{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["使用上の留意点 ","start","1","2","end","総括表"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":6,"comments":3,"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":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,1,9],[13,1,17,8],[18,1,26,8],[3,1,9,8],[10,1,12,8]]}
["使用上の留意点"]
[]
[]
[null,"　本エクセルシートは、事業実施状況等調書にかかる総括表を作成するためのシートです（1件の借入申込みに対し複数の事業（起債計画書ベース）を含む場合、事業ごとに別葉とし、総括表を作成してください）。総括表には、財政融資資金貸付予定額（変更）通知書に記載されている事業名を記入し、別葉として作成した調書には起債計画書の事業名など具体的な事業名を記入してください。\n　また、本エクセルシートを使用する場合においても、合計金額を含む各金額等については、必ず、再検証願います。"]
[]
[]
[]
[]
[]
[]
[null,"１．入力方法等\n・作業シートは「1」、「2」及び「総括表」の３つです。各シートにおいて、黄色着色されている部分が必須入力箇所です。着色されていない部分は、自動計算により表示される箇所（金額の計、借入時充当率など）のほか、記載不要の箇所です。作業シートを追加する場合には、「start」タブと「end」タブの間に挿入して下さい。\n・「end」タブの後ろにある「総括表」の各金額欄には、作業シート「１」、「２」の同位置にあるセルに入力されている金額を単純合計した金額が、自動的に反映されます。\n　（注）同位置にあるセルに異なる事業費内訳などの金額を入力している場合においても、単純合計されますのでご注意下さい。"]
[]
[]
[null,"２．エラーチェックの見方\n・エラーとなる場合、57行目「ok」→「ng」となります。\n 事業費内訳（計）　≠　財源内訳（計）　など、数字が一致しない場合がエラー表示となりますので、例示集を参考に適宜修正してください\n"]
[]
[]
[]
[]
[null,"３．その他留意事項\n・「start」及び「end」タブのシートは、削除しないで下さい。\n・「行」・「列」の挿入・削除は行わないで下さい。\n"]

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

{"sheet":"1","index":2,"n_rows":57,"n_cols":41,"rows_kept":57,"cut":false,"hidden":false,"merged":[[44,1,44,4],[44,14,44,21],[45,1,45,12],[45,14,45,21],[45,22,45,33],[44,22,44,33],[4,0,4,1],[4,2,4,21],[4,22,4,29],[4,30,4,37],[5,0,8,1],[5,2,8,21],[5,22,8,29],[5,30,8,37],[10,30,10,31],[10,32,10,33],[10,34,10,35],[10,36,10,37],[11,0,11,3],[11,4,11,7],[11,8,11,10],[11,11,11,13],[11,14,11,17],[11,18,11,21],[0,28,0,37],[1,4,1,32],[1,33,1,37],[3,0,3,1],[3,2,3,21],[3,22,3,25],[3,28,3,29],[3,30,3,31],[3,32,3,33],[3,34,3,35],[9,0,10,3],[9,4,10,7],[9,8,9,25],[9,26,9,37],[10,8,10,10],[10,11,10,13],[10,14,10,17],[10,18,10,21],[10,22,10,25],[10,26,10,29],[11,22,11,25],[11,26,11,29],[11,30,11,33],[11,34,11,37],[12,0,12,3],[12,4,12,7],[12,8,12,10],[12,11,12,13],[12,14,12,17],[12,18,12,21],[12,22,12,25],[12,26,12,29],[12,30,12,33],[12,34,12,37],[13,34,13,37],[14,0,14,3],[14,4,14,7],[14,8,14,10],[14,11,14,13],[14,14,14,17],[14,18,14,21],[14,22,14,25],[14,26,14,29],[14,30,14,33],[14,34,14,37],[13,0,13,3],[13,4,13,7],[13,8,13,10],[13,11,13,13],[13,14,13,17],[13,18,13,21],[13,22,13,25],[13,26,13,29],[13,30,13,33],[15,22,15,25],[15,26,15,29],[15,30,15,33],[15,34,15,37],[16,0,16,6],[16,8,16,10],[16,11,16,13],[16,14,16,17],[16,18,16,21],[16,22,16,25],[15,0,15,3],[15,4,15,7],[15,8,15,10],[15,11,15,13],[15,14,15,17],[15,18,15,21],[16,26,16,29],[16,30,16,33],[16,34,16,37],[18,34,18,35],[18,36,18,37],[18,0,18,2],[18,3,18,7],[18,8,18,10],[18,11,18,13],[18,14,18,17],[18,18,18,21],[17,0,17,7],[17,8,17,25],[17,26,17,37],[19,0,22,0],[19,1,19,2],[19,3,19,6],[19,8,19,10],[19,11,19,13],[19,14,19,17],[18,22,18,25],[18,26,18,29],[18,30,18,31],[19,18,19,21],[19,22,19,25],[19,26,19,29],[19,30,19,33],[21,1,21,2],[21,3,21,6],[21,8,21,10],[21,11,21,13],[21,14,21,17],[21,18,21,21],[21,22,21,25],[21,26,21,29],[21,30,21,33],[18,32,18,33],[19,34,19,37],[20,1,20,2],[20,3,20,6],[20,8,20,10],[20,11,20,13],[20,14,20,17],[20,18,20,21],[20,22,20,25],[20,26,20,29],[20,30,20,33],[20,34,20,37],[25,34,25,37],[21,34,21,37],[22,1,22,2],[22,3,22,6],[22,8,22,10],[22,11,22,13],[22,14,22,17],[23,14,23,17],[23,18,23,21],[23,22,23,25],[23,26,23,29],[23,30,23,33],[23,34,23,37],[22,18,22,21],[22,22,22,25],[22,26,22,29],[22,30,22,33],[22,34,22,37],[23,0,25,0],[26,26,26,29],[24,26,24,29],[24,30,24,33],[24,34,24,37],[25,1,25,2],[25,3,25,6],[25,8,25,10],[25,11,25,13],[25,14,25,17],[25,18,25,21],[25,22,25,25],[24,3,24,6],[24,8,24,10],[24,11,24,13],[24,14,24,17],[24,18,24,21],[24,22,24,25],[23,1,24,2],[23,3,23,6],[23,8,23,10],[23,11,23,13],[25,26,25,29],[25,30,25,33],[28,18,28,21],[28,22,28,25],[28,26,28,29],[28,30,28,33],[26,30,26,33],[26,34,26,37],[27,0,27,2],[27,3,27,7],[27,8,27,10],[27,11,27,13],[27,14,27,17],[27,18,27,21],[27,22,27,25],[27,26,27,29],[27,30,27,33],[27,34,27,37],[26,0,26,2],[26,3,26,7],[26,8,26,10],[26,11,26,13],[26,14,26,17],[26,18,26,21],[26,22,26,25],[34,12,34,17],[34,18,34,23],[34,24,34,37],[35,2,37,5],[35,8,35,10],[35,20,35,21],[36,8,36,10],[36,33,36,36],[28,34,28,37],[29,0,29,2],[29,3,29,7],[29,8,29,10],[29,11,29,13],[29,14,29,17],[29,18,29,21],[29,22,29,25],[29,26,29,29],[29,30,29,33],[29,34,29,37],[28,0,28,2],[28,3,28,7],[28,8,28,10],[28,11,28,13],[28,14,28,17],[30,30,30,33],[30,34,30,37],[31,0,31,6],[31,8,31,10],[31,11,31,13],[31,14,31,17],[31,18,32,20],[31,21,31,23],[31,24,31,37],[32,0,32,6],[32,8,32,10],[32,11,32,13],[32,14,32,17],[32,21,32,23],[32,24,32,37],[30,0,30,7],[30,8,30,10],[30,11,30,13],[30,14,30,17],[30,18,30,21],[30,22,30,25],[30,26,30,29],[37,6,37,7],[37,8,37,10],[37,13,37,17],[37,25,37,27],[38,0,42,1],[38,3,38,5],[38,6,38,10],[38,11,38,14],[38,15,38,17],[38,18,38,20],[40,3,40,4],[40,6,40,9],[40,11,40,13],[40,15,40,16],[38,21,38,28],[33,0,37,1],[33,2,33,3],[33,4,33,7],[33,8,33,9],[33,10,33,16],[33,17,33,19],[33,20,33,24],[34,2,34,5],[34,6,34,11],[38,29,38,37],[39,3,39,4],[39,6,39,9],[39,11,39,13],[39,15,39,16],[39,18,39,19],[39,21,39,28],[39,30,39,32],[42,3,42,4],[42,6,42,9],[42,11,42,13],[42,15,42,16],[42,18,42,19],[42,21,42,28],[40,18,40,19],[40,21,40,28],[41,3,41,4],[41,6,41,9],[41,11,41,13],[41,15,41,16],[41,18,41,19],[41,21,41,28],[46,1,46,12],[48,26,48,37],[56,8,56,10],[56,11,56,13],[56,14,56,17],[56,18,56,21],[56,22,56,25],[56,26,56,29],[56,30,56,33],[56,34,56,37]]}
["別紙第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,"事業開始日～\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,"Ａ",{"$f":"SUM(I12:K16)","v":0},null,null,{"$f":"SUM(L12:N16)","v":0},null,null,{"$f":"SUM(O12:R16)","v":0},null,null,null,{"$f":"SUM(S12:V16)","v":0},null,null,null,{"$f":"SUM(W12:Z16)","v":0},null,null,null,{"$f":"SUM(AA12:AD16)","v":0},null,null,null,{"$f":"SUM(AE12:AH16)","v":0},null,null,null,{"$f":"SUM(AI12:AL16)","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"■該当なし（事務費を起債対象とせず）"]
[null,"都道府県支出金",null,null,null,null,null,"Ｃ",null,null,null,null,null,null,null,null,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,null,null,null,null,null,"Ｄ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"■廃止前の補助基準により定められていた計算方法により算出した範囲内の額"]
[null,null,null,null,null,null,null,"Ｅ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"■補助基準に定める範囲内の事務費"]
["起債","財政融資資金",null,"本債",null,null,null,"Ｆ"]
[null,null,null,null,null,null,null,"Ｇ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"■該当なし（事務費を起債対象とせず）"]
[null,"その他",null,null,null,null,null,"Ｈ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"■設計監督費（外部委託）について、実所要額"]
["一般財源",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"■設計監督費以外の事務費について、全体事業費の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,"■設計監督費（外部委託）の実所要額、及びそれ以外の事務費について全体事業費の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,"■設計監督費（外部委託せず）及びそれ以外の事務費について、それぞれ全体事業費の2.75％以内の額　"]
["計",null,null,null,null,null,null,null,{"$f":"SUM(I20:K30)","v":0},null,null,{"$f":"SUM(L20:N30)","v":0},null,null,{"$f":"SUM(O20:R30)","v":0},null,null,null,{"$f":"SUM(S20:V30)","v":0},null,null,null,{"$f":"SUM(W20:Z30)","v":0},null,null,null,{"$f":"SUM(AA20:AD30)","v":0},null,null,null,{"$f":"SUM(AE20:AH30)","v":0},null,null,null,{"$f":"SUM(AI20:AL30)","v":0},null,null,null,null,null,"■設計監督費と合わせて全体事業費の6.0％以内の額（水道、港湾、下水道）"]
["借入時充当率((Ｆ+Ｇ+Ｈ)/(Ａ-Ｂ-Ｃ-Ｄ-Ｅ)×100)",null,null,null,null,null,null,"(％)",{"$f":"IF(I31>0,(I24+I25+I26)/(I17-I20-I21-I22-I23),\"\")","v":""},null,null,{"$f":"IF(L31>0,(L24+L25+L26)/(L17-L20-L21-L22-L23),\"\")","v":""},null,null,{"$f":"IF(O31>0,(O24+O25+O26)/(O17-O20-O21-O23),\"\")","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,null,"(％)",null,null,null,null,null,null,null,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,"年）"]
["起債同意\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,null,null,"②貸付日時点における事業の進捗状況"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"　要　　/　　否",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"要"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"2．事業費内訳には、起債対象となる費用のみ記入する。"]
[null,"3．収支金額、収支状況の各計は一致する。"]
[null,"4．収支状況は、借入月を「　月」欄に記入する。"]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(I$31=I$17,\"ok\",\"ng\")","v":"ok"},null,null,{"$f":"IF(L$31=L$17,\"ok\",\"ng\")","v":"ok"},null,null,{"$f":"IF(O$31=O$17,\"ok\",\"ng\")","v":"ok"},null,null,null,{"$f":"IF(S$31=S$17,\"ok\",\"ng\")","v":"ok"},null,null,null,{"$f":"IF(W$31=W$17,\"ok\",\"ng\")","v":"ok"},null,null,null,{"$f":"IF(AA$31=AA$17,\"ok\",\"ng\")","v":"ok"},null,null,null,{"$f":"IF(AE$31=AE$17,\"ok\",\"ng\")","v":"ok"},null,null,null,{"$f":"IF(AI$31=AI$17,\"ok\",\"ng\")","v":"ok"}]

{"sheet":"2","index":3,"n_rows":57,"n_cols":41,"rows_kept":57,"cut":false,"hidden":false,"merged":[[45,22,45,33],[44,22,44,33],[47,1,47,12],[44,1,44,4],[44,14,44,21],[45,1,45,12],[45,14,45,21],[46,1,46,12],[46,14,46,21],[46,22,46,29],[4,0,4,1],[4,2,4,21],[4,22,4,29],[4,30,4,37],[5,0,8,1],[5,2,8,21],[5,22,8,29],[5,30,8,37],[0,28,0,37],[1,4,1,32],[1,33,1,37],[3,0,3,1],[3,2,3,21],[3,22,3,25],[3,28,3,29],[3,30,3,31],[3,32,3,33],[3,34,3,35],[10,30,10,31],[10,32,10,33],[10,34,10,35],[10,36,10,37],[11,0,11,3],[11,4,11,7],[11,8,11,10],[11,11,11,13],[11,14,11,17],[11,18,11,21],[9,0,10,3],[9,4,10,7],[9,8,9,25],[9,26,9,37],[10,8,10,10],[10,11,10,13],[10,14,10,17],[10,18,10,21],[10,22,10,25],[10,26,10,29],[11,22,11,25],[11,26,11,29],[11,30,11,33],[11,34,11,37],[12,34,12,37],[13,0,13,3],[13,4,13,7],[13,8,13,10],[13,11,13,13],[13,14,13,17],[13,18,13,21],[13,22,13,25],[13,26,13,29],[13,30,13,33],[13,34,13,37],[12,0,12,3],[12,4,12,7],[12,8,12,10],[12,11,12,13],[12,14,12,17],[12,18,12,21],[12,22,12,25],[12,26,12,29],[12,30,12,33],[14,34,14,37],[15,0,15,3],[15,4,15,7],[15,8,15,10],[15,11,15,13],[15,14,15,17],[15,18,15,21],[16,26,16,29],[16,30,16,33],[16,34,16,37],[14,0,14,3],[14,4,14,7],[14,8,14,10],[14,11,14,13],[14,14,14,17],[14,18,14,21],[14,22,14,25],[14,26,14,29],[14,30,14,33],[15,22,15,25],[15,26,15,29],[15,30,15,33],[15,34,15,37],[16,0,16,6],[16,8,16,10],[16,11,16,13],[16,14,16,17],[16,18,16,21],[16,22,16,25],[18,34,18,35],[18,36,18,37],[18,0,18,2],[18,3,18,7],[18,8,18,10],[18,11,18,13],[18,14,18,17],[18,18,18,21],[17,0,17,7],[17,8,17,25],[17,26,17,37],[19,0,22,0],[19,1,19,2],[19,3,19,6],[19,8,19,10],[19,11,19,13],[19,14,19,17],[18,22,18,25],[18,26,18,29],[18,30,18,31],[19,18,19,21],[19,22,19,25],[19,26,19,29],[19,30,19,33],[21,1,21,2],[21,3,21,6],[21,8,21,10],[21,11,21,13],[21,14,21,17],[21,18,21,21],[21,22,21,25],[21,26,21,29],[21,30,21,33],[18,32,18,33],[19,34,19,37],[20,1,20,2],[20,3,20,6],[20,8,20,10],[20,11,20,13],[20,14,20,17],[20,18,20,21],[20,22,20,25],[20,26,20,29],[20,30,20,33],[20,34,20,37],[25,34,25,37],[21,34,21,37],[22,1,22,2],[22,3,22,6],[22,8,22,10],[22,11,22,13],[22,14,22,17],[23,14,23,17],[23,18,23,21],[23,22,23,25],[23,26,23,29],[23,30,23,33],[23,34,23,37],[22,18,22,21],[22,22,22,25],[22,26,22,29],[22,30,22,33],[22,34,22,37],[23,0,25,0],[26,26,26,29],[24,26,24,29],[24,30,24,33],[24,34,24,37],[25,1,25,2],[25,3,25,6],[25,8,25,10],[25,11,25,13],[25,14,25,17],[25,18,25,21],[25,22,25,25],[24,3,24,6],[24,8,24,10],[24,11,24,13],[24,14,24,17],[24,18,24,21],[24,22,24,25],[23,1,24,2],[23,3,23,6],[23,8,23,10],[23,11,23,13],[25,26,25,29],[25,30,25,33],[28,18,28,21],[28,22,28,25],[28,26,28,29],[28,30,28,33],[26,30,26,33],[26,34,26,37],[27,0,27,2],[27,3,27,7],[27,8,27,10],[27,11,27,13],[27,14,27,17],[27,18,27,21],[27,22,27,25],[27,26,27,29],[27,30,27,33],[27,34,27,37],[26,0,26,2],[26,3,26,7],[26,8,26,10],[26,11,26,13],[26,14,26,17],[26,18,26,21],[26,22,26,25],[34,12,34,17],[34,18,34,23],[34,24,34,37],[35,2,37,5],[35,8,35,10],[35,20,35,21],[36,8,36,10],[36,33,36,36],[28,34,28,37],[29,0,29,2],[29,3,29,7],[29,8,29,10],[29,11,29,13],[29,14,29,17],[29,18,29,21],[29,22,29,25],[29,26,29,29],[29,30,29,33],[29,34,29,37],[28,0,28,2],[28,3,28,7],[28,8,28,10],[28,11,28,13],[28,14,28,17],[30,30,30,33],[30,34,30,37],[31,0,31,6],[31,8,31,10],[31,11,31,13],[31,14,31,17],[31,18,32,20],[31,21,31,23],[31,24,31,37],[32,0,32,6],[32,8,32,10],[32,11,32,13],[32,14,32,17],[32,21,32,23],[32,24,32,37],[30,0,30,7],[30,8,30,10],[30,11,30,13],[30,14,30,17],[30,18,30,21],[30,22,30,25],[30,26,30,29],[37,6,37,7],[37,8,37,10],[37,13,37,17],[37,25,37,27],[38,0,42,1],[38,3,38,5],[38,6,38,10],[38,11,38,14],[38,15,38,17],[38,18,38,20],[40,3,40,4],[40,6,40,9],[40,11,40,13],[40,15,40,16],[38,21,38,28],[33,0,37,1],[33,2,33,3],[33,4,33,7],[33,8,33,9],[33,10,33,16],[33,17,33,19],[33,20,33,24],[34,2,34,5],[34,6,34,11],[38,29,38,37],[39,3,39,4],[39,6,39,9],[39,11,39,13],[39,15,39,16],[39,18,39,19],[39,21,39,28],[39,30,39,32],[42,3,42,4],[42,6,42,9],[42,11,42,13],[42,15,42,16],[42,18,42,19],[42,21,42,28],[40,18,40,19],[40,21,40,28],[41,3,41,4],[41,6,41,9],[41,11,41,13],[41,15,41,16],[41,18,41,19],[41,21,41,28],[48,26,48,37],[56,8,56,10],[56,11,56,13],[56,14,56,17],[56,18,56,21],[56,22,56,25],[56,26,56,29],[56,30,56,33],[56,34,56,37]]}
["別紙第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,"事業開始日～\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,"Ａ",{"$f":"SUM(I12:K16)","v":0},null,null,{"$f":"SUM(L12:N16)","v":0},null,null,{"$f":"SUM(O12:R16)","v":0},null,null,null,{"$f":"SUM(S12:V16)","v":0},null,null,null,{"$f":"SUM(W12:Z16)","v":0},null,null,null,{"$f":"SUM(AA12:AD16)","v":0},null,null,null,{"$f":"SUM(AE12:AH16)","v":0},null,null,null,{"$f":"SUM(AI12:AL16)","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"■該当なし（事務費を起債対象とせず）"]
[null,"都道府県支出金",null,null,null,null,null,"Ｃ",null,null,null,null,null,null,null,null,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,null,null,null,null,null,"Ｄ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"■廃止前の補助基準により定められていた計算方法により算出した範囲内の額"]
[null,null,null,null,null,null,null,"Ｅ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"■補助基準に定める範囲内の事務費"]
["起債","財政融資資金",null,"本債",null,null,null,"Ｆ"]
[null,null,null,null,null,null,null,"Ｇ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"■該当なし（事務費を起債対象とせず）"]
[null,"その他",null,null,null,null,null,"Ｈ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"■設計監督費（外部委託）について、実所要額"]
["一般財源",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"■設計監督費以外の事務費について、全体事業費の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,"■設計監督費（外部委託）の実所要額、及びそれ以外の事務費について全体事業費の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,"■設計監督費（外部委託せず）及びそれ以外の事務費について、それぞれ全体事業費の2.75％以内の額　"]
["計",null,null,null,null,null,null,null,{"$f":"SUM(I20:K30)","v":0},null,null,{"$f":"SUM(L20:N30)","v":0},null,null,{"$f":"SUM(O20:R30)","v":0},null,null,null,{"$f":"SUM(S20:V30)","v":0},null,null,null,{"$f":"SUM(W20:Z30)","v":0},null,null,null,{"$f":"SUM(AA20:AD30)","v":0},null,null,null,{"$f":"SUM(AE20:AH30)","v":0},null,null,null,{"$f":"SUM(AI20:AL30)","v":0},null,null,null,null,null,"■設計監督費と合わせて全体事業費の6.0％以内の額（水道、港湾、下水道）"]
["借入時充当率((Ｆ+Ｇ+Ｈ)/(Ａ-Ｂ-Ｃ-Ｄ-Ｅ)×100)",null,null,null,null,null,null,"(％)",{"$f":"IF(I31>0,(I24+I25+I26)/(I17-I20-I21-I22-I23),\"\")","v":""},null,null,{"$f":"IF(L31>0,(L24+L25+L26)/(L17-L20-L21-L22-L23),\"\")","v":""},null,null,{"$f":"IF(O31>0,(O24+O25+O26)/(O17-O20-O21-O23),\"\")","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,null,"(％)",null,null,null,null,null,null,null,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,"年）"]
["起債同意\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,null,null,"②貸付日時点における事業の進捗状況"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"　要　　/　　否",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"要"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"2．事業費内訳には、起債対象となる費用のみ記入する。"]
[null,"3．収支金額、収支状況の各計は一致する。"]
[null,"4．収支状況は、借入月を「　月」欄に記入する。"]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(I$31=I$17,\"ok\",\"ng\")","v":"ok"},null,null,{"$f":"IF(L$31=L$17,\"ok\",\"ng\")","v":"ok"},null,null,{"$f":"IF(O$31=O$17,\"ok\",\"ng\")","v":"ok"},null,null,null,{"$f":"IF(S$31=S$17,\"ok\",\"ng\")","v":"ok"},null,null,null,{"$f":"IF(W$31=W$17,\"ok\",\"ng\")","v":"ok"},null,null,null,{"$f":"IF(AA$31=AA$17,\"ok\",\"ng\")","v":"ok"},null,null,null,{"$f":"IF(AE$31=AE$17,\"ok\",\"ng\")","v":"ok"},null,null,null,{"$f":"IF(AI$31=AI$17,\"ok\",\"ng\")","v":"ok"}]

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

{"sheet":"総括表","index":5,"n_rows":57,"n_cols":41,"rows_kept":57,"cut":false,"hidden":false,"merged":[[44,1,44,4],[44,14,44,21],[45,1,45,12],[45,14,45,21],[44,22,44,33],[45,22,45,33],[4,0,4,1],[4,2,4,21],[4,22,4,29],[4,30,4,37],[5,0,8,1],[5,2,8,21],[5,22,8,29],[5,30,8,37],[10,30,10,31],[10,32,10,33],[10,34,10,35],[10,36,10,37],[11,0,11,3],[11,4,11,7],[11,8,11,10],[11,11,11,13],[11,14,11,17],[11,18,11,21],[0,28,0,37],[1,4,1,32],[1,33,1,37],[3,0,3,1],[3,2,3,21],[3,22,3,25],[3,28,3,29],[3,30,3,31],[3,32,3,33],[3,34,3,35],[9,0,10,3],[9,4,10,7],[9,8,9,25],[9,26,9,37],[10,8,10,10],[10,11,10,13],[10,14,10,17],[10,18,10,21],[10,22,10,25],[10,26,10,29],[11,22,11,25],[11,26,11,29],[11,30,11,33],[11,34,11,37],[12,0,12,3],[12,4,12,7],[12,8,12,10],[12,11,12,13],[12,14,12,17],[12,18,12,21],[12,22,12,25],[12,26,12,29],[12,30,12,33],[12,34,12,37],[13,34,13,37],[14,0,14,3],[14,4,14,7],[14,8,14,10],[14,11,14,13],[14,14,14,17],[14,18,14,21],[14,22,14,25],[14,26,14,29],[14,30,14,33],[14,34,14,37],[13,0,13,3],[13,4,13,7],[13,8,13,10],[13,11,13,13],[13,14,13,17],[13,18,13,21],[13,22,13,25],[13,26,13,29],[13,30,13,33],[15,22,15,25],[15,26,15,29],[15,30,15,33],[15,34,15,37],[16,0,16,6],[16,8,16,10],[16,11,16,13],[16,14,16,17],[16,18,16,21],[16,22,16,25],[15,0,15,3],[15,4,15,7],[15,8,15,10],[15,11,15,13],[15,14,15,17],[15,18,15,21],[16,26,16,29],[16,30,16,33],[16,34,16,37],[18,34,18,35],[18,36,18,37],[18,0,18,2],[18,3,18,7],[18,8,18,10],[18,11,18,13],[18,14,18,17],[18,18,18,21],[17,0,17,7],[17,8,17,25],[17,26,17,37],[19,0,22,0],[19,1,19,2],[19,3,19,6],[19,8,19,10],[19,11,19,13],[19,14,19,17],[18,22,18,25],[18,26,18,29],[18,30,18,31],[19,18,19,21],[19,22,19,25],[19,26,19,29],[19,30,19,33],[21,1,21,2],[21,3,21,6],[21,8,21,10],[21,11,21,13],[21,14,21,17],[21,18,21,21],[21,22,21,25],[21,26,21,29],[21,30,21,33],[18,32,18,33],[19,34,19,37],[20,1,20,2],[20,3,20,6],[20,8,20,10],[20,11,20,13],[20,14,20,17],[20,18,20,21],[20,22,20,25],[20,26,20,29],[20,30,20,33],[20,34,20,37],[25,34,25,37],[21,34,21,37],[22,1,22,2],[22,3,22,6],[22,8,22,10],[22,11,22,13],[22,14,22,17],[23,14,23,17],[23,18,23,21],[23,22,23,25],[23,26,23,29],[23,30,23,33],[23,34,23,37],[22,18,22,21],[22,22,22,25],[22,26,22,29],[22,30,22,33],[22,34,22,37],[23,0,25,0],[26,26,26,29],[24,26,24,29],[24,30,24,33],[24,34,24,37],[25,1,25,2],[25,3,25,6],[25,8,25,10],[25,11,25,13],[25,14,25,17],[25,18,25,21],[25,22,25,25],[24,3,24,6],[24,8,24,10],[24,11,24,13],[24,14,24,17],[24,18,24,21],[24,22,24,25],[23,1,24,2],[23,3,23,6],[23,8,23,10],[23,11,23,13],[25,26,25,29],[25,30,25,33],[28,18,28,21],[28,22,28,25],[28,26,28,29],[28,30,28,33],[26,30,26,33],[26,34,26,37],[27,0,27,2],[27,3,27,7],[27,8,27,10],[27,11,27,13],[27,14,27,17],[27,18,27,21],[27,22,27,25],[27,26,27,29],[27,30,27,33],[27,34,27,37],[26,0,26,2],[26,3,26,7],[26,8,26,10],[26,11,26,13],[26,14,26,17],[26,18,26,21],[26,22,26,25],[34,12,34,17],[34,18,34,23],[34,24,34,37],[35,2,37,5],[35,8,35,10],[35,20,35,21],[36,8,36,10],[36,33,36,36],[28,34,28,37],[29,0,29,2],[29,3,29,7],[29,8,29,10],[29,11,29,13],[29,14,29,17],[29,18,29,21],[29,22,29,25],[29,26,29,29],[29,30,29,33],[29,34,29,37],[28,0,28,2],[28,3,28,7],[28,8,28,10],[28,11,28,13],[28,14,28,17],[30,30,30,33],[30,34,30,37],[31,0,31,6],[31,8,31,10],[31,11,31,13],[31,14,31,17],[31,18,32,20],[31,21,31,23],[31,24,31,37],[32,0,32,6],[32,8,32,10],[32,11,32,13],[32,14,32,17],[32,21,32,23],[32,24,32,37],[30,0,30,7],[30,8,30,10],[30,11,30,13],[30,14,30,17],[30,18,30,21],[30,22,30,25],[30,26,30,29],[37,6,37,7],[37,8,37,10],[37,13,37,17],[37,25,37,27],[38,0,42,1],[38,3,38,5],[38,6,38,10],[38,11,38,14],[38,15,38,17],[38,18,38,20],[40,3,40,4],[40,6,40,9],[40,11,40,13],[40,15,40,16],[38,21,38,28],[33,0,37,1],[33,2,33,3],[33,4,33,7],[33,8,33,9],[33,10,33,16],[33,17,33,19],[33,20,33,24],[34,2,34,5],[34,6,34,11],[38,29,38,37],[39,3,39,4],[39,6,39,9],[39,11,39,13],[39,15,39,16],[39,18,39,19],[39,21,39,28],[39,30,39,32],[42,3,42,4],[42,6,42,9],[42,11,42,13],[42,15,42,16],[42,18,42,19],[42,21,42,28],[40,18,40,19],[40,21,40,28],[41,3,41,4],[41,6,41,9],[41,11,41,13],[41,15,41,16],[41,18,41,19],[41,21,41,28],[46,1,46,12],[48,26,48,37],[56,8,56,10],[56,11,56,13],[56,14,56,17],[56,18,56,21],[56,22,56,25],[56,26,56,29],[56,30,56,33],[56,34,56,37]]}
["別紙第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,"事業開始日～\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,{"$f":"SUM(start:end!I12)","v":0},null,null,{"$f":"SUM(start:end!L12)","v":0},null,null,{"$f":"SUM(start:end!O12)","v":0},null,null,null,{"$f":"SUM(start:end!S12)","v":0},null,null,null,{"$f":"SUM(start:end!W12)","v":0},null,null,null,{"$f":"SUM(start:end!AA12)","v":0},null,null,null,{"$f":"SUM(start:end!AE12)","v":0},null,null,null,{"$f":"SUM(start:end!AI12)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(start:end!I13)","v":0},null,null,{"$f":"SUM(start:end!L13)","v":0},null,null,{"$f":"SUM(start:end!O13)","v":0},null,null,null,{"$f":"SUM(start:end!S13)","v":0},null,null,null,{"$f":"SUM(start:end!W13)","v":0},null,null,null,{"$f":"SUM(start:end!AA13)","v":0},null,null,null,{"$f":"SUM(start:end!AE13)","v":0},null,null,null,{"$f":"SUM(start:end!AI13)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(start:end!I14)","v":0},null,null,{"$f":"SUM(start:end!L14)","v":0},null,null,{"$f":"SUM(start:end!O14)","v":0},null,null,null,{"$f":"SUM(start:end!S14)","v":0},null,null,null,{"$f":"SUM(start:end!W14)","v":0},null,null,null,{"$f":"SUM(start:end!AA14)","v":0},null,null,null,{"$f":"SUM(start:end!AE14)","v":0},null,null,null,{"$f":"SUM(start:end!AI14)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(start:end!I15)","v":0},null,null,{"$f":"SUM(start:end!L15)","v":0},null,null,{"$f":"SUM(start:end!O15)","v":0},null,null,null,{"$f":"SUM(start:end!S15)","v":0},null,null,null,{"$f":"SUM(start:end!W15)","v":0},null,null,null,{"$f":"SUM(start:end!AA15)","v":0},null,null,null,{"$f":"SUM(start:end!AE15)","v":0},null,null,null,{"$f":"SUM(start:end!AI15)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(start:end!I16)","v":0},null,null,{"$f":"SUM(start:end!L16)","v":0},null,null,{"$f":"SUM(start:end!O16)","v":0},null,null,null,{"$f":"SUM(start:end!S16)","v":0},null,null,null,{"$f":"SUM(start:end!W16)","v":0},null,null,null,{"$f":"SUM(start:end!AA16)","v":0},null,null,null,{"$f":"SUM(start:end!AE16)","v":0},null,null,null,{"$f":"SUM(start:end!AI16)","v":0}]
["計",null,null,null,null,null,null,"Ａ",{"$f":"SUM(I12:K16)","v":0},null,null,{"$f":"SUM(L12:N16)","v":0},null,null,{"$f":"SUM(O12:R16)","v":0},null,null,null,{"$f":"SUM(S12:V16)","v":0},null,null,null,{"$f":"SUM(W12:Z16)","v":0},null,null,null,{"$f":"SUM(AA12:AD16)","v":0},null,null,null,{"$f":"SUM(AE12:AH16)","v":0},null,null,null,{"$f":"SUM(AI12:AL16)","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,"Ｂ",{"$f":"SUM(start:end!I20)","v":0},null,null,{"$f":"SUM(start:end!L20)","v":0},null,null,{"$f":"SUM(start:end!O20)","v":0},null,null,null,{"$f":"SUM(start:end!S20)","v":0},null,null,null,{"$f":"SUM(start:end!W20)","v":0},null,null,null,{"$f":"SUM(start:end!AA20)","v":0},null,null,null,{"$f":"SUM(start:end!AE20)","v":0},null,null,null,{"$f":"SUM(start:end!AI20)","v":0},null,null,null,null,null,"■該当なし（事務費を起債対象とせず）"]
[null,"都道府県支出金",null,null,null,null,null,"Ｃ",{"$f":"SUM(start:end!I21)","v":0},null,null,{"$f":"SUM(start:end!L21)","v":0},null,null,{"$f":"SUM(start:end!O21)","v":0},null,null,null,{"$f":"SUM(start:end!S21)","v":0},null,null,null,{"$f":"SUM(start:end!W21)","v":0},null,null,null,{"$f":"SUM(start:end!AA21)","v":0},null,null,null,{"$f":"SUM(start:end!AE21)","v":0},null,null,null,{"$f":"SUM(start:end!AI21)","v":0},null,null,null,null,null,"■工事費の5.0％以内の額"]
[null,null,null,null,null,null,null,"Ｄ",{"$f":"SUM(start:end!I22)","v":0},null,null,{"$f":"SUM(start:end!L22)","v":0},null,null,{"$f":"SUM(start:end!O22)","v":0},null,null,null,{"$f":"SUM(start:end!S22)","v":0},null,null,null,{"$f":"SUM(start:end!W22)","v":0},null,null,null,{"$f":"SUM(start:end!AA22)","v":0},null,null,null,{"$f":"SUM(start:end!AE22)","v":0},null,null,null,{"$f":"SUM(start:end!AI22)","v":0},null,null,null,null,null,"■廃止前の補助基準により定められていた計算方法により算出した範囲内の額"]
[null,null,null,null,null,null,null,"Ｅ",{"$f":"SUM(start:end!I23)","v":0},null,null,{"$f":"SUM(start:end!L23)","v":0},null,null,{"$f":"SUM(start:end!O23)","v":0},null,null,null,{"$f":"SUM(start:end!S23)","v":0},null,null,null,{"$f":"SUM(start:end!W23)","v":0},null,null,null,{"$f":"SUM(start:end!AA23)","v":0},null,null,null,{"$f":"SUM(start:end!AE23)","v":0},null,null,null,{"$f":"SUM(start:end!AI23)","v":0},null,null,null,null,null,"■補助基準に定める範囲内の事務費"]
["起債","財政融資資金",null,"本債",null,null,null,"Ｆ",{"$f":"SUM(start:end!I24)","v":0},null,null,{"$f":"SUM(start:end!L24)","v":0},null,null,{"$f":"SUM(start:end!O24)","v":0},null,null,null,{"$f":"SUM(start:end!S24)","v":0},null,null,null,{"$f":"SUM(start:end!W24)","v":0},null,null,null,{"$f":"SUM(start:end!AA24)","v":0},null,null,null,{"$f":"SUM(start:end!AE24)","v":0},null,null,null,{"$f":"SUM(start:end!AI24)","v":0}]
[null,null,null,null,null,null,null,"Ｇ",{"$f":"SUM(start:end!I25)","v":0},null,null,{"$f":"SUM(start:end!L25)","v":0},null,null,{"$f":"SUM(start:end!O25)","v":0},null,null,null,{"$f":"SUM(start:end!S25)","v":0},null,null,null,{"$f":"SUM(start:end!W25)","v":0},null,null,null,{"$f":"SUM(start:end!AA25)","v":0},null,null,null,{"$f":"SUM(start:end!AE25)","v":0},null,null,null,{"$f":"SUM(start:end!AI25)","v":0},null,null,null,null,null,"■該当なし（事務費を起債対象とせず）"]
[null,"その他",null,null,null,null,null,"Ｈ",{"$f":"SUM(start:end!I26)","v":0},null,null,{"$f":"SUM(start:end!L26)","v":0},null,null,{"$f":"SUM(start:end!O26)","v":0},null,null,null,{"$f":"SUM(start:end!S26)","v":0},null,null,null,{"$f":"SUM(start:end!W26)","v":0},null,null,null,{"$f":"SUM(start:end!AA26)","v":0},null,null,null,{"$f":"SUM(start:end!AE26)","v":0},null,null,null,{"$f":"SUM(start:end!AI26)","v":0},null,null,null,null,null,"■設計監督費（外部委託）について、実所要額"]
["一般財源",null,null,null,null,null,null,null,{"$f":"SUM(start:end!I27)","v":0},null,null,{"$f":"SUM(start:end!L27)","v":0},null,null,{"$f":"SUM(start:end!O27)","v":0},null,null,null,{"$f":"SUM(start:end!S27)","v":0},null,null,null,{"$f":"SUM(start:end!W27)","v":0},null,null,null,{"$f":"SUM(start:end!AA27)","v":0},null,null,null,{"$f":"SUM(start:end!AE27)","v":0},null,null,null,{"$f":"SUM(start:end!AI27)","v":0},null,null,null,null,null,"■設計監督費（外部委託せず）について、全体事業費の2.75％以内の額"]
["既収入特定財源",null,null,null,null,null,null,null,{"$f":"SUM(start:end!I28)","v":0},null,null,{"$f":"SUM(start:end!L28)","v":0},null,null,{"$f":"SUM(start:end!O28)","v":0},null,null,null,{"$f":"SUM(start:end!S28)","v":0},null,null,null,{"$f":"SUM(start:end!W28)","v":0},null,null,null,{"$f":"SUM(start:end!AA28)","v":0},null,null,null,{"$f":"SUM(start:end!AE28)","v":0},null,null,null,{"$f":"SUM(start:end!AI28)","v":0},null,null,null,null,null,"■設計監督費以外の事務費について、全体事業費の2.75％以内の額"]
[null,null,null,null,null,null,null,null,{"$f":"SUM(start:end!I29)","v":0},null,null,{"$f":"SUM(start:end!L29)","v":0},null,null,{"$f":"SUM(start:end!O29)","v":0},null,null,null,{"$f":"SUM(start:end!S29)","v":0},null,null,null,{"$f":"SUM(start:end!W29)","v":0},null,null,null,{"$f":"SUM(start:end!AA29)","v":0},null,null,null,{"$f":"SUM(start:end!AE29)","v":0},null,null,null,{"$f":"SUM(start:end!AI29)","v":0},null,null,null,null,null,"■設計監督費（外部委託）の実所要額、及びそれ以外の事務費について全体事業費の2.75％以内の額"]
["一時立替金",null,null,null,null,null,null,null,{"$f":"SUM(start:end!I30)","v":0},null,null,{"$f":"SUM(start:end!L30)","v":0},null,null,{"$f":"SUM(start:end!O30)","v":0},null,null,null,{"$f":"SUM(start:end!S30)","v":0},null,null,null,{"$f":"SUM(start:end!W30)","v":0},null,null,null,{"$f":"SUM(start:end!AA30)","v":0},null,null,null,{"$f":"SUM(start:end!AE30)","v":0},null,null,null,{"$f":"SUM(start:end!AI30)","v":0},null,null,null,null,null,"■設計監督費（外部委託せず）及びそれ以外の事務費について、それぞれ全体事業費の2.75％以内の額　"]
["計",null,null,null,null,null,null,null,{"$f":"SUM(I20:K30)","v":0},null,null,{"$f":"SUM(L20:N30)","v":0},null,null,{"$f":"SUM(O20:R30)","v":0},null,null,null,{"$f":"SUM(S20:V30)","v":0},null,null,null,{"$f":"SUM(W20:Z30)","v":0},null,null,null,{"$f":"SUM(AA20:AD30)","v":0},null,null,null,{"$f":"SUM(AE20:AH30)","v":0},null,null,null,{"$f":"SUM(AI20:AL30)","v":0},null,null,null,null,null,"■設計監督費と合わせて全体事業費の6.0％以内の額（水道、港湾、下水道）"]
["借入時充当率((Ｆ+Ｇ+Ｈ)/(Ａ-Ｂ-Ｃ-Ｄ-Ｅ)×100)",null,null,null,null,null,null,"(％)",{"$f":"IF(I31>0,(I24+I25+I26)/(I17-I20-I21-I22-I23),\"\")","v":""},null,null,{"$f":"IF(L31>0,(L24+L25+L26)/(L17-L20-L21-L22-L23),\"\")","v":""},null,null,{"$f":"IF(O31>0,(O24+O25+O26)/(O17-O20-O21-O23),\"\")","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,null,"(％)",null,null,null,null,null,null,null,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,"年）"]
["起債同意\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,null,null,"②貸付日時点における事業の進捗状況"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"　要　　/　　否",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"要"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"2．事業費内訳には、起債対象となる費用のみ記入する。"]
[null,"3．収支金額、収支状況の各計は一致する。"]
[null,"4．収支状況は、借入月を「　月」欄に記入する。"]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(I$31=I$17,\"ok\",\"ng\")","v":"ok"},null,null,{"$f":"IF(L$31=L$17,\"ok\",\"ng\")","v":"ok"},null,null,{"$f":"IF(O$31=O$17,\"ok\",\"ng\")","v":"ok"},null,null,null,{"$f":"IF(S$31=S$17,\"ok\",\"ng\")","v":"ok"},null,null,null,{"$f":"IF(W$31=W$17,\"ok\",\"ng\")","v":"ok"},null,null,null,{"$f":"IF(AA$31=AA$17,\"ok\",\"ng\")","v":"ok"},null,null,null,{"$f":"IF(AE$31=AE$17,\"ok\",\"ng\")","v":"ok"},null,null,null,{"$f":"IF(AI$31=AI$17,\"ok\",\"ng\")","v":"ok"}]