{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["別表3インポート用マクロ","マクロ有効化の手順","別表３【貼付用】","別表３－２【貼付用】","入力シート１","入力シート２【法人用】","入力シート２【個人事業主用】","個人事業主の計算方法"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":9,"comments":1,"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":51,"n_cols":12,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["別表3インポート用CSVファイル出力の手順"]
["次のステップ１、２の順で実行してください。"]
[]
["■ステップ１"]
["「マクロ有効確認」ボタンをクリックしてください。（マクロが有効になっているか確認します）"]
["※「マクロは有効です。」（下記画像）のメッセージボックスが表示されましたら、ステップ２に進んでください。"]
["※メッセージボックスが表示されない場合、「マクロ有効化の手順」をご参照のうえ、マクロを有効化してください。"]
["マクロ有効化の手順"]
["※お客様のご利用環境によっては正常に動作しない場合があります。その場合は、申請画面から別表3の値を手入力してください。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["■ステップ２"]
["下表内の値が問題ないことを確認したうえで、「別表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":"別表３【貼付用】!C6","v":""},{"$f":"別表３【貼付用】!D6","v":""},{"$f":"別表３【貼付用】!E6","v":0},{"$f":"別表３【貼付用】!F6","v":0},{"$f":"別表３【貼付用】!G6","v":0},{"$f":"別表３【貼付用】!H6","v":0},{"$f":"別表３【貼付用】!I6","v":""},{"$f":"別表３【貼付用】!J6","v":""}]
["②売上原価",{"$f":"別表３【貼付用】!C7","v":""},{"$f":"別表３【貼付用】!D7","v":""},{"$f":"別表３【貼付用】!E7","v":0},{"$f":"別表３【貼付用】!F7","v":0},{"$f":"別表３【貼付用】!G7","v":0},{"$f":"別表３【貼付用】!H7","v":0},{"$f":"別表３【貼付用】!I7","v":""},{"$f":"別表３【貼付用】!J7","v":""}]
["③売上総利益（①－②）",{"$f":"IFERROR(B28-B29,0)","v":0},{"$f":"IFERROR(C28-C29,0)","v":0},0,0,0,0,0,0,0,0,0]
["④販売費及び一般管理費",{"$f":"別表３【貼付用】!C9","v":""},{"$f":"別表３【貼付用】!D9","v":""},{"$f":"別表３【貼付用】!E9","v":0},{"$f":"別表３【貼付用】!F9","v":0},{"$f":"別表３【貼付用】!G9","v":0},{"$f":"別表３【貼付用】!H9","v":0},{"$f":"別表３【貼付用】!I9","v":""},{"$f":"別表３【貼付用】!J9","v":""}]
["⑤営業利益",{"$f":"IFERROR(B30-B31,0)","v":0},{"$f":"IFERROR(C30-C31,0)","v":0},0,0,0,0,0,0,0,0,0]
["⑥経常利益",{"$f":"別表３【貼付用】!C11","v":""},{"$f":"別表３【貼付用】!D11","v":""},{"$f":"別表３【貼付用】!E11","v":0},{"$f":"別表３【貼付用】!F11","v":0},{"$f":"別表３【貼付用】!G11","v":0},{"$f":"別表３【貼付用】!H11","v":0},{"$f":"別表３【貼付用】!I11","v":""},{"$f":"別表３【貼付用】!J11","v":""}]
["⑦給与支給総額",{"$f":"別表３【貼付用】!C12","v":""},{"$f":"別表３【貼付用】!D12","v":""},{"$f":"別表３【貼付用】!E12","v":0},{"$f":"別表３【貼付用】!F12","v":0},{"$f":"別表３【貼付用】!G12","v":0},{"$f":"別表３【貼付用】!H12","v":0},{"$f":"別表３【貼付用】!I12","v":""},{"$f":"別表３【貼付用】!J12","v":""}]
["⑧人件費",{"$f":"別表３【貼付用】!C13","v":""},{"$f":"別表３【貼付用】!D13","v":""},{"$f":"別表３【貼付用】!E13","v":0},{"$f":"別表３【貼付用】!F13","v":0},{"$f":"別表３【貼付用】!G13","v":0},{"$f":"別表３【貼付用】!H13","v":0},{"$f":"別表３【貼付用】!I13","v":""},{"$f":"別表３【貼付用】!J13","v":""}]
["⑨設備投資額","-","-","-",{"$f":"別表３【貼付用】!F14","v":0},{"$f":"別表３【貼付用】!G14","v":0},{"$f":"別表３【貼付用】!H14","v":0},{"$f":"別表３【貼付用】!I14","v":""},{"$f":"別表３【貼付用】!J14","v":""}]
["⑩運転資金","-","-","-",{"$f":"別表３【貼付用】!F15","v":0},{"$f":"別表３【貼付用】!G15","v":0},{"$f":"別表３【貼付用】!H15","v":0},{"$f":"別表３【貼付用】!I15","v":""},{"$f":"別表３【貼付用】!J15","v":""}]
["⑪減価償却費",{"$f":"IFERROR(B39+B40,0)","v":0},{"$f":"IFERROR(C39+C40,0)","v":0},0,0,0,0,0,0,0,0,0]
["普通償却額",{"$f":"別表３【貼付用】!C16","v":""},{"$f":"別表３【貼付用】!D16","v":""},{"$f":"別表３【貼付用】!E16","v":0},{"$f":"別表３【貼付用】!F16","v":0},{"$f":"別表３【貼付用】!G16","v":0},{"$f":"別表３【貼付用】!H16","v":0},{"$f":"別表３【貼付用】!I16","v":""},{"$f":"別表３【貼付用】!J16","v":""}]
["特別償却額",{"$f":"別表３【貼付用】!C17","v":""},{"$f":"別表３【貼付用】!D17","v":""},{"$f":"別表３【貼付用】!E17","v":0},{"$f":"別表３【貼付用】!F17","v":0},{"$f":"別表３【貼付用】!G17","v":0},{"$f":"別表３【貼付用】!H17","v":0},{"$f":"別表３【貼付用】!I17","v":""},{"$f":"別表３【貼付用】!J17","v":""}]
["⑫付加価値額（⑤＋⑧＋⑪）",{"$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":"別表３【貼付用】!C20","v":""},{"$f":"別表３【貼付用】!D20","v":""},{"$f":"別表３【貼付用】!E20","v":0},{"$f":"別表３【貼付用】!F20","v":0},{"$f":"別表３【貼付用】!G20","v":0},{"$f":"別表３【貼付用】!H20","v":0},{"$f":"別表３【貼付用】!I20","v":""},{"$f":"別表３【貼付用】!J20","v":""}]
["⑭一人当たりの付加価値額（⑫÷⑬）",{"$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":"別表３【貼付用】!F22","v":0},{"$f":"別表３【貼付用】!G22","v":0},{"$f":"別表３【貼付用】!H22","v":0},{"$f":"別表３【貼付用】!I22","v":""},{"$f":"別表３【貼付用】!J22","v":""}]
["民間金融機関借入","-","-","-",{"$f":"別表３【貼付用】!F23","v":0},{"$f":"別表３【貼付用】!G23","v":0},{"$f":"別表３【貼付用】!H23","v":0},{"$f":"別表３【貼付用】!I23","v":""},{"$f":"別表３【貼付用】!J23","v":""}]
["自己資金","-","-","-",{"$f":"別表３【貼付用】!F24","v":0},{"$f":"別表３【貼付用】!G24","v":0},{"$f":"別表３【貼付用】!H24","v":0},{"$f":"別表３【貼付用】!I24","v":""},{"$f":"別表３【貼付用】!J24","v":""}]
["その他","-","-","-",{"$f":"別表３【貼付用】!F25","v":0},{"$f":"別表３【貼付用】!G25","v":0},{"$f":"別表３【貼付用】!H25","v":0},{"$f":"別表３【貼付用】!I25","v":""},{"$f":"別表３【貼付用】!J25","v":""}]
["注意事項"]
["・表内のセルに「半角マイナス（-）」、「半角カンマ（,）」、「小数点（.）」以外の記号が含まれないよう、参照元の値を修正してください。"]
["・変換されたファイルを保存する際、保存するフォルダ内に同名ファイルがある場合は警告なく上書き保存されます。"]

{"sheet":"マクロ有効化の手順","index":1,"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を再起動し、「マクロ有効確認」ボタンをクリックしてメッセージボックスが表示されるか確認する"]
[]
[]
[]
["以上"]

{"sheet":"別表３【貼付用】","index":2,"n_rows":36,"n_cols":19,"rows_kept":36,"cut":false,"hidden":false,"merged":[[17,0,17,1],[34,1,34,5],[35,1,35,5],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,24,0],[27,1,30,9],[33,1,33,5],[3,0,3,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[9,0,9,1],[4,0,4,1],[7,11,7,13],[7,14,7,15],[7,16,7,17],[9,12,9,13],[9,14,9,15],[9,16,9,17],[10,12,10,13],[10,14,10,15],[10,16,10,17],[10,18,10,19],[7,18,7,19],[8,12,8,13],[8,14,8,15],[8,16,8,17],[8,18,8,19],[9,18,9,19]]}
["（別表３）経営計画及び資金計画"]
[null,"　　"]
[null,null,null,null,null,null,null,null,null,"（単位　千円）"]
[null,null,"２年前","１年前","直近期末","１年後","２年後","３年後","４年後","５年後"]
[null,null,{"$f":"入力シート１!B5","v":"(R 年 月期)"},{"$f":"入力シート１!C5","v":"(R 年 月期)"},{"$f":"入力シート１!D5","v":"(R 年 月期)"},{"$f":"入力シート１!E5","v":"(R 年 月期)"},{"$f":"入力シート１!F5","v":"(R 年 月期)"},{"$f":"入力シート１!G5","v":"(R 年 月期)"},{"$f":"入力シート１!H5","v":"(R 年 月期)"},{"$f":"入力シート１!I5","v":"(R 年 月期)"}]
["①売上高",null,{"$f":"IF(入力シート１!B6=\"\",\"\",ROUND(入力シート１!B6/1000,0))","v":""},{"$f":"IF(入力シート１!C6=\"\",\"\",ROUND(入力シート１!C6/1000,0))","v":""},{"$f":"'別表３－２【貼付用】'!C6","v":0},{"$f":"'別表３－２【貼付用】'!D6","v":0},{"$f":"'別表３－２【貼付用】'!E6","v":0},{"$f":"'別表３－２【貼付用】'!F6","v":0},{"$f":"'別表３－２【貼付用】'!G6","v":""},{"$f":"'別表３－２【貼付用】'!H6","v":""},null,"★経営の向上の程度を示す指標（別表１）"]
["②売上原価",null,{"$f":"IF(C6=\"\",\"\",ROUND(入力シート１!B9/1000,0))","v":""},{"$f":"IF(D6=\"\",\"\",ROUND(入力シート１!C9/1000,0))","v":""},{"$f":"'別表３－２【貼付用】'!C9","v":0},{"$f":"'別表３－２【貼付用】'!D9","v":0},{"$f":"'別表３－２【貼付用】'!E9","v":0},{"$f":"'別表３－２【貼付用】'!F9","v":0},{"$f":"'別表３－２【貼付用】'!G9","v":""},{"$f":"'別表３－２【貼付用】'!H9","v":""},null,"計画終了期",null,null,"年後（3～5のいずれかの数字を入れてください。）"]
["③売上総利益\n（①－②）",null,{"$f":"IF(C6=\"\",\"\",C6-C7)","v":""},{"$f":"IF(D6=\"\",\"\",D6-D7)","v":""},{"$f":"E6-E7","v":0},{"$f":"F6-F7","v":0},{"$f":"G6-G7","v":0},{"$f":"H6-H7","v":0},{"$f":"IF(I6=\"\",\"\",I6-I7)","v":""},{"$f":"IF(J6=\"\",\"\",J6-J7)","v":""},null,"項目",null,null,"現状",null,"終了時",null,"伸び率"]
["④販売費及び\n　一般管理費",null,{"$f":"IF(C6=\"\",\"\",ROUND(入力シート１!B15/1000,0))","v":""},{"$f":"IF(D6=\"\",\"\",ROUND(入力シート１!C15/1000,0))","v":""},{"$f":"'別表３－２【貼付用】'!C15","v":0},{"$f":"'別表３－２【貼付用】'!D15","v":0},{"$f":"'別表３－２【貼付用】'!E15","v":0},{"$f":"'別表３－２【貼付用】'!F15","v":0},{"$f":"'別表３－２【貼付用】'!G15","v":""},{"$f":"'別表３－２【貼付用】'!H15","v":""},null,1,"付加価値額",null,{"$f":"E$19","v":0},null,{"$f":"INDEX(H19:J19,1,N7-2)","v":{"$error":"#VALUE!"}},null,{"$f":"(Q9-O9)/ABS(O9)","v":{"$error":"#VALUE!"}}]
["⑤営業利益",null,{"$f":"IF(C6=\"\",\"\",C8-C9)","v":""},{"$f":"IF(D6=\"\",\"\",D8-D9)","v":""},{"$f":"E8-E9","v":0},{"$f":"F8-F9","v":0},{"$f":"G8-G9","v":0},{"$f":"H8-H9","v":0},{"$f":"IF(I6=\"\",\"\",I8-I9)","v":""},{"$f":"IF(J6=\"\",\"\",J8-J9)","v":""},null,2,"一人当たりの\n付加価値額",null,{"$f":"E$21","v":{"$error":"#DIV/0!"}},null,{"$f":"INDEX(H21:J21,1,N7-2)","v":{"$error":"#VALUE!"}},null,{"$f":"(Q10-O10)/ABS(O10)","v":{"$error":"#VALUE!"}}]
["⑥経常利益",null,{"$f":"IF(C6=\"\",\"\",ROUND(入力シート１!B21/1000,0))","v":""},{"$f":"IF(D6=\"\",\"\",ROUND(入力シート１!C21/1000,0))","v":""},{"$f":"'別表３－２【貼付用】'!C21","v":0},{"$f":"'別表３－２【貼付用】'!D21","v":0},{"$f":"'別表３－２【貼付用】'!E21","v":0},{"$f":"'別表３－２【貼付用】'!F21","v":0},{"$f":"IF(I6=\"\",\"\",'別表３－２【貼付用】'!G21)","v":""},{"$f":"IF(J6=\"\",\"\",'別表３－２【貼付用】'!H21)","v":""},null,3,"給与支給総額",null,{"$f":"E$12","v":0},null,{"$f":"INDEX(H12:J12,1,N7-2)","v":{"$error":"#VALUE!"}},null,{"$f":"(Q11-O11)/ABS(O11)","v":{"$error":"#VALUE!"}}]
["⑦給与支給総額",null,{"$f":"IF(C6=\"\",\"\",ROUND(入力シート１!B22/1000,0))","v":""},{"$f":"IF(D6=\"\",\"\",ROUND(入力シート１!C22/1000,0))","v":""},{"$f":"'別表３－２【貼付用】'!C22","v":0},{"$f":"'別表３－２【貼付用】'!D22","v":0},{"$f":"'別表３－２【貼付用】'!E22","v":0},{"$f":"'別表３－２【貼付用】'!F22","v":0},{"$f":"'別表３－２【貼付用】'!G22","v":""},{"$f":"'別表３－２【貼付用】'!H22","v":""}]
["⑧人件費",null,{"$f":"IF(C6=\"\",\"\",ROUND(入力シート１!B25/1000,0))","v":""},{"$f":"IF(D6=\"\",\"\",ROUND(入力シート１!C25/1000,0))","v":""},{"$f":"'別表３－２【貼付用】'!C25","v":0},{"$f":"'別表３－２【貼付用】'!D25","v":0},{"$f":"'別表３－２【貼付用】'!E25","v":0},{"$f":"'別表３－２【貼付用】'!F25","v":0},{"$f":"'別表３－２【貼付用】'!G25","v":""},{"$f":"'別表３－２【貼付用】'!H25","v":""}]
["⑨設備投資額",null,"－","－","－",{"$f":"'別表３－２【貼付用】'!D28","v":0},{"$f":"'別表３－２【貼付用】'!E28","v":0},{"$f":"'別表３－２【貼付用】'!F28","v":0},{"$f":"'別表３－２【貼付用】'!G28","v":""},{"$f":"'別表３－２【貼付用】'!H28","v":""}]
["⑩運転資金",null,"－","－","－",{"$f":"'別表３－２【貼付用】'!D31","v":0},{"$f":"'別表３－２【貼付用】'!E31","v":0},{"$f":"'別表３－２【貼付用】'!F31","v":0},{"$f":"'別表３－２【貼付用】'!G31","v":""},{"$f":"'別表３－２【貼付用】'!H31","v":""}]
[null,"普通償却額",{"$f":"IF(C6=\"\",\"\",ROUND(入力シート１!B34/1000,0))","v":""},{"$f":"IF(D6=\"\",\"\",ROUND(入力シート１!C34/1000,0))","v":""},{"$f":"IF(E6=\"\",\"\",ROUND(入力シート１!D34/1000,0))","v":0},{"$f":"IF(F6=\"\",\"\",ROUND(入力シート１!E34/1000,0))","v":0},{"$f":"IF(G6=\"\",\"\",ROUND(入力シート１!F34/1000,0))","v":0},{"$f":"IF(H6=\"\",\"\",ROUND(入力シート１!G34/1000,0))","v":0},{"$f":"IF(I6=\"\",\"\",ROUND(入力シート１!H34/1000,0))","v":""},{"$f":"IF(J6=\"\",\"\",ROUND(入力シート１!I34/1000,0))","v":""}]
[null,"特別償却額",{"$f":"IF(C6=\"\",\"\",ROUND(入力シート１!B37/1000,0))","v":""},{"$f":"IF(D6=\"\",\"\",ROUND(入力シート１!C37/1000,0))","v":""},{"$f":"IF(E6=\"\",\"\",ROUND(入力シート１!D37/1000,0))","v":0},{"$f":"IF(F6=\"\",\"\",ROUND(入力シート１!E37/1000,0))","v":0},{"$f":"IF(G6=\"\",\"\",ROUND(入力シート１!F37/1000,0))","v":0},{"$f":"IF(H6=\"\",\"\",ROUND(入力シート１!G37/1000,0))","v":0},{"$f":"IF(I6=\"\",\"\",ROUND(入力シート１!H37/1000,0))","v":""},{"$f":"IF(J6=\"\",\"\",ROUND(入力シート１!I37/1000,0))","v":""}]
["⑪減価償却額",null,{"$f":"IF(C6=\"\",\"\",SUM(C16:C17))","v":""},{"$f":"IF(D6=\"\",\"\",SUM(D16:D17))","v":""},{"$f":"SUM(E16:E17)","v":0},{"$f":"SUM(F16:F17)","v":0},{"$f":"SUM(G16:G17)","v":0},{"$f":"SUM(H16:H17)","v":0},{"$f":"IF(I6=\"\",\"\",SUM(I16:I17))","v":""},{"$f":"IF(J6=\"\",\"\",SUM(J16:J17))","v":""}]
["⑫付加価値額\n（⑤＋⑧＋⑪）",null,{"$f":"IF(C6=\"\",\"\",SUM(C10,C13,C18))","v":""},{"$f":"IF(D6=\"\",\"\",SUM(D10,D13,D18))","v":""},{"$f":"'別表３－２【貼付用】'!C37","v":0},{"$f":"'別表３－２【貼付用】'!D37","v":0},{"$f":"'別表３－２【貼付用】'!E37","v":0},{"$f":"'別表３－２【貼付用】'!F37","v":0},{"$f":"'別表３－２【貼付用】'!G37","v":""},{"$f":"'別表３－２【貼付用】'!H37","v":""}]
["⑬従業員数",null,{"$f":"IF(C6=\"\",\"\",入力シート１!B43)","v":""},{"$f":"IF(D6=\"\",\"\",入力シート１!C43)","v":""},{"$f":"'別表３－２【貼付用】'!C40","v":0},{"$f":"'別表３－２【貼付用】'!D40","v":0},{"$f":"'別表３－２【貼付用】'!E40","v":0},{"$f":"'別表３－２【貼付用】'!F40","v":0},{"$f":"'別表３－２【貼付用】'!G40","v":""},{"$f":"'別表３－２【貼付用】'!H40","v":""}]
["⑭一人当たりの付加価値額（⑫÷⑬）",null,{"$f":"IF(C6=\"\",\"\",IF(C20=0,\"\",ROUND(C19/C20,0)))","v":""},{"$f":"IF(D6=\"\",\"\",IF(D20=0,\"\",ROUND(D19/D20,0)))","v":""},{"$f":"ROUND(E19/E20,0)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(F19/F20,0)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(G19/G20,0)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(H19/H20,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(I6=\"\",\"\",ROUND(I19/I20,0))","v":""},{"$f":"IF(J6=\"\",\"\",ROUND(J19/J20,0))","v":""}]
["⑮資金調達額(⑨＋⑩)","政府系金融\n機関借入","－","－","－",{"$f":"ROUND(入力シート１!E50/1000,0)","v":0},{"$f":"ROUND(入力シート１!F50/1000,0)","v":0},{"$f":"ROUND(入力シート１!G50/1000,0)","v":0},{"$f":"IF(I6=\"\",\"\",ROUND(入力シート１!H50/1000,0))","v":""},{"$f":"IF(J6=\"\",\"\",ROUND(入力シート１!I50/1000,0))","v":""}]
[null,"民間金融機\n関借入","－","－","－",{"$f":"ROUND(入力シート１!E51/1000,0)","v":0},{"$f":"ROUND(入力シート１!F51/1000,0)","v":0},{"$f":"ROUND(入力シート１!G51/1000,0)","v":0},{"$f":"IF(I6=\"\",\"\",ROUND(入力シート１!H51/1000,0))","v":""},{"$f":"IF(J6=\"\",\"\",ROUND(入力シート１!I51/1000,0))","v":""}]
[null,"自己資金","－","－","－",{"$f":"ROUND(入力シート１!E52/1000,0)","v":0},{"$f":"ROUND(入力シート１!F52/1000,0)","v":0},{"$f":"ROUND(入力シート１!G52/1000,0)","v":0},{"$f":"IF(I6=\"\",\"\",ROUND(入力シート１!H52/1000,0))","v":""},{"$f":"IF(J6=\"\",\"\",ROUND(入力シート１!I52/1000,0))","v":""}]
[null,"その他","－","－","－",{"$f":"ROUND(入力シート１!E53/1000,0)","v":0},{"$f":"ROUND(入力シート１!F53/1000,0)","v":0},{"$f":"ROUND(入力シート１!G53/1000,0)","v":0},{"$f":"IF(I6=\"\",\"\",ROUND(入力シート１!H53/1000,0))","v":""},{"$f":"IF(J6=\"\",\"\",ROUND(入力シート１!I53/1000,0))","v":""}]
[null,"合計","－","－","－",{"$f":"SUM(F22:F25)","v":0},{"$f":"SUM(G22:G25)","v":0},{"$f":"SUM(H22:H25)","v":0},{"$f":"IF(I6=\"\",\"\",SUM(I22:I25))","v":""},{"$f":"IF(J6=\"\",\"\",SUM(J22:J25))","v":""}]
[]
[null,"（各種指標の算出式）\n「給与支給総額」：給与＋賃金＋賞与＋各種手当\n「付加価値額」：営業利益＋人件費＋減価償却費\n「一人当たりの付加価値額」：付加価値額÷従業員数\n「営業利益」：売上総利益（売上高－売上原価）－販売費及び一般管理費"]
[]
[]
[]
[]
[null,"（付加価値額等の算出方法）　注）下記については該当があれば原則算入して下さい。"]
[null,"人数、人件費に短時間労働者、派遣労働者に対する費用を算入しましたか。",null,null,null,null,null,"はい",null,"該当なし"]
[null,"減価償却費にリース費用を算入しましたか。",null,null,null,null,null,"はい",null,"該当なし"]
[null,"従業員数について就業時間による調整を行いましたか。",null,null,null,null,null,"はい",null,"該当なし"]

{"sheet":"別表３－２【貼付用】","index":3,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["（別表３－２）中期経営計画（３～５年）及び資金計画の算出根拠資料"]
[]
["１　既存事業と新規事業　",null,null,null,null,null,null,"(単位　千円）"]
[null,null,"直近期末","１年後","２年後","３年後","４年後","５年後"]
[null,null,{"$f":"入力シート１!D5","v":"(R 年 月期)"},{"$f":"入力シート１!E5","v":"(R 年 月期)"},{"$f":"入力シート１!F5","v":"(R 年 月期)"},{"$f":"入力シート１!G5","v":"(R 年 月期)"},{"$f":"入力シート１!H5","v":"(R 年 月期)"},{"$f":"入力シート１!I5","v":"(R 年 月期)"}]
[" ①売上高",null,{"$f":"C7","v":0},{"$f":"SUM(D7:D8)","v":0},{"$f":"SUM(E7:E8)","v":0},{"$f":"SUM(F7:F8)","v":0},{"$f":"IF(SUM(G7:G8)=0,\"\",SUM(G7:G8))","v":""},{"$f":"IF(SUM(H7:H8)=0,\"\",SUM(H7:H8))","v":""}]
[null,"既存事業",{"$f":"ROUND(入力シート１!D7/1000,0)","v":0},{"$f":"ROUND(入力シート１!E7/1000,0)","v":0},{"$f":"ROUND(入力シート１!F7/1000,0)","v":0},{"$f":"ROUND(入力シート１!G7/1000,0)","v":0},{"$f":"IF(入力シート１!H7=\"\",\"\",ROUND(入力シート１!H7/1000,0))","v":""},{"$f":"IF(入力シート１!I7=\"\",\"\",ROUND(入力シート１!I7/1000,0))","v":""}]
[null,"新規事業","-",{"$f":"ROUND(入力シート１!E8/1000,0)","v":0},{"$f":"ROUND(入力シート１!F8/1000,0)","v":0},{"$f":"ROUND(入力シート１!G8/1000,0)","v":0},{"$f":"IF(G7=\"\",\"\",ROUND(入力シート１!H8/1000,0))","v":""},{"$f":"IF(H7=\"\",\"\",ROUND(入力シート１!I8/1000,0))","v":""}]
[" ②売上原価",null,{"$f":"C10","v":0},{"$f":"SUM(D10:D11)","v":0},{"$f":"SUM(E10:E11)","v":0},{"$f":"SUM(F10:F11)","v":0},{"$f":"IF(G6=\"\",\"\",SUM(G10:G11))","v":""},{"$f":"IF(H6=\"\",\"\",SUM(H10:H11))","v":""}]
[null,"既存事業",{"$f":"ROUND(入力シート１!D10/1000,0)","v":0},{"$f":"ROUND(入力シート１!E10/1000,0)","v":0},{"$f":"ROUND(入力シート１!F10/1000,0)","v":0},{"$f":"ROUND(入力シート１!G10/1000,0)","v":0},{"$f":"IF(G6=\"\",\"\",ROUND(入力シート１!H10/1000,0))","v":""},{"$f":"IF(H6=\"\",\"\",ROUND(入力シート１!I10/1000,0))","v":""}]
[null,"新規事業","-",{"$f":"ROUND(入力シート１!E11/1000,0)","v":0},{"$f":"ROUND(入力シート１!F11/1000,0)","v":0},{"$f":"ROUND(入力シート１!G11/1000,0)","v":0},{"$f":"IF(G6=\"\",\"\",ROUND(入力シート１!H11/1000,0))","v":""},{"$f":"IF(H6=\"\",\"\",ROUND(入力シート１!I11/1000,0))","v":""}]
[" ③売上総利益",null,{"$f":"C6-C9","v":0},0,0,0,{"$f":"IF(G6=\"\",\"\",G6-G9)","v":""},{"$f":"IF(H6=\"\",\"\",H6-H9)","v":""}]
[null,"既存事業",0,0,0,0,{"$f":"IF(G6=\"\",\"\",G7-G10)","v":""},{"$f":"IF(H6=\"\",\"\",H7-H10)","v":""}]
[null,"新規事業","-",{"$f":"D8-D11","v":0},{"$f":"E8-E11","v":0},{"$f":"F8-F11","v":0},{"$f":"IF(G6=\"\",\"\",G8-G11)","v":""},{"$f":"IF(H6=\"\",\"\",H8-H11)","v":""}]
[" ④販売費及び",null,{"$f":"C16","v":0},{"$f":"SUM(D16:D17)","v":0},{"$f":"SUM(E16:E17)","v":0},{"$f":"SUM(F16:F17)","v":0},{"$f":"IF(G6=\"\",\"\",SUM(G16:G17))","v":""},{"$f":"IF(H6=\"\",\"\",SUM(H16:H17))","v":""}]
["　一般管理費","既存事業",{"$f":"ROUND(入力シート１!D16/1000,0)","v":0},{"$f":"ROUND(入力シート１!E16/1000,0)","v":0},{"$f":"ROUND(入力シート１!F16/1000,0)","v":0},{"$f":"ROUND(入力シート１!G16/1000,0)","v":0},{"$f":"IF(G6=\"\",\"\",ROUND(入力シート１!H16/1000,0))","v":""},{"$f":"IF(H6=\"\",\"\",ROUND(入力シート１!I16/1000,0))","v":""}]
[null,"新規事業","-",{"$f":"ROUND(入力シート１!E17/1000,0)","v":0},{"$f":"ROUND(入力シート１!F17/1000,0)","v":0},{"$f":"ROUND(入力シート１!G17/1000,0)","v":0},{"$f":"IF(G6=\"\",\"\",ROUND(入力シート１!H17/1000,0))","v":""},{"$f":"IF(H6=\"\",\"\",ROUND(入力シート１!I17/1000,0))","v":""}]
[" ⑤営業利益",null,{"$f":"C19","v":0},{"$f":"SUM(D19:D20)","v":0},{"$f":"SUM(E19:E20)","v":0},{"$f":"SUM(F19:F20)","v":0},{"$f":"IF(G6=\"\",\"\",SUM(G19:G20))","v":""},{"$f":"IF(H6=\"\",\"\",SUM(H19:H20))","v":""}]
[null,"既存事業",{"$f":"C13-C16","v":0},{"$f":"D13-D16","v":0},{"$f":"E13-E16","v":0},{"$f":"F13-F16","v":0},{"$f":"IF(G6=\"\",\"\",G13-G16)","v":""},{"$f":"IF(H6=\"\",\"\",H13-H16)","v":""}]
[null,"新規事業","-",{"$f":"D14-D17","v":0},{"$f":"E14-E17","v":0},{"$f":"F14-F17","v":0},{"$f":"IF(G6=\"\",\"\",G14-G17)","v":""},{"$f":"IF(H6=\"\",\"\",H14-H17)","v":""}]
[" ⑥経常利益",null,{"$f":"ROUND(入力シート１!D21/1000,0)","v":0},{"$f":"ROUND(入力シート１!E21/1000,0)","v":0},{"$f":"ROUND(入力シート１!F21/1000,0)","v":0},{"$f":"ROUND(入力シート１!G21/1000,0)","v":0},{"$f":"IF(G6=\"\",\"\",ROUND(入力シート１!H21/1000,0))","v":""},{"$f":"IF(H6=\"\",\"\",ROUND(入力シート１!I21/1000,0))","v":""}]
[" ⑦給与支給総額",null,{"$f":"C23","v":0},{"$f":"SUM(D23:D24)","v":0},{"$f":"SUM(E23:E24)","v":0},{"$f":"SUM(F23:F24)","v":0},{"$f":"IF(G6=\"\",\"\",SUM(G23:G24))","v":""},{"$f":"IF(H6=\"\",\"\",SUM(H23:H24))","v":""}]
[null,"既存事業",{"$f":"ROUND(入力シート１!D23/1000,0)","v":0},{"$f":"ROUND(入力シート１!E23/1000,0)","v":0},{"$f":"ROUND(入力シート１!F23/1000,0)","v":0},{"$f":"ROUND(入力シート１!G23/1000,0)","v":0},{"$f":"IF(G6=\"\",\"\",ROUND(入力シート１!H23/1000,0))","v":""},{"$f":"IF(H6=\"\",\"\",ROUND(入力シート１!I23/1000,0))","v":""}]
[null,"新規事業","-",{"$f":"ROUND(入力シート１!E24/1000,0)","v":0},{"$f":"ROUND(入力シート１!F24/1000,0)","v":0},{"$f":"ROUND(入力シート１!G24/1000,0)","v":0},{"$f":"IF(G6=\"\",\"\",ROUND(入力シート１!H24/1000,0))","v":""},{"$f":"IF(H6=\"\",\"\",ROUND(入力シート１!I24/1000,0))","v":""}]
[" ⑧人件費",null,{"$f":"C26","v":0},{"$f":"SUM(D26:D27)","v":0},{"$f":"SUM(E26:E27)","v":0},{"$f":"SUM(F26:F27)","v":0},{"$f":"IF(G6=\"\",\"\",SUM(G26:G27))","v":""},{"$f":"IF(H6=\"\",\"\",SUM(H26:H27))","v":""}]
[null,"既存事業",{"$f":"ROUND(入力シート１!D26/1000,0)","v":0},{"$f":"ROUND(入力シート１!E26/1000,0)","v":0},{"$f":"ROUND(入力シート１!F26/1000,0)","v":0},{"$f":"ROUND(入力シート１!G26/1000,0)","v":0},{"$f":"IF(G6=\"\",\"\",ROUND(入力シート１!H26/1000,0))","v":""},{"$f":"IF(H6=\"\",\"\",ROUND(入力シート１!I26/1000,0))","v":""}]
[null,"新規事業","-",{"$f":"ROUND(入力シート１!E27/1000,0)","v":0},{"$f":"ROUND(入力シート１!F27/1000,0)","v":0},{"$f":"ROUND(入力シート１!G27/1000,0)","v":0},{"$f":"IF(G6=\"\",\"\",ROUND(入力シート１!H27/1000,0))","v":""},{"$f":"IF(H6=\"\",\"\",ROUND(入力シート１!I27/1000,0))","v":""}]
[" ⑨設備投資額",null,"-",{"$f":"SUM(D29:D30)","v":0},{"$f":"SUM(E29:E30)","v":0},{"$f":"SUM(F29:F30)","v":0},{"$f":"IF(G6=\"\",\"\",SUM(G29:G30))","v":""},{"$f":"IF(H6=\"\",\"\",SUM(H29:H30))","v":""}]
[null,"既存事業","-",{"$f":"ROUND(入力シート１!E29/1000,0)","v":0},{"$f":"ROUND(入力シート１!F29/1000,0)","v":0},{"$f":"ROUND(入力シート１!G29/1000,0)","v":0},{"$f":"IF(G6=\"\",\"\",ROUND(入力シート１!H29/1000,0))","v":""},{"$f":"IF(H6=\"\",\"\",ROUND(入力シート１!I29,0)/1000)","v":""}]
[null,"新規事業","-",{"$f":"ROUND(入力シート１!E30/1000,0)","v":0},{"$f":"ROUND(入力シート１!F30/1000,0)","v":0},{"$f":"ROUND(入力シート１!G30/1000,0)","v":0},{"$f":"IF(G6=\"\",\"\",ROUND(入力シート１!H30,0)/1000)","v":""},{"$f":"IF(H6=\"\",\"\",ROUND(入力シート１!I30,0)/1000)","v":""}]
[" ⑩運転資金",null,"-",{"$f":"SUM(D32:D33)","v":0},{"$f":"SUM(E32:E33)","v":0},{"$f":"SUM(F32:F33)","v":0},{"$f":"IF(G6=\"\",\"\",SUM(G32:G33))","v":""},{"$f":"IF(H6=\"\",\"\",SUM(H32:H33))","v":""}]
[null,"既存事業","-",{"$f":"ROUND(入力シート１!E32/1000,0)","v":0},{"$f":"ROUND(入力シート１!F32/1000,0)","v":0},{"$f":"ROUND(入力シート１!G32/1000,0)","v":0},{"$f":"IF(G6=\"\",\"\",ROUND(入力シート１!H32/1000,0))","v":""},{"$f":"IF(H6=\"\",\"\",ROUND(入力シート１!I32,0)/1000)","v":""}]
[null,"新規事業","-",{"$f":"ROUND(入力シート１!E33/1000,0)","v":0},{"$f":"ROUND(入力シート１!F33/1000,0)","v":0},{"$f":"ROUND(入力シート１!G33/1000,0)","v":0},{"$f":"IF(G6=\"\",\"\",ROUND(入力シート１!H33,0)/1000)","v":""},{"$f":"IF(H6=\"\",\"\",ROUND(入力シート１!I33,0)/1000)","v":""}]
[" ⑪減価償却額",null,{"$f":"C35","v":0},{"$f":"SUM(D35:D36)","v":0},{"$f":"SUM(E35:E36)","v":0},{"$f":"SUM(F35:F36)","v":0},{"$f":"IF(G6=\"\",\"\",SUM(G35:G36))","v":""},{"$f":"IF(H6=\"\",\"\",SUM(H35:H36))","v":""}]
[null,"既存事業",{"$f":"ROUND((入力シート１!D35+入力シート１!D38)/1000,0)","v":0},{"$f":"ROUND((入力シート１!E35+入力シート１!E38)/1000,0)","v":0},{"$f":"ROUND((入力シート１!F35+入力シート１!F38)/1000,0)","v":0},{"$f":"ROUND((入力シート１!G35+入力シート１!G38)/1000,0)","v":0},{"$f":"IF(G6=\"\",\"\",ROUND((入力シート１!H35+入力シート１!H38)/1000,0))","v":""},{"$f":"IF(H6=\"\",\"\",ROUND((入力シート１!I35+入力シート１!I38)/1000,0))","v":""}]
[null,"新規事業","-",{"$f":"ROUND((入力シート１!E36+入力シート１!E39)/1000,0)","v":0},{"$f":"ROUND((入力シート１!F36+入力シート１!F39)/1000,0)","v":0},{"$f":"ROUND((入力シート１!G36+入力シート１!G39)/1000,0)","v":0},{"$f":"IF(G6=\"\",\"\",ROUND((入力シート１!H36+入力シート１!H39)/1000,0))","v":""},{"$f":"IF(H6=\"\",\"\",ROUND((入力シート１!I36+入力シート１!I39)/1000,0))","v":""}]
[" ⑫付加価値額",null,{"$f":"C38","v":0},{"$f":"SUM(D38:D39)","v":0},{"$f":"SUM(E38:E39)","v":0},{"$f":"SUM(F38:F39)","v":0},{"$f":"IF(G6=\"\",\"\",SUM(G38:G39))","v":""},{"$f":"IF(H6=\"\",\"\",SUM(H38:H39))","v":""}]
[" (⑤+⑧+⑪）","既存事業",{"$f":"SUM(C19,C26,C35)","v":0},{"$f":"SUM(D19,D26,D35)","v":0},{"$f":"SUM(E19,E26,E35)","v":0},{"$f":"SUM(F19,F26,F35)","v":0},{"$f":"IF(G6=\"\",\"\",SUM(G19,G26,G35))","v":""},{"$f":"IF(H6=\"\",\"\",SUM(H19,H26,H35))","v":""}]
[null,"新規事業","-",{"$f":"SUM(D20,D27,D36)","v":0},{"$f":"SUM(E20,E27,E36)","v":0},{"$f":"SUM(F20,F27,F36)","v":0},{"$f":"IF(G6=\"\",\"\",SUM(G20,G27,G36))","v":""},{"$f":"IF(H6=\"\",\"\",SUM(H20,H27,H36))","v":""}]
[" ⑬従業員数",null,{"$f":"C41","v":0},{"$f":"SUM(D41:D42)","v":0},{"$f":"SUM(E41:E42)","v":0},{"$f":"SUM(F41:F42)","v":0},{"$f":"IF(G6=\"\",\"\",SUM(G41:G42))","v":""},{"$f":"IF(H6=\"\",\"\",SUM(H41:H42))","v":""}]
[null,"既存事業",{"$f":"入力シート１!D44","v":0},{"$f":"入力シート１!E44","v":0},{"$f":"入力シート１!F44","v":0},{"$f":"入力シート１!G44","v":0},{"$f":"IF(G6=\"\",\"\",入力シート１!H44)","v":""},{"$f":"IF(H6=\"\",\"\",入力シート１!I44)","v":""}]
[null,"新規事業","-",{"$f":"入力シート１!E45","v":0},{"$f":"入力シート１!F45","v":0},{"$f":"入力シート１!G45","v":0},{"$f":"IF(G6=\"\",\"\",入力シート１!H45)","v":""},{"$f":"IF(H6=\"\",\"\",入力シート１!I45)","v":""}]
[" ⑭一人当たり",null,"-","-","-","-","-","-"]
["　付加価値額","既存事業",{"$f":"ROUND(C38/C41,0)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(D38/D41,0)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(E38/E41,0)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(F38/F41,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(G6=\"\",\"\",ROUND(G38/G41,0))","v":""},{"$f":"IF(H6=\"\",\"\",ROUND(H38/H41,0))","v":""}]
[null,"新規事業","-",{"$f":"IF(D42=0,\"\",ROUND(D39/D42,0))","v":""},{"$f":"IF(E42=0,\"\",ROUND(E39/E42,0))","v":""},{"$f":"IF(F42=0,\"\",ROUND(F39/F42,0))","v":""},{"$f":"IF(G6=\"\",\"\",IF(G42=0,\"\",ROUND(G39/G42,0)))","v":""},{"$f":"IF(H6=\"\",\"\",IF(H42=0,\"\",ROUND(H39/H42,0)))","v":""}]

{"sheet":"入力シート１","index":4,"n_rows":53,"n_cols":16,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["◎入力シート１【法人・個人事業主共通】"]
[null,null,null,null,"種別","法人"]
[null,null,null,null,null,null,null,null,"(単位　円）"]
[null,"２年前","１年前","直近期末","１年後","２年後","３年後","４年後","５年後"]
[null,"(R 年 月期)","(R 年 月期)","(R 年 月期)","(R 年 月期)","(R 年 月期)","(R 年 月期)","(R 年 月期)","(R 年 月期)"]
["①売上高",{"$f":"IF(B7=\"\",\"\",B7)","v":""},{"$f":"IF(C7=\"\",\"\",C7)","v":""},{"$f":"D7","v":0},{"$f":"SUM(E7:E8)","v":0},{"$f":"SUM(F7:F8)","v":0},{"$f":"SUM(G7:G8)","v":0},{"$f":"IF(SUM(H7:H8)=0,\"\",SUM(H7:H8))","v":""},{"$f":"IF(SUM(I7:I8)=0,\"\",SUM(I7:I8))","v":""}]
["既存事業"]
["新規事業","-","-","-"]
["②売上原価",{"$f":"IF(B6=\"\",\"\",B10)","v":""},{"$f":"IF(C6=\"\",\"\",C10)","v":""},{"$f":"D10","v":0},{"$f":"SUM(E10:E11)","v":0},{"$f":"SUM(F10:F11)","v":0},{"$f":"SUM(G10:G11)","v":0},{"$f":"IF(H6=\"\",\"\",SUM(H10:H11))","v":""},{"$f":"IF(I6=\"\",\"\",SUM(I10:I11))","v":""}]
["既存事業"]
["新規事業","-","-","-"]
["③売上総利益",{"$f":"IF(B6=\"\",\"\",B6-B9)","v":""},{"$f":"IF(C6=\"\",\"\",C6-C9)","v":""},{"$f":"D6-D9","v":0},0,0,0,{"$f":"IF(H6=\"\",\"\",H6-H9)","v":""},{"$f":"IF(I6=\"\",\"\",I6-I9)","v":""}]
["既存事業",{"$f":"IF(B6=\"\",\"\",B7-B10)","v":""},{"$f":"IF(C6=\"\",\"\",C7-C10)","v":""},0,0,0,0,{"$f":"IF(H6=\"\",\"\",H7-H10)","v":""},{"$f":"IF(I6=\"\",\"\",I7-I10)","v":""}]
["新規事業","-","-","-",{"$f":"E8-E11","v":0},{"$f":"F8-F11","v":0},{"$f":"G8-G11","v":0},{"$f":"IF(H6=\"\",\"\",H8-H11)","v":""},{"$f":"IF(I6=\"\",\"\",I8-I11)","v":""}]
["④販売費及び一般管理費",{"$f":"IF(B6=\"\",\"\",SUM(B16:B17))","v":""},{"$f":"IF(C6=\"\",\"\",SUM(C16:C17))","v":""},{"$f":"D16","v":0},{"$f":"SUM(E16:E17)","v":0},{"$f":"SUM(F16:F17)","v":0},{"$f":"SUM(G16:G17)","v":0},{"$f":"IF(H6=\"\",\"\",SUM(H16:H17))","v":""},{"$f":"IF(I6=\"\",\"\",SUM(I16:I17))","v":""}]
["既存事業"]
["新規事業","-","-","-"]
["⑤営業利益",{"$f":"IF(B6=\"\",\"\",B12-B15)","v":""},{"$f":"IF(C6=\"\",\"\",C12-C15)","v":""},{"$f":"D12-D15","v":0},0,0,0,{"$f":"IF(H6=\"\",\"\",H12-H15)","v":""},{"$f":"IF(I6=\"\",\"\",I12-I15)","v":""}]
["既存事業",{"$f":"IF(B6=\"\",\"\",B13-B16)","v":""},{"$f":"IF(C6=\"\",\"\",C13-C16)","v":""},0,0,0,0,{"$f":"IF(H6=\"\",\"\",H13-H16)","v":""},{"$f":"IF(I6=\"\",\"\",I13-I16)","v":""}]
["新規事業","-","-","-",{"$f":"E14-E17","v":0},{"$f":"F14-F17","v":0},{"$f":"G14-G17","v":0},{"$f":"IF(H6=\"\",\"\",H14-H17)","v":""},{"$f":"IF(I6=\"\",\"\",I14-I17)","v":""}]
["⑥経常利益"]
["⑦給与支給総額",{"$f":"IF(B6=\"\",\"\",B23)","v":""},{"$f":"IF(C6=\"\",\"\",C23)","v":""},{"$f":"D23","v":0},{"$f":"SUM(E23:E24)","v":0},{"$f":"SUM(F23:F24)","v":0},{"$f":"SUM(G23:G24)","v":0},{"$f":"IF(H6=\"\",\"\",SUM(H23:H24))","v":""},{"$f":"IF(I6=\"\",\"\",SUM(I23:I24))","v":""}]
["既存事業",{"$f":"IF(B6=\"\",\"\",IF($F$2=\"法人\",入力シート２【法人用】!B12,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!B9)))","v":""},{"$f":"IF(C6=\"\",\"\",IF($F$2=\"法人\",入力シート２【法人用】!C12,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!C9)))","v":""},{"$f":"IF($F$2=\"法人\",入力シート２【法人用】!D12,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!D9))","v":0},{"$f":"IF($F$2=\"法人\",入力シート２【法人用】!E12,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!E9))","v":0},{"$f":"IF($F$2=\"法人\",入力シート２【法人用】!F12,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!F9))","v":0},{"$f":"IF($F$2=\"法人\",入力シート２【法人用】!G12,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!G9))","v":0},{"$f":"IF(H6=\"\",\"\",IF($F$2=\"法人\",入力シート２【法人用】!H12,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!H9)))","v":""},{"$f":"IF(I6=\"\",\"\",IF($F$2=\"法人\",入力シート２【法人用】!I12,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!I9)))","v":""}]
["新規事業","-","-","-",{"$f":"IF($F$2=\"法人\",入力シート２【法人用】!E22,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!E16))","v":0},{"$f":"IF($F$2=\"法人\",入力シート２【法人用】!F22,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!F16))","v":0},{"$f":"IF($F$2=\"法人\",入力シート２【法人用】!G22,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!G16))","v":0},{"$f":"IF(H6=\"\",\"\",IF($F$2=\"法人\",入力シート２【法人用】!H22,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!H16)))","v":""},{"$f":"IF(I6=\"\",\"\",IF($F$2=\"法人\",入力シート２【法人用】!I22,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!I16)))","v":""}]
["⑧人件費",{"$f":"IF(B6=\"\",\"\",B26)","v":""},{"$f":"IF(C6=\"\",\"\",C26)","v":""},{"$f":"D26","v":0},{"$f":"SUM(E26:E27)","v":0},{"$f":"SUM(F26:F27)","v":0},{"$f":"SUM(G26:G27)","v":0},{"$f":"IF(H6=\"\",\"\",SUM(H26:H27))","v":""},{"$f":"IF(I6=\"\",\"\",SUM(I26:I27))","v":""}]
["既存事業",{"$f":"IF(B6=\"\",\"\",IF($F$2=\"法人\",入力シート２【法人用】!B40,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!B25)))","v":""},{"$f":"IF(C6=\"\",\"\",IF($F$2=\"法人\",入力シート２【法人用】!C40,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!C25)))","v":""},{"$f":"IF($F$2=\"法人\",入力シート２【法人用】!D40,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!D25))","v":0},{"$f":"IF($F$2=\"法人\",入力シート２【法人用】!E40,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!E25))","v":0},{"$f":"IF($F$2=\"法人\",入力シート２【法人用】!F40,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!F25))","v":0},{"$f":"IF($F$2=\"法人\",入力シート２【法人用】!G40,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!G25))","v":0},{"$f":"IF(H6=\"\",\"\",IF($F$2=\"法人\",入力シート２【法人用】!H40,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!H25)))","v":""},{"$f":"IF(I6=\"\",\"\",IF($F$2=\"法人\",入力シート２【法人用】!I40,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!I25)))","v":""}]
["新規事業","-","-","-",{"$f":"IF($F$2=\"法人\",入力シート２【法人用】!E57,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!E33))","v":0},{"$f":"IF($F$2=\"法人\",入力シート２【法人用】!F57,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!F33))","v":0},{"$f":"IF($F$2=\"法人\",入力シート２【法人用】!G57,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!G33))","v":0},{"$f":"IF(H6=\"\",\"\",IF($F$2=\"法人\",入力シート２【法人用】!H57,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!H33)))","v":""},{"$f":"IF(I6=\"\",\"\",IF($F$2=\"法人\",入力シート２【法人用】!I57,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!I33)))","v":""}]
["⑨設備投資額","-","-","-",{"$f":"SUM(E29:E30)","v":0},{"$f":"SUM(F29:F30)","v":0},{"$f":"SUM(G29:G30)","v":0},{"$f":"IF(H6=\"\",\"\",SUM(H29:H30))","v":""},{"$f":"IF(I6=\"\",\"\",SUM(I29:I30))","v":""}]
["既存事業","-","-","-"]
["新規事業","-","-","-"]
["⑩運転資金","-","-","-",{"$f":"SUM(E32:E33)","v":0},{"$f":"SUM(F32:F33)","v":0},{"$f":"SUM(G32:G33)","v":0},{"$f":"IF(H6=\"\",\"\",SUM(H32:H33))","v":""},{"$f":"IF(I6=\"\",\"\",SUM(I32:I33))","v":""}]
["既存事業","-","-","-"]
["新規事業","-","-","-"]
["⑪減価償却額（普通償却）",{"$f":"IF(B6=\"\",\"\",B35)","v":""},{"$f":"IF(C6=\"\",\"\",C35)","v":""},{"$f":"D35","v":0},{"$f":"SUM(E35:E36)","v":0},{"$f":"SUM(F35:F36)","v":0},{"$f":"SUM(G35:G36)","v":0},{"$f":"IF(H6=\"\",\"\",SUM(H35:H36))","v":""},{"$f":"IF(I6=\"\",\"\",SUM(I35:I36))","v":""}]
["既存事業",{"$f":"IF(B6=\"\",\"\",IF($F$2=\"法人\",入力シート２【法人用】!B67,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!B42)))","v":""},{"$f":"IF(C6=\"\",\"\",IF($F$2=\"法人\",入力シート２【法人用】!C67,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!C42)))","v":""},{"$f":"IF($F$2=\"法人\",入力シート２【法人用】!D67,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!D42))","v":0},{"$f":"IF($F$2=\"法人\",入力シート２【法人用】!E67,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!E42))","v":0},{"$f":"IF($F$2=\"法人\",入力シート２【法人用】!F67,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!F42))","v":0},{"$f":"IF($F$2=\"法人\",入力シート２【法人用】!G67,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!G42))","v":0},{"$f":"IF(H6=\"\",\"\",IF($F$2=\"法人\",入力シート２【法人用】!H67,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!H42)))","v":""},{"$f":"IF(I6=\"\",\"\",IF($F$2=\"法人\",入力シート２【法人用】!I67,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!I42)))","v":""}]
["新規事業","-","-","-",{"$f":"IF($F$2=\"法人\",入力シート２【法人用】!E78,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!E53))","v":0},{"$f":"IF($F$2=\"法人\",入力シート２【法人用】!F78,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!F53))","v":0},{"$f":"IF($F$2=\"法人\",入力シート２【法人用】!G78,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!G53))","v":0},{"$f":"IF(H6=\"\",\"\",IF($F$2=\"法人\",入力シート２【法人用】!H78,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!H53)))","v":""},{"$f":"IF(I6=\"\",\"\",IF($F$2=\"法人\",入力シート２【法人用】!I78,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!I53)))","v":""}]
["⑪減価償却額（特別償却）",{"$f":"IF(B6=\"\",\"\",B38)","v":""},{"$f":"IF(C6=\"\",\"\",C38)","v":""},{"$f":"D38","v":0},{"$f":"SUM(E38:E39)","v":0},{"$f":"SUM(F38:F39)","v":0},{"$f":"SUM(G38:G39)","v":0},{"$f":"IF(H6=\"\",\"\",SUM(H38:H39))","v":""},{"$f":"IF(I6=\"\",\"\",SUM(I38:I39))","v":""}]
["既存事業",{"$f":"IF(B6=\"\",\"\",IF($F$2=\"法人\",入力シート２【法人用】!B68,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!B43)))","v":""},{"$f":"IF(C6=\"\",\"\",IF($F$2=\"法人\",入力シート２【法人用】!C68,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!C43)))","v":""},{"$f":"IF($F$2=\"法人\",入力シート２【法人用】!D68,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!D43))","v":0},{"$f":"IF($F$2=\"法人\",入力シート２【法人用】!E68,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!E43))","v":0},{"$f":"IF($F$2=\"法人\",入力シート２【法人用】!F68,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!F43))","v":0},{"$f":"IF($F$2=\"法人\",入力シート２【法人用】!G68,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!G43))","v":0},{"$f":"IF(H6=\"\",\"\",IF($F$2=\"法人\",入力シート２【法人用】!H68,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!H43)))","v":""},{"$f":"IF(I6=\"\",\"\",IF($F$2=\"法人\",入力シート２【法人用】!I68,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!I43)))","v":""}]
["新規事業","-","-","-",{"$f":"IF($F$2=\"法人\",入力シート２【法人用】!E79,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!E54))","v":0},{"$f":"IF($F$2=\"法人\",入力シート２【法人用】!F79,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!F54))","v":0},{"$f":"IF($F$2=\"法人\",入力シート２【法人用】!G79,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!G54))","v":0},{"$f":"IF(H6=\"\",\"\",IF($F$2=\"法人\",入力シート２【法人用】!H79,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!H54)))","v":""},{"$f":"IF(I6=\"\",\"\",IF($F$2=\"法人\",入力シート２【法人用】!I79,IF(入力シート１!$F$2=\"個人事業主\",入力シート２【個人事業主用】!I54)))","v":""}]
["⑫付加価値額",{"$f":"IF(B6=\"\",\"\",SUM(B18,B25,B34))","v":""},{"$f":"IF(C6=\"\",\"\",SUM(C18,C25,C34))","v":""},{"$f":"SUM(D18,D25,D34)","v":0},0,0,0,{"$f":"IF(H6=\"\",\"\",SUM(H18,H25,H34))","v":""},{"$f":"IF(I6=\"\",\"\",SUM(I18,I25,I34))","v":""}]
["既存事業",{"$f":"IF(B6=\"\",\"\",SUM(B19,B26,B35))","v":""},{"$f":"IF(C6=\"\",\"\",SUM(C19,C26,C35))","v":""},0,0,0,0,{"$f":"IF(H6=\"\",\"\",SUM(H19,H26,H35))","v":""},{"$f":"IF(I6=\"\",\"\",SUM(I19,I26,I35))","v":""}]
["新規事業","-","-","-",{"$f":"SUM(E20,E27,E36)","v":0},{"$f":"SUM(F20,F27,F36)","v":0},{"$f":"SUM(G20,G27,G36)","v":0},{"$f":"IF(H6=\"\",\"\",SUM(H20,H27,H36))","v":""},{"$f":"IF(I6=\"\",\"\",SUM(I20,I27,I36))","v":""}]
["⑬従業員数",{"$f":"IF(B6=\"\",\"\",B44)","v":""},{"$f":"IF(C6=\"\",\"\",C44)","v":""},{"$f":"D44","v":0},{"$f":"SUM(E44:E45)","v":0},{"$f":"SUM(F44:F45)","v":0},{"$f":"SUM(G44:G45)","v":0},{"$f":"IF(H6=\"\",\"\",SUM(H44:H45))","v":""},{"$f":"IF(I6=\"\",\"\",SUM(I44:I45))","v":""}]
["既存事業"]
["新規事業","-","-","-"]
["⑭一人当たり付加価値額"]
["既存事業"]
["新規事業"]
["⑮資金調達額","-","-","-",{"$f":"SUM(E50:E53)","v":0},{"$f":"SUM(F50:F53)","v":0},{"$f":"SUM(G50:G53)","v":0},{"$f":"IF(H6=\"\",\"\",SUM(H50:H53))","v":""},{"$f":"IF(I6=\"\",\"\",SUM(I50:I53))","v":""},null,"★チェック（⑮資金調達額＝⑨設備投資額＋⑩運転資金になっているか）"]
["政府系金融機関借入","-","-","-",null,null,null,null,null,null,"直近","1年後","2年後","3年後","4年後","5年後"]
["民間金融機関借入","-","-","-",null,null,null,null,null,null,null,{"$f":"IF(E$49=SUM(E$28,E$31),\"○\",\"×\")","v":"○"},{"$f":"IF(F$49=SUM(F$28,F$31),\"○\",\"×\")","v":"○"},{"$f":"IF(G$49=SUM(G$28,G$31),\"○\",\"×\")","v":"○"},{"$f":"IF(H6=\"\",\"\",IF(H$49=SUM(H$28,H$31),\"○\",\"×\"))","v":""},{"$f":"IF(I6=\"\",\"\",IF(I$49=SUM(I$28,I$31),\"○\",\"×\"))","v":""}]
["自己資金","-","-","-"]
["その他","-","-","-"]

{"sheet":"入力シート２【法人用】","index":5,"n_rows":81,"n_cols":9,"rows_kept":81,"cut":false,"hidden":false,"merged":[]}
["◎入力シート２（給与支給総額・人件費・減価償却費）【法人用】"]
[]
["⑦給与支給総額"]
["◎既存事業（１年後～５年後は合計の入力のみでも構いません）",null,null,null,null,null,null,null,"(単位　円）"]
[null,"２年前","１年前","直近期末","１年後","２年後","３年後","４年後","５年後"]
["役員報酬（役員給与）"]
["従業員給与・給与手当"]
["雑給"]
["賞与"]
["労務費（法定福利費、厚生費、退職金除く）"]
["その他"]
["合計",{"$f":"SUM(B6:B11)","v":0},{"$f":"SUM(C6:C11)","v":0},{"$f":"SUM(D6:D11)","v":0}]
[]
["◎新規事業（１年後～５年後は合計の入力のみでも構いません）",null,null,null,null,null,null,null,"(単位　円）"]
[null,"２年前","１年前","直近期末","１年後","２年後","３年後","４年後","５年後"]
["役員報酬（役員給与）"]
["従業員給与・給与手当"]
["雑給"]
["賞与、賞与引当金繰入"]
["労務費（法定福利費、厚生費、退職金除く）"]
["その他"]
["合計"]
[]
["⑧人件費"]
["◎既存事業（１年後～５年後は合計の入力のみでも構いません）",null,null,null,null,null,null,null,"(単位　円）"]
[null,"２年前","１年前","直近期末","１年後","２年後","３年後","４年後","５年後"]
["役員報酬（役員給与）",{"$f":"B6","v":0},0,0]
["従業員給与・給与手当",0,0,0]
["雑給",0,0,0]
["法定福利費"]
["福利厚生費、厚生費"]
["賞与",{"$f":"B9","v":0},{"$f":"C9","v":0},{"$f":"D9","v":0}]
["賞与引当金繰入"]
["退職金、退職引当金繰入"]
["外注費※"]
["労務費（法定福利費、厚生費、退職金除く）",{"$f":"B10","v":0},{"$f":"C10","v":0},{"$f":"D10","v":0}]
["労務費（法定福利費、厚生費、退職金のみ）"]
["給与支給総額の「その他」",{"$f":"B11","v":0},{"$f":"C11","v":0},{"$f":"D11","v":0}]
["その他"]
["合計",{"$f":"SUM(B27:B39)","v":0},{"$f":"SUM(C27:C39)","v":0},{"$f":"SUM(D27:D39)","v":0}]
["※派遣労働者、短時間労働者の給与を外注費で処理した場合"]
[]
["◎新規事業（１年後～５年後は合計の入力のみでも構いません）",null,null,null,null,null,null,null,"(単位　円）"]
[null,"２年前","１年前","直近期末","１年後","２年後","３年後","４年後","５年後"]
["役員報酬（役員給与）"]
["従業員給与・給与手当"]
["雑給"]
["法定福利費"]
["福利厚生費、厚生費"]
["賞与、賞与引当金繰入"]
["退職金、退職引当金繰入"]
["外注費※"]
["労務費（法定福利費、厚生費、退職金除く）"]
["労務費（法定福利費、厚生費、退職金のみ）"]
["給与支給総額の「その他」"]
["その他"]
["合計"]
["※派遣労働者、短時間労働者の給与を外注費で処理した場合"]
[]
["⑪減価償却費"]
["◎既存事業（１年後～５年後は小計の入力のみでも構いません）",null,null,null,null,null,null,null,"(単位　円）"]
[null,"２年前","１年前","直近期末","１年後","２年後","３年後","４年後","５年後"]
["減価償却費"]
["リース料※"]
["繰延資産償却"]
["その他"]
["普通償却（小計）",{"$f":"SUM(B63:B66)","v":0},{"$f":"SUM(C63:C66)","v":0},{"$f":"SUM(D63:D66)","v":0}]
["特別償却（小計）"]
["合計",{"$f":"SUM(B67:B68)","v":0},0,0,0,0,0,0,0]
["※地代・家賃以外の賃借料を含めてください（賃借料から地代・家賃を除けない場合は含みません）"]
[]
["◎新規事業（１年後～５年後は合計の入力のみでも構いません）",null,null,null,null,null,null,null,"(単位　円）"]
[null,"２年前","１年前","直近期末","１年後","２年後","３年後","４年後","５年後"]
["減価償却費"]
["リース料※"]
["繰延資産償却"]
["その他"]
["普通償却（小計）"]
["特別償却（小計）"]
["合計",null,null,null,{"$f":"SUM(E78:E79)","v":0},{"$f":"SUM(F78:F79)","v":0},{"$f":"SUM(G78:G79)","v":0},{"$f":"SUM(H78:H79)","v":0},{"$f":"SUM(I78:I79)","v":0}]
["※地代・家賃以外の賃借料を含めてください（賃借料から地代・家賃を除けない場合は含みません）"]

{"sheet":"入力シート２【個人事業主用】","index":6,"n_rows":56,"n_cols":9,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
["◎入力シート２（給与支給総額・人件費・減価償却費）【個人事業主用】"]
[]
["⑦給与支給総額"]
["◎既存事業（１年後～５年後は合計の入力のみでも構いません）",null,null,null,null,null,null,null,"(単位　円）"]
[null,"２年前","１年前","直近期末","１年後","２年後","３年後","４年後","５年後"]
["給与賃金⑳"]
["専従者給与㊳"]
["青色申告控除前の所得金額㊸"]
["合計",{"$f":"SUM(B6:B8)","v":0},{"$f":"SUM(C6:C8)","v":0},{"$f":"SUM(D6:D8)","v":0}]
[]
["◎新規事業（１年後～５年後は合計の入力のみでも構いません）",null,null,null,null,null,null,null,"(単位　円）"]
[null,"２年前","１年前","直近期末","１年後","２年後","３年後","４年後","５年後"]
["給与賃金⑳"]
["専従者給与㊳"]
["青色申告控除前の所得金額㊸"]
["合計"]
[]
["⑧人件費"]
["◎既存事業（１年後～５年後は合計の入力のみでも構いません）",null,null,null,null,null,null,null,"(単位　円）"]
[null,"２年前","１年前","直近期末","１年後","２年後","３年後","４年後","５年後"]
["福利厚生費⑲"]
["給与賃金⑳",{"$f":"B6","v":0},0,0]
["専従者給与㊳",0,0,0]
["法定福利費"]
["合計",{"$f":"SUM(B21:B24)","v":0},{"$f":"SUM(C21:C24)","v":0},{"$f":"SUM(D21:D24)","v":0}]
[]
["◎新規事業（１年後～５年後は合計の入力のみでも構いません）",null,null,null,null,null,null,null,"(単位　円）"]
[null,"２年前","１年前","直近期末","１年後","２年後","３年後","４年後","５年後"]
["福利厚生費⑲"]
["給与賃金⑳"]
["専従者給与㊳"]
["法定福利費"]
["合計"]
[]
["⑪減価償却費"]
["◎既存事業（１年後～５年後は小計の入力のみでも構いません）",null,null,null,null,null,null,null,"(単位　円）"]
[null,"２年前","１年前","直近期末","１年後","２年後","３年後","４年後","５年後"]
["減価償却費"]
["リース料※"]
["繰延資産償却"]
["その他"]
["普通償却（小計）",{"$f":"SUM(B38:B41)","v":0},{"$f":"SUM(C38:C41)","v":0},{"$f":"SUM(D38:D41)","v":0}]
["特別償却（小計）"]
["合計",{"$f":"SUM(B42:B43)","v":0},0,0,0,0,0,0,0]
["※地代・家賃以外の賃借料を含めてください（賃借料から地代・家賃を除けない場合は含みません）"]
[]
["◎新規事業（１年後～５年後は小計の入力のみでも構いません）",null,null,null,null,null,null,null,"(単位　円）"]
[null,"２年前","１年前","直近期末","１年後","２年後","３年後","４年後","５年後"]
["減価償却費"]
["リース料※"]
["繰延資産償却"]
["その他"]
["普通償却（小計）"]
["特別償却（小計）"]
["合計",null,null,null,{"$f":"SUM(E53:E54)","v":0},{"$f":"SUM(F53:F54)","v":0},{"$f":"SUM(G53:G54)","v":0},{"$f":"SUM(H53:H54)","v":0},{"$f":"SUM(I53:I54)","v":0}]
["※地代・家賃以外の賃借料を含めてください（賃借料から地代・家賃を除けない場合は含みません）"]

{"sheet":"個人事業主の計算方法","index":7,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["★個人事業主の場合の計算方法"]