{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Formula","Combined Formula","VBA Code"],"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":"Formula","index":0,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Combination of ROUND, INT, and ABS Functions"]
[]
[null,"Number","Abs. Value ","Log of Abs Value","Rounding to Nearest Integer"]
[null,78364556.964000002,{"$f":"ABS(B5)","v":78364556.964000002},{"$f":"LOG10(C5)","v":7.8941196826414357},{"$f":"INT(D5)","v":7}]
[null,78364556.964000002,{"$f":"ABS(B6)","v":78364556.964000002},{"$f":"LOG10(C6)","v":7.8941196826414357},{"$f":"INT(D6)","v":7}]
[null,78364556.964000002,{"$f":"ABS(B7)","v":78364556.964000002},{"$f":"LOG10(C7)","v":7.8941196826414357},{"$f":"INT(D7)","v":7}]
[null,78364556.964000002,{"$f":"ABS(B8)","v":78364556.964000002},{"$f":"LOG10(C8)","v":7.8941196826414357},{"$f":"INT(D8)","v":7}]
[null,78364556.964000002,{"$f":"ABS(B9)","v":78364556.964000002},{"$f":"LOG10(C9)","v":7.8941196826414357},{"$f":"INT(D9)","v":7}]
[null,78364556.964000002,{"$f":"ABS(B10)","v":78364556.964000002},{"$f":"LOG10(C10)","v":7.8941196826414357},{"$f":"INT(D10)","v":7}]
[null,"Adding 1","SF to Round","2nd Argument of ROUND Func.","Final Result"]
[null,{"$f":"1+E5","v":8},1,{"$f":"C12-B12","v":-7},{"$f":"ROUND(B5,D12)","v":80000000}]
[null,{"$f":"1+E6","v":8},2,{"$f":"C13-B13","v":-6},{"$f":"ROUND(B6,D13)","v":78000000}]
[null,{"$f":"1+E7","v":8},3,{"$f":"C14-B14","v":-5},{"$f":"ROUND(B7,D14)","v":78400000}]
[null,{"$f":"1+E8","v":8},4,{"$f":"C15-B15","v":-4},{"$f":"ROUND(B8,D15)","v":78360000}]
[null,{"$f":"1+E9","v":8},5,{"$f":"C16-B16","v":-3},{"$f":"ROUND(B9,D16)","v":78365000}]
[null,{"$f":"1+E10","v":8},6,{"$f":"C17-B17","v":-2},{"$f":"ROUND(B10,D17)","v":78364600}]

{"sheet":"Combined Formula","index":1,"n_rows":17,"n_cols":30,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,5],[8,1,13,1]]}
[]
[null,"Combination of ROUND, INT, and ABS Functions"]
[]
[null,"Number","Abs. Value ","Log of Abs Value","Rounding to Nearest Integer","Adding 1"]
[null,78364556.964000002,{"$f":"ABS(B5)","v":78364556.964000002},{"$f":"LOG10(C5)","v":7.8941196826414357},{"$f":"INT(D5)","v":7},{"$f":"1+E5","v":8},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,78364556.964000002,{"$f":"ABS(AA5)","v":78364556.964000002},{"$f":"LOG10(AB5)","v":7.8941196826414357},{"$f":"INT(AC5)","v":7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,78364556.964000002,{"$f":"ABS(AA6)","v":78364556.964000002},{"$f":"LOG10(AB6)","v":7.8941196826414357},{"$f":"INT(AC6)","v":7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,78364556.964000002,{"$f":"ABS(AA7)","v":78364556.964000002},{"$f":"LOG10(AB7)","v":7.8941196826414357},{"$f":"INT(AC7)","v":7}]
[null,"Number","SF to Round","2nd Argument of ROUND Func.","Final Result",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,78364556.964000002,{"$f":"ABS(AA8)","v":78364556.964000002},{"$f":"LOG10(AB8)","v":7.8941196826414357},{"$f":"INT(AC8)","v":7}]
[null,78364556.964000002,1,{"$f":"C9-F5","v":-7},{"$f":"ROUND(B5,D9)","v":80000000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,78364556.964000002,{"$f":"ABS(AA9)","v":78364556.964000002},{"$f":"LOG10(AB9)","v":7.8941196826414357},{"$f":"INT(AC9)","v":7}]
[null,null,2,{"$f":"C10-S13","v":-6},{"$f":"ROUND(AA5,D10)","v":78000000}]
[null,null,3,{"$f":"C11-S14","v":-5},{"$f":"ROUND(AA6,D11)","v":78400000}]
[null,null,4,{"$f":"C12-S15","v":-4},{"$f":"ROUND(AA7,D12)","v":78360000}]
[null,null,5,{"$f":"C13-S16","v":-3},{"$f":"ROUND(AA8,D13)","v":78365000},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+AD5","v":8}]
[null,null,6,{"$f":"C14-S17","v":-2},{"$f":"ROUND(AA9,D14)","v":78364600},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+AD6","v":8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+AD7","v":8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+AD8","v":8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+AD9","v":8}]

{"sheet":"VBA Code","index":2,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of VBA Code"]
[]
[null,"Number","SF","Rounded Figure"]
[null,78364556.964000002,1,{"$f":"SigFig(B5,C5)","v":80000000}]
[null,78364556.964000002,2,{"$f":"SigFig(B6,C6)","v":78000000}]
[null,78364556.964000002,3,78400000]
[null,78364556.964000002,4,78360000]
[null,78364556.964000002,5,78365000]
[null,78364556.964000002,6,78364600]