{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["貸借対照表","純資産変動計算書","行政コスト計算書","資金収支計算書","有形固定資産の明細","有形固定資産の行政目的別明細","投資及び出資金","基金","貸付金","長期延滞債権","未収金","地方債（借入先別）","地方債（利率別など）","引当金","補助金","財源明細","財源情報明細","資金明細","財源会計テンプレート"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":106,"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":"貸借対照表","index":0,"n_rows":71,"n_cols":31,"rows_kept":71,"cut":false,"hidden":true,"merged":[[8,3,8,26],[9,3,9,26],[11,3,11,14],[11,15,11,16],[11,17,11,24],[11,25,11,26],[28,17,28,24],[33,17,33,24],[67,17,67,24],[68,3,68,14],[68,17,68,24]]}
[null,null,null,"*出力条件"]
[null,null,null,"*会計年度 ： H28"]
[null,null,null,"*出力帳票選択 ： 財務書類"]
[null,null,null,"*団体区分 ： 会計別"]
[null,null,null,"*団体／会計コード ： 001  ／  01   一般会計等  ／  一般会計"]
[null,null,null,"*出力範囲 ： 年次"]
[null,null,null,"*出力金額単位 ： 円"]
[]
[null,null,null,"貸借対照表"]
[null,null,null,"（平成２９年３月３１日現在）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（単位：円）"]
["科目コード","科目コー",null,"科目",null,null,null,null,null,null,null,null,null,null,null,"金額",null,"科目",null,null,null,null,null,null,null,"金額"]
[null,null,null,"【資産の部】",null,null,null,null,null,null,null,null,null,null,null,null,null,"【負債の部】"]
["1020000","1590000",null,null,"固定資産",null,null,null,null,null,null,null,null,null,null,54826410977,null,null,"固定負債",null,null,null,null,null,null,25055942048,null,null,null,{"$f":"IF(AND(AD15=\"-\",AD43=\"-\",AD46=\"-\"),\"-\",SUM(AD15,AD43,AD46))","v":54826410977},{"$f":"IF(COUNTIF(AE15:AE19,\"-\")=COUNTA(AE15:AE19),\"-\",SUM(AE15:AE19))","v":25055942048}]
["1030000","1600000",null,null,null,"有形固定資産",null,null,null,null,null,null,null,null,null,51400853540,null,null,null,"地方債",null,null,null,null,null,19437392694,null,null,null,{"$f":"IF(AND(AD16=\"-\",AD32=\"-\",COUNTIF(AD41:AD42,\"-\")=COUNTA(AD41:AD42)),\"-\",SUM(AD16,AD32,AD41:AD42))","v":51400853540},19437392694]
["1040000","1610000",null,null,null,null,"事業用資産",null,null,null,null,null,null,null,null,38357064249,null,null,null,"長期未払金",null,null,null,null,null,"-",null,null,null,{"$f":"IF(COUNTIF(AD17:AD31,\"-\")=COUNTA(AD17:AD31),\"-\",SUM(AD17:AD31))","v":38357064249},"-"]
["1050000","1620000",null,null,null,null,null,"土地",null,null,null,null,null,null,null,25534427820,null,null,null,"退職手当引当金",null,null,null,null,null,5517048354,null,null,null,25534427820,5517048354]
["1060000","1630000",null,null,null,null,null,"立木竹",null,null,null,null,null,null,null,"-",null,null,null,"損失補償等引当金",null,null,null,null,null,101501000,null,null,null,"-",101501000]
["1070000","1640000",null,null,null,null,null,"建物",null,null,null,null,null,null,null,13912604575,null,null,null,"その他",null,null,null,null,null,"-",null,null,null,13912604575,"-"]
["1080000","1650000",null,null,null,null,null,"建物減価償却累計額",null,null,null,null,null,null,null,-1343131583,null,null,"流動負債",null,null,null,null,null,null,213752537,null,null,null,-1343131583,{"$f":"IF(COUNTIF(AE21:AE28,\"-\")=COUNTA(AE21:AE28),\"-\",SUM(AE21:AE28))","v":213752537}]
["1090000","1660000",null,null,null,null,null,"工作物",null,null,null,null,null,null,null,255511944,null,null,null,"1年内償還予定地方債",null,null,null,null,null,"-",null,null,null,255511944,"-"]
["1100000","1670000",null,null,null,null,null,"工作物減価償却累計額",null,null,null,null,null,null,null,-33668507,null,null,null,"未払金",null,null,null,null,null,"-",null,null,null,-33668507,"-"]
["1110000","1680000",null,null,null,null,null,"船舶",null,null,null,null,null,null,null,"-",null,null,null,"未払費用",null,null,null,null,null,"-",null,null,null,"-","-"]
["1120000","1690000",null,null,null,null,null,"船舶減価償却累計額",null,null,null,null,null,null,null,"-",null,null,null,"前受金",null,null,null,null,null,"-",null,null,null,"-","-"]
["1130000","1700000",null,null,null,null,null,"浮標等",null,null,null,null,null,null,null,"-",null,null,null,"前受収益",null,null,null,null,null,"-",null,null,null,"-","-"]
["1140000","1710000",null,null,null,null,null,"浮標等減価償却累計額",null,null,null,null,null,null,null,"-",null,null,null,"賞与等引当金",null,null,null,null,null,258699272,null,null,null,"-",258699272]
["1150000","1720000",null,null,null,null,null,"航空機",null,null,null,null,null,null,null,"-",null,null,null,"預り金",null,null,null,null,null,-44946735,null,null,null,"-",-44946735]
["1160000","1730000",null,null,null,null,null,"航空機減価償却累計額",null,null,null,null,null,null,null,"-",null,null,null,"その他",null,null,null,null,null,"-",null,null,null,"-","-"]
["1170000","1580000",null,null,null,null,null,"その他",null,null,null,null,null,null,null,"-",null,"負債合計",null,null,null,null,null,null,null,25269694585,null,null,null,"-",{"$f":"IF(AND(AE14=\"-\",AE20=\"-\"),\"-\",SUM(AE14,AE20))","v":25269694585}]
["1180000",null,null,null,null,null,null,"その他減価償却累計額",null,null,null,null,null,null,null,"-",null,"【純資産の部】",null,null,null,null,null,null,null,null,null,null,null,"-"]
["1190000","1750000",null,null,null,null,null,"建設仮勘定",null,null,null,null,null,null,null,31320000,null,null,"固定資産等形成分",null,null,null,null,null,null,56508018890,null,null,null,31320000,56508018890]
["1200000","1760000",null,null,null,null,"インフラ資産",null,null,null,null,null,null,null,null,13002190515,null,null,"余剰分（不足分）",null,null,null,null,null,null,-24008570818,null,null,null,{"$f":"IF(COUNTIF(AD33:AD40,\"-\")=COUNTA(AD33:AD40),\"-\",SUM(AD33:AD40))","v":13002190515},-24008570818]
["1210000",null,null,null,null,null,null,"土地",null,null,null,null,null,null,null,10763517256,null,null,null,null,null,null,null,null,null,null,null,null,null,10763517256]
["1220000",null,null,null,null,null,null,"建物",null,null,null,null,null,null,null,116045417,null,null,null,null,null,null,null,null,null,null,null,null,null,116045417]
["1230000",null,null,null,null,null,null,"建物減価償却累計額",null,null,null,null,null,null,null,-14387497,null,null,null,null,null,null,null,null,null,null,null,null,null,-14387497]
["1240000",null,null,null,null,null,null,"工作物",null,null,null,null,null,null,null,2363078462,null,null,null,null,null,null,null,null,null,null,null,null,null,2363078462]
["1250000",null,null,null,null,null,null,"工作物減価償却累計額",null,null,null,null,null,null,null,-226063123,null,null,null,null,null,null,null,null,null,null,null,null,null,-226063123]
["1260000",null,null,null,null,null,null,"その他",null,null,null,null,null,null,null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
["1270000",null,null,null,null,null,null,"その他減価償却累計額",null,null,null,null,null,null,null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
["1280000",null,null,null,null,null,null,"建設仮勘定",null,null,null,null,null,null,null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
["1290000",null,null,null,null,null,"物品",null,null,null,null,null,null,null,null,109035168,null,null,null,null,null,null,null,null,null,null,null,null,null,109035168]
["1300000",null,null,null,null,null,"物品減価償却累計額",null,null,null,null,null,null,null,null,-67436392,null,null,null,null,null,null,null,null,null,null,null,null,null,-67436392]
["1310000",null,null,null,null,"無形固定資産",null,null,null,null,null,null,null,null,null,111276157,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(AD44:AD45,\"-\")=COUNTA(AD44:AD45),\"-\",SUM(AD44:AD45))","v":111276157}]
["1320000",null,null,null,null,null,"ソフトウェア",null,null,null,null,null,null,null,null,111275935,null,null,null,null,null,null,null,null,null,null,null,null,null,111275935]
["1330000",null,null,null,null,null,"その他",null,null,null,null,null,null,null,null,222,null,null,null,null,null,null,null,null,null,null,null,null,null,222]
["1340000",null,null,null,null,"投資その他の資産",null,null,null,null,null,null,null,null,null,3314281280,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(AD47:AD58,\"-\")=COUNTA(AD47:AD58),\"-\",SUM(AD47,AD51:AD54,AD57:AD58))","v":3314281280}]
["1350000",null,null,null,null,null,"投資及び出資金",null,null,null,null,null,null,null,null,1698991000,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(AD48:AD50,\"-\")=COUNTA(AD48:AD50),\"-\",SUM(AD48:AD50))","v":1698991000}]
["1360000",null,null,null,null,null,null,"有価証券",null,null,null,null,null,null,null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
["1370000",null,null,null,null,null,null,"出資金",null,null,null,null,null,null,null,1698991000,null,null,null,null,null,null,null,null,null,null,null,null,null,1698991000]
["1380000",null,null,null,null,null,null,"その他",null,null,null,null,null,null,null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
["1390000",null,null,null,null,null,"投資損失引当金",null,null,null,null,null,null,null,null,-3000000,null,null,null,null,null,null,null,null,null,null,null,null,null,-3000000]
["1400000",null,null,null,null,null,"長期延滞債権",null,null,null,null,null,null,null,null,215800692,null,null,null,null,null,null,null,null,null,null,null,null,null,215800692]
["1410000",null,null,null,null,null,"長期貸付金",null,null,null,null,null,null,null,null,79405500,null,null,null,null,null,null,null,null,null,null,null,null,null,79405500]
["1420000",null,null,null,null,null,"基金",null,null,null,null,null,null,null,null,1359186383,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(AD55:AD56,\"-\")=COUNTA(AD55:AD56),\"-\",SUM(AD55:AD56))","v":1359186383}]
["1430000",null,null,null,null,null,null,"減債基金",null,null,null,null,null,null,null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
["1440000",null,null,null,null,null,null,"その他",null,null,null,null,null,null,null,1359186383,null,null,null,null,null,null,null,null,null,null,null,null,null,1359186383]
["1450000",null,null,null,null,null,"その他",null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
["1460000",null,null,null,null,null,"徴収不能引当金",null,null,null,null,null,null,null,null,-36102295,null,null,null,null,null,null,null,null,null,null,null,null,null,-36102295]
["1470000",null,null,null,"流動資産",null,null,null,null,null,null,null,null,null,null,2942731680,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(AD60:AD68,\"-\")=COUNTA(AD60:AD68),\"-\",SUM(AD60:AD63,AD66:AD68))","v":2942731680}]
["1480000",null,null,null,null,"現金預金",null,null,null,null,null,null,null,null,null,1082918998,null,null,null,null,null,null,null,null,null,null,null,null,null,1082918998]
["1490000",null,null,null,null,"未収金",null,null,null,null,null,null,null,null,null,185669888,null,null,null,null,null,null,null,null,null,null,null,null,null,185669888]
[1500000,null,null,null,null,"短期貸付金",null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["1510000",null,null,null,null,"基金",null,null,null,null,null,null,null,null,null,1681607913,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(AD64:AD65,\"-\")=COUNTA(AD64:AD65),\"-\",SUM(AD64:AD65))","v":1681607913}]
["1520000",null,null,null,null,null,"財政調整基金",null,null,null,null,null,null,null,null,1681433568,null,null,null,null,null,null,null,null,null,null,null,null,null,1681433568]
["1530000",null,null,null,null,null,"減債基金",null,null,null,null,null,null,null,null,174345,null,null,null,null,null,null,null,null,null,null,null,null,null,174345]
["1540000",null,null,null,null,"棚卸資産",null,null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
["1550000",null,null,null,null,"その他",null,null,null,null,null,null,null,null,null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
["1560000","1740000",null,null,null,"徴収不能引当金",null,null,null,null,null,null,null,null,null,-7465119,null,"純資産合計",null,null,null,null,null,null,null,32499448072,null,null,null,-7465119,{"$f":"IF(AND(AE31=\"-\",AE32=\"-\",#REF!=\"-\"),\"-\",SUM(AE31,AE32,#REF!))","v":{"$error":"#REF!"}}]
["1010000","1570000",null,"資産合計",null,null,null,null,null,null,null,null,null,null,null,57769142657,null,"負債及び純資産合計",null,null,null,null,null,null,null,57769142657,null,null,null,{"$f":"IF(AND(AD14=\"-\",AD59=\"-\",#REF!=\"-\"),\"-\",SUM(AD14,AD59,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AND(AE29=\"-\",AE68=\"-\"),\"-\",SUM(AE29,AE68))","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,"※ 下位項目との金額差は、単位未満の四捨五入によるものです。"]

{"sheet":"純資産変動計算書","index":1,"n_rows":32,"n_cols":24,"rows_kept":32,"cut":false,"hidden":true,"merged":[[8,2,8,17],[9,2,9,17],[10,2,10,17],[12,2,13,9],[12,10,13,11],[13,12,13,13],[13,14,13,15],[13,16,13,17],[23,10,23,11],[23,16,23,17],[15,12,15,13],[16,12,16,13],[17,12,17,13],[18,12,18,13],[19,12,19,13],[20,10,20,11],[20,16,20,17],[21,10,21,11],[21,16,21,17],[22,10,22,11],[22,16,22,17],[27,16,27,17],[24,10,24,11],[24,16,24,17],[25,14,25,15],[25,16,25,17],[26,14,26,15],[26,16,26,17]]}
[null,null,"*出力条件"]
[null,null,"*会計年度 ： H28"]
[null,null,"*出力帳票選択 ： 財務書類"]
[null,null,"*団体区分 ： 会計別"]
[null,null,"*団体／会計コード ： 001  ／  01   一般会計等  ／  一般会計"]
[null,null,"*出力範囲 ： 年次"]
[null,null,"*出力金額単位 ： 円"]
[]
[null,null,"純資産変動計算書"]
[null,null,"自　平成２８年４月１日　"]
[null,null,"至　平成２９年３月３１日"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（単位：円）"]
[null,null,"科目",null,null,null,null,null,null,null,"合計"]
["科目コード",null,null,null,null,null,null,null,null,null,null,null,"固定資産\n等形成分",null,"余剰分\n（不足分）",null,"他団体出資等分"]
["3010000",null,"前年度末純資産残高",null,null,null,null,null,null,null,34588576328,null,57280128661,null,-22691552333,null,"-",null,null,null,{"$f":"IF(COUNTIF(V15:X15,\"-\")=COUNTA(V15:X15),\"-\",SUM(V15:X15))","v":"-"},"-","-","-"]
["3020000",null,null,"純行政コスト（△）",null,null,null,null,null,null,-23273570027,null,null,null,-23273570027,null,"-",null,null,null,"-","-","-","-"]
["3030000",null,null,"財源",null,null,null,null,null,null,21133229672,null,null,null,21133229672,null,{"$f":"IF(COUNTIF(Q18:Q19,\"-\")=COUNTA(Q18:Q19),\"-\",SUM(Q18:Q19))","v":"-"},null,null,null,"-","-",{"$f":"IF(COUNTIF(W18:W19,\"-\")=COUNTA(W18:W19),\"-\",SUM(W18:W19))","v":"-"},"-"]
["3040000",null,null,null,"税収等",null,null,null,null,null,15280332856,null,null,null,15280332856,null,"-",null,null,null,"-","-","-","-"]
["3050000",null,null,null,"国県等補助金",null,null,null,null,null,5852896816,null,null,null,5852896816,null,"-",null,null,null,"-","-","-","-"]
["3060000",null,null,"本年度差額",null,null,null,null,null,null,-2140340355,null,null,null,-2140340355,null,{"$f":"IF(COUNTIF(Q16:Q17,\"-\")=COUNTA(Q16:Q17),\"-\",SUM(Q16:Q17))","v":"-"},null,null,null,"-","-",{"$f":"IF(COUNTIF(W16:W17,\"-\")=COUNTA(W16:W17),\"-\",SUM(W16:W17))","v":"-"},"-"]
["3070000",null,null,"固定資産等の変動（内部変動）",null,null,null,null,null,null,null,null,-823321870,null,823321870,null,null,null,null,null,"-",{"$f":"IF(COUNTA(V22:V25)=COUNTIF(V22:V25,\"-\"),\"-\",SUM(V22,V24,V23,V25))","v":"-"},{"$f":"IF(COUNTA(W22:W25)=COUNTIF(W22:W25,\"-\"),\"-\",SUM(W22,W24,W23,W25))","v":"-"},"-"]
["3080000",null,null,null,"有形固定資産等の増加",null,null,null,null,null,null,null,434455917,null,-434455917,null,null,null,null,null,"-","-","-","-"]
["3090000",null,null,null,"有形固定資産等の減少",null,null,null,null,null,null,null,-919015836,null,919015836,null,null,null,null,null,"-","-","-","-"]
["3100000",null,null,null,"貸付金・基金等の増加",null,null,null,null,null,null,null,628824081,null,-628824081,null,null,null,null,null,"-","-","-","-"]
["3110000",null,null,null,"貸付金・基金等の減少",null,null,null,null,null,null,null,-967586032,null,967586032,null,null,null,null,null,"-","-","-","-"]
["3120000",null,null,"資産評価差額",null,null,null,null,null,null,"-",null,"-",null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(V26:X26,\"-\")=COUNTA(V26:X26),\"-\",SUM(V26:X26))","v":"-"},"-","-","-"]
["3130000",null,null,"無償所管換等",null,null,null,null,null,null,51212099,null,51212099,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(V27:X27,\"-\")=COUNTA(V27:X27),\"-\",SUM(V27:X27))","v":"-"},"-","-","-"]
["3140000",null,null,"その他",null,null,null,null,null,null,"-",null,"-",null,"-",null,null,null,null,null,{"$f":"IF(COUNTIF(V28:X28,\"-\")=COUNTA(V28:X28),\"-\",SUM(V28:X28))","v":"-"},"-","-","-"]
["3150000",null,null,"本年度純資産変動額",null,null,null,null,null,null,-2089128256,null,-772109771,null,-1317018485,null,{"$f":"IF(AND(Q20=\"-\",COUNTIF(#REF!,\"-\")=COUNTA(#REF!)),\"-\",SUM(Q20,#REF!))","v":{"$error":"#REF!"}},null,null,null,{"$f":"IF(COUNTIF(V29:X29,\"-\")=COUNTA(V29:X29),\"-\",SUM(V29:X29))","v":"-"},{"$f":"IF(AND(V21=\"-\",COUNTIF(V26:V27,\"-\")=COUNTA(V26:V27),V28=\"-\"),\"-\",SUM(V21,V26:V27,V28))","v":"-"},{"$f":"IF(AND(W20=\"-\",W21=\"-\",COUNTIF(W26:W27,\"-\")=COUNTA(W26:W27),W28=\"-\"),\"-\",SUM(W20,W21,W26:W27,W28))","v":"-"},"-"]
["3160000",null,"本年度末純資産残高",null,null,null,null,null,null,null,32499448072,null,56508018890,null,-24008570818,null,{"$f":"IF(AND(Q15=\"-\",Q29=\"-\"),\"-\",SUM(Q15,Q29))","v":{"$error":"#REF!"}},null,null,null,{"$f":"IF(COUNTIF(V30:X30,\"-\")=COUNTA(V30:X30),\"-\",SUM(V30:X30))","v":"-"},"-","-","-"]
[]
[null,null,null,"※ 下位項目との金額差は、単位未満の四捨五入によるものです。"]

{"sheet":"行政コスト計算書","index":2,"n_rows":50,"n_cols":15,"rows_kept":50,"cut":false,"hidden":true,"merged":[[8,2,8,14],[9,2,9,14],[10,2,10,14],[12,2,12,12],[12,13,12,14]]}
[null,null,"*出力条件"]
[null,null,"*会計年度 ： H28"]
[null,null,"*出力帳票選択 ： 財務書類"]
[null,null,"*団体区分 ： 会計別"]
[null,null,"*団体／会計コード ： 001  ／  01   一般会計等  ／  一般会計"]
[null,null,"*出力範囲 ： 年次"]
[null,null,"*出力金額単位 ： 円"]
[]
[null,null,"行政コスト計算書"]
[null,null,"自　平成２８年４月１日　"]
[null,null,"至　平成２９年３月３１日"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（単位：円）"]
["科目コード",null,"科目",null,null,null,null,null,null,null,null,null,null,"金額"]
["2020000",null,null,"経常費用",null,null,null,null,null,null,null,null,null,24039892514]
["2030000",null,null,null,"業務費用",null,null,null,null,null,null,null,null,11882284082]
["2040000",null,null,null,null,"人件費",null,null,null,null,null,null,null,6607407140]
["2050000",null,null,null,null,null,"職員給与費",null,null,null,null,null,null,3010742406]
["2060000",null,null,null,null,null,"賞与等引当金繰入額",null,null,null,null,null,null,258699272]
["2070000",null,null,null,null,null,"退職手当引当金繰入額",null,null,null,null,null,null,2880764179]
["2080000",null,null,null,null,null,"その他",null,null,null,null,null,null,457201283]
["2090000",null,null,null,null,"物件費等",null,null,null,null,null,null,null,4912850183]
["2100000",null,null,null,null,null,"物件費",null,null,null,null,null,null,3809393420]
["2110000",null,null,null,null,null,"維持補修費",null,null,null,null,null,null,185550927]
["2120000",null,null,null,null,null,"減価償却費",null,null,null,null,null,null,917905836]
["2130000",null,null,null,null,null,"その他",null,null,null,null,null,null,"-"]
["2140000",null,null,null,null,"その他の業務費用",null,null,null,null,null,null,null,362026759]
["2150000",null,null,null,null,null,"支払利息",null,null,null,null,null,null,208749338]
["2160000",null,null,null,null,null,"徴収不能引当金繰入額",null,null,null,null,null,null,7465119]
["2170000",null,null,null,null,null,"その他",null,null,null,null,null,null,145812302]
["2180000",null,null,null,"移転費用",null,null,null,null,null,null,null,null,12157608432]
["2190000",null,null,null,null,"補助金等",null,null,null,null,null,null,null,3575542360]
["2200000",null,null,null,null,"社会保障給付",null,null,null,null,null,null,null,5287415504]
["2210000",null,null,null,null,"他会計への繰出金",null,null,null,null,null,null,null,3260879668]
["2220000",null,null,null,null,"その他",null,null,null,null,null,null,null,33770900]
["2230000",null,null,"経常収益",null,null,null,null,null,null,null,null,null,766199487]
["2240000",null,null,null,"使用料及び手数料",null,null,null,null,null,null,null,null,383924516]
["2250000",null,null,null,"その他",null,null,null,null,null,null,null,null,382274971]
["2010000",null,"純経常行政コスト",null,null,null,null,null,null,null,null,null,null,-23273693027]
["2270000",null,null,"臨時損失",null,null,null,null,null,null,null,null,null,-123000]
["2280000",null,null,null,"災害復旧事業費",null,null,null,null,null,null,null,null,"-"]
["2290000",null,null,null,"資産除売却損",null,null,null,null,null,null,null,null,0]
["2300000",null,null,null,"投資損失引当金繰入額",null,null,null,null,null,null,null,null,"-"]
["2310000",null,null,null,"損失補償等引当金繰入額",null,null,null,null,null,null,null,null,-238000]
["2320000",null,null,null,"その他",null,null,null,null,null,null,null,null,115000]
["2330000",null,null,"臨時利益",null,null,null,null,null,null,null,null,null,"-"]
["2340000",null,null,null,"資産売却益",null,null,null,null,null,null,null,null,"-"]
["2350000",null,null,null,"その他",null,null,null,null,null,null,null,null,"-"]
["2260000",null,"純行政コスト",null,null,null,null,null,null,null,null,null,null,-23273570027]
[]
[null,null,null,"※ 下位項目との金額差は、単位未満の四捨五入によるものです。"]

{"sheet":"資金収支計算書","index":3,"n_rows":69,"n_cols":17,"rows_kept":69,"cut":false,"hidden":true,"merged":[[59,2,59,11],[60,2,60,11],[61,2,61,11],[8,2,8,13],[9,2,9,13],[10,2,10,13],[12,2,13,11],[12,12,13,13],[58,2,58,11]]}
[null,null,"*出力条件"]
[null,null,"*会計年度 ： H28"]
[null,null,"*出力帳票選択 ： 財務書類"]
[null,null,"*団体区分 ： 会計別"]
[null,null,"*団体／会計コード ： 001  ／  01   一般会計等  ／  一般会計"]
[null,null,"*出力範囲 ： 年次"]
[null,null,"*出力金額単位 ： 円"]
[]
[null,null,"資金収支計算書"]
[null,null,"自　平成２８年４月１日　"]
[null,null,"至　平成２９年３月３１日"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"（単位：円）"]
[null,null,"科目",null,null,null,null,null,null,null,null,null,"金額"]
["科目コード"]
[null,null,"【業務活動収支】"]
["4020000",null,null,"業務支出",null,null,null,null,null,null,null,null,20645943222]
["4030000",null,null,null,"業務費用支出",null,null,null,null,null,null,null,8488334790]
["4040000",null,null,null,null,"人件費支出",null,null,null,null,null,null,4138828803]
["4050000",null,null,null,null,"物件費等支出",null,null,null,null,null,null,3994944347]
["4060000",null,null,null,null,"支払利息支出",null,null,null,null,null,null,208749338]
["4070000",null,null,null,null,"その他の支出",null,null,null,null,null,null,145812302]
["4080000",null,null,null,"移転費用支出",null,null,null,null,null,null,null,12157608432]
["4090000",null,null,null,null,"補助金等支出",null,null,null,null,null,null,3575542360]
["4100000",null,null,null,null,"社会保障給付支出",null,null,null,null,null,null,5287415504]
["4110000",null,null,null,null,"他会計への繰出支出",null,null,null,null,null,null,3260879668]
["4120000",null,null,null,null,"その他の支出",null,null,null,null,null,null,33770900]
["4130000",null,null,"業務収入",null,null,null,null,null,null,null,null,21716991392]
["4140000",null,null,null,"税収等収入",null,null,null,null,null,null,null,15406993718]
["4150000",null,null,null,"国県等補助金収入",null,null,null,null,null,null,null,5662331816]
["4160000",null,null,null,"使用料及び手数料収入",null,null,null,null,null,null,null,385545966]
["4170000",null,null,null,"その他の収入",null,null,null,null,null,null,null,262119892]
["4180000",null,null,"臨時支出",null,null,null,null,null,null,null,null,"-"]
["4190000",null,null,null,"災害復旧事業費支出",null,null,null,null,null,null,null,"-"]
["4200000",null,null,null,"その他の支出",null,null,null,null,null,null,null,"-"]
["4210000",null,null,"臨時収入",null,null,null,null,null,null,null,null,"-"]
["4010000",null,"業務活動収支",null,null,null,null,null,null,null,null,null,1071048170]
[null,null,"【投資活動収支】"]
["4230000",null,null,"投資活動支出",null,null,null,null,null,null,null,null,1432827871]
["4240000",null,null,null,"公共施設等整備費支出",null,null,null,null,null,null,null,434773917]
["4250000",null,null,null,"基金積立金支出",null,null,null,null,null,null,null,342949741]
["4260000",null,null,null,"投資及び出資金支出",null,null,null,null,null,null,null,"-"]
["4270000",null,null,null,"貸付金支出",null,null,null,null,null,null,null,655104213]
["4280000",null,null,null,"その他の支出",null,null,null,null,null,null,null,"-"]
["4290000",null,null,"投資活動収入",null,null,null,null,null,null,null,null,1523652713]
["4300000",null,null,null,"国県等補助金収入",null,null,null,null,null,null,null,190565000]
["4310000",null,null,null,"基金取崩収入",null,null,null,null,null,null,null,140000000]
["4320000",null,null,null,"貸付金元金回収収入",null,null,null,null,null,null,null,1191659713]
["4330000",null,null,null,"資産売却収入",null,null,null,null,null,null,null,1428000]
["4340000",null,null,null,"その他の収入",null,null,null,null,null,null,null,"-"]
["4220000",null,"投資活動収支",null,null,null,null,null,null,null,null,null,90824842]
[null,null,"【財務活動収支】"]
["4360000",null,null,"財務活動支出",null,null,null,null,null,null,null,null,2121476028]
["4370000",null,null,null,"地方債償還支出",null,null,null,null,null,null,null,2121476028]
["4380000",null,null,null,"その他の支出",null,null,null,null,null,null,null,"-"]
["4390000",null,null,"財務活動収入",null,null,null,null,null,null,null,null,1515923000]
["4400000",null,null,null,"地方債発行収入",null,null,null,null,null,null,null,1515923000]
["4410000",null,null,null,"その他の収入",null,null,null,null,null,null,null,"-"]
["4350000",null,"財務活動収支",null,null,null,null,null,null,null,null,null,-605553028]
["4420000",null,"本年度資金収支額",null,null,null,null,null,null,null,null,null,556319984]
["4430000",null,"前年度末資金残高",null,null,null,null,null,null,null,null,null,418526689]
[4435000,null,"比例連結割合変更に伴う差額",null,null,null,null,null,null,null,null,null,"-",null,null,null,"-"]
["4440000",null,"本年度末資金残高",null,null,null,null,null,null,null,null,null,974846673]
[]
["4450000",null,"前年度末歳計外現金残高",null,null,null,null,null,null,null,null,null,153019060]
["4460000",null,"本年度歳計外現金増減額",null,null,null,null,null,null,null,null,null,-44946735]
["4470000",null,"本年度末歳計外現金残高",null,null,null,null,null,null,null,null,null,108072325]
["4480000",null,"本年度末現金預金残高",null,null,null,null,null,null,null,null,null,1082918998]
[]
[null,null,null,"※ 下位項目との金額差は、単位未満の四捨五入によるものです。"]

{"sheet":"有形固定資産の明細","index":4,"n_rows":24,"n_cols":16,"rows_kept":24,"cut":false,"hidden":false,"merged":[[5,12,5,13],[5,14,5,15],[6,0,6,1],[6,2,6,3],[6,4,6,5],[6,6,6,7],[6,8,6,9],[6,10,6,11],[6,12,6,13],[6,14,6,15],[5,0,5,1],[5,2,5,3],[5,4,5,5],[5,6,5,7],[5,8,5,9],[5,10,5,11],[7,12,7,13],[7,14,7,15],[8,0,8,1],[8,2,8,3],[8,4,8,5],[8,6,8,7],[8,8,8,9],[8,10,8,11],[8,12,8,13],[8,14,8,15],[7,0,7,1],[7,2,7,3],[7,4,7,5],[7,6,7,7],[7,8,7,9],[7,10,7,11],[9,12,9,13],[9,14,9,15],[10,0,10,1],[10,2,10,3],[10,4,10,5],[10,6,10,7],[10,8,10,9],[10,10,10,11],[10,12,10,13],[10,14,10,15],[9,0,9,1],[9,2,9,3],[9,4,9,5],[9,6,9,7],[9,8,9,9],[9,10,9,11],[11,12,11,13],[11,14,11,15],[12,0,12,1],[12,2,12,3],[12,4,12,5],[12,6,12,7],[12,8,12,9],[12,10,12,11],[12,12,12,13],[12,14,12,15],[11,0,11,1],[11,2,11,3],[11,4,11,5],[11,6,11,7],[11,8,11,9],[11,10,11,11],[13,12,13,13],[13,14,13,15],[14,0,14,1],[14,2,14,3],[14,4,14,5],[14,6,14,7],[14,8,14,9],[14,10,14,11],[14,12,14,13],[14,14,14,15],[13,0,13,1],[13,2,13,3],[13,4,13,5],[13,6,13,7],[13,8,13,9],[13,10,13,11],[15,12,15,13],[15,14,15,15],[16,0,16,1],[16,2,16,3],[16,4,16,5],[16,6,16,7],[16,8,16,9],[16,10,16,11],[16,12,16,13],[16,14,16,15],[15,0,15,1],[15,2,15,3],[15,4,15,5],[15,6,15,7],[15,8,15,9],[15,10,15,11],[17,12,17,13],[17,14,17,15],[18,0,18,1],[18,2,18,3],[18,4,18,5],[18,6,18,7],[18,8,18,9],[18,10,18,11],[18,12,18,13],[18,14,18,15],[17,0,17,1],[17,2,17,3],[17,4,17,5],[17,6,17,7],[17,8,17,9],[17,10,17,11],[19,12,19,13],[19,14,19,15],[20,0,20,1],[20,2,20,3],[20,4,20,5],[20,6,20,7],[20,8,20,9],[20,10,20,11],[20,12,20,13],[20,14,20,15],[19,0,19,1],[19,2,19,3],[19,4,19,5],[19,6,19,7],[19,8,19,9],[19,10,19,11],[23,12,23,13],[23,14,23,15],[23,0,23,1],[23,2,23,3],[23,4,23,5],[23,6,23,7],[23,8,23,9],[23,10,23,11],[21,12,21,13],[21,14,21,15],[22,0,22,1],[22,2,22,3],[22,4,22,5],[22,6,22,7],[22,8,22,9],[22,10,22,11],[22,12,22,13],[22,14,22,15],[21,0,21,1],[21,2,21,3],[21,4,21,5],[21,6,21,7],[21,8,21,9],[21,10,21,11]]}
[]
["附属明細書"]
["1.貸借対照表の内容に関する明細"]
["(1)資産項目の明細"]
["①有形固定資産の明細",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（単位：円）"]
["区分",null,"\n前年度末残高\n（A）",null,"\n本年度増加額\n（B）",null,"\n本年度減少額\n（C）",null,"本年度末残高\n（A)＋（B)-（C)\n（D）",null,"本年度末\n減価償却累計額\n（E)",null,"\n本年度償却額\n（F)",null,"差引本年度末残高\n（D)－（E)\n（G)"]
[" 事業用資産",null,58849374826,null,421783651,null,0,null,59271158477,null,20914094228,null,678833577,null,38357064249]
["　  土地",null,25456276950,null,78150870,null,0,null,25534427820,null,0,null,0,null,25534427820]
["　　立木竹",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-"]
["　　建物",null,32322235798,null,239792401,null,0,null,32562028199,null,19992555207,null,666713031,null,12569472992]
["　　工作物",null,1070862078,null,72520380,null,0,null,1143382458,null,921539021,null,12120546,null,221843437]
["　　船舶",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-"]
["　　浮標等",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-"]
["　　航空機",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-"]
["　　その他",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-"]
["　　建設仮勘定",null,0,null,31320000,null,0,null,31320000,null,0,null,0,null,31320000]
[" インフラ資産",null,18559849978,null,64765158,null,1110000,null,18623505136,null,5621314621,null,119548970,null,13002190515]
["　　土地",null,10750970749,null,13656507,null,1110000,null,10763517256,null,0,null,0,null,10763517256]
["　　建物",null,268813234,null,0,null,0,null,268813234,null,167155314,null,7013434,null,101657920]
["　　工作物",null,7540065995,null,51108651,null,0,null,7591174646,null,5454159307,null,112535536,null,2137015339]
["　　その他",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-"]
["　　建設仮勘定",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-"]
[" 物品",null,328219565,null,4690000,null,7550000,null,325359565,null,283760789,null,31719098,null,41598776]
["合計",null,77737444369,null,491238809,null,8660000,null,78220023178,null,26819169638,null,830101645,null,51400853540]

{"sheet":"有形固定資産の行政目的別明細","index":5,"n_rows":27,"n_cols":20,"rows_kept":27,"cut":false,"hidden":false,"merged":[[7,12,8,13],[7,14,8,15],[7,16,8,17],[7,18,8,19],[9,0,9,1],[9,2,9,3],[9,4,9,5],[9,6,9,7],[9,8,9,9],[9,10,9,11],[7,0,8,1],[7,2,8,3],[7,4,8,5],[7,6,8,7],[7,8,8,9],[7,10,8,11],[9,12,9,13],[9,14,9,15],[9,16,9,17],[9,18,9,19],[10,0,10,1],[10,2,10,3],[10,4,10,5],[10,6,10,7],[10,8,10,9],[10,10,10,11],[10,12,10,13],[10,14,10,15],[10,16,10,17],[10,18,10,19],[11,0,11,1],[11,2,11,3],[11,4,11,5],[11,6,11,7],[11,8,11,9],[11,10,11,11],[11,12,11,13],[11,14,11,15],[11,16,11,17],[11,18,11,19],[12,0,12,1],[12,2,12,3],[12,4,12,5],[12,6,12,7],[12,8,12,9],[12,10,12,11],[12,12,12,13],[12,14,12,15],[12,16,12,17],[12,18,12,19],[13,0,13,1],[13,2,13,3],[13,4,13,5],[13,6,13,7],[13,8,13,9],[13,10,13,11],[13,12,13,13],[13,14,13,15],[13,16,13,17],[13,18,13,19],[14,0,14,1],[14,2,14,3],[14,4,14,5],[14,6,14,7],[14,8,14,9],[14,10,14,11],[14,12,14,13],[14,14,14,15],[14,16,14,17],[14,18,14,19],[15,0,15,1],[15,2,15,3],[15,4,15,5],[15,6,15,7],[15,8,15,9],[15,10,15,11],[15,12,15,13],[15,14,15,15],[15,16,15,17],[15,18,15,19],[16,0,16,1],[16,2,16,3],[16,4,16,5],[16,6,16,7],[16,8,16,9],[16,10,16,11],[16,12,16,13],[16,14,16,15],[16,16,16,17],[16,18,16,19],[17,0,17,1],[17,2,17,3],[17,4,17,5],[17,6,17,7],[17,8,17,9],[17,10,17,11],[17,12,17,13],[17,14,17,15],[17,16,17,17],[17,18,17,19],[18,0,18,1],[18,2,18,3],[18,4,18,5],[18,6,18,7],[18,8,18,9],[18,10,18,11],[18,12,18,13],[18,14,18,15],[18,16,18,17],[18,18,18,19],[19,0,19,1],[19,2,19,3],[19,4,19,5],[19,6,19,7],[19,8,19,9],[19,10,19,11],[19,12,19,13],[19,14,19,15],[19,16,19,17],[19,18,19,19],[20,0,20,1],[20,2,20,3],[20,4,20,5],[20,6,20,7],[20,8,20,9],[20,10,20,11],[20,12,20,13],[20,14,20,15],[20,16,20,17],[20,18,20,19],[21,0,21,1],[21,2,21,3],[21,4,21,5],[21,6,21,7],[21,8,21,9],[21,10,21,11],[21,12,21,13],[21,14,21,15],[21,16,21,17],[21,18,21,19],[22,0,22,1],[22,2,22,3],[22,4,22,5],[22,6,22,7],[22,8,22,9],[22,10,22,11],[22,12,22,13],[22,14,22,15],[22,16,22,17],[22,18,22,19],[23,0,23,1],[23,2,23,3],[23,4,23,5],[23,6,23,7],[23,8,23,9],[23,10,23,11],[23,12,23,13],[23,14,23,15],[23,16,23,17],[23,18,23,19],[24,0,24,1],[24,2,24,3],[24,4,24,5],[24,6,24,7],[24,8,24,9],[24,10,24,11],[24,12,24,13],[24,14,24,15],[24,16,24,17],[24,18,24,19],[25,0,25,1],[25,2,25,3],[25,4,25,5],[25,6,25,7],[25,8,25,9],[25,10,25,11],[26,12,26,13],[26,14,26,15],[26,16,26,17],[26,18,26,19],[25,12,25,13],[25,14,25,15],[25,16,25,17],[25,18,25,19],[26,0,26,1],[26,2,26,3],[26,4,26,5],[26,6,26,7],[26,8,26,9],[26,10,26,11]]}
[]
[]
[]
[]
[]
[]
["②有形固定資産の行政目的別明細",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（単位：円）"]
["区分",null,"生活インフラ・\n国土保全",null,"教育",null,"福祉",null,"環境衛生",null,"産業振興",null,"消防",null,"総務",null,"未設定",null,"合計"]
[]
[" 事業用資産",null,108783834,null,25006297676,null,1924356487,null,627506225,null,299174585,null,161787613,null,10229157829,null,"-",null,38357064249]
["　　土地",null,108747902,null,17164267092,null,876664130,null,625190740,null,112817456,null,41352379,null,6605388121,null,"-",null,25534427820]
["　　立木竹",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-"]
["　　建物",null,35932,null,7747871401,null,1047692354,null,2315485,null,186357126,null,"-",null,3585200694,null,"-",null,12569472992]
["　　工作物",null,"-",null,94159183,null,3,null,"-",null,3,null,120435234,null,7249014,null,"-",null,221843437]
["　　船舶",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-"]
["　　浮標等",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-"]
["　　航空機",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-"]
["　　その他",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-"]
["　　建設仮勘定",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-",null,31320000,null,"-",null,31320000]
[" インフラ資産",null,13002190515,null,"-",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-",null,13002190515]
["　　土地",null,10763517256,null,"-",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-",null,10763517256]
["　　建物",null,101657920,null,"-",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-",null,101657920]
["　　工作物",null,2137015339,null,"-",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-",null,2137015339]
["　　その他",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-"]
["　　建設仮勘定",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-",null,"-"]
[" 物品",null,699078,null,8862211,null,440110,null,"-",null,"-",null,4436014,null,27161363,null,"-",null,41598776]
["合計",null,13111673427,null,25015159887,null,1924796597,null,627506225,null,299174585,null,166223627,null,10256319192,null,"-",null,51400853540]

{"sheet":"投資及び出資金","index":6,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,"③投資及び出資金の明細"]
[null,"市場価格のあるもの",null,null,null,null,null,null,"（単位：円）"]
[null,"銘柄名","\n株数・口数など\n（A）","\n時価単価\n（B）","貸借対照表計上額\n（A）×（B)\n（C)","\n取得単価\n（D)","取得原価\n（A）×（D)\n（E)","評価差額\n（C）－（E)\n（F)","（参考）財産に関する\n調書記載額"]
[]
[null,null,null,null,{"$f":"IFERROR(C5*D5,\"\")","v":0},null,{"$f":"IFERROR(C5*F5,\"\")","v":0},{"$f":"IFERROR(E5-G5,\"\")","v":0}]
[null,null,null,null,null,null,null,0]
[null,"合計",{"$f":"IFERROR(SUM(C4:C6),\"\")","v":0},{"$f":"IFERROR(SUM(D4:D6),\"\")","v":0},{"$f":"IFERROR(SUM(E4:E6),\"\")","v":0},{"$f":"IFERROR(SUM(F4:F6),\"\")","v":0},{"$f":"IFERROR(SUM(G4:G6),\"\")","v":0},{"$f":"IFERROR(SUM(H5:H5),\"\")","v":0},{"$f":"IFERROR(SUM(I4:I6),\"\")","v":0}]
[]
[]
[null,"市場価格のないもののうち連結対象団体（会計）に対するもの",null,null,null,null,null,null,null,null,"（単位：円）"]
[null,"相手先名","出資金額\n（貸借対照表計上額）\n（A)","\n資産\n（B)","\n負債\n（C)","純資産額\n（B）－（C)\n（D)","\n資本金\n（E)","出資割合（％）\n（A）/（E)\n（F)","実質価額\n（D)×（F)\n（G)","投資損失引当金\n計上額\n（H)","（参考）財産に関する\n調書記載額"]
[]
[null,"柏原市水道事業会計",174086000,11639046088,5660530657,{"$f":"IFERROR(D13-E13,\"\")","v":5978515431},1083076115,{"$f":"IFERROR(C13/G13,\"\")","v":0.16073293242183631},{"$f":"IFERROR(F13*H13,\"\")","v":960944316.75382864},null,"記載なし"]
[null,"市立柏原病院事業会計",1506655000,6888520535,7621360049,{"$f":"IFERROR(D14-E14,\"\")","v":-732839514},667261008,{"$f":"IFERROR(C14/G14,\"\")","v":2.2579694931012662},{"$f":"IFERROR(F14*H14,\"\")","v":-1654729265.9511583},null,"記載なし"]
[null,"柏原市土地開発公社",5000000,888472674,814545305,73927369,5000000,{"$f":"IFERROR(C15/G15,\"\")","v":1},{"$f":"IFERROR(F15*H15,\"\")","v":73927369},null,5000000]
[null,"柏原市健康推進財団",3000000,null,null,{"$f":"IFERROR(D16-E16,\"\")","v":0},null,{"$f":"IFERROR(C16/G16,\"\")","v":""},{"$f":"IFERROR(F16*H16,\"\")","v":""},3000000,3000000]
[]
[null,"合計",{"$f":"IFERROR(SUM(C12:C17),\"\")","v":1688741000},{"$f":"IFERROR(SUM(D12:D17),\"\")","v":19416039297},{"$f":"IFERROR(SUM(E12:E17),\"\")","v":14096436011},{"$f":"IFERROR(SUM(F13:F16),\"\")","v":5319603286},{"$f":"IFERROR(SUM(G12:G17),\"\")","v":1755337123},"-",{"$f":"IFERROR(SUM(I12:I17),\"\")","v":-619857580.19732964},{"$f":"IFERROR(SUM(J12:J17),\"\")","v":3000000},{"$f":"IFERROR(SUM(K12:K17),\"\")","v":8000000}]
[]
[]
[null,"市場価格のないもののうち連結対象団体（会計）以外に対するもの",null,null,null,null,null,null,null,null,null,"（単位：円）"]
[null,"相手先名","\n出資金額\n（A)","\n資産\n（B)","\n負債\n（C)","純資産額\n（B）－（C)\n（D)","\n資本金\n（E)","出資割合（％）\n（A）/（E)\n（F)","実質価額\n（D)×（F)\n（G)","\n強制評価減\n（H)","貸借対照表計上額\n（Ａ）－（Ｈ）\n（Ｉ）","（参考）財産に関する\n調書記載額"]
[]
[null,"大阪湾広域臨海環境整備センター",200000,43629675544,29451202055,{"$f":"IFERROR(D24-E24,\"\")","v":14178473489},136900000,{"$f":"IFERROR(C24/G24,\"\")","v":1.4609203798392988E-3},{"$f":"IFERROR(F24*H24,\"\")","v":20713620.875091307},null,{"$f":"IFERROR(C24-J24,\"\")","v":200000},200000]
[null,"(財)大阪府地域福祉推進財団",480000,1707334225,96001807,{"$f":"IFERROR(D25-E25,\"\")","v":1611332418},422000000,{"$f":"IFERROR(C25/G25,\"\")","v":1.1374407582938389E-3},{"$f":"IFERROR(F25*H25,\"\")","v":1832795.1673933649},null,{"$f":"IFERROR(C25-J25,\"\")","v":480000},480000]
[null,"(財)砂防フロンティア整備推進機構",300000,3805931333,1258425596,{"$f":"IFERROR(D26-E26,\"\")","v":2547505737},400000000,{"$f":"IFERROR(C26/G26,\"\")","v":7.5000000000000002E-4},{"$f":"IFERROR(F26*H26,\"\")","v":1910629.30275},null,{"$f":"IFERROR(C26-J26,\"\")","v":300000},300000]
[null,"（財）大阪みどりのトラスト協会",100000,431910659,76379230,{"$f":"IFERROR(D27-E27,\"\")","v":355531429},100000000,{"$f":"IFERROR(C27/G27,\"\")","v":1E-3},{"$f":"IFERROR(F27*H27,\"\")","v":355531.429},null,{"$f":"IFERROR(C27-J27,\"\")","v":100000},100000]
[null,"(財)大阪府暴力追放推進センター",1400000,2625910943,9125931,{"$f":"IFERROR(D28-E28,\"\")","v":2616785012},1900000000,{"$f":"IFERROR(C28/G28,\"\")","v":7.3684210526315792E-4},{"$f":"IFERROR(F28*H28,\"\")","v":1928157.3772631579},null,{"$f":"IFERROR(C28-J28,\"\")","v":1400000},1400000]
[null,"森林さきもり基金",1800000,2005904471,1284564444,{"$f":"IFERROR(D29-E29,\"\")","v":721340027},201086000,{"$f":"IFERROR(C29/G29,\"\")","v":8.951393930954914E-3},{"$f":"IFERROR(F29*H29,\"\")","v":6456998.7398426542},null,{"$f":"IFERROR(C29-J29,\"\")","v":1800000},1800000]
[null,"(財)大阪人権歴史資料館",56000,2037301928,4552487,{"$f":"IFERROR(D30-E30,\"\")","v":2032749441},10000000,{"$f":"IFERROR(C30/G30,\"\")","v":5.5999999999999999E-3},{"$f":"IFERROR(F30*H30,\"\")","v":11383396.8696},null,{"$f":"IFERROR(C30-J30,\"\")","v":56000},56000]
[null,"(財)アジア・太平洋人権情報センター",814000,621791113,10861079,{"$f":"IFERROR(D31-E31,\"\")","v":610930034},509963826,{"$f":"IFERROR(C31/G31,\"\")","v":1.5961916483072272E-3},{"$f":"IFERROR(F31*H31,\"\")","v":975161.41797085037},null,{"$f":"IFERROR(C31-J31,\"\")","v":814000},814000]
[null,"地方公共団体金融機構",5100000,24786267000000,24545185000000,{"$f":"IFERROR(D32-E32,\"\")","v":241082000000},1660200000,{"$f":"IFERROR(C32/G32,\"\")","v":3.0719190458980846E-3},{"$f":"IFERROR(F32*H32,\"\")","v":740584387.42320204},null,{"$f":"IFERROR(C32-J32,\"\")","v":5100000},5100000]
[null,null,null,null,null,{"$f":"IFERROR(D33-E33,\"\")","v":0},null,{"$f":"IFERROR(C33/G33,\"\")","v":""},{"$f":"IFERROR(F33*H33,\"\")","v":""},null,{"$f":"IFERROR(C33-J33,\"\")","v":0}]
[null,"合計",{"$f":"IFERROR(SUM(C23:C33),\"\")","v":10250000},{"$f":"IFERROR(SUM(D23:D33),\"\")","v":24843132760216},{"$f":"IFERROR(SUM(E23:E33),\"\")","v":24577376112629},{"$f":"IFERROR(SUM(F24:F31),\"\")","v":24674647587},{"$f":"IFERROR(SUM(G23:G33),\"\")","v":5340149826},"-",{"$f":"IFERROR(SUM(I24:I31),\"\")","v":45556291.178911336},{"$f":"IFERROR(SUM(J23:J33),\"\")","v":0},{"$f":"IFERROR(SUM(K24:K32),\"\")","v":10250000},{"$f":"IFERROR(SUM(L23:L33),\"\")","v":10250000}]

{"sheet":"基金","index":7,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,7,2,7],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6]]}
[null,"④基金の明細",null,null,null,null,null,"（単位：円）"]
[null,"種類","現金預金","有価証券","土地","その他","合計\n(貸借対照表計上額)","(参考)財産に関する\n調書記載額"]
[]
[]
[null,"減債基金",174345,null,null,null,{"$f":"SUM(C5:F5)","v":174345},174345]
[null,"財政調整基金",1681433568,null,null,null,1681433568,1681433568]
[null,"公共施設等整備基金",24148065,null,null,null,24148065,24148065]
[null,"公園等整備基金",273853559,null,null,null,273853559,273853559]
[null,"文化振興基金",8950000,null,null,null,8950000,8950000]
[null,"ふるさと創生事業基金",65046965,null,null,null,65046965,65046965]
[null,"心身障害者福祉基金",15350000,null,null,null,15350000,15350000]
[null,"心身障害児福祉基金",5400000,null,null,null,5400000,5400000]
[null,"老人福祉基金",319530000,null,null,null,319530000,319530000]
[null,"奨学基金",54000204,null,null,null,54000204,53384780]
[null,"校外教授奨励基金",1000000,null,null,null,1000000,1000000]
[null,"スポーツ振興基金",39100000,null,null,null,39100000,39100000]
[null,"文化・スポーツ国際交流基金",228656659,null,null,null,228656659,228656659]
[null,"ふるさと基金",294150931,null,null,null,294150931,428160931]
[null,"更生資金貸付基金",20000000,null,null,null,20000000,20000000]
[null,"高額療養費貸付基金",10000000,null,null,null,10000000,10000000]
[]
[null,"合計",{"$f":"IFERROR(SUM(C4:C21),\"\")","v":3040794296},{"$f":"IFERROR(SUM(D4:D21),\"\")","v":0},0,0,3040794296,3174188872]

{"sheet":"貸付金","index":8,"n_rows":40,"n_cols":7,"rows_kept":40,"cut":false,"hidden":false,"merged":[[15,1,15,6],[21,1,21,6],[27,1,27,6],[33,1,33,6],[1,1,2,1],[1,2,1,3],[1,4,1,5],[1,6,2,6],[3,1,3,6],[9,1,9,6]]}
[null,"⑤貸付金の明細",null,null,null,null,"（単位：円）"]
[null,"相手先名または種別","長期貸付金",null,"短期貸付金",null,"（参考）\n貸付金計"]
[null,null,"貸借対照表計上額","徴収不能引当金\n計上額","貸借対照表計上額","徴収不能引当金\n計上額"]
[null,"地方公営事業"]
[]
[]
[]
[]
[]
[null,"一部事務組合・広域連合"]
[]
[]
[]
[]
[]
[null,"地方独立行政法人"]
[]
[]
[]
[]
[]
[null,"地方三公社"]
[]
[]
[]
[]
[]
[null,"第三セクター等"]
[]
[null,"柏原市健康推進財団",50000000,null,null,null,50000000]
[]
[]
[]
[null,"その他の貸付金"]
[]
[null,"奨学金貸付金",29405500,null,null,null,29405500]
[]
[]
[]
[null,"合計",{"$f":"IFERROR(SUM(C5:C39),\"\")","v":79405500},{"$f":"IFERROR(SUM(D5:D39),\"\")","v":0},{"$f":"IFERROR(SUM(E5:E39),\"\")","v":0},{"$f":"IFERROR(SUM(F5:F39),\"\")","v":0},{"$f":"IFERROR(SUM(G5:G39),\"\")","v":79405500}]

{"sheet":"長期延滞債権","index":9,"n_rows":33,"n_cols":4,"rows_kept":33,"cut":false,"hidden":false,"merged":[[4,1,4,3],[2,1,2,3],[13,1,13,3],[15,1,15,3],[22,1,22,3],[8,1,8,3]]}
[null,"⑥長期延滞債権の明細",null,"（単位：円）"]
[null,"相手先名または種別","貸借対照表計上額","徴収不能引当金計上額"]
[null,"【貸付金】"]
[]
[null,"第三セクター等"]
[]
[null,"柏原市健康推進財団貸付金元利収入",1000000,1000000]
[]
[null,"その他の貸付金"]
[]
[]
[]
[null,"小計",{"$f":"IFERROR(SUM(C6:C12),\"\")","v":1000000},{"$f":"IFERROR(SUM(D6:D12),\"\")","v":1000000}]
[null,"【未収金】"]
[]
[null,"税等未収金"]
[]
[null,"市民税",69995167,5459623]
[null,"固定資産税",81225031,5117177]
[null,"軽自動車税",1099067,145077]
[null,"都市計画税",16911191,1166872]
[]
[null,"その他の未収金"]
[]
[null,"私立保育所保育料",14100340,225605]
[null,"放課後児童会負担金",1306550]
[null,"放課後児童会延長保育負担金",5475]
[null,"公立保育所保育料",7330871,175941]
[null,"公立幼稚園保育料",15000]
[null,"サンヒル柏原土地建物貸付収入",22812000,22812000]
[]
[null,"小計",{"$f":"IFERROR(SUM(C15:C31),\"\")","v":214800692},{"$f":"IFERROR(SUM(D15:D31),\"\")","v":35102295}]
[null,"合計",{"$f":"IFERROR(SUM(C13,C32),\"\")","v":215800692},{"$f":"IFERROR(SUM(D13,D32),\"\")","v":36102295}]

{"sheet":"未収金","index":10,"n_rows":33,"n_cols":4,"rows_kept":33,"cut":false,"hidden":false,"merged":[[22,1,22,3],[2,1,2,3],[4,1,4,3],[8,1,8,3],[13,1,13,3],[15,1,15,3]]}
[null,"⑦未収金の明細",null,"（単位：円）"]
[null,"相手先名または種別","貸借対照表計上額","徴収不能引当金計上額"]
[null,"【貸付金】"]
[]
[null,"第三セクター等"]
[]
[]
[]
[null,"その他の貸付金"]
[]
[]
[]
[null,"小計",{"$f":"IFERROR(SUM(C6:C12),\"\")","v":0},{"$f":"IFERROR(SUM(D6:D12),\"\")","v":0}]
[null,"【未収金】"]
[]
[null,"税等未収金"]
[]
[null,"市民税",47235927,3684402]
[null,"固定資産税",43765894,2757251]
[null,"軽自動車税",2392000,315744]
[null,"都市計画税",8742084,603204]
[]
[null,"その他の未収金"]
[]
[null,"私立保育所保育料",4421480,70744]
[null,"放課後児童会負担金",1265350]
[null,"放課後児童会延長保育負担金",48675]
[null,"公立保育所保育料",1407250,33774]
[null,"公立幼稚園保育料",22050]
[null,"雑入",76369178]
[]
[null,"小計",{"$f":"IFERROR(SUM(C17:C31),\"\")","v":185669888},{"$f":"IFERROR(SUM(D17:D31),\"\")","v":7465119}]
[null,"合計",{"$f":"IFERROR(SUM(C13,C32),\"\")","v":185669888},{"$f":"IFERROR(SUM(D13,D32),\"\")","v":7465119}]

{"sheet":"地方債（借入先別）","index":11,"n_rows":18,"n_cols":12,"rows_kept":18,"cut":false,"hidden":false,"merged":[[12,1,12,11],[3,8,4,8],[3,11,4,11],[3,1,4,1],[3,2,4,2],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,7,4,7],[5,1,5,11]]}
[]
[null,"（２）負債項目の明細"]
[null,"①地方債（借入先別）の明細",null,null,null,null,null,null,null,null,null,"（単位：円）"]
[null,"種類","地方債残高",null,"政府資金","地方公共団体\n金融機構","市中銀行","その他の\n金融機関","市場公募債",null,null,"その他"]
[null,null,null,"うち1年内償還予定",null,null,null,null,null,"うち共同発行債","うち住民公募債"]
[null,"【通常分】"]
[null,"　　一般公共事業",572574944,null,430151283,17000000,92234448,3275000,null,null,null,29914213]
[null,"　　公営住宅建設"]
[null,"　　災害復旧",1227437,null,1227437]
[null,"　　教育・福祉施設",1384181298,null,1059144156,60889117,26622454,110614768,null,null,null,126910803]
[null,"　　一般単独事業",2088416081,null,379546806,315869669,334217384,578873000,null,null,null,479909222]
[null,"　　その他",1029709776,null,269841083,550047131,null,null,null,null,null,209821562]
[null,"【特別分】"]
[null,"　　臨時財政対策債",12689468074,null,6831636490,4555802584,542636000,759393000]
[null,"　　減税補てん債",426267651,null,426267651]
[null,"　　退職手当債",740986758,null,null,null,134250758,606736000]
[null,"　　その他",504560675,null,null,null,463354956,34679232,null,null,null,6526487]
[null,"合計",{"$f":"IFERROR(SUM(C7:C12)+SUM(C14:C17),\"\")","v":19437392694},{"$f":"IFERROR(SUM(D7:D12)+SUM(D14:D17),\"\")","v":0},{"$f":"IFERROR(SUM(E7:E12)+SUM(E14:E17),\"\")","v":9397814906},{"$f":"IFERROR(SUM(F7:F12)+SUM(F14:F17),\"\")","v":5499608501},1593316000,2093571000,0,{"$f":"IFERROR(SUM(J7:J12)+SUM(J14:J17),\"\")","v":0},{"$f":"IFERROR(SUM(K7:K12)+SUM(K14:K17),\"\")","v":0},{"$f":"IFERROR(SUM(L7:L12)+SUM(L14:L17),\"\")","v":853082287}]

{"sheet":"地方債（利率別など）","index":12,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[9,11,10,11],[15,2,16,2],[15,3,16,8],[9,7,10,7],[17,3,17,8],[9,8,10,8],[9,9,10,9],[9,10,10,10],[9,2,10,2],[9,3,10,3],[9,4,10,4],[9,5,10,5],[9,6,10,6],[3,7,4,7],[3,8,4,8],[3,9,4,9],[3,10,4,10],[3,11,4,11],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6]]}
[]
[]
[null,null,"②地方債（利率別）の明細",null,null,null,null,null,null,null,"（単位：円）"]
[null,null,"地方債残高","1.5％以下","1.5％超\n2.0％以下","2.0％超\n2.5％以下","2.5％超\n3.0％以下","3.0％超\n3.5％以下","3.5％超\n4.0％以下","4.0％超","（参考）\n加重平均\n利率"]
[]
[null,null,{"$f":"IFERROR(SUM(D6:J6),\"\")","v":19437392694},14137418425,4156352274,1094857078,1279316,35171146,4302442,8012013,1.1100000000000001]
[]
[]
[null,null,"③地方債（返済期間別）の明細",null,null,null,null,null,null,null,null,"（単位：円）"]
[null,null,"地方債残高","１年以内","１年超\n２年以内","２年超\n３年以内","３年超\n４年以内","４年超\n５年以内","５年超\n10年以内","10年超\n15年以内","15年超\n20年以内","20年超"]
[]
[null,null,{"$f":"IFERROR(SUM(D12:L12),\"\")","v":19437392694},null,114341000,487012847,136421607,182158604,5417500166,5846420616,6481937854,771600000]
[]
[]
[null,null,"④特定の契約条項が付された地方債の概要",null,null,null,null,null,"（単位：円）"]
[null,null,"特定の契約条項が\n付された地方債残高","契約条項の概要"]

{"sheet":"引当金","index":13,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[5,1,5,6],[8,1,8,6],[10,1,10,6],[13,1,13,6],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,3,5],[3,6,4,6]]}
[]
[]
[null,"⑤引当金の明細",null,null,null,null,"（単位：円）"]
[null,"区分","前年度末残高","本年度増加額","本年度減少額",null,"本年度末残高"]
[null,null,null,null,"目的使用","その他"]
[null,"固定資産"]
[null,"投資損失引当金",3000000,null,null,null,{"$f":"IFERROR(C7+D7-E7-F7,\"\")","v":3000000}]
[null,"徴収不能引当金",65923534,32821586,62642825,null,{"$f":"IFERROR(C8+D8-E8-F8,\"\")","v":36102295}]
[null,"流動資産"]
[null,"徴収不能引当金",32821586,7465119,null,32821586,{"$f":"IFERROR(C10+D10-E10-F10,\"\")","v":7465119}]
[null,"固定負債"]
[null,"退職手当引当金",3045330000,2880764179,409045825,null,{"$f":"IFERROR(C12+D12-E12-F12,\"\")","v":5517048354}]
[null,"損失補償等引当金",101739000,null,238000,null,{"$f":"IFERROR(C13+D13-E13-F13,\"\")","v":101501000}]
[null,"流動負債"]
[null,"賞与等引当金",261839289,258699272,261839289,null,{"$f":"IFERROR(C15+D15-E15-F15,\"\")","v":258699272}]
[null,"合計",{"$f":"IFERROR(SUM(C6:C15),\"\")","v":3510653409},{"$f":"IFERROR(SUM(D6:D15),\"\")","v":3179750156},733765939,32821586,5923816040]

{"sheet":"補助金","index":14,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,4,2,5],[2,6,2,7],[2,8,2,9],[1,8,1,9],[17,1,17,2],[17,4,17,5],[17,6,17,7],[17,8,17,9],[9,4,9,5],[9,6,9,7],[9,8,9,9],[16,4,16,5],[16,6,16,7],[16,8,16,9],[14,4,14,5],[14,6,14,7],[14,8,14,9],[10,8,10,9],[9,1,16,2],[4,6,4,7],[4,8,4,9],[7,4,7,5],[7,6,7,7],[7,8,7,9],[4,1,7,2],[13,4,13,5],[13,6,13,7],[13,8,13,9],[12,4,12,5],[12,6,12,7],[12,8,12,9],[11,4,11,5],[11,6,11,7],[11,8,11,9],[10,4,10,5],[10,6,10,7],[5,4,5,5],[5,6,5,7],[5,8,5,9],[4,4,4,5]]}
[null,"２．行政コスト計算書の内容に関する明細"]
[null,"（１）補助金等の明細",null,null,null,null,null,null,"（単位：円）"]
[null,"区分",null,"名称","相手先",null,"金額",null,"支出目的"]
["合計行開始"]
[null,"他団体への公共施設等整備補助金等\r\n(所有外資産分）",null,"集会所修繕等補助金","地区町会等",null,3173000,null,"集会所の修繕等に対する補助"]
[null,null,null,"民間保育所等整備費補助金","民間保育所等",null,81445000,null,"民間保育所等の施設整備に対する補助"]
["合計行終了"]
[null,null,null,"計",null,null,{"$f":"IFERROR(SUM(G4:G7),\"\")","v":84618000}]
["合計行開始"]
[null,"その他の補助金等",null,"柏羽藤環境事業組合負担金","柏羽藤環境事業組合",null,712976000,null,"一部事務組合に対する負担"]
[null,null,null,"柏羽藤消防組合負担金","柏羽藤消防組合",null,782329000,null,"一部事務組合に対する負担"]
[null,null,null,"藤柏学校給食組合負担金","藤柏学校給食組合",null,323029000,null,"一部事務組合に対する負担"]
[null,null,null,"後期高齢者医療広域連合療養給付費負担金","大阪府後期高齢者医療広域連合",null,634092599,null,"広域連合に対する負担"]
[null,null,null,"年金生活者等支援臨時福祉給付金","対象者",null,216150000,null,"年金生活者等に対する臨時福祉給付金"]
[null,null,null,"その他",null,null,822347761]
["合計行終了"]
[null,null,null,"計",null,null,{"$f":"IFERROR(SUM(G9:G16),\"\")","v":3490924360}]
[null,"合計",null,null,null,null,{"$f":"IFERROR(SUM(G8,G17),\"\")","v":3575542360}]

{"sheet":"財源明細","index":15,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[[3,3,3,4],[0,1,0,5],[4,1,28,1],[4,2,16,2],[4,3,4,4],[5,3,5,4],[11,3,11,4],[15,3,15,4],[16,3,16,4],[17,3,21,3],[18,2,27,2],[22,3,26,3],[27,3,27,4],[28,2,28,4],[10,3,10,4],[6,3,6,4],[9,3,9,4],[8,3,8,4],[7,3,7,4],[14,3,14,4],[13,3,13,4],[12,3,12,4]]}
[null,"３．純資産変動計算書の内容に関する明細"]
[null,"（１）財源の明細",null,null,null,"（単位：円）"]
[null,"会計","区分","財源の内容",null,"金額"]
["合計行開始"]
[null,null,"税収等","市税",null,8754888743]
[null,null,null,"地方譲与税",null,123278000]
[null,null,null,"利子割交付金",null,47176000]
[null,null,null,"株式等譲渡所得割交付金",null,27797000]
[null,null,null,"自動車取得税交付金",null,49127000]
[null,null,null,"地方特例交付金",null,39963000]
[null,null,null,"地方交付税",null,4489919000]
[null,null,null,"交通安全対策特別交付金",null,12424000]
[null,null,null,"分担金及び負担金",null,247448703]
[null,null,null,"寄附金",null,126200000]
[null,null,null,"その他",null,1362111410]
["合計行終了"]
[null,null,null,"小計",null,{"$f":"SUM(F4:F16)","v":15280332856}]
["合計行開始",null,null,"資本的\n補助金"]
[null,null,"国県等補助金",null,"国庫支出金",190565000]
[]
["合計行終了"]
[null,null,null,null,"計",{"$f":"SUM(F18:F21)","v":190565000}]
["合計行開始",null,null,"経常的\n補助金"]
[null,null,null,null,"国庫支出金",4051720956]
[null,null,null,null,"府支出金",1610610860]
["合計行終了"]
[null,null,null,null,"計",{"$f":"SUM(F23:F26)","v":5662331816}]
[null,null,null,"小計",null,{"$f":"SUM(F22,F27)","v":5852896816}]
[null,null,"合計",null,null,{"$f":"SUM(F17,F28)","v":21133229672}]

{"sheet":"財源情報明細","index":16,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[13,1,13,6],[3,1,3,3],[3,4,3,6],[4,1,5,1],[4,2,5,2],[4,3,4,6]]}
[]
[]
[]
[null,"（２）財源情報の明細",null,null,"（単位：円）"]
[null,"区分","金額","内訳"]
[null,null,null,"国県等補助金","地方債","税収等","その他"]
[null,"純行政コスト",{"$f":"IFERROR(SUM(D7:G7),\"\")","v":23273570027},5662331816,1290923000,12568786079,3751529132]
[null,"有形固定資産等の増加",{"$f":"IFERROR(SUM(D8:G8),\"\")","v":434455917},190565000,225000000,16900891,1990026]
[null,"貸付金・基金等の増加",628824081,null,null,573169858,55654223]
[null,"その他",0]
[null,"合計",24336850025,{"$f":"IFERROR(SUM(D7:D10),\"\")","v":5852896816},{"$f":"IFERROR(SUM(E7:E10),\"\")","v":1515923000},13158856828,3809173381]

{"sheet":"資金明細","index":17,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[12,1,12,2]]}
[null,"４．資金収支計算書の内容に関する明細"]
[null,"（１）資金の明細","（単位：円）"]
[null,"種類","本年度末残高"]
["合計行開始"]
[null,"要求払預金",974846673]
[]
[]
[]
["合計行終了"]
[null,"合計",{"$f":"IFERROR(SUM(C4:C9),\"\")","v":974846673}]

{"sheet":"財源会計テンプレート","index":18,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":true,"merged":[[1,3,1,4],[2,1,20,1],[2,2,6,2],[6,3,6,4],[8,2,19,2],[19,3,19,4],[20,2,20,4],[7,3,12,3],[13,3,18,3],[2,3,2,4],[3,3,3,4],[4,3,4,4],[5,3,5,4]]}
[]
["合計行開始"]
[null,null,"税収等"]
[]
[]
["合計行終了"]
[null,null,null,"小計",null,{"$f":"SUM(F2:F6)","v":0}]
["合計行開始",null,null,"資本的\n補助金"]
[null,null,"国県等補助金"]
[]
[]
["合計行終了"]
[null,null,null,null,"計",{"$f":"SUM(F8:F12)","v":0}]
["合計行開始",null,null,"経常的\n補助金"]
[]
[]
[]
["合計行終了"]
[null,null,null,null,"計",{"$f":"SUM(F14:F18)","v":0}]
[null,null,null,"小計",null,{"$f":"SUM(F13,F19)","v":0}]
[null,null,"合計",null,null,{"$f":"SUM(F7,F20)","v":0}]