{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["2019 Base Year (Reference)","i. 2020 Base Year","ii. 2021 Base Year"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":0,"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":"2019 Base Year (Reference)","index":0,"n_rows":70,"n_cols":23,"rows_kept":70,"cut":false,"hidden":false,"merged":[[51,0,51,1],[25,0,25,1],[26,0,26,1],[30,0,30,1],[34,0,34,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[23,0,23,1],[24,0,24,1],[0,0,0,5],[1,0,1,4],[2,0,2,4],[3,0,3,4],[13,0,13,1],[14,0,14,1]]}
[]
[]
[]
["EB-2021-XXXX"]
["Sheet I8 Demand Data Worksheet  -  "]
[]
[]
[]
[]
[]
[]
[]
[]
["CP TEST RESULTS",null,"-"]
["NCP TEST RESULTS",null,"-"]
[]
["Co-incident Peak",null,"Indicator"]
["1  CP",null,"CP 1"]
["4 CP",null,"CP 4"]
["12 CP",null,"CP 12"]
[]
["4 NCP",null,"NCP 4"]
["12 NCP",null,"NCP 12"]
["Non-co-incident Peak",null,"Indicator"]
["1 NCP",null,"NCP 1 "]
["4 NCP",null,"NCP 4"]
["12 NCP",null,"NCP 12"]
[]
[]
[null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Customer Classes",null,"Total","Residential","GS <50","GS>50-Regular","GS> 50-TOU","GS >50-Intermediate","Large Use >5MW","Street Light","Sentinel","Unmetered Scattered Load","Embedded Distributor","Back-up/Standby Power","Rate Class 1","Rate class 2","Rate class 3","Rate class 4","Rate class 5","Rate class 6","Rate class 7","Rate class 8","Rate class 9"]
[]
[]
[null,null,"CP\nSanity Check",{"$f":"IF(MAX(D38,D39,D40)>D55,\"Check 1 CP\",IF(MAX(D43,D44,D45)>D61,\"Check 4 CP\",IF(MAX(D48,D49,D50)>D67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(E38,E39,E40)>E55,\"Check 1 CP\",IF(MAX(E43,E44,E45)>E61,\"Check 4 CP\",IF(MAX(E48,E49,E50)>E67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(F38,F39,F40)>F55,\"Check 1 CP\",IF(MAX(F43,F44,F45)>F61,\"Check 4 CP\",IF(MAX(F48,F49,F50)>F67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(G38,G39,G40)>G55,\"Check 1 CP\",IF(MAX(G43,G44,G45)>G61,\"Check 4 CP\",IF(MAX(G48,G49,G50)>G67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(H38,H39,H40)>H55,\"Check 1 CP\",IF(MAX(H43,H44,H45)>H61,\"Check 4 CP\",IF(MAX(H48,H49,H50)>H67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(I38,I39,I40)>I55,\"Check 1 CP\",IF(MAX(I43,I44,I45)>I61,\"Check 4 CP\",IF(MAX(I48,I49,I50)>I67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(J38,J39,J40)>J55,\"Check 1 CP\",IF(MAX(J43,J44,J45)>J61,\"Check 4 CP\",IF(MAX(J48,J49,J50)>J67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(K38,K39,K40)>K55,\"Check 1 CP\",IF(MAX(K43,K44,K45)>K61,\"Check 4 CP\",IF(MAX(K48,K49,K50)>K67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(L38,L39,L40)>L55,\"Check 1 CP\",IF(MAX(L43,L44,L45)>L61,\"Check 4 CP\",IF(MAX(L48,L49,L50)>L67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(M38,M39,M40)>M55,\"Check 1 CP\",IF(MAX(M43,M44,M45)>M61,\"Check 4 CP\",IF(MAX(M48,M49,M50)>M67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(N38,N39,N40)>N55,\"Check 1 CP\",IF(MAX(N43,N44,N45)>N61,\"Check 4 CP\",IF(MAX(N48,N49,N50)>N67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(O38,O39,O40)>O55,\"Check 1 CP\",IF(MAX(O43,O44,O45)>O61,\"Check 4 CP\",IF(MAX(O48,O49,O50)>O67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(P38,P39,P40)>P55,\"Check 1 CP\",IF(MAX(P43,P44,P45)>P61,\"Check 4 CP\",IF(MAX(P48,P49,P50)>P67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(Q38,Q39,Q40)>Q55,\"Check 1 CP\",IF(MAX(Q43,Q44,Q45)>Q61,\"Check 4 CP\",IF(MAX(Q48,Q49,Q50)>Q67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(R38,R39,R40)>R55,\"Check 1 CP\",IF(MAX(R43,R44,R45)>R61,\"Check 4 CP\",IF(MAX(R48,R49,R50)>R67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(S38,S39,S40)>S55,\"Check 1 CP\",IF(MAX(S43,S44,S45)>S61,\"Check 4 CP\",IF(MAX(S48,S49,S50)>S67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(T38,T39,T40)>T55,\"Check 1 CP\",IF(MAX(T43,T44,T45)>T61,\"Check 4 CP\",IF(MAX(T48,T49,T50)>T67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(U38,U39,U40)>U55,\"Check 1 CP\",IF(MAX(U43,U44,U45)>U61,\"Check 4 CP\",IF(MAX(U48,U49,U50)>U67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(V38,V39,V40)>V55,\"Check 1 CP\",IF(MAX(V43,V44,V45)>V61,\"Check 4 CP\",IF(MAX(V48,V49,V50)>V67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(W38,W39,W40)>W55,\"Check 1 CP\",IF(MAX(W43,W44,W45)>W61,\"Check 4 CP\",IF(MAX(W48,W49,W50)>W67,\"Check 12 CP\",\"Pass\")))","v":"Pass"}]
["CO-INCIDENT PEAK"]
[]
["1 CP"]
["Transformation CP","TCP1",{"$f":"SUM(D38:W38)","v":54279.562438555084},28507.264103405636,8339.4512089078144,17114.348790019401,null,null,null,275.45464157768208,null,43.043694644556865]
["Bulk Delivery CP","BCP1",{"$f":"SUM(D39:W39)","v":54279.562438555084},{"$f":"D38","v":28507.264103405636},{"$f":"E38","v":8339.4512089078144},{"$f":"F38","v":17114.348790019401},{"$f":"G38","v":0},{"$f":"H38","v":0},{"$f":"I38","v":0},{"$f":"J38","v":275.45464157768208},{"$f":"K38","v":0},{"$f":"L38","v":43.043694644556865}]
["Total Sytem CP ","DCP1",{"$f":"SUM(D40:W40)","v":54279.562438555084},{"$f":"D39","v":28507.264103405636},{"$f":"E39","v":8339.4512089078144},{"$f":"F39","v":17114.348790019401},{"$f":"G39","v":0},{"$f":"H39","v":0},{"$f":"I39","v":0},{"$f":"J39","v":275.45464157768208},{"$f":"K39","v":0},{"$f":"L39","v":43.043694644556865}]
[]
["4 CP"]
["Transformation CP","TCP4",{"$f":"SUM(D43:W43)","v":213217.57218187678},105596.16273679851,33850.927246225503,73039.37784021144,null,null,null,550.90928315536416,null,180.19507548595746]
["Bulk Delivery CP","BCP4",{"$f":"SUM(D44:W44)","v":213217.57218187678},{"$f":"D43","v":105596.16273679851},{"$f":"E43","v":33850.927246225503},{"$f":"F43","v":73039.37784021144},{"$f":"G43","v":0},{"$f":"H43","v":0},{"$f":"I43","v":0},{"$f":"J43","v":550.90928315536416},{"$f":"K43","v":0},{"$f":"L43","v":180.19507548595746}]
["Total Sytem CP ","DCP4",{"$f":"SUM(D45:W45)","v":213217.57218187678},{"$f":"D44","v":105596.16273679851},{"$f":"E44","v":33850.927246225503},{"$f":"F44","v":73039.37784021144},{"$f":"G44","v":0},{"$f":"H44","v":0},{"$f":"I44","v":0},{"$f":"J44","v":550.90928315536416},{"$f":"K44","v":0},{"$f":"L44","v":180.19507548595746}]
[]
["12 CP"]
["Transformation CP","TCP12",{"$f":"SUM(D48:W48)","v":584045.14938967535},271802.19574495847,88636.349011986676,221410.81717794933,null,null,null,1652.7278494660927,null,543.05960531469725]
["Bulk Delivery CP","BCP12",{"$f":"SUM(D49:W49)","v":584045.14938967535},{"$f":"D48","v":271802.19574495847},{"$f":"E48","v":88636.349011986676},{"$f":"F48","v":221410.81717794933},{"$f":"G48","v":0},{"$f":"H48","v":0},{"$f":"I48","v":0},{"$f":"J48","v":1652.7278494660927},{"$f":"K48","v":0},{"$f":"L48","v":543.05960531469725}]
["Total Sytem CP ","DCP12",{"$f":"SUM(D50:W50)","v":584045.14938967535},{"$f":"D49","v":271802.19574495847},{"$f":"E49","v":88636.349011986676},{"$f":"F49","v":221410.81717794933},{"$f":"G49","v":0},{"$f":"H49","v":0},{"$f":"I49","v":0},{"$f":"J49","v":1652.7278494660927},{"$f":"K49","v":0},{"$f":"L49","v":543.05960531469725}]
[]
["NON CO_INCIDENT PEAK"]
[null,null,"NCP\nSanity Check",{"$f":"IF(OR(D55*4<D61,D56*4<D62,D57*4<D63,D58*4<D64),IF(OR(D55*12<D67,D56*12<D68,D57*12<D69,D58*12<D70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(D55*12<D67,D56*12<D68,D57*12<D69,D58*12<D70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(E55*4<E61,E56*4<E62,E57*4<E63,E58*4<E64),IF(OR(E55*12<E67,E56*12<E68,E57*12<E69,E58*12<E70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(E55*12<E67,E56*12<E68,E57*12<E69,E58*12<E70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(F55*4<F61,F56*4<F62,F57*4<F63,F58*4<F64),IF(OR(F55*12<F67,F56*12<F68,F57*12<F69,F58*12<F70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(F55*12<F67,F56*12<F68,F57*12<F69,F58*12<F70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(G55*4<G61,G56*4<G62,G57*4<G63,G58*4<G64),IF(OR(G55*12<G67,G56*12<G68,G57*12<G69,G58*12<G70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(G55*12<G67,G56*12<G68,G57*12<G69,G58*12<G70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(H55*4<H61,H56*4<H62,H57*4<H63,H58*4<H64),IF(OR(H55*12<H67,H56*12<H68,H57*12<H69,H58*12<H70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(H55*12<H67,H56*12<H68,H57*12<H69,H58*12<H70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(I55*4<I61,I56*4<I62,I57*4<I63,I58*4<I64),IF(OR(I55*12<I67,I56*12<I68,I57*12<I69,I58*12<I70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(I55*12<I67,I56*12<I68,I57*12<I69,I58*12<I70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(J55*4<J61,J56*4<J62,J57*4<J63,J58*4<J64),IF(OR(J55*12<J67,J56*12<J68,J57*12<J69,J58*12<J70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(J55*12<J67,J56*12<J68,J57*12<J69,J58*12<J70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(K55*4<K61,K56*4<K62,K57*4<K63,K58*4<K64),IF(OR(K55*12<K67,K56*12<K68,K57*12<K69,K58*12<K70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(K55*12<K67,K56*12<K68,K57*12<K69,K58*12<K70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(L55*4<L61,L56*4<L62,L57*4<L63,L58*4<L64),IF(OR(L55*12<L67,L56*12<L68,L57*12<L69,L58*12<L70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(L55*12<L67,L56*12<L68,L57*12<L69,L58*12<L70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(M55*4<M61,M56*4<M62,M57*4<M63,M58*4<M64),IF(OR(M55*12<M67,M56*12<M68,M57*12<M69,M58*12<M70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(M55*12<M67,M56*12<M68,M57*12<M69,M58*12<M70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(N55*4<N61,N56*4<N62,N57*4<N63,N58*4<N64),IF(OR(N55*12<N67,N56*12<N68,N57*12<N69,N58*12<N70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(N55*12<N67,N56*12<N68,N57*12<N69,N58*12<N70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(O55*4<O61,O56*4<O62,O57*4<O63,O58*4<O64),IF(OR(O55*12<O67,O56*12<O68,O57*12<O69,O58*12<O70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(O55*12<O67,O56*12<O68,O57*12<O69,O58*12<O70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(P55*4<P61,P56*4<P62,P57*4<P63,P58*4<P64),IF(OR(P55*12<P67,P56*12<P68,P57*12<P69,P58*12<P70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(P55*12<P67,P56*12<P68,P57*12<P69,P58*12<P70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(Q55*4<Q61,Q56*4<Q62,Q57*4<Q63,Q58*4<Q64),IF(OR(Q55*12<Q67,Q56*12<Q68,Q57*12<Q69,Q58*12<Q70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(Q55*12<Q67,Q56*12<Q68,Q57*12<Q69,Q58*12<Q70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(R55*4<R61,R56*4<R62,R57*4<R63,R58*4<R64),IF(OR(R55*12<R67,R56*12<R68,R57*12<R69,R58*12<R70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(R55*12<R67,R56*12<R68,R57*12<R69,R58*12<R70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(S55*4<S61,S56*4<S62,S57*4<S63,S58*4<S64),IF(OR(S55*12<S67,S56*12<S68,S57*12<S69,S58*12<S70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(S55*12<S67,S56*12<S68,S57*12<S69,S58*12<S70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(T55*4<T61,T56*4<T62,T57*4<T63,T58*4<T64),IF(OR(T55*12<T67,T56*12<T68,T57*12<T69,T58*12<T70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(T55*12<T67,T56*12<T68,T57*12<T69,T58*12<T70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(U55*4<U61,U56*4<U62,U57*4<U63,U58*4<U64),IF(OR(U55*12<U67,U56*12<U68,U57*12<U69,U58*12<U70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(U55*12<U67,U56*12<U68,U57*12<U69,U58*12<U70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(V55*4<V61,V56*4<V62,V57*4<V63,V58*4<V64),IF(OR(V55*12<V67,V56*12<V68,V57*12<V69,V58*12<V70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(V55*12<V67,V56*12<V68,V57*12<V69,V58*12<V70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(W55*4<W61,W56*4<W62,W57*4<W63,W58*4<W64),IF(OR(W55*12<W67,W56*12<W68,W57*12<W69,W58*12<W70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(W55*12<W67,W56*12<W68,W57*12<W69,W58*12<W70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"}]
["1 NCP"]
["Classification NCP from \n Load Data Provider","DNCP1",{"$f":"SUM(D55:W55)","v":59753.655948054198},28507.264103405636,9331.3735569023302,21591.96793595768,null,null,null,275.45464157768208,null,47.595710210866827]
["Primary NCP","PNCP1",{"$f":"SUM(D56:W56)","v":59753.655948054198},{"$f":"D55","v":28507.264103405636},{"$f":"E55","v":9331.3735569023302},{"$f":"F55","v":21591.96793595768},{"$f":"G55","v":0},{"$f":"H55","v":0},{"$f":"I55","v":0},{"$f":"J55","v":275.45464157768208},{"$f":"K55","v":0},{"$f":"L55","v":47.595710210866827}]
[" Line Transformer NCP","LTNCP1",{"$f":"SUM(D57:W57)","v":46941.636689672734},{"$f":"D56","v":28507.264103405636},{"$f":"E56","v":9331.3735569023302},8779.9486775762234,{"$f":"G56","v":0},{"$f":"H56","v":0},{"$f":"I56","v":0},{"$f":"J56","v":275.45464157768208},{"$f":"K56","v":0},{"$f":"L56","v":47.595710210866827}]
["Secondary NCP","SNCP1",{"$f":"SUM(D58:W58)","v":46941.636689672734},{"$f":"D57","v":28507.264103405636},{"$f":"E57","v":9331.3735569023302},{"$f":"F57","v":8779.9486775762234},{"$f":"G57","v":0},{"$f":"H57","v":0},{"$f":"I57","v":0},{"$f":"J57","v":275.45464157768208},{"$f":"K57","v":0},{"$f":"L57","v":47.595710210866827}]
[]
["4 NCP"]
["Classification NCP from \n Load Data Provider","DNCP4",{"$f":"SUM(D61:W61)","v":227633.2839370248},107784.22780631977,34960.686074177065,83598.373516112159,null,null,null,1101.8185663107283,null,188.17797410507492]
["Primary NCP","PNCP4",{"$f":"SUM(D62:W62)","v":227633.2839370248},{"$f":"D61","v":107784.22780631977},{"$f":"E61","v":34960.686074177065},{"$f":"F61","v":83598.373516112159},{"$f":"G61","v":0},{"$f":"H61","v":0},{"$f":"I61","v":0},{"$f":"J61","v":1101.8185663107283},{"$f":"K61","v":0},{"$f":"L61","v":188.17797410507492}]
[" Line Transformer NCP","LTNCP4",{"$f":"SUM(D63:W63)","v":178028.54320034912},{"$f":"D62","v":107784.22780631977},{"$f":"E62","v":34960.686074177065},33993.63277943647,{"$f":"G62","v":0},{"$f":"H62","v":0},{"$f":"I62","v":0},{"$f":"J62","v":1101.8185663107283},{"$f":"K62","v":0},{"$f":"L62","v":188.17797410507492}]
["Secondary NCP","SNCP4",{"$f":"SUM(D64:W64)","v":178028.54320034912},{"$f":"D63","v":107784.22780631977},{"$f":"E63","v":34960.686074177065},{"$f":"F63","v":33993.63277943647},{"$f":"G63","v":0},{"$f":"H63","v":0},{"$f":"I63","v":0},{"$f":"J63","v":1101.8185663107283},{"$f":"K63","v":0},{"$f":"L63","v":188.17797410507492}]
[]
["12 NCP"]
["Classification NCP from \n Load Data Provider","DNCP12",{"$f":"SUM(D67:W67)","v":620957.993162898},283805.05920792546,92882.990692050575,240421.42805867508,null,null,null,3305.4555989321857,null,543.05960531469725]
["Primary NCP","PNCP12",{"$f":"SUM(D68:W68)","v":620957.993162898},{"$f":"D67","v":283805.05920792546},{"$f":"E67","v":92882.990692050575},{"$f":"F67","v":240421.42805867508},{"$f":"G67","v":0},{"$f":"H67","v":0},{"$f":"I67","v":0},{"$f":"J67","v":3305.4555989321857},{"$f":"K67","v":0},{"$f":"L67","v":543.05960531469725}]
[" Line Transformer NCP","LTNCP12",{"$f":"SUM(D69:W69)","v":478299.20561970054},{"$f":"D68","v":283805.05920792546},{"$f":"E68","v":92882.990692050575},97762.640515477688,{"$f":"G68","v":0},{"$f":"H68","v":0},{"$f":"I68","v":0},{"$f":"J68","v":3305.4555989321857},{"$f":"K68","v":0},{"$f":"L68","v":543.05960531469725}]
["Secondary NCP","SNCP12",{"$f":"SUM(D70:W70)","v":478299.20561970054},{"$f":"D69","v":283805.05920792546},{"$f":"E69","v":92882.990692050575},{"$f":"F69","v":97762.640515477688},{"$f":"G69","v":0},{"$f":"H69","v":0},{"$f":"I69","v":0},{"$f":"J69","v":3305.4555989321857},{"$f":"K69","v":0},{"$f":"L69","v":543.05960531469725}]

{"sheet":"i. 2020 Base Year","index":1,"n_rows":70,"n_cols":23,"rows_kept":70,"cut":false,"hidden":false,"merged":[[51,0,51,1],[25,0,25,1],[26,0,26,1],[30,0,30,1],[34,0,34,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[23,0,23,1],[24,0,24,1],[0,0,0,5],[1,0,1,4],[2,0,2,4],[3,0,3,4],[13,0,13,1],[14,0,14,1]]}
[]
[]
[]
["EB-2021-XXXX"]
["Sheet I8 Demand Data Worksheet  -  "]
[]
[]
[]
[]
[]
[]
[]
[]
["CP TEST RESULTS",null,"-"]
["NCP TEST RESULTS",null,"-"]
[]
["Co-incident Peak",null,"Indicator"]
["1  CP",null,"CP 1"]
["4 CP",null,"CP 4"]
["12 CP",null,"CP 12"]
[]
["4 NCP",null,"NCP 4"]
["12 NCP",null,"NCP 12"]
["Non-co-incident Peak",null,"Indicator"]
["1 NCP",null,"NCP 1 "]
["4 NCP",null,"NCP 4"]
["12 NCP",null,"NCP 12"]
[]
[]
[null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Customer Classes",null,"Total","Residential","GS <50","GS>50-Regular","GS> 50-TOU","GS >50-Intermediate","Large Use >5MW","Street Light","Sentinel","Unmetered Scattered Load","Embedded Distributor","Back-up/Standby Power","Rate Class 1","Rate class 2","Rate class 3","Rate class 4","Rate class 5","Rate class 6","Rate class 7","Rate class 8","Rate class 9"]
[]
[]
[null,null,"CP\nSanity Check",{"$f":"IF(MAX(D38,D39,D40)>D55,\"Check 1 CP\",IF(MAX(D43,D44,D45)>D61,\"Check 4 CP\",IF(MAX(D48,D49,D50)>D67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(E38,E39,E40)>E55,\"Check 1 CP\",IF(MAX(E43,E44,E45)>E61,\"Check 4 CP\",IF(MAX(E48,E49,E50)>E67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(F38,F39,F40)>F55,\"Check 1 CP\",IF(MAX(F43,F44,F45)>F61,\"Check 4 CP\",IF(MAX(F48,F49,F50)>F67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(G38,G39,G40)>G55,\"Check 1 CP\",IF(MAX(G43,G44,G45)>G61,\"Check 4 CP\",IF(MAX(G48,G49,G50)>G67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(H38,H39,H40)>H55,\"Check 1 CP\",IF(MAX(H43,H44,H45)>H61,\"Check 4 CP\",IF(MAX(H48,H49,H50)>H67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(I38,I39,I40)>I55,\"Check 1 CP\",IF(MAX(I43,I44,I45)>I61,\"Check 4 CP\",IF(MAX(I48,I49,I50)>I67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(J38,J39,J40)>J55,\"Check 1 CP\",IF(MAX(J43,J44,J45)>J61,\"Check 4 CP\",IF(MAX(J48,J49,J50)>J67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(K38,K39,K40)>K55,\"Check 1 CP\",IF(MAX(K43,K44,K45)>K61,\"Check 4 CP\",IF(MAX(K48,K49,K50)>K67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(L38,L39,L40)>L55,\"Check 1 CP\",IF(MAX(L43,L44,L45)>L61,\"Check 4 CP\",IF(MAX(L48,L49,L50)>L67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(M38,M39,M40)>M55,\"Check 1 CP\",IF(MAX(M43,M44,M45)>M61,\"Check 4 CP\",IF(MAX(M48,M49,M50)>M67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(N38,N39,N40)>N55,\"Check 1 CP\",IF(MAX(N43,N44,N45)>N61,\"Check 4 CP\",IF(MAX(N48,N49,N50)>N67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(O38,O39,O40)>O55,\"Check 1 CP\",IF(MAX(O43,O44,O45)>O61,\"Check 4 CP\",IF(MAX(O48,O49,O50)>O67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(P38,P39,P40)>P55,\"Check 1 CP\",IF(MAX(P43,P44,P45)>P61,\"Check 4 CP\",IF(MAX(P48,P49,P50)>P67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(Q38,Q39,Q40)>Q55,\"Check 1 CP\",IF(MAX(Q43,Q44,Q45)>Q61,\"Check 4 CP\",IF(MAX(Q48,Q49,Q50)>Q67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(R38,R39,R40)>R55,\"Check 1 CP\",IF(MAX(R43,R44,R45)>R61,\"Check 4 CP\",IF(MAX(R48,R49,R50)>R67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(S38,S39,S40)>S55,\"Check 1 CP\",IF(MAX(S43,S44,S45)>S61,\"Check 4 CP\",IF(MAX(S48,S49,S50)>S67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(T38,T39,T40)>T55,\"Check 1 CP\",IF(MAX(T43,T44,T45)>T61,\"Check 4 CP\",IF(MAX(T48,T49,T50)>T67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(U38,U39,U40)>U55,\"Check 1 CP\",IF(MAX(U43,U44,U45)>U61,\"Check 4 CP\",IF(MAX(U48,U49,U50)>U67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(V38,V39,V40)>V55,\"Check 1 CP\",IF(MAX(V43,V44,V45)>V61,\"Check 4 CP\",IF(MAX(V48,V49,V50)>V67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(W38,W39,W40)>W55,\"Check 1 CP\",IF(MAX(W43,W44,W45)>W61,\"Check 4 CP\",IF(MAX(W48,W49,W50)>W67,\"Check 12 CP\",\"Pass\")))","v":"Pass"}]
["CO-INCIDENT PEAK"]
[]
["1 CP"]
["Transformation CP","TCP1",{"$f":"SUM(D38:W38)","v":54715.005777888284},26289.139867727066,8026.1850117071544,20355.25059224902,null,null,null,0,null,44.43030620503913]
["Bulk Delivery CP","BCP1",{"$f":"SUM(D39:W39)","v":54715.005777888284},{"$f":"D38","v":26289.139867727066},{"$f":"E38","v":8026.1850117071544},{"$f":"F38","v":20355.25059224902},{"$f":"G38","v":0},{"$f":"H38","v":0},{"$f":"I38","v":0},{"$f":"J38","v":0},{"$f":"K38","v":0},{"$f":"L38","v":44.43030620503913}]
["Total Sytem CP ","DCP1",{"$f":"SUM(D40:W40)","v":54715.005777888284},{"$f":"D39","v":26289.139867727066},{"$f":"E39","v":8026.1850117071544},{"$f":"F39","v":20355.25059224902},{"$f":"G39","v":0},{"$f":"H39","v":0},{"$f":"I39","v":0},{"$f":"J39","v":0},{"$f":"K39","v":0},{"$f":"L39","v":44.43030620503913}]
[]
["4 CP"]
["Transformation CP","TCP4",{"$f":"SUM(D43:W43)","v":216327.46288470109},102732.73168011774,33375.243143787076,79765.809427792745,null,null,null,274.62274914631234,null,179.05588385725025]
["Bulk Delivery CP","BCP4",{"$f":"SUM(D44:W44)","v":216327.46288470109},{"$f":"D43","v":102732.73168011774},{"$f":"E43","v":33375.243143787076},{"$f":"F43","v":79765.809427792745},{"$f":"G43","v":0},{"$f":"H43","v":0},{"$f":"I43","v":0},{"$f":"J43","v":274.62274914631234},{"$f":"K43","v":0},{"$f":"L43","v":179.05588385725025}]
["Total Sytem CP ","DCP4",{"$f":"SUM(D45:W45)","v":216327.46288470109},{"$f":"D44","v":102732.73168011774},{"$f":"E44","v":33375.243143787076},{"$f":"F44","v":79765.809427792745},{"$f":"G44","v":0},{"$f":"H44","v":0},{"$f":"I44","v":0},{"$f":"J44","v":274.62274914631234},{"$f":"K44","v":0},{"$f":"L44","v":179.05588385725025}]
[]
["12 CP"]
["Transformation CP","TCP12",{"$f":"SUM(D48:W48)","v":600516.02202378644},284245.08538430149,92520.599719890131,221561.06344249097,null,null,null,1647.7364948778741,null,541.53698222594824]
["Bulk Delivery CP","BCP12",{"$f":"SUM(D49:W49)","v":600516.02202378644},{"$f":"D48","v":284245.08538430149},{"$f":"E48","v":92520.599719890131},{"$f":"F48","v":221561.06344249097},{"$f":"G48","v":0},{"$f":"H48","v":0},{"$f":"I48","v":0},{"$f":"J48","v":1647.7364948778741},{"$f":"K48","v":0},{"$f":"L48","v":541.53698222594824}]
["Total Sytem CP ","DCP12",{"$f":"SUM(D50:W50)","v":600516.02202378644},{"$f":"D49","v":284245.08538430149},{"$f":"E49","v":92520.599719890131},{"$f":"F49","v":221561.06344249097},{"$f":"G49","v":0},{"$f":"H49","v":0},{"$f":"I49","v":0},{"$f":"J49","v":1647.7364948778741},{"$f":"K49","v":0},{"$f":"L49","v":541.53698222594824}]
[]
["NON CO_INCIDENT PEAK"]
[null,null,"NCP\nSanity Check",{"$f":"IF(OR(D55*4<D61,D56*4<D62,D57*4<D63,D58*4<D64),IF(OR(D55*12<D67,D56*12<D68,D57*12<D69,D58*12<D70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(D55*12<D67,D56*12<D68,D57*12<D69,D58*12<D70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(E55*4<E61,E56*4<E62,E57*4<E63,E58*4<E64),IF(OR(E55*12<E67,E56*12<E68,E57*12<E69,E58*12<E70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(E55*12<E67,E56*12<E68,E57*12<E69,E58*12<E70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(F55*4<F61,F56*4<F62,F57*4<F63,F58*4<F64),IF(OR(F55*12<F67,F56*12<F68,F57*12<F69,F58*12<F70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(F55*12<F67,F56*12<F68,F57*12<F69,F58*12<F70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(G55*4<G61,G56*4<G62,G57*4<G63,G58*4<G64),IF(OR(G55*12<G67,G56*12<G68,G57*12<G69,G58*12<G70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(G55*12<G67,G56*12<G68,G57*12<G69,G58*12<G70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(H55*4<H61,H56*4<H62,H57*4<H63,H58*4<H64),IF(OR(H55*12<H67,H56*12<H68,H57*12<H69,H58*12<H70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(H55*12<H67,H56*12<H68,H57*12<H69,H58*12<H70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(I55*4<I61,I56*4<I62,I57*4<I63,I58*4<I64),IF(OR(I55*12<I67,I56*12<I68,I57*12<I69,I58*12<I70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(I55*12<I67,I56*12<I68,I57*12<I69,I58*12<I70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(J55*4<J61,J56*4<J62,J57*4<J63,J58*4<J64),IF(OR(J55*12<J67,J56*12<J68,J57*12<J69,J58*12<J70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(J55*12<J67,J56*12<J68,J57*12<J69,J58*12<J70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(K55*4<K61,K56*4<K62,K57*4<K63,K58*4<K64),IF(OR(K55*12<K67,K56*12<K68,K57*12<K69,K58*12<K70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(K55*12<K67,K56*12<K68,K57*12<K69,K58*12<K70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(L55*4<L61,L56*4<L62,L57*4<L63,L58*4<L64),IF(OR(L55*12<L67,L56*12<L68,L57*12<L69,L58*12<L70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(L55*12<L67,L56*12<L68,L57*12<L69,L58*12<L70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(M55*4<M61,M56*4<M62,M57*4<M63,M58*4<M64),IF(OR(M55*12<M67,M56*12<M68,M57*12<M69,M58*12<M70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(M55*12<M67,M56*12<M68,M57*12<M69,M58*12<M70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(N55*4<N61,N56*4<N62,N57*4<N63,N58*4<N64),IF(OR(N55*12<N67,N56*12<N68,N57*12<N69,N58*12<N70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(N55*12<N67,N56*12<N68,N57*12<N69,N58*12<N70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(O55*4<O61,O56*4<O62,O57*4<O63,O58*4<O64),IF(OR(O55*12<O67,O56*12<O68,O57*12<O69,O58*12<O70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(O55*12<O67,O56*12<O68,O57*12<O69,O58*12<O70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(P55*4<P61,P56*4<P62,P57*4<P63,P58*4<P64),IF(OR(P55*12<P67,P56*12<P68,P57*12<P69,P58*12<P70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(P55*12<P67,P56*12<P68,P57*12<P69,P58*12<P70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(Q55*4<Q61,Q56*4<Q62,Q57*4<Q63,Q58*4<Q64),IF(OR(Q55*12<Q67,Q56*12<Q68,Q57*12<Q69,Q58*12<Q70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(Q55*12<Q67,Q56*12<Q68,Q57*12<Q69,Q58*12<Q70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(R55*4<R61,R56*4<R62,R57*4<R63,R58*4<R64),IF(OR(R55*12<R67,R56*12<R68,R57*12<R69,R58*12<R70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(R55*12<R67,R56*12<R68,R57*12<R69,R58*12<R70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(S55*4<S61,S56*4<S62,S57*4<S63,S58*4<S64),IF(OR(S55*12<S67,S56*12<S68,S57*12<S69,S58*12<S70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(S55*12<S67,S56*12<S68,S57*12<S69,S58*12<S70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(T55*4<T61,T56*4<T62,T57*4<T63,T58*4<T64),IF(OR(T55*12<T67,T56*12<T68,T57*12<T69,T58*12<T70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(T55*12<T67,T56*12<T68,T57*12<T69,T58*12<T70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(U55*4<U61,U56*4<U62,U57*4<U63,U58*4<U64),IF(OR(U55*12<U67,U56*12<U68,U57*12<U69,U58*12<U70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(U55*12<U67,U56*12<U68,U57*12<U69,U58*12<U70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(V55*4<V61,V56*4<V62,V57*4<V63,V58*4<V64),IF(OR(V55*12<V67,V56*12<V68,V57*12<V69,V58*12<V70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(V55*12<V67,V56*12<V68,V57*12<V69,V58*12<V70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(W55*4<W61,W56*4<W62,W57*4<W63,W58*4<W64),IF(OR(W55*12<W67,W56*12<W68,W57*12<W69,W58*12<W70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(W55*12<W67,W56*12<W68,W57*12<W69,W58*12<W70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"}]
["1 NCP"]
["Classification NCP from \n Load Data Provider","DNCP1",{"$f":"SUM(D55:W55)","v":58458.755540601916},27502.915720460031,8992.6973259478127,21641.181841422585,null,null,null,274.62274914631234,null,47.337903625173475]
["Primary NCP","PNCP1",{"$f":"SUM(D56:W56)","v":58458.755540601916},{"$f":"D55","v":27502.915720460031},{"$f":"E55","v":8992.6973259478127},{"$f":"F55","v":21641.181841422585},{"$f":"G55","v":0},{"$f":"H55","v":0},{"$f":"I55","v":0},{"$f":"J55","v":274.62274914631234},{"$f":"K55","v":0},{"$f":"L55","v":47.337903625173475}]
[" Line Transformer NCP","LTNCP1",{"$f":"SUM(D57:W57)","v":45617.534242532987},{"$f":"D56","v":27502.915720460031},{"$f":"E56","v":8992.6973259478127},8799.9605433536544,{"$f":"G56","v":0},{"$f":"H56","v":0},{"$f":"I56","v":0},{"$f":"J56","v":274.62274914631234},{"$f":"K56","v":0},{"$f":"L56","v":47.337903625173475}]
["Secondary NCP","SNCP1",{"$f":"SUM(D58:W58)","v":45617.534242532987},{"$f":"D57","v":27502.915720460031},{"$f":"E57","v":8992.6973259478127},{"$f":"F57","v":8799.9605433536544},{"$f":"G57","v":0},{"$f":"H57","v":0},{"$f":"I57","v":0},{"$f":"J57","v":274.62274914631234},{"$f":"K57","v":0},{"$f":"L57","v":47.337903625173475}]
[]
["4 NCP"]
["Classification NCP from \n Load Data Provider","DNCP4",{"$f":"SUM(D61:W61)","v":227345.54389222711},105782.12540343325,34946.267867336959,85332.358440721975,null,null,null,1098.4909965852494,null,186.30118414966108]
["Primary NCP","PNCP4",{"$f":"SUM(D62:W62)","v":227345.54389222711},{"$f":"D61","v":105782.12540343325},{"$f":"E61","v":34946.267867336959},{"$f":"F61","v":85332.358440721975},{"$f":"G61","v":0},{"$f":"H61","v":0},{"$f":"I61","v":0},{"$f":"J61","v":1098.4909965852494},{"$f":"K61","v":0},{"$f":"L61","v":186.30118414966108}]
[" Line Transformer NCP","LTNCP4",{"$f":"SUM(D63:W63)","v":176711.90906337154},{"$f":"D62","v":105782.12540343325},{"$f":"E62","v":34946.267867336959},34698.723611866408,{"$f":"G62","v":0},{"$f":"H62","v":0},{"$f":"I62","v":0},{"$f":"J62","v":1098.4909965852494},{"$f":"K62","v":0},{"$f":"L62","v":186.30118414966108}]
["Secondary NCP","SNCP4",{"$f":"SUM(D64:W64)","v":176711.90906337154},{"$f":"D63","v":105782.12540343325},{"$f":"E63","v":34946.267867336959},{"$f":"F63","v":34698.723611866408},{"$f":"G63","v":0},{"$f":"H63","v":0},{"$f":"I63","v":0},{"$f":"J63","v":1098.4909965852494},{"$f":"K63","v":0},{"$f":"L63","v":186.30118414966108}]
[]
["12 NCP"]
["Classification NCP from \n Load Data Provider","DNCP12",{"$f":"SUM(D67:W67)","v":629409.66226080176},289401.10065486556,94807.471061319869,241355.64683749172,null,null,null,3295.4728897557479,null,549.97081736886298]
["Primary NCP","PNCP12",{"$f":"SUM(D68:W68)","v":629409.66226080176},{"$f":"D67","v":289401.10065486556},{"$f":"E67","v":94807.471061319869},{"$f":"F67","v":241355.64683749172},{"$f":"G67","v":0},{"$f":"H67","v":0},{"$f":"I67","v":0},{"$f":"J67","v":3295.4728897557479},{"$f":"K67","v":0},{"$f":"L67","v":549.97081736886298}]
[" Line Transformer NCP","LTNCP12",{"$f":"SUM(D69:W69)","v":486196.53761311987},{"$f":"D68","v":289401.10065486556},{"$f":"E68","v":94807.471061319869},98142.522189809853,{"$f":"G68","v":0},{"$f":"H68","v":0},{"$f":"I68","v":0},{"$f":"J68","v":3295.4728897557479},{"$f":"K68","v":0},{"$f":"L68","v":549.97081736886298}]
["Secondary NCP","SNCP12",{"$f":"SUM(D70:W70)","v":486196.53761311987},{"$f":"D69","v":289401.10065486556},{"$f":"E69","v":94807.471061319869},{"$f":"F69","v":98142.522189809853},{"$f":"G69","v":0},{"$f":"H69","v":0},{"$f":"I69","v":0},{"$f":"J69","v":3295.4728897557479},{"$f":"K69","v":0},{"$f":"L69","v":549.97081736886298}]

{"sheet":"ii. 2021 Base Year","index":2,"n_rows":70,"n_cols":23,"rows_kept":70,"cut":false,"hidden":false,"merged":[[51,0,51,1],[25,0,25,1],[26,0,26,1],[30,0,30,1],[34,0,34,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[23,0,23,1],[24,0,24,1],[0,0,0,5],[1,0,1,4],[2,0,2,4],[3,0,3,4],[13,0,13,1],[14,0,14,1]]}
[]
[]
[]
["EB-2021-XXXX"]
["Sheet I8 Demand Data Worksheet  -  "]
[]
[]
[]
[]
[]
[]
[]
[]
["CP TEST RESULTS",null,"-"]
["NCP TEST RESULTS",null,"-"]
[]
["Co-incident Peak",null,"Indicator"]
["1  CP",null,"CP 1"]
["4 CP",null,"CP 4"]
["12 CP",null,"CP 12"]
[]
["4 NCP",null,"NCP 4"]
["12 NCP",null,"NCP 12"]
["Non-co-incident Peak",null,"Indicator"]
["1 NCP",null,"NCP 1 "]
["4 NCP",null,"NCP 4"]
["12 NCP",null,"NCP 12"]
[]
[]
[null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Customer Classes",null,"Total","Residential","GS <50","GS>50-Regular","GS> 50-TOU","GS >50-Intermediate","Large Use >5MW","Street Light","Sentinel","Unmetered Scattered Load","Embedded Distributor","Back-up/Standby Power","Rate Class 1","Rate class 2","Rate class 3","Rate class 4","Rate class 5","Rate class 6","Rate class 7","Rate class 8","Rate class 9"]
[]
[]
[null,null,"CP\nSanity Check",{"$f":"IF(MAX(D38,D39,D40)>D55,\"Check 1 CP\",IF(MAX(D43,D44,D45)>D61,\"Check 4 CP\",IF(MAX(D48,D49,D50)>D67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(E38,E39,E40)>E55,\"Check 1 CP\",IF(MAX(E43,E44,E45)>E61,\"Check 4 CP\",IF(MAX(E48,E49,E50)>E67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(F38,F39,F40)>F55,\"Check 1 CP\",IF(MAX(F43,F44,F45)>F61,\"Check 4 CP\",IF(MAX(F48,F49,F50)>F67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(G38,G39,G40)>G55,\"Check 1 CP\",IF(MAX(G43,G44,G45)>G61,\"Check 4 CP\",IF(MAX(G48,G49,G50)>G67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(H38,H39,H40)>H55,\"Check 1 CP\",IF(MAX(H43,H44,H45)>H61,\"Check 4 CP\",IF(MAX(H48,H49,H50)>H67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(I38,I39,I40)>I55,\"Check 1 CP\",IF(MAX(I43,I44,I45)>I61,\"Check 4 CP\",IF(MAX(I48,I49,I50)>I67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(J38,J39,J40)>J55,\"Check 1 CP\",IF(MAX(J43,J44,J45)>J61,\"Check 4 CP\",IF(MAX(J48,J49,J50)>J67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(K38,K39,K40)>K55,\"Check 1 CP\",IF(MAX(K43,K44,K45)>K61,\"Check 4 CP\",IF(MAX(K48,K49,K50)>K67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(L38,L39,L40)>L55,\"Check 1 CP\",IF(MAX(L43,L44,L45)>L61,\"Check 4 CP\",IF(MAX(L48,L49,L50)>L67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(M38,M39,M40)>M55,\"Check 1 CP\",IF(MAX(M43,M44,M45)>M61,\"Check 4 CP\",IF(MAX(M48,M49,M50)>M67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(N38,N39,N40)>N55,\"Check 1 CP\",IF(MAX(N43,N44,N45)>N61,\"Check 4 CP\",IF(MAX(N48,N49,N50)>N67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(O38,O39,O40)>O55,\"Check 1 CP\",IF(MAX(O43,O44,O45)>O61,\"Check 4 CP\",IF(MAX(O48,O49,O50)>O67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(P38,P39,P40)>P55,\"Check 1 CP\",IF(MAX(P43,P44,P45)>P61,\"Check 4 CP\",IF(MAX(P48,P49,P50)>P67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(Q38,Q39,Q40)>Q55,\"Check 1 CP\",IF(MAX(Q43,Q44,Q45)>Q61,\"Check 4 CP\",IF(MAX(Q48,Q49,Q50)>Q67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(R38,R39,R40)>R55,\"Check 1 CP\",IF(MAX(R43,R44,R45)>R61,\"Check 4 CP\",IF(MAX(R48,R49,R50)>R67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(S38,S39,S40)>S55,\"Check 1 CP\",IF(MAX(S43,S44,S45)>S61,\"Check 4 CP\",IF(MAX(S48,S49,S50)>S67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(T38,T39,T40)>T55,\"Check 1 CP\",IF(MAX(T43,T44,T45)>T61,\"Check 4 CP\",IF(MAX(T48,T49,T50)>T67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(U38,U39,U40)>U55,\"Check 1 CP\",IF(MAX(U43,U44,U45)>U61,\"Check 4 CP\",IF(MAX(U48,U49,U50)>U67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(V38,V39,V40)>V55,\"Check 1 CP\",IF(MAX(V43,V44,V45)>V61,\"Check 4 CP\",IF(MAX(V48,V49,V50)>V67,\"Check 12 CP\",\"Pass\")))","v":"Pass"},{"$f":"IF(MAX(W38,W39,W40)>W55,\"Check 1 CP\",IF(MAX(W43,W44,W45)>W61,\"Check 4 CP\",IF(MAX(W48,W49,W50)>W67,\"Check 12 CP\",\"Pass\")))","v":"Pass"}]
["CO-INCIDENT PEAK"]
[]
["1 CP"]
["Transformation CP","TCP1",{"$f":"SUM(D38:W38)","v":53180.906914244755},26907.261039970497,7777.6465236272197,18176.323533934188,null,null,null,275.35290904758676,null,44.322907665253361]
["Bulk Delivery CP","BCP1",{"$f":"SUM(D39:W39)","v":53180.906914244755},{"$f":"D38","v":26907.261039970497},{"$f":"E38","v":7777.6465236272197},{"$f":"F38","v":18176.323533934188},{"$f":"G38","v":0},{"$f":"H38","v":0},{"$f":"I38","v":0},{"$f":"J38","v":275.35290904758676},{"$f":"K38","v":0},{"$f":"L38","v":44.322907665253361}]
["Total Sytem CP ","DCP1",{"$f":"SUM(D40:W40)","v":53180.906914244755},{"$f":"D39","v":26907.261039970497},{"$f":"E39","v":7777.6465236272197},{"$f":"F39","v":18176.323533934188},{"$f":"G39","v":0},{"$f":"H39","v":0},{"$f":"I39","v":0},{"$f":"J39","v":275.35290904758676},{"$f":"K39","v":0},{"$f":"L39","v":44.322907665253361}]
[]
["4 CP"]
["Transformation CP","TCP4",{"$f":"SUM(D43:W43)","v":210390.54173425236},105297.92136682395,32380.582071846475,71704.01333969603,null,null,null,826.05872714276029,null,181.96622874314343]
["Bulk Delivery CP","BCP4",{"$f":"SUM(D44:W44)","v":210390.54173425236},{"$f":"D43","v":105297.92136682395},{"$f":"E43","v":32380.582071846475},{"$f":"F43","v":71704.01333969603},{"$f":"G43","v":0},{"$f":"H43","v":0},{"$f":"I43","v":0},{"$f":"J43","v":826.05872714276029},{"$f":"K43","v":0},{"$f":"L43","v":181.96622874314343}]
["Total Sytem CP ","DCP4",{"$f":"SUM(D45:W45)","v":210390.54173425236},{"$f":"D44","v":105297.92136682395},{"$f":"E44","v":32380.582071846475},{"$f":"F44","v":71704.01333969603},{"$f":"G44","v":0},{"$f":"H44","v":0},{"$f":"I44","v":0},{"$f":"J44","v":826.05872714276029},{"$f":"K44","v":0},{"$f":"L44","v":181.96622874314343}]
[]
["12 CP"]
["Transformation CP","TCP12",{"$f":"SUM(D48:W48)","v":593279.74767780979},283250.02152670064,92733.909449413186,215100.49180186412,null,null,null,1652.1174542855206,null,543.20744554628402]
["Bulk Delivery CP","BCP12",{"$f":"SUM(D49:W49)","v":593279.74767780979},{"$f":"D48","v":283250.02152670064},{"$f":"E48","v":92733.909449413186},{"$f":"F48","v":215100.49180186412},{"$f":"G48","v":0},{"$f":"H48","v":0},{"$f":"I48","v":0},{"$f":"J48","v":1652.1174542855206},{"$f":"K48","v":0},{"$f":"L48","v":543.20744554628402}]
["Total Sytem CP ","DCP12",{"$f":"SUM(D50:W50)","v":593279.74767780979},{"$f":"D49","v":283250.02152670064},{"$f":"E49","v":92733.909449413186},{"$f":"F49","v":215100.49180186412},{"$f":"G49","v":0},{"$f":"H49","v":0},{"$f":"I49","v":0},{"$f":"J49","v":1652.1174542855206},{"$f":"K49","v":0},{"$f":"L49","v":543.20744554628402}]
[]
["NON CO_INCIDENT PEAK"]
[null,null,"NCP\nSanity Check",{"$f":"IF(OR(D55*4<D61,D56*4<D62,D57*4<D63,D58*4<D64),IF(OR(D55*12<D67,D56*12<D68,D57*12<D69,D58*12<D70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(D55*12<D67,D56*12<D68,D57*12<D69,D58*12<D70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(E55*4<E61,E56*4<E62,E57*4<E63,E58*4<E64),IF(OR(E55*12<E67,E56*12<E68,E57*12<E69,E58*12<E70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(E55*12<E67,E56*12<E68,E57*12<E69,E58*12<E70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(F55*4<F61,F56*4<F62,F57*4<F63,F58*4<F64),IF(OR(F55*12<F67,F56*12<F68,F57*12<F69,F58*12<F70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(F55*12<F67,F56*12<F68,F57*12<F69,F58*12<F70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(G55*4<G61,G56*4<G62,G57*4<G63,G58*4<G64),IF(OR(G55*12<G67,G56*12<G68,G57*12<G69,G58*12<G70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(G55*12<G67,G56*12<G68,G57*12<G69,G58*12<G70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(H55*4<H61,H56*4<H62,H57*4<H63,H58*4<H64),IF(OR(H55*12<H67,H56*12<H68,H57*12<H69,H58*12<H70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(H55*12<H67,H56*12<H68,H57*12<H69,H58*12<H70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(I55*4<I61,I56*4<I62,I57*4<I63,I58*4<I64),IF(OR(I55*12<I67,I56*12<I68,I57*12<I69,I58*12<I70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(I55*12<I67,I56*12<I68,I57*12<I69,I58*12<I70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(J55*4<J61,J56*4<J62,J57*4<J63,J58*4<J64),IF(OR(J55*12<J67,J56*12<J68,J57*12<J69,J58*12<J70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(J55*12<J67,J56*12<J68,J57*12<J69,J58*12<J70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(K55*4<K61,K56*4<K62,K57*4<K63,K58*4<K64),IF(OR(K55*12<K67,K56*12<K68,K57*12<K69,K58*12<K70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(K55*12<K67,K56*12<K68,K57*12<K69,K58*12<K70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(L55*4<L61,L56*4<L62,L57*4<L63,L58*4<L64),IF(OR(L55*12<L67,L56*12<L68,L57*12<L69,L58*12<L70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(L55*12<L67,L56*12<L68,L57*12<L69,L58*12<L70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(M55*4<M61,M56*4<M62,M57*4<M63,M58*4<M64),IF(OR(M55*12<M67,M56*12<M68,M57*12<M69,M58*12<M70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(M55*12<M67,M56*12<M68,M57*12<M69,M58*12<M70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(N55*4<N61,N56*4<N62,N57*4<N63,N58*4<N64),IF(OR(N55*12<N67,N56*12<N68,N57*12<N69,N58*12<N70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(N55*12<N67,N56*12<N68,N57*12<N69,N58*12<N70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(O55*4<O61,O56*4<O62,O57*4<O63,O58*4<O64),IF(OR(O55*12<O67,O56*12<O68,O57*12<O69,O58*12<O70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(O55*12<O67,O56*12<O68,O57*12<O69,O58*12<O70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(P55*4<P61,P56*4<P62,P57*4<P63,P58*4<P64),IF(OR(P55*12<P67,P56*12<P68,P57*12<P69,P58*12<P70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(P55*12<P67,P56*12<P68,P57*12<P69,P58*12<P70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(Q55*4<Q61,Q56*4<Q62,Q57*4<Q63,Q58*4<Q64),IF(OR(Q55*12<Q67,Q56*12<Q68,Q57*12<Q69,Q58*12<Q70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(Q55*12<Q67,Q56*12<Q68,Q57*12<Q69,Q58*12<Q70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(R55*4<R61,R56*4<R62,R57*4<R63,R58*4<R64),IF(OR(R55*12<R67,R56*12<R68,R57*12<R69,R58*12<R70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(R55*12<R67,R56*12<R68,R57*12<R69,R58*12<R70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(S55*4<S61,S56*4<S62,S57*4<S63,S58*4<S64),IF(OR(S55*12<S67,S56*12<S68,S57*12<S69,S58*12<S70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(S55*12<S67,S56*12<S68,S57*12<S69,S58*12<S70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(T55*4<T61,T56*4<T62,T57*4<T63,T58*4<T64),IF(OR(T55*12<T67,T56*12<T68,T57*12<T69,T58*12<T70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(T55*12<T67,T56*12<T68,T57*12<T69,T58*12<T70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(U55*4<U61,U56*4<U62,U57*4<U63,U58*4<U64),IF(OR(U55*12<U67,U56*12<U68,U57*12<U69,U58*12<U70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(U55*12<U67,U56*12<U68,U57*12<U69,U58*12<U70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(V55*4<V61,V56*4<V62,V57*4<V63,V58*4<V64),IF(OR(V55*12<V67,V56*12<V68,V57*12<V69,V58*12<V70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(V55*12<V67,V56*12<V68,V57*12<V69,V58*12<V70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"},{"$f":"IF(OR(W55*4<W61,W56*4<W62,W57*4<W63,W58*4<W64),IF(OR(W55*12<W67,W56*12<W68,W57*12<W69,W58*12<W70),\"Check 4 NCP and 12 NCP\",\"Check 4 NCP\"),IF(OR(W55*12<W67,W56*12<W68,W57*12<W69,W58*12<W70),\"Check 12 NCP\",\"Pass\"))","v":"Pass"}]
["1 NCP"]
["Classification NCP from \n Load Data Provider","DNCP1",{"$f":"SUM(D55:W55)","v":58543.785528976499},27566.302456026104,9236.117513018,21417.110463218432,null,null,null,275.35290904758676,null,48.902187666382851]
["Primary NCP","PNCP1",{"$f":"SUM(D56:W56)","v":58543.785528976499},{"$f":"D55","v":27566.302456026104},{"$f":"E55","v":9236.117513018},{"$f":"F55","v":21417.110463218432},{"$f":"G55","v":0},{"$f":"H55","v":0},{"$f":"I55","v":0},{"$f":"J55","v":275.35290904758676},{"$f":"K55","v":0},{"$f":"L55","v":48.902187666382851}]
[" Line Transformer NCP","LTNCP1",{"$f":"SUM(D57:W57)","v":45835.521394484254},{"$f":"D56","v":27566.302456026104},{"$f":"E56","v":9236.117513018},8708.8463287261857,{"$f":"G56","v":0},{"$f":"H56","v":0},{"$f":"I56","v":0},{"$f":"J56","v":275.35290904758676},{"$f":"K56","v":0},{"$f":"L56","v":48.902187666382851}]
["Secondary NCP","SNCP1",{"$f":"SUM(D58:W58)","v":45835.521394484254},{"$f":"D57","v":27566.302456026104},{"$f":"E57","v":9236.117513018},{"$f":"F57","v":8708.8463287261857},{"$f":"G57","v":0},{"$f":"H57","v":0},{"$f":"I57","v":0},{"$f":"J57","v":275.35290904758676},{"$f":"K57","v":0},{"$f":"L57","v":48.902187666382851}]
[]
["4 NCP"]
["Classification NCP from \n Load Data Provider","DNCP4",{"$f":"SUM(D61:W61)","v":226473.71221051179},107409.61555528906,34653.611760102598,83119.766703105866,null,null,null,1101.4116361903471,null,189.30655582392208]
["Primary NCP","PNCP4",{"$f":"SUM(D62:W62)","v":226473.71221051179},{"$f":"D61","v":107409.61555528906},{"$f":"E61","v":34653.611760102598},{"$f":"F61","v":83119.766703105866},{"$f":"G61","v":0},{"$f":"H61","v":0},{"$f":"I61","v":0},{"$f":"J61","v":1101.4116361903471},{"$f":"K61","v":0},{"$f":"L61","v":189.30655582392208}]
[" Line Transformer NCP","LTNCP4",{"$f":"SUM(D63:W63)","v":177152.96224872128},{"$f":"D62","v":107409.61555528906},{"$f":"E62","v":34653.611760102598},33799.016741315383,{"$f":"G62","v":0},{"$f":"H62","v":0},{"$f":"I62","v":0},{"$f":"J62","v":1101.4116361903471},{"$f":"K62","v":0},{"$f":"L62","v":189.30655582392208}]
["Secondary NCP","SNCP4",{"$f":"SUM(D64:W64)","v":177152.96224872128},{"$f":"D63","v":107409.61555528906},{"$f":"E63","v":34653.611760102598},{"$f":"F63","v":33799.016741315383},{"$f":"G63","v":0},{"$f":"H63","v":0},{"$f":"I63","v":0},{"$f":"J63","v":1101.4116361903471},{"$f":"K63","v":0},{"$f":"L63","v":189.30655582392208}]
[]
["12 NCP"]
["Classification NCP from \n Load Data Provider","DNCP12",{"$f":"SUM(D67:W67)","v":622322.76738566277},286431.10535869189,93688.953600747278,238345.91938694371,null,null,null,3304.234808571041,null,552.55423070889844]
["Primary NCP","PNCP12",{"$f":"SUM(D68:W68)","v":622322.76738566277},{"$f":"D67","v":286431.10535869189},{"$f":"E67","v":93688.953600747278},{"$f":"F67","v":238345.91938694371},{"$f":"G67","v":0},{"$f":"H67","v":0},{"$f":"I67","v":0},{"$f":"J67","v":3304.234808571041},{"$f":"K67","v":0},{"$f":"L67","v":552.55423070889844}]
[" Line Transformer NCP","LTNCP12",{"$f":"SUM(D69:W69)","v":480895.52377361758},{"$f":"D68","v":286431.10535869189},{"$f":"E68","v":93688.953600747278},96918.675774898453,{"$f":"G68","v":0},{"$f":"H68","v":0},{"$f":"I68","v":0},{"$f":"J68","v":3304.234808571041},{"$f":"K68","v":0},{"$f":"L68","v":552.55423070889844}]
["Secondary NCP","SNCP12",{"$f":"SUM(D70:W70)","v":480895.52377361758},{"$f":"D69","v":286431.10535869189},{"$f":"E69","v":93688.953600747278},{"$f":"F69","v":96918.675774898453},{"$f":"G69","v":0},{"$f":"H69","v":0},{"$f":"I69","v":0},{"$f":"J69","v":3304.234808571041},{"$f":"K69","v":0},{"$f":"L69","v":552.55423070889844}]