{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["はじめに","個人別データ","Q1-1","Q1-2","Q2-1","Q2-2","Q3～Q9","Q会社情報"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":0,"defined_names":10,"comments":7,"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":181,"n_cols":5,"rows_kept":181,"cut":false,"hidden":false,"merged":[[180,1,180,5],[2,1,2,5],[3,1,3,5],[13,4,14,5],[37,1,37,5],[59,1,59,5],[4,1,4,5],[8,1,8,5],[9,1,9,5]]}
[null,"はじめに"]
[]
[null,"調査票を簡単に入力していただけるよう、このExcelファイルにはマクロが組み込まれております。\nExcelのマクロが実行可能でないと調査票は表示されないようになっております。"]
[null,"入力シートが表示されていない場合は、下記の「Excelの設定確認」を参考に設定を行ってください。\n表示されているスクリーンショットは Excel 2021 のものですが、他のバージョン（Excel 2007～2024、Office 365、JUST Calc等）でもほぼ同様です。（お使いのOSおよびExcelのバージョンにより、表示されるウィンドウ・メッセージ等が少々異なる場合があります。）"]
[null,"また、下図のような赤色で警告メッセージが表示されている場合は、「Excelファイルを開くとき④」を参考に設定を行ってください。この設定を行う場合はこのファイルを閉じて作業する必要があります。"]
[]
[]
[null,"この調査票の入力補助機能について"]
[null,"一部のセルでは入力のときに説明がポップアップ表示されますが、次のボタンで表示・非表示を変えられます。"]
[null,"昨年度の調査票のExcelデータ、または送信用データを取り込むことで、会社名や住所などの入力を一部省略することができます。なお、すでに入力済みのデータは上書きされます。\n下のボタンを押して、有効な調査票データ（Excelまたは送信用TTK）を指定してください。"]
[]
[null,"Excelの設定確認　※この手順は1度行うだけで完了します"]
[null,"≪Office 2010～2021の場合≫",null,null,"≪Office 2007の場合≫"]
[null,"①Excelを起動し、[ファイル]タブをクリックします。",null,null,"①Excelを起動し、[Officeボタン]→[Excel のオプション]の順にクリックします。　 ※そのまま③へ進みます"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"②[オプション]をクリックします"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"③[Excelのオプション]ウィンドウが表示されますので、[トラストセンター]→[トラストセンターの設定]、\nまたは[セキュリティ センター]→[セキュリティ センターの設定]の順にクリックします。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"④[トラストセンター]、または[セキュリティ センター]ウィンドウが表示されますので、[マクロの設定]をクリックし、\n [警告して、VBA マクロを無効にする]、または[警告を表示してすべてのマクロを無効にする]にチェックが入っている場合は[OK]をクリックします。\nチェックが入っていない場合は [警告して、VBA マクロを無効にする]、または[警告を表示してすべてのマクロを無効にする]にチェックを入れ、[OK]をクリックします。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"⑤[Excelのオプション]ウィンドウに戻りますので、[OK]をクリックし、Excelを終了します。"]
[]
[null,"Excelファイルを開くとき①（マクロのブロック解除）"]
[null,"下図のような警告メッセージが表示されている場合、ブロックの解除を行う必要があります。"]
[]
[]
[null,"以下の手順に従って、ブロックの解除を行ってください。"]
[null,"①このExcelファイルの保存場所を開きます。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"②Excelファイルを右クリックし、表示されるメニューリストの中から[プロパティ]を選択します。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"③[全般]タブのセキュリティ項目[許可する]にチェックを入れます。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"④[適用]→[OK]の順にクリックし、設定は終了です。"]
[]
[null,"Excelファイルを開くとき②（編集許可）"]
[null,"下図のような警告メッセージが表示される場合、[編集を有効にする]をクリックします。"]
[null,"※インターネットや電子メールからダウンロード直後に当Excelファイルを開くと、表示される可能性があります。"]
[]
[]
[]
[]
[null,"Excelファイルを開くとき③（マクロ実行の許可）"]
[null,"下図のような警告メッセージが表示される場合、[コンテンツの有効化]をクリックします。"]
[]
[]
[null,"下図のような警告ウィンドウが表示される場合、[マクロを有効にする]をクリックします。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Excelファイルを開くとき④（信頼済みドキュメントの有効化）"]
[null,"下図のような警告ウィンドウが表示される場合、[はい]をクリックします。"]
[null,"※ネットワークドライブ上に保存された当Excelファイルを初めて開くと、表示される可能性があります。」"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"上記の設定を行っても6つの入力シートが自動的に表示されない場合は、下のボタンをクリックしてください。\n　"]

{"sheet":"個人別データ","index":1,"n_rows":26,"n_cols":34,"rows_kept":26,"cut":false,"hidden":true,"merged":[[0,0,0,1],[7,19,7,23],[5,0,6,0],[6,33,8,33],[7,26,7,27],[7,28,7,29],[7,30,7,31],[7,9,7,13],[7,14,7,18],[6,26,6,31],[6,9,6,23],[6,24,8,24],[6,25,8,25],[6,32,8,32]]}
[5,null,"個人別データの入力"]
["固定給のみ","時間外あり","運行手当など歩合給あり"]
["けん引運転者","大型運転者","中型運転者","準中型運転者","普通運転者","事務員","荷扱手","整備・技能員"]
["20歳未満","20歳未満","20歳未満","20歳未満","20～30歳未満","20～30歳未満","30～40歳未満","30～40歳未満","40～50歳未満","40～50歳未満","50～60歳未満","50～60歳未満","60～65歳未満","65歳以上","65歳以上","65歳以上","65歳以上","65歳以上","65歳以上","65歳以上"]
[]
["賃金\nタイプ"]
[null,null,null,null,null,null,null,null,null,{"$f":"\"令和\"&$A$1&\"年の賃金\"","v":"令和5年の賃金"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"令和\"&$A$1-1&\"年\n冬期賞与\"","v":"令和4年\n冬期賞与"},{"$f":"\"令和\"&$A$1&\"年\n夏期賞与\"","v":"令和5年\n夏期賞与"},{"$f":"\"令和\"&$A$1&\"年の労働時間\"","v":"令和5年の労働時間"},null,null,null,null,null,{"$f":"\"令和\"&$A$1-1&\"年度\n年間\n実労働時間\"","v":"令和4年度\n年間\n実労働時間"},{"$f":"\"令和\"&$A$1-1&\"年度\n有給休暇\n取得日数\"","v":"令和4年度\n有給休暇\n取得日数"}]
[null,true,true,true,true,true,true,null,null,"5月",null,null,null,null,"6月",null,null,null,null,"7月",null,null,null,null,null,null,"5月",null,"6月",null,"7月"]
["有効","名前","性別","生年月","年齢","年齢区分","入社年月","勤続月","職種","固定給","運行手当","歩合他","時間外","その他","固定給","運行手当","歩合他","時間外","その他","固定給","運行手当","歩合他","時間外","その他",null,null,"所定内","所定外","所定内","所定外","所定内","所定外"]
[null,"山田　太郎","男性","1990-10-10",{"$f":"IF(D10<>\"\",DATEDIF(D10,DATEVALUE($A$1+2018&\"/7/31\"),\"Y\"),\"\")","v":32},{"$f":"IF(E10<>\"\",INT(E10*2/10)&\") \"&INDIRECT(ADDRESS(4,INT(E10*2/10)+1)),\"\")","v":"6) 30～40歳未満"},"1905-06-22",{"$f":"IF(G10<>\"\",DATEDIF(G10,DATEVALUE($A$1+2018&\"/7/31\"),\"M\")&\"月\",\"\")","v":"1417月"}]
[null,"山本　和子","女性","2000-01-01",23,{"$f":"IF(E11<>\"\",INT(E11*2/10)&\") \"&INDIRECT(ADDRESS(4,INT(E11*2/10)+1)),\"\")","v":"4) 20～30歳未満"},"2020-04-01","39月","大型運転者",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,3]
[null,null,null,"1995-01-01",28,{"$f":"IF(E12<>\"\",INT(E12*2/10)&\") \"&INDIRECT(ADDRESS(4,INT(E12*2/10)+1)),\"\")","v":"5) 20～30歳未満"},null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,"2009-01-02",14,{"$f":"IF(E13<>\"\",INT(E13*2/10)&\") \"&INDIRECT(ADDRESS(4,INT(E13*2/10)+1)),\"\")","v":"2) 20歳未満"},null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,"2003-01-01",20,{"$f":"IF(E14<>\"\",INT(E14*2/10)&\") \"&INDIRECT(ADDRESS(4,INT(E14*2/10)+1)),\"\")","v":"4) 20～30歳未満"},null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,"2004-01-01",19,{"$f":"IF(E15<>\"\",INT(E15*2/10)&\") \"&INDIRECT(ADDRESS(4,INT(E15*2/10)+1)),\"\")","v":"3) 20歳未満"},null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,"2015-01-01",8,{"$f":"IF(E16<>\"\",INT(E16*2/10)&\") \"&INDIRECT(ADDRESS(4,INT(E16*2/10)+1)),\"\")","v":"1) 20歳未満"},null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,"2018-02-02",5,{"$f":"IF(E17<>\"\",INT(E17*2/10)&\") \"&INDIRECT(ADDRESS(4,INT(E17*2/10)+1)),\"\")","v":"1) 20歳未満"},null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,"",{"$f":"IF(E18<>\"\",INT(E18*2/10)&\") \"&INDIRECT(ADDRESS(4,INT(E18*2/10)+1)),\"\")","v":""},null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,"",{"$f":"IF(E19<>\"\",INT(E19*2/10)&\") \"&INDIRECT(ADDRESS(4,INT(E19*2/10)+1)),\"\")","v":""},null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,"",{"$f":"IF(E20<>\"\",INT(E20*2/10)&\") \"&INDIRECT(ADDRESS(4,INT(E20*2/10)+1)),\"\")","v":""},null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,"",{"$f":"IF(E21<>\"\",INT(E21*2/10)&\") \"&INDIRECT(ADDRESS(4,INT(E21*2/10)+1)),\"\")","v":""},null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,"",{"$f":"IF(E22<>\"\",INT(E22*2/10)&\") \"&INDIRECT(ADDRESS(4,INT(E22*2/10)+1)),\"\")","v":""},null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[null,null,null,null,"",{"$f":"IF(E23<>\"\",INT(E23*2/10)&\") \"&INDIRECT(ADDRESS(4,INT(E23*2/10)+1)),\"\")","v":""},null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
[null,null,null,null,"",{"$f":"IF(E24<>\"\",INT(E24*2/10)&\") \"&INDIRECT(ADDRESS(4,INT(E24*2/10)+1)),\"\")","v":""},null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
[]
[{"$f":"COLUMN(A25)","v":1},2,3,4,5,6,7,8,9,{"$f":"COLUMN(J25)","v":10},null,null,null,null,{"$f":"COLUMN(O25)","v":15},null,null,null,null,20,null,null,null,null,25,26,27,28,29,30,31,32,33,34]

{"sheet":"Q1-1","index":2,"n_rows":57,"n_cols":12,"rows_kept":57,"cut":false,"hidden":true,"merged":[[0,11,3,11],[0,10,3,10],[4,1,9,1],[10,1,15,1],[16,1,21,1],[0,4,0,9],[1,4,3,4],[1,5,1,8],[1,9,3,9],[2,5,2,6],[2,7,3,7],[2,8,3,8],[0,3,3,3],[1,1,3,1],[1,2,3,2],[29,1,35,1],[36,1,42,1],[43,1,49,1],[50,1,56,1],[22,1,28,1]]}
[{"$f":"COUNTIF(A2:A100,\"NG\")","v":0},"Q1-1. 男性賃金等",null,{"$f":"\"令和\"&WAREKI&CHAR(10)&\"7月末の\n該当人員\"","v":"令和6年\n7月末の\n該当人員"},{"$f":"\"令和\"&WAREKI&\"5～7月の 1人1ヵ月当たり平均賃金　（※千円未満は四捨五入）\"","v":"令和6年5～7月の 1人1ヵ月当たり平均賃金　（※千円未満は四捨五入）"},null,null,null,null,null,"1人1ヵ月の\n固定給\n+\n変動給",{"$f":"\"1人当たり平均\n年間賞与\n(令和\"&WAREKI2&\"冬期\n+ \"&WAREKI&\"夏期)\"","v":"1人当たり平均\n年間賞与\n(令和5年冬期\n+ 6年夏期)"}]
[null,"職種","年齢区分",null,"固定給","変動給"]
[null,null,null,null,null,"歩合給",null,"時間外手当","その他"]
[null,null,null,null,null,"運行手当","その他"]
[{"$f":"IF(OR(AND(D5=0,OR(K5>0,L5>0)),AND(D5>0,OR(K5=0,L5=\"\"))),\"NG\",\"\")","v":""},"男性\nけん引\n運転者","20～30歳未満",null,null,null,null,null,null,{"$f":"F5+G5+H5+I5","v":0},{"$f":"E5+J5","v":0}]
[{"$f":"IF(OR(AND(D6=0,OR(K6>0,L6>0)),AND(D6>0,OR(K6=0,L6=\"\"))),\"NG\",\"\")","v":""},null,"30～40歳未満",null,null,null,null,null,null,0,0]
["",null,"40～50歳未満",null,null,null,null,null,null,0,0]
["",null,"50～60歳未満",null,null,null,null,null,null,0,0]
["",null,"60～65歳未満",null,null,null,null,null,null,0,0]
["",null,"65歳以上",null,null,null,null,null,null,0,0]
["","男性\n大型\n運転者","20～30歳未満",null,null,null,null,null,null,0,0]
["",null,"30～40歳未満",null,null,null,null,null,null,0,0]
["",null,"40～50歳未満",null,null,null,null,null,null,0,0]
["",null,"50～60歳未満",null,null,null,null,null,null,0,0]
["",null,"60～65歳未満",null,null,null,null,null,null,0,0]
["",null,"65歳以上",null,null,null,null,null,null,0,0]
["","男性\n中型\n運転者","20～30歳未満",null,null,null,null,null,null,{"$f":"F17+G17+H17+I17","v":0},0]
["",null,"30～40歳未満",null,null,null,null,null,null,0,0]
["",null,"40～50歳未満",null,null,null,null,null,null,{"$f":"F19+G19+H19+I19","v":0},0]
["",null,"50～60歳未満",null,null,null,null,null,null,0,0]
["",null,"60～65歳未満",null,null,null,null,null,null,0,0]
["",null,"65歳以上",null,null,null,null,null,null,0,0]
["","男性\n準中型\n運転者","20歳未満",null,null,null,null,null,null,0,0]
["",null,"20～30歳未満",null,null,null,null,null,null,0,0]
["",null,"30～40歳未満",null,null,null,null,null,null,0,0]
["",null,"40～50歳未満",null,null,null,null,null,null,0,0]
["",null,"50～60歳未満",null,null,null,null,null,null,0,0]
["",null,"60～65歳未満",null,null,null,null,null,null,0,0]
["",null,"65歳以上",null,null,null,null,null,null,0,0]
["","男性\n普通\n運転者","20歳未満",null,null,null,null,null,null,0,0]
["",null,"20～30歳未満",null,null,null,null,null,null,0,0]
["",null,"30～40歳未満",null,null,null,null,null,null,0,0]
["",null,"40～50歳未満",null,null,null,null,null,null,0,0]
["",null,"50～60歳未満",null,null,null,null,null,null,0,0]
["",null,"60～65歳未満",null,null,null,null,null,null,0,0]
["",null,"65歳以上",null,null,null,null,null,null,0,0]
["","男性\n事務員","20歳未満",null,null,null,null,null,null,0,0]
["",null,"20～30歳未満",null,null,null,null,null,null,0,0]
["",null,"30～40歳未満",null,null,null,null,null,null,0,0]
["",null,"40～50歳未満",null,null,null,null,null,null,0,0]
["",null,"50～60歳未満",null,null,null,null,null,null,0,0]
["",null,"60～65歳未満",null,null,null,null,null,null,0,0]
["",null,"65歳以上",null,null,null,null,null,null,0,0]
["","男性\n荷扱手","20歳未満",null,null,null,null,null,null,0,0]
["",null,"20～30歳未満",null,null,null,null,null,null,0,0]
["",null,"30～40歳未満",null,null,null,null,null,null,0,0]
["",null,"40～50歳未満",null,null,null,null,null,null,0,0]
["",null,"50～60歳未満",null,null,null,null,null,null,0,0]
["",null,"60～65歳未満",null,null,null,null,null,null,0,0]
["",null,"65歳以上",null,null,null,null,null,null,0,0]
["","男性\n整備・\n技能員","20歳未満",null,null,null,null,null,null,0,0]
["",null,"20～30歳未満",null,null,null,null,null,null,0,0]
["",null,"30～40歳未満",null,null,null,null,null,null,0,0]
["",null,"40～50歳未満",null,null,null,null,null,null,0,0]
["",null,"50～60歳未満",null,null,null,null,null,null,0,0]
["",null,"60～65歳未満",null,null,null,null,null,null,0,0]
["",null,"65歳以上",null,null,null,null,null,null,0,0]

{"sheet":"Q1-2","index":3,"n_rows":57,"n_cols":12,"rows_kept":57,"cut":false,"hidden":true,"merged":[[0,10,3,10],[0,11,3,11],[1,1,3,1],[1,2,3,2],[1,4,3,4],[1,5,1,8],[1,9,3,9],[2,5,2,6],[2,8,3,8],[0,4,0,9],[29,1,35,1],[36,1,42,1],[43,1,49,1],[50,1,56,1],[2,7,3,7],[4,1,9,1],[10,1,15,1],[16,1,21,1],[22,1,28,1],[0,3,3,3]]}
[{"$f":"COUNTIF(A2:A100,\"NG\")","v":0},"Q1-2. 女性賃金等",null,{"$f":"\"令和\"&WAREKI&CHAR(10)&\"7月末の\n該当人員\"","v":"令和6年\n7月末の\n該当人員"},{"$f":"\"令和\"&WAREKI&\"5～7月の 1人1ヵ月当たり平均賃金　（※千円未満は四捨五入）\"","v":"令和6年5～7月の 1人1ヵ月当たり平均賃金　（※千円未満は四捨五入）"},null,null,null,null,null,"1人1ヵ月の\n固定給\n+\n変動給",{"$f":"\"1人当たり平均\n年間賞与\n(令和\"&WAREKI2&\"冬期\n+ \"&WAREKI&\"夏期)\"","v":"1人当たり平均\n年間賞与\n(令和5年冬期\n+ 6年夏期)"}]
[null,"職種","年齢区分",null,"固定給","変動給"]
[null,null,null,null,null,"歩合給",null,"時間外手当","その他"]
[null,null,null,null,null,"運行手当","その他"]
[{"$f":"IF(OR(AND(D5=0,OR(K5>0,L5>0)),AND(D5>0,OR(K5=0,L5=\"\"))),\"NG\",\"\")","v":""},"女性\nけん引\n運転者","20～30歳未満",null,null,null,null,null,null,{"$f":"F5+G5+H5+I5","v":0},{"$f":"E5+J5","v":0}]
[{"$f":"IF(OR(AND(D6=0,OR(K6>0,L6>0)),AND(D6>0,OR(K6=0,L6=\"\"))),\"NG\",\"\")","v":""},null,"30～40歳未満",null,null,null,null,null,null,0,0]
["",null,"40～50歳未満",null,null,null,null,null,null,0,0]
["",null,"50～60歳未満",null,null,null,null,null,null,0,0]
["",null,"60～65歳未満",null,null,null,null,null,null,0,0]
["",null,"65歳以上",null,null,null,null,null,null,0,0]
["","女性\n大型\n運転者","20～30歳未満",null,null,null,null,null,null,0,0]
["",null,"30～40歳未満",null,null,null,null,null,null,0,0]
["",null,"40～50歳未満",null,null,null,null,null,null,0,0]
["",null,"50～60歳未満",null,null,null,null,null,null,0,0]
["",null,"60～65歳未満",null,null,null,null,null,null,0,0]
["",null,"65歳以上",null,null,null,null,null,null,0,0]
["","女性\n中型\n運転者","20～30歳未満",null,null,null,null,null,null,{"$f":"F17+G17+H17+I17","v":0},0]
["",null,"30～40歳未満",null,null,null,null,null,null,0,0]
["",null,"40～50歳未満",null,null,null,null,null,null,{"$f":"F19+G19+H19+I19","v":0},0]
["",null,"50～60歳未満",null,null,null,null,null,null,0,0]
["",null,"60～65歳未満",null,null,null,null,null,null,0,0]
["",null,"65歳以上",null,null,null,null,null,null,0,0]
["","女性\n準中型\n運転者","20歳未満",null,null,null,null,null,null,0,0]
["",null,"20～30歳未満",null,null,null,null,null,null,0,0]
["",null,"30～40歳未満",null,null,null,null,null,null,0,0]
["",null,"40～50歳未満",null,null,null,null,null,null,0,0]
["",null,"50～60歳未満",null,null,null,null,null,null,0,0]
["",null,"60～65歳未満",null,null,null,null,null,null,0,0]
["",null,"65歳以上",null,null,null,null,null,null,0,0]
["","女性\n普通\n運転者","20歳未満",null,null,null,null,null,null,0,0]
["",null,"20～30歳未満",null,null,null,null,null,null,0,0]
["",null,"30～40歳未満",null,null,null,null,null,null,0,0]
["",null,"40～50歳未満",null,null,null,null,null,null,0,0]
["",null,"50～60歳未満",null,null,null,null,null,null,0,0]
["",null,"60～65歳未満",null,null,null,null,null,null,0,0]
["",null,"65歳以上",null,null,null,null,null,null,0,0]
["","女性\n事務員","20歳未満",null,null,null,null,null,null,0,0]
["",null,"20～30歳未満",null,null,null,null,null,null,0,0]
["",null,"30～40歳未満",null,null,null,null,null,null,0,0]
["",null,"40～50歳未満",null,null,null,null,null,null,0,0]
["",null,"50～60歳未満",null,null,null,null,null,null,0,0]
["",null,"60～65歳未満",null,null,null,null,null,null,0,0]
["",null,"65歳以上",null,null,null,null,null,null,0,0]
["","女性\n荷扱手","20歳未満",null,null,null,null,null,null,0,0]
["",null,"20～30歳未満",null,null,null,null,null,null,0,0]
["",null,"30～40歳未満",null,null,null,null,null,null,0,0]
["",null,"40～50歳未満",null,null,null,null,null,null,0,0]
["",null,"50～60歳未満",null,null,null,null,null,null,0,0]
["",null,"60～65歳未満",null,null,null,null,null,null,0,0]
["",null,"65歳以上",null,null,null,null,null,null,0,0]
["","女性\n整備・\n技能員","20歳未満",null,null,null,null,null,null,0,0]
["",null,"20～30歳未満",null,null,null,null,null,null,0,0]
["",null,"30～40歳未満",null,null,null,null,null,null,0,0]
["",null,"40～50歳未満",null,null,null,null,null,null,0,0]
["",null,"50～60歳未満",null,null,null,null,null,null,0,0]
["",null,"60～65歳未満",null,null,null,null,null,null,0,0]
["",null,"65歳以上",null,null,null,null,null,null,0,0]

{"sheet":"Q2-1","index":4,"n_rows":55,"n_cols":10,"rows_kept":55,"cut":false,"hidden":true,"merged":[[0,3,1,4],[8,4,13,4],[14,4,19,4],[20,4,26,4],[27,4,33,4],[2,4,7,4],[14,9,19,9],[20,9,26,9],[41,1,47,1],[48,4,54,4],[34,4,40,4],[41,4,47,4],[48,9,54,9],[27,9,33,9],[34,9,40,9],[41,9,47,9],[48,1,54,1],[34,1,40,1],[2,1,7,1],[8,1,13,1],[14,1,19,1],[20,1,26,1],[27,1,33,1],[0,5,0,6],[0,9,1,9],[0,8,1,8],[2,9,7,9],[8,9,13,9],[0,7,1,7]]}
[{"$f":"COUNTIF(A2:A100,\"NG\")","v":0},"Q2-1. 男性年齢等",null,{"$f":"\"令和\"&WAREKI&\"7月末の\n該当人員\"","v":"令和6年7月末の\n該当人員"},null,"7月末の勤続年数の合計",null,"平均\n勤続年数","7月末の\n年齢の合計","平均年齢"]
[null,"職種","年齢区分",null,null,"年数","月数"]
[{"$f":"IF(OR(AND(D3=0,F3+G3+I3>0),AND(D3>0,F3+G3=0),AND(D3>0,I3=0)),\"NG\",\"\")","v":""},"男性\nけん引\n運転者","20～30歳未満",{"$f":"'Q1-1'!D5","v":0},{"$f":"SUM(D3:D8)","v":0},null,null,{"$f":"IF(D3=0,\"\",INT((F3*12+G3)/D3/12)&\"年\"&ROUND(MOD((F3*12+G3)/D3,12),0)&\"月\")","v":""},null,{"$f":"IF(E3>0,SUM(I3:I8)/E3,0)","v":0}]
["",null,"30～40歳未満",{"$f":"'Q1-1'!D6","v":0},null,null,null,{"$f":"IF(D4=0,\"\",INT((F4*12+G4)/D4/12)&\"年\"&ROUND(MOD((F4*12+G4)/D4,12),0)&\"月\")","v":""}]
["",null,"40～50歳未満",{"$f":"'Q1-1'!D7","v":0},null,null,null,""]
["",null,"50～60歳未満",{"$f":"'Q1-1'!D8","v":0},null,null,null,""]
["",null,"60～65歳未満",{"$f":"'Q1-1'!D9","v":0},null,null,null,""]
["",null,"65歳以上",{"$f":"'Q1-1'!D10","v":0},null,null,null,""]
["","男性\n大型\n運転者","20～30歳未満",{"$f":"'Q1-1'!D11","v":0},{"$f":"SUM(D9:D14)","v":0},null,null,"",null,{"$f":"IF(E9>0,SUM(I9:I14)/E9,0)","v":0}]
["",null,"30～40歳未満",{"$f":"'Q1-1'!D12","v":0},null,null,null,""]
["",null,"40～50歳未満",{"$f":"'Q1-1'!D13","v":0},null,null,null,""]
["",null,"50～60歳未満",{"$f":"'Q1-1'!D14","v":0},null,null,null,""]
["",null,"60～65歳未満",{"$f":"'Q1-1'!D15","v":0},null,null,null,""]
["",null,"65歳以上",{"$f":"'Q1-1'!D16","v":0},null,null,null,""]
["","男性\n中型\n運転者","20～30歳未満",{"$f":"'Q1-1'!D17","v":0},{"$f":"SUM(D15:D20)","v":0},null,null,"",null,{"$f":"IF(E15>0,SUM(I15:I20)/E15,0)","v":0}]
["",null,"30～40歳未満",{"$f":"'Q1-1'!D18","v":0},null,null,null,""]
["",null,"40～50歳未満",{"$f":"'Q1-1'!D19","v":0},null,null,null,""]
["",null,"50～60歳未満",{"$f":"'Q1-1'!D20","v":0},null,null,null,""]
["",null,"60～65歳未満",{"$f":"'Q1-1'!D21","v":0},null,null,null,""]
["",null,"65歳以上",{"$f":"'Q1-1'!D22","v":0},null,null,null,""]
["","男性\n準中型\n運転者","20歳未満",{"$f":"'Q1-1'!D23","v":0},{"$f":"SUM(D21:D27)","v":0},null,null,"",null,{"$f":"IF(E21>0,SUM(I21:I27)/E21,0)","v":0}]
["",null,"20～30歳未満",{"$f":"'Q1-1'!D24","v":0},null,null,null,""]
["",null,"30～40歳未満",{"$f":"'Q1-1'!D25","v":0},null,null,null,""]
["",null,"40～50歳未満",{"$f":"'Q1-1'!D26","v":0},null,null,null,""]
["",null,"50～60歳未満",{"$f":"'Q1-1'!D27","v":0},null,null,null,""]
["",null,"60～65歳未満",{"$f":"'Q1-1'!D28","v":0},null,null,null,""]
["",null,"65歳以上",{"$f":"'Q1-1'!D29","v":0},null,null,null,""]
["","男性\n普通\n運転者","20歳未満",{"$f":"'Q1-1'!D30","v":0},{"$f":"SUM(D28:D34)","v":0},null,null,"",null,{"$f":"IF(E28>0,SUM(I28:I34)/E28,0)","v":0}]
["",null,"20～30歳未満",{"$f":"'Q1-1'!D31","v":0},null,null,null,""]
["",null,"30～40歳未満",{"$f":"'Q1-1'!D32","v":0},null,null,null,""]
["",null,"40～50歳未満",{"$f":"'Q1-1'!D33","v":0},null,null,null,""]
["",null,"50～60歳未満",{"$f":"'Q1-1'!D34","v":0},null,null,null,""]
["",null,"60～65歳未満",{"$f":"'Q1-1'!D35","v":0},null,null,null,""]
["",null,"65歳以上",{"$f":"'Q1-1'!D36","v":0},null,null,null,""]
[{"$f":"IF(OR(AND(D35=0,F35+G35+I35>0),AND(D35>0,F35+G35=0),AND(D35>0,I35=0)),\"NG\",\"\")","v":""},"男性\n事務員","20歳未満",{"$f":"'Q1-1'!D37","v":0},{"$f":"SUM(D35:D41)","v":0},null,null,"",null,{"$f":"IF(E35>0,SUM(I35:I41)/E35,0)","v":0}]
["",null,"20～30歳未満",{"$f":"'Q1-1'!D38","v":0},null,null,null,""]
["",null,"30～40歳未満",{"$f":"'Q1-1'!D39","v":0},null,null,null,""]
["",null,"40～50歳未満",{"$f":"'Q1-1'!D40","v":0},null,null,null,""]
["",null,"50～60歳未満",{"$f":"'Q1-1'!D41","v":0},null,null,null,""]
["",null,"60～65歳未満",{"$f":"'Q1-1'!D42","v":0},null,null,null,""]
["",null,"65歳以上",{"$f":"'Q1-1'!D43","v":0},null,null,null,""]
["","男性\n荷扱手","20歳未満",{"$f":"'Q1-1'!D44","v":0},{"$f":"SUM(D42:D48)","v":0},null,null,"",null,{"$f":"IF(E42>0,SUM(I42:I48)/E42,0)","v":0}]
["",null,"20～30歳未満",{"$f":"'Q1-1'!D45","v":0},null,null,null,""]
["",null,"30～40歳未満",{"$f":"'Q1-1'!D46","v":0},null,null,null,""]
["",null,"40～50歳未満",{"$f":"'Q1-1'!D47","v":0},null,null,null,""]
["",null,"50～60歳未満",{"$f":"'Q1-1'!D48","v":0},null,null,null,""]
["",null,"60～65歳未満",{"$f":"'Q1-1'!D49","v":0},null,null,null,""]
["",null,"65歳以上",{"$f":"'Q1-1'!D50","v":0},null,null,null,""]
["","男性\n整備・\n技能員","20歳未満",{"$f":"'Q1-1'!D51","v":0},{"$f":"SUM(D49:D55)","v":0},null,null,"",null,{"$f":"IF(E49>0,SUM(I49:I55)/E49,0)","v":0}]
["",null,"20～30歳未満",{"$f":"'Q1-1'!D52","v":0},null,null,null,""]
["",null,"30～40歳未満",{"$f":"'Q1-1'!D53","v":0},null,null,null,""]
["",null,"40～50歳未満",{"$f":"'Q1-1'!D54","v":0},null,null,null,""]
["",null,"50～60歳未満",{"$f":"'Q1-1'!D55","v":0},null,null,null,""]
["",null,"60～65歳未満",{"$f":"'Q1-1'!D56","v":0},null,null,null,""]
["",null,"65歳以上",{"$f":"'Q1-1'!D57","v":0},null,null,null,{"$f":"IF(D55=0,\"\",INT((F55*12+G55)/D55/12)&\"年\"&ROUND(MOD((F55*12+G55)/D55,12),0)&\"月\")","v":""}]

{"sheet":"Q2-2","index":5,"n_rows":55,"n_cols":10,"rows_kept":55,"cut":false,"hidden":true,"merged":[[0,3,1,4],[0,5,0,6],[0,8,1,8],[0,9,1,9],[2,1,7,1],[2,4,7,4],[2,9,7,9],[0,7,1,7],[8,1,13,1],[8,4,13,4],[8,9,13,9],[14,1,19,1],[14,4,19,4],[14,9,19,9],[20,1,26,1],[20,4,26,4],[20,9,26,9],[27,1,33,1],[27,4,33,4],[27,9,33,9],[48,1,54,1],[48,4,54,4],[48,9,54,9],[34,1,40,1],[34,4,40,4],[34,9,40,9],[41,1,47,1],[41,4,47,4],[41,9,47,9]]}
[{"$f":"COUNTIF(A2:A100,\"NG\")","v":0},"Q2-2. 女性年齢等",null,{"$f":"\"令和\"&WAREKI&\"7月末の\n該当人員\"","v":"令和6年7月末の\n該当人員"},null,"7月末の勤続年数の合計",null,"平均\n勤続年数","7月末の\n年齢の合計","平均年齢"]
[null,"職種","年齢区分",null,null,"年数","月数"]
[{"$f":"IF(OR(AND(D3=0,F3+G3+I3>0),AND(D3>0,F3+G3=0),AND(D3>0,I3=0)),\"NG\",\"\")","v":""},"女性\nけん引\n運転者","20～30歳未満",{"$f":"'Q1-2'!D5","v":0},{"$f":"SUM(D3:D8)","v":0},null,null,{"$f":"IF(D3=0,\"\",INT((F3*12+G3)/D3/12)&\"年\"&ROUND(MOD((F3*12+G3)/D3,12),0)&\"月\")","v":""},null,{"$f":"IF(E3>0,SUM(I3:I8)/E3,0)","v":0}]
["",null,"30～40歳未満",{"$f":"'Q1-2'!D6","v":0},null,null,null,{"$f":"IF(D4=0,\"\",INT((F4*12+G4)/D4/12)&\"年\"&ROUND(MOD((F4*12+G4)/D4,12),0)&\"月\")","v":""}]
["",null,"40～50歳未満",{"$f":"'Q1-2'!D7","v":0},null,null,null,""]
["",null,"50～60歳未満",{"$f":"'Q1-2'!D8","v":0},null,null,null,""]
["",null,"60～65歳未満",{"$f":"'Q1-2'!D9","v":0},null,null,null,""]
["",null,"65歳以上",{"$f":"'Q1-2'!D10","v":0},null,null,null,""]
["","女性\n大型\n運転者","20～30歳未満",{"$f":"'Q1-2'!D11","v":0},{"$f":"SUM(D9:D14)","v":0},null,null,"",null,{"$f":"IF(E9>0,SUM(I9:I14)/E9,0)","v":0}]
["",null,"30～40歳未満",{"$f":"'Q1-2'!D12","v":0},null,null,null,""]
["",null,"40～50歳未満",{"$f":"'Q1-2'!D13","v":0},null,null,null,""]
["",null,"50～60歳未満",{"$f":"'Q1-2'!D14","v":0},null,null,null,""]
["",null,"60～65歳未満",{"$f":"'Q1-2'!D15","v":0},null,null,null,""]
["",null,"65歳以上",{"$f":"'Q1-2'!D16","v":0},null,null,null,""]
["","女性\n中型\n運転者","20～30歳未満",{"$f":"'Q1-2'!D17","v":0},{"$f":"SUM(D15:D20)","v":0},null,null,"",null,{"$f":"IF(E15>0,SUM(I15:I20)/E15,0)","v":0}]
["",null,"30～40歳未満",{"$f":"'Q1-2'!D18","v":0},null,null,null,""]
["",null,"40～50歳未満",{"$f":"'Q1-2'!D19","v":0},null,null,null,""]
["",null,"50～60歳未満",{"$f":"'Q1-2'!D20","v":0},null,null,null,""]
["",null,"60～65歳未満",{"$f":"'Q1-2'!D21","v":0},null,null,null,""]
["",null,"65歳以上",{"$f":"'Q1-2'!D22","v":0},null,null,null,""]
["","女性\n準中型\n運転者","20歳未満",{"$f":"'Q1-2'!D23","v":0},{"$f":"SUM(D21:D27)","v":0},null,null,"",null,{"$f":"IF(E21>0,SUM(I21:I27)/E21,0)","v":0}]
["",null,"20～30歳未満",{"$f":"'Q1-2'!D24","v":0},null,null,null,""]
["",null,"30～40歳未満",{"$f":"'Q1-2'!D25","v":0},null,null,null,""]
["",null,"40～50歳未満",{"$f":"'Q1-2'!D26","v":0},null,null,null,""]
["",null,"50～60歳未満",{"$f":"'Q1-2'!D27","v":0},null,null,null,""]
["",null,"60～65歳未満",{"$f":"'Q1-2'!D28","v":0},null,null,null,""]
["",null,"65歳以上",{"$f":"'Q1-2'!D29","v":0},null,null,null,""]
["","女性\n普通\n運転者","20歳未満",{"$f":"'Q1-2'!D30","v":0},{"$f":"SUM(D28:D34)","v":0},null,null,"",null,{"$f":"IF(E28>0,SUM(I28:I34)/E28,0)","v":0}]
["",null,"20～30歳未満",{"$f":"'Q1-2'!D31","v":0},null,null,null,""]
["",null,"30～40歳未満",{"$f":"'Q1-2'!D32","v":0},null,null,null,""]
["",null,"40～50歳未満",{"$f":"'Q1-2'!D33","v":0},null,null,null,""]
["",null,"50～60歳未満",{"$f":"'Q1-2'!D34","v":0},null,null,null,""]
["",null,"60～65歳未満",{"$f":"'Q1-2'!D35","v":0},null,null,null,""]
["",null,"65歳以上",{"$f":"'Q1-2'!D36","v":0},null,null,null,""]
[{"$f":"IF(OR(AND(D35=0,F35+G35+I35>0),AND(D35>0,F35+G35=0),AND(D35>0,I35=0)),\"NG\",\"\")","v":""},"女性\n事務員","20歳未満",{"$f":"'Q1-2'!D37","v":0},{"$f":"SUM(D35:D41)","v":0},null,null,"",null,{"$f":"IF(E35>0,SUM(I35:I41)/E35,0)","v":0}]
["",null,"20～30歳未満",{"$f":"'Q1-2'!D38","v":0},null,null,null,""]
["",null,"30～40歳未満",{"$f":"'Q1-2'!D39","v":0},null,null,null,""]
["",null,"40～50歳未満",{"$f":"'Q1-2'!D40","v":0},null,null,null,""]
["",null,"50～60歳未満",{"$f":"'Q1-2'!D41","v":0},null,null,null,""]
["",null,"60～65歳未満",{"$f":"'Q1-2'!D42","v":0},null,null,null,""]
["",null,"65歳以上",{"$f":"'Q1-2'!D43","v":0},null,null,null,""]
["","女性\n荷扱手","20歳未満",{"$f":"'Q1-2'!D44","v":0},{"$f":"SUM(D42:D48)","v":0},null,null,"",null,{"$f":"IF(E42>0,SUM(I42:I48)/E42,0)","v":0}]
["",null,"20～30歳未満",{"$f":"'Q1-2'!D45","v":0},null,null,null,""]
["",null,"30～40歳未満",{"$f":"'Q1-2'!D46","v":0},null,null,null,""]
["",null,"40～50歳未満",{"$f":"'Q1-2'!D47","v":0},null,null,null,""]
["",null,"50～60歳未満",{"$f":"'Q1-2'!D48","v":0},null,null,null,""]
["",null,"60～65歳未満",{"$f":"'Q1-2'!D49","v":0},null,null,null,""]
["",null,"65歳以上",{"$f":"'Q1-2'!D50","v":0},null,null,null,""]
["","女性\n整備・\n技能員","20歳未満",{"$f":"'Q1-2'!D51","v":0},{"$f":"SUM(D49:D55)","v":0},null,null,"",null,{"$f":"IF(E49>0,SUM(I49:I55)/E49,0)","v":0}]
["",null,"20～30歳未満",{"$f":"'Q1-2'!D52","v":0},null,null,null,""]
["",null,"30～40歳未満",{"$f":"'Q1-2'!D53","v":0},null,null,null,""]
["",null,"40～50歳未満",{"$f":"'Q1-2'!D54","v":0},null,null,null,""]
["",null,"50～60歳未満",{"$f":"'Q1-2'!D55","v":0},null,null,null,""]
["",null,"60～65歳未満",{"$f":"'Q1-2'!D56","v":0},null,null,null,""]
["",null,"65歳以上",{"$f":"'Q1-2'!D57","v":0},null,null,null,""]

{"sheet":"Q3～Q9","index":6,"n_rows":229,"n_cols":29,"rows_kept":229,"cut":false,"hidden":true,"merged":[[80,3,80,9],[82,3,82,6],[83,3,83,6],[82,1,82,2],[81,1,81,2],[81,3,81,10],[80,1,80,2],[83,1,83,2],[73,1,73,2],[73,3,73,5],[74,1,76,1],[74,3,74,8],[75,3,75,8],[76,3,76,8],[66,1,66,2],[67,1,67,2],[68,1,68,2],[72,1,72,2],[72,3,72,5],[61,1,61,2],[62,1,62,2],[63,1,63,2],[64,1,64,2],[65,1,65,2],[56,1,56,2],[57,1,57,2],[58,1,58,2],[59,1,59,2],[60,1,60,2],[50,7,50,9],[52,1,52,2],[53,1,53,2],[54,1,54,2],[55,1,55,2],[41,1,44,2],[41,3,43,4],[41,5,44,6],[41,7,47,9],[41,10,49,10],[44,3,44,4],[45,1,45,2],[45,3,45,4],[45,5,45,6],[46,1,46,2],[46,3,46,4],[46,5,46,6],[47,1,47,2],[47,5,47,6],[48,7,48,9],[49,7,49,9],[2,1,3,2],[2,3,2,8],[4,1,4,2],[5,1,6,1],[7,1,7,2],[8,1,8,2],[8,3,8,8],[9,1,9,2],[9,3,9,4],[9,5,9,8],[10,1,12,1],[10,3,10,8],[16,1,17,2],[16,3,16,5],[16,6,16,10],[17,3,17,10],[40,1,40,2],[40,3,40,4],[40,5,40,6],[40,7,40,9],[21,1,22,1],[23,1,24,1],[25,1,26,1],[27,1,28,1],[32,1,36,1]]}
[{"$f":"COUNTIF(A2:A99,\"NG\")","v":6},"Q3. 休日の状況、平均1人当りの月間実労働時間と年間実労働時間等"]
[null,null,null,"男性運転者","女性運転者","男性事務員","女性事務員","荷扱手","整備・技能員"]
[{"$f":"IF(D3=\"\",\"NG\",\"\")","v":"NG"},"週休2日制\nの実施状況",null,null,null,null,null,null,null,null,null,{"$f":"IF(D3<>\"\",HLOOKUP(D3,$W$3:$X$5,3,FALSE),\"\")","v":""},"←週休2日制の採否",null,null,null,null,null,null,null,null,null,"一部または全職種で実施している　（↓各職種ごとの実施状況を選択してください）","実施していない"]
[{"$f":"IF(OR(AND(L3=1,OR(D4=\"\",E4=\"\",F4=\"\",G4=\"\",H4=\"\",I4=\"\")),AND(L3<>1,OR(D4<>\"\",E4<>\"\",F4<>\"\",G4<>\"\",H4<>\"\",I4<>\"\"))),\"NG\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D4<>\"\",HLOOKUP(D4,$W$4:$AB$5,2,FALSE),\"\")","v":""},"","","","","",null,null,null,null,null,"完全週休2日制","4週7休(または月3回)","4週6休(または月2回)","4週5休(または月1回)","その他の方法(変形労働時間制を含む)","実施していない"]
[null,"該当人員",null,{"$f":"SUM('Q2-1'!E3:E34)","v":0},{"$f":"SUM('Q2-2'!E3:E34)","v":0},{"$f":"'Q2-1'!E35","v":0},{"$f":"'Q2-2'!E35","v":0},{"$f":"'Q2-1'!E42+'Q2-2'!E42","v":0},{"$f":"'Q2-1'!E49+'Q2-2'!E49","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,0]
[{"$f":"IF(OR(AND(D$5>0,D$6+D$7=0), AND(E$5>0,E$6+E$7=0),AND(F$5>0,F$6+F$7=0),AND(G$5>0,G$6+G$7=0),AND(H$5>0,H$6+H$7=0),AND(I$5>0,I$6+I$7=0)), \"NG\",\"\")","v":""},{"$f":"\"令和\"&WAREKI&\"5～7月の\n1人1ヵ月平均\n労働時間\"","v":"令和6年5～7月の\n1人1ヵ月平均\n労働時間"},"所定内\n労働時間",null,null,null,null,null,null,null,null,{"$f":"VALUE(D6)","v":0},0,0,0,0,0]
[{"$f":"IF(OR(AND(D$5=0,D$6+D$7>0), AND(E$5=0,E$6+E$7>0),AND(F$5=0,F$6+F$7>0),AND(G$5=0,G$6+G$7>0),AND(H$5=0,H$6+H$7>0),AND(I$5=0,I$6+I$7>0)), \"NG\",\"\")","v":""},null,"所定外\n労働時間",null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[{"$f":"IF(OR(AND($D$5>0,D8=0), AND($E$5>0,E8=0),AND($F$5>0,F8=0),AND($G$5>0,G8=0),AND($H$5>0,H8=0),AND($I$5>0,I8=0)), \"NG\",\"\")","v":""},{"$f":"\"令和\"&WAREKI2&\"度の\n年間 実労働時間\"","v":"令和5年度の\n年間 実労働時間"},null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[{"$f":"IF(D9=0,\"NG\",\"\")","v":"NG"},"規定の年間休日 総数",null,null,null,null,null,null,null,null,null,{"$f":"VALUE(D9)","v":0}]
[{"$f":"IF(OR(AND(D5+E5>0,D10=\"\"),AND(F5+G5+H5+I5>0,F10=\"\")),\"NG\",\"\")","v":""},{"$f":"\"令和\"&WAREKI2&\"度の\n有給休暇の平均取得日数\"","v":"令和5年度の\n有給休暇の平均取得日数"},null,null,null,null,null,null,null,null,null,{"$f":"VALUE(D10)","v":0},{"$f":"VALUE(F10)","v":0}]
[{"$f":"IF(D11=\"\",\"NG\",\"\")","v":"NG"},"変形労働\n時間制\nの採用状況",null,null,null,null,null,null,null,null,null,{"$f":"IF(D11<>\"\",HLOOKUP(D11,$W$11:$X$12,2,FALSE),\"\")","v":""},"←変形労働制の採否",null,null,null,null,null,null,null,null,null,"一部または全職種で採用している　（↓各職種ごとのすべての実施状況を選択してください）","採用していない"]
[{"$f":"IF(OR(AND($L$11=1,OR(D12=\"\",E12=\"\",F12=\"\",G12=\"\",H12=\"\",I12=\"\")),AND($L$11<>1,OR(D12<>\"\",E12<>\"\",G12<>\"\",H12<>\"\",I12<>\"\"))),\"NG\",\"\")","v":""},null,"1年単位の\n変形労働\n時間制",null,null,null,null,null,null,null,null,{"$f":"IF(D12<>\"\",HLOOKUP(D12,$W$13:$X$14,2,FALSE),\"\")","v":""},"","","","","",null,null,null,null,null,1,2]
[{"$f":"IF(OR(AND($L$11=1,OR(D13=\"\",E13=\"\",F13=\"\",G13=\"\",H13=\"\",I13=\"\")),AND($L$11<>1,OR(D13<>\"\",E13<>\"\",G13<>\"\",H13<>\"\",I13<>\"\"))),\"NG\",\"\")","v":""},null,"1ヵ月単位の\n変形労働\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,true,false]
[]
[null,"Q4-1. 退職金制度"]
[{"$f":"IF(OR(L17=\"\",AND(L17<>2,G17<>\"\"),AND(L17=2,G17=\"\")),\"NG\",\"\")","v":"NG"},"退職金制度と\nその内容",null,null,null,null,"",null,null,null,null,{"$f":"IF(D17<>\"\",HLOOKUP(D17,$W17:$Y$19,3,FALSE),\"\")","v":""},{"$f":"G17","v":""},null,null,null,null,null,null,null,null,null,"全職種に制度あり","一部の職種に制度あり　　　　右に職種を記入→","制度なし"]
[{"$f":"IF(OR(AND(L17<3,D18=\"\"),AND(L17=3,D18<>\"\")),\"NG\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D18<>\"\",HLOOKUP(D18,$W18:$AA$19,2,FALSE),\"\")","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,1,2,3,4,5]
[null,"Q4-2. 18歳で採用された方が退職する場合、退職金支給規定により支給される退職一時金　 （千円未満は四捨五入）"]
[null,"勤続年数","退職理由","けん引\n運転者","大型\n運転者","中型\n運転者","準中型\n運転者","普通\n運転者","事務員","荷扱手","整備・\n技能員"]
[null,"満10年勤続","自己都合"]
[null,null,"会社都合"]
[null,"満20年勤続","自己都合"]
[null,null,"会社都合"]
[null,"満30年勤続","自己都合"]
[null,null,"会社都合"]
[null,"満40年勤続","自己都合"]
[null,null,"会社都合"]
[]
[]
[null,"Q5. 新卒者の初任給　（千円未満は四捨五入）"]
[null,{"$f":"\"令和\"&WAREKI&\"3月卒業の\n新卒者の\n初任給\n（固定給のみ）\"","v":"令和6年3月卒業の\n新卒者の\n初任給\n（固定給のみ）"},"学歴","運転者","事務員","荷扱手","整備・技能員"]
[null,null,"大学"]
[null,null,"短大"]
[null,null,"専門学校"]
[null,null,"高校"]
[]
[]
[null,"Q6. 福利厚生制度　（採用しているものすべてにチェックを入れて下さい）"]
[null,"住宅制度",null,"給食制度",null,"子育て支援制度",null,"その他"]
[null,false,null,false,null,false,null,false,null,null,null,{"$f":"B42","v":false},{"$f":"B43","v":false},{"$f":"B44","v":false},{"$f":"B45","v":false},{"$f":"B46","v":""},{"$f":"B47","v":false},"←住宅制度"]
[null,false,null,false,null,false,null,false,null,null,null,{"$f":"D42","v":false},{"$f":"D43","v":false},{"$f":"D44","v":false},{"$f":"D45","v":""},{"$f":"D46","v":false},"←給食制度"]
[null,false,null,false,null,false,null,false,null,null,null,{"$f":"F42","v":false},{"$f":"F43","v":false},{"$f":"F44","v":false},{"$f":"F45","v":false},{"$f":"F46","v":""},{"$f":"F47","v":false},"←子育て支援"]
[null,false,null,"",null,false,null,false,null,null,null,{"$f":"H42","v":false},{"$f":"H43","v":false},{"$f":"H44","v":false},{"$f":"H45","v":false},{"$f":"H46","v":false},{"$f":"H47","v":false},{"$f":"H48","v":false},{"$f":"H49","v":""},{"$f":"H50","v":false},"←その他"]
[null,"",null,false,null,"",null,false]
[null,false,null,null,null,false,null,false]
[null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,false]
[]
[null,"Q7. 離職、採用状況"]
[null,"令和5年4月～令和6年3月末の\n採用・離職者",null,"期間内\n採用者","期間内\n離職者","期間内採用者\nのうち\n新卒者"]
[{"$f":"IF(F54>D54,\"NG\",\"\")","v":""},"男性けん引運転者"]
["","男性大型運転者"]
["","男性中型運転者"]
["","男性準中型運転者"]
["","男性普通運転者"]
["","男性事務員"]
["","男性荷扱手"]
["","男性整備・技能員"]
["","女性けん引運転者"]
["","女性大型運転者"]
["","女性中型運転者"]
["","女性準中型運転者"]
["","女性普通運転者"]
["","女性事務員"]
["","女性荷扱手"]
["","女性整備・技能員"]
[]
[]
[null,"Q8. 運転者の定年制等"]
[{"$f":"IF(D73=\"\",\"NG\",\"\")","v":"NG"}," 運転者の定年制",null,null,null,null,null,null,null,null,null,{"$f":"IF(D73=\"\",\"\",HLOOKUP(D73,W73:X$78,6,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,"定めている","定めていない"]
[{"$f":"IF(OR(AND($L$73=2,L74<>\"\"),AND($L$73=1,L74=\"\")),\"NG\",\"\")","v":""},"運転者の定年年齢",null,null,null,null,null,null,null,null,null,{"$f":"IF(D74<>\"\",HLOOKUP(D74,W74:AC$78,5,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"60歳","61歳","62歳","63歳","64歳","65歳","66歳以上"]
[{"$f":"IF(OR(AND($L$73=2,L75<>\"\"),AND($L$73=1,$L$74<6,L75=\"\")),\"NG\",\"\")","v":""},"定年到達者を\n勤務延長・\n再雇用\nした場合","勤務形態",null,null,null,null,null,null,null,null,{"$f":"IF(D75<>\"\",HLOOKUP(D75,W75:Z$78,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"定年到達時と同じ勤務形態","定年到達時より1日の勤務時間が短い","定年到達時より1週の勤務日数が少ない","定年到達時より1日の勤務時間も1週の勤務日数も少ない"]
[{"$f":"IF(OR(AND($L$73=2,L76<>\"\"),AND($L$73=1,$L$74<6,L76=\"\")),\"NG\",\"\")","v":""},null,"賃金",null,null,null,null,null,null,null,null,{"$f":"IF(D76<>\"\",HLOOKUP(D76,W76:Y$78,3,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"定年到達時の80%未満","定年到達時の80%以上100%未満","定年到達時と同じ"]
[{"$f":"IF(OR(AND($L$73=2,L77<>\"\"),AND($L$73=1,$L$74<6,L77=\"\")),\"NG\",\"\")","v":""},null,"仕事内容",null,null,null,null,null,null,null,null,{"$f":"IF(D77<>\"\",HLOOKUP(D77,W77:Y$78,2,FALSE),\"\")","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,1,2,3,4,5,6,7]
[]
[null,"Q9. 運転者の賃上げについて"]
[{"$f":"IF(D81=\"\",\"NG\",\"\")","v":"NG"},"昨年度の運転者の賃上げ",null,null,null,null,null,null,null,null,null,{"$f":"IF(D81=\"\",\"\",HLOOKUP(D81,W81:AB$85,5,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,"実施した　　（↓ 昨年度の「賃上げの内容」欄であてはまるものすべてにチェックし、「賃上げ率」を選択してください）","実施していない　　（↓ 「今年度の賃上げ」についての予定を選択してください）"]
[{"$f":"IF(AND($L$81=1,L82=FALSE,M82=FALSE,N82=FALSE,O82=FALSE,P82=FALSE),\"NG\", IF(AND($L$81<>1,OR(L82=TRUE,M82=TRUE,N82=TRUE,O82=TRUE,P82=TRUE)), \"NG\"))","v":false},"賃上げの内容",null,null,null,null,null,null,null,null,null,false,false,false,false,false]
[{"$f":"IF(OR(AND($L$81=1,L83=\"\"),AND($L$81<>1,L83<>\"\")),\"NG\",\"\")","v":""},"賃上げ率",null,null,null,null,null,null,null,null,null,{"$f":"IF(D83=\"\",\"\",HLOOKUP(D83,W83:AB$85,3,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,"年収ベースで 2%未満","年収ベースで 2%以上～3%未満","年収ベースで 3%以上～4%未満","年収ベースで 4%以上～5%未満","年収ベースで 5%以上～10%未満","年収ベースで 10%以上"]
[{"$f":"IF(OR(AND($L$81=1,L84<>\"\"),AND($L$81=2,L84=\"\")),\"NG\",\"\")","v":""},"今年度の賃上げ",null,null,null,null,null,null,null,null,null,{"$f":"IF(D84<>\"\",HLOOKUP(D84,$W84:Z$85,2,FALSE),\"\")","v":""},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,null,null,1,2,3,4,5,6]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,true]
[]
[]
[]
[]
[]
[null,null,false,null,null,null,true]
[null,null,null,null,null,null,false]

{"sheet":"Q会社情報","index":7,"n_rows":44,"n_cols":56,"rows_kept":44,"cut":false,"hidden":true,"merged":[[1,2,1,4],[2,2,2,5],[6,2,6,4],[8,2,8,4],[9,2,9,4],[7,2,7,7],[21,2,21,6],[6,1,7,1],[10,2,10,4],[11,2,11,4],[3,2,3,5],[4,2,4,5],[12,1,12,7],[17,2,17,6]]}
[{"$f":"COUNTIF(A3:A22,\"NG\")","v":6},"会社情報のご入力",null,null,"（令和6年度版）",null,{"$f":"MID($E$1,4,2)","v":"6年"},{"$f":"MID($E$1,4,1)-1&\"年\"","v":"5年"}]
[null,"区分","",null,null," 　※不明の場合は空欄でかまいません。",null,null,null,"特積","一般"]
[{"$f":"IF(C3=\"\",\"NG\",\"\")","v":"NG"},"貴社名","",null,null,null,null,null,null,1,2]
[null,"入力担当者所属",""]
[null,"入力担当者氏名",""]
[{"$f":"IF(OR(C6=\"\",E6=\"\"),\"NG\",\"\")","v":"NG"},"郵便番号","","－",""]
[{"$f":"IF(C7=\"\",\"NG\",\"\")","v":"NG"},"住所","",null,null,{"$f":"IF(C7<>\"\",HLOOKUP(C7,J7:BD8,2,FALSE),\"\")","v":""},null,null,null,"北海道","青森県","岩手県","宮城県","秋田県","山形県","福島県","茨城県","栃木県","群馬県","埼玉県","千葉県","東京都","神奈川県","新潟県","富山県","石川県","福井県","山梨県","長野県","岐阜県","静岡県","愛知県","三重県","滋賀県","京都府","大阪府","兵庫県","奈良県","和歌山県","鳥取県","島根県","岡山県","広島県","山口県","徳島県","香川県","愛媛県","高知県","福岡県","佐賀県","長崎県","熊本県","大分県","宮崎県","鹿児島県","沖縄県"]
[{"$f":"IF(C8=\"\",\"NG\",\"\")","v":"NG"},null,null,null,null,null,null,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,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47]
[null,"電話",""]
[null,"FAX",""]
[{"$f":"IF(C11=\"\",\"NG\",\"\")","v":"NG"},{"$f":"\"令和\"&WAREKI&\"7月末の\n総従業員数\"","v":"令和6年7月末の\n総従業員数"}]
[{"$f":"IF(C12=\"\",\"NG\",\"\")","v":"NG"},"保有車両数",null,null,null,null,"協会記入欄"]
[null,"※本調査に関する個人情報は、入力された内容の確認及び報告書の発送に使用させていただきます。\nその他の用途に使用することはありません。"]
[]
[]
[null,null,"すべて入力いただけましたら、下のボタンをクリックして送信用データを作成してください。"]
[null,null,"記入漏れや間違いがある場合はエラーが表示されデータの作成ができません。"]
[]
[null,null,"作成していただいたファイルは　chosa@nikka-net.or.jp 宛のメールに添付して送信をお願い致します。"]
[null,null,"なお、調査票データのご提出は、令和6年11月30日（土）まで となっております。"]
[null,null,"メール送信画面を表示するには下のリンクをクリックしてください。"]
[null,null,"chosa@nikka-net.or.jp"]
[]
[]
[null,"本調査は、トラック運送業界の現状を正確に把握するための調査であり、個々の情報を行政当局等外部に情報提供することは一切ありません。"]
[null,"この業務は日本貨物運送協同組合連合会に委託して実施しております。"]
[]
[null,"本調査による報告書が完成しましたら貴社宛にお送り致します。"]
[null,"ご協力ありがとうございました。"]
[null,"　　　　公益社団法人　全日本トラック協会"]
[null,"　　　　日本貨物運送協同組合連合会"]
[]
[]
[null,"この調査についてのお問い合わせ先"]
[null,"　・調査の趣旨について：　　公益社団法人　全日本トラック協会　企画部（電話 03-3354-1037）　　　"]
[null,"　・調査の内容、この入力ツールの操作方法等について：　　日本貨物運送協同組合連合会　総務部（電話 03-3355-2031）"]
[null,"　＜受付時間：　平日（月～金）　9:00～17:00＞"]
[]
[]
[]
[]
[]
[null,null,null,""]
[null,""]