On-screen User Documentation

The on-screen user documentation will help assist you in using the Holistic Health Spreadsheet

Navigational PageCustomer Info and Fee PerimetersQuote Page Business Performance Page, Performance Graphs

 

Text Box: Go back to the navigational home page
Navigational Page

 

The Navigational page is your easy guide through the spreadsheet, just click on the relevant hyperlink to access your desired page

 

Text Box: Click on your desired hyperlink to access the page

 

Customer Info and Fee perimeters

These are two pages that contain the information that are used in co-ordination with the spreadsheet.

 

 

 

 

 

 

 

Quote Page

In the columns shaded in grey information does not need to be entered into them as they will automatically be formed by their various formula's only enter data into the columns that are white. Also when entering data into Gym membership, Health Check and Payment method, make sure you do not add a space after the letter as the formula will then be unable to recognize it.

 

Text Box: Changes to text and payment rates can be made in these two pages

Business Performance Page

The Business Performance page shows the Business Performances'

Text Box: Where ever the is a column that displays the average, when new data is being entered into the quote page, you will need to re-calculate the average by simply clicking on the cell, then click on the fx button and then finally in the section in number 1 increase the range to the last entry of the quote. This is because if you select the whole column of cells it will include the values of 0 an produce an incorrect value

                                                                                            

 

Performance graphs

Data does not need to be entered into any of these relevant columns as the formula will automatically account for new data, and the graphs will also account for the new data