Report for Labor Durations

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

Hi Luke,

Sorry just got a chance to try and then show an example below. So first grouping is by WBS, 2nd grouping is by Takeoff item. And then I filtered Cost Type to just Labor.

I exploded the remaining lines just to show an example of what it was doing, but really what I would try to do is collapse to the takeoff level if possible. . What I'm after mainly though is subtotals of those Crew Days shown by takeoff (e.g. Total Crew Days for "Stump Removal, 36" would tally .26 total). And then I'd like to get a subtotal for all of the crew days within a WBS category (e.g. Site Demo would add up to 2.21). And then possibly totaling all WBS categories together to ultimately get an estimated time for the entire project.

So I guess really what I'm trying to see is if there's a way to sum items at the assembly level?

hey jason, try taking out takeoff. and replacing it with item name. as long as your labour item names you want grouped together have the same name and are descriptive enough for you to decipher what theyre for, you should get exactly what you're after

you can put takeoff after item name if you want to be able to check for reference where they're coming from, but i would set the default expand level to item name and click to open as necessary.

Luke, OK that looks like it does give me the subtotal numbers per WBS correctly. Like you said, I would have to expand each item name to reference the actual takeoff. That's not completely ideal for me when I have a much larger project to sort through but can do for now. And I'm assuming there's no way to automatically total all the WBS categories for a total job duration that you know of? I'm also going to play around with making a quickly-formatted exporter that might be easier for me to play around with in excel.

Thanks I appreciate your help on this!

In your situation l, try putting your wbs category before cost type

Layer/cost type/category/item name/takeoff

Maybe I’m misunderstanding you. Sorry if I’m putting you through a loop

I think the confusion is that the takeoff doesn’t need to be in the group-by at all here.

The report should be able to roll those hours up by WBS independently. Just summarizing output differently.

See below, hopefully I'm not confusing you.

The Takeoff is actually what I would like it to group-by. The Item Name is actually irrelevant to me, however, the hours/crew days are actually calculated at the assembly item level (Item Name column). Those little bracket lines I drew would group the report by Takeoff, however I don't believe I can do it that way. As you said correctly, I have to group by Item Name first because grouping by Takeoff will only give me a subtotal of the measurement quantity.

The red stars are the subtotals of my WBS categories, these are correctly done. I wasn't sure if there was a way to add another row at the very top or bottom that adds up all the job totals. This particular example is very rudimentary however, usually there would be many more lines to add.

Are those takeoffs separate from one another in the takeoff window? if they are I don't think they can group together in the reports. My understanding is like named items will group together but not takeoffs. One solution could be to create a zero cost item with the same name as the takeoff or another custom property with all your takeoff names in it?

No, they're grouped together in the takeoff window. I guess it would be like adding another segment to one takeoff line.

Jason did the above solution work for you?

Stephen, yes, Luke's ideas did provide a way to get the information I needed. I will probably request a couple feature changes when I get a chance to look into it more, but for now it gets me what I need. Thanks!