# Volume Report to Excel

**URL:** <https://forum.dynamobim.com/t/volume-report-to-excel/91942>\
**Category:** Civil 3D\
**Tags:** dynamo\
**Created:** [July 19, 2023, 2:07pm UTC](https://forum.dynamobim.com/t/volume-report-to-excel/91942 "2023-07-19T14:07:08Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![igor.carvalho](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/igor.carvalho/32/132582_2.png) [@igor.carvalho](https://forum.dynamobim.com/u/igor.carvalho)\
**Post date:** [July 19, 2023, 2:07pm UTC](https://forum.dynamobim.com/t/volume-report-to-excel/91942/1 "2023-07-19T14:07:08Z")

</div>

Good morning! I wanted to know if anyone in the forum already has a pre-made routine in Dynamo for Civil3D with the following function: I have some cross-sections of a corridor where I classify materials into three categories. Category 1 = soil, Category 2 = fragmented material between rock and soil, and Category 3 = rock, and finally, fill.

I need to export the volumes of these sections to Excel, similar to the attached Excel file. I am also providing the DWG file in case it’s needed for a better understanding. This is just an example; I would like to create the routine because I have several files with different corridors that require the same process. A Dynamo script would be very helpful, but I’m not sure how to get started.

 ![Captura de tela 2023-07-19 104553](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/8/4/84f643b1773df0390997c6297b81f1e24dd87a9d.png)  
 ![Captura de tela 2023-07-19 105024](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/5/4/54eb076f16416c77b5df73bd8bf60f32fc88cf29.png)  
[Pasta1.xlsx](https://forum.dynamobim.com/uploads/short-url/16LfQGyTpTmANfoNWqM3Y4WmTlZ.xlsx) (8.8 KB)

---

<div class="post-metadata">

**Author:** ![igor.carvalho](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/igor.carvalho/32/132582_2.png) [@igor.carvalho](https://forum.dynamobim.com/u/igor.carvalho)\
**Post date:** [July 19, 2023, 2:13pm UTC](https://forum.dynamobim.com/t/volume-report-to-excel/91942/2 "2023-07-19T14:13:38Z")

</div>

Sorry, I couldn’t attach the DWG file as it is too large.

---

<div class="post-metadata">

**Author:** ![omar.g](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/omar.g/32/146129_2.png) [@omar.g](https://forum.dynamobim.com/u/omar.g)\
**Post date:** [July 19, 2023, 6:08pm UTC](https://forum.dynamobim.com/t/volume-report-to-excel/91942/3 "2023-07-19T18:08:28Z")

</div>

Check out the Arkance Package. There is a handy node that pulls data from a Civil 3D table, like the volume data tables, into dynamo which can then be exported to Excel.

 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/a/e/aeb931e533e9b429b17bd4e29ef1076150d64b41.png)