Anouncing CloudPrep 2014 Migration Toolkit for SharePoint Online

We do a lot of Office 365 migrations. Most of these are for businesses with fewer than 50 employees. This should surprise nobody except maybe Microsoft, who seemed to be slow to realize that their cloud platform would have the most appeal to companies with limited budgets – or that most jobs in the US are provided by small businesses. Go figure.

Over the years, I’ve written several times about the challenges of moving from a conventional file store to Office 365. Fact is, it’s just not simple to do. It really makes sense to have an experienced IT professional help you make the move. I like helping customers make the switch, but doing so has presented interesting challenges for my business that I’m sure other SharePoint consultants share too.

Firstly, there are great third party tools out there for migrating files. We often use ShareGate and Content Matrix from MetaLogix. MetaVis is another great company that has great tools with lots of features. Fact is that even though these tools are great, they are also quite expensive. They’re feature rich, so really knowing the tool is a skillset of its own – and it makes good IT people hard to find when I need them to do a job. We also run up against serious limitations when trying to use these tools; sometimes we cannot find a way to use the tools to migrate the files in exactly the way we want to.

Second, some of my client already have a part-time IT person or managed services company that helps them service their PCs and on premises servers. Traditionally, we’re a SharePoint consultancy and we never set out to try and replace other IT folks; they need work too. They have the relationship with my customer, and the local presence needed for that on-site work. Over the years, I’ve seen that customers prefer to have their own local IT provider for most small requests. We needed to find a way to coexist with these other businesses in a way that would benefit us both.

Back in 2012, at the behest of a marketing consultant (who gave me lots of advice that was either bad or I couldn’t follow it at the time) I created a small tool called CloudPrep. This tool wasn’t much; I never had much confidence in it and so I never really promoted it. But, it did the work of renaming files that SharePoint didn’t like, and combined with WebDAV it was enough to make getting 20 to 50 GB of customer files into the cloud in a few days’ time. I released it into the wild, and CloudPrep has been getting downloaded a few times a week – mostly by other Office 365 consultants to my chagrin. Lesson learned and another checkmark for finding a way to compete with other IT providers; there are more of you than there are of me!

One problem I’ve noticed is that Office 365 migration budgets are small – I mean really tiny! That’s weird when you consider that for a 25 person company the ROI could be hundreds of thousands of bucks. But, we have been in an economic slump for something like 5 years now. I guess that takes its toll; even if you knew it would make you a thousand dollars next month, you can’t spend $100 today unless you have it to spare. Some companies are reluctant to spend even a few thousand to plan and execute.

There are a few tools that are in the “beer money” range. I tried FilesToGo once – and only once. It lacked some features that seems obvious to me, but made my client extremely angry. It didn’t have a lot of options either, one size fits all. I won’t discourage anyone from using it if it meets your needs, but I’m not going to risk my relationship with my clients on it. I am honestly surprised that after all this time, there’s nothing else in its price range.

I guess you could say that I’ve gotten fed up with this situation. Yet another migration we had to do where the current tools on the market couldn’t meet our needs for the client’s budget. That story gets old.

So, the boys in the lab and I finally built our own!

Announcing CloudPrep 2014! Forget everything you ever knew about that crappy tool we made back in 2012, because this is completely something at a whole new level.

CloudPrep 2014 is not one of those big expensive tools with a fancy GUI. It’s a set of PowerShell command-lets that work with SharePoint Online and your local file system. These commands and the sample scripts provided with them are designed to empower IT people and make migrating files to and from SharePoint Online a piece of cake.

These tools don’t replace an IT person or their experience. You’ll still need an experienced consultant to tell you how to organize your files, use metadata, overcome or avoid SharePoint Online limitations, and of course actually use the tools. You needed all that before anyway. The difference is that now much of this can be provided by your own experienced IT staff; or if you’re an IT consultant yourself, you can use our tool and make your small-business and small-budget migrations a breeze instead of a quagmire.

Our commands fall into basic categories: planning, preparation, file migration, and SharePoint management. We’re still putting the finishing touches on the product now. We’re hoping to have the Lite and Standard editions released to market sometime in February, with the Premium and Professional versions available as soon as March or April.

In the meantime, please take a look at our feature matrix and proposed pricing structure. There’s still time to collect some feedback. So, if you have a feature you’d like to see that isn’t here, then leave us a comment and let us know. Even if you don’t add a feature by the launch date, we’re planning to add even more features later. We’ll entertain any reasonable suggestion – except charging more for the product.

Like what you see and can’t wait to try it out? Contact us and I’ll give you a 15% discount if you purchase during the early access period.

Edition->Feature        Lite   standard Premium Professional
Release Date   Feb  Feb  March  April
Proposed Price Free $285 $576

$1,092

+$300 Per Tenant>2

Number of Office 365 Tenants Unlimited Unlimited unlimited Unlimited
Numbre of Site collections Unlimited Unlimited Unlimited Unlimited
Requires powershell 2.0 or higher Yes Yes Yes Yes
Requires Sharepoint client connectivity Yes Yes Yes

Yes

1 year support and Updates

(renewable Annually)

  Yes Yes Yes
Supported OS: Windows server 2008 or 2008 R2 N/A Yes Yes

Yes

Supported OS: Windows XP N/A   ?? ??
Supported OS: Windows Server 2003 N/A   ?? ??
Planning and Reporting        
Sizes and Numbers of items by folder, extention, ect. Yes Yes Yes

Yes

 

Check for Potentially Illegal file types   Yes Yes

 Yes

Folder and File Path Length Checking   Yes Yes

Yes

Permissions Checking for Local Files     Yes

Yes

Target URL Length Check Report     Yes

Yes

Upload Time Estimates      

Yes

File Preparation        
File Renaming for Illegal charaters Yes Yes Yes Yes

File Renaming for Illegal Paths

(_files,_forms)

Yes Yes Yes

Yes

Preserve Author and Editor for uploaded Files

  Yes Yes

Yes

Check for and Automatically ZIP files with illegal extentions (EXEs, Ect.)

    Yes

Yes

Check for and Automatically ZIP "_files" Folders

  Yes Yes

Yes

Migrate and Manage Files

       

Supports Network Mapped Drives

yes yes yes yes

Supports Network UNC Paths

yes yes yes

yes

 

Upload Entire Folder to Document Library

Yes Yes Yes

Yes

Upload Specific File to Document library

  yes Yes

Yes

Download Document Library to Folder

  Yes Yes

Yes

Download Specific File

  Yes Yes

Yes

Warns if Source Exceeds 5,000 items

  yes Yes

Yes

Warns if Target URL length Too Long

  yes Yes

Yes

Specify Content Type for Uploaded Documents

  Yes Yes

Yes

Specify Content Type for Top Level Folder

    Yes

Yes

Specify Content Type for Sub-Folders

    yes

Yes

Support for Documents Sets

     

Yes

Flatten Folder Structure with duplicate filename handing

    Yes

Yes

Flatten Folder Structure at 1 or more levels deep

     

Yes

Convert Folder Names to Metadata Fields

    Yes

Yes

Create Source URL Field for Uploaded Files

    Yes

Yes

Create MD5 Hash Field for Uploaded Files

     

Yes

Export Metadata to CSV File when Downloading Files

     

Yes

Synchronize of Local and Cloud files using File Modified Time

    Yes

Yes

Synchronize of Local and Cloud Files using File Modified Time+ MD5 Hash

     

Yes

Automation Features

       

Powershell command-lets

Yes Yes Yes Yes

Unattended Execution

  Yes Yes Yes

Sharepoint Management &

Development      

Create and Edit SharePoint Users

  Yes Yes Yes

Set Common Properties for Lists and Document Librarys

  Yes Yes Yes

Create and Edit Columns in Lists and Document Libraries

  Yes Yes Yes

Create and Edit Views Lists and Document Libraries

    Yes Yes

Copy a view to same or Different Document Library or list and site

    Yes Yes

Import and Export Site Columns

    Yes Yes

Import and Export Content Types

    Yes Yes

Import and export views

    Yes Yes

Add, Remove users and Groups, Permission Sets

    Yes Yes

 

CloudPrep Lite
This edition is a good fit for small file migration needs and try-before-you-buy. You can use it to do basic reporting on the structure of your files, rename files that are known to cause problems during migration, and upload folder structures to your SharePoint Online document libraries. In most cases it has a 99.7% or better success rate, and it produces a handy report so that your remaining files can be uploaded manually.

CloudPrep Standard
This edition includes a standard set of features designed to help you move files into Office 365 with a minimum amount of difficulty. You can upload and download large file collections without having to stand by the computer, perform multiple upload/download passes, and specify a default content type for files. Run it from anywhere, including various versions of Windows Server. We also include some additional pre-migration reporting tools that help to identify problems before you migrate your files.

CloudPrep Premium
For the seasoned SharePoint admin or IT professional, this edition includes features that will help you get the most out of Office 365 in the cloud. We include even more reports to give you a 360 degree view into any potential file migration issues. The file upload tool includes a variety of features for setting metadata and flattening folder structures.

CloudPrep Professional
This edition enables the true Office 365 IT professional to handle migrations for multiple clients. All the features of the Premium Edition plus advanced content type features including support for Document Sets. It also includes the ability to create MD5 Hash file uploaded files, which helps in detecting duplicate files and in determining that if two files are not the same even when their date stamps match.

Lessons from the Field for Migrating to Office 365

Recently, I’ve talked a bit about how companies can save money in lots of places by moving to the cloud with Office 365, and I’ve also described some of the complexities involved in moving large file shares to SharePoint. Today, I’d like to take a few minutes to talk about some of the lessons learned on some of our Office 365 migration projects over the past several months.

Getting Good Information Up Front is A Challenge
As SharePoint developers, we’re used to working with the IT departments of larger organizations (say 500 to 5000 employees) as we develop solutions. However, with Office 365 customers, many times we’re not working directly with IT folks. The customer may have a managed service provider for desktop support, a part-time IT contractor, and some clients do not even have their own IT staff at all.

Needless to say, planning a move to Office 365 requires us to take stock of a great many technical details. It’s not surprising that folks outside of IT might miss the importance of the myriad trivial details involved.

But getting these facts wrong during the early stages can lead to incorrect estimates and costly mistakes down the road. It’s important to get the discovery right.
Here are some things customers should pay careful attention to when gathering information in the pre-project planning phase.

Basic Planning
Make a User Inventory
Know how many users you plan to have. We’re going to need their contact information, including phone and e-mail, because more than likely this information isn’t up to date in Active Directory. From there we can talk about what plans are best for your users.

Make a Workstation and Mobile Inventory
Know how many desktop PCs, laptops, and mobile devices you’ll be configuring. It’s also important to know what kind of mobile devices will be used and how many of each type.

Make a Server Inventory
Know exactly what servers you have, what operating system and version they run on, and exactly what purposes they serve (file shares, print server, domain controller, e-mail, etc.) If you do not know these things, you should consider paying for a 1 to 3 day evaluation to document all of your systems.

What Will You Turn Off After Migration?
Part of calculating the cost is understanding the benefits you get in return for it. If you’re not sure that a system can be fully disabled after moving to the cloud, that’s something we can help you figure out.

Will You Need Any Servers You Don’t Have?

For example, if you are synching Active Directory users to Office 365, you need a server to run this on - though it needn’t be very powerful. If you have applications running on servers that you otherwise want to decommission, you may need a server in the cloud to replace them. Likewise, if your security needs are high, you’ll want to have a CipherPoint Eclipse or F-5 Big IP running in the cloud in front of Office 365.

Domain Registration
You should verify that all your domain names are still current and that you have access to the DNS registration. We’ve occasionally had customers who have some older DNS names that were being used for e-mail aliases, and they weren’t able to migrate them fully because they’d lost the ability to manage the domain name. Check on these beforehand and avoid unpleasant surprises.

Remote Access
Some companies have VPN; this is ideal. Some do not and have to rely on clunky terminal servers or third-party services such as TeamViewer or LogMeIn. If you’re in the later circumstance or haven’t set anything up at all, we should talk about what is likely to cause issues for the folks doing the migration work, because not all of these services are created equal.

What’s Your Actual Available Bandwidth
Knowing if you have a T-1, cable modem, or DSL is helpful; it’s not the end of the story. We’ll want to perform some bandwidth tests at different times of the day in order to account for the connectivity that your company is already using. In general, migrations that have to be pushed to the evening or weekends will take longer.

Test for Equipment Bottlenecks
It’s also worth pointing out that some older equipment can actually be slower than the Internet connection can handle. Early on, we can do a trial run with a few files or a single mailbox in order to determine if there are going to be unexpected problems due to slow hard drives and outdated or overloaded servers.

E-mail Migration Planning
Know Your E-mail Server
Whether you’re using Exchange, Lotus, or some other server it helps to know what we’re dealing with. We’ll need to know how many users you have, how big are their mailboxes, and what distribution lists you’re using. It’s not unusual to find a few people in a company with mailboxes approaching 20GB (or bigger!). Anything at this size is going to take a lot longer to move than usual and that needs to be taken into account.

Great Firewall of Spam
For the mail server, the above is a good start, but not enough. You need to identify if you have an anti-spam appliance (e.g. Barracuda) or service (e.g. Postini) in front of your mail server. You probably won’t need it after moving to Office 365, but if you want us to make it a part of the move we need to know ahead of time.

E-mail Archives
Most people do not think about this, but Outlook Archives (*.PST) files do not move automatically to the cloud. One of the best approaches we’ve found is to copy their contents up into Exchange Online so that you’ll have access to them everywhere you go. If you’re using archives, it’s important to know this so we can take them into account when looking at mailbox sizes, migration plans, etc.

File Migration Planning
Make a File Inventory
Know where your files are, how big they are, what you will move, and what you might leave behind. Professionals have tools that can help to analyze your files and better determine the cost to migrate. However, these tools are only helpful if we have the opportunity to run them against all the files that will be moved.

Public Folders
If you use Exchange Public Folders, you will need to have those files copied down into a regular file share so they can be moved into SharePoint. Exchange Online does not support public folders, which have been phased out in recent versions of Exchange. When we determine the size of the file stores you’ll be moving, these files need to be included.

How Will the Migration Team Access Files?
Depending on the remote access method and the speed of your Internet connection, in some cases it may actually be faster to copy your files to a portable drive and FedEx them to us rather than have us try to copy them from your office. This also provides the fringe benefit of being able to split the migration up across multiple sites, which can make everything go faster.

Dealing with the Unexpected
Obvious, there’s no such thing as a crystal ball, and that’s even more true for IT. Aside from the things I talk about above that, little things can go awry during the project. It’s important to remember that migrating to Office 365 is a big change from the way companies used to work back in the 90s. Be ready to expect and deal with the unexpected.
Here are some things we’ve seen happen in the middle of a project that can really get things out of whack.

Slippage
Sometimes it just takes longer to move files or e-mail than it seems like it should. It really helps to know exactly what we’re moving in the first place, but if your estimate and schedule were written sight unseen before we had access to the servers, then probably there are baked in assumptions that may prove to be wrong.

Even if we did a 1 day triage visit at the start of the project, sometimes the technology can make fools of us all. I had one customer where most mail moved over fine, but then one user’s mail dragged on and on weeks on end simply because their outdated server would not provide it any faster.

Needless to say, schedule creep can be very disruptive. As a result, we’ve learned to base our schedules on being 95% complete – anything more can be managed as ongoing support and needn’t cause everything else to back up waiting for it.

Limits of File Migration Tools
To move files into SharePoint is not a drag and drop operation. Fortunately, there are many good products on the market, and the state of the art is constantly changing. But, these products are not what I’d call mature - partly because Microsoft keeps changing the Office 365 platform itself. Over the years, we’ve seen file migration tools for SharePoint Online that don’t copy the date stamps on your documents, tools with poor or quirky support for Document Sets, and tools with draconian restrictions on the size of files that can be copied.

If we are copying a large volume of files, it is not uncommon that we may need to do a test run and then start over. We try to account for this in our estimates, but it’s not a perfect science. Tools are great, but if a tool or product does not get the results we want, we may have to switch tactics. This is not a sign of the coming apocalypse. Be prepared for this to be a part of the process.

Limits of E-mail Migration Tools
If you are migrating from Exchange 2007 or better, Microsoft has some great built in tools to make this possible. There are good third-party solutions for other platforms. Each of these has its own limitations. For example, Microsoft tools may not do well on extremely large mailboxes. Third party tools may be more robust, but they will take almost twice as long because they have to copy from the source and then copy to Office 365, whereas Microsoft has the benefit of running their tool in the same local network.

Limits of SharePoint
SharePoint is like any complex software product; it has boundaries. There are limits on the amount of storage you can have in a Site Collection, and limits on the number of items you can effectively put in a List or Library. Our job as consultants is to come up with plans and designs that avoid as many of these as possible. Still, it’s important to understand that Microsoft is constantly changing Office 365 – usually for the better. There have been times that we tried out a particular approach for organizing content and then had to change tactics because one of our assumptions proved to be incorrect.

Here are some examples of fiddly details that have sometimes pushed us around:

  • Flat views don’t work in large libraries (> 5000 items) even though you’d think they should be limited to the current folder.
  • In large libraries, indexes must be created before items > 5000.
  • Document Sets can only have one view inside the Document Set itself.
  • Nesting folders within Documents Sets is quirky.
    You cannot easily change the look and feel of the “my-sites” part of SharePoint.
  • And many more…


Shifting Requirements
Migrating to Office 365 is a big change. Training and discovery are a part of the process, and so you might learn something about the platform that you did not know at the beginning.

Likewise, we may learn something about your business that was not clear at the start and this could cause us to change our recommendations. Stay nimble and flexible; these moments can be opportunities to improve rather than a cause of stress.

Save Money for Your Small or Midsize Business by Moving to the Cloud

There are many small companies out there with a rack of servers in a closet. Years ago, this was the expected way that companies supported their internal operations. My company has one too. Many companies depend heavily on this equipment to perform vital functions for the business operation. E-mail and files typically live here - lots of files!

In recent years, there's been a shift to a new IT strategy called "the cloud". For small companies that may not have a lot of cash to make big changes, a move to the cloud can seem to involve a lot of risks and requires spending precious resources.

Today, I want to take a few minutes to explain some of the most compelling reasons that you might want to find a will and a way to turn that closet full of equipment off - because losing that ball and chain could help to set your business free.

Cloud Savings from Electrical Utility Costs
For starters, all that stuff running in your closet uses a lot of electricity. It's hard to tell how much exactly, because that depends on how old the equipment is and things like how many CPUs, drives, extra power supply it might have installed. Air conditioning costs energy too, and many people fail to take cooling costs into account when they try to estimate how much energy their computers use.

You can make some educated guesses based on the size of the circuit breaker on your equipment rack. For example, if you run everything on a single 20 amp circuit and it isn't blowing out like a Christmas tree in a hundred-year-old house circa 1974, then you are probably consistently pulling less than 18 amps and it's probably more like 15. Converted to watts, that's 1800 to a max. of 2400 watts. That's more than enough to run 5 servers with 500 watt power supplies - assuming you don't power them all up at one time. If you have fewer servers than that running, you either have older equipment that consumes more power or you aren't really using the circuit to its capacity.

1200 w at 120 v = 10A

500 w / 120 v = 4.15A

Another rule of thumb would be to assume about 550 watts per server, unless there's something fancy going on like it has a redundant power supply.

So let's use my own equipment as an example and I'll see if I can guess how much it costs me every month.

Here's my inventory:

  • Firewall
  • Domain Controller
  • 2 Virtual Servers
  • Database Server
  • Other Small Load Equipment: Wi-Fi Router, Network Switches, Battery Back UPS 


5 x 550 w = 2,750 w

2,750 w / 120 v = 22.9167 A

Maybe it's a little more than that if you include all the low end equipment.

This runs on a 20 amp circuit, so if I were really pushing 22A or more then I'd be blowing the circuit all the time, but I do know that if we add anything like a mini-fridge to the mix then we will trip the breaker, so I'm probably not far off. I could use this figure and call the overhead the cost of air conditioning.

Fortunately, I have another way to tell. I have these two APC 1500 VA back-up batteries and each is nice enough to tell me their load. Right now each is sitting at about 50% load. So, that's about the same as saying that we're running is 15 amps. This figure makes more sense, because you have to figure that the servers need a little extra capacity for starting up and such.

I could've come to the same conclusion by guessing that my equipment uses about 70% of its max. capacity. All these methods brings me to about the same figure.

My system uses 15A * 120v = 1,800 watts. I'll round it up to 2,000 watts to make the math easier and account for cooling costs and spikes in use that occur once in a while.

So, how much is that in money? The power company charges me per kilo-watt-hour. That's a fancy term for saying that if I use 1,000 watts for 1 hour, that's one unit on my electrical meter - for which they charge me $0.12.

24 hours in a day times an average 30.4 days in a given month equals 729.6 hours per month. Remember that this equipment runs 24 x 7 x 365, in case some employee wants to VPN in at an odd hour and get a little extra work done. So we have 2 kilo-watts times 729.6 hours times 12 cents. That's about $175.10 a month or $2,101.25 per year. Over time that really adds up.

What if I could cut that power consumption in half, by removing some of that equipment? If I had a thousand bucks, I could do a lot of things with that money instead. Here are some examples: 

  • Office 365 E3 plans for 4 employees
  • A small virtual server in the cloud with a VPN connection to my local network
  • Business-grade broadband internet service
  • A fancy office lunch for all the employees once per quarter
  • An extra grand for me to take home as a bonus

In fact, over five years this alone could pay for about 25 to 50% of the budget for moving to the cloud.

We do some really fancy stuff with our servers, but most companies are doing pretty ordinary things with their equipment. Here's some examples: 

  • Domain Controller
  • File server
  • Backup server
  • E-mail server
  • Anti-spam appliance
  • Company Intranet site
  • Remote Login / VPN / Terminal Server
  • Accounting Software
  • Other Customer Application Servers


If you replace that old equipment with cloud services and virtual servers in the cloud, you can eliminate a lot of these. In fact, only the domain controller and those last two items are particularly challenging to phase out completely. Depending on how your systems are configured, that could be as many as 3 servers (maybe more) that are just sitting there chewing up power that you could save.

Cloud Savings by Avoiding Upgrades to Hardware and Software


All of that hardware may be aging; the recession hit a lot of businesses that haven't had spare funds to update their servers since before 2008. That was 5 years ago, when Windows Server 2003 was still considered reasonably current. A lot of it isn't upgradable, because it's 32 bit architecture and won't support the newer operating systems, which means you have to figure hardware into your upgrade costs as well.

Even if your hardware is state of the art with the latest operating system, chances are good that you'll probably want to upgrade it sometime in the next 3 to 5 years. Depending on what the hardware does and what software runs on it will say a lot about how much you could save by freeing yourself from that burden.

Likewise, at some point you're probably going to want to upgrade Microsoft Office. Many companies say they're perfectly happy using Office XP or 2007; often, they just don't know about certain features that could be of really high value to them. Because they can't afford to upgrade, they never get the chance to discover the benefits on their own. Office 365 solves that problem because your Office desktop client software is included with the service.

For example, modern versions of Office have improved abilities to collaborate on documents when they're saved on a SharePoint server. Two people can edit the same Word document or Excel spreadsheet at the same time from two different computers. Most folks also don't realize that Excel has some very promising business intelligence features now that can let you crunch your business data in ways that could give your company the competitive edge.

One customer told us that because they were switching to a cloud architecture, they would be able to stop buying the more expensive laptops they'd been providing to their employees, in favor of units that we about half the price. If you have less than 10 employees that may not seem like a big deal, but if you're buying computers for a larger team, the multiplying effect can lead to formidable savings.

Here are some examples of some hardware and software costs you can save by switching to the cloud:

  • Typical mid-grade business server: $3,000 to $6,000 per server
  • Cheaper desktops or laptops: $250 to $1000 per user
  • Windows Server operating system: $1,000 per server
  • Exchange Server software: $1,000 + $120 per user
  • Microsoft Office client software: $400 to $700 per user depending on edition 


There are other miscellaneous software expenses too, like Remote Desktop Server (terminal server) clients, VPN devices, anti-spam appliances like the Barracuda, or backup solutions like Veritas. Having some of these in your company typically comes with annual support contracts that must be renewed - that's kind of like paying for cloud services without getting the cloud. You may not be able to discontinue all of these services, but especially for those which charge per user, scaling back the number of seats can save you a lot.

Cloud Savings by Reallocating IT Service Costs
Of course, computers don't take care of themselves. Some companies have an IT staff of their own, others hire managed services companies or freelance IT tradespeople to help maintain their computer systems.

These services come at a cost. A full-time IT person can cost $80,000 a year to keep on staff. Part time workers will usually charge consulting rates of around $50-100 an hour or more. Such a consultant might cost you $25,000 a year even if you bargain shop and only give him 10 hours a week. 

Such services are necessary. Backups need to be run. Users need help with malfunctioning software or broken equipment. Server drives will get full, fail, or both. Learning all those systems and which levers to pull in order to keep them running is a distraction from your business operation. Most business consultants agree that smaller companies should outsource their IT needs.

It might be tempting to think that you'll be able to cut the budget for IT support if you move to the cloud; after all your IT staff or MSP will have less equipment to maintain. The truth is that this will probably be a wash, because it's common to see both IT departments and managed service providers starved to the bone for resources. Likely, some of your resources will shift to supporting the new cloud solutions instead of the old infrastructure. Also, there are probably projects that have needed attention for a long time where you could redirect those funds or hours instead of cutting back.

So, look for changes in where you get your IT support, how it is delivered, and what platforms it will support - but don't expect to unearth a gold mine of savings by cutting back on IT work when you switch to the cloud. Fortunately, there are so many other places to find savings that it probably won't matter.

Cloud Savings from Stupid Accounting Tricks
Another thing to consider is that in some cases there are significant differences between CAPEX and OPEX, meaning that capital expenditures - those which result in obtaining assets - require different accounting treatment then ongoing expenses like your phone bill. Because cloud services are operating expenses, you may be saving money on stuff like business property taxes and depreciation if you go into the cloud.

Another thing to point out is that cloud services do not have to be paid all at once. For example, buying Office 2013 for 25 employees could mean coming up with over 17 grand up front, tapping into a line of credit, or having to phase the purchase in slowly. Getting that kind of money for big expenditures can also involve jumping through flaming hoops. Such obstacles might delay purchases you need to make, and they'll certainly drain your productivity.

Cloud services also scale much better than conventional server infrastructure. For example, you might provision an Exchange server that is reasonable for 15 employees. Over time, as employees are added to the company and old e-mail accumulates that server would be overburdened, thus accelerating the pace at which you'd have to spend more to upgrade it. Or, alternatively, you could plan ahead and buy a server that could support up to 30 employees, but then all that added expense is an opportunity cost and wasted resource for every year that you don't use the server to its full capacity.

Cloud services typically come with an annual agreement, just like your cell phone plan, which means there are some limits on how fast you could scale back if you have to, but you can increase capacity at any time. So, there's no excess supply except in cases where you shrink the company a bit - and your maximum liability is something you can plan for. With the traditional server all you could do is wait for users to drop to zero and then turn it off - just before hitting the light switch on your way out of the office.

Cloud Savings from Productivity Gains
This is the fun part that I always like to talk about, because people really overlook it when they're trying to find ways to save money - and this is where the real money is.

Suppose your small company grows, and you need to hire another office employee to handle the work. That probably costs you anywhere from $50,000 to $80,000 per year - maybe more depending on their qualifications, experience, and the value they bring to your company.

Suppose your company does less well than you'd like and you want to cut your staff. Everyone else would feel the pinch as their work is transferred to the rest of the team. The added workload affects morale, and productivity could drop - increasing the chances that you'll continue to slide downhill.

My point here is that whether your company is struggling or growing, both of these come with a cost. What if you could mitigate that cost by cutting out wasteful activities that aren't really productive but have just sort of become habits because you've always worked that way before?

If your business is like a lot of other companies, you probably have some pretty typical work patterns in your office. Here are some examples:

  • You have a network file share that you've been using for years; maybe you have everything going back to the early days of the company; there's an elaborate folder structure to keep everything organized, which has changed over time; finding things involves digging around in different folders until it turns up or asking the office admin if they know where it is.
  • Once in a while, somebody deletes a file off the network file share; either you don't ever find out about it, or when you need it you have to go to a backup since there's no recycle bin for the file share.
  • Since there's no official document retention policy - or way to automate it - old documents just pile up and lay around making everything else harder to find.
  • You have tons of documents living in e-mail; when you need a document you have to search Outlook to find it; sometimes you're not sure if it's the latest version or not.
  • You archive your old emails to gigantic PST files which you can only access on your work computer, because the file has to live on the network share in order to get backed up.
  • When you're on the road or working from home, you have to remote into a terminal server so that you can get access to all of your files at the office; you can't use your tablet or smartphone to do it; it's extremely slow compared to working on your home computer.
  • Your version of Office at home is different than the one you have at work, and so some of the stuff that you can do in the office can't be taken home with you
  • If there's an internet connection or electrical issue at the office, you can't really work from home, because VPN is down; business just shuts down for the day until the crisis is past.
  • If you do most of these things, chances are you could gain a lot of productivity by moving to the cloud. And, if you do any of these, chances are pretty good that everyone else in your office has the same bad habits and coping skills.

Logging into VPN, working with slow connections, foraging for documents, lugging portable drives back and forth, trying to find the correct version among duplicates, waiting for e-mail and file searches to finish running, being at specific computers to in order to complete certain tasks, and having to ask other people where to find that important file are all wasteful unproductive activities. Up to a certain point in time, they were considered necessary, just like people still consider driving to and from the office to be necessary - at least some of the time.

According to one McKinsey study, workers spend about 30% of their time reading and answering emails, 20% of the day looking for things, and 15% communicating and collaborating with their fellow workers. That's a whole workday every week spent looking for information, much of which may already exist inside your own company.

And yet, if each employee in a 25 person company could save just 2 hours a week by cutting down on how long it takes to find things, that'd add up to 50 hours a week in reclaimed productivity. In other words, you can add an entire virtual employee to the rolls without paying a penny - whether you simply avoid hiring another warm body or have to make due with less staff, either way you're looking at an effective savings of $50-80k.

The reality is that you can probably save a lot more than just 2 hours per week; that's just 24 minutes a day. If you think of it more like a worst case scenario, it's a pretty darn compelling argument to go ahead and make the change even if it costs you a little in the short run.

Think your company could benefit from a move to cloud architecture including Office 365? Reach out to us and we'll develop a custom migration plan, cost breakdown, and ROI.