Google Blogoscoped

Forum

Google Spreadsheets - new features

Art-One [PersonRank 10]

Wednesday, November 29, 2006
16 years ago5,247 views

The official Google blog mentions some new features for Google Spreadsheets:
* Revisions (yeah great!)
* Publishing feature (link to your spreadsheets in blogs, etc.)

Others:
* Stock value lookup functionality (why not add a generic webservice function?)
* Lookup in Google Q&A (powerfull, but how does that match with the news of closing down Google Q&A?)

More on
http://www.google.com/google-d-s/whatsnew.html

dpneal [PersonRank 10]

16 years ago #

Stock value look-up and Google Q&A inparticular are extremely clever. This is the kind of powerful yet subtle integration I want to see from Google. I'm really impressed with this. Great new features!

Mambo [PersonRank 10]

16 years ago #

>> how does that match with the news of closing down Google Q&A? <<

Q&A is a Web search feature; it's Google Answers that is eventually closing down.

stefan2904 [PersonRank 10]

16 years ago #

this "new" features are "old";
fe., this one is about 1 week old:
http://docs.google.com/View?docid=dfzv8b2j_3dh253q

stefan2904 [PersonRank 10]

16 years ago #

erm, yes, ok, sorry. this is a doc and the feature is only new for spreadsheets.... :/

Mrrix32 [PersonRank 10]

16 years ago #

If I type in a Q&A function (=GoogleLookup) in to GS, asking for someone's age it gives their date of birth.
And the info doesn't all come from Google Answers, most of the one's I've tried come from Wikipedia but there are other sources as well.

dpneal [PersonRank 10]

16 years ago #

are you adding the correct attribute to the the function?
http://docs.google.com/support/spreadsheets/bin/answer.py?answer=54199

Tony Ruscoe [PersonRank 10]

16 years ago #

<< And the info doesn't all come from Google Answers >>

I don't think any of it comes from Google Answers does it? Not unless the Google Q&A algorithms pick up content from there too...

Hanaplas [PersonRank 1]

16 years ago #

also nice one:

http://spreadsheets.google.com/pub?key=pHY1a1ksuajJgAimzaVOREA

Art-One [PersonRank 10]

16 years ago #

Sorry, my fault indeed, I confused Google Q&A with Google Answers.

BTW Feel free to experiment with this features in the For GoogleBlogoscoped spreadsheet in your docs.google.com list.

If you don't have it, I'll give you acces to it :P

stefan2904 [PersonRank 10]

16 years ago #

yes please. mynick at gmail

Ryan [PersonRank 0]

16 years ago #

Phil, the link on the main page doesn't go here correctly... I get an "oops can't be found."

While they're making changes, let me suggest a few (these apply to both docs and spreadsheets)

1.) why is check spelling on the lower right instead of in the toolbar where it belongs? I didn’t even know it was there when I first started using the site.
  
2.) If I’ve already saved… grey out the save button… or do something to let me know that the current document has been saved. If there’s nothing new to save, I shouldn’t be able to click save. Same with discard changes: If there’s no changes, what is it discarding? If it’s remembering since the last time I logged in, then that’s dangerous.

3.) why is “edit HTML” a link originally, then turns into a tab when I click it? That’s confusing and non-consitent.

4.) Preview needs to open in a new window. I click preview.. then there’s no “back” or “edit” button anywhere visible on the top of the page, so I close the window and then I’m gone.. That’s not good.

Mrrix32 [PersonRank 10]

16 years ago #

The Google Lookup function's Good but there's a lot of info it can't find. And for the age thing I put =GoogleLookup("name","Age") And it puts their DOB not age (as demonstrated on the For GoogleBlogoscoped sheet)

[put at-character here]Ryan
1) I like it where it I, it's easy to find
2) I agree
3) I'd prefer a tab all the time
4) I agree

dpneal [PersonRank 10]

16 years ago #

Ryan
1) I agree with you, should be on the toolbar. it is in gmail too!
2,3,4) Agreed

TOMHTML [PersonRank 10]

16 years ago #

Anyway, no charts in this update :(

Philipp Lenssen [PersonRank 10]

16 years ago #

> Phil, the link on the main page doesn't go here
> correctly... I get an "oops can't be found."

Ryan, which link exactly? I tried to repoduce but failed..

Ryan [PersonRank 0]

16 years ago #

the "continue the discussion" at the bottom of the main page post.

I had to find these comments via the forum, not the front blog page where I tried.

Haochi [PersonRank 10]

16 years ago #

Google is about to release an API for the Spreadsheets, though the page is not yet available.
http://code.google.com/apis/gdata/spreadsheets.html

Travis Harris [PersonRank 10]

16 years ago #

Haochi – Just today I had a customer ask me if my software could automatically update a google spreadsheet that they use with sales information. I said no, but maybe I can if they have an API. This is really actually quite cool... Would be nice if I could have the spreadsheet do a lookup in my software though, would be easier.

As with just about ever google new feature roll out, I have found a TON of flaws... for example, if I use
=GoogleLookup("AMD","ticker") it outputs "NYSE:AMD" so, in the next cell, if I use that output for a =GoogleFinance(OtherCell) it does not look it up!

I understand that when it returns a ticker symbol it is just stealing text from some site, but you would think that at least the result for some of the companies would work. This I think could be resolved in just using more fuzzy logic in the GoogleFinance Function.

An Other thing is that you can not use a GoogleLookup directly in a formula. I was trying to do an IF that would take a "#N/A That data is not..." result and just output the text "unknown" But I could not.

Other annoyances.... if I have time I'll post more... Hope Google is reading!

Reto Meier [PersonRank 10]

16 years ago #

Travis: Regarding your problem with stock ticker lookups. I agree that the GoogleFinance lookup should be able to take "Exchange:Symbol" as an argument, it's not too hard to add a cell that translates the Lookup return to text that Finance understands. The following formula will give you the symbol finance is expecting:

=MID(B2, FIND(":", B2)+1,10)

(Where B2 is the GoogleLookup formula)

Oh, and I absolutely agree with your other complaint, not being able to use GoolgLookup directly in a forumla is a real pain, but it just means you need to put the lookups off to the side and create your displayed columns with the If statements based on them. It's annoying but it'll work :)

Reto Meier [PersonRank 10]

16 years ago #

(Oh, and add a TRIM() around that formula – some of the ticker results have unexpected spacing!)

Grayson [PersonRank 1]

16 years ago #

I am trying the IF function and want to test another cell such as

=IF(C10="ADV", 3," 0")

However, for the "false" answer, I would like to incorporate another forumla such as:

=IF(C10="ADV", 3,"(=IF(C10="PRO", 5," 0"))")

Of course, the above returnes an error. Is this allowed in any way?

Thanks in advance.

Tony Ruscoe [PersonRank 10]

16 years ago #

Grayson:

1) The 2nd IF statement shouldn't be in double quotes
2) You only need the equal sign before the first IF

Try this:

=IF(C10="ADV", 3,IF(C10="PRO", 5," 0"))

David Hetfield [PersonRank 10]

16 years ago #

off topic (sorta) ;
how come the "New Features" button isnt bold?
it is on PicasaWeb

Docs:
http://docs.google.com/

PicasaWeb:
http://picasaweb.google.com/

Forum home

Advertisement

 
Blog  |  Forum     more >> Archive | Feed | Google's blogs | About
Advertisement

 

This site unofficially covers Google™ and more with some rights reserved. Join our forum!