{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Sheet1","Sheet2","Sheet3","Sheet4"],"not_rendered":{"macros":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":131,"n_cols":4,"rows_kept":131}
["Date","Supervisor","EMP Name","Sales"]
["2018-01-01","Supervisor-1","EMP-1",94]
[{"$f":"A2","v":"2018-01-01"},{"$f":"B2","v":"Supervisor-1"},"EMP-2",70]
[{"$f":"A3","v":"2018-01-01"},{"$f":"B3","v":"Supervisor-1"},"EMP-3",60]
["2018-01-01","Supervisor-1","EMP-4",60]
["2018-01-01","Supervisor-1","EMP-5",97]
["2018-01-01","Supervisor-2","EMP-10",60]
["2018-01-01",{"$f":"B7","v":"Supervisor-2"},"EMP-6",75]
["2018-01-01","Supervisor-2","EMP-7",62]
["2018-01-01","Supervisor-2","EMP-8",96]
["2018-01-01","Supervisor-2","EMP-9",100]
["2018-01-02","Supervisor-1","EMP-1",85]
[{"$f":"A12","v":"2018-01-02"},{"$f":"B12","v":"Supervisor-1"},"EMP-2",90]
["2018-01-02","Supervisor-1","EMP-3",73]
["2018-01-02","Supervisor-1","EMP-4",72]
["2018-01-02","Supervisor-1","EMP-5",94]
["2018-01-02","Supervisor-2","EMP-10",88]
["2018-01-02",{"$f":"B17","v":"Supervisor-2"},"EMP-6",70]
["2018-01-02","Supervisor-2","EMP-7",78]
["2018-01-02","Supervisor-2","EMP-8",91]
["2018-01-02","Supervisor-2","EMP-9",64]
["2018-01-03","Supervisor-1","EMP-1",82]
[{"$f":"A22","v":"2018-01-03"},{"$f":"B22","v":"Supervisor-1"},"EMP-2",70]
["2018-01-03","Supervisor-1","EMP-3",75]
["2018-01-03","Supervisor-1","EMP-4",80]
["2018-01-03","Supervisor-1","EMP-5",87]
["2018-01-03","Supervisor-2","EMP-10",91]
["2018-01-03",{"$f":"B27","v":"Supervisor-2"},"EMP-6",66]
["2018-01-03","Supervisor-2","EMP-7",99]
["2018-01-03","Supervisor-2","EMP-8",82]
["2018-01-03","Supervisor-2","EMP-9",90]
["2018-01-04","Supervisor-1","EMP-1",86]
[{"$f":"A32","v":"2018-01-04"},{"$f":"B32","v":"Supervisor-1"},"EMP-2",71]
["2018-01-04","Supervisor-1","EMP-3",63]
["2018-01-04","Supervisor-1","EMP-4",72]
["2018-01-04","Supervisor-1","EMP-5",79]
["2018-01-04","Supervisor-2","EMP-10",78]
["2018-01-04",{"$f":"B37","v":"Supervisor-2"},"EMP-6",95]
["2018-01-04","Supervisor-2","EMP-7",86]
["2018-01-04","Supervisor-2","EMP-8",78]
["2018-01-04","Supervisor-2","EMP-9",75]
["2018-01-05","Supervisor-1","EMP-1",76]
[{"$f":"A42","v":"2018-01-05"},{"$f":"B42","v":"Supervisor-1"},"EMP-2",87]
["2018-01-05","Supervisor-1","EMP-3",93]
["2018-01-05","Supervisor-1","EMP-4",81]
["2018-01-05","Supervisor-1","EMP-5",79]
["2018-01-05","Supervisor-2","EMP-10",98]
["2018-01-05",{"$f":"B47","v":"Supervisor-2"},"EMP-6",95]
["2018-01-05","Supervisor-2","EMP-7",62]
["2018-01-05","Supervisor-2","EMP-8",72]
["2018-01-05","Supervisor-2","EMP-9",70]
["2018-01-06","Supervisor-1","EMP-1",95]
[{"$f":"A52","v":"2018-01-06"},{"$f":"B52","v":"Supervisor-1"},"EMP-2",70]
["2018-01-06","Supervisor-1","EMP-3",93]
["2018-01-06","Supervisor-1","EMP-4",100]
["2018-01-06","Supervisor-1","EMP-5",93]
["2018-01-06","Supervisor-2","EMP-10",97]
["2018-01-06",{"$f":"B57","v":"Supervisor-2"},"EMP-6",88]
["2018-01-06","Supervisor-2","EMP-7",92]
["2018-01-06","Supervisor-2","EMP-8",62]
["2018-01-06","Supervisor-2","EMP-9",92]
["2018-01-07","Supervisor-1","EMP-1",64]
[{"$f":"A62","v":"2018-01-07"},{"$f":"B62","v":"Supervisor-1"},"EMP-2",90]
["2018-01-07","Supervisor-1","EMP-3",86]
["2018-01-07","Supervisor-1","EMP-4",79]
["2018-01-07","Supervisor-1","EMP-5",61]
["2018-01-07","Supervisor-2","EMP-10",76]
["2018-01-07",{"$f":"B67","v":"Supervisor-2"},"EMP-6",61]
["2018-01-07","Supervisor-2","EMP-7",64]
["2018-01-07","Supervisor-2","EMP-8",69]
["2018-01-07","Supervisor-2","EMP-9",61]
["2018-01-08","Supervisor-1","EMP-1",93]
[{"$f":"A72","v":"2018-01-08"},{"$f":"B72","v":"Supervisor-1"},"EMP-2",68]
["2018-01-08","Supervisor-1","EMP-3",60]
["2018-01-08","Supervisor-1","EMP-4",62]
["2018-01-08","Supervisor-1","EMP-5",82]
["2018-01-08","Supervisor-2","EMP-10",60]
["2018-01-08",{"$f":"B77","v":"Supervisor-2"},"EMP-6",83]
["2018-01-08","Supervisor-2","EMP-7",85]
["2018-01-08","Supervisor-2","EMP-8",70]
["2018-01-08","Supervisor-2","EMP-9",64]
["2018-01-09","Supervisor-1","EMP-1",85]
[{"$f":"A82","v":"2018-01-09"},{"$f":"B82","v":"Supervisor-1"},"EMP-2",86]
["2018-01-09","Supervisor-1","EMP-3",71]
["2018-01-09","Supervisor-1","EMP-4",70]
["2018-01-09","Supervisor-1","EMP-5",99]
["2018-01-09","Supervisor-2","EMP-10",81]
["2018-01-09",{"$f":"B87","v":"Supervisor-2"},"EMP-6",86]
["2018-01-09","Supervisor-2","EMP-7",93]
["2018-01-09","Supervisor-2","EMP-8",65]
["2018-01-09","Supervisor-2","EMP-9",78]
["2018-01-10","Supervisor-1","EMP-1",96]
[{"$f":"A92","v":"2018-01-10"},{"$f":"B92","v":"Supervisor-1"},"EMP-2",74]
["2018-01-10","Supervisor-1","EMP-3",77]
["2018-01-10","Supervisor-1","EMP-4",99]
["2018-01-10","Supervisor-1","EMP-5",74]
["2018-01-10","Supervisor-2","EMP-10",94]
["2018-01-10",{"$f":"B97","v":"Supervisor-2"},"EMP-6",99]
["2018-01-10","Supervisor-2","EMP-7",82]
["2018-01-10","Supervisor-2","EMP-8",84]
["2018-01-10","Supervisor-2","EMP-9",97]
["2018-01-11","Supervisor-1","EMP-1",93]
[{"$f":"A102","v":"2018-01-11"},{"$f":"B102","v":"Supervisor-1"},"EMP-2",74]
["2018-01-11","Supervisor-1","EMP-3",67]
["2018-01-11","Supervisor-1","EMP-4",83]
["2018-01-11","Supervisor-1","EMP-5",81]
["2018-01-11","Supervisor-2","EMP-10",84]
["2018-01-11",{"$f":"B107","v":"Supervisor-2"},"EMP-6",77]
["2018-01-11","Supervisor-2","EMP-7",76]
["2018-01-11","Supervisor-2","EMP-8",71]
["2018-01-11","Supervisor-2","EMP-9",94]
["2018-01-12","Supervisor-1","EMP-1",71]
[{"$f":"A112","v":"2018-01-12"},{"$f":"B112","v":"Supervisor-1"},"EMP-2",92]
["2018-01-12","Supervisor-1","EMP-3",71]
["2018-01-12","Supervisor-1","EMP-4",100]
["2018-01-12","Supervisor-1","EMP-5",68]
["2018-01-12","Supervisor-2","EMP-10",71]
["2018-01-12",{"$f":"B117","v":"Supervisor-2"},"EMP-6",100]
["2018-01-12","Supervisor-2","EMP-7",81]
["2018-01-12","Supervisor-2","EMP-8",90]
["2018-01-12","Supervisor-2","EMP-9",82]
["2018-01-13","Supervisor-1","EMP-1",85]
[{"$f":"A122","v":"2018-01-13"},{"$f":"B122","v":"Supervisor-1"},"EMP-2",94]
["2018-01-13","Supervisor-1","EMP-3",99]
["2018-01-13","Supervisor-1","EMP-4",65]
["2018-01-13","Supervisor-1","EMP-5",64]
["2018-01-13","Supervisor-2","EMP-10",92]
["2018-01-13",{"$f":"B127","v":"Supervisor-2"},"EMP-6",90]
["2018-01-13","Supervisor-2","EMP-7",63]
["2018-01-13","Supervisor-2","EMP-8",86]
["2018-01-13","Supervisor-2","EMP-9",88]

{"sheet":"Sheet2","index":1,"n_rows":131,"n_cols":4,"rows_kept":131}
["Date","Supervisor","EMP Name","Sales"]
["2018-01-01","Supervisor-1","EMP-1",94]
[{"$f":"A2","v":"2018-01-01"},{"$f":"B2","v":"Supervisor-1"},"EMP-2",70]
["2018-01-01","Supervisor-1","EMP-3",60]
["2018-01-01","Supervisor-1","EMP-4",60]
["2018-01-01","Supervisor-1","EMP-5",97]
["2018-01-01","Supervisor-2","EMP-10",60]
[{"$f":"A7","v":"2018-01-01"},"Supervisor-2","EMP-6",75]
["2018-01-01","Supervisor-2","EMP-7",62]
["2018-01-01","Supervisor-2","EMP-8",96]
["2018-01-01","Supervisor-2","EMP-9",100]
["2018-01-02","Supervisor-1","EMP-1",85]
[{"$f":"A12","v":"2018-01-02"},{"$f":"B12","v":"Supervisor-1"},"EMP-2",90]
["2018-01-02","Supervisor-1","EMP-3",73]
["2018-01-02","Supervisor-1","EMP-4",72]
["2018-01-02","Supervisor-1","EMP-5",94]
["2018-01-02","Supervisor-2","EMP-10",88]
[{"$f":"A17","v":"2018-01-02"},"Supervisor-2","EMP-6",70]
["2018-01-02","Supervisor-2","EMP-7",78]
["2018-01-02","Supervisor-2","EMP-8",91]
["2018-01-02","Supervisor-2","EMP-9",64]
["2018-01-03","Supervisor-1","EMP-1",82]
[{"$f":"A22","v":"2018-01-03"},{"$f":"B22","v":"Supervisor-1"},"EMP-2",70]
["2018-01-03","Supervisor-1","EMP-3",75]
["2018-01-03","Supervisor-1","EMP-4",80]
["2018-01-03","Supervisor-1","EMP-5",87]
["2018-01-03","Supervisor-2","EMP-10",91]
[{"$f":"A27","v":"2018-01-03"},"Supervisor-2","EMP-6",66]
["2018-01-03","Supervisor-2","EMP-7",99]
["2018-01-03","Supervisor-2","EMP-8",82]
["2018-01-03","Supervisor-2","EMP-9",90]
["2018-01-04","Supervisor-1","EMP-1",86]
[{"$f":"A32","v":"2018-01-04"},{"$f":"B32","v":"Supervisor-1"},"EMP-2",71]
["2018-01-04","Supervisor-1","EMP-3",63]
["2018-01-04","Supervisor-1","EMP-4",72]
["2018-01-04","Supervisor-1","EMP-5",79]
["2018-01-04","Supervisor-2","EMP-10",78]
[{"$f":"A37","v":"2018-01-04"},"Supervisor-2","EMP-6",95]
["2018-01-04","Supervisor-2","EMP-7",86]
["2018-01-04","Supervisor-2","EMP-8",78]
["2018-01-04","Supervisor-2","EMP-9",75]
["2018-01-05","Supervisor-1","EMP-1",76]
[{"$f":"A42","v":"2018-01-05"},{"$f":"B42","v":"Supervisor-1"},"EMP-2",87]
["2018-01-05","Supervisor-1","EMP-3",93]
["2018-01-05","Supervisor-1","EMP-4",81]
["2018-01-05","Supervisor-1","EMP-5",79]
["2018-01-05","Supervisor-2","EMP-10",98]
[{"$f":"A47","v":"2018-01-05"},"Supervisor-2","EMP-6",95]
["2018-01-05","Supervisor-2","EMP-7",62]
["2018-01-05","Supervisor-2","EMP-8",72]
["2018-01-05","Supervisor-2","EMP-9",70]
["2018-01-06","Supervisor-1","EMP-1",95]
[{"$f":"A52","v":"2018-01-06"},{"$f":"B52","v":"Supervisor-1"},"EMP-2",70]
["2018-01-06","Supervisor-1","EMP-3",93]
["2018-01-06","Supervisor-1","EMP-4",100]
["2018-01-06","Supervisor-1","EMP-5",93]
["2018-01-06","Supervisor-2","EMP-10",97]
[{"$f":"A57","v":"2018-01-06"},"Supervisor-2","EMP-6",88]
["2018-01-06","Supervisor-2","EMP-7",92]
["2018-01-06","Supervisor-2","EMP-8",62]
["2018-01-06","Supervisor-2","EMP-9",92]
["2018-01-07","Supervisor-1","EMP-1",64]
[{"$f":"A62","v":"2018-01-07"},{"$f":"B62","v":"Supervisor-1"},"EMP-2",90]
["2018-01-07","Supervisor-1","EMP-3",86]
["2018-01-07","Supervisor-1","EMP-4",79]
["2018-01-07","Supervisor-1","EMP-5",61]
["2018-01-07","Supervisor-2","EMP-10",76]
[{"$f":"A67","v":"2018-01-07"},"Supervisor-2","EMP-6",61]
["2018-01-07","Supervisor-2","EMP-7",64]
["2018-01-07","Supervisor-2","EMP-8",69]
["2018-01-07","Supervisor-2","EMP-9",61]
["2018-01-08","Supervisor-1","EMP-1",93]
[{"$f":"A72","v":"2018-01-08"},{"$f":"B72","v":"Supervisor-1"},"EMP-2",68]
["2018-01-08","Supervisor-1","EMP-3",60]
["2018-01-08","Supervisor-1","EMP-4",62]
["2018-01-08","Supervisor-1","EMP-5",82]
["2018-01-08","Supervisor-2","EMP-10",60]
[{"$f":"A77","v":"2018-01-08"},"Supervisor-2","EMP-6",83]
["2018-01-08","Supervisor-2","EMP-7",85]
["2018-01-08","Supervisor-2","EMP-8",70]
["2018-01-08","Supervisor-2","EMP-9",64]
["2018-01-09","Supervisor-1","EMP-1",85]
[{"$f":"A82","v":"2018-01-09"},{"$f":"B82","v":"Supervisor-1"},"EMP-2",86]
["2018-01-09","Supervisor-1","EMP-3",71]
["2018-01-09","Supervisor-1","EMP-4",70]
["2018-01-09","Supervisor-1","EMP-5",99]
["2018-01-09","Supervisor-2","EMP-10",81]
[{"$f":"A87","v":"2018-01-09"},"Supervisor-2","EMP-6",86]
["2018-01-09","Supervisor-2","EMP-7",93]
["2018-01-09","Supervisor-2","EMP-8",65]
["2018-01-09","Supervisor-2","EMP-9",78]
["2018-01-10","Supervisor-1","EMP-1",96]
[{"$f":"A92","v":"2018-01-10"},{"$f":"B92","v":"Supervisor-1"},"EMP-2",74]
["2018-01-10","Supervisor-1","EMP-3",77]
["2018-01-10","Supervisor-1","EMP-4",99]
["2018-01-10","Supervisor-1","EMP-5",74]
["2018-01-10","Supervisor-2","EMP-10",94]
[{"$f":"A97","v":"2018-01-10"},"Supervisor-2","EMP-6",99]
["2018-01-10","Supervisor-2","EMP-7",82]
["2018-01-10","Supervisor-2","EMP-8",84]
["2018-01-10","Supervisor-2","EMP-9",97]
["2018-01-11","Supervisor-1","EMP-1",93]
[{"$f":"A102","v":"2018-01-11"},{"$f":"B102","v":"Supervisor-1"},"EMP-2",74]
["2018-01-11","Supervisor-1","EMP-3",67]
["2018-01-11","Supervisor-1","EMP-4",83]
["2018-01-11","Supervisor-1","EMP-5",81]
["2018-01-11","Supervisor-2","EMP-10",84]
[{"$f":"A107","v":"2018-01-11"},"Supervisor-2","EMP-6",77]
["2018-01-11","Supervisor-2","EMP-7",76]
["2018-01-11","Supervisor-2","EMP-8",71]
["2018-01-11","Supervisor-2","EMP-9",94]
["2018-01-12","Supervisor-1","EMP-1",71]
[{"$f":"A112","v":"2018-01-12"},{"$f":"B112","v":"Supervisor-1"},"EMP-2",92]
["2018-01-12","Supervisor-1","EMP-3",71]
["2018-01-12","Supervisor-1","EMP-4",100]
["2018-01-12","Supervisor-1","EMP-5",68]
["2018-01-12","Supervisor-2","EMP-10",71]
[{"$f":"A117","v":"2018-01-12"},"Supervisor-2","EMP-6",100]
["2018-01-12","Supervisor-2","EMP-7",81]
["2018-01-12","Supervisor-2","EMP-8",90]
["2018-01-12","Supervisor-2","EMP-9",82]
["2018-01-13","Supervisor-1","EMP-1",85]
[{"$f":"A122","v":"2018-01-13"},{"$f":"B122","v":"Supervisor-1"},"EMP-2",94]
["2018-01-13","Supervisor-1","EMP-3",99]
["2018-01-13","Supervisor-1","EMP-4",65]
["2018-01-13","Supervisor-1","EMP-5",64]
["2018-01-13","Supervisor-2","EMP-10",92]
[{"$f":"A127","v":"2018-01-13"},"Supervisor-2","EMP-6",90]
["2018-01-13","Supervisor-2","EMP-7",63]
["2018-01-13","Supervisor-2","EMP-8",86]
["2018-01-13","Supervisor-2","EMP-9",88]

{"sheet":"Sheet3","index":2,"n_rows":131,"n_cols":6,"rows_kept":131}
["Date","Supervisor","EMP Name","Sales"]
["2018-01-01","Supervisor-1","EMP-1",94,{"$f":"IF(A2=\"\",E1,A2)","v":"2018-01-01"},{"$f":"IF(B2=\"\",F1,B2)","v":"Supervisor-1"}]
["2018-01-01","Supervisor-1","EMP-2",70,{"$f":"IF(A3=\"\",E2,A3)","v":"2018-01-01"},{"$f":"IF(B3=\"\",F2,B3)","v":"Supervisor-1"}]
["2018-01-01","Supervisor-1","EMP-3",60,"2018-01-01","Supervisor-1"]
["2018-01-01","Supervisor-1","EMP-4",60,"2018-01-01","Supervisor-1"]
["2018-01-01","Supervisor-1","EMP-5",97,"2018-01-01","Supervisor-1"]
["2018-01-01","Supervisor-2","EMP-10",60,"2018-01-01","Supervisor-2"]
["2018-01-01","Supervisor-2","EMP-6",75,"2018-01-01","Supervisor-2"]
["2018-01-01","Supervisor-2","EMP-7",62,"2018-01-01","Supervisor-2"]
["2018-01-01","Supervisor-2","EMP-8",96,"2018-01-01","Supervisor-2"]
["2018-01-01","Supervisor-2","EMP-9",100,"2018-01-01","Supervisor-2"]
["2018-01-02","Supervisor-1","EMP-1",85,"2018-01-02","Supervisor-1"]
["2018-01-02","Supervisor-1","EMP-2",90,"2018-01-02","Supervisor-1"]
["2018-01-02","Supervisor-1","EMP-3",73,"2018-01-02","Supervisor-1"]
["2018-01-02","Supervisor-1","EMP-4",72,"2018-01-02","Supervisor-1"]
["2018-01-02","Supervisor-1","EMP-5",94,"2018-01-02","Supervisor-1"]
["2018-01-02","Supervisor-2","EMP-10",88,"2018-01-02","Supervisor-2"]
["2018-01-02","Supervisor-2","EMP-6",70,"2018-01-02","Supervisor-2"]
["2018-01-02","Supervisor-2","EMP-7",78,"2018-01-02","Supervisor-2"]
["2018-01-02","Supervisor-2","EMP-8",91,"2018-01-02","Supervisor-2"]
["2018-01-02","Supervisor-2","EMP-9",64,"2018-01-02","Supervisor-2"]
["2018-01-03","Supervisor-1","EMP-1",82,"2018-01-03","Supervisor-1"]
["2018-01-03","Supervisor-1","EMP-2",70,"2018-01-03","Supervisor-1"]
["2018-01-03","Supervisor-1","EMP-3",75,"2018-01-03","Supervisor-1"]
["2018-01-03","Supervisor-1","EMP-4",80,"2018-01-03","Supervisor-1"]
["2018-01-03","Supervisor-1","EMP-5",87,"2018-01-03","Supervisor-1"]
["2018-01-03","Supervisor-2","EMP-10",91,"2018-01-03","Supervisor-2"]
["2018-01-03","Supervisor-2","EMP-6",66,"2018-01-03","Supervisor-2"]
["2018-01-03","Supervisor-2","EMP-7",99,"2018-01-03","Supervisor-2"]
["2018-01-03","Supervisor-2","EMP-8",82,"2018-01-03","Supervisor-2"]
["2018-01-03","Supervisor-2","EMP-9",90,"2018-01-03","Supervisor-2"]
["2018-01-04","Supervisor-1","EMP-1",86,"2018-01-04","Supervisor-1"]
["2018-01-04","Supervisor-1","EMP-2",71,"2018-01-04","Supervisor-1"]
["2018-01-04","Supervisor-1","EMP-3",63,"2018-01-04","Supervisor-1"]
["2018-01-04","Supervisor-1","EMP-4",72,"2018-01-04","Supervisor-1"]
["2018-01-04","Supervisor-1","EMP-5",79,"2018-01-04","Supervisor-1"]
["2018-01-04","Supervisor-2","EMP-10",78,"2018-01-04","Supervisor-2"]
["2018-01-04","Supervisor-2","EMP-6",95,"2018-01-04","Supervisor-2"]
["2018-01-04","Supervisor-2","EMP-7",86,"2018-01-04","Supervisor-2"]
["2018-01-04","Supervisor-2","EMP-8",78,"2018-01-04","Supervisor-2"]
["2018-01-04","Supervisor-2","EMP-9",75,"2018-01-04","Supervisor-2"]
["2018-01-05","Supervisor-1","EMP-1",76,"2018-01-05","Supervisor-1"]
["2018-01-05","Supervisor-1","EMP-2",87,"2018-01-05","Supervisor-1"]
["2018-01-05","Supervisor-1","EMP-3",93,"2018-01-05","Supervisor-1"]
["2018-01-05","Supervisor-1","EMP-4",81,"2018-01-05","Supervisor-1"]
["2018-01-05","Supervisor-1","EMP-5",79,"2018-01-05","Supervisor-1"]
["2018-01-05","Supervisor-2","EMP-10",98,"2018-01-05","Supervisor-2"]
["2018-01-05","Supervisor-2","EMP-6",95,"2018-01-05","Supervisor-2"]
["2018-01-05","Supervisor-2","EMP-7",62,"2018-01-05","Supervisor-2"]
["2018-01-05","Supervisor-2","EMP-8",72,"2018-01-05","Supervisor-2"]
["2018-01-05","Supervisor-2","EMP-9",70,"2018-01-05","Supervisor-2"]
["2018-01-06","Supervisor-1","EMP-1",95,"2018-01-06","Supervisor-1"]
["2018-01-06","Supervisor-1","EMP-2",70,"2018-01-06","Supervisor-1"]
["2018-01-06","Supervisor-1","EMP-3",93,"2018-01-06","Supervisor-1"]
["2018-01-06","Supervisor-1","EMP-4",100,"2018-01-06","Supervisor-1"]
["2018-01-06","Supervisor-1","EMP-5",93,"2018-01-06","Supervisor-1"]
["2018-01-06","Supervisor-2","EMP-10",97,"2018-01-06","Supervisor-2"]
["2018-01-06","Supervisor-2","EMP-6",88,"2018-01-06","Supervisor-2"]
["2018-01-06","Supervisor-2","EMP-7",92,"2018-01-06","Supervisor-2"]
["2018-01-06","Supervisor-2","EMP-8",62,"2018-01-06","Supervisor-2"]
["2018-01-06","Supervisor-2","EMP-9",92,"2018-01-06","Supervisor-2"]
["2018-01-07","Supervisor-1","EMP-1",64,"2018-01-07","Supervisor-1"]
["2018-01-07","Supervisor-1","EMP-2",90,"2018-01-07","Supervisor-1"]
["2018-01-07","Supervisor-1","EMP-3",86,"2018-01-07","Supervisor-1"]
["2018-01-07","Supervisor-1","EMP-4",79,"2018-01-07","Supervisor-1"]
["2018-01-07","Supervisor-1","EMP-5",61,"2018-01-07","Supervisor-1"]
["2018-01-07","Supervisor-2","EMP-10",76,{"$f":"IF(A67=\"\",E66,A67)","v":"2018-01-07"},{"$f":"IF(B67=\"\",F66,B67)","v":"Supervisor-2"}]
["2018-01-07","Supervisor-2","EMP-6",61,"2018-01-07","Supervisor-2"]
["2018-01-07","Supervisor-2","EMP-7",64,"2018-01-07","Supervisor-2"]
["2018-01-07","Supervisor-2","EMP-8",69,"2018-01-07","Supervisor-2"]
["2018-01-07","Supervisor-2","EMP-9",61,"2018-01-07","Supervisor-2"]
["2018-01-08","Supervisor-1","EMP-1",93,"2018-01-08","Supervisor-1"]
["2018-01-08","Supervisor-1","EMP-2",68,"2018-01-08","Supervisor-1"]
["2018-01-08","Supervisor-1","EMP-3",60,"2018-01-08","Supervisor-1"]
["2018-01-08","Supervisor-1","EMP-4",62,"2018-01-08","Supervisor-1"]
["2018-01-08","Supervisor-1","EMP-5",82,"2018-01-08","Supervisor-1"]
["2018-01-08","Supervisor-2","EMP-10",60,"2018-01-08","Supervisor-2"]
["2018-01-08","Supervisor-2","EMP-6",83,"2018-01-08","Supervisor-2"]
["2018-01-08","Supervisor-2","EMP-7",85,"2018-01-08","Supervisor-2"]
["2018-01-08","Supervisor-2","EMP-8",70,"2018-01-08","Supervisor-2"]
["2018-01-08","Supervisor-2","EMP-9",64,"2018-01-08","Supervisor-2"]
["2018-01-09","Supervisor-1","EMP-1",85,"2018-01-09","Supervisor-1"]
["2018-01-09","Supervisor-1","EMP-2",86,"2018-01-09","Supervisor-1"]
["2018-01-09","Supervisor-1","EMP-3",71,"2018-01-09","Supervisor-1"]
["2018-01-09","Supervisor-1","EMP-4",70,"2018-01-09","Supervisor-1"]
["2018-01-09","Supervisor-1","EMP-5",99,"2018-01-09","Supervisor-1"]
["2018-01-09","Supervisor-2","EMP-10",81,"2018-01-09","Supervisor-2"]
["2018-01-09","Supervisor-2","EMP-6",86,"2018-01-09","Supervisor-2"]
["2018-01-09","Supervisor-2","EMP-7",93,"2018-01-09","Supervisor-2"]
["2018-01-09","Supervisor-2","EMP-8",65,"2018-01-09","Supervisor-2"]
["2018-01-09","Supervisor-2","EMP-9",78,"2018-01-09","Supervisor-2"]
["2018-01-10","Supervisor-1","EMP-1",96,"2018-01-10","Supervisor-1"]
["2018-01-10","Supervisor-1","EMP-2",74,"2018-01-10","Supervisor-1"]
["2018-01-10","Supervisor-1","EMP-3",77,"2018-01-10","Supervisor-1"]
["2018-01-10","Supervisor-1","EMP-4",99,"2018-01-10","Supervisor-1"]
["2018-01-10","Supervisor-1","EMP-5",74,"2018-01-10","Supervisor-1"]
["2018-01-10","Supervisor-2","EMP-10",94,"2018-01-10","Supervisor-2"]
["2018-01-10","Supervisor-2","EMP-6",99,"2018-01-10","Supervisor-2"]
["2018-01-10","Supervisor-2","EMP-7",82,"2018-01-10","Supervisor-2"]
["2018-01-10","Supervisor-2","EMP-8",84,"2018-01-10","Supervisor-2"]
["2018-01-10","Supervisor-2","EMP-9",97,"2018-01-10","Supervisor-2"]
["2018-01-11","Supervisor-1","EMP-1",93,"2018-01-11","Supervisor-1"]
["2018-01-11","Supervisor-1","EMP-2",74,"2018-01-11","Supervisor-1"]
["2018-01-11","Supervisor-1","EMP-3",67,"2018-01-11","Supervisor-1"]
["2018-01-11","Supervisor-1","EMP-4",83,"2018-01-11","Supervisor-1"]
["2018-01-11","Supervisor-1","EMP-5",81,"2018-01-11","Supervisor-1"]
["2018-01-11","Supervisor-2","EMP-10",84,"2018-01-11","Supervisor-2"]
["2018-01-11","Supervisor-2","EMP-6",77,"2018-01-11","Supervisor-2"]
["2018-01-11","Supervisor-2","EMP-7",76,"2018-01-11","Supervisor-2"]
["2018-01-11","Supervisor-2","EMP-8",71,"2018-01-11","Supervisor-2"]
["2018-01-11","Supervisor-2","EMP-9",94,"2018-01-11","Supervisor-2"]
["2018-01-12","Supervisor-1","EMP-1",71,"2018-01-12","Supervisor-1"]
["2018-01-12","Supervisor-1","EMP-2",92,"2018-01-12","Supervisor-1"]
["2018-01-12","Supervisor-1","EMP-3",71,"2018-01-12","Supervisor-1"]
["2018-01-12","Supervisor-1","EMP-4",100,"2018-01-12","Supervisor-1"]
["2018-01-12","Supervisor-1","EMP-5",68,"2018-01-12","Supervisor-1"]
["2018-01-12","Supervisor-2","EMP-10",71,"2018-01-12","Supervisor-2"]
["2018-01-12","Supervisor-2","EMP-6",100,"2018-01-12","Supervisor-2"]
["2018-01-12","Supervisor-2","EMP-7",81,"2018-01-12","Supervisor-2"]
["2018-01-12","Supervisor-2","EMP-8",90,"2018-01-12","Supervisor-2"]
["2018-01-12","Supervisor-2","EMP-9",82,"2018-01-12","Supervisor-2"]
["2018-01-13","Supervisor-1","EMP-1",85,"2018-01-13","Supervisor-1"]
["2018-01-13","Supervisor-1","EMP-2",94,"2018-01-13","Supervisor-1"]
["2018-01-13","Supervisor-1","EMP-3",99,"2018-01-13","Supervisor-1"]
["2018-01-13","Supervisor-1","EMP-4",65,"2018-01-13","Supervisor-1"]
["2018-01-13","Supervisor-1","EMP-5",64,"2018-01-13","Supervisor-1"]
["2018-01-13","Supervisor-2","EMP-10",92,"2018-01-13","Supervisor-2"]
["2018-01-13","Supervisor-2","EMP-6",90,"2018-01-13","Supervisor-2"]
["2018-01-13","Supervisor-2","EMP-7",63,"2018-01-13","Supervisor-2"]
["2018-01-13","Supervisor-2","EMP-8",86,"2018-01-13","Supervisor-2"]
["2018-01-13","Supervisor-2","EMP-9",88,{"$f":"IF(A131=\"\",E130,A131)","v":"2018-01-13"},"Supervisor-2"]

{"sheet":"Sheet4","index":3,"n_rows":131,"n_cols":4,"rows_kept":131}
["Date","Supervisor","EMP Name","Sales"]
["2018-01-01","Supervisor-1","EMP-1",94]
["2018-01-01","Supervisor-1","EMP-2",70]
["2018-01-01","Supervisor-1","EMP-3",60]
["2018-01-01","Supervisor-1","EMP-4",60]
["2018-01-01","Supervisor-1","EMP-5",97]
["2018-01-01","Supervisor-2","EMP-10",60]
["2018-01-01","Supervisor-2","EMP-6",75]
["2018-01-01","Supervisor-2","EMP-7",62]
["2018-01-01","Supervisor-2","EMP-8",96]
["2018-01-01","Supervisor-2","EMP-9",100]
["2018-01-02","Supervisor-1","EMP-1",85]
["2018-01-02","Supervisor-1","EMP-2",90]
["2018-01-02","Supervisor-1","EMP-3",73]
["2018-01-02","Supervisor-1","EMP-4",72]
["2018-01-02","Supervisor-1","EMP-5",94]
["2018-01-02","Supervisor-2","EMP-10",88]
["2018-01-02","Supervisor-2","EMP-6",70]
["2018-01-02","Supervisor-2","EMP-7",78]
["2018-01-02","Supervisor-2","EMP-8",91]
["2018-01-02","Supervisor-2","EMP-9",64]
["2018-01-03","Supervisor-1","EMP-1",82]
["2018-01-03","Supervisor-1","EMP-2",70]
["2018-01-03","Supervisor-1","EMP-3",75]
["2018-01-03","Supervisor-1","EMP-4",80]
["2018-01-03","Supervisor-1","EMP-5",87]
["2018-01-03","Supervisor-2","EMP-10",91]
["2018-01-03","Supervisor-2","EMP-6",66]
["2018-01-03","Supervisor-2","EMP-7",99]
["2018-01-03","Supervisor-2","EMP-8",82]
["2018-01-03","Supervisor-2","EMP-9",90]
["2018-01-04","Supervisor-1","EMP-1",86]
["2018-01-04","Supervisor-1","EMP-2",71]
["2018-01-04","Supervisor-1","EMP-3",63]
["2018-01-04","Supervisor-1","EMP-4",72]
["2018-01-04","Supervisor-1","EMP-5",79]
["2018-01-04","Supervisor-2","EMP-10",78]
["2018-01-04","Supervisor-2","EMP-6",95]
["2018-01-04","Supervisor-2","EMP-7",86]
["2018-01-04","Supervisor-2","EMP-8",78]
["2018-01-04","Supervisor-2","EMP-9",75]
["2018-01-05","Supervisor-1","EMP-1",76]
["2018-01-05","Supervisor-1","EMP-2",87]
["2018-01-05","Supervisor-1","EMP-3",93]
["2018-01-05","Supervisor-1","EMP-4",81]
["2018-01-05","Supervisor-1","EMP-5",79]
["2018-01-05","Supervisor-2","EMP-10",98]
["2018-01-05","Supervisor-2","EMP-6",95]
["2018-01-05","Supervisor-2","EMP-7",62]
["2018-01-05","Supervisor-2","EMP-8",72]
["2018-01-05","Supervisor-2","EMP-9",70]
["2018-01-06","Supervisor-1","EMP-1",95]
["2018-01-06","Supervisor-1","EMP-2",70]
["2018-01-06","Supervisor-1","EMP-3",93]
["2018-01-06","Supervisor-1","EMP-4",100]
["2018-01-06","Supervisor-1","EMP-5",93]
["2018-01-06","Supervisor-2","EMP-10",97]
["2018-01-06","Supervisor-2","EMP-6",88]
["2018-01-06","Supervisor-2","EMP-7",92]
["2018-01-06","Supervisor-2","EMP-8",62]
["2018-01-06","Supervisor-2","EMP-9",92]
["2018-01-07","Supervisor-1","EMP-1",64]
["2018-01-07","Supervisor-1","EMP-2",90]
["2018-01-07","Supervisor-1","EMP-3",86]
["2018-01-07","Supervisor-1","EMP-4",79]
["2018-01-07","Supervisor-1","EMP-5",61]
["2018-01-07","Supervisor-2","EMP-10",76]
["2018-01-07","Supervisor-2","EMP-6",61]
["2018-01-07","Supervisor-2","EMP-7",64]
["2018-01-07","Supervisor-2","EMP-8",69]
["2018-01-07","Supervisor-2","EMP-9",61]
["2018-01-08","Supervisor-1","EMP-1",93]
["2018-01-08","Supervisor-1","EMP-2",68]
["2018-01-08","Supervisor-1","EMP-3",60]
["2018-01-08","Supervisor-1","EMP-4",62]
["2018-01-08","Supervisor-1","EMP-5",82]
["2018-01-08","Supervisor-2","EMP-10",60]
["2018-01-08","Supervisor-2","EMP-6",83]
["2018-01-08","Supervisor-2","EMP-7",85]
["2018-01-08","Supervisor-2","EMP-8",70]
["2018-01-08","Supervisor-2","EMP-9",64]
["2018-01-09","Supervisor-1","EMP-1",85]
["2018-01-09","Supervisor-1","EMP-2",86]
["2018-01-09","Supervisor-1","EMP-3",71]
["2018-01-09","Supervisor-1","EMP-4",70]
["2018-01-09","Supervisor-1","EMP-5",99]
["2018-01-09","Supervisor-2","EMP-10",81]
["2018-01-09","Supervisor-2","EMP-6",86]
["2018-01-09","Supervisor-2","EMP-7",93]
["2018-01-09","Supervisor-2","EMP-8",65]
["2018-01-09","Supervisor-2","EMP-9",78]
["2018-01-10","Supervisor-1","EMP-1",96]
["2018-01-10","Supervisor-1","EMP-2",74]
["2018-01-10","Supervisor-1","EMP-3",77]
["2018-01-10","Supervisor-1","EMP-4",99]
["2018-01-10","Supervisor-1","EMP-5",74]
["2018-01-10","Supervisor-2","EMP-10",94]
["2018-01-10","Supervisor-2","EMP-6",99]
["2018-01-10","Supervisor-2","EMP-7",82]
["2018-01-10","Supervisor-2","EMP-8",84]
["2018-01-10","Supervisor-2","EMP-9",97]
["2018-01-11","Supervisor-1","EMP-1",93]
["2018-01-11","Supervisor-1","EMP-2",74]
["2018-01-11","Supervisor-1","EMP-3",67]
["2018-01-11","Supervisor-1","EMP-4",83]
["2018-01-11","Supervisor-1","EMP-5",81]
["2018-01-11","Supervisor-2","EMP-10",84]
["2018-01-11","Supervisor-2","EMP-6",77]
["2018-01-11","Supervisor-2","EMP-7",76]
["2018-01-11","Supervisor-2","EMP-8",71]
["2018-01-11","Supervisor-2","EMP-9",94]
["2018-01-12","Supervisor-1","EMP-1",71]
["2018-01-12","Supervisor-1","EMP-2",92]
["2018-01-12","Supervisor-1","EMP-3",71]
["2018-01-12","Supervisor-1","EMP-4",100]
["2018-01-12","Supervisor-1","EMP-5",68]
["2018-01-12","Supervisor-2","EMP-10",71]
["2018-01-12","Supervisor-2","EMP-6",100]
["2018-01-12","Supervisor-2","EMP-7",81]
["2018-01-12","Supervisor-2","EMP-8",90]
["2018-01-12","Supervisor-2","EMP-9",82]
["2018-01-13","Supervisor-1","EMP-1",85]
["2018-01-13","Supervisor-1","EMP-2",94]
["2018-01-13","Supervisor-1","EMP-3",99]
["2018-01-13","Supervisor-1","EMP-4",65]
["2018-01-13","Supervisor-1","EMP-5",64]
["2018-01-13","Supervisor-2","EMP-10",92]
["2018-01-13","Supervisor-2","EMP-6",90]
["2018-01-13","Supervisor-2","EMP-7",63]
["2018-01-13","Supervisor-2","EMP-8",86]
["2018-01-13","Supervisor-2","EMP-9",88]