{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Dataset","dataset2","Quick view","positive+positive","positive+negative","negative+positive","negative+negative","fraction","zero","same","non-numeric","Formula","Time","VBA","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":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"\"ABC\" Company"]
[]
[null,"Product","Order Time","Price","Discount"]
[null,"Apple","18:10:00",2341.7600000000002,0.05]
[null,"Orange","19:15:00",1945.56,0.03]
[null,"Banana","20:20:00",1525.55,0.04]
[null,"Strawberry","21:17:00",3181.54,0.02]
[null,"Lemon","17:23:00",1661.89,0.05]
[null,"Blackberry","17:20:00",1936.09,0.02]
[null,"Watermelon",1.2749999999999999,3194.97,0.06]

{"sheet":"dataset2","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 (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":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,1,0,4],[1,1,1,4],[14,1,14,4]]}
[null,"FLOOR Function"]
[null,"=FLOOR(number, significance)"]
[]
[null,"number","significance","Formula","Output"]
[null,125.5,5,{"$f":"_xlfn.FORMULATEXT(E5)","v":"=FLOOR(B5,C5)"},{"$f":"FLOOR(B5,C5)","v":125}]
[null,125.5,100,{"$f":"_xlfn.FORMULATEXT(E6)","v":"=FLOOR(B6,C6)"},{"$f":"FLOOR(B6,C6)","v":100}]
[null,125.5,-10,"=FLOOR(B7,C7)",{"$error":"#NUM!"}]
[null,-125.5,5,"=FLOOR(B8,C8)",-130]
[null,-125.5,-5,"=FLOOR(B9,C9)",-125]
[null,2.5,2.5,"=FLOOR(B10,C10)",2.5]
[null,125.5,0.5,"=FLOOR(B11,C11)",125.5]
[null,125.5,0,"=FLOOR(B12,C12)",{"$error":"#DIV/0!"}]
[null,"19:15:00","01:00:00","=FLOOR(B13,C13)","19:00:00"]
[null,123.9,"Ten","=FLOOR(B14,C14)",{"$error":"#VALUE!"}]
[null,"FLOOR Function rounds down the number nearest to the multiple of significance."]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"p"]

{"sheet":"positive+positive","index":3,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Positive Number+Positive Significance"]
[]
[null,"Product","Price","Rounded Price"]
[null,"Apple",2341.7600000000002,{"$f":"FLOOR(C5,100)","v":2300}]
[null,"Orange",1945.56,1900]
[null,"Banana",1525.55,1500]
[null,"Strawberry",3181.54,3100]
[null,"Lemon",1661.89,1600]
[null,"Blackberry",1936.09,1900]
[null,"Watermelon",3194.97,3100]

{"sheet":"positive+negative","index":4,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Positive Number+Negative Significance"]
[]
[null,"Product","Price","Rounded Price"]
[null,"Apple",2341.7600000000002,{"$f":"FLOOR(C5,-1000)","v":{"$error":"#NUM!"}}]
[null,"Orange",1945.56,{"$f":"FLOOR(C6,-1000)","v":{"$error":"#NUM!"}}]
[null,"Banana",1525.55,{"$error":"#NUM!"}]
[null,"Strawberry",3181.54,{"$error":"#NUM!"}]
[null,"Lemon",1661.89,{"$error":"#NUM!"}]
[null,"Blackberry",1936.09,{"$error":"#NUM!"}]
[null,"Watermelon",3194.97,{"$error":"#NUM!"}]

{"sheet":"negative+positive","index":5,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Negative Number+Positive Significance"]
[]
[null,"Substance","Temperature (deg C)","Rounded Temperature"]
[null,"Ammonia",-132.44499999999999,{"$f":"FLOOR(C5,5)","v":-135}]
[null,"Butane",-152.23599999999999,{"$f":"FLOOR(C6,5)","v":-155}]
[null,"Chlorine",-144.76429999999999,-145]
[null,"Ethane",-32.223399999999998,-35]
[null,"Ethanol",-242.09649999999999,-245]
[null,"Nitrogen",-147.98699999999999,-150]
[null,"Propane",-96.709760000000003,-100]

{"sheet":"negative+negative","index":6,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Negative Number+Negative Significance"]
[]
[null,"Substance","Temperature (deg C)","Rounded Temperature"]
[null,"Ammonia",-132.44499999999999,{"$f":"FLOOR(C5,-5)","v":-130}]
[null,"Butane",-152.23599999999999,{"$f":"FLOOR(C6,-5)","v":-150}]
[null,"Chlorine",-144.76429999999999,-140]
[null,"Ethane",-32.223399999999998,-30]
[null,"Ethanol",-242.09649999999999,-240]
[null,"Nitrogen",-147.98699999999999,-145]
[null,"Propane",-96.709760000000003,-95]

{"sheet":"fraction","index":7,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Fraction Significance"]
[]
[null,"Product","Price","Rounded Price"]
[null,"Apple",2341.7600000000002,{"$f":"FLOOR(C5,0.5)","v":2341.5}]
[null,"Orange",1945.56,{"$f":"FLOOR(C6,0.5)","v":1945.5}]
[null,"Banana",1525.55,1525.5]
[null,"Strawberry",3181.54,3181.5]
[null,"Lemon",1661.89,1661.5]
[null,"Blackberry",1936.09,1936]
[null,"Watermelon",3194.97,3194.5]

{"sheet":"zero","index":8,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Zero Significance"]
[]
[null,"Product","Price","Rounded Price"]
[null,"Apple",2341.7600000000002,{"$f":"FLOOR(C5,0)","v":{"$error":"#DIV/0!"}}]
[null,"Orange",1945.56,{"$f":"FLOOR(C6,0)","v":{"$error":"#DIV/0!"}}]
[null,"Banana",1525.55,{"$error":"#DIV/0!"}]
[null,"Strawberry",3181.54,{"$error":"#DIV/0!"}]
[null,"Lemon",1661.89,{"$error":"#DIV/0!"}]
[null,"Blackberry",1936.09,{"$error":"#DIV/0!"}]
[null,"Watermelon",3194.97,{"$error":"#DIV/0!"}]

{"sheet":"same","index":9,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Same Number and Significance"]
[]
[null,"Product","Price","Significance","Rounded Price"]
[null,"Apple",2341.7600000000002,2341.7600000000002,{"$f":"FLOOR(C5,D5)","v":2341.7600000000002}]
[null,"Orange",1945.56,1945.56,{"$f":"FLOOR(C6,D6)","v":1945.56}]
[null,"Banana",1525.55,1525.55,1525.55]
[null,"Strawberry",3181.54,3181.54,3181.54]
[null,"Lemon",1661.89,1661.89,1661.89]
[null,"Blackberry",1936.09,1936.09,1936.09]
[null,"Watermelon",3194.97,3194.97,3194.97]

{"sheet":"non-numeric","index":10,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Non-numeric Significance"]
[]
[null,"Product","Price","Significance","Rounded Price"]
[null,"Apple",2341.7600000000002,"Ten",{"$f":"FLOOR(C5,D5)","v":{"$error":"#VALUE!"}}]
[null,"Orange",1945.56,"Ten",{"$f":"FLOOR(C6,D6)","v":{"$error":"#VALUE!"}}]
[null,"Banana",1525.55,"Ten",{"$error":"#VALUE!"}]
[null,"Strawberry",3181.54,"Ten",{"$error":"#VALUE!"}]
[null,"Lemon",1661.89,"Ten",{"$error":"#VALUE!"}]
[null,"Blackberry",1936.09,"Ten",{"$error":"#VALUE!"}]
[null,"Watermelon",3194.97,"Ten",{"$error":"#VALUE!"}]

{"sheet":"Formula","index":11,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"FLOOR function in a Formula"]
[]
[null,"Product","Price","Discount","Discounted Price"]
[null,"Apple",2341.7600000000002,0.05,{"$f":"FLOOR(C5*D5,5)","v":115}]
[null,"Orange",1945.56,0.03,{"$f":"FLOOR(C6*D6,5)","v":55}]
[null,"Banana",1525.55,0.04,60]
[null,"Strawberry",3181.54,0.02,60]
[null,"Lemon",1661.89,0.05,80]
[null,"Blackberry",1936.09,0.02,35]
[null,"Watermelon",3194.97,0.06,190]

{"sheet":"Time","index":12,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"FLOOR Function for Time"]
[]
[null,"Product","Order Time","Rounded Time"]
[null,"Apple","18:10:00",{"$f":"FLOOR(C5,\"1:00\")","v":"18:00:00"}]
[null,"Orange","19:15:00",{"$f":"FLOOR(C6,\"1:00\")","v":"19:00:00"}]
[null,"Banana","20:20:00","20:00:00"]
[null,"Strawberry","21:17:00","21:00:00"]
[null,"Lemon","17:23:00","17:00:00"]
[null,"Blackberry","17:20:00","17:00:00"]
[null,"Watermelon",1.2749999999999999,1.25]

{"sheet":"VBA","index":13,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"VBA Code"]
[]
[null,"Product","Price","Rounded Price"]
[null,"Apple",2341.7600000000002,2000]
[null,"Orange",1945.56,1000]
[null,"Banana",1525.55,1000]
[null,"Strawberry",3181.54,3000]
[null,"Lemon",1661.89,1000]
[null,"Blackberry",1936.09,1000]
[null,"Watermelon",3194.97,3000]

{"sheet":"practice","index":14,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,7,1,8]]}
[]
[null,"Practice",null,null,null,null,null,"Practice"]
[]
[null,"Product","Order Time","Price","Discount",null,null,"Substance","Temperature (deg C)"]
[null,"Apple","18:10:00",2341.7600000000002,0.05,null,null,"Ammonia",-132.44499999999999]
[null,"Orange","19:15:00",1945.56,0.03,null,null,"Butane",-152.23599999999999]
[null,"Banana","20:20:00",1525.55,0.04,null,null,"Chlorine",-144.76429999999999]
[null,"Strawberry","21:17:00",3181.54,0.02,null,null,"Ethane",-32.223399999999998]
[null,"Lemon","17:23:00",1661.89,0.05,null,null,"Ethanol",-242.09649999999999]
[null,"Blackberry","17:20:00",1936.09,0.02,null,null,"Nitrogen",-147.98699999999999]
[null,"Watermelon",1.2749999999999999,3194.97,0.06,null,null,"Propane",-96.709760000000003]