Morning, First off I'm 100% self taught in CAD so I don't pretend to have the expertience most of you probably do.
My ? may be fairly simple but I would appreciate some help. We use a product called Creform to produce carts, racks, stands.........basicly it is an erector set for adults. All kinds of various fittings with vinyl covered pipe form whatever it is you need.
When using it, if you want a length to be 36" long the pipe would be 31.750" because each fitting adds 2.125 to the length. Typically you would have a fittinfg at each end so 36"- 2.125 and 2.125 = 31.750". I would cut the pipe at 31.750, add the fitting at each end and end up with 36"OA.
I put together an Excel spread sheet that does the math for you but thought it would be cool if, when making a ACAD drawing of the fixture needed it just dim. the right pipe length from the gitgo. How do I make it dim. 4.250" off of the true length??
Thanks,

Are you asking how to do this in Excel then get the information into AutoCAD?

no, unless that's a good option. Everone that would be designing/drawing these fixtures has access to aCAD, so if I could create a drawing, w/this dim. option, I would just give it to all the other people in my dept.

Maybe it could be done with a custom lisp program.