{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["dataset","dataset1","quick view","whole number","positive","positive2","positive3","negative1","negative2","negative3","Formula","VBA","negative values","negative values2","negative values3","Practice"],"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":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Records of a Competition"]
[]
[null,"Participant\n Name","Distance\n(m)","Time\n(sec)"]
[null,"Michael",1459.5678,1260.9876899999999]
[null,"Joe",789.18,967.18669999999997]
[null,"John",858.27,567.2876]
[null,"Richard",687.78,234.67850000000001]
[null,"Christian",478.96699999999998,345.10876000000002]
[null,"Jefferson",897.654,823.1087]

{"sheet":"dataset1","index":1,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"\"X\" Laboratory"]
[]
[null,"Substance","Temperature\n(deg C)"]
[null,"Ammonia",-132.44499999999999]
[null,"Butane",-152.23599999999999]
[null,"Chlorine",-144.76429999999999]
[null,"Ethane",-32.223399999999998]
[null,"Ethanol",-242.09649999999999]
[null,"Nitrogen",-147.98699999999999]
[null,"Propane",-96.709760000000003]

{"sheet":"quick view","index":2,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3],[12,0,12,3]]}
["ROUNDUP Function"]
["=ROUNDUP(number, num_digits)"]
[]
["number","num_digits","Formula","Output"]
[967.18669999999997,-3,{"$f":"_xlfn.FORMULATEXT(D5)","v":"=ROUNDUP(A5,B5)"},{"$f":"ROUNDUP(A5,B5)","v":1000}]
[967.18669999999997,-2,{"$f":"_xlfn.FORMULATEXT(D6)","v":"=ROUNDUP(A6,B6)"},{"$f":"ROUNDUP(A6,B6)","v":1000}]
[967.18669999999997,-1,"=ROUNDUP(A7,B7)",970]
[967.18669999999997,0,"=ROUNDUP(A8,B8)",968]
[967.18669999999997,1,"=ROUNDUP(A9,B9)",967.2]
[967.18669999999997,2,"=ROUNDUP(A10,B10)",967.18999999999994]
[967.18669999999997,3,"=ROUNDUP(A11,B11)",967.18700000000001]
[-967.18669999999997,1,"=ROUNDUP(A12,B12)",-967.2]
["ROUNDUP Function rounds a number up to a certain number of decimal points"]

{"sheet":"whole number","index":3,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Rounding Up to the Whole Number"]
[]
[null,"Participant\n Name","Time\n(sec)","Rounded\nTime"]
[null,"Michael",1260.9876899999999,{"$f":"ROUNDUP(C5,0)","v":1261}]
[null,"Joe",967.18669999999997,{"$f":"ROUNDUP(C6,0)","v":968}]
[null,"John",567.2876,{"$f":"ROUNDUP(C7,0)","v":568}]
[null,"Richard",234.67850000000001,235]
[null,"Christian",345.10876000000002,346]
[null,"Jefferson",823.1087,824]

{"sheet":"positive","index":4,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Positive Number Digit"]
[]
[null,"Participant\n Name","Time\n(sec)","Rounded\nTime"]
[null,"Michael",1260.9876899999999,{"$f":"ROUNDUP(C5,1)","v":1261}]
[null,"Joe",967.18669999999997,{"$f":"ROUNDUP(C6,1)","v":967.2}]
[null,"John",567.2876,567.30000000000007]
[null,"Richard",234.67850000000001,234.7]
[null,"Christian",345.10876000000002,345.20000000000005]
[null,"Jefferson",823.1087,823.2]

{"sheet":"positive2","index":5,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Positive Number Digit"]
[]
[null,"Participant\n Name","Time\n(sec)","Rounded\nTime"]
[null,"Michael",1260.9876899999999,{"$f":"ROUNDUP(C5,2)","v":1260.99}]
[null,"Joe",967.18669999999997,{"$f":"ROUNDUP(C6,2)","v":967.18999999999994}]
[null,"John",567.2876,567.29]
[null,"Richard",234.67850000000001,234.67999999999998]
[null,"Christian",345.10876000000002,345.11]
[null,"Jefferson",823.1087,823.11]

{"sheet":"positive3","index":6,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Positive Number Digit"]
[]
[null,"Participant\n Name","Time\n(sec)","Rounded\nTime"]
[null,"Michael",1260.9876899999999,{"$f":"ROUNDUP(C5,3)","v":1260.9880000000001}]
[null,"Joe",967.18669999999997,{"$f":"ROUNDUP(C6,3)","v":967.18700000000001}]
[null,"John",567.2876,567.28800000000001]
[null,"Richard",234.67850000000001,234.679]
[null,"Christian",345.10876000000002,345.10899999999998]
[null,"Jefferson",823.1087,823.10899999999992]

{"sheet":"negative1","index":7,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Negative Number Digit"]
[]
[null,"Participant\n Name","Distance\n(m)","Rounded\nDistance"]
[null,"Michael",1459.5678,{"$f":"ROUNDUP(C5,-1)","v":1460}]
[null,"Joe",789.18,{"$f":"ROUNDUP(C6,-1)","v":790}]
[null,"John",858.27,860]
[null,"Richard",687.78,690]
[null,"Christian",478.96699999999998,480]
[null,"Jefferson",897.654,900]

{"sheet":"negative2","index":8,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Negative Number Digit"]
[]
[null,"Participant\n Name","Distance\n(m)","Rounded\nDistance"]
[null,"Michael",1459.5678,{"$f":"ROUNDUP(C5,-2)","v":1500}]
[null,"Joe",789.18,{"$f":"ROUNDUP(C6,-2)","v":800}]
[null,"John",858.27,900]
[null,"Richard",687.78,700]
[null,"Christian",478.96699999999998,500]
[null,"Jefferson",897.654,900]

{"sheet":"negative3","index":9,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Negative Number Digit"]
[]
[null,"Participant\n Name","Distance\n(m)","Rounded\nDistance"]
[null,"Michael",1459.5678,{"$f":"ROUNDUP(C5,-3)","v":2000}]
[null,"Joe",789.18,{"$f":"ROUNDUP(C6,-3)","v":1000}]
[null,"John",858.27,1000]
[null,"Richard",687.78,1000]
[null,"Christian",478.96699999999998,1000]
[null,"Jefferson",897.654,1000]

{"sheet":"Formula","index":10,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"ROUNDUP in a Formula"]
[]
[null,"Participant\n Name","Distance\n(m)","Time\n(sec)","Speed\n(m/sec)"]
[null,"Michael",1459.5678,1260.9876899999999,{"$f":"ROUNDUP((C5/D5),2)","v":1.1599999999999999}]
[null,"Joe",789.18,967.18669999999997,{"$f":"ROUNDUP((C6/D6),2)","v":0.82000000000000006}]
[null,"John",858.27,567.2876,1.52]
[null,"Richard",687.78,234.67850000000001,2.94]
[null,"Christian",478.96699999999998,345.10876000000002,1.39]
[null,"Jefferson",897.654,823.1087,1.1000000000000001]

{"sheet":"VBA","index":11,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using VBA Code"]
[]
[null,"Participant\n Name","Distance\n(m)","Rounded\nDistance"]
[null,"Michael",1459.5678,1459.57]
[null,"Joe",789.18,789.18]
[null,"John",858.27,858.27]
[null,"Richard",687.78,687.78]
[null,"Christian",478.96699999999998,478.96999999999997]
[null,"Jefferson",897.654,897.66]

{"sheet":"negative values","index":12,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Negative Values"]
[]
[null,"Substance","Temperature\n(deg C)","Rounded\n Values"]
[null,"Ammonia",-132.44499999999999,{"$f":"ROUNDUP(C5,0)","v":-133}]
[null,"Butane",-152.23599999999999,{"$f":"ROUNDUP(C6,0)","v":-153}]
[null,"Chlorine",-144.76429999999999,-145]
[null,"Ethane",-32.223399999999998,-33]
[null,"Ethanol",-242.09649999999999,-243]
[null,"Nitrogen",-147.98699999999999,-148]
[null,"Propane",-96.709760000000003,-97]

{"sheet":"negative values2","index":13,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Negative Values"]
[]
[null,"Substance","Temperature\n(deg C)","Rounded\n Values"]
[null,"Ammonia",-132.44499999999999,{"$f":"ROUNDUP(C5,2)","v":-132.44999999999999}]
[null,"Butane",-152.23599999999999,{"$f":"ROUNDUP(C6,2)","v":-152.23999999999998}]
[null,"Chlorine",-144.76429999999999,-144.76999999999998]
[null,"Ethane",-32.223399999999998,-32.229999999999997]
[null,"Ethanol",-242.09649999999999,-242.1]
[null,"Nitrogen",-147.98699999999999,-147.98999999999998]
[null,"Propane",-96.709760000000003,-96.710000000000008]

{"sheet":"negative values3","index":14,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Negative Values"]
[]
[null,"Substance","Temperature\n(deg C)","Rounded\n Values"]
[null,"Ammonia",-132.44499999999999,{"$f":"ROUNDUP(C5,-2)","v":-200}]
[null,"Butane",-152.23599999999999,{"$f":"ROUNDUP(C6,-2)","v":-200}]
[null,"Chlorine",-144.76429999999999,-200]
[null,"Ethane",-32.223399999999998,-100]
[null,"Ethanol",-242.09649999999999,-300]
[null,"Nitrogen",-147.98699999999999,-200]
[null,"Propane",-96.709760000000003,-100]

{"sheet":"Practice","index":15,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Practice",null,null,null,null,"Practice"]
[]
[null,"Participant\n Name","Distance\n(m)","Time\n(sec)",null,null,"Substance","Temperature\n(deg C)","Rounded\n Values"]
[null,"Michael",1459.5678,1260.9876899999999,null,null,"Ammonia",-132.44499999999999]
[null,"Joe",789.18,967.18669999999997,null,null,"Butane",-152.23599999999999]
[null,"John",858.27,567.2876,null,null,"Chlorine",-144.76429999999999]
[null,"Richard",687.78,234.67850000000001,null,null,"Ethane",-32.223399999999998]
[null,"Christian",478.96699999999998,345.10876000000002,null,null,"Ethanol",-242.09649999999999]
[null,"Jefferson",897.654,823.1087,null,null,"Nitrogen",-147.98699999999999]
[null,null,null,null,null,null,"Propane",-96.709760000000003]