{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["Hoja1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Hoja1","index":0,"n_rows":46,"n_cols":8,"rows_kept":46,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["CONVERSIÓN DE NÚMEROS ENTRE DISTINTAS BASES"]
[]
["BASE 10 A CUALQUIER OTRA BASE B (RESULTADO EN FORMATO mantisa * 2^exponente CON 1 <= |mantisa| < 2)"]
[]
[]
["Cantidad original: "," X = ",2e-39,null,null,"OJO: X debe ser distinto de 0 (puede ser negativo)"]
["Nueva base para la mantisa: "," b = ",16,null,null,"OJO: b debe ser positivo y distinto de 0 (recomendable dejar b=16)"]
[]
["SIGNO: POSITIVO"]
[]
["CÁLCULO DEL EXPONENTE"]
["1º. Calcular el cociente de logaritmos "]
["ln|X| / ln 2 = ",-128.55519570060713,{"$nulls":4},"BASE: ",16]
["2º. El exponente es la parte entera del cociente anterior"]
["exp = ",-129,{"$nulls":4},"EXPONENTE: ",-129]
[]
["CÁLCULO DE LA MANTISA EN BASE 10"]
["1º. Calcular base elevado al exponente"]
["2^exp = ",1.4693679385278594e-39]
["2º. La mantisa es el cociente entre el número original y el valor obtenido al elevar la base al exponente"]
["m = |X| / (2^exp) = ",1.3611294676837538,{"$nulls":4},"MANTISA: ",1.3611294676837538]
[]
["Por tanto: ","X = 1.36112946768375*2^-129"]
[]
["CÁLCULO DE LA MANTISA EN LA NUEVA BASE"]
["Posicion","F(X) = ",0.36112946768375376,"Dígito",null,"Mantisa en base 16","Error absoluto","Error relativo"]
[0,null,null,"M(0) = ",1,"m = 1",5.306320614721405e-40,0.26531603073607024]
[-1,"0.361129468*16 = ",5.77807148294006,"M(-1) = ",5,"m = 1.5",7.145458068218442e-41,0.03572729034109221]
[-2,"0.778071483*16 = ",12.449143727040962,"M(-2) = ",12,"m = 1.5C",2.577958563691007e-42,0.0012889792818455037]
[-3,"0.449143727*16 = ",7.186299632655391,"M(-3) = ",7,"m = 1.5C7",6.683171562093496e-44,3.3415857810467486e-05]
[-4,"0.186299633*16 = ",2.980794122486259,"M(-4) = ",2,"m = 1.5C72",2.1990164762540817e-44,1.0995082381270409e-05]
[-5,"0.980794122*16 = ",15.692705959780142,"M(-5) = ",15,"m = 1.5C72F",9.706877976685611e-46,4.853438988342806e-07]
[-6,"0.692705960*16 = ",11.083295356482267,"M(-6) = ",11,"m = 1.5C72FB",7.295103445249342e-48,3.6475517226246715e-09]
[-7,"0.083295356*16 = ",1.332725703716278,"M(-7) = ",1,"m = 1.5C72FB1",1.8212813189805256e-48,9.106406594902629e-10]
[-8,"0.332725704*16 = ",5.323611259460449,"M(-8) = ",5,"m = 1.5C72FB15",1.1071190452152037e-49,5.535595226076019e-11]
[-9,"0.323611259*16 = ",5.1777801513671875,"M(-9) = ",5,"m = 1.5C72FB155",3.8013161178325405e-51,1.9006580589162705e-12]
[-10,"0.177780151*16 = ",2.844482421875,"M(-10) = ",2,"m = 1.5C72FB1552",1.1285514077403448e-51,5.642757038701724e-13]
[-11,"0.844482422*16 = ",13.51171875,"M(-11) = ",13,"m = 1.5C72FB1552D",4.274074426539034e-53,2.137037213269517e-14]
[-12,"0.511718750*16 = ",8.1875,"M(-12) = ",8,"m = 1.5C72FB1552D8",9.787956701997787e-55,4.893978350998893e-16]
[-13,"0.187500000*16 = ",3,"M(-13) = ",3,"m = 1.5C72FB1552D83",0,0]
[-14,"0.000000000*16 = ",0,"M(-14) = ",0,"m = 1.5C72FB1552D830",0,0]
[-15,"0.000000000*16 = ",0,"M(-15) = ",0,"m = 1.5C72FB1552D8300",0,0]
[-16,"0.000000000*16 = ",0,"M(-16) = ",0,"m = 1.5C72FB1552D83000",0,0]
[-17,"0.000000000*16 = ",0,"M(-17) = ",0,"m = 1.5C72FB1552D830000",0,0]
[-18,"0.000000000*16 = ",0,"M(-18) = ",0,"m = 1.5C72FB1552D8300000",0,0]
[-19,"0.000000000*16 = ",0,"M(-19) = ",0,"m = 1.5C72FB1552D83000000",0,0]