{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["ご利用方法","過去３期データ入力","計画数値データ入力","計画全体（自動出力）","申請書＜別表３＞（自動出力）","数値目標確認（自動出力）","別表3インポート用マクロ","マクロ有効化の手順"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":8,"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":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":false,"merged":[[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,31,1],[16,1,23,1],[1,4,1,5],[4,1,5,2],[6,1,6,2],[7,1,14,1],[15,1,15,2]]}
[null,"「別表３」作成支援システム（法人用）＜過去３期データ入力＞　R7.4改訂版"]
[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":"D15-(D8+D9+D10+D11+D12+D13)","v":0},{"$f":"E15-(E8+E9+E10+E11+E12+E13)","v":0},0]
[null,null,"計"]
[null,"売上総利益　　　",null,{"$f":"D7-D15","v":0},{"$f":"E7-E15","v":0},{"$f":"F7-F15","v":0}]
[null,"販売費及び一般管理費","役員報酬、給与・賃金、賞与、雑給等"]
[null,null,"福利厚生・法定福利費・退職金等"]
[null,null,"減価償却費(普通)"]
[null,null,"減価償却費(特別)"]
[null,null,"賃借料(地代・家賃を除く)"]
[null,null,"リース料"]
[null,null,"上記以外　　　",{"$f":"D24-(D17+D18+D19+D20+D21+D22)","v":0},{"$f":"E24-(E17+E18+E19+E20+E21+E22)","v":0},0]
[null,null," 計    "]
[null,"営業利益　　　　 ",null,{"$f":"D16-D24","v":0},{"$f":"E16-E24","v":0},{"$f":"F16-F24","v":0}]
[null,"営業外収益"]
[null,"営業外費用"]
[null,"経常利益　　　　 "]
[null,"■資金"]
[null,"資金内訳","運転資金　　　",{"$f":"ROUND((D15+D24)/12,-2)","v":0},{"$f":"ROUND((E15+E24)/12,-2)","v":0},{"$f":"ROUND((F15+F24)/12,-2)","v":0}]
[null,null,"設備投資額（税込み）"]
[null,null,"計",{"$f":"SUM(D30:D31)","v":0},{"$f":"SUM(E30:E31)","v":0},{"$f":"SUM(F30:F31)","v":0}]
[null,"■人員配分",null,null,null,"（単位：人）"]
[null,"労務給与・賞与、雑給等\n対象人数（換算値）　 "]
[null,"役員報酬、給与・賞与、雑給等\n対象人数（換算値）　"]
[null,"計（換算値）",null,{"$f":"SUM(D34:D35)","v":0},0,0]

{"sheet":"計画数値データ入力","index":2,"n_rows":73,"n_cols":22,"rows_kept":73,"cut":false,"hidden":false,"merged":[[72,0,72,1],[72,2,72,5],[72,6,72,7],[72,8,72,9],[72,10,72,11],[71,0,71,1],[71,2,71,5],[71,6,71,7],[71,8,71,9],[71,10,71,11],[72,12,72,13],[72,14,72,15],[72,16,72,17],[72,18,72,19],[70,20,70,21],[72,20,72,21],[71,12,71,13],[71,14,71,15],[71,16,71,17],[71,18,71,19],[71,20,71,21],[67,18,67,19],[67,20,67,21],[68,3,68,5],[69,0,69,1],[69,20,69,21],[70,0,70,1],[70,2,70,5],[70,6,70,7],[70,8,70,9],[70,10,70,11],[67,2,67,5],[67,6,67,7],[67,8,67,9],[67,10,67,11],[67,12,67,13],[67,14,67,15],[67,16,67,17],[70,12,70,13],[70,14,70,15],[70,16,70,17],[70,18,70,19],[66,2,66,5],[66,6,66,7],[66,8,66,9],[66,10,66,11],[66,12,66,13],[66,14,66,15],[65,10,65,11],[65,12,65,13],[65,14,65,15],[65,2,65,5],[65,6,65,7],[65,8,65,9],[65,16,65,17],[65,18,65,19],[65,20,65,21],[66,16,66,17],[66,18,66,19],[66,20,66,21],[62,18,62,19],[62,20,62,21],[63,0,66,0],[63,2,63,5],[63,6,63,7],[63,8,63,9],[63,10,63,11],[63,12,63,13],[63,14,63,15],[63,16,63,17],[63,18,63,19],[63,20,63,21],[64,2,64,5],[64,6,64,7],[64,8,64,9],[64,10,64,11],[64,12,64,13],[64,14,64,15],[59,20,59,21],[60,10,60,11],[60,12,60,13],[60,14,60,15],[60,2,60,5],[60,6,60,7],[60,8,60,9],[64,16,64,17],[64,18,64,19],[64,20,64,21],[62,16,62,17],[61,16,61,17],[61,18,61,19],[61,20,61,21],[62,2,62,5],[62,6,62,7],[62,8,62,9],[62,10,62,11],[62,12,62,13],[62,14,62,15],[61,10,61,11],[61,12,61,13],[61,14,61,15],[59,8,59,9],[59,10,59,11],[59,12,59,13],[59,14,59,15],[61,2,61,5],[61,6,61,7],[61,8,61,9],[59,16,59,17],[59,18,59,19],[52,0,52,1],[52,2,52,5],[53,0,53,21],[54,0,56,0],[54,2,54,5],[55,2,55,5],[56,2,56,5],[60,16,60,17],[60,18,60,19],[60,20,60,21],[57,0,57,21],[58,0,61,0],[58,1,60,1],[58,2,58,5],[58,6,58,7],[58,8,58,9],[58,10,58,11],[58,12,58,13],[58,14,58,15],[58,16,58,17],[58,18,58,19],[58,20,58,21],[59,2,59,5],[59,6,59,7],[48,0,48,21],[49,0,49,1],[49,2,49,5],[50,0,50,1],[50,2,50,5],[51,0,51,1],[51,2,51,5],[45,0,45,1],[45,2,45,5],[46,0,46,1],[46,2,46,5],[47,0,47,1],[47,2,47,5],[42,0,42,1],[42,2,42,5],[43,0,43,1],[43,2,43,5],[38,0,39,1],[38,2,39,5],[38,6,38,7],[44,0,44,1],[44,2,44,5],[40,0,40,1],[40,2,40,5],[41,0,41,1],[41,2,41,5],[37,20,37,21],[34,12,34,13],[34,14,34,15],[34,16,34,17],[34,18,34,19],[34,20,34,21],[39,6,39,7],[39,8,39,9],[39,10,39,11],[39,12,39,13],[39,14,39,15],[39,16,39,17],[39,18,39,19],[39,20,39,21],[35,0,35,1],[35,4,35,5],[35,6,35,7],[35,8,35,9],[34,10,34,11],[35,10,35,11],[34,0,34,1],[34,4,34,5],[34,6,34,7],[34,8,34,9],[38,14,38,15],[38,16,38,17],[38,18,38,19],[38,20,38,21],[35,12,35,13],[35,14,35,15],[35,16,35,17],[35,18,35,19],[38,8,38,9],[38,10,38,11],[38,12,38,13],[35,20,35,21],[31,3,31,5],[32,0,32,5],[32,20,32,21],[33,0,33,1],[33,4,33,5],[33,6,33,7],[33,8,33,9],[33,10,33,11],[33,12,33,13],[33,14,33,15],[33,16,33,17],[33,18,33,19],[33,20,33,21],[28,18,28,19],[28,20,28,21],[29,16,29,17],[29,18,29,19],[29,20,29,21],[30,2,30,5],[30,6,30,7],[30,8,30,9],[30,10,30,11],[30,12,30,13],[30,14,30,15],[30,16,30,17],[29,2,29,5],[29,6,29,7],[29,8,29,9],[29,10,29,11],[29,12,29,13],[29,14,29,15],[30,18,30,19],[30,20,30,21],[26,18,26,19],[26,20,26,21],[27,2,27,5],[27,6,27,7],[27,8,27,9],[27,10,27,11],[27,12,27,13],[27,14,27,15],[27,16,27,17],[27,18,27,19],[27,20,27,21],[26,0,29,0],[26,2,26,5],[26,6,26,7],[26,8,26,9],[26,10,26,11],[26,12,26,13],[26,14,26,15],[26,16,26,17],[23,0,25,0],[28,2,28,5],[28,6,28,7],[28,8,28,9],[28,10,28,11],[28,12,28,13],[28,14,28,15],[28,16,28,17],[25,4,25,5],[25,6,25,7],[25,8,25,9],[25,10,25,11],[25,12,25,13],[25,14,25,15],[25,16,25,17],[25,18,25,19],[25,20,25,21],[23,14,23,15],[23,16,23,17],[23,18,23,19],[23,20,23,21],[24,4,24,5],[24,6,24,7],[24,8,24,9],[24,10,24,11],[24,12,24,13],[24,14,24,15],[23,4,23,5],[23,6,23,7],[23,8,23,9],[23,10,23,11],[23,12,23,13],[24,16,24,17],[24,18,24,19],[24,20,24,21],[15,0,15,1],[16,0,16,1],[17,0,17,1],[18,0,18,21],[19,0,21,0],[22,0,22,21],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,21],[14,0,14,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[3,16,3,17],[3,18,3,19],[3,20,3,21],[4,4,4,5],[4,6,4,7],[4,8,4,9],[4,10,4,11],[4,12,4,13],[4,14,4,15],[4,16,4,17],[1,14,1,15],[1,16,1,20],[2,20,2,21],[3,0,4,1],[3,4,3,5],[3,6,3,7],[3,8,3,9],[3,10,3,11],[3,12,3,13],[3,14,3,15],[4,18,4,19],[4,20,4,21]]}
["「別表３」作成支援システム（法人用）＜入力２＞"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"企業名",null,{"$f":"過去３期データ入力!E2","v":0}]
["【既存事業の売上計画等】",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(単位：千円）"]
[null,null,"２年前\n※自動出力","１年前\n※自動出力","直近期末\n※自動出力",null,"１年後",null,"２年後",null,"３年後",null,"４年後",null,"５年後",null,"６年後",null,"７年後",null,"８年後"]
[null,null,{"$f":"過去３期データ入力!D6","v":"( 年 月期)"},{"$f":"過去３期データ入力!E6","v":"( 年 月期)"},{"$f":"過去３期データ入力!F6","v":"( 年 月期)"},null,"( 年 月期)",null,"( 年 月期)",null,"( 年 月期)",null,"( 年 月期)",null,"( 年 月期)",null,"( 年 月期)",null,"( 年 月期)",null,"( 年 月期)"]
["売上高",null,{"$f":"過去３期データ入力!D7","v":0},{"$f":"過去３期データ入力!E7","v":0},{"$f":"過去３期データ入力!F7","v":0},100,null,100,null,100,null,100,null,100,null,100,null,100,null,100,null,100]
["売上原価",null,{"$f":"過去３期データ入力!D15","v":0},{"$f":"過去３期データ入力!E15","v":0},{"$f":"過去３期データ入力!F15","v":0},{"$f":"IF(E$6=0,\"－\",IF(E7<=0,\"－\",E7/E$6*100))","v":"－"},null,{"$f":"IF(G$6=0,\"－\",IF(G7<=0,\"－\",G7/G$6*100))","v":"－"},null,{"$f":"IF(I$6=0,\"－\",IF(I7<=0,\"－\",I7/I$6*100))","v":"－"},null,{"$f":"IF(K$6=0,\"－\",IF(K7<=0,\"－\",K7/K$6*100))","v":"－"},null,{"$f":"IF(M$6=0,\"－\",IF(M7<=0,\"－\",M7/M$6*100))","v":"－"},null,{"$f":"IF(O$6=0,\"－\",IF(O7<=0,\"－\",O7/O$6*100))","v":"－"},null,{"$f":"IF(Q$6=0,\"－\",IF(Q7<=0,\"－\",Q7/Q$6*100))","v":"－"},null,{"$f":"IF(S$6=0,\"－\",IF(S7<=0,\"－\",S7/S$6*100))","v":"－"},null,{"$f":"IF(U$6=0,\"－\",IF(U7<=0,\"－\",U7/U$6*100))","v":"－"}]
["売上総利益",null,{"$f":"過去３期データ入力!D16","v":0},{"$f":"過去３期データ入力!E16","v":0},{"$f":"過去３期データ入力!F16","v":0},"－",{"$f":"G6-G7","v":0},"－",{"$f":"I6-I7","v":0},"－",{"$f":"K6-K7","v":0},"－",{"$f":"M6-M7","v":0},"－",{"$f":"O6-O7","v":0},"－",{"$f":"Q6-Q7","v":0},"－",{"$f":"S6-S7","v":0},"－",{"$f":"U6-U7","v":0},"－"]
["販売費及び一般管理費",null,{"$f":"過去３期データ入力!D24","v":0},{"$f":"過去３期データ入力!E24","v":0},{"$f":"過去３期データ入力!F24","v":0},"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－"]
["営業利益   ",null,{"$f":"過去３期データ入力!D25","v":0},{"$f":"過去３期データ入力!E25","v":0},{"$f":"過去３期データ入力!F25","v":0},"－",{"$f":"G8-G9","v":0},"－",{"$f":"I8-I9","v":0},"－",{"$f":"K8-K9","v":0},"－",{"$f":"M8-M9","v":0},"－",{"$f":"O8-O9","v":0},"－",{"$f":"Q8-Q9","v":0},"－",{"$f":"S8-S9","v":0},"－",{"$f":"U8-U9","v":0},"－"]
["営業外収益",null,{"$f":"過去３期データ入力!D26","v":0},{"$f":"過去３期データ入力!E26","v":0},{"$f":"過去３期データ入力!F26","v":0},"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－"]
["営業外費用",null,{"$f":"過去３期データ入力!D27","v":0},{"$f":"過去３期データ入力!E27","v":0},{"$f":"過去３期データ入力!F27","v":0},"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－"]
["経常利益   ",null,{"$f":"過去３期データ入力!D28","v":0},{"$f":"過去３期データ入力!E28","v":0},{"$f":"過去３期データ入力!F28","v":0},"－",{"$f":"G10+G11-G12","v":0},"－",{"$f":"I10+I11-I12","v":0},"－",{"$f":"K10+K11-K12","v":0},"－",{"$f":"M10+M11-M12","v":0},"－",{"$f":"O10+O11-O12","v":0},"－",{"$f":"Q10+Q11-Q12","v":0},"－",{"$f":"S10+S11-S12","v":0},"－",{"$f":"U10+U11-U12","v":0},"－"]
["■給与支給総額及び人件費（既存事業）"]
["売上原価の労務給与等",null,{"$f":"過去３期データ入力!D8","v":0},{"$f":"過去３期データ入力!E8","v":0},{"$f":"過去３期データ入力!F8","v":0},{"$f":"IF(E$6=0,\"－\",IF(E15<=0,\"－\",E15/E$6*100))","v":"－"},null,{"$f":"IF(G$6=0,\"－\",IF(G15<=0,\"－\",G15/G$6*100))","v":"－"},null,{"$f":"IF(I$6=0,\"－\",IF(I15<=0,\"－\",I15/I$6*100))","v":"－"},null,{"$f":"IF(K$6=0,\"－\",IF(K15<=0,\"－\",K15/K$6*100))","v":"－"},null,{"$f":"IF(M$6=0,\"－\",IF(M15<=0,\"－\",M15/M$6*100))","v":"－"},null,{"$f":"IF(O$6=0,\"－\",IF(O15<=0,\"－\",O15/O$6*100))","v":"－"},null,{"$f":"IF(Q$6=0,\"－\",IF(Q15<=0,\"－\",Q15/Q$6*100))","v":"－"},null,{"$f":"IF(S$6=0,\"－\",IF(S15<=0,\"－\",S15/S$6*100))","v":"－"},null,{"$f":"IF(U$6=0,\"－\",IF(U15<=0,\"－\",U15/U$6*100))","v":"－"}]
["販管費の役員報酬・給与等",null,{"$f":"+過去３期データ入力!D17","v":0},{"$f":"+過去３期データ入力!E17","v":0},{"$f":"+過去３期データ入力!F17","v":0},{"$f":"IF(E$6=0,\"－\",IF(E16<=0,\"－\",E16/E$6*100))","v":"－"},null,{"$f":"IF(G$6=0,\"－\",IF(G16<=0,\"－\",G16/G$6*100))","v":"－"},null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－"]
["福利厚生・法定福利費・退職金等",null,{"$f":"過去３期データ入力!D9+過去３期データ入力!D18","v":0},{"$f":"過去３期データ入力!E9+過去３期データ入力!E18","v":0},{"$f":"過去３期データ入力!F9+過去３期データ入力!F18","v":0},{"$f":"IF(E$6=0,\"－\",IF(E17<=0,\"－\",E17/E$6*100))","v":"－"},null,{"$f":"IF(G$6=0,\"－\",IF(G17<=0,\"－\",G17/G$6*100))","v":"－"},null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－"]
["人件費     ",null,{"$f":"SUM(C15:C17)","v":0},{"$f":"SUM(D15:D17)","v":0},{"$f":"SUM(E15:E17)","v":0},{"$f":"IF(E$6=0,\"－\",IF(E18<=0,\"－\",E18/E$6*100))","v":"－"},{"$f":"SUM(G15:G17)","v":0},{"$f":"IF(G$6=0,\"－\",IF(G18<=0,\"－\",G18/G$6*100))","v":"－"},{"$f":"SUM(I15:I17)","v":0},"－",{"$f":"SUM(K15:K17)","v":0},"－",{"$f":"SUM(M15:M17)","v":0},"－",{"$f":"SUM(O15:O17)","v":0},"－",{"$f":"SUM(Q15:Q17)","v":0},"－",{"$f":"SUM(S15:S17)","v":0},"－",{"$f":"SUM(U15:U17)","v":0},"－"]
["■減価償却費等（既存事業）"]
["減価償却費","普通償却額＋賃借料（地代・家賃を除く）＋リース料",{"$f":"過去３期データ入力!D10+過去３期データ入力!D12+過去３期データ入力!D13+過去３期データ入力!D19+過去３期データ入力!D21+過去３期データ入力!D22","v":0},{"$f":"過去３期データ入力!E10+過去３期データ入力!E12+過去３期データ入力!E13+過去３期データ入力!E19+過去３期データ入力!E21+過去３期データ入力!E22","v":0},{"$f":"過去３期データ入力!F10+過去３期データ入力!F12+過去３期データ入力!F13+過去３期データ入力!F19+過去３期データ入力!F21+過去３期データ入力!F22","v":0},{"$f":"IF(E$6=0,\"－\",IF(E20<=0,\"－\",E20/E$6*100))","v":"－"},null,{"$f":"IF(G$6=0,\"－\",IF(G20<=0,\"－\",G20/G$6*100))","v":"－"},null,{"$f":"IF(I$6=0,\"－\",IF(I20<=0,\"－\",I20/I$6*100))","v":"－"},null,{"$f":"IF(K$6=0,\"－\",IF(K20<=0,\"－\",K20/K$6*100))","v":"－"},null,{"$f":"IF(M$6=0,\"－\",IF(M20<=0,\"－\",M20/M$6*100))","v":"－"},null,{"$f":"IF(O$6=0,\"－\",IF(O20<=0,\"－\",O20/O$6*100))","v":"－"},null,{"$f":"IF(Q$6=0,\"－\",IF(Q20<=0,\"－\",Q20/Q$6*100))","v":"－"},null,{"$f":"IF(S$6=0,\"－\",IF(S20<=0,\"－\",S20/S$6*100))","v":"－"},null,{"$f":"IF(U$6=0,\"－\",IF(U20<=0,\"－\",U20/U$6*100))","v":"－"}]
[null,"特別償却額",{"$f":"過去３期データ入力!D11+過去３期データ入力!D20","v":0},{"$f":"過去３期データ入力!E11+過去３期データ入力!E20","v":0},{"$f":"過去３期データ入力!F11+過去３期データ入力!F20","v":0},{"$f":"IF(E$6=0,\"－\",IF(E21<=0,\"－\",E21/E$6*100))","v":"－"},null,{"$f":"IF(G$6=0,\"－\",IF(G21<=0,\"－\",G21/G$6*100))","v":"－"},null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－"]
[null,"計　",{"$f":"C20+C21","v":0},{"$f":"D20+D21","v":0},{"$f":"E20+E21","v":0},{"$f":"IF(E$6=0,\"－\",IF(E22<=0,\"－\",E22/E$6*100))","v":"－"},{"$f":"G20+G21","v":0},{"$f":"IF(G$6=0,\"－\",IF(G22<=0,\"－\",G22/G$6*100))","v":"－"},{"$f":"I20+I21","v":0},"－",{"$f":"K20+K21","v":0},"－",{"$f":"M20+M21","v":0},"－",{"$f":"O20+O21","v":0},"－",{"$f":"Q20+Q21","v":0},"－",{"$f":"S20+S21","v":0},"－",{"$f":"U20+U21","v":0},"－"]
["■必要資金及び資金調達（既存事業）"]
["必要資金","運転資金 ",{"$f":"過去３期データ入力!D30","v":0},{"$f":"過去３期データ入力!E30","v":0},{"$f":"過去３期データ入力!F30","v":0},null,{"$f":"ROUND((G7+G9)/12,-2)","v":0},null,{"$f":"ROUND((I7+I9)/12,-2)","v":0},null,{"$f":"ROUND((K7+K9)/12,-2)","v":0},null,{"$f":"ROUND((M7+M9)/12,-2)","v":0},null,{"$f":"ROUND((O7+O9)/12,-2)","v":0},null,{"$f":"ROUND((Q7+Q9)/12,-2)","v":0},null,{"$f":"ROUND((S7+S9)/12,-2)","v":0},null,{"$f":"ROUND((U7+U9)/12,-2)","v":0}]
[null,"設備投資額（税込み）",{"$f":"過去３期データ入力!D31","v":0},{"$f":"過去３期データ入力!E31","v":0},{"$f":"過去３期データ入力!F31","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,"計　",{"$f":"C24+C25","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["資金調達額","政府系金融機関"]
[null,"民間金融機関"]
[null,"自己資金"]
[null,"その他"]
[null,"計　",null,null,null,null,{"$f":"SUM(G27:H30)","v":0},{"$f":"H28+H30","v":0},{"$f":"SUM(I27:J30)","v":0},{"$f":"J28+J30","v":0},{"$f":"SUM(K27:L30)","v":0},{"$f":"L28+L30","v":0},{"$f":"SUM(M27:N30)","v":0},{"$f":"N28+N30","v":0},{"$f":"SUM(O27:P30)","v":0},{"$f":"P28+P30","v":0},{"$f":"SUM(Q27:R30)","v":0},{"$f":"R28+R30","v":0},{"$f":"SUM(S27:T30)","v":0},{"$f":"T28+T30","v":0},{"$f":"SUM(U27:V30)","v":0},{"$f":"V28+V30","v":0}]
[null,null,null,null,null,null,{"$f":"IF(G26=G31,\" \",\"エラー\")","v":" "}," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
["■人員配分（既存事業）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（単位：人）"]
["売上原価の労務給与等\n対象人数（換算値）　 ",null,{"$f":"過去３期データ入力!D34","v":0},{"$f":"過去３期データ入力!E34","v":0},{"$f":"過去３期データ入力!F34","v":0}]
["販管費の役員報酬・給与等\n対象人数（換算値）　 ",null,{"$f":"過去３期データ入力!D35","v":0},{"$f":"過去３期データ入力!E35","v":0},{"$f":"過去３期データ入力!F35","v":0}]
["計",null,{"$f":"C34+C35","v":0},{"$f":"D34+D35","v":0},{"$f":"E34+E35","v":0},{"$f":"SUM(F34:F35)","v":0},{"$f":"G34+G35","v":0},0,{"$f":"I34+I35","v":0},{"$f":"SUM(J34:J35)","v":0},{"$f":"K34+K35","v":0},{"$f":"SUM(L34:L35)","v":0},{"$f":"M34+M35","v":0},{"$f":"SUM(N34:N35)","v":0},{"$f":"O34+O35","v":0},{"$f":"SUM(P34:P35)","v":0},{"$f":"Q34+Q35","v":0},{"$f":"SUM(R34:R35)","v":0},{"$f":"S34+S35","v":0},{"$f":"SUM(T34:T35)","v":0},{"$f":"U34+U35","v":0},{"$f":"SUM(V34:V35)","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,"５年後",null,"６年後",null,"７年後",null,"８年後"]
[null,null,null,null,null,null,{"$f":"G5","v":"( 年 月期)"},null,{"$f":"I5","v":"( 年 月期)"},null,{"$f":"K5","v":"( 年 月期)"},null,{"$f":"M5","v":"( 年 月期)"},null,{"$f":"O5","v":"( 年 月期)"},null,{"$f":"Q5","v":"( 年 月期)"},null,{"$f":"S5","v":"( 年 月期)"},null,{"$f":"U5","v":"( 年 月期)"}]
["売上高",null,null,null,null,null,null,100,null,100,null,100,null,100,null,100,null,100,null,100,null,100]
["売上原価",null,null,null,null,null,null,{"$f":"IF(G$6=0,\"－\",IF(G42<=0,\"－\",G42/G$6*100))","v":"－"},null,{"$f":"IF(I$6=0,\"－\",IF(I42<=0,\"－\",I42/I$6*100))","v":"－"},null,{"$f":"IF(K$6=0,\"－\",IF(K42<=0,\"－\",K42/K$6*100))","v":"－"},null,{"$f":"IF(M$6=0,\"－\",IF(M42<=0,\"－\",M42/M$6*100))","v":"－"},null,{"$f":"IF(O$6=0,\"－\",IF(O42<=0,\"－\",O42/O$6*100))","v":"－"},null,{"$f":"IF(Q$6=0,\"－\",IF(Q42<=0,\"－\",Q42/Q$6*100))","v":"－"},null,{"$f":"IF(S$6=0,\"－\",IF(S42<=0,\"－\",S42/S$6*100))","v":"－"},null,{"$f":"IF(U$6=0,\"－\",IF(U42<=0,\"－\",U42/U$6*100))","v":"－"}]
["売上総利益",null,null,null,null,null,{"$f":"G41-G42","v":0},"－",{"$f":"I41-I42","v":0},"－",{"$f":"K41-K42","v":0},"－",{"$f":"M41-M42","v":0},"－",{"$f":"O41-O42","v":0},"－",{"$f":"Q41-Q42","v":0},"－",{"$f":"S41-S42","v":0},"－",{"$f":"U41-U42","v":0},"－"]
["販売費及び一般管理費",null,null,null,null,null,null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－"]
["営業利益   ",null,null,null,null,null,{"$f":"G43-G44","v":0},"－",{"$f":"I43-I44","v":0},"－",{"$f":"K43-K44","v":0},"－",{"$f":"M43-M44","v":0},"－",{"$f":"O43-O44","v":0},"－",{"$f":"Q43-Q44","v":0},"－",{"$f":"S43-S44","v":0},"－",{"$f":"U43-U44","v":0},"－"]
["営業外収益",null,null,null,null,null,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,{"$f":"G45+G46-G47","v":0},"－",{"$f":"I45+I46-I47","v":0},"－",{"$f":"K45+K46-K47","v":0},"－",{"$f":"M45+M46-M47","v":0},"－",{"$f":"O45+O46-O47","v":0},"－",{"$f":"Q45+Q46-Q47","v":0},"－",{"$f":"S45+S46-S47","v":0},"－",{"$f":"U45+U46-U47","v":0},"－"]
["■給与支給総額及び人件費（新事業）"]
["売上原価の労務給与等",null,null,null,null,null,null,{"$f":"IF(G$6=0,\"－\",IF(G50<=0,\"－\",G50/G$6*100))","v":"－"},null,{"$f":"IF(I$6=0,\"－\",IF(I50<=0,\"－\",I50/I$6*100))","v":"－"},null,{"$f":"IF(K$6=0,\"－\",IF(K50<=0,\"－\",K50/K$6*100))","v":"－"},null,{"$f":"IF(M$6=0,\"－\",IF(M50<=0,\"－\",M50/M$6*100))","v":"－"},null,{"$f":"IF(O$6=0,\"－\",IF(O50<=0,\"－\",O50/O$6*100))","v":"－"},null,{"$f":"IF(Q$6=0,\"－\",IF(Q50<=0,\"－\",Q50/Q$6*100))","v":"－"},null,{"$f":"IF(S$6=0,\"－\",IF(S50<=0,\"－\",S50/S$6*100))","v":"－"},null,{"$f":"IF(U$6=0,\"－\",IF(U50<=0,\"－\",U50/U$6*100))","v":"－"}]
["販管費の給与等",null,null,null,null,null,null,{"$f":"IF(G$6=0,\"－\",IF(G51<=0,\"－\",G51/G$6*100))","v":"－"},null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－"]
["福利厚生・法定福利費等",null,null,null,null,null,null,{"$f":"IF(G$6=0,\"－\",IF(G52<=0,\"－\",G52/G$6*100))","v":"－"},null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－"]
["人件費    ",null,null,null,null,null,{"$f":"SUM(G50:G52)","v":0},{"$f":"IF(G$6=0,\"－\",IF(G53<=0,\"－\",G53/G$6*100))","v":"－"},{"$f":"SUM(I50:I52)","v":0},"－",{"$f":"SUM(K50:K52)","v":0},"－",{"$f":"SUM(M50:M52)","v":0},"－",{"$f":"SUM(O50:O52)","v":0},"－",{"$f":"SUM(Q50:Q52)","v":0},"－",{"$f":"SUM(S50:S52)","v":0},"－",{"$f":"SUM(U50:U52)","v":0},"－"]
["■減価償却費等(新事業）"]
["減価償却費","普通償却額＋賃借料（地代・家賃を除く）＋リース",null,null,null,null,null,{"$f":"IF(G$6=0,\"－\",IF(G55<=0,\"－\",G55/G$6*100))","v":"－"},null,{"$f":"IF(I$6=0,\"－\",IF(I55<=0,\"－\",I55/I$6*100))","v":"－"},null,{"$f":"IF(K$6=0,\"－\",IF(K55<=0,\"－\",K55/K$6*100))","v":"－"},null,{"$f":"IF(M$6=0,\"－\",IF(M55<=0,\"－\",M55/M$6*100))","v":"－"},null,{"$f":"IF(O$6=0,\"－\",IF(O55<=0,\"－\",O55/O$6*100))","v":"－"},null,{"$f":"IF(Q$6=0,\"－\",IF(Q55<=0,\"－\",Q55/Q$6*100))","v":"－"},null,{"$f":"IF(S$6=0,\"－\",IF(S55<=0,\"－\",S55/S$6*100))","v":"－"},null,{"$f":"IF(U$6=0,\"－\",IF(U55<=0,\"－\",U55/U$6*100))","v":"－"}]
[null,"特別償却額",null,null,null,null,null,{"$f":"IF(G$6=0,\"－\",IF(G56<=0,\"－\",G56/G$6*100))","v":"－"},null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－"]
[null,"計　",null,null,null,null,{"$f":"G55+G56","v":0},{"$f":"IF(G$6=0,\"－\",IF(G57<=0,\"－\",G57/G$6*100))","v":"－"},{"$f":"I55+I56","v":0},"－",{"$f":"K55+K56","v":0},"－",{"$f":"M55+M56","v":0},"－",{"$f":"O55+O56","v":0},"－",{"$f":"Q55+Q56","v":0},"－",{"$f":"S55+S56","v":0},"－",{"$f":"U55+U56","v":0},"－"]
["■必要資金及び資金調達（新事業）"]
["必要資金","運転資金","       通常運転資金",null,null,null,{"$f":"ROUND((G42+G44)/12,-2)","v":0},null,{"$f":"ROUND((I42+I44)/12,-2)","v":0},null,{"$f":"ROUND((K42+K44)/12,-2)","v":0},null,{"$f":"ROUND((M42+M44)/12,-2)","v":0},null,{"$f":"ROUND((O42+O44)/12,-2)","v":0},null,{"$f":"ROUND((Q42+Q44)/12,-2)","v":0},null,{"$f":"ROUND((S42+S44)/12,-2)","v":0},null,{"$f":"ROUND((U42+U44)/12,-2)","v":0}]
[null,null,"       増加運転資金"]
[null,null,"計",null,null,null,{"$f":"G59+G60","v":0},null,{"$f":"I59+I60","v":0},null,{"$f":"K59+K60","v":0},null,{"$f":"M59+M60","v":0},null,{"$f":"O59+O60","v":0},null,{"$f":"Q59+Q60","v":0},null,{"$f":"S59+S60","v":0},null,{"$f":"U59+U60","v":0}]
[null,"設備投資額（税込み）"]
[null,"計　",null,null,null,null,{"$f":"G61+G62","v":0},{"$f":"H59+H62","v":0},{"$f":"I61+I62","v":0},{"$f":"J59+J62","v":0},{"$f":"K61+K62","v":0},{"$f":"L59+L62","v":0},{"$f":"M61+M62","v":0},{"$f":"N59+N62","v":0},{"$f":"O61+O62","v":0},{"$f":"P59+P62","v":0},{"$f":"Q61+Q62","v":0},{"$f":"R59+R62","v":0},{"$f":"S61+S62","v":0},{"$f":"T59+T62","v":0},{"$f":"U61+U62","v":0},{"$f":"V59+V62","v":0}]
["資金調達額","政府系金融機関"]
[null,"民間金融機関"]
[null,"自己資金"]
[null,"その他"]
[null,"計　",null,null,null,null,{"$f":"SUM(G64:H67)","v":0},{"$f":"H65+H67","v":0},{"$f":"SUM(I64:J67)","v":0},{"$f":"J65+J67","v":0},{"$f":"SUM(K64:L67)","v":0},{"$f":"L65+L67","v":0},{"$f":"SUM(M64:N67)","v":0},{"$f":"N65+N67","v":0},{"$f":"SUM(O64:P67)","v":0},{"$f":"P65+P67","v":0},{"$f":"SUM(Q64:R67)","v":0},{"$f":"R65+R67","v":0},{"$f":"SUM(S64:T67)","v":0},{"$f":"T65+T67","v":0},{"$f":"SUM(U64:V67)","v":0},{"$f":"V65+V67","v":0}]
[null,null,null,null,null,null,{"$f":"IF(G63=G68,\" \",\"エラー\")","v":" "}," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
["■人員配分（新事業）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（単位：人）"]
["売上原価の労務給与等\n対象人数（換算値）　 "]
["販管費の給与等\n対象人数（換算値）　 "]
["計",null,null,null,null,null,{"$f":"SUM(G71:G72)","v":0},{"$f":"SUM(H71:H72)","v":0},{"$f":"SUM(I71:I72)","v":0},{"$f":"SUM(J71:J72)","v":0},{"$f":"SUM(K71:K72)","v":0},null,{"$f":"SUM(M71:M72)","v":0},0,0,0,0,0,0,0,0,0]

{"sheet":"計画全体（自動出力）","index":3,"n_rows":44,"n_cols":14,"rows_kept":44,"cut":false,"hidden":false,"merged":[[37,1,37,3],[38,1,38,2],[40,1,40,2],[42,1,42,2],[21,1,23,1],[24,1,27,1],[30,1,30,3],[31,1,31,2],[32,1,32,2],[33,1,33,2],[20,1,20,3],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,3],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[19,1,19,2],[6,1,6,2],[0,12,0,13],[1,1,1,6],[2,1,3,2],[4,1,4,2],[5,1,5,2]]}
[]
[null,"【会社全体の売上計画（既存事業＋新事業）自動出力】",null,null,null,null,null,null,null,null,null,null,null,"(単位：千円）"]
[null,null,null,"２年前","１年前","直近期末","１年後","２年後","３年後","４年後","５年後","６年後","７年後","８年後"]
[null,null,null,{"$f":"計画数値データ入力!C5","v":"( 年 月期)"},{"$f":"計画数値データ入力!D5","v":"( 年 月期)"},{"$f":"計画数値データ入力!E5","v":"( 年 月期)"},{"$f":"計画数値データ入力!G5","v":"( 年 月期)"},{"$f":"計画数値データ入力!I5","v":"( 年 月期)"},{"$f":"計画数値データ入力!K5","v":"( 年 月期)"},{"$f":"計画数値データ入力!M5","v":"( 年 月期)"},{"$f":"計画数値データ入力!O5","v":"( 年 月期)"},{"$f":"計画数値データ入力!Q5","v":"( 年 月期)"},{"$f":"計画数値データ入力!S5","v":"( 年 月期)"},{"$f":"計画数値データ入力!U5","v":"( 年 月期)"}]
[null,"売上高",null,{"$f":"計画数値データ入力!C6","v":0},{"$f":"計画数値データ入力!D6","v":0},{"$f":"計画数値データ入力!E6","v":0},{"$f":"計画数値データ入力!G6+計画数値データ入力!G41","v":0},{"$f":"計画数値データ入力!I6+計画数値データ入力!I41","v":0},{"$f":"計画数値データ入力!K6+計画数値データ入力!K41","v":0},{"$f":"計画数値データ入力!M6+計画数値データ入力!M41","v":0},{"$f":"計画数値データ入力!O6+計画数値データ入力!O41","v":0},{"$f":"計画数値データ入力!Q6+計画数値データ入力!Q41","v":0},{"$f":"計画数値データ入力!S6+計画数値データ入力!S41","v":0},{"$f":"計画数値データ入力!U6+計画数値データ入力!U41","v":0}]
[null,"売上原価",null,{"$f":"計画数値データ入力!C7","v":0},{"$f":"計画数値データ入力!D7","v":0},{"$f":"計画数値データ入力!E7","v":0},{"$f":"計画数値データ入力!G7+計画数値データ入力!G42","v":0},{"$f":"計画数値データ入力!I7+計画数値データ入力!I42","v":0},{"$f":"計画数値データ入力!K7+計画数値データ入力!K42","v":0},{"$f":"計画数値データ入力!M7+計画数値データ入力!M42","v":0},{"$f":"計画数値データ入力!O7+計画数値データ入力!O42","v":0},{"$f":"計画数値データ入力!Q7+計画数値データ入力!Q42","v":0},{"$f":"計画数値データ入力!S7+計画数値データ入力!S42","v":0},{"$f":"計画数値データ入力!U7+計画数値データ入力!U42","v":0}]
[null,"売上総利益",null,{"$f":"D5-D6","v":0},{"$f":"E5-E6","v":0},0,0,0,0,0,0,0,0,0]
[null,"販売費及び一般管理費",null,{"$f":"計画数値データ入力!C9","v":0},{"$f":"計画数値データ入力!D9","v":0},{"$f":"計画数値データ入力!E9","v":0},{"$f":"計画数値データ入力!G9+計画数値データ入力!G44","v":0},{"$f":"計画数値データ入力!I9+計画数値データ入力!I44","v":0},{"$f":"計画数値データ入力!K9+計画数値データ入力!K44","v":0},{"$f":"計画数値データ入力!M9+計画数値データ入力!M44","v":0},{"$f":"計画数値データ入力!O9+計画数値データ入力!O44","v":0},{"$f":"計画数値データ入力!Q9+計画数値データ入力!Q44","v":0},{"$f":"計画数値データ入力!S9+計画数値データ入力!S44","v":0},{"$f":"計画数値データ入力!U9+計画数値データ入力!U44","v":0}]
[null,"営業利益",null,{"$f":"D7-D8","v":0},{"$f":"E7-E8","v":0},0,0,0,0,0,0,0,0,0]
[null,"営業外収益",null,{"$f":"計画数値データ入力!C11","v":0},{"$f":"計画数値データ入力!D11","v":0},{"$f":"計画数値データ入力!E11","v":0},{"$f":"計画数値データ入力!G11+計画数値データ入力!G46","v":0},{"$f":"計画数値データ入力!I11+計画数値データ入力!I46","v":0},{"$f":"計画数値データ入力!K11+計画数値データ入力!K46","v":0},{"$f":"計画数値データ入力!M11+計画数値データ入力!M46","v":0},{"$f":"計画数値データ入力!O11+計画数値データ入力!O46","v":0},{"$f":"計画数値データ入力!Q11+計画数値データ入力!Q46","v":0},{"$f":"計画数値データ入力!S11+計画数値データ入力!S46","v":0},{"$f":"計画数値データ入力!U11+計画数値データ入力!U46","v":0}]
[null,"営業外費用",null,{"$f":"計画数値データ入力!C12","v":0},{"$f":"計画数値データ入力!D12","v":0},{"$f":"計画数値データ入力!E12","v":0},{"$f":"計画数値データ入力!G12+計画数値データ入力!G47","v":0},{"$f":"計画数値データ入力!I12+計画数値データ入力!I47","v":0},{"$f":"計画数値データ入力!K12+計画数値データ入力!K47","v":0},{"$f":"計画数値データ入力!M12+計画数値データ入力!M47","v":0},{"$f":"計画数値データ入力!O12+計画数値データ入力!O47","v":0},{"$f":"計画数値データ入力!Q12+計画数値データ入力!Q47","v":0},{"$f":"計画数値データ入力!S12+計画数値データ入力!S47","v":0},{"$f":"計画数値データ入力!U12+計画数値データ入力!U47","v":0}]
[null,"経常利益",null,{"$f":"D9+D10-D11","v":0},{"$f":"E9+E10-E11","v":0},0,0,0,0,0,0,0,0,0]
[null,"■給与支給総額及び人件費"]
[null,"給与支給総額（指標)",null,{"$f":"計画数値データ入力!C15+計画数値データ入力!C16","v":0},{"$f":"計画数値データ入力!D15+計画数値データ入力!D16","v":0},{"$f":"計画数値データ入力!E15+計画数値データ入力!E16","v":0},{"$f":"計画数値データ入力!G15+計画数値データ入力!G16+計画数値データ入力!G50+計画数値データ入力!G51","v":0},{"$f":"計画数値データ入力!I15+計画数値データ入力!I16+計画数値データ入力!I50+計画数値データ入力!I51","v":0},{"$f":"計画数値データ入力!K15+計画数値データ入力!K16+計画数値データ入力!K50+計画数値データ入力!K51","v":0},{"$f":"計画数値データ入力!M15+計画数値データ入力!M16+計画数値データ入力!M50+計画数値データ入力!M51","v":0},{"$f":"計画数値データ入力!O15+計画数値データ入力!O16+計画数値データ入力!O50+計画数値データ入力!O51","v":0},{"$f":"計画数値データ入力!Q15+計画数値データ入力!Q16+計画数値データ入力!Q50+計画数値データ入力!Q51","v":0},{"$f":"計画数値データ入力!S15+計画数値データ入力!S16+計画数値データ入力!S50+計画数値データ入力!S51","v":0},{"$f":"計画数値データ入力!U15+計画数値データ入力!U16+計画数値データ入力!U50+計画数値データ入力!U51","v":0}]
[null,"福利厚生・法定福利費・退職金等",null,{"$f":"計画数値データ入力!C17","v":0},{"$f":"計画数値データ入力!D17","v":0},{"$f":"計画数値データ入力!E17","v":0},{"$f":"計画数値データ入力!G17+計画数値データ入力!G52","v":0},{"$f":"計画数値データ入力!I17+計画数値データ入力!I52","v":0},{"$f":"計画数値データ入力!K17+計画数値データ入力!K52","v":0},{"$f":"計画数値データ入力!M17+計画数値データ入力!M52","v":0},{"$f":"計画数値データ入力!O17+計画数値データ入力!O52","v":0},{"$f":"計画数値データ入力!Q17+計画数値データ入力!Q52","v":0},{"$f":"計画数値データ入力!S17+計画数値データ入力!S52","v":0},{"$f":"計画数値データ入力!U17+計画数値データ入力!U52","v":0}]
[null,"人件費",null,{"$f":"D14+D15","v":0},{"$f":"E14+E15","v":0},0,0,0,0,0,0,0,0,0]
[null,"■減価償却費"]
[null,null,"普通償却額\n※賃借料・リース料を含む",{"$f":"計画数値データ入力!C20","v":0},{"$f":"計画数値データ入力!D20","v":0},{"$f":"計画数値データ入力!E20","v":0},{"$f":"計画数値データ入力!G20+計画数値データ入力!G55","v":0},{"$f":"計画数値データ入力!I20+計画数値データ入力!I55","v":0},{"$f":"計画数値データ入力!K20+計画数値データ入力!K55","v":0},{"$f":"計画数値データ入力!M20+計画数値データ入力!M55","v":0},{"$f":"計画数値データ入力!O20+計画数値データ入力!O55","v":0},{"$f":"計画数値データ入力!Q20+計画数値データ入力!Q55","v":0},{"$f":"計画数値データ入力!S20+計画数値データ入力!S55","v":0},{"$f":"計画数値データ入力!U20+計画数値データ入力!U55","v":0}]
[null,null,"特別償却額",{"$f":"計画数値データ入力!C21","v":0},{"$f":"計画数値データ入力!D21","v":0},{"$f":"計画数値データ入力!E21","v":0},{"$f":"計画数値データ入力!G21+計画数値データ入力!G56","v":0},{"$f":"計画数値データ入力!I21+計画数値データ入力!I56","v":0},{"$f":"計画数値データ入力!K21+計画数値データ入力!K56","v":0},{"$f":"計画数値データ入力!M21+計画数値データ入力!M56","v":0},{"$f":"計画数値データ入力!O21+計画数値データ入力!O56","v":0},{"$f":"計画数値データ入力!Q21+計画数値データ入力!Q56","v":0},{"$f":"計画数値データ入力!S21+計画数値データ入力!S56","v":0},{"$f":"計画数値データ入力!U21+計画数値データ入力!U56","v":0}]
[null,"減価償却額",null,{"$f":"D18+D19","v":0},{"$f":"E18+E19","v":0},0,0,0,0,0,0,0,0,0]
[null,"■必要資金及び資金調達"]
[null,"必要資金","運転資金",{"$f":"計画数値データ入力!C24","v":0},{"$f":"計画数値データ入力!D24","v":0},{"$f":"計画数値データ入力!E24","v":0},{"$f":"計画数値データ入力!G24+計画数値データ入力!G61","v":0},{"$f":"計画数値データ入力!I24+計画数値データ入力!I61","v":0},{"$f":"計画数値データ入力!K24+計画数値データ入力!K61","v":0},{"$f":"計画数値データ入力!M24+計画数値データ入力!M61","v":0},{"$f":"計画数値データ入力!O24+計画数値データ入力!O61","v":0},{"$f":"計画数値データ入力!Q24+計画数値データ入力!Q61","v":0},{"$f":"計画数値データ入力!S24+計画数値データ入力!S61","v":0},{"$f":"計画数値データ入力!U24+計画数値データ入力!U61","v":0}]
[null,null,"設備投資額",{"$f":"計画数値データ入力!C25","v":0},{"$f":"計画数値データ入力!D25","v":0},{"$f":"計画数値データ入力!E25","v":0},{"$f":"計画数値データ入力!G25+計画数値データ入力!G62","v":0},{"$f":"計画数値データ入力!I25+計画数値データ入力!I62","v":0},{"$f":"計画数値データ入力!K25+計画数値データ入力!K62","v":0},{"$f":"計画数値データ入力!M25+計画数値データ入力!M62","v":0},{"$f":"計画数値データ入力!O25+計画数値データ入力!O62","v":0},{"$f":"計画数値データ入力!Q25+計画数値データ入力!Q62","v":0},{"$f":"計画数値データ入力!S25+計画数値データ入力!S62","v":0},{"$f":"計画数値データ入力!U25+計画数値データ入力!U62","v":0}]
[null,null,"計",{"$f":"D22+D23","v":0},{"$f":"E22+E23","v":0},0,0,0,0,0,0,0,0,0]
[null,"資金調達額","政府系金融機関",null,null,null,{"$f":"計画数値データ入力!G27+計画数値データ入力!G64","v":0},{"$f":"計画数値データ入力!I27+計画数値データ入力!I64","v":0},{"$f":"計画数値データ入力!K27+計画数値データ入力!K64","v":0},{"$f":"計画数値データ入力!M27+計画数値データ入力!M64","v":0},{"$f":"計画数値データ入力!O27+計画数値データ入力!O64","v":0},{"$f":"計画数値データ入力!Q27+計画数値データ入力!Q64","v":0},{"$f":"計画数値データ入力!S27+計画数値データ入力!S64","v":0},{"$f":"計画数値データ入力!U27+計画数値データ入力!U64","v":0}]
[null,null,"民間金融機関",null,null,null,{"$f":"計画数値データ入力!G28+計画数値データ入力!G65","v":0},{"$f":"計画数値データ入力!I28+計画数値データ入力!I65","v":0},{"$f":"計画数値データ入力!K28+計画数値データ入力!K65","v":0},{"$f":"計画数値データ入力!M28+計画数値データ入力!M65","v":0},{"$f":"計画数値データ入力!O28+計画数値データ入力!O65","v":0},{"$f":"計画数値データ入力!Q28+計画数値データ入力!Q65","v":0},{"$f":"計画数値データ入力!S28+計画数値データ入力!S65","v":0},{"$f":"計画数値データ入力!U28+計画数値データ入力!U65","v":0}]
[null,null,"自己資金",null,null,null,{"$f":"計画数値データ入力!G29+計画数値データ入力!G66","v":0},{"$f":"計画数値データ入力!I29+計画数値データ入力!I66","v":0},{"$f":"計画数値データ入力!K29+計画数値データ入力!K66","v":0},{"$f":"計画数値データ入力!M29+計画数値データ入力!M66","v":0},{"$f":"計画数値データ入力!O29+計画数値データ入力!O66","v":0},{"$f":"計画数値データ入力!Q29+計画数値データ入力!Q66","v":0},{"$f":"計画数値データ入力!S29+計画数値データ入力!S66","v":0},{"$f":"計画数値データ入力!U29+計画数値データ入力!U66","v":0}]
[null,null,"その他",null,null,null,{"$f":"計画数値データ入力!G30+計画数値データ入力!G67","v":0},{"$f":"計画数値データ入力!I30+計画数値データ入力!I67","v":0},{"$f":"計画数値データ入力!K30+計画数値データ入力!K67","v":0},{"$f":"計画数値データ入力!M30+計画数値データ入力!M67","v":0},{"$f":"計画数値データ入力!O30+計画数値データ入力!O67","v":0},{"$f":"計画数値データ入力!Q30+計画数値データ入力!Q67","v":0},{"$f":"計画数値データ入力!S30+計画数値データ入力!S67","v":0},{"$f":"計画数値データ入力!U30+計画数値データ入力!U67","v":0}]
[null,null,"計",null,null,null,{"$f":"SUM(G25:G28)","v":0},{"$f":"SUM(H25:H28)","v":0},0,0,0,0,0,0]
[null,null,null,null,null,null,{"$f":"IF(G24=G29,\" \",\"エラー\")","v":" "},{"$f":"IF(H24=H29,\" \",\"エラー\")","v":" "}," "," "," "," "," "," "]
[null,"■人員配分（換算値）",null,null,null,null,null,null,null,null,null,null,null,"（単位：人）"]
[null,"既存事業",null,{"$f":"計画数値データ入力!C36","v":0},{"$f":"計画数値データ入力!D36","v":0},{"$f":"計画数値データ入力!E36","v":0},{"$f":"計画数値データ入力!G36","v":0},{"$f":"計画数値データ入力!I36","v":0},{"$f":"計画数値データ入力!K36","v":0},{"$f":"計画数値データ入力!M36","v":0},{"$f":"計画数値データ入力!O36","v":0},{"$f":"計画数値データ入力!Q36","v":0},{"$f":"計画数値データ入力!S36","v":0},{"$f":"計画数値データ入力!U36","v":0}]
[null,"新規事業",null,null,null,null,{"$f":"計画数値データ入力!G73","v":0},{"$f":"計画数値データ入力!I73","v":0},{"$f":"計画数値データ入力!K73","v":0},{"$f":"計画数値データ入力!M73","v":0},{"$f":"計画数値データ入力!O73","v":0},{"$f":"計画数値データ入力!Q73","v":0},{"$f":"計画数値データ入力!S73","v":0},{"$f":"計画数値データ入力!U73","v":0}]
[null,"計",null,{"$f":"D32+D33","v":0},{"$f":"E32+E33","v":0},0,0,0,0,0,0,0,0,0]
[null,null,"科目別内訳（換算値）"]
[null,null,"労務費対象人数",{"$f":"計画数値データ入力!C34","v":0},{"$f":"計画数値データ入力!D34","v":0},{"$f":"計画数値データ入力!E34","v":0},{"$f":"計画数値データ入力!G34+計画数値データ入力!G71","v":0},{"$f":"計画数値データ入力!I34+計画数値データ入力!I71","v":0},{"$f":"計画数値データ入力!K34+計画数値データ入力!K71","v":0},{"$f":"計画数値データ入力!M34+計画数値データ入力!M71","v":0},{"$f":"計画数値データ入力!O34+計画数値データ入力!O71","v":0},{"$f":"計画数値データ入力!Q34+計画数値データ入力!Q71","v":0},{"$f":"計画数値データ入力!S34+計画数値データ入力!S71","v":0},{"$f":"計画数値データ入力!U34+計画数値データ入力!U71","v":0}]
[null,null,"給与等対象人数",{"$f":"計画数値データ入力!C35","v":0},{"$f":"計画数値データ入力!D35","v":0},{"$f":"計画数値データ入力!E35","v":0},{"$f":"計画数値データ入力!G35+計画数値データ入力!G72","v":0},{"$f":"計画数値データ入力!I35+計画数値データ入力!I72","v":0},{"$f":"計画数値データ入力!K35+計画数値データ入力!K72","v":0},{"$f":"計画数値データ入力!M35+計画数値データ入力!M72","v":0},{"$f":"計画数値データ入力!O35+計画数値データ入力!O72","v":0},{"$f":"計画数値データ入力!Q35+計画数値データ入力!Q72","v":0},{"$f":"計画数値データ入力!S35+計画数値データ入力!S72","v":0},{"$f":"計画数値データ入力!U35+計画数値データ入力!U72","v":0}]
[null,"■指標"]
[null,"付加価値額",null,{"$f":"D9+D16+D20","v":0},{"$f":"E9+E16+E20","v":0},{"$f":"F9+F16+F20","v":0},{"$f":"G9+G16+G20","v":0},{"$f":"H9+H16+H20","v":0},0,0,0,0,0,0]
[null,null,"伸び率",null,null,null,null,null,{"$f":"IF(I39=0,\" \",ROUND(((I39-$F$39)/ABS($F$39)),3))","v":" "}," "," "," "," "," "]
[null,"一人当たり付加価値額",null,{"$f":"IF(D34=0,,ROUND((D39/D34),0))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"伸び率",null,null,null,null,null,{"$f":"IF(I41=0,\" \",ROUND(((I41-$F$41)/ABS($F$41)),3))","v":" "}," "," "," "," "," "]
[null,"給与支給総額",null,{"$f":"D14","v":0},{"$f":"E14","v":0},0,0,0,0,0,0,0,0,0]
[null,null,"伸び率",null,null,null,null,null,{"$f":"IF(I43=0,\" \",ROUND(((I43-$F$43)/ABS($F$43)),3))","v":" "}," "," "," "," "," "]

{"sheet":"申請書＜別表３＞（自動出力）","index":4,"n_rows":27,"n_cols":14,"rows_kept":27,"cut":false,"hidden":false,"merged":[[27,1,27,4],[29,2,29,6],[30,2,30,6],[31,2,31,8],[33,1,33,5],[18,0,18,2],[19,0,19,2],[20,0,20,2],[21,0,25,0],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[17,0,17,2],[2,2,2,3],[5,0,5,2],[6,0,6,2],[7,0,7,2],[8,0,8,2],[9,0,9,2],[10,0,10,2],[11,0,11,2],[12,0,12,2],[13,0,13,2],[14,0,14,2]]}
[null,null,"（別表３）"]
[null,null,"経営計画及び資金計画"]
[null,null,"参加特定事業者名　　　　　　　　",null,{"$f":"過去３期データ入力!E2","v":0},null,null,null,null,null,null,null,null,"（単位   千円）"]
[null,null,null,"２年前","１年前","直近期末","１年後","２年後","３年後","４年後","５年後","６年後","７年後","８年後"]
[null,null,null,{"$f":"'計画全体（自動出力）'!D4","v":"( 年 月期)"},{"$f":"'計画全体（自動出力）'!E4","v":"( 年 月期)"},{"$f":"'計画全体（自動出力）'!F4","v":"( 年 月期)"},{"$f":"'計画全体（自動出力）'!G4","v":"( 年 月期)"},{"$f":"'計画全体（自動出力）'!H4","v":"( 年 月期)"},{"$f":"'計画全体（自動出力）'!I4","v":"( 年 月期)"},{"$f":"'計画全体（自動出力）'!J4","v":"( 年 月期)"},{"$f":"'計画全体（自動出力）'!K4","v":"( 年 月期)"},{"$f":"'計画全体（自動出力）'!L4","v":"( 年 月期)"},{"$f":"'計画全体（自動出力）'!M4","v":"( 年 月期)"},{"$f":"'計画全体（自動出力）'!N4","v":"( 年 月期)"}]
["①売上高",null,null,{"$f":"'計画全体（自動出力）'!D5","v":0},{"$f":"'計画全体（自動出力）'!E5","v":0},{"$f":"'計画全体（自動出力）'!F5","v":0},{"$f":"'計画全体（自動出力）'!G5","v":0},{"$f":"'計画全体（自動出力）'!H5","v":0},{"$f":"'計画全体（自動出力）'!I5","v":0},{"$f":"'計画全体（自動出力）'!J5","v":0},{"$f":"'計画全体（自動出力）'!K5","v":0},{"$f":"'計画全体（自動出力）'!L5","v":0},{"$f":"'計画全体（自動出力）'!M5","v":0},{"$f":"'計画全体（自動出力）'!N5","v":0}]
["②売上原価",null,null,{"$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}]
["③売上総利益\n　(①－②）",null,null,{"$f":"D6-D7","v":0},0,0,0,0,0,0,0,0,0,0]
["④販売費及び\n　一般管理費",null,null,{"$f":"'計画全体（自動出力）'!D8","v":0},{"$f":"'計画全体（自動出力）'!E8","v":0},{"$f":"'計画全体（自動出力）'!F8","v":0},{"$f":"'計画全体（自動出力）'!G8","v":0},{"$f":"'計画全体（自動出力）'!H8","v":0},{"$f":"'計画全体（自動出力）'!I8","v":0},{"$f":"'計画全体（自動出力）'!J8","v":0},{"$f":"'計画全体（自動出力）'!K8","v":0},{"$f":"'計画全体（自動出力）'!L8","v":0},{"$f":"'計画全体（自動出力）'!M8","v":0},{"$f":"'計画全体（自動出力）'!N8","v":0}]
["⑤営業利益",null,null,{"$f":"'計画全体（自動出力）'!D9","v":0},{"$f":"'計画全体（自動出力）'!E9","v":0},{"$f":"'計画全体（自動出力）'!F9","v":0},{"$f":"'計画全体（自動出力）'!G9","v":0},{"$f":"'計画全体（自動出力）'!H9","v":0},{"$f":"'計画全体（自動出力）'!I9","v":0},{"$f":"'計画全体（自動出力）'!J9","v":0},{"$f":"'計画全体（自動出力）'!K9","v":0},{"$f":"'計画全体（自動出力）'!L9","v":0},{"$f":"'計画全体（自動出力）'!M9","v":0},{"$f":"'計画全体（自動出力）'!N9","v":0}]
["⑥経常利益",null,null,{"$f":"'計画全体（自動出力）'!D12","v":0},{"$f":"'計画全体（自動出力）'!E12","v":0},{"$f":"'計画全体（自動出力）'!F12","v":0},{"$f":"'計画全体（自動出力）'!G12","v":0},{"$f":"'計画全体（自動出力）'!H12","v":0},{"$f":"'計画全体（自動出力）'!I12","v":0},{"$f":"'計画全体（自動出力）'!J12","v":0},{"$f":"'計画全体（自動出力）'!K12","v":0},{"$f":"'計画全体（自動出力）'!L12","v":0},{"$f":"'計画全体（自動出力）'!M12","v":0},{"$f":"'計画全体（自動出力）'!N12","v":0}]
["⑦給与支給総額",null,null,{"$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}]
["⑧人件費",null,null,{"$f":"'計画全体（自動出力）'!D16","v":0},{"$f":"'計画全体（自動出力）'!E16","v":0},{"$f":"'計画全体（自動出力）'!F16","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}]
["⑨設備投資額",null,null,{"$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}]
["⑩運転資金",null,null,{"$f":"'計画全体（自動出力）'!D22","v":0},{"$f":"'計画全体（自動出力）'!E22","v":0},{"$f":"'計画全体（自動出力）'!F22","v":0},{"$f":"'計画全体（自動出力）'!G22","v":0},{"$f":"'計画全体（自動出力）'!H22","v":0},{"$f":"'計画全体（自動出力）'!I22","v":0},{"$f":"'計画全体（自動出力）'!J22","v":0},{"$f":"'計画全体（自動出力）'!K22","v":0},{"$f":"'計画全体（自動出力）'!L22","v":0},{"$f":"'計画全体（自動出力）'!M22","v":0},{"$f":"'計画全体（自動出力）'!N22","v":0}]
[null,"普通償却額",null,{"$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}]
[null,"特別償却額",null,{"$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}]
["⑪減価償却費",null,null,{"$f":"D16+D17","v":0},{"$f":"E16+E17","v":0},0,0,0,0,0,0,0,0,0]
["⑫付加価値額　　　　　（⑤＋⑧＋⑪）",null,null,{"$f":"D10+D13+D18","v":0},0,0,0,0,0,0,0,0,0,0]
["⑬従業員数",null,null,{"$f":"'計画全体（自動出力）'!D34","v":0},{"$f":"'計画全体（自動出力）'!E34","v":0},{"$f":"'計画全体（自動出力）'!F34","v":0},{"$f":"'計画全体（自動出力）'!G34","v":0},{"$f":"'計画全体（自動出力）'!H34","v":0},{"$f":"'計画全体（自動出力）'!I34","v":0},{"$f":"'計画全体（自動出力）'!J34","v":0},{"$f":"'計画全体（自動出力）'!K34","v":0},{"$f":"'計画全体（自動出力）'!L34","v":0},{"$f":"'計画全体（自動出力）'!M34","v":0},{"$f":"'計画全体（自動出力）'!N34","v":0}]
["⑭一人当たりの付加価値額（⑫÷⑬）",null,null,{"$f":"IF(D20>0,ROUND(D19/D20,0),0)","v":0},0,0,0,0,0,0,0,0,0,0]
["⑮資金調達額(⑨＋⑩）","政府系金融\n機関借入",null,"－","－","－",{"$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}]
[null,"民間金融機\n関借入",null,"－","－","－",{"$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}]
[null,"自己資金",null,"－","－","－",{"$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}]
[null,"その他",null,"－","－","－",{"$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}]
[null,"　合　計",null,"－","－","－",{"$f":"SUM(G22:G25)","v":0},{"$f":"SUM(H22:H25)","v":0},0,0,0,0,0,0]
[null,null,null,null,null,null,{"$f":"IF(G26=G14+G15,\" \",\"check!　⑨,⑩,⑮\")","v":" "}," "," "," "," "," "," "," "]

{"sheet":"数値目標確認（自動出力）","index":5,"n_rows":90,"n_cols":6,"rows_kept":90,"cut":false,"hidden":false,"merged":[[89,1,89,2],[68,1,68,2],[72,1,72,2],[73,1,73,2],[74,1,74,2],[76,1,76,2],[77,1,78,2],[79,1,79,2],[82,1,82,2],[83,1,83,2],[87,1,87,2],[88,1,88,2],[67,1,67,2],[46,1,46,2],[47,1,48,2],[49,1,49,2],[52,1,52,2],[53,1,53,2],[57,1,57,2],[58,1,58,2],[59,1,59,2],[61,1,61,2],[62,1,63,2],[64,1,64,2],[44,1,44,2],[23,1,23,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[31,1,31,2],[32,1,33,2],[34,1,34,2],[37,1,37,2],[38,1,38,2],[42,1,42,2],[43,1,43,2],[22,1,22,2],[1,1,1,2],[2,1,3,2],[4,1,4,2],[7,1,7,2],[8,1,8,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[16,1,16,2],[17,1,18,2],[19,1,19,2]]}
[]
[null,"３年計画"]
[null,null,null,"直近期末","目標最終期","伸び率"]
[null,null,null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$5","v":"( 年 月期)"},{"$f":"'申請書＜別表３＞（自動出力）'!$I$5","v":"( 年 月期)"},"（％）"]
[null,"売上高",null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$6","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$I$6","v":0},{"$f":"IF(OR(E5=0,D5=0),\"－\",IF(E5/D5>0,E5/D5*100-100,(E5-D5)/ABS(D5)*100))","v":"－"}]
[null,null,"売上原価",{"$f":"'申請書＜別表３＞（自動出力）'!$F$7","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$I$7","v":0},{"$f":"IF(OR(E6=0,D6=0),\"－\",IF(E6/D6>0,E6/D6*100-100,(E6-D6)/ABS(D6)*100))","v":"－"}]
[null,null,"販管費",{"$f":"'申請書＜別表３＞（自動出力）'!$F$9","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$I$9","v":0},"－"]
[null,"営業利益①",null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$10","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$I$10","v":0},"－"]
[null,"経常利益",null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$11","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$I$11","v":0},"－"]
[null,null,"人件費②",{"$f":"'申請書＜別表３＞（自動出力）'!$F$13","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$I$13","v":0},"－"]
[null,null,"減価償却費③",{"$f":"'申請書＜別表３＞（自動出力）'!$F$18","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$I$18","v":0},"－"]
[null,null,"従業員数④",{"$f":"'申請書＜別表３＞（自動出力）'!$F$20","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$I$20","v":0},"－"]
[null,"付加価値額（①+②+③)",null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$19","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$I$19","v":0},"－"]
[null,"１人あたり付加価値額(①＋②＋③)/④",null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$21","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$I$21","v":0},"－"]
[null,"給与支給総額",null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$12","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$I$12","v":0},"－"]
[]
[null,"４年計画"]
[null,null,null,"直近期末","目標最終期","伸び率"]
[null,null,null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$5","v":"( 年 月期)"},{"$f":"'申請書＜別表３＞（自動出力）'!$J$5","v":"( 年 月期)"},"（％）"]
[null,"売上高",null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$6","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$J$6","v":0},{"$f":"IF(OR(E20=0,D20=0),\"－\",IF(E20/D20>0,E20/D20*100-100,(E20-D20)/ABS(D20)*100))","v":"－"}]
[null,null,"売上原価",{"$f":"'申請書＜別表３＞（自動出力）'!$F$7","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$J$7","v":0},"－"]
[null,null,"販管費",{"$f":"'申請書＜別表３＞（自動出力）'!$F$9","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$J$9","v":0},"－"]
[null,"営業利益①",null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$10","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$J$10","v":0},"－"]
[null,"経常利益",null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$11","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$J$11","v":0},"－"]
[null,null,"人件費②",{"$f":"'申請書＜別表３＞（自動出力）'!$F$13","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$J$13","v":0},"－"]
[null,null,"減価償却費③",{"$f":"'申請書＜別表３＞（自動出力）'!$F$18","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$J$18","v":0},"－"]
[null,null,"従業員数④",{"$f":"'申請書＜別表３＞（自動出力）'!$F$20","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$J$20","v":0},"－"]
[null,"付加価値額（①+②+③)",null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$19","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$J$19","v":0},"－"]
[null,"１人あたり付加価値額(①＋②＋③)/④",null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$21","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$J$21","v":0},"－"]
[null,"給与支給総額",null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$12","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$J$12","v":0},"－"]
[]
[null,"５年計画"]
[null,null,null,"直近期末","目標最終期","伸び率"]
[null,null,null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$5","v":"( 年 月期)"},{"$f":"'申請書＜別表３＞（自動出力）'!$K$5","v":"( 年 月期)"},"（％）"]
[null,"売上高",null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$6","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$K$6","v":0},{"$f":"IF(OR(E35=0,D35=0),\"－\",IF(E35/D35>0,E35/D35*100-100,(E35-D35)/ABS(D35)*100))","v":"－"}]
[null,null,"売上原価",{"$f":"'申請書＜別表３＞（自動出力）'!$F$7","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$K$7","v":0},{"$f":"IF(OR(E36=0,D36=0),\"－\",IF(E36/D36>0,E36/D36*100-100,(E36-D36)/ABS(D36)*100))","v":"－"}]
[null,null,"販管費",{"$f":"'申請書＜別表３＞（自動出力）'!$F$9","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$K$9","v":0},"－"]
[null,"営業利益①",null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$10","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$K$10","v":0},"－"]
[null,"経常利益",null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$11","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$K$11","v":0},"－"]
[null,null,"人件費②",{"$f":"'申請書＜別表３＞（自動出力）'!$F$13","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$K$13","v":0},"－"]
[null,null,"減価償却費③",{"$f":"'申請書＜別表３＞（自動出力）'!$F$18","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$K$18","v":0},"－"]
[null,null,"従業員数④",{"$f":"'申請書＜別表３＞（自動出力）'!$F$20","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$K$20","v":0},"－"]
[null,"付加価値額（①+②+③)",null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$19","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$K$19","v":0},"－"]
[null,"１人あたり付加価値額(①＋②＋③)/④",null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$21","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$K$21","v":0},"－"]
[null,"給与支給総額",null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$12","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$K$12","v":0},"－"]
[]
[null,"６年計画"]
[null,null,null,"直近期末","目標最終期","伸び率"]
[null,null,null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$5","v":"( 年 月期)"},{"$f":"'申請書＜別表３＞（自動出力）'!L5","v":"( 年 月期)"},"（％）"]
[null,"売上高",null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$6","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$L$6","v":0},{"$f":"IF(OR(E50=0,D50=0),\"－\",IF(E50/D50>0,E50/D50*100-100,(E50-D50)/ABS(D50)*100))","v":"－"}]
[null,null,"売上原価",{"$f":"'申請書＜別表３＞（自動出力）'!$F$7","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$L$7","v":0},{"$f":"IF(OR(E51=0,D51=0),\"－\",IF(E51/D51>0,E51/D51*100-100,(E51-D51)/ABS(D51)*100))","v":"－"}]
[null,null,"販管費",{"$f":"'申請書＜別表３＞（自動出力）'!$F$9","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$L$9","v":0},"－"]
[null,"営業利益①",null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$10","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$L$10","v":0},"－"]
[null,"経常利益",null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$11","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$L$11","v":0},"－"]
[null,null,"人件費②",{"$f":"'申請書＜別表３＞（自動出力）'!$F$13","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$L$13","v":0},"－"]
[null,null,"減価償却費③",{"$f":"'申請書＜別表３＞（自動出力）'!$F$18","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$L$18","v":0},"－"]
[null,null,"従業員数④",{"$f":"'申請書＜別表３＞（自動出力）'!$F$20","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$L$20","v":0},"－"]
[null,"付加価値額（①+②+③)",null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$19","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$L$19","v":0},"－"]
[null,"１人あたり付加価値額(①＋②＋③)/④",null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$21","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$L$21","v":0},"－"]
[null,"給与支給総額",null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$12","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$L$12","v":0},"－"]
[]
[null,"７年計画"]
[null,null,null,"直近期末","目標最終期","伸び率"]
[null,null,null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$5","v":"( 年 月期)"},{"$f":"'申請書＜別表３＞（自動出力）'!$M$5","v":"( 年 月期)"},"（％）"]
[null,"売上高",null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$6","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$M$6","v":0},{"$f":"IF(OR(E65=0,D65=0),\"－\",IF(E65/D65>0,E65/D65*100-100,(E65-D65)/ABS(D65)*100))","v":"－"}]
[null,null,"売上原価",{"$f":"'申請書＜別表３＞（自動出力）'!$F$7","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$M$7","v":0},{"$f":"IF(OR(E66=0,D66=0),\"－\",IF(E66/D66>0,E66/D66*100-100,(E66-D66)/ABS(D66)*100))","v":"－"}]
[null,null,"販管費",{"$f":"'申請書＜別表３＞（自動出力）'!$F$9","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$M$9","v":0},"－"]
[null,"営業利益①",null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$10","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$M$10","v":0},"－"]
[null,"経常利益",null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$11","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$M$11","v":0},"－"]
[null,null,"人件費②",{"$f":"'申請書＜別表３＞（自動出力）'!$F$13","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$M$13","v":0},"－"]
[null,null,"減価償却費③",{"$f":"'申請書＜別表３＞（自動出力）'!$F$18","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$M$18","v":0},"－"]
[null,null,"従業員数④",{"$f":"'申請書＜別表３＞（自動出力）'!$F$20","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$M$20","v":0},"－"]
[null,"付加価値額（①+②+③)",null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$19","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$M$19","v":0},"－"]
[null,"１人あたり付加価値額(①＋②＋③)/④",null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$21","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$M$21","v":0},"－"]
[null,"給与支給総額",null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$12","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$M$12","v":0},"－"]
[]
[null,"８年計画"]
[null,null,null,"直近期末","目標最終期","伸び率"]
[null,null,null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$5","v":"( 年 月期)"},{"$f":"'申請書＜別表３＞（自動出力）'!$N$5","v":"( 年 月期)"},"（％）"]
[null,"売上高",null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$6","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$N$6","v":0},{"$f":"IF(OR(E80=0,D80=0),\"－\",IF(E80/D80>0,E80/D80*100-100,(E80-D80)/ABS(D80)*100))","v":"－"}]
[null,null,"売上原価",{"$f":"'申請書＜別表３＞（自動出力）'!$F$7","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$N$7","v":0},{"$f":"IF(OR(E81=0,D81=0),\"－\",IF(E81/D81>0,E81/D81*100-100,(E81-D81)/ABS(D81)*100))","v":"－"}]
[null,null,"販管費",{"$f":"'申請書＜別表３＞（自動出力）'!$F$9","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$N$9","v":0},"－"]
[null,"営業利益①",null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$10","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$N$10","v":0},"－"]
[null,"経常利益",null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$11","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$N$11","v":0},"－"]
[null,null,"人件費②",{"$f":"'申請書＜別表３＞（自動出力）'!$F$13","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$N$13","v":0},"－"]
[null,null,"減価償却費③",{"$f":"'申請書＜別表３＞（自動出力）'!$F$18","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$N$18","v":0},"－"]
[null,null,"従業員数④",{"$f":"'申請書＜別表３＞（自動出力）'!$F$20","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$N$20","v":0},"－"]
[null,"付加価値額（①+②+③)",null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$19","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$N$19","v":0},"－"]
[null,"１人あたり付加価値額(①＋②＋③)/④",null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$21","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$N$21","v":0},"－"]
[null,"給与支給総額",null,{"$f":"'申請書＜別表３＞（自動出力）'!$F$12","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!$N$12","v":0},"－"]

{"sheet":"別表3インポート用マクロ","index":6,"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":"'申請書＜別表３＞（自動出力）'!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":"'申請書＜別表３＞（自動出力）'!D9","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!E9","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!F9","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!G9","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!H9","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!I9","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!J9","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!K9","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!L9","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!M9","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!N9","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":"'申請書＜別表３＞（自動出力）'!D11","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!E11","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!F11","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!G11","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!H11","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!I11","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!J11","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!K11","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!L11","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!M11","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!N11","v":0}]
["⑦給与支給総額",{"$f":"'申請書＜別表３＞（自動出力）'!D12","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!E12","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!F12","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!G12","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!H12","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!I12","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!J12","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!K12","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!L12","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!M12","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!N12","v":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":"'申請書＜別表３＞（自動出力）'!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":"'申請書＜別表３＞（自動出力）'!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":"IFERROR(B39+B40,0)","v":0},{"$f":"IFERROR(C39+C40,0)","v":0},0,0,0,0,0,0,0,0,0]
["普通償却額",{"$f":"'申請書＜別表３＞（自動出力）'!D16","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!E16","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!F16","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":"'申請書＜別表３＞（自動出力）'!D17","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!E17","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!F17","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(B32+B35+B38,0)","v":0},{"$f":"IFERROR(C32+C35+C38,0)","v":0},0,0,0,0,0,0,0,0,0]
["⑬従業員数（役員含む）",{"$f":"'申請書＜別表３＞（自動出力）'!D20","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!E20","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!F20","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!G20","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!H20","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!I20","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!J20","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!K20","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!L20","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!M20","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!N20","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":"'申請書＜別表３＞（自動出力）'!G22","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!H22","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!I22","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!J22","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!K22","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!L22","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!M22","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!N22","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":"'申請書＜別表３＞（自動出力）'!G24","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!H24","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!I24","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!J24","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!K24","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!L24","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!M24","v":0},{"$f":"'申請書＜別表３＞（自動出力）'!N24","v":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}]
["注意事項"]
["・表内のセルに「半角マイナス（-）」、「半角カンマ（,）」、「小数点（.）」以外の記号が含まれないよう、参照元の値を修正してください。"]
["・変換されたファイルを保存する際、保存するフォルダ内に同名ファイルがある場合は警告なく上書き保存されます。"]

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