interpolation

Hello experts, Tried all methods without success I have large data of around 10,000 drainage pipe segments and 10,000 junctions in ArcGIS layer The problem is: due to some reason certain junctions could not be accessed for survey, thus 1,000+ entries are missing for pipes (up stream and d/s...

Hello all, I have a VBA problem that I hope (and given the quality of some of the posts I have read, am quite sure) is solvable. I need to perform a linear interpolation using a 3 column range of cells, where the first column is an identifier for different data sets (see example below). The...

I have a set of data that I have plotted in a graph. I have about 10-15 data points, the graph has couple of bends in it which I am very keen to preserve. I need to be able to identify y-values corresponding to x-values between my known data points. Is there any smart way in Excel to handle...

I am trying to determine a bonus payout percentage using interpolation and would like some help with the formula I should use. I have a payout percentage scale of: Less than 1.5% improvement pays out at 0% 1.5% improvement pays out at 20% 2% improvement pays out at 100% 5% improvement pays out...

Hello, I wonder how can I get an access query to interpole kind of like in the VLOOKUP Excel formula. I have a table that have a field named GAP that shows the distance between tow measures. I have another table with 3 columns min, max and GAP_RANGE. I want the query to identify in which...