Revit MEP

Revit MEP

Reply
Distinguished Contributor
abmeador
Posts: 394
Registered: ‎10-13-2006
Message 1 of 3 (261 Views)
Accepted Solution

R-MEP 2014 Schedule Using Loop Up Table to Populate Parameters?

261 Views, 2 Replies
08-21-2013 02:25 PM


I would like to know if it is possible to do this with a Space schedule:

I have a text parameter that someone will manually type in a number/letter combination into it.

I would like the schedule to go look at an Excel spreadsheet (aka a look up table .csv file like some of the pipe fittings use) and pull information in to populate various other parameters inside of the Space schedule.

Is this even possible?

We have a room code that tells us everything that needs to happen in that room (CFM's, Air changes, etc) and there is an Excel spreadsheet that contains all of that information. Instead of us having to hand type that information in, i would like to be able to pull it directly from the spreadsheet. Also I would want the Revit Space Schedule to update whenever there were changes to the Excel spreadsheet.

Thank you to any of ya'll that take a shot at this!!

 

 

Distinguished Contributor
abmeador
Posts: 394
Registered: ‎10-13-2006
Message 2 of 3 (223 Views)

Re: R-MEP 2014 Schedule Using Loop Up Table to Populate Parameters?

08-22-2013 06:17 AM in reply to: abmeador
So I have had a suggestion on how to do this, but have not tested it yet....
The suggestion was to use Schedule Keys and then use the Add-on Tool we have for Importing/Exporting information from Excel.
In order for stuff to be imported/exported it has to have a parameter inside the model already.
I"m not sure how the information will come back in...if it will be numeric or text, I'm hoping it will be based on the definition of the parameter b/c I will probably want to do some calculations or checks with those parameters.
I've got to test it though.
Distinguished Contributor
abmeador
Posts: 394
Registered: ‎10-13-2006
Message 3 of 3 (188 Views)

Re: R-MEP 2014 Schedule Using Loop Up Table to Populate Parameters?

08-27-2013 08:26 AM in reply to: abmeador

So I worked out a solution, it's not smooth and it requires a little leg work, but it works for what I need.

I would love to hear of other ways that might make this easier....

 

Btw...no schedule keys required!
Also, watch the cell formatting, it didn't want me to bring in "+" or "EX" values on one of my columns, it had to be a numeric value.

Another note: if you happened to copy/paste info down below the info on the Space Excel sheet make sure you Deleted the info along with Clearing Cell contents and deleting those rows/columns...otherwise you will get an error when you try to bring that back into Revit.

1) Create a Room Schedule that has the Room Name, Room Number, and Room Code from the Arch's model.
      Make sure the schedule linked files is selected
2) R/Export that room schedule
3) Open that room schedule in Excel
4) I have a template in Excel that does the look up information to another tab in the worksheet, I copy paste the info from the Room Schedule I exported into this worksheet, it populates a bunch of columns
5) Use the Imaginit Tool to Create an Export template for a Space that includes the desired items such as:
       ElementID, Room Code Manual (this will bring back the Room code from the Arch's model), Code AC, etc
6) Export the Project Data from that Space Template you made in the Imaginit tool
7) Open up the Info that it exported in Excel
8) Copy/Paste into the Space worksheet the info you gathered from the worksheet you used the Room Schedule on
9) Save the Space worksheet
10) Imaginit/Excel/Import Project Data with that Space info

 

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.