Stoaty said:
The XSLX spreadsheet on the Wiki has now been updated so that the dropdown for cities works. Many thanks to RegGuheert!!!
You are welcome! Thanks for making this available!
I will add that this new XLSX file has also been made fully compatible with
Google Drive. This might be useful for anyone who does not have either OpenOffice or Excel or who simply would prefer to use
Google Drive. You can simply download the XLSX file and upload it to your Google Drive. It imports as a fully functional spreadsheet with all of the features found in OpenOffice or Excel. That is true if you view it from a browser, at least. When you view it from the iPad Google Drive App, it works, but some of the spreadsheet features are limited.
I have also created a live version of Stoaty's spreadsheet that anyone can use simply by clicking
this link. This version is also full-featured, but it is slightly different from the other spreadsheets in that it has an additional tab labeled Input. This new tab is the ONLY part of the spreadsheet which you can modify (I hope!). This was done to protect the spreadsheet from any accidental damage by those with access to it. The inputs all now have error checking and hints to help users know what to input. The prediction tab is identical to the one found in the other spreadsheets except that the input fields are no longer live, but rather only display the values that are currently found on the input tab. This is helpful to prevent you from having to flip back and forth to see what you have entered, but it should also warn you if someone else is changing the inputs as you are trying to view your predictions!
Please give it a try and let me know if you find any problems.
Thanks again to Stoaty for putting this together!
P.S. You do NOT have to sign into your Google Account in order to use the link. If Google asks you to sign in or you are already signed in, you can simply sign out and then access the link again.