Click here to Skip to main content
15,891,248 members

Comments by Zachery Hysong (Top 8 by date)

Zachery Hysong 8-Apr-15 7:35am View    
I thought about that, but given the amount of time it takes to do it manually, compared to this way, we would have around $10,000 or more of extra scrap a year. That being said, What I am doing is exporting the file to CSV, then I am looping through a few arrays with PHP to accomplish this task. It is not the most elegant code, but it will work.
Zachery Hysong 7-Apr-15 10:46am View    
I'll try to explain a little better in a question edit. Please review the question above again. Thank you.
Zachery Hysong 7-Apr-15 10:36am View    
I would think that Excel very well CAN do this, but I don't know how to do it. Right now, I actually open AutoCAD and draw several lines at the full length of a tube we would buy, then I offset lines to see how we have to cut them to fit all the pieces with minimal scrap... I am not familiar enough with that type of math to know what to do.
Zachery Hysong 7-Apr-15 10:30am View    
I am thinking that maybe we are not on the same page... I have all the information I need, and I can move it and convert it as needed. What I am looking for is an algorithm of sorts to determine the information stated above. If what I have is not plausible, what would you suggest?
Zachery Hysong 7-Apr-15 10:14am View    
Well, I agree with you. But the decision to use Excel and AutoCAD or not is, unfortunately, not mine to make. That being said, All Excel is actually doing is converting the exported information from AutoCAD to a CSV File. Once it does that, I do the rest of it with PHP and JS/JQ. We have a plugin for AutoCAD called AutoAttribute that takes all of our custom tags and exports them to either an AutoCAD Table or an Excel Table. We have not been able to find any other plugin that works with AutoCAD and AutoCAD LT that comes close to this functionality. I am in the process of learning how to program for AutoCAD and LT, but until then, I am stuck with what I have. Do you have any suggestions that might point me in the right direction, within these parameters?