CSG Fantasy Football Spreadsheets v12.00 (2024)

You will need Excel to use this tool - Use the GoogleDrafter for a lite version that runs with GoogleSheets

and you may need to go into file properties and check this box to get macros working: Picture

---

• Boris Chen Tiers are not updated yet

• No Beersheets - there are many alternatives and I don't really have time to try and implement one or any of them right now.

---

Mac Users

• Versions of Excel prior to 2015 will not be able to use the refresh data button as web queries are not supported. Everything else should work fine.

• Excel for Mac 2015 the files open read only - make sure you enable macros and allow online data sources when those pop ups occur.

• You should still be able to edit the sheet and then go to File > Save As to get rid of the read only status.

#Guide now found here

---

#Downloads

	Mediafire	Google Drive	Dropbox
Standard	v12 MF	v12 GD	v12 DB	Use this version unless you have Individual Defensive players
Auction Version	v12a MF	v12a GD	v12a DB	Auction draft version of the sheet
IDP Version	v12i MF	v11i GD	v12i DB	Use this version if your draft includes individual defensive players
Auction IDP Version	v12ai MF	v12ai GD	v12ai DB	Auction draft version of the sheet that includes IDP

---

Features:

• Supports up to 20 team leagues, 40 rounds, keepers, pick trading, IDP

• Beersheet support (by downloading pasting the BeerSheet Excel File relevant to your league) No beersheets this year

• Spreadsheet with Rankings, ADPs and more from various sites that updates as you draft

• Draftboard that updates as you input picks

• Team Summary Page

Auction Version

• ESPN/Yahoo/NFL auction values and AAV's (all from pre-draft league rankings)

Here are some instructions and screenshots:

• Main Page - looks mostly the same here, you just have to enter the price and owner of the player

• Here is where it will keep track of each teams rosters, budgets etc.

---

#GoogleSheet Version v9.0

• Lighter version of sheet that runs in google sheets

Make a copy here

• Version with a few additional columns as well as pick odds tab (may run slower)

Make a copy here

---

#GoogleSheet Auction Version v5.0

• Lighter version of Auction sheet that runs in google sheets

Make a copy here

---

CSG Keeper Helper Sheet

v3.0

• CSG Keeper Helper Sheet v3.0 Dropbox
• CSG Keeper Helper Sheet v3.0 Google Drive
• CSG Keeper Helper Sheet v3.0 MediaFire

Made this tool to help when you have to input many keepers.

---

Resources & Credit:

• VBD / Auction Projected values and inflated values & related calculations from u/elboberto's Auction spreadsheet
• Draftboard style credit to: u/daruuk
• Draft pick odd calculations credit to u/bizarbus
• Tiers credit to Boris Chen, u/Prayes
• Drafting Style, Pick Trading & various other ideas u/ManhattanBeachBum
• BeerSheets: u/BeerSheets
• Cleaned up a bunch of the formatting (buttons and columns - thanks to u/riderist for the macro)

---

#Donations

not expected or necessary, but providing a link below for those that want to.

http://www.paypal.me/cndnSG