Spreadsheet: 194082d1353029794-calculating-variable-deep-within-formula-excel-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
q | y1 | X
0
0.005 |  | $H$3=EXP($B$4-$C$4/(x+$D$4))+(EXP($B$3-$C$3/(x+$D$3))-EXP($B$4-$C$4/(x+$D$4)))*A8
0.01
0.015
0.02
0.025
0.03
0.035
0.04
0.045
0.05
0.05499999999999999
0.05999999999999999
0.06499999999999999
0.06999999999999999
0.075
0.08
0.085
0.09000000000000001
0.09500000000000001
0.1
0.105
0.11
0.115
0.12
0.125
0.13
0.135
0.14
0.145
0.15
0.1550000000000001
0.1600000000000001
0.1650000000000001
0.1700000000000001
0.1750000000000001
0.1800000000000001
0.1850000000000001
0.1900000000000001
0.1950000000000001
0.2000000000000001
0.2050000000000001
0.2100000000000001
0.2150000000000001
0.2200000000000001
0.2250000000000001
0.2300000000000001
0.2350000000000001
0.2400000000000001
0.2450000000000001
0.2500000000000001
0.2550000000000001
0.2600000000000001
0.2650000000000001
0.2700000000000001
0.2750000000000001
0.2800000000000001
0.2850000000000001
0.2900000000000001
0.2950000000000002
0.3000000000000002
0.3050000000000002
0.3100000000000002
0.3150000000000002
0.3200000000000002
0.3250000000000002
0.3300000000000002
0.3350000000000002
0.3400000000000002
0.3450000000000002
0.3500000000000002
0.3550000000000002
0.3600000000000002
0.3650000000000002
0.3700000000000002
0.3750000000000002
0.3800000000000002
0.3850000000000002
0.3900000000000002
0.3950000000000002
0.4000000000000002
0.4050000000000002
0.4100000000000003
0.4150000000000003
0.4200000000000003
0.4250000000000003
0.4300000000000003
0.4350000000000003
0.4400000000000003
0.4450000000000003
0.4500000000000003
0.4550000000000003
0.4600000000000003
0.4650000000000003
0.4700000000000003
0.4750000000000003
0.4800000000000003
0.4850000000000003
0.4900000000000003
0.4950000000000003
0.5000000000000003
0.5050000000000003
0.5100000000000003
0.5150000000000003
0.5200000000000004
0.5250000000000004
0.5300000000000004
0.5350000000000004
0.5400000000000004
0.5450000000000004
0.5500000000000004
0.5550000000000004
0.5600000000000004
0.5650000000000004
0.5700000000000004
0.5750000000000004
0.5800000000000004
0.5850000000000004
0.5900000000000004
0.5950000000000004
0.6000000000000004
0.6050000000000004
0.6100000000000004
0.6150000000000004
0.6200000000000004
0.6250000000000004
0.6300000000000004
0.6350000000000005
0.6400000000000005
0.6450000000000005
0.6500000000000005
0.6550000000000005
0.6600000000000005
0.6650000000000005
0.6700000000000005
0.6750000000000005
0.6800000000000005
0.6850000000000005
0.6900000000000005
0.6950000000000005
0.7000000000000005
0.7050000000000005
0.7100000000000005
0.7150000000000005
0.7200000000000005
0.7250000000000005
0.7300000000000005
0.7350000000000005
0.7400000000000005
0.7450000000000006
0.7500000000000006
0.7550000000000006
0.7600000000000006
0.7650000000000006
0.7700000000000006
0.7750000000000006
0.7800000000000006
0.7850000000000006
0.7900000000000006
0.7950000000000006
0.8000000000000006
0.8050000000000006
0.8100000000000006
0.8150000000000006
0.8200000000000006
0.8250000000000006
0.8300000000000006
0.8350000000000006
0.8400000000000006
0.8450000000000006
0.8500000000000006
0.8550000000000006
0.8600000000000007
0.8650000000000007
0.8700000000000007
0.8750000000000007
0.8800000000000007
0.8850000000000007
0.8900000000000007
0.8950000000000007
0.9000000000000007
0.9050000000000007
0.9100000000000007
0.9150000000000007
0.9200000000000007
0.9250000000000007
0.9300000000000007
0.9350000000000007
0.9400000000000007
0.9450000000000007
0.9500000000000007
0.9550000000000007
0.9600000000000007
0.9650000000000007
0.9700000000000008
0.9750000000000008
0.9800000000000008
0.9850000000000008
0.9900000000000008
0.9950000000000008
1.000000000000001