{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["A","RTEs","CAPs"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":39,"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":53,"rows_kept":380,"cut":false,"hidden":false,"merged":[]}
["Filing Date (enter w/leading '):",null,null,"06/16/2021","2021 Annual Filing"]
["Tariff Entity (4 character COSA code):",null,null,null,null,null,null,"EOPYDate (enter w/leading ')","6/30/2021"]
["Transmittal Number (enter w/leading '):",null,null,null,null,null,null,"Total # Juris ",1]
["Filing Name:",null,null,null,null,null,null,"Date of Last PCI Update","10/01/2020"]
[]
["1) Uses multiplicative SBI Upper limits",null,null,null,"Jurisdictional SLCs?"]
["2) ANALYZER starts in column BT",null,null,null,"Jurisdictional PICCs?"]
[null,null,null,null,"Jurisdictional MOU?"]
[null,null,null,null,"Jurisdictional Targeting?"]
[null,null,null,null,"Mixed Jurisdictional SPM?"]
["SUM-1 chart.  Arrow right for next chart. ",null,null,null,null,null,null,null,null,"EXG-1 chart, Page 1.  Arrow down for next page and 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"]
["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/16/2021"},null,null,null,null,null,null,null,null,{"$f":"\"Filing Date:                \"&DATE","v":"Filing Date:                06/16/2021"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Filing Date:                \"&DATE","v":"Filing Date:                06/16/2021"},null,null,null,null,null,null,null,null,null,null,{"$f":"\"Filing Date:                \"&DATE","v":"Filing Date:                06/16/2021"},null,null,null,null,null,null,null,null,{"$f":"\"Filing Date:                \"&$D$1","v":"Filing Date:                06/16/2021"}]
[{"$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,null,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$4) & \"/\"& DAY($I$4) & \"/\" & RIGHT(YEAR($I$4),2)","v":"RATES AT 10/1/20"},"DEMAND x","DEMAND x",{"$f":"\"RATES AT \" & MONTH($I$4) & \"/\"& DAY($I$4) & \"/\" & RIGHT(YEAR($I$4),2)","v":"RATES AT 10/1/20"},"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$4) & \"/\"& DAY($I$4) & \"/\" & RIGHT(YEAR($I$4),2) & \" PCI\"","v":"10/1/20 PCI"},"CURRENT","PROPOSED",{"$f":"\"RATES AT \" & MONTH($I$4) & \"/\"& DAY($I$4) & \"/\" & RIGHT(YEAR($I$4),2)","v":"RATES AT 10/1/20"},"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,{"$f":"RTEs!D30","v":0},{"$f":"RTEs!E30","v":0},{"$f":"RTEs!F30","v":0},{"$f":"RTEs!G30","v":0},{"$f":"RTEs!H30","v":0},{"$f":"RTEs!I30","v":0},{"$f":"RTEs!J30","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,{"$f":"RTEs!D31","v":0},{"$f":"RTEs!E31","v":0},{"$f":"RTEs!F31","v":0},{"$f":"RTEs!G31","v":0},{"$f":"RTEs!H31","v":0},{"$f":"RTEs!I31","v":0},{"$f":"RTEs!J31","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,{"$f":"RTEs!D32","v":0},{"$f":"RTEs!E32","v":0},{"$f":"RTEs!F32","v":0},{"$f":"RTEs!G32","v":0},{"$f":"RTEs!H32","v":0},{"$f":"RTEs!I32","v":0},{"$f":"RTEs!J32","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,{"$f":"RTEs!D33","v":0},{"$f":"RTEs!E33","v":0},{"$f":"RTEs!F33","v":0},{"$f":"RTEs!G33","v":0},{"$f":"RTEs!H33","v":0},{"$f":"RTEs!I33","v":0},{"$f":"RTEs!J33","v":0},"    N/A",210,"Total Business Centrex Lines in groups with 9 or more lines","Input or Sum of Jurisdictions",{"$f":"CAPs!D33","v":0},"      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",{"$f":"RTEs!H34","v":0},{"$f":"RTEs!I34","v":0},{"$f":"RTEs!J34","v":0},"    N/A",220,"Total Business Groups with less than 9 lines in the group","Input or Sum of Jurisdictions",{"$f":"CAPs!D34","v":0},"      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,"","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,null,null,null,null,null,null,null,null,null,112,"Primary Res, Single Line Bus, Lifeline EUCL (1)",null,{"$f":"RTEs!D37","v":0},{"$f":"RTEs!E37","v":0},{"$f":"RTEs!F37","v":0},{"$f":"RTEs!G37","v":0},{"$f":"RTEs!H37","v":0},{"$f":"RTEs!I37","v":0},{"$f":"RTEs!J37","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,{"$f":"RTEs!D38","v":0},{"$f":"RTEs!E38","v":0},{"$f":"RTEs!F38","v":0},{"$f":"RTEs!G38","v":0},{"$f":"RTEs!H38","v":0},{"$f":"RTEs!I38","v":0},{"$f":"RTEs!J38","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,{"$f":"RTEs!D39","v":0},{"$f":"RTEs!E39","v":0},{"$f":"RTEs!F39","v":0},{"$f":"RTEs!G39","v":0},{"$f":"RTEs!H39","v":0},{"$f":"RTEs!I39","v":0},{"$f":"RTEs!J39","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,{"$f":"RTEs!D42","v":0},{"$f":"RTEs!E42","v":0},{"$f":"RTEs!F42","v":0},{"$f":"RTEs!G42","v":0},{"$f":"RTEs!H42","v":0},{"$f":"RTEs!I42","v":0},{"$f":"RTEs!J42","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,{"$f":"RTEs!D43","v":0},{"$f":"RTEs!E43","v":0},{"$f":"RTEs!F43","v":0},{"$f":"RTEs!G43","v":0},{"$f":"RTEs!H43","v":0},{"$f":"RTEs!I43","v":0},{"$f":"RTEs!J43","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,{"$f":"RTEs!D44","v":0},{"$f":"RTEs!E44","v":0},{"$f":"RTEs!F44","v":0},{"$f":"RTEs!G44","v":0},{"$f":"RTEs!H44","v":0},{"$f":"RTEs!I44","v":0},{"$f":"RTEs!J44","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,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,{"$f":"RTEs!D47","v":0},{"$f":"RTEs!E47","v":0},{"$f":"RTEs!F47","v":0},{"$f":"RTEs!G47","v":0},{"$f":"RTEs!H47","v":0},{"$f":"RTEs!I47","v":0},{"$f":"RTEs!J47","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,{"$f":"RTEs!D48","v":0},{"$f":"RTEs!E48","v":0},{"$f":"RTEs!F48","v":0},{"$f":"RTEs!G48","v":0},{"$f":"RTEs!H48","v":0},{"$f":"RTEs!I48","v":0},{"$f":"RTEs!J48","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,{"$f":"RTEs!D49","v":0},{"$f":"RTEs!E49","v":0},{"$f":"RTEs!F49","v":0},{"$f":"RTEs!G49","v":0},{"$f":"RTEs!H49","v":0},{"$f":"RTEs!I49","v":0},{"$f":"RTEs!J49","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,{"$f":"RTEs!D52","v":0},{"$f":"RTEs!E52","v":0},{"$f":"RTEs!F52","v":0},{"$f":"RTEs!G52","v":0},{"$f":"RTEs!H52","v":0},{"$f":"RTEs!I52","v":0},{"$f":"RTEs!J52","v":0},"    N/A",440,"Current MaxCMT Rev per Line (from previous filing)","Input (r460 from prev filing) or Wtd Avg of Juris",{"$f":"CAPs!D52","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,144,"NonPrimary Residence & BRI ISDN EUCL (1)",null,{"$f":"RTEs!D53","v":0},{"$f":"RTEs!E53","v":0},{"$f":"RTEs!F53","v":0},{"$f":"RTEs!G53","v":0},{"$f":"RTEs!H53","v":0},{"$f":"RTEs!I53","v":0},{"$f":"RTEs!J53","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,{"$f":"RTEs!D54","v":0},{"$f":"RTEs!E54","v":0},{"$f":"RTEs!F54","v":0},{"$f":"RTEs!G54","v":0},{"$f":"RTEs!H54","v":0},{"$f":"RTEs!I54","v":0},{"$f":"RTEs!J54","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,{"$f":"RTEs!D59","v":0},{"$f":"RTEs!E59","v":0},{"$f":"RTEs!F59","v":0},{"$f":"RTEs!G59","v":0},{"$f":"RTEs!H59","v":0},{"$f":"RTEs!I59","v":0},{"$f":"RTEs!J59","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,{"$f":"RTEs!D60","v":0},"          N/A","          N/A","          N/A",{"$f":"RTEs!H60","v":0},{"$f":"RTEs!I60","v":0},{"$f":"RTEs!J60","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,"","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,{"$f":"RTEs!D63","v":0},{"$f":"RTEs!E63","v":0},{"$f":"RTEs!F63","v":0},{"$f":"RTEs!G63","v":0},{"$f":"RTEs!H63","v":0},{"$f":"RTEs!I63","v":0},{"$f":"RTEs!J63","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,{"$f":"RTEs!D64","v":0},{"$f":"RTEs!E64","v":0},{"$f":"RTEs!F64","v":0},{"$f":"RTEs!G64","v":0},{"$f":"RTEs!H64","v":0},{"$f":"RTEs!I64","v":0},{"$f":"RTEs!J64","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,{"$f":"RTEs!D65","v":0},{"$f":"RTEs!E65","v":0},{"$f":"RTEs!F65","v":0},{"$f":"RTEs!G65","v":0},{"$f":"RTEs!H65","v":0},{"$f":"RTEs!I65","v":0},{"$f":"RTEs!J65","v":0},"    N/A","","",""]
[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,{"$f":"RTEs!D66","v":0},{"$f":"RTEs!E66","v":0},{"$f":"RTEs!F66","v":0},{"$f":"RTEs!G66","v":0},{"$f":"RTEs!H66","v":0},{"$f":"RTEs!I66","v":0},{"$f":"RTEs!J66","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,null,null,null,null,null,null,null,null,null,null,180,"Other Common Line",null,"          N/A","          N/A","          N/A","          N/A",{"$f":"RTEs!H69","v":0},{"$f":"RTEs!I69","v":0},{"$f":"RTEs!J69","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,185,"USAC Receipts",null,{"$f":"RTEs!D70","v":0},{"$f":"RTEs!E70","v":0},{"$f":"RTEs!F70","v":0},{"$f":"RTEs!G70","v":0},{"$f":"RTEs!H70","v":0},{"$f":"RTEs!I70","v":0},{"$f":"RTEs!J70","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,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,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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/16/2021"},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/16/2021"},null,null,null,null,null,null,null,null,{"$f":"\"Filing Date:                \"&$D$1","v":"Filing Date:                06/16/2021"}]
[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":"CAPs!D86","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":"+CAPs!D87","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":"CAPs!D88","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":"CAPs!D89","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(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\"),\"See Juris\",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":"CAPs!D92","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A","     NonPrimary Res & BRI ISDN",{"$f":"IF(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\"),\"See Juris\",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":"CAPs!D93","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A","     MLB, PRI ISDN, & Centrex",{"$f":"IF(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\"),\"See Juris\",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(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\"),\"See Juris\",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(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\"),\"See Juris\",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(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\"),\"See Juris\",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":"CAPs!D99","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($G$7<>\"y\",IF(AJ99>0,AJ99,0),CAPs!D104)","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":"CAPs!D107","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":"CAPs!D108","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,"Total from"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,"A tab","CAPs tab","Delta","Flag"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,"Exog Recoverable from ARC (from CAP5 r610)",{"$f":"AJ365","v":0},{"$f":"CAPs!D365","v":0},{"$f":"ROUND(AQ114-AR114,0)","v":0},{"$f":"IF(AS114>0,\"  CAPs is LOW\",IF(AS114<0,\" CAPs is 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,"","",""]
[null,null,null,null,null,null,null,null,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",{"$f":"CAPs!D116","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,945,"Prem. Terminating MOU Rate as of Dec. 29, 2011","Input or Weighted Avg of Jurisdictns",{"$f":"CAPs!D117","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,950,"Maximum CCL Revenue","r810 - r860, or Sum of Jurisdictions",{"$f":"CAPs!D118","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":"CAPs!D122","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":"CAPs!D123","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($G$10=\"y\",\"JurisMix\",IF($G$8=\"y\",\"JurisSPM\",IF($G$7=\"y\",\"JurisSP\",IF($G$6=\"y\",\"JurisS\",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":"CAPs!D132","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,1150,"Max. Allowable NonPrimary Res & BRI EU Revenue","if Juris rates,sum of Juris;if 1130 =CAP1,r620;else1130",{"$f":"CAPs!D133","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,1160,"Max. Allowable MLB, PRI & Centrex EU Revenue","if Juris rates,sum of Juris;if 1130=CAP1,r630;else1130",{"$f":"CAPs!D134","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,"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/16/2021"}]
[null,null,null,null,null,null,null,null,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(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\"),CAPs!D146,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(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\"),CAPs!D147,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(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\"),CAPs!D149,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,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(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\"),CAPs!D162,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(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\"),CAPs!D163,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(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\"),CAPs!D164,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(OR(AJ130=\"CAP2\",AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\"),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(OR(AJ130=\"CAP2\",AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\"),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/16/2021"},null,""]
[null,null,null,null,null,null,null,null,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(OR((AND(AJ99<=0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\")))),(AND(AJ99>0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisMix\"))))),CAPs!D206,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(OR((AND(AJ99<=0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\")))),(AND(AJ99>0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisMix\"))))),CAPs!D207,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(OR(AJ130=\"CAP3\",AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\"),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(OR(AJ130=\"CAP3\",AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\"),SUM(AK212:AO212),AJ130)","v":"CAP2"},{"$f":"IF(OR((AND(AJ99<=0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\")))),(AND(AJ99>0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisMix\"))))),CAPs!E212,IF(AJ130=\"CAP3\",AK29,AJ130))","v":"CAP2"},{"$f":"IF(OR((AND(AJ99<=0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\")))),(AND(AJ99>0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisMix\"))))),CAPs!F212,IF(AJ130=\"CAP3\",AL29,AJ130))","v":"CAP2"},{"$f":"IF(OR((AND(AJ99<=0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\")))),(AND(AJ99>0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisMix\"))))),CAPs!G212,IF(AJ130=\"CAP3\",AM29,AJ130))","v":"CAP2"},{"$f":"IF(OR((AND(AJ99<=0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\")))),(AND(AJ99>0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisMix\"))))),CAPs!H212,IF(AJ130=\"CAP3\",AN29,AJ130))","v":"CAP2"},{"$f":"IF(OR((AND(AJ99<=0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\")))),(AND(AJ99>0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisMix\"))))),CAPs!I212,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(OR(AJ130=\"CAP3\",AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\"),SUM(AK215:AO215),AJ130)","v":"CAP2"},{"$f":"IF(OR((AND($AJ99<=0,(OR($AJ130=\"JurisSPM\",$AJ130=\"JurisSP\",$AJ130=\"JurisS\",$AJ130=\"JurisMix\")))),(AND($AJ99>0,(OR($AJ130=\"JurisSPM\",$AJ130=\"JurisMix\"))))),CAPs!E215,IF($AJ130=\"CAP3\",AK212*AK214,$AJ130))","v":"CAP2"},{"$f":"IF(OR((AND($AJ99<=0,(OR($AJ130=\"JurisSPM\",$AJ130=\"JurisSP\",$AJ130=\"JurisS\",$AJ130=\"JurisMix\")))),(AND($AJ99>0,(OR($AJ130=\"JurisSPM\",$AJ130=\"JurisMix\"))))),CAPs!F215,IF($AJ130=\"CAP3\",AL212*AL214,$AJ130))","v":"CAP2"},{"$f":"IF(OR((AND($AJ99<=0,(OR($AJ130=\"JurisSPM\",$AJ130=\"JurisSP\",$AJ130=\"JurisS\",$AJ130=\"JurisMix\")))),(AND($AJ99>0,(OR($AJ130=\"JurisSPM\",$AJ130=\"JurisMix\"))))),CAPs!G215,IF($AJ130=\"CAP3\",AM212*AM214,$AJ130))","v":"CAP2"},{"$f":"IF(OR((AND($AJ99<=0,(OR($AJ130=\"JurisSPM\",$AJ130=\"JurisSP\",$AJ130=\"JurisS\",$AJ130=\"JurisMix\")))),(AND($AJ99>0,(OR($AJ130=\"JurisSPM\",$AJ130=\"JurisMix\"))))),CAPs!H215,IF($AJ130=\"CAP3\",AN212*AN214,$AJ130))","v":"CAP2"},{"$f":"IF(OR((AND($AJ99<=0,(OR($AJ130=\"JurisSPM\",$AJ130=\"JurisSP\",$AJ130=\"JurisS\",$AJ130=\"JurisMix\")))),(AND($AJ99>0,(OR($AJ130=\"JurisSPM\",$AJ130=\"JurisMix\"))))),CAPs!I215,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(OR((AND(AJ99<=0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\")))),(AND(AJ99>0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisMix\"))))),CAPs!D216,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(OR(AJ130=\"CAP3\",AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\"),SUM(AK218:AO218),AJ130)","v":"CAP2"},{"$f":"IF(OR((AND($AJ99<=0,(OR($AJ130=\"JurisSPM\",$AJ130=\"JurisSP\",$AJ130=\"JurisS\",$AJ130=\"JurisMix\")))),(AND($AJ99>0,(OR($AJ130=\"JurisSPM\",$AJ130=\"JurisMix\"))))),CAPs!E218,IF($AJ130=\"CAP3\",AK212*AJ217,$AJ130))","v":"CAP2"},{"$f":"IF(OR((AND($AJ99<=0,(OR($AJ130=\"JurisSPM\",$AJ130=\"JurisSP\",$AJ130=\"JurisS\",$AJ130=\"JurisMix\")))),(AND($AJ99>0,(OR($AJ130=\"JurisSPM\",$AJ130=\"JurisMix\"))))),CAPs!F218,IF($AJ130=\"CAP3\",AL212*AK217,$AJ130))","v":"CAP2"},{"$f":"IF(OR((AND($AJ99<=0,(OR($AJ130=\"JurisSPM\",$AJ130=\"JurisSP\",$AJ130=\"JurisS\",$AJ130=\"JurisMix\")))),(AND($AJ99>0,(OR($AJ130=\"JurisSPM\",$AJ130=\"JurisMix\"))))),CAPs!G218,IF($AJ130=\"CAP3\",AM212*AL217,$AJ130))","v":"CAP2"},{"$f":"IF(OR((AND($AJ99<=0,(OR($AJ130=\"JurisSPM\",$AJ130=\"JurisSP\",$AJ130=\"JurisS\",$AJ130=\"JurisMix\")))),(AND($AJ99>0,(OR($AJ130=\"JurisSPM\",$AJ130=\"JurisMix\"))))),CAPs!H218,IF($AJ130=\"CAP3\",AN212*AM217,$AJ130))","v":"CAP2"},{"$f":"IF(OR((AND($AJ99<=0,(OR($AJ130=\"JurisSPM\",$AJ130=\"JurisSP\",$AJ130=\"JurisS\",$AJ130=\"JurisMix\")))),(AND($AJ99>0,(OR($AJ130=\"JurisSPM\",$AJ130=\"JurisMix\"))))),CAPs!I218,IF($AJ130=\"CAP3\",AO212*AN217,$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(OR((AND(AJ99<=0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\")))),(AND(AJ99>0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisMix\"))))),CAPs!D224,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(OR(AJ130=\"CAP3\",AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\"),SUM(AK225:AO225),AJ130)","v":"CAP2"},{"$f":"IF(OR((AND(AJ99<=0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\")))),(AND(AJ99>0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisMix\"))))),CAPs!E225,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(OR((AND(AJ99<=0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\")))),(AND(AJ99>0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisMix\"))))),CAPs!F225,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(OR((AND(AJ99<=0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\")))),(AND(AJ99>0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisMix\"))))),CAPs!G225,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(OR((AND(AJ99<=0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\")))),(AND(AJ99>0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisMix\"))))),CAPs!H225,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(OR((AND(AJ99<=0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\")))),(AND(AJ99>0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisMix\"))))),CAPs!I225,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(OR(AJ130=\"CAP3\",AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\"),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,"junk"]
[null,null,null,null,null,null,null,null,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(OR(AJ130=\"CAP3\",AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\"),SUM(AK247:AO247),AJ130)","v":"CAP2"},{"$f":"IF(OR((AND(AJ99<=0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\")))),(AND(AJ99>0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisMix\"))))),CAPs!E247,IF(AJ130=\"CAP3\",AK242*AK26,AJ130))","v":"CAP2"},{"$f":"IF(OR((AND(AJ99<=0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\")))),(AND(AJ99>0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisMix\"))))),CAPs!F247,IF(AJ130=\"CAP3\",AL242*AL26,AJ130))","v":"CAP2"},{"$f":"IF(OR((AND(AJ99<=0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\")))),(AND(AJ99>0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisMix\"))))),CAPs!G247,IF(AJ130=\"CAP3\",AM242*AM26,AJ130))","v":"CAP2"},{"$f":"IF(OR((AND(AJ99<=0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\")))),(AND(AJ99>0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisMix\"))))),CAPs!H247,IF(AJ130=\"CAP3\",AN242*AN26,AJ130))","v":"CAP2"},{"$f":"IF(OR((AND(AJ99<=0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\")))),(AND(AJ99>0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisMix\"))))),CAPs!I247,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(OR(AJ130=\"CAP3\",AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\"),SUM(AK248:AO248),AJ130)","v":"CAP2"},{"$f":"IF(OR((AND(AJ99<=0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\")))),(AND(AJ99>0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisMix\"))))),CAPs!E248,IF(AJ130=\"CAP3\",AK243*AK27,AJ130))","v":"CAP2"},{"$f":"IF(OR((AND(AJ99<=0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\")))),(AND(AJ99>0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisMix\"))))),CAPs!F248,IF(AJ130=\"CAP3\",AL243*AL27,AJ130))","v":"CAP2"},{"$f":"IF(OR((AND(AJ99<=0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\")))),(AND(AJ99>0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisMix\"))))),CAPs!G248,IF(AJ130=\"CAP3\",AM243*AM27,AJ130))","v":"CAP2"},{"$f":"IF(OR((AND(AJ99<=0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\")))),(AND(AJ99>0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisMix\"))))),CAPs!H248,IF(AJ130=\"CAP3\",AN243*AN27,AJ130))","v":"CAP2"},{"$f":"IF(OR((AND(AJ99<=0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\")))),(AND(AJ99>0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisMix\"))))),CAPs!I248,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(OR(AJ130=\"CAP3\",AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\"),SUM(AK249:AO249),AJ130)","v":"CAP2"},{"$f":"IF(OR((AND(AJ99<=0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\")))),(AND(AJ99>0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisMix\"))))),CAPs!E249,IF(AJ130=\"CAP3\",AK244*AK28,AJ130))","v":"CAP2"},{"$f":"IF(OR((AND(AJ99<=0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\")))),(AND(AJ99>0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisMix\"))))),CAPs!F249,IF(AJ130=\"CAP3\",AL244*AL28,AJ130))","v":"CAP2"},{"$f":"IF(OR((AND(AJ99<=0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\")))),(AND(AJ99>0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisMix\"))))),CAPs!G249,IF(AJ130=\"CAP3\",AM244*AM28,AJ130))","v":"CAP2"},{"$f":"IF(OR((AND(AJ99<=0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\")))),(AND(AJ99>0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisMix\"))))),CAPs!H249,IF(AJ130=\"CAP3\",AN244*AN28,AJ130))","v":"CAP2"},{"$f":"IF(OR((AND(AJ99<=0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\")))),(AND(AJ99>0,(OR(AJ130=\"JurisSPM\",AJ130=\"JurisMix\"))))),CAPs!I249,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(OR(AJ130=\"CAP3\",AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\"),SUM(AJ247:AJ249),AJ130)","v":"CAP2"},{"$f":"IF(OR(AJ130=\"CAP3\",AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\"),SUM(AK247:AK249),AJ130)","v":"CAP2"},{"$f":"IF(OR(AJ130=\"CAP3\",AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\"),SUM(AL247:AL249),AJ130)","v":"CAP2"},{"$f":"IF(OR(AJ130=\"CAP3\",AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\"),SUM(AM247:AM249),AJ130)","v":"CAP2"},{"$f":"IF(OR(AJ130=\"CAP3\",AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\"),SUM(AN247:AN249),AJ130)","v":"CAP2"},{"$f":"IF(OR(AJ130=\"CAP3\",AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\"),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(OR(AJ130=\"CAP3\",AJ130=\"JurisSPM\",AJ130=\"JurisSP\",AJ130=\"JurisS\",AJ130=\"JurisMix\"),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/16/2021"}]
[null,null,null,null,null,null,null,null,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(OR($AJ130=\"JurisSPM\",$AJ130=\"JurisSP\",$AJ130=\"JurisS\",$AJ130=\"JurisMix\"),CAPs!D276,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(OR($AJ130=\"JurisSPM\",$AJ130=\"JurisSP\",$AJ130=\"JurisS\",$AJ130=\"JurisMix\"),CAPs!D277,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(OR($AJ130=\"JurisSPM\",$AJ130=\"JurisSP\",$AJ130=\"JurisS\",$AJ130=\"JurisMix\"),CAPs!D279,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(OR($AJ130=\"JurisSPM\",$AJ130=\"JurisSP\",$AJ130=\"JurisS\",$AJ130=\"JurisMix\"),IF(AND(SUM(AJ132:AJ134)=0,AJ269=\"CAP3\"),AJ269,AJ49),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(OR($AJ130=\"JurisSPM\",$AJ130=\"JurisSP\",$AJ130=\"JurisS\",$AJ130=\"JurisMix\"),IF(AND(SUM(AJ132:AJ134)=0,AJ269=\"CAP3\"),AJ269,AJ106),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(OR($AJ130=\"JurisSPM\",$AJ130=\"JurisSP\",$AJ130=\"JurisS\",$AJ130=\"JurisMix\"),IF(AND(SUM(AJ132:AJ134)=0,AJ269=\"CAP3\"),AJ269,CAPs!D286),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(OR(AJ269=\"CAP3\",AJ269=\"JurisSPM\",AJ269=\"JurisMix\"),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(OR(AJ130=\"JurisSPM\",AJ130=\"JurisMix\"),CAPs!D289,IF(OR(AJ269=\"CAP3\",AJ269=\"JurisSPM\",AJ269=\"JurisMix\"),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(OR(AJ269=\"JurisSPM\",AJ269=\"JurisSP\",AJ269=\"JurisS\",AJ269=\"JurisMix\"),CAPs!D293,IF(AJ269<>\"CAP3\",AJ130,AJ28)))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(OR(AJ269=\"JurisSPM\",AJ269=\"JurisSP\",AJ269=\"JurisS\",AJ269=\"JurisMix\"),CAPs!E293,IF(AJ269<>\"CAP3\",AJ130,AK28)))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(OR(AJ269=\"JurisSPM\",AJ269=\"JurisSP\",AJ269=\"JurisS\",AJ269=\"JurisMix\"),CAPs!F293,IF(AJ269<>\"CAP3\",AJ130,AL28)))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(OR(AJ269=\"JurisSPM\",AJ269=\"JurisSP\",AJ269=\"JurisS\",AJ269=\"JurisMix\"),CAPs!G293,IF(AJ269<>\"CAP3\",AJ130,AM28)))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(OR(AJ269=\"JurisSPM\",AJ269=\"JurisSP\",AJ269=\"JurisS\",AJ269=\"JurisMix\"),CAPs!H293,IF(AJ269<>\"CAP3\",AJ130,AN28)))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(OR(AJ269=\"JurisSPM\",AJ269=\"JurisSP\",AJ269=\"JurisS\",AJ269=\"JurisMix\"),CAPs!I293,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(OR(AJ269=\"JurisSPM\",AJ269=\"JurisSP\",AJ269=\"JurisS\",AJ269=\"JurisMix\"),CAPs!E295,IF(AJ269<>\"CAP3\",AJ130,AK293*AK294)))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(OR(AJ269=\"JurisSPM\",AJ269=\"JurisSP\",AJ269=\"JurisS\",AJ269=\"JurisMix\"),CAPs!F295,IF(AJ269<>\"CAP3\",AJ130,AL293*AL294)))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(OR(AJ269=\"JurisSPM\",AJ269=\"JurisSP\",AJ269=\"JurisS\",AJ269=\"JurisMix\"),CAPs!G295,IF(AJ269<>\"CAP3\",AJ130,AM293*AM294)))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(OR(AJ269=\"JurisSPM\",AJ269=\"JurisSP\",AJ269=\"JurisS\",AJ269=\"JurisMix\"),CAPs!H295,IF(AJ269<>\"CAP3\",AJ130,AN293*AN294)))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(OR(AJ269=\"JurisSPM\",AJ269=\"JurisSP\",AJ269=\"JurisS\",AJ269=\"JurisMix\"),CAPs!I295,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(OR(AJ269=\"JurisSPM\",AJ269=\"JurisSP\",AJ269=\"JurisS\",AJ269=\"JurisMix\"),CAPs!E298,IF(AJ269<>\"CAP3\",AJ130,AK293*AK297)))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(OR(AJ269=\"JurisSPM\",AJ269=\"JurisSP\",AJ269=\"JurisS\",AJ269=\"JurisMix\"),CAPs!F298,IF(AJ269<>\"CAP3\",AJ130,AL293*AL297)))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(OR(AJ269=\"JurisSPM\",AJ269=\"JurisSP\",AJ269=\"JurisS\",AJ269=\"JurisMix\"),CAPs!G298,IF(AJ269<>\"CAP3\",AJ130,AM293*AM297)))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(OR(AJ269=\"JurisSPM\",AJ269=\"JurisSP\",AJ269=\"JurisS\",AJ269=\"JurisMix\"),CAPs!H298,IF(AJ269<>\"CAP3\",AJ130,AN293*AN297)))","v":"No Pooling"},{"$f":"IF(AJ128<>\"Yes\",\"No Pooling\",IF(OR(AJ269=\"JurisSPM\",AJ269=\"JurisSP\",AJ269=\"JurisS\",AJ269=\"JurisMix\"),CAPs!I298,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,IF(OR(AJ269=\"JurisSPM\",AJ269=\"JurisSP\",AJ269=\"JurisS\",AJ269=\"JurisMix\"),AJ268+AJ295-AJ298-AJ277,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,"","","       if r105=\"Juris\", then r100+r320-r350-r140; "]
[null,null,null,null,null,null,null,null,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,"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/16/2021"},null,""]
[null,null,null,null,null,null,null,null,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":"CAPs!D326","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":"CAPs!D327","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":"CAPs!D329","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":"CAPs!D330","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":"CAPs!D332","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,"","","if CAP1r1130=\"Juris\",CAP1r1140+CAP2r500+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,210,"Final Total NonPrim Res & BRI ISDN EU Revenue","if CAP1r1130 = \"CAP1\", CAP1r620",{"$f":"CAPs!D336","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,"","","if CAP1r1130=\"Juris\",CAP1r1150+CAP2r510+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,220,"Final Total MLB, PRI ISDN, & Centrex EU Revenue","if CAP1r1110=\"Yes\"&:",{"$f":"CAPs!D340","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,"","","      if CAP1r1130=\"Juris\", CAP4(r155+r350a)"]
[null,null,null,null,null,null,null,null,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,"","","      if CAP1r1130=\"Juris\", CAP1r1160+CAP2r520+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,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"]
[null,null,null,null,null,null,null,null,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,"Recoverable from ARC ",null,{"$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,"  Annual Previous year Exog calculation:","r600<=0,0,max(0,min(EXG1r160 colsB+H+J),r600"]
[null,null,null,null,null,null,null,null,null,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/16/2021"}]
[null,null,null,null,null,null,null,null,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"]

{"sheet":"RTEs","index":1,"n_rows":74,"n_cols":20,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
[]
[]
["The Totals for all COSAs are in columns D through K"]
["in rows 15 through 74."]
[]
["COSAs with Jurisdictionally Separate SLCs, PICCs,"]
["and/or CCL are in rows 15 through 74 beginning in"]
["column M."]
[]
["Separate Exog Cost CMT ratios for split by above"]
["groupings, have values (not TOTAL) entered in rows 74."]
[]
[null,null,"Jurisdiction Number:",null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,"Juris name"]
["RTE-1J",null,null,"TOTAL"]
[{"$f":"\"Filing Date:                \"&DATE","v":"Filing Date:                06/16/2021"}]
[{"$f":"\"Filing Entity:               \"&COSA","v":"Filing Entity:               "}]
[{"$f":"\"Transmittal Number:   \"&TRANSMITTAL","v":"Transmittal Number:   "}]
[{"$f":"NAME","v":0}]
["Page 1",null,null,null,null,"Price Cap Tariff Review Plan",null,null,null,null,null,null,null,null,"Price Cap Tariff Review Plan"]
[null,null,null,null,null,"Common Line Basket",null,null,null,null,null,null,null,null,"Common Line Basket"]
[]
[null,null,null,null,null,null,null,"BASE PERIOD","BASE PERIOD","BASE PERIOD",null,null,null,null,null,null,"BASE PERIOD","BASE PERIOD","BASE PERIOD"]
[null,null,null,"BASE","RATES AT",null,null,"DEMAND x","DEMAND x","DEMAND x",null,null,"BASE","RATES AT",null,null,"DEMAND x","DEMAND x","DEMAND x"]
[null,null,null,"PERIOD","10/1/20 PCI","CURRENT","PROPOSED","RATES AT 10/1/20","CURRENT","PROPOSED","INDEX ",null,"PERIOD","10/1/20 PCI","CURRENT","PROPOSED","RATES AT 10/1/20","CURRENT","PROPOSED","INDEX "]
[null,null,null,"DEMAND","UPDATE","RATES","RATES","PCI UPDATE","RATES","RATES","RESULTS",null,"DEMAND","UPDATE","RATES","RATES","PCI UPDATE","RATES","RATES","RESULTS"]
[null,null,"-","-","-","-","-","-","-","-","-",null,"-","-","-","-","-","-","-","-"]
["","End User Common Line (EUCL)",null,"(A)","(B)","(C)","(D)","(E)","(F)","(G)","(H)",null,"(A)","(B)","(C)","(D)","(E)","(F)","(G)","(H)"]
["","No Zone or Zone A:"]
[102,"Primary Res, Single Line Bus, Lifeline EUCL (1)",null,{"$f":"SUM(M30)","v":0},{"$f":"IF($D30=0,0,H30/$D30)","v":0},0,0,{"$f":"SUM(Q30)","v":0},0,0,"    N/A",null,null,null,null,null,{"$f":"M30*N30","v":0},{"$f":"M30*O30","v":0},{"$f":"M30*P30","v":0},"    N/A"]
[104,"NonPrimary Residence & BRI ISDN EUCL (1)",null,{"$f":"SUM(M31)","v":0},0,0,0,0,0,0,"    N/A",null,null,null,null,null,{"$f":"M31*N31","v":0},{"$f":"M31*O31","v":0},{"$f":"M31*P31","v":0},"    N/A"]
[106,"Multiline Bus, PRI ISDN, Centrex EUCL (1)",null,{"$f":"SUM(M32)","v":0},0,0,0,0,0,0,"    N/A",null,null,null,null,null,{"$f":"M32*N32","v":0},{"$f":"M32*O32","v":0},{"$f":"M32*P32","v":0},"    N/A"]
[108,"Special Access Surcharge",null,{"$f":"SUM(M33)","v":0},0,0,0,0,0,0,"    N/A",null,null,null,null,null,{"$f":"M33*N33","v":0},{"$f":"M33*O33","v":0},{"$f":"M33*P33","v":0},"    N/A"]
[109,"Other EUCL",null,"          N/A","          N/A","          N/A","          N/A",0,0,0,"    N/A",null,"          N/A","          N/A","          N/A","          N/A",null,null,null,"    N/A"]
["",""]
["","Zone B:"]
[112,"Primary Res, Single Line Bus, Lifeline EUCL (1)",null,{"$f":"SUM(M37)","v":0},{"$f":"IF($D37=0,0,H37/$D37)","v":0},0,0,{"$f":"SUM(Q37)","v":0},0,0,"    N/A",null,null,null,null,null,{"$f":"M37*N37","v":0},{"$f":"M37*O37","v":0},{"$f":"M37*P37","v":0},"    N/A"]
[114,"NonPrimary Residence & BRI ISDN EUCL (1)",null,{"$f":"SUM(M38)","v":0},0,0,0,0,0,0,"    N/A",null,null,null,null,null,{"$f":"M38*N38","v":0},{"$f":"M38*O38","v":0},{"$f":"M38*P38","v":0},"    N/A"]
[116,"Multiline Bus, PRI ISDN, Centrex EUCL (1)",null,{"$f":"SUM(M39)","v":0},0,0,0,0,0,0,"    N/A",null,null,null,null,null,{"$f":"M39*N39","v":0},{"$f":"M39*O39","v":0},{"$f":"M39*P39","v":0},"    N/A"]
["",""]
["","Zone C:"]
[122,"Primary Res, Single Line Bus, Lifeline EUCL (1)",null,{"$f":"SUM(M42)","v":0},{"$f":"IF($D42=0,0,H42/$D42)","v":0},0,0,{"$f":"SUM(Q42)","v":0},0,0,"    N/A",null,null,null,null,null,{"$f":"M42*N42","v":0},{"$f":"M42*O42","v":0},{"$f":"M42*P42","v":0},"    N/A"]
[124,"NonPrimary Residence & BRI ISDN EUCL (1)",null,{"$f":"SUM(M43)","v":0},0,0,0,0,0,0,"    N/A",null,null,null,null,null,{"$f":"M43*N43","v":0},{"$f":"M43*O43","v":0},{"$f":"M43*P43","v":0},"    N/A"]
[126,"Multiline Bus, PRI ISDN, Centrex EUCL (1)",null,{"$f":"SUM(M44)","v":0},0,0,0,0,0,0,"    N/A",null,null,null,null,null,{"$f":"M44*N44","v":0},{"$f":"M44*O44","v":0},{"$f":"M44*P44","v":0},"    N/A"]
["",""]
["","Zone D:"]
[132,"Primary Res, Single Line Bus, Lifeline EUCL (1)",null,{"$f":"SUM(M47)","v":0},{"$f":"IF($D47=0,0,H47/$D47)","v":0},0,0,{"$f":"SUM(Q47)","v":0},0,0,"    N/A",null,null,null,null,null,{"$f":"M47*N47","v":0},{"$f":"M47*O47","v":0},{"$f":"M47*P47","v":0},"    N/A"]
[134,"NonPrimary Residence & BRI ISDN EUCL (1)",null,{"$f":"SUM(M48)","v":0},0,0,0,0,0,0,"    N/A",null,null,null,null,null,{"$f":"M48*N48","v":0},{"$f":"M48*O48","v":0},{"$f":"M48*P48","v":0},"    N/A"]
[136,"Multiline Bus, PRI ISDN, Centrex EUCL (1)",null,{"$f":"SUM(M49)","v":0},0,0,0,0,0,0,"    N/A",null,null,null,null,null,{"$f":"M49*N49","v":0},{"$f":"M49*O49","v":0},{"$f":"M49*P49","v":0},"    N/A"]
["",""]
["","Zone - Other:"]
[142,"Primary Res, Single Line Bus, Lifeline EUCL (1)",null,{"$f":"SUM(M52)","v":0},{"$f":"IF($D52=0,0,H52/$D52)","v":0},0,0,{"$f":"SUM(Q52)","v":0},0,0,"    N/A",null,null,null,null,null,{"$f":"M52*N52","v":0},{"$f":"M52*O52","v":0},{"$f":"M52*P52","v":0},"    N/A"]
[144,"NonPrimary Residence & BRI ISDN EUCL (1)",null,{"$f":"SUM(M53)","v":0},0,0,0,0,0,0,"    N/A",null,null,null,null,null,{"$f":"M53*N53","v":0},{"$f":"M53*O53","v":0},{"$f":"M53*P53","v":0},"    N/A"]
[146,"Multiline Bus, PRI ISDN, Centrex EUCL (1)",null,{"$f":"SUM(M54)","v":0},0,0,0,0,0,0,"    N/A",null,null,null,null,null,{"$f":"M54*N54","v":0},{"$f":"M54*O54","v":0},{"$f":"M54*P54","v":0},"    N/A"]
["",""]
["","Presubscribed Interexchange Carrier Charge (PICC)"]
[]
[]
[155,"Multiline Business & PRI ISDN PICC           (1)",null,{"$f":"SUM(M59)","v":0},{"$f":"IF($D59=0,0,H59/$D59)","v":0},{"$f":"IF($D59=0,0,I59/$D59)","v":0},{"$f":"IF($D59=0,0,J59/$D59)","v":0},{"$f":"SUM(Q59)","v":0},0,0,"    N/A",null,null,null,null,null,{"$f":"M59*N59","v":0},{"$f":"M59*O59","v":0},{"$f":"M59*P59","v":0},"    N/A"]
[157,"Business Centrex PICC",null,{"$f":"SUM(M60)","v":0},"          N/A","          N/A","          N/A",0,0,0,"    N/A",null,null,"          N/A","          N/A","          N/A",null,null,null,"    N/A"]
["",""]
["","Carrier Common Line"]
[161,"Terminating CCL Prem.",null,{"$f":"SUM(M63)","v":0},{"$f":"IF($D63=0,0,H63/$D63)","v":0},0,0,{"$f":"SUM(Q63)","v":0},0,0,"    N/A",null,null,null,null,null,{"$f":"M63*N63","v":0},{"$f":"M63*O63","v":0},{"$f":"M63*P63","v":0},"    N/A"]
[163,"Terminating CCL Non-Prem.",null,{"$f":"SUM(M64)","v":0},0,0,0,0,0,0,"    N/A",null,null,null,null,null,{"$f":"M64*N64","v":0},{"$f":"M64*O64","v":0},{"$f":"M64*P64","v":0},"    N/A"]
[165,"Originating CCL Prem.",null,{"$f":"SUM(M65)","v":0},0,0,0,0,0,0,"    N/A",null,null,null,null,null,{"$f":"M65*N65","v":0},{"$f":"M65*O65","v":0},{"$f":"M65*P65","v":0},"    N/A"]
[167,"Originating CCL Non-Prem.",null,{"$f":"SUM(M66)","v":0},0,0,0,0,0,0,"    N/A",null,null,null,null,null,{"$f":"M66*N66","v":0},{"$f":"M66*O66","v":0},{"$f":"M66*P66","v":0},"    N/A"]
[]
["",""]
[180,"Other Common Line",null,"          N/A","          N/A","          N/A","          N/A",{"$f":"SUM(Q69)","v":0},{"$f":"SUM(R69,AA69,AJ69,AS69,BB69,BK69,BT69,CC69,CL69,CU69,DD69,DM69,DV69,EE69,EN69,EW69,FF69,FO69)","v":0},0,"    N/A",null,"          N/A","          N/A","          N/A","          N/A",null,null,null,"    N/A"]
[185,"USAC Receipts",null,{"$f":"SUM(M70)","v":0},{"$f":"IF($D70=0,0,H70/$D70)","v":0},{"$f":"IF($D70=0,0,I70/$D70)","v":0},{"$f":"IF($D70=0,0,J70/$D70)","v":0},{"$f":"SUM(Q70)","v":0},0,0,"    N/A",null,null,null,null,null,{"$f":"M70*N70","v":0},{"$f":"M70*O70","v":0},{"$f":"M70*P70","v":0},"    N/A"]
["","Per Minute Revenues",null,null,null,null,null,0,0,0,"    N/A",null,null,null,null,null,{"$f":"SUM(Q63:Q66)","v":0},{"$f":"SUM(R63:R66)","v":0},{"$f":"SUM(S63:S66)","v":0},"    N/A"]
[190,"Total Basket",null,"          N/A","          N/A","          N/A","          N/A",0,0,0,"    N/A",null,"          N/A","          N/A","          N/A","          N/A",{"$f":"SUM(Q30:Q54)+Q59+Q60+SUM(Q62:Q66)+Q69+Q70","v":0},{"$f":"SUM(R30:R54)+R59+R60+SUM(R62:R66)+R69+R70","v":0},{"$f":"SUM(S30:S54)+S59+S60+SUM(S62:S66)+S69+S70","v":0},"    N/A"]
["",""]
["CL ExogCosts (non-ATS Trgtng): enter $ by juris or \"Total\"",null,null,"Total"]

{"sheet":"CAPs","index":2,"n_rows":407,"n_cols":18,"rows_kept":407,"cut":false,"hidden":false,"merged":[]}
[]
[]
["The Totals for all COSAs are in columns D through K"]
["in rows 15 through 374."]
[]
["COSAs with Jurisdictionally Separate SLCs, PICCs,"]
["and/or CCL are in rows 15 through 374 beginning in"]
["column M."]
[]
["The ANALYZER for each COSA is in lines 375 through 415."]
[]
[]
[null,null,"Jurisdiction Number:",null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,"Juris name"]
["CAP-1J",null,null,"Total "]
[{"$f":"\"Filing Date:                \"&DATE","v":"Filing Date:                06/16/2021"}]
[{"$f":"\"Filing Entity:               \"&COSA","v":"Filing Entity:               "}]
[{"$f":"\"Transmittal Number:   \"&TRANSMITTAL","v":"Transmittal Number:   "}]
[{"$f":"NAME","v":0}]
["Page 1 of 2",null,"","Price Cap Tariff Review Plan",null,null,null,null,null,null,null,null,"Price Cap Tariff Review Plan"]
[null,null,"","Calculation of EUCL Limits, PICC Rate and CCL Rates",null,null,null,null,null,null,null,null,"Calculation of EUCL Limits, PICC Rate and CCL Rates"]
[]
[null,null,null,"Total","No Zone / Zone A","Zone B","Zone C","Zone D","Other Zone",null,null,null,"Total Jurisdiction","No Zone / Zone A","Zone B","Zone C","Zone D","Other Zone"]
[null,null,"Source","(a)","(b)","(c)","(d)","(e)","(f)",null,null,null,"(a)","(b)","(c)","(d)","(e)","(f)"]
[null,"EUCL Demand Inputs",""]
[100,"Total Primary Res & SLB & LifeLine Lines","RTE1: b:r102a;c:r112a;d:r122a;e:r132a;f:r142a",{"$f":"SUM(M26)","v":0},0,0,0,0,0,null,null,null,{"$f":"SUM(N26:R26)","v":0},{"$f":"RTEs!M30","v":0},{"$f":"RTEs!M37","v":0},{"$f":"RTEs!M42","v":0},{"$f":"RTEs!M47","v":0},{"$f":"RTEs!M52","v":0}]
[110,"Total NonPrim Res & BRI ISDN Lines","RTE1: b:r104a;c:r114a;d:r124a;e:r134a;f:r144a",0,0,0,0,0,0,null,null,null,{"$f":"SUM(N27:R27)","v":0},{"$f":"RTEs!M31","v":0},{"$f":"RTEs!M38","v":0},{"$f":"RTEs!M43","v":0},{"$f":"RTEs!M48","v":0},{"$f":"RTEs!M53","v":0}]
[120,"Total MLB&PRI ISDN (include PRI * 5, & Include Centrex)","RTE1: b:r106a;c:r116a;d:r126a;e:r136a;f:r146a",0,0,0,0,0,0,null,null,null,{"$f":"SUM(N28:R28)","v":0},{"$f":"RTEs!M32","v":0},{"$f":"RTEs!M39","v":0},{"$f":"RTEs!M44","v":0},{"$f":"RTEs!M49","v":0},{"$f":"RTEs!M54","v":0}]
[130,"Total Local Exchange Lines","r100+r110+r120",0,0,0,0,0,0,null,null,null,{"$f":"SUM(N29:R29)","v":0},{"$f":"SUM(N26:N28)","v":0},{"$f":"SUM(O26:O28)","v":0},{"$f":"SUM(P26:P28)","v":0},{"$f":"SUM(Q26:Q28)","v":0},{"$f":"SUM(R26:R28)","v":0}]
[null,null,""]
[null,"PICC Demand Inputs",""]
[200,"Total MLB&PRI ISDN (include PRI * 5, & exclude Centrex)","RTE1r155a",{"$f":"SUM(M32)","v":0},null,null,null,null,null,null,null,null,{"$f":"RTEs!M59","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[210,"Total Business Centrex Lines in groups with 9 or more lines","Input",{"$f":"SUM(M33)","v":0},null,null,null,null,null,null,null,null,null,"      N/A","      N/A","      N/A","      N/A","      N/A"]
[220,"Total Business Groups with less than 9 lines in the group","Input",{"$f":"SUM(M34)","v":0},null,null,null,null,null,null,null,null,null,"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,""]
[null,null,""]
[null,"MOU Demand Inputs",""]
[300,"Total Terminating Premium MOU","RTE1r161a",{"$f":"SUM(M38)","v":0},null,null,null,null,null,null,null,null,{"$f":"RTEs!M63","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[310,"Total Terminating Non-Premium MOU","RTE1r163a",0,null,null,null,null,null,null,null,null,{"$f":"RTEs!M64","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[320,"Total Terminating Chargeable MOU","r300+.45*r310",0,null,null,null,null,null,null,null,null,{"$f":"M38+0.45*M39","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[330,"Total Originating Premium MOU","RTE1r165a",0,null,null,null,null,null,null,null,null,{"$f":"RTEs!M65","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[340,"Total Originating Non-Premium MOU","RTE1r167a",0,null,null,null,null,null,null,null,null,{"$f":"RTEs!M66","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[350,"Total Originating Chargeable MOU","r330+.45*r340",0,null,null,null,null,null,null,null,null,{"$f":"M41+0.45*M42","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,""]
[null,"SLC/PICC Caps",""]
[400,"PR, Lifeline & SLB EU Cap","Input",6.5,null,null,null,null,null,null,null,null,null,"      N/A","      N/A","      N/A","      N/A","      N/A"]
[410,"NonPrimary Res & BRI EU Cap","Input",7,null,null,null,null,null,null,null,null,null,"      N/A","      N/A","      N/A","      N/A","      N/A"]
[420,"MLB, PRI & Centrex EU Cap","Input",9.1999999999999993,null,null,null,null,null,null,null,null,null,"      N/A","      N/A","      N/A","      N/A","      N/A"]
[430,"MLB PICC Rate as of Dec. 29, 2011","Input",0,null,null,null,null,null,null,null,null,null,"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,""]
[null,"CMT Revenue",""]
[440,"Current MaxCMT Rev per Line (from previous filing)","Input (r460 from prev filing)",{"$f":"IF(D29=0,0,(SUMPRODUCT(M52,M29))/D29)","v":0},null,null,null,null,null,null,null,null,null,"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,""]
[null,null,""]
[null,null,""]
[450,"Total CMT Exogenous Cost Factor ((R+deltaZ)/R)","((EXG1r160s/r130a)/r440a)+1",{"$f":"IF(OR(D29=0,D52=0),0,IF(RTEs!D74=\"Total\",A!$AJ$56,(((RTEs!D74)/D29)/D52)+1))","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(OR(M29=0,M52=0),0,IF(RTEs!M74=\"Total\",A!$AJ56,(((RTEs!M74)/M29)/M52)+1))","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,""]
[460,"Proposed Maximum CMT Revenue Per Line","r440*r450",{"$f":"D52*D56","v":0},null,null,null,null,null,null,null,null,{"$f":"M52*M56","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,""]
["CAP-1J",null,null,"Total ",null,null,null,null,null,null,null,null,{"$f":"M15","v":0}]
[{"$f":"\"Filing Date:                \"&DATE","v":"Filing Date:                06/16/2021"}]
[{"$f":"\"Filing Entity:               \"&COSA","v":"Filing Entity:               "}]
[{"$f":"\"Transmittal Number:   \"&TRANSMITTAL","v":"Transmittal Number:   "},null,null,"",null,null,null,null,null,null,null,null,""]
[{"$f":"NAME","v":0}]
["Page 2 of 2",null,null,"Price Cap Tariff Review Plan",null,null,null,null,null,null,null,null,"Price Cap Tariff Review Plan"]
[null,null,null,"Calculation of EUCL Limits, PICC Rate and CCL Rates",null,null,null,null,null,null,null,null,"Calculation of EUCL Limits, PICC Rate and CCL Rates"]
[]
[null,null,null,"Total","No Zone / Zone A","Zone B","Zone C","Zone D","Other Zone",null,null,null,"Total Jurisdiction","No Zone / Zone A","Zone B","Zone C","Zone D","Other Zone"]
["",null,"Source","(a)","(b)","(c)","(d)","(e)","(f)",null,null,null,"(a)","(b)","(c)","(d)","(e)","(f)"]
[null,"CMT Revenue Vs EU Revenue at Max. Allowable Rates"]
[600,"Proposed Maximum CMT Revenue","r460 * r130",{"$f":"SUM(M86)","v":0},null,null,null,null,null,null,null,null,{"$f":"M58*M29","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[610,"Maximum Allowable PR, Lifeline & SLB EU Revenue","r400 * r100",0,null,null,null,null,null,null,null,null,{"$f":"M46*M26","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[620,"Maximum Allowable NonPrimary Res & BRI EU Revenue","r410 * r110",0,null,null,null,null,null,null,null,null,{"$f":"M47*M27","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[630,"Maximum Allowable MLB, PRI & Centrex EU Revenue","r420 * r120",0,null,null,null,null,null,null,null,null,{"$f":"M48*M28","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[640,"Total Maximum Allowable EU Revenue","r610 + r620 + r630",0,null,null,null,null,null,null,null,null,{"$f":"SUM(M87:M89)","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[650,"Remaining CMT Revenue/(CMT Over-recovery)","r600 - r640",0,null,null,null,null,null,null,null,null,{"$f":"M86-M90","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[652,"Maximum Allowable PICC Revenue","r430*( r200+r210/9+r220 )",0,null,null,null,null,null,null,null,null,{"$f":"M49*(M32+M33/9+M34)","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[660,"Total USAC Receipts (at t)","RTE1r185f",0,null,null,null,null,null,null,null,null,{"$f":"RTEs!S70","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[680,"Remaining Recoverable Revenue/(Total over-recovery)","r650-r660",{"$f":"ROUND(SUMIF(M99,\">0\",M99),0)","v":0},null,null,null,null,null,null,null,null,{"$f":"ROUND(+M91-M93,2)","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,""]
[]
[null,"Calculation of PICC for MultiLine Business, PRI ISDN, & Centrex Lines"]
[800,"MLB, PRI & Centrex PICC Rate (Dec. 29, 2011)","r430",{"$f":"D49","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(A!$G$7=\"n\",\"Agg.Rate\",+M49)","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[810,"MLB, PRI & Centrex PICC Revenue Target","if r680>0 then r680 else 0",{"$f":"IF(A!$G$7=\"n\",D99,IF(A!$G$7=\"y\",SUM(M104),\"\"))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(A!$G$7=\"n\",\"Agg.Rate\",IF(M99>0,M99,0))","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[820,"MLB, PRI & Centrex PICC Target Rate","r810 / (r200 + r210/9 + r220)",{"$f":"IF((D32+D33+D34)<>0,+D104/(D32+D33/9+D34),0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(A!$G$7=\"n\",\"Agg.Rate\",IF((M32+M33+M34)<>0,+M104/(M32+M33/9+M34),0))","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[830,"Maximum Average MLB, PRI & Centrex PICC Rate","Min(r800,r820)",{"$f":"MIN(D103,D105)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(A!$G$7=\"n\",\"Agg.Rate\",MIN(M103,M105))","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[840,"Maximum MLB & PRI PICC Revenue","r830 * r200",{"$f":"SUM(M107)","v":0},null,null,{"$f":"IF(AND(A!$G$10=\"n\",A!$G$7=\"n\"),D106*D32,D107)","v":0},null,null,null,null,null,{"$f":"IF(A!$G$7=\"n\",\"Agg.Rate\",+M106*M32)","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[850,"Maximum Centrex PICC Revenue","r830 * (r210/9 + r220)",{"$f":"SUM(M108)","v":0},null,null,{"$f":"IF(AND(A!$G$10=\"n\",A!$G$7=\"n\"),D106*(D33/9+D34),D108)","v":0},null,null,null,null,null,{"$f":"IF(A!$G$7=\"n\",\"Agg.Rate\",+M106*(M33/9+M34))","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[860,"Total Maximum PICC Revenue (Proposed)","r840 + r850",{"$f":"D107+D108","v":0},null,null,{"$f":"IF(A!$G$7=\"n\",D107+D108,D109)","v":0},null,null,null,null,null,{"$f":"IF(A!$G$7=\"n\",\"Agg.Rate\",+M107+M108)","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,""]
[null,"Calculation of CCL Rates and Revenue",""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[940,"Prem. Originating MOU Rate as of Dec. 29, 2011","Input",{"$f":"IF(D41=0,0,SUMPRODUCT(M116,M41)/D41)","v":0},null,null,null,null,null,null,null,null,null,"      N/A","      N/A","      N/A","      N/A","      N/A"]
[945,"Prem. Terminating MOU Rate as of Dec. 29, 2011","Input",{"$f":"IF(D38=0,0,SUMPRODUCT(M117,M38)/D38)","v":0},null,null,null,null,null,null,null,null,null,"      N/A","      N/A","      N/A","      N/A","      N/A"]
[950,"Maximum CCL Revenue","r810 - r860",{"$f":"SUMIF(M118,\">=0\",M118)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(OR(A!$G$7=\"n\",A!$G$8=\"n\"),\"Agg.Rate\",+M104-M109)","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[960,"Maximum CCL Originating Rate","Min(r940, r950/r350)",{"$f":"IF(D43=0,0,MIN(D116,D118/D43))","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(OR(A!$G$7=\"n\",A!$G$8=\"n\"),\"Agg.Rate\",MIN(M116,IF(M43=0,0,M118/M43)))","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[970,"Maximum CCL Terminating Rate","Min(r945,(r950 - (r350*r960))/r320)",{"$f":"MIN(D117,IF(D40=0,0,(D118-(D43*D119))/D40))","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(OR(A!$G$7=\"n\",A!$G$8=\"n\"),\"Agg.Rate\",MIN(M117,IF(M40=0,0,(M118-(M43*M119))/M40)))","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,""]
[980,"Maximum Originating CCL Revenue","r960 * r350",{"$f":"SUMIF(M122,\">=0\",M122)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(OR(A!$G$7=\"n\",A!$G$8=\"n\"),\"Agg.Rate\",+M119*M43)","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[990,"Maximum Terminating CCL Revenue","r970 * r320",{"$f":"SUMIF(M123,\">=0\",M123)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(OR(A!$G$7=\"n\",A!$G$8=\"n\"),\"Agg.Rate\",+M120*M40)","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[995,"Total Maximum CCL Revenue","r980 + r990",{"$f":"SUMIF(M124,\">=0\",M124)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(OR(A!$G$7=\"n\",A!$G$8=\"n\"),\"Agg.Rate\",+M122+M123)","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[]
[null,"EU Pricing Decision",""]
[1100,"Is Deaveraging of EUCL Rates Possible?","if r680>0,\"No\",\"Yes\"",null,null,null,null,null,null,null,null,null,{"$f":"IF(M99>0,\"NO\",\"YES\")","v":"YES"},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[1110,"Do you have Pooling Revenues?","from A sheet, CAP1r1110",null,null,null,null,null,null,null,null,null,{"$f":"A!$AJ$128","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[1120,"Are you going to deaverage EUCL Rates by zone?","Input (If r1100 = \"No\" you must input \"No\")",null,null,null,null,null,null,null,null,null,null,"      N/A","      N/A","      N/A","      N/A","      N/A"]
[1130,"CAP Form containing final EUCL Rates","if r680>0,CAP1; if r1120=No,CAP2; elseCAP3",null,null,null,null,null,null,null,null,null,{"$f":"IF(M86=0,\"\",IF(A!$G$7=\"n\",IF(M99>0,\"CAP1\",\"CAP2\"),IF(M99>0,\"CAP1\",IF(M129=\"no\",\"CAP2\",\"CAP3\"))))","v":""},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,""]
[1140,"Max. Allowable PR, Lifeline & SLB EU Revenue","if r1130=CAP1,r610;else1130",{"$f":"SUM(M132)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(OR(A!$G$6=\"n\",M86=0),\"\",IF(A!$AJ$130=\"cap1\",IF(M130=\"cap1\",M87,IF(M130=\"cap2\",M162,M247)),IF(AND((OR(A!$AJ$130=\"jurisspm\",A!$AJ$130=\"jurissp\",A!$AJ$130=\"juriss\",A!$AJ$130=\"jurismix\")),M130=\"cap1\"),M87,M130)))","v":""},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[1150,"Max. Allowable NonPrimary Res & BRI EU Revenue","if r1130=CAP1,r620;else1130",{"$f":"SUM(M133)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(OR(A!$G$6=\"n\",M86=0),\"\",IF(A!$AJ$130=\"cap1\",IF(M130=\"cap1\",M88,IF(M130=\"cap2\",M163,M248)),IF(AND((OR(A!$AJ$130=\"jurisspm\",A!$AJ$130=\"jurissp\",A!$AJ$130=\"juriss\",A!$AJ$130=\"jurismix\")),M130=\"cap1\"),M88,M130)))","v":""},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[1160,"Max. Allowable MLB, PRI & Centrex EU Revenue","if r1130=CAP1,r630;else1130",{"$f":"SUM(M134)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(OR(A!$G$6=\"n\",M86=0),\"\",IF(A!$AJ$130=\"cap1\",IF(M130=\"cap1\",M89,IF(M130=\"cap2\",M164,M249)),IF(AND((OR(A!$AJ$130=\"jurisspm\",A!$AJ$130=\"jurissp\",A!$AJ$130=\"juriss\",A!$AJ$130=\"jurismix\")),M130=\"cap1\"),M89,M130)))","v":""},"      N/A","      N/A","      N/A","      N/A","      N/A"]
["CAP-2J",null,null,"Total",null,null,null,null,null,null,null,null,{"$f":"M15","v":0}]
[{"$f":"\"Filing Date:                \"&DATE","v":"Filing Date:                06/16/2021"}]
[{"$f":"\"Filing Entity:               \"&COSA","v":"Filing Entity:               "}]
[{"$f":"\"Transmittal Number:   \"&TRANSMITTAL","v":"Transmittal Number:   "},null,null,"",null,null,null,null,null,null,null,null,""]
[{"$f":"NAME","v":0}]
["Page 1 of 1",null,null,"Price Cap Tariff Review Plan",null,null,null,null,null,null,null,null,"Price Cap Tariff Review Plan"]
[null,null,null,"Manual Input of EUCL Rates - No PICC or MOU Rates",null,null,null,null,null,null,null,null,"Manual Input of EUCL Rates - No PICC or MOU Rates"]
[]
[null,null,null,"Total",null,null,null,null,null,null,null,null,"Total Jurisdiction"]
["",null,"Source","(a)",null,null,null,null,null,null,null,null,"(a)"]
[null,"Calculation of Maximum Recoverable Revenue","For all rows: if CAP1r1130=\"CAP2\", use sourcing; if Juris Pricing, enter Sum of CAP2-priced Juris where indicated; else CAP1r1130."]
[100,"Maximum CMT Revenue","CAP1r600",{"$f":"SUM(M146)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"CAP2\",M86,M130)","v":""}]
[110,"Total USAC Receipts (at t)","CAP1r660",{"$f":"SUM(M147)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"CAP2\",M93,M130)","v":""}]
[]
[130,"Maximum Recoverable Revenue","r100 - r110",{"$f":"SUM(M149)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"CAP2\",M146-M147,M130)","v":""}]
[null,null,""]
[null,"Maximum Allowable EU Rates",""]
[200,"Max. Allowable Primary Res, Lifeline, & SLB EU Rate","CAP1r400 if CAP1r1130=CAP2",null,null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"CAP2\",M46,M130)","v":""}]
[210,"Max. Allowable NonPrimary Res & BRI ISDN EU Rate","CAP1r410 if CAP1r1130=CAP2",null,null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"CAP2\",M47,M130)","v":""}]
[220,"Max. Allowable MLB, PRI ISDN, & Centrex EU Rate","CAP1r420 if CAP1r1130=CAP2",null,null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"CAP2\",M48,M130)","v":""}]
[null,null,""]
[null,"Final EU Rates (Manually Input)",""]
[400,"Final Primary Res, Lifeline, & SLB EU Rate","Input ",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ROUND(N(M157)-N(M152),6)>0,\"     Error:  Exceeded maximum allowable rate\",\"     ok\")","v":"     ok"}]
[410,"Final NonPrim Res & BRI ISDN EU Rate","Input ",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ROUND(N(M158)-N(M153),6)>0,\"     Error:  Exceeded maximum allowable rate\",IF(ROUND(N(M158)-N(M157),6)<0,\"     Error:  NPR rate less than PR rate\",\"     ok\"))","v":"     ok"}]
[420,"Final MLB, PRI ISDN, & Centrex EU Rate","Input ",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ROUND(N(M159)-N(M154),6)>0,\"     Error:  Exceeded maximum allowable rate\",IF(ROUND(N(M159)-N(M158),6)<0,\"     Error:  MLB rate less than NPR rate\",IF(ROUND(N(M159)-N(M157),6)<0,\"     Error:  MLB rate less than PR rate\",\"     ok\")))","v":"     ok"}]
[null,null,""]
[null,"Final EU Revenue",""]
[500,"Final Total Primary Res & SLB & LifeLine EU Revenue","r400 * CAP1r100",{"$f":"SUM(M162)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"CAP2\",M157*M26,M130)","v":""}]
[510,"Final Total NonPrim Res & BRI ISDN EU Revenue","r410 * CAP1r110",{"$f":"SUM(M163)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"CAP2\",M158*M27,M130)","v":""}]
[520,"Final Total MLB, PRI ISDN, & Centrex EU Revenue","r420 * CAP1r120",{"$f":"SUM(M164)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"CAP2\",M159*M28,M130)","v":""}]
[530,"Final Total End User Revenue","r500 + r510 + r520",{"$f":"SUM(M165)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"CAP2\",M162+M163+M164,M130)","v":""}]
[null,null,""]
[600,"Actual vs. Allowable Revenue:  Over-recovery","r530 - r130",{"$f":"SUM(M167)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"CAP2\",ROUND(M165-M149,0),M130)","v":""},{"$f":"IF(M130=\"CAP2\",IF(M167>0,\"     Error:  Over-recovery. You must change EUCL rates.\",IF(M167<0,\"     You have under-recovered by this amount.\",\"     ok\")),\"\")","v":""}]
[null,"          or (Under-recovery)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["CAP-3J",null,null,"Total ",null,null,null,null,null,null,null,null,{"$f":"M15","v":0}]
[{"$f":"\"Filing Date:                \"&DATE","v":"Filing Date:                06/16/2021"},null,""]
[{"$f":"\"Filing Entity:               \"&COSA","v":"Filing Entity:               "},null,""]
[{"$f":"\"Transmittal Number:   \"&TRANSMITTAL","v":"Transmittal Number:   "},null,"","",null,null,null,null,null,null,null,null,""]
[{"$f":"NAME","v":0}]
["Page 1 of 1",null,null,"Price Cap Tariff Review Plan",null,null,null,null,null,null,null,null,"Price Cap Tariff Review Plan"]
[null,null,null,"Calculation of Minimum & Maximum EU Rates",null,null,null,null,null,null,null,null,"Calculation of Minimum & Maximum EU Rates"]
[null,null,""]
[null,null,"","Total","No Zone / Zone A","Zone B","Zone C","Zone D","Other Zone",null,null,null,"Total Jurisdiction","No Zone / Zone A","Zone B","Zone C","Zone D","Other Zone"]
[null,null,"Source","(a)","(b)","(c)","(d)","(e)","(f)",null,null,null,"(a)","(b)","(c)","(d)","(e)","(f)"]
[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."]
[100,"Maximum CMT Revenue","CAP1r600",{"$f":"SUM(M206)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"CAP3\",M86,M130)","v":""},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[110,"Total USAC Receipts","CAP1r660",{"$f":"SUM(M207)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"CAP3\",M93,M130)","v":""},"      N/A","      N/A","      N/A","      N/A","      N/A"]
["","",""]
[130,"Maximum Recoverable Revenue","r100 - r110",{"$f":"SUM(M209)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"CAP3\",M206-M207,M130)","v":""},"      N/A","      N/A","      N/A","      N/A","      N/A"]
["",""]
["","Inputs for Calculation of Minimum and Maximum Allowable Deaveraged Rates"]
[200,"Total Local Exchange Lines","CAP1r130",{"$f":"SUM(M212)","v":0},0,0,0,0,0,null,null,null,{"$f":"IF(M130=\"CAP3\",SUM(N212:R212),M130)","v":""},{"$f":"IF(M130=\"CAP3\",N29,M130)","v":""},{"$f":"IF(M130=\"CAP3\",O29,M130)","v":""},{"$f":"IF(M130=\"CAP3\",P29,M130)","v":""},{"$f":"IF(M130=\"CAP3\",Q29,M130)","v":""},{"$f":"IF(M130=\"CAP3\",R29,M130)","v":""}]
[210,"Unbundled Loop & Line Port Rate (State Approved)","Input if CAP1r1130=CAP3; else, CAP1r1130",null,null,null,null,null,null,null,null,null,"      N/A",{"$f":"M130","v":""},{"$f":"M130","v":""},{"$f":"M130","v":""},{"$f":"M130","v":""},{"$f":"M130","v":""}]
[220,"Interstate UNE Rate","r210*.25 if CAP1r1130=CAP3",null,null,null,null,null,null,null,null,null,"      N/A",{"$f":"IF(M130=\"CAP3\",N213*0.25,M130)","v":""},{"$f":"IF(M130=\"CAP3\",O213*0.25,M130)","v":""},{"$f":"IF(M130=\"CAP3\",P213*0.25,M130)","v":""},{"$f":"IF(M130=\"CAP3\",Q213*0.25,M130)","v":""},{"$f":"IF(M130=\"CAP3\",R213*0.25,M130)","v":""}]
[230,"Interstate UNE Revenues","r200 * r220",{"$f":"SUM(M215)","v":0},0,0,0,0,0,null,null,null,{"$f":"IF(OR(M130=\"CAP3\",M130=\"Juris\"),SUM(N215:R215),M130)","v":""},{"$f":"IF(M130=\"CAP3\",N212*N214,M130)","v":""},{"$f":"IF(M130=\"CAP3\",O212*O214,M130)","v":""},{"$f":"IF(M130=\"CAP3\",P212*P214,M130)","v":""},{"$f":"IF(M130=\"CAP3\",Q212*Q214,M130)","v":""},{"$f":"IF(M130=\"CAP3\",R212*R214,M130)","v":""}]
[240,"Maximum CMT Revenue (using Max CMT Rev/Line)","CAP1r600",{"$f":"SUM(M216)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"CAP3\",M86,M130)","v":""},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[250,"Average Price Cap CMT Rev to be Recovered per Line","CAP1r460 ifCAP1r1130=CAP3",null,null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"CAP3\",M58,M130)","v":""},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[260,"Price Cap CMT Revenue by Zone","r200 * r250",{"$f":"SUM(M218)","v":0},0,0,0,0,0,null,null,null,{"$f":"IF(M130=\"CAP3\",SUM(N218:R218),M130)","v":""},{"$f":"IF(M130=\"CAP3\",N212*M217,M130)","v":""},{"$f":"IF(M130=\"CAP3\",O212*M217,M130)","v":""},{"$f":"IF(M130=\"CAP3\",P212*M217,M130)","v":""},{"$f":"IF(M130=\"CAP3\",Q212*M217,M130)","v":""},{"$f":"IF(M130=\"CAP3\",R212*M217,M130)","v":""}]
[270,"Uniform Rate Adjustment Factor","(r260 - r230 ) / r 200",null,null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"CAP3\",IF(M212=0,0,(M218-M215)/M212),M130)","v":""},"      N/A","      N/A","      N/A","      N/A","      N/A"]
["","",""]
["","Minimum Deaveraged EU Charge Development",""]
[300,"Zone Average Revenue Per Line","r270a+r220 ifCAP1r1130=CAP3",null,null,null,null,null,null,null,null,null,"      N/A",{"$f":"IF(M130=\"CAP3\",IF(N214=0,\"None\",M219+N214),M130)","v":""},{"$f":"IF(M130=\"CAP3\",IF(O214=0,\"None\",M219+O214),M130)","v":""},{"$f":"IF(M130=\"CAP3\",IF(P214=0,\"None\",M219+P214),M130)","v":""},{"$f":"IF(M130=\"CAP3\",IF(Q214=0,\"None\",M219+Q214),M130)","v":""},{"$f":"IF(M130=\"CAP3\",IF(R214=0,\"None\",M219+R214),M130)","v":""}]
[310,"Preliminary Minimum Deaveraged EU Charge","Minimum value in r300",null,null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"CAP3\",IF(N214=0,0,IF(O214=0,N214,IF(P214=0,MIN(N214:O214),IF(Q214=0,MIN(N214:P214),IF(R214=0,MIN(N214:Q214),MIN(N214:R214))))))+M219,M130)","v":""},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[320,"Explicit Subsidy Support from USAC (at t)","CAP1r660",{"$f":"SUM(M224)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"CAP3\",M93,M130)","v":""},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[330,"Study Area above CAP Benchmark Revenues","If r300>9.2,(r300-7)*CAP1r(100+110)+(r300-9.2)*",{"$f":"SUM(M225)","v":0},{"$f":"SUM(N225)","v":0},{"$f":"SUM(O225)","v":0},{"$f":"SUM(P225)","v":0},{"$f":"SUM(Q225)","v":0},{"$f":"SUM(R225)","v":0},null,null,null,{"$f":"IF(M130=\"CAP3\",SUM(N225:R225),M130)","v":""},{"$f":"IF(M130=\"CAP3\",IF((N222>9.2),(N222-7)*(N26+N27)+(N222-9.2)*N28,IF(N222>7,(N222-7)*(N26+N27),0)),M130)","v":""},{"$f":"IF(M130=\"CAP3\",IF((O222>9.2),(O222-7)*(O26+O27)+(O222-9.2)*O28,IF(O222>7,(O222-7)*(O26+O27),0)),M130)","v":""},{"$f":"IF(M130=\"CAP3\",IF((P222>9.2),(P222-7)*(P26+P27)+(P222-9.2)*P28,IF(P222>7,(P222-7)*(P26+P27),0)),M130)","v":""},{"$f":"IF(M130=\"CAP3\",IF((Q222>9.2),(Q222-7)*(Q26+Q27)+(Q222-9.2)*Q28,IF(Q222>7,(Q222-7)*(Q26+Q27),0)),M130)","v":""},{"$f":"IF(M130=\"CAP3\",IF((R222>9.2),(R222-7)*(R26+R27)+(R222-9.2)*R28,IF(R222>7,(R222-7)*(R26+R27),0)),M130)","v":""}]
[null,"","   CAP1r120; if 9.2>=r300>7,(r300-7)*CAP1r(100+110);"]
[null,"","   else 0"]
[340,"Over Cap Revenues","Max(0, (r330 - r320))",{"$f":"SUM(M228)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"CAP3\",MAX(0,M225-M224),M130)","v":""},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[350,"Interim Calculations only (do not represent Zone results)","Interim calcs only (used in r360, r375, r385)",null,null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"CAP3\",IF(OR(O222=\"None\",N(N229)<=N(O222)),N229,IF(OR(P222=\"None\",N(O229)<=N(P222)),O229,IF(OR(Q222=\"None\",N(P229)<=N(Q222)),P229,IF(OR(R222=\"None\",N(Q229)<=N(R222)),Q229,R229)))),M130)","v":""},{"$f":"IF(M130=\"CAP3\",IF(N222=\"None\",\"None\",IF(N212=0,0,M228/N212)+N222),M130)","v":""},{"$f":"IF(M130=\"CAP3\",IF(O222=\"None\",\"None\",IF(N212+O212=0,0,MAX(0,(M228-(O222-N222)*N212))/(N212+O212))+O222),M130)","v":""},{"$f":"IF(M130=\"CAP3\",IF(P222=\"None\",\"None\",IF(N212+O212+P212=0,0,MAX(0,(M228-(P222-N222)*N212-(P222-O222)*O212))/(N212+O212+P212))+P222),M130)","v":""},{"$f":"IF(M130=\"CAP3\",IF(Q222=\"None\",\"None\",IF(N212+O212+P212+Q212=0,0,MAX(0,(M228-(Q222-N222)*N212-(Q222-O222)*O212-(Q222-P222)*P212))/(N212+O212+P212+Q212))+Q222),M130)","v":""},{"$f":"IF(M130=\"CAP3\",IF(R222=\"None\",\"None\",IF(N212+O212+P212+Q212+R212=0,0,MAX(0,(M228-(R222-N222)*N212-(R222-O222)*O212-(R222-P222)*P212-(R222-Q222)*Q212))/(N212+O212+P212+Q212+R212))+R222),M130)","v":""}]
["","",""]
[360,"Minimum Deavgd PR, Lifeline, SLB EU Rate","Min(r350a,CAP1r400)if CAP1r1130=CAP3",null,null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"CAP3\",MIN(M229,M46),M130)","v":""},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[370,"Maximum Deavgd PR, Lifeline, SLB EU Rate","CAP1r400 if CAP1r1130=CAP3",null,null,null,null,null,null,null,null,null,{"$f":"M130","v":""},"      N/A","      N/A","      N/A","      N/A","      N/A"]
["","",""]
[375,"Minimum Deavgd NPR & BRI ISDN EU Rate","Min(r350a,CAP1r410)if CAP1r1130=CAP3",null,null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"CAP3\",MIN(M229,M47),M130)","v":""},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[380,"Maximum Deavgd NPR & BRI ISDN EU Rate","CAP1r410 if CAP1r1130=CAP3",null,null,null,null,null,null,null,null,null,{"$f":"M130","v":""},"      N/A","      N/A","      N/A","      N/A","      N/A"]
["","",""]
[385,"Minimum Deavgd MLB, PRI, Centrex EU Rate","Min(r350a,CAP1r420)if CAP1r1130=CAP3",null,null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"CAP3\",MIN(M229,M48),M130)","v":""},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[390,"Maximum Deavgd MLB, PRI, Centrex EU Rate","CAP1r420 if CAP1r1130=CAP3",null,null,null,null,null,null,null,null,null,{"$f":"M130","v":""},"      N/A","      N/A","      N/A","      N/A","      N/A"]
["","",""]
[null,null,""]
["","Final EU Rates (Manually Input)",""]
[400,"Final Primary Res, Lifeline, & SLB EU Rate","Input; but for col.c thru f: if r100=\"N/A\", 0",null,null,null,null,null,null,null,null,null,"      N/A",{"$f":"M130","v":""},{"$f":"M130","v":""},{"$f":"M130","v":""},{"$f":"M130","v":""},{"$f":"M130","v":""}]
[410,"Final NonPrim Res & BRI ISDN EU Rate","Input; but for col.c thru f: if r100=\"N/A\", 0",null,null,null,null,null,null,null,null,null,"      N/A",{"$f":"M130","v":""},{"$f":"M130","v":""},{"$f":"M130","v":""},{"$f":"M130","v":""},{"$f":"M130","v":""}]
[420,"Final MLB, PRI ISDN, & Centrex EU Rate","Input; but for col.c thru f: if r100=\"N/A\", 0",null,null,null,null,null,null,null,null,null,"      N/A",{"$f":"M130","v":""},{"$f":"M130","v":""},{"$f":"M130","v":""},{"$f":"M130","v":""},{"$f":"M130","v":""}]
["","",""]
["","Final EU Revenue",""]
[500,"Final Total Primary Res & SLB & LifeLine EU Revenue","r400 * CAP1r100",{"$f":"SUM(M247)","v":0},0,0,0,0,0,null,null,null,{"$f":"IF(M130=\"CAP3\",SUM(N247:R247),M130)","v":""},{"$f":"IF(M130=\"CAP3\",N242*N26,M130)","v":""},{"$f":"IF(M130=\"CAP3\",O242*O26,M130)","v":""},{"$f":"IF(M130=\"CAP3\",P242*P26,M130)","v":""},{"$f":"IF(M130=\"CAP3\",Q242*Q26,M130)","v":""},{"$f":"IF(M130=\"CAP3\",R242*R26,M130)","v":""}]
[510,"Final Total NonPrim Res & BRI ISDN EU Revenue","r410 * CAP1r110",0,0,0,0,0,0,null,null,null,{"$f":"IF(M130=\"CAP3\",SUM(N248:R248),M130)","v":""},{"$f":"IF(M130=\"CAP3\",N243*N27,M130)","v":""},{"$f":"IF(M130=\"CAP3\",O243*O27,M130)","v":""},{"$f":"IF(M130=\"CAP3\",P243*P27,M130)","v":""},{"$f":"IF(M130=\"CAP3\",Q243*Q27,M130)","v":""},{"$f":"IF(M130=\"CAP3\",R243*R27,M130)","v":""}]
[520,"Final Total MLB, PRI ISDN, & Centrex EU Revenue","r420 * CAP1r120",0,0,0,0,0,0,null,null,null,{"$f":"IF(M130=\"CAP3\",SUM(N249:R249),M130)","v":""},{"$f":"IF(M130=\"CAP3\",N244*N28,M130)","v":""},{"$f":"IF(M130=\"CAP3\",O244*O28,M130)","v":""},{"$f":"IF(M130=\"CAP3\",P244*P28,M130)","v":""},{"$f":"IF(M130=\"CAP3\",Q244*Q28,M130)","v":""},{"$f":"IF(M130=\"CAP3\",R244*R28,M130)","v":""}]
[530,"Final Total End User Revenue","r500 + r510 + r520",0,0,0,0,0,0,null,null,null,{"$f":"IF(M130=\"CAP3\",SUM(M247:M249),M130)","v":""},{"$f":"IF(M130=\"CAP3\",SUM(N247:N249),M130)","v":""},{"$f":"IF(M130=\"CAP3\",SUM(O247:O249),M130)","v":""},{"$f":"IF(M130=\"CAP3\",SUM(P247:P249),M130)","v":""},{"$f":"IF(M130=\"CAP3\",SUM(Q247:Q249),M130)","v":""},{"$f":"IF(M130=\"CAP3\",SUM(R247:R249),M130)","v":""}]
[null,"",""]
[600,"Actual vs. Allowable Revenue:  Over-recovery","r530 - r130",{"$f":"SUM(M252)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"CAP3\",M250-M209,M130)","v":""},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,"          or (Under-recovery)"]
[]
["CAP-4J",null,null,"Total ",null,null,null,null,null,null,null,null,{"$f":"M15","v":0}]
[{"$f":"\"Filing Date:                \"&DATE","v":"Filing Date:                06/16/2021"}]
[{"$f":"\"Filing Entity:               \"&COSA","v":"Filing Entity:               "}]
[{"$f":"\"Transmittal Number:   \"&TRANSMITTAL","v":"Transmittal Number:   "},null,null,"",null,null,null,null,null,null,null,null,""]
[{"$f":"NAME","v":0}]
["Page 1 of 1",null,null,"Price Cap Tariff Review Plan",null,null,null,null,null,null,null,null,"Price Cap Tariff Review Plan"]
[null,null,null,"Allocation of Pool Revenues to MLB PICC & MLB EUCL",null,null,null,null,null,null,null,null,"Allocation of Pool Revenues to MLB PICC & MLB EUCL"]
[]
[]
[null,null,null,"Total","No Zone / Zone A","Zone B","Zone C","Zone D","Other Zone",null,null,null,"Total Jurisdiction","No Zone / Zone A","Zone B","Zone C","Zone D","Other Zone"]
[null,null,"Source","(a)","(b)","(c)","(d)","(e)","(f)",null,null,null,"(a)","(b)","(c)","(d)","(e)","(f)"]
[]
[null,null,"For rows 100&105: If CAP1r1110=\"Yes\", use sourcing; else enter \"No Pooling\"."]
[100,"Pooling Amount?","Input",{"$f":"SUM(M268)","v":0},null,null,null,null,null,null,null,null,null,"      N/A","      N/A","      N/A","      N/A","      N/A"]
[105,"CAP Form containing final EUCL Rates?","CAP1r1130",null,null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(M130=\"Agg.Rate\",\"CAP1\",M130)))","v":""},"      N/A","      N/A","      N/A","      N/A","      N/A"]
["","",""]
["","",""]
["","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."]
[110,"MLB, PRI ISDN & Centrex EUCL Cap","CAP1r420",null,null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"\",\"\",IF(M269<>\"CAP3\",IF(M128<>\"Yes\",\"No Pooling\",M48),M130))","v":""},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[120,"MLB, PRI & Centrex EUCL Rate","if r105=\"CAP1\", r110;  =\"CAP2\",CAP2r420;",null,null,null,null,null,null,null,null,null,null,"      N/A","      N/A","      N/A","      N/A","      N/A"]
["","",""]
[130,"MLB, PRI ISDN Revenue below EUCL CAP","(r110-r120)*(CAP1r120)",{"$f":"SUM(M276)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"\",\"\",IF(M269<>\"CAP3\",IF(M128<>\"Yes\",\"No Pooling\",(M273-M274)*M28),M130))","v":""},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[140,"Pooling revenue to be recovered from MLB EUCL Rate","Min(r130,r100)",{"$f":"SUM(M277)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"\",\"\",IF(M269<>\"CAP3\",IF(M128<>\"Yes\",\"No Pooling\",MIN(M276,M268)),M130))","v":""},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[150,"MLB EUCL rate","r120+(r140/CAP1r120) ",null,null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"\",\"\",IF(M269<>\"CAP3\",IF(M128<>\"Yes\",\"No Pooling\",IF(M28=0,0,M274+(M277/M28))),M130))","v":""},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[155,"MLB EUCL Revenue","r150 * (CAP1r120)",{"$f":"SUM(M279)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"\",\"\",IF(M269<>\"CAP3\",IF(M128<>\"Yes\",\"No Pooling\",M278*(M28)),M130))","v":""},"      N/A","      N/A","      N/A","      N/A","      N/A"]
["","",""]
["","",""]
[160,"Remaining Pooling Revenues","r100 - r140",{"$f":"SUM(M282)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"\",\"\",IF(M269<>\"CAP3\",IF(M128<>\"Yes\",\"No Pooling\",N(M268)-N(M277)),M130))","v":""},"      N/A","      N/A","      N/A","      N/A","      N/A"]
["","",""]
[170,"MLB PICC Cap","CAP1r430",null,null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(M130=\"\",\"\",IF(M269=\"CAP3\",M130,M49))))","v":""},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[180,"Maximum Average MLB, PRI & Centrex PICC Rate","CAP1r830",null,null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(M130=\"\",\"\",IF(M269=\"CAP3\",M130,IF(A!$G$7=\"y\",M106,A!$AJ106)))))","v":""},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[190,"MLB PICC Revenue below CAP","(r170-r180)*(CAP1(r200+r210/9+r220))",{"$f":"SUM(M286)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(OR(M269=\"CAP1\",M269=\"CAP2\"),IF(A!$G$7=\"y\",(M284-M285)*(M32+M33/9+M34),(A!$AJ284-A!$AJ285)*(M32+M33/9+M34)),M130)))","v":""},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[200,"Pooling revenue to be recovered from MLB PICC Rate","Min(r190,r160)",{"$f":"SUM(M287)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(OR(M269=\"CAP1\",M269=\"CAP2\"),MIN(M286,M282),M130)))","v":""},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[210,"MLB PICC rate","r180+(r200/CAP1(r200+r210/9+r220)) ",null,null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(OR(M269=\"CAP1\",M269=\"CAP2\"),IF(A!$G$7=\"y\",IF(M32+M33/9+M34=0,0,M285+(M287/(M32+M33/9+M34))),A!$AJ288),M130)))","v":""},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[220,"MLB PICC Revenue","r 210 * (CAP1(r200+r210/9+r220))",{"$f":"SUM(M289)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(OR(M269=\"CAP1\",M269=\"CAP2\"),M288*(M32+M33/9+M34),M130)))","v":""},"      N/A","      N/A","      N/A","      N/A","      N/A"]
["","",""]
["","",""]
["","MLB Pooled EU Rates for CAP3","For rows 300 to 400: If CAP4r105=\"CAP3\" or if Jurisdictional pricing, use sourcing; else value from CAP1r1130."]
[300,"Total MLB&PRI ISDN lines (include both PRI * 5 & Centrex)","CAP1r120",{"$f":"SUM(M293)","v":0},0,0,0,0,0,null,null,null,{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(OR(M269=\"CAP3\",M269=\"Agg.Rate\"),M28,M130)))","v":""},{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(OR(M269=\"CAP3\",M269=\"Agg.Rate\"),N28,M130)))","v":""},{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(OR(M269=\"CAP3\",M269=\"Agg.Rate\"),O28,M130)))","v":""},{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(OR(M269=\"CAP3\",M269=\"Agg.Rate\"),P28,M130)))","v":""},{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(OR(M269=\"CAP3\",M269=\"Agg.Rate\"),Q28,M130)))","v":""},{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(OR(M269=\"CAP3\",M269=\"Agg.Rate\"),R28,M130)))","v":""}]
[310,"CAP3 Final MLB, PRI ISDN, & Centrex EU Rate","if r105=\"CAP3\",CAP3r420; else r105",null,null,null,null,null,null,null,null,null,"      N/A",{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(OR(M269=\"CAP3\",M269=\"Agg.Rate\"),N244,M130)))","v":""},{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(OR(M269=\"CAP3\",M269=\"Agg.Rate\"),O244,M130)))","v":""},{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(OR(M269=\"CAP3\",M269=\"Agg.Rate\"),P244,M130)))","v":""},{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(OR(M269=\"CAP3\",M269=\"Agg.Rate\"),Q244,M130)))","v":""},{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(OR(M269=\"CAP3\",M269=\"Agg.Rate\"),R244,M130)))","v":""}]
[320,"CAP3 Final Total MLB, PRI ISDN, & Centrex EU Revenue","CAP3r520",{"$f":"SUM(M295)","v":0},0,0,0,0,0,null,null,null,{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(M269=\"CAP3\",SUM(N295:R295),M130)))","v":""},{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(OR(M269=\"CAP3\",M269=\"Agg.Rate\"),N293*N294,M130)))","v":""},{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(OR(M269=\"CAP3\",M269=\"Agg.Rate\"),O293*O294,M130)))","v":""},{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(OR(M269=\"CAP3\",M269=\"Agg.Rate\"),P293*P294,M130)))","v":""},{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(OR(M269=\"CAP3\",M269=\"Agg.Rate\"),Q293*Q294,M130)))","v":""},{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(OR(M269=\"CAP3\",M269=\"Agg.Rate\"),R293*R294,M130)))","v":""}]
[330,"CAP3 Final MLB Rate adjusted for Pooling amount","a: min(330b.f) b-f:(sum(r310b.f)+r100a)/sum(r300b.f)",null,null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(M269=\"CAP3\",MIN(N296:R296),M130)))","v":""},{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(M269<>\"CAP3\",M130,IF(SUM(N293:N293)=0,0,(SUM(N295:N295)+M268)/(SUM(N293:N293))))))","v":""},{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(M269<>\"CAP3\",M130,IF(SUM(N293:O293)=0,0,(SUM(N295:O295)+M268)/(SUM(N293:O293))))))","v":""},{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(M269<>\"CAP3\",M130,IF(SUM(N293:P293)=0,0,(SUM(N295:P295)+M268)/(SUM(N293:P293))))))","v":""},{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(M269<>\"CAP3\",M130,IF(SUM(N293:Q293)=0,0,(SUM(N295:Q295)+M268)/(SUM(N293:Q293))))))","v":""},{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(M269<>\"CAP3\",M130,IF(SUM(N293:R293)=0,0,(SUM(N295:R295)+M268)/(SUM(N293:R293))))))","v":""}]
[340,"Final MLB, PRI ISDN & Centrex EU Rate with Pooling","max(r310,r330a)",null,null,null,null,null,null,null,null,null,"      N/A",{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(M269<>\"CAP3\",M130,IF(N294=0,0,MAX(N294,M296)))))","v":""},{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(M269<>\"CAP3\",M130,IF(O294=0,0,MAX(O294,M296)))))","v":""},{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(M269<>\"CAP3\",M130,IF(P294=0,0,MAX(P294,M296)))))","v":""},{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(M269<>\"CAP3\",M130,IF(Q294=0,0,MAX(Q294,M296)))))","v":""},{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(M269<>\"CAP3\",M130,IF(R294=0,0,MAX(R294,M296)))))","v":""}]
[350,"MLB EUCL Revenue","r300*r340",{"$f":"SUM(M298)","v":0},0,0,0,0,0,null,null,null,{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(M269=\"CAP3\",SUM(N298:R298),M130)))","v":""},{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(OR(M269=\"CAP3\",M269=\"Agg.Rate\"),N293*N297,M130)))","v":""},{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(OR(M269=\"CAP3\",M269=\"Agg.Rate\"),O293*O297,M130)))","v":""},{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(OR(M269=\"CAP3\",M269=\"Agg.Rate\"),P293*P297,M130)))","v":""},{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(OR(M269=\"CAP3\",M269=\"Agg.Rate\"),Q293*Q297,M130)))","v":""},{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(OR(M269=\"CAP3\",M269=\"Agg.Rate\"),R293*R297,M130)))","v":""}]
["","",""]
[400,"Un-recovered Pool Revenues","if CAP1r1110=\"No\", then \"No Pooling\"; else ",{"$f":"SUM(M300)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"\",\"\",IF(M128<>\"Yes\",\"No Pooling\",IF(M269=\"CAP3\",M268+M295-M298,M282-M287)))","v":""},"      N/A","      N/A","      N/A","      N/A","      N/A"]
["","","       if r105=\"CAP3\", then r100+r320-r350; "]
["","","       if r105=\"Juris\", then r100+r320-r350-r140; "]
[null,null,"       else r160-r200"]
["",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["CAP-5J",null,null,"Total ",null,null,null,null,null,null,null,null,{"$f":"M15","v":0}]
[{"$f":"\"Filing Date:                \"&DATE","v":"Filing Date:                06/16/2021"},null,""]
[{"$f":"\"Filing Entity:               \"&COSA","v":"Filing Entity:               "},null,""]
[{"$f":"\"Transmittal Number:   \"&TRANSMITTAL","v":"Transmittal Number:   "},null,"","",null,null,null,null,null,null,null,null,""]
[{"$f":"NAME","v":0},null,null,"Price Cap Tariff Review Plan",null,null,null,null,null,null,null,null,"Price Cap Tariff Review Plan"]
["Page 1 of 1",null,null,"Verification of Recovered CMT Revenue",null,null,null,null,null,null,null,null,"Verification of Recovered CMT Revenue"]
[null,null,""]
[null,null,""]
[null,null,"","Total",null,null,null,null,null,null,null,null,"Total Jurisdiction"]
[null,null,"Source","(a)",null,null,null,null,null,null,null,null,"(a)"]
[]
[100,"Maximum CMT Revenue","CAP1r600",{"$f":"SUM(M326)","v":0},null,null,null,null,null,null,null,null,{"$f":"M86","v":0}]
[110,"Total USAC Receipts","CAP1r660",{"$f":"SUM(M327)","v":0},null,null,null,null,null,null,null,null,{"$f":"M93","v":0}]
["","",""]
[125,"Pooling Revenues","if CAP1r1110 = \"Yes\", CAP4r100",{"$f":"SUM(M329)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(OR(M268=\"\",M268=\"No Pooling\"),0,M268)","v":0}]
[130,"Maximum Recoverable Revenue","r100 - r110 + r125",{"$f":"SUM(M330)","v":0},null,null,null,null,null,null,null,null,{"$f":"M326-M327+M329","v":0}]
["","",""]
[200,"Final Total Primary Res & SLB & LifeLine EU Revenue","if CAP1r1130 = \"CAP1\", CAP1r610",{"$f":"SUM(M332)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"\",0,IF(OR(M130=\"CAP1\",M130=\"Agg.Rate\"),M87,IF(M130=\"CAP2\",M162,IF(M130=\"CAP3\",M247,\"          ERROR\"))))","v":0}]
["","","if CAP1r1130 = \"CAP2\", CAP2r500"]
["","","if CAP1r1130 = \"CAP3\", CAP3r500"]
["","","if CAP1r1130=\"Juris\",CAP1r1140+CAP2r500+CAP3r500"]
[210,"Final Total NonPrim Res & BRI ISDN EU Revenue","if CAP1r1130 = \"CAP1\", CAP1r620",{"$f":"SUM(M336)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"\",0,IF(OR(M130=\"CAP1\",M130=\"Agg.Rate\"),M88,IF(M130=\"CAP2\",M163,IF(M130=\"CAP3\",M248,\"          ERROR\"))))","v":0}]
["","","if CAP1r1130 = \"CAP2\", CAP2r510"]
["","","if CAP1r1130 = \"CAP3\", CAP3r510"]
["","","if CAP1r1130=\"Juris\",CAP1r1150+CAP2r510+CAP3r510"]
[220,"Final Total MLB, PRI ISDN, & Centrex EU Revenue","if CAP1r1110=\"Yes\"&:",{"$f":"SUM(M340)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"\",0,IF(M128=\"Yes\",IF(OR(M130=\"CAP1\",M130=\"Agg.Rate\"),M279,IF(M130=\"CAP2\",M279,IF(M130=\"CAP3\",M298,\"          ERROR\"))),IF(OR(M130=\"CAP1\",M130=\"Agg.Rate\"),M89,IF(M130=\"CAP2\",M164,IF(M130=\"CAP3\",M249,\"          ERROR\")))))","v":0}]
["","","      if CAP1r1130=\"CAP1\" or \"CAP2\", CAP4r155"]
["","","      if CAP1r1130=\"CAP3\", CAP4r350a"]
["","","      if CAP1r1130=\"Juris\", CAP4(r155+r350a)"]
[null,null,"if CAP1r1110=\"No\"&:"]
[null,null,"      if CAP1r1130=\"CAP1\", CAP1r630"]
[null,null,"      if CAP1r1130=\"CAP2\", CAP2r520"]
[null,null,"      if CAP1r1130=\"CAP3\", CAP3r520"]
[null,null,"      if CAP1r1130=\"Juris\", CAP1r1160+CAP2r520+CAP3r520"]
[]
[]
[300,"Final Total EUCL Revenue","r200 + r210 + r220",{"$f":"SUM(M351)","v":0},null,null,"EUCL rev recovered by juris. EUCL rates only",null,null,null,null,null,{"$f":"SUM(M332,M336,M340)","v":0}]
[310,"Final Total PICC Revenue","if CAP1r1110=\"Yes\"&CAP1r1130<>\"CAP3\", ",{"$f":"SUM(M352)","v":0},null,null,"PICC rev recovered by juris PICC rates only",null,null,null,null,null,{"$f":"IF(AND(M128=\"Yes\",M130<>\"CAP3\"),M289,M109)","v":0}]
[null,null,"     CAP4 r220; else CAP1r860"]
[320,"Final Total CCL Revenue","CAP1r995",{"$f":"SUM(M354)","v":0},null,null,"CCL rev recovered by juris CCL rates only",null,null,null,null,null,{"$f":"M124","v":0}]
["","",""]
[400,"Final Total Recovered Revenue","r300 + r310 + r320",{"$f":"SUM(M356)","v":0},null,null,"EUCL, PICC, CCL rev recovered by juris rates only ",null,null,null,null,null,{"$f":"SUM(M351:M354)","v":0}]
["","",""]
[500,"Allowable Revenue Over-recovery/(Under-recovery)"," r400-r130",{"$f":"SUM(M358)","v":0},null,null,"over/under-recovery, as it relates to juris rates only",null,null,null,null,null,{"$f":"ROUND(M356-M330,0)","v":0},{"$f":"IF(M358>0,\"     Error:  Over-recovery. You must change some rates.\",IF(M358<0,\"     You have under-recovered by this amount.\",\"     ok\"))","v":"     ok"}]
[]
["","",""]
[600,"Nonrecoverable from PICC and CCL","CAP1r950-CAP1r995",{"$f":"N(D118)-N(D124)","v":0},null,null,null,null,null,null,null,null,{"$f":"N(M118)-N(M124)","v":0}]
[605,"Annual Filing Non Recoverable Dollars ","if Annual filing = 0 else r600 - r610 from the Annual Filing",{"$f":"SUM(M362)","v":0}]
[607,"Cumulative CAF-ICC Exog Cost Base Year","Exog Cost base year",{"$f":"A!AJ363","v":"NA"}]
[608,"Cumulative  CAF-ICC Exogenous Cost","See Exog Cost Details wrksht",{"$f":"A!AJ364","v":0}]
[610,"Recoverable from ARC","Allocate total Recoverable from ARC to each Juris. based on r600.",{"$f":"SUM(M365)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(A!$AJ$365<A!$AJ$361,A!$AJ$365*M361/A!$AJ$361,M361)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["ANALYZER - Juris",null,null,null,null,null,null,null,null,null,null,null,{"$f":"M15","v":0}]
[{"$f":"\"Filing Date:                \"&DATE","v":"Filing Date:                06/16/2021"}]
[{"$f":"\"Filing Entity:               \"&COSA","v":"Filing Entity:               "}]
[{"$f":"\"Transmittal Number:   \"&TRANSMITTAL","v":"Transmittal Number:   "}]
[{"$f":"NAME","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flag"]
["COMMON LINE-----------------------------------------",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[]
["Deaveraging Checks (from CAP3):"]
["   Zone Progression Checks:"]
["     Primary Res, SLB, & LifeLine",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N(M206)<=0,M206,IF(AND(O29<>0,N(O242)<N(N242)),\"FAIL\",IF(AND(P29<>0,N(P242)<N(O242)),\"FAIL\",IF(AND(Q29<>0,N(Q242)<N(P242)),\"FAIL\",IF(AND(R29<>0,N(R242)<N(Q242)),\"FAIL\",\"PASS\")))))","v":""},{"$f":"IF(M386=\"\",\"\",IF(M129=\"no\",\"No Deaveraging Allowed\",IF(AND(O29<>0,O242<N242),\"Prim Res Zone B < Zone A\",IF(AND(P29<>0,P242<O242),\"Prim Res Zone C < Zone B\",IF(AND(Q29<>0,Q242<P242),\"Prim Res Zone D < Zone C\",IF(AND(R29<>0,R242<Q242),\"Prim Res Zone Other < Zone D\",\"Prim Rates OK\"))))))","v":""}]
["     NonPrimary Res & BRI ISDN",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N(M206)<=0,M206,IF(AND(O29<>0,N(O243)<N(N243)),\"FAIL\",IF(AND(P29<>0,N(P243)<N(O243)),\"FAIL\",IF(AND(Q29<>0,N(Q243)<N(P243)),\"FAIL\",IF(AND(R29<>0,N(R243)<N(Q243)),\"FAIL\",\"PASS\")))))","v":""},{"$f":"IF(M387=\"\",\"\",IF(M129=\"no\",\"No Deaveraging Allowed\",IF(AND(O29<>0,O243<N243),\"Non Prim Zone B < Zone A\",IF(AND(P29<>0,P243<O243),\"Non Prim Zone C < Zone B\",IF(AND(Q29<>0,Q243<P243),\"Non Prim Zone D < Zone C\",IF(AND(R29<>0,R243<Q243),\"Non Prim Zone Other < Zone D\",\"Non Prim Rates OK\"))))))","v":""}]
["     MLB, PRI ISDN, & Centrex",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N(M206)<=0,M206,IF(AND(O29<>0,N(O244)<N(N244)),\"FAIL\",IF(AND(P29<>0,N(P244)<N(O244)),\"FAIL\",IF(AND(Q29<>0,N(Q244)<N(P244)),\"FAIL\",IF(AND(R29<>0,N(R244)<N(Q244)),\"FAIL\",\"PASS\")))))","v":""},{"$f":"IF(M388=\"\",\"\",IF(M129=\"no\",\"No Deaveraging Allowed\",IF(AND(O29<>0,O244<N244),\"MLB Zone B < Zone A\",IF(AND(P29<>0,P244<O244),\"MLB Zone C < Zone B\",IF(AND(Q29<>0,Q244<P244),\"MLB Zone D < Zone C\",IF(AND(R29<>0,R244<Q244),\"MLB Zone Other < Zone D\",\"MLB Rates OK\"))))))","v":""}]
[]
["   Zone Minimum Pricing Checks:"]
["     Primary Res, SLB, & LifeLine",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"\",\"\",IF(M129=\"no\",\"N/A\",IF(OR(AND(OR(M130=\"CAP1\",M130=\"CAP2\"),N(#REF!)<>0),AND(N29<>0,N(N242)<N(M231)),AND(O29<>0,N(O242)<N(M231)),AND(P29<>0,N(P242)<N(M231)),AND(Q29<>0,N(Q242)<N(M231)),AND(R29<>0,N(R242)<N(M231))),\"FAIL\",\"PASS\")))","v":""},{"$f":"IF(M391=\"\",\"\",IF(M129=\"no\",\"No Deaveraging Allowed\",IF(AND(N29<>0,N242<M231),\"Prim Res Zone A < Min\",IF(AND(O29<>0,O242<M231),\"Prim Res Zone B < Min\",IF(AND(P29<>0,P242<M231),\"Prim Res Zone C < Min\",IF(AND(Q29<>0,Q242<M231),\"Prim Res Zone D < Min\",IF(AND(R29<>0,R242<M231),\"Prim Res Zone Other < Min\",\"Prim Rates above Min\")))))))","v":""}]
["     NonPrimary Res & BRI ISDN",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"\",\"\",IF(M129=\"no\",\"N/A\",IF(OR(AND(OR(M130=\"CAP1\",M130=\"CAP2\"),N(#REF!)<>0),AND(N29<>0,N(N243)<N(M234)),AND(O29<>0,N(O243)<N(M234)),AND(P29<>0,N(P243)<N(M234)),AND(Q29<>0,N(Q243)<N(M234)),AND(R29<>0,N(R243)<N(M234))),\"FAIL\",\"PASS\")))","v":""},{"$f":"IF(M392=\"\",\"\",IF(M129=\"no\",\"No Deaveraging Allowed\",IF(AND(N29<>0,N243<M234),\"Non Prim Zone A < Min\",IF(AND(O29<>0,O243<M234),\"Non Prim Zone B < Min\",IF(AND(P29<>0,P243<M234),\"Non Prim Zone C < Min\",IF(AND(Q29<>0,Q243<M234),\"Non Prim Zone D < Min\",IF(AND(R29<>0,R243<M234),\"Non Prim Zone Other < Min\",\"Non Prim Rates above Min\")))))))","v":""}]
["     MLB, PRI ISDN, & Centrex",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"\",\"\",IF(M129=\"no\",\"N/A\",IF(OR(AND(OR(M130=\"CAP1\",M130=\"CAP2\"),N(#REF!)<>0),AND(N29<>0,N(N244)<N(M237)),AND(O29<>0,N(O244)<N(M237)),AND(P29<>0,N(P244)<N(M237)),AND(Q29<>0,N(Q244)<N(M237)),AND(R29<>0,N(R244)<N(M237))),\"FAIL\",\"PASS\")))","v":""},{"$f":"IF(M393=\"\",\"\",IF(M129=\"no\",\"No Deaveraging Allowed\",IF(AND(N29<>0,N244<M237),\"MLB Zone A < Min\",IF(AND(O29<>0,O244<M237),\"MLB Zone B < Min\",IF(AND(P29<>0,P244<M237),\"MLB Zone C < Min\",IF(AND(Q29<>0,Q244<M237),\"MLB Zone D < Min\",IF(AND(R29<>0,R244<M237),\"MLB Zone Other < Min\",\"MLB Rates above Min\")))))))","v":""}]
[]
["   Zone Maximum Pricing Checks:"]
["     Primary Res, SLB, & LifeLine",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"\",\"\",IF(OR(M130=\"CAP1\",M130=\"CAP2\"),\"N/A\",IF(OR(N(#REF!)<>0,AND(N29<>0,N(N242)<N(M232)),AND(O29<>0,N(O242)<N(M232)),AND(P29<>0,N(P242)<N(M232)),AND(Q29<>0,N(Q242)<N(M232)),AND(R29<>0,N(R242)<N(M232))),\"FAIL\",\"PASS\")))","v":""},{"$f":"IF(M396=\"\",\"\",IF(M129=\"no\",\"No Deaveraging Allowed\",IF(AND(N29<>0,N242>M232),\"Prim Res Zone A > Max\",IF(AND(O29<>0,O242>M232),\"Prim Res Zone B > Max\",IF(AND(P29<>0,P242>M232),\"Prim Res Zone C > Max\",IF(AND(Q29<>0,Q242>M232),\"Prim Res Zone D > Max\",IF(AND(R29<>0,R242>M232),\"Prim Res Zone Other > Max\",\"Prim Rates below Max\")))))))","v":""}]
["     NonPrimary Res & BRI ISDN",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"\",\"\",IF(OR(M130=\"CAP1\",M130=\"CAP2\"),\"N/A\",IF(OR(N(#REF!)<>0,AND(N29<>0,N(N243)<N(M235)),AND(O29<>0,N(O243)<N(M235)),AND(P29<>0,N(P243)<N(M235)),AND(Q29<>0,N(Q243)<N(M235)),AND(R29<>0,N(R243)<N(M235))),\"FAIL\",\"PASS\")))","v":""},{"$f":"IF(M397=\"\",\"\",IF(M129=\"no\",\"No Deaveraging Allowed\",IF(AND(N29<>0,N243>M235),\"Non Prim Zone A > Max\",IF(AND(O29<>0,O243>M235),\"Non Prim Zone B > Max\",IF(AND(P29<>0,P243>M235),\"Non Prim Zone C > Max\",IF(AND(Q29<>0,Q243>M235),\"Non Prim Zone D > Max\",IF(AND(R29<>0,R243>M235),\"Non Prim Zone Other > Max\",\"Non Prim Rates below Max\")))))))","v":""}]
["     MLB, PRI ISDN, & Centrex",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"\",\"\",IF(OR(M130=\"CAP1\",M130=\"CAP2\"),\"N/A\",IF(OR(N(#REF!)<>0,AND(N29<>0,N(N244)<N(M238)),AND(O29<>0,N(O244)<N(M238)),AND(P29<>0,N(P244)<N(M238)),AND(Q29<>0,N(Q244)<N(M238)),AND(R29<>0,N(R244)<N(M238))),\"FAIL\",\"PASS\")))","v":""},{"$f":"IF(M398=\"\",\"\",IF(M129=\"no\",\"No Deaveraging Allowed\",IF(AND(N29<>0,N244>M238),\"MLB Zone A > Max\",IF(AND(O29<>0,O244>M238),\"MLB Zone B > Max\",IF(AND(P29<>0,P244>M238),\"MLB Zone C > Max\",IF(AND(Q29<>0,Q244>M238),\"MLB Zone D > Max\",IF(AND(R29<>0,R244>M238),\"MLB Zone Other > Max\",\"MLB Rates below Max\")))))))","v":""}]
[]
["   Class of Service Checks:"]
["     Zone A",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"\",\"\",IF(M129=\"no\",\"N/A\",IF(N(N243)<N(N242),\"FAIL\",IF(N(N244)<N(N243),\"FAIL\",\"PASS\"))))","v":""},{"$f":"IF(M401=\"\",\"\",IF(M129=\"no\",\"No Deaveraging Allowed\",IF(N(N$243)<N(N$242),\"Zone A Non Prim < Prim\",IF(N(N$244)<N(N$243),\"Zone A MLB < Non Prim\",\"Zone A OK\"))))","v":""}]
["     Zone B",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"\",\"\",IF(M129=\"no\",\"N/A\",IF(N(O243)<N(O242),\"FAIL\",IF(N(O244)<N(O243),\"FAIL\",\"PASS\"))))","v":""},{"$f":"IF(M402=\"\",\"\",IF(M129=\"no\",\"No Deaveraging Allowed\",IF(N(O$243)<N(O$242),\"Zone B Non Prim < Prim\",IF(N(O$244)<N(O$243),\"Zone B MLB < Non Prim\",\"Zone B OK\"))))","v":""}]
["     Zone C",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"\",\"\",IF(M129=\"no\",\"N/A\",IF(N(P243)<N(P242),\"FAIL\",IF(N(P244)<N(P243),\"FAIL\",\"PASS\"))))","v":""},{"$f":"IF(M403=\"\",\"\",IF(M129=\"no\",\"No Deaveraging Allowed\",IF(N(P$243)<N(P$242),\"Zone C Non Prim < Prim\",IF(N(P$244)<N(P$243),\"Zone C MLB < Non Prim\",\"Zone C OK\"))))","v":""}]
["     Zone D",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"\",\"\",IF(M129=\"no\",\"N/A\",IF(N(Q243)<N(Q242),\"FAIL\",IF(N(Q244)<N(Q243),\"FAIL\",\"PASS\"))))","v":""},{"$f":"IF(M404=\"\",\"\",IF(M129=\"no\",\"No Deaveraging Allowed\",IF(N(Q$243)<N(Q$242),\"Zone D Non Prim < Prim\",IF(N(Q$244)<N(Q$243),\"Zone D MLB < Non Prim\",\"Zone D OK\"))))","v":""}]
["     Other Zone",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"\",\"\",IF(M129=\"no\",\"N/A\",IF(N(R243)<N(R242),\"FAIL\",IF(N(R244)<N(R243),\"FAIL\",\"PASS\"))))","v":""},{"$f":"IF(M405=\"\",\"\",IF(M129=\"no\",\"No Deaveraging Allowed\",IF(N(R$243)<N(R$242),\"Other Zone Non Prim < Prim\",IF(N(R$244)<N(R$243),\"Other Zone MLB < Non Prim\",\"Other Zone OK\"))))","v":""}]
[]
["      CMT Revenue Too High?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(TRUNC(M356,0)>TRUNC(M330,0),\"     HIGH\",\"       *\")","v":"       *"}]