Retrieving unallocated time for a job/project

133 views
Skip to first unread message

Daniel Webb

unread,
Aug 16, 2018, 2:40:25 AM8/16/18
to Accelo
Hi,
I’ve already tried and failed support and the Accelo-community group, apologies for the cross posting, can anyone suggest a way to retrieve unallocated time?

Cheers
Daniel
On 10 Aug 2018, 09:57 +0100, Daniel Webb <dw...@cobwebb.com>, wrote:
Hi,
Is there a way to retrieve unallocated time for a project?

We have been using the project report xls export to calculate the number of hours of work we have outstanding (AKA Work in progress), which is a pretty important KPI for us.

However we have discovered that the unallocated time is not reported in the spreadsheet, so it is impossible to calculate the outstanding hours correctly for any job which has unallocated time.

We like to assign blocks of budget to milestones, then let the developers 'draw down' from those blocks into sub tasks which they create as they see fit. So for those projects:
Work in progress = hours remaining + hours unallocated.

This is also how it appears in the Insight tab of the project:


Hours budget: 100
hours: remaining: 50
Hours unallocated: 50
Therefore Work in progress = 50 + 50 - 0 = 100 hours

However the project report does not contain the unallocated time, so in the above example, we are currently calculating that there is only 50 hours of work in progress:

Hours budget: 100
hours remaining 50
Hours unallocated: not reported
Therefore Work in progress = 50 + 0(not reported) = 50 hours

Now ideally we'd like unallocated time added as a column in the report, but failing that, can we retrieve it from an api?

Best Regards
Daniel Webb / Managing Director

Cobwebb Communications Ltd

134 High Street / Tonbridge / TN9 1BB / UK / Registered in England No. 02029183 

Dave Donnelly

unread,
Aug 16, 2018, 12:48:46 PM8/16/18
to Accelo Developers
Daniel,

Thanks for reaching out to the Developers forum.  Unfortunately, it doesn't look like we have this field available in the API at this time.  

We can retrieve several fields regarding an Object's Budget, such as total budgeted time and total time logged, however we don't have a field for either Allocated time or Unallocated time on a budget.  More info here: https://api.accelo.com/docs/#object-budgets

I'll make an improvement request to our development team to potentially add this into the API under the Object Budget.  We will contact you here once implemented.

Thanks,
Dave


Daniel Webb

unread,
Aug 17, 2018, 2:32:17 AM8/17/18
to accel...@googlegroups.com
Hi Dave,
Thanks for looking into this issue, can I be extra needy and request you ask the devs to add unallocated time to the project report spreadsheet too? I really think it’s only been omitted by accident, it makes no sense to not have it there.

Regards

Daniel Webb

-- 'Work Smarter with Cobwebb Document Management'

Cobwebb Communications Ltd. | Website: http://www.cobwebb.com | Telephone: +44 (0) 1732 447 900 | Fax: +44 (0) 1732 365 604

Registered Address: 134 High street, Tonbridge, Kent, TN9 1BB. UK Registered in England. No: 02029183 | VAT Registration No: 374458817
--
You received this message because you are subscribed to the Google Groups "Accelo Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to accelo-devs...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Dave Donnelly

unread,
Aug 17, 2018, 12:27:23 PM8/17/18
to accel...@googlegroups.com
Daniel,

This request has already been sent to our development team, as indicated in your previous emails with our support team.

Thanks,
Dave

Daniel Webb

unread,
Aug 17, 2018, 12:48:57 PM8/17/18
to Accelo
Thanks Dave

Best Regards
Daniel Webb / Managing Director

Cobwebb Communications Ltd
T +44 (0) 1732 447 900 / M +44 (0) 7738 280 593

134 High Street / Tonbridge / TN9 1BB / UK / Registered in England No. 02029183 

On 17 August 2018 at 17:27, Dave Donnelly <dave.d...@accelo.com> wrote:
Daniel,

This has already been requested as indicated in your previous emails with our support team.

Thanks,
Dave

--
You received this message because you are subscribed to the Google Groups "Accelo Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to accelo-devs+unsubscribe@googlegroups.com.

Mahlon Duke

unread,
Sep 25, 2018, 1:51:33 PM9/25/18
to Accelo Developers
We're happy to confirm that Unallocated Hours has now been added to the Projects List's Extended export.  That number accounts for the total number of hours which have been budgeted for the Project, but have not yet been allocated to the Project's Milestones or Tasks.

Daniel Webb

unread,
Sep 27, 2018, 7:30:11 AM9/27/18
to Accelo
Thanks for implementing this, I can confirm that we are now getting "Unallocated hours" reported in our project export reports. This is great news, our outstanding work calculation is now consistent :-)

Best Regards
Daniel Webb / Managing Director

Cobwebb Communications Ltd
T +44 (0) 1732 447 900 / M +44 (0) 7738 280 593

134 High Street / Tonbridge / TN9 1BB / UK / Registered in England No. 02029183 

Thanks Dave
To unsubscribe from this group and stop receiving emails from it, send an email to accelo-devs...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Accelo Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to accelo-devs...@googlegroups.com.

Geoff McQueen

unread,
Sep 27, 2018, 8:35:30 AM9/27/18
to accel...@googlegroups.com
excellent!
Geoff McQueen
Founder & CEO


__________________________________________________________________________________________________________________________________________________________________________________________________

Daniel Webb

unread,
Sep 24, 2019, 11:35:29 AM9/24/19
to Accelo Developers
Hi, Happy anniversary to this request...

Has unallocated time been added to the API yet? We're so in need of this value for each project. Please add it in.

Best Regards
Daniel

Tim Edwards

unread,
Sep 30, 2019, 12:45:16 AM9/30/19
to accel...@googlegroups.com
Hi Daniel, 

As you may know, Accelo has revamped our Ideas Forum. Putting a post under the API section would be the best place to post to get the most visibility on this issue.
This way, we can track all user feedback in one place. To suggest a new idea visit ideas.accelo.com.

Regards,

Tim

--
You received this message because you are subscribed to the Google Groups "Accelo Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to accelo-devs...@googlegroups.com.


--
Tim Edwards
Developer

Daniel Webb

unread,
Sep 30, 2019, 3:30:52 AM9/30/19
to Accelo
Hi Tim,
Thanks for the reply but can you treat this issue as a bug to be fixed please? 

As I said, I think there's a strong argument that unallocated time is a key value of a project and it's absence from the API is not a feature, it's a bug.  

Best Regards
Daniel Webb / Managing Director

Cobwebb Communications Ltd
T +44 (0) 1732 447 900 / M +44 (0) 7738 280 593

134 High Street / Tonbridge / TN9 1BB / UK / Registered in England No. 02029183 

Geoff McQueen

unread,
Sep 30, 2019, 7:32:11 AM9/30/19
to accel...@googlegroups.com
Appreciate the desire for the feature, but the absence of a feature you want doesn't make it a bug.

Daniel Webb

unread,
Sep 30, 2019, 10:55:12 AM9/30/19
to Accelo
Hi Geoff,
I'll call it whatever you like if it gets it fixed :-)

There are currently 880 ideas listed. How many get added, removed, dismissed or implemented every week? Can we get some visibility?

All I know is that none of the 7 ideas we've submitted have seen any change. That's very demoralising.

 
Best Regards
Daniel Webb / Managing Director

Cobwebb Communications Ltd
T +44 (0) 1732 447 900 / M +44 (0) 7738 280 593

134 High Street / Tonbridge / TN9 1BB / UK / Registered in England No. 02029183 

Geoff McQueen

unread,
Sep 30, 2019, 11:00:18 AM9/30/19
to accel...@googlegroups.com
Hi Daniel,

This blog post from when we rebooted the forum a couple of months ago is the best place to go for more info: https://www.accelo.com/resources/blog/rebooting-accelos-ideas-forum/. We have a full time team member focusing on triaging and progressing the Ideas forum. Sorry none of your ideas have progressed past the idea phase so far, but we'll continue to review and categorize ideas based on popularity, impact, complexity to deliver and other factors on a daily basis.

Geoff

Daniel Webb

unread,
Sep 30, 2019, 11:17:59 AM9/30/19
to Accelo
Hi Geoff,
I like the ideas framework, and you deserve praise for building it, but if there's any activity I can't work out how to see it. The Number 1 item in the Hot list was last commented on in August.

"...this means that the Ideas Forum will not be a place where ideas go to die."

This is a really important goal of the ideas forum.

Please can we have a way to see what is happening with all these ideas? And please don't go asking me to post this request to the ideas forum :-)
 
Best Regards
Daniel Webb / Managing Director

Cobwebb Communications Ltd
T +44 (0) 1732 447 900 / M +44 (0) 7738 280 593

134 High Street / Tonbridge / TN9 1BB / UK / Registered in England No. 02029183 

Macks Schmeidler | Accelo

unread,
Sep 30, 2019, 6:18:46 PM9/30/19
to accel...@googlegroups.com
Hi Daniel!

It is my primary responsibility to manage the Feedback Forum, and I try my best to monitor all Ideas, Comments, and votes on a daily basis. As we make decisions on our roadmap and product priorities, I update the related suggestion's Public Status accordingly. As always, if you have any questions on a particular topic, feel free to leave a comment on the idea and I'm happy to help.

As Geoff stated above, there are several factors that we take into consideration when monitoring these ideas and comments. Again, this is not a place where ideas go to die! I monitor all ideas and interactions on the Feedback forum, so none will be forgotten ;)

Feel free to reach out to me on there is you have questions.

Cheers,
Macks


Macks Schmeidler
Junior Product Associate 



If you don't hear a reply from me within 24 hours, please send a message to sup...@accelo.com!



Daniel Webb

unread,
Oct 1, 2019, 4:57:54 AM10/1/19
to Accelo
Hi Macks, 
Good to make your acquaintance. 

I guess my main question is what is the best way of monitoring all the work that is going in the Feedback forum? 

Visibility would make it possible to understand the challenges and priorities you have, and how our priorities fit in.

Best Regards
Daniel Webb / Managing Director

Cobwebb Communications Ltd
T +44 (0) 1732 447 900 / M +44 (0) 7738 280 593

134 High Street / Tonbridge / TN9 1BB / UK / Registered in England No. 02029183 

Geoff McQueen

unread,
Oct 1, 2019, 8:23:51 AM10/1/19
to accel...@googlegroups.com
We publish updates every two weeks to www.accelo.com/resources/updates. Unfortunately UserVoice (the provider of the ideas system platform) doesn't seem to have a way to share data/analytics inside the platform, and we don't have the bandwidth to create our own reports beyond what we publish to our Updates blog - we're too busy focusing on making progress.

Reply all
Reply to author
Forward
0 new messages