Lessons from March Madness

A closer look at March Madness

It’s the Night before Madness and I still haven’t finished my bracket—or my wife’s. Last minute, as always. While sitting here at a restaurant waiting for my wife and kids to show up for our weekly family dinner, I’m watching a little ESPN, hoping to gain one or two more morsels of information that’ll help me figure out which 5-Seed is going to get upset this year in the first round. (Right now, I’m leaning towards West Virginia, who plays Clemson, by the way.)

For some reason, though, I can’t get out of my head the turmoil and heated discussion that took place Monday morning immediately following the announcement of the 68 teams that now make up the NCAA National Championship Tournament. It was 64 teams. Then, a year or two ago, they expanded the field to 65, with a “play-in” game that saw the winner getting the unenviable gift of a first round matchup against the Overall #1 Seed, so named as the best team in the field according to the selection committee. And this year it’s 68 damn teams. Too many if you ask me, but that’s a topic for another day. For those of you not at all interested in basketball or sports, bear with me; I’m getting to the part about the lessons learned from this always exciting and chaotic tournament in just a moment. Read more of this post

5 x 5 in 25

When it comes to working out, last week was one of the worst I’ve had in a long, long while.  You see, since 1990, my first year in college, I’ve had this 3-Day Rule.  Simply put, I forbade myself from ever taking more than three days off from working out.  And except for maybe three or four times, I’ve made good on that promise.  No matter what– birthday, illness, holidays, even on my honeymoon as my wife would attest– when and if that fourth day hit, I made sure I did something.  Whether it was going for a quick run, doing some push-ups and sprints in the driveway, or going to the grocery store to buy gallon milk containers to use as makeshift dumbbells, I made sure I got my workout in.

Fast forward–um– a few years and I’m proud to admit that, even though I seldom break that pact with myself, I’m much less restrictive now, forgiving myself for the occasional lapse.  Even then, though, I make sure the workouts that I am able to get in make up for the ones I missed. Read more of this post

Floor and Ceiling Functions

While the ROUNDUP (round up to the nearest number, specifying the number of digits), ROUNDDOWN (round down to the nearest number, specifying the number of digits), and ROUND (round to nearest number up or down, specifying the number of digits) are very helpful, sometimes you wish to round up or down to a specific multiple.  Maybe you are dealing with large numbers and want to deal work only with multiples of 1,000 or 10,000.  Or maybe you’re building a graph or chart and want to minimize the scale.  The best way to do that, you decide, is to make the base (lower bound value) lower than, but as close to, the lowest number as possible.

No matter the reason, performing this is easy.  For each of them, you only need the number you are rounding and the multiple you’d like to round (up or down) to.  Examples follow:

Value: A1=1,798

Floor(A1,5)=1,795
Floor(A1,10)=1,790
Floor(A1,25)=1,775
Floor(A1,100)=1,700
Floor(A1,1,000)=1,000
Floor(A1,1,500)=1,500
Floor(A1,2,000)=0

Ceiling(A1,5)=1,800
Ceiling(A1,10)=1,800
Ceiling(A1,25)=1,800
Ceiling(A1,100)=1,800
Ceiling(A1,1,000)=2,000
Ceiling(A1,1,500)=3,000
Floor(A1,2,000)=0

As always, if you have questions, drop me a line or post a comment.

21 Days

Last summer, my brother, my sister, and I, with our respective families in tow, converged on my father’s house for a week of rest and relaxation in sunny California. It was a much anticipated—and needed—family reunion. I hadn’t seen my sister, who lives in Indiana, in a couple of years. It had been even longer since I’d seen my brother, who resides in Washington. And we hadn’t all been together since my wedding almost a decade earlier. The week was nothing less than amazing. We ate. We drank. We laughed. Our kids got to spend quality time with their cousins, splashing in the pool and playing video games. And at moments, it felt like our mother, who passed away in 1998, was overseeing the whole event, still the loving matriarch of a closely knit family, bound together by affection, respect, and enough disagreements, arguments, and spats to rival any family.

But as anyone over the age of thirty with brothers or sisters can attest, spending time with your siblings as adults is surreal. At the most odd of moments, images of your childhood almost hijack your consciousness. You remember specific moments as children, both good and bad. You literally see your brothers and sisters—as they were years ago— in the eyes and actions of their children. (“She looks just like you” and “he acts like his daddy” were two of many refrains echoed over and over throughout the week.) And you wonder where all the time went. If you’re not careful, you’ll even find yourself holding back a tear or two. It’s okay— normal and healthy, even— to let those tears flow, but I’ll get to that in a later post. Read more of this post

YOY Comparison for Most Recent Days

Comparing Same Day Sales YOY

In my last post, Showing Activity for Most Recent Days, I showed you how to find the most recent date for which you have “totals” data.  We found that whether it’s support calls or sales made each day, being able to retrieve this information quickly and efficiently can be extremely helpful.   By using the ROUNDDOWN AND MAX functions, as well as the very powerful SUMPRODUCT,  we were able to create a quick summary of the most recent days’ activity. The obvious next question?  How do those days compare with the same time last year.  In other words, using the most recent data, how are things going compared to last year?

We already have the first several pieces of the puzzle, the current year’s sales information.  To compare the data to last year, we simply find the totals for the same dates in the previous year.  We can determine these dates these dates fairly easy by using the CONCATENATE formula, along with the popular and well known MONTH and YEAR formulas. Read more of this post