{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Presentación","Ciclo-For","Ciclo While","If","Cp","Ejercicio","PosFalsa","Secante","Anexos"],"not_rendered":{"charts":1,"images":25,"macros":1,"external_links":0,"defined_names":34,"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":"Ciclo-For","index":1,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Función promedio"]
[]
[]
[]
[null,"Datos",null,null,"Promedio"]
[null,1,null,null,{"$f":"AVERAGE(B6:B11)","v":9.5}]
[null,2]
[null,34,null,null,"Suma/n"]
[null,5,null,null,{"$f":"SUM(B6:B11)/6","v":9.5}]
[null,6]
[null,9,null,null,"Ciclo for"]
[null,null,null,null,{"$f":"prom(B6:B11)","v":9.5}]

{"sheet":"Ciclo While","index":2,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Función promedio"]
[]
[]
[]
[null,"Datos",null,null,"Promedio"]
[null,1,null,null,{"$f":"AVERAGE(B6:B11)","v":9.5}]
[null,2]
[null,34,null,null,"Suma/n"]
[null,5,null,null,{"$f":"SUM(B6:B11)/6","v":9.5}]
[null,6]
[null,9,null,null,"Ciclo for"]
[null,null,null,null,{"$f":"promWhile(B6:B11)","v":9.5}]

{"sheet":"If","index":3,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Función  If"]
[]
[null,null,null,"Si x=A","Uno"]
[null,null,null,"    x=B","Dos"]
[null,null,null,"    x =C","Tres"]
[null,null,null,null,"Nada"]
[]
[null,"A","B","C"]
[null,1,2,3]
[]
[]
[null,"x",2]
[null,"Respuesta",{"$f":"pruebaIf(C12,B9:D9)","v":"Dos"}]

{"sheet":"Cp","index":4,"n_rows":143,"n_cols":8,"rows_kept":143,"cut":false,"hidden":false,"merged":[]}
["Capacidad calorífica"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["T [K]","To [K]","R [kJ mol-1 K-1 ]","A","B","C","D","E"]
[600,{"$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,"c#pi [kJ mol-1 K-1 ]",{"$f":"cp(A15,C15,D15:H15)","v":3.1722953137082482E-2}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["T [K]","To [K]","R [kJ mol-1 K-1 ]","A","B","C","D","E"]
[600,{"$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,"<c#pi> [kJ mol-1 K-1 ]",{"$f":"Mcp(A42,B42,C42,D42:H42)","v":3.0837634692771222E-2}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Integral [kJ mol-1 ]",{"$f":"D49*(A42-B42)","v":9.3083400320129943}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["T [K]","To [K]","R [kJ mol-1 K-1 ]","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,"Integral [kJ mol-1 K-1 ]",{"$f":"IntcpT(A69,B69,C69,D69:H69)","v":1.8374162248571091E-4}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"<c#pi> [kJ mol-1 K-1 ]",{"$f":"Mcp(A69,B69,C69,D69:H69)","v":2.9703977954981392E-2}]
[]
[null,null,"Integral [kJ mol-1 K-1 ]",{"$f":"D87*LN(A69/B69)","v":1.8374165155763791E-4}]
[]
["To [K]","R [kJ mol-1 K-1 ]","A","B","C","D","E"]
[{"$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,"T [K]","Integral método  1","<c#pi> [kJ mol-1 K-1 ]","Integral método 2"]
[null,298.14999999999998,{"$f":"IntcpT(B96,$A$92,$B$92,$C$92:$G$92)","v":0},{"$f":"Mcp(B96,$A$92,$B$92,$C$92:$G$92)","v":2.9699428922321611E-2},{"$f":"D96*LN(B96/$A$92)","v":0}]
[null,{"$f":"B96+100","v":398.15},{"$f":"IntcpT(B97,$A$92,$B$92,$C$92:$G$92)","v":8.6714790337689591E-3},{"$f":"Mcp(B97,$A$92,$B$92,$C$92:$G$92)","v":2.999646465324228E-2},{"$f":"D97*LN(B97/$A$92)","v":8.6759405582521269E-3}]
[null,{"$f":"B97+100","v":498.15},1.5561475212594206E-2,3.0380924385515734E-2,1.5594665836867078E-2]
[null,598.15,2.1362366566239584E-2,3.0828890984832578E-2,2.1464456365072444E-2]
[null,698.15,2.6428847654156207E-2,3.1318459832392315E-2,2.6646912670820717E-2]
[null,798.15,3.0961813140956657E-2,3.1829738824903489E-2,3.1342738541645696E-2]
[null,898.15,3.5082668102469607E-2,3.2344848374583568E-2,3.5667970279137304E-2]
[null,998.15,3.8868135388106448E-2,3.284792140915898E-2,3.9690368448575986E-2]
[null,1098.1500000000001,4.2368354558730018E-2,3.3325103371865165E-2,4.3448786868551484E-2]
[null,1198.1500000000001,4.5617059328787506E-2,3.3764552221446448E-2,4.6964373885377463E-2]
[null,1298.1500000000001,4.863766112145284E-2,3.4156438432156197E-2,5.0247493452370368E-2]
[null,1398.15,5.1447068546945175E-2,3.449294499375672E-2,5.3302241006314151E-2]
[null,1498.15,5.4058184254815046E-2,3.4768267411519262E-2,5.6129528519727044E-2]
[null,1598.15,5.6481593344636788E-2,3.4978613706224078E-2,5.8729276878975993E-2]
[null,{"$f":"B109+100","v":1698.15},5.8726738433934951E-2,3.512220441416037E-2,6.1102028305080228E-2]
[null,1798.15,6.0802757986722758E-2,3.5199272587126282E-2,6.3250168554306749E-2]
[null,1898.15,6.2719097451418696E-2,3.5212063792428944E-2,6.5178878386205577E-2]
[null,1998.15,6.44859633083531E-2,3.5164836112884512E-2,6.6896892032876715E-2]
[null,2098.15,6.6114666122045307E-2,3.5063860146817963E-2,6.8417114711073396E-2]
[null,2198.15,6.7617883646432217E-2,3.4917419008063381E-2,6.9757134919174998E-2]
[null,2298.15,6.9009865348526545E-2,3.4735808325963735E-2,7.0939656635408105E-2]
[null,2398.15,7.0306593337615339E-2,3.4531336245371011E-2,7.1992869436026397E-2]
[null,2498.15,7.1525910396216072E-2,3.431832342664607E-2,7.2950769705698193E-2]
[null,2598.15,7.2687622867124255E-2,3.4113103045658885E-2,7.3853442736354386E-2]
[null,2698.15,7.3813584098872564E-2,3.393402079378826E-2,7.4747313115823638E-2]
[null,2798.15,7.4927762697964431E-2,3.3801434877922046E-2,7.5685369080008946E-2]
[null,2898.15,7.6056298791120872E-2,3.373771602045697E-2,7.6727365236848699E-2]
[null,2998.15,7.7227550739546832E-2,3.3767247459298794E-2,7.7940007129998823E-2]
[null,3098.15,7.8472134185963632E-2,3.3916424947862379E-2,7.9397120402213223E-2]
[null,3198.15,7.9822954896646092E-2,3.4213656755071188E-2,8.1179806778791858E-2]
[null,3298.15,8.131523654535748E-2,3.4689363665357999E-2,8.3376588675444285E-2]
[null,3398.15,8.2986544346129676E-2,3.537597897866445E-2,8.6083543910697988E-2]
[null,3498.15,8.4876805257607407E-2,3.6307948510441029E-2,8.9404431747787616E-2]
[null,3598.15,8.702832533900684E-2,3.7521730591647408E-2,9.3450811288165139E-2]
[null,3698.15,8.948580472637703E-2,3.9055796068751827E-2,9.8342153076188293E-2]
[null,3798.15,9.2296350610278161E-2,4.0950628303732153E-2,0.10420594464311483]
[null,3898.15,9.5509488526625885E-2,4.324872317407448E-2,0.11117779061140984]
[null,3998.15,9.9177172217154413E-2,4.5994589072774414E-2,0.11940150789246619]
[null,4098.1499999999996,0.1033537922715857,4.9234746908336194E-2,0.1290292164381148]
[null,4198.1499999999996,0.10809618372778579,5.3017730104773321E-2,0.14022142594581205]
[null,4298.1499999999996,0.11346363277713209,5.7394084601608088E-2,0.15314711886669172]
[null,4398.1499999999996,0.1195178826986041,6.2416368853871612E-2,0.16798383002296718]
[null,4498.1499999999996,0.12632313912566673,6.813915383210406E-2,0.18491772310496726]
[null,4598.1499999999996,0.13394607473399009,7.4619023022355027E-2,0.20414366428724437]
[null,4698.1499999999996,0.14245583342479071,8.1914572426182275E-2,0.22586529317676876]
[null,4798.1499999999996,0.1519240340675454,9.0086410560653057E-2,0.25029509128349969]
[null,4898.1499999999996,0.16242477385662452,9.9197158458343385E-2,0.27765444818393431]
[null,4998.1499999999996,0.17403463132867181,0.1093114496673387,0.3081737255311765]

{"sheet":"Ejercicio","index":5,"n_rows":31,"n_cols":10,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["y"]
[400]
[]
[]
[null,"xi","Ai","Bi","Ci","Di",null,null,"n (reglón)",4]
[null,0.3,10,25,36,40,null,null,"m (columna)",3]
[null,0.3,20,23,35,41]
[null,0.2,30,25,38,42,null,null,"Elemento",{"$f":"ElemMatriz(J10,J11,C11:F14)","v":39}]
[null,0.2,40,24,39,43]
[]
[]
[null,null,"Ai","Bi","Ci","Di"]
[]
[]
[]
[]
[]
[null,null,"A","B","C","D"]
[]
[]
[]
[]
[null,null,null,"I"]
[]
[]
[null,null,null,"I"]

{"sheet":"PosFalsa","index":6,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[9,1,9,2]]}
[]
[]
[]
[]
[]
[null,"Convergencia",1.0000000000000001E-5]
[null,"a",-100]
[null,"b",100]
[]
[null,"Posicion falsa"]
[null,"x",{"$f":"PosFalsa(C7,C8,C6)","v":-2.2134135078540993}]
[null,"f(x)",{"$f":"fu(C11)","v":-9.9950661827108433E-6}]

{"sheet":"Secante","index":7,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[[13,1,13,2]]}
[]
[]
[]
[]
[]
[null,"xtol",1.0000000000000001E-5]
[null,"ytol",1.0000000000000001E-5]
[null,"Nmax",100]
[null,"a",-100]
[null,"b",100]
[]
[]
[]
[null,"Secante"]
[null,"x",{"$f":"Secante(C9,C10,C6,C7,C8)","v":-2.2134116662853804}]
[null,"f(x)",{"$f":"fu(C15)","v":-1.9085272917607199E-8}]

{"sheet":"Anexos","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}