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!) :-)

Just send me a PM.

Thanks ofr all the work!

integral

United States3161 Posts

December 08 2010 21:53 GMT

#90

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.

OpticalShot

Canada6330 Posts

December 13 2010 20:05 GMT

#91

Highly anticipating the next update, Stork > Soulkey should have given me a significant boost!

]343[

United States10328 Posts

December 15 2010 04:52 GMT

#92

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

)

integral

United States3161 Posts

December 15 2010 05:39 GMT

#93

Yeah guys I was sick all last week and didn't feel like doing anything at all. I will update everything and trades will be open tomorrow morning.

GG_NO_RE

Japan238 Posts

December 15 2010 12:21 GMT

#94

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?

smileyyy

Germany1816 Posts

December 15 2010 12:28 GMT

#95

Yeah my Anti raped me hard this week reaally. I earnt like -12 points :D

integral

United States3161 Posts

December 16 2010 03:17 GMT

#96

Updated! Sorry for the delay, guys.

Also, trades are now open until Saturday December 18th, 13:00 KST.

AssiRoyal

Germany216 Posts

December 16 2010 03:20 GMT

#97

thx integral!!!

fuck yeah 7th :D

integral

United States3161 Posts

December 16 2010 03:22 GMT

#98

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.

I need some sleep.

FuRong

New Zealand3089 Posts

December 16 2010 03:35 GMT

#99

I don't completely understand the new spreadsheet.

Isn't "trade score differential" just there to show whether your trades have been profitable or not?

Why is it being added to (or in this case subtracted from) my points total?