Good morning. I am using Revit Arch 2011. I am trying to pull information from a schedule into a room tag. The information is a calculated driven formula. I know that there are many blogs that give info on this, however, I am not finding a definite answer. I have a column in my schedule that is the occupant load factor which is a calculated value, formula selected, common discipline, integer type, and the formula is (area / occupant load factor) / 1sf + 0.499. this is reporting a whole number(integer) however, putting that value in a tag it seems to be a dead end.... Am I missing something??? thank you in advance.
Eric Brown
Solved! Go to Solution.
Solved by ryan.duell. Go to Solution.
Unfortunately you cannot pull values from columns [such as calculated value formula] in a Revit Schedule to a Label in a tag family; this is a current limitation.
I have included some alternate approaches and additional information below:
http://www.aecbytes.com/tipsandtricks/2008/issue33-revitarch.html
http://revitinalexandria.blogspot.com/2010/08/occupant-load-schedule-formulas.html
http://www.revitforum.org/archive/index.php/t-36.html
I would highly recommend requesting this feature below:
http://usa.autodesk.com/adsk/servlet/index?siteID=123112&id=1109794
Thank you,
Ryan,
Thanks for your reply. I appreciate your time. Furthermore, I'm jelous of your job.... Long time follower from "The Revit Clinic". Lastly, I had a feeling that someone would refer me to those sites and solutions. however, I haven't checked out Revitforums.org yet. great info... thanks again.
Eric Brown
Hello Eric,
I saw the issue you are having with the calculation of the occupancy loads and the desire to put that information into Room Tags. I wanted to let you know that Ideate released a software yesterday that can allow you to accomplish this. Please take a look at our demo for Calculated Values in Tags.
http://www.ideatebimlink.com/index.php/demo/
Using Excel, you can get more accurate values and push the values into a parameter in the Room Tag. There is a 30-day trial that you can use to evaluate if this software will benefit you in this situation.
Jesika
Ryan,
Thank you for providing a link to the our new forum, Revitforum.org ; it is a new place dedicated only to Revit issues, which was created by Klaus Munkhom, and where the administrators are: Klaus himself, Aaron Maller, Iru69, and myself ; all of us were frequent contributors of the Revit Architecture forum at AUGI. But, due to recent events that happened after Autodesk University, and which disrupted our daily use of the forum, we decided to create and manage a new forum, created and managed by Revit users, for Revit users. In about two weeks the forum has received more than 200 new members, most of them "Augi refugees" who, like us, wanted to have a new beginning somewhere else.
I invite the community of this forum to visit us at http://revitforum.org/forum.php
Now this can also be achieved through Dynamo (Get Parameter / Formula / Set Parameter).
Only downside is that the data pushed through Dynamo is not live, and needs to be rerun.
Hi Jan!
I watched a video for this...
But I couldnt get what script he used exactly. Could you please help me in finding away to code it?
Thanks!
This one below worked for us. It requires you create 'Occupancy Load' and 'Occupancy Load Factor' project parameters (and set the Occupancy Load Factor before running the script). Script is attached.