{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Sheet1","Sheet2","Sheet3","Sheet4","Sheet5"],"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":"Sheet1","index":0,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[">> Click here for more Free Excel resources <<"]
[]
[]
["Amount","Round to 2 Decimal"]
[95.415999999999997,{"$f":"ROUND(A5,2)","v":95.42}]
[88.197999999999993,{"$f":"ROUND(A6,2)","v":88.2}]
[71.575000000000003,71.58]
[79.486999999999995,79.489999999999995]
[72.789000000000001,72.790000000000006]
[70.988,70.989999999999995]
[76.399000000000001,76.400000000000006]
[45.237000000000002,45.24]
[50.085000000000001,50.09]
[91.807000000000002,91.81]

{"sheet":"Sheet2","index":1,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Sales ","No of Units","Sale Price per unit"]
[95416,5,{"$f":"ROUND(A2/B2,0)","v":19083}]
[88198,21,{"$f":"ROUND(A3/B3,0)","v":4200}]
[71575,25,2863]
[79487,49,1622]
[72789,29,2510]
[70988,26,2730]
[76399,3,25466]
[45237,28,1616]
[50085,14,3578]
[91807,28,3279]

{"sheet":"Sheet3","index":2,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Amount","ROUNDUP"]
[95.415999999999997,{"$f":"ROUNDUP(A2,0)","v":96}]
[88.197999999999993,{"$f":"ROUNDUP(A3,0)","v":89}]
[71.575000000000003,72]
[79.486999999999995,80]
[72.789000000000001,73]
[70.988,71]
[76.399000000000001,77]
[45.237000000000002,46]
[50.085000000000001,51]
[91.807000000000002,92]

{"sheet":"Sheet4","index":3,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Amount","ROUNDDOWN"]
[95.415999999999997,{"$f":"ROUNDDOWN(A2,0)","v":95}]
[88.197999999999993,{"$f":"ROUNDDOWN(A3,0)","v":88}]
[71.575000000000003,71]
[79.486999999999995,79]
[72.789000000000001,72]
[70.988,70]
[76.399000000000001,76]
[45.237000000000002,45]
[50.085000000000001,50]
[91.807000000000002,91]

{"sheet":"Sheet5","index":4,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Region","Sales "]
["North",95.415999999999997,{"$f":"IF(A2=\"North\",ROUND(B2,0),D2)","v":95}]
["South",88.197999999999993,{"$f":"IF(A3=\"North\",ROUND(B3,0),D3)","v":0}]
["North",71.575000000000003,72]
["North",79.486999999999995,79]
["North",72.789000000000001,73]
["North",70.988,71]
["South",76.399000000000001,0]
["South",45.237000000000002,0]
["South",50.085000000000001,0]
["North",91.807000000000002,92]