!!

Not Registered?

Welcome!  Please register to view all of the new posts and forum boards - some of which are hidden to guests.  After registering and gaining 10 posts you will be able to sell and buy items on our N'porium.

If you have any problems registering, then please check your spam filter before emailing us.  Hotmail users seem to find their emails in the Junk folder.


Thanks for reading,
The NGF Staff.

Author Topic: Spreadsheet  (Read 501 times)

0 Members and 1 Guest are viewing this topic.

Offline Dorsetmike

  • Trade Count: (0)
  • Full Member
  • ***
  • N Gauge Society Number: 2365
  • Posts: 2844
  • Country: gb
  • Gender: Male
  • Grumpy old fart
    • Skype
    • Awards
Spreadsheet
« on: May 13, 2017, 05:38:24 pm »
I have downloaded a spreadsheet (.xls) of SR shed allocations, it is sorted by loco number
columns for loco number, class, date and shed)

Is there an easy way to sort out all entries for one shed and copy to a new spreadsheet, I can "Find" all entries for a shed but so far it's a case of select the row (or sometimes consecutive rows) and copy/paste, it would make sense to me for there to be a way of having found all entries for "shed" being able to selecting all relevant rows and copy the lot with one command.

I'm using Libre Office.

My hope is that I can use the result to renumber locos to what would be allocated to that area.
« Last Edit: May 13, 2017, 05:40:04 pm by Dorsetmike »
Cheers MIKE


How many roads must a man walk down ... ... ... ... ... before he knows he's lost!

Offline Chetcombe

  • Trade Count: (0)
  • Full Member
  • ***
  • N Gauge Society Number: 21564
  • Posts: 1097
  • Country: us
  • Gender: Male
    • YouTube
    • Chetcombe on YouTube
    • Awards
Re: Spreadsheet
« Reply #1 on: May 13, 2017, 06:07:11 pm »
Not sure about Libre Office, but in Excel you can select 'data' then 'filter' then 'auto filter'. This puts a little down arrow on the header for each column, which if you click it will show the data entries included for that column. So for the shed column you can click on say 80A and only the rows that have that particular shed entry will be shown.

For this to work the spreadsheet must be formatted with the Column Name in the top row and the data being in all the subsequent rows. You may need to cut and paste the data or reformat the spreadsheet to make this work.

Good luck!

Online Buzzard

  • Trade Count: (+2)
  • Full Member
  • ***
  • Posts: 426
  • Country: england
    • Awards
Re: Spreadsheet
« Reply #2 on: May 13, 2017, 06:24:06 pm »
Rather than going down the spreadsheet route why not look at the information on these pages which are already sorted into shed order

http://www.semgonline.com/shed_allocations/sr-shed-alloc1.html

http://www.semgonline.com/shed_allocations/sr-shed-alloc2.html

http://www.semgonline.com/shed_allocations/sr-shed-alloc3.html

Offline njee20

  • Trade Count: (+1)
  • Full Member
  • ***
  • N Gauge Society Number: 22598
  • Posts: 2339
  • Country: gb
    • Awards
Re: Spreadsheet
« Reply #3 on: May 13, 2017, 06:25:01 pm »
Ctrl+shift+L is the keyboard shortcut to add filters in Excel, a lot of shortcuts are the same on Libre Office too, try it. Otherwise you're looking for a funnel symbol.

Offline Dorsetmike

  • Trade Count: (0)
  • Full Member
  • ***
  • N Gauge Society Number: 2365
  • Posts: 2844
  • Country: gb
  • Gender: Male
  • Grumpy old fart
    • Skype
    • Awards
Re: Spreadsheet
« Reply #4 on: May 13, 2017, 06:41:11 pm »
Buzzard, where do you think I downloaded the spreadsheet from ::)

Myself and another SEMG member started that off, other members kicked in whatever they could come up with and thus we compiled those shed allocation listings many years ago, somebody else then did the spreadsheets. They are not complete, we dredged the info from many diferent books and other sources, DL  Bradley's books providied me with most of the LSWR and early SR

I was just hoping for a lazy old man's way of getting the data I want extracted.
Cheers MIKE


How many roads must a man walk down ... ... ... ... ... before he knows he's lost!

Offline escafeld

  • Trade Count: (0)
  • Full Member
  • ***
  • Posts: 397
  • Country: 00
  • Gender: Female
    • Awards
Re: Spreadsheet
« Reply #5 on: May 13, 2017, 07:14:41 pm »
Can you just sort it by the sorted by SHED, loco number, class, date

Then you can cut and paste all of a shed allocation at a time as they will be sequentially in the spreadsheet. The rest of the sort will still be correct

Offline njee20

  • Trade Count: (+1)
  • Full Member
  • ***
  • N Gauge Society Number: 22598
  • Posts: 2339
  • Country: gb
    • Awards
Re: Spreadsheet
« Reply #6 on: May 13, 2017, 07:30:51 pm »
I was just hoping for a lazy old man's way of getting the data I want extracted.

And you've been offered it... filter, or just sort, and copy in blocks.

Offline CarriageShed

  • Trade Count: (0)
  • Full Member
  • ***
  • N Gauge Society Number: 24383
  • Posts: 2455
  • Country: ee
  • Gender: Male
  • Beechinged 1981-2013
    • Ebay
    • Twitter
    • The History Files
    • Awards
Re: Spreadsheet
« Reply #7 on: May 14, 2017, 02:16:34 pm »
I'll be happy to do any sorting and extracting for you, Mike. Excel is something I handle regularly at work so I'm pretty familiar with it. All data provided in plain XLS if that's what you prefer.

Offline njee20

  • Trade Count: (+1)
  • Full Member
  • ***
  • N Gauge Society Number: 22598
  • Posts: 2339
  • Country: gb
    • Awards
Re: Spreadsheet
« Reply #8 on: May 14, 2017, 06:37:37 pm »
Yep, likewise, sounds like the work of a few seconds if you want to ping it across.

Offline Dorsetmike

  • Trade Count: (0)
  • Full Member
  • ***
  • N Gauge Society Number: 2365
  • Posts: 2844
  • Country: gb
  • Gender: Male
  • Grumpy old fart
    • Skype
    • Awards
Re: Spreadsheet
« Reply #9 on: May 14, 2017, 08:29:17 pm »
Finished up doing it by using the SEMG sorted by shed lists, selected shed then highlighted the period and did a copy/paste into notepad, selected other nearby sheds, repeat as necesary.

Some locos that I have  were not shedded anywhere local a few can be justified, but that still leaves a few rule 1 endorsements on my Modellers Licence.
Cheers MIKE


How many roads must a man walk down ... ... ... ... ... before he knows he's lost!

 

Please Support Us!
November Goal: £55.00
Due Date: Nov 30
Total Receipts: £90.00
Above Goal: £35.00
Site Currency: GBP
164% 
November Donations


Advertise Here