{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["ご利用方法","数値データ入力","申請書＜別表３＞（印刷用）","数値目標確認（自動出力）","別表3インポート用マクロ","マクロ有効化の手順"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":6,"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":35,"n_cols":25,"rows_kept":35,"cut":false,"hidden":false,"merged":[[3,19,3,20],[3,21,3,22],[3,23,3,24],[1,0,1,2],[1,17,1,18],[1,19,1,23],[2,23,2,24],[3,0,4,2],[3,3,3,4],[3,5,3,6],[3,7,3,8],[3,9,3,10],[3,11,3,12],[4,11,4,12],[4,13,4,14],[3,13,3,14],[3,15,3,16],[3,17,3,18],[5,0,5,2],[4,3,4,4],[4,5,4,6],[4,7,4,8],[4,9,4,10],[4,15,4,16],[4,17,4,18],[4,19,4,20],[4,21,4,22],[4,23,4,24],[6,0,6,2],[7,0,7,2],[8,0,10,0],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,0,11,2],[12,0,12,2],[13,0,15,0],[13,1,13,2],[14,1,14,2],[15,1,15,2],[26,0,26,2],[16,0,16,2],[17,1,17,2],[18,0,18,2],[19,0,19,2],[20,0,21,0],[20,1,20,2],[21,1,21,2],[22,0,22,2],[23,0,24,0],[23,1,23,2],[24,1,24,2],[25,0,25,2],[27,0,27,2],[28,0,28,2],[29,0,33,0],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2]]}
["【簡易版】「別表３」作成支援システム＜R7.5改訂版＞"]
["個人事業者用",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"屋号等"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(単位：千円）"]
[null,null,null,"２年前",null,"１年前",null,"直近期末",null,"１年後",null,"２年後",null,"３年後",null,"４年後",null,"５年後",null,"６年後",null,"７年後",null,"８年後"]
[null,null,null,"( 年12月期)",null,"( 年12月期)",null,"( 年12月期)",null,"( 年12月期)",null,"( 年12月期)",null,"( 年12月期)",null,"( 年12月期)",null,"( 年12月期)",null,"( 年12月期)",null,"( 年12月期)",null,"( 年12月期)"]
["①売上（収入）金額",null,null,null,100,null,100,null,100,null,100,null,100,null,100,null,100,null,100,null,100,null,100,null,100]
["②売上原価（差引原価）",null,null,null,{"$f":"IF(D$6=0,\"－\",IF(D7<=0,\"－\",D7/D$6*100))","v":"－"},null,{"$f":"IF(F$6=0,\"－\",IF(F7<=0,\"－\",F7/F$6*100))","v":"－"},null,{"$f":"IF(H$6=0,\"－\",IF(H7<=0,\"－\",H7/H$6*100))","v":"－"},null,{"$f":"IF(J$6=0,\"－\",IF(J7<=0,\"－\",J7/J$6*100))","v":"－"},null,{"$f":"IF(L$6=0,\"－\",IF(L7<=0,\"－\",L7/L$6*100))","v":"－"},null,{"$f":"IF(N$6=0,\"－\",IF(N7<=0,\"－\",N7/N$6*100))","v":"－"},null,{"$f":"IF(P$6=0,\"－\",IF(P7<=0,\"－\",P7/P$6*100))","v":"－"},null,{"$f":"IF(R$6=0,\"－\",IF(R7<=0,\"－\",R7/R$6*100))","v":"－"},null,{"$f":"IF(T$6=0,\"－\",IF(T7<=0,\"－\",T7/T$6*100))","v":"－"},null,{"$f":"IF(V$6=0,\"－\",IF(V7<=0,\"－\",V7/V$6*100))","v":"－"},null,{"$f":"IF(X$6=0,\"－\",IF(X7<=0,\"－\",X7/X$6*100))","v":"－"}]
["③差引金額　(①－②）",null,null,{"$f":"D6-D7","v":0},{"$f":"IF(D$6=0,\"－\",IF(D8<=0,\"－\",D8/D$6*100))","v":"－"},{"$f":"F6-F7","v":0},"－",{"$f":"H6-H7","v":0},"－",{"$f":"J6-J7","v":0},{"$f":"IF(J$6=0,\"－\",IF(J8<=0,\"－\",J8/J$6*100))","v":"－"},{"$f":"L6-L7","v":0},{"$f":"IF(L$6=0,\"－\",IF(L8<=0,\"－\",L8/L$6*100))","v":"－"},{"$f":"N6-N7","v":0},{"$f":"IF(N$6=0,\"－\",IF(N8<=0,\"－\",N8/N$6*100))","v":"－"},{"$f":"P6-P7","v":0},{"$f":"IF(P$6=0,\"－\",IF(P8<=0,\"－\",P8/P$6*100))","v":"－"},{"$f":"R6-R7","v":0},{"$f":"IF(R$6=0,\"－\",IF(R8<=0,\"－\",R8/R$6*100))","v":"－"},{"$f":"T6-T7","v":0},{"$f":"IF(T$6=0,\"－\",IF(T8<=0,\"－\",T8/T$6*100))","v":"－"},{"$f":"V6-V7","v":0},{"$f":"IF(V$6=0,\"－\",IF(V8<=0,\"－\",V8/V$6*100))","v":"－"},{"$f":"X6-X7","v":0},{"$f":"IF(X$6=0,\"－\",IF(X8<=0,\"－\",X8/X$6*100))","v":"－"}]
["経　費","利子割引料",null,null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－"]
[null,"上記以外（自動計算）",null,{"$f":"D11-D9","v":0},"－",{"$f":"F11-F9","v":0},"－",{"$f":"H11-H9","v":0},"－",{"$f":"J11-J9","v":0},"－",0,"－",{"$f":"N11-N9","v":0},"－",{"$f":"P11-P9","v":0},"－",{"$f":"R11-R9","v":0},"－",{"$f":"T11-T9","v":0},"－",{"$f":"V11-V9","v":0},"－",{"$f":"X11-X9","v":0},"－"]
[null,"計",null,null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－"]
["⑤営業利益",null,null,{"$f":"D8-D10","v":0},"－",{"$f":"F8-F10","v":0},"－",{"$f":"H8-H10","v":0},"－",{"$f":"J8-J10","v":0},"－",0,"－",{"$f":"N8-N10","v":0},"－",{"$f":"P8-P10","v":0},"－",{"$f":"R8-R10","v":0},"－",{"$f":"T8-T10","v":0},"－",{"$f":"V8-V10","v":0},"－",{"$f":"X8-X10","v":0},"－"]
["⑥差引金額（経常利益）",null,null,null,"－",null,"－",null,"－",{"$f":"J8-J11","v":0},"－",0,"－",{"$f":"N8-N11","v":0},"－",{"$f":"P8-P11","v":0},"－",{"$f":"R8-R11","v":0},"－",{"$f":"T8-T11","v":0},"－",{"$f":"V8-V11","v":0},"－",{"$f":"X8-X11","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,"－",{"$f":"J13-J15","v":0},"－",{"$f":"L13-L15","v":0},"－",{"$f":"N13-N15","v":0},"－",{"$f":"P13-P15","v":0},"－",{"$f":"R13-R15","v":0},"－",{"$f":"T13-T15","v":0},"－",{"$f":"V13-V15","v":0},"－",{"$f":"X13-X15","v":0},"－"]
["⑦給与支給総額",null,null,{"$f":"SUM(D14:D16)","v":0},"－",{"$f":"SUM(F14:F16)","v":0},"－",{"$f":"SUM(H14:H16)","v":0},"－",{"$f":"SUM(J14:J16)","v":0},"－",0,"－",{"$f":"SUM(N14:N16)","v":0},"－",{"$f":"SUM(P14:P16)","v":0},"－",{"$f":"SUM(R14:R16)","v":0},"－",{"$f":"SUM(T14:T16)","v":0},"－",{"$f":"SUM(V14:V16)","v":0},"－",{"$f":"SUM(X14:X16)","v":0},"－"]
[null,"福利厚生費・法定福利費＋退職金等",null,null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－"]
["⑧人件費",null,null,{"$f":"D14+D18","v":0},"－",{"$f":"F14+F18","v":0},"－",{"$f":"H14+H18","v":0},"－",{"$f":"J14+J18","v":0},"－",0,"－",{"$f":"N14+N18","v":0},"－",{"$f":"P14+P18","v":0},"－",{"$f":"R14+R18","v":0},"－",{"$f":"T14+T18","v":0},"－",{"$f":"V14+V18","v":0},"－",{"$f":"X14+X18","v":0},"－"]
["⑨設備投資額（税込み額）"]
[null,"通常運転資金",null,{"$f":"ROUND((D7+D10)/12,-2)","v":0},null,{"$f":"ROUND((F7+F10)/12,-2)","v":0},null,{"$f":"ROUND((H7+H10)/12,-2)","v":0},null,{"$f":"ROUND((J7+J10)/12,-2)","v":0},null,{"$f":"ROUND((L7+L10)/12,-2)","v":0},null,{"$f":"ROUND((N7+N10)/12,-2)","v":0},null,{"$f":"ROUND((P7+P10)/12,-2)","v":0},null,{"$f":"ROUND((R7+R10)/12,-2)","v":0},null,{"$f":"ROUND((T7+T10)/12,-2)","v":0},null,{"$f":"ROUND((V7+V10)/12,-2)","v":0},null,{"$f":"ROUND((X7+X10)/12,-2)","v":0}]
[null,"増加運転資金"]
["⑩運転資金",null,null,{"$f":"D21+D22","v":0},null,{"$f":"F21+F22","v":0},null,{"$f":"H21+H22","v":0},null,{"$f":"J21+J22","v":0},null,{"$f":"L21+L22","v":0},null,{"$f":"N21+N22","v":0},null,{"$f":"P21+P22","v":0},null,{"$f":"R21+R22","v":0},null,{"$f":"T21+T22","v":0},null,{"$f":"V21+V22","v":0},null,{"$f":"X21+X22","v":0}]
[null,"普通償却額+賃借料(地代・家賃を除く)＋リース料",null,null,{"$f":"IF(D$6=0,\"－\",IF(D24<=0,\"－\",D24/D$6*100))","v":"－"},null,"－",null,{"$f":"IF(H$6=0,\"－\",IF(H24<=0,\"－\",H24/H$6*100))","v":"－"},null,{"$f":"IF(J$6=0,\"－\",IF(J24<=0,\"－\",J24/J$6*100))","v":"－"},null,{"$f":"IF(L$6=0,\"－\",IF(L24<=0,\"－\",L24/L$6*100))","v":"－"},null,{"$f":"IF(N$6=0,\"－\",IF(N24<=0,\"－\",N24/N$6*100))","v":"－"},null,{"$f":"IF(P$6=0,\"－\",IF(P24<=0,\"－\",P24/P$6*100))","v":"－"},null,{"$f":"IF(R$6=0,\"－\",IF(R24<=0,\"－\",R24/R$6*100))","v":"－"},null,{"$f":"IF(T$6=0,\"－\",IF(T24<=0,\"－\",T24/T$6*100))","v":"－"},null,{"$f":"IF(V$6=0,\"－\",IF(V24<=0,\"－\",V24/V$6*100))","v":"－"},null,{"$f":"IF(X$6=0,\"－\",IF(X24<=0,\"－\",X24/X$6*100))","v":"－"}]
[null,"特別償却額",null,null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－",null,"－"]
["⑪減価償却費",null,null,{"$f":"SUM(D24:D25)","v":0},"－",{"$f":"SUM(F24:F25)","v":0},"－",{"$f":"SUM(H24:H25)","v":0},"－",{"$f":"SUM(J24:J25)","v":0},"－",{"$f":"SUM(L24:L25)","v":0},"－",{"$f":"SUM(N24:N25)","v":0},"－",{"$f":"SUM(P24:P25)","v":0},"－",{"$f":"SUM(R24:R25)","v":0},"－",{"$f":"SUM(T24:T25)","v":0},"－",{"$f":"SUM(V24:V25)","v":0},"－",{"$f":"SUM(X24:X25)","v":0},"－"]
["⑫付加価値額\n（⑤＋⑧＋⑪）",null,null,{"$f":"D12+D19+D26","v":0},null,{"$f":"F12+F19+F26","v":0},null,{"$f":"H12+H19+H26","v":0},null,{"$f":"J12+J19+J26","v":0},null,{"$f":"L12+L19+L26","v":0},null,{"$f":"N12+N19+N26","v":0},null,{"$f":"P12+P19+P26","v":0},null,{"$f":"R12+R19+R26","v":0},null,{"$f":"T12+T19+T26","v":0},null,{"$f":"V12+V19+V26","v":0},null,{"$f":"X12+X19+X26","v":0}]
["⑬個人事業主＋専従者数＋従業員の人数"]
["⑭一人当たりの付加価値額（⑫÷⑬）",null,null,{"$f":"IF(D28>0,ROUND(D27/D28,0),0)","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["⑮資金調達額(⑨＋⑩）","政府系金融機関借入"]
[null,"民間金融機関借入"]
[null,"自己資金",null,null,null,null,null,null,null,{"$f":"(J20+J23)-J30-J31-J33","v":0},null,{"$f":"(L20+L23)-L30-L31-L33","v":0},null,{"$f":"(N20+N23)-N30-N31-N33","v":0},null,{"$f":"(P20+P23)-P30-P31-P33","v":0},null,{"$f":"(R20+R23)-R30-R31-R33","v":0},null,{"$f":"(T20+T23)-T30-T31-T33","v":0},null,{"$f":"(V20+V23)-V30-V31-V33","v":0},null,{"$f":"(X20+X23)-X30-X31-X33","v":0}]
[null,"その他"]
[null,"　合　計",null,null,null,null,null,null,null,{"$f":"SUM(J30:J33)","v":0},null,{"$f":"SUM(L30:L33)","v":0},null,{"$f":"SUM(N30:N33)","v":0},null,{"$f":"SUM(P30:P33)","v":0},null,{"$f":"SUM(R30:R33)","v":0},null,{"$f":"SUM(T30:T33)","v":0},null,{"$f":"SUM(V30:V33)","v":0},null,{"$f":"SUM(X30:X33)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J32>-1,\" \",\"自己資金が▲です）\")","v":" "},null,{"$f":"IF(L32>-1,\" \",\"自己資金が▲です）\")","v":" "},null,{"$f":"IF(N32>-1,\" \",\"自己資金が▲です）\")","v":" "},null,{"$f":"IF(P32>-1,\" \",\"自己資金が▲です）\")","v":" "},null,{"$f":"IF(R32>-1,\" \",\"自己資金が▲です）\")","v":" "},null,{"$f":"IF(T32>-1,\" \",\"自己資金が▲です）\")","v":" "},null,{"$f":"IF(V32>-1,\" \",\"自己資金が▲です）\")","v":" "},null,{"$f":"IF(X32>-1,\" \",\"自己資金が▲です）\")","v":" "}]

{"sheet":"申請書＜別表３＞（印刷用）","index":2,"n_rows":28,"n_cols":14,"rows_kept":28,"cut":false,"hidden":false,"merged":[[18,0,18,2],[2,2,2,3],[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],[15,0,15,2],[19,0,19,2],[20,0,20,2],[21,0,21,2],[22,0,26,0],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[28,1,28,4],[30,2,30,6],[31,2,31,6],[32,2,32,8],[34,1,34,5]]}
[null,null,"（別表３）"]
[null,null,"経営計画及び資金計画"]
[null,null,"参加特定事業者名　　　　　　　　",null,{"$f":"数値データ入力!T2","v":0},null,null,null,null,null,null,null,null,"（単位   千円）"]
[]
[null,null,null,"２年前","１年前","直近期末","１年後","２年後","３年後","４年後","５年後","６年後","７年後","８年後"]
[null,null,null,{"$f":"数値データ入力!D5","v":"( 年12月期)"},{"$f":"数値データ入力!F5","v":"( 年12月期)"},{"$f":"数値データ入力!H5","v":"( 年12月期)"},{"$f":"数値データ入力!J5","v":"( 年12月期)"},{"$f":"数値データ入力!L5","v":"( 年12月期)"},{"$f":"数値データ入力!N5","v":"( 年12月期)"},{"$f":"数値データ入力!P5","v":"( 年12月期)"},{"$f":"数値データ入力!R5","v":"( 年12月期)"},{"$f":"数値データ入力!T5","v":"( 年12月期)"},{"$f":"数値データ入力!V5","v":"( 年12月期)"},{"$f":"数値データ入力!X5","v":"( 年12月期)"}]
["①売上高",null,null,{"$f":"数値データ入力!D6","v":0},{"$f":"数値データ入力!F6","v":0},{"$f":"数値データ入力!H6","v":0},{"$f":"数値データ入力!J6","v":0},{"$f":"数値データ入力!L6","v":0},{"$f":"数値データ入力!N6","v":0},{"$f":"数値データ入力!P6","v":0},{"$f":"数値データ入力!R6","v":0},{"$f":"数値データ入力!T6","v":0},{"$f":"数値データ入力!V6","v":0},{"$f":"数値データ入力!X6","v":0}]
["②売上原価",null,null,{"$f":"数値データ入力!D7","v":0},{"$f":"数値データ入力!F7","v":0},{"$f":"数値データ入力!H7","v":0},{"$f":"数値データ入力!J7","v":0},{"$f":"数値データ入力!L7","v":0},{"$f":"数値データ入力!N7","v":0},{"$f":"数値データ入力!P7","v":0},{"$f":"数値データ入力!R7","v":0},{"$f":"数値データ入力!T7","v":0},{"$f":"数値データ入力!V7","v":0},{"$f":"数値データ入力!X7","v":0}]
["③売上総利益\n　(①－②）",null,null,{"$f":"D7-D8","v":0},0,0,0,0,0,0,0,0,0,0]
["④販売費及び\n　一般管理費",null,null,{"$f":"数値データ入力!D10","v":0},{"$f":"数値データ入力!F10","v":0},{"$f":"数値データ入力!H10","v":0},{"$f":"数値データ入力!J10","v":0},{"$f":"数値データ入力!L10","v":0},{"$f":"数値データ入力!N10","v":0},{"$f":"数値データ入力!P10","v":0},{"$f":"数値データ入力!R10","v":0},{"$f":"数値データ入力!T10","v":0},{"$f":"数値データ入力!V10","v":0},{"$f":"数値データ入力!X10","v":0}]
["⑤営業利益",null,null,{"$f":"数値データ入力!D12","v":0},{"$f":"数値データ入力!F12","v":0},{"$f":"数値データ入力!H12","v":0},{"$f":"数値データ入力!J12","v":0},{"$f":"数値データ入力!L12","v":0},{"$f":"数値データ入力!N12","v":0},{"$f":"数値データ入力!P12","v":0},{"$f":"数値データ入力!R12","v":0},{"$f":"数値データ入力!T12","v":0},{"$f":"数値データ入力!V12","v":0},{"$f":"数値データ入力!X12","v":0}]
["⑥経常利益",null,null,{"$f":"数値データ入力!D13","v":0},{"$f":"数値データ入力!F13","v":0},{"$f":"数値データ入力!H13","v":0},{"$f":"数値データ入力!J13","v":0},{"$f":"数値データ入力!L13","v":0},{"$f":"数値データ入力!N13","v":0},{"$f":"数値データ入力!P13","v":0},{"$f":"数値データ入力!R13","v":0},{"$f":"数値データ入力!T13","v":0},{"$f":"数値データ入力!V13","v":0},{"$f":"数値データ入力!X13","v":0}]
["⑦給与支給総額",null,null,{"$f":"数値データ入力!D17","v":0},{"$f":"数値データ入力!F17","v":0},{"$f":"数値データ入力!H17","v":0},{"$f":"数値データ入力!J17","v":0},{"$f":"数値データ入力!L17","v":0},{"$f":"数値データ入力!N17","v":0},{"$f":"数値データ入力!P17","v":0},{"$f":"数値データ入力!R17","v":0},{"$f":"数値データ入力!T17","v":0},{"$f":"数値データ入力!V17","v":0},{"$f":"数値データ入力!X17","v":0}]
["⑧人件費",null,null,{"$f":"数値データ入力!D19","v":0},{"$f":"数値データ入力!F19","v":0},{"$f":"数値データ入力!H19","v":0},{"$f":"数値データ入力!J19","v":0},{"$f":"数値データ入力!L19","v":0},{"$f":"数値データ入力!N19","v":0},{"$f":"数値データ入力!P19","v":0},{"$f":"数値データ入力!R19","v":0},{"$f":"数値データ入力!T19","v":0},{"$f":"数値データ入力!V19","v":0},{"$f":"数値データ入力!X19","v":0}]
["⑨設備投資額",null,null,{"$f":"数値データ入力!D20","v":0},{"$f":"数値データ入力!F20","v":0},{"$f":"数値データ入力!H20","v":0},{"$f":"数値データ入力!J20","v":0},{"$f":"数値データ入力!L20","v":0},{"$f":"数値データ入力!N20","v":0},{"$f":"数値データ入力!P20","v":0},{"$f":"数値データ入力!R20","v":0},{"$f":"数値データ入力!T20","v":0},{"$f":"数値データ入力!V20","v":0},{"$f":"数値データ入力!X20","v":0}]
["⑩運転資金",null,null,{"$f":"数値データ入力!D23","v":0},{"$f":"数値データ入力!F23","v":0},{"$f":"数値データ入力!H23","v":0},{"$f":"数値データ入力!J23","v":0},{"$f":"数値データ入力!L23","v":0},{"$f":"数値データ入力!N23","v":0},{"$f":"数値データ入力!P23","v":0},{"$f":"数値データ入力!R23","v":0},{"$f":"数値データ入力!T23","v":0},{"$f":"数値データ入力!V23","v":0},{"$f":"数値データ入力!X23","v":0}]
[null,"普通償却額",null,{"$f":"数値データ入力!D24","v":0},{"$f":"数値データ入力!F24","v":0},{"$f":"数値データ入力!H24","v":0},{"$f":"数値データ入力!J24","v":0},{"$f":"数値データ入力!L24","v":0},{"$f":"数値データ入力!N24","v":0},{"$f":"数値データ入力!P24","v":0},{"$f":"数値データ入力!R24","v":0},{"$f":"数値データ入力!T24","v":0},{"$f":"数値データ入力!V24","v":0},{"$f":"数値データ入力!X24","v":0}]
[null,"特別償却額",null,{"$f":"数値データ入力!D25","v":0},{"$f":"数値データ入力!F25","v":0},{"$f":"数値データ入力!H25","v":0},{"$f":"数値データ入力!J25","v":0},{"$f":"数値データ入力!L25","v":0},{"$f":"数値データ入力!N25","v":0},{"$f":"数値データ入力!P25","v":0},{"$f":"数値データ入力!R25","v":0},{"$f":"数値データ入力!T25","v":0},{"$f":"数値データ入力!V25","v":0},{"$f":"数値データ入力!X25","v":0}]
["⑪減価償却費",null,null,{"$f":"D17+D18","v":0},{"$f":"E17+E18","v":0},0,0,0,0,0,0,0,0,0]
["⑫付加価値額　　　　　（⑤＋⑧＋⑪）",null,null,{"$f":"D11+D14+D19","v":0},0,0,0,0,0,0,0,0,0,0]
["⑬従業員数",null,null,{"$f":"数値データ入力!D28","v":0},{"$f":"数値データ入力!F28","v":0},{"$f":"数値データ入力!H28","v":0},{"$f":"数値データ入力!J28","v":0},{"$f":"数値データ入力!L28","v":0},{"$f":"数値データ入力!N28","v":0},{"$f":"数値データ入力!P28","v":0},{"$f":"数値データ入力!R28","v":0},{"$f":"数値データ入力!T28","v":0},{"$f":"数値データ入力!V28","v":0},{"$f":"数値データ入力!X28","v":0}]
["⑭一人当たりの付加価値額（⑫÷⑬）",null,null,{"$f":"IF(D21>0,ROUND(D20/D21,0),0)","v":0},0,0,0,0,0,0,0,0,0,0]
["⑮資金調達額(⑨＋⑩）","政府系金融\n機関借入",null,"－","－","－",{"$f":"数値データ入力!J30","v":0},{"$f":"数値データ入力!L30","v":0},{"$f":"数値データ入力!N30","v":0},{"$f":"数値データ入力!P30","v":0},{"$f":"数値データ入力!R30","v":0},{"$f":"数値データ入力!T30","v":0},{"$f":"数値データ入力!V30","v":0},{"$f":"数値データ入力!X30","v":0}]
[null,"民間金融機\n関借入",null,"－","－","－",{"$f":"数値データ入力!J31","v":0},{"$f":"数値データ入力!L31","v":0},{"$f":"数値データ入力!N31","v":0},{"$f":"数値データ入力!P31","v":0},{"$f":"数値データ入力!R31","v":0},{"$f":"数値データ入力!T31","v":0},{"$f":"数値データ入力!V31","v":0},{"$f":"数値データ入力!X31","v":0}]
[null,"自己資金",null,"－","－","－",{"$f":"数値データ入力!J32","v":0},{"$f":"数値データ入力!L32","v":0},{"$f":"数値データ入力!N32","v":0},{"$f":"数値データ入力!P32","v":0},{"$f":"数値データ入力!R32","v":0},{"$f":"数値データ入力!T32","v":0},{"$f":"数値データ入力!V32","v":0},{"$f":"数値データ入力!X32","v":0}]
[null,"その他",null,"－","－","－",{"$f":"数値データ入力!J33","v":0},{"$f":"数値データ入力!L33","v":0},{"$f":"数値データ入力!N33","v":0},{"$f":"数値データ入力!P33","v":0},{"$f":"数値データ入力!R33","v":0},{"$f":"数値データ入力!T33","v":0},{"$f":"数値データ入力!V33","v":0},{"$f":"数値データ入力!X33","v":0}]
[null,"　合　計",null,"－","－","－",{"$f":"SUM(G23:G26)","v":0},{"$f":"SUM(H23:H26)","v":0},0,0,0,0,0,0]
[null,null,null,null,null,null,{"$f":"IF(G25>-1,\" \",\"check!　⑨,⑩,⑮\")","v":" "},{"$f":"IF(H25>-1,\" \",\"check!　⑨,⑩,⑮\")","v":" "}," "," "," "," "," "," "]

{"sheet":"数値目標確認（自動出力）","index":3,"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$6","v":"( 年12月期)"},{"$f":"'申請書＜別表３＞（印刷用）'!$I$6","v":"( 年12月期)"},"（％）"]
[null,"売上高",null,{"$f":"'申請書＜別表３＞（印刷用）'!$F$7","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$I$7","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$8","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$I$8","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$10","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$I$10","v":0},"－"]
[null,"営業利益①",null,{"$f":"'申請書＜別表３＞（印刷用）'!$F$11","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$I$11","v":0},"－"]
[null,"経常利益",null,{"$f":"'申請書＜別表３＞（印刷用）'!$F$12","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$I$12","v":0},"－"]
[null,null,"人件費②",{"$f":"'申請書＜別表３＞（印刷用）'!$F$14","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$I$14","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$20","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$I$20","v":0},"－"]
[null,"１人あたり付加価値額(①＋②＋③)/④",null,{"$f":"'申請書＜別表３＞（印刷用）'!$F$22","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$I$22","v":0},"－"]
[null,"給与支給総額",null,{"$f":"'申請書＜別表３＞（印刷用）'!$F$13","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$I$13","v":0},"－"]
[]
[null,"４年計画"]
[null,null,null,"直近期末","目標最終期","伸び率"]
[null,null,null,{"$f":"'申請書＜別表３＞（印刷用）'!$F$6","v":"( 年12月期)"},{"$f":"'申請書＜別表３＞（印刷用）'!$J$6","v":"( 年12月期)"},"（％）"]
[null,"売上高",null,{"$f":"'申請書＜別表３＞（印刷用）'!$F$7","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$J$7","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$8","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$J$8","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$12","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$J$12","v":0},"－"]
[null,null,"人件費②",{"$f":"'申請書＜別表３＞（印刷用）'!$F$14","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$J$14","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$20","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$J$20","v":0},"－"]
[null,"１人あたり付加価値額(①＋②＋③)/④",null,{"$f":"'申請書＜別表３＞（印刷用）'!$F$22","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$J$22","v":0},"－"]
[null,"給与支給総額",null,{"$f":"'申請書＜別表３＞（印刷用）'!$F$13","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$J$13","v":0},"－"]
[]
[null,"５年計画"]
[null,null,null,"直近期末","目標最終期","伸び率"]
[null,null,null,{"$f":"'申請書＜別表３＞（印刷用）'!$F$6","v":"( 年12月期)"},{"$f":"'申請書＜別表３＞（印刷用）'!$K$6","v":"( 年12月期)"},"（％）"]
[null,"売上高",null,{"$f":"'申請書＜別表３＞（印刷用）'!$F$7","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$K$7","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$8","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$K$8","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$10","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$K$10","v":0},"－"]
[null,"営業利益①",null,{"$f":"'申請書＜別表３＞（印刷用）'!$F$11","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$K$11","v":0},"－"]
[null,"経常利益",null,{"$f":"'申請書＜別表３＞（印刷用）'!$F$12","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$K$12","v":0},"－"]
[null,null,"人件費②",{"$f":"'申請書＜別表３＞（印刷用）'!$F$14","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$K$14","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$20","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$K$20","v":0},"－"]
[null,"１人あたり付加価値額(①＋②＋③)/④",null,{"$f":"'申請書＜別表３＞（印刷用）'!$F$22","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$K$22","v":0},"－"]
[null,"給与支給総額",null,{"$f":"'申請書＜別表３＞（印刷用）'!$F$13","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$K$13","v":0},"－"]
[]
[null,"６年計画"]
[null,null,null,"直近期末","目標最終期","伸び率"]
[null,null,null,{"$f":"'申請書＜別表３＞（印刷用）'!$F$6","v":"( 年12月期)"},{"$f":"'申請書＜別表３＞（印刷用）'!L6","v":"( 年12月期)"},"（％）"]
[null,"売上高",null,{"$f":"'申請書＜別表３＞（印刷用）'!$F$7","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$L$7","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$8","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$L$8","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$10","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$L$10","v":0},"－"]
[null,"営業利益①",null,{"$f":"'申請書＜別表３＞（印刷用）'!$F$11","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$L$11","v":0},"－"]
[null,"経常利益",null,{"$f":"'申請書＜別表３＞（印刷用）'!$F$12","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$L$12","v":0},"－"]
[null,null,"人件費②",{"$f":"'申請書＜別表３＞（印刷用）'!$F$14","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$L$14","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$20","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$L$20","v":0},"－"]
[null,"１人あたり付加価値額(①＋②＋③)/④",null,{"$f":"'申請書＜別表３＞（印刷用）'!$F$22","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$L$22","v":0},"－"]
[null,"給与支給総額",null,{"$f":"'申請書＜別表３＞（印刷用）'!$F$13","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$L$13","v":0},"－"]
[]
[null,"７年計画"]
[null,null,null,"直近期末","目標最終期","伸び率"]
[null,null,null,{"$f":"'申請書＜別表３＞（印刷用）'!$F$6","v":"( 年12月期)"},{"$f":"'申請書＜別表３＞（印刷用）'!$M$6","v":"( 年12月期)"},"（％）"]
[null,"売上高",null,{"$f":"'申請書＜別表３＞（印刷用）'!$F$7","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$M$7","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$8","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$M$8","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$10","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$M$10","v":0},"－"]
[null,"営業利益①",null,{"$f":"'申請書＜別表３＞（印刷用）'!$F$11","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$M$11","v":0},"－"]
[null,"経常利益",null,{"$f":"'申請書＜別表３＞（印刷用）'!$F$12","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$M$12","v":0},"－"]
[null,null,"人件費②",{"$f":"'申請書＜別表３＞（印刷用）'!$F$14","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$M$14","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$20","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$M$20","v":0},"－"]
[null,"１人あたり付加価値額(①＋②＋③)/④",null,{"$f":"'申請書＜別表３＞（印刷用）'!$F$22","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$M$22","v":0},"－"]
[null,"給与支給総額",null,{"$f":"'申請書＜別表３＞（印刷用）'!$F$13","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$M$13","v":0},"－"]
[]
[null,"８年計画"]
[null,null,null,"直近期末","目標最終期","伸び率"]
[null,null,null,{"$f":"'申請書＜別表３＞（印刷用）'!$F$6","v":"( 年12月期)"},{"$f":"'申請書＜別表３＞（印刷用）'!$N$6","v":"( 年12月期)"},"（％）"]
[null,"売上高",null,{"$f":"'申請書＜別表３＞（印刷用）'!$F$7","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$N$7","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$8","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$N$8","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$10","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$N$10","v":0},"－"]
[null,"営業利益①",null,{"$f":"'申請書＜別表３＞（印刷用）'!$F$11","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$N$11","v":0},"－"]
[null,"経常利益",null,{"$f":"'申請書＜別表３＞（印刷用）'!$F$12","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$N$12","v":0},"－"]
[null,null,"人件費②",{"$f":"'申請書＜別表３＞（印刷用）'!$F$14","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$N$14","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$20","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$N$20","v":0},"－"]
[null,"１人あたり付加価値額(①＋②＋③)/④",null,{"$f":"'申請書＜別表３＞（印刷用）'!$F$22","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$N$22","v":0},"－"]
[null,"給与支給総額",null,{"$f":"'申請書＜別表３＞（印刷用）'!$F$13","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!$N$13","v":0},"－"]

{"sheet":"別表3インポート用マクロ","index":4,"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":"'申請書＜別表３＞（印刷用）'!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":"'申請書＜別表３＞（印刷用）'!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}]
["③売上総利益（①－②）",{"$f":"IFERROR(B28-B29,0)","v":0},{"$f":"IFERROR(C28-C29,0)","v":0},0,0,0,0,0,0,0,0,0]
["④販売費及び一般管理費",{"$f":"'申請書＜別表３＞（印刷用）'!D10","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!E10","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!F10","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!G10","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!H10","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!I10","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!J10","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!K10","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!L10","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!M10","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!N10","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":"'申請書＜別表３＞（印刷用）'!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":"'申請書＜別表３＞（印刷用）'!D14","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!E14","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!F14","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!G14","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!H14","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!I14","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!J14","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!K14","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!L14","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!M14","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!N14","v":0}]
["⑨設備投資額","-","-","-",{"$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":"'申請書＜別表３＞（印刷用）'!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":"IFERROR(B39+B40,0)","v":0},{"$f":"IFERROR(C39+C40,0)","v":0},0,0,0,0,0,0,0,0,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":"'申請書＜別表３＞（印刷用）'!D18","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!E18","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!F18","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!G18","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!H18","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!I18","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!J18","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!K18","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!L18","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!M18","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!N18","v":0}]
["⑫付加価値額（⑤＋⑧＋⑪）",{"$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":"'申請書＜別表３＞（印刷用）'!D21","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!E21","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!F21","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!G21","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!H21","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!I21","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!J21","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!K21","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!L21","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!M21","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!N21","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":"'申請書＜別表３＞（印刷用）'!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}]
["その他","-","-","-",{"$f":"'申請書＜別表３＞（印刷用）'!G26","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!H26","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!I26","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!J26","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!K26","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!L26","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!M26","v":0},{"$f":"'申請書＜別表３＞（印刷用）'!N26","v":0}]
["注意事項"]
["・表内のセルに「半角マイナス（-）」、「半角カンマ（,）」、「小数点（.）」以外の記号が含まれないよう、参照元の値を修正してください。"]
["・変換されたファイルを保存する際、保存するフォルダ内に同名ファイルがある場合は警告なく上書き保存されます。"]

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