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

 | 10.1. Part 1 with Temperature Remaining Constant at 75°C
 | A | B | C | P1 | P2 |  | Temperature °C
acetonitrile: | 14.2724 | 2945.47 | 224 | 83.20685746510479 | 41.98270494612822 |  | 75
nitromethane: | 14.2043 | 2972.64 | 209
x1 | y1 | P
0 | 0 | 41.98270494612822
0.005 | 0.009861243595587998 | 42.1888257087231
0.01 | 0.01962659807139934 | 42.39494647131798
0.015 | 0.0292974552755573 | 42.60106723391286
0.02 | 0.03887518024865024 | 42.80718799650775
0.025 | 0.04836111186604324 | 43.01330875910263
0.03 | 0.05775656346180993 | 43.21942952169751
0.035 | 0.06706282343489528 | 43.4255502842924
0.04 | 0.07628115583809696 | 43.63167104688728
0.045 | 0.08541280095043058 | 43.83779180948216
0.05 | 0.0944589758334234 | 44.04391257207705
0.05499999999999999 | 0.1034208748718605 | 44.25003333467193
0.05999999999999999 | 0.1122996702994878 | 44.45615409726681
0.06499999999999999 | 0.121096512710158 | 44.66227485986169
0.06999999999999999 | 0.1298125315548878 | 44.86839562245657
0.075 | 0.1384488356252773 | 45.07451638505146
0.08 | 0.1470065135237256 | 45.28063714764635
0.085 | 0.1554866341208621 | 45.48675791024122
0.09000000000000001 | 0.1638902470005973 | 45.69287867283611
0.09500000000000001 | 0.1722183828931811 | 45.89899943543099
0.1 | 0.1804720540966458 | 46.10512019802587
0.105 | 0.1886522548869936 | 46.31124096062076
0.11 | 0.1967599619174795 | 46.51736172321564
0.115 | 0.2047961346073252 | 46.72348248581052
0.12 | 0.2127617155201892 | 46.92960324840541
0.125 | 0.2206576307327072 | 47.13572401100029
0.13 | 0.2284847901934047 | 47.34184477359517
0.135 | 0.2362440880722744 | 47.54796553619006
0.14 | 0.2439364031013 | 47.75408629878494
0.145 | 0.2515625989062001 | 47.96020706137982
0.15 | 0.2591235243296524 | 48.1663278239747
0.1550000000000001 | 0.266620013746256 | 48.37244858656959
0.1600000000000001 | 0.2740528873694744 | 48.57856934916447
0.1650000000000001 | 0.2814229515507969 | 48.78469011175935
0.1700000000000001 | 0.2887309990713492 | 48.99081087435424
0.1750000000000001 | 0.2959778094261721 | 49.19693163694912
0.1800000000000001 | 0.3031641491013845 | 49.403052399544
0.1850000000000001 | 0.3102907718444368 | 49.60917316213889
0.1900000000000001 | 0.3173584189276548 | 49.81529392473377
0.1950000000000001 | 0.324367819405268 | 50.02141468732865
0.2000000000000001 | 0.3313196903641089 | 50.22753544992354
0.2050000000000001 | 0.3382147371681646 | 50.43365621251841
0.2100000000000001 | 0.3450536536971571 | 50.6397769751133
0.2150000000000001 | 0.3518371225793187 | 50.84589773770819
0.2200000000000001 | 0.3585658154185303 | 51.05201850030306
0.2250000000000001 | 0.3652403930159782 | 51.25813926289795
0.2300000000000001 | 0.3718615055864848 | 51.46426002549283
0.2350000000000001 | 0.378429792969662 | 51.67038078808771
0.2400000000000001 | 0.3849458848360294 | 51.8765015506826
0.2450000000000001 | 0.3914104008882391 | 52.08262231327748
0.2500000000000001 | 0.3978239510575415 | 52.28874307587236
0.2550000000000001 | 0.4041871356956214 | 52.49486383846725
0.2600000000000001 | 0.4105005457619334 | 52.70098460106213
0.2650000000000001 | 0.4167647630066577 | 52.90710536365701
0.2700000000000001 | 0.4229803601493954 | 53.1132261262519
0.2750000000000001 | 0.4291479010537207 | 53.31934688884678
0.2800000000000001 | 0.435267940897698 | 53.52546765144166
0.2850000000000001 | 0.4413410263404752 | 53.73158841403654
0.2900000000000001 | 0.4473676956850579 | 53.93770917663143
0.2950000000000002 | 0.4533484790373638 | 54.14382993922631
0.3000000000000002 | 0.4592838984616596 | 54.34995070182119
0.3050000000000002 | 0.4651744681324737 | 54.55607146441608
0.3100000000000002 | 0.4710206944830777 | 54.76219222701096
0.3150000000000002 | 0.4768230763506277 | 54.96831298960584
0.3200000000000002 | 0.4825821051180523 | 55.17443375220073
0.3250000000000002 | 0.4882982648527725 | 55.38055451479561
0.3300000000000002 | 0.4939720324423336 | 55.58667527739049
0.3350000000000002 | 0.4996038777270326 | 55.79279603998538
0.3400000000000002 | 0.5051942636296156 | 55.99891680258026
0.3450000000000002 | 0.5107436462821217 | 56.20503756517514
0.3500000000000002 | 0.5162524751499448 | 56.41115832777002
0.3550000000000002 | 0.5217211931531879 | 56.61727909036491
0.3600000000000002 | 0.5271502367853741 | 56.82339985295979
0.3650000000000002 | 0.5325400362295835 | 57.02952061555467
0.3700000000000002 | 0.5378910154720822 | 57.23564137814956
0.3750000000000002 | 0.5432035924135027 | 57.44176214074444
0.3800000000000002 | 0.5484781789776411 | 57.64788290333932
0.3850000000000002 | 0.5537151812179268 | 57.85400366593421
0.3900000000000002 | 0.5589149994216263 | 58.06012442852909
0.3950000000000002 | 0.5640780282118331 | 58.26624519112397
0.4000000000000002 | 0.5692046566473021 | 58.47236595371886
0.4050000000000002 | 0.5742952683201791 | 58.67848671631374
0.4100000000000003 | 0.5793502414516779 | 58.88460747890862
0.4150000000000003 | 0.5843699489857549 | 59.09072824150351
0.4200000000000003 | 0.5893547586808302 | 59.29684900409839
0.4250000000000003 | 0.5943050331996019 | 59.50296976669327
0.4300000000000003 | 0.5992211301970009 | 59.70909052928815
0.4350000000000003 | 0.6041034024063283 | 59.91521129188304
0.4400000000000003 | 0.6089521977236246 | 60.12133205447792
0.4450000000000003 | 0.613767859290305 | 60.3274528170728
0.4500000000000003 | 0.6185507255741093 | 60.53357357966769
0.4550000000000003 | 0.6233011304484026 | 60.73969434226257
0.4600000000000003 | 0.6280194032698672 | 60.94581510485745
0.4650000000000003 | 0.6327058689546221 | 61.15193586745234
0.4700000000000003 | 0.6373608480528107 | 61.35805663004722
0.4750000000000003 | 0.641984656821687 | 61.5641773926421
0.4800000000000003 | 0.6465776072972412 | 61.77029815523699
0.4850000000000003 | 0.6511400073643946 | 61.97641891783186
0.4900000000000003 | 0.6556721608257987 | 62.18253968042675
0.4950000000000003 | 0.6601743674692704 | 62.38866044302164
0.5000000000000003 | 0.6646469231338958 | 62.59478120561651
0.5050000000000003 | 0.6690901197748303 | 62.8009019682114
0.5100000000000003 | 0.6735042455268293 | 63.00702273080628
0.5150000000000003 | 0.6778895847665332 | 63.21314349340116
0.5200000000000004 | 0.68224641817354 | 63.41926425599605
0.5250000000000004 | 0.68657502279029 | 63.62538501859093
0.5300000000000004 | 0.6908756720807898 | 63.83150578118581
0.5350000000000004 | 0.6951486359882029 | 64.0376265437807
0.5400000000000004 | 0.6993941809913315 | 64.24374730637558
0.5450000000000004 | 0.7036125701600142 | 64.44986806897046
0.5500000000000004 | 0.707804063209464 | 64.65598883156534
0.5550000000000004 | 0.7119689165535702 | 64.86210959416023
0.5600000000000004 | 0.716107383357189 | 65.06823035675511
0.5650000000000004 | 0.7202197135874399 | 65.27435111935
0.5700000000000004 | 0.7243061540640362 | 65.48047188194488
0.5750000000000004 | 0.7283669485086671 | 65.68659264453976
0.5800000000000004 | 0.732402337593452 | 65.89271340713465
0.5850000000000004 | 0.7364125589884896 | 66.09883416972953
0.5900000000000004 | 0.7403978474085191 | 66.3049549323244
0.5950000000000004 | 0.7443584346587142 | 66.5110756949193
0.6000000000000004 | 0.7482945496796289 | 66.71719645751418
0.6050000000000004 | 0.7522064185913108 | 66.92331722010906
0.6100000000000004 | 0.7560942647366033 | 67.12943798270395
0.6150000000000004 | 0.7599583087236531 | 67.33555874529883
0.6200000000000004 | 0.7637987684676363 | 67.54167950789372
0.6250000000000004 | 0.767615859231727 | 67.7478002704886
0.6300000000000004 | 0.7714097936673167 | 67.95392103308347
0.6350000000000005 | 0.7751807818535058 | 68.16004179567835
0.6400000000000005 | 0.7789290313358802 | 68.36616255827325
0.6450000000000005 | 0.7826547471645894 | 68.57228332086812
0.6500000000000005 | 0.7863581319317373 | 68.77840408346302
0.6550000000000005 | 0.7900393858081071 | 68.9845248460579
0.6600000000000005 | 0.7936987065792245 | 69.19064560865277
0.6650000000000005 | 0.7973362896807829 | 69.39676637124765
0.6700000000000005 | 0.8009523282334359 | 69.60288713384254
0.6750000000000005 | 0.8045470130769763 | 69.80900789643742
0.6800000000000005 | 0.8081205328039072 | 70.01512865903231
0.6850000000000005 | 0.8116730737924269 | 70.22124942162719
0.6900000000000005 | 0.8152048202388308 | 70.42737018422207
0.6950000000000005 | 0.8187159541893474 | 70.63349094681695
0.7000000000000005 | 0.8222066555714183 | 70.83961170941184
0.7050000000000005 | 0.8256771022244346 | 71.04573247200672
0.7100000000000005 | 0.8291274699299372 | 71.25185323460161
0.7150000000000005 | 0.8325579324412984 | 71.45797399719649
0.7200000000000005 | 0.8359686615128871 | 71.66409475979137
0.7250000000000005 | 0.8393598269287351 | 71.87021552238625
0.7300000000000005 | 0.8427315965307106 | 72.07633628498114
0.7350000000000005 | 0.8460841362462092 | 72.28245704757602
0.7400000000000005 | 0.8494176101153724 | 72.48857781017091
0.7450000000000006 | 0.8527321803178451 | 72.69469857276579
0.7500000000000006 | 0.8560280071990757 | 72.90081933536067
0.7550000000000006 | 0.8593052492961741 | 73.10694009795554
0.7600000000000006 | 0.8625640633633326 | 73.31306086055044
0.7650000000000006 | 0.8658046043968189 | 73.51918162314531
0.7700000000000006 | 0.86902702565955 | 73.7253023857402
0.7750000000000006 | 0.8722314787052553 | 73.93142314833509
0.7800000000000006 | 0.8754181134022366 | 74.13754391092996
0.7850000000000006 | 0.8785870779567321 | 74.34366467352484
0.7900000000000006 | 0.8817385189358932 | 74.54978543611973
0.7950000000000006 | 0.884872581290383 | 74.75590619871463
0.8000000000000006 | 0.8879894083765988 | 74.9620269613095
0.8050000000000006 | 0.8910891419785307 | 75.16814772390438
0.8100000000000006 | 0.8941719223292616 | 75.37426848649926
0.8150000000000006 | 0.8972378881321152 | 75.58038924909414
0.8200000000000006 | 0.9002871765814588 | 75.78651001168903
0.8250000000000006 | 0.9033199233831676 | 75.99263077428392
0.8300000000000006 | 0.9063362627747573 | 76.1987515368788
0.8350000000000006 | 0.9093363275451891 | 76.40487229947368
0.8400000000000006 | 0.9123202490543579 | 76.61099306206856
0.8450000000000006 | 0.915288157252264 | 76.81711382466344
0.8500000000000006 | 0.9182401806978778 | 77.02323458725833
0.8550000000000006 | 0.9211764465777049 | 77.22935534985322
0.8600000000000007 | 0.9240970807240496 | 77.4354761124481
0.8650000000000007 | 0.9270022076329926 | 77.64159687504298
0.8700000000000007 | 0.9298919504820791 | 77.84771763763786
0.8750000000000007 | 0.9327664311477302 | 78.05383840023273
0.8800000000000007 | 0.9356257702223758 | 78.25995916282763
0.8850000000000007 | 0.9384700870313201 | 78.46607992542252
0.8900000000000007 | 0.9412994996493411 | 78.6722006880174
0.8950000000000007 | 0.9441141249170278 | 78.87832145061228
0.9000000000000007 | 0.9469140784568666 | 79.08444221320715
0.9050000000000007 | 0.9496994746890709 | 79.29056297580205
0.9100000000000007 | 0.9524704268471702 | 79.49668373839692
0.9150000000000007 | 0.9552270469933531 | 79.70280450099182
0.9200000000000007 | 0.9579694460335746 | 79.9089252635867
0.9250000000000007 | 0.9606977337324304 | 80.11504602618157
0.9300000000000007 | 0.9634120187278008 | 80.32116678877645
0.9350000000000007 | 0.9661124085452716 | 80.52728755137134
0.9400000000000007 | 0.968799009612333 | 80.73340831396622
0.9450000000000007 | 0.9714719272723604 | 80.93952907656112
0.9500000000000007 | 0.9741312657983858 | 81.145649839156
0.9550000000000007 | 0.9767771284066548 | 81.35177060175087
0.9600000000000007 | 0.9794096172699822 | 81.55789136434575
0.9650000000000007 | 0.9820288335309036 | 81.76401212694064
0.9700000000000008 | 0.9846348773146298 | 81.97013288953552
0.9750000000000008 | 0.9872278477418036 | 82.17625365213041
0.9800000000000008 | 0.989807842941069 | 82.38237441472529
0.9850000000000008 | 0.9923749600614491 | 82.58849517732017
0.9900000000000008 | 0.9949292952845398 | 82.79461593991505
0.9950000000000008 | 0.997470943836523 | 83.00073670250994
1.000000000000001 | 1 | 83.20685746510482