Lantern Glass Reference spreadsheet

Hi everyone. This is what I have done so far, feel free to have a look.

This is a combined effort by me and a number of other members including Carpedien 1982, Sedgman plus others. I do not claim that this is finished but it includes all the data I was given or could find easily.

Issues/notes

The dimensions are in millimeters but I would like to add a macro to the spreadsheet that converts between the two systems at the press of a button. The problem with this is, no two globes are exactly the same size, even when they are meant to be. For instance, you will see 115mm 116mm and 117mm quoted when I suspect all these were manufactured and sold as the same size. The differences will be caused by the difficulty of making glassware cylinders that is always the same. That might be easy now, but in the past I'm guessing it was more based on skill and guesswork!

Apart from Coleman, there aren't many other US globes included as I didn't have access to any data. Now if one or more of you kind fellows in the States would care to get out your rulers... that would be great. Of course, we will still have the problem of conversion but it would still be best to have data.

There is no particular order to the spreadsheet - I did what I could based on what came in and how it was presented.

You will find gaps and when you do, send me the measurements (if you have them) and I will add what's missing.

If you have any suggestions about formatting or handy notes, let me know.

Regards
Colin

 

Colin,
Please check paper size and if option all columns on one page is selected.
Last pages of your pdf are the last column that should be at the right of each page. Also the pdf has extra empty "sheet pages".
Text on top of page 6 is falling of the paper at the left side.
I know that getting the format correct can be a pain in the a&s.

If I can help you know how to contact me.

 

I have these links for Coleman lantern globes one is how to date them the other is a chart for dimensions, all credits the website that published them .
Welcome to the International Coleman Collectors Club - International Coleman Collectors Club
Coleman Globe Data - Size Charts - International Coleman Collectors Club

 

I've had a look and I'll integrate any data I haven't got. Thanks for the heads up.

 

I have integrated the majority of the Coleman Collectors Club glass data and added the cone shaped glass for the 625 and the 275 plus variants.
Coleman lantern globes are now listed alphabetically.

Regards
Colin

 

Another day, another update.

The spreadsheet is now arranged alphabetically by manufacturer, then by lantern name/number.
I've added loads more globe models from various sources - thank you everyone - keep it coming
The PDF is in landscape mode for more clarity
The notes section is now the last column
I've added the manufacturers ID wherever possible.

Feedback and or more data on different lantern globes I haven't included is always welcome.

When new globe sizes dry up, I will implement an auto metric imperial conversion function.

Enjoy
CG

 

Here is the latest version. If anyone wants the ODF spreadsheet file, just ask me.

 

@ColinG A fine piece of work. One for my ‘Watched Threads’ file.

Thank you Colin.

John

 

Thanks, Colin.

I will have to measure up some odd sized Australian glass for the list.

Cheers

Tony

 

@ColinG
Well done, thank you!
Steven

 

I made a somewhat different layout of the file Colin has send to me. I made the header come back every page and manipulate the page ends so that brands stay together as far as possible.
We are not sure about the lines/grey layout. Let us know.

 

Thank you so much. A lot of work went into this!

 

Thank you... it certainly did and still is if I can get some more US made globe dimensions - AGM, Prentiss Webber, Thermos etc

 

Guys (and Gals), this is my start at the AGM section. So... there are just a few problem as you can probably see: Which models should I include, what are the dimensions and is there any rhyme or reason to AGM's naming convention? I've been told the the smaller models follow the same shaped glass as the Coleman 200, and the larger models are pretty much the same as the Coleman 220/228 type globes. More than this I'm hoping some of you can help with... please!

 

The spreadsheet is really involved lots of work. Excellent initiative.

 

Hi All.

This update has a couple of changes.

1. Ditmar has been renamed and is now in the correct alphabetical position with 2 added models - thanks @ROBBO55 . There's still plenty of measurements I don't have yet.
2. The AGM section has been added but as yet there are only 2 entries. Do you have an AGM you could measure?

Feel free to have a look. You might like to suggest some models that aren't included - with sizes if possible!

Regards
Colin

 

Hi @ColinG
Small correction
The petromax globes for 500cp an 350cp lanterns are 110mm in diameter. (not 98)

The China clone lanterns globes are 109mm in diameter.

Thanks for noticing.

 

Thanks @bp4willi for the updated information. I just checked my one and only genuine Petromax and compared it with an Anchor clone and they're the same. The correct dimensions have now been included.

 

Hi all.

For the time being, this will be the final lantern globe spreadsheet.

I have included as many AGM model dimensions as I can find or that kind folk have given me. Also, apart for a few exceptions, I have omitted mica globes as it's primarily a glass globe database, but there are a few.

In time I may add the imperial/metric conversion button.

If I can find a way of making the spreadsheet file available as a download, I will, otherwise the PDF will have to suffice.

Regards and I hope this proves useful.

Colin

 

Slight amendment - sorry about that!

 

Fixed some annoying PDF display problems that omitted some of the data. All fixed now.

 

Worth mentioning the two overall heights of Tilley 171s, also X359.

Alec.

 

Just to confirm, you mean the overall height of the 171 globe and that I should add the X359 to the list of models. I will correct these omissions and also add the main diameter of the 171 which is actually missing! I might add a nota about the deeper neck on early 171s.

Thanks Alec!

 

Update!

I have added some Tilley models, some Coleman models and amended the measurements of a Solar 350.

If anyone notices a measurement that doesn't seem right, particularly if you have that lantern yourself, let me know and I'll change it.

Thanks,
Colin

 

Butterfly globe... Must be very approx 110 dia x 100 high. ? -I'll need to take it apart to measure more accurately.

 

Butterfly:-
I've got three different variants for the lanterns of the same size.
First photo: from left to right, all cylindrical and clear:-
1. With Pyrex registered/USA.
2. Regular, bought from Lea Hin (possibly local/Malaysia / Singapore / Indonesia).
3. By Schott Glass, Germany.

All with slightly different basic dimensions:-
1. Pyrex, USA Registered, approx. 109mm diam. x 115mm height :



2. Regular Lea Hin, approx. 107..108mm diam. x 114mm height. :



3. Schott, Germany, approx. 109.5mm diam. x 116mm height.:



All measured using a Mitutoyo Digimatic vernier caliper. Code no. 500-197-30; model no. CD-8" ASX...but with shaky hands, rather blurry eyesight and likely measurement errors.

 

Here is the PDF version 07 is a slightly different format:

 

Thanks Myn, very helpful.

 

My Butterfly is a model 928. and as close as I can measure, the globe would be 115mm diameter, (maximum), by about 115mm height, straight sided.
The Lee Hin would fit I'd say. The Schott could work, the US Pyrex would fit too I think. There is a little bit of 'wriggle-room', but the diameter can't be much more than 115mm.

 

Thanks, @MYN and @Julian Whittaker, very helpful posts. As you have both demonstrated, the measurements of many 'standard' globes varies quite a lot so I have opted to show generic measurements because thats all i can really do.

Also, I have grouped most of the Petromax 'clones' together unless there are significant differences such as with the Solar 500. As i now have accurate measurements for Butterfly I may add them as a seperate entry... what do you guys think?