ianblenk Posted August 13, 2019 Author Share Posted August 13, 2019 10 minutes ago, 31A said: I like the use of 'random' to chose which locos to use! I tried to do that when I drew up my sequence for "Finsbury Square" but couldn't work out how to do it, using the Apple "Numbers" program rather than Excel. Hi Steve, It works OK, but it can be a bit tedious finding the loco and getting the train assembled, but it means most of the stock can have a run out and that 'favourites' aren't in use all the time. I pinched some of the ideas from John Elliot and Bradfield Square. I'm just trying to run the whole thing through and check for any bugs. The practicalities of having all the ancillary gear accessible, i.e. block bells, laptop and slave screen in places where they aren't in the way has been a problem, but once I have accepted the fact I won't be exhibiting it and need to provide shelving etc it became easier. Looking forward to the next instalment of Finsbury! Cheers Ian B 1 Link to post Share on other sites More sharing options...
RMweb Premium 31A Posted August 13, 2019 RMweb Premium Share Posted August 13, 2019 2 minutes ago, ianblenk said: it means most of the stock can have a run out and that 'favourites' aren't in use all the time. Looking forward to the next instalment of Finsbury! Cheers Ian B That's exactly the reason I wanted to do it, but inn the end I listed the locos in numerical order and rotate them every time I re-run the sequence which has the same effect but is becoming more predictable than I wanted it to be. Thanks, glad you like Finsbury, I'll try and find something else to report soon! Link to post Share on other sites More sharing options...
ianblenk Posted August 13, 2019 Author Share Posted August 13, 2019 https://exceljet.net/formula/random-number-from-fixed-set-of-options. You can use IF Then formula based on the cell in which the class of the train appears. So IF cell with train class equals 'E' THEN CHOOSE RANDBETWEEN from a table with the loco numbers in it.Takes a while to enter the data, but seems to work so far! It will regenerate each time you open the spreadsheet and if linked to access automatically update the display form IB 2 Link to post Share on other sites More sharing options...
RMweb Premium 31A Posted August 13, 2019 RMweb Premium Share Posted August 13, 2019 Thanks Ian, I'll give it a go! Link to post Share on other sites More sharing options...
ianblenk Posted August 20, 2019 Author Share Posted August 20, 2019 And so it begins, any guesses? Link to post Share on other sites More sharing options...
RMweb Gold 5BarVT Posted August 20, 2019 RMweb Gold Share Posted August 20, 2019 An 0-5-0? Sorry. I’ll just go. 2 Link to post Share on other sites More sharing options...
Mark Saunders Posted August 20, 2019 Share Posted August 20, 2019 Looks like the tender conversion to water tank? Mark Saunders Link to post Share on other sites More sharing options...
ianblenk Posted August 20, 2019 Author Share Posted August 20, 2019 1 hour ago, Mark Saunders said: Looks like the tender conversion to water tank? Mark Saunders See page 5, weedkiller tank built on J21 tender chassis 1 Link to post Share on other sites More sharing options...
ianblenk Posted September 29, 2019 Author Share Posted September 29, 2019 Some progress on A17 the Harton weedkiller. But, what was its livery before it was painted white? Answers on a postcard please Ian B 4 Link to post Share on other sites More sharing options...
ianblenk Posted October 10, 2019 Author Share Posted October 10, 2019 A few changes to Tynebank, swopped Harton Line and B.R. Staithes lines around. Some snaps. Had to use the drone for the second one! Making progress with the weedkiller, alas had to smoke another cigar. 11 Link to post Share on other sites More sharing options...
ianblenk Posted October 11, 2019 Author Share Posted October 11, 2019 Seen today at Tynebank; K1 removing empty minerals from Harton System. Checking platform clearances for DP1 The behemoth 14 Link to post Share on other sites More sharing options...
ianblenk Posted October 11, 2019 Author Share Posted October 11, 2019 Derby Lightweight on South Shields Sunderland stopper via The Coast. Next stop Marine Park 13 Link to post Share on other sites More sharing options...
Toftwood Posted October 29, 2019 Share Posted October 29, 2019 On 22 July 2019 at 07:54, Ian Blenk said: Lost Just as I remember them, on the Tynemouth loop but a lot cleaner than in service! Is this a kit or conversion? Pete 1 Link to post Share on other sites More sharing options...
ianblenk Posted October 29, 2019 Author Share Posted October 29, 2019 It's a Dave Alexander kit I bought on a well known auction site. I have an unmade one, it was my intention to use this to produce the single car DMBT No E29238E. But, to be realistic it is unlikely that this will happen. I've also drawn up cutting plans for the Silhoutte for the N.E.R. parcels car in it's de-icing incarnation, again I wonder if I'll get round to it! i am however building some non-revenue earning stock for the Harton part of Tynebank. I'm also pleased to say that Tynebank is just about complete with only a few 'touch up' bits and pieces to do, who knows I may get an exhibition invite! 6 Link to post Share on other sites More sharing options...
ianblenk Posted October 29, 2019 Author Share Posted October 29, 2019 And for no good reason; 4 Link to post Share on other sites More sharing options...
ianblenk Posted October 29, 2019 Author Share Posted October 29, 2019 5 Link to post Share on other sites More sharing options...
Toftwood Posted October 29, 2019 Share Posted October 29, 2019 1 hour ago, ianblenk said: It's a Dave Alexander kit I bought on a well known auction site. I have an unmade one, it was my intention to use this to produce the single car DMBT No E29238E. But, to be realistic it is unlikely that this will happen. I've also drawn up cutting plans for the Silhoutte for the N.E.R. parcels car in it's de-icing incarnation, again I wonder if I'll get round to it! i am however building some non-revenue earning stock for the Harton part of Tynebank. I'm also pleased to say that Tynebank is just about complete with only a few 'touch up' bits and pieces to do, who knows I may get an exhibition invite! As Secretary of Thetford, Suffolk, Club I would invite you to our Exhibition next year but thats not up to me unfortunately, bit far to come for a day as well! Have been following this thread since you started. Great work. 1 Link to post Share on other sites More sharing options...
SteamAle Posted October 29, 2019 Share Posted October 29, 2019 5 hours ago, ianblenk said: It's a Dave Alexander kit I bought on a well known auction site. I have an unmade one, it was my intention to use this to produce the single car DMBT No E29238E. But, to be realistic it is unlikely that this will happen. I've also drawn up cutting plans for the Silhoutte for the N.E.R. parcels car in it's de-icing incarnation, again I wonder if I'll get round to it! i am however building some non-revenue earning stock for the Harton part of Tynebank. I'm also pleased to say that Tynebank is just about complete with only a few 'touch up' bits and pieces to do, who knows I may get an exhibition invite! Link to post Share on other sites More sharing options...
SteamAle Posted October 29, 2019 Share Posted October 29, 2019 Well we still have room for you next month in the demo class! Link to post Share on other sites More sharing options...
ianblenk Posted October 30, 2019 Author Share Posted October 30, 2019 7 hours ago, SteamAle said: Well we still have room for you next month in the demo class! I can demo building an ARP box for South Gallions? Link to post Share on other sites More sharing options...
dasatcopthorne Posted October 30, 2019 Share Posted October 30, 2019 (edited) 23 hours ago, ianblenk said: It's a Dave Alexander kit I bought on a well known auction site. I have an unmade one, it was my intention to use this to produce the single car DMBT No E29238E. But, to be realistic it is unlikely that this will happen. I've also drawn up cutting plans for the Silhoutte for the N.E.R. parcels car in it's de-icing incarnation, again I wonder if I'll get round to it! i am however building some non-revenue earning stock for the Harton part of Tynebank. I'm also pleased to say that Tynebank is just about complete with only a few 'touch up' bits and pieces to do, who knows I may get an exhibition invite! Any idea who's photo this is please. I am wondering whether they ever took a photo of the BR Parcels car at the same spot so that I can confirm the conduit arrangement over the Guard's compartment. Dave. Edited October 30, 2019 by dasatcopthorne Link to post Share on other sites More sharing options...
ianblenk Posted October 30, 2019 Author Share Posted October 30, 2019 Sorry I don't know who took the photo, it was in a box of local (Tyneside) snaps I bought at a card fayre some years ago. All it has is 'Little Benton' on the back. I believe the consist is running from Walker car sheds to South Gosforth. Ian B 1 Link to post Share on other sites More sharing options...
ianblenk Posted October 30, 2019 Author Share Posted October 30, 2019 18 hours ago, SteamAle said: Well we still have room for you next month in the demo class! Sorry Phil you didn't mean bring Tynebank did you? I could put South Gallions on display behind the demo bench Getting panicky now. Ian Link to post Share on other sites More sharing options...
SteamAle Posted October 31, 2019 Share Posted October 31, 2019 Ian Don't mind what you bring as long as it is yourself! Plenty of space for you display things, just let me know how much you want. Philip Link to post Share on other sites More sharing options...
ianblenk Posted November 6, 2019 Author Share Posted November 6, 2019 9Fs passing at Tynebank 12 Link to post Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now