Renew-Reuse-Recycle | Question on the Google Spreadsheet

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

<< Proven 15KW into Single Phase ... Alternatives to Proven 15 >>

View Comments (Threaded Mode) Printer Version

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...
	Production Summary.JPG	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