Home
%3CLINGO-SUB%20id%3D%22lingo-sub-814138%22%20slang%3D%22en-US%22%3EFantasy%20Football%20Cheat%20Sheet%20%26amp%3B%20Draft%20Template%20for%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-814138%22%20slang%3D%22en-US%22%3E%3CP%3ENow%20that%20the%20NFL%20preseason%20is%20off%20and%20running%2C%20fantasy%20leagues%20are%20starting%20up!%20Get%20the%20edge%20with%20our%20player%20analysis%20sheets%20or%20run%20the%20entire%20draft%20from%20Excel%20with%20this%20fantasy%20football%20template!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20736px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F127737iE98DC7B6816D91C6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22blog_gif3.gif%22%20title%3D%22blog_gif3.gif%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fexcel_ff_2019_blog_template%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSTRONG%3EClick%20here%3C%2FSTRONG%3E%3C%2FA%3Eto%20get%20the%20template%2C%20you%20will%20have%20the%20option%20to%20use%20it%20for%20free%20on%20Excel%20for%20the%20Web%2C%20or%20download%20it%20to%20your%20desktop.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20Draft%20template%20is%20filled%20out%20with%20rich%20player%20data%20ready%20to%20sort%20and%20filter%20as%20you%20research%20the%20best%20picks.%20Follow%20your%20league%E2%80%99s%20scoring%20system%20to%20calculate%20the%20fantasy%20points%20per%20player%20or%20team%20defense%2C%20and%20keep%20track%20of%20available%20players%20as%20they%E2%80%99re%20picked.%20Build%20your%20best%20team!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELet%E2%80%99s%20step%20through%20some%20of%20the%20features%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3ESetup%3C%2FSTRONG%3E%3CBR%20%2F%3EThe%20Setup%20sheet%20allows%20you%20to%20configure%20your%20league%20settings%2C%20which%20will%20update%20the%20FPTS%20(fantasy%20point)%20totals%20throughout%20the%20template.%20If%20you%20want%20to%20follow%20(or%20run!)%20your%20league%E2%80%99s%20draft%20in%20this%20template%2C%20enter%20your%20league%E2%80%99s%20team%20names%20in%20draft%20order.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20style%3D%22font-family%3A%20inherit%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F127727i07571882B97BD826%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22setup.jpg%22%20title%3D%22setup.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EDraft%20Board%3C%2FSTRONG%3E%3CBR%20%2F%3EUse%20the%20Draft%20Board%20to%20track%20your%20league%E2%80%99s%20picks!%20Run%20the%20league%20draft%20from%20here%20or%20follow%20along%20with%20your%20league%20to%20track%20player%20availability.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20652px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F127729iB08FD2A706A8BBE6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22draft_board.jpg%22%20title%3D%22draft_board.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EUse%20the%20drop%20downs%20to%20pick%20the%20players%2C%20or%20start%20typing%20a%20player%20name%20for%20auto-complete%20to%20kick%20in.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20players%20are%20picked%2C%20their%20data%20is%20pulled%20in.%20Points%20are%20calculated%20using%20the%20previous%20year%E2%80%99s%20stats%20with%20the%20scoring%20system%20filled%20out%20on%20the%20setup%20sheet.%20The%20count%20of%20players%20for%20each%20team%20in%20your%20league%20is%20also%20updated%20at%20the%20top%3B%20use%20that%20to%20predict%20what%20position%20each%20team%20still%20needs%20and%20what%20they%20might%20pick%20next!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20players%20are%20chosen%2C%20the%20workbook%20is%20updated%20with%20player%20availability%20so%20you%20can%20see%20who%E2%80%99s%20the%20%E2%80%9Cbest%20of%20the%20rest%E2%80%9D.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EAll%20Players%20%26amp%3B%20Position%20Sheets%3C%2FSTRONG%3E%3CBR%20%2F%3EUse%20the%20All%20Players%20tab%20to%20sort%20and%20filter%20all%20the%20players%20by%20key%20stats%20from%20last%20season%20and%20availability.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20709px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F127730iD3D92B23DB992CD3%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22all_players.jpg%22%20title%3D%22all_players.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThere%20are%20two%20ways%20to%20quickly%20sort%20and%20filter%20this%20data%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3EThe%20header%20drop%20downs%20for%20each%20column%20will%20allow%20you%20to%20quickly%20sort%20and%20filter%20a%20column.%3C%2FLI%3E%0A%3CLI%3ESlicers%20on%20the%20left-hand%20side%20of%20the%20data%20allow%20you%20to%20quickly%20filter%20for%20positions%2C%20teams%2C%20bye%20weeks%2C%20and%20player%20availability.%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CEM%3ETip%20%231%3A%20if%20you%E2%80%99re%20looking%20for%20players%20that%20aren%E2%80%99t%20in%20a%20particular%20bye%20week%2C%20just%20CTRL%20%2B%20click%20that%20week%20to%20remove%20it%20from%20the%20current%20set!%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EEach%20Position%20sheet%20(QB%2C%20RB%2C%20WR%2C%20...)%20has%20more%20detailed%20stats%20for%20each%20player%20in%20that%20position.%20Already-picked%20players%20show%20up%20grayed-out%20in%20the%20list.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20the%20upper%20left%20corner%20of%20the%20All%20Players%20sheet%20you%E2%80%99ll%20see%20how%20many%20players%20have%20been%20picked%20overall%20in%20the%20draft%20so%20far.%20In%20the%20upper%20left%20corner%20of%20the%20Position%20sheets%20you%E2%80%99ll%20see%20what%20percentage%20of%20FPTS%20is%20left%20for%20that%20position.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CEM%3ETip%20%232%3A%20Sorting%20the%20%22All%22%20sheets%20list%20of%20players%20will%20change%20the%20order%20of%20the%20drop%20down%20on%20the%20draft%20board!%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3ESchedule%3C%2FSTRONG%3E%3CBR%20%2F%3EView%20the%20entire%20season%E2%80%99s%20schedule%20on%20the%20Schedule%20sheet.%20The%20schedule%20shows%20the%20bye%20weeks%20and%20locations%20for%20the%20different%20teams%20so%20you%20can%20factor%20this%20into%20your%20draft%20decision-making.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20964px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F127732iF3D599ED32791B2C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22schedule.jpg%22%20title%3D%22schedule.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20example%2C%20TB%20(Tampa%20Bay)%20has%20a%20string%20of%20away%20games%20from%20Week%204%20through%20Week%209%2C%20which%20might%20be%20a%20series%20of%20tough%20games%20for%20players%20during%20those%20weeks.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWe%20wish%20you%20the%20best%20of%20luck%20in%20your%20fantasy%20league%2C%20and%20hope%20this%20template%20helps%20you%20draft%20a%20successful%20team!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENotes%3A%3CBR%20%2F%3EThis%20template%20is%20available%20in%20English%20and%20is%20designed%20for%20Excel%202016%2B%20for%20Windows%2C%20Mac%2C%20and%20Excel%20for%20the%20web.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-814138%22%20slang%3D%22en-US%22%3E%3CP%3ENow%20that%20the%20NFL%20preseason%20is%20off%20and%20running%2C%20fantasy%20leagues%20are%20starting%20up!%20Get%20the%20edge%20with%20our%20player%20analysis%20sheets%20or%20run%20the%20entire%20draft%20from%20Excel%20with%20the%20fantasy%20football%20template!%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-814138%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBlog%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-821917%22%20slang%3D%22en-US%22%3ERe%3A%20Fantasy%20Football%20Cheat%20Sheet%20%26amp%3B%20Draft%20Template%20for%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-821917%22%20slang%3D%22en-US%22%3E%3CP%3EAnyway%20to%20make%20the%20draft%20sheet%20have%2016%20spots%20instead%20of%2015%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-824464%22%20slang%3D%22en-US%22%3ERe%3A%20Fantasy%20Football%20Cheat%20Sheet%20%26amp%3B%20Draft%20Template%20for%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-824464%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F50203%22%20target%3D%22_blank%22%3E%40Sam%20R%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20you%20kindly%20share%20your%20code%20for%20the%20Date%20picker%20with%20your%20Colleagues%20who%20have%20been%20struggling%20to%20bring%20this%20into%20Excel%20from%209th%20Aug%202018%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Fsuggestions%2F13275054-add-date-picker-to-enable-users-to-select-a-date%23%7Btoggle_previous_statuses%7D%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Fsuggestions%2F13275054-add-date-picker-to-enable-users-to-select-a-date%23%7Btoggle_previous_statuses%7D%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-831772%22%20slang%3D%22en-US%22%3ERe%3A%20Fantasy%20Football%20Cheat%20Sheet%20%26amp%3B%20Draft%20Template%20for%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-831772%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20everyone!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENew%20update%20with%20updated%20data%20for%20this%20week%2C%20please%20re-download%20or%20use%20the%20edit%20in%20browser%20button%20again%20to%20get%20the%20updates%20for%20your%20upcoming%20drafts!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F398084%22%20target%3D%22_blank%22%3E%40gametimenonsense%3C%2FA%3E%26nbsp%3Bthanks%20for%20the%20feedback.%20The%20template%20is%20updated%20with%2016%20now!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F398961%22%20target%3D%22_blank%22%3E%40sgbhide%3C%2FA%3E%26nbsp%3BThanks%20for%20the%20date%20picker%20love!%26nbsp%3B%3CIMG%20class%3D%22lia-deferred-image%20lia-image-emoji%22%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Fhtml%2Fimages%2Femoticons%2Fhearteyes_40x40.gif%22%20alt%3D%22%3Ahearteyes%3A%22%20title%3D%22%3Ahearteyes%3A%22%20%2F%3EThe%20code%20is%20pretty%20different%20from%20VBA%20add-in%20code%20on%20my%20site%2C%20but%20they%20have%20taken%20into%20account%20feedback%20I've%20gotten%20from%20it%20to%20build%20a%20better%20one!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ethanks!%3C%2FP%3E%0A%3CP%3E-Sam%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-831961%22%20slang%3D%22en-US%22%3ERe%3A%20Fantasy%20Football%20Cheat%20Sheet%20%26amp%3B%20Draft%20Template%20for%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-831961%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Sam%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20attempted%20to%20update%20my%20version%20of%20the%20template%20using%20both%20the%20re-download%20and%20edit%20browser%20options%20but%20it%20is%20still%20showing%20only%20showing%2015%20slots%20per%20team.%26nbsp%3B%20Do%20you%20know%20of%20any%20other%20method%20that%20I%20could%20use%20to%20add%20that%2016th%20slot%20to%20my%20template%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-840005%22%20slang%3D%22en-US%22%3ERe%3A%20Fantasy%20Football%20Cheat%20Sheet%20%26amp%3B%20Draft%20Template%20for%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-840005%22%20slang%3D%22en-US%22%3E%3CP%3EDo%20we%20just%20enter%20the%20league%20settings%20on%20the%20setup%20tab%20and%20all%20the%20players%20stats%20will%20automatically%20be%20updated%20according%20to%20your%20league's%20setting%3F%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%2C%20how%20is%20this%20cheat%20sheet%20built%3F%20Is%20it%20taking%20the%20last%203%20years%20statistics%20from%20all%20the%20players%20and%20then%20averaging%20it%20out%20%2C%20then%20to%20predict%20the%20outcome%20of%20the%20players%20ranking%20by%20their%20position%20or%20does%20it%20just%20take%20last%20years%20stats%20and%20then%20comes%20up%20to%20predict%20how%20they%20will%20do%20this%20year%3F%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20play%20yahoo%20fantasy%20football%20scoring%20and%20this%20cheat%20sheet%20is%20missing%20a%20few%20of%20the%20scoring%20settings%20is%20it%20still%20possible%20to%20update%20the%20excel%20to%20include%20the%20missing%20scoring%20settings%20from%20yahoo%3F%3F%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft

Now that the NFL preseason is off and running, fantasy leagues are starting up! Get the edge with our player analysis sheets or run the entire draft from Excel with this fantasy football template!

 

blog_gif3.gif

 

 

Click here to get the template, you will have the option to use it for free on Excel for the Web, or download it to your desktop.

 

This Draft template is filled out with rich player data ready to sort and filter as you research the best picks. Follow your league’s scoring system to calculate the fantasy points per player or team defense, and keep track of available players as they’re picked. Build your best team!

 

Let’s step through some of the features:

 

Setup
The Setup sheet allows you to configure your league settings, which will update the FPTS (fantasy point) totals throughout the template. If you want to follow (or run!) your league’s draft in this template, enter your league’s team names in draft order.

 

setup.jpg

 

 

Draft Board
Use the Draft Board to track your league’s picks! Run the league draft from here or follow along with your league to track player availability.

 

draft_board.jpg

 

Use the drop downs to pick the players, or start typing a player name for auto-complete to kick in.

 

As players are picked, their data is pulled in. Points are calculated using the previous year’s stats with the scoring system filled out on the setup sheet. The count of players for each team in your league is also updated at the top; use that to predict what position each team still needs and what they might pick next!

 

As players are chosen, the workbook is updated with player availability so you can see who’s the “best of the rest”.

 

 

All Players & Position Sheets
Use the All Players tab to sort and filter all the players by key stats from last season and availability.

 

all_players.jpg

 

There are two ways to quickly sort and filter this data:

 

  1. The header drop downs for each column will allow you to quickly sort and filter a column.
  2. Slicers on the left-hand side of the data allow you to quickly filter for positions, teams, bye weeks, and player availability.

 

Tip #1: if you’re looking for players that aren’t in a particular bye week, just CTRL + click that week to remove it from the current set!

 

Each Position sheet (QB, RB, WR, ...) has more detailed stats for each player in that position. Already-picked players show up grayed-out in the list.

 

In the upper left corner of the All Players sheet you’ll see how many players have been picked overall in the draft so far. In the upper left corner of the Position sheets you’ll see what percentage of FPTS is left for that position.

 

Tip #2: Sorting the "All" sheets list of players will change the order of the drop down on the draft board!

 

 

Schedule
View the entire season’s schedule on the Schedule sheet. The schedule shows the bye weeks and locations for the different teams so you can factor this into your draft decision-making.

 

schedule.jpg

 

For example, TB (Tampa Bay) has a string of away games from Week 4 through Week 9, which might be a series of tough games for players during those weeks.

 

We wish you the best of luck in your fantasy league, and hope this template helps you draft a successful team!

 

 

Notes:
This template is available in English and is designed for Excel 2016+ for Windows, Mac, and Excel for the web.

 

5 Comments
Occasional Visitor

Anyway to make the draft sheet have 16 spots instead of 15?

Frequent Visitor

@Sam R 

Could you kindly share your code for the Date picker with your Colleagues who have been struggling to bring this into Excel from 9th Aug 2018

 

https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/13275054...

 

 

Microsoft

Hey everyone!

 

New update with updated data for this week, please re-download or use the edit in browser button again to get the updates for your upcoming drafts!

 

@gametimenonsense thanks for the feedback. The template is updated with 16 now!

 

@sgbhide Thanks for the date picker love!  The code is pretty different from VBA add-in code on my site, but they have taken into account feedback I've gotten from it to build a better one!

 

thanks!

-Sam

Occasional Visitor

Hi Sam,

 

I attempted to update my version of the template using both the re-download and edit browser options but it is still showing only showing 15 slots per team.  Do you know of any other method that I could use to add that 16th slot to my template?

 

Thanks.

Occasional Visitor

Do we just enter the league settings on the setup tab and all the players stats will automatically be updated according to your league's setting???

 

Also, how is this cheat sheet built? Is it taking the last 3 years statistics from all the players and then averaging it out , then to predict the outcome of the players ranking by their position or does it just take last years stats and then comes up to predict how they will do this year???

 

I play yahoo fantasy football scoring and this cheat sheet is missing a few of the scoring settings is it still possible to update the excel to include the missing scoring settings from yahoo???