Prior to the blank and double gameweeks last season, Ben Crellin created a fantastic spreadsheet that fantasy managers used to plan activation of their wild card and remaining chips. His spreadsheets took into account the missed games due to commitment to the UCL, UEL and league cups in England. As the season progress, so did Ben’s spreadsheet, until he tested the Twitter community and placed a price tag on his planning sheets, Out of respect for Ben, his time and effort in developing and maintaining these sheets, I made the decision to pay for his spreadsheet to finish out the season.
On Tuesday, Ben posted an announcement on Twitter, as he had just finished up the 2018/19 FPL Transfer Planner spreadsheet. I wasted no time in contacting Ben in order to receive the new version of his spreadsheet.
After a quick exchange with Ben on Twitter, I sent him payment, quickly and easily, using Paypal, which got me a link in return, from Ben to my FPL Transfer Planner. Before you do anything else, I highly suggest you watch his eight minute video on what the planner provides.
The video gives an excellent overview on how to navigate the four pages that constitute the transfer planner; Fixture Ratings & Links, Original, Wildcard 1 and Wildcard 2.
Fixture Ratings & Links
This page provides you offensive and defensive ratings, as well as an average rating of the two combined. There are also quick links to his videos that will help the new user learn the navigate the spreadsheets. The other links go to the public schedule spreadsheet and Ben’s fixture difficulty ratings (FDR).
All teams are broken down into four rankings; offensive, home and away and defensive, home and away. The corresponding numbers, representing the FDR can be changed for each, based on your research, not just limiting the user to what Ben believes. Each team has a default figure associated with each home and away category. There is also an average that takes into consideration the four combinations. These will be used to derive the weekly EPL schedules on the worksheet.
This is the main worksheet for the FPL Transfer Planner, providing you all the necessary information you need to fill out your GW1 squad before putting together your advanced planning, as it relates to fixtures and form. Starting in the top left corner is the ‘Squad Building Info‘ providing your remaining budget and average player price for your original squad. To the right you can change the number of gameweeks you want to include in your view, from 1 to 38. The above example displays the next 8 gameweeks.
The ‘Free Hit: GW‘ allows you to denote a gameweek you want to activate the chip (GW3). Once activated, it turns the gameweek fixture column gray as an identifier. The final information on the top right displays the remaining budget in the bank (ITB) and the price change from week to week based on transfers. GW5 is in red, as I used my FT to bring in a new player who was 0.5 more expensive than the one I transferred out.
Colored coded on the left side of the planner are the 15 slots used to build you team, with 5 addition slots for transfers when you start your planning. The headings display position, player name, their team and current price. This number is dynamic through the season, so you need not worry about the current player value.
The next group of columns display player price (PP), GW IN, GW OUT and starting price (SP), team and then each player is has an identification number (ID) associated with them, used when deciding your captain and four substitutes.
The gameweek matrix display is based on the number of weeks you indicated in the ‘Show next‘ variable. The example above shows the first eight gameweeks for my planning purposes. This matrix also include the number of transfers you have made or are planning to make, being colored coded based the point hit you intend on taking.
Players are entered, based on their position by a pull down menu or typing the first few characters. Once you select a player, price and their gameweek schedule is generated. For planning purposes, it’s as simple as posting the week you want to transfer the player out, which will darken out fixtures beyond that week. Under ‘Pos’ you will selection the position of the player you want to introduce and then add your new player.
The spreadsheet will be dynamic, updating prices and games, as it relates to BGW and DGWS, in order to assist managers in their planning and strategy. It’s really an intuitive spreadsheet, for both new and experienced managers. For all the work Ben put in last season, updating his spreadsheets with late season game activity, I felt his time and effort were well worth rewarding. If you don’t think so, that’s fine. I understand spreadsheets aren’t for everyone, as is paying for content. However, I felt it was worth a shout to Ben Crellin his work this season.
You can find Ben at @BenCrillen on Twitter and watch the introduction video on his FPL Transfer Planner.