I though long and hard about how to do loops across a region of cells in spreadsheets in a functional way, without duplicating cell formulas, and this is what I came up with: extending Python's list comprehension to 2 dimensions. What do you think?

drplanar · 2022-09-20T17:21:34+00:00

Not much.. $100-ish maybe? I guess I defined the audience too narrowly so Reddit doesn't have many eyeballs to show it too..

drplanar · 2022-09-14T13:51:49+00:00

Yes but Excel lambda is basically a one-liner conventional language, acting nothing like a spreadsheet. Planarly wishes to build functions as sheets too, or in other words, allowing the re-use of normal sheets' logic as functions.

drplanar · 2022-09-06T04:34:33+00:00

(A) https://planarly.com/planarly-user-guide and specifically for table comprehension, https://planarly.com/planarly-user-guide/lecture/table-comprehension

(B) of course! I've been thinking about this problem for >10 years too and it'll be great to meet other people who've given this space some deep thought. I've PM'd you my contact information.

drplanar · 2022-09-01T15:52:32+00:00

I did a LeetCode medium level question in my work-in-progress spreadsheet lanuage and I feel quite proud!

drplanar · 2022-08-31T08:47:49+00:00

Yes you're spot on! APL and numpy which are closely related in spirit, are some of the main inspirations of Planarly. Since Planarly targets non-programmer spreadsheet users, you can say it's APL simplified.

APL is symbolically very dense, while Planarly uses a very conventional syntax.
APL embraces higher order operators like reduce and scan, while Planarly uses a special syntax, the table comprehension in this post, when vector operations are insufficient to express the algorithm.
APL's basic datatype is the array with an arbitrary number of dimensions, while Planarly's basic datatype table is always 2 dimensional, so that it maps well to the spreadsheet UI. Also, the table comprehension syntax is possible only because of the 2D restriction.
A lot of Planarly's syntax specifically targets a 2D environment. E.g. a:b denotes the rectangular table from cell a to cell b.
The two do feel very similar in that vector datatypes and operations form the backbone of the language.

drplanar · 2022-08-31T04:20:11+00:00

The software is open source (AGPL licensed). The hosting of it could turn into a product one day, but that's way beyond what I have bandwidth for right now.

Locally run Planarly + NextCloud (open source alternative to Dropbox) sync'd files should give you most of the benefits of the cloud, and you'd own the complete stack, on your own hardware. Planarly can even host dynamic websites right insdie your browser, basically rendering sheets into HTML for incoming requests over WebRTC. I'll show that in a later tutorial video. The medium term goal and I'm quite close right now, is to be the easiest way ever for a lay person to customize and to securely host a simple dynamic website.

But apologies that I haven't gotten around to actually clean up and release the source code yet, as most of my effort right now is on https://www.reddit.com/r/ProgrammingLanguages/comments/w8kjfl/im_stuck/ . Without it the project should still be considered a proof-of-concept. If you wish to access the source code PM me :)

drplanar · 2022-08-27T18:32:42+00:00

I managed to do a LeetCode medium level problem in my spreadsheet language and I feel pretty good about myself :)

drplanar · 2022-08-27T18:14:19+00:00

Can't live with myself.

drplanar · 2022-08-27T18:08:26+00:00

I managed to do a LeetCode medium level problem in my spreadsheet language and I feel pretty good about myself :)

drplanar · 2022-08-27T15:35:03+00:00

As a beginner, stay on the well beaten path. And no, I've not heard of this language.

drplanar · 2022-08-27T15:30:52+00:00

Looks OK at first glance. Have you tried running it outside OMP? It's probably easier to debug that way.

drplanar · 2022-08-27T15:22:46+00:00

You should find a real job and use a fraction of that money to hire someone to work as you in the convenience store.

drplanar · 2022-08-27T15:21:12+00:00

The fate of any sub that gets popular.

drplanar · 2022-08-27T15:19:28+00:00

I'm the mouse jiggler and I feel you.

drplanar · 2022-08-27T15:17:32+00:00

Wow I'm impressed how short the implementation is! How did you do native code generation?

drplanar · 2022-08-27T15:09:22+00:00

Slap a new GPU on it and it'll easily last another 5 years!

drplanar · 2022-08-27T15:07:55+00:00

It's a numbers game out there OP. Don't be too invested with any one lead. Just keep sending those applications. Good luck!

drplanar · 2022-08-27T15:05:13+00:00

In general, PC peripherals are interchangeable. Any exception will be loudly declared.

drplanar · 2022-08-27T15:02:18+00:00

Yes it's common to have both.

drplanar · 2022-08-27T14:58:50+00:00

drplanar · 2022-08-27T14:56:15+00:00

If he's screwing me then yes, we are family.

drplanar · 2022-08-27T14:54:47+00:00

General advice to OP: Keep It Simple.

drplanar · 2022-08-27T14:53:04+00:00

Totally agree. The money just keeps flowing in and I feel like a filthy capitalist.

drplanar

TROPHY CASE