Moosenomics for the 2017 Dell Tech Championship FD Version

By August 28, 2017PGA, PGA Premium

FD version!

The content you are trying to access is only available to members. If you are a member, please log in. If you would like to become a subscriber (why wouldn't you?) check out our premium subscriptions.

For those of you who are new, here’s a brief tutorial of how Moosenomics works:

Updated each week, the Moosenomics’ spreadsheet provides every single tool you need to start research each week. The spreadsheet includes current Draft Kings salary alongside recent tournament history, prior course history, and rankings in over 25 different statistical categories.

Unlike any other sport, the field of play changes every week in golf. Different courses call for different types of players. Moosenomics gives you a significant edge by allowing you to give weight to the course history, recent form, and stats that you think are going to matter that week. That means you can output your own rankings based on the weights that you input into the Moosenomics spreadsheet. The only thing better than building winning golf lineups each week is building winning golf lineups with your own customized rankings.

There are a few new features in the Moosenomics spreadsheet for the 2016 season, and I thought I would take a minute to go over a few of them:

Cut Made %

First thing you might notice is the Cut Made % column. This is found on the “Moosenomics” sheet and is carried over to the “Lineup Manager” sheet so you can see how often they actually make cuts while you’re building your lineup. It shows the percentage of cuts each player has made in the past 12 months. If the number is negative, that means their percentage is based on fewer than 10 events.

This has actually been on the sheet for a couple of weeks now, but this is the first cut event we’ve had since we’ve implemented it.

Player History

When you are on the “Moosenomics” page and you are connected to the internet, you can double click on a player’s name and we will load up the past 5 seasons of tour results for the specified player. This feature is awesome. Try it out.

Lineup Manager “Double Click” Features

Instead of having to copy paste your players into the lineup manager roster spots, now you can just double click the players name from your player list and it will put that player into the next available lineup. You can similarily double click on that player’s name once he is in a lineup and it will remove him from that lineup.

Shit, while I’m talking about double clicking on the lineup manager I should probably mention another silly little trick… If you double click on the “Salary” label (the blue part) for any lineup, it will sort the players on that roster from most expensive to least expensive. Obviously this isn’t a game changer, but I caught myself wanting to sort the lineups often enough that I added this feature.

Lineup Manager Rank Column

This is kind of a cool new feature I’ve been playing with. I’ve added a rank column next to each of the lineup forms on the “Lineup Manager” sheet. Now, when you add a player to your roster it will grab his custom rank as determined by your weightings on the Moosenomics spreadsheet. It also totals up the rank for every player on that roster. This can be used to build “optimal” lineups by trying to build lineups with the lowest total sum of rank. Obviously, I don’t recommend relying 100% on this methodology. I like it, so I added it. Use it or ignore it, MooseFucker.

Shift Lineups Down

Once you start building more than 20 lineups, it was a pain to keep scrolling up and down to keep building lineups. That is why there is now a shift lineups down button on the “Lineups Manager” sheet. This button moves all of your lineups down a row without messing up the formulas and you can continue building lineups in the first row of lineup forms.

Model Value Rank

This is a calculated field that determines the value of a player by comparing his custom rank against his salary. If somebody has a custom rank of 14, but they are the 70th most expensive person, that would obviously be a big value and this column would high-light that. I currently have it buried in the fourth to last column on “Moosenomics” page. I tend to sort by this column once, and an ownership percentage to a couple of players based on it, and then I’m done with that column.

Own % Column

To make it easy to add players to your lineup manager sheet, I created a double click feature for the “Own %” column on the “Moosenomics” spreadsheet. If the cell is empty (black) it will give it 5% ownership. Full disclosure, I typically just give everyone 5% initially and figure out my actual percentages later. If there is a value in the column, double clicking will clear that value out and remove that player from your lineup manager the next time you click the “Update Lineup Manager” tab at the bottom.

Alright, go let loose like a moose and get to building those lineups!

Leave a Reply