{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["はじめに","Q1-1","Q1-2","Q2-1","Q2-2","Q3～Q10","Q会社情報"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":7,"comments":6,"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":96,"n_cols":5,"rows_kept":96,"cut":false,"hidden":false,"merged":[[95,1,95,5],[2,1,2,5],[3,1,3,5],[7,4,8,5],[29,1,29,5],[42,1,42,5]]}
[null,"はじめに"]
[]
[null,"調査票を簡単に入力していただけるよう、このExcelファイルにはマクロが組み込まれております。\nExcelのマクロが実行可能でないと調査票は表示されないようになっております。"]
[null,"入力シートが表示されていない場合は、以下のように設定を行ってください。\n表示されているスクリーンショットは Excel 2019 のものですが、他のバージョン（Excel 2007～2021、Office 365、JUST Calc）でもほぼ同様です。（お使いのOSおよびExcelのバージョンにより、表示されるウィンドウ・メッセージ等が少々異なります）"]
[]
[null,"Excelの設定変更　※この手順は1度行うだけで完了します"]
[null,"≪Office 2010～2021の場合≫",null,null,"≪Office 2007の場合≫"]
[null,"①Excelを起動し、[ファイル]タブをクリックします",null,null,"①Excelを起動し、[Officeボタン]→[Excel のオプション]の順にクリックします　 ※そのまま③へ進みます"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"②[オプション]をクリックします"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"③[Excelのオプション]ウィンドウが表示されますので、[セキュリティ センター]→[セキュリティ センターの設定]の\n　 順にクリックします"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"④[セキュリティ センター]ウィンドウが表示されますので、[マクロの設定]をクリックし、\n　 [警告を表示してすべてのマクロを無効にする]にチェックを入れ、[OK]をクリックします"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"⑤[Excelのオプション]ウィンドウに戻りますので、[OK]をクリックし、Excelを終了します"]
[]
[null,"Excelファイルを開くとき①（編集許可）"]
[null,"下図のような警告メッセージが表示される場合、[編集を有効にする]をクリックします"]
[null,"※インターネットや電子メールからダウンロード直後に当Excelファイルを開くと、表示される可能性があります"]
[]
[]
[]
[]
[null,"Excelファイルを開くとき②（マクロ実行の許可）"]
[null,"下図のような警告メッセージが表示される場合、[コンテンツの有効化]をクリックします"]
[]
[]
[null,"下図のような警告ウィンドウが表示される場合、[マクロを有効にする]をクリックします"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Excelファイルを開くとき③（信頼済みドキュメントの有効化）"]
[null,"下図のような警告ウィンドウが表示される場合、[はい]をクリックします"]
[null,"※ネットワークドライブ上に保存された当Excelファイルを初めて開くと、表示される可能性があります"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"上記の設定を行っても6つの入力シートが自動的に表示されない場合は、下のボタンをクリックしてください\n　"]

{"sheet":"Q1-1","index":1,"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,"令和3年\n7月末の\n該当人員","令和3年5～7月の 1人1ヵ月当たり平均賃金　（※千円未満は四捨五入）",null,null,null,null,null,"1人1ヵ月の\n固定給\n+\n変動給","1人当たり平均\n年間賞与\n(令和2年冬期\n+ 3年夏期)"]
[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":2,"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,"令和3年\n7月末の\n該当人員","令和3年5～7月の 1人1ヵ月当たり平均賃金　（※千円未満は四捨五入）",null,null,null,null,null,"1人1ヵ月の\n固定給\n+\n変動給","1人当たり平均\n年間賞与\n(令和2年冬期\n+ 3年夏期)"]
[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":3,"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,"令和3年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":4,"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,"令和3年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～Q10","index":5,"n_rows":233,"n_cols":29,"rows_kept":233,"cut":false,"hidden":true,"merged":[[87,1,88,2],[87,3,88,8],[73,1,73,2],[73,3,73,5],[81,1,82,2],[81,3,81,8],[82,4,82,7],[74,1,76,1],[74,3,74,8],[75,3,75,8],[76,3,76,8],[80,1,80,2],[80,3,80,5],[86,1,86,2],[86,3,86,5],[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,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],[40,1,40,2],[40,3,40,4],[40,5,40,6],[40,7,40,9],[41,1,44,2],[41,3,43,4],[41,5,44,6],[41,7,47,9],[21,1,22,1],[23,1,24,1],[25,1,26,1],[27,1,28,1],[32,1,36,1],[2,1,3,2],[2,3,2,8],[4,1,4,2],[5,1,6,1],[7,1,7,2],[10,1,12,1],[10,3,10,8],[16,1,17,2],[16,3,16,5],[8,1,8,2],[8,3,8,8],[9,1,9,2],[9,3,9,4],[9,5,9,8],[16,6,16,10],[17,3,17,10]]}
[{"$f":"COUNTIF(A2:A103,\"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<>\"\",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":""},"令和3年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":""},"令和2年度の\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":""},"令和2年度の\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,"令和3年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,"令和2年4月～令和3年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,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,L76=\"\")),\"NG\",\"\")","v":""},null,"賃金",null,null,null,null,null,null,null,null,{"$f":"IF(D76<>\"\",HLOOKUP(D76,W76:Z$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,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:X82,2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,"減少していない","減少した"]
[{"$f":"IF(OR(AND(OR(L82,M82,N82,O82,P82),L81<>2),AND(NOT(OR(L82,M82,N82,O82,P82)),L81=2)),\"NG\",\"\")","v":""},"減少した賃金\n(該当するものすべてにチェックを入れてください)",null,false,false,false,false,false,null,null,null,{"$f":"D82","v":false},{"$f":"E82","v":false},{"$f":"F82","v":false},{"$f":"G82","v":false},{"$f":"H82","v":false},{"$f":"E83","v":""},null,null,null,null,null,1,2]
[null,null,null,"（","",null,null,null,"）"]
[]
[]
[null,"Q10. 調査報告書（冊子）のご活用について （前回まで本調査にご協力いただいている方へ）"]
[null,"前回までお送りした調査報告書",null,null,null,null,null,null,null,null,null,{"$f":"IF(D87=\"\",\"\",HLOOKUP(D87,W87:X88,2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,"活用している","活用していない"]
[{"$f":"IF(OR(AND(OR(L88,M88,N88,O88),L87<>1),AND(NOT(OR(L88,M88,N88,O88)),L87=1)),\"NG\",\"\")","v":""},"調査報告書で活用しているデータ\n(該当するものすべてにチェックを入れてください)",null,false,false,false,false,null,null,null,null,{"$f":"D88","v":false},{"$f":"E88","v":false},false,false,null,null,null,null,null,null,null,1,2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,true]
[]
[]
[]
[]
[]
[null,null,false,null,null,null,true]
[null,null,null,null,null,null,false]

{"sheet":"Q会社情報","index":6,"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,null," 　※不明の場合は空欄でかまいません。",null,null,null,"特積","一般"]
[{"$f":"IF(C3=\"\",\"NG\",\"\")","v":"NG"},"貴社名",null,null,null,null,null,null,null,1,2]
[null,"入力担当者所属",""]
[null,"入力担当者氏名",""]
[{"$f":"IF(OR(C6=\"\",E6=\"\"),\"NG\",\"\")","v":"NG"},"郵便番号",null,"－"]
[{"$f":"IF(C7=\"\",\"NG\",\"\")","v":"NG"},"住所",null,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"},"令和3年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,"なお、調査票データのご提出は、令和3年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,""]