{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["dataset","copy paste","keyboard shortcut","vba","Table1","Table3","power query","mouse drag","text","concatenate"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Convert Formula Result to Text String"]
[]
[null,"Date","Product","Price","Discount","Sales Price"]
[null,{"$f":"TODAY()","v":44729},"Mustard - Individual Pkg",2.52,0.02,{"$f":"D5*(1-E5)","v":2.4695999999999998}]
[null,{"$f":"TODAY()","v":44729},"Lamb - Pieces, Diced",9.92,0,{"$f":"D6*(1-E6)","v":9.92}]
[null,44729,"Vinegar - Tarragon",2.4500000000000002,1.2500000000000001E-2,2.4193750000000005]
[null,44729,"Oregano - Fresh",9.11,0.1,8.1989999999999998]
[null,44729,"Soup - Clam Chowder, Dry Mix",4.6900000000000004,0,4.6900000000000004]
[null,44729,"Wine - Red, Gallo, Merlot",4.76,0.03,4.6171999999999995]
[null,"Total Sales",null,null,null,{"$f":"SUM(F5:F10)","v":32.315175000000004}]

{"sheet":"copy paste","index":1,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using Copy & Paste Feature"]
[]
[null,"Date","Product","Price","Discount","Sales Price"]
[null,"16-06-2022","Mustard - Individual Pkg",2.52,0.02,2.4695999999999998]
[null,"16-06-2022","Lamb - Pieces, Diced",9.92,0,9.92]
[null,"16-06-2022","Vinegar - Tarragon",2.4500000000000002,1.2500000000000001E-2,2.4193750000000005]
[null,"16-06-2022","Oregano - Fresh",9.11,0.1,8.1989999999999998]
[null,"16-06-2022","Soup - Clam Chowder, Dry Mix",4.6900000000000004,0,4.6900000000000004]
[null,"16-06-2022","Wine - Red, Gallo, Merlot",4.76,0.03,4.6171999999999995]
[null,"Total Sales",null,null,null,32.315175000000004]

{"sheet":"keyboard shortcut","index":2,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using Keyboard Shortcut"]
[]
[null,"Date","Product","Price","Discount","Sales Price"]
[null,"16-06-2022","Mustard - Individual Pkg",2.52,0.02,2.4695999999999998]
[null,"16-06-2022","Lamb - Pieces, Diced",9.92,0,9.92]
[null,"16-06-2022","Vinegar - Tarragon",2.4500000000000002,1.2500000000000001E-2,2.4193750000000005]
[null,"16-06-2022","Oregano - Fresh",9.11,0.1,8.1989999999999998]
[null,"16-06-2022","Soup - Clam Chowder, Dry Mix",4.6900000000000004,0,4.6900000000000004]
[null,"16-06-2022","Wine - Red, Gallo, Merlot",4.76,0.03,4.6171999999999995]
[null,"Total Sales",null,null,null,32.315175000000004]

{"sheet":"vba","index":3,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using VBA"]
[]
[null,"Date","Product","Price","Discount","Sales Price"]
[null,"17-06-2022","Mustard - Individual Pkg",2.52,0.02,2.4695999999999998]
[null,"17-06-2022","Lamb - Pieces, Diced",9.92,0,9.92]
[null,"17-06-2022","Vinegar - Tarragon",2.4500000000000002,1.2500000000000001E-2,2.4193750000000005]
[null,"17-06-2022","Oregano - Fresh",9.11,0.1,8.1989999999999998]
[null,"17-06-2022","Soup - Clam Chowder, Dry Mix",4.6900000000000004,0,4.6900000000000004]
[null,"17-06-2022","Wine - Red, Gallo, Merlot",4.76,0.03,4.6171999999999995]
[null,"Total Sales",null,null,null,32.315175000000004]

{"sheet":"Table1","index":4,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Date","Product","Price","Discount","Sales Price"]
[44728,"Mustard - Individual Pkg",2.52,0.02,2.4695999999999998]
[44728,"Lamb - Pieces, Diced",9.92,0,9.92]
[44728,"Vinegar - Tarragon",2.4500000000000002,0,2.4500000000000002]
[44728,"Oregano - Fresh",9.11,0.1,8.1989999999999998]
[44728,"Soup - Clam Chowder, Dry Mix",4.6900000000000004,0,4.6900000000000004]
[44728,"Wine - Red, Gallo, Merlot",4.76,0.03,4.6172000000000004]
["Total Sales",null,null,null,32.345799999999997]

{"sheet":"Table3","index":5,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Date","Product","Price","Discount","Sales Price"]
[44729,"Mustard - Individual Pkg",2.52,0.02,2.4695999999999998]
[44729,"Lamb - Pieces, Diced",9.92,0,9.92]
[44729,"Vinegar - Tarragon",2.4500000000000002,1.2500000000000001E-2,2.4194]
[44729,"Oregano - Fresh",9.11,0.1,8.1989999999999998]
[44729,"Soup - Clam Chowder, Dry Mix",4.6900000000000004,0,4.6900000000000004]
[44729,"Wine - Red, Gallo, Merlot",4.76,0.03,4.6172000000000004]
["Total Sales",null,null,null,32.315199999999997]

{"sheet":"power query","index":6,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using Power Query Editor"]
[]
[null,"Date","Product","Price","Discount","Sales Price"]
[null,{"$f":"TODAY()","v":44729},"Mustard - Individual Pkg",2.52,0.02,{"$f":"D5*(1-E5)","v":2.4695999999999998}]
[null,{"$f":"TODAY()","v":44729},"Lamb - Pieces, Diced",9.92,0,{"$f":"D6*(1-E6)","v":9.92}]
[null,44729,"Vinegar - Tarragon",2.4500000000000002,1.2500000000000001E-2,2.4193750000000005]
[null,44729,"Oregano - Fresh",9.11,0.1,8.1989999999999998]
[null,44729,"Soup - Clam Chowder, Dry Mix",4.6900000000000004,0,4.6900000000000004]
[null,44729,"Wine - Red, Gallo, Merlot",4.76,0.03,4.6171999999999995]
[null,"Total Sales",null,null,null,{"$f":"SUM(F5:F10)","v":32.315175000000004}]

{"sheet":"mouse drag","index":7,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Dragging Cells by Mouse"]
[]
[null,"Date","Product","Price","Discount","Sales Price"]
[null,"17-06-2022","Mustard - Individual Pkg",2.52,0.02,2.4695999999999998]
[null,"17-06-2022","Lamb - Pieces, Diced",9.92,0,9.92]
[null,"17-06-2022","Vinegar - Tarragon",2.4500000000000002,1.2500000000000001E-2,2.4193750000000005]
[null,"17-06-2022","Oregano - Fresh",9.11,0.1,8.1989999999999998]
[null,"17-06-2022","Soup - Clam Chowder, Dry Mix",4.6900000000000004,0,4.6900000000000004]
[null,"17-06-2022","Wine - Red, Gallo, Merlot",4.76,0.03,4.6171999999999995]
[null,"Total Sales",null,null,null,32.315175000000004]

{"sheet":"text","index":8,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,7,1,11]]}
[]
[null,"Using TEXT Function",null,null,null,null,null,"Do It Yourself"]
[]
[null,"Date","Product","Price","Discount","Sales Price",null,"Date","Product","Price","Discount","Sales Price"]
[null,{"$f":"TEXT(TODAY(),\"dd-mm-yy\")","v":"17-06-22"},"Mustard - Individual Pkg",2.52,0.02,{"$f":"TEXT(D5*(1-E5),\"0.00\")","v":"2.47"},null,{"$f":"TODAY()","v":44729},"Mustard - Individual Pkg",2.52,0.02,{"$f":"J5*(1-K5)","v":2.4695999999999998}]
[null,{"$f":"TEXT(TODAY(),\"dd-mm-yy\")","v":"17-06-22"},"Lamb - Pieces, Diced",9.92,0,{"$f":"TEXT(D6*(1-E6),\"0.00\")","v":"9.92"},null,{"$f":"TODAY()","v":44729},"Lamb - Pieces, Diced",9.92,0,{"$f":"J6*(1-K6)","v":9.92}]
[null,"17-06-22","Vinegar - Tarragon",2.4500000000000002,1.2500000000000001E-2,"2.42",null,44729,"Vinegar - Tarragon",2.4500000000000002,0,2.4500000000000002]
[null,"17-06-22","Oregano - Fresh",9.11,0.1,"8.20",null,44729,"Oregano - Fresh",9.11,0.1,8.1989999999999998]
[null,"17-06-22","Soup - Clam Chowder, Dry Mix",4.6900000000000004,0,"4.69",null,44729,"Soup - Clam Chowder, Dry Mix",4.6900000000000004,0,4.6900000000000004]
[null,"17-06-22","Wine - Red, Gallo, Merlot",4.76,0.03,"4.62",null,44729,"Wine - Red, Gallo, Merlot",4.76,0.03,4.6171999999999995]
[null,"Total Sales",null,null,null,{"$f":"SUM(F5:F10)","v":0},null,"Total Sales",null,null,null,{"$f":"SUM(L5:L10)","v":32.345800000000004}]

{"sheet":"concatenate","index":9,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using CONCAT or CONCATENATE Function"]
[]
[null,"Date","Product","Price","Discount","Sales Price"]
[null,{"$f":"CONCATENATE(TODAY())","v":"44729"},"Mustard - Individual Pkg",2.52,0.02,{"$f":"_xlfn.CONCAT(D5*(1-E5))","v":"2.4696"}]
[null,{"$f":"CONCATENATE(TODAY())","v":"44729"},"Lamb - Pieces, Diced",9.92,0,{"$f":"_xlfn.CONCAT(D6*(1-E6))","v":"9.92"}]
[null,"44729","Vinegar - Tarragon",2.4500000000000002,1.2500000000000001E-2,"2.419375"]
[null,"44729","Oregano - Fresh",9.11,0.1,"8.199"]
[null,"44729","Soup - Clam Chowder, Dry Mix",4.6900000000000004,0,"4.69"]
[null,"44729","Wine - Red, Gallo, Merlot",4.76,0.03,"4.6172"]
[null,"Total Sales",null,null,null,{"$f":"SUM(F5:F10)","v":0}]