Forum Discussion

Andre304's avatar
Andre304
Copper Contributor
Dec 24, 2022

Binomial Lattice Graph

Hi everyone,
Are there any way I can make a binomial lattice graphic like the one i put below?
https://1drv.ms/x/s!AhCCFUe0gk2Hm320raqU6G9in0MH?e=UeRXmA 

Thank you

Charting
excel

1 Reply

  • PeterBartholomew1's avatar
    PeterBartholomew1
    Silver Contributor
    Dec 24, 2022

    Andre304 

    This was possible but involved some pretty awkward 365 formulas.

     

    = 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))

     

Resources