Get access to thousands of free CAD projects

Join our community of over 1,220,000 engineers and 420,000 CAD files


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.


  • Tom Martin
    Tom Martin 10 months ago

    Doug, Since I'm short on time. Here is the short version, Autocad 2000 will work just fine.

    Step 1: Open up the excel spreadsheet (File: CopingPipeCalculator) and modify the input values as needed for your requirements.

    Step 2: Open up Autocad VBA manager dialog box. Load the file: "excel points to spline cuve.dvb"

    Step 3: Run 1 of 4 optional tabs (IE: Cope Template Variable Angle).

    Now you should have the 2D spline curve plotted on WCS in Autocad. Done!

  • Johnny
    Johnny 5 months ago

    Is the input data on pipe diameter ID or OD? Great work by the way!

  • Tom Martin
    Tom Martin 5 months ago

    Thanks Johnny, OD is the input, also the equations in the spreadsheet considers the wall thickness for the output data.

Please log in to add comments.

Log in

Save Cancel