Sparklines, Charts Reduced to the Max

I’m a huge fan of Edward Tufte’s Sparklines, although I have to confess I haven’t used them as much as I should in this blog. Here’s a couple to illustrate what they’re all about: Wifi and media coverage. But the problem has been a shortage of tools to automate this. Here’s another, from Andreas Flockermann, founder of
BonaVista Systems – Sparklines, Dashboards, Charting for Excel and Microsoft Business Intelligence
who has created something called MicroCharts (cool name) — “charts reduced to the max” (cool tag.)

I’m going to try it out.
 

Coming To Your Phone Soon: Sparklines

For sparkline enthusiasts: The guys at Bissantz tell me their SparkTicker is now available for download, creating sparklines for Excel, Word, PowerPoint, HTML and information tickers:

SparkTicker exports your data to both your personal ticker on your screen and/or a marquee you can post on a website, see the top of this page for examples.
Download area

SparkTicker Excel Add-in requires Microsoft Office 2000, XP or 2003 and the .NET Framework. You are free to evaluate SparkTicker in a non-productive environment. Please note that SparkTicker is still in beta phase. Download and install is at your own risk.

What’s perhaps most interesting about all this is Bissantz’s idea that sparklines might work on cellphones:

Sparklines not only make sense as a powerful means to increase the analytical depth of a text, they can also add information where space is scarce. Imagine your company’s most critical performance measures being sent to your cell-phone, while your away from the office. Or get the updated seasonal data of your favourite soccer team the minute the last game is over.

News: A Patch In Time Saves You Online

 This from the guys at Information Security Magazine, a warning about some new, and serious vulnerabilities in Microsoft software. The most critical vulnerability is titled ?Flaw in Visual Basic for Applications Could Allow Arbitrary Code Execution? (MS 03037). Microsoft provided few details about the actual vulnerability, but says the flaw is dangerous and users of affected software should apply patches immediately. This is not just for techheads and sysops: Affected software includes Access (97/2000/2002), Excel (97/2000/2002), PowerPoint (97/2000/2002), Project (2000/2002), Publisher 2002, Visio
(2000/2002), Word (97/98(J)/2000/2002), Works Suite (2001/2002/2003) and several versions of Microsoft Business solutions.
 
There are other vulnerabilities too:
?Flaw in Word Could Enable Macros to Run Automatically? (MS 03035)
?Buffer Overrun in WordPerfect Converter Could Allow Code Execution? (MS 03036)
?Unchecked Buffer Overflow in Microsoft Access Snapshot Viewer Could Allow Code Execution? (MS 03038)
?Flaw in NetBIOS Could Lead to Information Disclosure? (MS 03034)
 
If we’ve learned nothing in the past month, we should have at least learned to patch, patch and keep patching.

Update: Documents To Go For Dana

 Further to my review of the excellent Dana keyboard, its makers AlphaSmart, Inc. have announced they plan to offer a wide-screen version of DataViz’s Documents To Go Professional as a bundled software option for new versions of Dana. Documents To Go enables Palm users to work with Microsoft Office documents, such as Word, Excel and PowerPoint.
 
 
I found the Dana an excellent alternative for writing in certain conditions when you just want to get away from your desk, your office, your family, your town. It’s not everyone’s cup of tea, but with tools like Documents To Go, the lines between laptop and Dana tend to blur.

Column: WordPerfect Office

 
Loose Wire — Office Challenge: Corel Software’s latest version of WordPerfect Office has some great features, including a dictionary to die for and fumble-free format switching; Is it time to ditch Microsoft?
 
By Jeremy Wagstaff, from the 8 May 2003 edition of the Far Eastern Economic Review (c) 2003, Dow Jones & Company, Inc.
 
It requires a brave soul to take on Microsoft on its home turf. Even more so when one of the main selling points is a blue screen that nostalgically reminds users of their youth.

Enter WordPerfect Office 11, the latest version of Corel Software’s suite of applications that is supposed to be an alternative to Microsoft Office, the lumbering behemoth that accounts for more than 90% of the “desktop office-productivity applications” market (in other words: word processing, spreadsheeting, making slide shows to impress the boss). At $300, it’s quite a bit a cheaper than Microsoft’s offering, and with its flexible upgrade policy, it means you can more or less trade in any competing Microsoft program for about $150. Not to be sniffed at if you’re tired of shelling out for a whole department’s worth of word processing. Oh, and for legal eagles and apparatchiks who love the old DOS, blue-screen look of WordPerfect, there’s that too, along with most of the original keystrokes.

But does it really make sense to ditch Microsoft Office? There are plenty of reasons you might not want to: While the main elements of WordPerfect Office are similar to those of Microsoft’s, don’t expect to find all the commands and keystrokes in the same place. That means you and your cohorts will have to unlearn quite a lot. And there are bits missing: There’s no e-mail program in this version, for example. While I found some elements of the word-processing part of the suite useful, I encountered what can only be called weird formatting issues, which nearly cost me this column.

But there are some positives. It will run on operating systems from as far back (gasp) as Windows 98, whereas Microsoft Office 2003 will only run on Windows 2000 and XP (go figure: it takes a non-Microsoft product to run on a Microsoft platform). There’s a great thesaurus and dictionary, courtesy of Oxford, which together give you extended meanings, choices of usage, related words, antonyms and what-have-you. Quattro Pro is a sturdy Excel spreadsheet replacement, while Presentations is half graphics package, half PowerPoint presentation creator.

And Corel goes the extra mile in ensuring that you can switch between formats easily: Say you composed a document in Microsoft Word; you can easily open it in WordPerfect, edit it, and then save it in either format — or countless others. You can even save a file in the Adobe Acrobat format, a great way to ensure your documents look as good on other people’s computers as they do on yours.

This commitment to easy jockeying between formats is a major strength. But it’s only part of what may be the future of software, and, perhaps, the salvation of Corel: easy switching of data between computers, between programs and between platforms, using something called Extensible Markup Language. XML — an open-source language developed by a consortium of manufacturers and developers — is an improved version of HTML, the programming language used to make Web pages. Simply put, HTML uses hidden tags so that different browsers know how to present information in similar ways: The tag <Title>, for example, tells the browser to use whatever font and layout it is programmed to use for that style to display the title of the Web page you’re viewing. HTML tags, however, are preset — Title, Bold, whatever — whereas XML tags can be modified by the user. Under XML a tag can be very specific, classifying the data it refers to: <Explanation of technical term>, for example, or <Inventory of pigs’ trotters from the Russian Steppes>, or <Information given by tech columnist that is needlessly confusing reader>. Any document that uses those tags can, in theory, hook up with another document that’s agreed on the same tags, meaning data can be shared, compared and combined easily, without a lot of converting and other jiggery-pokery.

What’s this got to do with Office suites? WordPerfect seamlessly weaves XML into its component programs, so users can, with relative ease, save documents in XML format. And, while Microsoft in theory offers the same thing, there are signs that it’s not quite playing ball: Only the whizzbang top-level version of the upcoming Microsoft Office will support full XML capability, according to press reports — a step back from its present version.

The reason? No one’s saying, but it’s quite possible that the Redmond giant sees a threat to its de facto dominance of the Office market. Not because folk like Corel may be stealing a few customers, but because XML may end up replacing the formats that you save your document in. Right now, most documents are saved as Microsoft Word files, spreadsheets as Excel files, etc. This makes sense because most people use those programs. But what happens if people start using XML — open, flexible, free — as a format instead? Microsoft may be left out in the cold.

This may never happen. For all their faults — and there are many — Microsoft Office’s programs rule the roost, and part of the reason for this is that they are good. Well, quite good, anyway. And while folk may grumble, no one’s really challenging them. Corel is to be congratulated for pushing the envelope with version 11 of WordPerfect Office, but as of this month it’s struggling to find a buyer.

My advice? Unless you’re mightily sick of Microsoft Office, or desperate to save cash, don’t ditch it quite yet. If you are, you might want to try another option first: OpenOffice, a free suite of applications which, given that most folk use only a fraction of their Office suite’s features, may well be enough.