hey that third one is purty 
I think its what i was looking to do..... looks right anyway.
the max lvl row up top was just a reminder really... wasnt going to be a part of the final sheet, and the lines do ineed look better.
i just couldnt find the right colours to go with what I had for the background.
I like the way it looks so i'll leave it that way.
the peranent column, isnt quite hidden, if i print this out, its there, just without borders.
also, that does achieve the goal i had in mind, but not the way i wanted to do it (if even possible)
as you can see from the other values, it will do the calculations all the way down every row, simply by me entering the information in. with the GH and KH it will do that until the 0's stop... at which point i have to add a bunch of other formulas to go further down the sheet.
That may not even be a problem, since the way its setup it would only be one sheet per month...... so I would only need a finite number of formulas.
btw thanks for the help.... id otherwise be totally stuck at this point... and without pretty line charts with good colours
I think its what i was looking to do..... looks right anyway.
the max lvl row up top was just a reminder really... wasnt going to be a part of the final sheet, and the lines do ineed look better.
i just couldnt find the right colours to go with what I had for the background.
I like the way it looks so i'll leave it that way.
the peranent column, isnt quite hidden, if i print this out, its there, just without borders.
also, that does achieve the goal i had in mind, but not the way i wanted to do it (if even possible)
as you can see from the other values, it will do the calculations all the way down every row, simply by me entering the information in. with the GH and KH it will do that until the 0's stop... at which point i have to add a bunch of other formulas to go further down the sheet.
That may not even be a problem, since the way its setup it would only be one sheet per month...... so I would only need a finite number of formulas.
btw thanks for the help.... id otherwise be totally stuck at this point... and without pretty line charts with good colours
