Rather than having to go through the pain and suffering of learning a new technology and having to experience trial and error development, the best route would be to acquire the services of a consultant, who can identify your needs and create a customised solution. Obviously, the cost of such a project would depend on the size and complexity of the spreadsheet and your requirements. However, you might be surprised at how cost-effective this project would be.
A popular category of ready-made spreadsheets mentioned earlier, is 'Spreadsheets for Actors'. 'Spreadsheets for Actors' includes sets of programmed spreadsheets that are especially designed for professionals in the entertainment industry, from Actors to Producers. The spreadsheets under 'Spreadsheets for Actors' range from facilitating the managing of budgets to keeping track of income emerging from many sources.
You may also want to track your current spending on one sheet with columns for different categories. Some individuals will list the budgeted amount in one column and then list the actual amount spent in the column next to it.
Protection of formulae : How often have you forgotten to protect the cell contains the formula that took you hours to test and perfect. It takes one instance of honest human error, and that formula is gone.
types of spreadsheet
excel budget templates