John Litster's pre war spreadsheet available soon

The place to discuss Scottish football
Angusfifer
Posts: 89
Joined: Tue Sep 18, 2012 11:49 am
Contact:

Re: John Litster's pre war spreadsheet available soon

Post by Angusfifer » Tue Sep 18, 2012 12:03 pm

A quite remarkable power of work has obviously gone into this archive.

As a comparison I have put in a ridiculous amount of research into East Fife stats and am still missing one league starting line up (1.3.1922 away to Broxburn in case anyone just happens to have it kicking around somewhere :mrgreen: )...

BMCCOLL
Posts: 1051
Joined: Sun Oct 16, 2005 12:48 pm
Contact:

Re: John Litster's pre war spreadsheet available soon

Post by BMCCOLL » Tue Sep 18, 2012 1:08 pm

From the report I've seen, Neish was East Fife's 'keeper that day. I'm sure John could help you out with the one line-up, or failing that maybe Jim Corstorphine.
http://scottish-football-historical-archive.co.nf

Angusfifer
Posts: 89
Joined: Tue Sep 18, 2012 11:49 am
Contact:

Re: John Litster's pre war spreadsheet available soon

Post by Angusfifer » Tue Sep 18, 2012 5:05 pm

Aye, Jock Neish is the only player I have. I'm still hoping to check out the local Broxburn newspaper of the time one day. JC's line ups are incomplete as well I'm afraid...

Scottish
Site Admin
Posts: 7665
Joined: Sat Jun 11, 2005 4:51 pm
Contact:

Re: John Litster's pre war spreadsheet available soon

Post by Scottish » Tue Sep 18, 2012 11:23 pm

One other option might be to try Richard McBrearty at the Hampden Museum. They have the Scottish League's press cuttings collection from all national papers going back to 1890. Team sheets were also handed in by the ref but whether they have survived this long is another matter entirely.

sureitsza
Posts: 282
Joined: Tue Nov 18, 2008 10:13 pm
Contact:

Re: John Litster's pre war spreadsheet available soon

Post by sureitsza » Thu Nov 22, 2012 10:37 pm

Are the discs available yet?
I ordered the pre-war disc nearly two weeks ago but not received it yet.

bobby s
Posts: 806
Joined: Wed Jun 29, 2005 9:15 am
Location: Nittingrange
Contact:

Re: John Litster's pre war spreadsheet available soon

Post by bobby s » Fri Nov 23, 2012 12:22 am

Still waiting for mine too
It's the Hope I can't stand

Scottish
Site Admin
Posts: 7665
Joined: Sat Jun 11, 2005 4:51 pm
Contact:

Re: John Litster's pre war spreadsheet available soon

Post by Scottish » Fri Nov 23, 2012 12:40 am

Ditto but I'd expect mine to arrive later anyway. If someone can post when they receive theirs I'll know when to keep an eye out for the post.

prorege
Posts: 255
Joined: Mon May 21, 2007 4:59 pm
Contact:

Re: John Litster's pre war spreadsheet available soon

Post by prorege » Fri Nov 23, 2012 9:51 am

Both disks arrived today.

bobby s
Posts: 806
Joined: Wed Jun 29, 2005 9:15 am
Location: Nittingrange
Contact:

Re: John Litster's pre war spreadsheet available soon

Post by bobby s » Fri Nov 23, 2012 4:59 pm

Mine came today too, and the bad news is some spreadsheets have extra protection to stop you selecting cells to copy and paste. Might take a while to work around that, but I completely understand why it's incorporated.
It's the Hope I can't stand

Scottish
Site Admin
Posts: 7665
Joined: Sat Jun 11, 2005 4:51 pm
Contact:

Re: John Litster's pre war spreadsheet available soon

Post by Scottish » Fri Nov 23, 2012 5:49 pm

bobby s wrote:Mine came today too, and the bad news is some spreadsheets have extra protection to stop you selecting cells to copy and paste. Might take a while to work around that, but I completely understand why it's incorporated.
Select & drag to new sheet?

bobby s
Posts: 806
Joined: Wed Jun 29, 2005 9:15 am
Location: Nittingrange
Contact:

Re: John Litster's pre war spreadsheet available soon

Post by bobby s » Sun Nov 25, 2012 10:20 pm

That doesn't seem to work - at least for me, as you can't select any single cell. Not to worry, I've worked around it and had a quick look at what he's done for Hibs season by season.

Simply stunned at what I'm seeing. It seems to include virtually every single goalscorer in the league for 1893-1895, and a fair few variances from my research. I need to have a look through the detailed bibliography to see where I've gone wrong :shock:
It's the Hope I can't stand

Scottish
Site Admin
Posts: 7665
Joined: Sat Jun 11, 2005 4:51 pm
Contact:

Re: John Litster's pre war spreadsheet available soon

Post by Scottish » Mon Nov 26, 2012 1:01 am

PM me with the secret then so I can have a look when mine arrives.

Scottish
Site Admin
Posts: 7665
Joined: Sat Jun 11, 2005 4:51 pm
Contact:

Re: John Litster's pre war spreadsheet available soon

Post by Scottish » Mon Nov 26, 2012 2:37 pm

Arrived this morning. Can copy and paste no problem but can't sort data in new sheet even though no longer protected. Maybe it's something to do with Excel 2011 (was using 2004 before). Certainly the sort function looks very different.

bobby s
Posts: 806
Joined: Wed Jun 29, 2005 9:15 am
Location: Nittingrange
Contact:

Re: John Litster's pre war spreadsheet available soon

Post by bobby s » Mon Nov 26, 2012 3:00 pm

John must trust you!

I don't use sort - I use filters, I can't remember why though?

Have you tried selecting all the text and then selecting filter from the data menu? you can copy and paste filtered data.
It's the Hope I can't stand

Scottish
Site Admin
Posts: 7665
Joined: Sat Jun 11, 2005 4:51 pm
Contact:

Re: John Litster's pre war spreadsheet available soon

Post by Scottish » Mon Nov 26, 2012 3:33 pm

Cracked it. See PM

Post Reply

Who is online

Users browsing this forum: No registered users and 5 guests