{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Debt","CountyStatistics","ContactInfo","General Data","General Obligation","Revenue","County Supplemental Data","Dropdowns"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":11,"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":"Debt","index":0,"n_rows":35,"n_cols":12,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["Tab","County","ReportingEntity","ReportingEntityType","FiscalYear","DebtType","Term","Purpose","BeginFY","IssuedFY","RetiredFY","EndFY"]
["General Obligation",{"$f":"PROPER(County)","v":""},{"$f":"PROPER(ReportEnt)","v":""},{"$f":"PROPER(ReportEntType)","v":""},{"$f":"FYEnd","v":"06/30/2018"},"General Obligation","NA","Drainage/Flood Control",{"$f":"'General Obligation'!B11","v":0},{"$f":"'General Obligation'!C11","v":0},{"$f":"'General Obligation'!D11","v":0},{"$f":"'General Obligation'!E11","v":0}]
["General Obligation","","","","06/30/2018","General Obligation","NA","Governmental Facilities",{"$f":"'General Obligation'!B12","v":0},{"$f":"'General Obligation'!C12","v":0},{"$f":"'General Obligation'!D12","v":0},{"$f":"'General Obligation'!E12","v":0}]
["General Obligation","","","","06/30/2018","General Obligation","NA","Hospital",{"$f":"'General Obligation'!B13","v":0},{"$f":"'General Obligation'!C13","v":0},{"$f":"'General Obligation'!D13","v":0},{"$f":"'General Obligation'!E13","v":0}]
["General Obligation","","","","06/30/2018","General Obligation","NA","Parks/Recreation",{"$f":"'General Obligation'!B14","v":0},{"$f":"'General Obligation'!C14","v":0},{"$f":"'General Obligation'!D14","v":0},{"$f":"'General Obligation'!E14","v":0}]
["General Obligation","","","","06/30/2018","General Obligation","NA","Streets/Bridges",{"$f":"'General Obligation'!B15","v":0},{"$f":"'General Obligation'!C15","v":0},{"$f":"'General Obligation'!D15","v":0},{"$f":"'General Obligation'!E15","v":0}]
["General Obligation","","","","06/30/2018","General Obligation","NA","Water Utility Only",{"$f":"'General Obligation'!B16","v":0},{"$f":"'General Obligation'!C16","v":0},{"$f":"'General Obligation'!D16","v":0},{"$f":"'General Obligation'!E16","v":0}]
["General Obligation","","","","06/30/2018","General Obligation","NA","Sewer Utility Only",{"$f":"'General Obligation'!B17","v":0},{"$f":"'General Obligation'!C17","v":0},{"$f":"'General Obligation'!D17","v":0},{"$f":"'General Obligation'!E17","v":0}]
["General Obligation","","","","06/30/2018","General Obligation","NA","Water/Sewer Combined",{"$f":"'General Obligation'!B18","v":0},{"$f":"'General Obligation'!C18","v":0},{"$f":"'General Obligation'!D18","v":0},{"$f":"'General Obligation'!E18","v":0}]
["General Obligation","","","","06/30/2018","General Obligation","NA","Transit",{"$f":"'General Obligation'!B19","v":0},{"$f":"'General Obligation'!C19","v":0},{"$f":"'General Obligation'!D19","v":0},{"$f":"'General Obligation'!E19","v":0}]
["General Obligation","","","","06/30/2018","General Obligation","NA","Other",{"$f":"'General Obligation'!B20","v":0},{"$f":"'General Obligation'!C20","v":0},{"$f":"'General Obligation'!D20","v":0},{"$f":"'General Obligation'!E20","v":0}]
["General Obligation","","","","06/30/2018","General Obligation","NA","General Obligation Debt Issued by Referendum",{"$f":"'General Obligation'!B22","v":0},{"$f":"'General Obligation'!C22","v":0},{"$f":"'General Obligation'!D22","v":0},{"$f":"'General Obligation'!E22","v":0}]
["General Obligation","","","","06/30/2018","Other General Obligation","NA","Mortgage Loans",{"$f":"'General Obligation'!B26","v":0},{"$f":"'General Obligation'!C26","v":0},{"$f":"'General Obligation'!D26","v":0},{"$f":"'General Obligation'!E26","v":0}]
["General Obligation","","","","06/30/2018","Other General Obligation","NA","Bank Loans/Notes",{"$f":"'General Obligation'!B27","v":0},{"$f":"'General Obligation'!C27","v":0},{"$f":"'General Obligation'!D27","v":0},{"$f":"'General Obligation'!E27","v":0}]
["General Obligation","","","","06/30/2018","Other General Obligation","NA","Capital Lease Purchase",{"$f":"'General Obligation'!B28","v":0},{"$f":"'General Obligation'!C28","v":0},{"$f":"'General Obligation'!D28","v":0},{"$f":"'General Obligation'!E28","v":0}]
["General Obligation","","","","06/30/2018","Other General Obligation","NA","Other Lease Purchase Obligations",{"$f":"'General Obligation'!B29","v":0},{"$f":"'General Obligation'!C29","v":0},{"$f":"'General Obligation'!D29","v":0},{"$f":"'General Obligation'!E29","v":0}]
["General Obligation","","","","06/30/2018","Other General Obligation","NA","Certificates of Participation",{"$f":"'General Obligation'!B30","v":0},{"$f":"'General Obligation'!C30","v":0},{"$f":"'General Obligation'!D30","v":0},{"$f":"'General Obligation'!E30","v":0}]
["General Obligation","","","","06/30/2018","Other General Obligation","NA","Other General Obligations",{"$f":"'General Obligation'!B31","v":0},{"$f":"'General Obligation'!C31","v":0},{"$f":"'General Obligation'!D31","v":0},{"$f":"'General Obligation'!E31","v":0}]
["General Obligation","","","","06/30/2018","Other General Obligation","NA","General Obligation Debt Issued by Referendum",{"$f":"'General Obligation'!B33","v":0},{"$f":"'General Obligation'!C33","v":0},{"$f":"'General Obligation'!D33","v":0},{"$f":"'General Obligation'!E33","v":0}]
["Revenue","","","","06/30/2018","Revenue","NA","Drainage/Flood Control",{"$f":"Revenue!B11","v":0},{"$f":"Revenue!C11","v":0},{"$f":"Revenue!D11","v":0},{"$f":"Revenue!E11","v":0}]
["Revenue","","","","06/30/2018","Revenue","NA","Governmental Facilities",{"$f":"Revenue!B12","v":0},{"$f":"Revenue!C12","v":0},{"$f":"Revenue!D12","v":0},{"$f":"Revenue!E12","v":0}]
["Revenue","","","","06/30/2018","Revenue","NA","Hospital",{"$f":"Revenue!B13","v":0},{"$f":"Revenue!C13","v":0},{"$f":"Revenue!D13","v":0},{"$f":"Revenue!E13","v":0}]
["Revenue","","","","06/30/2018","Revenue","NA","Parks/Recreation",{"$f":"Revenue!B14","v":0},{"$f":"Revenue!C14","v":0},{"$f":"Revenue!D14","v":0},{"$f":"Revenue!E14","v":0}]
["Revenue","","","","06/30/2018","Revenue","NA","Streets/Bridges",{"$f":"Revenue!B15","v":0},{"$f":"Revenue!C15","v":0},{"$f":"Revenue!D15","v":0},{"$f":"Revenue!E15","v":0}]
["Revenue","","","","06/30/2018","Revenue","NA","Water Utility Only",{"$f":"Revenue!B16","v":0},{"$f":"Revenue!C16","v":0},{"$f":"Revenue!D16","v":0},{"$f":"Revenue!E16","v":0}]
["Revenue","","","","06/30/2018","Revenue","NA","Sewer Utility Only",{"$f":"Revenue!B17","v":0},{"$f":"Revenue!C17","v":0},{"$f":"Revenue!D17","v":0},{"$f":"Revenue!E17","v":0}]
["Revenue","","","","06/30/2018","Revenue","NA","Water/Sewer Combined",{"$f":"Revenue!B18","v":0},{"$f":"Revenue!C18","v":0},{"$f":"Revenue!D18","v":0},{"$f":"Revenue!E18","v":0}]
["Revenue","","","","06/30/2018","Revenue","NA","Transit",{"$f":"Revenue!B19","v":0},{"$f":"Revenue!C19","v":0},{"$f":"Revenue!D19","v":0},{"$f":"Revenue!E19","v":0}]
["Revenue","","","","06/30/2018","Revenue","NA","Other",{"$f":"Revenue!B20","v":0},{"$f":"Revenue!C20","v":0},{"$f":"Revenue!D20","v":0},{"$f":"Revenue!E20","v":0}]
["Revenue","","","","06/30/2018","Other Revenue","NA","Mortgage Loans",{"$f":"Revenue!B24","v":0},{"$f":"Revenue!C24","v":0},{"$f":"Revenue!D24","v":0},{"$f":"Revenue!E24","v":0}]
["Revenue","","","","06/30/2018","Other Revenue","NA","Bank Loans/Notes",{"$f":"Revenue!B25","v":0},{"$f":"Revenue!C25","v":0},{"$f":"Revenue!D25","v":0},{"$f":"Revenue!E25","v":0}]
["Revenue","","","","06/30/2018","Other Revenue","NA","Capital Lease Purchase",{"$f":"Revenue!B26","v":0},{"$f":"Revenue!C26","v":0},{"$f":"Revenue!D26","v":0},{"$f":"Revenue!E26","v":0}]
["Revenue","","","","06/30/2018","Other Revenue","NA","Other Lease Purchase Obligations",{"$f":"Revenue!B27","v":0},{"$f":"Revenue!C27","v":0},{"$f":"Revenue!D27","v":0},{"$f":"Revenue!E27","v":0}]
["Revenue","","","","06/30/2018","Other Revenue","NA","Certificates of Participation",{"$f":"Revenue!B28","v":0},{"$f":"Revenue!C28","v":0},{"$f":"Revenue!D28","v":0},{"$f":"Revenue!E28","v":0}]
["Revenue","","","","06/30/2018","Other Revenue","NA","Other General Obligations",{"$f":"Revenue!B29","v":0},{"$f":"Revenue!C29","v":0},{"$f":"Revenue!D29","v":0},{"$f":"Revenue!E29","v":0}]

{"sheet":"CountyStatistics","index":1,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["Tab","County","ReportingEntity","FiscalYear","Section","Category","Statistic","StatisticValue","StatisticPercent"]
["County Supplemental Data",{"$f":"PROPER(County)","v":""},{"$f":"PROPER(ReportEnt)","v":""},{"$f":"FY","v":"06/30/2018"},"Tax Data","Debt Limit","8% of Assessed Property Valuation",{"$f":"'County Supplemental Data'!C14","v":0},0]
["County Supplemental Data","","","06/30/2018","Tax Data","Debt Limit","General Obligation Debt Outstanding",{"$f":"'County Supplemental Data'!C15","v":0},0]
["County Supplemental Data","","","06/30/2018","Tax Data","Debt Limit","Less General Obligation Debt Issued by Referendum",{"$f":"'County Supplemental Data'!C16","v":0},0]
["County Supplemental Data","","","06/30/2018","Tax Data","Debt Limit","Total General Obligation Debt Outstanding",{"$f":"'County Supplemental Data'!C17","v":0},0]
["County Supplemental Data","","","06/30/2018","Tax Data","Debt Limit","Debt Margin",{"$f":"'County Supplemental Data'!C18","v":0},0]
["County Supplemental Data","","","06/30/2018","Tax Data","General Tax Data","Assessed Property Valuation",{"$f":"'County Supplemental Data'!C10","v":0},0]
["County Supplemental Data","","","06/30/2018","Tax Data","General Tax Data","Current Tax Collections",0,{"$f":"'County Supplemental Data'!D11","v":0}]
["County Supplemental Data","","","06/30/2018","Economic Profile","Major Employers",{"$f":"IF(PROPER('County Supplemental Data'!A31)=\"\",0,PROPER('County Supplemental Data'!A31))","v":0},{"$f":"'County Supplemental Data'!D31","v":0},0]
["County Supplemental Data","","","06/30/2018","Economic Profile","Major Employers",{"$f":"IF(PROPER('County Supplemental Data'!A32)=\"\",0,PROPER('County Supplemental Data'!A32))","v":0},{"$f":"'County Supplemental Data'!D32","v":0},0]
["County Supplemental Data","","","06/30/2018","Economic Profile","Major Employers",{"$f":"IF(PROPER('County Supplemental Data'!A33)=\"\",0,PROPER('County Supplemental Data'!A33))","v":0},{"$f":"'County Supplemental Data'!D33","v":0},0]
["County Supplemental Data","","","06/30/2018","Economic Profile","Major Employers",{"$f":"IF(PROPER('County Supplemental Data'!A34)=\"\",0,PROPER('County Supplemental Data'!A34))","v":0},{"$f":"'County Supplemental Data'!D34","v":0},0]
["County Supplemental Data","","","06/30/2018","Economic Profile","Major Employers",{"$f":"IF(PROPER('County Supplemental Data'!A35)=\"\",0,PROPER('County Supplemental Data'!A35))","v":0},{"$f":"'County Supplemental Data'!D35","v":0},0]
["County Supplemental Data","","","06/30/2018","Tax Data","Revenue Sources","Property Taxes",{"$f":"'County Supplemental Data'!C21","v":0},0]
["County Supplemental Data","","","06/30/2018","Tax Data","Revenue Sources","State Aid",{"$f":"'County Supplemental Data'!C22","v":0},0]
["County Supplemental Data","","","06/30/2018","Tax Data","Revenue Sources","Federal Aid",{"$f":"'County Supplemental Data'!C23","v":0},0]
["County Supplemental Data","","","06/30/2018","Tax Data","Revenue Sources","Fees, Fines and Forfeitures",{"$f":"'County Supplemental Data'!C24","v":0},0]
["County Supplemental Data","","","06/30/2018","Tax Data","Revenue Sources","Interest Income",{"$f":"'County Supplemental Data'!C25","v":0},0]
["County Supplemental Data","","","06/30/2018","Tax Data","Revenue Sources","Other",{"$f":"'County Supplemental Data'!C26","v":0},0]

{"sheet":"ContactInfo","index":2,"n_rows":2,"n_cols":9,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Tab","County","ReportingEntity","ReportingEntityType","FiscalYear","PreparedBy","Email","Phone","Fax"]
["General Data",{"$f":"PROPER(County)","v":""},{"$f":"PROPER(ReportEnt)","v":""},{"$f":"PROPER(ReportEntType)","v":""},{"$f":"FY","v":"06/30/2018"},{"$f":"Prepared","v":0},{"$f":"TRIM(PrepEmail)","v":""},{"$f":"TRIM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(PrepPhone,\"-\",\"\"),\")\",\"\"),\"(\",\"\"))","v":""},{"$f":"TRIM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(PrepFax,\"-\",\"\"),\")\",\"\"),\"(\",\"\"))","v":""}]

{"sheet":"General Data","index":3,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[[3,1,3,4],[2,1,2,4],[8,1,8,4],[0,0,1,4],[12,1,12,4],[7,1,7,4],[9,1,9,2],[9,3,9,4],[5,1,5,4],[4,1,4,4]]}
["South Carolina Office of the State Treasurer\nReport of Local Government Debt"]
[]
["County"]
["Name of Reporting Entity"]
["Reporting Entity Type"]
["Fiscal Year Ending Date",{"$f":"IF(MONTH(TODAY())>6,\"06/30/\"&YEAR(TODAY()),\"06/30/\"&YEAR(TODAY())-1)","v":"06/30/2018"},null,null,null,"County"]
[]
["Preparer's name",null,null,null,null,"vcbvc"]
["Preparer's email address",null,null,null,null,"School District"]
["Preparer's phone/fax",null,null,null,null,"Special Purpose District"]
[null,"phone",null,"fax"]
[]
["Return this form to ","sto.lgdr@sto.sc.gov"]
[]
["Alerts"]
[{"$f":"IF(AND(B5=\"County\",'County Supplemental Data'!C18<0),\"General Obligation Debt Exceeds Debt Limitation.  Please provide supporting justification.\",\"\")","v":""}]
["Instructions:"]
["County has a drop down box to make your choice"]
["Name of Reporting Entity is your county, city, town, school district, or special purpose district"]
["Reporting Entity has a drop down box to make your choice"]
["Fiscal Year is prefilled for your convenience"]
["You will need to provide the Preparer's name, email address, and phone/ fax numbers"]
["Please note the tabs at the bottom will take you to the actual report to fill in your information"]
["Once the report is completely filled out please press the Email Form button to send directly to the STO office "]

{"sheet":"General Obligation","index":4,"n_rows":43,"n_cols":5,"rows_kept":43,"cut":false,"hidden":false,"merged":[[42,0,42,4],[2,1,2,3],[40,0,40,4],[7,0,7,4],[5,0,5,4],[3,0,3,4]]}
["County",{"$f":"PROPER(IF('General Data'!B3:D3<>\"\",'General Data'!B3:D3,\"\"))","v":""}]
["Name of Reporting Entity",{"$f":"PROPER(IF('General Data'!B4:D4<>\"\",'General Data'!B4:D4,\"\"))","v":""}]
["Fiscal Year Ending",{"$f":"IF('General Data'!B6:D6<>\"\",'General Data'!B6:D6,\"\")","v":"06/30/2018"}]
["General Obligation Debt Outstanding, Issued and Retired"]
[]
["Instructions:  In these sections, include all debt that is to be repaid from the governmental entity's general fund.\nGeneral obligation debt is that which is secured by the full faith, credit and taxing power of the governmental entity."]
[]
["Section I: General Obligation Debt Outstanding Principal Amounts Only"]
[]
["General Obligation Bond Debt","Outstanding at Beginning of Fiscal Year","Issued During Fiscal Year","Amount Retired During Fiscal Year","Outstanding at End of Fiscal Year"]
["Drainage/Flood Control",null,null,null,{"$f":"B11+C11-D11","v":0}]
["Governmental Facilities",null,null,null,{"$f":"B12+C12-D12","v":0}]
["Hospital",null,null,null,0]
["Parks/Recreation",null,null,null,0]
["Streets/Bridges",null,null,null,0]
["Water Utility Only",null,null,null,0]
["Sewer Utility Only",null,null,null,0]
["Water/Sewer Combined",null,null,null,0]
["Transit",null,null,null,0]
["Other",null,null,null,0]
[null,null,null,null,0]
["General Obligation Debt Issued by Referendum",null,null,null,0]
["Subtotal General Obligation Bond Debt",{"$f":"SUM(B11:B22)","v":0},{"$f":"SUM(C11:C22)","v":0},{"$f":"SUM(D11:D22)","v":0},{"$f":"SUM(E11:E22)","v":0}]
[]
["Other General Obligation Debt","Outstanding at Beginning of Fiscal Year","Issued During Fiscal Year","Amount Retired During Fiscal Year","Outstanding at End of Fiscal Year"]
["Mortgage Loans",null,null,null,{"$f":"B26+C26-D26","v":0}]
["Bank Loans/Notes",null,null,null,{"$f":"B27+C27-D27","v":0}]
["Capital Lease Purchase",null,null,null,0]
["Other Lease Purchase Obligations",null,null,null,0]
["Certificates of Participation",null,null,null,0]
["Other General Obligations",null,null,null,0]
[]
["General Obligation Debt Issued by Referendum",null,null,null,{"$f":"B33+C33-D33","v":0}]
["Subtotal Other General Obligation Debt",{"$f":"SUM(B26:B33)","v":0},{"$f":"SUM(C26:C33)","v":0},0,{"$f":"SUM(E26:E33)","v":0}]
[]
["Grand Total - General Obligation Debt Issued by Referendum",{"$f":"B22+B33","v":0},{"$f":"C22+C33","v":0},0,{"$f":"E22+E33","v":0}]
["Grand Total - General Obligation Debt",{"$f":"SUM(B23,B34)","v":0},{"$f":"SUM(C23,C34)","v":0},{"$f":"SUM(D23,D34)","v":0},{"$f":"E34+E23","v":0}]
[]
[]
["IMPORTANT NOTICE:"]
["The amounts reflected in Beginning Balance must tie to the Ending Balance of the prior year's Audited Financial Statements.  Ending balances must tie to the Ending Balance of the current (reporting year) year's Audited Financial Statements. Please provide explanation for any variances to the reporting in the Audited Financial Statements."]
[]
["Included in this page should be an General Obligation debt.  This is any debt that would be paid by the citizens of the reporting entity. Please note that any debt issued by bond referendum is reported separately. "]

{"sheet":"Revenue","index":5,"n_rows":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,0,37,4],[35,0,35,4],[2,1,2,3],[3,0,3,4],[5,0,5,4],[7,0,7,4]]}
["County",{"$f":"PROPER(IF('General Data'!B3:D3<>\"\",'General Data'!B3:D3,\"\"))","v":""}]
["Name of Reporting Entity",{"$f":"PROPER(IF('General Data'!B4:D4<>\"\",'General Data'!B4:D4,\"\"))","v":""}]
["Fiscal Year Ending",{"$f":"IF('General Data'!B6:D6<>\"\",'General Data'!B6:D6,\"\")","v":"06/30/2018"}]
["Revenue Debt Outstanding, Issued and Retired"]
[]
["Instructions:  In these sections, include all debt that is to be repaid from revenue producing activities.\nRevenue debt is that which is secured by the revenue produced from the project for which the borrowing was made."]
[]
["Section I: Revenue Bond Debt Outstanding Principal Amounts Only"]
[]
["Revenue Bond Debt","Outstanding at Beginning of Fiscal Year","Issued During Fiscal Year","Amount Retired During Fiscal Year","Outstanding at End of Fiscal Year"]
["Drainage/Flood Control",null,null,null,{"$f":"B11+C11-D11","v":0}]
["Governmental Facilities",null,null,null,{"$f":"B12+C12-D12","v":0}]
["Hospital",null,null,null,0]
["Parks/Recreation",null,null,null,0]
["Streets/Bridges",null,null,null,0]
["Water Utility Only",null,null,null,0]
["Sewer Utility Only",null,null,null,0]
["Water/Sewer Combined",null,null,null,0]
["Transit",null,null,null,0]
["Other",null,null,null,0]
["Subtotal Revenue Bond Debt",{"$f":"SUM(B11:B20)","v":0},{"$f":"SUM(C11:C20)","v":0},{"$f":"SUM(D11:D20)","v":0},0]
[]
["Other Revenue Bond Debt","Outstanding at Beginning of Fiscal Year","Issued During Fiscal Year","Amount Retired During Fiscal Year","Outstanding at End of Fiscal Year"]
["Mortgage Loans",null,null,null,{"$f":"B24+C24-D24","v":0}]
["Bank Loans/Notes",null,null,null,0]
["Capital Lease Purchase",null,null,null,0]
["Other Lease Purchase Obligations",null,null,null,0]
["Certificates of Participation",null,null,null,0]
["Other General Obligations",null,null,null,0]
["Subtotal Other Revenue Bond Debt",{"$f":"SUM(B24:B29)","v":0},{"$f":"SUM(C24:C29)","v":0},{"$f":"SUM(D24:D29)","v":0},0]
[]
["Grand Total - Revenue Bond Debt",{"$f":"SUM(B21,B30)","v":0},{"$f":"SUM(C21,C30)","v":0},{"$f":"SUM(D21,D30)","v":0},0]
[]
[]
["IMPORTANT NOTICE:"]
["The amounts reflected in Beginning Balance must tie to the Ending Balance of the prior year's Audited Financial Statements.  Ending balances must tie to the Ending Balance of the current (reporting year) year's Audited Financial Statements. Please provide explanation for any variances to the reporting in the Audited Financial Statements."]
[]
["Revenue Bond issuances are bonds/loans that are paid with a designated source of income. Only debt associated with a designated source of revenue should be reported on this page. "]

{"sheet":"County Supplemental Data","index":6,"n_rows":40,"n_cols":4,"rows_kept":40,"cut":false,"hidden":false,"merged":[[34,0,34,2],[26,0,26,1],[32,0,32,2],[31,0,31,2],[30,0,30,2],[33,0,33,2],[28,0,28,3],[29,0,29,2],[5,0,5,3],[7,0,7,3],[8,0,8,1],[3,0,3,3],[10,0,10,1],[9,0,9,1],[14,0,14,1],[16,0,16,1],[13,0,13,1],[12,0,12,1],[21,0,21,1],[20,0,20,1],[19,0,19,1],[17,0,17,1],[24,0,24,1],[23,0,23,1],[22,0,22,1],[25,0,25,1],[15,0,15,1]]}
["County",{"$f":"PROPER(IF('General Data'!B3:D3<>\"\",'General Data'!B3:D3,\"\"))","v":""}]
["Name of Reporting Entity",{"$f":"PROPER(IF('General Data'!B4:D4<>\"\",'General Data'!B4:D4,\"\"))","v":""}]
["Fiscal Year Ending",{"$f":"IF('General Data'!B6:D6<>\"\",'General Data'!B6:D6,\"\")","v":"06/30/2018"}]
["County Supplemental Data"]
[]
["Instructions:  In these sections, include most recent information available to the county concerning its taxes and collections,\nsources of revenue, and major employers."]
[]
["Section I:  Tax Data"]
["General Tax Data",null,"Amount","Percent"]
["Assessed Property Valuation"]
["Current Tax Collections"]
[]
["Compliance with Debt Limitation"]
["8% of Assessed Property Valuation",null,{"$f":"C10*8%","v":0}]
["General Obligation Debt Outstanding",null,{"$f":"SUM('General Obligation'!E37)","v":0}]
["Less General Obligation Debt Issued by Referendum",null,{"$f":"'General Obligation'!E36","v":0}]
["Total General Obligation Debt Outstanding",null,{"$f":"C15-C16","v":0}]
["Debt Margin",null,{"$f":"C14-C17","v":0}]
[]
["Revenue Sources"]
["Property Taxes",null,null,{"$f":"IF(ISERROR(C21/$C$27),\"\",ROUND(C21/$C$27,8))","v":""}]
["State Aid",null,null,{"$f":"IF(ISERROR(C22/$C$27),\"\",ROUND(C22/$C$27,8))","v":""}]
["Federal Aid",null,null,""]
["Fees, Fines and Forfeitures",null,null,""]
["Interest Income",null,null,""]
["Other",null,null,""]
["Total Revenue Sources",null,{"$f":"SUM(C21:C26)","v":0},""]
[]
["Section II:  Economic Profile"]
["Five Major Employers",null,null,"Number Employed in County"]
[]
[]
[]
[]
[]
[]
["This page needs to be completed by the county treasurer.  The Assessed Property valuation should be reported by the county assessor the county treasurer. "]
["Compliance with Debt Limitation will automatically populate. "]
["Revenue Sources should be completed by the county treasurer. "]
["Economic Profile should be completed by the county treasurer.  "]

{"sheet":"Dropdowns","index":7,"n_rows":47,"n_cols":4,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
["CountyNo","CountyTxt",null,"ReportingEntityType"]
["001","Abbeville",null,"County"]
["002","Aiken",null,"School District"]
["003","Allendale",null,"Municipality"]
["004","Anderson",null,"Special Purpose District"]
["005","Bamberg"]
["006","Barnwell"]
["007","Beaufort"]
["008","Berkeley"]
["009","Calhoun"]
["010","Charleston"]
["011","Cherokee"]
["012","Chester"]
["013","Chesterfield"]
["014","Clarendon"]
["015","Colleton"]
["016","Darlington"]
["017","Dillon"]
["018","Dorchester"]
["019","Edgefield"]
["020","Fairfield"]
["021","Florence"]
["022","Georgetown"]
["023","Greenville"]
["024","Greenwood"]
["025","Hampton"]
["026","Horry"]
["027","Jasper"]
["028","Kershaw"]
["029","Lancaster"]
["030","Laurens"]
["031","Lee"]
["032","Lexington"]
["033","Mccormick"]
["034","Marion"]
["035","Marlboro"]
["036","Newberry"]
["037","Oconee"]
["038","Orangeburg"]
["039","Pickens"]
["040","Richland"]
["041","Saluda"]
["042","Spartanburg"]
["043","Sumter"]
["044","Union"]
["045","Williamsburg"]
["046","York"]