{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["hex2float","float2hex"],"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":"hex2float","index":0,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,"Bits[31:24]","Bits[23:16]","Bits[15:8]","Bits[7:0]"]
["Hex","7D","1A","F7","4D"]
["Dec",{"$f":"HEX2DEC(B2)","v":125},{"$f":"HEX2DEC(C2)","v":26},{"$f":"HEX2DEC(D2)","v":247},{"$f":"HEX2DEC(E2)","v":77}]
["Sign",null,{"$f":"1-BITWISE_AND(HEX2DEC(C2), 128)/64","v":1}]
[null,null,null,"Intermediate:"]
["Exponent:",null,null,{"$f":"POWER(2, B3-128)","v":0.125}]
[null,null,null,{"$f":"BITWISE_OR(C3, 128)","v":154}]
[null,null,null,{"$f":"D7*65536","v":10092544}]
[null,null,null,{"$f":"D8+D3*256","v":10155776}]
[null,null,null,{"$f":"D9+E3","v":10155853}]
[null,null,null,{"$f":"D10*POWER(2, -24)","v":0.60533601045608521}]
[null,null,null,"Result:"]
["Decimal Floating Point:",null,null,{"$f":"D11*D6*C4","v":7.5667001307010651E-2}]

{"sheet":"float2hex","index":1,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Decimal Floating Point:",null,null,0.37040000000000001]
["Exponent:",null,null,{"$f":"(INT(LOG(ABS(D1), 2) + 1))","v":-1}]
["Mantissa:",null,null,{"$f":"ROUND(ABS(D1)/(POWER(2,D2))*POWER(2, 24), 0)","v":12428562}]
["Sign:",null,null,{"$f":"SIGN(D1)","v":1},{"$f":"128*((1-D4)/2)","v":0}]
[]
[null,"Bits[31:24]","Bits[23:16]","Bits[15:8]","Bits[7:0]"]
["Hex",{"$f":"DEC2HEX(B8)","v":"7F"},{"$f":"DEC2HEX(C8)","v":"3D"},{"$f":"DEC2HEX(D8)","v":"A5"},{"$f":"DEC2HEX(E8)","v":"12"}]
["Dec",{"$f":"INT(D2+128)","v":127},{"$f":"BITWISE_AND(INT(D3/65536), 127)+E4","v":61},{"$f":"INT(BITWISE_AND(D3, 65535)/256)","v":165},{"$f":"INT(BITWISE_AND(D3, 255))","v":18}]