Frequently Asked Questions

The cost of manual processes

One reason for adding a Smart Tool to your organization's workflow is to minimize the amount of time you and your staff spend doing repetitive, manual, processing tasks.

For example, one of my first databases tracked enrollments in classes and workshops offered by a large insurance company. After this database had been in in production for a few months, the administrative assistant for that training group retired.
The company did not hire a replacement because this enrollment database had reduced the number of manually produced rosters, reports and related paperwork for classes so much that remaining staff could handle the load.
For the cost of a few weeks of development time, the company was able to save a full-time staff salary from then on.

If your organization offers training to employees or customers, talk to me about leveraging that experience to build you a Smart Classroom Management Tool.

Return to Top

How much will this cost?  

I bill design, development, testing and installation work at $75 an hour, with a 10 hour minimum for most projects. I consider long-term consulting contracts on a case by case basis.

Grover Park Consulting was established to build custom tools for your business. Now, with access to the additional resources of Data and Domains, I can offer even more value. It is true that having me build a Smart Tool costs more than purchasing a shrink-wrapped package from your local computer shop. That's because large software companies amortize their development costs for applications like QuickBooks^© or TurboTax^© over thousands of copies. Therefore, if you can meet your organization's needs with an off-the-shelf application like QuickBooks©, you'll find these products to be very cost-effective.

On the other hand, my Smart Tools don't cost millions of dollars like software systems created for large corporations, and they take weeks, not years, to design, build, test, and launch into production.

I also create training materials, both for my own Smart Tools and for other subjects. A basic rule of thumb is that it will take 10 to 15 hours of development time for each hour of print-based training. For web-based training the ratio can be higher.

Return to Top

How long will this take?

The amount of time I devote to designing and building your Smart Tool depends on several factors including the complexity of the proposed Tool, how similar it is to other Tools I've built, and any special requirements you have. I've created simple databases in less than a week. I've spent up to six months on complex projects for multiple users spread across multiple locations.

In addition to my own time, I work closely with you and your staff to design and build Smart Tools that meet your needs. You or someone on your staff will make an investment of time in at least three ways:

• Defining system requirements. This can take from one hour to several days, depending on how complex the proposed Tool is and how much thought you already have put into it. This step usually starts with a Proposed Project Profile.You can complete this prior to hiring me.

• Approving the design and signing off on milestones during development. This can also take from as few as one or two, up to several hours.

• Acceptance testing. Before signing off on the finished Tool, you'll want to have your staff test it to make sure it works as intended. Again, the testing time varies from situation to situation.

One way to control the cost of your Smart Tool project is to plan it in phases. If you want a suite of Smart Tools to track Time and Attendance, monitor Work in Progress, manage a Customer Contact List and keep your personal Rolodex, start with one module and add the others one at at time.

Return to Top

Do I need a database, a spreadsheet, or something else?

I won't try to sell you a database if I think another tool will do the job better.

Abraham Maslow, the eminent psychologist, once said, "To the person who has a hammer, every problem begins to resemble a nail." From time to time, I like to remind myself of that piece of wisdom. Databases, such as MS Access© or its larger brother, MS SQL Server©, are very good tools for some purposes, but not for others. The same is true of spreadsheets, word processing programs, etc. I like to think that a Smart Tool is one designed specifically for the purpose for which it is intended, using the right kind of technology.

Databases are very good for capturing and retaining large volumes of data over extended periods of time. For example, if you want to know the number of pieces of correspondence your organization receives from your customers each day, that's a job for a database, especially if you want to categorize them by the type of correspondence received, "orders", "complaints", "referrals", etc. and keep that data for a span of two or more years.

Spreadsheets are very good for analyzing, consolidating and reporting data. For example, if you want to create a chart or graph showing volumes of correspondence received, by category, for each month in the previous twelve months, that's a job for a spreadsheet.

In some cases, you may want to combine the strength of a database to capture your data with the spreadsheet's flexibility to present the data as a Pivot Table which you can post to a web site for all of your employees to browse.

Other functions may call for different tools. For example you may want to use a tool like Abode Acrobat© to convert documents to easily stored and shared files.

Return to Top

Do I need special software or equipment?

If I build your Smart Tool as an MS Access database, you will need to own, or purchase, licenses from Microsoftfor each workstation where the tool is used. However, alternatives are available. Call or email me to discuss your options.

Return to Top

Can you train my staff?

Training is an important part of everything I do at Grover Park Consulting. I now have more than 20 years of training experience. I have taught in a variety of settings from elementary and high schools to colleges to corporate training departments. In addition, I created a number of self-study manuals and courses and published a book on using MS Access.

I include documentation for our Smart Tools (written in plain English) and I can provide on-site training for you and your staff.

In addition to training in the Smart Tools I build, Grover Park Consulting has many years of experience in Instructional Design and Adult Training and Education. I can design and create training materials for you on a wide range of topics.

Call me at 1-425-876-0535 or emailme to discuss your needs.

Return to Top

What do I have to do to prepare before I hire GPC?

The more you do to define your requirements, the less work there is for me to do. Start by downloading and completing the Proposed Application ProfileThen contact meto get started.

Return to Top