What is Office Automation?


http://encyclopedia2.thefreedictionary.com/office+automation

_OFFAUTO

This is a loose, if somewhat hokey diagram of what an idea of “Office Automation” is. I don’t entirely agree with most definitions. I think Office Automation is about (among other things) pushing software and hardware systems to their ultimate potential. The Microsoft Office suite is a good example of “Office Automation”. The programs can work nicely together, when used right.

I think “Office Automation” allows people to come to THEIR full potential.

Humans and computer systems coming together to make truly big advances. That’s what we’re all about.

Cheers! 😎

Charles McCrumb, Office Automation Expert
Visit us at http://www.hm-associates.com
Like us on Facebook for instant updates on what Herbert, McCrumb & Associates is doing, how we’re doing it, and how we’re saving real people time and money!
email: charles@hm-associates.com
Skype: charles.mccrumb
Bus: (626) 593-6700

Advertisements

Full-Automation vs Semi-Automation


What’s the difference? I’ll tell you. Full-automation is different from semi-automation in that full-automation generally won’t give you a chance to interact with it. It’s ON until turned OFF, with no mercy on whatever data gets in it’s way. This is fine for what it’s for, downloading data, beating it up into a report, etc. Custom function calls are the parlance of the full-auto model. If you can check your data elsewhere before full-auto, then it’s terrific! Full-auto is best for SPEED! All actions happen in memory.

However, in those instances where your report is going to be seen, either publicly or by your boss (or her bosses boss), it is helpful to be able to review the PROCESS of the data being formed into the report. For the semi-auto model, I generally like to have the formulas living on an Excel spreadsheet where they can be reviewed by a human for accuracy, before either turning the model full-auto, or running it semi-auto. There’s lots of room for both in most businesses! Semi-automatic is best for CLARITY, both in thought and in action-reaction! All actions (calculations) happen on the spreadsheet, with the results being fed to another report or other action.

If you have a VBA programmer (or two) on staff, then full-auto can and should work without a hitch. If you don’t, it’ll be better to go with semi-auto.

Contact me for help with this!

Cheers! 😎

Charles McCrumb, Office Automation Expert
Visit us at http://www.hm-associates.com
Like us on Facebook for instant updates on what Herbert, McCrumb & Associates is doing, how we’re doing it, and how we’re saving real people time and money!
email: charles@hm-associates.com
Skype: charles.mccrumb
Bus: (626) 593-6700