Please enable JavaScript.
Coggle requires JavaScript to display documents.
Westwood Swim Centre Planning - Coggle Diagram
Westwood Swim Centre Planning
Spreadsheet pages
Home
Charge/ Costs
Swimmers
Attendance/ Swim times
Charts
Tables
Income?
Discounts
10%
discount to swimmers who paid for a
block of 8 weeks
Costs of classes
C6
Block rate:
£60
Class rate:
£10
C7
Block rate:
£66
Class rate:
£11
C8
Block rate:
£72
Class rate:
£12
Calculations
The total number of weeks attended by each swimmer
The income generated from...
Swimmers who have made a
block
booking of 8 weeks
before
the discount is applied.
Swimmers who have made a
block
booking of 8 weeks
after
the discount is applied.
Swimmers who have attendedclasses but
not
made a block booking.
The total income received from
each swimming class
before discount
after discount
The total income received
per week
before discount
after discount
Which swimmers will receive a voucher
Functions
Charts
pie chart- which segment has made the business more money
scatter graph/ bar chart- swimmers fastest time
COUNTIF
The total number of weeks attended by each swimmer
MIN
fastest swim time
IF
which swimmers will receive a voucher to use at a local sports shop.