{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Input Data","Cost and Results Tab"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":0,"comments":2,"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":"Instructions","index":0,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,"Full Cost of Water Tool"]
[null,"Guidance  / Instructions"]
[]
[null,"Overview"]
[null,"This tool will help estimate the full cost of water. Often water savings projects are not cost effective based upon the tap fee associated with municipal water supplies. However, many of these projects may be effective if all associated costs are added to the tap fee. "]
[]
[null,"The flow of the tool has been designed to allow the operator to move freely through the tool without the use of a guidance document.  However, this tool is designed for multiple skill set levels and some individuals may require additional assistance. It is important to work through the tool in the order suggested as results are often accumulated through the various worksheets."]
[]
[null,"To use the tool, please adhere to the following recommendations:"]
[]
[null,"The tool will only function properly if the macros are enabled."]
[]
[null,"Fields that may be edited by the user are shaded in light gray with a black font.  Often, these fields may be pre-populated with a drop-down cell. If you do not see an option in the drop down that is applicable to your operations, select \"Other\". Once you have selected \"Other\" simply enter the appropriate information. Note: Fields that are not shaded in light gray should not be modified for general use.  "]
[]
[null,"To navigate from one area to another click on any Icon in the workbook. The user may also select the worksheet at the bottom of the screen."]

{"sheet":"Input Data","index":1,"n_rows":20,"n_cols":49,"rows_kept":20,"cut":false,"hidden":false,"merged":[[10,33,10,36],[10,37,10,38],[8,1,8,4],[8,5,8,6],[8,33,8,36],[8,37,8,38],[9,1,9,4],[9,5,9,6],[9,33,9,36],[9,37,9,38],[10,5,10,6],[10,1,10,4],[6,1,6,12],[6,33,6,44],[1,1,3,12],[7,1,7,4],[7,5,7,6],[7,33,7,36],[7,37,7,38],[19,39,19,41],[18,1,18,6],[18,33,18,38],[14,1,14,6],[14,33,14,38],[15,1,15,6],[15,33,15,38],[16,1,16,6],[16,33,16,38],[19,1,19,6],[19,7,19,9],[19,33,19,38],[18,39,18,41],[18,7,18,9],[11,1,11,6],[11,33,11,38],[12,1,12,6],[12,33,12,38],[13,1,13,6],[13,33,13,38]]}
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Select Time Period)","(Select Yes, No, or N/A)","(Select Unit)"]
[null,"Water Tool - Operator Input Page",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Previous Years Data","Yes","gal"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year to Date Data","No","lb"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Previous Monthly Data","N/A","liter"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Map Key",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,null,null,null,null,"Current Monthly Data",null,"kg"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","Category Description",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,null,null,null,"Other ",null,"ft3"]
[null,"Operator Data Input Required",null,null,null,null,null,null,null,null,null,null,null,null,"-","Operator Input / Drop Down Cells",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Operator Data Input Required",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m3"]
[null,"Date data entered",null,null,null,"(Enter Todays Date)",null,null,null,null,null,null,null,null,"-","Calculated Value Cells",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date data entered",null,null,null,"(Enter Todays Date)"]
[null,"Time period for data entered",null,null,null,"(Select Time Period)",null,null,null,null,null,null,null,null,"-","Automatically Filled Cell",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Time period for data entered",null,null,null,"(Select Time Period)"]
[null,"Plant operating hours for time period",null,null,null,"(Enter Total Operating Hours)",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,"Plant operating hours for time period",null,null,null,"(Enter Total Operating Hours)"]
[]
[null,"Plant bills or metered inputs",null,null,null,null,null,"Units of Measure",null,"Amount","Cost","Currency","Notes / Comments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plant bills or metered inputs",null,null,null,null,null,"Units of Measure",null,"Amount","Cost","Currency","Notes / Comments"]
[null,"Total water used during time period",null,null,null,null,null,"(Select Unit)",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,"Total water used during time period",null,null,null,null,null,"(Select Unit)"]
[null,"Total water purchased during time period",null,null,null,null,"TOTAL WATER PURCHASED DURING TIME PERIOD",{"$f":"IF($H$13=\"(Select Unit)\",\"-\",$H$13)","v":"-"},null,null,null,"$",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total water purchased during time period",null,null,null,null,"TOTAL WATER PURCHASED DURING TIME PERIOD",{"$f":"IF($H$13=\"(Select Unit)\",\"-\",$H$13)","v":"-"},null,null,null,"$"]
[null,"Total wastewater discharged during time period",null,null,null,null,"TOTAL WASTE WATER DISCHARGED ",{"$f":"IF($H$13=\"(Select Unit)\",\"-\",$H$13)","v":"-"},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,"Total wastewater discharged during time period",null,null,null,null,"TOTAL WASTE WATER DISCHARGED ",{"$f":"IF($H$13=\"(Select Unit)\",\"-\",$H$13)","v":"-"}]
[null,"Total wastewater billed during time period",null,null,null,null,"TOTAL WASTE WATER BILLED",{"$f":"IF($H$13=\"(Select Unit)\",\"-\",$H$13)","v":"-"},null,null,null,"$",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total wastewater billed during time period",null,null,null,null,"TOTAL WASTE WATER BILLED",{"$f":"IF($H$13=\"(Select Unit)\",\"-\",$H$13)","v":"-"},null,null,null,"$"]
[null,"Total kWh consumed during time period",null,null,null,null,"TOTAL KWH  COMSUMED DURING TIME PERIOD","kWh",null,null,null,"$",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total kWh consumed during time period",null,null,null,null,"TOTAL KWH  COMSUMED DURING TIME PERIOD","kWh",null,null,null,"$"]
[null,"Total Fuel Used",null,null,null,null,null,null,null,{"$f":"J17","v":0},{"$f":"K17","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Fuel Used",null,null,null,null,null,null,null,{"$f":"AP17","v":0},{"$f":"AQ17","v":0}]
[null,"Total water treatment chemicals purchased during time period",null,null,null,null,"TOTAL WATER TREATMENTCHEMCIAL PURCHASED DURING  TIME PERIOD",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,"Total water treatment chemicals purchased during time period",null,null,null,null,"TOTAL WATER TREATMENTCHEMCIAL PURCHASED DURING  TIME PERIOD",null,null,null,null,"$"]
[null,"Total operator/maintenance cost for time period",null,null,null,null,"TOTAL MAINTANCE COST FOR TIME PERIOD",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,"Total operator/maintenance cost for time period",null,null,null,null,"TOTAL MAINTANCE COST FOR TIME PERIOD",null,null,null,null,"$"]

{"sheet":"Cost and Results Tab","index":2,"n_rows":30,"n_cols":35,"rows_kept":30,"cut":false,"hidden":false,"merged":[[29,2,29,4],[29,5,29,7],[29,9,29,13],[1,1,2,14],[4,16,4,20],[6,1,6,14],[7,1,7,3],[7,4,7,6],[7,8,7,14],[8,1,8,3],[8,4,8,6],[8,8,8,14],[10,1,10,3],[10,4,10,6],[10,8,10,14],[12,1,12,3],[12,4,12,6],[12,8,12,14],[15,1,15,14],[16,1,16,3],[16,4,16,6],[16,8,16,14],[18,1,18,3],[18,4,18,6],[18,8,18,14],[17,1,17,3],[17,4,17,6],[17,8,17,14],[19,1,19,3],[19,4,19,6],[19,8,19,14],[20,1,20,3],[20,4,20,6],[20,8,20,14],[21,1,21,3],[21,4,21,6],[21,8,21,14],[24,2,24,4],[24,5,24,7],[24,9,24,13],[23,1,23,13],[25,2,25,4],[25,5,25,7],[25,9,25,13],[26,2,26,4],[26,5,26,7],[26,9,26,13],[27,2,27,4],[27,5,27,7],[27,9,27,13],[28,2,28,4],[28,5,28,7],[28,9,28,13]]}
[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,null,null,"(Select %)","(Select %)","(Select %)","(Select %)","(Select %)","(Select Type)"]
[null,"Water Tool - Cost And Results Page",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,"Default","Between 10% and 20%","Default","Default","Default","Heating"]
[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,null,null,0.1,"Between 20% and 50%",0.1,0.05,0.05,"Refrigeration"]
[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,null,null,0.15,"Between 50% and 75%",0.2,0.1,0.1,"Heating & Refrigeration"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Map Key",null,null,null,null,null,null,"Heating",{"$f":"E22-#REF!","v":{"$error":"#REF!"}},null,null,null,null,0.2,1,0.3,0.15,0.15,"No Heating & Refrigeration "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","Category Description",null,null,null,null,null,"Refrigeration",{"$f":"E22-#REF!","v":{"$error":"#REF!"}},null,null,null,null,0.25,"Other (Operator input)",0.4,0.2,0.2]
[null,"Water Cost Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","Operator Input / Drop Down Cells",null,null,null,null,null,"Heating & Refrigeration",{"$f":"E22","v":0},null,null,null,null,"Other (Operator input)",null,0.5,"Other (Operator input)",0.25]
[null,"System / Service",null,null,"Estimated % of Total Cost ",null,null,"Units","Comments / Notes",null,null,null,null,null,null,null,"-","Calculated Value Cells",null,null,null,null,null,"No Heating & Refrigeration ",{"$f":"E22-(#REF!+#REF!)","v":{"$error":"#REF!"}},null,null,null,null,null,null,"Other (Operator input)",null,"Other (Operator input)"]
[null,"Chemicals",null,null,"(Select %)",null,null,"$",null,null,null,null,null,null,null,null,"-","Automatically Filled Cell"]
[null,null,null,null,{"$f":"IF(E9=\"Default\",0.3,IF(E9=\"50%+\",0.5,E9))","v":"(Select %)"}]
[null,"Maintenance",null,null,"(Select %)",null,null,"$"]
[null,null,null,null,{"$f":"IF(E11=\"Default\",0.05,E11)","v":"(Select %)"}]
[null,"Pumping",null,null,"(Select %)",null,null,"$"]
[null,null,null,null,null,{"$f":"IF(E13=\"Default\",0.2,E13)","v":"(Select %)"}]
[]
[null,"Plant Results"]
[null,"Area",null,null,"Cost / Thousand Units of Water",null,null,"Units","Comments / Notes"]
[null,"Water Cost",null,null,{"$f":"IF('Input Data'!K14=\"\",\"-\",('Input Data'!K14+'Input Data'!K16)/('Input Data'!J13/1000))","v":"-"},null,null,{"$f":"IF('Input Data'!$H$13=\"(Select Unit)\",\"-\",'Input Data'!$H$13)","v":"-"}]
[null,"Chemical Cost",null,null,{"$f":"IF(E10=\"(Select %)\",\"-\",(E10*'Input Data'!K19)/('Input Data'!J13/1000))","v":"-"},null,null,{"$f":"IF('Input Data'!$H$13=\"(Select Unit)\",\"-\",'Input Data'!$H$13)","v":"-"}]
[null,"Operator/Maintenance Cost",null,null,{"$f":"IF(E12=\"(Select %)\",\"-\",('Input Data'!K20*'Cost and Results Tab'!E12)/('Input Data'!J13/1000))","v":"-"},null,null,{"$f":"IF('Input Data'!$H$13=\"(Select Unit)\",\"-\",'Input Data'!$H$13)","v":"-"}]
[null,"Pumping Cost",null,null,{"$f":"IF(E13=\"(Select %)\",\"-\",('Input Data'!K16*'Cost and Results Tab'!F14)/('Input Data'!J13/1000))","v":"-"},null,null,{"$f":"IF('Input Data'!$H$13=\"(Select Unit)\",\"-\",'Input Data'!$H$13)","v":"-"}]
[null,"Total Cost of Water",null,null,{"$f":"SUM(E18:G21)","v":0},null,null,{"$f":"IF('Input Data'!$H$13=\"(Select Unit)\",\"-\",'Input Data'!$H$13)","v":"-"}]
[]
[null,"System Or Area Cost Calculations "]
[null,"Item No.","Analysis Type",null,null,"Estimated Volume of Water ",null,null,"Units","Estimated Total Embedded Cost of Water"]
[null,1,"Enter Area Name",null,null,"Enter Volume",null,null,{"$f":"IF('Input Data'!$H$13=\"(Select Unit)\",\"-\",'Input Data'!$H$13)","v":"-"},{"$f":"IF(F26=\"Enter Volume\",\"-\",($E$22/1000)*F26)","v":"-"}]
[null,2,"Enter Area Name",null,null,"Enter Volume",null,null,{"$f":"IF('Input Data'!$H$13=\"(Select Unit)\",\"-\",'Input Data'!$H$13)","v":"-"},{"$f":"IF(F27=\"Enter Volume\",\"-\",($E$22/1000)*F27)","v":"-"}]
[null,3,"Enter Area Name",null,null,"Enter Volume",null,null,{"$f":"IF('Input Data'!$H$13=\"(Select Unit)\",\"-\",'Input Data'!$H$13)","v":"-"},"-"]
[null,4,"Enter Area Name",null,null,"Enter Volume",null,null,{"$f":"IF('Input Data'!$H$13=\"(Select Unit)\",\"-\",'Input Data'!$H$13)","v":"-"},"-"]
[null,5,"Enter Area Name",null,null,"Enter Volume",null,null,{"$f":"IF('Input Data'!$H$13=\"(Select Unit)\",\"-\",'Input Data'!$H$13)","v":"-"},{"$f":"IF(F30=\"Enter Volume\",\"-\",($E$22/1000)*F30)","v":"-"}]