# Automatic pipe sizing in Revit using Excel and Dynamo

**URL:** <https://forum.dynamobim.com/t/automatic-pipe-sizing-in-revit-using-excel-and-dynamo/17150>\
**Category:** Revit\
**Tags:** dynamo\
**Created:** [December 6, 2017, 10:14am UTC](https://forum.dynamobim.com/t/automatic-pipe-sizing-in-revit-using-excel-and-dynamo/17150 "2017-12-06T10:14:59Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![mekanikist](https://avatars.discourse-cdn.com/v4/letter/m/e19b73/32.png) [@mekanikist](https://forum.dynamobim.com/u/mekanikist)\
**Post date:** [December 6, 2017, 10:14am UTC](https://forum.dynamobim.com/t/automatic-pipe-sizing-in-revit-using-excel-and-dynamo/17150/1 "2017-12-06T10:14:59Z")

</div>

Hello,  
I would like to make the sprinkler automatic pipe diameter. code I wrote, what mistakes are there? thank you

 ![Capture](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/6/a/6aa58705a28f4a8659e3b581003ca63c122c1a79.png)

---

<div class="post-metadata">

**Author:** ![jacob.small](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jacob.small/32/161030_2.png) [@jacob.small](https://forum.dynamobim.com/u/jacob.small)\
**Post date:** [December 6, 2017, 1:20pm UTC](https://forum.dynamobim.com/t/automatic-pipe-sizing-in-revit-using-excel-and-dynamo/17150/2 "2017-12-06T13:20:56Z")

</div>

What does the error message say on the excel.readfromfile node?

---

<div class="post-metadata">

**Author:** ![mekanikist](https://avatars.discourse-cdn.com/v4/letter/m/e19b73/32.png) [@mekanikist](https://forum.dynamobim.com/u/mekanikist)\
**Post date:** [December 7, 2017, 5:41am UTC](https://forum.dynamobim.com/t/automatic-pipe-sizing-in-revit-using-excel-and-dynamo/17150/3 "2017-12-07T05:41:47Z")

</div>

I destroyed the excel faults. I have to do pipecurves in the top categories, but I can not do it. Pipe does not merge excel file, only excel file.

 ![Capture](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/6/f/6f499613a577bb979db734d6887c682e14f4aba8.png)[asd.xlsx](https://forum.dynamobim.com/uploads/short-url/bq5BcO1hYHDSzd27u17WOENjFkc.xlsx) (9.9 KB)

---

<div class="post-metadata">

**Author:** ![mekanikist](https://avatars.discourse-cdn.com/v4/letter/m/e19b73/32.png) [@mekanikist](https://forum.dynamobim.com/u/mekanikist)\
**Post date:** [December 7, 2017, 5:46am UTC](https://forum.dynamobim.com/t/automatic-pipe-sizing-in-revit-using-excel-and-dynamo/17150/4 "2017-12-07T05:46:25Z")

</div>

No categories pipecurves. know how to find it

---

<div class="post-metadata">

**Author:** ![jacob.small](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jacob.small/32/161030_2.png) [@jacob.small](https://forum.dynamobim.com/u/jacob.small)\
**Post date:** [December 7, 2017, 6:25am UTC](https://forum.dynamobim.com/t/automatic-pipe-sizing-in-revit-using-excel-and-dynamo/17150/5 "2017-12-07T06:25:40Z")

</div>

Can you post the graph image after you run it, a copy of the .dyn file, and a simple Revit file to test on?

---

<div class="post-metadata">

**Author:** ![mekanikist](https://avatars.discourse-cdn.com/v4/letter/m/e19b73/32.png) [@mekanikist](https://forum.dynamobim.com/u/mekanikist)\
**Post date:** [December 7, 2017, 6:33am UTC](https://forum.dynamobim.com/t/automatic-pipe-sizing-in-revit-using-excel-and-dynamo/17150/6 "2017-12-07T06:33:28Z")

</div>

Thank you, I am sending

---

<div class="post-metadata">

**Author:** ![mekanikist](https://avatars.discourse-cdn.com/v4/letter/m/e19b73/32.png) [@mekanikist](https://forum.dynamobim.com/u/mekanikist)\
**Post date:** [December 7, 2017, 6:44am UTC](https://forum.dynamobim.com/t/automatic-pipe-sizing-in-revit-using-excel-and-dynamo/17150/7 "2017-12-07T06:44:35Z")

</div>

[5.yangın tesisatı çaplandırma.dyn](https://forum.dynamobim.com/uploads/short-url/oUr9caZ1EDVKxuPWiXRI2cnmltT.dyn) (12.8 KB)  
[asd.xlsx](https://forum.dynamobim.com/uploads/short-url/bq5BcO1hYHDSzd27u17WOENjFkc.xlsx) (9.9 KB)

[https://we.tl/52QIfbYDyU](https://we.tl/52QIfbYDyU)

---

<div class="post-metadata">

**Author:** ![cvc42100](https://avatars.discourse-cdn.com/v4/letter/c/a183cd/32.png) [@cvc42100](https://forum.dynamobim.com/u/cvc42100)\
**Post date:** [February 16, 2018, 4:49pm UTC](https://forum.dynamobim.com/t/automatic-pipe-sizing-in-revit-using-excel-and-dynamo/17150/8 "2018-02-16T16:49:32Z")

</div>

Hi,  
It is a very interesting script! But it stops on “Math.round” at home. ![Capture](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/d/c/dc77d0e6218b605485d73929552fc6fb6904b63e.jpg)  
It is my first hacking of node 🙂

---

<div class="post-metadata">

**Author:** ![gokhanozhim](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/gokhanozhim/32/40810_2.png) [@gokhanozhim](https://forum.dynamobim.com/u/gokhanozhim)\
**Post date:** [February 16, 2018, 5:49pm UTC](https://forum.dynamobim.com/t/automatic-pipe-sizing-in-revit-using-excel-and-dynamo/17150/9 "2018-02-16T17:49:45Z")

</div>

How will you do resize of pipe fittings ?

---

<div class="post-metadata">

**Author:** ![cvc42100](https://avatars.discourse-cdn.com/v4/letter/c/a183cd/32.png) [@cvc42100](https://forum.dynamobim.com/u/cvc42100)\
**Post date:** [February 16, 2018, 7:06pm UTC](https://forum.dynamobim.com/t/automatic-pipe-sizing-in-revit-using-excel-and-dynamo/17150/10 "2018-02-16T19:06:50Z")

</div>

Hi,  
I would like resize some diameters with pre-calculate to excel file ! Or resize with equation (formula Flamant : (0,25\*(square root(total FU (fixute units) ) .that 's it used in my country! But the last solution is too complicad for me on dynamo ! At the moment, I have the same file as the one of above topic !

---

<div class="post-metadata">

**Author:** ![mekanikist](https://avatars.discourse-cdn.com/v4/letter/m/e19b73/32.png) [@mekanikist](https://forum.dynamobim.com/u/mekanikist)\
**Post date:** [February 17, 2018, 4:39am UTC](https://forum.dynamobim.com/t/automatic-pipe-sizing-in-revit-using-excel-and-dynamo/17150/11 "2018-02-17T04:39:00Z")

</div>

I prepared a table based on the number of excited sprinklers. will vary according to the diameter corresponding to the number of sprinklers connected to this table.

---

<div class="post-metadata">

**Author:** ![mekanikist](https://avatars.discourse-cdn.com/v4/letter/m/e19b73/32.png) [@mekanikist](https://forum.dynamobim.com/u/mekanikist)\
**Post date:** [February 17, 2018, 4:40am UTC](https://forum.dynamobim.com/t/automatic-pipe-sizing-in-revit-using-excel-and-dynamo/17150/12 "2018-02-17T04:40:17Z")

</div>

There’s actually a solution on youtube. I prepared this dynamo by looking at that video but it is not working.
