Bottom post. David Berg wrote:
I'm trying to come up with a solution to a budgeting spreadsheet I'm trying to create. What I is a solution that will take as arguments a fixed amount that is the planned budgeted amount and actual spending data for each month then generate how much of the budget amount hasn't been spent to date (end of current month). What I have so far is this: Budgeted | Aug Actual | Aug Difference | Sept Actual | Sept Diff | etc where the Difference fields are Budgeted - Actual (for expense categories anyway). The solution I was thinking of would be to selectively add difference fields. Example: Its August, so add Jan Diff, Feb Diff, Mar Diff, ... Aug Diff. That way I can fix the Difference fields and change budgeting info without throwing off what has actually accrued. Does anyone have any ideas? As a side question, does anyone know of a source where you can download/upload spreadsheet templates?
DavidHere is a simple spreadsheet based on your statements. Have I interpreted your needs correctly? In both OOo format and .xls formats. You can, of course, see the formula by clicking in any cell.
I don't know of any source of templates other than what comes with the program, although I am sure that these exist.
Adam
budget_spreadsheet.ods
Description: application/vnd.oasis.opendocument.spreadsheet
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
