Holarch

Videos · Features in a minute · Spreadsheets

Formulas Engineers Use

LET, LAMBDA and dynamic arrays, as in Excel

Holarch spreadsheets calculate Excel's formula language with the Holarch Calc Engine, including the functions engineers use for real calculations: LET to name the parts of a formula, LAMBDA for your own functions with MAP, REDUCE, SCAN, BYROW and BYCOL, and dynamic arrays such as SORTBY, FILTER and UNIQUE that spill into the cells next to them. The example computes free-space path loss to five ground stations for the CubeSat EO-1 demo project.

In more depth: the highlight Named Views.

Features: The model · Help: Spreadsheets

Shows Holarch 2.35. Plays from holarch.app; see the Privacy Policy.

← Previous highlight · Next highlight →