Coping Calculator for large steel pipes in Excel format

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 (instruction below).
1. Highlight & Copy X , Y , Z coordinates from Coping calculator spreadsheet.

2. Paste X, Y, Z coordinates data into "Notepad" and save file.

3. Open Solidworks, then click on "Curves button", then "curve through xyz points", browse and select .txt file pull down. Select saved notepad file and OPEN.

4. X Y Z fields will be populated with coordinates in dialog box, Click OK. Done! The 2D bell curve will display in SW on the front plane.

Tom, I can not thank you enough for sharing this Excel file. I am using the calculated X,Y positions for G-code on a CNC plasma pipe cutter. I had already written an Excel file to create the G-code using the concatenate function. I was also using 5 deg increments of rotation so your calcs fit exactly what I was using.

I have a question on the miter tab. I'm trying to use this for a 2" pipe at 90 deg (45 miter). I'm not sure I understand the X, Y and Z. At 90 deg the Y calc appears to blow up. I tried using the X and Z and this produces a cut which is close.

Thanks,
Dave Steffler