[Stoves] RE Error in the recommended Shell FoundationHEH Project WaterBoiling Testhttp://ehs.sph.berkeley.edu/hem/hem/protocols/WBT_data-calculation_sheet.xls

[Crispin Pemberton-Pigott]

Dear Damon

Thanks for the additional info and the links.

I downloaded WBT_data-calculation_sheet_3.0.xls from the site
http://ceihd.berkeley.edu/heh.stove_perf_eval.htm and the formula is indeed
corrected as discussed earlier.

The correction was made after the ETHOS conference so as a matter interest,
what happened to Rob's data when the correction was made?  Unless the field
tests used extremely dry wood, it will have made a significant difference to
the performance.

Perhaps it would be wise to put the password and protection back on the
sheet as well.

Thanks
Crispin

-----Original Message-----
From: OGLE-D/M [mailto:monogle at oregoncoast.com] 
Sent: September 18, 2007 7:14 PM
To: crispin at newdawn.sz; Discussion of biomass cooking stoves
Subject: Re: [Stoves] RE Error in the recommended Shell FoundationHEH
Project WaterBoiling
Testhttp://ehs.sph.berkeley.edu/hem/hem/protocols/WBT_data-calculation_sheet
.xls


Dear Crispin,
    As Rob and Nordica pointed out there was indeed an error in that
particular
cell of the WBT data calculation sheet.  The rest of the calculations do not
depend on the content of this cell.  We all missed the error originally as
the
error was small and the rest of the spreadsheet was unchanged.  The error
was
originally caught by Arne Jacobson of Humbolt State.  The correction was
made
some time ago.  I just checked the WBT data calculation sheet on the CEIHD
site
at Berkeley and it looks like they are using the corrected formula.  I
accessed
the spreadsheet at the current CEIHD site.
http://ceihd.berkeley.edu/heh.stove_perf_eval.htm
This is slightly different from the address you cited.
    Thanks for taking the time to look through the spreadsheet and express
concern.  This stuff is complicated and it helps to have another set of eyes
looking at these things.

    All the best,
    Damon