Microsoft Office Tutorials and References
In Depth Information
USE TWO-WAY INTERPOLATION WITH A SINGLE FORMULA
velocity (a design parameter to be read from the table). In the table above, if
you need to ﬁ nd the velocity corresponding to a height of 47 meters, it is a fairly
simple matter to devise a formula that computes 130 + (180 – 130) * 7 / 10 =
165 meters/sec.
How would you do this for a two-way table in which there are two control
parameters? Is it possible to do so using a single formula? The table in Figure
63 illustrates values of wind pressure for the control parameters Height of
structure and Span, and you need to compute the wind pressure for a height of
25 meters and a span of 300 meters.
Figure 63. Interpolate values from column B and row 2.
Solution: The procedure you use to solve this problem is essentially an
extension of the method used for the single control parameter table. Follow
these steps:
Start with the worksheet shown in Figure 63. Add input cells for height and
span in J1 and J2 respectively.
For ease of formula readability, deﬁ ne the following names:
ColHd =Sheet1!\$B\$1:\$F\$1
RoHd
1.
2.
=Sheet1!\$A\$2:\$A\$9
Dat
=Sheet1!\$B\$2:\$F\$9
Ht
=Sheet1!\$J\$1
Sp
=Sheet1!\$J\$2

Search JabSto ::

Custom Search