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
[TABLE="width: 833"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]2.00[/TD]
[TD]1.00[/TD]
[TD]5[/TD]
[TD]8[/TD]
[TD]8[/TD]
[TD]320[/TD]
[/TR]
[TR]
[TD]24.00[/TD]
[TD]1.00[/TD]
[TD]15[/TD]
[TD]14[/TD]
[TD]22[/TD]
[TD]4620[/TD]
[/TR]
[TR]
[TD]7.00[/TD]
[TD]4.00[/TD]
[TD]9[/TD]
[TD]12[/TD]
[TD]12[/TD]
[TD]1296[/TD]
[/TR]
[TR]
[TD]2.00[/TD]
[TD]1.00[/TD]
[TD]4[/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]224[/TD]
[/TR]
[TR]
[TD]2.00[/TD]
[TD]1.00[/TD]
[TD]3[/TD]
[TD]11[/TD]
[TD]8[/TD]
[TD]264[/TD]
[/TR]
[TR]
[TD]2.00[/TD]
[TD]1.00[/TD]
[TD]6[/TD]
[TD]8[/TD]
[TD]8[/TD]
[TD]384[/TD]
[/TR]
[TR]
[TD]3.00[/TD]
[TD]2.00[/TD]
[TD]4[/TD]
[TD]11[/TD]
[TD]13[/TD]
[TD]572[/TD]
[/TR]
[TR]
[TD]14.00[/TD]
[TD]4.00[/TD]
[TD]12[/TD]
[TD]12[/TD]
[TD]18[/TD]
[TD]2592[/TD]
[/TR]
[TR]
[TD]2.00[/TD]
[TD]1.00[/TD]
[TD]3[/TD]
[TD]7[/TD]
[TD]10[/TD]
[TD]210[/TD]
[/TR]
[TR]
[TD]7.00[/TD]
[TD]4.00[/TD]
[TD]9[/TD]
[TD]12[/TD]
[TD]12[/TD]
[TD]1296[/TD]
[/TR]
[TR]
[TD]2.00[/TD]
[TD]1.00[/TD]
[TD]3[/TD]
[TD]7[/TD]
[TD]10[/TD]
[TD]210[/TD]
[/TR]
[TR]
[TD]2.00[/TD]
[TD]1.00[/TD]
[TD]3[/TD]
[TD]10[/TD]
[TD]11[/TD]
[TD]330[/TD]
[/TR]
[TR]
[TD]2.00[/TD]
[TD]1.00[/TD]
[TD]3[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]300[/TD]
[/TR]
[TR]
[TD]2.00[/TD]
[TD]1.00[/TD]
[TD]6[/TD]
[TD]8[/TD]
[TD]8[/TD]
[TD]384[/TD]
[/TR]
[TR]
[TD]6.00[/TD]
[TD]3.00[/TD]
[TD]4[/TD]
[TD]13[/TD]
[TD]22[/TD]
[TD]1144[/TD]
[/TR]
[TR]
[TD]14.00[/TD]
[TD]7.00[/TD]
[TD]12[/TD]
[TD]12[/TD]
[TD]18[/TD]
[TD]2592[/TD]
[/TR]
[TR]
[TD]3.00[/TD]
[TD]2.00[/TD]
[TD]3[/TD]
[TD]10[/TD]
[TD]13[/TD]
[TD]390[/TD]
[/TR]
[TR]
[TD]9.00[/TD]
[TD]4.00[/TD]
[TD]10[/TD]
[TD]13[/TD]
[TD]13[/TD]
[TD]1690[/TD]
[/TR]
[TR]
[TD]2.00[/TD]
[TD]1.00[/TD]
[TD]6[/TD]
[TD]8[/TD]
[TD]8[/TD]
[TD]384[/TD]
[/TR]
[TR]
[TD]2.00[/TD]
[TD]1.00[/TD]
[TD]6[/TD]
[TD]8[/TD]
[TD]8[/TD]
[TD]384[/TD]
[/TR]
[TR]
[TD]3.00[/TD]
[TD]1.00[/TD]
[TD]6[/TD]
[TD]8[/TD]
[TD]9[/TD]
[TD]432[/TD]
[/TR]
[TR]
[TD]3.00[/TD]
[TD]2.00[/TD]
[TD]6[/TD]
[TD]8[/TD]
[TD]9[/TD]
[TD]432[/TD]
[/TR]
</tbody>[/TABLE]

 

[CNelson19]

The common divisor to get to Column 1 was 194. What I am trying to find is a common divisor to get to column 2.. any ideas?

 

[Fluff]

Take your pick.
Anywhere between 384 & 389.
You will never get an accurate result from volumetric weight to physical weight

 

[sheetspread]

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

Take your pick.
Anywhere between 384 & 389.
You will never get an accurate result from volumetric weight to physical weight

Thought so, just checking, thanks.