I noticed the worksheet has some errors:
a) "Baseline Calculation" tab: the Watering Demand column is subtracting rainfall from ETo, instead of ETo being subtracted from rainfall
b) "Baseline Calculation" tab: Cells E22-E24 look incorrect - they are the minimum instead of the maximum
c) "Landscape Water Requirement" tab: Looks like the Average Monthly Rainfall for Peak Watering Month is referencing the lowest month
Is there someone to check the worksheet thoroughly and make corrections?
Edward Malesevich
Sustainability AdvisorTranswestern Sustainability Services
13 thumbs up
March 9, 2016 - 2:58 pm
Hi Stephanie,
I'll try to address your questions below:
a) Based on the most recent v4_Outdoor Water Use Reduction Calculator I downloaded from the resource page, the watering demand column appears to have the correct subtraction method. I see the ETo being subtracted from the rainfall to calculate the watering demand (D10 - C10 = E10).
http://www.usgbc.org/node/2601107?view=resources
b) I see in the spreadsheet formula that they are pulling a minimum, but it is pulling the data from some hidden columns that I can't see. I've entered in some examples from previous projects and it seems to pull the correct peak watering month based on the rainfall and ETo data.
c) Depending on if the formula for peak watering month in the "Baseline Calculation" tab is correct, this also appears to be correct once I enter in some sample data.
Let me know if this helps or if you have any other questions.