Skip to main content

It would be useful to have a button to export capacity planning data to an excel spreadsheet as some users requested to capture for reporting purpose

Totally agree—being able to export Capacity Planning data directly to Excel would make reporting and sharing so much easier. 
Also, if you haven’t already, I’d suggest posting this idea in the Feedback & Ideas section of the community. That’s the best place for the product team to track and review feature requests—and it gives others a chance to upvote and show their support too! Looking forward to seeing this one gain traction.


Yes, I ended up making a report that tries to duplicate the capacity planner - not interactive and there are some differences in the way that the allocaiton is calculated, but it works ok. It is a cross tab report. You have to create the report on the user and then pull in both Capacity and Labor time phase data, and then you can create a formula field called percent like this:

If( IsEmptyOrZero($CapacityOfUserMonthly.Capacity), 0, ($CapacityOfUserMonthly.LoadForMonthly.LinkObject.ProjectAssignment / $CapacityOfUserMonthly.Capacity) * 100)
 

 

But it is a little clunky and limited, and not as nice as capacity planner


Reply