Question on program for tracking spreadsheet edits

[mricks]

I work for a utility. We use a spreadsheet for meter design, no built in functionality just formatting. With our current process, the design sheet flows in this order: Marketing, Engineering, Measurement, Procurement, Operations, Billing/Collections. Currently, we have experienced some problems with projects falling through the cracks. I am looking for an approach that would allow someone to track the current status of all meter sets. Ideally, there would be a database or something with the active projects listed. Each time the next group performed their edits, email notification would be sent to the next in line and the database would be updated. It would be best if it could be automated as much as possible. Any ideas of what to use?

 

[IRstuff]

The only things I can think of offhand, are Bugzilla (

http://www.bugzilla.org/features/#email),

which is free, and DOORS, which is not. DOORS is also gross overkill, but its signature signoff mechanism does what I think you are describing. Likewise, Bugzilla's email notification process might do the same, but I haven't actually used that way.



TTFN
faq731-376

Need help writing a question or understanding a reply? forum1529