{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["User Guide","Introduction","Preliminary","General","Site","Lighting","Results","Ballast Change","Standard Data","Calculations"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":28,"comments":3,"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":"User Guide","index":0,"n_rows":45,"n_cols":1,"rows_kept":45,"cut":false,"hidden":false,"merged":[[11,0,11,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[4,0,4,4],[5,0,5,4],[6,0,6,4],[7,0,7,4],[8,0,8,4],[9,0,9,4],[10,0,10,1],[23,0,23,4],[12,0,12,4],[13,0,13,4],[14,0,14,4],[15,0,15,2],[16,0,16,4],[17,0,17,4],[18,0,18,2],[19,0,19,4],[20,0,20,4],[21,0,21,4],[22,0,22,4],[35,0,35,4],[24,0,24,4],[25,0,25,4],[26,0,26,4],[27,0,27,4],[28,0,28,4],[29,0,29,4],[30,0,30,4],[31,0,31,4],[32,0,32,2],[33,0,33,2],[34,0,34,4],[42,0,42,4],[43,0,43,4],[44,0,44,4],[36,0,36,4],[37,0,37,4],[38,0,38,4],[39,0,39,4],[40,0,40,4],[41,0,41,4]]}
["Welcome to BC Hydro PS Greenhouse Lighting Opportunity Assessment Tool! "]
["This tool helps to find an appropriate path for your future energy-savings greenhouse lighting retrofit or new construction project as well as providing a preliminary assessment of possible energy savings."]
["The tool allows you to enter data and get the assessment results on up to 3 sites. When all necessary data has been entered, the tool will calculate the estimated energy savings for each site and for"]
["the entire project and provide the information which route the project should go to. Please note you can enter data in the white fields only; the light green fields are locked."]
["Attention users of Excel versions 2007 and newer! Macros shall be enabled by allowing the active content for the tool. "]
["Watch a for pop-up massage when you complete the first sheet!"]
["The tool is an Excel workbook which consists of 4 worksheets:"]
["• General (Contact information, number of sites)"]
["• Site Information (Information on types, sizes, locations, and working schedule of each site)"]
["• Lighting (General description of existing lighting system for each site)  "]
["• Results (Outcome) "]
["To complete the tool, please follow the instructions below:"]
["Make sure you have all necessary cells filled in, otherwise \"Missing information!\" warning will appear, disabling the proper calculations."]
["1. In General, fill in general project information in the white fields (refer to the comments). As soon as the necessary information is filled in the next two worksheets will come up."]
["Units: Please select your chosen units for area (sqm or sqft) and light units (Lux or PAR)"]
["2. In Site Information:"]
["Site Name: Please include a name for each greenhouse lighting site/zone"]
["Address: Add the address of the lighting project"]
["City: Your city or region"]
["Existing total lighting area: add your total greenhouse area which currently has lighting"]
["Proposed lighting site area: add your proposed total new lighting area "]
["Existing crop type: select your existing crop"]
["Proposed crop type: select your prosed crop for the new lighting area"]
["Existing annual lighting hours: add your average annual lamp burn hours for the existing lighting area"]
["Proposed annual lighting hours: add your proposed annual lamp burn hours for the new lighting area"]
["Line voltage (V): add your existing electrical line voltage and in Lighting TAB in comments add new line voltage (if any)"]
["Existing crop Illuminance: select your existing crop illumination"]
["Proposed crop Illuminance: select your proposed crop illumination"]
["Luminaire mounting height (ft): select the closes range of mounting heights measured between the top of the crop and the bottom of the lighting fixture"]
["Lighting Function: select the end use function for the new lighting project"]
["Annual energy consumption (kWh): add your total billed annual electrical consumption metered for the lighting total lighting area"]
["Annual amount billed ($): add your total annual electrical charges for the metered area including the lighting areas"]
["3. In Lighting: For each site"]
["Luminaire Replacement"]
["Existing Type: select which type of lighting fixture in your existing lighting area"]
["Existing #: add the number of existing lighting fixtures"]
["Proposed Type: select the proposed new lighting fixture type "]
["Proposed #: add the number of proposed new lighting fixtures"]
["Energy Management Controls Control Scheme"]
["For the Existing (Baseline) and Proposed New Control Scheme: right click on each cell to select Yes or No"]
["Comments - enter your comments (e.g. new line voltage) in this space if you need to add some special information about the existing lighting systems.  "]
["For a multiple sites project the steps in #3 should be repeated for each site."]
["Results Button: Click on Proceed to the results page button to complete the Opportunity Assessment calculations."]
["4. The Results worksheet provides the estimated energy savings for each site and for the entire project broken out into the electrical savings from controls and from energy efficient luminaires."]
["BCH-QMS-9462-C-093-Greenhouse LOA-Rev000"]

{"sheet":"Introduction","index":1,"n_rows":27,"n_cols":15,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,null,null,"Welcome to the BC Hydro Power Smart Greenhouse Lighting Opportunity Assessment"]
[]
[null,null,null,null,null,null,null,"To begin, please choose an option below:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Note: If your project has both retrofit and new lighting, please complete two separate assessments."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BCH-QMS-9462-C-093-Greenhouse LOA-Rev000"]

{"sheet":"Preliminary","index":2,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":true,"merged":[[22,1,22,3],[12,4,12,6],[13,4,13,6],[14,4,14,6],[17,4,17,10]]}
[]
[null,"Greenhouse Opportunity Assessment"]
[null,"BCH-QMS-9462-C-093-Greenhouse LOA-Rev000"]
[null,"Retrofit Preliminary Test",null,null,null,null,"Ballast Acronyms"]
[]
[null,"Demand Reduction"]
[null,"Existing Baseline",null,null,null,null,"New Proposed"]
[null,"Luminaire","Luminaire","Luminaire","Existing Annual ","Annual ","Luminaire","Luminaire","Luminaire","Annual ","Annual "]
[null,"Description","Watts","Quantity","Lit Hours","Energy kWh/yr","Description","Watts","Quantity","Lit Hours","Energy kWh/yr"]
[null,null,{"$f":"IFERROR(VLOOKUP(B10,HID_Data1,3,FALSE),0)","v":0},null,null,{"$f":"C10*D10*E10/1000","v":0},null,{"$f":"IFERROR(VLOOKUP(G10,HID_Data1,3,FALSE),0)","v":0},null,null,{"$f":"H10*I10*E10/1000","v":0}]
[]
[null,"Lighting Controls"]
[null,"Project Has Lighting Controls?"]
[null,"Control Type"]
[null,"New Proposed Annual Hours"]
[]
[]
[null,"Result",null,null,{"$f":"Calculations!K3&Calculations!L3","v":"PROJECT DOES NOT APPEAR INCENTABLE: PROJECT MUST HAVE DEMAND REDUCTION; CONTROL SCHEME INELIGIBLE FOR INCENTIVE"}]

{"sheet":"General","index":3,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":true,"merged":[[23,1,23,2],[3,1,3,2]]}
[]
[null,"Greenhouse Opportunity Assessment"]
[null,"BCH-QMS-9462-C-093-Greenhouse LOA-Rev000"]
[null,"General Information"]
[]
[null,"Project Information"]
[null,"Project Type",null,{"$f":"IF(C7=\"\",\"*\",\"\")","v":"*"},{"$f":"IF(D7=\"*\",0,1)","v":0}]
[null,"Customer",null,{"$f":"IF(C8=\"\",\"*\",\"\")","v":"*"},{"$f":"IF(D8=\"*\",0,1)","v":0}]
[null,"Contact Name",null,{"$f":"IF(C9=\"\",\"*\",\"\")","v":"*"},{"$f":"IF(D9=\"*\",0,1)","v":0}]
[null,"Contact Phone",null,{"$f":"IF(C10=\"\",\"*\",\"\")","v":"*"},{"$f":"IF(D10=\"*\",0,1)","v":0}]
[null,"Number of Sites (max. 3)",null,{"$f":"IF(C11=\"\",\"*\",\"\")","v":"*"},{"$f":"IF(D11=\"*\",0,1)","v":0}]
[null,null,null,null,0,"always 0"]
[null,"Information Collected By",null,null,0,"always 0"]
[null,"Company Name",null,{"$f":"IF(C14=\"\",\"*\",\"\")","v":"*"},{"$f":"IF(D14=\"*\",0,1)","v":0}]
[null,"Contact Name",null,{"$f":"IF(C15=\"\",\"*\",\"\")","v":"*"},{"$f":"IF(D15=\"*\",0,1)","v":0}]
[null,"Contact Phone",null,{"$f":"IF(C16=\"\",\"*\",\"\")","v":"*"},{"$f":"IF(D16=\"*\",0,1)","v":0}]
[null,null,null,null,0,"always 0"]
[null,"Date (YYYY-MM-DD):",null,{"$f":"IF(C18=\"\",\"*\",\"\")","v":"*"},{"$f":"IF(D18=\"*\",0,1)","v":0}]
[null,null,null,null,0,"always 0"]
[null,"Units of Measurement",null,null,0]
[null,"Area",null,{"$f":"IF(C21=\"\",\"*\",\"\")","v":"*"},{"$f":"IF(D21=\"*\",0,1)","v":0}]
[null,"Illuminance",null,{"$f":"IF(C22=\"\",\"*\",\"\")","v":"*"},{"$f":"IF(D22=\"*\",0,1)","v":0}]
[]
[null,{"$f":"IF(SUM(E7:E22)<>11,\"* MISSING INFO\",\"\")","v":"* MISSING INFO"}]

{"sheet":"Site","index":4,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Greenhouse Lighting OA"]
[null,"BCH-QMS-9462-C-093-Greenhouse LOA-Rev000"]
[null,"Site Information"]
[]
[null,null,1,null,2,null,3,null,null,"Site 1","Site 2","Site 3"]
[null,"Site Name",null,{"$f":"IF(C7=\"\",\"*\",\"\")","v":"*"},null,{"$f":"IF(E7=\"\",\"*\",\"\")","v":"*"},null,{"$f":"IF(G7=\"\",\"*\",\"\")","v":"*"},null,{"$f":"IF(C7=\"\",0,1)","v":0},{"$f":"IF(E7=\"\",0,1)","v":0},{"$f":"IF(G7=\"\",0,1)","v":0}]
[null,"Address",null,null,null,null,null,null,null,0,0,0,"always 0"]
[null,"City",null,null,null,null,null,null,null,0,0,0,"always 0"]
[null,{"$f":"IF(Proj_Area_Units=\"sqm\", \"Existing total lighting area (sqm)\",\"Existing total lighting area (sqft)\")","v":"Existing total lighting area (sqft)"},null,{"$f":"IF(C10=\"\",\"*\",\"\")","v":"*"},null,{"$f":"IF(E10=\"\",\"*\",\"\")","v":"*"},null,{"$f":"IF(G10=\"\",\"*\",\"\")","v":"*"},null,{"$f":"IF(C10=\"\",0,1)","v":0},{"$f":"IF(E10=\"\",0,1)","v":0},{"$f":"IF(G10=\"\",0,1)","v":0}]
[null,{"$f":"IF(Proj_Area_Units=\"sqm\", \"Proposed lighting site area (sqm)\",\"Proposed lighting site area (sqft)\")","v":"Proposed lighting site area (sqft)"},null,"*",null,"*",null,"*",null,{"$f":"IF(C11=\"\",0,1)","v":0},{"$f":"IF(E11=\"\",0,1)","v":0},{"$f":"IF(G11=\"\",0,1)","v":0}]
[null,"Existing crop type",null,"*",null,"*",null,"*",null,0,0,0]
[null,"Proposed crop type",null,"*",null,"*",null,"*",null,0,0,0]
[null,{"$f":"IF('Standard Data'!H31=FALSE,\"Annual lighting hours\",IF(OR(Proj_Type=\"New greenhouse\",Proj_Type=\"Lighting in previously unlit area\"),\"Annual lighting hours (without controls)\",\"Existing annual lighting hours\"))","v":"Annual lighting hours"},null,"*",null,"*",null,"*",null,0,0,0]
[null,{"$f":"IF(OR(Proj_Type=\"New greenhouse\",Proj_Type=\"Lighting in previously unlit area\"),\"Annual lighting hours (with controls)\",\"Proposed annual lighting hours\")","v":"Proposed annual lighting hours"},null,"*",null,"*",null,"*",null,0,0,0]
[null,"Line voltage (V)",null,"*",null,"*",null,"*",null,0,0,0]
[null,{"$f":"IF(Proj_Illum_Units=\"Lux\",\"Existing crop illuminance (lux)\", \"Existing crop illuminance (PAR)\")","v":"Existing crop illuminance (PAR)"},null,"*",null,"*",null,"*",null,0,0,0]
[null,{"$f":"IF(Proj_Illum_Units=\"Lux\",\"Virtual baseline illuminance (lux) [calc]\", \"Virtual baseline illuminance (PAR) [calc]\")","v":"Virtual baseline illuminance (PAR) [calc]"},{"$f":"IFERROR(IF(Proj_Illum_Units=\"PAR\",Calculations!$I$28*(13/1000),Calculations!$I$28),\"\")","v":""},null,{"$f":"IFERROR(IF(Proj_Illum_Units=\"PAR\",Calculations!$I$61*(13/1000),Calculations!$I$61),\"\")","v":""},null,{"$f":"IFERROR(IF(Proj_Illum_Units=\"PAR\",Calculations!$I$94*(13/1000),Calculations!$I$94),\"\")","v":""},null,null,0,0,0,"always 0"]
[null,{"$f":"IF(Proj_Illum_Units=\"Lux\",IF(Proj_Type=\"Lighting retrofit (same illuminance)\",\"Crop illuminance (lux)\",\"Proposed crop illuminance (lux)\"),IF(Proj_Type=\"Lighting retrofit (same illuminance)\",\"Crop illuminance (PAR)\",\"Proposed crop illuminance (PAR)\"))","v":"Proposed crop illuminance (PAR)"},null,{"$f":"IF(C19=\"\",\"*\",\"\")","v":"*"},null,{"$f":"IF(E19=\"\",\"*\",\"\")","v":"*"},null,{"$f":"IF(G19=\"\",\"*\",\"\")","v":"*"},null,0,0,0]
[null,"Luminaire mounting height (ft)",null,{"$f":"IF(C20=\"\",\"*\",\"\")","v":"*"},null,{"$f":"IF(E20=\"\",\"*\",\"\")","v":"*"},null,{"$f":"IF(G20=\"\",\"*\",\"\")","v":"*"},null,0,0,0]
[null,"Lighting Function",null,{"$f":"IF(C21=\"\",\"*\",\"\")","v":"*"},null,{"$f":"IF(E21=\"\",\"*\",\"\")","v":"*"},null,{"$f":"IF(G21=\"\",\"*\",\"\")","v":"*"},null,0,0,0]
[null,"Annual energy consumption (kWh)",null,null,null,null,null,null,null,0,0,0,"always 0"]
[null,"Annual amount billed ($)",null,null,null,null,null,null,null,0,0,0,"always 0"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J7:J23)","v":0},{"$f":"SUM(K7:K23)","v":0},{"$f":"SUM(L7:L23)","v":0},"SUMS"]
[null,{"$f":"IF(SUM(J24:L24)=SUM(J25:L25),\"\",\"* MISSING REQUIRED INFO\")","v":"* MISSING REQUIRED INFO"},null,null,null,null,null,null,null,{"$f":"IF(Proj_Type=\"Lighting retrofit (same illuminance)\",10,IF(OR(Proj_Type=\"Lighting in previously unlit area\",Proj_Type=\"New greenhouse\"),9,12))","v":12},{"$f":"IF(Proj_Num_Sites<2,0,IF(Proj_Type=\"Lighting retrofit (same illuminance)\",10,IF(OR(Proj_Type=\"Lighting in previously unlit area\",Proj_Type=\"New greenhouse\"),9,12)))","v":0},{"$f":"IF(Proj_Num_Sites<3,0,IF(Proj_Type=\"Lighting retrofit (same illuminance)\",10,IF(OR(Proj_Type=\"Lighting in previously unlit area\",Proj_Type=\"New greenhouse\"),9,12)))","v":0},"REQ SUMS"]

{"sheet":"Lighting","index":5,"n_rows":25,"n_cols":16,"rows_kept":25,"cut":false,"hidden":true,"merged":[[24,6,26,6],[24,11,26,11],[24,1,26,1],[21,2,21,4]]}
[]
[null,"Greenhouse Lighting OA"]
[null,"BCH-QMS-9462-C-093-Greenhouse LOA-Rev000"]
[null,"Lighting Information"]
[]
[null,"Luminaire Replacement"]
[null,"Site 1 :",{"$f":"IF(Site!C7=\"\",\"\",Site!C7)","v":""},null,null,null,"Site 2 :",{"$f":"IF(Site!E7=\"\",\"\",Site!E7)","v":""},null,null,null,"Site 3:",{"$f":"IF(Site!G7=\"\",\"\",Site!G7)","v":""}]
[null,"Existing Luminaire Type","Existing Luminaire Quantity","Proposed Luminaire Type","Proposed Luminaire Quantity",null,"Existing Luminaire Type","Existing Luminaire Quantity","Proposed Luminaire Type","Proposed Luminaire Quantity",null,"Existing Luminaire Type","Existing Luminaire Quantity","Proposed Luminaire Type","Proposed Luminaire Quantity"]
[null,null,null,null,null,{"$f":"IF(OR(B9=\"\",C9=\"\",D9=\"\",E9=\"\"),\"*\",\"\")","v":"*"},null,null,null,null,{"$f":"IF(OR(G9=\"\",H9=\"\",I9=\"\",J9=\"\"),\"*\",\"\")","v":"*"},null,null,null,null,{"$f":"IF(OR(L9=\"\",M9=\"\",N9=\"\",O9=\"\"),\"*\",\"\")","v":"*"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(F9=\"*\",\"*MISSING REQUIRED INFO\",\"\")","v":"*MISSING REQUIRED INFO"},null,"Ballast Acronyms",null,null,{"$f":"IF(K9=\"*\",\"*MISSING REQUIRED INFO\",\"\")","v":"*MISSING REQUIRED INFO"},null,null,null,null,{"$f":"IF(P9=\"*\",\"*MISSING REQUIRED INFO\",\"\")","v":"*MISSING REQUIRED INFO"}]
[null,null,null,"[mouseover to see acronyms]"]
[null,"Lighting Controls"]
[null,"Control Type"]
[]
[]
[null,"Comments:",null,null,null,null,"Comments:",null,null,null,null,"Comments:"]

{"sheet":"Results","index":6,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":true,"merged":[[11,1,11,2]]}
[]
[null,"Greenhouse Lighting Opportunity Assessment"]
[null,"BCH-QMS-9462-C-093-Greenhouse LOA-Rev000"]
[null,"Assessment Results - Potentially Incentable Savings"]
[null,null,null,null,{"$f":"IF(Proj_Type=\"Lighting Retrofit (same illuminance)\",\"Values relative to existing levels\",\"Values relative to PSE-calculated virtual baseline\")","v":"Values relative to PSE-calculated virtual baseline"}]
[null,"Site Name","Proposed Luminaire Savings (kWh/yr)","Proposed Controls Savings (kWh/yr)","Total Proposed Savings (kWh/yr)","Calculated illuminance matches with proposed levels?"]
[1,{"$f":"IF(Site!C7=\"\",\"\",Site!C7)","v":""},{"$f":"IF(ISNUMBER(Calculations!F35),-Calculations!F35,\"MISSING INFO!\")","v":0},{"$f":"IF(ISNUMBER(Calculations!H35),-Calculations!H35,\"MISSING INFO!\")","v":0},{"$f":"C7+D7","v":0},{"$f":"IFERROR(IF(ABS((Calculations!$N$25-Calculations!$O$25)/Calculations!$N$25)<0.1,\"YES\",\">10% difference between baseline and calculated\"),\"N/A\")","v":"N/A"},{"$f":"IFERROR(IF(ABS((Calculations!$Q$25-Calculations!$R$25)/Calculations!$Q$25)<0.1,\"YES\",\">10% difference between proposed and calculated\"),\"N/A\")","v":"N/A"}]
[2,{"$f":"IF(Site!E7=\"\",\"\",Site!E7)","v":""},{"$f":"IF(ISNUMBER(Calculations!F68),-Calculations!F68,\"MISSING INFO!\")","v":0},{"$f":"IF(ISNUMBER(Calculations!H68),-Calculations!H68,\"MISSING INFO!\")","v":0},{"$f":"C8+D8","v":0},{"$f":"IFERROR(IF(ABS((Calculations!$N$58-Calculations!$O$58)/Calculations!$N$58)<0.1,\"YES\",\">10% difference between baseline and calculated\"),\"N/A\")","v":"N/A"},{"$f":"IFERROR(IF(ABS((Calculations!$Q$58-Calculations!$R$58)/Calculations!$Q$58)<0.1,\"YES\",\">10% difference between proposed and calculated\"),\"N/A\")","v":"N/A"}]
[3,{"$f":"IF(Site!G7=\"\",\"\",Site!G7)","v":""},{"$f":"IF(ISNUMBER(Calculations!F101),-Calculations!F101,\"MISSING INFO!\")","v":0},{"$f":"IF(ISNUMBER(Calculations!H101),-Calculations!H101,\"MISSING INFO!\")","v":0},{"$f":"C9+D9","v":0},{"$f":"IFERROR(IF(ABS((Calculations!$N$91-Calculations!$O$91)/Calculations!$N$91)<0.1,\"YES\",\">10% difference between baseline and calculated\"),\"N/A\")","v":"N/A"},{"$f":"IFERROR(IF(ABS((Calculations!$Q$91-Calculations!$R$91)/Calculations!$Q$91)<0.1,\"YES\",\">10% difference between proposed and calculated\"),\"N/A\")","v":"N/A"}]
[null,"Total",{"$f":"SUM(C7:C9)","v":0},{"$f":"SUM(D7:D9)","v":0},{"$f":"SUM(E7:E9)","v":0}]
[null,null,null,null,"Negative values signify increased energy consumption"]

{"sheet":"Ballast Change","index":7,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":true,"merged":[[3,1,3,2],[24,1,24,2]]}
[]
[null,"Greenhouse Opportunity Assessment"]
[null,"BCH-QMS-9462-C-093-Greenhouse LOA-Rev000"]
[null,"Simple Ballast Change"]
[]
[null,"Luminaire Quantity"]
[null,"Lamp Wattage",null,{"$f":"IF(C7=\"600W\",20,IF(C7=\"750W\",45,IF(C7=\"1000W\",68,\"\")))","v":""}]
[null,"Existing Ballast Type"]
[null,"Proposed Ballast Type"]
[null,"Annual Lighting Hours"]
[]
[null,"Energy Savings (kWh/yr)",{"$f":"IFERROR(IF(D7*C6*C10/1000=0,\"\",D7*C6*C10/1000),\"\")","v":""}]

{"sheet":"Standard Data","index":8,"n_rows":42,"n_cols":27,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
["Greenhouse HIDs 1","Nominal W","Input W","Degraded Mean Output lm","Degraded Mean Output µmols","#Sites","Control Types","Crop Types","Baseline (No Lighting) Data",null,null,null,null,"Proj Types","Yes/No","Length Units","Area Units","Illuminance Units","Standard Illuminance Levels",null,"Illuminance","Line Voltages","Lighting Functions","Ballast Types","Lamp Wattages","Start BT","Control Types"]
["No Lighting",0,{"$f":"IF(Site!$C$20=\"\",\"MISS INFO\",VLOOKUP(Site!$C$20,No_Light_Data,2,FALSE))","v":"MISS INFO"},{"$f":"IF(OR(Site!$C$20=\"\"),\"MISS INFO\",VLOOKUP(Site!$C$20,No_Light_Data,3,FALSE))","v":"MISS INFO"},{"$f":"IF(OR(Site!$C$20=\"\"),\"MISS INFO\",VLOOKUP(Site!$C$20,No_Light_Data,4,FALSE))","v":"MISS INFO"},1,"Manual On/Off","Tomatoes","Eq. HID","Height","Equiv W","Equiv lm","µmols",{"$f":"IF(H29=\"Retrofit\",\"Lighting Retrofit (same illuminance)\",IF(H29=\"New\",\"New Greenhouse\",\"ERROR\"))","v":"Lighting Retrofit (same illuminance)"},"Yes","m","sqm","Lux","µmol (PAR)","lx",{"$f":"IF(Proj_Illum_Units=\"Lux\",T3,S3)","v":13.2},120,"Propagation","Single-Coil Reactor","600W","Constant-Wattage","Manual controls"]
["UNUSED",0,{"$f":"IF(Site!$C$20=\"\",\"MISS INFO\",VLOOKUP(Site!$C$20,No_Light_Data,2,FALSE))","v":"MISS INFO"},{"$f":"IF(OR(Site!$C$20=\"\"),\"MISS INFO\",VLOOKUP(Site!$C$20,No_Light_Data,3,FALSE))","v":"MISS INFO"},{"$f":"IF(OR(Site!$C$20=\"\"),\"MISS INFO\",VLOOKUP(Site!$C$20,No_Light_Data,4,FALSE))","v":"MISS INFO"},2,"Photosensor: On/Off","Cucumbers","600W.CWA","0 to 4",665,77000,990,{"$f":"IF(H29=\"Retrofit\",\"Lighting Retrofit (increased illuminance)\",IF(H29=\"New\",\"Lighting in previously unlit area\",\"ERROR\"))","v":"Lighting Retrofit (increased illuminance)"},"No","ft","sqft","PAR",13.2,1000,26.4,208,"Production","Electronic","750W",null,"Photosensor with Computer Control"]
["400W.HPS.CWA",400,455,50000,645,3,"Photosensor: 50%-50% On/Off","Sweet Peppers","600W.CWA","4 to 8",665,77000,990,null,null,null,null,null,26.4,2000,39.6,240,"Production & Photoperiod",null,"1000W",null,"Photosensor with Computer Hardwired Zone Control"]
["600W.HPS.CWA",600,665,77000,990,null,"Photosensor: 25%-50%-75% On/Off","Hot Peppers","750W.CWA","6 to 10",840,93000,1200,null,null,null,null,null,39.6,3000,52.8,347]
["750W.HPS.CWA",750,830,93000,1200,null,"Photosensor: Dimming","Bedding Plants","1,000W.CWA","8 to 12",1100,121000,1665,null,null,null,null,null,52.8,4000,66,400]
["1000W.HPS.CWA",1000,1100,121000,1665,null,"Programming/Scheduling","Potted Flowers",null,null,null,null,null,null,null,null,null,null,66,5000,79.2,480]
["600W.HPS.SRB",600,645,80000,1030,null,null,"Potted Foliage",null,null,null,null,null,null,null,null,null,null,79.2,6000,92.4]
["750W.HPS.SRB",750,795,94000,1250,null,null,"Gerbera",null,null,null,null,null,null,null,null,null,null,92.4,7000,105.6]
["600W.HPS.EI",600,645,80000,1030,null,null,"Roses",null,null,null,null,null,null,null,null,null,null,105.6,8000,118.8]
["750W.HPS.EI",750,771,95000,1255,null,null,"Alstroemeria",null,null,null,null,null,null,null,null,null,null,118.8,9000,132]
["1000W.HPS.EI",1000,1032,126000,1720,null,null,"Lilies",null,null,null,null,null,null,null,null,null,null,132,10000,145.19999999999999]
[" ",0,0,0,0,null,null,"Iris",null,null,null,null,null,null,null,null,null,null,145.19999999999999,11000,158.4]
["empty row at bottom is for unused rows in Lighting sheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,158.4,12000,171.6]
["Greenhouse HIDs 2","Nominal W","Input W","Degraded Mean Output lm","Degraded Mean Output µmols",null,null,null,null,null,null,null,null,null,null,null,null,null,171.6,13000,184.8]
["No Lighting",0,{"$f":"IF(OR(Site!$E$20=\"\"),\"MISS INFO\",VLOOKUP(Site!$E$20,No_Light_Data,2,FALSE))","v":"MISS INFO"},{"$f":"IF(OR(Site!$E$20=\"\"),\"MISS INFO\",VLOOKUP(Site!$E$20,No_Light_Data,3,FALSE))","v":"MISS INFO"},{"$f":"IF(OR(Site!$E$20=\"\"),\"MISS INFO\",VLOOKUP(Site!$E$20,No_Light_Data,4,FALSE))","v":"MISS INFO"},null,"Existing HID List","New HID List",null,null,null,null,null,null,null,null,null,null,184.8,14000,198]
["UNUSED",0,{"$f":"IF(OR(Site!$E$20=\"\"),\"MISS INFO\",VLOOKUP(Site!$E$20,No_Light_Data,2,FALSE))","v":"MISS INFO"},{"$f":"IF(OR(Site!$E$20=\"\"),\"MISS INFO\",VLOOKUP(Site!$E$20,No_Light_Data,3,FALSE))","v":"MISS INFO"},{"$f":"IF(OR(Site!$E$20=\"\"),\"MISS INFO\",VLOOKUP(Site!$E$20,No_Light_Data,4,FALSE))","v":"MISS INFO"},null,{"$f":"IF(OR(Proj_Type=\"Lighting Retrofit (same illuminance)\",Proj_Type=\"Lighting Retrofit (increased illuminance)\"),A4,$A$2)","v":"No Lighting"},"400W.HPS.CWA",null,null,null,null,null,null,null,null,null,null,198,15000,211.2]
["400W.HPS.CWA",400,455,50000,645,null,"No Lighting","600W.HPS.CWA",null,null,null,null,null,null,null,null,null,null,211.2,16000,224.4]
["600W.HPS.CWA",600,665,77000,990,null,"No Lighting","750W.HPS.CWA",null,null,null,null,null,null,null,null,null,null,224.4,17000,237.6]
["750W.HPS.CWA",750,830,93000,1200,null,"No Lighting","1000W.HPS.CWA",null,null,null,null,null,null,null,null,null,null,237.6,18000,250.8]
["1000W.HPS.CWA",1000,1100,121000,1665,null,"No Lighting","600W.HPS.SRB",null,null,null,null,null,null,null,null,null,null,250.8,19000,264]
["600W.HPS.SRB",600,645,80000,1030,null,"No Lighting","750W.HPS.SRB",null,null,null,null,null,null,null,null,null,null,264,20000,290.39999999999998]
["750W.HPS.SRB",750,795,94000,1250,null,"No Lighting","600W.HPS.EI",null,null,null,null,null,null,null,null,null,null,290.39999999999998,22000]
["600W.HPS.EI",600,645,80000,1030,null,"No Lighting","750W.HPS.EI"]
["750W.HPS.EI",770,771,95000,1255,null,"No Lighting","1000W.HPS.EI"]
["1000W.HPS.EI",1000,1032,126000,1720]
[" ",0,0,0,0]
["empty row at bottom is for unused rows in Lighting sheet"]
["Greenhouse HIDs 3","Nominal W","Input W","Degraded Mean Output lm","Degraded Mean Output µmols",null,"Active Project Type","Retrofit"]
["No Lighting",0,{"$f":"IF(OR(Site!$G$20=\"\"),\"MISS INFO\",VLOOKUP(Site!$G$20,No_Light_Data,2,FALSE))","v":"MISS INFO"},{"$f":"IF(OR(Site!$G$20=\"\"),\"MISS INFO\",VLOOKUP(Site!$G$20,No_Light_Data,3,FALSE))","v":"MISS INFO"},{"$f":"IF(OR(Site!$G$20=\"\"),\"MISS INFO\",VLOOKUP(Site!$G$20,No_Light_Data,4,FALSE))","v":"MISS INFO"}]
["UNUSED",0,{"$f":"IF(OR(Site!$G$20=\"\"),\"MISS INFO\",VLOOKUP(Site!$G$20,No_Light_Data,2,FALSE))","v":"MISS INFO"},{"$f":"IF(OR(Site!$G$20=\"\"),\"MISS INFO\",VLOOKUP(Site!$G$20,No_Light_Data,3,FALSE))","v":"MISS INFO"},{"$f":"IF(OR(Site!$G$20=\"\"),\"MISS INFO\",VLOOKUP(Site!$G$20,No_Light_Data,4,FALSE))","v":"MISS INFO"},null,"Incented Controls?",{"$f":"IF(H29=\"Retrofit\",AND(Calculations!G3,Calculations!I3),IF(H29=\"New\",Lighting!C22='Standard Data'!AA4,\"NO PROJECT TYPE\"))","v":false}]
["400W.HPS.CWA",400,455,50000,645]
["600W.HPS.CWA",600,665,77000,990]
["750W.HPS.CWA",750,830,93000,1200]
["1000W.HPS.CWA",1000,1100,121000,1665]
["600W.HPS.SRB",600,645,80000,1030]
["750W.HPS.SRB",750,795,94000,1250]
["600W.HPS.EI",600,645,80000,1030]
["750W.HPS.EI",750,771,95000,1255]
["1000W.HPS.EI",1000,1032,126000,1720]
[" ",0,0,0,0]
["empty row at bottom is for unused rows in Lighting sheet"]

{"sheet":"Calculations","index":9,"n_rows":101,"n_cols":20,"rows_kept":101,"cut":false,"hidden":true,"merged":[[92,6,92,7],[89,9,89,10],[90,9,90,10],[91,9,91,10],[88,6,88,8],[89,6,89,7],[90,6,90,7],[91,6,91,7],[22,6,22,8],[23,6,23,7],[24,6,24,7],[25,6,25,7],[26,6,26,7],[28,9,28,10],[29,9,29,10],[30,9,30,10],[31,9,31,10],[23,9,23,10],[24,9,24,10],[25,9,25,10],[26,9,26,10],[27,9,27,10],[97,1,97,2],[98,1,98,2],[99,1,99,2],[100,1,100,2],[92,1,92,2],[93,1,93,2],[94,1,94,2],[95,1,95,2],[96,1,96,2],[66,1,66,2],[67,1,67,2],[89,1,89,2],[90,1,90,2],[91,1,91,2],[61,1,61,2],[62,1,62,2],[63,1,63,2],[64,1,64,2],[65,1,65,2],[56,1,56,2],[57,1,57,2],[58,1,58,2],[59,1,59,2],[60,1,60,2],[34,1,34,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[59,6,59,7],[56,9,56,10],[57,9,57,10],[58,9,58,10],[55,6,55,8],[56,6,56,7],[57,6,57,7],[58,6,58,7]]}
[null,"This color means: VALUE COPIED FROM INFO",null,null,null,"Compliance:"]
[null,"This color means: VALUE CALCULATED FROM INFO",null,null,null,"Passes A","Passes B","Passes C","Passes D",null,"Compliance Result","Failure Reason"]
[null,"This color means: TOTALLED VALUE",null,null,null,{"$f":"(Preliminary!F10>Preliminary!K10)","v":false},{"$f":"Preliminary!E13=\"Yes\"","v":false},{"$f":"Preliminary!F10>(Preliminary!H10*Preliminary!I10*Preliminary!E15/1000)","v":false},{"$f":"Preliminary!E14='Standard Data'!AA4","v":false},null,{"$f":"IF(F3,\"PROJECT POTENTIALLY INCENTABLE\",\"PROJECT DOES NOT APPEAR INCENTABLE: \")","v":"PROJECT DOES NOT APPEAR INCENTABLE: "},{"$f":"IF(F3=FALSE,\"PROJECT MUST HAVE DEMAND REDUCTION\",\"\")&IF(OR(AND(G3,I3=FALSE),G3=FALSE),\"; CONTROL SCHEME INELIGIBLE FOR INCENTIVE\",\"\")&IF(AND(H3=FALSE,F3),\"PROJECT MUST HAVE FINAL ENERGY SAVINGS\",\"\")","v":"PROJECT MUST HAVE DEMAND REDUCTION; CONTROL SCHEME INELIGIBLE FOR INCENTIVE"}]
[]
[]
[]
[]
[null,"Site 1"]
[null,null,null,null,"single","single","total","total","total",null,null,null,null,"single","single","total","total","total"]
[null,"Existing Luminaire","# of Existing Luminaires","Existing Annual Hrs","Existing Input W Per Luminaire","Existing Lm per Luminaire","Existing Total Input W","Existing Total Lm","Existing Total kWh/yr",null,"Proposed Luminaire","# of Proposed Luminaires","Proposed Annual Hrs","Proposed Input W Per Luminaire","Proposed Lm per Luminaire","Proposed Total Input W","Proposed Total Lm","Proposed Total kWh/yr",null,"exist lumens"]
[null,{"$f":"IF(Lighting!B$9=\"\",\" \",IF(Proj_Type=\"Lighting Retrofit (increased illuminance)\",\"UNUSED\",Lighting!B$9))","v":" "},{"$f":"IF(K11=\" \",0,IF(Proj_Type=\"Lighting Retrofit (same illuminance)\",IF(Lighting!C9=\"\",0,Lighting!C9),IF(OR(B11=\"No Lighting\",B11=\"UNUSED\"),IF(ISNUMBER($I$27),$I$27,0),0)))","v":0},{"$f":"IF(OR(K11=\" \",B11=\" \"),0,Site!$C$14)","v":0},{"$f":"IF(K11=\" \",0,VLOOKUP(B11,HID_Data1,3,FALSE))","v":0},{"$f":"IF(K11=\" \",0,VLOOKUP(B11,HID_Data1,4,FALSE))","v":0},{"$f":"IFERROR(C11*E11,\"MISS INFO\")","v":0},{"$f":"IFERROR(C11*F11,\"MISS INFO\")","v":0},{"$f":"IFERROR(D11*G11/1000,\"MISS INFO\")","v":0},null,{"$f":"IF(Lighting!D9=\"\",\" \",Lighting!D9)","v":" "},{"$f":"IF(Lighting!E9=\"\",0,Lighting!E9)","v":0},{"$f":"IF(K11=\" \",0,Site!$C$15)","v":0},{"$f":"VLOOKUP(K11,HID_Data1,3,FALSE)","v":0},{"$f":"VLOOKUP(K11,HID_Data1,4,FALSE)","v":0},{"$f":"IFERROR(L11*N11,\"MISS INFO\")","v":0},{"$f":"IFERROR(L11*O11,\"MISS INFO\")","v":0},{"$f":"IFERROR(M11*P11/1000,\"MISS INFO\")","v":0},null,{"$f":"IF(Lighting!B$9=\"\",0,VLOOKUP(Lighting!B$9,HID_Data1,4,FALSE)*Lighting!C$9)","v":0}]
[null,{"$f":"IF(Lighting!B$10=\"\",\" \",IF(Proj_Type=\"Lighting Retrofit (increased illuminance)\",\"UNUSED\",Lighting!B$10))","v":" "},{"$f":"IF(K12=\" \",0,IF(Proj_Type=\"Lighting Retrofit (same illuminance)\",IF(Lighting!C10=\"\",0,Lighting!C10),IF(OR(B12=\"No Lighting\",B12=\"UNUSED\"),IF(ISNUMBER($I$27),$I$27,0),0)))","v":0},{"$f":"IF(OR(K12=\" \",B12=\" \"),0,Site!$C$15)","v":0},{"$f":"IF(K12=\" \",0,VLOOKUP(B12,HID_Data1,3,FALSE))","v":0},0,{"$f":"IFERROR(C12*E12,\"MISS INFO\")","v":0},{"$f":"IFERROR(C12*F12,\"MISS INFO\")","v":0},{"$f":"IFERROR(D12*G12/1000,\"MISS INFO\")","v":0},null,{"$f":"IF(Lighting!D10=\"\",\" \",Lighting!D10)","v":" "},{"$f":"IF(Lighting!E10=\"\",0,Lighting!E10)","v":0},{"$f":"IF(K12=\" \",0,Site!$C$15)","v":0},0,0,{"$f":"IFERROR(L12*N12,\"MISS INFO\")","v":0},{"$f":"IFERROR(L12*O12,\"MISS INFO\")","v":0},{"$f":"IFERROR(M12*P12/1000,\"MISS INFO\")","v":0},null,{"$f":"IF(Lighting!B$10=\"\",0,VLOOKUP(Lighting!B$10,HID_Data1,4,FALSE)*Lighting!C$10)","v":0}]
[null,{"$f":"IF(Lighting!B$11=\"\",\" \",IF(Proj_Type=\"Lighting Retrofit (increased illuminance)\",\"UNUSED\",Lighting!B$11))","v":" "},{"$f":"IF(K13=\" \",0,IF(Proj_Type=\"Lighting Retrofit (same illuminance)\",IF(Lighting!C11=\"\",0,Lighting!C11),IF(OR(B13=\"No Lighting\",B13=\"UNUSED\"),IF(ISNUMBER($I$27),$I$27,0),0)))","v":0},{"$f":"IF(OR(K13=\" \",B13=\" \"),0,Site!$C$16)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!D11=\"\",\" \",Lighting!D11)","v":" "},{"$f":"IF(Lighting!E11=\"\",0,Lighting!E11)","v":0},{"$f":"IF(K13=\" \",0,Site!$C$15)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!B$11=\"\",0,VLOOKUP(Lighting!B$11,HID_Data1,4,FALSE)*Lighting!C$11)","v":0}]
[null,{"$f":"IF(Lighting!B$12=\"\",\" \",IF(Proj_Type=\"Lighting Retrofit (increased illuminance)\",\"UNUSED\",Lighting!B$12))","v":" "},{"$f":"IF(K14=\" \",0,IF(Proj_Type=\"Lighting Retrofit (same illuminance)\",IF(Lighting!C12=\"\",0,Lighting!C12),IF(OR(B14=\"No Lighting\",B14=\"UNUSED\"),IF(ISNUMBER($I$27),$I$27,0),0)))","v":0},{"$f":"IF(OR(K14=\" \",B14=\" \"),0,Site!$C$17)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!D12=\"\",\" \",Lighting!D12)","v":" "},{"$f":"IF(Lighting!E12=\"\",0,Lighting!E12)","v":0},{"$f":"IF(K14=\" \",0,Site!$C$15)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!B$12=\"\",0,VLOOKUP(Lighting!B$12,HID_Data1,4,FALSE)*Lighting!C$12)","v":0}]
[null,{"$f":"IF(Lighting!B$13=\"\",\" \",IF(Proj_Type=\"Lighting Retrofit (increased illuminance)\",\"UNUSED\",Lighting!B$13))","v":" "},{"$f":"IF(K15=\" \",0,IF(Proj_Type=\"Lighting Retrofit (same illuminance)\",IF(Lighting!C13=\"\",0,Lighting!C13),IF(OR(B15=\"No Lighting\",B15=\"UNUSED\"),IF(ISNUMBER($I$27),$I$27,0),0)))","v":0},{"$f":"IF(OR(K15=\" \",B15=\" \"),0,Site!$C$18)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!D13=\"\",\" \",Lighting!D13)","v":" "},{"$f":"IF(Lighting!E13=\"\",0,Lighting!E13)","v":0},{"$f":"IF(K15=\" \",0,Site!$C$15)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!B$13=\"\",0,VLOOKUP(Lighting!B$13,HID_Data1,4,FALSE)*Lighting!C$13)","v":0}]
[null,{"$f":"IF(Lighting!B$14=\"\",\" \",IF(Proj_Type=\"Lighting Retrofit (increased illuminance)\",\"UNUSED\",Lighting!B$14))","v":" "},{"$f":"IF(K16=\" \",0,IF(Proj_Type=\"Lighting Retrofit (same illuminance)\",IF(Lighting!C14=\"\",0,Lighting!C14),IF(OR(B16=\"No Lighting\",B16=\"UNUSED\"),IF(ISNUMBER($I$27),$I$27,0),0)))","v":0},{"$f":"IF(OR(K16=\" \",B16=\" \"),0,Site!$C$19)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!D14=\"\",\" \",Lighting!D14)","v":" "},{"$f":"IF(Lighting!E14=\"\",0,Lighting!E14)","v":0},{"$f":"IF(K16=\" \",0,Site!$C$15)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!B$14=\"\",0,VLOOKUP(Lighting!B$14,HID_Data1,4,FALSE)*Lighting!C$14)","v":0}]
[null,{"$f":"IF(Lighting!B$15=\"\",\" \",IF(Proj_Type=\"Lighting Retrofit (increased illuminance)\",\"UNUSED\",Lighting!B$15))","v":" "},{"$f":"IF(K17=\" \",0,IF(Proj_Type=\"Lighting Retrofit (same illuminance)\",IF(Lighting!C15=\"\",0,Lighting!C15),IF(OR(B17=\"No Lighting\",B17=\"UNUSED\"),IF(ISNUMBER($I$27),$I$27,0),0)))","v":0},{"$f":"IF(OR(K17=\" \",B17=\" \"),0,Site!$C$20)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!D15=\"\",\" \",Lighting!D15)","v":" "},{"$f":"IF(Lighting!E15=\"\",0,Lighting!E15)","v":0},{"$f":"IF(K17=\" \",0,Site!$C$15)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!B$15=\"\",0,VLOOKUP(Lighting!B$15,HID_Data1,4,FALSE)*Lighting!C$15)","v":0}]
[null,{"$f":"IF(Lighting!B$16=\"\",\" \",IF(Proj_Type=\"Lighting Retrofit (increased illuminance)\",\"UNUSED\",Lighting!B$16))","v":" "},{"$f":"IF(K18=\" \",0,IF(Proj_Type=\"Lighting Retrofit (same illuminance)\",IF(Lighting!C16=\"\",0,Lighting!C16),IF(OR(B18=\"No Lighting\",B18=\"UNUSED\"),IF(ISNUMBER($I$27),$I$27,0),0)))","v":0},{"$f":"IF(OR(K18=\" \",B18=\" \"),0,Site!$C$21)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!D16=\"\",\" \",Lighting!D16)","v":" "},{"$f":"IF(Lighting!E16=\"\",0,Lighting!E16)","v":0},{"$f":"IF(K18=\" \",0,Site!$C$15)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!B$16=\"\",0,VLOOKUP(Lighting!B$16,HID_Data1,4,FALSE)*Lighting!C$16)","v":0}]
[null,{"$f":"IF(Lighting!B$17=\"\",\" \",IF(Proj_Type=\"Lighting Retrofit (increased illuminance)\",\"UNUSED\",Lighting!B$17))","v":" "},{"$f":"IF(K19=\" \",0,IF(Proj_Type=\"Lighting Retrofit (same illuminance)\",IF(Lighting!C17=\"\",0,Lighting!C17),IF(OR(B19=\"No Lighting\",B19=\"UNUSED\"),IF(ISNUMBER($I$27),$I$27,0),0)))","v":0},{"$f":"IF(OR(K19=\" \",B19=\" \"),0,Site!$C$22)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!D17=\"\",\" \",Lighting!D17)","v":" "},{"$f":"IF(Lighting!E17=\"\",0,Lighting!E17)","v":0},{"$f":"IF(K19=\" \",0,Site!$C$15)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!B$17=\"\",0,VLOOKUP(Lighting!B$17,HID_Data1,4,FALSE)*Lighting!C$17)","v":0}]
[null,{"$f":"IF(Lighting!B$18=\"\",\" \",IF(Proj_Type=\"Lighting Retrofit (increased illuminance)\",\"UNUSED\",Lighting!B$18))","v":" "},{"$f":"IF(K20=\" \",0,IF(Proj_Type=\"Lighting Retrofit (same illuminance)\",IF(Lighting!C18=\"\",0,Lighting!C18),IF(OR(B20=\"No Lighting\",B20=\"UNUSED\"),IF(ISNUMBER($I$27),$I$27,0),0)))","v":0},{"$f":"IF(OR(K20=\" \",B20=\" \"),0,Site!$C$23)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!D18=\"\",\" \",Lighting!D18)","v":" "},{"$f":"IF(Lighting!E18=\"\",0,Lighting!E18)","v":0},{"$f":"IF(K20=\" \",0,Site!$C$15)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!B$18=\"\",0,VLOOKUP(Lighting!B$18,HID_Data1,4,FALSE)*Lighting!C$18)","v":0}]
[null,"TOTAL",{"$f":"SUM(C11:C20)","v":0},{"$f":"MAX(D11:D20)","v":0},{"$f":"SUM(E11:E20)","v":0},{"$f":"SUM(F11:F20)","v":0},{"$f":"C21*E21","v":0},{"$f":"C21*F21","v":0},0,null,"TOTAL",{"$f":"SUM(L11:L20)","v":0},{"$f":"MAX(M11:M20)","v":0},{"$f":"SUM(N11:N20)","v":0},{"$f":"SUM(O11:O20)","v":0},{"$f":"L21*N21","v":0},{"$f":"L21*O21","v":0},0]
[]
[null,"Savings Table",null,null,null,null,"Equivalent Existing # Luminaires",null,null,null,null,"Illuminance Checking"]
[null,"Replacement",null,"Energy (kWh) change","Lumen Change",null,"Proposed Illuminance (lux)",null,{"$f":"IF(Proj_Illum_Units=\"PAR\",(1000/13)*Site!C$19,Site!C$19)","v":0},null,null,null,null,"Customer Baseline","Customer calc.","Virtual Baseline","Customer Prop.","PSE Calculated"]
[null,{"$f":"(IF(AND(B11=\" \",K11=\" \"),\"\",B11&\" -> \"&K11))","v":""},null,{"$f":"IF(K11=\" \",0,IFERROR(R11-I11,\"MISS INFO\"))","v":0},{"$f":"IF(K11=\" \",0,IFERROR(Q11-H11,\"MISS INFO\"))","v":0},null,"Proposed Lit Area (sqm)",null,{"$f":"IF(Proj_Area_Units=\"sqft\",0.0929*Site!C$11,Site!C$11)","v":0},null,null,"Illuminance (lux)",null,{"$f":"IF(Proj_Type=\"Lighting Retrofit (increased illuminance)\",IF(Proj_Illum_Units=\"PAR\",Site!C$17*(1000/13),Site!C$17),IF(Proj_Type=\"Lighting Retrofit (same illuminance)\",I24,\"N/A\"))","v":"N/A"},{"$f":"IF(OR(Proj_Type=\"Lighting Retrofit (same illuminance)\",Proj_Type=\"Lighting Retrofit (increased illuminance)\"),IF(Proj_Area_Units=\"sqft\",O26/(0.0929*Site!C$10),O26/Site!C$10),\"N/A\")","v":"N/A"},{"$f":"I28","v":{"$error":"#VALUE!"}},{"$f":"I24","v":0},{"$f":"Q21/I25","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"(IF(AND(B12=\" \",K12=\" \"),\"\",B12&\" -> \"&K12))","v":""},null,{"$f":"IF(K12=\" \",0,IFERROR(R12-I12,\"MISS INFO\"))","v":0},{"$f":"IF(K12=\" \",0,IFERROR(Q12-H12,\"MISS INFO\"))","v":0},null,"Avg .Equiv. Degraded Lm",null,{"$f":"'Standard Data'!$D2","v":"MISS INFO"},null,null,"Total Degraded Lumens",null,{"$f":"IF(OR(Proj_Type=\"Lighting Retrofit (increased illuminance)\",Proj_Type=\"Lighting Retrofit (same illuminance)\"),IF(Proj_Area_Units=\"sqft\",0.0929*Site!C$10*N25,Site!C$10*N25),\"N/A\")","v":"N/A"},{"$f":"IF(Proj_Type=\"Lighting Retrofit (same illuminance)\",H21,IF(Proj_Type=\"Lighting Retrofit (increased illuminance)\",SUM(T11:T20),\"N/A\"))","v":"N/A"},{"$f":"I26*I27","v":{"$error":"#VALUE!"}},{"$f":"Q25*I25","v":0},{"$f":"Q21","v":0}]
[null,"",null,0,0,null,"Equivalent # Luminaires",null,{"$f":"ROUND(I24*I25/I26,0)","v":{"$error":"#VALUE!"}}]
[null,"",null,0,0,null,"Virtual Baseline (lux)",null,{"$f":"I27*I26/I25","v":{"$error":"#VALUE!"}}]
[null,"",null,0,0]
[null,"",null,0,0]
[null,"",null,0,0]
[null,"",null,0,0]
[null,"",null,0,0]
[null,"",null,0,0,"Luminaire Energy Change",null,"Controls Energy Change"]
[null,"TOTAL",null,{"$f":"IF(ISNUMBER(MATCH(\"MISS INFO\",D25:D34)),\"MISSING INFO!\",SUM(D25:D34))","v":0},{"$f":"IF(ISNUMBER(MATCH(\"MISS INFO\",E25:E34)),\"MISSING INFO!\",SUM(E25:E34))","v":0},{"$f":"(P21-G21)*D21/1000","v":0},null,{"$f":"IF('Standard Data'!H31=FALSE,0,IF('Standard Data'!H31=TRUE,D35-F35,\"NO PROJECT TYPE\"))","v":0}]
[]
[]
[]
[]
[]
[null,"Site 2"]
[null,null,null,null,"single","single","total","total","total",null,null,null,null,"single","single","total","total","total"]
[null,"Existing Luminaire","# of Existing Luminaires","Existing Annual Hrs","Existing Input W Per Luminaire","Existing Lm per Luminaire","Existing Total Input W","Existing Total Lm","Existing Total kWh/yr",null,"Proposed Luminaire","# of Proposed Luminaires","Proposed Annual Hrs","Proposed Input W Per Luminaire","Proposed Lm per Luminaire","Proposed Total Input W","Proposed Total Lm","Proposed Total kWh/yr",null,"exist lumens"]
[null,{"$f":"IF(Lighting!G$9=\"\",\" \",IF(Proj_Type=\"Lighting Retrofit (increased illuminance)\",\"UNUSED\",Lighting!G$9))","v":" "},{"$f":"IF(K44=\" \",0,IF(Proj_Type=\"Lighting Retrofit (same illuminance)\",IF(Lighting!H9=\"\",0,Lighting!H9),IF(OR(B44=\"No Lighting\",B44=\"UNUSED\"),IF(ISNUMBER($I$60),$I$60,0),0)))","v":0},{"$f":"IF(OR(K44=\" \",B44=\" \"),0,Site!$E$14)","v":0},{"$f":"IF(K44=\" \",0,VLOOKUP(B44,HID_Data2,3,FALSE))","v":0},{"$f":"IF(K44=\" \",0,VLOOKUP(B44,HID_Data2,4,FALSE))","v":0},{"$f":"IFERROR(C44*E44,\"MISS INFO\")","v":0},{"$f":"IFERROR(C44*F44,\"MISS INFO\")","v":0},{"$f":"IFERROR(D44*G44/1000,\"MISS INFO\")","v":0},null,{"$f":"IF(Lighting!I9=\"\",\" \",Lighting!I9)","v":" "},{"$f":"IF(Lighting!J9=\"\",0,Lighting!J9)","v":0},{"$f":"IF(K44=\" \",0,Site!$E$15)","v":0},{"$f":"VLOOKUP(K44,HID_Data2,3,FALSE)","v":0},{"$f":"VLOOKUP(K44,HID_Data2,4,FALSE)","v":0},{"$f":"IFERROR(L44*N44,\"MISS INFO\")","v":0},{"$f":"IFERROR(L44*O44,\"MISS INFO\")","v":0},{"$f":"IFERROR(M44*P44/1000,\"MISS INFO\")","v":0},null,{"$f":"IF(Lighting!G$9=\"\",0,VLOOKUP(Lighting!G$9,HID_Data1,4,FALSE)*Lighting!H$9)","v":0}]
[null,{"$f":"IF(Lighting!G$10=\"\",\" \",IF(Proj_Type=\"Lighting Retrofit (increased illuminance)\",\"UNUSED\",Lighting!G$10))","v":" "},{"$f":"IF(K45=\" \",0,IF(Proj_Type=\"Lighting Retrofit (same illuminance)\",IF(Lighting!H10=\"\",0,Lighting!H10),IF(OR(B45=\"No Lighting\",B45=\"UNUSED\"),IF(ISNUMBER($I$60),$I$60,0),0)))","v":0},{"$f":"IF(OR(K45=\" \",B45=\" \"),0,Site!$E$15)","v":0},0,0,{"$f":"IFERROR(C45*E45,\"MISS INFO\")","v":0},{"$f":"IFERROR(C45*F45,\"MISS INFO\")","v":0},{"$f":"IFERROR(D45*G45/1000,\"MISS INFO\")","v":0},null,{"$f":"IF(Lighting!I10=\"\",\" \",Lighting!I10)","v":" "},{"$f":"IF(Lighting!J10=\"\",0,Lighting!J10)","v":0},{"$f":"IF(K45=\" \",0,Site!$E$15)","v":0},0,0,{"$f":"IFERROR(L45*N45,\"MISS INFO\")","v":0},{"$f":"IFERROR(L45*O45,\"MISS INFO\")","v":0},{"$f":"IFERROR(M45*P45/1000,\"MISS INFO\")","v":0},null,{"$f":"IF(Lighting!G$10=\"\",0,VLOOKUP(Lighting!G$10,HID_Data1,4,FALSE)*Lighting!H$10)","v":0}]
[null,{"$f":"IF(Lighting!G$11=\"\",\" \",IF(Proj_Type=\"Lighting Retrofit (increased illuminance)\",\"UNUSED\",Lighting!G$11))","v":" "},{"$f":"IF(K46=\" \",0,IF(Proj_Type=\"Lighting Retrofit (same illuminance)\",IF(Lighting!H11=\"\",0,Lighting!H11),IF(OR(B46=\"No Lighting\",B46=\"UNUSED\"),IF(ISNUMBER($I$60),$I$60,0),0)))","v":0},{"$f":"IF(OR(K46=\" \",B46=\" \"),0,Site!$E$16)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!I11=\"\",\" \",Lighting!I11)","v":" "},{"$f":"IF(Lighting!J11=\"\",0,Lighting!J11)","v":0},{"$f":"IF(K46=\" \",0,Site!$E$15)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!G$11=\"\",0,VLOOKUP(Lighting!G$11,HID_Data1,4,FALSE)*Lighting!H$11)","v":0}]
[null,{"$f":"IF(Lighting!G$12=\"\",\" \",IF(Proj_Type=\"Lighting Retrofit (increased illuminance)\",\"UNUSED\",Lighting!G$12))","v":" "},{"$f":"IF(K47=\" \",0,IF(Proj_Type=\"Lighting Retrofit (same illuminance)\",IF(Lighting!H12=\"\",0,Lighting!H12),IF(OR(B47=\"No Lighting\",B47=\"UNUSED\"),IF(ISNUMBER($I$60),$I$60,0),0)))","v":0},{"$f":"IF(OR(K47=\" \",B47=\" \"),0,Site!$E$17)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!I12=\"\",\" \",Lighting!I12)","v":" "},{"$f":"IF(Lighting!J12=\"\",0,Lighting!J12)","v":0},{"$f":"IF(K47=\" \",0,Site!$E$15)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!G$12=\"\",0,VLOOKUP(Lighting!G$12,HID_Data1,4,FALSE)*Lighting!H$12)","v":0}]
[null,{"$f":"IF(Lighting!G$13=\"\",\" \",IF(Proj_Type=\"Lighting Retrofit (increased illuminance)\",\"UNUSED\",Lighting!G$13))","v":" "},{"$f":"IF(K48=\" \",0,IF(Proj_Type=\"Lighting Retrofit (same illuminance)\",IF(Lighting!H13=\"\",0,Lighting!H13),IF(OR(B48=\"No Lighting\",B48=\"UNUSED\"),IF(ISNUMBER($I$60),$I$60,0),0)))","v":0},{"$f":"IF(OR(K48=\" \",B48=\" \"),0,Site!$E$18)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!I13=\"\",\" \",Lighting!I13)","v":" "},{"$f":"IF(Lighting!J13=\"\",0,Lighting!J13)","v":0},{"$f":"IF(K48=\" \",0,Site!$E$15)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!G$13=\"\",0,VLOOKUP(Lighting!G$13,HID_Data1,4,FALSE)*Lighting!H$13)","v":0}]
[null,{"$f":"IF(Lighting!G$14=\"\",\" \",IF(Proj_Type=\"Lighting Retrofit (increased illuminance)\",\"UNUSED\",Lighting!G$14))","v":" "},{"$f":"IF(K49=\" \",0,IF(Proj_Type=\"Lighting Retrofit (same illuminance)\",IF(Lighting!H14=\"\",0,Lighting!H14),IF(OR(B49=\"No Lighting\",B49=\"UNUSED\"),IF(ISNUMBER($I$60),$I$60,0),0)))","v":0},{"$f":"IF(OR(K49=\" \",B49=\" \"),0,Site!$E$19)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!I14=\"\",\" \",Lighting!I14)","v":" "},{"$f":"IF(Lighting!J14=\"\",0,Lighting!J14)","v":0},{"$f":"IF(K49=\" \",0,Site!$E$15)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!G$14=\"\",0,VLOOKUP(Lighting!G$14,HID_Data1,4,FALSE)*Lighting!H$14)","v":0}]
[null,{"$f":"IF(Lighting!G$15=\"\",\" \",IF(Proj_Type=\"Lighting Retrofit (increased illuminance)\",\"UNUSED\",Lighting!G$15))","v":" "},{"$f":"IF(K50=\" \",0,IF(Proj_Type=\"Lighting Retrofit (same illuminance)\",IF(Lighting!H15=\"\",0,Lighting!H15),IF(OR(B50=\"No Lighting\",B50=\"UNUSED\"),IF(ISNUMBER($I$60),$I$60,0),0)))","v":0},{"$f":"IF(OR(K50=\" \",B50=\" \"),0,Site!$E$20)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!I15=\"\",\" \",Lighting!I15)","v":" "},{"$f":"IF(Lighting!J15=\"\",0,Lighting!J15)","v":0},{"$f":"IF(K50=\" \",0,Site!$E$15)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!G$15=\"\",0,VLOOKUP(Lighting!G$15,HID_Data1,4,FALSE)*Lighting!H$15)","v":0}]
[null,{"$f":"IF(Lighting!G$16=\"\",\" \",IF(Proj_Type=\"Lighting Retrofit (increased illuminance)\",\"UNUSED\",Lighting!G$16))","v":" "},{"$f":"IF(K51=\" \",0,IF(Proj_Type=\"Lighting Retrofit (same illuminance)\",IF(Lighting!H16=\"\",0,Lighting!H16),IF(OR(B51=\"No Lighting\",B51=\"UNUSED\"),IF(ISNUMBER($I$60),$I$60,0),0)))","v":0},{"$f":"IF(OR(K51=\" \",B51=\" \"),0,Site!$E$21)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!I16=\"\",\" \",Lighting!I16)","v":" "},{"$f":"IF(Lighting!J16=\"\",0,Lighting!J16)","v":0},{"$f":"IF(K51=\" \",0,Site!$E$15)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!G$16=\"\",0,VLOOKUP(Lighting!G$16,HID_Data1,4,FALSE)*Lighting!H$16)","v":0}]
[null,{"$f":"IF(Lighting!G$17=\"\",\" \",IF(Proj_Type=\"Lighting Retrofit (increased illuminance)\",\"UNUSED\",Lighting!G$17))","v":" "},{"$f":"IF(K52=\" \",0,IF(Proj_Type=\"Lighting Retrofit (same illuminance)\",IF(Lighting!H17=\"\",0,Lighting!H17),IF(OR(B52=\"No Lighting\",B52=\"UNUSED\"),IF(ISNUMBER($I$60),$I$60,0),0)))","v":0},{"$f":"IF(OR(K52=\" \",B52=\" \"),0,Site!$E$22)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!I17=\"\",\" \",Lighting!I17)","v":" "},{"$f":"IF(Lighting!J17=\"\",0,Lighting!J17)","v":0},{"$f":"IF(K52=\" \",0,Site!$E$15)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!G$17=\"\",0,VLOOKUP(Lighting!G$17,HID_Data1,4,FALSE)*Lighting!H$17)","v":0}]
[null,{"$f":"IF(Lighting!G$18=\"\",\" \",IF(Proj_Type=\"Lighting Retrofit (increased illuminance)\",\"UNUSED\",Lighting!G$18))","v":" "},{"$f":"IF(K53=\" \",0,IF(Proj_Type=\"Lighting Retrofit (same illuminance)\",IF(Lighting!H18=\"\",0,Lighting!H18),IF(OR(B53=\"No Lighting\",B53=\"UNUSED\"),IF(ISNUMBER($I$60),$I$60,0),0)))","v":0},{"$f":"IF(OR(K53=\" \",B53=\" \"),0,Site!$E$23)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!I18=\"\",\" \",Lighting!I18)","v":" "},{"$f":"IF(Lighting!J18=\"\",0,Lighting!J18)","v":0},{"$f":"IF(K53=\" \",0,Site!$E$15)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!G$18=\"\",0,VLOOKUP(Lighting!G$18,HID_Data1,4,FALSE)*Lighting!H$18)","v":0}]
[null,"TOTAL",{"$f":"SUM(C44:C53)","v":0},{"$f":"MAX(D44:D53)","v":0},{"$f":"SUM(E44:E53)","v":0},{"$f":"SUM(F44:F53)","v":0},{"$f":"C54*E54","v":0},{"$f":"C54*F54","v":0},0,null,"TOTAL",{"$f":"SUM(L44:L53)","v":0},{"$f":"MAX(M44:M53)","v":0},{"$f":"SUM(N44:N53)","v":0},{"$f":"SUM(O44:O53)","v":0},{"$f":"L54*N54","v":0},{"$f":"L54*O54","v":0},0]
[]
[null,"Savings Table",null,null,null,null,"Equivalent Existing # Luminaires",null,null,null,null,"Illuminance Checking"]
[null,"Replacement",null,"Energy (kWh) change","Lumen Change",null,"Proposed Illuminance (lux)",null,{"$f":"IF(Proj_Illum_Units=\"PAR\",(1000/13)*Site!E$19,Site!E$19)","v":0},null,null,null,null,"Customer Baseline","Customer calc.","Virtual Baseline","Customer Prop.","PSE Calculated"]
[null,{"$f":"(IF(AND(B44=\" \",K44=\" \"),\"\",B44&\" -> \"&K44))","v":""},null,{"$f":"IF(K44=\" \",0,IFERROR(R44-I44,\"MISS INFO\"))","v":0},{"$f":"IF(K44=\" \",0,IFERROR(Q44-H44,\"MISS INFO\"))","v":0},null,"Proposed Lit Area (sqm)",null,{"$f":"IF(Proj_Area_Units=\"sqft\",0.0929*Site!E$11,Site!E$11)","v":0},null,null,"Illuminance (lux)",null,{"$f":"IF(Proj_Type=\"Lighting Retrofit (increased illuminance)\",IF(Proj_Illum_Units=\"PAR\",Site!E$17*(1000/13),Site!E$17),IF(Proj_Type=\"Lighting Retrofit (same illuminance)\",I57,\"N/A\"))","v":"N/A"},{"$f":"IF(OR(Proj_Type=\"Lighting Retrofit (same illuminance)\",Proj_Type=\"Lighting Retrofit (increased illuminance)\"),IF(Proj_Area_Units=\"sqft\",O59/(0.0929*Site!E$10),O59/Site!E$10),\"N/A\")","v":"N/A"},{"$f":"I61","v":{"$error":"#VALUE!"}},{"$f":"I57","v":0},{"$f":"Q54/I58","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"(IF(AND(B45=\" \",K45=\" \"),\"\",B45&\" -> \"&K45))","v":""},null,{"$f":"IF(K45=\" \",0,IFERROR(R45-I45,\"MISS INFO\"))","v":0},{"$f":"IF(K45=\" \",0,IFERROR(Q45-H45,\"MISS INFO\"))","v":0},null,"Avg .Equiv. Degraded Lm",null,{"$f":"'Standard Data'!$D16","v":"MISS INFO"},null,null,"Total Degraded Lumens",null,{"$f":"IF(OR(Proj_Type=\"Lighting Retrofit (increased illuminance)\",Proj_Type=\"Lighting Retrofit (same illuminance)\"),IF(Proj_Area_Units=\"sqft\",0.0929*Site!E$10*N58,Site!E$10*N58),\"N/A\")","v":"N/A"},{"$f":"IF(Proj_Type=\"Lighting Retrofit (same illuminance)\",H54,IF(Proj_Type=\"Lighting Retrofit (increased illuminance)\",SUM(T44:T53),\"N/A\"))","v":"N/A"},{"$f":"I59*I60","v":{"$error":"#VALUE!"}},{"$f":"Q58*I58","v":0},{"$f":"Q54","v":0}]
[null,"",null,0,0,null,"Equivalent # Luminaires",null,{"$f":"ROUND(I57*I58/I59,0)","v":{"$error":"#VALUE!"}}]
[null,"",null,0,0,null,"Virtual Baseline (lux)",null,{"$f":"I60*I59/I58","v":{"$error":"#VALUE!"}}]
[null,"",null,0,0]
[null,"",null,0,0]
[null,"",null,0,0]
[null,"",null,0,0]
[null,"",null,0,0]
[null,"",null,0,0,"Luminaire Energy Change",null,"Controls Energy Change"]
[null,"TOTAL",null,{"$f":"IF(ISNUMBER(MATCH(\"MISS INFO\",D58:D67)),\"MISSING INFO!\",SUM(D58:D67))","v":0},{"$f":"IF(ISNUMBER(MATCH(\"MISS INFO\",E58:E67)),\"MISSING INFO!\",SUM(E58:E67))","v":0},{"$f":"(P54-G54)*D54/1000","v":0},null,{"$f":"IF('Standard Data'!H31=FALSE,0,IF('Standard Data'!H31=TRUE,D68-F68,\"NO PROJECT TYPE\"))","v":0}]
[]
[]
[]
[]
[]
[null,"Site 3"]
[null,null,null,null,"single","single","total","total","total",null,null,null,null,"single","single","total","total","total"]
[null,"Existing Luminaire","# of Existing Luminaires","Existing Annual Hrs","Existing Input W Per Luminaire","Existing Lm per Luminaire","Existing Total Input W","Existing Total Lm","Existing Total kWh/yr",null,"Proposed Luminaire","# of Proposed Luminaires","Proposed Annual Hrs","Proposed Input W Per Luminaire","Proposed Lm per Luminaire","Proposed Total Input W","Proposed Total Lm","Proposed Total kWh/yr",null,"exist lumens"]
[null,{"$f":"IF(Lighting!L$9=\"\",\" \",IF(Proj_Type=\"Lighting Retrofit (increased illuminance)\",\"UNUSED\",Lighting!L$9))","v":" "},{"$f":"IF(K77=\" \",0,IF(Proj_Type=\"Lighting Retrofit (same illuminance)\",IF(Lighting!M9=\"\",0,Lighting!M9),IF(OR(B77=\"No Lighting\",B77=\"UNUSED\"),IF(ISNUMBER($I$93),$I$93,0),0)))","v":0},{"$f":"IF(OR(K77=\" \",B77=\" \"),0,Site!$G$14)","v":0},{"$f":"IF(K77=\" \",0,VLOOKUP(B77,HID_Data3,3,FALSE))","v":0},{"$f":"IF(K77=\" \",0,VLOOKUP(B77,HID_Data3,4,FALSE))","v":0},{"$f":"IFERROR(C77*E77,\"MISS INFO\")","v":0},{"$f":"IFERROR(C77*F77,\"MISS INFO\")","v":0},{"$f":"IFERROR(D77*G77/1000,\"MISS INFO\")","v":0},null,{"$f":"IF(Lighting!N9=\"\",\" \",Lighting!N9)","v":" "},{"$f":"IF(Lighting!O9=\"\",0,Lighting!O9)","v":0},{"$f":"IF(K77=\" \",0,Site!$G$15)","v":0},{"$f":"VLOOKUP(K77,HID_Data3,3,FALSE)","v":0},{"$f":"VLOOKUP(K77,HID_Data3,4,FALSE)","v":0},{"$f":"IFERROR(L77*N77,\"MISS INFO\")","v":0},{"$f":"IFERROR(L77*O77,\"MISS INFO\")","v":0},{"$f":"IFERROR(M77*P77/1000,\"MISS INFO\")","v":0},null,{"$f":"IF(Lighting!L$9=\"\",0,VLOOKUP(Lighting!L$9,HID_Data1,4,FALSE)*Lighting!M$9)","v":0}]
[null,{"$f":"IF(Lighting!L$10=\"\",\" \",IF(Proj_Type=\"Lighting Retrofit (increased illuminance)\",\"UNUSED\",Lighting!L$10))","v":" "},{"$f":"IF(K78=\" \",0,IF(Proj_Type=\"Lighting Retrofit (same illuminance)\",IF(Lighting!M10=\"\",0,Lighting!M10),IF(OR(B78=\"No Lighting\",B78=\"UNUSED\"),IF(ISNUMBER($I$93),$I$93,0),0)))","v":0},{"$f":"IF(OR(K78=\" \",B78=\" \"),0,Site!$G$15)","v":0},0,0,{"$f":"IFERROR(C78*E78,\"MISS INFO\")","v":0},{"$f":"IFERROR(C78*F78,\"MISS INFO\")","v":0},{"$f":"IFERROR(D78*G78/1000,\"MISS INFO\")","v":0},null,{"$f":"IF(Lighting!N10=\"\",\" \",Lighting!N10)","v":" "},{"$f":"IF(Lighting!O10=\"\",0,Lighting!O10)","v":0},{"$f":"IF(K78=\" \",0,Site!$G$15)","v":0},0,0,{"$f":"IFERROR(L78*N78,\"MISS INFO\")","v":0},{"$f":"IFERROR(L78*O78,\"MISS INFO\")","v":0},{"$f":"IFERROR(M78*P78/1000,\"MISS INFO\")","v":0},null,{"$f":"IF(Lighting!L$10=\"\",0,VLOOKUP(Lighting!L$10,HID_Data1,4,FALSE)*Lighting!M$10)","v":0}]
[null,{"$f":"IF(Lighting!L$11=\"\",\" \",IF(Proj_Type=\"Lighting Retrofit (increased illuminance)\",\"UNUSED\",Lighting!L$11))","v":" "},{"$f":"IF(K79=\" \",0,IF(Proj_Type=\"Lighting Retrofit (same illuminance)\",IF(Lighting!M11=\"\",0,Lighting!M11),IF(OR(B79=\"No Lighting\",B79=\"UNUSED\"),IF(ISNUMBER($I$93),$I$93,0),0)))","v":0},{"$f":"IF(OR(K79=\" \",B79=\" \"),0,Site!$G$16)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!N11=\"\",\" \",Lighting!N11)","v":" "},{"$f":"IF(Lighting!O11=\"\",0,Lighting!O11)","v":0},{"$f":"IF(K79=\" \",0,Site!$G$15)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!L$11=\"\",0,VLOOKUP(Lighting!L$11,HID_Data1,4,FALSE)*Lighting!M$11)","v":0}]
[null,{"$f":"IF(Lighting!L$12=\"\",\" \",IF(Proj_Type=\"Lighting Retrofit (increased illuminance)\",\"UNUSED\",Lighting!L$12))","v":" "},{"$f":"IF(K80=\" \",0,IF(Proj_Type=\"Lighting Retrofit (same illuminance)\",IF(Lighting!M12=\"\",0,Lighting!M12),IF(OR(B80=\"No Lighting\",B80=\"UNUSED\"),IF(ISNUMBER($I$93),$I$93,0),0)))","v":0},{"$f":"IF(OR(K80=\" \",B80=\" \"),0,Site!$G$17)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!N12=\"\",\" \",Lighting!N12)","v":" "},{"$f":"IF(Lighting!O12=\"\",0,Lighting!O12)","v":0},{"$f":"IF(K80=\" \",0,Site!$G$15)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!L$12=\"\",0,VLOOKUP(Lighting!L$12,HID_Data1,4,FALSE)*Lighting!M$12)","v":0}]
[null,{"$f":"IF(Lighting!L$13=\"\",\" \",IF(Proj_Type=\"Lighting Retrofit (increased illuminance)\",\"UNUSED\",Lighting!L$13))","v":" "},{"$f":"IF(K81=\" \",0,IF(Proj_Type=\"Lighting Retrofit (same illuminance)\",IF(Lighting!M13=\"\",0,Lighting!M13),IF(OR(B81=\"No Lighting\",B81=\"UNUSED\"),IF(ISNUMBER($I$93),$I$93,0),0)))","v":0},{"$f":"IF(OR(K81=\" \",B81=\" \"),0,Site!$G$18)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!N13=\"\",\" \",Lighting!N13)","v":" "},{"$f":"IF(Lighting!O13=\"\",0,Lighting!O13)","v":0},{"$f":"IF(K81=\" \",0,Site!$G$15)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!L$13=\"\",0,VLOOKUP(Lighting!L$13,HID_Data1,4,FALSE)*Lighting!M$13)","v":0}]
[null,{"$f":"IF(Lighting!L$14=\"\",\" \",IF(Proj_Type=\"Lighting Retrofit (increased illuminance)\",\"UNUSED\",Lighting!L$14))","v":" "},{"$f":"IF(K82=\" \",0,IF(Proj_Type=\"Lighting Retrofit (same illuminance)\",IF(Lighting!M14=\"\",0,Lighting!M14),IF(OR(B82=\"No Lighting\",B82=\"UNUSED\"),IF(ISNUMBER($I$93),$I$93,0),0)))","v":0},{"$f":"IF(OR(K82=\" \",B82=\" \"),0,Site!$G$19)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!N14=\"\",\" \",Lighting!N14)","v":" "},{"$f":"IF(Lighting!O14=\"\",0,Lighting!O14)","v":0},{"$f":"IF(K82=\" \",0,Site!$G$15)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!L$14=\"\",0,VLOOKUP(Lighting!L$14,HID_Data1,4,FALSE)*Lighting!M$14)","v":0}]
[null,{"$f":"IF(Lighting!L$15=\"\",\" \",IF(Proj_Type=\"Lighting Retrofit (increased illuminance)\",\"UNUSED\",Lighting!L$15))","v":" "},{"$f":"IF(K83=\" \",0,IF(Proj_Type=\"Lighting Retrofit (same illuminance)\",IF(Lighting!M15=\"\",0,Lighting!M15),IF(OR(B83=\"No Lighting\",B83=\"UNUSED\"),IF(ISNUMBER($I$93),$I$93,0),0)))","v":0},{"$f":"IF(OR(K83=\" \",B83=\" \"),0,Site!$G$20)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!N15=\"\",\" \",Lighting!N15)","v":" "},{"$f":"IF(Lighting!O15=\"\",0,Lighting!O15)","v":0},{"$f":"IF(K83=\" \",0,Site!$G$15)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!L$15=\"\",0,VLOOKUP(Lighting!L$15,HID_Data1,4,FALSE)*Lighting!M$15)","v":0}]
[null,{"$f":"IF(Lighting!L$16=\"\",\" \",IF(Proj_Type=\"Lighting Retrofit (increased illuminance)\",\"UNUSED\",Lighting!L$16))","v":" "},{"$f":"IF(K84=\" \",0,IF(Proj_Type=\"Lighting Retrofit (same illuminance)\",IF(Lighting!M16=\"\",0,Lighting!M16),IF(OR(B84=\"No Lighting\",B84=\"UNUSED\"),IF(ISNUMBER($I$93),$I$93,0),0)))","v":0},{"$f":"IF(OR(K84=\" \",B84=\" \"),0,Site!$G$21)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!N16=\"\",\" \",Lighting!N16)","v":" "},{"$f":"IF(Lighting!O16=\"\",0,Lighting!O16)","v":0},{"$f":"IF(K84=\" \",0,Site!$G$15)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!L$16=\"\",0,VLOOKUP(Lighting!L$16,HID_Data1,4,FALSE)*Lighting!M$16)","v":0}]
[null,{"$f":"IF(Lighting!L$17=\"\",\" \",IF(Proj_Type=\"Lighting Retrofit (increased illuminance)\",\"UNUSED\",Lighting!L$17))","v":" "},{"$f":"IF(K85=\" \",0,IF(Proj_Type=\"Lighting Retrofit (same illuminance)\",IF(Lighting!M17=\"\",0,Lighting!M17),IF(OR(B85=\"No Lighting\",B85=\"UNUSED\"),IF(ISNUMBER($I$93),$I$93,0),0)))","v":0},{"$f":"IF(OR(K85=\" \",B85=\" \"),0,Site!$G$22)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!N17=\"\",\" \",Lighting!N17)","v":" "},{"$f":"IF(Lighting!O17=\"\",0,Lighting!O17)","v":0},{"$f":"IF(K85=\" \",0,Site!$G$15)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!L$17=\"\",0,VLOOKUP(Lighting!L$17,HID_Data1,4,FALSE)*Lighting!M$17)","v":0}]
[null,{"$f":"IF(Lighting!L$18=\"\",\" \",IF(Proj_Type=\"Lighting Retrofit (increased illuminance)\",\"UNUSED\",Lighting!L$18))","v":" "},{"$f":"IF(K86=\" \",0,IF(Proj_Type=\"Lighting Retrofit (same illuminance)\",IF(Lighting!M18=\"\",0,Lighting!M18),IF(OR(B86=\"No Lighting\",B86=\"UNUSED\"),IF(ISNUMBER($I$93),$I$93,0),0)))","v":0},{"$f":"IF(OR(K86=\" \",B86=\" \"),0,Site!$G$23)","v":0},0,0,{"$f":"IFERROR(C86*E86,\"MISS INFO\")","v":0},{"$f":"IFERROR(C86*F86,\"MISS INFO\")","v":0},0,null,{"$f":"IF(Lighting!N18=\"\",\" \",Lighting!N18)","v":" "},{"$f":"IF(Lighting!O18=\"\",0,Lighting!O18)","v":0},{"$f":"IF(K86=\" \",0,Site!$G$15)","v":0},0,0,0,0,0,null,{"$f":"IF(Lighting!L$18=\"\",0,VLOOKUP(Lighting!L$18,HID_Data1,4,FALSE)*Lighting!M$18)","v":0}]
[null,"TOTAL",{"$f":"SUM(C77:C86)","v":0},{"$f":"MAX(D77:D86)","v":0},{"$f":"SUM(E77:E86)","v":0},{"$f":"SUM(F77:F86)","v":0},{"$f":"C87*E87","v":0},{"$f":"C87*F87","v":0},0,null,"TOTAL",{"$f":"SUM(L77:L86)","v":0},{"$f":"MAX(M77:M86)","v":0},{"$f":"SUM(N77:N86)","v":0},{"$f":"SUM(O77:O86)","v":0},{"$f":"L87*N87","v":0},{"$f":"L87*O87","v":0},0]
[]
[null,"Savings Table",null,null,null,null,"Equivalent Existing # Luminaires",null,null,null,null,"Illuminance Checking"]
[null,"Replacement",null,"Energy (kWh) change","Lumen Change",null,"Proposed Illuminance (lux)",null,{"$f":"IF(Proj_Illum_Units=\"PAR\",(1000/13)*Site!G$19,Site!G$19)","v":0},null,null,null,null,"Customer Baseline","Customer calc.","Virtual Baseline","Customer Prop.","PSE Calculated"]
[null,{"$f":"(IF(AND(B77=\" \",K77=\" \"),\"\",B77&\" -> \"&K77))","v":""},null,{"$f":"IF(K77=\" \",0,IFERROR(R77-I77,\"MISS INFO\"))","v":0},{"$f":"IF(K77=\" \",0,IFERROR(Q77-H77,\"MISS INFO\"))","v":0},null,"Proposed Lit Area (sqm)",null,{"$f":"IF(Proj_Area_Units=\"sqft\",0.0929*Site!G$11,Site!G$11)","v":0},null,null,"Illuminance (lux)",null,{"$f":"IF(Proj_Type=\"Lighting Retrofit (increased illuminance)\",IF(Proj_Illum_Units=\"PAR\",Site!G$17*(1000/13),Site!G$17),IF(Proj_Type=\"Lighting Retrofit (same illuminance)\",I90,\"N/A\"))","v":"N/A"},{"$f":"IF(OR(Proj_Type=\"Lighting Retrofit (same illuminance)\",Proj_Type=\"Lighting Retrofit (increased illuminance)\"),IF(Proj_Area_Units=\"sqft\",O92/(0.0929*Site!G$10),O92/Site!G$10),\"N/A\")","v":"N/A"},{"$f":"I94","v":{"$error":"#VALUE!"}},{"$f":"I90","v":0},{"$f":"Q87/I91","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"(IF(AND(B78=\" \",K78=\" \"),\"\",B78&\" -> \"&K78))","v":""},null,{"$f":"IF(K78=\" \",0,IFERROR(R78-I78,\"MISS INFO\"))","v":0},{"$f":"IF(K78=\" \",0,IFERROR(Q78-H78,\"MISS INFO\"))","v":0},null,"Avg .Equiv. Degraded Lm",null,{"$f":"'Standard Data'!$D30","v":"MISS INFO"},null,null,"Total Degraded Lumens",null,{"$f":"IF(OR(Proj_Type=\"Lighting Retrofit (increased illuminance)\",Proj_Type=\"Lighting Retrofit (same illuminance)\"),IF(Proj_Area_Units=\"sqft\",0.0929*Site!G$10*N91,Site!G$10*N91),\"N/A\")","v":"N/A"},{"$f":"IF(Proj_Type=\"Lighting Retrofit (same illuminance)\",H87,IF(Proj_Type=\"Lighting Retrofit (increased illuminance)\",SUM(T77:T86),\"N/A\"))","v":"N/A"},{"$f":"I92*I93","v":{"$error":"#VALUE!"}},{"$f":"Q91*I91","v":0},{"$f":"Q87","v":0}]
[null,"",null,0,0,null,"Equivalent # Luminaires",null,{"$f":"ROUND(I90*I91/I92,0)","v":{"$error":"#VALUE!"}}]
[null,"",null,0,0,null,"Virtual Baseline (lux)",null,{"$f":"I93*I92/I91","v":{"$error":"#VALUE!"}}]
[null,"",null,0,0]
[null,"",null,0,0]
[null,"",null,0,0]
[null,"",null,0,0]
[null,"",null,0,0]
[null,"",null,0,0,"Luminaire Energy Change",null,"Controls Energy Change"]
[null,"TOTAL",null,{"$f":"IF(ISNUMBER(MATCH(\"MISS INFO\",D91:D100)),\"MISSING INFO!\",SUM(D91:D100))","v":0},{"$f":"IF(ISNUMBER(MATCH(\"MISS INFO\",E91:E100)),\"MISSING INFO!\",SUM(E91:E100))","v":0},{"$f":"(P87-G87)*D87/1000","v":0},null,{"$f":"IF('Standard Data'!H31=FALSE,0,IF('Standard Data'!H31=TRUE,D101-F101,\"NO PROJECT TYPE\"))","v":0}]