Filed under: Applications, Excel, iPhone | Tags: Applications, Excel, iPhone, Spreadsheets
Today sees the launch of an iPhone app that attempts to fulfill the store’s original promise by adding a truly useful feature to the iPhone that many have longed for since its introduction: modifiable spreadsheets.
The iPhone has allowed users to view Excel and Numbers files since its launch, but until now users have been unable to create or edit them.
The aptly named Spreadsheet application is available for $7.99 here, claiming to be the first Excel-like program on the platform. And it delivers, but with one deal-breaking caveat.
Included among Spreadsheet’s features are:
-Multiple cell types, including Numeric, Date, Time, Currency, Percentage and Text
-Cell formatting options, including bold, italic, text and background color, cell sizes and alignments.
-A range of functions, including date/time, math, statistical, string and trigonometric functions.
-Export (via email) to external spreadsheet applications.
The program’s most glaring flaw is its inability to import Excel spreadsheets – something the developer promises to release in the next update, but should have been included from the start.
This oversight will make the program nearly useless for most professionals, but if you’re only looking to make basic spreadsheets on the fly it works as advertised. Files made on the phone are saved in the standard XML format, and can be Emailed for further modifications on PCs.
The interface will be familiar to anyone who has used Excel or a similar program before – you use your finger to select cells, and can enter numbers and equations using the same syntax.
Spreadsheet may be the first app available in this space, but a number of other offerings are on the way, including Mariner.
Filed under: Analytics, Data | Tags: Applications, Data, iPhone, Statistics
Want to drill down to see how different iPhone apps are doing? You can click around iTunes and collect your own data, or you can visit the Application Ranking section of Mobclix and see the breakdown of iPhone apps in each category. Paid apps still outnumber free apps.
Of the 3,420 apps in the iTunes App Store, a full 2,604 (76 percent) are paid, and only 816 are free. (About the same ratio since the App Store launched). Games dominate (31 percent of all apps), followed by utilities (15 percent) and entertainment apps (12 percent).
Within each category, you can sort apps by rank, price, rating, or release date. And if you click on a specific app, you will get a chart showing its rank over time—something you can’t see in iTunes. For instance, Tap Tap Revenge is maintaining its early strength, and is currently ranked No. 8.
The No. 1 free app is Air Sharing (which turns your iPhone into a wireless hard drive) shot up quickly in the rankings after its launch on September 8.
In contrast, the No. 1 paid app, PocketGuitar (which turns your iPhone into a digital guitar) launched on August 26 and worked its way up more gradually in the overall rankings to its current No. 40 spot.
Filed under: Analytics, Data, Visualisation | Tags: Applications, Data, Flowing Data
mycrocosm is a project from the MIT Social Media Group that is similar in spirit to Daytum. The main difference is the interface. Users send Twitter-like messages via SMS or email to add to their personal datasets.
Me-trics is described as a Google Analytics for, well, you. It’s sort of an aggregator of all your personal data from applications like RescueTime, Twitter, etc. You can also enter data manually, and then it does some statistical voodoo (which sort of worries me) to find correlations. Not so sure about that part. It will offer an API, however.
Let’s face it. We all waste time, and when we do, we feel like a lazy bum. There are plenty of applications that help you keep track of how you spend your minutes.
Most of us have heard of Basecamp, which is used by many for project management. We use it here at Mark.
Start it up, run it in the background, and visit your dashboard to find how many hours you spent watching YouTube last week.
Trixie Tracker is designed to monitor your baby’s habits – poo, pee, sleep, and eating.
What are your peak tweeting hours? Find out with Twitter Charts.
Wakoopa is sort of like RescueTime, but I think it’s more about the video games.
You want to live a long and healthy life, don’t you? You better keep track of your bodily functions and what not.
Mon.thly.info is an application for women to keep track of their monthly cycles and stuff.
When is the last time you had sex?
I’m happy. Now I’m sad. Wait no, I’m happy. I’m perplexed. Confused. Crazy. Happy again. Oh life, you are an emotional roller coaster you are.
Record your moods and evaluate over time with Moodstats.
lifemetric is similar to Moodstats, although it sort of has a social component to it too.
How fit are you?
Use Traineo to track what you eat, how you exercise, calories lost, and all that good stuff.
From Garmin, MotionBased lets you upload GPS data and keep track of your runs in the park.
You put something on your shoe, connect it your iPod and you get feedback as you run.
Graph your weight.
Keep track of all your finances in one spot.
Mint, grabs data from your bank, credit cards, and investments.
With all our environmental concerns, we should all be aware of our driving patterns.
Plug CarChip into your car and it automatically records your driving behavior like speed, braking, etc.
My Mile Marker
I know there are a lot of people who write down their mileage and money spent after each gas fillup. My Mile Marker takes that data and helps you make sense of it.