JointExpenditureAnalysis
This spreadsheet was created to help us work out our monthly outgoings - it is simple to use and modify to suit your own needs. Please feel free to download it and change the names of the people in the columns ( obviously ). There is some 'validation' performed on some of the enteries so that the values of the cells make sense to the spreadsheet calculator. The sheet is locked ( without a password ) - this restricts the user entering data where they shouldn't and can be removed ( if you require ) once you understand the structure of the spreadsheet.
( There aren't any macros in this spreadsheet, all the intelligence is on the sheet )
I have deleted most of the figures other than the cartax enteries - these show you how the values get put into the right the columns and get reflected in the final analysis.
If you want to download this then click on the link below this picture ...
|