Q & A
Jason Ramsey Report for Labor Durations
Does anyone have any tips to format a report so that we can visualize labor hours (or crew days preferably) per WBS section? This would help to develop a preliminary schedule or provide an owner/contractor a quick glance at on estimated timelines at bid time.
As said, we report labor assemblies per Crew Days. I would like a report that shows totals for all takeoffs within a WBS. For example, say I have 6 takeoff measurements within my Site Demo WBS category (asphalt demo, fence removal, clearing & grubbing etc). I want to see the total of those 6 measurements to show 8.3 total crew days for Site Demo. And then I'd like to see a subtotal of total crew days for the entire job. I'm not sure if there's a way to filter for that?
Not sure if this would break something else you’re trying to do but I’ve changed the way I do my labour so it’s calculating hours output at all times and cost each is the labour rate so everything in my labour cost type shows in hours so yes it will total that for me if I have cost type in my group by
for example for a linear my formula is
[Linear:FT] / ([production Rate] /8)
cost each is labour cost per hour then output units is hours.
still get a total labour cost and price but also get hours totals
I use auto name at the takeoff level so I can make my labour item title text with tags. then I can still show production rate in takeoff name even if I change it
ex. [production rate]fpd
Hi Luke, thanks for replying. Let me try to clarify. I'm definitely able to get total labor hours per takeoff measurement. However, I am looking to subtotal total hours per WBS. So there will be say 6 takeoff line items under one WBS category (Sanitary for example). So I have takeoffs for excavation, backfill, pipe install, manholes, cleanouts, etc. Each of those obviously shows a labor time per takeoff in the canned reports. What I'm looking for is a total of those takeoffs combined.
Hi Jason, have you tried using the wbs property into your group by
cost type then the wbs category then item name should work