Friday, August 22, 2008

When in doubt - Use Excel

Have spent the morning analyzing the effects of the sales team giving away things on my project for free - again! At lunch time we agreed it was just a small disaster for my department, but not for the company as a whole, so they got OK. I however had to analyze the changes to explain the difference between my expected baseline and the newly proposed one. After several hours of trying to understand the extent and reasons for the changes and get the figures to tie up, I made a brand new Excel spreadsheet to analyze how things were linked. It did not tie up (I was not as stupid as I thought) so asked a work mate to help finding the variance. It turned out there was a mistake in a previous spreadsheet that had not been spotted. This lowered my margin even more. At least now, all figures tie up - and I can spend the weekend working on explanations.

But not tonight - need a few hours off. Martin is buying and cooking something exciting for dinner.

No comments: