{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["A"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":18,"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":"A","index":0,"n_rows":380,"n_cols":44,"rows_kept":380,"cut":false,"hidden":false,"merged":[]}
["Filing Date (enter w/leading '):",null,null,"06/17/2024","2024 Annual Filing"]
["Tariff Entity (4 character COSA code):",null,null,null,null,null,null,"EOPYDate (enter w/leading ')","7/1/2024"]
["Transmittal Number (enter w/leading '):",null,null,null,null,null,null,"Date of Last PCI Update","10/01/2023"]
["Filing Name:"]
[]
["1) Uses multiplicative SBI Upper limits"]
["2) ANALYZER starts in column BT."]
[]
[]
[]
["SUM-1 chart.  Arrow right for next chart. ",null,null,null,null,null,null,null,null,"EXG-1 chart, Page 1.  Arrow down for EXG-2 chart.  Arrow right for next chart.",null,null,null,null,null,null,null,null,null,null,null,"RTE-1 chart'",null,null,null,null,null,null,null,null,null,null,"CAP-1 chart.  Arrow down for additional CAP charts and FOOTNOTES pages.   Arrow right for  ANALYZER.",null,null,null,null,null,null,null,null,"ANALYZER, Page 1 through 2."]
[null,null,null,null,null,null,null,null,null,"Page down 60 for next page.",null,null,null,null,null,null,null,null,null,null,null,"Page down 60 for next page",null,null,null,null,null,null,null,null,null,null,"Page down 60 for next page",null,null,null,null,null,null,null,null,"Page down 60 for next page"]
["To Print, Use Manual Compression = 63% and Landscape Mode.",null,null,null,null,null,null,null,null,"To Print, Use Manual Compression = 63% and Landscape Mode.",null,null,null,null,null,null,null,null,null,null,null,"To Print, Use Manual Compression = 63% and Landscape Mode",null,null,null,null,null,null,null,null,null,null,"To Print, Use Manual Compression = 63% and Landscape Mode"]
[]
["SUM-1",null,null,null,null,null,null,null,null,"EXG-1",null,null,null,null,null,null,null,null,null,null,null,"RTE-1",null,null,null,null,null,null,null,null,null,null,"CAP-1",null,null,null,null,null,null,null,null,"ANALYZER"]
[{"$f":"\"Filing Date:                \"&DATE","v":"Filing Date:                06/17/2024"},null,null,null,null,null,null,null,null,{"$f":"\"Filing Date:                \"&DATE","v":"Filing Date:                06/17/2024"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Filing Date:                \"&DATE","v":"Filing Date:                06/17/2024"},null,null,null,null,null,null,null,null,null,null,{"$f":"\"Filing Date:                \"&DATE","v":"Filing Date:                06/17/2024"},null,null,null,null,null,null,null,null,{"$f":"\"Filing Date:                \"&$D$1","v":"Filing Date:                06/17/2024"}]
[{"$f":"\"Filing Entity:               \"&COSA","v":"Filing Entity:               "},null,null,null,null,null,null,null,null,{"$f":"\"Filing Entity:               \"&COSA","v":"Filing Entity:               "},null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Filing Entity:               \"&COSA","v":"Filing Entity:               "},null,null,null,null,null,null,null,null,null,null,{"$f":"\"Filing Entity:               \"&COSA","v":"Filing Entity:               "},null,null,null,null,null,null,null,null,{"$f":"\"Filing Entity:               \"&$D$2","v":"Filing Entity:               "}]
[{"$f":"\"Transmittal Number:   \"&TRANSMITTAL","v":"Transmittal Number:   "},null,null,null,null,null,null,null,null,{"$f":"\"Transmittal Number:   \"&TRANSMITTAL","v":"Transmittal Number:   "},null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Transmittal Number:   \"&TRANSMITTAL","v":"Transmittal Number:   "},null,null,null,null,null,null,null,null,null,null,{"$f":"\"Transmittal Number:   \"&TRANSMITTAL","v":"Transmittal Number:   "},null,null,"",null,null,null,null,null,{"$f":"\"Transmittal Number:   \"&$D$3","v":"Transmittal Number:   "}]
[{"$f":"NAME","v":0},null,null,null,"Price Caps Tariff Review Plan",null,null,null,null,{"$f":"NAME","v":0},null,null,null,null,"Price Cap Tariff Review Plan",null,null,null,null,null,null,{"$f":"NAME","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"NAME","v":0},null,null,null,null,null,null,null,null,{"$f":"$D$4","v":0}]
["Page 1 of 1",null,null,null,"      Price Out Summary",null,null,null,null,"Page 1 of 1",null,null,null,null,"  Exogenous Cost Changes",null,null,null,null,null,null,"Page 1 of 1",null,null,null,null,"Price Caps Tariff Review Plan",null,null,null,null,null,"Page 1 of 2",null,"Price Cap Tariff Review Plan",null,null,null,null,null,null,"Page 1 of 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Common Line Basket",null,null,null,null,null,null,null,"Calculation of EUCL Limits, PICC Rate and CCL Rates"]
[null,null,null,null,null,null,"BASE PER DMD x",null,null,null,null,null,null,null,null,null,"TRUEUP PRIOR"]
[null,null,null,"BASE PERIOD","","","CURR RATES minus","BASE PER DMD x",null,null,null,null,"REGULA-","EXCESS",null,"REMOVAL OF","SHARING /","CURRENT","TELECOMM.",null,null,null,null,null,null,null,null,null,"BASE PERIOD","BASE PERIOD","BASE PERIOD",null,null,null,null,"Total Jurisdiction","No Zone / Zone A","Zone B","Zone C","Zone D","Other Zone"]
[null,null,null,"DEMAND x","BASE PERIOD","BASE PERIOD","BASE PER DMD x","PROP RATES minus",null,null,null,"SALE OF","TORY","DEFERRED","ITC","LOW END","LOW END","LOW END","RELAY",null,null,null,null,null,"BASE","RATES AT",null,null,"DEMAND x","DEMAND x","DEMAND x",null,null,null,"Source","(a)","(b)","(c)","(d)","(e)","(f)"]
[null,null,null,{"$f":"\"RATES AT \" & MONTH($I$3) & \"/\"& DAY($I$3) & \"/\" & RIGHT(YEAR($I$3),2)","v":"RATES AT 10/1/23"},"DEMAND x","DEMAND x",{"$f":"\"RATES AT \" & MONTH($I$3) & \"/\"& DAY($I$3) & \"/\" & RIGHT(YEAR($I$3),2)","v":"RATES AT 10/1/23"},"BASE PER DMD x",null,null,null,"EXCHANGES","FEES","TAXES","AMORTIZ.","ADJUSTMENT","ADJUSTMENT","ADJUSTMENT","SERVICES","REG/NON-REG",null,null,null,null,"PERIOD",{"$f":" MONTH($I$3) & \"/\"& DAY($I$3) & \"/\" & RIGHT(YEAR($I$3),2) &\" PCI\"","v":"10/1/23 PCI"},"CURRENT","PROPOSED",{"$f":"\"RATES AT \" & MONTH($I$3) & \"/\"& DAY($I$3) & \"/\" & RIGHT(YEAR($I$3),2)","v":"RATES AT 10/1/23"},"CURRENT","PROPOSED","INDEX ","","EUCL Demand Inputs",""]
[null,null,null,"PCI UPDATE","CURRENT RATES","PROPOSED RATES","PCI UPDATE","CURRENT RATES",null,null,null,"-","-","-","-","-","-","-","-","-",null,null,null,null,"DEMAND","UPDATE","RATES","RATES","PCI UPDATE","RATES","RATES","RESULTS",100,"Total Primary Res & SLB & LifeLine Lines","RTE1: b:r102a;c:r112a;d:r122a;e:r132a;f:r142a",{"$f":"SUM(AK26:AO26)","v":0},{"$f":"Y30","v":0},{"$f":"Y37","v":0},{"$f":"Y42","v":0},{"$f":"Y47","v":0},{"$f":"Y52","v":0}]
[null,null,null,"(A)","(B)","(C)","(D) = (B) - (A)","(E) = (C) - (B)",null,null,null,"(A)","(B)","(C)","(D)","(E)","(F)","(G)","(H)","(I)",null,null,null,"-","-","-","-","-","-","-","-","-",110,"Total NonPrim Res & BRI ISDN Lines","RTE1: b:r104a;c:r114a;d:r124a;e:r134a;f:r144a",{"$f":"SUM(AK27:AO27)","v":0},{"$f":"Y31","v":0},{"$f":"Y38","v":0},{"$f":"Y43","v":0},{"$f":"Y48","v":0},{"$f":"Y53","v":0},"EXOGENOUS CHANGES in thousands-------------------------","-"]
["","Common Line Basket",null,null,null,null,null,null,null,"","COMMON LINE  Revenue Effect",null,null,null,null,null,null,null,null,null,null,"","End User Common Line (EUCL)",null,"(A)","(B)","(C)","(D)","(E)","(F)","(G)","(H)",120,"Total MLB&PRI ISDN (include PRI * 5, & Include Centrex)","RTE1: b:r106a;c:r116a;d:r126a;e:r136a;f:r146a",{"$f":"SUM(AK28:AO28)","v":0},{"$f":"Y32","v":0},{"$f":"Y39","v":0},{"$f":"Y44","v":0},{"$f":"Y49","v":0},{"$f":"Y54","v":0},"   Sale of Exchanges",{"$f":"(L29+L32)/1000","v":0}]
[100,"End User Common Line",null,{"$f":"SUM(AC30:AC54)","v":0},{"$f":"SUM(AD30:AD54)","v":0},{"$f":"SUM(AE30:AE54)","v":0},{"$f":"E29-D29","v":0},0,null,160,"Revenue Effects",null,null,null,null,null,null,null,null,null,null,"","No Zone or Zone A:",null,null,null,null,null,null,null,null,null,130,"Total Local Exchange Lines","r100+r110+r120",{"$f":"SUM(AK29:AO29)","v":0},{"$f":"SUM(AK26:AK28)","v":0},{"$f":"SUM(AL26:AL28)","v":0},{"$f":"SUM(AM26:AM28)","v":0},{"$f":"SUM(AN26:AN28)","v":0},{"$f":"SUM(AO26:AO28)","v":0},"   Regulatory Fees",{"$f":"(M29+M32)/1000","v":0}]
[110,"Common Line per MOU",null,{"$f":"SUM(AC63:AC66)","v":0},{"$f":"SUM(AD63:AD66)","v":0},{"$f":"SUM(AE63:AE66)","v":0},0,0,null,"","",null,null,null,null,null,null,null,null,null,null,102,"Primary Res, Single Line Bus, Lifeline EUCL (1)",null,null,null,null,null,{"$f":"Y30*Z30","v":0},{"$f":"Y30*AA30","v":0},{"$f":"Y30*AB30","v":0},"    N/A","","","",null,null,null,null,null,null,"   Excess Deferred Taxes",{"$f":"(N29+N32)/1000","v":0}]
[112,"PICC Common Line",null,{"$f":"SUM(AC59:AC60)","v":0},{"$f":"SUM(AD59:AD60)","v":0},{"$f":"SUM(AE59:AE60)","v":0},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,104,"NonPrimary Residence & BRI ISDN EUCL (1)",null,null,null,null,null,{"$f":"Y31*Z31","v":0},{"$f":"Y31*AA31","v":0},{"$f":"Y31*AB31","v":0},"    N/A","","PICC Demand Inputs","",null,null,null,null,null,null,"   ITC",{"$f":"(O29+O32)/1000","v":0}]
[115,"Other Common Line",null,{"$f":"AC69","v":0},0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,106,"Multiline Bus, PRI ISDN, Centrex EUCL (1)",null,null,null,null,null,{"$f":"Y32*Z32","v":0},{"$f":"Y32*AA32","v":0},{"$f":"Y32*AB32","v":0},"    N/A",200,"Total MLB&PRI ISDN (include PRI * 5, & exclude Centrex)","RTE1r155a",{"$f":"Y59","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A","   Removal Sharing/Low End Adj",{"$f":"(P29+P32)/1000","v":0}]
[118,"USAC Receipts",null,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,108,"Special Access Surcharge",null,null,null,null,null,{"$f":"Y33*Z33","v":0},{"$f":"Y33*AA33","v":0},{"$f":"Y33*AB33","v":0},"    N/A",210,"Total Business Centrex Lines in groups with 9 or more lines","Input or Sum of Jurisdictions",null,"      N/A","      N/A","      N/A","      N/A","      N/A","   TrueUp of Sharing/Low End Adj",{"$f":"(Q29+Q32)/1000","v":0}]
[120,"Total Common Line",null,{"$f":"AC72","v":0},{"$f":"AD72","v":0},{"$f":"AE72","v":0},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,109,"Other EUCL",null,"          N/A","          N/A","          N/A","          N/A",null,null,null,"    N/A",220,"Total Business Groups with less than 9 lines in the group","Input or Sum of Jurisdictions",null,"      N/A","      N/A","      N/A","      N/A","      N/A","   Current Low End Adj",{"$f":"(R29+R32)/1000","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,"   Telecomm.Relay Svcs.",{"$f":"(S29+S32)/1000","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","Zone B:",null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,"   Reg / NonReg",{"$f":"(T29+T32)/1000","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,112,"Primary Res, Single Line Bus, Lifeline EUCL (1)",null,null,null,null,null,{"$f":"Y37*Z37","v":0},{"$f":"Y37*AA37","v":0},{"$f":"Y37*AB37","v":0},"    N/A","","MOU Demand Inputs","",null,null,null,null,null,null,"   Other (1) [NANPA]",{"$f":"(L44+L47)/1000","v":0}]
[null,null,null,null,null,null,null,null,null,null,"DESCRIPTION:","NANPA","TBNP","","","","","","","",null,114,"NonPrimary Residence & BRI ISDN EUCL (1)",null,null,null,null,null,{"$f":"Y38*Z38","v":0},{"$f":"Y38*AA38","v":0},{"$f":"Y38*AB38","v":0},"    N/A",300,"Total Terminating Premium MOU","RTE1r161a",{"$f":"Y63","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A","   Other (2) [TBNP(incl. reversal)]",{"$f":"(M44+M47)/1000","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"","(incl. reversal)","","","","","","","",null,116,"Multiline Bus, PRI ISDN, Centrex EUCL (1)",null,null,null,null,null,{"$f":"Y39*Z39","v":0},{"$f":"Y39*AA39","v":0},{"$f":"Y39*AB39","v":0},"    N/A",310,"Total Terminating Non-Premium MOU","RTE1r163a",{"$f":"Y64","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A","   Other (3)",{"$f":"(N44+N47)/1000","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"OTHER (1)","OTHER (2)","OTHER (3)","OTHER (4)","OTHER (5)","OTHER (6)","OTHER (7)","OTHER (8)","OTHER (9)","TOTAL","","",null,null,null,null,null,null,null,null,null,320,"Total Terminating Chargeable MOU","r300+.45*r310",{"$f":"AJ38+0.45*AJ39","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A","   Other (4)",{"$f":"(O44+O47)/1000","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"-","-","-","-","-","-","-","-","-","-","","Zone C:",null,null,null,null,null,null,null,null,null,330,"Total Originating Premium MOU","RTE1r165a",{"$f":"Y65","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A","   Other (5)",{"$f":"(P44+P47)/1000","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"(J)","(K)","(L)","(M)","(N)","(O)","(P)","(Q)","(R)","(S)",122,"Primary Res, Single Line Bus, Lifeline EUCL (1)",null,null,null,null,null,{"$f":"Y42*Z42","v":0},{"$f":"Y42*AA42","v":0},{"$f":"Y42*AB42","v":0},"    N/A",340,"Total Originating Non-Premium MOU","RTE1r167a",{"$f":"Y66","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A","   Other (6)",{"$f":"(Q44+Q47)/1000","v":0}]
[null,null,null,null,null,null,null,null,null,null,"COMMON LINE  Revenue Effect",null,null,null,null,null,null,null,null,null,null,124,"NonPrimary Residence & BRI ISDN EUCL (1)",null,null,null,null,null,{"$f":"Y43*Z43","v":0},{"$f":"Y43*AA43","v":0},{"$f":"Y43*AB43","v":0},"    N/A",350,"Total Originating Chargeable MOU","r330+.45*r340",{"$f":"AJ41+0.45*AJ42","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A","   Other (7)",{"$f":"(R44+R47)/1000","v":0}]
[null,null,null,null,null,null,null,null,null,160,"Revenue Effects",null,null,null,null,null,null,null,null,null,null,126,"Multiline Bus, PRI ISDN, Centrex EUCL (1)",null,null,null,null,null,{"$f":"Y44*Z44","v":0},{"$f":"Y44*AA44","v":0},{"$f":"Y44*AB44","v":0},"    N/A","","","",null,null,null,null,null,null,"   Other (8)",{"$f":"(S44+S47)/1000","v":0}]
[400,"Total",null,{"$f":"D34+D42","v":0},{"$f":"E34+E42","v":0},{"$f":"F34+F42","v":0},{"$f":"E45-D45","v":0},{"$f":"F45-E45","v":0},null,"","",null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,"","SLC/PICC Caps","",null,null,null,null,null,null,"   Other (9)",{"$f":"(T44+T47)/1000","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","Zone D:",null,null,null,null,null,null,null,null,null,400,"PR, Lifeline & SLB EU Cap","Input",null,"      N/A","      N/A","      N/A","      N/A","      N/A",null,"All","Special"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,132,"Primary Res, Single Line Bus, Lifeline EUCL (1)",null,null,null,null,null,{"$f":"Y47*Z47","v":0},{"$f":"Y47*AA47","v":0},{"$f":"Y47*AB47","v":0},"    N/A",410,"NonPrimary Res & BRI EU Cap","Input",null,"      N/A","      N/A","      N/A","      N/A","      N/A","   TOTAL OF INDIVIDUALS",{"$f":"SUM(AQ28:AQ45)","v":0},{"$f":"(SUM(L32:T32)+SUM(L47:T47))/1000","v":0}]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,134,"NonPrimary Residence & BRI ISDN EUCL (1)",null,null,null,null,null,{"$f":"Y48*Z48","v":0},{"$f":"Y48*AA48","v":0},{"$f":"Y48*AB48","v":0},"    N/A",420,"MLB, PRI & Centrex EU Cap","Input",null,"      N/A","      N/A","      N/A","      N/A","      N/A","   TOTAL EXOGENOUS (EXG1)",{"$f":"(U$44+U$47)/1000","v":0},{"$f":"U47/1000","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,136,"Multiline Bus, PRI ISDN, Centrex EUCL (1)",null,null,null,null,null,{"$f":"Y49*Z49","v":0},{"$f":"Y49*AA49","v":0},{"$f":"Y49*AB49","v":0},"    N/A",430,"MLB PICC Rate as of Dec. 29, 2011","Input",null,"      N/A","      N/A","      N/A","      N/A","      N/A","   TOTAL EXOGENOUS (EXG2 - other column)",{"$f":"(N(M85)+N(M104))/1000","v":0},{"$f":"M104/1000","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","Zone - Other:",null,null,null,null,null,null,null,null,null,"","CMT Revenue",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,142,"Primary Res, Single Line Bus, Lifeline EUCL (1)",null,null,null,null,null,{"$f":"Y52*Z52","v":0},{"$f":"Y52*AA52","v":0},{"$f":"Y52*AB52","v":0},"    N/A",440,"Current MaxCMT Rev per Line (from previous filing)","Input (r460 from prev filing) or Wtd Avg of Juris",null,"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,144,"NonPrimary Residence & BRI ISDN EUCL (1)",null,null,null,null,null,{"$f":"Y53*Z53","v":0},{"$f":"Y53*AA53","v":0},{"$f":"Y53*AB53","v":0},"    N/A","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,146,"Multiline Bus, PRI ISDN, Centrex EUCL (1)",null,null,null,null,null,{"$f":"Y54*Z54","v":0},{"$f":"Y54*AA54","v":0},{"$f":"Y54*AB54","v":0},"    N/A","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","Presubscribed Interexchange Carrier Charge (PICC)",null,null,null,null,null,null,null,null,null,450,"Total CMT Exogenous Cost Factor ((R+deltaZ)/R)","((EXG1r160s/r130a)/r440a)+1",{"$f":"IF(OR(AJ29=0,AJ52=0),0,((U44/AJ29)/AJ52)+1)","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,460,"Proposed Maximum CMT Revenue Per Line","r440*r450",{"$f":"AJ52*AJ56","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,155,"Multiline Business & PRI ISDN PICC           (1)",null,null,null,null,null,{"$f":"Y59*Z59","v":0},{"$f":"Y59*AA59","v":0},{"$f":"Y59*AB59","v":0},"    N/A","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,157,"Business Centrex PICC",null,null,"          N/A","          N/A","          N/A",null,null,null,"    N/A","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","Carrier Common Line",null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,161,"Terminating CCL Prem.",null,null,null,null,null,{"$f":"Y63*Z63","v":0},{"$f":"Y63*AA63","v":0},{"$f":"Y63*AB63","v":0},"    N/A","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,163,"Terminating CCL Non-Prem.",null,null,null,null,null,{"$f":"Y64*Z64","v":0},{"$f":"Y64*AA64","v":0},{"$f":"Y64*AB64","v":0},"    N/A","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,165,"Originating CCL Prem.",null,null,null,null,null,{"$f":"Y65*Z65","v":0},{"$f":"Y65*AA65","v":0},{"$f":"Y65*AB65","v":0},"    N/A","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,167,"Originating CCL Non-Prem.",null,null,null,null,null,{"$f":"Y66*Z66","v":0},{"$f":"Y66*AA66","v":0},{"$f":"Y66*AB66","v":0},"    N/A","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,180,"Other Common Line",null,"          N/A","          N/A","          N/A","          N/A",null,null,null,"    N/A","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,185,"USAC Receipts",null,null,null,null,null,{"$f":"Y70*Z70","v":0},{"$f":"Y70*AA70","v":0},{"$f":"Y70*AB70","v":0},"    N/A","","",""]
["Note:","Display whole numbers for rows 100 through 400.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","Per Minute Revenues",null,null,null,null,null,{"$f":"SUM(AC63:AC66)","v":0},{"$f":"SUM(AD63:AD66)","v":0},{"$f":"SUM(AE63:AE66)","v":0},"    N/A","","",""]
[null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,190,"Total Basket",null,"          N/A","          N/A","          N/A","          N/A",{"$f":"SUM(AC30:AC54)+AC59+AC60+SUM(AC62:AC66)+AC69+AC70","v":0},{"$f":"SUM(AD30:AD54)+AD59+AD60+SUM(AD62:AD66)+AD69+AD70","v":0},{"$f":"SUM(AE30:AE54)+AE59+AE60+SUM(AE62:AE66)+AE69+AE70","v":0},"    N/A","","",""]
[null,null,null,null,null,null,null,null,null,"NOTE:","   (1) Total may not equal sum of changes due to interactive effects.",null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","   (2) Display whole numbers.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"EXG-2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAP-1",null,null,null,null,null,null,null,null,"ANALYZER"]
[null,null,null,null,null,null,null,null,null,{"$f":"\"Filing Date:                \"&DATE","v":"Filing Date:                06/17/2024"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Filing Date:                \"&DATE","v":"Filing Date:                06/17/2024"},null,null,null,null,null,null,null,null,{"$f":"\"Filing Date:                \"&$D$1","v":"Filing Date:                06/17/2024"}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"Filing Entity:               \"&COSA","v":"Filing Entity:               "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Filing Entity:               \"&COSA","v":"Filing Entity:               "},null,null,null,null,null,null,null,null,{"$f":"\"Filing Entity:               \"&$D$2","v":"Filing Entity:               "}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"Transmittal Number:   \"&TRANSMITTAL","v":"Transmittal Number:   "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Transmittal Number:   \"&TRANSMITTAL","v":"Transmittal Number:   "},null,null,null,null,null,null,null,null,{"$f":"\"Transmittal Number:   \"&$D$3","v":"Transmittal Number:   "}]
[null,null,null,null,null,null,null,null,null,{"$f":"NAME","v":0},null,null,null,null,"Price Cap Tariff Review Plan",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NAME","v":0},null,null,null,null,null,null,null,null,{"$f":"$D$4","v":0}]
[null,null,null,null,null,null,null,null,null,"Page 1 of 1",null,null,null,null,"Special Access Net Exogenous Cost Shifts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 2 of 2",null,"Price Cap Tariff Review Plan",null,null,null,null,null,null,"Page 2 of 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculation of EUCL Limits, PICC Rate and CCL Rates",null,null,null,null,null,null,null,null,"Flags / Notes"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Other Exog",null,null,"from EXG1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COMMON LINE-----------------------------------------",null,"-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Jurisdiction","No Zone / Zone A","Zone B","Zone C","Zone D","Other Zone"]
[null,null,null,null,null,null,null,null,null,"","Common Line  Basket",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Source","(a)","(b)","(c)","(d)","(e)","(f)","Deaveraging Checks (from CAP3):"]
[null,null,null,null,null,null,null,null,null,100,"Total Common Line",null,{"$f":"IF(U44=0,0,U44)","v":0},null,null,{"$f":"U44","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","CMT Revenue Vs EU Revenue at Max. Allowable Rates",null,null,null,null,null,null,null,"   Zone Progression Checks:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,600,"Proposed Maximum CMT Revenue","r460 * r130 or Sum of Jurisdictions",{"$f":"AJ58*AJ29","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A","     Primary Res, SLB, & LifeLine",{"$f":"IF(AJ206=\"      N/A\",\"N/A\",IF(AND(AL29<>0,AL242<AK242),\"FAIL\",IF(AND(AM29<>0,AM242<AL242),\"FAIL\",IF(AND(AN29<>0,AN242<AM242),\"FAIL\",IF(AND(AO29<>0,AO242<AN242),\"FAIL\",\"PASS\")))))","v":"PASS"},{"$f":"IF(AJ206=\"      N/A\",\"No Deaveraging Allowed\",IF(AND(AL29<>0,AL242<AK242),\"Prim Res Zone B < Zone A\",IF(AND(AM29<>0,AM242<AL242),\"Prim Res Zone C < Zone B\",IF(AND(AN29<>0,AN242<AM242),\"Prim Res Zone D < Zone C\",IF(AND(AO29<>0,AO242<AN242),\"Prim Res Zone Other < Zone D\",\"Prim Rates OK\")))))","v":"Prim Rates OK"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,610,"Maximum Allowable PR, Lifeline & SLB EU Revenue","r400 * r100 or Sum of Jurisdictions",{"$f":"AJ46*AJ26","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A","     NonPrimary Res & BRI ISDN",{"$f":"IF(AJ206=\"      N/A\",\"N/A\",IF(AND(AL29<>0,AL243<AK243),\"FAIL\",IF(AND(AM29<>0,AM243<AL243),\"FAIL\",IF(AND(AN29<>0,AN243<AM243),\"FAIL\",IF(AND(AO29<>0,AO243<AN243),\"FAIL\",\"PASS\")))))","v":"PASS"},{"$f":"IF(AJ206=\"      N/A\",\"No Deaveraging Allowed\",IF(AND(AL29<>0,AL243<AK243),\"Non Prim Zone B < Zone A\",IF(AND(AM29<>0,AM243<AL243),\"Non Prim Zone C < Zone B\",IF(AND(AN29<>0,AN243<AM243),\"Non Prim Zone D < Zone C\",IF(AND(AO29<>0,AO243<AN243),\"Non Prim Zone Other < Zone D\",\"Non Prim Rates OK\")))))","v":"Non Prim Rates OK"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,620,"Maximum Allowable NonPrimary Res & BRI EU Revenue","r410 * r110 or Sum of Jurisdictions",{"$f":"AJ47*AJ27","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A","     MLB, PRI ISDN, & Centrex",{"$f":"IF(AJ206=\"      N/A\",\"N/A\",IF(AND(AL29<>0,AL244<AK244),\"FAIL\",IF(AND(AM29<>0,AM244<AL244),\"FAIL\",IF(AND(AN29<>0,AN244<AM244),\"FAIL\",IF(AND(AO29<>0,AO244<AN244),\"FAIL\",\"PASS\")))))","v":"PASS"},{"$f":"IF(AJ206=\"      N/A\",\"No Deaveraging Allowed\",IF(AND(AL29<>0,AL244<AK244),\"MLB Zone B < Zone A\",IF(AND(AM29<>0,AM244<AL244),\"MLB Zone C < Zone B\",IF(AND(AN29<>0,AN244<AM244),\"MLB Zone D < Zone C\",IF(AND(AO29<>0,AO244<AN244),\"MLB Zone Other < Zone D\",\"MLB Rates OK\")))))","v":"MLB Rates OK"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,630,"Maximum Allowable MLB, PRI & Centrex EU Revenue","r420 * r120 or Sum of Jurisdictions",{"$f":"AJ48*AJ28","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,640,"Total Maximum Allowable EU Revenue","r610 + r620 + r630",{"$f":"SUM(AJ87:AJ89)","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A","   Zone Minimum Pricing Checks:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,650,"Remaining CMT Revenue/(CMT Over-recovery)","r600 - r640",{"$f":"AJ86-AJ90","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A","     Primary Res, SLB, & LifeLine",{"$f":"IF(AND(OR(AJ130=\"CAP1\",AJ130=\"CAP2\"),AND(AJ206<>0,ISNUMBER(AJ206)=TRUE)),\"FAIL\",IF(AND(AK29<>0,AK242<AJ231),\"FAIL\",IF(AND(AL29<>0,AL242<AJ231),\"FAIL\",IF(AND(AM29<>0,AM242<AJ231),\"FAIL\",IF(AND(AN29<>0,AN242<AJ231),\"FAIL\",IF(AND(AO29<>0,AO242<AJ231),\"FAIL\",\"PASS\"))))))","v":"PASS"},{"$f":"IF(AND(AK29<>0,AK242<AJ231),\"Prim Res Zone A < Min\",IF(AJ206=\"no\",\"Avg'd Prim Rate above Min\",IF(AND(AL29<>0,AL242<AJ231),\"Prim Res Zone B < Min\",IF(AND(AM29<>0,AM242<AJ231),\"Prim Res Zone C < Min\",IF(AND(AN29<>0,AN242<AJ231),\"Prim Res Zone D < Min\",IF(AND(AO29<>0,AO242<AJ231),\"Prim Res Zone Other < Min\",\"Prim Rates above Min\"))))))","v":"Prim Rates above Min"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,652,"Maximum Allowable PICC Revenue","r430*( r200+r210/9+r220 ) or Sum of Jurisdictns",{"$f":"AJ49*(AJ32+AJ33/9+AJ34)","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A","     NonPrimary Res & BRI ISDN",{"$f":"IF(AND(OR(AJ130=\"CAP1\",AJ130=\"CAP2\"),AND(AJ206<>0,ISNUMBER(AJ206)=TRUE)),\"FAIL\",IF(AND(AK29<>0,AK243<AJ234),\"FAIL\",IF(AND(AL29<>0,AL243<AJ234),\"FAIL\",IF(AND(AM29<>0,AM243<AJ234),\"FAIL\",IF(AND(AN29<>0,AN243<AJ234),\"FAIL\",IF(AND(AO29<>0,AO243<AJ234),\"FAIL\",\"PASS\"))))))","v":"PASS"},{"$f":"IF(AND(AK29<>0,AK243<AJ234),\"Non Prim Zone A < Min\",IF(AJ206=\"no\",\"Avg'd Non Prim Rates above Min\",IF(AND(AL29<>0,AL243<AJ234),\"Non Prim Zone B < Min\",IF(AND(AM29<>0,AM243<AJ234),\"Non Prim Zone C < Min\",IF(AND(AN29<>0,AN243<AJ234),\"Non Prim Zone D < Min\",IF(AND(AO29<>0,AO243<AJ234),\"Non Prim Zone Other < Min\",\"Non Prim Rates above Min\"))))))","v":"Non Prim Rates above Min"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,660,"Total USAC Receipts (at t)","RTE1r185f or Sum of Jurisdictns",{"$f":"AE70","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A","     MLB, PRI ISDN, & Centrex",{"$f":"IF(AND(OR(AJ130=\"CAP1\",AJ130=\"CAP2\"),AND(AJ206<>0,ISNUMBER(AJ206)=TRUE)),\"FAIL\",IF(AND(AK29<>0,AK244<AJ237),\"FAIL\",IF(AND(AL29<>0,AL244<AJ237),\"FAIL\",IF(AND(AM29<>0,AM244<AJ237),\"FAIL\",IF(AND(AN29<>0,AN244<AJ237),\"FAIL\",IF(AND(AO29<>0,AO244<AJ237),\"FAIL\",\"PASS\"))))))","v":"PASS"},{"$f":"IF(AND(AK29<>0,AK244<AJ237),\"MLB Zone A < Min\",IF(AJ206=\"no\",\"Avg'd MLB Rates above Min\",IF(AND(AL29<>0,AL244<AJ237),\"MLB Zone B < Min\",IF(AND(AM29<>0,AM244<AJ237),\"MLB Zone C < Min\",IF(AND(AN29<>0,AN244<AJ237),\"MLB Zone D < Min\",IF(AND(AO29<>0,AO244<AJ237),\"MLB Zone Other < Min\",\"MLB Rates above Min\"))))))","v":"MLB Rates above Min"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,"   Zone Maximum Pricing Checks:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,"     Primary Res, SLB, & LifeLine",{"$f":"IF(AND(OR(AJ130=\"CAP1\",AJ130=\"CAP2\"),AND(AJ206<>0,ISNUMBER(AJ206)=TRUE)),\"FAIL\",IF(AND(AK29<>0,AK242>AJ232),\"FAIL\",IF(AND(AL29<>0,AL242>AJ232),\"FAIL\",IF(AND(AM29<>0,AM242>AJ232),\"FAIL\",IF(AND(AN29<>0,AN242>AJ232),\"FAIL\",IF(AND(AO29<>0,AO242>AJ232),\"FAIL\",\"PASS\"))))))","v":"PASS"},{"$f":"IF(AND(AK29<>0,AK242>AJ232),\"Prim Res Zone A > Max\",IF(AJ206=\"no\",\"Avg'd Prim Rate below Max\",IF(AND(AL29<>0,AL242>AJ232),\"Prim Res Zone B > Max\",IF(AND(AM29<>0,AM242>AJ232),\"Prim Res Zone C > Max\",IF(AND(AN29<>0,AN242>AJ232),\"Prim Res Zone D > Max\",IF(AND(AO29<>0,AO242>AJ232),\"Prim Res Zone Other > Max\",\"Prim Rates below Max\"))))))","v":"Prim Rates below Max"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,"     NonPrimary Res & BRI ISDN",{"$f":"IF(AND(OR(AJ130=\"CAP1\",AJ130=\"CAP2\"),AND(AJ206<>0,ISNUMBER(AJ206)=TRUE)),\"FAIL\",IF(AND(AK29<>0,AK243>AJ235),\"FAIL\",IF(AND(AL29<>0,AL243>AJ235),\"FAIL\",IF(AND(AM29<>0,AM243>AJ235),\"FAIL\",IF(AND(AN29<>0,AN243>AJ235),\"FAIL\",IF(AND(AO29<>0,AO243>AJ235),\"FAIL\",\"PASS\"))))))","v":"PASS"},{"$f":"IF(AND(AK29<>0,AK243>AJ235),\"Non Prim Zone A > Max\",IF(AJ206=\"no\",\"Avg'd Non Prim Rates below Max\",IF(AND(AL29<>0,AL243>AJ235),\"Non Prim Zone B > Max\",IF(AND(AM29<>0,AM243>AJ235),\"Non Prim Zone C > Max\",IF(AND(AN29<>0,AN243>AJ235),\"Non Prim Zone D > Max\",IF(AND(AO29<>0,AO243>AJ235),\"Non Prim Zone Other > Max\",\"Non Prim Rates below Max\"))))))","v":"Non Prim Rates below Max"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,"     MLB, PRI ISDN, & Centrex",{"$f":"IF(AND(OR(AJ130=\"CAP1\",AJ130=\"CAP2\"),AND(AJ206<>0,ISNUMBER(AJ206)=TRUE)),\"FAIL\",IF(AND(AK29<>0,AK244>AJ238),\"FAIL\",IF(AND(AL29<>0,AL244>AJ238),\"FAIL\",IF(AND(AM29<>0,AM244>AJ238),\"FAIL\",IF(AND(AN29<>0,AN244>AJ238),\"FAIL\",IF(AND(AO29<>0,AO244>AJ238),\"FAIL\",\"PASS\"))))))","v":"PASS"},{"$f":"IF(AND(AK29<>0,AK244>AJ238),\"MLB Zone A > Max\",IF(AJ206=\"no\",\"Avg'd MLB Rates below Max\",IF(AND(AL29<>0,AL244>AJ238),\"MLB Zone B > Max\",IF(AND(AM29<>0,AM244>AJ238),\"MLB Zone C > Max\",IF(AND(AN29<>0,AN244>AJ238),\"MLB Zone D > Max\",IF(AND(AO29<>0,AO244>AJ238),\"MLB Zone Other > Max\",\"MLB Rates below Max\"))))))","v":"MLB Rates below Max"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,680,"Remaining Recoverable Revenue/(Total over-recovery)","r650-r660 or Sum of Jurisdictns",{"$f":"ROUND(AJ91-AJ93,2)","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,"   Class of Service Checks:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,"     Zone A",{"$f":"IF(AK$243<AK$242,\"FAIL\",IF(AK$244<AK$243,\"FAIL\",\"PASS\"))","v":"PASS"},{"$f":"IF(AK$243<AK$242,\"Zone A Non Prim < Prim\",IF(AK$244<AK$243,\"Zone A MLB < Non Prim\",\"Zone A OK\"))","v":"Zone A OK"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","Calculation of PICC for MultiLine Business, PRI ISDN, & Centrex Lines",null,null,null,null,null,null,null,"     Zone B",{"$f":"IF(AJ206=\"no\",\"N/A\",IF(AL$243<AL$242,\"FAIL\",IF(AL$244<AL$243,\"FAIL\",\"PASS\")))","v":"PASS"},{"$f":"IF(AJ206=\"no\",\"No Deaveraging Allowed\",IF(AL$243<AL$242,\"Zone B Non Prim < Prim\",IF(AL$244<AL$243,\"Zone B MLB < Non Prim\",\"Zone B OK\")))","v":"Zone B OK"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,800,"MLB, PRI & Centrex PICC Rate (Dec. 29, 2011)","r430",{"$f":"AJ49","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A","     Zone C",{"$f":"IF(AJ206=\"no\",\"N/A\",IF(AM$243<AM$242,\"FAIL\",IF(AM$244<AM$243,\"FAIL\",\"PASS\")))","v":"PASS"},{"$f":"IF(AJ206=\"no\",\"No Deaveraging Allowed\",IF(AM$243<AM$242,\"Zone C Non Prim < Prim\",IF(AM$244<AM$243,\"Zone C MLB < Non Prim\",\"Zone C OK\")))","v":"Zone C OK"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,810,"MLB, PRI & Centrex PICC Revenue Target","if r680>0 then r680 else 0, or Sum of Jurisdictns",{"$f":"IF(AJ99>0,AJ99,0)","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A","     Zone D",{"$f":"IF(AJ206=\"no\",\"N/A\",IF(AN$243<AN$242,\"FAIL\",IF(AN$244<AN$243,\"FAIL\",\"PASS\")))","v":"PASS"},{"$f":"IF(AJ206=\"no\",\"No Deaveraging Allowed\",IF(AN$243<AN$242,\"Zone D Non Prim < Prim\",IF(AN$244<AN$243,\"Zone D MLB < Non Prim\",\"Zone D OK\")))","v":"Zone D OK"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,820,"MLB, PRI & Centrex PICC Target Rate","r810 / (r200 + r210/9 + r220)",{"$f":"IF((AJ32+AJ33+AJ34)<>0,+AJ104/(AJ32+AJ33/9+AJ34),0)","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A","     Other Zone",{"$f":"IF(AJ206=\"no\",\"N/A\",IF(AO$243<AO$242,\"FAIL\",IF(AO$244<AO$243,\"FAIL\",\"PASS\")))","v":"PASS"},{"$f":"IF(AJ206=\"no\",\"No Deaveraging Allowed\",IF(AO$243<AO$242,\"Other Zone Non Prim < Prim\",IF(AO$244<AO$243,\"Other Zone MLB < Non Prim\",\"Other Zone OK\")))","v":"Other Zone OK"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,830,"Maximum Average MLB, PRI & Centrex PICC Rate","Min(r800,r820)",{"$f":"MIN(AJ103,AJ105)","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,840,"Maximum MLB & PRI PICC Revenue","r830 * r200, or Sum of Jurisdictions",{"$f":"AJ106*AJ32","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A","Proposed Revenues (from CAP5)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,850,"Maximum Centrex PICC Revenue","r830 * (r210/9 + r220), or Sum of Jurisdictions",{"$f":"AJ106*(AJ33/9+AJ34)","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A","     CMT Revenue Too High?",null,{"$f":"IF(TRUNC(AJ356,0)>TRUNC(AJ330,0),\"     HIGH\",\"       *\")","v":"       *"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,860,"Total Maximum PICC Revenue (Proposed)","r840 + r850",{"$f":"AJ107+AJ108","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","Calculation of CCL Rates and Revenue",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,940,"Prem. Originating MOU Rate as of Dec. 29, 2011","Input or Weighted Avg of Jurisdictns",null,"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,945,"Prem. Terminating MOU Rate as of Dec. 29, 2011","Input or Weighted Avg of Jurisdictns",null,"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,950,"Maximum CCL Revenue","r810 - r860, or Sum of Jurisdictions",{"$f":"AJ104-AJ109","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,960,"Maximum CCL Originating Rate","Min(r940, r950/r350)",{"$f":"MIN(AJ116,IF(AJ43=0,0,AJ118/AJ43))","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,970,"Maximum CCL Terminating Rate","Min(r945,(r950 - (r350*r960))/r320)",{"$f":"MIN(AJ117,IF(AJ40=0,0,(AJ118-(AJ43*AJ119))/AJ40))","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,980,"Maximum Originating CCL Revenue","r960 * r350, or Sum of Jurisdictions",{"$f":"AJ119*AJ43","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,990,"Maximum Terminating CCL Revenue","r970 * r320, or Sum of Jurisdictions",{"$f":"AJ120*AJ40","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,995,"Total Maximum CCL Revenue","r980 + r990",{"$f":"AJ122+AJ123","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","EU Pricing Decision",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1100,"Is Deaveraging of EUCL Rates Possible?","if r680>0,\"No\",\"Yes\"",{"$f":"IF(AJ99>0,\"NO\",\"YES\")","v":"YES"},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1110,"Do you have Pooling Revenues?","Input",null,"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1120,"Are you going to deaverage EUCL Rates by zone?","Input (If r1100 = \"No\" you must input \"No\")","No","      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1130,"CAP Form containing final EUCL Rates","if g6=g7=g8=Y,JurisSPM; if g6=g7=Y&g8=N,",{"$f":"IF(AJ99>0,\"CAP1\",IF(AJ129=\"No\",\"CAP2\",\"CAP3\"))","v":"CAP2"},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","  JurisSP; if g6=y&g7=g8=N&r680<=0,JurisS; if g10=y,JurisMix; if r680>0,CAP1; if r1120=No,CAP2;elseCAP3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1140,"Max. Allowable PR, Lifeline & SLB EU Revenue","if Juris rates,sum of Juris;if 1130=CAP1,r610;else1130",{"$f":"IF(AJ130=\"cap1\",AJ87,AJ130)","v":"CAP2"},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1150,"Max. Allowable NonPrimary Res & BRI EU Revenue","if Juris rates,sum of Juris;if 1130 =CAP1,r620;else1130",{"$f":"IF(AJ130=\"cap1\",AJ88,AJ130)","v":"CAP2"},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1160,"Max. Allowable MLB, PRI & Centrex EU Revenue","if Juris rates,sum of Juris;if 1130=CAP1,r630;else1130",{"$f":"IF(AJ130=\"cap1\",AJ89,AJ130)","v":"CAP2"},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAP-2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Filing Date:                \"&DATE","v":"Filing Date:                06/17/2024"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Filing Entity:               \"&COSA","v":"Filing Entity:               "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Transmittal Number:   \"&TRANSMITTAL","v":"Transmittal Number:   "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NAME","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 1 of 1",null,"Price Cap Tariff Review Plan"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manual Input of EUCL Rates - No PICC or MOU Rates"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Jurisdiction"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Source","(a)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","Calculation of Maximum Recoverable Revenue","For all rows: if CAP1r1130=\"CAP2\", use sourcing; if Jurisdictional Pricing, enter Sum of CAP2-priced Jurisdictions where indicated; else value from CAP1r1130."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,"Maximum CMT Revenue","CAP1r600 or Sum of CAP2-priced Jurisdictns",{"$f":"IF(AJ130=\"cap2\",AJ86,AJ130)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,110,"Total USAC Receipts (at t)","CAP1r660 or Sum of CAP2-priced Jurisdictns",{"$f":"IF(AJ130=\"cap2\",AJ93,AJ130)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,130,"Maximum Recoverable Revenue","r100 - r110",{"$f":"IF(AJ130=\"CAP2\",AJ146-AJ147,AJ130)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","Maximum Allowable EU Rates",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200,"Max. Allowable Primary Res, Lifeline, & SLB EU Rate","CAP1r400 if CAP1r1130=CAP2",{"$f":"IF(AJ130=\"cap2\",AJ46,AJ130)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,210,"Max. Allowable NonPrimary Res & BRI ISDN EU Rate","CAP1r410 if CAP1r1130=CAP2",{"$f":"IF(AJ130=\"cap2\",AJ47,AJ130)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,220,"Max. Allowable MLB, PRI ISDN, & Centrex EU Rate","CAP1r420 if CAP1r1130=CAP2",{"$f":"IF(AJ130=\"cap2\",AJ48,AJ130)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","Final EU Rates (Manually Input)",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,400,"Final Primary Res, Lifeline, & SLB EU Rate","Input ",null,{"$f":"IF(AJ157>AJ152,\"     Error:  Exceeded maximum allowable rate\",\"     ok\")","v":"     ok"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,410,"Final NonPrim Res & BRI ISDN EU Rate","Input ",null,{"$f":"IF(AJ158>AJ153,\"     Error:  Exceeded maximum allowable rate\",\"     ok\")","v":"     ok"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,420,"Final MLB, PRI ISDN, & Centrex EU Rate","Input ",null,{"$f":"IF(AJ159>AJ154,\"     Error:  Exceeded maximum allowable rate\",IF(AJ159<AJ158,\"     Error:  MLB rate less than NPR rate\",IF(AJ159<AJ157,\"     Error:  MLB rate less than PR rate\",\"     ok\")))","v":"     ok"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","Final EU Revenue",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500,"Final Total Primary Res & SLB & LifeLine EU Revenue","r400 * CAP1r100 or Sum of CAP2-priced Jurisdictns",{"$f":"IF(AJ130=\"cap2\",AJ157*AJ26,AJ130)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,510,"Final Total NonPrim Res & BRI ISDN EU Revenue","r410 * CAP1r110 or Sum of CAP2-priced Jurisdictns",{"$f":"IF(AJ130=\"cap2\",AJ158*AJ27,AJ130)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,520,"Final Total MLB, PRI ISDN, & Centrex EU Revenue","r420 * CAP1r120 or Sum of CAP2-priced Jurisdictns",{"$f":"IF(AJ130=\"cap2\",AJ159*AJ28,AJ130)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,530,"Final Total End User Revenue","r500 + r510 + r520",{"$f":"IF(AJ130=\"CAP2\",N(AJ162)+N(AJ163)+N(AJ164),AJ130)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,600,"Actual vs. Allowable Revenue:  Over-recovery","r530 - r130",{"$f":"IF(AJ130=\"CAP2\",ROUND(N(AJ165)-N(AJ149),0),AJ130)","v":0},{"$f":"IF(N(AJ167)>0,\"     Error:  Over-recovery. You must change EUCL rates.\",IF(N(AJ167)<0,\"     You have under-recovered by this amount.\",\"     ok\"))","v":"     ok"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","          or (Under-recovery)",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAP-3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Filing Date:                \"&DATE","v":"Filing Date:                06/17/2024"},null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Filing Entity:               \"&COSA","v":"Filing Entity:               "},null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Transmittal Number:   \"&TRANSMITTAL","v":"Transmittal Number:   "},null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NAME","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 1 of 1",null,"Price Cap Tariff Review Plan"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculation of Minimum & Maximum EU Rates"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","Total","Zone A","Zone B","Zone C","Zone D","Other Zone *"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Source","(a)","(b)","(c)","(d)","(e)","(f)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculation of Maximum Recoverable Revenue","For all rows: if CAP1r1130=\"CAP3\", use sourcing; if Juris. Pricing, enter Sum of CAP3-priced Juris. where indicated; else CAP1r1130."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,"Maximum CMT Revenue","CAP1r600 or Sum of CAP3-priced Jurisdictns",{"$f":"IF(AJ130=\"CAP3\",AJ86,AJ130)","v":"CAP2"},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,110,"Total USAC Receipts","CAP1r660 or Sum of CAP3-priced Jurisdictns",{"$f":"IF(AJ130=\"CAP3\",AJ93,AJ130)","v":"CAP2"},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,130,"Maximum Recoverable Revenue","r100 - r110",{"$f":"IF(AJ130=\"CAP3\",N(AJ206)-N(AJ207),AJ130)","v":"CAP2"},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","Inputs for Calculation of Minimum and Maximum Allowable Deaveraged Rates",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200,"Total Local Exchange Lines","CAP1r130 or Sum of CAP3-priced Jurisdictns",{"$f":"IF(AJ130=\"CAP3\",SUM(AK212:AO212),AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",AK29,AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",AL29,AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",AM29,AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",AN29,AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",AO29,AJ130)","v":"CAP2"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,210,"Unbundled Loop & Line Port Rate (State Approved)","Input if CAP1r1130=CAP3; else, CAP1r1130","      N/A",{"$f":"AJ130","v":"CAP2"},{"$f":"AJ130","v":"CAP2"},{"$f":"AJ130","v":"CAP2"},{"$f":"AJ130","v":"CAP2"},{"$f":"AJ130","v":"CAP2"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,220,"Interstate UNE Rate","r210*.25 if CAP1r1130=CAP3","      N/A",{"$f":"IF(AJ130=\"CAP3\",AK213*0.25,AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",AL213*0.25,AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",AM213*0.25,AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",AN213*0.25,AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",AO213*0.25,AJ130)","v":"CAP2"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,230,"Interstate UNE Revenues","r200 * r220 or Sum of CAP3-priced Jurisdictns",{"$f":"IF(AJ130=\"CAP3\",SUM(AK215:AO215),AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",AK212*AK214,AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",AL212*AL214,AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",AM212*AM214,AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",AN212*AN214,AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",AO212*AO214,AJ130)","v":"CAP2"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,240,"Maximum CMT Revenue (using Max CMT Rev/Line)","CAP1r600 or Sum of CAP3-priced Jurisdictns",{"$f":"IF(AJ130=\"CAP3\",AJ86,AJ130)","v":"CAP2"},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,250,"Average Price Cap CMT Rev to be Recovered per Line","CAP1r460 ifCAP1r1130=CAP3",{"$f":"IF(AJ130=\"CAP3\",AJ58,AJ130)","v":"CAP2"},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,260,"Price Cap CMT Revenue by Zone","r200 * r250 or Sum of CAP3-priced Jurisdictns",{"$f":"IF(AJ130=\"CAP3\",SUM(AK218:AO218),AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",AK212*AJ217,AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",AL212*AJ217,AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",AM212*AJ217,AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",AN212*AJ217,AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",AO212*AJ217,AJ130)","v":"CAP2"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,270,"Uniform Rate Adjustment Factor","(r260 - r230 ) / r 200",{"$f":"IF(AJ130<>\"CAP3\",AJ130,IF(AJ212=0,0,(AJ218-AJ215)/AJ212))","v":"CAP2"},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","Minimum Deaveraged EU Charge Development",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,300,"Zone Average Revenue Per Line","r270a+r220 ifCAP1r1130=CAP3","      N/A",{"$f":"IF(AJ130=\"CAP3\",IF(AK214=0,\"None\",AJ219+AK214),AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",IF(AL214=0,\"None\",AJ219+AL214),AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",IF(AM214=0,\"None\",AJ219+AM214),AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",IF(AN214=0,\"None\",AJ219+AN214),AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",IF(AO214=0,\"None\",AJ219+AO214),AJ130)","v":"CAP2"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,310,"Preliminary Minimum Deaveraged EU Charge","Minimum value in r300",{"$f":"IF(AJ130=\"CAP3\",IF(AK214=0,0,IF(AL214=0,AK214,IF(AM214=0,MIN(AK214:AL214),IF(AN214=0,MIN(AK214:AM214),IF(AO214=0,MIN(AK214:AN214),MIN(AK214:AO214))))))+AJ219,AJ130)","v":"CAP2"},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,320,"Explicit Subsidy Support from USAC (at t)","CAP1r660 or Sum of CAP3-priced Jurisdictns",{"$f":"IF(AJ130=\"CAP3\",AJ93,AJ130)","v":"CAP2"},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,330,"Study Area above CAP Benchmark Revenues","If r300>9.2,(r300-7)*CAP1r(100+110)+(r300-9.2)*",{"$f":"IF(AJ130=\"CAP3\",SUM(AK225:AO225),AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",IF(AK222=\"None\",\"None\",IF((AK222>9.2),(AK222-7)*(AK26+AK27)+(AK222-9.2)*AK28,IF(AK222>7,(AK222-7)*(AK26+AK27),0))),AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",IF(AL222=\"None\",\"None\",IF((AL222>9.2),(AL222-7)*(AL26+AL27)+(AL222-9.2)*AL28,IF(AL222>7,(AL222-7)*(AL26+AL27),0))),AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",IF(AM222=\"None\",\"None\",IF((AM222>9.2),(AM222-7)*(AM26+AM27)+(AM222-9.2)*AM28,IF(AM222>7,(AM222-7)*(AM26+AM27),0))),AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",IF(AN222=\"None\",\"None\",IF((AN222>9.2),(AN222-7)*(AN26+AN27)+(AN222-9.2)*AN28,IF(AN222>7,(AN222-7)*(AN26+AN27),0))),AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",IF(AO222=\"None\",\"None\",IF((AO222>9.2),(AO222-7)*(AO26+AO27)+(AO222-9.2)*AO28,IF(AO222>7,(AO222-7)*(AO26+AO27),0))),AJ130)","v":"CAP2"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","   CAP1r120; if 9.2>=r300>7,(r300-7)*CAP1r(100+110);"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","   else 0; or Sum of CAP3-priced Jurisdictns"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,340,"Over Cap Revenues","Max(0, (r330 - r320))",{"$f":"IF(AJ130=\"CAP3\",MAX(0,N(AJ225)-N(AJ224)),AJ130)","v":"CAP2"},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,350,"Interim Calculations only (do not represent Zone results)","Interim calcs only (used in r360, r375, r385)",{"$f":"IF(AJ130=\"CAP3\",IF(OR(AL222=\"None\",AK229<=AL222)=TRUE,AK229,IF(OR(AM222=\"None\",AL229<=AM222)=TRUE,AL229,IF(OR(AN222=\"None\",AM229<=AN222)=TRUE,AM229,IF(OR(AO222=\"None\",AN229<=AO222)=TRUE,AN229,AO229)))),AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",IF(AK222=\"None\",\"None\",IF(AK212=0,0,AJ228/AK212)+AK222),AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",IF(AL222=\"None\",\"None\",IF(AK212+AL212=0,0,MAX(0,(AJ228-(AL222-AK222)*AK212))/(AK212+AL212))+AL222),AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",IF(AM222=\"None\",\"None\",IF(AK212+AL212+AM212=0,0,MAX(0,(AJ228-(AM222-AK222)*AK212-(AM222-AL222)*AL212))/(AK212+AL212+AM212))+AM222),AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",IF(AN222=\"None\",\"None\",IF(AK212+AL212+AM212+AN212=0,0,MAX(0,(AJ228-(AN222-AK222)*AK212-(AN222-AL222)*AL212-(AN222-AM222)*AM212))/(AK212+AL212+AM212+AN212))+AN222),AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",IF(AO222=\"None\",\"None\",IF(AK212+AL212+AM212+AN212+AO212=0,0,MAX(0,(AJ228-(AO222-AK222)*AK212-(AO222-AL222)*AL212-(AO222-AM222)*AM212-(AO222-AN222)*AN212))/(AK212+AL212+AM212+AN212+AO212))+AO222),AJ130)","v":"CAP2"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,360,"Minimum Deavgd PR, Lifeline, SLB EU Rate","Min(r350a,CAP1r400)if CAP1r1130=CAP3",{"$f":"IF(AJ130=\"CAP3\",MIN(AJ229,AJ46),AJ130)","v":"CAP2"},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,370,"Maximum Deavgd PR, Lifeline, SLB EU Rate","CAP1r400 if CAP1r1130=CAP3",{"$f":"AJ130","v":"CAP2"},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,375,"Minimum Deavgd NPR & BRI ISDN EU Rate","Min(r350a,CAP1r410)if CAP1r1130=CAP3",{"$f":"IF(AJ130=\"CAP3\",MIN(AJ229,AJ47),AJ130)","v":"CAP2"},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,380,"Maximum Deavgd NPR & BRI ISDN EU Rate","CAP1r410 if CAP1r1130=CAP3",{"$f":"AJ130","v":"CAP2"},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,385,"Minimum Deavgd MLB, PRI, Centrex EU Rate","Min(r350a,CAP1r420)if CAP1r1130=CAP3",{"$f":"IF(AJ130=\"CAP3\",MIN(AJ229,AJ48),AJ130)","v":"CAP2"},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,390,"Maximum Deavgd MLB, PRI, Centrex EU Rate","CAP1r420 if CAP1r1130=CAP3",{"$f":"AJ130","v":"CAP2"},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","Final EU Rates (Manually Input)",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,400,"Final Primary Res, Lifeline, & SLB EU Rate","Input; but for col.c thru f: if r100=\"N/A\", 0","      N/A",{"$f":"AJ130","v":"CAP2"},{"$f":"AJ130","v":"CAP2"},{"$f":"AJ130","v":"CAP2"},{"$f":"AJ130","v":"CAP2"},{"$f":"AJ130","v":"CAP2"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,410,"Final NonPrim Res & BRI ISDN EU Rate","Input; but for col.c thru f: if r100=\"N/A\", 0","      N/A",{"$f":"AJ130","v":"CAP2"},{"$f":"AJ130","v":"CAP2"},{"$f":"AJ130","v":"CAP2"},{"$f":"AJ130","v":"CAP2"},{"$f":"AJ130","v":"CAP2"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,420,"Final MLB, PRI ISDN, & Centrex EU Rate","Input; but for col.c thru f: if r100=\"N/A\", 0","      N/A",{"$f":"AJ130","v":"CAP2"},{"$f":"AJ130","v":"CAP2"},{"$f":"AJ130","v":"CAP2"},{"$f":"AJ130","v":"CAP2"},{"$f":"AJ130","v":"CAP2"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","Final EU Revenue",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500,"Final Total Primary Res & SLB & LifeLine EU Revenue","r400 * CAP1r100 or Sum of CAP3-priced Juris",{"$f":"IF(AJ130=\"CAP3\",SUM(AK247:AO247),AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",AK242*AK26,AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",AL242*AL26,AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",AM242*AM26,AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",AN242*AN26,AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",AO242*AO26,AJ130)","v":"CAP2"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,510,"Final Total NonPrim Res & BRI ISDN EU Revenue","r410 * CAP1r110 or Sum of CAP3-priced Juris",{"$f":"IF(AJ130=\"CAP3\",SUM(AK248:AO248),AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",AK243*AK27,AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",AL243*AL27,AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",AM243*AM27,AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",AN243*AN27,AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",AO243*AO27,AJ130)","v":"CAP2"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,520,"Final Total MLB, PRI ISDN, & Centrex EU Revenue","r420 * CAP1r120 or Sum of CAP3-priced Juris",{"$f":"IF(AJ130=\"CAP3\",SUM(AK249:AO249),AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",AK244*AK28,AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",AL244*AL28,AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",AM244*AM28,AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",AN244*AN28,AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",AO244*AO28,AJ130)","v":"CAP2"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,530,"Final Total End User Revenue","r500 + r510 + r520",{"$f":"IF(AJ130=\"CAP3\",SUM(AJ247:AJ249),AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",SUM(AK247:AK249),AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",SUM(AL247:AL249),AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",SUM(AM247:AM249),AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",SUM(AN247:AN249),AJ130)","v":"CAP2"},{"$f":"IF(AJ130=\"CAP3\",SUM(AO247:AO249),AJ130)","v":"CAP2"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,600,"Actual vs. Allowable Revenue:  Over-recovery","r530 - r130",{"$f":"IF(AJ130=\"CAP3\",AJ250-AJ209,AJ130)","v":"CAP2"},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","          or (Under-recovery)",""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAP-4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Filing Date:                \"&DATE","v":"Filing Date:                06/17/2024"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Filing Entity:               \"&COSA","v":"Filing Entity:               "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Transmittal Number:   \"&TRANSMITTAL","v":"Transmittal Number:   "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NAME","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 1 of 1",null,"Price Cap Tariff Review Plan"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Allocation of Pool Revenues to MLB PICC & MLB EUCL"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total","No Zone / Zone A","Zone B","Zone C","Zone D","Other Zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Source","(a)","(b)","(c)","(d)","(e)","(f)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","For rows 100&105: If CAP1r1110=\"Yes\", use sourcing; else enter \"No Pooling\"."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,"Pooling Amount?","Input",null,"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,105,"CAP Form containing final EUCL Rates?","CAP1r1130",{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",AJ130)","v":"No Pooling"},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","MLB Pooled Rates for CAP1 & CAP2 Forms","For rows 110 to 220: If CAP4r105=\"CAP1\"or\"CAP2\" or if Jurisdictional pricing, use sourcing; else, r105 value."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,110,"MLB, PRI ISDN & Centrex EUCL Cap","CAP1r420",{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AND(AJ269<>\"CAP1\",AJ269<>\"CAP2\"),AJ130,AJ48))","v":"No Pooling"},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,120,"MLB, PRI & Centrex EUCL Rate","if r105=\"CAP1\", CAP1r520;  =\"CAP2\",CAP2r420;",{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AND(AJ269<>\"CAP1\",AJ269<>\"CAP2\"),AJ130,IF(AJ130=\"CAP1\",AJ48,AJ159)))","v":"No Pooling"},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,130,"MLB, PRI ISDN Revenue below EUCL CAP","(r110-r120)*(CAP1r120) or Sum of Jurisdictns",{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AND(AJ269<>\"CAP1\",AJ269<>\"CAP2\"),AJ130,(AJ273-AJ274)*AJ28))","v":"No Pooling"},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,140,"Pooling revenue to be recovered from MLB EUCL Rate","Min(r130,r100) or Sum of Jurisdictions",{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AND(AJ269<>\"CAP1\",AJ269<>\"CAP2\"),AJ130,MIN(AJ276,AJ268)))","v":"No Pooling"},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,150,"MLB EUCL rate","r120+(r140/CAP1r120) ",{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AND(AJ269<>\"CAP1\",AJ269<>\"CAP2\"),AJ130,IF(AJ28=0,0,AJ274+(AJ277/AJ28))))","v":"No Pooling"},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,155,"MLB EUCL Revenue","r150 * (CAP1r120), or Sum of Jurisdictions",{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AND(AJ269<>\"CAP1\",AJ269<>\"CAP2\"),AJ130,AJ278*(AJ28)))","v":"No Pooling"},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,160,"Remaining Pooling Revenues","r100 - r140",{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AJ269=\"CAP3\",AJ130,AJ268-AJ277))","v":"No Pooling"},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,170,"MLB PICC Cap","CAP1r430",{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AJ269=\"CAP3\",AJ269,AJ49))","v":"No Pooling"},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,180,"Maximum Average MLB, PRI & Centrex PICC Rate","CAP1r830",{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AJ269=\"CAP3\",AJ269,AJ106))","v":"No Pooling"},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,190,"MLB PICC Revenue below CAP","(r170-r180)*(CAP1(r200+r210/9+r220)) or Sum",{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AJ269=\"cap3\",AJ269,(AJ284-AJ285)*(AJ32+AJ33/9+AJ34)))","v":"No Pooling"},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200,"Pooling revenue to be recovered from MLB PICC Rate","Min(r190,r160)",{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AJ269=\"CAP3\",AJ130,MIN(AJ286,AJ282)))","v":"No Pooling"},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,210,"MLB PICC rate","r180+(r200/CAP1(r200+r210/9+r220)) ",{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AJ269=\"CAP3\",AJ130,IF(AJ32+AJ33/9+AJ34=0,0,AJ285+(AJ287/(AJ32+AJ33/9+AJ34)))))","v":"No Pooling"},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,220,"MLB PICC Revenue","r 210 * (CAP1(r200+r210/9+r220)), or Sum of ",{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AJ269=\"CAP3\",AJ130,AJ288*(AJ32+AJ33/9+AJ34)))","v":"No Pooling"},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","          Jurisdictions"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","MLB Pooled EU Rates for CAP3","For rows 300 to 400: If CAP4r105=\"CAP3\" or if Jurisdictional pricing, use sourcing; else value from CAP1r1130."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,300,"Total MLB&PRI ISDN lines (include both PRI * 5 & Centrex)","CAP1r120 or Sum of CAP3-priced Jurisdictns",{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AJ269<>\"CAP3\",AJ130,AJ28))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AJ269<>\"CAP3\",AJ130,AK28))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AJ269<>\"CAP3\",AJ130,AL28))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AJ269<>\"CAP3\",AJ130,AM28))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AJ269<>\"CAP3\",AJ130,AN28))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AJ269<>\"CAP3\",AJ130,AO28))","v":"No Pooling"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,310,"CAP3 Final MLB, PRI ISDN, & Centrex EU Rate","if r105=\"CAP3\",CAP3r420; else r105","      N/A",{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AJ269=\"CAP3\",AK244,AJ130))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AJ269=\"CAP3\",AL244,AJ130))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AJ269=\"CAP3\",AM244,AJ130))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AJ269=\"CAP3\",AN244,AJ130))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AJ269=\"CAP3\",AO244,AJ130))","v":"No Pooling"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,320,"CAP3 Final Total MLB, PRI ISDN, & Centrex EU Revenue","CAP3r520 or Sum of CAP3-priced Jurisdictns",{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(OR(AJ269=\"CAP1\",AJ269=\"CAP2\"),AJ130,SUM(AK295:AO295)))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AJ269<>\"CAP3\",AJ130,AK293*AK294))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AJ269<>\"CAP3\",AJ130,AL293*AL294))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AJ269<>\"CAP3\",AJ130,AM293*AM294))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AJ269<>\"CAP3\",AJ130,AN293*AN294))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AJ269<>\"CAP3\",AJ130,AO293*AO294))","v":"No Pooling"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,330,"CAP3 Final MLB Rate adjusted for Pooling amount","a: min(330b.f) b-f:(sum(r310b.f)+r100a)/sum(r300b.f)",{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AJ269<>\"CAP3\",AJ130,MIN(AK296:AO296)))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AJ269<>\"CAP3\",AJ130,IF(SUM(AK293)=0,0,(SUM(AK295)+AJ268)/(SUM(AK293)))))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AJ269<>\"CAP3\",AJ130,IF(SUM(AK293:AL293)=0,0,(SUM(AK295:AL295)+AJ268)/(SUM(AK293:AL293)))))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AJ269<>\"CAP3\",AJ130,IF(SUM(AK293:AM293)=0,0,(SUM(AK295:AM295)+AJ268)/(SUM(AK293:AM293)))))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AJ269<>\"CAP3\",AJ130,IF(SUM(AK293:AN293)=0,0,(SUM(AK295:AN295)+AJ268)/(SUM(AK293:AN293)))))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AJ269<>\"CAP3\",AJ130,IF(SUM(AK293:AO293)=0,0,(SUM(AK295:AO295)+AJ268)/(SUM(AK293:AO293)))))","v":"No Pooling"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,340,"Final MLB, PRI ISDN & Centrex EU Rate with Pooling","max(r310,r330a)","      N/A",{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AJ269<>\"CAP3\",AJ130,IF(AK294=0,0,MAX(AK294,AJ296))))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AJ269<>\"CAP3\",AJ130,IF(AL294=0,0,MAX(AL294,AJ296))))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AJ269<>\"CAP3\",AJ130,IF(AM294=0,0,MAX(AM294,AJ296))))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AJ269<>\"CAP3\",AJ130,IF(AN294=0,0,MAX(AN294,AJ296))))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AJ269<>\"CAP3\",AJ130,IF(AO294=0,0,MAX(AO294,AJ296))))","v":"No Pooling"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,350,"MLB EUCL Revenue","r300*r340 or Sum of CAP3-priced Jurisdictns",{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(OR(AJ269=\"CAP1\",AJ269=\"CAP2\"),AJ130,SUM(AK298:AO298)))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AJ269<>\"CAP3\",AJ130,AK293*AK297))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AJ269<>\"CAP3\",AJ130,AL293*AL297))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AJ269<>\"CAP3\",AJ130,AM293*AM297))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AJ269<>\"CAP3\",AJ130,AN293*AN297))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AJ269<>\"CAP3\",AJ130,AO293*AO297))","v":"No Pooling"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,400,"Un-recovered Pool Revenues","if CAP1r1110=\"No\", then \"No Pooling\"; else ",{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(AJ269=\"CAP3\",AJ268+AJ295-AJ298,AJ282-AJ287))","v":"No Pooling"},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","       if r105=\"CAP3\", then r100+r320-r350; "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","       else r160-r200"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAP-5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Filing Date:                \"&DATE","v":"Filing Date:                06/17/2024"},null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Filing Entity:               \"&COSA","v":"Filing Entity:               "},null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Transmittal Number:   \"&TRANSMITTAL","v":"Transmittal Number:   "},null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NAME","v":0},null,"Price Cap Tariff Review Plan"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 1 of 1",null,"Verification of Recovered CMT Revenue"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Source","(a)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,"Maximum CMT Revenue","CAP1r600",{"$f":"AJ86","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,110,"Total USAC Receipts","CAP1r660",{"$f":"AJ93","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,125,"Pooling Revenues","if CAP1r1110 = \"Yes\", CAP4r100",{"$f":"IF(AJ128=\"Yes\",AJ268,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,130,"Maximum Recoverable Revenue","r100 - r110 + r125",{"$f":"AJ326-AJ327+AJ329","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200,"Final Total Primary Res & SLB & LifeLine EU Revenue","if CAP1r1130 = \"CAP1\", CAP1r610",{"$f":"IF(AJ130=\"CAP1\",AJ132,IF(AJ130=\"CAP2\",AJ162,IF(AJ130=\"CAP3\",AJ247,\"          ERROR\")))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","if CAP1r1130 = \"CAP2\", CAP2r500"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","if CAP1r1130 = \"CAP3\", CAP3r500"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,210,"Final Total NonPrim Res & BRI ISDN EU Revenue","if CAP1r1130 = \"CAP1\", CAP1r620",{"$f":"IF(AJ130=\"CAP1\",AJ133,IF(AJ130=\"CAP2\",AJ163,IF(AJ130=\"CAP3\",AJ248,\"          ERROR\")))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","if CAP1r1130 = \"CAP2\", CAP2r510"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","if CAP1r1130 = \"CAP3\", CAP3r510"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,220,"Final Total MLB, PRI ISDN, & Centrex EU Revenue","if CAP1r1110=\"Yes\"&:",{"$f":"IF(AJ128=\"Yes\",IF(AJ130=\"CAP1\",AJ279,IF(AJ130=\"CAP2\",AJ279,IF(AJ130=\"CAP3\",AJ298,\"          ERROR\"))),IF(AJ130=\"CAP1\",AJ134,IF(AJ130=\"CAP2\",AJ164,IF(AJ130=\"CAP3\",AJ249,\"          ERROR\"))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","      if CAP1r1130=\"CAP1\" or \"CAP2\", CAP4r155"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","      if CAP1r1130=\"CAP3\", CAP4r350a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","if CAP1r1110=\"No\"&:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","      if CAP1r1130=\"CAP1\", CAP1r630"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","      if CAP1r1130=\"CAP2\", CAP2r520"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","      if CAP1r1130=\"CAP3\", CAP3r520"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,300,"Final Total EUCL Revenue","r200 + r210 + r220",{"$f":"AJ332+AJ336+AJ340","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,310,"Final Total PICC Revenue","if CAP1r1110=\"Yes\"&CAP1r1130<>\"CAP3\", ",{"$f":"IF(AND(AJ128=\"Yes\",AJ130<>\"CAP3\"),AJ289,AJ109)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","     CAP4 r220; else CAP1r860"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,320,"Final Total CCL Revenue","CAP1r995",{"$f":"AJ124","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,400,"Final Total Recovered Revenue","r300 + r310 + r320",{"$f":"SUM(AJ351:AJ354)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500,"Allowable Revenue Over-recovery/(Under-recovery)","r400-r130",{"$f":"ROUND(AJ356-AJ330,0)","v":0},{"$f":"IF(AJ358>0,\"     Error:  Over-recovery. You must change some rates.\",IF(AJ358<0,\"     You have under-recovered by this amount.\",\"     ok\"))","v":"     ok"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,600,"Nonrecoverable from PICC and CCL","CAP1r950-CAP1r995",{"$f":"AJ118-AJ124","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,605,"Annual Filing Non Recoverable Dollars ","if Annual filing = 0 else r600 - r610 from the Annual Filing",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,607,"Cumulative CAF-ICC Exog Cost Base Year"," base year from which Cumulative Exog Cost are calc'd","NA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,608,"Cumulative  CAF-ICC Exogenous Cost","See details on Exogenous Cost Details worksheet",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,610,"  Annual Previous year Exog calculation:","r600<=0,0,max(0,min(EXG1r160 colsB+H+J),r600",{"$f":"IF(OR(AJ363=\"NA\",AJ363=\"\"),IF(AJ361<=0,0,MAX(0,MIN(AJ361,M29+S29+L44))),AJ364)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Mid-Year Previous year Exog calculation:","Max(0,r600-r605)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Cumulative  Exog calculation:","r608"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FOOTNOTES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Filing Date:                \"&DATE","v":"Filing Date:                06/17/2024"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Filing Entity:               \"&COSA","v":"Filing Entity:               "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Transmittal Number:   \"&TRANSMITTAL","v":"Transmittal Number:   "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NAME","v":0},null,"Price Cap Tariff Review Plan"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 1 of 1",null,"           Footnotes"]