Create Mass from Area in Excel

excel

#1

I created this dyn file but it seems to be too big/ long. Is there anyway to make it smaller?
(I’m not sure of the correct terminology, sorry)

It takes a value from excel and creates a mass, and when I want to add additional rows to excel I have to increase the dyn file, which I’m ok with just thinking it could be streamlined.

Any help in making this dyn file correct or just easier to give to someone to quickly add rows/ masses would be appreciated.

Thanks, Jason

UPDATED
3Masses_from Excel.dyn (30.0 KB)

3Masses from Excel.xlsx (8.0 KB)


#2

You should have a look at the Transpose node. It would save you a lot of trouble…


#3

Thanks. I’ll post results.


#4

This is where I am at… I want to space out the rectangles in X axis depending on the width of the one before it plus a 2’ space until the next one starts, kind of multiple translations with equal spacing between, but cant figure out how to list the widths so the next rectangle starts where I want it. Any suggestions? Thanks.


#5

Try the following:


#6

w=List.Shuffle(5..20..5);
gap=2;
rc=Rectangle.ByWidthLength(w,w);
sp=List.DropItems(w,-1)/2+List.DropItems(w,1)/2+gap;
mv=Math.Sum(List.TakeItems(sp,1..List.Count(sp)));
rc.Translate(Vector.XAxis(),Flatten({0,mv}));

#7

There are several packages that have Mass Addition nodes - that would be another alternative for creating the placement coordinates with a constant margin between them.


#8

Thanks, Works perfectly!


#9

Hi Jason,
Could you please post what your finished graph looks like?
Thanks,
Don


#10

Luck is on your side…

image


#11

Indeed Jason!
Thank you!
Don