Budgeted vs. spent hours, etc.

Martin Pro

May 1. 2009. 10:05 am

We're putting the finishing touches on some tweaks that we need here at our company. One feature is to track budgeted vs. spent hours. I have extended the project object so that we now can assign a "budgeted hours" value to a project, and a "spent hours" value is calculated as users fill out their timesheets.

I've also added an additional progress bar so that when viewing project info, you can see both progress in terms of tasks completed, and in terms of hours spent.

If anyone is interested, I will write up some info on how we did wahtever we did (and I can show the code), etc.

-martin.

izooxman Pro

May 1. 2009. 11:06 am

#2

I am totally interested.

Labec Pro

May 1. 2009. 4:27 pm

#3

Very interested as well!

Martin Hložek

May 2. 2009. 3:11 am

#4

+1!

dilog Pro

May 2. 2009. 4:32 am

#5

me too, tnx :)

lcfeves Pro

May 3. 2009. 1:52 am

#6

I am very interested and would love any info you can provide. Thanks.

Parl Johnson Pro

May 3. 2009. 9:07 pm

#7

Hook me up!

Martin Pro

May 3. 2009. 11:01 pm

#8

Ok. I'll try to put something together this week (I'm traveling all week), and I'll see how I can post the code. The patch is not really difficult, but you'll end up touching a few files here and there.

The biggest prob right now is that our installation is running on our internal network, so I can't really show it "running". But I will find a way to at least show and explain the necessary code changes.

David Minton Pro

May 4. 2009. 12:59 am

#9

Sounds like a great addition. Are you trying to add some features similar to Tick:

http://www.tickspot.com/screenshots/ss_open-projects.html

Martin Pro

May 6. 2009. 11:28 am

#10

Yes, the feature is similar to "Tick". Curently AC shows % complete based on how many tasks have been completed. If 4 of 10 tasks are completed, then AC will show 40% complete in the progress bar, etc. I've added a progress bar (plus appropriate data fields etc.) that allows PM to assign a budgeted amount of hours (e.g. 100) and as users fill out their timesheets, I add up the hours and show spent hours in the bar and as a number.

As you know, one may have completed only 40% of the tasks, but already spent 55% of allotted hours. Our goal is twofold: a) use "actual vs. planned" to get better at time estimates, and b) be able to warn a customer when we get within X% of "budgeted" hours. Not all time-overruns are our fault ;)

Anyway, I'm traveling right now, but I have started the write-up on this and hope to post soon.

activeCollab

Demo

Tools

Community

Getting Started

Documentation

My activeCollab

Try activeCollab free for 30 days, No credit card required!