Liverpool FC Forum

by **SouthCoastShankly** » Fri Jul 28, 2006 1:38 pm

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/

by **adamnbarrett** » Fri Jul 28, 2006 1:41 pm

how do you download the fecker?

by **SouthCoastShankly** » Fri Jul 28, 2006 1:42 pm

there should be an option if you scroll down

by **flipmode** » Fri Jul 28, 2006 1:47 pm

Whats the password to unprotect it?

by **SouthCoastShankly** » Fri Jul 28, 2006 1:48 pm

why do you need to unprotect it?

by **flipmode** » Fri Jul 28, 2006 1:49 pm

So i can update it with the goals etc

by **SouthCoastShankly** » Fri Jul 28, 2006 1:52 pm

the sections you need to fill in are unprotected

by **flipmode** » Fri Jul 28, 2006 1:58 pm

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?

by **flipmode** » Fri Jul 28, 2006 1:59 pm

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?

by **flipmode** » Fri Jul 28, 2006 2:13 pm

Also the sum of all column dosent add anything... or am i just :censored:

? 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 :bowdown

by **SouthCoastShankly** » Fri Jul 28, 2006 2:18 pm

Your right.

Fixed version (also unprotected)

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

by **flipmode** » Fri Jul 28, 2006 2:27 pm

Excellent welldone mate :bowdown

by **SouthCoastShankly** » Mon Jul 31, 2006 2:21 pm

Thanks. Just goes to show boredom can be productive

by **SouthCoastShankly** » Mon Jul 31, 2006 2:51 pm

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

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

by **azriahmad** » Tue Aug 01, 2006 8:16 am

Well done, South Shanks...

Liverpool FC Forum

Lfc spreadsheet - If anyones interested....

Who is online