I don't know if this will help you but I export wire lists to an Access database that has added fields for wireway routing, wire terminal type, and wire length. This goes to the panel shop for the prototype build, where they determine the exact lengths for each wire, based upon the order it is placed into the wireways. For mass-produced panels this information helps define a core wiring harness. They fill in the exact lengths as they wire the prototype. I get the database back when they finish. I have a menu choice in the database that totals up the exact footage needed for each wire type and cable type, and for each type of termination device. I can then do a cost analysis based on the going rate for the raw materials and determine whether or not the panel shop is making a fair profit or whether they might be padding it too much. I will not farm out to a panel shop that will not work in this fashion. This method helped reduce a $20,000 control panel down to $15,000.
Doug McAlexander
Design Engineer/Consultant/Instructor/Mentor specializing in
AutoCAD Electrical training and implementation support
Phone and
Web-based Support Plans AvailablePhone: (770) 841-8009
www.linkedin.com/in/doug-mcalexander-1a77623
Please
Accept as Solution if I helped you.
Likes are also much appreciated.