Spreadsheet: 194924d1353359893-using-solver-to-solve-across-multiple-cells-solver-help
Sheet: Temp at 85C

 | 10.1. Part 1 with Temperature Remaining Constant at 85°C
 | A | B | C | P1 | P2 |  | Temperature °C
acetonitrile: | 14.2724 | 2945.47 | 224 | 114.4496087456915 | 59.93613578966044 |  | 85
nitromethane: | 14.2043 | 2972.64 | 209
x1 | y1 | P
0 | 0 | 59.93613578966044
0.005 | 0.009504407398720934 | 60.2087031544406
0.01 | 0.01892314889604044 | 60.48127051922075
0.015 | 0.02825737749215454 | 60.75383788400091
0.02 | 0.03750822558829239 | 61.02640524878106
0.025 | 0.04667680544468529 | 61.29897261356122
0.03 | 0.05576420962637157 | 61.57153997834138
0.035 | 0.06477151143721267 | 61.84410734312153
0.04 | 0.07369976534248233 | 62.11667470790169
0.045 | 0.0825500073803787 | 62.38924207268184
0.05 | 0.09132325556279619 | 62.661809437462
0.05499999999999999 | 0.1000205102656832 | 62.93437680224215
0.05999999999999999 | 0.1086427546092994 | 63.20694416702231
0.06499999999999999 | 0.1171909548286771 | 63.47951153180246
0.06999999999999999 | 0.1256660606345789 | 63.75207889658262
0.075 | 0.1340690055652353 | 64.02464626136278
0.08 | 0.1424007073291361 | 64.29721362614293
0.085 | 0.1506620681391397 | 64.56978099092308
0.09000000000000001 | 0.1588539750381551 | 64.84234835570324
0.09500000000000001 | 0.1669773002166451 | 65.1149157204834
0.1 | 0.1750329013221878 | 65.38748308526355
0.105 | 0.183021621761328 | 65.66005045004371
0.11 | 0.1909442909939417 | 65.93261781482386
0.115 | 0.1988017248203286 | 66.20518517960402
0.12 | 0.2065947256612421 | 66.47775254438417
0.125 | 0.2143240828310594 | 66.75031990916433
0.13 | 0.2219905728042842 | 67.02288727394449
0.135 | 0.2295949594755748 | 67.29545463872464
0.14 | 0.2371379944134772 | 67.5680220035048
0.145 | 0.2446204171080422 | 67.84058936828495
0.15 | 0.2520429552124973 | 68.11315673306511
0.1550000000000001 | 0.2594063247791383 | 68.38572409784527
0.1600000000000001 | 0.2667112304896034 | 68.65829146262541
0.1650000000000001 | 0.2739583658796824 | 68.93085882740557
0.1700000000000001 | 0.2811484135588151 | 69.20342619218573
0.1750000000000001 | 0.2882820454244212 | 69.47599355696589
0.1800000000000001 | 0.2953599228712054 | 69.74856092174605
0.1850000000000001 | 0.3023826969955751 | 70.02112828652619
0.1900000000000001 | 0.3093510087952999 | 70.29369565130635
0.1950000000000001 | 0.316265489364546 | 70.56626301608651
0.2000000000000001 | 0.3231267600844072 | 70.83883038086667
0.2050000000000001 | 0.3299354328090541 | 71.11139774564683
0.2100000000000001 | 0.3366921100476185 | 71.38396511042698
0.2150000000000001 | 0.3433973851419269 | 71.65653247520713
0.2200000000000001 | 0.3500518424401932 | 71.92909983998729
0.2250000000000001 | 0.3566560574667765 | 72.20166720476745
0.2300000000000001 | 0.3632105970881092 | 72.4742345695476
0.2350000000000001 | 0.3697160196748939 | 72.74680193432776
0.2400000000000001 | 0.3761728752606682 | 73.01936929910791
0.2450000000000001 | 0.3825817056968316 | 73.29193666388807
0.2500000000000001 | 0.3889430448042251 | 73.56450402866822
0.2550000000000001 | 0.3952574185213545 | 73.83707139344838
0.2600000000000001 | 0.4015253450493422 | 74.10963875822853
0.2650000000000001 | 0.407747334993692 | 74.38220612300869
0.2700000000000001 | 0.4139238915029489 | 74.65477348778884
0.2750000000000001 | 0.4200555104043315 | 74.927340852569
0.2800000000000001 | 0.4261426803364161 | 75.19990821734916
0.2850000000000001 | 0.432185882878944 | 75.47247558212932
0.2900000000000001 | 0.4381855926798282 | 75.74504294690946
0.2950000000000002 | 0.4441422775794251 | 76.01761031168962
0.3000000000000002 | 0.4500563987321452 | 76.29017767646978
0.3050000000000002 | 0.4559284107254635 | 76.56274504124994
0.3100000000000002 | 0.4617587616963988 | 76.83531240603008
0.3150000000000002 | 0.4675478934455213 | 77.10787977081026
0.3200000000000002 | 0.4732962415485515 | 77.3804471355904
0.3250000000000002 | 0.479004235465608 | 77.65301450037056
0.3300000000000002 | 0.4846722986481634 | 77.92558186515072
0.3350000000000002 | 0.4903008486437624 | 78.19814922993088
0.3400000000000002 | 0.4958902971985589 | 78.47071659471104
0.3450000000000002 | 0.5014410503577219 | 78.74328395949118
0.3500000000000002 | 0.5069535085637636 | 79.01585132427134
0.3550000000000002 | 0.5124280667528415 | 79.2884186890515
0.3600000000000002 | 0.5178651144490775 | 79.56098605383166
0.3650000000000002 | 0.5232650358569474 | 79.83355341861181
0.3700000000000002 | 0.5286282099517841 | 80.10612078339196
0.3750000000000002 | 0.5339550105684371 | 80.37868814817212
0.3800000000000002 | 0.5392458064881377 | 80.65125551295228
0.3850000000000002 | 0.5445009615236057 | 80.92382287773243
0.3900000000000002 | 0.5497208346024436 | 81.19639024251259
0.3950000000000002 | 0.5549057798488564 | 81.46895760729274
0.4000000000000002 | 0.5600561466637354 | 81.7415249720729
0.4050000000000002 | 0.5651722798031477 | 82.01409233685305
0.4100000000000003 | 0.5702545194552625 | 82.28665970163321
0.4150000000000003 | 0.575303201315756 | 82.55922706641337
0.4200000000000003 | 0.5803186566617262 | 82.83179443119352
0.4250000000000003 | 0.5853012124241541 | 83.10436179597367
0.4300000000000003 | 0.5902511912589423 | 83.37692916075383
0.4350000000000003 | 0.5951689116165668 | 83.64949652553399
0.4400000000000003 | 0.6000546878103692 | 83.92206389031415
0.4450000000000003 | 0.6049088300835237 | 84.1946312550943
0.4500000000000003 | 0.6097316446747074 | 84.46719861987445
0.4550000000000003 | 0.6145234338825032 | 84.73976598465461
0.4600000000000003 | 0.619284496128563 | 85.01233334943477
0.4650000000000003 | 0.6240151260195613 | 85.28490071421493
0.4700000000000003 | 0.628715614407963 | 85.55746807899507
0.4750000000000003 | 0.6333862484516335 | 85.83003544377523
0.4800000000000003 | 0.6380273116723181 | 86.10260280855539
0.4850000000000003 | 0.6426390840130125 | 86.37517017333555
0.4900000000000003 | 0.6472218418942511 | 86.6477375381157
0.4950000000000003 | 0.6517758582693364 | 86.92030490289585
0.5000000000000003 | 0.6563014026785317 | 87.19287226767601
0.5050000000000003 | 0.660798741302242 | 87.46543963245617
0.5100000000000003 | 0.6652681370132024 | 87.73800699723633
0.5150000000000003 | 0.669709849427697 | 88.01057436201648
0.5200000000000004 | 0.6741241349558292 | 88.28314172679663
0.5250000000000004 | 0.6785112468508634 | 88.55570909157679
0.5300000000000004 | 0.6828714352576587 | 88.82827645635695
0.5350000000000004 | 0.6872049472602132 | 89.1008438211371
0.5400000000000004 | 0.6915120269283384 | 89.37341118591726
0.5450000000000004 | 0.6957929153634821 | 89.64597855069741
0.5500000000000004 | 0.7000478507437181 | 89.91854591547757
0.5550000000000004 | 0.7042770683679197 | 90.19111328025772
0.5600000000000004 | 0.7084808006991353 | 90.46368064503788
0.5650000000000004 | 0.7126592774071818 | 90.73624800981804
0.5700000000000004 | 0.7168127254104724 | 91.00881537459819
0.5750000000000004 | 0.7209413689170947 | 91.28138273937836
0.5800000000000004 | 0.7250454294651568 | 91.5539501041585
0.5850000000000004 | 0.7291251259624129 | 91.82651746893866
0.5900000000000004 | 0.7331806747251854 | 92.09908483371882
0.5950000000000004 | 0.7372122895166002 | 92.37165219849896
0.6000000000000004 | 0.7412201815841429 | 92.64421956327914
0.6050000000000004 | 0.7452045596965593 | 92.91678692805928
0.6100000000000004 | 0.7491656301801025 | 93.18935429283944
0.6150000000000004 | 0.7531035969541506 | 93.4619216576196
0.6200000000000004 | 0.757018661566201 | 93.73448902239974
0.6250000000000004 | 0.7609110232262545 | 94.00705638717992
0.6300000000000004 | 0.7647808788406065 | 94.27962375196006
0.6350000000000005 | 0.7686284230450496 | 94.55219111674022
0.6400000000000005 | 0.7724538482375075 | 94.82475848152038
0.6450000000000005 | 0.7762573446101044 | 95.09732584630052
0.6500000000000005 | 0.7800391001806867 | 95.3698932110807
0.6550000000000005 | 0.7837993008238047 | 95.64246057586084
0.6600000000000005 | 0.7875381303011657 | 95.915027940641
0.6650000000000005 | 0.7912557702915712 | 96.18759530542115
0.6700000000000005 | 0.7949524004203441 | 96.4601626702013
0.6750000000000005 | 0.7986281982882595 | 96.73273003498147
0.6800000000000005 | 0.8022833394999885 | 97.00529739976162
0.6850000000000005 | 0.8059179976920627 | 97.27786476454177
0.6900000000000005 | 0.8095323445603698 | 97.55043212932193
0.6950000000000005 | 0.8131265498871912 | 97.82299949410209
0.7000000000000005 | 0.816700781567786 | 98.09556685888225
0.7050000000000005 | 0.8202552056365363 | 98.3681342236624
0.7100000000000005 | 0.823789986292656 | 98.64070158844255
0.7150000000000005 | 0.8273052859254769 | 98.91326895322271
0.7200000000000005 | 0.8308012651393167 | 99.18583631800287
0.7250000000000005 | 0.8342780827779379 | 99.45840368278303
0.7300000000000005 | 0.8377358959486068 | 99.73097104756317
0.7350000000000005 | 0.8411748600457567 | 100.0035384123433
0.7400000000000005 | 0.8445951287742688 | 100.2761057771235
0.7450000000000006 | 0.847996854172371 | 100.5486731419036
0.7500000000000006 | 0.8513801866341673 | 100.8212405066838
0.7550000000000006 | 0.8547452749318016 | 101.093807871464
0.7600000000000006 | 0.8580922662372645 | 101.3663752362441
0.7650000000000006 | 0.8614213061438498 | 101.6389426010243
0.7700000000000006 | 0.8647325386872649 | 101.9115099658044
0.7750000000000006 | 0.8680261063664054 | 102.1840773305846
0.7800000000000006 | 0.8713021501637971 | 102.4566446953647
0.7850000000000006 | 0.874560809565711 | 102.7292120601449
0.7900000000000006 | 0.8778022225819638 | 103.001779424925
0.7950000000000006 | 0.8810265257653979 | 103.2743467897052
0.8000000000000006 | 0.8842338542310602 | 103.5469141544854
0.8050000000000006 | 0.8874243416750746 | 103.8194815192655
0.8100000000000006 | 0.8905981203932197 | 104.0920488840457
0.8150000000000006 | 0.8937553212992159 | 104.3646162488258
0.8200000000000006 | 0.896896073942724 | 104.637183613606
0.8250000000000006 | 0.9000205065270674 | 104.9097509783861
0.8300000000000006 | 0.9031287459266748 | 105.1823183431663
0.8350000000000006 | 0.9062209177042546 | 105.4548857079465
0.8400000000000006 | 0.9092971461277032 | 105.7274530727266
0.8450000000000006 | 0.9123575541867524 | 106.0000204375068
0.8500000000000006 | 0.9154022636093597 | 106.2725878022869
0.8550000000000006 | 0.9184313948778497 | 106.5451551670671
0.8600000000000007 | 0.9214450672448041 | 106.8177225318472
0.8650000000000007 | 0.9244433987487138 | 107.0902898966274
0.8700000000000007 | 0.9274265062293885 | 107.3628572614075
0.8750000000000007 | 0.9303945053431348 | 107.6354246261877
0.8800000000000007 | 0.9333475105777038 | 107.9079919909678
0.8850000000000007 | 0.9362856352670107 | 108.180559355748
0.8900000000000007 | 0.9392089916056364 | 108.4531267205282
0.8950000000000007 | 0.9421176906631061 | 108.7256940853083
0.9000000000000007 | 0.9450118423979583 | 108.9982614500885
0.9050000000000007 | 0.9478915556716002 | 109.2708288148686
0.9100000000000007 | 0.9507569382619565 | 109.5433961796488
0.9150000000000007 | 0.9536080968769177 | 109.8159635444289
0.9200000000000007 | 0.956445137167584 | 110.0885309092091
0.9250000000000007 | 0.9592681637413176 | 110.3610982739893
0.9300000000000007 | 0.9620772801745987 | 110.6336656387694
0.9350000000000007 | 0.9648725890256934 | 110.9062330035496
0.9400000000000007 | 0.9676541918471359 | 111.1788003683297
0.9450000000000007 | 0.9704221891980248 | 111.4513677331099
0.9500000000000007 | 0.9731766806561437 | 111.72393509789
0.9550000000000007 | 0.9759177648299003 | 111.9965024626702
0.9600000000000007 | 0.9786455393700947 | 112.2690698274504
0.9650000000000007 | 0.9813601009815157 | 112.5416371922305
0.9700000000000008 | 0.9840615454343685 | 112.8142045570107
0.9750000000000008 | 0.9867499675755379 | 113.0867719217908
0.9800000000000008 | 0.9894254613396889 | 113.359339286571
0.9850000000000008 | 0.9920881197602067 | 113.6319066513511
0.9900000000000008 | 0.9947380349799809 | 113.9044740161313
0.9950000000000008 | 0.9973752982620344 | 114.1770413809114
1.000000000000001 | 1 | 114.4496087456916