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 →
Related videos
- Document Templates 0:48Features in a minute
- Find Acronyms and Build the Glossary 0:49Features in a minute
- Tutorial 11: Produce the Deliverable 2:33Hands-on tutorials
- Training 1.5: Documents 2:46Training course
- SE 11: Technical Reviews: SRR, PDR and CDR from the Model 5:10The 15288 process, start to finish
All Documents and reviews videos → · Simulation and analysis