I have knocked together the follows spreadsheet that may be useful
https://1drv.ms/x/s!AkYcP_eLvYMVqEed0REe2HbRpvix
There are several pages. A brief descriptions for each is:
Team: In select C3 select the county and all the players from that county with their stats are displayed.
Top 25: Shows the top 25 scoring players by each position, also below is the top 25 based on points per appearance per rating. If you wish to exclude a team then select "no" next to the county name in column C. Cell B3 is the minimum number of appearance a player needs to have played to be included.
Players: This is just where I copy in data from the TFF and provides all the flags for the first two pages.
Optimise: If you have solver in your excel (can install if not), then this can be run to select the optimum team based on scores so far. (currently 535 pts per day).
Fixtures These are in column D:E, there is a grid of these starting in cell J6. In AY25 is a table that gives the average number of extra fixtures you can get by moving from one team to another. If you want to see how it is achieved, type county name in cell AY23 and the number of transfers in AZ23 - The table starting I25 has a green marker showing how this is achieved.
One day This is the fixtures of just the one day games, also I have rated each team based on odds of winning. So Notts (favourites) Durham is counted as 1.5 games. If just want matches then change B2 to "equal". The green line is set on county selected in C1 with number of transfers in D1.
The other pages are nothing worth looking at.
Hope this may be of some use in planning.
Cricket spreadsheet
A Forum for Fans of Fantasy Cricket Games
- Waikikamukau
- Treebeard
- Posts: 223
- Joined: 12 Apr 2018, 18:40
Re: Cricket spreadsheet
Post by Waikikamukau »
Not to bad Darkish Not to bad at all
Love the use of the Excel solver
Would also love to know who's got the "R Reanalysis" team in the FISO league...great name....is that you by any chance
Love the use of the Excel solver
Would also love to know who's got the "R Reanalysis" team in the FISO league...great name....is that you by any chance
- Darkish
- Treebeard
- Posts: 110
- Joined: 21 May 2018, 22:34
- FS Record: Hit the top 50k this year in FPL
- FPL:
Re: Cricket spreadsheet
Thanks and glad you like it. I will try and update it through the season.
I found this fantasy section too late to join the league so "R Reanalysis" isn't me. I'll join the WC and T20 leagues if they are run.
Good luck
I found this fantasy section too late to join the league so "R Reanalysis" isn't me. I'll join the WC and T20 leagues if they are run.
Good luck
View Latest: 1 Day View Your posts
Jump to
- About FISO Forums
- ↳ Read Me First before Signing Up / Registration Problems
- ↳ List of Hidden Forums Available to Join
- ↳ List of Moderators
- ↳ FISO Forum News
- ↳ FISO Classics
- ↳ Old FISO Website
- ↳ FISO's Twitter Account
- ↳ FISO's Facebook Page
- Useful FISO Links
- ↳ FISO EPL Footballers Search
- ↳ FISO EPL Injury News Table
- ↳ Search FISO
- ↳ FISO Mail
- ↳ Your FISO Profile
- ↳ Friends & Foes
- ↳ FISO's Twitter Account
- ↳ FISO's Facebook Page
- ↳ List of Hidden Forums Available to Join
- ↳ List of Moderators
- FISO Games Forums
- ↳ FISO 7 Fantasy Manager
- ↳ Link to FISO 7
- ↳ FISO GOALS (Premiership Predictions)
- ↳ FISO Goals Link
- ↳ FISO Defenders Against Strikers (FISODAS) Games
- ↳ FISO Forum Community Games & Competitions
- ↳ FISO Forum Quiz Comps
- ↳ FISO Sudoku
- ↳ Other FISO Predictions (e.g. FA Cup, CL & Ints)
- ↳ Combined FPL/TFF Side Competition
- Fantasy Football Forums
- ↳ General Fantasy Football (FF) Notices & Comments
- ↳ Fantasy Football Hub
- ↳ FISO 'Champion of Champions'
- ↳ FPL Footballer Popularity
- ↳ Link to Pay It Square
- ↳ Team News (incl. INJURIES)
- ↳ Injury News Table
- ↳ Reports on Expected EPL Team Line-Ups
- ↳ Fixture News
- ↳ BBC Fixtures Link
- ↳ Specialist Club Knowledge
- ↳ FPL Footballer Popularity
- ↳ Fantasy PremierLeague.com (FPL)
- ↳ FISO's FPL Mini-League 2023/24
- ↳ Elite Team Reveals
- ↳ FPL Links, Mini-Leagues & Side Games
- ↳ FISO Crack The Code
- ↳ FPL Footballer Popularity
- ↳ FPL Link
- ↳ FF Hub
- ↳ FISO's FPL Mini-League 2022/23
- ↳ FPL Team Diaries & RMTs
- ↳ FPL Draft
- ↳ FPL Draft Team Questions
- ↳ FPL Draft Mini-Leagues & Side Games
- ↳ UEFA.com & FIFA.com Fantasy Football
- ↳ Eliteserien Fantasy
- ↳ Link to Eliteserien Fantasy
- ↳ Telegraph Fantasy Football (TFF)
- ↳ TFF Links, Super Leagues and Side Games
- ↳ TFF Link
- ↳ Edinburgh Egg Cup Charity Challenges (EECCC)
- ↳ Egg Cup Archive
- ↳ FISO Chat Room Link
- ↳ TFF Teams (e.g. Rate My Team - RMT)
- ↳ International Telegraph Fantasy Football Games
- ↳ Telegraph Football League (Championship & Leagues 1 & 2)
- ↳ How to Win at Telegraph FF by FF Hub
- ↳ The Sun Dream Team FF Games
- ↳ Sun Links, Mini-Leagues & Side Games
- ↳ Sun Dream Team Link
- ↳ FISO Chat Room Link
- ↳ Sun Teams (e.g. Rate My Team - RMT)
- ↳ FanTeam
- ↳ Link to FanTeam Fantasy Premier League game
- ↳ Link to FanTeam
- ↳ Expected EPL Line-Ups from FanTeam
- ↳ Player Price Changes for FanTeam
- ↳ Sortable list of FanTeam players
- ↳ FanTeam NBA Player Stats
- ↳ Link to £100k FanTeam Fantasy World Cup 2022 Multi-Entry
- ↳ Link to £50k FanTeam Fantasy World Cup 2022 Single Entry
- ↳ Mirror Fantasy Football
- ↳ YTM link
- ↳ Original Fantasy League (OFL) Football games
- ↳ Link to OFL
- ↳ SkySports Fantasy Football
- ↳ SkySports FF link
- ↳ SkySports FF Mini-Leagues and Side Games
- ↳ How to Win at Sky Sports FF by FF Hub
- ↳ Daily Mail Fantasy Football
- ↳ FantasyBet Fantasy Football
- ↳ Link to FantasyBet
- ↳ DraftKings UK
- ↳ Link to DraftKings UK
- ↳ FanDuel UK
- ↳ Link to FanDuel UK
- ↳ Playnbrag
- ↳ PlayON
- ↳ Link to PlayON
- ↳ Zweeler Football
- ↳ Zweeler Super11
- ↳ Zweeler Topscore
- ↳ Football Index
- ↳ FootballCoin
- ↳ Fanaments
- ↳ Link to Fanaments
- ↳ Other Fantasy Football games
- ↳ Football Score Prediction Games
- ↳ Super6 - £250k jackpot
- ↳ Simulated Football Management games
- ↳ Xpert Eleven
- ↳ Archived Fantasy Football Forums
- ↳ British Fantasy Football (Herald) games (Game ceased)
- ↳ Daily Record FF (Game ceased)
- ↳ Fanball Sky Sports (Game ceased)
- ↳ Guardian Fantasy Football Chairman (Game ceased)
- ↳ SquadGod (Game Ceased)
- ↳ La Republica del FISO Club History
- ↳ TFF KCs & MOTM History to May 2007
- ↳ TheLip's Archived Match Stats
- ↳ Guardian Fantasy Football (Ceased)
- ↳ Lucky 7's Fantasy Football (Ceased)
- ↳ Channel 4 FF Monthly (Ceased)
- ↳ Stan James Fantasy League
- ↳ San James Link
- ↳ Sun SPL Dream Team
- ↳ Telegraph Fantasy Football Online Squad Manager (TFFOSM)
- ↳ AOL Fantasy Football
- ↳ Link to AOL Fantasy Football
- ↳ Cancer Research UK Fantasy Football League
- ↳ Link to Cancer Research UK Fantasy League
- ↳ Sporting StarFantasy Football
- ↳ Link to Sporting Star Fantasy Football
- ↳ The Times Newspaper FF Games
- ↳ Times' Play The Game (PTG)
- ↳ Can You Kick It (CYKI)
- ↳ Fantasy Stakes
- ↳ Virgin Media Fantasy Football
- ↳ Sporting KO
- ↳ Football KO Link
- ↳ thespecialone's (TSO's) FISO Competitions
- ↳ Rock & Roll Fantasy Football
- ↳ Link to Rock N Roll Fantasy Football
- ↳ ITV Fantasy Football
- ↳ Euro-Eleven European Fantasy Football
- ↳ Bundesliga Super Manager
- ↳ Coachbet - The Fortnightly Fantasy Football Game
- ↳ Link to Coachbet
- ↳ Player Manager
- ↳ Link to Player Manager
- ↳ Football Manager
- ↳ SoccerManager
- ↳ Soccer Millionaire
- ↳ Link to Soccer Millionaire
- ↳ Orange Fantasy League
- ↳ Link to Orange Fantasy League
- ↳ Fantasy Football League
- ↳ Link to Fantasy Football League
- ↳ William Hill Fantasy League
- ↳ Elephant Fantasy Football
- ↳ Sportingbet Fantasy League
- ↳ Irish Times
- ↳ La Log
- ↳ Drunken League Association
- ↳ TFF Divisions
- ↳ Totel Football
- ↳ Link to Totel Football
- ↳ Fantasy Football Exchange
- ↳ Metro Fantasy Football
- ↳ Link to Metro Fantasy Football
- ↳ Mondogoal
- ↳ Link to Mondogoal
- ↳ Daily Star FF games
- ↳ Link to Daily Star FF
- ↳ Beat Your Manager! Fantasy Football (BYM)
- ↳ Yahoo! FF games
- ↳ Soccernet/ESPN Fantasy Soccer
- ↳ Ultimate FPL
- ↳ Link to Ultimate FPL
- ↳ Oulala Fantasy Football
- ↳ How to Win at FPL by FF Hub
- ↳ European Dream Team
- ↳ Link to European Dream Team
- ↳ SDT weekly games
- ↳ Sun Predictor / Weekend Dream Team Link
- Other Fantasy Sports Forums
- ↳ General Fantasy Sports (FS) Notices & Comments
- ↳ Link to Pay It Square
- ↳ Fantasy Cricket
- ↳ Fantasy Golf
- ↳ Fantasy Australian Rules Football
- ↳ Fantasy Cycling
- ↳ Fantasy Horse Racing
- ↳ Fantasy Motor Racing (incl F1)
- ↳ Fantasy F1 FanTeam Link
- ↳ Fantasy Rugby
- ↳ Fantasy NFL
- ↳ Fantasy NBA
- ↳ Link to Fantasy NBA by FanTeam
- ↳ FanTeam NBA Player Stats
- ↳ Link to Official NBA News
- ↳ Fantasy Baseball
- ↳ Fantasy Darts
- ↳ Fantasy Tennis
- ↳ Fantasy Motor Cycling
- ↳ Fantasy Investments
- ↳ Fantasy Snooker
- ↳ Fantasy Greyhound Racing
- ↳ Fantasy Polo
- ↳ Zweeler Fantasy Games
- ↳ Zweeler Cycling
- ↳ Zweeler F1/MotoGP
- ↳ Zweeler Tennis
- ↳ Zweeler Golf
- ↳ Zweeler Darts
- ↳ Zweeler Cyclo Cross
- ↳ Zweeler Ice Speed Skating
- ↳ Zweeler Stock Exchange
- ↳ Fanto - Daily Fantasy Sports
- ↳ Link to Fanto
- ↳ Other Fantasy Competitions
- Gambling Forums
- ↳ The Betting Forum
- ↳ FanTeam Sportsbook
- ↳ Online Bookmaker Links
- ↳ Link to William Hill
- ↳ Online Bookmaker Links
- ↳ FISO Poker Society
- ↳ Online Poker Links
- ↳ PokerStars Home Games
- ↳ The Casino Forum
- ↳ Poker & Casino Links
- ↳ Online Poker & Casino Links
- ↳ FISO Chat Room Link
- Sports Talk Forums
- ↳ Football Talk & Events
- ↳ Internationals Football Talk & Events
- ↳ Players of the Year
- ↳ Sports Talk & Events (excluding Football)
- ↳ FISO Chat Room Link
- Non-Sports Forums
- ↳ COVID-19
- ↳ Science, Computers & Technology (e.g. PCs, Web, TVs, Mobiles, Ipods, Gadgets)
- ↳ Spreadsheets
- ↳ Music
- ↳ Movies, TV & Radio
- ↳ Movies 'World Cup' Competitions
- ↳ Food & Drink
- ↳ Financial & Shopping
- ↳ PropertyPartner
- ↳ Ratesetter
- ↳ Link to BrickLane
- ↳ Link to Amazon
- ↳ Link to Revolut
- ↳ Travel, Holidays & Leisure
- ↳ Spanish Holiday Rental Offer
- ↳ Diving Malta Gozo
- ↳ Learn to dive holidays in Malta Gozo
- ↳ Games incl. Video Games
- ↳ Risk
- ↳ Arts, Literature & Cultural Events
- ↳ Health & fitness incl. well-being
- ↳ Careers, Businesses & Hobbies
- ↳ DIY
- ↳ Gardening
- ↳ Photography
- ↳ Motoring Forum
- ↳ Stuff (That Doesn't Fit Anywhere Else!)
- ↳ Miss Fiso World Cup 2010