YOUR DATA HAS NOT BEEN SAVED

PLEASE COMPLETE THE WEEKLY DATA ENTRY FORM

Fill in all active cells with your values or ‘N/A’

‘N/A’ should be entered when you do not have a value

Click here for the difference between zero and ‘N/A’

If you consistently enter ‘N/A’ for a row please turn it off in your cellar door setup

ZERO AND ‘N/A’ ARE DIFFERENT

Zero should be entered when the value is actually zero

‘N/A’ should be entered when you do not have a value

For example: If you are open to trade and have no visitors then recording a zero is a legitimate value. Similarly, if you receive visitors and make no sales, zero is the appropriate figure to enter against sales.

However, if you leave a cell blank an ‘N/A’ will automatically be inserted. You would leave a cell blank if you chose to close on a regular trading day (i.e. Christmas Day) or products usually available were no longer available for sale. Therefore the correct reporting value is “Not Available” because there is no value to report.

This distinction is important because it affects the way the reports are aggregated and presented. An incorrect value will skew the data and cause anomalies affecting the integrity of the reports. For the technically inclined, each ‘N/A’ is counted as a non-participation value and will reduce the participation rate, but will not be included in calculating the statistical value returned. Zeros are reported as a participating value that will increase the participation rate and be included in calculating the statistical value returned.

It’s also important to note that if you do not enter a positive value in Visitors Count, you will not be able to enter values in any other related cells (because the system assumes you had no visitors to sell to.)

If you require further clarification please contact us.