{"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":58,"n_cols":9,"rows_kept":58,"cut":false,"hidden":true,"merged":[[21,1,21,2],[53,1,53,2],[54,4,57,4],[54,1,54,2],[55,1,55,2],[56,1,56,2],[57,1,57,2]]}
[null,"事業実施状況等調書欄以外で削除、消去してはいけないシート及びセル（調書シートのAO行からAW行は非表示としている）"]
[null,"・","入力規則で設定しているセルリストに使用","【事業実施状況等調書】全シート","AO行",null,"パスワード","マクロ","0000"]
[null,"・","各シートチェック判定用数式が入力","〃","AR15:AR46",null,null,"シート","0000"]
[null,"・","各シートチェック判定用数式が入力","〃","AT12:AT46"]
[null,"・","各シートチェック判定用数式が入力","〃","J88:AM88"]
[null,"・","選択中種類（1=起債前 2=長期 3=臨財債）","〃","AP5"]
[null,"・","確認項目出力コメント←下記「確認項目」とリンク","〃","AP15:35"]
[null,"・","「start」「end」間のシート枚数","endシート","C8"]
[null,"・","「start」「end」シート"]
[]
[null,"メンテナンスの手順"]
[null,"基本","シート「様式1」を修正"]
[null,"例）確認項目を減らす（削除する）場合"]
[null,"【事業実施状況等調書】は、「様式１」シートのみとしてください。"]
[null,"①","下記、「チェック項目名称【任意変更可】」より不要なコメント及び関数を消去","※なお、消去した項目の行は行削除しないこと。（行を詰めたいときは欄内を全てコピー・ペーストしてください。）"]
[null,"②","チェック項目名は、「使用上の留意点」シート「確認項目」欄および各シートへリンクされていますが、数式は「様式１」シートに代入する必要がありますので下記ボタンで代入してください。（個々に数式のみをコピーしても可）"]
[]
[]
[null,null,"標題"]
[null,null,"事業実施状況等調書","←この標題（各シートセルG2）であれば、印刷時チェックメッセージを出力"]
[]
[null,"チェック項目名称【任意変更可】",null,null,"入力してある関数（参考）"]
[null,"①","支出金額合計額と収入金額合計額が一致していません。","臨財債除く","=IF(AP5<3,IF(AV50=1,\"\",IF(COUNTIF(J88:AM88,\"ok\")=COUNTA(J88:AM88),\"\",\"確認\")),\"\")"]
[null,"②","基準充当率が入力されておりません。(「J38」セル)","臨財債除く","=IF(AP5<3,IF(OR(J38=\"\",J38=0),IF(M38=0,\"確認\",\"\"),\"\"),\"\")"]
[null,"③","起債に関する予算の定め欄の利率の但し書きの有無が入力されておりません。(「Y43」セル)",null,"=IF(OR(Y43 = \"\",Y43 = 0),\"確認\",\"\")"]
[null,"④","起債対象事務費欄が入力されておりません。","臨財債除く","=IF(AP5<3,IF(AND(Z37 = \"\",Z38 = \"\"),\"確認\",\"\"),\"\")"]
[null,"④'","事業区分が一致しておりません。","臨財債除く","=IF(AP5<3,IF(OR(AND(COUNTA(M12:O21)>0,Z37=\"\"),AND(COUNTA(M12:O21)=0,Z37<>\"\"),AND(COUNTA(P12:S21)>0,Z38=\"\"),AND(COUNTA(P12:S21)=0,Z38<>\"\")),\"確認\",\"\"),\"\")"]
[null,"⑤","借入時充当率が、基準充当率を超過しています。","臨財債除く","=IFERROR(IF(AP5<3,IF(AND(J37>J38,J38>0),\"確認\",\"\"),\"\"),\"確認\")"]
[null,"⑥","支出金額と支出状況欄の金額計が一致していません。","部分払のみ","=IF(AP5=1,IF(COUNTIF(AT12:AT22,\"ok\")=COUNTA(AT12:AT22),\"\",\"確認\"),\"\")"]
[null,"⑦","支出状況欄の基準月（貸付実行月）を入力してください。(「AF11」セル)","部分払のみ","=IF(AP5=1,IF(AF11= \"\", \"確認\",\"\"),\"\")"]
[null,"⑧","収入金額と収入状況欄の金額計が一致していません。","部分払のみ","=IF(AP5=1,IF(COUNTIF(AT25:AT36,\"ok\")=COUNTA(AT25:AT36),\"\",IF(AV50=1,\"\",\"確認\")),\"\")"]
[null,"⑨","起債同意欄の「同意（許可）額」が未入力または、「うち本件借入分」より小額となっています。",null,"=IF(OR(SUM(I45:K48)<SUM(M45:O48),SUM(M45:O48)=0),\"確認\",\"\")"]
[null,"⑩","起債同意欄の「うち本件借入分」が「起債欄（本債）」より小額となっています。","臨財債除く","=IF(AP5<3,IF(OR(J29>SUM(M45:O48),J43=0),\"確認\",\"\"),\"\")"]
[null,"⑪","起債に関する予算の定め欄の「起債限度額（うち財政融資資金）」が「起債欄（本債）」より小額となっています。","臨財債除く","=IF(AP5<3,IF(J29>J43,\"確認\",\"\"),\"\")"]
[null,"⑫","起債同意欄の「備考」には１次分、２次分、国の補正予算分等、同意許可の区分名を入力してください。",null,"=IF(AND(COUNTA(E45:G48)>0,COUNTA(W45:AD48)=0),\"確認\",\"\")"]
[null,"⑬","計画期間未入力。または、計画期間が複数年にわたっているが、前年度以前施行済事業、翌年度以降計画事業双方とも未入力です。","臨財債除く","=IF(AP5<3,IF(AND(AD4=0,AJ4=0),\"確認\",IF(AND(AB4=AH4,AD4=AJ4),\"\",IF(AND(X6=0,AF6=0),\"確認\",\"\"))),\"\")"]
[null,"⑭","控除財源がある場合は、財源内訳内容欄に、具体的な交付金名等を入力ください。","臨財債除く","=IF(AP5<3,IF(COUNTIF(J25:L28,\">0\")<>COUNTA(E25:G28),\"確認\",\"\"),\"\")"]
[null,"⑮","事業完成（見込）日を入力してください。","臨財債除く","=IF(AP5<3,IF(COUNTIFS(H12:H21,\">0\")<COUNTIFS(J12:J21,\"<>0\"),\"確認\",\"\"),\"\")"]
[null,"⑯","補助金等の年度が入力されておりません。","臨財債除く","=IF(AP5<3,IF(COUNTIF(J25:L26,\">0\")<>COUNTA(H25:H26),\"確認\",\"\"),\"\")"]
[null,"⑰","「償還期限」か「償還年限」が未入力、もしくは、「償還期限」又は「据置期間」が同意年数を超えています。",null,"=IF(OR(COUNTA(Q45:R48)=0,AI45=\"\",AND(COUNTA(T45:U48)=0,AI46<>0)),\"確認\",if(OR(Q45<AI45,AND(Q46<>\"\",Q46<AI45),AND(Q47<>\"\",Q47<AI45),AND(Q48<>\"\",Q48<AI45),AND(T45<>\"\",T45<AI46),AND(T46<>\"\",T46<AI46),AND(T47<>\"\",T47<AI46),AND(T48<>\"\",T48<AI46)),\"確認\",\"\"))"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"その他参考欄へ反映【任意変更可】",null,"セルの位置"]
[null,null,null,"Range(\"B50\")","起債前クリック時","①「前月まで」及び「借入月を含む3カ月間（借入月、翌月、翌々月）の支出額の合計"]
[null,null,null,"Range(\"F51\")"]
[null,null,null,"Range(\"B52\")"]
[null,null,null,"Range(\"R50\")"]

{"sheet":"使用上の留意点","index":1,"n_rows":73,"n_cols":17,"rows_kept":73,"cut":false,"hidden":false,"merged":[[72,1,72,17],[1,0,1,18],[4,1,4,18],[5,1,5,17]]}
[]
["使用上の留意点"]
[]
[]
[null,"１．本エクセルの『事業実施状況等調書』（様式）シートは、「部分払」「一括借入」「臨時財政対策債」のいずれの借入れにも使用可能です。\n　　はじめに、印刷指定範囲外にある「部分払」、「一括借入」、「臨時財政対策債」のいずれかのボタンを選択すると、入力が必要な項目（クリーム色で\n　　着色されたセル）が表示されます。なお、「リセット」ボタンをクリックすると入力項目がすべてクリアされますので注意ください。\n　　作成に当たっては、以下の点にご留意願います。\n　　　(1)　「start」及び「end」タブのシートは、削除しないで下さい。\n　　　(2)　シートを追加する場合には、「start」タブと「end」タブの間に挿入して下さい。\n　　　　　　（印刷指定範囲外にある「シートコピー（追加）」欄をクリックすると「start」タブと「end」タブの間に挿入されます。）\n　　　(3)　「行」・「列」の挿入・削除は行わないで下さい。"]
[null,"２．確認用チェックについて\n　　　よく確認いただく事項をチェックすることができます。\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,"⑥","支出金額と支出状況欄の金額計が一致していません。",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,null,null,null,null,null,null,null,null,null,null,null,"臨財債除く"]
[null,"⑰","「償還期限」か「償還年限」が未入力、もしくは、「償還期限」又は「据置期間」が同意年数を超えています。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"３．「総括表」について\n　　事業実施状況等調書を複数作成する必要がある場合、「総括表」の提出をお願いいたしておりますが、上記手順に沿って入力すると「総括表」タブのシートに\n　　①事業件数（「start」タブと「end」タブの間にあるシートの枚数）、②合計金額（「start」タブと「end」タブの間にあるシートの同位置にあるセルに入力されている金額を\n　　合計金額）が、自動的に反映されますのでご活用願います。\n　　　（注）同位置にあるセルに異なる財源内訳などの金額を入力している場合においても、単純合計されますのでご注意下さい。"]

{"sheet":"start","index":2,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,"①「前月まで」及び「借入月を含む3ヵ月間（借入月、翌月、翌々月）」の支出額の合計」"]

{"sheet":"様式1","index":3,"n_rows":88,"n_cols":49,"rows_kept":88,"cut":false,"hidden":false,"merged":[[49,1,52,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],[53,27,53,38],[62,3,62,38],[63,3,63,38],[60,12,60,17],[76,3,76,38],[77,3,77,38],[78,3,78,38],[79,3,79,38],[80,3,80,38],[81,3,81,38],[70,3,70,38],[71,3,71,38],[72,3,72,38],[73,3,73,38],[74,3,74,38],[75,3,75,38],[87,35,87,38],[82,3,82,38],[83,3,83,38],[84,3,84,38],[87,9,87,11],[87,12,87,14],[87,15,87,18],[87,19,87,22],[87,23,87,26],[87,27,87,30],[87,31,87,34],[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],[43,22,43,29],[43,30,43,38],[44,4,44,6],[44,8,44,10],[44,12,44,14],[44,16,44,17],[44,19,44,20],[44,22,44,29],[44,31,44,33],[43,1,47,2],[43,4,43,7],[43,8,43,11],[43,12,43,15],[43,16,43,18],[43,19,43,21],[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],[47,19,47,20],[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],[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],[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],[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],[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],[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],[24,35,24,38],[25,2,25,3],[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],[24,4,24,6],[25,4,25,6],[24,1,27,1],[24,2,24,3],[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],[23,4,23,6],[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,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],[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],[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],[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],[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],[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],[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],[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]]}
[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,null,null,null,null,null,null,"翌年度以降計画事業",null,null,null,null,null,null,null,null,null,0,{"$f":"AI2","v":0}]
[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,{"$f":"IF(AF11=\"\",\"\",IF(AF11>=12,1,AF11+1))","v":""},null,"月以降",null,null,null,null,null,null,null,"横計CHECK計算式入力セル"]
[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,null,{"$f":"IF($AP$5<>1,\"\",IF($J12=SUM($AB12:$AM12),\"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($AP$5<>1,\"\",IF($J13=SUM($AB13:$AM13),\"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,"確認用関数",null,{"$f":"IF($AP$5<>1,\"\",IF($J14=SUM($AB14:$AM14),\"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,"①支出金額合計額と収入金額合計額が一致していません。","臨財債除く",{"$f":"IF(AP5<3,IF(AV50=1,\"\",IF(COUNTIF(J88:AM88,\"ok\")=COUNTA(J88:AM88),\"\",\"確認\")),\"\")","v":""},1,{"$f":"IF($AP$5<>1,\"\",IF($J15=SUM($AB15:$AM15),\"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,"証書借入又は証券発行","②基準充当率が入力されておりません。(「J38」セル)","臨財債除く",{"$f":"IF(AP5<3,IF(OR(J38=\"\",J38=0),IF(M38=0,\"確認\",\"\"),\"\"),\"\")","v":"確認"},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,"証書借入","③起債に関する予算の定め欄の利率の但し書きの有無が入力されておりません。(「Y43」セル)",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,"普通貸借又は証券発行","④起債対象事務費欄が入力されておりません。","臨財債除く",{"$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,"④'事業区分が一致しておりません。","臨財債除く",{"$f":"IF(AP5<3,IF(OR(AND(COUNTA(M12:O21)>0,Z37=\"\"),AND(COUNTA(M12:O21)=0,Z37<>\"\"),AND(COUNTA(P12:S21)>0,Z38=\"\"),AND(COUNTA(P12:S21)=0,Z38<>\"\")),\"確認\",\"\"),\"\")","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,"■該当なし（事務費を起債対象とせず）","⑤借入時充当率が、基準充当率を超過しています。","臨財債除く",{"$f":"IFERROR(IF(AP5<3,IF(AND(J37>J38,J38>0),\"確認\",\"\"),\"\"),\"確認\")","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％以内の額","⑥支出金額と支出状況欄の金額計が一致していません。","部分払のみ",{"$f":"IF(AP5=1,IF(COUNTIF(AT12:AT22,\"ok\")=COUNTA(AT12:AT22),\"\",\"確認\"),\"\")","v":""},7,""]
[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,"■廃止前の補助基準により定められていた計算方法により算出した範囲内の額","⑦支出状況欄の基準月（貸付実行月）を入力してください。(「AF11」セル)","部分払のみ",{"$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,"■補助基準に定める範囲内の事務費","⑧収入金額と収入状況欄の金額計が一致していません。","部分払のみ",{"$f":"IF(AP5=1,IF(COUNTIF(AT25:AT36,\"ok\")=COUNTA(AT25:AT36),\"\",IF(AV50=1,\"\",\"確認\")),\"\")","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,{"$f":"IF(AF11=\"\",\"\",AF11)","v":""},null,"月",null,{"$f":"AJ11","v":""},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(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,null,"⑩起債同意欄の「うち本件借入分」が「起債欄（本債）」より小額となっています。","臨財債除く",{"$f":"IF(AP5<3,IF(OR(J29>SUM(M45:O48),J43=0),\"確認\",\"\"),\"\")","v":"確認"},11,{"$f":"IF($AP$5<>1,\"\",IF($J25=SUM($AB25:$AM25),\"ok\",\"check\"))","v":""}]
[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,"■該当なし（事務費を起債対象とせず）","⑪起債に関する予算の定め欄の「起債限度額（うち財政融資資金）」が「起債欄（本債）」より小額となっています。","臨財債除く",{"$f":"IF(AP5<3,IF(J29>J43,\"確認\",\"\"),\"\")","v":""},12,""]
[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(AND(COUNTA(E45:G48)>0,COUNTA(W45:AD48)=0),\"確認\",\"\")","v":""},13,""]
[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(AND(AD4=0,AJ4=0),\"確認\",IF(AND(AB4=AH4,AD4=AJ4),\"\",IF(AND(X6=0,AF6=0),\"確認\",\"\"))),\"\")","v":"確認"},14,""]
[null,"起債","財政融資資金",null,"本債",null,null,null,"Ｆ",{"$f":"SUM(T29:AA29)","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(COUNTIF(J25:L28,\">0\")<>COUNTA(E25:G28),\"確認\",\"\"),\"\")","v":""},15,""]
[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":""},16,"","チェックボックスON/OFF状況"]
[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:L26,\">0\")<>COUNTA(H25:H26),\"確認\",\"\"),\"\")","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,"■設計監督費と合わせて全体事業費の6.0％以内の額（水道、港湾、下水道）","⑰「償還期限」か「償還年限」が未入力、もしくは、「償還期限」又は「据置期間」が同意年数を超えています。",null,{"$f":"IF(OR(COUNTA(Q45:R48)=0,AI45=\"\",AND(COUNTA(T45:U48)=0,AI46<>0)),\"確認\",IF(OR(Q45<AI45,AND(Q46<>\"\",Q46<AI45),AND(Q47<>\"\",Q47<AI45),AND(Q48<>\"\",Q48<AI45),AND(T45<>\"\",T45<AI46),AND(T46<>\"\",T46<AI46),AND(T47<>\"\",T47<AI46),AND(T48<>\"\",T48<AI46)),\"確認\",\"\"))","v":"確認"},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,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,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,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,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,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,{"$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,"「繰越財源」文字有無",{"$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,"㊳",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,"1．用紙の大きさは、日本産業規格Ａ列４とする。"]
[null,null,"2．事業費内訳には、起債対象となる費用のみ記入する。"]
[null,null,"3．収支金額、収支状況の各計は一致する。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"　　　　　令和　年　月　日"]
[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<>\"\",AO64,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"ver.R3.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,null,null,null,null,{"$f":"AO65&AO66&AO67","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,{"$f":"IF(J$36=J$22,\"ok\",\"NG\")","v":"ok"},null,null,{"$f":"IF(M$36=M$22,\"ok\",\"NG\")","v":"ok"},null,null,{"$f":"IF(P$36=P$22,\"ok\",\"NG\")","v":"ok"},null,null,null,{"$f":"IF(T$36=T$22,\"ok\",\"NG\")","v":"ok"},null,null,null,{"$f":"IF(X$36=X$22,\"ok\",\"NG\")","v":"ok"},null,null,null,{"$f":"IF(AB$36=AB$22,\"ok\",\"NG\")","v":"ok"},null,null,null,{"$f":"IF(AF$36=AF$22,\"ok\",\"NG\")","v":"ok"},null,null,null,{"$f":"IF(AJ$36=AJ$22,\"ok\",\"NG\")","v":"ok"}]

{"sheet":"end","index":4,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"シート総数-5","v":1}]

{"sheet":"総括表","index":5,"n_rows":65,"n_cols":49,"rows_kept":65,"cut":false,"hidden":false,"merged":[[11,7,15,8],[11,6,15,6],[11,5,15,5],[49,1,52,38],[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],[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],[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],[43,22,43,29],[43,30,43,38],[44,4,44,6],[44,8,44,10],[44,12,44,14],[44,16,44,17],[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],[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],[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],[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],[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],[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],[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],[24,35,24,38],[25,2,25,3],[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],[24,4,24,6],[25,4,25,6],[24,1,27,1],[24,2,24,3],[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],[23,4,23,6],[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,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],[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],[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],[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,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],[11,1,15,4],[11,31,11,34],[11,35,11,38],[12,9,12,11],[12,12,12,14],[13,35,13,38],[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,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],[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,9,11,11],[11,12,11,14],[11,15,11,18],[11,19,11,22],[11,23,11,26],[11,27,11,30],[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],[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]]}
[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,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,"事業開始日～\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,{"$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,{"$f":"\"事業本数 \" & _xlfn.SHEETS()-5 & \" 本\"","v":"事業本数 1 本"},null,null,null,{"$f":"IF(COUNTA(start:end!F12:F21)>0,MIN(start:end!F12:F21),\"開始日\n未入力\" )","v":"開始日\n未入力"},"～",{"$f":"IF(COUNTA(start:end!H12:I21)>0,MAX(start:end!H12:I21),\"完成見込日\n未入力\" )","v":"完成見込日\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,{"$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,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,{"$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,{"$f":"SUM(start:end!M25:O25)","v":0},null,null,{"$f":"SUM(start:end!P25:S25)","v":0},null,{"$f":"SUM(start:end!R20:T20)","v":0},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,{"$f":"SUM(start:end!AB25:AE25)","v":0},null,{"$f":"SUM(start:end!AD20:AF20)","v":0},null,{"$f":"SUM(start:end!AF25:AI25)","v":0},null,{"$f":"SUM(start:end!AH20:AJ20)","v":0},null,{"$f":"SUM(start:end!AJ25:AM25)","v":0},null,{"$f":"SUM(start:end!AL20:AN20)","v":0},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,{"$f":"SUM(start:end!M26:O26)","v":0},null,null,{"$f":"SUM(start:end!P26:S26)","v":0},null,{"$f":"SUM(start:end!R21:T21)","v":0},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,{"$f":"SUM(start:end!AB26:AE26)","v":0},null,{"$f":"SUM(start:end!AD21:AF21)","v":0},null,{"$f":"SUM(start:end!AF26:AI26)","v":0},null,{"$f":"SUM(start:end!AH21:AJ21)","v":0},null,{"$f":"SUM(start:end!AJ26:AM26)","v":0},null,{"$f":"SUM(start:end!AL21:AN21)","v":0},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,{"$f":"SUM(start:end!M27:O27)","v":0},null,null,{"$f":"SUM(start:end!P27:S27)","v":0},null,{"$f":"SUM(start:end!R22:T22)","v":0},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,{"$f":"SUM(start:end!AB27:AE27)","v":0},null,{"$f":"SUM(start:end!AD22:AF22)","v":0},null,{"$f":"SUM(start:end!AF27:AI27)","v":0},null,{"$f":"SUM(start:end!AH22:AJ22)","v":0},null,{"$f":"SUM(start:end!AJ27:AM27)","v":0},null,{"$f":"SUM(start:end!AL22:AN22)","v":0},null,null,"■設計監督費（外部委託せず）について、全体事業費の2.75％以内の額",null,null,{"$f":"IF(AP5=2,IF(AND(COUNTIF(B12:E21,\"*負担金*\")>0,#REF!=\"\"),\"確認\",\"\"),\"\")","v":""},13,""]
[null,null,null,null,null,null,null,null,"Ｅ",{"$f":"SUM(start:end!J28:L28)","v":0},null,null,{"$f":"SUM(start:end!M28:O28)","v":0},null,null,{"$f":"SUM(start:end!P28:S28)","v":0},null,{"$f":"SUM(start:end!R23:T23)","v":0},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,{"$f":"SUM(start:end!AB28:AE28)","v":0},null,{"$f":"SUM(start:end!AD23:AF23)","v":0},null,{"$f":"SUM(start:end!AF28:AI28)","v":0},null,{"$f":"SUM(start:end!AH23:AJ23)","v":0},null,{"$f":"SUM(start:end!AJ28:AM28)","v":0},null,{"$f":"SUM(start:end!AL23:AN23)","v":0},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,{"$f":"SUM(start:end!M29:O29)","v":0},null,null,{"$f":"SUM(start:end!P29:S29)","v":0},null,{"$f":"SUM(start:end!R24:T24)","v":0},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,{"$f":"SUM(start:end!AB29:AE29)","v":0},null,{"$f":"SUM(start:end!AD24:AF24)","v":0},null,{"$f":"SUM(start:end!AF29:AI29)","v":0},null,{"$f":"SUM(start:end!AH24:AJ24)","v":0},null,{"$f":"SUM(start:end!AJ29:AM29)","v":0},null,{"$f":"SUM(start:end!AL24:AN24)","v":0},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,{"$f":"SUM(start:end!M30:O30)","v":0},null,null,{"$f":"SUM(start:end!P30:S30)","v":0},null,{"$f":"SUM(start:end!R25:T25)","v":0},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,{"$f":"SUM(start:end!AB30:AE30)","v":0},null,{"$f":"SUM(start:end!AD25:AF25)","v":0},null,{"$f":"SUM(start:end!AF30:AI30)","v":0},null,{"$f":"SUM(start:end!AH25:AJ25)","v":0},null,{"$f":"SUM(start:end!AJ30:AM30)","v":0},null,{"$f":"SUM(start:end!AL25:AN25)","v":0},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,{"$f":"SUM(start:end!M31:O31)","v":0},null,null,{"$f":"SUM(start:end!P31:S31)","v":0},null,{"$f":"SUM(start:end!R26:T26)","v":0},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,{"$f":"SUM(start:end!AB31:AE31)","v":0},null,{"$f":"SUM(start:end!AD26:AF26)","v":0},null,{"$f":"SUM(start:end!AF31:AI31)","v":0},null,{"$f":"SUM(start:end!AH26:AJ26)","v":0},null,{"$f":"SUM(start:end!AJ31:AM31)","v":0},null,{"$f":"SUM(start:end!AL26:AN26)","v":0},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,{"$f":"SUM(start:end!M32:O32)","v":0},null,null,{"$f":"SUM(start:end!P32:S32)","v":0},null,{"$f":"SUM(start:end!R27:T27)","v":0},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,{"$f":"SUM(start:end!AB32:AE32)","v":0},null,{"$f":"SUM(start:end!AD27:AF27)","v":0},null,{"$f":"SUM(start:end!AF32:AI32)","v":0},null,{"$f":"SUM(start:end!AH27:AJ27)","v":0},null,{"$f":"SUM(start:end!AJ32:AM32)","v":0},null,{"$f":"SUM(start:end!AL27:AN27)","v":0},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,{"$f":"SUM(start:end!M33:O33)","v":0},null,null,{"$f":"SUM(start:end!P33:S33)","v":0},null,{"$f":"SUM(start:end!R28:T28)","v":0},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,{"$f":"SUM(start:end!AB33:AE33)","v":0},null,{"$f":"SUM(start:end!AD28:AF28)","v":0},null,{"$f":"SUM(start:end!AF33:AI33)","v":0},null,{"$f":"SUM(start:end!AH28:AJ28)","v":0},null,{"$f":"SUM(start:end!AJ33:AM33)","v":0},null,{"$f":"SUM(start:end!AL28:AN28)","v":0},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,{"$f":"SUM(start:end!M34:O34)","v":0},null,null,{"$f":"SUM(start:end!P34:S34)","v":0},null,{"$f":"SUM(start:end!R29:T29)","v":0},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,{"$f":"SUM(start:end!AB34:AE34)","v":0},null,{"$f":"SUM(start:end!AD29:AF29)","v":0},null,{"$f":"SUM(start:end!AF34:AI34)","v":0},null,{"$f":"SUM(start:end!AH29:AJ29)","v":0},null,{"$f":"SUM(start:end!AJ34:AM34)","v":0},null,{"$f":"SUM(start:end!AL29:AN29)","v":0},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,{"$f":"SUM(start:end!M35:O35)","v":0},null,null,{"$f":"SUM(start:end!P35:S35)","v":0},null,{"$f":"SUM(start:end!R30:T30)","v":0},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,{"$f":"SUM(start:end!AB35:AE35)","v":0},null,{"$f":"SUM(start:end!AD30:AF30)","v":0},null,{"$f":"SUM(start:end!AF35:AI35)","v":0},null,{"$f":"SUM(start:end!AH30:AJ30)","v":0},null,{"$f":"SUM(start:end!AJ35:AM35)","v":0},null,{"$f":"SUM(start:end!AL30:AN30)","v":0},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,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,"様式1","貸付種類を選択されていないのでチェックを行いませんでした。"]