Forum Discussion
BigSpill: A 90‑Function Excel LAMBDA Library for Dynamic Arrays
What is BigSpill?
BigSpill is an Excel LAMBDA library containing 90 functions across 10 categories, built from extensive experimentation with dynamic arrays. The goal is to provide elegant, efficient tools that make sheet‑level formulas easier to read, more modular, and more dynamic.
The library includes a mix of:
- quality‑of‑life helpers
- essential primitives
- mid‑level operators
- developer‑level tools
- a few functions you might not expect to see in Excel
Who is it for?
Everyone.
BigSpill aims to make complex operations more approachable and expressive.
A few examples from the library:
- Pairwiseλ
- Staircaseλ
- Grainλ
- PolarGridλ
- Convolveλ
- Foldλ
- Tessellateλ
- Revealλ
- Knapsackλ
- Magnifyλ
- Traverseλ
The repository includes full documentation and 11 sample workbooks so you can explore the functions without setup.
If you’re interested in experimenting with dynamic arrays, or LAMBDA workflows, feel free to take a look. Feedback and suggestions are always welcome.
I've attached 1 onboarding workbook. There are 10 more at the link below.
GitHub:
2 Replies
Visitors would be be benefited if you attached a sample file with sample data and output of each function. Little explanation would make the file excellent for visitors. Can you please share sample file and use of functions?
Edit: I got the sample files to your GitHub repository. Still I will advise to attach a sample file the post for easy way.
Thank you for taking a look. I didn't attach sample workbooks here because the forum tends to gobble up attachments!
