Dynamo Graph from Excel to Key Schedule

[travis.vaughan]

Trying to use what Dana DeFillipi did in herAutomating Occupancy class at AU this year for Function of Space (Occupancy) and modify it for Egress Width (doors).

I have the following information in Excel:

CR_Set Up Egress Width Key.xlsx (281.2 KB)

The following Dynamo graph:

CR_Set Up Egress Width Key.dyn (37.4 KB)

But i get this when the graph plays in Revit:

https://we.tl/t-ZoNBXHnGe6

If ya’ll could assist me, I’d appreciate it!

[Fiesta]

pls share a picture of your graph with the output of every node
Like that:

[john_pierson]

Hmm, I tried the files and I am not too sure what is going on. I did see this regarding it wanting strings only at one point, but that was from a while back.

Excel into key schedule Archi-lab

Hi there, I tried to extract data from excel into a Key Schedule. But, When I set the Type of Parameter to number. It doesn’t import the data from excel. Is there any way of extracting data from excel using the Number type Parameter? (I’m using Archi-lab key schedule node) Here’s my Code: [image] Here’s the Result: [image] Here’s my excel sheet: [image]

Might want to see if @Konrad_K_Sobon has some insight as I haven’t really every used the key schedule node.

[travis.vaughan]

Thanks for trying John. Hopefully Konrad will see and be able to help.

[travis.vaughan]

here’s the image that you requested:

[travis.vaughan]

I found a typo but fixing it didn’t effect the graph run into Revit.

[travis.vaughan]

It appears that the issue was that some of the parameters in Revit were not “text” parameters but “length”. Those were the ones that would not fill. As soon as I made those parameters which were “text” it worked.

[dana.defilippi]

Thanks for you hard work creating this, @Konrad_K_Sobon!!
Now that key values can be shared parameters it would be FANTASTIC if we could path the values as numbers/integers/etc so that they could be used in calculated values down the line.
Could you provide any insight as to how to edit the python / whether this is possible with the API? @jacob.small maybe?
Thanks again!!

[JacobSmall]

Think you meant to tag me… that’s just a friendly neighborhood alt account which only exists because of complexities around security policies.

Not sure what is possible with the API on this one, but it would be a good add for sure… Would make a nice ‘how to write some useful Python’ example for education stuff as well… I’ll slot some time to look this. No promises on anything, but if it’s doable with the time I have I’ll jump on it.