Printed from www.nzmeccano.com
Parts pricing information
A call for help
Hi all collectors and general trivia nuts...
I'm building a database of pricing information for the parts, outfits, and motors in the Meccano system over the years. When completed, we will be able to do all sorts of trick calculations if we so desire.
At the moment, I've entered a little data and created a very basic graph viewer which can show us the bare data. If you click on the part number in the "Parts table" on any part in the OPM, it will show a graph of the data in the system.
To see a graph of the parts prices, just view the following page (which is actually a picture), replacing the part number as desired -- here is the graph for the 11 ½" screwed rod:
This graph will appear in a new window. The grapher can also show more than one part at once. For example to show all the screwed rods on one page:
I hadn't realised, for example, that the three shortest screwed rods were always so much cheaper than the longest ones. Perhaps we can make some assumptions about the method of production on the basis of this.
The price graph blanks out at the end of production in January 1942. It doesn't restart until we have evidence of the part being available again on its own -- sometimes many years later.
Every dot on the graph indicates a known price list. There can be many dots in a line when the prices don't change.
The system can also show outfits, where the part numbers are prefixed by a capital O. Here's a graph of the prices of outfits 1 through to 6:
Well, I thought it was fun.
Now, in order to improve this graph, we need more data. The price information entered so far is from the following dates:
2810, 3503, 4101, 4111, 5002, 5010, 5207, 5404, 5409, 5502, 5506, 5510, 5602, 5702, 5802, 5812, 5905, 5907, 5912, 6004, 6102, 6108, 6204, 6301, 6305, 6309, 6505, 6509, 6601, 6701, 6901, 7002, 7305
In addition, we have limited (outfit only) information for the following:
4603, 4611, 4703, 4711, 4810, 4904
So, we need more! There are some price lists on the Gallery, and I'm sure we have more all over the place. Anyone fancy helping out?
What we need is a CSV file (a text file separated by commas) containing three columns:
- Part number
- Quantity (optional column, only needed if not each)
If anyone could help, it would be most appreciated. Note that if you're using a spreadsheet to create the data (recommended) you will need to change the second column to Text (select the entire column, choose Format/Cells/Text). This avoids it getting royally cross about pounds, shillings, and pence. You can enter in old pence or add shillings and/or pounds too. Or in new pence by appending a "p" to the end.
Save the CSV file as (for example)
6901.csv for January 1969, and email it to us on the "Contact Us"
link at the top of the page.
If you fancy a go and would like to help, find a price list that isn't listed above, and put a message below saying you're going to have a go at it. Then no-one else will duplicate the effort. Credits to everyone who has a go!
Total number of messages on this page: 9. This is page 2 of 2.
Martin Hanson (at 12:04pm, Sun 7th Nov, 10)
3711, 4806, 7701 and many earlier lists are in the back of Vol 6 should anyone be interested. The 4806 does have some blanks in it due to shortages though.
Martin Hanson (at 11:46am, Sun 7th Nov, 10)
I have done 6802, and have available 6804 which I intend to do. Everything else I have is already covered, apart from 6206 which is identical to 6204. I also have 6111, which I will do if there is any change from 6108 to 6204.
Charles (at 12:38am, Sun 7th Nov, 10)
Keith Burston has bagged 3110, 3211, 3503 fro Malcolm Hanson's gallery. Try going to the gallery and searching for Price Lists to find new ones. Make sure they're UK ones that we haven't already done, and post your intentions here...