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

 | 10.1. Part 1 with Temperature Remaining Constant at 65°C
 | A | B | C | P1 | P2 |  | Temperature °C
acetonitrile: | 14.2724 | 2945.47 | 224 | 59.17281815956486 | 28.65273511537906 |  | 65
nitromethane: | 14.2043 | 2972.64 | 209
x1 | y1 | P
0 | 0 | 28.65273511537906
0.005 | 0.01027115585873065 | 28.80533553059999
0.01 | 0.02043405934396523 | 28.95793594582092
0.015 | 0.03049041286581456 | 29.11053636104185
0.02 | 0.04044188332370695 | 29.26313677626278
0.025 | 0.05029010302748445 | 29.41573719148371
0.03 | 0.06003667058997669 | 29.56833760670464
0.035 | 0.06968315179207762 | 29.72093802192557
0.04 | 0.07923108042130818 | 29.87353843714649
0.045 | 0.08868195908480822 | 30.02613885236742
0.05 | 0.09803725999766305 | 30.17873926758835
0.05499999999999999 | 0.1072984257474326 | 30.33133968280928
0.05999999999999999 | 0.1164668700357178 | 30.48394009803021
0.06499999999999999 | 0.1255439783975646 | 30.63654051325114
0.06999999999999999 | 0.1345311088994744 | 30.78914092847207
0.075 | 0.143429592816759 | 30.941741343693
0.08 | 0.1522407352909513 | 31.09434175891393
0.085 | 0.1609658159679515 | 31.24694217413485
0.09000000000000001 | 0.1696060896175654 | 31.39954258935579
0.09500000000000001 | 0.1781627867350647 | 31.55214300457671
0.1 | 0.1866371141253745 | 31.70474341979764
0.105 | 0.1950302554704712 | 31.85734383501857
0.11 | 0.2033433718805504 | 32.0099442502395
0.115 | 0.2115776024295043 | 32.16254466546043
0.12 | 0.2197340646752271 | 32.31514508068136
0.125 | 0.2278138551652478 | 32.46774549590229
0.13 | 0.2358180499281701 | 32.62034591112322
0.135 | 0.2437477049513834 | 32.77294632634415
0.14 | 0.2516038566454889 | 32.92554674156508
0.145 | 0.2593875222958703 | 33.078147156786
0.15 | 0.267099700501823 | 33.23074757200693
0.1550000000000001 | 0.2747413716036388 | 33.38334798722786
0.1600000000000001 | 0.2823134980980306 | 33.5359484024488
0.1650000000000001 | 0.2898170250422666 | 33.68854881766972
0.1700000000000001 | 0.2972528804473694 | 33.84114923289065
0.1750000000000001 | 0.3046219756607259 | 33.99374964811158
0.1800000000000001 | 0.3119252057384369 | 34.14635006333251
0.1850000000000001 | 0.319163449807727 | 34.29895047855344
0.1900000000000001 | 0.3263375714197234 | 34.45155089377437
0.1950000000000001 | 0.3334484188928999 | 34.6041513089953
0.2000000000000001 | 0.3404968256474736 | 34.75675172421622
0.2050000000000001 | 0.3474836105310313 | 34.90935213943715
0.2100000000000001 | 0.3544095781356523 | 35.06195255465808
0.2150000000000001 | 0.3612755191067859 | 35.21455296987902
0.2200000000000001 | 0.3680822104441328 | 35.36715338509994
0.2250000000000001 | 0.3748304157947691 | 35.51975380032087
0.2300000000000001 | 0.3815208857387496 | 35.6723542155418
0.2350000000000001 | 0.3881543580674087 | 35.82495463076273
0.2400000000000001 | 0.3947315580545808 | 35.97755504598366
0.2450000000000001 | 0.4012531987209461 | 36.13015546120459
0.2500000000000001 | 0.4077199810917067 | 36.28275587642552
0.2550000000000001 | 0.4141325944477872 | 36.43535629164644
0.2600000000000001 | 0.4204917165707479 | 36.58795670686737
0.2650000000000001 | 0.4267980139815967 | 36.7405571220883
0.2700000000000001 | 0.433052142173672 | 36.89315753730924
0.2750000000000001 | 0.439254745839772 | 37.04575795253016
0.2800000000000001 | 0.4454064590936906 | 37.19835836775109
0.2850000000000001 | 0.4515079056863264 | 37.35095878297202
0.2900000000000001 | 0.4575596992165121 | 37.50355919819295
0.2950000000000002 | 0.4635624433367197 | 37.65615961341388
0.3000000000000002 | 0.4695167319537839 | 37.80876002863481
0.3050000000000002 | 0.4754231494247835 | 37.96136044385574
0.3100000000000002 | 0.4812822707482178 | 38.11396085907667
0.3150000000000002 | 0.487094661750609 | 38.26656127429759
0.3200000000000002 | 0.4928608792686561 | 38.41916168951852
0.3250000000000002 | 0.4985814713270668 | 38.57176210473945
0.3300000000000002 | 0.5042569773121831 | 38.72436251996038
0.3350000000000002 | 0.5098879281415194 | 38.87696293518131
0.3400000000000002 | 0.5154748464293214 | 39.02956335040224
0.3450000000000002 | 0.5210182466482579 | 39.18216376562317
0.3500000000000002 | 0.5265186352873485 | 39.3347641808441
0.3550000000000002 | 0.5319765110062283 | 39.48736459606503
0.3600000000000002 | 0.5373923647858512 | 39.63996501128596
0.3650000000000002 | 0.5427666800757243 | 39.79256542650688
0.3700000000000002 | 0.5480999329377674 | 39.94516584172781
0.3750000000000002 | 0.553392592186889 | 40.09776625694874
0.3800000000000002 | 0.5586451195283629 | 40.25036667216968
0.3850000000000002 | 0.5638579696920922 | 40.4029670873906
0.3900000000000002 | 0.5690315905638422 | 40.55556750261153
0.3950000000000002 | 0.5741664233135222 | 40.70816791783246
0.4000000000000002 | 0.5792629025205911 | 40.86076833305339
0.4050000000000002 | 0.5843214562966652 | 41.01336874827432
0.4100000000000003 | 0.5893425064053979 | 41.16596916349525
0.4150000000000003 | 0.5943264683797033 | 41.31856957871618
0.4200000000000003 | 0.599273751636392 | 41.47116999393711
0.4250000000000003 | 0.6041847595882841 | 41.62377040915803
0.4300000000000003 | 0.6090598897538667 | 41.77637082437897
0.4350000000000003 | 0.6138995338645555 | 41.9289712395999
0.4400000000000003 | 0.6187040779696235 | 42.08157165482082
0.4450000000000003 | 0.6234739025388536 | 42.23417207004175
0.4500000000000003 | 0.6282093825629759 | 42.38677248526268
0.4550000000000003 | 0.6329108876519415 | 42.53937290048361
0.4600000000000003 | 0.6375787821310891 | 42.69197331570454
0.4650000000000003 | 0.6422134251352565 | 42.84457373092547
0.4700000000000003 | 0.6468151707008882 | 42.9971741461464
0.4750000000000003 | 0.6513843678561893 | 43.14977456136732
0.4800000000000003 | 0.6559213607093702 | 43.30237497658825
0.4850000000000003 | 0.6604264885350368 | 43.45497539180919
0.4900000000000003 | 0.664900085858762 | 43.60757580703012
0.4950000000000003 | 0.669342482539891 | 43.76017622225105
0.5000000000000003 | 0.6737540038526182 | 43.91277663747197
0.5050000000000003 | 0.6781349705653801 | 44.0653770526929
0.5100000000000003 | 0.6824856990186051 | 44.21797746791383
0.5150000000000003 | 0.6868065012008573 | 44.37057788313476
0.5200000000000004 | 0.6910976848234154 | 44.52317829835569
0.5250000000000004 | 0.6953595533933232 | 44.67577871357662
0.5300000000000004 | 0.6995924062849476 | 44.82837912879755
0.5350000000000004 | 0.7037965388100801 | 44.98097954401848
0.5400000000000004 | 0.7079722422866171 | 45.13357995923941
0.5450000000000004 | 0.7121198041058497 | 45.28618037446034
0.5500000000000004 | 0.7162395077984 | 45.43878078968126
0.5550000000000004 | 0.7203316330988304 | 45.59138120490219
0.5600000000000004 | 0.7243964560089633 | 45.74398162012312
0.5650000000000004 | 0.7284342488599336 | 45.89658203534405
0.5700000000000004 | 0.7324452803730107 | 46.04918245056498
0.5750000000000004 | 0.7364298157192132 | 46.20178286578591
0.5800000000000004 | 0.7403881165777467 | 46.35438328100684
0.5850000000000004 | 0.7443204411932915 | 46.50698369622776
0.5900000000000004 | 0.7482270444321657 | 46.65958411144869
0.5950000000000004 | 0.7521081778373893 | 46.81218452666963
0.6000000000000004 | 0.7559640896826759 | 46.96478494189056
0.6050000000000004 | 0.7597950250253752 | 47.11738535711149
0.6100000000000004 | 0.7636012257583878 | 47.26998577233242
0.6150000000000004 | 0.7673829306610818 | 47.42258618755334
0.6200000000000004 | 0.771140375449224 | 47.57518660277427
0.6250000000000004 | 0.7748737928239593 | 47.7277870179952
0.6300000000000004 | 0.7785834125198486 | 47.88038743321613
0.6350000000000005 | 0.7822694613519936 | 48.03298784843706
0.6400000000000005 | 0.7859321632622651 | 48.18558826365799
0.6450000000000005 | 0.7895717393646562 | 48.33818867887892
0.6500000000000005 | 0.793188407989779 | 48.49078909409985
0.6550000000000005 | 0.7967823847285227 | 48.64338950932078
0.6600000000000005 | 0.8003538824748956 | 48.7959899245417
0.6650000000000005 | 0.8039031114680611 | 48.94859033976263
0.6700000000000005 | 0.8074302793335946 | 49.10119075498356
0.6750000000000005 | 0.8109355911239691 | 49.25379117020449
0.6800000000000005 | 0.8144192493582946 | 49.40639158542542
0.6850000000000005 | 0.81788145406132 | 49.55899200064635
0.6900000000000005 | 0.8213224028017182 | 49.71159241586728
0.6950000000000005 | 0.8247422907296686 | 49.8641928310882
0.7000000000000005 | 0.8281413106137505 | 50.01679324630913
0.7050000000000005 | 0.8315196528771637 | 50.16939366153007
0.7100000000000005 | 0.8348775056332903 | 50.321994076751
0.7150000000000005 | 0.8382150547206112 | 50.47459449197193
0.7200000000000005 | 0.8415324837369906 | 50.62719490719286
0.7250000000000005 | 0.8448299740733441 | 50.77979532241378
0.7300000000000005 | 0.8481077049466984 | 50.93239573763471
0.7350000000000005 | 0.8513658534326622 | 51.08499615285564
0.7400000000000005 | 0.8546045944973137 | 51.23759656807657
0.7450000000000006 | 0.8578241010285222 | 51.3901969832975
0.7500000000000006 | 0.8610245438667119 | 51.54279739851843
0.7550000000000006 | 0.8642060918350813 | 51.69539781373936
0.7600000000000006 | 0.8673689117692893 | 51.84799822896029
0.7650000000000006 | 0.8705131685466179 | 52.00059864418122
0.7700000000000006 | 0.8736390251146234 | 52.15319905940214
0.7750000000000006 | 0.8767466425192858 | 52.30579947462307
0.7800000000000006 | 0.8798361799326678 | 52.458399889844
0.7850000000000006 | 0.8829077946800905 | 52.61100030506493
0.7900000000000006 | 0.8859616422668398 | 52.76360072028587
0.7950000000000006 | 0.8889978764044086 | 52.9162011355068
0.8000000000000006 | 0.8920166490362884 | 53.06880155072772
0.8050000000000006 | 0.8950181103633144 | 53.22140196594865
0.8100000000000006 | 0.8980024088685795 | 53.37400238116957
0.8150000000000006 | 0.900969691341918 | 53.52660279639051
0.8200000000000006 | 0.9039201029039755 | 53.67920321161144
0.8250000000000006 | 0.9068537870298669 | 53.83180362683237
0.8300000000000006 | 0.9097708855724332 | 53.9844040420533
0.8350000000000006 | 0.9126715387851078 | 54.13700445727422
0.8400000000000006 | 0.915555885344392 | 54.28960487249515
0.8450000000000006 | 0.9184240623719591 | 54.44220528771608
0.8500000000000006 | 0.9212762054563804 | 54.59480570293701
0.8550000000000006 | 0.9241124486744956 | 54.74740611815794
0.8600000000000007 | 0.9269329246124195 | 54.90000653337887
0.8650000000000007 | 0.9297377643862051 | 55.0526069485998
0.8700000000000007 | 0.9325270976621602 | 55.20520736382073
0.8750000000000007 | 0.9353010526768304 | 55.35780777904166
0.8800000000000007 | 0.9380597562566501 | 55.51040819426259
0.8850000000000007 | 0.9408033338372734 | 55.66300860948351
0.8900000000000007 | 0.9435319094825847 | 55.81560902470444
0.8950000000000007 | 0.9462456059034002 | 55.96820943992537
0.9000000000000007 | 0.9489445444758645 | 56.12080985514631
0.9050000000000007 | 0.9516288452595458 | 56.27341027036724
0.9100000000000007 | 0.9542986270152405 | 56.42601068558816
0.9150000000000007 | 0.956954007222486 | 56.57861110080909
0.9200000000000007 | 0.9595951020967953 | 56.73121151603002
0.9250000000000007 | 0.9622220266066098 | 56.88381193125095
0.9300000000000007 | 0.9648348944899832 | 57.03641234647188
0.9350000000000007 | 0.967433818270996 | 57.18901276169281
0.9400000000000007 | 0.97001890927591 | 57.34161317691374
0.9450000000000007 | 0.9725902776490639 | 57.49421359213467
0.9500000000000007 | 0.9751480323685168 | 57.64681400735559
0.9550000000000007 | 0.9776922812614447 | 57.79941442257653
0.9600000000000007 | 0.9802231310192925 | 57.95201483779745
0.9650000000000007 | 0.9827406872126884 | 58.10461525301838
0.9700000000000008 | 0.985245054306123 | 58.25721566823931
0.9750000000000008 | 0.9877363356723992 | 58.40981608346024
0.9800000000000008 | 0.9902146336068548 | 58.56241649868117
0.9850000000000008 | 0.9926800493413653 | 58.7150169139021
0.9900000000000008 | 0.9951326830581264 | 58.86761732912303
0.9950000000000008 | 0.9975726339032255 | 59.02021774434395
1.000000000000001 | 1 | 59.17281815956488