Excel Development

FrontBlocksCWe have developed custom Excel solutions for clients. Excel is great platform for testing and development and local applications.

There is so much more to Excel than just adding numbers. Using Visual Basic, macros, and range of advanced functions, one can create complete applications that produce great value.

If you have spreadsheets you use frequently to manage business processes, and you find they are hard to use or you can easily make errors then we help you standardize your work to produce useful tools that basic administrative users can use successfully to produce consistent and accurate results.


Center for Creative Leadership Time Tracker

The client had a very unique requirement of having to track two blocks of work with specific hours. This sheet requires key information, then yields the time tracking with alerts the user to limits and changes (with voice prompts). In addition it has protected areas for accounting to generate check requests and other reports.

Check out their programs here http://goldenleafleaders.com

Note that the image is blurred on purpose to protect the data.

CCL2 SNAG 0139


Schools Using

This spreadsheet started in 2003 as a temporary record keeping device for a new text book, The Bible and It's Influence (http://www.bibleliteracy.org). 

It has grown to a full publication management system that tracks clients, orders, and keeps precise number on the various components as well as an executive dashboard.

Note that the image is blurred on purpose to protect the data.

Schools SNAG 0138


Site Tracker

We manage hundreds of sites on our servers. We built a spreadsheet that tracks all the sites, versions, software, and numerous other key points that make it easy to track, update, and maintain the server.

Note that the image is blurred on purpose to protect the data.

Sites SNAG 0141


Domain Tracker

On average we manage more than 1000 domain name for clients at multiple registrars. In order to track renewals and just as important, "Do Not Renews," we developed this sheet for ourselves. It aggregates the current domains lists from each registrar and then allows us to sort and filter on domains that need to be renewed. It also allows us to flag domains that are to expire on purpose.

Note that the image is blurred on purpose to protect the data.

Domains SNAG 0140