edjr 6,580 Posted August 11, 2022 20 minutes ago, bostonlager said: ! 23 minutes ago, WhiteWonder said: ! All jokes aside. I truly appreciate all the work you 2 put in to keep the edex running smoothly this season. Share this post Link to post Share on other sites
bostonlager 2,665 Posted August 11, 2022 Just now, edjr said: All jokes aside. I truly appreciate all the work you 2 put in to keep the edex running smoothly this season. Its fun for me I will be starting a new thread soon for winter meetings and plan to implement the spreadsheet into next year for easier scoring and standings. 1 Share this post Link to post Share on other sites
dain11279 976 Posted August 11, 2022 2 hours ago, edjr said: We are still doing the 8th edex tourney next week. So you and anyone that was paid through season, still owes 50 for this. Thank you for asking WW paid through year BLM paid through year Ed paid through year KSB Paid through year horseman paid through year KSB owes for Playoffs Clocaine owes for playoffs and last tourney whoreseman owes for playoffs AD owes for last tourney Fumble owes for last tourney Dain - I am unsure. I'm paid up, I finished 2nd a couple tourneys ago and you kept it for the remaining 2 events. 1 Share this post Link to post Share on other sites
edjr 6,580 Posted August 11, 2022 4 hours ago, edjr said: We are still doing the 8th edex tourney next week. So you and anyone that was paid through season, still owes 50 for this. Thank you for asking WW paid through year BLM paid through year Ed paid through year KSB Paid through year horseman paid through year Dain paid through year Cloacaine paid through year AD owes for last tourney Fumble owes for last tourney updated Share this post Link to post Share on other sites
Cloaca du jour 2,149 Posted August 11, 2022 I just sent it like an hour ago Share this post Link to post Share on other sites
WhiteWonder 2,734 Posted August 11, 2022 1 hour ago, bostonlager said: Its fun for me I will be starting a new thread soon for winter meetings and plan to implement the spreadsheet into next year for easier scoring and standings. If baseball is trending to robot umpires There’s no reason we can’t Trend toward robot score keeping Share this post Link to post Share on other sites
bostonlager 2,665 Posted August 11, 2022 10 minutes ago, WhiteWonder said: If baseball is trending to robot umpires There’s no reason we can’t Trend toward robot score keeping I wish it auto updated. I still have to type in each score after the rounds, but it will make it easier for you to type up and put into the thread. Share this post Link to post Share on other sites
edjr 6,580 Posted August 11, 2022 23 hours ago, bostonlager said: Rickie Fowler? You got him 5 under 65. Leishman triples his last hole Share this post Link to post Share on other sites
bostonlager 2,665 Posted August 11, 2022 2 minutes ago, edjr said: 5 under 65. Leishman triples his last hole You owe me 10% if you cash and his score is counted. Share this post Link to post Share on other sites
KSB2424 3,148 Posted August 11, 2022 I love this stuff!&$@! 1 Share this post Link to post Share on other sites
bostonlager 2,665 Posted August 11, 2022 1 hour ago, KSB2424 said: I love this stuff!&$@! Fantasy golf is 100 times more fun than fantasy football. If there were enough nerds in the world like us I would considered starting a website. GolfBallGuys.com Share this post Link to post Share on other sites
Horseman 2,449 Posted August 11, 2022 Am I winning? Share this post Link to post Share on other sites
bostonlager 2,665 Posted August 11, 2022 Spreadsheet is updated but I’ve been drinking. Check your players to make sure I didn’t make a mistake. Share this post Link to post Share on other sites
KSB2424 3,148 Posted August 11, 2022 Go into the spreadsheet and press CTRL + to add a row under the scoring for each player, example Row 14 for @edjr. Then under the round 1 scoring cell put in the following formula: =SUM((SMALL(B4:B13,1)&", "&SMALL(B4:B13,2)&", "&SMALL(B2:B13,3)) That should sum up the lowest 3 scores automatically. Share this post Link to post Share on other sites
bostonlager 2,665 Posted August 11, 2022 2 minutes ago, KSB2424 said: Go into the spreadsheet and press CTRL + to add a row under the scoring for each player, example Row 14 for @edjr. Then under the round 1 scoring cell put in the following formula: =SUM((SMALL(B4:B13,1)&", "&SMALL(B4:B13,2)&", "&SMALL(B2:B13,3)) That should sum up the lowest 3 scores automatically. Shoot me your email in a PM and I will grant you access so you can to it. That shitt is above my pay grade. 1 Share this post Link to post Share on other sites
bostonlager 2,665 Posted August 11, 2022 Also - the way I was going to do it is, score after each round. So it will need to be done for all 4 columns. If JJ Spaun shoots -4 tomorrow I’m putting his cumulative score in the round 2 box which would be -12 1 Share this post Link to post Share on other sites
KSB2424 3,148 Posted August 11, 2022 1 minute ago, bostonlager said: Also - the way I was going to do it is, score after each round. So it will need to be done for all 4 columns. If JJ Spaun shoots -4 tomorrow I’m putting his cumulative score in the round 2 box which would be -12 Oh yeah, we'll get this thang running like a champ. After round two put a IFERROR ir IFTHEN function to rule out the cut line. Share this post Link to post Share on other sites
bostonlager 2,665 Posted August 11, 2022 1 minute ago, KSB2424 said: Oh yeah, we'll get this thang running like a champ. After round two put a IFERROR ir IFTHEN function to rule out the cut line. Youu should be good to edit now Share this post Link to post Share on other sites
bostonlager 2,665 Posted August 12, 2022 12 minutes ago, KSB2424 said: Oh yeah, we'll get this thang running like a champ. After round two put a IFERROR ir IFTHEN function to rule out the cut line. We may need that next year, but they don’t have a cut for the playoffs do they? Share this post Link to post Share on other sites
edjr 6,580 Posted August 12, 2022 11 hours ago, bostonlager said: We may need that next year, but they don’t have a cut for the playoffs do they? Share this post Link to post Share on other sites
edjr 6,580 Posted August 12, 2022 28 minutes ago, KSB2424 said: Go into the spreadsheet and press CTRL + to add a row under the scoring for each player, example Row 14 for @edjr. Then under the round 1 scoring cell put in the following formula: =SUM((SMALL(B4:B13,1)&", "&SMALL(B4:B13,2)&", "&SMALL(B2:B13,3)) That should sum up the lowest 3 scores automatically. What choo need foo? Share this post Link to post Share on other sites
bostonlager 2,665 Posted August 12, 2022 Automation just put WW out of a job, sorry buddy. You still get your EdEx pension. 1 Share this post Link to post Share on other sites
bostonlager 2,665 Posted August 12, 2022 7 minutes ago, edjr said: 125 to 70 and then no cut I thought all 125 would be playing 4 rounds this week. Am I wrong? It is confusing because St Jude used to be a WGC event that was no cut. Share this post Link to post Share on other sites
KSB2424 3,148 Posted August 12, 2022 Next two rounds should auto add lowest three scores. It's a google sheet (you must be on a ChromeBook) and not MS excel so similar but different, took me a minute. I'll figure out the rest tomorrow. Lager and Wonder doing well BTW. Let me know if it saved. 1 Share this post Link to post Share on other sites
bostonlager 2,665 Posted August 12, 2022 4 minutes ago, KSB2424 said: Next two rounds should auto add lowest three scores. It's a google sheet (you must be on a ChromeBook) and not MS excel so similar but different, took me a minute. I'll figure out the rest tomorrow. Lager and Wonder doing well BTW. Let me know if it saved. It looks good on my end. I am using google sheets because I don’t know a way to share excel. 1 Share this post Link to post Share on other sites
WhiteWonder 2,734 Posted August 12, 2022 32 minutes ago, bostonlager said: Automation just put WW out of a job, sorry buddy. You still get your EdEx pension. I was looking to retire early anyway 1 Share this post Link to post Share on other sites
bostonlager 2,665 Posted August 12, 2022 1 minute ago, WhiteWonder said: I was looking to retire early anyway If this is one thing I hate, it is tallying up scores and standings. Much appreciated if you would still post scores in the thread and handle the season standings. Share this post Link to post Share on other sites
WhiteWonder 2,734 Posted August 12, 2022 4 minutes ago, bostonlager said: If this is one thing I hate, it is tallying up scores and standings. Much appreciated if you would still post scores in the thread and handle the season standings. phew I was like, wait... I can't bitch about my players, I can't do the scoring.... might as well #edjr at the end of the season. I actually just got home from golf (83 43/40) and thought it was open edit so was getting ready to input the scores into the spreadsheet and was planning to add some formulas but looks like KSB already took care of that 1 Share this post Link to post Share on other sites
bostonlager 2,665 Posted August 12, 2022 Just now, WhiteWonder said: phew I was like, wait... I can't about my players, I can't do the scoring.... might as well #edjr at the end of the season. I actually just got home from golf (83 43/40) and was getting ready to input the scores into the spreadsheet and was planning to add some formulas but looks like KSB already took care of that PM me your email and I will grant you access. I can make spreadsheets look pretty with colors and fonts, but after that, I'm done. We can make this a team effor. Share this post Link to post Share on other sites
KSB2424 3,148 Posted August 12, 2022 4 minutes ago, WhiteWonder said: I actually just got home from golf (83 43/40) Sweet!@#! Is that good or bad for you. Share this post Link to post Share on other sites
bostonlager 2,665 Posted August 12, 2022 3 minutes ago, KSB2424 said: Sweet!@#! Is that good or bad for you. I have broke 80 this year one time. I'm not sure what WW shoots, but I'll take 83 and drink some beers afterwards. Share this post Link to post Share on other sites
KSB2424 3,148 Posted August 12, 2022 3 minutes ago, bostonlager said: I have broke 80 this year one time. I'm not sure what WW shoots, but I'll take 83 and drink some beers afterwards. Pretty sure WW is a good golfer, started playing early and in HS, etc.. I'd guess 83 is average but he's a single digit 8 handicap. Me? 12 Handicap. 83 with a six pack is a great day. Share this post Link to post Share on other sites
WhiteWonder 2,734 Posted August 12, 2022 15 minutes ago, KSB2424 said: Sweet!@#! Is that good or bad for you. Season best is 77, season worst is 92. My higher scores generally include lots of penalty shots . Today I only had 1 penalty. 1 birdie, 2 doubles. Only hit 4 fairways and 9 greens. 83 is average. they are not all created equal. It felt like a "good" 83. Share this post Link to post Share on other sites
WhiteWonder 2,734 Posted August 12, 2022 Playoff Challenge - Fedex St Jude - Round ONE 1. Lager -18 (-8, -6, -4) 2. Wonder -18 (-8, -5, -5) 3. Edjr -13 (-5, -4, -4) 4. Alias -12 (-7, -3, -2) 5. KSB -12 (-6, -3, -3) 6. Cloaca -10 (-4, -3, -3) *5th golfer -2 7. Horse -10 (-4, -3, -3) 1 1 Share this post Link to post Share on other sites
Horseman 2,449 Posted August 12, 2022 4 hours ago, WhiteWonder said: Playoff Challenge - Fedex St Jude - Round ONE 1. Lager -18 (-8, -6, -4) 2. Wonder -18 (-8, -5, -5) 3. Edjr -13 (-5, -4, -4) 4. Alias -12 (-7, -3, -2) 5. KSB -12 (-6, -3, -3) 6. Cloaca -10 (-4, -3, -3) *5th golfer -2 7. Horse -10 (-4, -3, -3) Nope. Lagers spreadsheet forked up, obviously. 2 Share this post Link to post Share on other sites
edjr 6,580 Posted August 12, 2022 11 hours ago, bostonlager said: I thought all 125 would be playing 4 rounds this week. Am I wrong? It is confusing because St Jude used to be a WGC event that was no cut. They are. I misunderstood Share this post Link to post Share on other sites
edjr 6,580 Posted August 12, 2022 10 hours ago, KSB2424 said: Pretty sure WW is a good golfer, started playing early and in HS, etc.. I'd guess 83 is average but he's a single digit 8 handicap. Me? 12 Handicap. 83 with a six pack is a great day. You do sit ups between holes? Share this post Link to post Share on other sites
edjr 6,580 Posted August 12, 2022 10 hours ago, KSB2424 said: Sweet!@#! Is that good or bad for you. all you losers were invited to Vegas for some golf geek meat Share this post Link to post Share on other sites
Alias Detective 1,399 Posted August 12, 2022 13 hours ago, bostonlager said: I thought all 125 would be playing 4 rounds this week. Am I wrong? It is confusing because St Jude used to be a WGC event that was no cut. 1 hour ago, edjr said: They are. I misunderstood I see a cut line at -1 on PGA Tour.com Share this post Link to post Share on other sites
edjr 6,580 Posted August 12, 2022 25 minutes ago, Alias Detective said: I see a cut line at -1 on PGA Tour.com it makes sense, as they are teeing off split tees Share this post Link to post Share on other sites