{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["設定","作業報告書","readme"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":91,"n_cols":9,"rows_kept":91,"cut":false,"hidden":false,"merged":[]}
["月次作業報告書自動作成"]
[]
[null,null,"◆選択して下さい（青枠）"]
[null,"作業年月","2022",6,"◆選択",{"$f":"C4&\"年\"&D4&\"月\"","v":"2022年6月"},null,{"$f":"DATEVALUE(F4)","v":44713}]
[null,null,"年度","月度"]
[null,"開始",{"$f":"H4","v":"2022-06-01"}]
[]
[null,"終了",{"$f":"H4+H8-1","v":"2022-06-30"},null,"月日数",{"$f":"\"1～\"&DAY(EOMONTH(H4,0))&\"日\"","v":"1～30日"},null,{"$f":"DAY(EOMONTH(H4,0))","v":30}]
[]
[null,null,"◆設定値（緑枠）"]
[null,"所属","AAAA株式会社XXXX部",null,null,"※入力必須　手入力　(自社側情報)"]
[]
[null,"業務先","BBBB株式会社ｘｘｘ部",null,null,"※入力必須　手入力　(顧客情報）"]
[]
[null,"氏名","山田太郎",null,null,"※入力必須　手入力　（担当者)"]
[]
[null,"作業内容","運用・保守対応",null,null,"※入力必須（稼動日計算に一時的に利用するので空白は不可）"]
[]
[null,"始業時間","08:45:00","※入力必須","土曜日",null,"既定の色"]
[null,"終業時間","17:15:00","※入力必須","日曜日",null,"既定の色"]
[null,"休憩時間","01:00:00","※入力必須","祝祭日･ﾕｰｻﾞｰ",null,"既定の色"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"設定等に変更があれば、終了時に保存の問い合わせが出ます。"]
[]
["設定領域（30行）"]
[null,null,"◆年度・月度・休日設定（紫枠）"]
[null,null,"年度設定","月度設定","休日設定*","休日"]
[null,1,"2017",1,"2022-01-01","元日","祝日等は、年によって変わることがあるので"]
[null,2,"2018",2,"2022-01-10","成人の日","年初に再設定する必要があります。"]
[null,3,"2019",3,"2022-02-11","建国記念の日","特に振り替え休日は、毎年変わるので、再設定は"]
[null,4,"2020",4,"2022-02-23","天皇誕生日","必須になります。"]
[null,5,"2021",5,"2022-03-21","春分の日"]
[null,6,"2022",6,"2022-04-29","昭和の日"]
[null,7,"2023",7,"2022-05-03","憲法記念日","■年度の一括置換■"]
[null,8,"2024",8,"2022-05-04","みどりの日","（設定した年度に休日設定の年度を自動変更します）"]
[null,9,"2025",9,"2022-05-05","こどもの日"]
[null,10,"2026",10,"2022-07-15","海の日","設定年度","2022","　　年（選択して置換ボタンを押す）"]
[null,11,"2027",11,"2022-08-11","山の日"]
[null,12,"2028",12,"2022-09-19","敬老の日"]
[null,13,"2029",null,"2022-09-23","秋分の日"]
[null,14,"2030",null,"2022-10-10","スポーツの日"]
[null,15,"2031",null,"2022-11-03","文化の日","現状年度","2022年度"]
[null,16,"2032",null,"2022-11-23","勤労感謝の日"]
[null,17,"2033",null,null,null,"※機械的な年度の置換のみなので、最終的な手動調整は必ず必要です"]
[null,18,"2034"]
[null,19,"2035",null,null,null,"更新手順としては"]
[null,20,"2036",null,null,null,"1）年度の置換をする（年度を選択してから、置換ボタンを押す）"]
[null,21,"2037",null,null,null,"2）個々の休日の日付を確認（総理府情報等を参考）"]
[null,22,"2038",null,null,null,"3）新たな休日の追加、廃止、移動等があれば反映させる"]
[null,23,"2039",null,null,null,"（休日欄中の情報は自由に追加削除等出来ます）"]
[null,24,"2040",null,null,null,"総理府の休日情報"]
[null,25,null,null,null,null,"https://www8.cao.go.jp/chosei/shukujitsu/gaiyou.html"]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,null,null,null,{"$f":"COUNTA(E33:E62)","v":16}]
[null,null,null,null,"*入力方法","スラッシュ区切り"]
[null,null,null,null,"例　2019/1/25 ->1月25日(月）スラッシュ区切りで入力すれば、月日曜日表示されます。"]
[null,null,null,null,null,"※休日情報は入力したら自動的に反映されます（データ適用ボタンの処理）"]
["NOTE（67行）"]
[]
[]
[null,"月次作業報告書自動作成"]
[]
[null,null,"作成日","2017-07-31"]
[null,null,"作成者　　　******"]
[]
[null,"履歴"]
[null,"1）","2017-07-31"]
[null,null,"初回リリース"]
[null,null,"年月度を選択すれば、報告書フォーマットが自動生成される"]
[null,null,"休日処理も自動反映"]
[null,null,"ユーザーの設定日も自動反映"]
[null,null,"始業・終業・休憩時間自動設定"]
[]
[null,"2)","2017-11-28"]
[null,null,"必須入力事項のチェックルーチン追加。"]
[]
[null,"3)","2019-04-18"]
[null,null,"休日カレンダーを更新（2019年限定版）"]
[]
[null,"4）","2022-05-15"]
[null,null,"休日情報関係の処理"]
[null,null,"年度の一括置換機能を追加"]

{"sheet":"作業報告書","index":1,"n_rows":49,"n_cols":14,"rows_kept":49,"cut":false,"hidden":false,"merged":[[3,3,3,6],[3,8,3,11],[48,4,48,7],[48,8,48,9],[6,12,7,12],[4,3,4,10],[6,13,7,13],[7,2,7,3],[7,4,7,5],[39,0,39,5],[46,4,47,7],[46,8,46,9],[46,10,46,11],[47,8,47,9],[6,0,7,1],[6,2,6,5],[6,6,6,7],[6,8,6,9],[6,10,6,11]]}
[]
["作　業　報　告　書",null,null,null,"（平成",4,"年",6,"月分）"]
[]
["作業期間：",null,null,"2022-06-01",null,null,null,"～","2022-06-30",null,null,null,"所   属：*****株式会社+++++部"]
["業      務：　　",null,null,"********株式会社",null,null,null,null,null,null,null,null,"氏　 名：山田太郎"]
[]
["日 付",null,"作業時刻",null,null,null,"休憩時間",null,"作業外時間",null,"実作業時間",null,"作　　業　　内　　容","備　考"]
[null,null,"開　始",null,"終　了",null,"時","分","時","分","時","分"]
["2022-06-01",44713,8,45,null,null,1,0,null,null,{"$f":"IF(AND(E9<>\"\",C9<>\"\"),INT((E9*60+F9-C9*60-D9-G9*60-H9-I9*60-J9)/60),\"\")","v":""},{"$f":"IF(AND(E9<>\"\",C9<>\"\"),MOD((E9*60+F9-C9*60-D9-G9*60-H9-I9*60-J9),60),\"\")","v":""},"運用・保守対応"]
["2022-06-02",44714,8,45,null,null,1,0,null,null,{"$f":"IF(AND(E10<>\"\",C10<>\"\"),INT((E10*60+F10-C10*60-D10-G10*60-H10-I10*60-J10)/60),\"\")","v":""},{"$f":"IF(AND(E10<>\"\",C10<>\"\"),MOD((E10*60+F10-C10*60-D10-G10*60-H10-I10*60-J10),60),\"\")","v":""},"運用・保守対応"]
["2022-06-03",44715,8,45,null,null,1,0,null,null,"","","運用・保守対応"]
["2022-06-04",44716,null,null,null,null,null,null,null,null,"",""]
["2022-06-05",44717,null,null,null,null,null,null,null,null,"",""]
["2022-06-06",44718,8,45,null,null,1,0,null,null,"","","運用・保守対応"]
["2022-06-07",44719,8,45,null,null,1,0,null,null,"","","運用・保守対応"]
["2022-06-08",44720,8,45,null,null,1,0,null,null,"","","運用・保守対応"]
["2022-06-09",44721,8,45,null,null,1,0,null,null,"","","運用・保守対応"]
["2022-06-10",44722,8,45,null,null,1,0,null,null,"","","運用・保守対応"]
["2022-06-11",44723,null,null,null,null,null,null,null,null,"",""]
["2022-06-12",44724,null,null,null,null,null,null,null,null,"",""]
["2022-06-13",44725,8,45,null,null,1,0,null,null,"","","運用・保守対応"]
["2022-06-14",44726,8,45,null,null,1,0,null,null,"","","運用・保守対応"]
["2022-06-15",44727,8,45,null,null,1,0,null,null,"","","運用・保守対応"]
["2022-06-16",44728,8,45,null,null,1,0,null,null,"","","運用・保守対応"]
["2022-06-17",44729,8,45,null,null,1,0,null,null,"","","運用・保守対応"]
["2022-06-18",44730,null,null,null,null,null,null,null,null,"",""]
["2022-06-19",44731,null,null,null,null,null,null,null,null,"",""]
["2022-06-20",44732,8,45,null,null,1,0,null,null,"","","運用・保守対応"]
["2022-06-21",44733,8,45,null,null,1,0,null,null,"","","運用・保守対応"]
["2022-06-22",44734,8,45,null,null,1,0,null,null,"","","運用・保守対応"]
["2022-06-23",44735,8,45,null,null,1,0,null,null,"","","運用・保守対応"]
["2022-06-24",44736,8,45,null,null,1,0,null,null,"","","運用・保守対応"]
["2022-06-25",44737,null,null,null,null,null,null,null,null,"",""]
["2022-06-26",44738,null,null,null,null,null,null,null,null,"",""]
["2022-06-27",44739,8,45,null,null,1,0,null,null,"","","運用・保守対応"]
["2022-06-28",44740,8,45,null,null,1,0,null,null,"","","運用・保守対応"]
["2022-06-29",44741,8,45,null,null,1,0,null,null,"","","運用・保守対応"]
["2022-06-30",44742,8,45,null,null,1,0,null,null,"","","運用・保守対応"]
[null,null,null,null,null,null,null,null,null,null,"",""]
["調　　整　　時　　間",null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K9:K40)+INT(SUM(L9:L40)/60)","v":0},{"$f":"MOD(SUM(L9:L40),60)","v":0}]
[]
[null,"※合計の（分）は30分単位でお願いします。（30分単位に満たない場合は切り捨て）"]
[null,"※調整時間が発生したら、理由を作業内容欄に記入してください。"]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null,null,null,"作業実績",null,null,null,"作業日数",null,"実作業時間"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(K9:K39,\">0\")","v":0},null,{"$f":"K41","v":0},{"$f":"L41","v":0}]
[null,null,null,null,"稼動日数",null,null,null,22,null,{"$f":"I49*8","v":176},"00"]

{"sheet":"readme","index":2,"n_rows":26,"n_cols":1,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["月次作業報告書の作成"]
[]
["この作業報告書は、ある会社の担当者が顧客先で常駐作業しその作業状況を日々記録して"]
["毎月1回その作業状況を、自分の会社に報告するためのものです。"]
[]
["■毎月の処理手順"]
[]
["1）月次作業報告書の作成（1回/月）"]
[]
["①・作業年月を選択"]
["②・設定値（自社情報、顧客情報、時間情報）の確認"]
["③・「データの適用」ボタンを押す　-->　作業報告書に設定値が反映される"]
["④・「報告書の保存」ボタンを押して作業報告書を切り離してそこに日々のデータを入力していく"]
["本体は[業務報告書作成.xlsm]"]
["切り離された月次ファイルは（例）[勤務実績(山田太郎_2022年06月度).xlsx]と言うファイルになる"]
[]
["2）日々の作業データの入力（毎日）"]
[]
["①・作業報告書に日々の終了時間を入力する"]
["（休憩次回以外の時間外事項があれば入力：その時間だけ作業時間から差し引かれる）"]
["特記事項があれば備考欄に記入"]
[]
["3）月次作業報告書の提出（1回/月）"]
[]
["①・月次作業報告書を関係個所にメール等で送付する"]
["②・翌月の月次報告書の作成をする"]