Command Palette

Search for a command to run...

Log In
  1. Insights
  2. Exports
  3. Capacity Export

Capacity Export

The Capacity export produces a CSV of each team member's billable capacity and the Services behind it — the downloadable version of the Capacity Report.

Finding the Capacity export

Head to the Exports page in Astalty. Click Create Export and select Capacity under the Users group, or go straight to Create Capacity export.

Creating the export

The export produces one row per Service assigned to a team member, with their Billable Target and Billable Capacity repeated on each row. A team member with no assigned Services gets a single row.

Optionally narrow the export before generating it:

  • Select Team Members — limit the export to specific team members.
  • Select Teams — limit the export to specific Teams, where Teams are enabled.
  • Select Regions — limit the export to specific Regions, where Regions are enabled.
  • Fallback to Primary Coordinator — when a Service has no Service Coordinator, count it against the Participant's Primary Coordinator instead, matching the Primary Coordinator Fallback setting on the report.

Enter a Reason if your account requires one, then click Create Export.

Downloading the export

You'll be taken to the Exports list, where you can click Download to save the file once it's ready. If the export takes longer than about 20 seconds to process, Astalty emails you once the file is ready.

Exported fields

ColumnContents
User IDThe team member's unique ID.
NameThe team member's name.
EmailThe team member's email address.
Billable TargetThe team member's billable target.
Billable CapacityThe hours the team member could bill each week, based on the funds and weeks remaining across their Participants' Services.
Participant IDThe Participant's unique ID.
ParticipantThe Participant's name.
ServiceThe name of the Service.
Amount RemainingThe funding remaining in the Service.
Hours RemainingThe hours remaining in the Service, based on the "Remaining Units" Charge Item selected when configuring the Service.
Weeks RemainingThe weeks remaining in the Participant's plan.
Hours Per Week RemainingHours Remaining divided by Weeks Remaining.
  • Capacity Report — the on-screen version, including the Primary Coordinator Fallback setting.
  • My Capacity Report — the personal version, scoped to Services you coordinate.