{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["ご利用方法","財務データ入力用","計画全体（自動出力）","申請書＜別表３＞（自動出力）","目標確認用（自動出力）","別表3インポート用マクロ","マクロ有効化の手順"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":7,"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":87,"n_cols":23,"rows_kept":87,"cut":false,"hidden":false,"merged":[[2,15,2,16],[2,17,2,21],[3,21,3,22],[4,1,5,2],[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,4,18],[4,19,4,20],[4,21,4,22],[5,5,5,6],[5,7,5,8],[5,9,5,10],[5,11,5,12],[5,13,5,14],[5,15,5,16],[5,17,5,18],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[31,1,33,1],[31,5,31,6],[5,19,5,20],[5,21,5,22],[6,1,6,2],[7,1,16,1],[17,1,17,2],[18,1,25,1],[31,19,31,20],[31,21,31,22],[32,5,32,6],[32,7,32,8],[32,9,32,10],[32,11,32,12],[32,13,32,14],[32,15,32,16],[32,17,32,18],[32,19,32,20],[31,7,31,8],[31,9,31,10],[31,11,31,12],[31,13,31,14],[31,15,31,16],[31,17,31,18],[32,21,32,22],[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,33,22],[34,1,37,1],[34,7,34,8],[34,9,34,10],[34,11,34,12],[34,13,34,14],[34,15,34,16],[37,7,37,8],[37,9,37,10],[37,11,37,12],[37,13,37,14],[36,7,36,8],[36,9,36,10],[36,11,36,12],[36,13,36,14],[36,15,36,16],[34,17,34,18],[34,19,34,20],[34,21,34,22],[35,7,35,8],[35,9,35,10],[35,11,35,12],[35,13,35,14],[35,15,35,16],[35,17,35,18],[35,19,35,20],[35,21,35,22],[36,17,36,18],[36,19,36,20],[36,21,36,22],[37,15,37,16],[37,17,37,18],[37,19,37,20],[37,21,37,22],[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,38,20],[38,21,38,22],[39,5,39,6],[40,21,40,22],[41,1,41,2],[41,5,41,6],[41,7,41,8],[41,9,41,10],[41,11,41,12],[41,13,41,14],[41,15,41,16],[41,17,41,18],[41,19,41,20],[41,21,41,22],[43,21,43,22],[45,1,45,3],[45,21,45,22],[42,15,42,16],[42,17,42,18],[42,19,42,20],[42,21,42,22],[43,1,43,2],[43,5,43,6],[43,7,43,8],[43,9,43,10],[43,11,43,12],[43,13,43,14],[42,1,42,2],[42,5,42,6],[42,7,42,8],[42,9,42,10],[42,11,42,12],[42,13,42,14],[43,15,43,16],[43,17,43,18],[43,19,43,20],[47,21,47,22],[48,1,48,2],[49,1,58,1],[59,1,59,2],[60,1,67,1],[68,1,68,2],[46,17,46,18],[46,19,46,20],[46,21,46,22],[47,7,47,8],[47,9,47,10],[47,11,47,12],[47,13,47,14],[47,15,47,16],[47,17,47,18],[47,19,47,20],[46,1,47,2],[46,7,46,8],[46,9,46,10],[46,11,46,12],[46,13,46,14],[46,15,46,16],[69,1,69,2],[70,1,70,2],[72,1,76,1],[72,7,72,8],[72,9,72,10],[72,11,72,12],[76,7,76,8],[76,9,76,10],[76,11,76,12],[74,7,74,8],[74,9,74,10],[74,11,74,12],[72,13,72,14],[72,15,72,16],[72,17,72,18],[72,19,72,20],[72,21,72,22],[73,7,73,8],[73,9,73,10],[73,11,73,12],[73,13,73,14],[73,15,73,16],[73,17,73,18],[73,19,73,20],[73,21,73,22],[74,13,74,14],[74,15,74,16],[74,17,74,18],[74,19,74,20],[74,21,74,22],[75,7,75,8],[75,9,75,10],[75,11,75,12],[75,13,75,14],[75,15,75,16],[75,17,75,18],[75,19,75,20],[75,21,75,22],[76,13,76,14],[76,15,76,16],[76,17,76,18],[76,19,76,20],[76,21,76,22],[77,1,81,1],[77,7,77,8],[77,9,77,10],[77,11,77,12],[77,13,77,14],[77,15,77,16],[77,17,77,18],[77,19,77,20],[77,21,77,22],[78,7,78,8],[78,9,78,10],[78,11,78,12],[78,13,78,14],[78,15,78,16],[78,17,78,18],[78,19,78,20],[78,21,78,22],[79,7,79,8],[79,9,79,10],[79,11,79,12],[79,13,79,14],[79,15,79,16],[79,17,79,18],[79,19,79,20],[79,21,79,22],[80,19,80,20],[80,21,80,22],[81,7,81,8],[81,9,81,10],[81,11,81,12],[81,13,81,14],[81,15,81,16],[81,17,81,18],[81,19,81,20],[81,21,81,22],[80,7,80,8],[80,9,80,10],[80,11,80,12],[80,13,80,14],[80,15,80,16],[80,17,80,18],[82,5,82,6],[83,21,83,22],[84,1,84,2],[84,5,84,6],[84,7,84,8],[84,9,84,10],[84,11,84,12],[84,13,84,14],[84,15,84,16],[84,17,84,18],[84,19,84,20],[84,21,84,22],[86,21,86,22],[85,19,85,20],[85,21,85,22],[86,1,86,2],[86,5,86,6],[86,7,86,8],[86,9,86,10],[86,11,86,12],[86,13,86,14],[86,15,86,16],[86,17,86,18],[85,1,85,2],[85,5,85,6],[85,7,85,8],[85,9,85,10],[85,11,85,12],[85,13,85,14],[85,15,85,16],[85,17,85,18],[86,19,86,20]]}
[null,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,null,null,null,null,"企業名"]
[null,"【既存事業の売上計画等】",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(単位：千円）"]
[null,null,null,"２年前","１年前","直近期末",null,"１年後",null,"２年後",null,"３年後",null,"４年後",null,"５年後",null,"６年後",null,"７年後",null,"８年後"]
[null,null,null,"( 年 月期)","( 年 月期)","( 年 月期)",null,"( 年 月期)",null,"( 年 月期)",null,"( 年 月期)",null,"( 年 月期)",null,"( 年 月期)",null,"( 年 月期)",null,"( 年 月期)",null,"( 年 月期)"]
[null,"売上高",null,null,null,null,100,null,100,null,100,null,100,null,100,null,100,null,100,null,100,null,100]
[null,"売上原価","商品・材料費",null,null,null,{"$f":"IF(F$7=0,\"－\",IF(F8=0,\"－\",F8/F$7*100))","v":"－"},null,{"$f":"IF(H$7=0,\"－\",IF(H8=0,\"－\",H8/H$7*100))","v":"－"},null,{"$f":"IF(J$7=0,\"－\",IF(J8=0,\"－\",J8/J$7*100))","v":"－"},null,{"$f":"IF(L$7=0,\"－\",IF(L8=0,\"－\",L8/L$7*100))","v":"－"},null,{"$f":"IF(N$7=0,\"－\",IF(N8=0,\"－\",N8/N$7*100))","v":"－"},null,{"$f":"IF(P$7=0,\"－\",IF(P8=0,\"－\",P8/P$7*100))","v":"－"},null,{"$f":"IF(R$7=0,\"－\",IF(R8=0,\"－\",R8/R$7*100))","v":"－"},null,{"$f":"IF(T$7=0,\"－\",IF(T8=0,\"－\",T8/T$7*100))","v":"－"},null,{"$f":"IF(V$7=0,\"－\",IF(V8=0,\"－\",V8/V$7*100))","v":"－"}]
[null,null,"外注費",null,null,null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－"]
[null,null,"労務給与・賃金等",null,null,null,{"$f":"IF(F$7=0,\"－\",IF(F10=0,\"－\",F10/F$7*100))","v":"－"},null,{"$f":"IF(H$7=0,\"－\",IF(H10=0,\"－\",H10/H$7*100))","v":"－"},null,{"$f":"IF(J$7=0,\"－\",IF(J10=0,\"－\",J10/J$7*100))","v":"－"},null,{"$f":"IF(L$7=0,\"－\",IF(L10=0,\"－\",L10/L$7*100))","v":"－"},null,{"$f":"IF(N$7=0,\"－\",IF(N10=0,\"－\",N10/N$7*100))","v":"－"},null,{"$f":"IF(P$7=0,\"－\",IF(P10=0,\"－\",P10/P$7*100))","v":"－"},null,{"$f":"IF(R$7=0,\"－\",IF(R10=0,\"－\",R10/R$7*100))","v":"－"},null,{"$f":"IF(T$7=0,\"－\",IF(T10=0,\"－\",T10/T$7*100))","v":"－"},null,{"$f":"IF(V$7=0,\"－\",IF(V10=0,\"－\",V10/V$7*100))","v":"－"}]
[null,null,"福利厚生費・退職金等",null,null,null,{"$f":"IF(F$7=0,\"－\",IF(F11=0,\"－\",F11/F$7*100))","v":"－"},null,{"$f":"IF(H$7=0,\"－\",IF(H11=0,\"－\",H11/H$7*100))","v":"－"},null,{"$f":"IF(J$7=0,\"－\",IF(J11=0,\"－\",J11/J$7*100))","v":"－"},null,{"$f":"IF(L$7=0,\"－\",IF(L11=0,\"－\",L11/L$7*100))","v":"－"},null,{"$f":"IF(N$7=0,\"－\",IF(N11=0,\"－\",N11/N$7*100))","v":"－"},null,{"$f":"IF(P$7=0,\"－\",IF(P11=0,\"－\",P11/P$7*100))","v":"－"},null,{"$f":"IF(R$7=0,\"－\",IF(R11=0,\"－\",R11/R$7*100))","v":"－"},null,{"$f":"IF(T$7=0,\"－\",IF(T11=0,\"－\",T11/T$7*100))","v":"－"},null,{"$f":"IF(V$7=0,\"－\",IF(V11=0,\"－\",V11/V$7*100))","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,"－",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":"D17-(D8+D9+D10+D11+D12+D13+D14+D15)","v":0},{"$f":"E17-(E8+E9+E10+E11+E12+E13+E14+E15)","v":0},{"$f":"F17-(F8+F9+F10+F11+F12+F13+F14+F15)","v":0},"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－"]
[null,null," 計",null,null,null,{"$f":"IF(F$7=0,\"－\",IF(F17=0,\"－\",F17/F$7*100))","v":"－"},{"$f":"SUM(H8:H16)","v":0},{"$f":"IF(H$7=0,\"－\",IF(H17=0,\"－\",H17/H$7*100))","v":"－"},{"$f":"SUM(J8:J16)","v":0},{"$f":"IF(J$7=0,\"－\",IF(J17=0,\"－\",J17/J$7*100))","v":"－"},{"$f":"SUM(L8:L16)","v":0},{"$f":"IF(L$7=0,\"－\",IF(L17=0,\"－\",L17/L$7*100))","v":"－"},{"$f":"SUM(N8:N16)","v":0},{"$f":"IF(N$7=0,\"－\",IF(N17=0,\"－\",N17/N$7*100))","v":"－"},{"$f":"SUM(P8:P16)","v":0},{"$f":"IF(P$7=0,\"－\",IF(P17=0,\"－\",P17/P$7*100))","v":"－"},{"$f":"SUM(R8:R16)","v":0},{"$f":"IF(R$7=0,\"－\",IF(R17=0,\"－\",R17/R$7*100))","v":"－"},{"$f":"SUM(T8:T16)","v":0},{"$f":"IF(T$7=0,\"－\",IF(T17=0,\"－\",T17/T$7*100))","v":"－"},{"$f":"SUM(V8:V16)","v":0},"－"]
[null,"売上総利益",null,{"$f":"D7-D17","v":0},{"$f":"E7-E17","v":0},{"$f":"F7-F17","v":0},{"$f":"IF(F$7=0,\"－\",IF(F18<=0,\"－\",F18/F$7*100))","v":"－"},{"$f":"H7-H17","v":0},{"$f":"IF(H$7=0,\"－\",IF(H18<=0,\"－\",H18/H$7*100))","v":"－"},{"$f":"J7-J17","v":0},{"$f":"IF(J$7=0,\"－\",IF(J18<=0,\"－\",J18/J$7*100))","v":"－"},{"$f":"L7-L17","v":0},{"$f":"IF(L$7=0,\"－\",IF(L18<=0,\"－\",L18/L$7*100))","v":"－"},{"$f":"N7-N17","v":0},{"$f":"IF(N$7=0,\"－\",IF(N18<=0,\"－\",N18/N$7*100))","v":"－"},{"$f":"P7-P17","v":0},{"$f":"IF(P$7=0,\"－\",IF(P18<=0,\"－\",P18/P$7*100))","v":"－"},{"$f":"R7-R17","v":0},{"$f":"IF(R$7=0,\"－\",IF(R18<=0,\"－\",R18/R$7*100))","v":"－"},{"$f":"T7-T17","v":0},{"$f":"IF(T$7=0,\"－\",IF(T18<=0,\"－\",T18/T$7*100))","v":"－"},{"$f":"V7-V17","v":0},{"$f":"IF(V$7=0,\"－\",IF(V18<=0,\"－\",V18/V$7*100))","v":"－"}]
[null,"販売費及び一般管理費","役員報酬・給与等",null,null,null,{"$f":"IF(F$7=0,\"－\",IF(F19=0,\"－\",F19/F$7*100))","v":"－"},null,{"$f":"IF(H$7=0,\"－\",IF(H19=0,\"－\",H19/H$7*100))","v":"－"},null,{"$f":"IF(J$7=0,\"－\",IF(J19=0,\"－\",J19/J$7*100))","v":"－"},null,{"$f":"IF(L$7=0,\"－\",IF(L19=0,\"－\",L19/L$7*100))","v":"－"},null,{"$f":"IF(N$7=0,\"－\",IF(N19=0,\"－\",N19/N$7*100))","v":"－"},null,{"$f":"IF(P$7=0,\"－\",IF(P19=0,\"－\",P19/P$7*100))","v":"－"},null,{"$f":"IF(R$7=0,\"－\",IF(R19=0,\"－\",R19/R$7*100))","v":"－"},null,{"$f":"IF(T$7=0,\"－\",IF(T19=0,\"－\",T19/T$7*100))","v":"－"},null,{"$f":"IF(V$7=0,\"－\",IF(V19=0,\"－\",V19/V$7*100))","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,"－",null,"－",null,"－"]
[null,null,"減価償却費(特別)",null,null,null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－"]
[null,null,"賃借料(地代・家賃を除く)",null,null,null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－"]
[null,null,"リース料",null,null,null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－"]
[null,null,"上記以外",{"$f":"D26-(D19+D20+D21+D22+D23+D24)","v":0},{"$f":"E26-(E19+E20+E21+E22+E23+E24)","v":0},{"$f":"F26-(F19+F20+F21+F22+F23+F24)","v":0},"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－"]
[null,null," 計",null,null,null,"－",{"$f":"SUM(H19:H25)","v":0},"－",{"$f":"SUM(J19:J25)","v":0},"－",{"$f":"SUM(L19:L25)","v":0},"－",{"$f":"SUM(N19:N25)","v":0},"－",{"$f":"SUM(P19:P25)","v":0},"－",{"$f":"SUM(R19:R25)","v":0},"－",{"$f":"SUM(T19:T25)","v":0},"－",{"$f":"SUM(V19:V25)","v":0},"－"]
[null,"営業利益",null,{"$f":"D18-D26","v":0},{"$f":"E18-E26","v":0},{"$f":"F18-F26","v":0},{"$f":"IF(F$7=0,\"－\",IF(F27<=0,\"－\",F27/F$7*100))","v":"－"},{"$f":"H18-H26","v":0},{"$f":"IF(H$7=0,\"－\",IF(H27<=0,\"－\",H27/H$7*100))","v":"－"},{"$f":"J18-J26","v":0},{"$f":"IF(J$7=0,\"－\",IF(J27<=0,\"－\",J27/J$7*100))","v":"－"},{"$f":"L18-L26","v":0},{"$f":"IF(L$7=0,\"－\",IF(L27<=0,\"－\",L27/L$7*100))","v":"－"},{"$f":"N18-N26","v":0},{"$f":"IF(N$7=0,\"－\",IF(N27<=0,\"－\",N27/N$7*100))","v":"－"},{"$f":"P18-P26","v":0},{"$f":"IF(P$7=0,\"－\",IF(P27<=0,\"－\",P27/P$7*100))","v":"－"},{"$f":"R18-R26","v":0},{"$f":"IF(R$7=0,\"－\",IF(R27<=0,\"－\",R27/R$7*100))","v":"－"},{"$f":"T18-T26","v":0},{"$f":"IF(T$7=0,\"－\",IF(T27<=0,\"－\",T27/T$7*100))","v":"－"},{"$f":"V18-V26","v":0},{"$f":"IF(V$7=0,\"－\",IF(V27<=0,\"－\",V27/V$7*100))","v":"－"}]
[null,"営業外収益",null,null,null,null,{"$f":"IF(F$7=0,\"－\",IF(F28=0,\"－\",F28/F$7*100))","v":"－"},null,{"$f":"IF(H$7=0,\"－\",IF(H28=0,\"－\",H28/H$7*100))","v":"－"},null,{"$f":"IF(J$7=0,\"－\",IF(J28=0,\"－\",J28/J$7*100))","v":"－"},null,{"$f":"IF(L$7=0,\"－\",IF(L28=0,\"－\",L28/L$7*100))","v":"－"},null,{"$f":"IF(N$7=0,\"－\",IF(N28=0,\"－\",N28/N$7*100))","v":"－"},null,{"$f":"IF(P$7=0,\"－\",IF(P28=0,\"－\",P28/P$7*100))","v":"－"},null,{"$f":"IF(R$7=0,\"－\",IF(R28=0,\"－\",R28/R$7*100))","v":"－"},null,{"$f":"IF(T$7=0,\"－\",IF(T28=0,\"－\",T28/T$7*100))","v":"－"},null,{"$f":"IF(V$7=0,\"－\",IF(V28=0,\"－\",V28/V$7*100))","v":"－"}]
[null,"営業外費用",null,null,null,null,{"$f":"IF(F$7=0,\"－\",IF(F29=0,\"－\",F29/F$7*100))","v":"－"},null,{"$f":"IF(H$7=0,\"－\",IF(H29=0,\"－\",H29/H$7*100))","v":"－"},null,{"$f":"IF(J$7=0,\"－\",IF(J29=0,\"－\",J29/J$7*100))","v":"－"},null,{"$f":"IF(L$7=0,\"－\",IF(L29=0,\"－\",L29/L$7*100))","v":"－"},null,{"$f":"IF(N$7=0,\"－\",IF(N29=0,\"－\",N29/N$7*100))","v":"－"},null,{"$f":"IF(P$7=0,\"－\",IF(P29=0,\"－\",P29/P$7*100))","v":"－"},null,{"$f":"IF(R$7=0,\"－\",IF(R29=0,\"－\",R29/R$7*100))","v":"－"},null,{"$f":"IF(T$7=0,\"－\",IF(T29=0,\"－\",T29/T$7*100))","v":"－"},null,{"$f":"IF(V$7=0,\"－\",IF(V29=0,\"－\",V29/V$7*100))","v":"－"}]
[null,"経常利益",null,null,null,null,{"$f":"IF(F$7=0,\"－\",IF(F30<=0,\"－\",F30/F$7*100))","v":"－"},{"$f":"H27+H28-H29","v":0},{"$f":"IF(H$7=0,\"－\",IF(H30<=0,\"－\",H30/H$7*100))","v":"－"},{"$f":"J27+J28-J29","v":0},{"$f":"IF(J$7=0,\"－\",IF(J30<=0,\"－\",J30/J$7*100))","v":"－"},{"$f":"L27+L28-L29","v":0},{"$f":"IF(L$7=0,\"－\",IF(L30<=0,\"－\",L30/L$7*100))","v":"－"},{"$f":"N27+N28-N29","v":0},{"$f":"IF(N$7=0,\"－\",IF(N30<=0,\"－\",N30/N$7*100))","v":"－"},{"$f":"P27+P28-P29","v":0},{"$f":"IF(P$7=0,\"－\",IF(P30<=0,\"－\",P30/P$7*100))","v":"－"},{"$f":"R27+R28-R29","v":0},{"$f":"IF(R$7=0,\"－\",IF(R30<=0,\"－\",R30/R$7*100))","v":"－"},{"$f":"T27+T28-T29","v":0},{"$f":"IF(T$7=0,\"－\",IF(T30<=0,\"－\",T30/T$7*100))","v":"－"},{"$f":"V27+V28-V29","v":0},{"$f":"IF(V$7=0,\"－\",IF(V30<=0,\"－\",V30/V$7*100))","v":"－"}]
[null,"■資金計画（既存事業）"]
[null,"必要資金","運転資金",{"$f":"ROUND((D17+D26)/12,-2)","v":0},{"$f":"ROUND((E17+E26)/12,-2)","v":0},{"$f":"ROUND((F17+F26)/12,-2)","v":0},null,{"$f":"ROUND((H17+H26)/12,-2)","v":0},null,{"$f":"ROUND((J17+J26)/12,-2)","v":0},null,{"$f":"ROUND((L17+L26)/12,-2)","v":0},null,{"$f":"ROUND((N17+N26)/12,-2)","v":0},null,{"$f":"ROUND((P17+P26)/12,-2)","v":0},null,{"$f":"ROUND((R17+R26)/12,-2)","v":0},null,{"$f":"ROUND((T17+T26)/12,-2)","v":0},null,{"$f":"ROUND((V17+V26)/12,-2)","v":0}]
[null,null,"設備投資額(税込み)",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,"計",{"$f":"SUM(D32:D33)","v":0},{"$f":"SUM(E32:E33)","v":0},{"$f":"SUM(F32:F33)","v":0},null,{"$f":"SUM(H32:H33)","v":0},null,{"$f":"SUM(J32:J33)","v":0},null,{"$f":"SUM(L32:L33)","v":0},null,{"$f":"SUM(N32:N33)","v":0},null,{"$f":"SUM(P32:P33)","v":0},null,{"$f":"SUM(R32:R33)","v":0},null,{"$f":"SUM(T32:T33)","v":0},null,{"$f":"SUM(V32:V33)","v":0}]
[null,"資金調達額","政府系金融機関"]
[null,null,"民間金融機関"]
[null,null,"自己資金"]
[null,null,"その他"]
[null,null,"計",null,null,null,null,{"$f":"SUM(H35:H38)","v":0},null,{"$f":"SUM(J35:J38)","v":0},null,{"$f":"SUM(L35:L38)","v":0},null,{"$f":"SUM(N35:N38)","v":0},null,{"$f":"SUM(P35:P38)","v":0},null,{"$f":"SUM(R35:R38)","v":0},null,{"$f":"SUM(T35:T38)","v":0},null,{"$f":"SUM(V35:V38)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(H39=H34,\" \",\"エラー\")","v":" "},null,{"$f":"IF(J39=J34,\" \",\"エラー\")","v":" "},null,{"$f":"IF(L39=L34,\" \",\"エラー\")","v":" "},null,{"$f":"IF(N39=N34,\" \",\"エラー\")","v":" "},null,{"$f":"IF(P39=P34,\" \",\"エラー\")","v":" "},null,{"$f":"IF(R39=R34,\" \",\"エラー\")","v":" "},null,{"$f":"IF(T39=T34,\" \",\"エラー\")","v":" "},null,{"$f":"IF(V39=V34,\" \",\"エラー\")","v":" "}]
[null,"■人員配分（既存事業）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（単位：人）"]
[null,"労務給与・賃金等\n対象人数 （換算値）　 "]
[null,"役員報酬・給与等\n対象人数（換算値）　"]
[null,"計",null,{"$f":"ROUND((D42+D43),1)","v":0},{"$f":"ROUND((E42+E43),1)","v":0},{"$f":"ROUND((F42+F43),1)","v":0},{"$f":"ROUND((#REF!+#REF!+#REF!),1)","v":{"$error":"#REF!"}},{"$f":"ROUND((H42+H43),1)","v":0},{"$f":"ROUND((#REF!+#REF!+#REF!),1)","v":{"$error":"#REF!"}},{"$f":"ROUND((J42+J43),1)","v":0},{"$f":"ROUND((#REF!+#REF!+#REF!),1)","v":{"$error":"#REF!"}},{"$f":"ROUND((L42+L43),1)","v":0},{"$f":"ROUND((#REF!+#REF!+#REF!),1)","v":{"$error":"#REF!"}},{"$f":"ROUND((N42+N43),1)","v":0},{"$f":"ROUND((#REF!+#REF!+#REF!),1)","v":{"$error":"#REF!"}},{"$f":"ROUND((P42+P43),1)","v":0},{"$f":"ROUND((#REF!+#REF!+#REF!),1)","v":{"$error":"#REF!"}},{"$f":"ROUND((R42+R43),1)","v":0},{"$f":"ROUND((#REF!+#REF!+#REF!),1)","v":{"$error":"#REF!"}},{"$f":"ROUND((T42+T43),1)","v":0},{"$f":"ROUND((#REF!+#REF!+#REF!),1)","v":{"$error":"#REF!"}},{"$f":"ROUND((V42+V43),1)","v":0},{"$f":"ROUND((#REF!+#REF!+#REF!),1)","v":{"$error":"#REF!"}}]
[]
[null,"【新事業の売上計画等】",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(単位：千円）"]
[null,null,null,null,null,null,null,"１年後",null,"２年後",null,"３年後",null,"４年後",null,"５年後",null,"６年後",null,"７年後",null,"８年後"]
[null,null,null,null,null,null,null,{"$f":"H6","v":"( 年 月期)"},null,{"$f":"J6","v":"( 年 月期)"},null,{"$f":"L6","v":"( 年 月期)"},null,{"$f":"N6","v":"( 年 月期)"},null,{"$f":"P6","v":"( 年 月期)"},null,{"$f":"R6","v":"( 年 月期)"},null,{"$f":"T6","v":"( 年 月期)"},null,{"$f":"V6","v":"( 年 月期)"}]
[null,"売上高",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(H$49=0,\"－\",IF(H50=0,\"－\",H50/H$49*100))","v":"－"},null,{"$f":"IF(J$49=0,\"－\",IF(J50=0,\"－\",J50/J$49*100))","v":"－"},null,{"$f":"IF(L$49=0,\"－\",IF(L50=0,\"－\",L50/L$49*100))","v":"－"},null,{"$f":"IF(N$49=0,\"－\",IF(N50=0,\"－\",N50/N$49*100))","v":"－"},null,{"$f":"IF(P$49=0,\"－\",IF(P50=0,\"－\",P50/P$49*100))","v":"－"},null,{"$f":"IF(R$49=0,\"－\",IF(R50=0,\"－\",R50/R$49*100))","v":"－"},null,{"$f":"IF(T$49=0,\"－\",IF(T50=0,\"－\",T50/T$49*100))","v":"－"},null,{"$f":"IF(V$49=0,\"－\",IF(V50=0,\"－\",V50/V$49*100))","v":"－"}]
[null,null,"外注費",null,null,null,null,null,{"$f":"IF(H$49=0,\"－\",IF(H51=0,\"－\",H51/H$49*100))","v":"－"},null,{"$f":"IF(J$49=0,\"－\",IF(J51=0,\"－\",J51/J$49*100))","v":"－"},null,"－",null,{"$f":"IF(N$49=0,\"－\",IF(N51=0,\"－\",N51/N$49*100))","v":"－"},null,"－",null,"－",null,"－",null,"－"]
[null,null,"労務給与・賃金等",null,null,null,null,null,{"$f":"IF(H$49=0,\"－\",IF(H52=0,\"－\",H52/H$49*100))","v":"－"},null,{"$f":"IF(J$49=0,\"－\",IF(J52=0,\"－\",J52/J$49*100))","v":"－"},null,{"$f":"IF(L$49=0,\"－\",IF(L52=0,\"－\",L52/L$49*100))","v":"－"},null,{"$f":"IF(N$49=0,\"－\",IF(N52=0,\"－\",N52/N$49*100))","v":"－"},null,{"$f":"IF(P$49=0,\"－\",IF(P52=0,\"－\",P52/P$49*100))","v":"－"},null,{"$f":"IF(R$49=0,\"－\",IF(R52=0,\"－\",R52/R$49*100))","v":"－"},null,{"$f":"IF(T$49=0,\"－\",IF(T52=0,\"－\",T52/T$49*100))","v":"－"},null,{"$f":"IF(V$49=0,\"－\",IF(V52=0,\"－\",V52/V$49*100))","v":"－"}]
[null,null,"福利厚生費・退職金等",null,null,null,null,null,{"$f":"IF(H$49=0,\"－\",IF(H53=0,\"－\",H53/H$49*100))","v":"－"},null,{"$f":"IF(J$49=0,\"－\",IF(J53=0,\"－\",J53/J$49*100))","v":"－"},null,{"$f":"IF(L$49=0,\"－\",IF(L53=0,\"－\",L53/L$49*100))","v":"－"},null,{"$f":"IF(N$49=0,\"－\",IF(N53=0,\"－\",N53/N$49*100))","v":"－"},null,{"$f":"IF(P$49=0,\"－\",IF(P53=0,\"－\",P53/P$49*100))","v":"－"},null,{"$f":"IF(R$49=0,\"－\",IF(R53=0,\"－\",R53/R$49*100))","v":"－"},null,{"$f":"IF(T$49=0,\"－\",IF(T53=0,\"－\",T53/T$49*100))","v":"－"},null,{"$f":"IF(V$49=0,\"－\",IF(V53=0,\"－\",V53/V$49*100))","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,"－",null,"－",null,"－",null,"－",null,"－"]
[null,null,"賃借料(地代・家賃を除く)",null,null,null,null,null,{"$f":"IF(H$49=0,\"－\",IF(H56=0,\"－\",H56/H$49*100))","v":"－"},null,{"$f":"IF(J$49=0,\"－\",IF(J56=0,\"－\",J56/J$49*100))","v":"－"},null,{"$f":"IF(L$49=0,\"－\",IF(L56=0,\"－\",L56/L$49*100))","v":"－"},null,{"$f":"IF(N$49=0,\"－\",IF(N56=0,\"－\",N56/N$49*100))","v":"－"},null,{"$f":"IF(P$49=0,\"－\",IF(P56=0,\"－\",P56/P$49*100))","v":"－"},null,{"$f":"IF(R$49=0,\"－\",IF(R56=0,\"－\",R56/R$49*100))","v":"－"},null,{"$f":"IF(T$49=0,\"－\",IF(T56=0,\"－\",T56/T$49*100))","v":"－"},null,{"$f":"IF(V$49=0,\"－\",IF(V56=0,\"－\",V56/V$49*100))","v":"－"}]
[null,null,"リース料",null,null,null,null,null,{"$f":"IF(H$49=0,\"－\",IF(H57=0,\"－\",H57/H$49*100))","v":"－"},null,{"$f":"IF(J$49=0,\"－\",IF(J57=0,\"－\",J57/J$49*100))","v":"－"},null,{"$f":"IF(L$49=0,\"－\",IF(L57=0,\"－\",L57/L$49*100))","v":"－"},null,{"$f":"IF(N$49=0,\"－\",IF(N57=0,\"－\",N57/N$49*100))","v":"－"},null,{"$f":"IF(P$49=0,\"－\",IF(P57=0,\"－\",P57/P$49*100))","v":"－"},null,{"$f":"IF(R$49=0,\"－\",IF(R57=0,\"－\",R57/R$49*100))","v":"－"},null,{"$f":"IF(T$49=0,\"－\",IF(T57=0,\"－\",T57/T$49*100))","v":"－"},null,{"$f":"IF(V$49=0,\"－\",IF(V57=0,\"－\",V57/V$49*100))","v":"－"}]
[null,null,"上記以外",null,null,null,null,null,"－",null,"－",null,"－",null,"－",null,"－",null,{"$f":"IF(R$49=0,\"－\",IF(R58=0,\"－\",R58/R$49*100))","v":"－"},null,"－",null,"－"]
[null,null," 計",null,null,null,null,{"$f":"SUM(H50:H58)","v":0},"－",{"$f":"SUM(J50:J58)","v":0},"－",{"$f":"SUM(L50:L58)","v":0},"－",{"$f":"SUM(N50:N58)","v":0},"－",{"$f":"SUM(P50:P58)","v":0},"－",{"$f":"SUM(R50:R58)","v":0},{"$f":"IF(R$49=0,\"－\",IF(R59=0,\"－\",R59/R$49*100))","v":"－"},{"$f":"SUM(T50:T58)","v":0},"－",{"$f":"SUM(V50:V58)","v":0},"－"]
[null,"売上総利益",null,null,null,null,null,{"$f":"H49-H59","v":0},{"$f":"IF(H$49=0,\"－\",IF(H60<=0,\"－\",H60/H$49*100))","v":"－"},{"$f":"J49-J59","v":0},{"$f":"IF(J$49=0,\"－\",IF(J60<=0,\"－\",J60/J$49*100))","v":"－"},{"$f":"L49-L59","v":0},{"$f":"IF(L$49=0,\"－\",IF(L60<=0,\"－\",L60/L$49*100))","v":"－"},{"$f":"N49-N59","v":0},{"$f":"IF(N$49=0,\"－\",IF(N60<=0,\"－\",N60/N$49*100))","v":"－"},{"$f":"P49-P59","v":0},{"$f":"IF(P$49=0,\"－\",IF(P60<=0,\"－\",P60/P$49*100))","v":"－"},{"$f":"R49-R59","v":0},{"$f":"IF(R$49=0,\"－\",IF(R60<=0,\"－\",R60/R$49*100))","v":"－"},{"$f":"T49-T59","v":0},{"$f":"IF(T$49=0,\"－\",IF(T60<=0,\"－\",T60/T$49*100))","v":"－"},{"$f":"V49-V59","v":0},{"$f":"IF(V$49=0,\"－\",IF(V60<=0,\"－\",V60/V$49*100))","v":"－"}]
[null,"販売費及び一般管理費","給与等",null,null,null,null,null,{"$f":"IF(H$49=0,\"－\",IF(H61=0,\"－\",H61/H$49*100))","v":"－"},null,{"$f":"IF(J$49=0,\"－\",IF(J61=0,\"－\",J61/J$49*100))","v":"－"},null,{"$f":"IF(L$49=0,\"－\",IF(L61=0,\"－\",L61/L$49*100))","v":"－"},null,{"$f":"IF(N$49=0,\"－\",IF(N61=0,\"－\",N61/N$49*100))","v":"－"},null,{"$f":"IF(P$49=0,\"－\",IF(P61=0,\"－\",P61/P$49*100))","v":"－"},null,{"$f":"IF(R$49=0,\"－\",IF(R61=0,\"－\",R61/R$49*100))","v":"－"},null,{"$f":"IF(T$49=0,\"－\",IF(T61=0,\"－\",T61/T$49*100))","v":"－"},null,{"$f":"IF(V$49=0,\"－\",IF(V61=0,\"－\",V61/V$49*100))","v":"－"}]
[null,null,"福利厚生費・退職金等",null,null,null,null,null,"－",null,{"$f":"IF(J$49=0,\"－\",IF(J62=0,\"－\",J62/J$49*100))","v":"－"},null,{"$f":"IF(L$49=0,\"－\",IF(L62=0,\"－\",L62/L$49*100))","v":"－"},null,{"$f":"IF(N$49=0,\"－\",IF(N62=0,\"－\",N62/N$49*100))","v":"－"},null,{"$f":"IF(P$49=0,\"－\",IF(P62=0,\"－\",P62/P$49*100))","v":"－"},null,{"$f":"IF(R$49=0,\"－\",IF(R62=0,\"－\",R62/R$49*100))","v":"－"},null,{"$f":"IF(T$49=0,\"－\",IF(T62=0,\"－\",T62/T$49*100))","v":"－"},null,{"$f":"IF(V$49=0,\"－\",IF(V62=0,\"－\",V62/V$49*100))","v":"－"}]
[null,null,"減価償却費(普通)",null,null,null,null,null,"－",null,"－",null,"－",null,"－",null,"－",null,{"$f":"IF(R$49=0,\"－\",IF(R63=0,\"－\",R63/R$49*100))","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,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－"]
[null,null,"リース料",null,null,null,null,null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－"]
[null,null,"上記以外",null,null,null,null,null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－"]
[null,null,"計",null,null,null,null,{"$f":"SUM(H61:H67)","v":0},"－",{"$f":"SUM(J61:J67)","v":0},"－",{"$f":"SUM(L61:L67)","v":0},"－",{"$f":"SUM(N61:N67)","v":0},"－",{"$f":"SUM(P61:P67)","v":0},"－",{"$f":"SUM(R61:R67)","v":0},"－",{"$f":"SUM(T61:T67)","v":0},"－",{"$f":"SUM(V61:V67)","v":0},"－"]
[null,"営業利益",null,null,null,null,null,{"$f":"H60-H68","v":0},{"$f":"IF(H$49=0,\"－\",IF(H69<=0,\"－\",H69/H$49*100))","v":"－"},{"$f":"J60-J68","v":0},{"$f":"IF(J$49=0,\"－\",IF(J69<=0,\"－\",J69/J$49*100))","v":"－"},{"$f":"L60-L68","v":0},{"$f":"IF(L$49=0,\"－\",IF(L69<=0,\"－\",L69/L$49*100))","v":"－"},{"$f":"N60-N68","v":0},{"$f":"IF(N$49=0,\"－\",IF(N69<=0,\"－\",N69/N$49*100))","v":"－"},{"$f":"P60-P68","v":0},{"$f":"IF(P$49=0,\"－\",IF(P69<=0,\"－\",P69/P$49*100))","v":"－"},{"$f":"R60-R68","v":0},{"$f":"IF(R$49=0,\"－\",IF(R69<=0,\"－\",R69/R$49*100))","v":"－"},{"$f":"T60-T68","v":0},{"$f":"IF(T$49=0,\"－\",IF(T69<=0,\"－\",T69/T$49*100))","v":"－"},{"$f":"V60-V68","v":0},{"$f":"IF(V$49=0,\"－\",IF(V69<=0,\"－\",V69/V$49*100))","v":"－"}]
[null,"営業外費用(支払利息)",null,null,null,null,null,null,{"$f":"IF(H$49=0,\"－\",IF(H70=0,\"－\",H70/H$49*100))","v":"－"},null,{"$f":"IF(J$49=0,\"－\",IF(J70=0,\"－\",J70/J$49*100))","v":"－"},null,{"$f":"IF(L$49=0,\"－\",IF(L70=0,\"－\",L70/L$49*100))","v":"－"},null,{"$f":"IF(N$49=0,\"－\",IF(N70=0,\"－\",N70/N$49*100))","v":"－"},null,{"$f":"IF(P$49=0,\"－\",IF(P70=0,\"－\",P70/P$49*100))","v":"－"},null,{"$f":"IF(R$49=0,\"－\",IF(R70=0,\"－\",R70/R$49*100))","v":"－"},null,{"$f":"IF(T$49=0,\"－\",IF(T70=0,\"－\",T70/T$49*100))","v":"－"},null,{"$f":"IF(V$49=0,\"－\",IF(V70=0,\"－\",V70/V$49*100))","v":"－"}]
[null,"経常利益",null,null,null,null,null,{"$f":"H69-H70","v":0},{"$f":"IF(H$49=0,\"－\",IF(H71<=0,\"－\",H71/H$49*100))","v":"－"},{"$f":"J69-J70","v":0},{"$f":"IF(J$49=0,\"－\",IF(J71<=0,\"－\",J71/J$49*100))","v":"－"},{"$f":"L69-L70","v":0},{"$f":"IF(L$49=0,\"－\",IF(L71<=0,\"－\",L71/L$49*100))","v":"－"},{"$f":"N69-N70","v":0},{"$f":"IF(N$49=0,\"－\",IF(N71<=0,\"－\",N71/N$49*100))","v":"－"},{"$f":"P69-P70","v":0},{"$f":"IF(P$49=0,\"－\",IF(P71<=0,\"－\",P71/P$49*100))","v":"－"},{"$f":"R69-R70","v":0},{"$f":"IF(R$49=0,\"－\",IF(R71<=0,\"－\",R71/R$49*100))","v":"－"},{"$f":"T69-T70","v":0},{"$f":"IF(T$49=0,\"－\",IF(T71<=0,\"－\",T71/T$49*100))","v":"－"},{"$f":"V69-V70","v":0},{"$f":"IF(V$49=0,\"－\",IF(V71<=0,\"－\",V71/V$49*100))","v":"－"}]
[null,"■資金計画（新事業）"]
[null,"必要資金","運転資金(通常分)",null,null,null,null,{"$f":"ROUND((H59+H68)/12,-2)","v":0},null,{"$f":"ROUND((J59+J68)/12,-2)","v":0},null,{"$f":"ROUND((L59+L68)/12,-2)","v":0},null,{"$f":"ROUND((N59+N68)/12,-2)","v":0},null,{"$f":"ROUND((P59+P68)/12,-2)","v":0},null,{"$f":"ROUND((R59+R68)/12,-2)","v":0},null,{"$f":"ROUND((T59+T68)/12,-2)","v":0},null,{"$f":"ROUND((V59+V68)/12,-2)","v":0}]
[null,null,"運転資金(増加分)"]
[null,null,"運転資金（計）",null,null,null,null,{"$f":"SUM(H73:I74)","v":0},null,{"$f":"SUM(J73:K74)","v":0},null,{"$f":"SUM(L73:M74)","v":0},null,{"$f":"SUM(N73:O74)","v":0},null,{"$f":"SUM(P73:Q74)","v":0},null,{"$f":"SUM(R73:S74)","v":0},null,{"$f":"SUM(T73:U74)","v":0},null,{"$f":"SUM(V73:W74)","v":0}]
[null,null,"設備投資額(税込み)"]
[null,null,"計",null,null,null,null,{"$f":"H75+H76","v":0},null,{"$f":"J75+J76","v":0},null,{"$f":"L75+L76","v":0},null,{"$f":"N75+N76","v":0},null,{"$f":"P75+P76","v":0},null,{"$f":"R75+R76","v":0},null,{"$f":"T75+T76","v":0},null,{"$f":"V75+V76","v":0}]
[null,"資金調達額","政府系金融機関"]
[null,null,"民間金融機関"]
[null,null,"自己資金"]
[null,null,"その他"]
[null,null,"計",null,null,null,null,{"$f":"SUM(H78:H81)","v":0},null,{"$f":"SUM(J78:J81)","v":0},null,{"$f":"SUM(L78:L81)","v":0},null,{"$f":"SUM(N78:N81)","v":0},null,{"$f":"SUM(P78:P81)","v":0},null,{"$f":"SUM(R78:R81)","v":0},null,{"$f":"SUM(T78:T81)","v":0},null,{"$f":"SUM(V78:V81)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(H82=H77,\" \",\"エラー\")","v":" "},null,{"$f":"IF(J82=J77,\" \",\"エラー\")","v":" "},null,{"$f":"IF(L82=L77,\" \",\"エラー\")","v":" "},null,{"$f":"IF(N82=N77,\" \",\"エラー\")","v":" "},null,{"$f":"IF(P82=P77,\" \",\"エラー\")","v":" "},null,{"$f":"IF(R82=R77,\" \",\"エラー\")","v":" "},null,{"$f":"IF(T82=T77,\" \",\"エラー\")","v":" "},null,{"$f":"IF(V82=V77,\" \",\"エラー\")","v":" "}]
[null,"■人員配分（新事業）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（単位：人）"]
[null,"労務給与・賃金等\n対象人数 （換算値）　 "]
[null,"給与等\n対象人数（換算値）　"]
[null,"計",null,null,null,null,null,{"$f":"ROUND((H85+H86),1)","v":0},{"$f":"ROUND((#REF!+#REF!+#REF!),1)","v":{"$error":"#REF!"}},{"$f":"ROUND((J85+J86),1)","v":0},{"$f":"ROUND((#REF!+#REF!+#REF!),1)","v":{"$error":"#REF!"}},{"$f":"ROUND((L85+L86),1)","v":0},{"$f":"ROUND((#REF!+#REF!+#REF!),1)","v":{"$error":"#REF!"}},{"$f":"ROUND((N85+N86),1)","v":0},{"$f":"ROUND((#REF!+#REF!+#REF!),1)","v":{"$error":"#REF!"}},{"$f":"ROUND((P85+P86),1)","v":0},{"$f":"ROUND((#REF!+#REF!+#REF!),1)","v":{"$error":"#REF!"}},{"$f":"ROUND((R85+R86),1)","v":0},{"$f":"ROUND((#REF!+#REF!+#REF!),1)","v":{"$error":"#REF!"}},{"$f":"ROUND((T85+T86),1)","v":0},{"$f":"ROUND((#REF!+#REF!+#REF!),1)","v":{"$error":"#REF!"}},{"$f":"ROUND((V85+V86),1)","v":0},{"$f":"ROUND((#REF!+#REF!+#REF!),1)","v":{"$error":"#REF!"}}]

{"sheet":"計画全体（自動出力）","index":2,"n_rows":53,"n_cols":14,"rows_kept":53,"cut":false,"hidden":false,"merged":[[14,1,14,2],[0,12,0,13],[1,1,1,6],[2,1,3,2],[4,1,4,2],[5,1,13,1],[39,1,39,2],[15,1,15,2],[16,1,22,1],[23,1,23,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],[32,1,35,1],[38,1,38,3],[40,1,40,2],[41,1,41,2],[47,1,47,2],[49,1,49,2],[51,1,51,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":"( 年 月期)"},{"$f":"財務データ入力用!E6","v":"( 年 月期)"},{"$f":"財務データ入力用!F6","v":"( 年 月期)"},{"$f":"財務データ入力用!H6","v":"( 年 月期)"},{"$f":"財務データ入力用!J6","v":"( 年 月期)"},{"$f":"財務データ入力用!L6","v":"( 年 月期)"},{"$f":"財務データ入力用!N6","v":"( 年 月期)"},{"$f":"財務データ入力用!P6","v":"( 年 月期)"},{"$f":"財務データ入力用!R6","v":"( 年 月期)"},{"$f":"財務データ入力用!T6","v":"( 年 月期)"},{"$f":"財務データ入力用!V6","v":"( 年 月期)"}]
[null,"売上高",null,{"$f":"財務データ入力用!D7","v":0},{"$f":"財務データ入力用!E7","v":0},{"$f":"財務データ入力用!F7","v":0},{"$f":"財務データ入力用!H7+財務データ入力用!H49","v":0},{"$f":"ROUND(財務データ入力用!J7,0)+ROUND(財務データ入力用!J49,0)","v":0},{"$f":"ROUND(財務データ入力用!L7,0)+ROUND(財務データ入力用!L49,0)","v":0},{"$f":"ROUND(財務データ入力用!N7,0)+ROUND(財務データ入力用!N49,0)","v":0},{"$f":"ROUND(財務データ入力用!P7,0)+ROUND(財務データ入力用!P49,0)","v":0},{"$f":"ROUND(財務データ入力用!R7,0)+ROUND(財務データ入力用!R49,0)","v":0},{"$f":"ROUND(財務データ入力用!T7,0)+ROUND(財務データ入力用!T49,0)","v":0},{"$f":"ROUND(財務データ入力用!V7,0)+ROUND(財務データ入力用!V49,0)","v":0}]
[null,"売上原価","商品・材料費",{"$f":"ROUND(財務データ入力用!D8,0)","v":0},{"$f":"ROUND(財務データ入力用!E8,0)","v":0},{"$f":"ROUND(財務データ入力用!F8,0)","v":0},{"$f":"ROUND(財務データ入力用!H8,0)+ROUND(財務データ入力用!H50,0)","v":0},{"$f":"ROUND(財務データ入力用!J8,0)+ROUND(財務データ入力用!J50,0)","v":0},{"$f":"ROUND(財務データ入力用!L8,0)+ROUND(財務データ入力用!L50,0)","v":0},{"$f":"ROUND(財務データ入力用!N8,0)+ROUND(財務データ入力用!N50,0)","v":0},{"$f":"ROUND(財務データ入力用!P8,0)+ROUND(財務データ入力用!P50,0)","v":0},{"$f":"ROUND(財務データ入力用!R8,0)+ROUND(財務データ入力用!R50,0)","v":0},{"$f":"ROUND(財務データ入力用!T8,0)+ROUND(財務データ入力用!T50,0)","v":0},{"$f":"ROUND(財務データ入力用!V8,0)+ROUND(財務データ入力用!V50,0)","v":0}]
[null,null,"外注費",{"$f":"ROUND(財務データ入力用!D9,0)","v":0},{"$f":"ROUND(財務データ入力用!E9,0)","v":0},{"$f":"ROUND(財務データ入力用!F9,0)","v":0},{"$f":"ROUND(財務データ入力用!H9,0)+ROUND(財務データ入力用!H51,0)","v":0},{"$f":"ROUND(財務データ入力用!J9,0)+ROUND(財務データ入力用!J51,0)","v":0},{"$f":"ROUND(財務データ入力用!L9,0)+ROUND(財務データ入力用!L51,0)","v":0},{"$f":"ROUND(財務データ入力用!N9,0)+ROUND(財務データ入力用!N51,0)","v":0},{"$f":"ROUND(財務データ入力用!P9,0)+ROUND(財務データ入力用!P51,0)","v":0},{"$f":"ROUND(財務データ入力用!R9,0)+ROUND(財務データ入力用!R51,0)","v":0},{"$f":"ROUND(財務データ入力用!T9,0)+ROUND(財務データ入力用!T51,0)","v":0},{"$f":"ROUND(財務データ入力用!V9,0)+ROUND(財務データ入力用!V51,0)","v":0}]
[null,null,"労務給与・賃金等",{"$f":"ROUND(財務データ入力用!D10,0)","v":0},{"$f":"ROUND(財務データ入力用!E10,0)","v":0},{"$f":"ROUND(財務データ入力用!F10,0)","v":0},{"$f":"ROUND(財務データ入力用!H10,0)+ROUND(財務データ入力用!H52,0)","v":0},{"$f":"ROUND(財務データ入力用!J10,0)+ROUND(財務データ入力用!J52,0)","v":0},{"$f":"ROUND(財務データ入力用!L10,0)+ROUND(財務データ入力用!L52,0)","v":0},{"$f":"ROUND(財務データ入力用!N10,0)+ROUND(財務データ入力用!N52,0)","v":0},{"$f":"ROUND(財務データ入力用!P10,0)+ROUND(財務データ入力用!P52,0)","v":0},{"$f":"ROUND(財務データ入力用!R10,0)+ROUND(財務データ入力用!R52,0)","v":0},{"$f":"ROUND(財務データ入力用!T10,0)+ROUND(財務データ入力用!T52,0)","v":0},{"$f":"ROUND(財務データ入力用!V10,0)+ROUND(財務データ入力用!V52,0)","v":0}]
[null,null,"法定福利費等",{"$f":"ROUND(財務データ入力用!D11,0)","v":0},{"$f":"ROUND(財務データ入力用!E11,0)","v":0},{"$f":"ROUND(財務データ入力用!F11,0)","v":0},{"$f":"ROUND(財務データ入力用!H11,0)+ROUND(財務データ入力用!H53,0)","v":0},{"$f":"ROUND(財務データ入力用!J11,0)+ROUND(財務データ入力用!J53,0)","v":0},{"$f":"ROUND(財務データ入力用!L11,0)+ROUND(財務データ入力用!L53,0)","v":0},{"$f":"ROUND(財務データ入力用!N11,0)+ROUND(財務データ入力用!N53,0)","v":0},{"$f":"ROUND(財務データ入力用!P11,0)+ROUND(財務データ入力用!P53,0)","v":0},{"$f":"ROUND(財務データ入力用!R11,0)+ROUND(財務データ入力用!R53,0)","v":0},{"$f":"ROUND(財務データ入力用!T11,0)+ROUND(財務データ入力用!T53,0)","v":0},{"$f":"ROUND(財務データ入力用!V11,0)+ROUND(財務データ入力用!V53,0)","v":0}]
[null,null,"減価償却費(普通)",{"$f":"ROUND(財務データ入力用!D12,0)","v":0},{"$f":"ROUND(財務データ入力用!E12,0)","v":0},{"$f":"ROUND(財務データ入力用!F12,0)","v":0},{"$f":"ROUND(財務データ入力用!H12,0)+ROUND(財務データ入力用!H54,0)","v":0},{"$f":"ROUND(財務データ入力用!J12,0)+ROUND(財務データ入力用!J54,0)","v":0},{"$f":"ROUND(財務データ入力用!L12,0)+ROUND(財務データ入力用!L54,0)","v":0},{"$f":"ROUND(財務データ入力用!N12,0)+ROUND(財務データ入力用!N54,0)","v":0},{"$f":"ROUND(財務データ入力用!P12,0)+ROUND(財務データ入力用!P54,0)","v":0},{"$f":"ROUND(財務データ入力用!R12,0)+ROUND(財務データ入力用!R54,0)","v":0},{"$f":"ROUND(財務データ入力用!T12,0)+ROUND(財務データ入力用!T54,0)","v":0},{"$f":"ROUND(財務データ入力用!V12,0)+ROUND(財務データ入力用!V54,0)","v":0}]
[null,null,"減価償却費(特別)",{"$f":"ROUND(財務データ入力用!D13,0)","v":0},{"$f":"ROUND(財務データ入力用!E13,0)","v":0},{"$f":"ROUND(財務データ入力用!F13,0)","v":0},{"$f":"ROUND(財務データ入力用!H13,0)+ROUND(財務データ入力用!H55,0)","v":0},{"$f":"ROUND(財務データ入力用!J13,0)+ROUND(財務データ入力用!J55,0)","v":0},{"$f":"ROUND(財務データ入力用!L13,0)+ROUND(財務データ入力用!L55,0)","v":0},{"$f":"ROUND(財務データ入力用!N13,0)+ROUND(財務データ入力用!N55,0)","v":0},{"$f":"ROUND(財務データ入力用!P13,0)+ROUND(財務データ入力用!P55,0)","v":0},{"$f":"ROUND(財務データ入力用!R13,0)+ROUND(財務データ入力用!R55,0)","v":0},{"$f":"ROUND(財務データ入力用!T13,0)+ROUND(財務データ入力用!T55,0)","v":0},{"$f":"ROUND(財務データ入力用!V13,0)+ROUND(財務データ入力用!V55,0)","v":0}]
[null,null,"賃借料(地代・家賃を除く)",{"$f":"ROUND(財務データ入力用!D14,0)","v":0},{"$f":"ROUND(財務データ入力用!E14,0)","v":0},{"$f":"ROUND(財務データ入力用!F14,0)","v":0},{"$f":"ROUND(財務データ入力用!H14,0)+ROUND(財務データ入力用!H56,0)","v":0},{"$f":"ROUND(財務データ入力用!J14,0)+ROUND(財務データ入力用!J56,0)","v":0},{"$f":"ROUND(財務データ入力用!L14,0)+ROUND(財務データ入力用!L56,0)","v":0},{"$f":"ROUND(財務データ入力用!N14,0)+ROUND(財務データ入力用!N56,0)","v":0},{"$f":"ROUND(財務データ入力用!P14,0)+ROUND(財務データ入力用!P56,0)","v":0},{"$f":"ROUND(財務データ入力用!R14,0)+ROUND(財務データ入力用!R56,0)","v":0},{"$f":"ROUND(財務データ入力用!T14,0)+ROUND(財務データ入力用!T56,0)","v":0},{"$f":"ROUND(財務データ入力用!V14,0)+ROUND(財務データ入力用!V56,0)","v":0}]
[null,null,"リース料",{"$f":"ROUND(財務データ入力用!D15,0)","v":0},{"$f":"ROUND(財務データ入力用!E15,0)","v":0},{"$f":"ROUND(財務データ入力用!F15,0)","v":0},{"$f":"財務データ入力用!H15+財務データ入力用!H57","v":0},{"$f":"ROUND(財務データ入力用!J15,0)+ROUND(財務データ入力用!J57,0)","v":0},{"$f":"ROUND(財務データ入力用!L15,0)+ROUND(財務データ入力用!L57,0)","v":0},{"$f":"ROUND(財務データ入力用!N15,0)+ROUND(財務データ入力用!N57,0)","v":0},{"$f":"ROUND(財務データ入力用!P15,0)+ROUND(財務データ入力用!P57,0)","v":0},{"$f":"ROUND(財務データ入力用!R15,0)+ROUND(財務データ入力用!R57,0)","v":0},{"$f":"ROUND(財務データ入力用!T15,0)+ROUND(財務データ入力用!T57,0)","v":0},{"$f":"ROUND(財務データ入力用!V15,0)+ROUND(財務データ入力用!V57,0)","v":0}]
[null,null,"上記以外",{"$f":"ROUND(財務データ入力用!D16,0)","v":0},{"$f":"ROUND(財務データ入力用!E16,0)","v":0},{"$f":"ROUND(財務データ入力用!F16,0)","v":0},{"$f":"財務データ入力用!H16+財務データ入力用!H58","v":0},{"$f":"ROUND(財務データ入力用!J16,0)+ROUND(財務データ入力用!J58,0)","v":0},{"$f":"ROUND(財務データ入力用!L16,0)+ROUND(財務データ入力用!L58,0)","v":0},{"$f":"ROUND(財務データ入力用!N16,0)+ROUND(財務データ入力用!N58,0)","v":0},{"$f":"ROUND(財務データ入力用!P16,0)+ROUND(財務データ入力用!P58,0)","v":0},{"$f":"ROUND(財務データ入力用!R16,0)+ROUND(財務データ入力用!R58,0)","v":0},{"$f":"ROUND(財務データ入力用!T16,0)+ROUND(財務データ入力用!T58,0)","v":0},{"$f":"ROUND(財務データ入力用!V16,0)+ROUND(財務データ入力用!V58,0)","v":0}]
[null,"計",null,{"$f":"ROUND(SUM(D6:D14),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"売上総利益",null,{"$f":"ROUND((D5-D15),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"販売費及び一般管理費","役員報酬・給与等",{"$f":"ROUND((財務データ入力用!D19),0)","v":0},{"$f":"ROUND((財務データ入力用!E19),0)","v":0},{"$f":"ROUND((財務データ入力用!F19),0)","v":0},{"$f":"ROUND(財務データ入力用!H19,0)+ROUND(財務データ入力用!H61,0)","v":0},{"$f":"ROUND(財務データ入力用!J19,0)+ROUND(財務データ入力用!J61,0)","v":0},{"$f":"ROUND(財務データ入力用!L19,0)+ROUND(財務データ入力用!L61,0)","v":0},{"$f":"ROUND(財務データ入力用!N19,0)+ROUND(財務データ入力用!N61,0)","v":0},{"$f":"ROUND(財務データ入力用!P19,0)+ROUND(財務データ入力用!P61,0)","v":0},{"$f":"ROUND(財務データ入力用!R19,0)+ROUND(財務データ入力用!R61,0)","v":0},{"$f":"ROUND(財務データ入力用!T19,0)+ROUND(財務データ入力用!T61,0)","v":0},{"$f":"ROUND(財務データ入力用!V19,0)+ROUND(財務データ入力用!V61,0)","v":0}]
[null,null,"法定福利費等",{"$f":"ROUND((財務データ入力用!D20),0)","v":0},{"$f":"ROUND((財務データ入力用!E20),0)","v":0},{"$f":"ROUND((財務データ入力用!F20),0)","v":0},{"$f":"ROUND(財務データ入力用!H20,0)+ROUND(財務データ入力用!H62,0)","v":0},{"$f":"ROUND(財務データ入力用!J20,0)+ROUND(財務データ入力用!J62,0)","v":0},{"$f":"ROUND(財務データ入力用!L20,0)+ROUND(財務データ入力用!L62,0)","v":0},{"$f":"ROUND(財務データ入力用!N20,0)+ROUND(財務データ入力用!N62,0)","v":0},{"$f":"ROUND(財務データ入力用!P20,0)+ROUND(財務データ入力用!P62,0)","v":0},{"$f":"ROUND(財務データ入力用!R20,0)+ROUND(財務データ入力用!R62,0)","v":0},{"$f":"ROUND(財務データ入力用!T20,0)+ROUND(財務データ入力用!T62,0)","v":0},{"$f":"ROUND(財務データ入力用!V20,0)+ROUND(財務データ入力用!V62,0)","v":0}]
[null,null,"減価償却費(普通)",{"$f":"ROUND((財務データ入力用!D21),0)","v":0},{"$f":"ROUND((財務データ入力用!E21),0)","v":0},{"$f":"ROUND((財務データ入力用!F21),0)","v":0},{"$f":"ROUND(財務データ入力用!H21,0)+ROUND(財務データ入力用!H63,0)","v":0},{"$f":"ROUND(財務データ入力用!J21,0)+ROUND(財務データ入力用!J63,0)","v":0},{"$f":"ROUND(財務データ入力用!L21,0)+ROUND(財務データ入力用!L63,0)","v":0},{"$f":"ROUND(財務データ入力用!N21,0)+ROUND(財務データ入力用!N63,0)","v":0},{"$f":"ROUND(財務データ入力用!P21,0)+ROUND(財務データ入力用!P63,0)","v":0},{"$f":"ROUND(財務データ入力用!R21,0)+ROUND(財務データ入力用!R63,0)","v":0},{"$f":"ROUND(財務データ入力用!T21,0)+ROUND(財務データ入力用!T63,0)","v":0},{"$f":"ROUND(財務データ入力用!V21,0)+ROUND(財務データ入力用!V63,0)","v":0}]
[null,null,"減価償却費(特別)",{"$f":"ROUND((財務データ入力用!D22),0)","v":0},{"$f":"ROUND((財務データ入力用!E22),0)","v":0},{"$f":"ROUND((財務データ入力用!F22),0)","v":0},{"$f":"ROUND(財務データ入力用!H22,0)+ROUND(財務データ入力用!H64,0)","v":0},{"$f":"ROUND(財務データ入力用!J22,0)+ROUND(財務データ入力用!J64,0)","v":0},{"$f":"ROUND(財務データ入力用!L22,0)+ROUND(財務データ入力用!L64,0)","v":0},{"$f":"ROUND(財務データ入力用!N22,0)+ROUND(財務データ入力用!N64,0)","v":0},{"$f":"ROUND(財務データ入力用!P22,0)+ROUND(財務データ入力用!P64,0)","v":0},{"$f":"ROUND(財務データ入力用!R22,0)+ROUND(財務データ入力用!R64,0)","v":0},{"$f":"ROUND(財務データ入力用!T22,0)+ROUND(財務データ入力用!T64,0)","v":0},{"$f":"ROUND(財務データ入力用!V22,0)+ROUND(財務データ入力用!V64,0)","v":0}]
[null,null,"賃借料(地代・家賃を除く)",{"$f":"ROUND((財務データ入力用!D23),0)","v":0},{"$f":"ROUND((財務データ入力用!E23),0)","v":0},{"$f":"ROUND((財務データ入力用!F23),0)","v":0},{"$f":"ROUND(財務データ入力用!H23,0)+ROUND(財務データ入力用!H65,0)","v":0},{"$f":"ROUND(財務データ入力用!J23,0)+ROUND(財務データ入力用!J65,0)","v":0},{"$f":"ROUND(財務データ入力用!L23,0)+ROUND(財務データ入力用!L65,0)","v":0},{"$f":"ROUND(財務データ入力用!N23,0)+ROUND(財務データ入力用!N65,0)","v":0},{"$f":"ROUND(財務データ入力用!P23,0)+ROUND(財務データ入力用!P65,0)","v":0},{"$f":"ROUND(財務データ入力用!R23,0)+ROUND(財務データ入力用!R65,0)","v":0},{"$f":"ROUND(財務データ入力用!T23,0)+ROUND(財務データ入力用!T65,0)","v":0},{"$f":"ROUND(財務データ入力用!V23,0)+ROUND(財務データ入力用!V65,0)","v":0}]
[null,null,"リース料",{"$f":"ROUND((財務データ入力用!D24),0)","v":0},{"$f":"ROUND((財務データ入力用!E24),0)","v":0},{"$f":"ROUND((財務データ入力用!F24),0)","v":0},{"$f":"ROUND(財務データ入力用!H24,0)+ROUND(財務データ入力用!H66,0)","v":0},{"$f":"ROUND(財務データ入力用!J24,0)+ROUND(財務データ入力用!J66,0)","v":0},{"$f":"ROUND(財務データ入力用!L24,0)+ROUND(財務データ入力用!L66,0)","v":0},{"$f":"ROUND(財務データ入力用!N24,0)+ROUND(財務データ入力用!N66,0)","v":0},{"$f":"ROUND(財務データ入力用!P24,0)+ROUND(財務データ入力用!P66,0)","v":0},{"$f":"ROUND(財務データ入力用!R24,0)+ROUND(財務データ入力用!R66,0)","v":0},{"$f":"ROUND(財務データ入力用!T24,0)+ROUND(財務データ入力用!T66,0)","v":0},{"$f":"ROUND(財務データ入力用!V24,0)+ROUND(財務データ入力用!V66,0)","v":0}]
[null,null,"上記以外",{"$f":"ROUND((財務データ入力用!D25),0)","v":0},{"$f":"ROUND((財務データ入力用!E25),0)","v":0},{"$f":"ROUND((財務データ入力用!F25),0)","v":0},{"$f":"ROUND(財務データ入力用!H25,0)+ROUND(財務データ入力用!H67,0)","v":0},{"$f":"ROUND(財務データ入力用!J25,0)+ROUND(財務データ入力用!J67,0)","v":0},{"$f":"ROUND(財務データ入力用!L25,0)+ROUND(財務データ入力用!L67,0)","v":0},{"$f":"ROUND(財務データ入力用!N25,0)+ROUND(財務データ入力用!N67,0)","v":0},{"$f":"ROUND(財務データ入力用!P25,0)+ROUND(財務データ入力用!P67,0)","v":0},{"$f":"ROUND(財務データ入力用!R25,0)+ROUND(財務データ入力用!R67,0)","v":0},{"$f":"ROUND(財務データ入力用!T25,0)+ROUND(財務データ入力用!T67,0)","v":0},{"$f":"ROUND(財務データ入力用!V25,0)+ROUND(財務データ入力用!V67,0)","v":0}]
[null,"計",null,{"$f":"ROUND(SUM(D17:D23),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"営業利益",null,{"$f":"ROUND((D16-D24),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"営業外収益",null,{"$f":"ROUND(財務データ入力用!D28,0)","v":0},{"$f":"ROUND(財務データ入力用!E28,0)","v":0},{"$f":"ROUND(財務データ入力用!F28,0)","v":0},{"$f":"ROUND(財務データ入力用!H28,0)","v":0},{"$f":"ROUND(財務データ入力用!J28,0)","v":0},{"$f":"ROUND(財務データ入力用!L28,0)","v":0},{"$f":"ROUND(財務データ入力用!N28,0)","v":0},{"$f":"ROUND(財務データ入力用!P28,0)","v":0},{"$f":"ROUND(財務データ入力用!R28,0)","v":0},{"$f":"ROUND(財務データ入力用!T28,0)","v":0},{"$f":"ROUND(財務データ入力用!V28,0)","v":0}]
[null,"営業外費用",null,{"$f":"ROUND((財務データ入力用!D29),0)","v":0},{"$f":"ROUND((財務データ入力用!E29),0)","v":0},{"$f":"ROUND((財務データ入力用!F29),0)","v":0},{"$f":"ROUND(財務データ入力用!H29,0)+ROUND(財務データ入力用!H70,0)","v":0},{"$f":"ROUND(財務データ入力用!J29,0)+ROUND(財務データ入力用!J70,0)","v":0},{"$f":"ROUND(財務データ入力用!L29,0)+ROUND(財務データ入力用!L70,0)","v":0},{"$f":"ROUND(財務データ入力用!N29,0)+ROUND(財務データ入力用!N70,0)","v":0},{"$f":"ROUND(財務データ入力用!P29,0)+ROUND(財務データ入力用!P70,0)","v":0},{"$f":"ROUND(財務データ入力用!R29,0)+ROUND(財務データ入力用!R70,0)","v":0},{"$f":"ROUND(財務データ入力用!T29,0)+ROUND(財務データ入力用!T70,0)","v":0},{"$f":"ROUND(財務データ入力用!V29,0)+ROUND(財務データ入力用!V70,0)","v":0}]
[null,"経常利益",null,{"$f":"D25+D26-D27","v":0},{"$f":"E25+E26-E27","v":0},0,0,0,0,0,0,0,0,0]
[null,"■資金計画"]
[null,"必要資金","運転資金",{"$f":"財務データ入力用!D32","v":0},{"$f":"財務データ入力用!E32","v":0},{"$f":"財務データ入力用!F32","v":0},{"$f":"財務データ入力用!H32+財務データ入力用!H73+財務データ入力用!H74","v":0},{"$f":"財務データ入力用!J32+財務データ入力用!J73+財務データ入力用!J74","v":0},{"$f":"財務データ入力用!L32+財務データ入力用!L73+財務データ入力用!L74","v":0},{"$f":"財務データ入力用!N32+財務データ入力用!N73+財務データ入力用!N74","v":0},{"$f":"財務データ入力用!P32+財務データ入力用!P73+財務データ入力用!P74","v":0},{"$f":"財務データ入力用!R32+財務データ入力用!R73+財務データ入力用!R74","v":0},{"$f":"財務データ入力用!T32+財務データ入力用!T73+財務データ入力用!T74","v":0},{"$f":"財務データ入力用!V32+財務データ入力用!V73+財務データ入力用!V74","v":0}]
[null,null,"設備投資額",{"$f":"財務データ入力用!D33","v":0},{"$f":"財務データ入力用!E33","v":0},{"$f":"財務データ入力用!F33","v":0},{"$f":"財務データ入力用!H33+財務データ入力用!H76","v":0},{"$f":"財務データ入力用!J33+財務データ入力用!J76","v":0},{"$f":"財務データ入力用!L33+財務データ入力用!L76","v":0},{"$f":"財務データ入力用!N33+財務データ入力用!N76","v":0},{"$f":"財務データ入力用!P33+財務データ入力用!P76","v":0},{"$f":"財務データ入力用!R33+財務データ入力用!R76","v":0},{"$f":"財務データ入力用!T33+財務データ入力用!T76","v":0},{"$f":"財務データ入力用!V33+財務データ入力用!V76","v":0}]
[null,null,"計",{"$f":"SUM(D30:D31)","v":0},{"$f":"SUM(E30:E31)","v":0},{"$f":"SUM(F30:F31)","v":0},{"$f":"SUM(G30:G31)","v":0},{"$f":"SUM(H30:H31)","v":0},0,0,0,0,0,{"$f":"SUM(N30:N31)","v":0}]
[null,"資金調達額","政府系金融機関",null,null,null,{"$f":"財務データ入力用!H35+財務データ入力用!H78","v":0},{"$f":"財務データ入力用!J35+財務データ入力用!J78","v":0},{"$f":"財務データ入力用!L35+財務データ入力用!L78","v":0},{"$f":"財務データ入力用!N35+財務データ入力用!N78","v":0},{"$f":"財務データ入力用!P35+財務データ入力用!P78","v":0},{"$f":"財務データ入力用!R35+財務データ入力用!R78","v":0},{"$f":"財務データ入力用!T35+財務データ入力用!T78","v":0},{"$f":"財務データ入力用!V35+財務データ入力用!V78","v":0}]
[null,null,"民間金融機関",null,null,null,{"$f":"財務データ入力用!H36+財務データ入力用!H79","v":0},{"$f":"財務データ入力用!J36+財務データ入力用!J79","v":0},{"$f":"財務データ入力用!L36+財務データ入力用!L79","v":0},{"$f":"財務データ入力用!N36+財務データ入力用!N79","v":0},{"$f":"財務データ入力用!P36+財務データ入力用!P79","v":0},{"$f":"財務データ入力用!R36+財務データ入力用!R79","v":0},{"$f":"財務データ入力用!T36+財務データ入力用!T79","v":0},{"$f":"財務データ入力用!V36+財務データ入力用!V79","v":0}]
[null,null,"自己資金",null,null,null,{"$f":"財務データ入力用!H37+財務データ入力用!H80","v":0},{"$f":"財務データ入力用!J37+財務データ入力用!J80","v":0},{"$f":"財務データ入力用!L37+財務データ入力用!L80","v":0},{"$f":"財務データ入力用!N37+財務データ入力用!N80","v":0},{"$f":"財務データ入力用!P37+財務データ入力用!P80","v":0},{"$f":"財務データ入力用!R37+財務データ入力用!R80","v":0},{"$f":"財務データ入力用!T37+財務データ入力用!T80","v":0},{"$f":"財務データ入力用!V37+財務データ入力用!V80","v":0}]
[null,null,"その他",null,null,null,{"$f":"財務データ入力用!H38+財務データ入力用!H81","v":0},{"$f":"財務データ入力用!J38+財務データ入力用!J81","v":0},{"$f":"財務データ入力用!L38+財務データ入力用!L81","v":0},{"$f":"財務データ入力用!N38+財務データ入力用!N81","v":0},{"$f":"財務データ入力用!P38+財務データ入力用!P81","v":0},{"$f":"財務データ入力用!R38+財務データ入力用!R81","v":0},{"$f":"財務データ入力用!T38+財務データ入力用!T81","v":0},{"$f":"財務データ入力用!V38+財務データ入力用!V81","v":0}]
[null,null,"計",null,null,null,{"$f":"SUM(G33:G36)","v":0},{"$f":"SUM(H33:H36)","v":0},0,0,0,0,0,0]
[null,null,null,null,null,null,{"$f":"IF(G32=G37,\" \",\"エラー\")","v":" "},{"$f":"IF(H32=H37,\" \",\"エラー\")","v":" "}," "," "," "," "," "," "]
[null,"■人員配分（換算値）",null,null,null,null,null,null,null,null,null,null,null,"（単位：人）"]
[null,"既存事業",null,{"$f":"財務データ入力用!D44","v":0},{"$f":"財務データ入力用!E44","v":0},{"$f":"財務データ入力用!F44","v":0},{"$f":"財務データ入力用!H44","v":0},{"$f":"財務データ入力用!J44","v":0},{"$f":"財務データ入力用!L44","v":0},{"$f":"財務データ入力用!N44","v":0},{"$f":"財務データ入力用!P44","v":0},{"$f":"財務データ入力用!R44","v":0},{"$f":"財務データ入力用!T44","v":0},{"$f":"財務データ入力用!V44","v":0}]
[null,"新規事業",null,null,null,null,{"$f":"財務データ入力用!H87","v":0},{"$f":"財務データ入力用!J87","v":0},{"$f":"財務データ入力用!L87","v":0},{"$f":"財務データ入力用!N87","v":0},{"$f":"財務データ入力用!P87","v":0},{"$f":"財務データ入力用!R87","v":0},{"$f":"財務データ入力用!T87","v":0},{"$f":"財務データ入力用!V87","v":0}]
[null,"計",null,{"$f":"SUM(D40:D41)","v":0},{"$f":"SUM(E40:E41)","v":0},{"$f":"SUM(F40:F41)","v":0},{"$f":"SUM(G40:G41)","v":0},{"$f":"SUM(H40:H41)","v":0},0,0,0,0,0,{"$f":"SUM(N40:N41)","v":0}]
[null,null,"科目別内訳（換算値）"]
[null,null,"労務費対象人数",{"$f":"ROUND((財務データ入力用!D42),1)","v":0},{"$f":"ROUND((財務データ入力用!F42),1)","v":0},{"$f":"ROUND((財務データ入力用!F42),1)","v":0},{"$f":"ROUND((財務データ入力用!H42+財務データ入力用!H85),1)","v":0},{"$f":"ROUND((財務データ入力用!J42+財務データ入力用!J85),1)","v":0},{"$f":"ROUND((財務データ入力用!L42+財務データ入力用!L85),1)","v":0},{"$f":"ROUND((財務データ入力用!N42+財務データ入力用!N85),1)","v":0},{"$f":"ROUND((財務データ入力用!P42+財務データ入力用!P85),1)","v":0},{"$f":"ROUND((財務データ入力用!R42+財務データ入力用!R85),1)","v":0},{"$f":"ROUND((財務データ入力用!T42+財務データ入力用!T85),1)","v":0},{"$f":"ROUND((財務データ入力用!V42+財務データ入力用!V85),1)","v":0}]
[null,null,"役員報酬・給与等対象人数",{"$f":"ROUND((財務データ入力用!D43),1)","v":0},{"$f":"ROUND((財務データ入力用!E43),1)","v":0},{"$f":"ROUND((財務データ入力用!F43),1)","v":0},{"$f":"ROUND((財務データ入力用!H43+財務データ入力用!H86),1)","v":0},{"$f":"ROUND((財務データ入力用!J43+財務データ入力用!J86),1)","v":0},{"$f":"ROUND((財務データ入力用!L43+財務データ入力用!L86),1)","v":0},{"$f":"ROUND((財務データ入力用!N43+財務データ入力用!N86),1)","v":0},{"$f":"ROUND((財務データ入力用!P43+財務データ入力用!P86),1)","v":0},{"$f":"ROUND((財務データ入力用!R43+財務データ入力用!R86),1)","v":0},{"$f":"ROUND((財務データ入力用!T43+財務データ入力用!T86),1)","v":0},{"$f":"ROUND((財務データ入力用!V43+財務データ入力用!V86),1)","v":0}]
[]
[null,"■指標"]
[null,"付加価値額",null,{"$f":"D8+D9+D10+D11+D12+D13+D17+D18+D19+D20+D21+D22+D25","v":0},{"$f":"E8+E9+E10+E11+E12+E13+E17+E18+E19+E20+E21+E22+E25","v":0},{"$f":"F8+F9+F10+F11+F12+F13+F17+F18+F19+F20+F21+F22+F25","v":0},{"$f":"G8+G9+G10+G11+G12+G13+G17+G18+G19+G20+G21+G22+G25","v":0},0,0,0,0,0,0,0]
[null,null,"伸び率",null,null,null,null,null,{"$f":"IF(I48=0,\" \",ROUND(((I48-$F$48)/ABS($F$48)),3))","v":" "}," "," "," "," "," "]
[null,"一人当たり付加価値額",null,{"$f":"IF(D42=0,,ROUND((D48/D42),0))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"伸び率",null,null,null,null,null,{"$f":"IF(I50=0,\" \",ROUND(((I50-$F$50)/ABS($F$50)),3))","v":" "}," "," "," "," "," "]
[null,"給与支給総額",null,{"$f":"D8+D17","v":0},{"$f":"E8+E17","v":0},0,0,0,0,0,0,0,0,0]
[null,null,"伸び率",null,null,null,null,null,{"$f":"IF(I52=0,\" \",ROUND(((I52-$F$52)/ABS($F$52)),3))","v":" "}," "," "," "," "," "]

{"sheet":"申請書＜別表３＞（自動出力）","index":3,"n_rows":27,"n_cols":14,"rows_kept":27,"cut":false,"hidden":false,"merged":[[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],[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],[27,1,27,4],[29,2,29,6],[30,2,30,6],[31,2,31,8],[33,1,33,5]]}
[null,null,"（別表３）"]
[null,null,"経営計画及び資金計画"]
[null,null,"参加特定事業者名　　　　　　　　",null,{"$f":"財務データ入力用!R3","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":"'計画全体（自動出力）'!D15","v":0},{"$f":"'計画全体（自動出力）'!E15","v":0},{"$f":"'計画全体（自動出力）'!F15","v":0},{"$f":"'計画全体（自動出力）'!G15","v":0},{"$f":"'計画全体（自動出力）'!H15","v":0},{"$f":"'計画全体（自動出力）'!I15","v":0},{"$f":"'計画全体（自動出力）'!J15","v":0},{"$f":"'計画全体（自動出力）'!K15","v":0},{"$f":"'計画全体（自動出力）'!L15","v":0},{"$f":"'計画全体（自動出力）'!M15","v":0},{"$f":"'計画全体（自動出力）'!N15","v":0}]
["③売上総利益\n　(①－②）",null,null,{"$f":"D6-D7","v":0},0,0,0,0,0,0,0,0,0,0]
["④販売費及び\n　一般管理費",null,null,{"$f":"'計画全体（自動出力）'!D24","v":0},{"$f":"'計画全体（自動出力）'!E24","v":0},{"$f":"'計画全体（自動出力）'!F24","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}]
["⑤営業利益",null,null,{"$f":"'計画全体（自動出力）'!D25","v":0},{"$f":"'計画全体（自動出力）'!E25","v":0},{"$f":"'計画全体（自動出力）'!F25","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}]
["⑥経常利益",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":"'計画全体（自動出力）'!D52","v":0},{"$f":"'計画全体（自動出力）'!E52","v":0},{"$f":"'計画全体（自動出力）'!F52","v":0},{"$f":"'計画全体（自動出力）'!G52","v":0},{"$f":"'計画全体（自動出力）'!H52","v":0},{"$f":"'計画全体（自動出力）'!I52","v":0},{"$f":"'計画全体（自動出力）'!J52","v":0},{"$f":"'計画全体（自動出力）'!K52","v":0},{"$f":"'計画全体（自動出力）'!L52","v":0},{"$f":"'計画全体（自動出力）'!M52","v":0},{"$f":"'計画全体（自動出力）'!N52","v":0}]
["⑧人件費",null,null,{"$f":"SUM('計画全体（自動出力）'!D8:D9)+SUM('計画全体（自動出力）'!D17:D18)","v":0},{"$f":"SUM('計画全体（自動出力）'!E8:E9)+SUM('計画全体（自動出力）'!E17:E18)","v":0},{"$f":"SUM('計画全体（自動出力）'!F8:F9)+SUM('計画全体（自動出力）'!F17:F18)","v":0},{"$f":"SUM('計画全体（自動出力）'!G8:G9)+SUM('計画全体（自動出力）'!G17:G18)","v":0},{"$f":"SUM('計画全体（自動出力）'!H8:H9)+SUM('計画全体（自動出力）'!H17:H18)","v":0},{"$f":"SUM('計画全体（自動出力）'!I8:I9)+SUM('計画全体（自動出力）'!I17:I18)","v":0},{"$f":"SUM('計画全体（自動出力）'!J8:J9)+SUM('計画全体（自動出力）'!J17:J18)","v":0},{"$f":"SUM('計画全体（自動出力）'!K8:K9)+SUM('計画全体（自動出力）'!K17:K18)","v":0},{"$f":"SUM('計画全体（自動出力）'!L8:L9)+SUM('計画全体（自動出力）'!L17:L18)","v":0},{"$f":"SUM('計画全体（自動出力）'!M8:M9)+SUM('計画全体（自動出力）'!M17:M18)","v":0},{"$f":"SUM('計画全体（自動出力）'!N8:N9)+SUM('計画全体（自動出力）'!N17:N18)","v":0}]
["⑨設備投資額",null,null,{"$f":"'計画全体（自動出力）'!D31","v":0},{"$f":"'計画全体（自動出力）'!E31","v":0},{"$f":"'計画全体（自動出力）'!F31","v":0},{"$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":"'計画全体（自動出力）'!D30","v":0},{"$f":"'計画全体（自動出力）'!E30","v":0},{"$f":"'計画全体（自動出力）'!F30","v":0},{"$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,"普通償却額",null,{"$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":"'計画全体（自動出力）'!G10+'計画全体（自動出力）'!G12+'計画全体（自動出力）'!G13+'計画全体（自動出力）'!G19+'計画全体（自動出力）'!G21+'計画全体（自動出力）'!G22","v":0},{"$f":"'計画全体（自動出力）'!H10+'計画全体（自動出力）'!H12+'計画全体（自動出力）'!H13+'計画全体（自動出力）'!H19+'計画全体（自動出力）'!H21+'計画全体（自動出力）'!H22","v":0},{"$f":"'計画全体（自動出力）'!I10+'計画全体（自動出力）'!I12+'計画全体（自動出力）'!I13+'計画全体（自動出力）'!I19+'計画全体（自動出力）'!I21+'計画全体（自動出力）'!I22","v":0},{"$f":"'計画全体（自動出力）'!J10+'計画全体（自動出力）'!J12+'計画全体（自動出力）'!J13+'計画全体（自動出力）'!J19+'計画全体（自動出力）'!J21+'計画全体（自動出力）'!J22","v":0},{"$f":"'計画全体（自動出力）'!K10+'計画全体（自動出力）'!K12+'計画全体（自動出力）'!K13+'計画全体（自動出力）'!K19+'計画全体（自動出力）'!K21+'計画全体（自動出力）'!K22","v":0},{"$f":"'計画全体（自動出力）'!L10+'計画全体（自動出力）'!L12+'計画全体（自動出力）'!L13+'計画全体（自動出力）'!L19+'計画全体（自動出力）'!L21+'計画全体（自動出力）'!L22","v":0},{"$f":"'計画全体（自動出力）'!M10+'計画全体（自動出力）'!M12+'計画全体（自動出力）'!M13+'計画全体（自動出力）'!M19+'計画全体（自動出力）'!M21+'計画全体（自動出力）'!M22","v":0},{"$f":"'計画全体（自動出力）'!N10+'計画全体（自動出力）'!N12+'計画全体（自動出力）'!N13+'計画全体（自動出力）'!N19+'計画全体（自動出力）'!N21+'計画全体（自動出力）'!N22","v":0}]
[null,"特別償却額",null,{"$f":"'計画全体（自動出力）'!D11+'計画全体（自動出力）'!D20","v":0},{"$f":"'計画全体（自動出力）'!E11+'計画全体（自動出力）'!E20","v":0},{"$f":"'計画全体（自動出力）'!F11+'計画全体（自動出力）'!F20","v":0},{"$f":"'計画全体（自動出力）'!G11+'計画全体（自動出力）'!G20","v":0},{"$f":"'計画全体（自動出力）'!H11+'計画全体（自動出力）'!H20","v":0},{"$f":"'計画全体（自動出力）'!I11+'計画全体（自動出力）'!I20","v":0},{"$f":"'計画全体（自動出力）'!J11+'計画全体（自動出力）'!J20","v":0},{"$f":"'計画全体（自動出力）'!K11+'計画全体（自動出力）'!K20","v":0},{"$f":"'計画全体（自動出力）'!L11+'計画全体（自動出力）'!L20","v":0},{"$f":"'計画全体（自動出力）'!M11+'計画全体（自動出力）'!M20","v":0},{"$f":"'計画全体（自動出力）'!N11+'計画全体（自動出力）'!N20","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":"'計画全体（自動出力）'!D42","v":0},{"$f":"'計画全体（自動出力）'!E42","v":0},{"$f":"'計画全体（自動出力）'!F42","v":0},{"$f":"'計画全体（自動出力）'!G42","v":0},{"$f":"'計画全体（自動出力）'!H42","v":0},{"$f":"'計画全体（自動出力）'!I42","v":0},{"$f":"'計画全体（自動出力）'!J42","v":0},{"$f":"'計画全体（自動出力）'!K42","v":0},{"$f":"'計画全体（自動出力）'!L42","v":0},{"$f":"'計画全体（自動出力）'!M42","v":0},{"$f":"'計画全体（自動出力）'!N42","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":"'計画全体（自動出力）'!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,"民間金融機\n関借入",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,"－","－","－",{"$f":"'計画全体（自動出力）'!G35","v":0},{"$f":"'計画全体（自動出力）'!H35","v":0},{"$f":"'計画全体（自動出力）'!I35","v":0},{"$f":"'計画全体（自動出力）'!J35","v":0},{"$f":"'計画全体（自動出力）'!K35","v":0},{"$f":"'計画全体（自動出力）'!L35","v":0},{"$f":"'計画全体（自動出力）'!M35","v":0},{"$f":"'計画全体（自動出力）'!N35","v":0}]
[null,"その他",null,"－","－","－",{"$f":"'計画全体（自動出力）'!G36","v":0},{"$f":"'計画全体（自動出力）'!H36","v":0},{"$f":"'計画全体（自動出力）'!I36","v":0},{"$f":"'計画全体（自動出力）'!J36","v":0},{"$f":"'計画全体（自動出力）'!K36","v":0},{"$f":"'計画全体（自動出力）'!L36","v":0},{"$f":"'計画全体（自動出力）'!M36","v":0},{"$f":"'計画全体（自動出力）'!N36","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":4,"n_rows":90,"n_cols":6,"rows_kept":90,"cut":false,"hidden":false,"merged":[[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],[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],[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],[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]]}
[]
[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":5,"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":6,"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を再起動し、「マクロ有効確認」ボタンをクリックしてメッセージボックスが表示されるか確認する"]
[]
[]
[]
["以上"]