{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["週間記録"],"not_rendered":{"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"週間記録","index":0,"n_rows":25,"n_cols":9,"rows_kept":25,"merged":[[2,1,2,6],[2,7,2,8],[3,7,3,8],[4,7,4,8],[5,3,5,4],[5,7,5,8],[6,3,6,4],[6,7,6,8],[7,3,7,4],[7,7,7,8],[21,1,21,6],[21,7,21,8],[22,1,22,6],[22,7,22,8],[23,1,23,6],[23,7,23,8],[24,1,24,6],[24,7,24,8]]}
[]
[]
[null,"週間記録"]
[null,"MODERN DESIGN CO"]
[]
[null,"従業員:",null,"Miguel Reyes",null,null,"従業員の電話番号:","(805) 555-0123"]
[null,"マネージャー:",null,"Jyeshta Davgar",null,null,"従業員のメール:","miguel@example.com"]
[{"$nulls":6},"週の最終日",{"$f":"TODAY()","v":"2023-03-21"}]
[]
[null,"曜日"," ","日付","定時の勤務時間","残業時間:","病欠","休暇","合計"]
[null,{"$f":"IFERROR(TEXT(タイムシート[[#This Row],[日付]],\"aaaa\"), \"\")","v":"水曜日"},null,{"$f":"IFERROR(IF($H$8=0,\"\",$H$8-6), \"\")","v":"2023-03-15"},{"$nulls":4},{"$f":"IFERROR(SUM(E11:H11), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(タイムシート[[#This Row],[日付]],\"aaaa\"), \"\")","v":"木曜日"},null,{"$f":"IFERROR(IF($H$8=0,\"\",$H$8-5), \"\")","v":"2023-03-16"},{"$nulls":4},{"$f":"IFERROR(SUM(E12:H12), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(タイムシート[[#This Row],[日付]],\"aaaa\"), \"\")","v":"金曜日"},null,{"$f":"IFERROR(IF($H$8=0,\"\",$H$8-4), \"\")","v":"2023-03-17"},{"$nulls":4},{"$f":"IFERROR(SUM(E13:H13), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(タイムシート[[#This Row],[日付]],\"aaaa\"), \"\")","v":"土曜日"},null,{"$f":"IFERROR(IF($H$8=0,\"\",$H$8-3), \"\")","v":"2023-03-18"},{"$nulls":4},{"$f":"IFERROR(SUM(E14:H14), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(タイムシート[[#This Row],[日付]],\"aaaa\"), \"\")","v":"日曜日"},null,{"$f":"IFERROR(IF($H$8=0,\"\",$H$8-2), \"\")","v":"2023-03-19"},{"$nulls":4},{"$f":"IFERROR(SUM(E15:H15), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(タイムシート[[#This Row],[日付]],\"aaaa\"), \"\")","v":"月曜日"},null,{"$f":"IFERROR(IF($H$8=0,\"\",$H$8-1), \"\")","v":"2023-03-20"},{"$nulls":4},{"$f":"IFERROR(SUM(E16:H16), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(タイムシート[[#This Row],[日付]],\"aaaa\"), \"\")","v":"火曜日"},null,{"$f":"IFERROR(IF($H$8=0,\"\",$H$8), \"\")","v":"2023-03-21"},{"$nulls":4},{"v":0,"d":"0.00"}]
[{"$nulls":3},"合計時間",{"$f":"IFERROR(SUM(タイムシート[定時の勤務時間]), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(SUM(タイムシート[残業時間:]), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(SUM(タイムシート[病欠]), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(SUM(タイムシート[休暇]), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(SUM(タイムシート[合計]), \"\")","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"時給"]
[{"$nulls":3},"支払合計",{"$f":"IFERROR(E18*E19, \"\")","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(F18*F19, \"\")","v":{"v":0,"d":"¥0"}},{"v":0,"d":"¥0"},{"v":0,"d":"¥0"},{"v":0,"d":"¥0"}]
[]
[]
[null,"従業員の署名",{"$nulls":5},"日付"]
[]
[null,"マネージャーの署名",{"$nulls":5},"日付"]