"Over_used/Over_spent"(Losses) and "Under_used/Under_spent"(Savings) _ on a monthly basis based on data entered, the program also automatically plotted charts showing trends over a 12 month period.

I am keen to encourage individuals and organisations to explore using advanced MS Excel formulas and functions, in conjunction with Excel VBA programming, to develop customised spreadsheet applications that will solve typical problems end_users encounter daily in trying to record/analyse data and generate reports.

A DIFFERENT Type Of Automation. The approach to spreadsheet automation that I refer to, is one that seeks to provide functional spreadsheet automation alternatives for ANY spreadsheet user task(s). Typically, solutions like this would require the developer to study existing manual data recording, analysis and report generation systems, then plan _ in consultation with users _ for incorporation of automation into the spreadsheet to replace them, where possible.

One Possible Application: Plotting a pie chart based on income contributions from all your products and services(daily, weekly or monthly), and reviewing the automatically computed percentages/visual pie slices, can give very illuminating insight.

google spreadsheet calculate date difference

google spreadsheet calculate total

google spreadsheet calculate elapsed time

google spreadsheet calculate average

google spreadsheet calculate time difference

**excel budget templates**

google spreadsheet calculate percentage

google spreadsheet calculate hours

*uses of spreadsheet*

google spreadsheet calculated field

google spreadsheet calculate moving average

__examples of spreadsheet packages__