AEPL Fantasy Game: Draw/Results/Table

Started by Fletch74, September 13, 2010, 12:30:21 PM

Previous topic - Next topic

Fletch74

#45
In light of my uploading problem from Excel and some feedback in the feedback section I have manged to upload the file in which I will keep score.

It contains the draw for pre-season, the regular season, what will be the table once the season commences, plus it has everyone's team that they have chosen for this week, as well as data from all the EPL clubs (the data for Rd 3 was a cumulative figure for the first 3 rounds).

I will be posting this each week as well as the H2H results and the table.

http://www.mediafire.com/?kuabdhpdq36p2jf

It has all the statistics from all the clubs. I will also introduce an archive tab for each teams results too.

The "SR" next to the players in the starting XI are just stating that there are subs required because that player has not played any minutes.

Cheers :)

benjy251090


Hawka

yep thx fletch u have helped so much with this and cant be thank enof could work mate  ;)

Fletch74


Justin Bieber


Fletch74

#50
Results for Pre-Season Cup Round 1

                                      Score                                         Score
Hilly's Heroics                     44   ZZ's Zanny Zebra's                44
Q's Champions                   48   Hawka FC                              34
Hello                                 59   The Matchbox Matadors          34
Lardner's Loveable Losers   28   Didhedive Drogba                   33

So, we have a tie between Hilly and Zz?? What do we do?

The other winners were: Q, HP, and Andrew.

So the draw for next week is:

Hilly's Heroics/ZZ's Zanny Zebra's vs Q's Champions
Hello vs Didhedive Drogba

Practice Matches are:

Hilly's Heroics/ZZ Zanny Zebra's vs Hawka FC
The Matchbox Matadors vs Larder's Loveable Losers

To see teams and data;

PS Week 1 Results

Master Q

I couldn't really think of anyway to pick a winner out of Zz and Hilly, but I thought of 2 ways to solve it:


A: 3 Way Game - Zz's Zanny Zebra's v Hilly Heroics v Q's Champions - This could be a good way to do it, but it is rather unfair to me, as I have to beat both of them to go through.

B: Free Ticket - I don't play either of them, and progress to the Final. This is once again unfair, but this time to Zz and Hilly.

benjy251090


Master Q

Also Fletch, how are you listing the teams each week. For example, you've listed everyone's team this week, Starting 11 then the 4 Subs below, but where will you list next weeks team, or are you just going to delete this (last) weeks?

Maybe Benjy  :P

Fletch74

The options that could be considered are that I chose for Hilly, thus he goes through...

or

That Zz managed to equal Hilly's score with only 10 players scoring...

Otherwise i don't know??

Fletch74

Quote from: Master Q on September 27, 2010, 10:50:41 AM
Also Fletch, how are you listing the teams each week. For example, you've listed everyone's team this week, Starting 11 then the 4 Subs below, but where will you list next weeks team, or are you just going to delete this (last) weeks?

Maybe Benjy  :P
I'm only going to list the teams in the thread that you create for each week's analysis, thus I can put them in there. I'm not putting them in this thread.

If you're talking about the spreadsheet, then this weeks team will go into an archive worksheet, and the next week's team will be under each team's worksheet

Master Q

I was taking about the Spreadsheet Fletch.

chrisuzz

The practice matches could be turned into a minor premiership so the people that lost last week still have something to play for

Fletch74

Difficult Zz, as there are only 2 more weeks until the season starts and 2 more teams will join them next week...

You can still try and trade etc for Rd1??

chrisuzz

i thought the 1st round of the season was also the final the pre season cup??

Are you not allowed to trade during the season ??