{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Form_per_Person","Sales_Data"],"not_rendered":{"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Form_per_Person","index":0,"n_rows":26,"n_cols":3,"rows_kept":26}
[]
[]
[null,"Sales Performance Sheet"]
[]
[null,"Administrative data"]
[]
[null,"Name","Joe Miller"]
[]
[null,"Region",{"$f":"INDEX(Sales_Data!G:G,MATCH(C7,Sales_Data!F:F,0))","v":"North"}]
[]
[null,"Sales per month"]
[]
[null,"Month","Sales amount [USD k]"]
[null,"2020-01-01",{"$f":"SUMIFS(Sales_Data!D:D,Sales_Data!C:C,B14,Sales_Data!B:B,C$7)","v":84}]
[null,"2020-02-01",{"$f":"SUMIFS(Sales_Data!D:D,Sales_Data!C:C,B15,Sales_Data!B:B,C$7)","v":79}]
[null,"2020-03-01",{"$f":"SUMIFS(Sales_Data!D:D,Sales_Data!C:C,B16,Sales_Data!B:B,C$7)","v":70}]
[null,"2020-04-01",{"$f":"SUMIFS(Sales_Data!D:D,Sales_Data!C:C,B17,Sales_Data!B:B,C$7)","v":3}]
[null,"2020-05-01",{"$f":"SUMIFS(Sales_Data!D:D,Sales_Data!C:C,B18,Sales_Data!B:B,C$7)","v":93}]
[null,"2020-06-01",{"$f":"SUMIFS(Sales_Data!D:D,Sales_Data!C:C,B19,Sales_Data!B:B,C$7)","v":23}]
[null,"2020-07-01",{"$f":"SUMIFS(Sales_Data!D:D,Sales_Data!C:C,B20,Sales_Data!B:B,C$7)","v":26}]
[null,"2020-08-01",{"$f":"SUMIFS(Sales_Data!D:D,Sales_Data!C:C,B21,Sales_Data!B:B,C$7)","v":72}]
[null,"2020-09-01",{"$f":"SUMIFS(Sales_Data!D:D,Sales_Data!C:C,B22,Sales_Data!B:B,C$7)","v":91}]
[null,"2020-10-01",{"$f":"SUMIFS(Sales_Data!D:D,Sales_Data!C:C,B23,Sales_Data!B:B,C$7)","v":92}]
[null,"2020-11-01",{"$f":"SUMIFS(Sales_Data!D:D,Sales_Data!C:C,B24,Sales_Data!B:B,C$7)","v":84}]
[null,"2020-12-01",{"$f":"SUMIFS(Sales_Data!D:D,Sales_Data!C:C,B25,Sales_Data!B:B,C$7)","v":37}]
[null,"Total",{"$f":"SUM(C14:C25)","v":754}]

{"sheet":"Sales_Data","index":1,"n_rows":76,"n_cols":7,"rows_kept":76}
[]
[null,"Sales Data",{"$nulls":3},"Region mapping"]
[]
[null,"Sales Person","Date (Month)","Amount",null,"Sales Person","Region"]
[null,"Joe Miller","2020-01-01",84,null,"Joe Miller","North"]
[null,"Joe Miller","2020-02-01",79,null,"Robert B. Klein","South"]
[null,"Joe Miller","2020-03-01",70,null,"Michelle Adams","East"]
[null,"Joe Miller","2020-04-01",3,null,"Erich Brown Jr.","West"]
[null,"Joe Miller","2020-05-01",93,null,"Dafna Johnson","North"]
[null,"Joe Miller","2020-06-01",23,null,"Rob C.","South"]
[null,"Joe Miller","2020-07-01",26]
[null,"Joe Miller","2020-08-01",72]
[null,"Joe Miller","2020-09-01",91]
[null,"Joe Miller","2020-10-01",92]
[null,"Joe Miller","2020-11-01",84]
[null,"Joe Miller","2020-12-01",37]
[null,"Robert B. Klein","2020-01-01",19]
[null,"Robert B. Klein","2020-02-01",61]
[null,"Robert B. Klein","2020-03-01",86]
[null,"Robert B. Klein","2020-04-01",82]
[null,"Robert B. Klein","2020-05-01",40]
[null,"Robert B. Klein","2020-06-01",9]
[null,"Robert B. Klein","2020-07-01",70]
[null,"Robert B. Klein","2020-08-01",70]
[null,"Robert B. Klein","2020-09-01",69]
[null,"Robert B. Klein","2020-10-01",68]
[null,"Robert B. Klein","2020-11-01",31]
[null,"Robert B. Klein","2020-12-01",95]
[null,"Michelle Adams","2020-01-01",30]
[null,"Michelle Adams","2020-02-01",8]
[null,"Michelle Adams","2020-03-01",58]
[null,"Michelle Adams","2020-04-01",26]
[null,"Michelle Adams","2020-05-01",55]
[null,"Michelle Adams","2020-06-01",61]
[null,"Michelle Adams","2020-07-01",86]
[null,"Michelle Adams","2020-08-01",84]
[null,"Michelle Adams","2020-09-01",51]
[null,"Michelle Adams","2020-10-01",35]
[null,"Michelle Adams","2020-11-01",52]
[null,"Michelle Adams","2020-12-01",72]
[null,"Erich Brown Jr.","2020-01-01",50]
[null,"Erich Brown Jr.","2020-02-01",49]
[null,"Erich Brown Jr.","2020-03-01",69]
[null,"Erich Brown Jr.","2020-04-01",50]
[null,"Erich Brown Jr.","2020-05-01",87]
[null,"Erich Brown Jr.","2020-06-01",23]
[null,"Erich Brown Jr.","2020-07-01",50]
[null,"Erich Brown Jr.","2020-08-01",66]
[null,"Erich Brown Jr.","2020-09-01",4]
[null,"Erich Brown Jr.","2020-10-01",98]
[null,"Erich Brown Jr.","2020-11-01",0]
[null,"Erich Brown Jr.","2020-12-01",45]
[null,"Dafna Johnson","2020-01-01",68]
[null,"Dafna Johnson","2020-02-01",28]
[null,"Dafna Johnson","2020-03-01",51]
[null,"Dafna Johnson","2020-04-01",58]
[null,"Dafna Johnson","2020-05-01",100]
[null,"Dafna Johnson","2020-06-01",78]
[null,"Dafna Johnson","2020-07-01",42]
[null,"Dafna Johnson","2020-08-01",86]
[null,"Dafna Johnson","2020-09-01",67]
[null,"Dafna Johnson","2020-10-01",66]
[null,"Dafna Johnson","2020-11-01",49]
[null,"Dafna Johnson","2020-12-01",9]
[null,"Rob C.","2020-01-01",8]
[null,"Rob C.","2020-02-01",99]
[null,"Rob C.","2020-03-01",42]
[null,"Rob C.","2020-04-01",44]
[null,"Rob C.","2020-05-01",52]
[null,"Rob C.","2020-06-01",9]
[null,"Rob C.","2020-07-01",90]
[null,"Rob C.","2020-08-01",40]
[null,"Rob C.","2020-09-01",55]
[null,"Rob C.","2020-10-01",10]
[null,"Rob C.","2020-11-01",54]
[null,"Rob C.","2020-12-01",69]