Reality Bites
![Click here to read MyWeather Is a Customizable, "6X More Precise" Weather App for iPhone, Android, and Web](http://betacache.gawkerassets.com/assets/images/17/2011/05/small_1300-aotd-myweather.jpg "Click here to read MyWeather Is a Customizable, "6X More Precise" Weather App for iPhone, Android, and Web")
iPhone/Android/Web: There are so many weather apps available that weather is its own category in the mobile app stores. MyWeather is a new app that promises 6x better precision than The Weather Channel, Accuweather, and others, as well as more personalization. More »
Starting today, we’re rolling out pivot tables in Google spreadsheets. Pivot tables make it easy to process and summarize large data sets in seconds. Check out the video below for a look at how pivot tables work in Google spreadsheets:
In essence, a pivot table does just that — it allows you to “pivot” or rotate data, thus looking at it from different angles and seeing a variety of patterns which may not be immediately obvious. Let’s take a very simple example of a list of students. This list includes a number of students and some information about them, including gender, class level, and major.
To create a pivot table, select your data and go to Data > Pivot Table Report. In the pivot table report editor, you can add fields to set your rows, columns, and values and can drag and drop the fields around within the editor. Here, we’ve used pivot tables to display the number of students in each class level by gender.
Fields in the Values section can be summarized using built-in formulas to sum, count, or otherwise calculate your data. In the example above the number of students in each class level was summarized via a simple count.
The filter section lets you specify exactly what data you want to be included in the pivot table. For example, we can choose to only count the students in certain extracurricular activities.
With each change, the pivot table is updated in real-time for both you and any collaborators. If you prefer to make changes in batches, you can switch to manual mode. In this mode, your changes won’t be saved until you select Update table.
You can try pivot tables out for yourself using this template or by using your own data set. Please note that pivot tables from Microsoft Excel can’t be uploaded to Google spreadsheets at this time.
We hope you’ll enjoy exploring pivot tables in Google spreadsheets and that they’ll save you time analyzing your data. Check out our help content for even more examples.
Posted by: Matt Ziegelbaum, Software Engineer
Well, that was fast. Almost immediately after Google unveiled Android 3.1, Motorola was first out of the gate with an update, and now, not even a week later, Acer and ASUS are following suit with plans to freshen up their respective tablets with the newly minted software. To recap, 3.1’s benefits include resizeable widgets, support for USB peripherals, and new Movies and Books apps, among other perks. Acer confirmed to us that it aims to start selling the Iconia Tab A500 with 3.1 next month, as well as upgrade existing units running Android 3.0. ASUS, meanwhile, has been touting the impending update for the Eee Pad Transformer on its Italian Facebook page. To which we say, grazie!
Acer Iconia Tab A500 and ASUS Eee Pad Transformer getting Android 3.1 updates in June originally appeared on Engadget on Tue, 17 May 2011 15:41:00 EDT. Please see our terms for use of feeds.
Permalink 
ThisIsMyNext | 
ASUS Italia | Email this | Comments
With buzz picking up this week that the owners of the Atlanta Thrashers are in talks to sell their franchise to Winnipeg-based True North Sports and Entertainment, a lot of hockey fans are already wondering what division the relocated team would play in next season. Here are a few ideas.
In your daily Netflix news, the latest report on Global Internet Phenomena for spring 2011 from Sandvine has called out the movie service as the largest single consumer of bandwidth on the internet in North America. The last report in October suggested it made up around twenty percent of internet traffic during prime time, but this time around the stats say it accounts for 30% of traffic during prime time, and 22.2% of daily internet traffic. Sandvine gets the data from ISPs using its broadband technology and now foresees “Real-Time Entertainment” (which includes Netflix) shooting up over 55% of peak internet traffic by the end of this year. It also reports on net traffic from other regions, noting social networking outpaces YouTube traffic in Latin America, while European subscribers use twice as much data as North Americans. We’ll have to wait and see if these stats are waved in our faces to justify the next round of bandwidth caps or throttling, in the meantime you can click through for more stats or hear about it from Sandvine CEO Dave Caputo discuss them in a video embedded after the break.
Continue reading Study finds Netflix is the largest source of internet traffic in North America
Study finds Netflix is the largest source of internet traffic in North America originally appeared on Engadget on Tue, 17 May 2011 14:43:00 EDT. Please see our terms for use of feeds.
Permalink | Sandvine, YouTube | Email this | Comments
We might be on the verge of the biggest archaeological discovery in art history. A tomb in Florence could hold the remains of the model who sat for Leonardo da Vinci’s Mona Lisa some 500 years ago. More »
This year it’s become clear that data is scaling to such an degree that you have to change how you manage your desktop and your entire information architecture in order to not just manage your daily work but to succeed.
It’s the core issue of our day, one that’s that’s a top priority when planning to adopt a virtualized infrastructure that allows for people to access apps from tablets and smartphones.
The first step is to get a perspective on the size of the data. This infographic shows what a yottabyte represents in comparison to other terms for units of measurement. It may seem far out to think in such terms but considering projected storage requirements, the concept doesn’t seem so far fetched.
Sponsor
Murder for hire doesn’t have to be sexy, but it’s just more fun that way. And the best assassins are almost always sexy, using their sexual allure to confuse their prey and delight everyone else. More »
At the end of April Google announced that Android OS 2.3.4 would be available over the “next few weeks” for the Nexus One and Nexus S. This update gives video chat to Google Talk and Canadian Nexus S users are reporting that 2.3.4 has been slowly rolling out since this morning to Rogers, Bell, Telus […]
Related posts:
This photo, purportedly taken near Louisiana’s Morganza Spillway, is simultaneously horrifying and kind of amusing. The snake just looks so purposeful, with its head raised like that. As though it’s out running some errands, or on a morning commute.
That said, I kind of hope somebody spots the pixels that prove this image is a fake. Because the idea of giant snakes hanging out alongside American highways gives my feet a terrible case of the crawling willies.
Via Michael Pata
Arnold Schwarzenegger and his wife, Maria Shriver, separated after the former governor revealed he had fathered a child with a member of their household staff, The Los Angeles Times reported Tuesday.
U.S. diplomatic cables released by WikiLeaks reveal an American perspective on Canada’s ‘inferiority complex’ when it comes to its powerhouse neighbour.
It may be a bit difficult to pay attention to the spate of Honeycomb tablets that seem to be popping up left, right and center — you know, now that Ice Cream Sandwich has been officially promised — but what’s not easy to overlook is an 8.6mm slate. Checking in at a sliver of a pinch thinner than the illustrious iPad 2, Samsung’s rethought-out, redesigned and definitely-not-renamed Galaxy Tab 10.1 is the first Android tablet to date that seriously goes toe-to-toe with Apple in both specifications and design. Granted, the consumer models aren’t slated to ship out until June 8th, but given that Google handed us one last week during its annual I/O conference, we figured we’d spend the following weekend wisely. You know, photographing, benchmarking and testing this thing to the hilt. (Of note, the unit tested here was the Limited Edition model, devoid of TouchWiz, 3G and a microSD card slot, but is otherwise identical to shipping units aside from the design on the rear.)
The Tab 10.1 — not to be confused with the older, since-relabeled Tab 10.1v — weighs just 1.31 pounds (marginally besting the iPad 2’s 1.33 pound chassis), and if looks could kill, few people would’ve made it out of Moscone West with all organs functional. But as you well know, style only gets you in the door — it’s the guts, the software, and the marriage of it all that makes or breaks the tablet experience. Hop on past the jump to find out why we think Samsung truly delivered on the promise of a Google-powered tablet, and why you should all seriously consider socking away funds as early June approaches.
Continue reading Samsung Galaxy Tab 10.1 Limited Edition review
Samsung Galaxy Tab 10.1 Limited Edition review originally appeared on Engadget on Tue, 17 May 2011 12:00:00 EDT. Please see our terms for use of feeds.
Permalink | | Email this | Comments
Saskatchewan’s forest fire season has begun with 27 fires burning, including one covering more than 800 hectares.
Filed under: TV News, The Show Girl
Huddy fans, you better have a seat: Lisa Edelstein will not return to ‘House’ for the show’s eighth (and probably final) season.
According to Deadline, Edelstein and costars Omar Epps and Robert Sean Leonard were not under contract for the eighth season. However, Epps and Leonard signed new deals and Edelstein was expected to … until she decided not to.
“After much consideration, I am moving onward with a combination of disappointment at leaving behind a character I have loved playing for seven years and excitement of the new opportunities in acting and producing that lie ahead,” Edelstein said in a statement.
As part of the new deal that was being negotiated, the actress had been asked to cut her per episode salary.
We’ve long assumed that the double decker disaster scenario of a massive earthquake and tsunami caused the Fukushima meltdown. Turns out, all it took was the former, which knocked out Fukushima’s cooling in less than 10 minutes. More »
Moonplayer is a free streaming video site that endlessly plays music by your favorite artists using YouTube content. The service takes a Pandora-like approach to playlists, as it only allows the user to choose the artists, not the songs. Unlike Pandora, however, MoonPlayer only plays music by artists you add to the playlist—and it never stops playing unless you pause it. More »
Looks like Acer’s 7-inch Iconia Tab A100 has opted for a fashionably late entrance. We’ve just been informed by the company that its Honeycomb-sporting, Tegra 2-powered slate will not be arriving, as had been expected, right around now, but will in fact make its debut in the second half of 2011. No reasons have been given for the move, other than to say that the device has been postponed. The thing that prompted us to query Acer’s PR team was a report out of Poland suggesting the A100 had been cancelled. Acer’s UK reps are adamant that’s not been the case, but anyone who was looking forward to grabbing one soon will be disappointed either way.
Acer postpones Iconia Tab A100 launch to second half of the year originally appeared on Engadget on Tue, 17 May 2011 06:39:00 EDT. Please see our terms for use of feeds.
Permalink | | Email this | Comments
