{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Introduction","Data Input and Instructions","Summary of results","PrintSheet","Comparative","One Street Light Example","Unit Pricing BAU","unit pricing 1-5 years scenario","ballast losses","GHG Calculator","GHG savings","Assumptions"],"not_rendered":{"charts":1,"images":5,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"Introduction","index":0,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"LED Streetlights Across BC Project Evaluation Tool"]
[null,"Disclaimer:"]
[]
[null,"• The Government of British Columbia (\"The Province\") makes no representation or warranty with respect to the accuracy or completeness of any estimates generated by the Estimator. The Province accepts no liability of any kind arising out of a user’s use of or reliance of the Estimator."]
[]
[null,"• The estimates are intended for illustrative purposes only. They are based on values entered by the user and should not be considered an exact forecast of incentives."]
[]
[null,"• The Estimator is intended for municipal organizations with street lighting to estimate the financial benefits of LED and controls with street lighting. This Estimator is to provide estimates of financial and energy savings as a starting point, but these estimates can vary widely, and customers are responsible for verifying their actual energy savings. "]
[]
[null,"• The tool only applies to existing street lights located in the province of British Columbia, within the area served by BC Hydro, and under the 1702 or 1703 tariffs."]
[]
[null,"• All calculations are based on various assumptions and it is the sole responsibility of each customer to verify input and output data. "]
[]
[null,"• The customer indemnifies BC Hydro and The Province of any decisions made by the customer based on information provided by this Estimator."]

{"sheet":"Data Input and Instructions","index":1,"n_rows":72,"n_cols":27,"rows_kept":72,"cut":false,"hidden":true,"merged":[[69,1,69,3],[2,2,2,3],[36,1,36,3],[57,1,57,3],[22,1,22,3],[3,2,3,3],[9,1,9,3],[61,1,61,3],[64,1,64,3],[48,1,48,3],[5,2,5,3],[7,2,7,3],[23,2,23,3],[1,1,1,3],[37,1,37,3],[4,2,4,3],[6,2,6,3],[35,1,35,3],[10,2,10,3],[24,3,33,3]]}
[null,null,null,null,null,{"$f":"\"LED Street Lights Project Evaluation for \"&C3","v":"LED Street Lights Project Evaluation for "}]
[null,"Step 1: General Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PROJ_TYPES","RATES",null,"YES_NO","PROJ_YEARS"]
[null,"Name of Jurisdiction",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LED retrofit only",1702,null,"YES",1]
[null,"Contact Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LED retrofit with adaptive controls",1703,null,"NO",2]
[null,"Contact Title",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adaptive controls only",null,null,null,3]
[null,"Contact Telephone #",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,"Contact Email",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,"Date"]
[]
[null,"Step 2: Inventory"]
[null,"Rate",1702]
[null,"Total Streetlight Quantities","1701 Tariff","1702/1703 Tariff"]
[null,"HPS or other 50 Watts"]
[null,"HPS or other 70 Watts "]
[null,"HPS or other 100 Watts "]
[null,"HPS or other 150 Watts "]
[null,"HPS or other 200 Watts "]
[null,"HPS or other 250 Watts "]
[null,"HPS or other 400 Watts "]
[null,"HPS or other 1000 Watts "]
[null,"Totals",{"$f":"SUM(C13:C20)","v":0},{"$f":"SUM(D13:D20)","v":0}]
[]
[null,"Step 3: Proposed Project"]
[null,"Project Type","LED retrofit only",null,{"$f":"IF($C$24=\"LED retrofit only\",1,IF($C$24=\"LED retrofit with adaptive controls\",2,IF($C$24=\"Adaptive controls only\",3,4)))","v":1}]
[null,"Number of years for implementation (1-5 yr)",1,"Financial evaluation will be done based on these values."]
[null,"HPS or other 50 Watts to retrofit"]
[null,"HPS or other 70 Watts to retrofit",0]
[null,"HPS or other 100 Watts to retrofit"]
[null,"HPS or other 150 Watts to retrofit"]
[null,"HPS or other 200 Watts to retrofit"]
[null,"HPS or other 250 Watts to retrofit"]
[null,"HPS or other 400 Watts to retrofit",0]
[null,"HPS or other 1000 Watts to retrofit"]
[null,"Totals",{"$f":"SUM(C26:C33)","v":0}]
[]
[null,"Step 4: Incentives and Financial Aspects"]
[null,"Would you like to modify any of the values in RED? Please select YES or NO"]
[null,"Unit Prices of LED Technology",null,null,"def"]
[null,"Unit pricing LED 50 Watts ($)",200,"NO",200]
[null,"Unit pricing LED 70 Watts ($)",215,"NO",215]
[null,"Unit pricing LED 100 Watts ($)",241.65,"NO",250]
[null,"Unit pricing LED 150 Watts ($)",261.68,"NO",299]
[null,"Unit pricing LED 200 Watts ($)",343,"NO",392]
[null,"Unit pricing LED 250 Watts ($)",417.63,"NO",491]
[null,"Unit pricing LED 400 Watts ($)",451.53,"NO",864]
[null,"Unit pricing LED 1000 Watts ($)",700,"NO",1544]
[null,"Unit cost of installation per LED street light($)",160,"NO",160]
[null,"Unit cost of adaptive controls for LED street lights ($)",125,"NO",125]
[null,"Ballast Losses"]
[null,"Ballast losses 50 Watts (%)",0.35,"NO",0.35]
[null,"Ballast losses 70 Watts (%)",0.3,"NO",0.3]
[null,"Ballast losses 100 Watts (%)",0.3,"NO",0.3]
[null,"Ballast losses 150 Watts (%)",0.25,"NO",0.25]
[null,"Ballast losses 200 Watts (%)",0.2,"NO",0.2]
[null,"Ballast losses 250 Watts (%)",0.18,"NO",0.18]
[null,"Ballast losses 400 Watts (%)",0.14000000000000001,"NO",0.14000000000000001]
[null,"Ballast losses 1000 Watts (%)",0.11,"NO",0.11]
[null,"Energy Efficiency Potential of LED Technology (%)"]
[null,"Estimated energy efficiency of LED without adaptive controls (%)",0.5,"NO",0.5]
[null,"Estimated energy efficiency with LED + adaptive controls (%)",0.7,"NO",0.7]
[null,"Estimated efficiency with adaptive controls only (%)",0.2,"NO",0.2]
[null,"Electricity Rates ($ per watt per month) & Electricity Rate Annual Increase (%)"]
[null,"Electricity rate ($ per watt per month)",{"$f":"0.0275*1.09","v":2.9975000000000002E-2},"NO",2.75E-2]
[null,"Electricity rate annual increase (%)",4.1250000000000002E-2,"NO",0.03]
[null,"Incentives & Volume Discounts"]
[null,"Joint procurement discounts (% of total cost)",0,"YES",0.1]
[null,"Other incentives (% of total cost)",0,"NO",0]
[null,"Inflation (%)",0.02,"NO",0.02]
[null,"Discount rate (%)",0.02,"NO",0.04]
[null,"Carbon Price ($) & Carbon Price Rate Annual Increase (%)"]
[null,"Carbon price ($ Cost of Carbon Neutral Government Program)",25,"NO",25]
[null,"Carbon price rate annual increase(%)",0,"NO",0]

{"sheet":"Summary of results","index":2,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":true,"merged":[[32,1,32,4],[24,1,24,4],[27,1,27,4],[30,1,30,4],[18,1,18,4],[23,1,23,5],[29,1,29,5],[31,1,31,4],[26,1,26,4],[25,1,25,4],[21,1,21,4],[20,1,20,4],[19,1,19,4],[4,4,4,5],[1,4,1,5],[5,4,8,4],[5,5,8,5],[17,1,17,4],[16,1,16,5],[13,1,13,3],[12,1,12,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[14,1,14,3]]}
[]
[null,"Key Values (15-year evaluation):",null,null,"Summary of Results (15-year evaluation)"]
[null,"Total Energy Savings (kWh)",{"$f":"F18","v":0},null,null,{"$f":"\"LED Street Lights Project Evaluation for \"&'Data Input and Instructions'!C3","v":"LED Street Lights Project Evaluation for "}]
[null,"Total $ Savings",{"$f":"F31","v":0},null,null,{"$f":"+'Data Input and Instructions'!C8","v":"00:00:00"}]
[null,"Post-Incentive ROI",{"$f":"F32","v":{"$error":"#DIV/0!"}},null,"Part 1: Costs"]
[null,"Post-Incentive Payback",{"$f":"F33","v":1},null,"Business As Usual (BAU) HPS or other type of luminaries",{"$f":"CHOOSE('Data Input and Instructions'!$E$24,G7,H7,I7,\"N/A\")&\" (Post-Incentive)\"","v":"LED without adaptive controls (Post-Incentive)"}]
[null,"Pre-Incentive ROI",{"$f":"F21","v":{"$error":"#DIV/0!"}},null,null,null,"LED without adaptive controls","LED with adaptive controls","Adaptive controls only (No LED)"]
[null,"Pre-Incentive Payback",{"$f":"F22","v":1}]
[]
[null,"Total Cost ($ Nominal)",null,null,{"$f":"+SUM(Comparative!D9:D12)","v":0},{"$f":"CHOOSE('Data Input and Instructions'!$E$24,G10,H10,I10,\"N/A\")","v":0},{"$f":"Comparative!D26+Comparative!D29+Comparative!D30+Comparative!D31+Comparative!D32-Comparative!D27-Comparative!D28","v":0},{"$f":"Comparative!D58+Comparative!D61+Comparative!D62+Comparative!D63+Comparative!D64-Comparative!D59-Comparative!D60","v":0},{"$f":"Comparative!D90+Comparative!D93+Comparative!D94+Comparative!D95+Comparative!D96-Comparative!D91-Comparative!D92","v":0}]
[null,"Total Cost ($ Present Value)",null,null,{"$f":"+Comparative!D21","v":0},{"$f":"CHOOSE('Data Input and Instructions'!$E$24,G11,H11,I11,\"N/A\")","v":0},{"$f":"G12+G13","v":0},{"$f":"H12+H13","v":0},{"$f":"I12+I13","v":0}]
[null,"Capital ($ Present Value)",null,null,{"$f":"+Comparative!D15","v":0},{"$f":"CHOOSE('Data Input and Instructions'!$E$24,G12,H12,I12,\"N/A\")","v":0},{"$f":"+Comparative!D34-Comparative!D35-Comparative!D36","v":0},{"$f":"+Comparative!D67-Comparative!D68-Comparative!D69","v":0},{"$f":"+Comparative!D99-Comparative!D100-Comparative!D101","v":0}]
[null,"Operation ($ Present Value)",null,null,{"$f":"+E11-E12","v":0},{"$f":"CHOOSE('Data Input and Instructions'!$E$24,G13,H13,I13,\"N/A\")","v":0},{"$f":"Comparative!D37+Comparative!D38+Comparative!D39","v":0},{"$f":"Comparative!D70+Comparative!D71+Comparative!D72","v":0},{"$f":"Comparative!D102+Comparative!D103+Comparative!D104","v":0}]
[null,"Equivalent Annual Cost ($)",null,null,{"$f":"+Comparative!D23","v":0},{"$f":"CHOOSE('Data Input and Instructions'!$E$24,G14,H14,I14,\"N/A\")","v":0},{"$f":"+Comparative!D45","v":0},{"$f":"+Comparative!D77","v":0},{"$f":"+Comparative!D109","v":0}]
[null,"Yearly Energy (15 year avg)",null,null,{"$f":"Comparative!F19","v":0},{"$f":"CHOOSE('Data Input and Instructions'!$E$24,G15,H15,I15,\"N/A\")","v":0},{"$f":"Comparative!D41/15","v":0},{"$f":"Comparative!D65/15","v":0},{"$f":"Comparative!D97/15","v":0}]
[]
[null,"Part 2: Savings before Incentives"]
[null,"Total Energy Savings vs. BAU (KWh)",null,null,null,{"$f":"CHOOSE('Data Input and Instructions'!$E$24,G18,H18,I18,\"N/A\")","v":0},{"$f":"+Comparative!D19-Comparative!D41","v":0},{"$f":"+Comparative!D19-Comparative!D65","v":0},{"$f":"+Comparative!D19-Comparative!D97","v":0}]
[null,"Total Savings vs. BAU ($ Present Value)",null,null,null,{"$f":"CHOOSE('Data Input and Instructions'!$E$24,G19,H19,I19,\"N/A\")","v":0},{"$f":"Comparative!D15+Comparative!D16+Comparative!D17+Comparative!D18-Comparative!D34-Comparative!D37-Comparative!D38-Comparative!D39","v":0},{"$f":"Comparative!D15+Comparative!D16+Comparative!D17+Comparative!D18-Comparative!D67-Comparative!D70-Comparative!D71-Comparative!D72","v":0},{"$f":"Comparative!D15+Comparative!D16+Comparative!D17+Comparative!D18-Comparative!D99-Comparative!D102-Comparative!D103-Comparative!D104","v":0}]
["","Carbon Neutral Government Savings vs. BAU (CNG $)",null,null,null,{"$f":"CHOOSE('Data Input and Instructions'!$E$24,G20,H20,I20,\"N/A\")","v":0},{"$f":"+Comparative!D50","v":0},{"$f":"+Comparative!D73","v":0},{"$f":"+Comparative!D105","v":0}]
[null,"ROI after Energy, Operational and CNG Savings (%)",null,null,null,{"$f":"CHOOSE('Data Input and Instructions'!$E$24,G21,H21,I21,\"N/A\")","v":{"$error":"#DIV/0!"}},{"$f":"+Comparative!D54","v":{"$error":"#DIV/0!"}},{"$f":"+Comparative!D86","v":{"$error":"#DIV/0!"}},{"$f":"+Comparative!D118","v":{"$error":"#DIV/0!"}}]
[null,"Payback Period after Energy, Operational and CNG savings (# of years)",null,null,null,{"$f":"CHOOSE('Data Input and Instructions'!$E$24,G22,H22,I22,\"N/A\")","v":1},{"$f":"INDEX(Comparative!F122:T122,1,MATCH(Comparative!C127,Comparative!F127:T127,0))","v":1},{"$f":"INDEX(Comparative!F122:T122,1,MATCH(Comparative!C128,Comparative!F128:T128,0))","v":1},{"$f":"INDEX(Comparative!F122:T122,1,MATCH(Comparative!C129,Comparative!F129:T129,0))","v":1}]
[]
[null,"Part 3: Incentives"]
[null,"Other Incentives & Volume Discounts",null,null,null,{"$f":"CHOOSE('Data Input and Instructions'!$E$24,G25,H25,I25,\"N/A\")","v":0},{"$f":"SUM(G26:G27)","v":0},{"$f":"SUM(H26:H27)","v":0},{"$f":"SUM(I26:I27)","v":0}]
[null,"Joint Procurement Volume Discount ($)",null,null,null,{"$f":"CHOOSE('Data Input and Instructions'!$E$24,G26,H26,I26,\"N/A\")","v":0},{"$f":"+Comparative!D35","v":0},{"$f":"+Comparative!D68","v":0},{"$f":"+Comparative!D100","v":0}]
[null,"Other Incentives ($)",null,null,null,{"$f":"CHOOSE('Data Input and Instructions'!$E$24,G27,H27,I27,\"N/A\")","v":0},{"$f":"Comparative!D36","v":0},{"$f":"+Comparative!D69","v":0},{"$f":"+Comparative!D101","v":0}]
[null,"Total Cost after Incentives & Volume Discounts ($)",null,null,null,{"$f":"CHOOSE('Data Input and Instructions'!$E$24,G28,H28,I28,\"N/A\")","v":0},{"$f":"+G11-G20-G26-G27","v":0},{"$f":"+H11-H20-H26-H27","v":0},{"$f":"+I11-I20-I26-I27","v":0}]
[]
[null,"Part 4: Savings after Incentives"]
[null,"Total Savings after Incentives & Volume Discounts vs. BAU ($)",null,null,null,{"$f":"CHOOSE('Data Input and Instructions'!$E$24,G31,H31,I31,\"N/A\")","v":0},{"$f":"+G19+G20+G26+G27","v":0},{"$f":"+H19+H20+H26+H27","v":0},{"$f":"+I19+I20+I26+I27","v":0}]
[null,"ROI after Incentives & Volume Discounts (%)",null,null,null,{"$f":"CHOOSE('Data Input and Instructions'!$E$24,G32,H32,I32,\"N/A\")","v":{"$error":"#DIV/0!"}},{"$f":"+Comparative!D55","v":{"$error":"#DIV/0!"}},{"$f":"+Comparative!D87","v":{"$error":"#DIV/0!"}},{"$f":"+Comparative!D119","v":{"$error":"#DIV/0!"}}]
[null,"Payback Period after Incentives & Volume Discounts (# of years)",null,null,null,{"$f":"CHOOSE('Data Input and Instructions'!$E$24,G33,H33,I33,\"N/A\")","v":1},{"$f":"INDEX(Comparative!F122:T122,1,MATCH(Comparative!C137,Comparative!F137:T137,0))","v":1},{"$f":"INDEX(Comparative!F122:T122,1,MATCH(Comparative!C138,Comparative!F138:T138,0))","v":1},{"$f":"INDEX(Comparative!F122:T122,1,MATCH(Comparative!C139,Comparative!F139:T139,0))","v":1}]

{"sheet":"PrintSheet","index":3,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":true,"merged":[[24,2,24,3],[23,1,23,3],[9,5,9,6],[10,5,10,6],[11,5,11,6],[8,5,8,6],[6,1,6,3],[6,5,6,7],[1,1,1,7],[2,1,2,7],[7,5,7,6]]}
[]
[null,"LED Streetlight Project Evaluation:"]
[null,{"$f":"'Data Input and Instructions'!C24","v":"LED retrofit only"}]
[]
[null,{"$f":"'Data Input and Instructions'!C3","v":0},null,null,null,null,null,{"$f":"'Data Input and Instructions'!C8","v":"00:00:00"}]
[]
[null,"Project Summary",null,null,null,"Financial Summary"]
[]
[null,{"$f":"'Data Input and Instructions'!C25&\"-year implementation\"","v":"1-year implementation"},null,null,null,"Total Energy Savings (kWh)",null,{"$f":"'Summary of results'!C3","v":0}]
[null,{"$f":"\"BC Hydro rate \"&'Data Input and Instructions'!C11","v":"BC Hydro rate 1702"},null,null,null,"Total $ Savings",null,{"$f":"'Summary of results'!C4","v":0}]
[null,null,null,null,null,"Post-Incentive ROI",null,{"$f":"'Summary of results'!C5","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,"Post-Incentive Payback",null,{"$f":"'Summary of results'!C6","v":1}]
[null,{"$f":"\"Luminaire type \"&CHOOSE('Data Input and Instructions'!E24,\"retrofitted with LED:\",\"retrofitted with LED + controls:\",\"retrofitted with controls:\",\"N/A\")","v":"Luminaire type retrofitted with LED:"},"Luminaire Count","% of total inventory"]
[null,{"$f":"'Data Input and Instructions'!B13","v":"HPS or other 50 Watts"},{"$f":"'Data Input and Instructions'!C26","v":0},{"$f":"IFERROR(C14/'Data Input and Instructions'!D13,0)","v":0},null,null,"Business As Usual (BAU) HPS or other type of luminaries","Project"]
[null,{"$f":"'Data Input and Instructions'!B14","v":"HPS or other 70 Watts "},{"$f":"'Data Input and Instructions'!C27","v":0},{"$f":"IFERROR(C15/'Data Input and Instructions'!D14,0)","v":0},null,"Capital ($ Present Value)",{"$f":"'Summary of results'!E12","v":0},{"$f":"'Summary of results'!F12","v":0}]
[null,{"$f":"'Data Input and Instructions'!B15","v":"HPS or other 100 Watts "},{"$f":"'Data Input and Instructions'!C28","v":0},{"$f":"IFERROR(C16/'Data Input and Instructions'!D15,0)","v":0},null,"Operation ($ Present Value)",{"$f":"'Summary of results'!E13","v":0},{"$f":"'Summary of results'!F13","v":0}]
[null,{"$f":"'Data Input and Instructions'!B16","v":"HPS or other 150 Watts "},{"$f":"'Data Input and Instructions'!C29","v":0},{"$f":"IFERROR(C17/'Data Input and Instructions'!D16,0)","v":0},null,"Total Cost ($ Nominal)",{"$f":"'Summary of results'!E10","v":0},{"$f":"'Summary of results'!F10","v":0}]
[null,{"$f":"'Data Input and Instructions'!B17","v":"HPS or other 200 Watts "},{"$f":"'Data Input and Instructions'!C30","v":0},{"$f":"IFERROR(C18/'Data Input and Instructions'!D17,0)","v":0},null,"Total Cost ($ Present Value)",{"$f":"'Summary of results'!E11","v":0},{"$f":"'Summary of results'!F11","v":0}]
[null,{"$f":"'Data Input and Instructions'!B18","v":"HPS or other 250 Watts "},{"$f":"'Data Input and Instructions'!C31","v":0},{"$f":"IFERROR(C19/'Data Input and Instructions'!D18,0)","v":0}]
[null,{"$f":"'Data Input and Instructions'!B19","v":"HPS or other 400 Watts "},{"$f":"'Data Input and Instructions'!C32","v":0},{"$f":"IFERROR(C20/'Data Input and Instructions'!D19,0)","v":0}]
[null,{"$f":"'Data Input and Instructions'!B20","v":"HPS or other 1000 Watts "},{"$f":"'Data Input and Instructions'!C33","v":0},{"$f":"IFERROR(C21/'Data Input and Instructions'!D20,0)","v":0},null,"Incentives"]
[null,null,null,null,null,{"$f":"'Summary of results'!B26","v":"Joint Procurement Volume Discount ($)"},{"$f":"'Summary of results'!F26","v":0}]
[null,null,null,null,null,{"$f":"'Summary of results'!B27","v":"Other Incentives ($)"},{"$f":"'Summary of results'!F27","v":0}]
[null,"Total Yearly Energy (kWh)",null,null,null,"Total Incentives ($)",{"$f":"SUM(G22:G23)","v":0}]
[null,{"$f":"'Summary of results'!E15","v":0},{"$f":"'Summary of results'!F15","v":0}]

{"sheet":"Comparative","index":4,"n_rows":146,"n_cols":27,"rows_kept":146,"cut":false,"hidden":true,"merged":[[122,3,122,4]]}
[null,null,null,null,null,"LED Street Lights Project Evaluation for",null,null,null,{"$f":"+'Data Input and Instructions'!C3","v":0}]
[null,"Discount Rate",{"$f":"'Data Input and Instructions'!C69","v":0.02}]
[]
[null,null,null,null,null,"Year"]
[null,null,null,null,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,16]
[null,null,"Discount Factor",null,{"$f":"-PV($C$2,E5,0,1,0)","v":1},0.98039215686274506,0.96116878123798544,0.94232233454704462,0.9238454260265142,0.90573080982991594,0.88797138218619198,0.87056017861391388,0.85349037119011162,0.83675526587265847,0.82034829987515534,0.80426303909328967,0.78849317558165644,0.77303252508005538,0.75787502458828948,{"$f":"-PV($C$2,T5,0,1,0)","v":0.74301472998851925},{"$f":"-PV($C$2,U5,0,1,0)","v":0.72844581371423445},0.7141625624649357,0.7001593749656233,0.68643075977021895,0.67297133310805779,0.72844581371423445]
["Business as Usual Scenario with High Pressure Sodium Lamps (HPS)"]
[]
[null,"Nominal Value","Capital Cost (replacements)",{"$f":"SUM(F9:T9)","v":0},{"$f":"SUM('Unit Pricing BAU'!H45:H51)","v":0},{"$f":"SUM('Unit Pricing BAU'!J44:J51)+SUM('Unit Pricing BAU'!J4:J11)","v":0},{"$f":"SUM('Unit Pricing BAU'!K44:K51)+SUM('Unit Pricing BAU'!K4:K11)","v":0},{"$f":"SUM('Unit Pricing BAU'!L44:L51)+SUM('Unit Pricing BAU'!L4:L11)","v":0},{"$f":"SUM('Unit Pricing BAU'!M44:M51)+SUM('Unit Pricing BAU'!M4:M11)","v":0},{"$f":"SUM('Unit Pricing BAU'!N44:N51)+SUM('Unit Pricing BAU'!N4:N11)","v":0},{"$f":"SUM('Unit Pricing BAU'!O44:O51)+SUM('Unit Pricing BAU'!O4:O11)","v":0},{"$f":"SUM('Unit Pricing BAU'!P44:P51)+SUM('Unit Pricing BAU'!P4:P11)","v":0},{"$f":"SUM('Unit Pricing BAU'!Q44:Q51)+SUM('Unit Pricing BAU'!Q4:Q11)","v":0},{"$f":"SUM('Unit Pricing BAU'!R44:R51)+SUM('Unit Pricing BAU'!R4:R11)","v":0},{"$f":"SUM('Unit Pricing BAU'!S44:S51)+SUM('Unit Pricing BAU'!S4:S11)","v":0},{"$f":"SUM('Unit Pricing BAU'!T44:T51)+SUM('Unit Pricing BAU'!T4:T11)","v":0},{"$f":"SUM('Unit Pricing BAU'!U44:U51)+SUM('Unit Pricing BAU'!U4:U11)","v":0},{"$f":"SUM('Unit Pricing BAU'!V44:V51)+SUM('Unit Pricing BAU'!V4:V11)","v":0},{"$f":"SUM('Unit Pricing BAU'!W44:W51)+SUM('Unit Pricing BAU'!W4:W11)","v":0},{"$f":"SUM('Unit Pricing BAU'!X44:X51)+SUM('Unit Pricing BAU'!X4:X11)","v":0},{"$f":"SUM('Unit Pricing BAU'!Y44:Y51)+SUM('Unit Pricing BAU'!Y4:Y11)","v":0},{"$f":"SUM('Unit Pricing BAU'!Z44:Z51)+SUM('Unit Pricing BAU'!Z4:Z11)","v":0},{"$f":"SUM('Unit Pricing BAU'!AA44:AA51)+SUM('Unit Pricing BAU'!AA4:AA11)","v":0},{"$f":"SUM('Unit Pricing BAU'!AB44:AB51)+SUM('Unit Pricing BAU'!AB4:AB11)","v":0},{"$f":"SUM('Unit Pricing BAU'!AC44:AC51)+SUM('Unit Pricing BAU'!AC4:AC11)","v":0},{"$f":"SUM('Unit Pricing BAU'!AD44:AD51)+SUM('Unit Pricing BAU'!AD4:AD11)","v":0},{"$f":"SUM('Unit Pricing BAU'!AE44:AE51)+SUM('Unit Pricing BAU'!AE4:AE11)","v":0}]
[null,null,"Energy",{"$f":"SUM(F10:Y10)","v":0},{"$f":"SUM('Unit Pricing BAU'!H21:H27)","v":0},{"$f":"SUM('Unit Pricing BAU'!J20:J27)","v":0},{"$f":"SUM('Unit Pricing BAU'!K20:K27)","v":0},{"$f":"SUM('Unit Pricing BAU'!L20:L27)","v":0},{"$f":"SUM('Unit Pricing BAU'!M20:M27)","v":0},{"$f":"SUM('Unit Pricing BAU'!N20:N27)","v":0},{"$f":"SUM('Unit Pricing BAU'!O20:O27)","v":0},{"$f":"SUM('Unit Pricing BAU'!P20:P27)","v":0},{"$f":"SUM('Unit Pricing BAU'!Q20:Q27)","v":0},{"$f":"SUM('Unit Pricing BAU'!R20:R27)","v":0},{"$f":"SUM('Unit Pricing BAU'!S20:S27)","v":0},{"$f":"SUM('Unit Pricing BAU'!T20:T27)","v":0},{"$f":"SUM('Unit Pricing BAU'!U20:U27)","v":0},{"$f":"SUM('Unit Pricing BAU'!V20:V27)","v":0},{"$f":"SUM('Unit Pricing BAU'!W20:W27)","v":0},{"$f":"SUM('Unit Pricing BAU'!X20:X27)","v":0},{"$f":"SUM('Unit Pricing BAU'!Y20:Y27)","v":0},{"$f":"SUM('Unit Pricing BAU'!Z37:Z41)","v":0},{"$f":"SUM('Unit Pricing BAU'!AA37:AA41)","v":0},{"$f":"SUM('Unit Pricing BAU'!AB37:AB41)","v":0},{"$f":"SUM('Unit Pricing BAU'!AC37:AC41)","v":0},{"$f":"SUM('Unit Pricing BAU'!AD37:AD41)","v":0}]
[null,null,"Reactive Maintenance",{"$f":"SUM(F11:Y11)","v":0},{"$f":"SUM('Unit Pricing BAU'!H37:H43)","v":0},{"$f":"SUM('Unit Pricing BAU'!J36:J43)","v":0},{"$f":"SUM('Unit Pricing BAU'!K36:K43)","v":0},{"$f":"SUM('Unit Pricing BAU'!L36:L43)","v":0},{"$f":"SUM('Unit Pricing BAU'!M36:M43)","v":0},{"$f":"SUM('Unit Pricing BAU'!N36:N43)","v":0},{"$f":"SUM('Unit Pricing BAU'!O36:O43)","v":0},{"$f":"SUM('Unit Pricing BAU'!P36:P43)","v":0},{"$f":"SUM('Unit Pricing BAU'!Q36:Q43)","v":0},{"$f":"SUM('Unit Pricing BAU'!R36:R43)","v":0},{"$f":"SUM('Unit Pricing BAU'!S36:S43)","v":0},{"$f":"SUM('Unit Pricing BAU'!T36:T43)","v":0},{"$f":"SUM('Unit Pricing BAU'!U36:U43)","v":0},{"$f":"SUM('Unit Pricing BAU'!V36:V43)","v":0},{"$f":"SUM('Unit Pricing BAU'!W36:W43)","v":0},{"$f":"SUM('Unit Pricing BAU'!X36:X43)","v":0},{"$f":"SUM('Unit Pricing BAU'!Y36:Y43)","v":0},{"$f":"SUM('Unit Pricing BAU'!Z51:Z56)","v":0},{"$f":"SUM('Unit Pricing BAU'!AA51:AA56)","v":0},{"$f":"SUM('Unit Pricing BAU'!AB51:AB56)","v":0},{"$f":"SUM('Unit Pricing BAU'!AC51:AC56)","v":0},{"$f":"SUM('Unit Pricing BAU'!AD51:AD56)","v":0}]
[null,null,"Scheduled Maintenance",{"$f":"SUM(F12:Y12)","v":0},{"$f":"SUM('Unit Pricing BAU'!H53:H59)","v":0},{"$f":"SUM('Unit Pricing BAU'!J52:J59)","v":0},{"$f":"SUM('Unit Pricing BAU'!K52:K59)","v":0},{"$f":"SUM('Unit Pricing BAU'!L52:L59)","v":0},{"$f":"SUM('Unit Pricing BAU'!M52:M59)","v":0},{"$f":"SUM('Unit Pricing BAU'!N52:N59)","v":0},{"$f":"SUM('Unit Pricing BAU'!O52:O59)","v":0},{"$f":"SUM('Unit Pricing BAU'!P52:P59)","v":0},{"$f":"SUM('Unit Pricing BAU'!Q52:Q59)","v":0},{"$f":"SUM('Unit Pricing BAU'!R52:R59)","v":0},{"$f":"SUM('Unit Pricing BAU'!S52:S59)","v":0},{"$f":"SUM('Unit Pricing BAU'!T52:T59)","v":0},{"$f":"SUM('Unit Pricing BAU'!U52:U59)","v":0},{"$f":"SUM('Unit Pricing BAU'!V52:V59)","v":0},{"$f":"SUM('Unit Pricing BAU'!W52:W59)","v":0},{"$f":"SUM('Unit Pricing BAU'!X52:X59)","v":0},{"$f":"SUM('Unit Pricing BAU'!Y52:Y59)","v":0},{"$f":"SUM('Unit Pricing BAU'!Z66:Z70)","v":0},{"$f":"SUM('Unit Pricing BAU'!AA66:AA70)","v":0},{"$f":"SUM('Unit Pricing BAU'!AB66:AB70)","v":0},{"$f":"SUM('Unit Pricing BAU'!AC66:AC70)","v":0},{"$f":"SUM('Unit Pricing BAU'!AD66:AD70)","v":0}]
[]
[]
[null,"Present Value",{"$f":"C9","v":"Capital Cost (replacements)"},{"$f":"SUM(F15:T15)","v":0},{"$f":"E9*E$6","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"T9*T$6","v":0},{"$f":"U9*U$6","v":0},0,0,0,0,0]
[null,null,{"$f":"C10","v":"Energy"},{"$f":"SUM(F16:T16)","v":0},{"$f":"E10*E$6","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"T10*T$6","v":0},{"$f":"U10*U$6","v":0},0,0,0,0,0]
[null,null,{"$f":"C11","v":"Reactive Maintenance"},{"$f":"SUM(F17:T17)","v":0},{"$f":"E11*E$6","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"T11*T$6","v":0},{"$f":"U11*U$6","v":0},0,0,0,0,0]
[null,null,{"$f":"C12","v":"Scheduled Maintenance"},{"$f":"SUM(F18:T18)","v":0},{"$f":"E12*E$6","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"T12*T$6","v":0},{"$f":"U12*U$6","v":0},0,0,0,0,0]
[null,null,"Energy consumption KWh",{"$f":"SUM(F19:T19)","v":0},null,{"$f":"SUM('Unit Pricing BAU'!J29:J35)","v":0},{"$f":"SUM('Unit Pricing BAU'!K29:K35)","v":0},{"$f":"SUM('Unit Pricing BAU'!L29:L35)","v":0},{"$f":"SUM('Unit Pricing BAU'!M29:M35)","v":0},{"$f":"SUM('Unit Pricing BAU'!N29:N35)","v":0},{"$f":"SUM('Unit Pricing BAU'!O29:O35)","v":0},{"$f":"SUM('Unit Pricing BAU'!P29:P35)","v":0},{"$f":"SUM('Unit Pricing BAU'!Q29:Q35)","v":0},{"$f":"SUM('Unit Pricing BAU'!R29:R35)","v":0},{"$f":"SUM('Unit Pricing BAU'!S29:S35)","v":0},{"$f":"SUM('Unit Pricing BAU'!T29:T35)","v":0},{"$f":"SUM('Unit Pricing BAU'!U29:U35)","v":0},{"$f":"SUM('Unit Pricing BAU'!V29:V35)","v":0},{"$f":"SUM('Unit Pricing BAU'!W29:W35)","v":0},{"$f":"SUM('Unit Pricing BAU'!X29:X35)","v":0},{"$f":"SUM('Unit Pricing BAU'!Y29:Y35)","v":0},{"$f":"SUM('Unit Pricing BAU'!Z29:Z35)","v":0},{"$f":"SUM('Unit Pricing BAU'!AA29:AA35)","v":0},{"$f":"SUM('Unit Pricing BAU'!AB29:AB35)","v":0},{"$f":"SUM('Unit Pricing BAU'!AC29:AC35)","v":0},{"$f":"SUM('Unit Pricing BAU'!AD29:AD35)","v":0},{"$f":"SUM('Unit Pricing BAU'!AE29:AE35)","v":0}]
[]
[null,null,"Total Real Cost",{"$f":"SUM(D15:D18)","v":0},{"$f":"+D21+SUM(U15:U18)","v":0}]
[null,null,"Term",15,16,"years"]
[null,null,"Equivalent Annual Cost (EAC)",{"$f":"-PMT($C$2,D22,D21,0,0)","v":0},{"$f":"-PMT($C$2,E22,E21,0,0)","v":0},"per year"]
["1st LED Scenario -energy efficiency without adaptive controls"]
[]
[null,"Nominal Value","Capital Cost",{"$f":"SUM(F26:T26)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!H6:H12)+SUM('unit pricing 1-5 years scenario'!H14:H20)+SUM('unit pricing 1-5 years scenario'!H22:H28)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!J5:J12)+SUM('unit pricing 1-5 years scenario'!J13:J20)+SUM('unit pricing 1-5 years scenario'!J21:J28)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!K5:K12)+SUM('unit pricing 1-5 years scenario'!K13:K20)+SUM('unit pricing 1-5 years scenario'!K21:K28)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!L5:L12)+SUM('unit pricing 1-5 years scenario'!L13:L20)+SUM('unit pricing 1-5 years scenario'!L21:L28)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!M5:M12)+SUM('unit pricing 1-5 years scenario'!M13:M20)+SUM('unit pricing 1-5 years scenario'!M21:M28)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!N5:N12)+SUM('unit pricing 1-5 years scenario'!N13:N20)+SUM('unit pricing 1-5 years scenario'!N21:N28)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!O5:O12)+SUM('unit pricing 1-5 years scenario'!O13:O20)+SUM('unit pricing 1-5 years scenario'!O21:O28)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!P5:P12)+SUM('unit pricing 1-5 years scenario'!P13:P20)+SUM('unit pricing 1-5 years scenario'!P21:P28)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!Q5:Q12)+SUM('unit pricing 1-5 years scenario'!Q13:Q20)+SUM('unit pricing 1-5 years scenario'!Q21:Q28)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!R5:R12)+SUM('unit pricing 1-5 years scenario'!R13:R20)+SUM('unit pricing 1-5 years scenario'!R21:R28)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!S5:S12)+SUM('unit pricing 1-5 years scenario'!S13:S20)+SUM('unit pricing 1-5 years scenario'!S21:S28)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!T5:T12)+SUM('unit pricing 1-5 years scenario'!T13:T20)+SUM('unit pricing 1-5 years scenario'!T21:T28)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!U5:U12)+SUM('unit pricing 1-5 years scenario'!U13:U20)+SUM('unit pricing 1-5 years scenario'!U21:U28)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!V5:V12)+SUM('unit pricing 1-5 years scenario'!V13:V20)+SUM('unit pricing 1-5 years scenario'!V21:V28)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!W5:W12)+SUM('unit pricing 1-5 years scenario'!W13:W20)+SUM('unit pricing 1-5 years scenario'!W21:W28)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!X5:X12)+SUM('unit pricing 1-5 years scenario'!X13:X20)+SUM('unit pricing 1-5 years scenario'!X21:X28)","v":0}]
[null,{"$f":"+'Data Input and Instructions'!$C$66","v":0},"Volume Discounts",0,{"$f":"+E26*$B$27","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"+'Data Input and Instructions'!$C$67","v":0},"Other Incentives",{"$f":"SUM(F28:T28)","v":0},{"$f":"(+E26-E27)*$B$28","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Energy",0,{"$f":"SUM('unit pricing 1-5 years scenario'!H38:H44)+SUM('unit pricing 1-5 years scenario'!H86:H92)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!J37:J44)+SUM('unit pricing 1-5 years scenario'!J85:J92)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!K37:K44)+SUM('unit pricing 1-5 years scenario'!K85:K92)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!L37:L44)+SUM('unit pricing 1-5 years scenario'!L85:L92)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!M37:M44)+SUM('unit pricing 1-5 years scenario'!M85:M92)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!N37:N44)+SUM('unit pricing 1-5 years scenario'!N85:N92)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!O37:O44)+SUM('unit pricing 1-5 years scenario'!O85:O92)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!P37:P44)+SUM('unit pricing 1-5 years scenario'!P85:P92)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!Q37:Q44)+SUM('unit pricing 1-5 years scenario'!Q85:Q92)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!R37:R44)+SUM('unit pricing 1-5 years scenario'!R85:R92)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!S37:S44)+SUM('unit pricing 1-5 years scenario'!S85:S92)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!T37:T44)+SUM('unit pricing 1-5 years scenario'!T85:T92)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!U37:U44)+SUM('unit pricing 1-5 years scenario'!U85:U92)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!V37:V44)+SUM('unit pricing 1-5 years scenario'!V85:V92)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!W37:W44)+SUM('unit pricing 1-5 years scenario'!W85:W92)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!X37:X44)+SUM('unit pricing 1-5 years scenario'!X85:X92)","v":0}]
[null,null,"LED maintenance",0,{"$f":"SUM('unit pricing 1-5 years scenario'!H102:H108)+SUM('unit pricing 1-5 years scenario'!H110:H124)+SUM('unit pricing 1-5 years scenario'!H127:H133)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!J101:J108)+SUM('unit pricing 1-5 years scenario'!J109:J124)+SUM('unit pricing 1-5 years scenario'!J125:J133)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!K101:K108)+SUM('unit pricing 1-5 years scenario'!K109:K124)+SUM('unit pricing 1-5 years scenario'!K125:K133)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!L101:L108)+SUM('unit pricing 1-5 years scenario'!L109:L124)+SUM('unit pricing 1-5 years scenario'!L125:L133)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!M101:M108)+SUM('unit pricing 1-5 years scenario'!M109:M124)+SUM('unit pricing 1-5 years scenario'!M125:M133)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!N101:N108)+SUM('unit pricing 1-5 years scenario'!N109:N124)+SUM('unit pricing 1-5 years scenario'!N125:N133)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!O101:O108)+SUM('unit pricing 1-5 years scenario'!O109:O124)+SUM('unit pricing 1-5 years scenario'!O125:O133)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!P101:P108)+SUM('unit pricing 1-5 years scenario'!P109:P124)+SUM('unit pricing 1-5 years scenario'!P125:P133)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!Q101:Q108)+SUM('unit pricing 1-5 years scenario'!Q109:Q124)+SUM('unit pricing 1-5 years scenario'!Q125:Q133)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!R101:R108)+SUM('unit pricing 1-5 years scenario'!R109:R124)+SUM('unit pricing 1-5 years scenario'!R125:R133)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!S101:S108)+SUM('unit pricing 1-5 years scenario'!S109:S124)+SUM('unit pricing 1-5 years scenario'!S125:S133)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!T101:T108)+SUM('unit pricing 1-5 years scenario'!T109:T124)+SUM('unit pricing 1-5 years scenario'!T125:T133)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!U101:U108)+SUM('unit pricing 1-5 years scenario'!U109:U124)+SUM('unit pricing 1-5 years scenario'!U125:U133)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!V101:V108)+SUM('unit pricing 1-5 years scenario'!V109:V124)+SUM('unit pricing 1-5 years scenario'!V125:V133)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!W101:W108)+SUM('unit pricing 1-5 years scenario'!W109:W124)+SUM('unit pricing 1-5 years scenario'!W125:W133)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!X101:X108)+SUM('unit pricing 1-5 years scenario'!X109:X124)+SUM('unit pricing 1-5 years scenario'!X125:X133)","v":0}]
[null,null,"HPS maintenance",0,{"$f":"SUM('unit pricing 1-5 years scenario'!H135:H141)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!J134:J141)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!K134:K141)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!L134:L141)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!M134:M141)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!N134:N141)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!O134:O141)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!P134:P141)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!Q134:Q141)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!R134:R141)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!S134:S141)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!T134:T141)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!U134:U141)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!V134:V141)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!W134:W141)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!X134:X141)","v":0}]
[null,{"$f":"+'Data Input and Instructions'!$C$72","v":0},"Carbon Price/Carbon Neutral Govn't Savings",0,null,{"$f":"+'GHG savings'!I41","v":0},{"$f":"+F32*(1+$B$32)","v":0},{"$f":"+G32*(1+$B$32)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Present Value",{"$f":"C26","v":"Capital Cost"},{"$f":"SUM(F34:T34)","v":0},{"$f":"E26*E$6","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Volume Discounts",0,{"$f":"E27*E$6","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Other Incentives",{"$f":"SUM(F36:T36)","v":0},{"$f":"E28*E$6","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"C29","v":"Energy"},0,{"$f":"E29*E$6","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"C30","v":"LED maintenance"},0,{"$f":"E30*E$6","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"C31","v":"HPS maintenance"},0,{"$f":"E31*E$6","v":0},0,0,0,0,0,0,0,0,0,{"$f":"O31*O$6","v":0},0,0,0,0,0]
[null,null,{"$f":"C32","v":"Carbon Price/Carbon Neutral Govn't Savings"},{"$f":"SUM(F40:T40)","v":0},0,0,0,0,0,0,0,0,{"$f":"M32*M$6","v":0},{"$f":"N32*N$6","v":0},0,0,0,0,0,0]
[null,null,"Energy consumption KWh",{"$f":"SUM(F41:T41)","v":0},null,{"$f":"SUM('unit pricing 1-5 years scenario'!J45:J52)+ SUM('unit pricing 1-5 years scenario'!J93:J100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!K45:K52)+ SUM('unit pricing 1-5 years scenario'!K93:K100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!L45:L52)+ SUM('unit pricing 1-5 years scenario'!L93:L100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!M45:M52)+ SUM('unit pricing 1-5 years scenario'!M93:M100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!N45:N52)+ SUM('unit pricing 1-5 years scenario'!N93:N100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!O45:O52)+ SUM('unit pricing 1-5 years scenario'!O93:O100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!P45:P52)+ SUM('unit pricing 1-5 years scenario'!P93:P100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!Q45:Q52)+ SUM('unit pricing 1-5 years scenario'!Q93:Q100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!R45:R52)+ SUM('unit pricing 1-5 years scenario'!R93:R100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!S45:S52)+ SUM('unit pricing 1-5 years scenario'!S93:S100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!T45:T52)+ SUM('unit pricing 1-5 years scenario'!T93:T100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!U45:U52)+ SUM('unit pricing 1-5 years scenario'!U93:U100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!V45:V52)+ SUM('unit pricing 1-5 years scenario'!V93:V100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!W45:W52)+ SUM('unit pricing 1-5 years scenario'!W93:W100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!X45:X52)+ SUM('unit pricing 1-5 years scenario'!X93:X100)","v":0}]
[]
[null,null,"Total Present Value",{"$f":"+D34+D37+D38+D39-D35-D36","v":0}]
[null,null,"Term",15]
[null,null,"Equivalent Annual Cost (EAC)",{"$f":"-PMT($C$2,D44,D43,0,0)","v":0}]
["Comparative with BAU"]
[null,null,"Total Present Value",{"$f":"+D43-D21","v":0}]
[null,null,"Term",15]
[null,null,"Equivalent Annual Cost (EAC)",{"$f":"+D45-D23","v":0}]
[null,null,"Carbon Neutral Govn't Savings",{"$f":"+D40","v":0},null,null,null,null,null,null,null,"`"]
[null,null,"Volume Discounts",{"$f":"+D35","v":0}]
[null,null,"Other Incentives",{"$f":"+D36","v":0}]
[null,null,"Subtotal",{"$f":"+D47-D50-D51-D52","v":0}]
[null,null,"Rate of Savings",{"$f":"-((SUM(F37:T39)-SUM(F15:T18)-D50)/SUM(F34:T34))/15","v":{"$error":"#DIV/0!"}}]
[null,null,"Rate of Savings after discounts",{"$f":"-((SUM(F37:T39)-SUM(F15:T18)-D50-D51-D52)/SUM(F34:T34)/15)","v":{"$error":"#DIV/0!"}}]
[]
["2nd LED Scenario- energy efficiency with adaptive controls"]
[null,"Nominal Value","Capital Cost",{"$f":"SUM(F58:U58)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!H6:H20)+SUM('unit pricing 1-5 years scenario'!H22:H28)+SUM('unit pricing 1-5 years scenario'!H30:H36)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!J5:J20)+SUM('unit pricing 1-5 years scenario'!J21:J28)+SUM('unit pricing 1-5 years scenario'!J29:J36)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!K5:K20)+SUM('unit pricing 1-5 years scenario'!K21:K28)+SUM('unit pricing 1-5 years scenario'!K29:K36)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!L5:L20)+SUM('unit pricing 1-5 years scenario'!L21:L28)+SUM('unit pricing 1-5 years scenario'!L29:L36)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!M5:M20)+SUM('unit pricing 1-5 years scenario'!M21:M28)+SUM('unit pricing 1-5 years scenario'!M29:M36)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!N5:N20)+SUM('unit pricing 1-5 years scenario'!N21:N28)+SUM('unit pricing 1-5 years scenario'!N29:N36)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!O5:O20)+SUM('unit pricing 1-5 years scenario'!O21:O28)+SUM('unit pricing 1-5 years scenario'!O29:O36)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!P5:P20)+SUM('unit pricing 1-5 years scenario'!P21:P28)+SUM('unit pricing 1-5 years scenario'!P29:P36)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!Q5:Q20)+SUM('unit pricing 1-5 years scenario'!Q21:Q28)+SUM('unit pricing 1-5 years scenario'!Q29:Q36)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!R5:R20)+SUM('unit pricing 1-5 years scenario'!R21:R28)+SUM('unit pricing 1-5 years scenario'!R29:R36)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!S5:S20)+SUM('unit pricing 1-5 years scenario'!S21:S28)+SUM('unit pricing 1-5 years scenario'!S29:S36)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!T5:T20)+SUM('unit pricing 1-5 years scenario'!T21:T28)+SUM('unit pricing 1-5 years scenario'!T29:T36)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!U5:U20)+SUM('unit pricing 1-5 years scenario'!U21:U28)+SUM('unit pricing 1-5 years scenario'!U29:U36)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!V5:V20)+SUM('unit pricing 1-5 years scenario'!V21:V28)+SUM('unit pricing 1-5 years scenario'!V29:V36)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!W5:W20)+SUM('unit pricing 1-5 years scenario'!W21:W28)+SUM('unit pricing 1-5 years scenario'!W29:W36)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!X5:X20)+SUM('unit pricing 1-5 years scenario'!X21:X28)+SUM('unit pricing 1-5 years scenario'!X29:X36)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!Y5:Y20)+SUM('unit pricing 1-5 years scenario'!Y21:Y28)+SUM('unit pricing 1-5 years scenario'!Y29:Y36)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!Z5:Z20)+SUM('unit pricing 1-5 years scenario'!Z21:Z28)+SUM('unit pricing 1-5 years scenario'!Z29:Z36)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!AA5:AA20)+SUM('unit pricing 1-5 years scenario'!AA21:AA28)+SUM('unit pricing 1-5 years scenario'!AA29:AA36)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!AB5:AB20)+SUM('unit pricing 1-5 years scenario'!AB21:AB28)+SUM('unit pricing 1-5 years scenario'!AB29:AB36)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!AC5:AC20)+SUM('unit pricing 1-5 years scenario'!AC21:AC28)+SUM('unit pricing 1-5 years scenario'!AC29:AC36)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!AD5:AD20)+SUM('unit pricing 1-5 years scenario'!AD21:AD28)+SUM('unit pricing 1-5 years scenario'!AD29:AD36)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!AE5:AE20)+SUM('unit pricing 1-5 years scenario'!AE21:AE28)+SUM('unit pricing 1-5 years scenario'!AE29:AE36)","v":0}]
[null,{"$f":"+'Data Input and Instructions'!$C$66","v":0},"Volume Discounts",0,{"$f":"+E58*$B$59","v":0},{"$f":"+F58*$B$59","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+U58*(1-0.8)","v":0},{"$f":"+V58*(1-0.8)","v":0},{"$f":"+W58*(1-0.8)","v":0},{"$f":"+X58*(1-0.8)","v":0},{"$f":"+Y58*(1-0.8)","v":0}]
[null,{"$f":"+'Data Input and Instructions'!$C$67","v":0},"Other Incentives",{"$f":"SUM(F60:T60)","v":0},{"$f":"(+E58-E59)*$B$60","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Energy",0,{"$f":"(SUM('unit pricing 1-5 years scenario'!H54:H60)+SUM('unit pricing 1-5 years scenario'!H86:H92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!J53:J60)+SUM('unit pricing 1-5 years scenario'!J85:J92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!K53:K60)+SUM('unit pricing 1-5 years scenario'!K85:K92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!L53:L60)+SUM('unit pricing 1-5 years scenario'!L85:L92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!M53:M60)+SUM('unit pricing 1-5 years scenario'!M85:M92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!N53:N60)+SUM('unit pricing 1-5 years scenario'!N85:N92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!O53:O60)+SUM('unit pricing 1-5 years scenario'!O85:O92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!P53:P60)+SUM('unit pricing 1-5 years scenario'!P85:P92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!Q53:Q60)+SUM('unit pricing 1-5 years scenario'!Q85:Q92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!R53:R60)+SUM('unit pricing 1-5 years scenario'!R85:R92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!S53:S60)+SUM('unit pricing 1-5 years scenario'!S85:S92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!T53:T60)+SUM('unit pricing 1-5 years scenario'!T85:T92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!U53:U60)+SUM('unit pricing 1-5 years scenario'!U85:U92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!V53:V60)+SUM('unit pricing 1-5 years scenario'!V85:V92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!W53:W60)+SUM('unit pricing 1-5 years scenario'!W85:W92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!X53:X60)+SUM('unit pricing 1-5 years scenario'!X85:X92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!Y53:Y60)+SUM('unit pricing 1-5 years scenario'!Y85:Y92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!Z53:Z60)+SUM('unit pricing 1-5 years scenario'!Z85:Z92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!AA53:AA60)+SUM('unit pricing 1-5 years scenario'!AA85:AA92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!AB53:AB60)+SUM('unit pricing 1-5 years scenario'!AB85:AB92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!AC53:AC60)+SUM('unit pricing 1-5 years scenario'!AC85:AC92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!AD53:AD60)+SUM('unit pricing 1-5 years scenario'!AD85:AD92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!AE53:AE60)+SUM('unit pricing 1-5 years scenario'!AE85:AE92))","v":0}]
[null,null,"LED maintenance",0,{"$f":"SUM('unit pricing 1-5 years scenario'!H102:H108)+SUM('unit pricing 1-5 years scenario'!H110:H124)+SUM('unit pricing 1-5 years scenario'!H127:H133)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!J101:J108)+SUM('unit pricing 1-5 years scenario'!J109:J124)+SUM('unit pricing 1-5 years scenario'!J126:J133)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!K101:K108)+SUM('unit pricing 1-5 years scenario'!K109:K124)+SUM('unit pricing 1-5 years scenario'!K126:K133)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!L101:L108)+SUM('unit pricing 1-5 years scenario'!L109:L124)+SUM('unit pricing 1-5 years scenario'!L126:L133)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!M101:M108)+SUM('unit pricing 1-5 years scenario'!M109:M124)+SUM('unit pricing 1-5 years scenario'!M126:M133)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!N101:N108)+SUM('unit pricing 1-5 years scenario'!N109:N124)+SUM('unit pricing 1-5 years scenario'!N126:N133)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!O101:O108)+SUM('unit pricing 1-5 years scenario'!O109:O124)+SUM('unit pricing 1-5 years scenario'!O126:O133)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!P101:P108)+SUM('unit pricing 1-5 years scenario'!P109:P124)+SUM('unit pricing 1-5 years scenario'!P126:P133)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!Q101:Q108)+SUM('unit pricing 1-5 years scenario'!Q109:Q124)+SUM('unit pricing 1-5 years scenario'!Q126:Q133)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!R101:R108)+SUM('unit pricing 1-5 years scenario'!R109:R124)+SUM('unit pricing 1-5 years scenario'!R126:R133)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!S101:S108)+SUM('unit pricing 1-5 years scenario'!S109:S124)+SUM('unit pricing 1-5 years scenario'!S126:S133)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!T101:T108)+SUM('unit pricing 1-5 years scenario'!T109:T124)+SUM('unit pricing 1-5 years scenario'!T126:T133)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!U101:U108)+SUM('unit pricing 1-5 years scenario'!U109:U124)+SUM('unit pricing 1-5 years scenario'!U126:U133)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!V101:V108)+SUM('unit pricing 1-5 years scenario'!V109:V124)+SUM('unit pricing 1-5 years scenario'!V126:V133)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!W101:W108)+SUM('unit pricing 1-5 years scenario'!W109:W124)+SUM('unit pricing 1-5 years scenario'!W126:W133)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!X101:X108)+SUM('unit pricing 1-5 years scenario'!X109:X124)+SUM('unit pricing 1-5 years scenario'!X126:X133)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!Y101:Y108)+SUM('unit pricing 1-5 years scenario'!Y109:Y124)+SUM('unit pricing 1-5 years scenario'!Y126:Y133)","v":0}]
[null,null,"HPS maintenance",0,{"$f":"SUM('unit pricing 1-5 years scenario'!H135:H141)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!J134:J141)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!K134:K141)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!L134:L141)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!M134:M141)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!N134:N141)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!O134:O141)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!P134:P141)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!Q134:Q141)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!R134:R141)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!S134:S141)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!T134:T141)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!U134:U141)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!V134:V141)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!W134:W141)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!X134:X141)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!Y134:Y141)","v":0}]
[null,{"$f":"+'Data Input and Instructions'!$C$72","v":0},"Carbon Price/Carbon Neutral Govn't Savings",{"$f":"SUM(F64:T64)","v":0},null,{"$f":"+'GHG savings'!I49","v":0},{"$f":"+F64*(1+$B$64)","v":0},{"$f":"+G64*(1+$B$64)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Energy consumption KWh",{"$f":"SUM(F65:T65)","v":0},null,{"$f":"SUM('unit pricing 1-5 years scenario'!J61:J68)+ SUM('unit pricing 1-5 years scenario'!J93:J100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!K61:K68)+ SUM('unit pricing 1-5 years scenario'!K93:K100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!L61:L68)+ SUM('unit pricing 1-5 years scenario'!L93:L100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!M61:M68)+ SUM('unit pricing 1-5 years scenario'!M93:M100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!N61:N68)+ SUM('unit pricing 1-5 years scenario'!N93:N100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!O61:O68)+ SUM('unit pricing 1-5 years scenario'!O93:O100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!P61:P68)+ SUM('unit pricing 1-5 years scenario'!P93:P100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!Q61:Q68)+ SUM('unit pricing 1-5 years scenario'!Q93:Q100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!R61:R68)+ SUM('unit pricing 1-5 years scenario'!R93:R100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!S61:S68)+ SUM('unit pricing 1-5 years scenario'!S93:S100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!T61:T68)+ SUM('unit pricing 1-5 years scenario'!T93:T100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!U61:U68)+ SUM('unit pricing 1-5 years scenario'!U93:U100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!V61:V68)+ SUM('unit pricing 1-5 years scenario'!V93:V100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!W61:W68)+ SUM('unit pricing 1-5 years scenario'!W93:W100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!X61:X68)+ SUM('unit pricing 1-5 years scenario'!X93:X100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!Y61:Y68)+ SUM('unit pricing 1-5 years scenario'!Y93:Y100)","v":0}]
[]
[null,"Present Value",{"$f":"C58","v":"Capital Cost"},{"$f":"SUM(F67:T67)","v":0},{"$f":"E58*E$6","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Volume Discounts",{"$f":"SUM(F68:T68)","v":0},{"$f":"E59*E$6","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Other Incentives",0,{"$f":"E60*E$6","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"C61","v":"Energy"},0,{"$f":"E61*E$6","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"U61*U$6","v":0},0,0,0,0]
[null,null,{"$f":"C62","v":"LED maintenance"},0,{"$f":"E62*E$6","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"C63","v":"HPS maintenance"},0,{"$f":"E63*E$6","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"C64","v":"Carbon Price/Carbon Neutral Govn't Savings"},0,{"$f":"E64*E$6","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Total Present Value",{"$f":"+D67+D70+D71+D72-D68-D69","v":0}]
[null,null,"Term",15]
[null,null,"Equivalent Annual Cost (EAC)",{"$f":"-PMT($C$2,D76,D75,0,0)","v":0}]
["Comparative"]
[null,null,"Total Present Value",{"$f":"+D75-D21","v":0}]
[null,null,"Term",16]
[null,null,"Equivalent Annual Cost (EAC)",{"$f":"+D77-D23","v":0}]
[null,null,"Carbon Neutral Govn't Savings",{"$f":"+D73","v":0}]
[null,null,"Volume Discounts",{"$f":"+D68","v":0}]
[null,null,"Other Incentives",{"$f":"+D69","v":0}]
[null,null,"Subtotal",{"$f":"+D79-D82-D83-D84","v":0}]
[null,null,"Rate of Savings",{"$f":"-((SUM(F70:T72)-SUM(F15:T18)-D82)/SUM(F67:T67))/15","v":{"$error":"#DIV/0!"}}]
[null,null,"Rate of Savings after discounts",{"$f":"-((SUM(F70:T72)-SUM(F15:T18)-D82-D83-D84)/SUM(F67:T67)/15)","v":{"$error":"#DIV/0!"}}]
[]
["3rd Scenario- energy efficiency with adaptive controls only (NO LED)"]
[null,"Nominal Value","Capital Cost",{"$f":"SUM(F90:T90)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!H41:H55)+SUM('unit pricing 1-5 years scenario'!H57:H63)+SUM('unit pricing 1-5 years scenario'!H65:H71)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!J21:J28)+((SUM('unit pricing 1-5 years scenario'!J29:J36)*1.3))","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!K21:K28)+((SUM('unit pricing 1-5 years scenario'!K29:K36)*1.3))","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!L21:L28)+((SUM('unit pricing 1-5 years scenario'!L29:L36)*1.3))","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!M21:M28)+((SUM('unit pricing 1-5 years scenario'!M29:M36)*1.3))","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!N21:N28)+((SUM('unit pricing 1-5 years scenario'!N29:N36)*1.3))","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!O21:O28)+((SUM('unit pricing 1-5 years scenario'!O29:O36)*1.3))","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!P21:P28)+((SUM('unit pricing 1-5 years scenario'!P29:P36)*1.3))","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!Q21:Q28)+((SUM('unit pricing 1-5 years scenario'!Q29:Q36)*1.3))","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!R21:R28)+((SUM('unit pricing 1-5 years scenario'!R29:R36)*1.3))","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!S21:S28)+((SUM('unit pricing 1-5 years scenario'!S29:S36)*1.3))","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!T21:T28)+((SUM('unit pricing 1-5 years scenario'!T29:T36)*1.3))","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!U21:U28)+((SUM('unit pricing 1-5 years scenario'!U29:U36)*1.3))","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!V21:V28)+((SUM('unit pricing 1-5 years scenario'!V29:V36)*1.3))","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!W21:W28)+((SUM('unit pricing 1-5 years scenario'!W29:W36)*1.3))","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!X21:X28)+((SUM('unit pricing 1-5 years scenario'!X29:X36)*1.3))","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!Y21:Y28)+((SUM('unit pricing 1-5 years scenario'!Y29:Y36)*1.3))","v":0}]
[null,{"$f":"+'Data Input and Instructions'!$C$66","v":0},"Volume Discounts",0,{"$f":"+E90*$B$59","v":0},{"$f":"+F90*$B$59","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+U90*(1-0.8)","v":0},{"$f":"+V90*(1-0.8)","v":0},{"$f":"+W90*(1-0.8)","v":0},{"$f":"+X90*(1-0.8)","v":0},{"$f":"+Y90*(1-0.8)","v":0}]
[null,{"$f":"+'Data Input and Instructions'!$C$67","v":0},"Other Incentives",0,{"$f":"(+E90-E91)*$B$60","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Energy",0,{"$f":"(SUM('unit pricing 1-5 years scenario'!H89:H95)+SUM('unit pricing 1-5 years scenario'!H121:H128))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!J69:J76)+SUM('unit pricing 1-5 years scenario'!J85:J92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!K69:K76)+SUM('unit pricing 1-5 years scenario'!K85:K92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!L69:L76)+SUM('unit pricing 1-5 years scenario'!L85:L92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!M69:M76)+SUM('unit pricing 1-5 years scenario'!M85:M92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!N69:N76)+SUM('unit pricing 1-5 years scenario'!N85:N92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!O69:O76)+SUM('unit pricing 1-5 years scenario'!O85:O92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!P69:P76)+SUM('unit pricing 1-5 years scenario'!P85:P92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!Q69:Q76)+SUM('unit pricing 1-5 years scenario'!Q85:Q92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!R69:R76)+SUM('unit pricing 1-5 years scenario'!R85:R92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!S69:S76)+SUM('unit pricing 1-5 years scenario'!S85:S92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!T69:T76)+SUM('unit pricing 1-5 years scenario'!T85:T92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!U69:U76)+SUM('unit pricing 1-5 years scenario'!U85:U92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!V69:V76)+SUM('unit pricing 1-5 years scenario'!V85:V92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!W69:W76)+SUM('unit pricing 1-5 years scenario'!W85:W92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!X69:X76)+SUM('unit pricing 1-5 years scenario'!X85:X92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!Y69:Y76)+SUM('unit pricing 1-5 years scenario'!Y85:Y92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!Z69:Z876)+SUM('unit pricing 1-5 years scenario'!Z85:Z92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!AA69:AA876)+SUM('unit pricing 1-5 years scenario'!AA85:AA92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!AB69:AB876)+SUM('unit pricing 1-5 years scenario'!AB85:AB92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!AC69:AC876)+SUM('unit pricing 1-5 years scenario'!AC85:AC92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!AD69:AD876)+SUM('unit pricing 1-5 years scenario'!AD85:AD92))","v":0},{"$f":"(SUM('unit pricing 1-5 years scenario'!AE69:AE876)+SUM('unit pricing 1-5 years scenario'!AE85:AE92))","v":0}]
[null,null,"LED maintenance",{"$f":"SUM(F94:T94)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!H138:H144)+SUM('unit pricing 1-5 years scenario'!H146:H160)+SUM('unit pricing 1-5 years scenario'!H162:H168)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"HPS maintenance",0,{"$f":"SUM('unit pricing 1-5 years scenario'!H170:H176)","v":0},{"$f":"+F11+F12","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"+'Data Input and Instructions'!$C$72","v":0},"Carbon Price/Carbon Neutral Govn't Savings",{"$f":"SUM(F96:T96)","v":0},null,{"$f":"+'GHG savings'!I84","v":0},{"$f":"+F96*(1+$B$64)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Energy consumption KWh",{"$f":"SUM(F97:T97)","v":0},null,{"$f":"SUM('unit pricing 1-5 years scenario'!J77:J84)+ SUM('unit pricing 1-5 years scenario'!J93:J100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!K77:K84)+ SUM('unit pricing 1-5 years scenario'!K93:K100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!L77:L84)+ SUM('unit pricing 1-5 years scenario'!L93:L100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!M77:M84)+ SUM('unit pricing 1-5 years scenario'!M93:M100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!N77:N84)+ SUM('unit pricing 1-5 years scenario'!N93:N100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!O77:O84)+ SUM('unit pricing 1-5 years scenario'!O93:O100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!P77:P84)+ SUM('unit pricing 1-5 years scenario'!P93:P100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!Q77:Q84)+ SUM('unit pricing 1-5 years scenario'!Q93:Q100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!R77:R84)+ SUM('unit pricing 1-5 years scenario'!R93:R100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!S77:S84)+ SUM('unit pricing 1-5 years scenario'!S93:S100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!T77:T84)+ SUM('unit pricing 1-5 years scenario'!T93:T100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!U77:U84)+ SUM('unit pricing 1-5 years scenario'!U93:U100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!V77:V84)+ SUM('unit pricing 1-5 years scenario'!V93:V100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!W77:W84)+ SUM('unit pricing 1-5 years scenario'!W93:W100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!X77:X84)+ SUM('unit pricing 1-5 years scenario'!X93:X100)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!Y77:Y84)+ SUM('unit pricing 1-5 years scenario'!Y93:Y100)","v":0}]
[]
[null,"Present Value",{"$f":"C90","v":"Capital Cost"},{"$f":"SUM(F99:T99)","v":0},{"$f":"E90*E$6","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Volume Discounts",{"$f":"SUM(F100:T100)","v":0},{"$f":"E91*E$6","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Other Incentives",0,{"$f":"E92*E$6","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"C93","v":"Energy"},0,{"$f":"E93*E$6","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"U93*U$6","v":0},0,0,0,0]
[null,null,{"$f":"C94","v":"LED maintenance"},0,{"$f":"E94*E$6","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"C95","v":"HPS maintenance"},0,{"$f":"E95*E$6","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"C96","v":"Carbon Price/Carbon Neutral Govn't Savings"},0,{"$f":"E96*E$6","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Total Present Value",{"$f":"+D99+D102+D103+D104-D100-D101","v":0}]
[null,null,"Term",15]
[null,null,"Equivalent Annual Cost (EAC)",{"$f":"-PMT($C$2,D108,D107,0,0)","v":0}]
["Comparative"]
[null,null,"Total Present Value",{"$f":"+D107-D21","v":0}]
[null,null,"Term",15]
[null,null,"Equivalent Annual Cost (EAC)",{"$f":"+D109-D23","v":0}]
[null,null,"Carbon Neutral Govn't Savings",{"$f":"+D105","v":0}]
[null,null,"Volume Discounts",{"$f":"+D100","v":0}]
[null,null,"Other Incentives",{"$f":"+D101","v":0}]
[null,null,"Subtotal",{"$f":"+D111-D114-D115-D116","v":0}]
[null,null,"Rate of Savings",{"$f":"-((SUM(F102:T104)-SUM(F15:T18)-D114)/SUM(F99:T99))/15","v":{"$error":"#DIV/0!"}}]
[null,null,"Rate of Savings after discounts",{"$f":"-((SUM(F102:U104)-SUM(F15:T18)-D114-D115-D116)/SUM(F99:T99)/15)","v":{"$error":"#DIV/0!"}}]
["Cumulative Comparison and Payback"]
[null,null,null,null,null,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027]
[null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[null,null,null,"Cumulative Cost HPS",null,{"$f":"+SUM(F9:F12)","v":0},{"$f":"+SUM(G9:G12)+F123","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(U9:U12)","v":0},{"$f":"+SUM(V9:V12)","v":0},{"$f":"+SUM(W9:W12)","v":0},{"$f":"+SUM(X9:X12)","v":0},{"$f":"+SUM(Y9:Y12)","v":0}]
[null,null,null,"Cumulative Cost LED no adaptive controls",null,{"$f":"+SUM('unit pricing 1-5 years scenario'!J$5:J$28)+SUM('unit pricing 1-5 years scenario'!J$37:J$44)+SUM('unit pricing 1-5 years scenario'!J$85:J$92)+SUM('unit pricing 1-5 years scenario'!J$101:J$141)","v":0},{"$f":"+SUM('unit pricing 1-5 years scenario'!K$5:K$28)+SUM('unit pricing 1-5 years scenario'!K$37:K$44)+SUM('unit pricing 1-5 years scenario'!K$85:K$92)+SUM('unit pricing 1-5 years scenario'!K$101:K$141)+F124","v":0},{"$f":"+SUM('unit pricing 1-5 years scenario'!L$5:L$28)+SUM('unit pricing 1-5 years scenario'!L$37:L$44)+SUM('unit pricing 1-5 years scenario'!L$85:L$92)+SUM('unit pricing 1-5 years scenario'!L$101:L$141)+G124","v":0},{"$f":"+SUM('unit pricing 1-5 years scenario'!M$5:M$28)+SUM('unit pricing 1-5 years scenario'!M$37:M$44)+SUM('unit pricing 1-5 years scenario'!M$85:M$92)+SUM('unit pricing 1-5 years scenario'!M$101:M$141)+H124","v":0},{"$f":"+SUM('unit pricing 1-5 years scenario'!N$5:N$28)+SUM('unit pricing 1-5 years scenario'!N$37:N$44)+SUM('unit pricing 1-5 years scenario'!N$85:N$92)+SUM('unit pricing 1-5 years scenario'!N$101:N$141)+I124","v":0},{"$f":"+SUM('unit pricing 1-5 years scenario'!O$5:O$28)+SUM('unit pricing 1-5 years scenario'!O$37:O$44)+SUM('unit pricing 1-5 years scenario'!O$85:O$92)+SUM('unit pricing 1-5 years scenario'!O$101:O$141)+J124","v":0},{"$f":"+SUM('unit pricing 1-5 years scenario'!P$5:P$28)+SUM('unit pricing 1-5 years scenario'!P$37:P$44)+SUM('unit pricing 1-5 years scenario'!P$85:P$92)+SUM('unit pricing 1-5 years scenario'!P$101:P$141)+K124","v":0},{"$f":"+SUM('unit pricing 1-5 years scenario'!Q$5:Q$28)+SUM('unit pricing 1-5 years scenario'!Q$37:Q$44)+SUM('unit pricing 1-5 years scenario'!Q$85:Q$92)+SUM('unit pricing 1-5 years scenario'!Q$101:Q$141)+L124","v":0},{"$f":"+SUM('unit pricing 1-5 years scenario'!R$5:R$28)+SUM('unit pricing 1-5 years scenario'!R$37:R$44)+SUM('unit pricing 1-5 years scenario'!R$85:R$92)+SUM('unit pricing 1-5 years scenario'!R$101:R$141)+M124","v":0},{"$f":"+SUM('unit pricing 1-5 years scenario'!S$5:S$28)+SUM('unit pricing 1-5 years scenario'!S$37:S$44)+SUM('unit pricing 1-5 years scenario'!S$85:S$92)+SUM('unit pricing 1-5 years scenario'!S$101:S$141)+N124","v":0},{"$f":"+SUM('unit pricing 1-5 years scenario'!T$5:T$28)+SUM('unit pricing 1-5 years scenario'!T$37:T$44)+SUM('unit pricing 1-5 years scenario'!T$85:T$92)+SUM('unit pricing 1-5 years scenario'!T$101:T$141)+O124","v":0},{"$f":"+SUM('unit pricing 1-5 years scenario'!U$5:U$28)+SUM('unit pricing 1-5 years scenario'!U$37:U$44)+SUM('unit pricing 1-5 years scenario'!U$85:U$92)+SUM('unit pricing 1-5 years scenario'!U$101:U$141)+P124","v":0},{"$f":"+SUM('unit pricing 1-5 years scenario'!V$5:V$28)+SUM('unit pricing 1-5 years scenario'!V$37:V$44)+SUM('unit pricing 1-5 years scenario'!V$85:V$92)+SUM('unit pricing 1-5 years scenario'!V$101:V$141)+Q124","v":0},{"$f":"+SUM('unit pricing 1-5 years scenario'!W$5:W$28)+SUM('unit pricing 1-5 years scenario'!W$37:W$44)+SUM('unit pricing 1-5 years scenario'!W$85:W$92)+SUM('unit pricing 1-5 years scenario'!W$101:W$141)+R124","v":0},{"$f":"+SUM('unit pricing 1-5 years scenario'!X$5:X$28)+SUM('unit pricing 1-5 years scenario'!X$37:X$44)+SUM('unit pricing 1-5 years scenario'!X$85:X$92)+SUM('unit pricing 1-5 years scenario'!X$101:X$141)+S124","v":0}]
[null,null,"Minimum Positive (for ROI)","Cumulative Cost LED with adaptive controls",null,{"$f":"+SUM('unit pricing 1-5 years scenario'!J$5:J$36)+SUM('unit pricing 1-5 years scenario'!J$53:J$60)+SUM('unit pricing 1-5 years scenario'!J$85:J$92)+SUM('unit pricing 1-5 years scenario'!J$101:J$141)","v":0},{"$f":"+SUM('unit pricing 1-5 years scenario'!K$5:K$36)+SUM('unit pricing 1-5 years scenario'!K$53:K$60)+SUM('unit pricing 1-5 years scenario'!K$85:K$92)+SUM('unit pricing 1-5 years scenario'!K$101:K$141)+F125","v":0},{"$f":"+SUM('unit pricing 1-5 years scenario'!L$5:L$36)+SUM('unit pricing 1-5 years scenario'!L$53:L$60)+SUM('unit pricing 1-5 years scenario'!L$85:L$92)+SUM('unit pricing 1-5 years scenario'!L$101:L$141)+G125","v":0},{"$f":"+SUM('unit pricing 1-5 years scenario'!M$5:M$36)+SUM('unit pricing 1-5 years scenario'!M$53:M$60)+SUM('unit pricing 1-5 years scenario'!M$85:M$92)+SUM('unit pricing 1-5 years scenario'!M$101:M$141)+H125","v":0},{"$f":"+SUM('unit pricing 1-5 years scenario'!N$5:N$36)+SUM('unit pricing 1-5 years scenario'!N$53:N$60)+SUM('unit pricing 1-5 years scenario'!N$85:N$92)+SUM('unit pricing 1-5 years scenario'!N$101:N$141)+I125","v":0},{"$f":"+SUM('unit pricing 1-5 years scenario'!O$5:O$36)+SUM('unit pricing 1-5 years scenario'!O$53:O$60)+SUM('unit pricing 1-5 years scenario'!O$85:O$92)+SUM('unit pricing 1-5 years scenario'!O$101:O$141)+J125","v":0},{"$f":"+SUM('unit pricing 1-5 years scenario'!P$5:P$36)+SUM('unit pricing 1-5 years scenario'!P$53:P$60)+SUM('unit pricing 1-5 years scenario'!P$85:P$92)+SUM('unit pricing 1-5 years scenario'!P$101:P$141)+K125","v":0},{"$f":"+SUM('unit pricing 1-5 years scenario'!Q$5:Q$36)+SUM('unit pricing 1-5 years scenario'!Q$53:Q$60)+SUM('unit pricing 1-5 years scenario'!Q$85:Q$92)+SUM('unit pricing 1-5 years scenario'!Q$101:Q$141)+L125","v":0},{"$f":"+SUM('unit pricing 1-5 years scenario'!R$5:R$36)+SUM('unit pricing 1-5 years scenario'!R$53:R$60)+SUM('unit pricing 1-5 years scenario'!R$85:R$92)+SUM('unit pricing 1-5 years scenario'!R$101:R$141)+M125","v":0},{"$f":"+SUM('unit pricing 1-5 years scenario'!S$5:S$36)+SUM('unit pricing 1-5 years scenario'!S$53:S$60)+SUM('unit pricing 1-5 years scenario'!S$85:S$92)+SUM('unit pricing 1-5 years scenario'!S$101:S$141)+N125","v":0},{"$f":"+SUM('unit pricing 1-5 years scenario'!T$5:T$36)+SUM('unit pricing 1-5 years scenario'!T$53:T$60)+SUM('unit pricing 1-5 years scenario'!T$85:T$92)+SUM('unit pricing 1-5 years scenario'!T$101:T$141)+O125","v":0},{"$f":"+SUM('unit pricing 1-5 years scenario'!U$5:U$36)+SUM('unit pricing 1-5 years scenario'!U$53:U$60)+SUM('unit pricing 1-5 years scenario'!U$85:U$92)+SUM('unit pricing 1-5 years scenario'!U$101:U$141)+P125","v":0},{"$f":"+SUM('unit pricing 1-5 years scenario'!V$5:V$36)+SUM('unit pricing 1-5 years scenario'!V$53:V$60)+SUM('unit pricing 1-5 years scenario'!V$85:V$92)+SUM('unit pricing 1-5 years scenario'!V$101:V$141)+Q125","v":0},{"$f":"+SUM('unit pricing 1-5 years scenario'!W$5:W$36)+SUM('unit pricing 1-5 years scenario'!W$53:W$60)+SUM('unit pricing 1-5 years scenario'!W$85:W$92)+SUM('unit pricing 1-5 years scenario'!W$101:W$141)+R125","v":0},{"$f":"+SUM('unit pricing 1-5 years scenario'!X$5:X$36)+SUM('unit pricing 1-5 years scenario'!X$53:X$60)+SUM('unit pricing 1-5 years scenario'!X$85:X$92)+SUM('unit pricing 1-5 years scenario'!X$101:X$141)+S125","v":0}]
[null,null,null,"Cumulative Cost Adaptive",null,{"$f":"SUM('unit pricing 1-5 years scenario'!J$21:J$28)+SUM('unit pricing 1-5 years scenario'!J$69:J$76)+SUM('unit pricing 1-5 years scenario'!J$85:J$92)+SUM('unit pricing 1-5 years scenario'!J$29:J$36)*1.3+SUM('Unit Pricing BAU'!J$36:J$59)","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!K$21:K$28)+SUM('unit pricing 1-5 years scenario'!K$69:K$76)+SUM('unit pricing 1-5 years scenario'!K$85:K$92)+SUM('unit pricing 1-5 years scenario'!K$29:K$36)*1.3+SUM('Unit Pricing BAU'!K$36:K$59)+F126","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!L$21:L$28)+SUM('unit pricing 1-5 years scenario'!L$69:L$76)+SUM('unit pricing 1-5 years scenario'!L$85:L$92)+SUM('unit pricing 1-5 years scenario'!L$29:L$36)*1.3+SUM('Unit Pricing BAU'!L$36:L$59)+G126","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!M$21:M$28)+SUM('unit pricing 1-5 years scenario'!M$69:M$76)+SUM('unit pricing 1-5 years scenario'!M$85:M$92)+SUM('unit pricing 1-5 years scenario'!M$29:M$36)*1.3+SUM('Unit Pricing BAU'!M$36:M$59)+H126","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!N$21:N$28)+SUM('unit pricing 1-5 years scenario'!N$69:N$76)+SUM('unit pricing 1-5 years scenario'!N$85:N$92)+SUM('unit pricing 1-5 years scenario'!N$29:N$36)*1.3+SUM('Unit Pricing BAU'!N$36:N$59)+I126","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!O$21:O$28)+SUM('unit pricing 1-5 years scenario'!O$69:O$76)+SUM('unit pricing 1-5 years scenario'!O$85:O$92)+SUM('unit pricing 1-5 years scenario'!O$29:O$36)*1.3+SUM('Unit Pricing BAU'!O$36:O$59)+J126","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!P$21:P$28)+SUM('unit pricing 1-5 years scenario'!P$69:P$76)+SUM('unit pricing 1-5 years scenario'!P$85:P$92)+SUM('unit pricing 1-5 years scenario'!P$29:P$36)*1.3+SUM('Unit Pricing BAU'!P$36:P$59)+K126","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!Q$21:Q$28)+SUM('unit pricing 1-5 years scenario'!Q$69:Q$76)+SUM('unit pricing 1-5 years scenario'!Q$85:Q$92)+SUM('unit pricing 1-5 years scenario'!Q$29:Q$36)*1.3+SUM('Unit Pricing BAU'!Q$36:Q$59)+L126","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!R$21:R$28)+SUM('unit pricing 1-5 years scenario'!R$69:R$76)+SUM('unit pricing 1-5 years scenario'!R$85:R$92)+SUM('unit pricing 1-5 years scenario'!R$29:R$36)*1.3+SUM('Unit Pricing BAU'!R$36:R$59)+M126","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!S$21:S$28)+SUM('unit pricing 1-5 years scenario'!S$69:S$76)+SUM('unit pricing 1-5 years scenario'!S$85:S$92)+SUM('unit pricing 1-5 years scenario'!S$29:S$36)*1.3+SUM('Unit Pricing BAU'!S$36:S$59)+N126","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!T$21:T$28)+SUM('unit pricing 1-5 years scenario'!T$69:T$76)+SUM('unit pricing 1-5 years scenario'!T$85:T$92)+SUM('unit pricing 1-5 years scenario'!T$29:T$36)*1.3+SUM('Unit Pricing BAU'!T$36:T$59)+O126","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!U$21:U$28)+SUM('unit pricing 1-5 years scenario'!U$69:U$76)+SUM('unit pricing 1-5 years scenario'!U$85:U$92)+SUM('unit pricing 1-5 years scenario'!U$29:U$36)*1.3+SUM('Unit Pricing BAU'!U$36:U$59)+P126","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!V$21:V$28)+SUM('unit pricing 1-5 years scenario'!V$69:V$76)+SUM('unit pricing 1-5 years scenario'!V$85:V$92)+SUM('unit pricing 1-5 years scenario'!V$29:V$36)*1.3+SUM('Unit Pricing BAU'!V$36:V$59)+Q126","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!W$21:W$28)+SUM('unit pricing 1-5 years scenario'!W$69:W$76)+SUM('unit pricing 1-5 years scenario'!W$85:W$92)+SUM('unit pricing 1-5 years scenario'!W$29:W$36)*1.3+SUM('Unit Pricing BAU'!W$36:W$59)+R126","v":0},{"$f":"SUM('unit pricing 1-5 years scenario'!X$21:X$28)+SUM('unit pricing 1-5 years scenario'!X$69:X$76)+SUM('unit pricing 1-5 years scenario'!X$85:X$92)+SUM('unit pricing 1-5 years scenario'!X$29:X$36)*1.3+SUM('Unit Pricing BAU'!X$36:X$59)+S126","v":0}]
[null,null,{"$f":"MIN(IF(F127:T127>0,F127:T127))","v":0},"Cumulative savings LED no adaptive controls",null,{"$f":"+F123-F124","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"MIN(IF(F128:T128>0,F128:T128))","v":0},"Cumulative savings LED with adaptive controls",null,{"$f":"+F123-F125","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"MIN(IF(F129:T129>0,F129:T129))","v":0},"Cumulative savings adaptive",null,{"$f":"F123-F126","v":0},{"$f":"G123-G126","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[null,null,null,"Other cumulative discounts LED no adaptive",null,{"$f":"($D$50/15)+F35+F36+F40","v":0},{"$f":"($D$50/15)+G35+G36+G40+F131","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"($D$50/15)+V35+U131","v":0},{"$f":"($D$50/15)+W35+V131","v":0},{"$f":"($D$50/15)+X35+W131","v":0},{"$f":"($D$50/15)+Y35+X131","v":0}]
[null,null,null,"Other cumulative discounts LED with adaptive",null,{"$f":"($D$82/15)+F68+F69+F73","v":0},{"$f":"($D$82/15)+G68+G69+G73+F132","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"($D$82/15)+V68+U132","v":0},{"$f":"($D$82/15)+W68+V132","v":0},{"$f":"($D$82/15)+X68+W132","v":0},{"$f":"($D$82/15)+Y68+X132","v":0}]
[null,null,null,"Other cumulative discounts adaptive only",null,{"$f":"($D$114/15)+F$100+F$101+F$105","v":0},{"$f":"($D$114/15)+G$100+G$101+G$105+F133","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Cumulative cost LED without adaptive controls after incentives",null,{"$f":"+F124-F131","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Cumulative cost LED with adaptive controls after incentives",null,{"$f":"+F125-F132","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Cumulative cost adaptive only after incentives",null,{"$f":"F126-F133","v":0},{"$f":"G126-G133","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"MIN(IF(F137:T137>0,F137:T137))","v":0},"Cumulative savings LED without adpative controls after incentives",null,{"$f":"+F127+F131","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"MIN(IF(F138:T138>0,F138:T138))","v":0},"Cumulative savings LED with adaptive controls after incentives",null,{"$f":"+F128+F132","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"MIN(IF(F139:T139>0,F139:T139))","v":0},"Cumulative savings LED adaptive only after incentives",null,{"$f":"F129+F133","v":0},{"$f":"G129+G133","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[]
[null,null,null,"Cumulative cost active",null,{"$f":"CHOOSE('Data Input and Instructions'!$E$24,Comparative!F$134,Comparative!F$135,Comparative!F$136,0)","v":0},{"$f":"CHOOSE('Data Input and Instructions'!$E$24,Comparative!G$134,Comparative!G$135,Comparative!G$136,0)","v":0},{"$f":"CHOOSE('Data Input and Instructions'!$E$24,Comparative!H$134,Comparative!H$135,Comparative!H$136,0)","v":0},{"$f":"CHOOSE('Data Input and Instructions'!$E$24,Comparative!I$134,Comparative!I$135,Comparative!I$136,0)","v":0},{"$f":"CHOOSE('Data Input and Instructions'!$E$24,Comparative!J$134,Comparative!J$135,Comparative!J$136,0)","v":0},{"$f":"CHOOSE('Data Input and Instructions'!$E$24,Comparative!K$134,Comparative!K$135,Comparative!K$136,0)","v":0},{"$f":"CHOOSE('Data Input and Instructions'!$E$24,Comparative!L$134,Comparative!L$135,Comparative!L$136,0)","v":0},{"$f":"CHOOSE('Data Input and Instructions'!$E$24,Comparative!M$134,Comparative!M$135,Comparative!M$136,0)","v":0},{"$f":"CHOOSE('Data Input and Instructions'!$E$24,Comparative!N$134,Comparative!N$135,Comparative!N$136,0)","v":0},{"$f":"CHOOSE('Data Input and Instructions'!$E$24,Comparative!O$134,Comparative!O$135,Comparative!O$136,0)","v":0},{"$f":"CHOOSE('Data Input and Instructions'!$E$24,Comparative!P$134,Comparative!P$135,Comparative!P$136,0)","v":0},{"$f":"CHOOSE('Data Input and Instructions'!$E$24,Comparative!Q$134,Comparative!Q$135,Comparative!Q$136,0)","v":0},{"$f":"CHOOSE('Data Input and Instructions'!$E$24,Comparative!R$134,Comparative!R$135,Comparative!R$136,0)","v":0},{"$f":"CHOOSE('Data Input and Instructions'!$E$24,Comparative!S$134,Comparative!S$135,Comparative!S$136,0)","v":0},{"$f":"CHOOSE('Data Input and Instructions'!$E$24,Comparative!T$134,Comparative!T$135,Comparative!T$136,0)","v":0}]
[null,null,null,"Cumulative cost bau",null,{"$f":"F$123","v":0},{"$f":"G$123","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Cumulative energy active",null,{"$f":"CHOOSE('Data Input and Instructions'!$E$24,F$41,F$65,F$97,0)","v":0},{"$f":"CHOOSE('Data Input and Instructions'!$E$24,G$41,G$65,G$97,0)+F145","v":0},{"$f":"CHOOSE('Data Input and Instructions'!$E$24,H$41,H$65,H$97,0)+G145","v":0},{"$f":"CHOOSE('Data Input and Instructions'!$E$24,I$41,I$65,I$97,0)+H145","v":0},{"$f":"CHOOSE('Data Input and Instructions'!$E$24,J$41,J$65,J$97,0)+I145","v":0},{"$f":"CHOOSE('Data Input and Instructions'!$E$24,K$41,K$65,K$97,0)+J145","v":0},{"$f":"CHOOSE('Data Input and Instructions'!$E$24,L$41,L$65,L$97,0)+K145","v":0},{"$f":"CHOOSE('Data Input and Instructions'!$E$24,M$41,M$65,M$97,0)+L145","v":0},{"$f":"CHOOSE('Data Input and Instructions'!$E$24,N$41,N$65,N$97,0)+M145","v":0},{"$f":"CHOOSE('Data Input and Instructions'!$E$24,O$41,O$65,O$97,0)+N145","v":0},{"$f":"CHOOSE('Data Input and Instructions'!$E$24,P$41,P$65,P$97,0)+O145","v":0},{"$f":"CHOOSE('Data Input and Instructions'!$E$24,Q$41,Q$65,Q$97,0)+P145","v":0},{"$f":"CHOOSE('Data Input and Instructions'!$E$24,R$41,R$65,R$97,0)+Q145","v":0},{"$f":"CHOOSE('Data Input and Instructions'!$E$24,S$41,S$65,S$97,0)+R145","v":0},{"$f":"CHOOSE('Data Input and Instructions'!$E$24,T$41,T$65,T$97,0)+S145","v":0}]
[null,null,null,"Cumulative energy bau",null,{"$f":"F19","v":0},{"$f":"G19+F146","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"One Street Light Example","index":5,"n_rows":47,"n_cols":21,"rows_kept":47,"cut":false,"hidden":true,"merged":[[36,1,37,1],[27,1,28,1],[29,1,30,1],[31,1,32,1],[33,1,34,1],[3,1,4,1],[5,1,6,1],[7,1,8,1],[9,1,10,1],[12,1,13,1]]}
[null,null,null,null,null,null,"One Street Light Example 70 Watts 50% efficiency"]
[]
[null,null,null,null,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,"Payback Period","Rate of Annual Savings"]
[null,"Lamp and Installation","HPS"]
[null,null,"LED",null,{"$f":"+'unit pricing 1-5 years scenario'!F6+'unit pricing 1-5 years scenario'!F14","v":375.9375}]
[null,"Maintenance","HPS",null,null,null,null,null,33.14,null,null,null,null,{"$f":"92.14+33.14","v":125.28},null,null,null,null,33.14]
[null,null,"LED",null,null,null,null,null,null,null,null,null,null,33]
[null,"Failures & Replacements","HPS",null,260,{"$f":"$I$6*0.1","v":3.3140000000000001},3.3140000000000001,3.3140000000000001,3.3140000000000001,3.3140000000000001,3.3140000000000001,3.3140000000000001,3.3140000000000001,3.3140000000000001,3.3140000000000001,3.3140000000000001,3.3140000000000001,3.3140000000000001,3.3140000000000001]
[null,null,"LED",null,{"$f":"($E$5*0.01)","v":3.7593749999999999},{"$f":"($E$5*0.01)","v":3.7593749999999999},3.7593749999999999,3.7593749999999999,3.7593749999999999,3.7593749999999999,3.7593749999999999,3.7593749999999999,3.7593749999999999,3.7593749999999999,3.7593749999999999,3.7593749999999999,3.7593749999999999,3.7593749999999999,3.7593749999999999]
[null,"Electricity","HPS",null,29.27,{"$f":"$E10","v":29.27},{"$f":"$E10","v":29.27},29.27,29.27,29.27,29.27,29.27,29.27,29.27,29.27,29.27,29.27,29.27,29.27]
[null,null,"LED",null,14.63,{"$f":"$E11","v":14.63},14.63,14.63,14.63,14.63,14.63,14.63,14.63,14.63,14.63,14.63,14.63,14.63,14.63]
[]
[null,"Cumulative Annual Cost","HPS",null,{"$f":"+E4+E8+E10","v":289.27},{"$f":"+F4+F6+F10+E13","v":318.53999999999996},{"$f":"+G4+G6+G10+F13","v":347.80999999999995},377.07999999999993,439.4899999999999,468.75999999999988,498.02999999999986,527.29999999999984,556.56999999999982,711.11999999999989,740.38999999999987,769.65999999999985,798.92999999999984,828.19999999999982,890.60999999999979]
[null,null,"LED",null,{"$f":"+E5+E9+E11","v":394.32687499999997},{"$f":"+E14+F5+F7+F11","v":408.95687499999997},{"$f":"+F14+G5+G7+G11","v":423.58687499999996},438.21687499999996,452.84687499999995,467.47687499999995,482.10687499999995,496.73687499999994,511.36687499999994,558.99687499999993,573.62687499999993,588.25687499999992,602.88687499999992,617.51687499999991,632.14687499999991]
[null,"Subtotal 1 (Cumulative Savings) ",null,null,{"$f":"E13-E14","v":-105.05687499999999},{"$f":"F13-F14","v":-90.416875000000005},-75.776875000000018,-61.136875000000032,-13.356875000000059,1.2831249999999272,15.923124999999914,30.5631249999999,45.203124999999886,152.12312499999996,166.76312499999995,181.40312499999993,196.04312499999992,210.6831249999999,258.46312499999988,10]
[null,"Carbon Neutral Government Savings",null,null,3,{"$f":"+E16+3","v":6},{"$f":"+F16+3","v":9},12,15,18,21,24,27,30,33,36,39,42,45]
[null,"Subtotal 2",null,null,{"$f":"+E15+E16","v":-102.05687499999999},-84.416875000000005,-66.776875000000018,-49.136875000000032,1.6431249999999409,19.283124999999927,36.923124999999914,54.5631249999999,72.203124999999886,182.12312499999996,199.76312499999995,217.40312499999993,235.04312499999992,252.6831249999999,303.46312499999988,10]
[null,"Volume Discount",null,null,{"$f":"+E5*0.1","v":37.59375}]
[null,"Subtotal 3",null,null,{"$f":"+E17+E18","v":-64.463124999999991},{"$f":"+F17+$E$18","v":-46.823125000000005},{"$f":"+G17+$E$18","v":-29.183125000000018},-11.543125000000032,39.236874999999941,56.876874999999927,74.516874999999914,92.1568749999999,109.79687499999989,219.71687499999996,237.35687499999995,254.99687499999993,272.63687499999992,290.2768749999999,341.05687499999988,8]
[null,"Power Smart Contribution",null,null,{"$f":"+E18*0.2","v":7.5187500000000007}]
[null,"Subtotal 4",null,null,{"$f":"+E19+E20","v":-56.944374999999994},{"$f":"+F19+$E$20","v":-39.304375000000007},{"$f":"+G19+$E$20","v":-21.664375000000017},-4.0243750000000311,46.755624999999938,64.395624999999924,82.035624999999911,99.675624999999897,117.31562499999988,227.23562499999997,244.87562499999996,262.51562499999994,280.15562499999993,297.79562499999992,348.57562499999989,7]
[null,"Other Incentives"]
[null,"Total",null,null,{"$f":"+E21+E22","v":-56.944374999999994},{"$f":"+F21+$E$46","v":-39.304375000000007},{"$f":"+G21+$E$46","v":-21.664375000000017},-4.0243750000000311,46.755624999999938,64.395624999999924,82.035624999999911,99.675624999999897,117.31562499999988,227.23562499999997,244.87562499999996,262.51562499999994,280.15562499999993,297.79562499999992,348.57562499999989]
[]
[]
[null,null,null,null,null,null,null,null,null,"One Street Light Example 70 Watts 70% efficiency with adaptative controls"]
[null,null,null,null,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,"Payback Period","Rate of Annual Savings"]
[null,"Lamp and Installation","HPS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E28:S28)","v":0}]
[null,null,"LED",null,{"$f":"+'unit pricing 1-5 years scenario'!F6+'unit pricing 1-5 years scenario'!F14+'unit pricing 1-5 years scenario'!F30","v":500.9375},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E29:S29)","v":500.9375}]
[null,"Maintenance","HPS",null,null,null,null,null,33.14,null,null,null,null,{"$f":"92.14+33.14","v":125.28},null,null,null,null,33.14,191.56]
[null,null,"LED",null,null,null,null,null,null,null,null,null,null,33,null,null,null,null,null,33]
[null,"Failures & Replacements","HPS",null,260,{"$f":"$I$6*0.1","v":3.3140000000000001},3.3140000000000001,3.3140000000000001,3.3140000000000001,3.3140000000000001,3.3140000000000001,3.3140000000000001,3.3140000000000001,3.3140000000000001,3.3140000000000001,3.3140000000000001,3.3140000000000001,3.3140000000000001,3.3140000000000001,306.3960000000003]
[null,null,"LED",null,{"$f":"($E$5*0.01)","v":3.7593749999999999},{"$f":"($E$5*0.01)","v":3.7593749999999999},3.7593749999999999,3.7593749999999999,3.7593749999999999,3.7593749999999999,3.7593749999999999,3.7593749999999999,3.7593749999999999,3.7593749999999999,3.7593749999999999,3.7593749999999999,3.7593749999999999,3.7593749999999999,3.7593749999999999,56.390624999999986]
[null,"Electricity","HPS",null,{"$f":"+'unit pricing 1-5 years scenario'!F86","v":32.732700000000001},{"$f":"$E34","v":32.732700000000001},{"$f":"$E34","v":32.732700000000001},32.732700000000001,32.732700000000001,32.732700000000001,32.732700000000001,32.732700000000001,32.732700000000001,32.732700000000001,32.732700000000001,32.732700000000001,32.732700000000001,32.732700000000001,32.732700000000001,490.99050000000017]
[null,null,"LED",null,{"$f":"+'unit pricing 1-5 years scenario'!F54","v":9.8198100000000004},{"$f":"$E35","v":9.8198100000000004},9.8198100000000004,9.8198100000000004,9.8198100000000004,9.8198100000000004,9.8198100000000004,9.8198100000000004,9.8198100000000004,9.8198100000000004,9.8198100000000004,9.8198100000000004,9.8198100000000004,9.8198100000000004,9.8198100000000004,147.29715000000002]
[]
[null,"Cumulative Annual Cost","HPS",null,{"$f":"+E28+E32+E34","v":292.73270000000002},{"$f":"+F28+F30+F34+E37","v":325.46540000000005},{"$f":"+G28+G30+G34+F37","v":358.19810000000007},390.93080000000009,456.8035000000001,489.53620000000012,522.26890000000014,555.00160000000017,587.73430000000019,745.74700000000018,778.47970000000021,811.21240000000023,843.94510000000025,876.67780000000027,942.55050000000028]
[null,null,"LED",null,{"$f":"+E29+E33+E35","v":514.51668499999994},{"$f":"+E38+F29+F31+F35","v":524.3364949999999},{"$f":"+F38+G29+G31+G35","v":534.15630499999986},543.97611499999982,553.79592499999978,563.61573499999975,573.43554499999971,583.25535499999967,593.07516499999963,635.89497499999959,645.71478499999955,655.53459499999951,665.35440499999947,675.17421499999944,684.9940249999994]
[null,"Subtotal 1 (Cumulative Savings)",null,null,{"$f":"E37-E38","v":-221.78398499999992},{"$f":"F37-F38","v":-198.87109499999985},-175.95820499999979,-153.04531499999973,-96.992424999999685,-74.079534999999623,-51.166644999999562,-28.253754999999501,-5.3408649999994395,{"$f":"N37-N38","v":109.85202500000059},132.76491500000066,155.67780500000072,178.59069500000078,201.50358500000084,257.55647500000089,10]
[null,"Carbon Neutral Government Savings",null,null,4.25,8.5,12.75,17,21.25,25.5,29.75,34,38.25,42.5,46.75,51,55.25,59.5,63.75]
[null,"Subtotal 2",null,null,{"$f":"+E39+E40","v":-217.53398499999992},-190.37109499999985,-163.20820499999979,-136.04531499999973,-75.742424999999685,-48.579534999999623,-21.416644999999562,5.7462450000004992,32.90913500000056,152.35202500000059,179.51491500000066,206.67780500000072,233.84069500000078,261.00358500000084,321.30647500000089,10]
[null,"Volume Discount",null,null,{"$f":"+E29*0.1","v":50.09375}]
[null,"Subtotal 3",null,null,{"$f":"+E41+E42","v":-167.44023499999992},{"$f":"+F41+$E$42","v":-140.27734499999985},{"$f":"+G41+$E$42","v":-113.11445499999979},-85.951564999999732,-25.648674999999685,1.5142150000003767,28.677105000000438,55.839995000000499,83.00288500000056,202.44577500000059,229.60866500000066,256.77155500000072,283.93444500000078,311.09733500000084,371.40022500000089,9]
[null,"Power Smart Contribution",null,null,{"$f":"+E42*0.2","v":10.018750000000001}]
[null,"Subtotal 4",null,null,{"$f":"+E43+E44","v":-157.4214849999999},{"$f":"+F43+$E$44","v":-130.25859499999984},{"$f":"+G43+$E$44","v":-103.0957049999998},-75.932814999999735,-15.629924999999684,11.532965000000377,38.695855000000435,65.858745000000496,93.021635000000558,212.46452500000061,239.62741500000067,266.79030500000073,293.95319500000079,321.11608500000085,381.4189750000009,8]
[null,"Other Incentives"]
[null,"Total",null,null,{"$f":"+E45+E46","v":-157.4214849999999},{"$f":"+F45+$E$46","v":-130.25859499999984},{"$f":"+G45+$E$46","v":-103.0957049999998},-75.932814999999735,-15.629924999999684,11.532965000000377,38.695855000000435,65.858745000000496,93.021635000000558,212.46452500000061,239.62741500000067,266.79030500000073,293.95319500000079,321.11608500000085,381.4189750000009,8]

{"sheet":"Unit Pricing BAU","index":6,"n_rows":59,"n_cols":25,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
["quantity 50",{"$f":"+'Data Input and Instructions'!C26","v":0},null,null,"phases",5,null,"year =>","annual",1,{"$f":"1+J1","v":2},{"$f":"1+K1","v":3},4,5,6,7,8,9,10,11,12,{"$f":"1+U1","v":13},{"$f":"1+V1","v":14},{"$f":"1+W1","v":15},16]
["quantity 70",{"$f":"+'Data Input and Instructions'!$C$27","v":0},null,null,null,null,null,"HPS","adjustment",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
["quantity 100",{"$f":"+'Data Input and Instructions'!C$28","v":0},null,null,null,null,null,"LED",null,0,0,0,0,{"$f":"N1/$F$1","v":1},1,1,1,1,1,1,1,1,1,1,1]
["quantity 150",{"$f":"+'Data Input and Instructions'!$C$29","v":0},null,null,"unit capital cost 50 watt  (Light bulbs only)",18,{"$f":"+$B$1","v":0},{"$f":"F4*G4","v":0},0.25,{"$f":"J$2*$H4*$I4","v":0},{"$f":"K$2*$H4*$I4*((1+$B$29)^J$1)","v":0},{"$f":"L$2*$H4*$I4*((1+$B$29)^K$1)","v":0},{"$f":"M$2*$H4*$I4*((1+$B$29)^L$1)","v":0},{"$f":"N$2*$H4*$I4*((1+$B$29)^M$1)","v":0},{"$f":"O$2*$H4*$I4*((1+$B$29)^N$1)","v":0},{"$f":"P$2*$H4*$I4*((1+$B$29)^O$1)","v":0},{"$f":"Q$2*$H4*$I4*((1+$B$29)^P$1)","v":0},{"$f":"R$2*$H4*$I4*((1+$B$29)^Q$1)","v":0},{"$f":"S$2*$H4*$I4*((1+$B$29)^R$1)","v":0},{"$f":"T$2*$H4*$I4*((1+$B$29)^S$1)","v":0},{"$f":"U$2*$H4*$I4*((1+$B$29)^T$1)","v":0},{"$f":"V$2*$H4*$I4*((1+$B$29)^U$1)","v":0},{"$f":"W$2*$H4*$I4*((1+$B$29)^V$1)","v":0},{"$f":"X$2*$H4*$I4*((1+$B$29)^W$1)","v":0},{"$f":"Y$2*$H4*$I4*((1+$B$29)^X$1)","v":0}]
["quantity 200",{"$f":"+'Data Input and Instructions'!$C$30","v":0},null,null,"unit capital cost 70 watt  (Light bulbs only)",14,{"$f":"+$B$2","v":0},{"$f":"F5*G5","v":0},0.25,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["quantity 250",{"$f":"+'Data Input and Instructions'!$C$31","v":0},null,null,"unit capital cost 100 watt  (Light bulbs only)",13,{"$f":"+$B$3","v":0},0,0.25,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["quantity 400",{"$f":"+'Data Input and Instructions'!C32","v":0},null,null,"unit capital cost 150 watt  (Light bulbs only)",13,{"$f":"+$B$4","v":0},0,0.25,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["quantity 1000",{"$f":"+'Data Input and Instructions'!C33","v":0},null,null,"unit capital cost 200 watt  (Light bulbs only)",15,{"$f":"+$B$5","v":0},0,0.25,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total",{"$f":"SUM(B1:B8)","v":0},null,null,"unit capital cost 250 watt  (Light bulbs only)",13,{"$f":"+$B$6","v":0},0,0.25,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"unit capital cost 400 watt  (Light bulbs only)",13,{"$f":"+$B$7","v":0},0,0.25,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"unit capital cost 1000 watt  (Light bulbs only)",19,{"$f":"+$B$8","v":0},0,0.25,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Installation cost 50 watt  (relamping included in group maintenance)",null,{"$f":"+$B$1","v":0},{"$f":"F12*G12","v":0},0.3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Installation cost 70 watt  (relamping included in group maintenance)",null,{"$f":"+$B$2","v":0},{"$f":"F13*G13","v":0},0.3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["BCHydro Rate Oct 30, 2012",{"$f":"+'Data Input and Instructions'!$C$63","v":2.9975000000000002E-2},"per watt per month",null,"Installation cost 100 watt  (relamping included in group maintenance)",null,{"$f":"+$B$3","v":0},{"$f":"F14*G14","v":0},0.3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Installation cost 150 watt  (relamping included in group maintenance)",null,{"$f":"+$B$4","v":0},0,0.3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Installation cost 200 watt  (relamping included in group maintenance)",null,{"$f":"+$B$5","v":0},0,0.3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"KWh","Installation cost 250 watt  (relamping included in group maintenance)",null,{"$f":"+$B$6","v":0},0,0.3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["watts 50 watt HPS",{"$f":"+'ballast losses'!F3","v":67.5},{"$f":"B18*12*$B$14","v":24.27975},{"$f":"+($B18*4000)/1000","v":270},"Installation cost 400 watt  (relamping included in group maintenance)",null,{"$f":"+$B$7","v":0},0,0.3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["watts 70 watt HPS",{"$f":"+'ballast losses'!F4","v":91},32.732700000000001,364,"Installation cost 1000 watt  (relamping included in group maintenance)",null,{"$f":"+$B$8","v":0},0,0.3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["watts 100 watt HPS",{"$f":"+'ballast losses'!F5","v":130},46.761000000000003,520,"energy cost 50 HPS",{"$f":"+C18+IF('Data Input and Instructions'!$C$11=\"1703\",0.8309,0)","v":24.27975},{"$f":"+$B$1","v":0},{"$f":"F20*G20","v":0},1,{"$f":"+H20","v":0},{"$f":"$H20*((1+'Data Input and Instructions'!$C$64)^J$1)","v":0},{"$f":"$H20*((1+'Data Input and Instructions'!$C$64)^K$1)","v":0},{"$f":"$H20*((1+'Data Input and Instructions'!$C$64)^L$1)","v":0},{"$f":"$H20*((1+'Data Input and Instructions'!$C$64)^M$1)","v":0},{"$f":"$H20*((1+'Data Input and Instructions'!$C$64)^N$1)","v":0},{"$f":"$H20*((1+'Data Input and Instructions'!$C$64)^O$1)","v":0},{"$f":"$H20*((1+'Data Input and Instructions'!$C$64)^P$1)","v":0},{"$f":"$H20*((1+'Data Input and Instructions'!$C$64)^Q$1)","v":0},{"$f":"$H20*((1+'Data Input and Instructions'!$C$64)^R$1)","v":0},{"$f":"$H20*((1+'Data Input and Instructions'!$C$64)^S$1)","v":0},{"$f":"$H20*((1+'Data Input and Instructions'!$C$64)^T$1)","v":0},{"$f":"$H20*((1+'Data Input and Instructions'!$C$64)^U$1)","v":0},{"$f":"$H20*((1+'Data Input and Instructions'!$C$64)^V$1)","v":0},{"$f":"$H20*((1+'Data Input and Instructions'!$C$64)^W$1)","v":0},{"$f":"$H20*((1+'Data Input and Instructions'!$C$64)^X$1)","v":0}]
["watts 150 watt HPS",{"$f":"+'ballast losses'!F6","v":187.5},67.443750000000009,750,"energy cost 70 HPS",{"$f":"+C19+IF('Data Input and Instructions'!$C$11=\"1703\",0.8309,0)","v":32.732700000000001},{"$f":"+$B$2","v":0},0,1,{"$f":"+H21","v":0},{"$f":"$H21*((1+'Data Input and Instructions'!$C$64)^J$1)","v":0},{"$f":"$H21*((1+'Data Input and Instructions'!$C$64)^K$1)","v":0},{"$f":"$H21*((1+'Data Input and Instructions'!$C$64)^L$1)","v":0},{"$f":"$H21*((1+'Data Input and Instructions'!$C$64)^M$1)","v":0},{"$f":"$H21*((1+'Data Input and Instructions'!$C$64)^N$1)","v":0},{"$f":"$H21*((1+'Data Input and Instructions'!$C$64)^O$1)","v":0},{"$f":"$H21*((1+'Data Input and Instructions'!$C$64)^P$1)","v":0},{"$f":"$H21*((1+'Data Input and Instructions'!$C$64)^Q$1)","v":0},{"$f":"$H21*((1+'Data Input and Instructions'!$C$64)^R$1)","v":0},{"$f":"$H21*((1+'Data Input and Instructions'!$C$64)^S$1)","v":0},{"$f":"$H21*((1+'Data Input and Instructions'!$C$64)^T$1)","v":0},{"$f":"$H21*((1+'Data Input and Instructions'!$C$64)^U$1)","v":0},{"$f":"$H21*((1+'Data Input and Instructions'!$C$64)^V$1)","v":0},{"$f":"$H21*((1+'Data Input and Instructions'!$C$64)^W$1)","v":0},{"$f":"$H21*((1+'Data Input and Instructions'!$C$64)^X$1)","v":0}]
["watts 200 watt HPS",{"$f":"+'ballast losses'!F7","v":240},86.328000000000003,960,"energy cost 100 HPS",{"$f":"+C20+IF('Data Input and Instructions'!$C$11=\"1703\",0.8309,0)","v":46.761000000000003},{"$f":"+$B$3","v":0},0,1,{"$f":"+H22","v":0},{"$f":"$H22*((1+'Data Input and Instructions'!$C$64)^J$1)","v":0},{"$f":"$H22*((1+'Data Input and Instructions'!$C$64)^K$1)","v":0},{"$f":"$H22*((1+'Data Input and Instructions'!$C$64)^L$1)","v":0},{"$f":"$H22*((1+'Data Input and Instructions'!$C$64)^M$1)","v":0},{"$f":"$H22*((1+'Data Input and Instructions'!$C$64)^N$1)","v":0},{"$f":"$H22*((1+'Data Input and Instructions'!$C$64)^O$1)","v":0},{"$f":"$H22*((1+'Data Input and Instructions'!$C$64)^P$1)","v":0},{"$f":"$H22*((1+'Data Input and Instructions'!$C$64)^Q$1)","v":0},{"$f":"$H22*((1+'Data Input and Instructions'!$C$64)^R$1)","v":0},{"$f":"$H22*((1+'Data Input and Instructions'!$C$64)^S$1)","v":0},{"$f":"$H22*((1+'Data Input and Instructions'!$C$64)^T$1)","v":0},{"$f":"$H22*((1+'Data Input and Instructions'!$C$64)^U$1)","v":0},{"$f":"$H22*((1+'Data Input and Instructions'!$C$64)^V$1)","v":0},{"$f":"$H22*((1+'Data Input and Instructions'!$C$64)^W$1)","v":0},{"$f":"$H22*((1+'Data Input and Instructions'!$C$64)^X$1)","v":0}]
["watts 250 watt HPS",{"$f":"+'ballast losses'!F8","v":295},106.11150000000001,1180,"energy cost 150 HPS",{"$f":"+C21+IF('Data Input and Instructions'!$C$11=\"1703\",0.8309,0)","v":67.443750000000009},{"$f":"+$B$4","v":0},0,1,0,{"$f":"$H23*((1+'Data Input and Instructions'!$C$64)^J$1)","v":0},{"$f":"$H23*((1+'Data Input and Instructions'!$C$64)^K$1)","v":0},{"$f":"$H23*((1+'Data Input and Instructions'!$C$64)^L$1)","v":0},{"$f":"$H23*((1+'Data Input and Instructions'!$C$64)^M$1)","v":0},{"$f":"$H23*((1+'Data Input and Instructions'!$C$64)^N$1)","v":0},{"$f":"$H23*((1+'Data Input and Instructions'!$C$64)^O$1)","v":0},{"$f":"$H23*((1+'Data Input and Instructions'!$C$64)^P$1)","v":0},{"$f":"$H23*((1+'Data Input and Instructions'!$C$64)^Q$1)","v":0},{"$f":"$H23*((1+'Data Input and Instructions'!$C$64)^R$1)","v":0},{"$f":"$H23*((1+'Data Input and Instructions'!$C$64)^S$1)","v":0},{"$f":"$H23*((1+'Data Input and Instructions'!$C$64)^T$1)","v":0},{"$f":"$H23*((1+'Data Input and Instructions'!$C$64)^U$1)","v":0},{"$f":"$H23*((1+'Data Input and Instructions'!$C$64)^V$1)","v":0},{"$f":"$H23*((1+'Data Input and Instructions'!$C$64)^W$1)","v":0},{"$f":"$H23*((1+'Data Input and Instructions'!$C$64)^X$1)","v":0}]
["watts 400 watt HPS",{"$f":"+'ballast losses'!F9","v":456},164.0232,1824,"energy cost 200 HPS",{"$f":"+C22+IF('Data Input and Instructions'!$C$11=\"1703\",0.8309,0)","v":86.328000000000003},{"$f":"+$B$5","v":0},0,1,0,{"$f":"$H24*((1+'Data Input and Instructions'!$C$64)^J$1)","v":0},{"$f":"$H24*((1+'Data Input and Instructions'!$C$64)^K$1)","v":0},{"$f":"$H24*((1+'Data Input and Instructions'!$C$64)^L$1)","v":0},{"$f":"$H24*((1+'Data Input and Instructions'!$C$64)^M$1)","v":0},{"$f":"$H24*((1+'Data Input and Instructions'!$C$64)^N$1)","v":0},{"$f":"$H24*((1+'Data Input and Instructions'!$C$64)^O$1)","v":0},{"$f":"$H24*((1+'Data Input and Instructions'!$C$64)^P$1)","v":0},{"$f":"$H24*((1+'Data Input and Instructions'!$C$64)^Q$1)","v":0},{"$f":"$H24*((1+'Data Input and Instructions'!$C$64)^R$1)","v":0},{"$f":"$H24*((1+'Data Input and Instructions'!$C$64)^S$1)","v":0},{"$f":"$H24*((1+'Data Input and Instructions'!$C$64)^T$1)","v":0},{"$f":"$H24*((1+'Data Input and Instructions'!$C$64)^U$1)","v":0},{"$f":"$H24*((1+'Data Input and Instructions'!$C$64)^V$1)","v":0},{"$f":"$H24*((1+'Data Input and Instructions'!$C$64)^W$1)","v":0},{"$f":"$H24*((1+'Data Input and Instructions'!$C$64)^X$1)","v":0}]
["watts 1000 watt HPS",{"$f":"+'ballast losses'!F10","v":1110},399.267,4440,"energy cost 250 HPS",{"$f":"+C23+IF('Data Input and Instructions'!$C$11=\"1703\",0.8309,0)","v":106.11150000000001},{"$f":"+$B$6","v":0},0,1,0,{"$f":"$H25*((1+'Data Input and Instructions'!$C$64)^J$1)","v":0},{"$f":"$H25*((1+'Data Input and Instructions'!$C$64)^K$1)","v":0},{"$f":"$H25*((1+'Data Input and Instructions'!$C$64)^L$1)","v":0},{"$f":"$H25*((1+'Data Input and Instructions'!$C$64)^M$1)","v":0},{"$f":"$H25*((1+'Data Input and Instructions'!$C$64)^N$1)","v":0},{"$f":"$H25*((1+'Data Input and Instructions'!$C$64)^O$1)","v":0},{"$f":"$H25*((1+'Data Input and Instructions'!$C$64)^P$1)","v":0},{"$f":"$H25*((1+'Data Input and Instructions'!$C$64)^Q$1)","v":0},{"$f":"$H25*((1+'Data Input and Instructions'!$C$64)^R$1)","v":0},{"$f":"$H25*((1+'Data Input and Instructions'!$C$64)^S$1)","v":0},{"$f":"$H25*((1+'Data Input and Instructions'!$C$64)^T$1)","v":0},{"$f":"$H25*((1+'Data Input and Instructions'!$C$64)^U$1)","v":0},{"$f":"$H25*((1+'Data Input and Instructions'!$C$64)^V$1)","v":0},{"$f":"$H25*((1+'Data Input and Instructions'!$C$64)^W$1)","v":0},{"$f":"$H25*((1+'Data Input and Instructions'!$C$64)^X$1)","v":0}]
[null,null,null,null,"energy cost 400 HPS",{"$f":"+C24+IF('Data Input and Instructions'!$C$11=\"1703\",0.8309,0)","v":164.0232},{"$f":"+$B$7","v":0},{"$f":"F26*G26*I26","v":0},1,0,{"$f":"$H26*((1+'Data Input and Instructions'!$C$64)^J$1)","v":0},{"$f":"$H26*((1+'Data Input and Instructions'!$C$64)^K$1)","v":0},{"$f":"$H26*((1+'Data Input and Instructions'!$C$64)^L$1)","v":0},{"$f":"$H26*((1+'Data Input and Instructions'!$C$64)^M$1)","v":0},{"$f":"$H26*((1+'Data Input and Instructions'!$C$64)^N$1)","v":0},{"$f":"$H26*((1+'Data Input and Instructions'!$C$64)^O$1)","v":0},{"$f":"$H26*((1+'Data Input and Instructions'!$C$64)^P$1)","v":0},{"$f":"$H26*((1+'Data Input and Instructions'!$C$64)^Q$1)","v":0},{"$f":"$H26*((1+'Data Input and Instructions'!$C$64)^R$1)","v":0},{"$f":"$H26*((1+'Data Input and Instructions'!$C$64)^S$1)","v":0},{"$f":"$H26*((1+'Data Input and Instructions'!$C$64)^T$1)","v":0},{"$f":"$H26*((1+'Data Input and Instructions'!$C$64)^U$1)","v":0},{"$f":"$H26*((1+'Data Input and Instructions'!$C$64)^V$1)","v":0},{"$f":"$H26*((1+'Data Input and Instructions'!$C$64)^W$1)","v":0},{"$f":"$H26*((1+'Data Input and Instructions'!$C$64)^X$1)","v":0}]
[null,null,null,null,"energy cost 1000 HPS",{"$f":"+C25+IF('Data Input and Instructions'!$C$11=\"1703\",0.8309,0)","v":399.267},{"$f":"+$B$8","v":0},{"$f":"F27*G27*I27","v":0},1,0,{"$f":"$H27*((1+'Data Input and Instructions'!$C$64)^J$1)","v":0},{"$f":"$H27*((1+'Data Input and Instructions'!$C$64)^K$1)","v":0},{"$f":"$H27*((1+'Data Input and Instructions'!$C$64)^L$1)","v":0},{"$f":"$H27*((1+'Data Input and Instructions'!$C$64)^M$1)","v":0},{"$f":"$H27*((1+'Data Input and Instructions'!$C$64)^N$1)","v":0},{"$f":"$H27*((1+'Data Input and Instructions'!$C$64)^O$1)","v":0},{"$f":"$H27*((1+'Data Input and Instructions'!$C$64)^P$1)","v":0},{"$f":"$H27*((1+'Data Input and Instructions'!$C$64)^Q$1)","v":0},{"$f":"$H27*((1+'Data Input and Instructions'!$C$64)^R$1)","v":0},{"$f":"$H27*((1+'Data Input and Instructions'!$C$64)^S$1)","v":0},{"$f":"$H27*((1+'Data Input and Instructions'!$C$64)^T$1)","v":0},{"$f":"$H27*((1+'Data Input and Instructions'!$C$64)^U$1)","v":0},{"$f":"$H27*((1+'Data Input and Instructions'!$C$64)^V$1)","v":0},{"$f":"$H27*((1+'Data Input and Instructions'!$C$64)^W$1)","v":0},{"$f":"$H27*((1+'Data Input and Instructions'!$C$64)^X$1)","v":0}]
[null,null,null,null,"energy KWh 50 HPS",{"$f":"+D18","v":270},{"$f":"+$B$1","v":0},{"$f":"F28*G28","v":0},1,{"$f":"+$H28","v":0},{"$f":"+$H28","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Inflation",{"$f":"+'Data Input and Instructions'!C68","v":0.02},null,null,"energy KWh 70 HPS",364,{"$f":"+$B$2","v":0},{"$f":"F29*G29","v":0},1,{"$f":"+$H29","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"energy KWh 100 HPS",520,{"$f":"+$B$3","v":0},{"$f":"F30*G30","v":0},1,{"$f":"+$H30","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"energy KWh 150 HPS",750,{"$f":"+$B$4","v":0},0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"energy KWh 200 HPS",960,{"$f":"+$B$5","v":0},0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"energy KWh 250 HPS",1180,{"$f":"+$B$6","v":0},0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"energy KWh 400 HPS",1824,{"$f":"+$B$7","v":0},0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"energy KWh 1000 HPS",4440,{"$f":"+$B$8","v":0},0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"reactive maintenance (failures) cost 50 HPS",150,{"$f":"+$B$1","v":0},{"$f":"F36*G36","v":0},0.1,{"$f":"J$2*$H36*$I36","v":0},{"$f":"K$2*$H36*$I36*((1+$B$29)^J$1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"reactive maintenance (failures) cost 70 HPS",150,{"$f":"+$B$2","v":0},{"$f":"F37*G37","v":0},0.1,{"$f":"J$2*$H37*$I37","v":0},{"$f":"K$2*$H37*$I37*((1+$B$29)^J$1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"reactive maintenance (failures) cost 100 HPS",150,{"$f":"+$B$3","v":0},{"$f":"F38*G38","v":0},0.1,{"$f":"J$2*$H38*$I38","v":0},{"$f":"K$2*$H38*$I38*((1+$B$29)^J$1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"reactive maintenance (failures) cost 150 HPS",150,{"$f":"+$B$4","v":0},0,0.1,0,{"$f":"K$2*$H39*$I39*((1+$B$29)^J$1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"reactive maintenance (failures) cost 200 HPS",150,{"$f":"+$B$5","v":0},0,0.1,0,{"$f":"K$2*$H40*$I40*((1+$B$29)^J$1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"reactive maintenance (failures) cost 250 HPS",150,{"$f":"+$B$6","v":0},0,0.1,0,{"$f":"K$2*$H41*$I41*((1+$B$29)^J$1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"reactive maintenance (failures) cost 400 HPS",150,{"$f":"+$B$7","v":0},0,0.1,0,{"$f":"K$2*$H42*$I42*((1+$B$29)^J$1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"reactive maintenance (failures) cost 1000 HPS",150,{"$f":"+$B$8","v":0},0,0.1,0,{"$f":"K$2*$H43*$I43*((1+$B$29)^J$1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"luminaire maintenance (replacements) 50 HPS",99,{"$f":"+$B$1","v":0},0,0.05,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"luminaire maintenance (replacements) 70 HPS",99,{"$f":"+$B$2","v":0},{"$f":"F45*G45","v":0},0.05,0,{"$f":"K$2*$H45*$I45*((1+$B$29)^J$1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"luminaire maintenance (replacements) 100 HPS",154,{"$f":"+$B$3","v":0},{"$f":"F46*G46","v":0},0.05,0,{"$f":"K$2*$H46*$I46*((1+$B$29)^J$1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"luminaire maintenance (replacements)150 HPS",154,{"$f":"+$B$4","v":0},{"$f":"F47*G47","v":0},0.05,0,{"$f":"K$2*$H47*$I47*((1+$B$29)^J$1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"luminaire maintenance (replacements)200 HPS",{"$f":"+F47*1.2","v":184.79999999999998},{"$f":"+$B$5","v":0},{"$f":"F48*G48","v":0},0.05,0,{"$f":"K$2*$H48*$I48*((1+$B$29)^J$1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"luminaire maintenance (replacements) 250 HPS",184.8,{"$f":"+$B$6","v":0},0,0.05,0,{"$f":"K$2*$H49*$I49*((1+$B$29)^J$1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"luminaire maintenance (replacements) 400 HPS",{"$f":"+F49*1.2","v":221.76000000000002},{"$f":"+$B$7","v":0},0,0.05,0,{"$f":"K$2*$H50*$I50*((1+$B$29)^J$1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"luminaire maintenance (replacements) 1000 HPS",{"$f":"+F50*1.2","v":266.11200000000002},{"$f":"+$B$8","v":0},0,0.05,0,{"$f":"K$2*$H51*$I51*((1+$B$29)^J$1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"group maintenance(scheduled)cost 50 HPS (ncludes re-lamping)",33.14,{"$f":"+$B$1","v":0},{"$f":"F52*G52","v":0},0.25,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"group maintenance(scheduled)cost 70 HPS (ncludes re-lamping)",33.14,{"$f":"+$B$2","v":0},{"$f":"F53*G53","v":0},0.25,0,{"$f":"K$2*$H53*$I53*((1+$B$29)^J$1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"group maintenance(scheduled)cost 100 HPS (ncludes re-lamping)",33.14,{"$f":"+$B$3","v":0},{"$f":"F54*G54","v":0},0.25,0,{"$f":"K$2*$H54*$I54*((1+$B$29)^J$1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"group maintenance(scheduled)cost 150 HPS (ncludes re-lamping)",33.14,{"$f":"+$B$4","v":0},0,0.25,0,{"$f":"K$2*$H55*$I55*((1+$B$29)^J$1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"group maintenance(scheduled)cost 200 HPS (ncludes re-lamping)",33.14,{"$f":"+$B$5","v":0},0,0.25,0,{"$f":"K$2*$H56*$I56*((1+$B$29)^J$1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"group maintenance(scheduled)cost 250 HPS (ncludes re-lamping)",33.14,{"$f":"+$B$6","v":0},0,0.25,0,{"$f":"K$2*$H57*$I57*((1+$B$29)^J$1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"group maintenance(scheduled)cost 400 HPS (ncludes re-lamping)",33.14,{"$f":"+$B$7","v":0},0,0.25,0,{"$f":"K$2*$H58*$I58*((1+$B$29)^J$1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"group maintenance(scheduled)cost 1000 HPS (ncludes re-lamping)",33.14,{"$f":"+$B$8","v":0},0,0.25,0,{"$f":"K$2*$H59*$I59*((1+$B$29)^J$1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"unit pricing 1-5 years scenario","index":7,"n_rows":169,"n_cols":25,"rows_kept":169,"cut":false,"hidden":true,"merged":[[1,4,2,4]]}
[]
[null,null,null,null,null,5,null,"year =>","annual",1,{"$f":"1+J2","v":2},{"$f":"1+K2","v":3},4,5,6,7,8,9,10,11,12,{"$f":"1+U2","v":13},{"$f":"1+V2","v":14},{"$f":"1+W2","v":15},16]
["quantity 50",{"$f":"+'Data Input and Instructions'!C26","v":0},null,null,null,null,null,"HPS","adjustment",{"$f":"IF('Data Input and Instructions'!$C$25>1,(1-(1/'Data Input and Instructions'!$C$25)),0)","v":0},{"$f":"IF('Data Input and Instructions'!C25<=2,0,(1-(1/'Data Input and Instructions'!C25)-J4))","v":0},{"$f":"IF('Data Input and Instructions'!C25<=3,0,(1-(1/'Data Input and Instructions'!C25)-K4))","v":0},{"$f":"IF('Data Input and Instructions'!C25<=4,0,(1-(1/'Data Input and Instructions'!C25)-L4))","v":0},{"$f":"IF('Data Input and Instructions'!C25<=5,0,(1/'Data Input and Instructions'!C25)-M4)","v":0},0,0,0,0,0,0,0,0,0,0,0]
["quantity 70",{"$f":"+'Data Input and Instructions'!$C$27","v":0},null,null,null,null,null,"LED",null,{"$f":"1-J3","v":1},{"$f":"IF(J3=0,1,1-K3)","v":1},{"$f":"IF(K3=0,1,1-L3)","v":1},{"$f":"IF(L3=0,1,1-M3)","v":1},{"$f":"IF(M3=0,1,1-N3)","v":1},1,1,1,1,1,1,1,1,1,1,1]
["quantity 100",{"$f":"+'Data Input and Instructions'!C28","v":0},null,null,"unit capital cost 50 watt LED (including procurement fee)",{"$f":"'Data Input and Instructions'!C39*(1+$B$54)","v":200.5},{"$f":"+$B$3","v":0},{"$f":"F5*G5","v":0},{"$f":"1-$B$13","v":0.9},{"$f":"$J$4*$H5*$I5^(J$2-1)","v":0},{"$f":"IF(AND($J$3=0,$J$4=1),0,($H5*$I5^(K$2-1)))","v":0},{"$f":"IF(AND($K$3=0,$K$4=1),0,($J$4*$H5*$I5^(L$2-1)))","v":0},{"$f":"IF(AND($L$3=0,$L$4=1),0,($J$4*$H5*$I5^(M$2-1)))","v":0},{"$f":"IF(AND($M$3=0,$M$4=1),0,($J$4*$H5*$I5^(N$2-1)))","v":0}]
["quantity 150",{"$f":"+'Data Input and Instructions'!$C$29","v":0},null,null,"unit capital cost 70 watt LED (including procurement fee)",{"$f":"'Data Input and Instructions'!C40*(1+$B$54)","v":215.53749999999999},{"$f":"+$B$4","v":0},0,0.9,0,{"$f":"IF(AND($J$3=0,$J$4=1),0,($J$4*$H6*$I6^(K$2-1)))","v":0},{"$f":"IF(AND($K$3=0,$K$4=1),0,($J$4*$H6*$I6^(L$2-1)))","v":0},{"$f":"IF(AND($L$3=0,$L$4=1),0,($J$4*$H6*$I6^(M$2-1)))","v":0},{"$f":"IF(AND($M$3=0,$M$4=1),0,($J$4*$H6*$I6^(N$2-1)))","v":0}]
["quantity 200",{"$f":"+'Data Input and Instructions'!$C$30","v":0},null,null,"unit capital cost 100 watt LED (including procurement fee)",{"$f":"'Data Input and Instructions'!C41*(1+$B$54)","v":242.25412499999999},{"$f":"+$B$5","v":0},0,0.9,0,{"$f":"IF(AND($J$3=0,$J$4=1),0,($J$4*$H7*$I7^(K$2-1)))","v":0},0,{"$f":"IF(AND($L$3=0,$L$4=1),0,($J$4*$H7*$I7^(M$2-1)))","v":0},0]
["quantity 250",{"$f":"+'Data Input and Instructions'!$C$31","v":0},null,null,"unit capital cost 150 watt LED (including procurement fee)",{"$f":"'Data Input and Instructions'!C42*(1+$B$54)","v":262.33420000000001},{"$f":"+$B$6","v":0},0,0.9,{"$f":"$J$4*$H8*$I8^(J$2-1)","v":0},0,0,0,0]
["quantity 400",{"$f":"+'Data Input and Instructions'!C32","v":0},null,null,"unit capital cost 200 watt LED (including procurement fee)",{"$f":"'Data Input and Instructions'!C43*(1+$B$54)","v":343.85749999999996},{"$f":"+$B$7","v":0},0,0.9,{"$f":"$J$4*$H9*$I9^(J$2-1)","v":0},0,0,0,0]
["quantity 1000",{"$f":"+'Data Input and Instructions'!C33","v":0},null,null,"unit capital cost 250 watt LED (including procurement fee)",{"$f":"'Data Input and Instructions'!C44*(1+$B$54)","v":418.67407499999996},{"$f":"+$B$8","v":0},0,0.9,{"$f":"$J$4*$H10*$I10^(J$2-1)","v":0},0,0,0,0]
["Total",{"$f":"SUM(B4:B10)","v":0},null,null,"unit capital cost 400 watt LED (including procurement fee)",{"$f":"'Data Input and Instructions'!C45*(1+$B$54)","v":452.65882499999992},{"$f":"+$B$9","v":0},{"$f":"F11*G11","v":0},0.9,{"$f":"$J$4*$H11*$I11^(J$2-1)","v":0},0,0,0,0]
[null,null,null,null,"unit capital cost 1000 watt LED (including procurement fee)",{"$f":"'Data Input and Instructions'!C46*(1+$B$54)","v":701.75},{"$f":"+$B$10","v":0},{"$f":"F12*G12","v":0},0.9,0,0,0,0,0]
["led price reductions over first 5 years",0.1,null,null,"Installation cost 50 watt LED (including procurement fee)",{"$f":"'Data Input and Instructions'!C$47*(1+$B$54)","v":160.39999999999998},{"$f":"+$B$3","v":0},{"$f":"F13*G13","v":0},0.9,0,0,0,0,0]
["BCHydro Rate Oct 30, 2012",{"$f":"+'Data Input and Instructions'!$C$63","v":2.9975000000000002E-2},"per watt per month",null,"Installation cost 70 watt LED (including procurement fee)",{"$f":"'Data Input and Instructions'!C$47*(1+$B$54)","v":160.39999999999998},{"$f":"+$B$4","v":0},{"$f":"F14*G14","v":0},0.9,0,0,0,0,0]
["estimated LED efficiency",{"$f":"+'Data Input and Instructions'!$C$59","v":0.5},{"$f":"+'Data Input and Instructions'!$C$60","v":0.7},{"$f":"+'Data Input and Instructions'!C61","v":0.2},"Installation cost 100 watt LED (including procurement fee)",{"$f":"'Data Input and Instructions'!C$47*(1+$B$54)","v":160.39999999999998},{"$f":"+$B$5","v":0},{"$f":"F15*G15","v":0},0.9,0,0,0,0,0]
[null,null,null,"KWh","Installation cost 150 watt LED (including procurement fee)",{"$f":"'Data Input and Instructions'!C$47*(1+$B$54)","v":160.39999999999998},{"$f":"+$B$6","v":0},{"$f":"F16*G16","v":0},0.9,0,0,0,0,0]
["watts 50 watt HPS",{"$f":"+'ballast losses'!F3","v":67.5},{"$f":"B17*12*$B$14","v":24.27975},{"$f":"+($B17*4000)/1000","v":270},"Installation cost 200 watt LED (including procurement fee)",{"$f":"'Data Input and Instructions'!C$47*(1+$B$54)","v":160.39999999999998},{"$f":"+$B$7","v":0},0,0.9,0,0,0,0,0]
["watts 70 watt HPS",{"$f":"+'ballast losses'!F4","v":91},32.732700000000001,364,"Installation cost 250 watt LED (including procurement fee)",{"$f":"'Data Input and Instructions'!C$47*(1+$B$54)","v":160.39999999999998},{"$f":"+$B$8","v":0},0,0.9,0,0,0,0,0]
["watts 100 watt HPS",{"$f":"+'ballast losses'!F5","v":130},46.761000000000003,520,"Installation cost 400 watt LED (including procurement fee)",{"$f":"'Data Input and Instructions'!C$47*(1+$B$54)","v":160.39999999999998},{"$f":"+$B$9","v":0},0,0.9,0,0,0,0,0]
["watts 150 watt HPS",{"$f":"+'ballast losses'!F6","v":187.5},67.443750000000009,750,"Installation cost 10000 watt LED (including procurement fee)",{"$f":"'Data Input and Instructions'!C$47*(1+$B$54)","v":160.39999999999998},{"$f":"+$B$10","v":0},0,0.9,0,0,0,0,0]
["watts 200 watt HPS",{"$f":"+'ballast losses'!F7","v":240},86.328000000000003,960,"Consulting cost 50 watt LED ",{"$f":"(+F5*$B$52)","v":2.0049999999999999},{"$f":"+$B$3","v":0},{"$f":"F21*G21","v":0},0.9,{"$f":"$J$4*$H21","v":0},0,0,0,0]
["watts 250 watt HPS",{"$f":"+'ballast losses'!F8","v":295},106.11150000000001,1180,"Consulting cost 70 watt LED ",2.1553749999999998,{"$f":"+$B$4","v":0},{"$f":"F22*G22","v":0},0.9,0,0,0,0,0]
["watts 400 watt HPS",{"$f":"+'ballast losses'!F9","v":456},164.0232,1824,"Consulting cost 100 watt LED ",2.4225412500000001,{"$f":"+$B$5","v":0},{"$f":"F23*G23","v":0},0.9,0,0,0,0,0]
["watts 1000 watt HPS",{"$f":"+'ballast losses'!F10","v":1110},399.267,4440,"Consulting cost 150 watt LED",2.6233420000000001,{"$f":"+$B$6","v":0},0,0.9,0,0,0,0,0]
[null,null,null,null,"Consulting cost 200 watt LED",3.4385749999999997,{"$f":"+$B$7","v":0},0,0.9,0,0,0,0,0]
[" 50 watt equivalent LED considering energy efficiency without adaptive controls",{"$f":"B17*(1-$B$15)","v":33.75},{"$f":"B26*12*$B$14","v":12.139875},{"$f":"+($B26*4000)/1000","v":135},"Consulting cost 250 watt LED",4.1867407499999993,{"$f":"+$B$8","v":0},0,0.9,0,0,0,0,0]
[" 70 watt equivalent LED considering energy efficiency without adaptive controls",45.5,16.366350000000001,{"$f":"+($B27*4000)/1000","v":182},"Consulting cost 400 watt LED",4.5265882499999996,{"$f":"+$B$9","v":0},0,0.9,0,0,0,0,0]
["100 watt equivalent LED considering energy efficiency without adaptive controls",65,23.380500000000001,{"$f":"+($B28*4000)/1000","v":260},"Consulting cost 1000 watt LED",7.0175000000000001,{"$f":"+$B$10","v":0},0,0.9,0,0,0,0,0]
[" 150 watt equivalent LED considering energy efficiency without adaptive controls",93.75,33.721875000000004,{"$f":"+($B29*4000)/1000","v":375},"adaptive controls 50 watt LED",{"$f":"+'Data Input and Instructions'!$C$48","v":125},{"$f":"+$B$3","v":0},0,0.9,{"$f":"$J$4*$H29*$I29^(J$2-1)","v":0},0,0,0,0]
["200 watt equivalent LED considering energy efficiency without adaptive controls",120,43.164000000000001,{"$f":"+($B30*4000)/1000","v":480},"adaptive controls 70 watt LED",{"$f":"+'Data Input and Instructions'!$C$48","v":125},{"$f":"+$B$4","v":0},{"$f":"F30*G30","v":0},0.9,0,0,0,0,0]
["250 watt equivalent LED considering energy efficiency without adaptive controls",147.5,53.055750000000003,590,"adaptive controls 100 watt LED",{"$f":"+'Data Input and Instructions'!$C$48","v":125},{"$f":"+$B$5","v":0},0,0.9,0,0,0,0,0]
["400 watt equivalent LED considering energy efficiency without adaptive controls",228,82.011600000000001,912,"adaptive controls 150 watt LED",{"$f":"+'Data Input and Instructions'!$C$48","v":125},{"$f":"+$B$6","v":0},0,0.9,0,0,0,0,0]
["1000 watt equivalent LED considering energy efficiency without adaptive controls",555,199.6335,2220,"adaptive controls 200 watt LED",{"$f":"+'Data Input and Instructions'!$C$48","v":125},{"$f":"+$B$7","v":0},0,0.9,0,0,0,0,0]
[" 50 watt equivalent LED considering energy efficiency with adaptive controls",{"$f":"+B17*(1-$C$15)","v":20.250000000000004},7.2839250000000018,{"$f":"+($B34*4000)/1000","v":81.000000000000014},"adaptive controls 250 watt LED",{"$f":"+'Data Input and Instructions'!$C$48","v":125},{"$f":"+$B$8","v":0},0,0.9,0,0,0,0,0]
[" 70 watt equivalent LED considering energy efficiency with adaptive controls",27.300000000000004,9.8198100000000004,{"$f":"+($B35*4000)/1000","v":109.20000000000002},"adaptive controls 400 watt LED",{"$f":"+'Data Input and Instructions'!$C$48","v":125},{"$f":"+$B$9","v":0},0,0.9,0,0,0,0,0]
[" 100 watt equivalent LED considering energy efficiency with adaptive controls",39.000000000000007,14.028300000000003,{"$f":"+($B36*4000)/1000","v":156.00000000000003},"adaptive controls 1000 watt LED",{"$f":"+'Data Input and Instructions'!$C$48","v":125},{"$f":"+$B$10","v":0},0,0.9,0,0,0,0,0]
[" 150 watt equivalent LED considering energy efficiency with adaptive controls",56.250000000000007,20.233125000000005,{"$f":"+($B37*4000)/1000","v":225.00000000000003},"energy cost 50 LED no adaptive controls",{"$f":"+C26+IF('Data Input and Instructions'!$C$11=\"1703\",0.8309,0)","v":12.139875},{"$f":"+$B$3","v":0},0,1,{"$f":"(J$4*$H37)","v":0},{"$f":"(K$4*$H37)*((1+'Data Input and Instructions'!$C$64)^$J$2)","v":0},{"$f":"(L$4*$H37)*((1+'Data Input and Instructions'!$C$64)^$K$2)","v":0},{"$f":"(M$4*$H37)*((1+'Data Input and Instructions'!$C$64)^$L$2)","v":0},{"$f":"(N$4*$H37)*((1+'Data Input and Instructions'!$C$64)^$M$2)","v":0},{"$f":"+N37*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+O37*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+P37*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+Q37*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+R37*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+S37*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+T37*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+U37*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+V37*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+W37*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+X37*(1+'Data Input and Instructions'!$C$64)","v":0}]
[" 200 watt equivalent LED considering energy efficiency with adaptive controls",72.000000000000014,25.898400000000009,288.00000000000006,"energy cost 70 LED no adaptive controls",{"$f":"+C27+IF('Data Input and Instructions'!$C$11=\"1703\",0.8309,0)","v":16.366350000000001},{"$f":"+$B$4","v":0},{"$f":"F38*G38","v":0},1,0,{"$f":"(K$4*$H38)*((1+'Data Input and Instructions'!$C$64)^$J$2)","v":0},{"$f":"(L$4*$H38)*((1+'Data Input and Instructions'!$C$64)^$K$2)","v":0},{"$f":"(M$4*$H38)*((1+'Data Input and Instructions'!$C$64)^$L$2)","v":0},{"$f":"(N$4*$H38)*((1+'Data Input and Instructions'!$C$64)^$M$2)","v":0},{"$f":"+N38*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+O38*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+P38*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+Q38*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+R38*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+S38*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+T38*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+U38*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+V38*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+W38*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+X38*(1+'Data Input and Instructions'!$C$64)","v":0}]
[" 250 watt equivalent LED considering energy efficiency with adaptive controls",88.500000000000014,31.83345000000001,354.00000000000006,"energy cost 100 LED no adaptive controls",{"$f":"+C28+IF('Data Input and Instructions'!$C$11=\"1703\",0.8309,0)","v":23.380500000000001},{"$f":"+$B$5","v":0},0,1,0,{"$f":"(K$4*$H39)*((1+'Data Input and Instructions'!$C$64)^$J$2)","v":0},{"$f":"(L$4*$H39)*((1+'Data Input and Instructions'!$C$64)^$K$2)","v":0},{"$f":"(M$4*$H39)*((1+'Data Input and Instructions'!$C$64)^$L$2)","v":0},{"$f":"(N$4*$H39)*((1+'Data Input and Instructions'!$C$64)^$M$2)","v":0},{"$f":"+N39*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+O39*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+P39*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+Q39*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+R39*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+S39*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+T39*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+U39*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+V39*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+W39*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+X39*(1+'Data Input and Instructions'!$C$64)","v":0}]
[" 400 watt equivalent LED considering energy efficiency with adaptive controls",136.80000000000001,49.206960000000009,547.20000000000005,"energy cost 150 LED no adaptive controls",{"$f":"+C29+IF('Data Input and Instructions'!$C$11=\"1703\",0.8309,0)","v":33.721875000000004},{"$f":"+$B$6","v":0},0,1,0,{"$f":"(K$4*$H40)*((1+'Data Input and Instructions'!$C$64)^$J$2)","v":0},{"$f":"(L$4*$H40)*((1+'Data Input and Instructions'!$C$64)^$K$2)","v":0},{"$f":"(M$4*$H40)*((1+'Data Input and Instructions'!$C$64)^$L$2)","v":0},{"$f":"(N$4*$H40)*((1+'Data Input and Instructions'!$C$64)^$M$2)","v":0},{"$f":"+N40*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+O40*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+P40*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+Q40*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+R40*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+S40*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+T40*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+U40*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+V40*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+W40*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+X40*(1+'Data Input and Instructions'!$C$64)","v":0}]
[" 1000 watt equivalent LED considering energy efficiency with adaptive controls",333.00000000000006,119.78010000000003,1332.0000000000002,"energy cost 200 LED no adaptive controls",{"$f":"+C30+IF('Data Input and Instructions'!$C$11=\"1703\",0.8309,0)","v":43.164000000000001},{"$f":"+$B$7","v":0},0,1,0,{"$f":"(K$4*$H41)*((1+'Data Input and Instructions'!$C$64)^$J$2)","v":0},{"$f":"(L$4*$H41)*((1+'Data Input and Instructions'!$C$64)^$K$2)","v":0},{"$f":"(M$4*$H41)*((1+'Data Input and Instructions'!$C$64)^$L$2)","v":0},{"$f":"(N$4*$H41)*((1+'Data Input and Instructions'!$C$64)^$M$2)","v":0},{"$f":"+N41*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+O41*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+P41*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+Q41*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+R41*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+S41*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+T41*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+U41*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+V41*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+W41*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+X41*(1+'Data Input and Instructions'!$C$64)","v":0}]
[" 50 watt equivalent energy efficiency with adaptive controls only",{"$f":"+B17*(1-$D$15)","v":54},19.4238,{"$f":"+($B42*4000)/1000","v":216},"energy cost 250 LED no adaptive controls",{"$f":"+C31+IF('Data Input and Instructions'!$C$11=\"1703\",0.8309,0)","v":53.055750000000003},{"$f":"+$B$8","v":0},0,1,0,{"$f":"(K$4*$H42)*((1+'Data Input and Instructions'!$C$64)^$J$2)","v":0},{"$f":"(L$4*$H42)*((1+'Data Input and Instructions'!$C$64)^$K$2)","v":0},{"$f":"(M$4*$H42)*((1+'Data Input and Instructions'!$C$64)^$L$2)","v":0},{"$f":"(N$4*$H42)*((1+'Data Input and Instructions'!$C$64)^$M$2)","v":0},{"$f":"+N42*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+O42*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+P42*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+Q42*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+R42*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+S42*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+T42*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+U42*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+V42*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+W42*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+X42*(1+'Data Input and Instructions'!$C$64)","v":0}]
[" 70 watt equivalent energy efficiency with adaptive controls only",72.8,26.186159999999997,291.2,"energy cost 400 LED no adaptive controls",{"$f":"+C32+IF('Data Input and Instructions'!$C$11=\"1703\",0.8309,0)","v":82.011600000000001},{"$f":"+$B$9","v":0},0,1,0,{"$f":"(K$4*$H43)*((1+'Data Input and Instructions'!$C$64)^$J$2)","v":0},{"$f":"(L$4*$H43)*((1+'Data Input and Instructions'!$C$64)^$K$2)","v":0},{"$f":"(M$4*$H43)*((1+'Data Input and Instructions'!$C$64)^$L$2)","v":0},{"$f":"(N$4*$H43)*((1+'Data Input and Instructions'!$C$64)^$M$2)","v":0},{"$f":"+N43*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+O43*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+P43*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+Q43*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+R43*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+S43*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+T43*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+U43*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+V43*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+W43*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+X43*(1+'Data Input and Instructions'!$C$64)","v":0}]
[" 100 watt equivalent energy efficiency with adaptive controls only",104,37.408799999999999,416,"energy cost 1000 LED no adaptive controls",{"$f":"+C33+IF('Data Input and Instructions'!$C$11=\"1703\",0.8309,0)","v":199.6335},{"$f":"+$B$10","v":0},0,1,0,{"$f":"(K$4*$H44)*((1+'Data Input and Instructions'!$C$64)^$J$2)","v":0},{"$f":"(L$4*$H44)*((1+'Data Input and Instructions'!$C$64)^$K$2)","v":0},{"$f":"(M$4*$H44)*((1+'Data Input and Instructions'!$C$64)^$L$2)","v":0},{"$f":"(N$4*$H44)*((1+'Data Input and Instructions'!$C$64)^$M$2)","v":0},{"$f":"+N44*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+O44*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+P44*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+Q44*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+R44*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+S44*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+T44*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+U44*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+V44*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+W44*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+X44*(1+'Data Input and Instructions'!$C$64)","v":0}]
[" 150 watt equivalent energy efficiency with adaptive controls only",150,53.955000000000005,600,"energy KWh 50 LED no adaptive controls",{"$f":"+$D26","v":135},{"$f":"+$B$3","v":0},{"$f":"F45*G45","v":0},1,0,{"$f":"(K$4*$H45)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[" 200 watt equivalent energy efficiency with adaptive controls only",192,69.062399999999997,768,"energy KWh 70 LED no adaptive controls",182,{"$f":"+$B$4","v":0},0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[" 250 watt equivalent energy efficiency with adaptive controls only",236,84.889200000000002,944,"energy KWh 100 LED no adaptive controls",260,{"$f":"+$B$5","v":0},{"$f":"F47*G47","v":0},1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[" 400 watt equivalent energy efficiency with adaptive controls only",364.8,131.21856000000002,1459.2,"energy KWh 150 LED no adaptive controls",375,{"$f":"+$B$6","v":0},0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[" 1000 watt equivalent energy efficiency with adaptive controls only",888,319.41360000000003,3552,"energy KWh 200 LED no adaptive controls",480,{"$f":"+$B$7","v":0},0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"energy KWh 250 LED no adaptive controls",590,{"$f":"+$B$8","v":0},0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"energy KWh 400 LED no adaptive controls",912,{"$f":"+$B$9","v":0},0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Consulting cost",0.01,null,null,"energy KWh 1000 LED no adaptive controls",2220,{"$f":"+$B$10","v":0},0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Consulting admin fee for procurement services",0.01,null,null,"energy cost adaptive controls 50 watt LED",{"$f":"+C34+IF('Data Input and Instructions'!$C$11=\"1703\",0.8309,0)","v":7.2839250000000018},{"$f":"+$B$3","v":0},0,1,0,{"$f":"(K$4*$H53)*((1+'Data Input and Instructions'!$C$64)^$J$2)","v":0},{"$f":"(L$4*$H53)*((1+'Data Input and Instructions'!$C$64)^$K$2)","v":0},{"$f":"(M$4*$H53)*((1+'Data Input and Instructions'!$C$64)^$L$2)","v":0},{"$f":"(N$4*$H53)*((1+'Data Input and Instructions'!$C$64)^$M$2)","v":0},{"$f":"+N53*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+O53*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+P53*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+Q53*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+R53*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+S53*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+T53*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+U53*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+V53*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+W53*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+X53*(1+'Data Input and Instructions'!$C$64)","v":0}]
["Joint Procurement cost",2.5000000000000001E-3,null,null,"energy cost adaptive controls 70 watt LED",{"$f":"+C35+IF('Data Input and Instructions'!$C$11=\"1703\",0.8309,0)","v":9.8198100000000004},{"$f":"+$B$4","v":0},{"$f":"F54*G54","v":0},1,0,{"$f":"(K$4*$H54)*((1+'Data Input and Instructions'!$C$64)^$J$2)","v":0},{"$f":"(L$4*$H54)*((1+'Data Input and Instructions'!$C$64)^$K$2)","v":0},{"$f":"(M$4*$H54)*((1+'Data Input and Instructions'!$C$64)^$L$2)","v":0},{"$f":"(N$4*$H54)*((1+'Data Input and Instructions'!$C$64)^$M$2)","v":0},{"$f":"+N54*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+O54*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+P54*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+Q54*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+R54*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+S54*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+T54*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+U54*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+V54*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+W54*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+X54*(1+'Data Input and Instructions'!$C$64)","v":0}]
["Inflation",{"$f":"+'Data Input and Instructions'!C68","v":0.02},null,null,"energy cost adaptive controls 100 watt LED",{"$f":"+C36+IF('Data Input and Instructions'!$C$11=\"1703\",0.8309,0)","v":14.028300000000003},{"$f":"+$B$5","v":0},0,1,0,{"$f":"(K$4*$H55)*((1+'Data Input and Instructions'!$C$64)^$J$2)","v":0},{"$f":"(L$4*$H55)*((1+'Data Input and Instructions'!$C$64)^$K$2)","v":0},{"$f":"(M$4*$H55)*((1+'Data Input and Instructions'!$C$64)^$L$2)","v":0},{"$f":"(N$4*$H55)*((1+'Data Input and Instructions'!$C$64)^$M$2)","v":0},{"$f":"+N55*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+O55*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+P55*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+Q55*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+R55*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+S55*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+T55*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+U55*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+V55*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+W55*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+X55*(1+'Data Input and Instructions'!$C$64)","v":0}]
[null,null,null,null,"energy cost adaptive controls 150 watt LED",{"$f":"+C37+IF('Data Input and Instructions'!$C$11=\"1703\",0.8309,0)","v":20.233125000000005},{"$f":"+$B$6","v":0},0,1,{"$f":"(J$4*$H56)*1.03","v":0},{"$f":"(K$4*$H56)*((1+'Data Input and Instructions'!$C$64)^$J$2)","v":0},{"$f":"(L$4*$H56)*((1+'Data Input and Instructions'!$C$64)^$K$2)","v":0},{"$f":"(M$4*$H56)*((1+'Data Input and Instructions'!$C$64)^$L$2)","v":0},{"$f":"(N$4*$H56)*((1+'Data Input and Instructions'!$C$64)^$M$2)","v":0},{"$f":"+N56*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+O56*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+P56*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+Q56*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+R56*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+S56*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+T56*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+U56*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+V56*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+W56*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+X56*(1+'Data Input and Instructions'!$C$64)","v":0}]
[null,null,null,null,"energy cost adaptive controls 200 watt LED",{"$f":"+C38+IF('Data Input and Instructions'!$C$11=\"1703\",0.8309,0)","v":25.898400000000009},{"$f":"+$B$7","v":0},0,1,{"$f":"(J$4*$H57)*1.03","v":0},{"$f":"(K$4*$H57)*((1+'Data Input and Instructions'!$C$64)^$J$2)","v":0},{"$f":"(L$4*$H57)*((1+'Data Input and Instructions'!$C$64)^$K$2)","v":0},{"$f":"(M$4*$H57)*((1+'Data Input and Instructions'!$C$64)^$L$2)","v":0},{"$f":"(N$4*$H57)*((1+'Data Input and Instructions'!$C$64)^$M$2)","v":0},{"$f":"+N57*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+O57*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+P57*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+Q57*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+R57*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+S57*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+T57*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+U57*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+V57*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+W57*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+X57*(1+'Data Input and Instructions'!$C$64)","v":0}]
[null,null,null,null,"energy cost adaptive controls 250 watt LED",{"$f":"+C39+IF('Data Input and Instructions'!$C$11=\"1703\",0.8309,0)","v":31.83345000000001},{"$f":"+$B$8","v":0},0,1,{"$f":"(J$4*$H58)*1.03","v":0},{"$f":"(K$4*$H58)*((1+'Data Input and Instructions'!$C$64)^$J$2)","v":0},{"$f":"(L$4*$H58)*((1+'Data Input and Instructions'!$C$64)^$K$2)","v":0},{"$f":"(M$4*$H58)*((1+'Data Input and Instructions'!$C$64)^$L$2)","v":0},{"$f":"(N$4*$H58)*((1+'Data Input and Instructions'!$C$64)^$M$2)","v":0},{"$f":"+N58*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+O58*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+P58*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+Q58*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+R58*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+S58*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+T58*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+U58*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+V58*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+W58*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+X58*(1+'Data Input and Instructions'!$C$64)","v":0}]
[null,null,null,null,"energy cost adaptive controls 400 watt LED",{"$f":"+C40+IF('Data Input and Instructions'!$C$11=\"1703\",0.8309,0)","v":49.206960000000009},{"$f":"+$B$9","v":0},0,1,{"$f":"(J$4*$H59)*1.03","v":0},{"$f":"(K$4*$H59)*((1+'Data Input and Instructions'!$C$64)^$J$2)","v":0},{"$f":"(L$4*$H59)*((1+'Data Input and Instructions'!$C$64)^$K$2)","v":0},{"$f":"(M$4*$H59)*((1+'Data Input and Instructions'!$C$64)^$L$2)","v":0},{"$f":"(N$4*$H59)*((1+'Data Input and Instructions'!$C$64)^$M$2)","v":0},{"$f":"+N59*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+O59*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+P59*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+Q59*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+R59*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+S59*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+T59*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+U59*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+V59*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+W59*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+X59*(1+'Data Input and Instructions'!$C$64)","v":0}]
[null,null,null,null,"energy cost adaptive controls 1000 watt LED",{"$f":"+C41+IF('Data Input and Instructions'!$C$11=\"1703\",0.8309,0)","v":119.78010000000003},{"$f":"+$B$10","v":0},0,1,{"$f":"(J$4*$H60)*1.03","v":0},{"$f":"(K$4*$H60)*((1+'Data Input and Instructions'!$C$64)^$J$2)","v":0},{"$f":"(L$4*$H60)*((1+'Data Input and Instructions'!$C$64)^$K$2)","v":0},{"$f":"(M$4*$H60)*((1+'Data Input and Instructions'!$C$64)^$L$2)","v":0},{"$f":"(N$4*$H60)*((1+'Data Input and Instructions'!$C$64)^$M$2)","v":0},{"$f":"+N60*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+O60*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+P60*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+Q60*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+R60*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+S60*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+T60*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+U60*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+V60*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+W60*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+X60*(1+'Data Input and Instructions'!$C$64)","v":0}]
[null,null,null,null,"energy KWh 50 LED with adaptive controls",{"$f":"+$D34","v":81.000000000000014},{"$f":"+$B$3","v":0},0,1,{"$f":"(J$4*$H61)","v":0},{"$f":"(K$4*$H61)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"energy KWh 70 LED with adaptive controls",109.20000000000002,{"$f":"+$B$4","v":0},0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"energy KWh 100 LED with adaptive controls",156.00000000000003,{"$f":"+$B$5","v":0},{"$f":"F63*G63","v":0},1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"energy KWh 150 LED with adaptive controls",225.00000000000003,{"$f":"+$B$6","v":0},0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"energy KWh 200 LED with adaptive controls",288.00000000000006,{"$f":"+$B$7","v":0},0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"energy KWh 250 LED with adaptive controls",354.00000000000006,{"$f":"+$B$8","v":0},0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"energy KWh 400 LED with adaptive controls",547.20000000000005,{"$f":"+$B$9","v":0},0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"energy KWh 1000 LED with adaptive controls",1332.0000000000002,{"$f":"+$B$10","v":0},0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"energy cost NO LED and adaptive controls 50 watt LED",{"$f":"+C42+IF('Data Input and Instructions'!$C$11=\"1703\",0.8309,0)","v":19.4238},{"$f":"+$B$3","v":0},0,1,0,{"$f":"(K$4*$H69)*((1+'Data Input and Instructions'!$C$64)^$J$2)","v":0},{"$f":"(L$4*$H69)*((1+'Data Input and Instructions'!$C$64)^$K$2)","v":0},{"$f":"(M$4*$H69)*((1+'Data Input and Instructions'!$C$64)^$L$2)","v":0},{"$f":"(N$4*$H69)*((1+'Data Input and Instructions'!$C$64)^$M$2)","v":0},{"$f":"+N69*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+O69*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+P69*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+Q69*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+R69*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+S69*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+T69*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+U69*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+V69*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+W69*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+X69*(1+'Data Input and Instructions'!$C$64)","v":0}]
[null,null,null,null,"energy cost NO LED and adaptive controls 70 watt LED",{"$f":"+C43+IF('Data Input and Instructions'!$C$11=\"1703\",0.8309,0)","v":26.186159999999997},{"$f":"+$B$4","v":0},0,1,0,{"$f":"(K$4*$H70)*((1+'Data Input and Instructions'!$C$64)^$J$2)","v":0},{"$f":"(L$4*$H70)*((1+'Data Input and Instructions'!$C$64)^$K$2)","v":0},{"$f":"(M$4*$H70)*((1+'Data Input and Instructions'!$C$64)^$L$2)","v":0},{"$f":"(N$4*$H70)*((1+'Data Input and Instructions'!$C$64)^$M$2)","v":0},{"$f":"+N70*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+O70*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+P70*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+Q70*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+R70*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+S70*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+T70*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+U70*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+V70*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+W70*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+X70*(1+'Data Input and Instructions'!$C$64)","v":0}]
[null,null,null,null,"energy cost NO LED and adaptive controls 100 watt LED",{"$f":"+C44+IF('Data Input and Instructions'!$C$11=\"1703\",0.8309,0)","v":37.408799999999999},{"$f":"+$B$5","v":0},0,1,0,{"$f":"(K$4*$H71)*((1+'Data Input and Instructions'!$C$64)^$J$2)","v":0},{"$f":"(L$4*$H71)*((1+'Data Input and Instructions'!$C$64)^$K$2)","v":0},{"$f":"(M$4*$H71)*((1+'Data Input and Instructions'!$C$64)^$L$2)","v":0},{"$f":"(N$4*$H71)*((1+'Data Input and Instructions'!$C$64)^$M$2)","v":0},{"$f":"+N71*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+O71*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+P71*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+Q71*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+R71*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+S71*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+T71*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+U71*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+V71*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+W71*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+X71*(1+'Data Input and Instructions'!$C$64)","v":0}]
[null,null,null,null,"energy cost NO LED and adaptive controls 150 watt LED",{"$f":"+C45+IF('Data Input and Instructions'!$C$11=\"1703\",0.8309,0)","v":53.955000000000005},{"$f":"+$B$6","v":0},0,1,{"$f":"(J$4*$H72)*1.03","v":0},{"$f":"(K$4*$H72)*((1+'Data Input and Instructions'!$C$64)^$J$2)","v":0},{"$f":"(L$4*$H72)*((1+'Data Input and Instructions'!$C$64)^$K$2)","v":0},{"$f":"(M$4*$H72)*((1+'Data Input and Instructions'!$C$64)^$L$2)","v":0},{"$f":"(N$4*$H72)*((1+'Data Input and Instructions'!$C$64)^$M$2)","v":0},{"$f":"+N72*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+O72*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+P72*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+Q72*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+R72*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+S72*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+T72*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+U72*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+V72*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+W72*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+X72*(1+'Data Input and Instructions'!$C$64)","v":0}]
[null,null,null,null,"energy cost NO LED and adaptive controls 200 watt LED",{"$f":"+C46+IF('Data Input and Instructions'!$C$11=\"1703\",0.8309,0)","v":69.062399999999997},{"$f":"+$B$7","v":0},0,1,{"$f":"(J$4*$H73)*1.03","v":0},{"$f":"(K$4*$H73)*((1+'Data Input and Instructions'!$C$64)^$J$2)","v":0},{"$f":"(L$4*$H73)*((1+'Data Input and Instructions'!$C$64)^$K$2)","v":0},{"$f":"(M$4*$H73)*((1+'Data Input and Instructions'!$C$64)^$L$2)","v":0},{"$f":"(N$4*$H73)*((1+'Data Input and Instructions'!$C$64)^$M$2)","v":0},{"$f":"+N73*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+O73*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+P73*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+Q73*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+R73*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+S73*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+T73*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+U73*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+V73*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+W73*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+X73*(1+'Data Input and Instructions'!$C$64)","v":0}]
[null,null,null,null,"energy cost NO LED and adaptive controls 250 watt LED",{"$f":"+C47+IF('Data Input and Instructions'!$C$11=\"1703\",0.8309,0)","v":84.889200000000002},{"$f":"+$B$8","v":0},0,1,{"$f":"(J$4*$H74)*1.03","v":0},{"$f":"(K$4*$H74)*((1+'Data Input and Instructions'!$C$64)^$J$2)","v":0},{"$f":"(L$4*$H74)*((1+'Data Input and Instructions'!$C$64)^$K$2)","v":0},{"$f":"(M$4*$H74)*((1+'Data Input and Instructions'!$C$64)^$L$2)","v":0},{"$f":"(N$4*$H74)*((1+'Data Input and Instructions'!$C$64)^$M$2)","v":0},{"$f":"+N74*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+O74*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+P74*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+Q74*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+R74*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+S74*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+T74*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+U74*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+V74*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+W74*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+X74*(1+'Data Input and Instructions'!$C$64)","v":0}]
[null,null,null,null,"energy cost NO LED and adaptive controls 400 watt LED",{"$f":"+C48+IF('Data Input and Instructions'!$C$11=\"1703\",0.8309,0)","v":131.21856000000002},{"$f":"+$B$9","v":0},0,1,{"$f":"(J$4*$H75)*1.03","v":0},{"$f":"(K$4*$H75)*((1+'Data Input and Instructions'!$C$64)^$J$2)","v":0},{"$f":"(L$4*$H75)*((1+'Data Input and Instructions'!$C$64)^$K$2)","v":0},{"$f":"(M$4*$H75)*((1+'Data Input and Instructions'!$C$64)^$L$2)","v":0},{"$f":"(N$4*$H75)*((1+'Data Input and Instructions'!$C$64)^$M$2)","v":0},{"$f":"+N75*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+O75*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+P75*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+Q75*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+R75*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+S75*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+T75*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+U75*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+V75*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+W75*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+X75*(1+'Data Input and Instructions'!$C$64)","v":0}]
[null,null,null,null,"energy cost NO LED and adaptive controls 1000 watt LED",{"$f":"+C49+IF('Data Input and Instructions'!$C$11=\"1703\",0.8309,0)","v":319.41360000000003},{"$f":"+$B$10","v":0},0,1,{"$f":"(J$4*$H76)*1.03","v":0},{"$f":"(K$4*$H76)*((1+'Data Input and Instructions'!$C$64)^$J$2)","v":0},{"$f":"(L$4*$H76)*((1+'Data Input and Instructions'!$C$64)^$K$2)","v":0},{"$f":"(M$4*$H76)*((1+'Data Input and Instructions'!$C$64)^$L$2)","v":0},{"$f":"(N$4*$H76)*((1+'Data Input and Instructions'!$C$64)^$M$2)","v":0},{"$f":"+N76*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+O76*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+P76*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+Q76*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+R76*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+S76*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+T76*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+U76*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+V76*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+W76*(1+'Data Input and Instructions'!$C$64)","v":0},{"$f":"+X76*(1+'Data Input and Instructions'!$C$64)","v":0}]
[null,null,null,null,"energy KWh NO LED, only adaptive controls 50 Watts",{"$f":"+$D42","v":216},{"$f":"+$B$3","v":0},{"$f":"F77*G77","v":0},1,{"$f":"(J$4*$H77)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"energy KWh NO LED, only adaptive controls 100 Watts",{"$f":"+$D43","v":291.2},{"$f":"+$B$4","v":0},{"$f":"F78*G78","v":0},1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"energy KWh NO LED, only adaptive controls 100 Watts",416,{"$f":"+$B$5","v":0},{"$f":"F79*G79","v":0},1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"energy KWh NO LED, only adaptive controls 150 Watts",600,{"$f":"+$B$6","v":0},0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"energy KWh NO LED, only adaptive controls 200 Watts",768,{"$f":"+$B$7","v":0},0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"energy KWh NO LED, only adaptive controls 250 Watts",944,{"$f":"+$B$8","v":0},0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"energy KWh NO LED, only adaptive controls 400 Watts",1459.2,{"$f":"+$B$9","v":0},0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"energy KWh NO LED, only adaptive controls 1000 Watts",3552,{"$f":"+$B$10","v":0},0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"energy cost 50 HPS",{"$f":"+C17+IF('Data Input and Instructions'!$C$11=\"1703\",0.8309,0)","v":24.27975},{"$f":"+$B$3","v":0},0,1,{"$f":"(J$3*$H85)","v":0},{"$f":"(K$3*$H85)*((1+'Data Input and Instructions'!$C$64)^$J$2)","v":0},{"$f":"(L$3*$H85)*((1+'Data Input and Instructions'!$C$64)^$K$2)","v":0},{"$f":"(M$3*$H85)*((1+'Data Input and Instructions'!$C$64)^$L$2)","v":0},{"$f":"(N$3*$H85)*((1+'Data Input and Instructions'!$C$64)^$M$2)","v":0}]
[null,null,null,null,"energy cost 70 HPS",{"$f":"+C18+IF('Data Input and Instructions'!$C$11=\"1703\",0.8309,0)","v":32.732700000000001},{"$f":"+$B$4","v":0},{"$f":"F86*G86","v":0},1,0,{"$f":"(K$3*$H86)*((1+'Data Input and Instructions'!$C$64)^$J$2)","v":0},{"$f":"(L$3*$H86)*((1+'Data Input and Instructions'!$C$64)^$K$2)","v":0},{"$f":"(M$3*$H86)*((1+'Data Input and Instructions'!$C$64)^$L$2)","v":0},{"$f":"(N$3*$H86)*((1+'Data Input and Instructions'!$C$64)^$M$2)","v":0}]
[null,null,null,null,"energy cost 100 HPS",{"$f":"+C19+IF('Data Input and Instructions'!$C$11=\"1703\",0.8309,0)","v":46.761000000000003},{"$f":"+$B$5","v":0},0,1,0,{"$f":"(K$3*$H87)*((1+'Data Input and Instructions'!$C$64)^$J$2)","v":0},{"$f":"(L$3*$H87)*((1+'Data Input and Instructions'!$C$64)^$K$2)","v":0},{"$f":"(M$3*$H87)*((1+'Data Input and Instructions'!$C$64)^$L$2)","v":0},{"$f":"(N$3*$H87)*((1+'Data Input and Instructions'!$C$64)^$M$2)","v":0}]
[null,null,null,null,"energy cost 150 HPS",{"$f":"+C20+IF('Data Input and Instructions'!$C$11=\"1703\",0.8309,0)","v":67.443750000000009},{"$f":"+$B$6","v":0},0,1,0,{"$f":"(K$3*$H88)*((1+'Data Input and Instructions'!$C$64)^$J$2)","v":0},{"$f":"(L$3*$H88)*((1+'Data Input and Instructions'!$C$64)^$K$2)","v":0},{"$f":"(M$3*$H88)*((1+'Data Input and Instructions'!$C$64)^$L$2)","v":0},{"$f":"(N$3*$H88)*((1+'Data Input and Instructions'!$C$64)^$M$2)","v":0}]
[null,null,null,null,"energy cost 200 HPS",{"$f":"+C21+IF('Data Input and Instructions'!$C$11=\"1703\",0.8309,0)","v":86.328000000000003},{"$f":"+$B$7","v":0},0,1,0,{"$f":"(K$3*$H89)*((1+'Data Input and Instructions'!$C$64)^$J$2)","v":0},{"$f":"(L$3*$H89)*((1+'Data Input and Instructions'!$C$64)^$K$2)","v":0},{"$f":"(M$3*$H89)*((1+'Data Input and Instructions'!$C$64)^$L$2)","v":0},{"$f":"(N$3*$H89)*((1+'Data Input and Instructions'!$C$64)^$M$2)","v":0}]
[null,null,null,null,"energy cost 250 HPS",{"$f":"+C22+IF('Data Input and Instructions'!$C$11=\"1703\",0.8309,0)","v":106.11150000000001},{"$f":"+$B$8","v":0},0,1,0,{"$f":"(K$3*$H90)*((1+'Data Input and Instructions'!$C$64)^$J$2)","v":0},{"$f":"(L$3*$H90)*((1+'Data Input and Instructions'!$C$64)^$K$2)","v":0},{"$f":"(M$3*$H90)*((1+'Data Input and Instructions'!$C$64)^$L$2)","v":0},{"$f":"(N$3*$H90)*((1+'Data Input and Instructions'!$C$64)^$M$2)","v":0}]
[null,null,null,null,"energy cost 400 HPS",{"$f":"+C23+IF('Data Input and Instructions'!$C$11=\"1703\",0.8309,0)","v":164.0232},{"$f":"+$B$9","v":0},0,1,0,{"$f":"(K$3*$H91)*((1+'Data Input and Instructions'!$C$64)^$J$2)","v":0},{"$f":"(L$3*$H91)*((1+'Data Input and Instructions'!$C$64)^$K$2)","v":0},{"$f":"(M$3*$H91)*((1+'Data Input and Instructions'!$C$64)^$L$2)","v":0},{"$f":"(N$3*$H91)*((1+'Data Input and Instructions'!$C$64)^$M$2)","v":0}]
[null,null,null,null,"energy cost 1000 HPS",{"$f":"+C24+IF('Data Input and Instructions'!$C$11=\"1703\",0.8309,0)","v":399.267},{"$f":"+$B$10","v":0},0,1,0,{"$f":"(K$3*$H92)*((1+'Data Input and Instructions'!$C$64)^$J$2)","v":0},{"$f":"(L$3*$H92)*((1+'Data Input and Instructions'!$C$64)^$K$2)","v":0},{"$f":"(M$3*$H92)*((1+'Data Input and Instructions'!$C$64)^$L$2)","v":0},{"$f":"(N$3*$H92)*((1+'Data Input and Instructions'!$C$64)^$M$2)","v":0}]
[null,null,null,null,"energy KWh 50 HPS",{"$f":"+$D17","v":270},{"$f":"+$B$3","v":0},0,1,0,{"$f":"(K$3*$H93)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"energy KWh 70 HPS",364,{"$f":"+$B$4","v":0},0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"energy KWh 100 HPS",520,{"$f":"+$B$5","v":0},{"$f":"F95*G95","v":0},1,0,{"$f":"(K$3*$H95)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"energy KWh 150 HPS",750,{"$f":"+$B$6","v":0},0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"energy KWh 200 HPS",960,{"$f":"+$B$7","v":0},0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"energy KWh 250 HPS",1180,{"$f":"+$B$8","v":0},0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"energy KWh 400 HPS",1824,{"$f":"+$B$9","v":0},0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"energy KWh 1000 HPS",4440,{"$f":"+$B$10","v":0},0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"luminaire maintenance cost 50 LED",{"$f":"+F5+F13","v":360.9},{"$f":"+$B$3","v":0},{"$f":"F101*G101*I101","v":0},0.05,0,0,0,0,0,0,0,0,0,0,{"$f":"J$4*$H101*$I101*((1+$B$55)^T$2)","v":0},0,0,0,0,0]
[null,null,null,null,"luminaire maintenance cost 70 LED",375.9375,{"$f":"+$B$4","v":0},{"$f":"F102*G102*I102","v":0},0.05,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"luminaire maintenance cost 100 LED",402.65412499999996,{"$f":"+$B$5","v":0},0,0.05,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"luminaire maintenance cost 150 LED",422.73419999999999,{"$f":"+$B$6","v":0},0,0.05,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"luminaire maintenance cost 200 LED",504.25749999999994,{"$f":"+$B$7","v":0},0,0.05,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"luminaire maintenance cost 250 LED",579.07407499999999,{"$f":"+$B$8","v":0},0,0.05,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"luminaire maintenance cost 400 LED",613.05882499999984,{"$f":"+$B$9","v":0},0,0.05,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"luminaire maintenance cost 1000 LED",862.15,{"$f":"+$B$10","v":0},0,0.05,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"spot maintenance cost 50 HPS",{"$f":"$I$155","v":0},{"$f":"+$B$3","v":0},{"$f":"F109*G109*I109","v":0},0.1,{"$f":"J$3*$H109","v":0},{"$f":"K$3*$H109*((1+$B$55)^K$2)","v":0},0,0,0]
[null,null,null,null,"spot maintenance cost 70 HPS",0,{"$f":"+$B$4","v":0},0,0.1,0,0,0,0,0]
[null,null,null,null,"spot maintenance cost 100 HPS",0,{"$f":"+$B$5","v":0},0,0.1,0,0,0,0,0]
[null,null,null,null,"spot maintenance cost 150 HPS",0,{"$f":"+$B$6","v":0},0,0.1,0,0,0,0,0]
[null,null,null,null,"spot maintenance cost 200 HPS",0,{"$f":"+$B$7","v":0},0,0.1,0,0,0,0,0]
[null,null,null,null,"spot maintenance cost 250 HPS",0,{"$f":"+$B$8","v":0},0,0.1,0,0,0,0,0]
[null,null,null,null,"spot maintenance cost 400 HPS",{"$f":"$I$155","v":0},{"$f":"+$B$9","v":0},0,0.1,{"$f":"J$3*$H115","v":0},0,0,0,0]
[null,null,null,null,"spot maintenance cost 1000 HPS",{"$f":"$I$155","v":0},{"$f":"+$B$10","v":0},0,0.1,{"$f":"J$3*$H116","v":0},0,0,0,0]
[null,null,null,null,"luminaire maintenance 50 HPS",0,{"$f":"+$B$3","v":0},0,0.05,{"$f":"J$3*$H117*$I117","v":0},0,{"$f":"L$3*$H117*$I117","v":0},0,0]
[null,null,null,null,"luminaire maintenance 70 HPS",0,{"$f":"+$B$4","v":0},{"$f":"F118*G118*I118","v":0},0.05,0,0,0,0,0]
[null,null,null,null,"luminaire maintenance 100 HPS",0,{"$f":"+$B$5","v":0},0,0.05,0,0,0,0,0]
[null,null,null,null,"luminaire maintenance 150 HPS",0,{"$f":"+$B$6","v":0},0,0.05,0,0,0,0,0]
[null,null,null,null,"luminaire maintenance 200 HPS",0,{"$f":"+$B$7","v":0},0,0.05,0,0,0,0,0]
[null,null,null,null,"luminaire maintenance 250 HPS",0,{"$f":"+$B$8","v":0},0,0.05,0,0,0,0,0]
[null,null,null,null,"luminaire maintenance 400 HPS",0,{"$f":"+$B$9","v":0},0,0.05,0,0,0,0,0]
[null,null,null,null,"luminaire maintenance 1000 HPS",0,{"$f":"+$B$10","v":0},0,0.05,0,0,0,0,0]
[null,null,null,null,"group maintenance cost 50 LED",32.14,{"$f":"+$B$3","v":0},0,1,0,0,0,0,0,0,{"$f":"$J$4*$H125*((1+$B$55)^P$2)","v":0},0,0,0,0,0,0,{"$f":"$J$4*$H125*((1+$B$55)^W$2)","v":0},0,0]
[null,null,null,null,"group maintenance cost 70 LED",32.14,{"$f":"+$B$4","v":0},{"$f":"F126*G126*I126","v":0},1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"group maintenance cost 70 LED",33.14,{"$f":"+$B$4","v":0},0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"group maintenance cost 100 LED",33.14,{"$f":"+$B$5","v":0},0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"group maintenance cost 150 LED",33.14,{"$f":"+$B$6","v":0},0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"group maintenance cost 200 LED",33.14,{"$f":"+$B$7","v":0},0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"group maintenance cost 250 LED",33.14,{"$f":"+$B$8","v":0},0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"group maintenance cost 400 LED",33.14,{"$f":"+$B$9","v":0},0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"group maintenance cost 1000 LED",33.14,{"$f":"+$B$10","v":0},0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"group maintenance cost 50 HPS",33.14,{"$f":"+$B$3","v":0},{"$f":"F134*G134*I134","v":0},0.25,{"$f":"J$3*$H134","v":0},{"$f":"K$3*$H134*(1+$B$55)","v":0},{"$f":"L$3*$H134*((1+$B$55)^L$2)","v":0},0,0]
[null,null,null,null,"group maintenance cost 70 HPS",33.14,{"$f":"+$B$4","v":0},0,0.25,0,0,0,0,0]
[null,null,null,null,"group maintenance cost 100 HPS",33.14,{"$f":"+$B$5","v":0},0,0.25,0,0,0,0,0]
[null,null,null,null,"group maintenance cost 150 HPS",33.14,{"$f":"+$B$6","v":0},0,0.25,0,0,0,0,0]
[null,null,null,null,"group maintenance cost 200 HPS",33.14,{"$f":"+$B$7","v":0},0,0.25,0,0,0,0,0]
[null,null,null,null,"group maintenance cost 250 HPS",33.14,{"$f":"+$B$8","v":0},0,0.25,0,0,0,0,0]
[null,null,null,null,"group maintenance cost 400 HPS",33.14,{"$f":"+$B$9","v":0},{"$f":"F140*G140*I140","v":0},0.25,{"$f":"J$3*$H140","v":0},0,0,0,0]
[null,null,null,null,"group maintenance cost 1000 HPS",33.14,{"$f":"+$B$10","v":0},{"$f":"F141*G141*I141","v":0},0.25,0,0,0,0,0]
[null,null,null,null,"interest",3.5000000000000003E-2,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,"status quo costs",null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,"non spot lamping",null,null,"spot lamping",0,0,0,0,0]
[null,null,null,null,"luminaire costs",415869,null,null,null,0,0,0,0,0]
[null,null,null,null,"number of work orders",1888,null,null,{"$f":"M167","v":0},0,0,{"$f":"L$3*$H154*((1+$B$55)^L$2)","v":0},0,0]
[null,null,null,null,"unit cost",{"$f":"F153/F154","v":220.26959745762713},null,null,{"$f":"N167","v":0},0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,"extrapolated per year",{"$f":"12/9*F154","v":2517.333333333333},"units expected to fail",null,{"$f":"12/8*I154","v":0},0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,"percentage failure of 50,000 ",{"$f":"F157/50000","v":5.0346666666666658E-2},null,null,{"$f":"I157/50000","v":0},0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,"annual",{"$f":"F157*F155","v":554492},null,null,{"$f":"I157*I155","v":0},0,0,0,0,0]
[null,null,null,null,"total maintenance",{"$f":"F162+I162","v":554492},null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0]

{"sheet":"ballast losses","index":8,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Nominal","Ballast Loss "]
[" Lamp Wattage  "," as a Percentage (%) of Lamp Wattage  "]
[50,{"$f":"+'Data Input and Instructions'!C50","v":0.35},null,50,{"$f":"+A3*B3","v":17.5},{"$f":"+D3+E3","v":67.5}]
[70,{"$f":"+'Data Input and Instructions'!C51","v":0.3},null,70,21,{"$f":"+D4+E4","v":91}]
[100,{"$f":"+'Data Input and Instructions'!C52","v":0.3},null,100,30,{"$f":"+D5+E5","v":130}]
[150,{"$f":"+'Data Input and Instructions'!C53","v":0.25},null,150,37.5,187.5]
[200,{"$f":"+'Data Input and Instructions'!C54","v":0.2},null,200,40,240]
[250,{"$f":"+'Data Input and Instructions'!C55","v":0.18},null,250,45,295]
[400,{"$f":"+'Data Input and Instructions'!C56","v":0.14000000000000001},null,400,56.000000000000007,{"$f":"+D9+E9","v":456}]
[1000,{"$f":"+'Data Input and Instructions'!C57","v":0.11},null,1000,110,1110]

{"sheet":"GHG Calculator","index":9,"n_rows":388,"n_cols":9,"rows_kept":388,"cut":false,"hidden":true,"merged":[]}
["Overhead Street Lighting"]
["Electricity Usage Calculator"]
[]
["Enter latitude and lighting parameters below",null,null,null,null,null,"Estimated Usage:"]
["to calculate estimated electricity usage.",null,null,null,null,null,null,null,"Estimated"]
[null,null,null,null,null,"Month","Month","Night Hrs","Usage (kWh)"]
[null,null,null,null,null,1,"Jan",{"$f":"SUMIF(F$24:F$388,F7,I$24:I$388)","v":479.21874319809734},{"$f":"$C$20*H7/1000","v":0}]
["Latitude:",54.23,null,null,null,2,"Feb",396.55171460603327,0]
[null,null,null,null,null,3,"Mar",377.78706135093768,0]
["Lighting Parameters:",null,null,null,null,4,"Apr",301.81469047307002,0]
["# of Lamps","Wattage","Watts",null,null,5,"May",262.91654890376532,0]
[{"$f":"+'Data Input and Instructions'!C26","v":0},50,{"$f":"A12*B12","v":0},null,null,6,"Jun",233.88486772374688,0]
[{"$f":"+'Data Input and Instructions'!C27","v":0},70,0,null,null,7,"Jul",250.1904196503632,0]
[{"$f":"+'Data Input and Instructions'!C28","v":0},100,0,null,null,8,"Aug",288.29346891881403,0]
[{"$f":"+'Data Input and Instructions'!C29","v":0},150,0,null,null,9,"Sep",337.00889651800497,0]
[{"$f":"+'Data Input and Instructions'!C30","v":0},200,0,null,null,10,"Oct",414.26491730348732,0]
[{"$f":"+'Data Input and Instructions'!C31","v":0},250,0,null,null,11,"Nov",451.2033766363765,0]
[{"$f":"+'Data Input and Instructions'!C32","v":0},400,0,null,null,12,"Dec",489.46254134257055,0]
[{"$f":"+'Data Input and Instructions'!C33","v":0},1000,0,null,null,null,"Annual Total (kWh):",null,{"$f":"SUM(I7:I18)","v":0}]
["Total Watts:",null,{"$f":"SUM(C13:C19)","v":0}]
[]
[null,null,null,null,null,null,"Estimated Hours of Day/Night:"]
[null,null,null,null,"Day #","Month","Date","Daylight Hrs","Night Hrs"]
[null,null,null,null,1,{"$f":"MONTH(G24)","v":1},"2011-01-01",{"$f":"24-(24/PI())*(ACOS((SIN(0.8333*PI()/180) + SIN(B$8*PI()/180)*SIN(ASIN(0.39795*COS(0.2163108 + 2*ATAN(0.9671396*TAN(0.0086*($E24-186)))))))/COS(B$8*PI()/180)*COS(ASIN(0.39795*COS(0.2163108 + 2*ATAN(0.9671396*TAN(0.0086*($E24-186))))))))","v":8.1963106419744829},{"$f":"24-H24","v":15.803689358025517}]
[null,null,null,null,2,{"$f":"MONTH(G25)","v":1},"2011-01-02",8.2081704014770338,{"$f":"24-H25","v":15.791829598522966}]
[null,null,null,null,3,1,"2011-01-03",8.2211845028561967,15.778815497143803]
[null,null,null,null,4,1,"2011-01-04",8.2353537657369298,15.76464623426307]
[null,null,null,null,5,1,"2011-01-05",8.2506789322796656,15.749321067720334]
[null,null,null,null,6,1,"2011-01-06",8.2671606411747245,15.732839358825276]
[null,null,null,null,7,1,"2011-01-07",8.2847994004960697,15.71520059950393]
[null,null,null,null,8,1,"2011-01-08",8.3035955596138233,15.696404440386177]
[null,null,null,null,9,1,"2011-01-09",8.3235492803698019,15.676450719630198]
[null,null,null,null,10,1,"2011-01-10",8.3446605077234963,15.655339492276504]
[null,null,null,null,11,1,"2011-01-11",8.3669289400770275,15.633071059922973]
[null,null,null,null,12,1,"2011-01-12",8.3903539994869138,15.609646000513086]
[null,null,null,null,13,1,"2011-01-13",8.414934801968041,15.585065198031959]
[null,null,null,null,14,1,"2011-01-14",8.4406701280906553,15.559329871909345]
[null,null,null,null,15,1,"2011-01-15",8.4675583940654757,15.532441605934524]
[null,null,null,null,16,1,"2011-01-16",8.4955976235041746,15.504402376495825]
[null,null,null,null,17,1,"2011-01-17",8.5247854200334903,15.47521457996651]
[null,null,null,null,18,1,"2011-01-18",8.5551189409308535,15.444881059069147]
[null,null,null,null,19,1,"2011-01-19",8.5865948719376597,15.41340512806234]
[null,null,null,null,20,1,"2011-01-20",8.6192094033938584,15.380790596606142]
[null,null,null,null,21,1,"2011-01-21",8.6529582078238274,15.347041792176173]
[null,null,null,null,22,1,"2011-01-22",8.6878364190893844,15.312163580910616]
[null,null,null,null,23,1,"2011-01-23",8.7238386132110293,15.276161386788971]
[null,null,null,null,24,1,"2011-01-24",8.7609587909433575,15.239041209056643]
[null,null,null,null,25,1,"2011-01-25",8.7991903621753345,15.200809637824666]
[null,null,null,null,26,1,"2011-01-26",8.8385261322107773,15.161473867789223]
[null,null,null,null,27,1,"2011-01-27",8.878958289969205,15.121041710030795]
[null,null,null,null,28,1,"2011-01-28",8.9204783981324258,15.079521601867574]
[null,null,null,null,29,1,"2011-01-29",8.9630773852475887,15.036922614752411]
[null,null,null,null,30,1,"2011-01-30",9.0067455397837399,14.99325446021626]
[null,null,null,null,31,1,"2011-01-31",9.0514725061255454,14.948527493874455]
[null,null,null,null,32,2,"2011-02-01",9.0972472824754966,14.902752717524503]
[null,null,null,null,33,2,"2011-02-02",9.1440582206242382,14.855941779375762]
[null,null,null,null,34,2,"2011-02-03",9.1918930275381285,14.808106972461871]
[null,null,null,null,35,2,"2011-02-04",9.240738768703336,14.759261231296664]
[null,null,null,null,36,2,"2011-02-05",9.2905818731573078,14.709418126842692]
[null,null,null,null,37,2,"2011-02-06",9.3414081401307456,14.658591859869254]
[null,null,null,null,38,2,"2011-02-07",9.3932027472168027,14.606797252783197]
[null,null,null,null,39,2,"2011-02-08",9.4459502599787655,14.554049740021235]
[null,null,null,null,40,2,"2011-02-09",9.4996346429031018,14.500365357096898]
[null,null,null,null,41,2,"2011-02-10",9.5542392716014302,14.44576072839857]
[null,null,null,null,42,2,"2011-02-11",9.6097469461626233,14.390253053837377]
[null,null,null,null,43,2,"2011-02-12",9.6661399055548394,14.333860094445161]
[null,null,null,null,44,2,"2011-02-13",9.7233998429768107,14.276600157023189]
[null,null,null,null,45,2,"2011-02-14",9.781507922058081,14.218492077941919]
[null,null,null,null,46,2,"2011-02-15",9.8404447938089259,14.159555206191074]
[null,null,null,null,47,2,"2011-02-16",9.9001906142226943,14.099809385777306]
[null,null,null,null,48,2,"2011-02-17",9.960725062435646,14.039274937564354]
[null,null,null,null,49,2,"2011-02-18",10.022027359352457,13.977972640647543]
[null,null,null,null,50,2,"2011-02-19",10.084076286649251,13.915923713350749]
[null,null,null,null,51,2,"2011-02-20",10.146850206069832,13.853149793930168]
[null,null,null,null,52,2,"2011-02-21",10.210327078935284,13.789672921064716]
[null,null,null,null,53,2,"2011-02-22",10.274484485791762,13.725515514208238]
[null,null,null,null,54,2,"2011-02-23",10.339299646126067,13.660700353873933]
[null,null,null,null,55,2,"2011-02-24",10.404749438083915,13.595250561916085]
[null,null,null,null,56,2,"2011-02-25",10.470810418130705,13.529189581869295]
[null,null,null,null,57,2,"2011-02-26",10.537458840600106,13.462541159399894]
[null,null,null,null,58,2,"2011-02-27",10.604670677080852,13.395329322919148]
[null,null,null,null,59,2,"2011-02-28",10.672421635597567,13.327578364402433]
[null,null,null,null,60,3,"2011-03-01",10.740687179546413,13.259312820453587]
[null,null,null,null,61,3,"2011-03-02",10.809442546351614,13.190557453648386]
[null,null,null,null,62,3,"2011-03-03",10.878662765813761,13.121337234186239]
[null,null,null,null,63,3,"2011-03-04",10.948322678125544,13.051677321874456]
[null,null,null,null,64,3,"2011-03-05",11.018396951535307,12.981603048464693]
[null,null,null,null,65,3,"2011-03-06",{"$f":"24-(24/PI())*(ACOS((SIN(0.8333*PI()/180) + SIN(B$8*PI()/180)*SIN(ASIN(0.39795*COS(0.2163108 + 2*ATAN(0.9671396*TAN(0.0086*($E88-186)))))))/COS(B$8*PI()/180)*COS(ASIN(0.39795*COS(0.2163108 + 2*ATAN(0.9671396*TAN(0.0086*($E88-186))))))))","v":11.08886009964303},12.91113990035697]
[null,null,null,null,66,{"$f":"MONTH(G89)","v":3},"2011-03-07",11.159686498317706,{"$f":"24-H89","v":12.840313501682294}]
[null,null,null,null,67,3,"2011-03-08",11.230850402228883,12.769149597771117]
[null,null,null,null,68,3,"2011-03-09",11.302325960988947,12.697674039011053]
[null,null,null,null,69,3,"2011-03-10",11.374087234906192,12.625912765093808]
[null,null,null,null,70,3,"2011-03-11",11.446108210351873,12.553891789648127]
[null,null,null,null,71,3,"2011-03-12",11.51836281474748,12.48163718525252]
[null,null,null,null,72,3,"2011-03-13",11.59082493118113,12.40917506881887]
[null,null,null,null,73,3,"2011-03-14",11.663468412664493,12.336531587335507]
[null,null,null,null,74,3,"2011-03-15",11.736267096043813,12.263732903956187]
[null,null,null,null,75,3,"2011-03-16",11.809194815580625,12.190805184419375]
[null,null,null,null,76,3,"2011-03-17",11.882225416219422,12.117774583780578]
[null,null,null,null,77,3,"2011-03-18",11.955332766561076,12.044667233438924]
[null,null,null,null,78,3,"2011-03-19",12.028490771562049,11.971509228437951]
[null,null,null,null,79,3,"2011-03-20",12.101673384980419,11.898326615019581]
[null,null,null,null,80,3,"2011-03-21",12.174854621590624,11.825145378409376]
[null,null,null,null,81,3,"2011-03-22",12.248008569189368,11.751991430810632]
[null,null,null,null,82,3,"2011-03-23",12.321109400415516,11.678890599584484]
[null,null,null,null,83,3,"2011-03-24",12.394131384407006,11.605868615592994]
[null,null,null,null,84,3,"2011-03-25",12.467048898317747,11.532951101682253]
[null,null,null,null,85,3,"2011-03-26",12.539836438717264,11.460163561282736]
[null,null,null,null,86,3,"2011-03-27",12.612468632895462,11.387531367104538]
[null,null,null,null,87,3,"2011-03-28",12.684920250094217,11.315079749905783]
[null,null,null,null,88,3,"2011-03-29",12.757166212686792,11.242833787313208]
[null,null,null,null,89,3,"2011-03-30",12.829181607325083,11.170818392674917]
[null,null,null,null,90,3,"2011-03-31",12.900941696073506,11.099058303926494]
[null,null,null,null,91,4,"2011-04-01",12.97242192754717,11.02757807245283]
[null,null,null,null,92,4,"2011-04-02",13.043597948070321,10.956402051929679]
[null,null,null,null,93,4,"2011-04-03",13.114445612869543,10.885554387130457]
[null,null,null,null,94,4,"2011-04-04",13.184940997314337,10.815059002685663]
[null,null,null,null,95,4,"2011-04-05",13.255060408215702,10.744939591784298]
[null,null,null,null,96,4,"2011-04-06",13.324780395191331,10.675219604808669]
[null,null,null,null,97,4,"2011-04-07",13.394077762103635,10.605922237896365]
[null,null,null,null,98,4,"2011-04-08",13.462929578574524,10.537070421425476]
[null,null,null,null,99,4,"2011-04-09",13.53131319157826,10.46868680842174]
[null,null,null,null,100,4,"2011-04-10",13.599206237111018,10.400793762888982]
[null,null,null,null,101,4,"2011-04-11",13.666586651933082,10.333413348066918]
[null,null,null,null,102,4,"2011-04-12",13.733432685376577,10.266567314623423]
[null,null,null,null,103,4,"2011-04-13",13.799722911208763,10.200277088791237]
[null,null,null,null,104,4,"2011-04-14",13.865436239537706,10.134563760462294]
[null,null,null,null,105,4,"2011-04-15",13.930551928744094,10.069448071255906]
[null,null,null,null,106,4,"2011-04-16",13.995049597419662,10.004950402580338]
[null,null,null,null,107,4,"2011-04-17",14.058909236289452,9.9410907637105481]
[null,null,null,null,108,4,"2011-04-18",14.122111220091906,9.8778887799080941]
[null,null,null,null,109,4,"2011-04-19",14.184636319387435,9.815363680612565]
[null,null,null,null,110,4,"2011-04-20",14.24646571226293,9.7535342877370699]
[null,null,null,null,111,4,"2011-04-21",14.307580995896416,9.6924190041035843]
[null,null,null,null,112,4,"2011-04-22",14.367964197943005,9.6320358020569952]
[null,null,null,null,113,4,"2011-04-23",14.42759778770021,9.5724022122997905]
[null,null,null,null,114,4,"2011-04-24",14.486464687007853,9.5135353129921469]
[null,null,null,null,115,4,"2011-04-25",14.544548280835123,9.455451719164877]
[null,null,null,null,116,4,"2011-04-26",14.601832427504743,9.3981675724952574]
[null,null,null,null,117,4,"2011-04-27",14.658301468502033,9.3416985314979666]
[null,null,null,null,118,4,"2011-04-28",14.71394023781462,9.2860597621853795]
[null,null,null,null,119,4,"2011-04-29",14.768734070746856,9.2312659292531443]
[null,null,null,null,120,4,"2011-04-30",14.822668812151687,9.1773311878483135]
[null,null,null,null,121,5,"2011-05-01",14.875730824021726,9.1242691759782737]
[null,null,null,null,122,5,"2011-05-02",14.927906992380743,9.072093007619257]
[null,null,null,null,123,5,"2011-05-03",14.979184733416655,9.0208152665833445]
[null,null,null,null,124,5,"2011-05-04",15.029551998797483,8.9704480012025165]
[null,null,null,null,125,5,"2011-05-05",15.078997280112592,8.921002719887408]
[null,null,null,null,126,5,"2011-05-06",15.127509612382891,8.8724903876171091]
[null,null,null,null,127,5,"2011-05-07",15.175078576585641,8.8249214234143594]
[null,null,null,null,128,5,"2011-05-08",15.221694301141952,8.7783056988580483]
[null,null,null,null,129,5,"2011-05-09",{"$f":"24-(24/PI())*(ACOS((SIN(0.8333*PI()/180) + SIN(B$8*PI()/180)*SIN(ASIN(0.39795*COS(0.2163108 + 2*ATAN(0.9671396*TAN(0.0086*($E152-186)))))))/COS(B$8*PI()/180)*COS(ASIN(0.39795*COS(0.2163108 + 2*ATAN(0.9671396*TAN(0.0086*($E152-186))))))))","v":15.267347462318188},8.7326525376818118]
[null,null,null,null,130,{"$f":"MONTH(G153)","v":5},"2011-05-10",15.312029283496001,{"$f":"24-H153","v":8.6879707165039992}]
[null,null,null,null,131,5,"2011-05-11",15.355731533270118,8.6442684667298817]
[null,null,null,null,132,5,"2011-05-12",15.398446522337558,8.601553477662442]
[null,null,null,null,133,5,"2011-05-13",15.440167099147516,8.5598329008524843]
[null,null,null,null,134,5,"2011-05-14",15.480886644286876,8.5191133557131238]
[null,null,null,null,135,5,"2011-05-15",15.520599063582763,8.4794009364172371]
[null,null,null,null,136,5,"2011-05-16",15.559298779910408,8.4407012200895917]
[null,null,null,null,137,5,"2011-05-17",15.596980723701934,8.4030192762980658]
[null,null,null,null,138,5,"2011-05-18",15.633640322159282,8.3663596778407179]
[null,null,null,null,139,5,"2011-05-19",15.669273487182652,8.330726512817348]
[null,null,null,null,140,5,"2011-05-20",15.703876602034041,8.2961233979659585]
[null,null,null,null,141,5,"2011-05-21",15.737446506764046,8.2625534932359539]
[null,null,null,null,142,5,"2011-05-22",15.769980482438759,8.2300195175612405]
[null,null,null,null,143,5,"2011-05-23",15.801476234212295,8.198523765787705]
[null,null,null,null,144,5,"2011-05-24",15.831931873299245,8.1680681267007547]
[null,null,null,null,145,5,"2011-05-25",15.861345897909962,8.1386541020900385]
[null,null,null,null,146,5,"2011-05-26",15.889717173220069,8.1102828267799314]
[null,null,null,null,147,5,"2011-05-27",15.917044910453734,8.0829550895462656]
[null,null,null,null,148,5,"2011-05-28",15.943328645168204,8.0566713548317956]
[null,null,null,null,149,5,"2011-05-29",15.968568214834407,8.0314317851655925]
[null,null,null,null,150,5,"2011-05-30",15.992763735815476,8.0072362641845238]
[null,null,null,null,151,5,"2011-05-31",16.015915579851374,7.9840844201486263]
[null,null,null,null,152,6,"2011-06-01",16.038024350163457,7.9619756498365426]
[null,null,null,null,153,6,"2011-06-02",16.059090857297861,7.9409091427021394]
[null,null,null,null,154,6,"2011-06-03",16.079116094830802,7.9208839051691982]
[null,null,null,null,155,6,"2011-06-04",16.098101215062218,7.9018987849377815]
[null,null,null,null,156,6,"2011-06-05",16.116047504826717,7.8839524951732827]
[null,null,null,null,157,6,"2011-06-06",16.132956361552381,7.867043638447619]
[null,null,null,null,158,6,"2011-06-07",16.148829269698613,7.8511707303013871]
[null,null,null,null,159,6,"2011-06-08",16.163667777703829,7.8363322222961713]
[null,null,null,null,160,6,"2011-06-09",16.177473475572633,7.8225265244273672]
[null,null,null,null,161,6,"2011-06-10",16.190247973229663,7.8097520267703366]
[null,null,null,null,162,6,"2011-06-11",16.201992879764152,7.7980071202358481]
[null,null,null,null,163,6,"2011-06-12",16.212709783685021,7.7872902163149789]
[null,null,null,null,164,6,"2011-06-13",16.222400234301205,7.7775997656987954]
[null,null,null,null,165,6,"2011-06-14",16.231065724335764,7.7689342756642361]
[null,null,null,null,166,6,"2011-06-15",16.238707673875691,7.761292326124309]
[null,null,null,null,167,6,"2011-06-16",16.245327415751408,7.754672584248592]
[null,null,null,null,168,6,"2011-06-17",16.250926182431716,7.7490738175682843]
[null,null,null,null,169,6,"2011-06-18",16.255505094510774,7.7444949054892263]
[null,null,null,null,170,6,"2011-06-19",16.259065150854092,7.7409348491459085]
[null,null,null,null,171,6,"2011-06-20",16.261607220460245,7.7383927795397547]
[null,null,null,null,172,6,"2011-06-21",16.263132036084407,7.7368679639155928]
[null,null,null,null,173,6,"2011-06-22",16.263640189658815,7.7363598103411846]
[null,null,null,null,174,6,"2011-06-23",16.263132129534036,7.7368678704659644]
[null,null,null,null,175,6,"2011-06-24",16.261608159553404,7.7383918404465959]
[null,null,null,null,176,6,"2011-06-25",16.259068439961602,7.7409315600383977]
[null,null,null,null,177,6,"2011-06-26",16.255512990136712,7.7444870098632883]
[null,null,null,null,178,6,"2011-06-27",16.250941693123824,7.7490583068761758]
[null,null,null,null,179,6,"2011-06-28",16.245354301937002,7.7546456980629976]
[null,null,null,null,180,6,"2011-06-29",16.238750447585499,7.7612495524145011]
[null,null,null,null,181,6,"2011-06-30",16.231129648769638,7.7688703512303618]
[null,null,null,null,182,7,"2011-07-01",16.222491323181629,7.7775086768183712]
[null,null,null,null,183,7,"2011-07-02",16.212834800337113,7.787165199662887]
[null,null,null,null,184,7,"2011-07-03",16.202159335854262,7.7978406641457383]
[null,null,null,null,185,7,"2011-07-04",16.190464127088966,7.8095358729110345]
[null,null,null,null,186,7,"2011-07-05",16.177748330027264,7.8222516699727365]
[null,null,null,null,187,7,"2011-07-06",16.164011077329263,7.8359889226707367]
[null,null,null,null,188,7,"2011-07-07",16.149251497413061,7.8507485025869386]
[null,null,null,null,189,7,"2011-07-08",16.133468734462102,7.8665312655378976]
[null,null,null,null,190,7,"2011-07-09",16.116661969235363,7.8833380307646372]
[null,null,null,null,191,7,"2011-07-10",16.098830440556537,7.9011695594434634]
[null,null,null,null,192,7,"2011-07-11",16.07997346735624,7.9200265326437602]
[null,null,null,null,193,7,"2011-07-12",{"$f":"24-(24/PI())*(ACOS((SIN(0.8333*PI()/180) + SIN(B$8*PI()/180)*SIN(ASIN(0.39795*COS(0.2163108 + 2*ATAN(0.9671396*TAN(0.0086*($E216-186)))))))/COS(B$8*PI()/180)*COS(ASIN(0.39795*COS(0.2163108 + 2*ATAN(0.9671396*TAN(0.0086*($E216-186))))))))","v":16.06009047113994},7.9399095288600599]
[null,null,null,null,194,{"$f":"MONTH(G217)","v":7},"2011-07-13",16.039180998754041,{"$f":"24-H217","v":7.9608190012459588}]
[null,null,null,null,195,7,"2011-07-14",16.017244745323136,7.9827552546768636]
[null,null,null,null,196,7,"2011-07-15",15.994281577232965,8.0057184227670355]
[null,null,null,null,197,7,"2011-07-16",15.970291555036056,8.0297084449639442]
[null,null,null,null,198,7,"2011-07-17",15.945274956160228,8.0547250438397722]
[null,null,null,null,199,7,"2011-07-18",15.919232297304196,8.0807677026958036]
[null,null,null,null,200,7,"2011-07-19",15.892164356409321,8.1078356435906791]
[null,null,null,null,201,7,"2011-07-20",15.864072194101965,8.1359278058980351]
[null,null,null,null,202,7,"2011-07-21",15.834957174507077,8.1650428254929235]
[null,null,null,null,203,7,"2011-07-22",15.804820985340214,8.1951790146597858]
[null,null,null,null,204,7,"2011-07-23",15.77366565719233,8.2263343428076698]
[null,null,null,null,205,7,"2011-07-24",15.74149358192923,8.2585064180707697]
[null,null,null,null,206,7,"2011-07-25",15.708307530135388,8.2916924698646124]
[null,null,null,null,207,7,"2011-07-26",15.674110667539912,8.325889332460088]
[null,null,null,null,208,7,"2011-07-27",15.638906570370795,8.3610934296292054]
[null,null,null,null,209,7,"2011-07-28",15.602699239591775,8.3973007604082248]
[null,null,null,null,210,7,"2011-07-29",15.565493113984699,8.434506886015301]
[null,null,null,null,211,7,"2011-07-30",15.527293082048381,8.4727069179516192]
[null,null,null,null,212,7,"2011-07-31",15.488104492693287,8.5118955073067131]
[null,null,null,null,213,8,"2011-08-01",15.447933164719272,8.5520668352807281]
[null,null,null,null,214,8,"2011-08-02",15.40678539507134,8.5932146049286597]
[null,null,null,null,215,8,"2011-08-03",15.364667965875777,8.6353320341242235]
[null,null,null,null,216,8,"2011-08-04",15.32158815026613,8.6784118497338696]
[null,null,null,null,217,8,"2011-08-05",15.277553717015039,8.7224462829849614]
[null,null,null,null,218,8,"2011-08-06",15.232572933994172,8.767427066005828]
[null,null,null,null,219,8,"2011-08-07",15.186654570490258,8.8133454295097415]
[null,null,null,null,220,8,"2011-08-08",15.139807898410307,8.8601921015896927]
[null,null,null,null,221,8,"2011-08-09",15.092042692413937,8.907957307586063]
[null,null,null,null,222,8,"2011-08-10",15.043369229014724,8.9566307709852762]
[null,null,null,null,223,8,"2011-08-11",14.993798284696222,9.0062017153037779]
[null,null,null,null,224,8,"2011-08-12",14.943341133091311,9.0566588669086894]
[null,null,null,null,225,8,"2011-08-13",14.892009541275991,9.107990458724009]
[null,null,null,null,226,8,"2011-08-14",14.839815765230908,9.1601842347690923]
[null,null,null,null,227,8,"2011-08-15",14.786772544525148,9.2132274554748523]
[null,null,null,null,228,8,"2011-08-16",14.732893096278039,9.2671069037219613]
[null,null,null,null,229,8,"2011-08-17",14.678191108455053,9.3218088915449471]
[null,null,null,null,230,8,"2011-08-18",14.622680732554034,9.3773192674459658]
[null,null,null,null,231,8,"2011-08-19",14.566376575737621,9.4336234242623789]
[null,null,null,null,232,8,"2011-08-20",14.509293692466871,9.490706307533129]
[null,null,null,null,233,8,"2011-08-21",14.451447575690173,9.5485524243098272]
[null,null,null,null,234,8,"2011-08-22",14.392854147639838,9.6071458523601621]
[null,null,null,null,235,8,"2011-08-23",14.333529750287214,9.6664702497127859]
[null,null,null,null,236,8,"2011-08-24",14.273491135505042,9.7265088644949582]
[null,null,null,null,237,8,"2011-08-25",14.212755454983554,9.7872445450164456]
[null,null,null,null,238,8,"2011-08-26",14.15134024994434,9.8486597500556599]
[null,null,null,null,239,8,"2011-08-27",14.089263440693465,9.9107365593065353]
[null,null,null,null,240,8,"2011-08-28",14.02654331605242,9.97345668394758]
[null,null,null,null,241,8,"2011-08-29",13.963198522702783,10.036801477297217]
[null,null,null,null,242,8,"2011-08-30",13.899248054477351,10.100751945522649]
[null,null,null,null,243,8,"2011-08-31",13.834711241627604,10.165288758372396]
[null,null,null,null,244,9,"2011-09-01",13.769607740094234,10.230392259905766]
[null,null,null,null,245,9,"2011-09-02",13.703957520804487,10.296042479195513]
[null,null,null,null,246,9,"2011-09-03",13.637780859016903,10.362219140983097]
[null,null,null,null,247,9,"2011-09-04",13.571098323731109,10.428901676268891]
[null,null,null,null,248,9,"2011-09-05",13.503930767177259,10.496069232822741]
[null,null,null,null,249,9,"2011-09-06",13.436299314396857,10.563700685603143]
[null,null,null,null,250,9,"2011-09-07",13.368225352923732,10.631774647076268]
[null,null,null,null,251,9,"2011-09-08",13.299730522571291,10.700269477428709]
[null,null,null,null,252,9,"2011-09-09",13.230836705329363,10.769163294670637]
[null,null,null,null,253,9,"2011-09-10",13.161566015371436,10.838433984628564]
[null,null,null,null,254,9,"2011-09-11",13.091940789170645,10.908059210829355]
[null,null,null,null,255,9,"2011-09-12",13.021983575720384,10.978016424279616]
[null,null,null,null,256,9,"2011-09-13",12.951717126853346,11.048282873146654]
[null,null,null,null,257,9,"2011-09-14",{"$f":"24-(24/PI())*(ACOS((SIN(0.8333*PI()/180) + SIN(B$8*PI()/180)*SIN(ASIN(0.39795*COS(0.2163108 + 2*ATAN(0.9671396*TAN(0.0086*($E280-186)))))))/COS(B$8*PI()/180)*COS(ASIN(0.39795*COS(0.2163108 + 2*ATAN(0.9671396*TAN(0.0086*($E280-186))))))))","v":12.881164387650532},11.118835612349468]
[null,null,null,null,258,{"$f":"MONTH(G281)","v":9},"2011-09-15",12.810348486929904,{"$f":"24-H281","v":11.189651513070096}]
[null,null,null,null,259,9,"2011-09-16",12.739292727802434,11.260707272197566]
[null,null,null,null,260,9,"2011-09-17",12.66802057828165,11.33197942171835]
[null,null,null,null,261,9,"2011-09-18",12.596555661931134,11.403444338068866]
[null,null,null,null,262,9,"2011-09-19",12.524921748533096,11.475078251466904]
[null,null,null,null,263,9,"2011-09-20",12.453142744759766,11.546857255240234]
[null,null,null,null,264,9,"2011-09-21",12.38124268482826,11.61875731517174]
[null,null,null,null,265,9,"2011-09-22",12.309245721118577,11.690754278881423]
[null,null,null,null,266,9,"2011-09-23",12.237176114733524,11.762823885266476]
[null,null,null,null,267,9,"2011-09-24",12.165058225978704,11.834941774021296]
[null,null,null,null,268,9,"2011-09-25",12.092916504740119,11.907083495259881]
[null,null,null,null,269,9,"2011-09-26",12.020775480736642,11.979224519263358]
[null,null,null,null,270,9,"2011-09-27",11.948659753624344,12.051340246375656]
[null,null,null,null,271,9,"2011-09-28",11.876593982929618,12.123406017070382]
[null,null,null,null,272,9,"2011-09-29",11.804602877788204,12.195397122211796]
[null,null,null,null,273,9,"2011-09-30",11.732711186467514,12.267288813532486]
[null,null,null,null,274,10,"2011-10-01",11.660943685650086,12.339056314349914]
[null,null,null,null,275,10,"2011-10-02",11.589325169456766,12.410674830543234]
[null,null,null,null,276,10,"2011-10-03",11.517880438188973,12.482119561811027]
[null,null,null,null,277,10,"2011-10-04",11.446634286770538,12.553365713229462]
[null,null,null,null,278,10,"2011-10-05",11.375611492870815,12.624388507129185]
[null,null,null,null,279,10,"2011-10-06",11.304836804692284,12.695163195307716]
[null,null,null,null,280,10,"2011-10-07",11.234334928407483,12.765665071592517]
[null,null,null,null,281,10,"2011-10-08",11.16413051523207,12.83586948476793]
[null,null,null,null,282,10,"2011-10-09",11.09424814812289,12.90575185187711]
[null,null,null,null,283,10,"2011-10-10",11.024712328092299,12.975287671907701]
[null,null,null,null,284,10,"2011-10-11",10.955547460132584,13.044452539867416]
[null,null,null,null,285,10,"2011-10-12",10.886777838747069,13.113222161252931]
[null,null,null,null,286,10,"2011-10-13",10.818427633087639,13.181572366912361]
[null,null,null,null,287,10,"2011-10-14",10.750520871701561,13.249479128298439]
[null,null,null,null,288,10,"2011-10-15",10.6830814268941,13.3169185731059]
[null,null,null,null,289,10,"2011-10-16",10.616132998717058,13.383867001282942]
[null,null,null,null,290,10,"2011-10-17",10.5496990985973,13.4503009014027]
[null,null,null,null,291,10,"2011-10-18",10.483803032623552,13.516196967376448]
[null,null,null,null,292,10,"2011-10-19",10.41846788451395,13.58153211548605]
[null,null,null,null,293,10,"2011-10-20",10.353716498291391,13.646283501708609]
[null,null,null,null,294,10,"2011-10-21",10.289571460698408,13.710428539301592]
[null,null,null,null,295,10,"2011-10-22",10.226055083387935,13.773944916612065]
[null,null,null,null,296,10,"2011-10-23",10.163189384931385,13.836810615068615]
[null,null,null,null,297,10,"2011-10-24",10.100996072690238,13.899003927309762]
[null,null,null,null,298,10,"2011-10-25",10.039496524602404,13.960503475397596]
[null,null,null,null,299,10,"2011-10-26",9.9787117709395634,14.021288229060437]
[null,null,null,null,300,10,"2011-10-27",9.9186624760966193,14.081337523903381]
[null,null,null,null,301,10,"2011-10-28",9.8593689204791755,14.140631079520825]
[null,null,null,null,302,10,"2011-10-29",9.8008509825596466,14.199149017440353]
[null,null,null,null,303,10,"2011-10-30",9.7431281211770528,14.256871878822947]
[null,null,null,null,304,10,"2011-10-31",9.6862193581597431,14.313780641840257]
[null,null,null,null,305,11,"2011-11-01",9.6301432613541493,14.369856738645851]
[null,null,null,null,306,11,"2011-11-02",9.5749179281461316,14.425082071853868]
[null,null,null,null,307,11,"2011-11-03",9.5205609695645013,14.479439030435499]
[null,null,null,null,308,11,"2011-11-04",9.4670894950588131,14.532910504941187]
[null,null,null,null,309,11,"2011-11-05",9.4145200980453509,14.585479901954649]
[null,null,null,null,310,11,"2011-11-06",9.3628688423165674,14.637131157683433]
[null,null,null,null,311,11,"2011-11-07",9.312151249409661,14.687848750590339]
[null,null,null,null,312,11,"2011-11-08",9.2623822870298085,14.737617712970192]
[null,null,null,null,313,11,"2011-11-09",9.213576358622408,14.786423641377592]
[null,null,null,null,314,11,"2011-11-10",9.1657472941867475,14.834252705813253]
[null,null,null,null,315,11,"2011-11-11",9.118908342420605,14.881091657579395]
[null,null,null,null,316,11,"2011-11-12",9.0730721642813634,14.926927835718637]
[null,null,null,null,317,11,"2011-11-13",9.02825082804444,14.97174917195556]
[null,null,null,null,318,11,"2011-11-14",8.9844558059338322,15.015544194066168]
[null,null,null,null,319,11,"2011-11-15",8.9416979723928005,15.058302027607199]
[null,null,null,null,320,11,"2011-11-16",8.8999876040546724,15.100012395945328]
[null,null,null,null,321,11,"2011-11-17",{"$f":"24-(24/PI())*(ACOS((SIN(0.8333*PI()/180) + SIN(B$8*PI()/180)*SIN(ASIN(0.39795*COS(0.2163108 + 2*ATAN(0.9671396*TAN(0.0086*($E344-186)))))))/COS(B$8*PI()/180)*COS(ASIN(0.39795*COS(0.2163108 + 2*ATAN(0.9671396*TAN(0.0086*($E344-186))))))))","v":8.8593343814649934},15.140665618535007]
[null,null,null,null,322,{"$f":"MONTH(G345)","v":11},"2011-11-18",8.819747392596204,{"$f":"24-H345","v":15.180252607403796}]
[null,null,null,null,323,11,"2011-11-19",8.7812351381854423,15.218764861814558]
[null,null,null,null,324,11,"2011-11-20",8.7438055389142768,15.256194461085723]
[null,null,null,null,325,11,"2011-11-21",8.7074659444368461,15.292534055563154]
[null,null,null,null,326,11,"2011-11-22",8.6722231442498234,15.327776855750177]
[null,null,null,null,327,11,"2011-11-23",8.6380833803838328,15.361916619616167]
[null,null,null,null,328,11,"2011-11-24",8.6050523618819597,15.39494763811804]
[null,null,null,null,329,11,"2011-11-25",8.5731352810163504,15.42686471898365]
[null,null,null,null,330,11,"2011-11-26",8.5423368311793464,15.457663168820654]
[null,null,null,null,331,11,"2011-11-27",8.5126612263707973,15.487338773629203]
[null,null,null,null,332,11,"2011-11-28",8.4841122221886067,15.515887777811393]
[null,null,null,null,333,11,"2011-11-29",8.4566931382151047,15.543306861784895]
[null,null,null,null,334,11,"2011-11-30",8.4304068816780315,15.569593118321968]
[null,null,null,null,335,12,"2011-12-01",8.4052559722514832,15.594744027748517]
[null,null,null,null,336,12,"2011-12-02",8.3812425678495899,15.61875743215041]
[null,null,null,null,337,12,"2011-12-03",8.3583684912539891,15.641631508746011]
[null,null,null,null,338,12,"2011-12-04",8.3366352574056819,15.663364742594318]
[null,null,null,null,339,12,"2011-12-05",8.316044101182305,15.683955898817695]
[null,null,null,null,340,12,"2011-12-06",8.2965960054739316,15.703403994526068]
[null,null,null,null,341,12,"2011-12-07",8.2782917293639375,15.721708270636062]
[null,null,null,null,342,12,"2011-12-08",8.2611318362165385,15.738868163783462]
[null,null,null,null,343,12,"2011-12-09",8.2451167214692234,15.754883278530777]
[null,null,null,null,344,12,"2011-12-10",8.2302466399269676,15.769753360073032]
[null,null,null,null,345,12,"2011-12-11",8.2165217323551865,15.783478267644814]
[null,null,null,null,346,12,"2011-12-12",8.2039420511707384,15.796057948829262]
[null,null,null,null,347,12,"2011-12-13",8.1925075850341127,15.807492414965887]
[null,null,null,null,348,12,"2011-12-14",8.18221828215197,15.81778171784803]
[null,null,null,null,349,12,"2011-12-15",8.1730740721066937,15.826925927893306]
[null,null,null,null,350,12,"2011-12-16",8.1650748860392728,15.834925113960727]
[null,null,null,null,351,12,"2011-12-17",8.158220675022898,15.841779324977102]
[null,null,null,null,352,12,"2011-12-18",8.1525114264773837,15.847488573522616]
[null,null,null,null,353,12,"2011-12-19",8.1479471784890194,15.852052821510981]
[null,null,null,null,354,12,"2011-12-20",8.1445280319158471,15.855471968084153]
[null,null,null,null,355,12,"2011-12-21",8.1422541601754581,15.857745839824542]
[null,null,null,null,356,12,"2011-12-22",8.1411258166302112,15.858874183369789]
[null,null,null,null,357,12,"2011-12-23",8.1411433395036994,15.858856660496301]
[null,null,null,null,358,12,"2011-12-24",8.1423071542817702,15.85769284571823]
[null,null,null,null,359,12,"2011-12-25",8.1446177735714027,15.855382226428597]
[null,null,null,null,360,12,"2011-12-26",8.148075794411243,15.851924205588757]
[null,null,null,null,361,12,"2011-12-27",8.1526818930478822,15.847318106952118]
[null,null,null,null,362,12,"2011-12-28",8.1584368172123494,15.841563182787651]
[null,null,null,null,363,12,"2011-12-29",8.1653413759513818,15.834658624048618]
[null,null,null,null,364,12,"2011-12-30",8.1733964270873845,15.826603572912616]
[null,null,null,null,365,12,"2011-12-31",8.1826028623999925,15.817397137600008]

{"sheet":"GHG savings","index":10,"n_rows":51,"n_cols":15,"rows_kept":51,"cut":false,"hidden":true,"merged":[[5,2,5,5],[6,2,8,2],[6,3,6,5],[7,3,7,5],[12,3,13,3],[12,4,13,4],[12,5,13,5]]}
[]
[]
[]
[]
[null,null,"British Columbia"]
[]
[null,null,"British Columbia","Greenhouse Gas Intensity1"]
[null,null,null,"(g GHG/kWh electricity generated)"]
[null,null,null,1990,2008,20092]
[null,null,"CO2 Intensity",17,26,24]
[null,null,"CH4 Intensity",4.0000000000000001E-3,7.0000000000000001E-3,6.0000000000000001E-3]
[null,null,"N2O Intensity",1E-3,6.9999999999999999E-4,5.9999999999999995E-4]
[null,null,"Overall Intensity3",17,27,25]
[null,null,"(g CO2 eq/kWh)"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+I27/325652","v":0}]
[null,null,null,null,null,null,"HPS",null,{"$f":"+'GHG Calculator'!I19","v":0},"grams CO2e"]
[null,null,null,null,null,null,null,null,{"$f":"+I21/1000000","v":0},"Tonnes CO2e per year"]
[null,null,null,null,null,null,null,null,{"$f":"+I22*12","v":0},"Tonnes CO2e per 12 years"]
[null,null,null,null,null,null,null,null,{"$f":"+I22*15","v":0},"Tonnes CO2e per 15 years"]
[null,null,null,null,null,null,null,null,{"$f":"+I22*25","v":0},"Carbon price per year"]
[null,"Carbon price",null,{"$f":"+'Data Input and Instructions'!C71","v":25},null,null,null,null,{"$f":"+I23*25","v":0},"Carbon price 12 years"]
[null,null,null,null,null,null,null,null,{"$f":"+I24*25","v":0},"Carbon price 15 years"]
[null,null,null,null,null,null,null,null,null,null,null,"Savings"]
[null,null,null,null,null,null,"LED 30%",null,{"$f":"+I21*0.7","v":0},"grams CO2e",null,null,{"$f":"+I21-I29","v":0},"grams CO2e"]
[null,null,null,null,null,null,null,null,{"$f":"+I29/1000000","v":0},"Tonnes CO2e per year",null,null,{"$f":"+M29/1000000","v":0},"Tonnes CO2e per year"]
[null,null,null,null,null,null,null,null,{"$f":"+I30*12","v":0},"Tonnes CO2e per 12 years",null,null,{"$f":"+M30*12","v":0},"Tonnes CO2e per 12 years"]
[null,null,null,null,null,null,null,null,{"$f":"+I30*15","v":0},"Tonnes CO2e per 15 years",null,null,{"$f":"+M30*15","v":0},"Tonnes CO2e per 15 years"]
[null,null,null,null,null,null,null,null,{"$f":"+I30*D26","v":0},"Carbon price per year",null,null,{"$f":"+M30*D26","v":0},"Carbon price per year"]
[null,null,null,null,null,null,null,null,{"$f":"+I31*D26","v":0},"Carbon price 12 years",null,null,{"$f":"+M31*D26","v":0},"Carbon price 12 years"]
[null,null,null,null,null,null,null,null,{"$f":"+I32*D26","v":0},"Carbon price 15 years",null,null,{"$f":"+M32*D26","v":0},"Carbon price 15 years"]
[]
[null,null,null,null,null,null,"LED 50%",null,{"$f":"+I21*(1-'Data Input and Instructions'!C59)","v":0},"grams CO2e",null,null,{"$f":"+I21-I37","v":0},"grams CO2e"]
[null,null,null,null,null,null,null,null,{"$f":"+I37/1000000","v":0},"Tonnes CO2e per year",null,null,{"$f":"+M37/1000000","v":0},"Tonnes CO2e per year"]
[null,null,null,null,null,null,null,null,{"$f":"+I38*12","v":0},"Tonnes CO2e per 12 years",null,null,{"$f":"+M38*12","v":0},"Tonnes CO2e per 12 years"]
[null,null,null,null,null,null,null,null,{"$f":"+I38*15","v":0},"Tonnes CO2e per 15 years",null,null,{"$f":"+M38*15","v":0},"Tonnes CO2e per 15 years"]
[null,null,null,null,null,null,null,null,{"$f":"+I38*D26","v":0},"Carbon price per year",null,null,{"$f":"+M38*D26","v":0},"Carbon price per year"]
[null,null,null,null,null,null,null,null,{"$f":"+I41*12","v":0},"Carbon price 12 years",null,null,{"$f":"+M39*D26","v":0},"Carbon price 12 years"]
[null,null,null,null,null,null,null,null,{"$f":"+I41*15","v":0},"Carbon price 15 years",null,null,{"$f":"+M40*D26","v":0},"Carbon price 15 years",{"$f":"+M43/325652","v":0}]
[]
[null,null,null,null,null,null,"LED 70%",null,{"$f":"+I21*('Data Input and Instructions'!C60)","v":0},"grams CO2e",null,null,{"$f":"+I21-I45","v":0},"grams CO2e"]
[null,null,null,null,null,null,null,null,{"$f":"+I45/1000000","v":0},"Tonnes CO2e per year",null,null,{"$f":"+M45/1000000","v":0},"Tonnes CO2e per year"]
[null,null,null,null,null,null,null,null,{"$f":"+I46*12","v":0},"Tonnes CO2e per 12years",null,null,{"$f":"+M46*12","v":0},"Tonnes CO2e per 12years"]
[null,null,null,null,null,null,null,null,{"$f":"+I46*15","v":0},"Tonnes CO2e per 15 years",null,null,{"$f":"+M46*15","v":0},"Tonnes CO2e per 15 years"]
[null,null,null,null,null,null,null,null,{"$f":"+I46*D26","v":0},"Carbon price per year",null,null,{"$f":"+M46*D26","v":0},"Carbon price per year"]
[null,null,null,null,null,null,null,null,{"$f":"+I47*D26","v":0},"Carbon price 12 years",null,null,{"$f":"+M47*D26","v":0},"Carbon price 12 years"]
[null,null,null,null,null,null,null,null,{"$f":"+I48*D26","v":0},"Carbon price 15 years",null,null,{"$f":"+M48*D26","v":0},"Carbon price 15 years",{"$f":"+I51/325652","v":0}]

{"sheet":"Assumptions","index":11,"n_rows":57,"n_cols":13,"rows_kept":57,"cut":false,"hidden":true,"merged":[[15,8,15,15],[41,1,41,16],[17,8,17,14],[33,1,33,6],[32,8,32,15],[33,8,33,15],[34,8,34,15],[37,8,37,13],[35,8,35,15],[38,8,38,13],[22,8,22,15],[18,8,18,15],[16,1,16,5],[29,8,29,15],[31,8,31,15],[28,8,28,15],[16,8,16,15],[19,8,19,15],[20,8,20,15],[21,8,21,15],[27,8,27,15],[36,8,36,15],[31,1,31,6],[35,1,35,6],[18,1,18,5],[23,8,23,12],[42,0,42,3],[43,0,43,3],[44,0,44,3],[45,0,45,3],[46,0,46,3],[50,0,50,3],[51,0,51,3],[49,0,49,3],[48,0,48,3],[47,0,47,3],[52,0,52,3],[53,0,53,3],[54,0,54,3],[55,0,55,3],[56,0,56,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"ASSUMPTIONS"]
[]
["ASSETS BUSINESS AS USUAL",null,null,null,null,null,null,null,"ASSETS LED and/or adaptive controls 20%, 50% and 70 %  energy efficiency"]
[null,"·          HPS fixtures average lifetime 15 years, HPS Light bulbs only 4-5 years. ",null,null,null,null,null,null,"·         LED average lifetime is estimated between 15  (without adaptive  controls) and 16 years or more with adaptive controls"]
[null,"·        Business as Usual Scenario does not include capital cost; however, it considers a  cost of replacement of the 5 percent of total intalled fixtures per year ",null,null,null,null,null,null,"·         Prices do not include installation of new poles, general assumption and recommendation is to reuse and adapt existing poles"]
[null,"·         5% of HPS fixtures and 25% of HPS light bulds will be replaced annually. ",null,null,null,null,null,null,"·          Actual unit prices will depend on procurement process, for reference we are using prices provided by LED suppliers and City of Vancouver"]
[null,"·      This busines case does not take into account increasing quantities due to new installations (only repleacements of existing infraestructure)",null,null,null,null,null,null,"·         This business case assumes additional incentive: 10% joint procurement discount. Other grants may be available from various sources, but are not yet included."]
[null,". This busines case considers capital costs of HPS fixtures and HPS light bulbs",null,null,null,null,null,null,"·         LED lights are constantly improving from bluish to warm white while costs are dropping. For this business case there is an estimation of 10 percent price reduction annually in capital, installation and consulting cost"]
[null,null,null,null,null,null,null,null,"·         Prices for adaptative controls are estimated to be 125dols additional to luminarie price"]
[null,null,null,null,null,null,null,null,"·          Costs for installation are estimated at 160 dols per luminarie, independently of the wattage"]
[null,null,null,null,null,null,null,null,"·          Costs for consulting and designing services are estimated at 1% of capital cost, this includes administration fee for procurement services"]
[null,null,null,null,null,null,null,null,"·      This busines case does not take into account increasing quantities due to new installations"]
["FINANCIAL  BUSINESS AS USUAL",null,null,null,null,null,null,null,"FINANCIAL LED and/or adaptive controls 20%, 50% and 70 %  energy efficiency"]
[null,"·         Business case evaluation is 15 years",null,null,null,null,null,null,"·         Business case evaluation is 15 years"]
[null,null,null,null,null,null,null,null,"·         A 2 to 4  percent discount rate is recommended"]
[null,null,null,null,null,null,null,null,"·        Business plan considers a 1 to 5 years implementation period. longer or shorther implementation plans could be considererd"]
[null,null,null,null,null,null,null,null,"·    A discounted ROI calculation method has been used for this business case"]
[null,null,null,null,null,null,null,null,"·    Cost of financing is not being considered in this business case"]
["OPERATION BUSINESS AS USUAL",null,null,null,null,null,null,null,"OPERATION LED and/or adaptive controls 20%, 50% and 70 %  energy efficiency"]
[null,"·         Prices on energy (.03 per watt per month) are estimated to raise 4.125% every year ",null,null,null,null,null,null,"·         Prices on energy (.03 per watt per month) are estimated to raise 4.125% every year "]
[null,"·         Maintance will be required for both, new LED luminaries and existing HPS ",null,null,null,null,null,null,"·         Prices on energy estimate 3 different energy efficiency scenarios: 20%, 50% and 70%  with adaptative controls"]
[null," ·         For HPS, a 10 percent of the total plants is considered to require  reactive maintance (failures and fixture repleacement). Also a 25 percent is estimated for scheduled maintance (this includes cleaning and re-lamping costs (changing HPS light bulbs) ",null,null,null,null,null,null,"·         The estimated potential from LED technology with Adaptive Controls represents a technical potential of ~50 GWh for roadway application and ~17 GWh for general public areas (example parks, pathways etc).  "]
[null,"·         90 percent of HPS spot maintance and group maintance belongs to labour",null,null,null,null,null,null,"·         A 5 percent of the total LED cost is considered for reactive maintance (after guarantee has expired"]
[null,"·    Inflation is 2% affecting costs of maintance",null,null,null,null,null,null,"·         Scheduled maintenance (cleaning)  is required every 7 years"]
[null,null,null,null,null,null,null,null,"·    Inflation is 2% affecting costs of maintance"]
[null,null,null,null,null,null,null,null,"·   10 years guarantee is considered"]
[null,null,null,null,null,null,null,null,"·   A .25% fee over capital cost and installation has been considered to cover for joint procurement services. "]
[]
["OTHER ASSUMPTIONS",null,null,null,null,null,null,null,null,null,null,null,"`"]
[]
[{"$f":"'Data Input and Instructions'!B50","v":"Ballast losses 50 Watts (%)"},null,null,null,{"$f":"'Data Input and Instructions'!C50","v":0.35}]
[{"$f":"'Data Input and Instructions'!B51","v":"Ballast losses 70 Watts (%)"},null,null,null,{"$f":"'Data Input and Instructions'!C51","v":0.3}]
[{"$f":"'Data Input and Instructions'!B52","v":"Ballast losses 100 Watts (%)"},null,null,null,{"$f":"'Data Input and Instructions'!C52","v":0.3}]
[{"$f":"'Data Input and Instructions'!B53","v":"Ballast losses 150 Watts (%)"},null,null,null,{"$f":"'Data Input and Instructions'!C53","v":0.25}]
[{"$f":"'Data Input and Instructions'!B54","v":"Ballast losses 200 Watts (%)"},null,null,null,{"$f":"'Data Input and Instructions'!C54","v":0.2}]
[{"$f":"'Data Input and Instructions'!B55","v":"Ballast losses 250 Watts (%)"},null,null,null,{"$f":"'Data Input and Instructions'!C55","v":0.18}]
[{"$f":"'Data Input and Instructions'!B56","v":"Ballast losses 400 Watts (%)"},null,null,null,{"$f":"'Data Input and Instructions'!C56","v":0.14000000000000001}]
[{"$f":"'Data Input and Instructions'!B57","v":"Ballast losses 1000 Watts (%)"},null,null,null,{"$f":"'Data Input and Instructions'!C57","v":0.11}]
[{"$f":"'Data Input and Instructions'!B59","v":"Estimated energy efficiency of LED without adaptive controls (%)"},null,null,null,{"$f":"'Data Input and Instructions'!C59","v":0.5}]
[{"$f":"'Data Input and Instructions'!B60","v":"Estimated energy efficiency with LED + adaptive controls (%)"},null,null,null,{"$f":"'Data Input and Instructions'!C60","v":0.7}]
[{"$f":"'Data Input and Instructions'!B61","v":"Estimated efficiency with adaptive controls only (%)"},null,null,null,{"$f":"'Data Input and Instructions'!C61","v":0.2}]
[{"$f":"'Data Input and Instructions'!B64","v":"Electricity rate annual increase (%)"},null,null,null,{"$f":"'Data Input and Instructions'!C64","v":4.1250000000000002E-2}]
[{"$f":"'Data Input and Instructions'!B66","v":"Joint procurement discounts (% of total cost)"},null,null,null,{"$f":"'Data Input and Instructions'!C66","v":0}]
[{"$f":"'Data Input and Instructions'!B71","v":"Carbon price ($ Cost of Carbon Neutral Government Program)"},null,null,null,{"$f":"'Data Input and Instructions'!C71","v":25}]
[{"$f":"'Data Input and Instructions'!B72","v":"Carbon price rate annual increase(%)"},null,null,null,{"$f":"'Data Input and Instructions'!C72","v":0}]