{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["ＴＯＰ","基本情報","従業員情報","給与入力","別表６（２３）","別表６（２３）Ｈ３０","別表６（２３）付表１Ｈ３０","計算基礎シート"],"not_rendered":{"charts":0,"images":14,"macros":1,"external_links":0,"defined_names":3,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"ＴＯＰ","index":0,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,5],[31,2,32,5],[34,2,35,5],[25,2,27,5],[28,2,30,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,"上記別表６（２３）を、平成30年４月以後終了事業年度分の別表６（２３）形式にしたものです。"]
[]
[null,null," ",null,null,"上記別表６（２３）を、平成30年４月以後終了事業年度分の別表６（２３）付表１形式にしたものです。"]
[]
[]
[null,null,null,null,null,"提供：小林敬幸税理士事務所"]
[null,null,null,null,null,"Ver. 1.0"]
[null,"★当事務所の税理士の著書"]
[]
[null,null,"帳簿初心者な方向けに、パソコン会計で徹底的に簡単に青色申告を行うためのTipsを詰め込んだ、自信の一作です！"]
[]
[]
[null,null,"★参考\nこのファイルの保護パスワードは、こちらの本の背面の２つめのバーコードの数字（1922で始まる１３ケタの数字（半角））になっています。マクロを有効にすると、保護を解除しなくともすべての機能は使えますが、保護を解除して改造等挑戦される方は是非本書もお求めください。"]
[]
[]
[null,null,"個人事業を会社にした場合の税金や社会保険料の変化が、誰でも簡単にシミュレーションできるソフトが付録についた、法人成りのノウハウ満載のマニュアル本です！"]

{"sheet":"基本情報","index":1,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[[16,1,17,1],[24,1,25,1],[11,1,12,1]]}
[]
[]
[]
[]
[]
[]
[null,"会社名","株式会社今野デザイン"]
[]
[null,"中小企業に該当するか","該当",{"$f":"IF(C9=\"該当\",20,10)","v":20},null,null,null,null,null,null,null,"中小法人","大法人"]
[null,null,null,"期首日","2015-04-01","2016-04-01","2017-04-01","2018-04-01","月数","前事業年度月数",null,{"$f":"IF(D11<E10,0.02,0.03)","v":0.03},{"$f":"IF(D11<E10,0.02,IF(D11<F10,0.03,IF(D11<G10,0.04,0.05)))","v":0.05}]
[null,"計算事業年度の期末日","2018-09-30",{"$f":"EOMONTH(C11,-12)+1","v":"2017-10-01"},{"$f":"IF(C9=\"該当\",L10,M10)","v":0.03},null,{"$f":"IF(C20>=D11,\"-\",EOMONTH(D11,-13)+1)","v":"2016-10-01"},{"$f":"IF(C20>=D11,\"-\",EOMONTH(G11,11))","v":"2017-09-30"},{"$f":"MIN(DATEDIF(D11,C11,\"M\")+1,DATEDIF(C20,C11,\"M\")+1)","v":12},{"$f":"IF(C20>=D11,\"-\",DATEDIF(G11,H11,\"M\")+1)","v":12}]
[null,"計算事業年度の期首日",{"$f":"D11","v":"2017-10-01"}]
[null,null,{"$f":"IF(C12>=42826,\"平成２９年４月以降開始\",\"平成２９年３月以前開始\")","v":"平成２９年４月以降開始"},{"$f":"IF(C12>=42826,1,0)","v":1}]
[null,null,null,null,null,null,"前年度期首日","前年度期末日"]
[null,"法人の設立日","平成25年３月31日以前",{"$f":"IF(C15=\"平成25年３月31日以前\",1,0)","v":1}]
[]
[null,"基準年度",{"$f":"IF(D15=1,G17,\"-\")","v":"2012-10-01"},{"$f":"\"2013/\"&MONTH(D11)&\"/\"&DAY(D11)","v":"2013/10/1"},{"$f":"VALUE(D17)","v":"2013-10-01"},"2013-04-01",{"$f":"IF(E17>=F17,EOMONTH(E17,-13)+1,E17)","v":"2012-10-01"},null,"月数"]
[null,null,{"$f":"IF(D15=1,EOMONTH(C17,11),\"-\")","v":"2013-09-30"},null,null,null,null,null,{"$f":"IF(D15=1,DATEDIF(C17,C18,\"M\")+1,\"-\")","v":12}]
[null,null,null,null,null,"期末日"]
[null,"基準年度がない\n場合の法人設立日",null,{"$f":"YEAR(C20)&\"/\"&MONTH(C11)&\"/\"&DAY(C11)","v":"1900/9/30"},{"$f":"VALUE(D20)","v":"1900-09-30"},{"$f":"IF(C20<E20,E20,EOMONTH(E20,12))","v":"1900-09-30"},{"$f":"DATEDIF(C20,F20,\"M\")+1","v":9}]
[null,"設立年度の\n雇用者給与等支給額",null,{"$f":"ROUNDDOWN(C21*0.7,0)","v":0}]
[]
[]
[null,"経過年度の摘要の有無","有"]
[null,"経過年度"]

{"sheet":"従業員情報","index":2,"n_rows":38,"n_cols":14,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"No.","従業員名","役員・使用人兼務役員\n特殊関係者","国内雇用者","雇用保険\n一般被保険者","一般被保険者\nとなった月","一般被保険者\nでなくなった月","一般被保険者で\nなくなった理由","なった月\n判定","一般被保険者\nとなった月","一般被保険者\nでなくなった月","継続雇用者","なくなった月\n判定"]
[null,1,"今野　友夫","該当",null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(G6,計算基礎シート!I$5:J$28,2,FALSE)),2,VLOOKUP(G6,計算基礎シート!I$5:J$28,2,FALSE))","v":2},{"$f":"IF(ISERROR(VLOOKUP(G6,計算基礎シート!$C$5:$D$28,2,FALSE)),\"\",VLOOKUP(G6,計算基礎シート!$C$5:$D$28,2,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(H6,計算基礎シート!$F$3:$G$28,2,FALSE)),\"\",VLOOKUP(H6,計算基礎シート!$F$3:$G$28,2,FALSE))","v":""},{"$f":"IF(AND(J6=1,N6=1),\"該当\",\"\")","v":""},{"$f":"IF(ISERROR(VLOOKUP(L6,計算基礎シート!G$5:H$28,2,FALSE)),2,VLOOKUP(L6,計算基礎シート!G$5:H$28,2,FALSE))","v":2}]
[null,2,"今野　朝子","該当",null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(G7,計算基礎シート!I$5:J$28,2,FALSE)),2,VLOOKUP(G7,計算基礎シート!I$5:J$28,2,FALSE))","v":2},{"$f":"IF(ISERROR(VLOOKUP(G7,計算基礎シート!$C$5:$D$28,2,FALSE)),\"\",VLOOKUP(G7,計算基礎シート!$C$5:$D$28,2,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(H7,計算基礎シート!$F$3:$G$28,2,FALSE)),\"\",VLOOKUP(H7,計算基礎シート!$F$3:$G$28,2,FALSE))","v":""},{"$f":"IF(AND(J7=1,N7=1),\"該当\",\"\")","v":""},{"$f":"IF(ISERROR(VLOOKUP(L7,計算基礎シート!G$5:H$28,2,FALSE)),2,VLOOKUP(L7,計算基礎シート!G$5:H$28,2,FALSE))","v":2}]
[null,3,"今野　祥子","該当",null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(G8,計算基礎シート!I$5:J$28,2,FALSE)),2,VLOOKUP(G8,計算基礎シート!I$5:J$28,2,FALSE))","v":2},{"$f":"IF(ISERROR(VLOOKUP(G8,計算基礎シート!$C$5:$D$28,2,FALSE)),\"\",VLOOKUP(G8,計算基礎シート!$C$5:$D$28,2,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(H8,計算基礎シート!$F$3:$G$28,2,FALSE)),\"\",VLOOKUP(H8,計算基礎シート!$F$3:$G$28,2,FALSE))","v":""},"",{"$f":"IF(ISERROR(VLOOKUP(L8,計算基礎シート!G$5:H$28,2,FALSE)),2,VLOOKUP(L8,計算基礎シート!G$5:H$28,2,FALSE))","v":2}]
[null,4,"川西　めぐみ","非該当","該当","該当","2016年10月以前","在職中",null,{"$f":"IF(ISERROR(VLOOKUP(G9,計算基礎シート!I$5:J$28,2,FALSE)),2,VLOOKUP(G9,計算基礎シート!I$5:J$28,2,FALSE))","v":1},{"$f":"IF(ISERROR(VLOOKUP(G9,計算基礎シート!$C$5:$D$28,2,FALSE)),\"\",VLOOKUP(G9,計算基礎シート!$C$5:$D$28,2,FALSE))","v":"2016-10-01"},{"$f":"IF(ISERROR(VLOOKUP(H9,計算基礎シート!$F$3:$G$28,2,FALSE)),\"\",VLOOKUP(H9,計算基礎シート!$F$3:$G$28,2,FALSE))","v":"2018-09-30"},"該当",{"$f":"IF(ISERROR(VLOOKUP(L9,計算基礎シート!G$5:H$28,2,FALSE)),2,VLOOKUP(L9,計算基礎シート!G$5:H$28,2,FALSE))","v":1}]
[null,5,"鳥居　雅之","非該当","該当","非該当",null,null,null,{"$f":"IF(ISERROR(VLOOKUP(G10,計算基礎シート!I$5:J$28,2,FALSE)),2,VLOOKUP(G10,計算基礎シート!I$5:J$28,2,FALSE))","v":2},{"$f":"IF(ISERROR(VLOOKUP(G10,計算基礎シート!$C$5:$D$28,2,FALSE)),\"\",VLOOKUP(G10,計算基礎シート!$C$5:$D$28,2,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(H10,計算基礎シート!$F$3:$G$28,2,FALSE)),\"\",VLOOKUP(H10,計算基礎シート!$F$3:$G$28,2,FALSE))","v":""},"",{"$f":"IF(ISERROR(VLOOKUP(L10,計算基礎シート!G$5:H$28,2,FALSE)),2,VLOOKUP(L10,計算基礎シート!G$5:H$28,2,FALSE))","v":2}]
[null,6,"絹延橋　みつ子","非該当","該当","該当","2016年10月以前","2018年7月","退職",{"$f":"IF(ISERROR(VLOOKUP(G11,計算基礎シート!I$5:J$28,2,FALSE)),2,VLOOKUP(G11,計算基礎シート!I$5:J$28,2,FALSE))","v":1},{"$f":"IF(ISERROR(VLOOKUP(G11,計算基礎シート!$C$5:$D$28,2,FALSE)),\"\",VLOOKUP(G11,計算基礎シート!$C$5:$D$28,2,FALSE))","v":"2016-10-01"},{"$f":"IF(ISERROR(VLOOKUP(H11,計算基礎シート!$F$3:$G$28,2,FALSE)),\"\",VLOOKUP(H11,計算基礎シート!$F$3:$G$28,2,FALSE))","v":"2018-07-31"},"該当",{"$f":"IF(ISERROR(VLOOKUP(L11,計算基礎シート!G$5:H$28,2,FALSE)),2,VLOOKUP(L11,計算基礎シート!G$5:H$28,2,FALSE))","v":1}]
[null,7,"笹部　菜穂美","非該当","該当","該当","2018年4月","在職中",null,{"$f":"IF(ISERROR(VLOOKUP(G12,計算基礎シート!I$5:J$28,2,FALSE)),2,VLOOKUP(G12,計算基礎シート!I$5:J$28,2,FALSE))","v":2},{"$f":"IF(ISERROR(VLOOKUP(G12,計算基礎シート!$C$5:$D$28,2,FALSE)),\"\",VLOOKUP(G12,計算基礎シート!$C$5:$D$28,2,FALSE))","v":"2018-04-30"},{"$f":"IF(ISERROR(VLOOKUP(H12,計算基礎シート!$F$3:$G$28,2,FALSE)),\"\",VLOOKUP(H12,計算基礎シート!$F$3:$G$28,2,FALSE))","v":"2018-09-30"},"",{"$f":"IF(ISERROR(VLOOKUP(L12,計算基礎シート!G$5:H$28,2,FALSE)),2,VLOOKUP(L12,計算基礎シート!G$5:H$28,2,FALSE))","v":1}]
[null,8,"山下　典子","非該当","該当","該当","2016年11月","在職中",null,{"$f":"IF(ISERROR(VLOOKUP(G13,計算基礎シート!I$5:J$28,2,FALSE)),2,VLOOKUP(G13,計算基礎シート!I$5:J$28,2,FALSE))","v":1},{"$f":"IF(ISERROR(VLOOKUP(G13,計算基礎シート!$C$5:$D$28,2,FALSE)),\"\",VLOOKUP(G13,計算基礎シート!$C$5:$D$28,2,FALSE))","v":"2016-11-30"},{"$f":"IF(ISERROR(VLOOKUP(H13,計算基礎シート!$F$3:$G$28,2,FALSE)),\"\",VLOOKUP(H13,計算基礎シート!$F$3:$G$28,2,FALSE))","v":"2018-09-30"},"該当",{"$f":"IF(ISERROR(VLOOKUP(L13,計算基礎シート!G$5:H$28,2,FALSE)),2,VLOOKUP(L13,計算基礎シート!G$5:H$28,2,FALSE))","v":1}]
[null,9,"畦野　保則","非該当","該当","該当","2016年10月以前","2018年5月","継続雇用制度に移行",{"$f":"IF(ISERROR(VLOOKUP(G14,計算基礎シート!I$5:J$28,2,FALSE)),2,VLOOKUP(G14,計算基礎シート!I$5:J$28,2,FALSE))","v":1},{"$f":"IF(ISERROR(VLOOKUP(G14,計算基礎シート!$C$5:$D$28,2,FALSE)),\"\",VLOOKUP(G14,計算基礎シート!$C$5:$D$28,2,FALSE))","v":"2016-10-01"},{"$f":"IF(ISERROR(VLOOKUP(H14,計算基礎シート!$F$3:$G$28,2,FALSE)),\"\",VLOOKUP(H14,計算基礎シート!$F$3:$G$28,2,FALSE))","v":"2018-05-31"},"該当",{"$f":"IF(ISERROR(VLOOKUP(L14,計算基礎シート!G$5:H$28,2,FALSE)),2,VLOOKUP(L14,計算基礎シート!G$5:H$28,2,FALSE))","v":1}]
[null,10,"滝山　隆一","非該当","該当","該当","2016年10月以前","2017年7月","継続雇用制度に移行",{"$f":"IF(ISERROR(VLOOKUP(G15,計算基礎シート!I$5:J$28,2,FALSE)),2,VLOOKUP(G15,計算基礎シート!I$5:J$28,2,FALSE))","v":1},{"$f":"IF(ISERROR(VLOOKUP(G15,計算基礎シート!$C$5:$D$28,2,FALSE)),\"\",VLOOKUP(G15,計算基礎シート!$C$5:$D$28,2,FALSE))","v":"2016-10-01"},{"$f":"IF(ISERROR(VLOOKUP(H15,計算基礎シート!$F$3:$G$28,2,FALSE)),\"\",VLOOKUP(H15,計算基礎シート!$F$3:$G$28,2,FALSE))","v":"2017-07-31"},"",{"$f":"IF(ISERROR(VLOOKUP(L15,計算基礎シート!G$5:H$28,2,FALSE)),2,VLOOKUP(L15,計算基礎シート!G$5:H$28,2,FALSE))","v":2}]
[null,11,null,"該当",null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(G16,計算基礎シート!I$5:J$28,2,FALSE)),2,VLOOKUP(G16,計算基礎シート!I$5:J$28,2,FALSE))","v":2},{"$f":"IF(ISERROR(VLOOKUP(G16,計算基礎シート!$C$5:$D$28,2,FALSE)),\"\",VLOOKUP(G16,計算基礎シート!$C$5:$D$28,2,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(H16,計算基礎シート!$F$3:$G$28,2,FALSE)),\"\",VLOOKUP(H16,計算基礎シート!$F$3:$G$28,2,FALSE))","v":""},"",{"$f":"IF(ISERROR(VLOOKUP(L16,計算基礎シート!G$5:H$28,2,FALSE)),2,VLOOKUP(L16,計算基礎シート!G$5:H$28,2,FALSE))","v":2}]
[null,12,null,"該当",null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(G17,計算基礎シート!I$5:J$28,2,FALSE)),2,VLOOKUP(G17,計算基礎シート!I$5:J$28,2,FALSE))","v":2},{"$f":"IF(ISERROR(VLOOKUP(G17,計算基礎シート!$C$5:$D$28,2,FALSE)),\"\",VLOOKUP(G17,計算基礎シート!$C$5:$D$28,2,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(H17,計算基礎シート!$F$3:$G$28,2,FALSE)),\"\",VLOOKUP(H17,計算基礎シート!$F$3:$G$28,2,FALSE))","v":""},"",{"$f":"IF(ISERROR(VLOOKUP(L17,計算基礎シート!G$5:H$28,2,FALSE)),2,VLOOKUP(L17,計算基礎シート!G$5:H$28,2,FALSE))","v":2}]
[null,13,null,"該当",null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(G18,計算基礎シート!I$5:J$28,2,FALSE)),2,VLOOKUP(G18,計算基礎シート!I$5:J$28,2,FALSE))","v":2},{"$f":"IF(ISERROR(VLOOKUP(G18,計算基礎シート!$C$5:$D$28,2,FALSE)),\"\",VLOOKUP(G18,計算基礎シート!$C$5:$D$28,2,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(H18,計算基礎シート!$F$3:$G$28,2,FALSE)),\"\",VLOOKUP(H18,計算基礎シート!$F$3:$G$28,2,FALSE))","v":""},"",{"$f":"IF(ISERROR(VLOOKUP(L18,計算基礎シート!G$5:H$28,2,FALSE)),2,VLOOKUP(L18,計算基礎シート!G$5:H$28,2,FALSE))","v":2}]
[null,14,null,"該当",null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(G19,計算基礎シート!I$5:J$28,2,FALSE)),2,VLOOKUP(G19,計算基礎シート!I$5:J$28,2,FALSE))","v":2},{"$f":"IF(ISERROR(VLOOKUP(G19,計算基礎シート!$C$5:$D$28,2,FALSE)),\"\",VLOOKUP(G19,計算基礎シート!$C$5:$D$28,2,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(H19,計算基礎シート!$F$3:$G$28,2,FALSE)),\"\",VLOOKUP(H19,計算基礎シート!$F$3:$G$28,2,FALSE))","v":""},"",{"$f":"IF(ISERROR(VLOOKUP(L19,計算基礎シート!G$5:H$28,2,FALSE)),2,VLOOKUP(L19,計算基礎シート!G$5:H$28,2,FALSE))","v":2}]
[null,15,null,"該当",null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(G20,計算基礎シート!I$5:J$28,2,FALSE)),2,VLOOKUP(G20,計算基礎シート!I$5:J$28,2,FALSE))","v":2},{"$f":"IF(ISERROR(VLOOKUP(G20,計算基礎シート!$C$5:$D$28,2,FALSE)),\"\",VLOOKUP(G20,計算基礎シート!$C$5:$D$28,2,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(H20,計算基礎シート!$F$3:$G$28,2,FALSE)),\"\",VLOOKUP(H20,計算基礎シート!$F$3:$G$28,2,FALSE))","v":""},"",{"$f":"IF(ISERROR(VLOOKUP(L20,計算基礎シート!G$5:H$28,2,FALSE)),2,VLOOKUP(L20,計算基礎シート!G$5:H$28,2,FALSE))","v":2}]
[null,16,null,"該当",null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(G21,計算基礎シート!I$5:J$28,2,FALSE)),2,VLOOKUP(G21,計算基礎シート!I$5:J$28,2,FALSE))","v":2},{"$f":"IF(ISERROR(VLOOKUP(G21,計算基礎シート!$C$5:$D$28,2,FALSE)),\"\",VLOOKUP(G21,計算基礎シート!$C$5:$D$28,2,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(H21,計算基礎シート!$F$3:$G$28,2,FALSE)),\"\",VLOOKUP(H21,計算基礎シート!$F$3:$G$28,2,FALSE))","v":""},"",{"$f":"IF(ISERROR(VLOOKUP(L21,計算基礎シート!G$5:H$28,2,FALSE)),2,VLOOKUP(L21,計算基礎シート!G$5:H$28,2,FALSE))","v":2}]
[null,17,null,"該当",null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(G22,計算基礎シート!I$5:J$28,2,FALSE)),2,VLOOKUP(G22,計算基礎シート!I$5:J$28,2,FALSE))","v":2},{"$f":"IF(ISERROR(VLOOKUP(G22,計算基礎シート!$C$5:$D$28,2,FALSE)),\"\",VLOOKUP(G22,計算基礎シート!$C$5:$D$28,2,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(H22,計算基礎シート!$F$3:$G$28,2,FALSE)),\"\",VLOOKUP(H22,計算基礎シート!$F$3:$G$28,2,FALSE))","v":""},"",{"$f":"IF(ISERROR(VLOOKUP(L22,計算基礎シート!G$5:H$28,2,FALSE)),2,VLOOKUP(L22,計算基礎シート!G$5:H$28,2,FALSE))","v":2}]
[null,18,null,"該当",null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(G23,計算基礎シート!I$5:J$28,2,FALSE)),2,VLOOKUP(G23,計算基礎シート!I$5:J$28,2,FALSE))","v":2},{"$f":"IF(ISERROR(VLOOKUP(G23,計算基礎シート!$C$5:$D$28,2,FALSE)),\"\",VLOOKUP(G23,計算基礎シート!$C$5:$D$28,2,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(H23,計算基礎シート!$F$3:$G$28,2,FALSE)),\"\",VLOOKUP(H23,計算基礎シート!$F$3:$G$28,2,FALSE))","v":""},"",{"$f":"IF(ISERROR(VLOOKUP(L23,計算基礎シート!G$5:H$28,2,FALSE)),2,VLOOKUP(L23,計算基礎シート!G$5:H$28,2,FALSE))","v":2}]
[null,19,null,"該当",null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(G24,計算基礎シート!I$5:J$28,2,FALSE)),2,VLOOKUP(G24,計算基礎シート!I$5:J$28,2,FALSE))","v":2},{"$f":"IF(ISERROR(VLOOKUP(G24,計算基礎シート!$C$5:$D$28,2,FALSE)),\"\",VLOOKUP(G24,計算基礎シート!$C$5:$D$28,2,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(H24,計算基礎シート!$F$3:$G$28,2,FALSE)),\"\",VLOOKUP(H24,計算基礎シート!$F$3:$G$28,2,FALSE))","v":""},"",{"$f":"IF(ISERROR(VLOOKUP(L24,計算基礎シート!G$5:H$28,2,FALSE)),2,VLOOKUP(L24,計算基礎シート!G$5:H$28,2,FALSE))","v":2}]
[null,20,null,"該当",null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(G25,計算基礎シート!I$5:J$28,2,FALSE)),2,VLOOKUP(G25,計算基礎シート!I$5:J$28,2,FALSE))","v":2},{"$f":"IF(ISERROR(VLOOKUP(G25,計算基礎シート!$C$5:$D$28,2,FALSE)),\"\",VLOOKUP(G25,計算基礎シート!$C$5:$D$28,2,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(H25,計算基礎シート!$F$3:$G$28,2,FALSE)),\"\",VLOOKUP(H25,計算基礎シート!$F$3:$G$28,2,FALSE))","v":""},"",{"$f":"IF(ISERROR(VLOOKUP(L25,計算基礎シート!G$5:H$28,2,FALSE)),2,VLOOKUP(L25,計算基礎シート!G$5:H$28,2,FALSE))","v":2}]
[null,21,null,"該当",null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(G26,計算基礎シート!I$5:J$28,2,FALSE)),2,VLOOKUP(G26,計算基礎シート!I$5:J$28,2,FALSE))","v":2},{"$f":"IF(ISERROR(VLOOKUP(G26,計算基礎シート!$C$5:$D$28,2,FALSE)),\"\",VLOOKUP(G26,計算基礎シート!$C$5:$D$28,2,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(H26,計算基礎シート!$F$3:$G$28,2,FALSE)),\"\",VLOOKUP(H26,計算基礎シート!$F$3:$G$28,2,FALSE))","v":""},"",{"$f":"IF(ISERROR(VLOOKUP(L26,計算基礎シート!G$5:H$28,2,FALSE)),2,VLOOKUP(L26,計算基礎シート!G$5:H$28,2,FALSE))","v":2}]
[null,22,null,"該当",null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(G27,計算基礎シート!I$5:J$28,2,FALSE)),2,VLOOKUP(G27,計算基礎シート!I$5:J$28,2,FALSE))","v":2},{"$f":"IF(ISERROR(VLOOKUP(G27,計算基礎シート!$C$5:$D$28,2,FALSE)),\"\",VLOOKUP(G27,計算基礎シート!$C$5:$D$28,2,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(H27,計算基礎シート!$F$3:$G$28,2,FALSE)),\"\",VLOOKUP(H27,計算基礎シート!$F$3:$G$28,2,FALSE))","v":""},"",{"$f":"IF(ISERROR(VLOOKUP(L27,計算基礎シート!G$5:H$28,2,FALSE)),2,VLOOKUP(L27,計算基礎シート!G$5:H$28,2,FALSE))","v":2}]
[null,23,null,"該当",null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(G28,計算基礎シート!I$5:J$28,2,FALSE)),2,VLOOKUP(G28,計算基礎シート!I$5:J$28,2,FALSE))","v":2},{"$f":"IF(ISERROR(VLOOKUP(G28,計算基礎シート!$C$5:$D$28,2,FALSE)),\"\",VLOOKUP(G28,計算基礎シート!$C$5:$D$28,2,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(H28,計算基礎シート!$F$3:$G$28,2,FALSE)),\"\",VLOOKUP(H28,計算基礎シート!$F$3:$G$28,2,FALSE))","v":""},"",{"$f":"IF(ISERROR(VLOOKUP(L28,計算基礎シート!G$5:H$28,2,FALSE)),2,VLOOKUP(L28,計算基礎シート!G$5:H$28,2,FALSE))","v":2}]
[null,24,null,"該当",null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(G29,計算基礎シート!I$5:J$28,2,FALSE)),2,VLOOKUP(G29,計算基礎シート!I$5:J$28,2,FALSE))","v":2},{"$f":"IF(ISERROR(VLOOKUP(G29,計算基礎シート!$C$5:$D$28,2,FALSE)),\"\",VLOOKUP(G29,計算基礎シート!$C$5:$D$28,2,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(H29,計算基礎シート!$F$3:$G$28,2,FALSE)),\"\",VLOOKUP(H29,計算基礎シート!$F$3:$G$28,2,FALSE))","v":""},"",{"$f":"IF(ISERROR(VLOOKUP(L29,計算基礎シート!G$5:H$28,2,FALSE)),2,VLOOKUP(L29,計算基礎シート!G$5:H$28,2,FALSE))","v":2}]
[null,25,null,"該当",null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(G30,計算基礎シート!I$5:J$28,2,FALSE)),2,VLOOKUP(G30,計算基礎シート!I$5:J$28,2,FALSE))","v":2},{"$f":"IF(ISERROR(VLOOKUP(G30,計算基礎シート!$C$5:$D$28,2,FALSE)),\"\",VLOOKUP(G30,計算基礎シート!$C$5:$D$28,2,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(H30,計算基礎シート!$F$3:$G$28,2,FALSE)),\"\",VLOOKUP(H30,計算基礎シート!$F$3:$G$28,2,FALSE))","v":""},"",{"$f":"IF(ISERROR(VLOOKUP(L30,計算基礎シート!G$5:H$28,2,FALSE)),2,VLOOKUP(L30,計算基礎シート!G$5:H$28,2,FALSE))","v":2}]
[null,26,null,"該当",null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(G31,計算基礎シート!I$5:J$28,2,FALSE)),2,VLOOKUP(G31,計算基礎シート!I$5:J$28,2,FALSE))","v":2},{"$f":"IF(ISERROR(VLOOKUP(G31,計算基礎シート!$C$5:$D$28,2,FALSE)),\"\",VLOOKUP(G31,計算基礎シート!$C$5:$D$28,2,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(H31,計算基礎シート!$F$3:$G$28,2,FALSE)),\"\",VLOOKUP(H31,計算基礎シート!$F$3:$G$28,2,FALSE))","v":""},"",{"$f":"IF(ISERROR(VLOOKUP(L31,計算基礎シート!G$5:H$28,2,FALSE)),2,VLOOKUP(L31,計算基礎シート!G$5:H$28,2,FALSE))","v":2}]
[null,27,null,"該当",null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(G32,計算基礎シート!I$5:J$28,2,FALSE)),2,VLOOKUP(G32,計算基礎シート!I$5:J$28,2,FALSE))","v":2},{"$f":"IF(ISERROR(VLOOKUP(G32,計算基礎シート!$C$5:$D$28,2,FALSE)),\"\",VLOOKUP(G32,計算基礎シート!$C$5:$D$28,2,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(H32,計算基礎シート!$F$3:$G$28,2,FALSE)),\"\",VLOOKUP(H32,計算基礎シート!$F$3:$G$28,2,FALSE))","v":""},"",{"$f":"IF(ISERROR(VLOOKUP(L32,計算基礎シート!G$5:H$28,2,FALSE)),2,VLOOKUP(L32,計算基礎シート!G$5:H$28,2,FALSE))","v":2}]
[null,28,null,"該当",null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(G33,計算基礎シート!I$5:J$28,2,FALSE)),2,VLOOKUP(G33,計算基礎シート!I$5:J$28,2,FALSE))","v":2},{"$f":"IF(ISERROR(VLOOKUP(G33,計算基礎シート!$C$5:$D$28,2,FALSE)),\"\",VLOOKUP(G33,計算基礎シート!$C$5:$D$28,2,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(H33,計算基礎シート!$F$3:$G$28,2,FALSE)),\"\",VLOOKUP(H33,計算基礎シート!$F$3:$G$28,2,FALSE))","v":""},"",{"$f":"IF(ISERROR(VLOOKUP(L33,計算基礎シート!G$5:H$28,2,FALSE)),2,VLOOKUP(L33,計算基礎シート!G$5:H$28,2,FALSE))","v":2}]
[null,29,null,"該当",null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(G34,計算基礎シート!I$5:J$28,2,FALSE)),2,VLOOKUP(G34,計算基礎シート!I$5:J$28,2,FALSE))","v":2},{"$f":"IF(ISERROR(VLOOKUP(G34,計算基礎シート!$C$5:$D$28,2,FALSE)),\"\",VLOOKUP(G34,計算基礎シート!$C$5:$D$28,2,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(H34,計算基礎シート!$F$3:$G$28,2,FALSE)),\"\",VLOOKUP(H34,計算基礎シート!$F$3:$G$28,2,FALSE))","v":""},"",{"$f":"IF(ISERROR(VLOOKUP(L34,計算基礎シート!G$5:H$28,2,FALSE)),2,VLOOKUP(L34,計算基礎シート!G$5:H$28,2,FALSE))","v":2}]
[null,30,null,"該当",null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(G35,計算基礎シート!I$5:J$28,2,FALSE)),2,VLOOKUP(G35,計算基礎シート!I$5:J$28,2,FALSE))","v":2},{"$f":"IF(ISERROR(VLOOKUP(G35,計算基礎シート!$C$5:$D$28,2,FALSE)),\"\",VLOOKUP(G35,計算基礎シート!$C$5:$D$28,2,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(H35,計算基礎シート!$F$3:$G$28,2,FALSE)),\"\",VLOOKUP(H35,計算基礎シート!$F$3:$G$28,2,FALSE))","v":""},"",{"$f":"IF(ISERROR(VLOOKUP(L35,計算基礎シート!G$5:H$28,2,FALSE)),2,VLOOKUP(L35,計算基礎シート!G$5:H$28,2,FALSE))","v":2}]
[]
["該当"]
["非該当"]

{"sheet":"給与入力","index":3,"n_rows":80,"n_cols":34,"rows_kept":80,"cut":false,"hidden":false,"merged":[[5,32,6,32],[25,32,32,32],[54,32,61,32]]}
[]
[]
[]
[null,"１、基準雇用者給与等支給額の入力"]
[null,"Ｎｏ．",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,"合計"]
[null,"名前",{"$f":"VLOOKUP(C5,従業員情報!$B$6:$C$35,2,FALSE)","v":"今野　友夫"},{"$f":"VLOOKUP(D5,従業員情報!$B$6:$C$35,2,FALSE)","v":"今野　朝子"},{"$f":"VLOOKUP(E5,従業員情報!$B$6:$C$35,2,FALSE)","v":"今野　祥子"},{"$f":"VLOOKUP(F5,従業員情報!$B$6:$C$35,2,FALSE)","v":"川西　めぐみ"},{"$f":"VLOOKUP(G5,従業員情報!$B$6:$C$35,2,FALSE)","v":"鳥居　雅之"},{"$f":"VLOOKUP(H5,従業員情報!$B$6:$C$35,2,FALSE)","v":"絹延橋　みつ子"},{"$f":"VLOOKUP(I5,従業員情報!$B$6:$C$35,2,FALSE)","v":"笹部　菜穂美"},{"$f":"VLOOKUP(J5,従業員情報!$B$6:$C$35,2,FALSE)","v":"山下　典子"},{"$f":"VLOOKUP(K5,従業員情報!$B$6:$C$35,2,FALSE)","v":"畦野　保則"},{"$f":"VLOOKUP(L5,従業員情報!$B$6:$C$35,2,FALSE)","v":"滝山　隆一"},{"$f":"VLOOKUP(M5,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(N5,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(O5,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(P5,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(Q5,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(R5,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(S5,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(T5,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(U5,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(V5,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(W5,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(X5,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(Y5,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(Z5,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(AA5,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(AB5,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(AC5,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(AD5,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(AE5,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(AF5,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"SUM(C7:AF7)","v":0}]
[null,"国内雇用者",{"$f":"IF(ISERROR(VLOOKUP(C5,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(C5,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(D5,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(D5,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(E5,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(E5,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(F5,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(F5,従業員情報!$B$6:$H$35,4,FALSE))","v":"該当"},{"$f":"IF(ISERROR(VLOOKUP(G5,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(G5,従業員情報!$B$6:$H$35,4,FALSE))","v":"該当"},{"$f":"IF(ISERROR(VLOOKUP(H5,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(H5,従業員情報!$B$6:$H$35,4,FALSE))","v":"該当"},{"$f":"IF(ISERROR(VLOOKUP(I5,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(I5,従業員情報!$B$6:$H$35,4,FALSE))","v":"該当"},{"$f":"IF(ISERROR(VLOOKUP(J5,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(J5,従業員情報!$B$6:$H$35,4,FALSE))","v":"該当"},{"$f":"IF(ISERROR(VLOOKUP(K5,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(K5,従業員情報!$B$6:$H$35,4,FALSE))","v":"該当"},{"$f":"IF(ISERROR(VLOOKUP(L5,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(L5,従業員情報!$B$6:$H$35,4,FALSE))","v":"該当"},{"$f":"IF(ISERROR(VLOOKUP(M5,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(M5,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(N5,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(N5,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(O5,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(O5,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(P5,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(P5,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(Q5,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(Q5,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(R5,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(R5,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(S5,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(S5,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(T5,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(T5,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(U5,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(U5,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(V5,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(V5,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(W5,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(W5,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(X5,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(X5,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(Y5,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(Y5,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(Z5,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(Z5,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(AA5,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(AA5,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(AB5,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(AB5,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(AC5,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(AC5,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(AD5,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(AD5,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(AE5,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(AE5,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(AF5,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(AF5,従業員情報!$B$6:$H$35,4,FALSE))","v":0}]
[null,{"$f":"基本情報!C17","v":"2012-10-01"},null,null,null,240000,30000,320500,null,null,185000,105000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C8:AF8)","v":880500}]
[null,{"$f":"IF($B$8=\"-\",\"-\",EOMONTH(B8,1))","v":"2012-11-30"},null,null,null,232000,50000,310500,null,null,192000,123000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C9:AF9)","v":907500}]
[null,{"$f":"IF($B$8=\"-\",\"-\",EOMONTH(B9,1))","v":"2012-12-31"},null,null,null,235000,40000,310200,null,null,178000,115000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,878200]
[null,"2013-01-31",null,null,null,242000,30000,320300,null,null,192000,178000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,962300]
[null,"2013-02-28",null,null,null,238000,20000,330000,null,null,168000,123500,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,879500]
[null,"2013-03-31",null,null,null,229000,50000,380000,null,null,173000,156000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,988000]
[null,"2013-04-30",null,null,null,228000,60000,320000,null,null,169000,165000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,942000]
[null,"2013-05-31",null,null,null,231000,80000,310500,null,null,185000,148000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,954500]
[null,"2013-06-30",null,null,null,240500,70000,300500,null,null,193000,132500,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,936500]
[null,"2013-07-31",null,null,null,229000,50000,320000,null,null,178000,180000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,957000]
[null,"2013-08-31",null,null,null,232000,60000,320550,null,null,172000,123000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,907550]
[null,"2013-09-30",null,null,null,239000,80000,320000,null,null,179000,178000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,996000]
[null,"賞与など",null,null,null,250000,20000,250000,null,null,150000,158000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,828000]
[null,"合計",{"$f":"SUM(C8:C20)","v":0},{"$f":"SUM(D8:D20)","v":0},0,3065500,640000,4113050,0,0,2314000,1885000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,12017550]
[]
[]
[null,"２、比較雇用者給与等支給額の入力"]
[null,"Ｎｏ．",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,"合計","月別継続\n雇用者数"]
[null,"名前",{"$f":"VLOOKUP(C25,従業員情報!$B$6:$C$35,2,FALSE)","v":"今野　友夫"},{"$f":"VLOOKUP(D25,従業員情報!$B$6:$C$35,2,FALSE)","v":"今野　朝子"},{"$f":"VLOOKUP(E25,従業員情報!$B$6:$C$35,2,FALSE)","v":"今野　祥子"},{"$f":"VLOOKUP(F25,従業員情報!$B$6:$C$35,2,FALSE)","v":"川西　めぐみ"},{"$f":"VLOOKUP(G25,従業員情報!$B$6:$C$35,2,FALSE)","v":"鳥居　雅之"},{"$f":"VLOOKUP(H25,従業員情報!$B$6:$C$35,2,FALSE)","v":"絹延橋　みつ子"},{"$f":"VLOOKUP(I25,従業員情報!$B$6:$C$35,2,FALSE)","v":"笹部　菜穂美"},{"$f":"VLOOKUP(J25,従業員情報!$B$6:$C$35,2,FALSE)","v":"山下　典子"},{"$f":"VLOOKUP(K25,従業員情報!$B$6:$C$35,2,FALSE)","v":"畦野　保則"},{"$f":"VLOOKUP(L25,従業員情報!$B$6:$C$35,2,FALSE)","v":"滝山　隆一"},{"$f":"VLOOKUP(M25,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(N25,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(O25,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(P25,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(Q25,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(R25,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(S25,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(T25,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(U25,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(V25,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(W25,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(X25,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(Y25,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(Z25,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(AA25,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(AB25,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(AC25,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(AD25,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(AE25,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(AF25,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"SUM(C27:AF27)","v":0}]
[null,"国内雇用者",{"$f":"IF(ISERROR(VLOOKUP(C25,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(C25,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(D25,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(D25,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(E25,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(E25,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(F25,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(F25,従業員情報!$B$6:$H$35,4,FALSE))","v":"該当"},{"$f":"IF(ISERROR(VLOOKUP(G25,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(G25,従業員情報!$B$6:$H$35,4,FALSE))","v":"該当"},{"$f":"IF(ISERROR(VLOOKUP(H25,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(H25,従業員情報!$B$6:$H$35,4,FALSE))","v":"該当"},{"$f":"IF(ISERROR(VLOOKUP(I25,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(I25,従業員情報!$B$6:$H$35,4,FALSE))","v":"該当"},{"$f":"IF(ISERROR(VLOOKUP(J25,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(J25,従業員情報!$B$6:$H$35,4,FALSE))","v":"該当"},{"$f":"IF(ISERROR(VLOOKUP(K25,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(K25,従業員情報!$B$6:$H$35,4,FALSE))","v":"該当"},{"$f":"IF(ISERROR(VLOOKUP(L25,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(L25,従業員情報!$B$6:$H$35,4,FALSE))","v":"該当"},{"$f":"IF(ISERROR(VLOOKUP(M25,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(M25,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(N25,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(N25,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(O25,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(O25,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(P25,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(P25,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(Q25,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(Q25,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(R25,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(R25,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(S25,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(S25,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(T25,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(T25,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(U25,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(U25,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(V25,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(V25,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(W25,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(W25,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(X25,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(X25,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(Y25,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(Y25,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(Z25,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(Z25,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(AA25,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(AA25,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(AB25,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(AB25,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(AC25,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(AC25,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(AD25,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(AD25,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(AE25,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(AE25,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(AF25,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(AF25,従業員情報!$B$6:$H$35,4,FALSE))","v":0}]
[null,"継続雇用者",{"$f":"IF(ISERROR(VLOOKUP(C25,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(C25,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(D25,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(D25,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(E25,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(E25,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(F25,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(F25,従業員情報!$B$6:$M$35,12,FALSE))","v":"該当"},{"$f":"IF(ISERROR(VLOOKUP(G25,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(G25,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(H25,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(H25,従業員情報!$B$6:$M$35,12,FALSE))","v":"該当"},{"$f":"IF(ISERROR(VLOOKUP(I25,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(I25,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(J25,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(J25,従業員情報!$B$6:$M$35,12,FALSE))","v":"該当"},{"$f":"IF(ISERROR(VLOOKUP(K25,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(K25,従業員情報!$B$6:$M$35,12,FALSE))","v":"該当"},{"$f":"IF(ISERROR(VLOOKUP(L25,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(L25,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(M25,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(M25,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(N25,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(N25,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(O25,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(O25,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(P25,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(P25,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(Q25,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(Q25,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(R25,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(R25,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(S25,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(S25,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(T25,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(T25,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(U25,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(U25,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(V25,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(V25,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(W25,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(W25,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(X25,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(X25,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(Y25,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(Y25,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(Z25,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(Z25,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AA25,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(AA25,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AB25,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(AB25,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AC25,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(AC25,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AD25,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(AD25,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AE25,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(AE25,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AF25,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(AF25,従業員情報!$B$6:$M$35,12,FALSE))","v":""}]
[null,"被保険者開始月",{"$f":"IF(ISERROR(VLOOKUP(C25,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(C25,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(D25,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(D25,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(E25,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(E25,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(F25,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(F25,従業員情報!$B$6:$M$35,10,FALSE))","v":"2016-10-01"},{"$f":"IF(ISERROR(VLOOKUP(G25,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(G25,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(H25,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(H25,従業員情報!$B$6:$M$35,10,FALSE))","v":"2016-10-01"},{"$f":"IF(ISERROR(VLOOKUP(I25,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(I25,従業員情報!$B$6:$M$35,10,FALSE))","v":"2018-04-30"},{"$f":"IF(ISERROR(VLOOKUP(J25,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(J25,従業員情報!$B$6:$M$35,10,FALSE))","v":"2016-11-30"},{"$f":"IF(ISERROR(VLOOKUP(K25,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(K25,従業員情報!$B$6:$M$35,10,FALSE))","v":"2016-10-01"},{"$f":"IF(ISERROR(VLOOKUP(L25,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(L25,従業員情報!$B$6:$M$35,10,FALSE))","v":"2016-10-01"},{"$f":"IF(ISERROR(VLOOKUP(M25,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(M25,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(N25,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(N25,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(O25,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(O25,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(P25,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(P25,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(Q25,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(Q25,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(R25,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(R25,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(S25,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(S25,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(T25,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(T25,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(U25,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(U25,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(V25,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(V25,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(W25,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(W25,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(X25,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(X25,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(Y25,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(Y25,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(Z25,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(Z25,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AA25,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(AA25,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AB25,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(AB25,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AC25,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(AC25,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AD25,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(AD25,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AE25,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(AE25,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AF25,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(AF25,従業員情報!$B$6:$M$35,10,FALSE))","v":""}]
[null,"被保険者終了月",{"$f":"IF(ISERROR(VLOOKUP(C25,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(C25,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(D25,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(D25,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(E25,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(E25,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(F25,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(F25,従業員情報!$B$6:$M$35,11,FALSE))","v":"2018-09-30"},{"$f":"IF(ISERROR(VLOOKUP(G25,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(G25,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(H25,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(H25,従業員情報!$B$6:$M$35,11,FALSE))","v":"2018-07-31"},{"$f":"IF(ISERROR(VLOOKUP(I25,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(I25,従業員情報!$B$6:$M$35,11,FALSE))","v":"2018-09-30"},{"$f":"IF(ISERROR(VLOOKUP(J25,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(J25,従業員情報!$B$6:$M$35,11,FALSE))","v":"2018-09-30"},{"$f":"IF(ISERROR(VLOOKUP(K25,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(K25,従業員情報!$B$6:$M$35,11,FALSE))","v":"2018-05-31"},{"$f":"IF(ISERROR(VLOOKUP(L25,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(L25,従業員情報!$B$6:$M$35,11,FALSE))","v":"2017-07-31"},{"$f":"IF(ISERROR(VLOOKUP(M25,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(M25,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(N25,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(N25,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(O25,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(O25,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(P25,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(P25,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(Q25,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(Q25,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(R25,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(R25,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(S25,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(S25,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(T25,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(T25,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(U25,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(U25,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(V25,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(V25,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(W25,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(W25,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(X25,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(X25,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(Y25,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(Y25,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(Z25,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(Z25,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AA25,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(AA25,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AB25,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(AB25,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AC25,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(AC25,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AD25,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(AD25,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AE25,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(AE25,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AF25,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(AF25,従業員情報!$B$6:$M$35,11,FALSE))","v":""}]
[null,"退職／継続雇用",{"$f":"IF(VLOOKUP(C25,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(C25,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(D25,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(D25,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(E25,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(E25,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(F25,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(F25,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(G25,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(G25,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(H25,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(H25,従業員情報!$B$6:$M$35,8,FALSE))","v":"退職"},{"$f":"IF(VLOOKUP(I25,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(I25,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(J25,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(J25,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(K25,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(K25,従業員情報!$B$6:$M$35,8,FALSE))","v":"継続雇用制度に移行"},{"$f":"IF(VLOOKUP(L25,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(L25,従業員情報!$B$6:$M$35,8,FALSE))","v":"継続雇用制度に移行"},{"$f":"IF(VLOOKUP(M25,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(M25,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(N25,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(N25,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(O25,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(O25,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(P25,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(P25,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(Q25,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(Q25,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(R25,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(R25,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(S25,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(S25,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(T25,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(T25,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(U25,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(U25,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(V25,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(V25,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(W25,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(W25,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(X25,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(X25,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(Y25,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(Y25,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(Z25,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(Z25,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(AA25,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(AA25,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(AB25,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(AB25,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(AC25,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(AC25,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(AD25,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(AD25,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(AE25,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(AE25,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(AF25,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(AF25,従業員情報!$B$6:$M$35,8,FALSE))","v":""}]
[null,"退職日",{"$f":"IF(C27<>\"該当\",\"\",IF(C31=\"退職\",C30,$B$45+1))","v":""},{"$f":"IF(D27<>\"該当\",\"\",IF(D31=\"退職\",D30,$B$45+1))","v":""},"","2017-10-01","2017-10-01","2018-07-31","2017-10-01","2017-10-01","2017-10-01","2017-10-01","","","","","","","","","","","","","","","","","","","",""]
[null,"継続雇用開始",{"$f":"IF(C27<>\"該当\",\"\",IF(C31=\"継続雇用制度に移行\",C30+1,$B$45+1))","v":""},{"$f":"IF(D27<>\"該当\",\"\",IF(D31=\"継続雇用制度に移行\",D30+1,$B$45+1))","v":""},"","2017-10-01","2017-10-01","2017-10-01","2017-10-01","2017-10-01","2018-06-01","2017-08-01","","","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"基本情報!G11","v":"2016-10-01"},null,null,null,220000,30000,230500,null,null,172000,165000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C34:AF34)","v":817500},{"$f":"COUNTIFS(C$28:AF$28,\"該当\",C34:AF34,\">0\",C$33:AF$33,\">\"&B34)","v":3}]
[null,{"$f":"EOMONTH(B34,1)","v":"2016-11-30"},null,null,null,232000,50000,237000,null,null,168000,183000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C35:AF35)","v":870000},{"$f":"COUNTIFS(C$28:AF$28,\"該当\",C35:AF35,\">0\",C$33:AF$33,\">\"&B35)","v":3}]
[null,{"$f":"EOMONTH(B35,1)","v":"2016-12-31"},null,null,null,235000,40000,230500,null,null,152000,156000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,813500,3]
[null,"2017-01-31",null,null,null,222000,30000,280300,null,null,193000,156000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,881300,3]
[null,"2017-02-28",null,null,null,238000,10000,290200,null,168000,168000,172000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1046200,4]
[null,"2017-03-31",null,null,null,229000,50000,290500,null,172000,121000,182000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1044500,4]
[null,"2017-04-30",null,null,null,228000,60000,280000,null,168000,158000,152500,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1046500,4]
[null,"2017-05-31",null,null,null,231000,80000,275600,null,198000,168000,132000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1084600,4]
[null,"2017-06-30",null,null,null,240500,20000,null,null,172000,189000,85000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,706500,3]
[null,"2017-07-31",null,null,null,259000,50000,null,null,182000,192000,93000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,776000,3]
[null,"2017-08-31",null,null,null,232000,60000,null,null,168000,179000,54000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,693000,3]
[null,"2017-09-30",null,null,null,219000,80000,null,null,199000,189000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,687000,3]
[null,"賞与など（雇用保険加入者）",null,null,null,250000,null,null,null,100000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,350000]
[null,"賞与など（継続雇用制度）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"賞与など（雇用保険非加入者）",null,null,null,null,20000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20000]
[null,"合計",{"$f":"SUM(C34:C48)","v":0},{"$f":"SUM(D34:D48)","v":0},0,3035500,580000,2114600,0,1527000,2049000,1530500,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AG34:AG48)","v":10836600},{"$f":"SUM(AH34:AH48)","v":40}]
[null,"うち継続雇用者の給与",{"$f":"IF(C28=\"該当\",SUM(C34:C45)+C46+C47,0)","v":0},{"$f":"IF(D28=\"該当\",SUM(D34:D45)+D46+D47,0)","v":0},0,3035500,0,2114600,0,1527000,2049000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C50:AF50)","v":8726100}]
[null,"うち継続雇用制度対象者の給与",{"$f":"IF(C28=\"該当\",SUMIFS(C34:C45,$B34:$B45,\">=\"&C33)+C47,0)","v":0},{"$f":"IF(D28=\"該当\",SUMIFS(D34:D45,$B34:$B45,\">=\"&D33)+D47,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C51:AF51)","v":0}]
[]
[null,"３、（適用年度）雇用者給与等支給額の入力"]
[null,"Ｎｏ．",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,"合計","月別継続\n雇用者数"]
[null,"名前",{"$f":"VLOOKUP(C54,従業員情報!$B$6:$C$35,2,FALSE)","v":"今野　友夫"},{"$f":"VLOOKUP(D54,従業員情報!$B$6:$C$35,2,FALSE)","v":"今野　朝子"},{"$f":"VLOOKUP(E54,従業員情報!$B$6:$C$35,2,FALSE)","v":"今野　祥子"},{"$f":"VLOOKUP(F54,従業員情報!$B$6:$C$35,2,FALSE)","v":"川西　めぐみ"},{"$f":"VLOOKUP(G54,従業員情報!$B$6:$C$35,2,FALSE)","v":"鳥居　雅之"},{"$f":"VLOOKUP(H54,従業員情報!$B$6:$C$35,2,FALSE)","v":"絹延橋　みつ子"},{"$f":"VLOOKUP(I54,従業員情報!$B$6:$C$35,2,FALSE)","v":"笹部　菜穂美"},{"$f":"VLOOKUP(J54,従業員情報!$B$6:$C$35,2,FALSE)","v":"山下　典子"},{"$f":"VLOOKUP(K54,従業員情報!$B$6:$C$35,2,FALSE)","v":"畦野　保則"},{"$f":"VLOOKUP(L54,従業員情報!$B$6:$C$35,2,FALSE)","v":"滝山　隆一"},{"$f":"VLOOKUP(M54,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(N54,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(O54,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(P54,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(Q54,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(R54,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(S54,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(T54,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(U54,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(V54,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(W54,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(X54,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(Y54,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(Z54,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(AA54,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(AB54,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(AC54,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(AD54,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(AE54,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"VLOOKUP(AF54,従業員情報!$B$6:$C$35,2,FALSE)","v":0},{"$f":"SUM(C56:AF56)","v":0}]
[null,"国内雇用者",{"$f":"IF(ISERROR(VLOOKUP(C54,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(C54,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(D54,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(D54,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(E54,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(E54,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(F54,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(F54,従業員情報!$B$6:$H$35,4,FALSE))","v":"該当"},{"$f":"IF(ISERROR(VLOOKUP(G54,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(G54,従業員情報!$B$6:$H$35,4,FALSE))","v":"該当"},{"$f":"IF(ISERROR(VLOOKUP(H54,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(H54,従業員情報!$B$6:$H$35,4,FALSE))","v":"該当"},{"$f":"IF(ISERROR(VLOOKUP(I54,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(I54,従業員情報!$B$6:$H$35,4,FALSE))","v":"該当"},{"$f":"IF(ISERROR(VLOOKUP(J54,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(J54,従業員情報!$B$6:$H$35,4,FALSE))","v":"該当"},{"$f":"IF(ISERROR(VLOOKUP(K54,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(K54,従業員情報!$B$6:$H$35,4,FALSE))","v":"該当"},{"$f":"IF(ISERROR(VLOOKUP(L54,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(L54,従業員情報!$B$6:$H$35,4,FALSE))","v":"該当"},{"$f":"IF(ISERROR(VLOOKUP(M54,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(M54,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(N54,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(N54,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(O54,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(O54,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(P54,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(P54,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(Q54,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(Q54,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(R54,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(R54,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(S54,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(S54,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(T54,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(T54,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(U54,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(U54,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(V54,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(V54,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(W54,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(W54,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(X54,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(X54,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(Y54,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(Y54,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(Z54,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(Z54,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(AA54,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(AA54,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(AB54,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(AB54,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(AC54,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(AC54,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(AD54,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(AD54,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(AE54,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(AE54,従業員情報!$B$6:$H$35,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(AF54,従業員情報!$B$6:$H$35,4,FALSE)),\"\",VLOOKUP(AF54,従業員情報!$B$6:$H$35,4,FALSE))","v":0}]
[null,"継続雇用者",{"$f":"IF(ISERROR(VLOOKUP(C54,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(C54,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(D54,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(D54,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(E54,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(E54,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(F54,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(F54,従業員情報!$B$6:$M$35,12,FALSE))","v":"該当"},{"$f":"IF(ISERROR(VLOOKUP(G54,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(G54,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(H54,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(H54,従業員情報!$B$6:$M$35,12,FALSE))","v":"該当"},{"$f":"IF(ISERROR(VLOOKUP(I54,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(I54,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(J54,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(J54,従業員情報!$B$6:$M$35,12,FALSE))","v":"該当"},{"$f":"IF(ISERROR(VLOOKUP(K54,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(K54,従業員情報!$B$6:$M$35,12,FALSE))","v":"該当"},{"$f":"IF(ISERROR(VLOOKUP(L54,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(L54,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(M54,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(M54,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(N54,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(N54,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(O54,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(O54,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(P54,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(P54,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(Q54,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(Q54,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(R54,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(R54,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(S54,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(S54,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(T54,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(T54,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(U54,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(U54,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(V54,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(V54,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(W54,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(W54,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(X54,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(X54,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(Y54,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(Y54,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(Z54,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(Z54,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AA54,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(AA54,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AB54,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(AB54,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AC54,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(AC54,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AD54,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(AD54,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AE54,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(AE54,従業員情報!$B$6:$M$35,12,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AF54,従業員情報!$B$6:$M$35,12,FALSE)),\"\",VLOOKUP(AF54,従業員情報!$B$6:$M$35,12,FALSE))","v":""}]
[null,"被保険者開始月",{"$f":"IF(ISERROR(VLOOKUP(C54,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(C54,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(D54,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(D54,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(E54,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(E54,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(F54,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(F54,従業員情報!$B$6:$M$35,10,FALSE))","v":"2016-10-01"},{"$f":"IF(ISERROR(VLOOKUP(G54,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(G54,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(H54,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(H54,従業員情報!$B$6:$M$35,10,FALSE))","v":"2016-10-01"},{"$f":"IF(ISERROR(VLOOKUP(I54,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(I54,従業員情報!$B$6:$M$35,10,FALSE))","v":"2018-04-30"},{"$f":"IF(ISERROR(VLOOKUP(J54,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(J54,従業員情報!$B$6:$M$35,10,FALSE))","v":"2016-11-30"},{"$f":"IF(ISERROR(VLOOKUP(K54,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(K54,従業員情報!$B$6:$M$35,10,FALSE))","v":"2016-10-01"},{"$f":"IF(ISERROR(VLOOKUP(L54,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(L54,従業員情報!$B$6:$M$35,10,FALSE))","v":"2016-10-01"},{"$f":"IF(ISERROR(VLOOKUP(M54,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(M54,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(N54,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(N54,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(O54,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(O54,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(P54,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(P54,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(Q54,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(Q54,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(R54,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(R54,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(S54,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(S54,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(T54,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(T54,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(U54,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(U54,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(V54,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(V54,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(W54,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(W54,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(X54,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(X54,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(Y54,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(Y54,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(Z54,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(Z54,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AA54,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(AA54,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AB54,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(AB54,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AC54,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(AC54,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AD54,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(AD54,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AE54,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(AE54,従業員情報!$B$6:$M$35,10,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AF54,従業員情報!$B$6:$M$35,10,FALSE)),\"\",VLOOKUP(AF54,従業員情報!$B$6:$M$35,10,FALSE))","v":""}]
[null,"被保険者終了月",{"$f":"IF(ISERROR(VLOOKUP(C54,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(C54,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(D54,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(D54,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(E54,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(E54,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(F54,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(F54,従業員情報!$B$6:$M$35,11,FALSE))","v":"2018-09-30"},{"$f":"IF(ISERROR(VLOOKUP(G54,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(G54,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(H54,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(H54,従業員情報!$B$6:$M$35,11,FALSE))","v":"2018-07-31"},{"$f":"IF(ISERROR(VLOOKUP(I54,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(I54,従業員情報!$B$6:$M$35,11,FALSE))","v":"2018-09-30"},{"$f":"IF(ISERROR(VLOOKUP(J54,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(J54,従業員情報!$B$6:$M$35,11,FALSE))","v":"2018-09-30"},{"$f":"IF(ISERROR(VLOOKUP(K54,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(K54,従業員情報!$B$6:$M$35,11,FALSE))","v":"2018-05-31"},{"$f":"IF(ISERROR(VLOOKUP(L54,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(L54,従業員情報!$B$6:$M$35,11,FALSE))","v":"2017-07-31"},{"$f":"IF(ISERROR(VLOOKUP(M54,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(M54,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(N54,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(N54,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(O54,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(O54,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(P54,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(P54,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(Q54,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(Q54,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(R54,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(R54,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(S54,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(S54,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(T54,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(T54,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(U54,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(U54,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(V54,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(V54,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(W54,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(W54,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(X54,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(X54,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(Y54,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(Y54,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(Z54,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(Z54,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AA54,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(AA54,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AB54,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(AB54,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AC54,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(AC54,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AD54,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(AD54,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AE54,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(AE54,従業員情報!$B$6:$M$35,11,FALSE))","v":""},{"$f":"IF(ISERROR(VLOOKUP(AF54,従業員情報!$B$6:$M$35,11,FALSE)),\"\",VLOOKUP(AF54,従業員情報!$B$6:$M$35,11,FALSE))","v":""}]
[null,"退職／継続雇用",{"$f":"IF(VLOOKUP(C54,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(C54,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(D54,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(D54,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(E54,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(E54,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(F54,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(F54,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(G54,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(G54,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(H54,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(H54,従業員情報!$B$6:$M$35,8,FALSE))","v":"退職"},{"$f":"IF(VLOOKUP(I54,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(I54,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(J54,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(J54,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(K54,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(K54,従業員情報!$B$6:$M$35,8,FALSE))","v":"継続雇用制度に移行"},{"$f":"IF(VLOOKUP(L54,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(L54,従業員情報!$B$6:$M$35,8,FALSE))","v":"継続雇用制度に移行"},{"$f":"IF(VLOOKUP(M54,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(M54,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(N54,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(N54,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(O54,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(O54,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(P54,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(P54,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(Q54,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(Q54,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(R54,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(R54,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(S54,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(S54,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(T54,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(T54,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(U54,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(U54,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(V54,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(V54,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(W54,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(W54,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(X54,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(X54,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(Y54,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(Y54,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(Z54,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(Z54,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(AA54,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(AA54,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(AB54,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(AB54,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(AC54,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(AC54,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(AD54,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(AD54,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(AE54,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(AE54,従業員情報!$B$6:$M$35,8,FALSE))","v":""},{"$f":"IF(VLOOKUP(AF54,従業員情報!$B$6:$M$35,8,FALSE)=\"\",\"\",VLOOKUP(AF54,従業員情報!$B$6:$M$35,8,FALSE))","v":""}]
[null,"退職日",{"$f":"IF(C56<>\"該当\",\"\",IF(C60=\"退職\",C59,$B$74+1))","v":""},{"$f":"IF(D56<>\"該当\",\"\",IF(D60=\"退職\",D59,$B$74+1))","v":""},"","2018-10-01","2018-10-01","2018-07-31","2018-10-01","2018-10-01","2018-10-01","2018-10-01","","","","","","","","","","","","","","","","","","","",""]
[null,"継続雇用開始",{"$f":"IF(C56<>\"該当\",\"\",IF(C60=\"継続雇用制度に移行\",C59+1,$B$74+1))","v":""},{"$f":"IF(D56<>\"該当\",\"\",IF(D60=\"継続雇用制度に移行\",D59+1,$B$74+1))","v":""},"","2018-10-01","2018-10-01","2018-10-01","2018-10-01","2018-10-01","2018-06-01","2017-08-01","","","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"基本情報!D11","v":"2017-10-01"},null,null,null,383000,20000,null,null,308000,172000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C63:AF63)","v":883000},{"$f":"COUNTIFS(C$57:AF$57,\"該当\",C63:AF63,\">0\",C$62:AF$62,\">\"&B63)","v":3}]
[null,{"$f":"EOMONTH(B63,1)","v":"2017-11-30"},null,null,null,361400,60000,null,null,293000,168000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C64:AF64)","v":882400},{"$f":"COUNTIFS(C$57:AF$57,\"該当\",C64:AF64,\">0\",C$62:AF$62,\">\"&B64)","v":3}]
[null,{"$f":"EOMONTH(B64,1)","v":"2017-12-31"},null,null,null,354500,10000,null,null,298000,192000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,854500,3]
[null,"2018-01-31",null,null,null,350500,70000,null,null,288000,193000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,901500,3]
[null,"2018-02-28",null,null,null,368200,20000,null,null,292000,168000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,848200,3]
[null,"2018-03-31",null,null,null,330200,30000,null,null,292000,201000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,853200,3]
[null,"2018-04-30",null,null,null,389000,80000,null,280200,306000,188000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1243200,3]
[null,"2018-05-31",null,null,null,365000,70000,null,380200,300000,168000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1283200,3]
[null,"2018-06-30",null,null,null,420800,30000,null,330500,295000,189000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1265300,2]
[null,"2018-07-31",null,null,null,362000,60000,null,220300,285000,80000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1007300,2]
[null,"2018-08-31",null,null,null,456000,40000,null,240800,299000,79000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1114800,2]
[null,"2018-09-30",null,null,null,393000,90000,null,220300,318000,89000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1110300,2]
[null,"賞与など（雇用保険加入者）",null,null,null,500000,null,null,200000,400000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1100000]
[null,"賞与など（継続雇用制度）",null,null,null,null,null,null,null,null,20000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20000]
[null,"賞与など（雇用保険非加入者）",null,null,null,null,20000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20000]
[null,"合計",{"$f":"SUM(C63:C77)","v":0},{"$f":"SUM(D63:D77)","v":0},0,5033600,600000,0,1872300,3974000,1907000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AG63:AG77)","v":13386900},{"$f":"SUM(AH63:AH77)","v":32}]
[null,"うち継続雇用者の給与",{"$f":"IF(C57=\"該当\",SUM(C63:C74)+C75+C76,0)","v":0},{"$f":"IF(D57=\"該当\",SUM(D63:D74)+D75+D76,0)","v":0},0,5033600,0,0,0,3974000,1907000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C79:AF79)","v":10914600}]
[null,"うち継続雇用制度対象者の給与",{"$f":"IF(C57=\"該当\",SUMIFS(C63:C74,$B63:$B74,\">=\"&C62)+C76,0)","v":0},{"$f":"IF(D57=\"該当\",SUMIFS(D63:D74,$B63:$B74,\">=\"&D62)+D76,0)","v":0},0,0,0,0,0,0,457000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C80:AF80)","v":457000}]

{"sheet":"別表６（２３）","index":4,"n_rows":59,"n_cols":54,"rows_kept":59,"cut":false,"hidden":false,"merged":[[11,16,12,22],[14,16,16,22],[18,16,18,22],[20,16,20,22],[22,16,23,22],[25,16,25,22],[29,37,29,43],[22,37,23,43],[25,37,25,43],[11,37,12,43],[14,37,16,43],[18,37,18,43],[20,37,20,43],[56,2,56,15],[56,16,57,16],[57,4,57,13],[57,19,57,29],[57,33,57,43],[26,37,27,43],[29,16,29,22],[52,2,52,15],[52,16,53,16],[53,4,53,13],[53,19,53,29],[53,33,53,43],[54,2,55,15],[54,16,55,16],[55,19,55,29],[55,33,55,43],[48,2,49,15],[48,16,49,16],[49,19,49,29],[49,33,49,43],[50,2,51,15],[50,16,51,16],[51,19,51,29],[51,33,51,43],[46,2,47,15],[46,16,47,16],[46,17,46,18],[46,31,46,32],[47,19,47,29],[47,33,47,43],[43,2,45,15],[43,16,43,30],[43,31,43,44],[44,16,44,30],[44,31,44,44],[45,22,45,24],[45,36,45,38],[41,2,41,3],[41,4,41,13],[41,15,41,23],[41,28,41,31],[41,35,41,43],[42,7,42,38],[39,4,39,12],[39,17,39,22],[39,27,39,32],[39,37,39,42],[40,2,40,3],[40,4,40,13],[40,28,40,31],[37,2,38,14],[37,15,38,24],[37,26,37,33],[37,35,37,44],[38,25,38,34],[38,35,38,44],[35,2,35,3],[35,4,35,13],[35,15,35,23],[35,28,35,31],[35,35,35,43],[36,7,36,38],[33,4,33,12],[33,17,33,22],[33,27,33,32],[33,37,33,42],[34,2,34,3],[34,4,34,13],[34,28,34,31],[30,7,30,38],[31,2,32,14],[31,15,32,24],[31,26,31,33],[31,35,31,44],[32,25,32,34],[32,35,32,44],[28,2,28,14],[28,15,29,15],[28,25,28,35],[28,36,29,36],[29,2,29,14],[29,25,29,35],[26,2,26,14],[26,15,27,15],[26,25,26,35],[26,36,27,36],[27,2,27,14],[27,25,27,35],[26,16,27,22],[24,2,24,14],[24,15,25,15],[24,25,24,35],[24,36,25,36],[25,2,25,14],[25,25,25,35],[21,2,21,14],[21,15,23,15],[21,25,21,35],[21,36,23,36],[22,2,22,14],[22,27,23,29],[22,30,22,33],[23,2,23,14],[23,30,23,33],[19,2,19,14],[19,15,20,15],[19,25,19,35],[19,36,20,36],[20,6,20,10],[20,25,20,35],[16,27,16,35],[17,2,17,14],[17,15,18,15],[17,27,17,35],[17,36,18,36],[18,6,18,10],[18,27,18,35],[13,2,13,14],[13,15,16,15],[13,25,18,26],[13,27,13,35],[13,36,16,36],[14,6,16,10],[14,28,15,30],[14,31,14,32],[15,31,15,32],[7,45,27,45],[8,4,8,14],[8,28,9,30],[8,31,8,32],[9,4,9,14],[5,4,5,14],[5,15,6,15],[5,25,5,35],[5,36,6,36],[6,8,6,9],[6,24,26,24],[6,25,6,35],[7,4,7,14],[7,15,9,15],[1,45,6,45],[10,2,10,14],[10,15,12,15],[10,27,10,35],[10,36,12,36],[11,27,11,35],[12,2,12,14],[12,27,12,35],[7,25,12,26],[7,27,7,35],[3,15,4,15],[3,25,3,35],[3,36,4,36],[4,25,4,35],[4,37,4,43],[1,2,2,22],[1,23,2,26],[1,27,1,31],[1,32,2,35],[1,36,2,44],[2,27,2,31],[3,2,9,2],[3,3,9,3],[3,4,4,14],[7,36,9,36],[9,31,9,32],[4,16,4,22],[6,16,6,22],[8,16,9,22],[6,37,6,43],[8,37,9,43]]}
[]
[null,null,"雇用者給与等支給額が増加した場合の法人税額\nの特別控除に関する明細書",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"事　業\n年　度",null,null,null,{"$f":"基本情報!D11","v":"2017-10-01"},null,null,null,null,"法人名",null,null,null,{"$f":"基本情報!C7","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":"基本情報!C11","v":"2018-09-30"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"中小企業者等に"]
[null,null,"調整前雇用者給与等","支給増加額の計算","雇用者給与等支給額",null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,0,null,"円",null,"調整前税額控除限度額",null,null,null,null,null,null,null,null,null,null,12,null,null,0,null,null,null,null,"円",null,null,null,null,null,null,{"$f":"基本情報!C9","v":"該当"},null,{"$f":"IF(AZ4=\"該当\",1,0)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T48","v":13386900},null,null,null,null,null,null,null,null,"(11)×10/100\n((6)≦(7)の場合は0)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q19<=Q21,0,ROUNDDOWN(Q30*10/100,0))","v":136935},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"基本情報!C13","v":"平成２９年４月以降開始"},null,{"$f":"IF(AZ5=\"平成２９年４月以降開始\",1,0)","v":1}]
[null,null,null,null,"基準雇用者給与等支給額",null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,0,null,null,null,"税額控除加算基準額",null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,null,"(26)",null,null,null,null,null,null,null,{"$f":"IF(ISERROR(AJ36),0,AJ36)","v":12017550},null,null,null,null,null,null,null,"法人税額の特別控除額の計算","(((1)-(5))と(11)のうち少ない金額）",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MIN(Q5-Q15,Q30)<0,0,MIN(Q5-Q15,Q30))","v":1369350},null,null,null,null,null,null,null,null,null,null,null,null,null,"H29年3月以前","H29年4月以後"]
[null,null,null,null,"調整前雇用者給与等支給増加額",null,null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,"以外の法人\n中小企業者等",null,"税額控除加算額",null,null,null,null,null,null,null,null,14,null,null,null,null,null,null,null,null,"平二十九・四・一以後終了事業年度分",null,null,null,null,null,null,{"$f":"ROUNDDOWN(AL7*2/100,0)","v":27387}]
[null,null,null,null,"(1)－(2)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q5-Q7<0,0,Q5-Q7)","v":1369350},null,null,null,null,null,null,null,null,null,null,null,"(13)×",null,null,2,null,null,null,null,null,{"$f":"IF(BB4=1,\"\",IF(BB5=1,BA8,AZ8))","v":""}]
[null,null,null,null,"(マイナスの場合は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,100]
[null,null,"増加促進割合",null,null,null,null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,"税額控除限度額",null,null,null,null,null,null,null,null,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q12<0.04,0,IF(Q5<Q15,0,AL5))","v":136935},{"$f":"IF(Q12<0.05,0,IF(OR(Q5<Q15,Q26<0.02,Q21=0),0,AL5+AL9))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUNDDOWN(Q9/Q7,3)),0,ROUNDDOWN(Q9/Q7,3))","v":0.113},null,null,null,null,null,null,null,null,null,null,"(12)又は((12+(14))",null,null,null,null,null,null,null,null,null,{"$f":"IF(BB4=1,\"\",IF(BB5=1,BA11,AZ11))","v":""}]
[null,null,"(3)/(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,"((1)<(5)の場合又は(9)<0.02若しくは\n(7)=0の場合は0)"]
[null,null,"比較雇用者給与等支給額",null,null,null,null,null,null,null,null,null,null,null,null,5,null,null,null,null,null,null,null,null,null,"中小企業者等",null,"税額控除加算額",null,null,null,null,null,null,null,null,16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q26<0.02,Q21=0),0,ROUNDDOWN(AL7*12/100,0))","v":164322}]
[null,null,null,null,null,null,"(30)",null,null,null,null,null,null,null,null,null,{"$f":"AJ42","v":10836600},null,null,null,null,null,null,null,null,null,null,null,"(13)×",null,null,12,null,null,null,null,null,{"$f":"IF(BB4=0,\"\",IF(BB5=1,BA14,AZ14))","v":164322}]
[null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"((9)<0.02又は(7)=0の場合は0)"]
[null,null,"平 均 給 与 等 支 給 額",null,null,null,null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,0,null,null,null,null,null,"税額控除限度額",null,null,null,null,null,null,null,null,17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q12<0.03,0,IF(Q5<Q15,0,AL5))","v":136935},{"$f":"IF(Q12<0.03,0,IF(Q5<Q15,0,AL5+AL15))","v":301257}]
[null,null,null,null,null,null,"(36の①)",null,null,null,null,null,null,null,null,null,{"$f":"T58","v":326800},null,null,null,null,null,null,null,null,null,null,"(12)又は((12+(16))\n((1)<(5)の場合は0)",null,null,null,null,null,null,null,null,null,{"$f":"IF(BB4=0,\"\",IF(BB5=1,BA18,AZ18))","v":301257}]
[null,null,"比較平均給与等支給額",null,null,null,null,null,null,null,null,null,null,null,null,7,null,null,null,null,null,null,null,null,null,"調整前法人税額",null,null,null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,"(36の②)",null,null,null,null,null,null,null,null,null,{"$f":"AH58","v":218152},null,null,null,null,null,null,null,null,"(別表一(一)｢2｣、別表一(二)｢2｣、別表一\n(三)｢2｣又は別表一の三｢2｣若しくは｢13｣)",null,null,null,null,null,null,null,null,null,null,null,2000000]
[null,null,"平均給与等支給増加額",null,null,null,null,null,null,null,null,null,null,null,null,8,null,null,null,null,null,null,null,null,null,"当期税額基準額",null,null,null,null,null,null,null,null,null,null,19]
[null,null,"(6)－(7)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q19-Q21<0,0,Q19-Q21)","v":108648},null,null,null,null,null,null,null,null,null,null,"(11)×",null,null,{"$f":"IF(BB4=1,20,10)","v":20},null,null,null,null,null,null,{"$f":"ROUND(AL21*AE23/AE24,0)","v":400000}]
[null,null,"(マイナスの場合は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,100]
[null,null,"平均給与等支給増加割合",null,null,null,null,null,null,null,null,null,null,null,null,9,null,null,null,null,null,null,null,null,null,"当期税額控除可能額",null,null,null,null,null,null,null,null,null,null,20]
[null,null,"(8)/(7)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q21=0,1,ROUNDDOWN(Q23/Q21,3))","v":0.498},null,null,null,null,null,null,null,null,"(((15)又は(17))と(19)のうち少ない金額）",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BB4=1,MIN(AL19,AL23),MIN(AL12,AL23))","v":301257}]
[null,null,"雇用者給与等支給増加重複控除",null,null,null,null,null,null,null,null,null,null,null,null,10,null,null,null,null,null,null,null,null,null,"法人税額超過構成額",null,null,null,null,null,null,null,null,null,null,21]
[null,null,"(別表六(二十三)付表｢7｣)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（別表六(二十七)｢7の㉔｣）"]
[null,null,"雇用者給与等支給増加額",null,null,null,null,null,null,null,null,null,null,null,null,11,null,null,null,null,null,null,null,null,null,"法人税額の特別控除額",null,null,null,null,null,null,null,null,null,null,22]
[null,null,"(3)－(10)\n（マイナスの場合は０）",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q9-Q27<0,0,Q9-Q27)","v":1369350},null,null,null,null,null,null,null,null,"(20)－(21)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"AL26-AL27","v":301257}]
[null,null,null,null,null,null,null,"基準雇用者給与等支給額の計算"]
[null,null,"基準事業年度又は基準連結事業年度等",null,null,null,null,null,null,null,null,null,null,null,null,"国内雇用者に対する\n給与等の支給額",null,null,null,null,null,null,null,null,null,null,"適用年度の月数",null,null,null,null,null,null,null,null,"基準雇用者給与等支給額"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(23)の基準事業年度又は\n基準連結事業年度等の月数",null,null,null,null,null,null,null,null,null,"(24)×(25)"]
[null,null,null,null,23,null,null,null,null,null,null,null,null,null,null,null,null,24,null,null,null,null,null,null,null,null,null,25,null,null,null,null,null,null,null,null,null,26]
[null,null,"平",null,{"$f":"基本情報!C17","v":"2012-10-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"円",null,null,null,{"$f":"基本情報!I11","v":12},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"円"]
[null,null,"平",null,{"$f":"基本情報!C18","v":"2013-09-30"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E35=\"-\",基本情報!D21,給与入力!AG21)","v":12017550},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E35=\"-\",基本情報!G20,基本情報!I18)","v":12},null,null,null,null,null,null,{"$f":"ROUNDDOWN(P36*AC35/AC36,0)","v":12017550}]
[null,null,null,null,null,null,null,"比較雇用者給与等支給額の計算"]
[null,null,"前事業年度又は前連結事業年度",null,null,null,null,null,null,null,null,null,null,null,null,"国内雇用者に対する\n給与等の支給額",null,null,null,null,null,null,null,null,null,null,"適用年度の月数",null,null,null,null,null,null,null,null,"比較雇用者給与等支給額"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(27)の前事業年度又は\n前連結事業年度の月数",null,null,null,null,null,null,null,null,null,"(21)×(22)"]
[null,null,null,null,27,null,null,null,null,null,null,null,null,null,null,null,null,28,null,null,null,null,null,null,null,null,null,29,null,null,null,null,null,null,null,null,null,30]
[null,null,"平",null,{"$f":"基本情報!G11","v":"2016-10-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"円",null,null,null,{"$f":"基本情報!I11","v":12},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"円"]
[null,null,"平",null,{"$f":"基本情報!H11","v":"2017-09-30"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E41=\"-\",0,給与入力!AG49)","v":10836600},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"基本情報!J11","v":12},null,null,null,null,null,null,{"$f":"IF(E41=\"-\",0,ROUNDDOWN(P42*AC41/AC42,0))","v":10836600}]
[null,null,null,null,null,null,null,"平均給与等支給額及び比較平均給与等支給額の計算"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"平均給与等支給額の計算",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"比較平均給与等支給額の計算"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"適　　用　　年　　度",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"前事業年度又は前連結事業年度"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"①",null,null,null,null,null,null,null,null,null,null,null,null,null,"②"]
[null,null,"雇用者給与等支給額",null,null,null,null,null,null,null,null,null,null,null,null,null,31,"(1)",null,null,null,null,null,null,null,null,null,null,null,null,"円","(28)",null,null,null,null,null,null,null,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":"給与入力!AG78","v":13386900},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"給与入力!AG49","v":10836600}]
[null,null,"同上のうち一般被保険者である\n継続雇用者に係る金額",null,null,null,null,null,null,null,null,null,null,null,null,null,32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"給与入力!AG79","v":10914600},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"給与入力!AG50","v":8726100}]
[null,null,"同上のうち継続雇用制度\n対象者に係る金額",null,null,null,null,null,null,null,null,null,null,null,null,null,33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"給与入力!AG80","v":457000},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"給与入力!AG51","v":0}]
[null,null,"継続雇用者給与等支給額",null,null,null,null,null,null,null,null,null,null,null,null,null,34]
[null,null,null,null,"(32)－(33)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E41=\"-\",1,T50-T52)","v":10457600},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E41=\"-\",0,AH50-AH52)","v":8726100}]
[null,null,"月別支給対象者の合計数",null,null,null,null,null,null,null,null,null,null,null,null,null,35,null,null,null,null,null,null,null,null,null,null,null,null,null,"人",null,null,null,null,null,null,null,null,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(E41=\"-\",1,給与入力!AH78)","v":32},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E41=\"-\",1,給与入力!AH49)","v":40}]
[null,null,"平均給与等支給額及び比較平均給与等支給額　",null,null,null,null,null,null,null,null,null,null,null,null,null,36,null,null,null,null,null,null,null,null,null,null,null,null,null,"円",null,null,null,null,null,null,null,null,null,null,null,null,null,"円"]
[null,null,null,null,"(34)/(35)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUNDDOWN(T54/T56,0)),0,ROUNDDOWN(T54/T56,0))","v":326800},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(ROUNDDOWN(AH54/AH56,0)),0,ROUNDDOWN(AH54/AH56,0))","v":218152}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"法　0301-0623"]

{"sheet":"別表６（２３）Ｈ３０","index":5,"n_rows":69,"n_cols":30,"rows_kept":69,"cut":false,"hidden":false,"merged":[[64,22,67,23],[66,12,67,20],[67,2,67,6],[61,21,63,21],[61,22,63,23],[62,2,62,6],[62,12,63,20],[63,2,63,6],[63,11,67,11],[57,1,67,1],[57,2,58,6],[57,7,58,7],[57,8,58,9],[57,13,57,20],[57,21,58,21],[64,2,64,6],[64,7,67,7],[64,8,67,10],[64,12,65,20],[58,13,58,20],[59,2,59,6],[59,7,60,7],[59,8,60,9],[59,12,59,20],[64,21,67,21],[54,8,56,9],[54,13,54,20],[54,21,56,21],[61,2,61,6],[61,7,63,7],[61,8,63,9],[61,12,61,20],[54,22,56,23],[55,3,56,4],[55,16,56,16],[55,17,56,17],[55,18,55,19],[56,18,56,19],[59,21,60,21],[59,22,60,23],[60,2,60,6],[60,12,60,20],[57,22,58,23],[46,1,56,1],[46,2,49,6],[46,7,49,7],[46,8,49,9],[46,12,58,12],[46,13,53,14],[46,15,46,20],[46,21,49,21],[46,22,49,23],[47,17,48,17],[47,18,48,18],[49,15,49,20],[50,2,51,6],[50,7,53,7],[50,8,53,9],[50,15,50,20],[50,21,53,21],[50,22,53,23],[51,17,52,17],[51,18,52,18],[52,2,53,6],[53,15,53,20],[54,2,54,6],[54,7,56,7],[39,12,40,12],[39,13,39,20],[39,21,41,21],[39,22,41,23],[40,2,40,6],[40,13,41,20],[41,2,41,6],[42,2,42,6],[42,7,45,7],[42,8,45,10],[42,13,42,20],[42,21,45,21],[42,22,45,23],[43,13,44,20],[45,2,45,6],[45,13,45,20],[34,1,45,1],[34,2,34,6],[34,7,36,7],[34,8,36,9],[34,10,35,10],[34,13,34,20],[34,21,36,21],[34,22,36,23],[35,2,36,6],[35,16,36,16],[35,17,36,17],[35,18,35,19],[36,18,36,19],[37,2,37,6],[37,7,38,7],[37,8,38,9],[37,13,37,20],[37,21,38,21],[37,22,38,23],[38,2,38,6],[38,13,38,20],[39,2,39,6],[39,7,41,7],[39,8,41,9],[25,15,26,20],[27,15,27,20],[27,21,30,21],[31,1,31,6],[31,7,33,7],[31,8,33,10],[31,15,31,20],[27,22,30,23],[28,1,29,6],[28,17,29,17],[28,18,29,18],[30,1,30,6],[30,15,30,20],[27,1,27,6],[27,7,30,7],[27,8,30,9],[27,13,33,14],[31,21,33,21],[31,22,33,23],[32,15,32,20],[33,15,33,20],[17,21,19,21],[17,22,19,23],[18,13,19,20],[19,1,19,6],[20,1,20,6],[20,7,22,7],[20,8,22,9],[20,12,37,12],[20,13,26,13],[20,14,26,14],[20,15,20,20],[20,21,22,21],[20,22,22,23],[21,1,22,6],[21,17,22,17],[21,18,22,18],[23,1,24,6],[23,7,26,7],[23,8,26,9],[23,15,23,20],[23,21,26,21],[23,22,26,23],[24,15,24,20],[25,1,26,6],[14,16,15,16],[14,17,15,17],[14,18,14,19],[15,12,16,12],[15,18,15,19],[16,13,16,20],[17,1,18,6],[17,7,19,7],[17,8,19,9],[17,10,18,10],[17,12,18,12],[17,13,17,20],[8,7,9,7],[8,8,9,9],[8,13,8,20],[8,21,9,21],[8,22,9,23],[8,25,67,27],[9,1,9,6],[9,12,10,12],[9,13,9,20],[10,1,10,6],[10,7,12,7],[10,8,12,9],[10,13,10,20],[10,21,12,21],[10,22,12,23],[11,1,11,6],[11,12,12,12],[11,13,11,20],[12,1,12,6],[12,13,12,20],[13,13,13,20],[13,21,16,21],[13,22,16,23],[13,24,15,24],[4,1,5,9],[4,10,4,11],[4,12,4,17],[4,18,5,19],[4,20,5,24],[4,25,5,27],[5,10,5,11],[5,12,5,17],[6,1,7,6],[6,7,7,7],[6,8,7,9],[6,11,62,11],[6,12,6,20],[6,21,7,21],[13,1,14,6],[13,7,16,7],[13,8,16,10],[13,12,14,12],[6,22,7,23],[6,25,7,25],[6,26,7,26],[6,27,7,27],[7,12,7,20],[8,1,8,6]]}
[]
[]
[]
[]
[null,"雇用者給与等支給額が増加した場合又は給与等\nの引き上げ及び設備投資を行った場合の法人税額\nの特別控除に関する明細書",null,null,null,null,null,null,null,null,"事　業",null,{"$f":"'別表６（２３）'!AB2:AB2","v":"2017-10-01"},null,null,null,null,null,"法人名",null,{"$f":"'別表６（２３）'!AK2:AK2","v":"株式会社今野デザイン"},null,null,null,null,"別表六"]
[null,null,null,null,null,null,null,null,null,null,"年　度",null,{"$f":"'別表６（２３）'!AB3:AB3","v":"2018-09-30"}]
[null,"雇用者給与等支給額",null,null,null,null,null,1,{"$f":"'別表６（２３）'!Q5:Q5","v":13386900},null,"円"," 法人税額の特別控除額の計算  ","調整前法人税額",null,null,null,null,null,null,null,null,21,{"$f":"'別表６（２３）'!AL21:AL21","v":2000000},null,"円","(","二十三",")"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(別表一(一)｢2｣､別表一(二)｢2｣又は別表一(三)｢2｣又は別表一の三｢2｣若しくは｢13｣)"]
[null,"基準雇用者給与等支給額",null,null,null,null,null,2,{"$f":"'別表６（２３）'!Q7:Q7","v":12017550},null,null,null,null,"雇用者給与等支給増加重複控除額",null,null,null,null,null,null,null,22,{"$f":"'別表６（２３）'!Q27:Q27","v":0},null,null," 平三十・四・一以後終了事業年度分"]
[null,"(別表六(二十三)付表一｢4｣)",null,null,null,null,null,null,null,null,null,null,"平成","（別表六(二十三)付表二｢7｣）"]
[null,"調整前雇用者給与等支給増加額",null,null,null,null,null,3,{"$f":"'別表６（２３）'!Q9:Q9","v":1369350},null,null,null,null,"雇用者給与等支給増加額",null,null,null,null,null,null,null,23,{"$f":"'別表６（２３）'!Q30:Q30","v":1369350}]
[null,"(1)－(2)",null,null,null,null,null,null,null,null,null,null,30,"(3)－(22)"]
[null,"(マイナスの場合は０)",null,null,null,null,null,null,null,null,null,null,null,"(マイナスの場合は０)"]
[null,"増加促進割合",null,null,null,null,null,4,{"$f":"'別表６（２３）'!Q12:Q12","v":0.113},null,null,null,"年","税額控除限度額",null,null,null,null,null,null,null,24,{"$f":"'別表６（２３）'!AL5:AL5","v":136935},null,"円",null,null,null,null,{"$f":"IF(AND(#REF!=2,I14>=0.03),INT(W11*10/100),IF(I14>=0.05,INT(W11*10/100),0))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(23)","×",10]
[null,null,null,null,"(3)",null,null,null,null,null,null,null,4,null,null,null,null,null,100]
[null,null,null,null,"(2)",null,null,null,null,null,null,null,null,"((6)≦(7)の場合は０)"]
[null,"比較雇用者給与等支給額",null,null,null,null,null,5,{"$f":"'別表６（２３）'!Q15:Q15","v":10836600},null,"円",null,"月","税額控除加算基準額",null,null,null,null,null,null,null,25,{"$f":"MIN(I7-I18,W11)","v":1369350}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"(((1)－(5))と(23)のうち少ない金額)"]
[null,"(別表六(二十三)付表一｢8｣)",null,null,null,null,null,null,null,null,null,null,1]
[null,"平均給与等支給額",null,null,null,null,null,6,{"$f":"'別表６（２３）'!Q19:Q19","v":326800},null,null,null,"日前に開始した事業年度の場合"," 中小企業者等"," 以外の法人","税額控除加算額",null,null,null,null,null,26,{"$f":"'別表６（２３）'!AL9:AL9","v":""}]
[null,"(別表六(二十三)付表一｢14の①｣)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(25)","×",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100]
[null,"比較平均給与等支給額",null,null,null,null,null,7,{"$f":"'別表６（２３）'!Q21:Q21","v":218152},null,null,null,null,null,null,"税額控除限度額",null,null,null,null,null,27,{"$f":"'別表６（２３）'!AL12:AL12","v":""},null,null,null,null,null,null,{"$f":"IF(OR(I32<0.02,I24=0),0,W14+W21)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(24)＋(26)"]
[null,"(別表六(二十三)付表一｢14の②｣)",null,null,null,null,null,null,null,null,null,null,null,null,null,"((1)＜(5)の場合又は(9)＜0.02\n若しくは(7)＝０の場合は０)"]
[]
[null,"平均給与等支給増加額",null,null,null,null,null,8,{"$f":"IF(I21-I24>0,I21-I24,0)","v":108648},null,null,null,null,"中小企業者等",null,"税額控除加算額",null,null,null,null,null,28,{"$f":"'別表６（２３）'!AL15:AL15","v":164322}]
[null,"(6)－(7)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(25)","×",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100]
[null,"(マイナスの場合は０)",null,null,null,null,null,null,null,null,null,null,null,null,null,"((9)＜0.02又は(7)＝０の場合は０)"]
[null,"平均給与等支給増加割合",null,null,null,null,null,9,{"$f":"'別表６（２３）'!Q26:Q26","v":0.498},null,null,null,null,null,null,"税額控除限度額",null,null,null,null,null,29,{"$f":"'別表６（２３）'!AL19:AL19","v":301257}]
[null,null,null,null,"(8)",null,null,null,null,null,null,null,null,null,null,"(24)＋(28)"]
[null,null,null,null,"(7)",null,null,null,null,null,null,null,null,null,null,"((1)＜(5)の場合は０)"]
[null,"継続雇用者給与等支給増加割合の計算","継続雇用者給与等支給額",null,null,null,null,10,null,null,"円",null,null,"当期税額基準額",null,null,null,null,null,null,null,30,{"$f":"'別表６（２３）'!AL23:AL23","v":400000}]
[null,null,"(別表六(二十三)付表一｢19の①｣)",null,null,null,null,null,null,null,null,null,null,null,null,null,"(21)","×",{"$f":"'別表６（２３）'!AE23:AE23","v":20}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100]
[null,null,"継続雇用者比較給与等支給額",null,null,null,null,11,null,null,null,null,null,"当期税額控除可能額",null,null,null,null,null,null,null,31,{"$f":"'別表６（２３）'!AL26:AL26","v":301257}]
[null,null,"(別表六(二十三)付表一｢19の②｣又は｢19の③｣)",null,null,null,null,null,null,null,null,null,null,"(((27)又は(29))と(30)のうち少ない金額)"]
[null,null,"継続雇用者給与等支給増加額",null,null,null,null,12,{"$f":"IF(I35-I38>0,I35-I38,0)","v":0},null,null,null,"平成","雇用者給与等支給増加重複控除額",null,null,null,null,null,null,null,32]
[null,null,"(10)－(11)",null,null,null,null,null,null,null,null,null,null,"（別表六(二十三)付表二｢17｣）"]
[null,null,"(マイナスの場合は０)",null,null,null,null,null,null,null,null,null,30]
[null,null,"継続雇用者給与等支給増加割合",null,null,null,null,13,{"$f":"IF(I38>0,ROUNDDOWN(I40/I38,4),\"\")","v":""},null,null,null,"年","雇用者給与等支給増加額",null,null,null,null,null,null,null,33]
[null,null,null,null,"(12)",null,null,null,null,null,null,null,4,"(1)－(5)－(32)"]
[null,null,null,null,"(11)",null,null,null,null,null,null,null,"月"]
[null,null,"((11)＝０の場合は０)",null,null,null,null,null,null,null,null,null,1,"(マイナスの場合は０)"]
[null,"国内設備投資に係る計算","国内設備投資額",null,null,null,null,14,null,null,null,null,"日以後に開始する事業年度の場合","税額控除限度額",null,"(20)≧20％又は(17)＝(19)＞0の場合",null,null,null,null,null,34]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(33)","×",20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"((13)＜0.03又は(14)＜(16)の場合は０)"]
[null,null,"当期償却費総額",null,null,null,null,15,null,null,null,null,null,null,null,"同上以外の場合",null,null,null,null,null,35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(33)","×",15]
[null,null,"(別表六(二十三)付表一｢22｣)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"((13)＜0.03又は(14)＜(16)の場合は０)"]
[null,null,"当期償却費総額の90％相当額",null,null,null,null,16,null,null,null,null,null,"当期税額基準額",null,null,null,null,null,null,null,36]
[null,null,null,"(15)×",null,90,null,null,null,null,null,null,null,null,null,null,"(21)","×",20]
[null,null,null,null,null,100,null,null,null,null,null,null,null,null,null,null,null,null,100]
[null,"教育訓練費増加割合の計算","教育訓練費の額",null,null,null,null,17,null,null,null,null,null,"当期税額控除可能額",null,null,null,null,null,null,null,37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"(((34)又は(35))と(36)のうち少な\nい金額)"]
[null,null,"比較教育訓練費の額",null,null,null,null,18,null,null,null,null,"当期税額控除可能額",null,null,null,null,null,null,null,null,38,{"$f":"W38","v":301257}]
[null,null,"(別表六(二十三)付表一｢27｣)",null,null,null,null,null,null,null,null,null,"(31)又は(37)"]
[null,null,"教育訓練費増加額",null,null,null,null,19,{"$f":"IF(I58-I60>0,I58-I60,0)","v":0},null,null,null,"調整前法人税額超過構成額",null,null,null,null,null,null,null,null,39,{"$f":"'別表６（２３）'!AL27:AL27","v":0}]
[null,null,"(17)－(18)",null,null,null,null,null,null,null,null,null,"（別表六(二十八)｢7の㉒｣）"]
[null,null,"(マイナスの場合は０)"]
[null,null,"教育訓練費増加割合",null,null,null,null,20,{"$f":"IF(I60>0,ROUNDDOWN(I62/I60,4),\"\")","v":""},null,null,null,"法人税額の特別控除額",null,null,null,null,null,null,null,null,40,{"$f":"'別表６（２３）'!AL30:AL30","v":301257}]
[null,null,null,null,"(19)"]
[null,null,null,null,"(18)",null,null,null,null,null,null,null,"(38)－(39)"]
[null,null,"((18)＝０の場合は０)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"法　0301-0623"]

{"sheet":"別表６（２３）付表１Ｈ３０","index":6,"n_rows":70,"n_cols":39,"rows_kept":70,"cut":false,"hidden":false,"merged":[[4,1,5,14],[4,15,4,16],[4,17,4,22],[4,23,5,24],[4,25,5,33],[4,34,5,36],[5,15,5,16],[5,17,5,22],[7,26,8,26],[8,34,9,36],[9,2,10,7],[9,8,10,8],[9,9,10,14],[9,17,10,25],[9,26,10,26],[6,5,6,29],[6,34,7,34],[6,35,7,35],[6,36,7,36],[7,2,8,7],[7,8,8,8],[7,16,15,16],[7,17,8,25],[9,27,9,32],[10,27,10,32],[10,34,28,36],[11,2,11,7],[11,8,13,8],[11,11,12,13],[11,17,11,25],[11,26,13,26],[11,29,12,31],[12,2,13,7],[12,17,13,25],[13,11,13,13],[13,29,13,31],[14,2,14,7],[14,8,15,8],[14,9,15,14],[14,17,14,25],[14,26,15,26],[14,27,15,32],[15,2,15,7],[20,1,21,8],[20,9,21,9],[21,10,21,20],[21,24,21,32],[22,1,23,8],[22,9,23,9],[22,10,23,20],[22,24,23,32],[15,17,15,25],[16,5,16,29],[17,1,19,9],[17,10,17,21],[17,22,17,33],[18,10,18,21],[18,22,18,33],[19,10,19,21],[19,22,19,33],[7,1,15,1],[24,1,25,8],[24,9,25,9],[24,10,25,20],[24,24,25,32],[26,1,26,8],[26,9,27,9],[26,10,27,20],[26,24,27,32],[27,1,27,8],[28,1,29,8],[28,9,29,9],[28,10,29,20],[28,24,29,32],[30,1,30,8],[30,9,32,9],[30,10,32,20],[30,21,31,21],[30,24,32,32],[36,26,36,33],[37,1,38,8],[37,9,38,9],[37,10,38,17],[37,18,37,25],[37,26,37,33],[38,18,38,25],[38,26,38,33],[30,33,31,33],[33,5,33,29],[34,1,36,9],[34,10,34,17],[34,18,34,33],[35,10,35,17],[35,18,35,25],[35,26,35,33],[36,10,36,17],[36,18,36,25],[39,1,40,8],[39,9,40,9],[40,10,40,16],[40,18,40,24],[40,26,40,32],[41,1,42,8],[41,9,42,9],[41,10,42,16],[41,18,42,24],[41,26,42,32],[45,1,45,8],[45,9,47,9],[46,1,46,8],[46,10,47,16],[46,18,47,24],[46,26,47,32],[47,1,47,8],[43,1,43,8],[43,9,44,9],[43,10,44,17],[43,18,44,25],[43,28,43,31],[44,1,44,8],[44,28,44,31],[48,5,48,29],[49,1,50,7],[49,8,50,8],[49,9,50,15],[49,25,52,25],[49,26,52,32],[50,17,50,24],[51,1,51,7],[51,8,52,8],[51,9,52,15],[51,17,51,24],[52,1,52,7],[53,5,53,29],[54,1,56,8],[54,9,56,17],[54,18,54,25],[54,26,55,33],[55,18,56,25],[56,26,56,33],[60,9,61,16],[60,21,60,23],[60,26,61,32],[61,2,61,8],[61,21,61,23],[57,1,57,8],[57,9,57,17],[57,18,57,25],[57,26,57,33],[58,1,65,1],[58,2,58,8],[58,9,59,16],[58,21,58,23],[58,26,59,32],[59,2,59,8],[7,10,7,15],[8,10,8,15],[7,28,7,33],[8,28,8,33],[66,1,66,25],[66,26,66,32],[67,1,67,24],[67,25,68,25],[67,26,68,32],[68,1,68,24],[64,2,64,8],[64,9,65,16],[64,21,64,23],[64,26,65,32],[65,2,65,8],[65,21,65,23],[62,2,62,8],[62,9,63,16],[62,21,62,23],[62,26,63,32],[63,2,63,8],[63,21,63,23],[59,21,59,23],[60,2,60,8]]}
[]
[]
[]
[]
[null,"給与等支給額、当期償却費総額及び比較教育訓練\n費の額の計算に関する明細書",null,null,null,null,null,null,null,null,null,null,null,null,null,"事　業",null,{"$f":"'別表６（２３）'!AB2:AB2","v":"2017-10-01"},null,null,null,null,null,"法人名",null,{"$f":"'別表６（２３）'!AK2:AK2","v":"株式会社今野デザイン"},null,null,null,null,null,null,null,null,"別表六"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"年　度",null,{"$f":"'別表６（２３）'!AB3:AB3","v":"2018-09-30"}]
[null,null,null,null,null,"給与等支給額の計算に関する明細",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(","二十三",")"]
[null,"基準雇用者給与等支給額の計算","基準事業年度又は\n基準連結事業年度等",null,null,null,null,null,1,"平",{"$f":"'別表６（２３）'!E35:E35","v":"2012-10-01"},null,null,null,null,null,"比較雇用者給与等支給額の計算","前事業年度又は前連結事業年度",null,null,null,null,null,null,null,null,5,"平",{"$f":"'別表６（２３）'!E41:E41","v":"2016-10-01"}]
[null,null,null,null,null,null,null,null,null,"平",{"$f":"'別表６（２３）'!E36:E36","v":"2013-09-30"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"平",{"$f":"'別表６（２３）'!E42:E42","v":"2017-09-30"},null,null,null,null,null,"付表一"]
[null,null,"国内雇用者に対する\n給与等の支給額",null,null,null,null,null,2,{"$f":"'別表６（２３）'!P36:P36","v":12017550},null,null,null,null,null,"円",null,"国内雇用者に対する\n給与等の支給額",null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,"円"]
[null,null,null,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":"'別表６（２３）'!P42:P42","v":10836600},null,null,null,null,null,null," 平三十・四・一以後終了事業年度分"]
[null,null,"適用年度の月数",null,null,null,null,null,3,null,null,{"$f":"'別表６（２３）'!AC35:AC35","v":12},null,null,null,null,null,"適用年度の月数",null,null,null,null,null,null,null,null,7,null,null,{"$f":"'別表６（２３）'!AC41:AC41","v":12}]
[null,null,"(1)の基準事業年度又は\n基準連結事業年度等の月数",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(5)の前事業年度又は\n前連結事業年度の月数"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'別表６（２３）'!AC36:AC36","v":12},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'別表６（２３）'!AC42:AC42","v":12}]
[null,null,"基準雇用者給与等支給額",null,null,null,null,null,4,{"$f":"'別表６（２３）'!AJ36:AJ36","v":12017550},null,null,null,null,null,"円",null,"比較雇用者給与等支給額",null,null,null,null,null,null,null,null,8,{"$f":"'別表６（２３）'!AJ42:AJ42","v":10836600},null,null,null,null,null,"円"]
[null,null,"(2)×(3)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(6)×(7)"]
[null,null,null,null,null,"平均給与等支給額及び比較平均給与等支給額の計算"]
[null,null,null,null,null,null,null,null,null,null,"平均給与等支給額の計算",null,null,null,null,null,null,null,null,null,null,null,"比較平均給与等支給額の計算"]
[null,null,null,null,null,null,null,null,null,null,"適　用　年　度",null,null,null,null,null,null,null,null,null,null,null,"前事業年度又は前連結事業年度"]
[null,null,null,null,null,null,null,null,null,null,"①",null,null,null,null,null,null,null,null,null,null,null,"②"]
[null,"雇用者給与等支給額",null,null,null,null,null,null,null,9,"別表六(二十三)｢1｣",null,null,null,null,null,null,null,null,null,null,"円","(6)",null,null,null,null,null,null,null,null,null,null,"円"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'別表６（２３）'!T48:T48","v":13386900},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'別表６（２３）'!AH48:AH48","v":10836600}]
[null,"同上のうち一般被保険者である旧\n措法第42条の12の５第２項第８号に\n規定する継続雇用者に係る金額",null,null,null,null,null,null,null,10,{"$f":"'別表６（２３）'!T50:T50","v":10914600},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'別表６（２３）'!AH50:AH50","v":8726100}]
[]
[null,"同上のうち継続雇用制度対象者に係る金額",null,null,null,null,null,null,null,11,{"$f":"'別表６（２３）'!T52:T52","v":457000},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'別表６（２３）'!AH52:AH52","v":0}]
[]
[null,"継続雇用者に対する給与等の支給額",null,null,null,null,null,null,null,12,{"$f":"'別表６（２３）'!T54:T54","v":10457600},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'別表６（２３）'!AH54:AH54","v":8726100}]
[null,"(10)－(11)"]
[null,"月別支給対象者の合計数",null,null,null,null,null,null,null,13,{"$f":"'別表６（２３）'!T56:T56","v":32},null,null,null,null,null,null,null,null,null,null,"人",null,null,{"$f":"'別表６（２３）'!AH56:AH56","v":40},null,null,null,null,null,null,null,null,"人"]
[]
[null,"平均給与等支給額及び比較平均給与等支給額",null,null,null,null,null,null,null,14,{"$f":"'別表６（２３）'!T58:T58","v":326800},null,null,null,null,null,null,null,null,null,null,"円",null,null,{"$f":"'別表６（２３）'!AH58:AH58","v":218152},null,null,null,null,null,null,null,null,"円"]
[null,null,null,null,null,"(12)"]
[null,null,null,null,null,"(13)"]
[null,null,null,null,null,"継続雇用者給与等支給額及び継続雇用者比較給与等支給額の計算"]
[null,null,null,null,null,null,null,null,null,null,"継続雇用者給与等支給額の計算",null,null,null,null,null,null,null,"継続雇用者比較給与等支給額の計算"]
[null,null,null,null,null,null,null,null,null,null,"適　用　年　度",null,null,null,null,null,null,null,"前 事 業 年 度 等",null,null,null,null,null,null,null,"前一年事業年度等特定期間"]
[null,null,null,null,null,null,null,null,null,null,"①",null,null,null,null,null,null,null,"②",null,null,null,null,null,null,null,"③"]
[null,"事業年度等又は連結事業年度等",null,null,null,null,null,null,null,15]
[]
[null,"雇用者給与等支給額",null,null,null,null,null,null,null,16,"別表六(二十三)｢1｣",null,null,null,null,null,null,"円","(6)",null,null,null,null,null,null,"円",null,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":"AB10","v":0}]
[null,"同上のうち継続雇用者に係る金額",null,null,null,null,null,null,null,17]
[]
[null,"適用年度の月数",null,null,null,null,null,null,null,18]
[null,"(15の③)の月数"]
[null,"継続雇用者給与等支給額及び",null,null,null,null,null,null,null,19,null,null,null,null,null,null,null,"円",null,null,null,null,null,null,null,"円",null,null,null,null,null,null,null,"円"]
[null,"継続雇用者比較給与等支給額"]
[null,"(17)又は((17)×(18))"]
[null,null,null,null,null,"当期償却費総額の計算に関する明細"]
[null,"損益計算書に計上された減価償却費の額",null,null,null,null,null,null,20,null,null,null,null,null,null,null,"円",null,null,null,null,null,null,null,null,22,{"$f":"J50+J52","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,21,null,null,null,null,null,null,null,null,"(20)＋(21)"]
[null,"して積み立てた金額その他上記以外の金額"]
[null,null,null,null,null,"比較教育訓練費の額の計算に関する明細"]
[null,"事業年度又は連結事業年度",null,null,null,null,null,null,null,"教育訓練費の額",null,null,null,null,null,null,null,null,"適用年度の月数",null,null,null,null,null,null,null,"改定教育訓練費の額"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(23)の前事業年度又は\n連結事業年度の月数"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(24)×(25)"]
[null,23,null,null,null,null,null,null,null,24,null,null,null,null,null,null,null,null,25,null,null,null,null,null,null,null,26]
[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(V60>0,INT(J59*V59/V60),0)","v":0},null,null,null,null,null,null,"円"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V62>0,INT(J61*V61/V62),0)","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,{"$f":"IF(V64>0,INT(J63*V63/V64),0)","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,{"$f":"IF(V66>0,INT(J65*V65/V66),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"事業年度の数"]
[null,"計",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(AA59:AG66)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(J59:Q66,\">0\")","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,27,{"$f":"IF(AA67>0,INT(AA67/AM67),0)","v":0}]
[null,"(26の計)÷(調整対象年度数)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"法　0301-0623-付1"]

{"sheet":"計算基礎シート","index":7,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,null,null,null,"在職中",{"$f":"G28","v":"2018-09-30"},"なくなった月",null,"なった月"]
[null,"前年度",null,null,"適用年度",{"$f":"F5&\"前退職\"","v":"2016年10月前退職"},{"$f":"G5-1","v":"2016-09-30"},1]
[1,{"$f":"基本情報!G11","v":"2016-10-01"},{"$f":"YEAR(B5)&\"年\"&MONTH(B5)&\"月以前\"","v":"2016年10月以前"},{"$f":"B5","v":"2016-10-01"},{"$f":"D5","v":"2016-10-01"},{"$f":"YEAR(E5)&\"年\"&MONTH(E5)&\"月\"","v":"2016年10月"},{"$f":"E5","v":"2016-10-01"},2,{"$f":"C5","v":"2016年10月以前"},1,null,"退職"]
[2,{"$f":"EOMONTH(B5,1)","v":"2016-11-30"},{"$f":"YEAR(B6)&\"年\"&MONTH(B6)&\"月\"","v":"2016年11月"},{"$f":"B6","v":"2016-11-30"},{"$f":"EOMONTH(E5,1)","v":"2016-11-30"},{"$f":"YEAR(E6)&\"年\"&MONTH(E6)&\"月\"","v":"2016年11月"},{"$f":"E6","v":"2016-11-30"},2,{"$f":"C6","v":"2016年11月"},1,null,"継続雇用制度に移行"]
[3,{"$f":"EOMONTH(B6,1)","v":"2016-12-31"},{"$f":"YEAR(B7)&\"年\"&MONTH(B7)&\"月\"","v":"2016年12月"},"2016-12-31",{"$f":"EOMONTH(E6,1)","v":"2016-12-31"},"2016年12月","2016-12-31",2,"2016年12月",1]
[4,"2017-01-31","2017年1月","2017-01-31","2017-01-31","2017年1月","2017-01-31",2,"2017年1月",1]
[5,"2017-02-28","2017年2月","2017-02-28","2017-02-28","2017年2月","2017-02-28",2,"2017年2月",1]
[6,"2017-03-31","2017年3月","2017-03-31","2017-03-31","2017年3月","2017-03-31",2,"2017年3月",1]
[7,"2017-04-30","2017年4月","2017-04-30","2017-04-30","2017年4月","2017-04-30",2,"2017年4月",1]
[8,"2017-05-31","2017年5月","2017-05-31","2017-05-31","2017年5月","2017-05-31",2,"2017年5月",1]
[9,"2017-06-30","2017年6月","2017-06-30","2017-06-30","2017年6月","2017-06-30",2,"2017年6月",1]
[10,"2017-07-31","2017年7月","2017-07-31","2017-07-31","2017年7月","2017-07-31",2,"2017年7月",1]
[11,"2017-08-31","2017年8月","2017-08-31","2017-08-31","2017年8月","2017-08-31",2,"2017年8月",1]
[12,"2017-09-30","2017年9月","2017-09-30","2017-09-30","2017年9月","2017-09-30",2,"2017年9月",1]
[13,"2017-10-31","2017年10月","2017-10-31","2017-10-31","2017年10月","2017-10-31",1,"2017年10月",2]
[14,"2017-11-30","2017年11月","2017-11-30","2017-11-30","2017年11月","2017-11-30",1,"2017年11月",2]
[15,"2017-12-31","2017年12月","2017-12-31","2017-12-31","2017年12月","2017-12-31",1,"2017年12月",2]
[16,"2018-01-31","2018年1月","2018-01-31","2018-01-31","2018年1月","2018-01-31",1,"2018年1月",2]
[17,"2018-02-28","2018年2月","2018-02-28","2018-02-28","2018年2月","2018-02-28",1,"2018年2月",2]
[18,"2018-03-31","2018年3月","2018-03-31","2018-03-31","2018年3月","2018-03-31",1,"2018年3月",2]
[19,"2018-04-30","2018年4月","2018-04-30","2018-04-30","2018年4月","2018-04-30",1,"2018年4月",2]
[20,"2018-05-31","2018年5月","2018-05-31","2018-05-31","2018年5月","2018-05-31",1,"2018年5月",2]
[21,"2018-06-30","2018年6月","2018-06-30","2018-06-30","2018年6月","2018-06-30",1,"2018年6月",2]
[22,"2018-07-31","2018年7月","2018-07-31","2018-07-31","2018年7月","2018-07-31",1,"2018年7月",2]
[23,"2018-08-31","2018年8月","2018-08-31","2018-08-31","2018年8月","2018-08-31",1,"2018年8月",2]
[24,"2018-09-30","2018年9月","2018-09-30","2018-09-30","2018年9月","2018-09-30",1,"2018年9月",2]