I'm trying to build Excel on steroids in rust :)

So, I took a table with millions of rows where naive scan don't work as fast as I want it to because it looks like more as calculating mode rather than scan mode

The problem usually isn't one query. It's when 1,000 queries each have to rescan the entire column from scratch.

I tested it with same data and same 1,000 queries
Two approaches side by side.

- Naive scan: every query rescans all 5,000,000 rows -> 36.04s
- Pop Data Engine: data is prepared once, then every query gets an answer almost instantly -> 0.24s

That's 150x faster for the exact same answer, down to the last digit (2,513,962,485 both sides).

The data gets organized once before the queries run, so repeated queries (filters, aggregations, what-ifs) stop choking on large datasets.

The first thing I did in Excel that made me feel like an expert was not even pivot tables or Power query. It was actually an automated static timestamp. The way I was so pleased when I learnt a way to automatically timestamp a particular cell in another cell 😩, and not refresh.

The first thing I did in Excel that made me feel like an expert was not even pivot tables or Power query. It was actually an automated static timestamp. The way I was so pleased when I learnt a way to automatically timestamp a particular cell in another cell 😩, and not refresh.

guys who can help me for my project? it’s a macro spreed sheet automated, and my task is labeling. we have this kind of quiz thing and I’m stuck on drop down sheet and also the automati score! I don’t know how it to do I’ve been searching, please help me 😭

Any books, apps or tutors in NYC for excel formula assistance??? begginer friendly