Spreadsheet: 52293d1251992395-multiple-formulae-in-a-cell-an-algorithm-698153-named-formulas
Sheet: Sheet2

RH \ Ta | 0 | 5 | 10 | 15 | 20 | 25 | 30 | 35 | 40 | 45 | 50
0.05 | 0.1918332225926568 | 0.2728807580288489 | 0.3828179915084579 | 0.5300717902491511 | 0.724980728649533 | 0.9801004931970294 | 1.310535650160855 | 1.734297836326567 | 2.272690686279327 | 2.950722283086283 | 3.797546655064143 |  | Ta | [NAME]: =O$1
0.1 | 0.3808533123702009 | 0.5421755276062924 | 0.7611808636010765 | 1.054768379903494 | 1.443701841775052 | 1.953241643144995 | 2.613838668218763 | 3.461893975893432 | 4.540590088387407 | 5.900802439487911 | 7.60210339254867 |  | RH | [NAME]: =$[NAME]
0.15 | 0.5692214393363018 | 0.810713607299292 | 1.138727805383267 | 1.578689783605747 | 2.161877559788588 | 2.926398104347397 | 3.91827038901596 | 5.192626448512368 | 6.815047205958253 | 8.863056999661207 | 11.42781058053585 |  | Var1 | [NAME]: =0.611 * RH * EXP(17.27 * Sheet2!Ta / (Sheet2!Ta + 237.3))
0.2 | 0.7572655265595942 | 1.078910696425927 | 1.51597348309317 | 2.102457395330248 | 2.880237804389979 | 3.900400985055514 | 5.224742861638374 | 6.927450997567096 | 9.097003391632041 | 11.83833163111024 | 15.27531509491674 |  | Var2 | Var2 RefersTo: =(116.9 + 237.3 * LN(Var1)) / (16.78 - LN(Sheet2!Var1))
0.25 | 0.9451216659582801 | 1.34693638866053 | 1.893123439614871 | 2.626312740778578 | 3.599056392124939 | 4.875547420469933 | 6.533560618759369 | 8.66665521068595 | 11.38669589810013 | 14.82677230464074 | 19.14462911319245 |  | Var3 | Var3 RefersTo: =611.2 * EXP(17.67 * (Var2 / (243.5 + Sheet2!Var2) ) )
0.3 | 1.132862143238819 | 1.61487941957612 | 2.270283160876337 | 3.150376639990032 | 4.31846555591842 | 5.851973758999298 | 7.844852647894677 | 10.41034465750092 | 13.68418691308432 | 17.82837700870036 | 23.03567264283009 |  | Var4 | Var4 RefersTo: =0.622 * Var3/(101.325 * 1000 - Sheet2!Var3)
0.35 | 1.320530729798125 | 1.882792766110928 | 2.647514455940574 | 3.674718089746315 | 5.038538054153482 | 6.829750799501817 | 9.158679418584846 | 12.15855861006125 | 15.98948248850922 | 20.84310927028291 | 26.94836902481173 |  | x | x RefersTo: =1000 * Var4 / (1 + Sheet2!Var4)
0.4 | 1.508156223683154 | 2.15071080708816 | 3.024856693132658 | 4.199379883378885 | 5.759317222967887 | 7.80891792029332 | 10.47507014380123 | 13.91130867729472 | 18.30256970193204 | 23.87092959299497 | 30.88266463366748
0.45 | 1.695758696459849 | 2.418657180608662 | 3.402336433275755 | 4.724390095682131 | 6.480830240941926 | 8.789497828645976 | 11.79403840171812 | 15.66859425358463 | 20.6234303164815 | 26.91180498482809 | 34.83853102573606
0.5 | 1.883352745535593 | 2.686648846183058 | 3.779972365923394 | 5.249767900718443 | 7.203094745501687 | 9.771503759217389 | 13.11558951225166 | 17.43040941706709 | 22.95204621552715 | 29.96571152761685 | 38.8159627312326
0.55 | 2.070949340274332 | 2.954698375078859 | 4.157778068717584 | 5.775526787227685 | 7.926122432835665 | 10.75494330177221 | 14.43972431784283 | 19.19674623115503 | 25.28840158897038 | 33.03263455687258 | 42.81497422720003
0.6 | 2.258556940521061 | 3.222815329005672 | 4.535763654433161 | 6.301676456179901 | 8.649921148414565 | 11.73982057014807 | 15.76644123810096 | 20.96759638845567 | 27.63248373711332 | 36.11256803120434 | 46.83559708100122
0.65 | 2.446182209836917 | 3.491007133682405 | 4.91393680589346 | 6.828223999482596 | 9.374496164043421 | 12.72613749256891 | 17.09573743428926 | 22.74295203930507 | 29.98428326266722 | 39.20551367596227 | 50.87787750323396
0.7 | 2.63383048944073 | 3.75927965570924 | 5.292303453717133 | 7.355174662935299 | 10.09985099015788 | 13.7138946089519 | 18.42760948879087 | 24.52280620019177 | 32.34379399127007 | 42.31148012149396 | 54.94187432042068
0.75 | 2.821506124031671 | 4.027637596715518 | 5.670868235536143 | 7.882532357050746 | 10.82598790977636 | 14.70309157852566 | 19.76205380869039 | 26.30715293890642 | 34.71101277774284 | 45.43048211463553 | 59.0276573139957
0.8 | 3.009212692268322 | 4.296084770470543 | 6.049634816151884 | 8.410300008852323 | 11.55290833914409 | 15.69372751069121 | 21.0990668670389 | 28.09598743902503 | 37.08593927249555 | 48.56253982527371 | 63.13530586165999
0.85 | 3.196953173815946 | 4.564624302509459 | 6.42860611622028 | 8.938479810008452 | 12.2806130768969 | 16.68580118461762 | 22.43864534607534 | 29.88930599912026 | 39.46857568333895 | 51.70767824730476 | 67.26490782313606
0.9 | 3.384730072984512 | 4.833258776988323 | 6.807784479043877 | 9.467073395462796 | 13.00910247950548 | 17.67931119695224 | 23.78078622003907 | 31.68710599738719 | 41.85892654886926 | 54.86592668508982 | 71.41655862217169
0.95 | 3.572545511925217 | 5.101990346709555 | 7.187171794447818 | 9.996081974317704 | 13.7383765868007 | 18.67425606206435 | 25.12548680023992 | 33.48938583897917 | 44.25699853012405 | 58.03731831427626 | 75.5903604861538
1 | 3.760401302018451 | 5.370820816887815 | 7.566769592256128 | 10.525506427216 | 14.46843521299671 | 19.67063428036772 | 26.47274475635996 | 35.29614489588195 | 46.66280022250606 | 61.22188980607523 | 79.7864218127574