I've been tasked with reviewing the timesheet process in a 500 person company with a semi-mobile workforce. Vacation/Sick time is accrued monthly on an Exception Basis
, and is currently a managed with Excel timesheets emailed each month via Outlook to active employees, who email them back to regional timekeepers. The regional timekeepers update the accruals and drop the timesheets into network folders.
I'm a fairly good VBA developer and I can automate the steps in Excel and Outlook. I've written a routine that rips the data off each timesheet into a master spreadsheet so I can compare the total Vacation/Sick Accruals for the month to the aggregates in the submitted timesheets for the month. But a little voice in my brain keeps saying:
"...this should be on web forms with centralized data storage"
But i don't know other scripting languages. Although if I could do it in say less than two months I'll go for it. So If I were to attempt it...
2. Can I manage the process within the department or would I have to get the networking people involved to host the website and give me an instance of SqlServer or MySql on an enterprise server?
Are there any decent books you could recommend that use a timesheet project as an example?
thank you in advance