Here's an excel file i found online which helps in finding dimensions of Butt welded, socket welded flanges, valves, olets and bolting. It also include Pipe thickness chart, pipe sizing chart and computed weights. It's quiet an old excel yet seems to be very useful for pipers. Here are some point about it:
1. Cells shaded in green denote component and piping weights. reducer weights are only for the size indicated.
2. Cells shaded in cyan relate to fig. 8/blank and spacer thicknesses.
3. No responsibilty will be accepted for any errors occuring from the use of the data obtained from this spreadsheet.
4. Future modifications/updates are planned such as inclusion of valve weights.