Mesh Spreadsheet(mesh-spreadsheet.com)

474 pointsby galfarragemvor 7 Jahren51 comments

http://mesh-spreadsheet.com/

52 comments

chrispsnvor 7 Jahren

Hi! Didn't expect this.

Mesh is still very much an alpha. Since the last public commit I have been experimenting with:

- different text representations of the sheet (to make diffs as readable as possible)

- ways to compress more functionality into the 'boilerplate' included with each sheet.

On the to-do list are:

- persistence (including fixing "save sheet as URL" and local load/save)

- selecting input cells with a keyboard while editing a formula

- a way to include 'standard' spreadsheet formulas such as 'SUM' on-demand in the sheet file

- case-insensitive cell references

- much more polish...

JavaScript's lack of a built-in parser is a real bummer, and it means that while Mesh's backend logic can be written as a spreadsheet, in Mesh [1], the file has to include a third-party JS parser, which significantly slows down the editing process. I'd also like a proper SQL and first-class table support, but we work with what is supported by Internet Explorer 11.

I remain confident that we can substantially improve the status quo of spreadsheets and, by extension, programming.

[1] https://twitter.com/MeshSpreadsheet/status/10195553103635046...

galfarragemvor 7 Jahren

The only two projects I know regarding "visual programming" that I think "are on the money" are Mesh Spreadsheet and Hyperfiddle. Luna-lang, even if in theory is great, didn't click with me. Observablehq is also interesting but I don't have a use case for it.

Keep the good work!

edit - some remarks to "get there": it must be/feel fast like native Excel, Sublime Text or at least VS code. In another phase, to be a real "programming editor" it would be great if you could use any programming language you want, not just JS. Clojurescript or Elm/Purescript could be a good start.

edit2 > ways to compress more functionality into the 'boilerplate' included with each sheet. I think the boilerplate should be somehow hidden from the end user.

microcolonelvor 7 Jahren

> some remarks to "get there": it must be/feel fast like native Excel, Sublime Text or at least VS code.

As someone who is working on an Excel compiler, I can tell you it's challenging to make it very fast.

infinite8svor 7 Jahren

Is your compiler running on an interpreted language? I think to make this sort of product fast requires JIT compiling the users expressions, and doing some sort of whole program analysis to pull out the dependencies between cells.

microcolonelvor 7 Jahren

I do whole program analysis, and the host is not interpreted. The costs are mostly about the data structures used to store the intermediate values. Automatically selecting whether to make some values contiguous or not is difficult, and the types are a bit complex (basically option types).

The sheets I'm working with have around a million expressions, and there are large sparse regions, so the data structures have to be a bit compact.

vchak1vor 7 Jahren

I also think it would be valuable to autoconvert long lines (rows or columns) of similar formulas into a mapping on an array. That would require some level of shape analysis on the excel file.

microcolonelvor 7 Jahren

That is in fact the first step, we have around 800k instances, but only around 1500 unique combinations of dependency shape and expression, which makes a big difference.

infinite8svor 7 Jahren

Sounds interesting, have you published any more details anywhere?

microcolonelvor 7 Jahren

Not yet, gotta do our jobs first, then we can have the candy. :- )

I would like to do a write-up about it at some point though, if for no other reason but to show the Open Document or LibreOffice people what could be improved about the formats.

chrispsnvor 7 Jahren

Agree on the speed.

Not every programming language is suitable but ClojureScript would probably work (no plans to support it right now though, gotta finish this one first!).

Considering hiding the boilerplate in the text pane.

chrispsnvor 7 Jahren

Thank you!

codetrottervor 7 Jahren

This is really cool! Do you develop all of Mesh in itself exclusively, or do you still use a regular text editor as well? Either way I can certainly see this as being useful. I starred the project on GitHub and look forward to see what more is to come.

Aside from the SQL support you mentioned wanting to add, and the various todo-items, are you planning on going beyond the spreadsheet concept? For example with some type of node-based interface, like Unreal Engine 4 Blueprints [1], or like the materials editor in Blender [2]? I realize that might be a vague question, heh.

[1]: https://docs.unrealengine.com/en-US/Engine/Blueprints/index....

[2]: https://docs.blender.org/manual/en/latest/editors/shader_edi...

chrispsnvor 7 Jahren

Thanks! I honestly haven't developed much of Mesh in Mesh, because it's still early in the 'bootstrap cycle' and due to the parse delay issue mentioned above. It's also not nearly as robust to errors as it should be - text editors and traditional spreadsheets allow the user to 'sketch' ideas as discussed by Aaron Hsu [1].

I'd like to stick to a grid for writing 'functional core' logic, but there's potential to use a node interface at the surface of the 'imperative shell', to link up sheets or data feeds (push/pull). I was really impressed by Nodes [2] and I need to spend some time digging into Node-RED [3].

[1] https://www.sacrideo.us/un-structured-programming/

[2] http://nodes.io/story/

[3] https://nodered.org/

Paperweightvor 7 Jahren

I wonder if a spreadsheet and its editor could go in a self-contained HTML file. You'd open it in a browser, it modifies its own source code, and you just re-export or "Save Page As" when you're done?

Furthermore, maybe the data could be in CSV at the top of the file, in an HTML comment, and the editor could be in HTML at the bottom of the file, in a CSV comment, so the file could be opened in either a browser or Excel? Haha

chrispsnvor 7 Jahren

Possibly! Discussed this a little here: https://twitter.com/meshspreadsheet/status/10554309994530529...

Paperweightvor 7 Jahren

Programatically invoking the "Save As" dialog seems troublesome. Maybe there could be a signed WebExtension blob in the file, too - or it should download the latest updated library script every time the file is opened (although then there are security & CORS issues).

dustingetzvor 7 Jahren

Chris do you want to chat? I'm a founder in this space. Can you add contact info here or on github, or open twitter DMs or something:) My contact in profile.

[deleted]vor 7 Jahren

WorldMakervor 7 Jahren

> I'd also like a proper SQL and first-class table support, but we work with what is supported by Internet Explorer 11.

If you were thinking about WebSQL, then sticking to IE11 has skipped you over an obstacle course in web standards, because WebSQL was abandoned by the browsers (for good reasons, led by Mozilla and Microsoft trying not to let SQLite bugs define the web platform for decades) and won't be supported again soon, in lieu of the much simpler key-value store called IndexedDB.

> JavaScript's lack of a built-in parser is a real bummer

eval() wasn't sufficient for your needs?

_bxg1vor 7 Jahren

eval() parses and executes. I assume the OP's use-case involved working with the abstract syntax tree and not simply running a string as code.

chrispsnvor 7 Jahren

Yes, correct.

macca321vor 7 Jahren

I'd be really interested in the ability to put in probability ranges for cell values and run monte-carlo simulations to get the final values (Excel+montecarlo has been a pet idea of mine for years but I haven't got the time to do it)

chrispsnvor 7 Jahren

You might like Guesstimate: https://www.getguesstimate.com/

macca321vor 7 Jahren

Thanks, that looks great!

tenaciousDanielvor 7 Jahren

This is awesome! I happen to be working on something similar, although it's oriented towards UI design.

eb0lavor 7 Jahren

Reminds me Tiddlywiki (https://tiddlywiki.com/); but with spreadsheets instead of wikis...

... as a second thought spreadsheets are the wikis of people in finance, management...

ajninvor 7 Jahren

Pretty cool, some basic documentation would be nice (the readme does not tell everything). I didn't find how to reproduce some of the behavior of the loan example in the GIF, like how to format cells (turns out formatting is just writing a function that transforms a value and assigning it to the cell's 'f' field. Are there other special fields ?). I can't seem to make sub-table creation work, after creating a table with ctrl-alt-t, I seem to be stuck in table edition mode, I can't click on another cell or press enter or tab to deselect a cell.

I think it's a pretty promising project. Spreadsheets are very useful tools but usually crippled by single-line, crappy, not syntax-checking, not highlighting function editors.

chrispsnvor 7 Jahren

Thanks for trying it out!

Yes - there are, or will be, other special fields, such as 'transpose' (so table headers would go in the first column instead of the first row). I was still figuring out which flags should be included, which is why it was under-documented.

Never expected sub-tables as a use case. Displaying nested cells would require a substantial re-write, but having logically nested tables may work... you'd just need to call the table making boilerplate function manually.

chrispsnvor 7 Jahren

If you’d like to see more of Mesh in action, here’s a long form video of an early version showing how to write a primitive RSS reader in a Mesh spreadsheet and use it as the backend to a website. Back then typing into a blank cell created a name; it now creates a value and uses the cell position as the default name. Cell references also had to be preceded with $; we now just add cell names as properties of the global object so you don’t need a prefix.

https://youtu.be/4e1vNqMs0QI

erikcwvor 7 Jahren

This immediately reminded me of org-mode spreadsheets[0]. I wonder if they were a source of inspiration for this project.

[0] https://orgmode.org/worg/org-tutorials/org-spreadsheet-intro...

tryitnowvor 7 Jahren

Great job.

On the "Why may I want to use Mesh instead of..." you may consider describing why I would want to use mesh instead of jupyter notebooks.

pqsvor 7 Jahren

Nice project. I always wanted a Python based spreadhshet. One where all the formulas are written in python, with access to all the standard library and more. This project is in javascript, but maybe someone could do it in python one day.

donarbvor 7 Jahren

There are a couple of a Python based spreadsheets, one called pyspread and another Grid Studio.

https://manns.github.io/pyspread/index.html

https://hackernoon.com/introducing-grid-studio-a-spreadsheet...

fulvousvor 7 Jahren

You can write macros in Python for Libreoffice.

https://help.libreoffice.org/6.3/en-US/text/sbasic/python/ma...

j88439h84vor 7 Jahren

http://visidata.org

mleventalvor 7 Jahren

> I always wanted a Python based spreadhshet.

isn't that just pandas?

chrisweeklyvor 7 Jahren

Very cool!

Tangent: I'm reminded of [Mobx creator] Michael Weststrate's post^1 citing familiar spreadsheet formulas and input cells as a way to explain concepts of derivations and observables in mobx (his excellent state mgmt lib, which imho improves on redux), making React actually "reactive".

^1 https://hackernoon.com/becoming-fully-reactive-an-in-depth-e...

SamBamvor 7 Jahren

Neat project, although selecting cells often does not work. (I assume that's because it's in alpha.)

This line, though:

> is lightweight: ~2000 lines of source code (excluding libraries)

I feel like that's a very different meaning of "lightweight" than I normally think of. I guess you're considering it from the perspective of a developer who works on it. As a user, however, the browser downloads 1.4MB of javascript, which is quite large, I'd say.

Someonevor 7 Jahren

1.4MB is about 50 VisiCalcs (http://www.bricklin.com/history/vcexecutable.htm) but I wouldn’t call it “quite large” for modern software.

chrispsnvor 7 Jahren

Yeah, I’m not happy with the download size either. It’s mostly the third-party JS parser.

MuffinFlavoredvor 7 Jahren

Does having JavaScript in the cell formulas allow you to do anything more than you could already do with Excel?

chrispsnvor 7 Jahren

Yes! Regex, tables that can expand/contract (not just arrays) are two big ones.

miki123211vor 7 Jahren

Could be cool, but this has zero screen reader accessibility. I hope this gets fixed.

chrispsnvor 7 Jahren

Good point, thank you. It is added to the isssues log. I’d love to hear more about what would make Mesh more accessible for you and others.

https://github.com/chrispsn/mesh/issues/68

theo31vor 7 Jahren

If you like this concept, you might like https://clay.run which is spreadsheet + functions hosted in the cloud

kerneisvor 7 Jahren

This reminded me of Histogram: http://tomasp.net/histogram/

MR4Dvor 7 Jahren

Any idea how to run this on an iPad?

chrispsnvor 7 Jahren

It should work on iPad, although it’s designed as a keyboard-preferred experience. What were you trying to do?

MR4Dvor 7 Jahren

Not sure why, but the edit button doesn’t seem to work, and I think that is preventing the keyboard from coming up (using virtual, not physical keyboard).

Simulacravor 7 Jahren

Spiffy! I like this !

denstervor 7 Jahren

Chris,

"substantially improve the status quo of spreadsheets and, by extension, programming."

I couldn't agree more!

We've created a new kind of spreadsheet for building software -- mintdata.com

Would be great to get your feedback -- any thoughts on what we could improve?

acjohnson55vor 7 Jahren

Your product looks really interesting, but

- $95/mo for a single user sets the impression that this is way out of reach for anything I'd consider. Clearly, I'm not the customer. - The fact that it appears to be using traditional spreadsheet formulas gives me concerns about how general it might be. Mesh is intriguing for its more flexible programming and table model. - There's a live chat module on your page that appears to not be able to be dismissed, which blocks a lot of the page content.