# Interpolation with conditional pricing

I have 6 attributes: A, B, C, D, Speed, Price.

Speed and price are continuous; conditional pricing is as follows:
Speed =  100, Price = 2, 3, 4
Speed = 400, Price = 4, 6, 8
Speed = 4000, Price = 10, 15, 20

I'm interested in simulations where Speed = 2000 and prices are varied in the range of 10 to 20. However, when I set Speed = 2000, the simulator assumes that Prices 4, 6, 8 are applicable. I'm guessing it views the Speed levels as thresholds for which price sets apply.

When I set Price to a value such as 12, the simulator thinks I'm requesting an "extrapolation." One consequence of this is that it prevents using RFC. I'm able to use Share of Preference with a Price such as 12 but it must be interpolating Speed (since 100  < 2000 < 4000) while extrapolating Price (since 4 < 6 < 8 < 12).

However, in my real-world context, it is more reasonable to assume Prices are in the range of 10 to 20 rather than 4 to 8 when Speed = 2000. Is there a way to configure the simulator to associate the highest price set (10, 15, 20) when Speed = 2000 ?

I've tried hand-calculations on the Excel simulator utilities to replicate the dual interpolation/extrapolation that Share of Preference is performing. I doubt I'll figure out how to extend to RFC. Thus, I was hoping there is a way to change which (conditional) price range the simulator is associating with my interpolated Speed.
 Please only use this to answer the original question. Otherwise please use comments. Your name to display (optional): Email me at this address if my answer is selected or commented on: Privacy: Your email address will only be used for sending these notifications. Anti-spam verification: To avoid this verification in future, please log in or register.