This is the first time I have posted here so you will have to bear with me for a moment. I work with shipping containers and I am interested in determining how many slots I can fill on board a vessel with a specific cargo mix. The catch is that while 20' units can fit anywhere, 40' units can only fit in specific areas on board. I have extracted some historical data that shows how many 20' units will normally fit in addition to a specific number of 40' units. So, with 40' units as my point of reference, the results come up as this:
<tbody>
</tbody>
(ie. If I want to load 60 x 40' units then I can only load 226 x 20' as additional cargo around them)
After extracting the equation from the graph I get this:
y = -7.2857x2 + 9.1143x + 300.8
So my question is this - If I want to create an open cell where I can enter the number of 40's to be loaded (eg. 46), how can I input this equation into a formula to determine how may 20' slots will be available off the data provided above?
I have used FORECAST and TREND but these seem to only follow Linear equations. I am rather stumped so I would be grateful if anyone had any ideas to solve this one.
20' | 40' |
304 | 0 |
288 | 20 |
260 | 40 |
226 | 60 |
162 | 80 |
<tbody>
</tbody>
(ie. If I want to load 60 x 40' units then I can only load 226 x 20' as additional cargo around them)
After extracting the equation from the graph I get this:
y = -7.2857x2 + 9.1143x + 300.8
So my question is this - If I want to create an open cell where I can enter the number of 40's to be loaded (eg. 46), how can I input this equation into a formula to determine how may 20' slots will be available off the data provided above?
I have used FORECAST and TREND but these seem to only follow Linear equations. I am rather stumped so I would be grateful if anyone had any ideas to solve this one.