Please enable JavaScript.
Coggle requires JavaScript to display documents.
Westwood village hall mindmap - Coggle Diagram
Westwood village hall mindmap
Page design
Elements
Many dots and soft circle elements
Many plants associating things
Colours
Light and dark green
Brown
A bit of the light blue
Design tools
Mindmap
Flowchart
Wireframe
Types of booking
Full day
Half day
Hourly
Formulas that will be use
=SUM
=VLOOKUP
=SUMIF
=COUNTIF
=FILTER
Data validation
Protect the sheet
Only "you" can edit this range; All pages protected
Drop down
On the "october booking page"; Extra items & rate
HCI
Big buttons
Main menu has buttons to all pages
All pages have buttons to main menu
Total counting
There is a separate page for this
The total number of booking made in october
The total number of booking made by each customer in October
The total number of bookings made for each type of booking
The total income generated from booking the hall in October
The total income generated of bookings made in October that included extra items
The total number of bookings made in October that included extra items
The total income generated for the month of October
The total income generated from each customer for the booking they have made in October
Charts
Bar chart
Total income generated from each customer
Pie chart
Extra items cost