Webware

The hottest hotspots in New York...for nerds.

(Credit: Sam Lessin)

Just how powerful can the data behind a location-based application be? Extremely.

Earlier this month, the second annual Internet Week New York took place, and Dropio founder and certifiable data nerd Sam Lessin crunched a bunch of numbers based on what his contacts on urban navigation and friend-finding service Foursquare were doing. Lessin was working with a group of fewer than 100 contacts, almost all of whom are involved in the tech and new-media industries (this is the scene that birthed Foursquare and its predecessor Dodgeball, after all), and yet it's a fascinating peek at just how much this kind of data can reveal. He's posted it on his personal file "drop" on Dropio.

Lessin trawled through the data to find what time people checked into coffee shops in the morning (and whether they were doing this earlier or later on a given day), how much people "lost steam" over the course of a party- and conference-filled week, and how much the most popular gatherings actually matched up to the Internet Week New York official schedule. As it turns out, the hottest parties were impromptu, unofficial gatherings at the Standard Hotel and, um, Sing Sing Karaoke.

Obviously, this isn't perfect. Foursquare updates are voluntary, which means that data can't say a thing about what people are doing when they aren't telling the app about it. The presence of an app like Foursquare, too, can also skew social activity: word about the massive impromptu party at the Standard Hotel bar, for example, spread when the Foursquare check-ins started snowballing.

But when you have enough people participating--which, as of yet, Foursquare does not--the critical mass starts to correct some of those issues. It's a fascinating sneak peek at what sort of value this data could have down the road.

What we can also look forward to: pretty infographics, Orwellian privacy concerns. Eek.

Data visualizations are a great way to make something complex more easily understood from any spreadsheet or table. Verifiable, a free visualization tool does just that, by quickly organizing uploaded data sets into charts that can be customized and manipulated using a drag and drop control scheme that feels a lot like making a playlist in iTunes.

What's interesting here is that the service is putting both the charts and the data in the same place, so you can go behind the curtain to double check to see the source numbers. The other day when we wrote a follow up on the TechCrunch50 and Demo conferences and showed what was live and what was dead, we included charts, but in order to back everything up we had to drop the source spreadsheet in there, too. With Verifiable, the source data would have been there, but only seen when users clicked on the charts.

There are number of ways to get your data onto the service. You can upload from your hard drive, or paste the data by pasting it into a text box. However my favorite is by linking it up to Google Docs and Spreadsheets which lets you suck in your data from the cloud. You can even narrow it down by what part of the spreadsheet you want to get the numbers from.

I'll be honest here, I don't have a whole lot of use for this in my daily routine, but compared to some other data comparison services like Tablefy, iCharts and Swivel, Verifiable's Web app feel seems more attuned to folks who need to remix and re-order data they already have.

Here's a sample chart. To see all the fun data behind it, you'll have to click on it.

I spend a considerable amount of time perusing financial sites for data that impacts a respective company's financial statements. Because of that, I've developed a liking for certain sites, and a severe distaste for others that have no business providing information to anyone.

But it's the great that I'm highlighting today. And in the following list of services, you'll find some obvious choices and hopefully some new services you may have never seen.

Emerginvest

One of the main issues facing sites like Bloomberg or MarketWatch is that most of their focus is placed squarely on U.S.-based companies. It makes sense--most of the visitors to those sites are looking for information on companies that operate in the United States. But that doesn't mean we don't need international data, and that's exactly what Emerginvest provides.

The self-proclaimed "Yahoo Finance for the rest of the world," Emerginvest provides outstanding financial data about companies that are operating outside the U.S. Once you register for the site, it displays a "heat map" detailing the performance of markets around the world. That's just a starting point for what is a deluge of financial information about companies operating in over 120 countries. That data includes news, market overviews, sector data, individual company performance, analysis, and much more.

Even better, Emerginvest provides a link to brokerages that allow you to purchase the security in international markets. Unfortunately, though, I've found that few brokerages will allow their clients to acquire obscure international securities.

Emerginvest's claim that it wants to be the "Yahoo Finance for the rest of the world" is a bit troubling, though. What would stop Yahoo, Google, or any other major firm from creating a similar service that would put this company out of business?

Investopedia

If you want to research stocks and mutual funds, while learning about them, Investopedia is the best place to do it. With thousands of articles on investing, the stock market, and other financial topics, Investopedia offers an exceptional amount of value to the novice and professional investor alike.

The real beauty however is in the breadth of information it provides. Want to learn how to buy a security for the first time? It will walk you through the process. Want to learn about pink sheets? Investopedia has your answer. Oh, and if you want to find out if Google is a good buy right now, Investopedia will fill you in with analyst opinions, historical prices, and much more. Suffice it to say that if you're looking for anything related to business, Investopedia will have it.

It's that good.

StockCharts

Sometimes, when I use Yahoo Finance, I take historical stock price charts for granted. After all, they're really only useful to show price differences of a particular stock over time, right? But when I find my way back to StockCharts, I can't believe that I even considered using Yahoo Finance charts to make a decision about a company.

StockCharts doesn't just provide historical share price data in its charts, it provides a full solution for analyzing the value of a stock. Along with price changes, it can display key indicators of financial health like Moving Average Convergence/Divergence, Relative Strength Index, Moving Averages, and Volume. It even lets you embed those graphs into your own site, social network profile, or presentation if you want to share the information you've gathered with others. That said, be aware that a couple trips to Investopedia may be in order--StockCharts is specifically designed for those who are knowledgeable about investing and have a keen understanding of company valuation.

ValueEngine

If you want to know what a stock is really worth and you don't want to do the heavy lifting with a service like StockCharts, ValueEngine is the perfect alternative. There's only one catch: you'll need to pay $199.95 per year or $19.95 per month to do it.

ValueEngine provides accurate valuations for any stock you throw at it. According to the company, it analyzes each stock based on a number of key factors and ratios to determine what a share should be priced at and whether it's a good buy or not. Upon entering a particular security, ValueEngine provides extensive data that not only gives you a valuation, but financial evidence to support its claim. It even runs market trend analysis and price reversal calculations to estimate stock performance over the next few years. I'm not convinced that kind of long-term planning is reliable, but it's tough to argue with the company's success: it claims its recommendation engine enjoyed a 25 percent rate of return during 2008.

Yahoo Finance

Any mention of financial data research cannot be complete without talking about the de facto leader in the space, Yahoo Finance.

Although some prefer Google Finance to Yahoo's because of its slightly less-cluttered design, I don't think it compares to Yahoo's page. Combining news, analyst opinions, key ratios, and charts with an outstanding design that makes it simple to navigate from one security to another, Yahoo Finance is set apart as the most useful financial research tool on the Web. And although it's lacking in international data and Google is making inroads, Yahoo's finance page provides the best information as quickly as possible.

Any time I hear a company reference their product as a "YouTube for _____," I cringe a little. Newcomer iCharts said the same thing about its charts product at its presentation at the TechCrunch50 conference this morning. The service takes your data from spreadsheets and turns it into charts that are both hosted on the site and can be embedded elsewhere, including things like PowerPoints, message boards, and PDFs.

What makes iCharts less worthy of the YouTube cringe is that it's a solid business model. As billionaire panelist Mark Cuban pointed out, you can leverage out this technology to other companies that want to make their charts suck less, making a quick buck as a service provider instead of ending up as a destination site for orphaned sales charts.

The service has a few tricks up its sleeve, including a building tool that lets you drag and drop data sets from a centralized document list. You can add as many sets as you want as long as the X & Y data axis match up. This comes with a live preview of what your charts will look like on the site, letting you see how it looks before hitting the publish button.

Also included is search engine optimization and the option to leave short audio annotations that can be attached to each chart. These clips follow it along wherever it goes, even on PowerPoint presentations, which means you can put together a pretty slick presentation that plays itself without using any other sort of narration software.

The service is launching later today with the tools to upload and build, along with a portal that shows off user charts that have been set as public.

You can adjust what you're seeing with the slider on the left. All the data on this chart is also SEO friendly, making your data accessible on major search tools.

(Credit: iCharts.net/CNET Networks)

Are you a stats junkie? If you're like me and could make comparison charts all day long you should check out Tablefy, a simple service that lets you quickly put together large and complex tables of data. You can compare whatever you want, and there's already a handful of user-created data tables like superhero stats, sports car specifications, and even a well-done chart of several popular blogging tools going head-to-head.

The tool is set up just like any old spreadsheet, except that you can predefine any row by what you're planning to put in it. You can drop in text and numbers or insert media like a YouTube video or hosted photo. In the chart embedded below I managed to throw in two videos with just a copy and paste. You can also increase your fill-out speed using simple keyboard shortcuts that let you skip ahead either by row or column. Some of the auto-formatting is especially well done. For example, writing yes or no automatically turns the cell green or red respectively. Trying to do that in Google Spreadsheets can be a pain unless you've got a template set up or take the time to format the cells.

What makes the tool really neat is that you can grab any bit of data from another chart and add it to your "comparison basket." It will automatically link up any related data like height, weight, age, etc., and put it in the right row across all the tables you've added. This lets you come up with crazy combinations. For example, I compared the XBox 360 to Iron Man (both awesome). More beneficial creations include a presidential nominee comparison, popular water filters going sink-to-sink, and a listing of poisonous plants to avoid.

Chart creators can also declare a winner between each column of data. Likewise anyone who reads that chart can agree or disagree through the comments or with a simple radio button.

Tablefy reminds me a lot of data comparison and tracking service Swivel. The big difference between the two being Tablefy's focus on just charts, whereas Swivel branches out into scatter plots, bar graphs, and pie charts. Swivel also has a huge head start on user- and service-generated data. For use in things like term papers or business reports, users are likely to see Swivel if only for this richer mass of searchable data.

To see an introductory video of Tablefy, hit the break below.

go to the table!

... Read more

Stories about animals are a staple for the nightly news and frequently make their way to the front page of news sites such as Digg and CNN. Not to be left out, Purina, purveyors of food for dogs and cats has its own social news site devoted to all things domestic pet with Pet Charts, a self-proclaimed "definitive guide to the best pet stuff online." It features news stories, videos, and photos for dogs and cats.

Users can swap between either species or view both at once. Content is ranked numerically and can be voted on by clicking the green paw buttons next to each story. Voting requires no user registration, and the stories are aggregated automatically from several different sources. Not included is a way for users to add their own content, or tools to place the paw buttons on external sites to encourage users to add additional votes.

Pet Charts is no icanhascheezburger, but it's certainly worth a look. In comparison with other social news sites, Digg has its own pets and animals section in the offbeat news category. Much of the content on Digg is relegated to videos and photographs, while Pet Charts splits it up into three different sections. Social news network Mixx also has its own pets category that's got an eclectic mix of its own.

[via Digg]

Can dog and cat food makers topple Digg's pet news section? More importantly, how cute is that dog? Awwwwwwe. (Click to enlarge)

(Credit: CNET Networks)

Best4c says it's the "best online diagram tool on earth." A pretty lofty claim, considering how many other chart utilities are out there that have similar feature sets (see Gliffy, mxGraph, Ajax13, Floor Planner, etc.) Best4c offers up a simple drag and drop editor, with a four-pane interface that mimics a other desktop drawing apps. You can pick from a fairly large selection of items to drag into your virtual space, including items for floor planning like desks, couches, and houseplants, all the way to flow chart tools to use as a virtual whiteboarding space. There's even an option to upload your own image, although I couldn't get this feature to work.

Rotating and re-sizing objects is a simple and intuitive. There are also controls to bring various elements up and down on the virtual canvas. The entire environment runs in Adobe Flash, and is very responsive--right down to the sliding control panels which expand and contract to open up each set of icons. When you're all done with your work, you can save it to your virtual storage drive. Each time you do this you get also get a simple URL you can give to others for sharing.

So what do you do with a tool like this? I took the time to re-design my office space. It's also helpful for putting flow charts you might have written down in a meeting, onto something that's able to be shared with others. Unfortunately, there's no collaborative workspace--which means you can't work on a chart with someone else at the same time. For collaborative editing however, anyone can take a publicly shared chart and make edits, saving their creation as a new version, while the old remains unchanged.

So is Best4c the "best online diagram tool on earth"? Frankly I haven't tried them all, and despite a few hiccups, I'm giving it a thumbs up. Just one minor suggestion though, the name doesn't really roll off the tongue.

Related: Floor Planner helps to plan your pad

Design your future dream office with Best4c's design tools. Everything is drag and drop.

(Credit: CNET Networks)

Setting up a basic pie chart in Google Spreadsheets

(Credit: CNET Networks)

Last week, Google quietly upgraded its online spreadsheet application, Docs and Spreadsheets with a charting function. Like almost everything else about Google's online apps suite, the charting tool is barebones yet useful, and benefits from being part of a suite in which collaboration is easy.

Creating a chart is easy. Just select a range of data, click on the little chart icon, and choose your chart type and a few options. You can't change colors or typefaces, or modify most of things people take for granted in a typical spreadsheet like Excel.

The new charting function is useful to help you visualize basic data, and it's a necessary precursor to Google's upcoming presentation app. But people looking to go beyond the basic representation of data--those wanting to fine-tune their visuals a bit--will find the feature lacking.

With this update to its spreadsheet app, Google made some other enhancements, which are covered in this official Google blog post.

Over on our sister blog Crave, we post about the occasional stargazing gadget for amateur astronomers. But if you aren't willing to shell out the cash for a pricey telescope, night sky projector, or home planetarium, never fear--that's where the wonderful world of free webware comes in. Wikisky was described by the Wired Science blog as "Google Earth for space," which is essentially an apt description. You can use Wikisky (which isn't actually a wiki, for the record) to view and navigate the entire night sky either as a graphical representation, or in legit photographs courtesy of the Sloan Digital Sky Survey.

(Credit: Wikisky)

The interface isn't as easy to get the hang of as Google Maps or Google Earth's, but then again, I don't think very many of us are as familiar with the night sky as we are with a world atlas. It also was a bit slow to load, even in the graphical form, and it is more difficult to zoom in and out because Google Maps' quick keyboard commands don't apply.

This appears to be very much a project in the works--currently, only a quarter of the night sky is available--but I think it's ultimately a great idea. If Wikisky can keep growing and adding more functionality, I can see this being an awesome information resource, and an even awesomer time-waster.

See also: The downloadable app, Stellarium (for PC, Mac).