{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Read First - Introduction","1. Location","2. Water Supply","3. Rates","4. Site Level Data","5. Water End-Use Data","Output Form","output_calcs","config","clear_inputs","input_validation","Irrigation Zones","template","Help"],"not_rendered":{"charts":0,"images":20,"macros":1,"external_links":0,"defined_names":203,"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":"Read First - Introduction","index":0,"n_rows":57,"n_cols":16,"rows_kept":57,"cut":false,"hidden":false,"merged":[[0,1,0,27],[1,7,1,28],[2,26,2,27],[4,1,7,27],[9,1,10,27],[51,1,54,27],[56,9,57,13],[56,15,57,19],[50,26,50,27],[12,1,14,27],[39,1,44,27],[46,11,47,17],[26,1,27,27],[24,1,25,27],[18,1,22,27],[28,1,35,27],[36,1,38,27]]}
[" "]
[null,null,null,null,null,null,null,"WATER PROJECT SCREENING TOOL"]
[null,"Introduction"]
[]
[null,"The Federal Energy Management Program (FEMP) developed this water project screening tool to enable federal agencies to quickly screen sites for water efficiency opportunities. General information related to a site’s water use is entered into the tool in the input tabs and the tool provides qualitative recommendations on potential water efficiency projects."]
[]
[]
[]
[]
[null,"Before you start: if a gold banner appears at the top of the workbook, click the “Enable Content” button. This will allow the tool to function properly."]
[]
[]
[null,"Input forms. There are five forms that require inputs to generate results. White input fields are required, while input fields that are highlighted in yellow are optional. Most inputs are dropdown menus providing a preset list of possible answers, while others are open fields. "]
[]
[]
[]
[null,"Click the help icon",null,null,null,null,null,null,"at the top of each form for more information on inputs."]
[]
[null,"Begin by clicking the “Start” button at the bottom of this page. Enter information in form #1, then click the “Next” button at the bottom of the form when all inputs are complete. Repeat this step for forms #2 through #4. After completing form #5, click the “Submit” button to generate the output form. If any required fields are not completed, an error message will alert you to the missing input. Go back and enter the required information, then click the “Submit” button on form #5 again."]
[]
[]
[]
[]
[]
[null,"Output form. The tool generates two categories of outputs: 1) water saving potential, 2) cost effectiveness potential."]
[]
[null,"End-use specific water savings potential: The tool provides a qualitative estimate of water savings potential for nine equipment types."]
[]
[null,"1) Plumbing fixtures: toilets, urinals, showerheads, and faucets\n2) Irrigation systems\n3) Cooling towers\n4) Steam systems\n5) Single-pass cooling\n6) Laboratory and medical equipment\n7) Commercial kitchen equipment\n8) Vehicle wash\n9) Distribution leaks"]
[]
[]
[]
[]
[]
[]
[]
[null,"Each equipment type that is applicable to the site receives a score between one and four water drops, with one drop indicating a low water savings potential and four water drops indicating a high savings potential."]
[]
[]
[null,"Cost effectiveness potential: The tool also indicates the relative potential for cost effective projects in two categories: 1) indoor equipment such as plumbing fixtures and commercial kitchen equipment, 2) irrigation equipment. Cost effectiveness potential is rated on a scale of one to three dollar signs. The tool does not generate a cost effectiveness potential for process-oriented equipment such as cooling towers, steam systems, vehicle wash, and distribution leaks because cost savings potential is very dependent on site-specific application and use patterns."]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Start"]
[]
[]
[]
[null,"Paper Data Entry"]
[null,"If you would prefer to fill out the input forms on paper rather than electronically, click the Expand button below to expand all input forms and show optional sections, then navigate to each form and use Excel's print function to print the forms. Click the Collapse button to collapse all input forms back to their intial state."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Expand",null,null,null,null,null,"Collapse"]

{"sheet":"1. Location","index":1,"n_rows":13,"n_cols":30,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,28],[12,15,13,21],[1,29,1,16383],[5,16,5,27],[8,23,8,27],[1,7,1,28],[5,1,5,14],[8,1,8,10],[8,16,8,21],[8,12,8,14],[10,23,10,27],[2,26,2,27],[12,7,13,13]]}
[]
[null,null,null,null,null,null,null,"WATER PROJECT SCREENING TOOL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions"]
[null,"Location"]
[]
[null,"1. Name of person entering data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2. Site name"]
[]
[]
[null,"3. City",null,null,null,null,null,null,null,null,null,null,"4. State",null,null,null,"5. Zip code (5-digit)",null,null,null,null,null,null,"6. Irrigation zone (1-11)"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Show map"]
[]
[null,null,null,null,null,null,null,"Back",null,null,null,null,null,null,null,"Next"]

{"sheet":"2. Water Supply","index":2,"n_rows":22,"n_cols":30,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,28],[1,29,1,16383],[1,7,1,28],[8,1,8,8],[8,10,8,17],[8,19,8,27],[21,7,22,13],[21,15,22,21],[14,19,14,27],[13,19,13,27],[13,10,13,17],[13,1,13,8],[18,19,18,27],[18,1,18,8],[18,10,18,17],[17,19,17,27],[17,10,17,17],[17,1,17,8],[14,1,14,8],[14,10,14,17]]}
[]
[null,null,null,null,null,null,null,"WATER PROJECT SCREENING TOOL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions"]
[null,"Water Supply"]
[]
[null,"1. What types of water are supplied to your site? Select all check boxes that apply."]
[null,null,"Potable Water",null,null,null,null,"Non-potable freshwater",null,null,null,null,null,null,"Alternative  water (water not sourced from freshwater)"]
[null,true,null,null,null,null,false,null,null,null,null,null,null,false]
[null,"What are the sources of water supplied to your site? Select all check boxes that apply for applicable water types."]
[null,"Potable water",null,null,null,null,null,null,null,null,"Non-potable freshwater",null,null,null,null,null,null,null,null,"Alternative water"]
[null,null,"Purchased",null,null,null,null,null,false,null,null,"Purchased",null,null,null,null,null,false,null,null,"Purchased",null,null,null,null,null,null,false]
[null,null,"Self-produced",null,null,null,null,null,false,null,null,"Self-produced",null,null,null,null,null,false,null,null,"Self-produced",null,null,null,null,null,null,false]
[]
[null,"2. Enter the annual water use for the most recent year in thousand gallons."]
[null,"Potable water",null,null,null,null,null,null,null,null,"Non-potable freshwater",null,null,null,null,null,null,null,null,"Alternative water"]
[]
[]
[null,"3. Select your main source of water use data from the drop-down list."]
[null,"Potable water",null,null,null,null,null,null,null,null,"Non-potable freshwater",null,null,null,null,null,null,null,null,"Alternative water"]
[]
[]
[]
[null,null,null,null,null,null,null,"Back",null,null,null,null,null,null,null,"Next"]

{"sheet":"3. Rates","index":3,"n_rows":17,"n_cols":30,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,28],[1,29,1,16383],[1,7,1,28],[5,22,5,27],[14,22,14,27],[5,1,5,8],[14,1,14,8],[2,29,18,41],[8,1,8,8],[8,22,8,27],[11,1,11,8],[11,22,11,27],[16,7,17,13],[16,15,17,21]]}
[]
[null,null,null,null,null,null,null,"WATER PROJECT SCREENING TOOL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions"]
[null,"Rates",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flat monthly fee: site only pays a flat fee that does not change with volume of water/wastewater treated.\n\nVolumentric rate: water/wastewater is charged for the volume used."]
[]
[null,"1. What is your potable water rate structure? Select from drop-down list."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B6=\"Flat monthly fee\",\"What is the monthly fee?  \",IF(B6=\"Volumetric rate\",\"What is the rate in $ per thousand gallons?  \",\"\"))","v":""}]
[]
[null,"1a. What is your non-potable water rate structure? Select from drop-down list."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B9=\"Flat monthly fee\",\"What is the monthly fee?  \",IF(B9=\"Volumetric rate\",\"What is the rate in $ per thousand gallons?  \",\"\"))","v":""}]
[]
[null,{"$f":"IF(OR(ws_inpt_12=TRUE,AND(ws_inpt_12=FALSE,ws_inpt_13)=FALSE),\"1b.\",\"1a.\")&\" What is your alternative water rate structure? Select from drop-down list.\"","v":"1b. What is your alternative water rate structure? Select from drop-down list."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B12=\"Flat monthly fee\",\"What is the monthly fee?  \",IF(B12=\"Volumetric rate\",\"What is the rate in $ per thousand gallons?  \",\"\"))","v":""}]
[]
[null,"2. What is your wastewater (sewer) rate structure? Select from drop-down list."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B15=\"Flat monthly fee\",\"What is the monthly fee?  \",IF(B15=\"Volumetric rate\",\"What is the rate in $ per thousand gallons?  \",\"\"))","v":""}]
[]
[null,null,null,null,null,null,null,"Back",null,null,null,null,null,null,null,"Next"]

{"sheet":"4. Site Level Data","index":4,"n_rows":29,"n_cols":30,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,28],[21,23,21,27],[28,7,29,13],[28,15,29,21],[25,20,25,27],[19,1,19,6],[19,8,19,13],[19,22,19,27],[19,15,19,20],[16,22,16,27],[18,1,18,6],[18,7,18,14],[18,22,18,27],[12,23,12,27],[23,23,23,27],[1,29,1,16383],[18,15,18,20],[1,7,1,28],[6,1,6,11],[6,18,6,27],[8,1,8,10],[8,18,8,27],[10,18,10,27],[15,1,15,6],[15,8,15,13],[15,15,15,20],[15,22,15,27],[16,1,16,6],[16,8,16,13],[16,15,16,20]]}
[]
[null,null,null,null,null,null,null,"WATER PROJECT SCREENING TOOL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions"]
[null,"Site Level Data"]
[]
[null,"1. What is the total population of your site?"]
[]
[null,"Average daily onsite tenants (live onsite)"]
[]
[null,"Average daily personnel (live offsite)"]
[]
[null,"1. What is the total facility area? Enter in units of square feet."]
[]
[null,"2. Are the majority of your buildings older than 1994? Estimate is acceptable. (Yes/No)"]
[]
[null,"3. What is the estimated percent of each building type by floor area?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((B17+I17+P17+W17+B20+I20+W20+P20)>100%,\"Percentages add to more than 100%\",TEXT((1-(B17+I17+P17+W17+B20+I20+W20+P20))*100,0%)&\"% remaining\")","v":"100% remaining"}]
[null,"Office",null,null,null,null,null,null,"Hospital/healthcare",null,null,null,null,null,null,"Barracks",null,null,null,null,null,null,"Prison"]
[]
[]
[null,"Laboratory",null,null,null,null,null,"Dining/commercial kitchen",null,null,null,null,null,null,null,"Other"]
[]
[]
[null,"4. Does the site operate and maintain the potable water distribution system? (Yes/No)"]
[]
[null,"Does the site perform regular leak detection? (Yes/No)"]
[]
[null,"What is the general age of the distribution system? Select from drop-down list."]
[]
[]
[null,null,null,null,null,null,null,"Back",null,null,null,null,null,null,null,"Next"]

{"sheet":"5. Water End-Use Data","index":5,"n_rows":49,"n_cols":30,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,0,0,28],[1,29,1,16383],[1,7,1,28],[4,20,4,27],[10,20,10,27],[7,22,7,27],[4,1,5,18],[7,1,8,18],[21,20,21,27],[21,1,22,18],[18,1,19,18],[18,20,18,27],[29,1,30,18],[29,20,29,27],[24,20,24,27],[45,20,45,27],[40,20,40,27],[32,20,32,27],[48,7,49,13],[48,15,49,21],[37,1,38,18],[37,20,37,27]]}
[]
[null,null,null,null,null,null,null,"WATER PROJECT SCREENING TOOL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions"]
[null,"Water End-Use Data"]
[]
[null,"1. Have high efficiency fixture retrofits been installed in any of the site's restrooms? (Yes/No)"]
[]
[]
[null,"What is the estimated % of restrooms that have been upgraded with high efficiency fixtures?"]
[]
[]
[null,"2. Does the site have landscape irrigation? (Yes/No)"]
[]
[null,"What is the water supply for landscape irrigation? Check all that apply."]
[null,null,"Potable water",null,null,null,null,null,null,null,null,"Non-potable freshwater",null,null,null,null,null,null,null,null,"Alternative water"]
[null,false,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,null,false]
[null,"What types of landscaped areas are irrigated?"]
[null,null,"Athletic fields",null,null,null,null,null,null,"Parade fields",null,null,null,null,null,"Golf course",null,null,null,null,null,"Landscape around buildings"]
[null,false,null,null,null,null,null,null,false,null,null,null,null,null,false,null,null,null,null,null,false]
[null,"Is the majority of the landscaping native or adaptive plants with low or no irrigation requirements?"]
[]
[]
[null,"Are the majority of your irrigation controls advanced weater/sensor-based controls or conventional clock timers?"]
[]
[]
[null,"3. Does the site have cooling towers? (Yes/No)"]
[]
[null,"What is the water supply for the cooling tower makeup? Check all that apply."]
[null,null,"Potable water",null,null,null,null,null,null,null,null,"Non-potable freshwater",null,null,null,null,null,null,null,null,"Alternative water"]
[null,false,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,null,false]
[null,"What is the estimated percentage of the overall site water use consumed in cooling towers?"]
[]
[]
[null,"4. Does the site have an on-site steam system? (Yes/No)"]
[]
[null,"What is the water supply for the steam system makeup? Check all that apply."]
[null,null,"Potable water",null,null,null,null,null,null,null,null,"Non-potable freshwater",null,null,null,null,null,null,null,null,"Alternative water"]
[null,false,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,null,false]
[null,"What is the estimated percentage of the overall site water use consumed in steam systems?"]
[]
[]
[null,"5. Does the site have a central vehicle wash facility? (Yes/No)"]
[]
[null,"What is the water supply for vehicle wash? Check all that apply."]
[null,null,"Potable water",null,null,null,null,null,null,null,null,"Non-potable freshwater",null,null,null,null,null,null,null,null,"Alternative water"]
[null,false,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,null,false]
[null,"6. Do any processes have single-pass cooling? (Yes/No)"]
[]
[]
[null,null,null,null,null,null,null,"Back",null,null,null,null,null,null,null,"Submit"]

{"sheet":"Output Form","index":6,"n_rows":64,"n_cols":7,"rows_kept":64,"cut":false,"hidden":true,"merged":[[48,2,48,3],[1,6,1,27],[8,1,12,1],[13,1,24,1],[22,2,22,3],[18,2,18,3],[19,2,19,3],[21,2,21,3],[20,2,20,3],[12,2,12,3],[49,2,49,3],[63,1,64,4],[24,2,24,3],[35,1,41,1],[31,2,31,3],[27,2,27,3],[61,1,62,1],[25,1,27,1],[42,1,45,1],[46,1,49,1],[50,1,53,1],[58,2,58,3],[57,2,57,3],[52,2,52,3],[28,1,34,1],[53,2,53,3],[0,1,0,4],[41,2,41,3],[40,2,40,3],[59,2,59,3],[10,2,10,3],[54,1,60,1],[60,2,60,3],[34,2,34,3],[33,2,33,3],[23,2,23,3],[11,2,11,3],[32,2,32,3],[38,2,38,3],[39,2,39,3],[44,2,44,3],[45,2,45,3]]}
[" "]
[null,null,"   WATER PROJECT SCREENING TOOL | RESULTS",null,null,null,"Water Project Screening Tool"]
[]
[null,"Site name:",{"$f":"IF(loc_inpt_2=\"\",\"\",loc_inpt_2)","v":""}]
[null,"Site location:",{"$f":"IF(loc_inpt_3=\"\",\"\",loc_inpt_3&\", \"&loc_inpt_4)","v":""}]
[null,"POC:",{"$f":"IF(loc_inpt_1=\"\",\"\",loc_inpt_1)","v":""}]
[]
[null,"EQUIPMENT","PROJECT POTENTIAL SCORE","WHAT YOUR SCORE MEANS","TECHNOLOGY OPTIONS"]
[null,"PLUMBING",null,{"$f":"IF(wed_inpt_11>=0.9,\"Most or all of the site's plumbing fixtures have been retrofitted with high efficiency fixtures so there is minimal savings potential with plumbing fixture upgrades.\",INDIRECT(\"'output_calcs'!\"&ADDRESS(ROW(out_lookup)+MATCH(\"pl\",out_lookup,0)+MATCH(1,out_pl_ary,0)-2,COLUMN(out_lookup_exp))))","v":"Plumbing fixture upgrades likely represent a relatively low potential for water savings."},{"$f":"IF(wed_inpt_11>=0.9,\"\",INDIRECT(\"'output_calcs'!\"&ADDRESS(ROW(out_lookup)+MATCH(\"pl\",out_lookup,0)+MATCH(1,out_pl_ary,0)-2,COLUMN(out_lookup_opt))))","v":"Confirm that high efficiency fixtures have been installed in new and renovated buildings.  For buildings with standard or old plumbing fixtures, consider installing high efficiency toilets, urinals, faucets, and showerheads."}]
[null,null,"Resources:"]
[null,null,"FEMP BMP #6 - Toilets and Urinals"]
[null,null,"FEMP BMP #7 - Faucets and Showers"]
[null,null,"EPA WaterSense at Work - Sanitary Fixtures"]
[null,"IRRIGATION",null,{"$f":"INDIRECT(\"'output_calcs'!\"&ADDRESS(ROW(out_lookup)+MATCH(\"ir\",out_lookup,0)+MATCH(1,out_ir_ary,0)-2,COLUMN(out_lookup_exp)))","v":"The site has no landscape irrigation."},{"$f":"INDIRECT(\"'output_calcs'!\"&ADDRESS(ROW(out_lookup)+MATCH(\"ir\",out_lookup,0)+MATCH(1,out_ir_ary,0)-2,COLUMN(out_lookup_opt)))","v":" "}]
[null,null,"ADVANCED WEATHER- OR SENSOR-BASED CONTROLS",null,"Ensure that existing advanced irrigation controls are operated and maintained per the manufacturer’s specifications and re-commissioned periodically."]
[null,null,"ADVANCED CONTROLS POTENTIAL","Conventional timer-based irrigation controls are currently used at the site, consider upgrading to advanced weather/sensor-based irrigation controls.","Weather/sensor-based irrigation controls  optimize the irrigation schedule based on real-time weather data and have the potential for significant water savings."]
[null,null,"ALTERNATIVE WATER PROJECT POTENTIAL","The site does not currently use alternative water for irrigation.  Alternative water can significantly offset the use of freshwater.","Consider switching to alternative water sources for irrigation, such as harvested rainwater or reclaimed wastewater."]
[null,null,"Resources:"]
[null,null,"FEMP BMP #4 - Water-Efficient Landscaping"]
[null,null,"FEMP BMP #5 - Water-Efficient Irrigation"]
[null,null,"Irrigation Association Audit Guidelines"]
[null,null,"EPA WaterSense Smart Watering Information"]
[null,null,"Irrigation Association's Smart Water Application Technologies (SWAT)"]
[null,null,"FEMP BMP #14 - Alternative Water Sources"]
[null,null,"EPA WaterSense at Work - Alternative Water"]
[null,"DISTRIBUTION SYSTEM",null,{"$f":"INDIRECT(\"'output_calcs'!\"&ADDRESS(ROW(out_lookup)+MATCH(\"ds\",out_lookup,0)+MATCH(1,out_ds_ary,0)-2,COLUMN(out_lookup_exp)))","v":"The site does not operate and maintain the water distribution system."},{"$f":"INDIRECT(\"'output_calcs'!\"&ADDRESS(ROW(out_lookup)+MATCH(\"ds\",out_lookup,0)+MATCH(1,out_ds_ary,0)-2,COLUMN(out_lookup_opt)))","v":" "}]
[null,null,"Resources:"]
[null,null,"FEMP BMP #3 - Distribution System Audits, Leak Detection, and Repair"]
[null,"COOLING TOWERS",null,{"$f":"INDIRECT(\"'output_calcs'!\"&ADDRESS(ROW(out_lookup)+MATCH(\"ct\",out_lookup,0)+MATCH(1,out_ct_ary,0)-2,COLUMN(out_lookup_exp)))","v":"The site has no cooling towers."},{"$f":"INDIRECT(\"'output_calcs'!\"&ADDRESS(ROW(out_lookup)+MATCH(\"ct\",out_lookup,0)+MATCH(1,out_ct_ary,0)-2,COLUMN(out_lookup_opt)))","v":" "}]
[null,null,"ALTERNATIVE WATER PROJECT POTENTIAL","The site does not currently use alternative water for cooling tower makeup.  Alternative water can significantly offset the use of freshwater.","Consider switching to alternative water sources for cooling tower makeup, such as harvested rainwater, captured condensate, or reclaimed wastewater."]
[null,null,"Resources:"]
[null,null,"FEMP BMP #10 - Cooling Tower Management"]
[null,null,"EPA WaterSense at Work - Cooling Towers"]
[null,null,"FEMP BMP #14 - Alternative Water Sources"]
[null,null,"EPA WaterSense at Work - Alternative Water"]
[null,"STEAM SYSTEM",null,{"$f":"INDIRECT(\"'output_calcs'!\"&ADDRESS(ROW(out_lookup)+MATCH(\"ss\",out_lookup,0)+MATCH(1,out_ss_ary,0)-2,COLUMN(out_lookup_exp)))","v":"The site has no steam system."},{"$f":"INDIRECT(\"'output_calcs'!\"&ADDRESS(ROW(out_lookup)+MATCH(\"ss\",out_lookup,0)+MATCH(1,out_ss_ary,0)-2,COLUMN(out_lookup_opt)))","v":" "}]
[null,null,"ALTERNATIVE WATER PROJECT POTENTIAL","The site does not currently use alternative water for steam system makeup.  Alternative water can significantly offset the use of freshwater.","Consider switching to alternative water sources for steam system makeup, such as harvested rainwater, process reuse, or reclaimed wastewater."]
[null,null,"Resources:"]
[null,null,"FEMP BMP #8 - Steam Boiler Systems"]
[null,null,"EPA WaterSense at Work - Boiler and Steam Systems"]
[null,null,"FEMP BMP #14 - Alternative Water Sources"]
[null,null,"EPA WaterSense at Work - Alternative Water"]
[null,"SINGLE-PASS COOLING",null,{"$f":"INDIRECT(\"'output_calcs'!\"&ADDRESS(ROW(out_lookup)+MATCH(\"sp\",out_lookup,0)+MATCH(1,out_sp_ary,0)-2,COLUMN(out_lookup_exp)))","v":"The site does not have single-pass cooling equipment."},{"$f":"INDIRECT(\"'output_calcs'!\"&ADDRESS(ROW(out_lookup)+MATCH(\"sp\",out_lookup,0)+MATCH(1,out_sp_ary,0)-2,COLUMN(out_lookup_opt)))","v":" "}]
[null,null,"Resources:"]
[null,null,"FEMP BMP #9 - Single-pass Cooling"]
[null,null,"EPA WaterSense at Work - Single-Pass Cooling"]
[null,"LABORATORY / MEDICAL",null,{"$f":"INDIRECT(\"'output_calcs'!\"&ADDRESS(ROW(out_lookup)+MATCH(\"lm\",out_lookup,0)+MATCH(1,out_lm_ary,0)-2,COLUMN(out_lookup_exp)))","v":"Laboratory and medical equipment upgrades likely do not represent a big potential for water savings. "},{"$f":"INDIRECT(\"'output_calcs'!\"&ADDRESS(ROW(out_lookup)+MATCH(\"lm\",out_lookup,0)+MATCH(1,out_lm_ary,0)-2,COLUMN(out_lookup_opt)))","v":" "}]
[null,null,"Resources:"]
[null,null,"FEMP BMP #12 - Laboratory and Medical Equipment"]
[null,null,"EPA WaterSense at Work - Laboratory and Medical Equipment"]
[null,"DINING",null,{"$f":"INDIRECT(\"'output_calcs'!\"&ADDRESS(ROW(out_lookup)+MATCH(\"di\",out_lookup,0)+MATCH(1,out_di_ary,0)-2,COLUMN(out_lookup_exp)))","v":"Commercial kitchen equipment upgrades likely do not represent a big potential for water savings. "},{"$f":"INDIRECT(\"'output_calcs'!\"&ADDRESS(ROW(out_lookup)+MATCH(\"di\",out_lookup,0)+MATCH(1,out_di_ary,0)-2,COLUMN(out_lookup_opt)))","v":" "}]
[null,null,"Resources:"]
[null,null,"FEMP BMP #11 - Commercial Kitchen Equipment"]
[null,null,"EPA WaterSense at Work - Commercial Kitchen Equipment"]
[null,"VEHICLE WASH",null,{"$f":"INDIRECT(\"'output_calcs'!\"&ADDRESS(ROW(out_lookup)+MATCH(\"vw\",out_lookup,0)+MATCH(1,out_vw_ary,0)-2,COLUMN(out_lookup_exp)))","v":"The site does not have vehicle wash."},{"$f":"INDIRECT(\"'output_calcs'!\"&ADDRESS(ROW(out_lookup)+MATCH(\"vw\",out_lookup,0)+MATCH(1,out_vw_ary,0)-2,COLUMN(out_lookup_opt)))","v":" "}]
[null,null,"ALTERNATIVE WATER PROJECT POTENTIAL","The site does not currently use alternative water for vehicle wash.  Alternative water can significantly offset the use of freshwater.","Consider switching to alternative water sources for vehicle wash, such as harvested rainwater or reclaimed wastewater."]
[null,null,"Resources:"]
[null,null,"FEMP BMP #13 - Other Water Intensive Processes"]
[null,null,"EPA WaterSense at Work - Vehicle Washing"]
[null,null,"FEMP BMP #14 - Alternative Water Sources"]
[null,null,"EPA WaterSense at Work - Alternative Water"]
[null,"COST EFFECTIVENESS","INDOOR PROJECTS",{"$f":"INDIRECT(\"'output_calcs'!\"&ADDRESS(ROW(out_lookup)+MATCH(\"ci\",out_lookup,0)+MATCH(1,out_ci_ary,0)-2,COLUMN(out_lookup_exp)))","v":"No rate data entered."},{"$f":"INDIRECT(\"'output_calcs'!\"&ADDRESS(ROW(out_lookup)+MATCH(\"ci\",out_lookup,0)+MATCH(1,out_ci_ary,0)-2,COLUMN(out_lookup_opt)))","v":" "}]
[null,null,"IRRIGATION PROJECTS",{"$f":"INDIRECT(\"'output_calcs'!\"&ADDRESS(ROW(out_lookup)+MATCH(\"co\",out_lookup,0)+MATCH(1,out_co_ary,0)-2,COLUMN(out_lookup_exp)))","v":"The site has a flat fee for water and there is no marginal volumetric cost. Therefore, landscape irrigation efficiency projects will be difficult to justify based on cost effectiveness unless they include other savings streams are included such as operations and maintenance costs."},{"$f":"INDIRECT(\"'output_calcs'!\"&ADDRESS(ROW(out_lookup)+MATCH(\"co\",out_lookup,0)+MATCH(1,out_co_ary,0)-2,COLUMN(out_lookup_opt)))","v":" "}]
[null,{"$f":"out_table_footer","v":"Based on your inputs, this site does not have irrigation, cooling towers, a steam system, a central vehicle wash facility, or single-pass cooling. This site also does not operate or maintain the potable water distribution system."}]

{"sheet":"output_calcs","index":7,"n_rows":148,"n_cols":20,"rows_kept":148,"cut":false,"hidden":true,"merged":[[69,0,69,2],[81,0,81,2],[12,0,12,2],[1,0,1,2],[28,0,28,2],[48,0,48,2],[62,0,62,2],[93,0,93,2],[100,0,100,2],[113,0,113,2],[128,0,128,2],[135,0,135,2]]}
["element","input","output",null,null,"Output text lookup",null,null,null,null,null,null,"CE Outdoor lookup",null,null,null,"Output table footer","include","cumulative"]
["cost effectiveness indoor",null,null,"ci",null,"code","level","explanation","options","resources","add1",null,"zone","min","max",null,"irrigation",{"$f":"IF(config_level_ir=5,1,0)","v":1},{"$f":"R2","v":1},{"$f":"IF(R2=0,\"\",IF(S2=1,\"have \",\"\")&IF(S2=$R$7,IF($R$7>1,\"or \"&Q2,Q2),IF(S2<$R$7,IF($R$7>2,Q2&\", \",Q2&\" \"),\"ERR\")))","v":"have irrigation, "}]
["rt_inpt_11",{"$f":"rt_inpt_11","v":0},{"$f":"IF(B3=\"Flat monthly fee\",0/0,0)","v":0},null,null,"ci",1,{"$f":"IF(rt_inpt_11=\"Flat monthly fee\",\"The site has a flat fee\" & \" for potable water and there is no marginal volumetric cost.  Therefore, water projects will be difficult to justify based on cost effectiveness unless they include other savings streams such as energy and operations and maintenance costs.\",\"The marginal cost of potable water \" & IF(rt_inpt_21=\"Volumetric rate\",\"and sewer \",\"\")& \"($\" & out_ci_combrt &\"/kgal) is inexpensive, which may make it difficult to justify indoor water efficiency projects unless they include other savings streams such as energy and operations and maintenance costs.\")","v":"The marginal cost of potable water ($0/kgal) is inexpensive, which may make it difficult to justify indoor water efficiency projects unless they include other savings streams such as energy and operations and maintenance costs."}," "," "," ",null,{"$f":"loc_inpt_6","v":0},{"$f":"IFERROR(INDIRECT(ADDRESS(MATCH(loc_inpt_6,out_co_zones,0)+ROW(out_co_zones)-1,COLUMN())),1)","v":1},{"$f":"IFERROR(INDIRECT(ADDRESS(MATCH(loc_inpt_6,out_co_zones,0)+ROW(out_co_zones)-1,COLUMN())),1)","v":1},null,"cooling towers",{"$f":"IF(config_level_ct=5,1,0)","v":1},{"$f":"R3+S2","v":2},{"$f":"IF(R3=0,\"\",IF(S3=1,\"have \",\"\")&IF(S3=$R$7,IF($R$7>1,\"or \"&Q3,Q3),IF(S3<$R$7,IF($R$7>2,Q3&\", \",Q3&\" \"),\"ERR\")))","v":"cooling towers, "}]
["rt_inpt_12",{"$f":"rt_inpt_12","v":0},{"$f":"IF(B3=\"Volumetric Rate\",rt_inpt_12,0)","v":0},null,null,"ci",2,{"$f":"\"The marginal cost of potable water \" & IF(rt_inpt_21=\"Volumetric rate\",\"and sewer \",\"\")& \"($\" & out_ci_combrt &\"/kgal) will likely produce fairly favorable, cost effective indoor water efficiency projects.\"","v":"The marginal cost of potable water ($0/kgal) will likely produce fairly favorable, cost effective indoor water efficiency projects."}," "," "," ",null,1,6.5,7.5,null,"a steam system",{"$f":"IF(config_level_ss=5,1,0)","v":1},{"$f":"R4+S3","v":3},"a steam system, "]
["rt_inpt_21",{"$f":"rt_inpt_21","v":0},null,null,null,"ci",3,{"$f":"\"The marginal cost of potable water \" & IF(rt_inpt_21=\"Volumetric rate\",\"and sewer \",\"\")& \"($\" & out_ci_combrt &\"/kgal) will likely produce very favorable, cost effective indoor water efficiency projects.\"","v":"The marginal cost of potable water ($0/kgal) will likely produce very favorable, cost effective indoor water efficiency projects."}," "," "," ",null,2,4,5,null,"a central vehicle wash facility",{"$f":"IF(config_level_vw=5,1,0)","v":1},4,"a central vehicle wash facility, "]
["rt_inpt_22",{"$f":"rt_inpt_22","v":0},{"$f":"IF(B3=\"Volumetric Rate\",IF(B5=\"Volumetric Rate\",rt_inpt_22,0),0)","v":0},null,null,"ci",4," "," "," "," ",null,3,3,4,null,"single-pass cooling",{"$f":"IF(config_level_sp=5,1,0)","v":1},5,"or single-pass cooling"]
["combined rate",null,{"$f":"SUM(C3:C6)","v":0},null,null,"ci","NA",{"$f":"\"No rate data entered.\"","v":"No rate data entered."}," "," "," ",null,4,1.5,2,null,"total",{"$f":"SUM(R2:R6)","v":5}]
["threshold 1","combined rate  >0 AND <=3 OR Flat rate",{"$f":"IF(NOT(ISERROR(out_ci_combrt)),IF(AND(out_ci_combrt>0,out_ci_combrt<=3),1,0),1)","v":0},null,null,"co",1,{"$f":"IF(out_co_combrt=\"flat rate\",\"The site has a flat fee for water\" & \" and there is no marginal volumetric cost. Therefore, landscape irrigation efficiency projects will be difficult to justify based on cost effectiveness unless they include other savings streams are included such as operations and maintenance costs.\",\"The marginal cost of \" &B23& \" water ($\" & out_co_combrt &\"/kgal) is inexpensive, which may make it difficult to justify landscape irrigation efficiency projects unless they include other savings streams such as operations and maintenance costs.\")","v":"The site has a flat fee for water and there is no marginal volumetric cost. Therefore, landscape irrigation efficiency projects will be difficult to justify based on cost effectiveness unless they include other savings streams are included such as operations and maintenance costs."}," "," "," ",null,5,2.25,3.25]
["threshold 2","combined rate >3 AND <6",{"$f":"IF(AND(NOT(ISERROR(out_ci_combrt)),out_ci_combrt>3,out_ci_combrt<6),1,0)","v":0},null,null,"co",2,{"$f":"\"The marginal cost of \" &B23& \" water ($\" & out_co_combrt &\"/kgal) will likely produce fairly favorable, cost effective landscape irrigation efficiency projects.\"","v":"The marginal cost of  water ($flat rate/kgal) will likely produce fairly favorable, cost effective landscape irrigation efficiency projects."}," "," "," ",null,6,6,7,null,"distribution system",{"$f":"IF(config_level_ds=5,1,0)","v":1},null,{"$f":"IF(R9=0,\".\",IF(R7>0,\". This site also does not \",\"\")&\"operate or maintain the potable water distribution system.\")","v":". This site also does not operate or maintain the potable water distribution system."}]
["threshold 3","combined rate >=6",{"$f":"IF(AND(NOT(ISERROR(out_ci_combrt)),out_ci_combrt>=6),1,0)","v":0},null,null,"co",3,{"$f":"\"The marginal cost of \" &B23& \" water ($\" & out_co_combrt &\"/kgal) will likely produce very favorable, cost effective landscape irrigation efficiency projects.\"","v":"The marginal cost of  water ($flat rate/kgal) will likely produce very favorable, cost effective landscape irrigation efficiency projects."}," "," "," ",null,7,3,4.5]
["threshold 4","NA",0,null,null,"co",4," "," "," "," ",null,8,6.5,8,null,"concat",{"$f":"IF(AND(R7=0,R9=0),\"\",\"Based on your inputs, this site does not \"&CONCATENATE(T2,T3,T4,T5,T6,T9))","v":"Based on your inputs, this site does not have irrigation, cooling towers, a steam system, a central vehicle wash facility, or single-pass cooling. This site also does not operate or maintain the potable water distribution system."}]
["NA","no data",{"$f":"IF(SUM(C8:C10)=0,1,0)","v":1},null,null,"co","NA",{"$f":"\"No rate data entered.\"","v":"No rate data entered."}," "," "," ",null,9,10,12]
["cost effectiveness irrigation",null,null,"co",null,"pl",1,"Plumbing fixture upgrades likely represent a relatively low potential for water savings.","Confirm that high efficiency fixtures have been installed in new and renovated buildings.  For buildings with standard or old plumbing fixtures, consider installing high efficiency toilets, urinals, faucets, and showerheads."," "," ",null,10,3.5,4]
["loc_inpt_6",{"$f":"loc_inpt_6","v":0},null,null,null,"pl",2,"Some of the buildings likely have old plumbing fixtures; upgrading to high efficiency fixtures will save water. ","Install high efficiency toilets, urinals, faucets, and showerheads.  Ensure the contractor has specific expertise in water-efficient plumbing systems. "," "," ",null,11,11,13]
["rt_inpt_11",{"$f":"rt_inpt_11","v":0},{"$f":"wed_inpt_21","v":false},null,null,"pl",3,"Some of the buildings likely have old plumbing fixtures; upgrading to high efficiency fixtures will save water.","Install high efficiency toilets, urinals, faucets, and showerheads.  Ensure the contractor has specific expertise in water-efficient plumbing systems.","FEMP BMP #6 - Toilets and Urinals: http://energy.gov/eere/femp/best-management-practice-6-toilets-and-urinals \nFEMP BMP#7 - Faucets and Showers: http://energy.gov/eere/femp/best-management-practice-7-faucets-and-showerheads\nEPA WaterSense: http://www.epa.gov/watersense/ "," "]
["rt_inpt_12",{"$f":"rt_inpt_12","v":0},{"$f":"IF(AND(wed_inpt_21=TRUE,B15=\"Volumetric rate\"),rt_inpt_12,0)","v":0},null,null,"pl",4,"Many of the buildings likely have old plumbing fixtures; upgrading to high efficiency fixtures will save water.","Install high efficiency toilets, urinals, faucets, and showerheads.  Ensure the contractor has specific expertise in water-efficient plumbing systems.","FEMP BMP #6 - Toilets and Urinals: http://energy.gov/eere/femp/best-management-practice-6-toilets-and-urinals \nFEMP BMP#7 - Faucets and Showers: http://energy.gov/eere/femp/best-management-practice-7-faucets-and-showerheads\nEPA WaterSense: http://www.epa.gov/watersense/ "," "]
["rt_inpt_21",{"$f":"rt_inpt_21","v":0},null,null,null,"pl","NA","The site has no plumbing project potential."," "," "," "]
["rt_inpt_22",{"$f":"rt_inpt_22","v":0},{"$f":"IF(B17=\"Volumetric rate\",rt_inpt_22,0)","v":0},null,null,"ir",1,"Landscape irrigation projects likely represent a relatively low potential for water savings.","Confirm landscaped areas are irrigated efficiently through regular system maintenance and proper scheduling, conduct a comprehensive irrigation audit every 3 years using the Irrigation Association's auditing guidelines."," "," "]
["rt_inpt_a11",{"$f":"rt_inpt_a11","v":0},{"$f":"wed_inpt_22","v":false},null,null,"ir",2,"There is potential for efficiency improvements and water savings in landscape irrigation.","Consider conducting a comprehensive irrigation audit that follows the Irrigation Association's guidelines.\nConsider implementing system distribution enhancements, installing efficiency improvements, and converting to native and adaptive landscape.\nContract with a WaterSense Irrigation Professional."," "," "]
["rt_inpt_a12",{"$f":"rt_inpt_a12","v":0},{"$f":"IF(AND(wed_inpt_22=TRUE,B19=\"Volumetric rate\"),rt_inpt_a12,0)","v":0},null,null,"ir",3,"There is potential for efficiency improvements and water savings in landscape irrigation.","Consider conducting a comprehensive irrigation audit that follows the Irrigation Association's guidelines.\nConsider implementing system distribution enhancements, installing efficiency improvements, and converting to native and adaptive landscape.\nContract with a WaterSense Irrigation Professional.","FEMP BMP #4 - Water-Efficient Landscaping: http://energy.gov/eere/femp/best-management-practice-4-water-efficient-landscaping \nFEMP BMP#5 - Water-Efficient Irrigation: http://energy.gov/eere/femp/best-management-practice-5-water-efficient-irrigation \nEPA WaterSense Smart Watering Information: http://www.epa.gov/watersense/outdoor/index.html"," "]
["rt_inpt_b11",{"$f":"rt_inpt_b11","v":0},{"$f":"wed_inpt_23","v":false},null,null,"ir",4,"There is likely a large opportunity for efficiency improvements and water savings in landscape irrigation.","Consider conducting a comprehensive irrigation audit that follows the Irrigation Association's guidelines.\nConsider implementing system distribution enhancements, installing efficiency improvements, and converting to native and adaptive landscape.\nContract with a WaterSense Irrigation Professional.","FEMP BMP #4 - Water-Efficient Landscaping: http://energy.gov/eere/femp/best-management-practice-4-water-efficient-landscaping \nFEMP BMP#5 - Water-Efficient Irrigation: http://energy.gov/eere/femp/best-management-practice-5-water-efficient-irrigation \nEPA WaterSense Smart Watering Information: http://www.epa.gov/watersense/outdoor/index.html"," "]
["rt_inpt_b12",{"$f":"rt_inpt_b12","v":0},{"$f":"IF(AND(wed_inpt_23=TRUE,B21=\"Volumetric rate\"),rt_inpt_b12,0)","v":0},null,null,"ir","NA","The site has no landscape irrigation."," "," "," "]
["combined rate",{"$f":"IFERROR(IF(D23=2,\"potable\",IF(D23=6,\"non-potable\",IF(D23=8,\"alternative\",\"\"))),\"\")","v":""},{"$f":"IF(wed_inpt_2=\"No\",\"no irrigation\",IF(MAX(C16,C20,C22)>0,MAX(C16,C20,C22),\"flat rate\"))","v":"flat rate"},{"$f":"MATCH(out_co_combrt,C15:C22,0)","v":{"$error":"#N/A"}},null,"ct",1,"Cooling towers likely do not represent a big potential for water savings.","Determine the system’s cycles of concentration.  Consider installing real-time controllers to control blowdown and chemical feed."," "," "]
["threshold 1","combined rate >0 AND <out_co_min OR Flat rate",{"$f":"IF(C28=1,0,IF(NOT(out_co_combrt=\"flat rate\"),IF(AND(out_co_combrt>=0,out_co_combrt<out_co_min),1,0),1))","v":1},null,null,"ct",2," "," "," "," "]
["threshold 2","combined rate >=out_co_min AND <=out_co_max",{"$f":"IF(NOT(ISERROR(out_co_combrt)),IF(AND(out_co_combrt>=out_co_min,out_co_combrt<=out_co_max),1,0),0)","v":0},null,null,"ct",3,"Cooling towers may be a significant water user and there is likely an opportunity for water efficiency improvements.","Maximize cycles of concentration.  Consider installing real-time controllers to control blowdown and chemical feed. Contract with a company that has specific expertise in this area.","FEMP BMP #10 - Cooling Tower Management: http://energy.gov/eere/femp/best-management-practice-10-cooling-tower-management \nEPA WaterSense: http://www.epa.gov/watersense/commercial/docs/watersense_at_work/#/194/"," "]
["threshold 3","combined rate >out_co_max",{"$f":"IF(NOT(ISERROR(out_co_combrt)),IF(AND(ISNUMBER(out_co_combrt),out_co_combrt>out_co_max),1,0),0)","v":0},null,null,"ct",4,"Cooling towers are a significant water user and offer large potential water savings.","Maximize cycles of concentration.  Consider installing real-time controllers to control blowdown and chemical feed. Contract with a company that has specific expertise in this area.","FEMP BMP #10 - Cooling Tower Management: http://energy.gov/eere/femp/best-management-practice-10-cooling-tower-management \nEPA WaterSense: http://www.epa.gov/watersense/commercial/docs/watersense_at_work/#/194/"," "]
["threshold 4","no irrigation",{"$f":"IF(out_co_combrt=B27,1,0)","v":0},null,null,"ct","NA","The site has no cooling towers."," "," "," "]
["NA","no data",{"$f":"IF(ISERROR(out_co_combrt),1,0)","v":0},null,null,"ss",1,"Steam boilers likely do not represent a big potential for water savings. ","Determine the system’s cycles of concentration.  Consider installing real-time controllers to control blowdown and chemical feed."," "," "]
["plumbing",null,null,"pl",null,"ss",2," "," "," "," "]
["sld_inpt_2",{"$f":"sld_inpt_2","v":0},{"$f":"IF(B30=\"Yes\",1,0)","v":0},null,null,"ss",3,"Steam systems may be a significant water user and there is likely an opportunity for water efficiency improvements.","Maximize cycles of concentration.  Consider installing real-time controllers to control blowdown and chemical feed.  Contract with a company that has specific expertise in this area.","FEMP BMP #8 - http://energy.gov/eere/femp/best-management-practice-8-steam-boiler-systems\nEPA WaterSense: http://www.epa.gov/watersense/commercial/docs/watersense_at_work/#/211/"," "]
["wed_inpt_1",{"$f":"wed_inpt_1","v":0},{"$f":"IF(B31=\"No\",3,0)","v":0},null,null,"ss",4,"Steam systems are a significant water user that most likely offers large potential water savings.","Maximize cycles of concentration.  Consider installing real-time controllers to control blowdown and chemical feed. Contract with a company that has specific expertise in this area.","FEMP BMP #8 - http://energy.gov/eere/femp/best-management-practice-8-steam-boiler-systems\nEPA WaterSense: http://www.epa.gov/watersense/commercial/docs/watersense_at_work/#/211/"," "]
["wed_inpt_11",{"$f":"wed_inpt_11","v":0},null,null,null,"ss","NA","The site has no steam system."," "," "," "]
["% renovated restrooms",">=90%",{"$f":"IF(AND(B31=\"Yes\",C31=0,B32>=0.9),-3,0)","v":0},null,null,"sp",1," "," "," "," "]
[null,">=75% AND <90%",{"$f":"IF(AND(B31=\"Yes\",C31=0,B32>=0.75,B32<0.9),-2,0)","v":0},null,null,"sp",2," "," "," "," "]
[null,">50% AND <75%",0,null,null,"sp",3," "," "," "," "]
[null,">20% AND <=50%",{"$f":"IF(AND(B31=\"Yes\",C31=0,B32>0.2,B32<=0.5),2,0)","v":0},null,null,"sp",4,"Single-pass cooling equipment should be eliminated unless the water used is deemed non-consumptive, which is defined as water diverted from its freshwater source and returned to the point of diversion in the same quantity and quality.","Consider replacing single-pass cooling equipment with a recirculating cooling system.","FEMP BMP #9 - Single-pass Cooling: http://energy.gov/eere/femp/best-management-practice-9-single-pass-cooling-equipment \nEPA WaterSense: http://www.epa.gov/watersense/commercial/docs/watersense_at_work/#/190/"," "]
[null,"<=20% OR blank",{"$f":"IF(AND(B31=\"Yes\",B32<=0.2),3,0)","v":0},null,null,"sp","NA","The site does not have single-pass cooling equipment."," "," "," "]
["office+hospital+barracks+prison %",{"$f":"sld_inpt_31+sld_inpt_32+sld_inpt_33+sld_inpt_34","v":0},null,null,null,"lm",1,"Laboratory and medical equipment upgrades likely do not represent a big potential for water savings. "," "," "," "]
["bldg type % (office+hospital+barracks+prison)",">=60%",{"$f":"IF(B38>=0.6,4,0)","v":0},null,null,"lm",2," "," "," "," "]
[null,">=40% AND <60%",{"$f":"IF(AND(B38>=0.4,B38<0.6),3,0)","v":0},null,null,"lm",3,"Laboratory and medical equipment may be a significant water user and there is likely an opportunity for water savings.","Consider conducting a comprehensive audit of the hospital/laboratory space to identify the water-consuming equipment and determine if water efficiency improvements apply.","FEMP BMP #12 - Laboratory and Medical Equipment: http://energy.gov/eere/femp/best-management-practice-12-laboratory-and-medical-equipment \nEPA WaterSense: http://www.epa.gov/watersense/commercial/docs/watersense_at_work/#/219"," "]
[null,">20% AND <40%",{"$f":"IF(AND(B38>0.2,B38<0.4),2,0)","v":0},null,null,"lm",4,"Laboratory and medical equipment is likely a significant water user and there is likely an opportunity for water savings.","Consider conducting a comprehensive audit of the hospital/laboratory space to identify the water-consuming equipment and determine if water efficiency improvements apply.","FEMP BMP #12 - Laboratory and Medical Equipment: http://energy.gov/eere/femp/best-management-practice-12-laboratory-and-medical-equipment \nEPA WaterSense: http://www.epa.gov/watersense/commercial/docs/watersense_at_work/#/219"," "]
[null,">0% AND <=20%",{"$f":"IF(AND(B38>0,B38<=0.2),1,0)","v":0},null,null,"lm","NA","The site has no laboratory or medical floor area."," "," "," "]
["score",null,{"$f":"MAX(SUM(C30:C42),1)","v":1},null,null,"di",1,"Commercial kitchen equipment upgrades likely do not represent a big potential for water savings. "," "," "," "]
["threshold 1","score >0 AND <=3",{"$f":"IF(AND(C43>0,C43<3),1,0)","v":1},null,null,"di",2," "," "," "," "]
["threshold 2","score =3",{"$f":"IF(C43=3,1,0)","v":0},null,null,"di",3,"Commercial kitchen equipment may be a significant water user and there may be potential for water savings.","Consider installing water-efficient kitchen equipment, including:\n- ENERGY STAR dishwashers\n- ENERGY STAR steam cookers\n- ENERGY STAR ice machines\n- WaterSense® pre-rinse spray valves","FEMP BMP #11 - Commercial Kitchen Equipment: http://energy.gov/eere/femp/best-management-practice-11-commercial-kitchen-equipment\nEPA WaterSense: http://www.epa.gov/watersense/commercial/docs/watersense_at_work/#/94/"," "]
["threshold 3","score >3 AND <6",{"$f":"IF(AND(C43>3,C43<6),1,0)","v":0},null,null,"di",4,"Commercial kitchen equipment may be a significant water user and there may be potential for water savings. ","Consider installing water-efficient kitchen equipment, including:\n- ENERGY STAR dishwashers\n- ENERGY STAR steam cookers\n- ENERGY STAR ice machines\n- WaterSense® pre-rinse spray valves","FEMP BMP #11 - Commercial Kitchen Equipment: http://energy.gov/eere/femp/best-management-practice-11-commercial-kitchen-equipment\nEPA WaterSense: http://www.epa.gov/watersense/commercial/docs/watersense_at_work/#/94/"," "]
["threshold 4","score >=6",{"$f":"IF(C43>=6,1,0)","v":0},null,null,"di","NA","The site has no dining floor area."," "," "," "]
["NA","score =0",{"$f":"IF(C43=0,1,0)","v":0},null,null,"vw",1," "," "," "," "]
["irrigation",null,null,"ir",null,"vw",2," "," "," "," "]
["wed_inpt_2",{"$f":"wed_inpt_2","v":0},{"$f":"IF(NOT(B50=\"Yes\"),0/0,0)","v":{"$error":"#DIV/0!"}},null,null,"vw",3," "," "," "," "]
["wed_inpt_24",{"$f":"wed_inpt_24","v":false},{"$f":"IF(B51=TRUE,2,0)","v":0},null,null,"vw",4,"If vehicle wash is a large water user, there may be an opportunity for water savings.","Consider implementing timers, automatic shutoff nozzles, and recycle systems to reuse rinse water.","FEMP BMP #13-Water Intensive Processes: http://energy.gov/eere/femp/best-management-practice-13-other-water-intensive-processes\nAlliance for Water Efficiency: http://www.allianceforwaterefficiency.org/Vehicle_Wash_Introduction.aspx"," "]
["wed_inpt_25",{"$f":"wed_inpt_25","v":false},{"$f":"IF(B52=TRUE,2,0)","v":0},null,null,"vw","NA","The site does not have vehicle wash."," "," "," "]
["wed_inpt_26",{"$f":"wed_inpt_26","v":false},{"$f":"IF(B53=TRUE,4,0)","v":0},null,null,"ds",1,"Leaks and losses in the water distribution system may not be significant and likely do not represent a large opportunity for water reduction.","If no leak detection program is in place, consider deploying a regular leak detection program."," "," "]
["wed_inpt_27",{"$f":"wed_inpt_27","v":false},{"$f":"IF(B54=TRUE,2,0)","v":0},null,null,"ds",2,"Leaks and losses in the water distribution system may be significant and likely represent an opportunity for water reduction.","If no leak detection program is in place, consider deploying a regular leak detection program."," "," "]
["wed_inpt_28",{"$f":"wed_inpt_28","v":0},{"$f":"IF(B55=\"Advanced Controls\",-0.5,IF(B55=\"Conventional clock timers\",1))","v":false},null,null,"ds",3,"Leaks and losses in the water distribution system may be significant and likely represent a large opportunity for water reduction.","If no leak detection program is in place, consider deploying a regular leak detection program that includes contracting a leak detection firm and/or deploying leak detection technology.","FEMP BMP #3 - Distribution System Audits, Leak Detection, and Repair: http://energy.gov/eere/femp/best-management-practice-3-distribution-system-audits-leak-detection-and-repair"," "]
["wed_inpt_271",{"$f":"wed_inpt_271","v":0},{"$f":"IF(B56=\"Yes\",-2,0)","v":0},null,null,"ds",4,"The water distribution system likely has significant losses and there is a large potential for water reductions.","Develop a regular leak detection and repair program that includes contracting a leak detection firm and/or deploying leak detection technology.","FEMP BMP #3 - Distribution System Audits, Leak Detection, and Repair: http://energy.gov/eere/femp/best-management-practice-3-distribution-system-audits-leak-detection-and-repair"," "]
["score",null,{"$f":"MAX(SUM(C50:C56),0)","v":{"$error":"#DIV/0!"}},null,null,"ds","NA","The site does not operate and maintain the water distribution system."," "," "," "]
["threshold 1","score <1.5",{"$f":"IF(C62=0,IF(C57<1.5,1,0),0)","v":0}]
["threshold 2","score >=1.5 AND <2.6",{"$f":"IF(C62=0,IF(AND(C57>=1.5,C57<2.6),1,0),0)","v":0}]
["threshold 3","score >=2.6 AND <3.6",{"$f":"IF(C62=0,IF(AND(C57>=2.6,C57<3.6),1,0),0)","v":0}]
["threshold 4","score >=3.6",{"$f":"IF(C62=0,IF(C57>=3.6,1,0),0)","v":0}]
["NA","if iserror(score)",{"$f":"IF(ISERROR(C57),1,0)","v":1}]
["alternative water",null,null,"aw"]
["ws_inpt_13",{"$f":"ws_inpt_13","v":false}]
["threshold 1","NA",0]
["threshold 2","NA",0]
["threshold 3","NA",0]
["threshold 4",null,{"$f":"IF(B64=FALSE,1,0)","v":1}]
["NA",null,{"$f":"IF(B64=TRUE,1,0)","v":0}]
["cooling towers",null,null,"ct"]
["wed_inpt_3",{"$f":"wed_inpt_3","v":0},{"$f":"IF(NOT(B71=\"Yes\"),0/0,0)","v":{"$error":"#DIV/0!"}}]
["wed_inpt_34",{"$f":"wed_inpt_34","v":0}]
["% of water use cooling towers",">=50%",{"$f":"IF(B72>=0.5,4,0)","v":0}]
[null,"<50% OR blank",{"$f":"IF(B72<0.5,3,0)","v":3}]
[null,null,0]
["score",null,{"$f":"SUM(C71:C75)","v":{"$error":"#DIV/0!"}}]
["threshold 1","NA",0]
["threshold 2","NA",0]
["threshold 3",3,{"$f":"IF(C81=0,IF(C76=3,1,0),0)","v":0}]
["threshold 4",4,{"$f":"IF(C81=0,IF(C76=4,1,0),0)","v":0}]
["NA","if iserror(score)",{"$f":"IF(ISERROR(C76),1,0)","v":1}]
["steam systems",null,null,"ss"]
["wed_inpt_4",{"$f":"wed_inpt_4","v":0},{"$f":"IF(NOT(B83=\"Yes\"),0/0,0)","v":{"$error":"#DIV/0!"}}]
["wed_inpt_34",{"$f":"wed_inpt_44","v":0}]
["% of water use steam systems",">=50%",{"$f":"IF(B84>=0.5,4,0)","v":0}]
[null,"<50% OR blank",{"$f":"IF(B84<0.5,3,0)","v":3}]
[null,null,0]
["score",null,{"$f":"SUM(C83:C87)","v":{"$error":"#DIV/0!"}}]
["threshold 1","NA",0]
["threshold 2","NA",0]
["threshold 3",3,{"$f":"IF(C93=0,IF(C88=3,1,0),0)","v":0}]
["threshold 4",4,{"$f":"IF(C93=0,IF(C88=4,1,0),0)","v":0}]
["NA","if iserror(score)",{"$f":"IF(ISERROR(C88),1,0)","v":1}]
["single-pass cooling",null,null,"sp"]
["wed_inpt_6",{"$f":"wed_inpt_6","v":0}]
["threshold 1","NA",0]
["threshold 2","NA",0]
["threshold 3","NA",0]
["threshold 4",null,{"$f":"IF(B95=\"Yes\",1,0)","v":0}]
["no output",null,{"$f":"IF(NOT(B95=\"Yes\"),1,0)","v":1}]
["lab-medical",null,null,"lm"]
["sld_inpt_32",{"$f":"sld_inpt_32","v":0}]
["sld_inpt_35",{"$f":"sld_inpt_35","v":0}]
["lab+medical % combined",null,{"$f":"B102+B103","v":0}]
["bldg % lab-medical",">50%",{"$f":"IF(C104>0.5,3,0)","v":0}]
[null,">=30% AND <=50% OR blank",{"$f":"IF(AND(C104>=0.3,C104<=0.5),2,0)","v":0}]
[null,">0% AND <30%",{"$f":"IF(AND(C104>0,C104<0.3),1,0)","v":0}]
["score",null,{"$f":"SUM(C105:C107)","v":0}]
["threshold 1",1,{"$f":"IF(C108<=1,1,0)","v":1}]
["threshold 2","NA",0]
["threshold 3",2,{"$f":"IF(C108=2,1,0)","v":0}]
["threshold 4",3,{"$f":"IF(C108=3,1,0)","v":0}]
["NA",0,0]
["dining",null,null,"di"]
["sld_inpt_32",{"$f":"sld_inpt_32","v":0}]
["sld_inpt_33",{"$f":"sld_inpt_33","v":0}]
["sld_inpt_34",{"$f":"sld_inpt_34","v":0}]
["sld_inpt_36",{"$f":"sld_inpt_36","v":0}]
["dining+prison+barracks+hospital % combined",null,{"$f":"SUM(B115:B118)","v":0}]
["bldg % dining",">50%",{"$f":"IF(C119>0.5,3,0)","v":0}]
[null,">=30% AND <=50%",{"$f":"IF(AND(C119>=0.3,C119<=0.5),2,0)","v":0}]
[null,">0% AND <30%",{"$f":"IF(AND(C119>0,C119<0.3),1,0)","v":0}]
["score",null,{"$f":"SUM(C120:C122)","v":0}]
["threshold 1",1,{"$f":"IF(C123<=1,1,0)","v":1}]
["threshold 2","NA",0]
["threshold 3",2,{"$f":"IF(C123=2,1,0)","v":0}]
["threshold 4",3,{"$f":"IF(C123=3,1,0)","v":0}]
["NA",0,0]
["vehicle wash",null,null,"vw"]
["wed_inpt_5",{"$f":"wed_inpt_5","v":0}]
["threshold 1","NA",0]
["threshold 2","NA",0]
["threshold 3","NA",0]
["threshold 4",null,{"$f":"IF(B130=\"Yes\",1,0)","v":0}]
["no output",null,{"$f":"IF(NOT(B130=\"Yes\"),1,0)","v":1}]
["distribution system",null,null,"ds"]
["sld_inpt_4",{"$f":"sld_inpt_4","v":0},{"$f":"IF(NOT(B137=\"Yes\"),0/0,0)","v":{"$error":"#DIV/0!"}}]
["sld_inpt_41",{"$f":"sld_inpt_41","v":0},{"$f":"IF(B138=\"No\",5,0)","v":0}]
["sld_inpt_42",{"$f":"sld_inpt_42","v":0}]
["general age of system","Older than 30 years",{"$f":"IF(B140=$B$139,5,0)","v":0}]
[null,"Between 15 and 30 years",{"$f":"IF(B141=$B$139,4,0)","v":0}]
[null,"15 years or newer",{"$f":"IF(B142=$B$139,3,0)","v":0}]
["score",null,{"$f":"SUM(C137:C142)","v":{"$error":"#DIV/0!"}}]
["threshold 1","<4",{"$f":"IF(C148=0,IF(C143<4,1,0),0)","v":0}]
["threshold 2",{"$f":"4","v":4},{"$f":"IF(C148=0,IF(C143=4,1,0),0)","v":0}]
["threshold 3",">=5 AND <=9",{"$f":"IF(C148=0,IF(AND(C143>=5,C143<=9),1,0),0)","v":0}]
["threshold 4",">9",{"$f":"IF(C148=0,IF(C143>9,1,0),0)","v":0}]
["NA",null,{"$f":"IF(ISERROR(C143),1,0)","v":1}]

{"sheet":"config","index":8,"n_rows":89,"n_cols":4,"rows_kept":89,"cut":false,"hidden":true,"merged":[]}
["plumbing",{"$f":"MATCH(1,out_pl_ary,0)","v":1}]
["irrigation",{"$f":"MATCH(1,out_ir_ary,0)","v":5}]
["irrigation adv controls",{"$f":"IF(wed_inpt_28=\"Advanced controls\",5,5)","v":5},null,"map_output_state"]
["irrigation conv controls",{"$f":"IF(wed_inpt_28=\"Conventional clock timers\",4,5)","v":5},null,true]
["irrigation alt water",{"$f":"IF(AND(wed_inpt_2=\"Yes\",wed_inpt_23=FALSE),4,5)","v":5}]
["distribution system",{"$f":"MATCH(1,out_ds_ary,0)","v":5},null,"app_enableevents"]
["cooling towers",{"$f":"MATCH(1,out_ct_ary,0)","v":5},null,true]
["ct alt water",{"$f":"IF(AND(wed_inpt_3=\"Yes\",wed_inpt_33=FALSE),4,5)","v":5}]
["steam system",{"$f":"MATCH(1,out_ss_ary,0)","v":5}]
["ss alt water",{"$f":"IF(AND(wed_inpt_4=\"Yes\",wed_inpt_43=FALSE),4,5)","v":5}]
["single-pass cooling",{"$f":"MATCH(1,out_sp_ary,0)","v":5}]
["lab/medical",{"$f":"MATCH(1,out_lm_ary,0)","v":1}]
["dining",{"$f":"MATCH(1,out_di_ary,0)","v":1}]
["vehicle wash",{"$f":"MATCH(1,out_vw_ary,0)","v":5}]
["vw alt water",{"$f":"IF(AND(wed_inpt_5=\"Yes\",wed_inpt_53=FALSE),4,5)","v":5}]
["cost effectiveness indoor",{"$f":"MATCH(1,out_ci_ary,0)","v":5}]
["cost effectiveness outdoor",{"$f":"MATCH(1,out_co_ary,0)","v":1}]
[]
["current input hash",{"$f":"CONCATENATE(B21, B22, B23, B24, B25, B26, B27, B28, B29, B30, B31, B32, B33, B34, B35, B36, B37, B38, B39, B40, B41, B42, B43, B44, B45, B46, B47, B48, B49, B50, B51, B52, B53, B54, B55, B56, B57, B58, B59, B60, B61, B62, B63, B64, B65, B66, B67, B68, B69, B70, B71, B72, B73, B74, B75, B76, B77, B78, B79, B80, B81, B82, B83, B84, B85, B86, B87, B88, B89)","v":"000000TRFAFAFAFAFAFAFAFA00000000000000000.00.00.00.00.00.00.00.000000.00FAFAFAFAFAFAFA000FAFAFA0.00FAFAFA0.00FAFAFA0"}]
["previous input hash","000000TRFAFAFAFAFAFAFAFA00000000000000000.00.00.00.00.00.00.00.000000.00FAFAFAFAFAFAFA000FAFAFA0.00FAFAFA0.00FAFAFA0"]
["loc_inpt_1",{"$f":"LEFT(TEXT(INDIRECT(A21),\"0\"),2)","v":"0"}]
["loc_inpt_2",{"$f":"LEFT(TEXT(INDIRECT(A22),\"0\"),2)","v":"0"}]
["loc_inpt_3","0"]
["loc_inpt_4","0"]
["loc_inpt_5","0"]
["loc_inpt_6","0"]
["ws_inpt_11","TR"]
["ws_inpt_12","FA"]
["ws_inpt_13","FA"]
["ws_inpt_a11","FA"]
["ws_inpt_b11","FA"]
["ws_inpt_a12","FA"]
["ws_inpt_b12","FA"]
["ws_inpt_a13","FA"]
["ws_inpt_b13","FA"]
["ws_inpt_21",{"$f":"TEXT(INDIRECT(A36),\"0\")","v":"0"}]
["ws_inpt_22",{"$f":"TEXT(INDIRECT(A37),\"0\")","v":"0"}]
["ws_inpt_23",{"$f":"TEXT(INDIRECT(A38),\"0\")","v":"0"}]
["ws_inpt_31",{"$f":"LEFT(TEXT(INDIRECT(A39),\"0\"),2)","v":"0"}]
["ws_inpt_32","0"]
["ws_inpt_33","0"]
["rt_inpt_11","0"]
["rt_inpt_12",{"$f":"TEXT(INDIRECT(A43),\"0\")","v":"0"}]
["rt_inpt_21","0"]
["rt_inpt_22",{"$f":"TEXT(INDIRECT(A45),\"0\")","v":"0"}]
["rt_inpt_a11","0"]
["rt_inpt_a12",{"$f":"TEXT(INDIRECT(A47),\"0\")","v":"0"}]
["rt_inpt_b11","0"]
["rt_inpt_b12",{"$f":"TEXT(INDIRECT(A49),\"0\")","v":"0"}]
["sld_inpt_1",{"$f":"TEXT(INDIRECT(A50),\"0\")","v":"0"}]
["sld_inpt_2","0"]
["sld_inpt_31",{"$f":"TEXT(INDIRECT(A52),\"0.0\")","v":"0.0"}]
["sld_inpt_32",{"$f":"TEXT(INDIRECT(A53),\"0.0\")","v":"0.0"}]
["sld_inpt_33","0.0"]
["sld_inpt_34","0.0"]
["sld_inpt_35","0.0"]
["sld_inpt_36","0.0"]
["sld_inpt_37","0.0"]
["sld_inpt_38","0.0"]
["sld_inpt_4","0"]
["sld_inpt_41","0"]
["sld_inpt_42","0"]
["wed_inpt_1","0"]
["wed_inpt_11",{"$f":"TEXT(INDIRECT(A64),\"0.0\")","v":"0.0"}]
["wed_inpt_2","0"]
["wed_inpt_21","FA"]
["wed_inpt_22","FA"]
["wed_inpt_23","FA"]
["wed_inpt_24","FA"]
["wed_inpt_25","FA"]
["wed_inpt_26","FA"]
["wed_inpt_27","FA"]
["wed_inpt_271","0"]
["wed_inpt_28","0"]
["wed_inpt_3","0"]
["wed_inpt_31","FA"]
["wed_inpt_32","FA"]
["wed_inpt_33","FA"]
["wed_inpt_34",{"$f":"TEXT(INDIRECT(A79),\"0.0\")","v":"0.0"}]
["wed_inpt_4","0"]
["wed_inpt_41","FA"]
["wed_inpt_42","FA"]
["wed_inpt_43","FA"]
["wed_inpt_44",{"$f":"TEXT(INDIRECT(A84),\"0.0\")","v":"0.0"}]
["wed_inpt_5","0"]
["wed_inpt_51","FA"]
["wed_inpt_52","FA"]
["wed_inpt_53","FA"]
["wed_inpt_6","0"]

{"sheet":"clear_inputs","index":9,"n_rows":35,"n_cols":1,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["loc_inpt_1"]
["loc_inpt_2"]
["loc_inpt_3"]
["loc_inpt_4"]
["loc_inpt_5"]
["loc_inpt_6"]
["ws_inpt_11"]
["ws_inpt_12"]
["ws_inpt_13"]
["rt_inpt_11"]
["rt_inpt_12"]
["rt_inpt_21"]
["rt_inpt_22"]
["rt_inpt_a11"]
["rt_inpt_a12"]
["rt_inpt_b11"]
["rt_inpt_b12"]
["sld_inpt_1"]
["sld_inpt_2"]
["sld_inpt_31"]
["sld_inpt_32"]
["sld_inpt_33"]
["sld_inpt_34"]
["sld_inpt_35"]
["sld_inpt_36"]
["sld_inpt_37"]
["sld_inpt_38"]
["sld_inpt_4"]
["wed_inpt_1"]
["wed_inpt_2"]
["wed_inpt_3"]
["wed_inpt_4"]
["wed_inpt_5"]
["wed_inpt_6"]
["wed_inpt_28"]

{"sheet":"input_validation","index":10,"n_rows":72,"n_cols":12,"rows_kept":72,"cut":false,"hidden":true,"merged":[[5,8,8,8]]}
["level","worksheet","text","name","value","type","check",null,"error",null,"msg_type","msg_text"]
["worksheet","Location","the name of the person entering data","loc_inpt_1",{"$f":"INDIRECT(D2)","v":0},"text field",{"$f":"IF(E2=0,FALSE,TRUE)","v":false},null,{"$f":"MATCH(FALSE,validate_check_col,0)","v":2},null,"text field",{"$f":"\"Not all inputs are complete. Please enter a value for \" & INDIRECT(ADDRESS(validate_cur_err,COLUMN(validate_text_col)))  & \" in the \" & INDIRECT(ADDRESS(validate_cur_err,COLUMN(validate_ws_col))) & \" form.\"","v":"Not all inputs are complete. Please enter a value for the name of the person entering data in the Location form."}]
["worksheet","Location","your site name","loc_inpt_2",0,"text field",false,null,"type",null,"check box",{"$f":"\"Not all inputs are complete. Please select \" & INDIRECT(ADDRESS(validate_cur_err,COLUMN(validate_text_col))) & \" in the \" & INDIRECT(ADDRESS(validate_cur_err,COLUMN(validate_ws_col))) & \" form.\"","v":"Not all inputs are complete. Please select the name of the person entering data in the Location form."}]
["worksheet","Location","your city","loc_inpt_3",0,"text field",false,null,{"$f":"INDIRECT(ADDRESS(validate_cur_err,COLUMN(validate_type_col)))","v":"text field"},null,"multi text field",{"$f":"\"Not all inputs are complete. Please enter values \" & INDIRECT(ADDRESS(validate_cur_err,COLUMN(validate_text_col)))  & \" in the \" & INDIRECT(ADDRESS(validate_cur_err,COLUMN(validate_ws_col))) & \" form.\"","v":"Not all inputs are complete. Please enter values the name of the person entering data in the Location form."}]
["worksheet","Location","your state","loc_inpt_4",0,"text field",false,null,"message",null,"boolean",{"$f":"\"Not all inputs are complete. Please indicate whether \" & INDIRECT(ADDRESS(validate_cur_err,COLUMN(validate_text_col)))  & \" in the \" & INDIRECT(ADDRESS(validate_cur_err,COLUMN(validate_ws_col))) & \" form.\"","v":"Not all inputs are complete. Please indicate whether the name of the person entering data in the Location form."}]
["worksheet","Location","your zip code (5-digit)","loc_inpt_5",0,"text field",false,null,{"$f":"INDIRECT(ADDRESS(MATCH(validate_cur_type,validate_msg_type,0),COLUMN(validate_msg_text)))","v":"Not all inputs are complete. Please enter a value for the name of the person entering data in the Location form."},null,"water supply",{"$f":"\"Not all inputs are complete. You have indicated that the site uses \"& INDIRECT(ADDRESS(validate_cur_err,COLUMN(validate_text_col))) &\" for one or more water end-uses. Please select \"& INDIRECT(ADDRESS(validate_cur_err,COLUMN(validate_text_col))) &\" in the Water Supply form and complete the associated inputs in that form and the Rates form.\"","v":"Not all inputs are complete. You have indicated that the site uses the name of the person entering data for one or more water end-uses. Please select the name of the person entering data in the Water Supply form and complete the associated inputs in that form and the Rates form."}]
["worksheet","Location","your climate zone (1-11)","loc_inpt_6",0,"text field",false]
["worksheet","Water Supply",null,"ws_inpt_11",true,"check box","NA"]
["worksheet","Water Supply",null,"ws_inpt_12",false,"check box","NA"]
["worksheet","Water Supply",null,"ws_inpt_13",false,"check box","NA"]
["worksheet","Water Supply","one or more sources for your site's potable water","ws_inpt_a11",false,"check box",{"$f":"IF(AND(E11=FALSE,E12=FALSE),FALSE,TRUE)","v":false}]
["worksheet","Water Supply",null,"ws_inpt_b11",false,"check box","NA"]
["worksheet","Water Supply","one or more sources for your site's non-potable water","ws_inpt_a12",false,"check box",{"$f":"IF(AND(E9=TRUE,E13=FALSE,E14=FALSE),FALSE,TRUE)","v":true}]
["worksheet","Water Supply",null,"ws_inpt_b12",false,"check box","NA"]
["worksheet","Water Supply","one or more sources for your site's alternative water","ws_inpt_a13",false,"check box",{"$f":"IF(AND(E10=TRUE,E15=FALSE,E16=FALSE),FALSE,TRUE)","v":true}]
["worksheet","Water Supply",null,"ws_inpt_b13",false,"check box","NA"]
["worksheet","Water Supply",null,"ws_inpt_21",0,"text field","NA"]
["worksheet","Water Supply",null,"ws_inpt_22",0,"text field","NA"]
["worksheet","Water Supply",null,"ws_inpt_23",0,"text field","NA"]
["worksheet","Water Supply",null,"ws_inpt_31",0,"text field","NA"]
["worksheet","Water Supply",null,"ws_inpt_32",0,"text field","NA"]
["worksheet","Water Supply",null,"ws_inpt_33",0,"text field","NA"]
["worksheet","Rates","your site's potable water rate type (volumetric or flat fee)","rt_inpt_11",0,"text field",{"$f":"IF(E23=0,FALSE,TRUE)","v":false}]
["worksheet","Rates","your site's potable water rate ($ per thousand gallons)","rt_inpt_12",0,"text field",{"$f":"IF(AND(E23=\"Volumetric rate\",E24=0),FALSE,TRUE)","v":true}]
["worksheet","Rates","your site's wastewater rate type (volumetric or flat fee)","rt_inpt_21",0,"text field",{"$f":"IF(E25=0,FALSE,TRUE)","v":false}]
["worksheet","Rates","your site's wastewater rate ($ per thousand gallons)","rt_inpt_22",0,"text field",{"$f":"IF(AND(E25=\"Volumetric rate\",E26=0),FALSE,TRUE)","v":true}]
["worksheet","Rates","your site's non-potable water rate type (volumetric or flat fee)","rt_inpt_a11",0,"text field",{"$f":"IF(AND(E9=TRUE,E27=0),FALSE,TRUE)","v":true}]
["worksheet","Rates","your site's non-potable water rate ($ per thousand gallons)","rt_inpt_a12",0,"text field",{"$f":"IF(AND(E27=\"Volumetric rate\",E28=0),FALSE,TRUE)","v":true}]
["worksheet","Rates",null,"rt_inpt_b11",0,"text field","NA"]
["worksheet","Rates",null,"rt_inpt_b12",0,"text field","NA"]
["worksheet","Site Level Data","the total facility square footage","sld_inpt_1",0,"text field","NA"]
["worksheet","Site Level Data","a majority of your site's buildings were built before 1994","sld_inpt_2",0,"boolean",{"$f":"IF(E32=0,FALSE,TRUE)","v":false}]
["worksheet","Site Level Data","totaling 100% for the estimated percent of each building type by floor area","sld_inpt_31",0,"multi text field",{"$f":"IF(NOT(SUM(E33:E40)=1),FALSE,TRUE)","v":false}]
["worksheet","Site Level Data",null,"sld_inpt_32",0,"multi text field","NA"]
["worksheet","Site Level Data",null,"sld_inpt_33",0,"multi text field","NA"]
["worksheet","Site Level Data",null,"sld_inpt_34",0,"multi text field","NA"]
["worksheet","Site Level Data",null,"sld_inpt_35",0,"multi text field","NA"]
["worksheet","Site Level Data",null,"sld_inpt_36",0,"multi text field","NA"]
["worksheet","Site Level Data",null,"sld_inpt_37",0,"multi text field","NA"]
["worksheet","Site Level Data",null,"sld_inpt_38",0,"multi text field","NA"]
["worksheet","Site Level Data","the site operates and maintains the water distribution system","sld_inpt_4",0,"boolean",{"$f":"IF(E41=0,FALSE,TRUE)","v":false}]
["worksheet","Site Level Data","the site performs regular leak detection","sld_inpt_41",0,"boolean",{"$f":"IF(AND(E41=\"Yes\",E42=0),FALSE,TRUE)","v":true}]
["worksheet","Site Level Data","the general age of the distribution system","sld_inpt_42",0,"text field",{"$f":"IF(AND(E41=\"Yes\",E43=0),FALSE,TRUE)","v":true}]
["worksheet","Water End-Use Data","high efficiency fixture retrofits have been installed in any of the site's restrooms","wed_inpt_1",0,"boolean",{"$f":"IF(E44=0,FALSE,TRUE)","v":false}]
["worksheet","Water End-Use Data",null,"wed_inpt_11",0,"text field","NA"]
["worksheet","Water End-Use Data","the site has landscape irrigation","wed_inpt_2",0,"boolean",{"$f":"IF(E46=0,FALSE,TRUE)","v":false}]
["worksheet","Water End-Use Data","one or more water supply types for landscape irrigation","wed_inpt_21",false,"check box",{"$f":"IF(AND(E46=\"Yes\",E47=FALSE,E48=FALSE,E49=FALSE),FALSE,TRUE)","v":true}]
["worksheet","Water End-Use Data",null,"wed_inpt_22",false,"check box","NA"]
["worksheet","Water End-Use Data",null,"wed_inpt_23",false,"check box","NA"]
["worksheet","Water End-Use Data","one or more irrigated landscaped area types","wed_inpt_24",false,"check box",{"$f":"IF(AND(E46=\"Yes\",E50=FALSE,E51=FALSE,E52=FALSE,E53=FALSE),FALSE,TRUE)","v":true}]
["worksheet","Water End-Use Data",null,"wed_inpt_25",false,"check box","NA"]
["worksheet","Water End-Use Data",null,"wed_inpt_26",false,"check box","NA"]
["worksheet","Water End-Use Data",null,"wed_inpt_27",false,"check box","NA"]
["worksheet","Water End-Use Data",null,"wed_inpt_271",0,"boolean","NA"]
["worksheet","Water End-Use Data","the majority of your irrigation controls are advanced or conventional","wed_inpt_28",0,"boolean",{"$f":"IF(AND(E46=\"Yes\",E55=0),FALSE,TRUE)","v":true}]
["worksheet","Water End-Use Data","the site has cooling towers","wed_inpt_3",0,"boolean",{"$f":"IF(E56=0,FALSE,TRUE)","v":false}]
["worksheet","Water End-Use Data","one or more water supply types for the site's cooling towers","wed_inpt_31",false,"check box",{"$f":"IF(AND(E56=\"Yes\",E57=FALSE,E58=FALSE,E59=FALSE),FALSE,TRUE)","v":true}]
["worksheet","Water End-Use Data",null,"wed_inpt_32",false,"check box","NA"]
["worksheet","Water End-Use Data",null,"wed_inpt_33",false,"check box","NA"]
["worksheet","Water End-Use Data",null,"wed_inpt_34",0,"text field","NA"]
["worksheet","Water End-Use Data","the site has a steam system","wed_inpt_4",0,"boolean",{"$f":"IF(E61=0,FALSE,TRUE)","v":false}]
["worksheet","Water End-Use Data","one or more water supply types for the site's steam system","wed_inpt_41",false,"check box",{"$f":"IF(AND(E61=\"Yes\",E62=FALSE,E63=FALSE,E64=FALSE),FALSE,TRUE)","v":true}]
["worksheet","Water End-Use Data",null,"wed_inpt_42",false,"check box","NA"]
["worksheet","Water End-Use Data",null,"wed_inpt_43",false,"check box","NA"]
["worksheet","Water End-Use Data",null,"wed_inpt_44",{"$f":"INDIRECT(D65)","v":0},"text field","NA"]
["worksheet","Water End-Use Data","the site has a central vehicle wash facility","wed_inpt_5",0,"boolean",{"$f":"IF(E66=0,FALSE,TRUE)","v":false}]
["worksheet","Water End-Use Data","one or more water supply types for the site's vehicle wash facility","wed_inpt_51",false,"check box",{"$f":"IF(AND(E66=\"Yes\",E67=FALSE,E68=FALSE,E69=FALSE),FALSE,TRUE)","v":true}]
["worksheet","Water End-Use Data",null,"wed_inpt_52",false,"check box","NA"]
["worksheet","Water End-Use Data",null,"wed_inpt_53",false,"check box","NA"]
["worksheet","Water End-Use Data","any processes have single-pass cooling","wed_inpt_6",0,"boolean",{"$f":"IF(E70=0,FALSE,TRUE)","v":false}]
["global","Water Supply","non-potable water",null,null,"water supply",{"$f":"IF(AND(E9=FALSE,OR(E48=TRUE,E58=TRUE,E63=TRUE,E68=TRUE)),FALSE,TRUE)","v":true}]
["global","Water Supply","alternative water",null,null,"water supply",{"$f":"IF(AND(E10=FALSE,OR(E49=TRUE,E59=TRUE,E64=TRUE,E69=TRUE)),FALSE,TRUE)","v":true}]

{"sheet":"Irrigation Zones","index":11,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":true,"merged":[[31,16,32,22]]}
[]
[null,null,null,null,null,null,null,"WATER PROJECT SCREENING TOOL | IRRIGATION ZONE MAP"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Close"]

{"sheet":"template","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[[1,0,1,20]]}

{"sheet":"Help","index":13,"n_rows":121,"n_cols":25,"rows_kept":121,"cut":false,"hidden":false,"merged":[[1,7,1,28],[4,1,7,27],[11,1,18,27],[70,1,72,27],[73,1,75,27],[20,1,22,27],[25,1,33,27],[37,1,39,27],[2,23,2,27],[9,21,9,27],[35,24,35,27],[53,21,53,27],[41,1,44,27],[55,1,56,27],[58,1,62,27],[46,1,51,27],[64,1,68,27],[116,1,118,27],[120,1,123,27],[76,1,77,27],[81,1,85,27],[92,1,102,27],[104,1,108,27],[110,1,114,27],[79,20,79,27],[86,1,89,27]]}
[]
[null,null,null,null,null,null,null,"WATER PROJECT SCREENING TOOL | HELP"]
[" ","Location",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Back to Location"]
[]
[null,"In fields 1 through 5, enter your name and site information. In field 6, select the irrigation zone for your location. To find your irrigation zone, click the “Show Map” button and find the appropriate irrigation zone for your site, then click the “Close” button and select the zone number from the dropdown list."]
[]
[]
[]
[]
[" ","Water Supply",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Back to Water Supply"]
[]
[null,"1. Water supply. All sites should be supplied with potable water for drinking and other sanitation purposes (such as showering and hand washing); therefore, the potable water box is selected by default. If your site is supplied with non-potable freshwater or alternative water (see definitions below), select the appropriate boxes. For potable and non-potable supply type, indicate whether the site purchases the supply from an outside entity or if it self-produces onsite from sources such as wells or surface water, such as a golf course pond. For alternative water supply type, indicate whether the site purchases offsite reclaimed water, harvests rainwater, or uses onsite produced processed water."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2. Water use. For each applicable water supply type, enter the total amount of water used in the most recent completed calendar year. This data should be readily available from water utility bills and/or production records. This input is optional."]
[]
[]
[]
[null,"Definitions:"]
[null,"Potable water: Water that is of sufficient quality for human consumption and is obtained from public water systems or from freshwater sources such as lakes, streams, and aquifers that are classified, permitted, and approved for human consumption.\nNon-potable freshwater: Water obtained from freshwater sources (such as surface water or groundwater) that is not of sufficient quality for human consumption and has not been properly treated nor permitted and approved for human consumption.\nAlternative water: Water not obtained from a freshwater source (surface water or groundwater sources). Alternative water can include rainwater harvested from roofs, gray water, air cooling condensate, reject water from water purification systems, reclaimed wastewater, or water derived from other water reuse strategies."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[" ","Rates",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Back to Rates"]
[]
[null,"Rate structure. Select the appropriate water and wastewater rate type. There are generally two types of rate structures for water and wastewater charged by water utilities, which can found on water bills:"]
[]
[]
[null,"Flat monthly fee: A constant fee that does not change with the volume of water."]
[null,"Volumetric rate: A fee corresponding to the volume of water used that is charged on a per unit basis; enter this rate in the units of cost per thousand gallons ($/kgal). If the water utility’s rate is in a different unit, such as cost per hundred cubic feet ($/ccf), convert ccf to kgal by dividing $/ccf by the unit conversion factor of 0.748 kgal per ccf."]
[]
[]
[]
[]
[null,"If the site produces water onsite or treats wastewater onsite, a volumetric rate can be derived by summing the costs for treatment, pumping, distribution, and ongoing system operation and maintenance, and dividing this total by the total number of gallons produced or treated. Sites often derive such a rate to charge reimbursable customers for water consumption and treated wastewater. If this rate is available or can be derived, enter it into the volumetric rate field.  If not, chose the “flat monthly fee” option and leave the monthly fee field blank."]
[]
[]
[]
[]
[]
[]
[" ","Site Level Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Back to Site Level Data"]
[]
[null,"1. Facility square footage. Enter the total facility square footage (all buildings within the site); this data may be found in a real property database. This input is optional."]
[]
[]
[null,"2. Buildings’ age. A building’s age helps to indicate the type of plumbing fixtures that are installed. Buildings built before 1994 may have old, inefficient fixtures while new buildings likely have more efficient fixtures. For sites where over 50% of the buildings are constructed before 1994, select “Yes” from the dropdown list. The age of buildings may be obtained in a real property database. If you do not have easy access to this data, make a best estimate."]
[]
[]
[]
[]
[]
[null,"3. Building type breakout. The building type generally indicates the type of water-consuming equipment that is in the building. Enter an estimated percentage of each building type by total square feet of floor area.  Make sure this number adds to 100%. For large campuses, if possible obtain the real property database, which should include building type categories. If you do not have easy access to this data, make an estimate of the building type breakout."]
[]
[]
[]
[]
[]
[null,"4. Water distribution system. If the site operates and maintains the system of pipes that distributes water within a large building or across a complex of buildings, select yes. Water distribution systems can be a source of significant leaks if not maintained properly.  "]
[]
[]
[null,"Leak detection: If the site operates and maintains the system, indicate whether the site has a regular leak detection program. This typically consists of identifying leaks through an acoustic listening device and determining the location of the leak so that it can be repaired. "]
[]
[]
[null,"System age: Older systems are more prone to leaks. Select the age range that best represents the majority of system distribution’s age."]
[]
[]
[" ","Water End-Use Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Back to Water End-Use Data"]
[]
[null,"1. Restroom renovations. If any restrooms have been retrofitted with high efficiency fixtures, select yes from the drop down list.  High efficiency fixtures are defined by the Environmental Protection Agency as: toilets with a flush rate of 1.28 gallons per flush (gpf) or less; urinals with a flush rate of 0.5 gpf or less; faucets with a flow rate of 1.5 gallons per minute (gpm) or less, and showerheads with a flow rate of 2.0 gpm or less."]
[]
[]
[]
[]
[null,"If there have been restroom retrofit projects, enter an estimated percentage of buildings that have been upgraded. For example, if all of the restrooms have been upgraded with high efficiency fixtures in three buildings that total 300,000 square feet, with a total site floor area of 1 million square feet, then the total percentage of upgraded restrooms is 30%.  It is acceptable to estimate this value."]
[]
[]
[]
[]
[null,"2. Landscape irrigation."]
[null,"Supply type: If the facility irrigates landscaping, select the sources of irrigation water. Sites commonly irrigate with potable water but some may use non-potable water, or “raw” water directly from a surface supply or non-potable well. Alternative water, such as harvested rainwater, may also be a source of irrigation water. \nLandscape type: Select the landscape types that are irrigated at the facility. If the facility has landscaping around buildings, specify whether these areas are mostly native or adaptive landscaping, which are plants specific to your area that do not require supplemental irrigation. This input is optional.\nController type: Indicate the type of controllers that are used to schedule irrigation. Advanced controls use live weather data or soil moisture data to determine the required amount of irrigation. Conventional clock timers set the irrigation schedule based on a pre-determined time, typically at the same time each day. Select the type of controller that is predominant at the site."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3. Cooling towers: If the facility has cooling towers, select the sources of makeup water. Cooling tower makeup water is commonly supplied with potable water, but some sites may use non-potable water, or “raw” water directly from a surface supply or non-potable well. Alternative water, such as harvested rainwater or captured condensate, may also be a source of makeup water. If the data is available, enter an estimated percentage of the water used in cooling towers. "]
[]
[]
[]
[]
[]
[null,"4. Steam systems: If the facility has a steam system, select the sources of makeup water. Steam system makeup water is commonly supplied with potable water, but some sites may use non-potable water, or “raw” water directly from a surface supply or non-potable well. Alternative water, such as harvested rainwater or captured condensate, may also be a source of makeup water. If the data is available, enter an estimated percentage of the water used in steam systems."]
[]
[]
[]
[]
[]
[null,"5. Vehicle wash: If the facility has a vehicle wash system, select the sources of water. Vehicle wash systems are commonly supplied with potable water, but some sites may use non-potable water, or “raw” water directly from a surface supply or non-potable well. "]
[]
[]
[]
[null,"6. Single-pass cooling: Single-pass cooling systems circulate water once through a heat exchanger to cool a piece of equipment and then send the water down the drain. Types of equipment that typically use single-pass cooling include CAT scanners, degreasers, hydraulic equipment, and condensers. Indicate whether the site has single-pass cooling equipment."]