April 08, 2002
Well, more spreadsheet hacking
Well, more spreadsheet hacking today, and all of a sudden it is a lot more depressing. Although I'm pretty sure I must be mistaken, on the morbid side, in some of my calculations. First for some reason it looks like ~30k in a year's expenses somehow works out to needing 69k in gross pre-tax freelance income. I mean, that just can't be right. But an online calculator said so. I've got to be double-counting somewhere.But regardless, I plugged the values in to my spreadsheet and found a couple more indicators. Like I found out that at my current average rate, I'll have to average 41 hours a week from here on out to meet my expenses. Or that at my current average hours per week, I should be charging a rate about double what I'm charging now. And I also figure what my rate should be if I average 30 hrs from here on out, which seems more reasonable... but I won't be at 30 hrs average for a while.
And I'm pretty close to finding my magic number - my magic "desired average rate" number, that needs to go DOWN for me to feel encouraged - and last week, my ultra-busy week, that magic number only went down by twenty cents!