{"text_format":"1","workbook":"xlsx","n_sheets":33,"sheets":["INSTRUCTIONS","PROJECT DATA","Site 1 PSS","Site 2 PSS","Site 3 PSS","Site 4 PSS","Site 5 PSS","Site 6 PSS","Site 7 PSS","Site 8 PSS","Site 9 PSS","Site 10 PSS","Site 11 PSS","Site 12 PSS","Site 13 PSS","Site 14 PSS","Site 15 PSS","Site 16 PSS","Site 17 PSS","Site 18 PSS","Site 19 PSS","Site 20 PSS","1st Quarter PSS","1st Quarter Payment","2nd Quarter PSS","2nd Quarter Payment","3rd Quarter PSS","3rd Quarter Payment","4th Quarter PSS","4th Quarter Payment","Total Aggregated Savings","15% Withheld Payment","References"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":32,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"INSTRUCTIONS","index":0,"n_rows":35,"n_cols":2,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Project Summary Sheet Template Instructions"]
[]
["Project Data Tab"]
[null,"» This tab collects basic project data and populates this information in the subsequent tabs"]
[null,"» This tab also collects baseline energy use to enable the \"Percent of Savings to Total Energy Consumption (%)\" fields to auto calculate in the site specific PSS tabs and the Total Aggregated Savings tab"]
[null,"» Insert the information required in the Project Information box"]
[null,"» Insert the site owner name and site street address of each participant site next to their Participant Site number"]
[null,"» Insert the baseline fuel consumption of each participant site in the units identified"]
[null,"» Add more rows to the table, as necessary (after row 22)"]
[null,"» Update the conversion factors in the MMBTU Conversion Factor Table (in Column C), as necessary"]
[]
["Site Specific PSS tabs: "]
[null,"» Fill in the green highlighted cells"]
[null,"» Check the box in cell B5 if the site is a small business or non-profit with 10 full-time equivalent (40 hrs./week) employees or less"]
[null,"» Paste table into the Participant Site Energy Study Report"]
[null,"» Additional Site Specific PSS tabs can be unhidden, if necessary. To unhide a tab, right click on any tab and select 'unhide'. Select the appropriate tab to unhide. If more than site specific PSS tabs are necessary for your project, reach out to your NYSERDA Project Manager for assistance. "]
[]
["Quarterly PSS tabs: "]
[null,"» Fill in the green highlighted cells. You can copy and PASTE VALUES from the site specific PSS tables into the quarterly PSS tables"]
[null,"» Only include savings from the participant site energy study reports that were approved by NYSERDA during the specific quarter"]
[null,"» Submit as the Quarterly Aggregation Report "]
[null,"» Upload entire spreadsheet to SharePoint with the appropriate Quarterly PSS tab completed. Use the following naming convention: \"AGG [####] - [Project Name] - Q[#] Report - [Date]\". "]
[null,"» If revisions to the spreadsheet are necessary, insert revision number in the file name: \"AGG [####] - [Project Name] - Q[#] Report_Rev[#] - [Date]\""]
[null,"» Include each Quarterly PSS table into an appendix of the Final Aggregation Project Report "]
[]
["Total Aggregated PSS tab: "]
[null,"» Fill in the green highlighted cells"]
[null,"» Paste table into the Final Aggregation Project Report "]
[]
["Quarterly Payment tabs: "]
[null,"» Fill in the green highlighted cells"]
[null,"» Submit in conjunction with the Quarterly Aggregation Reports"]
[null,"» Upload entire spreadsheet to SharePoint with the appropriate Quarterly PSS tab completed. Use the following naming convention: \"AGG [####] - [Project Name] - Q[#] Report - [Date]\". "]
[null,"» If revisions to the spreadsheet are necessary, insert revision number in the file name: \"AGG [####] - [Project Name] - Q[#] Report_Rev[#] - [Date]\""]
[null,"» The calculated performance incentives are based on the total recommended savings from the corresponding Quarterly PSS tab, post NYSERDA technical review and approval"]

{"sheet":"PROJECT DATA","index":1,"n_rows":39,"n_cols":20,"rows_kept":39,"cut":false,"hidden":false,"merged":[[19,2,19,4],[7,2,7,4],[9,2,9,4],[10,2,10,4],[3,7,3,16],[9,5,9,6],[10,5,10,6],[11,5,11,6],[12,5,12,6],[13,5,13,6],[14,5,14,6],[15,5,15,6],[16,2,16,4],[19,5,19,6],[0,0,0,16],[5,7,5,16],[17,2,17,4],[18,2,18,4],[11,2,11,4],[12,2,12,4],[13,2,13,4],[14,2,14,4],[15,2,15,4],[16,5,16,6],[17,5,17,6],[18,5,18,6],[27,0,27,6],[8,2,8,4],[1,1,1,2],[2,1,2,2],[3,1,3,2],[25,2,25,4],[26,2,26,4],[21,2,21,4],[22,2,22,4],[23,2,23,4],[24,2,24,4],[6,2,6,4],[7,5,7,6],[6,5,6,6],[8,5,8,6],[20,2,20,4],[20,5,20,6],[26,5,26,6],[21,5,21,6],[22,5,22,6],[23,5,23,6],[24,5,24,6],[25,5,25,6]]}
["PROJECT INFORMATION"]
["AGG #:",null,null,null,"NYSERDA PO #:"]
["Consultant: ",null,null,null,"FT Consultant #: "]
["Portfolio #:",null,null,null,null,null,null,"BASELINE ENERGY CONVERSION TABLE"]
[]
[null,null,null,null,null,null,null,"Baseline Consumption"]
[null,null,"Site Owner Company: ",null,null,"Site Street Address:",null,"Electric (kWh)","Natural Gas (therms)","#2 Oil (gallons)","#4 Oil (gallons)","#6 Oil (gallons)","Steam \n(lbs.)","Propane (gallons)","Coal (gallons)","Other (MMBtu)","Total Baseline Consumption\n(MMBtu)",null,"Full Participant Site Name","Energy Study  Approval Quarter"]
["Participant Site 1 : ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H8*$B$31+I8*$B$32+J8*$B$33+K8*$B$34+L8*$B$35+M8*$B$36+N8*$B$37+O8*$B$38+P8","v":0},null,{"$f":"IF(OR(C8=\"\",F8=\"\"),\"\",CONCATENATE(C8,\" - \",F8))","v":""}]
["Participant Site 2 : ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(OR(C9=\"\",F9=\"\"),\"\",CONCATENATE(C9,\" - \",F9))","v":""}]
["Participant Site 3 : ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,""]
["Participant Site 4 : ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,""]
["Participant Site 5 : ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,""]
["Participant Site 6 : ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,""]
["Participant Site 7 : ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,""]
["Participant Site 8 : ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,""]
["Participant Site 9 : ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,""]
["Participant Site 10 : ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,""]
["Participant Site 11 : ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,""]
["Participant Site 12 : ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,""]
["Participant Site 13 : ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,""]
["Participant Site 14 : ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,""]
["Participant Site 15 : ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,""]
["Participant Site 16 : ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,""]
["Participant Site 17 : ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,""]
["Participant Site 18 : ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,""]
["Participant Site 19 : ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,""]
["Participant Site 20 : ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,""]
["Total Aggregation Portfolio :    ",null,null,null,null,null,null,{"$f":"SUM(H8:H27)","v":0},0,0,0,0,0,0,0,0,{"$f":"(H28*$B$31)+(I28*$B$32)+(J28*$B$33)+(K28*$B$34)+(L28*$B$35)+(M28*$B$36)+(N28*$B$37)+(O28*$B$38)+P28","v":0}]
[]
["MMBtu Conversion Factors"]
["kWh",3.4120000000000001E-3,null,null,"Notes:"]
["therms",0.1,null,null,"» This tab serves to enable the \"Percent of Savings to Total Energy Consumption (%)\" fields to auto calculate in the site specific PSS tabs and the Total Aggregated Savings tab"]
["#2 gallon",0.13900000000000001,null,null,"» The Participant Site names are linked from the Site Specific PSS tabs"]
["#4 gallon",0.1467,null,null,"» Insert the baseline fuel consumption of each participant site in the units identified"]
["#6 gallon",0.15,null,null,"» Add more rows to the table, as necessary (after row 22)"]
["Steam lbs.",1.194E-3,null,null,"» Update the conversion factors in the MMBTU Conversion Factor Table (in Column C), as necessary"]
["LPG gallon",9.1499999999999998E-2]
["Coal tons",24]
["Other",1]

{"sheet":"Site 1 PSS","index":2,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,7,2,9],[29,0,29,9],[32,0,32,9],[6,6,7,6],[6,9,7,9],[26,0,26,2],[27,0,27,2],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,6,4],[6,5,7,5],[6,7,7,7],[6,8,7,8]]}
[]
[]
["Participant Site: ",{"$f":"IF(OR('PROJECT DATA'!F8=\"\",'PROJECT DATA'!C8=\"\"),\"\",CONCATENATE('PROJECT DATA'!C8,\" - \",'PROJECT DATA'!F8))","v":""},null,null,null,null,"AGG Project: ",{"$f":"IF('PROJECT DATA'!$B$2=\"\",\"\",CONCATENATE(\"AGG \",'PROJECT DATA'!$B$2,\" - \",'PROJECT DATA'!$B$3,\" - Portfolio #\",'PROJECT DATA'!$B$4))","v":""}]
[]
[]
["ENERGY SAVINGS SUMMARY"]
["Measure Description","Measure Status\n(see notes)","Fuel Type Saved\n(see notes)","Electric",null,"Fuel Savings\n(MMBtu)","Percent of Savings \nto Total Energy Consumption\n(%)","Annual Cost Savings","Implementation Cost","Simple Payback\n(Years)"]
[null,null,null,"Supply Savings\n(kWh)","Demand Savings\n(kW)"]
[null,null,null,null,null,null,{"$f":"IF(AND(D9=\"\",F9=\"\"),\"\",(D9*'PROJECT DATA'!$B$31+F9)/'PROJECT DATA'!$Q$8)","v":""},null,null,{"$f":"IFERROR(I9/H9,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(D10=\"\",F10=\"\"),\"\",(D10*'PROJECT DATA'!$B$31+F10)/'PROJECT DATA'!$Q$8)","v":""},null,null,{"$f":"IFERROR(I10/H10,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(D11=\"\",F11=\"\"),\"\",(D11*'PROJECT DATA'!$B$31+F11)/'PROJECT DATA'!$Q$8)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D12=\"\",F12=\"\"),\"\",(D12*'PROJECT DATA'!$B$31+F12)/'PROJECT DATA'!$Q$8)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D13=\"\",F13=\"\"),\"\",(D13*'PROJECT DATA'!$B$31+F13)/'PROJECT DATA'!$Q$8)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D14=\"\",F14=\"\"),\"\",(D14*'PROJECT DATA'!$B$31+F14)/'PROJECT DATA'!$Q$8)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D15=\"\",F15=\"\"),\"\",(D15*'PROJECT DATA'!$B$31+F15)/'PROJECT DATA'!$Q$8)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D16=\"\",F16=\"\"),\"\",(D16*'PROJECT DATA'!$B$31+F16)/'PROJECT DATA'!$Q$8)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D17=\"\",F17=\"\"),\"\",(D17*'PROJECT DATA'!$B$31+F17)/'PROJECT DATA'!$Q$8)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D18=\"\",F18=\"\"),\"\",(D18*'PROJECT DATA'!$B$31+F18)/'PROJECT DATA'!$Q$8)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D19=\"\",F19=\"\"),\"\",(D19*'PROJECT DATA'!$B$31+F19)/'PROJECT DATA'!$Q$8)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D20=\"\",F20=\"\"),\"\",(D20*'PROJECT DATA'!$B$31+F20)/'PROJECT DATA'!$Q$8)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D21=\"\",F21=\"\"),\"\",(D21*'PROJECT DATA'!$B$31+F21)/'PROJECT DATA'!$Q$8)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D22=\"\",F22=\"\"),\"\",(D22*'PROJECT DATA'!$B$31+F22)/'PROJECT DATA'!$Q$8)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D23=\"\",F23=\"\"),\"\",(D23*'PROJECT DATA'!$B$31+F23)/'PROJECT DATA'!$Q$8)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D24=\"\",F24=\"\"),\"\",(D24*'PROJECT DATA'!$B$31+F24)/'PROJECT DATA'!$Q$8)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D25=\"\",F25=\"\"),\"\",(D25*'PROJECT DATA'!$B$31+F25)/'PROJECT DATA'!$Q$8)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D26=\"\",F26=\"\"),\"\",(D26*'PROJECT DATA'!$B$31+F26)/'PROJECT DATA'!$Q$8)","v":""},null,null,""]
["TOTAL (Recommended Only):",null,null,{"$f":"SUMIF($B$9:$B$26,References!$A$2,D9:D26)+SUMIF($B$9:$B$26,References!$A$3,D9:D26)+SUMIF($B$9:$B$26,References!$A$6,D9:D26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,E9:E26)+SUMIF($B$9:$B$26,References!$A$3,E9:E26)+SUMIF($B$9:$B$26,References!$A$6,E9:E26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,F9:F26)+SUMIF($B$9:$B$26,References!$A$3,F9:F26)+SUMIF($B$9:$B$26,References!$A$6,F9:F26)","v":0},{"$f":"IFERROR(((D27*'PROJECT DATA'!B31)+F27)/'PROJECT DATA'!$Q$8,\"0\"%)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,H9:H26)+SUMIF($B$9:$B$26,References!$A$3,H9:H26)+SUMIF($B$9:$B$26,References!$A$6,H9:H26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,I9:I26)+SUMIF($B$9:$B$26,References!$A$3,I9:I26)+SUMIF($B$9:$B$26,References!$A$6,I9:I26)","v":0},{"$f":"IFERROR(I27/H27,\"0.0\")","v":"0.0"}]
["TOTAL (All):",null,null,{"$f":"SUM(D9:D26)","v":0},0,0,{"$f":"IFERROR(((D28*'PROJECT DATA'!B31)+F28)/'PROJECT DATA'!$Q$8,\"0\"%)","v":0},0,0,{"$f":"IFERROR(I28/H28,\"0.0\")","v":"0.0"}]
["Notes:"]
["* Measure Status: Implemented (I); Recommended (R); Further Study Recommended (RS); Not Recommended (NR); Recommended Mutually Exclusive (RME); Mutually Exclusive (ME); Recommended Non-Energy (RNE)"]
[" * Fuel Type Saved: Indicate the fuel type of the reported MMBtu savings"]
["* MMBtu = 1,000,000 Btu"]
["* Energy savings must be presented as savings at the customer’s utility meter(s), and not at the individual building or tenant space.  "]
["* Percent of Savings to Total Fuel Consumption is auto-calculated from the data in the Energy Conversion tab. It is a comparison of the total electric & fuel savings to the total baseline energy consumption"]

{"sheet":"Site 2 PSS","index":3,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[[6,6,7,6],[2,1,2,4],[2,7,2,9],[32,0,32,9],[6,7,7,7],[6,8,7,8],[6,9,7,9],[26,0,26,2],[27,0,27,2],[29,0,29,9],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,6,4],[6,5,7,5]]}
[]
[]
["Participant Site: ",{"$f":"IF(OR('PROJECT DATA'!F9=\"\",'PROJECT DATA'!C9=\"\"),\"\",CONCATENATE('PROJECT DATA'!C9,\" - \",'PROJECT DATA'!F9))","v":""},null,null,null,null,"AGG Project: ",{"$f":"IF('PROJECT DATA'!$B$2=\"\",\"\",CONCATENATE(\"AGG \",'PROJECT DATA'!$B$2,\" - \",'PROJECT DATA'!$B$3,\" - Portfolio #\",'PROJECT DATA'!$B$4))","v":""}]
[]
[]
["ENERGY SAVINGS SUMMARY"]
["Measure Description","Measure Status\n(see notes)","Fuel Type Saved\n(see notes)","Electric",null,"Fuel Savings\n(MMBtu)","Percent of Savings \nto Total Energy Consumption\n(%)","Annual Cost Savings","Implementation Cost","Simple Payback\n(Years)"]
[null,null,null,"Supply Savings\n(kWh)","Demand Savings\n(kW)"]
[null,null,null,null,null,null,{"$f":"IF(AND(D9=\"\",F9=\"\"),\"\",(D9*'PROJECT DATA'!$B$31+F9)/'PROJECT DATA'!$Q$9)","v":""},null,null,{"$f":"IFERROR(I9/H9,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(D10=\"\",F10=\"\"),\"\",(D10*'PROJECT DATA'!$B$31+F10)/'PROJECT DATA'!$Q$9)","v":""},null,null,{"$f":"IFERROR(I10/H10,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(D11=\"\",F11=\"\"),\"\",(D11*'PROJECT DATA'!$B$31+F11)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D12=\"\",F12=\"\"),\"\",(D12*'PROJECT DATA'!$B$31+F12)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D13=\"\",F13=\"\"),\"\",(D13*'PROJECT DATA'!$B$31+F13)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D14=\"\",F14=\"\"),\"\",(D14*'PROJECT DATA'!$B$31+F14)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D15=\"\",F15=\"\"),\"\",(D15*'PROJECT DATA'!$B$31+F15)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D16=\"\",F16=\"\"),\"\",(D16*'PROJECT DATA'!$B$31+F16)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D17=\"\",F17=\"\"),\"\",(D17*'PROJECT DATA'!$B$31+F17)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D18=\"\",F18=\"\"),\"\",(D18*'PROJECT DATA'!$B$31+F18)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D19=\"\",F19=\"\"),\"\",(D19*'PROJECT DATA'!$B$31+F19)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D20=\"\",F20=\"\"),\"\",(D20*'PROJECT DATA'!$B$31+F20)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D21=\"\",F21=\"\"),\"\",(D21*'PROJECT DATA'!$B$31+F21)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D22=\"\",F22=\"\"),\"\",(D22*'PROJECT DATA'!$B$31+F22)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D23=\"\",F23=\"\"),\"\",(D23*'PROJECT DATA'!$B$31+F23)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D24=\"\",F24=\"\"),\"\",(D24*'PROJECT DATA'!$B$31+F24)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D25=\"\",F25=\"\"),\"\",(D25*'PROJECT DATA'!$B$31+F25)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D26=\"\",F26=\"\"),\"\",(D26*'PROJECT DATA'!$B$31+F26)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
["TOTAL (Recommended Only):",null,null,{"$f":"SUMIF($B$9:$B$26,References!$A$2,D9:D26)+SUMIF($B$9:$B$26,References!$A$3,D9:D26)+SUMIF($B$9:$B$26,References!$A$6,D9:D26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,E9:E26)+SUMIF($B$9:$B$26,References!$A$3,E9:E26)+SUMIF($B$9:$B$26,References!$A$6,E9:E26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,F9:F26)+SUMIF($B$9:$B$26,References!$A$3,F9:F26)+SUMIF($B$9:$B$26,References!$A$6,F9:F26)","v":0},{"$f":"IFERROR(((D27*'PROJECT DATA'!B31)+F27)/'PROJECT DATA'!$Q$9,\"0\"%)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,H9:H26)+SUMIF($B$9:$B$26,References!$A$3,H9:H26)+SUMIF($B$9:$B$26,References!$A$6,H9:H26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,I9:I26)+SUMIF($B$9:$B$26,References!$A$3,I9:I26)+SUMIF($B$9:$B$26,References!$A$6,I9:I26)","v":0},{"$f":"IFERROR(I27/H27,\"0.0\")","v":"0.0"}]
["TOTAL (All):",null,null,{"$f":"SUM(D9:D26)","v":0},0,0,{"$f":"IFERROR(((D28*'PROJECT DATA'!B31)+F28)/'PROJECT DATA'!$Q$9,\"0\"%)","v":0},0,0,{"$f":"IFERROR(I28/H28,\"0.0\")","v":"0.0"}]
["Notes:"]
["* Measure Status: Implemented (I); Recommended (R); Further Study Recommended (RS); Not Recommended (NR); Recommended Mutually Exclusive (RME); Mutually Exclusive (ME); Recommended Non-Energy (RNE)"]
[" * Fuel Type Saved: Indicate the fuel type of the reported MMBtu savings"]
["* MMBtu = 1,000,000 Btu"]
["* Energy savings must be presented as savings at the customer’s utility meter(s), and not at the individual building or tenant space.  "]
["* Percent of Savings to Total Fuel Consumption is auto-calculated from the data in the Energy Conversion tab. It is a comparison of the total electric & fuel savings to the total baseline energy consumption"]

{"sheet":"Site 3 PSS","index":4,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":true,"merged":[[2,1,2,4],[2,7,2,9],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,6,4],[6,5,7,5],[6,6,7,6],[31,0,31,9],[6,7,7,7],[6,8,7,8],[6,9,7,9],[26,0,26,2],[27,0,27,2],[29,0,29,9]]}
[]
[]
["Participant Site: ",{"$f":"IF(OR('PROJECT DATA'!F10=\"\",'PROJECT DATA'!C10=\"\"),\"\",CONCATENATE('PROJECT DATA'!C10,\" - \",'PROJECT DATA'!F10))","v":""},null,null,null,null,"AGG Project: ",{"$f":"IF('PROJECT DATA'!$B$2=\"\",\"\",CONCATENATE(\"AGG \",'PROJECT DATA'!$B$2,\" - \",'PROJECT DATA'!$B$3,\" - Portfolio #\",'PROJECT DATA'!$B$4))","v":""}]
[]
[]
["ENERGY SAVINGS SUMMARY"]
["Measure Description","Measure Status\n(see notes)","Fuel Type Saved\n(see notes)","Electric",null,"Fuel Savings\n(MMBtu)","Percent of Savings \nto Total Energy Consumption\n(%)","Annual Cost Savings","Implementation Cost","Simple Payback\n(Years)"]
[null,null,null,"Supply Savings\n(kWh)","Demand Savings\n(kW)"]
[null,null,null,null,null,null,{"$f":"IF(AND(D9=\"\",F9=\"\"),\"\",(D9*'PROJECT DATA'!$B$31+F9)/'PROJECT DATA'!$Q$10)","v":""},null,null,{"$f":"IFERROR(I9/H9,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(D10=\"\",F10=\"\"),\"\",(D10*'PROJECT DATA'!$B$31+F10)/'PROJECT DATA'!$Q$10)","v":""},null,null,{"$f":"IFERROR(I10/H10,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(D11=\"\",F11=\"\"),\"\",(D11*'PROJECT DATA'!$B$31+F11)/'PROJECT DATA'!$Q$10)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D12=\"\",F12=\"\"),\"\",(D12*'PROJECT DATA'!$B$31+F12)/'PROJECT DATA'!$Q$10)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D13=\"\",F13=\"\"),\"\",(D13*'PROJECT DATA'!$B$31+F13)/'PROJECT DATA'!$Q$10)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D14=\"\",F14=\"\"),\"\",(D14*'PROJECT DATA'!$B$31+F14)/'PROJECT DATA'!$Q$10)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D15=\"\",F15=\"\"),\"\",(D15*'PROJECT DATA'!$B$31+F15)/'PROJECT DATA'!$Q$10)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D16=\"\",F16=\"\"),\"\",(D16*'PROJECT DATA'!$B$31+F16)/'PROJECT DATA'!$Q$10)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D17=\"\",F17=\"\"),\"\",(D17*'PROJECT DATA'!$B$31+F17)/'PROJECT DATA'!$Q$10)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D18=\"\",F18=\"\"),\"\",(D18*'PROJECT DATA'!$B$31+F18)/'PROJECT DATA'!$Q$10)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D19=\"\",F19=\"\"),\"\",(D19*'PROJECT DATA'!$B$31+F19)/'PROJECT DATA'!$Q$10)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D20=\"\",F20=\"\"),\"\",(D20*'PROJECT DATA'!$B$31+F20)/'PROJECT DATA'!$Q$10)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D21=\"\",F21=\"\"),\"\",(D21*'PROJECT DATA'!$B$31+F21)/'PROJECT DATA'!$Q$10)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D22=\"\",F22=\"\"),\"\",(D22*'PROJECT DATA'!$B$31+F22)/'PROJECT DATA'!$Q$10)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D23=\"\",F23=\"\"),\"\",(D23*'PROJECT DATA'!$B$31+F23)/'PROJECT DATA'!$Q$10)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D24=\"\",F24=\"\"),\"\",(D24*'PROJECT DATA'!$B$31+F24)/'PROJECT DATA'!$Q$10)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D25=\"\",F25=\"\"),\"\",(D25*'PROJECT DATA'!$B$31+F25)/'PROJECT DATA'!$Q$10)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D26=\"\",F26=\"\"),\"\",(D26*'PROJECT DATA'!$B$31+F26)/'PROJECT DATA'!$Q$10)","v":""},null,null,""]
["TOTAL (Recommended Only):",null,null,{"$f":"SUMIF($B$9:$B$26,References!$A$2,D9:D26)+SUMIF($B$9:$B$26,References!$A$3,D9:D26)+SUMIF($B$9:$B$26,References!$A$6,D9:D26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,E9:E26)+SUMIF($B$9:$B$26,References!$A$3,E9:E26)+SUMIF($B$9:$B$26,References!$A$6,E9:E26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,F9:F26)+SUMIF($B$9:$B$26,References!$A$3,F9:F26)+SUMIF($B$9:$B$26,References!$A$6,F9:F26)","v":0},{"$f":"IFERROR(((D27*'PROJECT DATA'!B31)+F27)/'PROJECT DATA'!$Q$10,\"0\"%)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,H9:H26)+SUMIF($B$9:$B$26,References!$A$3,H9:H26)+SUMIF($B$9:$B$26,References!$A$6,H9:H26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,I9:I26)+SUMIF($B$9:$B$26,References!$A$3,I9:I26)+SUMIF($B$9:$B$26,References!$A$6,I9:I26)","v":0},{"$f":"IFERROR(I27/H27,\"0.0\")","v":"0.0"}]
["TOTAL (All):",null,null,{"$f":"SUM(D9:D26)","v":0},0,0,{"$f":"IFERROR(((D28*'PROJECT DATA'!B31)+F28)/'PROJECT DATA'!$Q$10,\"0\"%)","v":0},0,0,{"$f":"IFERROR(I28/H28,\"0.0\")","v":"0.0"}]
["Notes:"]
["* Measure Status: Implemented (I); Recommended (R); Further Study Recommended (RS); Not Recommended (NR); Recommended Mutually Exclusive (RME); Mutually Exclusive (ME); Recommended Non-Energy (RNE)"]
["* MMBtu = 1,000,000 Btu"]
["* Energy savings must be presented as savings at the customer’s utility meter(s), and not at the individual building or tenant space.  "]
["* Percent of Savings to Total Fuel Consumption (%) should be a comparison of the total of all the electric and fuel savings to the total baseline energy consumption"]

{"sheet":"Site 4 PSS","index":5,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":true,"merged":[[2,1,2,4],[2,7,2,9],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,6,4],[6,5,7,5],[6,6,7,6],[31,0,31,9],[6,7,7,7],[6,8,7,8],[6,9,7,9],[26,0,26,2],[27,0,27,2],[29,0,29,9]]}
[]
[]
["Participant Site: ",{"$f":"IF(OR('PROJECT DATA'!F11=\"\",'PROJECT DATA'!C11=\"\"),\"\",CONCATENATE('PROJECT DATA'!C11,\" - \",'PROJECT DATA'!F11))","v":""},null,null,null,null,"AGG Project: ",{"$f":"IF('PROJECT DATA'!$B$2=\"\",\"\",CONCATENATE(\"AGG \",'PROJECT DATA'!$B$2,\" - \",'PROJECT DATA'!$B$3,\" - Portfolio #\",'PROJECT DATA'!$B$4))","v":""}]
[]
[]
["ENERGY SAVINGS SUMMARY"]
["Measure Description","Measure Status\n(see notes)","Fuel Type Saved\n(see notes)","Electric",null,"Fuel Savings\n(MMBtu)","Percent of Savings \nto Total Energy Consumption\n(%)","Annual Cost Savings","Implementation Cost","Simple Payback\n(Years)"]
[null,null,null,"Supply Savings\n(kWh)","Demand Savings\n(kW)"]
[null,null,null,null,null,null,{"$f":"IF(AND(D9=\"\",F9=\"\"),\"\",(D9*'PROJECT DATA'!$B$31+F9)/'PROJECT DATA'!$Q$11)","v":""},null,null,{"$f":"IFERROR(I9/H9,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(D10=\"\",F10=\"\"),\"\",(D10*'PROJECT DATA'!$B$31+F10)/'PROJECT DATA'!$Q$11)","v":""},null,null,{"$f":"IFERROR(I10/H10,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(D11=\"\",F11=\"\"),\"\",(D11*'PROJECT DATA'!$B$31+F11)/'PROJECT DATA'!$Q$11)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D12=\"\",F12=\"\"),\"\",(D12*'PROJECT DATA'!$B$31+F12)/'PROJECT DATA'!$Q$11)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D13=\"\",F13=\"\"),\"\",(D13*'PROJECT DATA'!$B$31+F13)/'PROJECT DATA'!$Q$11)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D14=\"\",F14=\"\"),\"\",(D14*'PROJECT DATA'!$B$31+F14)/'PROJECT DATA'!$Q$11)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D15=\"\",F15=\"\"),\"\",(D15*'PROJECT DATA'!$B$31+F15)/'PROJECT DATA'!$Q$11)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D16=\"\",F16=\"\"),\"\",(D16*'PROJECT DATA'!$B$31+F16)/'PROJECT DATA'!$Q$11)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D17=\"\",F17=\"\"),\"\",(D17*'PROJECT DATA'!$B$31+F17)/'PROJECT DATA'!$Q$11)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D18=\"\",F18=\"\"),\"\",(D18*'PROJECT DATA'!$B$31+F18)/'PROJECT DATA'!$Q$11)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D19=\"\",F19=\"\"),\"\",(D19*'PROJECT DATA'!$B$31+F19)/'PROJECT DATA'!$Q$11)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D20=\"\",F20=\"\"),\"\",(D20*'PROJECT DATA'!$B$31+F20)/'PROJECT DATA'!$Q$11)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D21=\"\",F21=\"\"),\"\",(D21*'PROJECT DATA'!$B$31+F21)/'PROJECT DATA'!$Q$11)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D22=\"\",F22=\"\"),\"\",(D22*'PROJECT DATA'!$B$31+F22)/'PROJECT DATA'!$Q$11)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D23=\"\",F23=\"\"),\"\",(D23*'PROJECT DATA'!$B$31+F23)/'PROJECT DATA'!$Q$11)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D24=\"\",F24=\"\"),\"\",(D24*'PROJECT DATA'!$B$31+F24)/'PROJECT DATA'!$Q$11)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D25=\"\",F25=\"\"),\"\",(D25*'PROJECT DATA'!$B$31+F25)/'PROJECT DATA'!$Q$11)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D26=\"\",F26=\"\"),\"\",(D26*'PROJECT DATA'!$B$31+F26)/'PROJECT DATA'!$Q$11)","v":""},null,null,""]
["TOTAL (Recommended Only):",null,null,{"$f":"SUMIF($B$9:$B$26,References!$A$2,D9:D26)+SUMIF($B$9:$B$26,References!$A$3,D9:D26)+SUMIF($B$9:$B$26,References!$A$6,D9:D26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,E9:E26)+SUMIF($B$9:$B$26,References!$A$3,E9:E26)+SUMIF($B$9:$B$26,References!$A$6,E9:E26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,F9:F26)+SUMIF($B$9:$B$26,References!$A$3,F9:F26)+SUMIF($B$9:$B$26,References!$A$6,F9:F26)","v":0},{"$f":"IFERROR(((D27*'PROJECT DATA'!B31)+F27)/'PROJECT DATA'!$Q$11,\"0\"%)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,H9:H26)+SUMIF($B$9:$B$26,References!$A$3,H9:H26)+SUMIF($B$9:$B$26,References!$A$6,H9:H26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,I9:I26)+SUMIF($B$9:$B$26,References!$A$3,I9:I26)+SUMIF($B$9:$B$26,References!$A$6,I9:I26)","v":0},{"$f":"IFERROR(I27/H27,\"0.0\")","v":"0.0"}]
["TOTAL (All):",null,null,{"$f":"SUM(D9:D26)","v":0},0,0,{"$f":"IFERROR(((D28*'PROJECT DATA'!B31)+F28)/'PROJECT DATA'!$Q$11,\"0\"%)","v":0},0,0,{"$f":"IFERROR(I28/H28,\"0.0\")","v":"0.0"}]
["Notes:"]
["* Measure Status: Implemented (I); Recommended (R); Further Study Recommended (RS); Not Recommended (NR); Recommended Mutually Exclusive (RME); Mutually Exclusive (ME); Recommended Non-Energy (RNE)"]
["* MMBtu = 1,000,000 Btu"]
["* Energy savings must be presented as savings at the customer’s utility meter(s), and not at the individual building or tenant space.  "]
["* Percent of Savings to Total Fuel Consumption (%) should be a comparison of the total of all the electric and fuel savings to the total baseline energy consumption"]

{"sheet":"Site 5 PSS","index":6,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":true,"merged":[[2,1,2,4],[2,7,2,9],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,6,4],[6,5,7,5],[6,6,7,6],[31,0,31,9],[6,7,7,7],[6,8,7,8],[6,9,7,9],[26,0,26,2],[27,0,27,2],[29,0,29,9]]}
[]
[]
["Participant Site: ",{"$f":"IF(OR('PROJECT DATA'!F12=\"\",'PROJECT DATA'!C12=\"\"),\"\",CONCATENATE('PROJECT DATA'!C12,\" - \",'PROJECT DATA'!F12))","v":""},null,null,null,null,"AGG Project: ",{"$f":"IF('PROJECT DATA'!$B$2=\"\",\"\",CONCATENATE(\"AGG \",'PROJECT DATA'!$B$2,\" - \",'PROJECT DATA'!$B$3,\" - Portfolio #\",'PROJECT DATA'!$B$4))","v":""}]
[]
[]
["ENERGY SAVINGS SUMMARY"]
["Measure Description","Measure Status\n(see notes)","Fuel Type Saved\n(see notes)","Electric",null,"Fuel Savings\n(MMBtu)","Percent of Savings \nto Total Energy Consumption\n(%)","Annual Cost Savings","Implementation Cost","Simple Payback\n(Years)"]
[null,null,null,"Supply Savings\n(kWh)","Demand Savings\n(kW)"]
[null,null,null,null,null,null,{"$f":"IF(AND(D9=\"\",F9=\"\"),\"\",(D9*'PROJECT DATA'!$B$31+F9)/'PROJECT DATA'!$Q$12)","v":""},null,null,{"$f":"IFERROR(I9/H9,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(D10=\"\",F10=\"\"),\"\",(D10*'PROJECT DATA'!$B$31+F10)/'PROJECT DATA'!$Q$12)","v":""},null,null,{"$f":"IFERROR(I10/H10,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(D11=\"\",F11=\"\"),\"\",(D11*'PROJECT DATA'!$B$31+F11)/'PROJECT DATA'!$Q$12)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D12=\"\",F12=\"\"),\"\",(D12*'PROJECT DATA'!$B$31+F12)/'PROJECT DATA'!$Q$12)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D13=\"\",F13=\"\"),\"\",(D13*'PROJECT DATA'!$B$31+F13)/'PROJECT DATA'!$Q$12)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D14=\"\",F14=\"\"),\"\",(D14*'PROJECT DATA'!$B$31+F14)/'PROJECT DATA'!$Q$12)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D15=\"\",F15=\"\"),\"\",(D15*'PROJECT DATA'!$B$31+F15)/'PROJECT DATA'!$Q$12)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D16=\"\",F16=\"\"),\"\",(D16*'PROJECT DATA'!$B$31+F16)/'PROJECT DATA'!$Q$12)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D17=\"\",F17=\"\"),\"\",(D17*'PROJECT DATA'!$B$31+F17)/'PROJECT DATA'!$Q$12)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D18=\"\",F18=\"\"),\"\",(D18*'PROJECT DATA'!$B$31+F18)/'PROJECT DATA'!$Q$12)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D19=\"\",F19=\"\"),\"\",(D19*'PROJECT DATA'!$B$31+F19)/'PROJECT DATA'!$Q$12)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D20=\"\",F20=\"\"),\"\",(D20*'PROJECT DATA'!$B$31+F20)/'PROJECT DATA'!$Q$12)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D21=\"\",F21=\"\"),\"\",(D21*'PROJECT DATA'!$B$31+F21)/'PROJECT DATA'!$Q$12)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D22=\"\",F22=\"\"),\"\",(D22*'PROJECT DATA'!$B$31+F22)/'PROJECT DATA'!$Q$12)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D23=\"\",F23=\"\"),\"\",(D23*'PROJECT DATA'!$B$31+F23)/'PROJECT DATA'!$Q$12)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D24=\"\",F24=\"\"),\"\",(D24*'PROJECT DATA'!$B$31+F24)/'PROJECT DATA'!$Q$12)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D25=\"\",F25=\"\"),\"\",(D25*'PROJECT DATA'!$B$31+F25)/'PROJECT DATA'!$Q$12)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D26=\"\",F26=\"\"),\"\",(D26*'PROJECT DATA'!$B$31+F26)/'PROJECT DATA'!$Q$12)","v":""},null,null,""]
["TOTAL (Recommended Only):",null,null,{"$f":"SUMIF($B$9:$B$26,References!$A$2,D9:D26)+SUMIF($B$9:$B$26,References!$A$3,D9:D26)+SUMIF($B$9:$B$26,References!$A$6,D9:D26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,E9:E26)+SUMIF($B$9:$B$26,References!$A$3,E9:E26)+SUMIF($B$9:$B$26,References!$A$6,E9:E26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,F9:F26)+SUMIF($B$9:$B$26,References!$A$3,F9:F26)+SUMIF($B$9:$B$26,References!$A$6,F9:F26)","v":0},{"$f":"IFERROR(((D27*'PROJECT DATA'!B31)+F27)/'PROJECT DATA'!$Q$12,\"0\"%)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,H9:H26)+SUMIF($B$9:$B$26,References!$A$3,H9:H26)+SUMIF($B$9:$B$26,References!$A$6,H9:H26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,I9:I26)+SUMIF($B$9:$B$26,References!$A$3,I9:I26)+SUMIF($B$9:$B$26,References!$A$6,I9:I26)","v":0},{"$f":"IFERROR(I27/H27,\"0.0\")","v":"0.0"}]
["TOTAL (All):",null,null,{"$f":"SUM(D9:D26)","v":0},0,0,{"$f":"IFERROR(((D28*'PROJECT DATA'!B31)+F28)/'PROJECT DATA'!$Q$12,\"0\"%)","v":0},0,0,{"$f":"IFERROR(I28/H28,\"0.0\")","v":"0.0"}]
["Notes:"]
["* Measure Status: Implemented (I); Recommended (R); Further Study Recommended (RS); Not Recommended (NR); Recommended Mutually Exclusive (RME); Mutually Exclusive (ME); Recommended Non-Energy (RNE)"]
["* MMBtu = 1,000,000 Btu"]
["* Energy savings must be presented as savings at the customer’s utility meter(s), and not at the individual building or tenant space.  "]
["* Percent of Savings to Total Fuel Consumption (%) should be a comparison of the total of all the electric and fuel savings to the total baseline energy consumption"]

{"sheet":"Site 6 PSS","index":7,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":true,"merged":[[2,1,2,4],[2,7,2,9],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,6,4],[6,5,7,5],[6,6,7,6],[31,0,31,9],[6,7,7,7],[6,8,7,8],[6,9,7,9],[26,0,26,2],[27,0,27,2],[29,0,29,9]]}
[]
[]
["Participant Site: ",{"$f":"IF(OR('PROJECT DATA'!F13=\"\",'PROJECT DATA'!C13=\"\"),\"\",CONCATENATE('PROJECT DATA'!C13,\" - \",'PROJECT DATA'!F13))","v":""},null,null,null,null,"AGG Project: ",{"$f":"IF('PROJECT DATA'!$B$2=\"\",\"\",CONCATENATE(\"AGG \",'PROJECT DATA'!$B$2,\" - \",'PROJECT DATA'!$B$3,\" - Portfolio #\",'PROJECT DATA'!$B$4))","v":""}]
[]
[]
["ENERGY SAVINGS SUMMARY"]
["Measure Description","Measure Status\n(see notes)","Fuel Type Saved\n(see notes)","Electric",null,"Fuel Savings\n(MMBtu)","Percent of Savings \nto Total Energy Consumption\n(%)","Annual Cost Savings","Implementation Cost","Simple Payback\n(Years)"]
[null,null,null,"Supply Savings\n(kWh)","Demand Savings\n(kW)"]
[null,null,null,null,null,null,{"$f":"IF(AND(D9=\"\",F9=\"\"),\"\",(D9*'PROJECT DATA'!$B$31+F9)/'PROJECT DATA'!$Q$9)","v":""},null,null,{"$f":"IFERROR(I9/H9,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(D10=\"\",F10=\"\"),\"\",(D10*'PROJECT DATA'!$B$31+F10)/'PROJECT DATA'!$Q$9)","v":""},null,null,{"$f":"IFERROR(I10/H10,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(D11=\"\",F11=\"\"),\"\",(D11*'PROJECT DATA'!$B$31+F11)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D12=\"\",F12=\"\"),\"\",(D12*'PROJECT DATA'!$B$31+F12)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D13=\"\",F13=\"\"),\"\",(D13*'PROJECT DATA'!$B$31+F13)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D14=\"\",F14=\"\"),\"\",(D14*'PROJECT DATA'!$B$31+F14)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D15=\"\",F15=\"\"),\"\",(D15*'PROJECT DATA'!$B$31+F15)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D16=\"\",F16=\"\"),\"\",(D16*'PROJECT DATA'!$B$31+F16)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D17=\"\",F17=\"\"),\"\",(D17*'PROJECT DATA'!$B$31+F17)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D18=\"\",F18=\"\"),\"\",(D18*'PROJECT DATA'!$B$31+F18)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D19=\"\",F19=\"\"),\"\",(D19*'PROJECT DATA'!$B$31+F19)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D20=\"\",F20=\"\"),\"\",(D20*'PROJECT DATA'!$B$31+F20)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D21=\"\",F21=\"\"),\"\",(D21*'PROJECT DATA'!$B$31+F21)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D22=\"\",F22=\"\"),\"\",(D22*'PROJECT DATA'!$B$31+F22)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D23=\"\",F23=\"\"),\"\",(D23*'PROJECT DATA'!$B$31+F23)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D24=\"\",F24=\"\"),\"\",(D24*'PROJECT DATA'!$B$31+F24)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D25=\"\",F25=\"\"),\"\",(D25*'PROJECT DATA'!$B$31+F25)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D26=\"\",F26=\"\"),\"\",(D26*'PROJECT DATA'!$B$31+F26)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
["TOTAL (Recommended Only):",null,null,{"$f":"SUMIF($B$9:$B$26,References!$A$2,D9:D26)+SUMIF($B$9:$B$26,References!$A$3,D9:D26)+SUMIF($B$9:$B$26,References!$A$6,D9:D26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,E9:E26)+SUMIF($B$9:$B$26,References!$A$3,E9:E26)+SUMIF($B$9:$B$26,References!$A$6,E9:E26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,F9:F26)+SUMIF($B$9:$B$26,References!$A$3,F9:F26)+SUMIF($B$9:$B$26,References!$A$6,F9:F26)","v":0},{"$f":"IFERROR(((D27*'PROJECT DATA'!B31)+F27)/'PROJECT DATA'!$Q$10,\"0\"%)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,H9:H26)+SUMIF($B$9:$B$26,References!$A$3,H9:H26)+SUMIF($B$9:$B$26,References!$A$6,H9:H26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,I9:I26)+SUMIF($B$9:$B$26,References!$A$3,I9:I26)+SUMIF($B$9:$B$26,References!$A$6,I9:I26)","v":0},{"$f":"IFERROR(I27/H27,\"0.0\")","v":"0.0"}]
["TOTAL (All):",null,null,{"$f":"SUM(D9:D26)","v":0},0,0,{"$f":"IFERROR(((D28*'PROJECT DATA'!B31)+F28)/'PROJECT DATA'!$Q$10,\"0\"%)","v":0},0,0,{"$f":"IFERROR(I28/H28,\"0.0\")","v":"0.0"}]
["Notes:"]
["* Measure Status: Implemented (I); Recommended (R); Further Study Recommended (RS); Not Recommended (NR); Recommended Mutually Exclusive (RME); Mutually Exclusive (ME); Recommended Non-Energy (RNE)"]
["* MMBtu = 1,000,000 Btu"]
["* Energy savings must be presented as savings at the customer’s utility meter(s), and not at the individual building or tenant space.  "]
["* Percent of Savings to Total Fuel Consumption (%) should be a comparison of the total of all the electric and fuel savings to the total baseline energy consumption"]

{"sheet":"Site 7 PSS","index":8,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":true,"merged":[[2,1,2,4],[2,7,2,9],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,6,4],[6,5,7,5],[6,6,7,6],[31,0,31,9],[6,7,7,7],[6,8,7,8],[6,9,7,9],[26,0,26,2],[27,0,27,2],[29,0,29,9]]}
[]
[]
["Participant Site: ",{"$f":"IF(OR('PROJECT DATA'!F14=\"\",'PROJECT DATA'!C14=\"\"),\"\",CONCATENATE('PROJECT DATA'!C14,\" - \",'PROJECT DATA'!F14))","v":""},null,null,null,null,"AGG Project: ",{"$f":"IF('PROJECT DATA'!$B$2=\"\",\"\",CONCATENATE(\"AGG \",'PROJECT DATA'!$B$2,\" - \",'PROJECT DATA'!$B$3,\" - Portfolio #\",'PROJECT DATA'!$B$4))","v":""}]
[]
[]
["ENERGY SAVINGS SUMMARY"]
["Measure Description","Measure Status\n(see notes)","Fuel Type Saved\n(see notes)","Electric",null,"Fuel Savings\n(MMBtu)","Percent of Savings \nto Total Energy Consumption\n(%)","Annual Cost Savings","Implementation Cost","Simple Payback\n(Years)"]
[null,null,null,"Supply Savings\n(kWh)","Demand Savings\n(kW)"]
[null,null,null,null,null,null,{"$f":"IF(AND(D9=\"\",F9=\"\"),\"\",(D9*'PROJECT DATA'!$B$31+F9)/'PROJECT DATA'!$Q$9)","v":""},null,null,{"$f":"IFERROR(I9/H9,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(D10=\"\",F10=\"\"),\"\",(D10*'PROJECT DATA'!$B$31+F10)/'PROJECT DATA'!$Q$9)","v":""},null,null,{"$f":"IFERROR(I10/H10,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(D11=\"\",F11=\"\"),\"\",(D11*'PROJECT DATA'!$B$31+F11)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D12=\"\",F12=\"\"),\"\",(D12*'PROJECT DATA'!$B$31+F12)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D13=\"\",F13=\"\"),\"\",(D13*'PROJECT DATA'!$B$31+F13)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D14=\"\",F14=\"\"),\"\",(D14*'PROJECT DATA'!$B$31+F14)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D15=\"\",F15=\"\"),\"\",(D15*'PROJECT DATA'!$B$31+F15)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D16=\"\",F16=\"\"),\"\",(D16*'PROJECT DATA'!$B$31+F16)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D17=\"\",F17=\"\"),\"\",(D17*'PROJECT DATA'!$B$31+F17)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D18=\"\",F18=\"\"),\"\",(D18*'PROJECT DATA'!$B$31+F18)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D19=\"\",F19=\"\"),\"\",(D19*'PROJECT DATA'!$B$31+F19)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D20=\"\",F20=\"\"),\"\",(D20*'PROJECT DATA'!$B$31+F20)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D21=\"\",F21=\"\"),\"\",(D21*'PROJECT DATA'!$B$31+F21)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D22=\"\",F22=\"\"),\"\",(D22*'PROJECT DATA'!$B$31+F22)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D23=\"\",F23=\"\"),\"\",(D23*'PROJECT DATA'!$B$31+F23)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D24=\"\",F24=\"\"),\"\",(D24*'PROJECT DATA'!$B$31+F24)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D25=\"\",F25=\"\"),\"\",(D25*'PROJECT DATA'!$B$31+F25)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D26=\"\",F26=\"\"),\"\",(D26*'PROJECT DATA'!$B$31+F26)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
["TOTAL (Recommended Only):",null,null,{"$f":"SUMIF($B$9:$B$26,References!$A$2,D9:D26)+SUMIF($B$9:$B$26,References!$A$3,D9:D26)+SUMIF($B$9:$B$26,References!$A$6,D9:D26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,E9:E26)+SUMIF($B$9:$B$26,References!$A$3,E9:E26)+SUMIF($B$9:$B$26,References!$A$6,E9:E26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,F9:F26)+SUMIF($B$9:$B$26,References!$A$3,F9:F26)+SUMIF($B$9:$B$26,References!$A$6,F9:F26)","v":0},{"$f":"IFERROR(((D27*'PROJECT DATA'!B31)+F27)/'PROJECT DATA'!$Q$10,\"0\"%)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,H9:H26)+SUMIF($B$9:$B$26,References!$A$3,H9:H26)+SUMIF($B$9:$B$26,References!$A$6,H9:H26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,I9:I26)+SUMIF($B$9:$B$26,References!$A$3,I9:I26)+SUMIF($B$9:$B$26,References!$A$6,I9:I26)","v":0},{"$f":"IFERROR(I27/H27,\"0.0\")","v":"0.0"}]
["TOTAL (All):",null,null,{"$f":"SUM(D9:D26)","v":0},0,0,{"$f":"IFERROR(((D28*'PROJECT DATA'!B31)+F28)/'PROJECT DATA'!$Q$10,\"0\"%)","v":0},0,0,{"$f":"IFERROR(I28/H28,\"0.0\")","v":"0.0"}]
["Notes:"]
["* Measure Status: Implemented (I); Recommended (R); Further Study Recommended (RS); Not Recommended (NR); Recommended Mutually Exclusive (RME); Mutually Exclusive (ME); Recommended Non-Energy (RNE)"]
["* MMBtu = 1,000,000 Btu"]
["* Energy savings must be presented as savings at the customer’s utility meter(s), and not at the individual building or tenant space.  "]
["* Percent of Savings to Total Fuel Consumption (%) should be a comparison of the total of all the electric and fuel savings to the total baseline energy consumption"]

{"sheet":"Site 8 PSS","index":9,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":true,"merged":[[2,1,2,4],[2,7,2,9],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,6,4],[6,5,7,5],[6,6,7,6],[31,0,31,9],[6,7,7,7],[6,8,7,8],[6,9,7,9],[26,0,26,2],[27,0,27,2],[29,0,29,9]]}
[]
[]
["Participant Site: ",{"$f":"IF(OR('PROJECT DATA'!F15=\"\",'PROJECT DATA'!C15=\"\"),\"\",CONCATENATE('PROJECT DATA'!C15,\" - \",'PROJECT DATA'!F15))","v":""},null,null,null,null,"AGG Project: ",{"$f":"IF('PROJECT DATA'!$B$2=\"\",\"\",CONCATENATE(\"AGG \",'PROJECT DATA'!$B$2,\" - \",'PROJECT DATA'!$B$3,\" - Portfolio #\",'PROJECT DATA'!$B$4))","v":""}]
[]
[]
["ENERGY SAVINGS SUMMARY"]
["Measure Description","Measure Status\n(see notes)","Fuel Type Saved\n(see notes)","Electric",null,"Fuel Savings\n(MMBtu)","Percent of Savings \nto Total Energy Consumption\n(%)","Annual Cost Savings","Implementation Cost","Simple Payback\n(Years)"]
[null,null,null,"Supply Savings\n(kWh)","Demand Savings\n(kW)"]
[null,null,null,null,null,null,{"$f":"IF(AND(D9=\"\",F9=\"\"),\"\",(D9*'PROJECT DATA'!$B$31+F9)/'PROJECT DATA'!$Q$9)","v":""},null,null,{"$f":"IFERROR(I9/H9,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(D10=\"\",F10=\"\"),\"\",(D10*'PROJECT DATA'!$B$31+F10)/'PROJECT DATA'!$Q$9)","v":""},null,null,{"$f":"IFERROR(I10/H10,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(D11=\"\",F11=\"\"),\"\",(D11*'PROJECT DATA'!$B$31+F11)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D12=\"\",F12=\"\"),\"\",(D12*'PROJECT DATA'!$B$31+F12)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D13=\"\",F13=\"\"),\"\",(D13*'PROJECT DATA'!$B$31+F13)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D14=\"\",F14=\"\"),\"\",(D14*'PROJECT DATA'!$B$31+F14)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D15=\"\",F15=\"\"),\"\",(D15*'PROJECT DATA'!$B$31+F15)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D16=\"\",F16=\"\"),\"\",(D16*'PROJECT DATA'!$B$31+F16)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D17=\"\",F17=\"\"),\"\",(D17*'PROJECT DATA'!$B$31+F17)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D18=\"\",F18=\"\"),\"\",(D18*'PROJECT DATA'!$B$31+F18)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D19=\"\",F19=\"\"),\"\",(D19*'PROJECT DATA'!$B$31+F19)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D20=\"\",F20=\"\"),\"\",(D20*'PROJECT DATA'!$B$31+F20)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D21=\"\",F21=\"\"),\"\",(D21*'PROJECT DATA'!$B$31+F21)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D22=\"\",F22=\"\"),\"\",(D22*'PROJECT DATA'!$B$31+F22)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D23=\"\",F23=\"\"),\"\",(D23*'PROJECT DATA'!$B$31+F23)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D24=\"\",F24=\"\"),\"\",(D24*'PROJECT DATA'!$B$31+F24)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D25=\"\",F25=\"\"),\"\",(D25*'PROJECT DATA'!$B$31+F25)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D26=\"\",F26=\"\"),\"\",(D26*'PROJECT DATA'!$B$31+F26)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
["TOTAL (Recommended Only):",null,null,{"$f":"SUMIF($B$9:$B$26,References!$A$2,D9:D26)+SUMIF($B$9:$B$26,References!$A$3,D9:D26)+SUMIF($B$9:$B$26,References!$A$6,D9:D26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,E9:E26)+SUMIF($B$9:$B$26,References!$A$3,E9:E26)+SUMIF($B$9:$B$26,References!$A$6,E9:E26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,F9:F26)+SUMIF($B$9:$B$26,References!$A$3,F9:F26)+SUMIF($B$9:$B$26,References!$A$6,F9:F26)","v":0},{"$f":"IFERROR(((D27*'PROJECT DATA'!B31)+F27)/'PROJECT DATA'!$Q$10,\"0\"%)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,H9:H26)+SUMIF($B$9:$B$26,References!$A$3,H9:H26)+SUMIF($B$9:$B$26,References!$A$6,H9:H26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,I9:I26)+SUMIF($B$9:$B$26,References!$A$3,I9:I26)+SUMIF($B$9:$B$26,References!$A$6,I9:I26)","v":0},{"$f":"IFERROR(I27/H27,\"0.0\")","v":"0.0"}]
["TOTAL (All):",null,null,{"$f":"SUM(D9:D26)","v":0},0,0,{"$f":"IFERROR(((D28*'PROJECT DATA'!B31)+F28)/'PROJECT DATA'!$Q$10,\"0\"%)","v":0},0,0,{"$f":"IFERROR(I28/H28,\"0.0\")","v":"0.0"}]
["Notes:"]
["* Measure Status: Implemented (I); Recommended (R); Further Study Recommended (RS); Not Recommended (NR); Recommended Mutually Exclusive (RME); Mutually Exclusive (ME); Recommended Non-Energy (RNE)"]
["* MMBtu = 1,000,000 Btu"]
["* Energy savings must be presented as savings at the customer’s utility meter(s), and not at the individual building or tenant space.  "]
["* Percent of Savings to Total Fuel Consumption (%) should be a comparison of the total of all the electric and fuel savings to the total baseline energy consumption"]

{"sheet":"Site 9 PSS","index":10,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":true,"merged":[[2,1,2,4],[2,7,2,9],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,6,4],[6,5,7,5],[6,6,7,6],[31,0,31,9],[6,7,7,7],[6,8,7,8],[6,9,7,9],[26,0,26,2],[27,0,27,2],[29,0,29,9]]}
[]
[]
["Participant Site: ",{"$f":"IF(OR('PROJECT DATA'!F16=\"\",'PROJECT DATA'!C16=\"\"),\"\",CONCATENATE('PROJECT DATA'!C16,\" - \",'PROJECT DATA'!F16))","v":""},null,null,null,null,"AGG Project: ",{"$f":"IF('PROJECT DATA'!$B$2=\"\",\"\",CONCATENATE(\"AGG \",'PROJECT DATA'!$B$2,\" - \",'PROJECT DATA'!$B$3,\" - Portfolio #\",'PROJECT DATA'!$B$4))","v":""}]
[]
[]
["ENERGY SAVINGS SUMMARY"]
["Measure Description","Measure Status\n(see notes)","Fuel Type Saved\n(see notes)","Electric",null,"Fuel Savings\n(MMBtu)","Percent of Savings \nto Total Energy Consumption\n(%)","Annual Cost Savings","Implementation Cost","Simple Payback\n(Years)"]
[null,null,null,"Supply Savings\n(kWh)","Demand Savings\n(kW)"]
[null,null,null,null,null,null,{"$f":"IF(AND(D9=\"\",F9=\"\"),\"\",(D9*'PROJECT DATA'!$B$31+F9)/'PROJECT DATA'!$Q$9)","v":""},null,null,{"$f":"IFERROR(I9/H9,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(D10=\"\",F10=\"\"),\"\",(D10*'PROJECT DATA'!$B$31+F10)/'PROJECT DATA'!$Q$9)","v":""},null,null,{"$f":"IFERROR(I10/H10,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(D11=\"\",F11=\"\"),\"\",(D11*'PROJECT DATA'!$B$31+F11)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D12=\"\",F12=\"\"),\"\",(D12*'PROJECT DATA'!$B$31+F12)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D13=\"\",F13=\"\"),\"\",(D13*'PROJECT DATA'!$B$31+F13)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D14=\"\",F14=\"\"),\"\",(D14*'PROJECT DATA'!$B$31+F14)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D15=\"\",F15=\"\"),\"\",(D15*'PROJECT DATA'!$B$31+F15)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D16=\"\",F16=\"\"),\"\",(D16*'PROJECT DATA'!$B$31+F16)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D17=\"\",F17=\"\"),\"\",(D17*'PROJECT DATA'!$B$31+F17)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D18=\"\",F18=\"\"),\"\",(D18*'PROJECT DATA'!$B$31+F18)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D19=\"\",F19=\"\"),\"\",(D19*'PROJECT DATA'!$B$31+F19)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D20=\"\",F20=\"\"),\"\",(D20*'PROJECT DATA'!$B$31+F20)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D21=\"\",F21=\"\"),\"\",(D21*'PROJECT DATA'!$B$31+F21)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D22=\"\",F22=\"\"),\"\",(D22*'PROJECT DATA'!$B$31+F22)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D23=\"\",F23=\"\"),\"\",(D23*'PROJECT DATA'!$B$31+F23)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D24=\"\",F24=\"\"),\"\",(D24*'PROJECT DATA'!$B$31+F24)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D25=\"\",F25=\"\"),\"\",(D25*'PROJECT DATA'!$B$31+F25)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D26=\"\",F26=\"\"),\"\",(D26*'PROJECT DATA'!$B$31+F26)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
["TOTAL (Recommended Only):",null,null,{"$f":"SUMIF($B$9:$B$26,References!$A$2,D9:D26)+SUMIF($B$9:$B$26,References!$A$3,D9:D26)+SUMIF($B$9:$B$26,References!$A$6,D9:D26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,E9:E26)+SUMIF($B$9:$B$26,References!$A$3,E9:E26)+SUMIF($B$9:$B$26,References!$A$6,E9:E26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,F9:F26)+SUMIF($B$9:$B$26,References!$A$3,F9:F26)+SUMIF($B$9:$B$26,References!$A$6,F9:F26)","v":0},{"$f":"IFERROR(((D27*'PROJECT DATA'!B31)+F27)/'PROJECT DATA'!$Q$10,\"0\"%)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,H9:H26)+SUMIF($B$9:$B$26,References!$A$3,H9:H26)+SUMIF($B$9:$B$26,References!$A$6,H9:H26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,I9:I26)+SUMIF($B$9:$B$26,References!$A$3,I9:I26)+SUMIF($B$9:$B$26,References!$A$6,I9:I26)","v":0},{"$f":"IFERROR(I27/H27,\"0.0\")","v":"0.0"}]
["TOTAL (All):",null,null,{"$f":"SUM(D9:D26)","v":0},0,0,{"$f":"IFERROR(((D28*'PROJECT DATA'!B31)+F28)/'PROJECT DATA'!$Q$10,\"0\"%)","v":0},0,0,{"$f":"IFERROR(I28/H28,\"0.0\")","v":"0.0"}]
["Notes:"]
["* Measure Status: Implemented (I); Recommended (R); Further Study Recommended (RS); Not Recommended (NR); Recommended Mutually Exclusive (RME); Mutually Exclusive (ME); Recommended Non-Energy (RNE)"]
["* MMBtu = 1,000,000 Btu"]
["* Energy savings must be presented as savings at the customer’s utility meter(s), and not at the individual building or tenant space.  "]
["* Percent of Savings to Total Fuel Consumption (%) should be a comparison of the total of all the electric and fuel savings to the total baseline energy consumption"]

{"sheet":"Site 10 PSS","index":11,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":true,"merged":[[2,1,2,4],[2,7,2,9],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,6,4],[6,5,7,5],[6,6,7,6],[31,0,31,9],[6,7,7,7],[6,8,7,8],[6,9,7,9],[26,0,26,2],[27,0,27,2],[29,0,29,9]]}
[]
[]
["Participant Site: ",{"$f":"IF(OR('PROJECT DATA'!F17=\"\",'PROJECT DATA'!C17=\"\"),\"\",CONCATENATE('PROJECT DATA'!C17,\" - \",'PROJECT DATA'!F17))","v":""},null,null,null,null,"AGG Project: ",{"$f":"IF('PROJECT DATA'!$B$2=\"\",\"\",CONCATENATE(\"AGG \",'PROJECT DATA'!$B$2,\" - \",'PROJECT DATA'!$B$3,\" - Portfolio #\",'PROJECT DATA'!$B$4))","v":""}]
[]
[]
["ENERGY SAVINGS SUMMARY"]
["Measure Description","Measure Status\n(see notes)","Fuel Type Saved\n(see notes)","Electric",null,"Fuel Savings\n(MMBtu)","Percent of Savings \nto Total Energy Consumption\n(%)","Annual Cost Savings","Implementation Cost","Simple Payback\n(Years)"]
[null,null,null,"Supply Savings\n(kWh)","Demand Savings\n(kW)"]
[null,null,null,null,null,null,{"$f":"IF(AND(D9=\"\",F9=\"\"),\"\",(D9*'PROJECT DATA'!$B$31+F9)/'PROJECT DATA'!$Q$9)","v":""},null,null,{"$f":"IFERROR(I9/H9,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(D10=\"\",F10=\"\"),\"\",(D10*'PROJECT DATA'!$B$31+F10)/'PROJECT DATA'!$Q$9)","v":""},null,null,{"$f":"IFERROR(I10/H10,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(D11=\"\",F11=\"\"),\"\",(D11*'PROJECT DATA'!$B$31+F11)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D12=\"\",F12=\"\"),\"\",(D12*'PROJECT DATA'!$B$31+F12)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D13=\"\",F13=\"\"),\"\",(D13*'PROJECT DATA'!$B$31+F13)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D14=\"\",F14=\"\"),\"\",(D14*'PROJECT DATA'!$B$31+F14)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D15=\"\",F15=\"\"),\"\",(D15*'PROJECT DATA'!$B$31+F15)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D16=\"\",F16=\"\"),\"\",(D16*'PROJECT DATA'!$B$31+F16)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D17=\"\",F17=\"\"),\"\",(D17*'PROJECT DATA'!$B$31+F17)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D18=\"\",F18=\"\"),\"\",(D18*'PROJECT DATA'!$B$31+F18)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D19=\"\",F19=\"\"),\"\",(D19*'PROJECT DATA'!$B$31+F19)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D20=\"\",F20=\"\"),\"\",(D20*'PROJECT DATA'!$B$31+F20)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D21=\"\",F21=\"\"),\"\",(D21*'PROJECT DATA'!$B$31+F21)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D22=\"\",F22=\"\"),\"\",(D22*'PROJECT DATA'!$B$31+F22)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D23=\"\",F23=\"\"),\"\",(D23*'PROJECT DATA'!$B$31+F23)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D24=\"\",F24=\"\"),\"\",(D24*'PROJECT DATA'!$B$31+F24)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D25=\"\",F25=\"\"),\"\",(D25*'PROJECT DATA'!$B$31+F25)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D26=\"\",F26=\"\"),\"\",(D26*'PROJECT DATA'!$B$31+F26)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
["TOTAL (Recommended Only):",null,null,{"$f":"SUMIF($B$9:$B$26,References!$A$2,D9:D26)+SUMIF($B$9:$B$26,References!$A$3,D9:D26)+SUMIF($B$9:$B$26,References!$A$6,D9:D26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,E9:E26)+SUMIF($B$9:$B$26,References!$A$3,E9:E26)+SUMIF($B$9:$B$26,References!$A$6,E9:E26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,F9:F26)+SUMIF($B$9:$B$26,References!$A$3,F9:F26)+SUMIF($B$9:$B$26,References!$A$6,F9:F26)","v":0},{"$f":"IFERROR(((D27*'PROJECT DATA'!B31)+F27)/'PROJECT DATA'!$Q$10,\"0\"%)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,H9:H26)+SUMIF($B$9:$B$26,References!$A$3,H9:H26)+SUMIF($B$9:$B$26,References!$A$6,H9:H26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,I9:I26)+SUMIF($B$9:$B$26,References!$A$3,I9:I26)+SUMIF($B$9:$B$26,References!$A$6,I9:I26)","v":0},{"$f":"IFERROR(I27/H27,\"0.0\")","v":"0.0"}]
["TOTAL (All):",null,null,{"$f":"SUM(D9:D26)","v":0},0,0,{"$f":"IFERROR(((D28*'PROJECT DATA'!B31)+F28)/'PROJECT DATA'!$Q$10,\"0\"%)","v":0},0,0,{"$f":"IFERROR(I28/H28,\"0.0\")","v":"0.0"}]
["Notes:"]
["* Measure Status: Implemented (I); Recommended (R); Further Study Recommended (RS); Not Recommended (NR); Recommended Mutually Exclusive (RME); Mutually Exclusive (ME); Recommended Non-Energy (RNE)"]
["* MMBtu = 1,000,000 Btu"]
["* Energy savings must be presented as savings at the customer’s utility meter(s), and not at the individual building or tenant space.  "]
["* Percent of Savings to Total Fuel Consumption (%) should be a comparison of the total of all the electric and fuel savings to the total baseline energy consumption"]

{"sheet":"Site 11 PSS","index":12,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":true,"merged":[[2,1,2,4],[2,7,2,9],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,6,4],[6,5,7,5],[6,6,7,6],[31,0,31,9],[6,7,7,7],[6,8,7,8],[6,9,7,9],[26,0,26,2],[27,0,27,2],[29,0,29,9]]}
[]
[]
["Participant Site: ",{"$f":"IF(OR('PROJECT DATA'!F18=\"\",'PROJECT DATA'!C18=\"\"),\"\",CONCATENATE('PROJECT DATA'!C18,\" - \",'PROJECT DATA'!F18))","v":""},null,null,null,null,"AGG Project: ",{"$f":"IF('PROJECT DATA'!$B$2=\"\",\"\",CONCATENATE(\"AGG \",'PROJECT DATA'!$B$2,\" - \",'PROJECT DATA'!$B$3,\" - Portfolio #\",'PROJECT DATA'!$B$4))","v":""}]
[]
[]
["ENERGY SAVINGS SUMMARY"]
["Measure Description","Measure Status\n(see notes)","Fuel Type Saved\n(see notes)","Electric",null,"Fuel Savings\n(MMBtu)","Percent of Savings \nto Total Energy Consumption\n(%)","Annual Cost Savings","Implementation Cost","Simple Payback\n(Years)"]
[null,null,null,"Supply Savings\n(kWh)","Demand Savings\n(kW)"]
[null,null,null,null,null,null,{"$f":"IF(AND(D9=\"\",F9=\"\"),\"\",(D9*'PROJECT DATA'!$B$31+F9)/'PROJECT DATA'!$Q$9)","v":""},null,null,{"$f":"IFERROR(I9/H9,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(D10=\"\",F10=\"\"),\"\",(D10*'PROJECT DATA'!$B$31+F10)/'PROJECT DATA'!$Q$9)","v":""},null,null,{"$f":"IFERROR(I10/H10,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(D11=\"\",F11=\"\"),\"\",(D11*'PROJECT DATA'!$B$31+F11)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D12=\"\",F12=\"\"),\"\",(D12*'PROJECT DATA'!$B$31+F12)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D13=\"\",F13=\"\"),\"\",(D13*'PROJECT DATA'!$B$31+F13)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D14=\"\",F14=\"\"),\"\",(D14*'PROJECT DATA'!$B$31+F14)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D15=\"\",F15=\"\"),\"\",(D15*'PROJECT DATA'!$B$31+F15)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D16=\"\",F16=\"\"),\"\",(D16*'PROJECT DATA'!$B$31+F16)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D17=\"\",F17=\"\"),\"\",(D17*'PROJECT DATA'!$B$31+F17)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D18=\"\",F18=\"\"),\"\",(D18*'PROJECT DATA'!$B$31+F18)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D19=\"\",F19=\"\"),\"\",(D19*'PROJECT DATA'!$B$31+F19)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D20=\"\",F20=\"\"),\"\",(D20*'PROJECT DATA'!$B$31+F20)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D21=\"\",F21=\"\"),\"\",(D21*'PROJECT DATA'!$B$31+F21)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D22=\"\",F22=\"\"),\"\",(D22*'PROJECT DATA'!$B$31+F22)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D23=\"\",F23=\"\"),\"\",(D23*'PROJECT DATA'!$B$31+F23)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D24=\"\",F24=\"\"),\"\",(D24*'PROJECT DATA'!$B$31+F24)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D25=\"\",F25=\"\"),\"\",(D25*'PROJECT DATA'!$B$31+F25)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D26=\"\",F26=\"\"),\"\",(D26*'PROJECT DATA'!$B$31+F26)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
["TOTAL (Recommended Only):",null,null,{"$f":"SUMIF($B$9:$B$26,References!$A$2,D9:D26)+SUMIF($B$9:$B$26,References!$A$3,D9:D26)+SUMIF($B$9:$B$26,References!$A$6,D9:D26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,E9:E26)+SUMIF($B$9:$B$26,References!$A$3,E9:E26)+SUMIF($B$9:$B$26,References!$A$6,E9:E26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,F9:F26)+SUMIF($B$9:$B$26,References!$A$3,F9:F26)+SUMIF($B$9:$B$26,References!$A$6,F9:F26)","v":0},{"$f":"IFERROR(((D27*'PROJECT DATA'!B31)+F27)/'PROJECT DATA'!$Q$10,\"0\"%)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,H9:H26)+SUMIF($B$9:$B$26,References!$A$3,H9:H26)+SUMIF($B$9:$B$26,References!$A$6,H9:H26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,I9:I26)+SUMIF($B$9:$B$26,References!$A$3,I9:I26)+SUMIF($B$9:$B$26,References!$A$6,I9:I26)","v":0},{"$f":"IFERROR(I27/H27,\"0.0\")","v":"0.0"}]
["TOTAL (All):",null,null,{"$f":"SUM(D9:D26)","v":0},0,0,{"$f":"IFERROR(((D28*'PROJECT DATA'!B31)+F28)/'PROJECT DATA'!$Q$10,\"0\"%)","v":0},0,0,{"$f":"IFERROR(I28/H28,\"0.0\")","v":"0.0"}]
["Notes:"]
["* Measure Status: Implemented (I); Recommended (R); Further Study Recommended (RS); Not Recommended (NR); Recommended Mutually Exclusive (RME); Mutually Exclusive (ME); Recommended Non-Energy (RNE)"]
["* MMBtu = 1,000,000 Btu"]
["* Energy savings must be presented as savings at the customer’s utility meter(s), and not at the individual building or tenant space.  "]
["* Percent of Savings to Total Fuel Consumption (%) should be a comparison of the total of all the electric and fuel savings to the total baseline energy consumption"]

{"sheet":"Site 12 PSS","index":13,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":true,"merged":[[2,1,2,4],[2,7,2,9],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,6,4],[6,5,7,5],[6,6,7,6],[31,0,31,9],[6,7,7,7],[6,8,7,8],[6,9,7,9],[26,0,26,2],[27,0,27,2],[29,0,29,9]]}
[]
[]
["Participant Site: ",{"$f":"IF(OR('PROJECT DATA'!F19=\"\",'PROJECT DATA'!C19=\"\"),\"\",CONCATENATE('PROJECT DATA'!C19,\" - \",'PROJECT DATA'!F19))","v":""},null,null,null,null,"AGG Project: ",{"$f":"IF('PROJECT DATA'!$B$2=\"\",\"\",CONCATENATE(\"AGG \",'PROJECT DATA'!$B$2,\" - \",'PROJECT DATA'!$B$3,\" - Portfolio #\",'PROJECT DATA'!$B$4))","v":""}]
[]
[]
["ENERGY SAVINGS SUMMARY"]
["Measure Description","Measure Status\n(see notes)","Fuel Type Saved\n(see notes)","Electric",null,"Fuel Savings\n(MMBtu)","Percent of Savings \nto Total Energy Consumption\n(%)","Annual Cost Savings","Implementation Cost","Simple Payback\n(Years)"]
[null,null,null,"Supply Savings\n(kWh)","Demand Savings\n(kW)"]
[null,null,null,null,null,null,{"$f":"IF(AND(D9=\"\",F9=\"\"),\"\",(D9*'PROJECT DATA'!$B$31+F9)/'PROJECT DATA'!$Q$9)","v":""},null,null,{"$f":"IFERROR(I9/H9,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(D10=\"\",F10=\"\"),\"\",(D10*'PROJECT DATA'!$B$31+F10)/'PROJECT DATA'!$Q$9)","v":""},null,null,{"$f":"IFERROR(I10/H10,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(D11=\"\",F11=\"\"),\"\",(D11*'PROJECT DATA'!$B$31+F11)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D12=\"\",F12=\"\"),\"\",(D12*'PROJECT DATA'!$B$31+F12)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D13=\"\",F13=\"\"),\"\",(D13*'PROJECT DATA'!$B$31+F13)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D14=\"\",F14=\"\"),\"\",(D14*'PROJECT DATA'!$B$31+F14)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D15=\"\",F15=\"\"),\"\",(D15*'PROJECT DATA'!$B$31+F15)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D16=\"\",F16=\"\"),\"\",(D16*'PROJECT DATA'!$B$31+F16)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D17=\"\",F17=\"\"),\"\",(D17*'PROJECT DATA'!$B$31+F17)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D18=\"\",F18=\"\"),\"\",(D18*'PROJECT DATA'!$B$31+F18)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D19=\"\",F19=\"\"),\"\",(D19*'PROJECT DATA'!$B$31+F19)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D20=\"\",F20=\"\"),\"\",(D20*'PROJECT DATA'!$B$31+F20)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D21=\"\",F21=\"\"),\"\",(D21*'PROJECT DATA'!$B$31+F21)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D22=\"\",F22=\"\"),\"\",(D22*'PROJECT DATA'!$B$31+F22)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D23=\"\",F23=\"\"),\"\",(D23*'PROJECT DATA'!$B$31+F23)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D24=\"\",F24=\"\"),\"\",(D24*'PROJECT DATA'!$B$31+F24)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D25=\"\",F25=\"\"),\"\",(D25*'PROJECT DATA'!$B$31+F25)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D26=\"\",F26=\"\"),\"\",(D26*'PROJECT DATA'!$B$31+F26)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
["TOTAL (Recommended Only):",null,null,{"$f":"SUMIF($B$9:$B$26,References!$A$2,D9:D26)+SUMIF($B$9:$B$26,References!$A$3,D9:D26)+SUMIF($B$9:$B$26,References!$A$6,D9:D26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,E9:E26)+SUMIF($B$9:$B$26,References!$A$3,E9:E26)+SUMIF($B$9:$B$26,References!$A$6,E9:E26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,F9:F26)+SUMIF($B$9:$B$26,References!$A$3,F9:F26)+SUMIF($B$9:$B$26,References!$A$6,F9:F26)","v":0},{"$f":"IFERROR(((D27*'PROJECT DATA'!B31)+F27)/'PROJECT DATA'!$Q$10,\"0\"%)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,H9:H26)+SUMIF($B$9:$B$26,References!$A$3,H9:H26)+SUMIF($B$9:$B$26,References!$A$6,H9:H26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,I9:I26)+SUMIF($B$9:$B$26,References!$A$3,I9:I26)+SUMIF($B$9:$B$26,References!$A$6,I9:I26)","v":0},{"$f":"IFERROR(I27/H27,\"0.0\")","v":"0.0"}]
["TOTAL (All):",null,null,{"$f":"SUM(D9:D26)","v":0},0,0,{"$f":"IFERROR(((D28*'PROJECT DATA'!B31)+F28)/'PROJECT DATA'!$Q$10,\"0\"%)","v":0},0,0,{"$f":"IFERROR(I28/H28,\"0.0\")","v":"0.0"}]
["Notes:"]
["* Measure Status: Implemented (I); Recommended (R); Further Study Recommended (RS); Not Recommended (NR); Recommended Mutually Exclusive (RME); Mutually Exclusive (ME); Recommended Non-Energy (RNE)"]
["* MMBtu = 1,000,000 Btu"]
["* Energy savings must be presented as savings at the customer’s utility meter(s), and not at the individual building or tenant space.  "]
["* Percent of Savings to Total Fuel Consumption (%) should be a comparison of the total of all the electric and fuel savings to the total baseline energy consumption"]

{"sheet":"Site 13 PSS","index":14,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":true,"merged":[[2,1,2,4],[2,7,2,9],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,6,4],[6,5,7,5],[6,6,7,6],[31,0,31,9],[6,7,7,7],[6,8,7,8],[6,9,7,9],[26,0,26,2],[27,0,27,2],[29,0,29,9]]}
[]
[]
["Participant Site: ",{"$f":"IF(OR('PROJECT DATA'!F20=\"\",'PROJECT DATA'!C20=\"\"),\"\",CONCATENATE('PROJECT DATA'!C20,\" - \",'PROJECT DATA'!F20))","v":""},null,null,null,null,"AGG Project: ",{"$f":"IF('PROJECT DATA'!$B$2=\"\",\"\",CONCATENATE(\"AGG \",'PROJECT DATA'!$B$2,\" - \",'PROJECT DATA'!$B$3,\" - Portfolio #\",'PROJECT DATA'!$B$4))","v":""}]
[]
[]
["ENERGY SAVINGS SUMMARY"]
["Measure Description","Measure Status\n(see notes)","Fuel Type Saved\n(see notes)","Electric",null,"Fuel Savings\n(MMBtu)","Percent of Savings \nto Total Energy Consumption\n(%)","Annual Cost Savings","Implementation Cost","Simple Payback\n(Years)"]
[null,null,null,"Supply Savings\n(kWh)","Demand Savings\n(kW)"]
[null,null,null,null,null,null,{"$f":"IF(AND(D9=\"\",F9=\"\"),\"\",(D9*'PROJECT DATA'!$B$31+F9)/'PROJECT DATA'!$Q$9)","v":""},null,null,{"$f":"IFERROR(I9/H9,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(D10=\"\",F10=\"\"),\"\",(D10*'PROJECT DATA'!$B$31+F10)/'PROJECT DATA'!$Q$9)","v":""},null,null,{"$f":"IFERROR(I10/H10,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(D11=\"\",F11=\"\"),\"\",(D11*'PROJECT DATA'!$B$31+F11)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D12=\"\",F12=\"\"),\"\",(D12*'PROJECT DATA'!$B$31+F12)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D13=\"\",F13=\"\"),\"\",(D13*'PROJECT DATA'!$B$31+F13)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D14=\"\",F14=\"\"),\"\",(D14*'PROJECT DATA'!$B$31+F14)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D15=\"\",F15=\"\"),\"\",(D15*'PROJECT DATA'!$B$31+F15)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D16=\"\",F16=\"\"),\"\",(D16*'PROJECT DATA'!$B$31+F16)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D17=\"\",F17=\"\"),\"\",(D17*'PROJECT DATA'!$B$31+F17)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D18=\"\",F18=\"\"),\"\",(D18*'PROJECT DATA'!$B$31+F18)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D19=\"\",F19=\"\"),\"\",(D19*'PROJECT DATA'!$B$31+F19)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D20=\"\",F20=\"\"),\"\",(D20*'PROJECT DATA'!$B$31+F20)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D21=\"\",F21=\"\"),\"\",(D21*'PROJECT DATA'!$B$31+F21)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D22=\"\",F22=\"\"),\"\",(D22*'PROJECT DATA'!$B$31+F22)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D23=\"\",F23=\"\"),\"\",(D23*'PROJECT DATA'!$B$31+F23)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D24=\"\",F24=\"\"),\"\",(D24*'PROJECT DATA'!$B$31+F24)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D25=\"\",F25=\"\"),\"\",(D25*'PROJECT DATA'!$B$31+F25)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D26=\"\",F26=\"\"),\"\",(D26*'PROJECT DATA'!$B$31+F26)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
["TOTAL (Recommended Only):",null,null,{"$f":"SUMIF($B$9:$B$26,References!$A$2,D9:D26)+SUMIF($B$9:$B$26,References!$A$3,D9:D26)+SUMIF($B$9:$B$26,References!$A$6,D9:D26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,E9:E26)+SUMIF($B$9:$B$26,References!$A$3,E9:E26)+SUMIF($B$9:$B$26,References!$A$6,E9:E26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,F9:F26)+SUMIF($B$9:$B$26,References!$A$3,F9:F26)+SUMIF($B$9:$B$26,References!$A$6,F9:F26)","v":0},{"$f":"IFERROR(((D27*'PROJECT DATA'!B31)+F27)/'PROJECT DATA'!$Q$10,\"0\"%)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,H9:H26)+SUMIF($B$9:$B$26,References!$A$3,H9:H26)+SUMIF($B$9:$B$26,References!$A$6,H9:H26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,I9:I26)+SUMIF($B$9:$B$26,References!$A$3,I9:I26)+SUMIF($B$9:$B$26,References!$A$6,I9:I26)","v":0},{"$f":"IFERROR(I27/H27,\"0.0\")","v":"0.0"}]
["TOTAL (All):",null,null,{"$f":"SUM(D9:D26)","v":0},0,0,{"$f":"IFERROR(((D28*'PROJECT DATA'!B31)+F28)/'PROJECT DATA'!$Q$10,\"0\"%)","v":0},0,0,{"$f":"IFERROR(I28/H28,\"0.0\")","v":"0.0"}]
["Notes:"]
["* Measure Status: Implemented (I); Recommended (R); Further Study Recommended (RS); Not Recommended (NR); Recommended Mutually Exclusive (RME); Mutually Exclusive (ME); Recommended Non-Energy (RNE)"]
["* MMBtu = 1,000,000 Btu"]
["* Energy savings must be presented as savings at the customer’s utility meter(s), and not at the individual building or tenant space.  "]
["* Percent of Savings to Total Fuel Consumption (%) should be a comparison of the total of all the electric and fuel savings to the total baseline energy consumption"]

{"sheet":"Site 14 PSS","index":15,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":true,"merged":[[2,1,2,4],[2,7,2,9],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,6,4],[6,5,7,5],[6,6,7,6],[31,0,31,9],[6,7,7,7],[6,8,7,8],[6,9,7,9],[26,0,26,2],[27,0,27,2],[29,0,29,9]]}
[]
[]
["Participant Site: ",{"$f":"IF(OR('PROJECT DATA'!F21=\"\",'PROJECT DATA'!C21=\"\"),\"\",CONCATENATE('PROJECT DATA'!C21,\" - \",'PROJECT DATA'!F21))","v":""},null,null,null,null,"AGG Project: ",{"$f":"IF('PROJECT DATA'!$B$2=\"\",\"\",CONCATENATE(\"AGG \",'PROJECT DATA'!$B$2,\" - \",'PROJECT DATA'!$B$3,\" - Portfolio #\",'PROJECT DATA'!$B$4))","v":""}]
[]
[]
["ENERGY SAVINGS SUMMARY"]
["Measure Description","Measure Status\n(see notes)","Fuel Type Saved\n(see notes)","Electric",null,"Fuel Savings\n(MMBtu)","Percent of Savings \nto Total Energy Consumption\n(%)","Annual Cost Savings","Implementation Cost","Simple Payback\n(Years)"]
[null,null,null,"Supply Savings\n(kWh)","Demand Savings\n(kW)"]
[null,null,null,null,null,null,{"$f":"IF(AND(D9=\"\",F9=\"\"),\"\",(D9*'PROJECT DATA'!$B$31+F9)/'PROJECT DATA'!$Q$9)","v":""},null,null,{"$f":"IFERROR(I9/H9,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(D10=\"\",F10=\"\"),\"\",(D10*'PROJECT DATA'!$B$31+F10)/'PROJECT DATA'!$Q$9)","v":""},null,null,{"$f":"IFERROR(I10/H10,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(D11=\"\",F11=\"\"),\"\",(D11*'PROJECT DATA'!$B$31+F11)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D12=\"\",F12=\"\"),\"\",(D12*'PROJECT DATA'!$B$31+F12)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D13=\"\",F13=\"\"),\"\",(D13*'PROJECT DATA'!$B$31+F13)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D14=\"\",F14=\"\"),\"\",(D14*'PROJECT DATA'!$B$31+F14)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D15=\"\",F15=\"\"),\"\",(D15*'PROJECT DATA'!$B$31+F15)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D16=\"\",F16=\"\"),\"\",(D16*'PROJECT DATA'!$B$31+F16)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D17=\"\",F17=\"\"),\"\",(D17*'PROJECT DATA'!$B$31+F17)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D18=\"\",F18=\"\"),\"\",(D18*'PROJECT DATA'!$B$31+F18)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D19=\"\",F19=\"\"),\"\",(D19*'PROJECT DATA'!$B$31+F19)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D20=\"\",F20=\"\"),\"\",(D20*'PROJECT DATA'!$B$31+F20)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D21=\"\",F21=\"\"),\"\",(D21*'PROJECT DATA'!$B$31+F21)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D22=\"\",F22=\"\"),\"\",(D22*'PROJECT DATA'!$B$31+F22)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D23=\"\",F23=\"\"),\"\",(D23*'PROJECT DATA'!$B$31+F23)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D24=\"\",F24=\"\"),\"\",(D24*'PROJECT DATA'!$B$31+F24)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D25=\"\",F25=\"\"),\"\",(D25*'PROJECT DATA'!$B$31+F25)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D26=\"\",F26=\"\"),\"\",(D26*'PROJECT DATA'!$B$31+F26)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
["TOTAL (Recommended Only):",null,null,{"$f":"SUMIF($B$9:$B$26,References!$A$2,D9:D26)+SUMIF($B$9:$B$26,References!$A$3,D9:D26)+SUMIF($B$9:$B$26,References!$A$6,D9:D26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,E9:E26)+SUMIF($B$9:$B$26,References!$A$3,E9:E26)+SUMIF($B$9:$B$26,References!$A$6,E9:E26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,F9:F26)+SUMIF($B$9:$B$26,References!$A$3,F9:F26)+SUMIF($B$9:$B$26,References!$A$6,F9:F26)","v":0},{"$f":"IFERROR(((D27*'PROJECT DATA'!B31)+F27)/'PROJECT DATA'!$Q$10,\"0\"%)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,H9:H26)+SUMIF($B$9:$B$26,References!$A$3,H9:H26)+SUMIF($B$9:$B$26,References!$A$6,H9:H26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,I9:I26)+SUMIF($B$9:$B$26,References!$A$3,I9:I26)+SUMIF($B$9:$B$26,References!$A$6,I9:I26)","v":0},{"$f":"IFERROR(I27/H27,\"0.0\")","v":"0.0"}]
["TOTAL (All):",null,null,{"$f":"SUM(D9:D26)","v":0},0,0,{"$f":"IFERROR(((D28*'PROJECT DATA'!B31)+F28)/'PROJECT DATA'!$Q$10,\"0\"%)","v":0},0,0,{"$f":"IFERROR(I28/H28,\"0.0\")","v":"0.0"}]
["Notes:"]
["* Measure Status: Implemented (I); Recommended (R); Further Study Recommended (RS); Not Recommended (NR); Recommended Mutually Exclusive (RME); Mutually Exclusive (ME); Recommended Non-Energy (RNE)"]
["* MMBtu = 1,000,000 Btu"]
["* Energy savings must be presented as savings at the customer’s utility meter(s), and not at the individual building or tenant space.  "]
["* Percent of Savings to Total Fuel Consumption (%) should be a comparison of the total of all the electric and fuel savings to the total baseline energy consumption"]

{"sheet":"Site 15 PSS","index":16,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":true,"merged":[[2,1,2,4],[2,7,2,9],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,6,4],[6,5,7,5],[6,6,7,6],[31,0,31,9],[6,7,7,7],[6,8,7,8],[6,9,7,9],[26,0,26,2],[27,0,27,2],[29,0,29,9]]}
[]
[]
["Participant Site: ",{"$f":"IF(OR('PROJECT DATA'!F22=\"\",'PROJECT DATA'!C22=\"\"),\"\",CONCATENATE('PROJECT DATA'!C22,\" - \",'PROJECT DATA'!F22))","v":""},null,null,null,null,"AGG Project: ",{"$f":"IF('PROJECT DATA'!$B$2=\"\",\"\",CONCATENATE(\"AGG \",'PROJECT DATA'!$B$2,\" - \",'PROJECT DATA'!$B$3,\" - Portfolio #\",'PROJECT DATA'!$B$4))","v":""}]
[]
[]
["ENERGY SAVINGS SUMMARY"]
["Measure Description","Measure Status\n(see notes)","Fuel Type Saved\n(see notes)","Electric",null,"Fuel Savings\n(MMBtu)","Percent of Savings \nto Total Energy Consumption\n(%)","Annual Cost Savings","Implementation Cost","Simple Payback\n(Years)"]
[null,null,null,"Supply Savings\n(kWh)","Demand Savings\n(kW)"]
[null,null,null,null,null,null,{"$f":"IF(AND(D9=\"\",F9=\"\"),\"\",(D9*'PROJECT DATA'!$B$31+F9)/'PROJECT DATA'!$Q$9)","v":""},null,null,{"$f":"IFERROR(I9/H9,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(D10=\"\",F10=\"\"),\"\",(D10*'PROJECT DATA'!$B$31+F10)/'PROJECT DATA'!$Q$9)","v":""},null,null,{"$f":"IFERROR(I10/H10,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(D11=\"\",F11=\"\"),\"\",(D11*'PROJECT DATA'!$B$31+F11)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D12=\"\",F12=\"\"),\"\",(D12*'PROJECT DATA'!$B$31+F12)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D13=\"\",F13=\"\"),\"\",(D13*'PROJECT DATA'!$B$31+F13)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D14=\"\",F14=\"\"),\"\",(D14*'PROJECT DATA'!$B$31+F14)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D15=\"\",F15=\"\"),\"\",(D15*'PROJECT DATA'!$B$31+F15)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D16=\"\",F16=\"\"),\"\",(D16*'PROJECT DATA'!$B$31+F16)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D17=\"\",F17=\"\"),\"\",(D17*'PROJECT DATA'!$B$31+F17)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D18=\"\",F18=\"\"),\"\",(D18*'PROJECT DATA'!$B$31+F18)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D19=\"\",F19=\"\"),\"\",(D19*'PROJECT DATA'!$B$31+F19)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D20=\"\",F20=\"\"),\"\",(D20*'PROJECT DATA'!$B$31+F20)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D21=\"\",F21=\"\"),\"\",(D21*'PROJECT DATA'!$B$31+F21)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D22=\"\",F22=\"\"),\"\",(D22*'PROJECT DATA'!$B$31+F22)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D23=\"\",F23=\"\"),\"\",(D23*'PROJECT DATA'!$B$31+F23)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D24=\"\",F24=\"\"),\"\",(D24*'PROJECT DATA'!$B$31+F24)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D25=\"\",F25=\"\"),\"\",(D25*'PROJECT DATA'!$B$31+F25)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D26=\"\",F26=\"\"),\"\",(D26*'PROJECT DATA'!$B$31+F26)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
["TOTAL (Recommended Only):",null,null,{"$f":"SUMIF($B$9:$B$26,References!$A$2,D9:D26)+SUMIF($B$9:$B$26,References!$A$3,D9:D26)+SUMIF($B$9:$B$26,References!$A$6,D9:D26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,E9:E26)+SUMIF($B$9:$B$26,References!$A$3,E9:E26)+SUMIF($B$9:$B$26,References!$A$6,E9:E26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,F9:F26)+SUMIF($B$9:$B$26,References!$A$3,F9:F26)+SUMIF($B$9:$B$26,References!$A$6,F9:F26)","v":0},{"$f":"IFERROR(((D27*'PROJECT DATA'!B31)+F27)/'PROJECT DATA'!$Q$10,\"0\"%)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,H9:H26)+SUMIF($B$9:$B$26,References!$A$3,H9:H26)+SUMIF($B$9:$B$26,References!$A$6,H9:H26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,I9:I26)+SUMIF($B$9:$B$26,References!$A$3,I9:I26)+SUMIF($B$9:$B$26,References!$A$6,I9:I26)","v":0},{"$f":"IFERROR(I27/H27,\"0.0\")","v":"0.0"}]
["TOTAL (All):",null,null,{"$f":"SUM(D9:D26)","v":0},0,0,{"$f":"IFERROR(((D28*'PROJECT DATA'!B31)+F28)/'PROJECT DATA'!$Q$10,\"0\"%)","v":0},0,0,{"$f":"IFERROR(I28/H28,\"0.0\")","v":"0.0"}]
["Notes:"]
["* Measure Status: Implemented (I); Recommended (R); Further Study Recommended (RS); Not Recommended (NR); Recommended Mutually Exclusive (RME); Mutually Exclusive (ME); Recommended Non-Energy (RNE)"]
["* MMBtu = 1,000,000 Btu"]
["* Energy savings must be presented as savings at the customer’s utility meter(s), and not at the individual building or tenant space.  "]
["* Percent of Savings to Total Fuel Consumption (%) should be a comparison of the total of all the electric and fuel savings to the total baseline energy consumption"]

{"sheet":"Site 16 PSS","index":17,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":true,"merged":[[2,1,2,4],[2,7,2,9],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,6,4],[6,5,7,5],[6,6,7,6],[31,0,31,9],[6,7,7,7],[6,8,7,8],[6,9,7,9],[26,0,26,2],[27,0,27,2],[29,0,29,9]]}
[]
[]
["Participant Site: ",{"$f":"IF(OR('PROJECT DATA'!F23=\"\",'PROJECT DATA'!C23=\"\"),\"\",CONCATENATE('PROJECT DATA'!C23,\" - \",'PROJECT DATA'!F23))","v":""},null,null,null,null,"AGG Project: ",{"$f":"IF('PROJECT DATA'!$B$2=\"\",\"\",CONCATENATE(\"AGG \",'PROJECT DATA'!$B$2,\" - \",'PROJECT DATA'!$B$3,\" - Portfolio #\",'PROJECT DATA'!$B$4))","v":""}]
[]
[]
["ENERGY SAVINGS SUMMARY"]
["Measure Description","Measure Status\n(see notes)","Fuel Type Saved\n(see notes)","Electric",null,"Fuel Savings\n(MMBtu)","Percent of Savings \nto Total Energy Consumption\n(%)","Annual Cost Savings","Implementation Cost","Simple Payback\n(Years)"]
[null,null,null,"Supply Savings\n(kWh)","Demand Savings\n(kW)"]
[null,null,null,null,null,null,{"$f":"IF(AND(D9=\"\",F9=\"\"),\"\",(D9*'PROJECT DATA'!$B$31+F9)/'PROJECT DATA'!$Q$9)","v":""},null,null,{"$f":"IFERROR(I9/H9,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(D10=\"\",F10=\"\"),\"\",(D10*'PROJECT DATA'!$B$31+F10)/'PROJECT DATA'!$Q$9)","v":""},null,null,{"$f":"IFERROR(I10/H10,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(D11=\"\",F11=\"\"),\"\",(D11*'PROJECT DATA'!$B$31+F11)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D12=\"\",F12=\"\"),\"\",(D12*'PROJECT DATA'!$B$31+F12)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D13=\"\",F13=\"\"),\"\",(D13*'PROJECT DATA'!$B$31+F13)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D14=\"\",F14=\"\"),\"\",(D14*'PROJECT DATA'!$B$31+F14)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D15=\"\",F15=\"\"),\"\",(D15*'PROJECT DATA'!$B$31+F15)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D16=\"\",F16=\"\"),\"\",(D16*'PROJECT DATA'!$B$31+F16)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D17=\"\",F17=\"\"),\"\",(D17*'PROJECT DATA'!$B$31+F17)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D18=\"\",F18=\"\"),\"\",(D18*'PROJECT DATA'!$B$31+F18)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D19=\"\",F19=\"\"),\"\",(D19*'PROJECT DATA'!$B$31+F19)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D20=\"\",F20=\"\"),\"\",(D20*'PROJECT DATA'!$B$31+F20)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D21=\"\",F21=\"\"),\"\",(D21*'PROJECT DATA'!$B$31+F21)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D22=\"\",F22=\"\"),\"\",(D22*'PROJECT DATA'!$B$31+F22)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D23=\"\",F23=\"\"),\"\",(D23*'PROJECT DATA'!$B$31+F23)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D24=\"\",F24=\"\"),\"\",(D24*'PROJECT DATA'!$B$31+F24)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D25=\"\",F25=\"\"),\"\",(D25*'PROJECT DATA'!$B$31+F25)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D26=\"\",F26=\"\"),\"\",(D26*'PROJECT DATA'!$B$31+F26)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
["TOTAL (Recommended Only):",null,null,{"$f":"SUMIF($B$9:$B$26,References!$A$2,D9:D26)+SUMIF($B$9:$B$26,References!$A$3,D9:D26)+SUMIF($B$9:$B$26,References!$A$6,D9:D26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,E9:E26)+SUMIF($B$9:$B$26,References!$A$3,E9:E26)+SUMIF($B$9:$B$26,References!$A$6,E9:E26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,F9:F26)+SUMIF($B$9:$B$26,References!$A$3,F9:F26)+SUMIF($B$9:$B$26,References!$A$6,F9:F26)","v":0},{"$f":"IFERROR(((D27*'PROJECT DATA'!B31)+F27)/'PROJECT DATA'!$Q$10,\"0\"%)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,H9:H26)+SUMIF($B$9:$B$26,References!$A$3,H9:H26)+SUMIF($B$9:$B$26,References!$A$6,H9:H26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,I9:I26)+SUMIF($B$9:$B$26,References!$A$3,I9:I26)+SUMIF($B$9:$B$26,References!$A$6,I9:I26)","v":0},{"$f":"IFERROR(I27/H27,\"0.0\")","v":"0.0"}]
["TOTAL (All):",null,null,{"$f":"SUM(D9:D26)","v":0},0,0,{"$f":"IFERROR(((D28*'PROJECT DATA'!B31)+F28)/'PROJECT DATA'!$Q$10,\"0\"%)","v":0},0,0,{"$f":"IFERROR(I28/H28,\"0.0\")","v":"0.0"}]
["Notes:"]
["* Measure Status: Implemented (I); Recommended (R); Further Study Recommended (RS); Not Recommended (NR); Recommended Mutually Exclusive (RME); Mutually Exclusive (ME); Recommended Non-Energy (RNE)"]
["* MMBtu = 1,000,000 Btu"]
["* Energy savings must be presented as savings at the customer’s utility meter(s), and not at the individual building or tenant space.  "]
["* Percent of Savings to Total Fuel Consumption (%) should be a comparison of the total of all the electric and fuel savings to the total baseline energy consumption"]

{"sheet":"Site 17 PSS","index":18,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":true,"merged":[[2,1,2,4],[2,7,2,9],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,6,4],[6,5,7,5],[6,6,7,6],[31,0,31,9],[6,7,7,7],[6,8,7,8],[6,9,7,9],[26,0,26,2],[27,0,27,2],[29,0,29,9]]}
[]
[]
["Participant Site: ",{"$f":"IF(OR('PROJECT DATA'!F24=\"\",'PROJECT DATA'!C24=\"\"),\"\",CONCATENATE('PROJECT DATA'!C24,\" - \",'PROJECT DATA'!F24))","v":""},null,null,null,null,"AGG Project: ",{"$f":"IF('PROJECT DATA'!$B$2=\"\",\"\",CONCATENATE(\"AGG \",'PROJECT DATA'!$B$2,\" - \",'PROJECT DATA'!$B$3,\" - Portfolio #\",'PROJECT DATA'!$B$4))","v":""}]
[]
[]
["ENERGY SAVINGS SUMMARY"]
["Measure Description","Measure Status\n(see notes)","Fuel Type Saved\n(see notes)","Electric",null,"Fuel Savings\n(MMBtu)","Percent of Savings \nto Total Energy Consumption\n(%)","Annual Cost Savings","Implementation Cost","Simple Payback\n(Years)"]
[null,null,null,"Supply Savings\n(kWh)","Demand Savings\n(kW)"]
[null,null,null,null,null,null,{"$f":"IF(AND(D9=\"\",F9=\"\"),\"\",(D9*'PROJECT DATA'!$B$31+F9)/'PROJECT DATA'!$Q$9)","v":""},null,null,{"$f":"IFERROR(I9/H9,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(D10=\"\",F10=\"\"),\"\",(D10*'PROJECT DATA'!$B$31+F10)/'PROJECT DATA'!$Q$9)","v":""},null,null,{"$f":"IFERROR(I10/H10,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(D11=\"\",F11=\"\"),\"\",(D11*'PROJECT DATA'!$B$31+F11)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D12=\"\",F12=\"\"),\"\",(D12*'PROJECT DATA'!$B$31+F12)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D13=\"\",F13=\"\"),\"\",(D13*'PROJECT DATA'!$B$31+F13)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D14=\"\",F14=\"\"),\"\",(D14*'PROJECT DATA'!$B$31+F14)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D15=\"\",F15=\"\"),\"\",(D15*'PROJECT DATA'!$B$31+F15)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D16=\"\",F16=\"\"),\"\",(D16*'PROJECT DATA'!$B$31+F16)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D17=\"\",F17=\"\"),\"\",(D17*'PROJECT DATA'!$B$31+F17)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D18=\"\",F18=\"\"),\"\",(D18*'PROJECT DATA'!$B$31+F18)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D19=\"\",F19=\"\"),\"\",(D19*'PROJECT DATA'!$B$31+F19)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D20=\"\",F20=\"\"),\"\",(D20*'PROJECT DATA'!$B$31+F20)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D21=\"\",F21=\"\"),\"\",(D21*'PROJECT DATA'!$B$31+F21)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D22=\"\",F22=\"\"),\"\",(D22*'PROJECT DATA'!$B$31+F22)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D23=\"\",F23=\"\"),\"\",(D23*'PROJECT DATA'!$B$31+F23)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D24=\"\",F24=\"\"),\"\",(D24*'PROJECT DATA'!$B$31+F24)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D25=\"\",F25=\"\"),\"\",(D25*'PROJECT DATA'!$B$31+F25)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D26=\"\",F26=\"\"),\"\",(D26*'PROJECT DATA'!$B$31+F26)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
["TOTAL (Recommended Only):",null,null,{"$f":"SUMIF($B$9:$B$26,References!$A$2,D9:D26)+SUMIF($B$9:$B$26,References!$A$3,D9:D26)+SUMIF($B$9:$B$26,References!$A$6,D9:D26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,E9:E26)+SUMIF($B$9:$B$26,References!$A$3,E9:E26)+SUMIF($B$9:$B$26,References!$A$6,E9:E26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,F9:F26)+SUMIF($B$9:$B$26,References!$A$3,F9:F26)+SUMIF($B$9:$B$26,References!$A$6,F9:F26)","v":0},{"$f":"IFERROR(((D27*'PROJECT DATA'!B31)+F27)/'PROJECT DATA'!$Q$10,\"0\"%)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,H9:H26)+SUMIF($B$9:$B$26,References!$A$3,H9:H26)+SUMIF($B$9:$B$26,References!$A$6,H9:H26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,I9:I26)+SUMIF($B$9:$B$26,References!$A$3,I9:I26)+SUMIF($B$9:$B$26,References!$A$6,I9:I26)","v":0},{"$f":"IFERROR(I27/H27,\"0.0\")","v":"0.0"}]
["TOTAL (All):",null,null,{"$f":"SUM(D9:D26)","v":0},0,0,{"$f":"IFERROR(((D28*'PROJECT DATA'!B31)+F28)/'PROJECT DATA'!$Q$10,\"0\"%)","v":0},0,0,{"$f":"IFERROR(I28/H28,\"0.0\")","v":"0.0"}]
["Notes:"]
["* Measure Status: Implemented (I); Recommended (R); Further Study Recommended (RS); Not Recommended (NR); Recommended Mutually Exclusive (RME); Mutually Exclusive (ME); Recommended Non-Energy (RNE)"]
["* MMBtu = 1,000,000 Btu"]
["* Energy savings must be presented as savings at the customer’s utility meter(s), and not at the individual building or tenant space.  "]
["* Percent of Savings to Total Fuel Consumption (%) should be a comparison of the total of all the electric and fuel savings to the total baseline energy consumption"]

{"sheet":"Site 18 PSS","index":19,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":true,"merged":[[2,1,2,4],[2,7,2,9],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,6,4],[6,5,7,5],[6,6,7,6],[31,0,31,9],[6,7,7,7],[6,8,7,8],[6,9,7,9],[26,0,26,2],[27,0,27,2],[29,0,29,9]]}
[]
[]
["Participant Site: ",{"$f":"IF(OR('PROJECT DATA'!F25=\"\",'PROJECT DATA'!C25=\"\"),\"\",CONCATENATE('PROJECT DATA'!C25,\" - \",'PROJECT DATA'!F25))","v":""},null,null,null,null,"AGG Project: ",{"$f":"IF('PROJECT DATA'!$B$2=\"\",\"\",CONCATENATE(\"AGG \",'PROJECT DATA'!$B$2,\" - \",'PROJECT DATA'!$B$3,\" - Portfolio #\",'PROJECT DATA'!$B$4))","v":""}]
[]
[]
["ENERGY SAVINGS SUMMARY"]
["Measure Description","Measure Status\n(see notes)","Fuel Type Saved\n(see notes)","Electric",null,"Fuel Savings\n(MMBtu)","Percent of Savings \nto Total Energy Consumption\n(%)","Annual Cost Savings","Implementation Cost","Simple Payback\n(Years)"]
[null,null,null,"Supply Savings\n(kWh)","Demand Savings\n(kW)"]
[null,null,null,null,null,null,{"$f":"IF(AND(D9=\"\",F9=\"\"),\"\",(D9*'PROJECT DATA'!$B$31+F9)/'PROJECT DATA'!$Q$9)","v":""},null,null,{"$f":"IFERROR(I9/H9,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(D10=\"\",F10=\"\"),\"\",(D10*'PROJECT DATA'!$B$31+F10)/'PROJECT DATA'!$Q$9)","v":""},null,null,{"$f":"IFERROR(I10/H10,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(D11=\"\",F11=\"\"),\"\",(D11*'PROJECT DATA'!$B$31+F11)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D12=\"\",F12=\"\"),\"\",(D12*'PROJECT DATA'!$B$31+F12)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D13=\"\",F13=\"\"),\"\",(D13*'PROJECT DATA'!$B$31+F13)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D14=\"\",F14=\"\"),\"\",(D14*'PROJECT DATA'!$B$31+F14)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D15=\"\",F15=\"\"),\"\",(D15*'PROJECT DATA'!$B$31+F15)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D16=\"\",F16=\"\"),\"\",(D16*'PROJECT DATA'!$B$31+F16)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D17=\"\",F17=\"\"),\"\",(D17*'PROJECT DATA'!$B$31+F17)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D18=\"\",F18=\"\"),\"\",(D18*'PROJECT DATA'!$B$31+F18)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D19=\"\",F19=\"\"),\"\",(D19*'PROJECT DATA'!$B$31+F19)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D20=\"\",F20=\"\"),\"\",(D20*'PROJECT DATA'!$B$31+F20)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D21=\"\",F21=\"\"),\"\",(D21*'PROJECT DATA'!$B$31+F21)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D22=\"\",F22=\"\"),\"\",(D22*'PROJECT DATA'!$B$31+F22)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D23=\"\",F23=\"\"),\"\",(D23*'PROJECT DATA'!$B$31+F23)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D24=\"\",F24=\"\"),\"\",(D24*'PROJECT DATA'!$B$31+F24)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D25=\"\",F25=\"\"),\"\",(D25*'PROJECT DATA'!$B$31+F25)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D26=\"\",F26=\"\"),\"\",(D26*'PROJECT DATA'!$B$31+F26)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
["TOTAL (Recommended Only):",null,null,{"$f":"SUMIF($B$9:$B$26,References!$A$2,D9:D26)+SUMIF($B$9:$B$26,References!$A$3,D9:D26)+SUMIF($B$9:$B$26,References!$A$6,D9:D26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,E9:E26)+SUMIF($B$9:$B$26,References!$A$3,E9:E26)+SUMIF($B$9:$B$26,References!$A$6,E9:E26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,F9:F26)+SUMIF($B$9:$B$26,References!$A$3,F9:F26)+SUMIF($B$9:$B$26,References!$A$6,F9:F26)","v":0},{"$f":"IFERROR(((D27*'PROJECT DATA'!B31)+F27)/'PROJECT DATA'!$Q$10,\"0\"%)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,H9:H26)+SUMIF($B$9:$B$26,References!$A$3,H9:H26)+SUMIF($B$9:$B$26,References!$A$6,H9:H26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,I9:I26)+SUMIF($B$9:$B$26,References!$A$3,I9:I26)+SUMIF($B$9:$B$26,References!$A$6,I9:I26)","v":0},{"$f":"IFERROR(I27/H27,\"0.0\")","v":"0.0"}]
["TOTAL (All):",null,null,{"$f":"SUM(D9:D26)","v":0},0,0,{"$f":"IFERROR(((D28*'PROJECT DATA'!B31)+F28)/'PROJECT DATA'!$Q$10,\"0\"%)","v":0},0,0,{"$f":"IFERROR(I28/H28,\"0.0\")","v":"0.0"}]
["Notes:"]
["* Measure Status: Implemented (I); Recommended (R); Further Study Recommended (RS); Not Recommended (NR); Recommended Mutually Exclusive (RME); Mutually Exclusive (ME); Recommended Non-Energy (RNE)"]
["* MMBtu = 1,000,000 Btu"]
["* Energy savings must be presented as savings at the customer’s utility meter(s), and not at the individual building or tenant space.  "]
["* Percent of Savings to Total Fuel Consumption (%) should be a comparison of the total of all the electric and fuel savings to the total baseline energy consumption"]

{"sheet":"Site 19 PSS","index":20,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":true,"merged":[[2,1,2,4],[2,7,2,9],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,6,4],[6,5,7,5],[6,6,7,6],[31,0,31,9],[6,7,7,7],[6,8,7,8],[6,9,7,9],[26,0,26,2],[27,0,27,2],[29,0,29,9]]}
[]
[]
["Participant Site: ",{"$f":"IF(OR('PROJECT DATA'!F26=\"\",'PROJECT DATA'!C26=\"\"),\"\",CONCATENATE('PROJECT DATA'!C26,\" - \",'PROJECT DATA'!F26))","v":""},null,null,null,null,"AGG Project: ",{"$f":"IF('PROJECT DATA'!$B$2=\"\",\"\",CONCATENATE(\"AGG \",'PROJECT DATA'!$B$2,\" - \",'PROJECT DATA'!$B$3,\" - Portfolio #\",'PROJECT DATA'!$B$4))","v":""}]
[]
[]
["ENERGY SAVINGS SUMMARY"]
["Measure Description","Measure Status\n(see notes)","Fuel Type Saved\n(see notes)","Electric",null,"Fuel Savings\n(MMBtu)","Percent of Savings \nto Total Energy Consumption\n(%)","Annual Cost Savings","Implementation Cost","Simple Payback\n(Years)"]
[null,null,null,"Supply Savings\n(kWh)","Demand Savings\n(kW)"]
[null,null,null,null,null,null,{"$f":"IF(AND(D9=\"\",F9=\"\"),\"\",(D9*'PROJECT DATA'!$B$31+F9)/'PROJECT DATA'!$Q$9)","v":""},null,null,{"$f":"IFERROR(I9/H9,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(D10=\"\",F10=\"\"),\"\",(D10*'PROJECT DATA'!$B$31+F10)/'PROJECT DATA'!$Q$9)","v":""},null,null,{"$f":"IFERROR(I10/H10,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(D11=\"\",F11=\"\"),\"\",(D11*'PROJECT DATA'!$B$31+F11)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D12=\"\",F12=\"\"),\"\",(D12*'PROJECT DATA'!$B$31+F12)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D13=\"\",F13=\"\"),\"\",(D13*'PROJECT DATA'!$B$31+F13)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D14=\"\",F14=\"\"),\"\",(D14*'PROJECT DATA'!$B$31+F14)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D15=\"\",F15=\"\"),\"\",(D15*'PROJECT DATA'!$B$31+F15)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D16=\"\",F16=\"\"),\"\",(D16*'PROJECT DATA'!$B$31+F16)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D17=\"\",F17=\"\"),\"\",(D17*'PROJECT DATA'!$B$31+F17)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D18=\"\",F18=\"\"),\"\",(D18*'PROJECT DATA'!$B$31+F18)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D19=\"\",F19=\"\"),\"\",(D19*'PROJECT DATA'!$B$31+F19)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D20=\"\",F20=\"\"),\"\",(D20*'PROJECT DATA'!$B$31+F20)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D21=\"\",F21=\"\"),\"\",(D21*'PROJECT DATA'!$B$31+F21)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D22=\"\",F22=\"\"),\"\",(D22*'PROJECT DATA'!$B$31+F22)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D23=\"\",F23=\"\"),\"\",(D23*'PROJECT DATA'!$B$31+F23)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D24=\"\",F24=\"\"),\"\",(D24*'PROJECT DATA'!$B$31+F24)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D25=\"\",F25=\"\"),\"\",(D25*'PROJECT DATA'!$B$31+F25)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D26=\"\",F26=\"\"),\"\",(D26*'PROJECT DATA'!$B$31+F26)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
["TOTAL (Recommended Only):",null,null,{"$f":"SUMIF($B$9:$B$26,References!$A$2,D9:D26)+SUMIF($B$9:$B$26,References!$A$3,D9:D26)+SUMIF($B$9:$B$26,References!$A$6,D9:D26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,E9:E26)+SUMIF($B$9:$B$26,References!$A$3,E9:E26)+SUMIF($B$9:$B$26,References!$A$6,E9:E26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,F9:F26)+SUMIF($B$9:$B$26,References!$A$3,F9:F26)+SUMIF($B$9:$B$26,References!$A$6,F9:F26)","v":0},{"$f":"IFERROR(((D27*'PROJECT DATA'!B31)+F27)/'PROJECT DATA'!$Q$10,\"0\"%)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,H9:H26)+SUMIF($B$9:$B$26,References!$A$3,H9:H26)+SUMIF($B$9:$B$26,References!$A$6,H9:H26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,I9:I26)+SUMIF($B$9:$B$26,References!$A$3,I9:I26)+SUMIF($B$9:$B$26,References!$A$6,I9:I26)","v":0},{"$f":"IFERROR(I27/H27,\"0.0\")","v":"0.0"}]
["TOTAL (All):",null,null,{"$f":"SUM(D9:D26)","v":0},0,0,{"$f":"IFERROR(((D28*'PROJECT DATA'!B31)+F28)/'PROJECT DATA'!$Q$10,\"0\"%)","v":0},0,0,{"$f":"IFERROR(I28/H28,\"0.0\")","v":"0.0"}]
["Notes:"]
["* Measure Status: Implemented (I); Recommended (R); Further Study Recommended (RS); Not Recommended (NR); Recommended Mutually Exclusive (RME); Mutually Exclusive (ME); Recommended Non-Energy (RNE)"]
["* MMBtu = 1,000,000 Btu"]
["* Energy savings must be presented as savings at the customer’s utility meter(s), and not at the individual building or tenant space.  "]
["* Percent of Savings to Total Fuel Consumption (%) should be a comparison of the total of all the electric and fuel savings to the total baseline energy consumption"]

{"sheet":"Site 20 PSS","index":21,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":true,"merged":[[2,1,2,4],[2,7,2,9],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,6,4],[6,5,7,5],[6,6,7,6],[31,0,31,9],[6,7,7,7],[6,8,7,8],[6,9,7,9],[26,0,26,2],[27,0,27,2],[29,0,29,9]]}
[]
[]
["Participant Site: ",{"$f":"IF(OR('PROJECT DATA'!F27=\"\",'PROJECT DATA'!C27=\"\"),\"\",CONCATENATE('PROJECT DATA'!C27,\" - \",'PROJECT DATA'!F27))","v":""},null,null,null,null,"AGG Project: ",{"$f":"IF('PROJECT DATA'!$B$2=\"\",\"\",CONCATENATE(\"AGG \",'PROJECT DATA'!$B$2,\" - \",'PROJECT DATA'!$B$3,\" - Portfolio #\",'PROJECT DATA'!$B$4))","v":""}]
[]
[]
["ENERGY SAVINGS SUMMARY"]
["Measure Description","Measure Status\n(see notes)","Fuel Type Saved\n(see notes)","Electric",null,"Fuel Savings\n(MMBtu)","Percent of Savings \nto Total Energy Consumption\n(%)","Annual Cost Savings","Implementation Cost","Simple Payback\n(Years)"]
[null,null,null,"Supply Savings\n(kWh)","Demand Savings\n(kW)"]
[null,null,null,null,null,null,{"$f":"IF(AND(D9=\"\",F9=\"\"),\"\",(D9*'PROJECT DATA'!$B$31+F9)/'PROJECT DATA'!$Q$9)","v":""},null,null,{"$f":"IFERROR(I9/H9,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(D10=\"\",F10=\"\"),\"\",(D10*'PROJECT DATA'!$B$31+F10)/'PROJECT DATA'!$Q$9)","v":""},null,null,{"$f":"IFERROR(I10/H10,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(D11=\"\",F11=\"\"),\"\",(D11*'PROJECT DATA'!$B$31+F11)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D12=\"\",F12=\"\"),\"\",(D12*'PROJECT DATA'!$B$31+F12)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D13=\"\",F13=\"\"),\"\",(D13*'PROJECT DATA'!$B$31+F13)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D14=\"\",F14=\"\"),\"\",(D14*'PROJECT DATA'!$B$31+F14)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D15=\"\",F15=\"\"),\"\",(D15*'PROJECT DATA'!$B$31+F15)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D16=\"\",F16=\"\"),\"\",(D16*'PROJECT DATA'!$B$31+F16)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D17=\"\",F17=\"\"),\"\",(D17*'PROJECT DATA'!$B$31+F17)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D18=\"\",F18=\"\"),\"\",(D18*'PROJECT DATA'!$B$31+F18)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D19=\"\",F19=\"\"),\"\",(D19*'PROJECT DATA'!$B$31+F19)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D20=\"\",F20=\"\"),\"\",(D20*'PROJECT DATA'!$B$31+F20)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D21=\"\",F21=\"\"),\"\",(D21*'PROJECT DATA'!$B$31+F21)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D22=\"\",F22=\"\"),\"\",(D22*'PROJECT DATA'!$B$31+F22)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D23=\"\",F23=\"\"),\"\",(D23*'PROJECT DATA'!$B$31+F23)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D24=\"\",F24=\"\"),\"\",(D24*'PROJECT DATA'!$B$31+F24)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D25=\"\",F25=\"\"),\"\",(D25*'PROJECT DATA'!$B$31+F25)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(D26=\"\",F26=\"\"),\"\",(D26*'PROJECT DATA'!$B$31+F26)/'PROJECT DATA'!$Q$9)","v":""},null,null,""]
["TOTAL (Recommended Only):",null,null,{"$f":"SUMIF($B$9:$B$26,References!$A$2,D9:D26)+SUMIF($B$9:$B$26,References!$A$3,D9:D26)+SUMIF($B$9:$B$26,References!$A$6,D9:D26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,E9:E26)+SUMIF($B$9:$B$26,References!$A$3,E9:E26)+SUMIF($B$9:$B$26,References!$A$6,E9:E26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,F9:F26)+SUMIF($B$9:$B$26,References!$A$3,F9:F26)+SUMIF($B$9:$B$26,References!$A$6,F9:F26)","v":0},{"$f":"IFERROR(((D27*'PROJECT DATA'!B31)+F27)/'PROJECT DATA'!$Q$10,\"0\"%)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,H9:H26)+SUMIF($B$9:$B$26,References!$A$3,H9:H26)+SUMIF($B$9:$B$26,References!$A$6,H9:H26)","v":0},{"$f":"SUMIF($B$9:$B$26,References!$A$2,I9:I26)+SUMIF($B$9:$B$26,References!$A$3,I9:I26)+SUMIF($B$9:$B$26,References!$A$6,I9:I26)","v":0},{"$f":"IFERROR(I27/H27,\"0.0\")","v":"0.0"}]
["TOTAL (All):",null,null,{"$f":"SUM(D9:D26)","v":0},0,0,{"$f":"IFERROR(((D28*'PROJECT DATA'!B31)+F28)/'PROJECT DATA'!$Q$10,\"0\"%)","v":0},0,0,{"$f":"IFERROR(I28/H28,\"0.0\")","v":"0.0"}]
["Notes:"]
["* Measure Status: Implemented (I); Recommended (R); Further Study Recommended (RS); Not Recommended (NR); Recommended Mutually Exclusive (RME); Mutually Exclusive (ME); Recommended Non-Energy (RNE)"]
["* MMBtu = 1,000,000 Btu"]
["* Energy savings must be presented as savings at the customer’s utility meter(s), and not at the individual building or tenant space.  "]
["* Percent of Savings to Total Fuel Consumption (%) should be a comparison of the total of all the electric and fuel savings to the total baseline energy consumption"]

{"sheet":"1st Quarter PSS","index":22,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,10],[28,0,28,10],[4,4,4,5],[4,3,5,3],[4,2,5,2],[4,1,5,1],[4,6,5,6],[4,8,5,8],[4,9,5,9],[31,0,31,9],[30,0,30,9],[25,0,25,3],[26,0,26,3],[4,10,5,10],[4,0,5,0],[4,7,5,7]]}
["First Quarterly Report"]
[]
["ENERGY SAVINGS SUMMARY for: ",null,{"$f":"IF('PROJECT DATA'!$B$2=\"\",\"\",CONCATENATE(\"AGG \",'PROJECT DATA'!$B$2,\" - \",'PROJECT DATA'!$B$3,\" - Portfolio #\",'PROJECT DATA'!$B$4))","v":""}]
[]
["Participant Site","Measure Description","Measure Status\n(see notes)","Fuel Type Saved\n(see notes)","Electric",null,"Fuel Savings\n(MMBtu)","Percent of Savings to Total Energy Consumption\n(%)","Annual Cost Savings","Implemen-tation Cost","Simple Payback\n(Years)"]
[null,null,null,null,"Supply Savings\n(kWh)","Demand Savings\n(kW)"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(J7/I7,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
["TOTAL (Recommended Only):",null,null,null,{"$f":"SUMIF($C$7:$C$25,References!$A$2,E7:E25)+SUMIF($C$7:$C$25,References!$A$3,E7:E25)+SUMIF($C$7:'1st Quarter PSS'!$C$25,References!$A$6,E7:E25)","v":0},{"$f":"SUMIF($C$7:$C$25,References!$A$2,F7:F25)+SUMIF($C$7:$C$25,References!$A$3,F7:F25)+SUMIF($C$7:$C$25,References!$A$6,F7:F25)","v":0},{"$f":"SUMIF($C$7:$C$25,References!$A$2,G7:G25)+SUMIF($C$7:$C$25,References!$A$3,G7:G25)+SUMIF($C$7:$C$25,References!$A$6,G7:G25)","v":0},null,{"$f":"SUMIF($C$7:$C$25,References!$A$2,I7:I25)+SUMIF($C$7:$C$25,References!$A$3,I7:I25)+SUMIF($C$7:$C$25,References!$A$6,I7:I25)","v":0},{"$f":"SUMIF($C$7:$C$25,References!$A$2,J7:J25)+SUMIF($C$7:$C$25,References!$A$3,J7:J25)+SUMIF($C$7:$C$25,References!$A$6,J7:J25)","v":0},{"$f":"IFERROR(J26/I26,\"0.0\")","v":"0.0"}]
["TOTAL (All):",null,null,null,{"$f":"SUM(E7:E25)","v":0},{"$f":"SUM(F7:F25)","v":0},{"$f":"SUM(G7:G25)","v":0},null,{"$f":"SUM(I7:I25)","v":0},{"$f":"SUM(J7:J25)","v":0},{"$f":"IFERROR(J27/I27,\"0.0\")","v":"0.0"}]
["Notes:"]
["* Measure Status: Implemented (I); Recommended (R); Further Study Recommended (RS); Not Recommended (NR); Recommended Mutually Exclusive (RME); Mutually Exclusive (ME); Recommended \n   Non-Energy (RNE)"]
["* MMBtu = 1,000,000 Btu"]
["* Energy savings must be presented as savings at the customer’s utility meter(s), and not at the individual building or tenant space"]
["* Only include savings from the participant site energy study reports that were approved by NYSERDA during the specific quarter"]

{"sheet":"1st Quarter Payment","index":23,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":false,"merged":[[33,1,33,6],[37,3,37,4],[36,3,36,4],[35,3,35,4],[2,0,2,7],[3,0,3,7],[14,2,14,4],[8,2,8,4],[10,2,10,4],[12,2,12,6],[6,2,6,3]]}
[]
[]
["1st Quarter Performance Incentive"]
["Payment Request"]
[]
[]
[null,"Date: "]
[]
[null,"FlexTech Consultant: ",{"$f":"IF('PROJECT DATA'!$B$3=\"\",\"\",'PROJECT DATA'!$B$3)","v":""}]
[]
[null,"FlexTech Consultant #: ",{"$f":"IF('PROJECT DATA'!$F$3=\"\",\"\",'PROJECT DATA'!$F$3)","v":""}]
[]
[null,"Project # and Name: ",{"$f":"IF('PROJECT DATA'!$B$2=\"\",\"\",CONCATENATE(\"AGG \",'PROJECT DATA'!$B$2,\" - \",'PROJECT DATA'!$B$3,\" - Portfolio #\",'PROJECT DATA'!$B$4))","v":""}]
[]
[null,"PO Number: ",{"$f":"IF('PROJECT DATA'!$F$2=\"\",\"\",'PROJECT DATA'!$F$2)","v":""}]
[]
[null,"Performance Incentive"]
[null,null,"MWh Incentive (@ $110/MWh) = ",{"$f":"'1st Quarter PSS'!$E$26*0.11","v":0}]
[null,null,"MMBtu Incentive (@$5/MMBtu) = ",{"$f":"'1st Quarter PSS'!$G$26*5","v":0}]
[null,null,"Total Potential Incentive =",{"$f":"SUM(D18:D19)","v":0}]
[]
[null,"Performance Incentive Cap Check"]
[null,null,"Performance Incentive Cap: ",45000]
[null,null,"Total Eligible Incentive: ",{"$f":"IF(D23<0,0,IF(D23-D20>0,D20,IF(D20-(D23),D23)))","v":0}]
[]
[null,"Incentive Withheld (payable upon approval of final report)"]
[null,null,"15% withheld from this quarter's incentive:",{"$f":"D24*0.15","v":0},"* withheld from the total eligible incentive amount above"]
[]
[null,null,"Invoice Amount: ",{"$f":"D24-D27","v":0},"* Total Eligible Incentive minus current quarter's retainage"]
[]
[]
[]
[null,"  NYSERDA Certification"]
[null,"I certify that I have reviewed this invoice and also certify, to the best of my knowldege, that the invoice and related documentation represent reasonable and appropriate costs for work performed in accordance with the contract or porgram requirements and recomment payment of the invoice. "]
[]
[null,"  NYSERDA Approval","Date of Approval: "]
[null,null,"Approved By: "]

{"sheet":"2nd Quarter PSS","index":24,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,10],[28,0,28,10],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,4,5],[4,6,5,6],[4,8,5,8],[4,9,5,9],[31,0,31,9],[25,0,25,3],[26,0,26,3],[30,0,30,9],[4,10,5,10],[4,7,5,7]]}
["Second Quarterly Report"]
[]
["ENERGY SAVINGS SUMMARY for: ",null,{"$f":"IF('PROJECT DATA'!$B$2=\"\",\"\",CONCATENATE(\"AGG \",'PROJECT DATA'!$B$2,\" - \",'PROJECT DATA'!$B$3,\" - Portfolio #\",'PROJECT DATA'!$B$4))","v":""}]
[]
["Participant Site","Measure Description","Measure Status\n(see notes)","Fuel Type Saved\n(see notes)","Electric",null,"Fuel Savings\n(MMBtu)","Percent of Savings to Total Energy Consumption\n(%)","Annual Cost Savings","Implemen-tation Cost","Simple Payback\n(Years)"]
[null,null,null,null,"Supply Savings\n(kWh)","Demand Savings\n(kW)"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(J7/I7,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(J12/I12,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
["TOTAL (Recommended Only):",null,null,null,{"$f":"SUMIF($C$7:$C$25,References!$A$2,E7:E25)+SUMIF($C$7:$C$25,References!$A$3,E7:E25)+SUMIF($C$7:$C$25,References!$A$6,E7:E25)","v":0},{"$f":"SUMIF($C$7:$C$25,References!$A$2,F7:F25)+SUMIF($C$7:$C$25,References!$A$3,F7:F25)+SUMIF($C$7:$C$25,References!$A$6,F7:F25)","v":0},{"$f":"SUMIF($C$7:$C$25,References!$A$2,G7:G25)+SUMIF($C$7:$C$25,References!$A$3,G7:G25)+SUMIF($C$7:$C$25,References!$A$6,G7:G25)","v":0},null,{"$f":"SUMIF($C$7:$C$25,References!$A$2,I7:I25)+SUMIF($C$7:$C$25,References!$A$3,I7:I25)+SUMIF($C$7:$C$25,References!$A$6,I7:I25)","v":0},{"$f":"SUMIF($C$7:$C$25,References!$A$2,J7:J25)+SUMIF($C$7:$C$25,References!$A$3,J7:J25)+SUMIF($C$7:$C$25,References!$A$6,J7:J25)","v":0},{"$f":"IFERROR(J26/I26,\"0.0\")","v":"0.0"}]
["TOTAL (All):",null,null,null,{"$f":"SUM(E7:E25)","v":0},{"$f":"SUM(F7:F25)","v":0},{"$f":"SUM(G7:G25)","v":0},null,{"$f":"SUM(I7:I25)","v":0},{"$f":"SUM(J7:J25)","v":0},{"$f":"IFERROR(J27/I27,\"0.0\")","v":"0.0"}]
["Notes:"]
["* Measure Status: Implemented (I); Recommended (R); Further Study Recommended (RS); Not Recommended (NR); Recommended Mutually Exclusive (RME); Mutually Exclusive (ME); Recommended \n   Non-Energy (RNE)"]
["* MMBtu = 1,000,000 Btu"]
["* Energy savings must be presented as savings at the customer’s utility meter(s), and not at the individual building or tenant space"]
["* Only include savings from the participant site energy study reports that were approved by NYSERDA during the specific quarter"]

{"sheet":"2nd Quarter Payment","index":25,"n_rows":39,"n_cols":5,"rows_kept":39,"cut":false,"hidden":false,"merged":[[35,1,35,6],[37,3,37,4],[38,3,38,4],[14,2,14,4],[2,0,2,7],[3,0,3,7],[6,2,6,3],[8,2,8,4],[10,2,10,4],[12,2,12,6]]}
[]
[]
["2nd Quarter Performance Incentive"]
["Payment Request"]
[]
[]
[null,"Date: "]
[]
[null,"FlexTech Consultant: ",{"$f":"IF('PROJECT DATA'!$B$3=\"\",\"\",'PROJECT DATA'!$B$3)","v":""}]
[]
[null,"FlexTech Consultant #: ",{"$f":"IF('PROJECT DATA'!$F$3=\"\",\"\",'PROJECT DATA'!$F$3)","v":""}]
[]
[null,"Project # and Name: ",{"$f":"IF('PROJECT DATA'!$B$2=\"\",\"\",CONCATENATE(\"AGG \",'PROJECT DATA'!$B$2,\" - \",'PROJECT DATA'!$B$3,\" - Portfolio #\",'PROJECT DATA'!$B$4))","v":""}]
[]
[null,"PO Number: ",{"$f":"IF('PROJECT DATA'!$F$2=\"\",\"\",'PROJECT DATA'!$F$2)","v":""}]
[]
[null,"Performance Incentive"]
[null,null,"MWh Incentive (@ $110/MWh) = ",{"$f":"'2nd Quarter PSS'!$E$26*0.11","v":0}]
[null,null,"MMBtu Incentive (@$5/MMBtu) = ",{"$f":"'2nd Quarter PSS'!$G$26*5","v":0}]
[null,null,"Total Potential Incentive =",{"$f":"SUM(D18:D19)","v":0}]
[]
[null,"Performance Incentive Cap Check"]
[null,null,"Performance Incentive Cap: ",45000]
[null,null,"Previous Payment(s) & Incentive Withheld:",{"$f":"'1st Quarter Payment'!D27+'1st Quarter Payment'!D29","v":0}]
[null,null,"Total Eligible Incentive: ",{"$f":"IF(D23-D24<0,0,IF(D23-D24-D20>0,D20,IF(D20-(D23-D24),D23-D24)))","v":0}]
[]
[null,"Incentive Withheld (payable upon approval of final report)"]
[null,null,"15% withheld from this quarter's incentive:",{"$f":"D25*0.15","v":0},"* withheld from the total eligible incentive amount above"]
[null,null,"Total incentive withheld to date:",{"$f":"D28+'1st Quarter Payment'!D27","v":0},"* withheld from this and all prior invoices"]
[]
[null,null,"Invoice Amount: ",{"$f":"D25-D28","v":0},"* Total Eligible Incentive minus current quarter's retainage"]
[]
[]
[]
[null,"  NYSERDA Certification"]
[null,"I certify that I have reviewed this invoice and also certify, to the best of my knowldege, that the invoice and related documentation represent reasonable and appropriate costs for work performed in accordance with the contract or porgram requirements and recomment payment of the invoice. "]
[]
[null,"  NYSERDA Approval","Date of Approval: "]
[null,null,"Approved By: "]

{"sheet":"3rd Quarter PSS","index":26,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,10],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,4,5],[4,6,5,6],[4,8,5,8],[4,9,5,9],[4,10,5,10],[4,7,5,7],[31,0,31,10],[25,0,25,3],[26,0,26,3],[28,0,28,10],[30,0,30,10]]}
["Third Quarterly Report"]
[]
["ENERGY SAVINGS SUMMARY for: ",null,{"$f":"IF('PROJECT DATA'!$B$2=\"\",\"\",CONCATENATE(\"AGG \",'PROJECT DATA'!$B$2,\" - \",'PROJECT DATA'!$B$3,\" - Portfolio #\",'PROJECT DATA'!$B$4))","v":""}]
[]
["Participant Site","Measure Description","Measure Status\n(see notes)","Fuel Type Saved\n(see notes)","Electric",null,"Fuel Savings\n(MMBtu)","Percent of Savings to Total Energy Consumption\n(%)","Annual Cost Savings","Implemen-tation Cost","Simple Payback\n(Years)"]
[null,null,null,null,"Supply Savings\n(kWh)","Demand Savings\n(kW)"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(J7/I7,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(J8/I8,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
["TOTAL (Recommended Only):",null,null,null,{"$f":"SUMIF($C$7:$C$25,References!$A$2,E7:E25)+SUMIF($C$7:$C$25,References!$A$3,E7:E25)+SUMIF($C$7:$C$25,References!$A$6,E7:E25)","v":0},{"$f":"SUMIF($C$7:$C$25,References!$A$2,F7:F25)+SUMIF($C$7:$C$25,References!$A$3,F7:F25)+SUMIF($C$7:$C$25,References!$A$6,F7:F25)","v":0},{"$f":"SUMIF($C$7:$C$25,References!$A$2,G7:G25)+SUMIF($C$7:$C$25,References!$A$3,G7:G25)+SUMIF($C$7:$C$25,References!$A$6,G7:G25)","v":0},null,{"$f":"SUMIF($C$7:$C$25,References!$A$2,I7:I25)+SUMIF($C$7:$C$25,References!$A$3,I7:I25)+SUMIF($C$7:$C$25,References!$A$6,I7:I25)","v":0},{"$f":"SUMIF($C$7:$C$25,References!$A$2,J7:J25)+SUMIF($C$7:$C$25,References!$A$3,J7:J25)+SUMIF($C$7:$C$25,References!$A$6,J7:J25)","v":0},{"$f":"IFERROR(J26/I26,\"0.0\")","v":"0.0"}]
["TOTAL (All):",null,null,null,{"$f":"SUM(E7:E25)","v":0},{"$f":"SUM(F7:F25)","v":0},{"$f":"SUM(G7:G25)","v":0},null,{"$f":"SUM(I7:I25)","v":0},{"$f":"SUM(J7:J25)","v":0},{"$f":"IFERROR(J27/I27,\"0.0\")","v":"0.0"}]
["Notes:"]
["* Measure Status: Implemented (I); Recommended (R); Further Study Recommended (RS); Not Recommended (NR); Recommended Mutually Exclusive (RME); Mutually Exclusive (ME); Recommended \n   Non-Energy (RNE)"]
["* MMBtu = 1,000,000 Btu"]
["* Energy savings must be presented as savings at the customer’s utility meter(s), and not at the individual building or tenant space"]
["* Only include savings from the participant site energy study reports that were approved by NYSERDA during the specific quarter"]

{"sheet":"3rd Quarter Payment","index":27,"n_rows":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":false,"merged":[[34,1,34,6],[36,3,36,4],[37,3,37,4],[14,2,14,4],[2,0,2,7],[3,0,3,7],[6,2,6,3],[8,2,8,4],[10,2,10,4],[12,2,12,6]]}
[]
[]
["3rd Quarter Performance Incentive"]
["Payment Request"]
[]
[]
[null,"Date: "]
[]
[null,"FlexTech Consultant: ",{"$f":"IF('PROJECT DATA'!$B$3=\"\",\"\",'PROJECT DATA'!$B$3)","v":""}]
[]
[null,"FlexTech Consultant #: ",{"$f":"IF('PROJECT DATA'!$F$3=\"\",\"\",'PROJECT DATA'!$F$3)","v":""}]
[]
[null,"Project # and Name: ",{"$f":"IF('PROJECT DATA'!$B$2=\"\",\"\",CONCATENATE(\"AGG \",'PROJECT DATA'!$B$2,\" - \",'PROJECT DATA'!$B$3,\" - Portfolio #\",'PROJECT DATA'!$B$4))","v":""}]
[]
[null,"PO Number: ",{"$f":"IF('PROJECT DATA'!$F$2=\"\",\"\",'PROJECT DATA'!$F$2)","v":""}]
[]
[null,"Performance Incentive"]
[null,null,"MWh Incentive (@ $110/MWh) = ",{"$f":"'3rd Quarter PSS'!$E$26*0.11","v":0}]
[null,null,"MMBtu Incentive (@$5/MMBtu) = ",{"$f":"'3rd Quarter PSS'!$G$26*5","v":0}]
[null,null,"Total Potential Incentive =",{"$f":"SUM(D18:D19)","v":0}]
[]
[null,"Performance Incentive Cap Check"]
[null,null,"Performance Incentive Cap: ",45000]
[null,null,"Previous Payment(s) & Incentive Withheld:",{"$f":"'2nd Quarter Payment'!D28+'2nd Quarter Payment'!D31+'2nd Quarter Payment'!D24","v":0}]
[null,null,"Total Eligible Incentive: ",{"$f":"IF(D23-D24<0,0,IF(D23-D24-D20>0,D20,IF(D20-(D23-D24),D23-D24)))","v":0}]
[]
[null,"Incentive Withheld (payable upon approval of final report)"]
[null,null,"15% withheld from this quarter's incentive:",{"$f":"D25*0.15","v":0},"* withheld from the total eligible incentive amount above"]
[null,null,"Total incentive withheld to date:",{"$f":"D28+'2nd Quarter Payment'!D29","v":0},"* withheld from this and all prior invoices"]
[]
[null,null,"Invoice Amount: ",{"$f":"D25-D28","v":0},"* Total Eligible Incentive minus current quarter's retainage"]
[]
[]
[null,"  NYSERDA Certification"]
[null,"I certify that I have reviewed this invoice and also certify, to the best of my knowldege, that the invoice and related documentation represent reasonable and appropriate costs for work performed in accordance with the contract or porgram requirements and recomment payment of the invoice. "]
[]
[null,"  NYSERDA Approval","Date of Approval: "]
[null,null,"Approved By: "]

{"sheet":"4th Quarter PSS","index":28,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,10],[28,0,28,10],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,4,5],[4,6,5,6],[4,7,5,7],[4,8,5,8],[4,9,5,9],[31,0,31,9],[25,0,25,3],[26,0,26,3],[30,0,30,9],[4,10,5,10]]}
["Fourth Quarterly Report"]
[]
["ENERGY SAVINGS SUMMARY for: ",null,{"$f":"IF('PROJECT DATA'!$B$2=\"\",\"\",CONCATENATE(\"AGG \",'PROJECT DATA'!$B$2,\" - \",'PROJECT DATA'!$B$3,\" - Portfolio #\",'PROJECT DATA'!$B$4))","v":""}]
[]
["Participant Site","Measure Description","Measure Status\n(see notes)","Fuel Type Saved\n(see notes)","Electric",null,"Fuel Savings\n(MMBtu)","Percent of Savings to Total Energy Consumption\n(%)","Annual Cost Savings","Implemen-tation Cost","Simple Payback\n(Years)"]
[null,null,null,null,"Supply Savings\n(kWh)","Demand Savings\n(kW)"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(J7/I7,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(J8/I8,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
["TOTAL (Recommended Only):",null,null,null,{"$f":"SUMIF($C$7:$C$25,References!$A$2,E7:E25)+SUMIF($C$7:$C$25,References!$A$3,E7:E25)+SUMIF($C$7:$C$25,References!$A$6,E7:E25)","v":0},{"$f":"SUMIF($C$7:$C$25,References!$A$2,F7:F25)+SUMIF($C$7:$C$25,References!$A$3,F7:F25)+SUMIF($C$7:$C$25,References!$A$6,F7:F25)","v":0},{"$f":"SUMIF($C$7:$C$25,References!$A$2,G7:G25)+SUMIF($C$7:$C$25,References!$A$3,G7:G25)+SUMIF($C$7:$C$25,References!$A$6,G7:G25)","v":0},null,{"$f":"SUMIF($C$7:$C$25,References!$A$2,I7:I25)+SUMIF($C$7:$C$25,References!$A$3,I7:I25)+SUMIF($C$7:$C$25,References!$A$6,I7:I25)","v":0},{"$f":"SUMIF($C$7:$C$25,References!$A$2,J7:J25)+SUMIF($C$7:$C$25,References!$A$3,J7:J25)+SUMIF($C$7:$C$25,References!$A$6,J7:J25)","v":0},{"$f":"IFERROR(J26/I26,\"0.0\")","v":"0.0"}]
["TOTAL (All):",null,null,null,{"$f":"SUM(E7:E25)","v":0},{"$f":"SUM(F7:F25)","v":0},{"$f":"SUM(G7:G25)","v":0},null,{"$f":"SUM(I7:I25)","v":0},{"$f":"SUM(J7:J25)","v":0},{"$f":"IFERROR(J27/I27,\"0.0\")","v":"0.0"}]
["Notes:"]
["* Measure Status: Implemented (I); Recommended (R); Further Study Recommended (RS); Not Recommended (NR); Recommended Mutually Exclusive (RME); Mutually Exclusive (ME); Recommended \n   Non-Energy (RNE)"]
["* MMBtu = 1,000,000 Btu"]
["* Energy savings must be presented as savings at the customer’s utility meter(s), and not at the individual building or tenant space"]
["* Only include savings from the participant site energy study reports that were approved by NYSERDA during the specific quarter"]

{"sheet":"4th Quarter Payment","index":29,"n_rows":39,"n_cols":5,"rows_kept":39,"cut":false,"hidden":false,"merged":[[35,1,35,6],[37,3,37,4],[38,3,38,4],[14,2,14,4],[2,0,2,7],[3,0,3,7],[6,2,6,3],[8,2,8,4],[10,2,10,4],[12,2,12,6]]}
[]
[]
["4th Quarter Performance Incentive"]
["Payment Request"]
[]
[]
[null,"Date: "]
[]
[null,"FlexTech Consultant: ",{"$f":"IF('PROJECT DATA'!$B$3=\"\",\"\",'PROJECT DATA'!$B$3)","v":""}]
[]
[null,"FlexTech Consultant #: ",{"$f":"IF('PROJECT DATA'!$F$3=\"\",\"\",'PROJECT DATA'!$F$3)","v":""}]
[]
[null,"Project # and Name: ",{"$f":"IF('PROJECT DATA'!$B$2=\"\",\"\",CONCATENATE(\"AGG \",'PROJECT DATA'!$B$2,\" - \",'PROJECT DATA'!$B$3,\" - Portfolio #\",'PROJECT DATA'!$B$4))","v":""}]
[]
[null,"PO Number: ",{"$f":"IF('PROJECT DATA'!$F$2=\"\",\"\",'PROJECT DATA'!$F$2)","v":""}]
[]
[null,"Performance Incentive"]
[null,null,"MWh Incentive (@ $110/MWh) = ",{"$f":"'4th Quarter PSS'!$E$26*0.11","v":0}]
[null,null,"MMBtu Incentive (@$5/MMBtu) = ",{"$f":"'4th Quarter PSS'!$G$26*5","v":0}]
[null,null,"Total Potential Incentive =",{"$f":"SUM(D18:D19)","v":0}]
[]
[null,"Performance Incentive Cap Check"]
[null,null,"Performance Incentive Cap: ",45000]
[null,null,"Previous Payment(s) & Incentive Withheld:",{"$f":"'3rd Quarter Payment'!D28+'3rd Quarter Payment'!D31+'3rd Quarter Payment'!D24","v":0}]
[null,null,"Total Eligible Incentive: ",{"$f":"IF(D23-D24<0,0,IF(D23-D24-D20>0,D20,IF(D20-(D23-D24),D23-D24)))","v":0}]
[]
[null,"Incentive Withheld (payable upon approval of final report)"]
[null,null,"15% withheld from this quarter's incentive:",{"$f":"D25*0.15","v":0},"* withheld from the total eligible incentive amount above"]
[null,null,"Total incentive withheld to date:",{"$f":"D28+'3rd Quarter Payment'!D29","v":0},"* withheld from this and all prior invoices"]
[]
[null,null,"Invoice Amount: ",{"$f":"D25-D28","v":0},"* Total Eligible Incentive minus current quarter's retainage"]
[]
[]
[]
[null,"  NYSERDA Certification"]
[null,"I certify that I have reviewed this invoice and also certify, to the best of my knowldege, that the invoice and related documentation represent reasonable and appropriate costs for work performed in accordance with the contract or porgram requirements and recomment payment of the invoice. "]
[]
[null,"  NYSERDA Approval","Date of Approval: "]
[null,null,"Approved By: "]

{"sheet":"Total Aggregated Savings","index":30,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[13,0,13,10],[11,0,11,1],[7,3,8,3],[7,4,7,5],[7,6,8,6],[7,8,8,8],[7,0,8,1],[7,2,8,2],[0,0,0,10],[7,7,8,7],[9,0,9,1],[10,0,10,1],[7,9,8,9],[7,10,8,10]]}
["Total Aggregation Portfolio Savings"]
[]
["ENERGY SAVINGS SUMMARY for: ",null,{"$f":"IF('PROJECT DATA'!$B$2=\"\",\"\",CONCATENATE(\"AGG \",'PROJECT DATA'!$B$2,\" - \",'PROJECT DATA'!$B$3,\" - Portfolio #\",'PROJECT DATA'!$B$4))","v":""}]
[]
["# of customers in the aggregation portfolio:"]
["# of participant sites in the aggregation portfolio:"]
[]
["TOTAL AGGREGATION \nPORTFOLIO SAVINGS",null,"Number of Measures","Predominant Fuel Type Saved\n(see notes)","Electric",null,"Fuel Savings\n(MMBtu)","Percent of Savings \nto Total Fuel Consumption\n(%)","Annual Cost Savings","Implementation Cost","Simple Payback\n(Years)"]
[null,null,null,null,"Supply Savings\n(kWh)","Demand Savings\n(kW)"]
["Recommended Only:  ",null,{"$f":"SUM(COUNTIF('4th Quarter PSS'!C7:C25,\"I\"),COUNTIF('4th Quarter PSS'!C7:C25,\"R\"),COUNTIF('4th Quarter PSS'!C7:C25,\"RME\"),COUNTIF('3rd Quarter PSS'!C7:C25,\"I\"),COUNTIF('3rd Quarter PSS'!C7:C25,\"R\"),COUNTIF('3rd Quarter PSS'!C7:C25,\"RME\"),COUNTIF('2nd Quarter PSS'!C7:C25,\"I\"),COUNTIF('2nd Quarter PSS'!C7:C25,\"R\"),COUNTIF('2nd Quarter PSS'!C7:C25,\"RME\"),COUNTIF('1st Quarter PSS'!C7:C25,\"I\"),COUNTIF('1st Quarter PSS'!C7:C25,\"R\"),COUNTIF('1st Quarter PSS'!C7:C25,\"RME\"))","v":0},null,{"$f":"SUM('1st Quarter PSS'!E26+'2nd Quarter PSS'!E26+'3rd Quarter PSS'!E26+'4th Quarter PSS'!E26)","v":0},{"$f":"SUM('1st Quarter PSS'!F26+'2nd Quarter PSS'!F26+'3rd Quarter PSS'!F26+'4th Quarter PSS'!F26)","v":0},{"$f":"SUM('1st Quarter PSS'!G26+'2nd Quarter PSS'!G26+'3rd Quarter PSS'!G26+'4th Quarter PSS'!G26)","v":0},{"$f":"((E10*'PROJECT DATA'!$B$31)+G10)/'PROJECT DATA'!$Q$28","v":{"$error":"#DIV/0!"}},{"$f":"SUM('1st Quarter PSS'!I26+'2nd Quarter PSS'!I26+'3rd Quarter PSS'!I26+'4th Quarter PSS'!I26)","v":0},{"$f":"SUM('1st Quarter PSS'!J26+'2nd Quarter PSS'!J26+'3rd Quarter PSS'!J26+'4th Quarter PSS'!J26)","v":0},{"$f":"IFERROR(J10/I10,\"0.0\")","v":"0.0"}]
["Not Recommended Only:   ",null,{"$f":"SUM(COUNTIF('4th Quarter PSS'!C7:C25,\"NR\"),COUNTIF('4th Quarter PSS'!C7:C25,\"ME\"),COUNTIF('4th Quarter PSS'!C7:C25,\"RNE\"),COUNTIF('4th Quarter PSS'!C7:C25,\"RS\"),COUNTIF('2nd Quarter PSS'!C7:C25,\"NR\"),COUNTIF('2nd Quarter PSS'!C7:C25,\"ME\"),COUNTIF('2nd Quarter PSS'!C7:C25,\"RNE\"),COUNTIF('2nd Quarter PSS'!C7:C25,\"RS\"),COUNTIF('1st Quarter PSS'!C7:C25,\"NR\"),COUNTIF('1st Quarter PSS'!C7:C25,\"ME\"),COUNTIF('1st Quarter PSS'!C7:C25,\"RNE\"),COUNTIF('1st Quarter PSS'!C7:C25,\"RS\"),COUNTIF('3rd Quarter PSS'!C7:C25,\"NR\"),COUNTIF('3rd Quarter PSS'!C7:C25,\"ME\"),COUNTIF('3rd Quarter PSS'!C7:C25,\"RNE\"),COUNTIF('3rd Quarter PSS'!C7:C25,\"RS\"))","v":0},null,{"$f":"E12-E10","v":0},{"$f":"F12-F10","v":0},{"$f":"G12-G10","v":0},{"$f":"((E11*'PROJECT DATA'!$B$31)+G11)/'PROJECT DATA'!$Q$28","v":{"$error":"#DIV/0!"}},{"$f":"I12-I10","v":0},{"$f":"J12-J10","v":0},{"$f":"IFERROR(J11/I11,\"0.0\")","v":"0.0"}]
["All:     ",null,{"$f":"COUNTA('1st Quarter PSS'!C7:C25,'2nd Quarter PSS'!C7:C25,'3rd Quarter PSS'!C7:C25,'4th Quarter PSS'!C7:C25)","v":0},null,{"$f":"SUM('1st Quarter PSS'!E27+'2nd Quarter PSS'!E27+'3rd Quarter PSS'!E27+'4th Quarter PSS'!E27)","v":0},{"$f":"SUM('1st Quarter PSS'!F27+'2nd Quarter PSS'!F27+'3rd Quarter PSS'!F27+'4th Quarter PSS'!F27)","v":0},{"$f":"SUM('1st Quarter PSS'!G27+'2nd Quarter PSS'!G27+'3rd Quarter PSS'!G27+'4th Quarter PSS'!G27)","v":0},{"$f":"((E12*'PROJECT DATA'!$B$31)+G12)/'PROJECT DATA'!$Q$28","v":{"$error":"#DIV/0!"}},{"$f":"SUM('1st Quarter PSS'!I27+'2nd Quarter PSS'!I27+'3rd Quarter PSS'!I27+'4th Quarter PSS'!I27)","v":0},{"$f":"SUM('1st Quarter PSS'!J27+'2nd Quarter PSS'!J27+'3rd Quarter PSS'!J27+'4th Quarter PSS'!J27)","v":0},"0.0"]
["Notes:"]
["* Measure Status: Implemented (I); Recommended (R); Further Study Recommended (RS); Not Recommended (NR); Recommended Mutually Exclusive (RME); Mutually Exclusive (ME); Recommended Non-Energy (RNE)"]
[" * Predominant Fuel Type Saved: Indicate the fuel type of the predominant reported MMBtu savings"]
["* MMBtu = 1,000,000 Btu"]
["* Energy savings must be presented as savings at the customer’s utility meter(s), and not at the individual building or tenant space.  "]
["* Percent of Savings to Total Fuel Consumption is auto-calculated from the data in the Energy Conversion tab. It is a comparison of the total electric & fuel savings to the total baseline energy consumption"]

{"sheet":"15% Withheld Payment","index":31,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":true,"merged":[[27,1,27,6],[29,3,29,4],[30,3,30,4],[14,2,14,4],[2,0,2,7],[3,0,3,7],[6,2,6,3],[8,2,8,4],[10,2,10,4],[12,2,12,6]]}
[]
[]
["Withheld Performance Incentive"]
["Payment Request"]
[]
[]
[null,"Date: "]
[]
[null,"FlexTech Consultant: ",{"$f":"IF('PROJECT DATA'!$B$3=\"\",\"\",'PROJECT DATA'!$B$3)","v":""}]
[]
[null,"FlexTech Consultant #: ",{"$f":"IF('PROJECT DATA'!$F$3=\"\",\"\",'PROJECT DATA'!$F$3)","v":""}]
[]
[null,"Project # and Name: ",{"$f":"IF('PROJECT DATA'!$B$2=\"\",\"\",CONCATENATE(\"AGG \",'PROJECT DATA'!$B$2,\" - \",'PROJECT DATA'!$B$3,\" - Portfolio #\",'PROJECT DATA'!$B$4))","v":""}]
[]
[null,"PO Number: ",{"$f":"IF('PROJECT DATA'!$F$2=\"\",\"\",'PROJECT DATA'!$F$2)","v":""}]
[]
[null,"Incentive Withheld (payable upon approval of final report)"]
[null,null,"1st Quarter Withheld:     ",{"$f":"'1st Quarter Payment'!D27","v":0}]
[null,null,"2nd Quarter Withheld:     ",{"$f":"'2nd Quarter Payment'!D28","v":0}]
[null,null,"3rd Quarter Withheld:     ",{"$f":"'3rd Quarter Payment'!D28","v":0}]
[null,null,"4th Quarter Withheld:     ",{"$f":"'4th Quarter Payment'!D28","v":0}]
[]
[null,null,"Invoice Amount: ",{"$f":"SUM(D18:D21)","v":0}]
[]
[]
[]
[null,"  NYSERDA Certification"]
[null,"I certify that I have reviewed this invoice and also certify, to the best of my knowldege, that the invoice and related documentation represent reasonable and appropriate costs for work performed in accordance with the contract or porgram requirements and recomment payment of the invoice. "]
[]
[null,"  NYSERDA Approval","Date of Approval: "]
[null,null,"Approved By: "]

{"sheet":"References","index":32,"n_rows":25,"n_cols":2,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
["Measure Status"]
["I","Implemented"]
["R","Recommended"]
["RS","Further Study Recommended"]
["NR","Not Recommended"]
["RME","Recommeded Mutually Exclusive"]
["ME","Mutually Exclusive to Recommended Option"]
["RNE","Recommended Non-Energy"]
[]
["Fuel Saved"]
["Elec","Electric"]
["NGas","Natural Gas"]
["Oil2","#2 Oil"]
["Oil4","#4 Oil"]
["Oil6","#6 Oil"]
["Steam","District Steam"]
["LPG","Propane"]
["Coal","Coal"]
["Other","Other"]
[]
["Reporting Quarter"]
["Q1","1st Quarter"]
["Q2","2nd Quarter"]
["Q3","3rd Quarter"]
["Q4","4th Quarter"]