If you're trying to build a spreadsheet or program that estimates your valve and pipe weights/costs based on nominal size and pressure I don't think your results are going to be all that accurate. Valve costs/weights will vary considerably depending on type, trims quality level, and so on.You might try building and maintaining a separate database or spreadsheet with weights and costs direct from your vendors, then drawing your values from this into your estimating spreadsheet.