Posted by tribeofa | Posted in Admin Life, MS Excel | | Posted on 26-02-2011
I recently solved a problem that had been plaguing me for months. I inherited an email schedule that had been created for a client, laid out like this:
Week 1 Week 2 Week 3
Tier1 Name 1 Tier1 Name 2 Tier1 Name 3
Tier2 Name 1 Tier2 Name 2 Tier2 Name 3
Tier3 Name 1 Tier 3 Name 2 Tier 3 Name 3
Looks like one of those puzzles in the Sunday Times, doesn’t it? Here’s the thing: Tier 1 folks got contacted every 2 months. Tier 2 every 4 and Tier 3 every 6. So here’s this beautiful schedule, which, when it comes to the end of the names, repeats. Well, it didn’t take me too long, as measured by average ape mentation rates, to figure out that when we repeated the first tier 1 contact it wasn’t going to be time yet to contact the Tiers 2 and 3 people listed for the same week. What’s really embarrassing is how long it took me to solve it. When I’m embarrassed, I try to advertise how stupid I am so everyone else can be embarrassed for me. I think it’s a well thought out psychological strategy. But seriously, this problem had clearly also happened to the person who preceded me, and something similar may have happened to you.
I searched the web for templates or solutions. I consulted Excel experts and tried out their arcane and extremely labor intensive formulas. I squinted and scribbled and searched for different software. I cursed.
Sometimes you just need to look at data in a different direction. If you can’t make a spreadsheet work horizontally, try it vertically. Everything may look different to you. If you want to see my—really very simple—solution to this particular little hell, the details are on this page. If you’re struggling with one of your own, try turning your monitor sideways.Share on Facebook