In columns G,H, I you *appear* to "tier" the pricing for some days. But you
don't seem to do that in column F. So you need to clarify for me HOW you
apply your pricing tier.

Do you...
1) count the number of days and find the rate on the chart, then charge the
single rate to ALL the days in April
2) Charge .25 a day for the first 3 days, 1.01 per day for the next 30, 1.25
per day for the next 30, and finally 1.56 per day for all days after 60.
3) Charge to top TWO rates applicable to the row (this appears to be what
you may be doing.)

You can respond to me directly if you wish at:
jerry AT devstudios DOT com

(turn that into a normal email address)
--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"ibvalentine" wrote:

I just created a worksheet that is more complicated than it looks and I want
to make it available for anyone who would do my the favor of looking it over.

The difficulty of the worksheet is that you have to considered all possible
parameters, some of which may not be obvious. So, if you can see any possible
parameters that the formulas may not cover, please let me know. Also, I may
have overlooked some errors.

The objective of the worksheet is to calculate storage fees for April. The
difficult part is that items come in at different times and have different
levels of charges. There is a table in columns L and M that breaks the
charges down.

You can down load the Excel file by going to this page:
http://www.icellini.com/excel.html.

Thanks to anyone that takes a look!