{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["別表3 既存事業","別表3 新規事業","別表3（合算）"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"別表3 既存事業","index":0,"n_rows":48,"n_cols":25,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,18,0,20],[2,3,2,7],[2,0,2,2],[35,1,35,6],[36,1,36,6],[2,9,2,13],[3,0,4,2],[37,1,37,7],[5,0,5,2],[6,0,6,2],[7,0,7,2],[8,0,8,2],[25,1,26,1],[27,1,28,1],[29,1,30,1],[15,1,15,2],[16,1,16,2],[39,1,39,5],[31,0,31,2],[33,1,33,4],[9,0,9,2],[10,0,10,2],[11,0,11,2],[12,0,12,2],[13,0,13,2],[14,0,14,2],[21,0,29,0],[17,0,17,2],[18,0,18,2],[19,0,19,2],[20,0,20,2],[21,1,22,1],[23,1,24,1]]}
["別表３　(既存事業）",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,{"$f":"IF(V1<=5,\"\",\"エラーコード\")","v":""}]
["中小企業者名",null,null,null,null,null,null,null,null,"（単位：千円）",null,null,null,null,"フリー編集場"]
[null,null,null,"２年前","１年前","直近期末","１年後","２年後","３年後","４年後","５年後","６年後","７年後","８年後"]
[null,null,null,"(　　　年　月期）","(　　　年　月期）","(　　　年　月期）","(　　　年　月期）","(　　　年　月期）","(　　　年　月期）","(　　　年　月期）","(　　　年　月期）","(　　　年　月期）","(　　　年　月期）","(　　　年　月期）","※H30年6月期　や　R2年3月期　と入力"]
["①売上高",null,null,null,null,null,null,null,null,null,null,null,null,null,"2年前","１年前","直近期末","1年後","２年後","３年後","４年後","５年後","６年後","７年後","８年後"]
["②売上原価",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D7/D6","v":{"$error":"#DIV/0!"}},{"$f":"E7/E6","v":{"$error":"#DIV/0!"}},{"$f":"F7/F6","v":{"$error":"#DIV/0!"}},{"$f":"G7/G6","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["③売上総利益\n(①－②）",null,null,{"$f":"D6-D7","v":0},{"$f":"E6-E7","v":0},0,0,0,0,0,0,{"$f":"L6-L7","v":0},0,0]
["④販売費及び\n一般管理費",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D9/D6","v":{"$error":"#DIV/0!"}},{"$f":"E9/E6","v":{"$error":"#DIV/0!"}},{"$f":"F9/F6","v":{"$error":"#DIV/0!"}},{"$f":"G9/G6","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["⑤営業利益",null,null,{"$f":"D8-D9","v":0},{"$f":"E8-E9","v":0},0,0,0,0,{"$f":"J8-J9","v":0},0,{"$f":"L8-L9","v":0},{"$f":"M8-M9","v":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,null,null,null,null,null,null,"※売上原価に含まれる労務費（福利厚生費や退職金等含む）＋販管費に含まれる役員給与＋従業員給与＋賞与＋賞与引当金繰入＋福利厚生費＋退職金＋退職給与引当金繰入＋派遣労働者・パート社員給与等"]
["⑨設備投資額"]
["⑩運転資金"]
[null,"普通償却額"]
[null,"特別償却額",null,null,null,null,null,null,null,null,null,null,null,null,"※売上原価又は販管費に計上されている場合のみ記載。　※特別損失計上額は記載不要。"]
["⑪減価償却費",null,null,{"$f":"D16+D17","v":0},{"$f":"E16+E17","v":0},{"$f":"F16+F17","v":0},0,0,0,0,0,0,0,0]
["⑫付加価値額\n（⑤＋⑧＋⑪）",null,null,{"$f":"D10+D13+D18","v":0},{"$f":"E10+E13+E18","v":0},0,0,0,0,0,0,{"$f":"L10+L13+L18","v":0},0,0,null,null,null,null,"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  "]
["⑬従業員数",null,null,null,null,null,null,null,null,null,null,null,null,null,"※正規従業員の他、代表者＋役員＋パート等（就業時間等換算：就業8時間の内、パート4時間であれば0.5人）を含む"]
["⑭一人当たりの付加価値額（⑫÷⑬）",null,null,{"$f":"IF(D20>0,ROUND(D19/D20,0),0)","v":0},{"$f":"IF(E20>0,ROUND(E19/E20,0),0)","v":0},0,0,0,0,0,0,{"$f":"IF(L20>0,ROUND(L19/L20,0),0)","v":0},0,0]
["⑮資金調達額　⑨＋⑩","政府系\n金融機関\n借入","設備","-","-","-"]
[null,null,"運転","-","-","-"]
[null,"県制度\n融資借入","設備","-","-","-"]
[null,null,"運転","-","-","-"]
[null,"民間金融\n機関借入","設備","-","-","-"]
[null,null,"運転","-","-","-"]
[null,"自己資金","設備","-","-","-"]
[null,null,"運転","-","-","-"]
[null,"その他","設備","-","-","-"]
[null,null,"運転","-","-","-"]
["合　　　計",null,null,"-","-","-",{"$f":"SUM(G22:G31)","v":0},0,0,0,0,0,{"$f":"SUM(M22:M31)","v":0},0]
[null,null,null,null,null,null,{"$f":"IF(G14+G15=G32,\"\",\"NG!\")","v":""},{"$f":"IF(H14+H15=H32,\"\",\"NG!\")","v":""},{"$f":"IF(I14+I15=I32,\"\",\"NG!\")","v":""},{"$f":"IF(J14+J15=J32,\"\",\"NG!\")","v":""},{"$f":"IF(K14+K15=K32,\"\",\"NG!\")","v":""},{"$f":"IF(L14+L15=L32,\"\",\"NG!\")","v":""},"",""]
[null,"（各種指標の算出式）"]
[null,"「給与支給総額」：給料＋賃金＋賞与＋各種手当（所得：残業手当、休日出勤手当、扶養手当、住宅手当等含む）"]
[null,"「付加価値額」：営業利益＋人件費＋減価償却費"]
[null,"「一人当たりの付加価値額」：付加価値額÷従業員数"]
[null,"「営業利益」：売上総利益（売上高－売上原価）－販売費及び一般管理費"]
[]
[null,"（付加価値額等の算出方法）"]
[null,"人数、人件費に短時間労働者、派遣労働者に対する費用を算入しましたか。",null,null,null,null,null,null,{"$f":"IF(I46=TRUE,\"はい\",\"いいえ\")","v":"いいえ"},{"$f":"IF(I46=TRUE,\"\",\"ＮＧ\")","v":"ＮＧ"}]
[null,"減価償却費にリース費用を算入しましたか。",null,null,null,null,null,null,{"$f":"IF(I47=TRUE,\"はい\",\"いいえ\")","v":"いいえ"},{"$f":"IF(I47=TRUE,\"\",\"ＮＧ\")","v":"ＮＧ"}]
[null,"従業員数について就業時間による調整を行いましたか。",null,null,null,null,null,null,{"$f":"IF(I48=TRUE,\"はい\",\"いいえ\")","v":"いいえ"},{"$f":"IF(I48=TRUE,\"\",\"ＮＧ\")","v":"ＮＧ"}]
[]
[]
[null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,false]

{"sheet":"別表3 新規事業","index":1,"n_rows":48,"n_cols":25,"rows_kept":48,"cut":false,"hidden":false,"merged":[[2,9,2,13],[2,0,2,2],[2,3,2,7],[35,1,35,6],[36,1,36,6],[3,0,4,2],[37,1,37,7],[5,0,5,2],[6,0,6,2],[7,0,7,2],[8,0,8,2],[14,0,14,2],[17,0,17,2],[18,0,18,2],[15,1,15,2],[16,1,16,2],[39,1,39,5],[33,1,33,4],[31,0,31,2],[9,0,9,2],[10,0,10,2],[11,0,11,2],[12,0,12,2],[20,0,20,2],[21,0,29,0],[21,1,22,1],[23,1,24,1],[25,1,26,1],[27,1,28,1],[29,1,30,1],[19,0,19,2],[13,0,13,2]]}
["別表３　（新規事業）"]
["経営計画及び資金計画"]
["中小企業者名",null,null,{"$f":"IF('別表3 既存事業'!D3:H3=\"\",\"シート別表3既存事業に事業者名を入力してください\",'別表3 既存事業'!D3:H3)","v":"シート別表3既存事業に事業者名を入力してください"},null,null,null,null,null,"（単位：千円）",null,null,null,null,"フリー編集場"]
[null,null,null,"2年前","１年前","直近期末","1年後","２年後","３年後","４年後","５年後","６年後","７年後","８年後"]
[null,null,null,{"$f":"'別表3 既存事業'!D5","v":"(　　　年　月期）"},{"$f":"'別表3 既存事業'!E5","v":"(　　　年　月期）"},{"$f":"'別表3 既存事業'!F5","v":"(　　　年　月期）"},{"$f":"'別表3 既存事業'!G5","v":"(　　　年　月期）"},{"$f":"'別表3 既存事業'!H5","v":"(　　　年　月期）"},{"$f":"'別表3 既存事業'!I5","v":"(　　　年　月期）"},{"$f":"'別表3 既存事業'!J5","v":"(　　　年　月期）"},{"$f":"'別表3 既存事業'!K5","v":"(　　　年　月期）"},{"$f":"'別表3 既存事業'!L5","v":"(　　　年　月期）"},{"$f":"'別表3 既存事業'!M5","v":"(　　　年　月期）"},{"$f":"'別表3 既存事業'!N5","v":"(　　　年　月期）"},"※赤字の場合は、シート別表３既存事業の決算期を入力してください。"]
["①売上高",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1年後","２年後","３年後","４年後","５年後","６年後","７年後","８年後"]
["②売上原価",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G7/G6","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["③売上総利益\n(①－②）",null,null,null,null,null,{"$f":"G6-G7","v":0},{"$f":"H6-H7","v":0},{"$f":"I6-I7","v":0},{"$f":"J6-J7","v":0},{"$f":"K6-K7","v":0},{"$f":"L6-L7","v":0},0,0]
["④販売費及び\n一般管理費",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G9/G6","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["⑤営業利益",null,null,null,null,null,{"$f":"G8-G9","v":0},{"$f":"H8-H9","v":0},{"$f":"I8-I9","v":0},{"$f":"J8-J9","v":0},{"$f":"K8-K9","v":0},{"$f":"L8-L9","v":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,null,null,null,null,null,null,"※売上原価に含まれる労務費（福利厚生費や退職金等含む）＋販管費に含まれる役員給与＋従業員給与＋賞与＋賞与引当金繰入＋福利厚生費＋退職金＋退職給与引当金繰入等"]
["⑨設備投資額"]
["⑩運転資金"]
[null,"普通償却額"]
[null,"特別償却額",null,null,null,null,null,null,null,null,0,0,0,0,"※売上原価又は販管費に計上されている場合のみ記載。　※特別損失計上額は記載不要。"]
["⑪減価償却費",null,null,null,null,null,{"$f":"G16+G17","v":0},{"$f":"H16+H17","v":0},0,0,0,0,0,0]
["⑫付加価値額\n（⑤＋⑧＋⑪）",null,null,null,null,null,{"$f":"G10+G13+G18","v":0},{"$f":"H10+H13+H18","v":0},{"$f":"I10+I13+I18","v":0},{"$f":"J10+J13+J18","v":0},{"$f":"K10+K13+K18","v":0},{"$f":"L10+L13+L18","v":0},0,0]
["⑬従業員数",null,null,null,null,null,null,null,null,null,null,null,null,null,"※正規従業員の他、代表者＋役員＋パート等（就業時間等換算：就業8時間の内、パート4時間であれば0.5人）を含む"]
["⑭一人当たりの付加価値額（⑫÷⑬）",null,null,null,null,null,{"$f":"IF(G20>0,ROUND(G19/G20,0),0)","v":0},{"$f":"IF(H20>0,ROUND(H19/H20,0),0)","v":0},{"$f":"IF(I20>0,ROUND(I19/I20,0),0)","v":0},{"$f":"IF(J20>0,ROUND(J19/J20,0),0)","v":0},{"$f":"IF(K20>0,ROUND(K19/K20,0),0)","v":0},{"$f":"IF(L20>0,ROUND(L19/L20,0),0)","v":0},0,0]
["⑮資金調達額　⑨＋⑩","政府系\n金融機関\n借入","設備","-","-","-"]
[null,null,"運転","-","-","-"]
[null,"県制度\n融資借入","設備","-","-","-"]
[null,null,"運転","-","-","-"]
[null,"民間金融\n機関借入","設備","-","-","-"]
[null,null,"運転","-","-","-"]
[null,"自己資金","設備","-","-","-"]
[null,null,"運転","-","-","-"]
[null,"その他","設備","-","-","-"]
[null,null,"運転","-","-","-"]
["合　　　計",null,null,"-","-","-",{"$f":"SUM(G22:G31)","v":0},{"$f":"SUM(H22:H31)","v":0},{"$f":"SUM(I22:I31)","v":0},{"$f":"SUM(J22:J31)","v":0},{"$f":"SUM(K22:K31)","v":0},{"$f":"SUM(L22:L31)","v":0},0,0]
[null,null,null,null,null,null,{"$f":"IF(G14+G15=G32,\"\",\"NG!\")","v":""},{"$f":"IF(H14+H15=H32,\"\",\"NG!\")","v":""},{"$f":"IF(I14+I15=I32,\"\",\"NG!\")","v":""},{"$f":"IF(J14+J15=J32,\"\",\"NG!\")","v":""},{"$f":"IF(K14+K15=K32,\"\",\"NG!\")","v":""},{"$f":"IF(L14+L15=L32,\"\",\"NG!\")","v":""},"",""]
[null,"（各種指標の算出式）"]
[null,"「給与支給総額」：給料＋賃金＋賞与＋各種手当（所得：残業手当、休日出勤手当、扶養手当、住宅手当等含む）"]
[null,"「付加価値額」：営業利益＋人件費＋減価償却費"]
[null,"「一人当たりの付加価値額」：付加価値額÷従業員数"]
[null,"「営業利益」：売上総利益（売上高－売上原価）－販売費及び一般管理費"]
[]
[null,"（付加価値額等の算出方法）"]
[null,"人数、人件費に短時間労働者、派遣労働者に対する費用を算入しましたか。",null,null,null,null,null,null,{"$f":"IF(I46=TRUE,\"はい\",\"いいえ\")","v":"いいえ"},{"$f":"IF(I46=TRUE,\"\",\"ＮＧ\")","v":"ＮＧ"}]
[null,"減価償却費にリース費用を算入しましたか。",null,null,null,null,null,null,{"$f":"IF(I47=TRUE,\"はい\",\"いいえ\")","v":"いいえ"},{"$f":"IF(I47=TRUE,\"\",\"ＮＧ\")","v":"ＮＧ"}]
[null,"従業員数について就業時間による調整を行いましたか。",null,null,null,null,null,null,{"$f":"IF(I48=TRUE,\"はい\",\"いいえ\")","v":"いいえ"},"ＮＧ"]
[]
[]
[null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,false]

{"sheet":"別表3（合算）","index":2,"n_rows":42,"n_cols":25,"rows_kept":42,"cut":false,"hidden":false,"merged":[[2,9,2,13],[2,0,2,2],[2,3,2,7],[27,1,27,4],[29,1,29,6],[3,0,4,2],[5,0,5,2],[6,0,6,2],[7,0,7,2],[8,0,8,2],[14,0,14,2],[17,0,17,2],[18,0,18,2],[19,0,19,2],[20,0,20,2],[15,1,15,2],[16,1,16,2],[9,0,9,2],[10,0,10,2],[11,0,11,2],[12,0,12,2],[13,0,13,2],[33,1,33,5],[21,1,21,2],[21,0,25,0],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[31,1,31,7],[30,1,30,6]]}
["（別表３）　(合算）",null,null,null,null,null,null,null,null,null,null,null,null,null,"研究期間",{"$f":"'別表3 既存事業'!V1","v":0},"年間"]
["経営計画及び資金計画",null,null,null,null,null,null,null,null,null,null,null,null,null,"事業開始",{"$f":"P1+1","v":1},"年後～"]
["中小企業者名",null,null,{"$f":"IF('別表3 既存事業'!D3:H3=\"\",\"シート別表3既存事業に事業者名を入力してください\",'別表3 既存事業'!D3:H3)","v":"シート別表3既存事業に事業者名を入力してください"},null,null,null,null,null,"（単位：千円）",null,null,null,null,"フリー編集場"]
[null,null,null,"2年前","１年前","直近期末","1年後","２年後","３年後","４年後","５年後","６年後","７年後","８年後"]
[null,null,null,{"$f":"'別表3 既存事業'!D5","v":"(　　　年　月期）"},{"$f":"'別表3 既存事業'!E5","v":"(　　　年　月期）"},{"$f":"'別表3 既存事業'!F5","v":"(　　　年　月期）"},{"$f":"'別表3 既存事業'!G5","v":"(　　　年　月期）"},{"$f":"'別表3 既存事業'!H5","v":"(　　　年　月期）"},{"$f":"'別表3 既存事業'!I5","v":"(　　　年　月期）"},{"$f":"'別表3 既存事業'!J5","v":"(　　　年　月期）"},{"$f":"'別表3 既存事業'!K5","v":"(　　　年　月期）"},{"$f":"'別表3 既存事業'!L5","v":"(　　　年　月期）"},{"$f":"'別表3 既存事業'!M5","v":"(　　　年　月期）"},{"$f":"'別表3 既存事業'!N5","v":"(　　　年　月期）"},"※赤字の場合は、シート別表３既存事業の決算期を入力してください。"]
["①売上高",null,null,{"$f":"'別表3 既存事業'!D6","v":0},{"$f":"'別表3 既存事業'!E6","v":0},{"$f":"'別表3 既存事業'!F6","v":0},{"$f":"'別表3 既存事業'!G6+'別表3 新規事業'!G6","v":0},{"$f":"'別表3 既存事業'!H6+'別表3 新規事業'!H6","v":0},{"$f":"'別表3 既存事業'!I6+'別表3 新規事業'!I6","v":0},{"$f":"'別表3 既存事業'!J6+'別表3 新規事業'!J6","v":0},{"$f":"'別表3 既存事業'!K6+'別表3 新規事業'!K6","v":0},{"$f":"'別表3 既存事業'!L6+'別表3 新規事業'!L6","v":0},{"$f":"'別表3 既存事業'!M6+'別表3 新規事業'!M6","v":0},{"$f":"'別表3 既存事業'!N6+'別表3 新規事業'!N6","v":0},"2年前","１年前","直近期末","1年後","２年後","３年後","４年後","５年後","６年後","７年後","８年後"]
["②売上原価",null,null,{"$f":"'別表3 既存事業'!D7","v":0},{"$f":"'別表3 既存事業'!E7","v":0},{"$f":"'別表3 既存事業'!F7","v":0},{"$f":"'別表3 既存事業'!G7+'別表3 新規事業'!G7","v":0},{"$f":"'別表3 既存事業'!H7+'別表3 新規事業'!H7","v":0},{"$f":"'別表3 既存事業'!I7+'別表3 新規事業'!I7","v":0},{"$f":"'別表3 既存事業'!J7+'別表3 新規事業'!J7","v":0},{"$f":"'別表3 既存事業'!K7+'別表3 新規事業'!K7","v":0},{"$f":"'別表3 既存事業'!L7+'別表3 新規事業'!L7","v":0},{"$f":"'別表3 既存事業'!M7+'別表3 新規事業'!M7","v":0},{"$f":"'別表3 既存事業'!N7+'別表3 新規事業'!N7","v":0},{"$f":"D7/D6","v":{"$error":"#DIV/0!"}},{"$f":"E7/E6","v":{"$error":"#DIV/0!"}},{"$f":"F7/F6","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["③売上総利益\n(①－②）",null,null,{"$f":"D6-D7","v":0},{"$f":"E6-E7","v":0},0,0,0,0,0,0,{"$f":"L6-L7","v":0},0,0]
["④販売費及び\n一般管理費",null,null,{"$f":"'別表3 既存事業'!D9","v":0},{"$f":"'別表3 既存事業'!E9","v":0},{"$f":"'別表3 既存事業'!F9","v":0},{"$f":"'別表3 既存事業'!G9+'別表3 新規事業'!G9","v":0},{"$f":"'別表3 既存事業'!H9+'別表3 新規事業'!H9","v":0},{"$f":"'別表3 既存事業'!I9+'別表3 新規事業'!I9","v":0},{"$f":"'別表3 既存事業'!J9+'別表3 新規事業'!J9","v":0},{"$f":"'別表3 既存事業'!K9+'別表3 新規事業'!K9","v":0},{"$f":"'別表3 既存事業'!L9+'別表3 新規事業'!L9","v":0},{"$f":"'別表3 既存事業'!M9+'別表3 新規事業'!M9","v":0},{"$f":"'別表3 既存事業'!N9+'別表3 新規事業'!N9","v":0},{"$f":"D9/D6","v":{"$error":"#DIV/0!"}},{"$f":"E9/E6","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["⑤営業利益",null,null,{"$f":"'別表3 既存事業'!D10","v":0},{"$f":"'別表3 既存事業'!E10","v":0},{"$f":"'別表3 既存事業'!F10","v":0},{"$f":"'別表3 既存事業'!G10+'別表3 新規事業'!G10","v":0},{"$f":"'別表3 既存事業'!H10+'別表3 新規事業'!H10","v":0},{"$f":"'別表3 既存事業'!I10+'別表3 新規事業'!I10","v":0},{"$f":"'別表3 既存事業'!J10+'別表3 新規事業'!J10","v":0},{"$f":"'別表3 既存事業'!K10+'別表3 新規事業'!K10","v":0},{"$f":"'別表3 既存事業'!L10+'別表3 新規事業'!L10","v":0},{"$f":"'別表3 既存事業'!M10+'別表3 新規事業'!M10","v":0},{"$f":"'別表3 既存事業'!N10+'別表3 新規事業'!N10","v":0}]
["⑥経常利益",null,null,{"$f":"'別表3 既存事業'!D11","v":0},{"$f":"'別表3 既存事業'!E11","v":0},{"$f":"'別表3 既存事業'!F11","v":0},{"$f":"'別表3 既存事業'!G11+'別表3 新規事業'!G11","v":0},{"$f":"'別表3 既存事業'!H11+'別表3 新規事業'!H11","v":0},{"$f":"'別表3 既存事業'!I11+'別表3 新規事業'!I11","v":0},{"$f":"'別表3 既存事業'!J11+'別表3 新規事業'!J11","v":0},{"$f":"'別表3 既存事業'!K11+'別表3 新規事業'!K11","v":0},{"$f":"'別表3 既存事業'!L11+'別表3 新規事業'!L11","v":0},{"$f":"'別表3 既存事業'!M11+'別表3 新規事業'!M11","v":0},{"$f":"'別表3 既存事業'!N11+'別表3 新規事業'!N11","v":0},"事業3年後\n成長率4.5%","事業4年後\n成長率6.0%","事業5年後\n成長率7.5%"]
["⑦給与支給総額",null,null,{"$f":"'別表3 既存事業'!D12","v":0},{"$f":"'別表3 既存事業'!E12","v":0},{"$f":"'別表3 既存事業'!F12","v":0},{"$f":"'別表3 既存事業'!G12+'別表3 新規事業'!G12","v":0},{"$f":"'別表3 既存事業'!H12+'別表3 新規事業'!H12","v":0},{"$f":"'別表3 既存事業'!I12+'別表3 新規事業'!I12","v":0},{"$f":"'別表3 既存事業'!J12+'別表3 新規事業'!J12","v":0},{"$f":"'別表3 既存事業'!K12+'別表3 新規事業'!K12","v":0},{"$f":"'別表3 既存事業'!L12+'別表3 新規事業'!L12","v":0},{"$f":"'別表3 既存事業'!M12+'別表3 新規事業'!M12","v":0},{"$f":"'別表3 既存事業'!N12+'別表3 新規事業'!N12","v":0},{"$f":"IF(AND('別表3 既存事業'!V1>=1,'別表3 既存事業'!V1<=5),((OFFSET(I12,0,'別表3 既存事業'!V1)-F12)/ABS(F12)),IF('別表3 既存事業'!V1>5,\"\",(I12-F12)/ABS(F12)))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND('別表3 既存事業'!V1>=1,'別表3 既存事業'!V1<=4),((OFFSET(J12,0,'別表3 既存事業'!V1)-F12)/ABS(F12)),IF('別表3 既存事業'!V1>4,\"\",(J12-F12)/ABS(F12)))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND('別表3 既存事業'!V1>=1,'別表3 既存事業'!V1<=3),((OFFSET(K12,0,'別表3 既存事業'!V1)-F12)/ABS(F12)),IF('別表3 既存事業'!V1>3,\"\",(K12-F12)/ABS(F12)))","v":{"$error":"#DIV/0!"}}]
["⑧人件費",null,null,{"$f":"'別表3 既存事業'!D13","v":0},{"$f":"'別表3 既存事業'!E13","v":0},{"$f":"'別表3 既存事業'!F13","v":0},{"$f":"'別表3 既存事業'!G13+'別表3 新規事業'!G13","v":0},{"$f":"'別表3 既存事業'!H13+'別表3 新規事業'!H13","v":0},{"$f":"'別表3 既存事業'!I13+'別表3 新規事業'!I13","v":0},{"$f":"'別表3 既存事業'!J13+'別表3 新規事業'!J13","v":0},{"$f":"'別表3 既存事業'!K13+'別表3 新規事業'!K13","v":0},{"$f":"'別表3 既存事業'!L13+'別表3 新規事業'!L13","v":0},{"$f":"'別表3 既存事業'!M13+'別表3 新規事業'!M13","v":0},{"$f":"'別表3 既存事業'!N13+'別表3 新規事業'!N13","v":0}]
["⑨設備投資額",null,null,{"$f":"'別表3 既存事業'!D14","v":0},{"$f":"'別表3 既存事業'!E14","v":0},{"$f":"'別表3 既存事業'!F14","v":0},{"$f":"'別表3 既存事業'!G14+'別表3 新規事業'!G14","v":0},{"$f":"'別表3 既存事業'!H14+'別表3 新規事業'!H14","v":0},{"$f":"'別表3 既存事業'!I14+'別表3 新規事業'!I14","v":0},{"$f":"'別表3 既存事業'!J14+'別表3 新規事業'!J14","v":0},{"$f":"'別表3 既存事業'!K14+'別表3 新規事業'!K14","v":0},{"$f":"'別表3 既存事業'!L14+'別表3 新規事業'!L14","v":0},{"$f":"'別表3 既存事業'!M14+'別表3 新規事業'!M14","v":0},{"$f":"'別表3 既存事業'!N14+'別表3 新規事業'!N14","v":0}]
["⑩運転資金",null,null,{"$f":"'別表3 既存事業'!D15","v":0},{"$f":"'別表3 既存事業'!E15","v":0},{"$f":"'別表3 既存事業'!F15","v":0},{"$f":"'別表3 既存事業'!G15+'別表3 新規事業'!G15","v":0},{"$f":"'別表3 既存事業'!H15+'別表3 新規事業'!H15","v":0},{"$f":"'別表3 既存事業'!I15+'別表3 新規事業'!I15","v":0},{"$f":"'別表3 既存事業'!J15+'別表3 新規事業'!J15","v":0},{"$f":"'別表3 既存事業'!K15+'別表3 新規事業'!K15","v":0},{"$f":"'別表3 既存事業'!L15+'別表3 新規事業'!L15","v":0},{"$f":"'別表3 既存事業'!M15+'別表3 新規事業'!M15","v":0},{"$f":"'別表3 既存事業'!N15+'別表3 新規事業'!N15","v":0}]
[null,"普通償却額",null,{"$f":"'別表3 既存事業'!D16","v":0},{"$f":"'別表3 既存事業'!E16","v":0},{"$f":"'別表3 既存事業'!F16","v":0},{"$f":"'別表3 既存事業'!G16+'別表3 新規事業'!G16","v":0},{"$f":"'別表3 既存事業'!H16+'別表3 新規事業'!H16","v":0},{"$f":"'別表3 既存事業'!I16+'別表3 新規事業'!I16","v":0},{"$f":"'別表3 既存事業'!J16+'別表3 新規事業'!J16","v":0},{"$f":"'別表3 既存事業'!K16+'別表3 新規事業'!K16","v":0},{"$f":"'別表3 既存事業'!L16+'別表3 新規事業'!L16","v":0},{"$f":"'別表3 既存事業'!M16+'別表3 新規事業'!M16","v":0},{"$f":"'別表3 既存事業'!N16+'別表3 新規事業'!N16","v":0}]
[null,"特別償却額",null,{"$f":"'別表3 既存事業'!D17","v":0},{"$f":"'別表3 既存事業'!E17","v":0},{"$f":"'別表3 既存事業'!F17","v":0},{"$f":"'別表3 既存事業'!G17+'別表3 新規事業'!G17","v":0},{"$f":"'別表3 既存事業'!H17+'別表3 新規事業'!H17","v":0},{"$f":"'別表3 既存事業'!I17+'別表3 新規事業'!I17","v":0},{"$f":"'別表3 既存事業'!J17+'別表3 新規事業'!J17","v":0},{"$f":"'別表3 既存事業'!K17+'別表3 新規事業'!K17","v":0},{"$f":"'別表3 既存事業'!L17+'別表3 新規事業'!L17","v":0},{"$f":"'別表3 既存事業'!M17+'別表3 新規事業'!M17","v":0},{"$f":"'別表3 既存事業'!N17+'別表3 新規事業'!N17","v":0}]
["⑪減価償却費",null,null,{"$f":"D16","v":0},{"$f":"E16","v":0},0,0,0,0,0,0,{"$f":"L16","v":0},0,0,"事業3年後\n成長率9%","事業4年後\n成長率12%","事業5年後\n成長率15%"]
["⑫付加価値額　　　　　（⑤＋⑧＋⑪）",null,null,{"$f":"D10+D13+D18","v":0},{"$f":"E10+E13+E18","v":0},0,0,0,0,0,0,{"$f":"L10+L13+L18","v":0},0,0,{"$f":"IF(AND('別表3 既存事業'!V1>=1,'別表3 既存事業'!V1<=5),((OFFSET(I19,0,'別表3 既存事業'!V1)-F19)/ABS(F19)),IF('別表3 既存事業'!V1>5,\"\",(I19-F19)/ABS(F19)))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND('別表3 既存事業'!V1>=1,'別表3 既存事業'!V1<=4),((OFFSET(J19,0,'別表3 既存事業'!V1)-F19)/ABS(F19)),IF('別表3 既存事業'!V1>4,\"\",(J19-F19)/ABS(F19)))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND('別表3 既存事業'!V1>=1,'別表3 既存事業'!V1<=3),((OFFSET(K19,0,'別表3 既存事業'!V1)-F19)/ABS(F19)),IF('別表3 既存事業'!V1>3,\"\",(K19-F19)/ABS(F19)))","v":{"$error":"#DIV/0!"}}]
["⑬従業員数",null,null,{"$f":"'別表3 既存事業'!D20","v":0},{"$f":"'別表3 既存事業'!E20","v":0},{"$f":"'別表3 既存事業'!F20","v":0},{"$f":"'別表3 既存事業'!G20+'別表3 新規事業'!G20","v":0},{"$f":"'別表3 既存事業'!H20+'別表3 新規事業'!H20","v":0},{"$f":"'別表3 既存事業'!I20+'別表3 新規事業'!I20","v":0},{"$f":"'別表3 既存事業'!J20+'別表3 新規事業'!J20","v":0},{"$f":"'別表3 既存事業'!K20+'別表3 新規事業'!K20","v":0},{"$f":"'別表3 既存事業'!L20+'別表3 新規事業'!L20","v":0},{"$f":"'別表3 既存事業'!M20+'別表3 新規事業'!M20","v":0},{"$f":"'別表3 既存事業'!N20+'別表3 新規事業'!N20","v":0},"事業3年後\n成長率9%","事業4年後\n成長率12%","事業5年後\n成長率15%"]
["⑭一人当たりの付加価値額（⑫÷⑬）",null,null,{"$f":"IF(D20>0,ROUND(D19/D20,0),0)","v":0},0,0,0,0,0,0,0,{"$f":"IF(L20>0,ROUND(L19/L20,0),0)","v":0},0,0,{"$f":"IF(AND('別表3 既存事業'!V1>=1,'別表3 既存事業'!V1<=5),((OFFSET(I21,0,'別表3 既存事業'!V1)-F21)/ABS(F21)),IF('別表3 既存事業'!V1>5,\"\",(I21-F21)/ABS(F21)))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND('別表3 既存事業'!V1>=1,'別表3 既存事業'!V1<=4),((OFFSET(J21,0,'別表3 既存事業'!V1)-F21)/ABS(F21)),IF('別表3 既存事業'!V1>4,\"\",(J21-F21)/ABS(F21)))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND('別表3 既存事業'!V1>=1,'別表3 既存事業'!V1<=3),((OFFSET(K21,0,'別表3 既存事業'!V1)-F21)/ABS(F21)),IF('別表3 既存事業'!V1>3,\"\",(K21-F21)/ABS(F21)))","v":{"$error":"#DIV/0!"}}]
["⑮資金調達額　⑨＋⑩","政府系金融\n機関借入",null,"-","-","-",{"$f":"'別表3 既存事業'!G22+'別表3 既存事業'!G23+'別表3 新規事業'!G22+'別表3 新規事業'!G23","v":0},{"$f":"'別表3 既存事業'!H22+'別表3 既存事業'!H23+'別表3 新規事業'!H22+'別表3 新規事業'!H23","v":0},{"$f":"'別表3 既存事業'!I22+'別表3 既存事業'!I23+'別表3 新規事業'!I22+'別表3 新規事業'!I23","v":0},{"$f":"'別表3 既存事業'!J22+'別表3 既存事業'!J23+'別表3 新規事業'!J22+'別表3 新規事業'!J23","v":0},{"$f":"'別表3 既存事業'!K22+'別表3 既存事業'!K23+'別表3 新規事業'!K22+'別表3 新規事業'!K23","v":0},{"$f":"'別表3 既存事業'!L22+'別表3 既存事業'!L23+'別表3 新規事業'!L22+'別表3 新規事業'!L23","v":0},{"$f":"'別表3 既存事業'!M22+'別表3 既存事業'!M23+'別表3 新規事業'!M22+'別表3 新規事業'!M23","v":0},{"$f":"'別表3 既存事業'!N22+'別表3 既存事業'!N23+'別表3 新規事業'!N22+'別表3 新規事業'!N23","v":0}]
[null,"民間金融\n機関借入",null,"-","-","-",{"$f":"SUM('別表3 既存事業'!G24:G27)+SUM('別表3 新規事業'!G24:G27)","v":0},{"$f":"SUM('別表3 既存事業'!H24:H27)+SUM('別表3 新規事業'!H24:H27)","v":0},{"$f":"SUM('別表3 既存事業'!I24:I27)+SUM('別表3 新規事業'!I24:I27)","v":0},{"$f":"SUM('別表3 既存事業'!J24:J27)+SUM('別表3 新規事業'!J24:J27)","v":0},{"$f":"SUM('別表3 既存事業'!K24:K27)+SUM('別表3 新規事業'!K24:K27)","v":0},{"$f":"SUM('別表3 既存事業'!L24:L27)+SUM('別表3 新規事業'!L24:L27)","v":0},{"$f":"SUM('別表3 既存事業'!M24:M27)+SUM('別表3 新規事業'!M24:M27)","v":0},{"$f":"SUM('別表3 既存事業'!N24:N27)+SUM('別表3 新規事業'!N24:N27)","v":0}]
[null,"自己資金",null,"-","-","-",{"$f":"'別表3 既存事業'!G28+'別表3 既存事業'!G29+'別表3 新規事業'!G28+'別表3 新規事業'!G29","v":0},{"$f":"'別表3 既存事業'!H28+'別表3 既存事業'!H29+'別表3 新規事業'!H28+'別表3 新規事業'!H29","v":0},{"$f":"'別表3 既存事業'!I28+'別表3 既存事業'!I29+'別表3 新規事業'!I28+'別表3 新規事業'!I29","v":0},{"$f":"'別表3 既存事業'!J28+'別表3 既存事業'!J29+'別表3 新規事業'!J28+'別表3 新規事業'!J29","v":0},{"$f":"'別表3 既存事業'!K28+'別表3 既存事業'!K29+'別表3 新規事業'!K28+'別表3 新規事業'!K29","v":0},{"$f":"'別表3 既存事業'!L28+'別表3 既存事業'!L29+'別表3 新規事業'!L28+'別表3 新規事業'!L29","v":0},{"$f":"'別表3 既存事業'!M28+'別表3 既存事業'!M29+'別表3 新規事業'!M28+'別表3 新規事業'!M29","v":0},{"$f":"'別表3 既存事業'!N28+'別表3 既存事業'!N29+'別表3 新規事業'!N28+'別表3 新規事業'!N29","v":0}]
[null,"その他",null,"-","-","-",{"$f":"'別表3 既存事業'!G30+'別表3 既存事業'!G31+'別表3 新規事業'!G30+'別表3 新規事業'!G31","v":0},{"$f":"'別表3 既存事業'!H30+'別表3 既存事業'!H31+'別表3 新規事業'!H30+'別表3 新規事業'!H31","v":0},{"$f":"'別表3 既存事業'!I30+'別表3 既存事業'!I31+'別表3 新規事業'!I30+'別表3 新規事業'!I31","v":0},{"$f":"'別表3 既存事業'!J30+'別表3 既存事業'!J31+'別表3 新規事業'!J30+'別表3 新規事業'!J31","v":0},{"$f":"'別表3 既存事業'!K30+'別表3 既存事業'!K31+'別表3 新規事業'!K30+'別表3 新規事業'!K31","v":0},{"$f":"'別表3 既存事業'!L30+'別表3 既存事業'!L31+'別表3 新規事業'!L30+'別表3 新規事業'!L31","v":0},{"$f":"'別表3 既存事業'!M30+'別表3 既存事業'!M31+'別表3 新規事業'!M30+'別表3 新規事業'!M31","v":0},{"$f":"'別表3 既存事業'!N30+'別表3 既存事業'!N31+'別表3 新規事業'!N30+'別表3 新規事業'!N31","v":0}]
[null,"合計",null,"-","-","-",{"$f":"SUM(G22:G25)","v":0},{"$f":"SUM(H22:H25)","v":0},{"$f":"SUM(I22:I25)","v":0},{"$f":"SUM(J22:J25)","v":0},{"$f":"SUM(K22:K25)","v":0},{"$f":"SUM(L22:L25)","v":0},0,0]
[]
[null,"（各種指標の算出式）"]
[null,"「給与支給総額」：給料＋賃金＋賞与＋各種手当（所得：残業手当、休日出勤手当、扶養手当、住宅手当等含む）"]
[null,"「付加価値額」：営業利益＋人件費＋減価償却費"]
[null,"「一人当たりの付加価値額」：付加価値額÷従業員数"]
[null,"「営業利益」：売上総利益（売上高－売上原価）－販売費及び一般管理費"]
[]
[null,"（付加価値額等の算出方法）"]
[null,"人数、人件費に短時間労働者、派遣労働者に対する費用を算入しましたか。",null,null,null,null,null,null,{"$f":"IF(I40=\"はい\",IF(J40=\"はい\",\"はい\",\"いいえ\"),\"いいえ\")","v":"いいえ"},{"$f":"IF(I35=\"はい\",\"\",\"ＮＧ\")","v":"ＮＧ"}]
[null,"減価償却費にリース費用を算入しましたか。",null,null,null,null,null,null,{"$f":"IF(I41=\"はい\",IF(J41=\"はい\",\"はい\",\"いいえ\"),\"いいえ\")","v":"いいえ"},{"$f":"IF(I36=\"はい\",\"\",\"ＮＧ\")","v":"ＮＧ"}]
[null,"従業員数について就業時間による調整を行いましたか。",null,null,null,null,null,null,{"$f":"IF(I42=\"はい\",(IF(J42=\"はい\",\"はい\",\"いいえ\")),\"いいえ\")","v":"いいえ"},{"$f":"IF(I37=\"はい\",\"\",\"ＮＧ\")","v":"ＮＧ"}]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF('別表3 既存事業'!$I$46=TRUE,\"はい\",\"いいえ\")","v":"いいえ"},{"$f":"IF('別表3 新規事業'!$I$46=TRUE,\"はい\",\"いいえ\")","v":"いいえ"}]
[null,null,null,null,null,null,null,null,{"$f":"IF('別表3 既存事業'!$I$47=TRUE,\"はい\",\"いいえ\")","v":"いいえ"},{"$f":"IF('別表3 新規事業'!$I$47=TRUE,\"はい\",\"いいえ\")","v":"いいえ"}]
[null,null,null,null,null,null,null,null,{"$f":"IF('別表3 既存事業'!$I$48=TRUE,\"はい\",\"いいえ\")","v":"いいえ"},{"$f":"IF('別表3 新規事業'!$I$48=TRUE,\"はい\",\"いいえ\")","v":"いいえ"}]