Our website would like to use cookies to store information on your computer. You may delete and block all cookies from this site, but parts of the site will not work as a result. Find out more about how we use cookies.
Renew-Reuse-Recycle
22nd Nov 2019 Login  
Question on the Google Spreadsheet
by Tony Smith at 2010-09-16 09:03:59 (Forum::Public::Wind)
Are the blanks missing data, or zero production.
Hi,

I was having a look at the Google spreadsheet to see how real world production compares to manufacturer's figures. My idea was to look at the total for each, divide by the number of months and convert to annual.

Where months are marked as blank, does that mean zero production, or is that missing data?

Thanks.
--
aesmith

Mail this to a friend
Question on the Google Spreadsheet Tony Smith - 2010-09-16 09:03:59
Re: Question on the Google Spreadsheet Website Administrator - 2010-09-16 12:07:35
Hi,

Where the spreadsheet has empty cells for a particular month, it means "no data" - ie the owner of that turbine didn't fill in a figure for that month. The reasons aren't given, so it may be 'no production' or just 'forgot to fill it in'.

It'll be interesting to see your results - can you do a write-up and post it here?

Cheers
Simon
--
Website Administrator

Re: Question on the Google Spreadsheet Tony Smith - 2010-09-16 13:28:15
Thanks. It's not a very sophisticated analysis, I just wanted to see how real-world production compared to the some of the manufacturer's estimates.

I'll attach a screenshot showing what I've come up with. It would be quite easy to add these fields into the master spreadsheet. Hopefully the columns are self-explanatory

--
aesmith

Attachments...
JPEG image (1Mb limit) Summarised Production Snapshot
Re: Question on the Google Spreadsheet Website Administrator - 2010-09-16 15:13:48
Very interesting - so for a 6KW turbine you might expect 6 x 24 x 365 = 52560 kWh in a year if the wind blew constantly but in fact you'll get anything from 5% to 48% of that.

Cheers
Simon
--
Website Administrator

Re: Question on the Google Spreadsheet Tony Smith - 2010-09-16 15:44:55
Yes that's exactly what I was wanting to see. Typically I've seen that large-scale developers budget to get 30%, and the Ofgen figures show that they generally achieve that, more or less.

Ofgen doesn't publish figures for small scale installs.

Of course the large machines are higher so will be in stronger wind more of the time.
--
aesmith

Re: Question on the Google Spreadsheet Tony Smith - 2010-09-16 15:50:30
Just checked for our site on Proven's online estimator, and they reckon we should get between 15,000 and 17,000 from a 6kW. The spreadsheet figures show that apart from Orkney it looks like real production is more like half or a quarter of their estimate.
--
aesmith
Re: Question on the Google Spreadsheet Stuart - 2010-09-17 11:48:34
This has prompted me to update a few more months of data this weekend.

--
Stuart

Re: Question on the Google Spreadsheet David Hobbs - 2010-09-19 22:12:17
Yes,

My own figures for a Proven 6 have been between 6,000 and 8,000 KWh for each of the three years mine has been in operation. We are on a fairly good site in a modestly windy area (DTI 5.0/5.7 at 10m, 25m) and our turbine is on a 15m mast.

--
dch_control

If you'd like to post comments on this site, just register here

Powered by Novacaster