Hi again,
I have yet more questions about using dynamo and revit.
so far I have read a set of data from an excel file in dynamo and used that to place beams into my revit model.
from that, I have collected beam lengths and written them to the excel document. I get a list of "length" values for every beam of a certain type and that's a good start, but now I need to manage that data and It would be good if i can do this in dynamo rather than sifting through the data manually.
here is what i'd like to achieve is:
reporting the amount of beams that would need to be purchased in order to have the required amount of beams for the project ---
i.e. if we can only purchase a beam in 6m lengths, how many would I need to purchase to have the required amount.
I would like to somehow tell dynamo to run through the beam lengths it computes and then say "is this under 6m?, if so, are there any other beams that can be cut from the remaining 6m beam?"
I hope that makes sense, basically I am trying to minimise the material we would buy, by calculating the amount we need without needing to weld/join beams.
Alternatively, is there a command to write a function into and excel cell? rather than dynamo computing the information, I thought a workaround would be to give excel the information and a function to work itself out.
Many thanks and best regards,
David
