Slashdot Mirror
Hands on: Google Spreadsheets
feminazi writes "Google spreadsheets are more powerful than you might think, according to Richard Ericson. The free, Web-based service doesn't currently offer encryption, but the clean interface has standard drop-down menus, icons and buttons (just when MS is switching to "ribbons"). You can use it to work with existing files and "Formatting is simple, direct and fast. ... Sort, does precisely what you'd expect." Most importantly, it has most of Excel's functions -- including some that aren't listed or documented." We covered the launch of this program last week.
The key to this being an "Excel Killer" is not that it needs to be able to do everything (or even most) of what Excel can do. Most people barely use probably 2% of Excel's capabilities, and don't even know how to use much of the other 98%.
Yeah, but you still need to get to the 2% mark. I'm looking at this review, and I am utterly dumbfounded at some of the features it's lacking. For example, Charts would be incredibly easy to compute on the server, then download as images. Alternatively, they could use SVG support, or canvas support, or Javascript Drawings. Yet they completely leave charts out! I don't know of a single Excel user who hasn't charted their data at some point in time. If Google isn't supporting this, then they can expect users to dislike their spreadsheet.
Similarly, the lack of online help is a no-no for a spreadsheet program. Users still need to do computations, even if they're as simple as addition, subtraction, averaging, and weighted averaging. Failing to include online help means that users will have no idea how to properly compute these formulas. Even just dropping the expected args into the text field would do wonders for usability!
All in all, this article makes me believe that Google is buying into this "users don't need that much" mantra that makes sites like ajaxLaunch so laughable. GMail "won" because it provided a completely new way to work with email. It wasn't just the best Webmail apps, it was better than even installable apps! If Google wants to follow that success, they need to take that sort of innovation (*blech* sorry, weasel word) into their other office products. Otherwise, they're going nowhere, fast.
Javascript + Nintendo DSi = DSiCade
I'm using it to manage the world cup scores which are shared with another ppl I know, and the spreadsheet is cool I really didn't expected it to support formulas but It Does and i'm using them :)
OK, I'll bite:
http://www.wd40.com/Brands/index.html
Lists:
Lava, 2000 flushes, Carpet Fresh, 3-in-ONE, Lava Pro, X-14, and Spot Shot in addition to WD-40.
So which is the one product?
I mean, you've all heard the 80-20 (or 90-10, depending who you ask) law - and it's a valid point that there are many people still running Office 97, since it does everything they need from it. Makes you wonder whether it was really worth Google's while including these features - I guess anyone that uses them is likely to really need them, and is a power-user likely to trust Google as their primary(/only) spreadsheet app?
For the moment, Web 2.0 stuff is undoubtedly cool and useful (Google's own Maps and GMail both good examples of both), but I wouldn't really want to rely on it. It'd be like only having a mobile phone - most of the time you don't miss a landline, but when you need to make an emergency call, you don't want to be without one. Anyone else feel the same?
(Don't get me wrong, for casual stuff like writing birthday letters this'd be great - I'm thinking of the people running businesses off it here.)
My, that was a yummy potato!
WD-40 stands for Water Displacement, 40th attempt. Has a much better ring than WD-17 or WD-666.
Don't lead me into temptation... I can find it myself.
Just something I noticed. If you have a GMail account, and you've requested to be in the Beta Testing of the spreadsheet program, you may already be approved! I never received a confirmation from Google (perhaps it got caught in the Spam filter?), but I just went to http://spreadsheets.google.com/ and found that I could log in!
I have to say, the sheet has a nice feel to it. It really reminds you of Excel or OpenOffice Calc. Unfortunately, this comparison is quickly disappated once you start using it. Things I've noticed:
1. Formulas are edited in the cell rather than having a text field on top. This is REALLY annoying to anyone who uses a spreadsheet program regularly. There is an uneditable text field at the top (doesn't work right in Mozilla 1.7.12), but it's not useful for anything other than ogleing at.
2. Auto-resizing by double-clicking doesn't work. This is a core feature that I should think that everyone uses.
3. No size indicator when changing cell sizes. I don't know about anyone else, but I always try to resize my sheets to about 14.25 points high, as this looks best. In addition, the indicator is a good way of knowing that you've got the right size for a row, rather than by messing with trial and error.
4. You're limited to 100 x T cells. If you're one of those people with a lot of data, good luck. It doesn't look like Google will let you store it without manually inserting enough rows or columns to hold it all.
5. The formatting menu is useless. It's got a few data types, and that is IT. If you need a custom style, or a date in one of the billion other formats, you're SOL.
6. No cell borders. Raise your hand if you tend to mark headers with a cell border. (/Me raises hand.)
7. The "Freeze Rows" command makes no sense. Why are you choosing the number of rows from a menu, when a multiple row-select exists?
8. Sorting! Yippe! Now I can make my sheet into a database! (/sarcasm) Seriously, this feature actually works. I was expecting it to choke on numbers by treating them as text, but it automatically sorted then correctly. Score one for the team.
There's a lot of other minor annoyances that I won't get into, but the above are the big ones. Unfortunately, I've just about covered 90% of the functionality. My verdict? It's not ready for prime time. If Google wanted to do this, perhaps they should have teamed up with Sun's StarOffice team.
Javascript + Nintendo DSi = DSiCade
I have the Office 2007 Beta, yes the Ribbons are different from the old version, but after a couple of days of working with them, they became natural, one benefit is that they are very flexible so you can have a very similar GUI between all the applications, something Office hasn't always had. Sure it's not a single reason to upgrade (heck I use Crystal 8.5 for some of my work, it has a horrendous GUI), but it's a nice upgrade to be had, and I am sure somewhere there is a menu where you can turn it back to the old style.
Me thinks you are confusing two very similarly named but unrelated companies. Morgan Stanley owns Discover (Dean Witter and Van Kampen funds) but was not affilated with the house of Morgan (it was started by a former JP Morgan partners who left a JP Morgan predicessor prior to Drexel & Co's breakup due to the Glass Stegall act). JP Morgan & Co owns Chase and BankOne.
Degaussing scares the bad magnetism out of the monitor and fills it with good karma.
Not only those, but I just had it futz up my numbers. I loaded my Moon Shot Cost Calculator spreadsheet into Google SpreadSheet to see what would happen. Interestingly, it only displays the rows and columns I used. It also improperly sized column "C" so that "Wild Ass Guess" became "Wild Ass". :-P
:-(
The real problem, however, was that it automatically used integers for the computations. As a result, the mass ratio shows up as "0" rather than ".996". All calculations that follow from that one (pretty much everything) are thus zeroed out. With a more complex spreadsheet, you might never notice.
Frustratingly, there was no scientific or floating-point number option. I had to chose percent rounded to 2 decimal places to get the calculation to be correct. Not good.
As you mentioned, dollars also show up as just numbers rather than dollars. This also changes the look of the spreadsheet.
Javascript + Nintendo DSi = DSiCade
http://www.google.com/finance?q=SHLD
Somehow, I doubt Sear's future looks gloomy.... In fact, they look great with positive earnings and positive growth. Just because you don't shop at Sear's doesn't mean the company is doing poorly.
Anyone who uses Google Spreadsheets must really have nothing to hide if they're willing to trade away their personal data for advertising.
Is here
I tested it and it works good. I couldn't load a 'big' excel or csv file (1.5 Mb) but I wrote a bug report with the online tool. I think that this kind of online application had a lot of potential. Coming soon, many applications will be ported online thanks to AJAX and the webservices (.net, RoR, JSP/JSF, SOAP,..).