Please enable JavaScript.
Coggle requires JavaScript to display documents.
Westwood Swim Centre - Coggle Diagram
Westwood Swim Centre
-
Tasks to do
- Count how many of the two classes appear ( class and block ) just like it was in the dog training sheet ( P B S G ) using the COUNTIF function. Highlight the top row of Swim class data and put the class/block in " "
- Find the income generated from each class/block by multiplying the cost of it to the amount of swimmers that are from that class
- Find which swimmer is eligible for the 10% discount ( who has paid for 8 weeks upfront ) by using the IF function to see if its got a BLOCK or CLASS. if it has BLOCK it means its eligible for a discount, formula will look like =IF(_"B",0.1,0).
- Find the total after the discount, to do this we will do the total before - IncomeDiscount, formula will look like this =-(_)
- Make macro buttons for each worksheet that fit with the colour theme of the logo using Insert and then Drawing. design the buttons using shapes, change text size and colours
-