{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Presentación","Funciones","Secante"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":17,"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":"Presentación","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Funciones","index":1,"n_rows":86,"n_cols":9,"rows_kept":86,"cut":false,"hidden":false,"merged":[]}
["Función promedio"]
[]
["Ciclo for",null,"Datos"]
[null,null,1]
[null,null,2]
[null,null,34]
[null,null,5]
[null,null,6]
[null,null,9]
[]
[null,"Ciclo for","Promedio","Suma/n"]
[null,{"$f":"prom(C4:C9)","v":9.5},{"$f":"AVERAGE(C4:C9)","v":9.5},{"$f":"SUM(C4:C9)/6","v":9.5}]
[]
[]
[]
[]
[]
["Ciclo While",null,"Datos"]
[null,null,1]
[null,null,2]
[null,null,34]
[null,null,5]
[null,null,6]
[null,null,9]
[]
[null,"Ciclo for","Promedio","Suma/n"]
[null,{"$f":"promWhile(C19:C24)","v":9.5},{"$f":"AVERAGE(C19:C24)","v":9.5},{"$f":"SUM(C19:C24)/6","v":9.5}]
[]
[]
[]
[]
[]
[]
[]
["T","To","R","A","B","C","D","E"]
[300,{"$f":"25+273.15","v":298.14999999999998},8.3140000000000002E-3,3.6393655172413797,-1.2581540229885059E-3,4.242965517241379E-6,-2.7613103448275862E-9,5.0429885057471253E-13]
[]
[]
[]
[null,null,"Calculado",null,"Referencia"]
[null,null,{"$f":"Mcp(A36,B36,C36,D36:H36)","v":2.9703977954981392E-2},null,2.9703977954981392E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,0]
[null,"Datos","Cuadrado"]
[null,2,4]
[null,3,9]
[null,4,16]
[null,6,36]
[null,8,64]
[null,9,81]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Suma"]
[null,1,6,11,{"$f":"SUM(B73:D73)","v":18}]
[null,2,7,12,{"$f":"SUM(B74:D74)","v":21}]
[null,3,8,13,24]
[null,4,9,14,27]
[null,5,1,15,21]
["Suma",{"$f":"SUM(B73:B77)","v":15},{"$f":"SUM(C73:C77)","v":31},65]
[]
[]
[null,null,"x",0,"reglon"]
[null,null,"y",2,"columna"]
[null,null,"Suma ",{"$f":"PruebaRango(B73:D77,D81,D82)","v":31}]
[]
[]
[null,null,1]

{"sheet":"Secante","index":2,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,"xtol",1E-4]
[null,null,"Convergencia",1.0000000000000001E-5,null,"ytol",1E-4]
[null,null,"a",-100,null,"a",-100]
[null,null,"b",100,null,"b",100]
[]
[null,null,"Posicion falsa",null,null,"Secante",{"$f":"Secante(G4,G5,G2,G3)","v":-2.2134184680649054}]
[null,null,"x",{"$f":"PosFalsa(D4,D5,D3)","v":-2.2134135078540993}]
[null,null,"f(x)",{"$f":"fu(D8)","v":-9.9950661827108433E-6}]
[null,null,"Solver"]
[null,null,"x",-2.213411527465095]
[null,null,"f(x)",{"$f":"fu(D11)","v":7.3291852675794189E-7}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Función"]
[null,null,"a","b","c","d"]
[null,null,2,3,4,5]
[]
[null,null,"x",10,null,null,"xtol",1E-4]
[null,null,"f(x)",{"$f":"C22+D22*D24+E22*D24^2+F22*D24^3","v":5432},null,null,"ytol",1E-4]
[null,null,null,null,null,null,"a",{"$f":"D24","v":10}]
[null,null,"x",{"$f":"D24","v":10},null,null,"b",100]
[null,null,"f(x)",{"$f":"FF(C22:F22,D27)","v":5432}]
[null,null,null,null,null,null,"Secante"]