{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["ホール パス履歴"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"ホール パス履歴","index":0,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[0,1,0,2],[0,3,0,5],[1,1,1,5]]}
[null,"ホール パス履歴",null,"担任: Ms. Galvin、教室: 34"]
[null,{"$f":"IFERROR(\"平均時間: \"&TEXT((SUBTOTAL(109,パス[戻り時刻])-SUBTOTAL(109,パス[退出時刻]))/SUBTOTAL(102,パス[退出時刻]),\"[h]:mm\"),\"[戻り時刻] を入力すると [平均時間] が表示されます\")","v":"平均時間: 0:04"}]
[null,"日付","学生","行き先","退出時刻","戻り時刻"]
[null,{"$f":"TODAY()","v":"2018-05-17"},"James","トイレ","09:15:00","09:23:00"]
[null,{"$f":"TODAY()","v":"2018-05-17"},"John","備品庫","10:11:00","10:16:00"]
[null,{"$f":"TODAY()+1","v":"2018-05-18"},"Shawn","トイレ","13:33:00","13:36:00"]
[null,{"$f":"TODAY()+1","v":"2018-05-18"},"Phil","トイレ","11:24:00","11:27:00"]
[null,{"$f":"TODAY()+2","v":"2018-05-19"},"John","トイレ","11:40:00","11:44:00"]
[null,{"$f":"TODAY()+2","v":"2018-05-19"},"John","トイレ"]
[null,{"$f":"TODAY()+3","v":"2018-05-20"},"James","備品庫"]
[null,{"$f":"TODAY()+3","v":"2018-05-20"},"John","トイレ"]