{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Menu","True Up Calc","Summary by Study Area","Footnotes"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":17,"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":"Menu","index":0,"n_rows":3,"n_cols":11,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,"KEY (Erase text & color before filing):"]
[null,null,null,null,null,null,null,null,null,null,"Label / Date Change"]

{"sheet":"True Up Calc","index":1,"n_rows":241,"n_cols":27,"rows_kept":241,"cut":false,"hidden":false,"merged":[[11,16,11,26],[8,7,9,7],[11,2,11,8],[12,24,12,26],[12,10,12,12],[12,2,13,2],[11,9,11,15],[12,9,13,9],[12,3,12,5],[12,6,12,8],[3,5,7,5],[3,6,7,6],[3,7,7,7],[8,5,9,5],[8,6,9,6],[12,0,13,0],[12,1,13,1],[12,16,12,19],[12,20,12,23],[12,13,12,15]]}
["Filing Date (enter w/leading '):",null,null,"2021-06-16",null,null,null,null,"ARC-TUP"]
["Holding Company:"]
["Filing Name:"]
[null,null,null,null,null,"51.915(b)(4) Expected Revenues for ARC","51.915(b)(13) True Up Revenues for ARC","51.915(d)(1)(viii) Eligible Recovery: True-up Revenues for ARC less Expected Revenues "]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"SUMIF(C:C,\"Total\",G:G)+SUMIF(C:C,\"Total\",N:N)+SUMIF(C:C,\"Total\",Y:Y)","v":0},{"$f":"SUMIF(C:C,\"Total\",H:H)+SUMIF(C:C,\"Total\",O:O)+SUMIF(C:C,\"Total\",Z:Z)","v":0},{"$f":"F9-G9","v":0}]
[]
[null,null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y"]
[null,null,"Primary/Non Primary Residential",null,null,null,null,null,null,"SLB / BRI",null,null,null,null,null,null,"MLB"]
["Study Area","Exchanges","Actual Tariff Rates","Lines",null,null,"Revenue",null,null,"Actual Tariff Rates","Lines",null,null,"Revenue",null,null,"Non-Centrex Lines",null,null,null,"Centrex Lines",null,null,null,"Revenue"]
[null,null,null,"ARC Eligible Tariff Period Projected Lines","ARC Eligible Tariff Period Actual Lines","Difference","ARC Eligible Tariff Period Projected Revenue","ARC Eligible Tariff Period True Up Revenue","Difference",null,"ARC Eligible Tariff Period Projected Lines","ARC Eligible Tariff Period Actual Lines","Difference","ARC Eligible Tariff Period Projected Revenue","ARC Eligible Tariff Period True Up Revenue","Difference","Actual Tariff Rates","ARC Eligible Tariff Period Projected Lines","ARC Eligible Tariff Period Actual Lines","Difference","Actual Tariff Rates","ARC Eligible Tariff Period Projected Lines","ARC Eligible Tariff Period Actual Lines","Difference","ARC Eligible Tariff Period Projected Revenue","ARC Eligible Tariff Period True Up Revenue","Difference"]
[null,null,"A","B","C","D = C - B","E = A * B","F = A* C","G = F - E","H","I","J","K = J - I","L = H * I","M = H * J","N = M - L","O","P","Q","R = Q - P","S","T","U","V = U - T","W = O * P +  S * T","X = O * Q + S * U","Y = X - W"]
["S1StudyArea","Example 1",0,0,0,{"$f":"E16-D16","v":0},{"$f":"C16*D16","v":0},{"$f":"C16*E16","v":0},{"$f":"H16-G16","v":0},0,0,0,{"$f":"L16-K16","v":0},{"$f":"J16*K16","v":0},{"$f":"J16*L16","v":0},{"$f":"O16-N16","v":0},0,0,0,{"$f":"S16-R16","v":0},0,0,0,{"$f":"W16-V16","v":0},{"$f":"Q16*R16+U16*V16","v":0},{"$f":"Q16*S16+U16*W16","v":0},{"$f":"Z16-Y16","v":0}]
["S1StudyArea","Example 2",0,0,0,{"$f":"E17-D17","v":0},{"$f":"C17*D17","v":0},{"$f":"C17*E17","v":0},{"$f":"H17-G17","v":0},0,0,0,{"$f":"L17-K17","v":0},{"$f":"J17*K17","v":0},{"$f":"J17*L17","v":0},{"$f":"O17-N17","v":0},0,0,0,{"$f":"S17-R17","v":0},0,0,0,{"$f":"W17-V17","v":0},{"$f":"Q17*R17+U17*V17","v":0},{"$f":"Q17*S17+U17*W17","v":0},{"$f":"Z17-Y17","v":0}]
["S1StudyArea","Example 3",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S1StudyArea","Example 4",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S1StudyArea","Example 5",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S1StudyArea","Example 7",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S1StudyArea","Example 8",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S1StudyArea","Example 9",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S1StudyArea","Example 10",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S1StudyArea","Example 11",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S1StudyArea","Example 12",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S1StudyArea","Example 13",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S2StudyArea","Example 1",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S2StudyArea","Example 2",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 1",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 2",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 3",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 4",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 5",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 6",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 7",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 8",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 9",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 10",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 11",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 12",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 13",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 14",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 15",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 16",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 17",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 18",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 19",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 20",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 21",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 22",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 23",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 24",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 25",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 26",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 27",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 28",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 29",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 30",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 31",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 32",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 33",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 34",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 35",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 36",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 37",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 38",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 39",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 40",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 41",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 42",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 43",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 44",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 45",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 46",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 47",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 48",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 49",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 50",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 51",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 52",0,0,0,{"$f":"E81-D81","v":0},{"$f":"C81*D81","v":0},{"$f":"C81*E81","v":0},{"$f":"H81-G81","v":0},0,0,0,{"$f":"L81-K81","v":0},{"$f":"J81*K81","v":0},{"$f":"J81*L81","v":0},{"$f":"O81-N81","v":0},0,0,0,{"$f":"S81-R81","v":0},0,0,0,{"$f":"W81-V81","v":0},{"$f":"Q81*R81+U81*V81","v":0},{"$f":"Q81*S81+U81*W81","v":0},{"$f":"Z81-Y81","v":0}]
["S3StudyArea","Example 53",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 54",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 55",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 56",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 57",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 58",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 59",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 60",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 61",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 62",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 63",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 64",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 65",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 66",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 67",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 68",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 69",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 70",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 71",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 72",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 73",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 74",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 75",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 76",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 77",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 78",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 79",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 80",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 81",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 82",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 83",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 84",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 85",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 86",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 87",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 88",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 89",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 90",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 91",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 92",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 93",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 94",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 95",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 96",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 97",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 98",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 99",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 100",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 101",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 102",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 103",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 104",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 105",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 106",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 107",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 108",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 109",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 110",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 111",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 112",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 113",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 114",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 115",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 116",0,0,0,{"$f":"E145-D145","v":0},{"$f":"C145*D145","v":0},{"$f":"C145*E145","v":0},{"$f":"H145-G145","v":0},0,0,0,{"$f":"L145-K145","v":0},{"$f":"J145*K145","v":0},{"$f":"J145*L145","v":0},{"$f":"O145-N145","v":0},0,0,0,{"$f":"S145-R145","v":0},0,0,0,{"$f":"W145-V145","v":0},{"$f":"Q145*R145+U145*V145","v":0},{"$f":"Q145*S145+U145*W145","v":0},{"$f":"Z145-Y145","v":0}]
["S3StudyArea","Example 117",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 118",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 119",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 120",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 121",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 122",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 123",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 124",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 125",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 126",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 127",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 128",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 129",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 130",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 131",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 132",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 133",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 134",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 135",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 136",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 137",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 138",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 139",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 140",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 141",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 142",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 143",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 144",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 145",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 146",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 147",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 148",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 149",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 150",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 151",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 152",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 153",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 154",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 155",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 156",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 157",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 158",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 159",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 160",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 161",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 162",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 163",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 164",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 165",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 166",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 167",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 168",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 169",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 170",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 171",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 172",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 173",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 174",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 175",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 176",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 177",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 178",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 179",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 180",0,0,0,{"$f":"E209-D209","v":0},{"$f":"C209*D209","v":0},{"$f":"C209*E209","v":0},{"$f":"H209-G209","v":0},0,0,0,{"$f":"L209-K209","v":0},{"$f":"J209*K209","v":0},{"$f":"J209*L209","v":0},{"$f":"O209-N209","v":0},0,0,0,{"$f":"S209-R209","v":0},0,0,0,{"$f":"W209-V209","v":0},{"$f":"Q209*R209+U209*V209","v":0},{"$f":"Q209*S209+U209*W209","v":0},{"$f":"Z209-Y209","v":0}]
["S3StudyArea","Example 181",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 182",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 183",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 184",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 185",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 186",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 187",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 188",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 189",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 190",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 191",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 192",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 193",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 194",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 195",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 196",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 197",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 198",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 199",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 200",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 201",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 202",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 203",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 204",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 205",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S3StudyArea","Example 206",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S4StudyArea","Example 1",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S4StudyArea","Example 2",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["S4StudyArea","Example 3",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"V238","v":0},0,0,0,0]
[]
[]
[null,null,"Total",{"$f":"SUM(D16:D239)","v":0},0,0,0,0,0,null,{"$f":"SUM(K16:K239)","v":0},0,0,0,0,0,null,{"$f":"SUM(R16:R239)","v":0},{"$f":"SUM(S16:S239)","v":0},{"$f":"SUM(T16:T239)","v":0},null,{"$f":"SUM(V16:V239)","v":0},0,0,0,0,0]

{"sheet":"Summary by Study Area","index":2,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[[9,0,9,4]]}
["Filing Date (enter w/leading '):","2021-06-12",null,null,"ARC-TUP"]
["Holding Company:"]
["Filing Name:"]
[]
[]
[]
[]
[]
[]
["Summary by Study Area"]
["Study Area Names","Study Area","51.915(b)(4) Expected Revenues for ARC","51.915(b)(13) True Up Revenues for ARC","51.915(d)(1)(viii) Eligible Recovery: True-up Revenues for ARC less Expected Revenues "]
["State 1 Telephone Co","S1StudyArea",{"$f":"SUMIF('True Up Calc'!A:A,B12,'True Up Calc'!G:G)+SUMIF('True Up Calc'!A:A,B12,'True Up Calc'!N:N)+SUMIF('True Up Calc'!A:A,B12,'True Up Calc'!Y:Y)","v":0},{"$f":"SUMIF('True Up Calc'!A:A,B12,'True Up Calc'!H:H)+SUMIF('True Up Calc'!A:A,B12,'True Up Calc'!O:O)+SUMIF('True Up Calc'!A:A,B12,'True Up Calc'!Z:Z)","v":0},{"$f":"C12-D12","v":0}]
["State 2 Telephone Co.","S2StudyArea",{"$f":"SUMIF('True Up Calc'!A:A,B13,'True Up Calc'!G:G)+SUMIF('True Up Calc'!A:A,B13,'True Up Calc'!N:N)+SUMIF('True Up Calc'!A:A,B13,'True Up Calc'!Y:Y)","v":0},{"$f":"SUMIF('True Up Calc'!A:A,B13,'True Up Calc'!H:H)+SUMIF('True Up Calc'!A:A,B13,'True Up Calc'!O:O)+SUMIF('True Up Calc'!A:A,B13,'True Up Calc'!Z:Z)","v":0},{"$f":"C13-D13","v":0}]
["State 3 Telephone Co","S3StudyArea",{"$f":"SUMIF('True Up Calc'!A:A,B14,'True Up Calc'!G:G)+SUMIF('True Up Calc'!A:A,B14,'True Up Calc'!N:N)+SUMIF('True Up Calc'!A:A,B14,'True Up Calc'!Y:Y)","v":0},{"$f":"SUMIF('True Up Calc'!A:A,B14,'True Up Calc'!H:H)+SUMIF('True Up Calc'!A:A,B14,'True Up Calc'!O:O)+SUMIF('True Up Calc'!A:A,B14,'True Up Calc'!Z:Z)","v":0},{"$f":"C14-D14","v":0}]
["State 4 Telephone Co","S4StudyArea",{"$f":"SUMIF('True Up Calc'!A:A,B15,'True Up Calc'!G:G)+SUMIF('True Up Calc'!A:A,B15,'True Up Calc'!N:N)+SUMIF('True Up Calc'!A:A,B15,'True Up Calc'!Y:Y)","v":0},{"$f":"SUMIF('True Up Calc'!A:A,B15,'True Up Calc'!H:H)+SUMIF('True Up Calc'!A:A,B15,'True Up Calc'!O:O)+SUMIF('True Up Calc'!A:A,B15,'True Up Calc'!Z:Z)","v":0},{"$f":"C15-D15","v":0}]
[]
[]
[]
[null,"Total",{"$f":"SUM(C12:C17)","v":0},{"$f":"SUM(D12:D17)","v":0},{"$f":"SUM(E12:E17)","v":0}]

{"sheet":"Footnotes","index":3,"n_rows":5,"n_cols":11,"rows_kept":5,"cut":false,"hidden":false,"merged":[[4,0,4,10]]}
["Filing Date (enter w/leading '):",null,null,"2021-06-16",null,null,null,null,null,null,"ARC-CAF-4"]
["Holding Company:"]
["Filing Name:"]
[]
["FOOTNOTES:"]