Inch-Diameter conversion to weights and lengths

Can anybody help with a method by which we can convert inch-diameter into a weight and lengths mto calculator (spreadsheet)?

So are you the purchasing guy and are trying to estimate shipping cost? ...Well if your really interested in getting "weights" then I suggest getting a piping book called "Navco Piping Datalog Book" ...Pittsburg, PA., USA ...they have just about every type of piping and with weight factors, so you can calculate the weights you're looking for.

No, I'm the Piping Designer on the job tasked with coming up with a conversion calculator / spreadsheet to convert inch-diameters to lengths of pipe, which in turn can be converted into weights.
Perhaps my question should be how to convert inch-diameters into inch-meters, which can then be converted back to lengths, from which I can calculate weights?

Well then I don't understand WHY you want to know what pipe weighs!?? Every MTO I have generated the pipe is indicated by size, schedule, material (carbon steel or what ever), and listed as a quantity in linear feet (so suppliers can change that value to "radium or double radium lengths") ...The weight of the pipe was/is not required. You can prove this to yourself by calling a supplier and ask for 1.75 tons of 10" pipe ...see what they tell you!??
However, "IF" you feel you still need "something" to generate a weight, then I would suggest you contact the structural group that deals with pipe supports, they have to calculate pipe weights for supports, OR maybe a manufacture and see if they have something to get the info your looking for, they would be interested in "weights". ...Good Luck!

Thanks Anton but no, that's not what I'm after.