# Values multiply by 60 **URL:** \ **Category:** Revit\ **Created:** [April 26, 2017, 3:09pm UTC](https://forum.dynamobim.com/t/values-multiply-by-60/11335 "2017-04-26T15:09:22Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![Bill\_Mutert](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/bill_mutert/32/192965_2.png) [@Bill\_Mutert](https://forum.dynamobim.com/u/Bill_Mutert)\ **Post date:** [April 26, 2017, 3:09pm UTC](https://forum.dynamobim.com/t/values-multiply-by-60/11335/1 "2017-04-26T15:09:22Z")
I know there are unit issues with Dynamo and Revit, but this one is making me crazy. The units in my Excel spread sheet flow through my Dynamo graph with no problems and I can follow them in the drop downs at every node, but when I check the properties inside of my Revit model these numbers multiply by 60 for some reason. I skimmed through 20 or 30 posts and couldn’t find a good way to convert them. Most posts revolve around measurements and not plain numbers Any thoughts here? ![](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/a/d/ad9c5490545c09a5db0dd14f81d89f3ff2c6494f.JPG) Thanks ---
**Author:** ![Brendan\_Cassidy](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/brendan_cassidy/32/7685_2.png) [@Brendan\_Cassidy](https://forum.dynamobim.com/u/Brendan_Cassidy)\ **Post date:** [April 26, 2017, 3:27pm UTC](https://forum.dynamobim.com/t/values-multiply-by-60/11335/2 "2017-04-26T15:27:35Z")
i would suggest you look at getting revit lookup installed so you can interrogate the values behind the scenes, the reason behind this is to understand the factor difference between “value” and “value as string”(conversion for units) See the following post i did a while back that helps to highlight this. > [@Structural framing Tekla values to Dynamo possible units issue](https://forum.dynamobim.com/t/structural-framing-tekla-values-to-dynamo-possible-units-issue/5457/2): > > What seems to be happening is the kilonewtons value is being transferred between kilo newtons to feet for some weird reason(to Feet open_mouth and see attached). But as a note the revit database saves all values in imperial units but the values you see( “As value String”) are how you decided to show units via project units. As you can see the value in the revit data base is similar to a metre to feet conversion of units but if you can access the “As Value String” you can get the direct value. … To get around the issue you can divide the value just prior to putting it into revit parameter by the factor difference which in this case is 60. Add the following to a Code Block: a / 60 ---
**Author:** ![Bill\_Mutert](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/bill_mutert/32/192965_2.png) [@Bill\_Mutert](https://forum.dynamobim.com/u/Bill_Mutert)\ **Post date:** [April 26, 2017, 4:26pm UTC](https://forum.dynamobim.com/t/values-multiply-by-60/11335/3 "2017-04-26T16:26:41Z")
I had tried using a DIVIDE node, but it would error out on me. I tried it in a few different locations Thanks ---
**Author:** ![Kulkul](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/kulkul/32/49801_2.png) [@Kulkul](https://forum.dynamobim.com/u/Kulkul)\ **Post date:** [April 26, 2017, 4:58pm UTC](https://forum.dynamobim.com/t/values-multiply-by-60/11335/5 "2017-04-26T16:58:05Z")
Hi @Bill_Mutert, @erfajo, @Brendan_Cassidy Why not just Set parameter as per Project units. There is a method in Revit API (ConvertToItnernalUnits) to set that [http://www.revitapidocs.com/2017.1/86d6d8b7-71ff-3768-4ffd-08969866dd62.htm](http://www.revitapidocs.com/2017.1/86d6d8b7-71ff-3768-4ffd-08969866dd62.htm) thanks to @T_Pover who has already created this. [https://www.dropbox.com/s/lij2jvec77kcus9/set%20mech.gif?dl=0](https://www.dropbox.com/s/lij2jvec77kcus9/set%20mech.gif?dl=0) ---
**Author:** ![Bill\_Mutert](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/bill_mutert/32/192965_2.png) [@Bill\_Mutert](https://forum.dynamobim.com/u/Bill_Mutert)\ **Post date:** [April 26, 2017, 5:09pm UTC](https://forum.dynamobim.com/t/values-multiply-by-60/11335/6 "2017-04-26T17:09:39Z")
I’ll give it a shot, thanks ---
**Author:** ![Bill\_Mutert](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/bill_mutert/32/192965_2.png) [@Bill\_Mutert](https://forum.dynamobim.com/u/Bill_Mutert)\ **Post date:** [April 26, 2017, 5:22pm UTC](https://forum.dynamobim.com/t/values-multiply-by-60/11335/7 "2017-04-26T17:22:14Z")
That works perfectly as a “manual override” but how can I automate that step? ---
**Author:** ![Kulkul](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/kulkul/32/49801_2.png) [@Kulkul](https://forum.dynamobim.com/u/Kulkul)\ **Post date:** [April 26, 2017, 6:24pm UTC](https://forum.dynamobim.com/t/values-multiply-by-60/11335/9 "2017-04-26T18:24:07Z")
> [@Bill\_Mutert](#): > > how can I automate that step? @Bill_Mutert Read Excel → Convert Excel Values to Numbers using String.ToNumber node → Assign the number values to SetParameterAsProjectUnits. Hope it helps! ---
**Author:** ![Bill\_Mutert](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/bill_mutert/32/192965_2.png) [@Bill\_Mutert](https://forum.dynamobim.com/u/Bill_Mutert)\ **Post date:** [April 26, 2017, 7:33pm UTC](https://forum.dynamobim.com/t/values-multiply-by-60/11335/10 "2017-04-26T19:33:48Z")
I remember some traffic about strings and numbers in another challenge I had, I will try that Thanks ---
**Author:** ![Bill\_Mutert](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/bill_mutert/32/192965_2.png) [@Bill\_Mutert](https://forum.dynamobim.com/u/Bill_Mutert)\ **Post date:** [April 26, 2017, 8:56pm UTC](https://forum.dynamobim.com/t/values-multiply-by-60/11335/11 "2017-04-26T20:56:04Z")
While I have your attention, I have another issue. My testing model has TEN spaces with this parameter in it, but Dynamo is only pushing to one of them. Any thoughts here? ![](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/6/1/6193249c72d610532a86da77cdc56e68ef1e8df2.JPG) ---
**Author:** ![Bill\_Mutert](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/bill_mutert/32/192965_2.png) [@Bill\_Mutert](https://forum.dynamobim.com/u/Bill_Mutert)\ **Post date:** [April 26, 2017, 8:58pm UTC](https://forum.dynamobim.com/t/values-multiply-by-60/11335/12 "2017-04-26T20:58:28Z")
Nevermind, it was a LACING issue ---
**Author:** ![Kulkul](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/kulkul/32/49801_2.png) [@Kulkul](https://forum.dynamobim.com/u/Kulkul)\ **Post date:** [April 27, 2017, 12:31am UTC](https://forum.dynamobim.com/t/values-multiply-by-60/11335/13 "2017-04-27T00:31:20Z")
@Bill_Mutert Some Basic rules - Always mark the topic as solved when you find solution. ---
**Author:** ![Bill\_Mutert](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/bill_mutert/32/192965_2.png) [@Bill\_Mutert](https://forum.dynamobim.com/u/Bill_Mutert)\ **Post date:** [April 27, 2017, 3:11pm UTC](https://forum.dynamobim.com/t/values-multiply-by-60/11335/14 "2017-04-27T15:11:48Z")
How do you do that? ---
**Author:** ![Kulkul](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/kulkul/32/49801_2.png) [@Kulkul](https://forum.dynamobim.com/u/Kulkul)\ **Post date:** [April 27, 2017, 3:12pm UTC](https://forum.dynamobim.com/t/values-multiply-by-60/11335/15 "2017-04-27T15:12:42Z")
@Bill_Mutert Here is how to mark. ![](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/2/4/247b739b0adbf0c8a72a6cf29417aa6b29978e50.png) ---
**Author:** ![Bill\_Mutert](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/bill_mutert/32/192965_2.png) [@Bill\_Mutert](https://forum.dynamobim.com/u/Bill_Mutert)\ **Post date:** [April 27, 2017, 3:22pm UTC](https://forum.dynamobim.com/t/values-multiply-by-60/11335/16 "2017-04-27T15:22:37Z")
Got it I went back through all of my posts and updated them ---
**Author:** ![Kulkul](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/kulkul/32/49801_2.png) [@Kulkul](https://forum.dynamobim.com/u/Kulkul)\ **Post date:** [April 27, 2017, 3:24pm UTC](https://forum.dynamobim.com/t/values-multiply-by-60/11335/17 "2017-04-27T15:24:22Z")
@Bill_Mutert Just click on one solution i think you by mistakenly clicked on solution to my reply on how to mark the post 😄