{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["A"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":28,"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":74,"rows_kept":380,"cut":false,"hidden":false,"merged":[]}
["Filing Date (enter w/leading '):",null,null,"06/16/2023","2023 Annual Filing"]
["Tariff Entity (4 character COSA code):",null,null,null,null,null,null,null,null,null,null,"EOPYDate (enter w/leading ')","6/30/2023"]
["Transmittal Number (enter w/leading '):",null,null,null,null,null,null,null,null,null,null,"Date of Last PCI Update","10/01/2022"]
["Filing Name:"]
[]
["1) Uses multiplicative SBI Upper limits"]
["2) ANALYZER starts in column BT."]
[]
[]
[]
["IND-1 chart, Page 1.  Arrow right for next chart.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PCI-1 chart.  Arrow right for next chart.",null,null,null,null,null,null,null,null,null,"SUM-1 chart.  Arrow right for next chart. ",null,null,null,null,null,null,null,null,null,null,"EXG-1 chart, Page 1.  Arrow down for EXG-2 chart.  Arrow right for next chart.",null,null,null,null,null,null,null,null,null,null,null,"RTE-1 chart, Pages 1-6",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 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,null,null,null,null,null,"Page down 60 for next page.",null,null,null,null,null,null,null,null,null,null,null,"Page down 60 for next page",null,null,null,null,null,null,null,null,null,null,"Page down 60 for next page",null,null,null,null,null,null,null,null,"Page down 60 for next page"]
["To Print, Use Manual Compression = 63% and Landscape Mode.",null,null,null,null,null,null,null,null,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,"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.",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"]
[]
["IND-1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PCI-1",null,null,null,null,null,null,null,null,null,"SUM-1",null,null,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/2023"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Filing Date:                \"&DATE","v":"Filing Date:                06/16/2023"},null,null,null,null,null,null,null,null,null,{"$f":"\"Filing Date:                \"&DATE","v":"Filing Date:                06/16/2023"},null,null,null,null,null,null,null,null,null,null,{"$f":"\"Filing Date:                \"&DATE","v":"Filing Date:                06/16/2023"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Filing Date:                \"&DATE","v":"Filing Date:                06/16/2023"},null,null,null,null,null,null,null,null,null,null,{"$f":"\"Filing Date:                \"&DATE","v":"Filing Date:                06/16/2023"},null,null,null,null,null,null,null,null,{"$f":"\"Filing Date:                \"&$D$1","v":"Filing Date:                06/16/2023"}]
[{"$f":"\"Filing Entity:               \"&COSA","v":"Filing Entity:               "},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,{"$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,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,"   Price Cap Tariff Review Plan",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,{"$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,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,null,"             Indices",null,null,null,null,null,null,null,null,null,null,{"$f":"NAME","v":0},null,null,null,"   Price Cap Tariff Review Plan",null,null,null,null,null,{"$f":"NAME","v":0},null,null,null,"Price Caps Tariff Review Plan",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,{"$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,"7/1/2023",{"$f":"D20","v":"7/1/2023"},{"$f":"E20","v":"7/1/2023"},{"$f":"F20","v":"7/1/2023"},{"$f":"M3","v":"10/01/2022"},{"$f":"H20","v":"10/01/2022"},{"$f":"I20","v":"10/01/2022"},{"$f":"J20","v":"10/01/2022"},"In effect on","In effect on",null,null,null,"Page 1 of 1",null,null,null,"            PCI Development",null,null,null,null,null,"Page 1 of 1",null,null,null,"      Price Out Summary",null,null,null,null,null,null,"Page 1 of 1",null,null,null,null,"  Exogenous Cost Changes",null,null,null,null,null,null,"Page 1 of 6",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 5"]
[null,null,null,"PROPOSED","PROPOSED","PROPOSED","PROPOSED","EXISTING","EXISTING","EXISTING","EXISTING",{"$f":"$M$2","v":"6/30/2023"},{"$f":"$M$2","v":"6/30/2023"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"PCI ","API","SBI","SBI LIMIT","PCI ","API","SBI","SBI LIMIT","PCI ","SBI",null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,"BASE PER DMD x",null,null,null,null,null,null,null,null,null,null,null,"TRUEUP PRIOR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GENERAL--------------------------------------------","-"]
[null,null,null,"(A)","(B)","(C)","(D)","(E)","(F)","(G)","(H)","(I)","(J)",null,null,null,null,null,null,null,null,null,"SPECIAL",null,null,null,null,null,null,"BASE PERIOD","","","CURR RATES minus","BASE PER DMD x",null,null,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","   GDPPI",{"$f":"W29","v":0}]
["","Special Access Basket",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ACCESS",null,null,null,null,null,null,"DEMAND x","BASE PERIOD","BASE PERIOD","BASE PER DMD x","PROP RATES minus",null,null,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)"]
[720,"VG/WATS,Met,Tgh - Special  ",null,"          N/A","          N/A",null,null,"          N/A","          N/A",null,null,"          N/A",null,null,null,null,null,null,"Source",null,null,null,"BASKET",null,null,null,null,null,null,{"$f":"\"RATES AT \" & MONTH($M$3) & \"/\"& DAY($M$3) & \"/\" & RIGHT(YEAR($M$3),2)","v":"RATES AT 10/1/22"},"DEMAND x","DEMAND x",{"$f":"\"RATES AT \" & MONTH($M$3) & \"/\"& DAY($M$3) & \"/\" & RIGHT(YEAR($M$3),2)","v":"RATES AT 10/1/22"},"BASE PER DMD x",null,null,null,null,null,"EXCHANGES","FEES","TAXES","AMORTIZ.","ADJUSTMENT","ADJUSTMENT","ADJUSTMENT","SERVICES","REG/NON-REG",null,null,null,null,"PERIOD",{"$f":"MONTH($M$3) & \"/\"& DAY($M$3) & \"/\" & RIGHT(YEAR($M$3),2) & \" PCI\"","v":"10/1/22 PCI"},"CURRENT","PROPOSED",{"$f":"\"RATES AT \" & MONTH($M$3) & \"/\"& DAY($M$3) & \"/\" & RIGHT(YEAR($M$3),2)","v":"RATES AT 10/1/22"},"CURRENT","PROPOSED","INDEX ","","EUCL Demand Inputs","",null,null,null,null,null,null,"   X for SP",{"$f":"W30","v":2}]
[730,"Audio & Video",null,"          N/A","          N/A",null,null,"          N/A","          N/A",null,null,"          N/A",null,null,null,null,null,"-","-",null,null,null,"-",null,null,null,null,null,null,"PCI UPDATE","CURRENT RATES","PROPOSED RATES","PCI UPDATE","CURRENT RATES",null,null,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(BM26:BQ26)","v":0},{"$f":"BA30","v":0},{"$f":"BA37","v":0},{"$f":"BA42","v":0},{"$f":"BA47","v":0},{"$f":"BA52","v":0}]
[740,"High Cap & DDS - Special",null,"          N/A","          N/A",null,null,"          N/A","          N/A",null,null,"          N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(A)","(B)","(C)","(D) = (B) - (A)","(E) = (C) - (B)",null,null,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(BM27:BQ27)","v":0},{"$f":"BA31","v":0},{"$f":"BA38","v":0},{"$f":"BA43","v":0},{"$f":"BA48","v":0},{"$f":"BA53","v":0},"EXOGENOUS CHANGES in thousands-------------------------","-"]
[750,"    DS-1 SubCat - Special",null,"          N/A","          N/A",null,null,"          N/A","          N/A",null,null,"          N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","Common Line Basket",null,null,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(BM28:BQ28)","v":0},{"$f":"BA32","v":0},{"$f":"BA39","v":0},{"$f":"BA44","v":0},{"$f":"BA49","v":0},{"$f":"BA54","v":0},"   Sale of Exchanges",{"$f":"(AN29+AN32)/1000","v":0}]
[751,"         DS1 Spec Density Zone 1",null,"          N/A","          N/A",null,null,"          N/A","          N/A",null,null,"          N/A",null,null,null,null,600,"GDP-PI","Input",null,null,null,null,null,null,null,100,"End User Common Line",null,{"$f":"SUM(BE30:BE54)","v":0},{"$f":"SUM(BF30:BF54)","v":0},{"$f":"SUM(BG30:BG54)","v":0},{"$f":"AE29-AD29","v":0},0,null,null,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(BM29:BQ29)","v":0},{"$f":"SUM(BM26:BM28)","v":0},{"$f":"SUM(BN26:BN28)","v":0},{"$f":"SUM(BO26:BO28)","v":0},{"$f":"SUM(BP26:BP28)","v":0},{"$f":"SUM(BQ26:BQ28)","v":0},"   Regulatory Fees",{"$f":"(AO29+AO32)/1000","v":0}]
[752,"         DS1 Spec Density Zone 2",null,"          N/A","          N/A",null,null,"          N/A","          N/A",null,null,"          N/A",null,null,null,null,610,"Productivity Factor (X)","col.A:3.0;  col.B:r600, exc. for COSA w/X extension",null,null,null,2,null,null,null,110,"Common Line per MOU",null,{"$f":"SUM(BE63:BE66)","v":0},{"$f":"SUM(BF63:BF66)","v":0},{"$f":"SUM(BG63:BG66)","v":0},0,0,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,102,"Primary Res, Single Line Bus, Lifeline EUCL (1)",null,null,null,null,null,{"$f":"BA30*BB30","v":0},{"$f":"BA30*BC30","v":0},{"$f":"BA30*BD30","v":0},"    N/A","","","",null,null,null,null,null,null,"   Excess Deferred Taxes",{"$f":"(AP29+AP32)/1000","v":0}]
[753,"         DS1 Spec Density Zone 3",null,"          N/A","          N/A",null,null,"          N/A","          N/A",null,null,"          N/A",null,null,null,null,null,null,"",null,null,null,null,null,null,null,112,"PICC Common Line",null,{"$f":"SUM(BE59:BE60)","v":0},{"$f":"SUM(BF59:BF60)","v":0},{"$f":"SUM(BG59:BG60)","v":0},0,0,null,null,null,"","SPECIAL Access Revenue Effect",null,null,null,null,null,null,null,null,null,null,104,"NonPrimary Residence & BRI ISDN EUCL (1)",null,null,null,null,null,{"$f":"BA31*BB31","v":0},{"$f":"BA31*BC31","v":0},{"$f":"BA31*BD31","v":0},"    N/A","","PICC Demand Inputs","",null,null,null,null,null,null,"   ITC",{"$f":"(AQ29+AQ32)/1000","v":0}]
[754,"         DS1 Spec Density Zone 4",null,"          N/A","          N/A",null,null,"          N/A","          N/A",null,null,"          N/A",null,null,null,null,620,"GDP-PI - X","r600-r610",null,null,null,{"$f":"W29-W30","v":-2},null,null,null,115,"Other Common Line",null,{"$f":"BE69","v":0},0,0,0,0,null,null,null,1360,"Revenue Effects",null,null,null,null,null,null,null,null,null,null,106,"Multiline Bus, PRI ISDN, Centrex EUCL (1)",null,null,null,null,null,{"$f":"BA32*BB32","v":0},{"$f":"BA32*BC32","v":0},{"$f":"BA32*BD32","v":0},"    N/A",200,"Total MLB&PRI ISDN (include PRI * 5, & exclude Centrex)","RTE1r155a",{"$f":"BA59","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A","   Removal Sharing/Low End Adj",{"$f":"(AR29+AR32)/1000","v":0}]
[755,"         DS1 Spec Density Zone 5",null,"          N/A","          N/A",null,null,"          N/A","          N/A",null,null,"          N/A",null,null,null,null,"","","",null,null,null,null,null,null,null,118,"USAC Receipts",null,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,108,"Special Access Surcharge",null,null,null,null,null,{"$f":"BA33*BB33","v":0},{"$f":"BA33*BC33","v":0},{"$f":"BA33*BD33","v":0},"    N/A",210,"Total Business Centrex Lines in groups with 9 or more lines","Input or Sum of Jurisdictions",null,"      N/A","      N/A","      N/A","      N/A","      N/A","   TrueUp of Sharing/Low End Adj",{"$f":"(AS29+AS32)/1000","v":0}]
[760,"    DS-3 SubCat - Special",null,"          N/A","          N/A",null,null,"          N/A","          N/A",null,null,"          N/A",null,null,null,null,680,"Existing PCI","Input",null,null,null,null,null,null,null,120,"Total Common Line",null,{"$f":"BE72","v":0},{"$f":"BF72","v":0},{"$f":"BG72","v":0},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,109,"Other EUCL",null,"          N/A","          N/A","          N/A","          N/A",null,null,null,"    N/A",220,"Total Business Groups with less than 9 lines in the group","Input or Sum of Jurisdictions",null,"      N/A","      N/A","      N/A","      N/A","      N/A","   Current Low End Adj",{"$f":"(AT29+AT32)/1000","v":0}]
[761,"         DS3 Spec Density Zone 1",null,"          N/A","          N/A",null,null,"          N/A","          N/A",null,null,"          N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,"   Telecomm.Relay Svcs.",{"$f":"(AU29+AU32)/1000","v":0}]
[762,"         DS3 Spec Density Zone 2",null,"          N/A","          N/A",null,null,"          N/A","          N/A",null,null,"          N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","Zone B:",null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,"   Reg / NonReg",{"$f":"(AV29+AV32)/1000","v":0}]
[763,"         DS3 Spec Density Zone 3",null,"          N/A","          N/A",null,null,"          N/A","          N/A",null,null,"          N/A",null,null,null,null,710,"Delta Z","EXG1,c.S",null,null,null,{"$f":"AW47","v":0},null,null,null,"","Special Access Basket",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,112,"Primary Res, Single Line Bus, Lifeline EUCL (1)",null,null,null,null,null,{"$f":"BA37*BB37","v":0},{"$f":"BA37*BC37","v":0},{"$f":"BA37*BD37","v":0},"    N/A","","MOU Demand Inputs","",null,null,null,null,null,null,"   Other (1) [NANPA]",{"$f":"(AN44+AN47)/1000","v":0}]
[764,"         DS3 Spec Density Zone 4",null,"          N/A","          N/A",null,null,"          N/A","          N/A",null,null,"          N/A",null,null,null,null,720,"R(t-1)","SUM1,c.A",null,null,null,{"$f":"AD42","v":0},null,null,null,300,"VoiceGrade,WATS,Met&Tgh: Special",null,{"$f":"BE98","v":0},{"$f":"BF98","v":0},{"$f":"BG98","v":0},{"$f":"AE38-AD38","v":0},0,null,null,null,null,"DESCRIPTION:","NANPA","TBNP","","","","","","","",null,114,"NonPrimary Residence & BRI ISDN EUCL (1)",null,null,null,null,null,{"$f":"BA38*BB38","v":0},{"$f":"BA38*BC38","v":0},{"$f":"BA38*BD38","v":0},"    N/A",300,"Total Terminating Premium MOU","RTE1r161a",{"$f":"BA63","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A","   Other (2) [TBNP(incl. reversal)]",{"$f":"(AO44+AO47)/1000","v":0}]
[765,"         DS3 Spec Density Zone 5",null,"          N/A","          N/A",null,null,"          N/A","          N/A",null,null,"          N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,310,"Audio & Video",null,{"$f":"BE111","v":0},{"$f":"BF111","v":0},{"$f":"BG111","v":0},0,0,null,null,null,null,null,"","(incl. reversal)","","","","","","","",null,116,"Multiline Bus, PRI ISDN, Centrex EUCL (1)",null,null,null,null,null,{"$f":"BA39*BB39","v":0},{"$f":"BA39*BC39","v":0},{"$f":"BA39*BD39","v":0},"    N/A",310,"Total Terminating Non-Premium MOU","RTE1r163a",{"$f":"BA64","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A","   Other (3)",{"$f":"(AP44+AP47)/1000","v":0}]
[790,"Wideband",null,"          N/A","          N/A",null,null,"          N/A","          N/A",null,null,"          N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,320,"High Caps & DDS: Special",null,{"$f":"BE337","v":0},{"$f":"BF337","v":0},{"$f":"BG337","v":0},0,0,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":"BL38+0.45*BL39","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A","   Other (4)",{"$f":"(AQ44+AQ47)/1000","v":0}]
[899,"Total Special Access",null,null,null,"          N/A","          N/A",null,null,"          N/A","          N/A",null,"          N/A",null,null,null,740,"Delta Z/R","r710/r720*100",null,null,null,{"$f":"IF(W38=0,0,W37/W38*100)","v":0},null,null,null,330,"Wideband",null,{"$f":"BE350","v":0},{"$f":"BF350","v":0},{"$f":"BG350","v":0},0,0,null,null,null,null,null,"-","-","-","-","-","-","-","-","-","-","","Zone C:",null,null,null,null,null,null,null,null,null,330,"Total Originating Premium MOU","RTE1r165a",{"$f":"BA65","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A","   Other (5)",{"$f":"(AR44+AR47)/1000","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,750,"W","100+r740",null,null,null,{"$f":"IF(W38=0,0,100+W41)","v":0},null,null,null,340,"Total Special Access",null,{"$f":"BE358","v":0},{"$f":"BF358","v":0},{"$f":"BG358","v":0},0,0,null,null,null,null,null,"(J)","(K)","(L)","(M)","(N)","(O)","(P)","(Q)","(R)","(S)",122,"Primary Res, Single Line Bus, Lifeline EUCL (1)",null,null,null,null,null,{"$f":"BA42*BB42","v":0},{"$f":"BA42*BC42","v":0},{"$f":"BA42*BD42","v":0},"    N/A",340,"Total Originating Non-Premium MOU","RTE1r167a",{"$f":"BA66","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A","   Other (6)",{"$f":"(AS44+AS47)/1000","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,760,"W*(GDP-PI - X)","r750*r620/100",null,null,null,{"$f":"(W42*W32)/100","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COMMON LINE  Revenue Effect",null,null,null,null,null,null,null,null,null,null,124,"NonPrimary Residence & BRI ISDN EUCL (1)",null,null,null,null,null,{"$f":"BA43*BB43","v":0},{"$f":"BA43*BC43","v":0},{"$f":"BA43*BD43","v":0},"    N/A",350,"Total Originating Chargeable MOU","r330+.45*r340",{"$f":"BL41+0.45*BL42","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A","   Other (7)",{"$f":"(AT44+AT47)/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,160,"Revenue Effects",null,null,null,null,null,null,null,null,null,null,126,"Multiline Bus, PRI ISDN, Centrex EUCL (1)",null,null,null,null,null,{"$f":"BA44*BB44","v":0},{"$f":"BA44*BC44","v":0},{"$f":"BA44*BD44","v":0},"    N/A","","","",null,null,null,null,null,null,"   Other (8)",{"$f":"(AU44+AU47)/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,400,"Total",null,{"$f":"AD34+AD42","v":0},{"$f":"AE34+AE42","v":0},{"$f":"AF34+AF42","v":0},{"$f":"AE45-AD45","v":0},{"$f":"AF45-AE45","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":"(AV44+AV47)/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,"","SPECIAL Access Revenue Effect",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1360,"Revenue Effects",null,null,null,null,null,null,null,null,null,null,132,"Primary Res, Single Line Bus, Lifeline EUCL (1)",null,null,null,null,null,{"$f":"BA47*BB47","v":0},{"$f":"BA47*BC47","v":0},{"$f":"BA47*BD47","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(BS28:BS45)","v":0},{"$f":"(SUM(AN32:AV32)+SUM(AN47:AV47))/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,134,"NonPrimary Residence & BRI ISDN EUCL (1)",null,null,null,null,null,{"$f":"BA48*BB48","v":0},{"$f":"BA48*BC48","v":0},{"$f":"BA48*BD48","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":"(AW$44+AW$47)/1000","v":0},{"$f":"AW47/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,136,"Multiline Bus, PRI ISDN, Centrex EUCL (1)",null,null,null,null,null,{"$f":"BA49*BB49","v":0},{"$f":"BA49*BC49","v":0},{"$f":"BA49*BD49","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(AO85)+N(AO104))/1000","v":0},{"$f":"AO104/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,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,142,"Primary Res, Single Line Bus, Lifeline EUCL (1)",null,null,null,null,null,{"$f":"BA52*BB52","v":0},{"$f":"BA52*BC52","v":0},{"$f":"BA52*BD52","v":0},"    N/A",440,"Current MaxCMT Rev per Line (from previous filing)","Input (r460 from prev filing) or Wtd Avg of Juris",null,"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,144,"NonPrimary Residence & BRI ISDN EUCL (1)",null,null,null,null,null,{"$f":"BA53*BB53","v":0},{"$f":"BA53*BC53","v":0},{"$f":"BA53*BD53","v":0},"    N/A","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,970,"Prop. PCI (NonExog Only: Annual Filing","col.B: r680*(1+r620/100)",null,null,null,{"$f":"W34*(1+W32/100)","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,146,"Multiline Bus, PRI ISDN, Centrex EUCL (1)",null,null,null,null,null,{"$f":"BA54*BB54","v":0},{"$f":"BA54*BC54","v":0},{"$f":"BA54*BD54","v":0},"    N/A","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","       SBI Upper Limit calculations only)","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,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,"Proposed PCI","col.A&B: r680*(1+r760/100+r740/100)",null,null,null,{"$f":"IF(AND(W34=0,BG358<>0),0,+W34*(1+W43/100+W41/100))","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,"","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(BL29=0,BL52=0),0,((AW44/BL29)/BL52)+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,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"BL52*BL56","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,155,"Multiline Business & PRI ISDN PICC           (1)",null,null,null,null,null,{"$f":"BA59*BB59","v":0},{"$f":"BA59*BC59","v":0},{"$f":"BA59*BD59","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,157,"Business Centrex PICC",null,null,"          N/A","          N/A","          N/A",null,null,null,"    N/A","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,161,"Terminating CCL Prem.",null,null,null,null,null,{"$f":"BA63*BB63","v":0},{"$f":"BA63*BC63","v":0},{"$f":"BA63*BD63","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,163,"Terminating CCL Non-Prem.",null,null,null,null,null,{"$f":"BA64*BB64","v":0},{"$f":"BA64*BC64","v":0},{"$f":"BA64*BD64","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,165,"Originating CCL Prem.",null,null,null,null,null,{"$f":"BA65*BB65","v":0},{"$f":"BA65*BC65","v":0},{"$f":"BA65*BD65","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,167,"Originating CCL Non-Prem.",null,null,null,null,null,{"$f":"BA66*BB66","v":0},{"$f":"BA66*BC66","v":0},{"$f":"BA66*BD66","v":0},"    N/A","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTES:","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","(1) Display indexes and factors as percent to four decimal places (e.g., display 100% as 100.000).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,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 revenues as 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,180,"Other Common Line",null,"          N/A","          N/A","          N/A","          N/A",null,null,null,"    N/A","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,185,"USAC Receipts",null,null,null,null,null,{"$f":"BA70*BB70","v":0},{"$f":"BA70*BC70","v":0},{"$f":"BA70*BD70","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,"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,null,null,"","Per Minute Revenues",null,null,null,null,null,{"$f":"SUM(BE63:BE66)","v":0},{"$f":"SUM(BF63:BF66)","v":0},{"$f":"SUM(BG63:BG66)","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,190,"Total Basket",null,"          N/A","          N/A","          N/A","          N/A",{"$f":"SUM(BE30:BE54)+BE59+BE60+SUM(BE62:BE66)+BE69+BE70","v":0},{"$f":"SUM(BF30:BF54)+BF59+BF60+SUM(BF62:BF66)+BF69+BF70","v":0},{"$f":"SUM(BG30:BG54)+BG59+BG60+SUM(BG62:BG66)+BG69+BG70","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,"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,null,null,null,null,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,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,"RTE-1",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,null,null,null,null,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/2023"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Filing Date:                \"&DATE","v":"Filing Date:                06/16/2023"},null,null,null,null,null,null,null,null,null,null,{"$f":"\"Filing Date:                \"&DATE","v":"Filing Date:                06/16/2023"},null,null,null,null,null,null,null,null,{"$f":"\"Filing Date:                \"&$D$1","v":"Filing Date:                06/16/2023"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,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,{"$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:               "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,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,{"$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,null,{"$f":"\"Transmittal Number:   \"&$D$3","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,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}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,"Special Access Net Exogenous Cost Shifts",null,null,null,null,null,null,"Page 2 of 6",null,null,null,null,"Price Caps Tariff Review Plan",null,null,null,null,null,"Page 2 of 2",null,"Price Cap Tariff Review Plan",null,null,null,null,null,null,"Page 2 of 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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Special Access Basket",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,"BASE","RATES AT",null,null,"DEMAND x","DEMAND x","DEMAND x",null,"",null,"Source","(a)","(b)","(c)","(d)","(e)","(f)","Deaveraging Checks (from CAP3):"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Total Common Line",null,{"$f":"IF(AW44=0,0,AW44)","v":0},null,null,{"$f":"AW44","v":0},null,null,null,null,null,null,null,null,"PERIOD",{"$f":"MONTH($M$3) & \"/\"& DAY($M$3) & \"/\" & RIGHT(YEAR($M$3),2) & \" PCI\"","v":"10/1/22 PCI"},"CURRENT","PROPOSED",{"$f":"\"RATES AT \" & MONTH($M$3) & \"/\"& DAY($M$3) & \"/\" & RIGHT(YEAR($M$3),2)","v":"RATES AT 10/1/22"},"CURRENT","PROPOSED","INDEX ","","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,null,null,null,null,null,"","Special Access Basket",null,null,null,null,null,null,null,null,null,null,null,null,null,"DEMAND","UPDATE","RATES","RATES","PCI UPDATE","RATES","RATES","RESULTS",600,"Proposed Maximum CMT Revenue","r460 * r130 or Sum of Jurisdictions",{"$f":"BL58*BL29","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A","     Primary Res, SLB, & LifeLine",{"$f":"IF(BL206=\"      N/A\",\"N/A\",IF(AND(BN29<>0,BN242<BM242),\"FAIL\",IF(AND(BO29<>0,BO242<BN242),\"FAIL\",IF(AND(BP29<>0,BP242<BO242),\"FAIL\",IF(AND(BQ29<>0,BQ242<BP242),\"FAIL\",\"PASS\")))))","v":"PASS"},{"$f":"IF(BL206=\"      N/A\",\"No Deaveraging Allowed\",IF(AND(BN29<>0,BN242<BM242),\"Prim Res Zone B < Zone A\",IF(AND(BO29<>0,BO242<BN242),\"Prim Res Zone C < Zone B\",IF(AND(BP29<>0,BP242<BO242),\"Prim Res Zone D < Zone C\",IF(AND(BQ29<>0,BQ242<BP242),\"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,null,null,null,null,null,700,"VG,MT,TGH SP (undesignated)",null,0,null,null,"          N/A",null,null,null,null,null,null,null,null,"-","-","-","-","-","-","-","-",610,"Maximum Allowable PR, Lifeline & SLB EU Revenue","r400 * r100 or Sum of Jurisdictions",{"$f":"BL46*BL26","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A","     NonPrimary Res & BRI ISDN",{"$f":"IF(BL206=\"      N/A\",\"N/A\",IF(AND(BN29<>0,BN243<BM243),\"FAIL\",IF(AND(BO29<>0,BO243<BN243),\"FAIL\",IF(AND(BP29<>0,BP243<BO243),\"FAIL\",IF(AND(BQ29<>0,BQ243<BP243),\"FAIL\",\"PASS\")))))","v":"PASS"},{"$f":"IF(BL206=\"      N/A\",\"No Deaveraging Allowed\",IF(AND(BN29<>0,BN243<BM243),\"Non Prim Zone B < Zone A\",IF(AND(BO29<>0,BO243<BN243),\"Non Prim Zone C < Zone B\",IF(AND(BP29<>0,BP243<BO243),\"Non Prim Zone D < Zone C\",IF(AND(BQ29<>0,BQ243<BP243),\"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,null,null,null,null,null,710,"Audio & Video (undesignated)",null,0,null,null,"          N/A",null,null,null,null,null,null,null,null,"(A)","(B)","(C)","(D)","(E)","(F)","(G)","(H)",620,"Maximum Allowable NonPrimary Res & BRI EU Revenue","r410 * r110 or Sum of Jurisdictions",{"$f":"BL47*BL27","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A","     MLB, PRI ISDN, & Centrex",{"$f":"IF(BL206=\"      N/A\",\"N/A\",IF(AND(BN29<>0,BN244<BM244),\"FAIL\",IF(AND(BO29<>0,BO244<BN244),\"FAIL\",IF(AND(BP29<>0,BP244<BO244),\"FAIL\",IF(AND(BQ29<>0,BQ244<BP244),\"FAIL\",\"PASS\")))))","v":"PASS"},{"$f":"IF(BL206=\"      N/A\",\"No Deaveraging Allowed\",IF(AND(BN29<>0,BN244<BM244),\"MLB Zone B < Zone A\",IF(AND(BO29<>0,BO244<BN244),\"MLB Zone C < Zone B\",IF(AND(BP29<>0,BP244<BO244),\"MLB Zone D < Zone C\",IF(AND(BQ29<>0,BQ244<BP244),\"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,null,null,null,null,null,720,"High Cap & DDS SP (undesignated)",null,0,null,null,"          N/A",null,null,null,null,null,null,"Voice Grade,  Metallic, & Telegraph",null,null,null,null,null,null,null,null,null,630,"Maximum Allowable MLB, PRI & Centrex EU Revenue","r420 * r120 or Sum of Jurisdictions",{"$f":"BL48*BL28","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,730,"    DS-1 SubCat SP (undesignated)",null,0,null,null,"          N/A",null,null,null,null,null,null,"Service Category - Special",null,null,null,null,null,null,null,null,null,640,"Total Maximum Allowable EU Revenue","r610 + r620 + r630",{"$f":"SUM(BL87:BL89)","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,null,null,null,null,null,731,"         DS1 Spec Density Zone 1",null,0,null,null,"          N/A",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":"BL86-BL90","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A","     Primary Res, SLB, & LifeLine",{"$f":"IF(AND(OR(BL130=\"CAP1\",BL130=\"CAP2\"),AND(BL206<>0,ISNUMBER(BL206)=TRUE)),\"FAIL\",IF(AND(BM29<>0,BM242<BL231),\"FAIL\",IF(AND(BN29<>0,BN242<BL231),\"FAIL\",IF(AND(BO29<>0,BO242<BL231),\"FAIL\",IF(AND(BP29<>0,BP242<BL231),\"FAIL\",IF(AND(BQ29<>0,BQ242<BL231),\"FAIL\",\"PASS\"))))))","v":"PASS"},{"$f":"IF(AND(BM29<>0,BM242<BL231),\"Prim Res Zone A < Min\",IF(BL206=\"no\",\"Avg'd Prim Rate above Min\",IF(AND(BN29<>0,BN242<BL231),\"Prim Res Zone B < Min\",IF(AND(BO29<>0,BO242<BL231),\"Prim Res Zone C < Min\",IF(AND(BP29<>0,BP242<BL231),\"Prim Res Zone D < Min\",IF(AND(BQ29<>0,BQ242<BL231),\"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,null,null,null,null,null,732,"         DS1 Spec Density Zone 2",null,0,null,null,"          N/A",null,null,null,null,null,"","Non-Density Zone",null,null,null,null,null,null,null,null,null,652,"Maximum Allowable PICC Revenue","r430*( r200+r210/9+r220 ) or Sum of Jurisdictns",{"$f":"BL49*(BL32+BL33/9+BL34)","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A","     NonPrimary Res & BRI ISDN",{"$f":"IF(AND(OR(BL130=\"CAP1\",BL130=\"CAP2\"),AND(BL206<>0,ISNUMBER(BL206)=TRUE)),\"FAIL\",IF(AND(BM29<>0,BM243<BL234),\"FAIL\",IF(AND(BN29<>0,BN243<BL234),\"FAIL\",IF(AND(BO29<>0,BO243<BL234),\"FAIL\",IF(AND(BP29<>0,BP243<BL234),\"FAIL\",IF(AND(BQ29<>0,BQ243<BL234),\"FAIL\",\"PASS\"))))))","v":"PASS"},{"$f":"IF(AND(BM29<>0,BM243<BL234),\"Non Prim Zone A < Min\",IF(BL206=\"no\",\"Avg'd Non Prim Rates above Min\",IF(AND(BN29<>0,BN243<BL234),\"Non Prim Zone B < Min\",IF(AND(BO29<>0,BO243<BL234),\"Non Prim Zone C < Min\",IF(AND(BP29<>0,BP243<BL234),\"Non Prim Zone D < Min\",IF(AND(BQ29<>0,BQ243<BL234),\"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,null,null,null,null,null,733,"         DS1 Spec Density Zone 3",null,0,null,null,"          N/A",null,null,null,null,null,4141,"VG,Met,Tgh SP NonDZ ChanTerm",null,null,"          N/A","          N/A","          N/A",null,null,null,"    N/A",660,"Total USAC Receipts (at t)","RTE1r185f or Sum of Jurisdictns",{"$f":"BG70","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A","     MLB, PRI ISDN, & Centrex",{"$f":"IF(AND(OR(BL130=\"CAP1\",BL130=\"CAP2\"),AND(BL206<>0,ISNUMBER(BL206)=TRUE)),\"FAIL\",IF(AND(BM29<>0,BM244<BL237),\"FAIL\",IF(AND(BN29<>0,BN244<BL237),\"FAIL\",IF(AND(BO29<>0,BO244<BL237),\"FAIL\",IF(AND(BP29<>0,BP244<BL237),\"FAIL\",IF(AND(BQ29<>0,BQ244<BL237),\"FAIL\",\"PASS\"))))))","v":"PASS"},{"$f":"IF(AND(BM29<>0,BM244<BL237),\"MLB Zone A < Min\",IF(BL206=\"no\",\"Avg'd MLB Rates above Min\",IF(AND(BN29<>0,BN244<BL237),\"MLB Zone B < Min\",IF(AND(BO29<>0,BO244<BL237),\"MLB Zone C < Min\",IF(AND(BP29<>0,BP244<BL237),\"MLB Zone D < Min\",IF(AND(BQ29<>0,BQ244<BL237),\"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,734,"         DS1 Spec Density Zone 4",null,0,null,null,"          N/A",null,null,null,null,null,4144,"VG,Met,Tgh SP NonDZ Other",null,"          N/A","          N/A","          N/A","          N/A",null,null,null,"    N/A","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,735,"         DS1 Spec Density Zone 5",null,0,null,null,"          N/A",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,740,"    DS-3 SubCat SP (undesignated)",null,0,null,null,"          N/A",null,null,null,null,null,4148,"Total VG,Met,Tgh SP NonZone",null,"          N/A","          N/A","          N/A","          N/A",{"$f":"SUM(BE93:BE94)","v":0},{"$f":"SUM(BF93:BF94)","v":0},{"$f":"SUM(BG93:BG94)","v":0},"    N/A","","","",null,null,null,null,null,null,"     Primary Res, SLB, & LifeLine",{"$f":"IF(AND(OR(BL130=\"CAP1\",BL130=\"CAP2\"),AND(BL206<>0,ISNUMBER(BL206)=TRUE)),\"FAIL\",IF(AND(BM29<>0,BM242>BL232),\"FAIL\",IF(AND(BN29<>0,BN242>BL232),\"FAIL\",IF(AND(BO29<>0,BO242>BL232),\"FAIL\",IF(AND(BP29<>0,BP242>BL232),\"FAIL\",IF(AND(BQ29<>0,BQ242>BL232),\"FAIL\",\"PASS\"))))))","v":"PASS"},{"$f":"IF(AND(BM29<>0,BM242>BL232),\"Prim Res Zone A > Max\",IF(BL206=\"no\",\"Avg'd Prim Rate below Max\",IF(AND(BN29<>0,BN242>BL232),\"Prim Res Zone B > Max\",IF(AND(BO29<>0,BO242>BL232),\"Prim Res Zone C > Max\",IF(AND(BP29<>0,BP242>BL232),\"Prim Res Zone D > Max\",IF(AND(BQ29<>0,BQ242>BL232),\"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,741,"         DS3 Spec Density Zone 1",null,0,null,null,"          N/A",null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,"     NonPrimary Res & BRI ISDN",{"$f":"IF(AND(OR(BL130=\"CAP1\",BL130=\"CAP2\"),AND(BL206<>0,ISNUMBER(BL206)=TRUE)),\"FAIL\",IF(AND(BM29<>0,BM243>BL235),\"FAIL\",IF(AND(BN29<>0,BN243>BL235),\"FAIL\",IF(AND(BO29<>0,BO243>BL235),\"FAIL\",IF(AND(BP29<>0,BP243>BL235),\"FAIL\",IF(AND(BQ29<>0,BQ243>BL235),\"FAIL\",\"PASS\"))))))","v":"PASS"},{"$f":"IF(AND(BM29<>0,BM243>BL235),\"Non Prim Zone A > Max\",IF(BL206=\"no\",\"Avg'd Non Prim Rates below Max\",IF(AND(BN29<>0,BN243>BL235),\"Non Prim Zone B > Max\",IF(AND(BO29<>0,BO243>BL235),\"Non Prim Zone C > Max\",IF(AND(BP29<>0,BP243>BL235),\"Non Prim Zone D > Max\",IF(AND(BQ29<>0,BQ243>BL235),\"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,742,"         DS3 Spec Density Zone 2",null,0,null,null,"          N/A",null,null,null,null,null,4197,"Total VG/Met/Tgh SP Service Category",null,"          N/A","          N/A","          N/A","          N/A",{"$f":"BE96","v":0},{"$f":"BF96","v":0},{"$f":"BG96","v":0},"    N/A","","","",null,null,null,null,null,null,"     MLB, PRI ISDN, & Centrex",{"$f":"IF(AND(OR(BL130=\"CAP1\",BL130=\"CAP2\"),AND(BL206<>0,ISNUMBER(BL206)=TRUE)),\"FAIL\",IF(AND(BM29<>0,BM244>BL238),\"FAIL\",IF(AND(BN29<>0,BN244>BL238),\"FAIL\",IF(AND(BO29<>0,BO244>BL238),\"FAIL\",IF(AND(BP29<>0,BP244>BL238),\"FAIL\",IF(AND(BQ29<>0,BQ244>BL238),\"FAIL\",\"PASS\"))))))","v":"PASS"},{"$f":"IF(AND(BM29<>0,BM244>BL238),\"MLB Zone A > Max\",IF(BL206=\"no\",\"Avg'd MLB Rates below Max\",IF(AND(BN29<>0,BN244>BL238),\"MLB Zone B > Max\",IF(AND(BO29<>0,BO244>BL238),\"MLB Zone C > Max\",IF(AND(BP29<>0,BP244>BL238),\"MLB Zone D > Max\",IF(AND(BQ29<>0,BQ244>BL238),\"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,null,null,null,null,null,743,"         DS3 Spec Density Zone 3",null,0,null,null,"          N/A",null,null,null,null,null,4198,"VG/Met/Tgh SP SBI",null,"          N/A","          N/A","          N/A","          N/A","          N/A","          N/A","          N/A",{"$f":"IF(AND(J25=0,BG98<>0),F25,IF(BF98=0,J25,J25*BG98/BF98))","v":0},680,"Remaining Recoverable Revenue/(Total over-recovery)","r650-r660 or Sum of Jurisdictns",{"$f":"ROUND(BL91-BL93,2)","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,744,"         DS3 Spec Density Zone 4",null,0,null,null,"          N/A",null,null,null,null,null,4199,"VG/Met/Tgh SP Upper SBI Limit",null,"          N/A","          N/A","          N/A","          N/A","          N/A","          N/A","          N/A",{"$f":"IF(AND(J25=0,BG98<>0),105,IF(L41=0,0,IF(BE98=0,M25*$W$54/L41*1.05,M25*$W$54/L41*1.05*(1+(SUM($AO$87:$AO$87)+BE98*IF(BE358=0,0,AO103/BE358))/BE98))))","v":0},"","","",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,745,"         DS3 Spec Density Zone 5",null,0,null,null,"          N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,"     Zone A",{"$f":"IF(BM$243<BM$242,\"FAIL\",IF(BM$244<BM$243,\"FAIL\",\"PASS\"))","v":"PASS"},{"$f":"IF(BM$243<BM$242,\"Zone A Non Prim < Prim\",IF(BM$244<BM$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,null,null,null,null,null,760,"Wideband (undesignated)",null,0,null,null,"          N/A",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(BL206=\"no\",\"N/A\",IF(BN$243<BN$242,\"FAIL\",IF(BN$244<BN$243,\"FAIL\",\"PASS\")))","v":"PASS"},{"$f":"IF(BL206=\"no\",\"No Deaveraging Allowed\",IF(BN$243<BN$242,\"Zone B Non Prim < Prim\",IF(BN$244<BN$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,null,null,null,null,null,770,"SP Undesignated to Svc Bands",null,0,null,null,"          N/A",null,null,null,null,null,"","Audio & Video Service Category",null,null,null,null,null,null,null,null,null,800,"MLB, PRI & Centrex PICC Rate (Dec. 29, 2011)","r430",{"$f":"BL49","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A","     Zone C",{"$f":"IF(BL206=\"no\",\"N/A\",IF(BO$243<BO$242,\"FAIL\",IF(BO$244<BO$243,\"FAIL\",\"PASS\")))","v":"PASS"},{"$f":"IF(BL206=\"no\",\"No Deaveraging Allowed\",IF(BO$243<BO$242,\"Zone C Non Prim < Prim\",IF(BO$244<BO$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,null,null,null,null,null,780,"Total Special Access",null,{"$f":"SUM(AO87:AO103)","v":0},null,null,{"$f":"AW47","v":0},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(BL99>0,BL99,0)","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A","     Zone D",{"$f":"IF(BL206=\"no\",\"N/A\",IF(BP$243<BP$242,\"FAIL\",IF(BP$244<BP$243,\"FAIL\",\"PASS\")))","v":"PASS"},{"$f":"IF(BL206=\"no\",\"No Deaveraging Allowed\",IF(BP$243<BP$242,\"Zone D Non Prim < Prim\",IF(BP$244<BP$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","Non-Zone Audio & Video",null,null,null,null,null,null,null,null,null,820,"MLB, PRI & Centrex PICC Target Rate","r810 / (r200 + r210/9 + r220)",{"$f":"IF((BL32+BL33+BL34)<>0,+BL104/(BL32+BL33/9+BL34),0)","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A","     Other Zone",{"$f":"IF(BL206=\"no\",\"N/A\",IF(BQ$243<BQ$242,\"FAIL\",IF(BQ$244<BQ$243,\"FAIL\",\"PASS\")))","v":"PASS"},{"$f":"IF(BL206=\"no\",\"No Deaveraging Allowed\",IF(BQ$243<BQ$242,\"Other Zone Non Prim < Prim\",IF(BQ$244<BQ$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4361,"Audio/Video NonDZ Channel Term",null,null,"          N/A","          N/A","          N/A",null,null,null,"    N/A",830,"Maximum Average MLB, PRI & Centrex PICC Rate","Min(r800,r820)",{"$f":"MIN(BL103,BL105)","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,4364,"Audio/Video NonDZ Other",null,"          N/A","          N/A","          N/A","          N/A",null,null,null,"    N/A",840,"Maximum MLB & PRI PICC Revenue","r830 * r200, or Sum of Jurisdictions",{"$f":"BL106*BL32","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,null,null,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":"BL106*(BL33/9+BL34)","v":0},"      N/A","      N/A","      N/A","      N/A","      N/A","     CMT Revenue Too High?",null,{"$f":"IF(TRUNC(BL356,0)>TRUNC(BL330,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4368,"Total Audio/Video NonZone",null,"          N/A","          N/A","          N/A","          N/A",{"$f":"SUM(BE106:BE107)","v":0},{"$f":"SUM(BF106:BF107)","v":0},{"$f":"SUM(BG106:BG107)","v":0},"    N/A",860,"Total Maximum PICC Revenue (Proposed)","r840 + r850",{"$f":"BL107+BL108","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4397,"Total Audio/Video Service Category",null,"          N/A","          N/A","          N/A","          N/A",{"$f":"BE109","v":0},{"$f":"BF109","v":0},{"$f":"BG109","v":0},"    N/A","","Calculation of CCL Rates and Revenue",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4398,"Audio/Video SBI",null,"          N/A","          N/A","          N/A","          N/A","          N/A","          N/A","          N/A",{"$f":"IF(AND(J26=0,BG111<>0),F26,IF(BF111=0,J26,+J26*BG111/BF111))","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,4399,"Audio/Video Upper SBI Limit",null,"          N/A","          N/A","          N/A","          N/A","          N/A","          N/A","          N/A",{"$f":"IF(AND(J26=0,BG111<>0),105,IF(L41=0,0,IF(BE111=0,M26*$W$54/L41*1.05,M26*$W$54/L41*1.05*(1+(SUM($AO$88:$AO$88)+BE111*IF(BE358=0,0,AO103/BE358))/BE111))))","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,940,"Prem. Originating MOU Rate as of Dec. 29, 2011","Input or Weighted Avg of Jurisdictns",null,"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,945,"Prem. Terminating MOU Rate as of Dec. 29, 2011","Input or Weighted Avg of Jurisdictns",null,"      N/A","      N/A","      N/A","      N/A","      N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"BL104-BL109","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,960,"Maximum CCL Originating Rate","Min(r940, r950/r350)",{"$f":"MIN(BL116,IF(BL43=0,0,BL118/BL43))","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,970,"Maximum CCL Terminating Rate","Min(r945,(r950 - (r350*r960))/r320)",{"$f":"MIN(BL117,IF(BL40=0,0,(BL118-(BL43*BL119))/BL40))","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"BL119*BL43","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,990,"Maximum Terminating CCL Revenue","r970 * r320, or Sum of Jurisdictions",{"$f":"BL120*BL40","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,995,"Total Maximum CCL Revenue","r980 + r990",{"$f":"BL122+BL123","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,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(BL99>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,null,null,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","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,null,null,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,null,null,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(BL99>0,\"CAP1\",IF(BL129=\"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,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,1140,"Max. Allowable PR, Lifeline & SLB EU Revenue","if Juris rates,sum of Juris;if 1130=CAP1,r610;else1130",{"$f":"IF(BL130=\"cap1\",BL87,BL130)","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,1150,"Max. Allowable NonPrimary Res & BRI EU Revenue","if Juris rates,sum of Juris;if 1130 =CAP1,r620;else1130",{"$f":"IF(BL130=\"cap1\",BL88,BL130)","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,1160,"Max. Allowable MLB, PRI & Centrex EU Revenue","if Juris rates,sum of Juris;if 1130=CAP1,r630;else1130",{"$f":"IF(BL130=\"cap1\",BL89,BL130)","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,"RTE-1",null,null,null,null,null,null,null,null,null,null,"CAP-2",null,null,null,null,null,null,null,null,"ANALYZER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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/2023"},null,null,null,null,null,null,null,null,null,null,{"$f":"\"Filing Date:                \"&DATE","v":"Filing Date:                06/16/2023"},null,null,null,null,null,null,null,null,{"$f":"\"Filing Date:                \"&DATE","v":"Filing Date:                06/16/2023"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,{"$f":"NAME","v":0},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 3 of 6",null,null,null,null,"Price Caps Tariff Review Plan",null,null,null,null,null,"Page 1 of 1",null,"Price Cap Tariff Review Plan",null,null,null,null,null,null,"Page 3 of 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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Special Access Basket",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IND-1","RTE-1","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BASE PERIOD","BASE PERIOD","BASE PERIOD",null,null,null,null,"Total Jurisdiction",null,null,null,null,null,"SPECIAL ACCESS--------------------------------------","-","-","-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BASE","RATES AT",null,null,"DEMAND x","DEMAND x","DEMAND x",null,"",null,"Source","(a)",null,null,null,null,null," VG, MT, TG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PERIOD",{"$f":"MONTH($M$3) & \"/\"& DAY($M$3) & \"/\" & RIGHT(YEAR($M$3),2) & \" PCI\"","v":"10/1/22 PCI"},"CURRENT","PROPOSED",{"$f":"\"RATES AT \" & MONTH($M$3) & \"/\"& DAY($M$3) & \"/\" & RIGHT(YEAR($M$3),2)","v":"RATES AT 10/1/22"},"CURRENT","PROPOSED","INDEX ","","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,"         Proposed Sub-Index",{"$f":"F25","v":0},{"$f":"BH99","v":0},{"$f":"ROUND(N(BS145)-N(BT145),4)","v":0},{"$f":"IF(BU145>0,\"     HIGH\",IF(BU145<0,\"      LOW\",\"       *\"))","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,"DEMAND","UPDATE","RATES","RATES","PCI UPDATE","RATES","RATES","RESULTS",100,"Maximum CMT Revenue","CAP1r600 or Sum of CAP2-priced Jurisdictns",{"$f":"IF(BL130=\"cap2\",BL86,BL130)","v":0},null,null,null,null,null,"         Sub-Index Upper Limit",{"$f":"G25","v":0},{"$f":"BH100","v":0},{"$f":"ROUND(N(BS146)-N(BT146),4)","v":0},{"$f":"IF(BU146>0,\"     HIGH\",IF(BU146<0,\"      LOW\",\"       *\"))","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,"-","-","-","-","-","-","-","-",110,"Total USAC Receipts (at t)","CAP1r660 or Sum of CAP2-priced Jurisdictns",{"$f":"IF(BL130=\"cap2\",BL93,BL130)","v":0},null,null,null,null,null,"         IND-1 Sub-Index Out of Bounds?",null,null,null,{"$f":"IF(TRUNC(BS145,4)>TRUNC(BS146,4),\"     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,"(A)","(B)","(C)","(D)","(E)","(F)","(G)","(H)","","","",null,null,null,null,null,null,"         RTE-1 Sub-Index Out of Bounds?",null,null,null,{"$f":"IF(TRUNC(N(BT145),4)>TRUNC(N(BT146),4),\"     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,"High Cap & DDS Service Category - Special",null,null,null,null,null,null,null,null,null,130,"Maximum Recoverable Revenue","r100 - r110",{"$f":"IF(BL130=\"CAP2\",BL146-BL147,BL130)","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,null," Audio & Video"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","DS1,  Special Access Density Zone 1:",null,null,null,null,null,null,null,null,null,"","Maximum Allowable EU Rates","",null,null,null,null,null,null,"         Proposed Sub-Index",{"$f":"F26","v":0},{"$f":"BH112","v":0},{"$f":"ROUND(N(BS151)-N(BT151),4)","v":0},{"$f":"IF(BU151>0,\"     HIGH\",IF(BU151<0,\"      LOW\",\"       *\"))","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,4401,"DS1 Spec DZ1 ChanTerm",null,null,"          N/A","          N/A","          N/A",null,null,null,"    N/A",200,"Max. Allowable Primary Res, Lifeline, & SLB EU Rate","CAP1r400 if CAP1r1130=CAP2",{"$f":"IF(BL130=\"cap2\",BL46,BL130)","v":0},null,null,null,null,null,"         Sub-Index Upper Limit",{"$f":"G26","v":0},{"$f":"BH113","v":0},{"$f":"ROUND(N(BS152)-N(BT152),4)","v":0},{"$f":"IF(BU152>0,\"     HIGH\",IF(BU152<0,\"      LOW\",\"       *\"))","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,4404,"DS1 Spec DZ1 Other",null,"          N/A","          N/A","          N/A","          N/A",null,null,null,"    N/A",210,"Max. Allowable NonPrimary Res & BRI ISDN EU Rate","CAP1r410 if CAP1r1130=CAP2",{"$f":"IF(BL130=\"cap2\",BL47,BL130)","v":0},null,null,null,null,null,"         IND-1 Sub-Index Out of Bounds?",null,null,null,{"$f":"IF(TRUNC(BS151,4)>TRUNC(BS152,4),\"     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,220,"Max. Allowable MLB, PRI ISDN, & Centrex EU Rate","CAP1r420 if CAP1r1130=CAP2",{"$f":"IF(BL130=\"cap2\",BL48,BL130)","v":0},null,null,null,null,null,"         RTE-1 Sub-Index Out of Bounds?",null,null,null,{"$f":"IF(TRUNC(N(BT151),4)>TRUNC(N(BT152),4),\"     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,4417,"Total DS1 Spec DZ1 Sub-Category",null,"          N/A","          N/A","          N/A","          N/A",{"$f":"SUM(BE152:BE153)","v":0},{"$f":"SUM(BF152:BF153)","v":0},{"$f":"SUM(BG152:BG153)","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,4418,"DS1 Spec DZ1 Subindex",null,"          N/A","          N/A","          N/A","          N/A","          N/A","          N/A","          N/A",{"$f":"IF(AND(J29=0,BG155<>0),F29,IF(BF155=0,J29,J29*BG155/BF155))","v":0},"","Final EU Rates (Manually Input)","",null,null,null,null,null,null," HiCap"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4419,"DS1 Spec DZ1 Upper Limit",null,"          N/A","          N/A","          N/A","          N/A","          N/A","          N/A","          N/A",{"$f":"IF(AND(J29=0,BG155<>0),115,IF(L41=0,0,IF(BE155=0,M29*$W$54/L41*1.15,M29*$W$54/L41*1.15*(1+($AO$91+BE155*(IF(BE337=0,0,AO89/BE337)+IF(BE217=0,0,AO90/BE217)+IF(BE358=0,0,AO103/BE358)))/BE155))))","v":0},400,"Final Primary Res, Lifeline, & SLB EU Rate","Input ",null,{"$f":"IF(BL157>BL152,\"     Error:  Exceeded maximum allowable rate\",\"     ok\")","v":"     ok"},null,null,null,null,"      DS1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(BL158>BL153,\"     Error:  Exceeded maximum allowable rate\",\"     ok\")","v":"     ok"},null,null,null,null,"         Proposed Sub-Index",{"$f":"F28","v":0},{"$f":"BH218","v":0},{"$f":"ROUND(N(BS158)-N(BT158),4)","v":0},{"$f":"IF(BU158>0,\"     HIGH\",IF(BU158<0,\"      LOW\",\"       *\"))","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,420,"Final MLB, PRI ISDN, & Centrex EU Rate","Input ",null,{"$f":"IF(BL159>BL154,\"     Error:  Exceeded maximum allowable rate\",IF(BL159<BL158,\"     Error:  MLB rate less than NPR rate\",IF(BL159<BL157,\"     Error:  MLB rate less than PR rate\",\"     ok\")))","v":"     ok"},null,null,null,null,"         Sub-Index Upper Limit",{"$f":"G28","v":0},{"$f":"BH219","v":0},{"$f":"ROUND(N(BS159)-N(BT159),4)","v":0},{"$f":"IF(BU159>0,\"     HIGH\",IF(BU159<0,\"      LOW\",\"       *\"))","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,"","DS1,  Special Access Density Zone 2:",null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,"         IND-1 Sub-Index Out of Bounds?",null,null,null,{"$f":"IF(TRUNC(BS158,4)>TRUNC(BS159,4),\"     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,4421,"DS1 Spec DZ2 ChanTerm",null,null,"          N/A","          N/A","          N/A",null,null,null,"    N/A","","Final EU Revenue","",null,null,null,null,null,null,"         RTE-1 Sub-Index Out of Bounds?",null,null,null,{"$f":"IF(TRUNC(N(BT158),4)>TRUNC(N(BT159),4),\"     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,4424,"DS1 Spec DZ2 Other",null,"          N/A","          N/A","          N/A","          N/A",null,null,null,"    N/A",500,"Final Total Primary Res & SLB & LifeLine EU Revenue","r400 * CAP1r100 or Sum of CAP2-priced Jurisdictns",{"$f":"IF(BL130=\"cap2\",BL157*BL26,BL130)","v":0},null,null,null,null,null,"      DS3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(BL130=\"cap2\",BL158*BL27,BL130)","v":0},null,null,null,null,null,"         Proposed Sub-Index",{"$f":"F34","v":0},{"$f":"BH296","v":0},{"$f":"ROUND(N(BS163)-N(BT163),4)","v":0},{"$f":"IF(BU163>0,\"     HIGH\",IF(BU163<0,\"      LOW\",\"       *\"))","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,4437,"Total DS1 Spec DZ2 Sub-Category",null,"          N/A","          N/A","          N/A","          N/A",{"$f":"SUM(BE161:BE162)","v":0},{"$f":"SUM(BF161:BF162)","v":0},{"$f":"SUM(BG161:BG162)","v":0},"    N/A",520,"Final Total MLB, PRI ISDN, & Centrex EU Revenue","r420 * CAP1r120 or Sum of CAP2-priced Jurisdictns",{"$f":"IF(BL130=\"cap2\",BL159*BL28,BL130)","v":0},null,null,null,null,null,"         Sub-Index Upper Limit",{"$f":"G34","v":0},{"$f":"BH297","v":0},{"$f":"ROUND(N(BS164)-N(BT164),4)","v":0},{"$f":"IF(BU164>0,\"     HIGH\",IF(BU164<0,\"      LOW\",\"       *\"))","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,4438,"DS1 Spec DZ2 Subindex",null,"          N/A","          N/A","          N/A","          N/A","          N/A","          N/A","          N/A",{"$f":"IF(AND(J30=0,BG164<>0),F30,IF(BF164=0,J30,J30*BG164/BF164))","v":0},530,"Final Total End User Revenue","r500 + r510 + r520",{"$f":"IF(BL130=\"CAP2\",N(BL162)+N(BL163)+N(BL164),BL130)","v":0},null,null,null,null,null,"         IND-1 Sub-Index Out of Bounds?",null,null,null,{"$f":"IF(TRUNC(BS163,4)>TRUNC(BS164,4),\"     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,4439,"DS1 Spec DZ2 Upper Limit",null,"          N/A","          N/A","          N/A","          N/A","          N/A","          N/A","          N/A",{"$f":"IF(AND(J30=0,BG164<>0),115,IF(L41=0,0,IF(BE164=0,M30*$W$54/L41*1.15,M30*$W$54/L41*1.15*(1+($AO$92+BE164*(IF(BE337=0,0,AO89/BE337)+IF(BE217=0,0,AO90/BE217)+IF(BE358=0,0,AO103/BE358)))/BE164))))","v":0},"","","",null,null,null,null,null,null,"         RTE-1 Sub-Index Out of Bounds?",null,null,null,{"$f":"IF(TRUNC(N(BT163),4)>TRUNC(N(BT164),4),\"     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,600,"Actual vs. Allowable Revenue:  Over-recovery","r530 - r130",{"$f":"IF(BL130=\"CAP2\",ROUND(N(BL165)-N(BL149),0),BL130)","v":0},{"$f":"IF(N(BL167)>0,\"     Error:  Over-recovery. You must change EUCL rates.\",IF(N(BL167)<0,\"     You have under-recovered by this amount.\",\"     ok\"))","v":"     ok"},null,null,null,null,"      Total HiCap/DDS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"         Proposed Sub-Index",{"$f":"F27","v":0},{"$f":"BH338","v":0},{"$f":"ROUND(N(BS168)-N(BT168),4)","v":0},{"$f":"IF(BU168>0,\"     HIGH\",IF(BU168<0,\"      LOW\",\"       *\"))","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,"","DS1,  Special Access Density Zone 3:",null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,"         Sub-Index Upper Limit",{"$f":"G27","v":0},{"$f":"BH339","v":0},{"$f":"ROUND(N(BS169)-N(BT169),4)","v":0},{"$f":"IF(BU169>0,\"     HIGH\",IF(BU169<0,\"      LOW\",\"       *\"))","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,4441,"DS1 Spec DZ3 ChanTerm",null,null,"          N/A","          N/A","          N/A",null,null,null,"    N/A","","","",null,null,null,null,null,null,"         IND-1 Sub-Index Out of Bounds?",null,null,null,{"$f":"IF(TRUNC(BS168,4)>TRUNC(BS169,4),\"     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,4444,"DS1 Spec DZ3 Other",null,"          N/A","          N/A","          N/A","          N/A",null,null,null,"    N/A","","","",null,null,null,null,null,null,"         RTE-1 Sub-Index Out of Bounds?",null,null,null,{"$f":"IF(TRUNC(N(BT168),4)>TRUNC(N(BT169),4),\"     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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4457,"Total DS1 Spec DZ3 Sub-Category",null,"          N/A","          N/A","          N/A","          N/A",{"$f":"SUM(BE170:BE171)","v":0},{"$f":"SUM(BF170:BF171)","v":0},{"$f":"SUM(BG170:BG171)","v":0},"    N/A","","","",null,null,null,null,null,null," Wideband"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4458,"DS1 Spec DZ3 Subindex",null,"          N/A","          N/A","          N/A","          N/A","          N/A","          N/A","          N/A",{"$f":"IF(AND(J31=0,BG173<>0),F31,IF(BF173=0,J31,J31*BG173/BF173))","v":0},"","","",null,null,null,null,null,null,"         Proposed Sub-Index",{"$f":"F40","v":0},{"$f":"BH351","v":0},{"$f":"ROUND(N(BS174)-N(BT174),4)","v":0},{"$f":"IF(BU174>0,\"     HIGH\",IF(BU174<0,\"      LOW\",\"       *\"))","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,4459,"DS1 Spec DZ3 Upper Limit",null,"          N/A","          N/A","          N/A","          N/A","          N/A","          N/A","          N/A",{"$f":"IF(AND(J31=0,BG173<>0),115,IF(L41=0,0,IF(BE173=0,M31*$W$54/L41*1.15,M31*$W$54/L41*1.15*(1+($AO$93+BE173*(IF(BE337=0,0,AO89/BE337)+IF(BE217=0,0,AO90/BE217)+IF(BE358=0,0,AO103/BE358)))/BE173))))","v":0},null,null,null,null,null,null,null,null,null,"         Sub-Index Upper Limit",{"$f":"G40","v":0},{"$f":"BH352","v":0},{"$f":"ROUND(N(BS175)-N(BT175),4)","v":0},{"$f":"IF(BU175>0,\"     HIGH\",IF(BU175<0,\"      LOW\",\"       *\"))","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,null,null,null,null,null,"         IND-1 Sub-Index Out of Bounds?",null,null,null,{"$f":"IF(TRUNC(BS174,4)>TRUNC(BS175,4),\"     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,null,null,null,"         RTE-1 Sub-Index Out of Bounds?",null,null,null,{"$f":"IF(TRUNC(N(BT174),4)>TRUNC(N(BT175),4),\"     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,"","DS1,  Special Access Density Zone 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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4461,"DS1 Spec DZ4 ChanTerm",null,null,"          N/A","          N/A","          N/A",null,null,null,"    N/A",null,null,null,null,null,null,null,null,null," Total Special Access"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4464,"DS1 Spec DZ4 Other",null,"          N/A","          N/A","          N/A","          N/A",null,null,null,"    N/A",null,null,null,null,null,null,null,null,null,"      Special Access API",{"$f":"E41","v":0},{"$f":"BH360","v":0},{"$f":"ROUND(N(BS180)-N(BT180),4)","v":0},{"$f":"IF(BU180>0,\"     HIGH\",IF(BU180<0,\"      LOW\",\"       *\"))","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,null,null,null,"      Special Access PCI",{"$f":"D41","v":0},{"$f":"BH361","v":0},{"$f":"ROUND(N(BS181)-N(BT181),4)","v":0},{"$f":"IF(BU181>0,\"     HIGH\",IF(BU181<0,\"      LOW\",\"       *\"))","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,4477,"Total DS1 Spec DZ4 Sub-Category",null,"          N/A","          N/A","          N/A","          N/A",{"$f":"SUM(BE179:BE180)","v":0},{"$f":"SUM(BF179:BF180)","v":0},{"$f":"SUM(BG179:BG180)","v":0},"    N/A",null,null,null,null,null,null,null,null,null,"      IND-1 API Above PCI?",null,null,null,{"$f":"IF(TRUNC(BS180,4)>TRUNC(BS181,4),\"     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,4478,"DS1 Spec DZ4 Subindex",null,"          N/A","          N/A","          N/A","          N/A","          N/A","          N/A","          N/A",{"$f":"IF(AND(J32=0,BG182<>0),F32,IF(BF182=0,J32,J32*BG182/BF182))","v":0},null,null,null,null,null,null,null,null,null,"      RTE API Above PCI?",null,null,null,{"$f":"IF(TRUNC(N(BT180),4)>TRUNC(N(BT181),4),\"     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,4479,"DS1 Spec DZ4 Upper Limit",null,"          N/A","          N/A","          N/A","          N/A","          N/A","          N/A","          N/A",{"$f":"IF(AND(J32=0,BG182<>0),115,IF(L41=0,0,IF(BE182=0,M32*$W$54/L41*1.15,M32*$W$54/L41*1.15*(1+($AO$94+BE182*(IF(BE337=0,0,AO89/BE337)+IF(BE217=0,0,AO90/BE217)+IF(BE358=0,0,AO103/BE358)))/BE182))))","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,"","DS1,  Special Access Density Zone 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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4481,"DS1 Spec DZ5 ChanTerm",null,null,"          N/A","          N/A","          N/A",null,null,null,"    N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4484,"DS1 Spec DZ5 Other",null,"          N/A","          N/A","          N/A","          N/A",null,null,null,"    N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4497,"Total DS1 Spec DZ5 Sub-Category",null,"          N/A","          N/A","          N/A","          N/A",{"$f":"SUM(BE188:BE189)","v":0},{"$f":"SUM(BF188:BF189)","v":0},{"$f":"SUM(BG188:BG189)","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,4498,"DS1 Spec DZ5 Subindex",null,"          N/A","          N/A","          N/A","          N/A","          N/A","          N/A","          N/A",{"$f":"IF(AND(J33=0,BG191<>0),F33,IF(BF191=0,J33,J33*BG191/BF191))","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,4499,"DS1 Spec DZ5 Upper Limit",null,"          N/A","          N/A","          N/A","          N/A","          N/A","          N/A","          N/A",{"$f":"IF(AND(J33=0,BG191<>0),115,IF(L41=0,0,IF(BE191=0,M33*$W$54/L41*1.15,M33*$W$54/L41*1.15*(1+($AO$95+BE191*(IF(BE337=0,0,AO89/BE337)+IF(BE217=0,0,AO90/BE217)+IF(BE358=0,0,AO103/BE358)))/BE191))))","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,"RTE-1",null,null,null,null,null,null,null,null,null,null,"CAP-3",null,null,null,null,null,null,null,null,"ANALYZER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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/2023"},null,null,null,null,null,null,null,null,null,null,{"$f":"\"Filing Date:                \"&DATE","v":"Filing Date:                06/16/2023"},null,"",null,null,null,null,null,null,{"$f":"\"Filing Date:                \"&DATE","v":"Filing Date:                06/16/2023"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,{"$f":"\"Filing Entity:               \"&COSA","v":"Filing Entity:               "},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,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,{"$f":"\"Transmittal Number:   \"&TRANSMITTAL","v":"Transmittal Number:   "},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,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,{"$f":"NAME","v":0},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 4 of 6",null,null,null,null,"Price Caps Tariff Review Plan",null,null,null,null,null,"Page 1 of 1",null,"Price Cap Tariff Review Plan",null,null,null,null,null,null,"Page 4 of 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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Special Access Basket",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,null,"IND-1","RTE-1","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BASE PERIOD","BASE PERIOD","BASE PERIOD",null,null,null,"","Total","Zone A","Zone B","Zone C","Zone D","Other Zone *","SPECIAL ACCESS--------------------------------------","-","-","-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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)","      DS1  Special Access Density Zone 1 "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PERIOD",{"$f":"MONTH($M$3) & \"/\"& DAY($M$3) & \"/\" & RIGHT(YEAR($M$3),2) & \" PCI\"","v":"10/1/22 PCI"},"CURRENT","PROPOSED",{"$f":"\"RATES AT \" & MONTH($M$3) & \"/\"& DAY($M$3) & \"/\" & RIGHT(YEAR($M$3),2)","v":"RATES AT 10/1/22"},"CURRENT","PROPOSED","INDEX ",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,"         Proposed Sub-Index",{"$f":"F29","v":0},{"$f":"BH156","v":0},{"$f":"ROUND(N(BS205)-N(BT205),4)","v":0},{"$f":"IF(BU205>0,\"     HIGH\",IF(BU205<0,\"      LOW\",\"       *\"))","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,"DEMAND","UPDATE","RATES","RATES","PCI UPDATE","RATES","RATES","RESULTS",100,"Maximum CMT Revenue","CAP1r600 or Sum of CAP3-priced Jurisdictns",{"$f":"IF(BL130=\"CAP3\",BL86,BL130)","v":"CAP2"},"      N/A","      N/A","      N/A","      N/A","      N/A","         Sub-Index Upper Limit",{"$f":"G29","v":0},{"$f":"BH157","v":0},{"$f":"ROUND(N(BS206)-N(BT206),4)","v":0},{"$f":"IF(BU206>0,\"     HIGH\",IF(BU206<0,\"      LOW\",\"       *\"))","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,"-","-","-","-","-","-","-","-",110,"Total USAC Receipts","CAP1r660 or Sum of CAP3-priced Jurisdictns",{"$f":"IF(BL130=\"CAP3\",BL93,BL130)","v":"CAP2"},"      N/A","      N/A","      N/A","      N/A","      N/A","         IND-1 Sub-Index Out of Bounds?",null,null,null,{"$f":"IF(TRUNC(BS205,4)>TRUNC(BS206,4),\"     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,"(A)","(B)","(C)","(D)","(E)","(F)","(G)","(H)","","","",null,null,null,null,null,null,"         RTE-1 Sub-Index Out of Bounds?",null,null,null,{"$f":"IF(TRUNC(N(BT205),4)>TRUNC(N(BT206),4),\"     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,"","High Cap & DDS Service Category - Special",null,null,null,null,null,null,null,null,null,130,"Maximum Recoverable Revenue","r100 - r110",{"$f":"IF(BL130=\"CAP3\",N(BL206)-N(BL207),BL130)","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,"      DS1  Special Access Density Zone 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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DS1, Non-Density Zone Special:",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,"         Proposed Sub-Index",{"$f":"F30","v":0},{"$f":"BH165","v":0},{"$f":"ROUND(N(BS211)-N(BT211),4)","v":0},{"$f":"IF(BU211>0,\"     HIGH\",IF(BU211<0,\"      LOW\",\"       *\"))","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,4571,"DS1 SP NonDZ ChanTerm",null,null,"          N/A","          N/A","          N/A",null,null,null,"    N/A",200,"Total Local Exchange Lines","CAP1r130 or Sum of CAP3-priced Jurisdictns",{"$f":"IF(BL130=\"CAP3\",SUM(BM212:BQ212),BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",BM29,BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",BN29,BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",BO29,BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",BP29,BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",BQ29,BL130)","v":"CAP2"},"         Sub-Index Upper Limit",{"$f":"G30","v":0},{"$f":"BH166","v":0},{"$f":"ROUND(N(BS212)-N(BT212),4)","v":0},{"$f":"IF(BU212>0,\"     HIGH\",IF(BU212<0,\"      LOW\",\"       *\"))","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,4574,"DS1 SP NonDZ Other",null,"          N/A","          N/A","          N/A","          N/A",null,null,null,"    N/A",210,"Unbundled Loop & Line Port Rate (State Approved)","Input if CAP1r1130=CAP3; else, CAP1r1130","      N/A",{"$f":"BL130","v":"CAP2"},{"$f":"BL130","v":"CAP2"},{"$f":"BL130","v":"CAP2"},{"$f":"BL130","v":"CAP2"},{"$f":"BL130","v":"CAP2"},"         IND-1 Sub-Index Out of Bounds?",null,null,null,{"$f":"IF(TRUNC(BS211,4)>TRUNC(BS212,4),\"     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,220,"Interstate UNE Rate","r210*.25 if CAP1r1130=CAP3","      N/A",{"$f":"IF(BL130=\"CAP3\",BM213*0.25,BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",BN213*0.25,BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",BO213*0.25,BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",BP213*0.25,BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",BQ213*0.25,BL130)","v":"CAP2"},"         RTE-1 Sub-Index Out of Bounds?",null,null,null,{"$f":"IF(TRUNC(N(BT211),4)>TRUNC(N(BT212),4),\"     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,4578,"Total DS1 SP NonZone",null,"          N/A","          N/A","          N/A","          N/A",{"$f":"SUM(BE212:BE213)","v":0},{"$f":"SUM(BF212:BF213)","v":0},{"$f":"SUM(BG212:BG213)","v":0},"    N/A",230,"Interstate UNE Revenues","r200 * r220 or Sum of CAP3-priced Jurisdictns",{"$f":"IF(BL130=\"CAP3\",SUM(BM215:BQ215),BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",BM212*BM214,BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",BN212*BN214,BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",BO212*BO214,BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",BP212*BP214,BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",BQ212*BQ214,BL130)","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,240,"Maximum CMT Revenue (using Max CMT Rev/Line)","CAP1r600 or Sum of CAP3-priced Jurisdictns",{"$f":"IF(BL130=\"CAP3\",BL86,BL130)","v":"CAP2"},"      N/A","      N/A","      N/A","      N/A","      N/A","      DS1  Special Access Density Zone 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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4597,"TOTAL DS1 Special Sub-Category",null,"          N/A","          N/A","          N/A","          N/A",{"$f":"BE155+BE164+BE173+BE182+BE191+BE215","v":0},{"$f":"BF155+BF164+BF173+BF182+BF191+BF215","v":0},{"$f":"BG155+BG164+BG173+BG182+BG191+BG215","v":0},"    N/A",250,"Average Price Cap CMT Rev to be Recovered per Line","CAP1r460 ifCAP1r1130=CAP3",{"$f":"IF(BL130=\"CAP3\",BL58,BL130)","v":"CAP2"},"      N/A","      N/A","      N/A","      N/A","      N/A","         Proposed Sub-Index",{"$f":"F31","v":0},{"$f":"BH174","v":0},{"$f":"ROUND(N(BS217)-N(BT217),4)","v":0},{"$f":"IF(BU217>0,\"     HIGH\",IF(BU217<0,\"      LOW\",\"       *\"))","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,4598,"DS1 Special Subindex",null,"          N/A","          N/A","          N/A","          N/A","          N/A","          N/A","          N/A",{"$f":"IF(AND(J28=0,BG217<>0),F28,IF(BF217=0,J28,J28*BG217/BF217))","v":0},260,"Price Cap CMT Revenue by Zone","r200 * r250 or Sum of CAP3-priced Jurisdictns",{"$f":"IF(BL130=\"CAP3\",SUM(BM218:BQ218),BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",BM212*BL217,BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",BN212*BL217,BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",BO212*BL217,BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",BP212*BL217,BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",BQ212*BL217,BL130)","v":"CAP2"},"         Sub-Index Upper Limit",{"$f":"G31","v":0},{"$f":"BH175","v":0},{"$f":"ROUND(N(BS218)-N(BT218),4)","v":0},{"$f":"IF(BU218>0,\"     HIGH\",IF(BU218<0,\"      LOW\",\"       *\"))","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,4599,"DS1 Special Upper Limit",null,"          N/A","          N/A","          N/A","          N/A","          N/A","          N/A","          N/A",{"$f":"IF(AND(J28=0,BG217<>0),105,IF(L41=0,0,IF(BE217=0,M28*$W$54/L41*1.05,M28*$W$54/L41*1.05*(1+(SUM($AO$90:$AO$95)+BE217*(IF(BE337=0,0,AO89/BE337)+IF(BE358=0,0,AO103/BE358)))/BE217))))","v":0},270,"Uniform Rate Adjustment Factor","(r260 - r230 ) / r 200",{"$f":"IF(BL130<>\"CAP3\",BL130,IF(BL212=0,0,(BL218-BL215)/BL212))","v":"CAP2"},"      N/A","      N/A","      N/A","      N/A","      N/A","         IND-1 Sub-Index Out of Bounds?",null,null,null,{"$f":"IF(TRUNC(BS217,4)>TRUNC(BS218,4),\"     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,null,null,"         RTE-1 Sub-Index Out of Bounds?",null,null,null,{"$f":"IF(TRUNC(N(BT217),4)>TRUNC(N(BT218),4),\"     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,"","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High Cap & DDS Service Category - Special",null,null,null,null,null,null,null,null,null,300,"Zone Average Revenue Per Line","r270a+r220 ifCAP1r1130=CAP3","      N/A",{"$f":"IF(BL130=\"CAP3\",IF(BM214=0,\"None\",BL219+BM214),BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",IF(BN214=0,\"None\",BL219+BN214),BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",IF(BO214=0,\"None\",BL219+BO214),BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",IF(BP214=0,\"None\",BL219+BP214),BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",IF(BQ214=0,\"None\",BL219+BQ214),BL130)","v":"CAP2"},"      DS1  Special Access Density Zone 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,null,null,null,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(BL130=\"CAP3\",IF(BM214=0,0,IF(BN214=0,BM214,IF(BO214=0,MIN(BM214:BN214),IF(BP214=0,MIN(BM214:BO214),IF(BQ214=0,MIN(BM214:BP214),MIN(BM214:BQ214))))))+BL219,BL130)","v":"CAP2"},"      N/A","      N/A","      N/A","      N/A","      N/A","         Proposed Sub-Index",{"$f":"F32","v":0},{"$f":"BH183","v":0},{"$f":"ROUND(N(BS223)-N(BT223),4)","v":0},{"$f":"IF(BU223>0,\"     HIGH\",IF(BU223<0,\"      LOW\",\"       *\"))","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,"","DS3,  Special Access Density Zone 1:",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(BL130=\"CAP3\",BL93,BL130)","v":"CAP2"},"      N/A","      N/A","      N/A","      N/A","      N/A","         Sub-Index Upper Limit",{"$f":"G32","v":0},{"$f":"BH184","v":0},{"$f":"ROUND(N(BS224)-N(BT224),4)","v":0},{"$f":"IF(BU224>0,\"     HIGH\",IF(BU224<0,\"      LOW\",\"       *\"))","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,4601,"DS3 Spec DZ1 ChanTerm",null,"          N/A","          N/A","          N/A","          N/A",null,null,null,"    N/A",330,"Study Area above CAP Benchmark Revenues","If r300>9.2,(r300-7)*CAP1r(100+110)+(r300-9.2)*",{"$f":"IF(BL130=\"CAP3\",SUM(BM225:BQ225),BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",IF(BM222=\"None\",\"None\",IF((BM222>9.2),(BM222-7)*(BM26+BM27)+(BM222-9.2)*BM28,IF(BM222>7,(BM222-7)*(BM26+BM27),0))),BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",IF(BN222=\"None\",\"None\",IF((BN222>9.2),(BN222-7)*(BN26+BN27)+(BN222-9.2)*BN28,IF(BN222>7,(BN222-7)*(BN26+BN27),0))),BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",IF(BO222=\"None\",\"None\",IF((BO222>9.2),(BO222-7)*(BO26+BO27)+(BO222-9.2)*BO28,IF(BO222>7,(BO222-7)*(BO26+BO27),0))),BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",IF(BP222=\"None\",\"None\",IF((BP222>9.2),(BP222-7)*(BP26+BP27)+(BP222-9.2)*BP28,IF(BP222>7,(BP222-7)*(BP26+BP27),0))),BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",IF(BQ222=\"None\",\"None\",IF((BQ222>9.2),(BQ222-7)*(BQ26+BQ27)+(BQ222-9.2)*BQ28,IF(BQ222>7,(BQ222-7)*(BQ26+BQ27),0))),BL130)","v":"CAP2"},"         IND-1 Sub-Index Out of Bounds?",null,null,null,{"$f":"IF(TRUNC(BS223,4)>TRUNC(BS224,4),\"     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,4604,"DS3 Spec DZ1 Other",null,"          N/A","          N/A","          N/A","          N/A",null,null,null,"    N/A","","","   CAP1r120; if 9.2>=r300>7,(r300-7)*CAP1r(100+110);",null,null,null,null,null,null,"         RTE-1 Sub-Index Out of Bounds?",null,null,null,{"$f":"IF(TRUNC(N(BT223),4)>TRUNC(N(BT224),4),\"     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,"","","   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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4617,"Total DS3 Spec DZ1 Sub-Category",null,"          N/A","          N/A","          N/A","          N/A",{"$f":"SUM(BE225:BE226)","v":0},{"$f":"SUM(BF225:BF226)","v":0},{"$f":"SUM(BG225:BG226)","v":0},"    N/A",340,"Over Cap Revenues","Max(0, (r330 - r320))",{"$f":"IF(BL130=\"CAP3\",MAX(0,N(BL225)-N(BL224)),BL130)","v":"CAP2"},"      N/A","      N/A","      N/A","      N/A","      N/A","      DS1  Special Access Density Zone 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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4618,"DS3 Spec DZ1 Subindex",null,"          N/A","          N/A","          N/A","          N/A","          N/A","          N/A","          N/A",{"$f":"IF(AND(J35=0,BG228<>0),F35,IF(BF228=0,J35,J35*BG228/BF228))","v":0},350,"Interim Calculations only (do not represent Zone results)","Interim calcs only (used in r360, r375, r385)",{"$f":"IF(BL130=\"CAP3\",IF(OR(BN222=\"None\",BM229<=BN222)=TRUE,BM229,IF(OR(BO222=\"None\",BN229<=BO222)=TRUE,BN229,IF(OR(BP222=\"None\",BO229<=BP222)=TRUE,BO229,IF(OR(BQ222=\"None\",BP229<=BQ222)=TRUE,BP229,BQ229)))),BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",IF(BM222=\"None\",\"None\",IF(BM212=0,0,BL228/BM212)+BM222),BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",IF(BN222=\"None\",\"None\",IF(BM212+BN212=0,0,MAX(0,(BL228-(BN222-BM222)*BM212))/(BM212+BN212))+BN222),BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",IF(BO222=\"None\",\"None\",IF(BM212+BN212+BO212=0,0,MAX(0,(BL228-(BO222-BM222)*BM212-(BO222-BN222)*BN212))/(BM212+BN212+BO212))+BO222),BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",IF(BP222=\"None\",\"None\",IF(BM212+BN212+BO212+BP212=0,0,MAX(0,(BL228-(BP222-BM222)*BM212-(BP222-BN222)*BN212-(BP222-BO222)*BO212))/(BM212+BN212+BO212+BP212))+BP222),BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",IF(BQ222=\"None\",\"None\",IF(BM212+BN212+BO212+BP212+BQ212=0,0,MAX(0,(BL228-(BQ222-BM222)*BM212-(BQ222-BN222)*BN212-(BQ222-BO222)*BO212-(BQ222-BP222)*BP212))/(BM212+BN212+BO212+BP212+BQ212))+BQ222),BL130)","v":"CAP2"},"         Proposed Sub-Index",{"$f":"F33","v":0},{"$f":"BH192","v":0},{"$f":"ROUND(N(BS229)-N(BT229),4)","v":0},{"$f":"IF(BU229>0,\"     HIGH\",IF(BU229<0,\"      LOW\",\"       *\"))","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,4619,"DS3 Spec DZ1 Upper Limit",null,"          N/A","          N/A","          N/A","          N/A","          N/A","          N/A","          N/A",{"$f":"IF(AND(J35=0,BG228<>0),115,IF(L41=0,0,IF(BE228=0,M35*$W$54/L41*1.15,M35*$W$54/L41*1.15*(1+($AO$97+BE228*(IF(BE337=0,0,AO89/BE337)+IF(BE295=0,0,AO96/BE295)+IF(BE358=0,0,AO103/BE358)))/BE228))))","v":0},"","","",null,null,null,null,"junk",null,"         Sub-Index Upper Limit",{"$f":"G33","v":0},{"$f":"BH193","v":0},{"$f":"ROUND(N(BS230)-N(BT230),4)","v":0},{"$f":"IF(BU230>0,\"     HIGH\",IF(BU230<0,\"      LOW\",\"       *\"))","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,360,"Minimum Deavgd PR, Lifeline, SLB EU Rate","Min(r350a,CAP1r400)if CAP1r1130=CAP3",{"$f":"IF(BL130=\"CAP3\",MIN(BL229,BL46),BL130)","v":"CAP2"},"      N/A","      N/A","      N/A","      N/A","      N/A","         IND-1 Sub-Index Out of Bounds?",null,null,null,{"$f":"IF(TRUNC(BS229,4)>TRUNC(BS230,4),\"     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,370,"Maximum Deavgd PR, Lifeline, SLB EU Rate","CAP1r400 if CAP1r1130=CAP3",{"$f":"BL130","v":"CAP2"},"      N/A","      N/A","      N/A","      N/A","      N/A","         RTE-1 Sub-Index Out of Bounds?",null,null,null,{"$f":"IF(TRUNC(N(BT229),4)>TRUNC(N(BT230),4),\"     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,"","DS3,  Special Access Density Zone 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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4621,"DS3 Spec DZ2 ChanTerm",null,"          N/A","          N/A","          N/A","          N/A",null,null,null,"    N/A",375,"Minimum Deavgd NPR & BRI ISDN EU Rate","Min(r350a,CAP1r410)if CAP1r1130=CAP3",{"$f":"IF(BL130=\"CAP3\",MIN(BL229,BL47),BL130)","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,4624,"DS3 Spec DZ2 Other",null,"          N/A","          N/A","          N/A","          N/A",null,null,null,"    N/A",380,"Maximum Deavgd NPR & BRI ISDN EU Rate","CAP1r410 if CAP1r1130=CAP3",{"$f":"BL130","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,null,null,null,null,null,null,null,null,null,null,null,4637,"Total DS3 Spec DZ2 Sub-Category",null,"          N/A","          N/A","          N/A","          N/A",{"$f":"SUM(BE234:BE235)","v":0},{"$f":"SUM(BF234:BF235)","v":0},{"$f":"SUM(BG234:BG235)","v":0},"    N/A",385,"Minimum Deavgd MLB, PRI, Centrex EU Rate","Min(r350a,CAP1r420)if CAP1r1130=CAP3",{"$f":"IF(BL130=\"CAP3\",MIN(BL229,BL48),BL130)","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,4638,"DS3 Spec DZ2 Subindex",null,"          N/A","          N/A","          N/A","          N/A","          N/A","          N/A","          N/A",{"$f":"IF(AND(J36=0,BG237<>0),F36,IF(BF237=0,J36,J36*BG237/BF237))","v":0},390,"Maximum Deavgd MLB, PRI, Centrex EU Rate","CAP1r420 if CAP1r1130=CAP3",{"$f":"BL130","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,4639,"DS3 Spec DZ2 Upper Limit",null,"          N/A","          N/A","          N/A","          N/A","          N/A","          N/A","          N/A",{"$f":"IF(AND(J36=0,BG237<>0),115,IF(L41=0,0,IF(BE237=0,M36*$W$54/L41*1.15,M36*$W$54/L41*1.15*(1+($AO$98+BE237*(IF(BE337=0,0,AO89/BE337)+IF(BE295=0,0,AO96/BE295)+IF(BE358=0,0,AO103/BE358)))/BE237))))","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","DS3,  Special Access Density Zone 3:",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":"BL130","v":"CAP2"},{"$f":"BL130","v":"CAP2"},{"$f":"BL130","v":"CAP2"},{"$f":"BL130","v":"CAP2"},{"$f":"BL130","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,4641,"DS3 Spec DZ3 ChanTerm",null,"          N/A","          N/A","          N/A","          N/A",null,null,null,"    N/A",410,"Final NonPrim Res & BRI ISDN EU Rate","Input; but for col.c thru f: if r100=\"N/A\", 0","      N/A",{"$f":"BL130","v":"CAP2"},{"$f":"BL130","v":"CAP2"},{"$f":"BL130","v":"CAP2"},{"$f":"BL130","v":"CAP2"},{"$f":"BL130","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,4644,"DS3 Spec DZ3 Other",null,"          N/A","          N/A","          N/A","          N/A",null,null,null,"    N/A",420,"Final MLB, PRI ISDN, & Centrex EU Rate","Input; but for col.c thru f: if r100=\"N/A\", 0","      N/A",{"$f":"BL130","v":"CAP2"},{"$f":"BL130","v":"CAP2"},{"$f":"BL130","v":"CAP2"},{"$f":"BL130","v":"CAP2"},{"$f":"BL130","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4657,"Total DS3 Spec DZ3 Sub-Category",null,"          N/A","          N/A","          N/A","          N/A",{"$f":"SUM(BE243:BE244)","v":0},{"$f":"SUM(BF243:BF244)","v":0},{"$f":"SUM(BG243:BG244)","v":0},"    N/A","","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4658,"DS3 Spec DZ3 Subindex",null,"          N/A","          N/A","          N/A","          N/A","          N/A","          N/A","          N/A",{"$f":"IF(AND(J37=0,BG246<>0),F37,IF(BF246=0,J37,J37*BG246/BF246))","v":0},500,"Final Total Primary Res & SLB & LifeLine EU Revenue","r400 * CAP1r100 or Sum of CAP3-priced Juris",{"$f":"IF(BL130=\"CAP3\",SUM(BM247:BQ247),BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",BM242*BM26,BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",BN242*BN26,BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",BO242*BO26,BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",BP242*BP26,BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",BQ242*BQ26,BL130)","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,4659,"DS3 Spec DZ3 Upper Limit",null,"          N/A","          N/A","          N/A","          N/A","          N/A","          N/A","          N/A",{"$f":"IF(AND(J37=0,BG246<>0),115,IF(L41=0,0,IF(BE246=0,M37*$W$54/L41*1.15,M37*$W$54/L41*1.15*(1+($AO$99+BE246*(IF(BE337=0,0,AO89/BE337)+IF(BE295=0,0,AO96/BE295)+IF(BE358=0,0,AO103/BE358)))/BE246))))","v":0},510,"Final Total NonPrim Res & BRI ISDN EU Revenue","r410 * CAP1r110 or Sum of CAP3-priced Juris",{"$f":"IF(BL130=\"CAP3\",SUM(BM248:BQ248),BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",BM243*BM27,BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",BN243*BN27,BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",BO243*BO27,BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",BP243*BP27,BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",BQ243*BQ27,BL130)","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,520,"Final Total MLB, PRI ISDN, & Centrex EU Revenue","r420 * CAP1r120 or Sum of CAP3-priced Juris",{"$f":"IF(BL130=\"CAP3\",SUM(BM249:BQ249),BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",BM244*BM28,BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",BN244*BN28,BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",BO244*BO28,BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",BP244*BP28,BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",BQ244*BQ28,BL130)","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,530,"Final Total End User Revenue","r500 + r510 + r520",{"$f":"IF(BL130=\"CAP3\",SUM(BL247:BL249),BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",SUM(BM247:BM249),BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",SUM(BN247:BN249),BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",SUM(BO247:BO249),BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",SUM(BP247:BP249),BL130)","v":"CAP2"},{"$f":"IF(BL130=\"CAP3\",SUM(BQ247:BQ249),BL130)","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(BL130=\"CAP3\",BL250-BL209,BL130)","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,"","          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,"RTE-1",null,null,null,null,null,null,null,null,null,null,"CAP-4",null,null,null,null,null,null,null,null,"ANALYZER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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/2023"},null,null,null,null,null,null,null,null,null,null,{"$f":"\"Filing Date:                \"&DATE","v":"Filing Date:                06/16/2023"},null,null,null,null,null,null,null,null,{"$f":"\"Filing Date:                \"&DATE","v":"Filing Date:                06/16/2023"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,{"$f":"NAME","v":0},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 5 of 6",null,null,null,null,"Price Caps Tariff Review Plan",null,null,null,null,null,"Page 1 of 1",null,"Price Cap Tariff Review Plan",null,null,null,null,null,null,"Page 5 of 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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Special Access Basket",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IND-1","RTE-1","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BASE PERIOD","BASE PERIOD","BASE PERIOD",null,null,null,null,null,null,null,null,null,null,"SPECIAL ACCESS--------------------------------------","-","-","-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BASE","RATES AT",null,null,"DEMAND x","DEMAND x","DEMAND x",null,null,null,null,"Total","No Zone / Zone A","Zone B","Zone C","Zone D","Other Zone","      DS3  Special Access Density Zone 1 "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PERIOD",{"$f":"MONTH($M$3) & \"/\"& DAY($M$3) & \"/\" & RIGHT(YEAR($M$3),2) & \" PCI\"","v":"10/1/22 PCI"},"CURRENT","PROPOSED",{"$f":"\"RATES AT \" & MONTH($M$3) & \"/\"& DAY($M$3) & \"/\" & RIGHT(YEAR($M$3),2)","v":"RATES AT 10/1/22"},"CURRENT","PROPOSED","INDEX ",null,null,"Source","(a)","(b)","(c)","(d)","(e)","(f)","         Proposed Sub-Index",{"$f":"F35","v":0},{"$f":"BH229","v":0},{"$f":"ROUND(N(BS265)-N(BT265),4)","v":0},{"$f":"IF(BU265>0,\"     HIGH\",IF(BU265<0,\"      LOW\",\"       *\"))","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,"DEMAND","UPDATE","RATES","RATES","PCI UPDATE","RATES","RATES","RESULTS","","","",null,null,null,null,null,null,"         Sub-Index Upper Limit",{"$f":"G35","v":0},{"$f":"BH230","v":0},{"$f":"ROUND(N(BS266)-N(BT266),4)","v":0},{"$f":"IF(BU266>0,\"     HIGH\",IF(BU266<0,\"      LOW\",\"       *\"))","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,"-","-","-","-","-","-","-","-","","","For rows 100&105: If CAP1r1110=\"Yes\", use sourcing; else enter \"No Pooling\".",null,null,null,null,null,null,"         IND-1 Sub-Index Out of Bounds?",null,null,null,{"$f":"IF(TRUNC(BS265,4)>TRUNC(BS266,4),\"     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,"(A)","(B)","(C)","(D)","(E)","(F)","(G)","(H)",100,"Pooling Amount?","Input",null,"      N/A","      N/A","      N/A","      N/A","      N/A","         RTE-1 Sub-Index Out of Bounds?",null,null,null,{"$f":"IF(TRUNC(N(BT265),4)>TRUNC(N(BT266),4),\"     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,"High Cap & DDS Service Category - Special",null,null,null,null,null,null,null,null,null,105,"CAP Form containing final EUCL Rates?","CAP1r1130",{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",BL130)","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,"      DS3  Special Access Density Zone 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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","DS3,  Special Access Density Zone 4:",null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,"         Proposed Sub-Index",{"$f":"F36","v":0},{"$f":"BH238","v":0},{"$f":"ROUND(N(BS271)-N(BT271),4)","v":0},{"$f":"IF(BU271>0,\"     HIGH\",IF(BU271<0,\"      LOW\",\"       *\"))","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,4661,"DS3 Spec DZ4 ChanTerm",null,"          N/A","          N/A","          N/A","          N/A",null,null,null,"    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.",null,null,null,null,null,null,"         Sub-Index Upper Limit",{"$f":"G36","v":0},{"$f":"BH239","v":0},{"$f":"ROUND(N(BS272)-N(BT272),4)","v":0},{"$f":"IF(BU272>0,\"     HIGH\",IF(BU272<0,\"      LOW\",\"       *\"))","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,4664,"DS3 Spec DZ4 Other",null,"          N/A","          N/A","          N/A","          N/A",null,null,null,"    N/A",110,"MLB, PRI ISDN & Centrex EUCL Cap","CAP1r420",{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(AND(BL269<>\"CAP1\",BL269<>\"CAP2\"),BL130,BL48))","v":"No Pooling"},"      N/A","      N/A","      N/A","      N/A","      N/A","         IND-1 Sub-Index Out of Bounds?",null,null,null,{"$f":"IF(TRUNC(BS271,4)>TRUNC(BS272,4),\"     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,120,"MLB, PRI & Centrex EUCL Rate","if r105=\"CAP1\", CAP1r520;  =\"CAP2\",CAP2r420;",{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(AND(BL269<>\"CAP1\",BL269<>\"CAP2\"),BL130,IF(BL130=\"CAP1\",BL48,BL159)))","v":"No Pooling"},"      N/A","      N/A","      N/A","      N/A","      N/A","         RTE-1 Sub-Index Out of Bounds?",null,null,null,{"$f":"IF(TRUNC(N(BT271),4)>TRUNC(N(BT272),4),\"     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,4677,"Total DS3 Spec DZ4 Sub-Category",null,"          N/A","          N/A","          N/A","          N/A",{"$f":"SUM(BE272:BE273)","v":0},{"$f":"SUM(BF272:BF273)","v":0},{"$f":"SUM(BG272:BG273)","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,4678,"DS3 Spec DZ4 Subindex",null,"          N/A","          N/A","          N/A","          N/A","          N/A","          N/A","          N/A",{"$f":"IF(AND(J38=0,BG275<>0),F38,IF(BF275=0,J38,J38*BG275/BF275))","v":0},130,"MLB, PRI ISDN Revenue below EUCL CAP","(r110-r120)*(CAP1r120) or Sum of Jurisdictns",{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(AND(BL269<>\"CAP1\",BL269<>\"CAP2\"),BL130,(BL273-BL274)*BL28))","v":"No Pooling"},"      N/A","      N/A","      N/A","      N/A","      N/A","      DS3  Special Access Density Zone 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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4679,"DS3 Spec DZ4 Upper Limit",null,"          N/A","          N/A","          N/A","          N/A","          N/A","          N/A","          N/A",{"$f":"IF(AND(J38=0,BG275<>0),115,IF(L41=0,0,IF(BE275=0,M38*$W$54/L41*1.15,M38*$W$54/L41*1.15*(1+($AO$100+BE275*(IF(BE337=0,0,AO89/BE337)+IF(BE295=0,0,AO96/BE295)+IF(BE358=0,0,AO103/BE358)))/BE275))))","v":0},140,"Pooling revenue to be recovered from MLB EUCL Rate","Min(r130,r100) or Sum of Jurisdictions",{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(AND(BL269<>\"CAP1\",BL269<>\"CAP2\"),BL130,MIN(BL276,BL268)))","v":"No Pooling"},"      N/A","      N/A","      N/A","      N/A","      N/A","         Proposed Sub-Index",{"$f":"F37","v":0},{"$f":"BH247","v":0},{"$f":"ROUND(N(BS277)-N(BT277),4)","v":0},{"$f":"IF(BU277>0,\"     HIGH\",IF(BU277<0,\"      LOW\",\"       *\"))","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,150,"MLB EUCL rate","r120+(r140/CAP1r120) ",{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(AND(BL269<>\"CAP1\",BL269<>\"CAP2\"),BL130,IF(BL28=0,0,BL274+(BL277/BL28))))","v":"No Pooling"},"      N/A","      N/A","      N/A","      N/A","      N/A","         Sub-Index Upper Limit",{"$f":"G37","v":0},{"$f":"BH248","v":0},{"$f":"ROUND(N(BS278)-N(BT278),4)","v":0},{"$f":"IF(BU278>0,\"     HIGH\",IF(BU278<0,\"      LOW\",\"       *\"))","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,155,"MLB EUCL Revenue","r150 * (CAP1r120), or Sum of Jurisdictions",{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(AND(BL269<>\"CAP1\",BL269<>\"CAP2\"),BL130,BL278*(BL28)))","v":"No Pooling"},"      N/A","      N/A","      N/A","      N/A","      N/A","         IND-1 Sub-Index Out of Bounds?",null,null,null,{"$f":"IF(TRUNC(BS277,4)>TRUNC(BS278,4),\"     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,"","DS3,  Special Access Density Zone 5:",null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,"         RTE-1 Sub-Index Out of Bounds?",null,null,null,{"$f":"IF(TRUNC(N(BT277),4)>TRUNC(N(BT278),4),\"     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,4681,"DS3 Spec DZ5 ChanTerm",null,"          N/A","          N/A","          N/A","          N/A",null,null,null,"    N/A","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4684,"DS3 Spec DZ5 Other",null,"          N/A","          N/A","          N/A","          N/A",null,null,null,"    N/A",160,"Remaining Pooling Revenues","r100 - r140",{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(BL269=\"CAP3\",BL130,BL268-BL277))","v":"No Pooling"},"      N/A","      N/A","      N/A","      N/A","      N/A","      DS3  Special Access Density Zone 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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,"         Proposed Sub-Index",{"$f":"F38","v":0},{"$f":"BH276","v":0},{"$f":"ROUND(N(BS283)-N(BT283),4)","v":0},{"$f":"IF(BU283>0,\"     HIGH\",IF(BU283<0,\"      LOW\",\"       *\"))","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,4697,"Total DS3 Spec DZ5 Sub-Category",null,"          N/A","          N/A","          N/A","          N/A",{"$f":"SUM(BE281:BE282)","v":0},{"$f":"SUM(BF281:BF282)","v":0},{"$f":"SUM(BG281:BG282)","v":0},"    N/A",170,"MLB PICC Cap","CAP1r430",{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(BL269=\"CAP3\",BL269,BL49))","v":"No Pooling"},"      N/A","      N/A","      N/A","      N/A","      N/A","         Sub-Index Upper Limit",{"$f":"G38","v":0},{"$f":"BH277","v":0},{"$f":"ROUND(N(BS284)-N(BT284),4)","v":0},{"$f":"IF(BU284>0,\"     HIGH\",IF(BU284<0,\"      LOW\",\"       *\"))","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,4698,"DS3 Spec DZ5 Subindex",null,"          N/A","          N/A","          N/A","          N/A","          N/A","          N/A","          N/A",{"$f":"IF(AND(J39=0,BG284<>0),F39,IF(BF284=0,J39,J39*BG284/BF284))","v":0},180,"Maximum Average MLB, PRI & Centrex PICC Rate","CAP1r830",{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(BL269=\"CAP3\",BL269,BL106))","v":"No Pooling"},"      N/A","      N/A","      N/A","      N/A","      N/A","         IND-1 Sub-Index Out of Bounds?",null,null,null,{"$f":"IF(TRUNC(BS283,4)>TRUNC(BS284,4),\"     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,4699,"DS3 Spec DZ5 Upper Limit",null,"          N/A","          N/A","          N/A","          N/A","          N/A","          N/A","          N/A",{"$f":"IF(AND(J39=0,BG284<>0),115,IF(L41=0,0,IF(BE284=0,M39*$W$54/L41*1.15,M39*$W$54/L41*1.15*(1+($AO$101+BE284*(IF(BE337=0,0,AO89/BE337)+IF(BE295=0,0,AO96/BE295)+IF(BE358=0,0,AO103/BE358)))/BE284))))","v":0},190,"MLB PICC Revenue below CAP","(r170-r180)*(CAP1(r200+r210/9+r220)) or Sum",{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(BL269=\"cap3\",BL269,(BL284-BL285)*(BL32+BL33/9+BL34)))","v":"No Pooling"},"      N/A","      N/A","      N/A","      N/A","      N/A","         RTE-1 Sub-Index Out of Bounds?",null,null,null,{"$f":"IF(TRUNC(N(BT283),4)>TRUNC(N(BT284),4),\"     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,200,"Pooling revenue to be recovered from MLB PICC Rate","Min(r190,r160)",{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(BL269=\"CAP3\",BL130,MIN(BL286,BL282)))","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,210,"MLB PICC rate","r180+(r200/CAP1(r200+r210/9+r220)) ",{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(BL269=\"CAP3\",BL130,IF(BL32+BL33/9+BL34=0,0,BL285+(BL287/(BL32+BL33/9+BL34)))))","v":"No Pooling"},"      N/A","      N/A","      N/A","      N/A","      N/A","      DS3  Special Access Density Zone 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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","DS3, Non-Density Zone Special:",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(BL128<>\"Yes\",\"No Pooling\",IF(BL269=\"CAP3\",BL130,BL288*(BL32+BL33/9+BL34)))","v":"No Pooling"},"      N/A","      N/A","      N/A","      N/A","      N/A","         Proposed Sub-Index",{"$f":"F39","v":0},{"$f":"BH285","v":0},{"$f":"ROUND(N(BS289)-N(BT289),4)","v":0},{"$f":"IF(BU289>0,\"     HIGH\",IF(BU289<0,\"      LOW\",\"       *\"))","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,4771,"DS3 SP NonDZ ChanTerm",null,"          N/A","          N/A","          N/A","          N/A",null,null,null,"    N/A","","","          Jurisdictions",null,null,null,null,null,null,"         Sub-Index Upper Limit",{"$f":"G39","v":0},{"$f":"BH286","v":0},{"$f":"ROUND(N(BS290)-N(BT290),4)","v":0},{"$f":"IF(BU290>0,\"     HIGH\",IF(BU290<0,\"      LOW\",\"       *\"))","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,4774,"DS3 SP NonDZ Other",null,"          N/A","          N/A","          N/A","          N/A",null,null,null,"    N/A","","","",null,null,null,null,null,null,"         IND-1 Sub-Index Out of Bounds?",null,null,null,{"$f":"IF(TRUNC(BS289,4)>TRUNC(BS290,4),\"     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,"","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,"         RTE-1 Sub-Index Out of Bounds?",null,null,null,{"$f":"IF(TRUNC(N(BT289),4)>TRUNC(N(BT290),4),\"     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,4778,"Total DS3 SP NonZone",null,"          N/A","          N/A","          N/A","          N/A",{"$f":"SUM(BE290:BE291)","v":0},{"$f":"SUM(BF290:BF291)","v":0},{"$f":"SUM(BG290:BG291)","v":0},"    N/A",300,"Total MLB&PRI ISDN lines (include both PRI * 5 & Centrex)","CAP1r120 or Sum of CAP3-priced Jurisdictns",{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(BL269<>\"CAP3\",BL130,BL28))","v":"No Pooling"},{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(BL269<>\"CAP3\",BL130,BM28))","v":"No Pooling"},{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(BL269<>\"CAP3\",BL130,BN28))","v":"No Pooling"},{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(BL269<>\"CAP3\",BL130,BO28))","v":"No Pooling"},{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(BL269<>\"CAP3\",BL130,BP28))","v":"No Pooling"},{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(BL269<>\"CAP3\",BL130,BQ28))","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,310,"CAP3 Final MLB, PRI ISDN, & Centrex EU Rate","if r105=\"CAP3\",CAP3r420; else r105","      N/A",{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(BL269=\"CAP3\",BM244,BL130))","v":"No Pooling"},{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(BL269=\"CAP3\",BN244,BL130))","v":"No Pooling"},{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(BL269=\"CAP3\",BO244,BL130))","v":"No Pooling"},{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(BL269=\"CAP3\",BP244,BL130))","v":"No Pooling"},{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(BL269=\"CAP3\",BQ244,BL130))","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,4797,"TOTAL DS3 Special Sub-Category",null,"          N/A","          N/A","          N/A","          N/A",{"$f":"BE228+BE237+BE246+BE275+BE284+BE293","v":0},{"$f":"BF228+BF237+BF246+BF275+BF284+BF293","v":0},{"$f":"BG228+BG237+BG246+BG275+BG284+BG293","v":0},"    N/A",320,"CAP3 Final Total MLB, PRI ISDN, & Centrex EU Revenue","CAP3r520 or Sum of CAP3-priced Jurisdictns",{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(OR(BL269=\"CAP1\",BL269=\"CAP2\"),BL130,SUM(BM295:BQ295)))","v":"No Pooling"},{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(BL269<>\"CAP3\",BL130,BM293*BM294))","v":"No Pooling"},{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(BL269<>\"CAP3\",BL130,BN293*BN294))","v":"No Pooling"},{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(BL269<>\"CAP3\",BL130,BO293*BO294))","v":"No Pooling"},{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(BL269<>\"CAP3\",BL130,BP293*BP294))","v":"No Pooling"},{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(BL269<>\"CAP3\",BL130,BQ293*BQ294))","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,4798,"DS3 Special Subindex",null,"          N/A","          N/A","          N/A","          N/A","          N/A","          N/A","          N/A",{"$f":"IF(AND(J34=0,BG295<>0),F34,IF(BF295=0,J34,J34*BG295/BF295))","v":0},330,"CAP3 Final MLB Rate adjusted for Pooling amount","a: min(330b.f) b-f:(sum(r310b.f)+r100a)/sum(r300b.f)",{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(BL269<>\"CAP3\",BL130,MIN(BM296:BQ296)))","v":"No Pooling"},{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(BL269<>\"CAP3\",BL130,IF(SUM(BM293)=0,0,(SUM(BM295)+BL268)/(SUM(BM293)))))","v":"No Pooling"},{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(BL269<>\"CAP3\",BL130,IF(SUM(BM293:BN293)=0,0,(SUM(BM295:BN295)+BL268)/(SUM(BM293:BN293)))))","v":"No Pooling"},{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(BL269<>\"CAP3\",BL130,IF(SUM(BM293:BO293)=0,0,(SUM(BM295:BO295)+BL268)/(SUM(BM293:BO293)))))","v":"No Pooling"},{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(BL269<>\"CAP3\",BL130,IF(SUM(BM293:BP293)=0,0,(SUM(BM295:BP295)+BL268)/(SUM(BM293:BP293)))))","v":"No Pooling"},{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(BL269<>\"CAP3\",BL130,IF(SUM(BM293:BQ293)=0,0,(SUM(BM295:BQ295)+BL268)/(SUM(BM293:BQ293)))))","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,4799,"DS3 Special Upper Limit",null,"          N/A","          N/A","          N/A","          N/A","          N/A","          N/A","          N/A",{"$f":"IF(AND(J34=0,BG295<>0),105,IF(L41=0,0,IF(BE295=0,M34*$W$54/L41*1.05,M34*$W$54/L41*1.05*(1+(SUM($AO$96:$AO$101)+BE295*(IF(BE337=0,0,AO89/BE337)+IF(BE358=0,0,AO103/BE358)))/BE295))))","v":0},340,"Final MLB, PRI ISDN & Centrex EU Rate with Pooling","max(r310,r330a)","      N/A",{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(BL269<>\"CAP3\",BL130,IF(BM294=0,0,MAX(BM294,BL296))))","v":"No Pooling"},{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(BL269<>\"CAP3\",BL130,IF(BN294=0,0,MAX(BN294,BL296))))","v":"No Pooling"},{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(BL269<>\"CAP3\",BL130,IF(BO294=0,0,MAX(BO294,BL296))))","v":"No Pooling"},{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(BL269<>\"CAP3\",BL130,IF(BP294=0,0,MAX(BP294,BL296))))","v":"No Pooling"},{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(BL269<>\"CAP3\",BL130,IF(BQ294=0,0,MAX(BQ294,BL296))))","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,350,"MLB EUCL Revenue","r300*r340 or Sum of CAP3-priced Jurisdictns",{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(OR(BL269=\"CAP1\",BL269=\"CAP2\"),BL130,SUM(BM298:BQ298)))","v":"No Pooling"},{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(BL269<>\"CAP3\",BL130,BM293*BM297))","v":"No Pooling"},{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(BL269<>\"CAP3\",BL130,BN293*BN297))","v":"No Pooling"},{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(BL269<>\"CAP3\",BL130,BO293*BO297))","v":"No Pooling"},{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(BL269<>\"CAP3\",BL130,BP293*BP297))","v":"No Pooling"},{"$f":"IF(BL128<>\"Yes\",\"No Pooling\",IF(BL269<>\"CAP3\",BL130,BQ293*BQ297))","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(BL128<>\"Yes\",\"No Pooling\",IF(BL269=\"CAP3\",BL268+BL295-BL298,BL282-BL287))","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,"","","       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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","       else r160-r200"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RTE-1",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,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/2023"},null,null,null,null,null,null,null,null,null,null,{"$f":"\"Filing Date:                \"&DATE","v":"Filing Date:                06/16/2023"},null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,{"$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,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,{"$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,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,{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 6 of 6",null,null,null,null,"Price Caps Tariff Review Plan",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,"Special Access Basket",null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BASE PERIOD","BASE PERIOD","BASE PERIOD",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BASE","RATES AT",null,null,"DEMAND x","DEMAND x","DEMAND x",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,"PERIOD",{"$f":"MONTH($M$3) & \"/\"& DAY($M$3) & \"/\" & RIGHT(YEAR($M$3),2) & \" PCI\"","v":"10/1/22 PCI"},"CURRENT","PROPOSED",{"$f":"\"RATES AT \" & MONTH($M$3) & \"/\"& DAY($M$3) & \"/\" & RIGHT(YEAR($M$3),2)","v":"RATES AT 10/1/22"},"CURRENT","PROPOSED","INDEX ","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DEMAND","UPDATE","RATES","RATES","PCI UPDATE","RATES","RATES","RESULTS",100,"Maximum CMT Revenue","CAP1r600",{"$f":"BL86","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,"-","-","-","-","-","-","-","-",110,"Total USAC Receipts","CAP1r660",{"$f":"BL93","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,"(A)","(B)","(C)","(D)","(E)","(F)","(G)","(H)","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","High Cap & DDS Service Category",null,null,null,null,null,null,null,null,null,125,"Pooling Revenues","if CAP1r1110 = \"Yes\", CAP4r100",{"$f":"IF(BL128=\"Yes\",BL268,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"BL326-BL327+BL329","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,"","DDS&Other Non-Zone - Special:",null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4971,"DDS&Other SP Non-Zone Channel Term",null,"          N/A","          N/A","          N/A","          N/A",null,null,null,"    N/A",200,"Final Total Primary Res & SLB & LifeLine EU Revenue","if CAP1r1130 = \"CAP1\", CAP1r610",{"$f":"IF(BL130=\"CAP1\",BL132,IF(BL130=\"CAP2\",BL162,IF(BL130=\"CAP3\",BL247,\"          ERROR\")))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4974,"DDS&Other SP Non-Zone Other",null,"          N/A","          N/A","          N/A","          N/A",null,null,null,"    N/A","","","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,"","","if CAP1r1130 = \"CAP3\", CAP3r500"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4978,"Total DDS & Other SP NonZone",null,"          N/A","          N/A","          N/A","          N/A",{"$f":"SUM(BE332:BE333)","v":0},{"$f":"SUM(BF332:BF333)","v":0},{"$f":"SUM(BG332:BG333)","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,210,"Final Total NonPrim Res & BRI ISDN EU Revenue","if CAP1r1130 = \"CAP1\", CAP1r620",{"$f":"IF(BL130=\"CAP1\",BL133,IF(BL130=\"CAP2\",BL163,IF(BL130=\"CAP3\",BL248,\"          ERROR\")))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4997,"TOTAL HC/DDS Service Category",null,"          N/A","          N/A","          N/A","          N/A",{"$f":"BE335+BE295+BE217","v":0},{"$f":"BF335+BF295+BF217","v":0},{"$f":"BG335+BG295+BG217","v":0},"    N/A","","","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4998,"HC/DDS SBI",null,"          N/A","          N/A","          N/A","          N/A","          N/A","          N/A","          N/A",{"$f":"IF(AND(J27=0,BG337<>0),F27,IF(BF337=0,J27,J27*BG337/BF337))","v":0},"","","if CAP1r1130 = \"CAP3\", CAP3r510"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4999,"HC/DDS Upper SBI Limit",null,"          N/A","          N/A","          N/A","          N/A","          N/A","          N/A","          N/A",{"$f":"IF(AND(J27=0,BG337<>0),105,IF(L41=0,0,IF(BE337=0,M27*$W$54/L41*1.05,M27*$W$54/L41*1.05*(1+(SUM($AO$89:$AO$101)+BE337*IF(BE358=0,0,AO103/BE358))/BE337))))","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,220,"Final Total MLB, PRI ISDN, & Centrex EU Revenue","if CAP1r1110=\"Yes\"&:",{"$f":"IF(BL128=\"Yes\",IF(BL130=\"CAP1\",BL279,IF(BL130=\"CAP2\",BL279,IF(BL130=\"CAP3\",BL298,\"          ERROR\"))),IF(BL130=\"CAP1\",BL134,IF(BL130=\"CAP2\",BL164,IF(BL130=\"CAP3\",BL249,\"          ERROR\"))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","Wideband Service Category",null,null,null,null,null,null,null,null,null,"","","      if CAP1r1130=\"CAP3\", CAP4r350a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","-",null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","Non-Zone WB:",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5171,"WB Channel Term",null,0,"          N/A","          N/A","          N/A",null,null,null,"    N/A","","","      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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5174,"WB Other",null,"          N/A","          N/A","          N/A","          N/A",null,null,null,"    N/A","","","      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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,"","","      if CAP1r1130=\"CAP3\", CAP3r520"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5178,"Total WB NonZone",null,"          N/A","          N/A","          N/A","          N/A",{"$f":"SUM(BE345:BE346)","v":0},{"$f":"SUM(BF345:BF346)","v":0},{"$f":"SUM(BG345:BG346)","v":0},"    N/A","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5197,"Total Wideband Service Category",null,"          N/A","          N/A","          N/A","          N/A",{"$f":"BE348","v":0},{"$f":"BF348","v":0},{"$f":"BG348","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,5198,"Wideband SBI",null,"          N/A","          N/A","          N/A","          N/A","          N/A","          N/A","          N/A",{"$f":"IF(AND(J40=0,BG350<>0),F40,IF(BF350=0,J40,J40*BG350/BF350))","v":0},300,"Final Total EUCL Revenue","r200 + r210 + r220",{"$f":"BL332+BL336+BL340","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,5199,"Wideband Upper SBI Limit",null,"          N/A","          N/A","          N/A","          N/A","          N/A","          N/A","          N/A",{"$f":"IF(AND(J40=0,BG350<>0),105,IF(L41=0,0,IF(BE350=0,M40*$W$54/L41*1.05,M40*$W$54/L41*1.05*(1+(SUM($AO$102:$AO$102)+BE350*IF(BE359=0,0,AO103/BE358))/BE350))))","v":0},310,"Final Total PICC Revenue","if CAP1r1110=\"Yes\"&CAP1r1130<>\"CAP3\", ",{"$f":"IF(AND(BL128=\"Yes\",BL130<>\"CAP3\"),BL289,BL109)","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,"","","     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,null,null,null,null,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":"BL124","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(BL351:BL354)","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5970,"Total Special Access Basket",null,"          N/A","          N/A","          N/A","          N/A",{"$f":"BE98+BE111+BE337+BE350","v":0},{"$f":"BF98+BF111+BF337+BF350","v":0},{"$f":"BG98+BG111+BG337+BG350","v":0},"    N/A",500,"Allowable Revenue Over-recovery/(Under-recovery)","r400-r130",{"$f":"ROUND(BL356-BL330,0)","v":0},{"$f":"IF(BL358>0,\"     Error:  Over-recovery. You must change some rates.\",IF(BL358<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,null,null,null,null,null,null,null,null,null,null,null,5980,"Total Special Access API",null,"          N/A","          N/A","          N/A","          N/A","          N/A","          N/A","          N/A",{"$f":"IF(AND(I41=0,BG358<>0),E41,IF(BF358=0,I41,I41*BG358/BF358))","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,5990,"Total Special Access PCI",null,"          N/A","          N/A","          N/A","          N/A","          N/A","          N/A","          N/A",{"$f":"$W$56","v":0},600,"Nonrecoverable from PICC and CCL","CAP1r950-CAP1r995",{"$f":"BL118-BL124","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,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,null,null,null,null,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,null,null,null,null,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,null,null,null,null,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(BL363=\"NA\",BL363=\"\"),IF(BL361<=0,0,MAX(0,MIN(BL361,AO29+AU29+AN44))),BL364)","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,"  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,null,null,null,null,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,null,null,null,null,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,null,null,null,null,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,null,null,null,null,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/2023"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,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,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 1 of 1",null,"           Footnotes"]