From

Location

Message

Date Posted

Nottingham, UK

Its a little early but does anyone have an up to date formula that I can use in excel for calculating the estimated weight from OTT measurements.

I found this one: =0.0000795*POWER(G2,2.76) from http://www.bigpumpkins.com/viewarticle.asp?id=37&gid=4 but it is from 2001 stats and I was hoping for something more up to date.

Thanks in advance and happy new year everyone!

Pete

1/5/2012 12:12:28 PM

Upa Creek, MO

Peter I don't have a formula, but a current OTT chart probably utilizes the current formula. You could have a sum formula for your 3 measurements, and in the next cell have a V-lookup with its range directly looking at a current OTT chart pasted into a different tab. Once you have the formula and V-lookup for one day, all you need to do is plug in daily measurments and it will pull the OTT in directly.

1/5/2012 12:34:51 PM

Upa Creek, MO

After rethinking, my above post is probably a bad idea since you could only use whole numbers. Now I see why you want the formula.

1/5/2012 12:41:30 PM

Ashby, MA

I've seen an iPhone app which does this calculation. That app must have the formula. Here's the message board entry for that app: http://www.bigpumpkins.com/MsgBoard/ViewThread.asp?b=3&p=401004

1/5/2012 4:09:14 PM

Pocatello ([email protected])

Well, that app is there but it won't necessarily divulge the formula in detail.

I've always wondered why we limit ourselves to a single formula that is hoped to be accurate for all measurements. That is, there is no reason not to have three formulas. One for OTT 50 to 250, another for 250 to 350, and another for 350 up to 450 or whatever. Complicated? No, that's what computers are for. You enter your numbers exactly as before, and the tool you're using gives you the result.

The benefit is that the numbers you get are more accurate. When we give credence to how heavy to the chart a fruit was, we ought to give equal credence to the formulas that give the number in the first place.

Maybe someday I'll do this.

1/5/2012 6:03:22 PM

milford, CT,

Dandy...go to GVGO website

Download Daily or weekly growth tracker

The formula works good..I have not been surprised since using it for the last 3 years... http://gvgo.ca/articles/

1/5/2012 6:38:48 PM

Nottingham, UK

Thanks for helping everyone!

Milford, I am going to have to ditch mine now and use the one on the GVGO site which is far better!

1/6/2012 6:02:33 AM

Glosta

try using an "interpolation" formula.

interpolation definition----In the mathematical field of numerical analysis, interpolation is a method of constructing new data points within the range of a discrete set of known data points.

Here is the formula I use on data tracker I have

IF(ISNA(INDEX('1400 Pacer'!$AA$6:$AB$359,MATCH(F11,'1400 Pacer'!$AA$6:$AA$359,1),2)+(F11-INDEX('1400 Pacer'!$AA$6:$AB$359,MATCH(F11,'1400 Pacer'!$AA$6:$AA$359,1),1))*(INDEX('1400 Pacer'!$AA$6:$AB$359,MATCH($F11,'1400 Pacer'!$AA$6:$AA$359,1)+1,2)-INDEX('1400 Pacer'!$AA$6:$AB$359,MATCH($F11,'1400 Pacer'!$AA$6:$AA$359,1),2))/(INDEX('1400 Pacer'!$AA$6:$AB$359,MATCH($F11,'1400 Pacer'!$AA$6:$AA$359,1)+1,1)-INDEX('1400 Pacer'!$AA$6:$AB$359,MATCH($F11,'1400 Pacer'!$AA$6:$AA$359,1),1))),0,INDEX('1400 Pacer'!$AA$6:$AB$359,MATCH(F11,'1400 Pacer'!$AA$6:$AA$359,1),2)+(F11-INDEX('1400 Pacer'!$AA$6:$AB$359,MATCH(F11,'1400 Pacer'!$AA$6:$AA$359,1),1))*(INDEX('1400 Pacer'!$AA$6:$AB$359,MATCH($F11,'1400 Pacer'!$AA$6:$AA$359,1)+1,2)-INDEX('1400 Pacer'!$AA$6:$AB$359,MATCH($F11,'1400 Pacer'!$AA$6:$AA$359,1),2))/(INDEX('1400 Pacer'!$AA$6:$AB$359,MATCH($F11,'1400 Pacer'!$AA$6:$AA$359,1)+1,1)-INDEX('1400 Pacer'!$AA$6:$AB$359,MATCH($F11,'1400 Pacer'!$AA$6:$AA$359,1),1)))

Obviously it only works on my excel sheet because it references specific cells and sheets.

1/6/2012 8:52:42 AM

Pocatello ([email protected])

I've found some cool resources...

Does anybody have a (fairly comprehensive) list of OTT vs. actual weight? Or, a way that I can construct one? I'd like to turn this into a full-blown project and eventually present it to the community.

1/6/2012 1:42:10 PM

Pocatello ([email protected])

I went ahead and derived my own equation based on the 2005 table on the GVGO site.

weight = .0005072 * (0.2512*OTT + 6.2798)^3.1655

For all intents, it's probably the same as the one given above.

1/6/2012 3:36:40 PM