{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","Solar","Bio-gas","Wind","Geo Thermal","Other","Results Page "],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":0,"comments":6,"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":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"Brewers Association Renewable Energy Tool"]
[null,"Guidance  / Instructions"]
[]
[null,"Overview"]
[null,"This tool is designed to help evaluate cost effective renewable energy options."]
[]
[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.  The user can access the \"Instructions\" page , for 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.  If the cell is not applicable, leave it blank or enter \"0\".  "]
[]
[null,"To navigate from one area to another click on any Icon in the workbook or select the tab at the bottom of the page"]

{"sheet":"Solar","index":1,"n_rows":25,"n_cols":19,"rows_kept":25,"cut":false,"hidden":false,"merged":[[17,2,17,3],[12,2,12,3],[17,4,17,5],[5,6,5,8],[12,6,12,7],[13,6,13,7],[16,6,16,7],[17,6,17,7],[11,1,11,7],[16,2,16,3],[16,4,16,5],[1,1,1,3],[13,2,13,3],[3,1,3,3],[12,4,12,5],[13,4,13,5],[4,5,4,8],[6,6,6,8],[7,6,7,8],[8,6,8,8]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Select Unit",null,null,"Select Offset","-","-"]
[null,"Calculating the Cost of Renewable Energy",null,null,null,null,null,null,null,null,null,null,"Solar PV",{"$f":"D6","v":"Enter Quantity"},null,"Electrical Energy",{"$f":"IF(D6=\"Enter Quantity\",\"-\",D6-D15)","v":"-"},{"$f":"D7/D6","v":{"$error":"#VALUE!"}},"Price per unit"]
[null,null,null,null,null,null,null,null,null,"Select Unit","-",null,"Wind",{"$f":"D6","v":"Enter Quantity"},null,"Fuel Energy",{"$f":"IF(D8=\"Enter Quantity\",\"-\",D8-D15)","v":"-"},{"$f":"D9/D8","v":{"$error":"#VALUE!"}},"Price per unit"]
[null,"Current Energy Situation",null,null,null,null,null,null,null,"kWh",1,null,"Thermal",{"$f":"$D$10","v":"-"}]
[null,null,"Unit","Amount",null,"Map Key",null,null,null,"therm",29.307220000000001,null,"Bio-Gas",{"$f":"$D$10","v":"-"}]
[null,"Total Electrical Purchased","kWh","Enter Quantity",null,"-","Category Description",null,null,"MMBtu",0.29307109999999997,null,"Bio-Mass",{"$f":"$D$10","v":"-"}]
[null,"Total Electrical Energy Cost","$","Enter Cost",null,"-","Operator Input / Drop Down Cells",null,null,null,null,null,"Geothermal",{"$f":"$D$10","v":"-"}]
[null,"Total Fuel Purchased","Select Unit","Enter Quantity",null,"-","Calculated Value Cells",null,null,null,null,null,"Other",{"$f":"D6","v":"Enter Quantity"}]
[null,"Total Fuel Cost","$","Enter Cost",null,"-","Automatically Filled Cell"]
[null,{"$f":"VLOOKUP(C8,J3:K6,2,FALSE)","v":"-"},"kWh",{"$f":"IF(B10=\"-\",\"-\",D8*B10)","v":"-"}]
[null,"Total Energy Used","kWh",{"$f":"IF(D10=\"-\",\"-\",D6+D10)","v":"-"}]
[null,"Proposed Project"]
[null,"Renewable Energy Type","Solar Energy Option 1",null,"Solar Energy Option 2",null,"Solar Energy Option 3"]
[null,"Renewable Energy Project Name","Enter Project Type/Name",null,"Enter Project Type/Name",null,"Enter Project Type/Name"]
[null,"Estimated Energy Produced/Saved Annually","kWh","Enter Quantity","kWh","Enter Quantity","kWh","Enter Quantity"]
[null,"Estimated Cost for System","$","Enter Cost","$","Enter Cost","$","Enter Cost"]
[null,null,"Results Option 1",null,"Results Option 2",null,"Results Option 3"]
[null,"Energy Offset Type","Select Offset",null,"Select Offset",null,"Select Offset"]
[null,"Estimated Gross Energy Savings","$",{"$f":"IF(C18=\"Select Offset\",\"-\",VLOOKUP(C18,P1:R3,3,FALSE)*D15)","v":"-"},"$",{"$f":"IF(E18=\"Select Offset\",\"-\",VLOOKUP(E18,P1:R3,3,FALSE)*F15)","v":"-"},"$",{"$f":"IF(G18=\"Select Offset\",\"-\",VLOOKUP(G18,P1:R3,3,FALSE)*H15)","v":"-"}]
[null,"Estimated Cost for Renewable Fuel","$","Enter Cost","$","Enter Cost","$","Enter Cost"]
[null,null,null,{"$f":"IF(D20=\"Enter Cost\",0,D20)","v":0},null,{"$f":"IF(F20=\"Enter Cost\",0,F20)","v":0},null,{"$f":"IF(H20=\"Enter Cost\",0,H20)","v":0}]
[null,"Estimated Annual Maintenance Cost","$","Enter Cost","$","Enter Cost","$","Enter Cost"]
[null,null,null,{"$f":"IF(D22=\"Enter Cost\",0,D22)","v":0},null,{"$f":"IF(F22=\"Enter Cost\",0,F22)","v":0},null,{"$f":"IF(H22=\"Enter Cost\",0,H22)","v":0}]
[null,"Total Estimated Energy Cost Savings","$",{"$f":"IF(D19=\"-\",\"-\",D19-D21-D23)","v":"-"},"$",{"$f":"IF(F19=\"-\",\"-\",F19-F21-F23)","v":"-"},"$",{"$f":"IF(H19=\"-\",\"-\",H19-H21-H23)","v":"-"}]
[null,"Simple Payback","Year",{"$f":"IF(D24=\"-\",\"-\",D16/D24)","v":"-"},"Year",{"$f":"IF(F24=\"-\",\"-\",F16/F24)","v":"-"},"Year",{"$f":"IF(H24=\"-\",\"-\",H16/H24)","v":"-"}]

{"sheet":"Bio-gas","index":2,"n_rows":25,"n_cols":19,"rows_kept":25,"cut":false,"hidden":false,"merged":[[17,4,17,5],[17,6,17,7],[13,4,13,5],[13,6,13,7],[16,2,16,3],[16,4,16,5],[16,6,16,7],[17,2,17,3],[1,1,1,3],[3,1,3,3],[12,2,12,3],[13,2,13,3],[4,5,4,8],[5,6,5,8],[6,6,6,8],[7,6,7,8],[8,6,8,8],[11,1,11,7],[12,4,12,5],[12,6,12,7]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Select Unit",null,null,"Select Offset","-","-"]
[null,"Calculating the Cost of Renewable Energy",null,null,null,null,null,null,null,null,null,null,"Bio-gas PV",{"$f":"D6","v":"Enter Quantity"},null,"Electrical Energy",{"$f":"IF(D6=\"Enter Quantity\",\"-\",D6-D15)","v":"-"},{"$f":"D7/D6","v":{"$error":"#VALUE!"}},"Price per unit"]
[null,null,null,null,null,null,null,null,null,"Select Unit","-",null,"Wind",{"$f":"D6","v":"Enter Quantity"},null,"Fuel Energy",{"$f":"IF(D8=\"Enter Quantity\",\"-\",D8-D15)","v":"-"},{"$f":"D9/D8","v":{"$error":"#VALUE!"}},"Price per unit"]
[null,"Current Energy Situation",null,null,null,null,null,null,null,"kWh",1,null,"Thermal",{"$f":"$D$10","v":"-"}]
[null,null,"Unit","Amount",null,"Map Key",null,null,null,"therm",29.307220000000001,null,"Bio-Gas",{"$f":"$D$10","v":"-"}]
[null,"Total Electrical Purchased","kWh","Enter Quantity",null,"-","Category Description",null,null,"MMBtu",0.29307109999999997,null,"Bio-Mass",{"$f":"$D$10","v":"-"}]
[null,"Total Electrical Energy Cost","$","Enter Cost",null,"-","Operator Input / Drop Down Cells",null,null,null,null,null,"Geothermal",{"$f":"$D$10","v":"-"}]
[null,"Total Fuel Purchased","Select Unit","Enter Quantity",null,"-","Calculated Value Cells",null,null,null,null,null,"Other",{"$f":"D6","v":"Enter Quantity"}]
[null,"Total Fuel Cost","$","Enter Cost",null,"-","Automatically Filled Cell"]
[null,{"$f":"VLOOKUP(C8,J3:K6,2,FALSE)","v":"-"},"kWh",{"$f":"IF(B10=\"-\",\"-\",D8*B10)","v":"-"}]
[null,"Total Energy Used","kWh",{"$f":"IF(D10=\"-\",\"-\",D6+D10)","v":"-"}]
[null,"Proposed Project"]
[null,"Renewable Energy Type","Bio-gas Energy Option 1",null,"Bio-gas Energy Option 2",null,"Bio-gas Energy Option 3"]
[null,"Renewable Energy Project Name","Enter Project Type/Name",null,"Enter Project Type/Name",null,"Enter Project Type/Name"]
[null,"Estimated Energy Produced/Saved Annually","kWh","Enter Quantity","kWh","Enter Quantity","kWh","Enter Quantity"]
[null,"Estimated Cost for System","$","Enter Cost","$","Enter Cost","$","Enter Cost"]
[null,null,"Results Option 1",null,"Results Option 2",null,"Results Option 3"]
[null,"Energy Offset Type","Select Offset",null,"Select Offset",null,"Select Offset"]
[null,"Estimated Gross Energy Savings","$",{"$f":"IF(C18=\"Select Offset\",\"-\",VLOOKUP(C18,P1:R3,3,FALSE)*D15)","v":"-"},"$",{"$f":"IF(E18=\"Select Offset\",\"-\",VLOOKUP(E18,P1:R3,3,FALSE)*F15)","v":"-"},"$",{"$f":"IF(G18=\"Select Offset\",\"-\",VLOOKUP(G18,P1:R3,3,FALSE)*H15)","v":"-"}]
[null,"Estimated Cost for Renewable Fuel","$","Enter Cost","$","Enter Cost","$","Enter Cost"]
[null,null,null,{"$f":"IF(D20=\"Enter Cost\",0,D20)","v":0},null,{"$f":"IF(F20=\"Enter Cost\",0,F20)","v":0},null,{"$f":"IF(H20=\"Enter Cost\",0,H20)","v":0}]
[null,"Estimated Annual Maintenance Cost","$","Enter Cost","$","Enter Cost","$","Enter Cost"]
[null,null,null,{"$f":"IF(D22=\"Enter Cost\",0,D22)","v":0},null,{"$f":"IF(F22=\"Enter Cost\",0,F22)","v":0},null,{"$f":"IF(H22=\"Enter Cost\",0,H22)","v":0}]
[null,"Total Estimated Energy Cost Savings","$",{"$f":"IF(D19=\"-\",\"-\",D19-D21-D23)","v":"-"},"$",{"$f":"IF(F19=\"-\",\"-\",F19-F21-F23)","v":"-"},"$",{"$f":"IF(H19=\"-\",\"-\",H19-H21-H23)","v":"-"}]
[null,"Simple Payback","Year",{"$f":"IF(D24=\"-\",\"-\",D16/D24)","v":"-"},"Year",{"$f":"IF(F24=\"-\",\"-\",F16/F24)","v":"-"},"Year",{"$f":"IF(H24=\"-\",\"-\",H16/H24)","v":"-"}]

{"sheet":"Wind","index":3,"n_rows":25,"n_cols":19,"rows_kept":25,"cut":false,"hidden":false,"merged":[[17,4,17,5],[17,6,17,7],[13,4,13,5],[13,6,13,7],[16,2,16,3],[16,4,16,5],[16,6,16,7],[17,2,17,3],[1,1,1,3],[3,1,3,3],[12,2,12,3],[13,2,13,3],[4,5,4,8],[5,6,5,8],[6,6,6,8],[7,6,7,8],[8,6,8,8],[11,1,11,7],[12,4,12,5],[12,6,12,7]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Select Unit",null,null,"Select Offset","-","-"]
[null,"Calculating the Cost of Renewable Energy",null,null,null,null,null,null,null,null,null,null,"Wind PV",{"$f":"D6","v":"Enter Quantity"},null,"Electrical Energy",{"$f":"IF(D6=\"Enter Quantity\",\"-\",D6-D15)","v":"-"},{"$f":"D7/D6","v":{"$error":"#VALUE!"}},"Price per unit"]
[null,null,null,null,null,null,null,null,null,"Select Unit","-",null,"Wind",{"$f":"D6","v":"Enter Quantity"},null,"Fuel Energy",{"$f":"IF(D8=\"Enter Quantity\",\"-\",D8-D15)","v":"-"},{"$f":"D9/D8","v":{"$error":"#VALUE!"}},"Price per unit"]
[null,"Current Energy Situation",null,null,null,null,null,null,null,"kWh",1,null,"Thermal",{"$f":"$D$10","v":"-"}]
[null,null,"Unit","Amount",null,"Map Key",null,null,null,"therm",29.307220000000001,null,"Wind",{"$f":"$D$10","v":"-"}]
[null,"Total Electrical Purchased","kWh","Enter Quantity",null,"-","Category Description",null,null,"MMBtu",0.29307109999999997,null,"Bio-Mass",{"$f":"$D$10","v":"-"}]
[null,"Total Electrical Energy Cost","$","Enter Cost",null,"-","Operator Input / Drop Down Cells",null,null,null,null,null,"Geothermal",{"$f":"$D$10","v":"-"}]
[null,"Total Fuel Purchased","Select Unit","Enter Quantity",null,"-","Calculated Value Cells",null,null,null,null,null,"Other",{"$f":"D6","v":"Enter Quantity"}]
[null,"Total Fuel Cost","$","Enter Cost",null,"-","Automatically Filled Cell"]
[null,{"$f":"VLOOKUP(C8,J3:K6,2,FALSE)","v":"-"},"kWh",{"$f":"IF(B10=\"-\",\"-\",D8*B10)","v":"-"}]
[null,"Total Energy Used","kWh",{"$f":"IF(D10=\"-\",\"-\",D6+D10)","v":"-"}]
[null,"Proposed Project"]
[null,"Renewable Energy Type","Wind Energy Option 1",null,"Wind Energy Option 2",null,"Wind Energy Option 3"]
[null,"Renewable Energy Project Name","Enter Project Type/Name",null,"Enter Project Type/Name",null,"Enter Project Type/Name"]
[null,"Estimated Energy Produced/Saved Annually","kWh","Enter Quantity","kWh","Enter Quantity","kWh","Enter Quantity"]
[null,"Estimated Cost for System","$","Enter Cost","$","Enter Cost","$","Enter Cost"]
[null,null,"Results Option 1",null,"Results Option 2",null,"Results Option 3"]
[null,"Energy Offset Type","Select Offset",null,"Select Offset",null,"Select Offset"]
[null,"Estimated Gross Energy Savings","$",{"$f":"IF(C18=\"Select Offset\",\"-\",VLOOKUP(C18,P1:R3,3,FALSE)*D15)","v":"-"},"$",{"$f":"IF(E18=\"Select Offset\",\"-\",VLOOKUP(E18,P1:R3,3,FALSE)*F15)","v":"-"},"$",{"$f":"IF(G18=\"Select Offset\",\"-\",VLOOKUP(G18,P1:R3,3,FALSE)*H15)","v":"-"}]
[null,"Estimated Cost for Renewable Fuel","$","Enter Cost","$","Enter Cost","$","Enter Cost"]
[null,null,null,{"$f":"IF(D20=\"Enter Cost\",0,D20)","v":0},null,{"$f":"IF(F20=\"Enter Cost\",0,F20)","v":0},null,{"$f":"IF(H20=\"Enter Cost\",0,H20)","v":0}]
[null,"Estimated Annual Maintenance Cost","$","Enter Cost","$","Enter Cost","$","Enter Cost"]
[null,null,null,{"$f":"IF(D22=\"Enter Cost\",0,D22)","v":0},null,{"$f":"IF(F22=\"Enter Cost\",0,F22)","v":0},null,{"$f":"IF(H22=\"Enter Cost\",0,H22)","v":0}]
[null,"Total Estimated Energy Cost Savings","$",{"$f":"IF(D19=\"-\",\"-\",D19-D21-D23)","v":"-"},"$",{"$f":"IF(F19=\"-\",\"-\",F19-F21-F23)","v":"-"},"$",{"$f":"IF(H19=\"-\",\"-\",H19-H21-H23)","v":"-"}]
[null,"Simple Payback","Year",{"$f":"IF(D24=\"-\",\"-\",D16/D24)","v":"-"},"Year",{"$f":"IF(F24=\"-\",\"-\",F16/F24)","v":"-"},"Year",{"$f":"IF(H24=\"-\",\"-\",H16/H24)","v":"-"}]

{"sheet":"Geo Thermal","index":4,"n_rows":25,"n_cols":19,"rows_kept":25,"cut":false,"hidden":false,"merged":[[17,4,17,5],[17,6,17,7],[13,4,13,5],[13,6,13,7],[16,2,16,3],[16,4,16,5],[16,6,16,7],[17,2,17,3],[1,1,1,3],[3,1,3,3],[12,2,12,3],[13,2,13,3],[4,5,4,8],[5,6,5,8],[6,6,6,8],[7,6,7,8],[8,6,8,8],[11,1,11,7],[12,4,12,5],[12,6,12,7]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Select Unit",null,null,"Select Offset","-","-"]
[null,"Calculating the Cost of Renewable Energy",null,null,null,null,null,null,null,null,null,null,"Geo Thermal PV",{"$f":"D6","v":"Enter Quantity"},null,"Electrical Energy",{"$f":"IF(D6=\"Enter Quantity\",\"-\",D6-D15)","v":"-"},{"$f":"D7/D6","v":{"$error":"#VALUE!"}},"Price per unit"]
[null,null,null,null,null,null,null,null,null,"Select Unit","-",null,"Geo Thermal",{"$f":"D6","v":"Enter Quantity"},null,"Fuel Energy",{"$f":"IF(D8=\"Enter Quantity\",\"-\",D8-D15)","v":"-"},{"$f":"D9/D8","v":{"$error":"#VALUE!"}},"Price per unit"]
[null,"Current Energy Situation",null,null,null,null,null,null,null,"kWh",1,null,"Thermal",{"$f":"$D$10","v":"-"}]
[null,null,"Unit","Amount",null,"Map Key",null,null,null,"therm",29.307220000000001,null,"Geo Thermal",{"$f":"$D$10","v":"-"}]
[null,"Total Electrical Purchased","kWh","Enter Quantity",null,"-","Category Description",null,null,"MMBtu",0.29307109999999997,null,"Bio-Mass",{"$f":"$D$10","v":"-"}]
[null,"Total Electrical Energy Cost","$","Enter Cost",null,"-","Operator Input / Drop Down Cells",null,null,null,null,null,"Geothermal",{"$f":"$D$10","v":"-"}]
[null,"Total Fuel Purchased","Select Unit","Enter Quantity",null,"-","Calculated Value Cells",null,null,null,null,null,"Other",{"$f":"D6","v":"Enter Quantity"}]
[null,"Total Fuel Cost","$","Enter Cost",null,"-","Automatically Filled Cell"]
[null,{"$f":"VLOOKUP(C8,J3:K6,2,FALSE)","v":"-"},"kWh",{"$f":"IF(B10=\"-\",\"-\",D8*B10)","v":"-"}]
[null,"Total Energy Used","kWh",{"$f":"IF(D10=\"-\",\"-\",D6+D10)","v":"-"}]
[null,"Proposed Project"]
[null,"Renewable Energy Type","Geo Thermal Energy Option 1",null,"Geo Thermal Energy Option 2",null,"Geo Thermal Energy Option 3"]
[null,"Renewable Energy Project Name","Enter Project Type/Name",null,"Enter Project Type/Name",null,"Enter Project Type/Name"]
[null,"Estimated Energy Produced/Saved Annually","kWh","Enter Quantity","kWh","Enter Quantity","kWh","Enter Quantity"]
[null,"Estimated Cost for System","$","Enter Cost","$","Enter Cost","$","Enter Cost"]
[null,null,"Results Option 1",null,"Results Option 2",null,"Results Option 3"]
[null,"Energy Offset Type","Select Offset",null,"Select Offset",null,"Select Offset"]
[null,"Estimated Gross Energy Savings","$",{"$f":"IF(C18=\"Select Offset\",\"-\",VLOOKUP(C18,P1:R3,3,FALSE)*D15)","v":"-"},"$",{"$f":"IF(E18=\"Select Offset\",\"-\",VLOOKUP(E18,P1:R3,3,FALSE)*F15)","v":"-"},"$",{"$f":"IF(G18=\"Select Offset\",\"-\",VLOOKUP(G18,P1:R3,3,FALSE)*H15)","v":"-"}]
[null,"Estimated Cost for Renewable Fuel","$","Enter Cost","$","Enter Cost","$","Enter Cost"]
[null,null,null,{"$f":"IF(D20=\"Enter Cost\",0,D20)","v":0},null,{"$f":"IF(F20=\"Enter Cost\",0,F20)","v":0},null,{"$f":"IF(H20=\"Enter Cost\",0,H20)","v":0}]
[null,"Estimated Annual Maintenance Cost","$","Enter Cost","$","Enter Cost","$","Enter Cost"]
[null,null,null,{"$f":"IF(D22=\"Enter Cost\",0,D22)","v":0},null,{"$f":"IF(F22=\"Enter Cost\",0,F22)","v":0},null,{"$f":"IF(H22=\"Enter Cost\",0,H22)","v":0}]
[null,"Total Estimated Energy Cost Savings","$",{"$f":"IF(D19=\"-\",\"-\",D19-D21-D23)","v":"-"},"$",{"$f":"IF(F19=\"-\",\"-\",F19-F21-F23)","v":"-"},"$",{"$f":"IF(H19=\"-\",\"-\",H19-H21-H23)","v":"-"}]
[null,"Simple Payback","Year",{"$f":"IF(D24=\"-\",\"-\",D16/D24)","v":"-"},"Year",{"$f":"IF(F24=\"-\",\"-\",F16/F24)","v":"-"},"Year",{"$f":"IF(H24=\"-\",\"-\",H16/H24)","v":"-"}]

{"sheet":"Other","index":5,"n_rows":25,"n_cols":19,"rows_kept":25,"cut":false,"hidden":false,"merged":[[17,4,17,5],[17,6,17,7],[13,4,13,5],[13,6,13,7],[16,2,16,3],[16,4,16,5],[16,6,16,7],[17,2,17,3],[1,1,1,3],[3,1,3,3],[12,2,12,3],[13,2,13,3],[4,5,4,8],[5,6,5,8],[6,6,6,8],[7,6,7,8],[8,6,8,8],[11,1,11,7],[12,4,12,5],[12,6,12,7]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Select Unit",null,null,"Select Offset","-","-"]
[null,"Calculating the Cost of Renewable Energy",null,null,null,null,null,null,null,null,null,null,"Other PV",{"$f":"D6","v":"Enter Quantity"},null,"Electrical Energy",{"$f":"IF(D6=\"Enter Quantity\",\"-\",D6-D15)","v":"-"},{"$f":"D7/D6","v":{"$error":"#VALUE!"}},"Price per unit"]
[null,null,null,null,null,null,null,null,null,"Select Unit","-",null,"Other",{"$f":"D6","v":"Enter Quantity"},null,"Fuel Energy",{"$f":"IF(D8=\"Enter Quantity\",\"-\",D8-D15)","v":"-"},{"$f":"D9/D8","v":{"$error":"#VALUE!"}},"Price per unit"]
[null,"Current Energy Situation",null,null,null,null,null,null,null,"kWh",1,null,"Thermal",{"$f":"$D$10","v":"-"}]
[null,null,"Unit","Amount",null,"Map Key",null,null,null,"therm",29.307220000000001,null,"Other",{"$f":"$D$10","v":"-"}]
[null,"Total Electrical Purchased","kWh","Enter Quantity",null,"-","Category Description",null,null,"MMBtu",0.29307109999999997,null,"Bio-Mass",{"$f":"$D$10","v":"-"}]
[null,"Total Electrical Energy Cost","$","Enter Cost",null,"-","Operator Input / Drop Down Cells",null,null,null,null,null,"Geothermal",{"$f":"$D$10","v":"-"}]
[null,"Total Fuel Purchased","Select Unit","Enter Quantity",null,"-","Calculated Value Cells",null,null,null,null,null,"Other",{"$f":"D6","v":"Enter Quantity"}]
[null,"Total Fuel Cost","$","Enter Cost",null,"-","Automatically Filled Cell"]
[null,{"$f":"VLOOKUP(C8,J3:K6,2,FALSE)","v":"-"},"kWh",{"$f":"IF(B10=\"-\",\"-\",D8*B10)","v":"-"}]
[null,"Total Energy Used","kWh",{"$f":"IF(D10=\"-\",\"-\",D6+D10)","v":"-"}]
[null,"Proposed Project"]
[null,"Renewable Energy Type","Other Energy Option 1",null,"Other Energy Option 2",null,"Other Energy Option 3"]
[null,"Renewable Energy Project Name","Enter Project Type/Name",null,"Enter Project Type/Name",null,"Enter Project Type/Name"]
[null,"Estimated Energy Produced/Saved Annually","kWh","Enter Quantity","kWh","Enter Quantity","kWh","Enter Quantity"]
[null,"Estimated Cost for System","$","Enter Cost","$","Enter Cost","$","Enter Cost"]
[null,null,"Results Option 1",null,"Results Option 2",null,"Results Option 3"]
[null,"Energy Offset Type","Select Offset",null,"Select Offset",null,"Select Offset"]
[null,"Estimated Gross Energy Savings","$",{"$f":"IF(C18=\"Select Offset\",\"-\",VLOOKUP(C18,P1:R3,3,FALSE)*D15)","v":"-"},"$",{"$f":"IF(E18=\"Select Offset\",\"-\",VLOOKUP(E18,P1:R3,3,FALSE)*F15)","v":"-"},"$",{"$f":"IF(G18=\"Select Offset\",\"-\",VLOOKUP(G18,P1:R3,3,FALSE)*H15)","v":"-"}]
[null,"Estimated Cost for Renewable Fuel","$","Enter Cost","$","Enter Cost","$","Enter Cost"]
[null,null,null,{"$f":"IF(D20=\"Enter Cost\",0,D20)","v":0},null,{"$f":"IF(F20=\"Enter Cost\",0,F20)","v":0},null,{"$f":"IF(H20=\"Enter Cost\",0,H20)","v":0}]
[null,"Estimated Annual Maintenance Cost","$","Enter Cost","$","Enter Cost","$","Enter Cost"]
[null,null,null,{"$f":"IF(D22=\"Enter Cost\",0,D22)","v":0},null,{"$f":"IF(F22=\"Enter Cost\",0,F22)","v":0},null,{"$f":"IF(H22=\"Enter Cost\",0,H22)","v":0}]
[null,"Total Estimated Energy Cost Savings","$",{"$f":"IF(D19=\"-\",\"-\",D19-D21-D23)","v":"-"},"$",{"$f":"IF(F19=\"-\",\"-\",F19-F21-F23)","v":"-"},"$",{"$f":"IF(H19=\"-\",\"-\",H19-H21-H23)","v":"-"}]
[null,"Simple Payback","Year",{"$f":"IF(D24=\"-\",\"-\",D16/D24)","v":"-"},"Year",{"$f":"IF(F24=\"-\",\"-\",F16/F24)","v":"-"},"Year",{"$f":"IF(H24=\"-\",\"-\",H16/H24)","v":"-"}]

{"sheet":"Results Page ","index":6,"n_rows":16,"n_cols":21,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,3,1,10]]}
[null,null,null,"Renewable Energy Result Page",null,null,null,null,null,null,null,null,null,null,null,null,null,"Select Option"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Option 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Option 2"]
[null,"Technology","Select Option","Project Name","Fuel Concerns","Energy Savings/Offsets (kWh/Year)","Environmental Impact","Incentives, rebates, grants","Infrastructure Modifications","Capital Cost","Return on Investment (Years)","Recommendations",null,null,null,null,null,"Option 3",null,null,"Select One"]
[null,"Example","Option 1","Rooftop PV","Sun Class 3","100 kWh/yr","Yes, Water","Tax Credit","Yes, Roof",15000,"5.5 years","Hold, Until economics are more favorable",null,null,null,null,null,null,null,null,"Hold, Until economics are more favorable"]
[null,"PV Solar","Option 2",{"$f":"IF(C6=\"Select Option\",\"-\",IF(C6=\"Option 1\",Solar!C14,IF('Results Page '!C6=\"Option 2\",Solar!E14,Solar!G14)))","v":"Enter Project Type/Name"},null,{"$f":"IF(C6=\"Select Option\",\"-\",IF(C6=\"Option 1\",Solar!D15,IF('Results Page '!C6=\"Option 2\",Solar!F15,Solar!H15)))","v":"Enter Quantity"},null,null,null,{"$f":"IF(C6=\"Select Option\",\"-\",IF(C6=\"Option 1\",Solar!D16,IF('Results Page '!C6=\"Option 2\",Solar!F16,Solar!H16)))","v":"Enter Cost"},{"$f":"IF(C6=\"Select Option\",\"-\",IF(C6=\"Option 1\",Solar!D25,IF('Results Page '!C6=\"Option 2\",Solar!F25,Solar!H25)))","v":"-"},"Select One",null,null,null,null,null,null,null,null,"Move forward with project development"]
[null,"Bio-gas Cogen","Select Option",{"$f":"IF(C7=\"Select Option\",\"-\",IF(C7=\"Option 1\",'Bio-gas'!C14,IF('Results Page '!C7=\"Option 2\",'Bio-gas'!E14,'Bio-gas'!G14)))","v":"-"},null,{"$f":"IF(C7=\"Select Option\",\"-\",IF(C7=\"Option 1\",'Bio-gas'!D15,IF('Results Page '!C7=\"Option 2\",'Bio-gas'!F15,'Bio-gas'!H15)))","v":"-"},null,null,null,{"$f":"IF(C7=\"Select Option\",\"-\",IF(C7=\"Option 1\",'Bio-gas'!D16,IF('Results Page '!C7=\"Option 2\",'Bio-gas'!F16,'Bio-gas'!H16)))","v":"-"},{"$f":"IF(C7=\"Select Option\",\"-\",IF(C7=\"Option 1\",'Bio-gas'!D25,IF('Results Page '!C7=\"Option 2\",'Bio-gas'!F25,'Bio-gas'!H25)))","v":"-"},"Select One",null,null,null,null,null,null,null,null,"Move forward with detailed scope and estimate"]
[null,"Wind Generation","Select Option",{"$f":"IF(C8=\"Select Option\",\"-\",IF(C8=\"Option 1\",Wind!C14,IF('Results Page '!C8=\"Option 2\",Wind!E14,Wind!G14)))","v":"-"},null,{"$f":"IF(C8=\"Select Option\",\"-\",IF(C8=\"Option 1\",Wind!D15,IF('Results Page '!C8=\"Option 2\",Wind!F15,Wind!H15)))","v":"-"},null,null,null,{"$f":"IF(C8=\"Select Option\",\"-\",IF(C8=\"Option 1\",Wind!D16,IF('Results Page '!C8=\"Option 2\",Wind!F16,Wind!H16)))","v":"-"},{"$f":"IF(C8=\"Select Option\",\"-\",IF(C8=\"Option 1\",Wind!D25,IF('Results Page '!C8=\"Option 2\",Wind!F25,Wind!H25)))","v":"-"},"Select One",null,null,null,null,null,null,null,null,"Not applicable to study discontinued"]
[null,"Geo Thermal","Select Option",{"$f":"IF(C9=\"Select Option\",\"-\",IF(C9=\"Option 1\",'Geo Thermal'!C14,IF('Results Page '!C9=\"Option 2\",'Geo Thermal'!E14,'Geo Thermal'!G14)))","v":"-"},null,{"$f":"IF(C9=\"Select Option\",\"-\",IF(C9=\"Option 1\",'Geo Thermal'!D15,IF('Results Page '!C9=\"Option 2\",'Geo Thermal'!F15,'Geo Thermal'!H15)))","v":"-"},null,null,null,{"$f":"IF(C9=\"Select Option\",\"-\",IF(C9=\"Option 1\",'Geo Thermal'!D16,IF('Results Page '!C9=\"Option 2\",'Geo Thermal'!F16,'Geo Thermal'!H16)))","v":"-"},{"$f":"IF(C9=\"Select Option\",\"-\",IF(C9=\"Option 1\",'Geo Thermal'!D25,IF('Results Page '!C9=\"Option 2\",'Geo Thermal'!F25,'Geo Thermal'!H25)))","v":"-"},"Select One",null,null,null,null,null,null,null,null,"Not applicable to site"]
[null,"Other","Select Option",{"$f":"IF(C10=\"Select Option\",\"-\",IF(C10=\"Option 1\",Other!C14,IF('Results Page '!C10=\"Option 2\",Other!E14,Other!G14)))","v":"-"},null,{"$f":"IF(C10=\"Select Option\",\"-\",IF(C10=\"Option 1\",Other!D15,IF('Results Page '!C10=\"Option 2\",Other!F15,Other!H15)))","v":"-"},null,null,null,{"$f":"IF(C10=\"Select Option\",\"-\",IF(C10=\"Option 1\",Other!D16,IF('Results Page '!C10=\"Option 2\",Other!F16,Other!H16)))","v":"-"},{"$f":"IF(C10=\"Select Option\",\"-\",IF(C10=\"Option 1\",Other!D25,IF('Results Page '!C10=\"Option 2\",Other!F25,Other!H25)))","v":"-"},"Select One"]
[]
[]
[]
[]
[]
[null,"Example Chart"]