Problem with creating a reference table

[JimmyOS]

Hi All,

I am having an issue with an excel table that I am trying to create.

I have a table which can be seen in cells A1:F7 in the attached excel workbook.

Basically, the values in cells B3:F7 are determined based on the corresponding values in cells B1:F1 and A3:A7.

I want to populate the cells in the table below for the values in between the cells B1:F1 and A3:A7.

Is there any quick way of doing this instead of having to run this?

Any help is massively appreciated!

Jimmy

[JimmyOS]

Am I missing something here?

How do I attach my excel workbook again?

[JimmyOS]

Excel workbook attached.

[MarvinP]

Hi Jimmy,

It looks to me like you should average the slopes of your known points to get the unknown slopes. Then do interpolation for the intercepts, which is a simple average for some. See if the attached works for you..

[JimmyOS]

Hi Marvin,

That's great, thanks for your help. Appreciate it!

Jimmy