Time sheets and managing projects... EEEK :(

something_totally_different

something_totally_different

something_totally_different

Associate
Joined
10 Oct 2007
Posts
1,165
Location
in the arse of england.
im trying to find a cheap and effective method of recording the time our employees spend on each project they do per day and to be honest im at a bit of a loss...

i looked for a pre built system but it was very complicated and at £1600 a year to record data for 3 people quite frankly it was a bit of a rip off.

all i need is something we can put a persons name into and a project code and the time they started and finished that project and then for me to be able to pool the data at the end of the month. any clues hints and tips are most welcome :)
 
Create an access database with all the fields you need in it and get them to fill it in. :)

Alternatively, setup a local LAMP server and get them to fill out a 'web' based form.

Or, get them to write it down and you fill in the details. :p

But, as you can see, a databased system is the one I'd go for.
 
I recently setup an MS Project Server but this may be a little expensive for yuor needs.

As suggested, LAMP is a good option.
 
WotDa said:
Linux, Apache, MySQL and PHP. :)

Might be a bit advanced for a small company mind you. :p
Click to expand...


you made my brain leak...


i think thats probably a little beyond me for the moment, im excellent with computers but 98% of what i know is hardware based as its the field i used to work in so my current jobs something of an education for me.

am having a crack with access, will post it up here when do for you all to scrutinize and laugh at. :p
 
Haha, that's uncanny. I've been working on a system for my office today and presented it this morning. I've done it in Excel, it's actually relatively simple to do. I've set it up so that they enter the time in minutes per day on each activity and it generates a monthly analysis of where their time is spent. Is that the sort of thing you want?
 
You just don't want to go much further than MYOB. Seriously cheap for what it does, has great practice management facilities and is a pretty well finished-off program. Two of my customers use it (about 15 - 20 using it simultaneously) and are highly impressed.
 
mks2005 said:
Haha, that's uncanny. I've been working on a system for my office today and presented it this morning. I've done it in Excel, it's actually relatively simple to do. I've set it up so that they enter the time in minutes per day on each activity and it generates a monthly analysis of where their time is spent. Is that the sort of thing you want?
Click to expand...

No more per hour charge on booking project work to clients.


I'd of thought Excel would sufice, with a copy of Project Standard if you want to make pretty layouts, or get a MS Dynamics setup, be pr0.
 
3 People ?

Simple Excel spreadsheet will be more than adequate. Dont bother spending money on alternative products.
 
siloleth said:
3 People ?

Simple Excel spreadsheet will be more than adequate. Dont bother spending money on alternative products.
Click to expand...
Exactly what I was about to say, Excel would be more than adequate.

If you want to pool the data at the end of the month, then make some fields only contain certain words/values which you can then easily search for in formulas.
 
For 3 people use Excel (or Access)

For future proofing you could use WAMP if you don't want the pain of LAMP.

www.wampserver.com

Windows Apache MySQL PHP! Dead easy to setup. Making a web based system to run on it may be a bit harder!
 
You must log in or register to reply here.
Back
Top Bottom