DESIGN NOTES:
1. Columns c and d can be deleted as long as columns H and P are calculated correctly by dividing by 30.
2. There should be 30 rows 1 for each Expense category, plus the header and footer row.
3. The Total for Row F is a combination of Totals from
Row N and Totals from Row F.
Overview: The Idea behind this is that the user inputs Monthly Living Expenses, and Dream Lifestyle Expenses, as well as Monthly Income Streams.
Monthly income streams from both sides (BLUE and YELLOW) will effect monthly living expenses first (lowest dollar amount to highest), and then Dream Lifestyle Living Expenses (lowest dollar amount to highest).
Both the yellow and Blue Income streams will go FIRST toward meeting, and then exceeding the Yellow monthly Living Expenses side.
After the monthly living expenses side (yellow side) has been covered and exceeded by a combination of both or either of the Yellow or Blue income streams, then the income streams totals will be directed to the Blue Side Dream Lifestyle expenses.
If the income streams cover a expense (starting at the lowest dollar amount Living Expense monthly Yellow side), then the category field in column B would turn GREEN).
If the category is reached by the income streams, but not quite covered, then the field category would turn (YELLOW).
If the category is not even hit by the income streams, then the field category would turn (RED).
Once the user inputs the Living Expense Text Column and monthly Dollar amount, as well as the Dream Lifestyle Text column and Dollar amount, the GREEN [Click Here To Crush Your Job!] button is clicked, and the function would calculate all the rows and columns.
The exact calculations would also apply to the Blue Side Dream Lifestyle, after the Yellow side Monthly living expenses have been met.
It would be nice if a sound or visual effect could be added ..like a cash register adding up, and or Flashing [GREEN BUTTON].
