tipton5260
Mechanical
- Jun 1, 2009
- 5
I work for a small oil/gas company for down hole tools (drilling). A little over 50 people. We recently converted from Parts & Venders to DBA & use Activault for all SolidWorks drawings. Right now I upload all released drawings, ECR's & ECN's, and cover sheets in the item master in DBA. A Cover Sheets is simply a form that I staple on the front of a folder that shows the drawing number, description, ECR/ECN numbers, start & finish dates, designer/engineer & changes made on that part. So we can easily see all the changes on that one part but when looking at the whole assembly, we have to gather all the parts folders and look at each cover sheet & ECN's. Our top assemblies have many sub assemblies and we would like to be able to see all the changes that were made in the whole assembly without having to dig through paper work. They are not willing to spend any money on a program so Ive been trying to come up with an excel spreadsheet. Does anybody have any spreadsheets already made or know of any free programs I can use?
Example – Tool built 6 months ago ( at Rev A) comes back for servicing/upgrade. Meantime there have been several ECNs released for that tool type which is now at Rev D. We need a document / record that will show all the changes (including affected sub assemblies) that need to be incorporated to the tool back for servicing, to bring it up to current revisions.
Our cover sheets do not show changes made in the sub assemblies, only changes made on that particual drawing.
Thanks,
Rose
Example – Tool built 6 months ago ( at Rev A) comes back for servicing/upgrade. Meantime there have been several ECNs released for that tool type which is now at Rev D. We need a document / record that will show all the changes (including affected sub assemblies) that need to be incorporated to the tool back for servicing, to bring it up to current revisions.
Our cover sheets do not show changes made in the sub assemblies, only changes made on that particual drawing.
Thanks,
Rose