{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["1781C","1781","1781(an)"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":1,"defined_names":32,"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":"1781C","index":0,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,6,9],[7,1,10,9],[11,1,14,9]]}
[]
[null,"HSTACK\nVSTACK"]
[]
[]
[]
[]
[]
[null,"Single Cell Cross Tabulated Report"]
[]
[]
[]
[null,"Excel Magic Trick 1781"]
[]
[]
[]
[]
[null,"Excel Statistical Analysis 7: Cross Tabulation, Visualizations, AND Logical Tests, Simpson’s Paradox"]
[null,{"$f":"LEN(B17)","v":100}]
[null,null,{"$f":"LEN(C18)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,"Microsoft 365 Excel"]

{"sheet":"1781","index":1,"n_rows":95,"n_cols":10,"rows_kept":95,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","Sales","Employee","Product"]
[null,"2023-01-02",1116.49,"Cinderella Stein","Carlota"]
[null,"2023-01-02",1575.84,"Johnsie Treadway","Carlota"]
[null,"2023-01-02",331.69,"Barton Rojas","Carlota"]
[null,"2023-01-02",474.66,"Cinderella Stein","Yanaki"]
[null,"2023-01-02",402.75,"Johnsie Treadway","Quad"]
[null,"2023-01-02",114.79,"Johnsie Treadway","Carlota"]
[null,"2023-01-02",872.93,"Tyrone Washington","Quad"]
[null,"2023-01-02",2164.73,"Tyrone Washington","Carlota"]
[null,"2023-01-02",2383.2800000000002,"Johnsie Treadway","Aspen"]
[null,"2023-01-02",247.35,"Cinderella Stein","Aspen"]
[null,"2023-01-03",1718.94,"Tyrone Washington","Carlota"]
[null,"2023-01-03",351.53,"Johnsie Treadway","Aspen"]
[null,"2023-01-03",494.64,"Tyrone Washington","Carlota"]
[null,"2023-01-03",1544.04,"Cinderella Stein","Aspen"]
[null,"2023-01-03",281.77,"Cinderella Stein","Carlota"]
[null,"2023-01-03",453.99,"Johnsie Treadway","Yanaki"]
[null,"2023-01-03",207.29,"Cinderella Stein","Quad"]
[null,"2023-01-03",1521.42,"Tyrone Washington","Quad"]
[null,"2023-01-03",2339,"Chantel Mimms","Yanaki"]
[null,"2023-01-03",2487.54,"Chantel Mimms","Aspen"]
[null,"2023-01-03",977.28,"Tyrone Washington","Aspen"]
[null,"2023-01-03",1666.68,"Cinderella Stein","Aspen"]
[null,"2023-01-03",544.41,"Tyrone Washington","Quad"]
[null,"2023-01-03",192.25,"Tyrone Washington","Quad"]
[null,"2023-01-04",2057.67,"Tyrone Washington","Yanaki"]
[null,"2023-01-04",48.23,"Johnsie Treadway","Quad"]
[null,"2023-01-04",1877.43,"Tyrone Washington","Yanaki"]
[null,"2023-01-04",500,"Johnsie Treadway","Carlota"]
[null,"2023-01-04",1240.6600000000001,"Tyrone Washington","Quad"]
[null,"2023-01-04",264.72000000000003,"Barton Rojas","Aspen"]
[null,"2023-01-04",2306.12,"Chantel Mimms","Quad"]
[null,"2023-01-04",472.56,"Johnsie Treadway","Yanaki"]
[null,"2023-01-04",654.63,"Barton Rojas","Quad"]
[null,"2023-01-04",344.26,"Cinderella Stein","Yanaki"]
[null,"2023-01-05",331.2,"Tyrone Washington","Quad"]
[null,"2023-01-05",283.72000000000003,"Chantel Mimms","Carlota"]
[null,"2023-01-05",259.45999999999998,"Barton Rojas","Yanaki"]
[null,"2023-01-05",70.22,"Barton Rojas","Aspen"]
[null,"2023-01-05",2369.15,"Tyrone Washington","Yanaki"]
[null,"2023-01-05",1488.59,"Barton Rojas","Quad"]
[null,"2023-01-05",223.74,"Tyrone Washington","Yanaki"]
[null,"2023-01-05",1059.3599999999999,"Tyrone Washington","Yanaki"]
[null,"2023-01-05",427.07,"Johnsie Treadway","Yanaki"]
[null,"2023-01-05",289.93,"Johnsie Treadway","Yanaki"]
[null,"2023-01-05",1360.51,"Chantel Mimms","Aspen"]
[null,"2023-01-06",1123.8,"Chantel Mimms","Quad"]
[null,"2023-01-06",214.45,"Johnsie Treadway","Aspen"]
[null,"2023-01-06",432.61,"Barton Rojas","Aspen"]
[null,"2023-01-06",284.70999999999998,"Cinderella Stein","Aspen"]
[null,"2023-01-06",1253.1300000000001,"Tyrone Washington","Aspen"]
[null,"2023-01-06",487.05,"Chantel Mimms","Yanaki"]
[null,"2023-01-06",977.7,"Chantel Mimms","Aspen"]
[null,"2023-01-06",335.83,"Johnsie Treadway","Aspen"]
[null,null,null,null,null,null,"2023-01-09",140.22,"Chantel Mimms","Sunshine"]
[null,null,null,null,null,null,"2023-01-09",433.08,"Sioux Radness","Sunshine"]
[null,null,null,null,null,null,"2023-01-09",2565.54,"Tyrone Washington","Yanaki"]
[null,null,null,null,null,null,"2023-01-09",354.35,"Chantel Mimms","Yanaki"]
[null,null,null,null,null,null,"2023-01-09",553.76,"Sioux Radness","Aspen"]
[null,null,null,null,null,null,"2023-01-09",262.76,"Cinderella Stein","Sunshine"]
[null,null,null,null,null,null,"2023-01-09",439.66,"Barton Rojas","Sunshine"]
[null,null,null,null,null,null,"2023-01-09",296.58,"Barton Rojas","Quad"]
[null,null,null,null,null,null,"2023-01-09",2394.1,"Tyrone Washington","Sunshine"]
[null,null,null,null,null,null,"2023-01-09",982.24,"Barton Rojas","Carlota"]
[null,null,null,null,null,null,"2023-01-09",273.75,"Sioux Radness","Quad"]
[null,null,null,null,null,null,"2023-01-09",1910.17,"Barton Rojas","Yanaki"]
[null,null,null,null,null,null,"2023-01-09",999.96,"Cinderella Stein","Aspen"]
[null,null,null,null,null,null,"2023-01-09",1205.29,"Barton Rojas","Sunshine"]
[null,null,null,null,null,null,"2023-01-09",1177.29,"Sioux Radness","Yanaki"]
[]
[null,null,null,null,null,null,"2023-01-10",416.24,"Tyrone Washington","V-Rang"]
[null,null,null,null,null,null,"2023-01-10",1864.51,"Cinderella Stein","Yanaki"]
[null,null,null,null,null,null,"2023-01-10",263.37,"Tyrone Washington","Sunshine"]
[null,null,null,null,null,null,"2023-01-10",355.58,"Barton Rojas","V-Rang"]
[null,null,null,null,null,null,"2023-01-10",2794.15,"Tyrone Washington","Yanaki"]
[null,null,null,null,null,null,"2023-01-10",370.45,"Johnsie Treadway","Aspen"]
[null,null,null,null,null,null,"2023-01-10",418.35,"Johnsie Treadway","Carlota"]
[null,null,null,null,null,null,"2023-01-10",364.72,"Barton Rojas","Sunshine"]
[null,null,null,null,null,null,"2023-01-10",2687.45,"Tyrone Washington","Carlota"]
[null,null,null,null,null,null,"2023-01-10",2091.29,"Tyrone Washington","Yanaki"]
[null,null,null,null,null,null,"2023-01-10",304.58,"Cinderella Stein","V-Rang"]
[null,null,null,null,null,null,"2023-01-10",2044.17,"Tyrone Washington","Aspen"]
[null,null,null,null,null,null,"2023-01-10",1879.21,"Chantel Mimms","Yanaki"]
[null,null,null,null,null,null,"2023-01-10",2762.35,"Chantel Mimms","Sunshine"]
[null,null,null,null,null,null,"2023-01-10",626.78,"Johnsie Treadway","V-Rang"]
[null,null,null,null,null,null,"2023-01-10",329.85,"Chantel Mimms","V-Rang"]
[null,null,null,null,null,null,"2023-01-10",419.96,"Cinderella Stein","V-Rang"]
[null,null,null,null,null,null,"2023-01-10",468.05,"Tyrone Washington","Quad"]
[null,null,null,null,null,null,"2023-01-10",2154.85,"Johnsie Treadway","Sunshine"]
[null,null,null,null,null,null,"2023-01-10",2442.0700000000002,"Tyrone Washington","Sunshine"]
[null,null,null,null,null,null,"2023-01-10",136.21,"Johnsie Treadway","Quad"]
[null,null,null,null,null,null,"2023-01-10",1461.01,"Barton Rojas","Carlota"]
[null,null,null,null,null,null,"2023-01-10",2248.04,"Chantel Mimms","Sunshine"]
[null,null,null,null,null,null,"2023-01-10",1594.7,"Cinderella Stein","Carlota"]

{"sheet":"1781(an)","index":2,"n_rows":95,"n_cols":12,"rows_kept":95,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","Sales","Employee","Product",null,{"$f":"_xlfn.LET(\n_xlpm.sc,fSalesAn[Sales],_xlpm.ec,fSalesAn[Employee],_xlpm.pc,fSalesAn[Product],\n_xlpm.efn,fSalesAn[[#Headers],[Employee]],_xlpm.pfn,fSalesAn[[#Headers],[Product]],\n_xlpm.el,_xlfn._xlws.SORT(_xlfn.UNIQUE(_xlpm.ec)),_xlpm.pl,TRANSPOSE(_xlfn._xlws.SORT(_xlfn.UNIQUE(_xlpm.pc))),\n_xlpm.fr,_xlfn.HSTACK(_xlpm.efn&\"/\"&_xlpm.pfn,_xlpm.pl,\"Total Sales\"),\n_xlpm.sr,_xlfn.HSTACK(_xlpm.el,SUMIFS(_xlpm.sc,_xlpm.ec,_xlpm.el,_xlpm.pc,_xlpm.pl),SUMIFS(_xlpm.sc,_xlpm.ec,_xlpm.el)),\n_xlpm.tr,_xlfn.HSTACK(\"Total Sales\",SUMIFS(_xlpm.sc,_xlpm.pc,_xlpm.pl),SUM(_xlpm.sc)),\n_xlfn.VSTACK(_xlpm.fr,_xlpm.sr,_xlpm.tr))","v":"Employee/Product"},"Aspen","Carlota","Quad","Yanaki","Total Sales"]
[null,"2023-01-02",1116.49,"Cinderella Stein","Carlota",null,"Barton Rojas",767.55000000000007,331.69,2143.2199999999998,259.45999999999998,3501.92]
[null,"2023-01-02",1575.84,"Johnsie Treadway","Carlota",null,"Chantel Mimms",4825.75,283.72000000000003,3429.92,2826.05,11365.439999999999]
[null,"2023-01-02",331.69,"Barton Rojas","Carlota",null,"Cinderella Stein",3742.7799999999997,1398.26,207.29,818.92000000000007,6167.25]
[null,"2023-01-02",474.66,"Cinderella Stein","Yanaki",null,"Johnsie Treadway",3285.09,2190.63,450.98,1643.55,7570.2499999999991]
[null,"2023-01-02",402.75,"Johnsie Treadway","Quad",null,"Tyrone Washington",2230.41,4378.3100000000004,4702.87,7587.3499999999995,18898.940000000002]
[null,"2023-01-02",114.79,"Johnsie Treadway","Carlota",null,"Total Sales",14851.58,8582.6099999999988,10934.279999999999,13135.33,47503.799999999996]
[null,"2023-01-02",872.93,"Tyrone Washington","Quad"]
[null,"2023-01-02",2164.73,"Tyrone Washington","Carlota"]
[null,"2023-01-02",2383.2800000000002,"Johnsie Treadway","Aspen"]
[null,"2023-01-02",247.35,"Cinderella Stein","Aspen"]
[null,"2023-01-03",1718.94,"Tyrone Washington","Carlota"]
[null,"2023-01-03",351.53,"Johnsie Treadway","Aspen"]
[null,"2023-01-03",494.64,"Tyrone Washington","Carlota"]
[null,"2023-01-03",1544.04,"Cinderella Stein","Aspen"]
[null,"2023-01-03",281.77,"Cinderella Stein","Carlota"]
[null,"2023-01-03",453.99,"Johnsie Treadway","Yanaki"]
[null,"2023-01-03",207.29,"Cinderella Stein","Quad"]
[null,"2023-01-03",1521.42,"Tyrone Washington","Quad"]
[null,"2023-01-03",2339,"Chantel Mimms","Yanaki"]
[null,"2023-01-03",2487.54,"Chantel Mimms","Aspen"]
[null,"2023-01-03",977.28,"Tyrone Washington","Aspen"]
[null,"2023-01-03",1666.68,"Cinderella Stein","Aspen"]
[null,"2023-01-03",544.41,"Tyrone Washington","Quad"]
[null,"2023-01-03",192.25,"Tyrone Washington","Quad"]
[null,"2023-01-04",2057.67,"Tyrone Washington","Yanaki"]
[null,"2023-01-04",48.23,"Johnsie Treadway","Quad"]
[null,"2023-01-04",1877.43,"Tyrone Washington","Yanaki"]
[null,"2023-01-04",500,"Johnsie Treadway","Carlota"]
[null,"2023-01-04",1240.6600000000001,"Tyrone Washington","Quad"]
[null,"2023-01-04",264.72000000000003,"Barton Rojas","Aspen"]
[null,"2023-01-04",2306.12,"Chantel Mimms","Quad"]
[null,"2023-01-04",472.56,"Johnsie Treadway","Yanaki"]
[null,"2023-01-04",654.63,"Barton Rojas","Quad"]
[null,"2023-01-04",344.26,"Cinderella Stein","Yanaki"]
[null,"2023-01-05",331.2,"Tyrone Washington","Quad"]
[null,"2023-01-05",283.72000000000003,"Chantel Mimms","Carlota"]
[null,"2023-01-05",259.45999999999998,"Barton Rojas","Yanaki"]
[null,"2023-01-05",70.22,"Barton Rojas","Aspen"]
[null,"2023-01-05",2369.15,"Tyrone Washington","Yanaki"]
[null,"2023-01-05",1488.59,"Barton Rojas","Quad"]
[null,"2023-01-05",223.74,"Tyrone Washington","Yanaki"]
[null,"2023-01-05",1059.3599999999999,"Tyrone Washington","Yanaki"]
[null,"2023-01-05",427.07,"Johnsie Treadway","Yanaki"]
[null,"2023-01-05",289.93,"Johnsie Treadway","Yanaki"]
[null,"2023-01-05",1360.51,"Chantel Mimms","Aspen"]
[null,"2023-01-06",1123.8,"Chantel Mimms","Quad"]
[null,"2023-01-06",214.45,"Johnsie Treadway","Aspen"]
[null,"2023-01-06",432.61,"Barton Rojas","Aspen"]
[null,"2023-01-06",284.70999999999998,"Cinderella Stein","Aspen"]
[null,"2023-01-06",1253.1300000000001,"Tyrone Washington","Aspen"]
[null,"2023-01-06",487.05,"Chantel Mimms","Yanaki"]
[null,"2023-01-06",977.7,"Chantel Mimms","Aspen"]
[null,"2023-01-06",335.83,"Johnsie Treadway","Aspen"]
[null,null,null,null,null,null,"2023-01-09",140.22,"Chantel Mimms","Sunshine"]
[null,null,null,null,null,null,"2023-01-09",433.08,"Sioux Radness","Sunshine"]
[null,null,null,null,null,null,"2023-01-09",2565.54,"Tyrone Washington","Yanaki"]
[null,null,null,null,null,null,"2023-01-09",354.35,"Chantel Mimms","Yanaki"]
[null,null,null,null,null,null,"2023-01-09",553.76,"Sioux Radness","Aspen"]
[null,null,null,null,null,null,"2023-01-09",262.76,"Cinderella Stein","Sunshine"]
[null,null,null,null,null,null,"2023-01-09",439.66,"Barton Rojas","Sunshine"]
[null,null,null,null,null,null,"2023-01-09",296.58,"Barton Rojas","Quad"]
[null,null,null,null,null,null,"2023-01-09",2394.1,"Tyrone Washington","Sunshine"]
[null,null,null,null,null,null,"2023-01-09",982.24,"Barton Rojas","Carlota"]
[null,null,null,null,null,null,"2023-01-09",273.75,"Sioux Radness","Quad"]
[null,null,null,null,null,null,"2023-01-09",1910.17,"Barton Rojas","Yanaki"]
[null,null,null,null,null,null,"2023-01-09",999.96,"Cinderella Stein","Aspen"]
[null,null,null,null,null,null,"2023-01-09",1205.29,"Barton Rojas","Sunshine"]
[null,null,null,null,null,null,"2023-01-09",1177.29,"Sioux Radness","Yanaki"]
[]
[null,null,null,null,null,null,"2023-01-10",416.24,"Tyrone Washington","V-Rang"]
[null,null,null,null,null,null,"2023-01-10",1864.51,"Cinderella Stein","Yanaki"]
[null,null,null,null,null,null,"2023-01-10",263.37,"Tyrone Washington","Sunshine"]
[null,null,null,null,null,null,"2023-01-10",355.58,"Barton Rojas","V-Rang"]
[null,null,null,null,null,null,"2023-01-10",2794.15,"Tyrone Washington","Yanaki"]
[null,null,null,null,null,null,"2023-01-10",370.45,"Johnsie Treadway","Aspen"]
[null,null,null,null,null,null,"2023-01-10",418.35,"Johnsie Treadway","Carlota"]
[null,null,null,null,null,null,"2023-01-10",364.72,"Barton Rojas","Sunshine"]
[null,null,null,null,null,null,"2023-01-10",2687.45,"Tyrone Washington","Carlota"]
[null,null,null,null,null,null,"2023-01-10",2091.29,"Tyrone Washington","Yanaki"]
[null,null,null,null,null,null,"2023-01-10",304.58,"Cinderella Stein","V-Rang"]
[null,null,null,null,null,null,"2023-01-10",2044.17,"Tyrone Washington","Aspen"]
[null,null,null,null,null,null,"2023-01-10",1879.21,"Chantel Mimms","Yanaki"]
[null,null,null,null,null,null,"2023-01-10",2762.35,"Chantel Mimms","Sunshine"]
[null,null,null,null,null,null,"2023-01-10",626.78,"Johnsie Treadway","V-Rang"]
[null,null,null,null,null,null,"2023-01-10",329.85,"Chantel Mimms","V-Rang"]
[null,null,null,null,null,null,"2023-01-10",419.96,"Cinderella Stein","V-Rang"]
[null,null,null,null,null,null,"2023-01-10",468.05,"Tyrone Washington","Quad"]
[null,null,null,null,null,null,"2023-01-10",2154.85,"Johnsie Treadway","Sunshine"]
[null,null,null,null,null,null,"2023-01-10",2442.0700000000002,"Tyrone Washington","Sunshine"]
[null,null,null,null,null,null,"2023-01-10",136.21,"Johnsie Treadway","Quad"]
[null,null,null,null,null,null,"2023-01-10",1461.01,"Barton Rojas","Carlota"]
[null,null,null,null,null,null,"2023-01-10",2248.04,"Chantel Mimms","Sunshine"]
[null,null,null,null,null,null,"2023-01-10",1594.7,"Cinderella Stein","Carlota"]