Choose topics of interest…

RMG Magazine Index

A complete reference chart

The spreadsheet RMG Index is a comprehensive search tool for the entire history of RMG back-issue magazines*. In it is a chronological list of articles published throughout the history of the Guild from the first Newsletter dated October 1986 to the most recent issue. The work will be updated as new volumes appear, and/or improved from time to time as the project develops, including additional tabs with more information on various topics. This really is a “work in progress”!

* Note that not all historical volumes are currently available, however we are hoping to publish a complete set of second edition back issues over the next couple of years or so.

The spreadsheet is free to download by clicking here after which you can alter or amend it to suit your own needs.

The latest version is 1.2.

Instructions/Guidelines

To open the spreadsheet, you will need Microsoft Excel 97 or later, or other spreadsheet software that will open Microsoft Excel (.xls) files.

Hopefully, the following guidelines (which assumes no previous experience of spreadsheets) will help to de-mystify the logic, and assist you in deciphering the information to quickly find what you’re looking for…

At first glance, the spreadsheet looks a little daunting, but using the filtering options at the top of each column, you can narrow down your search very quickly and easily, using a wide range of criteria, to find any general topic or any specific item that you wish — or you can just browse through the entire listing at your leisure!

Categorising articles and models into specific genres is a little less straightforward than it might seem at first because there is often an overlap of different categories or a combination/choice of two or more! To cater for this, the chart includes several branches of categorisation to allow these blends to be considered.

Consequently, there is I am sure, a whole host of anomalies and mistakes to be found even though I have checked through it many times during compilation! 

If you do find any omissions or errors that you feel need to be corrected, please e-mail me with the details and I’ll take a look and reply either with an updated version or reasons for retaining the current data.

All constructive criticism and helpful suggestions will be warmly received.

Information Layout

Much of this is fairly self explanatory but I’ll cover all aspects of the chart anyway.

To begin with, there are two tabs labelled at the bottom, “Index 1-88” and “Article Categories”. (Figure 1)

These should be self explanatory:

To open either, just click on the tab label.  A few more tabs will be added later on — hopefully.

Looking at the main Index tab, and working across the top, you will see all the column titles. They may not all appear on screen, so scroll across using the scroll bar, to see the rest. (Figure 2) 

The column titles are ‘frozen’ so they should remain visible with the filter buttons at the top of your screen, even as you scroll down through the rest of the chart.

Column titles are as follows:

  • Issue No. — self explanatory
  • Month and Year — self explanatory
  • Article Content — the title of each article as it appears in the magazine
  • Page From and To — self explanatory (note that page numbers for each issue followed on in sequence up to volume 34 after which numbering reverted to page 1  to 60 (or there-abouts) for each issue.
  • Article Category — this is the first level of categorising and applies to all articles. For example, exhibitions, meetings, history, members, models etc.
  • Topic/Theme — the next level to search, for example, if you’re looking for exhibitions or meetings, where are they located. You might be looking for a genre of models, or a particular one built by a particular person. Start here — it might be vehicles, clocks, or Meccanographs etc.
  • Author — who wrote the article (as far as I’m aware)
  • Builder — who built the model (specifically featured in the article) (as far as Im aware)
  • Designer  who originally designed the model (as far as Im aware)
  • Other Credits  anyone else involved in the design or build project

The next group of columns highlighted in blue (Figure 3) relate specifically to featured models, and helps to fit them into one or more various categories:

  • Mobile or Static — seems obvious at first, but look again! A bridge would be static. A car chassis might be mobile if it actually moves along, or it might also be classed as static if it’s mounted on a stand or turntable? So both mobile and static could apply! Tricky!
  • Environment — where would the prototype operate — air, land, sea, space, or a combination of these?
  • Mode — What about land for example — is it for road, or rails, or all-terrain? Is it wheeled, tracked or walking?
  • Power — how is the prototype driven? Wind, water, steam, petrol, electric?
  • Power  how is the model driven? Hand powered, clockwork, electric* motor? (* This will later be expanded to include Direct Mains, Transformer, Battery, voltage required)
  • Type  e.g. a road vehicle could be a car, truck, bus, bike etc, etc.
  • Structures static models could be bridges, buildings, monuments, static cranes etc.

The next group of columns highlighted in green (Figure 3) relates to the nature of the written article:

  • Write Up — brief description or detailed explanation?
  • Instructions — is the construction of the model described in detail?
  • Photos and Sketches — are these included or not?
  • Series — is the article one of a series or parts?
  • News Cutting — is the article taken directly from a newspaper item?

Filtering

Each column has a filter button at the top. (Figure 4) You can use these to narrow your search for one column, and then continue to narrow it further from any other column/s.

To begin with, these all appear like the one circled green (not active) and the entire chart is on view.

A filtered column appears like the one circled red (active).

When you click on the filter button, (Figure 5) a drop-down menu appears listing the items included in that column which you can filter out.  You can either:

  • Un-tick the boxes of the items you don’t want to see, then click “OK”, or
  • Un-tick “select all”, then tick the items you do want to see, then click “OK”, or
  • Type in your search criteria in the text bar provided.

All un-ticked items will then be hidden (including the entire row they sit in), so the chart becomes much smaller and more manageable.

I suggest you dont hide the titles (as these are included in the drop down list) but its not the end of the world if you do.

Bear in mind that having filtered one column, the menu choices in the other columns filters may be reduced temporarily.

Undo filtering for any or all columns by ticking “select all” to re-gain the full menu range in each one.

The best way to get to grips with this is to just have a play and experiment. If it all goes horribly wrong, just close the application without saving it, and then start again.

As a last resort, you can always just download the original version again!

Any questions or difficulties, please feel free to contact me for answers.

Note — I am not an expert in Excel by any means and my knowledge on the subject is pretty limited! There is probably far more we could do with this project, and I am always open to education and suggestions.

Happy exploring!