{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Task1","Task2","Task3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Task1","index":0,"n_rows":26,"n_cols":13,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["SalesKey","DateKey","Month","Quarter","Year","channelKey","Chanel","StoreKey","ProductKey","Category","Payment","TotalCost","SalesAmount"]
[126326,"2019-10-27",4,"Q 2",2020,1,"Store",2,395,"Computers","Debit",3324,6520]
[122568,"2019-10-14",4,"Q 2",2020,3,"Mail",2,1032,"Cameras","Credit",864.5,1880]
[123171,"2019-10-16",4,"Q 2",2020,2,"Online",2,1063,"Cameras","Cash",1554.3,3380]
[104966,"2019-10-26",4,"Q 2",2020,1,"Store",2,1136,"Cameras","Credit",1592,4805]
[100152,"2019-10-25",4,"Q 2",2020,3,"Mail",2,242,"TV & Video Music","Cash",2945.4,8890]
[129847,"2019-08-15",2,"Q 1",2020,2,"Online",2,1548,"Cell phones","Debit",1467.84,3165.4]
[106505,"2019-08-31",2,"Q 1",2020,1,"Store",2,1166,"Cameras","Debit",2018.88,3927]
[104554,"2019-09-16",3,"Q 1",2020,3,"Mail",2,1105,"Cameras","Credit",2258.2800000000002,6588.8]
[104876,"2019-08-12",2,"Q 1",2020,2,"Online",2,685,"Computers","Cash",871.92,1896]
[128192,"2019-09-07",3,"Q 1",2020,2,"Online",2,57,"Audio","Debit",1908.72,3697.2]
[112886,"2019-07-31",1,"Q 1",2020,2,"Online",2,828,"Computers","Debit",131.88,277.24]
[118283,"2019-08-11",2,"Q 1",2020,3,"Mail",2,1645,"TV & Video Music","Debit",319.44,682.98400000000004]
[113525,"2019-09-01",3,"Q 1",2020,3,"Mail",2,844,"Computers","Credit",329.04,645.6]
[100083,"2019-09-29",3,"Q 1",2020,2,"Online",2,66,"Audio","Debit",314.39999999999998,616.55999999999995]
[109357,"2019-08-19",2,"Q 1",2020,2,"Online",2,1028,"Cameras","Credit",1423.68,3057.3]
[122648,"2019-08-28",2,"Q 1",2020,3,"Mail",2,471,"Computers","Debit",1211.28,2366.1]
[121468,"2019-08-14",2,"Q 1",2020,1,"Store",2,995,"Cameras","Credit",1040.1600000000001,2262]
[125222,"2019-07-14",1,"Q 1",2020,3,"Mail",2,548,"Computers","Debit",2096.88,4541]
[119366,"2019-07-25",1,"Q 1",2020,1,"Store",2,491,"Computers","Debit",2461.08,7242.3]
[117753,"2019-08-17",2,"Q 1",2020,2,"Online",2,1360,"Cell phones","Cash",93.42,281.94]
[125368,"2019-09-21",3,"Q 1",2020,1,"Store",2,551,"Computers","Credit",4562.28,13311]
[121518,"2019-09-11",3,"Q 1",2020,3,"Mail",2,853,"Computers","Debit",459,1385.4]
[115158,"2019-08-25",2,"Q 1",2020,1,"Store",2,202,"TV & Video Music","Credit",3802.2,8061.3]
[100042,"2019-07-04",1,"Q 1",2020,2,"Online",2,1352,"Cell phones","Credit",126.84,268.983]
[112360,"2019-09-07",3,"Q 1",2020,1,"Store",2,1400,"Cell phones","Credit",182.05,424.68200000000002]

{"sheet":"Task2","index":1,"n_rows":28,"n_cols":13,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["SalesKey","DateKey","Month","Quarter","Year","channelKey","Chanel","StoreKey","ProductKey","Category","Payment","TotalCost","SalesAmount"]
[113096,"2019-10-08",4,"Q 2",2020,1,"Store",1,3,"Audio","Debit",148,290.39999999999998]
[110712,"2019-10-07",4,"Q 2",2020,3,"Mail",1,428,"Computers","Credit",3210.5,9690]
[127006,"2019-10-23",4,"Q 2",2020,2,"Online",1,579,"Computers","Credit",1167.5,2290]
[109693,"2019-10-06",4,"Q 2",2020,2,"Online",1,953,"Cameras","Debit",866.8,1885]
[102938,"2019-09-22",3,"Q 1",2020,2,"Online",1,448,"Computers","Cash",3302.4,6423.62]
[107504,"2019-07-11",1,"Q 1",2020,3,"Mail",1,15,"Audio","Credit",857.28,1833.248]
[116295,"2019-09-12",3,"Q 1",2020,2,"Online",1,368,"Computers","Credit",2582.2800000000002,7404.3]
[104503,"2019-09-01",3,"Q 1",2020,1,"Store",1,970,"Cameras","Credit",1092.5999999999999,2376]
[102125,"2019-07-25",1,"Q 1",2020,2,"Online",1,963,"Cameras","Credit",1065.48,3216]
[122309,"2019-09-18",3,"Q 1",2020,1,"Store",1,249,"TV & Video Music","Credit",2435.04,4776]
[108884,"2019-08-03",2,"Q 1",2020,2,"Online",1,374,"Computers","Debit",2582.2800000000002,7274.4]
[107281,"2019-08-20",2,"Q 1",2020,3,"Mail",1,752,"Computers","Credit",116.16,228]
[119847,"2019-07-08",1,"Q 1",2020,3,"Mail",1,829,"Computers","Debit",79.319999999999993,235.41]
[128679,"2019-08-19",2,"Q 1",2020,2,"Online",1,70,"Audio","Credit",529.20000000000005,1131.6199999999999]
[112233,"2019-09-08",3,"Q 1",2020,3,"Mail",1,879,"Computers","Debit",159.12,312]
[111728,"2019-07-14",1,"Q 1",2020,1,"Store",1,344,"Computers","Credit",2239.1999999999998,4355.3999999999996]
[128148,"2019-08-14",2,"Q 1",2020,3,"Mail",1,1196,"Cameras","Credit",2366.65,4895.2]
[120452,"2019-07-26",1,"Q 1",2020,2,"Online",1,1166,"Cameras","Debit",2018.88,3960]
[102168,"2019-09-13",3,"Q 1",2020,2,"Online",1,728,"Computers","Cash",1081.56,2332.4]
[101674,"2019-07-12",1,"Q 1",2020,1,"Store",1,338,"Computers","Credit",4767,13908.4]
[114459,"2019-07-23",1,"Q 1",2020,2,"Online",1,619,"Computers","Credit",1385.16,2961.8]
[124023,"2019-09-28",3,"Q 1",2020,1,"Store",1,63,"Audio","Credit",998.88,2099.6]
[105047,"2019-09-21",3,"Q 1",2020,3,"Mail",1,1514,"Cell phones","Credit",1147.8,2475.1999999999998]
[115910,"2019-09-30",3,"Q 1",2020,1,"Store",1,538,"Computers","Cash",1211.28,2356.1999999999998]
[104073,"2019-07-16",1,"Q 1",2020,3,"Mail",1,105,"Audio","Credit",634.55999999999995,1357]
[122978,"2019-09-14",3,"Q 1",2020,3,"Mail",1,1556,"Cell phones","Credit",1545.12,3304]
[107377,"2019-09-20",3,"Q 1",2020,3,"Mail",1,455,"Computers","Debit",1826.88,5422.1]

{"sheet":"Task3","index":2,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["SalesKey","DateKey","Month","Quarter","Year","channelKey","Chanel","StoreKey","ProductKey","Category","Payment","TotalCost","SalesAmount"]
[128780,"2019-08-31",2,"Q 1",2020,3,"Mail",1,454,"Computers","Credit",3302.4,6423.62]
[101602,"2019-07-19",1,"Q 1",2020,1,"Store",1,514,"Computers","Debit",548.64,1642.2]
[112659,"2019-07-13",1,"Q 1",2020,2,"Online",1,588,"Computers","Debit",4967.82,14494.2]
[112682,"2019-07-04",1,"Q 1",2020,2,"Online",1,406,"Computers","Debit",2342.88,4557.1049999999996]
[108015,"2019-08-16",2,"Q 1",2020,2,"Online",1,472,"Computers","Debit",844.32,1635.3]
[117479,"2019-09-19",3,"Q 1",2020,2,"Online",1,906,"Computers","Credit",929.76,1808.5619999999999]
[121263,"2019-07-17",1,"Q 1",2020,3,"Mail",1,395,"Computers","Credit",3988.8,7791.4]
[105010,"2019-11-07",5,"Q 2",2020,3,"Mail",1,553,"Computers","Debit",4178.72,9087]
[118039,"2019-11-12",5,"Q 2",2020,1,"Store",1,1553,"Cell phones","Debit",1602.12,3484]
[126438,"2019-12-25",6,"Q 2",2020,1,"Store",1,23,"Audio","Credit",801.06,1688.4]
[108566,"2019-12-11",6,"Q 2",2020,1,"Store",1,1163,"Cameras","Credit",5081.4399999999996,10370]
[123420,"2019-11-01",5,"Q 2",2020,2,"Online",1,42,"Audio","Credit",1386.97,2923.2]
[102827,"2019-11-20",5,"Q 2",2020,1,"Store",1,122,"TV & Video Music","Debit",1673.88,3639.87]
[102274,"2019-11-16",5,"Q 2",2020,1,"Store",1,338,"Computers","Credit",5164.25,14627.8]
[107667,"2019-12-19",6,"Q 2",2020,3,"Mail",1,1328,"Cell phones","Debit",99.36,259.94799999999998]
[101896,"2019-12-18",6,"Q 2",2020,1,"Store",1,1204,"Cameras","Cash",3180.66,9280]
[104810,"2019-12-21",6,"Q 2",2020,3,"Mail",1,1379,"Cell phones","Credit",137.54,289.8]
[121523,"2019-12-16",6,"Q 2",2020,1,"Store",1,371,"Computers","Credit",3580.98,7547.4]
[110095,"2019-12-03",6,"Q 2",2020,2,"Online",1,1347,"Cell phones","Debit",125.58,260.39999999999998]
[109277,"2019-11-13",5,"Q 2",2020,3,"Mail",1,1180,"Cameras","Credit",3180.66,8640]
[118879,"2019-12-22",6,"Q 2",2020,1,"Store",1,366,"Computers","Debit",4182.96,9854]
[100935,"2019-12-07",6,"Q 2",2020,3,"Mail",1,378,"Computers","Credit",4531.54,9854]
[123995,"2019-12-20",6,"Q 2",2020,3,"Mail",1,44,"Audio","Credit",1386.97,3016]
[101284,"2019-11-03",5,"Q 2",2020,2,"Online",1,363,"Computers","Debit",4178.72,8947.2000000000007]
[107605,"2019-12-18",6,"Q 2",2020,2,"Online",1,109,"Audio","Credit",795.08,1702.2719999999999]
[106613,"2019-12-15",6,"Q 2",2020,1,"Store",1,504,"Computers","Debit",1727.52,4518.8]
[119450,"2019-11-20",5,"Q 2",2020,1,"Store",1,468,"Computers","Credit",1070.1600000000001,2327]
[125168,"2019-12-09",6,"Q 2",2020,3,"Mail",1,161,"TV & Video Music","Credit",3165.18,8279.44]