How do I Iinterpolate from a data table? EXCEL
How do I Iinterpolate from a data table? EXCEL
(OP)
I have a data table which looks like this.
219 220 221
82 0.3548 0.3540 0.3532
82.1 0.3531 0.3523 0.3515
82.2 0.3514 0.3506 0.3498
Lets say the left column is T, the top row is P, and the rest is D.
If I have calulated a T and P in my spreadsheet, how can I use those values to find the D. The trick is, the P will not always be an exact value. For example, the P may equal 219.4. If this is the case, how can I use that value and this table to interpolate the D.
219 220 221
82 0.3548 0.3540 0.3532
82.1 0.3531 0.3523 0.3515
82.2 0.3514 0.3506 0.3498
Lets say the left column is T, the top row is P, and the rest is D.
If I have calulated a T and P in my spreadsheet, how can I use those values to find the D. The trick is, the P will not always be an exact value. For example, the P may equal 219.4. If this is the case, how can I use that value and this table to interpolate the D.





RE: How do I Iinterpolate from a data table? EXCEL
RE: How do I Iinterpolate from a data table? EXCEL
Dik
RE: How do I Iinterpolate from a data table? EXCEL
Anyways, to interpolate for 219.4 you should just be able to use lookup to get the values for 219 and 220 (I'll call them 3 and 4 for example) and then take a weighted average:
3 + (4-3)*((219.4-219)/(220-219))
Of course, the values would be references, with 3 and 4 being received from lookup function.
-- MechEng2005
RE: How do I Iinterpolate from a data table? EXCEL
http://fil
I hope that works... First time I've tried uploading
-- MechEng2005
RE: How do I Iinterpolate from a data table? EXCEL
AgentLA
RE: How do I Iinterpolate from a data table? EXCEL
Cheers
Greg Locock
SIG:Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.
RE: How do I Iinterpolate from a data table? EXCEL
RE: How do I Iinterpolate from a data table? EXCEL
This is the final product I came up with and it works. It's a really good time saver. Feel free to use it.
AgentLA
RE: How do I Iinterpolate from a data table? EXCEL
Hope people find it useful!
RE: How do I Iinterpolate from a data table? EXCEL
RE: How do I Iinterpolate from a data table? EXCEL
I have never used the offset() function before, I believe for referencing a two dimensional matrix this function will require less storage than index().
RE: How do I Iinterpolate from a data table? EXCEL
http://eng-tips.com/viewthread.cfm?qid=4962
Mala Singh
'Dare to Imagine'
RE: How do I Iinterpolate from a data table? EXCEL
I am new to this website so I dont know how everything works. I was reading all of your comments and I think you guys might be able to help me.
I have some data tha looks like this and I need to do some linear interpolation in excel so whenever I pick any value for T, I can get the "interpolated" Q, W, E and R. I tried the spreadsheet you guys posted but it is not working for me. Could anyone please help me?
Thank you very much for all of your help
T q w e r
1,782 1.33 1.170 290.01 1.02
1,772 1.33 1.170 290.01 1.02
1,766 1.34 1.170 290.01 1.02
1,761 1.34 1.170 290.01 1.02
1,754 1.34 1.170 290.01 1.02
1,748 1.35 1.170 290.01 1.02
1,735 1.35 1.170 290.01 1.02
1,717 1.36 1.170 290.01 1.02
1,710 1.37 1.170 290.01 1.02
1,700 1.50 1.168 284.27 1.02
1,694 1.50 1.168 283.38 1.02
1,689 1.51 1.168 282.52 1.02
1,659 1.53 1.166 277.28 1.02
1,644 1.55 1.164 274.64 1.02
1,621 1.57 1.163 270.72 1.02
1,612 1.58 1.162 269.20 1.02
1,597 1.60 1.161 266.69 1.02
1,589 1.61 1.161 265.30 1.02
1,561 1.64 1.159 260.51 1.02
1,542 1.66 1.157 257.16 1.02
1,533 1.67 1.157 255.74 1.02
1,517 1.69 1.155 252.94 1.02
1,493 1.71 1.154 248.85 1.02
1,482 1.73 1.153 246.95 1.02
1,453 1.76 1.151 241.98 1.02
1,421 1.81 1.149 236.44 1.02
1,395 1.84 1.147 231.97 1.02
1,386 1.85 1.146 230.48 1.02
1,362 1.89 1.144 226.29 1.02
1,348 1.91 1.143 223.94 1.02
RE: How do I Iinterpolate from a data table? EXCEL
RE: How do I Iinterpolate from a data table? EXCEL
RE: How do I Iinterpolate from a data table? EXCEL
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: How do I Iinterpolate from a data table? EXCEL
thread 770-234356 in the same forum
I submitted a rather general spreadsheet for 2 interpolation.