{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["作業手順","表紙","JANPIA","様式１","様式2A","様式3Ａ","様式3B","様式4","様式5","様式6","添付書類1","添付書類2","添付書類3","リスト"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":30,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"作業手順","index":0,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[[21,0,21,2]]}
["経費精算報告書　作成手順"]
[]
["入力順序"]
[null,"記述内容","入力順序（入力０から入力して下さい。）"]
["様式1","総括表","入力0\n⇒資金計画交付時、改定後、両方の欄に入力。\n　そのほかは、様式2以降から自動転記。"]
["様式2A","支出明細書（A.直接事業費）","入力5\n⇒様式5.6の入力データをマクロボタンで転記。"]
["様式3A","経費集計表（A.直接事業費）","入力3\n⇒様式２Aの直接事業費の科目を黄色の欄に入力してください。"]
["様式3B","経費集計表（B.管理的経費）","入力4\n⇒様式5.6の管理的経費の科目を黄色の欄に入力してください。"]
["様式4","支払証拠書類貼付台紙","収支発生時に随時添付"]
["様式5","収支管理簿","入力1（収支発生時に入力）"]
["様式6","現金出納帳","入力2（収支発生時に入力）"]
["添付書類1"," 区分経理に関する会計書類"]
["添付書類2","指定口座の通帳の写し"]
["添付書類3","人件費に対する賃金台帳等の写し"]
[]
[]
["注意事項"]
["・様式５、様式６は、月次報告にも利用します。"]
["・様式２Ａは、様式５及び様式６の直接事業費の支出明細となります。"]
["・無色の欄は自動転記、自動計算の項目ですので入力は不要です。"]
["・黄色の欄に入力してください。"]

{"sheet":"表紙","index":1,"n_rows":35,"n_cols":9,"rows_kept":35,"cut":false,"hidden":false,"merged":[[12,0,13,8],[16,0,17,8]]}
[]
[null,null,null,null,null,null,null,null,"（西暦）　　　　年　月　日"]
["［　資　金　分　配　団　体　名　］"]
[]
[]
[]
[null,null,null,null,"（団体名）"]
[null,null,null,null,"（代表者役職名）"]
[null,null,null,null,"（氏名）　　　　　　　　　　　　",null,null,null,"印"]
[]
[]
[]
["経費精算報告書"]
[]
[]
[]
["［　資　金　分　配　団　体　名　］　と　［　　実　　行　　団　　体　　名　　］の間で締結した2020年〇月〇日付資金提供契約に基づく○○○○○○〇○○〇○○〇○○〇○○〇事業に関し、〇〇年度の直接事業費、管理的経費の精算金額は金〇〇〇〇〇〇〇〇円となりましたので報告いたします。"]
[]
[]
["添付書類："]
[]
["（１）精算様式１ ",null,null,"総括表"]
["（２）精算様式２　",null,null,"支出明細書"]
["（３）精算様式３　",null,null,"経費集計表"]
["（４）精算様式４　",null,null,"支払証拠書類貼付台紙"]
["（５）精算様式５　",null,null,"収支管理簿"]
["（６）精算様式６　",null,null,"現金出納帳"]
["（７）精算添付書類１　",null,null,"指定口座の通帳の写し"]
["（８）精算添付書類２　",null,null,"区分経理に関する会計書類"]
["（９）精算添付書類3　",null,null,"人件費に対する賃金台帳等の写し"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"以　上"]

{"sheet":"JANPIA","index":2,"n_rows":14,"n_cols":18,"rows_kept":14,"cut":false,"hidden":true,"merged":[[5,2,8,2]]}
[]
[]
[]
[]
[null,null,"JANPIA使用欄"]
[null,null,"次年度資金計画とネットする金額",null,"実行団体","資金分配団体"]
[null,null,null,null,null,"合計",null,null,"実行団体への助成等",null,"管理的経費",null,"PO関連経費",null,"評価関連経費"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"分配団体",null,"実行団体"]
[null,null,null,null,"精算金額","①精算金額","②繰越金額","①-②","精算金額","繰越金額","精算金額","繰越金額","精算金額","繰越金額","精算金額","繰越金額","精算金額","繰越金額"]
[null,2019,null,null,null,{"$f":"I10+K10+M10+O10+Q10","v":{"$error":"#REF!"}},{"$f":"J10+L10+N10+P10+R10","v":0},{"$f":"F10-G10","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},0,{"$f":"#REF!","v":{"$error":"#REF!"}},0,{"$f":"#REF!","v":{"$error":"#REF!"}},0,{"$f":"#REF!","v":{"$error":"#REF!"}},0,{"$f":"#REF!","v":{"$error":"#REF!"}},0]
[null,2020,{"$f":"E11+H10+H11","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"I11+K11+M11+O11+Q11","v":{"$error":"#REF!"}},{"$f":"J11+L11+N11+P11+R11","v":0},{"$f":"F11-G11","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},0,{"$f":"#REF!","v":{"$error":"#REF!"}},0,{"$f":"#REF!","v":{"$error":"#REF!"}},0,{"$f":"#REF!","v":{"$error":"#REF!"}},0,{"$f":"#REF!","v":{"$error":"#REF!"}},0]
[null,2021,{"$f":"E12+H12","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},0,{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},0,{"$f":"#REF!","v":{"$error":"#REF!"}},0,{"$f":"#REF!","v":{"$error":"#REF!"}},0,{"$f":"#REF!","v":{"$error":"#REF!"}},0,{"$f":"#REF!","v":{"$error":"#REF!"}},0]
[null,2022,{"$f":"E13+H13","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},0,{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},0,{"$f":"#REF!","v":{"$error":"#REF!"}},0,{"$f":"#REF!","v":{"$error":"#REF!"}},0,{"$f":"#REF!","v":{"$error":"#REF!"}},0,{"$f":"#REF!","v":{"$error":"#REF!"}},0]
[null,"合計",{"$error":"#REF!"},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"I14+K14+M14+O14+Q14","v":{"$error":"#REF!"}},{"$f":"J14+L14+N14+P14","v":0},{"$error":"#REF!"},{"$f":"SUM(I10:I13)","v":{"$error":"#REF!"}},0,{"$f":"SUM(K10:K13)","v":{"$error":"#REF!"}},0,{"$f":"SUM(M10:M13)","v":{"$error":"#REF!"}},0,{"$f":"SUM(O10:O13)","v":{"$error":"#REF!"}},0,{"$f":"SUM(Q10:Q13)","v":{"$error":"#REF!"}},0]

{"sheet":"様式１","index":3,"n_rows":40,"n_cols":9,"rows_kept":40,"cut":false,"hidden":false,"merged":[[5,3,6,3],[5,4,6,4],[5,5,6,5],[14,6,14,7],[9,0,10,3],[9,4,9,5],[9,6,9,7],[14,4,14,5],[12,0,13,0],[6,0,6,2],[29,4,29,5],[29,6,29,7],[28,4,28,5],[28,6,28,7],[9,8,10,8],[21,4,21,5],[22,4,22,5],[22,6,22,7],[15,4,15,5],[15,6,15,7],[21,6,21,7],[19,0,20,0],[11,1,11,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[17,1,17,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[31,1,31,3],[26,1,26,3],[27,1,27,3],[28,1,28,3],[29,1,29,3],[30,1,30,3]]}
["精算様式１. 総括表"]
[]
["集計"]
[null,null,null,"①助成額","②確定助成額","①-②残額"]
[null,null,null,null,null,"（精算金額）"]
["契約期間",null,"（〇ヶ月）",{"$f":"I28","v":0},{"$f":"I31","v":{"$error":"#DIV/0!"}},{"$f":"D6-E6","v":{"$error":"#DIV/0!"}}]
["2020年〇月〇日～〇年〇月〇"]
[]
["総事業費 内訳"]
[null,null,null,null,"直接事業費",null,"管理的経費",null,"小計"]
[null,null,null,null,"助成金","自己資金","助成金","自己資金"]
[2020,"資金計画（交付時）",null,null,null,null,null,null,{"$f":"SUM(E12:H12)","v":0}]
["（2020年〇月～2021年3月）\n","資金計画（改定後）",null,null,null,null,null,null,{"$f":"SUM(E13:H13)","v":0}]
[null,"助成金受領額",null,null,null,null,null,null,{"$f":"SUM(E14:H14)","v":0}]
[null,"実績額",null,null,{"$f":"様式2A!H2","v":0},null,{"$f":"様式3B!E29","v":0},null,{"$f":"SUM(E15:H15)","v":0}]
[null,"執行率",null,null,{"$f":"IF(E15/(E13+F13)>=1,1,E15/(E13+F13))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(G15/(G13+H13)>=1,1,G15/(G13+H13))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(I15/(I13)>=1,1,I15/(I13))","v":{"$error":"#DIV/0!"}}]
[null,"確定助成額",null,null,{"$f":"E31*E$13/(E$13+E20)","v":{"$error":"#DIV/0!"}},null,{"$f":"G31*G$13/(G$13+G20)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(E17:H17)","v":{"$error":"#DIV/0!"}}]
[null,"精算金額",null,null,{"$f":"E14-E17","v":{"$error":"#DIV/0!"}},null,{"$f":"G14-G17","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[2021,"資金計画（交付時）",null,null,null,null,null,null,0]
["（2021年4月～〇年〇月）\n","資金計画（改定後）",null,null,null,null,null,null,0]
[null,"助成金受領額",null,null,null,null,null,null,0]
[null,"実績額",null,null,{"$f":"様式2A!H3","v":0},null,{"$f":"様式3B!E53","v":0},null,0]
[null,"執行率",null,null,{"$f":"IF(E22/(E20+F20)>=1,1,E22/(E20+F20))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(G22/(G20+H20)>=1,1,G22/(G20+H20))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(I22/(I20)>=1,1,I22/(I20))","v":{"$error":"#DIV/0!"}}]
[null,"確定助成額",null,null,{"$f":"E31*E$20/(E$13+E20)","v":{"$error":"#DIV/0!"}},null,{"$f":"G31*G$20/(G$13+G20)","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,"精算金額",null,null,{"$f":"E21-E24","v":{"$error":"#DIV/0!"}},null,{"$f":"G21-G24","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
["合計","資金計画（交付時）",null,null,{"$f":"E12+E19","v":0},0,0,0,0]
[null,"資金計画（改定時）",null,null,0,0,0,0,0]
[null,"助成金受領額",null,null,{"$f":"E14+E21","v":0},null,{"$f":"G14+G21","v":0},null,0]
[null,"実績額",null,null,{"$f":"E15+E22","v":0},null,{"$f":"G15+G22","v":0},null,0]
[null,"執行率",null,null,{"$f":"IF(E29/(E27+F27)>=1,1,E29/(E27+F27))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(G29/(G27+H27)>=1,1,G29/(G27+H27))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(I29/(I27)>=1,1,I29/(I27))","v":{"$error":"#DIV/0!"}}]
[null,"確定助成額",null,null,{"$f":"ROUND(E27*E30,0)","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(G27*G30,0)","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,"精算金額",null,null,{"$f":"E28-E31","v":{"$error":"#DIV/0!"}},null,{"$f":"G28-G31","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[]
[]
["＜参考＞　様式３より転記"]
[null,null,null,null,"人件費\n(外部委託費＊）","その他経費"]
[null,"2020年度",null,"直接事業費",{"$f":"様式3Ａ!E27","v":0},{"$f":"様式3Ａ!E28","v":0}]
[null,null,null,"管理的経費",{"$f":"様式3B!E27","v":0},{"$f":"様式3B!E28","v":0}]
[null,"2021年度",null,"直接事業費",{"$f":"様式3Ａ!E51","v":0},{"$f":"様式3Ａ!E52","v":0}]
[null,null,null,"管理的経費",{"$f":"様式3B!E51","v":0},{"$f":"様式3B!E52","v":0}]

{"sheet":"様式2A","index":4,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["精算様式２. 支出明細書",null,null,null,null,null,"年度","実績額"]
["A.","直接事業費",null,null,null,null,2020,{"$f":"SUMIF($B$8:$B$2000,G2,$H$8:$H$2000)","v":0}]
[null,null,null,null,null,null,2021,{"$f":"SUMIF($B$8:$B$2000,G3,$H$8:$H$2000)","v":0}]
[]
[]
[]
["精算様式４の番号","年度"," 支出年月日\n（西暦/月/日）","支払区分","財務諸表\nにおける科目","会計科目","支出先","実績額（円）","使途目的、理由など"]
["A-1"]
["A-2"]
["A-3"]
["A-4"]
["A-5"]
["A-6"]
["A-7"]
["A-8"]
["A-9"]
["A-10"]
["A-11"]
["A-12"]
[]
[]
["合計",null,null,null,null,null,null,{"$f":"SUM(H8:H21)","v":0}]
["注1) 記入スペースは適宜増減してください。"]

{"sheet":"様式3Ａ","index":5,"n_rows":53,"n_cols":7,"rows_kept":53,"cut":false,"hidden":false,"merged":[[50,1,51,1],[3,6,4,6],[3,1,4,1],[3,4,4,4],[3,5,4,5],[26,1,27,1]]}
["精算様式３. 経費集計表"]
["A.","直接事業費"]
[null,null,null,null,null,"＊記入スペースは適宜増減してください。"]
["年度","財務諸表\nにおける科目","会計科目","予算","実績額","執行率\n（各年度ベース）","会計科目間流用がある場合にはその理由"]
[null,null,null,"資金計画書記載の値"]
[2020,null,null,null,{"$f":"IF(C6=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$3000=$C6)*(様式2A!$B$8:$B$3000=$A$6)*様式2A!$H$8:$H$3000))","v":""},{"$f":"IF(C6=\"\",\"\",SUM(E6/D6))","v":""}]
[null,null,null,null,{"$f":"IF(C7=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$3000=$C7)*(様式2A!$B$8:$B$3000=$A$6)*様式2A!$H$8:$H$3000))","v":""},""]
[null,null,null,null,{"$f":"IF(C8=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$3000=$C8)*(様式2A!$B$8:$B$3000=$A$6)*様式2A!$H$8:$H$3000))","v":""},""]
[null,null,null,null,{"$f":"IF(C9=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$3000=$C9)*(様式2A!$B$8:$B$3000=$A$6)*様式2A!$H$8:$H$3000))","v":""},""]
[null,null,null,null,{"$f":"IF(C10=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$3000=$C10)*(様式2A!$B$8:$B$3000=$A$6)*様式2A!$H$8:$H$3000))","v":""},""]
[null,null,null,null,{"$f":"IF(C11=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$3000=$C11)*(様式2A!$B$8:$B$3000=$A$6)*様式2A!$H$8:$H$3000))","v":""},""]
[null,null,null,null,{"$f":"IF(C12=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$3000=$C12)*(様式2A!$B$8:$B$3000=$A$6)*様式2A!$H$8:$H$3000))","v":""},""]
[null,null,null,null,{"$f":"IF(C13=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$3000=$C13)*(様式2A!$B$8:$B$3000=$A$6)*様式2A!$H$8:$H$3000))","v":""},""]
[null,null,null,null,{"$f":"IF(C14=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$3000=$C14)*(様式2A!$B$8:$B$3000=$A$6)*様式2A!$H$8:$H$3000))","v":""},""]
[null,null,null,null,{"$f":"IF(C15=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$3000=$C15)*(様式2A!$B$8:$B$3000=$A$6)*様式2A!$H$8:$H$3000))","v":""},""]
[null,null,null,null,{"$f":"IF(C16=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$3000=$C16)*(様式2A!$B$8:$B$3000=$A$6)*様式2A!$H$8:$H$3000))","v":""},""]
[null,null,null,null,{"$f":"IF(C17=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$3000=$C17)*(様式2A!$B$8:$B$3000=$A$6)*様式2A!$H$8:$H$3000))","v":""},""]
[null,null,null,null,{"$f":"IF(C18=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$3000=$C18)*(様式2A!$B$8:$B$3000=$A$6)*様式2A!$H$8:$H$3000))","v":""},""]
[null,null,null,null,{"$f":"IF(C19=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$3000=$C19)*(様式2A!$B$8:$B$3000=$A$6)*様式2A!$H$8:$H$3000))","v":""},""]
[null,null,null,null,{"$f":"IF(C20=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$3000=$C20)*(様式2A!$B$8:$B$3000=$A$6)*様式2A!$H$8:$H$3000))","v":""},""]
[null,null,null,null,{"$f":"IF(C21=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$3000=$C21)*(様式2A!$B$8:$B$3000=$A$6)*様式2A!$H$8:$H$3000))","v":""},""]
[null,null,null,null,{"$f":"IF(C22=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$3000=$C22)*(様式2A!$B$8:$B$3000=$A$6)*様式2A!$H$8:$H$3000))","v":""},""]
[null,null,null,null,{"$f":"IF(C23=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$3000=$C23)*(様式2A!$B$8:$B$3000=$A$6)*様式2A!$H$8:$H$3000))","v":""},""]
[null,null,null,null,{"$f":"IF(C24=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$3000=$C24)*(様式2A!$B$8:$B$3000=$A$6)*様式2A!$H$8:$H$3000))","v":""},""]
[null,null,null,null,{"$f":"IF(C25=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$3000=$C25)*(様式2A!$B$8:$B$3000=$A$6)*様式2A!$H$8:$H$3000))","v":""},""]
[null,null,null,null,{"$f":"IF(C26=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$3000=$C26)*(様式2A!$B$8:$B$3000=$A$6)*様式2A!$H$8:$H$3000))","v":""},""]
[null,"上記のうち","　人件費科目  計",null,null,{"$f":"IF(ISERROR(E27/D27),\"\",E27/D27)","v":""}]
[null,null,"その他の科目 計",{"$f":"D29-D27","v":0},{"$f":"E29-E27","v":0},{"$f":"IF(ISERROR(E28/D28),\"\",E28/D28)","v":""}]
["小計",null,null,{"$f":"SUBTOTAL(9,D6:D26)","v":0},{"$f":"SUBTOTAL(9,E6:E26)","v":0},{"$f":"IF(ISERROR(E29/D29),\"\",E29/D29)","v":""}]
[2021,null,null,null,{"$f":"IF(C30=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$6000=$C30)*(様式2A!$B$8:$B$6000=$A$30)*様式2A!$H$8:$H$6000))","v":""},""]
[null,null,null,null,{"$f":"IF(C31=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$6000=$C31)*(様式2A!$B$8:$B$6000=$A$30)*様式2A!$H$8:$H$6000))","v":""},""]
[null,null,null,null,{"$f":"IF(C32=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$6000=$C32)*(様式2A!$B$8:$B$6000=$A$30)*様式2A!$H$8:$H$6000))","v":""},""]
[null,null,null,null,{"$f":"IF(C33=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$6000=$C33)*(様式2A!$B$8:$B$6000=$A$30)*様式2A!$H$8:$H$6000))","v":""},""]
[null,null,null,null,{"$f":"IF(C34=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$6000=$C34)*(様式2A!$B$8:$B$6000=$A$30)*様式2A!$H$8:$H$6000))","v":""},""]
[null,null,null,null,{"$f":"IF(C35=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$6000=$C35)*(様式2A!$B$8:$B$6000=$A$30)*様式2A!$H$8:$H$6000))","v":""},""]
[null,null,null,null,{"$f":"IF(C36=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$6000=$C36)*(様式2A!$B$8:$B$6000=$A$30)*様式2A!$H$8:$H$6000))","v":""},""]
[null,null,null,null,{"$f":"IF(C37=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$6000=$C37)*(様式2A!$B$8:$B$6000=$A$30)*様式2A!$H$8:$H$6000))","v":""},""]
[null,null,null,null,{"$f":"IF(C38=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$6000=$C38)*(様式2A!$B$8:$B$6000=$A$30)*様式2A!$H$8:$H$6000))","v":""},""]
[null,null,null,null,{"$f":"IF(C39=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$6000=$C39)*(様式2A!$B$8:$B$6000=$A$30)*様式2A!$H$8:$H$6000))","v":""},""]
[null,null,null,null,{"$f":"IF(C40=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$6000=$C40)*(様式2A!$B$8:$B$6000=$A$30)*様式2A!$H$8:$H$6000))","v":""},""]
[null,null,null,null,{"$f":"IF(C41=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$6000=$C41)*(様式2A!$B$8:$B$6000=$A$30)*様式2A!$H$8:$H$6000))","v":""},""]
[null,null,null,null,{"$f":"IF(C42=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$6000=$C42)*(様式2A!$B$8:$B$6000=$A$30)*様式2A!$H$8:$H$6000))","v":""},""]
[null,null,null,null,{"$f":"IF(C43=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$6000=$C43)*(様式2A!$B$8:$B$6000=$A$30)*様式2A!$H$8:$H$6000))","v":""},""]
[null,null,null,null,{"$f":"IF(C44=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$6000=$C44)*(様式2A!$B$8:$B$6000=$A$30)*様式2A!$H$8:$H$6000))","v":""},""]
[null,null,null,null,{"$f":"IF(C45=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$6000=$C45)*(様式2A!$B$8:$B$6000=$A$30)*様式2A!$H$8:$H$6000))","v":""},""]
[null,null,null,null,{"$f":"IF(C46=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$6000=$C46)*(様式2A!$B$8:$B$6000=$A$30)*様式2A!$H$8:$H$6000))","v":""},""]
[null,null,null,null,{"$f":"IF(C47=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$6000=$C47)*(様式2A!$B$8:$B$6000=$A$30)*様式2A!$H$8:$H$6000))","v":""},""]
[null,null,null,null,{"$f":"IF(C48=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$6000=$C48)*(様式2A!$B$8:$B$6000=$A$30)*様式2A!$H$8:$H$6000))","v":""},""]
[null,null,null,null,{"$f":"IF(C49=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$6000=$C49)*(様式2A!$B$8:$B$6000=$A$30)*様式2A!$H$8:$H$6000))","v":""},""]
[null,null,null,null,{"$f":"IF(C50=\"\",\"\",SUMPRODUCT((様式2A!$F$8:$F$6000=$C50)*(様式2A!$B$8:$B$6000=$A$30)*様式2A!$H$8:$H$6000))","v":""},""]
[null,"上記のうち","　人件費科目  計",null,null,{"$f":"IF(ISERROR(E51/D51),\"\",E51/D51)","v":""}]
[null,null,"その他の科目 計",{"$f":"D53-D51","v":0},{"$f":"E53-E51","v":0},{"$f":"IF(ISERROR(E52/D52),\"\",E52/D52)","v":""}]
["小計",null,null,{"$f":"SUBTOTAL(9,D30:D50)","v":0},{"$f":"SUBTOTAL(9,E30:E50)","v":0},{"$f":"IF(ISERROR(E53/D53),\"\",E53/D53)","v":""}]

{"sheet":"様式3B","index":6,"n_rows":53,"n_cols":7,"rows_kept":53,"cut":false,"hidden":false,"merged":[[50,1,51,1],[3,1,4,1],[3,4,4,4],[3,5,4,5],[3,6,4,6],[26,1,27,1]]}
["精算様式３. 経費集計表"]
["B.","管理的経費"]
[null,null,null,null,null,"＊記入スペースは適宜増減してください。"]
["年度","財務諸表\nにおける科目","会計科目","予算","実績額","執行率\n（各年度ベース）","会計科目間流用がある場合にはその理由"]
[null,null,null,"資金計画書記載の値"]
[2020,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$3000=$A$6)*(様式5!$H$5:$H$3000=$B$2)*(様式5!$J$5:$J$3000=C6)*(様式5!$C$5:$C$3000))\n+SUMPRODUCT((様式6!$A$5:$A$3000=$A$6)*(様式6!$H$5:$H$3000=$B$2)*(様式6!$J$5:$J$3000=C6)*(様式6!$C$5:$C$3000))","v":0},{"$f":"IF(C6=\"\",\"\",SUM(E6/D6))","v":""}]
[null,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$3000=$A$6)*(様式5!$H$5:$H$3000=$B$2)*(様式5!$J$5:$J$3000=C7)*(様式5!$C$5:$C$3000))\n+SUMPRODUCT((様式6!$A$5:$A$3000=$A$6)*(様式6!$H$5:$H$3000=$B$2)*(様式6!$J$5:$J$3000=C7)*(様式6!$C$5:$C$3000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$3000=$A$6)*(様式5!$H$5:$H$3000=$B$2)*(様式5!$J$5:$J$3000=C8)*(様式5!$C$5:$C$3000))\n+SUMPRODUCT((様式6!$A$5:$A$3000=$A$6)*(様式6!$H$5:$H$3000=$B$2)*(様式6!$J$5:$J$3000=C8)*(様式6!$C$5:$C$3000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$3000=$A$6)*(様式5!$H$5:$H$3000=$B$2)*(様式5!$J$5:$J$3000=C9)*(様式5!$C$5:$C$3000))\n+SUMPRODUCT((様式6!$A$5:$A$3000=$A$6)*(様式6!$H$5:$H$3000=$B$2)*(様式6!$J$5:$J$3000=C9)*(様式6!$C$5:$C$3000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$3000=$A$6)*(様式5!$H$5:$H$3000=$B$2)*(様式5!$J$5:$J$3000=C10)*(様式5!$C$5:$C$3000))\n+SUMPRODUCT((様式6!$A$5:$A$3000=$A$6)*(様式6!$H$5:$H$3000=$B$2)*(様式6!$J$5:$J$3000=C10)*(様式6!$C$5:$C$3000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$3000=$A$6)*(様式5!$H$5:$H$3000=$B$2)*(様式5!$J$5:$J$3000=C11)*(様式5!$C$5:$C$3000))\n+SUMPRODUCT((様式6!$A$5:$A$3000=$A$6)*(様式6!$H$5:$H$3000=$B$2)*(様式6!$J$5:$J$3000=C11)*(様式6!$C$5:$C$3000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$3000=$A$6)*(様式5!$H$5:$H$3000=$B$2)*(様式5!$J$5:$J$3000=C12)*(様式5!$C$5:$C$3000))\n+SUMPRODUCT((様式6!$A$5:$A$3000=$A$6)*(様式6!$H$5:$H$3000=$B$2)*(様式6!$J$5:$J$3000=C12)*(様式6!$C$5:$C$3000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$3000=$A$6)*(様式5!$H$5:$H$3000=$B$2)*(様式5!$J$5:$J$3000=C13)*(様式5!$C$5:$C$3000))\n+SUMPRODUCT((様式6!$A$5:$A$3000=$A$6)*(様式6!$H$5:$H$3000=$B$2)*(様式6!$J$5:$J$3000=C13)*(様式6!$C$5:$C$3000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$3000=$A$6)*(様式5!$H$5:$H$3000=$B$2)*(様式5!$J$5:$J$3000=C14)*(様式5!$C$5:$C$3000))\n+SUMPRODUCT((様式6!$A$5:$A$3000=$A$6)*(様式6!$H$5:$H$3000=$B$2)*(様式6!$J$5:$J$3000=C14)*(様式6!$C$5:$C$3000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$3000=$A$6)*(様式5!$H$5:$H$3000=$B$2)*(様式5!$J$5:$J$3000=C15)*(様式5!$C$5:$C$3000))\n+SUMPRODUCT((様式6!$A$5:$A$3000=$A$6)*(様式6!$H$5:$H$3000=$B$2)*(様式6!$J$5:$J$3000=C15)*(様式6!$C$5:$C$3000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$3000=$A$6)*(様式5!$H$5:$H$3000=$B$2)*(様式5!$J$5:$J$3000=C16)*(様式5!$C$5:$C$3000))\n+SUMPRODUCT((様式6!$A$5:$A$3000=$A$6)*(様式6!$H$5:$H$3000=$B$2)*(様式6!$J$5:$J$3000=C16)*(様式6!$C$5:$C$3000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$3000=$A$6)*(様式5!$H$5:$H$3000=$B$2)*(様式5!$J$5:$J$3000=C17)*(様式5!$C$5:$C$3000))\n+SUMPRODUCT((様式6!$A$5:$A$3000=$A$6)*(様式6!$H$5:$H$3000=$B$2)*(様式6!$J$5:$J$3000=C17)*(様式6!$C$5:$C$3000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$3000=$A$6)*(様式5!$H$5:$H$3000=$B$2)*(様式5!$J$5:$J$3000=C18)*(様式5!$C$5:$C$3000))\n+SUMPRODUCT((様式6!$A$5:$A$3000=$A$6)*(様式6!$H$5:$H$3000=$B$2)*(様式6!$J$5:$J$3000=C18)*(様式6!$C$5:$C$3000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$3000=$A$6)*(様式5!$H$5:$H$3000=$B$2)*(様式5!$J$5:$J$3000=C19)*(様式5!$C$5:$C$3000))\n+SUMPRODUCT((様式6!$A$5:$A$3000=$A$6)*(様式6!$H$5:$H$3000=$B$2)*(様式6!$J$5:$J$3000=C19)*(様式6!$C$5:$C$3000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$3000=$A$6)*(様式5!$H$5:$H$3000=$B$2)*(様式5!$J$5:$J$3000=C20)*(様式5!$C$5:$C$3000))\n+SUMPRODUCT((様式6!$A$5:$A$3000=$A$6)*(様式6!$H$5:$H$3000=$B$2)*(様式6!$J$5:$J$3000=C20)*(様式6!$C$5:$C$3000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$3000=$A$6)*(様式5!$H$5:$H$3000=$B$2)*(様式5!$J$5:$J$3000=C21)*(様式5!$C$5:$C$3000))\n+SUMPRODUCT((様式6!$A$5:$A$3000=$A$6)*(様式6!$H$5:$H$3000=$B$2)*(様式6!$J$5:$J$3000=C21)*(様式6!$C$5:$C$3000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$3000=$A$6)*(様式5!$H$5:$H$3000=$B$2)*(様式5!$J$5:$J$3000=C22)*(様式5!$C$5:$C$3000))\n+SUMPRODUCT((様式6!$A$5:$A$3000=$A$6)*(様式6!$H$5:$H$3000=$B$2)*(様式6!$J$5:$J$3000=C22)*(様式6!$C$5:$C$3000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$3000=$A$6)*(様式5!$H$5:$H$3000=$B$2)*(様式5!$J$5:$J$3000=C23)*(様式5!$C$5:$C$3000))\n+SUMPRODUCT((様式6!$A$5:$A$3000=$A$6)*(様式6!$H$5:$H$3000=$B$2)*(様式6!$J$5:$J$3000=C23)*(様式6!$C$5:$C$3000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$3000=$A$6)*(様式5!$H$5:$H$3000=$B$2)*(様式5!$J$5:$J$3000=C24)*(様式5!$C$5:$C$3000))\n+SUMPRODUCT((様式6!$A$5:$A$3000=$A$6)*(様式6!$H$5:$H$3000=$B$2)*(様式6!$J$5:$J$3000=C24)*(様式6!$C$5:$C$3000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$3000=$A$6)*(様式5!$H$5:$H$3000=$B$2)*(様式5!$J$5:$J$3000=C25)*(様式5!$C$5:$C$3000))\n+SUMPRODUCT((様式6!$A$5:$A$3000=$A$6)*(様式6!$H$5:$H$3000=$B$2)*(様式6!$J$5:$J$3000=C25)*(様式6!$C$5:$C$3000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$3000=$A$6)*(様式5!$H$5:$H$3000=$B$2)*(様式5!$J$5:$J$3000=C26)*(様式5!$C$5:$C$3000))\n+SUMPRODUCT((様式6!$A$5:$A$3000=$A$6)*(様式6!$H$5:$H$3000=$B$2)*(様式6!$J$5:$J$3000=C26)*(様式6!$C$5:$C$3000))","v":0},""]
[null,"上記のうち","　人件費科目  計",null,null,{"$f":"IF(ISERROR(E27/D27),\"\",E27/D27)","v":""}]
[null,null,"その他の科目 計",{"$f":"D29-D27","v":0},{"$f":"E29-E27","v":0},{"$f":"IF(ISERROR(E28/D28),\"\",E28/D28)","v":""}]
["小計",null,null,{"$f":"SUBTOTAL(9,D6:D26)","v":0},{"$f":"SUBTOTAL(9,E6:E26)","v":0},{"$f":"IF(ISERROR(E29/D29),\"\",E29/D29)","v":""}]
[2021,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$7000=$A$30)*(様式5!$H$5:$H$7000=$B$2)*(様式5!$J$5:$J$7000=C30)*(様式5!$C$5:$C$7000))\n+SUMPRODUCT((様式6!$A$5:$A$7000=$A$30)*(様式6!$H$5:$H$7000=$B$2)*(様式6!$J$5:$J$7000=C30)*(様式6!$C$5:$C$7000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$7000=$A$30)*(様式5!$H$5:$H$7000=$B$2)*(様式5!$J$5:$J$7000=C31)*(様式5!$C$5:$C$7000))\n+SUMPRODUCT((様式6!$A$5:$A$7000=$A$30)*(様式6!$H$5:$H$7000=$B$2)*(様式6!$J$5:$J$7000=C31)*(様式6!$C$5:$C$7000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$7000=$A$30)*(様式5!$H$5:$H$7000=$B$2)*(様式5!$J$5:$J$7000=C32)*(様式5!$C$5:$C$7000))\n+SUMPRODUCT((様式6!$A$5:$A$7000=$A$30)*(様式6!$H$5:$H$7000=$B$2)*(様式6!$J$5:$J$7000=C32)*(様式6!$C$5:$C$7000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$7000=$A$30)*(様式5!$H$5:$H$7000=$B$2)*(様式5!$J$5:$J$7000=C33)*(様式5!$C$5:$C$7000))\n+SUMPRODUCT((様式6!$A$5:$A$7000=$A$30)*(様式6!$H$5:$H$7000=$B$2)*(様式6!$J$5:$J$7000=C33)*(様式6!$C$5:$C$7000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$7000=$A$30)*(様式5!$H$5:$H$7000=$B$2)*(様式5!$J$5:$J$7000=C34)*(様式5!$C$5:$C$7000))\n+SUMPRODUCT((様式6!$A$5:$A$7000=$A$30)*(様式6!$H$5:$H$7000=$B$2)*(様式6!$J$5:$J$7000=C34)*(様式6!$C$5:$C$7000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$7000=$A$30)*(様式5!$H$5:$H$7000=$B$2)*(様式5!$J$5:$J$7000=C35)*(様式5!$C$5:$C$7000))\n+SUMPRODUCT((様式6!$A$5:$A$7000=$A$30)*(様式6!$H$5:$H$7000=$B$2)*(様式6!$J$5:$J$7000=C35)*(様式6!$C$5:$C$7000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$7000=$A$30)*(様式5!$H$5:$H$7000=$B$2)*(様式5!$J$5:$J$7000=C36)*(様式5!$C$5:$C$7000))\n+SUMPRODUCT((様式6!$A$5:$A$7000=$A$30)*(様式6!$H$5:$H$7000=$B$2)*(様式6!$J$5:$J$7000=C36)*(様式6!$C$5:$C$7000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$7000=$A$30)*(様式5!$H$5:$H$7000=$B$2)*(様式5!$J$5:$J$7000=C37)*(様式5!$C$5:$C$7000))\n+SUMPRODUCT((様式6!$A$5:$A$7000=$A$30)*(様式6!$H$5:$H$7000=$B$2)*(様式6!$J$5:$J$7000=C37)*(様式6!$C$5:$C$7000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$7000=$A$30)*(様式5!$H$5:$H$7000=$B$2)*(様式5!$J$5:$J$7000=C38)*(様式5!$C$5:$C$7000))\n+SUMPRODUCT((様式6!$A$5:$A$7000=$A$30)*(様式6!$H$5:$H$7000=$B$2)*(様式6!$J$5:$J$7000=C38)*(様式6!$C$5:$C$7000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$7000=$A$30)*(様式5!$H$5:$H$7000=$B$2)*(様式5!$J$5:$J$7000=C39)*(様式5!$C$5:$C$7000))\n+SUMPRODUCT((様式6!$A$5:$A$7000=$A$30)*(様式6!$H$5:$H$7000=$B$2)*(様式6!$J$5:$J$7000=C39)*(様式6!$C$5:$C$7000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$7000=$A$30)*(様式5!$H$5:$H$7000=$B$2)*(様式5!$J$5:$J$7000=C40)*(様式5!$C$5:$C$7000))\n+SUMPRODUCT((様式6!$A$5:$A$7000=$A$30)*(様式6!$H$5:$H$7000=$B$2)*(様式6!$J$5:$J$7000=C40)*(様式6!$C$5:$C$7000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$7000=$A$30)*(様式5!$H$5:$H$7000=$B$2)*(様式5!$J$5:$J$7000=C41)*(様式5!$C$5:$C$7000))\n+SUMPRODUCT((様式6!$A$5:$A$7000=$A$30)*(様式6!$H$5:$H$7000=$B$2)*(様式6!$J$5:$J$7000=C41)*(様式6!$C$5:$C$7000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$7000=$A$30)*(様式5!$H$5:$H$7000=$B$2)*(様式5!$J$5:$J$7000=C42)*(様式5!$C$5:$C$7000))\n+SUMPRODUCT((様式6!$A$5:$A$7000=$A$30)*(様式6!$H$5:$H$7000=$B$2)*(様式6!$J$5:$J$7000=C42)*(様式6!$C$5:$C$7000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$7000=$A$30)*(様式5!$H$5:$H$7000=$B$2)*(様式5!$J$5:$J$7000=C43)*(様式5!$C$5:$C$7000))\n+SUMPRODUCT((様式6!$A$5:$A$7000=$A$30)*(様式6!$H$5:$H$7000=$B$2)*(様式6!$J$5:$J$7000=C43)*(様式6!$C$5:$C$7000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$7000=$A$30)*(様式5!$H$5:$H$7000=$B$2)*(様式5!$J$5:$J$7000=C44)*(様式5!$C$5:$C$7000))\n+SUMPRODUCT((様式6!$A$5:$A$7000=$A$30)*(様式6!$H$5:$H$7000=$B$2)*(様式6!$J$5:$J$7000=C44)*(様式6!$C$5:$C$7000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$7000=$A$30)*(様式5!$H$5:$H$7000=$B$2)*(様式5!$J$5:$J$7000=C45)*(様式5!$C$5:$C$7000))\n+SUMPRODUCT((様式6!$A$5:$A$7000=$A$30)*(様式6!$H$5:$H$7000=$B$2)*(様式6!$J$5:$J$7000=C45)*(様式6!$C$5:$C$7000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$7000=$A$30)*(様式5!$H$5:$H$7000=$B$2)*(様式5!$J$5:$J$7000=C46)*(様式5!$C$5:$C$7000))\n+SUMPRODUCT((様式6!$A$5:$A$7000=$A$30)*(様式6!$H$5:$H$7000=$B$2)*(様式6!$J$5:$J$7000=C46)*(様式6!$C$5:$C$7000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$7000=$A$30)*(様式5!$H$5:$H$7000=$B$2)*(様式5!$J$5:$J$7000=C47)*(様式5!$C$5:$C$7000))\n+SUMPRODUCT((様式6!$A$5:$A$7000=$A$30)*(様式6!$H$5:$H$7000=$B$2)*(様式6!$J$5:$J$7000=C47)*(様式6!$C$5:$C$7000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$7000=$A$30)*(様式5!$H$5:$H$7000=$B$2)*(様式5!$J$5:$J$7000=C48)*(様式5!$C$5:$C$7000))\n+SUMPRODUCT((様式6!$A$5:$A$7000=$A$30)*(様式6!$H$5:$H$7000=$B$2)*(様式6!$J$5:$J$7000=C48)*(様式6!$C$5:$C$7000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$7000=$A$30)*(様式5!$H$5:$H$7000=$B$2)*(様式5!$J$5:$J$7000=C49)*(様式5!$C$5:$C$7000))\n+SUMPRODUCT((様式6!$A$5:$A$7000=$A$30)*(様式6!$H$5:$H$7000=$B$2)*(様式6!$J$5:$J$7000=C49)*(様式6!$C$5:$C$7000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式5!$A$5:$A$7000=$A$30)*(様式5!$H$5:$H$7000=$B$2)*(様式5!$J$5:$J$7000=C50)*(様式5!$C$5:$C$7000))\n+SUMPRODUCT((様式6!$A$5:$A$7000=$A$30)*(様式6!$H$5:$H$7000=$B$2)*(様式6!$J$5:$J$7000=C50)*(様式6!$C$5:$C$7000))","v":0},""]
[null,"上記のうち","　人件費科目  計",null,null,{"$f":"IF(ISERROR(E51/D51),\"\",E51/D51)","v":""}]
[null,null,"その他の科目 計",{"$f":"D53-D51","v":0},{"$f":"E53-E51","v":0},{"$f":"IF(ISERROR(E52/D52),\"\",E52/D52)","v":""}]
["小計",null,null,{"$f":"SUBTOTAL(9,D30:D50)","v":0},{"$f":"SUBTOTAL(9,E30:E50)","v":0},{"$f":"IF(ISERROR(E53/D53),\"\",E53/D53)","v":""}]

{"sheet":"様式4","index":7,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["精算様式4. 支払証拠書類貼付台紙"]
[null,null,null,null,null,null,"番号","　　　　　　　　　　"]

{"sheet":"様式5","index":8,"n_rows":69,"n_cols":11,"rows_kept":69,"cut":false,"hidden":false,"merged":[[1,0,1,10]]}
["精算様式5. 収支管理簿",null,null,null,null,null,null,null,null,null,"＊記入スペースは適宜増減してください。"]
["収 支 管 理 簿"]
[]
["該当年度","年月日","支出金額","収入金額","指定口座残高","支払区分","支払先/受入元","目的区分","財務諸表における科目","会計科目","使途・目的・理由など"]
[{"$f":"IF(B5=\"\",\"\",IF(MONTH(B5)>=4,YEAR(B5),YEAR(B5)-1))","v":""},null,null,null,{"$f":"D5","v":0}]
[{"$f":"IF(B6=\"\",\"\",IF(MONTH(B6)>=4,YEAR(B6),YEAR(B6)-1))","v":""},null,null,null,{"$f":"IF(E5=\"\",\"\",(E5-C6+D6))","v":0}]
["",null,null,null,{"$f":"IF(E6=\"\",\"\",(E6-C7+D7))","v":0}]
[{"$f":"IF(B8=\"\",\"\",IF(MONTH(B8)>=4,YEAR(B8),YEAR(B8)-1))","v":""},null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[{"$f":"IF(B37=\"\",\"\",IF(MONTH(B37)>=4,YEAR(B37),YEAR(B37)-1))","v":""},null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
[{"$f":"IF(B51=\"\",\"\",IF(MONTH(B51)>=4,YEAR(B51),YEAR(B51)-1))","v":""},null,null,null,0]
[{"$f":"IF(B52=\"\",\"\",IF(MONTH(B52)>=4,YEAR(B52),YEAR(B52)-1))","v":""},null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
[{"$f":"IF(B62=\"\",\"\",IF(MONTH(B62)>=4,YEAR(B62),YEAR(B62)-1))","v":""},null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]

{"sheet":"様式6","index":9,"n_rows":38,"n_cols":11,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,0,1,10]]}
["精算様式6. 現金出納帳",null,null,null,null,null,null,null,null,null,"＊記入スペースは適宜増減してください。"]
["現 金 出 納 帳"]
[]
["該当年度","年月日","支出\n（戻入）","収入\n(引出額）","現金残高","支払区分","支払先","目的区分","財務諸表における科目","会計科目","使途・目的・理由など"]
[{"$f":"IF(B5=\"\",\"\",IF(MONTH(B5)>=4,YEAR(B5),YEAR(B5)-1))","v":""},null,null,null,{"$f":"D5","v":0}]
[{"$f":"IF(B6=\"\",\"\",IF(MONTH(B6)>=4,YEAR(B6),YEAR(B6)-1))","v":""},null,null,null,{"$f":"IF(E5=\"\",\"\",(E5-C6+D6))","v":0}]
["",null,null,null,{"$f":"IF(E6=\"\",\"\",(E6-C7+D7))","v":0}]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
[{"$f":"IF(B16=\"\",\"\",IF(MONTH(B16)>=4,YEAR(B16),YEAR(B16)-1))","v":""},null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]

{"sheet":"添付書類1","index":10,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["精算添付書類１. 指定口座の通帳の写し"]
[null,null,null,null,null,null,"番号","　　　　　　　　　　"]

{"sheet":"添付書類2","index":11,"n_rows":6,"n_cols":8,"rows_kept":6,"cut":false,"hidden":false,"merged":[[3,0,4,8],[5,0,8,8]]}
["精算添付書類2. 区分経理に関する会計書類"]
[null,null,null,null,null,null,"番号","　　　　　　　　　　"]
[]
["各勘定科目については、助成期間に該当するものかを判別し、助成期間に該当しないものや処理されていないものがないか等を確認のうえ、確定したものを提出してください。"]
[]
["例えば、\n①人件費：給与、社会保険料等の支払いが月末締の翌月になる場合、\n②経費：事業の進捗上緊急を要し、助成期間の終了直前に経費が発生し、経理処理の 都合上、助成期間中の支払いが困難なものなど。"]

{"sheet":"添付書類3","index":12,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["精算添付書類3. 人件費に対する賃金台帳等の写し"]
[null,null,null,null,null,null,null,"番号","　　　　　　　　　　"]
[]
["賃金台帳等（賃金計算の基礎となる事項および賃金の額）の写しのほか、按分の際には、その根拠の写しを添付して下さい。"]
["例えば、直接事業費割や時間割の場合、算出根拠となっているＰＬや勤務管理表など。"]
["また、以下の例を参考に該当者の賃金の計算方法、労働時間等を記入してください。"]
[]
["（例）"]
[null,null,"単価","×","値","×","単位","＝","月額","按分等"]
["A職員","１月",300000,"×","1人","×","1ヶ月","＝",300000,"従事割合（専従）"]
["〃","２月",300000,"×","1人","×","1ヶ月","＝",300000,"従事割合（専従）"]
["〃","〜"]
[]
["B職員","1月",2000,"×","160時間","×","１ヶ月","＝",320000,"従事時間給"]
["〃","2月",2000,"×","160時間","×","１ヶ月","＝",320000,"従事時間給"]
["〃","～"]
[]
["C職員","1月",350000,"×","1人","×","0.５按分","＝",175000,"〇事業と直接事業費割（割合0.5）"]
["〃","2月",350000,"×","1人","×","0.５按分","＝",175000,"〇事業と直接事業費割（割合0.5）"]
["〃","～"]

{"sheet":"リスト","index":13,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["列1",null,"列2"]
["直接事業費",null,"現金"]
["管理的経費",null,"振込"]
["―",null,"クレジット"]
["―",null,"振替"]
["―",null,"―"]