{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset-1","DEC2BIN Function","INT & MOD Functions","QUOTIENT and MOD Functions","Dataset-2","Text to Binary"],"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-1","index":0,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"List of Decimal Numbers"]
[]
[null,"Decimal Number"]
[null,10]
[null,54]
[null,44]
[null,67]
[null,32]
[null,56]
[null,8]
[null,31]
[null,25]
[null,79]
[null,4]
[null,76]
[null,10]

{"sheet":"DEC2BIN Function","index":1,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Using DEC2BIN Function",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Decimal Number","Binary Number",null,null,null,null,null,null,null,null,"Decimal Number","Binary Number"]
[null,10,{"$f":"DEC2BIN(B5)","v":"1010"},null,null,null,null,null,null,null,null,10]
[null,54,{"$f":"DEC2BIN(B6)","v":"110110"},null,null,null,null,null,null,null,null,54]
[null,44,"101100",null,null,null,null,null,null,null,null,44]
[null,40,"101000",null,null,null,null,null,null,null,null,40]
[null,32,"100000",null,null,null,null,null,null,null,null,32]
[null,56,"111000",null,null,null,null,null,null,null,null,56]
[null,8,"1000",null,null,null,null,null,null,null,null,8]
[null,31,"11111",null,null,null,null,null,null,null,null,31]
[null,25,"11001",null,null,null,null,null,null,null,null,25]
[null,37,"100101",null,null,null,null,null,null,null,null,37]
[null,4,"100",null,null,null,null,null,null,null,null,4]
[null,28,"11100",null,null,null,null,null,null,null,null,28]
[null,10,"1010",null,null,null,null,null,null,null,null,10]

{"sheet":"INT & MOD Functions","index":2,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[9,2,9,3],[4,1,8,1],[1,11,1,13],[4,11,8,11],[9,12,9,13]]}
[]
[null,"Using INT and MOD Functions",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Decimal Number","Quotient","Remainder",null,null,null,null,null,null,null,"Decimal Number","Quotient","Remainder"]
[null,40,{"$f":"INT(B5/2)","v":20},{"$f":"MOD(B5,2)","v":0},null,null,null,null,null,null,null,40]
[null,null,{"$f":"INT(C5/2)","v":10},{"$f":"MOD(C6,2)","v":0}]
[null,null,{"$f":"INT(C6/2)","v":5},{"$f":"MOD(C7,2)","v":1}]
[null,null,2,0]
[null,null,1,1]
[null,"Binary Number",{"$f":"CONCATENATE(1,0,1,0,0)","v":"10100"},null,null,null,null,null,null,null,null,"Binary Number"]

{"sheet":"QUOTIENT and MOD Functions","index":3,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,3],[4,1,8,1],[1,11,1,13],[4,11,8,11]]}
[]
[null,"Using QUOTIENT and MOD Functions",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Decimal Number","Quotient","Remainder",null,null,null,null,null,null,null,"Decimal Number","Quotient","Remainder"]
[null,40,{"$f":"QUOTIENT(B5,2)","v":20},{"$f":"MOD(B5,2)","v":0},null,null,null,null,null,null,null,40]
[null,null,{"$f":"QUOTIENT(C5,2)","v":10},{"$f":"MOD(C6,2)","v":0}]
[null,null,{"$f":"QUOTIENT(C6,2)","v":5},{"$f":"MOD(C7,2)","v":1}]
[null,null,{"$f":"QUOTIENT(C7,2)","v":2},{"$f":"MOD(C8,2)","v":0}]
[null,null,{"$f":"QUOTIENT(C8,2)","v":1},{"$f":"MOD(C9,2)","v":1}]
[]
[]
[null,"Quotient","Remainder"]
[null,1,1]
[null,2,0]
[null,5,1]
[null,10,0]
[null,20,0]
[null,"Binary Number",{"$f":"CONCATENATE(C13,C14,C15,C16,C17)","v":"10100"}]

{"sheet":"Dataset-2","index":4,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Employee Information"]
[]
[null,"Department","Employee Name"]
[null,"Operations","Jim"]
[null,"Operations","Jon"]
[null,"Finance","Eli"]
[null,"Accounting","Wil"]
[null,"HR","Jen"]
[null,"HR","Rob"]
[null,"Engineering","Tim"]
[null,"Engineering","Bob"]
[null,"Marketing","Ann"]

{"sheet":"Text to Binary","index":5,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Converting Text to Binary with VBA Code",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Department","Employee Name","Binary Number",null,null,null,null,null,null,null,"Department","Employee Name","Binary Number"]
[null,"Operations","Jim",{"$f":"String_To_Binary(C5)","v":"100101011010011101101"},null,null,null,null,null,null,null,"Operations","Jim"]
[null,"Operations","Jon",{"$f":"String_To_Binary(C6)","v":"100101011011111101110"},null,null,null,null,null,null,null,"Operations","Jon"]
[null,"Finance","Eli",{"$f":"String_To_Binary(C7)","v":"100010111011001101001"},null,null,null,null,null,null,null,"Finance","Eli"]
[null,"Accounting","Wil",{"$f":"String_To_Binary(C8)","v":"101011111010011101100"},null,null,null,null,null,null,null,"Accounting","Wil"]
[null,"HR","Jen",{"$f":"String_To_Binary(C9)","v":"100101011001011101110"},null,null,null,null,null,null,null,"HR","Jen"]
[null,"HR","Rob",{"$f":"String_To_Binary(C10)","v":"101001011011111100010"},null,null,null,null,null,null,null,"HR","Rob"]
[null,"Engineering","Tim",{"$f":"String_To_Binary(C11)","v":"101010011010011101101"},null,null,null,null,null,null,null,"Engineering","Tim"]
[null,"Engineering","Bob",{"$f":"String_To_Binary(C12)","v":"100001011011111100010"},null,null,null,null,null,null,null,"Engineering","Bob"]
[null,"Marketing","Ann",{"$f":"String_To_Binary(C13)","v":"100000111011101101110"},null,null,null,null,null,null,null,"Marketing","Ann"]