Login

***sve7en*** · 12-06-2023, 11:56 PM

Fantasy scoring and swaps are hard right?

Evaluating swaps means looking at the index, counting, doing a bunch of mental or excel math and bot commands, that's a lot of work.

This sheet, based on the fantasy index link, and your username, will pull...

your team

their fantasy points per game

their games / points remaining

every unpicked player in your group

their fantasy points per game

their games / points remaining

and tell you the (theoretical) most beneficial swaps to make (if all performances stay on the current pace)

[Image: image.png?ex=6583adea&is=657138ea&hm=0f1...height=427]

File -> Make a Copy, have fun, good luck

https://docs.google.com/spreadsheets/d/1...sp=sharing

Lemme know if anything weird breaks or you have ideas for improvements.

MCP_ · 12-06-2023, 11:59 PM

remember when we had to look at things in different tabs

**brickwall35** · 04-11-2024, 12:38 PM

@sve7en on my copy, I adjusted the formula in column O on the SORT tab to go to 3 places on the "right" function, as it was putting the person at F.103 at F.03. There also isn't anything to resolve ties in FPRem, but that's pretty minor considering how unlikely it is (although there is currently a tie for F.03, I just manually bumped up one by .1)

***sve7en*** · 04-11-2024, 01:00 PM

Yeah, James just pinged me about it too. I thought I fixed that but it was on the wrong file. Should be fixed this week.

Navigation

Extra Menu

About us