{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Rate Detail","Revenue Summary"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":41,"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":"Rate Detail","index":0,"n_rows":165,"n_cols":12,"rows_kept":165,"cut":false,"hidden":false,"merged":[[2,3,2,10]]}
[null,"RDET"]
[null,"Filing Entity:"]
[null,"Filing Date:","6/16/2023",{"$f":"B5","v":"June 16, 2023 Annual Filing (XXXXXX.XLS)"}]
[null,"Transmittal No.:"]
[null,"June 16, 2023 Annual Filing (XXXXXX.XLS)"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Demand","Demand",null,null,"Demand"]
[null,null,null,null,"Base Period","Current","Proposed","Times","Times",null,null,"Times"]
["RTE-1","Section","USOC","Rate Element","Demand","Rate","Rate","Current Rate","Proposed Rate",null,"Rates at Last PCI","Rates at Last PCI"]
[null,null,null,null,"(A)","(B)","(C)","(D) = A * B","(E) = A * C",null,"(F)","(G) = A * F"]
[null,null,null,"BASKET 1 - COMMON LINE"]
[]
[null,null,null,"SUBSCRIBER LINE CHARGE (SLC)"]
[106,"4.7",null,"SLC -  Multi-Line Business and Centrex",0,0,0,{"$f":"E17*F17","v":0},{"$f":"E17*G17","v":0},{"$f":"IF($I$27<>0,I17/$I$27,0)","v":0},0,{"$f":"E17*K17","v":0}]
[106,"4.7",null,"SLC -  ISDN PRI",0,0,{"$f":"G17","v":0},0,0,0,0,0]
[102,"4.7",null,"SLC -  Residence",0,0,0,0,0,0,0,0]
[102,"4.7",null,"SLC - Single Line Business",0,0,{"$f":"G19","v":0},0,0,0,0,0]
[102,"4.2",null,"SLC - Residential Lifeline",0,0,{"$f":"G19","v":0},0,0,0,0,0]
[104,"4.7",null,"SLC - Non-Primary Residence",0,0,0,0,0,0,0,0]
[104,"4.7",null,"SLC - ISDN BRI",0,0,{"$f":"G22","v":0},0,0,0,0,0]
[]
[108,"17.3.1","S25","Special Access Surcharge",0,0,{"$f":"+F25","v":0},{"$f":"E25*F25","v":0},{"$f":"E25*G25","v":0},{"$f":"IF($I$27<>0,I25/$I$27,0)","v":0},0,{"$f":"E25*K25","v":0}]
[]
[null,null,null,"  TOTAL END USER",null,null,null,{"$f":"SUM(H17:H25)","v":0},{"$f":"SUM(I17:I25)","v":0},{"$f":"IF($I$47<>0,I27/$I$47,0)","v":0},null,{"$f":"SUM(L17:L25)","v":0}]
[]
[null,null,null,"CARRIER COMMON LINE (CCL)"]
[161,"3.7.1","1010","CCL -  Premium Terminating",0,0,{"$f":"+F30","v":0},{"$f":"E30*F30","v":0},{"$f":"E30*G30","v":0},{"$f":"IF($I$40<>0,I30/$I$40,0)","v":0},0,{"$f":"E30*K30","v":0}]
[163,"3.7.1",1020,"CCL -  NonPremium Terminating",0,0,{"$f":"+F31","v":0},{"$f":"E31*F31","v":0},{"$f":"E31*G31","v":0},{"$f":"IF($I$40<>0,I31/$I$40,0)","v":0},0,{"$f":"E31*K31","v":0}]
[165,"3.7.1","1030","CCL -  Premium Originating",0,0,{"$f":"+F32","v":0},{"$f":"E32*F32","v":0},{"$f":"E32*G32","v":0},{"$f":"IF($I$40<>0,I32/$I$40,0)","v":0},0,{"$f":"E32*K32","v":0}]
[167,"3.7.1",1040,"CCL -  NonPremium Originating",0,0,{"$f":"+F33","v":0},{"$f":"E33*F33","v":0},{"$f":"E33*G33","v":0},{"$f":"IF($I$40<>0,I33/$I$40,0)","v":0},0,{"$f":"E33*K33","v":0}]
[]
[null,null,null,"PRESUBSCRIBED INTEREXCHANGE CARRIER CHARGE (PICC)"]
[155,"3.5",null,"PICC - Multi-Line Business",0,0,{"$f":"+F36","v":0},{"$f":"E36*F36","v":0},{"$f":"E36*G36","v":0},{"$f":"IF($I$40<>0,I36/$I$40,0)","v":0},0,{"$f":"E36*K36","v":0}]
[155,"3.5",null,"PICC - ISDN PRI",0,0,{"$f":"+F37","v":0},{"$f":"E37*F37","v":0},{"$f":"E37*G37","v":0},{"$f":"IF($I$40<>0,I37/$I$40,0)","v":0},0,{"$f":"E37*K37","v":0}]
[157,"3.5",null,"PICC - Business Centrex ",0,0,{"$f":"+F38","v":0},{"$f":"E38*F38","v":0},{"$f":"E38*G38","v":0},{"$f":"IF($I$40<>0,I38/$I$40,0)","v":0},0,{"$f":"E38*K38","v":0}]
[180,"3.5",null,"PICC - PayPhone",0,0,{"$f":"+F39","v":0},{"$f":"E39*F39","v":0},{"$f":"E39*G39","v":0},{"$f":"IF($I$40<>0,I39/$I$40,0)","v":0},0]
[null,null,null,"  TOTAL CARRIER COMMON LINE",null,null,null,{"$f":"SUM(H30:H39)","v":0},{"$f":"SUM(I30:I39)","v":0},{"$f":"IF($I$47<>0,I40/$I$47,0)","v":0},null,{"$f":"SUM(L30:L39)","v":0}]
[]
[null,null,null,"LINE PORTS IN EXCESS OF BASIC"]
[109,null,null,"ISDN Line Port BRI",0,0,{"$f":"+F43","v":0},{"$f":"E43*F43","v":0},{"$f":"E43*G43","v":0},{"$f":"IF($I$47<>0,I43/$I$47,0)","v":0},0,{"$f":"E43*K43","v":0}]
[109,null,null,"ISDN Line Port PRI",0,0,{"$f":"+F44","v":0},{"$f":"E44*F44","v":0},{"$f":"E44*G44","v":0},{"$f":"IF($I$47<>0,I44/$I$47,0)","v":0},0,{"$f":"E44*K44","v":0}]
[109,null,null,"DS1 Line Port",0,0,{"$f":"+F45","v":0},{"$f":"E45*F45","v":0},{"$f":"E45*G45","v":0},{"$f":"IF($I$47<>0,I45/$I$47,0)","v":0},0,{"$f":"E45*K45","v":0}]
[]
[null,null,null,"    TOTAL COMMON LINE",null,null,null,{"$f":"H27+H40+H43+H44+H45","v":0},{"$f":"I27+I40+I43+I44+I45","v":0},{"$f":"IF($I$165<>0,I47/$I$165,0)","v":0},null,{"$f":"L27+L40+L43+L44+L45","v":0}]
[]
[]
[]
[null,null,null," BASKET 4 - SPECIAL ACCESS"]
[]
[null,null,null,"** VoiceGrade/WATS**"]
[null,null,null,"VG DTT/EF NonDensity Zone"]
[null,null,null,"TELEGRAPH GRADE"]
[4141,"17.3.2.A","TGCT2","Telegraph (Sp) Channel Termination, 2-Wire",0,0,{"$f":"+F56","v":0},{"$f":"E56*F56","v":0},{"$f":"E56*G56","v":0},{"$f":"IF($I$73<>0,I56/$I$73,0)","v":0},0,{"$f":"E56*K56","v":0}]
[4141,"17.3.2.A","TGCT4","Telegraph (Sp) Channel Termination, 4-Wire",0,0,{"$f":"+F57","v":0},{"$f":"E57*F57","v":0},{"$f":"E57*G57","v":0},{"$f":"IF($I$73<>0,I57/$I$73,0)","v":0},0,{"$f":"E57*K57","v":0}]
[null,null,null,"VOICE GRADE"]
[4141,"17.3.3.A","VGT2","VG (Sp) Channel Termination, 2-Wire",0,0,{"$f":"+F59","v":0},{"$f":"E59*F59","v":0},{"$f":"E59*G59","v":0},{"$f":"IF($I$73<>0,I59/$I$73,0)","v":0},0,{"$f":"E59*K59","v":0}]
[4141,"17.3.3.A","VGT4","VG (Sp) Channel Termination, 4-Wire",0,0,0,{"$f":"E60*F60","v":0},{"$f":"E60*G60","v":0},0,0,0]
[4144,"17.3.3.C.1.a","VGB2","VG (Sp) Voice Bridging - 2-Wire",0,0,0,{"$f":"E61*F61","v":0},{"$f":"E61*G61","v":0},0,0,0]
[4144,"17.3.3.C.1.a","VGB4","VG (Sp) Voice Bridging - 4-Wire",0,0,0,0,0,0,0,0]
[4144,"17.3.3.C.1.b",null,"VG (Sp) Data Bridging 2-Wire",0,0,0,0,0,0,0,0]
[4144,"17.3.3.C.1.b",null,"VG (Sp) Data Bridging 4-Wire",0,0,0,0,0,0,0,0]
[4144,"17.3.3.C.2","VGC4","VG (Sp) Conditioning, C-Type",0,0,0,0,0,0,0,0]
[4144,"17.3.3.C.2","VGDC4","VG (Sp) Conditioning, Data Capability",0,0,0,0,0,0,0,0]
[4144,"17.3.3.C.3","VGRL2","VG (Sp) Improved Return Loss - 2-Wire",0,0,0,0,0,0,0,0]
[4144,"17.3.3.C.3","VGRL4","VG (Sp) Improved Return Loss - 4-Wire",0,0,0,0,0,0,0,0]
[4144,"17.3.3.C.6","VGSC","VG (Sp) Signaling Capability",0,0,0,0,0,0,0,0]
[null,null,null,"                VG  (Sp) Nonrecurring"]
[4144,"17.3.3.A","1760","VG (Sp) Channel Termination, 2-Wire, NRC",0,0,{"$f":"+F71","v":0},{"$f":"E71*F71","v":0},{"$f":"E71*G71","v":0},{"$f":"IF($I$73<>0,I71/$I$73,0)","v":0},0,{"$f":"E71*K71","v":0}]
[4144,"17.3.3.A","1765","VG (Sp) Channel Termination, 4-Wire, NRC",0,0,{"$f":"+F72","v":0},{"$f":"E72*F72","v":0},{"$f":"E72*G72","v":0},{"$f":"IF($I$73<>0,I72/$I$73,0)","v":0},0,{"$f":"E72*K72","v":0}]
[null,null,null,"  TOTAL VG/WATS/MET./TGPH ",null,null,null,{"$f":"SUM(H56:H72)","v":0},{"$f":"SUM(I56:I72)","v":0},{"$f":"IF($I$160<>0,I73/$I$160,0)","v":0},null,{"$f":"SUM(L56:L72)","v":0}]
[]
[4198,null,null,"VG/WATS/MET./TGPH - SP - SBI",null,0,{"$f":"IF(H73<>0,F75*I73/H73,F75)","v":0},null,null,null,0]
[4199,null,null,"  VG/WTS/MT/TG - SP - SBI Upper Limit",null,0,0,null,null,null,0]
[]
[null,null,null,"** AUDIO/VIDEO SERVICE CATEGORY SPECIAL  **"]
[null,null,null,"AUDIO/VIDEO Non Density Zone"]
[4361,"17.3.4.A","PAT3","PA (Sp)  Channel Term, 200-3500 Hz, Monthly",0,0,{"$f":"+F80","v":0},{"$f":"E80*F80","v":0},{"$f":"E80*G80","v":0},{"$f":"IF($I$89<>0,I80/$I$89,0)","v":0},0,{"$f":"E80*K80","v":0}]
[4361,"17.3.4.A","PAT5","PA (Sp)  Channel Term, 100-5000 Hz, Monthly",0,0,{"$f":"+F81","v":0},{"$f":"E81*F81","v":0},{"$f":"E81*G81","v":0},{"$f":"IF($I$89<>0,I81/$I$89,0)","v":0},0,{"$f":"E81*K81","v":0}]
[4361,"17.3.4.A","PAT8","PA (Sp)  Channel Term, 50-8000 Hz, Monthly",0,0,{"$f":"+F82","v":0},{"$f":"E82*F82","v":0},{"$f":"E82*G82","v":0},{"$f":"IF($I$89<>0,I82/$I$89,0)","v":0},0,{"$f":"E82*K82","v":0}]
[4361,"17.3.4.A","PAT15","PA (Sp)  Channel Term, 50-15000 Hz, Monthly",0,0,{"$f":"+F83","v":0},{"$f":"E83*F83","v":0},{"$f":"E83*G83","v":0},{"$f":"IF($I$89<>0,I83/$I$89,0)","v":0},0,{"$f":"E83*K83","v":0}]
[null,null,null,"               PA (Sp)  Nonrecurring"]
[4364,"17.3.4.A",null,"PA (Sp)  Installation, 200-3500 Hz, NRC",0,0,{"$f":"+F85","v":0},{"$f":"E85*F85","v":0},{"$f":"E85*G85","v":0},{"$f":"IF($I$89<>0,I85/$I$89,0)","v":0},0,{"$f":"E85*K85","v":0}]
[4364,"17.3.4.A",null,"PA (Sp)  Installation, 100-5000 Hz, NRC",0,0,{"$f":"+F86","v":0},{"$f":"E86*F86","v":0},{"$f":"E86*G86","v":0},{"$f":"IF($I$89<>0,I86/$I$89,0)","v":0},0,{"$f":"E86*K86","v":0}]
[4364,"17.3.4.A","2060","PA (Sp)  Installation, 50-8000 Hz, NRC",0,0,{"$f":"+F87","v":0},{"$f":"E87*F87","v":0},{"$f":"E87*G87","v":0},{"$f":"IF($I$89<>0,I87/$I$89,0)","v":0},0,{"$f":"E87*K87","v":0}]
[4364,"17.3.4.A","2160","PA (Sp)  Installation, 50-15000 Hz, NRC",0,0,{"$f":"+F88","v":0},{"$f":"E88*F88","v":0},{"$f":"E88*G88","v":0},{"$f":"IF($I$89<>0,I88/$I$89,0)","v":0},0,{"$f":"E88*K88","v":0}]
[null,null,null,"  TOTAL AUDIO/VIDEO - SP",null,null,null,{"$f":"SUM(H80:H88)","v":0},{"$f":"SUM(I80:I88)","v":0},{"$f":"IF($I$160<>0,I89/$I$160,0)","v":0},null,{"$f":"SUM(L80:L88)","v":0}]
[]
[4398,null,null,"AUDIO/VIDEO - SP - SBI",null,0,{"$f":"IF(H89<>0,F91*I89/H89,F91)","v":0},null,null,null,0]
[4399,null,null,"  AUDIO/VIDEO - SP - SBI Upper Limit",null,0,0,null,null,null,0]
[]
[null,null,null,"** HIGH CAP & DDS SERVICE CATEGORY  -  SPECIAL  **"]
[null,null,null,"DS1,  SPECIAL ACCESS"]
[4571,"17.3.7.A","HCTV","DS1 (Sp) (1.544 Mbps) Channel Termination, Monthly",0,0,{"$f":"+F96","v":0},{"$f":"E96*F96","v":0},{"$f":"E96*G96","v":0},{"$f":"IF($I$101<>0,I96/$I$101,0)","v":0},0,{"$f":"E96*K96","v":0}]
[4571,"17.3.7.A","HCTV36","DS1 (Sp) (1.544 Mbps) Channel Termination, 36 Months",0,0,{"$f":"ROUND(G96*0.9,2)","v":0},{"$f":"E97*F97","v":0},{"$f":"E97*G97","v":0},{"$f":"IF($I$101<>0,I97/$I$101,0)","v":0},0,{"$f":"E97*K97","v":0}]
[4571,"17.3.7.A","HCTV60","DS1 (Sp) (1.544 Mbps) Channel Termination, 60 Months",0,0,{"$f":"ROUND(G96*0.8,2)","v":0},{"$f":"E98*F98","v":0},{"$f":"E98*G98","v":0},{"$f":"IF($I$101<>0,I98/$I$101,0)","v":0},0,{"$f":"E98*K98","v":0}]
[null,null,null,"              DS1   (Sp) Nonrecurring"]
[4574,"17.3.7.A","3160","DS1 (Sp) Installation - 1.544 Mbps, NRC",0,0,{"$f":"+F100","v":0},{"$f":"E100*F100","v":0},{"$f":"E100*G100","v":0},{"$f":"IF($I$101<>0,I100/$I$101,0)","v":0},0,{"$f":"E100*K100","v":0}]
[null,null,null,"    TOTAL DS1 - SP - NON DENSITY ZONE",null,null,null,{"$f":"SUM(H96:H100)","v":0},{"$f":"SUM(I96:I100)","v":0},{"$f":"IF($I$160<>0,I101/$I$160,0)","v":0},null,{"$f":"SUM(L96:L100)","v":0}]
[]
[4598,null,null,"DS1 SPECIAL - SBI",null,0,{"$f":"IF(H101<>0,F103*I101/H101,F103)","v":0},null,null,null,0]
[4599,null,null,"  DS1- Sub-SBI Upper Limit",null,0,0,null,null,null,0]
[]
[null,null,null,"DS3, SPECIAL ACCESS"]
[4771,"17.3.7.A","HCT3","DS3 (Sp) Channel Termination - Monthly",0,0,{"$f":"+F107","v":0},{"$f":"E107*F107","v":0},{"$f":"E107*G107","v":0},{"$f":"IF($I$113<>0,I107/$I$113,0)","v":0},0,{"$f":"E107*K107","v":0}]
[4771,"17.3.7.A","HCT336","DS3 (Sp) Channel Termination - 36 Months",0,0,{"$f":"ROUND(G107*0.9,2)","v":0},{"$f":"E108*F108","v":0},{"$f":"E108*G108","v":0},{"$f":"IF($I$113<>0,I108/$I$113,0)","v":0},0,{"$f":"E108*K108","v":0}]
[4771,"17.3.7.A","HCT360","DS3 (Sp) Channel Termination - 60 Months",0,0,{"$f":"ROUND(G107*0.8,2)","v":0},{"$f":"E109*F109","v":0},{"$f":"E109*G109","v":0},{"$f":"IF($I$113<>0,I109/$I$113,0)","v":0},0,{"$f":"E109*K109","v":0}]
[4771,"17.3.7.A",null,"DS3 (Sp) Channel Termination - Fixed Rate Plan",0,0,{"$f":"ROUND(G107*(1-0.21),2)","v":0},{"$f":"E110*F110","v":0},{"$f":"E110*G110","v":0},{"$f":"IF($I$113<>0,I110/$I$113,0)","v":0},0,{"$f":"E110*K110","v":0}]
[null,null,null,"        DS3  (Sp) Nonrecurring"]
[4774,"17.3.7.A","3475","DS3 (Sp) Channel Termination, NRC, Monthly",0,0,{"$f":"+F112","v":0},{"$f":"E112*F112","v":0},{"$f":"E112*G112","v":0},{"$f":"IF($I$113<>0,I112/$I$113,0)","v":0},0,{"$f":"E112*K112","v":0}]
[null,null,null,"    TOTAL DS3 - SP - NON DENSITY ZONE",null,null,null,{"$f":"SUM(H107:H112)","v":0},{"$f":"SUM(I107:I112)","v":0},{"$f":"IF($I$160<>0,I113/$I$160,0)","v":0},null,{"$f":"SUM(L107:L112)","v":0}]
[]
[4798,null,null,"TOTAL DS3 - SP - SBI",null,0,{"$f":"IF(H113<>0,F115*I113/H113,F115)","v":0},null,null,null,0]
[4799,null,null,"  TOTAL DS3- SP - Sub-SBI Upper Limit",null,0,105.10060625003196,null,null,null,0]
[]
[null,null,null,"DDS and Other Non Density Zone - Special:"]
[4971,"17.3.6.A","DAT2","DDS (Sp)  Channel Termination - 2.4 kbps",0,0,{"$f":"+F119","v":0},{"$f":"E119*F119","v":0},{"$f":"E119*G119","v":0},{"$f":"IF($I$153<>0,I119/$I$153,0)","v":0},0,{"$f":"E119*K119","v":0}]
[4971,"17.3.6.A","DAT4","DDS (Sp)  Channel Termination - 4.8 kbps",0,0,0,0,0,0,0,0]
[4971,"17.3.6.A","DAT9","DDS (Sp)  Channel Termination - 9.6 kbps",0,0,0,0,0,0,0,0]
[4971,"17.3.6.A","DAT19","DDS (Sp)  Channel Termination - 19.2 kbps",0,0,0,0,0,0,0,0]
[4971,"17.3.6.A","DAT5","DDS (Sp)  Channel Termination - 56.0 kbps",0,0,0,0,0,0,0,0]
[4971,"17.3.6.A","DAT64","DDS (Sp)  Channel Termination - 64.0 kbps",0,0,0,0,0,0,0,0]
[4974,"17.3.6.C.1","DAB2+DAB4+DAB9+DAB19+DAB5+DAB64","DDS (Sp)  Bridging, per Port",0,0,0,0,0,0,0,0]
[null,null,null,"        DDS & Other  (Sp) Nonrecurring"]
[4974,"17.3.6.A","2635","DDS (Sp)  Channel Termination,  2.4 kbps, NRC",0,0,{"$f":"+F127","v":0},{"$f":"E127*F127","v":0},{"$f":"E127*G127","v":0},{"$f":"IF($I$153<>0,I127/$I$153,0)","v":0},0,{"$f":"E127*K127","v":0}]
[4974,"17.3.6.A","2730","DDS (Sp)  Channel Termination, 4.8 kbps, NRC",0,0,0,0,0,0,0,0]
[4974,"17.3.6.A","2840","DDS (Sp)  Channel Termination, 9.6 kbps, NRC",0,0,0,0,0,0,0,0]
[4974,"17.3.6.A","2974","DDS (Sp)  Channel Termination, 19.2 kbps, NRC",0,0,0,0,0,0,0,0]
[4974,"17.3.6.A","2940","DDS (Sp)  Channel Termination, 56.0 kbps, NRC",0,0,0,0,0,0,0,0]
[4974,"17.3.6.A","2994","DDS (Sp)  Channel Termination, 64.0 kbps, NRC",0,0,0,0,0,0,0,0]
[4974,"17.4.8.B.4.a.iii","AOC","Access Ordering Charge, NRC",0,0,0,0,0,0,0,0]
[4974,"17.4.1.B","SDCC","Service Date Change Charge, NRC",0,0,0,0,0,0,0,0]
[4974,"17.4.1.C","DCC","Design Change Charge, NRC",0,0,0,0,0,0,0,0]
[4974,"17.4.1.D","MSOC","Miscellaneous Service Order Charge, NRC",0,0,0,0,0,0,0,0]
[4974,"17.4.1.E","EXP","Expedited Order Charge",0,0,0,0,0,{"$f":"IF(#REF!<>0,I137/#REF!,0)","v":{"$error":"#REF!"}},0,0]
[4974,null,null,"Add'l Labor - Expedite Charge - Basic Time, per Engineer (each 1/2 hour), NRC"]
[4974,"17.4.2.A",null,"Add'l Engineering - Basic Time, per Engineer (each 1/2 hour), NRC",0,0,{"$f":"+F139","v":0},0,0,{"$f":"IF($I$153<>0,I139/$I$153,0)","v":0},0,0]
[4974,"17.4.2.B",null,"Add'l Engineering - Overtime, per Engineer (each 1/2 hour), NRC",0,0,0,0,0,0,0,0]
[4974,"17.4.2.C",null,"Add'l Engineering - Premium, per Engineer (each 1/2 hour), NRC",0,0,0,0,0,0,0,0]
[4974,"17.4.3.A",null,"Add'l Labor - Install. Or Repair, Overtime (each 1/2 hour), NRC",0,0,0,0,0,0,0,0]
[4974,"17.4.3.A",null,"Add'l Labor - Install. Or Repair, Premium Time (each 1/2 hour), NRC",0,0,0,0,0,0,0,0]
[4974,"17.4.3.B",null,"Add'l Labor - Standby, Basic Time (each 1/2 hour), NRC",0,0,0,0,0,0,0,0]
[4974,"17.4.3.B",null,"Add'l Labor - Standby, Overtime (each 1/2 hour), NRC",0,0,0,0,0,0,0,0]
[4974,"17.4.3.B",null,"Add'l Labor - Standby, Premium Time (each 1/2 hour), NRC",0,0,0,0,0,0,0,0]
[4974,"17.4.3.C","IRTECHB","Add'l Labor - Test and Main. w/ other TELCO, Basic Time (each 1/2 Hr) Install/Repr Tech, NRC",0,0,0,0,0,0,0,0]
[4974,"17.4.3.C","IRTECHO","Add'l Labor - Test and Main. w/ other TELCO, Overtime (each 1/2 Hr) Install/Repr Tech, NRC",0,0,0,0,0,0,0,0]
[4974,"17.4.3.C","IRTECHP","Add'l Labor - Test and Main. w/ other TELCO, Premium Time (each 1/2 Hr) Install/Repr Tech, NRC",0,0,0,0,0,0,0,0]
[4974,"17.4.3.C","COTECHB","Add'l Labor - Test and Main. w/ other TELCO, Basic Time (each 1/2 Hr) CO Main Tech, NRC",0,0,0,0,0,0,0,0]
[4974,"17.4.3.C","COTECHO","Add'l Labor - Test and Main. w/ other TELCO, Overtime (each 1/2 Hr) CO Main Tech, NRC",0,0,0,0,0,0,0,0]
[4974,"17.4.3.C","COTECHP","Add'l Labor - Test and Main. w/ other TELCO, Premium Time (each 1/2 Hr) CO Main Tech, NRC",0,0,0,0,0,0,0,0]
[null,null,null,"  TOTAL DIGITAL DATA - SP",null,0,0,{"$f":"SUM(H119:H152)","v":0},{"$f":"SUM(I119:I152)","v":0},{"$f":"IF($I$160<>0,I153/$I$160,0)","v":0},null,{"$f":"SUM(L119:L152)","v":0}]
[]
[null,null,null,"    TOTAL HIGH CAP & DDS - SP",null,null,null,{"$f":"H101+H113+H153","v":0},{"$f":"I101+I113+I153","v":0},{"$f":"IF($I$160<>0,I155/$I$160,0)","v":0},null,{"$f":"L101+L113+L153","v":0}]
[]
[4998,null,null,"HIGH CAP & DDS - SP - SBI",null,0,{"$f":"IF(H155<>0,F157*I155/H155,F157)","v":0},null,null,null,0]
[4999,null,null,"  HC & DDS - SP - SBI Upper Limit",null,0,0,null,null,null,0]
[]
[null,null,null,"TOTAL SPECIAL ACCESS BASKET",null,null,null,{"$f":"+H155+H89+H73","v":0},{"$f":"+I155+I89+I73","v":0},{"$f":"IF($I$165<>0,I160/$I$165,0)","v":0},null,{"$f":"+L155+L89+L73","v":0}]
[]
[5980,null,null,"TOTAL SPECIAL ACCESS API",null,0,{"$f":"IF(H160<>0,F162*I160/H160,F162)","v":0},null,null,null,0]
[5990,null,null,"TOTAL SPECIAL ACCESS PCI",null,0,0,null,null,null,0]
[]
[null,null,null,"TOTAL PRICE CAP",null,null,null,{"$f":"H160+H47","v":0},{"$f":"I160+I47","v":0},null,null,{"$f":"L160+L47","v":0}]

{"sheet":"Revenue Summary","index":1,"n_rows":43,"n_cols":7,"rows_kept":43,"cut":false,"hidden":false,"merged":[[3,0,3,5],[4,2,4,4],[45,2,45,4]]}
[{"$f":"'Rate Detail'!B3&\"     \"&'Rate Detail'!C3","v":"Filing Date:     6/16/2023"},null,null,null,"Workpaper Revenue Summary"]
[{"$f":"'Rate Detail'!B2&\"     \"&'Rate Detail'!C2","v":"Filing Entity:     "}]
[{"$f":"'Rate Detail'!B4&\"   \"&'Rate Detail'!C4","v":"Transmittal No.:   "}]
[{"$f":"'Rate Detail'!B5","v":"June 16, 2023 Annual Filing (XXXXXX.XLS)"}]
[]
[null,null,"Demand","Demand","Demand"]
[null,null,"Times","Times","Times",null,"%"]
[null,null,"Rates @ Last PCI","Current Rate","Proposed Rate","Difference","Difference"]
[null,"Common Line"]
[102,"Primary Res, Single Line Bus, Lifeline EUCL ",{"$f":"SUMIFSS('Rate Detail'!A:A,A10,'Rate Detail'!L:L)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A10,'Rate Detail'!$H:$H)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A10,'Rate Detail'!$I:$I)","v":0},{"$f":"+E10-D10","v":0},{"$f":"IF(C10<>0,+F10/C10,0)","v":0}]
[104,"NonPrimary Residence & BRI ISDN EUCL ",{"$f":"SUMIFSS('Rate Detail'!A:A,A11,'Rate Detail'!L:L)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A11,'Rate Detail'!$H:$H)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A11,'Rate Detail'!$I:$I)","v":0},0,{"$f":"IF(C11<>0,+F11/C11,0)","v":0}]
[106,"Multiline Bus, PRI ISDN, Centrex EUCL ",{"$f":"SUMIFSS('Rate Detail'!A:A,A12,'Rate Detail'!L:L)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A12,'Rate Detail'!$H:$H)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A12,'Rate Detail'!$I:$I)","v":0},0,{"$f":"IF(C12<>0,+F12/C12,0)","v":0}]
[108,"Special Access Surcharge",{"$f":"SUMIFSS('Rate Detail'!A:A,A13,'Rate Detail'!L:L)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A13,'Rate Detail'!$H:$H)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A13,'Rate Detail'!$I:$I)","v":0},0,{"$f":"IF(C13<>0,+F13/C13,0)","v":0}]
[109,"Other EUCL",{"$f":"SUMIFSS('Rate Detail'!A:A,A14,'Rate Detail'!L:L)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A14,'Rate Detail'!$H:$H)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A14,'Rate Detail'!$I:$I)","v":0},0,0]
[null,"EUCL Revenues",{"$f":"SUM(C10:C14)","v":0},{"$f":"SUM(D10:D14)","v":0},{"$f":"SUM(E10:E14)","v":0},0,0]
[155,"Multiline Business & PRI ISDN PICC          ",{"$f":"SUMIFSS('Rate Detail'!A:A,A16,'Rate Detail'!L:L)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A16,'Rate Detail'!$H:$H)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A16,'Rate Detail'!$I:$I)","v":0},0,0]
[157,"Business Centrex PICC",{"$f":"SUMIFSS('Rate Detail'!A:A,A17,'Rate Detail'!L:L)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A17,'Rate Detail'!$H:$H)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A17,'Rate Detail'!$I:$I)","v":0},0,0]
[185,"USAC Receipts",{"$f":"SUMIFSS('Rate Detail'!A:A,A18,'Rate Detail'!L:L)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A18,'Rate Detail'!$H:$H)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A18,'Rate Detail'!$I:$I)","v":0},0,0]
[null,"Total Common Line Revenue",{"$f":"SUM(C15:C18)","v":0},{"$f":"SUM(D15:D18)","v":0},{"$f":"SUM(E15:E18)","v":0},0,0]
[]
[300,"Total IX Basket",{"$f":"SUMIFSS('Rate Detail'!A:A,A21,'Rate Detail'!L:L)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A21,'Rate Detail'!$H:$H)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A21,'Rate Detail'!$I:$I)","v":0},0,0]
[]
[null,"Special Access"]
[414,"Voice Grade",{"$f":"SUMIFSS('Rate Detail'!A:A,A24,'Rate Detail'!L:L)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A24,'Rate Detail'!$H:$H)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A24,'Rate Detail'!$I:$I)","v":0},{"$f":"+E24-C24","v":0},{"$f":"IF(C24<>0,+F24/C24,0)","v":0}]
[436,"Audio/Video",{"$f":"SUMIFSS('Rate Detail'!A:A,A25,'Rate Detail'!L:L)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A25,'Rate Detail'!$H:$H)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A25,'Rate Detail'!$I:$I)","v":0},0,0]
[null,"Hi-Cap",{"$f":"C27+C28+C34","v":0},{"$f":"D27+D28+D34","v":0},{"$f":"E27+E28+E34","v":0},0,0]
[497,"   DDS & Other High Cap",{"$f":"SUMIFSS('Rate Detail'!A:A,A27,'Rate Detail'!L:L)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A27,'Rate Detail'!$H:$H)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A27,'Rate Detail'!$I:$I)","v":0},0,0]
[null,"   DS1",{"$f":"SUM(C29:C33)","v":0},{"$f":"SUM(D29:D33)","v":0},{"$f":"SUM(E29:E33)","v":0},0,0]
[457,"       DS1 Non-Zoned",{"$f":"SUMIFSS('Rate Detail'!A:A,A29,'Rate Detail'!L:L)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A29,'Rate Detail'!$H:$H)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A29,'Rate Detail'!$I:$I)","v":0},0,0]
[440,"       DS1 Rate Zone 1",{"$f":"SUMIFSS('Rate Detail'!A:A,A30,'Rate Detail'!L:L)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A30,'Rate Detail'!$H:$H)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A30,'Rate Detail'!$I:$I)","v":0},0,0]
[442,"       DS1 Rate Zone 2",{"$f":"SUMIFSS('Rate Detail'!A:A,A31,'Rate Detail'!L:L)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A31,'Rate Detail'!$H:$H)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A31,'Rate Detail'!$I:$I)","v":0},0,0]
[444,"       DS1 Rate Zone 3",{"$f":"SUMIFSS('Rate Detail'!A:A,A32,'Rate Detail'!L:L)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A32,'Rate Detail'!$H:$H)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A32,'Rate Detail'!$I:$I)","v":0},0,0]
[446,"       DS1 Rate Zone 4",{"$f":"SUMIFSS('Rate Detail'!A:A,A33,'Rate Detail'!L:L)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A33,'Rate Detail'!$H:$H)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A33,'Rate Detail'!$I:$I)","v":0},0,0]
[null,"   DS3",{"$f":"SUM(C35:C39)","v":0},{"$f":"SUM(D35:D39)","v":0},{"$f":"SUM(E35:E39)","v":0},0,0]
[477,"      DS3 Non-Zoned",{"$f":"SUMIFSS('Rate Detail'!A:A,A35,'Rate Detail'!L:L)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A35,'Rate Detail'!$H:$H)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A35,'Rate Detail'!$I:$I)","v":0},0,0]
[460,"      DS3 Rate Zone 1",{"$f":"SUMIFSS('Rate Detail'!A:A,A36,'Rate Detail'!L:L)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A36,'Rate Detail'!$H:$H)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A36,'Rate Detail'!$I:$I)","v":0},0,0]
[462,"      DS3 Rate Zone 2",{"$f":"SUMIFSS('Rate Detail'!A:A,A37,'Rate Detail'!L:L)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A37,'Rate Detail'!$H:$H)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A37,'Rate Detail'!$I:$I)","v":0},0,0]
[464,"      DS3 Rate Zone 3",{"$f":"SUMIFSS('Rate Detail'!A:A,A38,'Rate Detail'!L:L)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A38,'Rate Detail'!$H:$H)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A38,'Rate Detail'!$I:$I)","v":0},0,0]
[466,"      DS3 Rate Zone 4",{"$f":"SUMIFSS('Rate Detail'!A:A,A39,'Rate Detail'!L:L)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A39,'Rate Detail'!$H:$H)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A39,'Rate Detail'!$I:$I)","v":0},0,0]
[517,"Wideband",{"$f":"SUMIFSS('Rate Detail'!A:A,A40,'Rate Detail'!L:L)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A40,'Rate Detail'!$H:$H)","v":0},{"$f":"SUMIFSS('Rate Detail'!$A:$A,$A40,'Rate Detail'!$I:$I)","v":0},0,0]
[null,"TOTAL SPECIAL ACCESS BASKET",{"$f":"C24+C25+C26+C40","v":0},{"$f":"D24+D25+D26+D40","v":0},{"$f":"E24+E25+E26+E40","v":0},0,0]
[]
[null,"Total",{"$f":"C41+C21+C19","v":0},{"$f":"D41+D21+D19","v":0},{"$f":"E41+E21+E19","v":0},{"$f":"+E43-C43","v":0},{"$f":"IF(C43<>0,+F43/C43,0)","v":0}]