CraftWEB Hot Glass Talk

CraftWEB Hot Glass Talk (
-   Color work from rods and batch glasses (
-   -   Spreadsheet additions? (

Paul Stout 11-09-2019 01:18 AM

Spreadsheet additions?
I've just put together a spread sheet for calculating L.E.C. (I know; its a guide not gospel) Is anyone willing to share any additional expansion values for things like strontium, or any other potentially useful ingredients, beyond what's listed in 'Modern Glass Practice' and 'Glass Notes IV'? Or have a suggestion of where to look for such additional values? Thanks in advance.
P.S. the original E&T values were published in 1927 in the Journal of the American Ceramic Society volume 10, pg. 551. It's a well written piece of history.

Pete VanderLaan 11-09-2019 11:19 AM

Look at Appen.

Josh Bernbaum 11-09-2019 10:15 PM

I think Dave Bross mentioned here somewhere that strontium and barium were very similar on expansion factor. So I've been entering the strontium in the barium line of the spreadsheet. How accurate that is, I'm not sure yet but is what I've been doing on the spreadsheet for these phosphates I'm doing now which have a decent amt. of strontium.

Dave Bross 12-24-2020 01:38 PM

Yup, what Josh said, I've got Barium at 1.40 and Strontium at 1.38.

One other you might not have, Phosphorous, P2O5, I have at .667

What's interesting to me is that as long as you're close, and you don't change the values for anything in the spreadsheet over time, your corrections getting to a match will take care of minor, and some major errors.

My opinion of the single most valuable aspect of a spreadsheet is in making those corrections to get a match with minimum tries.

Pete VanderLaan 12-24-2020 04:25 PM

that's interesting with the phosphate. It suggests a negative factor except that you can't just add P205. It needs to be attached to something which would throw the factor off. It is worth noting that calcium has a pretty low factor and that helps explain why one could add up to 5% cal phosphate without mismatch.

Of course then there are the ryolite stones.

All times are GMT -5. The time now is 04:13 AM.

Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd. Opportunity Network. 2008. All Rights Reserved.