{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Calculator","Sheet1","Main","InvestTable","Rate 41","Rate 44","Rate 45","Rate 61"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":6,"comments":4,"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":"Calculator","index":0,"n_rows":30,"n_cols":12,"rows_kept":30,"cut":false,"hidden":false,"merged":[[17,5,17,6],[17,8,17,9],[25,3,25,6],[6,9,6,10],[8,9,8,10]]}
[null,null,null,null,null,null,null,null,null,null,null,"Effective Jan 1, 2023"]
[null,null,null,null,null,null,null,null,null,null,null,"Version 20221208"]
[]
[null,null,null,"Estimated Cost for Reducing Contract Minimums"]
[]
[]
[null,null,null,"Type of Service"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Existing",null,null,"New"]
[]
[null,null,null,"Contract Minimum Demand",null,null,95.333333333333329,null,null,{"$f":"IF(J16=0,0,IF(J16>=75,J16*2/3,3))","v":0}]
[]
[null,null,null,"Expected Peak Demand",null,null,{"$f":"G14*3/2","v":143},null,null,0]
[]
[null,null,null,"Rate",null,"General Service (R61)",null,null,{"$f":"IF(J16>=75,\"General Service (R61)\",CHOOSE(Main!$F$8,\"Small General Service (R41)\",\"Oil & Gas Service (R45)\"))","v":"Small General Service (R41)"}]
[]
[]
[]
[null,null,null,"Notice Period Required",null,null,null,null,null,{"$f":"MAX(Main!F30:F31)","v":3}]
[]
[null,null,null,"Or"]
[]
[null,null,null,"Estimated Payment in Lieu of Notice",null,null,null,null,null,{"$f":"Main!F35","v":1404.72}]
[]
[]
[null,"Next Steps"]
[null,"If you are interested in proceeding, please contact FortisAlberta for a formal “Review of Minimum”."]

{"sheet":"Sheet1","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Main","index":2,"n_rows":35,"n_cols":19,"rows_kept":35,"cut":false,"hidden":true,"merged":[[33,0,33,4]]}
["PILON Calculator",null,null,null,null,null,"Change effective Jan 1, 2015"]
[null,null,null,null,null,null,"Version 20150807"]
[]
[null,null,null,null,null,"Do you know which rate you are buying down to?"]
[null,null,null,null,null,2]
[]
[null,null,null,null,null,"Select the Type of Service"]
[null,null,null,null,null,1]
[]
["Service Requirements",null,null,"Original",null,"New"]
["Rate",null,null,1,null,1]
["Service Type",null,null,"Commercial/Oil & Gas",null,{"$f":"IF(Main!$F$5=1,CHOOSE(F$11,\"N/A\",\"Commercial\",\"Oil & Gas\",\"Oil & Gas\",\"Commercial/Oil & Gas\"),IF(Main!$F$13>=75,\"Commercial/Oil & Gas\",IF(Main!$F$8=1,\"N/A\",IF(Main!$F$8=2,\"Commercial\",CHOOSE(F$11,\"N/A\",\"Oil & Gas\",\"Oil & Gas\")))))","v":"N/A"},null,null,null,null,null,null,null,null,null,null,{"$f":"InvestTable!P10/InvestTable!P16*(#REF!-#REF!)","v":{"$error":"#DIV/0!"}}]
["Expected Peak Demand",null,null,{"$f":"Calculator!G14*3/2","v":143},"kW",{"$f":"Calculator!J16","v":0},"kW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":" RIGHT(G1,4)&\" Fortis MIL (\"&#REF!&\" kW)\"","v":{"$error":"#REF!"}},{"$f":" RIGHT(G1,4)&\" Fortis MIL (\"&#REF!&\" kW) excl. Base Investment\"","v":{"$error":"#REF!"}},{"$f":"YEAR(#REF!)&\" \"&#REF!","v":{"$error":"#REF!"}},"(A) ","(B)","(C)"]
[]
["Payment in Lieu of Notice",null,null,"Original",null,"New",null,null,null,"Case3: A > B > C"]
["Rate",null,null,{"$f":"\"Rate 61\"","v":"Rate 61"},null,{"$f":"IF(Main!$F$5=1,CHOOSE(F$11,\"N/A\",\"Rate 41\",\"Rate 44\",\"Rate 45\",\"Rate 61\"),IF(Main!$F$13>=75,\"Rate 61\",IF(Main!$F$8=1,\"Rate 41\",\"Rate 45\")))","v":"Rate 41"},null,null,null,{"$f":"\"Buy-down Charge = Max(A - B - Max(A - C , 0), 0) = \"&IF(#REF!=3,0,\"N/A\")","v":{"$error":"#REF!"}}]
["Contract Minimum Demand",null,null,{"$f":"ROUND(CHOOSE(D$11,D13*2/3),1)","v":95.3},"kW",{"$f":"IF(F13=0,0,CHOOSE(InvestTable!$I$27,\"\",3,3,3,ROUND(F13*2/3,1)))","v":0},"kW"]
["Minimum Monthly Charge",null,null,{"$f":"CHOOSE(D$11,'Rate 61'!O7)","v":775.75},null,{"$f":"IF(F13=0,0,CHOOSE(InvestTable!$I$27,\"\",'Rate 41'!O8,'Rate 44'!O8,'Rate 45'!O8,'Rate 61'!O8,))","v":0}]
["Monthly Payment in Lieu of Notice - T Component",null,null,null,null,{"$f":"IF($D$22-$F$22<0,0,$D$22-$F$22)","v":468.24}]
["Monthly Payment in Lieu of Notice - D Component",null,null,null,null,{"$f":"IF($D$23-$F$23<0,0,$D$23-$F$23)","v":307.51}]
["Monthly Charge T Component",null,null,{"$f":"'Rate 61'!R7","v":468.24},null,{"$f":"IF(F13=0,0,CHOOSE(InvestTable!$I$27,\"\",'Rate 41'!R8,'Rate 44'!R8,'Rate 45'!R8,'Rate 61'!R8))","v":0}]
["Monthly Charge D Component",null,null,{"$f":"'Rate 61'!U7","v":307.51},null,{"$f":"IF(F13=0,0,CHOOSE(InvestTable!$I$27,\"\",'Rate 41'!U8,'Rate 44'!U8,'Rate 45'!U8,'Rate 61'!U8))","v":0}]
["Monthly Payment in Lieu of Notice",null,null,null,null,{"$f":"IF(($D$19-$F$19)<0,0,$D$19-$F$19)","v":775.75},"/month"]
[]
["Decrease in Contract Minimum Demand",null,null,null,null,{"$f":"IF((D18-F18)<0,0,D18-F18)","v":95.3},"kW"]
["Notice Period Required for T - component (Maximum 60 Months)",null,null,null,null,{"$f":"MIN(ROUND($F$26/30,0),60)","v":3},"months"]
["Notice Period Required for D - component (Maximum 24 Months)",null,null,null,null,{"$f":"MIN(ROUND($F$26/30,0),24)","v":3},"months"]
["Actual Notice Provided",null,null,null,null,null,"months"]
["Months Falling Short of Required Notice Period - T Component",null,null,null,null,{"$f":"MAX($F$27-$F$29,0)","v":3},"months"]
["Months Falling Short of Required Notice Period - D Component",null,null,null,null,{"$f":"MAX($F$28-$F$29,0)","v":3},"months"]
["Payment in Lieu of Notice - T Component",null,null,null,null,{"$f":"IF($F$24<=0,0,$F$30*$F$20)","v":1404.72}]
["Payment in Lieu of Notice - D Component",null,null,null,null,{"$f":"IF($F$24<=0,0,$F$31*$F$21)","v":922.53}]
["Payment in Lieu of Notice - D Component (Removed) \nas per AUC decision 25916-D01-2021 ",null,null,null,null,{"$f":"F33*-1","v":-922.53}]
["Total Payment in Lieu of Notice",null,null,null,null,{"$f":"SUM(F32:F34)","v":1404.72}]

{"sheet":"InvestTable","index":3,"n_rows":35,"n_cols":9,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["Maximum Investment Levels for Distribution Facilities When Service Life Is Less Than 15 Years."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Points of Service with a life of less than 2 years are considered temporary services and the maximum investment is zero."]
[]
[]
["Drop-Down Menus"]
["OldRate","NewRate","OldType","NewType"]
["Rate 11","Rate 11","Residential","Residential",null,"Please select the rate.","Please select the type of service.","Yes",{"$f":"IF(Main!$F$17=\"Rate 41\",2,IF(Main!$F$17=\"Rate 44\",3,IF(Main!$F$17=\"Rate 45\",4,IF(Main!$F$17=\"Rate 61\",5,1))))","v":2}]
["Rate 21","Rate 21","Farm","Farm",null,"Rate 41","Non Oil & Gas","No"]
["Rate 23","Rate 23","Irrigation","Irrigation",null,"Rate 44","Oil & Gas"]
["Rate 26","Rate 26","Commercial/Oil & Gas","Commercial/Oil & Gas",null,"Rate 45"]
["Rate 41","Rate 41","Large General Service","Large General Service",null,"Rate 61"]
["Rate 44","Rate 44"]
["Rate 45","Rate 45",null,null,null,"Please select the rate."]
["Rate 61","Rate 61",null,null,null,"Rate 44"]
["Rate 63","Rate 63",null,null,null,"Rate 45"]

{"sheet":"Rate 41","index":4,"n_rows":300,"n_cols":21,"rows_kept":300,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Small General Service - Rate 41"]
[null,{"$f":"EffectiveDate","v":"FortisAlberta Inc. 2017 Rates, effective January 1, 2017"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Minimum",null,"Minimum"]
[null,"User input area:",null,null,null,null,null,null,null,null,null,null,"Demand",null,"Charge"]
[null,"Demand (kW of capacity)",null,null,{"$f":"Main!F18","v":0},null,"kWh delivered",null,null,null,{"$f":"E6*730*E7","v":0},null,"Input",null,{"$f":"O20","v":29.73},null,null,{"$f":"E20","v":0},null,null,{"$f":"G20","v":29.73}]
[null,"Load Factor",null,null,0,null,"first block (kWh)",null,null,null,{"$f":"((200*$E$6)*12/365)*$E$8","v":0},null,{"$f":"Main!D18","v":95.3},0,1081.08,null,{"$f":"M7","v":95.3},370.69,null,{"$f":"Q7","v":95.3},710.38]
[null,"Number of days in Consumption Period",null,null,{"$f":"365/12","v":30.416666666666668},null,null,null,null,null,null,null,{"$f":"Main!F18","v":0},0,27.97,null,{"$f":"M8","v":0},0,null,{"$f":"Q8","v":0},27.97]
[null,"Municipal Code",null,null,"99-0001"]
[null,"Epcor RRO rider (daily amount)",null,null,0]
[]
[]
[null,"BASE CHARGES","Generation",null,"Transmission",null,"Distribution",null,"Retail",null,null,null,"Units",null,"Charges"]
[null,"Energy Charge (¢/kWh)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND((((E15*M15)+(G15*M15))/100),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND((SUM(C16:E16)*M16/100),2)","v":0}]
[null,"Capacity Charges"]
[null,"     all kW",null,null,0.119662,null,0.250301,null,null,null,null,null,{"$f":"E6","v":0},null,{"$f":"ROUNDUP((((E18+G18)*M18)*E8),2)","v":0}]
[null,"Service Charge",null,null,null,null,0.97752700000000003,null,null,null,null,null,{"$f":"E8","v":30.416666666666668},null,{"$f":"ROUND(G19*M19,2)","v":29.73}]
[null,"Total Base Charges",{"$f":"(C15*M15/100)+(C16*M16/100)","v":0},null,{"$f":"ROUND(E18*$E$8*$M$18+E19*$M$19,2)","v":0},null,{"$f":"ROUND(G18*$E$8*$M$18+G19*$M$19,2)","v":29.73},null,{"$f":"#REF!*E8","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"SUM(O15:O19)","v":29.73}]
[]
[null,"RIDERS","G Riders",null,"T Riders",null,"D Riders",null,null,null,"Other Riders"]
[null,"2001 EESAI RRO Shortfall Rider ",null,null,null,null,null,null,null,null,{"$f":"E10","v":0},null,{"$f":"E8","v":30.416666666666668},null,{"$f":"ROUND((K23*M23/100),2)","v":0}]
[null,"Municipal Assessment Rider A-1",null,null,null,null,0,null,null,null,null,null,{"$f":"E20+G20","v":29.73},null,{"$f":"ROUND((G24*M24),2)","v":0}]
[null,"Municipal Franchise (Local Access) Fee",null,null,null,null,null,null,null,null,0,null,{"$f":"E20+G20","v":29.73},null,{"$f":"ROUND((K25*M25),2)","v":0}]
[null,"Total Riders",null,null,null,null,{"$f":"ROUND((G23*M23/100),2)+ROUND((G24*M24),2)+ROUND((G25*M25),2)","v":0},null,null,null,{"$f":"ROUND((K23*M23/100),2)+ROUND((K24*M24),2)+ROUND((K25*M25),2)","v":0},null,null,null,{"$f":"ROUNDUP((SUM(O23:O25)),2)","v":0}]
[]
[null,"Final Charges",{"$f":"C20+C26","v":0},null,{"$f":"E20+E26","v":0},null,{"$f":"G20+G26","v":29.73},null,{"$f":"I20+I26","v":{"$error":"#REF!"}},null,{"$f":"K20+K26","v":0},null,null,null,{"$f":"ROUNDUP((SUM(O20:O25)),2)","v":29.73}]
[]
[null,"Percentage of Total Charges",{"$f":"C28/O28","v":0},null,{"$f":"E28/O28","v":0},null,{"$f":"G28/O28","v":1},null,{"$f":"I28/O28","v":{"$error":"#REF!"}},null,{"$f":"K28/O28","v":0},null,null,null,{"$f":"O28/O28","v":1}]
[]
[]
[]
[]
[null,"01-0003"]
[null,"01-0046"]
[null,"01-0048"]
[null,"01-0098"]
[null,"01-0117"]
[null,"01-0200"]
[null,"01-0203"]
[null,"01-0291"]
[null,"01-0292"]
[null,"01-0347"]
[null,"02-0011"]
[null,"02-0014"]
[null,"02-0016"]
[null,"02-0017"]
[null,"02-0019"]
[null,"02-0024"]
[null,"02-0030"]
[null,"02-0031"]
[null,"02-0034"]
[null,"02-0039"]
[null,"02-0040"]
[null,"02-0043"]
[null,"02-0044"]
[null,"02-0047"]
[null,"02-0050"]
[null,"02-0052"]
[null,"02-0056"]
[null,"02-0065"]
[null,"02-0069"]
[null,"02-0070"]
[null,"02-0079"]
[null,"02-0082"]
[null,"02-0086"]
[null,"02-0088"]
[null,"02-0091"]
[null,"02-0095"]
[null,"02-0100"]
[null,"02-0115"]
[null,"02-0124"]
[null,"02-0135"]
[null,"02-0143"]
[null,"02-0148"]
[null,"02-0151"]
[null,"02-0180"]
[null,"02-0188"]
[null,"02-0192"]
[null,"02-0194"]
[null,"02-0197"]
[null,"02-0202"]
[null,"02-0211"]
[null,"02-0215"]
[null,"02-0218"]
[null,"02-0219"]
[null,"02-0224"]
[null,"02-0232"]
[null,"02-0238"]
[null,"02-0239"]
[null,"02-0248"]
[null,"02-0249"]
[null,"02-0250"]
[null,"02-0254"]
[null,"02-0257"]
[null,"02-0261"]
[null,"02-0265"]
[null,"02-0266"]
[null,"02-0268"]
[null,"02-0280"]
[null,"02-0297"]
[null,"02-0301"]
[null,"02-0303"]
[null,"02-0307"]
[null,"02-0310"]
[null,"02-0311"]
[null,"02-0318"]
[null,"02-0321"]
[null,"02-0326"]
[null,"02-0331"]
[null,"02-0333"]
[null,"02-0335"]
[null,"02-0345"]
[null,"02-0350"]
[null,"02-0356"]
[null,"02-0360"]
[null,"02-0361"]
[null,"02-0387"]
[null,"03-0002"]
[null,"03-0004"]
[null,"03-0005"]
[null,"03-0007"]
[null,"03-0010"]
[null,"03-0013"]
[null,"03-0018"]
[null,"03-0022"]
[null,"03-0029"]
[null,"03-0041"]
[null,"03-0042"]
[null,"03-0054"]
[null,"03-0055"]
[null,"03-0061"]
[null,"03-0062"]
[null,"03-0064"]
[null,"03-0066"]
[null,"03-0068"]
[null,"03-0076"]
[null,"03-0077"]
[null,"03-0078"]
[null,"03-0081"]
[null,"03-0093"]
[null,"03-0096"]
[null,"03-0097"]
[null,"03-0099"]
[null,"03-0109"]
[null,"03-0112"]
[null,"03-0128"]
[null,"03-0144"]
[null,"03-0149"]
[null,"03-0152"]
[null,"03-0153"]
[null,"03-0154"]
[null,"03-0182"]
[null,"03-0183"]
[null,"03-0207"]
[null,"03-0208"]
[null,"03-0209"]
[null,"03-0220"]
[null,"03-0223"]
[null,"03-0233"]
[null,"03-0234"]
[null,"03-0236"]
[null,"03-0240"]
[null,"03-0270"]
[null,"03-0272"]
[null,"03-0276"]
[null,"03-0278"]
[null,"03-0295"]
[null,"03-0300"]
[null,"03-0304"]
[null,"03-0313"]
[null,"03-0315"]
[null,"03-0317"]
[null,"03-0338"]
[null,"03-0339"]
[null,"03-0363"]
[null,"03-0364"]
[null,"04-0009"]
[null,"04-0026"]
[null,"04-0028"]
[null,"04-0057"]
[null,"04-0080"]
[null,"04-0123"]
[null,"04-0129"]
[null,"04-0134"]
[null,"04-0138"]
[null,"04-0185"]
[null,"04-0186"]
[null,"04-0187"]
[null,"04-0196"]
[null,"04-0210"]
[null,"04-0230"]
[null,"04-0237"]
[null,"04-0253"]
[null,"04-0256"]
[null,"04-0273"]
[null,"04-0277"]
[null,"04-0279"]
[null,"04-0282"]
[null,"04-0283"]
[null,"04-0288"]
[null,"04-0306"]
[null,"04-0308"]
[null,"04-0324"]
[null,"04-0344"]
[null,"04-0354"]
[null,"04-0357"]
[null,"04-0358"]
[null,"04-0359"]
[null,"04-0367"]
[null,"04-0368"]
[null,"04-0369"]
[null,"04-0370"]
[null,"04-0371"]
[null,"04-0374"]
[null,"04-0378"]
[null,"04-0379"]
[null,"04-0380"]
[null,"04-0384"]
[null,"04-0385"]
[null,"04-0386"]
[null,"04-0388"]
[null,"04-0414"]
[null,"06-0012"]
[null,"06-0015"]
[null,"06-0020"]
[null,"06-0049"]
[null,"06-0053"]
[null,"06-0110"]
[null,"06-0111"]
[null,"06-0118"]
[null,"06-0191"]
[null,"06-0193"]
[null,"06-0195"]
[null,"06-0198"]
[null,"06-0201"]
[null,"06-0204"]
[null,"06-0222"]
[null,"06-0226"]
[null,"06-0235"]
[null,"06-0245"]
[null,"06-0251"]
[null,"06-0255"]
[null,"06-0258"]
[null,"06-0263"]
[null,"06-0269"]
[null,"06-0299"]
[null,"06-0305"]
[null,"06-0312"]
[null,"06-0314"]
[null,"06-0329"]
[null,"06-0334"]
[null,"06-0336"]
[null,"06-0340"]
[null,"06-0346"]
[null,"06-0348"]
[null,"06-0349"]
[null,"06-0353"]
[null,"06-0376"]
[null,"06-0377"]
[null,"06-0382"]
[null,"06-0383"]
[null,"06-0480"]
[null,"06-0481"]
[null,"06-0482"]
[null,"06-0501"]
[null,"06-0507"]
[null,"06-0512"]
[null,"06-0538"]
[null,"07-0159"]
[null,"07-0164"]
[null,"07-0168"]
[null,"07-0373"]
[null,"08-0142"]
[null,"09-0302"]
[null,"09-0508"]
[null,"11-0406"]
[null,"11-0411"]
[null,"25-0419"]
[null,"25-0420"]
[null,"25-0426"]
[null,"25-0427"]
[null,"25-0432"]
[null,"25-0435"]
[null,"25-0440"]
[null,"25-0441"]
[null,"25-0442"]
[null,"25-0444"]
[null,"25-0445"]
[null,"25-0447"]
[null,"25-0448"]
[null,"25-0454"]
[null,"25-0462"]
[null,"25-0466"]
[null,"25-0467"]
[null,"25-0468"]
[null,"25-0487"]
[null,"25-0498"]
[null,"99-0001"]

{"sheet":"Rate 44","index":5,"n_rows":303,"n_cols":21,"rows_kept":303,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Oil & Gas (Capacity) Service - Rate 44"]
[null,{"$f":"EffectiveDate","v":"FortisAlberta Inc. 2017 Rates, effective January 1, 2017"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Minimum",null,"Minimum"]
[null,"User input area:",null,null,null,null,null,null,null,null,null,null,"Demand",null,"Charge"]
[null,"Demand (kW of capacity)",null,null,{"$f":"Main!F18","v":0},null,"kWh delivered",null,null,null,{"$f":"E6*730*E7","v":0},null,"Input",null,{"$f":"O20","v":123.65},null,null,{"$f":"E20","v":36.86},null,null,{"$f":"G20","v":86.78}]
[null,"Load Factor",null,null,0,null,null,null,null,null,null,null,{"$f":"Main!D18","v":95.3},0,3088.1000000000004,null,{"$f":"M7","v":95.3},1171.07,null,{"$f":"Q7","v":95.3},1917.01]
[null,"Number of days in Consumption Period",null,null,{"$f":"365/12","v":30.416666666666668},null,null,null,null,null,null,null,{"$f":"Main!F18","v":0},0,123.65,null,{"$f":"M8","v":0},36.86,null,{"$f":"Q8","v":0},86.78]
[null,"Municipal Code",null,null,"99-0001"]
[null,"Epcor RRO rider (daily amount)",null,null,0]
[]
[]
[null,"BASE CHARGES","Generation",null,"Transmission",null,"Distribution",null,"Retail",null,null,null,"Units",null,"Charges"]
[null,"Energy Charges"]
[null,"     all kWh",0,null,null,null,null,null,null,null,null,null,{"$f":"K6","v":0},null,{"$f":"ROUND((SUM(C15:G15)*M15/100),2)","v":0}]
[null,"Capacity Charges"]
[null,"     first 3 kW",null,null,0.40400000000000003,null,0.95104999999999995,null,null,null,null,null,3,null,{"$f":"ROUND((((E17*M17)+(G17*M17))*$E$8),2)","v":123.65}]
[null,"     Next 12 kW",null,null,0.40400000000000003,null,0.68476999999999999,null,null,null,null,null,{"$f":"MIN(MAX(E6-3,0),12)","v":0},null,{"$f":"ROUND((((E18*M18)+(G18*M18))*$E$8),2)","v":0}]
[null,"     all remaining",null,null,0.40400000000000003,null,0.64700999999999997,null,null,null,null,null,{"$f":"MAX(E6-15,0)","v":0},null,{"$f":"ROUND((((E19*M19)+(G19*M19))*E8),2)","v":0}]
[null,"Total Base Charges",{"$f":"C15*M15/100","v":0},null,{"$f":"ROUNDDOWN((E15*$M15/100*$E8),2)+ROUNDDOWN((E17*$M17*$E8),2)+ROUND((E18*$M18*$E8),2)+ROUND((E19*$M19*$E8),2)","v":36.86},null,{"$f":"ROUND((G15*$M15/100*$E8),2)+ROUND((G17*$M17*$E8),2)+ROUND((G18*$M18*$E8),2)+ROUND((G19*$M19*$E8),2)","v":86.78},null,null,null,null,null,null,null,{"$f":"SUM(O15:O19)","v":123.65}]
[]
[null,"RIDERS","G Riders",null,"T Riders",null,"D Riders",null,null,null,"Other Riders"]
[null,"2001 EESAI RRO Shortfall Rider ",null,null,null,null,null,null,null,null,{"$f":"E10","v":0},null,{"$f":"E8","v":30.416666666666668},null,{"$f":"ROUND((K23*M23/100),2)","v":0}]
[null,"Municipal Assessment Rider A-1",null,null,null,null,0,null,null,null,null,null,{"$f":"E20+G20","v":123.64},null,{"$f":"ROUND((G24*M24),2)","v":0}]
[null,"Municipal Franchise (Local Access) Fee",null,null,null,null,null,null,null,null,0,null,{"$f":"E20+G20","v":123.64},null,{"$f":"ROUND((K25*M25),2)","v":0}]
[null,"Total Riders",null,null,null,null,{"$f":"ROUND((G23*M23/100),2)+ROUND((G24*M24),2)+ROUND((G25*M25),2)","v":0},null,null,null,{"$f":"ROUND((K23*M23/100),2)+ROUND((K24*M24),2)+ROUND((K25*M25),2)","v":0},null,null,null,{"$f":"SUM(O23:O25)","v":0}]
[]
[null,"Final Charges",{"$f":"C20+C26","v":0},null,{"$f":"E20+E26","v":36.86},null,{"$f":"G20+G26","v":86.78},null,{"$f":"I20+I26","v":0},null,{"$f":"K20+K26","v":0},null,null,null,{"$f":"SUM(O20:O25)","v":123.65}]
[]
[null,"Percentage of Total Charges",{"$f":"C28/O28","v":0},null,{"$f":"E28/O28","v":0.29809947432268497},null,{"$f":"G28/O28","v":0.7018196522442377},null,{"$f":"I28/O28","v":0},null,{"$f":"K28/O28","v":0},null,null,null,{"$f":"O28/O28","v":1}]
[]
[]
[]
[]
[]
[]
[]
[null,"01-0003"]
[null,"01-0046"]
[null,"01-0048"]
[null,"01-0098"]
[null,"01-0117"]
[null,"01-0200"]
[null,"01-0203"]
[null,"01-0291"]
[null,"01-0292"]
[null,"01-0347"]
[null,"02-0011"]
[null,"02-0014"]
[null,"02-0016"]
[null,"02-0017"]
[null,"02-0019"]
[null,"02-0024"]
[null,"02-0030"]
[null,"02-0031"]
[null,"02-0034"]
[null,"02-0039"]
[null,"02-0040"]
[null,"02-0043"]
[null,"02-0044"]
[null,"02-0047"]
[null,"02-0050"]
[null,"02-0052"]
[null,"02-0056"]
[null,"02-0065"]
[null,"02-0069"]
[null,"02-0070"]
[null,"02-0079"]
[null,"02-0082"]
[null,"02-0086"]
[null,"02-0088"]
[null,"02-0091"]
[null,"02-0095"]
[null,"02-0100"]
[null,"02-0115"]
[null,"02-0124"]
[null,"02-0135"]
[null,"02-0143"]
[null,"02-0148"]
[null,"02-0151"]
[null,"02-0180"]
[null,"02-0188"]
[null,"02-0192"]
[null,"02-0194"]
[null,"02-0197"]
[null,"02-0202"]
[null,"02-0211"]
[null,"02-0215"]
[null,"02-0218"]
[null,"02-0219"]
[null,"02-0224"]
[null,"02-0232"]
[null,"02-0238"]
[null,"02-0239"]
[null,"02-0248"]
[null,"02-0249"]
[null,"02-0250"]
[null,"02-0254"]
[null,"02-0257"]
[null,"02-0261"]
[null,"02-0265"]
[null,"02-0266"]
[null,"02-0268"]
[null,"02-0280"]
[null,"02-0297"]
[null,"02-0301"]
[null,"02-0303"]
[null,"02-0307"]
[null,"02-0310"]
[null,"02-0311"]
[null,"02-0318"]
[null,"02-0321"]
[null,"02-0326"]
[null,"02-0331"]
[null,"02-0333"]
[null,"02-0335"]
[null,"02-0345"]
[null,"02-0350"]
[null,"02-0356"]
[null,"02-0360"]
[null,"02-0361"]
[null,"02-0387"]
[null,"03-0002"]
[null,"03-0004"]
[null,"03-0005"]
[null,"03-0007"]
[null,"03-0010"]
[null,"03-0013"]
[null,"03-0018"]
[null,"03-0022"]
[null,"03-0029"]
[null,"03-0041"]
[null,"03-0042"]
[null,"03-0054"]
[null,"03-0055"]
[null,"03-0061"]
[null,"03-0062"]
[null,"03-0064"]
[null,"03-0066"]
[null,"03-0068"]
[null,"03-0076"]
[null,"03-0077"]
[null,"03-0078"]
[null,"03-0081"]
[null,"03-0093"]
[null,"03-0096"]
[null,"03-0097"]
[null,"03-0099"]
[null,"03-0109"]
[null,"03-0112"]
[null,"03-0128"]
[null,"03-0144"]
[null,"03-0149"]
[null,"03-0152"]
[null,"03-0153"]
[null,"03-0154"]
[null,"03-0182"]
[null,"03-0183"]
[null,"03-0207"]
[null,"03-0208"]
[null,"03-0209"]
[null,"03-0220"]
[null,"03-0223"]
[null,"03-0233"]
[null,"03-0234"]
[null,"03-0236"]
[null,"03-0240"]
[null,"03-0270"]
[null,"03-0272"]
[null,"03-0276"]
[null,"03-0278"]
[null,"03-0295"]
[null,"03-0300"]
[null,"03-0304"]
[null,"03-0313"]
[null,"03-0315"]
[null,"03-0317"]
[null,"03-0338"]
[null,"03-0339"]
[null,"03-0363"]
[null,"03-0364"]
[null,"04-0009"]
[null,"04-0026"]
[null,"04-0028"]
[null,"04-0057"]
[null,"04-0080"]
[null,"04-0123"]
[null,"04-0129"]
[null,"04-0134"]
[null,"04-0138"]
[null,"04-0185"]
[null,"04-0186"]
[null,"04-0187"]
[null,"04-0196"]
[null,"04-0210"]
[null,"04-0230"]
[null,"04-0237"]
[null,"04-0253"]
[null,"04-0256"]
[null,"04-0273"]
[null,"04-0277"]
[null,"04-0279"]
[null,"04-0282"]
[null,"04-0283"]
[null,"04-0288"]
[null,"04-0306"]
[null,"04-0308"]
[null,"04-0324"]
[null,"04-0344"]
[null,"04-0354"]
[null,"04-0357"]
[null,"04-0358"]
[null,"04-0359"]
[null,"04-0367"]
[null,"04-0368"]
[null,"04-0369"]
[null,"04-0370"]
[null,"04-0371"]
[null,"04-0374"]
[null,"04-0378"]
[null,"04-0379"]
[null,"04-0380"]
[null,"04-0384"]
[null,"04-0385"]
[null,"04-0386"]
[null,"04-0388"]
[null,"04-0414"]
[null,"06-0012"]
[null,"06-0015"]
[null,"06-0020"]
[null,"06-0049"]
[null,"06-0053"]
[null,"06-0110"]
[null,"06-0111"]
[null,"06-0118"]
[null,"06-0191"]
[null,"06-0193"]
[null,"06-0195"]
[null,"06-0198"]
[null,"06-0201"]
[null,"06-0204"]
[null,"06-0222"]
[null,"06-0226"]
[null,"06-0235"]
[null,"06-0245"]
[null,"06-0251"]
[null,"06-0255"]
[null,"06-0258"]
[null,"06-0263"]
[null,"06-0269"]
[null,"06-0299"]
[null,"06-0305"]
[null,"06-0312"]
[null,"06-0314"]
[null,"06-0329"]
[null,"06-0334"]
[null,"06-0336"]
[null,"06-0340"]
[null,"06-0346"]
[null,"06-0348"]
[null,"06-0349"]
[null,"06-0353"]
[null,"06-0376"]
[null,"06-0377"]
[null,"06-0382"]
[null,"06-0383"]
[null,"06-0480"]
[null,"06-0481"]
[null,"06-0482"]
[null,"06-0501"]
[null,"06-0507"]
[null,"06-0512"]
[null,"06-0538"]
[null,"07-0159"]
[null,"07-0164"]
[null,"07-0168"]
[null,"07-0373"]
[null,"08-0142"]
[null,"09-0302"]
[null,"09-0508"]
[null,"11-0406"]
[null,"11-0411"]
[null,"25-0419"]
[null,"25-0420"]
[null,"25-0426"]
[null,"25-0427"]
[null,"25-0432"]
[null,"25-0435"]
[null,"25-0440"]
[null,"25-0441"]
[null,"25-0442"]
[null,"25-0444"]
[null,"25-0445"]
[null,"25-0447"]
[null,"25-0448"]
[null,"25-0454"]
[null,"25-0462"]
[null,"25-0466"]
[null,"25-0467"]
[null,"25-0468"]
[null,"25-0487"]
[null,"25-0498"]
[null,"99-0001"]

{"sheet":"Rate 45","index":6,"n_rows":316,"n_cols":21,"rows_kept":316,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Oil & Gas (Energy) Service - Rate 45"]
[null,{"$f":"EffectiveDate","v":"FortisAlberta Inc. 2017 Rates, effective January 1, 2017"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Minimum",null,"Minimum"]
[null,"User input area:",null,null,null,null,null,null,null,null,null,null,"Demand",null,"Charge"]
[null,"Demand (kW of capacity)",null,null,{"$f":"Main!F18","v":0},null,"kWh delivered",null,null,null,{"$f":"E6*730*E7","v":0},null,"Input",null,{"$f":"O20","v":18.96},null,null,{"$f":"E20","v":0},null,null,{"$f":"G20","v":18.96}]
[null,"Load Factor",null,null,0,null,null,null,null,null,null,null,{"$f":"Main!D18","v":95.3},0,3504.27,null,{"$f":"M7","v":95.3},1090.71,null,{"$f":"Q7","v":95.3},2413.5700000000002]
[null,"Number of days in Consumption Period",null,null,{"$f":"365/12","v":30.416666666666668},null,null,null,null,null,null,null,{"$f":"Main!F18","v":0},0,17.850000000000001,null,{"$f":"M8","v":0},0,null,{"$f":"Q8","v":0},17.850000000000001]
[null,"Municipal Code",null,null,"99-0001"]
[null,"Epcor RRO rider (daily amount)",null,null,0]
[]
[]
[null,"BASE CHARGES","Generation",null,"Transmission",null,"Distribution",null,"Retail",null,null,null,"Units",null,"Charges"]
[null,"Energy Charges"]
[null,"     all kWh",0,null,0.52739999999999998,null,null,null,null,null,null,null,{"$f":"K6","v":0},null,{"$f":"ROUND((SUM(C15:G15)*M15/100),2)","v":0}]
[null,"Capacity Charges"]
[null,"     All kW",null,null,0.35745399999999999,null,0.87748599999999999,null,null,null,null,null,{"$f":"E6","v":0},null,{"$f":"ROUND((((E17*M17)+(G17*M17))*$E$8),2)","v":0}]
[null,"Service Charge",null,null,null,null,0.62321499999999996,null,null,null,null,null,{"$f":"E8","v":30.416666666666668},null,{"$f":"ROUND(G18*M18,2)","v":18.96}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND((((E19*M19)+(G19*M19))*E8),2)","v":0}]
[null,"Total Base Charges",{"$f":"C15*M15/100","v":0},null,{"$f":"ROUND(E17*$M$17*$E$8+E18*$M$18,2)","v":0},null,{"$f":"ROUND(G17*$M$17*$E$8+G18*$M$18,2)","v":18.96},null,null,null,null,null,null,null,{"$f":"SUM(O15:O19)","v":18.96}]
[]
[null,"RIDERS","G Riders",null,"T Riders",null,"D Riders",null,null,null,"Other Riders"]
[null,"2001 EESAI RRO Shortfall Rider ",null,null,null,null,null,null,null,null,{"$f":"E10","v":0},null,{"$f":"E8","v":30.416666666666668},null,{"$f":"ROUND((K23*M23/100),2)","v":0}]
[null,"Municipal Assessment Rider A-1",null,null,null,null,0,null,null,null,null,null,{"$f":"E20+G20","v":18.96},null,{"$f":"ROUND((G24*M24),2)","v":0}]
[null,"Municipal Franchise (Local Access) Fee",null,null,null,null,null,null,null,null,0,null,{"$f":"E20+G20","v":18.96},null,{"$f":"ROUND((K25*M25),2)","v":0}]
[null,"Total Riders",null,null,null,null,{"$f":"ROUND((G23*M23/100),2)+ROUND((G24*M24),2)+ROUND((G25*M25),2)","v":0},null,null,null,{"$f":"ROUND((K23*M23/100),2)+ROUND((K24*M24),2)+ROUND((K25*M25),2)","v":0},null,null,null,{"$f":"SUM(O23:O25)","v":0}]
[]
[null,"Final Charges",{"$f":"C20+C26","v":0},null,{"$f":"E20+E26","v":0},null,{"$f":"G20+G26","v":18.96},null,{"$f":"I20+I26","v":0},null,{"$f":"K20+K26","v":0},null,null,null,{"$f":"SUM(O20:O25)","v":18.96}]
[]
[null,"Percentage of Total Charges",{"$f":"C28/O28","v":0},null,{"$f":"E28/O28","v":0},null,{"$f":"G28/O28","v":1},null,{"$f":"I28/O28","v":0},null,{"$f":"K28/O28","v":0},null,null,null,{"$f":"O28/O28","v":1}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"01-0003"]
[null,"01-0046"]
[null,"01-0048"]
[null,"01-0098"]
[null,"01-0117"]
[null,"01-0200"]
[null,"01-0203"]
[null,"01-0291"]
[null,"01-0292"]
[null,"01-0347"]
[null,"02-0011"]
[null,"02-0014"]
[null,"02-0016"]
[null,"02-0017"]
[null,"02-0019"]
[null,"02-0024"]
[null,"02-0030"]
[null,"02-0031"]
[null,"02-0034"]
[null,"02-0039"]
[null,"02-0040"]
[null,"02-0043"]
[null,"02-0044"]
[null,"02-0047"]
[null,"02-0050"]
[null,"02-0052"]
[null,"02-0056"]
[null,"02-0065"]
[null,"02-0069"]
[null,"02-0070"]
[null,"02-0079"]
[null,"02-0082"]
[null,"02-0086"]
[null,"02-0088"]
[null,"02-0091"]
[null,"02-0095"]
[null,"02-0100"]
[null,"02-0115"]
[null,"02-0124"]
[null,"02-0135"]
[null,"02-0143"]
[null,"02-0148"]
[null,"02-0151"]
[null,"02-0180"]
[null,"02-0188"]
[null,"02-0192"]
[null,"02-0194"]
[null,"02-0197"]
[null,"02-0202"]
[null,"02-0211"]
[null,"02-0215"]
[null,"02-0218"]
[null,"02-0219"]
[null,"02-0224"]
[null,"02-0232"]
[null,"02-0238"]
[null,"02-0239"]
[null,"02-0248"]
[null,"02-0249"]
[null,"02-0250"]
[null,"02-0254"]
[null,"02-0257"]
[null,"02-0261"]
[null,"02-0265"]
[null,"02-0266"]
[null,"02-0268"]
[null,"02-0280"]
[null,"02-0297"]
[null,"02-0301"]
[null,"02-0303"]
[null,"02-0307"]
[null,"02-0310"]
[null,"02-0311"]
[null,"02-0318"]
[null,"02-0321"]
[null,"02-0326"]
[null,"02-0331"]
[null,"02-0333"]
[null,"02-0335"]
[null,"02-0345"]
[null,"02-0350"]
[null,"02-0356"]
[null,"02-0360"]
[null,"02-0361"]
[null,"02-0387"]
[null,"03-0002"]
[null,"03-0004"]
[null,"03-0005"]
[null,"03-0007"]
[null,"03-0010"]
[null,"03-0013"]
[null,"03-0018"]
[null,"03-0022"]
[null,"03-0029"]
[null,"03-0041"]
[null,"03-0042"]
[null,"03-0054"]
[null,"03-0055"]
[null,"03-0061"]
[null,"03-0062"]
[null,"03-0064"]
[null,"03-0066"]
[null,"03-0068"]
[null,"03-0076"]
[null,"03-0077"]
[null,"03-0078"]
[null,"03-0081"]
[null,"03-0093"]
[null,"03-0096"]
[null,"03-0097"]
[null,"03-0099"]
[null,"03-0109"]
[null,"03-0112"]
[null,"03-0128"]
[null,"03-0144"]
[null,"03-0149"]
[null,"03-0152"]
[null,"03-0153"]
[null,"03-0154"]
[null,"03-0182"]
[null,"03-0183"]
[null,"03-0207"]
[null,"03-0208"]
[null,"03-0209"]
[null,"03-0220"]
[null,"03-0223"]
[null,"03-0233"]
[null,"03-0234"]
[null,"03-0236"]
[null,"03-0240"]
[null,"03-0270"]
[null,"03-0272"]
[null,"03-0276"]
[null,"03-0278"]
[null,"03-0295"]
[null,"03-0300"]
[null,"03-0304"]
[null,"03-0313"]
[null,"03-0315"]
[null,"03-0317"]
[null,"03-0338"]
[null,"03-0339"]
[null,"03-0363"]
[null,"03-0364"]
[null,"04-0009"]
[null,"04-0026"]
[null,"04-0028"]
[null,"04-0057"]
[null,"04-0080"]
[null,"04-0123"]
[null,"04-0129"]
[null,"04-0134"]
[null,"04-0138"]
[null,"04-0185"]
[null,"04-0186"]
[null,"04-0187"]
[null,"04-0196"]
[null,"04-0210"]
[null,"04-0230"]
[null,"04-0237"]
[null,"04-0253"]
[null,"04-0256"]
[null,"04-0273"]
[null,"04-0277"]
[null,"04-0279"]
[null,"04-0282"]
[null,"04-0283"]
[null,"04-0288"]
[null,"04-0306"]
[null,"04-0308"]
[null,"04-0324"]
[null,"04-0344"]
[null,"04-0354"]
[null,"04-0357"]
[null,"04-0358"]
[null,"04-0359"]
[null,"04-0367"]
[null,"04-0368"]
[null,"04-0369"]
[null,"04-0370"]
[null,"04-0371"]
[null,"04-0374"]
[null,"04-0378"]
[null,"04-0379"]
[null,"04-0380"]
[null,"04-0384"]
[null,"04-0385"]
[null,"04-0386"]
[null,"04-0388"]
[null,"04-0414"]
[null,"06-0012"]
[null,"06-0015"]
[null,"06-0020"]
[null,"06-0049"]
[null,"06-0053"]
[null,"06-0110"]
[null,"06-0111"]
[null,"06-0118"]
[null,"06-0191"]
[null,"06-0193"]
[null,"06-0195"]
[null,"06-0198"]
[null,"06-0201"]
[null,"06-0204"]
[null,"06-0222"]
[null,"06-0226"]
[null,"06-0235"]
[null,"06-0245"]
[null,"06-0251"]
[null,"06-0255"]
[null,"06-0258"]
[null,"06-0263"]
[null,"06-0269"]
[null,"06-0299"]
[null,"06-0305"]
[null,"06-0312"]
[null,"06-0314"]
[null,"06-0329"]
[null,"06-0334"]
[null,"06-0336"]
[null,"06-0340"]
[null,"06-0346"]
[null,"06-0348"]
[null,"06-0349"]
[null,"06-0353"]
[null,"06-0376"]
[null,"06-0377"]
[null,"06-0382"]
[null,"06-0383"]
[null,"06-0480"]
[null,"06-0481"]
[null,"06-0482"]
[null,"06-0501"]
[null,"06-0507"]
[null,"06-0512"]
[null,"06-0538"]
[null,"07-0159"]
[null,"07-0164"]
[null,"07-0168"]
[null,"07-0373"]
[null,"08-0142"]
[null,"09-0302"]
[null,"09-0508"]
[null,"11-0406"]
[null,"11-0411"]
[null,"25-0419"]
[null,"25-0420"]
[null,"25-0426"]
[null,"25-0427"]
[null,"25-0432"]
[null,"25-0435"]
[null,"25-0440"]
[null,"25-0441"]
[null,"25-0442"]
[null,"25-0444"]
[null,"25-0445"]
[null,"25-0447"]
[null,"25-0448"]
[null,"25-0454"]
[null,"25-0462"]
[null,"25-0466"]
[null,"25-0467"]
[null,"25-0468"]
[null,"25-0487"]
[null,"25-0498"]
[null,"99-0001"]

{"sheet":"Rate 61","index":7,"n_rows":300,"n_cols":21,"rows_kept":300,"cut":false,"hidden":true,"merged":[]}
[]
[null,"General Service - Rate 61"]
[null,{"$f":"EffectiveDate","v":"FortisAlberta Inc. 2017 Rates, effective January 1, 2017"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Minimum",null,"Minimum"]
[null,"User input area:",null,null,null,null,null,null,null,null,null,null,"Demand",null,"Charge"]
[null,"Demand (kW of capacity)",null,null,{"$f":"Main!F18","v":0},null,"kWh delivered",null,null,null,{"$f":"E6*730*E7","v":0},null,"Input",null,{"$f":"O20","v":36.770000000000003},null,null,{"$f":"E20","v":0},null,null,{"$f":"G20","v":36.770000000000003}]
[null,"Load Factor",null,null,0,null,null,null,null,null,null,null,{"$f":"Main!D18","v":95.3},0,775.75,null,{"$f":"M7","v":95.3},468.24,null,{"$f":"Q7","v":95.3},307.51]
[null,"Number of days in Consumption Period",null,null,{"$f":"365/12","v":30.416666666666668},null,null,null,null,null,null,null,{"$f":"Main!F18","v":0},0,34.64,null,{"$f":"M8","v":0},0,null,{"$f":"Q8","v":0},34.64]
[null,"Municipal Code",null,null,"99-0001"]
[]
[]
[null,"BASE CHARGES","Generation",null,"Transmission",null,"Distribution",null,"Retail",null,null,null,"Units",null,"Charges"]
[null,"Energy Charge (¢/kWh)"]
[null,"     all kWh consumed",0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND((SUM(C14:G14)*M14/100),2)","v":0}]
[null,"Capacity Charges ($)"]
[null,"     All kW",null,null,0.142876,null,9.992899999999999E-2,null,null,null,null,null,{"$f":"IF(E6=0,0,IF(E6<50,50,E6))","v":0},null,{"$f":"ROUND(((E16+G16)*M16*E$8),2)","v":0}]
[null,"Service Charge",null,null,null,null,1.208901,null,null,null,null,null,{"$f":"E8","v":30.416666666666668},null,{"$f":"ROUND(G17*M17,2)","v":36.770000000000003}]
[]
[]
[null,"Total Base Charges",{"$f":"C14*M14/100","v":0},null,{"$f":"ROUND(E16*$M$16*$E$8+E17*$M$17,2)","v":0},null,{"$f":"ROUND(G16*$M$16*$E$8+G17*$M$17,2)","v":36.770000000000003},null,{"$f":"(I14*M14/100)","v":0},null,null,null,null,null,{"$f":"SUM(O14:O19)","v":36.770000000000003}]
[]
[null,"RIDERS","G Riders",null,"T Riders",null,"D Riders",null,null,null,"Other Riders"]
[null,"Municipal Assessment Rider A-1",null,null,null,null,0,null,null,null,null,null,{"$f":"E20+G20","v":36.770000000000003},null,{"$f":"ROUND((M23*G23),2)","v":0}]
[null,"Municipal Franchise (Local Access) Fee",null,null,null,null,null,null,null,null,0,null,{"$f":"E20+G20","v":36.770000000000003},null,{"$f":"ROUND((K24*M24),2)","v":0}]
[null,"Total Riders",null,null,null,null,{"$f":"ROUND((G23*M23),2)+ROUND((G24*M24),2)","v":0},null,null,null,{"$f":"ROUND((K23*M23),2)+ROUND((K24*M24),2)","v":0},null,null,null,{"$f":"SUM(O23:O24)","v":0}]
[]
[null,"Final Charges",{"$f":"C20+C25","v":0},null,{"$f":"E20+E25","v":0},null,{"$f":"G20+G25","v":36.770000000000003},null,{"$f":"I20+I25","v":0},null,{"$f":"K20+K25","v":0},null,null,null,{"$f":"SUM(O20:O24)","v":36.770000000000003}]
[]
[null,"Percentage of Total Charges",{"$f":"C27/O27","v":0},null,{"$f":"E27/O27","v":0},null,{"$f":"G27/O27","v":1},null,{"$f":"I27/O27","v":0},null,{"$f":"K27/O27","v":0},null,null,null,{"$f":"O27/O27","v":1}]
[]
[]
[]
[]
[]
[null,"01-0003"]
[null,"01-0046"]
[null,"01-0048"]
[null,"01-0098"]
[null,"01-0117"]
[null,"01-0200"]
[null,"01-0203"]
[null,"01-0291"]
[null,"01-0292"]
[null,"01-0347"]
[null,"02-0011"]
[null,"02-0014"]
[null,"02-0016"]
[null,"02-0017"]
[null,"02-0019"]
[null,"02-0024"]
[null,"02-0030"]
[null,"02-0031"]
[null,"02-0034"]
[null,"02-0039"]
[null,"02-0040"]
[null,"02-0043"]
[null,"02-0044"]
[null,"02-0047"]
[null,"02-0050"]
[null,"02-0052"]
[null,"02-0056"]
[null,"02-0065"]
[null,"02-0069"]
[null,"02-0070"]
[null,"02-0079"]
[null,"02-0082"]
[null,"02-0086"]
[null,"02-0088"]
[null,"02-0091"]
[null,"02-0095"]
[null,"02-0100"]
[null,"02-0115"]
[null,"02-0124"]
[null,"02-0135"]
[null,"02-0143"]
[null,"02-0148"]
[null,"02-0151"]
[null,"02-0180"]
[null,"02-0188"]
[null,"02-0192"]
[null,"02-0194"]
[null,"02-0197"]
[null,"02-0202"]
[null,"02-0211"]
[null,"02-0215"]
[null,"02-0218"]
[null,"02-0219"]
[null,"02-0224"]
[null,"02-0232"]
[null,"02-0238"]
[null,"02-0239"]
[null,"02-0248"]
[null,"02-0249"]
[null,"02-0250"]
[null,"02-0254"]
[null,"02-0257"]
[null,"02-0261"]
[null,"02-0265"]
[null,"02-0266"]
[null,"02-0268"]
[null,"02-0280"]
[null,"02-0297"]
[null,"02-0301"]
[null,"02-0303"]
[null,"02-0307"]
[null,"02-0310"]
[null,"02-0311"]
[null,"02-0318"]
[null,"02-0321"]
[null,"02-0326"]
[null,"02-0331"]
[null,"02-0333"]
[null,"02-0335"]
[null,"02-0345"]
[null,"02-0350"]
[null,"02-0356"]
[null,"02-0360"]
[null,"02-0361"]
[null,"02-0387"]
[null,"03-0002"]
[null,"03-0004"]
[null,"03-0005"]
[null,"03-0007"]
[null,"03-0010"]
[null,"03-0013"]
[null,"03-0018"]
[null,"03-0022"]
[null,"03-0029"]
[null,"03-0041"]
[null,"03-0042"]
[null,"03-0054"]
[null,"03-0055"]
[null,"03-0061"]
[null,"03-0062"]
[null,"03-0064"]
[null,"03-0066"]
[null,"03-0068"]
[null,"03-0076"]
[null,"03-0077"]
[null,"03-0078"]
[null,"03-0081"]
[null,"03-0093"]
[null,"03-0096"]
[null,"03-0097"]
[null,"03-0099"]
[null,"03-0109"]
[null,"03-0112"]
[null,"03-0128"]
[null,"03-0144"]
[null,"03-0149"]
[null,"03-0152"]
[null,"03-0153"]
[null,"03-0154"]
[null,"03-0182"]
[null,"03-0183"]
[null,"03-0207"]
[null,"03-0208"]
[null,"03-0209"]
[null,"03-0220"]
[null,"03-0223"]
[null,"03-0233"]
[null,"03-0234"]
[null,"03-0236"]
[null,"03-0240"]
[null,"03-0270"]
[null,"03-0272"]
[null,"03-0276"]
[null,"03-0278"]
[null,"03-0295"]
[null,"03-0300"]
[null,"03-0304"]
[null,"03-0313"]
[null,"03-0315"]
[null,"03-0317"]
[null,"03-0338"]
[null,"03-0339"]
[null,"03-0363"]
[null,"03-0364"]
[null,"04-0009"]
[null,"04-0026"]
[null,"04-0028"]
[null,"04-0057"]
[null,"04-0080"]
[null,"04-0123"]
[null,"04-0129"]
[null,"04-0134"]
[null,"04-0138"]
[null,"04-0185"]
[null,"04-0186"]
[null,"04-0187"]
[null,"04-0196"]
[null,"04-0210"]
[null,"04-0230"]
[null,"04-0237"]
[null,"04-0253"]
[null,"04-0256"]
[null,"04-0273"]
[null,"04-0277"]
[null,"04-0279"]
[null,"04-0282"]
[null,"04-0283"]
[null,"04-0288"]
[null,"04-0306"]
[null,"04-0308"]
[null,"04-0324"]
[null,"04-0344"]
[null,"04-0354"]
[null,"04-0357"]
[null,"04-0358"]
[null,"04-0359"]
[null,"04-0367"]
[null,"04-0368"]
[null,"04-0369"]
[null,"04-0370"]
[null,"04-0371"]
[null,"04-0374"]
[null,"04-0378"]
[null,"04-0379"]
[null,"04-0380"]
[null,"04-0384"]
[null,"04-0385"]
[null,"04-0386"]
[null,"04-0388"]
[null,"04-0414"]
[null,"06-0012"]
[null,"06-0015"]
[null,"06-0020"]
[null,"06-0049"]
[null,"06-0053"]
[null,"06-0110"]
[null,"06-0111"]
[null,"06-0118"]
[null,"06-0191"]
[null,"06-0193"]
[null,"06-0195"]
[null,"06-0198"]
[null,"06-0201"]
[null,"06-0204"]
[null,"06-0222"]
[null,"06-0226"]
[null,"06-0235"]
[null,"06-0245"]
[null,"06-0251"]
[null,"06-0255"]
[null,"06-0258"]
[null,"06-0263"]
[null,"06-0269"]
[null,"06-0299"]
[null,"06-0305"]
[null,"06-0312"]
[null,"06-0314"]
[null,"06-0329"]
[null,"06-0334"]
[null,"06-0336"]
[null,"06-0340"]
[null,"06-0346"]
[null,"06-0348"]
[null,"06-0349"]
[null,"06-0353"]
[null,"06-0376"]
[null,"06-0377"]
[null,"06-0382"]
[null,"06-0383"]
[null,"06-0480"]
[null,"06-0481"]
[null,"06-0482"]
[null,"06-0501"]
[null,"06-0507"]
[null,"06-0512"]
[null,"06-0538"]
[null,"07-0159"]
[null,"07-0164"]
[null,"07-0168"]
[null,"07-0373"]
[null,"08-0142"]
[null,"09-0302"]
[null,"09-0508"]
[null,"11-0406"]
[null,"11-0411"]
[null,"25-0419"]
[null,"25-0420"]
[null,"25-0426"]
[null,"25-0427"]
[null,"25-0432"]
[null,"25-0435"]
[null,"25-0440"]
[null,"25-0441"]
[null,"25-0442"]
[null,"25-0444"]
[null,"25-0445"]
[null,"25-0447"]
[null,"25-0448"]
[null,"25-0454"]
[null,"25-0462"]
[null,"25-0466"]
[null,"25-0467"]
[null,"25-0468"]
[null,"25-0487"]
[null,"25-0498"]
[null,"99-0001"]