{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["メニュー画面","CSVファイル項目定義","勤務帳票出力イメージ","出力項目","帳票様式"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"メニュー画面","index":0,"n_rows":75,"n_cols":26,"rows_kept":75,"cut":false,"hidden":false,"merged":[[6,0,9,25],[10,0,11,25]]}
[]
[]
[]
[]
[]
[]
["HRstation派遣元勤怠支援ツール Rev.2.1"]
[]
[]
[]
["HRstation派遣元勤怠支援ツールは、勤務帳票ファイル（エクセル）およびCSVファイルを生成するツールです。\n以下の手順に従ってご利用ください。"]
[]
[null,"利用上の注意"]
[null,"・HRstationシステムよりダウンロードしたTSVファイルは、編集せず本ツールに取り込みを行ってください。"]
[null,"・JOBコード、契約先コードが数字のみで15桁を超えるコードの場合、出力されたCSVファイルを"]
[null,"　Excelで開くと数値が異なります。Notepad、Wordpadにてご確認ください。"]
[null,"・出力中は、実行中の端末で他の処理が出来ない場合がございます。"]
[]
["1.","HRstationシステム「勤怠・経費CSV取出」よりTSVファイルをダウンロードしてください。"]
[null,"ダウンロード方法は、HRstation派遣元担当者マニュアルにてご確認ください。"]
[]
["2.","TSVファイルの読み込みを行います。以下の「HRstationファイルを選択」を押下してください。"]
[null,"1でダウンロードしたTSVファイルを選択して読み込みます。"]
[null,"ファイルの生成先は読み込んだTSVファイルがある場所に自動的に生成されます。"]
[null,"あらかじめフォルダを作成し、TSVファイルを格納してから本ツールをご利用ください。"]
[]
[]
[]
[]
[null,"※HRstationファイルを選択をクリックしても反応しない場合は、マクロが有効になっていない可能性があります。"]
[null,null,"マクロの設定につきましては、エクセル2007をご利用の方または、エクセル2010をご利用の方シートを"]
[null,null,"ご確認のうえ、マクロを有効に設定してご利用ください。"]
[]
["3.","以下のダイアログボックスが表示されますので、\"OKボタン\"をクリックしてください。"]
[]
[]
[]
[]
["4.","処理中は、ウィンドウ左下に以下のような進捗メッセージが表示されます。"]
[]
[]
[]
[]
[]
[]
["5.","処理が終了すると、以下のダイアログボックスが表示されますので、OKボタンをクリックしてください。"]
[]
[]
[]
[]
["6.","yyyy-mm勤務_yymmddhhmmss.csv、yyyy-mm勤務帳票_yymmddhhmmss.xls　2つのファイルが生成されます。"]
[]
["7.","生成されたyyyy-mm勤務_yymmddhhmmss.csvは、基幹システムへ取り込む際にご活用ください。"]
[null,"出力されるCSVの項目は、別シート\"CSVファイル項目定義\"に基づき生成されます。"]
[]
["8.","yyyy-mm勤務帳票_yymmddhhmmss.xlsは、勤務明細表の一括印刷が可能です。"]
[null,"以下は、出力される勤務明細表イメージです。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["9.","HRstation派遣元勤怠支援ツールのシステム要件"]
[null,"本ツールは、以下環境で動作確認済みです。"]
[null,"OS：Microsoft Windows 10"]
[null,"Excel：Microsoft Office Excel 2016"]
[null,"空きメモリ：20MB以上"]
[null,"空きディスク容量：10MB以上"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Copyright ©\"&YEAR(TODAY())&\" HRstation.net. All rights reserved.\"","v":"Copyright ©2025 HRstation.net. All rights reserved."}]

{"sheet":"CSVファイル項目定義","index":1,"n_rows":53,"n_cols":26,"rows_kept":53,"cut":false,"hidden":false,"merged":[[26,2,26,5],[26,6,26,21],[26,22,26,23],[27,2,27,5],[27,6,27,21],[27,22,27,23],[24,2,24,5],[24,6,24,21],[24,22,24,23],[25,2,25,5],[25,6,25,21],[25,22,25,23],[0,0,2,25],[20,0,22,25],[23,2,23,5],[23,6,23,21],[23,22,23,23],[28,6,28,21],[28,22,28,23],[29,2,29,5],[29,6,29,21],[29,22,29,23],[28,2,28,5],[30,2,30,5],[30,6,30,21],[30,22,30,23],[31,2,31,5],[31,6,31,21],[31,22,31,23],[32,2,32,5],[32,6,32,21],[32,22,32,23],[33,2,33,5],[33,6,33,21],[33,22,33,23],[34,2,34,5],[34,6,34,21],[34,22,34,23],[35,2,35,5],[35,6,35,21],[35,22,35,23],[36,2,36,5],[36,6,36,21],[36,22,36,23],[37,2,37,5],[37,6,37,21],[37,22,37,23],[38,2,38,5],[38,6,38,21],[38,22,38,23],[39,2,39,5],[39,6,39,21],[39,22,39,23],[40,2,40,5],[40,6,40,21],[40,22,40,23],[41,2,41,5],[41,6,41,21],[41,22,41,23],[42,2,42,5],[42,6,42,21],[42,22,42,23],[43,2,43,5],[43,6,43,21],[43,22,43,23],[44,2,44,5],[44,6,44,21],[44,22,44,23],[48,2,48,5],[48,6,48,21],[48,22,48,23],[46,2,46,5],[46,6,46,21],[46,22,46,23],[47,2,47,5],[47,6,47,21],[47,22,47,23],[45,2,45,5],[45,6,45,21],[45,22,45,23]]}
["CSVファイル出力イメージ"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["CSVファイル項目定義"]
[]
[]
[null,"列","データ項目名",null,null,null,"備考",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TSV項目№"]
[null,"A","契約No.",null,null,null,"形式：契約No. + 契約No.枝番号",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,"B","契約開始日",null,null,null,"形式：YYYY/MM/DD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,"C","契約終了日",null,null,null,"形式：YYYY/MM/DD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,"D","スタッフコード",null,null,null,"企業コード（5桁）除いたコード",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,"E","スタッフ氏名",null,null,null,"形式：姓 + 半角スペース + 名",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,"F","クライアントコード",null,null,null,"派遣先会社コード",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,"G","就業先企業名",null,null,null,"派遣先会社名（日本語）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,"H","Jobコード",null,null,null,"派遣元Jobコード",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,"I","契約先コード",null,null,null,"派遣元契約先コード",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,"J","就業年月日",null,null,null,"形式：YYYY/MM/DD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32]
[null,"K","区分",null,null,null,"勤務区分（1:通常、2:休出、4:年休、5:欠勤、6:振休、7:代休、8:休日）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33]
[null,"L","勤務開始時刻",null,null,null,"形式：HH:MM（HH部分が0～9の場合はゼロの前埋めなし）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34]
[null,"M","勤務終了時刻",null,null,null,"形式：HH:MM（HH部分が0～9の場合はゼロの前埋めなし）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35]
[null,"N","休憩時間",null,null,null,"形式：HH:MM（HH部分が0～9の場合はゼロの前埋めなし）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36]
[null,"O","深夜休憩時間",null,null,null,"形式：HH:MM（HH部分が0～9の場合はゼロの前埋めなし）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37]
[null,"P","実労働時間",null,null,null,"形式：HH:MM（HH部分が0～9の場合はゼロの前埋めなし）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40]
[null,"Q","契約内",null,null,null,"形式：HH:MM（HH部分が0～9の場合はゼロの前埋めなし）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41]
[null,"R","法定内契約外",null,null,null,"形式：HH:MM（HH部分が0～9の場合はゼロの前埋めなし）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42]
[null,"S","法定外契約外",null,null,null,"形式：HH:MM（HH部分が0～9の場合はゼロの前埋めなし）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43]
[null,"T","深夜勤務",null,null,null,"形式：HH:MM（HH部分が0～9の場合はゼロの前埋めなし）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44]
[null,"U","休日労働",null,null,null,"形式：HH:MM（HH部分が0～9の場合はゼロの前埋めなし）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45]
[null,"V","法定休日労働",null,null,null,"形式：HH:MM（HH部分が0～9の場合はゼロの前埋めなし）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46]
[null,"W","年休時間",null,null,null,"形式：HH:MM（HH部分が0～9の場合はゼロの前埋めなし）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47]
[null,"X","交通費",null,null,null,"形式：\\ + 金額",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38]
[null,"Y","立替金",null,null,null,"形式：\\ + 金額",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39]
[null,"※各時間数の算出方法は、派遣元利用ユーザマニュアル、「参考資料」勤怠一括ダウンロード_TSVファイルフォーマット項目定義にてご確認ください。"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Copyright ©\"&YEAR(TODAY())&\" HRstation.net. All rights reserved.\"","v":"Copyright ©2025 HRstation.net. All rights reserved."}]

{"sheet":"勤務帳票出力イメージ","index":2,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,13]]}
["勤務帳票出力イメージ"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Copyright ©\"&YEAR(TODAY())&\" HRstation.net. All rights reserved.\"","v":"Copyright ©2025 HRstation.net. All rights reserved."}]

{"sheet":"出力項目","index":3,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
[null,"項番","項目"]
[null,"1","契約No."]
[null,"2","契約開始日"]
[null,"3","契約終了日"]
[null,"4","スタッフコード"]
[null,"5","スタッフ氏名"]
[null,"6","クライアントコード"]
[null,"7","就業先企業名"]
[null,"8","Jobコード"]
[null,"9","契約先コード"]
[null,"10","就業年月日"]
[null,"11","区分"]
[null,"12","勤務開始時刻"]
[null,"13","勤務終了時刻"]
[null,"14","休憩時間"]
[null,"15","深夜休憩時間"]
[null,"16","実労働時間"]
[null,"17","契約内"]
[null,"18","法定内契約外"]
[null,"19","法定外契約外"]
[null,"20","深夜勤務"]
[null,"21","休日労働"]
[null,"22","法定休日労働"]
[null,"23","年休時間"]
[null,"24","交通費"]
[null,"25","立替金"]

{"sheet":"帳票様式","index":4,"n_rows":33,"n_cols":23,"rows_kept":33,"cut":false,"hidden":true,"merged":[[22,21,22,23],[11,19,22,19],[32,0,32,6],[1,19,10,19],[1,21,1,23],[3,21,3,23],[4,21,4,23],[5,21,5,23],[6,21,6,23],[7,21,7,23],[8,21,8,23],[17,21,17,23],[18,21,18,23],[20,21,20,23],[19,21,19,23],[21,21,21,23],[11,21,11,23],[12,21,12,23],[13,21,13,23],[14,21,14,23],[15,21,15,23],[16,21,16,23]]}
["月/日","曜日","勤務\r\n区分","開始\r\n時刻","終了\r\n時刻","休憩\r\n時間","深夜\r\n休憩","実労働\r\n時間","契約内\r\n時間","法定内\r\n契約外\r\n時間","法定外\r\n契約外\r\n時間","深夜\r\n勤務","休日\r\n出勤","法定\n休日\n出勤","年休\r\n時間","交通費","立替金","備考",null,null,"gz001"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"契約情報","契約№"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"契約期間",null,"～"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"スタッフコード"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"スタッフ氏名"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"派遣先コード"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"派遣先会社名"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"勤務曜日"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"休憩時間1",null,"から"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"月間勤怠情報","勤怠開始日",{"$f":"A2","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"勤怠終了日"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JOBコード"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"契約先コード"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"総出勤日数",{"$f":"COUNTIF(C2:C32,\"通常\")+COUNTIF(C2:C32,\"休出\")+COUNTIF(C2:C32,\"法定休出\")+COUNTIF(C2:C32,\"在宅(通常)\")+COUNTIF(C2:C32,\"在宅(休出)\")+COUNTIF(C2:C32,\"在宅(法出)\")+(COUNTIF(C2:C32,\"半休\")/2)+(COUNTIF(C2:C32,\"在宅(半休)\")/2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"欠勤日数",{"$f":"COUNTIF(C2:C32,\"欠勤\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"年休日数",{"$f":"COUNTIF(C2:C32,\"年休\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"休出日数",{"$f":"COUNTIF(C2:C32,\"休出\")+COUNTIF(C2:C32,\"在宅(休出)\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"法定休出日数",{"$f":"COUNTIF(C2:C32,\"法定休出\")+COUNTIF(C2:C32,\"在宅(法出)\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"振休日数",{"$f":"COUNTIF(C2:C32,\"振休\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"代休日数",{"$f":"COUNTIF(C2:C32,\"代休\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"半休日数",{"$f":"(COUNTIF(C2:C32,\"半休\")+COUNTIF(C2:C32,\"在宅(半休)\"))/2","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["合計",null,null,null,null,null,null,{"$f":"SUM(H2:H32)","v":0},0,0,0,0,0,{"$f":"SUM(N2:N32)","v":0},0,0,0]