One thing that I am hoping for however is some kind of notebook-like interface for doing small, ad-hoc data analysis projects. This looks fairly close to that.
Mathematica pioneered "the computational notebook" concept, and now we have similar stuff with R/Rstudio, IPython/Jupyter, matlab, and jmp. Those are all really nice and powerful, but they're somewhat large in scope and very ambitious.
It would be soooo cool to be able to just make notebooks that contain spreadsheets, related manipulation and analysis code and also text that can render to well-formatted html/pdf documents with really nice tables.
This tool looks like it can get there... if it can develop the ability to render documents sort of like Knitr for R.
I have been really curious about getting first-class interactive spreadsheet functionality in Jupyter (possibly by building a widget). I think it would be the ideal analysis platform.
while i dont have much of an opinion of js in a spreadsheet except "neat!", the website design and text is spot-on in that I understood in an instant what the project does! Kudos.
I'd love to see Jupyter (IPython Notebooks) capable of this kind of thing. It'd be awesome to be able to select a column of a Pandas DataFrame and apply a function to it.
Yeah, I mean more as a GUI enhancement. It might be outside the scope of Jupyter, but I think it'd be neat to be able to treat DataFrames like a spreadsheet.
Personally, I'm comfortable writing Python, but I bet you'd see more adoption for non-programmer academics who still need to work with data.
I'm of the same mind about Excel, which is why I don't use it any more. I don't like anything where there are hidden layers of meaning that are easy to overlook. I like Jupyter because everything is right there in front of you.
Another shortcoming of spreadsheets is that they don't solve what I consider to be the Fundamental Problem of Programming: How to keep your sanity when your project gets bigger than one screen or one page. Of course programmers have lots of ways to deal with this, by creating named abstractions, subroutines, and so forth. It's why we can write million line programs today. But how it's solved in Excel seems incredibly clumsy by comparison. Of course you can adopt the conventions of programming by using Visual Basic, but that seems to occur quite rarely.
I use Jupyter as a lab notebook, and it's OK to enter data by hand in an array literal, paste it from a spreadsheet (it comes in as tab delimited text, which is easy to mung) or read it from a text file.
But an edit-able tabular data array (that was also accessible programmatically) would be really super.
I noticed that you're using a web-worker, does all the heavy lifting happen there and the main thread is used for purely rendering?
I'm noticing some lag when I just press enter into a cell twice (once to get into edit, and then again to get out). Any idea what's going on there (I'm interested technically)?
No editbox for the contents of the currently selected cell? (I have to double click to see the formula)
One of the examples suggested I use dl.stdev(D2:D65). I think it actually meant D5, but in any case I noticed that it computed the stdev as if empty cells had zeroes in them, rather than ignore them which would be more the norm with spreadsheets.
I do like the idea of being able to import random javascript, could be very handy.
edit: also the drop down menu headings seem to stay highlighted when you click off them, but you probably knew that. 2nd edit: oh I see, it's if I click off them onto a blank part of the window
Yeah it's not really "new". Lotus Improv was doing this 25 years ago, for those of us old fogeys who remember. 1-2-3 was for the secretaries, Improv for the power users.
Also, I know know of plenty of financial institutions that have mod'd Excel with Add-ins to the point where the Worksheet integrity is better than 95% of the RDBMS' I've worked with. Version controlled, full audit trails, access control lists, type validation...
Hell out of the box, you can get an out of the box Excel + SQL Server BI to essentially make an off-the-cuff Line of Business app, completely sync'd, with a Silverlight front similar to (this)[http://www.infragistics.com/uploadedImages/Content/PRODUCTS/...]
True, but having a feature isn't necessarily the same as having it front-and-center as part of the experience. Also, that JS API you have linked looks pretty verbose and clunky compared to OPs.
Sorry, those pages are not there yet. We're working to put in the those pages. We got excited and decided to show the meat first. We'll have done ready soon. If you'd like to contact us, go ahead and shoot us an email contact at dtab dot io
Every single spreadsheet software has been able to do this for years, but using Javascript makes it better amirite?
What makes this better than Excel (VBA, Python, probably half of the languages on the planet.), Libre Office, Google Spreadsheets, etc., aside from Javascript ? The only point I could see would be integrating this into a page, which is of dubious utility.
As the Show HN guidelines say: "When something isn't good, you needn't pretend that it is." But you also needn't trample over someone's freshly planted garden.
Helpful criticism is fine. Asking a question is fine (a real question, not a gotcha one designed to make someone look bad); for example, one could ask "what do you mean when you say this is a new kind of spreadsheet?" Pointing out similarities to other work is fine. All we want to avoid is being dismissive. Since the line isn't obvious (especially to a million readers), simply err on the side of not being.
On HN, new work doesn't need to be useful, just alive. One can't always predict what will turn out to be useful anyhow.
Everybody showing new work deserves a minimal baseline of respect here. If you know more and have done more than someone else has, that's great. That's an opportunity to teach and to share, not put them down.
Edit: since "new kind of spreadsheet" is arguably a bit baity we've changed to the HTML doc title.
I am uncomfortable with the line you're taking here. The sentence "javascript makes it better amirite" was a bit juvenile, but otherwise the comment was perfectly valid. We do not want to be forced to be positive about things which have serious flaws; this sort of kumbaya HN thought police makes this seem more like some sort of Christian summer camp than an environment for rational discussion.
Nobody wants to be "forced to be positive", including us. If you try to find a different interpretation of what I wrote, I don't think you'll find it very hard.
In a typical office environment, everybody knows how to work with spreadsheets. They're a common interface and a great way to present and explore tabular data.
But as soon as you put that data into an Excel document and hit Save, it's outdated. Somewhere, somebody in the office has a .xlsx file on their C: drive with the data you need, but that doesn't help you much, does it? Or somebody puts the data into a spreadsheet and emails it to everybody in the office, then a few people make some changes and email again, and now you've got 15 different versions of the same spreadsheet floating around and nobody knows which one is the latest and most truthful.
Or you put that interface on a web page connected to a shared data source and all of those problems disappear.
There's another nuanced advantage to this kind of tool, however: the ability to perform "reproducible" analysis.
With an excel spreadsheet, the person doing the analysis typically pulls in some data (usually by copy/paste), and then performs a series of manipulations on it. These manipulations are NOT recorded. A the end of the analysis the author sends the spreadsheet in an email or maybe copies the spreadsheet into the body of an email. Recipients, if they're going to evaluate the analysis have a lot of work to do over and aren't necessarily able to determine what, exactly, was done to the data.
Something like this puts everything into a console, javascript libraries, and tables-- as long as the author manipulates data from the console and the functions, it should be possible for someone to follow what was done to the data, reproduce results, and go further with the analysis.
Use of spreadsheets results into many problems when team-size sharing spreadsheet becomes bigger.
I have created summary of comparing spreadsheet with web application using online database at the following link.
Major items are security, multi-user experience, encryption/decryption of sensitive data, auditing/change-history, workflow-requirements etc. For simple work in a smaller team environment spreadsheets work fine.
What does this product have that fixes the problem you're talking about here? How does working in a spreadsheet with javascript net you any better benefit than working with Excel with respect to obsolete sheets?
My experience is stuck in the 90s, as are the coworkers that drive that experience. Most of them refer to the Chrome browser as "the Google", I haven't a snowball's chance in teaching them how to connect an Excel document directly to a central data source.
But what I can do is provide them with an easy interface for interacting with that data directly, and give them the option to "save" their results within the context of those interactions so that they can share a simple link instead of a static file.
As for embedding runtimes in HTML, ActiveX is dead and I do not mourn it. Our office has finally decided to standardize on a modern web browser, and I couldn't be happier about that.
But those people could be using Google Spreadsheet already for example, which would have already solved the problem. And people in the office are not going to be writing Javascript in their spreadsheet.
Storing proprietary data in Google may not be viable. I know it isn't in my office, for instance. Plus, you lose the flexibility to integrate it into a more comprehensive application interface which runs on your own hardware/software stack, which the Javascript in this case provides.
I can already imagine several good uses for this software in my workplace, so saying it "literally solves nothing" is "literally false".
Indeed, anyone who thinks Google Spreadsheets is the end of all spreadsheets and nobody would ever need anything else, has never tried to embed Google Spreadsheets into a larger application.
One thing that I am hoping for however is some kind of notebook-like interface for doing small, ad-hoc data analysis projects. This looks fairly close to that.
Mathematica pioneered "the computational notebook" concept, and now we have similar stuff with R/Rstudio, IPython/Jupyter, matlab, and jmp. Those are all really nice and powerful, but they're somewhat large in scope and very ambitious.
It would be soooo cool to be able to just make notebooks that contain spreadsheets, related manipulation and analysis code and also text that can render to well-formatted html/pdf documents with really nice tables.
This tool looks like it can get there... if it can develop the ability to render documents sort of like Knitr for R.