{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["表紙","JANPIA","様式１","様式2A","様式2B","様式3Ａ","様式3B","様式5","様式6","様式7","添付書類1","添付書類2","リスト"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":22,"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":33,"n_cols":9,"rows_kept":33,"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,"区分経理に関する会計書類"]
["（９）精算添付書類４",null,null,"実行団体からの助成金受領書"]
[]
["*2020年度緊急支援助成において「精算様式４」、「精算添付書類３」はありません。"]
[null,null,null,null,null,null,null,null,"以　上"]

{"sheet":"JANPIA","index":1,"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":"#VALUE!"}},{"$f":"J10+L10+N10+P10+R10","v":0},{"$f":"F10-G10","v":{"$error":"#VALUE!"}},{"$f":"様式１!C29","v":""},0,{"$f":"様式１!E29","v":""},0,{"$f":"様式１!F35","v":{"$error":"#DIV/0!"}},0,{"$f":"様式１!#REF!","v":{"$error":"#REF!"}},0,{"$f":"様式１!#REF!","v":{"$error":"#REF!"}},0]
[null,2020,{"$f":"E11+H10+H11","v":{"$error":"#VALUE!"}},null,{"$f":"様式１!G7","v":0},{"$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":"#DIV/0!"}},0,{"$f":"SUM(O10:O13)","v":{"$error":"#REF!"}},0,{"$f":"SUM(Q10:Q13)","v":{"$error":"#REF!"}},0]

{"sheet":"様式１","index":2,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[[11,6,12,6],[11,2,11,3],[11,4,11,5],[27,4,27,5],[27,2,27,3],[20,2,20,3],[26,2,26,3],[26,4,26,5],[21,3,22,3],[21,5,22,5],[11,0,12,0],[28,4,28,5],[11,1,12,1],[20,4,20,5],[28,2,28,3],[15,2,15,3],[15,4,15,5],[25,2,25,3],[25,4,25,5],[16,3,17,3],[16,5,17,5]]}
["精算様式１. 総括表"]
[]
["集計（A+B+C)"]
[null,"　資金分配団体の精算（Ⅰ）",null,null,"　実行団体の精算（Ⅱ）",null,null,null,"（Ⅰ+Ⅱ）"]
[null,"①助成額","②確定助成額","①-②残額","①´助成額","②´確定助成額","①´-②´残額",null,"精算金額合計"]
[null,"（資金計画）",null,"（精算金額A）",null,null,"（精算金額B）",null,"（A＋B)"]
[2020,{"$f":"C14+E14+B35","v":0},{"$f":"G17+E35","v":{"$error":"#VALUE!"}},{"$f":"B7-C7","v":{"$error":"#VALUE!"}},{"$f":"C16","v":0},null,{"$f":"E7-F7","v":0},null,{"$f":"D7+G7","v":{"$error":"#VALUE!"}}]
[2021,{"$f":"C19+E19+B36","v":0},{"$f":"G22+E36","v":{"$error":"#VALUE!"}},{"$f":"B8-C8","v":{"$error":"#VALUE!"}},{"$f":"C21","v":0},null,{"$f":"E8-F8","v":0},null,{"$f":"D8+G8","v":{"$error":"#VALUE!"}}]
["合計",{"$f":"SUM(B7:B8)","v":0},{"$f":"G28+E37","v":{"$error":"#VALUE!"}},{"$f":"B9-C9","v":{"$error":"#VALUE!"}},{"$f":"SUM(E7:E8)","v":0},null,{"$f":"E9-F9","v":0},null,{"$f":"D9+G9","v":{"$error":"#VALUE!"}}]
[]
["A.事業費実績"]
[null,null,"実行団体への助成等に充当する費用",null,"管理的経費",null,"小計"]
[null,null,"助成金","自己資金","助成金","自己資金"]
["2020年度","資金計画(交付時）",null,null,null,null,{"$f":"SUM(C14:F14)","v":0}]
[null,"資金計画(改定後）",null,null,null,null,{"$f":"SUM(C15:F15)","v":0}]
[null,"実績額",{"$f":"様式2A!F3","v":0},null,{"$f":"様式3Ａ!E21","v":0},null,0]
[null,"確定助成額",{"$f":"C$28*C$15/(C$15+C$20)","v":{"$error":"#VALUE!"}},null,{"$f":"E$28*E$15/(E$15+E$20)","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"}]
[null,"精算金額",{"$f":"C14-C17","v":{"$error":"#VALUE!"}},null,{"$f":"E14-E17","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"}]
["2021年度","資金計画(交付時）",null,null,null,null,0]
[null,"資金計画(改定後）",null,null,null,null,0]
[null,"実績額",{"$f":"様式2A!F4","v":0},null,{"$f":"様式3Ａ!E36","v":0},null,{"$f":"SUM(C21:F21)","v":0}]
[null,"確定助成額",{"$f":"C$28*C$20/(C$15+C$20)","v":{"$error":"#VALUE!"}},null,{"$f":"E$28*E$20/(E$15+E$20)","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(C22:F22)","v":{"$error":"#VALUE!"}}]
[null,"精算金額",{"$f":"C19-C22","v":{"$error":"#VALUE!"}},null,{"$f":"E19-E22","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"}]
[null,"資金計画(交付時）",{"$f":"C14+C19","v":0},0,0,0,{"$f":"SUM(C24:F24)","v":0}]
[null,"資金計画(改定後）",0,0,0,0,0]
["小計","実績額",{"$f":"C16+C21","v":0},null,{"$f":"E16+E21","v":0},null,0]
[null,"執行率",{"$f":"IF(ISERROR(IF(C26/(C25+D25)>=1,1,C26/(C25+D25))),\"\",IF(C26/(C25+D25)>=1,1,C26/(C25+D25)))","v":""},null,{"$f":"IF(ISERROR(IF(E26/(E25+F25)>=1,1,E26/(E25+F25))),\"\",IF(E26/(E25+F25)>=1,1,E26/(E25+F25)))","v":""},null,"―"]
[null,"確定助成額",{"$f":"C25*C27","v":{"$error":"#VALUE!"}},null,{"$f":"E25*E27","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"}]
[null,"精算金額",{"$f":"IF(ISERROR(C24-C28),\"\",C24-C28)","v":""},null,{"$f":"IF(ISERROR(E24-E28),\"\",E24-E28)","v":""},null,0]
[]
[]
[]
["B. プログラム・オフィサー関連経費"]
["事業年度","資金計画（交付時）","資金計画(改定後）","実績額","確定助成額","精算金額"]
[2020,null,null,{"$f":"様式2B!H3","v":0},{"$f":"$E$37*C35/$C$37","v":{"$error":"#DIV/0!"}},{"$f":"B35-E35","v":{"$error":"#DIV/0!"}}]
["2021年度",null,null,{"$f":"様式2B!H4","v":0},{"$f":"$E$37*C36/$C$37","v":{"$error":"#DIV/0!"}},{"$f":"B36-E36","v":{"$error":"#DIV/0!"}}]
["小計",{"$f":"SUM(B35:B36)","v":0},{"$f":"SUM(C35:C36)","v":0},{"$f":"SUM(D35:D36)","v":0},{"$f":"IF(D37>C37,C37,D37)","v":0},{"$f":"B37-E37","v":0}]

{"sheet":"様式2A","index":3,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[[24,0,24,3],[6,3,6,4]]}
["精算様式２. 支出明細書"]
["A．","実行団体への助成",null,"に充当される費用"]
[null,null,null,null,2020,{"$f":"SUMIF($B$8:$B$24,$E$3,$F$8:$F$24)","v":0}]
[null,null,null,null,2021,{"$f":"SUMIF($B$8:$B$24,$E$4,$F$8:$F$24)","v":0}]
[]
[]
["精算様式５の番号","年度"," 支出年月日\n（西暦/月/日）","支出先",null,"実績額（円）"]
["A-1"]
["A-2"]
["A-3"]
["A-4"]
["A-5"]
["A-6"]
["A-7"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["合計",null,null,null,null,{"$f":"SUM(F8:F24)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"実行団体からの助成金受領書"]

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

{"sheet":"様式3Ａ","index":5,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[[33,1,34,1],[18,1,19,1],[3,6,4,6],[3,1,4,1],[3,4,4,4],[3,5,4,5]]}
["精算様式３. 経費集計表"]
["A.","管理的経費"]
[null,null,null,null,null,"＊記入スペースは適宜増減してください。"]
["年度","財務諸表\nにおける科目","会計科目","予算","実績額","執行率（各年ベース）","会計科目間流用がある場合にはその理由"]
[null,null,null,"資金計画書記載の値"]
[2020,null,null,null,{"$f":"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))\n+SUMPRODUCT((様式7!$A$5:$A$3000=$A$6)*(様式7!$H$5:$H$3000=$B$2)*(様式7!$J$5:$J$3000=C6)*(様式7!$C$5:$C$3000))","v":0},{"$f":"IF(C6=\"\",\"\",SUM(E6/D6))","v":""}]
[null,null,null,null,{"$f":"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))\n+SUMPRODUCT((様式7!$A$5:$A$3000=$A$6)*(様式7!$H$5:$H$3000=$B$2)*(様式7!$J$5:$J$3000=C7)*(様式7!$C$5:$C$3000))","v":0},""]
[null,null,null,null,{"$f":"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))\n+SUMPRODUCT((様式7!$A$5:$A$3000=$A$6)*(様式7!$H$5:$H$3000=$B$2)*(様式7!$J$5:$J$3000=C8)*(様式7!$C$5:$C$3000))","v":0},""]
[null,null,null,null,{"$f":"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))\n+SUMPRODUCT((様式7!$A$5:$A$3000=$A$6)*(様式7!$H$5:$H$3000=$B$2)*(様式7!$J$5:$J$3000=C9)*(様式7!$C$5:$C$3000))","v":0},""]
[null,null,null,null,{"$f":"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))\n+SUMPRODUCT((様式7!$A$5:$A$3000=$A$6)*(様式7!$H$5:$H$3000=$B$2)*(様式7!$J$5:$J$3000=C10)*(様式7!$C$5:$C$3000))","v":0},""]
[null,null,null,null,{"$f":"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))\n+SUMPRODUCT((様式7!$A$5:$A$3000=$A$6)*(様式7!$H$5:$H$3000=$B$2)*(様式7!$J$5:$J$3000=C11)*(様式7!$C$5:$C$3000))","v":0},""]
[null,null,null,null,{"$f":"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))\n+SUMPRODUCT((様式7!$A$5:$A$3000=$A$6)*(様式7!$H$5:$H$3000=$B$2)*(様式7!$J$5:$J$3000=C12)*(様式7!$C$5:$C$3000))","v":0},""]
[null,null,null,null,{"$f":"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))\n+SUMPRODUCT((様式7!$A$5:$A$3000=$A$6)*(様式7!$H$5:$H$3000=$B$2)*(様式7!$J$5:$J$3000=C13)*(様式7!$C$5:$C$3000))","v":0},""]
[null,null,null,null,{"$f":"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))\n+SUMPRODUCT((様式7!$A$5:$A$3000=$A$6)*(様式7!$H$5:$H$3000=$B$2)*(様式7!$J$5:$J$3000=C14)*(様式7!$C$5:$C$3000))","v":0},""]
[null,null,null,null,{"$f":"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))\n+SUMPRODUCT((様式7!$A$5:$A$3000=$A$6)*(様式7!$H$5:$H$3000=$B$2)*(様式7!$J$5:$J$3000=C15)*(様式7!$C$5:$C$3000))","v":0},""]
[null,null,null,null,{"$f":"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))\n+SUMPRODUCT((様式7!$A$5:$A$3000=$A$6)*(様式7!$H$5:$H$3000=$B$2)*(様式7!$J$5:$J$3000=C16)*(様式7!$C$5:$C$3000))","v":0},""]
[null,null,null,null,{"$f":"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))\n+SUMPRODUCT((様式7!$A$5:$A$3000=$A$6)*(様式7!$H$5:$H$3000=$B$2)*(様式7!$J$5:$J$3000=C17)*(様式7!$C$5:$C$3000))","v":0},""]
[null,null,null,null,{"$f":"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))\n+SUMPRODUCT((様式7!$A$5:$A$3000=$A$6)*(様式7!$H$5:$H$3000=$B$2)*(様式7!$J$5:$J$3000=C18)*(様式7!$C$5:$C$3000))","v":0},""]
[null,"上記のうち","　人件費科目  計",{"$f":"D6","v":0}]
[null,null,"その他の科目 計",{"$f":"D21-D19","v":0},{"$f":"E21-E19","v":0}]
["小計",null,null,{"$f":"SUBTOTAL(9,D6:D18)","v":0},{"$f":"SUBTOTAL(9,E6:E18)","v":0},""]
[2021,null,null,null,{"$f":"SUMPRODUCT((様式6!$A$5:$A$6000=$A$22)*(様式6!$H$5:$H$6000=$B$2)*(様式6!$J$5:$J$6000=C22)*(様式6!$C$5:$C$6000))\n+SUMPRODUCT((様式7!$A$5:$A$6000=$A$22)*(様式7!$H$5:$H$6000=$B$2)*(様式7!$J$5:$J$6000=C22)*(様式7!$C$5:$C$6000))","v":0},{"$f":"IF(C22=\"\",\"\",SUM(E22/D22))","v":""}]
[null,null,null,null,{"$f":"SUMPRODUCT((様式6!$A$5:$A$6000=$A$22)*(様式6!$H$5:$H$6000=$B$2)*(様式6!$J$5:$J$6000=C23)*(様式6!$C$5:$C$6000))\n+SUMPRODUCT((様式7!$A$5:$A$6000=$A$22)*(様式7!$H$5:$H$6000=$B$2)*(様式7!$J$5:$J$6000=C23)*(様式7!$C$5:$C$6000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式6!$A$5:$A$6000=$A$22)*(様式6!$H$5:$H$6000=$B$2)*(様式6!$J$5:$J$6000=C24)*(様式6!$C$5:$C$6000))\n+SUMPRODUCT((様式7!$A$5:$A$6000=$A$22)*(様式7!$H$5:$H$6000=$B$2)*(様式7!$J$5:$J$6000=C24)*(様式7!$C$5:$C$6000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式6!$A$5:$A$6000=$A$22)*(様式6!$H$5:$H$6000=$B$2)*(様式6!$J$5:$J$6000=C25)*(様式6!$C$5:$C$6000))\n+SUMPRODUCT((様式7!$A$5:$A$6000=$A$22)*(様式7!$H$5:$H$6000=$B$2)*(様式7!$J$5:$J$6000=C25)*(様式7!$C$5:$C$6000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式6!$A$5:$A$6000=$A$22)*(様式6!$H$5:$H$6000=$B$2)*(様式6!$J$5:$J$6000=C26)*(様式6!$C$5:$C$6000))\n+SUMPRODUCT((様式7!$A$5:$A$6000=$A$22)*(様式7!$H$5:$H$6000=$B$2)*(様式7!$J$5:$J$6000=C26)*(様式7!$C$5:$C$6000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式6!$A$5:$A$6000=$A$22)*(様式6!$H$5:$H$6000=$B$2)*(様式6!$J$5:$J$6000=C27)*(様式6!$C$5:$C$6000))\n+SUMPRODUCT((様式7!$A$5:$A$6000=$A$22)*(様式7!$H$5:$H$6000=$B$2)*(様式7!$J$5:$J$6000=C27)*(様式7!$C$5:$C$6000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式6!$A$5:$A$6000=$A$22)*(様式6!$H$5:$H$6000=$B$2)*(様式6!$J$5:$J$6000=C28)*(様式6!$C$5:$C$6000))\n+SUMPRODUCT((様式7!$A$5:$A$6000=$A$22)*(様式7!$H$5:$H$6000=$B$2)*(様式7!$J$5:$J$6000=C28)*(様式7!$C$5:$C$6000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式6!$A$5:$A$6000=$A$22)*(様式6!$H$5:$H$6000=$B$2)*(様式6!$J$5:$J$6000=C29)*(様式6!$C$5:$C$6000))\n+SUMPRODUCT((様式7!$A$5:$A$6000=$A$22)*(様式7!$H$5:$H$6000=$B$2)*(様式7!$J$5:$J$6000=C29)*(様式7!$C$5:$C$6000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式6!$A$5:$A$6000=$A$22)*(様式6!$H$5:$H$6000=$B$2)*(様式6!$J$5:$J$6000=C30)*(様式6!$C$5:$C$6000))\n+SUMPRODUCT((様式7!$A$5:$A$6000=$A$22)*(様式7!$H$5:$H$6000=$B$2)*(様式7!$J$5:$J$6000=C30)*(様式7!$C$5:$C$6000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式6!$A$5:$A$6000=$A$22)*(様式6!$H$5:$H$6000=$B$2)*(様式6!$J$5:$J$6000=C31)*(様式6!$C$5:$C$6000))\n+SUMPRODUCT((様式7!$A$5:$A$6000=$A$22)*(様式7!$H$5:$H$6000=$B$2)*(様式7!$J$5:$J$6000=C31)*(様式7!$C$5:$C$6000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式6!$A$5:$A$6000=$A$22)*(様式6!$H$5:$H$6000=$B$2)*(様式6!$J$5:$J$6000=C32)*(様式6!$C$5:$C$6000))\n+SUMPRODUCT((様式7!$A$5:$A$6000=$A$22)*(様式7!$H$5:$H$6000=$B$2)*(様式7!$J$5:$J$6000=C32)*(様式7!$C$5:$C$6000))","v":0},""]
[null,null,null,null,{"$f":"SUMPRODUCT((様式6!$A$5:$A$6000=$A$22)*(様式6!$H$5:$H$6000=$B$2)*(様式6!$J$5:$J$6000=C33)*(様式6!$C$5:$C$6000))\n+SUMPRODUCT((様式7!$A$5:$A$6000=$A$22)*(様式7!$H$5:$H$6000=$B$2)*(様式7!$J$5:$J$6000=C33)*(様式7!$C$5:$C$6000))","v":0},""]
[null,"上記のうち","　人件費科目  計",{"$f":"D22","v":0},null,{"$f":"E34/D34","v":{"$error":"#DIV/0!"}}]
[null,null,"その他の科目 計",{"$f":"D36-D34","v":0},{"$f":"E36-E34","v":0},{"$f":"E35/D35","v":{"$error":"#DIV/0!"}}]
["小計",null,null,{"$f":"SUBTOTAL(9,D22:D33)","v":0},{"$f":"SUBTOTAL(9,E22:E33)","v":0},{"$error":"#DIV/0!"}]

{"sheet":"様式3B","index":6,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[[3,5,4,5],[3,1,4,1],[3,6,4,6],[3,4,4,4]]}
["精算様式３. 経費集計表"]
["B.","PO関連経費",null,null,null,"＊人件費が含まれる場合は、精算様式４を合わせて提出ください。"]
[null,null,null,null,null,"＊記入スペースは適宜増減してください。"]
["年度","財務諸表\nにおける科目","会計科目","予算","実績額","執行率（各年ベース）","会計科目間流用がある場合にはその理由"]
[null,null,null,"資金計画書記載の値"]
[2020,null,null,null,{"$f":"IF(C6=\"\",\"\",SUMPRODUCT((様式2B!$F$8:$F$2000=$C6)*(様式2B!$B$8:$B$2000=$A$6)*様式2B!$H$8:$H$2000))","v":""},{"$f":"IF(C6=\"\",\"\",SUM(E6/D6))","v":""}]
[null,null,null,null,{"$f":"IF(C7=\"\",\"\",SUMPRODUCT((様式2B!$F$8:$F$2000=$C7)*(様式2B!$B$8:$B$2000=$A$6)*様式2B!$H$8:$H$2000))","v":""},""]
[null,null,null,null,{"$f":"IF(C8=\"\",\"\",SUMPRODUCT((様式2B!$F$8:$F$2000=$C8)*(様式2B!$B$8:$B$2000=$A$6)*様式2B!$H$8:$H$2000))","v":""},""]
[null,null,null,null,{"$f":"IF(C9=\"\",\"\",SUMPRODUCT((様式2B!$F$8:$F$2000=$C9)*(様式2B!$B$8:$B$2000=$A$6)*様式2B!$H$8:$H$2000))","v":""},""]
[null,null,null,null,{"$f":"IF(C10=\"\",\"\",SUMPRODUCT((様式2B!$F$8:$F$2000=$C10)*(様式2B!$B$8:$B$2000=$A$6)*様式2B!$H$8:$H$2000))","v":""},""]
[null,null,null,null,{"$f":"IF(C11=\"\",\"\",SUMPRODUCT((様式2B!$F$8:$F$2000=$C11)*(様式2B!$B$8:$B$2000=$A$6)*様式2B!$H$8:$H$2000))","v":""},""]
[null,null,null,null,{"$f":"IF(C12=\"\",\"\",SUMPRODUCT((様式2B!$F$8:$F$2000=$C12)*(様式2B!$B$8:$B$2000=$A$6)*様式2B!$H$8:$H$2000))","v":""},""]
[null,null,null,null,{"$f":"IF(C13=\"\",\"\",SUMPRODUCT((様式2B!$F$8:$F$2000=$C13)*(様式2B!$B$8:$B$2000=$A$6)*様式2B!$H$8:$H$2000))","v":""},""]
[null,null,null,null,{"$f":"IF(C14=\"\",\"\",SUMPRODUCT((様式2B!$F$8:$F$2000=$C14)*(様式2B!$B$8:$B$2000=$A$6)*様式2B!$H$8:$H$2000))","v":""},""]
[null,null,null,null,{"$f":"IF(C15=\"\",\"\",SUMPRODUCT((様式2B!$F$8:$F$2000=$C15)*(様式2B!$B$8:$B$2000=$A$6)*様式2B!$H$8:$H$2000))","v":""},""]
[null,null,null,null,{"$f":"IF(C16=\"\",\"\",SUMPRODUCT((様式2B!$F$8:$F$2000=$C16)*(様式2B!$B$8:$B$2000=$A$6)*様式2B!$H$8:$H$2000))","v":""},""]
[null,null,null,null,{"$f":"IF(C17=\"\",\"\",SUMPRODUCT((様式2B!$F$8:$F$2000=$C17)*(様式2B!$B$8:$B$2000=$A$6)*様式2B!$H$8:$H$2000))","v":""},""]
[null,null,null,null,{"$f":"IF(C18=\"\",\"\",SUMPRODUCT((様式2B!$F$8:$F$2000=$C18)*(様式2B!$B$8:$B$2000=$A$6)*様式2B!$H$8:$H$2000))","v":""}]
["小計",null,null,{"$f":"SUM(D6:D18)","v":0},{"$f":"SUM(E6:E18)","v":0},{"$f":"IF(D19=\"\",\"\",E19/D19)","v":{"$error":"#DIV/0!"}}]
[2021,null,null,null,{"$f":"IF(C20=\"\",\"\",SUMPRODUCT((様式2B!$F$8:$F$2000=$C20)*(様式2B!$B$8:$B$2000=$A$20)*様式2B!$H$8:$H$2000))","v":""},{"$f":"IF(C20=\"\",\"\",SUM(E20/D20))","v":""}]
[null,null,null,null,{"$f":"IF(C21=\"\",\"\",SUMPRODUCT((様式2B!$F$8:$F$2000=$C21)*(様式2B!$B$8:$B$2000=$A$20)*様式2B!$H$8:$H$2000))","v":""},""]
[null,null,null,null,{"$f":"IF(C22=\"\",\"\",SUMPRODUCT((様式2B!$F$8:$F$2000=$C22)*(様式2B!$B$8:$B$2000=$A$20)*様式2B!$H$8:$H$2000))","v":""},""]
[null,null,null,null,{"$f":"IF(C23=\"\",\"\",SUMPRODUCT((様式2B!$F$8:$F$2000=$C23)*(様式2B!$B$8:$B$2000=$A$20)*様式2B!$H$8:$H$2000))","v":""},""]
[null,null,null,null,{"$f":"IF(C24=\"\",\"\",SUMPRODUCT((様式2B!$F$8:$F$2000=$C24)*(様式2B!$B$8:$B$2000=$A$20)*様式2B!$H$8:$H$2000))","v":""},""]
[null,null,null,null,{"$f":"IF(C25=\"\",\"\",SUMPRODUCT((様式2B!$F$8:$F$2000=$C25)*(様式2B!$B$8:$B$2000=$A$20)*様式2B!$H$8:$H$2000))","v":""},""]
[null,null,null,null,{"$f":"IF(C26=\"\",\"\",SUMPRODUCT((様式2B!$F$8:$F$2000=$C26)*(様式2B!$B$8:$B$2000=$A$20)*様式2B!$H$8:$H$2000))","v":""},""]
[null,null,null,null,{"$f":"IF(C27=\"\",\"\",SUMPRODUCT((様式2B!$F$8:$F$2000=$C27)*(様式2B!$B$8:$B$2000=$A$20)*様式2B!$H$8:$H$2000))","v":""},""]
[null,null,null,null,{"$f":"IF(C28=\"\",\"\",SUMPRODUCT((様式2B!$F$8:$F$2000=$C28)*(様式2B!$B$8:$B$2000=$A$20)*様式2B!$H$8:$H$2000))","v":""},""]
[null,null,null,null,{"$f":"IF(C29=\"\",\"\",SUMPRODUCT((様式2B!$F$8:$F$2000=$C29)*(様式2B!$B$8:$B$2000=$A$20)*様式2B!$H$8:$H$2000))","v":""},""]
[null,null,null,null,{"$f":"IF(C30=\"\",\"\",SUMPRODUCT((様式2B!$F$8:$F$2000=$C30)*(様式2B!$B$8:$B$2000=$A$20)*様式2B!$H$8:$H$2000))","v":""},""]
[null,null,null,null,{"$f":"IF(C31=\"\",\"\",SUMPRODUCT((様式2B!$F$8:$F$2000=$C31)*(様式2B!$B$8:$B$2000=$A$20)*様式2B!$H$8:$H$2000))","v":""},""]
[null,null,null,null,{"$f":"IF(C32=\"\",\"\",SUMPRODUCT((様式2B!$F$8:$F$2000=$C32)*(様式2B!$B$8:$B$2000=$A$20)*様式2B!$H$8:$H$2000))","v":""}]
["小計",null,null,{"$f":"SUM(D20:D32)","v":0},{"$f":"SUM(E20:E32)","v":0},{"$f":"IF(D33=\"\",\"\",E33/D33)","v":{"$error":"#DIV/0!"}}]

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

{"sheet":"様式6","index":8,"n_rows":36,"n_cols":11,"rows_kept":36,"cut":false,"hidden":false,"merged":[[1,0,1,10]]}
["精算様式6. 収支管理簿",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}]
["",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,{"$f":"IF(E20=\"\",\"\",(E20-C21+D21))","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]
["",null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]
[2021,null,null,null,0]
[2021,null,null,null,0]
["",null,null,null,0]
["",null,null,null,0]

{"sheet":"様式7","index":9,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,0,1,10]]}
["精算様式7. 現金出納帳",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]
["",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":"リスト","index":12,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["列1",null,"列2"]
["実行団体への助成",null,"現金"]
["PO関連経費",null,"振込"]
["管理的経費",null,"クレジット"]
["―",null,"振替"]
["―",null,"―"]