{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["利用手順","調査票","リスト","出力CSVデータレイアウト定義","入力CSVデータレイアウト定義"],"not_rendered":{"charts":0,"images":14,"macros":1,"external_links":2,"defined_names":274,"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":135,"n_cols":8,"rows_kept":135,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"１．「調査票」シートの黄色いセルの調査項目に入力してください。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"２．入力チェックを実施し、入力誤りを訂正してください。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"　　チェック後、エラーがある場合はメッセージが表示され、対象箇所のセルが赤色となります。"]
[null,"　　エラー内容に従い、誤りを訂正してください。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"　　訂正後、再度、エラーチェックボタンをクリックし、エラーが無くなった場合は"]
[null,"　　エラーが無い旨のメッセージが表示されます。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"３．「調査票」シートを印刷してください。または「XMLファイル出力」をし、"]
[null,"　　オンライン調査システムにて回答を送信してください。"]
[]
[null,"　　＜XMLファイル出力方法＞"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"　　エラーがなければ、「オンライン登録の確認」のメッセージが表示されますので、「はい」を押してください。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"　　事業所名を入力して、ファイルを保存してください。"]
[]
[null,null,null,null,null,null,null,"※調査票画面表示のみに使います。"]
[null,null,null,null,null,null,null,"　 名称変更がある場合は、"]
[null,null,null,null,null,null,null," 　別途ご連絡ください。"]
[]
[]
[]
[]
[]
[]
[null,"　　＜オンライン調査システムのXMLファイル回答送信方法＞"]
[]
[null,"　　オンライン調査システム（https://www.e-survey.go.jp/）にログインし、回答する月の調査票を開き、"]
[null,"　　調査票の画面左上「読み込み」ボタンより、先ほど保存したXMLファイルを読み込みます。"]

{"sheet":"調査票","index":1,"n_rows":61,"n_cols":53,"rows_kept":61,"cut":false,"hidden":false,"merged":[[52,44,53,46],[52,47,53,48],[53,40,53,43],[52,40,52,43],[54,5,54,6],[54,13,54,14],[49,4,50,7],[49,25,50,25],[7,28,8,28],[7,29,8,29],[7,30,8,30],[7,31,8,31],[39,18,42,19],[39,20,42,22],[39,23,42,25],[39,26,42,29],[7,32,8,32],[49,44,51,50],[52,5,52,6],[52,13,52,14],[52,49,53,50],[53,5,53,6],[53,13,53,14],[44,4,47,5],[38,45,38,46],[39,37,42,43],[39,45,39,49],[42,45,42,49],[33,44,35,50],[44,6,47,7],[44,8,47,9],[44,10,47,11],[44,12,47,13],[46,44,46,47],[46,48,46,49],[47,44,47,47],[47,48,47,49],[44,34,47,36],[44,37,47,43],[44,14,47,17],[44,18,47,19],[44,20,47,22],[44,23,47,25],[44,26,47,29],[44,30,47,33],[43,44,44,50],[35,18,38,19],[35,20,38,22],[39,3,39,5],[39,6,42,7],[39,8,42,9],[39,10,42,11],[39,12,42,13],[39,14,42,17],[42,3,42,5],[35,6,38,7],[35,8,38,9],[35,10,38,11],[35,12,38,13],[35,14,38,17],[35,23,38,25],[32,18,34,19],[32,20,34,22],[32,23,34,25],[32,26,34,29],[32,30,34,33],[32,37,34,43],[35,26,38,29],[35,30,38,33],[35,37,38,43],[20,3,20,7],[28,20,28,22],[29,20,29,22],[30,20,30,22],[31,20,31,22],[32,3,32,5],[32,6,34,7],[32,8,34,9],[32,10,34,11],[32,12,34,13],[32,14,34,17],[22,12,28,13],[22,20,22,22],[54,25,57,38],[52,26,52,38],[53,26,53,38],[2,36,2,43],[4,28,5,32],[4,33,5,48],[12,35,14,35],[12,36,14,36],[12,37,14,37],[12,38,14,38],[12,39,14,40],[23,44,23,50],[25,44,25,50],[27,44,27,50],[12,28,14,28],[12,29,14,30],[12,31,14,31],[12,32,14,32],[12,33,14,33],[12,34,14,34],[12,43,14,43],[12,44,14,44],[39,30,42,33],[39,34,42,36],[13,5,13,8],[13,9,13,10],[12,41,14,41],[12,42,14,42],[22,30,30,33],[22,37,30,43],[23,18,30,19],[23,20,23,22],[23,34,30,36],[19,8,20,19],[19,20,20,22],[19,23,19,29],[19,30,20,50],[12,50,14,50],[20,23,20,29],[12,45,14,45],[12,48,14,48],[27,3,27,7],[27,20,27,22],[24,20,24,22],[25,3,25,7],[25,20,25,22],[26,20,26,22],[21,3,22,7],[4,49,5,50],[5,19,6,22],[6,5,7,12],[6,34,7,48],[10,43,11,45],[10,46,10,48],[10,49,10,50],[11,39,11,41],[11,46,11,48],[11,49,11,50],[8,44,9,50],[10,28,11,30],[10,31,11,37],[10,38,10,42]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"統計法に基づく基幹統計調査"]
[]
[null,null,null,null,"１　主要な生産品又は事業の内容は何ですか。",null,null,null,null,null,null,null,null,null,null,null,null,"３　調査期間中に事業活動を行った日数は何日でしたか。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"毎月勤労統計調査調査票",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"秘"]
[null,null,null,null,"（主要なものとは、総収入の最も多いものです。）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"日"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"令和",null,"年",null,"月分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"４　企業の全常用労働者数は何人ですか。該当の番号を○",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"厚 生 労 働 省"]
[null,null,null,null,"２　調査期間はいつからいつまででしたか。（前月の",null,null,null,null,null,null,null,null,null,null,null,"　で囲んでください。（貴企業（同一会社）に属する事業","　で囲んでください。（貴企業（同一会社）に属する事業"]
[null,null,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,null,null,null,"産業分類番号",null,null,null,null,"抽出率番号",null,null,"※事業所",null,null,"※ 企業"]
[null,null,null,null,"　までの1ヵ月間です。）",null,null,null,null,null,null,null,null,null,null,null,null,null,1," 1,000人以上",null,4," 30～99人",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"大","中",null,null,"小",null,null,null,"規模番号",null,null,"規模番号"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2," 300～999人",null,5," 5～29人"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3," 100～299人"]
[]
[null,null,null," 　常用労働者についてお答えください。　常用労働者とは、期間を定めずに、又は1か月以上の期間を定めて雇われている者",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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日の所定労働時間が一般の労働者よりも短い者及び1日の所定労働時間が一般の労働者と同じで1週の所定労働日数が一般の労働者よりも少ない者です。"]
[]
[null,null,null,null,null,null,null,null,"5　常　用　労　働　者　数",null,null,null,null,null,null,null,null,null,null,null,"6　出勤日数",null,null,"7　実　労　働　時　間　数",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,null,null,null,null,"(休憩時間は含めないでください。)"]
[null,null,null,"常用労働者"]
[null,null,null,null,null,null,null,null," (1)　前調査",null," (2)　採用、",null," (3)　解雇、\n 退職、転勤\n 等による減\n 少は何人で\n したか。",null," (4)　本調査",null,null,null,null,null," 実際に出勤した",null,null," (1)　所定内労働",null,null," (2) 所定外労働",null,null,null," (1)　きまって支\n 給する給与の総\n 額はいくらでし\n たか。（労働協\n 約、就業規則等\n に支給条件、算\n 定方法等が定め\n られている給与\n です。）",null,null,null,null,null,null,"  (3)　特別に支払われた給\n  与の総額はいくらでした \n  か。(盆、暮等の賞与、\n  3ヵ月を超える期間で算\n  定される給与、ベースアッ\n  プの差額追給分及び支給\n  事由の発生が不確実な給\n  与です。）"]
[null,null,null,null,null,null,null,null," ",null," ",null,null,null,null,null,null,null," (5)　うち、 \n パートタイ\n ム労働者は\n 何人でした\n か。",null," 日の合計は延べ",null,null,null,null,null,null,null,null,null,null,null,null,null,"(2)　うち、超過\n労働給与の総額\nはいくらでした\nか。(残業手当、\n深夜手当等です.)",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," 時間の合計は延",null,null," 時間の合計は延"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," (有給休暇は含",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," た給与の名称及び名称別"]
[null,null,null,null,null,null,null,null," は何人でし",null," る増加は何",null,null,null," は何人でし",null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 日に数えてくだ"]
[null,null,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,null,null,{"$f":"問5_1_男+問5_2_男-問5_3_男","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,null,null,null,null," 計欄に記入して"]
[null,null,null,null,null,null,2,null,null,null,null,null,null,null,{"$f":"問5_1_女+問5_2_女-問5_3_女","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," ②定昇・ベースアップ等"]
[null,null,null,null,"女",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"　の追給"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  (",null,null,")月分"]
[null,null,null,null,null,null,3,null,{"$f":"問5_1_男+問5_1_女","v":0},null,{"$f":"問5_2_男+問5_2_女","v":0},null,{"$f":"問5_3_男+問5_3_女","v":0},null,{"$f":"問5_4_男+問5_4_女","v":0},null,null,null,null,null,{"$f":"問6_男+問6_女","v":0},null,null,{"$f":"問7_1_男+問7_1_女","v":0},null,null,{"$f":"問7_2_男+問7_2_女","v":0},null,null,null,{"$f":"問8_1_男+問8_1_女","v":0},null,null,null,null,null,null,{"$f":"問8_3_男+問8_3_女","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," ③3ヵ月を超える期間で"]
[null,null,null,null,"計",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"　算定される通勤手当"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"千円"]
[null,null,null,null,null,null,null,null,"　　　◎　計のうち、パートタイム労働者分について記入してください。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,{"$f":"問5_5_男+問5_5_女","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,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"千円"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 変動状況",null,null,null,"　　　調査期間中に、次のことがあった場合は該当事項の数字を○で囲い、右の備考欄に",null,null,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,null,null,"　　　その概略を記入してください。",null,null,null,null,null,null,null,null,null,null,null,null,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,null,4,null," 休日に操業、営業等の事業活動を行った。",null,null,null,null,null,null,null,null,null,"","正社員←→パート（アルバイト）の就業形態変更",null,null,null,null,null,null,null,null,null,null,null,null,null,"調　査　票"]
[null,null,null,null,null,2,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,null,null,null,null,null,"提出年月日"]
[null,null,null,null,null,3,null," 操業短縮、一時休業を実施した。",null,null,null,null,null,6,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,"　この調査の実施に当たっては、特に必要がある場合には、資料の提出のお願いや関係者の方々への質問を行うことがあります。"]

{"sheet":"リスト","index":2,"n_rows":22,"n_cols":16,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["産業分類_大分類","4_企業の全常用労働者数_1000人以上","4_企業の全常用労働者数_300～999人","4_企業の全常用労働者数_100～299人","4_企業の全常用労働者数_30～99人","4_企業の全常用労働者数_5～29人","9_変動状況_1_定昇実施","9_変動状況_2_ベースアップ","9_変動状況_3_操業短縮","9_変動状況_4_休日操業","9_変動状況_5_所定労働時間短縮","9_変動状況_6_休日増加","元号","元号_年","登録事業所名（ユーザー定義）","チェック記号"]
[null,1,2,3,4,5,1,2,3,4,5,6,"平成",31,"※ここに事業所名を入力してください。"]
["C","①","②","③","④","⑤","①","②","③","④","⑤","⑥","令和",1,null,"■"]
["D",null,null,null,null,null,null,null,null,null,null,null,null,2]
["E",null,null,null,null,null,null,null,null,null,null,null,null,3]
["F",null,null,null,null,null,null,null,null,null,null,null,null,4]
["G",null,null,null,null,null,null,null,null,null,null,null,null,5]
["H",null,null,null,null,null,null,null,null,null,null,null,null,6]
["I",null,null,null,null,null,null,null,null,null,null,null,null,7]
["J",null,null,null,null,null,null,null,null,null,null,null,null,8]
["K",null,null,null,null,null,null,null,null,null,null,null,null,9]
["L",null,null,null,null,null,null,null,null,null,null,null,null,10]
["M",null,null,null,null,null,null,null,null,null,null,null,null,11]
["N",null,null,null,null,null,null,null,null,null,null,null,null,12]
["O",null,null,null,null,null,null,null,null,null,null,null,null,13]
["P",null,null,null,null,null,null,null,null,null,null,null,null,14]
["Q",null,null,null,null,null,null,null,null,null,null,null,null,15]
["R",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,17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,20]

{"sheet":"出力CSVデータレイアウト定義","index":3,"n_rows":2,"n_cols":56,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["都道府県番号","事業所一連番号","1_主要な生産品又は事業","2_調査期間_開始月","2_調査期間_開始日","2_調査期間_終了月","2_調査期間_終了日","3_事業活動日数","4_企業の全常用労働者数","5_常用労働者数_(1)前月末労働者数_男","5_常用労働者数_(2)増加数_男","5_常用労働者数_(3)減少数_男","5_常用労働者数_(5)うちパート_男","6_出勤日数_男","7_実労働時間数_(1)所定内労働時間_男","7_実労働時間数_(2)所定外労働時間_男","8_現金給与額_(1)きまって支給する給与_男","8_現金給与額_(3)特別に支払われた給与_男","5_常用労働者数_(1)前月末労働者数_女","5_常用労働者数_(2)増加数_女","5_常用労働者数_(3)減少数_女","5_常用労働者数_(5)うちパート_女","6_出勤日数_女","7_実労働時間数_(1)所定内労働時間_女","7_実労働時間数_(2)所定外労働時間_女","8_現金給与額_(1)きまって支給する給与_女","8_現金給与額_(3)特別に支払われた給与_女","8_現金給与額_(2)超過労働の給与_計","5_常用労働者数_(1)前月末労働者数_パート","5_常用労働者数_(2)増加数_パート","5_常用労働者数_(3)減少数_パート","6_出勤日数_パート","7_実労働時間数_(2)所定外労働時間_パート","7_実労働時間数_(2)所定外労働時間_パート","8_現金給与額_(1)きまって支給する給与_パート","8_現金給与額_(2)超過労働の給与_パート","8_現金給与額_(3)特別に支払われた給与_パート","8_現金給与額_(4)①賞与","8_現金給与額_(4)②定昇_追給開始月","8_現金給与額_(4)②定昇_追給終了月","8_現金給与額_(4)②定昇_追給金額","8_現金給与額_(4)③通勤手当","8_現金給与額_(4)④名称","8_現金給与額_(4)④金額","8_現金給与額_(4)⑤名称","8_現金給与額_(4)⑤金額","9_変動状況_1_定昇実施","9_変動状況_2_ベースアップ","9_変動状況_3_操業短縮","9_変動状況_4_休日操業","9_変動状況_5_所定労働時間短縮","9_変動状況_6_休日増加","10_備考","記入担当者氏名","10_1","10_2"]
[{"$f":"IF(都道府県番号1=\"\",\" \",都道府県番号1)&IF(都道府県番号2=\"\",\" \",都道府県番号2)","v":"  "},{"$f":"IF(事業所一連番号1=\"\",\" \",事業所一連番号1)&IF(事業所一連番号2=\"\",\" \",事業所一連番号2)&IF(事業所一連番号3=\"\",\" \",事業所一連番号3)&IF(事業所一連番号4=\"\",\" \",事業所一連番号4)&IF(事業所一連番号5=\"\",\" \",事業所一連番号5)&IF(事業所一連番号6=\"\",\" \",事業所一連番号6)&IF(事業所一連番号7=\"\",\" \",事業所一連番号7)","v":"       "},null,{"$f":"IF(問2_開始月=\"\", \"\",RIGHT(0 & 問2_開始月, 2))","v":""},{"$f":"IF(問2_開始日=\"\", \"\",RIGHT(0 & 問2_開始日, 2))","v":""},{"$f":"IF(問2_終了月=\"\",\"\",RIGHT(0 & 問2_終了月, 2))","v":""},{"$f":"IF(問2_終了日=\"\",\"\",RIGHT(0 & 問2_終了日, 2))","v":""},{"$f":"IF(問3=\"\",\"\",RIGHT(0 & 問3, 2))","v":""},{"$f":"IF(問4_1=\"①\",1,IF(問4_2=\"②\",2,IF(問4_3=\"③\",3,IF(問4_4=\"④\",4,IF(問4_5=\"⑤\",5,\"\")))))","v":""},{"$f":"IF(問5_1_男=\"\",\"\",問5_1_男)","v":""},{"$f":"IF(問5_2_男=\"\",\"\",問5_2_男)","v":""},{"$f":"IF(問5_3_男=\"\",\"\",問5_3_男)","v":""},{"$f":"IF(問5_5_男=\"\",\"\",問5_5_男)","v":""},{"$f":"IF(問6_男=\"\",\"\",問6_男)","v":""},{"$f":"IF(問7_1_男=\"\",\"\",問7_1_男)","v":""},{"$f":"IF(問7_2_男=\"\",\"\",問7_2_男)","v":""},{"$f":"IF(問8_1_男=\"\",\"\",問8_1_男)","v":""},{"$f":"IF(問8_3_男=\"\",\"\",問8_3_男)","v":""},{"$f":"IF(問5_1_女=\"\",\"\",問5_1_女)","v":""},{"$f":"IF(問5_2_女=\"\",\"\",問5_2_女)","v":""},{"$f":"IF(問5_3_女=\"\",\"\",問5_3_女)","v":""},{"$f":"IF(問5_5_女=\"\",\"\",問5_5_女)","v":""},{"$f":"IF(問6_女=\"\",\"\",問6_女)","v":""},{"$f":"IF(問7_1_女=\"\",\"\",問7_1_女)","v":""},{"$f":"IF(問7_2_女=\"\",\"\",問7_2_女)","v":""},{"$f":"IF(問8_1_女=\"\",\"\",問8_1_女)","v":""},{"$f":"IF(問8_3_女=\"\",\"\",問8_3_女)","v":""},{"$f":"IF(問8_2_計=\"\",\"\",問8_2_計)","v":""},{"$f":"IF(問5_1_パート=\"\",\"\",問5_1_パート)","v":""},{"$f":"IF(問5_2_パート=\"\",\"\",問5_2_パート)","v":""},{"$f":"IF(問5_3_パート=\"\",\"\",問5_3_パート)","v":""},{"$f":"IF(問6_パート=\"\",\"\",問6_パート)","v":""},{"$f":"IF(問7_1_パート=\"\",\"\",問7_1_パート)","v":""},{"$f":"IF(問7_2_パート=\"\",\"\",問7_2_パート)","v":""},{"$f":"IF(問8_1_パート=\"\",\"\",問8_1_パート)","v":""},{"$f":"IF(問8_2_パート=\"\",\"\",問8_2_パート)","v":""},{"$f":"IF(問8_3_パート=\"\",\"\",問8_3_パート)","v":""},{"$f":"IF(問8_4_①賞与=\"\",\"\",問8_4_①賞与)","v":""},{"$f":"IF(問8_4_②定昇_追給開始月=\"\",\"\",問8_4_②定昇_追給開始月)","v":""},{"$f":"IF(問8_4_②定昇_追給終了月=\"\",\"\",問8_4_②定昇_追給終了月)","v":""},{"$f":"IF(問8_4_②定昇_追給金額=\"\",\"\",問8_4_②定昇_追給金額)","v":""},{"$f":"IF(問8_4_③通勤手当=\"\",\"\",問8_4_③通勤手当)","v":""},null,{"$f":"IF(問8_4_④金額=\"\",\"\",問8_4_④金額)","v":""},null,{"$f":"IF(問8_4_⑤金額=\"\",\"\",問8_4_⑤金額)","v":""},{"$f":"IF(問9_1=\"①\",1,IF(問9_1=\"1\",0,0))","v":0},{"$f":"IF(問9_2=\"②\",1,IF(問9_2=\"2\",0,0))","v":0},{"$f":"IF(問9_3=\"③\",1,IF(問9_3=\"3\",0,0))","v":0},{"$f":"IF(問9_4=\"④\",1,IF(問9_4=\"4\",0,0))","v":0},{"$f":"IF(問9_5=\"⑤\",1,IF(問9_5=\"5\",0,0))","v":0},{"$f":"IF(問9_6=\"⑥\",1,IF(問9_6=\"6\",0,0))","v":0},null,null,{"$f":"IF(問10_1=\"■\",1,IF(問10_1=\"\",0,0))","v":0},{"$f":"IF(問10_2=\"■\",1,IF(問10_2=\"\",0,0))","v":0}]

{"sheet":"入力CSVデータレイアウト定義","index":4,"n_rows":9,"n_cols":67,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["CSVデータレイアウト"]
["都道府県番号","事業所一連番号","1_主要な生産品又は事業","2_調査期間_開始月","2_調査期間_開始日","2_調査期間_終了月","2_調査期間_終了日","3_事業活動日数","4_企業の全常用労働者数","5_常用労働者数_(1)前月末労働者数_男","5_常用労働者数_(2)増加数_男","5_常用労働者数_(3)減少数_男","5_常用労働者数_(5)うちパート_男","6_出勤日数_男","7_実労働時間数_(1)所定内労働時間_男","7_実労働時間数_(2)所定外労働時間_男","8_現金給与額_(1)きまって支給する給与_男","8_現金給与額_(3)特別に支払われた給与_男","5_常用労働者数_(1)前月末労働者数_女","5_常用労働者数_(2)増加数_女","5_常用労働者数_(3)減少数_女","5_常用労働者数_(5)うちパート_女","6_出勤日数_女","7_実労働時間数_(1)所定内労働時間_女","7_実労働時間数_(2)所定外労働時間_女","8_現金給与額_(1)きまって支給する給与_女","8_現金給与額_(3)特別に支払われた給与_女","8_現金給与額_(2)超過労働の給与_計","5_常用労働者数_(1)前月末労働者数_パート","5_常用労働者数_(2)増加数_パート","5_常用労働者数_(3)減少数_パート","6_出勤日数_パート","7_実労働時間数_(2)所定外労働時間_パート","7_実労働時間数_(2)所定外労働時間_パート","8_現金給与額_(1)きまって支給する給与_パート","8_現金給与額_(2)超過労働の給与_パート","8_現金給与額_(3)特別に支払われた給与_パート","8_現金給与額_(4)①賞与","8_現金給与額_(4)②定昇_追給開始月","8_現金給与額_(4)②定昇_追給終了月","8_現金給与額_(4)②定昇_追給金額","8_現金給与額_(4)③通勤手当","8_現金給与額_(4)④名称","8_現金給与額_(4)④金額","8_現金給与額_(4)⑤名称","8_現金給与額_(4)⑤金額","9_変動状況_1_定昇実施","9_変動状況_2_ベースアップ","9_変動状況_3_操業短縮","9_変動状況_4_休日操業","9_変動状況_5_所定労働時間短縮","9_変動状況_6_休日増加","10_備考","記入担当者氏名","10_1","10_2"]
["12","1111111","","","","","","","","5","5","5","5","5","5","","5","","5","5","5","5","5","5","","5","","","41","4","2","5","5","","5","","","","","","","","","","","","0","0","0","0","0","0","","",0,1]
[]
["↓"]
[]
["インポート用データ変換"]
["都道府県番号1","都道府県番号2","事業所一連番号1","事業所一連番号2","事業所一連番号3","事業所一連番号4","事業所一連番号5","事業所一連番号6","事業所一連番号7","問1","問2_開始月","問2_開始日","問2_終了月","問2_終了日","問3","問4_1","問4_2","問4_3","問4_4","問4_5","問5_1_男","問5_2_男","問5_3_男","問5_5_男","問6_男","問7_1_男","問7_2_男","問8_1_男","問8_3_男","問5_1_女","問5_2_女","問5_3_女","問5_5_女","問6_女","問7_1_女","問7_2_女","問8_1_女","問8_3_女","問8_2_計","問5_1_パート","問5_2_パート","問5_3_パート","問6_パート","問7_1_パート","問7_2_パート","問8_1_パート","問8_2_パート","問8_3_パート","問8_4_①賞与","問8_4_②定昇_追給開始月","問8_4_②定昇_追給終了月","問8_4_②定昇_追給金額","問8_4_③通勤手当","問8_4_④名称","問8_4_④金額","問8_4_⑤名称","問8_4_⑤金額","問9_1","問9_2","問9_3","問9_4","問9_5","問9_6","問10_3","記入担当者氏名","問10_1","問10_2"]
[{"$f":"MID($A$3,1,1)","v":"1"},{"$f":"MID($A$3,2,1)","v":"2"},{"$f":"MID($B$3,1,1)","v":"1"},{"$f":"MID($B$3,2,1)","v":"1"},{"$f":"MID($B$3,3,1)","v":"1"},{"$f":"MID($B$3,4,1)","v":"1"},{"$f":"MID($B$3,5,1)","v":"1"},{"$f":"MID($B$3,6,1)","v":"1"},{"$f":"MID($B$3,7,1)","v":"1"},{"$f":"IF(C3=\"\",\"\",C3)","v":""},{"$f":"IF(D3=\"0\",\"\",D3)","v":""},{"$f":"IF(E3=\"0\",\"\",E3)","v":""},"","","",{"$f":"IF($I$3=\"1\",\"①\",\"1\")","v":"1"},{"$f":"IF($I$3=\"2\",\"②\",\"2\")","v":"2"},{"$f":"IF($I$3=\"3\",\"③\",\"3\")","v":"3"},{"$f":"IF($I$3=\"4\",\"④\",\"4\")","v":"4"},{"$f":"IF($I$3=\"5\",\"⑤\",\"5\")","v":"5"},{"$f":"IF(J3=\"\",\"\",J3)","v":"5"},{"$f":"IF(K3=\"\",\"\",K3)","v":"5"},"5","5","5","5","","5","","5","5","5","5","5","5","","5","","","41","4","2","5","5","","5","","","","","","","","","","","",{"$f":"IF(AU3=\"1\",\"①\",\"1\")","v":"1"},{"$f":"IF(AV3=\"1\",\"②\",\"2\")","v":"2"},{"$f":"IF(AW3=\"1\",\"③\",\"3\")","v":"3"},{"$f":"IF(AX3=\"1\",\"④\",\"4\")","v":"4"},{"$f":"IF(AY3=\"1\",\"⑤\",\"5\")","v":"5"},{"$f":"IF(AZ3=\"1\",\"⑥\",\"6\")","v":"6"},{"$f":"IF(BA3=\"\",\"\",BA3)","v":""},{"$f":"IF(BB3=\"\",\"\",BB3)","v":""},{"$f":"IF(BC3=1,\"■\",\"\")","v":""},{"$f":"IF(BD3=1,\"■\",\"\")","v":"■"}]