{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["VF","P","T","ANTOINE"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":60,"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":"VF","index":0,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,6,0,11],[24,1,24,11],[25,1,25,11],[26,1,26,11],[13,4,13,6],[2,6,2,11]]}
["TERMODINÁMICA DEL EQUILIBRIO",null,null,null,null,null,"DESTILACION FLASH"]
["FEDERICO G. SALAZAR"]
[null,null,null,null,null,null,"CALCULO DE V/F"]
["N",2,"Número de componentes",null,null,null,"PROCEDIMIENTO:"]
["T ",700,"(ºK)",null,null,null,"1. Seleccione los números de los componentes en la carpeta ANTOINE"]
["P flash ",500,"(kPa)","Pburb ",{"$f":"J16*H16+J17*H17+J18*H18+J19*H19+J20*H20+J21*H21","v":1327.6628133809693},"(kPa)","2. Ingrese los datos requeridos de las casillas en amarillo"]
["F = ",55,"mol / hr","Procio ",{"$f":"1/(J16/H16+J17/H17+IF(B4>=3,J18/H18,0)+IF(B4>=4,J19/H19)+IF(B4>=5,J20/H20)+IF(B4=6,J21/H21))","v":1240.3156774479569},"(kPa)","3. Ajuste las condiciones de la destilación al intervalo de Rocío y Burbuja"]
["V = ",{"$f":"+B7*B10","v":48.45005896474742},"mol / hr",null,null,null,"4. En el menú HERRAMIENTAS seleccione SOLVER"]
["L = ",{"$f":"+(1-B10)*B7","v":6.5499410352525764},"mol / hr",null,null,null,"5. Presione RESOLVER y ACEPTAR"]
["V / F",0.8809101629954077]
[null,null,null,null,null,null,null,null,{"$f":"+IF(E6<B6,\"ALIMENTACIÓN MUY FRIA\",IF(E7>B6,\"ALIMENTACIÓN MUY CALIENTE\",\" \"))","v":"ALIMENTACIÓN MUY CALIENTE"}]
[null,null,null,null,null,"SOLVER",{"$f":"+(B16*I16)/(1+$B$10*(I16-1))+(B17*I17)/(1+$B$10*(I17-1))+(B18*I18)/(1+$B$10*(I18-1))+(B19*I19)/(1+$B$10*(I19-1))+(B20*I20)/(1+$B$10*(I20-1))+(B21*I21)/(1+$B$10*(I21-1))","v":1.0767345281978116},null,{"$f":"+IF(E6>B6,IF(E7<B6,\" \",\"EL FLASH NO ES POSIBLE A ESAS CONDICIONES\"),\"EL FLASH NO ES POSIBLE A ESAS CONDICIONES\")","v":"EL FLASH NO ES POSIBLE A ESAS CONDICIONES"}]
[]
[" componente",null,null,null,"log10 Pvap  =  A  -  [B / (T °C +  C)] bar",null,null,"(kPa)","Psati / P",null,"yi P /     Psati","(zi Ki) / (1+V/F(Ki-1))"]
["No.","zi","Fórmula","componente","A","B","C","Psati  ","Ki","zi","xi","yi"]
[1,0.62,{"$f":"LOOKUP(A16,ANTOINE!A22:A107,ANTOINE!C22:C107)","v":"CH4"},{"$f":"LOOKUP(A16,ANTOINE!$A$22:$A$107,ANTOINE!$B$22:$B$107)","v":"Metano"},{"$f":"LOOKUP($A16,ANTOINE!$A$22:$A$107,ANTOINE!$D$22:$D$107)","v":3.7686999999999999},{"$f":"LOOKUP($A16,ANTOINE!$A$22:$A$107,ANTOINE!$E$22:$E$107)","v":395.74400000000003},{"$f":"LOOKUP($A16,ANTOINE!$A$22:$A$107,ANTOINE!$F$22:$F$107)","v":266.68099999999998},{"$f":"+IF($E$16=0,\"ND\",POWER(10,$E$16-($F$16/($B$5-273.15+$G$16))))","v":1577.8948791720877},{"$f":"+H16/$B$6","v":3.1557897583441754},{"$f":"+B16","v":0.62},{"$f":"+(L16*$B$6)/H16","v":0.21386263775762218},{"$f":"+(J16*I16)/(1+$B$10*(I16-1))","v":0.67490552192797437}]
[56,0.38,{"$f":"LOOKUP(A17,ANTOINE!A23:A108,ANTOINE!C23:C108)","v":"CH5N"},{"$f":"LOOKUP(A17,ANTOINE!$A$22:$A$107,ANTOINE!$B$22:$B$107)","v":"Metilamina"},{"$f":"LOOKUP(A17,ANTOINE!$A$22:$A$107,ANTOINE!$D$22:$D$107)","v":4.5442},{"$f":"LOOKUP($A17,ANTOINE!$A$22:$A$107,ANTOINE!$E$22:$E$107)","v":1050.6600000000001},{"$f":"LOOKUP($A17,ANTOINE!$A$22:$A$107,ANTOINE!$F$22:$F$107)","v":237.83},{"$f":"+IF($E17=0,\"ND\",POWER(10,$E17-($F17/($B$5-273.15+$G17))))","v":919.38944287967092},{"$f":"+H17/$B$6","v":1.8387788857593419},0.38,{"$f":"+(L17*$B$6)/H17","v":0.21853035695692033},{"$f":"+(J17*I17)/(1+$B$10*(I17-1))","v":0.4018290062698372}]
[null,null,{"$f":"IF(A18>0,LOOKUP(A18,ANTOINE!A24:A109,ANTOINE!C24:C109),\" \")","v":" "},{"$f":"IF(A18>0,LOOKUP(A18,ANTOINE!$A$22:$A$107,ANTOINE!$B$22:$B$107),\"  \")","v":"  "},{"$f":"IF(A18>0,LOOKUP(A18,ANTOINE!$A$22:$A$107,ANTOINE!$D$22:$D$107),\" \")","v":" "},{"$f":"IF(A18>0,LOOKUP($A18,ANTOINE!$A$22:$A$107,ANTOINE!$E$22:$E$107),\" \")","v":" "},{"$f":"IF(A18>0,LOOKUP($A18,ANTOINE!$A$22:$A$107,ANTOINE!$F$22:$F$107),\" \")","v":" "},{"$f":"+IF(A18=0,0,POWER(10,$E18-($F18/($B$5-273.15+$G18))))","v":0},{"$f":"IF(A18>0,H18/$B$6,0)","v":0},0,{"$f":"+IF(A19=0,0,(L18*$B$6)/H18)","v":0},{"$f":"+(J18*I18)/(1+$B$10*(I18-1))","v":0}]
[null,null,{"$f":"IF(A19>0,LOOKUP(A19,ANTOINE!A25:A110,ANTOINE!C25:C110),\" \")","v":" "},{"$f":"IF(A19>0,LOOKUP(A19,ANTOINE!$A$22:$A$107,ANTOINE!$B$22:$B$107),\"  \")","v":"  "},{"$f":"IF(A19>0,LOOKUP(A19,ANTOINE!$A$22:$A$107,ANTOINE!$D$22:$D$107),\" \")","v":" "},{"$f":"IF(A19>0,LOOKUP($A19,ANTOINE!$A$22:$A$107,ANTOINE!$E$22:$E$107),\" \")","v":" "},{"$f":"IF(A19>0,LOOKUP($A19,ANTOINE!$A$22:$A$107,ANTOINE!$F$22:$F$107),\" \")","v":" "},{"$f":"+IF($A19=0,0,POWER(10,$E19-($F19/($B$5-273.15+$G19))))","v":0},{"$f":"IF(A19>0,H19/$B$6,0)","v":0},0,{"$f":"+IF(A20=0,0,(L19*$B$6)/H19)","v":0},{"$f":"+(J19*I19)/(1+$B$10*(I19-1))","v":0}]
[null,null,{"$f":"IF(A20>0,LOOKUP(A20,ANTOINE!A26:A111,ANTOINE!C26:C111),\" \")","v":" "},{"$f":"IF(A20>0,LOOKUP(A20,ANTOINE!$A$22:$A$107,ANTOINE!$B$22:$B$107),\"  \")","v":"  "},{"$f":"IF(A20>0,LOOKUP(A20,ANTOINE!$A$22:$A$107,ANTOINE!$D$22:$D$107),\" \")","v":" "},{"$f":"IF(A20>0,LOOKUP($A20,ANTOINE!$A$22:$A$107,ANTOINE!$E$22:$E$107),\" \")","v":" "},{"$f":"IF(A20>0,LOOKUP($A20,ANTOINE!$A$22:$A$107,ANTOINE!$F$22:$F$107),\" \")","v":" "},{"$f":"+IF($A20=0,0,POWER(10,$E20-($F20/($B$5-273.15+$G20))))","v":0},{"$f":"IF(A20>0,H20/$B$6,0)","v":0},0,{"$f":"+IF(A20=0,0,(L20*$B$6)/H20)","v":0},{"$f":"+IF(A20=0,0,(J20*I20)/(1+$B$10*(I20-1)))","v":0}]
[null,null,{"$f":"IF(A21>0,LOOKUP(A21,ANTOINE!A27:A112,ANTOINE!C27:C112),\" \")","v":" "},{"$f":"IF(A21>0,LOOKUP(A21,ANTOINE!$A$22:$A$107,ANTOINE!$B$22:$B$107),\"  \")","v":"  "},{"$f":"IF(A21>0,LOOKUP(A21,ANTOINE!$A$22:$A$107,ANTOINE!$D$22:$D$107),\" \")","v":" "},{"$f":"IF(A21>0,LOOKUP($A21,ANTOINE!$A$22:$A$107,ANTOINE!$E$22:$E$107),\" \")","v":" "},{"$f":"IF(A21>0,LOOKUP($A21,ANTOINE!$A$22:$A$107,ANTOINE!$F$22:$F$107),\" \")","v":" "},{"$f":"+IF($A21=0,0,POWER(10,$E21-($F21/($B$5-273.15+$G21))))","v":0},{"$f":"IF(A21>0,H21/$B$6,0)","v":0},0,{"$f":"+IF(A20=0,0,(L21*$B$6)/H21)","v":0},{"$f":"+IF(A20=0,0,(J21*I21)/(1+$B$10*(I21-1)))","v":0}]
[null,{"$f":"SUM(J16:J21)","v":1},null,null,null,null,null,null,null,{"$f":"SUM(J16:J21)","v":1},{"$f":"SUM(K16:K21)","v":0.43239299471454251},{"$f":"SUM(L16:L21)","v":1.0767345281978116}]
[]
["REFERENCIAS BIBLIOGRÁFICAS:"]
[1,"SMITH, J.M., H.C. VAN NES & M.M. ABBOTT. (2005). Introduction to Chemical Engineering Thermodynamics. Seventh Edition. McGraw Hill. New York."]
[2,"POLING, BRUCE; PRAUSNITZ, JOHN; & O`CONNELL, JOHN. (2001). The Properties of Gases and Liquids. Fifth edition. McGraw Hill. New York."]
[3,"SOTO AGÜERA, ANDRÉS.(2004). Separaciones básicas: Destilación Flash. Universidad Politécnica de Madrid. Consultado en:  http://www.diquima.upm.es/docencia/obiq/OB%20notas%20de%20clase%20flash.pdf"]

{"sheet":"P","index":1,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,6,0,11],[24,1,24,11],[25,1,25,11],[26,1,26,11],[13,4,13,6],[2,6,2,11]]}
["TERMODINÁMICA DEL EQUILIBRIO",null,null,null,null,null,"DESTILACION FLASH"]
["FEDERICO G. SALAZAR"]
[null,null,null,null,null,null,"CALCULO DE P"]
["N",3,"Número de componentes",null,null,null,"PROCEDIMIENTO:"]
["T ",700,"(ºK)",null,null,null,"1. Seleccione los números de los componentes en la carpeta ANTOINE"]
["P flash ",499.99218559085097,"(kPa)","Pburb ",{"$f":"J16*H16+J17*H17+J18*H18+J19*H19+J20*H20+J21*H21","v":1224.9414536195975},"(kPa)","2. Ingrese los datos requeridos de las casillas en amarillo"]
["F = ",55,"mol / hr","Procio ",{"$f":"1/(J16/H16+J17/H17+IF(B4>=3,J18/H18,0)+IF(B4>=4,J19/H19)+IF(B4>=5,J20/H20)+IF(B4=6,J21/H21))","v":204.30262770943926},"(kPa)","3. Ajuste las condiciones de la destilación al intervalo de Rocío y Burbuja"]
["V = ",{"$f":"+B7*B10","v":48.450049999999997},"mol / hr",null,null,null,"4. En el menú HERRAMIENTAS seleccione SOLVER"]
["L = ",{"$f":"+(1-B10)*B7","v":6.5499500000000017},"mol / hr",null,null,null,"5. Presione RESOLVER y ACEPTAR"]
["V / F",0.88090999999999997]
[null,null,null,null,null,null,null,null,{"$f":"+IF(E6<B6,\"ALIMENTACIÓN MUY FRIA\",IF(E7>B6,\"ALIMENTACIÓN MUY CALIENTE\",\" \"))","v":" "}]
[null,null,null,null,null,"SOLVER",{"$f":"+(B16*H16/B6)/(1+B10*(H16/B6-1))+(B17*H17/B6)/(1+B10*(H17/B6-1))+(B18*H18/B6)/(1+B10*(H18/B6-1))+(B19*H19/B6)/(1+B10*(H19/B6-1))+(B20*H20/B6)/(1+B10*(H20/B6-1))+(B21*H21/B6)/(1+B10*(H21/B6-1))","v":1.0000009235695042},null,{"$f":"+IF(E6>B6,IF(E7<B6,\" \",\"EL FLASH NO ES POSIBLE A ESAS CONDICIONES\"),\"EL FLASH NO ES POSIBLE A ESAS CONDICIONES\")","v":" "}]
[]
[" componente",null,null,null,"log10 Pvap  =  A  -  [B / (T °C +  C)] bar",null,null,"(kPa)","Psati / P",null,"yi P /     Psati","(zi Ki) / (1+V/F(Ki-1))"]
["No.","zi","Fórmula","componente","A","B","C","Psati  ","Ki","zi","xi","yi"]
[1,0.6,{"$f":"LOOKUP(A16,ANTOINE!A22:A107,ANTOINE!C22:C107)","v":"CH4"},{"$f":"LOOKUP(A16,ANTOINE!$A$22:$A$107,ANTOINE!$B$22:$B$107)","v":"Metano"},{"$f":"LOOKUP($A16,ANTOINE!$A$22:$A$107,ANTOINE!$D$22:$D$107)","v":3.7686999999999999},{"$f":"LOOKUP($A16,ANTOINE!$A$22:$A$107,ANTOINE!$E$22:$E$107)","v":395.74400000000003},{"$f":"LOOKUP($A16,ANTOINE!$A$22:$A$107,ANTOINE!$F$22:$F$107)","v":266.68099999999998},{"$f":"+IF($E$16=0,\"ND\",POWER(10,$E$16-($F$16/($B$5-273.15+$G$16))))","v":1577.8948791720877},{"$f":"+H16/$B$6","v":3.1558390803797405},{"$f":"+B16","v":0.6},{"$f":"+(L16*$B$6)/H16","v":0.20696076634764948},{"$f":"+(J16*I16)/(1+$B$10*(I16-1))","v":0.65313487454525254}]
[56,0.3,{"$f":"LOOKUP(A17,ANTOINE!A23:A108,ANTOINE!C23:C108)","v":"CH5N"},{"$f":"LOOKUP(A17,ANTOINE!$A$22:$A$107,ANTOINE!$B$22:$B$107)","v":"Metilamina"},{"$f":"LOOKUP(A17,ANTOINE!$A$22:$A$107,ANTOINE!$D$22:$D$107)","v":4.5442},{"$f":"LOOKUP($A17,ANTOINE!$A$22:$A$107,ANTOINE!$E$22:$E$107)","v":1050.6600000000001},{"$f":"LOOKUP($A17,ANTOINE!$A$22:$A$107,ANTOINE!$F$22:$F$107)","v":237.83},{"$f":"+IF($E17=0,\"ND\",POWER(10,$E17-($F17/($B$5-273.15+$G17))))","v":919.38944287967092},{"$f":"+H17/$B$6","v":1.8388076241495848},0.3,{"$f":"+(L17*$B$6)/H17","v":0.17252146789707418},{"$f":"+(J17*I17)/(1+$B$10*(I17-1))","v":0.31723379049861783}]
[34,0.1,{"$f":"IF(A18>0,LOOKUP(A18,ANTOINE!A24:A109,ANTOINE!C24:C109),\" \")","v":"C10H8"},{"$f":"IF(A18>0,LOOKUP(A18,ANTOINE!$A$22:$A$107,ANTOINE!$B$22:$B$107),\"  \")","v":"Naftaleno"},{"$f":"IF(A18>0,LOOKUP(A18,ANTOINE!$A$22:$A$107,ANTOINE!$D$22:$D$107),\" \")","v":4.1355500000000003},{"$f":"IF(A18>0,LOOKUP($A18,ANTOINE!$A$22:$A$107,ANTOINE!$E$22:$E$107),\" \")","v":1733.71},{"$f":"IF(A18>0,LOOKUP($A18,ANTOINE!$A$22:$A$107,ANTOINE!$F$22:$F$107),\" \")","v":201.85900000000001},{"$f":"+IF(A18=0,0,POWER(10,$E18-($F18/($B$5-273.15+$G18))))","v":23.876932524438054},{"$f":"IF(A18>0,H18/$B$6,0)","v":4.775461139702053E-2},0.1,{"$f":"+(L18*$B$6)/H18","v":0.62051093410180436},{"$f":"+(J18*I18)/(1+$B$10*(I18-1))","v":2.9632258525633878E-2}]
[null,null,{"$f":"IF(A19>0,LOOKUP(A19,ANTOINE!A25:A110,ANTOINE!C25:C110),\" \")","v":" "},{"$f":"IF(A19>0,LOOKUP(A19,ANTOINE!$A$22:$A$107,ANTOINE!$B$22:$B$107),\"  \")","v":"  "},{"$f":"IF(A19>0,LOOKUP(A19,ANTOINE!$A$22:$A$107,ANTOINE!$D$22:$D$107),\" \")","v":" "},{"$f":"IF(A19>0,LOOKUP($A19,ANTOINE!$A$22:$A$107,ANTOINE!$E$22:$E$107),\" \")","v":" "},{"$f":"IF(A19>0,LOOKUP($A19,ANTOINE!$A$22:$A$107,ANTOINE!$F$22:$F$107),\" \")","v":" "},{"$f":"+IF($A19=0,0,POWER(10,$E19-($F19/($B$5-273.15+$G19))))","v":0},{"$f":"IF(A19>0,H19/$B$6,0)","v":0},0,{"$f":"+IF(A20=0,0,(L19*$B$6)/H19)","v":0},{"$f":"+(J19*I19)/(1+$B$10*(I19-1))","v":0}]
[null,null,{"$f":"IF(A20>0,LOOKUP(A20,ANTOINE!A26:A111,ANTOINE!C26:C111),\" \")","v":" "},{"$f":"IF(A20>0,LOOKUP(A20,ANTOINE!$A$22:$A$107,ANTOINE!$B$22:$B$107),\"  \")","v":"  "},{"$f":"IF(A20>0,LOOKUP(A20,ANTOINE!$A$22:$A$107,ANTOINE!$D$22:$D$107),\" \")","v":" "},{"$f":"IF(A20>0,LOOKUP($A20,ANTOINE!$A$22:$A$107,ANTOINE!$E$22:$E$107),\" \")","v":" "},{"$f":"IF(A20>0,LOOKUP($A20,ANTOINE!$A$22:$A$107,ANTOINE!$F$22:$F$107),\" \")","v":" "},{"$f":"+IF($A20=0,0,POWER(10,$E20-($F20/($B$5-273.15+$G20))))","v":0},{"$f":"IF(A20>0,H20/$B$6,0)","v":0},0,{"$f":"+IF(A20=0,0,(L20*$B$6)/H20)","v":0},{"$f":"+IF(A20=0,0,(J20*I20)/(1+$B$10*(I20-1)))","v":0}]
[null,null,{"$f":"IF(A21>0,LOOKUP(A21,ANTOINE!A27:A112,ANTOINE!C27:C112),\" \")","v":" "},{"$f":"IF(A21>0,LOOKUP(A21,ANTOINE!$A$22:$A$107,ANTOINE!$B$22:$B$107),\"  \")","v":"  "},{"$f":"IF(A21>0,LOOKUP(A21,ANTOINE!$A$22:$A$107,ANTOINE!$D$22:$D$107),\" \")","v":" "},{"$f":"IF(A21>0,LOOKUP($A21,ANTOINE!$A$22:$A$107,ANTOINE!$E$22:$E$107),\" \")","v":" "},{"$f":"IF(A21>0,LOOKUP($A21,ANTOINE!$A$22:$A$107,ANTOINE!$F$22:$F$107),\" \")","v":" "},{"$f":"+IF($A21=0,0,POWER(10,$E21-($F21/($B$5-273.15+$G21))))","v":0},{"$f":"IF(A21>0,H21/$B$6,0)","v":0},0,{"$f":"+IF(A20=0,0,(L21*$B$6)/H21)","v":0},{"$f":"+IF(A20=0,0,(J21*I21)/(1+$B$10*(I21-1)))","v":0}]
[null,{"$f":"SUM(J16:J21)","v":0.99999999999999989},null,null,null,null,null,null,null,{"$f":"SUM(J16:J21)","v":0.99999999999999989},{"$f":"SUM(K16:K21)","v":0.99999316834652796},{"$f":"SUM(L16:L21)","v":1.0000009235695042}]
[]
["REFERENCIAS BIBLIOGRÁFICAS:"]
[1,"SMITH, J.M., H.C. VAN NES & M.M. ABBOTT. (2005). Introduction to Chemical Engineering Thermodynamics. Seventh Edition. McGraw Hill. New York."]
[2,"POLING, BRUCE; PRAUSNITZ, JOHN; & O`CONNELL, JOHN. (2001). The Properties of Gases and Liquids. Fifth edition. McGraw Hill. New York."]
[3,"SOTO AGÜERA, ANDRÉS.(2004). Separaciones básicas: Destilación Flash. Universidad Politécnica de Madrid. Consultado en:  http://www.diquima.upm.es/docencia/obiq/OB%20notas%20de%20clase%20flash.pdf"]

{"sheet":"T","index":2,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,6,0,11],[24,1,24,11],[25,1,25,11],[26,1,26,11],[13,4,13,6],[2,6,2,11]]}
["TERMODINÁMICA DEL EQUILIBRIO",null,null,null,null,null,"DESTILACION FLASH"]
["FEDERICO G. SALAZAR"]
[null,null,null,null,null,null,"CALCULO DE T"]
["N",3,"Número de componentes",null,null,null,"PROCEDIMIENTO:"]
["T ",700.00054578344145,"(ºK)",null,null,null,"1. Seleccione los números de los componentes en la carpeta ANTOINE"]
["P flash ",500,"(kPa)","Pburb ",{"$f":"J16*H16+J17*H17+J18*H18+J19*H19+J20*H20+J21*H21","v":1224.9432700187813},"(kPa)","2. Ingrese los datos requeridos de las casillas en amarillo"]
["F = ",55,"mol / hr","Procio ",{"$f":"1/(J16/H16+J17/H17+IF(B4>=3,J18/H18,0)+IF(B4>=4,J19/H19)+IF(B4>=5,J20/H20)+IF(B4=6,J21/H21))","v":204.30364839495817},"(kPa)","3. Ajuste las condiciones de la destilación al intervalo de Rocío y Burbuja"]
["V = ",{"$f":"+B7*B10","v":48.450049999999997},"mol / hr",null,null,null,"4. En el menú HERRAMIENTAS seleccione SOLVER"]
["L = ",{"$f":"+(1-B10)*B7","v":6.5499500000000017},"mol / hr",null,null,null,"5. Presione RESOLVER y ACEPTAR"]
["V / F",0.88090999999999997]
[null,null,null,null,null,null,null,null,{"$f":"+IF(E6<B6,\"ALIMENTACIÓN MUY FRIA\",IF(E7>B6,\"ALIMENTACIÓN MUY CALIENTE\",\" \"))","v":" "}]
[null,null,null,null,null,"SOLVER",{"$f":"+(B16*H16/B6)/(1+B10*(H16/B6-1))+(B17*H17/B6)/(1+B10*(H17/B6-1))+(B18*H18/B6)/(1+B10*(H18/B6-1))+(B19*H19/B6)/(1+B10*(H19/B6-1))+(B20*H20/B6)/(1+B10*(H20/B6-1))+(B21*H21/B6)/(1+B10*(H21/B6-1))","v":1.0000000358352339},null,{"$f":"+IF(E6>B6,IF(E7<B6,\" \",\"EL FLASH NO ES POSIBLE A ESAS CONDICIONES\"),\"EL FLASH NO ES POSIBLE A ESAS CONDICIONES\")","v":" "}]
[]
[" componente",null,null,null,"log10 Pvap  =  A  -  [B / (T °C +  C)] bar",null,null,"(kPa)","Psati / P",null,"yi P /     Psati","(zi Ki) / (1+V/F(Ki-1))"]
["No.","zi","Fórmula","componente","A","B","C","Psati  ","Ki","zi","xi","yi"]
[1,0.6,{"$f":"LOOKUP(A16,ANTOINE!A22:A107,ANTOINE!C22:C107)","v":"CH4"},{"$f":"LOOKUP(A16,ANTOINE!$A$22:$A$107,ANTOINE!$B$22:$B$107)","v":"Metano"},{"$f":"LOOKUP($A16,ANTOINE!$A$22:$A$107,ANTOINE!$D$22:$D$107)","v":3.7686999999999999},{"$f":"LOOKUP($A16,ANTOINE!$A$22:$A$107,ANTOINE!$E$22:$E$107)","v":395.74400000000003},{"$f":"LOOKUP($A16,ANTOINE!$A$22:$A$107,ANTOINE!$F$22:$F$107)","v":266.68099999999998},{"$f":"+IF($E$16=0,\"ND\",POWER(10,$E$16-($F$16/($B$5-273.15+$G$16))))","v":1577.8965107077706},{"$f":"+H16/$B$6","v":3.1557930214155414},{"$f":"+B16","v":0.6},{"$f":"+(L16*$B$6)/H16","v":0.20696366286798967},{"$f":"+(J16*I16)/(1+$B$10*(I16-1))","v":0.65313448296540055}]
[56,0.3,{"$f":"LOOKUP(A17,ANTOINE!A23:A108,ANTOINE!C23:C108)","v":"CH5N"},{"$f":"LOOKUP(A17,ANTOINE!$A$22:$A$107,ANTOINE!$B$22:$B$107)","v":"Metilamina"},{"$f":"LOOKUP(A17,ANTOINE!$A$22:$A$107,ANTOINE!$D$22:$D$107)","v":4.5442},{"$f":"LOOKUP($A17,ANTOINE!$A$22:$A$107,ANTOINE!$E$22:$E$107)","v":1050.6600000000001},{"$f":"LOOKUP($A17,ANTOINE!$A$22:$A$107,ANTOINE!$F$22:$F$107)","v":237.83},{"$f":"+IF($E17=0,\"ND\",POWER(10,$E17-($F17/($B$5-273.15+$G17))))","v":919.39219060188645},{"$f":"+H17/$B$6","v":1.838784381203773},0.3,{"$f":"+(L17*$B$6)/H17","v":0.17252349928495939},{"$f":"+(J17*I17)/(1+$B$10*(I17-1))","v":0.31723351587580362}]
[34,0.1,{"$f":"IF(A18>0,LOOKUP(A18,ANTOINE!A24:A109,ANTOINE!C24:C109),\" \")","v":"C10H8"},{"$f":"IF(A18>0,LOOKUP(A18,ANTOINE!$A$22:$A$107,ANTOINE!$B$22:$B$107),\"  \")","v":"Naftaleno"},{"$f":"IF(A18>0,LOOKUP(A18,ANTOINE!$A$22:$A$107,ANTOINE!$D$22:$D$107),\" \")","v":4.1355500000000003},{"$f":"IF(A18>0,LOOKUP($A18,ANTOINE!$A$22:$A$107,ANTOINE!$E$22:$E$107),\" \")","v":1733.71},{"$f":"IF(A18>0,LOOKUP($A18,ANTOINE!$A$22:$A$107,ANTOINE!$F$22:$F$107),\" \")","v":201.85900000000001},{"$f":"+IF(A18=0,0,POWER(10,$E18-($F18/($B$5-273.15+$G18))))","v":23.877064135531015},{"$f":"IF(A18>0,H18/$B$6,0)","v":4.7754128271062027E-2},0.1,{"$f":"+(L18*$B$6)/H18","v":0.62051257277344263},{"$f":"+(J18*I18)/(1+$B$10*(I18-1))","v":2.9632036994029692E-2}]
[null,null,{"$f":"IF(A19>0,LOOKUP(A19,ANTOINE!A25:A110,ANTOINE!C25:C110),\" \")","v":" "},{"$f":"IF(A19>0,LOOKUP(A19,ANTOINE!$A$22:$A$107,ANTOINE!$B$22:$B$107),\"  \")","v":"  "},{"$f":"IF(A19>0,LOOKUP(A19,ANTOINE!$A$22:$A$107,ANTOINE!$D$22:$D$107),\" \")","v":" "},{"$f":"IF(A19>0,LOOKUP($A19,ANTOINE!$A$22:$A$107,ANTOINE!$E$22:$E$107),\" \")","v":" "},{"$f":"IF(A19>0,LOOKUP($A19,ANTOINE!$A$22:$A$107,ANTOINE!$F$22:$F$107),\" \")","v":" "},{"$f":"+IF($A19=0,0,POWER(10,$E19-($F19/($B$5-273.15+$G19))))","v":0},{"$f":"IF(A19>0,H19/$B$6,0)","v":0},0,{"$f":"+IF(A20=0,0,(L19*$B$6)/H19)","v":0},{"$f":"+(J19*I19)/(1+$B$10*(I19-1))","v":0}]
[null,null,{"$f":"IF(A20>0,LOOKUP(A20,ANTOINE!A26:A111,ANTOINE!C26:C111),\" \")","v":" "},{"$f":"IF(A20>0,LOOKUP(A20,ANTOINE!$A$22:$A$107,ANTOINE!$B$22:$B$107),\"  \")","v":"  "},{"$f":"IF(A20>0,LOOKUP(A20,ANTOINE!$A$22:$A$107,ANTOINE!$D$22:$D$107),\" \")","v":" "},{"$f":"IF(A20>0,LOOKUP($A20,ANTOINE!$A$22:$A$107,ANTOINE!$E$22:$E$107),\" \")","v":" "},{"$f":"IF(A20>0,LOOKUP($A20,ANTOINE!$A$22:$A$107,ANTOINE!$F$22:$F$107),\" \")","v":" "},{"$f":"+IF($A20=0,0,POWER(10,$E20-($F20/($B$5-273.15+$G20))))","v":0},{"$f":"IF(A20>0,H20/$B$6,0)","v":0},0,{"$f":"+IF(A20=0,0,(L20*$B$6)/H20)","v":0},{"$f":"+IF(A20=0,0,(J20*I20)/(1+$B$10*(I20-1)))","v":0}]
[null,null,{"$f":"IF(A21>0,LOOKUP(A21,ANTOINE!A27:A112,ANTOINE!C27:C112),\" \")","v":" "},{"$f":"IF(A21>0,LOOKUP(A21,ANTOINE!$A$22:$A$107,ANTOINE!$B$22:$B$107),\"  \")","v":"  "},{"$f":"IF(A21>0,LOOKUP(A21,ANTOINE!$A$22:$A$107,ANTOINE!$D$22:$D$107),\" \")","v":" "},{"$f":"IF(A21>0,LOOKUP($A21,ANTOINE!$A$22:$A$107,ANTOINE!$E$22:$E$107),\" \")","v":" "},{"$f":"IF(A21>0,LOOKUP($A21,ANTOINE!$A$22:$A$107,ANTOINE!$F$22:$F$107),\" \")","v":" "},{"$f":"+IF($A21=0,0,POWER(10,$E21-($F21/($B$5-273.15+$G21))))","v":0},{"$f":"IF(A21>0,H21/$B$6,0)","v":0},0,{"$f":"+IF(A20=0,0,(L21*$B$6)/H21)","v":0},{"$f":"+IF(A20=0,0,(J21*I21)/(1+$B$10*(I21-1)))","v":0}]
[null,{"$f":"SUM(J16:J21)","v":0.99999999999999989},null,null,null,null,null,null,null,{"$f":"SUM(J16:J21)","v":0.99999999999999989},{"$f":"SUM(K16:K21)","v":0.99999973492639171},{"$f":"SUM(L16:L21)","v":1.0000000358352339}]
[]
["REFERENCIAS BIBLIOGRÁFICAS:"]
[1,"SMITH, J.M., H.C. VAN NES & M.M. ABBOTT. (2005). Introduction to Chemical Engineering Thermodynamics. Seventh Edition. McGraw Hill. New York."]
[2,"POLING, BRUCE; PRAUSNITZ, JOHN; & O`CONNELL, JOHN. (2001). The Properties of Gases and Liquids. Fifth edition. McGraw Hill. New York."]
[3,"SOTO AGÜERA, ANDRÉS.(2004). Separaciones básicas: Destilación Flash. Universidad Politécnica de Madrid. Consultado en:  http://www.diquima.upm.es/docencia/obiq/OB%20notas%20de%20clase%20flash.pdf"]

{"sheet":"ANTOINE","index":3,"n_rows":107,"n_cols":6,"rows_kept":107,"cut":false,"hidden":false,"merged":[]}
["CALCULO DE LA PRESION DE VAPOR PARA SUSTANCIAS PURAS"]
["ECUACION DE ANTOINE"]
[]
[null,null,"log10 Pvap  =  A  -  [B / (T °C +  C)] bar"]
[]
[null,"T =",50,"°C","<---- Ingrese temperatura"]
[null,"No. =",41,null,"<---- Ingrese No. de Sustancia"]
[]
[null,"Sustancia =",{"$f":"LOOKUP($C$7,$A$22:$A$107,$B$22:$B$107)","v":"Metil Etil Cetona"},{"$f":"LOOKUP(C7,A22:A107,C22:C107)","v":"C4H8O "}]
[]
[null,null,"A","B","C"]
[null,"Constantes =",{"$f":"LOOKUP($C$7,$A$22:$A$107,$D$22:$D$107)","v":4.1386000000000003},{"$f":"LOOKUP($C$7,$A$22:$A$107,$E$22:$E$107)","v":1232.6300000000001},{"$f":"LOOKUP($C$7,$A$22:$A$107,$F$22:$F$107)","v":218.69}]
[]
[null,"Valor Calculado:","Pvap =",{"$f":"+IF($C$12=0,\"ND\",POWER(10,$C$12-($D$12/($C$6+$E$12))))","v":0.35566863587561809},"bar"]
[]
[]
[null,"BASE DE DATOS"]
[null,"Ref:  POLING, BRUCE; PRAUSNITZ, JOHN & O'CONNELL, JOHN."]
[null,"        \"The Properties of Gases and Liquids\". 5th edition.  McGraw Hill.  New York.  2001"]
[]
["No.","SUSTANCIA","FORMULA","A","B","C"]
[1,"Metano","CH4",3.7686999999999999,395.74400000000003,266.68099999999998]
[2,"Etano","C2H6",3.9540500000000001,663.72,256.68099999999998]
[3,"Propano","C3H8",3.92828,803.99699999999996,247.04]
[4,"n-Butano","C4H10",3.9326599999999998,935.77300000000002,238.78899999999999]
[5,"n-Pentano","C5H12",3.9778600000000002,1064.8399999999999,232.01400000000001]
[6,"n-Hexano","C6H14",4.0013899999999998,1170.875,224.31700000000001]
[7,"n-Heptano","C7H16",4.0202299999999997,1263.9090000000001,216.43199999999999]
[8,"n-Octano","C8H18",4.0507499999999999,1356.36,209.63499999999999]
[9,"n-Nonano","C9H20",4.0735599999999996,1438.03,202.69399999999999]
[10,"Isobutano","C4H10",4.0027200000000001,947.54,248.87]
[11,"Isoctano","C8H18",4.0387700000000004,1335.22,213.41499999999999]
[12,"Ciclopentano","C5H10",4.0678299999999998,1152.5740000000001,234.51]
[13,"Ciclohexano","C6H12",3.9300199999999998,1182.7739999999999,220.61799999999999]
[14,"Metilciclopentano","C6H12",4.1819899999999999,1295.5429999999999,238.39]
[15,"Metilciclohexano","C7H14",3.9823200000000001,1290.9680000000001,223.70099999999999]
[16,"Etileno","C2H4",3.9138199999999999,596.52599999999995,256.37]
[17,"Propileno","C3H6",3.9560599999999999,789.62400000000002,247.58]
[18,"1-Buteno","C4H8",3.9178000000000002,908.8,238.54]
[19,"cis-2-Buteno","C4H8",4.0095799999999997,967.32,237.87299999999999]
[20,"trans-2-Buteno","C4H8",4.0082700000000004,967.5,240.84]
[21,"1-Hexeno","C6H12",4.1819899999999999,1295.5429999999999,238.39]
[22,"Isobutileno","C4H8",3.8095599999999998,866.25,234.64]
[23,"1,3-Butadieno","C4H6",3.9664000000000001,927.21,238.63]
[24,"Ciclohexeno","C6H10",560.4,-9.0810200000000005,5.75488]
[25,"Acetileno","C2H2",3.67374,528.66999999999996,228.79]
[26,"Benceno","C6H6",3.9852300000000001,1184.24,217.572]
[27,"Tolueno","C7H8",4.0500429999999996,1327.62,217.625]
[28,"Etilbenceno","C8H10",4.0686099999999996,1415.77,212.3]
[29,"Cumeno","C9H12",4.0611199999999998,1460.7660000000001,207.83]
[30,"o-Xileno","C8H10",4.0978899999999996,1458.7059999999999,212.041]
[31,"m-Xileno","C8H10",4.1405099999999999,1468.703,216.12]
[32,"p-Xileno","C8H10",4.10494,1446.8320000000001,214.62700000000001]
[33,"Estireno","C8H8"]
[34,"Naftaleno","C10H8",4.1355500000000003,1733.71,201.85900000000001]
[35,"Bifenilo","C12H10",4.1886999999999999,1841.48,185.15]
[36,"Formaldehido","CH20"]
[37,"Acetaldehido","C2H40"]
[38,"Acetato de Metilo","C3H6O2",4.18621,1156.43,219.69]
[39,"Acetato de Etilo","C4H8O2",4.13361,1195.1300000000001,212.47]
[40,"Acetona","C3H6O",4.2183999999999999,1197.01,228.06]
[41,"Metil Etil Cetona","C4H8O ",4.1386000000000003,1232.6300000000001,218.69]
[42,"Eter dietílico","C4H10O",4.1096199999999996,1090.6400000000001,231.2]
[43,"Eter metil t-butílico","C5H12O",3.8364799999999999,1052.47,210.88]
[44,"Metanol","CH4O",5.2027700000000001,1580.08,239.5]
[45,"Etanol","C2H6O",5.3367500000000003,1648.22,230.91800000000001]
[46,"1-Propanol","C3H8O",4.9999099999999999,1512.94,205.80699999999999]
[47,"1-Butanol","C4H10O",4.6493000000000002,1395.14,182.739]
[48,"1-Hexanol","C6H14O",4.1894799999999996,1295.5899999999999,152.51]
[49,"2-Propanol","C3H8O",5.24268,1580.92,219.61]
[50,"Fenol","C6H6O",4.2695999999999996,1523.42,175.4]
[51,"Etilenglicol","C2H6O2"]
[52,"Acido Acético","C2H4O2",4.5445599999999997,1555.12,224.65]
[53,"Acido n-butírico","C4H8O2",4.8234000000000004,1731.7080000000001,195.95500000000001]
[54,"Acido Benzoico","C7H6O2"]
[55,"Acetonitrilo","C2H3N"]
[56,"Metilamina","CH5N",4.5442,1050.6600000000001,237.83]
[57,"Etilamina","C2H7N",4.4340000000000002,1102.8800000000001,232.45]
[58,"Nitrometano","CH3NO2"]
[59,"Tetracloruro de carbono","CCl4",4.1044499999999999,1265.6320000000001,232.148]
[60,"Cloroformo","CHCl3",3.9628800000000002,1106.904,218.55199999999999]
[61,"Diclorometano","CH2Cl2",4.0762200000000002,1070.07,223.24]
[62,"Cloruro de metilo","CH3Cl",4.16533,920.86,245.58]
[63,"Cloruro de etilo","C2H5Cl",4.0908800000000003,1020.63,237.57]
[64,"Clorobenceno","C6H5Cl",4.0201200000000004,1378.79,211.7]
[65,"Argón","Ar",3.7414100000000001,304.22699999999998,267.32]
[66,"Kriptón","Kr",3.7555999999999998,416.38,264.45]
[67,"Xenón","Xe",3.7677900000000002,566.28200000000004,258.66000000000003]
[68,"Helio 4","He",1.6836,8.1547999999999998,273.70999999999998]
[69,"Hidrógeno","H2",2.9492799999999999,67.507800000000003,275.7]
[70,"Oxígeno","O2",3.8163399999999998,319.01299999999998,266.7]
[71,"Nitrógeno","N2 ",3.6194700000000002,255.68,266.55]
[72,"Cloro","Cl2",4.0628000000000002,861.34,246.33]
[73,"Monóxido de carbono","CO",3.8191199999999998,291.74299999999999,267.99599999999998]
[74,"Dióxido de carbono","CO2"]
[75,"Disulfuro de carbono","CS2"]
[76,"Sulfuro de hidrógeno","H2S ",4.2288199999999998,806.93299999999999,251.39]
[77,"Dióxido de Azufre","SO2",4.4071999999999996,999.9,237.19]
[78,"Trióxido de Azufre","SO3",6.1757499999999999,1735.31,236.5]
[79,"Oxido Nítrico","NO",5.8678999999999997,682.93859999999995,268.27]
[80,"Oxido Nitroso","N2O",4.1288400000000003,654.26,247.16]
[81,"Cloruro de hidrógeno","HCl",4.2949000000000002,745.78,258.88]
[82,"Cianuro de hidrógeno","CNH"]
[83,"Agua","H2O",647.29999999999995,-7.77224,1.4568399999999999]
[84,"Amoníaco","NH3",4.4854000000000003,926.13199999999995,240.17]
[85,"Acido Nítrico","HNO3"]
[86,"Acido Sulfurico","H2SO4"]