General Discussion
|
Subject: Excel spreadsheet
|
|
From
|
Location
|
Message
|
Date Posted
|
Scott_B |
Columbia, Kentucky
|
Does anyone have a spreadsheet that you can just input the ott and it will calculate and track the weight? I had one a few years back but I had to wipe the lap top and did not back it up.
|
10/13/2020 8:36:27 PM
|
lunker99 |
Iowa
|
What's your email address?
|
10/13/2020 9:07:52 PM
|
Scott_B |
Columbia, Kentucky
|
Scottbayuk85@yahoo.com
|
10/13/2020 9:21:30 PM
|
Scott_B |
Columbia, Kentucky
|
Or if anyone has the formula that I can input for ott into the estimated weight.
|
10/13/2020 9:23:17 PM
|
Smallmouth |
Upa Creek, Mo
|
If you don’t get one From Lunker, I can write a formula for you.
|
10/13/2020 9:53:19 PM
|
Wolf3080 |
Dillonvale, Ohio
|
The formula is on the bottom of the chart
|
10/14/2020 7:40:28 AM
|
Jake |
Westmoreland, KS
|
Scott just grow it on a scale then you know exactly how much it weighs! ;)
|
10/14/2020 9:08:04 AM
|
Scott_B |
Columbia, Kentucky
|
Thanks smallmouth, I'll let you know. I'll check Andy if that will work in my chart. Jake if I had that much money I would grow bigger pumpkins;) I just want to use it to monitor growth rates and save for historic use later.
|
10/14/2020 10:21:24 AM
|
Scott_B |
Columbia, Kentucky
|
=(((14.2/(1+7.3*2^(-A2/96)))^3+(A2/51)^2.91)-8)*0.993
This is all I could find. Not sure how to apply it. Smallmounth if you can email me I would be great full. Scottbayuk85@yahoo.com
|
10/14/2020 10:26:12 AM
|
Gerald UK |
Watlington, UK
|
The formula is correct, where A2 is the OTT in inches
|
10/14/2020 1:48:22 PM
|
Scott_B |
Columbia, Kentucky
|
Thank you all, I have a version now created almost identical to what I had before.
|
10/14/2020 11:48:13 PM
|
Gerald UK |
Watlington, UK
|
If you want to go one step further, you can use the data from your spreadsheet to make a growth chart, like this: http://www.bigpumpkins.com/Diary/DiaryViewOne.asp?eid=320344
|
10/16/2020 3:41:14 AM
|
Duncan |
seattle
|
I created this page 20 years ago. Different URL, but still 20 years ago https://www.backyardgardener.com/garden-forum-education/pumpkins/how-to-weigh-a-pumpkin/
|
10/16/2020 8:43:46 AM
|
Duncan |
seattle
|
I would like the excel file, please mcalpin1@yahoo.com
|
10/16/2020 9:04:24 AM
|
Total Posts: 14 |
Current Server Time: 11/27/2024 9:40:30 PM |