Hey @ElliotLeson, I noticed your final column called "% Utilization". Is this a calculated field, a calculated report column, or something else? If it's a calculation I'd be interested in knowing what fields you're using in your calculation.
I've been exporting an Assignment Report to Excel where I take either Actual Hours (if they exist) or Planned Hours (if no actual hours have been recorded)and divide by Duration x Full-Time Hours (which for us is 7.5 hours a day) to get resource utilization at the task level.
Something like this:
=(SUM(IF(ActualHours,ActualHours,PlannedHours))/(TaskDuration*7.5)
I'm curious what others are using.