# Cost takeoff (for positions without actual elements too)

**URL:** <https://forum.dynamobim.com/t/cost-takeoff-for-positions-without-actual-elements-too/98974>\
**Category:** Revit\
**Tags:** dynamo\
**Created:** [March 11, 2024, 9:10am UTC](https://forum.dynamobim.com/t/cost-takeoff-for-positions-without-actual-elements-too/98974 "2024-03-11T09:10:15Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Huettig](https://avatars.discourse-cdn.com/v4/letter/h/7ab992/32.png) [@Huettig](https://forum.dynamobim.com/u/Huettig)\
**Post date:** [March 11, 2024, 9:10am UTC](https://forum.dynamobim.com/t/cost-takeoff-for-positions-without-actual-elements-too/98974/1 "2024-03-11T09:10:15Z")

</div>

Hello there,

I aim to implement a cost takeoff in my already existing system to get quantities. Here I mostly calculate via dynamo scripts the quantity of elements and store them in parameters or export them straight to excel.

I searched in the forum and also found some very interesting videos from @GavinNicholls like:

[Preparing Revit models for takeoff](https://youtu.be/Ll9JvkUiGoA?si=u8wb8qbyUHv6E81c)  
and  
[Takeoff via dynamo](https://youtu.be/d54HoPH3T_A?si=6IYD-x-4QyMiU6FH)

Let me try to summarize it quickly:

- Add cost takeoff parameters to elements: “ABG\_TakeoffRate”,“ABG\_Cost\_Itemized” and Cost Group.
- Export Elements with new parameters
- Set Cost in Excel
- Calculate them via Dynamo
- Export

Looks super sexy. Sadly, on the way to implement this at multiple costs for a single element, the sexiness gets lost.

For example, rooms are used to store quantities of multiple elements that are not in itself modeled.  
They store values for sockets and toppings.  
This is not an individual case either. So, for those elements, I would need to add multiple unique parameters that are to be set individually.

The quantity exists. Cost needs to be set.

Then again, add logic for those parameters specifically.

Does anybody have a better idea for masses without actual modeled elements?

My process right now would be:

1. Including ABG Parameters
2. Set all element based costs
3. Set cost for not modeled elements individually
4. calculate ABG Cost
5. calculate individually
6. Export → again multiple parameters with multiple columns

---

<div class="post-metadata">

**Author:** ![Nick\_Boyts](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/nick_boyts/32/76313_2.png) [@Nick\_Boyts](https://forum.dynamobim.com/u/Nick_Boyts)\
**Post date:** [March 11, 2024, 2:09pm UTC](https://forum.dynamobim.com/t/cost-takeoff-for-positions-without-actual-elements-too/98974/2 "2024-03-11T14:09:04Z")

</div>

If I’m following your process correctly, your current plan is to export elements and parameters to Excel, set values in Excel, import back into Dynamo to calculate, then export back out to Excel. Why have Dynamo do the math when Excel is already great at it?

Instead, you could start with an Excel template file with a unit value sheet for setting all your material or unit pricing and lookup tables for item counts. You could then just export all your material and unit data to Excel in a standardized format where the values get automatically calculated. It would be more setup on the Excel side but would making scaling much easier. You also wouldn’t have to maintain unique parameters for each material/unit.

---

<div class="post-metadata">

**Author:** ![Huettig](https://avatars.discourse-cdn.com/v4/letter/h/7ab992/32.png) [@Huettig](https://forum.dynamobim.com/u/Huettig)\
**Post date:** [March 11, 2024, 3:20pm UTC](https://forum.dynamobim.com/t/cost-takeoff-for-positions-without-actual-elements-too/98974/3 "2024-03-11T15:20:54Z")

</div>

Yeah, that sounds a lot better. Will look into it. Sometimes you dont see the simple solution…  
My reasoning to do it in revit was to keep all information in the model. But yeah, one can just deliever the result. The quantity is there already.

Thank You

---

<div class="post-metadata">

**Author:** ![GavinNicholls](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/gavinnicholls/32/190442_2.png) [@GavinNicholls](https://forum.dynamobim.com/u/GavinNicholls)\
**Post date:** [March 11, 2024, 10:32pm UTC](https://forum.dynamobim.com/t/cost-takeoff-for-positions-without-actual-elements-too/98974/4 "2024-03-11T22:32:24Z")

</div>

I agree with Nick, no point in pushing data down only to pull it back up without the model serving a purpose towards it. I use this logic to deal with room data sheets for example where I work, the Lion’s share of the work comes from Excel with model based data coming via the model (e.g. room area, level, name).

If you end up using power BI look into table joining using ‘merged queries’ to interrogate multiple data sources of consistent structure. I’d focus on getting alignment in your Revit derived/excel based data and then that means you get the best of both worlds. It’s a bit beyond where my video ends up but definitely possible:

> **[Tutorial: Shape and combine data in Power BI Desktop - Power BI](https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data)**
>
> In this tutorial, you learn how to shape and combine data in Power BI Desktop

> **[Joining contents of two tables into one new table](https://community.fabric.microsoft.com/t5/Desktop/Joining-contents-of-two-tables-into-one-new-table/m-p/39775)**
>
> I have the Table A: Entidade\_ID LocOrgTrab\_CD Empresa\_ID Orgao\_CD Ano\_CD SiglaOrgaoF   Table B: LocOrgTrab\_ID LocOrgTrab LocOrgTrab\_CD LocOrgTrab\_DS LocOrgTrab\_SL Entidade\_ID   As can be noted in both tables I have the LocOrgTrab\_CD and...
