Well possibly not funny but just a comedy of errors. I mess with data for a living and I send out reports that MUST be accurate and I have years of experience completing these and doing them very accurately.
One series of these I am responsible for creating are reports for physical Inventories (Executive summary and store final reports) at stores that go to the highest levels of the company as well as being sent out to those stores that have the physical inventories. Its quite complex to create these, quite time consuming and its very important that they be accurate as the stores (and their Managers/regional Managers) get on the nice or naughty list due to these.
The current brand I was doing these for is the only brand that wants store results by Retail rather than just Stat cost. All that being said, I created the reports as I always do. I tied them out to the data I pulled out of SAP BI/BO and it all looked fine. I double checked them, then sent them to my boss who takes a quick look. All good.
Round 1
I sent them out and everything was fine except that the brand managers didn't like the retail numbers. I wont go into too many details but we use an average for that because our system didnt "hold" the data. After much handwringing it was decided to use another method...which we did. And to do so I had to refresh some data....well I refreshed the data, and tied out the totals but forgot that I didn't have my formulas turned on so they didn't update. But the totals tied out 100% so it didnt send up any flags. I sent them out.
Round 2
I got a call that evening that it was sent out to the stores and a store noticed that the data for their store was not accurate which snowballed into another and another. Of course I pulled up the original data and it was fine (of course it was, excel refreshes formulas when you save).
I fixed the data, made a new report, made apologies and sent it out again.
Round 3
Again they didnt like the Retail data. So they asked to retract and deep dive for a new way to get there. Which we discovered...... and we were so very proud that we figured out a way to get an accurate retail cost in the file. Well since we were deep diving, I happened to recheck something and realized when I pulled the BO data originally, the company database had not finished updating for monthly numbers and it was missing some data.
I fixed the issue, implemented the new retails but since the background data had been wrong, the Executive summary was not correct.
Round 4
Now I have to send out to the entire distribution list, the entire batch of reports for the 4th time. Keep in mind these go all over the world and to Senior VP's, VP's, etc etc etc..... They dont like getting multiple iterations of the same report.
Honestly, I have never felt so awful about a work situation in my entire career. I took it worse than my boss or the VP of our department who kept telling me to stop beating myself up about it.
All I can say is I am glad I got my bonus for last year already, and that I got an exceptional on last years review. I expect this one to be quite different. I can only hope that since this is so early in the year, they wont remember it in November when they start working on my yearly reviews. I wouldn't count on it.
