Eirman
asked on
Improve On Spreadsheet Design
The attached spreadsheet works just fine. It's very easy to use and many people I've given it to, have found it very useful.
However, the four levels of one/zero logic that I used, seem clumsy and rather inelegant .... I couldn't think any other way of doing it.
My Question .... How would you have done it!
The sheet is ready to go with sample data. It has real life annual, monthly, bi-monthly, quarterly and 10/12 monthly payments.
Just click on a month and the total to be paid for that month will be displayed.
(Best viewed on a good sized wide screen monitor)
To enter new payments, go to the red text area and enter the amount, the day of the month and a 1 for each payment month.
BUDGET-3.xls
However, the four levels of one/zero logic that I used, seem clumsy and rather inelegant .... I couldn't think any other way of doing it.
My Question .... How would you have done it!
The sheet is ready to go with sample data. It has real life annual, monthly, bi-monthly, quarterly and 10/12 monthly payments.
Just click on a month and the total to be paid for that month will be displayed.
(Best viewed on a good sized wide screen monitor)
To enter new payments, go to the red text area and enter the amount, the day of the month and a 1 for each payment month.
BUDGET-3.xls
ASKER
You ONLY enter data in the red area.
The 1s in the two brown areas and the black area are formula derived .. one area is calculated from the other
The 1s in the two brown areas and the black area are formula derived .. one area is calculated from the other
yes got it then what is the gey line between each item the row I mean just to diffrenciate items or you will use it in the future?
ASKER
> then what is the gey line between each item
Just to make it easier to read
Just to make it easier to read
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Your solution is definitely much more elegant than mine reitzen
gowflow, Believe it or not, at one point I was using the grey area to enter data ... I had a hide/unhide button etc .... I might go back to that
01:15 here ... i'm off to bed
gowflow, Believe it or not, at one point I was using the grey area to enter data ... I had a hide/unhide button etc .... I might go back to that
01:15 here ... i'm off to bed
ASKER
Thanks everyone
then my first impression u say its clumzy ... but sometimes simple things are the most efficient. I will give you my final comments when I understand the whole thing
gowflow