Binomial Lattice Graph

Copper Contributor

Hi everyone,
Are there any way I can make a binomial lattice graphic like the one i put below?
Binomial  

Thank youindex.jpg

1 Reply

@Andre304 

This was possible but involved some pretty awkward 365 formulas.

image.png

 

= LET(
      level, SEQUENCE(levels),
         nodes, REDUCE({"x","y"}, level,
            LAMBDA(acc,n,
               VSTACK(acc,
                  LET(
                     x, SEQUENCE(n,1,n-1,0),
                     y, SEQUENCE(n,1,n-1,-2),
                     b, IF(SEQUENCE(n),NA()),
                     HSTACK(x, y, x+1, y+1,b, b, x, y, x+1, y-1,b,b)
                  )
               )
            )
         ),
   WRAPROWS(TOCOL(DROP(nodes,1)), 2))