{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["狀況","圖表"],"not_rendered":{"charts":1,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"狀況","index":0,"n_rows":41,"n_cols":41,"rows_kept":41,"merged":[[0,0,0,22],[0,23,0,25],[0,27,0,28],[0,34,0,35],[0,36,0,40],[1,2,1,32],[1,33,1,40],[3,0,4,0],[3,1,4,1],[3,33,4,33],[3,34,4,34],[3,35,4,35],[3,36,4,36],[3,37,4,37],[3,38,4,38],[3,39,4,39],[3,40,4,40],[40,27,40,32]]}
["員工考勤表 ",{"$nulls":22},{"v":2009,"d":"2009年"},{"$nulls":3},{"v":4,"d":"4月"},{"$nulls":6},"今天日期",null,{"$f":"TODAY()","v":"2012-05-25"}]
[null,null,"日  期",{"$nulls":30},"狀況"]
[null,null,{"$f":"DATE($X$1,$AB$1,1)","v":"2009-04-01"},{"$f":"IF(C3<C5,\"\",C3+1)","v":"2009-04-02"},{"$f":"D3+1","v":"2009-04-03"},"2009-04-04","2009-04-05","2009-04-06","2009-04-07","2009-04-08","2009-04-09","2009-04-10","2009-04-11","2009-04-12","2009-04-13","2009-04-14","2009-04-15","2009-04-16","2009-04-17","2009-04-18","2009-04-19","2009-04-20","2009-04-21","2009-04-22","2009-04-23","2009-04-24","2009-04-25","2009-04-26","2009-04-27","2009-04-28","2009-04-29","2009-04-30","2009-05-01"]
["員工\n編號","員工姓名",{"$f":"C3","v":"2009-04-01"},{"$f":"D3","v":"2009-04-02"},"2009-04-03","2009-04-04","2009-04-05","2009-04-06","2009-04-07","2009-04-08","2009-04-09","2009-04-10","2009-04-11","2009-04-12","2009-04-13","2009-04-14","2009-04-15","2009-04-16","2009-04-17","2009-04-18","2009-04-19","2009-04-20","2009-04-21","2009-04-22","2009-04-23","2009-04-24","2009-04-25","2009-04-26","2009-04-27",{"$f":"IF(OR(MONTH(AD3)-MONTH(AC3)=1,AC4=\"\"),\"\",AD3)","v":"2009-04-28"},{"$f":"IF(OR(MONTH(AE3)-MONTH(AD3)=1,AD4=\"\"),\"\",AE3)","v":"2009-04-29"},{"$f":"IF(OR(MONTH(AF3)-MONTH(AE3)=1,AE4=\"\"),\"\",AF3)","v":"2009-04-30"},{"$f":"IF(OR(MONTH(AG3)-MONTH(AF3)=1,AF4=\"\"),\"\",AG3)","v":""},"遲到","早退","曠工","病假","事假","公假","喪假\n產假","不可抗力\n颱風\n水災"]
[null,null,{"$f":"WEEKDAY(C3,2)","v":3},4,5,6,7,1,2,3,4,5,6,7,1,2,3,4,5,6,7,1,2,3,4,5,6,7,1,2,{"$f":"IF(OR(MONTH(AE3)-MONTH(AD3)=1,AD4=\"\"),\"\",WEEKDAY(AE3,2))","v":3},{"$f":"IF(OR(MONTH(AF3)-MONTH(AE3)=1,AE4=\"\"),\"\",WEEKDAY(AF3,2))","v":4},{"$f":"IF(OR(MONTH(AG3)-MONTH(AF3)=1,AF4=\"\"),\"\",WEEKDAY(AG3,2))","v":""}]
[null,"員工1",{"$f":"IF(OR(C$5=6,C$5=7),\"●\",\"\")","v":""},{"$f":"IF(OR(D$5=6,D$5=7),\"●\",\"\")","v":""},"","●","●","","","","","","●","●","","","","","","●","●","","","","","","●","●","","","","","",{"$f":"COUNTIF($C6:$AG6,\"遲到\")","v":0},{"$f":"COUNTIF($C6:$AG6,\"早退\")","v":0},{"$f":"COUNTIF($C6:$AG6,\"曠工\")","v":0},{"$f":"COUNTIF($C6:$AG6,\"病假\")","v":0},{"$f":"COUNTIF($C6:$AG6,\"事假\")","v":0},{"$f":"COUNTIF($C6:$AG6,\"公假\")","v":0},{"$f":"COUNTIF($C6:$AG6,\"喪、產假\")","v":0},{"$f":"COUNTIF($C6:$AG6,\"不可抗力\")","v":0}]
[null,null,"","","","●","●","","","","","","●","●","","","","","","●","●","","","","","","●","●","","","","","",{"$f":"COUNTIF($C7:$AG7,\"遲到\")","v":0},{"$f":"COUNTIF($C7:$AG7,\"早退\")","v":0},{"$f":"COUNTIF($C7:$AG7,\"曠工\")","v":0},{"$f":"COUNTIF($C7:$AG7,\"病假\")","v":0},{"$f":"COUNTIF($C7:$AG7,\"事假\")","v":0},{"$f":"COUNTIF($C7:$AG7,\"公假\")","v":0},{"$f":"COUNTIF($C7:$AG7,\"喪、產假\")","v":0},{"$f":"COUNTIF($C7:$AG7,\"不可抗力\")","v":0}]
[null,null,"","","","●","●","","","","","","●","●","","","","","","●","●","","","","","","●","●","","","","","",0,0,0,0,0,0,0,0]
[null,null,"","","","●","●","","","","","","●","●","","","","","","●","●","","","","","","●","●","","","","","",0,0,0,0,0,0,0,0]
[null,null,"","","","●","●","","","","","","●","●","","","","","","●","●","","","","","","●","●","","","","","",0,0,0,0,0,0,0,0]
[null,null,"","","","●","●","","","","","","●","●","","","","","","●","●","","","","","","●","●","","","","","",0,0,0,0,0,0,0,0]
[null,null,"","","","●","●","","","","","","●","●","","","","","","●","●","","","","","","●","●","","","","","",0,0,0,0,0,0,0,0]
[null,null,"","","","●","●","","","","","","●","●","","","","",{"$f":"IF(OR(S$5=6,S$5=7),\"●\",\"\")","v":""},"●","●","","","","","","●","●","","","","","",0,0,0,0,0,0,0,0]
[null,null,"",{"$f":"IF(OR(D$5=6,D$5=7),\"●\",\"\")","v":""},"","●","●","","","","","","●","●","","","","","","●","●","","","","","","●","●","","","","","",0,0,0,0,0,0,0,0]
[null,null,"","","","●","●","","","","","","●","●","","","","","","●","●","","","","","","●","●","","","","","",0,0,0,0,0,0,0,0]
[null,null,"","","","●","●","","","","","","●","●","","","","","","●","●","","","","","","●","●","","","","","",0,0,0,0,0,0,0,0]
[null,null,"","","","●","●","","","","","","●","●","","","","","","●","●","","","","","","●","●","","","","","",0,0,0,0,0,0,0,0]
[null,null,"","","","●","●","","","","","","●","●","","","","","","●","●","","","","","","●","●","","","","","",0,0,0,0,0,0,0,0]
[null,null,"","","","●","●","","","","","","●","●","","","","","","●","●","","","","","","●","●","","","","","",0,0,0,0,0,0,0,0]
[null,null,"","","","●","●","","","","","","●","●","","","","","","●","●","","","","","","●","●","","","","","",0,0,0,0,0,0,0,0]
[null,null,"","","","●","●","","","","","","●","●","","","","","","●","●","","","","","","●","●","","","","","",0,0,0,0,0,0,0,0]
[null,null,"","","","●","●","","","","","","●","●","","","","",{"$f":"IF(OR(S$5=6,S$5=7),\"●\",\"\")","v":""},"●","●","","","","","","●","●","","","","","",0,0,0,0,0,0,0,0]
[null,null,"",{"$f":"IF(OR(D$5=6,D$5=7),\"●\",\"\")","v":""},"","●","●","","","","","","●","●","","","","","","●","●","","","","","","●","●","","","","","",0,0,0,0,0,0,0,0]
[null,null,"","","","●","●","","","","","","●","●","","","","","","●","●","","","","","","●","●","","","","","",0,0,0,0,0,0,0,0]
[null,null,"","","","●","●","","","","","","●","●","","","","","","●","●","","","","","","●","●","","","","","",0,0,0,0,0,0,0,0]
[null,null,"","","","●","●","","","","","","●","●","","","","","","●","●","","","","","","●","●","","","","","",0,0,0,0,0,0,0,0]
[null,null,"","","","●","●","","","","","","●","●","","","","","","●","●","","","","","","●","●","","","","","",0,0,0,0,0,0,0,0]
[null,null,"","","","●","●","","","","","","●","●","","","","","","●","●","","","","","","●","●","","","","","",0,0,0,0,0,0,0,0]
[null,null,"","","","●","●","","","","","","●","●","","","","","","●","●","","","","","","●","●","","","","","",0,0,0,0,0,0,0,0]
[null,null,"","","","●","●","","","","","","●","●","","","","","","●","●","","","","","","●","●","","","","","",0,0,0,0,0,0,0,0]
[null,null,"","","","●","●","","","","","","●","●","","","","",{"$f":"IF(OR(S$5=6,S$5=7),\"●\",\"\")","v":""},"●","●","","","","","","●","●","","","","","",0,0,0,0,0,0,0,0]
[null,null,"",{"$f":"IF(OR(D$5=6,D$5=7),\"●\",\"\")","v":""},"","●","●","","","","","","●","●","","","","","","●","●","","","","","","●","●","","","","","",0,0,0,0,0,0,0,0]
[null,null,"","","","●","●","","","","","","●","●","","","","","","●","●","","","","","","●","●","","","","","",0,0,0,0,0,0,0,0]
[null,null,"","","","●","●","","","","","","●","●","","","","","","●","●","","","","","","●","●","","","","","",0,0,0,0,0,0,0,0]
[null,null,"","","","●","●","","","","","","●","●","","","","","","●","●","","","","","","●","●","","","","","",0,0,0,0,0,0,0,0]
[null,null,"","","","●","●","","","","","","●","●","","","","","","●","●","","","","","","●","●","","","","","",0,0,0,0,0,0,0,0]
[null,null,"","","","●","●","","","","","","●","●","","","","","","●","●","","","","","","●","●","","","","","",0,0,0,0,0,0,0,0]
[null,null,"","","","●","●","","","","","","●","●","","","","","","●","●","","","","","","●","●","","","","","",0,0,0,0,0,0,0,0]
[null,null,"","","","●","●","","","","","","●","●","","","","","","●","●","","","","","","●","●","","","","","",0,0,0,0,0,0,0,0]
[null,null,"","","","●","●","","","","","","●","●","","","","",{"$f":"IF(OR(S$5=6,S$5=7),\"●\",\"\")","v":""},"●","●","","","","","","●","●","","","","","",0,0,0,0,0,0,0,0]
[{"$nulls":27},"總計",{"$nulls":5},{"$f":"SUM(AH6:AH40)","v":0},{"$f":"SUM(AI6:AI40)","v":0},0,0,0,0,0,0]

{"sheet":"圖表","index":1,"n_rows":4,"n_cols":9,"rows_kept":4,"merged":[[0,0,0,3],[0,4,0,5]]}
["請選擇想要瀏覽的員工姓名",{"$nulls":3},"員工1"]
[]
[null,"遲到","早退","曠工","病假","事假","公假","喪假\n產假","不可抗力\n颱風\n水災"]
[null,{"$f":"VLOOKUP($E$1,data,33,)","v":0},{"$f":"VLOOKUP($E$1,data,34,)","v":0},{"$f":"VLOOKUP($E$1,data,35,)","v":0},{"$f":"VLOOKUP($E$1,data,36,)","v":0},{"$f":"VLOOKUP($E$1,data,37,)","v":0},{"$f":"VLOOKUP($E$1,data,38,)","v":0},{"$f":"VLOOKUP($E$1,data,39,)","v":0},{"$f":"VLOOKUP($E$1,data,40,)","v":0}]