Ive been tossing this around in my head for a while now and wanted to get some others input and suggestions. I know this has been discussed but when i search the forums nothing seems to come up for exactly what I'm trying to do.
First a quick description of what we do. Easiest way I can describe what the company i work for does is sublease floor space to clients. We rent an entire floor (building) then lease small pieces of it (10'x10') to clients.
So we have our "production" drawings which depicts our as-built floor plans at all times. When ever we get a client come in and ask for space we provide a design of where they are going to go. I take the "production" drawing and saveas to the clients name then draw in the new area within our site....If the client likes it and signs the deal, we then take that and pull in the "layout" back into the "production" drawing.
Upper management wants to be able to track what designs have been done and each revision as well as track which designs have become part of "production"
My thoughts
What I think would work best but am unsure how in depth this is...
I'm thinking I can redefine the close command to pull up a dialog box that asks certain questions and then takes those answers and places them into a respective excel sheet.
Example: When you try to close a drawing....
You are trying to close drawing xxx.dwg. Have you made any changes to this drawing YES or NO
Which type of order was this for?
* New Design Layout
* Revised Design Layout
* Pre- Approval
* Order Acceptance
* Updated As-builts
Please fill out the form below. (a lot of info can be auto-retrieved due to checking user loggin, folder name of drawing location, date.....blah blah blah)
________
________
________
So my three part question to you guys...
1. How difficult will this be and which route should I go...(vba, .net, other)
2. Does any one els have similar job tracking procedures
3. How do you track you time/jobs you work on.