{"text_format":"2","workbook":"xls","n_sheets":18,"sheets":["Introduction","Basic Info","Reporting Summary","SIR by Measure","LEED for Homes Mid-Rise Form","Windows eQUEST","Water Savings","DHW Demand","Appliances","Lighting Schedule","In-Unit Lighting","Interior Lighting","Exterior Lighting","Infiltration&Ventilation","EIR for PTAC and PTHP","Results from eQUEST","Simulation Summary","Tables of Values"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":2,"defined_names":10,"comments":13,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Introduction","index":0,"n_rows":57,"n_cols":4,"rows_kept":57,"cut":false,"hidden":false,"merged":[[3,0,3,1],[5,0,5,1],[1,3,5,6],[56,0,64,1]],"flags":["formulas_cached_only"]}
["Performance Path Calculator"]
["Version 1.2",null,null,"OMB Control Number: 2060-0586\nExpiration Date: XX-XX-XXXX\nEPA Form Number: 5900-268"]
[]
["The following worksheets detail the information regarding the recommended scope of work and document the achievement of the 15% Performance Target. Some cells are protected to prevent accidental over-writing of formulas. "]
[]
["Note that throughout these worksheets, common information from cells are linked and should automatically update.  Only cells shaded in blue need to be entered manually. Entering values into white or orange cells will override pre-determined formulas."]
[]
["Basic Info"]
[null,"In blue cells only, enter the basic information about the building (number of units, square footage of the apartments and commercial spaces, type of garage (if applicable) and indicate the level of space conditioning in each zone). All other square footages will auto-fill after completion of the Interior Lighting worksheet."]
[]
["Reporting Summary"]
[null,"In blue cells only, enter general information about the project, the model and specifics about the ASHRAE compliant components of the Baseline Building and the energy efficient components in the Proposed Design."]
[]
["SIR by Measure"]
[null,"Although not required by the EPA to earn the ENERGY STAR, if incremental costs are entered, this worksheet can be used to determine the cost effectiveness for each recommended measure and for the project as a whole."]
[]
["LEED for Homes Mid-Rise Form"]
[null,"For projects pursuing LEED for Homes Mid-Rise certification, enter data in blue cells only. This form has been provided by the USGBC and can be used in submittals for that program."]
[]
["Windows eQUEST"]
[null,"For eQUEST users only, this calculates the Shading Coefficient for entry into eQUEST and modifies the NFRC U-factor to exclude the air-film."]
[]
["Water Savings"]
[null,"By entering data in blue cells only, this worksheet will calculate the water savings in gallons based on the proposed flow rates entered. This information does not affect the Performance Rating but can be used when calculating SIR to justify measures that reduce consumption of water."]
[]
["DHW Demand"]
[null,"Enter in occupancy usage characteristic (low/medium/high) and information about the appliances that consume water in the building. You must enter data in the Basic Info and Water Savings tab, prior to this tab."]
[]
["Appliances"]
[null,"Enter data in blue cells. Values are calculated in W/SF or kWh/yr for entry into software."]
[]
["Lighting Schedule"]
[null,"Developed for eQUEST users, but can be used with other software to translate total operating hours/day into an hourly schedule that meets the requirements from the Simulation Guidelines."]
[]
["In-Unit Lighting"]
[null,"Enter details and counts of installed lighting fixtures in apartments only. Square footage not illuminated by these fixtures will have a default lighting power density of 1.1 W/Sf assigned to both baseline and proposed. Installed fixtures in rooms where supplemental light will be provided by the occupant or through switched outlets, shall not be modeled as providing illumination for the entire room. Overall lighting power density is calculated on this worksheet for input into software."]
[]
["Interior Lighting"]
[null,"Using floor plans, a lighting schedule, and lighting cut sheets, fill in the details of this worksheet. This will sum the square footages by ASHRAE space type for reporting purposes on the Basic Info tab, and calculate the lighting power density to be modeled per room. It also provides the maximum wattage allowed by ASHRAE 90.1 for that room, which can be more useful to the design team than the lighting power density. To help project compliance with program Prerequisites, zones are highlighted in red that exceed ASHRAE LPD’s by more than 20%, which reduce the energy savings of the building, as well as zones that have insufficient illumination. "]
[]
["Exterior Lighting"]
[null,"Enter details in blue cells only on exterior areas to be illuminated. The total wattage will be provided for input into the simulation software."]
[]
["Infiltration&Ventilation"]
[null,"Although developed initially for eQUEST users, the approach can be used for other simulation software if needed. The approach allows for infiltration and exhaust in apartments to be combined in the worksheet and a combined value to be entered into the software."]
[]
["EIR for PTAC or PTHP"]
[null,"Although developed initially for eQUEST users, the approach can be used for other simulation software if the energy efficiency of these systems are entered in terms of EIR, rather than EER."]
[]
["Results from eQUEST"]
[null,"For eQUEST users only, this worksheet is based upon the Parms.csv file that is generated upon simulation of your building. If those results are pasted into this worksheet, according to the directions, the performance rating will automatically calculate in the Simulation Summary worksheet. "]
[]
["Simulation Summary"]
[null,"This worksheet requires you to enter the fuel prices in order to calculate the overall energy cost savings, which are required to demonstrate achievement of the Performance Target.  This tab links to the Results eQUEST tab and is based on natural gas or electric heat. To use oil, modifications to this tab would be needed."]
[]
[]
["This collection of information is approved by OMB under the Paperwork Reduction Act, 44 U.S.C. 3501 et seq. (OMB Control No. 2060-0586). Responses to this collection of information are voluntary. An agency may not conduct or sponsor, and a person is not required to respond to, a collection of information unless it displays a currently valid OMB control number. The public reporting and recordkeeping burden for this collection of information is estimated to be 1 hour per response. Send comments on the Agency’s need for this information, the accuracy of the provided burden estimates and any suggested methods for minimizing respondent burden including through the use of automated collection techniques to the Director, Regulatory Support Division, U.S. Environmental Protection Agency (2821T), 1200 Pennsylvania Ave., NW, Washington, D.C. 20460.  Include the OMB control number in any correspondence.  Do not send the completed form to this address."]

{"sheet":"Basic Info","index":1,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"Instructions:"]
[1,"First fill in the Interior Lighting tab (this information will populate the square footages for this table)"]
[2,"Only fill in cells highlighted with this color."]
[null,"Basic Project Information"]
[{"$nulls":8},"None"]
[null,"Number of Units (per building)",{"$nulls":6},"Under Ground Garage"]
[null,"Studio",{"$nulls":6},"Above Ground Garage"]
[null,"1 - Bedroom",{"$nulls":6},"Parking Lot"]
[null,"2 - Bedroom"]
[null,"3 - Bedroom",{"$nulls":6},"Heated & Cooled"]
[null,"4 - Bedroom",{"$nulls":6},"Heated-Only"]
[{"$nulls":8},"Cooled-Only"]
[null,"Building Areas (per building)",{"$nulls":6},"Unconditioned"]
[null,"Building Area","Total Square Ft","Conditioned?",null,"Lighting (W/sf)"]
[null,"Apartment",null,null,"",{"$error":"#DIV/0!"}]
[null,"Storage, active",0,null,"",{"$error":"#DIV/0!"}]
[null,"Storage, inactive",0,null,"",{"$error":"#DIV/0!"}]
[null,"Lobby",0,null,"",{"$error":"#DIV/0!"}]
[null,"Corridor/Transition",0,null,"",{"$error":"#DIV/0!"}]
[null,"Stairs - Active",0,null,"",{"$error":"#DIV/0!"}]
[null,"Restroom",0,null,"",{"$error":"#DIV/0!"}]
[null,"Office",0,null,"",{"$error":"#DIV/0!"}]
[null,"Conference/meeting/multipurpose",0,null,"",{"$error":"#DIV/0!"}]
[null,"Electrical/Mechanical",0,null,"",{"$error":"#DIV/0!"}]
[null,"Workshop",0,null,"",{"$error":"#DIV/0!"}]
[null,"Parking garage",0,"Unconditioned",null,{"$error":"#DIV/0!"}]
[null,"Nonresidential Spaces (ie. commercial)",null,null,""]
[null,null,0,null,""]
[]
[null,"Type of Garage"]

{"sheet":"Reporting Summary","index":2,"n_rows":143,"n_cols":42,"rows_kept":143,"cut":false,"hidden":false,"merged":[[113,8,113,9],[111,10,111,11],[112,10,112,11],[113,10,113,11],[105,15,105,16],[109,4,109,5],[109,6,109,7],[108,10,108,11],[107,10,107,11],[111,8,111,9],[112,8,112,9],[105,1,105,2],[109,1,109,2],[105,4,105,5],[105,6,105,7],[105,8,105,9],[106,1,106,11],[109,8,109,9],[109,10,109,11],[107,8,107,9],[108,8,108,9],[19,8,19,11],[20,8,20,11],[21,8,21,11],[22,8,22,11],[45,1,45,11],[57,7,57,11],[47,1,47,2],[49,1,49,2],[50,1,50,2],[51,1,51,2],[125,10,125,11],[100,1,100,2],[113,4,113,5],[91,6,91,7],[103,6,103,7],[97,4,97,5],[104,6,104,7],[108,4,108,5],[96,6,96,7],[129,10,129,11],[127,10,127,11],[121,9,122,9],[128,10,128,11],[98,4,98,5],[126,10,126,11],[103,4,103,5],[107,6,107,7],[104,4,104,5],[100,6,100,7],[23,6,23,7],[123,10,123,11],[124,10,124,11],[75,4,75,6],[113,6,113,7],[102,6,102,7],[56,4,56,6],[121,2,121,4],[23,8,23,11],[111,4,111,5],[1,1,2,11],[6,8,6,11],[7,8,7,11],[8,8,8,11],[9,8,9,11],[10,8,10,11],[7,3,7,5],[10,6,10,7],[9,3,9,5],[6,6,6,7],[98,6,98,7],[95,4,95,5],[95,6,95,7],[100,4,100,5],[108,6,108,7],[13,8,13,11],[85,4,85,6],[24,8,24,11],[25,8,25,11],[26,8,26,11],[27,8,27,11],[16,3,16,5],[15,3,15,5],[15,8,15,11],[16,8,16,11],[93,1,93,2],[91,1,91,2],[90,1,90,11],[92,1,92,2],[16,1,16,2],[102,1,102,2],[99,6,99,7],[94,6,94,7],[96,4,96,5],[99,8,99,9],[100,8,100,9],[96,1,96,2],[94,1,94,2],[94,4,94,5],[94,8,94,9],[7,6,7,7],[8,3,8,5],[8,6,8,7],[6,3,6,5],[93,4,93,5],[93,6,93,7],[44,7,44,11],[29,8,29,11],[30,8,30,11],[92,6,92,7],[52,1,52,2],[67,1,67,11],[40,1,40,3],[9,1,9,2],[29,1,29,2],[21,1,21,2],[24,1,24,2],[25,6,25,7],[15,6,15,7],[13,1,13,2],[63,7,63,11],[64,7,64,11],[68,7,68,11],[61,7,61,8],[89,4,89,5],[89,6,89,7],[86,4,86,6],[84,4,84,6],[86,7,86,11],[83,1,83,11],[37,1,37,3],[36,1,36,3],[35,1,35,3],[31,1,31,2],[48,1,48,2],[44,4,44,6],[39,1,39,3],[44,1,44,2],[46,4,46,6],[41,1,41,3],[54,7,54,11],[55,7,55,11],[56,7,56,11],[82,1,82,2],[79,1,79,2],[55,4,55,6],[54,4,54,6],[54,1,54,2],[82,4,82,6],[63,4,63,6],[30,1,30,2],[20,6,20,7],[13,6,13,7],[24,3,24,5],[25,3,25,5],[26,3,26,5],[20,1,20,2],[27,3,27,5],[26,6,26,7],[27,6,27,7],[46,7,46,11],[48,7,48,11],[9,6,9,7],[10,3,10,5],[38,1,38,3],[19,3,19,5],[14,6,14,7],[16,6,16,7],[13,3,13,5],[34,1,34,3],[14,8,14,11],[14,1,14,2],[19,1,19,2],[14,3,14,5],[20,3,20,5],[21,3,21,5],[15,1,15,2],[48,4,48,6],[53,1,53,2],[53,4,53,6],[21,6,21,7],[22,6,22,7],[23,3,23,5],[53,7,53,11],[33,1,33,5],[22,3,22,5],[31,8,31,11],[121,10,122,11],[73,1,73,2],[69,7,69,11],[91,8,91,9],[110,1,110,11],[55,1,55,2],[75,1,75,2],[61,5,61,6],[68,4,68,6],[73,4,73,6],[85,7,85,11],[92,4,92,5],[69,4,69,6],[78,4,78,6],[86,1,86,2],[91,4,91,5],[77,4,77,6],[80,1,80,11],[78,1,78,2],[73,7,73,11],[57,4,57,6],[60,4,60,6],[63,1,63,2],[97,1,97,2],[95,1,95,2],[84,1,84,2],[76,4,76,6],[76,1,76,2],[72,1,72,2],[65,1,65,2],[56,1,56,2],[25,1,25,2],[121,6,121,8],[6,1,6,2],[7,1,7,2],[8,1,8,2],[10,1,10,2],[27,1,27,2],[46,1,46,2],[57,1,57,2],[59,1,59,2],[58,1,58,11],[62,4,62,6],[61,9,61,11],[62,7,62,11],[60,1,60,2],[60,7,60,8],[60,9,60,11],[62,1,62,2],[61,1,61,2],[81,1,81,2],[75,7,75,11],[64,1,64,2],[69,1,69,2],[68,1,68,2],[66,4,66,6],[79,4,79,6],[64,4,64,6],[74,1,74,11],[77,7,77,11],[94,10,94,11],[89,8,89,9],[89,10,89,11],[71,1,71,2],[65,7,65,11],[66,7,66,11],[82,7,82,11],[84,7,84,11],[65,4,65,6],[66,1,66,2],[112,4,112,5],[81,4,81,6],[97,6,97,7],[76,7,76,11],[78,7,78,11],[79,7,79,11],[81,7,81,11],[91,10,91,11],[92,10,92,11],[93,10,93,11],[99,4,99,5],[99,1,99,2],[102,4,102,5],[101,1,101,11],[105,10,105,11],[113,1,113,2],[111,1,111,2],[112,6,112,7],[112,1,112,2],[111,6,111,7],[103,8,103,9],[104,8,104,9],[98,8,98,9],[95,8,95,9],[99,10,99,11],[108,1,108,2],[104,1,104,2],[107,1,107,2],[107,4,107,5],[103,1,103,2],[102,10,102,11],[103,10,103,11],[96,8,96,9],[97,8,97,9],[130,10,130,11],[95,10,95,11],[96,10,96,11],[104,10,104,11],[98,10,98,11],[102,8,102,9],[131,10,131,11],[59,7,59,8],[59,9,59,11],[70,1,70,2],[70,4,70,6],[70,7,70,11],[97,10,97,11],[92,8,92,9],[93,8,93,9],[100,10,100,11],[47,4,47,6],[47,7,47,11],[49,4,49,6],[50,4,50,6],[51,4,51,6],[52,4,52,6],[49,7,49,11],[50,7,50,11],[51,7,51,11],[52,7,52,11]],"flags":["formulas_cached_only"]}
[]
[null,"ENERGY STAR Multifamily High Rise\nReporting Summary, Version 1.2"]
[]
[]
[]
[null,"Table 1. General Project Information"]
[null,"Current Project Status:",{"$nulls":4},"Builder / Developer:"]
[null,"Estimated Construction Completion Date (mo/yr):",{"$nulls":4},"Name of contact:"]
[null,"Project Name:",{"$nulls":4},"Phone:"]
[null,"Project Address:",{"$nulls":4},"E-mail:"]
[null,"Project City, State, Zip:"]
[]
[null,"Table 2. Modeling Information"]
[null,"Modeler:",{"$nulls":4},"Simulation Program & Version #:"]
[null,"Company:",{"$nulls":4},"Baseline:"]
[null,"Phone:",{"$nulls":4},"Weather File Location (City, ST):"]
[null,"E-mail:",{"$nulls":4},"Climate Zone:"]
[]
[null,"Table 3. Building Information"]
[null,"# of stories",{"$nulls":4},"Total bldg ft2:",null,0]
[null,"Space heating fuel:",{"$nulls":4},"Residential",null,0]
[null,"DHW fuel:",{"$nulls":4},"Common space",null,0]
[null,"Heating system:",{"$nulls":4},"Commercial",null,0]
[null,"Cooling system:",{"$nulls":4},"Other",null,0]
[null,"Ventilation system:",{"$nulls":4},"Conditioned ft2:",null,0]
[null,"DHW System:",{"$nulls":4},"Heated & cooled",null,0]
[{"$nulls":6},"Heated-only",null,0]
[{"$nulls":6},"Cooled-only",null,0]
[]
[null,"Apartment type",null,"Studio","1-BR","2-BR","3-BR","4-BR","Total"]
[null,"# of apartments",null,0,0,0,0,0,0]
[null,"Average ft2",null,"NA","NA","NA","NA","NA",{"$error":"#DIV/0!"}]
[]
[null,"Table 4. ENERGY STAR Portfolio Manager Input"]
[null,"Gross Floor Area",null,null,0,"Notes"]
[null,"Number of bedrooms ",null,null,0]
[null,"Number of Floors",null,null,0]
[null,"Number of in-apartment laundry hookups ",null,null,0]
[null,"Number of common area laundry hookups ",null,null,0]
[null,"Number of dishwashers ",null,null,0]
[null,"% gross floor area that is heated",null,null,{"$error":"#DIV/0!"}]
[null,"% gross floor area that is cooled",null,null,{"$error":"#DIV/0!"}]
[]
[null,"Table 5. Comparison of Inputs"]
[null,"Model Input Parameter",null,"Example Unit","Baseline Design\n(provide description and specification)",null,null,"Proposed Final Design\n(provide description and specification)"]
[null,"Building envelope",{"$nulls":33},"None Installed",null,"% AFUE","SEER","Title 24","1A","Whole Building"]
[null,"Ext. wall construction (above grade)",null,"U-factor or R",{"$nulls":31},"Non-ENERGY STAR",null,"HSPF","EER","90.1-2007","1B","Unit-by-Unit"]
[null,"Ext. wall construction (below grade)",null,"C-factor or R",{"$nulls":31},"ENERGY STAR",null,"%Et",null,"90.1-2010","2A","Mixed"]
[null,"Floor construction",null,"U-factor or R",{"$nulls":33},"%Ec",null,"Other","2B","None Installed"]
[null,"Slab-on-grade construction (unheated)",null,"F-factor",{"$nulls":33},"COP",null,null,"2C"]
[null,"Slab-on-grade construction (embedded heat)",null,"F-factor",{"$nulls":36},"3A"]
[null,"Slab-below grade construction",null,"C-factor",{"$nulls":36},"3B"]
[null,"Roof construction",null,"U-factor or R",{"$nulls":36},"3C"]
[null,"Window/wall area ratio",null,"%",{"$nulls":36},"4A"]
[null,"Window type and U-factor",null,"U-factor",{"$nulls":36},"4B"]
[null,"Window SHGC",null,"SHGC",{"$nulls":36},"4C"]
[null,"Shading devices",{"$nulls":38},"5A"]
[null,"Doors",null,"U-factor",{"$nulls":36},"5B"]
[null,"Lighting & appliances",{"$nulls":38},"5C"]
[null,"In-unit lighting power density",null,"W/ft2",null,1.1,"W/SF",{"$error":"#DIV/0!"},null,"W/SF",{"$nulls":30},"6A"]
[null,"Corridor lighting power density",null,"W/ft2","0.5 W/SF",null,null,{"$error":"#DIV/0!"},null,"W/SF",{"$nulls":30},"6B"]
[null,"Other interior lighting",null,"W/ft2",{"$error":"#DIV/0!"},"W/SF, per ASHRAE 90.1, Table 9.6.1",null,{"$error":"#DIV/0!"},null,"W/SF",null,null,{"$error":"#DIV/0!"},{"$nulls":27},7]
[null,"Exterior lighting",null,"W",0,null,null,0,{"$nulls":32},8]
[null,"Lighting controls"]
[null,"Refrigerator",null,"ENERGY STAR?"]
[null,"Dishwasher",null,"ENERGY STAR?"]
[null,"Clothes Washer",null,"ENERGY STAR?"]
[null,"HVAC System"]
[null,"Primary HVAC system type"]
[null,"Apartment Ventilation System"]
[null,"Corridor Outdoor Air Supply",null,"CFM/ft2"]
[null,"Primary System Heating efficiency",null,"AFUE / HSPF"]
[null,"Primary System Cooling efficiency",null,"SEER / EER"]
[null,"Fan supply power",null,"kW"]
[null,"Domestic Hot Water System"]
[null,"Equipment efficiency",null,"EF, %Et"]
[null,"Kitchen Faucets",null,"GPM","2.5 @ 80 psi",null,null,0]
[null,"Lavatory Faucets",null,"GPM","2.5 @ 80 psi",null,null,0]
[null,"Showerheads",null,"GPM","2.5 @ 80psi",null,null,0]
[null,"Solar DHW system",null,"% of load"]
[null,"Renewable Electric Generation System"]
[null,"Type of system"]
[null,"Rated capacity",null,"kW"]
[null,"Other"]
[]
[]
[]
[]
[null,"Table 6. Comparison of Estimated Consumption"]
[null,"End Use",null,"Units","Baseline \nAnnual Consumption ",null,"Proposed Design \nAnnual Consumption",null,"% Savings\nby end-use",null,"% Savings\ntoward Target"]
[null,"Electric loads"]
[null,"Ventilation fans",null,"kWh",{"$error":"#DIV/0!"},null,0,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,"Space heating",null,"kWh",{"$error":"#DIV/0!"},null,0,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,"Space cooling",null,"kWh",{"$error":"#DIV/0!"},null,0,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,"Domestic hot water",null,"kWh",{"$error":"#DIV/0!"},null,0,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,"Interior lighting",null,"kWh",{"$error":"#DIV/0!"},null,0,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,"Exterior lighting",null,"kWh",0,null,0,null,"NA",null,{"$error":"#DIV/0!"}]
[null,"Appliances",null,"kWh",{"$error":"#DIV/0!"},null,0,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,"Pumps and Aux",null,"kWh",{"$error":"#DIV/0!"},null,0,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,"Other exterior",null,"kWh",{"$error":"#DIV/0!"},null,0,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,"Plug loads",null,"kWh",0,null,0,null,"NA",null,{"$error":"#DIV/0!"}]
[null,"Gas loads"]
[null,"Space heating",null,"MMbtu",{"$error":"#DIV/0!"},null,0,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,"Domestic hot water",null,"MMbtu",{"$error":"#DIV/0!"},null,0,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,"Appliances",null,"MMbtu",{"$error":"#DIV/0!"},null,0,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,"Other",null,"MMbtu",{"$error":"#DIV/0!"},null,0,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,"Fuel oil loads"]
[null,"Space heating",null,"MMbtu",{"$nulls":4},"NA",null,{"$error":"#DIV/0!"}]
[null,"Domestic hot water",null,"MMbtu",{"$nulls":4},"NA",null,{"$error":"#DIV/0!"}]
[null,"Other",null,"MMbtu",{"$nulls":4},"NA",null,{"$error":"#DIV/0!"}]
[null,"Totals"]
[null,"Electric loads",null,"kWh",{"$error":"#DIV/0!"},null,0,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,"Gas loads",null,"MMbtu",{"$error":"#DIV/0!"},null,0,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,"Oil loads",null,"MMbtu",0,null,0,null,"NA",null,{"$error":"#DIV/0!"}]
[]
[null,"Table 7. Fuel Cost"]
[null,"Electricity",0,"$/kWh"]
[null,"Natural Gas",0,"$/Therm"]
[null,"Fuel Oil",0,"$/Gallon"]
[]
[null,"Table 8. Performance Rating Calculation"]
[null,null,"Baseline",null,null,null,"Proposed",null,null,"BTU Savings, %","$ Savings, %"]
[null,null,"Fossil Fuel, Btu","Electricity, Btu","Cost, $",null,"Fossil Fuel, Btu","Electricity, Btu","Cost, $"]
[null,"Annual Heating",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Annual Cooling ",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Annual Lighting",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Annual Hot Water",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Annual Appliance",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Annual Other",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Total without Renewable",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Annual Renewable",0,0,0,null,0,0,0,0,0]
[null,"Total with Renewable",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,"Table 9. Energy Usage per Square Foot of Conditioned Area"]
[null,null,"Baseline","Proposed"]
[null,null,"Btu/SqFt","Btu/SqFt"]
[null,"Annual Heating",0,0]
[null,"Annual Cooling ",0,0]
[null,"Annual Lighting",0,0]
[null,"Annual Hot Water",0,0]
[null,"Annual Appliance",0,0]
[null,"Annual Other",0,0]
[null,"Total without Renewable",0,0]

{"sheet":"SIR by Measure","index":3,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":false,"merged":[[7,14,9,14],[8,7,8,8],[7,13,9,13]],"flags":["formulas_cached_only"]}
[null,"Instructions: "]
[1,"Enter each measure and the corresponding baseline and proposed costs."]
[2,"Use the SAME order as the parametric runs copied in the Results from eQuest worksheet."]
[]
[null,"Discount Rate:",0.03]
[]
["Energy Reduction Measures and Incremental Hard Costs"]
[null,null,"Baseline Components",null,"Proposed Components",{"$nulls":4},"Incremental Metrics",null,null,null,"Lifecycle Savings","Weighted Lifetime"]
[null,"Parametric Run","Description","Baseline Cost","Description","Proposed Cost","Lifetime","Energy Savings",null,"Costs","Cost Savings","Payback","S.I.R."]
[{"$nulls":6},"years","MMBtu","kWh",null,"$","years"]
[1,0,{"$nulls":5},0,0,0,0,0,0,0,0]
[2,0,{"$nulls":5},0,0,0,0,0,0,0,0]
[3,0,{"$nulls":5},0,0,0,0,0,0,0,0]
[4,0,{"$nulls":5},0,0,0,0,0,0,0,0]
[5,0,{"$nulls":5},0,0,0,0,0,0,0,0]
[6,0,{"$nulls":5},0,0,0,0,0,0,0,0]
[7,0,{"$nulls":5},0,0,0,0,0,0,0,0]
[8,0,{"$nulls":5},0,0,0,0,0,0,0,0]
[9,0,{"$nulls":5},0,0,0,0,0,0,0,0]
[10,0,{"$nulls":5},0,0,0,0,0,0,0,0]
[11,0,{"$nulls":5},0,0,0,0,0,0,0,0]
[12,0,{"$nulls":5},0,0,0,0,0,0,0,0]
[13,0,{"$nulls":5},0,0,0,0,0,0,0,0]
[14,0,{"$nulls":5},0,0,0,0,0,0,0,0]
[15,0,{"$nulls":5},0,0,0,0,0,0,0,0]
[16,0,{"$nulls":5},0,0,0,0,0,0,0,0]
[17,0,{"$nulls":5},0,0,0,0,0,0,0,0]
[18,0,{"$nulls":5},0,0,0,0,0,0,0,0]
[19,0,{"$nulls":5},0,0,0,0,0,0,0,0]
[20,0,{"$nulls":5},0,0,0,0,0,0,0,0]
[21,0,{"$nulls":5},0,0,0,0,0,0,0,0]
[]
[{"$nulls":7},0,0,null,0,null,null,0,{"$error":"#DIV/0!"}]
[{"$nulls":9},0,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]

{"sheet":"LEED for Homes Mid-Rise Form","index":4,"n_rows":184,"n_cols":30,"rows_kept":184,"cut":false,"hidden":true,"merged":[[41,8,41,10],[179,2,179,3],[179,5,179,6],[179,7,179,8],[180,2,180,9],[181,2,181,3],[181,5,181,6],[181,7,181,8],[177,2,177,9],[178,2,178,3],[182,2,182,3],[182,5,182,6],[182,7,182,8],[183,2,183,3],[183,5,183,6],[183,7,183,8],[178,5,178,6],[178,7,178,8],[175,2,175,3],[175,5,175,6],[175,7,175,8],[176,2,176,3],[176,5,176,6],[176,7,176,8],[173,2,173,9],[174,2,174,3],[174,5,174,6],[174,7,174,8],[171,2,171,3],[171,5,171,6],[171,7,171,8],[172,2,172,3],[172,5,172,6],[172,7,172,8],[170,2,170,3],[170,5,170,6],[170,7,170,8],[168,5,168,6],[168,2,168,3],[168,7,168,8],[169,2,169,3],[169,5,169,6],[169,7,169,8],[165,2,165,3],[165,5,165,6],[165,7,165,8],[166,2,166,3],[166,5,166,6],[166,7,166,8],[167,2,167,3],[167,5,167,6],[167,7,167,8],[157,2,157,3],[158,2,158,3],[159,2,159,3],[162,5,162,6],[162,7,162,8],[163,2,163,9],[164,2,164,3],[164,7,164,8],[148,2,148,3],[149,2,149,9],[150,2,150,3],[151,2,151,3],[152,2,152,3],[153,2,153,9],[154,2,154,3],[155,2,155,3],[143,2,143,3],[144,2,144,3],[145,2,145,3],[146,2,146,3],[147,2,147,3],[164,5,164,6],[133,7,133,10],[130,1,130,2],[130,4,130,6],[130,7,130,10],[131,1,131,10],[156,2,156,9],[139,2,139,9],[140,2,140,3],[141,2,141,3],[142,2,142,3],[126,7,126,10],[127,1,127,2],[127,7,127,10],[134,1,134,2],[134,4,134,6],[134,7,134,10],[133,4,133,6],[132,1,132,2],[132,4,132,6],[132,7,132,10],[122,1,122,10],[123,1,123,2],[123,4,123,6],[123,7,123,10],[128,1,128,10],[129,1,129,2],[129,4,129,6],[129,7,129,10],[126,1,126,2],[126,4,126,6],[124,1,124,2],[124,4,124,6],[124,7,124,10],[125,1,125,2],[125,4,125,6],[125,7,125,10],[119,1,119,2],[119,4,119,6],[119,7,119,10],[120,1,120,2],[120,4,120,6],[120,7,120,10],[121,1,121,2],[121,4,121,6],[121,7,121,10],[116,1,116,2],[116,4,116,6],[116,7,116,10],[117,1,117,2],[117,4,117,6],[117,7,117,10],[118,1,118,2],[118,4,118,6],[118,7,118,10],[113,1,113,2],[113,4,113,6],[113,7,113,10],[114,1,114,2],[115,1,115,2],[109,7,109,10],[106,4,106,6],[110,1,110,2],[110,4,110,6],[110,7,110,10],[111,1,111,2],[111,4,111,6],[111,7,111,10],[102,7,102,10],[104,7,104,10],[112,1,112,2],[104,1,104,2],[105,1,105,2],[106,1,106,2],[107,1,107,2],[108,1,108,10],[109,1,109,2],[109,4,109,6],[98,4,98,6],[98,7,98,10],[107,4,107,6],[106,7,106,10],[107,7,107,10],[99,1,99,2],[100,1,100,2],[101,1,101,2],[102,1,102,2],[103,1,103,2],[96,4,96,6],[96,7,96,10],[97,1,97,2],[94,1,94,2],[95,1,95,2],[95,4,95,6],[95,7,95,10],[97,4,97,6],[97,7,97,10],[90,1,90,2],[90,4,90,6],[90,7,90,10],[91,1,91,2],[91,4,91,6],[91,7,91,10],[93,1,93,2],[93,4,93,6],[93,7,93,10],[92,7,92,10],[92,4,92,6],[98,1,98,2],[94,4,94,6],[94,7,94,10],[92,1,92,2],[96,1,96,2],[87,1,87,2],[87,4,87,6],[87,7,87,10],[88,1,88,2],[88,4,88,6],[88,7,88,10],[89,1,89,2],[89,4,89,6],[89,7,89,10],[83,1,83,2],[83,4,83,6],[83,7,83,10],[84,1,84,2],[84,7,84,10],[85,1,85,10],[86,1,86,2],[86,4,86,6],[86,7,86,10],[84,4,84,6],[80,1,80,2],[80,4,80,6],[80,7,80,10],[81,1,81,2],[81,4,81,6],[81,7,81,10],[82,1,82,2],[82,4,82,6],[82,7,82,10],[76,1,76,10],[77,1,77,2],[77,4,77,6],[77,7,77,10],[78,1,78,2],[78,4,78,6],[78,7,78,10],[79,1,79,2],[72,1,72,2],[72,4,72,6],[73,1,73,2],[73,4,73,6],[79,4,79,6],[79,7,79,10],[75,1,75,2],[75,4,75,6],[75,7,75,10],[74,7,74,10],[73,7,73,10],[72,7,72,10],[65,2,65,3],[69,1,69,2],[69,4,69,6],[69,7,69,10],[70,1,70,10],[71,1,71,2],[71,4,71,6],[71,7,71,10],[74,1,74,2],[74,4,74,6],[60,4,60,5],[60,6,60,7],[60,8,60,9],[61,2,61,3],[61,4,61,5],[61,6,61,7],[61,8,61,9],[63,2,63,3],[64,2,64,3],[57,2,57,3],[57,4,57,5],[59,2,59,3],[59,4,59,5],[57,6,57,7],[57,8,57,9],[58,2,58,3],[58,4,58,5],[58,6,58,7],[58,8,58,9],[59,6,59,7],[59,8,59,9],[54,2,54,3],[54,4,54,5],[54,6,54,7],[54,8,54,9],[55,2,55,3],[55,4,55,5],[55,6,55,7],[55,8,55,9],[48,1,48,2],[48,3,48,5],[48,6,48,7],[48,8,48,10],[56,2,56,3],[56,4,56,5],[56,6,56,7],[56,8,56,9],[53,2,53,3],[53,4,53,5],[53,6,53,7],[53,8,53,9],[49,1,49,2],[49,3,49,5],[49,6,49,7],[49,8,49,10],[32,1,34,4],[47,1,47,2],[47,3,47,5],[47,6,47,7],[47,8,47,10],[46,1,46,2],[46,3,46,5],[46,6,46,7],[46,8,46,10],[41,3,41,5],[16,1,16,10],[17,2,17,10],[31,7,31,10],[1,1,2,10],[6,1,9,10],[26,7,26,10],[27,1,29,4],[27,7,27,10],[28,7,28,10],[22,2,22,10],[3,0,3,11],[10,1,10,10],[11,1,11,10],[12,1,12,10],[13,1,13,10],[14,1,14,10],[38,1,38,2],[38,3,38,5],[38,6,38,7],[38,8,38,10],[18,2,18,10],[19,2,19,10],[20,2,20,10],[21,2,21,10],[32,7,32,10],[33,7,33,10],[39,1,39,2],[39,3,39,5],[104,4,104,6],[102,4,102,6],[99,4,99,6],[40,1,40,2],[41,1,41,2],[42,1,42,2],[42,3,42,5],[42,6,42,7],[99,7,99,10],[100,4,100,6],[100,7,100,10],[39,6,39,7],[39,8,39,10],[40,3,40,5],[40,6,40,7],[40,8,40,10],[41,6,41,7],[42,8,42,10]],"flags":["formulas_cached_only"]}
[]
[null,"LEED for Homes Mid-rise Pilot \nEnergy Model Information Form"]
[]
["March 2010 Update"]
[]
[null,"Instructions:"]
[null,"Please provide the information in the following tables. This information should be provided by the energy modeler with input from the project team. This form should be submitted to USGBC at the end of design (after completion of CDs), then updated upon final construction and on-site verification. "]
[]
[]
[]
[null,"In addition to this form, every project must submit the following:"]
[null,"1) sample input summary reports, \n2) output reports showing consumption by end-use, energy cost by fuel, and unmet load hours.\n3) calculations for appliances, domestic hot water, and lighting, as per the EPA Multifamily High Rise Program Simulation Guidelines, published November 2009\n4) calculations related to renewable energy use (California projects only)"]
[null,"2) output reports showing consumption by end-use, energy cost by fuel, and unmet load hours.\n3) calculations for appliances, domestic hot water, and lighting, as per the EPA Multifamily High Rise Program Simulation Guidelines, published November 2009\n4) calculations related to renewable energy use (California projects only)"]
[null,"3) calculations for appliances, domestic hot water, and lighting, as per the EPA Multifamily High Rise Program \n     Simulation Guidelines, published November 2009."]
[null,"4) calculations related to renewable energy use (California projects only)"]
[]
[null,"Examples of reports include: "]
[null,"TREAT:","TREAT Input, TREAT Output, NYSERDA Spreadsheets for TREAT"]
[null,"DOE-2:","BEPS, BEPU, ES-D"]
[null,"EnergyPro:","PERF-1, UTIL-1, ECON-1, Mid-Rise Title 24 Spreadsheet"]
[null,"TRACE:","Entered Values, Energy Cost Budget, Energy Consumption Summary, Equipment Energy Consumption"]
[null,"HAP:","Annual Cost Summary, Energy Cost Budget by System Component, Unmet Load Report"]
[null,"HAP v4.4:","LEED NC 2.2 EA Credit 1 Summary Report"]
[]
[]
[]
[null,"Sign-off by energy modeler",{"$nulls":4},"Signature:"]
[null,"I hereby verify that the information provided in the tables below is accurate and complete, to the best of my knowledge.",{"$nulls":4},"Name:"]
[{"$nulls":6},"Date:"]
[]
[]
[null,"Sign-off by project team leader",{"$nulls":4},"Signature:"]
[null,"I hereby verify that the information provided in the tables below is accurate and complete, to the best of my knowledge.",{"$nulls":4},"Name:"]
[{"$nulls":6},"Date:"]
[]
[]
[]
[null,"Table 1. General Project Information"]
[null,"Current Project Status:",null,0,null,null,"Builder / Developer:",null,0]
[null,"End Date (mo/yr):",null,"00:00:00",null,null,"Name of contact:",null,0]
[null,"Project Name:",null,0,null,null,"Phone:",null,0]
[null,"Project Address:",null,0,null,null,"E-mail:",null,0]
[null,"Project City, State:",null,0]
[]
[]
[null,"Table 2. Modeling Information"]
[null,"Modeler:",null,0,null,null,"Simulation Program:",null,0]
[null,"Company:",null,0,null,null,"Baseline:",null,0]
[null,"Phone:",null,0,null,null,"Weather File:",null,0]
[null,"E-mail:",null,0]
[]
[]
[null,null,"Table 3. Building Information"]
[null,null,"# of stories",null,0,null,"Total bldg ft2:",null,0]
[null,null,"Space heating fuel:",null,0,null,"Residential",null,0]
[null,null,"DHW fuel:",null,0,null,"Common space",null,0]
[null,null,"Heating system type:",null,0,null,"Commercial",null,0]
[null,null,"Cooling system type:",null,0,null,"Other",null,0]
[null,null,"Ventilation system type:",null,0,null,"Conditioned ft2:",null,0]
[{"$nulls":6},"Heated & cooled",null,0]
[{"$nulls":6},"Heated-only",null,0]
[{"$nulls":6},"Cooled-only",null,0]
[]
[null,null,"Apartment type",null,"Studio","1-BR","2-BR","3-BR","4-BR","Total"]
[null,null,"# of apartments",null,0,0,0,0,0,0]
[null,null,"Average ft2",null,"NA","NA","NA","NA","NA",{"$error":"#DIV/0!"}]
[]
[]
[null,"Table 4. Comparison of Inputs"]
[null,"Model Input Parameter",null,"Example Unit","Baseline Design\n(provide description and specification)",null,null,"Proposed Final Design\n(provide description and specification)"]
[null,"Schedules"]
[null,"Heating temp (occ/unocc)",null,"°F, hours","72/70",null,null,"72/70"]
[null,"Cooling temp (occ/unocc)",null,"°F, hours","78/80",null,null,"78/80"]
[null,"Exterior lighting",null,"hours/day",12,null,null,12]
[null,"Interior non-apt lighting",null,"hours/day"]
[null,"Interior apt lighting",null,"hours/day",2.34,null,null,2.34]
[null,"Building envelope"]
[null,"Ext. wall construction",null,"U-factor",0,null,null,0]
[null,"Roof construction",null,"U-factor",{"$error":"#REF!"},null,null,{"$error":"#REF!"}]
[null,"Floor / slab construction",null,"F-factor",0,null,null,0]
[null,"Window/wall area ratio",null,"WWA",0,null,null,0]
[null,"Windows",null,"U-factor",0,null,null,0]
[null,"North-facing windows",null,"SHGC",0,null,null,0]
[null,"Other window area",null,"SHGC",0,null,null,0]
[null,"Shading devices",null,null,0,null,null,0]
[null,"Lighting & appliances"]
[null,"Lighting power density:"]
[null,"In-unit lighting power density",null,"W/ft2","0.5 W/SF",null,null,{"$error":"#DIV/0!"}]
[null,"Other interior lighting",null,"W/ft2",{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[null,"Exterior lighting",null,"kW",0,null,null,0]
[null,"Lighting controls",null,"Space, %"]
[null,"Refrigerators",null,"Model, #"]
[null,"Annual energy use",null,"kWh/year",528.75,null,null,423]
[null,"Dishwashers",null,"Model, #",{"$nulls":25},"Electric"]
[null,"Annual energy use",null,"kWh/year",0,null,null,0,{"$nulls":21},"Gas"]
[null,"Annual hot water use",null,"gal/year",0,null,null,1290]
[null,"Clothes Washers",null,"Model, #"]
[null,"Annual energy use",null,"kWh/year",0,null,null,0]
[null,"Annual hot water use",null,"gal/year",0,null,null,0]
[null,"Clothes Dryers",null,"Model, #"]
[null,"Fuel",null,"Elec/gas",null,null,null,0]
[null,"Annual energy use",null,"kWh, therms",null,0,"therms",null,0,"therms"]
[null,"Cooking Fuel",null,"Elec/gas",null,null,null,0]
[null,"Annual energy use",null,"kWh, therms",null,0,"therms",null,0,"therms"]
[null,"Apartment Plug Loads",null,"kWh/year",0,null,null,0]
[null,"Non-apartment Plug Loads",null,"W/sf or kWh/sf",null,{"$error":"#DIV/0!"},"kWh/sf",null,{"$error":"#DIV/0!"},"kWh/sf"]
[null,"Elevators",null,"Type, model"]
[null,"Annual energy use",null,"kWh/year","SG, Section 3.11",null,null,0]
[null,"HVAC System"]
[null,"Primary HVAC system type",null,"System 1, 2"]
[null,"Exhaust fans",null,"Energy Star?",0,null,null,0]
[null,"Exhaust fan efficiency",null,"CFM/watt"]
[null,"Infiltration rate",null,"ACH, CFM/p",null,0.1,"ACH",null,0.1,"ACH"]
[null,"Exhaust rates",null,"CFM",0,null,null,0]
[null,"Heating efficiency",null,"AFUE / COP",null,0,0,null,0,0]
[null,"Cooling efficiency",null,"SEER / EER",null,0,0,null,0,0]
[null,"Hot water loop parameters",null,"°F, reset"]
[null,"Hot water pump parameters",null,"VSD, W/gpm"]
[null,"Fan supply volume",null,"CFM"]
[null,"Fan supply power",null,"kW",0,null,null,0]
[null,"Distribution efficiency",null,"1.0 / 0.95"]
[null,"Cooling adjustment coeff",null,0.4,1,null,null,1]
[null,"Domestic Hot Water System"]
[null,"Equipment effiency",null,"EF",0,null,null,0]
[null,"Total hot water demand",null,"gal/day",0,null,null,{"$error":"#DIV/0!"}]
[null,"Faucets",null,"GPM","2.5 @ 80 psi",null,null,0]
[null,"Showerheads",null,"GPM","2.5 @ 80psi",null,null,0]
[null,"Solar DHW system",null,"% of load"]
[null,"Renewable Electric Generation System"]
[null,"Type of system",null,null,0,null,null,0]
[null,"Rated capacity",null,"kW",0,null,null,0]
[null,"Other"]
[{"$nulls":4},0,null,null,0]
[{"$nulls":4},0,null,null,0]
[{"$nulls":4},0,null,null,0]
[]
[]
[null,null,"Table 6. Outputs:  Estimated Consumption for Baseline Design"]
[null,null,"End Use",null,"Units","0 degree rotation","90 degree rotation","180 degree rotation","270 degree rotation","Average"]
[null,null,"Electric loads"]
[null,null,"Ventilation fans",null,"kWh",0,0,0,0,{"$error":"#DIV/0!"}]
[null,null,"Space heating",null,"kWh",0,0,0,0,{"$error":"#DIV/0!"}]
[null,null,"Space cooling",null,"kWh",0,0,0,0,{"$error":"#DIV/0!"}]
[null,null,"Domestic hot water",null,"kWh",0,0,0,0,{"$error":"#DIV/0!"}]
[null,null,"Interior lighting",null,"kWh",0,0,0,0,{"$error":"#DIV/0!"}]
[null,null,"Exterior lighting",null,"kWh",0,0,0,0,0]
[null,null,"Appliances",null,"kWh",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#DIV/0!"}]
[null,null,"Plug loads",null,"kWh",0,0,0,0,0]
[null,null,"Other (describe)",null,"kWh",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#DIV/0!"}]
[null,null,"Gas loads"]
[null,null,"Space heating",null,"Mbtu",0,0,0,0,{"$error":"#DIV/0!"}]
[null,null,"Domestic hot water",null,"Mbtu",0,0,0,0,{"$error":"#DIV/0!"}]
[null,null,"Appliances",null,"Mbtu",0,0,0,0,{"$error":"#DIV/0!"}]
[null,null,"Fuel oil loads"]
[null,null,"Space heating",null,"Mbtu",0,0,0,0,0]
[null,null,"Domestic hot water",null,"Mbtu",0,0,0,0,0]
[null,null,"Totals"]
[null,null,"Electric loads",null,"kWh",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},""]
[null,null,"Gas loads",null,"Mbtu",0,0,0,0,0]
[null,null,"Oil loads",null,"Mbtu",0,0,0,0,0]
[]
[null,null,"Table 5. Comparison of Estimated Consumption"]
[null,null,"End Use",null,"Units","Baseline \nAnnual Consumption ",null,"Proposed Design \nAnnual Consumption",null,"% Savings"]
[null,null,"Electric loads"]
[null,null,"Ventilation fans",null,"kWh",{"$error":"#DIV/0!"},null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Space heating",null,"kWh",{"$error":"#DIV/0!"},null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Space cooling",null,"kWh",{"$error":"#DIV/0!"},null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Domestic hot water",null,"kWh",{"$error":"#DIV/0!"},null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Interior lighting",null,"kWh",{"$error":"#DIV/0!"},null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Exterior lighting",null,"kWh",0,null,0,null,"NA"]
[null,null,"Appliances",null,"kWh",{"$error":"#DIV/0!"},null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Other (describe)",null,"kWh",{"$error":"#DIV/0!"},null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Plug loads",null,"kWh",0,null,0,null,"NA"]
[null,null,"Gas loads"]
[null,null,"Space heating",null,"Mbtu",{"$error":"#DIV/0!"},null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Domestic hot water",null,"Mbtu",{"$error":"#DIV/0!"},null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Appliances",null,"Mbtu",{"$error":"#DIV/0!"},null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Fuel oil loads"]
[null,null,"Space heating",null,"Mbtu",{"$nulls":4},"NA"]
[null,null,"Domestic hot water",null,"Mbtu",{"$nulls":4},"NA"]
[null,null,"Totals"]
[null,null,"Electric loads",null,"kWh","",null,0,null,{"$error":"#VALUE!"}]
[null,null,"Gas loads",null,"Mbtu",0,null,0,null,"NA"]
[null,null,"Oil loads",null,"Mbtu",0,null,0,null,"NA"]

{"sheet":"Windows eQUEST","index":5,"n_rows":32,"n_cols":24,"rows_kept":32,"cut":false,"hidden":false,"merged":[[9,2,9,3],[9,4,9,5],[18,2,18,3],[18,4,18,5],[18,16,18,17],[26,12,26,13],[26,14,26,15],[26,16,26,17],[18,6,18,7],[18,8,18,9],[18,14,18,15],[18,10,18,11],[18,12,18,13],[26,10,26,11],[26,2,26,3],[26,4,26,5],[26,6,26,7],[26,8,26,9]],"flags":["formulas_cached_only"]}
[null,"Instructions: ",{"$nulls":21},1]
[1,"Using ASHRAE 90.1-2007 Table 5.5 (copied below), enter values for your Climate Zone and framing in the Baseline column. ",{"$nulls":21},2]
[2,"Baseline fenestration is based on construction. Wood-frame buildings use nonmetal framing; all others use applicable metal framing.",{"$nulls":21},3]
[3,"Enter actual NFRC values in the Proposed column.",{"$nulls":21},4]
[4,"Use calculated values as inputs into eQUEST Glass Type Properties - Basic Specifications screen.",{"$nulls":21},5]
[{"$nulls":23},6]
[null,"Climate Zone",{"$nulls":21},7]
[null,"Construction Type",{"$nulls":21},8]
[]
[null,"ASHRAE 90.1-2007","Residential",null,"Nonresidential",{"$nulls":18},"Wood-frame"]
[null,null,"Baseline","Proposed","Baseline","Proposed"," ",{"$nulls":16},"Other"]
[null,"NFRC SHGC"]
[null,"NFRC U-value"]
[]
[null,"eQUEST SC",0,0,0,0]
[null,"eQUEST U-value",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[null,"Residential","Climate Zone 1",null,"Climate Zone 2 ",null,"Climate Zone 3",null,"Climate Zone 4",null,"Climate Zone 5",null,"Climate Zone 6",null,"Climate Zone 7",null,"Climate Zone 8"]
[null,null,"U-value","SHGC","U-value","SHGC","U-value","SHGC","U-value","SHGC","U-value","SHGC","U-value","SHGC","U-value","SHGC","U-value","SHGC"]
[null,"Nonmetal Framing (all)",1.2,0.25,0.75,0.25,0.65,0.25,0.4,0.4,0.35,0.4,0.35,0.4,0.35,"NR",0.35,"NR"]
[null,"Metal Framing (storefront)",1.2,0.25,0.7,0.25,0.6,0.25,0.5,0.4,0.45,0.4,0.45,0.4,0.4,"NR",0.4,"NR"]
[null,"Metal Framing (entrance door)",1.2,0.25,1.1,0.25,0.9,0.25,0.85,0.4,0.8,0.4,0.8,0.4,0.8,"NR",0.8,"NR"]
[null,"Metal Framing (all other)",1.2,0.25,0.75,0.25,0.65,0.25,0.55,0.4,0.55,0.4,0.55,0.4,0.45,"NR",0.45,"NR"]
[]
[]
[null,"Nonresidential","Climate Zone 1",null,"Climate Zone 2 ",null,"Climate Zone 3",null,"Climate Zone 4",null,"Climate Zone 5",null,"Climate Zone 6",null,"Climate Zone 7",null,"Climate Zone 8"]
[null,null,"U-value","SHGC","U-value","SHGC","U-value","SHGC","U-value","SHGC","U-value","SHGC","U-value","SHGC","U-value","SHGC","U-value","SHGC"]
[null,"Nonmetal Framing (all)",1.2,0.25,0.75,0.25,0.65,0.25,0.4,0.4,0.35,0.4,0.35,0.4,0.35,0.45,0.35,0.45]
[null,"Metal Framing (storefront)",1.2,0.25,0.7,0.25,0.6,0.25,0.5,0.4,0.45,0.4,0.45,0.4,0.4,0.45,0.4,0.45]
[null,"Metal Framing (entrance door)",1.2,0.25,1.1,0.25,0.9,0.25,0.85,0.4,0.8,0.4,0.8,0.4,0.8,0.45,0.8,0.45]
[null,"Metal Framing (all other)",1.2,0.25,0.75,0.25,0.65,0.25,0.55,0.4,0.55,0.4,0.55,0.4,0.45,0.45,0.45,0.45]

{"sheet":"Water Savings","index":6,"n_rows":35,"n_cols":5,"rows_kept":35,"cut":false,"hidden":false,"merged":[[6,1,6,4],[2,1,2,4],[3,1,3,4],[4,1,4,4],[5,1,5,4]],"flags":["formulas_cached_only"]}
[null,"Instructions:"]
[1,"First, fill in Basic Info tab."]
[2,"In the \"Baseline Fixture\" table, enter an estimated number of uses/day for urinals in the appropriate space.  Enter \"0\" if there are no urinals in building."]
[3,"The baseline usage values will generate automatically."]
[4,"In the \"Proposed Fixture\" table, enter the flow rate for each proposed fixture type."]
[5,"When on-site collected graywater or rainwater is used for sewage conveyance, the total estimated annual graywater quantity may be subtracted from the total annual design case water usage. Estimated graywater quantity may not be greater than the total usage of fixtures that utilize it. For example, if graywater will be used only in flush toilets, the estimated graywater quantity cannot be greater than the total annual water used by the toilets.  Estimate graywater usage for each fixture type and enter the value in the appropriate cell."]
[6,"The remaining values will generate automatically.  Water usage savings and cost savings may be reported as indicated in the Water Savings section of the Simulation Guidelines. "]
[null,"Average Price per Gallon of Water"]
[null,"No. of Occupants",0]
[null,"Dishwasher Savings (Gal/yr)",0]
[null,"Clothes Washers Savings (Gal/yr)",0]
[]
[null,"Baseline Fixture",null,"Baseline Flow Rates (GPF/GPM)","Baseline Usage (Gallons/year)"]
[null,"Toilets","<Enter \"0\" below if no urinals>",1.6,0]
[null,"Urinals",null,1,0]
[null,"Showerheads",null,2.5,0]
[null,"Bathroom Faucets",null,2.5,0]
[null,"Kitchen Faucets",null,2.5,0]
[null,"Total",null,null,0]
[]
[null,"Proposed Fixture","Proposed Fixture Flow Rate (GPM/GPF)","Graywater Usage (Gallons/year)","Proposed Usage (Gallons/year)"]
[null,"Toilets",null,null,0]
[null,"Urinals",null,null,0]
[null,"Showerheads (@80 psi)",null,null,0]
[null,"Bathroom Faucets (@80 psi)",null,null,0]
[null,"Kitchen Faucets (@80 psi)",null,null,0]
[null,"Total",null,null,0]
[]
[null,"Savings by Fixture Type","Water Usage Savings (Gallons/year)","Cost Savings ($/year)"]
[null,"Toilets",0,0]
[null,"Urinals",0,0]
[null,"Showerheads",0,0]
[null,"Bathroom Faucets",0,0]
[null,"Kitchen Faucets",0,0]
[null,"Total",0,0]

{"sheet":"DHW Demand","index":7,"n_rows":39,"n_cols":27,"rows_kept":39,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"Instructions: "]
[1,"First fill in the Basic Info and Water Savings tabs.",{"$nulls":23},"Low","Electric"]
[2,"Fill in cells highlighted with this color.",null,null,null,"Occupancy",null,"Low/medium/high usage (see Simulation Guidelines, 3.9.2)",{"$nulls":17},"Medium","Gas"]
[3,"Data to be entered into software.",{"$nulls":4},44,"gallons per person per day",{"$nulls":17},"High"]
[]
[null,null,"Proposed","Baseline",null,"Kitchen Faucet",0,"GPM"]
[null,"Avg Faucet gpm (@ 80 psi)",{"$error":"#DIV/0!"},2.5,null,"Bath Faucet",0,"GPM"]
[null,"Showerhead gpm (@ 80 psi)",0,2.5,null,"Baseline DW",0,"GAL/YR PER APT = ",null,0,"gallons/day-apt (1 dishwasher)"]
[null,"Total Gal/day (occupant only)",{"$error":"#DIV/0!"},0,null,"Proposed DW",1290,"GAL/YR PER APT = ",null,3.5342465753424657,"gallons/day-apt (1 dishwasher)"]
[null,"Total Gal/day (w/both DW & CW)",{"$error":"#DIV/0!"},0,null,"Baseline CW",0,"hot water gallons/yr  =",null,null,0,"Total hot water gallons/day (all clothes washers)"]
[null,"GPM w/DOE APT DHW schedule",{"$error":"#DIV/0!"},0,null,"Proposed CW",0,"hot water gallons/yr  =",null,null,0,"Total hot water gallons/day (all clothes washers)"]
[]
[]
[null,"Schedule","DOE APT DHW","Proposed","Baseline",null,null,"Do apartments have dishwashers?  (Y/N)"]
[null,0.05,0,{"$error":"#DIV/0!"},0,null,null,"Are they Energy Star rated? (Y/N/NA)"]
[null,0.05,1,{"$error":"#DIV/0!"},0,null,0,"# of bedrooms"]
[null,0.05,2,{"$error":"#DIV/0!"},0,null,0,"# of apartments"]
[null,0.05,3,{"$error":"#DIV/0!"},0,null,null,"# kitchen faucets",null,null,null,"# kitchens"]
[null,0.05,4,{"$error":"#DIV/0!"},0,null,null,"# lav faucets",null,null,null,"# lavatories (that require exhaust)"]
[null,0.05,5,{"$error":"#DIV/0!"},0]
[null,0.3,6,{"$error":"#DIV/0!"},0,null,null,"# of dishwashers"]
[null,0.5,7,{"$error":"#DIV/0!"},0,null,null,"# of clothes washers"]
[null,0.4,8,{"$error":"#DIV/0!"},0,null,null,"Are they Energy Star rated? (Y/N/NA)"]
[null,0.3,9,{"$error":"#DIV/0!"},0]
[null,0.3,10,{"$error":"#DIV/0!"},0,null,null,"washer and dryer"]
[null,0.35,11,{"$error":"#DIV/0!"},0]
[null,0.4,12,{"$error":"#DIV/0!"},0,null,null,"Central DHW"]
[null,0.35,13,{"$error":"#DIV/0!"},0,null,null,"DHW Storage Volume (gallons)",null,null,null,1.25,"radius"]
[null,0.35,14,{"$error":"#DIV/0!"},0,null,0,"DHW Storage Volume (cubic feet)",null,null,null,0,"height"]
[null,0.3,15,{"$error":"#DIV/0!"},0,null,12.5,"R-value"]
[null,0.3,16,{"$error":"#DIV/0!"},0,null,9.821428571428571,"Surface Area",null,null,"% EFF","HIR/EIR"]
[null,0.5,17,{"$error":"#DIV/0!"},0,null,0.7857142857142857,"UA for eQuest",null,null,null,{"$error":"#DIV/0!"}]
[null,0.5,18,{"$error":"#DIV/0!"},0]
[null,0.4,19,{"$error":"#DIV/0!"},0,null,null,"In-Unit Water Heater"]
[null,0.35,20,{"$error":"#DIV/0!"},0,null,null,"Volume","Fuel","EF","HIR/EIR"]
[null,0.45,21,{"$error":"#DIV/0!"},0,null,"Baseline",null,null,"",{"$error":"#VALUE!"}]
[null,0.3,22,{"$error":"#DIV/0!"},0,null,"Proposed",0,0,null,{"$error":"#DIV/0!"}]
[null,0.05,23,{"$error":"#DIV/0!"},0]
[null,6.7,null,{"$error":"#DIV/0!"},0]

{"sheet":"Appliances","index":8,"n_rows":58,"n_cols":22,"rows_kept":58,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"Instructions: "]
[1,"First, fill out Basic Info and DHW Demand tabs."]
[2,"Fill in cells highlighted with this color."]
[3,"Data to be entered in eQUEST as Equipment or Internal Energy Sources."]
[]
[null,null,"Proposed","Baseline","Equipment # (optional)","Sensible","Latent","Schedule"]
[null,"Refrigerator, kWh/yr-unit",423,528.75,null,"Heat Ratio","Heat Ratio",{"$nulls":13},"Electric","In-Unit"]
[null,"Refrigerator, kWh/yr-blg",0,0,{"$nulls":16},"Gas","Common"]
[null,"Refrigerator, W/SqFt",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"Apt Equipment [#]",1,0,"T24 DAY EQP WD",null,null,"1 Stove"]
[null,"Electric Stove, kWh/yr-unit",0,0,{"$nulls":5},"Stove Type",0,"Therms"]
[null,"Electric Stove, kWh/yr-blg",0,0]
[null,"Stove, W/SqFt",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"Apt Equipment [#]",0,0,"T24 DAY EQP WD"]
[null,"Dishwasher, kWh/yr-unit",0,0,{"$nulls":4},0,"# of dishwashers"]
[null,"Dishwasher, kWh/yr-bldg",0,0]
[null,"Dishwasher, W/SqFt",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"Apt Equipment [#]",0.6,0.15,"T24 DAY EQP WD"]
[null,"In-Unit Clothes Washer, kWh/yr",0,0]
[null,"In-Unit Clothes Washer, kWh/yr-bldg",0,0,{"$nulls":4},1,"F-factor"]
[null,"In-Unit Washer, W/SqFt",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"Apt Equipment [#]",0.8,0,"T24 DAY EQP WD",0,"# of washers"]
[null,"In-Unit Dryer, kWh/yr-bldg",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$nulls":5},"# of dryers","1 Dryer"]
[null,"In-Unit Dryer, W/SqFt",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"Apt Equipment [#]",0.15,0.05,"T24 DAY EQP WD",null,"DRYER",0,"Therms"]
[null,"Common Washer, kWh/yr-machine",0,0,{"$nulls":4},{"$error":"#DIV/0!"},"Average # bedrooms in living units"]
[null,"Common Washer, kWh/yr-bldg",0,0,{"$nulls":5},"sum of area of all common laundry rooms"]
[null,"Common Washer, W/SqFt",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"NA","NA","NA","T24 EQP WD"]
[null,"Common Dryer, kWh/yr-bldg",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Common Dryer, W/SqFt",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"NA",0.15,0.05,"T24 EQP WD"]
[null,"In-Unit Dryer, BTU/h               (PER dryer)",0,0,"NA","NA","NA","T24 DAY EQP WD"]
[null,"In-unit, misc. kWh/yr-SqFt (SG 2-11)",1.05,1.05]
[null,"In-unit misc W/SqFt ",0.4959848842701938,0.4959848842701938,"Apt Equipment 1",0.9,0.1,"T24 DAY EQP WD","Number of Stories:",0]
[null,"Corridor, restrooms & Stairs W/SqFt",0.2,0.2,"Corr & Stairs Equipment 1",1,0,"T24 EQP WD","Area of Elevator:"]
[null,"Elevator W/SqFt",{"$error":"#DIV/0!"},{"$error":"#VALUE!"},"Elevator Equipment 1",0.1,0,"T24 EQP WD","Elevator Type:",""]
[null,"Office W/SqFt",1.5,1.5,"Office Equipment 1",1,0,"T24 EQP WD","SG, Section 3.11","Baseline kWh/yr for elevator"]
[null,"Other Public and Common Area W/SqFt",0.5,0.5,"Common Area Equipment 1",{"$nulls":4},"Proposed kWh/yr (same as Baseline if not requesting performance credit)"]
[null,"Hour","Common area plug load schedule, SG 2.11 (Same as T24 EQP WD)","Apartment Plug load schedule (Same as T24 DAY EQP WD)"]
[null,1,0.1,0.05]
[null,2,0.1,0.05]
[null,3,0.1,0.05]
[null,4,0.1,0.05]
[null,5,0.1,0.05]
[null,6,0.3,0.05]
[null,7,0.45,0.05]
[null,8,0.45,0.05]
[null,9,0.45,0.5]
[null,10,0.45,0.5]
[null,11,0.3,0.5]
[null,12,0.3,0.5]
[null,13,0.3,0.3]
[null,14,0.3,0.5]
[null,15,0.3,0.5]
[null,16,0.3,0.5]
[null,17,0.3,0.5]
[null,18,0.3,0.5]
[null,19,0.6,0.35]
[null,20,0.8,0.05]
[null,21,0.9,0.05]
[null,22,0.8,0.05]
[null,23,0.6,0.05]
[null,24,0.3,0.05]
[null,"Total",9,5.799999999999998]

{"sheet":"Lighting Schedule","index":9,"n_rows":44,"n_cols":6,"rows_kept":44,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"Instructions: "]
[1,"Use this worksheet to generate schedules for lighting inputs."]
[2,"Enter hours/day in the cell highlighted in this color to generate a 24 hour schedule in column F. "]
[3,"Do not edit cells highlighted in this color."]
[4,"Do not edit cells highlighted in this color. These calculated values are for editing or creating schedules."]
[5,"Elevator lighting should only be assigned to ONE elevator zone."]
[6,"In eQUEST, exit Signs can be added as Lighting #2 (kW) in the appropriate zones."]
[7,"Credit for occupancy sensors can be applied to corridors and stairs by reducing proposed W/SF by 25% and 35% respectively."]
[]
[null,"Daily operating hours","hr/day"]
[null,"Apartments and Balconies",2.34]
[null,"Garage, Corridors, Lobbies & Stairs",24]
[null,"Exterior Lighting ",12]
[null,"Non Apartment, Non 24 hour"]
[]
[null,null,"APT LTG WD","Adjusted Fraction",null,"Adjusted Fraction"]
[null,"Hr","Fraction","Apartments",null,"Non Apartment, Non 24 hour"]
[null,1,0.05,0.015496688741721854,null,0]
[null,2,0.05,0.015496688741721854,null,0]
[null,3,0.05,0.015496688741721854,null,0]
[null,4,0.05,0.015496688741721854,null,0]
[null,5,0.05,0.015496688741721854,null,0]
[null,6,0.05,0.015496688741721854,null,0]
[null,7,0.25,0.07748344370860927,null,0]
[null,8,0.45,0.13947019867549668,null,0]
[null,9,0.45,0.13947019867549668,null,0]
[null,10,0.35,0.10847682119205297,null,0]
[null,11,0.35,0.10847682119205297,null,0]
[null,12,0.35,0.10847682119205297,null,0]
[null,13,0.25,0.07748344370860927,null,0]
[null,14,0.25,0.07748344370860927,null,0]
[null,15,0.25,0.07748344370860927,null,0]
[null,16,0.25,0.07748344370860927,null,0]
[null,17,0.25,0.07748344370860927,null,0]
[null,18,0.35,0.10847682119205297,null,0]
[null,19,0.7,0.21695364238410594,null,0]
[null,20,0.7,0.21695364238410594,null,0]
[null,21,0.7,0.21695364238410594,null,0]
[null,22,0.7,0.21695364238410594,null,0]
[null,23,0.6,0.18596026490066223,null,0]
[null,24,0.05,0.015496688741721854,null,0]
[null,"Total",7.55,2.34,null,0]
[null,"Apartment Adjustment",0.30993377483443707]
[null,"Non Apartment, Non 24 hour",0]

{"sheet":"In-Unit Lighting","index":10,"n_rows":71,"n_cols":12,"rows_kept":71,"cut":false,"hidden":false,"merged":[[2,1,2,11],[3,1,3,11],[4,1,4,11],[47,1,47,4],[46,1,46,4],[43,1,43,4],[44,1,44,4],[45,1,45,4]],"flags":["formulas_cached_only"]}
[null,"Instructions:"]
[1,"Include all in-unit hard-wired lighting in this table. Rated wattage must include ballast (follow 90.1 User's manual or Appendix B of Performance Path)."]
[2,"Per ASHRAE 9.1.4, screw-based fixtures must be entered using the maximum rated wattage of the fixture, even if a screw-based CFL or LED is installed. As this requirement is waived for this program, screw-base fixtures may be entered using the installed lamp and ballast wattage or the maximum rated wattage of the fixture."]
[3,"Only the rooms for which there are specified hard-wired lighting fixtures should be entered in this table. Therefore, the total square feet that you list in this table might be smaller than the total square feet of the Apartments. If there are multiple fixtures per room, distribute area accordingly."]
[4,"Likewise, for some rooms, the areas for which lighting is specified may be LESS than the total area of the room. If the specified fixtures are intended to light only a portion of the room, enter the square feet of the lighted area only, per your own estimation, but not to exceed 3 square feet per Watt. (Ex. A 13 Watt wall sconce in a bedroom can light at most 39 square feet and should not be modeled as lighting the entire space.)"]
[5,"Cells highlighted in red indicate spaces where estimated lumen output of fixture does not provide minimum illumination (16 lumens/SqFt) per IESNA."]
[6,"Enter data in the cells highlighted in this color. "]
[7,"Do not edit cells highlighted in this color."]
[8,"Do not edit cells highlighted in this color. These calculated values are to be entered into software as W/SF for Apartment zones."]
[]
[null,"In-Unit Lighting Table"]
[null,"Room Name","Room Area, SqFt","Quantity","Fixture Code","Fixture Wattage","Lumens per Fixture","Number of such rooms in the building","Total Area, SqFt","Total Installed Wattage, W","Illumination (footcandles or\nlumens/SqFt)"]
[{"$nulls":5},0,0,null,0,0,"0.0",""]
[{"$nulls":5},0,0,null,0,0,"0.0",""]
[{"$nulls":5},0,0,null,0,0,"0.0",""]
[{"$nulls":5},0,0,null,0,0,"0.0",""]
[{"$nulls":5},0,0,null,0,0,"0.0",""]
[{"$nulls":5},0,0,null,0,0,"0.0",""]
[{"$nulls":5},0,0,null,0,0,"0.0",""]
[{"$nulls":5},0,0,null,0,0,"0.0",""]
[{"$nulls":5},0,0,null,0,0,"0.0",""]
[{"$nulls":5},0,0,null,0,0,"0.0",""]
[{"$nulls":5},0,0,null,0,0,"0.0",""]
[{"$nulls":5},0,0,null,0,0,"0.0",""]
[{"$nulls":5},0,0,null,0,0,"0.0",""]
[{"$nulls":5},0,0,null,0,0,"0.0",""]
[{"$nulls":5},0,0,null,0,0,"0.0",""]
[{"$nulls":5},0,0,null,0,0,"0.0",""]
[{"$nulls":5},0,0,null,0,0,"0.0",""]
[{"$nulls":5},0,0,null,0,0,"0.0",""]
[{"$nulls":5},0,0,null,0,0,"0.0",""]
[{"$nulls":5},0,0,null,0,0,"0.0",""]
[{"$nulls":5},0,0,null,0,0,"0.0",""]
[{"$nulls":5},0,0,null,0,0,"0.0",""]
[{"$nulls":5},0,0,null,0,0,"0.0",""]
[{"$nulls":5},0,0,null,0,0,"0.0",""]
[{"$nulls":5},0,0,null,0,0,"0.0",""]
[{"$nulls":5},0,0,null,0,0,"0.0",""]
[{"$nulls":5},0,0,null,0,0,"0.0",""]
[{"$nulls":5},0,0,null,0,0,"0.0",""]
[{"$nulls":5},0,0,null,0,0,"0.0",""]
[]
[null,"Summary"]
[null,"Total in-unit area with specified lighting, SqFt",null,null,null,0]
[null,"Total specified lighting, W",null,null,null,0]
[null,"Specified lighting power density, W/SqFt",null,null,null,"NA"]
[null,"Proposed lighting power density, W/SqFt",null,null,null,{"$error":"#DIV/0!"}]
[null,"Baseline lighting power density, W/SqFt",null,null,null,1.1]
{"$rows_empty":11}
[null,"Room Types"]
[null,"Bathroom"]
[null,"Bedroom"]
[null,"Closet"]
[null,"Dining Room"]
[null,"Family Room"]
[null,"Hall"]
[null,"Kitchen"]
[null,"Living Room"]
[null,"Office"]
[null,"Utility Room"]
[null,"Other"]

{"sheet":"Interior Lighting","index":11,"n_rows":359,"n_cols":24,"rows_kept":359,"cut":false,"hidden":false,"merged":[[1,6,1,7]],"flags":["formulas_cached_only"]}
["Instructions: ",{"$nulls":7},"Fixture Code","Fixture Type","Watts/Fixture","Lumens/fixture","Manufacturer/Model","General Location","ENERGY STAR? (Y/N)","24/7?","Quantity",{"$nulls":4},2007,2010]
["1. Fill in cells highlighted with this color, including the Watts/fixture and Lumens/fixture in Column J&K.",{"$nulls":5},"MUST BE ALPHABETICAL",null,"A",{"$nulls":7},{"$error":"#DIV/0!"},null,"Storage, active","Apartment","Conference/meeting/multipurpose",1.3,1.23,30]
["2. When available, provide manufacturer, model, whether ENERGY STAR qualified and indicate 24 hour operation.",{"$nulls":7},"B",{"$nulls":7},{"$error":"#DIV/0!"},null,"Storage, inactive","Common Space","Corridor/Transition",0.5,0.66,10]
["3. List NON-APARTMENT rooms in the building that have specified lighting by FLOOR. For typical floors, indicate the floor multiplier in Column H.",{"$nulls":7},"C",{"$nulls":7},{"$error":"#DIV/0!"},null,"Lobby","Exterior","Electrical/Mechanical",1.5,0.95,30]
["4. List square footages for all NON-APARTMENT spaces in Column B (do not assign square footages to rows for Exit Signs or Exterior Lights).",{"$nulls":7},"D",{"$nulls":7},{"$error":"#DIV/0!"},null,"Corridor/Transition",null,"Exit Signs","5 W/face","5 W/face","NA"]
["5. Indicate how many fixtures of each type are in each room in Column E.",{"$nulls":7},"E",{"$nulls":7},{"$error":"#DIV/0!"},null,"Stairs - Active",null,"Lobby",1.3,0.9,16]
["6. Use drop down menu to indicate the ASHRAE space type for calculating proposed LPD's.",{"$nulls":7},"F",{"$nulls":7},{"$error":"#DIV/0!"},null,"Restroom",null,"Office",1.1,1.11,35]
["7. Rooms with more than one fixture type should be entered using multiple rows (Ex. exit signs); square footage should be distributed between entries.",{"$nulls":7},"G",{"$nulls":7},{"$error":"#DIV/0!"},null,"Office",null,"Parking garage",0.2,0.19,7]
["8. If you need more rows for your building, add them at the bottom by copying rows above (or filling down).",{"$nulls":7},"H",{"$nulls":7},{"$error":"#DIV/0!"},null,"Conference/meeting/multipurpose",null,"Restroom",0.9,0.98,12]
["9. When finished, be sure to delete any \"#N/A\" from blank rows.",{"$nulls":7},"I",{"$nulls":7},{"$error":"#DIV/0!"},null,"Electrical/Mechanical",null,"Stairs - Active",0.6,0.69,15]
["10.Red cells indicate ZONES where proposed lighting exceed ASHRAE LPD by more than 20%. ",{"$nulls":7},"J",{"$nulls":7},{"$error":"#DIV/0!"},null,"Workshop",null,"Storage, active",0.8,0.63,20]
["11.ZONES can exceed LPDs by more than 20%, but the TOTAL proposed wattage cannot exceed the TOTAL wattage in the baseline by more than 20%.",{"$nulls":7},"K",{"$nulls":7},{"$error":"#DIV/0!"},null,"Parking Garage",null,"Storage, inactive",0.3,0.63,8]
["",{"$nulls":4},"",null,null,"L",{"$nulls":7},{"$error":"#DIV/0!"},null,"Exit Signs",null,"Unlit Chases/Shafts",0,0,"NA"]
[{"$nulls":8},"M",{"$nulls":7},{"$error":"#DIV/0!"},null,"Unlit Chases/Shafts",null,"Workshop",1.9,1.59,50]
["Select calculation method:",null,"Space-By-Space (90.1-2007)",{"$nulls":5},"N",{"$nulls":7},{"$error":"#DIV/0!"}]
[{"$nulls":8},"O",{"$nulls":7},{"$error":"#DIV/0!"}]
[{"$nulls":8},"P",{"$nulls":7},{"$error":"#DIV/0!"},null,"Yes","Incandescent","Space-By-Space (90.1-2007)"]
[null,null,null,"Fixture Count","TOTAL","ENERGY STAR","> 80%?",null,"Q",{"$nulls":7},{"$error":"#DIV/0!"},null,"No","Screw-Based CFL","Building Area (90.1-2007)"]
[null,null,null,"Apartment",0,0,{"$error":"#DIV/0!"},null,"R",{"$nulls":7},{"$error":"#DIV/0!"},null,"Sensors","Pin-type fluorescent","Space-By-Space (90.1-2010)"]
[null,null,null,"Common Space",0,0,{"$error":"#DIV/0!"},null,"S",{"$nulls":7},{"$error":"#DIV/0!"},null,null,"Metal Halide","Building Area (90.1-2010)"]
[null,null,null,"Exterior",0,0,{"$error":"#DIV/0!"},null,"T",{"$nulls":7},{"$error":"#DIV/0!"},null,null,"High Pressure Sodium"]
[{"$nulls":8},"U",{"$nulls":7},{"$error":"#DIV/0!"},null,null,"LED"]
[{"$nulls":8},"V",{"$nulls":7},{"$error":"#DIV/0!"},null,null,"Other"]
[{"$nulls":7},"If you need more rows, insert below this row >>","W",{"$nulls":7},{"$error":"#DIV/0!"}]
[]
[{"$nulls":8},0,null,null,0]
[null,"Square Footage","Room Name","ASHRAE Space Type","Installed quantity","Fixture Code (A,B,C etc)","Fixture Installed Wattage","Floor Multiplier","Total Installed Wattage","PROPOSED W/SF","BASELINE W/SF","BASELINE WATTS","CALCULATED FOOTCANDLES","IESNA FOOTCANDLES","Total Square Footage","Footcandle Warning"]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]
[{"$nulls":6},{"$error":"#N/A"},null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},0,{"$error":"#N/A"},{"$error":"#N/A"},0,""]

{"sheet":"Exterior Lighting","index":12,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[[8,1,9,1]],"flags":["formulas_cached_only"]}
[null,"Instructions:"]
[1,"Enter data in the cells highlighted with this color. "]
[2,"Use values from the cells highlighted in this color in the energy simulations. "]
[3,"In eQUEST, exterior lighting should be entered in the \"Utility & Economics\" section, under Electric Meter as a Direct Exterior Load, with Ambient Lighting enduse and a 12 hr/day schedule."]
[4,"For proposed design simulation, enter exterior lighting specified on drawings."]
[5,"Apartment balcony lighting should be treated as façade lighting, and modeled using the 2.34 hr/day schedule for in-unit lighting."]
[null,"Exterior Lighting Allowances (Per Table 9.4.5 of ASHRAE 90.1-2007)"]
[]
[null,"Area Type","Lighting Power Density ","Area","Baseline Lighting Allowance","Proposed Lighting Allowance","Proposed Fixture Description"]
[null,null,"W/SqFt","SqFt","W","W"]
[null,"Uncovered parking lots and drives",0.15,null,0]
[null,"Walkways 10ft wide or greater",0.2,null,0]
[null,"Exterior stairways",1,null,0]
[null,"Canopies and overhangs",1.25,null,0]
[null,"Building Facades  (1)",0.2,null,0,null,null,"If Proposed façade lighting exceeds Baseline allowance, model proposed as designed. "]
[{"$nulls":7},"If Proposed façade lighting is less than Baseline allowance, model baseline the same as proposed. "]
[null,"Area Type","Lighting Power Density, ","Linear feet","Baseline Lighting Allowance","Proposed Lighting Allowance","Proposed Fixture Description"]
[null,null,"W/linear foot","Ft","W","W"]
[null,"Walkways less than 10 ft wide",1,null,0]
[null,"Main building entrance (2)",30,null,0]
[null,"Other exterior doors (2) ",20,null,0]
[null,"Building Facades  (3)",5,null,0]
[]
[null,"Total Exterior Building Allowance to be entered in Energy Models (4)"]
[null,null,"Baseline","Proposed"]
[null,"Tradable",0,0,"Watts"]
[null,"Non-Tradable",0,0,"Watts"]
[null,null,0,0,"Watts"]
[null,"Notes:"]
[null,"(1) Enter area of all illuminated walls or surfaces in the Area column "]
[null,"(2) Enter total linear foot of door width for main entrance doors"]
[null,"(3) Enter total linear foot of all illuminated wall or surface length"]
[null,"(4) Total values include additional 5% allowance per Section 9.4.5"]

{"sheet":"Infiltration&Ventilation","index":13,"n_rows":69,"n_cols":17,"rows_kept":69,"cut":false,"hidden":false,"merged":[[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[11,4,11,5],[12,4,12,5],[13,4,13,5],[14,4,14,5],[11,6,11,7],[12,6,12,7],[13,6,13,7],[14,6,14,7]],"flags":["formulas_cached_only"]}
[null,"Instructions: "]
[1,"In the simulation software, rather than model Outside Air and Exhaust for Apartments separately, you may combine and model as \"Infiltration\"."]
[2,"You may model Exhaust for refuse rooms and laundry rooms as equivalent \"Infiltration\" as well."]
[3,"Fill in cells highlighted with this color."]
[4,"Data to be entered into simulation software."]
[5,"Corridor Supply Air can be modeled as Outside Air in software."]
[6,"Supply Ventilation for Apartments should be mechanical supply or trickle vents, but not corridor make-up air."]
[7,"ACH or CFM/SF can be used for data entry."]
[8,"In eQUEST, electricity for exhaust fans should be modeled as Direct-Interior or Exterior Loads in Electric Meter, with Ventilation Fans enduse."]
[9,"Red cells will indicate when continuous baseline ventilation is not properly modeled."]
[null,null,"Baseline","Proposed","Baseline","Proposed","Baseline","Proposed","Baseline","Proposed",{"$nulls":5},"Ceiling (10-80 CFM)",1.2]
[null,"Space Type","Apartments",null,"Refuse Room",null,"Laundry Room",{"$nulls":8},"Ceiling (90-500 CFM)",2.3]
[null,"Total Area For Space Type, SqFt",0,{"$nulls":12},"Inline or Range Hood",2.3]
[null,"Ceiling Height, Ft",{"$nulls":13},"Rooftop/Other","NA"]
[null,"Total Volume For Space Type, CuFt",0,null,0,null,0,null,0]
[null,"Exhaust Ventilation, CFM (Design/tested flows at grilles)",{"$nulls":13},"Intermittent"]
[null,"Ventilation Duct Leakage (Baseline add 10 CFM/floor per shaft)",{"$nulls":13},"Continuous"]
[null,"Exhaust Runtime, hr/day"]
[null,"Assumed Infiltration Rate, ACH",0.1,0.1,0.1,0.1,0.1,0.1]
[null,"Equivalent Continuous Exhaust, ACH",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Supply Ventilation, CFM"]
[null,"Supply Runtime, hr/day"]
[null,"Equivalent Continuous Supply, ACH",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Minimum Outdoor Air Requirements, ACH",0.35,0.35]
[null,"Average Combined Hourly Infiltration/Ventilation Rate, ACH",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Average Combined Hourly Infiltration/Ventilation Rate, CFM/SF",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,"Exhaust Fan Type",null,0,null,0,null,0]
[null,"CFM/W",{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,"Pfan (Watts)",{"$error":"#N/A"},{"$error":"#DIV/0!"},{"$error":"#N/A"},{"$error":"#DIV/0!"},{"$error":"#N/A"},{"$error":"#DIV/0!"}]
[null,"HP","Do not Enter data","Do not Enter data","Do not Enter data","Do not Enter data","Do not Enter data","Do not Enter data"]
[null,"Pfan (Watts)","NA","NA","NA","NA","NA","NA"]
[null,"BHP","Do not Enter data","Do not Enter data","Do not Enter data","Do not Enter data","Do not Enter data","Do not Enter data"]
[null,"Motor Efficiency","Do not Enter data","Do not Enter data","Do not Enter data","Do not Enter data","Do not Enter data","Do not Enter data"]
[null,"Pfan (Watts)","NA","NA","NA","NA","NA","NA"]
[]
[null,"Local Exhaust (62.2-2007):","Kitchen","Bathroom",0,"CFM is the maximum allowed in the baseline if both fans run continuously or both fans run intermittently."]
[null,"MAXIMUM CONTINUOUS LOCAL BASELINE EXHAUST:",0,30]
[null,"MAXIMUM INTERMITTENT LOCAL BASELINE EXHAUST:",150,75]
[]
[null,null,"Kitchen","Bathroom",0,"CFM is the minimum allowed in the baseline if both fans run continuously or both fans run intermittently."]
[null,"MINIMUM CONTINUOUS LOCAL BASELINE EXHAUST:",0,20]
[null,"MINIMUM INTERMITTENT LOCAL BASELINE EXHAUST:",100,50]
[]
[null,"BASELINE LOCAL EXHAUST VENTILATION:"]
[null,"PROPOSED LOCAL EXHAUST VENTILATION:"]
[null,"INTERMITTENT OR CONTINUOUS?:"]
[null,null,"Insufficient Ventilation","Insufficient Ventilation"]
[null,"Kitchen Area:"]
[null,"Kitchen Ceiling height:"]
[null,"Continuous CFM equivalent to 5ACH (62.2-2007):",0]
[]
[null,"Whole Unit Ventilation Rate (62.2-2007):","Studios","1BR","2BR","3BR","4BR"]
[null,"Average Area (SqFt):"]
[null,"Minimum CFM required:",15,15,22.5,30,37.5,"<< These values are updated once you have entered your average area."]
[null,"Maximum CFM allowed in Baseline:",0,0,0,0,0,"<< These values are determined once you have entered your proposed CFM."]
[null,"Proposed CFM:"]
[null,null,"Insufficient Ventilation","Insufficient Ventilation","Insufficient Ventilation","Insufficient Ventilation","Insufficient Ventilation"]
[]
[null,null,"CFM","minutes/hour","hours/day"]
[null,"Convert Intermittent Ventilation to equivalent Continuous:",null,null,null,0,"CFM is the equivalent continuous ventilation rate."]
[]
[null,null,"Quantity of Fans","CFM","minutes/hour","hours/day"]
[null,"Combine Different Ventilation to equivalent Continuous:",{"$nulls":4},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[]
[{"$nulls":6},0,"CFM is the equivalent continuous ventilation rate for all fans combined."]

{"sheet":"EIR for PTAC and PTHP","index":14,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[[20,4,20,10],[6,2,6,3],[6,4,6,10],[8,4,8,10],[18,2,18,3],[18,4,18,10]],"flags":["formulas_cached_only"]}
[null,"Instructions: "]
[1,"For gas heated buildings using System 1 - PTAC, use the top chart to calculate cooling-EIR"]
[2,"For electric heated buildings using System 2 - PTHP, use the bottom chart to calculate cooling-EIR"]
[3,"Baseline PTAC fan energy should be simulated as 0.3 W/CFM"]
[4,"Fill in cells highlighted with this color."]
[5,"Data to be entered in simulation software."]
[null,null,"Baseline Design",null,"Proposed Design"]
[null,null,"Common Space Systems","Apartment Systems","Apartment Systems","Common Space System1","Common Space System2","Common Space System3","Common Space System4","Common Space System5","Common Space System6"]
[null,"System Type","PTAC","PTAC"]
[null,"EER",11.009,11.009]
[null,"Net Cooling Capacity, Btu/Hr"]
[null,"Fan BHP","NA","NA"]
[null,"Fan Motor Efficiency","NA","NA"]
[null,"CFM","NA","NA"]
[null,"Fan kW/CFM",0.0003,0.0003,0,0,0,0,0,0,0]
[null,"EIR or 1/COP",0.2577895729181931,0.2577895729181931,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[null,null,"Baseline Design",null,"Proposed Design"]
[null,null,"Common Space Systems","Apartment Systems","Apartment Systems","Common Space System1","Common Space System2","Common Space System3","Common Space System4","Common Space System5","Common Space System6"]
[null,"System Type","PTHP","PTHP"]
[null,"Cooling EER",10.809,10.809]
[null,"Net Cooling Capacity, Btu/Hr"]
[null,"Fan BHP","NA","NA"]
[null,"Fan Motor Efficiency","NA","NA"]
[null,"CFM","NA","NA"]
[null,"Fan kW/CFM",0.0003,0.0003,0,0,0,0,0,0,0]
[null,"EIR or 1/COP (COOLING)",0.26329718401113056,0.26329718401113056,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Net Heating Capacity, Btu/Hr"]
[null,"COP (HEATING)",3.018,3.018]
[null,"EIR or 1/COP (HEATING)",0.3313452617627568,0.3313452617627568,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"Results from eQUEST","index":15,"n_rows":48,"n_cols":70,"rows_kept":48,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"Instructions: "]
[1,"Open Parms.csv file that corresponds to baseline and proposed eQUEST models."]
[2,"Copy runs corresponding to four orientation exposures from baseline Parms.csv to row 13-16 below. If not rotated, copy into row 13 only."]
[3,"Copy run that corresponds to proposed design from proposed Parms.csv to row 19 below"]
[4,"These values will used to calculate the performance rating in the Simulation Summary worksheet"]
[5,"If building uses more than one fossil fuel or uses oil instead of gas for heating, adjustments are needed."]
[{"$nulls":11},"Annual Lighting","Annual Lighting","Annual Appliance","Annual Heating","Annual Cooling ","Annual Cooling ","Annual Other","Annual Other","Annual Appliance","Annual Heating","Annual Hot Water","Annual Other",{"$nulls":26},"Annual Lighting","Annual Lighting","Annual Appliance","Annual Heating","Annual Cooling ","Annual Cooling ","Annual Other","Annual Other","Annual Appliance","Annual Heating","Annual Hot Water","Annual Other"]
["Step1:","Baseline Design (copy runs corresponding to four exposures from <project name>-Parms.csv to row 13-16 below)",{"$nulls":9},"Electric Usage:",{"$nulls":12},"Non-Coincident Peak Demand:",{"$nulls":11},"Coincident Peak Demand:",{"$nulls":12},"Fuel Usage:",{"$nulls":12},"Source Energy:",null,"TDV Energy:",null,"Annual Utility Costs:"]
[{"$nulls":10},"SS-D","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","PS-E","BEPS","BEPS","TDV1","TDV1","ES-E","ES-E","ES-E","ES-E"]
[{"$nulls":10},"Peak Cooling","Ambient","Task","Misc","Space","Space","Heat","Pumps","Ventilation","Refrig","Heat Pump","Domestic","Exterior",null,"Ambient","Task","Misc","Space","Space","Heat","Pumps","Ventilation","Refrig","Heat Pump","Domestic","Exterior","Ambient","Task","Misc","Space","Space","Heat","Pumps","Ventilation","Refrig","Heat Pump","Domestic","Exterior","Bldg","Ambient","Task","Misc","Space","Space","Heat","Pumps","Ventilation","Refrig","Heat Pump","Domestic","Exterior",null,"Bldg","Bldg","Bldg","Bldg","Total","Total","Electric","Electric"]
["Run","Internal","Case","Short","Carry","Incremental","Incremental",null,null,null,"Coil Load","Lights","Lights","Equip","Heating","Cooling","Reject","& Aux","Fans","Display","Supplement","Hot Water","Usage","Total","Lights","Lights","Equip","Heating","Cooling","Reject","& Aux","Fans","Display","Supplement","Hot Water","Usage","Lights","Lights","Equip","Heating","Cooling","Reject","& Aux","Fans","Display","Supplement","Hot Water","Usage","Total","Lights","Lights","Equip","Heating","Cooling","Reject","& Aux","Fans","Display","Supplement","Hot Water","Usage","Total","Energy","EUI","Energy","EUI","Electric","Fuel","kWh","kW"]
["Type","Loads","#s","Name","Fwd","First Cost ($)","Annual Maint. ($)","Date & Time of Run","File Name","Case Description","kBtu","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kW","kW","kW","kW","kW","kW","kW","kW","kW","kW","kW","kW","kW","kW","kW","kW","kW","kW","kW","kW","kW","kW","kW","kW","kW","Therms","Therms","Therms","Therms","Therms","Therms","Therms","Therms","Therms","Therms","Therms","Therms","Therms","MBtu","kBtu/sf/yr","TDV-MBtu","TDV-kBtu/sf/yr","$","$","$","$"]
[]
[]
[]
[]
["Average of 4 exposures (needed in Simulation Summary)",{"$nulls":10},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Step2:","Proposed Design (copy run that corresponds to proposed design from <project name>-Parms.csv to row 19 below)"]
[]
[]
[]
[]
["Step3:","Energy Savings By Measure (copy runs that correspond to EACH parametric run from <project name>-Parms.csv to rows below). These are used to calculate savings in SIR by Measure worksheet"]
[{"$nulls":10},"Peak Cooling","Ambient","Task","Misc","Space","Space","Heat","Pumps","Ventilation","Refrig","Heat Pump","Domestic","Exterior",null,"Ambient","Task","Misc","Space","Space","Heat","Pumps","Ventilation","Refrig","Heat Pump","Domestic","Exterior","Ambient","Task","Misc","Space","Space","Heat","Pumps","Ventilation","Refrig","Heat Pump","Domestic","Exterior","Bldg","Ambient","Task","Misc","Space","Space","Heat","Pumps","Ventilation","Refrig","Heat Pump","Domestic","Exterior",null,"Bldg","Bldg","Bldg","Bldg","Total","Total","Electric","Electric"]
["Run","Internal","Case","Short","Carry","Incremental","Incremental",null,null,null,"Coil Load","Lights","Lights","Equip","Heating","Cooling","Reject","& Aux","Fans","Display","Supplement","Hot Water","Usage","Total","Lights","Lights","Equip","Heating","Cooling","Reject","& Aux","Fans","Display","Supplement","Hot Water","Usage","Lights","Lights","Equip","Heating","Cooling","Reject","& Aux","Fans","Display","Supplement","Hot Water","Usage","Total","Lights","Lights","Equip","Heating","Cooling","Reject","& Aux","Fans","Display","Supplement","Hot Water","Usage","Total","Energy","EUI","Energy","EUI","Electric","Fuel","kWh","kW"]
["Type","Loads","#s","Name","Fwd","First Cost ($)","Annual Maint. ($)","Date & Time of Run","File Name","Case Description","kBtu","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kW","kW","kW","kW","kW","kW","kW","kW","kW","kW","kW","kW","kW","kW","kW","kW","kW","kW","kW","kW","kW","kW","kW","kW","kW","Therms","Therms","Therms","Therms","Therms","Therms","Therms","Therms","Therms","Therms","Therms","Therms","Therms","MBtu","kBtu/sf/yr","TDV-MBtu","TDV-kBtu/sf/yr","$","$","$","$"]
{"$rows_empty":21}
["(these rows can be manually entered for calculations done outside of eQuest such as Solar Hot Water, Solar PV, etc)"]

{"sheet":"Simulation Summary","index":16,"n_rows":59,"n_cols":10,"rows_kept":59,"cut":false,"hidden":false,"merged":[[8,3,8,9],[9,3,9,9],[10,3,10,9],[11,3,11,9],[12,3,12,9],[21,2,21,4],[21,5,21,7],[37,2,37,4],[37,5,37,7],[37,8,38,8],[37,9,38,9],[21,8,22,8],[21,9,22,9]],"flags":["formulas_cached_only"]}
[null,"Instructions:"]
[1,"First fill in the Basic Info worksheet and copy results into Result Summary eQUEST worksheet."]
[2,"Fill in cells highlighted with this color."]
[3,"If oil is used rather than natural gas, modifications to table are needed."]
[4,"Baseline and Proposed design fuel usage is copied from the corresponding rows in Result Summary eQUEST worksheet."]
[5,"Performance rating is shown in Red Font"]
[6,"Energy cost savings associated with on-site power generation, including cogeneration, photovoltaics, and wind turbines, may not be used to meet the Performance Target of 15%, but can be listed in Row 31."]
[null,"Building Area Summary (conditioned spaces only)"]
[null,"Space Type","Area, SqFt","Notes"]
[null,"Residential ",0,"Include total floor area of all residential units in building"]
[null,"Common Area",0,"Include combined floor area of residential-associated spaces (corridors, recreation areas, lobbies, etc.)"]
[null,"Commercial Area",0,"Include combined floor area of nonresidential spaces (commerical, office, retail, food sales, etc.)"]
[null,"Garage",0,"Include floor area of enclosed/underground garages"]
[null,"Total Conditioned",0]
[]
[null,"Fuel Cost"]
[null,"Electricity",null,"$/kWh"]
[null,"Natural Gas",null,"$/Therm"]
[null,"Fuel Oil",null,"$/Gallon"]
[]
[null,"Performance Rating Calculation"]
[null,null,"Baseline",null,null,"Proposed",null,null,"Site BTU Savings, %","$ Savings, %"]
[null,null,"Fossil Fuel, Btu","Electricity, Btu","Cost, $","Fossil Fuel, Btu","Electricity, Btu","Cost, $"]
[null,"Annual Heating",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Annual Cooling ",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Annual Lighting",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Annual Hot Water",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Annual Appliance",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Annual Other",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Total without Renewable",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Annual Renewable",0,0,0,null,null,0,0,0]
[null,"Total with Renewable",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[{"$nulls":7},{"$error":"#DIV/0!"},"average monthly gas costs per apartment"]
[{"$nulls":7},{"$error":"#DIV/0!"},"average monthly electricity costs per apartment"]
[]
[null,"Utility Bill Comparison"]
[null,null,"Baseline",null,null,"Proposed",null,null,"Site BTU Savings, %","$ Savings, %"]
[null,null,"Fossil Fuel, therms","Electricity, kWh","Cost, $","Fossil Fuel, therms","Electricity, kWh","Cost, $"]
[null,"Annual Heating",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Annual Cooling ",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Annual Lighting",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Annual Hot Water",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Annual Appliance",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Annual Other",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Total with Renewable",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[null,"Energy Usage per Square Foot of Conditioned Area"]
[]
[null,null,"Baseline","Proposed"]
[null,null,"Btu/SqFt","Btu/SqFt"]
[null,"Annual Heating",0,0]
[null,"Annual Cooling ",0,0]
[null,"Annual Lighting",0,0]
[null,"Annual Hot Water",0,0]
[null,"Annual Appliance",0,0]
[null,"Annual Other",0,0]
[null,"Total without Renewable",0,0]

{"sheet":"Tables of Values","index":17,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":true,"merged":[[0,0,0,1],[9,0,9,2]],"flags":["formulas_cached_only"]}
["Baseline Fixtures, per EPAct 1992"]
["Fixture","Flow Rate"]
["Baseline Toilets (GPF)",1.6]
["Baseline Urinals (GPF)",1]
["Baseline Showerheads (GPM)",2.5]
["Baseline Bathroom Faucets (GPM)",2.5]
["Baseline Kitchen Faucets (GPM)",2.5]
[]
[]
["Fixture Use"]
["Fixture Type","Duration (sec)","Uses/Day/Occupant"]
["Toilets","-",5]
["Urinals","-",5]
["Showerheads",300,1]
["Bathroom Faucets",15,5]
["Kitchen Faucets",60,4]