Model Engineer Indexes
Model Engineer cross reference between year and Volume number
Engineer's Workshop Index and Engineering in Miniature Index
(Link to Colin Ushers web
Don't forget these files require a database program
to allow you to access the data. A number of people have used these
files to create on-line index searches. Use your favourite search
engine to find them.
This project started as a small attempt to index my own copies of M.E. There is not much point in having a collection of magazines if you can never find anything. As the files grew I found they became an essential tool to search out articles, helpful hints etc. They also showed the value of an organised storage system. Some of you may be lucky enough to have bound copies but if not find yourself some other way of keeping the mags in order. I use cardboard magazine files. Normally three volumes fit in each file so it is very helpful to mark each file with its volume numbers and years.
Contact with other model engineers both in
the UK and abroad proved that there was a need for a web based
electronic index. Various people have produced indexes before, on
paper, CD and available via email. As far as can be ascertained most
of these are now unobtainable or incomplete. Hence this web page was
started. Initially the files were an index of those issues of M.E.
which I had on my shelves. The records for the few missing copies
were kindly supplied by Dave Hoskin and some corrections added. This
was way back in 1998.
As time went on other people contributed
files and corrections and the links to Model Engineer's Workshop and
Engineering in Miniature files became available. Not all the new data
was compatible so we had to keep several different databases running.
Then along came Chris Orchard from Northamptonshire. He volunteered
to add in the missing volumes. No small job as there was about 120
volumes missing at that time. Not only has he completed that task but
he has also revisited all the original work to correct errors and
omissions and add in the things I didn't include like letters and
book reviews. This gives a consistent style
and content to all the files. A big thank you to Chris and also to
the Northampton SME Ltd for allowing Chris to use their library
copies of the earlier volumes to produce his files. Chris does not
currently have a web site but can be contacted on "chris at quiltedsteam.co.uk" (please substitute for the " at ").
ME Index Notes
The files are encoded as .ZIP archives. This makes the files much smaller but more importantly your browser is more likely to recognise the file type and offer to save rather than try to display the contents. Most home computers whatever the operating system should be able open the ZIP archive.
When the ZIP archive is opened the files are in comma separated ASCII text. Most databases can import this and a spreadsheet can also be used to view the files. They can be imported into a word processor but this will be a very unwieldy way of looking at them.
More recent spreadsheets can open the combined file. Older versions may have a 65,000 line limit and will need to use the individual files. You will have to import them as separate worksheets and search the individual sheets. Colin Usher is hosting the Excel version of these files on his site here together with several other index's.
Chris has provided some notes to assist those who wish to use the data files in Microsoft Access or Excel.
If you have Microsoft Access on your machine but are unsure how to use it to search these files have a look at this page.
I retain the right to be wrong and offer these files for personal, non-commercial use. You may copy and distribute them freely as long as their origin is acknowledged and no charge is made for them.
Copyright Notice:- Please note that the ME Indexes available from
this site are copyright.
All rights unless specifically released reserved Bill Phillips and Chris Orchard 1998-2017
This is also available as a comma separated file
(4Kbytes) for adding to your database or spreadsheet
and just to complete the set there is another comma separated file (86Kbytes) whichcross references the magazine number to its issue date
Return to home
Text Copyright © Bill Phillips 2017