{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Summary","3005a BalanceSheet","3005b IncomeStatement","3005c Cashflow","3005a Hidden","3005b Hidden","3005c Hidden"],"not_rendered":{"images":6,"macros":1,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":18,"n_cols":9,"rows_kept":18,"merged":[[0,5,0,8],[6,0,6,1],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[12,5,12,8]]}
[{"$nulls":5},"Mandatory fields that are blank"]
[{"$nulls":5},"Worksheet","Input Item","Line Item","Error Status"]
[{"$nulls":5},"3005a BalanceSheet","Study Area Code","<010>",{"$f":"IF(LEN('3005a BalanceSheet'!F5)=0,G3&\" can not be blank\",\"OK\")","v":"Study Area Code can not be blank"}]
[{"$nulls":5},"3005a BalanceSheet","Study Area Name","<015>",{"$f":"IF(LEN('3005a BalanceSheet'!F6)=0,G4&\" can not be blank\",\"OK\")","v":"Study Area Name can not be blank"}]
[{"$nulls":5},"3005a BalanceSheet","Program Year","<020>",{"$f":"IF(LEN('3005a BalanceSheet'!F7)=0,G5&\" can not be blank\",\"OK\")","v":"Program Year can not be blank"}]
[{"$nulls":5},"3005a BalanceSheet","Contact Name - Person USAC should contact regarding this data","<030>",{"$f":"IF(LEN('3005a BalanceSheet'!F8)=0,G6&\" can not be blank\",\"OK\")","v":"Contact Name - Person USAC should contact regarding this data can not be blank"}]
[null,null,"Number of fields with invalid data",null,null,"3005a BalanceSheet","Contact Telephone Number - Number of person identified in data line <030>","<035>",{"$f":"IF(LEN('3005a BalanceSheet'!F9)=0,G7&\" can not be blank\",\"OK\")","v":"Contact Telephone Number - Number of person identified in data line <030> can not be blank"}]
["3005a BalanceSheet",null,{"$f":"COUNTIF('3005a Hidden'!C:D,\"Invalid\")+COUNTIF('3005a Hidden'!G:H,\"Invalid\")","v":0},null,null,"3005a BalanceSheet","Contact Telephone Email Address - Email Address of person identified in data line <030>","<039>",{"$f":"IF(LEN('3005a BalanceSheet'!F10)=0,G8&\" can not be blank\",\"OK\")","v":"Contact Telephone Email Address - Email Address of person identified in data line <030> can not be blank"}]
["3005b IncomeStatement",null,{"$f":"COUNTIF('3005b Hidden'!G:H,\"Invalid\")","v":0},null,null,"3005c Cashflow","Explanation for cell C20",5,{"$f":"IF(AND(LEN('3005c Cashflow'!C20)=0,SUM('3005c Cashflow'!H20)<>0),\"Explanation for line item 5 is mssing.  Please provide an explanation in cell C20\",\"OK\")","v":"OK"}]
["3005c Cashflow",null,{"$f":"COUNTIF('3005c Hidden'!C:C,\"Invalid\")","v":0},null,null,"3005c Cashflow","Explanation for cell C39",22,{"$f":"IF(AND(LEN('3005c Cashflow'!C39)=0,SUM('3005c Cashflow'!H39)<>0),\"Explanation for line item 22 is mssing.  Please provide an explanation in cell C39\",\"OK\")","v":"OK"}]
[{"$nulls":5},"3005c Cashflow","Explanation for cell C45",27,{"$f":"IF(AND(LEN('3005c Cashflow'!C45)=0,SUM('3005c Cashflow'!H45)<>0),\"Explanation for line item 27 is mssing.  Please provide an explanation in cell C45\",\"OK\")","v":"OK"}]
[]
[{"$nulls":5},"Totals that can not be zero"]
[{"$nulls":5},"Worksheet","Input Item","Line Item","Error Status"]
[{"$nulls":5},"3005a BalanceSheet","Total Assets",24,{"$f":"IF(AND('3005a BalanceSheet'!C61=0,'3005a BalanceSheet'!D61=0),G15&\" can not be zero for both prior year and current year.  Please complete the \"&F15&\" worksheet (columns C and/or D).\",\"OK\")","v":"Total Assets can not be zero for both prior year and current year.  Please complete the 3005a BalanceSheet worksheet (columns C and/or D)."}]
[{"$nulls":5},"3005a BalanceSheet","Total Liabilities and Equity",59,{"$f":"IF(AND('3005a BalanceSheet'!G61=0,'3005a BalanceSheet'!H61=0),G16&\" can not be zero for both prior year and current year.  Please complete the \"&F16&\" worksheet (columns G and/or H).\",\"OK\")","v":"Total Liabilities and Equity can not be zero for both prior year and current year.  Please complete the 3005a BalanceSheet worksheet (columns G and/or H)."}]
[{"$nulls":5},"3005b IncomeStatement","Input items for prior year",null,{"$f":"IF(AND('3005a BalanceSheet'!C61<>0,'3005b Hidden'!K52=0),\"All input items are zero for the prior year in the \"&F17&\" worksheet.  Please complete the \"&F17&\" worksheet for the prior year (column G).\",\"OK\")","v":"OK"}]
[{"$nulls":5},"3005b IncomeStatement","Input items for current year",null,{"$f":"IF(AND('3005a BalanceSheet'!D61<>0,'3005b Hidden'!L52=0),\"All input items are zero for the current year in the \"&F18&\" worksheet.  Please complete the \"&F18&\" worksheet for the current year (column H).\",\"OK\")","v":"OK"}]

{"sheet":"3005a BalanceSheet","index":1,"n_rows":61,"n_cols":8,"rows_kept":61,"merged":[[14,0,14,7],[15,0,15,7],[19,0,19,7],[20,0,20,1],[20,4,20,5]]}
["(3005a) Operating Report for Privately-Held Rate of Return Carriers",{"$nulls":3},"FCC Form 481"]
["Balance Sheet - Data Collection Form ",{"$nulls":3},"OMB Control No. 3060-0986"]
["Page 1 of 3",{"$nulls":3},"July 2013"]
[]
["<010>","Study Area Code",null,null,"<010>"]
["<015>","Study Area Name",null,null,"<015>"]
["<020>","Program Year",null,null,"<020>"]
["<030>","Contact Name - Person USAC should contact regarding this data",null,null,"<030>"]
["<035>","Contact Telephone Number - Number of person identified in data line <030>",null,null,"<035>"]
["<039>","Contact Telephone Email Address - Email Address of person identified in data line <030>",null,null,"<039>"]
[]
[]
[]
[]
["CERTIFICATION"]
["We hereby certify that the entries in this report are in accordance with the accounts and other records of the system and reflect the status of the system to the best of our knowledge and belief."]
[]
[]
[null,"Signature",null,"Date"]
["PART A. BALANCE SHEET"]
["ASSETS",null,"BALANCE PRIOR YEAR","BALANCE END OF PERIOD","LIABILTIES AND STOCKHOLDERS' EQUITY",null,"BALANCE PRIOR YEAR","BALANCE END OF PERIOD"]
["CURRENT ASSETS",{"$nulls":3},"CURRENT LIABILITIES"]
["1.","Cash and Equivalents",null,null,"25.","Accounts Payable"]
["2.","Cash-RUS Construction Fund",null,null,"26.","Notes Payable"]
["3.","Affiliates:",null,null,"27.","Advance Billings and Payments"]
[null,"a. Telecom, Accounts Receivable",null,null,"28.","Customer Deposits"]
[null,"b. Other Accounts Receivable",null,null,"29.","Current Mat. L/T Debt"]
[null,"c. Notes Receivable",null,null,"30.","Current Mat. L/T Debt-Rur. Dev."]
["4.","Non-Affiliates:",null,null,"31.","Current Mat.-Capital Leases"]
[null,"a. Telecom, Accounts Receivable",null,null,"32.","Income Taxes Accrued"]
[null,"b. Other Accounts Receivable",null,null,"33.","Other Taxes Accrued"]
[null,"c. Notes Receivable",null,null,"34.","Other Current Liabilities"]
["5.","Interest and Dividends Receivable",null,null,"35.","Total Current Liabilities (25 thru 34)",{"$f":"SUM(G23:G32)","v":0},{"$f":"SUM(H23:H32)","v":0}]
["6.","Material-Regulated",null,null,"LONG-TERM DEBT"]
["7.","Material-Nonregulated",null,null,"36.","Funded Debt-RUS Notes"]
["8.","Prepayments",null,null,"37.","Funded Debt-RTB Notes"]
["9.","Other Current Assets",null,null,"38.","Funded Debt-FFB Notes"]
["10.","Total Current Assets (1 Thru 9)",{"$f":"SUM(C23:C37)","v":0},{"$f":"SUM(D23:D37)","v":0},"39.","Funded Debt-Other"]
[{"$nulls":4},"40.","Funded Debt-Rural Develop. Loan"]
["NONCURRENT ASSETS",{"$nulls":3},"41.","Premium (Discount) on L/T Debt"]
["11.","Investment in Affiliated Companies",null,null,"42.","Reacquired Debt"]
[null,"a. Rural Development",null,null,"43.","Obligations Under Capital Lease"]
[null,"b. Nonrural Development",null,null,"44.","Adv. From Affiliated Companies"]
["12.","Other Investments",null,null,"45.","Other Long-Term Debt"]
[null,"a. Rural Development",null,null,"46.","Total Long-Term Debt (36 thru 45)",{"$f":"SUM(G35:G44)","v":0},{"$f":"SUM(H35:H44)","v":0}]
[null,"b. Nonrural Development",null,null,"OTHER LIAB. & DEF. CREDITS"]
["13.","Nonregulated Investments",null,null,"47.","Other Long-Term Liabilities"]
["14.","Other Noncurrent Assets",null,null,"48.","Other Deferred Credits"]
["15.","Deferred Charges",null,null,"49.","Other Jurisdictional Differences"]
["16.","Jurisdictional Differences",null,null,"50.","Total Other Liabilities and Deferred Credits (47 thru 49)",{"$f":"SUM(G47:G49)","v":0},{"$f":"SUM(H47:H49)","v":0}]
["17.","Total Noncurrent Assets (11 thru 16)",{"$f":"SUM(C42:C50)","v":0},{"$f":"SUM(D42:D50)","v":0},"EQUITY"]
[{"$nulls":4},"51.","Cap. Stock Outstanding & Subscribed"]
["PLANT, PROPERTY, AND EQUIPMENT",{"$nulls":3},"52.","Additional Paid-in-Capital"]
["18.","Telecom, Plant-in-Service",null,null,"53.","Treasury Stock"]
["19.","Property Held for Future Use",null,null,"54.","Membership and Cap. Certificates"]
["20.","Plant Under Construction",null,null,"55.","Other Capital"]
["21.","Plant Adj., Nonop. Plant & Goodwill",null,null,"56.","Patronage Capital Credits"]
["22.","Less Accumulated Depreciation",null,null,"57.","Retained Earnings or Margins"]
["23.","Net Plant (18 thru 21 less 22)",{"$f":"SUM(C54:C58)","v":0},{"$f":"SUM(D54:D58)","v":0},"58.","Total Equity (51 thru 57)",{"$f":"SUM(G52:G58)","v":0},{"$f":"SUM(H52:H58)","v":0}]
[]
["24.","TOTAL ASSETS (10+17+23)",{"$f":"C38+C51+C59","v":0},{"$f":"D38+D51+D59","v":0},"59.","TOTAL LIABILITIES AND EQUITY (35+46+50+58)",{"$f":"G33+G45+G50+G59","v":0},{"$f":"H33+H45+H50+H59","v":0}]

{"sheet":"3005b IncomeStatement","index":2,"n_rows":62,"n_cols":8,"rows_kept":62,"merged":[[12,0,12,7],[13,0,13,5],[14,1,14,5],[15,1,15,5],[16,1,16,5],[17,1,17,5],[18,1,18,5],[19,1,19,5],[20,1,20,5],[21,1,21,5],[22,1,22,5],[23,1,23,5],[24,1,24,5],[25,1,25,5],[26,1,26,5],[27,1,27,5],[28,1,28,5],[29,1,29,5],[30,1,30,5],[31,1,31,5],[32,1,32,5],[33,1,33,5],[34,1,34,5],[35,1,35,5],[36,1,36,5],[37,1,37,5],[38,1,38,5],[39,1,39,5],[40,1,40,5],[41,1,41,5],[42,1,42,5],[43,1,43,5],[44,1,44,5],[45,1,45,5],[46,1,46,5],[47,1,47,5],[48,1,48,5],[49,1,49,5],[50,1,50,5],[51,1,51,5],[52,1,52,5],[53,1,53,5],[54,1,54,5],[55,1,55,5],[56,1,56,5],[57,1,57,5],[58,1,58,5],[59,1,59,5],[60,1,60,5],[61,1,61,5]]}
["(3005b) Operating Report for Privately-Held Rate of Return Carriers",{"$nulls":3},"FCC Form 481"]
["Balance Sheet - Data Collection Form ",{"$nulls":3},"OMB Control No. 3060-0986"]
["Page 2 of 3",{"$nulls":3},"July 2013"]
[]
["<010>","Study Area Code",null,null,"<010>",{"$f":"IF(LEN('3005a BalanceSheet'!F5)=0,\"\",'3005a BalanceSheet'!F5)","v":""}]
["<015>","Study Area Name",null,null,"<015>",{"$f":"IF(LEN('3005a BalanceSheet'!F6)=0,\"\",'3005a BalanceSheet'!F6)","v":""}]
["<020>","Program Year",null,null,"<020>",{"$f":"IF(LEN('3005a BalanceSheet'!F7)=0,\"\",'3005a BalanceSheet'!F7)","v":""}]
["<030>","Contact Name - Person USAC should contact regarding this data",null,null,"<030>",{"$f":"IF(LEN('3005a BalanceSheet'!F8)=0,\"\",'3005a BalanceSheet'!F8)","v":""}]
["<035>","Contact Telephone Number - Number of person identified in data line <030>",null,null,"<035>",{"$f":"IF(LEN('3005a BalanceSheet'!F9)=0,\"\",'3005a BalanceSheet'!F9)","v":""}]
["<039>","Contact Telephone Email Address - Email Address of person identified in data line <030>",null,null,"<039>",{"$f":"IF(LEN('3005a BalanceSheet'!F10)=0,\"\",'3005a BalanceSheet'!F10)","v":""}]
[]
[]
["PART B. STATEMENTS OF INCOME AND RETAINED EARINGS OR MARGINS"]
["ITEM",{"$nulls":5},"PRIOR YEAR","THIS YEAR"]
["1.","Local Network Services Revenues"]
["2.","Network Access Services Revenues"]
["3.","Long Distance Network Services Revenues"]
["4.","Carrier Billing and Collection Revenues"]
["5.","Miscellaneous Revenues"]
["6.","Uncollectible Revenues"]
["7.","Net Operating Revenues (1 thru 5 less 6)",{"$nulls":4},{"$f":"SUM(G15:G19)-G20","v":0},{"$f":"SUM(H15:H19)-H20","v":0}]
["8.","Plant Specific Operations Expense"]
["9.","Plant Nonspecific Operations Expense (Excluding Depreciation & Amortization)"]
["10.","Depreciation Expense"]
["11.","Amortization Expense"]
["12.","Customer Operations Expense"]
["13.","Corporate Operations Expense"]
["14.","Total Operating Expenses (8 thru 13)",{"$nulls":4},{"$f":"SUM(G22:G27)","v":0},{"$f":"SUM(H22:H27)","v":0}]
["15.","Operating Income or Margins (7 less 14)",{"$nulls":4},{"$f":"G21-G28","v":0},{"$f":"H21-H28","v":0}]
["16.","Other Operating Income and Expenses"]
["17.","State and Local Taxes"]
["18.","Federal Income Taxes"]
["19.","Other Taxes"]
["20.","Total Operating Taxes (17+18+19)",{"$nulls":4},{"$f":"SUM(G31:G33)","v":0},{"$f":"SUM(H31:H33)","v":0}]
["21.","Net Operating Income or Margins (15+16-20)",{"$nulls":4},{"$f":"G29+G30-G34","v":0},{"$f":"H29+H30-H34","v":0}]
["22.","Interest on Funded Debt"]
["23.","Interest Expense - Capital Leases"]
["24.","Other Interest Expense"]
["25.","Allowance for Funds Used During Construction"]
["26.","Total Fixed Charges (22+23+24-25)",{"$nulls":4},{"$f":"SUM(G36:G38)-G39","v":0},{"$f":"SUM(H36:H38)-H39","v":0}]
["27.","Nonoperating Net Income"]
["28.","Extraordinary Items"]
["29.","Jurisdictional Differences"]
["30.","Nonregulated Net Income"]
["31.","Total Net Income or margins (21+27+28+29+30-26)",{"$nulls":4},{"$f":"G35+SUM(G41:G44)-G40","v":0},{"$f":"H35+SUM(H41:H44)-H40","v":0}]
["32.","Total Taxes Based on Income"]
["33.","Retained Earnings or Margins Beginning-of-Year"]
["34.","Miscellaneous Credits Year-to-Date"]
["35.","Dividends Declared (Common)"]
["36.","Dividends Declared (Preferred)"]
["37.","Other Debits Year-to-Date"]
["38.","Transfers to Patronage Capital"]
["39.","Retained Earnings or Margins end-of-Period [(31+33+34)-(35+36+37+38)]",{"$nulls":4},{"$f":"(G45+G47+G48)-SUM(G49:G52)","v":0},{"$f":"(H45+H47+H48)-SUM(H49:H52)","v":0}]
["40.","Patronage Capital Beginning-of-Year"]
["41.","Transfers to Patronage Capital"]
["42.","Patronage Capital Credits Retired"]
["43.","Patronage Capital End-of-Year (40+41-42)",{"$nulls":4},{"$f":"G54+G55-G56","v":0},{"$f":"H54+H55-H56","v":0}]
["44.","Annual Debt Service Payments"]
["45.","Cash Ratio [(14+20-10-11)/7]",{"$nulls":4},{"$f":"IF(G21=0,0,(G28+G34-G24-G25)/G21)","v":{"v":0,"d":"0.00"}},{"$f":"IF(H21=0,0,(H28+H34-H24-H25)/H21)","v":{"v":0,"d":"0.00"}}]
["46.","Operating Accrual Ratio [(14+20+26)/7]",{"$nulls":4},{"$f":"IF(G21=0,0,(G28+G34+G40)/G21)","v":{"v":0,"d":"0.00"}},{"$f":"IF(H21=0,0,(H28+H34+H40)/H21)","v":{"v":0,"d":"0.00"}}]
["47.","TIER [(31+26)/26]",{"$nulls":4},{"$f":"IF(G40=0,0,(G45+G40)/G40)","v":{"v":0,"d":"0.00"}},{"$f":"IF(H40=0,0,(H45+H40)/H40)","v":{"v":0,"d":"0.00"}}]
["48.","DSCR [(31+26+10+11)/44]",{"$nulls":4},{"$f":"IF(G58=0,0,(G45+G40+G24+G25)/G58)","v":{"v":0,"d":"0.00"}},{"$f":"IF(H58=0,0,(H45+H40+H24+H25)/H58)","v":{"v":0,"d":"0.00"}}]

{"sheet":"3005c Cashflow","index":3,"n_rows":48,"n_cols":8,"rows_kept":48,"merged":[[12,0,12,7],[13,1,13,6],[14,0,14,6],[15,1,15,6],[16,0,16,6],[17,1,17,5],[18,1,18,5],[19,2,19,5],[20,0,20,6],[21,1,21,6],[22,1,22,6],[23,1,23,6],[24,1,24,6],[25,1,25,6],[26,1,26,6],[27,1,27,6],[28,1,28,6],[29,0,29,6],[30,1,30,6],[31,1,31,6],[32,1,32,6],[33,1,33,6],[34,1,34,6],[35,1,35,6],[36,1,36,6],[37,1,37,6],[38,2,38,5],[39,1,39,6],[40,0,40,6],[41,1,41,6],[42,1,42,6],[43,1,43,6],[44,2,44,5],[45,1,45,6],[46,1,46,6],[47,1,47,6]]}
["(3005c) Operating Report for Privately-Held Rate of Return Carriers",{"$nulls":3},"FCC Form 481"]
["Balance Sheet - Data Collection Form ",{"$nulls":3},"OMB Control No. 3060-0986"]
["Page 3 of 3",{"$nulls":3},"July 2013"]
[]
["<010>","Study Area Code",null,null,"<010>",{"$f":"IF(LEN('3005a BalanceSheet'!F5)=0,\"\",'3005a BalanceSheet'!F5)","v":""}]
["<015>","Study Area Name",null,null,"<015>",{"$f":"IF(LEN('3005a BalanceSheet'!F6)=0,\"\",'3005a BalanceSheet'!F6)","v":""}]
["<020>","Program Year",null,null,"<020>",{"$f":"IF(LEN('3005a BalanceSheet'!F7)=0,\"\",'3005a BalanceSheet'!F7)","v":""}]
["<030>","Contact Name - Person USAC should contact regarding this data",null,null,"<030>",{"$f":"IF(LEN('3005a BalanceSheet'!F8)=0,\"\",'3005a BalanceSheet'!F8)","v":""}]
["<035>","Contact Telephone Number - Number of person identified in data line <030>",null,null,"<035>",{"$f":"IF(LEN('3005a BalanceSheet'!F9)=0,\"\",'3005a BalanceSheet'!F9)","v":""}]
["<039>","Contact Telephone Email Address - Email Address of person identified in data line <030>",null,null,"<039>",{"$f":"IF(LEN('3005a BalanceSheet'!F10)=0,\"\",'3005a BalanceSheet'!F10)","v":""}]
[]
[]
["PART C. STATEMENTS OF CASH FLOWS"]
["1.","Beginning Cash (Cash and Equivalents plus RUS Construction Fund)"]
["CASH FLOWS FROM OPERATING ACTIVITIES"]
["2.","Net Income"]
["Adjustments to Reconcile Net Income to Net Cash Provided by Operating Activities"]
["3.","Add: Depreciation"]
["4.","Add: Amortization"]
["5.","Other (Explain)"]
["Changes in Operating Assets and Liabilities"]
["6.","Decrease/(Increase) in Accounts Receivable"]
["7.","Decrease/(Increase) in Materials and Inventory"]
["8.","Decrease/(Increase) in Prepayments and Deferred Charges"]
["9.","Decrease/(Increase) in Other Current Assets"]
["10.","Increase/(Decrease) in Accounts Payable"]
["11.","Increase/(Decrease) in Advance Billings & Payments"]
["12.","Increase/(Decrease) in Other Current Liabilities"]
["13.","Net Cash Provided/(Used) by Operations",{"$nulls":5},{"$f":"SUM(H16,H18:H20,H22:H28)","v":0}]
["CASH FLOWS FROM FINANCING ACTIVITIES"]
["14.","Decrease/(Increase) in Notes Receivable"]
["15.","Increase/(Decrease) in Notes Payable"]
["16.","Increase/(Decrease) in Customer Deposits"]
["17.","Net Increase/(Decrease) in Long Term Debt (Including Current Maturities)"]
["18.","Increase/(Decrease) in Other Liabilities & Deferred Credits"]
["19.","Increase/(Decrease) in Capital Stock, Paid-in Capital, Membership and Capital Certificates & Other Capital"]
["20.","Less:  Payment of Dividends"]
["21.","Less:  Patronage Capital Credits Retired"]
["22.","Other (Explain)"]
["23.","Net Cash Provided/(Used) by Financing Activities",{"$nulls":5},{"$f":"SUM(H31:H39)","v":0}]
["CASH FLOWS FROM INVESTING ACTIVITIES"]
["24.","Net Capital Expenditures (Property, Plant & Equipment)"]
["25.","Other Long-Term Investments"]
["26.","Other Noncurrent Assets & Jurisdictional Differences"]
["27.","Other (Explain)"]
["28.","Net Cash Provided/(Used) by Investing Activities",{"$nulls":5},{"$f":"SUM(H42:H45)","v":0}]
["29.","Net Increase/(Decrease) in Cash",{"$nulls":5},{"$f":"SUM(H29,H40,H46)","v":0}]
["30.","Ending Cash",{"$nulls":5},{"$f":"SUM(H14,H47)","v":0}]

{"sheet":"3005a Hidden","index":4,"n_rows":42,"n_cols":8,"rows_kept":42,"hidden":true}
[]
["ASSETS",null,"BALANCE PRIOR YEAR","BALANCE END OF PERIOD","LIABILTIES AND STOCKHOLDERS' EQUITY",null,"BALANCE PRIOR YEAR","BALANCE END OF PERIOD"]
["CURRENT ASSETS",{"$nulls":3},"CURRENT LIABILITIES"]
["1.","Cash and Equivalents",{"$f":"IF(AND('3005a BalanceSheet'!C23>=-999999999999,'3005a BalanceSheet'!C23<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!D23>=-999999999999,'3005a BalanceSheet'!D23<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},"25.","Accounts Payable",{"$f":"IF(AND('3005a BalanceSheet'!G23>=-999999999999,'3005a BalanceSheet'!G23<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!H23>=-999999999999,'3005a BalanceSheet'!H23<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["2.","Cash-RUS Construction Fund",{"$f":"IF(AND('3005a BalanceSheet'!C24>=-999999999999,'3005a BalanceSheet'!C24<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!D24>=-999999999999,'3005a BalanceSheet'!D24<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},"26.","Notes Payable",{"$f":"IF(AND('3005a BalanceSheet'!G24>=-999999999999,'3005a BalanceSheet'!G24<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!H24>=-999999999999,'3005a BalanceSheet'!H24<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["3.","Affiliates:",{"$f":"IF(AND('3005a BalanceSheet'!C25>=-999999999999,'3005a BalanceSheet'!C25<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!D25>=-999999999999,'3005a BalanceSheet'!D25<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},"27.","Advance Billings and Payments",{"$f":"IF(AND('3005a BalanceSheet'!G25>=-999999999999,'3005a BalanceSheet'!G25<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!H25>=-999999999999,'3005a BalanceSheet'!H25<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
[null,"a. Telecom, Accounts Receivable",{"$f":"IF(AND('3005a BalanceSheet'!C26>=-999999999999,'3005a BalanceSheet'!C26<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!D26>=-999999999999,'3005a BalanceSheet'!D26<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},"28.","Customer Deposits",{"$f":"IF(AND('3005a BalanceSheet'!G26>=-999999999999,'3005a BalanceSheet'!G26<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!H26>=-999999999999,'3005a BalanceSheet'!H26<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
[null,"b. Other Accounts Receivable",{"$f":"IF(AND('3005a BalanceSheet'!C27>=-999999999999,'3005a BalanceSheet'!C27<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!D27>=-999999999999,'3005a BalanceSheet'!D27<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},"29.","Current Mat. L/T Debt",{"$f":"IF(AND('3005a BalanceSheet'!G27>=-999999999999,'3005a BalanceSheet'!G27<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!H27>=-999999999999,'3005a BalanceSheet'!H27<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
[null,"c. Notes Receivable",{"$f":"IF(AND('3005a BalanceSheet'!C28>=-999999999999,'3005a BalanceSheet'!C28<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!D28>=-999999999999,'3005a BalanceSheet'!D28<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},"30.","Current Mat. L/T Debt-Rur. Dev.",{"$f":"IF(AND('3005a BalanceSheet'!G28>=-999999999999,'3005a BalanceSheet'!G28<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!H28>=-999999999999,'3005a BalanceSheet'!H28<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["4.","Non-Affiliates:",{"$f":"IF(AND('3005a BalanceSheet'!C29>=-999999999999,'3005a BalanceSheet'!C29<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!D29>=-999999999999,'3005a BalanceSheet'!D29<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},"31.","Current Mat.-Capital Leases",{"$f":"IF(AND('3005a BalanceSheet'!G29>=-999999999999,'3005a BalanceSheet'!G29<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!H29>=-999999999999,'3005a BalanceSheet'!H29<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
[null,"a. Telecom, Accounts Receivable",{"$f":"IF(AND('3005a BalanceSheet'!C30>=-999999999999,'3005a BalanceSheet'!C30<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!D30>=-999999999999,'3005a BalanceSheet'!D30<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},"32.","Income Taxes Accrued",{"$f":"IF(AND('3005a BalanceSheet'!G30>=-999999999999,'3005a BalanceSheet'!G30<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!H30>=-999999999999,'3005a BalanceSheet'!H30<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
[null,"b. Other Accounts Receivable",{"$f":"IF(AND('3005a BalanceSheet'!C31>=-999999999999,'3005a BalanceSheet'!C31<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!D31>=-999999999999,'3005a BalanceSheet'!D31<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},"33.","Other Taxes Accrued",{"$f":"IF(AND('3005a BalanceSheet'!G31>=-999999999999,'3005a BalanceSheet'!G31<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!H31>=-999999999999,'3005a BalanceSheet'!H31<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
[null,"c. Notes Receivable",{"$f":"IF(AND('3005a BalanceSheet'!C32>=-999999999999,'3005a BalanceSheet'!C32<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!D32>=-999999999999,'3005a BalanceSheet'!D32<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},"34.","Other Current Liabilities",{"$f":"IF(AND('3005a BalanceSheet'!G32>=-999999999999,'3005a BalanceSheet'!G32<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!H32>=-999999999999,'3005a BalanceSheet'!H32<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["5.","Interest and Dividends Receivable",{"$f":"IF(AND('3005a BalanceSheet'!C33>=-999999999999,'3005a BalanceSheet'!C33<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!D33>=-999999999999,'3005a BalanceSheet'!D33<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},"35.","Total Current Liabilities (25 thru 34)",{"$f":"SUM(G4:G13)","v":0},{"$f":"SUM(H4:H13)","v":0}]
["6.","Material-Regulated",{"$f":"IF(AND('3005a BalanceSheet'!C34>=-999999999999,'3005a BalanceSheet'!C34<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!D34>=-999999999999,'3005a BalanceSheet'!D34<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},"LONG-TERM DEBT"]
["7.","Material-Nonregulated",{"$f":"IF(AND('3005a BalanceSheet'!C35>=-999999999999,'3005a BalanceSheet'!C35<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!D35>=-999999999999,'3005a BalanceSheet'!D35<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},"36.","Funded Debt-RUS Notes",{"$f":"IF(AND('3005a BalanceSheet'!G35>=-999999999999,'3005a BalanceSheet'!G35<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!H35>=-999999999999,'3005a BalanceSheet'!H35<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["8.","Prepayments",{"$f":"IF(AND('3005a BalanceSheet'!C36>=-999999999999,'3005a BalanceSheet'!C36<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!D36>=-999999999999,'3005a BalanceSheet'!D36<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},"37.","Funded Debt-RTB Notes",{"$f":"IF(AND('3005a BalanceSheet'!G36>=-999999999999,'3005a BalanceSheet'!G36<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!H36>=-999999999999,'3005a BalanceSheet'!H36<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["9.","Other Current Assets",{"$f":"IF(AND('3005a BalanceSheet'!C37>=-999999999999,'3005a BalanceSheet'!C37<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!D37>=-999999999999,'3005a BalanceSheet'!D37<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},"38.","Funded Debt-FFB Notes",{"$f":"IF(AND('3005a BalanceSheet'!G37>=-999999999999,'3005a BalanceSheet'!G37<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!H37>=-999999999999,'3005a BalanceSheet'!H37<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["10.","Total Current Assets (1 Thru 9)",{"$f":"SUM(C4:C18)","v":0},{"$f":"SUM(D4:D18)","v":0},"39.","Funded Debt-Other",{"$f":"IF(AND('3005a BalanceSheet'!G38>=-999999999999,'3005a BalanceSheet'!G38<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!H38>=-999999999999,'3005a BalanceSheet'!H38<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
[{"$nulls":4},"40.","Funded Debt-Rural Develop. Loan",{"$f":"IF(AND('3005a BalanceSheet'!G39>=-999999999999,'3005a BalanceSheet'!G39<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!H39>=-999999999999,'3005a BalanceSheet'!H39<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["NONCURRENT ASSETS",{"$nulls":3},"41.","Premium (Discount) on L/T Debt",{"$f":"IF(AND('3005a BalanceSheet'!G40>=-999999999999,'3005a BalanceSheet'!G40<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!H40>=-999999999999,'3005a BalanceSheet'!H40<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["11.","Investment in Affiliated Companies",null,null,"42.","Reacquired Debt",{"$f":"IF(AND('3005a BalanceSheet'!G41>=-999999999999,'3005a BalanceSheet'!G41<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!H41>=-999999999999,'3005a BalanceSheet'!H41<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
[null,"a. Rural Development",{"$f":"IF(AND('3005a BalanceSheet'!C42>=-999999999999,'3005a BalanceSheet'!C42<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!D42>=-999999999999,'3005a BalanceSheet'!D42<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},"43.","Obligations Under Capital Lease",{"$f":"IF(AND('3005a BalanceSheet'!G42>=-999999999999,'3005a BalanceSheet'!G42<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!H42>=-999999999999,'3005a BalanceSheet'!H42<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
[null,"b. Nonrural Development",{"$f":"IF(AND('3005a BalanceSheet'!C43>=-999999999999,'3005a BalanceSheet'!C43<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!D43>=-999999999999,'3005a BalanceSheet'!D43<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},"44.","Adv. From Affiliated Companies",{"$f":"IF(AND('3005a BalanceSheet'!G43>=-999999999999,'3005a BalanceSheet'!G43<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!H43>=-999999999999,'3005a BalanceSheet'!H43<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["12.","Other Investments",null,null,"45.","Other Long-Term Debt",{"$f":"IF(AND('3005a BalanceSheet'!G44>=-999999999999,'3005a BalanceSheet'!G44<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!H44>=-999999999999,'3005a BalanceSheet'!H44<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
[null,"a. Rural Development",{"$f":"IF(AND('3005a BalanceSheet'!C45>=-999999999999,'3005a BalanceSheet'!C45<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!D45>=-999999999999,'3005a BalanceSheet'!D45<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},"46.","Total Long-Term Debt (36 thru 45)",{"$f":"SUM(G16:G25)","v":0},{"$f":"SUM(H16:H25)","v":0}]
[null,"b. Nonrural Development",{"$f":"IF(AND('3005a BalanceSheet'!C46>=-999999999999,'3005a BalanceSheet'!C46<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!D46>=-999999999999,'3005a BalanceSheet'!D46<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},"OTHER LIAB. & DEF. CREDITS"]
["13.","Nonregulated Investments",{"$f":"IF(AND('3005a BalanceSheet'!C47>=-999999999999,'3005a BalanceSheet'!C47<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!D47>=-999999999999,'3005a BalanceSheet'!D47<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},"47.","Other Long-Term Liabilities",{"$f":"IF(AND('3005a BalanceSheet'!G47>=-999999999999,'3005a BalanceSheet'!G47<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!H47>=-999999999999,'3005a BalanceSheet'!H47<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["14.","Other Noncurrent Assets",{"$f":"IF(AND('3005a BalanceSheet'!C48>=-999999999999,'3005a BalanceSheet'!C48<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!D48>=-999999999999,'3005a BalanceSheet'!D48<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},"48.","Other Deferred Credits",{"$f":"IF(AND('3005a BalanceSheet'!G48>=-999999999999,'3005a BalanceSheet'!G48<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!H48>=-999999999999,'3005a BalanceSheet'!H48<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["15.","Deferred Charges",{"$f":"IF(AND('3005a BalanceSheet'!C49>=-999999999999,'3005a BalanceSheet'!C49<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!D49>=-999999999999,'3005a BalanceSheet'!D49<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},"49.","Other Jurisdictional Differences",{"$f":"IF(AND('3005a BalanceSheet'!G49>=-999999999999,'3005a BalanceSheet'!G49<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!H49>=-999999999999,'3005a BalanceSheet'!H49<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["16.","Jurisdictional Differences",{"$f":"IF(AND('3005a BalanceSheet'!C50>=-999999999999,'3005a BalanceSheet'!C50<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!D50>=-999999999999,'3005a BalanceSheet'!D50<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},"50.","Total Other Liabilities and Deferred Credits (47 thru 49)",{"$f":"SUM(G28:G30)","v":0},{"$f":"SUM(H28:H30)","v":0}]
["17.","Total Noncurrent Assets (11 thru 16)",{"$f":"SUM(C23:C31)","v":0},{"$f":"SUM(D23:D31)","v":0},"EQUITY"]
[{"$nulls":4},"51.","Cap. Stock Outstanding & Subscribed",{"$f":"IF(AND('3005a BalanceSheet'!G52>=-999999999999,'3005a BalanceSheet'!G52<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!H52>=-999999999999,'3005a BalanceSheet'!H52<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["PLANT, PROPERTY, AND EQUIPMENT",{"$nulls":3},"52.","Additional Paid-in-Capital",{"$f":"IF(AND('3005a BalanceSheet'!G53>=-999999999999,'3005a BalanceSheet'!G53<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!H53>=-999999999999,'3005a BalanceSheet'!H53<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["18.","Telecom, Plant-in-Service",{"$f":"IF(AND('3005a BalanceSheet'!C54>=-999999999999,'3005a BalanceSheet'!C54<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!D54>=-999999999999,'3005a BalanceSheet'!D54<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},"53.","Treasury Stock",{"$f":"IF(AND('3005a BalanceSheet'!G54>=-999999999999,'3005a BalanceSheet'!G54<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!H54>=-999999999999,'3005a BalanceSheet'!H54<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["19.","Property Held for Future Use",{"$f":"IF(AND('3005a BalanceSheet'!C55>=-999999999999,'3005a BalanceSheet'!C55<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!D55>=-999999999999,'3005a BalanceSheet'!D55<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},"54.","Membership and Cap. Certificates",{"$f":"IF(AND('3005a BalanceSheet'!G55>=-999999999999,'3005a BalanceSheet'!G55<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!H55>=-999999999999,'3005a BalanceSheet'!H55<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["20.","Plant Under Construction",{"$f":"IF(AND('3005a BalanceSheet'!C56>=-999999999999,'3005a BalanceSheet'!C56<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!D56>=-999999999999,'3005a BalanceSheet'!D56<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},"55.","Other Capital",{"$f":"IF(AND('3005a BalanceSheet'!G56>=-999999999999,'3005a BalanceSheet'!G56<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!H56>=-999999999999,'3005a BalanceSheet'!H56<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["21.","Plant Adj., Nonop. Plant & Goodwill",{"$f":"IF(AND('3005a BalanceSheet'!C57>=-999999999999,'3005a BalanceSheet'!C57<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!D57>=-999999999999,'3005a BalanceSheet'!D57<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},"56.","Patronage Capital Credits",{"$f":"IF(AND('3005a BalanceSheet'!G57>=-999999999999,'3005a BalanceSheet'!G57<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!H57>=-999999999999,'3005a BalanceSheet'!H57<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["22.","Less Accumulated Depreciation",{"$f":"IF(AND('3005a BalanceSheet'!C58>=-999999999999,'3005a BalanceSheet'!C58<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!D58>=-999999999999,'3005a BalanceSheet'!D58<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},"57.","Retained Earnings or Margins",{"$f":"IF(AND('3005a BalanceSheet'!G58>=-999999999999,'3005a BalanceSheet'!G58<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005a BalanceSheet'!H58>=-999999999999,'3005a BalanceSheet'!H58<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["23.","Net Plant (18 thru 21 less 22)",{"$f":"SUM(C35:C39)","v":0},{"$f":"SUM(D35:D39)","v":0},"58.","Total Equity (51 thru 57)",{"$f":"SUM(G33:G39)","v":0},{"$f":"SUM(H33:H39)","v":0}]
[]
["24.","TOTAL ASSETS (10+17+23)",{"$f":"C19+C32+C40","v":0},{"$f":"D19+D32+D40","v":0},"59.","TOTAL LIABILITIES AND EQUITY (35+46+50+58)",{"$f":"G14+G26+G31+G40","v":0},{"$f":"H14+H26+H31+H40","v":0}]

{"sheet":"3005b Hidden","index":5,"n_rows":52,"n_cols":12,"rows_kept":52,"hidden":true}
[{"$nulls":10},"Absolute Values"]
["ITEM",{"$nulls":5},"PRIOR YEAR","THIS YEAR",null,null,"PRIOR YEAR","THIS YEAR"]
["1.","Local Network Services Revenues",{"$nulls":4},{"$f":"IF(AND('3005b IncomeStatement'!G15>=-999999999999,'3005b IncomeStatement'!G15<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005b IncomeStatement'!H15>=-999999999999,'3005b IncomeStatement'!H15<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},null,null,{"$f":"ABS('3005b IncomeStatement'!G15)","v":0},{"$f":"ABS('3005b IncomeStatement'!H15)","v":0}]
["2.","Network Access Services Revenues",{"$nulls":4},{"$f":"IF(AND('3005b IncomeStatement'!G16>=-999999999999,'3005b IncomeStatement'!G16<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005b IncomeStatement'!H16>=-999999999999,'3005b IncomeStatement'!H16<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},null,null,{"$f":"ABS('3005b IncomeStatement'!G16)","v":0},{"$f":"ABS('3005b IncomeStatement'!H16)","v":0}]
["3.","Long Distance Network Services Revenues",{"$nulls":4},{"$f":"IF(AND('3005b IncomeStatement'!G17>=-999999999999,'3005b IncomeStatement'!G17<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005b IncomeStatement'!H17>=-999999999999,'3005b IncomeStatement'!H17<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},null,null,{"$f":"ABS('3005b IncomeStatement'!G17)","v":0},{"$f":"ABS('3005b IncomeStatement'!H17)","v":0}]
["4.","Carrier Billing and Collection Revenues",{"$nulls":4},{"$f":"IF(AND('3005b IncomeStatement'!G18>=-999999999999,'3005b IncomeStatement'!G18<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005b IncomeStatement'!H18>=-999999999999,'3005b IncomeStatement'!H18<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},null,null,{"$f":"ABS('3005b IncomeStatement'!G18)","v":0},{"$f":"ABS('3005b IncomeStatement'!H18)","v":0}]
["5.","Miscellaneous Revenues",{"$nulls":4},{"$f":"IF(AND('3005b IncomeStatement'!G19>=-999999999999,'3005b IncomeStatement'!G19<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005b IncomeStatement'!H19>=-999999999999,'3005b IncomeStatement'!H19<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},null,null,{"$f":"ABS('3005b IncomeStatement'!G19)","v":0},{"$f":"ABS('3005b IncomeStatement'!H19)","v":0}]
["6.","Uncollectible Revenues",{"$nulls":4},{"$f":"IF(AND('3005b IncomeStatement'!G20>=-999999999999,'3005b IncomeStatement'!G20<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005b IncomeStatement'!H20>=-999999999999,'3005b IncomeStatement'!H20<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},null,null,{"$f":"ABS('3005b IncomeStatement'!G20)","v":0},{"$f":"ABS('3005b IncomeStatement'!H20)","v":0}]
["7.","Net Operating Revenues (1 thru 5 less 6)",{"$nulls":4},0,0]
["8.","Plant Specific Operations Expense",{"$nulls":4},{"$f":"IF(AND('3005b IncomeStatement'!G22>=-999999999999,'3005b IncomeStatement'!G22<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005b IncomeStatement'!H22>=-999999999999,'3005b IncomeStatement'!H22<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},null,null,{"$f":"ABS('3005b IncomeStatement'!G22)","v":0},{"$f":"ABS('3005b IncomeStatement'!H22)","v":0}]
["9.","Plant Nonspecific Operations Expense (Excluding Depreciation & Amortization)",{"$nulls":4},{"$f":"IF(AND('3005b IncomeStatement'!G23>=-999999999999,'3005b IncomeStatement'!G23<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005b IncomeStatement'!H23>=-999999999999,'3005b IncomeStatement'!H23<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},null,null,{"$f":"ABS('3005b IncomeStatement'!G23)","v":0},{"$f":"ABS('3005b IncomeStatement'!H23)","v":0}]
["10.","Depreciation Expense",{"$nulls":4},{"$f":"IF(AND('3005b IncomeStatement'!G24>=-999999999999,'3005b IncomeStatement'!G24<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005b IncomeStatement'!H24>=-999999999999,'3005b IncomeStatement'!H24<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},null,null,{"$f":"ABS('3005b IncomeStatement'!G24)","v":0},{"$f":"ABS('3005b IncomeStatement'!H24)","v":0}]
["11.","Amortization Expense",{"$nulls":4},{"$f":"IF(AND('3005b IncomeStatement'!G25>=-999999999999,'3005b IncomeStatement'!G25<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005b IncomeStatement'!H25>=-999999999999,'3005b IncomeStatement'!H25<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},null,null,{"$f":"ABS('3005b IncomeStatement'!G25)","v":0},{"$f":"ABS('3005b IncomeStatement'!H25)","v":0}]
["12.","Customer Operations Expense",{"$nulls":4},{"$f":"IF(AND('3005b IncomeStatement'!G26>=-999999999999,'3005b IncomeStatement'!G26<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005b IncomeStatement'!H26>=-999999999999,'3005b IncomeStatement'!H26<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},null,null,{"$f":"ABS('3005b IncomeStatement'!G26)","v":0},{"$f":"ABS('3005b IncomeStatement'!H26)","v":0}]
["13.","Corporate Operations Expense",{"$nulls":4},{"$f":"IF(AND('3005b IncomeStatement'!G27>=-999999999999,'3005b IncomeStatement'!G27<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005b IncomeStatement'!H27>=-999999999999,'3005b IncomeStatement'!H27<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},null,null,{"$f":"ABS('3005b IncomeStatement'!G27)","v":0},{"$f":"ABS('3005b IncomeStatement'!H27)","v":0}]
["14.","Total Operating Expenses (8 thru 13)",{"$nulls":4},0,0]
["15.","Operating Income or Margins (7 less 14)",{"$nulls":4},0,0]
["16.","Other Operating Income and Expenses",{"$nulls":4},{"$f":"IF(AND('3005b IncomeStatement'!G30>=-999999999999,'3005b IncomeStatement'!G30<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005b IncomeStatement'!H30>=-999999999999,'3005b IncomeStatement'!H30<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},null,null,{"$f":"ABS('3005b IncomeStatement'!G30)","v":0},{"$f":"ABS('3005b IncomeStatement'!H30)","v":0}]
["17.","State and Local Taxes",{"$nulls":4},{"$f":"IF(AND('3005b IncomeStatement'!G31>=-999999999999,'3005b IncomeStatement'!G31<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005b IncomeStatement'!H31>=-999999999999,'3005b IncomeStatement'!H31<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},null,null,{"$f":"ABS('3005b IncomeStatement'!G31)","v":0},{"$f":"ABS('3005b IncomeStatement'!H31)","v":0}]
["18.","Federal Income Taxes",{"$nulls":4},{"$f":"IF(AND('3005b IncomeStatement'!G32>=-999999999999,'3005b IncomeStatement'!G32<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005b IncomeStatement'!H32>=-999999999999,'3005b IncomeStatement'!H32<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},null,null,{"$f":"ABS('3005b IncomeStatement'!G32)","v":0},{"$f":"ABS('3005b IncomeStatement'!H32)","v":0}]
["19.","Other Taxes",{"$nulls":4},{"$f":"IF(AND('3005b IncomeStatement'!G33>=-999999999999,'3005b IncomeStatement'!G33<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005b IncomeStatement'!H33>=-999999999999,'3005b IncomeStatement'!H33<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},null,null,{"$f":"ABS('3005b IncomeStatement'!G33)","v":0},{"$f":"ABS('3005b IncomeStatement'!H33)","v":0}]
["20.","Total Operating Taxes (17+18+19)",{"$nulls":4},0,0]
["21.","Net Operating Income or Margins (15+16-20)",{"$nulls":4},0,0]
["22.","Interest on Funded Debt",{"$nulls":4},{"$f":"IF(AND('3005b IncomeStatement'!G36>=-999999999999,'3005b IncomeStatement'!G36<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005b IncomeStatement'!H36>=-999999999999,'3005b IncomeStatement'!H36<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},null,null,{"$f":"ABS('3005b IncomeStatement'!G36)","v":0},{"$f":"ABS('3005b IncomeStatement'!H36)","v":0}]
["23.","Interest Expense - Capital Leases",{"$nulls":4},{"$f":"IF(AND('3005b IncomeStatement'!G37>=-999999999999,'3005b IncomeStatement'!G37<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005b IncomeStatement'!H37>=-999999999999,'3005b IncomeStatement'!H37<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},null,null,{"$f":"ABS('3005b IncomeStatement'!G37)","v":0},{"$f":"ABS('3005b IncomeStatement'!H37)","v":0}]
["24.","Other Interest Expense",{"$nulls":4},{"$f":"IF(AND('3005b IncomeStatement'!G38>=-999999999999,'3005b IncomeStatement'!G38<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005b IncomeStatement'!H38>=-999999999999,'3005b IncomeStatement'!H38<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},null,null,{"$f":"ABS('3005b IncomeStatement'!G38)","v":0},{"$f":"ABS('3005b IncomeStatement'!H38)","v":0}]
["25.","Allowance for Funds Used During Construction",{"$nulls":4},{"$f":"IF(AND('3005b IncomeStatement'!G39>=-999999999999,'3005b IncomeStatement'!G39<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005b IncomeStatement'!H39>=-999999999999,'3005b IncomeStatement'!H39<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},null,null,{"$f":"ABS('3005b IncomeStatement'!G39)","v":0},{"$f":"ABS('3005b IncomeStatement'!H39)","v":0}]
["26.","Total Fixed Charges (22+23+24-25)",{"$nulls":4},0,0]
["27.","Nonoperating Net Income",{"$nulls":4},{"$f":"IF(AND('3005b IncomeStatement'!G41>=-999999999999,'3005b IncomeStatement'!G41<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005b IncomeStatement'!H41>=-999999999999,'3005b IncomeStatement'!H41<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},null,null,{"$f":"ABS('3005b IncomeStatement'!G41)","v":0},{"$f":"ABS('3005b IncomeStatement'!H41)","v":0}]
["28.","Extraordinary Items",{"$nulls":4},{"$f":"IF(AND('3005b IncomeStatement'!G42>=-999999999999,'3005b IncomeStatement'!G42<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005b IncomeStatement'!H42>=-999999999999,'3005b IncomeStatement'!H42<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},null,null,{"$f":"ABS('3005b IncomeStatement'!G42)","v":0},{"$f":"ABS('3005b IncomeStatement'!H42)","v":0}]
["29.","Jurisdictional Differences",{"$nulls":4},{"$f":"IF(AND('3005b IncomeStatement'!G43>=-999999999999,'3005b IncomeStatement'!G43<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005b IncomeStatement'!H43>=-999999999999,'3005b IncomeStatement'!H43<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},null,null,{"$f":"ABS('3005b IncomeStatement'!G43)","v":0},{"$f":"ABS('3005b IncomeStatement'!H43)","v":0}]
["30.","Nonregulated Net Income",{"$nulls":4},{"$f":"IF(AND('3005b IncomeStatement'!G44>=-999999999999,'3005b IncomeStatement'!G44<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005b IncomeStatement'!H44>=-999999999999,'3005b IncomeStatement'!H44<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},null,null,{"$f":"ABS('3005b IncomeStatement'!G44)","v":0},{"$f":"ABS('3005b IncomeStatement'!H44)","v":0}]
["31.","Total Net Income or margins (21+27+28+29+30-26)",{"$nulls":4},0,0]
["32.","Total Taxes Based on Income",{"$nulls":4},{"$f":"IF(AND('3005b IncomeStatement'!G46>=-999999999999,'3005b IncomeStatement'!G46<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005b IncomeStatement'!H46>=-999999999999,'3005b IncomeStatement'!H46<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},null,null,{"$f":"ABS('3005b IncomeStatement'!G46)","v":0},{"$f":"ABS('3005b IncomeStatement'!H46)","v":0}]
["33.","Retained Earnings or Margins Beginning-of-Year",{"$nulls":4},{"$f":"IF(AND('3005b IncomeStatement'!G47>=-999999999999,'3005b IncomeStatement'!G47<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005b IncomeStatement'!H47>=-999999999999,'3005b IncomeStatement'!H47<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},null,null,{"$f":"ABS('3005b IncomeStatement'!G47)","v":0},{"$f":"ABS('3005b IncomeStatement'!H47)","v":0}]
["34.","Miscellaneous Credits Year-to-Date",{"$nulls":4},{"$f":"IF(AND('3005b IncomeStatement'!G48>=-999999999999,'3005b IncomeStatement'!G48<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005b IncomeStatement'!H48>=-999999999999,'3005b IncomeStatement'!H48<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},null,null,{"$f":"ABS('3005b IncomeStatement'!G48)","v":0},{"$f":"ABS('3005b IncomeStatement'!H48)","v":0}]
["35.","Dividends Declared (Common)",{"$nulls":4},{"$f":"IF(AND('3005b IncomeStatement'!G49>=-999999999999,'3005b IncomeStatement'!G49<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005b IncomeStatement'!H49>=-999999999999,'3005b IncomeStatement'!H49<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},null,null,{"$f":"ABS('3005b IncomeStatement'!G49)","v":0},{"$f":"ABS('3005b IncomeStatement'!H49)","v":0}]
["36.","Dividends Declared (Preferred)",{"$nulls":4},{"$f":"IF(AND('3005b IncomeStatement'!G50>=-999999999999,'3005b IncomeStatement'!G50<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005b IncomeStatement'!H50>=-999999999999,'3005b IncomeStatement'!H50<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},null,null,{"$f":"ABS('3005b IncomeStatement'!G50)","v":0},{"$f":"ABS('3005b IncomeStatement'!H50)","v":0}]
["37.","Other Debits Year-to-Date",{"$nulls":4},{"$f":"IF(AND('3005b IncomeStatement'!G51>=-999999999999,'3005b IncomeStatement'!G51<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005b IncomeStatement'!H51>=-999999999999,'3005b IncomeStatement'!H51<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},null,null,{"$f":"ABS('3005b IncomeStatement'!G51)","v":0},{"$f":"ABS('3005b IncomeStatement'!H51)","v":0}]
["38.","Transfers to Patronage Capital",{"$nulls":4},{"$f":"IF(AND('3005b IncomeStatement'!G52>=-999999999999,'3005b IncomeStatement'!G52<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005b IncomeStatement'!H52>=-999999999999,'3005b IncomeStatement'!H52<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},null,null,{"$f":"ABS('3005b IncomeStatement'!G52)","v":0},{"$f":"ABS('3005b IncomeStatement'!H52)","v":0}]
["39.","Retained Earnings or Margins end-of-Period [(31+33+34)-(35+36+37+38)]",{"$nulls":4},0,0]
["40.","Patronage Capital Beginning-of-Year",{"$nulls":4},{"$f":"IF(AND('3005b IncomeStatement'!G54>=-999999999999,'3005b IncomeStatement'!G54<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005b IncomeStatement'!H54>=-999999999999,'3005b IncomeStatement'!H54<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},null,null,{"$f":"ABS('3005b IncomeStatement'!G54)","v":0},{"$f":"ABS('3005b IncomeStatement'!H54)","v":0}]
["41.","Transfers to Patronage Capital",{"$nulls":4},{"$f":"IF(AND('3005b IncomeStatement'!G55>=-999999999999,'3005b IncomeStatement'!G55<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005b IncomeStatement'!H55>=-999999999999,'3005b IncomeStatement'!H55<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},null,null,{"$f":"ABS('3005b IncomeStatement'!G55)","v":0},{"$f":"ABS('3005b IncomeStatement'!H55)","v":0}]
["42.","Patronage Capital Credits Retired",{"$nulls":4},{"$f":"IF(AND('3005b IncomeStatement'!G56>=-999999999999,'3005b IncomeStatement'!G56<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005b IncomeStatement'!H56>=-999999999999,'3005b IncomeStatement'!H56<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},null,null,{"$f":"ABS('3005b IncomeStatement'!G56)","v":0},{"$f":"ABS('3005b IncomeStatement'!H56)","v":0}]
["43.","Patronage Capital End-of-Year (40+41-42)",{"$nulls":4},0,0]
["44.","Annual Debt Service Payments",{"$nulls":4},{"$f":"IF(AND('3005b IncomeStatement'!G58>=-999999999999,'3005b IncomeStatement'!G58<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},{"$f":"IF(AND('3005b IncomeStatement'!H58>=-999999999999,'3005b IncomeStatement'!H58<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"},null,null,{"$f":"ABS('3005b IncomeStatement'!G58)","v":0},{"$f":"ABS('3005b IncomeStatement'!H58)","v":0}]
["45.","Cash Ratio [(14+20-10-11)/7]",{"$nulls":4},0,0]
["46.","Operating Accrual Ratio [(14+20+26)/7]",{"$nulls":4},0,0]
["47.","TIER [(31+26)/26]",{"$nulls":4},0,0]
["48.","DSCR [(31+26+10+11)/44]",{"$nulls":4},0,0]
[]
[null,"Absolute Value Totals (Input Data Only)",{"$nulls":8},{"$f":"SUM(K3:K50)","v":0},{"$f":"SUM(L3:L50)","v":0}]

{"sheet":"3005c Hidden","index":6,"n_rows":36,"n_cols":3,"rows_kept":36,"hidden":true}
["PART C. STATEMENTS OF CASH FLOWS"]
["1.","Beginning Cash (Cash and Equivalents plus RUS Construction Fund)",{"$f":"IF(AND('3005c Cashflow'!H14>=-999999999999,'3005c Cashflow'!H14<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["CASH FLOWS FROM OPERATING ACTIVITIES"]
["2.","Net Income",{"$f":"IF(AND('3005c Cashflow'!H16>=-999999999999,'3005c Cashflow'!H16<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["Adjustments to Reconcile Net Income to Net Cash Provided by Operating Activities"]
["3.","Add: Depreciation",{"$f":"IF(AND('3005c Cashflow'!H18>=-999999999999,'3005c Cashflow'!H18<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["4.","Add: Amortization",{"$f":"IF(AND('3005c Cashflow'!H19>=-999999999999,'3005c Cashflow'!H19<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["5.","Other (Explain)",{"$f":"IF(AND('3005c Cashflow'!H20>=-999999999999,'3005c Cashflow'!H20<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["Changes in Operating Assets and Liabilities"]
["6.","Decrease/(Increase) in Accounts Receivable",{"$f":"IF(AND('3005c Cashflow'!H22>=-999999999999,'3005c Cashflow'!H22<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["7.","Decrease/(Increase) in Materials and Inventory",{"$f":"IF(AND('3005c Cashflow'!H23>=-999999999999,'3005c Cashflow'!H23<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["8.","Decrease/(Increase) in Prepayments and Deferred Charges",{"$f":"IF(AND('3005c Cashflow'!H24>=-999999999999,'3005c Cashflow'!H24<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["9.","Decrease/(Increase) in Other Current Assets",{"$f":"IF(AND('3005c Cashflow'!H25>=-999999999999,'3005c Cashflow'!H25<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["10.","Increase/(Decrease) in Accounts Payable",{"$f":"IF(AND('3005c Cashflow'!H26>=-999999999999,'3005c Cashflow'!H26<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["11.","Increase/(Decrease) in Advance Billings & Payments",{"$f":"IF(AND('3005c Cashflow'!H27>=-999999999999,'3005c Cashflow'!H27<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["12.","Increase/(Decrease) in Other Current Liabilities",{"$f":"IF(AND('3005c Cashflow'!H28>=-999999999999,'3005c Cashflow'!H28<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["13.","Net Cash Provided/(Used) by Operations",{"$f":"IF(AND('3005c Cashflow'!H29>=-999999999999,'3005c Cashflow'!H29<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["CASH FLOWS FROM FINANCING ACTIVITIES"]
["14.","Decrease/(Increase) in Notes Receivable",{"$f":"IF(AND('3005c Cashflow'!H31>=-999999999999,'3005c Cashflow'!H31<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["15.","Increase/(Decrease) in Notes Payable",{"$f":"IF(AND('3005c Cashflow'!H32>=-999999999999,'3005c Cashflow'!H32<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["16.","Increase/(Decrease) in Customer Deposits",{"$f":"IF(AND('3005c Cashflow'!H33>=-999999999999,'3005c Cashflow'!H33<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["17.","Net Increase/(Decrease) in Long Term Debt (Including Current Maturities)",{"$f":"IF(AND('3005c Cashflow'!H34>=-999999999999,'3005c Cashflow'!H34<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["18.","Increase/(Decrease) in Other Liabilities & Deferred Credits",{"$f":"IF(AND('3005c Cashflow'!H35>=-999999999999,'3005c Cashflow'!H35<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["19.","Increase/(Decrease) in Capital Stock, Paid-in Capital, Membership and Capital Certificates & Other Capital",{"$f":"IF(AND('3005c Cashflow'!H36>=-999999999999,'3005c Cashflow'!H36<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["20.","Less:  Payment of Dividends",{"$f":"IF(AND('3005c Cashflow'!H37>=-999999999999,'3005c Cashflow'!H37<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["21.","Less:  Patronage Capital Credits Retired",{"$f":"IF(AND('3005c Cashflow'!H38>=-999999999999,'3005c Cashflow'!H38<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["22.","Other (Explain)",{"$f":"IF(AND('3005c Cashflow'!H39>=-999999999999,'3005c Cashflow'!H39<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["23.","Net Cash Provided/(Used) by Financing Activities",{"$f":"IF(AND('3005c Cashflow'!H40>=-999999999999,'3005c Cashflow'!H40<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["CASH FLOWS FROM INVESTING ACTIVITIES"]
["24.","Net Capital Expenditures (Property, Plant & Equipment)",{"$f":"IF(AND('3005c Cashflow'!H42>=-999999999999,'3005c Cashflow'!H42<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["25.","Other Long-Term Investments",{"$f":"IF(AND('3005c Cashflow'!H43>=-999999999999,'3005c Cashflow'!H43<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["26.","Other Noncurrent Assets & Jurisdictional Differences",{"$f":"IF(AND('3005c Cashflow'!H44>=-999999999999,'3005c Cashflow'!H44<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["27.","Other (Explain)",{"$f":"IF(AND('3005c Cashflow'!H45>=-999999999999,'3005c Cashflow'!H45<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["28.","Net Cash Provided/(Used) by Investing Activities",{"$f":"IF(AND('3005c Cashflow'!H46>=-999999999999,'3005c Cashflow'!H46<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["29.","Net Increase/(Decrease) in Cash",{"$f":"IF(AND('3005c Cashflow'!H47>=-999999999999,'3005c Cashflow'!H47<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]
["30.","Ending Cash",{"$f":"IF(AND('3005c Cashflow'!H48>=-999999999999,'3005c Cashflow'!H48<=999999999999),\"Valid\",\"Invalid\")","v":"Valid"}]