Please enable JavaScript.
Coggle requires JavaScript to display documents.
Westwood car hire - Coggle Diagram
Westwood car hire
Pages
Customer details
Stores data on the customers like phone number and license as well as their cost without a discount
Income
The total income from all the people who hired a car as well as the months intake
Home page
Allows for different pages to be accessed from this page as well as to get back to this page
Comparison page
Compares the different prices from the original, discounter and £5 increase
Fees
stores any extra prices per hire
What functions to use
IF statement
Count IF
Drop down boxes / data validations
Charts
Hyperlink
Things to protect
Formulas so that they don't get deleted
Password so there's no unauthorised access
Cells that cant be modified
design
Same font as logo
Same colour scheme as logo
Logo in each corner of the spreadsheet at the top
Brand name in the middle at the top of home page
Page name in middle on the top of each page in between the logos
Easy to use home page and navigation system
Charts suitable to each topic that one would be needed for