{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Water Calculator","Sheet2","ref"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Water Calculator","index":0,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,7],[34,1,34,3],[30,5,30,6],[31,5,31,6],[32,5,32,6],[29,1,29,3],[29,5,29,6],[29,0,33,0],[8,1,8,4],[9,1,9,4],[10,1,10,4],[15,0,16,2],[12,0,13,0],[5,0,5,7],[4,0,4,7],[30,1,30,3],[3,0,3,7],[2,0,2,7],[1,0,1,7],[39,1,39,4],[36,0,36,3],[7,1,7,4],[27,1,27,3],[33,1,33,3],[33,5,33,6],[36,5,36,7],[31,1,31,3],[32,1,32,3],[18,2,18,5]]}
["WELO\nWater Budget and Water Use Calculator"]
["INSTRUCTIONS:"]
["1. Enable macros. "]
["2. Enter values in blue cells. Gray cells will automatically fill."]
["3. For Eto, refer to Appendix A of the ordinance, available here:  https://www.water.ca.gov/Programs/Water-Use-And-Efficiency/Urban-Water-Use-Efficiency "]
["4. Print this sheet and submit with Landscape Document Package for the Comprehensive Performance Compliance Pathway."]
[]
["Date:"]
["Project Name:"]
["Project Contact:"]
["Project Contact Email:"]
[]
["Maximum Applied \nWater Allowance\n(MAWA)","Project \nType","ETo","ETAF","Special Landscape Area \n(SLA)","Total Landscape Area \nincluding SLA","MAWA\n(gal/yr)"]
[null,null,null,{"$f":"IF(B14=\"Non-residential\",0.45,IF(B14=\"Residential\",0.55,IF(B14=\"\",\"\",\"\")))","v":""},{"$f":"E35","v":0},null,{"$f":"0.62*C14*((F14*(IF(B14=\"Non-residential\",0.45,0.55))+(E14*(IF(B14=\"Non-residential\",0.55,0.45)))))","v":0},"MAWA =(ETo) * (0.62) *[(ETAF*LA) + ((1-ETAF) * SLA)]. "]
[]
["Estimated Total Water Use\n(ETWU)",null,null,"ETo","(SF * PF) / IE","SLA","ETWU\n(gal/yr)"]
[null,null,null,{"$f":"C14","v":0},{"$f":"H28","v":0},{"$f":"E14","v":0},{"$f":"D17*0.62*(E17+F17)","v":0},"ETWU =(ETo) * (0.62) *[(PF*SF/IE) + SLA]"]
[]
[null,null,"Difference between MAWA and ETWU",null,null,null,{"$f":"SUM(G14-G17)","v":0},{"$f":"IF(G17<=G14,\"Project meets water budget.\",\"Project does not meet water budget.\")","v":"Project meets water budget."}]
[]
[]
[]
["ETWU Calculation\n(Regular landscape areas)","Zone #","Description","Select \nIrrigation","Square Feet\n(SF)","Plant Factor\n (PF)","Irrigation Efficiency (IE)","(SF * PF) / IE"]
[null,1,null,null,null,null,{"$f":"IF(D24=\"Drip\",0.81,IF(D24=\"Bubbler\",0.81,IF(D24=\"Spray\",0.75,IF(D24=\"Water Feature or Pool\",1,IF(D24=\"\",\"\",\"\")))))","v":""},{"$f":"IF(ISERROR(E24*F24/G24),\"-\",E24*F24/G24)","v":"-"}]
[null,2,null,null,null,null,{"$f":"IF(D25=\"Drip\",0.81,IF(D25=\"Bubbler\",0.81,IF(D25=\"Spray\",0.75,IF(D25=\"Water Feature or Pool\",1,IF(D25=\"\",\"\",\"\")))))","v":""},{"$f":"IF(ISERROR(E25*F25/G25),\"-\",E25*F25/G25)","v":"-"}]
[null,3,null,null,null,null,"","-"]
[null,4,null,null,null,null,"","-"]
[null,"Landscape area (not including SLA)",null,null,{"$f":"SUM(E24:OFFSET(E28,-1,0))","v":0},null,null,{"$f":"SUM(H24:OFFSET(H28,-1,0))","v":0}]
[]
["ETWU Calculation\nSpecial Landscape Areas\n(SLA)","Description",null,null,"Square Feet\n(SF)","Plant Factor / Irrigation Efficiency (PF/IE)",null,"(SF * PF) / IE"]
[null,"Edible planting area",null,null,null,1,null,{"$f":"E31*F31","v":0}]
[null,"Multi-use and sports field turf area",null,null,null,1,null,{"$f":"E32*F32","v":0}]
[null,"Area irrigated with recycled water",null,null,null,1,null,0]
[null,"Pool",null,null,null,1,null,0]
[null,"Total SLA",null,null,{"$f":"SUM(E31:E34)","v":0},null,null,{"$f":"SUM(H31:H33)","v":0}]
[]
["Total Landscape Area (including SLA) from ETWU Calculation",null,null,null,{"$f":"E28+E35","v":0},{"$f":"IF(E37=F14,\"\",\"Error: Value does not match Total Landscape Area in MAWA calculation.\")","v":""}]

{"sheet":"Sheet2","index":1,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[]
["Spray"]
["Drip"]
["Bubbler"]
["Water Feature or Pool"]

{"sheet":"ref","index":2,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Select one:"]
[]
["Residential"]
["Non-residential"]
[]
["- Select -"]
["Drip"]
["Spray"]