|
|
Post by YouStayClassySanDiego on Oct 31, 2022 16:18:15 GMT -5
Hey folks. Been sharing this a bit in some chat streams and overall reactions were pretty good, so figured I'd share it with the wider community. I made a spreadsheet that allows you to track your fittings and overall stats. Input the stat changes for each fitting (Optional - use cell shaders to highlight fitting rarity). Then select the archetype you're wanting to play and the sheet will tell you your overall stats for each category. Also included is a putting percentage calculator. Be aware, thanks to Colby, I'm pretty sure when I was doing the measurements for this, I was impacted by the bug where the passive skills were stacking. So I had putting weight unlocked, but apparently that meant that putting roll was also on. As such, I'm going to need to redo the putting part. As it stands, it's recommending percentages that are a little too low, especially at higher speed greens. Use with caution until I finish v 1.20.  Download link for Google Sheets: docs.google.com/spreadsheets/d/1gwp1iJkwpm-ecCgtU09wwT3Kxc4pMhmt/edit?usp=sharing&ouid=104113915162171634502&rtpof=true&sd=true |
|
|
|
Post by jack12k10 on Oct 31, 2022 18:18:27 GMT -5
Great idea!
|
|
|
|
Post by YouStayClassySanDiego on Oct 31, 2022 19:05:00 GMT -5
Upon further review, things get weirder. On the putting test course I created (Perfectly flat green a few hundred yards in diameter), the game displays different green speeds on the 'Tee' vs 'Green'. IE, a tee shot on VF greens shows 186 as the speed, but if you putt a couple of inches, the next putt displays a 192 speed. What's more, the actual max distances are different from the 'tee' versus the green. Off the tee, max on VF is 204, off the tee it's 212. Not sure what to make of this, but the spreadsheet should be pretty accurate. In my playing experience though, higher speeds do tend to come up a little short if hit the prescribed distance.
Of course this version of the game also has way more slope influence as well - uphill putts play slower than 2k21 and downhill putts play faster, so it's all an inexact science.
|
|
|
|
Post by paddyjk19 on Oct 31, 2022 19:37:46 GMT -5
Hey folks. Been sharing this a bit in some chat streams and overall reactions were pretty good, so figured I'd share it with the wider community. I made a spreadsheet that allows you to track your fittings and overall stats. Input the stat changes for each fitting (Optional - use cell shaders to highlight fitting rarity). Then select the archetype you're wanting to play and the sheet will tell you your overall stats for each category. Also included is a putting percentage calculator. Be aware, thanks to Colby, I'm pretty sure when I was doing the measurements for this, I was impacted by the bug where the passive skills were stacking. So I had putting weight unlocked, but apparently that meant that putting roll was also on. As such, I'm going to need to redo the putting part. As it stands, it's recommending percentages that are a little too low, especially at higher speed greens. Use with caution until I finish v 1.20. Download link for Google Sheets: docs.google.com/spreadsheets/d/1gwp1iJkwpm-ecCgtU09wwT3Kxc4pMhmt/edit?usp=sharing&ouid=104113915162171634502&rtpof=true&sd=trueGot some good stats there, I’m at best 83 in any category! I need to spend less time in the course designer! |
|
|
|
Post by blueblood1995 on Oct 31, 2022 19:52:36 GMT -5
Nice work Eric!
Confirming Transition = distance control right ??
And shaping impacts fade/draw and also your ability to hit low/high and with backspin/forward roll (adjusted using the left bumper and right analog stick for Xbox controller). Is this correct ??
Lie just narrows the % range right ?? Example a lower lie stat might result in 75% to 85% from rough but a higher lie stat might result in 82% to 85% or something like thate correct ??
Cheers
|
|
|
|
Post by Cecil Harvey on Oct 31, 2022 20:20:26 GMT -5
Nice work Eric! Confirming Transition = distance control right ?? And shaping impacts fade/draw and also your ability to hit low/high and with backspin/forward roll (adjusted using the left bumper and right analog stick for Xbox controller). Is this correct ?? Lie just narrows the % range right ?? Example a lower lie stat might result in 75% to 85% from rough but a higher lie stat might result in 82% to 85% or something like thate correct ?? Cheers
At the bottom of the image of the first post explains what the skills do.
|
|
|
|
Post by YouStayClassySanDiego on Nov 3, 2022 13:00:22 GMT -5
FYI for anyone who's downloaded this - there was a formula error impacting the Wedge stats. I've corrected the error and updated the sheet.
|
|
|
|
Post by YouStayClassySanDiego on Nov 18, 2022 13:55:53 GMT -5
New update. More accurate putting percentages and detailed clubfittings. Distance calculator will give you carry distance based on yardage, elevation wind (enter a headwind as a negative value) and lie range. Does not take into account boosts from skills.  Putting % will tell you the percentage putt needed for the listed distance. Input the green speed as shown in game.  Club Fittings will show overall stats based on fittings. This is fine if you're using the same fittings for each club in a set:  Club Fittings - Detailed is new. This allows you to see stats for each club - useful if you're running different fittings within a set. It also shows the club distances in your bag as well as the gaps between clubs. The active archetype must be selected on the regular Club Fittings sheet.  Club Fittings - Source is where you enter the fittings you have available. Enter the values and select the rarity. The Club Fittings - Detailed will draw on this info to calculate distances and stats.  |
|
|
|
Post by gordyberry on Nov 18, 2022 14:28:45 GMT -5
New update. More accurate putting percentages and detailed clubfittings. Distance calculator will give you carry distance based on yardage, elevation wind (enter a headwind as a negative value) and lie range. Does not take into account boosts from skills. Great work and smart idea with making that easier to see if running different fittings within a club type. Did I miss a link to the new version? |
|
|
|
Post by YouStayClassySanDiego on Nov 18, 2022 14:37:19 GMT -5
|
|
|
|
Post by xxdetersxx on Nov 26, 2022 16:13:10 GMT -5
Spread sheet looks awesome, great idea.
One question, I copied the sheet to my own google docs so I can use it. Where are the archetype selections pulled from? I assume I missed something but my just shows up as loading and it doesn't load.
|
|
|
|
Post by blueblood1995 on Jan 2, 2023 19:07:41 GMT -5
YouStayClassySanDiego , is the link just above the most current of your very very useful Fittings Tracker ?? I also have x2 questions below regarding Fittings. (Forgive me for my ignorance but I'm only just starting to explore the world of Fittings !!) 1. What does the green number in the top right mean exactly ??  2. Are the Fitting values randomly generated ?? For example I note I have a +9 and +12 (selected) for Lie Range. 
|
|
|
|
Post by blueblood1995 on Jan 2, 2023 19:16:21 GMT -5
Also x4 more questions I'm hopign you can assist...
1. Club distances aside and focussing on Fittings only are the x2 sheets I should be using...
* Club Fittings - Detailed, and
* Club Fittings
2. What's Club Fittings - Source used for ??
3. What's the second table under the Totals with Archetype table in Club Fittings sheet ?? It seems to be a duplicate but with manually added data and not sourced from your array.
4. And, I'm a metric man and so if I simply add a conversion factor into your Club Distances sheet assuming this will be Ok ??
Thanks again
|
|
|
|
Post by greenlightning on Jan 2, 2023 22:17:09 GMT -5
YouStayClassySanDiego , is the link just above the most current of your very very useful Fittings Tracker ?? I also have x2 questions below regarding Fittings. (Forgive me for my ignorance but I'm only just starting to explore the world of Fittings !!) 1. What does the green number in the top right mean exactly ?? 2. Are the Fitting values randomly generated ?? For example I note I have a +9 and +12 (selected) for Lie Range. Green plus 7 your base distance with no fitting is 251 so you increased that by 7. |
|
