So as promised, here is the link to the google docs spreadsheet which will hopefully serve as a good way in sharing our monthly production details.
Boards.ie - Solar Capacity and production analysis - Google Sheets
Some guidelines.
- Avoid putting in partial month data (unless it's the current one). What I mean is if your installation was setup July 17th, then leave July blank as your first month as it makes it difficult to compare across installations as they aren't like-for-like. One exception is that you can include what you have done so far in the current month, if you want to - as long as you update the month when it's complete with the final figure.
- The spreadsheet isn't "my" spreadsheet, or anyone elses. It's owned by the community and as such the success or failure will be the engagement that the community has with with it.
- If someone genuinely feels that there is something which could be improved, then don't be shy and feel free to improve things for the betterment of the community - but at the same time, be cognizant that not everyone may see things as you do. E.g. highlighting cells in your favorite florescent colors might not be to everyone's taste!
- There are a couple of "Spare Users" rows in there. These can be used by replacing "Spare user" with "<Your name>". If there are no "Spare Users" rows left, then we'll have to add a few rows. If you know how to do this in Excel, Google sheets is the same, so feel free. Don't forget the charts may need updating to include the data-source(s). If you are stuck and unsure what to do, I can do this or ECO_Mental if you want to PM one of us? Happy to help.
Aside: Just want to give a shout out also to ECO_Mental who was one of the main drivers of the charting and filtering in the spreadsheets. Sure, I setup the original spreadsheet and it might be my name posting this message now, but in reality a large proportion of the work here was done by him and that kudos should acknowledged.