Loading spreadsheet…
Opening in Numbers for Mac...
Your browser isn’t fully supported.
For the best Numbers for iCloud experience, use a supported browser.
Learn More
Cancel
Continue
Standing Values
Rate per Day
US$20.00
Weeks in Month
4
Minimum Charge per Month
US$45.00
(1 Day per week 1/2 Days)
Disc Rate
No Days Per Week
Monthly Charge
1
US$80.00
2
US$140.00
3
US$200.00
4
US$260.00
Std Rate
No Days Per Week
Monthly Charge
1
US$80.00
2
US$160.00
3
US$240.00
4
US$320.00
Days Per Wee
Full / Half
Standard Tuition Per Month
Discount Tuition Per Month
1
Full Day
US$80.00
US$80.00
2
Full Day
US$160.00
US$140.00
3
Full Day
US$240.00
US$200.00
4
Full Day
US$320.00
US$260.00
1
Half Day
US$45.00
US$45.00
2
Half Day
US$80.00
US$70.00
3
Half Day
US$120.00
US$100.00
4
Half Day
US$160.00
US$130.00
Free Days
No Days Per Week
Free Days Per Month
1
0
2
1
3
2
4
3
Standing Values Table allows you to update your rates, without changing any formula.
Free Days Table allows you to defi ne how many free
days you want to give for the discounted rate, used in
the vLookup calculation for the Disc Rate table. Table
allows you to change the number of free days without
changing any formula.
Std Rate Table simply multiplies the Weeks in the Month ($B$2) by the Rate per Day ($B$1) in the Standing
Values Table
Similar to the table above, however uses Vlookup to lookup the number of free days in the Free Days Table
based on the values in No Days per Week (Col A) to reduce the monthly cost calculation the number of free days
in a month in the Discounted rate Calculation.
Uses an IF statement to check if the value in Col B is “Full Day”, if it is then it will use the full value of the Std
Rate Table, if not then it will take the higher of ( using the MAX formula ) the Minimum Monthly cost or half the
std rate for the 1/2 day costs of the Std Rates. I did it this was as it looks like for 1 day per Month you are using a
minimum rate of $45 per month , rather than half that would be $40 as per the normal calculation.
Cell format set to pop up style to avoid risk of typo’s
