Starting off the new year, I'd like to bring a bit more management to this shop, vs way to much ad-hoc re-invent the wheel each job. And one of the management pieces that I need to set up is a tracking system for drawing set submittals /issues. ATM, I take a snapshot of the dwg set using SSM to archive, ad file by date on the server. As far as knowing what went out when, that works for me -- as long as the bosses keep me informed.
What I think I need to set up for them is a spreadsheet that would provide a listing and record of every submittal or drawing issue, with the who-what-where-when-why information so whomever needs to know can look at the history of what went when, and have an idea f the current status of a job.
So my question to all y'all is has anyone set up something similar? suitable for admin, design, and engineers to use....