Get access to thousands of free CAD projects

Join our community of over 1,580,000 engineers and 540,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 11 months ago

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

  • Jay Rice
    Jay Rice 3 months ago

    I am trying to cope some 8" XS pipe as shown in the attached "cope.pdf". Would anyone care to share a few pointers with me? Advance thanks!

  • Tom Martin
    Tom Martin 3 months ago

    I think the obvious solution is offset the diagonal pipes so it doesn't intersect with the vertical pipe. Although if you must have this configuration of intersecting pipes then I would say the diagonal pipes you could use the spreadsheet to create 2 curves at 180 deg (not the 360 deg) one at 36.93 deg and the second at 53.07 deg then splice them together for a full 360 deg flat pattern curve. This is not easy but with a little attention to detail I think it can be done. Good luck!

Please log in to add comments.

Log in

Save Cancel