Creating Duplicate Rooms from excel sheet by counts

Revit
1

Hello,

I want to create unplaced rooms based on excel sheet, some rooms have quantity data (Workstation 8, Office manager 4 etc,)
the only was I found to do that is to duplicate identical room in excel as many times as quantity requirement but is a bit tedius

any help?

2

Bit confused by what you have and what you need. Can you post an attempt at a graph and a sample excel file and a screenshot showing where you want to get to?

3

Hi @attoshi

Could you show your excel?

4

image

5

List.OfRepeatedItems should do the trick. You will need to be careful with your levels though.

6

thanks Jacob, is it out of the box node? any sample graph?

7

Here is an example.

1 Like
8

@Kulkul pretty much just summed it up perfectly, as usual. :smiley:

9

The Dictiorary can help to answer those questions:
http://dictionary.dynamobim.com/#/Core/List/Action/OfRepeatedItem
And so does the Primer:
http://dynamoprimer.com/en/06_Designing-with-Lists/6-1_whats-a-list.html

10

Thanks Guys,

I’ll give it a try

11

Thanks everyone, it worked with minor tweeks

Capture
Capture.png4422×1396 284 KB