Please enable JavaScript.
Coggle requires JavaScript to display documents.
Watford Leisure centre - Coggle Diagram
Watford Leisure centre
Dashboard
Pictures
Buttons
Class Charge
Players
Charts
Class charge
Tennis class date
formula
Logo
Dashboard button for each sheet (except for the dashboard itself)
Players
Payment type
"Class" or "Block"
Player ID
Players first and Last name
Players date of birth
Class type
"c7","c8","c9"
Income
format
diagram
bar chart
Before and after 10% discount
the amount of money made by each class
The amount after the 10% discounts
Formula
=sum(countifs('Tennis class data'!B:B,"y",'Tennis class data'!L:L,"Class",'Tennis class data'!M:M,"c7"))*Class_charge!
Total income
for each week
before and after the 10% discount
Class charge
Class or block rate
Payment
Class
c7,c8,c9
headlines in purple
Tennis class data
Player ID
Black Headline
attendance for each week
marked"Y" if present
weeks 1-9
formule
countif(X1:X9,"y")
Total number of weeks
Blue headline
Payment and class type
Green headline
Income generated per Player
=if(="Block",
Class_charge!,if(="Class",
Class_charge))
formula for after 10% discount
=if(and(="Block",=6),N3*(1-0.1),N3)
Total income formula
=K4*Class_charge!$C$2