Category: Computer Applications

Report from CES 2011, Part 3: Digital Ecosystems and Device Convergence

This is the final article in a series of posts about innovations on display at the 2011 Consumer Electronics Show earlier this month in (fabulous) Las Vegas.  This article will discuss how your electronics can talk to each other using standards like DLNA, as well as show the latest “SuperPhone”, the Motorola Atrix.

Interconnected Ecosystems of Electronics

Although new mobile phones are traditionally announced at telecommunications-centered trade shows, CES 2011 featured many new devices which illustrate how mobile devices, consumer electronics, and computers are converging into a series of devices which work together. This new model means that in addition to connecting your Blu-Ray player to your home theater and your LED television, you will be able to connect many other devices in a “plug and play” ecosystem which can be operated easily. This new model means that:

· Users can connect a smart phone or a tablet to your wireless network, and it can either play back content on the phone/tablet or use the wireless network to work as a remote control for any supported device.

· Smart television sets can run applications to access web content like FaceBook, Yahoo!, YouTube, make phone calls using Skype, or to display media files from your existing network. Most new television sets feature digital connections such as HDMI, DVI, fiber optics, wireless networks, or traditional wired networks to transmit data between devices and work with your internet connection.

· Set top boxes like the D-Link Boxee Box, Apple TV, the Roku HD, or Google TV allow existing “dumb” TV sets to access this new digital world.

· Gaming devices like the Sony PlayStation 3 and Microsoft’s Xbox360 serve as players on these networks, and also integrate with gaming ecosystems like Xbox Live and Windows Phone 7. Devices like the Xbox Kinect allow for remoteless control of electronic devices, and will allow users to socialize virtually using Avatars in a virtual world to connect people around the world.

· Smart speakers allow audio to be “pushed” to network-attached audio devices using a remote or other device.

· Devices which you may have never considered “personal electronics” may interface with your home theater and gaming systems in new and useful ways. For example, the Panasonic booth at CES featured a NordicTrack exercise machine that communicated with Panasonic’s Viera home electronics ecosystem.

Most of these devices uses a relatively new standard called DLNA – the Digital Living Network Alliance (www.dlna.org) to communicate with each other over direct digital cables as well as using existing wired and wireless computer networks. Although most major electronics companies participate in DLNA, which was founded by Sony, some companies such as Apple prefer to market devices which do not communicate using the open DLNA standards.

Businesses should consider the security risks associated with attaching these “smart” devices to business networks, as they may become a new vector for malware, spyware, and privacy breaches. For example, a home network attached storage device which includes a media server might offer hackers and disgruntled employees an open portal into confidential files through security vulnerabilities on the media server.

The Motorola Atrix: A Case Study in Convergence

Probably the most innovative device at CES 2011 was Motorola’s Atrix 4G smartphone. Although this device is really a smartphone, it represents the first wave in a series of new crossover devices which have the form factor of a smart phone, but can morph into a portable computer by placing them into a series of docking stations, including:

· A “lapdock” docking station which allows the Atrix 4G to function as a traditional laptop running the Android operating system.

· A more traditional docking station, which allows connectivity to monitors and TV sets using a micro-HDMI cable, as well as the use of a mouse and keyboard connected with USB or Bluetooth.

This device has both front and rear-facing cameras (1.3MP and 5.0MP, respectively), will record video in 720P high definition format, and will play back content in full 1080P HD resolution over an included micro-HDMI port. (Motorola indicates that this tiny powerhouse will make phone calls on AT&T at its initial launch, but eventually should land on most major carriers).

imageimage image

Figure 10 – The Motorola Atrix 4G represents a new breed of smart devices which can morph into a laptop or a media player when properly accessorized. Some journalists are classifying the Atrix in a new category – the “SuperPhone”.

The Atrix can also download applications from the Android Marketplace to accomplish additional tasks, such as controlling home electronic devices using a remote control application.

 

Report from CES 2011, Part 2: Tablets, Slates, Convertibles, and Sliders

The form factor of our computing devices has changed over the last year with the introduction of the Apple iPad, and this revolution was clearly evident at the 2011 International Consumer Electronics Show (CES) last week in Las Vegas.  In this second of three posts on CES 2011, we review some of the products you’ll see on the shelves of a retailer near you later this year.

Tablets and Slates

The biggest trend for 2011 is the appearance of competitors to the Apple iPad tablet computer. While most of the devices shown were running the latest version of Google’s Android cell phone operating system (v. 2.2, aka FroYo) on devices with a single-core processor, devices slated for release in the second and third quarter of 2011 will feature dual-core processors and Android 3.0 (Honeycomb), which has been optimized for use on tablet computers. Microsoft mentioned running Windows 7-based tablets and slates in Steve Ballmer’s show-opening keynote. Ballmer also announced that Windows 8 will include a special version which compiled to run on the ARM processor line, which is used in many consumer electronic devices such as cell phones. Although this will require publishers to recompile their applications to run on this new platform, this may keep Microsoft alive in this new category of devices until they come out with a more substantive strategy.

Samsung’s Galaxy Tab

Samsung created a lot of excitement in the tablet space with the fall 2010 release of the Galaxy Tab, a 7” tablet running Android 2.2 which was sold through most cellular carriers during the 2010 holiday season (along with a wireless data plan and two year contract). A Wi-fi only version of the device was announced at CES, and should be available in the first quarter of 2011. Specs on this device are as follows:

The Galaxy Tab runs on Android™ 2.2 (Froyo) and features a 7-inch TFT display with 1024 x 600 WSVGA resolution. The lightweight and sleek device weighs only 13 ounces, is 12 millimeters thin and easily fits in a jacket pocket or purse. The Galaxy Tab includes 16GB of internal storage and has microSD expansion for up to 32 GB of additional storage. The Tab also supports Adobe® Flash® Player 10.1 to deliver an enhanced content experience with access to thousands of Web sites packed with complex Flash-based applications and content. The Galaxy Tab’s Flash content support includes games, animations, rich Internet applications (RIAs), data presentations and visualizations, ecommerce, video, music and more. The Galaxy Tab is also designed with a rear-facing 3 megapixel camera for taking pictures on-the-go, as well as a front-facing 1.3 megapixel camera and camcorder for video chat. [1]

image

Figure 1 – The Samsung Galaxy Tab is an early leader in the emerging Android tablet category (Source: Samsung).

image

Figure 2 – Most of the new tablets interface with home entertainment devices, as shown on this Samsung Galaxy Tab connected to an LED flat panel television.

Most tablets included significant enhancements to allow for interoperability with home entertainment systems. These features include media sharing, wi-fi, docking stations, micro-HDMI connections, applications which transform the tablets into remote control devices using wi-fi and many more.

Convertibles and Sliders

While the biggest news of CES 2011 was the entry of numerous iPad competitors into the marketplace, there were some other notable trends, including the demise of the netbook in its current form factor. Although the $300 “netbook” with a 10” display, a 1.3 MP camera, and an Intel Atom processor running Windows XP Home was exciting at CES 2010, this bargain device has been eclipsed by siren call of the tablet. Major netbook manufacturers such as ASUS have introduced a new spin to the netbook – a “convertible” PC with a removable tablet, or a “slider”, which can take conceal its keyboard behind the screen for use as a slate. Most of these devices have screens which are 10”-12” diagonally, built-in webcams, a keyboard, and run either the Android or Microsoft’s Windows 7 operating system.

While the Android operating system does not have as extensive of an ecosystem of business productivity applications as Microsoft Windows, concerns about battery life and processing speed have driven many manufacturers in this category to look into using Google’s open source Android operating system instead of Windows. Although business customers will demand Windows-based hardware, it is unclear which operating system consumers will choose for their gear.

image image

Figure 3 – Sliders, which can be used like a traditional laptop or like a tablet were present from Samsung (L), Dell(R), and many other manufacturers.

image image

Figure 4 – The ASUS T101MT convertible tablet configured as a notebook (L) and a slate (R).

ASUS indicated that its Slider and Convertible tablets will be available in the second quarter, and will be priced from $299 to $699 (with netbook-style processors) and slightly more than comparable laptops for Core i5/Core i7 based processors.

We will wrap up our series on CES next week with a discussion of the emerging home entertainment ecosystems and how the convergence of the home theater and the home network may affect you in the future.


[1] Source: Samsung Press Release dated 1/5/2011, “SAMSUNG Mobile Announces Upcoming Availability Of WiFi-Only SAMSUNG Galaxy Tab™”

 

Report From CES: Mobile Monitors and Mobile Scanning

I attended the 2011 international CES show in Las Vegas last week.  I’m posting some of my observations on monitors and scanners which would be useful for mobile accountants below.  I’m looking forward to working with the ScanSnap S1100 and putting it through its paces!

Mobile Monitors

There has (finally) been some innovation in the mobile monitor space to make it much easier for mobile users (e.g. road warriors) to have two monitors without carrying a ton of gear. Two new models offer road warriors workable solutions for that second display, the Toshiba Mobile Monitor (to be released in March 2011, price TBA) and the Field Monitor Pro from Mobile Monitor Technologies ($289 from www.mmt2.com)

image

Figure 1: The Toshiba Mobile Monitor is a 14.1″ LCD display which runs on USB power. (available March 2011)

The Toshiba device uses one USB 2.0 slot to provide a second 14.1” display (1366 x 768) for an external monitor, and we understand that there will be a USB 3.0 version coming soon. This exciting new offering comes in a leather folio which seals with Velcro, and can be used as a stand for the monitor on any flat surface. The model we saw was a prototype, and we were told that this device will be available in March, 2011. (Pricing not available at press time)

image

Figure 2 – The Field Monitor Pro, from http://www.MMT2.com is $279, and includes a numeric keypad.

Although they were not at CES 2011, the enterprising accountants at Mobile Monitor Technologies appeared at the 2010 CCH User Conference with the Field Monitor Pro. This device is similar to a very thin laptop, and its 15.4” 1280×800 display is connected to a PC using a USB port. The LCD can be positioned using three different stands, and includes a full numeric keypad. The Field Monitor Pro is priced at $279, and is available now from www.mmt2.com.

Mobile Scanning

Scanners for use on the road have been a challenge for accountants on the go for some time, and although Fujitsu has offered the ScanSnap S1300 portable scanner for some time, this device is still somewhat bulky to carry every day or for road warriors. Fujitsu recently released the ScanSnap S1100 to fill this gap in their product line.

image

Figure 3 – Fujitsu’s ScanSnap S1100 offers portable scanning in a micro-sized footprint.

Weighing in at a light 12.3 ounces, the svelte (10.74” x 1.33” x 1.87”) ScanSnap 1100 scans one side of one page at a time, and will handle hard to scan originals like embossed cards without an issue. Scanning takes 7.5 seconds per page, which puts the speed for this device at about six pages per minute.

image

Figure 4- The Fujitsu ScanSnap S1100 portable scanner

Although the scanner itself is impressive, the real advances made by Fujitsu are in the accompanying ScanSnap Manager software, which has been extended to allow users to scan documents directly to PDF files, e-mail messages, printers, or to numerous cloud applications for online collaboration. One-click online document sharing is available for Evernote, SharePoint, and Google Docs.

image

Figure 5 – Fujitsu’s ScanSnap Manager software allows one-touch uploads to numerous document portal services.

Another alternative for mobile scanning is to use software to convert the high quality digital cameras in tablets and cellular phones into a scanning device. One application, PDF Scanner, which is available for Windows Mobile 6, Android, and the iPhone, will take pictures of documents and convert them into PDF files, which can then be either downloaded using a cable or attached to e-mail messages. PDF scanner is available from most cell phone application stores, and more information can be found at www.melonmobile.com.

 

Analysis on the Cheap

I often remind participants in my seminars that every accountant I’ve ever met shares a common favorite four letter word.

Seriously.

That word is, of course, FREE.

With that in mind, I’ve run across some tools over the last few months that I haven’t blogged about, and wanted to pass these along to you all.  The tools are available for the low, low price of….. wait for it…. FREE.

Analyzing and manipulating large data sets has long been the job of accountants, auditors, and analysts, and the classic tools for these tasks like CaseWare IDEA, ACL, and others have always been very expensive and required a week or so of training so that you can be proficient with them.  With the general availability of quad core processors, workstations with 8 GB+ of RAM, fast 1 TB hard disks, end users no longer need to wait on someone to create a report for them.  Get the right tools, get access to the data, and get to work.

Basic Tools: Microsoft Query and Excel PivotTables

Although they aren’t technically “free” since you need to purchase Microsoft Office to get them, Microsoft offers a couple of tools which are just as useful to analysts as an adjustable wrench (a Crescent wrench) and a claw hammer are to those doing home repair.

  • Microsoft Query is a tool for selecting, joining, sorting, filtering, and extracting data from databases.  Query is one of those “helper” applications which is hidden from most users – I have only executed MS Query from within the Data tab of the Excel 2007/2010 Ribbon (Data, Get External Data Group, From Other Sources, Microsoft Query), but it is invaluable for entry level work with databases, and is compatible with any ODBC compliant database which you can use on your PC, including MS Access, MS SQL, and many, many other formats.  Queries can be created, edited, saved, and executed from a simple menu structure, and a wizard makes the hard task of writing SQL statements into child’s play.
  • Excel Pivot Tables make it possible to summarize large data sets into interactive tables.  Although a full discussion of Pivot Tables would take all day (I actually own entire volumes written on Pivot Tables, and teach TWO half day classes on them (1) (2) through K2 Enterprises), suffice it to say that Pivot Tables will change your life, and do just about anything you want except make your teeth whiter and make you more attractive to members of the opposite sex.  Seriously – they’re that good.

ActiveData For Office

My friends over at InformationActive.com have a couple of nice products which meet the needs of accountants, engineers, and other professionals who need to perform sophisticated analysis on large data sets.  While my favorite one, ActiveData for Excel, is still a pay application, there is a version of this powerful tool called ActiveData for Office, which is now available for the low, low, price of FREE.  ActiveData for Office (also referred to as “ActiveData for SQL”) uses standard ODBC connections to talk to large databases, and will perform routine calculations like verifying the accuracy of an A/R aging report based on the dates in an open item listing, stratifying a sample, and evaluating sample results.  I’ve been somewhat confused by the move to give away this product, as I think it’s more powerful than the Excel tool – but pricing decisions are above my pay grade.  For more information, visit InformationActive.com’s page on ActiveData for Office.

image

ActiveData for Office is a FREE data analysis tool which is invaluable for Accountants and other information professionals who need to slice and dice large data sets.

PowerPivot for Office 2010

With the release of Microsoft Office 2010, our friends at Microsoft have come to the table with one of the best tools for summarizing huge (100K+ records) data sets.  While the tool does require that you become an early adopter of Office 2010, the price is definitely right, and the tool has been used to analyze data sets with hundreds of millions of records.  PowerPivot (free from www.powerpivot.com) is a self-service business intelligence tool designed to let end users create their own business intelligence (BI) solutions which combine data from disparate sources using an Excel add-in.  For seasoned BI professionals, PowerPivot creates pre-summarized tables which are periodically updated and can be queried similar to cubes for almost instant calculations on data sets with millions of records.

While you can do many of the same things using MS Access, update queries, dummy databases, ODBC connections, and pivot tables, PowerPIvot is both more powerful (smarter) and easier to use (better looking) than the alternatives, and it’s free.

If you haven’t tried it, PowerPivot is available from www.powerpivot.com.

 

What’s New For 2010

I’ve been traveling to meetings with vendors and writing pretty much nonstop the last few weeks, and have neglected you, the gentle reader of this blog.  Accordingly, I’m going to simply link to some great coverage of good tech tricks from my recent work/writing.

  1. Windows 7 “God Mode” – My friend Dr. Bob Spencer recently posted on an unsupported “hack” in Windows 7 to allow sophisticated users to create a “super control panel”.  Read on @ www.bobspencer.com.  There is also a freeware (UNTESTED) application called “GodMode Creator” for Windows Vista and Windows 7 – use at your own risk.  (No word on whether or not you can order up a Garden of Eden without the serpent…)
  2. Outlook Data Exporter – I’ve been working on a course on a webmail and web calendar productivity apps, and have noted that it’s notoriously hard to get data out of MS Outlook.  I discovered a utility earlier today that may make this a little easier.  The utility is called Outlook Data Exporter, and it’s an open source application which lets you export data like events from your calendar into a number of different formats.  More available online at http://outlookdataexp.codeplex.com/.
  3. ZumoDrive is a web-based application which will let you share directories across numerous PC and Mac computers.  It also will store your synchronized data as encrypted files in the cloud.  Finally, you can use ZumoDrive to share content with people no matter where they are, and it has features like version control which make it very interesting.
  4. Google Apps – I’ve been working on a course on Google Apps for quite a while now, and am starting to see how it provides a compelling alternative, particularly for small businesses.  The e-mail and calendar are absolutely brilliant (powered by GMail and Google Calendar, respectively).  Google Apps and Google Docs are particularly interesting in how the features sets reflect the priorities of Google itself, a company of brilliant engineers.  For example:
    • The spreadsheet tool is extremely feature rich, and has the majority of the functions in Microsoft Excel as well as some new web functions, and a very compelling method for publishing charts to the web or to a dashboard.  There are some major holes in the tool for Accountants – PivotTables, support for cubes, and ODBC support are all missing in action.  (Google is working on a tool called FusionTables, which is in Google Labs now, but it’s still not functioning at the level where PivotTables were 15 years ago on my 486 laptop (25 Mhz, 1MB RAM, Windows 3.1).
    • The word processing tool seems to be designed for writing content for the web, and leaves something to be desired for editing documents to be printed on dead trees (e.g. paper).  Google expects you to edit CSS and use javascript to do some of the functions you know and love like modify styles and other functions.  The tool is probably OK for basic correspondence, but where the form of the correspondence is important, this one leaves something to be desired.
    • The presentations tool is pretty compelling, but the lack of meaningful support for styles without being a web programmer just isn’t going to be enough for most office workers to change.

If you look at the war between Microsoft and Apple, it’s clear that there is a role for style in computing, and Google Apps clearly needs a new pair of shoes (and a wardrobe).

How about you, readers.  What are you working on, and what have you learned lately?  You can read more of the stuff I’m reading by following me on Twitter.  For a preview, visit twitter.com/bftcpa

 

Sights from CES 2010, Part I

I’ve been in Las Vegas for CES for the last few days, and wanted to pass along some of the sights from the trade show floor.  It’s been a really good experience, and I think I’ve made some really good contacts, and refreshed lots of old ones.  Thanks to Sage and Greg LaFollette for a very nice meeting with some of the CPA profession’s technology leaders at the Aria casino last night.  It’ was a very interesting meeting, and I think we all had a great time exchanging information and tips about how best to work this meeting.

Pre Download 2010-01-08 264

Planon had a new version of their portable scanner (with bluetooth and an LCD) and a new thermal portable printer.  Looks interesting, but I’d like to work with one for a few weeks before I pass judgment.  There were some scanners here, and I’m planning follow up visits to some of them, but I haven’t seen anything super-revolutionary.  I’ll probably have another post on anything that turns out to be super-exciting.

Displays continue to be a big deal in the computer space.  Kodak and some other vendors were using the Microsoft Surface platform (funny parody of this technology here) to have an interactive digital experience.  The technology was really cool, and it helped me get more of their messaging – so it worked.

Pre Download 2010-01-08 267

Displaylink showed off a Samsung display with six large monitors configured to be one massive display, running through one small digital cable.  They demonstrated it running a driving game, and the video performance was truly amazing.

Pre Download 2010-01-08 274

The Microsoft booth had a small notebook with two displays that slide out from each other to give you two monitors on a laptop.  Very cool, although these two displays are only about 12” diagonally (16×9) each, and this is a prototype which won’t be in production for a while.

Pre Download 2010-01-08 277

Skype continues be featured in numerous products, including the ASUS AiGuru SV1T device (left, below).  Television manufacturers continue to incorporate features into their new LCD/LED sets, including the Skype feature demonstrated by LG (right, below).  Other applications on displays include media streaming, Netflix, and many others.  Microsoft launched a new IPTV interface for Windows 7 Media Center which can be used to directly receive IPTV from services like my TDS Fiber Account, AT&T U-Verse, or Verizon FIOS without needing a cable box, which looks pretty interesting.  (I’ll believe it when I see it working in my home office).

Pre Download 2010-01-08 266 Pre Download 2010-01-08 279

If you have specific things you’re interested in, send me a Tweet (@BFTCPA), and I can let you know what I’m seeing that might be of interest.

 

Monitors for Out of the Office and Other Hardware Recommendations

One of the more common questions asked by readers is a request for recommendations of external LCD monitors which can be attached to a laptop so that mobile users have two displays.  This post summarizes current thoughts on how to do this based on my experiences and the experiences of my friends, Randy Johnston, Bob Spencer, and Val Steed.  Together, we teach hundreds of CPE courses to accountants across North America each year, and also make recommendations at TechnologyBestPractices.com, CPAFirmTech.com, TotallyPaperless.com, and AccountingSoftwareWorld.com.  Many of us are also active consultants with CPA firms nationally either independently or through organizations such as NMGI.

The K2 CPA Firm Tech team members had an e-mail discussion re: our personal opinions on portable monitors for CPAs about three weeks ago.

  • Some of my co-workers @ K2 (Val, Randy, Bob) are recommending an HP 21.5” touch screen monitor – the HP L2105tm 21.5”($299).  Personally, I think this one is too big to lug around (14.1 lb (6.4 kg), Dimensions (w x d x h) 20.2 x 9.1 x 16.5 in).  The one I mention below is smaller, but does not have the multi-touch touch screen, and is also only an 18.5” display instead of a 21.5” display, resulting in much less work area, but my recommendation is a little over half of the weight of the HP model.  Info on HP model L2105tm is available on the HP website.
  • Due its the much smaller form factor (17.72″ x 11.65″ x 2.83″, Weight 7.94 lbs), I’m recommending the Samsung LD190N monitor for staff and seniors when out of the office  ().  It is a 18.5” LCD (1360 x 768 native resolution), and has a 5ms response time with decent contrast.  I purchased one of these for my own use a few weeks ago.  Some things you should know about this display:
    • This WILL NOT fit in my backpack sized for a 17”notebook, so I haven’t taken it on the road yet.
    • The monitor is NOT HDCP capable, so you will not be able to play Blue Ray DVDs on it, and only has an analog VGA cable input.
    • Since this one is only $119 vs. the $299 of the HP above (the HP is clearly a superior monitor, but it’s big, you could always buy a few of the Samsungs, and then see if you need a larger display and the touch interface.
  • You might try to find a good deal on 17” monitors, although I don’t know of any specific models to recommend, as most everyone is going to something bigger these days.

Screen protection will be a concern for most users, as there is no protection provided with either of these displays, and they will be very easy to crack.  I plan to protect my screen two ways:

  • I plan to use black velcro (matches the framing on the monitor) to attach a trimmed corrugated plastic For Sale sign you can buy at Lowe’s/Home Depot and use it as a hard piece to protect the screen.
  • I will see if any of my existing bags will hold the monitor so I can avoid purchasing a special case for it (I have about 10 laptop cases from throughout the years).

There are a number of alternatives for a case, including:

  • For the smaller Samsung and other 19” class displays, there’s a closeout bag by Shuttle (gaming PC manufacturer) which is designed to transport their discontinued XP19 – 19” monitor (which had a piece of plexiglass over the LCD) from place to place.  I don’t have one at this point, but it looks pretty interesting, and is $60 @ Directron, an online closeout store.
  • One firm reported that they use the CaseAce LCD harness to transport monitors and shield the screens from damage.  This is a cover shaped like a messenger bag (with the bottom open) to let you carry your monitor by the handle mounted on the top of the bag.  (Note: This harness appears to not be water tight, so you may want to also carry a trash bag with you to seal the monitor in the event of very heavy rain).  There is a larger version of this LCD harness which will let you carry monitors up to 24”.
  • Another firm reported that they used contact paper to reinforce the original packaging which came with their monitors and are using these boxes on the infrequent occasions when they need to move from site to site with their LCD.

Finally, some users will want to have more than one 22” monitor available in the office.  There are a number of solutions which will let you run the second external monitor (e.g. laptop LCD + 2 External LCD’s), including:

I would NOT purchase more than one of any device until you test it and verify that the drivers will not conflict with your applications and operating system.  I have had numerous issues with drivers for these items in the past, and some of the ones you can purchase at retail in office supply stores have software which will hang up when you try to run the PC without the attached monitor – which defeats the purpose of having a laptop.

FREE WEBCAST 12/9/2009 @ 2PM – On a personal note, I’m presenting a free one hour webcast on Gadgets with Greg Lafollette at 2pm EST on Wednesday, December 9th.  I hope you will register and attend.  The webcast is sponsored by Sage.

 

Excel Used to Solve Sudoku

Charlie Ellis, a program manager at Microsoft, has an interesting article which uses solving a Sudoku puzzle as a way to teach how you can use Excel to solve extremely complex puzzles using iterative calculations.  Interesting concept, and I look forward to using it on one of my favorite games ever.


Web: Building a Basic, Understandable Sudoku Solver Using Excel Iterative Calculation (by Charlie Ellis from Excel on MSDN Blogs)

 

Blogged with the Flock Browser

Tags: , , ,

 

Fiber Optic Internet and New Software Business Models

I’m in the middle of getting fiber optic internet installed today (through TDS, my phone company – even though I don’t have a land line), and am excited about it.  I’ll post more, as well as some speed tests once I get things set up.  Speed on the line is advertised as 25Mbs down, 10Mbps up.  Hopefully this will eliminate the occasional flutter in my VOIP conversations. Intuit recently announced that they have 50,000 ProAdvisors, which is a pretty significant milestone.  For comparison, AICPA has 300,000 members – so there’s plenty of room for growth – but 50K is going to be far and away the largest in the segment (as you would expect).  If you haven’t looked at the partner programs from Intuit (ProAdvisor Program), Sage (Sage Accountants Network), and Microsoft (Microsoft Professional Accountants Network) as well.  One can join all three for a total about $1,200 per year, and get close to $30K in software…. good stuff, people. Not to be outdone, Sage and Microsoft have both announced some initiatives through their partner programs which are very innovative.  Sage has offered ads on job site Monster.com for SSAN members, is giving away a free license of Peachtree Complete Accounting (plus six months support) for clients of CPA’s switching from Quickbooks (see their site, www.switchmyclients.com for details), and has a number of innovative offerings to help their members meet the needs of clients, including payroll tax subscriptions and a five user license of Peachtree Quantum for SSAN-Peachtree members.  Microsoft’s MPAN program recently announced a co-branding initiative where MPAN members can put links to their own website in copies of Office Accounting and Office Accounting Express for clients, which is pretty interesting.  I’ll write more about this later, but Microsoft still offers the Microsoft Action Pack to MPAN members in public practice or consulting.  This subscription is basically everything Microsoft you would ever use in a 10 person CPA firm for $299 a year.  They also are linking to the MPAN Certified Consultant directory from within the software – so if someone has the software and tries out a sample company, they can go to the “Find a Small Business Accountant” page on the Microsoft site, and find an MPAN member to help them (search this database under zip code 37922, and you’ll find me as an “MPAN Consultant”, which means that I have passed their certification exam on Office Accounting).  (Side note – take and pass as many of the certification exams as you can – my phone rang yesterday with a potentially very lucrative opportunity because I was on the QuickBooks ProAdvisor site for Enterprise Solutions.  I personally billed and collected about $4K off of leads from my ProAdvisor listing last year, with an average rate over $100 per hour, and actually turned away a lot of leads from this source.  This would not have been possible without taking and passing the ProAdvisor exams for the standard and enterprise editions of QuickBooks). On the software subscription vs. purchase front, Microsoft is now selling MS Office Home and Student on a subscription basis.  The new product is called “Equipt”, and is bundled with some Windows Live / Office Live services, including Windows Live OneCare and Office Live Workspace.  This seems like a great offering for students and others who need MS Office software, but get sticker shock at the initial price of purchasing this software.

It’s important to note the following:

  • Same EULA as Home and Student (e.g. use for the student only or the parents when helping students with homework).  Accordingly, this is NOT and SHOULD NOT be used in a business environment.
  • Software can be installed on up to three PC’s.
  • Office updates are pushed out automatically, and upgrades during the subscription term are automatic.

Some links for those wanting to know more:

If you’re doubting that software subscriptions are the wave of the future, let me remind you that Intuit announced a restructuring last week which realigns their workforce to focus on subscriptions and online services.  From Intuit’s press release:

The changes better position the company to deliver on its comprehensive “Connected Services” strategy. The strategy increases Intuit’s emphasis on developing value-added services for its desktop products and innovative online offerings. The company plans to focus on both traditional and new markets across the globe, while embracing social networking and mobile technology trends.

While I’m a serious technophile, I plan on celebrating the 4th with my family by taking my son and niece to a drive-in movie while they still exist.  (There’s plenty of time to watch  HDTV and surf the internet over fiber later.)  Life is, after all, all about relationships, isn’t it? Brian Tankersley is a Knoxville, Tennessee based CPA and consultant, and is an Associate with K2 Enterprises.  You can read more of Brian’s writings either on AccountingWeb.com or at http://blog.bftcpa.com. 

Tags: