{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Gas Heat or Heat Pump","Resistive Electric Heat","Reference"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":2,"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":28,"n_cols":16,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Instructions"]
[null,1,"Select the appropriate worksheet based on development's primary heating source"]
[null,null,null,"Gas Heat/Heat Pump OR Resistive Electric Heat"]
[null,2,"Enter the Base Year (Cell E5)  found in the table on the Engineering Services Agreement Information Form"]
[null,3,"Enter the number of residential units per year: (Cells E6 to W13)"]
[null,null,null,"Electrical loads are based on Above Grade square feet (Column C)"]
[null,4,"Select from list any non-residential load types (Cells B15 to B19)"]
[null,null,null,"Typical Non-Residental Loads"]
[null,null,null,"Club House:  Approximately 40 kW"]
[null,null,null,"Average Church Building:  Approximately 75 kW"]
[null,null,null,"Large Church Building:  Approximately 150 kW"]
[null,null,null,"Elementary School:  Approximately 500 kW"]
[null,null,null,"Junior High School:  Approximately 1000 kW"]
[null,null,null,"High School:  Approximately 1500 kW"]
[null,null,null,"Light Commercial: Approximately 75 kW/Acre"]
[null,null,null,"Other:  User Specify kW"]
[null,5,"Enter electrical loads in kW and by year for identified non-residential loads in the development (Cells E15 to W19)"]
[null,null,null,"Recommended electrical loads by type are displayed in cells C15 to C19 following their selection in cells B15 to B19.  (Values in kW)"]
[null,6,"Enter any existing site loads (Cell E21)"]
[null,null,null,"May need to consult the Area Engineer for existing loads that will remain in a development."]
[null,7,"Copy Existing kW, New kW, and Total kW results to Engineering Services Agreement Load Information Form (Cells E21 to W23)"]
[]
[]
[null,"Notes"]
[null,"These worksheets are to be used for Primarily Residential Developments"]
[null,"These worksheets were developed from PacifiCorp Standards"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version 2016.7"]

{"sheet":"Gas Heat or Heat Pump","index":1,"n_rows":23,"n_cols":24,"rows_kept":23,"cut":false,"hidden":false,"merged":[[17,1,17,2],[18,1,18,2],[8,1,12,1],[5,1,7,1],[0,10,2,22],[13,1,13,3],[14,1,14,2],[15,1,15,2],[16,1,16,2]]}
[null,null,null,null,null,null,null,null,null,null,"Gas Heat or Heat Pump"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summer Peaking Area"]
[null,"Type","Size\nAbove \nGrade \nSQFT ","Estimated kW/Unit \nGas Heat or Heat Pump",2017,null,{"$f":"E5+1","v":2018},null,{"$f":"G5+1","v":2019},null,2020,null,2021,null,2022,null,2023,null,2024,null,2025,null,2026]
[null,"Multi-\nFamily \nHousing","<800",4.75,null,{"$f":"E6*$D6","v":0},null,{"$f":"G6*$D6","v":0},null,{"$f":"I6*$D6","v":0},null,{"$f":"K6*$D6","v":0},null,{"$f":"M6*$D6","v":0},null,{"$f":"O6*$D6","v":0},null,{"$f":"Q6*$D6","v":0},null,{"$f":"S6*$D6","v":0},null,{"$f":"U6*$D6","v":0},null,{"$f":"W6*$D6","v":0}]
[null,null,"801-1000",5.7,null,{"$f":"E7*$D7","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,"1001-1500",6.65,null,{"$f":"E8*$D8","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,"Single\nFamily\nResidential","<1300",7.6,null,{"$f":"E9*$D9","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,"1300-2000",9.5,null,{"$f":"E10*$D10","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,"2001-3500",13.3,null,{"$f":"E11*$D11","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,"3501-4500",16.149999999999999,null,{"$f":"E12*$D12","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,"4501-6000",20.9,null,{"$f":"E13*$D13","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,"Coincidence Factor",null,null,{"$f":"IF(SUM(E6:E13)>9, 0.7, IF(SUM(E6:E13)=9, 0.71, IF(SUM(E6:E13)=8,0.72, IF(SUM(E6:E13)=7,0.74, IF(SUM(E6:E13)=6, 0.76, IF(SUM(E6:E13)=5, 0.78, IF(SUM(E6:E13)=4,0.82,IF(SUM(E6:E13)=3,0.86, IF(SUM(E6:E13)=2,0.9, IF(SUM(E6:E13)=1,1,0))))))))))","v":0},null,{"$f":"IF(SUM(G6:G13)>9, 0.7, IF(SUM(G6:G13)=9, 0.71, IF(SUM(G6:G13)=8,0.72, IF(SUM(G6:G13)=7,0.74, IF(SUM(G6:G13)=6, 0.76, IF(SUM(G6:G13)=5, 0.78, IF(SUM(G6:G13)=4,0.82,IF(SUM(G6:G13)=3,0.86, IF(SUM(G6:G13)=2,0.9, IF(SUM(G6:G13)=1,1,0))))))))))","v":0},null,{"$f":"IF(SUM(I6:I13)>9, 0.7, IF(SUM(I6:I13)=9, 0.71, IF(SUM(I6:I13)=8,0.72, IF(SUM(I6:I13)=7,0.74, IF(SUM(I6:I13)=6, 0.76, IF(SUM(I6:I13)=5, 0.78, IF(SUM(I6:I13)=4,0.82,IF(SUM(I6:I13)=3,0.86, IF(SUM(I6:I13)=2,0.9, IF(SUM(I6:I13)=1,1,0))))))))))","v":0},null,{"$f":"IF(SUM(K6:K13)>9, 0.7, IF(SUM(K6:K13)=9, 0.71, IF(SUM(K6:K13)=8,0.72, IF(SUM(K6:K13)=7,0.74, IF(SUM(K6:K13)=6, 0.76, IF(SUM(K6:K13)=5, 0.78, IF(SUM(K6:K13)=4,0.82,IF(SUM(K6:K13)=3,0.86, IF(SUM(K6:K13)=2,0.9, IF(SUM(K6:K13)=1,1,0))))))))))","v":0},null,{"$f":"IF(SUM(M6:M13)>9, 0.7, IF(SUM(M6:M13)=9, 0.71, IF(SUM(M6:M13)=8,0.72, IF(SUM(M6:M13)=7,0.74, IF(SUM(M6:M13)=6, 0.76, IF(SUM(M6:M13)=5, 0.78, IF(SUM(M6:M13)=4,0.82,IF(SUM(M6:M13)=3,0.86, IF(SUM(M6:M13)=2,0.9, IF(SUM(M6:M13)=1,1,0))))))))))","v":0},null,{"$f":"IF(SUM(O6:O13)>9, 0.7, IF(SUM(O6:O13)=9, 0.71, IF(SUM(O6:O13)=8,0.72, IF(SUM(O6:O13)=7,0.74, IF(SUM(O6:O13)=6, 0.76, IF(SUM(O6:O13)=5, 0.78, IF(SUM(O6:O13)=4,0.82,IF(SUM(O6:O13)=3,0.86, IF(SUM(O6:O13)=2,0.9, IF(SUM(O6:O13)=1,1,0))))))))))","v":0},null,{"$f":"IF(SUM(Q6:Q13)>9, 0.7, IF(SUM(Q6:Q13)=9, 0.71, IF(SUM(Q6:Q13)=8,0.72, IF(SUM(Q6:Q13)=7,0.74, IF(SUM(Q6:Q13)=6, 0.76, IF(SUM(Q6:Q13)=5, 0.78, IF(SUM(Q6:Q13)=4,0.82,IF(SUM(Q6:Q13)=3,0.86, IF(SUM(Q6:Q13)=2,0.9, IF(SUM(Q6:Q13)=1,1,0))))))))))","v":0},null,{"$f":"IF(SUM(S6:S13)>9, 0.7, IF(SUM(S6:S13)=9, 0.71, IF(SUM(S6:S13)=8,0.72, IF(SUM(S6:S13)=7,0.74, IF(SUM(S6:S13)=6, 0.76, IF(SUM(S6:S13)=5, 0.78, IF(SUM(S6:S13)=4,0.82,IF(SUM(S6:S13)=3,0.86, IF(SUM(S6:S13)=2,0.9, IF(SUM(S6:S13)=1,1,0))))))))))","v":0},null,{"$f":"IF(SUM(U6:U13)>9, 0.7, IF(SUM(U6:U13)=9, 0.71, IF(SUM(U6:U13)=8,0.72, IF(SUM(U6:U13)=7,0.74, IF(SUM(U6:U13)=6, 0.76, IF(SUM(U6:U13)=5, 0.78, IF(SUM(U6:U13)=4,0.82,IF(SUM(U6:U13)=3,0.86, IF(SUM(U6:U13)=2,0.9, IF(SUM(U6:U13)=1,1,0))))))))))","v":0},null,{"$f":"IF(SUM(W6:W13)>9, 0.7, IF(SUM(W6:W13)=9, 0.71, IF(SUM(W6:W13)=8,0.72, IF(SUM(W6:W13)=7,0.74, IF(SUM(W6:W13)=6, 0.76, IF(SUM(W6:W13)=5, 0.78, IF(SUM(W6:W13)=4,0.82,IF(SUM(W6:W13)=3,0.86, IF(SUM(W6:W13)=2,0.9, IF(SUM(W6:W13)=1,1,0))))))))))","v":0}]
[null,"Additional Load",null,{"$f":"VLOOKUP(B15,Reference!$A$2:$B$10,2,FALSE)","v":"kW"},null,{"$f":"E15","v":0},null,{"$f":"G15","v":0},null,{"$f":"I15","v":0},null,{"$f":"K15","v":0},null,{"$f":"M15","v":0},null,{"$f":"O15","v":0},null,{"$f":"Q15","v":0},null,{"$f":"S15","v":0},null,{"$f":"U15","v":0},null,{"$f":"W15","v":0}]
[null,"Additional Load",null,{"$f":"VLOOKUP(B16,Reference!$A$2:$B$10,2,FALSE)","v":"kW"},null,{"$f":"E16","v":0},null,{"$f":"G16","v":0},null,{"$f":"I16","v":0},null,{"$f":"K16","v":0},null,{"$f":"M16","v":0},null,{"$f":"O16","v":0},null,{"$f":"Q16","v":0},null,{"$f":"S16","v":0},null,{"$f":"U16","v":0},null,{"$f":"W16","v":0}]
[null,"Additional Load",null,{"$f":"VLOOKUP(B17,Reference!$A$2:$B$10,2,FALSE)","v":"kW"},null,{"$f":"E17","v":0},null,{"$f":"G17","v":0},null,{"$f":"I17","v":0},null,{"$f":"K17","v":0},null,{"$f":"M17","v":0},null,{"$f":"O17","v":0},null,{"$f":"Q17","v":0},null,{"$f":"S17","v":0},null,{"$f":"U17","v":0},null,{"$f":"W17","v":0}]
[null,"Additional Load",null,{"$f":"VLOOKUP(B18,Reference!$A$2:$B$10,2,FALSE)","v":"kW"},null,{"$f":"E18","v":0},null,{"$f":"G18","v":0},null,{"$f":"I18","v":0},null,{"$f":"K18","v":0},null,{"$f":"M18","v":0},null,{"$f":"O18","v":0},null,{"$f":"Q18","v":0},null,{"$f":"S18","v":0},null,{"$f":"U18","v":0},null,{"$f":"W18","v":0}]
[null,"Additional Load",null,{"$f":"VLOOKUP(B19,Reference!$A$2:$B$10,2,FALSE)","v":"kW"},null,{"$f":"E19","v":0},null,{"$f":"G19","v":0},null,{"$f":"I19","v":0},null,{"$f":"K19","v":0},null,{"$f":"M19","v":0},null,{"$f":"O19","v":0},null,{"$f":"Q19","v":0},null,{"$f":"S19","v":0},null,{"$f":"U19","v":0},null,{"$f":"W19","v":0}]
[null,null,null,null,{"$f":"E5","v":2017},{"$f":"F5","v":0},2018,0,2019,0,2020,0,2021,0,2022,0,2023,0,2024,0,2025,0,2026]
[null,null,null,"Existing kW",0]
[null,null,null,"New kW",{"$f":"SUM(F6:F13)*E14+SUM(F15:F19)","v":0},null,{"$f":"SUM(H6:H13)*G14+SUM(H15:H19)","v":0},null,{"$f":"SUM(J6:J13)*I14+SUM(J15:J19)","v":0},null,{"$f":"SUM(L6:L13)*K14+SUM(L15:L19)","v":0},null,{"$f":"SUM(N6:N13)*M14+SUM(N15:N19)","v":0},null,{"$f":"SUM(P6:P13)*O14+SUM(P15:P19)","v":0},null,{"$f":"SUM(R6:R13)*Q14+SUM(R15:R19)","v":0},null,{"$f":"SUM(T6:T13)*S14+SUM(T15:T19)","v":0},null,{"$f":"SUM(V6:V13)*U14+SUM(V15:V19)","v":0},null,{"$f":"SUM(X6:X13)*W14+SUM(X15:X19)","v":0}]
[null,null,null,"Total kW",{"$f":"E21+E22","v":0},null,{"$f":"G22+E23","v":0},null,{"$f":"I22+G23","v":0},null,{"$f":"K22+I23","v":0},null,{"$f":"M22+K23","v":0},null,{"$f":"O22+M23","v":0},null,{"$f":"Q22+O23","v":0},null,{"$f":"S22+Q23","v":0},null,{"$f":"U22+S23","v":0},null,{"$f":"W22+U23","v":0}]

{"sheet":"Resistive Electric Heat","index":2,"n_rows":23,"n_cols":24,"rows_kept":23,"cut":false,"hidden":false,"merged":[[17,1,17,2],[18,1,18,2],[0,10,2,22],[13,1,13,3],[5,1,7,1],[8,1,12,1],[14,1,14,2],[15,1,15,2],[16,1,16,2]]}
[null,null,null,null,null,null,null,null,null,null,"Resistive Electric Heat"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summer Peaking Area"]
[null,"Type","Size\nAbove \nGrade \nSQFT ","Estimated kW/Unit Resistive Electric Heat",2017,null,{"$f":"E5+1","v":2018},null,{"$f":"G5+1","v":2019},null,2020,null,2021,null,2022,null,2023,null,2024,null,2025,null,2026]
[null,"Multi-\nFamily \nHousing","<800",7.6,null,{"$f":"E6*$D6","v":0},null,{"$f":"G6*$D6","v":0},null,{"$f":"I6*$D6","v":0},null,{"$f":"K6*$D6","v":0},null,{"$f":"M6*$D6","v":0},null,{"$f":"O6*$D6","v":0},null,{"$f":"Q6*$D6","v":0},null,{"$f":"S6*$D6","v":0},null,{"$f":"U6*$D6","v":0},null,{"$f":"W6*$D6","v":0}]
[null,null,"801-1000",8.5500000000000007,null,{"$f":"E7*$D7","v":0},null,0,null,{"$f":"I7*$D7","v":0},null,{"$f":"K7*$D7","v":0},null,{"$f":"M7*$D7","v":0},null,{"$f":"O7*$D7","v":0},null,{"$f":"Q7*$D7","v":0},null,{"$f":"S7*$D7","v":0},null,{"$f":"U7*$D7","v":0},null,{"$f":"W7*$D7","v":0}]
[null,null,"1001-1500",10.45,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,"Single\nFamily\nResidential","<1300",12.35,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,"1300-2000",16.149999999999999,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,"2001-3500",19,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,"3501-4500",23.75,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,"4501-6000",28.5,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,"Coincidence Factor",null,null,{"$f":"IF(SUM(E6:E13)>9, 0.7, IF(SUM(E6:E13)=9, 0.71, IF(SUM(E6:E13)=8,0.72, IF(SUM(E6:E13)=7,0.74, IF(SUM(E6:E13)=6, 0.76, IF(SUM(E6:E13)=5, 0.78, IF(SUM(E6:E13)=4,0.82,IF(SUM(E6:E13)=3,0.86, IF(SUM(E6:E13)=2,0.9, IF(SUM(E6:E13)=1,1,0))))))))))","v":0},null,{"$f":"IF(SUM(G6:G13)>9, 0.7, IF(SUM(G6:G13)=9, 0.71, IF(SUM(G6:G13)=8,0.72, IF(SUM(G6:G13)=7,0.74, IF(SUM(G6:G13)=6, 0.76, IF(SUM(G6:G13)=5, 0.78, IF(SUM(G6:G13)=4,0.82,IF(SUM(G6:G13)=3,0.86, IF(SUM(G6:G13)=2,0.9, IF(SUM(G6:G13)=1,1,0))))))))))","v":0},null,{"$f":"IF(SUM(I6:I13)>9, 0.7, IF(SUM(I6:I13)=9, 0.71, IF(SUM(I6:I13)=8,0.72, IF(SUM(I6:I13)=7,0.74, IF(SUM(I6:I13)=6, 0.76, IF(SUM(I6:I13)=5, 0.78, IF(SUM(I6:I13)=4,0.82,IF(SUM(I6:I13)=3,0.86, IF(SUM(I6:I13)=2,0.9, IF(SUM(I6:I13)=1,1,0))))))))))","v":0},null,{"$f":"IF(SUM(K6:K13)>9, 0.7, IF(SUM(K6:K13)=9, 0.71, IF(SUM(K6:K13)=8,0.72, IF(SUM(K6:K13)=7,0.74, IF(SUM(K6:K13)=6, 0.76, IF(SUM(K6:K13)=5, 0.78, IF(SUM(K6:K13)=4,0.82,IF(SUM(K6:K13)=3,0.86, IF(SUM(K6:K13)=2,0.9, IF(SUM(K6:K13)=1,1,0))))))))))","v":0},null,{"$f":"IF(SUM(M6:M13)>9, 0.7, IF(SUM(M6:M13)=9, 0.71, IF(SUM(M6:M13)=8,0.72, IF(SUM(M6:M13)=7,0.74, IF(SUM(M6:M13)=6, 0.76, IF(SUM(M6:M13)=5, 0.78, IF(SUM(M6:M13)=4,0.82,IF(SUM(M6:M13)=3,0.86, IF(SUM(M6:M13)=2,0.9, IF(SUM(M6:M13)=1,1,0))))))))))","v":0},null,{"$f":"IF(SUM(O6:O13)>9, 0.7, IF(SUM(O6:O13)=9, 0.71, IF(SUM(O6:O13)=8,0.72, IF(SUM(O6:O13)=7,0.74, IF(SUM(O6:O13)=6, 0.76, IF(SUM(O6:O13)=5, 0.78, IF(SUM(O6:O13)=4,0.82,IF(SUM(O6:O13)=3,0.86, IF(SUM(O6:O13)=2,0.9, IF(SUM(O6:O13)=1,1,0))))))))))","v":0},null,{"$f":"IF(SUM(Q6:Q13)>9, 0.7, IF(SUM(Q6:Q13)=9, 0.71, IF(SUM(Q6:Q13)=8,0.72, IF(SUM(Q6:Q13)=7,0.74, IF(SUM(Q6:Q13)=6, 0.76, IF(SUM(Q6:Q13)=5, 0.78, IF(SUM(Q6:Q13)=4,0.82,IF(SUM(Q6:Q13)=3,0.86, IF(SUM(Q6:Q13)=2,0.9, IF(SUM(Q6:Q13)=1,1,0))))))))))","v":0},null,{"$f":"IF(SUM(S6:S13)>9, 0.7, IF(SUM(S6:S13)=9, 0.71, IF(SUM(S6:S13)=8,0.72, IF(SUM(S6:S13)=7,0.74, IF(SUM(S6:S13)=6, 0.76, IF(SUM(S6:S13)=5, 0.78, IF(SUM(S6:S13)=4,0.82,IF(SUM(S6:S13)=3,0.86, IF(SUM(S6:S13)=2,0.9, IF(SUM(S6:S13)=1,1,0))))))))))","v":0},null,{"$f":"IF(SUM(U6:U13)>9, 0.7, IF(SUM(U6:U13)=9, 0.71, IF(SUM(U6:U13)=8,0.72, IF(SUM(U6:U13)=7,0.74, IF(SUM(U6:U13)=6, 0.76, IF(SUM(U6:U13)=5, 0.78, IF(SUM(U6:U13)=4,0.82,IF(SUM(U6:U13)=3,0.86, IF(SUM(U6:U13)=2,0.9, IF(SUM(U6:U13)=1,1,0))))))))))","v":0},null,{"$f":"IF(SUM(W6:W13)>9, 0.7, IF(SUM(W6:W13)=9, 0.71, IF(SUM(W6:W13)=8,0.72, IF(SUM(W6:W13)=7,0.74, IF(SUM(W6:W13)=6, 0.76, IF(SUM(W6:W13)=5, 0.78, IF(SUM(W6:W13)=4,0.82,IF(SUM(W6:W13)=3,0.86, IF(SUM(W6:W13)=2,0.9, IF(SUM(W6:W13)=1,1,0))))))))))","v":0}]
[null,"Additional Load",null,{"$f":"VLOOKUP(B15,Reference!$A$2:$B$10,2,FALSE)","v":"kW"},null,{"$f":"E15","v":0},null,{"$f":"G15","v":0},null,{"$f":"I15","v":0},null,{"$f":"K15","v":0},null,{"$f":"M15","v":0},null,{"$f":"O15","v":0},null,{"$f":"Q15","v":0},null,{"$f":"S15","v":0},null,{"$f":"U15","v":0},null,{"$f":"W15","v":0}]
[null,"Additional Load",null,{"$f":"VLOOKUP(B16,Reference!$A$2:$B$10,2,FALSE)","v":"kW"},null,{"$f":"E16","v":0},null,{"$f":"G16","v":0},null,{"$f":"I16","v":0},null,{"$f":"K16","v":0},null,{"$f":"M16","v":0},null,{"$f":"O16","v":0},null,{"$f":"Q16","v":0},null,{"$f":"S16","v":0},null,{"$f":"U16","v":0},null,{"$f":"W16","v":0}]
[null,"Additional Load",null,{"$f":"VLOOKUP(B17,Reference!$A$2:$B$10,2,FALSE)","v":"kW"},null,{"$f":"E17","v":0},null,{"$f":"G17","v":0},null,{"$f":"I17","v":0},null,{"$f":"K17","v":0},null,{"$f":"M17","v":0},null,{"$f":"O17","v":0},null,{"$f":"Q17","v":0},null,{"$f":"S17","v":0},null,{"$f":"U17","v":0},null,{"$f":"W17","v":0}]
[null,"Additional Load",null,{"$f":"VLOOKUP(B18,Reference!$A$2:$B$10,2,FALSE)","v":"kW"},null,{"$f":"E18","v":0},null,{"$f":"G18","v":0},null,{"$f":"I18","v":0},null,{"$f":"K18","v":0},null,{"$f":"M18","v":0},null,{"$f":"O18","v":0},null,{"$f":"Q18","v":0},null,{"$f":"S18","v":0},null,{"$f":"U18","v":0},null,{"$f":"W18","v":0}]
[null,"Additional Load",null,{"$f":"VLOOKUP(B19,Reference!$A$2:$B$10,2,FALSE)","v":"kW"},null,{"$f":"E19","v":0},null,{"$f":"G19","v":0},null,{"$f":"I19","v":0},null,{"$f":"K19","v":0},null,{"$f":"M19","v":0},null,{"$f":"O19","v":0},null,{"$f":"Q19","v":0},null,{"$f":"S19","v":0},null,{"$f":"U19","v":0},null,{"$f":"W19","v":0}]
[null,null,null,null,{"$f":"E5","v":2017},{"$f":"F5","v":0},2018,0,2019,0,2020,0,2021,0,2022,0,2023,0,2024,0,2025,0,2026]
[null,null,null,"Existing kW",0]
[null,null,null,"New kW",{"$f":"SUM(F6:F13)*E14+SUM(F15:F19)","v":0},null,{"$f":"SUM(H6:H13)*G14+SUM(H15:H19)","v":0},null,{"$f":"SUM(J6:J13)*I14+SUM(J15:J19)","v":0},null,{"$f":"SUM(L6:L13)*K14+SUM(L15:L19)","v":0},null,{"$f":"SUM(N6:N13)*M14+SUM(N15:N19)","v":0},null,{"$f":"SUM(P6:P13)*O14+SUM(P15:P19)","v":0},null,{"$f":"SUM(R6:R13)*Q14+SUM(R15:R19)","v":0},null,{"$f":"SUM(T6:T13)*S14+SUM(T15:T19)","v":0},null,{"$f":"SUM(V6:V13)*U14+SUM(V15:V19)","v":0},null,{"$f":"SUM(X6:X13)*W14+SUM(X15:X19)","v":0}]
[null,null,null,"Total kW",{"$f":"E21+E22","v":0},null,{"$f":"G22+E23","v":0},null,{"$f":"I22+G23","v":0},null,{"$f":"K22+I23","v":0},null,{"$f":"M22+K23","v":0},null,{"$f":"O22+M23","v":0},null,{"$f":"Q22+O23","v":0},null,{"$f":"S22+Q23","v":0},null,{"$f":"U22+S23","v":0},null,{"$f":"W22+U23","v":0}]

{"sheet":"Reference","index":3,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[]
["Additional Load","kW"]
["Club House",40]
["Church Building (Average)",75]
["Church Building (Large)",150]
["Elementary School",500]
["Junior High School",1000]
["High School",1500]
["Light Commercial (per Acre)",75]
["Other ","kW"]