i need input from my excel file for my dynamo script.
i’m trying to find the rebar combination which fits and is closest to but bigger then cell F12 (647).
a cell is good when the rebar combination is green in both tables.
K7(770) is the closest green cell to F12 but the combination 5xØ14 (K22) is red in the second table so i can’t pick this number.
the next cell closest to F12 is P5 (785), in the second table is combination 10xØ10 (P20) also green so this one is good.
how can i pick the first rebar combination which is right?