{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["貸借対照表","純資産変動計算書","行政コスト計算書","資金収支計算書","有形固定資産","投資及び出資金","基金","貸付金","長期延滞債権","未収金","地方債（借入先別）","地方債（利率別など）","引当金","補助金","財源明細","財源情報明細","資金明細","財源会計テンプレート"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":4772,"comments":12,"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,194782485004,null,null,"固定負債",null,null,null,null,null,null,50139995439,null,null,null,{"$f":"IF(AND(AD15=\"-\",AD43=\"-\",AD46=\"-\"),\"-\",SUM(AD15,AD43,AD46))","v":194782485004},{"$f":"IF(COUNTIF(AE15:AE19,\"-\")=COUNTA(AE15:AE19),\"-\",SUM(AE15:AE19))","v":50139995439}]
["1030000","1600000",null,null,null,"有形固定資産",null,null,null,null,null,null,null,null,null,182766046166,null,null,null,"地方債",null,null,null,null,null,46452552259,null,null,null,{"$f":"IF(AND(AD16=\"-\",AD32=\"-\",COUNTIF(AD41:AD42,\"-\")=COUNTA(AD41:AD42)),\"-\",SUM(AD16,AD32,AD41:AD42))","v":182766046166},46452552259]
["1040000","1610000",null,null,null,null,"事業用資産",null,null,null,null,null,null,null,null,92562732726,null,null,null,"長期未払金",null,null,null,null,null,337567000,null,null,null,{"$f":"IF(COUNTIF(AD17:AD31,\"-\")=COUNTA(AD17:AD31),\"-\",SUM(AD17:AD31))","v":92562732726},337567000]
["1050000","1620000",null,null,null,null,null,"土地",null,null,null,null,null,null,null,40065322121,null,null,null,"退職手当引当金",null,null,null,null,null,3081725000,null,null,null,40065322121,3081725000]
["1060000","1630000",null,null,null,null,null,"立木竹",null,null,null,null,null,null,null,"-",null,null,null,"損失補償等引当金",null,null,null,null,null,133000000,null,null,null,"-",133000000]
["1070000","1640000",null,null,null,null,null,"建物",null,null,null,null,null,null,null,131551984055,null,null,null,"その他",null,null,null,null,null,135151180,null,null,null,131551984055,135151180]
["1080000","1650000",null,null,null,null,null,"建物減価償却累計額",null,null,null,null,null,null,null,-83462315416,null,null,"流動負債",null,null,null,null,null,null,5847815290,null,null,null,-83462315416,{"$f":"IF(COUNTIF(AE21:AE28,\"-\")=COUNTA(AE21:AE28),\"-\",SUM(AE21:AE28))","v":5847815290}]
["1090000","1660000",null,null,null,null,null,"工作物",null,null,null,null,null,null,null,6626192385,null,null,null,"1年内償還予定地方債",null,null,null,null,null,4934483317,null,null,null,6626192385,4934483317]
["1100000","1670000",null,null,null,null,null,"工作物減価償却累計額",null,null,null,null,null,null,null,-4016824822,null,null,null,"未払金",null,null,null,null,null,93162710,null,null,null,-4016824822,93162710]
["1110000","1680000",null,null,null,null,null,"船舶",null,null,null,null,null,null,null,3851638,null,null,null,"未払費用",null,null,null,null,null,"-",null,null,null,3851638,"-"]
["1120000","1690000",null,null,null,null,null,"船舶減価償却累計額",null,null,null,null,null,null,null,-3077927,null,null,null,"前受金",null,null,null,null,null,"-",null,null,null,-3077927,"-"]
["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,291645000,null,null,null,"-",291645000]
["1150000","1720000",null,null,null,null,null,"航空機",null,null,null,null,null,null,null,"-",null,null,null,"預り金",null,null,null,null,null,528524263,null,null,null,"-",528524263]
["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,30380400,null,"負債合計",null,null,null,null,null,null,null,55987810729,null,null,null,30380400,{"$f":"IF(AND(AE14=\"-\",AE20=\"-\"),\"-\",SUM(AE14,AE20))","v":55987810729}]
["1180000",null,null,null,null,null,null,"その他減価償却累計額",null,null,null,null,null,null,null,-1792443,null,"【純資産の部】",null,null,null,null,null,null,null,null,null,null,null,-1792443]
["1190000","1750000",null,null,null,null,null,"建設仮勘定",null,null,null,null,null,null,null,1769012735,null,null,"固定資産等形成分",null,null,null,null,null,null,195081993442,null,null,null,1769012735,193335572111]
["1200000","1760000",null,null,null,null,"インフラ資産",null,null,null,null,null,null,null,null,88706121277,null,null,"余剰分（不足分）",null,null,null,null,null,null,-54082864853,null,null,null,{"$f":"IF(COUNTIF(AD33:AD40,\"-\")=COUNTA(AD33:AD40),\"-\",SUM(AD33:AD40))","v":88706121277},-52336443522]
["1210000",null,null,null,null,null,null,"土地",null,null,null,null,null,null,null,26473843906,null,null,null,null,null,null,null,null,null,null,null,null,null,26473843906]
["1220000",null,null,null,null,null,null,"建物",null,null,null,null,null,null,null,1353522464,null,null,null,null,null,null,null,null,null,null,null,null,null,1353522464]
["1230000",null,null,null,null,null,null,"建物減価償却累計額",null,null,null,null,null,null,null,-872960260,null,null,null,null,null,null,null,null,null,null,null,null,null,-872960260]
["1240000",null,null,null,null,null,null,"工作物",null,null,null,null,null,null,null,139318591684,null,null,null,null,null,null,null,null,null,null,null,null,null,139318591684]
["1250000",null,null,null,null,null,null,"工作物減価償却累計額",null,null,null,null,null,null,null,-77586614986,null,null,null,null,null,null,null,null,null,null,null,null,null,-77586614986]
["1260000",null,null,null,null,null,null,"その他",null,null,null,null,null,null,null,484794503,null,null,null,null,null,null,null,null,null,null,null,null,null,484794503]
["1270000",null,null,null,null,null,null,"その他減価償却累計額",null,null,null,null,null,null,null,-484659834,null,null,null,null,null,null,null,null,null,null,null,null,null,-484659834]
["1280000",null,null,null,null,null,null,"建設仮勘定",null,null,null,null,null,null,null,19603800,null,null,null,null,null,null,null,null,null,null,null,null,null,19603800]
["1290000",null,null,null,null,null,"物品",null,null,null,null,null,null,null,null,4395086387,null,null,null,null,null,null,null,null,null,null,null,null,null,4395086387]
["1300000",null,null,null,null,null,"物品減価償却累計額",null,null,null,null,null,null,null,null,-2897894224,null,null,null,null,null,null,null,null,null,null,null,null,null,-2897894224]
["1310000",null,null,null,null,"無形固定資産",null,null,null,null,null,null,null,null,null,32129522,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":32129522}]
["1320000",null,null,null,null,null,"ソフトウェア",null,null,null,null,null,null,null,null,3176928,null,null,null,null,null,null,null,null,null,null,null,null,null,3176928]
["1330000",null,null,null,null,null,"その他",null,null,null,null,null,null,null,null,28952594,null,null,null,null,null,null,null,null,null,null,null,null,null,28952594]
["1340000",null,null,null,null,"投資その他の資産",null,null,null,null,null,null,null,null,null,11984309316,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":11984309316}]
["1350000",null,null,null,null,null,"投資及び出資金",null,null,null,null,null,null,null,null,14401789083,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":14401789083}]
["1360000",null,null,null,null,null,null,"有価証券",null,null,null,null,null,null,null,380355795,null,null,null,null,null,null,null,null,null,null,null,null,null,380355795]
["1370000",null,null,null,null,null,null,"出資金",null,null,null,null,null,null,null,520693288,null,null,null,null,null,null,null,null,null,null,null,null,null,520693288]
["1380000",null,null,null,null,null,null,"その他",null,null,null,null,null,null,null,13500740000,null,null,null,null,null,null,null,null,null,null,null,null,null,13500740000]
["1390000",null,null,null,null,null,"投資損失引当金",null,null,null,null,null,null,null,null,-13296105510,null,null,null,null,null,null,null,null,null,null,null,null,null,-13296105510]
["1400000",null,null,null,null,null,"長期延滞債権",null,null,null,null,null,null,null,null,482249145,null,null,null,null,null,null,null,null,null,null,null,null,null,482249145]
["1410000",null,null,null,null,null,"長期貸付金",null,null,null,null,null,null,null,null,462045108,null,null,null,null,null,null,null,null,null,null,null,null,null,462045108]
["1420000",null,null,null,null,null,"基金",null,null,null,null,null,null,null,null,9923081814,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":9923081814}]
["1430000",null,null,null,null,null,null,"減債基金",null,null,null,null,null,null,null,3259873975,null,null,null,null,null,null,null,null,null,null,null,null,null,3259873975]
["1440000",null,null,null,null,null,null,"その他",null,null,null,null,null,null,null,6663207839,null,null,null,null,null,null,null,null,null,null,null,null,null,6663207839]
["1450000",null,null,null,null,null,"その他",null,null,null,null,null,null,null,null,100008266,null,null,null,null,null,null,null,null,null,null,null,null,null,100008266]
["1460000",null,null,null,null,null,"徴収不能引当金",null,null,null,null,null,null,null,null,-88758590,null,null,null,null,null,null,null,null,null,null,null,null,null,-88758590]
["1470000",null,null,null,"流動資産",null,null,null,null,null,null,null,null,null,null,2204454314,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":2204454314}]
["1480000",null,null,null,null,"現金預金",null,null,null,null,null,null,null,null,null,1142182998,null,null,null,null,null,null,null,null,null,null,null,null,null,1142182998]
["1490000",null,null,null,null,"未収金",null,null,null,null,null,null,null,null,null,197641859,null,null,null,null,null,null,null,null,null,null,null,null,null,197641859]
[1500000,null,null,null,null,"短期貸付金",null,null,null,null,null,null,null,null,null,49898148,null,null,null,null,null,null,null,null,null,null,null,null,null,49898148]
["1510000",null,null,null,null,"基金",null,null,null,null,null,null,null,null,null,249610290,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":249610290}]
["1520000",null,null,null,null,null,"財政調整基金",null,null,null,null,null,null,null,null,238656056,null,null,null,null,null,null,null,null,null,null,null,null,null,238656056]
["1530000",null,null,null,null,null,"減債基金",null,null,null,null,null,null,null,null,10954234,null,null,null,null,null,null,null,null,null,null,null,null,null,10954234]
["1540000",null,null,null,null,"棚卸資産",null,null,null,null,null,null,null,null,null,263110516,null,null,null,null,null,null,null,null,null,null,null,null,null,263110516]
["1550000",null,null,null,null,"その他",null,null,null,null,null,null,null,null,null,306502370,null,null,null,null,null,null,null,null,null,null,null,null,null,306502370]
["1560000","1740000",null,null,null,"徴収不能引当金",null,null,null,null,null,null,null,null,null,-4491867,null,"純資産合計",null,null,null,null,null,null,null,140999128589,null,null,null,-4491867,{"$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,196986939318,null,"負債及び純資産合計",null,null,null,null,null,null,null,196986939318,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,142857373391,null,198104206054,null,-55246832663,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,-36939548326,null,null,null,-36939548326,null,"-",null,null,null,"-","-","-","-"]
["3030000",null,null,"財源",null,null,null,null,null,null,35183438928,null,null,null,35183438928,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,23877762815,null,null,null,23877762815,null,"-",null,null,null,"-","-","-","-"]
["3050000",null,null,null,"国県等補助金",null,null,null,null,null,11305676113,null,null,null,11305676113,null,"-",null,null,null,"-","-","-","-"]
["3060000",null,null,"本年度差額",null,null,null,null,null,null,-1756109398,null,null,null,-1756109398,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,-4666498539,null,4666498539,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,3464205360,null,-3464205360,null,null,null,null,null,"-","-","-","-"]
["3090000",null,null,null,"有形固定資産等の減少",null,null,null,null,null,null,null,-8041470818,null,8041470818,null,null,null,null,null,"-","-","-","-"]
["3100000",null,null,null,"貸付金・基金等の増加",null,null,null,null,null,null,null,2701948527,null,-2701948527,null,null,null,null,null,"-","-","-","-"]
["3110000",null,null,null,"貸付金・基金等の減少",null,null,null,null,null,null,null,-2791181608,null,2791181608,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,-102135404,null,-102135404,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,-1858244802,null,-4768633943,null,2910389141,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,140999128589,null,193335572111,null,-52336443522,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,38366914822]
["2030000",null,null,null,"業務費用",null,null,null,null,null,null,null,null,17923182226]
["2040000",null,null,null,null,"人件費",null,null,null,null,null,null,null,5426092554]
["2050000",null,null,null,null,null,"職員給与費",null,null,null,null,null,null,3838115042]
["2060000",null,null,null,null,null,"賞与等引当金繰入額",null,null,null,null,null,null,291645000]
["2070000",null,null,null,null,null,"退職手当引当金繰入額",null,null,null,null,null,null,298817073]
["2080000",null,null,null,null,null,"その他",null,null,null,null,null,null,997515439]
["2090000",null,null,null,null,"物件費等",null,null,null,null,null,null,null,12076350479]
["2100000",null,null,null,null,null,"物件費",null,null,null,null,null,null,5669385718]
["2110000",null,null,null,null,null,"維持補修費",null,null,null,null,null,null,687935962]
["2120000",null,null,null,null,null,"減価償却費",null,null,null,null,null,null,5715597638]
["2130000",null,null,null,null,null,"その他",null,null,null,null,null,null,3431161]
["2140000",null,null,null,null,"その他の業務費用",null,null,null,null,null,null,null,420739193]
["2150000",null,null,null,null,null,"支払利息",null,null,null,null,null,null,238121401]
["2160000",null,null,null,null,null,"徴収不能引当金繰入額",null,null,null,null,null,null,25685960]
["2170000",null,null,null,null,null,"その他",null,null,null,null,null,null,156931832]
["2180000",null,null,null,"移転費用",null,null,null,null,null,null,null,null,20443732596]
["2190000",null,null,null,null,"補助金等",null,null,null,null,null,null,null,7348558370]
["2200000",null,null,null,null,"社会保障給付",null,null,null,null,null,null,null,10658781819]
["2210000",null,null,null,null,"他会計への繰出金",null,null,null,null,null,null,null,2343773218]
["2220000",null,null,null,null,"その他",null,null,null,null,null,null,null,92619189]
["2230000",null,null,"経常収益",null,null,null,null,null,null,null,null,null,2536445103]
["2240000",null,null,null,"使用料及び手数料",null,null,null,null,null,null,null,null,1454731365]
["2250000",null,null,null,"その他",null,null,null,null,null,null,null,null,1081713738]
["2010000",null,"純経常行政コスト",null,null,null,null,null,null,null,null,null,null,-35830469719]
["2270000",null,null,"臨時損失",null,null,null,null,null,null,null,null,null,1869740356]
["2280000",null,null,null,"災害復旧事業費",null,null,null,null,null,null,null,null,140964253]
["2290000",null,null,null,"資産除売却損",null,null,null,null,null,null,null,null,1087693641]
["2300000",null,null,null,"投資損失引当金繰入額",null,null,null,null,null,null,null,null,640460000]
["2310000",null,null,null,"損失補償等引当金繰入額",null,null,null,null,null,null,null,null,"-"]
["2320000",null,null,null,"その他",null,null,null,null,null,null,null,null,622462]
["2330000",null,null,"臨時利益",null,null,null,null,null,null,null,null,null,760661749]
["2340000",null,null,null,"資産売却益",null,null,null,null,null,null,null,null,6222320]
["2350000",null,null,null,"その他",null,null,null,null,null,null,null,null,754439429]
["2260000",null,"純行政コスト",null,null,null,null,null,null,null,null,null,null,-36939548326]
[]
[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,33079115005]
["4030000",null,null,null,"業務費用支出",null,null,null,null,null,null,null,12635382409]
["4040000",null,null,null,null,"人件費支出",null,null,null,null,null,null,5726484554]
["4050000",null,null,null,null,"物件費等支出",null,null,null,null,null,null,6520525251]
["4060000",null,null,null,null,"支払利息支出",null,null,null,null,null,null,238121401]
["4070000",null,null,null,null,"その他の支出",null,null,null,null,null,null,150251203]
["4080000",null,null,null,"移転費用支出",null,null,null,null,null,null,null,20443732596]
["4090000",null,null,null,null,"補助金等支出",null,null,null,null,null,null,7348558370]
["4100000",null,null,null,null,"社会保障給付支出",null,null,null,null,null,null,10658781819]
["4110000",null,null,null,null,"他会計への繰出支出",null,null,null,null,null,null,2343773218]
["4120000",null,null,null,null,"その他の支出",null,null,null,null,null,null,92619189]
["4130000",null,null,"業務収入",null,null,null,null,null,null,null,null,36432036532]
["4140000",null,null,null,"税収等収入",null,null,null,null,null,null,null,23897008312]
["4150000",null,null,null,"国県等補助金収入",null,null,null,null,null,null,null,10085837272]
["4160000",null,null,null,"使用料及び手数料収入",null,null,null,null,null,null,null,1454842432]
["4170000",null,null,null,"その他の収入",null,null,null,null,null,null,null,994348516]
["4180000",null,null,"臨時支出",null,null,null,null,null,null,null,null,140964253]
["4190000",null,null,null,"災害復旧事業費支出",null,null,null,null,null,null,null,140964253]
["4200000",null,null,null,"その他の支出",null,null,null,null,null,null,null,"-"]
["4210000",null,null,"臨時収入",null,null,null,null,null,null,null,null,17681988]
["4010000",null,"業務活動収支",null,null,null,null,null,null,null,null,null,3229639262]
[null,null,"【投資活動収支】"]
["4230000",null,null,"投資活動支出",null,null,null,null,null,null,null,null,5819490685]
["4240000",null,null,null,"公共施設等整備費支出",null,null,null,null,null,null,null,3237528305]
["4250000",null,null,null,"基金積立金支出",null,null,null,null,null,null,null,702197668]
["4260000",null,null,null,"投資及び出資金支出",null,null,null,null,null,null,null,658369000]
["4270000",null,null,null,"貸付金支出",null,null,null,null,null,null,null,1221395712]
["4280000",null,null,null,"その他の支出",null,null,null,null,null,null,null,"-"]
["4290000",null,null,"投資活動収入",null,null,null,null,null,null,null,null,3338738679]
["4300000",null,null,null,"国県等補助金収入",null,null,null,null,null,null,null,1219838841]
["4310000",null,null,null,"基金取崩収入",null,null,null,null,null,null,null,756852613]
["4320000",null,null,null,"貸付金元金回収収入",null,null,null,null,null,null,null,1272643172]
["4330000",null,null,null,"資産売却収入",null,null,null,null,null,null,null,89404053]
["4340000",null,null,null,"その他の収入",null,null,null,null,null,null,null,"-"]
["4220000",null,"投資活動収支",null,null,null,null,null,null,null,null,null,-2480752006]
[null,null,"【財務活動収支】"]
["4360000",null,null,"財務活動支出",null,null,null,null,null,null,null,null,4814099169]
["4370000",null,null,null,"地方債償還支出",null,null,null,null,null,null,null,4790777169]
["4380000",null,null,null,"その他の支出",null,null,null,null,null,null,null,23322000]
["4390000",null,null,"財務活動収入",null,null,null,null,null,null,null,null,3779518000]
["4400000",null,null,null,"地方債発行収入",null,null,null,null,null,null,null,3779518000]
["4410000",null,null,null,"その他の収入",null,null,null,null,null,null,null,"-"]
["4350000",null,"財務活動収支",null,null,null,null,null,null,null,null,null,-1034581169]
["4420000",null,"本年度資金収支額",null,null,null,null,null,null,null,null,null,-285693913]
["4430000",null,"前年度末資金残高",null,null,null,null,null,null,null,null,null,869352648]
[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,583658735]
[]
["4450000",null,"前年度末歳計外現金残高",null,null,null,null,null,null,null,null,null,581506584]
["4460000",null,"本年度歳計外現金増減額",null,null,null,null,null,null,null,null,null,-22982321]
["4470000",null,"本年度末歳計外現金残高",null,null,null,null,null,null,null,null,null,558524263]
["4480000",null,"本年度末現金預金残高",null,null,null,null,null,null,null,null,null,1142182998]
[]
[null,null,null,"※ 下位項目との金額差は、単位未満の四捨五入によるものです。"]

{"sheet":"有形固定資産","index":4,"n_rows":53,"n_cols":14,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,11],[2,0,2,4],[3,0,3,10],[4,0,4,10],[5,1,5,10],[8,1,8,2],[7,1,7,2],[10,1,10,2],[9,1,9,2],[12,1,12,2],[11,1,11,2],[14,1,14,2],[13,1,13,2],[16,1,16,2],[15,1,15,2],[18,1,18,2],[17,1,17,2],[20,1,20,2],[19,1,19,2],[22,1,22,2],[21,1,21,2],[24,1,24,2],[23,1,23,2],[29,1,30,2],[29,3,30,3],[29,4,30,4],[25,1,25,2],[29,10,30,10],[31,1,31,2],[33,1,33,2],[32,1,32,2],[35,1,35,2],[34,1,34,2],[29,5,30,5],[29,6,30,6],[29,7,30,7],[29,8,30,8],[29,9,30,9],[37,1,37,2],[36,1,36,2],[39,1,39,2],[38,1,38,2],[41,1,41,2],[40,1,40,2],[43,1,43,2],[42,1,42,2],[45,1,45,2],[44,1,44,2],[48,1,48,2],[47,1,47,2],[46,1,46,2]]}
["【様式第５号】"]
["附属明細書"]
["１．貸借対照表の内容に関する明細"]
["　※下記以外の資産及び負債のうち、その額が資産総額の100分の5を超える科目についても作成する。"]
["（１）資産項目の明細"]
[]
[null,"①有形固定資産の明細",null,null,null,null,null,null,null,"（単位：円）"]
[null,"区分",null,"\n前年度末残高\n（A）","\n本年度増加額\n（B）","\n本年度減少額\n（C）","本年度末残高\n（A)＋（B)-（C)\n（D）","本年度末\n減価償却累計額\n（E)","\n本年度償却額\n（F)","差引本年度末残高\n（D)－（E)\n（G)"]
[null," 事業用資産",null,{"$f":"SUM(D10:D18)","v":8401507730},{"$f":"SUM(E10:E18)","v":243434517},{"$f":"SUM(F10:F18)","v":0},{"$f":"D9+E9-F9","v":8644942247},{"$f":"SUM(H10:H18)","v":4008223913},{"$f":"SUM(I10:I18)","v":193759506},{"$f":"G9-H9","v":4636718334}]
[null,"　  土地",null,228823599,0,0,228823599,0,0,228823599]
[null,"　　立木竹",null,0,0,0,0,0,0,0]
[null,"　　建物",null,6560242231,234987174,0,6795229405,3179812323,144486609,3615417082]
[null,"　　工作物",null,1612441900,8447343,0,1620889243,828411590,49272897,792477653]
[null,"　　船舶",null,0,0,0,0,0,0,0]
[null,"　　浮標等",null,0,0,0,0,0,0,0]
[null,"　　航空機",null,0,0,0,0,0,0,0]
[null,"　　その他",null,0,0,0,0,0,0,0]
[null,"　　建設仮勘定",null,0,0,0,0,0,0,0]
[null," インフラ資産",null,{"$f":"SUM(D20:D24)","v":18901727022},{"$f":"SUM(E20:E24)","v":43035688},{"$f":"SUM(F20:F24)","v":6},18944762704,{"$f":"SUM(H20:H24)","v":12712750079},{"$f":"SUM(I20:I24)","v":376566257},6232012625]
[null,"　　土地",null,657879,5127,6,663000,0,0,663000]
[null,"　　建物",null,165316000,0,0,165316000,72654588,4810900,92661412]
[null,"　　工作物",null,18735753143,43030561,0,18778783704,12640095491,371755357,6138688213]
[null,"　　その他",null,0,0,0,0,0,0,0]
[null,"　　建設仮勘定",null,0,0,0,0,0,0,0]
[null," 物品",null,124721983,0,0,124721983,114073134,3633467,10648849]
[null,"合計",null,{"$f":"D9+D19+D25","v":27427956735},286470205,6,27714426934,16835047126,573959230,10879379808,null,null,null,"⇒ＢＳとの一致を確認する。"]
[]
[]
[null,"②有形固定資産の行政目的別明細",null,null,null,null,null,null,null,null,"（単位：円）"]
[null,"区分",null,"生活インフラ・\n国土保全","教育","福祉","環境衛生","産業振興","消防","総務","合計"]
[]
[null," 事業用資産",null,{"$f":"SUM(D33:D41)","v":991903296},1583411206,192315531,580565382,539323294,934381,748265244,{"$f":"SUM(D32:J32)","v":4636718334},null,null,{"$f":"J9-K32","v":0}]
[null,"　　土地",null,78563964,57781917,4597747,4690963,3650916,934381,{"$f":"78500894+102817","v":78603711},228823599,null,null,0]
[null,"　　立木竹",null,0,0,0,0,0,0,0,0,null,null,0]
[null,"　　建物",null,888212318,1308591620,136649842,495577141,437170561,0,{"$f":"348903601+311999","v":349215600},3615417082,null,null,0]
[null,"　　工作物",null,25127014,217037669,51067942,80297278,98501817,0,{"$f":"320445941-8","v":320445933},792477653,null,null,0]
[null,"　　船舶",null,0,0,0,0,0,0,0,0,null,null,0]
[null,"　　浮標等",null,0,0,0,0,0,0,0,0,null,null,0]
[null,"　　航空機",null,0,0,0,0,0,0,0,0,null,null,0]
[null,"　　その他",null,0,0,0,0,0,0,0,0,null,null,0]
[null,"　　建設仮勘定",null,0,0,0,0,0,0,0,0,null,null,0]
[null," インフラ資産",null,{"$f":"SUM(D43:D47)","v":6231864270},0,0,0,77386,0,70969,6232012625,null,null,0]
[null,"　　土地",null,{"$f":"580487-65842","v":514645},0,0,0,77386,0,70969,663000,null,null,0]
[null,"　　建物",null,{"$f":"J21","v":92661412},0,0,0,0,0,0,92661412,null,null,0]
[null,"　　工作物",null,{"$f":"J22","v":6138688213},0,0,0,0,0,0,6138688213,null,null,0]
[null,"　　その他",null,0,0,0,0,0,0,0,0,null,null,0]
[null,"　　建設仮勘定",null,0,0,0,0,0,0,0,0,null,null,0]
[null," 物品",null,6,1466169,369602,1926212,294009,0,{"$f":"5689141+903710","v":6592851},10648849,null,null,0]
[null,"合計",null,{"$f":"D32+D42+D48","v":7223767572},1584877375,192685133,582491594,539694689,934381,754929064,10879379808,null,null,0]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"↑全て0になることを確認する。"]

{"sheet":"投資及び出資金","index":5,"n_rows":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,"貸借対照表\n投資および出資金","判定\n(貸借対照表\n計上額)"]
[null,null,null,null,null,null,null,{"$f":"IF(G3=F11+D19+L33,\"○\",\"×\")","v":"×"}]
[]
[null,null,"③投資及び出資金の明細"]
[null,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(D9*E9,\"\")","v":0},null,{"$f":"IFERROR(D9*G9,\"\")","v":0},{"$f":"IFERROR(F9-H9,\"\")","v":0}]
["合計行終了",null,null,null,null,null,null,null,0]
[null,null,"合計",{"$f":"IFERROR(SUM(D8:D10),\"\")","v":0},{"$f":"IFERROR(SUM(E8:E10),\"\")","v":0},{"$f":"IFERROR(SUM(F8:F10),\"\")","v":0},{"$f":"IFERROR(SUM(G8:G10),\"\")","v":0},{"$f":"IFERROR(SUM(H8:H10),\"\")","v":0},0,{"$f":"IFERROR(SUM(J8:J10),\"\")","v":0}]
[]
[]
[null,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調書記載額"]
["合計行開始"]
[null,null,"該当なし",null,null,null,{"$f":"IFERROR(E17-F17,\"\")","v":0},null,{"$f":"IFERROR(D17/H17,\"\")","v":""},{"$f":"IFERROR(G17*I17,\"\")","v":""}]
["合計行終了"]
[null,null,"合計",{"$f":"IFERROR(SUM(D16:D18),\"\")","v":0},{"$f":"IFERROR(SUM(E16:E18),\"\")","v":0},{"$f":"IFERROR(SUM(F16:F18),\"\")","v":0},{"$f":"IFERROR(E19-F19,\"\")","v":0},{"$f":"IFERROR(SUM(H16:H18),\"\")","v":0},{"$f":"IFERROR(D19/H19,\"\")","v":""},{"$f":"IFERROR(SUM(J16:J18),\"\")","v":0},{"$f":"IFERROR(SUM(K16:K18),\"\")","v":0},{"$f":"IFERROR(SUM(L16:L18),\"\")","v":0}]
[]
[]
[null,null,"市場価格のないもののうち連結対象団体（会計）以外に対するもの",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,null,"北海道曹達　株式会社",200000,8586885000,2532709000,{"$f":"IFERROR(E25-F25,\"\")","v":6054176000},1224519000,{"$f":"IFERROR(D25/H25,\"\")","v":1.6332943792623879E-4},{"$f":"IFERROR(G25*I25,\"\")","v":988825.16318652465},0,{"$f":"IFERROR(D25-K25,\"\")","v":200000},200000]
[null,null,"北海道私学振興基金協会出資金",33000,6207627784,2053228209,{"$f":"IFERROR(E26-F26,\"\")","v":4154399575},621702000,{"$f":"IFERROR(D26/H26,\"\")","v":5.30800930349267E-5},{"$f":"IFERROR(G26*I26,\"\")","v":220515.91594525994},0,{"$f":"IFERROR(D26-K26,\"\")","v":33000},33000]
[null,null,"北海道農業信用基金協会出資金",500000,399080932000,370757475000,{"$f":"IFERROR(E27-F27,\"\")","v":28323457000},28323456000,{"$f":"IFERROR(D27/H27,\"\")","v":1.7653212941245588E-5},{"$f":"IFERROR(G27*I27,\"\")","v":500000.01765321294},0,{"$f":"IFERROR(D27-K27,\"\")","v":500000},500000]
[null,null,"北海道土地改良事業団体連合会出資金",150000,4453606042,1567446940,{"$f":"IFERROR(E28-F28,\"\")","v":2886159102},2886159102,{"$f":"IFERROR(D28/H28,\"\")","v":5.1972186805660028E-5},{"$f":"IFERROR(G28*I28,\"\")","v":150000},0,{"$f":"IFERROR(D28-K28,\"\")","v":150000},150000]
[null,null,"北海道市町村職員福祉協会育英事業出資金",750000,null,null,{"$f":"IFERROR(E29-F29,\"\")","v":0},null,{"$f":"IFERROR(D29/H29,\"\")","v":""},{"$f":"IFERROR(G29*I29,\"\")","v":""},0,{"$f":"IFERROR(D29-K29,\"\")","v":750000},750000]
[null,null,"ようてい森林組合出資金",2119000,1048178894,665433350,{"$f":"IFERROR(E30-F30,\"\")","v":382745544},100640000,{"$f":"IFERROR(D30/H30,\"\")","v":2.105524642289348E-2},{"$f":"IFERROR(G30*I30,\"\")","v":8058801.7461844189},0,{"$f":"IFERROR(D30-K30,\"\")","v":2119000},2119000]
[null,null,"地方公共団体金融機構出資金",400000,24786267000000,24545185000000,{"$f":"IFERROR(E31-F31,\"\")","v":241082000000},16602000000,{"$f":"IFERROR(D31/H31,\"\")","v":2.4093482712926154E-5},{"$f":"IFERROR(G31*I31,\"\")","v":5808504.9993976634},0,{"$f":"IFERROR(D31-K31,\"\")","v":400000},400000]
["合計行終了",null,null,null,null,null,{"$f":"IFERROR(E32-F32,\"\")","v":0},null,{"$f":"IFERROR(D32/H32,\"\")","v":""},{"$f":"IFERROR(G32*I32,\"\")","v":""},null,{"$f":"IFERROR(D32-K32,\"\")","v":0}]
[null,null,"合計",{"$f":"IFERROR(SUM(D24:D32),\"\")","v":4152000},{"$f":"IFERROR(SUM(E24:E32),\"\")","v":25205644229720},{"$f":"IFERROR(SUM(F24:F32),\"\")","v":24922761292499},282882937221,{"$f":"IFERROR(SUM(H24:H32),\"\")","v":49758476102},8.3443069910115546E-5,23604620.706910729,{"$f":"IFERROR(SUM(K24:K32),\"\")","v":0},4152000,{"$f":"IFERROR(SUM(M24:M32),\"\")","v":4152000}]

{"sheet":"基金","index":6,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[[5,8,6,8],[5,2,6,2],[5,3,6,3],[5,4,6,4],[5,5,6,5],[5,6,6,6],[5,7,6,7]]}
[]
[null,null,null,null,null,"貸借対照表\n固定資産　基金","貸借対照表\n流動資産　基金","貸借対照表\n基金合計","判定"]
[null,null,null,null,null,null,null,{"$f":"SUM(F3:G3)","v":0},{"$f":"IF(H3=H20,\"○\",\"×\")","v":"×"}]
[]
[null,null,"④基金の明細",null,null,null,null,null,"（単位：円）"]
[null,null,"種類","現金預金","有価証券","土地","その他","合計\n(貸借対照表計上額)","(参考)財産に関する\n調書記載額"]
[]
["合計行開始"]
[null,null,"財政調整基金",495813677,null,null,null,{"$f":"SUM(D9:G9)","v":495813677},495813677]
[null,null,"減債基金",163192761,null,null,null,163192761,163192761]
[null,null,"公共施設整備基金",423304152,null,null,null,423304152,423304152]
[null,null,"土地開発基金",17643375,null,null,null,17643375,17643375]
[null,null,"農産物価格安定基金",51177861,null,null,null,51177861,51177861]
[null,null,"敬老福祉基金",135855454,null,null,null,135855454,135855454]
[null,null,"ふるさと創生基金",50000000,null,null,null,50000000,50000000]
[null,null,"畑地かんがい排水施設管理基金",48674372,null,null,null,48674372,48674372]
[null,null,"さくら・もみじ基金",53105518,null,null,null,53105518,53105518]
[null,null,"移住・定住支援事業基金",97000000,null,null,null,97000000,97000000]
["合計行終了"]
[null,null,"合計",{"$f":"IFERROR(SUM(D8:D19),\"\")","v":1535767170},0,0,0,1535767170,1535767170]

{"sheet":"貸付金","index":7,"n_rows":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":false,"merged":[[15,2,15,7],[19,2,19,7],[23,2,23,7],[27,2,27,7],[5,2,6,2],[5,3,5,4],[5,5,5,6],[5,7,6,7],[7,2,7,7],[11,2,11,7]]}
[]
[null,null,null,null,"貸借対照表\n長期貸付金","判定\n(長期貸付金\n貸借対照表計上額)","貸借対照表\n短期貸付金","判定\n(短期貸付金\n貸借対照表計上額)"]
[null,null,null,null,null,{"$f":"IF(D32=E3,\"○\",\"×\")","v":"○"},null,{"$f":"IF(F32=G3,\"○\",\"×\")","v":"○"}]
[]
[null,null,"⑤貸付金の明細",null,null,null,null,"（単位：円）"]
[null,null,"相手先名または種別","長期貸付金",null,"短期貸付金",null,"（参考）\n貸付金計"]
[null,null,null,"貸借対照表計上額","徴収不能引当金\n計上額","貸借対照表計上額","徴収不能引当金\n計上額"]
[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,"合計",{"$f":"IFERROR(SUM(D9:D31),\"\")","v":0},{"$f":"IFERROR(SUM(E9:E31),\"\")","v":0},{"$f":"IFERROR(SUM(F9:F31),\"\")","v":0},{"$f":"IFERROR(SUM(G9:G31),\"\")","v":0},{"$f":"IFERROR(SUM(H9:H31),\"\")","v":0}]

{"sheet":"長期延滞債権","index":8,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[8,2,8,4],[6,2,6,4],[17,2,17,4],[19,2,19,4],[26,2,26,4],[12,2,12,4]]}
[]
[null,null,null,null,"貸借対照表\n長期延滞債権","判定\n(貸借対照表計上額)"]
[null,null,null,"-",null,{"$f":"IF(D33=E3,\"○\",\"×\")","v":"×"}]
[]
[null,null,"⑥長期延滞債権の明細",null,"（単位：円）"]
[null,null,"相手先名または種別","貸借対照表計上額","徴収不能引当金計上額"]
[null,null,"【貸付金】"]
[]
[null,null,"第三セクター等"]
["合計行開始"]
[null,null,"  該当なし"]
["合計行終了"]
[null,null,"その他の貸付金"]
["合計行開始"]
[null,null,"  該当なし"]
["合計行終了"]
[null,null,"小計",{"$f":"IFERROR(SUM(D10:D16),\"\")","v":0},{"$f":"IFERROR(SUM(E10:E16),\"\")","v":0}]
[null,null,"【未収金】"]
[]
[null,null,"税等未収金"]
["合計行開始"]
[null,null,"　村民税",4144188,153350]
[null,null,"　固定資産税",1249330,46230]
[null,null,"　軽自動車税",287200,10628]
[null,null,"　特別土地保有税",63700,2357]
["合計行終了"]
[null,null,"その他の未収金"]
["合計行開始"]
[null,null,"　村営住宅使用料",0,0]
[null,null,"　督促手数料",55800,2065]
["合計行終了"]
[null,null,"小計",{"$f":"IFERROR(SUM(D19:D31),\"\")","v":5800218},{"$f":"IFERROR(SUM(E19:E31),\"\")","v":214630}]
[null,null,"合計",{"$f":"IFERROR(SUM(D17,D32),\"\")","v":5800218},{"$f":"IFERROR(SUM(E17,E32),\"\")","v":214630}]

{"sheet":"未収金","index":9,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[26,2,26,4],[6,2,6,4],[8,2,8,4],[12,2,12,4],[17,2,17,4],[19,2,19,4]]}
[]
[null,null,null,null,"貸借対照表\n未収金","判定\n(貸借対照表計上額)"]
[null,null,null,null,null,{"$f":"IF(D33=E3,\"○\",\"×\")","v":"×"}]
[]
[null,null,"⑦未収金の明細",null,"（単位：円）"]
[null,null,"相手先名または種別","貸借対照表計上額","徴収不能引当金計上額"]
[null,null,"【貸付金】"]
[]
[null,null,"第三セクター等"]
["合計行開始"]
[null,null,"  該当なし"]
["合計行終了"]
[null,null,"その他の貸付金"]
["合計行開始"]
[null,null,"  該当なし"]
["合計行終了"]
[null,null,"小計",{"$f":"IFERROR(SUM(D10:D16),\"\")","v":0},{"$f":"IFERROR(SUM(E10:E16),\"\")","v":0}]
[null,null,"【未収金】"]
[]
[null,null,"税等未収金"]
["合計行開始"]
[null,null,"　村民税",1007898,37295]
[null,null,"　固定資産税",16926100,626331]
[null,null,"　軽自動車税",196300,7264]
[null,null,"　特別土地保有税",0,0]
["合計行終了"]
[null,null,"その他の未収金"]
["合計行開始"]
[null,null,"　村営住宅使用料",37200,1377]
[null,null,"　督促手数料",15500,574]
["合計行終了"]
[null,null,"小計",{"$f":"IFERROR(SUM(D21:D31),\"\")","v":18182998},{"$f":"IFERROR(SUM(E21:E31),\"\")","v":672841}]
[null,null,"合計",{"$f":"IFERROR(SUM(D17,D32),\"\")","v":18182998},{"$f":"IFERROR(SUM(E17,E32),\"\")","v":672841}]

{"sheet":"地方債（借入先別）","index":10,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[[16,1,16,11],[1,4,1,5],[2,4,2,5],[1,7,1,8],[2,7,2,8],[7,8,8,8],[7,11,8,11],[7,1,8,1],[7,2,8,2],[7,4,8,4],[7,5,8,5],[7,6,8,6],[7,7,8,7],[9,1,9,11]]}
[]
[null,null,null,null,"貸借対照表\n固定負債\n地方債",null,"判定\n(地方債残高)","貸借対照表\n流動負債\n1年内償還予定地方債",null,"判定\n(うち1年内\n償還予定)"]
[null,null,null,null,null,null,{"$f":"IF(E3=C22-D22,\"○\",\"×\")","v":"×"},null,null,{"$f":"IF(D22=H3,\"○\",\"×\")","v":"×"}]
[]
[]
[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,"　　一般公共事業",0,0]
[null,"　　公営住宅建設",271368176,13646968,134068176,null,null,null,null,null,null,137300000]
[null,"　　災害復旧",1656576,273345,1656576]
[null,"　　教育・福祉施設",49948649,22111901,49948649]
[null,"　　一般単独事業",102417025,19717732,null,102417025]
[null,"　　その他",837672757,55248537,837672757]
[null,"【特別分】"]
[null,"　　臨時財政対策債",1095391142,82153370,964139142,null,null,131252000]
[null,"　　減税補てん債"]
[null,"　　退職手当債"]
[null,"　　その他",15282182,7425142,5458647,9823535]
[null,"合計",{"$f":"IFERROR(SUM(C11:C16)+SUM(C18:C21),\"\")","v":2373736507},{"$f":"IFERROR(SUM(D11:D16)+SUM(D18:D21),\"\")","v":200576995},{"$f":"IFERROR(SUM(E11:E16)+SUM(E18:E21),\"\")","v":1992943947},{"$f":"IFERROR(SUM(F11:F16)+SUM(F18:F21),\"\")","v":112240560},0,131252000,0,{"$f":"IFERROR(SUM(J11:J16)+SUM(J18:J21),\"\")","v":0},{"$f":"IFERROR(SUM(K11:K16)+SUM(K18:K21),\"\")","v":0},{"$f":"IFERROR(SUM(L11:L16)+SUM(L18:L21),\"\")","v":137300000}]

{"sheet":"地方債（利率別など）","index":11,"n_rows":18,"n_cols":17,"rows_kept":18,"cut":false,"hidden":false,"merged":[[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,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],[9,10,10,10],[9,11,10,11],[9,16,10,16],[3,13,4,13],[3,14,4,14],[9,13,10,13],[9,14,10,14],[9,15,10,15]]}
[]
[]
[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,"貸借対照表\n固定負債 地方債 ＋\n流動負債 1年内償還予定地方債","判定\n(地方債残高)"]
[]
[null,null,{"$f":"IFERROR(SUM(D6:J6),\"\")","v":2373736507},2130174070,168486156,17600809,null,null,null,57475472,8.4072000000000001E-3,null,null,null,{"$f":"IF(C6=N6,\"○\",\"×\")","v":"×"}]
[]
[]
[null,null,"③地方債（返済期間別）の明細",null,null,null,null,null,null,null,null,"（単位：円）"]
[null,null,"地方債残高","１年以内","１年超\n２年以内","２年超\n３年以内","３年超\n４年以内","４年超\n５年以内","５年超\n10年以内","10年超\n15年以内","15年超\n20年以内","20年超",null,"貸借対照表\n固定負債 地方債","判定\n(地方債残高)","貸借対照表\n流動負債 1年内償還予定地方債","判定\n(地方債残高)"]
[]
[null,null,{"$f":"IFERROR(SUM(D12:L12),\"\")","v":2373736507},200576995,221355320,224249397,221534201,214008741,834874001,335109492,103212841,18815519,null,null,{"$f":"IF(SUM(E12:L12)=N12,\"○\",\"×\")","v":"×"},null,{"$f":"IF(D12=P12,\"○\",\"×\")","v":"×"}]
[]
[]
[null,null,"④特定の契約条項が付された地方債の概要",null,null,null,null,null,"（単位：円）"]
[null,null,"特定の契約条項が\n付された地方債残高","契約条項の概要"]
[]
[null,null,"該当なし"]

{"sheet":"引当金","index":12,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[4,10,5,10],[5,1,5,6],[8,1,8,6],[10,1,10,6],[13,1,13,6],[4,9,5,9],[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,null,"貸借対照表\n各引当金　金額","判定\n(本年度末残高)"]
[null,"固定資産"]
[null,"投資損失引当金",0,0,0,0,{"$f":"IFERROR(C7+D7-E7-F7,\"\")","v":0},null,null,null,{"$f":"IF(G7=-J7,\"○\",\"×\")","v":"○"}]
[null,"徴収不能引当金",1192283,0,657019,320634,{"$f":"IFERROR(C8+D8-E8-F8,\"\")","v":214630},null,null,null,{"$f":"IF(G8=-J8,\"○\",\"×\")","v":"×"}]
[null,"流動資産",null,null,null,null,null,null,null,null,"―"]
[null,"徴収不能引当金",1297026,0,0,624185,{"$f":"IFERROR(C10+D10-E10-F10,\"\")","v":672841},null,null,null,{"$f":"IF(G10=-J10,\"○\",\"×\")","v":"×"}]
[null,"固定負債",null,null,null,null,null,null,null,null,"―"]
[null,"退職手当引当金",176776000,null,0,27481000,{"$f":"IFERROR(C12+D12-E12-F12,\"\")","v":149295000},null,null,null,{"$f":"IF(G12=J12,\"○\",\"×\")","v":"×"}]
[null,"損失補償等引当金",0,0,0,0,{"$f":"IFERROR(C13+D13-E13-F13,\"\")","v":0},null,null,null,{"$f":"IF(G13=J13,\"○\",\"×\")","v":"○"}]
[null,"流動負債",null,null,null,null,null,null,null,null,"―"]
[null,"賞与等引当金",21098444,21831498,21098444,0,{"$f":"IFERROR(C15+D15-E15-F15,\"\")","v":21831498},null,null,null,{"$f":"IF(G15=J15,\"○\",\"×\")","v":"×"}]
[null,"合計",{"$f":"IFERROR(SUM(C6:C15),\"\")","v":200363753},{"$f":"IFERROR(SUM(D6:D15),\"\")","v":21831498},21755463,28425819,172013969]

{"sheet":"補助金","index":13,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[[10,8,10,9],[6,1,6,2],[6,4,6,5],[6,6,6,7],[6,8,6,9],[8,4,8,5],[8,6,8,7],[8,8,8,9],[1,6,1,7],[1,8,1,9],[2,6,2,7],[2,8,2,9],[5,8,5,9],[30,1,30,2],[30,4,30,5],[30,6,30,7],[30,8,30,9],[12,4,12,5],[12,6,12,7],[12,8,12,9],[29,4,29,5],[29,6,29,7],[29,8,29,9],[27,4,27,5],[27,6,27,7],[13,4,13,5],[13,6,13,7],[13,8,13,9],[17,4,17,5],[14,8,14,9],[17,6,17,7],[17,8,17,9],[27,8,27,9],[26,4,26,5],[26,6,26,7],[26,8,26,9],[19,4,19,5],[19,6,19,7],[19,8,19,9],[18,4,18,5],[18,6,18,7],[18,8,18,9],[24,4,24,5],[24,6,24,7],[24,8,24,9],[25,8,25,9],[16,8,16,9],[15,4,15,5],[15,6,15,7],[15,8,15,9],[20,6,20,7],[20,8,20,9],[20,4,20,5],[25,4,25,5],[25,6,25,7],[16,4,16,5],[16,6,16,7],[23,8,23,9],[22,8,22,9],[21,6,21,7],[21,8,21,9],[12,1,29,2],[14,4,14,5],[14,6,14,7],[10,4,10,5],[10,6,10,7],[8,1,10,2],[23,4,23,5],[23,6,23,7],[22,4,22,5],[22,6,22,7],[21,4,21,5]]}
[]
[null,null,null,null,null,null,"行政コスト計算書\n補助金等",null,"判定\n(金額)"]
[null,null,null,null,null,null,null,null,{"$f":"IF(G31=G3,\"○\",\"×\")","v":"×"}]
[]
[null,"２．行政コスト計算書の内容に関する明細"]
[null,"（１）補助金等の明細",null,null,null,null,null,null,"（単位：円）"]
[null,"区分",null,"名称","相手先",null,"金額",null,"支出目的"]
["合計行開始"]
[null,"他団体への公共施設等整備補助金等\r\n(所有外資産分）",null,"該当なし"]
["合計行終了"]
[null,null,null,"計",null,null,{"$f":"IFERROR(SUM(G8:G10),\"\")","v":0}]
["合計行開始"]
[null,"その他の補助金等",null,"北後志消防組合負担金","北後志消防組合",null,149633000]
[null,null,null,"後志広域連合負担金","後志広域連合",null,26747604]
[null,null,null,"村社会福祉協議会運営事業補助金","赤井川村社会福祉協議会",null,16357000]
[null,null,null,"学校給食業務負担金",null,null,12727600]
[null,null,null,"市町村生活バス運行補助金",null,null,12725120]
[null,null,null,"橋梁点検業務負担金",null,null,12268800]
[null,null,null,"後期高齢者医療広域連合療養給付費負担金","北海道後期高齢者医療広域連合",null,10189891]
[null,null,null,"土づくり対策事業補助金",null,null,9600000]
[null,null,null,"北後志衛生施設組合負担金","北後志衛生施設組合",null,9358000]
[null,null,null,"北しりべし廃棄物処理広域連合負担金","北しりべし廃棄物処理広域連合",null,7900000]
[null,null,null,"農業振興センター運営事業補助金",null,null,7687700]
[null,null,null,"臨時福祉給付金","対象者",null,7071000]
[null,null,null,"中学生海外研修事業補助金",null,null,6245000]
[null,null,null,"村商工会運営事業補助金",null,null,6000000]
[null,null,null,"青年就農給付金",null,null,5973949]
[null,null,null,"その他",null,null,{"$f":"48907957-498551","v":48409406}]
["合計行終了"]
[null,null,null,"計",null,null,{"$f":"IFERROR(SUM(G12:G29),\"\")","v":348894070}]
[null,"合計",null,null,null,null,{"$f":"IFERROR(SUM(G11,G30),\"\")","v":348894070}]

{"sheet":"財源明細","index":14,"n_rows":34,"n_cols":13,"rows_kept":34,"cut":false,"hidden":false,"merged":[[7,3,7,4],[4,1,4,5],[8,1,33,1],[8,2,21,2],[8,3,8,4],[9,3,9,4],[20,3,20,4],[21,3,21,4],[22,3,26,3],[23,2,32,2],[27,3,31,3],[32,3,32,4],[33,2,33,4],[19,3,19,4],[13,3,13,4],[12,3,12,4],[11,3,11,4],[10,3,10,4],[18,3,18,4],[17,3,17,4],[16,3,16,4],[15,3,15,4],[14,3,14,4]]}
[]
[null,null,null,null,null,null,null,"純資産変動計算書\n財源","判定\n(一般会計\n金額)","純資産変動計算書\n税収等","判定\n(税収等\n金額)","純資産変動計算書\n国県等補助金","判定\n(国県等補助金\n金額)"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM($F34)=$H$3,\"○\",\"×\")","v":"×"},null,{"$f":"IF(SUM($F22)=$J$3,\"○\",\"×\")","v":"×"},null,{"$f":"IF(SUM($F33)=$L$3,\"○\",\"×\")","v":"×"}]
[]
[null,"３．純資産変動計算書の内容に関する明細"]
[null,"（１）財源の明細",null,null,null,"（単位：円）"]
[null,"会計","区分","財源の内容",null,"金額"]
["合計行開始"]
[null,"一般会計","税収等","村税",null,{"$f":"304849052-(1541411864-1519822440)","v":283259628}]
[null,null,null,"地方譲与税",null,40002000]
[null,null,null,"利子割交付金",null,101000]
[null,null,null,"配当割交付金",null,189000]
[null,null,null,"株式等譲渡所得割交付金",null,113000]
[null,null,null,"地方消費税交付金",null,23140000]
[null,null,null,"自動車取得税交付金",null,6800000]
[null,null,null,"地方特例交付金",null,88000]
[null,null,null,"地方交付税",null,1106226000]
[null,null,null,"交通安全対策特別交付金",null,0]
[null,null,null,"分担金及び負担金",null,2386810]
[null,null,null,"寄付金",null,57517002]
["合計行終了"]
[null,null,null,"小計",null,{"$f":"SUM(F8:F21)","v":1519822440}]
["合計行開始",null,null,"資本的\n補助金"]
[null,null,"国県等補助金",null,"国庫支出金",120598000]
[null,null,null,null,"道支出金",0]
["合計行終了"]
[null,null,null,null,"計",{"$f":"SUM(F23:F26)","v":120598000}]
["合計行開始",null,null,"経常的\n補助金"]
[null,null,null,null,"国庫支出金",{"$f":"177827320-F24","v":57229320}]
[null,null,null,null,"道支出金",{"$f":"56813442","v":56813442}]
["合計行終了"]
[null,null,null,null,"計",{"$f":"SUM(F28:F31)","v":114042762}]
[null,null,null,"小計",null,{"$f":"SUM(F27,F32)","v":234640762}]
[null,null,"合計",null,null,{"$f":"SUM(F22,F33)","v":1754463202}]

{"sheet":"財源情報明細","index":15,"n_rows":22,"n_cols":11,"rows_kept":22,"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,null,"金額","判定"]
[null,"純行政コスト",{"$f":"IFERROR(SUM(D7:G7),\"\")","v":2234896759},{"$f":"財源明細!F32","v":114042762},{"$f":"294317000-E8","v":141517000},{"$f":"F22-F8-F9","v":1402506828},{"$f":"J7-D7-E7-F7","v":576830169},null,"純資産変動計算書\n純行政コストの合計",2234896759,{"$f":"IF(J7=C7,\"○\",\"×\")","v":"○"}]
[null,"有形固定資産等の増加",{"$f":"IFERROR(SUM(D8:G8),\"\")","v":286470205},{"$f":"財源明細!F27","v":120598000},152800000,{"$f":"J8-D8-E8-G8","v":13072205},0,null,"純資産変動計算書\n有形固定資産等の増加\n固定資産等形成分",286470205,{"$f":"IF(J8=C8,\"○\",\"×\")","v":"○"}]
[null,"貸付金・基金等の増加",7382823,0,0,{"$f":"J9-D9-E9-G9","v":6405170},977653,null,"純資産変動計算書\n貸付金・基金等の増加\n固定資産等形成分",7382823,{"$f":"IF(J9=C9,\"○\",\"×\")","v":"○"}]
[null,"その他",0,0,0,0,0,null,"純資産変動計算書\nその他の合計",0,{"$f":"IF(J10=C10,\"○\",\"×\")","v":"○"}]
[null,"合計",2528749787,{"$f":"IFERROR(SUM(D7:D10),\"\")","v":234640762},{"$f":"IFERROR(SUM(E7:E10),\"\")","v":294317000},1421984203,577807822]
[]
[]
[]
[null,null,null,"NW国県等補助金と一致","CF地方債収入と一致","NW税収等-CF地方債償還支出-CF本年度資金収支額-CF公共施設等整備費支出に含まれる長期未払支払額と一致"]
[null,null,null,"OK","OK","OK"]
[]
[]
[null,null,null,null,"NW税収等",1519822440]
[null,null,null,null,"CF地方債償還支出",184045927]
[null,null,null,null,"CF本年度収支差額",-86207690]
[null,null,null,null,"差引",{"$f":"F19-F20-F21","v":1421984203}]

{"sheet":"資金明細","index":16,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[13,1,13,2]]}
[]
[null,null,null,"資金収支計算書\n本年度末資金残高","判定\n（本年度末残高）"]
[null,null,null,null,{"$f":"IF(C11=D3,\"○\",\"×\")","v":"×"}]
[]
[null,"４．資金収支計算書の内容に関する明細"]
[null,"（１）資金の明細","（単位：円）"]
[null,"種類","本年度末残高"]
["合計行開始"]
[null,"要求払預金",109842111]
["合計行終了"]
[null,"合計",{"$f":"IFERROR(SUM(C8:C10),\"\")","v":109842111}]

{"sheet":"財源会計テンプレート","index":17,"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}]