{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["目标数据","源数据"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"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":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["工号","姓名","门店编号","门店名称","人员类型","班次","房态","日期","数量"]
["JJPY001","薪资1",null,null,"客房服务员","早班","退房","2021-08-01",1]
["JJPY001","薪资1",null,null,"客房服务员","早班","续住","2021-08-01",10]
["JJPY001","薪资1",null,null,"客房服务员","早班","大清房","2021-08-01",25]
["JJPY001","薪资1",null,null,"客房服务员","早班","退房","2021-08-01",20]
["JJPY001","薪资1",null,null,"客房服务员","早班","续住","2021-08-01",1]
["JJPY001","薪资1",null,null,"客房服务员","早班","大清房","2021-08-01",10]

{"sheet":"源数据","index":1,"n_rows":11,"n_cols":38,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,1,0],[2,0,10,0],[0,1,1,1],[2,1,10,1],[0,2,1,2],[2,2,10,2],[0,6,1,6],[0,3,1,3],[2,3,10,3],[0,4,1,4],[2,4,10,4],[0,5,1,5],[2,5,4,5],[5,5,7,5],[8,5,10,5]]}
["     工号","姓名","门店编号","门店名称","人员类型","班次","房态","2021-08-01","2021-08-02","2021-08-03","2021-08-04","2021-08-05","2021-08-06","2021-08-07","2021-08-08","2021-08-09","2021-08-10","2021-08-11","2021-08-12","2021-08-13","2021-08-14","2021-08-15","2021-08-16","2021-08-17","2021-08-18","2021-08-19","2021-08-20","2021-08-21","2021-08-22","2021-08-23","2021-08-24","2021-08-25","2021-08-26","2021-08-27","2021-08-28","2021-08-29","2021-08-30","2021-08-31"]
[null,null,null,null,null,null,null,{"$f":"IF(WEEKDAY(H$1)=1,\"周日\",IF(WEEKDAY(H$1)=2,\"周一\",IF(WEEKDAY(H$1)=3,\"周二\",IF(WEEKDAY(H$1)=4,\"周三\",IF(WEEKDAY(H$1)=5,\"周四\",IF(WEEKDAY(H$1)=6,\"周五\",IF(WEEKDAY(H$1)=7,\"周六\",下月)))))))","v":"周日"},{"$f":"IF(WEEKDAY(I$1)=1,\"周日\",IF(WEEKDAY(I$1)=2,\"周一\",IF(WEEKDAY(I$1)=3,\"周二\",IF(WEEKDAY(I$1)=4,\"周三\",IF(WEEKDAY(I$1)=5,\"周四\",IF(WEEKDAY(I$1)=6,\"周五\",IF(WEEKDAY(I$1)=7,\"周六\",下月)))))))","v":"周一"},{"$f":"IF(WEEKDAY(J$1)=1,\"周日\",IF(WEEKDAY(J$1)=2,\"周一\",IF(WEEKDAY(J$1)=3,\"周二\",IF(WEEKDAY(J$1)=4,\"周三\",IF(WEEKDAY(J$1)=5,\"周四\",IF(WEEKDAY(J$1)=6,\"周五\",IF(WEEKDAY(J$1)=7,\"周六\",下月)))))))","v":"周二"},{"$f":"IF(WEEKDAY(K$1)=1,\"周日\",IF(WEEKDAY(K$1)=2,\"周一\",IF(WEEKDAY(K$1)=3,\"周二\",IF(WEEKDAY(K$1)=4,\"周三\",IF(WEEKDAY(K$1)=5,\"周四\",IF(WEEKDAY(K$1)=6,\"周五\",IF(WEEKDAY(K$1)=7,\"周六\",下月)))))))","v":"周三"},{"$f":"IF(WEEKDAY(L$1)=1,\"周日\",IF(WEEKDAY(L$1)=2,\"周一\",IF(WEEKDAY(L$1)=3,\"周二\",IF(WEEKDAY(L$1)=4,\"周三\",IF(WEEKDAY(L$1)=5,\"周四\",IF(WEEKDAY(L$1)=6,\"周五\",IF(WEEKDAY(L$1)=7,\"周六\",下月)))))))","v":"周四"},{"$f":"IF(WEEKDAY(M$1)=1,\"周日\",IF(WEEKDAY(M$1)=2,\"周一\",IF(WEEKDAY(M$1)=3,\"周二\",IF(WEEKDAY(M$1)=4,\"周三\",IF(WEEKDAY(M$1)=5,\"周四\",IF(WEEKDAY(M$1)=6,\"周五\",IF(WEEKDAY(M$1)=7,\"周六\",下月)))))))","v":"周五"},{"$f":"IF(WEEKDAY(N$1)=1,\"周日\",IF(WEEKDAY(N$1)=2,\"周一\",IF(WEEKDAY(N$1)=3,\"周二\",IF(WEEKDAY(N$1)=4,\"周三\",IF(WEEKDAY(N$1)=5,\"周四\",IF(WEEKDAY(N$1)=6,\"周五\",IF(WEEKDAY(N$1)=7,\"周六\",下月)))))))","v":"周六"},{"$f":"IF(WEEKDAY(O$1)=1,\"周日\",IF(WEEKDAY(O$1)=2,\"周一\",IF(WEEKDAY(O$1)=3,\"周二\",IF(WEEKDAY(O$1)=4,\"周三\",IF(WEEKDAY(O$1)=5,\"周四\",IF(WEEKDAY(O$1)=6,\"周五\",IF(WEEKDAY(O$1)=7,\"周六\",下月)))))))","v":"周日"},{"$f":"IF(WEEKDAY(P$1)=1,\"周日\",IF(WEEKDAY(P$1)=2,\"周一\",IF(WEEKDAY(P$1)=3,\"周二\",IF(WEEKDAY(P$1)=4,\"周三\",IF(WEEKDAY(P$1)=5,\"周四\",IF(WEEKDAY(P$1)=6,\"周五\",IF(WEEKDAY(P$1)=7,\"周六\",下月)))))))","v":"周一"},{"$f":"IF(WEEKDAY(Q$1)=1,\"周日\",IF(WEEKDAY(Q$1)=2,\"周一\",IF(WEEKDAY(Q$1)=3,\"周二\",IF(WEEKDAY(Q$1)=4,\"周三\",IF(WEEKDAY(Q$1)=5,\"周四\",IF(WEEKDAY(Q$1)=6,\"周五\",IF(WEEKDAY(Q$1)=7,\"周六\",下月)))))))","v":"周二"},{"$f":"IF(WEEKDAY(R$1)=1,\"周日\",IF(WEEKDAY(R$1)=2,\"周一\",IF(WEEKDAY(R$1)=3,\"周二\",IF(WEEKDAY(R$1)=4,\"周三\",IF(WEEKDAY(R$1)=5,\"周四\",IF(WEEKDAY(R$1)=6,\"周五\",IF(WEEKDAY(R$1)=7,\"周六\",下月)))))))","v":"周三"},{"$f":"IF(WEEKDAY(S$1)=1,\"周日\",IF(WEEKDAY(S$1)=2,\"周一\",IF(WEEKDAY(S$1)=3,\"周二\",IF(WEEKDAY(S$1)=4,\"周三\",IF(WEEKDAY(S$1)=5,\"周四\",IF(WEEKDAY(S$1)=6,\"周五\",IF(WEEKDAY(S$1)=7,\"周六\",下月)))))))","v":"周四"},{"$f":"IF(WEEKDAY(T$1)=1,\"周日\",IF(WEEKDAY(T$1)=2,\"周一\",IF(WEEKDAY(T$1)=3,\"周二\",IF(WEEKDAY(T$1)=4,\"周三\",IF(WEEKDAY(T$1)=5,\"周四\",IF(WEEKDAY(T$1)=6,\"周五\",IF(WEEKDAY(T$1)=7,\"周六\",下月)))))))","v":"周五"},{"$f":"IF(WEEKDAY(U$1)=1,\"周日\",IF(WEEKDAY(U$1)=2,\"周一\",IF(WEEKDAY(U$1)=3,\"周二\",IF(WEEKDAY(U$1)=4,\"周三\",IF(WEEKDAY(U$1)=5,\"周四\",IF(WEEKDAY(U$1)=6,\"周五\",IF(WEEKDAY(U$1)=7,\"周六\",下月)))))))","v":"周六"},{"$f":"IF(WEEKDAY(V$1)=1,\"周日\",IF(WEEKDAY(V$1)=2,\"周一\",IF(WEEKDAY(V$1)=3,\"周二\",IF(WEEKDAY(V$1)=4,\"周三\",IF(WEEKDAY(V$1)=5,\"周四\",IF(WEEKDAY(V$1)=6,\"周五\",IF(WEEKDAY(V$1)=7,\"周六\",下月)))))))","v":"周日"},{"$f":"IF(WEEKDAY(W$1)=1,\"周日\",IF(WEEKDAY(W$1)=2,\"周一\",IF(WEEKDAY(W$1)=3,\"周二\",IF(WEEKDAY(W$1)=4,\"周三\",IF(WEEKDAY(W$1)=5,\"周四\",IF(WEEKDAY(W$1)=6,\"周五\",IF(WEEKDAY(W$1)=7,\"周六\",下月)))))))","v":"周一"},{"$f":"IF(WEEKDAY(X$1)=1,\"周日\",IF(WEEKDAY(X$1)=2,\"周一\",IF(WEEKDAY(X$1)=3,\"周二\",IF(WEEKDAY(X$1)=4,\"周三\",IF(WEEKDAY(X$1)=5,\"周四\",IF(WEEKDAY(X$1)=6,\"周五\",IF(WEEKDAY(X$1)=7,\"周六\",下月)))))))","v":"周二"},{"$f":"IF(WEEKDAY(Y$1)=1,\"周日\",IF(WEEKDAY(Y$1)=2,\"周一\",IF(WEEKDAY(Y$1)=3,\"周二\",IF(WEEKDAY(Y$1)=4,\"周三\",IF(WEEKDAY(Y$1)=5,\"周四\",IF(WEEKDAY(Y$1)=6,\"周五\",IF(WEEKDAY(Y$1)=7,\"周六\",下月)))))))","v":"周三"},{"$f":"IF(WEEKDAY(Z$1)=1,\"周日\",IF(WEEKDAY(Z$1)=2,\"周一\",IF(WEEKDAY(Z$1)=3,\"周二\",IF(WEEKDAY(Z$1)=4,\"周三\",IF(WEEKDAY(Z$1)=5,\"周四\",IF(WEEKDAY(Z$1)=6,\"周五\",IF(WEEKDAY(Z$1)=7,\"周六\",下月)))))))","v":"周四"},{"$f":"IF(WEEKDAY(AA$1)=1,\"周日\",IF(WEEKDAY(AA$1)=2,\"周一\",IF(WEEKDAY(AA$1)=3,\"周二\",IF(WEEKDAY(AA$1)=4,\"周三\",IF(WEEKDAY(AA$1)=5,\"周四\",IF(WEEKDAY(AA$1)=6,\"周五\",IF(WEEKDAY(AA$1)=7,\"周六\",下月)))))))","v":"周五"},{"$f":"IF(WEEKDAY(AB$1)=1,\"周日\",IF(WEEKDAY(AB$1)=2,\"周一\",IF(WEEKDAY(AB$1)=3,\"周二\",IF(WEEKDAY(AB$1)=4,\"周三\",IF(WEEKDAY(AB$1)=5,\"周四\",IF(WEEKDAY(AB$1)=6,\"周五\",IF(WEEKDAY(AB$1)=7,\"周六\",下月)))))))","v":"周六"},{"$f":"IF(WEEKDAY(AC$1)=1,\"周日\",IF(WEEKDAY(AC$1)=2,\"周一\",IF(WEEKDAY(AC$1)=3,\"周二\",IF(WEEKDAY(AC$1)=4,\"周三\",IF(WEEKDAY(AC$1)=5,\"周四\",IF(WEEKDAY(AC$1)=6,\"周五\",IF(WEEKDAY(AC$1)=7,\"周六\",下月)))))))","v":"周日"},{"$f":"IF(WEEKDAY(AD$1)=1,\"周日\",IF(WEEKDAY(AD$1)=2,\"周一\",IF(WEEKDAY(AD$1)=3,\"周二\",IF(WEEKDAY(AD$1)=4,\"周三\",IF(WEEKDAY(AD$1)=5,\"周四\",IF(WEEKDAY(AD$1)=6,\"周五\",IF(WEEKDAY(AD$1)=7,\"周六\",下月)))))))","v":"周一"},{"$f":"IF(WEEKDAY(AE$1)=1,\"周日\",IF(WEEKDAY(AE$1)=2,\"周一\",IF(WEEKDAY(AE$1)=3,\"周二\",IF(WEEKDAY(AE$1)=4,\"周三\",IF(WEEKDAY(AE$1)=5,\"周四\",IF(WEEKDAY(AE$1)=6,\"周五\",IF(WEEKDAY(AE$1)=7,\"周六\",下月)))))))","v":"周二"},{"$f":"IF(WEEKDAY(AF$1)=1,\"周日\",IF(WEEKDAY(AF$1)=2,\"周一\",IF(WEEKDAY(AF$1)=3,\"周二\",IF(WEEKDAY(AF$1)=4,\"周三\",IF(WEEKDAY(AF$1)=5,\"周四\",IF(WEEKDAY(AF$1)=6,\"周五\",IF(WEEKDAY(AF$1)=7,\"周六\",下月)))))))","v":"周三"},{"$f":"IF(WEEKDAY(AG$1)=1,\"周日\",IF(WEEKDAY(AG$1)=2,\"周一\",IF(WEEKDAY(AG$1)=3,\"周二\",IF(WEEKDAY(AG$1)=4,\"周三\",IF(WEEKDAY(AG$1)=5,\"周四\",IF(WEEKDAY(AG$1)=6,\"周五\",IF(WEEKDAY(AG$1)=7,\"周六\",下月)))))))","v":"周四"},{"$f":"IF(WEEKDAY(AH$1)=1,\"周日\",IF(WEEKDAY(AH$1)=2,\"周一\",IF(WEEKDAY(AH$1)=3,\"周二\",IF(WEEKDAY(AH$1)=4,\"周三\",IF(WEEKDAY(AH$1)=5,\"周四\",IF(WEEKDAY(AH$1)=6,\"周五\",IF(WEEKDAY(AH$1)=7,\"周六\",下月)))))))","v":"周五"},{"$f":"IF(WEEKDAY(AI$1)=1,\"周日\",IF(WEEKDAY(AI$1)=2,\"周一\",IF(WEEKDAY(AI$1)=3,\"周二\",IF(WEEKDAY(AI$1)=4,\"周三\",IF(WEEKDAY(AI$1)=5,\"周四\",IF(WEEKDAY(AI$1)=6,\"周五\",IF(WEEKDAY(AI$1)=7,\"周六\",下月)))))))","v":"周六"},{"$f":"IF(WEEKDAY(AJ$1)=1,\"周日\",IF(WEEKDAY(AJ$1)=2,\"周一\",IF(WEEKDAY(AJ$1)=3,\"周二\",IF(WEEKDAY(AJ$1)=4,\"周三\",IF(WEEKDAY(AJ$1)=5,\"周四\",IF(WEEKDAY(AJ$1)=6,\"周五\",IF(WEEKDAY(AJ$1)=7,\"周六\",下月)))))))","v":"周日"},{"$f":"IF(WEEKDAY(AK$1)=1,\"周日\",IF(WEEKDAY(AK$1)=2,\"周一\",IF(WEEKDAY(AK$1)=3,\"周二\",IF(WEEKDAY(AK$1)=4,\"周三\",IF(WEEKDAY(AK$1)=5,\"周四\",IF(WEEKDAY(AK$1)=6,\"周五\",IF(WEEKDAY(AK$1)=7,\"周六\",下月)))))))","v":"周一"},{"$f":"IF(WEEKDAY(AL$1)=1,\"周日\",IF(WEEKDAY(AL$1)=2,\"周一\",IF(WEEKDAY(AL$1)=3,\"周二\",IF(WEEKDAY(AL$1)=4,\"周三\",IF(WEEKDAY(AL$1)=5,\"周四\",IF(WEEKDAY(AL$1)=6,\"周五\",IF(WEEKDAY(AL$1)=7,\"周六\",下月)))))))","v":"周二"}]
["JJ00019283","丁德英","010097","7天酒店·北京南站草桥交通枢纽店","客房服务员","早班","退房",null,15,32,null,30,null,20,null,null,31,null,25,null,21,null,23,null,22,26,null,23,null,24,25,null,28,null,null,null,25]
[null,null,null,null,null,null,"续住",null,10,23,null,15,null,20,null,null,8,null,7,null,8,null,5,null,12,9,null,16,null,8,12,null,10,null,null,null,13]
[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,"晚班\n","退房"]
[null,null,null,null,null,null,"续住"]
[null,null,null,null,null,null,"大清房"]