Formula Search - Need some master magic!

[CNelson19]

Hello, Below is a list of data. I am trying to find a common Divisor for the last column ( Dim. weight w/o Divisor) that will make the rated weight equal to the shipment rated weight. We can throw out outliers like line 2 with 24 rated weight and 1 original weight. Any ideas? I am stuck!

Rated Weight Orig. Weight Height Weight Length Dim. Weight w/o Divisor

2.00	1.00	5	8	8	320
24.00	1.00	15	14	22	4620
7.00	4.00	9	12	12	1296
2.00	1.00	4	7	8	224
2.00	1.00	3	11	8	264
2.00	1.00	6	8	8	384
3.00	2.00	4	11	13	572
14.00	4.00	12	12	18	2592
2.00	1.00	3	7	10	210
7.00	4.00	9	12	12	1296
2.00	1.00	3	7	10	210
2.00	1.00	3	10	11	330
2.00	1.00	3	10	10	300
2.00	1.00	6	8	8	384
6.00	3.00	4	13	22	1144
14.00	7.00	12	12	18	2592
3.00	2.00	3	10	13	390
9.00	4.00	10	13	13	1690
2.00	1.00	6	8	8	384
2.00	1.00	6	8	8	384
3.00	1.00	6	8	9	432
3.00	2.00	6	8	9	432

<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[sheetspread]

It's just the product of the previous 3 columns, I'm not sure you can connect that to the rated weight.

 

[CNelson19]

It the product of the L*W*H divided by an unknown number. This number should result in the original weight.

 

[sheetspread]

If you divide there's still no exact pattern, even after deleting some outliers. A regression might help, like:

 

[sheetspread]

It the product of the L*W*H divided by an unknown number. This number should result in the original weight.

Maybe the second column is some kind of adjustment, but I'm not seeing exactly how yet, and there are outliers as you said. E.g. the last two rows differ only by:

Excel 2010
	A	B	C	D	E	F
22	3	1	6	8	9	432
23	3	2	6	8	9	432
Sheet1 (3)

 

[Fluff]

How about

Excel 2013/2016
	A	B	C	D	E	F	G
1	2	1	5	8	8	320	2
2	24	1	15	14	22	4620	24
3	7	4	9	12	12	1296	7
4	2	1	4	7	8	224	2
5	2	1	3	11	8	264	2
6	2	1	6	8	8	384	2
7	3	2	4	11	13	572	3
8	14	4	12	12	18	2592	14
Engine

Cell Formulas
Range	Formula
G1	=ROUNDUP(F1/194,0)

 

[sheetspread]

=ROUNDUP(<font color="Blue">F1/194,0</font>)</td></tr></tbody></table></td></tr></table><br />

Nice, but how do you go in the other direction?

 

[Fluff]

In what way?
Assuming weights are in Kg & dimensions in cm then
1Kg equates to ~194cc

 

[sheetspread]

If we wanted to find the last column from the first column or two?

 

[Fluff]

Not as simple
If the rated weight is 2Kg then it could be anywhere from 1.01Kg to 2Kg giving anywhere between 196 & 388 cubic whatevers