The first tab in the workbook is a dynamic tab indexing system that can be used as a navigation system (menu system) for quickly getting to worksheets if desired.

The Refresh button allows you to update this after you've moved tabs around or added your own.

This "simple" little database application has 26 worksheets in it. All of them play a role.

In addition, there are two different scripting modules that utilize google script (javascript with google objects) that are required. One module is intrinsic to the file, and one is external and linked to the file.

This is also has connections to outside databases for customers lists and product lists in addition to the ability to do those locally, just in this file.

Modular software is VERY powerful stuff, but like a car, you need a good mechanic who knows how it all goes together to keep the maintenance and headaches to a minimum.

This is one of the data input screens for your blend data.

We have a suggestion for a patient level worksheet system that would be used to track your blend creation process, leaving this just for the final record of what was chosen/prescribed.

Data can be entered into this screen and saved, much like a website form.

These operate slower than websites. A save could take 10-20 seconds.

Other less decorative forms can be used for data entry to reduce to 5-7 seconds an you can still recall and print on forms that look like this in a matter of seconds.

This is what a basic blend worksheet looks like filled in in print preview.

This data is intended to be saved in a relational database type of structure that can be recalled and edited as desired.

This worksheet can be printed out if needed or desired.

This can be emailed as a PDF or saved as a PDF if desired.

All aspects of this can be customized from fonts, to all related fields.

Labels can be included or excluded in the printed material.

Labels can be emailed as individual documents or labels can be pasted into emails and emailed that way.