{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["はじめに","記載例","第７号_収支予算内訳","第７号様式_収支予算書(展開枠)"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":11,"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":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"記載例","index":1,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[[16,0,16,1],[2,0,5,0],[6,0,6,1],[7,0,10,0],[11,0,11,1],[12,0,15,0],[32,0,32,1],[17,0,20,0],[21,0,21,1],[22,0,25,0],[26,0,26,1],[27,0,30,0],[31,0,31,1]]}
["収支予算内訳",null,null,null,{"$f":"+SUM(F7,F12,F27,F32)","v":737400},"単位：円"]
["費目区分","品目名","単価\n（税抜）","数量","事業費","補助対象経費\n(税抜)"]
["ソフトウェア購入費","財務会計ソフト○○",50000,1,{"$f":"+IF(B3=\"\",\"\",C3*D3)","v":50000},{"$f":"+IF(E3=\"\",\"\",E3)","v":50000}]
[null,"財務会計ソフト○○　ライセンス料",12000,1,{"$f":"+IF(B4=\"\",\"\",C4*D4)","v":12000},{"$f":"+IF(E4=\"\",\"\",E4)","v":12000}]
[null,null,null,null,"",""]
[null,null,null,null,{"$f":"+IF(B6=\"\",\"\",C6*D6)","v":""},{"$f":"+IF(E6=\"\",\"\",E6)","v":""}]
["小計",null,null,null,{"$f":"SUM(E3:E6)","v":62000},{"$f":"SUM(F3:F6)","v":62000}]
["システム\n構築費","POSレジシステム連動",450000,1,450000,450000]
[null,"既存在庫管理システムとの連動",200000,1,200000,200000]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
["小計",null,null,null,{"$f":"SUM(E8:E11)","v":650000},{"$f":"SUM(F8:F11)","v":650000}]
["導入関連経費\n（PC・タブレット・周辺機器等）\n\n※１台あたり15万円\nまで\n※補助対象経費全体の１/２以内","タブレット（メーカー・型番）",198000,2,{"$f":"+IF(B13=\"\",\"\",C13*D13)","v":396000},{"$f":"+IF(B13=\"\",\"\",IF(C13<10000,\"１万円未満\",IF(MIN(150000*D13,C13*D13)<10000,0,IF(MIN(150000*D13,C13*D13)>$E$1,IF($E$1<10000,0,$E$1),MIN(150000*D13,C13*D13)))))","v":300000},{"$f":"+IF(E13=F13,\"\",\"補助対象経費が１万円未満、150,001円以上、\nまたは補助対象経費の全体の１/２を超えました\")","v":"補助対象経費が１万円未満、150,001円以上、\nまたは補助対象経費の全体の１/２を超えました"}]
[null,null,null,null,"",{"$f":"+IF(B14=\"\",\"\",IF(C14<10000,\"１万円未満\",IF(MIN(150000*D14,C14*D14)<10000,0,IF(SUM($F$13:F13)+MIN(150000*D14,C14*D14)>$E$1,IF($E$1-SUM($F$13:F13)<10000,0,$E$1-SUM($F$13:F13)),MIN(150000*D14,C14*D14)))))","v":""},{"$f":"+IF(E14=F14,\"\",\"補助対象経費が１万円未満、150,001円以上、\nまたは補助対象経費の全体の１/２を超えました\")","v":""}]
[null,null,null,null,"",{"$f":"+IF(B15=\"\",\"\",IF(C15<10000,\"１万円未満\",IF(MIN(150000*D15,C15*D15)<10000,0,IF(SUM($F$13:F14)+MIN(150000*D15,C15*D15)>$E$1,IF($E$1-SUM($F$13:F14)<10000,0,$E$1-SUM($F$13:F14)),MIN(150000*D15,C15*D15)))))","v":""},""]
[null,null,null,null,"",{"$f":"+IF(B16=\"\",\"\",IF(C16<10000,\"１万円未満\",IF(MIN(150000*D16,C16*D16)<10000,0,IF(SUM($F$13:F15)+MIN(150000*D16,C16*D16)>$E$1,IF($E$1-SUM($F$13:F15)<10000,0,$E$1-SUM($F$13:F15)),MIN(150000*D16,C16*D16)))))","v":""},""]
["小計",null,null,null,{"$f":"SUM(E13:E16)","v":396000},{"$f":"SUM(F13:F16)","v":300000}]
["導入関連経費\n（上記以外の経費）\n\n※補助対象経費全体の１/２以内","POSレジ（メーカー・型番）",250000,1,250000,{"$f":"+IF(B18=\"\",\"\",IF(C18<10000,\"１万円未満\",IF(C18*D18<10000,0,IF(SUM($F$13:$F$16)+C18*D18>$E$1,IF($E$1-SUM($F$13:$F$16)<10000,0,$E$1-SUM($F$13:$F$16)),C18*D18))))","v":250000},{"$f":"+IF(E18=F18,\"\",\"補助対象経費が１万円未満、\nまたは補助対象経費の全体の１/２を超えました\")","v":""}]
[null,"ハンディターミナル（メーカー・型番）",75000,3,225000,{"$f":"+IF(B19=\"\",\"\",IF(C19<10000,\"１万円未満\",IF(C19*D19<10000,0,IF(SUM($F$13:$F$16,$F$18:F18)+C19*D19>$E$1,IF($E$1-SUM($F$13:$F$16,$F$18:F18)<10000,0,$E$1-SUM($F$13:$F$16,$F$18:F18)),C19*D19))))","v":187400},{"$f":"+IF(E19=F19,\"\",\"補助対象経費が１万円未満、\nまたは補助対象経費の全体の１/２を超えました\")","v":"補助対象経費が１万円未満、\nまたは補助対象経費の全体の１/２を超えました"}]
[null,null,null,null,"",{"$f":"+IF(B20=\"\",\"\",IF(C20<10000,\"１万円未満\",IF(C20*D20<10000,0,IF(SUM($F$13:$F$16,$F$18:F19)+C20*D20>$E$1,IF($E$1-SUM($F$13:$F$16,$F$18:F19)<10000,0,$E$1-SUM($F$13:$F$16,$F$18:F19)),C20*D20))))","v":""},""]
[null,null,null,null,"",{"$f":"+IF(B21=\"\",\"\",IF(C21<10000,\"１万円未満\",IF(C21*D21<10000,0,IF(SUM($F$13:$F$16,$F$18:F20)+C21*D21>$E$1,IF($E$1-SUM($F$13:$F$16,$F$18:F20)<10000,0,$E$1-SUM($F$13:$F$16,$F$18:F20)),C21*D21))))","v":""},""]
["小計",null,null,null,{"$f":"SUM(E18:E21)","v":475000},{"$f":"SUM(F18:F21)","v":437400}]
["クラウドサービス\n利用料","○○クラウド（R7年〇月〇日～〇月〇日　80日分）",130,80,10400,10400]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
["小計",null,null,null,{"$f":"SUM(E23:E26)","v":10400},{"$f":"SUM(F23:F26)","v":10400}]
["賃借料","△△リース（R7年10月～12月　3か月分）",5000,3,15000,15000]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
["小計",null,null,null,{"$f":"SUM(E28:E31)","v":15000},{"$f":"SUM(F28:F31)","v":15000}]
["合計",null,null,null,{"$f":"+SUM(E7,E12,E17,E22,E27,E32)","v":1608400},{"$f":"+IF(COUNTIF(F3:F32,\"*未満*\")>0,\"Erroerあり\",SUM(F7,F12,F17,F22,F27,F32))","v":1474800}]

{"sheet":"第７号_収支予算内訳","index":2,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[[28,0,31,0],[7,0,10,0],[2,0,5,0],[33,0,33,1],[6,0,6,1],[11,0,11,1],[16,0,16,1],[27,0,27,1],[32,0,32,1],[21,0,21,1],[12,0,15,0],[22,0,26,0],[17,0,20,0]]}
["収支予算内訳",null,null,null,{"$f":"+SUM(F7,F12,F28,F33)","v":0},"単位：円"]
["費目区分","品目名","単価\n（税抜）","数量","事業費","補助対象経費\n(税抜)"]
["ソフトウェア購入費",null,null,null,{"$f":"+IF(B3=\"\",\"\",C3*D3)","v":""},{"$f":"+IF(E3=\"\",\"\",E3)","v":""}]
[null,null,null,null,{"$f":"+IF(B4=\"\",\"\",C4*D4)","v":""},{"$f":"+IF(E4=\"\",\"\",E4)","v":""}]
[null,null,null,null,"",""]
[null,null,null,null,{"$f":"+IF(B6=\"\",\"\",C6*D6)","v":""},{"$f":"+IF(E6=\"\",\"\",E6)","v":""}]
["小計",null,null,null,{"$f":"SUM(E3:E6)","v":0},{"$f":"SUM(F3:F6)","v":0}]
["システム\n構築費",null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
["小計",null,null,null,{"$f":"SUM(E8:E11)","v":0},{"$f":"SUM(F8:F11)","v":0}]
["導入関連経費\n（PC・タブレット・周辺機器等）\n\n※１台あたり15万円\nまで\n※補助対象経費全体の１/２以内",null,null,null,{"$f":"+IF(B13=\"\",\"\",C13*D13)","v":""},{"$f":"+IF(B13=\"\",\"\",IF(C13<10000,\"１万円未満\",IF(MIN(150000*D13,C13*D13)<10000,0,IF(MIN(150000*D13,C13*D13)>$E$1,IF($E$1<10000,0,$E$1),MIN(150000*D13,C13*D13)))))","v":""},{"$f":"+IF(E13=F13,\"\",\"補助対象経費が１万円未満、150,001円以上、\nまたは補助対象経費の全体の１/２を超えました\")","v":""}]
[null,null,null,null,"",{"$f":"+IF(B14=\"\",\"\",IF(C14<10000,\"１万円未満\",IF(MIN(150000*D14,C14*D14)<10000,0,IF(SUM($F$13:F13)+MIN(150000*D14,C14*D14)>$E$1,IF($E$1-SUM($F$13:F13)<10000,0,$E$1-SUM($F$13:F13)),MIN(150000*D14,C14*D14)))))","v":""},{"$f":"+IF(E14=F14,\"\",\"補助対象経費が１万円未満、150,001円以上、\nまたは補助対象経費の全体の１/２を超えました\")","v":""}]
[null,null,null,null,"",{"$f":"+IF(B15=\"\",\"\",IF(C15<10000,\"１万円未満\",IF(MIN(150000*D15,C15*D15)<10000,0,IF(SUM($F$13:F14)+MIN(150000*D15,C15*D15)>$E$1,IF($E$1-SUM($F$13:F14)<10000,0,$E$1-SUM($F$13:F14)),MIN(150000*D15,C15*D15)))))","v":""},""]
[null,null,null,null,"",{"$f":"+IF(B16=\"\",\"\",IF(C16<10000,\"１万円未満\",IF(MIN(150000*D16,C16*D16)<10000,0,IF(SUM($F$13:F15)+MIN(150000*D16,C16*D16)>$E$1,IF($E$1-SUM($F$13:F15)<10000,0,$E$1-SUM($F$13:F15)),MIN(150000*D16,C16*D16)))))","v":""},""]
["小計",null,null,null,{"$f":"SUM(E13:E16)","v":0},{"$f":"SUM(F13:F16)","v":0}]
["導入関連経費\n（上記以外の経費）\n\n※補助対象経費全体の１/２以内",null,null,null,"",{"$f":"+IF(B18=\"\",\"\",IF(C18<10000,\"１万円未満\",IF(C18*D18<10000,0,IF($F$17+C18*D18>$E$1,IF($E$1-$F$17<10000,0,$E$1-$F$17),C18*D18))))","v":""},{"$f":"+IF(E18=F18,\"\",\"補助対象経費が１万円未満、\nまたは補助対象経費の全体の１/２を超えました\")","v":""}]
[null,null,null,null,"",{"$f":"+IF(B19=\"\",\"\",IF(C19<10000,\"１万円未満\",IF(C19*D19<10000,0,IF(SUM($F$17,$F$18:F18)+C19*D19>$E$1,IF($E$1-SUM($F$17,$F$18:F18)<10000,0,$E$1-SUM($F$17,$F$18:F18)),C19*D19))))","v":""},{"$f":"+IF(E19=F19,\"\",\"補助対象経費が１万円未満、\nまたは補助対象経費の全体の１/２を超えました\")","v":""}]
[null,null,null,null,"",{"$f":"+IF(B20=\"\",\"\",IF(C20<10000,\"１万円未満\",IF(C20*D20<10000,0,IF(SUM($F$17,$F$18:F19)+C20*D20>$E$1,IF($E$1-SUM($F$17,$F$18:F19)<10000,0,$E$1-SUM($F$17,$F$18:F19)),C20*D20))))","v":""},""]
[null,null,null,null,"",{"$f":"+IF(B21=\"\",\"\",IF(C21<10000,\"１万円未満\",IF(C21*D21<10000,0,IF(SUM($F$17,$F$18:F20)+C21*D21>$E$1,IF($E$1-SUM($F$17,$F$18:F20)<10000,0,$E$1-SUM($F$17,$F$18:F20)),C21*D21))))","v":""},""]
["小計",null,null,null,{"$f":"SUM(E18:E21)","v":0},{"$f":"SUM(F18:F21)","v":0}]
["クラウドサービス\n利用料",null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,{"$f":"IF(B27=\"\",\"\",C27*D27)","v":""},""]
["小計",null,null,null,{"$f":"SUM(E23:E27)","v":0},{"$f":"SUM(F23:F27)","v":0}]
["賃借料",null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
["小計",null,null,null,{"$f":"SUM(E29:E32)","v":0},{"$f":"SUM(F29:F32)","v":0}]
["合計",null,null,null,{"$f":"+SUM(E7,E12,E17,E22,E28,E33)","v":0},{"$f":"+IF(COUNTIF(F3:F33,\"*未満*\")>0,\"Erroerあり\",SUM(F7,F12,F17,F22,F28,F33))","v":0}]

{"sheet":"第７号様式_収支予算書(展開枠)","index":3,"n_rows":27,"n_cols":21,"rows_kept":27,"cut":false,"hidden":false,"merged":[[12,0,13,0],[12,1,13,10],[13,11,13,14],[13,16,13,19],[19,1,19,3],[16,4,17,8],[16,1,17,3],[18,9,18,14],[19,9,19,14],[16,9,17,14],[16,15,17,20],[18,15,18,20],[19,15,19,20],[1,0,1,20],[4,0,11,0],[4,1,6,10],[4,11,6,15],[4,16,6,20],[7,1,7,10],[7,11,7,15],[7,16,7,20],[8,1,8,10],[8,11,8,15],[8,16,8,20],[9,1,9,10],[9,11,9,15],[9,16,9,20],[10,1,10,10],[10,11,10,15],[10,16,10,20],[22,4,22,8],[22,16,22,19],[26,15,26,20],[11,1,11,10],[11,11,11,15],[11,16,11,20],[18,4,18,8],[19,4,19,8],[18,1,18,3]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"別紙２"]
["収　支　予　算　書"]
[]
["１．収支予算書　　　　　　　　　　　　　　　　　　　　　　　　　　　　",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"単位：円"]
["事\n\n業\n\n経\n\n費","費用区分",null,null,null,null,null,null,null,null,null,"総事業費\n（税抜）",null,null,null,null,"補助対象経費\n(税抜)"]
[]
[]
[null,"ソフトウェア購入費",null,null,null,null,null,null,null,null,null,{"$f":"第７号_収支予算内訳!E7","v":0},null,null,null,null,{"$f":"第７号_収支予算内訳!F7","v":0}]
[null,"システム構築費",null,null,null,null,null,null,null,null,null,{"$f":"第７号_収支予算内訳!E12","v":0},null,null,null,null,{"$f":"第７号_収支予算内訳!F12","v":0}]
[null,"導入関連経費",null,null,null,null,null,null,null,null,null,{"$f":"SUM(第７号_収支予算内訳!E17,第７号_収支予算内訳!E22)","v":0},null,null,null,null,{"$f":"SUM(第７号_収支予算内訳!F17,第７号_収支予算内訳!F22)","v":0}]
[null,"クラウドサービス利用料",null,null,null,null,null,null,null,null,null,{"$f":"第７号_収支予算内訳!E28","v":0},null,null,null,null,{"$f":"第７号_収支予算内訳!F28","v":0}]
[null,"賃借料",null,null,null,null,null,null,null,null,null,{"$f":"第７号_収支予算内訳!E33","v":0},null,null,null,null,{"$f":"第７号_収支予算内訳!F33","v":0}]
[null,"合　計",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（Ａ）"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L8:P12)","v":0},null,null,null,"円",{"$f":"SUM(Q8:U12)","v":0},null,null,null,"円"]
[null," ※「導入関連経費の総額」及び「導入経費におけるＰＣ・タブレット・周辺機器」"]
[null,null,"における要件は以下のとおり。"]
[null,"支援枠",null,null,"導入関連経費の総額",null,null,null,null,"ハードウェアの\n補助対象経費",null,null,null,null,null,"ＰＣ・タブレット・周辺機器等の購入上限額"]
[]
[null,"デジタル\n導入枠",null,null,"上限なし",null,null,null,null,"・補助対象経費となるのは\n　１個あたり税抜価格\n　１万円以上の商品のみ",null,null,null,null,null,"・総額（税抜価格）上限\n　15万円まで"]
[null,"デジタル\n展開枠",null,null,"・補助対象経費全体の　１／２以内",null,null,null,null,"・補助対象経費となるのは\n　１個あたり税抜価格\n　１万円以上の商品のみ",null,null,null,null,null,"・１台当たりの価格（税抜\n　価格）上限15万円まで"]
[]
["２　補助申請額"]
[null,"（Ａ）",null,null,{"$f":"Q14","v":0},null,null,null,null,null,"×　２／３　＝",null,null,null,"（Ｂ）",null,{"$f":"INT(E23* 2/3)","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,{"$f":"IF(INT(Q23/1000)>=1000,1000,INT(Q23/1000))","v":0}]