Spreadsheet: 194893d1353352794-using-solver-to-solve-across-multiple-cells-solver-help
Sheet: Pressure 70KPa

 | 10.1. Part 2 with Pressure Remaining Constant at 70 KPa
 | A | B | C | t1 | t2 |  | Pressure Kpa
acetonitrile: | 14.2724 | 2945.47 | 224 | 69.84457166392644 | 89.58359743606547 |  | 70
nitromethane: | 14.2043 | 2972.64 | 209
x1 | y1 | T | P-P2sat/(P1sat-P2sat) | P1sat
0 | 0 | 89.58359743606547
0.005 | 0.00934222353061206 | 89.38793328333422 | 0.004999065848047116 | 130.7911294285688
0.01 | 0.01861115945597539 | 89.25694520031057 | 0.0099999952759738 | 130.2781161918277
0.015 |  |  |  | 3.074002188770097
0.02 |  |  |  | 3.074002188770097
0.025 |  |  |  | 3.074002188770097
0.03 |  |  |  | 3.074002188770097
0.035 |  |  |  | 3.074002188770097
0.04 |  |  |  | 3.074002188770097
0.045 |  |  |  | 3.074002188770097
0.05 |  |  |  | 3.074002188770097
0.05499999999999999 |  |  |  | 3.074002188770097
0.05999999999999999 |  |  |  | 3.074002188770097
0.06499999999999999 |  |  |  | 3.074002188770097
0.06999999999999999 |  |  |  | 3.074002188770097
0.075 |  |  |  | 3.074002188770097
0.08 |  |  |  | 3.074002188770097
0.085 |  |  |  | 3.074002188770097
0.09000000000000001 |  |  |  | 3.074002188770097
0.09500000000000001 |  |  |  | 3.074002188770097
0.1 |  |  |  | 3.074002188770097
0.105 |  |  |  | 3.074002188770097
0.11 |  |  |  | 3.074002188770097
0.115 |  |  |  | 3.074002188770097
0.12 |  |  |  | 3.074002188770097
0.125 |  |  |  | 3.074002188770097
0.13 |  |  |  | 3.074002188770097
0.135 |  |  |  | 3.074002188770097
0.14 |  |  |  | 3.074002188770097
0.145 |  |  |  | 3.074002188770097
0.15 |  |  |  | 3.074002188770097
0.1550000000000001 |  |  |  | 3.074002188770097
0.1600000000000001 |  |  |  | 3.074002188770097
0.1650000000000001 |  |  |  | 3.074002188770097
0.1700000000000001 |  |  |  | 3.074002188770097
0.1750000000000001 |  |  |  | 3.074002188770097
0.1800000000000001 |  |  |  | 3.074002188770097
0.1850000000000001 |  |  |  | 3.074002188770097
0.1900000000000001 |  |  |  | 3.074002188770097
0.1950000000000001 |  |  |  | 3.074002188770097
0.2000000000000001 |  |  |  | 3.074002188770097
0.2050000000000001 |  |  |  | 3.074002188770097
0.2100000000000001 |  |  |  | 3.074002188770097
0.2150000000000001 |  |  |  | 3.074002188770097
0.2200000000000001 |  |  |  | 3.074002188770097
0.2250000000000001 |  |  |  | 3.074002188770097
0.2300000000000001 |  |  |  | 3.074002188770097
0.2350000000000001 |  |  |  | 3.074002188770097
0.2400000000000001 |  |  |  | 3.074002188770097
0.2450000000000001 |  |  |  | 3.074002188770097
0.2500000000000001 |  |  |  | 3.074002188770097
0.2550000000000001 |  |  |  | 3.074002188770097
0.2600000000000001 |  |  |  | 3.074002188770097
0.2650000000000001 |  |  |  | 3.074002188770097
0.2700000000000001 |  |  |  | 3.074002188770097
0.2750000000000001 |  |  |  | 3.074002188770097
0.2800000000000001 |  |  |  | 3.074002188770097
0.2850000000000001 |  |  |  | 3.074002188770097
0.2900000000000001 |  |  |  | 3.074002188770097
0.2950000000000002 |  |  |  | 3.074002188770097
0.3000000000000002 |  |  |  | 3.074002188770097
0.3050000000000002 |  |  |  | 3.074002188770097
0.3100000000000002 |  |  |  | 3.074002188770097
0.3150000000000002 |  |  |  | 3.074002188770097
0.3200000000000002 |  |  |  | 3.074002188770097
0.3250000000000002 |  |  |  | 3.074002188770097
0.3300000000000002 |  |  |  | 3.074002188770097
0.3350000000000002 |  |  |  | 3.074002188770097
0.3400000000000002 |  |  |  | 3.074002188770097
0.3450000000000002 |  |  |  | 3.074002188770097
0.3500000000000002 |  |  |  | 3.074002188770097
0.3550000000000002 |  |  |  | 3.074002188770097
0.3600000000000002 |  |  |  | 3.074002188770097
0.3650000000000002 |  |  |  | 3.074002188770097
0.3700000000000002 |  |  |  | 3.074002188770097
0.3750000000000002 |  |  |  | 3.074002188770097
0.3800000000000002 |  |  |  | 3.074002188770097
0.3850000000000002 |  |  |  | 3.074002188770097
0.3900000000000002 |  |  |  | 3.074002188770097
0.3950000000000002 |  |  |  | 3.074002188770097
0.4000000000000002 |  |  |  | 3.074002188770097
0.4050000000000002 |  |  |  | 3.074002188770097
0.4100000000000003 |  |  |  | 3.074002188770097
0.4150000000000003 |  |  |  | 3.074002188770097
0.4200000000000003 |  |  |  | 3.074002188770097
0.4250000000000003 |  |  |  | 3.074002188770097
0.4300000000000003 |  |  |  | 3.074002188770097
0.4350000000000003 |  |  |  | 3.074002188770097
0.4400000000000003 |  |  |  | 3.074002188770097
0.4450000000000003 |  |  |  | 3.074002188770097
0.4500000000000003 |  |  |  | 3.074002188770097
0.4550000000000003 |  |  |  | 3.074002188770097
0.4600000000000003 |  |  |  | 3.074002188770097
0.4650000000000003 |  |  |  | 3.074002188770097
0.4700000000000003 |  |  |  | 3.074002188770097
0.4750000000000003 |  |  |  | 3.074002188770097
0.4800000000000003 |  |  |  | 3.074002188770097
0.4850000000000003 |  |  |  | 3.074002188770097
0.4900000000000003 |  |  |  | 3.074002188770097
0.4950000000000003 |  |  |  | 3.074002188770097
0.5000000000000003 |  |  |  | 3.074002188770097
0.5050000000000003 |  |  |  | 3.074002188770097
0.5100000000000003 |  |  |  | 3.074002188770097
0.5150000000000003 |  |  |  | 3.074002188770097
0.5200000000000004 |  |  |  | 3.074002188770097
0.5250000000000004 |  |  |  | 3.074002188770097
0.5300000000000004 |  |  |  | 3.074002188770097
0.5350000000000004 |  |  |  | 3.074002188770097
0.5400000000000004 |  |  |  | 3.074002188770097
0.5450000000000004 |  |  |  | 3.074002188770097
0.5500000000000004 |  |  |  | 3.074002188770097
0.5550000000000004 |  |  |  | 3.074002188770097
0.5600000000000004 |  |  |  | 3.074002188770097
0.5650000000000004 |  |  |  | 3.074002188770097
0.5700000000000004 |  |  |  | 3.074002188770097
0.5750000000000004 |  |  |  | 3.074002188770097
0.5800000000000004 |  |  |  | 3.074002188770097
0.5850000000000004 |  |  |  | 3.074002188770097
0.5900000000000004 |  |  |  | 3.074002188770097
0.5950000000000004 |  |  |  | 3.074002188770097
0.6000000000000004 |  |  |  | 3.074002188770097
0.6050000000000004 |  |  |  | 3.074002188770097
0.6100000000000004 |  |  |  | 3.074002188770097
0.6150000000000004 |  |  |  | 3.074002188770097
0.6200000000000004 |  |  |  | 3.074002188770097
0.6250000000000004 |  |  |  | 3.074002188770097
0.6300000000000004 |  |  |  | 3.074002188770097
0.6350000000000005 |  |  |  | 3.074002188770097
0.6400000000000005 |  |  |  | 3.074002188770097
0.6450000000000005 |  |  |  | 3.074002188770097
0.6500000000000005 |  |  |  | 3.074002188770097
0.6550000000000005 |  |  |  | 3.074002188770097
0.6600000000000005 |  |  |  | 3.074002188770097
0.6650000000000005 |  |  |  | 3.074002188770097
0.6700000000000005 |  |  |  | 3.074002188770097
0.6750000000000005 |  |  |  | 3.074002188770097
0.6800000000000005 |  |  |  | 3.074002188770097
0.6850000000000005 |  |  |  | 3.074002188770097
0.6900000000000005 |  |  |  | 3.074002188770097
0.6950000000000005 |  |  |  | 3.074002188770097
0.7000000000000005 |  |  |  | 3.074002188770097
0.7050000000000005 |  |  |  | 3.074002188770097
0.7100000000000005 |  |  |  | 3.074002188770097
0.7150000000000005 |  |  |  | 3.074002188770097
0.7200000000000005 |  |  |  | 3.074002188770097
0.7250000000000005 |  |  |  | 3.074002188770097
0.7300000000000005 |  |  |  | 3.074002188770097
0.7350000000000005 |  |  |  | 3.074002188770097
0.7400000000000005 |  |  |  | 3.074002188770097
0.7450000000000006 |  |  |  | 3.074002188770097
0.7500000000000006 |  |  |  | 3.074002188770097
0.7550000000000006 |  |  |  | 3.074002188770097
0.7600000000000006 |  |  |  | 3.074002188770097
0.7650000000000006 |  |  |  | 3.074002188770097
0.7700000000000006 |  |  |  | 3.074002188770097
0.7750000000000006 |  |  |  | 3.074002188770097
0.7800000000000006 |  |  |  | 3.074002188770097
0.7850000000000006 |  |  |  | 3.074002188770097
0.7900000000000006 |  |  |  | 3.074002188770097
0.7950000000000006 |  |  |  | 3.074002188770097
0.8000000000000006 |  |  |  | 3.074002188770097
0.8050000000000006 |  |  |  | 3.074002188770097
0.8100000000000006 |  |  |  | 3.074002188770097
0.8150000000000006 |  |  |  | 3.074002188770097
0.8200000000000006 |  |  |  | 3.074002188770097
0.8250000000000006 |  |  |  | 3.074002188770097
0.8300000000000006 |  |  |  | 3.074002188770097
0.8350000000000006 |  |  |  | 3.074002188770097
0.8400000000000006 |  |  |  | 3.074002188770097
0.8450000000000006 |  |  |  | 3.074002188770097
0.8500000000000006 |  |  |  | 3.074002188770097
0.8550000000000006 |  |  |  | 3.074002188770097
0.8600000000000007 |  |  |  | 3.074002188770097
0.8650000000000007 |  |  |  | 3.074002188770097
0.8700000000000007 |  |  |  | 3.074002188770097
0.8750000000000007 |  |  |  | 3.074002188770097
0.8800000000000007 |  |  |  | 3.074002188770097
0.8850000000000007 |  |  |  | 3.074002188770097
0.8900000000000007 |  |  |  | 3.074002188770097
0.8950000000000007 |  |  |  | 3.074002188770097
0.9000000000000007 |  |  |  | 3.074002188770097
0.9050000000000007 |  |  |  | 3.074002188770097
0.9100000000000007 |  |  |  | 3.074002188770097
0.9150000000000007 |  |  |  | 3.074002188770097
0.9200000000000007 |  |  |  | 3.074002188770097
0.9250000000000007 |  |  |  | 3.074002188770097
0.9300000000000007 |  |  |  | 3.074002188770097
0.9350000000000007 |  |  |  | 3.074002188770097
0.9400000000000007 |  |  |  | 3.074002188770097
0.9450000000000007 |  |  |  | 3.074002188770097
0.9500000000000007 |  |  |  | 3.074002188770097
0.9550000000000007 |  |  |  | 3.074002188770097
0.9600000000000007 |  |  |  | 3.074002188770097
0.9650000000000007 |  |  |  | 3.074002188770097
0.9700000000000008 |  |  |  | 3.074002188770097
0.9750000000000008 |  |  |  | 3.074002188770097
0.9800000000000008 |  |  |  | 3.074002188770097
0.9850000000000008 |  |  |  | 3.074002188770097
0.9900000000000008 |  |  |  | 3.074002188770097
0.9950000000000008 |  |  |  | 3.074002188770097
1.000000000000001 |  |  |  | 3.074002188770097