Solved
units for values in tables
Is there a way to assign units to values in tables?
eg: i would like to use a table for density of air at various pressures and temperatures
| t [O C] | -50 | 0 | 50 | 100 | 150 | 200 | 300 | 400 |
| ρ [kg/m3] | ||||||||
| 1 bar | 1.563 | 1.275 | 1.078 | 0.932 | 0.8226 | 0.7356 | 0.6072 | 0.517 |
| 50 | 83.79 | 65.2 | 53.96 | 46.25 | 40.57 | 36.18 | 29.8 | 25.37 |
| 100 bar | 175.6 | 131.4 | 107.1 | 91.13 | 79.66 | 70.92 | 58.37 | 49.71 |
| 200 bar | 340.3 | 253.7 | 205.4 | 174.3 | 152.2 | 135.6 | 111.8 | 95.41 |
| 300 bar | 449.3 | 350.8 | 288.6 | 246.7 | 216.4 | 193.4 | 160.3 | 137.4 |
Is there a way i could create such a table with respective units for each of the values so that if I use a lookup function to find
hlookup(300K,table, 150bar)=, mathcad interpolates b/w nearest values in the table and gives me an answer
similarly, is there a function for interpolation and extrapolation from table values such that if i try to look up ρ at 50O C & 10MPa) it should automatically interpolate b/w the nearest actual points present in the table and provide a value.
