{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["編集用","確認用","使い方"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":45,"n_cols":46,"rows_kept":45,"cut":false,"hidden":false,"merged":[[11,17,12,19],[11,20,12,22],[11,23,12,25],[11,26,12,28],[11,29,12,31],[11,32,12,34],[11,35,12,37],[11,38,12,40],[10,0,12,1],[10,2,12,3],[10,4,12,7],[10,8,10,13],[10,14,10,19],[10,20,10,40],[11,8,12,10],[0,32,0,34],[0,35,0,37],[0,38,0,39],[1,0,1,21],[1,32,1,34],[1,35,1,37],[1,38,1,39],[3,0,3,2],[3,3,3,6],[3,7,3,9],[3,10,3,21],[3,22,3,27],[3,28,3,37],[5,0,5,6],[7,31,7,37],[7,38,7,40],[8,31,8,37],[8,38,8,40],[5,21,5,30],[5,31,5,37],[5,38,5,40],[6,21,6,30],[6,31,6,37],[6,38,6,40],[7,21,7,30],[7,0,7,6],[8,0,8,6],[8,7,8,13],[8,14,8,20],[8,21,8,30],[5,7,5,13],[5,14,5,20],[6,0,6,6],[6,7,6,13],[6,14,6,20],[7,7,7,13],[7,14,7,20],[13,17,13,19],[13,20,13,22],[13,23,13,25],[13,26,13,28],[13,29,13,31],[13,32,13,34],[13,35,13,37],[13,38,13,40],[11,11,12,13],[11,14,12,16],[13,0,13,1],[13,2,13,3],[13,8,13,10],[13,11,13,13],[13,14,13,16],[14,23,14,25],[14,26,14,28],[14,29,14,31],[14,32,14,34],[14,35,14,37],[14,38,14,40],[14,0,14,1],[14,2,14,3],[14,8,14,10],[14,11,14,13],[14,14,14,16],[14,17,14,19],[14,20,14,22],[15,23,15,25],[15,26,15,28],[15,29,15,31],[15,32,15,34],[15,35,15,37],[15,38,15,40],[15,0,15,1],[15,2,15,3],[15,8,15,10],[15,11,15,13],[15,14,15,16],[15,17,15,19],[15,20,15,22],[16,23,16,25],[16,26,16,28],[16,29,16,31],[16,32,16,34],[16,35,16,37],[16,38,16,40],[16,0,16,1],[16,2,16,3],[16,8,16,10],[16,11,16,13],[16,14,16,16],[16,17,16,19],[16,20,16,22],[20,23,20,25],[20,26,20,28],[20,29,20,31],[20,32,20,34],[20,35,20,37],[20,38,20,40],[20,0,20,1],[20,2,20,3],[20,8,20,10],[20,11,20,13],[20,14,20,16],[20,17,20,19],[20,20,20,22],[21,23,21,25],[21,26,21,28],[21,29,21,31],[21,32,21,34],[21,35,21,37],[21,38,21,40],[21,0,21,1],[21,2,21,3],[21,8,21,10],[21,11,21,13],[21,14,21,16],[21,17,21,19],[21,20,21,22],[22,23,22,25],[22,26,22,28],[22,29,22,31],[22,32,22,34],[22,35,22,37],[22,38,22,40],[22,0,22,1],[22,2,22,3],[22,8,22,10],[22,11,22,13],[22,14,22,16],[22,17,22,19],[22,20,22,22],[23,23,23,25],[23,26,23,28],[23,29,23,31],[23,32,23,34],[23,35,23,37],[23,38,23,40],[23,0,23,1],[23,2,23,3],[23,8,23,10],[23,11,23,13],[23,14,23,16],[23,17,23,19],[23,20,23,22],[24,23,24,25],[24,26,24,28],[24,29,24,31],[24,32,24,34],[24,35,24,37],[24,38,24,40],[24,0,24,1],[24,2,24,3],[24,8,24,10],[24,11,24,13],[24,14,24,16],[24,17,24,19],[24,20,24,22],[25,23,25,25],[25,26,25,28],[25,29,25,31],[25,32,25,34],[25,35,25,37],[25,38,25,40],[25,0,25,1],[25,2,25,3],[25,8,25,10],[25,11,25,13],[25,14,25,16],[25,17,25,19],[25,20,25,22],[26,23,26,25],[26,26,26,28],[26,29,26,31],[26,32,26,34],[26,35,26,37],[26,38,26,40],[26,0,26,1],[26,2,26,3],[26,8,26,10],[26,11,26,13],[26,14,26,16],[26,17,26,19],[26,20,26,22],[27,23,27,25],[27,26,27,28],[27,29,27,31],[27,32,27,34],[27,35,27,37],[27,38,27,40],[27,0,27,1],[27,2,27,3],[27,8,27,10],[27,11,27,13],[27,14,27,16],[27,17,27,19],[27,20,27,22],[28,23,28,25],[28,26,28,28],[28,29,28,31],[28,32,28,34],[28,35,28,37],[28,38,28,40],[28,0,28,1],[28,2,28,3],[28,8,28,10],[28,11,28,13],[28,14,28,16],[28,17,28,19],[28,20,28,22],[29,23,29,25],[29,26,29,28],[29,29,29,31],[29,32,29,34],[29,35,29,37],[29,38,29,40],[29,0,29,1],[29,2,29,3],[29,8,29,10],[29,11,29,13],[29,14,29,16],[29,17,29,19],[29,20,29,22],[30,23,30,25],[30,26,30,28],[30,29,30,31],[30,32,30,34],[30,35,30,37],[30,38,30,40],[30,0,30,1],[30,2,30,3],[30,8,30,10],[30,11,30,13],[30,14,30,16],[30,17,30,19],[30,20,30,22],[38,23,38,25],[38,26,38,28],[38,29,38,31],[38,32,38,34],[38,35,38,37],[38,38,38,40],[38,0,38,1],[38,2,38,3],[38,8,38,10],[38,11,38,13],[38,14,38,16],[38,17,38,19],[38,20,38,22],[39,23,39,25],[39,26,39,28],[39,29,39,31],[39,32,39,34],[39,35,39,37],[39,38,39,40],[39,0,39,1],[39,2,39,3],[39,8,39,10],[39,11,39,13],[39,14,39,16],[39,17,39,19],[39,20,39,22],[40,23,40,25],[40,26,40,28],[40,29,40,31],[40,32,40,34],[40,35,40,37],[40,38,40,40],[40,0,40,1],[40,2,40,3],[40,8,40,10],[40,11,40,13],[40,14,40,16],[40,17,40,19],[40,20,40,22],[41,23,41,25],[41,26,41,28],[41,29,41,31],[41,32,41,34],[41,35,41,37],[41,38,41,40],[41,0,41,1],[41,2,41,3],[41,8,41,10],[41,11,41,13],[41,14,41,16],[41,17,41,19],[41,20,41,22],[42,23,42,25],[42,26,42,28],[42,29,42,31],[42,32,42,34],[42,35,42,37],[42,38,42,40],[42,0,42,1],[42,2,42,3],[42,8,42,10],[42,11,42,13],[42,14,42,16],[42,17,42,19],[42,20,42,22],[43,29,43,31],[43,32,43,34],[43,35,43,37],[43,38,43,40],[43,0,43,1],[43,2,43,3],[43,14,43,16],[43,17,43,19],[43,20,43,22],[43,23,43,25],[43,26,43,28],[17,23,17,25],[17,26,17,28],[17,29,17,31],[17,32,17,34],[17,35,17,37],[17,38,17,40],[17,0,17,1],[17,2,17,3],[17,8,17,10],[17,11,17,13],[17,14,17,16],[17,17,17,19],[17,20,17,22],[18,23,18,25],[18,26,18,28],[18,29,18,31],[18,32,18,34],[18,35,18,37],[18,38,18,40],[18,0,18,1],[18,2,18,3],[18,8,18,10],[18,11,18,13],[18,14,18,16],[18,17,18,19],[18,20,18,22],[19,23,19,25],[19,26,19,28],[19,29,19,31],[19,32,19,34],[19,35,19,37],[19,38,19,40],[19,0,19,1],[19,2,19,3],[19,8,19,10],[19,11,19,13],[19,14,19,16],[19,17,19,19],[19,20,19,22],[44,20,44,22],[44,23,44,25],[44,26,44,28],[44,29,44,31],[44,32,44,34],[44,35,44,37],[31,23,31,25],[31,26,31,28],[31,29,31,31],[31,32,31,34],[31,35,31,37],[31,38,31,40],[31,0,31,1],[31,2,31,3],[31,8,31,10],[31,11,31,13],[31,14,31,16],[31,17,31,19],[31,20,31,22],[32,23,32,25],[32,26,32,28],[32,29,32,31],[32,32,32,34],[32,35,32,37],[32,38,32,40],[32,0,32,1],[32,2,32,3],[32,8,32,10],[32,11,32,13],[32,14,32,16],[32,17,32,19],[32,20,32,22],[33,23,33,25],[33,26,33,28],[33,29,33,31],[33,32,33,34],[33,35,33,37],[33,38,33,40],[33,0,33,1],[33,2,33,3],[33,8,33,10],[33,11,33,13],[33,14,33,16],[33,17,33,19],[33,20,33,22],[34,23,34,25],[34,26,34,28],[34,29,34,31],[34,32,34,34],[34,35,34,37],[34,38,34,40],[34,0,34,1],[34,2,34,3],[34,8,34,10],[34,11,34,13],[34,14,34,16],[34,17,34,19],[34,20,34,22],[35,23,35,25],[35,26,35,28],[35,29,35,31],[35,32,35,34],[35,35,35,37],[35,38,35,40],[35,0,35,1],[35,2,35,3],[35,8,35,10],[35,11,35,13],[35,14,35,16],[35,17,35,19],[35,20,35,22],[36,23,36,25],[36,26,36,28],[36,29,36,31],[36,32,36,34],[36,35,36,37],[36,38,36,40],[36,0,36,1],[36,2,36,3],[36,8,36,10],[36,11,36,13],[36,14,36,16],[36,17,36,19],[36,20,36,22],[37,23,37,25],[37,26,37,28],[37,29,37,31],[37,32,37,34],[37,35,37,37],[37,38,37,40],[37,0,37,1],[37,2,37,3],[37,8,37,10],[37,11,37,13],[37,14,37,16],[37,17,37,19],[37,20,37,22]]}
[{"$nulls":42},"時間設定"]
["2018年08月01日-2018年08月31日分"]
[{"$nulls":42},"早朝・深夜業時間",0.916666666666667,"～",0.208333333333333]
["社員NO",{"$nulls":6},"所属",{"$nulls":14},"氏名",{"$nulls":5},"鹿島和正",{"$nulls":13},"休憩時間","01:00:00"]
[{"$nulls":42},"残業時間","08:00:00"]
["出勤日数",{"$nulls":6},"欠勤日数",{"$nulls":6},"有休取得日数",{"$nulls":6},"代休取得日数",{"$nulls":9},"振休取得日数",{"$nulls":6},"Akerun利用日数"]
[{"$f":"COUNTIF($E$14:$H$44,\"出勤\")","v":19},{"$nulls":6},{"$f":"COUNTIF($E$14:$H$44,\"欠勤\")","v":0},{"$nulls":6},{"$f":"COUNTIF($E$14:$H$44,\"有給休暇\")","v":0},{"$nulls":6},{"$f":"COUNTIF($E$14:$H$44,\"代休\")","v":0},{"$nulls":9},{"$f":"COUNTIF($E$14:$H$44,\"振休\")","v":0},{"$nulls":6},19.0]
["総就業時間",{"$nulls":6},"残業時間",{"$nulls":6},"早朝勤務時間",{"$nulls":6},"深夜勤務時間",{"$nulls":9},"休日出勤時間",{"$nulls":6},"Akerun利用日率"]
[{"$f":"U45","v":5.490277778},{"$nulls":6},{"$f":"AA45","v":0.2444444444},{"$nulls":6},{"$f":"AD45","v":0},{"$nulls":6},{"$f":"AG45","v":0},{"$nulls":9},{"$f":"AJ45","v":0},{"$nulls":6},{"$f":"IFERROR(AM7/A7,\"\")","v":1}]
[{"$nulls":44},"所定休日","法定休日"]
["日",null,"曜日",null,"勤怠区分",null,null,null,"入退室時刻     ",{"$nulls":5},"就業時刻",{"$nulls":5},"就業時間",{"$nulls":23},{"$f":"AS45","v":0},0]
[{"$nulls":8},"出社",null,null,"退社",null,null,"出社",null,null,"退社",null,null,"総就業",null,null,"休憩",null,null,"残業",null,null,"早朝勤務",null,null,"深夜勤務",null,null,"休日出勤",null,null,"備考"]
[{"$nulls":42},"勤怠区分",null,"所定休日","法定休日"]
[1.0,null,"水",null,"出勤",null,null,null,"18:33:00",null,null,"20:14:00",null,null,{"$f":"IF(I14=\"\",\"\",I14)","v":"18:33:00"},null,null,{"$f":"IF(L14=\"\",\"\",L14)","v":"20:14:00"},null,null,{"$f":"IF(E14=\"有給休暇\",TIME(8,0,0),IF(OR(O14=\"\",R14=\"\"),\"\",IF((R14-O14-X14)>0,R14-O14-X14,\"24:00\"-O14+R14-X14)))","v":0.07013888889},null,null,{"$f":"IF(E14=\"有給休暇\",TIME(8,0,0),IF(OR(O14=\"\",R14=\"\"),\"\",IF(AND((R14-O14)>0,(R14-O14)<\"6:00\"*1),\"0:00\",$AR$4)))","v":"0:00"},null,null,{"$f":"IF(OR(I14=\"\",R14=\"\",U14<$AR$5),\"\",U14-$AR$5)","v":""},{"$nulls":8},{"$f":"IF(E14=\"休日出勤\",U14,\"\")","v":""}]
[2.0,null,"木",null,"出勤",null,null,null,"10:06:00",null,null,"20:29:00",null,null,"10:06:00",null,null,"20:29:00",null,null,0.3909722222,null,null,0.04166666667,null,null,0.05763888889,{"$nulls":8},"",{"$nulls":6},"出勤"]
[3.0,null,"金",null,"出勤",null,null,null,"11:21:00",null,null,"19:49:00",null,null,"11:21:00",null,null,"19:49:00",null,null,0.3111111111,null,null,0.04166666667,null,null,"",{"$nulls":8},"",{"$nulls":6},"欠勤"]
[4.0,null,"土",{"$nulls":11},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},"",{"$nulls":6},"有給休暇"]
[5.0,null,"日",{"$nulls":11},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},"",{"$nulls":6},"代休"]
[6.0,null,"月",null,"出勤",null,null,null,"10:07:00",null,null,"19:21:00",null,null,"10:07:00",null,null,"19:21:00",null,null,0.3430555556,null,null,0.04166666667,null,null,0.009722222222,{"$nulls":8},"",{"$nulls":6},"振休"]
[7.0,null,"火",null,"出勤",null,null,null,"10:08:00",null,null,"14:57:00",null,null,"10:08:00",null,null,"14:57:00",null,null,0.2006944444,null,null,"0:00",null,null,"",{"$nulls":8},"",{"$nulls":6},"休日出勤"]
[8.0,null,"水",null,"出勤",null,null,null,"09:58:00",null,null,"13:22:00",null,null,"09:58:00",null,null,"13:22:00",null,null,0.1416666667,null,null,"0:00",null,null,"",{"$nulls":8},"",{"$nulls":6},"その他休暇"]
[9.0,null,"木",null,"出勤",null,null,null,"10:08:00",null,null,"19:23:00",null,null,"10:08:00",null,null,"19:23:00",null,null,0.34375,null,null,0.04166666667,null,null,0.01041666667,{"$nulls":8},""]
[10.0,null,"金",{"$nulls":11},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},""]
[11.0,null,"土",{"$nulls":11},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},""]
[12.0,null,"日",null,"出勤",null,null,null,"12:05:00",null,null,"13:56:00",null,null,"12:05:00",null,null,"13:56:00",null,null,0.07708333333,null,null,"0:00",null,null,"",{"$nulls":8},""]
[13.0,null,"月",null,"出勤",null,null,null,"10:07:00",null,null,"19:06:00",null,null,"10:07:00",null,null,"19:06:00",null,null,0.3326388889,null,null,0.04166666667,null,null,"",{"$nulls":8},""]
[14.0,null,"火",null,"出勤",null,null,null,"11:47:00",null,null,"19:23:00",null,null,"11:47:00",null,null,"19:23:00",null,null,0.275,null,null,0.04166666667,null,null,"",{"$nulls":8},""]
[15.0,null,"水",{"$nulls":11},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},""]
[16.0,null,"木",null,"出勤",null,null,null,"10:04:00",null,null,"19:16:00",null,null,"10:04:00",null,null,"19:16:00",null,null,0.3416666667,null,null,0.04166666667,null,null,0.008333333333,{"$nulls":8},""]
[17.0,null,"金",{"$nulls":11},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},""]
[18.0,null,"土",{"$nulls":11},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},""]
[19.0,null,"日",{"$nulls":11},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},""]
[20.0,null,"月",{"$nulls":11},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},""]
[21.0,null,"火",null,"出勤",null,null,null,"09:45:00",null,null,"19:44:00",null,null,"09:45:00",null,null,"19:44:00",null,null,0.3743055556,null,null,0.04166666667,null,null,0.04097222222,{"$nulls":8},""]
[22.0,null,"水",null,"出勤",null,null,null,"09:57:00",null,null,"18:44:00",null,null,"09:57:00",null,null,"18:44:00",null,null,0.3243055556,null,null,0.04166666667,null,null,"",{"$nulls":8},""]
[23.0,null,"木",null,"出勤",null,null,null,"13:29:00",null,null,"19:11:00",null,null,"13:29:00",null,null,"19:11:00",null,null,0.2375,null,null,"0:00",null,null,"",{"$nulls":8},""]
[24.0,null,"金",null,"出勤",null,null,null,"10:00:00",null,null,"20:10:00",null,null,"10:00:00",null,null,"20:10:00",null,null,0.3819444444,null,null,0.04166666667,null,null,0.04861111111,{"$nulls":8},""]
[25.0,null,"土",{"$nulls":11},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},""]
[26.0,null,"日",{"$nulls":11},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},""]
[27.0,null,"月",null,"出勤",null,null,null,"10:01:00",null,null,"19:13:00",null,null,"10:01:00",null,null,"19:13:00",null,null,0.3416666667,null,null,0.04166666667,null,null,0.008333333333,{"$nulls":8},""]
[28.0,null,"火",null,"出勤",null,null,null,"11:00:00",null,null,"20:53:00",null,null,"11:00:00",null,null,"20:53:00",null,null,0.3701388889,null,null,0.04166666667,null,null,0.03680555556,{"$nulls":8},""]
[29.0,null,"水",null,"出勤",null,null,null,"12:22:00",null,null,"19:59:00",null,null,"12:22:00",null,null,"19:59:00",null,null,0.2756944444,null,null,0.04166666667,null,null,"",{"$nulls":8},""]
[30.0,null,"木",null,"出勤",null,null,null,"09:58:00",null,null,"19:32:00",null,null,"09:58:00",null,null,"19:32:00",null,null,0.3569444444,null,null,0.04166666667,null,null,0.02361111111,{"$nulls":8},""]
[31.0,null,"金",{"$nulls":11},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},""]
[{"$nulls":20},{"$f":"SUM(U14:U44)","v":5.490277778},null,null,{"$f":"SUM(X14:X44)","v":0.5833333333},null,null,{"$f":"SUM(AA14:AA44)","v":0.2444444444},null,null,{"$f":"AD14+AD15+AD16+AD17+AD18+AD19+AD20+AD21+AD22+AD23+AD24+AD25+AD26+AD27+AD28+AD29+AD30+AD31+AD32+AD33+AD34+AD35+AD36+AD37+AD38+AD39+AD40+AD41+AD42+AD43+AD44","v":0},null,null,{"$f":"AG14+AG15+AG16+AG17+AG18+AG19+AG20+AG21+AG22+AG23+AG24+AG25+AG26+AG27+AG28+AG29+AG30+AG31+AG32+AG33+AG34+AG35+AG36+AG37+AG38+AG39+AG40+AG41+AG42+AG43+AG44","v":0},null,null,{"$f":"SUM(AJ14:AJ44)","v":0},{"$nulls":8},{"$f":"SUM(AS14:AS44)","v":0},0]

{"sheet":"確認用","index":1,"n_rows":45,"n_cols":46,"rows_kept":45,"cut":false,"hidden":false,"merged":[[11,17,12,19],[11,20,12,22],[11,23,12,25],[11,26,12,28],[11,29,12,31],[11,32,12,34],[11,35,12,37],[11,38,12,40],[10,0,12,1],[10,2,12,3],[10,4,12,7],[10,8,10,13],[10,14,10,19],[10,20,10,40],[11,8,12,10],[13,35,13,37],[13,38,13,40],[13,14,13,16],[13,17,13,19],[13,20,13,22],[13,23,13,25],[13,26,13,28],[13,29,13,31],[13,32,13,34],[0,32,0,34],[0,35,0,37],[0,38,0,39],[1,0,1,21],[1,32,1,34],[1,35,1,37],[1,38,1,39],[3,0,3,2],[3,3,3,6],[3,7,3,9],[3,10,3,21],[3,22,3,27],[3,28,3,37],[5,0,5,6],[7,31,7,37],[7,38,7,40],[8,31,8,37],[8,38,8,40],[5,21,5,30],[5,31,5,37],[5,38,5,40],[6,21,6,30],[6,31,6,37],[6,38,6,40],[7,21,7,30],[7,0,7,6],[8,0,8,6],[8,7,8,13],[8,14,8,20],[8,21,8,30],[5,7,5,13],[5,14,5,20],[6,0,6,6],[6,7,6,13],[6,14,6,20],[7,7,7,13],[7,14,7,20],[11,11,12,13],[11,14,12,16],[13,0,13,1],[13,2,13,3],[13,4,13,7],[13,8,13,10],[13,11,13,13],[17,20,17,22],[17,23,17,25],[17,26,17,28],[17,29,17,31],[17,32,17,34],[17,35,17,37],[17,38,17,40],[17,0,17,1],[17,2,17,3],[17,4,17,7],[17,8,17,10],[17,11,17,13],[17,14,17,16],[17,17,17,19],[18,20,18,22],[18,23,18,25],[18,26,18,28],[18,29,18,31],[18,32,18,34],[18,35,18,37],[18,38,18,40],[18,0,18,1],[18,2,18,3],[18,4,18,7],[18,8,18,10],[18,11,18,13],[18,14,18,16],[18,17,18,19],[19,20,19,22],[19,23,19,25],[19,26,19,28],[19,29,19,31],[19,32,19,34],[19,35,19,37],[19,38,19,40],[19,0,19,1],[19,2,19,3],[19,4,19,7],[19,8,19,10],[19,11,19,13],[19,14,19,16],[19,17,19,19],[20,20,20,22],[20,23,20,25],[20,26,20,28],[20,29,20,31],[20,32,20,34],[20,35,20,37],[20,38,20,40],[20,0,20,1],[20,2,20,3],[20,4,20,7],[20,8,20,10],[20,11,20,13],[20,14,20,16],[20,17,20,19],[21,20,21,22],[21,23,21,25],[21,26,21,28],[21,29,21,31],[21,32,21,34],[21,35,21,37],[21,38,21,40],[21,0,21,1],[21,2,21,3],[21,4,21,7],[21,8,21,10],[21,11,21,13],[21,14,21,16],[21,17,21,19],[22,20,22,22],[22,23,22,25],[22,26,22,28],[22,29,22,31],[22,32,22,34],[22,35,22,37],[22,38,22,40],[22,0,22,1],[22,2,22,3],[22,4,22,7],[22,8,22,10],[22,11,22,13],[22,14,22,16],[22,17,22,19],[23,20,23,22],[23,23,23,25],[23,26,23,28],[23,29,23,31],[23,32,23,34],[23,35,23,37],[23,38,23,40],[23,0,23,1],[23,2,23,3],[23,4,23,7],[23,8,23,10],[23,11,23,13],[23,14,23,16],[23,17,23,19],[24,20,24,22],[24,23,24,25],[24,26,24,28],[24,29,24,31],[24,32,24,34],[24,35,24,37],[24,38,24,40],[24,0,24,1],[24,2,24,3],[24,4,24,7],[24,8,24,10],[24,11,24,13],[24,14,24,16],[24,17,24,19],[25,20,25,22],[25,23,25,25],[25,26,25,28],[25,29,25,31],[25,32,25,34],[25,35,25,37],[25,38,25,40],[25,0,25,1],[25,2,25,3],[25,4,25,7],[25,8,25,10],[25,11,25,13],[25,14,25,16],[25,17,25,19],[26,20,26,22],[26,23,26,25],[26,26,26,28],[26,29,26,31],[26,32,26,34],[26,35,26,37],[26,38,26,40],[26,0,26,1],[26,2,26,3],[26,4,26,7],[26,8,26,10],[26,11,26,13],[26,14,26,16],[26,17,26,19],[27,20,27,22],[27,23,27,25],[27,26,27,28],[27,29,27,31],[27,32,27,34],[27,35,27,37],[27,38,27,40],[27,0,27,1],[27,2,27,3],[27,4,27,7],[27,8,27,10],[27,11,27,13],[27,14,27,16],[27,17,27,19],[28,20,28,22],[28,23,28,25],[28,26,28,28],[28,29,28,31],[28,32,28,34],[28,35,28,37],[28,38,28,40],[28,0,28,1],[28,2,28,3],[28,4,28,7],[28,8,28,10],[28,11,28,13],[28,14,28,16],[28,17,28,19],[29,20,29,22],[29,23,29,25],[29,26,29,28],[29,29,29,31],[29,32,29,34],[29,35,29,37],[29,38,29,40],[29,0,29,1],[29,2,29,3],[29,4,29,7],[29,8,29,10],[29,11,29,13],[29,14,29,16],[29,17,29,19],[30,20,30,22],[30,23,30,25],[30,26,30,28],[30,29,30,31],[30,32,30,34],[30,35,30,37],[30,38,30,40],[30,0,30,1],[30,2,30,3],[30,4,30,7],[30,8,30,10],[30,11,30,13],[30,14,30,16],[30,17,30,19],[31,20,31,22],[31,23,31,25],[31,26,31,28],[31,29,31,31],[31,32,31,34],[31,35,31,37],[31,38,31,40],[31,0,31,1],[31,2,31,3],[31,4,31,7],[31,8,31,10],[31,11,31,13],[31,14,31,16],[31,17,31,19],[32,20,32,22],[32,23,32,25],[32,26,32,28],[32,29,32,31],[32,32,32,34],[32,35,32,37],[32,38,32,40],[32,0,32,1],[32,2,32,3],[32,4,32,7],[32,8,32,10],[32,11,32,13],[32,14,32,16],[32,17,32,19],[33,20,33,22],[33,23,33,25],[33,26,33,28],[33,29,33,31],[33,32,33,34],[33,35,33,37],[33,38,33,40],[33,0,33,1],[33,2,33,3],[33,4,33,7],[33,8,33,10],[33,11,33,13],[33,14,33,16],[33,17,33,19],[34,20,34,22],[34,23,34,25],[34,26,34,28],[34,29,34,31],[34,32,34,34],[34,35,34,37],[34,38,34,40],[34,0,34,1],[34,2,34,3],[34,4,34,7],[34,8,34,10],[34,11,34,13],[34,14,34,16],[34,17,34,19],[42,20,42,22],[42,23,42,25],[42,26,42,28],[42,29,42,31],[42,32,42,34],[42,35,42,37],[42,38,42,40],[42,0,42,1],[42,2,42,3],[42,4,42,7],[42,8,42,10],[42,11,42,13],[42,14,42,16],[42,17,42,19],[43,0,43,1],[43,2,43,3],[43,4,43,7],[43,8,43,10],[43,11,43,13],[43,14,43,16],[43,17,43,19],[43,20,43,22],[43,23,43,25],[43,26,43,28],[43,29,43,31],[43,32,43,34],[43,35,43,37],[43,38,43,40],[14,20,14,22],[14,23,14,25],[14,26,14,28],[14,29,14,31],[14,32,14,34],[14,35,14,37],[14,38,14,40],[14,0,14,1],[14,2,14,3],[14,4,14,7],[14,8,14,10],[14,11,14,13],[14,14,14,16],[14,17,14,19],[15,20,15,22],[15,23,15,25],[15,26,15,28],[15,29,15,31],[15,32,15,34],[15,35,15,37],[15,38,15,40],[15,0,15,1],[15,2,15,3],[15,4,15,7],[15,8,15,10],[15,11,15,13],[15,14,15,16],[15,17,15,19],[16,20,16,22],[16,23,16,25],[16,26,16,28],[16,29,16,31],[16,32,16,34],[16,35,16,37],[16,38,16,40],[16,0,16,1],[16,2,16,3],[16,4,16,7],[16,8,16,10],[16,11,16,13],[16,14,16,16],[16,17,16,19],[44,20,44,22],[44,23,44,25],[44,26,44,28],[44,29,44,31],[44,32,44,34],[44,35,44,37],[35,20,35,22],[35,23,35,25],[35,26,35,28],[35,29,35,31],[35,32,35,34],[35,35,35,37],[35,38,35,40],[35,0,35,1],[35,2,35,3],[35,4,35,7],[35,8,35,10],[35,11,35,13],[35,14,35,16],[35,17,35,19],[36,20,36,22],[36,23,36,25],[36,26,36,28],[36,29,36,31],[36,32,36,34],[36,35,36,37],[36,38,36,40],[36,0,36,1],[36,2,36,3],[36,4,36,7],[36,8,36,10],[36,11,36,13],[36,14,36,16],[36,17,36,19],[37,20,37,22],[37,23,37,25],[37,26,37,28],[37,29,37,31],[37,32,37,34],[37,35,37,37],[37,38,37,40],[37,0,37,1],[37,2,37,3],[37,4,37,7],[37,8,37,10],[37,11,37,13],[37,14,37,16],[37,17,37,19],[38,20,38,22],[38,23,38,25],[38,26,38,28],[38,29,38,31],[38,32,38,34],[38,35,38,37],[38,38,38,40],[38,0,38,1],[38,2,38,3],[38,4,38,7],[38,8,38,10],[38,11,38,13],[38,14,38,16],[38,17,38,19],[39,20,39,22],[39,23,39,25],[39,26,39,28],[39,29,39,31],[39,32,39,34],[39,35,39,37],[39,38,39,40],[39,0,39,1],[39,2,39,3],[39,4,39,7],[39,8,39,10],[39,11,39,13],[39,14,39,16],[39,17,39,19],[40,20,40,22],[40,23,40,25],[40,26,40,28],[40,29,40,31],[40,32,40,34],[40,35,40,37],[40,38,40,40],[40,0,40,1],[40,2,40,3],[40,4,40,7],[40,8,40,10],[40,11,40,13],[40,14,40,16],[40,17,40,19],[41,20,41,22],[41,23,41,25],[41,26,41,28],[41,29,41,31],[41,32,41,34],[41,35,41,37],[41,38,41,40],[41,0,41,1],[41,2,41,3],[41,4,41,7],[41,8,41,10],[41,11,41,13],[41,14,41,16],[41,17,41,19]]}
[{"$nulls":42},"時間設定"]
[]
[{"$nulls":42},"早朝・深夜業時間",0.916666666666667,"～",0.208333333333333]
["社員NO",{"$nulls":6},"所属",{"$nulls":14},"氏名",{"$nulls":19},"休憩時間","01:00:00"]
[{"$nulls":42},"残業時間","08:00:00"]
["出勤日数",{"$nulls":6},"欠勤日数",{"$nulls":6},"有休取得日数",{"$nulls":6},"代休取得日数",{"$nulls":9},"振休取得日数",{"$nulls":6},"Akerun利用日数"]
[{"$f":"COUNTIF($E$14:$H$44,\"出勤\")","v":0},{"$nulls":6},{"$f":"COUNTIF($E$14:$H$44,\"欠勤\")","v":0},{"$nulls":6},{"$f":"COUNTIF($E$14:$H$44,\"有給休暇\")","v":0},{"$nulls":6},{"$f":"COUNTIF($E$14:$H$44,\"代休\")","v":0},{"$nulls":9},{"$f":"COUNTIF($E$14:$H$44,\"振休\")","v":0},{"$nulls":6},0.0]
["総就業時間",{"$nulls":6},"残業時間",{"$nulls":6},"早朝勤務時間",{"$nulls":6},"深夜勤務時間",{"$nulls":9},"休日出勤時間",{"$nulls":6},"Akerun利用日率"]
[{"$f":"U45","v":0},{"$nulls":6},{"$f":"AA45","v":0},{"$nulls":6},{"$f":"AD45","v":0},{"$nulls":6},{"$f":"AG45","v":0},{"$nulls":9},{"$f":"AJ45","v":0},{"$nulls":6},{"$f":"IFERROR(AM7/A7,\"\")","v":""}]
[{"$nulls":44},"所定休日","法定休日"]
["日",null,"曜日",null,"勤怠区分",null,null,null,"入退室時刻     ",{"$nulls":5},"就業時刻",{"$nulls":5},"就業時間",{"$nulls":23},{"$f":"AS45","v":0},0]
[{"$nulls":8},"出社",null,null,"退社",null,null,"出社",null,null,"退社",null,null,"総就業",null,null,"休憩",null,null,"残業",null,null,"早朝勤務",null,null,"深夜勤務",null,null,"休日出勤",null,null,"備考"]
[{"$nulls":42},"勤怠区分",null,"所定休日","法定休日"]
[{"$nulls":14},{"$f":"IF(I14=\"\",\"\",I14)","v":""},null,null,{"$f":"IF(L14=\"\",\"\",L14)","v":""},null,null,{"$f":"IF(E14=\"有給休暇\",TIME(8,0,0),IF(OR(O14=\"\",R14=\"\"),\"\",IF((R14-O14-X14)>0,R14-O14-X14,\"24:00\"-O14+R14-X14)))","v":""},null,null,{"$f":"IF(E14=\"有給休暇\",TIME(8,0,0),IF(OR(O14=\"\",R14=\"\"),\"\",IF(AND((R14-O14)>0,(R14-O14)<\"6:00\"*1),\"0:00\",$AR$4)))","v":""},null,null,{"$f":"IF(OR(I14=\"\",R14=\"\",U14<$AR$5),\"\",U14-$AR$5)","v":""},{"$nulls":8},{"$f":"IF(E14=\"休日出勤\",U14,\"\")","v":""}]
[{"$nulls":14},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},"",{"$nulls":6},"出勤"]
[{"$nulls":14},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},"",{"$nulls":6},"欠勤"]
[{"$nulls":14},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},"",{"$nulls":6},"有給休暇"]
[{"$nulls":14},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},"",{"$nulls":6},"代休"]
[{"$nulls":14},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},"",{"$nulls":6},"振休"]
[{"$nulls":14},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},"",{"$nulls":6},"休日出勤"]
[{"$nulls":14},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},"",{"$nulls":6},"その他休暇"]
[{"$nulls":14},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},""]
[{"$nulls":14},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},""]
[{"$nulls":14},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},""]
[{"$nulls":14},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},""]
[{"$nulls":14},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},""]
[{"$nulls":14},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},""]
[{"$nulls":14},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},""]
[{"$nulls":14},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},""]
[{"$nulls":14},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},""]
[{"$nulls":14},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},""]
[{"$nulls":14},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},""]
[{"$nulls":14},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},""]
[{"$nulls":14},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},""]
[{"$nulls":14},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},""]
[{"$nulls":14},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},""]
[{"$nulls":14},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},""]
[{"$nulls":14},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},""]
[{"$nulls":14},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},""]
[{"$nulls":14},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},""]
[{"$nulls":14},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},""]
[{"$nulls":14},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},""]
[{"$nulls":14},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},""]
[{"$nulls":14},"",null,null,"",null,null,"",null,null,"",null,null,"",{"$nulls":8},""]
[{"$nulls":20},{"$f":"SUM(U14:U44)","v":0},null,null,{"$f":"SUM(X14:X44)","v":0},null,null,{"$f":"SUM(AA14:AA44)","v":0},null,null,{"$f":"AD14+AD15+AD16+AD17+AD18+AD19+AD20+AD21+AD22+AD23+AD24+AD25+AD26+AD27+AD28+AD29+AD30+AD31+AD32+AD33+AD34+AD35+AD36+AD37+AD38+AD39+AD40+AD41+AD42+AD43+AD44","v":0},null,null,{"$f":"AG14+AG15+AG16+AG17+AG18+AG19+AG20+AG21+AG22+AG23+AG24+AG25+AG26+AG27+AG28+AG29+AG30+AG31+AG32+AG33+AG34+AG35+AG36+AG37+AG38+AG39+AG40+AG41+AG42+AG43+AG44","v":0},null,null,{"$f":"SUM(AJ14:AJ44)","v":0},{"$nulls":8},{"$f":"SUM(AS14:AS44)","v":0},0]

{"sheet":"使い方","index":2,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"◯タイムカード内の用語の説明"]
[null,"入退室時刻","Akerun入退室管理システムで記録された最初と最後の打刻時間です。\n複数のAkerunをご利用の場合は最初のログが記録されます。"]
[null,"就業時刻","Akerun入退室管理システムで記録された「出社」「退社」時間が、実際の勤務時間と異なる場合は修正ください。"]
[null,"休憩","休憩時間は自動的に1時間取得したものとして計算されます。\n異なる場合は修正ください。"]
[null,"早朝勤務 / 深夜勤務","入退室時刻を利用して、\n早朝は5時以前の勤務時間\n深夜は22時以降の勤務時間\nがシステムによって自動計算された時間が入力されています。"]
[null,"休日出勤","勤務区分で「休日出勤」と選択すると計算されます。"]
[null,"Akerun利用日数","Akerun入退室管理システムを利用して打刻をした日数が入力されています。"]
[null,"Akerun利用日率","初期値では Akerun利用日数 ÷ 勤務日数が入力されています。\nリモート勤務した日の勤怠区分を入力し、出勤日数を計算し直すことで、出勤日のうち実際に出社した日の割合を求めることができます。\nリモート勤務を行っている場合の「出社率」を求めやすくなります。"]