All data needs to be entered on "Data" page only

To change the start date, type the new start date on the "Data" sheet in cell A4

Once a day (I do it in the morning), enter the forecast hi & low from Sim & NWS for the current day and the 3 following days in the correct cells
(For Sim, columns E-H and J-M for the NWS)

Once a day, enter the Actual hi & low recorded locally
NOTE: I created this for use with a personal weather station weather station and enter Actual values to 1 decimal - Be sure to see note (below) about the value zero in relation to the calculations

The data in each verification table is filtered such that, if difference between the forecast and actual is greater than 15 deg, "ND" will appear in the verification and will not be included in the error and standard deviation calculations.
This was done so the will remain accurate before the "Actual" is entered.

Additionally, both the Average Error and Stand Deviation calculations are set up to not include a zero value.  This would only create a problem if the temperature were exactly as forecast.  For this reason, it is helpful to enter actual temperatures to 1 decimal place.

Spreadsheet is set up to be used as is for 38 days; if you are not comfortable editing spreadsheets and would like assistance, just ask.  I'm sure I will be extending it for my own use anyway
weather@pdfamily.com