Please enable JavaScript.
Coggle requires JavaScript to display documents.
Watford Leisure Centre - Coggle Diagram
Watford Leisure Centre
Players
Payment
Class
Block
Player ID
Player first name
player last name
Date of birth
Class
C7
C8
C9
Class Charge
Class
C7
C8
C9
Block Rate
Class Charge
Income
Income from each tennis class before and after 10% discount
Before the 10% discount
C7
=sum(C7-Income before discount)
C8
=sum(C8-Income before discount)
C9
=sum(C9-Income before discount)
After the 10% discount
C9
=sum(C9-Income before discount)*0.9
C8
=sum(C8-Income before discount)*0.9
C7
=sum(C7-Income before discount)*0.9
Total income per week before and after the 10% discount
Before the 10% discount
Week 1
=sum(countifs(range, "y", range, "class", range, "C7/C8/C9"))*repeat 2 more times
Week 2
=sum(countifs(range, "y", range, "class", range, "C7/C8/C9"))*repeat 2 more times
Week 3
=sum(countifs(range, "y", range, "class", range, "C7/C8/C9"))*repeat 2 more times
Week 4
=sum(countifs(range, "y", range, "class", range, "C7/C8/C9"))*repeat 2 more times
Week 5
=sum(countifs(range, "y", range, "class", range, "C7/C8/C9"))*repeat 2 more times
Week 6
=sum(countifs(range, "y", range, "class", range, "C7/C8/C9"))*repeat 2 more times
After the 10% discount
Week 1
=sum(countifs(range, "y", range, "class", range, "C7/C8/C9")
0.9)
repeat 2 more times
Week 2
=sum(countifs(range, "y", range, "class", range, "C7/C8/C9")
0.9)
repeat 2 more times
Week 3
=sum(countifs(range, "y", range, "class", range, "C7/C8/C9")
0.9)
repeat 2 more times
Week 4
=sum(countifs(range, "y", range, "class", range, "C7/C8/C9")
0.9)
repeat 2 more times
Week 5
=sum(countifs(range, "y", range, "class", range, "C7/C8/C9")
0.9)
repeat 2 more times
Week 6
=sum(countifs(range, "y", range, "class", range, "C7/C8/C9")
0.9)
repeat 2 more times
TennisClassData
Player ID
Total Number of Weeks - Y
Week 1
Week 2
Week 3
Week 4
Week 5
Week 6
Time
Week 7 time
Week 8 time
Week 9 time
Payment
Class
Block
Class
C7
C8
C9
Income
Before 10% discount
After 10% discount
Income from each player