{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Sales Data","Pivot Table","Double Click","Button","Context Menu","Keyboard Shortcuts","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":6},"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":"Sales Data","index":0,"n_rows":44,"n_cols":8,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
[null,"Sales Data"]
[]
[null,"OrderDate","Region","Category","Product","UnitPrice","Quantity","SalePrice"]
[null,"2022-07-01","East","Cookies","Chocolate Chip",1.87,40,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":74.800000000000011}]
[null,"2022-07-02","East","Bars","Carrot",1.77,78,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":138.06}]
[null,"2022-07-03","East","Snacks","Pretzels",3.15,20,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":63}]
[null,"2022-07-04","East","Bars","Bran",1.87,83,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":155.21}]
[null,"2022-07-05","East","Cookies","Oatmeal Raisin",2.84,37,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":105.08}]
[null,"2022-07-06","East","Cookies","Chocolate Chip",1.87,82,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":153.34}]
[null,"2022-07-07","West","Bars","Carrot",1.77,58,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":102.66}]
[null,"2022-07-08","West","Bars","Bran",1.87,46,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":86.02000000000001}]
[null,"2022-07-09","East","Snacks","Potato Chips",1.68,47,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":78.959999999999994}]
[null,"2022-07-10","East","Bars","Carrot",1.77,106,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":187.62}]
[null,"2022-07-11","West","Bars","Carrot",1.77,22,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":38.94}]
[null,"2022-07-12","East","Crackers","Cheese",2.5299999999999998,23,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":58.19}]
[null,"2022-07-13","East","Crackers","Saltines",2.19,55,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":120.45}]
[null,"2022-07-14","West","Cookies","Arrowroot",2.1800000000000002,25,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":54.500000000000007}]
[null,"2022-07-15","West","Crackers","Whole Wheat",3.49,30,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":104.7}]
[null,"2022-07-16","West","Bars","Bran",1.87,43,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":80.410000000000011}]
[null,"2022-07-17","East","Crackers","Whole Wheat",3.49,36,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":125.64000000000001}]
[null,"2022-07-18","West","Cookies","Chocolate Chip",1.87,95,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":177.65}]
[null,"2022-07-19","East","Cookies","Chocolate Chip",1.87,80,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":149.60000000000002}]
[null,"2022-07-20","East","Crackers","Whole Wheat",3.49,21,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":73.290000000000006}]
[null,"2022-07-21","East","Bars","Banana",2.27,32,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":72.64}]
[null,"2022-07-22","West","Bars","Banana",2.27,21,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":47.67}]
[null,"2022-07-23","East","Cookies","Oatmeal Raisin",2.84,98,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":278.32}]
[null,"2022-07-24","West","Bars","Carrot",1.77,174,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":307.98}]
[null,"2022-07-25","West","Snacks","Potato Chips",1.68,57,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":95.759999999999991}]
[null,"2022-07-26","West","Snacks","Potato Chips",1.68,26,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":43.68}]
[null,"2022-07-27","West","Snacks","Potato Chips",1.68,114,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":191.51999999999998}]
[null,"2022-07-28","West","Cookies","Arrowroot",2.1800000000000002,144,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":313.92}]
[null,"2022-07-29","East","Bars","Bran",1.87,34,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":63.580000000000005}]
[null,"2022-07-30","West","Bars","Carrot",1.77,30,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":53.1}]
[null,"2022-07-31","East","Snacks","Potato Chips",1.68,46,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":77.28}]
[null,"2022-08-01","West","Crackers","Whole Wheat",3.49,21,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":73.290000000000006}]
[null,"2022-08-02","East","Cookies","Arrowroot",2.1800000000000002,128,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":279.04000000000002}]
[null,"2022-08-03","West","Snacks","Potato Chips",1.68,41,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":68.88}]
[null,"2022-08-04","East","Snacks","Potato Chips",1.68,30,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":50.4}]
[null,"2022-08-05","East","Snacks","Pretzels",3.15,32,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":100.8}]
[null,"2022-08-06","West","Cookies","Oatmeal Raisin",2.84,102,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":289.68}]
[null,"2022-08-07","West","Cookies","Oatmeal Raisin",2.84,74,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":210.16}]
[null,"2022-08-08","East","Bars","Bran",1.87,27,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":50.49}]
[null,"2022-08-09","East","Snacks","Potato Chips",1.68,28,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":47.04}]
[null,"2022-08-10","West","Bars","Carrot",1.77,37,{"$f":"PRODUCT(SalesTable[[#This Row],[UnitPrice]],SalesTable[[#This Row],[Quantity]])","v":65.489999999999995}]

{"sheet":"Pivot Table","index":1,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Category","Product","Count"]
[null,"Bars",null,791]
[null,null,"Banana",53]
[null,null,"Bran",233]
[null,null,"Carrot",505]
[null,"Cookies",null,905]
[null,null,"Arrowroot",297]
[null,null,"Chocolate Chip",297]
[null,null,"Oatmeal Raisin",311]
[null,"Crackers",null,186]
[null,null,"Cheese",23]
[null,null,"Saltines",55]
[null,null,"Whole Wheat",108]
[null,"Snacks",null,441]
[null,null,"Potato Chips",389]
[null,null,"Pretzels",52]
[null,"Grand Total",null,2323]

{"sheet":"Double Click","index":2,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Category","Product","Number"]
[null,"Bars",null,791]
[null,"Cookies",null,905]
[null,"Crackers",null,186]
[null,"Snacks",null,441]
[null,"Grand Total",null,2323]

{"sheet":"Button","index":3,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Category","Product","Number"]
[null,"Bars",null,791]
[null,"Cookies",null,905]
[null,"Crackers",null,186]
[null,"Snacks",null,441]
[null,"Grand Total",null,2323]

{"sheet":"Context Menu","index":4,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Category","Product","Number"]
[null,"Bars",null,791]
[null,"Cookies",null,905]
[null,"Crackers",null,186]
[null,"Snacks",null,441]
[null,"Grand Total",null,2323]

{"sheet":"Keyboard Shortcuts","index":5,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Category","Product","Number"]
[null,"Bars",null,791]
[null,"Cookies",null,905]
[null,"Crackers",null,186]
[null,"Snacks",null,441]
[null,"Grand Total",null,2323]

{"sheet":"VBA","index":6,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Category","Product","Number"]
[null,"Bars",null,791]
[null,"Cookies",null,905]
[null,"Crackers",null,186]
[null,"Snacks",null,441]
[null,"Grand Total",null,2323]