Home

Multiple Intersections and interpolation

%3CLINGO-SUB%20id%3D%22lingo-sub-769360%22%20slang%3D%22en-US%22%3EMultiple%20Intersections%20and%20interpolation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-769360%22%20slang%3D%22en-US%22%3EHi%2C%20I%20am%20trying%20to%20find%20an%20easy%20way%20to%20find%20the%20interpolated%20number%20within%20multiple%20intersections.%20Means%3A%20there%20are%20two%20row%20headlines%20on%20A%26amp%3BB%20and%202%20other%20topics%20on%201%26amp%3B2.%20I%20am%20trying%20to%20find%20the%20numbers%20on%20the%20intersection%20of%20A%20and%20B%20to%201%20and%202%2C%20and%20they%20have%20to%20be%20interpolated.%20See%20the%20file%20to%20have%20a%20better%20understanding%2C%20thanks%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-769360%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20mobile%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-769666%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20Intersections%20and%20interpolation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-769666%22%20slang%3D%22en-US%22%3ECan%20you%20please%20include%20(in%20the%20sample%20workbook%20you%20provided)%20some%20sample%20lookup%20values%20and%20the%20expected%20outcome.%20And%20which%20interpolation%20method%20do%20you%20wish%20to%20use%20(Linear%2C%20power%2C%20...)%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-769710%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20Intersections%20and%20interpolation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-769710%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F380686%22%20target%3D%22_blank%22%3E%40Bulent_Bildik%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20do%20not%20know%20much%20about%20interpolation%20but%20this%20article%20seems%20to%20be%20pretty%20insightful%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.datadigitization.com%2Fdagra-in-action%2Flinear-interpolation-with-excel%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.datadigitization.com%2Fdagra-in-action%2Flinear-interpolation-with-excel%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20helps!%3CBR%20%2F%3EPReagan%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-770342%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20Intersections%20and%20interpolation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-770342%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3BThe%20outcome%20is%20somewhere%20in%20between%20the%204%20given%20values'%20intersection.%20Simply%2C%20if%20the%20entry%20value%20perfectly%20matches%20with%20the%20chart%20values%2C%20let's%20say%20Weight%20360%2C%200%20OAT%20to%20Speed%20of%2080%20and%20Alt%200%2C%20the%20value%20is%2022.1%20(top%20left%20first%20value)%3C%2FP%3E%3CP%3EBut%20normally%20the%20entries%20are%20not%20on%20the%20chart%2C%20but%20in%20between%20the%20chart%20values%2C%20which%20has%20to%20be%20interpolated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-771166%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20Intersections%20and%20interpolation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-771166%22%20slang%3D%22en-US%22%3EHow%20do%20you%20propose%20we%20interpolate%20between%20two%20categories%2C%20first%20for%20a%20Weight%20of%20343%20which%20is%20somewhere%20around%20row%2013%20of%20the%20table%20and%20then%20for%20an%20OAT%20of%2017%2C%20which%20may%20be%20in%20various%20places%20in%20the%20same%20table.%20What%20if%20OAT%20equals%20330%20and%20Speed%20equals%2015%2C%20which%20row%20would%20you%20pick%3F%3C%2FLINGO-BODY%3E
Bulent_Bildik
New Contributor
Hi, I am trying to find an easy way to find the interpolated number within multiple intersections. Means: there are two row headlines on A&B and 2 other topics on 1&2. I am trying to find the numbers on the intersection of A and B to 1 and 2, and they have to be interpolated. See the file to have a better understanding, thanks
4 Replies
Can you please include (in the sample workbook you provided) some sample lookup values and the expected outcome. And which interpolation method do you wish to use (Linear, power, ...)?

Hello @Bulent_Bildik,

 

I do not know much about interpolation but this article seems to be pretty insightful:

https://www.datadigitization.com/dagra-in-action/linear-interpolation-with-excel/

 

Hope this helps!
PReagan 

@Jan Karel Pieterse The outcome is somewhere in between the 4 given values' intersection. Simply, if the entry value perfectly matches with the chart values, let's say Weight 360, 0 OAT to Speed of 80 and Alt 0, the value is 22.1 (top left first value)

But normally the entries are not on the chart, but in between the chart values, which has to be interpolated.

How do you propose we interpolate between two categories, first for a Weight of 343 which is somewhere around row 13 of the table and then for an OAT of 17, which may be in various places in the same table. What if OAT equals 330 and Speed equals 15, which row would you pick?
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Teams Calling - Dial pad missing
Chris Cooper in Microsoft Teams on
73 Replies