It seems I have my first bug report when it comes to my budgeting spreadsheet. Anyone not interested in the details can just go grab the latest version from DIYPlanner's financial section. If you want the gory details about spreadsheets behaving badly, read on.
Something that worked 100% fine in Numbers didn't work well at all in other spreadsheets. You could have a table called "Income" with a column called "Planned" and another called "Actual" and have a row with the totals of the columns. The total would look like =sum(Planned) or =sum(Actual). I tried to do this kind of set up in Excel and OpenOffice/NeoOffice and it seemed to work fine, so I copied the one month of budget I did 11 times to make for one year of budgeting worksheets.
It turns out in most spreadsheets, besides numbers, you can only have one batch of cells assigned a name - for the whole spreadsheet. So when I had =sum(Planned_Income) in January, February, March, etc. it was all reading from the Planned_Income cells in one month- January in this case. So I had to go in and assign the "Jan_Planned_Income", "Feb_Planned_Income", etc names to all the named cells and then adjust the formulas to use the new names. What a pain in the neck!
Showing posts with label spreadsheet. Show all posts
Showing posts with label spreadsheet. Show all posts
Monday, December 31, 2007
Monday, July 23, 2007
emergency crash mode budget
Here we go again... I am once more in the land of the job hunters. It is a bit different this time. I saw it coming and saved up some cash. This would be the first time I've had more than a 5 second warning that employment problems were coming.
My current routine for the day: in the morning I apply for at least two jobs, clean a bit, eat lunch and then exercise. In the afternoon, I do some reading and work on some ideas that could earn some extra cash. Right now it is more working on coming up with ideas than actually doing them.
There's a neighborhood garage sale coming up in mid-August. We'll see how much junk we can sell.
I'm planning on using Dave Ramsey's Irregular Income Planning form available here to budget until I get another steady job. I'll have a spreadsheet version of that form up at the beginning of August, if not sooner.
My current routine for the day: in the morning I apply for at least two jobs, clean a bit, eat lunch and then exercise. In the afternoon, I do some reading and work on some ideas that could earn some extra cash. Right now it is more working on coming up with ideas than actually doing them.
There's a neighborhood garage sale coming up in mid-August. We'll see how much junk we can sell.
I'm planning on using Dave Ramsey's Irregular Income Planning form available here to budget until I get another steady job. I'll have a spreadsheet version of that form up at the beginning of August, if not sooner.
Subscribe to:
Posts (Atom)