{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Auto-Insert Decimal","solution 1","solutions(VBA)","Currency Format","solution 2","Rounding Numbers","solution 3","number into dates","Solution 4","Rounding Numbers (2)"],"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":"Auto-Insert Decimal","index":0,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Final Exam Marks"]
[]
[null,"Name ","Obtained Marks"]
[null,"John Walter",0.62]
[null,"James Frank",0.68]
[null,"William Robin",0.75]
[null,"Adam Smith",0.6]
[null,"Mary Rose",0.85]
[null,"Anna Frank",0.93]
[null,"Robert Jones",0.56000000000000005]
[null,"Thomas Henry",0.78]
[null,"Sandra Elizabeth",0.96]
[null,"Arthur Konan",0.88]

{"sheet":"solution 1","index":1,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Final Exam Marks"]
[]
[null,"Name ","Obtained Marks"]
[null,"John Walter",62]
[null,"James Frank",68]
[null,"William Robin",75]
[null,"Adam Smith",60]
[null,"Mary Rose",85]
[null,"Anna Frank",93]
[null,"Robert Jones",56]
[null,"Thomas Henry",78]
[null,"Sandra Elizabeth",96]
[null,"Arthur Konan",88]

{"sheet":"solutions(VBA)","index":2,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Final Exam Marks"]
[]
[null,"Name ","Obtained Marks"]
[null,"John Walter",62]
[null,"James Frank",68]
[null,"William Robin",75]
[null,"Adam Smith",60]
[null,"Mary Rose",85]
[null,"Anna Frank",93]
[null,"Robert Jones",56]
[null,"Thomas Henry",78]
[null,"Sandra Elizabeth",96]
[null,"Arthur Konan",88]

{"sheet":"Currency Format","index":3,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Transportation Cost"]
[]
[null,"Name ","Transport Cost "]
[null,"John Walter",60]
[null,"James Frank",56]
[null,"William Robin",46]
[null,"Adam Smith",70]
[null,"Mary Rose",85]
[null,"Anna Frank",65]
[null,"Robert Jones",49]
[null,"Thomas Henry",81]
[null,"Sandra Elizabeth",0]
[null,"Arthur Konan",72]

{"sheet":"solution 2","index":4,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Transportation Cost"]
[]
[null,"Name ","Transport Cost "]
[null,"John Walter",60]
[null,"James Frank",56]
[null,"William Robin",46]
[null,"Adam Smith",70]
[null,"Mary Rose",85]
[null,"Anna Frank",65]
[null,"Robert Jones",49]
[null,"Thomas Henry",81]
[null,"Sandra Elizabeth",0]
[null,"Arthur Konan",72]

{"sheet":"Rounding Numbers","index":5,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Revenue of Companies"]
[]
[null,"Product","Revenue"]
[null,"Basics - Brotform basket",2658945]
[null,"Cty Kitc - Pocket pastry maker",789646]
[null,"Kitchen Press - Apple baker",895445]
[null,"Own Brand - Broiling pan",6589345]
[null,"Basics - Aspic cutters",4587632]
[null,"Kitchen Press - Onion soup bowls",6001324.5]
[null,"M&S - Icing bags & decorating tips",6967031.7999999998]
[null,"Cty Kitc - Muddler",7932739.0999999996]
[null,"M&S - Wine cooler",8898446.4000000004]
[null,"J Oliver - Panettone mold",9864153.6999999993]

{"sheet":"solution 3","index":6,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Revenue of Companies"]
[]
[null,"Product","Rev"]
[null,"Basics - Brotform basket",2658945]
[null,"Cty Kitc - Pocket pastry maker",789646]
[null,"Kitchen Press - Apple baker",895445]
[null,"Own Brand - Broiling pan",6589345]
[null,"Basics - Aspic cutters",4587632]
[null,"Kitchen Press - Onion soup bowls",6001324.5]
[null,"M&S - Icing bags & decorating tips",6967031.7999999998]
[null,"Cty Kitc - Muddler",7932739.0999999996]
[null,"M&S - Wine cooler",8898446.4000000004]
[null,"J Oliver - Panettone mold",9864153.6999999993]

{"sheet":"number into dates","index":7,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Distance of Locations"]
[]
[null,"Name ","Distance (Km)"]
[null,"Location-1","2022-04-03"]
[null,"Location-2","2022-02-01"]
[null,"Location-3","2022-05-02"]
[null,"Location-4","2022-06-03"]
[null,"Location-5","2022-08-04"]

{"sheet":"Solution 4","index":8,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Distance of Locations"]
[]
[null,"Name ","Distance (Km)"]
[null,"Location-1","3/4"]
[null,"Location-2","1/2"]
[null,"Location-3","2/5"]
[null,"Location-4","3/6"]
[null,"Location-5","4/8"]

{"sheet":"Rounding Numbers (2)","index":9,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Revenue of Companies"]
[]
[null,"Product","Revenue","Revenue"]
[null,"Basics - Brotform basket",2658945,{"$f":"CONCATENATE(C5)","v":"2658945"}]
[null,"Cty Kitc - Pocket pastry maker",789646,{"$f":"CONCATENATE(C6)","v":"789646"}]
[null,"Kitchen Press - Apple baker",895445,"895445"]
[null,"Own Brand - Broiling pan",6589345,"6589345"]
[null,"Basics - Aspic cutters",4587632,"4587632"]
[null,"Kitchen Press - Onion soup bowls",6001324.5,"6001324.5"]
[null,"M&S - Icing bags & decorating tips",6967031.7999999998,"6967031.8"]
[null,"Cty Kitc - Muddler",7932739.0999999996,"7932739.1"]
[null,"M&S - Wine cooler",8898446.4000000004,"8898446.4"]
[null,"J Oliver - Panettone mold",9864153.6999999993,"9864153.7"]