Coping Calculator for large steel pipes in Excel format

grabcad

This Coping Calculator is a handy tool that I use to create flat patterns for different pipes cuts, includes miter cut, pipes intersecting with variable angles or a pipe piercing through another pipe. The Excel spreadsheet includes all configurations with a graph/flat pattern that looks like a bell curve. Just input the diameter and wall thickness, or angle of intersection. Also included a Visual Basic (.dvb) program for Autocad that will take points from the Excel spread sheet and plot a flat pattern curve directly to Autocad. UPDATE! Curve data coordinates can be imported into Solidworks (instructions below). 1. Highlight & Copy X , Y , Z coordinates from Coping calculator spreadsheet. 2. Paste X, Y, and Z coordinates data into "Notepad" and save file (remember the name and location of saved file). 3. Open Solidworks, then open a new part (default template) and then click on insert > Curve > "Curve Through xyz points...", browse and select .txt file pull down. Select the previous saved notepad file and OPEN. 4. X, Y, and Z fields will be populated with coordinates in dialog box, Click OK. You're Done! The 2D bell curve will display in SW on the front plane.