Ok, maybe not 'anything' - but pretty close... It uses a lesser known feature of the Google search box. For example, If you want to know how many feet there are in 12 meters, you type "12 meters in feet" and you get your answer. Or let's say your british friend tells you he has a friend who wants to get to know you better - and you say "describe him" and he says, "right... he's got a good personality, and...well... he weighs 14 stone". Of course, instead of seeming like a naive American (of course not, not you), you quickly go to the google search box and type "14 stone in pounds" and then decide... and maybe then you can use this same method to figure out how many USD (yes, that's dollars) you'll need to buy dinner in GBP (of course, that's pound sterling) - it's not a pretty answer.
Well - now that you know that trick - here's the real trick. In a spreadsheet (yes, on Google, of course) you can send that query to the Google search page in the background, get back the answer, parse it and display the answer in your spreadsheet. All this through the magic of the "ImportHTML()" formula.
I'm not going to go into the details of how to do that here - but I will give you a link to get your own copy of this sample spreadsheet (yes, you'll be asked to login to your google account, if you aren't already, to get this spreadsheet added to your doc list).
I must admit, I've had this fun thing (wha? you don't think this is fun?) lying around for a bit - but I figured I should clear the decks given that I've got some new ideas to post...
Monday, March 24, 2008
Convert Anything on a spreadsheet
Posted by
JR
at
9:46 PM
4
comments
Labels: google spreadsheets, spreadsheet tips
Monday, March 10, 2008
Digital Culture what?
In February, I was interviewed on a show (which, for you wine enthusiasts, is the equivalent of the second label of Good Morning America) called Good Morning America Now - shown on cable TV and on the web. This was a bit of a tanget for me, but there was definitely some relevance to cloud computing and the intersection of our social lives and the web.
Funny part #1 was to see how sensationalism drives the media. It's clear from the way they framed this story, that it was deemed interesting only due to the snippets of sensationalism which could be drawn from a consumer survey. Funnier part #2 was how they titled me in the first half of the clip... almost Seinfeld-worthy.
Whatever the result, it was really a fun experience...
Posted by
JR
at
7:11 AM
3
comments
Labels: Cloud Computing, Events, JR, Video
Tuesday, March 4, 2008
A dinner-time story to break the monotony
I looked at my blog today... and I didn't like what I saw... a very sparse set of posts, all of which seemed like boring recalls of what I've been doing in the world of conferences (ouch! I just yawned so wide I pulled a muscle)...
so... just to break that cycle... here's something complete irrelevant:
I haven't felt that feeling of uncontrollable laughter in a while - but last night at the dinner table, my four-year old son triggered it.
he: "Daddy - I saw a squirrel today.."
me: "oh, really?"
he: "yeah...it was dead"
me: "awww... that's sad"
he: "his eyeball popped out"
(I swear, he said it so matter of factly... and at the Dinner table!... and I'm supposed to be the "that's not proper dinner-table talk" daddy, and instead I'm trying to hold back extreme hysterics)
me: (bouncing up and down from in-audible laughter) "oh... uh... that's not great dinner table talk..."
he: "yeah... and a bird was eating it"
me: all-out laughter... no holding back... too much pain...
Sometimes it just feels so good to be 4 again.
Posted by
JR
at
11:10 PM
2
comments
Labels: fatherhood, non-web, stories
Monday, March 3, 2008
Web Services at UPenn's Wharton

I spent my Friday at the Business Technology Conference at Wharton Business School (University of Pennsylvania). Besides feeling under-dressed next to all the MBA students in suits, it was a very satisfying day - I met a new group of great people and learned things about activities in this area (Web Services) which is slowly becoming a standard part of the foundation of business and life.
The Panel I participated in was really high energy (I thought) and interactive. It was entitled: Internet & Web Services Panel, Subtitled: The Web as Platform: How Cloud Computing Will Change the Software Industry. The Panel was moderated by Jeff Barr - Senior Web Services Evangelist, Amazon.com, and the panelists were:
- Alex Chan - Director, Connected Systems Division, Microsoft
- Ramon Estopina - Strategy Director, BT Design, BT
- Adam Gross - Vice President of Platform and Developer Marketing, Salesforce.com
- Rick Treitman - Entrepreneur in Residence, Adobe Systems
- Me
Too bad there seems to be no recording or video of the panel - and not even too much blogging activity about the content, 'cause I think there were some good questions and good points made. If you attended, feel free to comment to either counter that point or provide some detail that you might remember (....crickets...).
Hey Rick - How'd you get the title? I gotta get me one a those ;)
Posted by
JR
at
6:10 AM
0
comments
Labels: Cloud Computing, Events, JR
Monday, February 11, 2008
More conferences and panels about web 2.0
Somehow it seems I've gotten into the habit of logging my participation on conference panels and speaking opportunities here on my blog... not in a timely manner in most cases, but logging nonetheless. So let's continue the tradition with two conferences and panels from the past 2 weeks:
Today (hey - that is timely!) I was at the Web Services on Wall Street conference, on a panel entitled "Beyond Web 2.0" (with a much longer subtitle which related it back to the enterprise). On this panel, I joined Tom Steinthal from BSG Alliance (Moderator), Marc Adler from Citigroup, and Michael Ogrinz from Bank of America. This session really dug up some old (for me) large corporate investment banking memories and challenged me to relate all that to my current role... interesting... fun...
Two weeks ago, I was at the Web 2.0 conference put on by WebGuild in Santa Clara, CA two weeks ago - my panel was called "Future of the Web Office", where I was joined by Raju Vegesna and moderated by Ismail Ghalami.
Posted by
JR
at
5:54 PM
0
comments
Monday, January 21, 2008
Computing in the Cloud at Princeton U
I participated on a Panel at Princeton University last week, as part of the "Computing in the Cloud" workshop, hosted by the Center for Information Technology Policy. Definitely a valuable experience for me... I met great people and learned from other panelists and participants. The panel I was on - moderated by Andrea LaPaugh and called "What's Next", included Reihan Salam and Jesse Robbins - both of whom are great story tellers and brought completely different perspectives to the subject.
Overall, panelists and attendees of the workshop conveyed a general net positive attitude, balanced with useful caution regarding privacy and security, with strong hope that Cloud Computing (should I be capitalizing that?) will bring increased transparency to such things as government collected information. As in most areas of new technology ("new" is a relative term), there are some valuable pessimistic views which keep people like me - call me a pragmatic optimist - deeply appreciating the skills of security and legal specialists who act as the sherpas (lower-case 's') in their respective mountain ranges (or jungles). I personally still have a strong view that "I trust the cloud more than my laptop" - to sum it up as simply as I can. You can watch the video of our specific panel (that one alone is 90 minutes - and all the others are also posted thanks to the UChannel). I also thought it might be useful to post the notes I put together before the panel, to organize some of my thoughts (opinions) about Cloud Computing...
(click here for the whole post, including my pre-panel notes)
My notes used at the panel:
> Containers for gadgets > platform for gadget development > gadget types (content free) > content-relevant gadget instances
- Maybe even a Premium "absolutely private" web
ISSUES LIKELY TO OCCUR - which, themselves, drive opportunities...
Note: These were just my notes that I used for the panel, since the format included each panelist giving a 10-15 minute no-slides discussion of their views. Nothing Google in here - just some semi-random personal views and not organized into a standalone presentation.
Posted by
JR
at
9:42 AM
0
comments
Labels: Cloud Computing, web 2.0, web products
Wednesday, January 2, 2008
Sarcasm can ruin a kid's vocabulary
(First of all - Happy New Year to those of you who haven't heard that useless greeting enough already - I know, none of you)...
Over the break, I had a few interesting revelations... well... one... well... maybe not interesting, but, revealing, if nothing else...
My 4 year old asked me something about something (huh?) - I can't remember actually what it was - but it was something like "Hey Dad! " (which I'm sure he repeated 7 times before being convinced that he had my undivided attention) - "look at this thing I made! Isn't it cool?"...
...to which I replied: "Yeah - that's great!!"
(here's the semi-interesting part...)
He said: "What does that mean?"
JR: "What does what mean?"
4yr-old: "great"
JR: "great? You know what 'great' means! ... don't you?"
4yr-old: " " (stare at daddy until he realizes that you thought you knew what it meant until now)
JR: "great - you know, 'GREAT!' - like 'That's really great!' - it means really really really super good!"
4yr-old: "Oh, yeah... 'great'!... that's great!"
Then I realized... He had heard the word 'great' lots of times... from me, and others... but in a very different context... like, when he spills milk all over the table and floor, and I say 'Oh, that's great'... or when we miss his brother's school bus, and I say 'oh great'...
You get the idea...
great = 'not so great' in the bizarro world of sarcasm where adults find minimal humor in the context of something not so great and kids who are learning their native language find confusion and reverse meanings for everyday words.
My seven year-old, on the other hand, loves sarcasm - and is likely half the source of his brother's confusion...
It might kill the effect to add "That was sarcasm - I actually mean the opposite of what I just said" to the end of every sarcastic comment I make at home - so maybe I'll just stop....
nah.
Posted by
JR
at
8:57 AM
0
comments
Labels: fatherhood, parenting, philosophy, stories



