The spreadsheet will be updated frequently! I will post in this thread when it is updated.
There are four sheets in the spreadsheet! Be sure you click at the bottom to tab between "FPL Owner Rankings", "Player Stats", and "Team Scores". Anyone asking "but where are player stats and team scores?" will be publicly ridiculed.
This thread is for discussing the results and standings as posted above. Feel free to copy and paste relevant stats and information into this thread, but please be reasonable with how much you copy.
If you see any mistakes, please PM me. If you find a mistake in your team, a player's score, a team's score, or any relevant field, I will correct it as soon as I can.
Expect to be spoiled in this thread. The use of spoiler tags is purely optional.
Feedback is welcome. If you have any suggestions or constructive criticism pertaining to the spreadsheet, don't hesitate to send me a PM or write about it in the thread.
[*]Counts of how many people own each player [*]Plus/minus trade value differential for each player [*]Total trade value for each FPL owner [*]New thread about trading [*]Team cost and trade values
Light and Stork are the common themes of the teams currently at the top, not surprising as they've both way outplayed their 4 point cost so far. My team is doing about as expected, just need Oz and KT to actually get to ace matches for my team to reach its true potential, which I'm not sure will happen.
Damn 1st place got like x2 of my points lol. So far its not bad but Turn and Brave with 0 and Afrotoss with -1 is slowing me down. At least my anti is perfect Hyun,Horang2,M18M FTL +4
looks like some people are picking players and TRYING to have as few points as possible but yeah all the people at the top have Light and Stork in their team...
On November 29 2010 23:50 SkelA wrote: Damn 1st place got like x2 of my points lol. So far its not bad but Turn and Brave with 0 and Afrotoss with -1 is slowing me down. At least my anti is perfect Hyun,Horang2,M18M FTL +4
Wow 5th :D even with kal not playing and shuttle winning >.< probably soon to be top 5 in LB too as i voted MBC and SKT, currently 8th there, gogogoogo me :D:D
Shoot. My anti-team has been burning a hole but it's not TOO bad seeing that I would have picked Jaehoon or Ggaemo, which still wouldn't have turned out well.
Should have picked Wemade over KT seeing as KT still seems to be on a slide. Will need to make some trades to even have a prayer. Though, in all honesty, ~380ish isn't TOO bad.
Woohooo 4th is pretty nice ^_^, I was hoping KT Rolster would break it's slump, and of course everyone on STX had to win except Clam, (against Flash eck).
I'm still scared of Turn, can't wait to trade him away.
Is there an easy way to search my name in the results document? Cause so far I only found myself after scrolling up and down, but I don't wanna do this every time the results get updated.
Anti team: -1 Jaehoon loss +1 Jaehoon Ace -1 Jaehoon loss in ace -1 M18M loss +4 Jaehoon win
Total: 2
Grand total score: 29 points as of November 29th.
The way I added it up I'm at 29 points at round 2's end, but the spreadsheet has me at like 25 points, so I should be around 35th place instead of 76th but maybe I'm adding something up wrong
Is there a way to check for a scoring error? Looking at my spoiler I believe I added it up correctly so far but it has me with 4 points less
On November 30 2010 05:39 pred470r wrote: Is there an easy way to search my name in the results document? Cause so far I only found myself after scrolling up and down, but I don't wanna do this every time the results get updated.
Anti team: -1 Jaehoon loss +1 Jaehoon Ace -1 Jaehoon loss in ace -1 M18M loss +4 Jaehoon win
Total: 2
Grand total score: 29 points as of November 29th.
The way I added it up I'm at 29 points at round 2's end, but the spreadsheet has me at like 25 points, so I should be around 35th place instead of 76th but maybe I'm adding something up wrong
Is there a way to check for a scoring error? Looking at my spoiler I believe I added it up correctly so far but it has me with 4 points less
I forgot to include by.sun's win, thanks. It's fixed on the master spreadsheet and this will be reflected in the next public update.
Anti team: -1 Jaehoon loss +1 Jaehoon Ace -1 Jaehoon loss in ace -1 M18M loss +4 Jaehoon win
Total: 2
Grand total score: 29 points as of November 29th.
The way I added it up I'm at 29 points at round 2's end, but the spreadsheet has me at like 25 points, so I should be around 35th place instead of 76th but maybe I'm adding something up wrong
Is there a way to check for a scoring error? Looking at my spoiler I believe I added it up correctly so far but it has me with 4 points less
I forgot to include by.sun's win, thanks. It's fixed on the master spreadsheet and this will be reflected in the next public update.
Thank you integral, honestly the amount of work you probably have to put into this is insane so I thank you so much for being so prompt with responses and changes <3
On November 30 2010 10:58 FuRong wrote: Sigh, as usual I'm getting destroyed by my anti-team =/
Main team +18 Anti team -15 already
Thanks for compiling all of this though, it must be a nightmare entering all the results.
Well, for starters, you have Roro on your antiteam. This is a bad idea regardless of how tempting it is. Trust me, I know from experience.
Have you seen Shine's recent record? It's pretty damn good. Despite what Bisu fanboys will have you think, he's a decent to above average player. There were other, far safer 4 point players.
As far as I can tell, Bogus isn't that bad a player. He's actually posted pretty consistent results throughout his career, so I'm not entirely sure why you picked him.
Shoulda spammed your anti with mediocre tosses now that Central Plains is out.
On November 30 2010 12:31 Cr4zyH0r5e wrote: Yeah My anti-team's points seem wrong too. Jaehoon loss +1 Jaehoon Ace -1 Jaehoon loss +1 snow loss +1 ggaemo win -4
Total = -2 // My anti says -6
There's something wrong with the calculations of one of those players... Also Grrrrr @ light and stork suddenly deciding to end their bad streak.
I added a Trade Info tab -- indicates total trade values for your main and anti-teams. This tab will be where your trades are tracked. Trades will open in another thread on TL after the end of R2 Week1.
The Team Scores tab now has adjusted trade values, trade values, costs, and other information.
I will update all four tabs after ACE vs Hite this evening, but will not likely be awake for KHAN vs KT.
I really gotta get rid of shuttle before he causes anymore damage I think, M18M started the night well for me with a loss, hoping for a chintastic victory next ^^
On November 30 2010 16:16 writer22816 wrote: SHIT google spreadsheets is blocked in china
Btw you are Rank 17 with 33 Points
Ooh thanks very much!
Although torproject appears to be blocked and vtunnel seems to have problems displaying the page. It just loads a blank page and stops, even when I have enabled javascript.
edit: now its working without a proxy now for some reason LOL
On November 30 2010 18:10 Garrl wrote: Why did I put Fantasy on my anti?
whoaaa bro why would you do that? ahah. i guess you only get better with experience, and there is certain players you learn to never anti, no matter how tempting. i.e. roro
-1 Jaehoon loss +1 Jaehoon Ace appearance -1 Jaehoon loss in ace -1 M18M loss +4 Jaehoon win
+1 Turn Ace appearance -1 Turn loss (told you he can't beat good players ;o)
Total: 2
Grand total score: 32 points as of November 30th.
*batman theme song*
self updateeeeeee
So, the spreadsheet seems to be updated but I don't know thru when. After adding in the scores from Samsung Khan v KT Rolster, I should be at 32 points now, the score sheet lists me with 30. It has my anti team score apparently correct, with an anti team total of 2 point to be subtracted from my 34 main team points (+4 for Stats win, -1 for Stork loss).
Not sure if there is an error, or the spreadsheet wasn't fully updated.
On November 30 2010 18:10 Garrl wrote: Why did I put Fantasy on my anti?
whoaaa bro why would you do that? ahah. i guess you only get better with experience, and there is certain players you learn to never anti, no matter how tempting. i.e. roro
Well, paying 6 points for a 6-3 player with no ace games seemed like a great idea - sure it's 20 points, but it let's you take actually bad players. With Bisu beasting it up and Best playing well enough to get his own ace appearances, I figured fantasy probably still wouldn't see ace based on his (well publicized) TvZ problems.
Of course, it looks like a terrible idea now, but it wasn't completely unreasonable based on R1.
I wouldn't have considered Fantasy just because he might not even play one game on some matches, with the depth that SK has, let alone aces.
wiht the current scoring format, you need to take advantage of all the bonuses you can, in this case, that is the +1 bonus for your player playing in the ace match
Stork was 4 points, Light was 4, Stats was 4, those are three players that maybe 40% of the time will play their teams ace match. Gotta take advantage of the situation where you can.
Updated, current to tonight's games. Any mistakes, please PM me.
I will create a thread for trades tomorrow. Trades will open when that thread is created, and close Sunday, December 5th, 13:00 KST. Please hold off on any trade-related questions until then, I will explain everything you need to know.
On December 02 2010 00:03 ZlaSHeR wrote: well I can deal with top 35ish for now, but man, that by.sun game was a killer, so close and if he had won it i'd be like top 10
I had Really on my Anti then I put Turn instead .. then I thought na screw it Pure gonna suck in R2... guess what -_- This bastard cost me 10 Points....
bisu not getting the ace in the 2nd game and fantasy winning it, and then bisu losing ace vs kal prolly costed me first place. Damn !!! Im still in there, horang2 fucked my anti, 8th place.
Integral -thanks for setting all this up and keeping track...I'm sure it is alot of work! If you need anyone to a) help with inputing information or b) coming up with ways to automate the spreadsheet to make updating the information easier please let me know, as I work in excel all day long (and love FPL!) :-)
The spreadsheet is fully automated already, actually, except for trades. The only work now is copying and pasting to a different spreadsheet and then sorting before I paste it to google docs. I can't sort it on the master spreadsheet because then my references screw up. I'm sure there's a better way to do this sort of thing but I'm pretty sure I'd have to use a database to do it. Regardless, thanks for the offer and I'm glad you're enjoying FPL.
On December 09 2010 06:53 integral wrote: The spreadsheet is fully automated already, actually, except for trades. The only work now is copying and pasting to a different spreadsheet and then sorting before I paste it to google docs. I can't sort it on the master spreadsheet because then my references screw up. I'm sure there's a better way to do this sort of thing but I'm pretty sure I'd have to use a database to do it. Regardless, thanks for the offer and I'm glad you're enjoying FPL.
Thanks for all your work! It does seem to have been a while since the last update, though (I'm waiting eagerly for my score to rise above 20 )
i might as well screenshot my 5th place here as this week has totally knocked me out of like the top 100. was good while it lasted!
aahah how sad is this: i almost wish there was a game to simulate FPL as many times as you want. a game about a game? ahah i guess they have it with the new nba games and what not, so it's so so bad, right?
On December 16 2010 12:20 AssiRoyal wrote: thx integral!!!
fuck yeah 7th :D
You're actually 5th, lol. You have to subtract two from your Row # since there are two header rows. I really should be adding a rank column to clear this up but I've been lazy lately, lol. whatever.
edit: nevermind I'm an idiot, I saw Anduril's box highlighted and thought that was yours. Yeah you're 7th.
On December 22 2010 04:52 dRaW wrote: WTF IS GOING ON!? SKT AND WOONGJIN been losing like crazy this season, stars are getting absolutely man handled in every set.
trying to let everyone else catch up! actually I think hite has been doing well and is solid #2 now...
There was a scoring error for everyone who had made a trade, I made a simple copy/paste mistake while updating the spreadsheet and it caused the cell references to be off by one column. Anyway, I've updated the results and standings accordingly. Sorry for any confusion.
lol this is by far the best I have ever done in FPL....although I can't be too proud, the pickings were not terribly difficult. There were some very clear cut over/under priced players this round o.O
On December 24 2010 16:48 ndralcasid wrote: lol this is by far the best I have ever done in FPL....although I can't be too proud, the pickings were not terribly difficult. There were some very clear cut over/under priced players this round o.O
It's obvious now that hiya was going to continue his slump and that turn was a one-round wonder and that stars is having an awful round and on and on, but that's just 20/20 hindsight. At the start when everyone was making their teams very few people were saying anything about poorly priced players. By looking at the numbers of who chose what, the only truly consensus pick for underpriced (that really panned out) was stork. For overpriced, there were two such consensus picks that panned out: perfectman and horang2.
It's easy to say that picking was easy this round when you do well for the first time, but that's just post hoc reasoning.
On December 24 2010 16:48 ndralcasid wrote: lol this is by far the best I have ever done in FPL....although I can't be too proud, the pickings were not terribly difficult. There were some very clear cut over/under priced players this round o.O
It's obvious now that hiya was going to continue his slump and that turn was a one-round wonder and that stars is having an awful round and on and on, but that's just 20/20 hindsight. At the start when everyone was making their teams very few people were saying anything about poorly priced players. By looking at the numbers of who chose what, the only truly consensus pick for underpriced (that really panned out) was stork. For overpriced, there were two such consensus picks that panned out: perfectman and horang2.
It's easy to say that picking was easy this round when you do well for the first time, but that's just post hoc reasoning.
I hear you on the Hiya thing. Can't believe I took him over Light, I'd be in first place if I had gotten that one right.
My hope resting on the potential of a Turn turnaround. All wasted.
A ~330th place is not too bad but I can't lie, I'm fairly disappointed. I want at least a Top 100 Finish next time. Should do better research and actually look carefully at some steals (missed Light @ 3 points).
With the official FPL for Round 3 confirmed by HOTBID. I just want to thank integral for all his hard work in fufilling our FPL hunger for round 2. Mad Props!
EPT![[image loading]](http://www.teamliquid.net/fantasy/proleague/Images/Banner.jpg)
my team has 0 points
)
