{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["新規事業","既存事業","全体","別表3インポート用マクロ","マクロ有効化の手順"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":5,"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":41,"n_cols":14,"rows_kept":41,"cut":false,"hidden":false,"merged":[[40,0,41,8],[20,13,21,13],[21,0,21,2],[22,0,22,2],[23,0,23,2],[24,0,27,1],[28,0,28,2],[20,7,21,7],[20,8,21,8],[20,9,21,9],[20,10,21,10],[20,11,21,11],[20,12,21,12],[20,6,21,6],[19,0,19,2],[20,0,20,2],[20,3,21,3],[20,4,21,4],[20,5,21,5],[17,0,18,0],[17,1,17,2],[18,1,18,2],[9,10,10,10],[9,11,10,11],[12,0,12,2],[13,0,13,2],[14,0,14,2],[15,0,15,2],[16,0,16,2],[9,12,10,12],[9,13,10,13],[10,0,10,2],[11,0,11,2],[7,13,8,13],[8,0,8,2],[9,0,9,2],[9,3,10,3],[9,4,10,4],[9,5,10,5],[9,6,10,6],[9,7,10,7],[9,8,10,8],[9,9,10,9],[7,7,8,7],[7,8,8,8],[7,9,8,9],[7,10,8,10],[7,11,8,11],[7,12,8,12],[6,0,6,2],[7,0,7,2],[7,3,8,3],[7,4,8,4],[7,5,8,5],[7,6,8,6],[5,0,5,2],[1,0,1,4],[2,0,2,6],[2,9,2,10],[2,12,2,13],[3,0,4,2]]}
["（別表３）"]
["経営計画及び資金計画（新規事業）"]
["参加中小企業者名　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　",null,null,null,null,null,null,null,null,null,null,null,"（単位　千円）"]
[null,null,null,"２年前","１年前","直近期末","１年後","２年後","３年後","４年後","５年後","６年後","７年後","８年後"]
[null,null,null,"(　年　月期)","(　年　月期)","(　年　月期)","(　年　月期)","(　年　月期)","(　年　月期)","(　年　月期)","(　年　月期)","(　年　月期)","(　年　月期)","(　年　月期)"]
["①売上高"]
["②売上原価"]
["③売上総利益",null,null,{"$f":"D6-D7","v":0},0,0,0,0,0,0,0,{"$f":"L6-L7","v":0},{"$f":"M6-M7","v":0},{"$f":"N6-N7","v":0}]
["（①－②）"]
["④販売費及び"]
["一般管理費"]
["⑤営業利益",null,null,{"$f":"D8-D10","v":0},0,0,0,0,0,0,0,{"$f":"L8-L10","v":0},{"$f":"M8-M10","v":0},{"$f":"N8-N10","v":0}]
["⑥経常利益"]
["⑦給与支給総額"]
["⑧人件費"]
["⑨設備投資額"]
["⑩運転資金"]
[null,"普通償却額"]
[null,"特別償却額"]
["⑪減価償却費",null,null,{"$f":"D18+D19","v":0},0,0,0,0,0,0,0,{"$f":"L18+L19","v":0},{"$f":"M18+M19","v":0},{"$f":"N18+N19","v":0}]
["⑫付加価値額",null,null,{"$f":"D12+D15+D20","v":0},0,0,0,0,0,0,0,0,0,0]
["（⑤＋⑧＋⑪）"]
["⑬従業員数"]
["⑭一人当たりの付加価値額\n(⑫÷⑬)",null,null,{"$f":"D21/D23","v":{"$error":"#DIV/0!"}},{"$f":"E21/E23","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"L21/L23","v":{"$error":"#DIV/0!"}},{"$f":"M21/M23","v":{"$error":"#DIV/0!"}},{"$f":"N21/N23","v":{"$error":"#DIV/0!"}}]
["⑮資金調達額（⑨＋⑩）",null,"政府系金融機関借入","－","－","－"]
[null,null,"民間金融機関借入","－","－","－"]
[null,null,"自己資金","－","－","－"]
[null,null,"その他","－","－","－"]
["合　計",null,null,"－","－","－",{"$f":"SUM(G25:G28)","v":0},0,0,0,0,0,0,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,"（はい・いいえ）"]
["　　※（例）4時間勤務のパートタイム従業員がいる（フルタイムの就業時間8時間）場合\n　　　　　　⇒0.5人で換算"]

{"sheet":"既存事業","index":1,"n_rows":41,"n_cols":14,"rows_kept":41,"cut":false,"hidden":false,"merged":[[40,0,41,8],[20,13,21,13],[21,0,21,2],[22,0,22,2],[23,0,23,2],[24,0,27,1],[28,0,28,2],[20,7,21,7],[20,8,21,8],[20,9,21,9],[20,10,21,10],[20,11,21,11],[20,12,21,12],[20,6,21,6],[19,0,19,2],[20,0,20,2],[20,3,21,3],[20,4,21,4],[20,5,21,5],[17,0,18,0],[17,1,17,2],[18,1,18,2],[9,10,10,10],[9,11,10,11],[12,0,12,2],[13,0,13,2],[14,0,14,2],[15,0,15,2],[16,0,16,2],[9,12,10,12],[9,13,10,13],[10,0,10,2],[11,0,11,2],[7,13,8,13],[8,0,8,2],[9,0,9,2],[9,3,10,3],[9,4,10,4],[9,5,10,5],[9,6,10,6],[9,7,10,7],[9,8,10,8],[9,9,10,9],[7,7,8,7],[7,8,8,8],[7,9,8,9],[7,10,8,10],[7,11,8,11],[7,12,8,12],[6,0,6,2],[7,0,7,2],[7,3,8,3],[7,4,8,4],[7,5,8,5],[7,6,8,6],[5,0,5,2],[1,0,1,5],[2,0,2,6],[2,9,2,10],[2,12,2,13],[3,0,4,2]]}
["（別表３）"]
["経営計画及び資金計画（既存事業）"]
["参加中小企業者名　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　",null,null,null,null,null,null,null,null,null,null,null,"（単位　千円）"]
[null,null,null,"２年前","１年前","直近期末","１年後","２年後","３年後","４年後","５年後","６年後","７年後","８年後"]
[null,null,null,"(　年　月期)","(　年　月期)","(　年　月期)","(　年　月期)","(　年　月期)","(　年　月期)","(　年　月期)","(　年　月期)","(　年　月期)","(　年　月期)","(　年　月期)"]
["①売上高"]
["②売上原価"]
["③売上総利益",null,null,{"$f":"D6-D7","v":0},0,0,0,0,0,0,0,{"$f":"L6-L7","v":0},{"$f":"M6-M7","v":0},{"$f":"N6-N7","v":0}]
["（①－②）"]
["④販売費及び"]
["一般管理費"]
["⑤営業利益",null,null,{"$f":"D8-D10","v":0},0,0,0,0,0,0,0,{"$f":"L8-L10","v":0},{"$f":"M8-M10","v":0},{"$f":"N8-N10","v":0}]
["⑥経常利益"]
["⑦給与支給総額"]
["⑧人件費"]
["⑨設備投資額"]
["⑩運転資金"]
[null,"普通償却額"]
[null,"特別償却額"]
["⑪減価償却費",null,null,{"$f":"D18+D19","v":0},0,0,0,0,0,0,0,{"$f":"L18+L19","v":0},{"$f":"M18+M19","v":0},{"$f":"N18+N19","v":0}]
["⑫付加価値額",null,null,{"$f":"D12+D15+D20","v":0},0,0,0,0,0,0,0,0,0,0]
["（⑤＋⑧＋⑪）"]
["⑬従業員数"]
["⑭一人当たりの付加価値額\n(⑫÷⑬)",null,null,{"$f":"D21/D23","v":{"$error":"#DIV/0!"}},{"$f":"E21/E23","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"L21/L23","v":{"$error":"#DIV/0!"}},{"$f":"M21/M23","v":{"$error":"#DIV/0!"}},{"$f":"N21/N23","v":{"$error":"#DIV/0!"}}]
["⑮資金調達額（⑨＋⑩）",null,"政府系金融機関借入","－","－","－"]
[null,null,"民間金融機関借入","－","－","－"]
[null,null,"自己資金","－","－","－"]
[null,null,"その他","－","－","－"]
["合　計",null,null,"－","－","－",{"$f":"SUM(G25:G28)","v":0},0,0,0,0,0,0,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,"（はい・いいえ）"]
["　　 ※（例）4時間勤務のパートタイム従業員がいる（フルタイムの就業時間8時間）場合\n　　　　　　 ⇒0.5人で換算"]

{"sheet":"全体","index":2,"n_rows":46,"n_cols":14,"rows_kept":46,"cut":false,"hidden":false,"merged":[[40,0,41,9],[20,13,21,13],[21,0,21,2],[22,0,22,2],[23,0,23,2],[24,0,27,1],[28,0,28,2],[20,7,21,7],[20,8,21,8],[20,9,21,9],[20,10,21,10],[20,11,21,11],[20,12,21,12],[20,6,21,6],[19,0,19,2],[20,0,20,2],[20,3,21,3],[20,4,21,4],[20,5,21,5],[17,0,18,0],[17,1,17,2],[18,1,18,2],[9,10,10,10],[9,11,10,11],[12,0,12,2],[13,0,13,2],[14,0,14,2],[15,0,15,2],[16,0,16,2],[9,12,10,12],[9,13,10,13],[10,0,10,2],[11,0,11,2],[7,13,8,13],[8,0,8,2],[9,0,9,2],[9,3,10,3],[9,4,10,4],[9,5,10,5],[9,6,10,6],[9,7,10,7],[9,8,10,8],[9,9,10,9],[7,7,8,7],[7,8,8,8],[7,9,8,9],[7,10,8,10],[7,11,8,11],[7,12,8,12],[6,0,6,2],[7,0,7,2],[7,3,8,3],[7,4,8,4],[7,5,8,5],[7,6,8,6],[5,0,5,2],[1,0,1,4],[2,0,2,6],[2,9,2,10],[2,12,2,13],[3,0,4,2]]}
["（別表３）"]
["経営計画及び資金計画（全体）"]
["参加中小企業者名　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　",null,null,null,null,null,null,null,null,null,null,null,"（単位　千円）"]
[null,null,null,"２年前","１年前","直近期末","１年後","２年後","３年後","４年後","５年後","６年後","７年後","８年後"]
[null,null,null,"(　年　月期)","(　年　月期)","(　年　月期)","(　年　月期)","(　年　月期)","(　年　月期)","(　年　月期)","(　年　月期)","(　年　月期)","(　年　月期)","(　年　月期)"]
["①売上高",null,null,{"$f":"新規事業!D6+既存事業!D6","v":0},{"$f":"新規事業!E6+既存事業!E6","v":0},{"$f":"新規事業!F6+既存事業!F6","v":0},{"$f":"新規事業!G6+既存事業!G6","v":0},{"$f":"新規事業!H6+既存事業!H6","v":0},{"$f":"新規事業!I6+既存事業!I6","v":0},{"$f":"新規事業!J6+既存事業!J6","v":0},{"$f":"新規事業!K6+既存事業!K6","v":0},{"$f":"新規事業!L6+既存事業!L6","v":0},{"$f":"新規事業!M6+既存事業!M6","v":0},{"$f":"新規事業!N6+既存事業!N6","v":0}]
["②売上原価",null,null,{"$f":"新規事業!D7+既存事業!D7","v":0},{"$f":"新規事業!E7+既存事業!E7","v":0},{"$f":"新規事業!F7+既存事業!F7","v":0},{"$f":"新規事業!G7+既存事業!G7","v":0},{"$f":"新規事業!H7+既存事業!H7","v":0},{"$f":"新規事業!I7+既存事業!I7","v":0},{"$f":"新規事業!J7+既存事業!J7","v":0},{"$f":"新規事業!K7+既存事業!K7","v":0},{"$f":"新規事業!L7+既存事業!L7","v":0},{"$f":"新規事業!M7+既存事業!M7","v":0},{"$f":"新規事業!N7+既存事業!N7","v":0}]
["③売上総利益",null,null,{"$f":"D6-D7","v":0},0,0,0,0,0,0,0,{"$f":"L6-L7","v":0},{"$f":"M6-M7","v":0},{"$f":"N6-N7","v":0}]
["（①－②）"]
["④販売費及び",null,null,{"$f":"新規事業!D10+既存事業!D10","v":0},{"$f":"新規事業!E10+既存事業!E10","v":0},{"$f":"新規事業!F10+既存事業!F10","v":0},{"$f":"新規事業!G10+既存事業!G10","v":0},{"$f":"新規事業!H10+既存事業!H10","v":0},{"$f":"新規事業!I10+既存事業!I10","v":0},{"$f":"新規事業!J10+既存事業!J10","v":0},{"$f":"新規事業!K10+既存事業!K10","v":0},{"$f":"新規事業!L10+既存事業!L10","v":0},{"$f":"新規事業!M10+既存事業!M10","v":0},{"$f":"新規事業!N10+既存事業!N10","v":0}]
["一般管理費"]
["⑤営業利益",null,null,{"$f":"D8-D10","v":0},0,0,0,0,0,0,0,{"$f":"L8-L10","v":0},{"$f":"M8-M10","v":0},{"$f":"N8-N10","v":0}]
["⑥経常利益",null,null,{"$f":"新規事業!D13+既存事業!D13","v":0},{"$f":"新規事業!E13+既存事業!E13","v":0},{"$f":"新規事業!F13+既存事業!F13","v":0},{"$f":"新規事業!G13+既存事業!G13","v":0},{"$f":"新規事業!H13+既存事業!H13","v":0},{"$f":"新規事業!I13+既存事業!I13","v":0},{"$f":"新規事業!J13+既存事業!J13","v":0},{"$f":"新規事業!K13+既存事業!K13","v":0},{"$f":"新規事業!L13+既存事業!L13","v":0},{"$f":"新規事業!M13+既存事業!M13","v":0},{"$f":"新規事業!N13+既存事業!N13","v":0}]
["⑦給与支給総額",null,null,{"$f":"新規事業!D14+既存事業!D14","v":0},{"$f":"新規事業!E14+既存事業!E14","v":0},{"$f":"新規事業!F14+既存事業!F14","v":0},{"$f":"新規事業!G14+既存事業!G14","v":0},{"$f":"新規事業!H14+既存事業!H14","v":0},{"$f":"新規事業!I14+既存事業!I14","v":0},{"$f":"新規事業!J14+既存事業!J14","v":0},{"$f":"新規事業!K14+既存事業!K14","v":0},{"$f":"新規事業!L14+既存事業!L14","v":0},{"$f":"新規事業!M14+既存事業!M14","v":0},{"$f":"新規事業!N14+既存事業!N14","v":0}]
["⑧人件費",null,null,{"$f":"新規事業!D15+既存事業!D15","v":0},{"$f":"新規事業!E15+既存事業!E15","v":0},{"$f":"新規事業!F15+既存事業!F15","v":0},{"$f":"新規事業!G15+既存事業!G15","v":0},{"$f":"新規事業!H15+既存事業!H15","v":0},{"$f":"新規事業!I15+既存事業!I15","v":0},{"$f":"新規事業!J15+既存事業!J15","v":0},{"$f":"新規事業!K15+既存事業!K15","v":0},{"$f":"新規事業!L15+既存事業!L15","v":0},{"$f":"新規事業!M15+既存事業!M15","v":0},{"$f":"新規事業!N15+既存事業!N15","v":0}]
["⑨設備投資額",null,null,{"$f":"新規事業!D16+既存事業!D16","v":0},{"$f":"新規事業!E16+既存事業!E16","v":0},{"$f":"新規事業!F16+既存事業!F16","v":0},{"$f":"新規事業!G16+既存事業!G16","v":0},{"$f":"新規事業!H16+既存事業!H16","v":0},{"$f":"新規事業!I16+既存事業!I16","v":0},{"$f":"新規事業!J16+既存事業!J16","v":0},{"$f":"新規事業!K16+既存事業!K16","v":0},{"$f":"新規事業!L16+既存事業!L16","v":0},{"$f":"新規事業!M16+既存事業!M16","v":0},{"$f":"新規事業!N16+既存事業!N16","v":0}]
["⑩運転資金",null,null,{"$f":"新規事業!D17+既存事業!D17","v":0},{"$f":"新規事業!E17+既存事業!E17","v":0},{"$f":"新規事業!F17+既存事業!F17","v":0},{"$f":"新規事業!G17+既存事業!G17","v":0},{"$f":"新規事業!H17+既存事業!H17","v":0},{"$f":"新規事業!I17+既存事業!I17","v":0},{"$f":"新規事業!J17+既存事業!J17","v":0},{"$f":"新規事業!K17+既存事業!K17","v":0},{"$f":"新規事業!L17+既存事業!L17","v":0},{"$f":"新規事業!M17+既存事業!M17","v":0},{"$f":"新規事業!N17+既存事業!N17","v":0}]
[null,"普通償却額",null,{"$f":"新規事業!D18+既存事業!D18","v":0},{"$f":"新規事業!E18+既存事業!E18","v":0},{"$f":"新規事業!F18+既存事業!F18","v":0},{"$f":"新規事業!G18+既存事業!G18","v":0},{"$f":"新規事業!H18+既存事業!H18","v":0},{"$f":"新規事業!I18+既存事業!I18","v":0},{"$f":"新規事業!J18+既存事業!J18","v":0},{"$f":"新規事業!K18+既存事業!K18","v":0},{"$f":"新規事業!L18+既存事業!L18","v":0},{"$f":"新規事業!M18+既存事業!M18","v":0},{"$f":"新規事業!N18+既存事業!N18","v":0}]
[null,"特別償却額",null,{"$f":"新規事業!D19+既存事業!D19","v":0},{"$f":"新規事業!E19+既存事業!E19","v":0},{"$f":"新規事業!F19+既存事業!F19","v":0},{"$f":"新規事業!G19+既存事業!G19","v":0},{"$f":"新規事業!H19+既存事業!H19","v":0},{"$f":"新規事業!I19+既存事業!I19","v":0},{"$f":"新規事業!J19+既存事業!J19","v":0},{"$f":"新規事業!K19+既存事業!K19","v":0},{"$f":"新規事業!L19+既存事業!L19","v":0},{"$f":"新規事業!M19+既存事業!M19","v":0},{"$f":"新規事業!N19+既存事業!N19","v":0}]
["⑪減価償却費",null,null,{"$f":"D18+D19","v":0},0,0,0,0,0,0,0,{"$f":"L18+L19","v":0},{"$f":"M18+M19","v":0},{"$f":"N18+N19","v":0}]
["⑫付加価値額",null,null,{"$f":"D12+D15+D20","v":0},0,0,0,0,0,0,0,0,0,0]
["（⑤＋⑧＋⑪）"]
["⑬従業員数",null,null,{"$f":"新規事業!D23+既存事業!D23","v":0},{"$f":"新規事業!E23+既存事業!E23","v":0},{"$f":"新規事業!F23+既存事業!F23","v":0},{"$f":"新規事業!G23+既存事業!G23","v":0},{"$f":"新規事業!H23+既存事業!H23","v":0},{"$f":"新規事業!I23+既存事業!I23","v":0},{"$f":"新規事業!J23+既存事業!J23","v":0},{"$f":"新規事業!K23+既存事業!K23","v":0},{"$f":"新規事業!L23+既存事業!L23","v":0},{"$f":"新規事業!M23+既存事業!M23","v":0},{"$f":"新規事業!N23+既存事業!N23","v":0}]
["⑭一人当たりの付加価値額\n(⑫÷⑬)",null,null,{"$f":"D21/D23","v":{"$error":"#DIV/0!"}},{"$f":"E21/E23","v":{"$error":"#DIV/0!"}},{"$f":"F21/F23","v":{"$error":"#DIV/0!"}},{"$f":"G21/G23","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"L21/L23","v":{"$error":"#DIV/0!"}},{"$f":"M21/M23","v":{"$error":"#DIV/0!"}},{"$f":"N21/N23","v":{"$error":"#DIV/0!"}}]
["⑮資金調達額（⑨＋⑩）",null,"政府系金融機関借入","－","－","－",{"$f":"新規事業!G25+既存事業!G25","v":0},{"$f":"新規事業!H25+既存事業!H25","v":0},{"$f":"新規事業!I25+既存事業!I25","v":0},{"$f":"新規事業!J25+既存事業!J25","v":0},{"$f":"新規事業!K25+既存事業!K25","v":0},{"$f":"新規事業!L25+既存事業!L25","v":0},{"$f":"新規事業!M25+既存事業!M25","v":0},{"$f":"新規事業!N25+既存事業!N25","v":0}]
[null,null,"民間金融機関借入","－","－","－",{"$f":"新規事業!G26+既存事業!G26","v":0},{"$f":"新規事業!H26+既存事業!H26","v":0},{"$f":"新規事業!I26+既存事業!I26","v":0},{"$f":"新規事業!J26+既存事業!J26","v":0},{"$f":"新規事業!K26+既存事業!K26","v":0},{"$f":"新規事業!L26+既存事業!L26","v":0},{"$f":"新規事業!M26+既存事業!M26","v":0},{"$f":"新規事業!N26+既存事業!N26","v":0}]
[null,null,"自己資金","－","－","－",{"$f":"新規事業!G27+既存事業!G27","v":0},{"$f":"新規事業!H27+既存事業!H27","v":0},{"$f":"新規事業!I27+既存事業!I27","v":0},{"$f":"新規事業!J27+既存事業!J27","v":0},{"$f":"新規事業!K27+既存事業!K27","v":0},{"$f":"新規事業!L27+既存事業!L27","v":0},{"$f":"新規事業!M27+既存事業!M27","v":0},{"$f":"新規事業!N27+既存事業!N27","v":0}]
[null,null,"その他","－","－","－",{"$f":"新規事業!G28+既存事業!G28","v":0},{"$f":"新規事業!H28+既存事業!H28","v":0},{"$f":"新規事業!I28+既存事業!I28","v":0},{"$f":"新規事業!J28+既存事業!J28","v":0},{"$f":"新規事業!K28+既存事業!K28","v":0},{"$f":"新規事業!L28+既存事業!L28","v":0},{"$f":"新規事業!M28+既存事業!M28","v":0},{"$f":"新規事業!N28+既存事業!N28","v":0}]
["合　計",null,null,"－","－","－",{"$f":"SUM(G25:G28)","v":0},0,0,0,0,0,0,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,"（はい・いいえ）"]
["　 　※（例）4時間勤務のパートタイム従業員がいる（フルタイムの就業時間8時間）場合\n　　　　　　 ⇒0.5人で換算"]
[]
[]
[null,null,null,null,"伸び率","付加価値額",null,null,{"$f":"(((I21-$F$21)/ABS($F$21))*100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"一人当たり",null,null,{"$f":"(((I24-$F$24)/ABS($F$24))*100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"経常利益",null,null,{"$f":"(((I14-$F$14)/ABS($F$14))*100)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"別表3インポート用マクロ","index":3,"n_rows":51,"n_cols":12,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["別表3インポート用CSVファイル出力の手順"]
["次のステップ１、２の順で実行してください。"]
[]
["■ステップ１"]
["「マクロ有効確認」ボタンをクリックしてください。（マクロが有効になっているか確認します）"]
["※「マクロは有効です。」（下記画像）のメッセージボックスが表示されましたら、ステップ２に進んでください。"]
["※メッセージボックスが表示されない場合、「マクロ有効化の手順」をご参照のうえ、マクロを有効化してください。"]
["マクロ有効化の手順"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["■ステップ２"]
["下表内の値が問題ないことを確認したうえで、「別表3インポート用CSVファイルに変換する」ボタンをクリックしてください。"]
["※表の下部に記載されている注意事項をよく読んでご利用ください。"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"（単位 千円）"]
[null,"2年前","1年前","直近期末","1年後","2年後","3年後","4年後","5年後","6年後","7年後","8年後"]
["①売上高",{"$f":"全体!D6","v":0},{"$f":"全体!E6","v":0},{"$f":"全体!F6","v":0},{"$f":"全体!G6","v":0},{"$f":"全体!H6","v":0},{"$f":"全体!I6","v":0},{"$f":"全体!J6","v":0},{"$f":"全体!K6","v":0},{"$f":"全体!L6","v":0},{"$f":"全体!M6","v":0},{"$f":"全体!N6","v":0}]
["②売上原価",{"$f":"全体!D7","v":0},{"$f":"全体!E7","v":0},{"$f":"全体!F7","v":0},{"$f":"全体!G7","v":0},{"$f":"全体!H7","v":0},{"$f":"全体!I7","v":0},{"$f":"全体!J7","v":0},{"$f":"全体!K7","v":0},{"$f":"全体!L7","v":0},{"$f":"全体!M7","v":0},{"$f":"全体!N7","v":0}]
["③売上総利益（①－②）",{"$f":"IFERROR(B28-B29,0)","v":0},{"$f":"IFERROR(C28-C29,0)","v":0},0,0,0,0,0,0,0,0,0]
["④販売費及び一般管理費",{"$f":"全体!D10","v":0},{"$f":"全体!E10","v":0},{"$f":"全体!F10","v":0},{"$f":"全体!G10","v":0},{"$f":"全体!H10","v":0},{"$f":"全体!I10","v":0},{"$f":"全体!J10","v":0},{"$f":"全体!K10","v":0},{"$f":"全体!L10","v":0},{"$f":"全体!M10","v":0},{"$f":"全体!N10","v":0}]
["⑤営業利益",{"$f":"IFERROR(B30-B31,0)","v":0},{"$f":"IFERROR(C30-C31,0)","v":0},0,0,0,0,0,0,0,0,0]
["⑥経常利益",{"$f":"全体!D13","v":0},{"$f":"全体!E13","v":0},{"$f":"全体!F13","v":0},{"$f":"全体!G13","v":0},{"$f":"全体!H13","v":0},{"$f":"全体!I13","v":0},{"$f":"全体!J13","v":0},{"$f":"全体!K13","v":0},{"$f":"全体!L13","v":0},{"$f":"全体!M13","v":0},{"$f":"全体!N13","v":0}]
["⑦給与支給総額",{"$f":"全体!D14","v":0},{"$f":"全体!E14","v":0},{"$f":"全体!F14","v":0},{"$f":"全体!G14","v":0},{"$f":"全体!H14","v":0},{"$f":"全体!I14","v":0},{"$f":"全体!J14","v":0},{"$f":"全体!K14","v":0},{"$f":"全体!L14","v":0},{"$f":"全体!M14","v":0},{"$f":"全体!N14","v":0}]
["⑧人件費",{"$f":"全体!D15","v":0},{"$f":"全体!E15","v":0},{"$f":"全体!F15","v":0},{"$f":"全体!G15","v":0},{"$f":"全体!H15","v":0},{"$f":"全体!I15","v":0},{"$f":"全体!J15","v":0},{"$f":"全体!K15","v":0},{"$f":"全体!L15","v":0},{"$f":"全体!M15","v":0},{"$f":"全体!N15","v":0}]
["⑨設備投資額","-","-","-",{"$f":"全体!G16","v":0},{"$f":"全体!H16","v":0},{"$f":"全体!I16","v":0},{"$f":"全体!J16","v":0},{"$f":"全体!K16","v":0},{"$f":"全体!L16","v":0},{"$f":"全体!M16","v":0},{"$f":"全体!N16","v":0}]
["⑩運転資金","-","-","-",{"$f":"全体!G17","v":0},{"$f":"全体!H17","v":0},{"$f":"全体!I17","v":0},{"$f":"全体!J17","v":0},{"$f":"全体!K17","v":0},{"$f":"全体!L17","v":0},{"$f":"全体!M17","v":0},{"$f":"全体!N17","v":0}]
["⑪減価償却費",{"$f":"IFERROR(B39+B40,0)","v":0},{"$f":"IFERROR(C39+C40,0)","v":0},0,0,0,0,0,0,0,0,0]
["普通償却額",{"$f":"全体!D18","v":0},{"$f":"全体!E18","v":0},{"$f":"全体!F18","v":0},{"$f":"全体!G18","v":0},{"$f":"全体!H18","v":0},{"$f":"全体!I18","v":0},{"$f":"全体!J18","v":0},{"$f":"全体!K18","v":0},{"$f":"全体!L18","v":0},{"$f":"全体!M18","v":0},{"$f":"全体!N18","v":0}]
["特別償却額",{"$f":"全体!D19","v":0},{"$f":"全体!E19","v":0},{"$f":"全体!F19","v":0},{"$f":"全体!G19","v":0},{"$f":"全体!H19","v":0},{"$f":"全体!I19","v":0},{"$f":"全体!J19","v":0},{"$f":"全体!K19","v":0},{"$f":"全体!L19","v":0},{"$f":"全体!M19","v":0},{"$f":"全体!N19","v":0}]
["⑫付加価値額（⑤＋⑧＋⑪）",{"$f":"IFERROR(B32+B35+B38,0)","v":0},{"$f":"IFERROR(C32+C35+C38,0)","v":0},0,0,0,0,0,0,0,0,0]
["⑬従業員数（役員含む）",{"$f":"全体!D23","v":0},{"$f":"全体!E23","v":0},{"$f":"全体!F23","v":0},{"$f":"全体!G23","v":0},{"$f":"全体!H23","v":0},{"$f":"全体!I23","v":0},{"$f":"全体!J23","v":0},{"$f":"全体!K23","v":0},{"$f":"全体!L23","v":0},{"$f":"全体!M23","v":0},{"$f":"全体!N23","v":0}]
["⑭一人当たりの付加価値額（⑫÷⑬）",{"$f":"IFERROR(ROUND(B41/B42, 0), 0)","v":0},{"$f":"IFERROR(ROUND(C41/C42, 0), 0)","v":0},0,0,0,0,0,0,0,0,0]
["⑮資金調達額（⑨＋⑩）","-","-","-",{"$f":"IFERROR(E45+E46+E47+E48,0)","v":0},{"$f":"IFERROR(F45+F46+F47+F48,0)","v":0},0,0,0,0,0,0]
["政府系金融機関借入","-","-","-",{"$f":"全体!G25","v":0},{"$f":"全体!H25","v":0},{"$f":"全体!I25","v":0},{"$f":"全体!J25","v":0},{"$f":"全体!K25","v":0},{"$f":"全体!L25","v":0},{"$f":"全体!M25","v":0},{"$f":"全体!N25","v":0}]
["民間金融機関借入","-","-","-",{"$f":"全体!G26","v":0},{"$f":"全体!H26","v":0},{"$f":"全体!I26","v":0},{"$f":"全体!J26","v":0},{"$f":"全体!K26","v":0},{"$f":"全体!L26","v":0},{"$f":"全体!M26","v":0},{"$f":"全体!N26","v":0}]
["自己資金","-","-","-",{"$f":"全体!G27","v":0},{"$f":"全体!H27","v":0},{"$f":"全体!I27","v":0},{"$f":"全体!J27","v":0},{"$f":"全体!K27","v":0},{"$f":"全体!L27","v":0},{"$f":"全体!M27","v":0},{"$f":"全体!N27","v":0}]
["その他","-","-","-",{"$f":"全体!G28","v":0},{"$f":"全体!H28","v":0},{"$f":"全体!I28","v":0},{"$f":"全体!J28","v":0},{"$f":"全体!K28","v":0},{"$f":"全体!L28","v":0},{"$f":"全体!M28","v":0},{"$f":"全体!N28","v":0}]
["注意事項"]
["・表内のセルに「半角マイナス（-）」、「半角カンマ（,）」、「小数点（.）」以外の記号が含まれないよう、参照元の値を修正してください。"]
["・変換されたファイルを保存する際、保存するフォルダ内に同名ファイルがある場合は警告なく上書き保存されます。"]

{"sheet":"マクロ有効化の手順","index":4,"n_rows":236,"n_cols":2,"rows_kept":236,"cut":false,"hidden":false,"merged":[]}
["マクロ有効化の手順"]
["マクロを有効化するにあたって、次のA、Bいずれかのパターンを実施する必要があります。"]
["上記を実施後に「マクロ有効確認」ボタンが反応しない場合は、「■マクロ有効確認ボタンが反応しない場合の対処」をご確認ください。"]
[]
["■パターンA（セキュリティ警告メッセージが表示される場合）"]
["手順A-1"]
["セキュリティ警告メッセージが表示されたら、「コンテンツの有効化」をクリックする"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["■パターンB（セキュリティ警告メッセージが表示されない場合）"]
["手順B-1","「ファイル」タブをクリックする"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["手順B-2","「オプション」をクリックする"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["手順B-3","「トラストセンター」から「トラストセンターの設定」をクリックする"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["手順B-4","「マクロの設定」で「電子署名されたマクロを除き、VBAマクロを無効にする」を選択し、「OK」をクリックする"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["手順B-5","エクセルを再起動し、パターンAの手順を実施する"]
[]
[]
["■マクロ有効確認ボタンが反応しない場合の対処"]
["手順1","「ファイル」タブをクリックする"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["手順2","「オプション」をクリックする"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["手順3","「全般」タブで[ユーザーインターフェイスのオプション] - [複数ディスプレイを使用する場合]を「互換性に対応した最適化（アプリケーションの再起動が必要）」に設定し、「OK」をクリックする"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["手順4","Excelを再起動し、「マクロ有効確認」ボタンをクリックしてメッセージボックスが表示されるか確認する"]
[]
[]
[]
["以上"]