Please enable JavaScript.
Coggle requires JavaScript to display documents.
WVH spreadsheet solution - Coggle Diagram
WVH
spreadsheet solution
FORMULAS
sum adds all the numeric values in a cell range
CountIF
CountA
Vlookup
OUTPUTS
Charts
total number of money made.
Invoices
date of invoice
customer ID
cost per booking
total cost
booking number and date of booking
CLIENT REQUIRMENTS
store details about who has booked the halll
follow WVH house/style branding by reflecting the logo
have an easy to use Human computer interface
HOMEPAGE
macros
WVH logo
house style
green beige blue
buttons
SECURITY
password WVH#26
VALIDATION
drop down menu
formating
currency
Payment Card Number