Please enable JavaScript.
Coggle requires JavaScript to display documents.
WESTWOOD VILLAGE HALL :, This mind map contains specific details on how my…
WESTWOOD VILLAGE HALL :
FEATURES
BOOKING MANAGEMENT
-
-
-
I will do this by entering the data above into booking sheet and use data validation to restrict input. this will improve accuracy and prevent incorrect input
-
BOOKING TYPE
-
-
-
I will use drop down list data validation because it prevents typos and make data cleaner and easier to analyse
I will also use formulars to calculate the cost i will do this by multiplying all the cost together (=IF)
PAGES
EXTRA ITEAMS
This page will store extra item prices , by using lookup formulars
MAIN PAGE
I will do this by using hyperlinks or buttons to move between sheet which will all be on the home page
Navigation buttons, will be under the sheet and also on the home page
-
-
-
-
CALCULATION PAGE
This page will contain all the totals summaries, i will use countif.sum and sumif
-
BOOKIG PAGE
This page will store all the October booking, Rolls will have individual booking and Coolum's will have booking data
-
SECURITY FEATURES : :
-
-
SPREEDSHEET PROTECTION
Spreadsheet would be lock to prevent the deletion of data or the formular, I will do this by locking the formula cell this can be done by choosing the specific cell I want to lock, then highlight it, I will then select formatting cell then click the lock button I will go on review then click on protect then select all the list except select cell
-
This mind map contains specific details on how my spreadsheet will look and how it will be navigated, i have used different branches to explain the different function, features and pages my customer could use to navigate without any issues, I have also used different variety of colours for specific things example I used the colour pink to do my explanations I have also used capital letters for the main branch so the customer doesn't get confused