{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Dataset","Autofill","column","Table","array","VBA","copy paste","Ctrl+D","CTRL+R","Non-adjacent","Ctrl+CLick","find formula","evaluate"],"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":"Dataset","index":0,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Sales Data of Amigo Super Store"]
[]
[null,"Sales Person","Product","Unit Price","Sales Unit (June)","Sales Unit (July)"]
[null,"Jenny","Apple",3,30000,7500]
[null,"Mike","Banana",2,25000,16000]
[null,"Ammy","Avocado",5,18000,21000]
[null,"Ross","Grapes",4,26000,19500]
[null,"Colin","Strawberry",3,15000,25000]
[null,"Diego","Water-melon",6,12500,14000]
[null,"Total"]

{"sheet":"Autofill","index":1,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Sales Data of Amigo Super Store"]
[]
[null,"Sales Person","Product","Sales Unit (June)","Sales Unit (July)","Increase/Decrease"]
[null,"Jenny","Apple",30000,7500,{"$f":"E6-D6","v":-22500}]
[null,"Mike","Banana",25000,16000,{"$f":"E7-D7","v":-9000}]
[null,"Ammy","Avocado",18000,21000,3000]
[null,"Ross","Grapes",26000,19500,-6500]
[null,"Colin","Strawberry",15000,25000,10000]
[null,"Diego","Water-melon",12500,14000,1500]
[null,"Total"]

{"sheet":"column","index":2,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Sales Data of Amigo Super Store)"]
[]
[null,"Sales Person","Product","Sales Unit (June)","Sales Unit (July)","Increase/Decrease"]
[null,"Jenny","Apple",30000,7500,{"$f":"E6-D6","v":-22500}]
[null,"Mike","Banana",25000,16000,{"$f":"E7-D7","v":-9000}]
[null,"Ammy","Avocado",18000,21000,3000]
[null,"Ross","Grapes",26000,19500,-6500]
[null,"Colin","Strawberry",15000,25000,10000]
[null,"Diego","Water-melon",12500,14000,1500]
[null,"Total"]

{"sheet":"Table","index":3,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Sales Data of Amigo Super Store "]
[]
[null,"Sales Person","Product","Sales Unit (June)","Sales Unit (July)","Increase/Decrease"]
[null,"Jenny","Apple",30000,7500,{"$f":"Table1[[#This Row],[Sales Unit (July)]]-Table1[[#This Row],[Sales Unit (June)]]","v":-22500}]
[null,"Mike","Banana",25000,16000,{"$f":"Table1[[#This Row],[Sales Unit (July)]]-Table1[[#This Row],[Sales Unit (June)]]","v":-9000}]
[null,"Ammy","Avocado",18000,21000,{"$f":"Table1[[#This Row],[Sales Unit (July)]]-Table1[[#This Row],[Sales Unit (June)]]","v":3000}]
[null,"Ross","Grapes",26000,19500,{"$f":"Table1[[#This Row],[Sales Unit (July)]]-Table1[[#This Row],[Sales Unit (June)]]","v":-6500}]
[null,"Colin","Strawberry",15000,25000,{"$f":"Table1[[#This Row],[Sales Unit (July)]]-Table1[[#This Row],[Sales Unit (June)]]","v":10000}]
[null,"Diego","Water-melon",12500,14000,{"$f":"Table1[[#This Row],[Sales Unit (July)]]-Table1[[#This Row],[Sales Unit (June)]]","v":1500}]
[null,"Total"]

{"sheet":"array","index":4,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Sales Data of Amigo Super Store"]
[]
[null,"Sales Person","Product","Sales Unit (June)","Sales Unit (July)","Increase/Decrease"]
[null,"Jenny","Apple",30000,7500,{"$f":"E6:E11-D6:D11","v":-22500}]
[null,"Mike","Banana",25000,16000,-9000]
[null,"Ammy","Avocado",18000,21000,3000]
[null,"Ross","Grapes",26000,19500,-6500]
[null,"Colin","Strawberry",15000,25000,10000]
[null,"Diego","Water-melon",12500,14000,1500]
[null,"Total"]

{"sheet":"VBA","index":5,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Sales Data of Amigo Super Store"]
[]
[null,"Sales Person","Product","Sales Unit (June)","Sales Unit (July)","Increase or Decrease"]
[null,"Jenny","Apple",30000,7500,{"$f":"E6:E11-D6:D11","v":-22500}]
[null,"Mike","Banana",25000,16000,-9000]
[null,"Ammy","Avocado",18000,21000,3000]
[null,"Ross","Grapes",26000,19500,-6500]
[null,"Colin","Strawberry",15000,25000,10000]
[null,"Diego","Water-melon",12500,14000,1500]
[null,"Total"]

{"sheet":"copy paste","index":6,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,2,6]]}
[]
[]
[null,"Sales Data of Amigo Super Store"]
[]
[null,"Sales Person","Product","Price (May)","Price (June)","Price (July)","Price (Aug)"]
[null,"Jenny","Apple",3,{"$f":"$D6-$D6*E$13","v":2.64},{"$f":"$D6-$D6*F$13","v":2.76},2.5499999999999998]
[null,"Mike","Banana",2,{"$f":"$D7-$D7*E$13","v":1.76},1.84,1.7]
[null,"Ammy","Avocado",5]
[null,"Ross","Grapes",4]
[null,"Colin","Strawberry",3]
[null,"Diego","Water-melon",6]
[]
[null,null,null,"Discount",0.12,0.08,0.15]
[]
[]
[null,"Total"]

{"sheet":"Ctrl+D","index":7,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,2,6]]}
[]
[]
[null,"Sales Data of Amigo Super Store"]
[]
[null,"Sales Person","Product","Price (May)","Price (June)","Price (July)","Price (Aug)"]
[null,"Jenny","Apple",3,{"$f":"$D6-$D6*$E$13","v":2.64}]
[null,"Mike","Banana",2,1.76]
[null,"Ammy","Avocado",5,4.4000000000000004]
[null,"Ross","Grapes",4,3.52]
[null,"Colin","Strawberry",3,2.64]
[null,"Diego","Water-melon",6,5.28]
[]
[null,null,null,"Discount",0.12,0.08,0.15]
[]
[]
[null,"Total"]

{"sheet":"CTRL+R","index":8,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,2,6]]}
[]
[]
[null,"Sales Data of Amigo Super Store"]
[]
[null,"Sales Person","Product","Price (May)","Price (June)","Price (July)","Price (Aug)"]
[null,"Jenny","Apple",3,{"$f":"$D6-$D6*E$13","v":2.64},{"$f":"$D6-$D6*F$13","v":2.76}]
[null,"Mike","Banana",2,{"$f":"$D7-$D7*E$13","v":1.76},1.84]
[null,"Ammy","Avocado",5,4.4000000000000004,4.5999999999999996]
[null,"Ross","Grapes",4,3.52,3.68]
[null,"Colin","Strawberry",3,2.64,2.76]
[null,"Diego","Water-melon",6,5.28,5.52]
[]
[null,null,null,"Discount",0.12,0.08,0.15]
[]
[]
[null,"Total"]

{"sheet":"Non-adjacent","index":9,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,2,6]]}
[]
[]
[null,"Sales Data of Amigo Super Store"]
[]
[null,"Sales Person","Product","Price (May)","Price (June)","Price (July)","Price (Aug)"]
[null,"Jenny","Apple",3,{"$f":"$D6-$D6*E$13","v":2.64},{"$f":"$D6-$D6*F$13","v":2.76},2.5499999999999998]
[]
[null,"Ammy","Avocado",5,{"$f":"$D8-$D8*E$13","v":4.4000000000000004},4.5999999999999996,4.25]
[null,"Ross","Grapes",4,3.52,3.68,3.4]
[]
[null,"Diego","Water-melon",6,{"$f":"$D11-$D11*E$13","v":5.28},5.52,5.0999999999999996]
[]
[null,null,null,"Discount",0.12,0.08,0.15]
[]
[]
[null,"Total"]

{"sheet":"Ctrl+CLick","index":10,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,1,2,6]]}
[]
[]
[null,"Sales Data of Amigo Super Store"]
[]
[null,"Sales Person","Product","Price (May)","Price (June)","Price (July)","Price (Aug)"]
[null,"Jenny","Apple",3,{"$f":"$D6-$D6*E$13","v":2.64},{"$f":"$D6-$D6*F$13","v":2.76},2.5499999999999998]
[]
[null,"Ammy","Avocado",5,{"$f":"$D8-$D8*E$13","v":4.4000000000000004},4.5999999999999996,4.25]
[null,"Ross","Grapes",4,3.52,3.68,3.4]
[]
[null,"Diego","Water-melon",6,{"$f":"$D11-$D11*E$13","v":5.28},{"$f":"$D11-$D11*F$13","v":5.52},5.0999999999999996]
[]
[null,null,null,"Discount",0.12,0.08,0.15]
[]
[null,null,"Average",{"$f":"AVERAGE(D6,D8,D9,D11)","v":4.5},{"$f":"AVERAGE(E6,E8,E9,E11)","v":3.96},{"$f":"AVERAGE(F6,F8,F9,F11)","v":4.1399999999999997},3.8249999999999997]
[]
[]
[null,"Total"]

{"sheet":"find formula","index":11,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,1,2,6]]}
[]
[]
[null,"Sales Data of Amigo Super Store"]
[]
[null,"Sales Person","Product","Price (May)","Price (June)","Price (July)","Price (Aug)"]
[null,"Jenny","Apple",3,{"$f":"$D6-$D6*E$13","v":2.64},{"$f":"$D6-$D6*F$13","v":2.76},2.5499999999999998]
[null,"Mark","-","-","-","-","-"]
[null,"Ammy","Avocado",5,{"$f":"$D8-$D8*E$13","v":4.4000000000000004},4.5999999999999996,4.25]
[null,"Ross","Grapes",4,3.52,3.68,3.4]
[null,"Damien","-","-","-","-","-"]
[null,"Diego","Water-melon",6,{"$f":"$D11-$D11*E$13","v":5.28},{"$f":"$D11-$D11*F$13","v":5.52},5.0999999999999996]
[]
[null,null,null,"Discount",0.12,0.08,0.15]
[]
[null,null,"Average",{"$f":"AVERAGE(D6,D8,D9,D11)","v":4.5},{"$f":"AVERAGE(E6,E8,E9,E11)","v":3.96},4.1399999999999997,3.8249999999999997]
[]
[]
[null,"Total"]

{"sheet":"evaluate","index":12,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Sales Data of Amigo Super Store"]
[]
[null,"Sales Person","Product","Unit Price","Status"]
[null,"Jenny","Apple",3,{"$f":"IF(D6>3.5,\"Costly\",\"Cheap\")","v":"Cheap"}]
[null,"Mike","Banana",2,{"$f":"IF(D7>3.5,\"Costly\",\"Cheap\")","v":"Cheap"}]
[null,"Ammy","Avocado",5,"Costly"]
[null,"Ross","Grapes",4,"Costly"]
[null,"Colin","Strawberry",3,"Cheap"]
[null,"Diego","Water-melon",6,"Costly"]
[null,"Total"]