Mapping a table based on 2 lookup values

Configuration
1

I’m trying to develop a sensor template which looks up values based on 2 inputs from a table. The lookup on Temperature to be based on the outside temperature sensor. The lookup on Power needs to be based on some interpolation between the nearest values in the table.

Capture
Capture1428×978 307 KB

For example:

  • It’s 10 degrees outside.
  • The power used is 1.25kW
  • The value returned must be interpolated between the 5,47 and 3,52

I’ve tried mapper but I only get get it to map on a key:value pair. I would need to look up the value based on both temperature and power.

Thanks for any pointers.

1 Like
2

Did you ever find a solution for this? I’m trying to do the exact same thing with a COP chart for my heat pump to know when to use the heat pump vs gas furnace, but I have a much sparser table to work from than you do! (my COP table only has 8 total temperature points)