post

Macros For Dummies

I’ve never made a secret of the fact that my spreadsheet skills are somewhere at the level of what I learned using Lotus 1-2-3🙂  so the recent addition of Macros and Pivot tables to Zoho Sheet was really not my piece of cake.  Not that I would not recognize the techological feat when both Google and Editgrid said they couldn’t / wouldn’t do it…

Now I have to admit I occasionally tinkered around with Excel macros: not that I know Visual Basic, all I ever did was record the sequence I needed, then tinker with the resulting VB code.  That’s the capability Zoho just announced today: with a few clicks record, edit, re-run your macros, in the original Zoho Sheet or in any others you have access to.  Finally, Macros For Dummies like me 🙂 Here’s a summary video:

To the best of my knowledge no other spreadsheet can do it (other than GrandDaddy Excel)

Reblog this post [with Zemanta]
post

Apple vs. Windows Pricing: It’s All About TCO

The debate du jour: should you pay twice as much for a Mac than you’d have to pay for a Windows PC?

(Data source: NPD)

Just about everyone attributes the price difference to Apple’s marketing, Brand Power.   But I think by focusing on out-of-the box prices, they all miss the boat: it’s all about TCO.  Total Cost of Ownership.

I started to chronicle the hassle of just running a Vista PC and dealing with random, unexplainable failures, but more or less gave up.  Compare this to the anecdotal evidence of my Mac-user friends, who, despite occasional hiccups all agree: it just works.

I don’t know how you value your time (heck, sometimes I wonder about mine), but most computer users probably are not in the minimum wage bracket. Considering the days and nights I spent trying to fix this Vista monster, I’m quite sure I would have been better off paying more upfront for a Mac.  My TCO would have been lower.  And not even my Virtual Invoices can make up for that.

See today’s debate on: Apple Watch, DailyTech, TechBlog, Mark Evans, Microsoft Watch, Technovia , jkOnTheRun, The Digital Home, Hardware 2.0,

Update: Finally, some sanity – here’s Jake:

Focusing on out-the-door pricing seems too narrow to ask such a broad question. It would be very interesting to see a comparison of expected full costs (not just OOTB) for each of the major O/S.

post

Life After Outlook: Gmail. But is it Becoming Oopsmail?

Bernard’s title @ ReadWriteWeb, Breaking Free of Outlook perfectly matches my own sentiment: in fact I called the MS Client Outlook-prison repeatedly.

Unlike Bernard, I escaped from prison in stages:

I’ve never looked back, and am definitely more productive than in my desktop-bound life.  I could see first-hand a lot of people move in the same direction: my How to Import All Your Archive Email Into Gmail guide become an all-time classic, probably approaching 100,000 hits by now.  Gmail’s IMAP support changed everything, so I issued a  Simplified Guide to Importing All Your Archive Email Into Gmail.  A while later Google woke up, and started to offer a migration tool to subscribers of the paid Google Apps version. (Oh, and they are being sued by LimitNone, who claims Google basically stole their gMove product).

But the love-affair with Gmail was not without trouble: I first documented some glitches last spring: Gmail, I Love You – Don’t Let Me Down, then real trouble started a month ort so ago.

Formerly rock-solid Gmail has been ill a lot lately.  The “Oops…the system encountered a problem (#500) – Retrying in 1:30” error message has became a daily occurance… in fact several times a day.

I somewhat jokingly called “retry now” Gmail’s Penalty Button, when I noticed every time I hit it the wait counter increased by a minute.

Now I have an update: you don’t need the penalty button, the counter increases by itself.  Every time, “reliably”. Basically as soon as you see the Oops error, you might as well close the browser tab (or browser itself), as it won’t recover on its own.  This annoying  error has become the most frequent “feature” of Gmail, to the extent that it really undermines productivity.

I hope Google will fix it.  They MUST.  It’s the crown jewel of Google Apps. In fact without Gmail and Calendar there wouldn’t be Google Apps at all.

Update:  Oops: apparently there’s a real service by the name of Oopsmail.  Obviously I am not referrring to them in the title. (Although… ? 🙂 )

Zemanta Pixie
post

Oops…Gmail Has a Penalty Button

Gears-enabling Gmail will be great, for those “unconnected” moments (hours), and I certainly hope they will avoid dumb mistakes that made Google Reader almost useless offline.

But for now, all I wish is a little more reliabilty.  Formerly rock-solid Gmail has been ill a lot lately.  The “Oops…the system encountered a problem (#500) – Retrying in 1:30” error message has became a daily occurance… in fact several times a day.

A minute and half is not that much – except that it’s not only waiting for the requested operation, it freezes up Gmail entirely.  So if you’re impatient, you’ll inevitable click the “Retry now” button. After all, that’s whay it’s there, isn’t it?

Wrong!  You’ve just found Gmail’s penalty button!  Every time you click it, the wait counter increases by a minute.

Still want to work, rather than go for coffee?  The only solution is to completely close the browser tab – sometimes the entire browser – then log back into Gmail again.

Zemanta Pixie
post

Sync Update: Syncplicity, Dropbox, Windows Live (?) Mesh

Quick update to my recent Syncplicity review:

In the meantime Microsoft’s Windows Live Mesh opened to the public, combining synhcronization and backup – also competing with their own Foldershare.  Now a word on what will happen to Foldershare, but I guess the writing is on the wall.  That said,  Live Mesh just failed for me the second time, so I can’t really recommend it.

Another service, Dropbox is getting a lot of buzz nowadays, largely to a smart theme of giving out limited numbers of beta invitations.  Apparently artificially created shortage is good marketing, bloggers LOVE being able to give away 10 or so invites…

Dropbox has one advantage over Syncplicity: it’s multi-platform, including Apple’s OS X and Linux, whereas Syncplicity is Windows only for now.  But that’s where it ends: it has less features (forget Web Apps integration, e.g. Google, Zoho, Scribd, Picnik), and has what I consider a huge flaw:  you have to drop your files into a dedicated folder to be synchronized.   That may be reasonable if you want to collaborate on a limited set of files, but it simply does not resolve the “access to all my data anywhere, anytime” problem.  It’s certainly a show-stopper for me.

So if you’re waiting for a Dropbox invitation, you might as well try Syncplicity – you’ll love it.  And if you sign up here, you get 1G more, i.e. 3G of free storage instead of the standard 2G.

Update: I received a very good, constructive comment from Assaf, who pointed out this was a largely negative post.   In my mind this post is an extension of my original Syncplicity review, but now that I re-read it on it’s own, I agree with Assaf.  Please read my response here, that makes this post complete.

Zemanta Pixie
post

Live Mesh: Open, But Still Barely Live. Who Has Time For This?

A few months ago I detailed the obstacle course Microsoft put me on, trying to get to Windows Live Mesh, and somewhat sarcastically labeled it Windows Barely Live Mesh.  Fast forward 3 months, and today Mesh is open – but still Barely Live.

But first things first: I wanted to read on the specs before installing.  You can click on the maze of mostly useless help text, but can’t find out such basics as:

  • is sync strictly via the server or peer-to-peer, a’la FolderShare ( a product Microsoft absorbed)
  • are the files stored up @ the 5G free storage encrypted?
  • etc…

The last one (encryption) is pretty important and for many users / businesses a potential dealbreaker.  Since it’s no-where mentioned, I assume MS does not offer encryption.  In comparison, Syncplicity, a sync-backup-and-more  service launched by former Microsofties offers encryption, and just as importantly the explain what happens to your data before you take the plunge – see my review here.

Oh, well, so the only way to find out is jump in… so I decided to install and test.   No more hoops, simply sign in with my Live Id (formerly Passport) account, and voila! – here’s the download.

2 minutes later:

The “Get more help” takes me back to the already seen generic FAQ.

Normally this would be the time to search the MS knowledge base, or better yet, Google, but this thingie is so new, it’s probably not yet documented.   Who has time for this?  I’m out of here, be back to check on Live (?) Mesh in another few months.

And Dear Microsoft, this one was just a quickie, but you still owe me for last time, se here’s my virtual invoice:

Zemanta Pixie
post

Swisscom Selects Zoho for Business SaaS Offering

If the second largest Swiss telco partnered with Google for email, then who would the #1 select for business applications?   You guessed right (I hope):  it’s Zoho. smile_wink

Swisscom, Switzerland’s leading telco has for a while need piloting Teamnet, a business collaboration portal, which includes a customized version of Zoho Business, with Zoho Writer, Sheet, Show, Notebook, Meeting and other tools.

 

This comes on the heels of another, larger scale Zoho partnership with Baihui in China. 

Zoho Business, also offered of course directly by Zoho is currently in private beta, which typically means by invitation – but here’s a secret (don’t tell anyone!smile_wink) : it’s actually open for use.  

Zoho has a few similar deals in the works, and they also have white-label partnerships with fairly large corporate customers.  The latter is probably the less-known side of the Zoho Story, but the one that allows them to offer their services free to individual users.

As a side-note, Swisscom certainly does not operate only in Switzerland: they were the team that outfitted last years Office 2.0 conference with excellent wi-fi – quite a story in itself.

Related posts at: Between the Lines, CenterNetworks,

post

Syncplicity: Simply Excellent Synchronization, Online Backup and More

(Updated)
In today’s world where features are hyped as products and project teams masquerade as companies it’s truly refreshing to see a service that’s almost an All-in-One (OK, perhaps Four-in-One) in it’s category, which I would loosely define as protecting, sharing and synchronizing one’s data.

Recently launched Syncplicity:

  • Synchronizes your data across multiple computers a’la Foldershare
  • Provides secure online backup a’la Mozy
  • Facilitates easy online file sharing a’la box.net..etc
  • Integrates with  online services like Google, Zoho, Scribd, Picnik (somewhat like now defunct Docsyncer?)

An impressive list by all means.   Oh, and congrat’s to the team for finding an available domain name that’s actually a perfect description of what they do.  The simplicity part probably refers to the ease of installation and use not the task they perform in the background. smile_wink.

Getting Started
Registration, installation of the client is quick and easy, more importantly, after the initial configuration you can forget about the software – it works for you in the background non-intrusively, allowing you peace of mind.  You can leave it to Syncplicity to find all your document and media files or specify directories to be synchronized.  The process allows more granular control than Foldershare, where one of my gripes was that if I select My Documents ( a fairly obvious choice), I cannot exempt subdirectories, which results in conflict with some stubborn programs (e.g. Evernote).  With Syncplicity you can precisely fine-tune what you want synchronized, in fact they indicated that filename-based exclusion is in the development plan. (If you ever had your Picasa.ini files messed up by Foldershare, you know what I am talking about…)

Synchronization
The major difference compared to Foldershare is that Syncplicity is not a peer-to-peer product: it actually uploads your files to their servers, where they are encrypted (AES-256) and are available either to the Syncplicity clients on your other computers, or directly, via a Web browser.  This may be a show-stopper for some, and a convenience for others: unlike Foldershare, this approach does not require all synchronized computers to be online at the same time.  And since the files are stored online, it might as well be used as a backup service – this is where we enter Mozy-land.

Backup
The two major differences vs. Mozy are encryption and ease of restoring files from the backup set.
Mozy performs all encryption on your computer and even allows you to pick your private key: it can hardly be any safer (so safe, that if you lose the key, you’re files are gone forever).  Syncplicity transmits your files using SSL and the AES 256-bit encryption occurs in their data center, using a random key that is then sent off to a different location. Since they hold the key, there’s definitely a trust issue to ponder here.
Of course a backup solution is only as good as the restore, and, unlike Mozy, which will send a zip file hours after your request, then to be decrypted on your PC, accessing your files with Syncplicity couldn’t be any simpler.  Install the client on any PC and auto-download entire directories, or just browse the online version, check file revision history and pick what you’d like to download manually.

Sharing
Syncplicity offers both file and folder-level sharing: from your PC, right-click on any file to get a shareable link, which will allow anyone you email it to download the file from their website.  Or share entire folders to any email address, and the receiving party can either browse the folder’s online version, or, if they have the Syncplicity client installed, you both will have identical copies on your computers.  You can further specify view-only or edit access – the latter takes us into collaboration-land: updates made by any sharing party will be synchronized back to all other computers.  Be aware though that each party will still work on individual copies prior to save/sync, so with long multiple edits it’s quite possible to end up with several versions of the same document, due to Syncplicity’s conflict resolution.

This is why I believe real-time online collaboration is superior: there’s only one master copy, and no confusion between revisions.  This is what Google Docs and Zoho offer, and – surprise, surprise! – Syncplicity won’t let you down here, either.
They have created the best seamless offline/online integration I’ve seen with Google Docs: at the initial run your designated PC folder (e.g. My Documents) will get uploaded to your Google Docs account, and Google docs will be placed in a subdirectory on your computer.  From this point on you can edit these documents using Google, Word, Excel ..etc – your offline and online versions will be kept in sync.  This is pretty good, but not perfect: since Google docs only support a subset of the Word functions, after an online edit Syncplicity keeps two (and potentially more) versions of the same file – one with the latest changes, the other with a full set of Word functions “lost” in the conversion to Google.

Syncplicity’s most recently added online partners are:

  • Zoho – Right-click for the  ‘Edit in Zoho’ option.  Saving updates the document both on your computer, Syncplicity, but NOT on Zoho and Zoho (fixed, that was fast)
  • ScribdiPaper view of your files on the desktop.
  • Picnik – Right-click to choose “Edit in Picnik” for all your photos.

The Zoho integration presents a funny situation: you can now use Zoho Writer to save a file to your Google Docs space (Zoho>Desktop>Syncplicity>Google).  Not sure how practical this is, but I like the irony of a third party creating Zoho>Google integrationsmile_tongue.  On a more serious note, what I really would like to see is full Syncplicity<>Zoho integration, like it works with Google today (and since Zoho supports more Word functions, the conversion should be less lossy).  And while on the wish-list, how about sync-ing to Flickr?

Is it for you?
First of all, pricing: Free for two computers and 2G space, $9.99/month or $99 annually for any number of computers and 40G of storage.  You can sign up here to get 1G more, i.e. 3G of free storage, or 45G on paid accounts (using ZOLIBLOG as invitation code also works).  The price-tag is clearly heftier than, say Mozy, or free Foldershare, but there’s a lot more functionality you get – and oh, boy, when did box.net become so expensive?

The one potential downside is the fact that Syncplicity is a pre-funding startup. Will they survive?  This market has seen casualties (Docsyncer, Omnidrive?), successful exits (Mozy, Foldershare), and stable, ongoing services.  The answer is: who knows?   The Founders are ex-Microsofties, they’ve put an amazing service together in a very short time, so I’d put my chips on them, but in business there are no guarantees.

A better question to ask what you’re real risk is.  If online backup is critically important to you, and are already paying for a service like Mozy, I wouldn’t abandon it yet (Mozy is now owned by EMC, not going anywhere).  If you’re mostly just syncing currently, or don’t have a solid backup solution for now, there’s not much to lose. Even if Syncplicity were to disappear, your files will be replicated in several places, you don’t lose access.

In fact, by signing up, you help Syncplicity show traction, which is critical in the funding process, so you can help solidify their position.  Happy Sync-ing!smile_regular

Update (7/17): In the meantime Microsoft’s Windows Live Mesh opened to the public, combining synhcronization and backup – also competing with their own Foldershare.  Now a word on what will happen to Foldershare, but I guess the writing is on the wall.  That said, I Live Mesh just failed for me the second time, so I can’t really recommend it.

Another service, Dropbox is getting hyped a lot nowadays, largely to a smart theme of giving out limited numbers of invitations.  Apparently artificially created shortage is good marketing, bloggers LOVE being able to give away 10 or so invites…   Dropbox has one advantage over Syncplicity: it’s multi-platform, including Apple’s OS X and Linux, whereas Syncplicity is Windows only for now.  But that’s where it ends: it has less features (forget Web Apps integration), and has what I consider a huge flaw:  you have to drop your files into a dedicated folder to be synchronized.   That may be reasonable if you want to collaborate on a limited set of files, but it simply does not resolve the “access to all myy data anywhere, anytime” problem.  It’s certainly a show-stopper for me.

So if you’re waiting for a Dropbox invitation, you might as well try Syncplicity – you’ll love it.  And if you sign up here, you get 1G more, i.e. 3G of free storage instead of the standard 2G.

Update #2:  Congratulations to the Syncplicity team on their funding.

post

Email is Not in Danger, Thank You

Yet-another-email-is-dead (OK, just in danger) article, this time by Alex Iskold @ ReadWriteWeb.  Alex adds Twitter‘s increasing popularity to the standard “reusable” arguments: teenagers using IM, or increasingly SMS, and most recently Facebook instead of email which they find cumbersome, slow and unreliable – hence email usage will decline.

I beg to disagree as I did before, and before.  Sure, I also get frustrated by the occasional rapid-fire exchange of one-line emails when by the 15th round we both realize the conversation should have started on IM. Most of teenagers’ interaction is social, immediate, and SMS works perfectly well in those situations. However, we all enter business, get a job..etc sooner or later, like it or not…smile_wink Our communication style changes along with that – often requiring a build-up of logical structure, sequence, or simply a written record of facts, and email is vital for this type of communication.  As much fun Twitter may be, I rarely have (or see) serious ongoing discussions there  – in other words Tweets are in addition, instead of email.

Email in business is being “attacked” from another direction though: for project teams, planning activity, collaboratively designing a document, staging an event… etc email is a real wasteful medium. Or should I say, it’s the perfect place for information to get buried. This type of communication is most effective using a wiki, or an increasing number of online tools supporting native collaboration.  Yesterday I reviewed a startup CEO’s ppt deck, and it took us 4 rounds of emailed versions of the same presentation – it would have been a lot easier to collaborate on just one “master” presentation in Zoho Show.

So yes, I agree with Alex, even in business we’re offloading stuff off email.  But email is far from dead, or even in danger, and it won’t be any time soon. We just have to learn to use the right tool in the right situation. As usual, Rod Boothby says it better in a single chart:

Rod’s chart is almost two years old, but still valid – perhaps I would update it to say “Wiki and collaborative documents”.  My own post here is a slightly updated version of an older one from last year, which in turn was an almost verbatim reprint of another one from July 2006. I rarely re-post old stuff, but in this case I felt it still made a valid point.  Next year, when someone brings up the “is email dead?” question, I’ll dust it off again. smile_tongue

Zemanta Pixie
post

MS Money: Old Financial Data May Not Be Accessible on Vista

You’d think at least Microsoft’s own products are compatible with Vista.  Well, sort of.  MS Money users who converted from Quicken may be out of luck.

I have a lot of financial data in Microsoft Money and prior to that in Quicken files. Both  applications used to recommend you keep the data files small by archiving earlier years. With today’s faster computers archiving is no longer an issue, but if you’re  a long-time user like I am, you probably have a few old archive files.

Every time you “upgrade” Money (hardly any new value, but if you use online services, MS forces you to upgrade every 2-3 years) your current data file is upgraded to the new formats, too. But what happens to the archive files?

I decided to convert all my older Quicken files to Money, just in case… after all, Money supports Quicken conversion.  Or not: crash.  Crash again.. and again.  I tried several data files, even rebooted the system, to no avail: Money consistently crashed at all conversion attempts.

This is where Vista’s Problem Reports and Solutions comes handy, and yes, a few days later it shows “solution found”. Hm… if they found it, they certainly are not sharing it.  Here’s the user-friendly stuff I found:

<?xml version=”1.0″ encoding=”UTF-16″?>
<DATABASE>
<EXE NAME=”MSMoney.EXE” FILTER=”GRABMI_FILTER_PRIVACY”>
<MATCHING_FILE NAME=”adapt.dll” SIZE=”109360″ CHECKSUM=”0x24BD92C0″ BIN_FILE_VERSION=”16.0.0.1303″ BIN_PRODUCT_VERSION=”16.0.0.1303″ PRODUCT_VERSION=”16.00.1303″ FILE_DESCRIPTION=”MSN Money Adaptation DLL” COMPANY_NAME=”Microsoft(R) Corporation” PRODUCT_NAME=”Microsoft(R) Money” FILE_VERSION=”16.00.1303″ ORIGINAL_FILENAME=”adapt.dll” INTERNAL_NAME=”adaptation” LEGAL_COPYRIGHT=”Copyright © Microsoft Corp. ” VERDATEHI=”0x0″ VERDATELO=”0x0″ VERFILEOS=”0x4″ VERFILETYPE=”0x2″ MODULE_TYPE=”WIN32″ PE_CHECKSUM=”0x25BFE” LINKER_VERSION=”0x60000″ UPTO_BIN_FILE_VERSION=”16.0.0.1303″ UPTO_BIN_PRODUCT_VERSION=”16.0.0.1303″ LINK_DATE=”01/04/2007 07:49:53″ UPTO_LINK_DATE=”01/04/2007 07:49:53″ EXPORT_NAME=”Adapt.DLL” VER_LANGUAGE=”English (United States) [0x409]” />
<MATCHING_FILE NAME=”adaptres.dll” SIZE=”13104″ CHECKSUM=”0xA99DDA54″ BIN_FILE_VERSION=”16.0.0.1303″ BIN_PRODUCT_VERSION=”16.0.0.1303″ PRODUCT_VERSION=”16.00.1303″ FILE_DESCRIPTION=”MSN Money Adaptation DLL” COMPANY_NAME=”Microsoft(R) Corporation” PRODUCT_NAME=”Microsoft(R) Money” FILE_VERSION=”16.00.1303″ ORIGINAL_FILENAME=”adapt.dll” INTERNAL_NAME=”adaptation” LEGAL_COPYRIGHT=”Copyright © Microsoft Corp. ” VERDATEHI=”0x0″ VERDATELO=”0x0″ VERFILEOS=”0x4″ VERFILETYPE=”0x2″ MODULE_TYPE=”WIN32″ PE_CHECKSUM=”0x4855″ LINKER_VERSION=”0x60000″ UPTO_BIN_FILE_VERSION=”16.0.0.1303″ UPTO_BIN_PRODUCT_VERSION=”16.0.0.1303″ LINK_DATE=”01/04/2007 07:00:04″ UPTO_LINK_DATE=”01/04/2007 07:00:04″ VER_LANGUAGE=”English (United States) [0x409]” />

This looks like the problem report sent to Microsoft, not the solution.  There’s one hint though: the filename is AppCompat.txt.  Perhaps it’s a Vista compatibility issue?   Luckily I still have an XP laptop around, the data files are there thanks to Foldershare sync (more on synchronization in the next post), all I have to do is install MS Money on the XP machine and try conversion there.

Voila!  Half an hour later I have the Quicken files converted to Money on the XP computer.  Money’s import/conversion routine is incompatible with Vista!   The whole exercise, including search on the Money Group took me about 2 hours, so dear Microsoft, here’s my invoice for lost productivity:

Oh, wait, we’re in the US, perhaps I should have presented a properly Americanized version. smile_wink

My poor experience was with MS Money 2007, but with Money Plus, the 2008 version of the product line Microsoft shows true ignorance to users’ legacy data needs.  Money Plus comes in four editions: Essentials, Deluxe, Premium, and Home & Business.

Microsoft offers a nice comparison chart, which neglects to mention a small detail, available only at the footnotes:

* Important note – Microsoft Money Essentials will not be able to open previous Money or Quicken files. If you are upgrading from a previous version of Money or Quicken, Money Plus Deluxe may be the right solution for you.

Not opening Quicken … well, it’s their decision. But not opening data from their very own previous releases? And this is hidden in the small print?

I rest my case.

Zemanta Pixie