I'm tired of waiting for Google spreadsheets, so I'm building a fast alternative
hrishimittal.com
hrishimittal.com
After nearly 40 years of commercial spreadsheets, the empirical evidence is that spreadsheets are hard, otherwise there would be more of them. And the reason Excel dominates is because they get so many of the non-trivial details right.
Example: consider how often inaccuracy of JavaScript floating point operations makes a blog post appearance on the web [I recall several even on HN] versus the rarity of similar observations regarding Excel calculations. Then consider how many complicated floating point ops are done via Excel functions every minute of every day by non-computer scientists and non-programmers.
A couple of years ago I came to the conclusion that Excel, not Windows, is the killer-app for Microsoft, and that Microsoft knows it and invests in it accordingly. The person who decides on office suites is the manager who uses spreadsheets not the people using the word processor [in which case we would talk about WordPerfect not MS Word as the standard].
Microsoft has changed lots of things in Excel. The pivot tables and graphs were rewritten in 2007. The statistics functions were rewritten in 2010. These are pretty fundamental features.
The key is that they made these changes by versioning. v1 Pivot Tables are not automatically converted to v2 Pivot Tables. The new statistics functions have new names -- the old statistics functions are still around. This ensures bug-for-bug compatibility with old spreadsheets.
The reason Google Spreadsheet hasn't taken off is lack of investment on Google's part, which is needed because from what I understand from some Google's devs comments, it is a right mess under the bonnet.
We can only guess why Google haven't invested in it, maybe they don't believe people are willing to share their private or corporate data with Google's, or they think the potential for disaster is too high.
But I believe the potential is there
I'm not seeing this.
You can indeed paste from the clipboard multiple times in Excel. I just tried this, and it works fine in both Excel 2013 and the Excel web app.
I suspect the reason for Google's lack of investment is the degree of difficulty which it takes to develop a spreadsheet that can compete with Excel on something other than price. The world is littered with trivial attempts at spreadsheets, from Emacs org-mode tables and calc-mode to Common-Lisp's Cells project to Scheme-in-a-grid.
As I skim and wade and slog about Knuth's Semi-Numerical Algorithms, I get the feeling that any useful spreadsheet is probably going to have a bit of the "Electric components by Lucas" about it in order to bash a numerical implementation sufficiently to meet the reasonable expectations of real world non-programmer end-users. You won't get far with the CEO of a Fortune 500 corporation by saying, "Sometimes addition and multiplication are non-associative, so be sure to avoid cumulative rounding errors."
Pasting: See Office Clipboard. http://office.microsoft.com/en-us/word-help/copy-and-paste-m...
From the signups so far, it appears there are plenty of people looking for an alternative, so we'll focus on satisfying them.
>the rarity of similar observations regarding Excel calculations.
There is no rarity of these: https://en.wikipedia.org/wiki/Numeric_precision_in_Microsoft...
>Excel, not Windows, is the killer-app for Microsoft
Agreed:)
The thing about Excel is it's good enough to compete with free, e.g. Google Docs and OpenOffice/OfficeLibre. That's perhaps why Microsoft Excel buried less expensive competitors with approximately equivalent functionality for a typical user, not only Lotus123 but also Quattro Pro.
Google Docs scripts are cool but far too often they break.
In the interest of speed, what are you going to keep vs. trash out of the excel functions kit? I bet you could get an incredible tool by keeping top 30-40% of functionality, because lets be honest, anything beyond that an back to Excel it is...
Another key feature will be a robust API to allow people to build on top of it. More on that in another post soon.
If anyone can confirm it's not the case, I'm happy to update the post.
P.S. You complained about the selected-cell animation in the web app. This animation is not limited to the web app -- exists in Excel 2013 as well. It's just an animation -- there is no functional effect. If you don't want to get slowed down, ignore the animation and start typing.
It's just like unminimizing a window in the Windows taskbar. The animation is just eye candy -- the window is actually fully-active as soon as you click on the taskbar button.
I'm not fixing those apps. I'm building a new one without that issue.
This animation is not limited to the web app -- exists in Excel 2013 as well.
Yes, but it affects the web app a lot more. You're right that it has no function, so why slow down the user for eye candy?
As for animations, users like animations. Only a small fraction of users know the program well enough to outpace the animations. And they can simply ignore the animations, like I do.
I think it uses a lockfile to do this. It works, but it doesn't scale up well. IIRC, after about 3 people, the effectiveness drops substantially.
The sad part is that if this new project succeeded, it could catch google's attention and they will be able to launch a better version in a very short time.
They have too much power to strangle/buy any innovation. Just to let them die.
This is why I don't like google anymore.
http://www.amazon.com/Data-Smart-Science-Transform-Informati...
This is admirable, however slightly myopic. I'd be interested to see how a product can both be fast and have all of the other extremely complicated calculations that Excel has today. People don't use Excel just because it's fast.
I use collaborative spreadsheets for everything: scheduling, crm, data-loading tasking, actual data entry. If a project is in its infancy and I want to get started quickly for proof of concept, online spreadsheets are absolutely invaluable in all sorts of applications. I piece-meal this stuff out to other services down the line.
I too muck with large tables in a standalone application (libre) and upload my updates. would love to skip that step and stay in a web-browser.
I think the ideal route might be to grow into that product instead of trying to build it from day one.
I only ask because the app alone sounds like a nice idea, but the key thing is what you integrate it with. Having yet another web app provider that is storing data is a no-no for a lot of people.
I never really stressed it, but looks promissing to big data.
I'm still looking for a really good alternative, exporting my gdocs to excel data processing.
>"To enable iCloud on your Windows PC (Windows 7 or 8 required), first set up iCloud on your other devices, then install the iCloud Control Panel for Windows."
The "first set up iCloud on your other devices" step appears to need an Apple device.