Fantasy Fixtures

15
 Customisable PL Fixture List 2014/15 For a while I h ad plann ed on mak ing a i xture list based on di!idi ng all o the teams in the Prem dii"ult# $ so that w hen it "ame to de"iding w hi"h "olour should represent ea"h mat"h it would b was eeling at the time %translation& super in"onsistent'()  *ter dis"ussing the rel ati!e dii"ult ies o dierent teams w ith some o the good olks o!er at F that$ while we all ag reed on ,an Ci t# and *rsenal belongi ng to the t op group$ there w ere se!er -ome pu t -tok e in the se "ond gr oup wi th -pur s$ while others put them in the thi rd grou p with t I didn.t want to spend a ges tailormaking m# own spreadsheet onl# or others to disagree with that would ha! e been a big wa ste o time) -o wha t #ou ins tead ha!e be ore #ou i s a spreads he also al lows # ou to mak e ui" k and simple "ha nges to a n#thi ng #ou di sagre e wit h %as lo ng as # stru"ture i this is a hit I intend to make a more detailed one or next #ear() asi"all#$ i it.s in a 3a riables tab$ # ou "an "hange the ! alue$ press enter $ and the "olour will "hange in the i xture li his will also be useul as the season wears on$ where some teams impro!e and others alter) long ix ture list somewh at obsol et e "ome 8anuar #$ but with this s#st em # ou "an "onst antl # be u ea"h team as and when ne"essar#)  

description

Fantasy Football Fixture Tracker

Transcript of Fantasy Fixtures

Welcome

Customisable PL Fixture List 2014/15

Welcome to this interactive, season-long fixture list.

For a while I had planned on making a fixture list based on dividing all of the teams in the Premier League into four groups of relative difficulty, so that when it came to deciding which colour should represent each match it would be consistent as opposed to however I was feeling at the time (translation: super inconsistent!).

After discussing the relative difficulties of different teams with some of the good folks over at FF247 though, it soon became apparent that, while we all agreed on Man City and Arsenal belonging to the top group, there were several teams that we all disagreed on. Some put Stoke in the second group with Spurs, while others put them in the third group with the likes of Sunderland for example.

I didn't want to spend ages tailor-making my own spreadsheet only for others to disagree with a few of my valuations when I shared it; that would have been a big waste of time. So what you instead have before you is a spreadsheet that shows all of the fixtures, but also allows you to make quick and simple changes to anything you disagree with (as long as you keep to within the 4-tiered group structure - if this is a hit I intend to make a more detailed one for next year). Basically, if it's in a cyan-coloured column in the Variables tab, you can change the value, press enter, and the colour will change in the fixture list AUTOMATICALLY.

This will also be useful as the season wears on, where some teams improve and others falter. This would render any rigid season-long fixture list somewhat obsolete come January, but with this system you can constantly be updating the relative difficulties of each team as and when necessary.

Made by Calvin Clyne (@SharpyBoy86), on behalf of everyone at http://www.fantasyfootball247.co.uk/. Special mention should go to my wonderful girlfriend and Dreamers from FF247, who both helped me get my head around the formulas necessary to make this work.

How It Works

Each team is given a ranking of 1, 2, 3 or 4 according to their difficulty, with 1 being the hardest.The default layout for the team rankings is shown below:There are 8 possible permutations for each group - a home and away match against teams from all 4 groups. Multiply this by 4 to include all 4 groups, and this gives us 32 different possible outcomes, each with its own colour- coded difficulty. These are shown below, along with the default ratings:Both the team rankings (as shown on the left, 1-4) and the match difficulties (as shown below, A-E) can be altered as you wish. This is done in the Variables tab (at the bottom of the page).

After you have made the desired changes, click on the Fixtures tab to see your own customised tracker, with personalised colour-changes.

ARS1CRY2NEW3AVL4CHE1EVE2SOU3BUR4LIV1STK2SUN3HUL4MCI1TOT2SWA3LEI4Group 1 Vs Group 4 HomeAGroup 2 Vs Group 4 HomeBGroup 3 Vs Group 4 HomeBGroup 4 Vs Group 4 HomeBMUN1WBA3QPR4Group 1 Vs Group 4 AwayBGroup 2 Vs Group 4 AwayBGroup 3 Vs Group 4 AwayCGroup 4 Vs Group 4 AwayCWHU3Group 1 Vs Group 3 HomeBGroup 2 Vs Group 3 HomeCGroup 3 Vs Group 3 HomeCGroup 4 Vs Group 3 HomeCGroup 1 Vs Group 3 AwayCGroup 2 Vs Group 3 AwayCGroup 3 Vs Group 3 AwayCGroup 4 Vs Group 3 AwayCEvery possible meeting between teams of these 4 groups is then also given a rating of A, B, C, D or E depending of the difficulty of that particular fixture.Group 1 Vs Group 2 HomeCGroup 2 Vs Group 2 HomeCGroup 3 Vs Group 2 HomeCGroup 4 Vs Group 2 HomeCGroup 1 Vs Group 2 AwayCGroup 2 Vs Group 2 AwayDGroup 3 Vs Group 2 AwayDGroup 4 Vs Group 2 AwayDGroup 1 Vs Group 1 HomeDGroup 2 Vs Group 1 HomeDGroup 3 Vs Group 1 HomeDGroup 4 Vs Group 1 HomeDGroup 1 Vs Group 1 AwayDGroup 2 Vs Group 1 AwayEGroup 3 Vs Group 1 AwayEGroup 4 Vs Group 1 AwayEABCDE

For example, if Arsenal play Burnley at home then,referring to the groups above, that will be:Group 1 vs Group 4 HomeAIf you wish to change the colours of A-E then right-click on one of the fixtures in the Fixtures tab and click on 'Conditional Formatting' and select a different colour, see if I care ;)The exact same fixture from Burnley's point of view:Group 4 vs Group 1 AwayE

FIXTURES12345TotalsLast 3 gamesLast 3 gamesTotal so far1234567891011121314151617181920212223242526272829303132333435363738TeamEaseCleanAttackEaseCleanAttackEaseCleanAttackEaseCleanAttackEaseCleanAttackEaseCleanAttackTotalH - ForH AgainstA - ForA AgainstForAgainstARSCRYeveleiMCIavlTOTcheHULsunBURswaMUNwbaSOUstkNEWlivQPRwhusouSTKmciAVLtotLEIcryEVEqprWHUnewLIVburSUNCHEhulSWAmunWBACHE51141133411193325411065521AVLstkNEWHULlivARScheMCIeveqprTOTwhuSOUburcryLEIwbaMUNswaSUNCRYleiLIVarsCHEhulSTKnewWBAsunSWAmuntotQPRmciEVEWHUsouBURMCI4351140141020222445635125BURCHEswaMUNcrySUNwbaleiWHUEVEarsHULstkAVLNEWqprSOUtotLIVmcinewQPRCRYsunWBAmuncheSWAlivMCIsouTOTARSeveLEIwhuhulSTKavlSOU34411251118222221413817CHEburLEIeveSWAmciAVLARScrymunQPRlivWBAsunTOTnewHULstkWHUsoutotNEWswaMCIavlEVEBURleiwhuSOUhulSTKqprMUNarsCRYLIVwbaSUNARS400400411300400191121101344728CRYarsWHUnewBUReveLEIhulCHEwbaSUNmunLIVswaAVLtotSTKmciSOUqpravlTOTburEVEleiNEWARSwhusouQPRstkMCIsunWBAHULcheMUNlivSWATOT34424117011895653934EVEleiARSCHEwbaCRYlivmunAVLburSWAsunWHUtotHULmciQPRsouSTKnewhulMCIWBAcryLIVcheLEIarsstkNEWqprSOUswaBURMUNavlSUNwhuTOTAVL3334316001614081234HULqprSTKavlWHUnewMCICRYarslivSOUburTOTmuneveWBAcheSWAsunLEIEVEwbawhuNEWmciAVLQPRstkSUNleiCHEswasouLIVcryARSBURtotMUNSTK3433316001656242833LEIEVEcheARSstkMUNcryBURnewswaWBAsouSUNqprLIVavlMCIwhuTOThullivAVLSTKmunCRYarseveCHEmciHULtotWHUwbaSWAburNEWSOUsunQPREVE4133415001511133135LIVSOUmcitotAVLwhuEVEWBAqprHULnewCHEcrySTKleiSUNmunARSburSWALEIsunavlWHUeveTOTsouMCIBURswaMUNarsNEWhulwbaQPRcheCRYstkMUN3433215001563424324MCInewLIVSTKarsCHEhulavlTOTwhuMUNqprSWAsousunEVEleiCRYwbaBURSUNeveARScheHULstkNEWlivLEIburWBAcrymunWHUAVLtotQPRswaSOUSWA3423315001527232833MUNSWAsunburQPRleiWHUEVEwbaCHEmciCRYarsHULSTKsouLIVavlNEWtotstkSOUqprLEIwhuBURswaSUNnewTOTlivAVLMCIcheeveWBAcryARShulHUL3333214001443152334NEWMCIavlCRYsouHULstkswaLEItotLIVwbaQPRwhuburCHEarsSUNmunEVEBURcheSOUhulSTKcrymciAVLMUNeveARSsunlivTOTSWAleiWBAqprWHULIV2243314001474303629QPRHULtotSUNmunSTKsouwhuLIVAVLcheMCInewLEIswaBUReveWBAarsCRYSWAburMUNstkSOUsunhulTOTARScryEVEwbaCHEavlWHUlivmciNEWleiWHU2422414001452133628SOUlivWBAwhuNEWswaQPRtotSUNSTKhulLEIavlMCIarsMUNburEVEcryCHEARSmunnewSWAqprWHULIVwbaCRYcheBUReveHULstkTOTsunleiAVLmciQPR3223313001314452643STKAVLhulmciLEIqprNEWsunSWAsouWHUtotBURlivmunARScryCHEeveWBAMUNarsleiQPRnewMCIavlHULEVEwbaCRYchewhuSOUSUNswaTOTburLIVSUN3233213001323462236SUNwbaMUNqprTOTburSWASTKsouARScryEVEleiCHEMCIlivWHUnewHULavlmciLIVtotBURswaQPRWBAmunhulAVLwhuNEWCRYarsstkSOUeveLEIcheWBA4233113001333332434SWAmunBURWBAcheSOUsunNEWstkLEIeveARSmciCRYQPRwhuTOThulAVLlivqprWHUCHEsouSUNwbaMUNburtotLIVavlHULEVEleinewSTKarsMCIcryCRY200214312001233422735TOTwhuQPRLIVsunWBAarsSOUmciNEWavlSTKhulEVEcheCRYswaBURleiMUNCHEcrySUNwbaARSlivWHUqprSWAmunLEIburAVLnewsouMCIstkHULeveNEW1333212001256433137WBASUNsouswaEVEtotBURlivMUNCRYleiNEWcheARSWHUhulAVLqprMCIstkwhuHULeveTOTburSWAsunSOUavlSTKmciQPRLEIcryLIVmunnewCHEarsLEI3213211001112472240WHUTOTcrySOUhulLIVMUNQPRburMCIstkAVLeveNEWwbaSWAsunLEIcheARSWBAswaHULlivMUNsoutotCRYCHEarsSUNleiSTKmciqprBURavlEVEnewBUR13221900966482443

12345EDCBA1234567891011121314151617181920212223242526272829303132333435363738ARSBBBCBCDABABCBCBBCACDBDBCABBBCBCBACBBCBReorder alphabeticallyAVLCCBDDEDCBCDDBCBCCCBCBCEDBCCCBCDDBECCEBAdd recent form from website, and total for/againstBURDCDCCCCDCECCCCCDDDECCCCCDECDDEDDCCDCCCFill from match coloursCHEBABBDBCBCACBBCBABCDCBBCBBABCCBBBCDBCBAUse judgment to adjust ease by colour, clean and attackCRYECCBCBBDCBDCCCDCEDBCCBCBCDDEBCDBCBECDCSort total column - descendingEVEBDDCCDDCBCBCDBEBECCBDCCCEBECCBDCBCCBDCHULCCCDCDCEDDCDDCCECCCCCDCECCCCCDCEDCDCDDLEICEDCDCCCCCECCDCDDDCDCCDCECDECDDCCCCDCCLIVDDDBDBBBBCDCBBBDDBBBBCCCCDDBCCDBBCBDBCMCIBCBDCBBCCCBBDBBBBBAABCDABBCABBBCCBCABCMUNBBBBBCBCDDBDBBDCCBDCDBBDBCBCCDBDDCBCDBNEWDCCEBCCBDCCBDBDEBDCBEDBCCECCCDBDCCBCBCQPRCDCDCEDDCEDCCCCCCECCCDCDCCDDCCCDCDDECCSOUCBCBBACABBABCDCBBBCCCBBBCCBBDABABCBBBDSTKCBEBBCBCECDBDDDCDCCCEBBCDCBCCCEDDBCCBCSUNCDCDCCCEDCCCDDDDCCCEDDCCCCDCCDCCECDCCESWADBCEDBCCBCDECBDCBCDBCDEBCCBDCCBCBCCEDCTOTDBCBBDDDBCBBBDBCBBCDCBCDDCBBDBBBCDDCBCWBABECCDBDCCBCEDCBCBDCDBCCBCBDCCEBBCCDCDEWHUCCDBCCBBDCBCBCBBBDDBCBDCDDBDDBBBDBBCBCABCDE

COMPARE FIXTURESSelect Team1234567891011121314151617181920212223242526272829303132333435363738Add TeamAdd TeamAdd TeamAdd TeamAdd TeamAdd TeamAdd TeamAdd TeamAdd TeamAdd TeamAdd TeamAdd TeamAdd TeamAdd TeamAdd TeamAdd TeamAdd TeamAdd TeamAdd TeamAdd Team

ARSCRYeveleiMCIavlTOTcheHULsunBURswaMUNwbaSOUstkNEWlivQPRwhusouSTKmciAVLtotLEIcryEVEqprWHUnewLIVburSUNCHEhulSWAmunWBAAVLstkNEWHULlivARScheMCIeveqprTOTwhuSOUburcryLEIwbaMUNswaSUNCRYleiLIVarsCHEhulSTKnewWBAsunSWAmuntotQPRmciEVEWHUsouBURBURCHEswaMUNcrySUNwbaleiWHUEVEarsHULstkAVLNEWqprSOUtotLIVmcinewQPRCRYsunWBAmuncheSWAlivMCIsouTOTARSeveLEIwhuhulSTKavlCHEburLEIeveSWAmciAVLARScrymunQPRlivWBAsunTOTnewHULstkWHUsoutotNEWswaMCIavlEVEBURleiwhuSOUhulSTKqprMUNarsCRYLIVwbaSUNCRYarsWHUnewBUReveLEIhulCHEwbaSUNmunLIVswaAVLtotSTKmciSOUqpravlTOTburEVEleiNEWARSwhusouQPRstkMCIsunWBAHULcheMUNlivSWAEVEleiARSCHEwbaCRYlivmunAVLburSWAsunWHUtotHULmciQPRsouSTKnewhulMCIWBAcryLIVcheLEIarsstkNEWqprSOUswaBURMUNavlSUNwhuTOTHULqprSTKavlWHUnewMCICRYarslivSOUburTOTmuneveWBAcheSWAsunLEIEVEwbawhuNEWmciAVLQPRstkSUNleiCHEswasouLIVcryARSBURtotMUNLEIEVEcheARSstkMUNcryBURnewswaWBAsouSUNqprLIVavlMCIwhuTOThullivAVLSTKmunCRYarseveCHEmciHULtotWHUwbaSWAburNEWSOUsunQPRLIVSOUmcitotAVLwhuEVEWBAqprHULnewCHEcrySTKleiSUNmunARSburSWALEIsunavlWHUeveTOTsouMCIBURswaMUNarsNEWhulwbaQPRcheCRYstkMCInewLIVSTKarsCHEhulavlTOTwhuMUNqprSWAsousunEVEleiCRYwbaBURSUNeveARScheHULstkNEWlivLEIburWBAcrymunWHUAVLtotQPRswaSOUMUNSWAsunburQPRleiWHUEVEwbaCHEmciCRYarsHULSTKsouLIVavlNEWtotstkSOUqprLEIwhuBURswaSUNnewTOTlivAVLMCIcheeveWBAcryARShulNEWMCIavlCRYsouHULstkswaLEItotLIVwbaQPRwhuburCHEarsSUNmunEVEBURcheSOUhulSTKcrymciAVLMUNeveARSsunlivTOTSWAleiWBAqprWHUQPRHULtotSUNmunSTKsouwhuLIVAVLcheMCInewLEIswaBUReveWBAarsCRYSWAburMUNstkSOUsunhulTOTARScryEVEwbaCHEavlWHUlivmciNEWleiSOUlivWBAwhuNEWswaQPRtotSUNSTKhulLEIavlMCIarsMUNburEVEcryCHEARSmunnewSWAqprWHULIVwbaCRYcheBUReveHULstkTOTsunleiAVLmciSTKAVLhulmciLEIqprNEWsunSWAsouWHUtotBURlivmunARScryCHEeveWBAMUNarsleiQPRnewMCIavlHULEVEwbaCRYchewhuSOUSUNswaTOTburLIVSUNwbaMUNqprTOTburSWASTKsouARScryEVEleiCHEMCIlivWHUnewHULavlmciLIVtotBURswaQPRWBAmunhulAVLwhuNEWCRYarsstkSOUeveLEIcheSWAmunBURWBAcheSOUsunNEWstkLEIeveARSmciCRYQPRwhuTOThulAVLlivqprWHUCHEsouSUNwbaMUNburtotLIVavlHULEVEleinewSTKarsMCIcryTOTwhuQPRLIVsunWBAarsSOUmciNEWavlSTKhulEVEcheCRYswaBURleiMUNCHEcrySUNwbaARSlivWHUqprSWAmunLEIburAVLnewsouMCIstkHULeveWBASUNsouswaEVEtotBURlivMUNCRYleiNEWcheARSWHUhulAVLqprMCIstkwhuHULeveTOTburSWAsunSOUavlSTKmciQPRLEIcryLIVmunnewCHEarsWHUTOTcrySOUhulLIVmunQPRburMCIstkAVLeveNEWwbaSWAsunLEIcheARSWBAswaHULlivMUNsoutotCRYCHEarsSUNleiSTKmciqprBURavlEVEnew

1234567891011121314151617181920212223242526272829303132333435363738Add TeamFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFARSBBBCBCDABABCBCBBCACDBDBCABBBCBCBACBBCBAVLCCBDDEDCBCDDBCBCCCBCBCEDBCCCBCDDBECCEBBURDCDCCCCDCECCCCCDDDECCCCCDECDDEDDCCDCCCCHEBABBDBCBCACBBCBABCDCBBCBBABCCBBBCDBCBACRYECCBCBBDCBDCCCDCEDBCCBCBCDDEBCDBCBECDCEVEBDDCCDDCBCBCDBEBECCBDCCCEBECCBDCBCCBDCHULCCCDCDCEDDCDDCCECCCCCDCECCCCCDCEDCDCDDLEICEDCDCCCCCECCDCDDDCDCCDCECDECDDCCCCDCCLIVDDDBDBBBBCDCBBBDDBBBBCCCCDDBCCDBBCBDBCMCIBCBDCBBCCCBBDBBBBBAABCDABBCABBBCCBCABCMUNBBBBBCBCDDBDBBDCCBDCDBBDBCBCCDBDDCBCDBNEWDCCEBCCBDCCBDBDEBDCBEDBCCECCCDBDCCBCBCQPRCDCDCEDDCEDCCCCCCECCCDCDCCDDCCCDCDDECCSOUCBCBBACABBABCDCBBBCCCBBBCCBBDABABCBBBDSTKCBEBBCBCECDBDDDCDCCCEBBCDCBCCCEDDBCCBCSUNCDCDCCCEDCCCDDDDCCCEDDCCCCDCCDCCECDCCESWADBCEDBCCBCDECBDCBCDBCDEBCCBDCCBCBCCEDCTOTDBCBBDDDBCBBBDBCBBCDCBCDDCBBDBBBCDDCBCWBABECCDBDCCBCEDCBCBDCDBCCBCBDCCEBBCCDCDEWHUCCDBCCBBDCBCBCBBBDDBCBDCDDBDDBBBDBBCBCABCDE

Variables

ARS1Team RankingsRelative DifficultiesGroup 1 Vs Group 4 HomeAGroup 3 Vs Group 4 HomeBAVL3Group 1 Vs Group 4 AwayBGroup 3 Vs Group 4 AwayBBUR4The teams are listed alphabeticallyon the left, and alongside each isits ranking.

Any that you disagree with may bechanged by simply replacing the default number with your own.

Perhaps you think Villa will improvethis season, and don't deserve tobe as low as Group 4? Easy then; select the cyan-coloured cell next to AVL, type '3' and press enter,and, hey presto, all of Villa's corresponding colours in the Fixtures tab will automatically update for you.

You MUST use a value in the range1-4.All possible meetings between the teams in your chosen groups are listed on the right, again with theirrelative difficulties alongside.

Once again, you may change anyof the letters that represent the difficulties.

You MUST use a value in the rangeA-E.

*Close observers may note that thedefault difficulties are the same forGroup 3's and Group 4's matches (both read B, C, C, C, C, D, D, E), and so may wonder what is the point in having them in differentgroups at all? Well there is a point,e.g. in Group 2 the matches against Group 3 have a C difficulty, as opposed to a B difficulty for the matches against Group 4.Group 1 Vs Group 3 HomeBGroup 3 Vs Group 3 HomeCCHE1Group 1 Vs Group 3 AwayBGroup 3 Vs Group 3 AwayCCRY3Group 1 Vs Group 2 HomeCGroup 3 Vs Group 2 HomeCEVE3Group 1 Vs Group 2 AwayCGroup 3 Vs Group 2 AwayDHUL4Group 1 Vs Group 1 HomeCGroup 3 Vs Group 1 HomeDLEI4Group 1 Vs Group 1 AwayDGroup 3 Vs Group 1 AwayELIV2MCI1Group 2 Vs Group 4 HomeBGroup 4 Vs Group 4 HomeCMUN2Group 2 Vs Group 4 AwayBGroup 4 Vs Group 4 AwayCNEW3Group 2 Vs Group 3 HomeBGroup 4 Vs Group 3 HomeCQPR4Group 2 Vs Group 3 AwayCGroup 4 Vs Group 3 AwayCSOU1Group 2 Vs Group 2 HomeCGroup 4 Vs Group 2 HomeDSTK3Group 2 Vs Group 2 AwayDGroup 4 Vs Group 2 AwayDSUN4Group 2 Vs Group 1 HomeDGroup 4 Vs Group 1 HomeDSWA3Group 2 Vs Group 1 AwayDGroup 4 Vs Group 1 AwayETOT2WBA3WHU2

DataGroupsCombinationsNotesARS1the numbers14TRUEATRUE = HomeCHE1to the left14FALSEBFalse = AwayLIV2correspond13TRUEBMCI1with the group13FALSEBMUN2difficulties12TRUECand the lettersCRY312FALSECon the leftEVE311TRUECrepresent theSTK3the numbers to11FALSEDdifficulty of eachTOT2the right are all24TRUEBmatch, e.g.NEW3of the different24FALSEBGroup 2 teamSOU1permutations23TRUEBv Group 4 teamSUN4of said23FALSECat home is a BSWA3difficulties, like22TRUECdifficulty (green)WBA31 v 4, 1 v 3, etc.22FALSEDWHU221TRUEDAVL3TRUE and21FALSEDBUR4FALSE34TRUEBHUL4represents34FALSEBLEI4home + away33TRUECQPR433FALSEC32TRUEC32FALSED31TRUED31FALSEE44TRUEC44FALSEC43TRUEC43FALSEC42TRUED42FALSED41TRUED41FALSEE

HA Data1234567891011121314151617181920212223242526272829303132333435363738ARSTRUEFALSEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUETRUEFALSETRUEFALSETRUEAVLFALSETRUETRUEFALSETRUEFALSETRUEFALSEFALSETRUEFALSETRUEFALSEFALSETRUEFALSETRUEFALSETRUETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSEFALSETRUEFALSETRUETRUEFALSETRUEBURTRUEFALSETRUEFALSETRUEFALSEFALSETRUETRUEFALSETRUEFALSETRUETRUEFALSETRUEFALSETRUEFALSEFALSETRUETRUEFALSETRUEFALSEFALSETRUEFALSETRUEFALSETRUETRUEFALSETRUEFALSEFALSETRUEFALSECHEFALSETRUEFALSETRUEFALSETRUETRUEFALSEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSEFALSETRUEFALSETRUEFALSETRUETRUEFALSEFALSETRUEFALSETRUEFALSETRUEFALSETRUETRUEFALSETRUECRYFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSEFALSETRUEFALSETRUEFALSETRUETRUEFALSEFALSETRUEFALSETRUEFALSETRUETRUEFALSETRUEFALSETRUEEVEFALSETRUETRUEFALSETRUEFALSEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSEFALSETRUETRUEFALSETRUEFALSETRUEFALSEFALSETRUEFALSETRUEFALSETRUETRUEFALSETRUEFALSETRUEHULFALSETRUEFALSETRUEFALSETRUETRUEFALSEFALSETRUEFALSETRUEFALSEFALSETRUEFALSETRUEFALSETRUETRUEFALSEFALSETRUEFALSETRUETRUEFALSETRUEFALSETRUEFALSEFALSETRUEFALSETRUETRUEFALSETRUELEITRUEFALSETRUEFALSETRUEFALSETRUEFALSEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSEFALSETRUETRUEFALSETRUEFALSEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUETRUEFALSETRUELIVTRUEFALSEFALSETRUEFALSETRUETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUETRUEFALSEFALSETRUEFALSETRUEFALSETRUETRUEFALSETRUEFALSETRUEFALSEFALSETRUEFALSETRUEFALSEMCIFALSETRUETRUEFALSETRUEFALSEFALSETRUEFALSETRUEFALSETRUEFALSEFALSETRUEFALSETRUEFALSETRUETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSEFALSETRUETRUEFALSETRUEFALSETRUEMUNTRUEFALSEFALSETRUEFALSETRUETRUEFALSETRUEFALSETRUEFALSETRUETRUEFALSETRUEFALSETRUEFALSEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUETRUEFALSEFALSETRUEFALSETRUEFALSENEWTRUEFALSETRUEFALSETRUEFALSEFALSETRUEFALSETRUEFALSETRUEFALSEFALSETRUEFALSETRUEFALSETRUETRUEFALSETRUEFALSETRUEFALSEFALSETRUETRUEFALSETRUEFALSEFALSETRUETRUEFALSETRUEFALSETRUEQPRTRUEFALSETRUEFALSETRUEFALSEFALSETRUETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUETRUEFALSETRUEFALSETRUEFALSEFALSETRUETRUEFALSETRUEFALSETRUEFALSETRUEFALSEFALSETRUEFALSESOUFALSETRUEFALSETRUEFALSETRUEFALSETRUETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUETRUEFALSEFALSETRUEFALSETRUETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSEFALSETRUEFALSESTKTRUEFALSEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSEFALSETRUEFALSETRUEFALSETRUETRUEFALSEFALSETRUEFALSETRUEFALSETRUETRUEFALSETRUEFALSEFALSETRUETRUEFALSETRUEFALSETRUESUNFALSETRUEFALSETRUEFALSETRUETRUEFALSETRUEFALSETRUEFALSETRUETRUEFALSETRUEFALSETRUEFALSEFALSETRUEFALSETRUEFALSETRUETRUEFALSEFALSETRUEFALSETRUETRUEFALSEFALSETRUEFALSETRUEFALSESWAFALSETRUETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUETRUEFALSETRUEFALSETRUEFALSEFALSETRUETRUEFALSETRUEFALSETRUEFALSEFALSETRUEFALSETRUETRUEFALSEFALSETRUEFALSETRUEFALSETOTFALSETRUETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSEFALSETRUEFALSETRUEFALSEWBATRUEFALSEFALSETRUEFALSETRUEFALSETRUETRUEFALSETRUEFALSETRUETRUEFALSETRUEFALSETRUEFALSEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUETRUEFALSETRUEFALSEFALSETRUEFALSEWHUTRUEFALSETRUEFALSETRUETRUETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUEFALSETRUETRUEFALSETRUEFALSETRUEFALSEFALSETRUETRUEFALSETRUEFALSETRUEFALSEFALSETRUEFALSETRUEFALSE

Sheet1TeamTimesAddTeamTimesAddTotalARS3218MCI512045.5=MCIAVL4217EVE481943+11CHEBUR4217NEW481943+1MUNCHE3218MUN402242+1TOTCRY2816TOT451840.5-2NEWEVE4819AVL421738+2BURHUL2213SWA421738+3ARSLEI3615BUR421738-6EVELIV3218WHU391635.5+2LIVMCI5120ARS321834-1WHUMUN4022LIV321834+8SOUNEW4819WBA321834-5SWAQPR3314CHE321834+4STKSOU2414LEI361533+1QPRSTK2816QPR331430.5-3WBASUN2414CRY281630-10AVLSWA4217STK281630+1SUNTOT4518SUN241426-2CRYWBA3218SOU241426+1HULWHU3916HUL221324-6LEI