Liverpool FC Forum

[SouthCoastShankly]

I often get bored at work, on one of those occasions I spent the afternoon creating this spreadsheet that you can enter liverpool results and scorers and chart our progress throughout the year.

Note: for the scorer calculation to work the Surname entered next to the result section has to match exactly the spelling of the player surname on the squad list

Download:

http://www.filefactory.com/file/cec434/

[adamnbarrett]

how do you download the fecker?

[SouthCoastShankly]

there should be an option if you scroll down

[flipmode]

Whats the password to unprotect it?

[SouthCoastShankly]

why do you need to unprotect it?

[flipmode]

So i can update it with the goals etc

[SouthCoastShankly]

the sections you need to fill in are unprotected

[flipmode]

Ah i see nice one, this is very good.... I did a test in Charity Shield though put 2-0 to us in scorers one box i put gerrard, box next to it fowler.....On the scorers page gerrard had one but fowler didnt add on?

[flipmode]

Ah i see nice one, this is very good.... I did a test in Charity Shield though put 2-0 to us in scorers one box i put gerrard, box next to it fowler.....On the scorers page gerrard had one but fowler didnt add on?

[flipmode]

Also the sum of all column dosent add anything... or am i just ? LOL
Dont get me wrong im not complaining just thinks its a brilliant spread and would be great to work proper.

Props to the maker 

[SouthCoastShankly]

Your right.

Fixed version (also unprotected)

http://www.filefactory.com/file/b77d46/

[flipmode]

Excellent welldone mate

[SouthCoastShankly]

Thanks. Just goes to show boredom can be productive

[SouthCoastShankly]

I've improved it once again, this version will autosort the player goals table on the front page

http://www.filefactory.com/file/2acc56/

[azriahmad]

Well done, South Shanks...