Ring metal cost calculator

thingiverse

This spreadsheet will allow you to do a somewhat more apples-to-apples comparison of the value of metal used in a ring before you of to get it made. It doesn't take into account extra manufacturing costs but should give you a ballpark estimate of the raw material cost so you can make sure you aren't getting ripped off etc. Potentially very useful when combined with the following: Ring Creation Script http://www.thingiverse.com/thing:12448 Diamond size shape weight conversion Spreadsheet http://www.thingiverse.com/thing:12586 Ring Size System Coversion http://www.thingiverse.com/thing:12689 for costing a custom engagement ring or other such tomfoolery. Contains data for the following metals with Spot prices as of 2011-October-14 24kt Pure gold 950 Palladium 950 Platinum Fine Silver Tungsten Titanium Rhodium Copper Nickel Zinc 18kt Red Gold (75Au 25Cu) Est. 18kt White Gold (75Au 25Pt) Est. 18kt White Gold (75Au 25Pd) Est. 18kt White Gold (75Au 10Pd 10Ni 5Zn) Est. 14kt White Gold (58Au ~42Ar)** Sterling Silver (92.5Ar 7.5Cu) Est. Est. => Estimated minimum cost based constituent metal cost, actual cost is likely to be higher as the metals will have to be processed etc. to create the desired alloy Not suitable as a ring material for allergy, strength etc. reasons but may be used as an alloying metal **Actual 14kt White Gold Ni/Pd free formula is more like (58Au 40Ar 1.5Tin 0.5Ge) but hard to get prices for Germanium so assume it doesn't massively affect material cost due to its low concentration and presence of very low cost Tin Sourceshttp://money.cnn.com/data/commodities/http://www.coinnews.net/tools/live-silver-gold-platinum-spots/ xe.comhttp://www.metalprices.com/http://www.csgnetwork.com/specificgravmettable.htmlhttp://www.reade.com/Particle_Briefings/spec_gra.htmlhttp://www.clihouston.com/knowledge-base/composition-of-gold-alloys.html Instructions Open Spreadsheet in OpenOffice, Excel, whatever. Input the day's metal spot prices into the "metal pound cost [US$/0.454kg]" or "metal troy ounce cost [US$/0.031kg]" columns (links to sites used to find these are provided) Input the basic dimensions of your ring (Internal Diameter, Wall Thickness, Height or Depth, Feature Size)in [mm] 3a. Use one of the 4 provided ring cross sectional shapes (Rectangle, Ellipse, Pill shaped, Half ellipse) to estimate comparative metal value OR 3b. Create a column for your own custom shape and calculate the Cross Sectional Area, Circumference through centre of area and Rough Volume to generate a new column of estimate comparative metal value data Being forewarned and forearmed, you can now approach a metalsmith and choose a ring material with more confidence.