Excel Timesheets


We use Excel spreadsheets for timesheets in a 500 pp company that are manually created, emailed and received by timekeepers each month. Is there a generally accepted better method using some combination of already deployed technology such as MS Outlook, Access, Sharepoint, Infopath or Sql Server?

DavisroBudget AnalystAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DavisroBudget AnalystAuthor Commented:
Let me be more specific...im interested in what other Established Developers have done to solve the timesheet application problem and built a process Using Excel or Access or VBA or Sharepoint or Outlook using their experience and their brain instead of apathy, leveraging existing technology and without bringing in yet another vendor in a market where everyone and their second cousin has a timesheet application for a fee.
DavisroBudget AnalystAuthor Commented:
And if anyone who reads this has dealt with the same issue...

I have extensively googled the topic and found almost nothing, and if anyone has written a technical article or blog comment, its buried in under hundreds of sales pitches for timesheet applications for about an average of $10 per month per employee

I've also poured through books on every technology I mentioned. Usually, a Microsoft MVP developer Hero has written something on a topic and i'm kind of surprised that i haven't found anything given how common this development request is. I did find a few mentions on the internet regarding Infopath and Office 365 web apps, and Microsoft Dynamics has a timesheet module that ships free with the product but the design isnt right for me because its project based and i need exception-based time and attendance reporting.

So I'm probably going to modify our existing Excel process using VBA to manage the tasks of checking the active directory, choosing the employees that need timesheets and emailing it to them, and then when they email it back, rip the values using ADO into a master spreadsheet for analysis and further processing.

But if there's another approach that anyone has successfully used I'm interested to know about it.
Robberbaron (robr)Commented:
like you we started with an Excel based timesheet.

we morphed this into an intranet app ASP.NET grid based app with an SQL backend,

 the big advantage is that the input screen looks very similar to the old one and therefore no big surprise for the users.

(developed in house by a Uni student)

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
SANTABABYSoftware ProfessionalCommented:
I have created a solution with Excel(formatted spreadsheet) for data entry and VBA code  and MS access as data repository. It works fine in a multi user (<50 users). In future there is a plan to migrate to ASP.Net with SQL Sever based implementation.
DavisroBudget AnalystAuthor Commented:
Thank you both for your responses. Exactly what i needed to know.

much appreciated
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.