Quick question... - A Suburbs Boy Living a Country Life
[My Flickr Photos]
For those of you that work for firms that require regular [e.g. weekly or monthly reporting], where indidual reports are edited and rolled-up into group reports, how do you do it?
I'm especially interested in any of you that use technology or automaion to solve this problem for a sizable work-force spread out in such a way that their only commonly available platform is their web-browser.
Current Mood: curious
|Date:||November 20th, 2007 05:55 am (UTC)|| |
Do you mean just timesheet reporting, or status reports as well? If the former, SlimTimer
works well. If the latter, then I second Owen's suggestion.
|Date:||November 20th, 2007 01:42 pm (UTC)|| |
I'll look at that.
I used to do this at Westat--but we were doing a lot of high level stats on the reports. We used SPSS data analysis software to manipulate the data, using the "tables" functions (you can use an aggregate function to "roll up" the data, if memory serves...) and then we'd export it into preformatted excel templates. I believe we'd use VBA macros in Excel to grab the correct data tables and pop it into the tables.
I know this is the wrong answer for today's environments but i would spend a day writing
an internal-only webapp to do it. Actually have written apps like that in a couple days.
|Date:||November 20th, 2007 03:22 pm (UTC)|| |
Send John an email, I know they do something, but not sure what... ?
Home grown internal application.