Merlin Database on Excel

For all that relates to both Armstrong MT 500 and Harley Davidson MT 350
Post Reply
appyarry
Posts: 1479
Joined: Wed Jan 12, 2011 9:39 pm
Location: Lyminge, Kent.

Merlin Database on Excel

Post by appyarry » Mon Sep 17, 2018 11:44 am

I saw a post earlier today about getting a copy of the Merlin database. I followed the link and downloaded the pages and put them all into one Excel Workbook. It works well and I'm pleased with it.
I couldn't find the original post when I searched just now, so thank you to whomever posted the link to the sheets, it is very useful :-)
0 x
MT 604e :-)
Serveta Jet 200
Triumph Tigress 250
BSA C15 to be rebuilt as Scrambler
Sinclair Goddard PowerPak
Kalkhoff Endeavour 11 Speed Hub

appyarry
Posts: 1479
Joined: Wed Jan 12, 2011 9:39 pm
Location: Lyminge, Kent.

Re: Merlin Database on Excel

Post by appyarry » Mon Sep 17, 2018 12:51 pm

My bike details from the Merlin DB, it seems to have spent it's life with the Medics. Nice to have the details though.
I tried formatting it better but the forum doesn't allow the spaces.

erm keyno rivdate uin unit_title rivno rcpno rcpdate batch
25KL37 3 16/12/1993 CA005A JSCS ASHCHURCH CAPITA 1874AA 17/12/1993
25KL37 3 17/12/1993 CA005A JSCS ASHCHURCH DRSE 1874AA 17/12/1993
25KL37 4 05/08/1994 A0915A 24 ARMD FD AMB RAMC 8142A 1037 18/08/1994
25KL37 4 01/09/1999 A9043A UK FD AMB 037H/T 457H/T 12/09/1999 H/T
25KL37 4 05/02/2000 A0915A 24 ARMD FD AMB RAMC 150 201 15/02/2000 H/T
25KL37 4 28/06/2000 A3858A 3 MEDICAL REGIMENT 52 13 28/06/2000 H/T
25KL37 4 26/06/2003 A9118A THEATRE UK CS MED REGT 238 18 26/06/2003 H/T
25KL37 4 12/11/2003 A3858A 3 MEDICAL REGIMENT 128 809 12/11/2003
25KL37 3 30/04/2009 CQ710A WITHAM (SPECIALISTVEHICLES) LTD 28429 333 05/05/2009 A29
0 x
MT 604e :-)
Serveta Jet 200
Triumph Tigress 250
BSA C15 to be rebuilt as Scrambler
Sinclair Goddard PowerPak
Kalkhoff Endeavour 11 Speed Hub

User avatar
Laurence
Posts: 287
Joined: Thu Jun 18, 2015 1:43 pm
Location: Tunbridge Wells

Re: Merlin Database on Excel

Post by Laurence » Mon Sep 17, 2018 10:05 pm

Would you be able to do a search for my bike Phil?
0 x
..VFR 400..
..MT 350..
..Enfield Explorer..

Wirralman
Posts: 4841
Joined: Fri Jan 16, 2009 9:45 am
Location: Wirral, Merseyside

Re: Merlin Database on Excel

Post by Wirralman » Mon Sep 17, 2018 10:46 pm

Laurence wrote: ↑
Mon Sep 17, 2018 10:05 pm
Would you be able to do a search for my bike Phil?
Why don't you get in touch with MOD Abbey Wood ? Under the freedom of information legislation they will provide any information they have. In times gone by MT500 information had to be manually searched whereas MT350 information is computer based

I seem to recall a member complaining at the MT500 information cost, but with direct costs of filing, storage, retrieval, copying , postage, and re-filing documents plus indirect costs , it's easy to see how it mounts up
0 x

appyarry
Posts: 1479
Joined: Wed Jan 12, 2011 9:39 pm
Location: Lyminge, Kent.

Re: Merlin Database on Excel

Post by appyarry » Thu Sep 20, 2018 11:49 am

Laurence wrote: ↑
Mon Sep 17, 2018 10:05 pm
Would you be able to do a search for my bike Phil?
Yep, no problem, send/post me the number :-)
0 x
MT 604e :-)
Serveta Jet 200
Triumph Tigress 250
BSA C15 to be rebuilt as Scrambler
Sinclair Goddard PowerPak
Kalkhoff Endeavour 11 Speed Hub

User avatar
Laurence
Posts: 287
Joined: Thu Jun 18, 2015 1:43 pm
Location: Tunbridge Wells

Re: Merlin Database on Excel

Post by Laurence » Fri Sep 28, 2018 2:53 pm

appyarry wrote: ↑
Thu Sep 20, 2018 11:49 am
Laurence wrote: ↑
Mon Sep 17, 2018 10:05 pm
Would you be able to do a search for my bike Phil?
Yep, no problem, send/post me the number :-)
Cheers Phil!

GG 96 AA
0 x
..VFR 400..
..MT 350..
..Enfield Explorer..

appyarry
Posts: 1479
Joined: Wed Jan 12, 2011 9:39 pm
Location: Lyminge, Kent.

Re: Merlin Database on Excel

Post by appyarry » Fri Sep 28, 2018 5:52 pm

Laurence wrote: ↑
Fri Sep 28, 2018 2:53 pm
GG 96 AA
The details are as below. The formatting isn't good because the Forum doesn't allow spaces and TABs for formatting. If you have trouble working the columns out I could always send you a copy of the sheets in excel.



erm nsn asset_code contract_nu description colour holdin unit_title date_in_service chassis_no engine_no cast_i cast_date
GG96AA 2340998938379 NB10104105 LV2/067 MOTOR CYCLE GENERAL PURPOSE L/DIP 350CC HARLEY DAVIDSON NT 350GB/MIL Army/NATO Green IRR VEHICLE NO LONGER IN SERVICE 10/07/1996 IHD6RLT15TY000411 NA Y 30/03/2009

erm keyno rivdate uin unit_title rivno rcpno rcpdate batch_
GG96AA 3 09/07/1996 CA005A JSCS ASHCHURCH CAPITA 19709AA 10/07/1996
GG96AA 4 17/09/1996 A3721C 150RLC-217SQN 25369A 676 28/09/1996
GG96AA 4 06/11/2002 A0360A 10 FD SQN(AS) 39 ENGR REGT 12226 572 07/11/2002 T37
GG96AA 4 11/08/2003 A9122A UK THEATRE FD SQN RE AVIATION SP 69 211 24/08/2003
GG96AA 4 18/11/2003 A0360A 10 FD SQN(AS) 39 ENGR REGT 24 1184 28/11/2003 H/T
GG96AA 3 17/06/2009 CQ710A WITHAM (SPECIALIST VEHICLES) LTD 65119 1234 18/06/2009 01:00 A26
0 x
MT 604e :-)
Serveta Jet 200
Triumph Tigress 250
BSA C15 to be rebuilt as Scrambler
Sinclair Goddard PowerPak
Kalkhoff Endeavour 11 Speed Hub

Dave_S_MT
Posts: 81
Joined: Thu May 11, 2017 10:00 pm
Location: UK

Re: Merlin Database on Excel

Post by Dave_S_MT » Sun Sep 30, 2018 8:47 am

Just ran my little MT350 through the Merlin site

http://merlinarchive.uk/index.php

Main history:

Scottish Royal Logistics Corps,

Theatre Fleet Support Unit,

2nd Lancs,

2nd Battalion (2 Rifles).

Cheers :-)
0 x

User avatar
Laurence
Posts: 287
Joined: Thu Jun 18, 2015 1:43 pm
Location: Tunbridge Wells

Re: Merlin Database on Excel

Post by Laurence » Mon Oct 01, 2018 10:18 am

appyarry wrote: ↑
Fri Sep 28, 2018 5:52 pm
Laurence wrote: ↑
Fri Sep 28, 2018 2:53 pm
GG 96 AA
The details are as below.
That's brilliant thank you Phil! Learnt something new about my bike :D
0 x
..VFR 400..
..MT 350..
..Enfield Explorer..

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests