{"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":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[[35,1,35,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[0,1,0,6],[31,1,33,1],[1,4,1,5],[4,1,5,2],[6,1,6,2],[7,1,14,1],[15,1,15,2],[16,1,16,2],[17,1,24,1],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,29,1]]}
[null,"「別表３」作成支援システム（個人事業者用）＜過去３期データ入力＞　R7.4改訂版"]
[null,null,null,"屋号等"]
[]
[null,"【過去３期決算実績】",null,null,null,"(単位：千円）"]
[null,null,null,"２年前","１年前","直近期末"]
[null,null,null,"( 年12月期)","( 年12月期)","( 年12月期)"]
[null,"売上（収入）金額"]
[null,"売上原価","労務費（給与賃金）"]
[null,null,"福利厚生費"]
[null,null,"外注工賃"]
[null,null,"減価償却費(普通)"]
[null,null,"減価償却費(特別)"]
[null,null,"賃借料(地代・家賃を除く)"]
[null,null,"リース料"]
[null,null,"上記以外　　 　 ",{"$f":"D16-(D8+D9+D10+D11+D12+D13+D14)","v":0},{"$f":"E16-(E8+E9+E10+E11+E12+E13+E14)","v":0},0]
[null,"　　　計（差引原価）"]
[null,"差引金額(売上総利益)　",null,{"$f":"D7-D16","v":0},{"$f":"E7-E16","v":0},{"$f":"F7-F16","v":0}]
[null,"経　　費","給与賃金"]
[null,null,"福利厚生費"]
[null,null,"減価償却費(普通)"]
[null,null,"減価償却費(特別)"]
[null,null,"賃借料(地代・家賃を除く)"]
[null,null,"リース料"]
[null,null,"利子割引料"]
[null,null,"上記以外　　 　 ",{"$f":"D26-(D18+D19+D20+D21+D22+D23+D24)","v":0},{"$f":"E26-(E18+E19+E20+E21+E22+E23+E24)","v":0},0]
[null,"計"]
[null,"営業利益　　　　   ",null,{"$f":"D17-D26+D24","v":0},{"$f":"E17-E26+E24","v":0},0]
[null,"差引金額(経常利益)   "]
[null,"その他","専従者給与"]
[null,null,"青色申告特別控除前の所得金額"]
[null,"■資金"]
[null,"必要資金","運転資金　　　",{"$f":"ROUND((D16+D26-D24)/12,-2)","v":0},{"$f":"ROUND((E16+E26-E24)/12,-2)","v":0},0]
[null,null,"設備投資額（税込み）"]
[null,null,"計",{"$f":"SUM(D32:D33)","v":0},{"$f":"SUM(E32:E33)","v":0},{"$f":"SUM(F32:F33)","v":0}]
[null,"■人員配分",null,null,null,"（単位：人）"]
[null,"労務費対象者数（換算値）"]
[null,"給与賃金対象者数（換算値）"]
[null,"専従者"]
[null,"個人事業主",null,1,1,1]
[null,"計（換算値）",null,{"$f":"ROUND((D36+D37+D38+D39),1)","v":1},{"$f":"ROUND((E36+E37+E38+E39),1)","v":1},{"$f":"ROUND((F36+F37+F38+F39),1)","v":1}]

{"sheet":"計画数値データ入力","index":2,"n_rows":77,"n_cols":22,"rows_kept":77,"cut":false,"hidden":false,"merged":[[76,0,76,1],[76,2,76,5],[76,6,76,7],[76,8,76,9],[76,10,76,11],[75,0,75,1],[75,2,75,5],[75,6,75,7],[75,8,75,9],[75,10,75,11],[76,12,76,13],[76,14,76,15],[76,16,76,17],[76,18,76,19],[74,20,74,21],[76,20,76,21],[75,12,75,13],[75,14,75,15],[75,16,75,17],[75,18,75,19],[75,20,75,21],[71,18,71,19],[71,20,71,21],[72,3,72,5],[73,0,73,1],[73,20,73,21],[74,0,74,1],[74,2,74,5],[74,6,74,7],[74,8,74,9],[74,10,74,11],[71,2,71,5],[71,6,71,7],[71,8,71,9],[71,10,71,11],[71,12,71,13],[71,14,71,15],[71,16,71,17],[74,12,74,13],[74,14,74,15],[74,16,74,17],[74,18,74,19],[70,2,70,5],[70,6,70,7],[70,8,70,9],[70,10,70,11],[70,12,70,13],[70,14,70,15],[69,10,69,11],[69,12,69,13],[69,14,69,15],[69,2,69,5],[69,6,69,7],[69,8,69,9],[69,16,69,17],[69,18,69,19],[69,20,69,21],[70,16,70,17],[70,18,70,19],[70,20,70,21],[66,18,66,19],[66,20,66,21],[67,0,70,0],[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],[67,18,67,19],[67,20,67,21],[68,2,68,5],[68,6,68,7],[68,8,68,9],[68,10,68,11],[68,12,68,13],[68,14,68,15],[64,14,64,15],[64,2,64,5],[64,6,64,7],[64,8,64,9],[68,16,68,17],[68,18,68,19],[68,20,68,21],[66,16,66,17],[65,16,65,17],[65,18,65,19],[65,20,65,21],[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],[63,16,63,17],[63,18,63,19],[56,0,56,1],[56,2,56,5],[57,0,57,21],[58,0,60,0],[58,2,58,5],[59,2,59,5],[60,2,60,5],[64,16,64,17],[64,18,64,19],[64,20,64,21],[61,0,61,21],[62,0,65,0],[62,1,64,1],[62,2,62,5],[62,6,62,7],[62,8,62,9],[63,20,63,21],[64,10,64,11],[64,12,64,13],[62,10,62,11],[62,12,62,13],[62,14,62,15],[62,16,62,17],[62,18,62,19],[62,20,62,21],[63,2,63,5],[63,6,63,7],[53,0,53,1],[53,2,53,5],[54,0,54,1],[54,2,54,5],[55,0,55,1],[55,2,55,5],[63,10,63,11],[63,12,63,13],[63,14,63,15],[63,8,63,9],[49,0,49,1],[49,2,49,5],[50,0,50,1],[50,2,50,5],[51,0,51,21],[52,0,52,1],[52,2,52,5],[42,6,42,7],[42,8,42,9],[42,10,42,11],[42,12,42,13],[42,14,42,15],[45,0,45,1],[45,2,45,5],[46,0,48,0],[46,2,46,5],[47,2,47,5],[48,2,48,5],[43,0,43,1],[43,2,43,5],[44,0,44,1],[44,2,44,5],[38,20,38,21],[40,20,40,21],[41,0,42,1],[41,2,42,5],[41,6,41,7],[41,8,41,9],[41,10,41,11],[42,16,42,17],[42,18,42,19],[42,20,42,21],[38,0,38,1],[38,4,38,5],[38,6,38,7],[38,8,38,9],[38,10,38,11],[38,12,38,13],[38,14,38,15],[38,16,38,17],[38,18,38,19],[41,12,41,13],[41,14,41,15],[41,16,41,17],[41,18,41,19],[41,20,41,21],[36,20,36,21],[37,0,37,1],[37,4,37,5],[37,6,37,7],[37,8,37,9],[37,10,37,11],[37,12,37,13],[37,14,37,15],[37,16,37,17],[37,18,37,19],[37,20,37,21],[36,0,36,1],[36,4,36,5],[36,6,36,7],[36,8,36,9],[36,10,36,11],[36,12,36,13],[36,14,36,15],[36,16,36,17],[36,18,36,19],[34,14,34,15],[34,16,34,17],[34,18,34,19],[34,20,34,21],[35,0,35,1],[35,4,35,5],[35,6,35,7],[35,8,35,9],[35,10,35,11],[35,12,35,13],[34,0,34,1],[34,4,34,5],[34,6,34,7],[34,8,34,9],[34,10,34,11],[34,12,34,13],[35,14,35,15],[35,16,35,17],[35,18,35,19],[35,20,35,21],[31,16,31,17],[31,18,31,19],[31,20,31,21],[32,3,32,5],[33,0,33,5],[33,20,33,21],[31,2,31,5],[31,6,31,7],[31,8,31,9],[31,10,31,11],[31,12,31,13],[31,14,31,15],[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],[30,18,30,19],[30,20,30,21],[27,20,27,21],[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],[28,18,28,19],[28,20,28,21],[27,0,30,0],[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],[29,2,29,5],[29,6,29,7],[29,8,29,9],[29,10,29,11],[29,12,29,13],[29,14,29,15],[29,16,29,17],[29,18,29,19],[26,4,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],[26,18,26,19],[26,20,26,21],[17,0,17,1],[18,0,18,1],[19,0,19,21],[20,0,22,0],[23,0,23,21],[24,0,26,0],[24,4,24,5],[24,6,24,7],[24,8,24,9],[24,10,24,11],[24,12,24,13],[24,14,24,15],[24,16,24,17],[24,18,24,19],[24,20,24,21],[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],[11,0,11,1],[12,0,12,1],[13,0,13,21],[14,0,14,1],[15,0,15,1],[16,0,16,1],[4,18,4,19],[4,20,4,21],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,10,0],[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],[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]]}
["「別表３」作成支援システム（個人事業者用）＜入力２＞"]
[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":"( 年12月期)"},{"$f":"過去３期データ入力!E6","v":"( 年12月期)"},{"$f":"過去３期データ入力!F6","v":"( 年12月期)"},null,"( 年12月期)",null,"( 年12月期)",null,"( 年12月期)",null,"( 年12月期)",null,"( 年12月期)",null,"( 年12月期)",null,"( 年12月期)",null,"( 年12月期)"]
["売上（収入）金額",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":"過去３期データ入力!D16","v":0},{"$f":"過去３期データ入力!E16","v":0},{"$f":"過去３期データ入力!F16","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":"過去３期データ入力!D17","v":0},{"$f":"過去３期データ入力!E17","v":0},{"$f":"過去３期データ入力!F17","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},"－"]
[" 経 費","経費（利子割引料を除く）",{"$f":"過去３期データ入力!D26-過去３期データ入力!D24","v":0},{"$f":"過去３期データ入力!E26-過去３期データ入力!E24","v":0},{"$f":"過去３期データ入力!F26-過去３期データ入力!F24","v":0},"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－"]
[null,"利子割引料",{"$f":"過去３期データ入力!D24","v":0},{"$f":"過去３期データ入力!E24","v":0},{"$f":"過去３期データ入力!F24","v":0},"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－"]
[null,"計",{"$f":"C9+C10","v":0},0,0,"－",{"$f":"G9+G10","v":0},"－",{"$f":"I9+I10","v":0},"－",{"$f":"K9+K10","v":0},"－",{"$f":"M9+M10","v":0},"－",{"$f":"O9+O10","v":0},"－",{"$f":"Q9+Q10","v":0},"－",{"$f":"S9+S10","v":0},"－",{"$f":"U9+U10","v":0},"－"]
["営業利益",null,{"$f":"C8-C9","v":0},0,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":"C8-C11","v":0},0,0,"－",{"$f":"G8-G11","v":0},"－",{"$f":"I8-I11","v":0},"－",{"$f":"K8-K11","v":0},"－",{"$f":"M8-M11","v":0},"－",{"$f":"O8-O11","v":0},"－",{"$f":"Q8-Q11","v":0},"－",{"$f":"S8-S11","v":0},"－",{"$f":"U8-U11","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":"過去３期データ入力!D18","v":0},{"$f":"過去３期データ入力!E18","v":0},{"$f":"過去３期データ入力!F18","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+過去３期データ入力!D19","v":0},{"$f":"過去３期データ入力!E9+過去３期データ入力!E19","v":0},{"$f":"過去３期データ入力!F9+過去３期データ入力!F19","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":"過去３期データ入力!D29","v":0},{"$f":"過去３期データ入力!E29","v":0},{"$f":"過去３期データ入力!F29","v":0},{"$f":"IF(E$6=0,\"－\",IF(E18<=0,\"－\",E18/E$6*100))","v":"－"},null,{"$f":"IF(G$6=0,\"－\",IF(G18<=0,\"－\",G18/G$6*100))","v":"－"},null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－"]
["青色申告特別控除前の所得金額",null,{"$f":"過去３期データ入力!D30","v":0},{"$f":"過去３期データ入力!E30","v":0},{"$f":"過去３期データ入力!F30","v":0},{"$f":"IF(E$6=0,\"－\",IF(E19<=0,\"－\",E19/E$6*100))","v":"－"},{"$f":"G13-G18","v":0},{"$f":"IF(G$6=0,\"－\",IF(G19<=0,\"－\",G19/G$6*100))","v":"－"},{"$f":"I13-I18","v":0},"－",{"$f":"K13-K18","v":0},"－",{"$f":"M13-M18","v":0},"－",{"$f":"O13-O18","v":0},"－",{"$f":"Q13-Q18","v":0},"－",{"$f":"S13-S18","v":0},"－",{"$f":"U13-U18","v":0},"－"]
["■減価償却費等（既存事業）"]
["減価償却費","普通償却額＋賃借料（地代・家賃を除く）＋リース",{"$f":"過去３期データ入力!D11+過去３期データ入力!D13+過去３期データ入力!D14+過去３期データ入力!D20+過去３期データ入力!D22+過去３期データ入力!D23","v":0},{"$f":"過去３期データ入力!E11+過去３期データ入力!E13+過去３期データ入力!E14+過去３期データ入力!E20+過去３期データ入力!E22+過去３期データ入力!E23","v":0},{"$f":"過去３期データ入力!F11+過去３期データ入力!F13+過去３期データ入力!F14+過去３期データ入力!F20+過去３期データ入力!F22+過去３期データ入力!F23","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,{"$f":"IF(I$6=0,\"－\",IF(I21<=0,\"－\",I21/I$6*100))","v":"－"},null,{"$f":"IF(K$6=0,\"－\",IF(K21<=0,\"－\",K21/K$6*100))","v":"－"},null,{"$f":"IF(M$6=0,\"－\",IF(M21<=0,\"－\",M21/M$6*100))","v":"－"},null,{"$f":"IF(O$6=0,\"－\",IF(O21<=0,\"－\",O21/O$6*100))","v":"－"},null,{"$f":"IF(Q$6=0,\"－\",IF(Q21<=0,\"－\",Q21/Q$6*100))","v":"－"},null,{"$f":"IF(S$6=0,\"－\",IF(S21<=0,\"－\",S21/S$6*100))","v":"－"},null,{"$f":"IF(U$6=0,\"－\",IF(U21<=0,\"－\",U21/U$6*100))","v":"－"}]
[null,"特別償却額",{"$f":"過去３期データ入力!D12+過去３期データ入力!D21","v":0},{"$f":"過去３期データ入力!E12+過去３期データ入力!E21","v":0},{"$f":"過去３期データ入力!F12+過去３期データ入力!F21","v":0},{"$f":"IF(E$6=0,\"－\",IF(E22<=0,\"－\",E22/E$6*100))","v":"－"},null,{"$f":"IF(G$6=0,\"－\",IF(G22<=0,\"－\",G22/G$6*100))","v":"－"},null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－"]
[null,"計　",{"$f":"C21+C22","v":0},{"$f":"D21+D22","v":0},{"$f":"E21+E22","v":0},{"$f":"IF(E$6=0,\"－\",IF(E23<=0,\"－\",E23/E$6*100))","v":"－"},{"$f":"SUM(G21:G22)","v":0},{"$f":"IF(G$6=0,\"－\",IF(G23<=0,\"－\",G23/G$6*100))","v":"－"},{"$f":"SUM(I21:I22)","v":0},"－",{"$f":"SUM(K21:K22)","v":0},"－",{"$f":"SUM(M21:M22)","v":0},"－",{"$f":"SUM(O21:O22)","v":0},"－",{"$f":"SUM(Q21:Q22)","v":0},"－",{"$f":"SUM(S21:S22)","v":0},"－",{"$f":"SUM(U21:U22)","v":0},"－"]
["■必要資金及び資金調達（既存事業）"]
["必要資金","運転資金 ",{"$f":"過去３期データ入力!D32","v":0},{"$f":"過去３期データ入力!E32","v":0},{"$f":"過去３期データ入力!F32","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":"過去３期データ入力!D33","v":0},{"$f":"過去３期データ入力!E33","v":0},{"$f":"過去３期データ入力!F33","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,"計　",{"$f":"C25+C26","v":0},0,0,0,{"$f":"SUM(G25:H26)","v":0},0,{"$f":"SUM(I25:J26)","v":0},0,{"$f":"SUM(K25:L26)","v":0},0,{"$f":"SUM(M25:N26)","v":0},0,{"$f":"SUM(O25:P26)","v":0},0,{"$f":"SUM(Q25:R26)","v":0},0,{"$f":"SUM(S25:T26)","v":0},0,{"$f":"SUM(U25:V26)","v":0},0]
["資金調達額","政府系金融機関"]
[null,"民間金融機関"]
[null,"自己資金"]
[null,"その他"]
[null,"計　",null,null,null,null,{"$f":"SUM(G28:H31)","v":0},{"$f":"H29+H31","v":0},{"$f":"SUM(I28:J31)","v":0},{"$f":"J29+J31","v":0},{"$f":"SUM(K28:L31)","v":0},{"$f":"L29+L31","v":0},{"$f":"SUM(M28:N31)","v":0},{"$f":"N29+N31","v":0},{"$f":"SUM(O28:P31)","v":0},{"$f":"P29+P31","v":0},{"$f":"SUM(Q28:R31)","v":0},{"$f":"R29+R31","v":0},{"$f":"SUM(S28:T31)","v":0},{"$f":"T29+T31","v":0},{"$f":"SUM(U28:V31)","v":0},{"$f":"V29+V31","v":0}]
[null,null,null,null,null,null,{"$f":"IF(G27=G32,\" \",\"エラー\")","v":" "}," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
["■人員配分（既存事業）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（単位：人）"]
["労務費対象者数(換算値)",null,{"$f":"過去３期データ入力!D36","v":0},{"$f":"過去３期データ入力!E36","v":0},{"$f":"過去３期データ入力!F36","v":0}]
["給与賃金対象者数(換算値)",null,{"$f":"過去３期データ入力!D37","v":0},{"$f":"過去３期データ入力!E37","v":0},{"$f":"過去３期データ入力!F37","v":0}]
["専従者",null,{"$f":"過去３期データ入力!D38","v":0},{"$f":"過去３期データ入力!E38","v":0},{"$f":"過去３期データ入力!F38","v":0}]
["個人事業主",null,{"$f":"過去３期データ入力!D39","v":1},{"$f":"過去３期データ入力!E39","v":1},{"$f":"過去３期データ入力!F39","v":1},null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1]
["計",null,{"$f":"SUM(C35:C38)","v":1},{"$f":"SUM(D35:D38)","v":1},{"$f":"SUM(E35:F38)","v":1},{"$f":"SUM(F35:F35)","v":0},{"$f":"SUM(G35:H38)","v":1},{"$f":"SUM(H35:H35)","v":0},{"$f":"SUM(I35:J38)","v":1},{"$f":"SUM(J35:J35)","v":0},{"$f":"SUM(K35:L38)","v":1},{"$f":"SUM(L35:L35)","v":0},{"$f":"SUM(M35:N38)","v":1},{"$f":"SUM(N35:N35)","v":0},{"$f":"SUM(O35:P38)","v":1},{"$f":"SUM(P35:P35)","v":0},{"$f":"SUM(Q35:R38)","v":1},{"$f":"SUM(R35:R35)","v":0},{"$f":"SUM(S35:T38)","v":1},{"$f":"SUM(T35:T35)","v":0},{"$f":"SUM(U35:V38)","v":1},{"$f":"SUM(V35: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":"( 年12月期)"},null,{"$f":"I5","v":"( 年12月期)"},null,{"$f":"K5","v":"( 年12月期)"},null,{"$f":"M5","v":"( 年12月期)"},null,{"$f":"O5","v":"( 年12月期)"},null,{"$f":"Q5","v":"( 年12月期)"},null,{"$f":"S5","v":"( 年12月期)"},null,{"$f":"U5","v":"( 年12月期)"}]
["売上（収入）金額",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(G45<=0,\"－\",G45/G$6*100))","v":"－"},null,{"$f":"IF(I$6=0,\"－\",IF(I45<=0,\"－\",I45/I$6*100))","v":"－"},null,{"$f":"IF(K$6=0,\"－\",IF(K45<=0,\"－\",K45/K$6*100))","v":"－"},null,{"$f":"IF(M$6=0,\"－\",IF(M45<=0,\"－\",M45/M$6*100))","v":"－"},null,{"$f":"IF(O$6=0,\"－\",IF(O45<=0,\"－\",O45/O$6*100))","v":"－"},null,{"$f":"IF(Q$6=0,\"－\",IF(Q45<=0,\"－\",Q45/Q$6*100))","v":"－"},null,{"$f":"IF(S$6=0,\"－\",IF(S45<=0,\"－\",S45/S$6*100))","v":"－"},null,{"$f":"IF(U$6=0,\"－\",IF(U45<=0,\"－\",U45/U$6*100))","v":"－"}]
["差引金額(売上総利益)　",null,null,null,null,null,{"$f":"G44-G45","v":0},"－",{"$f":"I44-I45","v":0},"－",{"$f":"K44-K45","v":0},"－",{"$f":"M44-M45","v":0},"－",{"$f":"O44-O45","v":0},"－",{"$f":"Q44-Q45","v":0},"－",{"$f":"S44-S45","v":0},"－",{"$f":"U44-U45","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,{"$f":"G47+G48","v":0},"－",{"$f":"I47+I48","v":0},"－",{"$f":"K47+K48","v":0},"－",{"$f":"M47+M48","v":0},"－",{"$f":"O47+O48","v":0},"－",{"$f":"Q47+Q48","v":0},"－",{"$f":"S47+S48","v":0},"－",{"$f":"U47+U48","v":0},"－"]
["営業利益",null,null,null,null,null,{"$f":"G46-G47","v":0},"－",{"$f":"I46-I47","v":0},"－",{"$f":"K46-K47","v":0},"－",{"$f":"M46-M47","v":0},"－",{"$f":"O46-O47","v":0},"－",{"$f":"Q46-Q47","v":0},"－",{"$f":"S46-S47","v":0},"－",{"$f":"U46-U47","v":0},"－"]
["差引金額（経常利益）",null,null,null,null,null,{"$f":"G46-G49","v":0},"－",{"$f":"I46-I49","v":0},"－",{"$f":"K46-K49","v":0},"－",{"$f":"M46-M49","v":0},"－",{"$f":"O46-O49","v":0},"－",{"$f":"Q46-Q49","v":0},"－",{"$f":"S46-S49","v":0},"－",{"$f":"U46-U49","v":0},"－"]
["■給与賃金・専従者給与等（新事業）"]
["労務費（給与賃金）",null,null,null,null,null,null,{"$f":"IF(G$6=0,\"－\",IF(G53<=0,\"－\",G53/G$6*100))","v":"－"},null,{"$f":"IF(I$6=0,\"－\",IF(I53<=0,\"－\",I53/I$6*100))","v":"－"},null,{"$f":"IF(K$6=0,\"－\",IF(K53<=0,\"－\",K53/K$6*100))","v":"－"},null,{"$f":"IF(M$6=0,\"－\",IF(M53<=0,\"－\",M53/M$6*100))","v":"－"},null,{"$f":"IF(O$6=0,\"－\",IF(O53<=0,\"－\",O53/O$6*100))","v":"－"},null,{"$f":"IF(Q$6=0,\"－\",IF(Q53<=0,\"－\",Q53/Q$6*100))","v":"－"},null,{"$f":"IF(S$6=0,\"－\",IF(S53<=0,\"－\",S53/S$6*100))","v":"－"},null,{"$f":"IF(U$6=0,\"－\",IF(U53<=0,\"－\",U53/U$6*100))","v":"－"}]
["給与賃金",null,null,null,null,null,null,{"$f":"IF(G$6=0,\"－\",IF(G54<=0,\"－\",G54/G$6*100))","v":"－"},null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－"]
["福利厚生費",null,null,null,null,null,null,{"$f":"IF(G$6=0,\"－\",IF(G55<=0,\"－\",G55/G$6*100))","v":"－"},null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－"]
["専従者給与",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":"G51-G56","v":0},{"$f":"IF(G$6=0,\"－\",IF(G57<=0,\"－\",G57/G$6*100))","v":"－"},{"$f":"I51-I56","v":0},"－",{"$f":"K51-K56","v":0},"－",{"$f":"M51-M56","v":0},"－",{"$f":"O51-O56","v":0},"－",{"$f":"Q51-Q56","v":0},"－",{"$f":"S51-S56","v":0},"－",{"$f":"U51-U56","v":0},"－"]
["■減価償却費等(新事業）"]
["減価償却費","普通償却額＋賃借料（地代・家賃を除く）＋リース",null,null,null,null,null,{"$f":"IF(G$6=0,\"－\",IF(G59<=0,\"－\",G59/G$6*100))","v":"－"},null,{"$f":"IF(I$6=0,\"－\",IF(I59<=0,\"－\",I59/I$6*100))","v":"－"},null,{"$f":"IF(K$6=0,\"－\",IF(K59<=0,\"－\",K59/K$6*100))","v":"－"},null,{"$f":"IF(M$6=0,\"－\",IF(M59<=0,\"－\",M59/M$6*100))","v":"－"},null,{"$f":"IF(O$6=0,\"－\",IF(O59<=0,\"－\",O59/O$6*100))","v":"－"},null,{"$f":"IF(Q$6=0,\"－\",IF(Q59<=0,\"－\",Q59/Q$6*100))","v":"－"},null,{"$f":"IF(S$6=0,\"－\",IF(S59<=0,\"－\",S59/S$6*100))","v":"－"},null,{"$f":"IF(U$6=0,\"－\",IF(U59<=0,\"－\",U59/U$6*100))","v":"－"}]
[null,"特別償却額",null,null,null,null,null,{"$f":"IF(G$6=0,\"－\",IF(G60<=0,\"－\",G60/G$6*100))","v":"－"},null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－"]
[null,"計　",null,null,null,null,{"$f":"SUM(G59:G60)","v":0},{"$f":"IF(G$6=0,\"－\",IF(G61<=0,\"－\",G61/G$6*100))","v":"－"},{"$f":"SUM(I59:I60)","v":0},"－",{"$f":"SUM(K59:K60)","v":0},"－",{"$f":"SUM(M59:M60)","v":0},"－",{"$f":"SUM(O59:O60)","v":0},"－",{"$f":"SUM(Q59:Q60)","v":0},"－",{"$f":"SUM(S59:S60)","v":0},"－",{"$f":"SUM(U59:U60)","v":0},"－"]
["■必要資金及び資金調達（新事業）"]
["必要資金","運転資金","       通常運転資金 ",null,null,null,{"$f":"ROUND((G45+G47)/12,-2)","v":0},null,{"$f":"ROUND((I45+I47)/12,-2)","v":0},null,{"$f":"ROUND((K45+K47)/12,-2)","v":0},null,{"$f":"ROUND((M45+M47)/12,-2)","v":0},null,{"$f":"ROUND((O45+O47)/12,-2)","v":0},null,{"$f":"ROUND((Q45+Q47)/12,-2)","v":0},null,{"$f":"ROUND((S45+S47)/12,-2)","v":0},null,{"$f":"ROUND((U45+U47)/12,-2)","v":0}]
[null,null,"       増加運転資金"]
[null,null,"計",null,null,null,{"$f":"G63+G64","v":0},null,{"$f":"I63+I64","v":0},null,{"$f":"K63+K64","v":0},null,{"$f":"M63+M64","v":0},null,{"$f":"O63+O64","v":0},null,{"$f":"Q63+Q64","v":0},null,{"$f":"S63+S64","v":0},null,{"$f":"U63+U64","v":0}]
[null,"設備投資額（税込み）"]
[null,"計　",null,null,null,null,{"$f":"G65+G66","v":0},{"$f":"H63+H66","v":0},{"$f":"I65+I66","v":0},{"$f":"J63+J66","v":0},{"$f":"K65+K66","v":0},{"$f":"L63+L66","v":0},{"$f":"M65+M66","v":0},{"$f":"N63+N66","v":0},{"$f":"O65+O66","v":0},{"$f":"P63+P66","v":0},{"$f":"Q65+Q66","v":0},{"$f":"R63+R66","v":0},{"$f":"S65+S66","v":0},{"$f":"T63+T66","v":0},{"$f":"U65+U66","v":0},{"$f":"V63+V66","v":0}]
["資金調達額","政府系金融機関"]
[null,"民間金融機関"]
[null,"自己資金"]
[null,"その他"]
[null,"計　",null,null,null,null,{"$f":"SUM(G68:H71)","v":0},{"$f":"H69+H71","v":0},{"$f":"SUM(I68:J71)","v":0},{"$f":"J69+J71","v":0},{"$f":"SUM(K68:L71)","v":0},{"$f":"L69+L71","v":0},{"$f":"SUM(M68:N71)","v":0},{"$f":"N69+N71","v":0},{"$f":"SUM(O68:P71)","v":0},{"$f":"P69+P71","v":0},{"$f":"SUM(Q68:R71)","v":0},{"$f":"R69+R71","v":0},{"$f":"SUM(S68:T71)","v":0},{"$f":"T69+T71","v":0},{"$f":"SUM(U68:V71)","v":0},{"$f":"V69+V71","v":0}]
[null,null,null,null,null,null,{"$f":"IF(G67=G72,\" \",\"エラー\")","v":" "}," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
["■人員配分（新事業）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（単位：人）"]
["労務費対象者数(換算値)"]
["給与賃金対象者数(換算値)"]
["計",null,null,null,null,null,{"$f":"SUM(G75:G76)","v":0},{"$f":"SUM(H75:H76)","v":0},{"$f":"SUM(I75:I76)","v":0},{"$f":"SUM(J75:J76)","v":0},{"$f":"SUM(K75:K76)","v":0},null,{"$f":"SUM(M75:M76)","v":0},0,0,0,0,0,0,0,0,0]

{"sheet":"計画全体（自動出力）","index":3,"n_rows":52,"n_cols":14,"rows_kept":52,"cut":false,"hidden":false,"merged":[[38,1,38,2],[46,1,46,2],[48,1,48,2],[50,1,50,2],[25,1,25,2],[26,1,28,1],[29,1,32,1],[35,1,35,3],[36,1,36,2],[37,1,37,2],[21,1,23,1],[7,1,9,1],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,3],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[20,1,20,3],[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,null,null,null,null,null,null,"(単位：千円）"]
[null,null,null,"２年前","１年前","直近期末","１年後","２年後","３年後","４年後","５年後","６年後","７年後","８年後"]
[null,null,null,{"$f":"過去３期データ入力!D6","v":"( 年12月期)"},{"$f":"過去３期データ入力!E6","v":"( 年12月期)"},{"$f":"過去３期データ入力!F6","v":"( 年12月期)"},{"$f":"計画数値データ入力!G5","v":"( 年12月期)"},{"$f":"計画数値データ入力!I5","v":"( 年12月期)"},{"$f":"計画数値データ入力!K5","v":"( 年12月期)"},{"$f":"計画数値データ入力!M5","v":"( 年12月期)"},{"$f":"計画数値データ入力!O5","v":"( 年12月期)"},{"$f":"計画数値データ入力!Q5","v":"( 年12月期)"},{"$f":"計画数値データ入力!S5","v":"( 年12月期)"},{"$f":"計画数値データ入力!U5","v":"( 年12月期)"}]
[null,"売上（収入）金額",null,{"$f":"計画数値データ入力!C6","v":0},{"$f":"計画数値データ入力!D6","v":0},{"$f":"計画数値データ入力!E6","v":0},{"$f":"計画数値データ入力!G6+計画数値データ入力!G44","v":0},{"$f":"計画数値データ入力!I6+計画数値データ入力!I44","v":0},{"$f":"計画数値データ入力!K6+計画数値データ入力!K44","v":0},{"$f":"計画数値データ入力!M6+計画数値データ入力!M44","v":0},{"$f":"計画数値データ入力!O6+計画数値データ入力!O44","v":0},{"$f":"計画数値データ入力!Q6+計画数値データ入力!Q44","v":0},{"$f":"計画数値データ入力!S6+計画数値データ入力!S44","v":0},{"$f":"計画数値データ入力!U6+計画数値データ入力!U44","v":0}]
[null,"売上原価（差引原価）",null,{"$f":"計画数値データ入力!C7","v":0},{"$f":"計画数値データ入力!D7","v":0},{"$f":"計画数値データ入力!E7","v":0},{"$f":"計画数値データ入力!G7+計画数値データ入力!G45","v":0},{"$f":"計画数値データ入力!I7+計画数値データ入力!I45","v":0},{"$f":"計画数値データ入力!K7+計画数値データ入力!K45","v":0},{"$f":"計画数値データ入力!M7+計画数値データ入力!M45","v":0},{"$f":"計画数値データ入力!O7+計画数値データ入力!O45","v":0},{"$f":"計画数値データ入力!Q7+計画数値データ入力!Q45","v":0},{"$f":"計画数値データ入力!S7+計画数値データ入力!S45","v":0},{"$f":"計画数値データ入力!U7+計画数値データ入力!U45","v":0}]
[null,"差引金額(売上総利益)　",null,{"$f":"ROUND((D5-D6),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null," 経 費","経費（利子割引料を除く）",{"$f":"計画数値データ入力!C9","v":0},{"$f":"計画数値データ入力!D9","v":0},{"$f":"計画数値データ入力!E9","v":0},{"$f":"計画数値データ入力!G9+計画数値データ入力!G47","v":0},{"$f":"計画数値データ入力!I9+計画数値データ入力!I47","v":0},{"$f":"計画数値データ入力!K9+計画数値データ入力!K47","v":0},{"$f":"計画数値データ入力!M9+計画数値データ入力!M47","v":0},{"$f":"計画数値データ入力!O9+計画数値データ入力!O47","v":0},{"$f":"計画数値データ入力!Q9+計画数値データ入力!Q47","v":0},{"$f":"計画数値データ入力!S9+計画数値データ入力!S47","v":0},{"$f":"計画数値データ入力!U9+計画数値データ入力!U47","v":0}]
[null,null,"利子割引料",{"$f":"計画数値データ入力!C10","v":0},{"$f":"計画数値データ入力!D10","v":0},{"$f":"計画数値データ入力!E10","v":0},{"$f":"計画数値データ入力!G10+計画数値データ入力!G48","v":0},{"$f":"計画数値データ入力!I10+計画数値データ入力!I48","v":0},{"$f":"計画数値データ入力!K10+計画数値データ入力!K48","v":0},{"$f":"計画数値データ入力!M10+計画数値データ入力!M48","v":0},{"$f":"計画数値データ入力!O10+計画数値データ入力!O48","v":0},{"$f":"計画数値データ入力!Q10+計画数値データ入力!Q48","v":0},{"$f":"計画数値データ入力!S10+計画数値データ入力!S48","v":0},{"$f":"計画数値データ入力!U10+計画数値データ入力!U48","v":0}]
[null,null,"計",{"$f":"ROUND(SUM(D8:D9),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"営業利益",null,{"$f":"ROUND((D7-D8),0)","v":0},{"$f":"ROUND((E7-E8),0)","v":0},0,0,0,0,0,0,0,0,0]
[null,"経常利益（差引金額）",null,{"$f":"D7-D10","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,"■給与賃金・専従者給与等"]
[null,"労務費（給与賃金）",null,{"$f":"計画数値データ入力!C15","v":0},{"$f":"計画数値データ入力!D15","v":0},{"$f":"計画数値データ入力!E15","v":0},{"$f":"計画数値データ入力!G15+計画数値データ入力!G53","v":0},{"$f":"計画数値データ入力!I15+計画数値データ入力!I53","v":0},{"$f":"計画数値データ入力!K15+計画数値データ入力!K53","v":0},{"$f":"計画数値データ入力!M15+計画数値データ入力!M53","v":0},{"$f":"計画数値データ入力!O15+計画数値データ入力!O53","v":0},{"$f":"計画数値データ入力!Q15+計画数値データ入力!Q53","v":0},{"$f":"計画数値データ入力!S15+計画数値データ入力!S53","v":0},{"$f":"計画数値データ入力!U15+計画数値データ入力!U53","v":0}]
[null,"給与賃金",null,{"$f":"計画数値データ入力!C16","v":0},{"$f":"計画数値データ入力!D16","v":0},{"$f":"計画数値データ入力!E16","v":0},{"$f":"計画数値データ入力!G16+計画数値データ入力!G54","v":0},{"$f":"計画数値データ入力!I16+計画数値データ入力!I54","v":0},{"$f":"計画数値データ入力!K16+計画数値データ入力!K54","v":0},{"$f":"計画数値データ入力!M16+計画数値データ入力!M54","v":0},{"$f":"計画数値データ入力!O16+計画数値データ入力!O54","v":0},{"$f":"計画数値データ入力!Q16+計画数値データ入力!Q54","v":0},{"$f":"計画数値データ入力!S16+計画数値データ入力!S54","v":0},{"$f":"計画数値データ入力!U16+計画数値データ入力!U54","v":0}]
[null,"福利厚生費",null,{"$f":"計画数値データ入力!C17","v":0},{"$f":"計画数値データ入力!D17","v":0},{"$f":"計画数値データ入力!E17","v":0},{"$f":"計画数値データ入力!G17+計画数値データ入力!G55","v":0},{"$f":"計画数値データ入力!I17+計画数値データ入力!I55","v":0},{"$f":"計画数値データ入力!K17+計画数値データ入力!K55","v":0},{"$f":"計画数値データ入力!M17+計画数値データ入力!M55","v":0},{"$f":"計画数値データ入力!O17+計画数値データ入力!O55","v":0},{"$f":"計画数値データ入力!Q17+計画数値データ入力!Q55","v":0},{"$f":"計画数値データ入力!S17+計画数値データ入力!S55","v":0},{"$f":"計画数値データ入力!U17+計画数値データ入力!U55","v":0}]
[null,"専従者給与",null,{"$f":"計画数値データ入力!C18","v":0},{"$f":"計画数値データ入力!D18","v":0},{"$f":"計画数値データ入力!E18","v":0},{"$f":"計画数値データ入力!G18+計画数値データ入力!G56","v":0},{"$f":"計画数値データ入力!I18+計画数値データ入力!I56","v":0},{"$f":"計画数値データ入力!K18+計画数値データ入力!K56","v":0},{"$f":"計画数値データ入力!M18+計画数値データ入力!M56","v":0},{"$f":"計画数値データ入力!O18+計画数値データ入力!O56","v":0},{"$f":"計画数値データ入力!Q18+計画数値データ入力!Q56","v":0},{"$f":"計画数値データ入力!S18+計画数値データ入力!S56","v":0},{"$f":"計画数値データ入力!U18+計画数値データ入力!U56","v":0}]
[null,"青色申告特別控除前の所得金額",null,{"$f":"計画数値データ入力!C19","v":0},{"$f":"計画数値データ入力!D19","v":0},{"$f":"計画数値データ入力!E19","v":0},{"$f":"計画数値データ入力!G19+計画数値データ入力!G57","v":0},{"$f":"計画数値データ入力!I19+計画数値データ入力!I57","v":0},{"$f":"計画数値データ入力!K19+計画数値データ入力!K57","v":0},{"$f":"計画数値データ入力!M19+計画数値データ入力!M57","v":0},{"$f":"計画数値データ入力!O19+計画数値データ入力!O57","v":0},{"$f":"計画数値データ入力!Q19+計画数値データ入力!Q57","v":0},{"$f":"計画数値データ入力!S19+計画数値データ入力!S57","v":0},{"$f":"計画数値データ入力!U19+計画数値データ入力!U57","v":0}]
[]
[null,"■減価償却費等"]
[null,"減価償却費","普通償却額＋賃借料＋リース",{"$f":"計画数値データ入力!C21","v":0},{"$f":"計画数値データ入力!D21","v":0},{"$f":"計画数値データ入力!E21","v":0},{"$f":"計画数値データ入力!G21+計画数値データ入力!G59","v":0},{"$f":"計画数値データ入力!I21+計画数値データ入力!I59","v":0},{"$f":"計画数値データ入力!K21+計画数値データ入力!K59","v":0},{"$f":"計画数値データ入力!M21+計画数値データ入力!M59","v":0},{"$f":"計画数値データ入力!O21+計画数値データ入力!O59","v":0},{"$f":"計画数値データ入力!Q21+計画数値データ入力!Q59","v":0},{"$f":"計画数値データ入力!S21+計画数値データ入力!S59","v":0},{"$f":"計画数値データ入力!U21+計画数値データ入力!U59","v":0}]
[null,null,"特別償却額",{"$f":"計画数値データ入力!C22","v":0},{"$f":"計画数値データ入力!D22","v":0},{"$f":"計画数値データ入力!E22","v":0},{"$f":"計画数値データ入力!G22+計画数値データ入力!G60","v":0},{"$f":"計画数値データ入力!I22+計画数値データ入力!I60","v":0},{"$f":"計画数値データ入力!K22+計画数値データ入力!K60","v":0},{"$f":"計画数値データ入力!M22+計画数値データ入力!M60","v":0},{"$f":"計画数値データ入力!O22+計画数値データ入力!O60","v":0},{"$f":"計画数値データ入力!Q22+計画数値データ入力!Q60","v":0},{"$f":"計画数値データ入力!S22+計画数値データ入力!S60","v":0},{"$f":"計画数値データ入力!U22+計画数値データ入力!U60","v":0}]
[null,null,"計　",{"$f":"SUM(D22:D23)","v":0},{"$f":"SUM(E22:E23)","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,"■資金計画"]
[null,"必要資金","運転資金",{"$f":"計画数値データ入力!C25","v":0},{"$f":"計画数値データ入力!D25","v":0},{"$f":"計画数値データ入力!E25","v":0},{"$f":"計画数値データ入力!G25+計画数値データ入力!G65","v":0},{"$f":"計画数値データ入力!I25+計画数値データ入力!I65","v":0},{"$f":"計画数値データ入力!K25+計画数値データ入力!K65","v":0},{"$f":"計画数値データ入力!M25+計画数値データ入力!M65","v":0},{"$f":"計画数値データ入力!O25+計画数値データ入力!O65","v":0},{"$f":"計画数値データ入力!Q25+計画数値データ入力!Q65","v":0},{"$f":"計画数値データ入力!S25+計画数値データ入力!S65","v":0},{"$f":"計画数値データ入力!U25+計画数値データ入力!U65","v":0}]
[null,null,"設備投資額",{"$f":"計画数値データ入力!C26","v":0},{"$f":"計画数値データ入力!D26","v":0},{"$f":"計画数値データ入力!E26","v":0},{"$f":"計画数値データ入力!G26+計画数値データ入力!G66","v":0},{"$f":"計画数値データ入力!I26+計画数値データ入力!I66","v":0},{"$f":"計画数値データ入力!K26+計画数値データ入力!K66","v":0},{"$f":"計画数値データ入力!M26+計画数値データ入力!M66","v":0},{"$f":"計画数値データ入力!O26+計画数値データ入力!O66","v":0},{"$f":"計画数値データ入力!Q26+計画数値データ入力!Q66","v":0},{"$f":"計画数値データ入力!S26+計画数値データ入力!S66","v":0},{"$f":"計画数値データ入力!U26+計画数値データ入力!U66","v":0}]
[null,null,"計",{"$f":"SUM(D27:D28)","v":0},{"$f":"SUM(E27:E28)","v":0},{"$f":"SUM(F27:F28)","v":0},{"$f":"SUM(G27:G28)","v":0},{"$f":"SUM(H27:H28)","v":0},0,0,0,0,0,{"$f":"SUM(N27:N28)","v":0}]
[null,"資金調達額","政府系金融機関",null,null,null,{"$f":"計画数値データ入力!G28+計画数値データ入力!G68","v":0},{"$f":"計画数値データ入力!I28+計画数値データ入力!I68","v":0},{"$f":"計画数値データ入力!K28+計画数値データ入力!K68","v":0},{"$f":"計画数値データ入力!M28+計画数値データ入力!M68","v":0},{"$f":"計画数値データ入力!O28+計画数値データ入力!O68","v":0},{"$f":"計画数値データ入力!Q28+計画数値データ入力!Q68","v":0},{"$f":"計画数値データ入力!S28+計画数値データ入力!S68","v":0},{"$f":"計画数値データ入力!U28+計画数値データ入力!U68","v":0}]
[null,null,"民間金融機関",null,null,null,{"$f":"計画数値データ入力!G29+計画数値データ入力!G69","v":0},{"$f":"計画数値データ入力!I29+計画数値データ入力!I69","v":0},{"$f":"計画数値データ入力!K29+計画数値データ入力!K69","v":0},{"$f":"計画数値データ入力!M29+計画数値データ入力!M69","v":0},{"$f":"計画数値データ入力!O29+計画数値データ入力!O69","v":0},{"$f":"計画数値データ入力!Q29+計画数値データ入力!Q69","v":0},{"$f":"計画数値データ入力!S29+計画数値データ入力!S69","v":0},{"$f":"計画数値データ入力!U29+計画数値データ入力!U69","v":0}]
[null,null,"自己資金",null,null,null,{"$f":"計画数値データ入力!G30+計画数値データ入力!G70","v":0},{"$f":"計画数値データ入力!I30+計画数値データ入力!I70","v":0},{"$f":"計画数値データ入力!K30+計画数値データ入力!K70","v":0},{"$f":"計画数値データ入力!M30+計画数値データ入力!M70","v":0},{"$f":"計画数値データ入力!O30+計画数値データ入力!O70","v":0},{"$f":"計画数値データ入力!Q30+計画数値データ入力!Q70","v":0},{"$f":"計画数値データ入力!S30+計画数値データ入力!S70","v":0},{"$f":"計画数値データ入力!U30+計画数値データ入力!U70","v":0}]
[null,null,"その他",null,null,null,{"$f":"計画数値データ入力!G31+計画数値データ入力!G71","v":0},{"$f":"計画数値データ入力!I31+計画数値データ入力!I71","v":0},{"$f":"計画数値データ入力!K31+計画数値データ入力!K71","v":0},{"$f":"計画数値データ入力!M31+計画数値データ入力!M71","v":0},{"$f":"計画数値データ入力!O31+計画数値データ入力!O71","v":0},{"$f":"計画数値データ入力!Q31+計画数値データ入力!Q71","v":0},{"$f":"計画数値データ入力!S31+計画数値データ入力!S71","v":0},{"$f":"計画数値データ入力!U31+計画数値データ入力!U71","v":0}]
[null,null,"計",null,null,null,{"$f":"SUM(G30:G33)","v":0},{"$f":"SUM(H30:H33)","v":0},0,0,0,0,0,0]
[null,null,null,null,null,null,{"$f":"IF(G29=G34,\" \",\"エラー\")","v":" "},{"$f":"IF(H29=H34,\" \",\"エラー\")","v":" "}," "," "," "," "," "," "]
[null,"■人員配分（換算値）",null,null,null,null,null,null,null,null,null,null,null,"（単位：人）"]
[null,"既存事業",null,{"$f":"計画数値データ入力!C39","v":1},{"$f":"計画数値データ入力!D39","v":1},{"$f":"計画数値データ入力!E39","v":1},{"$f":"計画数値データ入力!G39","v":1},{"$f":"計画数値データ入力!I39","v":1},{"$f":"計画数値データ入力!K39","v":1},{"$f":"計画数値データ入力!M39","v":1},{"$f":"計画数値データ入力!O39","v":1},{"$f":"計画数値データ入力!Q39","v":1},{"$f":"計画数値データ入力!S39","v":1},{"$f":"計画数値データ入力!U39","v":1}]
[null,"新規事業",null,null,null,null,{"$f":"計画数値データ入力!G77","v":0},{"$f":"計画数値データ入力!I77","v":0},{"$f":"計画数値データ入力!K77","v":0},{"$f":"計画数値データ入力!M77","v":0},{"$f":"計画数値データ入力!O77","v":0},{"$f":"計画数値データ入力!Q77","v":0},{"$f":"計画数値データ入力!S77","v":0},{"$f":"計画数値データ入力!U77","v":0}]
[null,"計",null,{"$f":"SUM(D37:D38)","v":1},{"$f":"SUM(E37:E38)","v":1},{"$f":"SUM(F37:F38)","v":1},{"$f":"SUM(G37:G38)","v":1},{"$f":"SUM(H37:H38)","v":1},{"$f":"SUM(I37:I38)","v":1},1,1,1,1,{"$f":"SUM(N37:N38)","v":1}]
[null,null,"科目別内訳（換算値）"]
[null,null,"労務費対象人数",{"$f":"ROUND((計画数値データ入力!C35),1)","v":0},{"$f":"ROUND((計画数値データ入力!D35),1)","v":0},{"$f":"ROUND((計画数値データ入力!E35),1)","v":0},{"$f":"計画数値データ入力!G35+計画数値データ入力!G75","v":0},{"$f":"計画数値データ入力!I35+計画数値データ入力!I75","v":0},{"$f":"計画数値データ入力!K35+計画数値データ入力!K75","v":0},{"$f":"計画数値データ入力!M35+計画数値データ入力!M75","v":0},{"$f":"計画数値データ入力!O35+計画数値データ入力!O75","v":0},{"$f":"計画数値データ入力!Q35+計画数値データ入力!Q75","v":0},{"$f":"計画数値データ入力!S35+計画数値データ入力!S75","v":0},{"$f":"計画数値データ入力!U35+計画数値データ入力!U75","v":0}]
[null,null,"給与賃金対象人数",{"$f":"ROUND((過去３期データ入力!D37),1)","v":0},{"$f":"ROUND((過去３期データ入力!E37),1)","v":0},{"$f":"ROUND((過去３期データ入力!F37),1)","v":0},{"$f":"計画数値データ入力!G36+計画数値データ入力!G76","v":0},{"$f":"計画数値データ入力!I36+計画数値データ入力!I76","v":0},{"$f":"計画数値データ入力!K36+計画数値データ入力!K76","v":0},{"$f":"計画数値データ入力!M36+計画数値データ入力!M76","v":0},{"$f":"計画数値データ入力!O36+計画数値データ入力!O76","v":0},{"$f":"計画数値データ入力!Q36+計画数値データ入力!Q76","v":0},{"$f":"計画数値データ入力!S36+計画数値データ入力!S76","v":0},{"$f":"計画数値データ入力!U36+計画数値データ入力!U76","v":0}]
[null,null,"専従者",{"$f":"ROUND((過去３期データ入力!D38),1)","v":0},{"$f":"ROUND((過去３期データ入力!E38),1)","v":0},{"$f":"ROUND((過去３期データ入力!F38),1)","v":0},{"$f":"計画数値データ入力!G37","v":0},{"$f":"計画数値データ入力!I37","v":0},{"$f":"計画数値データ入力!K37","v":0},{"$f":"計画数値データ入力!M37","v":0},{"$f":"計画数値データ入力!O37","v":0},{"$f":"計画数値データ入力!Q37","v":0},{"$f":"計画数値データ入力!S37","v":0},{"$f":"計画数値データ入力!U37","v":0}]
[null,null,"個人事業主",{"$f":"ROUND((過去３期データ入力!D39),1)","v":1},{"$f":"ROUND((過去３期データ入力!E39),1)","v":1},{"$f":"ROUND((過去３期データ入力!F39),1)","v":1},{"$f":"計画数値データ入力!G38","v":1},{"$f":"計画数値データ入力!I38","v":1},{"$f":"計画数値データ入力!K38","v":1},{"$f":"計画数値データ入力!M38","v":1},{"$f":"計画数値データ入力!O38","v":1},{"$f":"計画数値データ入力!Q38","v":1},{"$f":"計画数値データ入力!S38","v":1},{"$f":"計画数値データ入力!U38","v":1}]
[]
[null,"■指標"]
[null,"付加価値額",null,{"$f":"D11+D15+D16+D17+D24","v":0},{"$f":"E11+E15+E16+E17+E24","v":0},0,0,0,0,0,0,0,0,0]
[null,null,"伸び率",null,null,null,null,null,{"$f":"IF(I47=0,\" \",ROUND(((I47-$F$47)/ABS($F$47)),3))","v":" "}," "," "," "," "," "]
[null,"一人当たり付加価値額",null,{"$f":"IF(D39=0,,ROUND((D47/D39),0))","v":0},{"$f":"IF(E39=0,,ROUND((E47/E39),0))","v":0},{"$f":"IF(F39=0,,ROUND((F47/F39),0))","v":0},{"$f":"IF(G39=0,,ROUND((G47/G39),0))","v":0},0,0,0,0,0,0,0]
[null,null,"伸び率",null,null,null,null,null,{"$f":"IF(I49=0,\" \",ROUND(((I49-$F$49)/ABS($F$49)),3))","v":" "}," "," "," "," "," "]
[null,"給与支給総額",null,{"$f":"D15+D16+D18+D19","v":0},{"$f":"E15+E16+E18+E19","v":0},0,0,0,0,0,0,0,0,0]
[null,null,"伸び率",null,null,null,null,null,{"$f":"IF(I51=0,\" \",ROUND(((I51-$F$51)/ABS($F$51)),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":"( 年12月期)"},{"$f":"'計画全体（自動出力）'!E4","v":"( 年12月期)"},{"$f":"'計画全体（自動出力）'!F4","v":"( 年12月期)"},{"$f":"'計画全体（自動出力）'!G4","v":"( 年12月期)"},{"$f":"'計画全体（自動出力）'!H4","v":"( 年12月期)"},{"$f":"'計画全体（自動出力）'!I4","v":"( 年12月期)"},{"$f":"'計画全体（自動出力）'!J4","v":"( 年12月期)"},{"$f":"'計画全体（自動出力）'!K4","v":"( 年12月期)"},{"$f":"'計画全体（自動出力）'!L4","v":"( 年12月期)"},{"$f":"'計画全体（自動出力）'!M4","v":"( 年12月期)"},{"$f":"'計画全体（自動出力）'!N4","v":"( 年12月期)"}]
["①売上高",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},{"$f":"E6-E7","v":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":"'計画全体（自動出力）'!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}]
["⑥経常利益",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":"'計画全体（自動出力）'!D51","v":0},{"$f":"'計画全体（自動出力）'!E51","v":0},{"$f":"'計画全体（自動出力）'!F51","v":0},{"$f":"'計画全体（自動出力）'!G51","v":0},{"$f":"'計画全体（自動出力）'!H51","v":0},{"$f":"'計画全体（自動出力）'!I51","v":0},{"$f":"'計画全体（自動出力）'!J51","v":0},{"$f":"'計画全体（自動出力）'!K51","v":0},{"$f":"'計画全体（自動出力）'!L51","v":0},{"$f":"'計画全体（自動出力）'!M51","v":0},{"$f":"'計画全体（自動出力）'!N51","v":0}]
["⑧人件費",null,null,{"$f":"'計画全体（自動出力）'!D15+'計画全体（自動出力）'!D16+'計画全体（自動出力）'!D17","v":0},{"$f":"'計画全体（自動出力）'!E15+'計画全体（自動出力）'!E16+'計画全体（自動出力）'!E17","v":0},{"$f":"'計画全体（自動出力）'!F15+'計画全体（自動出力）'!F16+'計画全体（自動出力）'!F17","v":0},{"$f":"'計画全体（自動出力）'!G15+'計画全体（自動出力）'!G16+'計画全体（自動出力）'!G17","v":0},{"$f":"'計画全体（自動出力）'!H15+'計画全体（自動出力）'!H16+'計画全体（自動出力）'!H17","v":0},{"$f":"'計画全体（自動出力）'!I15+'計画全体（自動出力）'!I16+'計画全体（自動出力）'!I17","v":0},{"$f":"'計画全体（自動出力）'!J15+'計画全体（自動出力）'!J16+'計画全体（自動出力）'!J17","v":0},{"$f":"'計画全体（自動出力）'!K15+'計画全体（自動出力）'!K16+'計画全体（自動出力）'!K17","v":0},{"$f":"'計画全体（自動出力）'!L15+'計画全体（自動出力）'!L16+'計画全体（自動出力）'!L17","v":0},{"$f":"'計画全体（自動出力）'!M15+'計画全体（自動出力）'!M16+'計画全体（自動出力）'!M17","v":0},{"$f":"'計画全体（自動出力）'!N15+'計画全体（自動出力）'!N16+'計画全体（自動出力）'!N17","v":0}]
["⑨設備投資額",null,null,{"$f":"'計画全体（自動出力）'!D28","v":0},{"$f":"'計画全体（自動出力）'!E28","v":0},{"$f":"'計画全体（自動出力）'!F28","v":0},{"$f":"'計画全体（自動出力）'!G28","v":0},{"$f":"'計画全体（自動出力）'!H28","v":0},{"$f":"'計画全体（自動出力）'!I28","v":0},{"$f":"'計画全体（自動出力）'!J28","v":0},{"$f":"'計画全体（自動出力）'!K28","v":0},{"$f":"'計画全体（自動出力）'!L28","v":0},{"$f":"'計画全体（自動出力）'!M28","v":0},{"$f":"'計画全体（自動出力）'!N28","v":0}]
["⑩運転資金",null,null,{"$f":"'計画全体（自動出力）'!D27","v":0},{"$f":"'計画全体（自動出力）'!E27","v":0},{"$f":"'計画全体（自動出力）'!F27","v":0},{"$f":"'計画全体（自動出力）'!G27","v":0},{"$f":"'計画全体（自動出力）'!H27","v":0},{"$f":"'計画全体（自動出力）'!I27","v":0},{"$f":"'計画全体（自動出力）'!J27","v":0},{"$f":"'計画全体（自動出力）'!K27","v":0},{"$f":"'計画全体（自動出力）'!L27","v":0},{"$f":"'計画全体（自動出力）'!M27","v":0},{"$f":"'計画全体（自動出力）'!N27","v":0}]
[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":"'計画全体（自動出力）'!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":"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},{"$f":"E10+E13+E18","v":0},0,0,0,0,0,0,0,0,0]
["⑬従業員数",null,null,{"$f":"'計画全体（自動出力）'!D39","v":1},{"$f":"'計画全体（自動出力）'!E39","v":1},{"$f":"'計画全体（自動出力）'!F39","v":1},{"$f":"'計画全体（自動出力）'!G39","v":1},{"$f":"'計画全体（自動出力）'!H39","v":1},{"$f":"'計画全体（自動出力）'!I39","v":1},{"$f":"'計画全体（自動出力）'!J39","v":1},{"$f":"'計画全体（自動出力）'!K39","v":1},{"$f":"'計画全体（自動出力）'!L39","v":1},{"$f":"'計画全体（自動出力）'!M39","v":1},{"$f":"'計画全体（自動出力）'!N39","v":1}]
["⑭一人当たりの付加価値額（⑫÷⑬）",null,null,{"$f":"IF(D20>0,ROUND(D19/D20,0),0)","v":0},{"$f":"IF(E20>0,ROUND(E19/E20,0),0)","v":0},0,0,0,0,0,0,0,0,0]
["⑮資金調達額(⑨＋⑩）","政府系金融\n機関借入",null,"－","－","－",{"$f":"'計画全体（自動出力）'!G30","v":0},{"$f":"'計画全体（自動出力）'!H30","v":0},{"$f":"'計画全体（自動出力）'!I30","v":0},{"$f":"'計画全体（自動出力）'!J30","v":0},{"$f":"'計画全体（自動出力）'!K30","v":0},{"$f":"'計画全体（自動出力）'!L30","v":0},{"$f":"'計画全体（自動出力）'!M30","v":0},{"$f":"'計画全体（自動出力）'!N30","v":0}]
[null,"民間金融機\n関借入",null,"－","－","－",{"$f":"'計画全体（自動出力）'!G31","v":0},{"$f":"'計画全体（自動出力）'!H31","v":0},{"$f":"'計画全体（自動出力）'!I31","v":0},{"$f":"'計画全体（自動出力）'!J31","v":0},{"$f":"'計画全体（自動出力）'!K31","v":0},{"$f":"'計画全体（自動出力）'!L31","v":0},{"$f":"'計画全体（自動出力）'!M31","v":0},{"$f":"'計画全体（自動出力）'!N31","v":0}]
[null,"自己資金",null,"－","－","－",{"$f":"'計画全体（自動出力）'!G32","v":0},{"$f":"'計画全体（自動出力）'!H32","v":0},{"$f":"'計画全体（自動出力）'!I32","v":0},{"$f":"'計画全体（自動出力）'!J32","v":0},{"$f":"'計画全体（自動出力）'!K32","v":0},{"$f":"'計画全体（自動出力）'!L32","v":0},{"$f":"'計画全体（自動出力）'!M32","v":0},{"$f":"'計画全体（自動出力）'!N32","v":0}]
[null,"その他",null,"－","－","－",{"$f":"'計画全体（自動出力）'!G33","v":0},{"$f":"'計画全体（自動出力）'!H33","v":0},{"$f":"'計画全体（自動出力）'!I33","v":0},{"$f":"'計画全体（自動出力）'!J33","v":0},{"$f":"'計画全体（自動出力）'!K33","v":0},{"$f":"'計画全体（自動出力）'!L33","v":0},{"$f":"'計画全体（自動出力）'!M33","v":0},{"$f":"'計画全体（自動出力）'!N33","v":0}]
[null,"　合　計",null,"－","－","－",{"$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,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":"( 年12月期)"},{"$f":"'申請書＜別表３＞（自動出力）'!$I$5","v":"( 年12月期)"},"（％）"]
[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":1},{"$f":"'申請書＜別表３＞（自動出力）'!$I$20","v":1},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":"( 年12月期)"},{"$f":"'申請書＜別表３＞（自動出力）'!$J$5","v":"( 年12月期)"},"（％）"]
[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":1},{"$f":"'申請書＜別表３＞（自動出力）'!$J$20","v":1},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":"( 年12月期)"},{"$f":"'申請書＜別表３＞（自動出力）'!$K$5","v":"( 年12月期)"},"（％）"]
[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":1},{"$f":"'申請書＜別表３＞（自動出力）'!$K$20","v":1},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":"( 年12月期)"},{"$f":"'申請書＜別表３＞（自動出力）'!L5","v":"( 年12月期)"},"（％）"]
[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":1},{"$f":"'申請書＜別表３＞（自動出力）'!$L$20","v":1},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":"( 年12月期)"},{"$f":"'申請書＜別表３＞（自動出力）'!$M$5","v":"( 年12月期)"},"（％）"]
[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":1},{"$f":"'申請書＜別表３＞（自動出力）'!$M$20","v":1},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":"( 年12月期)"},{"$f":"'申請書＜別表３＞（自動出力）'!$N$5","v":"( 年12月期)"},"（％）"]
[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":1},{"$f":"'申請書＜別表３＞（自動出力）'!$N$20","v":1},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":1},{"$f":"'申請書＜別表３＞（自動出力）'!E20","v":1},{"$f":"'申請書＜別表３＞（自動出力）'!F20","v":1},{"$f":"'申請書＜別表３＞（自動出力）'!G20","v":1},{"$f":"'申請書＜別表３＞（自動出力）'!H20","v":1},{"$f":"'申請書＜別表３＞（自動出力）'!I20","v":1},{"$f":"'申請書＜別表３＞（自動出力）'!J20","v":1},{"$f":"'申請書＜別表３＞（自動出力）'!K20","v":1},{"$f":"'申請書＜別表３＞（自動出力）'!L20","v":1},{"$f":"'申請書＜別表３＞（自動出力）'!M20","v":1},{"$f":"'申請書＜別表３＞（自動出力）'!N20","v":1}]
["⑭一人当たりの付加価値額（⑫÷⑬）",{"$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を再起動し、「マクロ有効確認」ボタンをクリックしてメッセージボックスが表示されるか確認する"]
[]
[]
[]
["以上"]