{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["使用上の留意点","確認ポイント整理図","start","様式1","end","総括表"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":4,"comments":2,"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":74,"n_cols":17,"rows_kept":74,"cut":false,"hidden":false,"merged":[[73,1,73,17],[1,0,1,18],[4,1,4,18],[5,1,5,17]]}
[]
["使用上の留意点"]
[]
[]
[null,"１．　はじめに、印刷指定範囲外にある「地方長期資金等」、「臨時財政対策債」のいずれかのボタンを選択すると、入力が必要な項目（クリーム色で\n　　　着色されたセル）が表示されます。なお、「リセット」ボタンをクリックすると入力項目がすべてクリアされますので注意ください。\n　　　作成に当たっては、以下の点にご留意願います。\n　　　(1)　「start」及び「end」タブのシートは、削除しないで下さい。\n　　　(2)　シートを追加する場合には、「start」タブと「end」タブの間に挿入して下さい。\n　　　　　　（印刷指定範囲外にある「シートコピー（追加）」欄をクリックすると「start」タブと「end」タブの間に挿入されます。）\n　　　(3)　「行」・「列」の挿入・削除は行わないで下さい。"]
[null,"２．確認用チェックについて\n　　　よく確認いただく事項をチェックすることができます。\n　　　入力終了後、「チェック」ボタンを押下すると、確認いただきたい項目が色付けされるとともに、表下に「確認ボックス」欄に具体的な内容が表示されます。\n　　　表示される確認項目は以下のとおりとなっています。\n　　　（※ なお、確認ボックスをご確認の上、ご提出いただいた場合でも、個別で確認の相談をさせていただく場合もございます。あらかじめご了承願います。）"]
[]
[null,"主な確認項目"]
[null,"①","支出金額合計額と収入金額合計額が一致していません。",null,null,null,null,null,null,null,null,null,null,null,null,null,"臨財債除く"]
[null,"②","基準充当率が入力されておりません。(「J38」セル)",null,null,null,null,null,null,null,null,null,null,null,null,null,"臨財債除く"]
[null,"③","起債に関する予算の定め欄の利率の但し書きの有無が入力されておりません。(「Y43」セル)"]
[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,"⑦","支出状況欄の基準月（貸付実行月）を入力してください。(「AF11」セル)",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,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　　事業実施状況等調書を複数作成する必要がある場合、「総括表」の提出をお願いいたしておりますが、上記手順に沿って入力すると「総括表」タブのシートに\n　　①事業件数（「start」タブと「end」タブの間にあるシートの枚数）、②合計金額（「start」タブと「end」タブの間にあるシートの同位置にあるセルに入力されている金額を\n　　合計金額）が、自動的に反映されますのでご活用願います。\n　　　（注）同位置にあるセルに異なる財源内訳などの金額を入力している場合においても、単純合計されますのでご注意下さい。"]

{"sheet":"確認ポイント整理図","index":1,"n_rows":60,"n_cols":42,"rows_kept":60,"cut":false,"hidden":false,"merged":[[50,2,53,39],[54,28,54,39],[48,5,48,6],[48,8,48,11],[48,13,48,15],[48,17,48,18],[48,20,48,21],[48,23,48,30],[46,20,46,21],[46,23,46,30],[47,5,47,6],[47,8,47,11],[47,13,47,15],[47,17,47,18],[47,20,47,21],[47,23,47,30],[44,2,48,3],[46,5,46,6],[46,8,46,11],[46,13,46,15],[46,17,46,18],[44,23,44,30],[44,31,44,39],[45,5,45,6],[45,8,45,11],[45,13,45,15],[45,17,45,18],[45,20,45,21],[45,23,45,30],[45,32,45,34],[44,5,44,7],[44,8,44,12],[44,13,44,16],[44,17,44,19],[44,20,44,22],[36,32,36,35],[36,36,36,39],[37,2,37,8],[37,10,37,12],[37,13,37,15],[37,16,37,19],[37,20,38,22],[37,23,37,25],[37,26,37,39],[38,2,38,8],[38,10,38,12],[38,13,38,15],[38,16,38,19],[38,23,38,25],[38,26,38,39],[36,2,36,9],[36,10,36,12],[36,13,36,15],[36,16,36,19],[36,20,36,23],[36,24,36,27],[36,28,36,31],[39,2,43,3],[39,4,39,5],[39,6,39,9],[39,10,39,11],[39,12,39,18],[39,19,39,21],[39,22,39,26],[40,4,40,7],[40,8,40,13],[40,14,40,19],[40,20,40,25],[40,26,40,39],[41,4,43,7],[41,10,41,12],[41,22,41,23],[42,10,42,12],[42,35,42,38],[43,8,43,9],[43,10,43,12],[43,15,43,19],[43,27,43,29],[34,36,34,39],[35,2,35,4],[35,5,35,9],[35,10,35,12],[35,13,35,15],[35,16,35,19],[35,20,35,23],[35,24,35,27],[35,28,35,31],[35,32,35,35],[35,36,35,39],[34,2,34,4],[34,5,34,9],[34,10,34,12],[34,13,34,15],[34,16,34,19],[34,20,34,23],[34,24,34,27],[34,28,34,31],[34,32,34,35],[32,32,32,35],[32,36,32,39],[33,2,33,4],[33,5,33,9],[33,10,33,12],[33,13,33,15],[33,16,33,19],[33,20,33,23],[33,24,33,27],[33,28,33,31],[33,32,33,35],[33,36,33,39],[32,2,32,4],[32,5,32,9],[32,10,32,12],[32,13,32,15],[32,16,32,19],[32,20,32,23],[32,24,32,27],[29,2,31,2],[32,28,32,31],[30,28,30,31],[30,32,30,35],[30,36,30,39],[31,3,31,4],[31,5,31,8],[31,10,31,12],[31,13,31,15],[31,16,31,19],[31,20,31,23],[31,24,31,27],[30,5,30,8],[30,10,30,12],[30,13,30,15],[30,16,30,19],[30,20,30,23],[30,24,30,27],[29,3,30,4],[29,5,29,8],[29,10,29,12],[29,13,29,15],[31,28,31,31],[31,32,31,35],[31,36,31,39],[27,36,27,39],[28,3,28,4],[28,5,28,8],[28,10,28,12],[28,13,28,15],[28,16,28,19],[29,16,29,19],[29,20,29,23],[29,24,29,27],[29,28,29,31],[29,32,29,35],[29,36,29,39],[28,20,28,23],[28,24,28,27],[28,28,28,31],[28,32,28,35],[28,36,28,39],[25,36,25,39],[26,3,26,4],[26,5,26,8],[26,10,26,12],[26,13,26,15],[26,16,26,19],[26,20,26,23],[26,24,26,27],[26,28,26,31],[26,32,26,35],[26,36,26,39],[25,2,28,2],[25,3,25,4],[25,5,25,8],[25,10,25,12],[25,13,25,15],[25,16,25,19],[24,24,24,27],[24,28,24,31],[24,32,24,33],[25,20,25,23],[25,24,25,27],[25,28,25,31],[25,32,25,35],[27,3,27,4],[27,5,27,8],[27,10,27,12],[27,13,27,15],[27,16,27,19],[27,20,27,23],[27,24,27,27],[27,28,27,31],[27,32,27,35],[24,34,24,35],[24,36,24,37],[24,38,24,39],[24,2,24,4],[24,5,24,9],[24,10,24,12],[24,13,24,15],[24,16,24,19],[24,20,24,23],[23,2,23,9],[23,10,23,27],[23,28,23,39],[21,24,21,27],[21,28,21,31],[21,32,21,35],[21,36,21,39],[22,2,22,8],[22,10,22,12],[22,13,22,15],[22,16,22,19],[22,20,22,23],[22,24,22,27],[21,2,21,5],[21,6,21,9],[21,10,21,12],[21,13,21,15],[21,16,21,19],[21,20,21,23],[22,28,22,31],[22,32,22,35],[22,36,22,39],[19,36,19,39],[20,2,20,5],[20,6,20,9],[20,10,20,12],[20,13,20,15],[20,16,20,19],[20,20,20,23],[20,24,20,27],[20,28,20,31],[20,32,20,35],[20,36,20,39],[19,2,19,5],[19,6,19,9],[19,10,19,12],[19,13,19,15],[19,16,19,19],[19,20,19,23],[19,24,19,27],[19,28,19,31],[19,32,19,35],[17,36,17,39],[18,2,18,5],[18,6,18,9],[18,10,18,12],[18,13,18,15],[18,16,18,19],[18,20,18,23],[18,24,18,27],[18,28,18,31],[18,32,18,35],[18,36,18,39],[17,2,17,5],[17,6,17,9],[17,10,17,12],[17,13,17,15],[17,16,17,19],[17,20,17,23],[17,24,17,27],[17,28,17,31],[17,32,17,35],[15,36,15,39],[16,2,16,5],[16,6,16,9],[16,10,16,12],[16,13,16,15],[16,16,16,19],[16,20,16,23],[16,24,16,27],[16,28,16,31],[16,32,16,35],[16,36,16,39],[15,2,15,5],[15,6,15,9],[15,10,15,12],[15,13,15,15],[15,16,15,19],[15,20,15,23],[15,24,15,27],[15,28,15,31],[15,32,15,35],[13,36,13,39],[14,2,14,5],[14,6,14,9],[14,10,14,12],[14,13,14,15],[14,16,14,19],[14,20,14,23],[14,24,14,27],[14,28,14,31],[14,32,14,35],[14,36,14,39],[13,2,13,5],[13,6,13,9],[13,10,13,12],[13,13,13,15],[13,16,13,19],[13,20,13,23],[13,24,13,27],[13,28,13,31],[13,32,13,35],[11,32,11,33],[11,34,11,35],[11,36,11,37],[11,38,11,39],[12,2,12,5],[12,6,12,9],[12,10,12,12],[12,13,12,15],[12,16,12,19],[12,20,12,23],[10,2,11,5],[10,6,11,9],[10,10,10,27],[10,28,10,39],[11,10,11,12],[11,13,11,15],[11,16,11,19],[11,20,11,23],[11,24,11,27],[11,28,11,31],[12,24,12,27],[12,28,12,31],[12,32,12,35],[12,36,12,39],[5,2,5,3],[5,4,5,23],[5,24,5,31],[5,32,5,39],[6,2,9,3],[6,4,9,23],[6,24,9,31],[6,32,9,39],[2,30,2,39],[3,6,3,34],[3,35,3,39],[4,2,4,3],[4,4,4,23],[4,24,4,27],[4,28,4,31],[4,32,4,33],[4,34,4,35],[4,36,4,37]]}
[null,"【ご参考】確認ポイント整理図（記載誤りが多い事項をまとめたもの）"]
[]
[null,null,"別紙第13号書式"]
[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,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,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,{"$f":"SUM(U13:AB13)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U14:AB14)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U21:AB21)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,"計",null,null,null,null,null,null,"Ａ",{"$f":"SUM(K13:M22)","v":0},null,null,{"$f":"SUM(N13:P22)","v":0},null,null,{"$f":"SUM(Q13:T22)","v":0},null,null,null,{"$f":"SUM(U13:X22)","v":0},null,null,null,{"$f":"SUM(Y13:AB22)","v":0},null,null,null,{"$f":"SUM(AC13:AF22)","v":0},null,null,null,{"$f":"SUM(AG13:AJ22)","v":0},null,null,null,{"$f":"SUM(AK13:AN22)","v":0}]
[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,"Ｂ",{"$f":"SUM(U26:AB26)","v":0}]
[null,null,null,"都道府県支出金",null,null,null,null,null,"Ｃ",{"$f":"SUM(U27:AB27)","v":0}]
[null,null,null,null,null,null,null,null,null,"Ｄ",0]
[null,null,null,null,null,null,null,null,null,"Ｅ",0]
[null,null,"起債","財政融資資金",null,"本債",null,null,null,"Ｆ",0]
[null,null,null,null,null,null,null,null,null,"Ｇ",0]
[null,null,null,"その他",null,null,null,null,null,"Ｈ",0]
[null,null,"一般財源",null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,"一時立替金",null,null,null,null,null,null,null,0]
[null,null,"計",null,null,null,null,null,null,null,{"$f":"SUM(K26:M36)","v":0},null,null,{"$f":"SUM(N26:P36)","v":0},null,null,{"$f":"SUM(Q26:T36)","v":0},null,null,null,{"$f":"SUM(U26:X36)","v":0},null,null,null,{"$f":"SUM(Y26:AB36)","v":0},null,null,null,{"$f":"SUM(AC26:AF36)","v":0},null,null,null,{"$f":"SUM(AG26:AJ36)","v":0},null,null,null,{"$f":"SUM(AK26:AN36)","v":0}]
[null,null,"借入時充当率((Ｆ+Ｇ+Ｈ)/(Ａ-Ｂ-Ｃ-Ｄ-Ｅ)×100)",null,null,null,null,null,null,"(％)",{"$f":"IF(K37>0,(K30+K31+K32)/(K23-K26-K27-K28-K29),\"\")","v":""},null,null,{"$f":"IF(N37>0,(N30+N31+N32)/(N23-N26-N27-N28-N29),\"\")","v":""},null,null,{"$f":"IF(Q37>0,(Q30+Q31+Q32)/(Q23-Q26-Q27-Q28-Q29),\"\")","v":""},null,null,null,"起債対象\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,"起債に関する\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,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,"）",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,"■工事費の5.0％以内の額"]
[null,null,"起債同意\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,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,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,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,"■設計監督費（外部委託せず）について、全体事業費の2.75％以内の額"]
[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,"■設計監督費以外の事務費について、全体事業費の2.75％以内の額"]
[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,"■設計監督費（外部委託）の実所要額、及びそれ以外の事務費について全体事業費の2.75％以内の額"]
[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,"■設計監督費（外部委託せず）及びそれ以外の事務費について、それぞれ全体事業費の2.75％以内の額　"]
[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,"■設計監督費と合わせて全体事業費の6.0％以内の額（水道、港湾、下水道）"]
[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,null,null,null,null,null,null,null,"■補助事業と同様の計算方法により算出した範囲内の額（災害復旧）"]
[null,null,null,"1．用紙の大きさは、日本産業規格Ａ列４とする。",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,"2．事業費内訳には、起債対象となる費用のみ記入する。"]
[null,null,null,"3．収支金額、収支状況の各計は一致する。"]
[null,null,null,"4．収支状況は、借入月を「　月」欄に記入する。"]

{"sheet":"start","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"様式1","index":3,"n_rows":105,"n_cols":53,"rows_kept":105,"cut":false,"hidden":false,"merged":[[70,3,70,38],[82,3,82,38],[71,3,71,38],[72,3,72,38],[73,3,73,38],[74,3,74,38],[75,3,75,38],[64,3,64,38],[65,3,65,38],[66,3,66,38],[67,3,67,38],[68,3,68,38],[69,3,69,38],[84,3,84,38],[86,3,86,38],[87,3,87,38],[76,3,76,38],[77,3,77,38],[78,3,78,38],[79,3,79,38],[80,3,80,38],[81,3,81,38],[83,3,83,38],[99,9,99,11],[99,12,99,14],[99,15,99,18],[99,19,99,22],[99,23,99,26],[99,27,99,30],[99,31,99,34],[99,35,99,38],[88,3,88,38],[89,3,89,38],[90,3,90,38],[91,3,91,38],[4,1,4,2],[4,3,4,22],[4,23,4,30],[4,31,4,38],[10,15,10,18],[10,19,10,22],[10,23,10,26],[10,27,10,30],[5,1,8,2],[5,3,8,22],[5,23,8,30],[5,31,8,38],[9,1,10,4],[9,5,10,8],[9,9,9,26],[9,27,9,38],[10,9,10,11],[10,12,10,14],[10,35,10,36],[10,37,10,38],[10,31,10,32],[10,33,10,34],[0,29,0,38],[1,34,1,38],[3,1,3,2],[3,3,3,22],[3,23,3,26],[3,27,3,28],[3,29,3,30],[3,31,3,32],[3,33,3,34],[3,35,3,36],[3,37,3,38],[1,6,1,25],[11,31,11,34],[11,35,11,38],[12,1,12,4],[12,9,12,11],[12,12,12,14],[12,15,12,18],[12,19,12,22],[12,23,12,26],[12,27,12,30],[12,31,12,34],[12,35,12,38],[11,1,11,4],[11,9,11,11],[11,12,11,14],[11,15,11,18],[11,19,11,22],[11,23,11,26],[11,27,11,30],[11,5,11,8],[12,5,12,8],[13,35,13,38],[14,1,14,4],[14,9,14,11],[14,12,14,14],[14,15,14,18],[14,19,14,22],[14,23,14,26],[14,27,14,30],[14,31,14,34],[14,35,14,38],[13,1,13,4],[13,9,13,11],[13,12,13,14],[13,15,13,18],[13,19,13,22],[13,23,13,26],[13,27,13,30],[13,31,13,34],[13,5,13,8],[14,5,14,8],[15,35,15,38],[16,1,16,4],[16,9,16,11],[16,12,16,14],[16,15,16,18],[16,19,16,22],[16,23,16,26],[16,27,16,30],[16,31,16,34],[16,35,16,38],[15,1,15,4],[15,9,15,11],[15,12,15,14],[15,15,15,18],[15,19,15,22],[15,23,15,26],[15,27,15,30],[15,31,15,34],[15,5,15,8],[16,5,16,8],[17,35,17,38],[18,1,18,4],[18,9,18,11],[18,12,18,14],[18,15,18,18],[18,19,18,22],[18,23,18,26],[18,27,18,30],[18,31,18,34],[18,35,18,38],[17,1,17,4],[17,9,17,11],[17,12,17,14],[17,15,17,18],[17,19,17,22],[17,23,17,26],[17,27,17,30],[17,31,17,34],[17,5,17,8],[18,5,18,8],[19,35,19,38],[20,1,20,4],[20,9,20,11],[20,12,20,14],[20,15,20,18],[20,19,20,22],[20,23,20,26],[20,27,20,30],[20,31,20,34],[20,35,20,38],[19,1,19,4],[19,9,19,11],[19,12,19,14],[19,15,19,18],[19,19,19,22],[19,23,19,26],[19,27,19,30],[19,31,19,34],[19,5,19,8],[20,5,20,8],[23,35,23,36],[23,37,23,38],[21,35,21,38],[22,1,22,8],[22,9,22,26],[22,27,22,38],[23,1,23,3],[23,4,23,8],[23,9,23,11],[23,12,23,14],[23,15,23,18],[23,19,23,22],[21,1,21,7],[21,9,21,11],[21,12,21,14],[21,15,21,18],[21,19,21,22],[21,23,21,26],[21,27,21,30],[21,31,21,34],[23,33,23,34],[24,1,27,1],[24,2,24,3],[24,4,24,7],[24,9,24,11],[24,12,24,14],[24,15,24,18],[23,23,23,26],[23,27,23,30],[23,31,23,32],[24,19,24,22],[24,23,24,26],[24,27,24,30],[24,31,24,34],[26,2,26,3],[26,4,26,7],[26,9,26,11],[26,12,26,14],[26,15,26,18],[26,19,26,22],[26,23,26,26],[26,27,26,30],[26,31,26,34],[24,35,24,38],[25,2,25,3],[25,4,25,7],[25,9,25,11],[25,12,25,14],[25,15,25,18],[25,19,25,22],[25,23,25,26],[25,27,25,30],[25,31,25,34],[25,35,25,38],[30,35,30,38],[26,35,26,38],[27,2,27,3],[27,4,27,7],[27,9,27,11],[27,12,27,14],[27,15,27,18],[28,15,28,18],[28,19,28,22],[28,23,28,26],[28,27,28,30],[28,31,28,34],[28,35,28,38],[27,19,27,22],[27,23,27,26],[27,27,27,30],[27,31,27,34],[27,35,27,38],[28,1,30,1],[31,27,31,30],[29,27,29,30],[29,31,29,34],[29,35,29,38],[30,2,30,3],[30,4,30,7],[30,9,30,11],[30,12,30,14],[30,15,30,18],[30,19,30,22],[30,23,30,26],[29,4,29,7],[29,9,29,11],[29,12,29,14],[29,15,29,18],[29,19,29,22],[29,23,29,26],[28,2,29,3],[28,4,28,7],[28,9,28,11],[28,12,28,14],[30,27,30,30],[30,31,30,34],[31,31,31,34],[31,35,31,38],[32,1,32,3],[32,4,32,8],[32,9,32,11],[32,12,32,14],[32,15,32,18],[32,19,32,22],[32,23,32,26],[32,27,32,30],[32,31,32,34],[32,35,32,38],[31,1,31,3],[31,4,31,8],[31,9,31,11],[31,12,31,14],[31,15,31,18],[31,19,31,22],[31,23,31,26],[33,35,33,38],[34,1,34,3],[34,4,34,8],[34,9,34,11],[34,12,34,14],[34,15,34,18],[34,19,34,22],[34,23,34,26],[34,27,34,30],[34,31,34,34],[34,35,34,38],[33,1,33,3],[33,4,33,8],[33,9,33,11],[33,12,33,14],[33,15,33,18],[33,19,33,22],[33,23,33,26],[33,27,33,30],[33,31,33,34],[38,1,42,2],[38,3,38,4],[38,7,38,8],[38,9,38,10],[38,11,38,17],[38,18,38,21],[38,22,38,25],[39,3,39,7],[39,8,39,12],[39,13,39,18],[39,19,39,24],[39,25,39,38],[40,3,42,7],[40,9,40,11],[40,21,40,22],[41,9,41,11],[41,32,41,33],[41,34,41,37],[42,9,42,11],[42,16,42,17],[42,26,42,28],[35,31,35,34],[35,35,35,38],[36,1,36,7],[36,9,36,11],[36,12,36,14],[36,15,36,18],[36,19,37,21],[36,22,36,24],[36,25,36,38],[37,1,37,7],[37,9,37,11],[37,12,37,14],[37,15,37,18],[37,22,37,24],[37,25,37,38],[35,1,35,8],[35,9,35,11],[35,12,35,14],[35,15,35,18],[35,19,35,22],[35,23,35,26],[35,27,35,30],[62,3,62,38],[63,3,63,38],[43,1,47,2],[43,30,43,38],[44,31,44,33],[45,16,45,17],[47,4,47,6],[43,4,43,7],[43,8,43,11],[43,12,43,15],[47,22,47,29],[45,19,45,20],[46,19,46,20],[46,22,46,29],[46,12,46,14],[45,4,45,6],[45,8,45,10],[45,12,45,14],[47,8,47,10],[44,16,44,17],[45,22,45,29],[46,4,46,6],[46,8,46,10],[47,12,47,14],[43,22,43,29],[43,16,43,18],[43,19,43,21],[60,12,60,17],[44,19,44,20],[44,22,44,29],[46,16,46,17],[49,1,52,38],[53,27,53,38],[47,16,47,17],[47,19,47,20],[44,4,44,6],[44,8,44,10],[44,12,44,14]]}
[null,"別紙第13号書式",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,null,null,null,null,"年度",null,null,null,"現在選択中種類",null,null,null,{"$f":"総括表!AT4","v":"一括印刷"}]
[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,0,{"$f":"AI2","v":0},null,null,{"$f":"総括表!AT5","v":0}]
[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,{"$f":"総括表!AT6","v":"一括チェック"}]
[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,{"$f":"総括表!AT7","v":0}]
[]
[]
[null,"事　業　費　内　訳",null,null,null,"事業開始日～\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,null,null,null,null,null,null,null,null,null,null,null,"横計CHECK計算式入力セル",null,null,null,"横計CHECK計算式入力セル"]
[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,{"$f":"SUM(T12:AA12)","v":0},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,{"$f":"IF($AI$2<>\"【長期（部分払あり）】\",\"\",IF($J12=SUM($AB12:$AM12),\"ok\",\"check\"))","v":""},null,null,null,{"$f":"IF($AI$2=\"【長期（部分払なし）】\",IF(AND($J12=SUM($M12:$S12),$J12=SUM($T12:$AA12)),\"ok\",\"check\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(T13:AA13)","v":0},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,"有","㉚までは関数㉛からは、VBAで判定している。",null,null,null,{"$f":"IF($AI$2<>\"【長期（部分払あり）】\",\"\",IF($J13=SUM($AB13:$AM13),\"ok\",\"check\"))","v":""},null,null,null,{"$f":"IF($AI$2=\"【長期（部分払なし）】\",IF(AND($J13=SUM($M13:$S13),$J13=SUM($T13:$AA13)),\"ok\",\"check\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,0,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,"確認用関数","CK数","",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"①支出金額合計額と収入金額合計額が一致していません。","臨財債除く",{"$f":"IF(AP5<3,IF(AV50=1,\"\",IF(COUNTIF(J100:AM100,\"ok\")=COUNTA(J100:AM100),\"\",\"確認\")),\"\")","v":""},1,"",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"証書借入又は証券発行","②基準充当率が入力されておりません。(「J38」セル)","臨財債除く",{"$f":"IF(AP5<3,IF(OR(J38=\"\",J38=0),IF(M38=0,\"確認\",\"\"),\"\"),\"\")","v":"確認"},2,"",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"証書借入","③起債に関する予算の定め欄の利率の但し書きの有無が入力されておりません。(「Y43」セル)",null,{"$f":"IF(OR(Y43 = \"\",Y43 = 0),\"確認\",\"\")","v":"確認"},3,"",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"普通貸借又は証券発行","④起債対象事務費欄が入力されておりません。","臨財債除く",{"$f":"IF(AP5<3,IF(AND(Z37 = \"\",Z38 = \"\"),\"確認\",\"\"),\"\")","v":"確認"},4,"",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"⑤借入時充当率が、基準充当率を超過しています。","臨財債除く",{"$f":"IFERROR(IF(AP5<3,IF(AND(J37>J38,J38>0),\"確認\",\"\"),\"\"),\"確認\")","v":""},5,"",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"■該当なし（事務費を起債対象とせず）","⑥支出金額と支出状況欄の金額計が一致していません。","長期（部分払あり）のみ",{"$f":"IF(AP5=1,IF(COUNTIF(AT12:AT22,\"ok\")=COUNTA(AT12:AT22),\"\",\"確認\"),\"\")","v":""},6,"",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"■工事費の5.0％以内の額","⑦支出状況欄の基準月（貸付実行月）を入力してください。(「AF11」セル)","長期（部分払あり）のみ",{"$f":"IF(AP5=1,IF(AF11= \"\", \"確認\",\"\"),\"\")","v":""},7,"",null,null,null,""]
[null,"計",null,null,null,null,null,null,"Ａ",{"$f":"SUM(J12:L21)","v":0},null,null,{"$f":"SUM(M12:O21)","v":0},null,null,{"$f":"SUM(P12:S21)","v":0},null,null,null,{"$f":"SUM(T12:W21)","v":0},null,null,null,{"$f":"SUM(X12:AA21)","v":0},null,null,null,{"$f":"SUM(AB12:AE21)","v":0},null,null,null,{"$f":"SUM(AF12:AI21)","v":0},null,null,null,{"$f":"SUM(AJ12:AM21)","v":0},null,null,null,null,"■廃止前の補助基準により定められていた計算方法により算出した範囲内の額","⑧収入金額と収入状況欄の金額計が一致していません。","長期（部分払あり）のみ",{"$f":"IF(AP5=1,IF(COUNTIF(AT25:AT36,\"ok\")=COUNTA(AT25:AT36),\"\",IF(AV50=1,\"\",\"確認\")),\"\")","v":""},8,"",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,{"$f":"IF(OR(SUM(I45:K48)<SUM(M45:O48),SUM(I45:K48)=0),\"確認\",\"\")","v":"確認"},9]
[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":"IF(AF11=\"\",\"\",AF11)","v":""},null,"月",null,{"$f":"AJ11","v":0},null,"月以降",null,null,null,"⑩起債同意欄の「うち本件借入分」が「起債欄（本債）」より小額となっています。","臨財債除く",{"$f":"IF(AP5<3,IF(OR(J29>SUM(M45:O48),J43=0),\"確認\",\"\"),\"\")","v":"確認"},10,null,null,null,null,null,null,null,{"$f":"COUNTIFS(H12:H21,\">0\")","v":0}]
[null,"控除財源","国庫支出金",null,null,null,null,null,"Ｂ",{"$f":"SUM(T25:AA25)","v":0},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,"■該当なし（事務費を起債対象とせず）","⑪起債に関する予算の定め欄の「起債限度額（うち財政融資資金）」が「起債欄（本債）」より小額となっています。","臨財債除く",{"$f":"IF(AP5<3,IF(J29>J43,\"確認\",\"\"),\"\")","v":""},11,{"$f":"IF($AI$2<>\"【長期（部分払あり）】\",\"\",IF($J25=SUM($AB25:$AM25),\"ok\",\"check\"))","v":""},null,null,null,{"$f":"IF($AI$2=\"【長期（部分払なし）】\",IF(AND($J25=SUM($M25:$S25),$J25=SUM($T25:$AA25)),\"ok\",\"check\"),\"\")","v":""},null,null,{"$f":"COUNTIFS(J12:J21,\"<>0\")","v":0}]
[null,null,"都道府県支出金",null,null,null,null,null,"Ｃ",{"$f":"SUM(T26:AA26)","v":0},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,{"$f":"IF(AND(COUNTA(E45:G48)>0,COUNTA(W45:AD48)=0),\"確認\",\"\")","v":""},12,{"$f":"IF($AI$2<>\"【長期（部分払あり）】\",\"\",IF($J26=SUM($AB26:$AM26),\"ok\",\"check\"))","v":""},null,null,null,{"$f":"IF($AI$2=\"【長期（部分払なし）】\",IF(AND($J26=SUM($M26:$S26),$J26=SUM($T26:$AA26)),\"ok\",\"check\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,"Ｄ",{"$f":"SUM(T27:AA27)","v":0},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,"■設計監督費（外部委託せず）について、全体事業費の2.75％以内の額","⑬計画期間未入力。または、計画期間が複数年にわたっているが、前年度以前施行済事業、翌年度以降計画事業双方とも未入力です。","臨財債除く",{"$f":"IF(AP5<3,IF(AND(AD4=0,AJ4=0),\"確認\",IF(AND(AB4=AH4,AD4=AJ4),\"\",IF(AND(X6=0,AF6=0),\"確認\",\"\"))),\"\")","v":"確認"},13,"",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"■設計監督費以外の事務費について、全体事業費の2.75％以内の額","⑭控除財源がある場合は、財源内訳内容欄に、具体的な交付金名等を入力ください。","臨財債除く",{"$f":"IF(AP5<3,IF(COUNTIF(J25:L28,\">0\")<>COUNTA(E25:H28),\"確認\",\"\"),\"\")","v":""},14,"",null,null,null,""]
[null,"起債","財政融資資金",null,"本債",null,null,null,"Ｆ",0,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,"■設計監督費（外部委託）の実所要額、及びそれ以外の事務費について全体事業費の2.75％以内の額","⑮事業完成（見込）日を入力してください。","臨財債除く",{"$f":"IF(AP5<3,IF(COUNTIFS(H12:H21,\">0\")<COUNTIFS(J12:J21,\"<>0\"),\"確認\",\"\"),\"\")","v":""},15,"",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"■設計監督費（外部委託せず）及びそれ以外の事務費について、それぞれ全体事業費の2.75％以内の額　","⑯借入申込み償還期限年数が起債同意欄の償還年限を超えています。",null,{"$f":"IF(MAX(Q45:R48)<AI45,\"確認\",\"\")","v":""},16,"","チェックボックスON/OFF状況（VBA用）",null,null,""]
[null,null,"その他",null,null,null,null,null,"Ｈ",0,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,"■設計監督費と合わせて全体事業費の6.0％以内の額（水道、港湾、下水道）","⑰借入申込み据置期間年数が起債同意欄のうち据置期間を超えています。",null,{"$f":"IF(MAX(T45:U48)<AI46,\"確認\",\"\")","v":""},17,"",false,1,"「議決等年月日」議決済",""]
[null,"一般財源",null,null,null,null,null,null,null,0,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,18,"",false,2,"「議決等年月日」議決予定",""]
[null,null,null,null,null,null,null,null,null,0,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,19,"",false,3,"「議決等年月日」専決済",""]
[null,null,null,null,null,null,null,null,null,0,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,20,"",false,4,"「議決等年月日」専決予定",""]
[null,"一時立替金",null,null,null,null,null,null,null,0,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,21,"",false,5,"「起債の方法」証書借入",""]
[null,"計",null,null,null,null,null,null,null,{"$f":"SUM(J25:L35)","v":0},null,null,{"$f":"SUM(M25:O35)","v":0},null,null,{"$f":"SUM(P25:S35)","v":0},null,null,null,{"$f":"SUM(T25:W35)","v":0},null,null,null,{"$f":"SUM(X25:AA35)","v":0},null,null,null,{"$f":"SUM(AB25:AE35)","v":0},null,null,null,{"$f":"SUM(AF25:AI35)","v":0},null,null,null,{"$f":"SUM(AJ25:AM35)","v":0},null,null,null,null,"有",null,null,null,22,"",false,6,"「起債の方法」証券発行",""]
[null,"借入時充当率((Ｆ+Ｇ+Ｈ)/(Ａ-Ｂ-Ｃ-Ｄ-Ｅ)×100)",null,null,null,null,null,null,"(％)",{"$f":"IF(J36>0,(J29+J30+J31)/(J22-J25-J26-J27-J28),0)","v":0},null,null,{"$f":"IF(M36>0,(M29+M30+M31)/(M22-M25-M26-M27-M28),\"\")","v":""},null,null,{"$f":"IF(P36>0,(P29+P30+P31)/(P22-P25-P26-P27-P28),\"\")","v":""},null,null,null,"起債対象\n事 務 費",null,null,"（補助事業分）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"無",null,null,null,23,null,false,7,"「起債の方法」その他"]
[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,24,null,false,8,"「起債の方法」普通貸借","⑳=IF(AP5=2,IF(COUNTIF(AX12:AX22,\"ok\")=COUNTA(AX12:AX22),\"\",\"確認\"),\"\")⇐不要"]
[null,"起債に関する\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,null,null,"（□",null,null,null,25,null,false,9,"「償還の方法」年賦","㉑=IF(AP5=2,IF(COUNTIF(AX25:AX36,\"ok\")=COUNTA(AX25:AX36),\"\",\"確認\"),\"\")⇐不要"]
[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,26,null,false,10,"「償還の方法」融資条件による"]
[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,27,null,false,11,"「償還の方法」償還期間"]
[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,28,null,false,12,"「償還の方法」半年賦"]
[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,29,null,false,13,"「償還の方法」元利均等"]
[null,"起債同意\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,null,null,null,null,null,"（予定）",null,null,null,30,null,false,14,"「償還の方法」その他"]
[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,"㉛","議決承認",false,15,"「償還の方法」元金均等"]
[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,"㉝","償還の方法"]
[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,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,{"$f":"IF(AP5=1,IF(AV51>0,IF(AV53=AF36,1,9),9),9)","v":9},"  1:一致　9:不一致"]
[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,"「繰越財源」文字有無",{"$f":"COUNTIF($B$33:$D$34,LEFT(AV49,4))","v":0}]
[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,"「繰越財源」文字のある行",{"$f":"MATCH(LEFT(AV49,4),B:B,0)","v":{"$error":"#N/A"}}]
[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,"繰越額列の値",{"$f":"INDIRECT(ADDRESS(AV52,24))","v":{"$error":"#N/A"}}]
[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,"1．用紙の大きさは、日本産業規格Ａ列４とする。"]
[null,null,"2．事業費内訳には、起債対象となる費用のみ記入する。",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,"3．収支金額、収支状況の各計は一致する。"]
[null,null,"4．収支状況は、借入月を「　月」欄に記入する。"]
[null,null,"5．起債前貸等の場合で、数ヶ月分の支出のために資金を借り入れる場合は、「　月」欄を「○～○月まで」として記入する。"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))","v":"様式1"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T61<>\"\",AO63,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"ver.R5.06"]
[]
[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,{"$f":"AO64&AO65&AO66","v":""}]
[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,{"$f":"LEFT(D64,1)&LEFT(D65,1)&LEFT(D66,1)&LEFT(D67,1)&LEFT(D68,1)&LEFT(D69,1)","v":""}]
[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,{"$f":"LEFT(D70,1)&LEFT(D71,1)&LEFT(D72,1)&LEFT(D73,1)&LEFT(D74,1)&LEFT(D75,1)&LEFT(D76,1)&LEFT(D77,1)&LEFT(D78,1)&LEFT(D79,1)","v":""}]
[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,{"$f":"LEFT(D80,1)&LEFT(D81,1)&LEFT(D82,1)&LEFT(D83,1)&LEFT(D84,1)&LEFT(D85,1)","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"確認用メッセージ(財務局・財務事務所確認用)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J22=J36,\"ok\",\"NG\")","v":"ok"},null,null,{"$f":"IF(M22=M36,\"ok\",\"NG\")","v":"ok"},null,null,{"$f":"IF(P22=P36,\"ok\",\"NG\")","v":"ok"},null,null,{"$f":"IF(S22=S36,\"ok\",\"NG\")","v":"ok"},"ok",null,null,"ok","ok",null,null,"ok",{"$f":"IF(AB22=AB36,\"ok\",\"NG\")","v":"ok"},null,null,{"$f":"IF(AE22=AE36,\"ok\",\"NG\")","v":"ok"},"ok",null,null,"ok","ok",null,null,"ok"]
[]
[]
[]
[]
[null,null,null,null,null," "]

{"sheet":"end","index":4,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"_xlfn.SHEETS(start:end!AR3)-2","v":1}]

{"sheet":"総括表","index":5,"n_rows":65,"n_cols":49,"rows_kept":65,"cut":false,"hidden":false,"merged":[[49,1,52,38],[3,35,3,36],[3,37,3,38],[4,1,4,2],[4,3,4,22],[4,23,4,30],[4,31,4,38],[0,29,0,38],[3,1,3,2],[3,3,3,22],[3,23,3,26],[3,27,3,28],[3,29,3,30],[3,31,3,32],[3,33,3,34],[1,6,1,25],[2,6,2,26],[1,34,1,38],[10,15,10,18],[10,19,10,22],[10,23,10,26],[10,27,10,30],[5,1,8,2],[5,3,8,22],[5,23,8,30],[5,31,8,38],[9,1,10,4],[9,5,10,8],[9,9,9,26],[9,27,9,38],[10,9,10,11],[10,12,10,14],[10,35,10,36],[10,37,10,38],[10,31,10,32],[10,33,10,34],[11,31,11,34],[11,35,11,38],[12,1,12,4],[12,5,12,8],[12,9,12,11],[12,12,12,14],[12,15,12,18],[12,19,12,22],[12,23,12,26],[12,27,12,30],[12,31,12,34],[12,35,12,38],[11,1,11,4],[11,5,11,8],[11,9,11,11],[11,12,11,14],[11,15,11,18],[11,19,11,22],[11,23,11,26],[11,27,11,30],[13,35,13,38],[14,1,14,4],[14,5,14,8],[14,9,14,11],[14,12,14,14],[14,15,14,18],[14,19,14,22],[14,23,14,26],[14,27,14,30],[14,31,14,34],[14,35,14,38],[13,1,13,4],[13,5,13,8],[13,9,13,11],[13,12,13,14],[13,15,13,18],[13,19,13,22],[13,23,13,26],[13,27,13,30],[13,31,13,34],[15,35,15,38],[16,1,16,4],[16,5,16,8],[16,9,16,11],[16,12,16,14],[16,15,16,18],[16,19,16,22],[16,23,16,26],[16,27,16,30],[16,31,16,34],[16,35,16,38],[15,1,15,4],[15,5,15,8],[15,9,15,11],[15,12,15,14],[15,15,15,18],[15,19,15,22],[15,23,15,26],[15,27,15,30],[15,31,15,34],[17,35,17,38],[18,1,18,4],[18,5,18,8],[18,9,18,11],[18,12,18,14],[18,15,18,18],[18,19,18,22],[18,23,18,26],[18,27,18,30],[18,31,18,34],[18,35,18,38],[17,1,17,4],[17,5,17,8],[17,9,17,11],[17,12,17,14],[17,15,17,18],[17,19,17,22],[17,23,17,26],[17,27,17,30],[17,31,17,34],[19,35,19,38],[20,1,20,4],[20,5,20,8],[20,9,20,11],[20,12,20,14],[20,15,20,18],[20,19,20,22],[20,23,20,26],[20,27,20,30],[20,31,20,34],[20,35,20,38],[19,1,19,4],[19,5,19,8],[19,9,19,11],[19,12,19,14],[19,15,19,18],[19,19,19,22],[19,23,19,26],[19,27,19,30],[19,31,19,34],[23,35,23,36],[23,37,23,38],[21,35,21,38],[22,1,22,8],[22,9,22,26],[22,27,22,38],[23,1,23,3],[23,4,23,8],[23,9,23,11],[23,12,23,14],[23,15,23,18],[23,19,23,22],[21,1,21,7],[21,9,21,11],[21,12,21,14],[21,15,21,18],[21,19,21,22],[21,23,21,26],[21,27,21,30],[21,31,21,34],[23,33,23,34],[24,1,27,1],[24,2,24,3],[24,4,24,7],[24,9,24,11],[24,12,24,14],[24,15,24,18],[23,23,23,26],[23,27,23,30],[23,31,23,32],[24,19,24,22],[24,23,24,26],[24,27,24,30],[24,31,24,34],[26,2,26,3],[26,4,26,7],[26,9,26,11],[26,12,26,14],[26,15,26,18],[26,19,26,22],[26,23,26,26],[26,27,26,30],[26,31,26,34],[24,35,24,38],[25,2,25,3],[25,4,25,7],[25,9,25,11],[25,12,25,14],[25,15,25,18],[25,19,25,22],[25,23,25,26],[25,27,25,30],[25,31,25,34],[25,35,25,38],[30,35,30,38],[26,35,26,38],[27,2,27,3],[27,4,27,7],[27,9,27,11],[27,12,27,14],[27,15,27,18],[28,15,28,18],[28,19,28,22],[28,23,28,26],[28,27,28,30],[28,31,28,34],[28,35,28,38],[27,19,27,22],[27,23,27,26],[27,27,27,30],[27,31,27,34],[27,35,27,38],[28,1,30,1],[31,27,31,30],[29,27,29,30],[29,31,29,34],[29,35,29,38],[30,2,30,3],[30,4,30,7],[30,9,30,11],[30,12,30,14],[30,15,30,18],[30,19,30,22],[30,23,30,26],[29,4,29,7],[29,9,29,11],[29,12,29,14],[29,15,29,18],[29,19,29,22],[29,23,29,26],[28,2,29,3],[28,4,28,7],[28,9,28,11],[28,12,28,14],[30,27,30,30],[30,31,30,34],[31,31,31,34],[31,35,31,38],[32,1,32,3],[32,4,32,8],[32,9,32,11],[32,12,32,14],[32,15,32,18],[32,19,32,22],[32,23,32,26],[32,27,32,30],[32,31,32,34],[32,35,32,38],[31,1,31,3],[31,4,31,8],[31,9,31,11],[31,12,31,14],[31,15,31,18],[31,19,31,22],[31,23,31,26],[33,35,33,38],[34,1,34,3],[34,4,34,8],[34,9,34,11],[34,12,34,14],[34,15,34,18],[34,19,34,22],[34,23,34,26],[34,27,34,30],[34,31,34,34],[34,35,34,38],[33,1,33,3],[33,4,33,8],[33,9,33,11],[33,12,33,14],[33,15,33,18],[33,19,33,22],[33,23,33,26],[33,27,33,30],[33,31,33,34],[38,1,42,2],[38,3,38,4],[38,7,38,8],[38,9,38,10],[38,11,38,17],[38,18,38,21],[38,22,38,25],[39,3,39,7],[39,8,39,12],[39,13,39,18],[39,19,39,24],[39,25,39,38],[40,3,42,7],[40,9,40,11],[40,21,40,22],[41,9,41,11],[41,32,41,33],[41,34,41,37],[42,9,42,11],[42,16,42,17],[42,26,42,28],[35,31,35,34],[35,35,35,38],[36,1,36,7],[36,9,36,11],[36,12,36,14],[36,15,36,18],[36,19,37,21],[36,22,36,24],[36,25,36,38],[37,1,37,7],[37,9,37,11],[37,12,37,14],[37,15,37,18],[37,22,37,24],[37,25,37,38],[35,1,35,8],[35,9,35,11],[35,12,35,14],[35,15,35,18],[35,19,35,22],[35,23,35,26],[35,27,35,30],[44,19,44,20],[44,22,44,29],[44,31,44,33],[43,4,43,7],[43,8,43,11],[43,12,43,15],[43,16,43,18],[43,19,43,21],[43,22,43,29],[43,30,43,38],[43,1,47,2],[45,4,45,6],[45,8,45,10],[45,12,45,14],[45,16,45,17],[47,4,47,6],[47,8,47,10],[47,12,47,14],[47,16,47,17],[44,4,44,6],[44,8,44,10],[44,12,44,14],[44,16,44,17],[47,22,47,29],[45,19,45,20],[45,22,45,29],[46,4,46,6],[46,8,46,10],[46,12,46,14],[46,16,46,17],[46,19,46,20],[46,22,46,29],[47,19,47,20],[53,27,53,38],[63,9,63,11],[63,12,63,14],[63,15,63,18],[63,19,63,22],[63,23,63,26],[63,27,63,30],[63,31,63,34],[63,35,63,38]]}
[null,"別紙第13号書式"]
[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,null,null,null,null,null,"翌年度以降計画事業",null,null,null,null,null,null,null,null,{"$f":"MAX(start:end!D12:D21,start:end!F12:G21)","v":"00:00:00"},0,{"$f":"MAX(start:end!F12:F21,start:end!H12:I21)","v":"00:00:00"},null,null,0]
[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,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,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,{"$f":"_xlfn.SHEETS(start:end!AP3)-2","v":1},null,{"$f":"_xlfn.SHEETS(start:end!AR3)-2","v":1}]
[]
[null,"事　業　費　内　訳",null,null,null,"事業開始日～\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,null,null,null,null,null,null,{"$f":"COUNTA(start:end!B4)","v":1},null,{"$f":"COUNTA(start:end!D4)","v":0}]
[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":"IF(様式1!AF11=\"\",\"\",様式1!AF11)","v":""},null,"月",null,{"$f":"IF(AF11=\"\",\"\",IF(AF11>=12,1,AF11+1))","v":""},null,"月以降",null,null,null,null,null,null,null,"横計CHECK計算式入力セル"]
[null,"事業件数",null,null,null,0,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,{"$f":"IF($AI$2<>\"【起前】\",\"\",IF($J12=SUM($AB12:$AM12),\"ok\",\"check\"))","v":""}]
[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,"有","㉚までは関数㉛からは、VBAで判定している。",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AP5<3,IF(COUNTIF(J64:AM64,\"ok\")=COUNTA(J64:AM64),\"\",\"確認\"),\"\")","v":""},1,""]
[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,{"$f":"IF(AP5<3,IF(OR(J38=\"\",J38=0),IF(M38=0,\"確認\",\"\"),\"\"),\"\")","v":"確認"},2,""]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(T17:AA17)","v":0},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,{"$f":"IF(OR(Y43 = \"\",Y43 = 0),\"確認\",\"\")","v":"確認"},3,""]
[null,null,null,null,null,null,null,null,null,0,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,{"$f":"IF(AP5<3,IF(AND(Z37 = \"\",Z38 = \"\"),\"確認\",\"\"),\"\")","v":"確認"},4,""]
[null,null,null,null,null,null,null,null,null,0,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,{"$f":"IF(AP5<3,IF(AND(J37>J38,J38>0),\"確認\",\"\"),\"\")","v":""},5,""]
[null,null,null,null,null,null,null,null,null,0,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,{"$f":"IF(AP5=1,IF(C51 = \"\", \"確認\",\"\"),\"\")","v":""},6,""]
[null,null,null,null,null,null,null,null,null,0,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,"■工事費の5.0％以内の額",null,null,{"$f":"IF(AP5=1,IF(COUNTIF(AT12:AT22,\"ok\")=COUNTA(AT12:AT22),\"\",\"確認\"),\"\")","v":""},7,""]
[null,"計",null,null,null,null,null,null,"Ａ",{"$f":"SUM(start:end!J22)","v":0},null,null,{"$f":"SUM(start:end!M22)","v":0},null,null,{"$f":"SUM(start:end!P22)","v":0},null,null,null,{"$f":"SUM(start:end!T22)","v":0},null,null,null,{"$f":"SUM(start:end!X22)","v":0},null,null,null,{"$f":"SUM(start:end!AB22)","v":0},null,null,null,{"$f":"SUM(start:end!AF22)","v":0},null,null,null,{"$f":"SUM(start:end!AJ22)","v":0},null,null,null,null,"■廃止前の補助基準により定められていた計算方法により算出した範囲内の額",null,null,{"$f":"IF(AP5=1,IF(AF11= \"\", \"確認\",\"\"),\"\")","v":""},8,""]
[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,{"$f":"IF(AP5=1,IF(COUNTIF(AT25:AT36,\"ok\")=COUNTA(AT25:AT36),\"\",\"確認\"),\"\")","v":""},9]
[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":"IF(AF11=\"\",\"\",AF11)","v":""},null,"月",null,{"$f":"AJ11","v":""},null,"月以降",null,null,null,null,null,{"$f":"IF(OR(SUM(I45:K48)<SUM(M45:O48),SUM(M45:O48)=0),\"確認\",\"\")","v":"確認"},10]
[null,"控除財源","国庫支出金",null,null,null,null,null,"Ｂ",{"$f":"SUM(start:end!J25:L25)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(start:end!T25:W25)","v":0},null,{"$f":"SUM(start:end!V20:X20)","v":0},null,{"$f":"SUM(start:end!X25:AA25)","v":0},null,{"$f":"SUM(start:end!Z20:AB20)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"■該当なし（事務費を起債対象とせず）",null,null,{"$f":"IF(AP5<3,IF(OR(J29>SUM(M45:O48),J43=0),\"確認\",\"\"),\"\")","v":"確認"},11,{"$f":"IF($AI$2<>\"【起前】\",\"\",IF($J25=SUM($AB25:$AM25),\"ok\",\"check\"))","v":""}]
[null,null,"都道府県支出金",null,null,null,null,null,"Ｃ",{"$f":"SUM(start:end!J26:L26)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(start:end!T26:W26)","v":0},null,{"$f":"SUM(start:end!V21:X21)","v":0},null,{"$f":"SUM(start:end!X26:AA26)","v":0},null,{"$f":"SUM(start:end!Z21:AB21)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"■設計監督費（外部委託）について、実所要額",null,null,{"$f":"IF(AP5<3,IF(J29>J43,\"確認\",\"\"),\"\")","v":""},12,""]
[null,null,null,null,null,null,null,null,"Ｄ",{"$f":"SUM(start:end!J27:L27)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(start:end!T27:W27)","v":0},null,{"$f":"SUM(start:end!V22:X22)","v":0},null,{"$f":"SUM(start:end!X27:AA27)","v":0},null,{"$f":"SUM(start:end!Z22:AB22)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"■設計監督費（外部委託せず）について、全体事業費の2.75％以内の額",null,null,{"$f":"IF(AP5=2,IF(AND(COUNTIF(B12:E21,\"*負担金*\")>0,B50=\"\"),\"確認\",\"\"),\"\")","v":""},13,""]
[null,null,null,null,null,null,null,null,"Ｅ",{"$f":"SUM(start:end!J28:L28)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(start:end!T28:W28)","v":0},null,{"$f":"SUM(start:end!V23:X23)","v":0},null,{"$f":"SUM(start:end!X28:AA28)","v":0},null,{"$f":"SUM(start:end!Z23:AB23)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"■設計監督費以外の事務費について、全体事業費の2.75％以内の額",null,null,{"$f":"IF(AND(COUNTA(E45:G48)>0,COUNTA(W45:AD48)=0),\"確認\",\"\")","v":""},14,""]
[null,"起債","財政融資資金",null,"本債",null,null,null,"Ｆ",{"$f":"SUM(start:end!J29:L29)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(start:end!T29:W29)","v":0},null,{"$f":"SUM(start:end!V24:X24)","v":0},null,{"$f":"SUM(start:end!X29:AA29)","v":0},null,{"$f":"SUM(start:end!Z24:AB24)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"■設計監督費（外部委託）の実所要額、及びそれ以外の事務費について全体事業費の2.75％以内の額",null,null,{"$f":"IF(AP5<3,IF(AND(AD4=0,AJ4=0),\"確認\",IF(AND(AB4=AH4,AD4=AJ4),\"\",IF(AND(X6=0,AF6=0),\"確認\",\"\"))),\"\")","v":"確認"},15,""]
[null,null,null,null,null,null,null,null,"Ｇ",{"$f":"SUM(start:end!J30:L30)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(start:end!T30:W30)","v":0},null,{"$f":"SUM(start:end!V25:X25)","v":0},null,{"$f":"SUM(start:end!X30:AA30)","v":0},null,{"$f":"SUM(start:end!Z25:AB25)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"■設計監督費（外部委託せず）及びそれ以外の事務費について、それぞれ全体事業費の2.75％以内の額　",null,null,{"$f":"IF(AP5<3,IF(COUNTIF(J25:L28,\">0\")<>COUNTA(E25:H28),\"確認\",\"\"),\"\")","v":""},16,"","チェックボックスON/OFF状況"]
[null,null,"その他",null,null,null,null,null,"Ｈ",{"$f":"SUM(start:end!J31:L31)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(start:end!T31:W31)","v":0},null,{"$f":"SUM(start:end!V26:X26)","v":0},null,{"$f":"SUM(start:end!X31:AA31)","v":0},null,{"$f":"SUM(start:end!Z26:AB26)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"■設計監督費と合わせて全体事業費の6.0％以内の額（水道、港湾、下水道）",null,null,null,17,"",false,1,"「議決等年月日」議決済"]
[null,"一般財源",null,null,null,null,null,null,null,{"$f":"SUM(start:end!J32:L32)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(start:end!T32:W32)","v":0},null,{"$f":"SUM(start:end!V27:X27)","v":0},null,{"$f":"SUM(start:end!X32:AA32)","v":0},null,{"$f":"SUM(start:end!Z27:AB27)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"■適正必要額（交通）",null,null,null,18,"",false,2,"「議決等年月日」議決予定"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(start:end!J33:L33)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(start:end!T33:W33)","v":0},null,{"$f":"SUM(start:end!V28:X28)","v":0},null,{"$f":"SUM(start:end!X33:AA33)","v":0},null,{"$f":"SUM(start:end!Z28:AB28)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"■補助事業と同様の計算方法により算出した範囲内の額（災害復旧）",null,null,null,19,"",false,3,"「議決等年月日」専決済"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(start:end!J34:L34)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(start:end!T34:W34)","v":0},null,{"$f":"SUM(start:end!V29:X29)","v":0},null,{"$f":"SUM(start:end!X34:AA34)","v":0},null,{"$f":"SUM(start:end!Z29:AB29)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"■実績等に応じ、必要な額",null,null,null,20,"",false,4,"「議決等年月日」専決予定"]
[null,"一時立替金",null,null,null,null,null,null,null,{"$f":"SUM(start:end!J35:L35)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(start:end!T35:W35)","v":0},null,{"$f":"SUM(start:end!V30:X30)","v":0},null,{"$f":"SUM(start:end!X35:AA35)","v":0},null,{"$f":"SUM(start:end!Z30:AB30)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,"",false,5,"「起債の方法」証書借入"]
[null,"計",null,null,null,null,null,null,null,{"$f":"SUM(start:end!J36:L36)","v":0},null,null,{"$f":"SUM(start:end!M36:O36)","v":0},null,null,{"$f":"SUM(start:end!P36:S36)","v":0},null,null,null,{"$f":"SUM(start:end!T36:W36)","v":0},null,{"$f":"SUM(start:end!V31:X31)","v":0},null,{"$f":"SUM(start:end!X36:AA36)","v":0},null,{"$f":"SUM(start:end!Z31:AB31)","v":0},null,{"$f":"SUM(start:end!AB36:AE36)","v":0},null,{"$f":"SUM(start:end!AD31:AF31)","v":0},null,{"$f":"SUM(start:end!AF36:AI36)","v":0},null,{"$f":"SUM(start:end!AH31:AJ31)","v":0},null,{"$f":"SUM(start:end!AJ36:AM36)","v":0},null,{"$f":"SUM(start:end!AL31:AN31)","v":0},null,null,"有",null,null,null,22,{"$f":"IF($AI$2<>\"【起前】\",\"\",IF($J36=SUM($AB36:$AM36),\"ok\",\"check\"))","v":""},false,6,"「起債の方法」証券発行"]
[null,"借入時充当率((Ｆ+Ｇ+Ｈ)/(Ａ-Ｂ-Ｃ-Ｄ-Ｅ)×100)",null,null,null,null,null,null,"(％)",{"$f":"IF(J36>0,(J29+J30+J31)/(J22-J25-J26-J27-J28),0)","v":0},null,null,{"$f":"IF(M36>0,(M29+M30+M31)/(M22-M25-M26-M27-M28),\"\")","v":""},null,null,{"$f":"IF(P36>0,(P29+P30+P31)/(P22-P25-P26-P27-P28),\"\")","v":""},null,null,null,"起債対象\n事 務 費",null,null,"（補助事業分）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"無",null,null,null,23,null,false,7,"「起債の方法」その他"]
[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,24,null,false,8,"「起債の方法」普通貸借"]
[null,"起債に関する\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,"専決予定）",null,null,null,"（□",null,null,null,25,null,false,9,"「償還の方法」年賦"]
[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,26,null,false,10,"「償還の方法」融資条件による"]
[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,27,null,false,11,"「償還の方法」償還期間"]
[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,28,null,false,12,"「償還の方法」半年賦"]
[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,29,null,false,13,"「償還の方法」元利均等"]
[null,"起債同意\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,null,null,null,null,null,"（予定）",null,null,null,30,null,false,14,"「償還の方法」その他"]
[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,false,15,"「償還の方法」元金均等"]
[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,"㉝"]
[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,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,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,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,null,"㊵"]
[null,"備考"]
[null,null,"1．用紙の大きさは、日本産業規格Ａ列４とする。"]
[null,null,"2．事業費内訳には、起債対象となる費用のみ記入する。",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,"3．収支金額、収支状況の各計は一致する。"]
[null,null,"4．収支状況は、借入月を「　月」欄に記入する。"]
[null,null,"5．起債前貸等の場合で、数ヶ月分の支出のために資金を借り入れる場合は、「　月」欄を「○～○月まで」として記入する。"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J22=J36,\"ok\",\"NG\")","v":"ok"},null,null,{"$f":"IF(M22=M36,\"ok\",\"NG\")","v":"ok"},null,null,{"$f":"IF(P22=P36,\"ok\",\"NG\")","v":"ok"},null,null,{"$f":"IF(S22=S36,\"ok\",\"NG\")","v":"ok"},{"$f":"IF(T22=T36,\"ok\",\"NG\")","v":"ok"},null,{"$f":"IF(V22=V36,\"ok\",\"NG\")","v":"ok"},null,{"$f":"IF(X22=X36,\"ok\",\"NG\")","v":"ok"},{"$f":"IF(Y22=Y36,\"ok\",\"NG\")","v":"ok"},null,null,{"$f":"IF(AB22=AB36,\"ok\",\"NG\")","v":"ok"},null,null,{"$f":"IF(AE22=AE36,\"ok\",\"NG\")","v":"ok"},{"$f":"IF(AF22=AF36,\"ok\",\"NG\")","v":"ok"},null,{"$f":"IF(AH22=AH36,\"ok\",\"NG\")","v":"ok"},null,{"$f":"IF(AJ22=AJ36,\"ok\",\"NG\")","v":"ok"},{"$f":"IF(AK22=AK36,\"ok\",\"NG\")","v":"ok"}]
[null,null,"様式1","長期等選択されていないのでチェックを行いませんでした。"]