{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Sample data","Auto","Different Column","Same Column","Table","Filter","Pivot Table","VBA","Pivot","Table6","Power Query"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":1},"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":"Sample data","index":0,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Sales Information of Products"]
[]
[null,"Sales Reps","Category","Product","Quantity (kg)","Unit Price","Total Price","Profit"]
[null,"John","Vegetables","Brocolli",3,29,{"$f":"E5*F5","v":87},{"$f":"G5*0.05","v":4.3500000000000005}]
[null,"Adam","Fruit","Cherry",3,33,99,4.95]
[null,"Emily","Dairy","Milk",3,70,210,10.5]
[null,"Adam","Meat","Beef",3,120,360,18]
[null,"Emily","Fruit","Strawberry",2,50,100,5]
[null,"John","Meat","Mutton",3,150,450,22.5]
[null,"Mary","Vegetables","Carrot",2,25,50,2.5]
[null,"Adam","Fruit","Strawberry",2,42,84,4.2]
[null,"Mary","Vegetables","Brocolli",1,30,30,1.5]
[null,"John","Meat","Chicken",2,65,130,6.5]
[null,"Emily","Fruit","Cherry",4,35,140,7]
[null,"Adam","Meat","Mutton",5,100,500,25]
[null,"Emily","Dairy","Yogurt",4,70,280,14]
[null,"John","Meat","Beef",3,115,345,17.25]

{"sheet":"Auto","index":1,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Inserting Subtotals Automatically"]
[]
[null,"Sales Reps","Category","Product","Quantity (kg)","Unit Price","Total Price","Profit"]
[null,"Adam","Fruit","Cherry",3,33,{"$f":"E5*F5","v":99},{"$f":"G5*0.05","v":4.95}]
[null,"Adam","Meat","Beef",3,120,{"$f":"E6*F6","v":360},{"$f":"G6*0.05","v":18}]
[null,"Adam","Fruit","Strawberry",2,42,{"$f":"E7*F7","v":84},{"$f":"G7*0.05","v":4.2}]
[null,"Adam","Meat","Mutton",5,100,{"$f":"E8*F8","v":500},{"$f":"G8*0.05","v":25}]
[null,"Adam Total",null,null,{"$f":"SUBTOTAL(9,E5:E8)","v":13},null,{"$f":"SUBTOTAL(9,G5:G8)","v":1043},{"$f":"SUBTOTAL(9,H5:H8)","v":52.15}]
[null,"Emily","Dairy","Milk",3,70,{"$f":"E10*F10","v":210},{"$f":"G10*0.05","v":10.5}]
[null,"Emily","Fruit","Strawberry",2,50,{"$f":"E11*F11","v":100},{"$f":"G11*0.05","v":5}]
[null,"Emily","Fruit","Cherry",4,35,{"$f":"E12*F12","v":140},{"$f":"G12*0.05","v":7}]
[null,"Emily","Dairy","Yogurt",4,70,{"$f":"E13*F13","v":280},{"$f":"G13*0.05","v":14}]
[null,"Emily Total",null,null,{"$f":"SUBTOTAL(9,E10:E13)","v":13},null,{"$f":"SUBTOTAL(9,G10:G13)","v":730},{"$f":"SUBTOTAL(9,H10:H13)","v":36.5}]
[null,"John","Vegetables","Brocolli",3,29,{"$f":"E15*F15","v":87},{"$f":"G15*0.05","v":4.3500000000000005}]
[null,"John","Meat","Mutton",3,150,{"$f":"E16*F16","v":450},{"$f":"G16*0.05","v":22.5}]
[null,"John","Meat","Chicken",2,65,{"$f":"E17*F17","v":130},{"$f":"G17*0.05","v":6.5}]
[null,"John","Meat","Beef",3,115,{"$f":"E18*F18","v":345},{"$f":"G18*0.05","v":17.25}]
[null,"John Total",null,null,{"$f":"SUBTOTAL(9,E15:E18)","v":11},null,{"$f":"SUBTOTAL(9,G15:G18)","v":1012},{"$f":"SUBTOTAL(9,H15:H18)","v":50.6}]
[null,"Mary","Vegetables","Carrot",2,25,{"$f":"E20*F20","v":50},{"$f":"G20*0.05","v":2.5}]
[null,"Mary","Vegetables","Brocolli",1,30,{"$f":"E21*F21","v":30},{"$f":"G21*0.05","v":1.5}]
[null,"Mary Total",null,null,{"$f":"SUBTOTAL(9,E20:E21)","v":3},null,{"$f":"SUBTOTAL(9,G20:G21)","v":80},{"$f":"SUBTOTAL(9,H20:H21)","v":4}]
[null,"Grand Total",null,null,{"$f":"SUBTOTAL(9,E5:E21)","v":40},null,{"$f":"SUBTOTAL(9,G5:G21)","v":2865},{"$f":"SUBTOTAL(9,H5:H21)","v":143.25}]

{"sheet":"Different Column","index":2,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Adding Multiple Subtotals"]
[]
[null,"Sales Reps","Category","Product","Quantity (kg)","Unit Price","Total Price","Profit"]
[null,"Adam","Fruit","Cherry",3,33,{"$f":"E5*F5","v":99},{"$f":"G5*0.05","v":4.95}]
[null,"Adam","Fruit","Strawberry",2,42,{"$f":"E6*F6","v":84},{"$f":"G6*0.05","v":4.2}]
[null,null,"Fruit Total",null,{"$f":"SUBTOTAL(9,E5:E6)","v":5},null,{"$f":"SUBTOTAL(9,G5:G6)","v":183},{"$f":"SUBTOTAL(9,H5:H6)","v":9.15}]
[null,"Adam","Meat","Beef",3,120,{"$f":"E8*F8","v":360},{"$f":"G8*0.05","v":18}]
[null,"Adam","Meat","Mutton",5,100,{"$f":"E9*F9","v":500},{"$f":"G9*0.05","v":25}]
[null,null,"Meat Total",null,{"$f":"SUBTOTAL(9,E8:E9)","v":8},null,{"$f":"SUBTOTAL(9,G8:G9)","v":860},{"$f":"SUBTOTAL(9,H8:H9)","v":43}]
[null,"Adam Total",null,null,{"$f":"SUBTOTAL(9,E5:E9)","v":13},null,{"$f":"SUBTOTAL(9,G5:G9)","v":1043},{"$f":"SUBTOTAL(9,H5:H9)","v":52.15}]
[null,"Emily","Dairy","Milk",3,70,{"$f":"E12*F12","v":210},{"$f":"G12*0.05","v":10.5}]
[null,"Emily","Dairy","Yogurt",4,70,{"$f":"E13*F13","v":280},{"$f":"G13*0.05","v":14}]
[null,null,"Dairy Total",null,{"$f":"SUBTOTAL(9,E12:E13)","v":7},null,{"$f":"SUBTOTAL(9,G12:G13)","v":490},{"$f":"SUBTOTAL(9,H12:H13)","v":24.5}]
[null,"Emily","Fruit","Strawberry",2,50,{"$f":"E15*F15","v":100},{"$f":"G15*0.05","v":5}]
[null,"Emily","Fruit","Cherry",4,35,{"$f":"E16*F16","v":140},{"$f":"G16*0.05","v":7}]
[null,null,"Fruit Total",null,{"$f":"SUBTOTAL(9,E15:E16)","v":6},null,{"$f":"SUBTOTAL(9,G15:G16)","v":240},{"$f":"SUBTOTAL(9,H15:H16)","v":12}]
[null,"Emily Total",null,null,{"$f":"SUBTOTAL(9,E12:E16)","v":13},null,{"$f":"SUBTOTAL(9,G12:G16)","v":730},{"$f":"SUBTOTAL(9,H12:H16)","v":36.5}]
[null,"John","Meat","Mutton",3,150,{"$f":"E19*F19","v":450},{"$f":"G19*0.05","v":22.5}]
[null,"John","Meat","Chicken",2,65,{"$f":"E20*F20","v":130},{"$f":"G20*0.05","v":6.5}]
[null,"John","Meat","Beef",3,115,{"$f":"E21*F21","v":345},{"$f":"G21*0.05","v":17.25}]
[null,null,"Meat Total",null,{"$f":"SUBTOTAL(9,E19:E21)","v":8},null,{"$f":"SUBTOTAL(9,G19:G21)","v":925},{"$f":"SUBTOTAL(9,H19:H21)","v":46.25}]
[null,"John","Vegetables","Brocolli",3,29,{"$f":"E23*F23","v":87},{"$f":"G23*0.05","v":4.3500000000000005}]
[null,null,"Vegetables Total",null,{"$f":"SUBTOTAL(9,E23:E23)","v":3},null,{"$f":"SUBTOTAL(9,G23:G23)","v":87},{"$f":"SUBTOTAL(9,H23:H23)","v":4.3500000000000005}]
[null,"John Total",null,null,{"$f":"SUBTOTAL(9,E19:E23)","v":11},null,{"$f":"SUBTOTAL(9,G19:G23)","v":1012},{"$f":"SUBTOTAL(9,H19:H23)","v":50.6}]
[null,"Mary","Vegetables","Carrot",2,25,{"$f":"E26*F26","v":50},{"$f":"G26*0.05","v":2.5}]
[null,"Mary","Vegetables","Brocolli",1,30,{"$f":"E27*F27","v":30},{"$f":"G27*0.05","v":1.5}]
[null,null,"Vegetables Total",null,{"$f":"SUBTOTAL(9,E26:E27)","v":3},null,{"$f":"SUBTOTAL(9,G26:G27)","v":80},{"$f":"SUBTOTAL(9,H26:H27)","v":4}]
[null,"Mary Total",null,null,{"$f":"SUBTOTAL(9,E26:E27)","v":3},null,{"$f":"SUBTOTAL(9,G26:G27)","v":80},{"$f":"SUBTOTAL(9,H26:H27)","v":4}]
[null,"Grand Total",null,null,{"$f":"SUBTOTAL(9,E5:E27)","v":40},null,{"$f":"SUBTOTAL(9,G5:G27)","v":2865},{"$f":"SUBTOTAL(9,H5:H27)","v":143.25}]

{"sheet":"Same Column","index":3,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Finding Multiple Subtotals in Same Column"]
[]
[null,"Sales Reps","Category","Product","Quantity (kg)","Unit Price","Total Price","Profit"]
[null,"Adam","Fruit","Cherry",3,33,{"$f":"E5*F5","v":99},{"$f":"G5*0.05","v":4.95}]
[null,"Adam","Meat","Beef",3,120,{"$f":"E6*F6","v":360},{"$f":"G6*0.05","v":18}]
[null,"Adam","Fruit","Strawberry",2,42,{"$f":"E7*F7","v":84},{"$f":"G7*0.05","v":4.2}]
[null,"Adam","Meat","Mutton",5,100,{"$f":"E8*F8","v":500},{"$f":"G8*0.05","v":25}]
[null,"Adam StdDev",null,null,{"$f":"SUBTOTAL(7,E5:E8)","v":1.2583057392117916},null,{"$f":"SUBTOTAL(7,G5:G8)","v":203.71119262328224},{"$f":"SUBTOTAL(7,H5:H8)","v":10.185559631164111}]
[null,"Adam Average",null,null,{"$f":"SUBTOTAL(1,E5:E8)","v":3.25},null,{"$f":"SUBTOTAL(1,G5:G8)","v":260.75},{"$f":"SUBTOTAL(1,H5:H8)","v":13.0375}]
[null,"Adam Total",null,null,{"$f":"SUBTOTAL(9,E5:E8)","v":13},null,{"$f":"SUBTOTAL(9,G5:G8)","v":1043},{"$f":"SUBTOTAL(9,H5:H8)","v":52.15}]
[null,"Emily","Dairy","Milk",3,70,{"$f":"E12*F12","v":210},{"$f":"G12*0.05","v":10.5}]
[null,"Emily","Fruit","Strawberry",2,50,{"$f":"E13*F13","v":100},{"$f":"G13*0.05","v":5}]
[null,"Emily","Fruit","Cherry",4,35,{"$f":"E14*F14","v":140},{"$f":"G14*0.05","v":7}]
[null,"Emily","Dairy","Yogurt",4,70,{"$f":"E15*F15","v":280},{"$f":"G15*0.05","v":14}]
[null,"Emily StdDev",null,null,{"$f":"SUBTOTAL(7,E12:E15)","v":0.9574271077563381},null,{"$f":"SUBTOTAL(7,G12:G15)","v":79.320026895271965},{"$f":"SUBTOTAL(7,H12:H15)","v":3.966001344763598}]
[null,"Emily Average",null,null,{"$f":"SUBTOTAL(1,E12:E15)","v":3.25},null,{"$f":"SUBTOTAL(1,G12:G15)","v":182.5},{"$f":"SUBTOTAL(1,H12:H15)","v":9.125}]
[null,"Emily Total",null,null,{"$f":"SUBTOTAL(9,E12:E15)","v":13},null,{"$f":"SUBTOTAL(9,G12:G15)","v":730},{"$f":"SUBTOTAL(9,H12:H15)","v":36.5}]
[null,"John","Vegetables","Brocolli",3,29,{"$f":"E19*F19","v":87},{"$f":"G19*0.05","v":4.3500000000000005}]
[null,"John","Meat","Mutton",3,150,{"$f":"E20*F20","v":450},{"$f":"G20*0.05","v":22.5}]
[null,"John","Meat","Chicken",2,65,{"$f":"E21*F21","v":130},{"$f":"G21*0.05","v":6.5}]
[null,"John","Meat","Beef",3,115,{"$f":"E22*F22","v":345},{"$f":"G22*0.05","v":17.25}]
[null,"John StdDev",null,null,{"$f":"SUBTOTAL(7,E19:E22)","v":0.5},null,{"$f":"SUBTOTAL(7,G19:G22)","v":173.16466152191677},{"$f":"SUBTOTAL(7,H19:H22)","v":8.6582330760958381}]
[null,"John Average",null,null,{"$f":"SUBTOTAL(1,E19:E22)","v":2.75},null,{"$f":"SUBTOTAL(1,G19:G22)","v":253},{"$f":"SUBTOTAL(1,H19:H22)","v":12.65}]
[null,"John Total",null,null,{"$f":"SUBTOTAL(9,E19:E22)","v":11},null,{"$f":"SUBTOTAL(9,G19:G22)","v":1012},{"$f":"SUBTOTAL(9,H19:H22)","v":50.6}]
[null,"Mary","Vegetables","Carrot",2,25,{"$f":"E26*F26","v":50},{"$f":"G26*0.05","v":2.5}]
[null,"Mary","Vegetables","Brocolli",1,30,{"$f":"E27*F27","v":30},{"$f":"G27*0.05","v":1.5}]
[null,"Mary StdDev",null,null,{"$f":"SUBTOTAL(7,E26:E27)","v":0.70710678118654757},null,{"$f":"SUBTOTAL(7,G26:G27)","v":14.142135623730951},{"$f":"SUBTOTAL(7,H26:H27)","v":0.70710678118654757}]
[null,"Mary Average",null,null,{"$f":"SUBTOTAL(1,E26:E27)","v":1.5},null,{"$f":"SUBTOTAL(1,G26:G27)","v":40},{"$f":"SUBTOTAL(1,H26:H27)","v":2}]
[null,"Mary Total",null,null,{"$f":"SUBTOTAL(9,E26:E27)","v":3},null,{"$f":"SUBTOTAL(9,G26:G27)","v":80},{"$f":"SUBTOTAL(9,H26:H27)","v":4}]
[null,"Grand StdDev",null,null,{"$f":"SUBTOTAL(7,E5:E27)","v":1.0271051820261907},null,{"$f":"SUBTOTAL(7,G5:G27)","v":154.83222043075043},{"$f":"SUBTOTAL(7,H5:H27)","v":7.7416110215375191}]
[null,"Grand Average",null,null,{"$f":"SUBTOTAL(1,E5:E27)","v":2.8571428571428572},null,{"$f":"SUBTOTAL(1,G5:G27)","v":204.64285714285714},{"$f":"SUBTOTAL(1,H5:H27)","v":10.232142857142858}]
[null,"Grand Total",null,null,{"$f":"SUBTOTAL(9,E5:E27)","v":40},null,{"$f":"SUBTOTAL(9,G5:G27)","v":2865},{"$f":"SUBTOTAL(9,H5:H27)","v":143.25}]

{"sheet":"Table","index":4,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Inserting Subtotals to Excel Table"]
[]
[null,"Sales Reps","Category","Product","Quantity (kg)","Unit Price","Total Price","Profit"]
[null,"John","Vegetables","Brocolli",3,29,{"$f":"E5*F5","v":87},{"$f":"G5*0.05","v":4.3500000000000005}]
[null,"Adam","Fruit","Cherry",3,33,99,4.95]
[null,"Emily","Dairy","Milk",3,70,210,10.5]
[null,"Adam","Meat","Beef",3,120,360,18]
[null,"Emily","Fruit","Strawberry",2,50,100,5]
[null,"John","Meat","Mutton",3,150,450,22.5]
[null,"Mary","Vegetables","Carrot",2,25,50,2.5]
[null,"Adam","Fruit","Strawberry",2,42,84,4.2]
[null,"Mary","Vegetables","Brocolli",1,30,30,1.5]
[null,"John","Meat","Chicken",2,65,130,6.5]
[null,"Emily","Fruit","Cherry",4,35,140,7]
[null,"Adam","Meat","Mutton",5,100,500,25]
[null,"Emily","Dairy","Yogurt",4,70,280,14]
[null,"John","Meat","Beef",3,115,345,17.25]

{"sheet":"Filter","index":5,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Manually Hidden Rows"]
[]
[null,"Sales Reps","Category","Product","Quantity (kg)","Unit Price","Total Price","Profit"]
[null,"John","Vegetables","Brocolli",3,29,{"$f":"E5*F5","v":87},{"$f":"G5*0.05","v":4.3500000000000005}]
[null,"Adam","Fruit","Cherry",3,33,99,4.95]
[null,"Emily","Dairy","Milk",3,70,210,10.5]
[null,"Adam","Meat","Beef",3,120,360,18]
[null,"Emily","Fruit","Strawberry",2,50,100,5]
[null,"John","Meat","Mutton",3,150,450,22.5]
[null,"Mary","Vegetables","Carrot",2,25,50,2.5]
[null,"Adam","Fruit","Strawberry",2,42,84,4.2]
[null,"Mary","Vegetables","Brocolli",1,30,30,1.5]
[null,"John","Meat","Chicken",2,65,130,6.5]
[null,"Emily","Fruit","Cherry",4,35,140,7]
[null,"Adam","Meat","Mutton",5,100,500,25]
[null,"Emily","Dairy","Yogurt",4,70,280,14]
[null,"John","Meat","Beef",3,115,345,17.25]
[null,"Grand Total",null,null,{"$f":"SUBTOTAL(109,E5:E18)","v":30},null,{"$f":"SUBTOTAL(9,G5:G18)","v":2865},{"$f":"SUBTOTAL(109,H5:H18)","v":107.65}]

{"sheet":"Pivot Table","index":6,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Inserting Subtotals in Pivot Table"]
[]
[null,"Sales Reps","(All)"]
[]
[null,"Row Labels","Sum of Quantity (kg)","Sum of Unit Price","Sum of Total Price","Sum of Profit"]
[null,"Dairy"]
[null,"Milk",3,70,210,10.5]
[null,"Yogurt",4,70,280,14]
[null,"Dairy Total",7,140,490,24.5]
[null,"Fruit"]
[null,"Cherry",7,68,239,11.95]
[null,"Strawberry",4,92,184,9.1999999999999993]
[null,"Fruit Total",11,160,423,21.15]
[null,"Meat"]
[null,"Beef",6,235,705,35.25]
[null,"Chicken",2,65,130,6.5]
[null,"Mutton",8,250,950,47.5]
[null,"Meat Total",16,550,1785,89.25]
[null,"Vegetables"]
[null,"Brocolli",4,59,117,5.8500000000000005]
[null,"Carrot",2,25,50,2.5]
[null,"Vegetables Total",6,84,167,8.3500000000000014]
[null,"(blank)"]
[null,"(blank)",null,null,2865,143.25]
[null,"(blank) Total",null,null,2865,143.25]
[null,"Grand Total",40,934,5730,286.5]

{"sheet":"VBA","index":7,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Using VBA Code"]
[]
[null,"Sales Reps","Category","Product","Quantity (kg)","Unit Price","Total Price","Profit"]
[null,"Adam","Fruit","Cherry",3,33,{"$f":"E5*F5","v":99},{"$f":"G5*0.05","v":4.95}]
[null,"Adam","Meat","Beef",3,120,{"$f":"E6*F6","v":360},{"$f":"G6*0.05","v":18}]
[null,"Adam","Fruit","Strawberry",2,42,{"$f":"E7*F7","v":84},{"$f":"G7*0.05","v":4.2}]
[null,"Adam","Meat","Mutton",5,100,{"$f":"E8*F8","v":500},{"$f":"G8*0.05","v":25}]
[null,"Subtotal Adam",null,null,null,null,{"$f":"SUM(G$5:G$8)","v":1043},{"$f":"SUM(H$5:H$8)","v":52.15}]
[null,"Emily","Dairy","Milk",3,70,{"$f":"E10*F10","v":210},{"$f":"G10*0.05","v":10.5}]
[null,"Emily","Fruit","Strawberry",2,50,{"$f":"E11*F11","v":100},{"$f":"G11*0.05","v":5}]
[null,"Emily","Fruit","Cherry",4,35,{"$f":"E12*F12","v":140},{"$f":"G12*0.05","v":7}]
[null,"Emily","Dairy","Yogurt",4,70,{"$f":"E13*F13","v":280},{"$f":"G13*0.05","v":14}]
[null,"Subtotal Emily",null,null,null,null,{"$f":"SUM(G$10:G$13)","v":730},{"$f":"SUM(H$10:H$13)","v":36.5}]
[null,"John","Vegetables","Brocolli",3,29,{"$f":"E15*F15","v":87},{"$f":"G15*0.05","v":4.3500000000000005}]
[null,"John","Meat","Mutton",3,150,{"$f":"E16*F16","v":450},{"$f":"G16*0.05","v":22.5}]
[null,"John","Meat","Chicken",2,65,{"$f":"E17*F17","v":130},{"$f":"G17*0.05","v":6.5}]
[null,"John","Meat","Beef",3,115,{"$f":"E18*F18","v":345},{"$f":"G18*0.05","v":17.25}]
[null,"Subtotal John",null,null,null,null,{"$f":"SUM(G$15:G$18)","v":1012},{"$f":"SUM(H$15:H$18)","v":50.6}]
[null,"Mary","Vegetables","Carrot",2,25,{"$f":"E20*F20","v":50},{"$f":"G20*0.05","v":2.5}]
[null,"Mary","Vegetables","Brocolli",1,30,{"$f":"E21*F21","v":30},{"$f":"G21*0.05","v":1.5}]
[null,"Subtotal Mary",null,null,null,null,{"$f":"SUM(G$20:G$21)","v":80},{"$f":"SUM(H$20:H$21)","v":4}]

{"sheet":"Pivot","index":8,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Using VBA Code"]
[]
[null,"Sales Reps","Category","Product","Quantity (kg)","Unit Price","Total Price","Profit"]
[null,"John","Vegetables","Brocolli",3,29,{"$f":"E5*F5","v":87},{"$f":"G5*0.05","v":4.3500000000000005}]
[null,"Adam","Fruit","Cherry",3,33,99,4.95]
[null,"Emily","Dairy","Milk",3,70,210,10.5]
[null,"Adam","Meat","Beef",3,120,360,18]
[null,"Emily","Fruit","Strawberry",2,50,100,5]
[null,"John","Meat","Mutton",3,150,450,22.5]
[null,"Mary","Vegetables","Carrot",2,25,50,2.5]
[null,"Adam","Fruit","Strawberry",2,42,84,4.2]
[null,"Mary","Vegetables","Brocolli",1,30,30,1.5]
[null,"John","Meat","Chicken",2,65,130,6.5]
[null,"Emily","Fruit","Cherry",4,35,140,7]
[null,"Adam","Meat","Mutton",5,100,500,25]
[null,"Emily","Dairy","Yogurt",4,70,280,14]
[null,"John","Meat","Beef",3,115,345,17.25]

{"sheet":"Table6","index":9,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Subtotals in Power Query"]
[]
[null,"Sales Reps","Category","Total Price","Profit"]
[null,"John","Vegetables",87,4.3499999999999996]
[null,"Adam","Fruit",183,9.15]
[null,"Emily","Dairy",490,24.5]
[null,"Adam","Meat",860,43]
[null,"Emily","Fruit",240,12]
[null,"John","Meat",925,46.25]
[null,"Mary","Vegetables",80,4]

{"sheet":"Power Query","index":10,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Using Power Query"]
[]
[null,"Sales Reps","Category","Product","Quantity (kg)","Unit Price","Total Price","Profit"]
[null,"John","Vegetables","Brocolli",3,29,{"$f":"E5*F5","v":87},{"$f":"G5*0.05","v":4.3500000000000005}]
[null,"Adam","Fruit","Cherry",3,33,99,4.95]
[null,"Emily","Dairy","Milk",3,70,210,10.5]
[null,"Adam","Meat","Beef",3,120,360,18]
[null,"Emily","Fruit","Strawberry",2,50,100,5]
[null,"John","Meat","Mutton",3,150,450,22.5]
[null,"Mary","Vegetables","Carrot",2,25,50,2.5]
[null,"Adam","Fruit","Strawberry",2,42,84,4.2]
[null,"Mary","Vegetables","Brocolli",1,30,30,1.5]
[null,"John","Meat","Chicken",2,65,130,6.5]
[null,"Emily","Fruit","Cherry",4,35,140,7]
[null,"Adam","Meat","Mutton",5,100,500,25]
[null,"Emily","Dairy","Yogurt",4,70,280,14]
[null,"John","Meat","Beef",3,115,345,17.25]