Support

Contact Us

TechWizard™ Help

Production Wizard™ Help

White Papers

TechWizard™ Frequently Asked Questions (FAQ)

Production Wizard™ Frequently Asked Questions (FAQ)

 

 

TechWizard™ HelpBack

Getting TechWizard™ Version 4 Started Using Excel 2000 - 2003

Getting TechWizard™ Version 4 Started Using Excel 2007 or 2010

Copying TechWizard™ Version 3 Ingredient and Formula Files to Version 4 (pdf format)

Making a Back Up Copy of Formula and Ingredient Files in Version 4 (pdf format)

Creating a Graphics File for a Nutrition Facts (pdf format)

Registering the Solver Add-in in Excel 2010 (pdf format)

Opening TechWizard™ and other Excel files at the Same Time (pdf format)

Installing TechWizard™ Version 5 Update and Registering (single user)

Installing TechWizard™ Version 5 Update and Registering (network)

Using the New Nutrition Facts Label Formats in TechWizard™ Version 5

Getting TechWizard™ Version 5 Started

 

 

Production Wizard™ HelpBack

Getting Production Wizard™ Started Using Excel 2003 (pdf format)

Getting Production Wizard™ Started Using Excel 2007 or 2010 (pdf format)

Using the Batch Sheet Creation Tool (pdf format)

Using the Ingredient Update Tool (pdf format)

Using the Tank Contents Editor (pdf format)

Configure Tank Settings and Add Candidate Ingredients to a Tank (pdf format)

Production Wizard™ Administrator (pdf format)

Fix-a-Mix™: Re-standardizing a Formula (pdf format)

Registering the Solver Add-in in Excel 2010 (pdf format)

Opening Production Wizard™ and other Excel files at the Same Time (pdf format)

 

White Papers Back

Evaluating Frozen Desserts (pdf format)

Calculating the Sucrose Equivalents of an Ingredient (pdf format)

How does TechWizard™ Calculate Density? (pdf format)

Corporate Management of Formula Development and Batching Using TechWizard™ and Production Wizard™ (pdf format)

Relative Sweetness Values for Various Sweeteners (pdf format)

 

TechWizard ™ Frequently Asked QuestionsBack

General

How much does TechWizard™ cost?
Please click here to view a price list for our products and services.

Can TechWizard™ communicate with other software programs?
Yes. TechWizard™ can be configured to import or export information to most software programs.

I am a product developer and I need to reformulate foods to have less sugar, less fat, more fiber, or meet a particular health claim. How can TechWizard™ help?
TechWizard™ was made for this task. You simply enter your original formula’s information. Tell TechWizard™ how you would like to improve the formula and TechWizard™ will create a recipe that meets your needs.

How do I add a new ingredient to the ingredient file?
Click here for the answer.

I would like a special report that is not available in TechWizard™. Can it be added?
Yes. Owl Software is more than happy to modify TechWizard™ to meet your special requirements.

Why should I purchase TechWizard™ if I already have an alphabet soup of software programs such as ERP, PLM, LIMS, SCADA, and so on?
TechWizard™ is a comparably inexpensive application that provides features that complement these other software packages and can communicate with them to save you money and time.

Can I import ingredient information directly from my ingredient supplier?
Yes. Using the Ingredient Request Wizard™ you can submit a form to your supplier. They fill it out and send it back as an email attachment. You click a button in TechWizard™ to retrieve the information. This is very useful for adding new ingredients or updating existing ones.

Can I add non-nutritive components to the ingredient database?
Yes. You can create any type of property you require to help you develop a formula.

Can I update pricing information for ingredients?
Yes. You can enter the information manually or Owl Software can build a data bridge to automatically update the information.

Can TechWizard™ provide ingredient and formula cost information?
Yes. TechWizard™ can provide both ingredient and formula cost information for any amount.

Can I use a formula as an ingredient in another formula?
Yes

Can TechWizard™ estimate what a given volume of mix will weigh?
Yes. Furthermore a variety of density equations are built into the program to provide you with the best estimate.

Can TechWizard™ estimate what a given volume of an ingredient will weigh?
Yes. Furthermore a variety of density equations are built into the program to provide you with the best estimate.

Can I print a spec sheet for an ingredient or formula from TechWizard™?
Yes. The spec sheet can include your company’s logo, nutritional, allergen, and other pertinent information.

I need a special feature added to TechWizard™. Is that possible?
Yes. Owl Software has a great deal of experience customizing TechWizard™ to meet the needs of our customers.

How can I determine if I have the latest patch for TechWizard™?
Click the Check for Updates button in the Front Panel of TechWizard™ to determine if you need to install the latest patch.

Why does TechWizard™ run in Microsoft® Excel®?
This makes things much easier. If Microsoft® Excel® (2000 – 2010) works on your computer or network then TechWizard™ will work. Furthermore, this allows TechWizard™ to be a very robust software package while taking up very little space on your hard drive. Microsoft® Excel® can communicate with most software programs. TechWizard™ takes advantage of this to quickly establish a link with other software programs to import and export data. Installation is simple. TechWizard™ and all its dependent files fit in one folder.

Is there a Mac Version of TechWizard™?
No. You need to load Windows on your Mac and a Windows version of Excel to use TechWizard™. One way to do this is by using VMWARE® Fusion® software. It allows you to run Microsoft® Windows® like any other application without rebooting. Once VMWARE® Fusion® is installed, follow the instructions provided by VMWARE to install Microsoft® Windows®. Next, install a copy of the Microsoft® Windows® version of Excel®. The last step is to install TechWizard™.

Can I view multiple formulas at the same time?
Yes. You can open 2 or more copies of TechWizard™ at the same time. In TechWizard™, Click the File menu, select Open Other Files, and click Open Another Instance of TechWizard. When TechWizard™ opens the window is maximized. Resize TechWizard™ windows to see both.

Will TechWizard™ help my hair grow back?
Possibly. If the cause of your hair loss is from pulling out your hair with frustration then it may help.

What does TechWizard™ consider to be a formula?
A formula is a list of ingredients and their percentage of the total weight. You can create a formula by selecting ingredients and enter amounts for each in any unit. Or, TechWizard™ can create a formula if you select the ingredients and use the least cost formulation capability.

How does TechWizard™ assist with reverse engineering food products?
The user enters the information from the nutrition facts panel and ingredients from the ingredient statement in TechWizard™. This provides TechWizard™ a composition to match and a list of ingredients to use. The actual composition of the food product is estimated taking into consideration the rounding rules that are implemented when creating a nutrition facts panel. TechWizard™ uses this information along with any other information you can supply such as chemical analysis to create a comparable formula.

Nutrition Facts

I’m a small business and need to use TechWizard™ periodically. I cannot justify the cost of purchasing a nutrition labeling program. Do you have an affordable solution for me?
Yes. Owl Software offers a subscription option. This allows you to use our TechWizard™ product development and labeling software for a given time period at a cost which is much lower than the purchase cost. At the end of the subscription period, you have several options. 1. You can let the program go dormant until you need it again, 2. You can renew your subscription, or 3. You can subtract the first year’s subscription fees from the purchase price for a permanent TechWizard™ license.

I am interested in creating a Nutrition Facts panel, ingredient statement, and an allergen statement. I do not require software that has all the extra features found in TechWizard™. Why should I purchase this software?
TechWizard™ offers many features to meet a variety of needs and it costs less than other nutrition labeling programs. Use the features you need today and feel secure that the other features are there if you need them later.

Can I create a Nutrition Facts panel for a product that loses moisture during processing?
Yes

Can I create a Nutrition Facts panel for a product that gains fat during processing?
Yes

Can I create a Nutrition Facts panel for a product that gains fat and loses moisture during processing?
Yes

Least Cost Formulation

What is least cost formulation?
This is a method of obtaining a recipe blend while also trying to minimize cost. Generally the user will set limitations on the composition that is required and possibly on the amounts of certain ingredients too. For instance, I want to use a certain amount of fat, protein, sweetness, solids, etc. and I want you to pick from a particular list of ingredients to come up with a recipe. In TechWizard™ you click the formulate button and it will come up with a recipe that fits all your requirements at the least cost.

I need to prepare least cost formulas for my products. I do not require a nutrition labeling program. Why should I purchase this software?
TechWizard™ offers many features to meet a variety of needs and it costs less than other least cost formulation programs. Use the features you need today and feel secure that the other features are there if you need them later.

Can I provide a list of candidate ingredients, provide a required composition, and have TechWizard™ provide the best recipe?
Yes

Meat

Can I use TechWizard™ to formulate meat and sausage products?
Yes. TechWizard™ has special features that make formulating meat and sausage products easy. You can meet necessary requirements for components such as fat, moisture, protein, etc.

Frozen Desserts and Dairy Products

Can TechWizard™ formulate a frozen dessert to have a particular texture and mouthfeel?
Yes.

Can TechWizard™ estimate the ice content of a frozen dessert?
Yes. Furthermore you can formulate to achieve a required ice content at a given temperature. You can compare the freezing properties of multiple formulas at the same time.

Can TechWizard™ create a liquid milk ingredient based on the total solids and fat information?
Yes. You can create a new ingredient based on adjusting the solids, fat, fat and solids, or skim milk solids and milk fat of the original ingredient.

Products Containing Alcohol

I need to formulate a product to have a particular Alcohol by volume value. Can TechWizard™ do this?
Yes. TechWizard™ has special features to assist with this.

My ingredient supplier provided alcohol by volume data. I need to convert it to alcohol by weight. Can TechWizard™ do this?
Yes. TechWizard™ has special features to assist with this.

Processed Cheese

Can I use TechWizard™ to formulate processed cheese?
Yes. TechWizard™ has special features that make formulating processed cheese a snap. You can meet necessary requirements for components such as fat, moisture, protein, cheese solids, intact casein, FDM, etc.

Can TechWizard™ prepare a “milk based” ingredient statement for processed cheese?
Yes!


Production Wizard™
Frequently Asked Questions
Back

What is the difference between Production Wizard™ and TechWizard™?
TechWizard™ is a research and development program. It provides least-cost formulation, nutrition labeling, reverse engineering, and other features in one software package. It does offer some simple batching capability. Some smaller operations use TechWizard™ for day-to-day batching.

Production Wizard™ brings the power of TechWizard™ to the plant floor. It is designed to meet all your day-to-day batching needs.  First formulas and ingredients are configured to your specifications.  Then the operator is provided a simple user interface where he or she answers a few questions. Next, a batch sheet, formatted to your needs is produced. Production Wizard™ tracks raw ingredient usage, tank storage, tank ingredient composition, and provides a great solution for plant floor production. Production Wizard™ provides a completed batch sheet to produce a consistent product even with variable raw ingredients.

How much does Production Wizard™ cost?
Please click here to view a price list for our products and services.

If we purchase Production Wizard™, what does that include?
The software, manual, software setup and training are included. Everything you will need to put Production Wizard™ to work is typically included in the purchase price. If you require additional program modification, we will let you know before you purchase the software if this will incur any addition costs.

Can Production Wizard™ track the amount of each ingredient I use to make each batch?
Yes. Production Wizard™ can be configured to track all raw ingredient usage. For dairy plant operators, the necessary information to report dairy ingredient usage such as milk and cream is part of the report.

We already have software to keep track of the composition of each ingredient in our raw storage areas. Can Production Wizard™ use that information to batch product?
Yes. Production Wizard™ is a very flexible program.

We require Production Wizard™ to create a special batch report. Is that possible?
Yes. Creating a batch report that meets your requirements is included in the purchase price.

Can Production Wizard™ communicate with our inventory software, accounting software, and process control software?
Yes. Production Wizard™ can be configured to communicate with a wide variety of software programs.

How much money should we expect to save with Production Wizard™?
This varies depending on the size of your operation. Typically, users save enough money to pay for the software in just a few months.  This is especially true if you are currently using spreadsheets or hand calculations. The savings is due to reduced ingredient losses, reduced product losses, and reduced labor costs.

The raw ingredients we obtain vary in composition from lot to lot. Can Production Wizard™ calculate consistent batches?
Yes. Production Wizard™ is designed to recalculate your recipe amounts based on real time compositional data for your raw ingredients. Formulas can be configured to allow users a choice. For example, if you run low on condensed skim, a formula can be configured to automatically switch to skim milk powder. If one tank is running low, Production Wizard™ can seamlessly switch to a new tank while taking into account any difference in ingredient composition between the two tanks.

Some of our ingredients come in bags and other units of measure. How can Production Wizard™ make the job easier on our production technicians?
Production Wizard™ can use any type of unit to create a batch report. For example, if your sugar comes in 50 pound bags and you would like to report the number of bags to add to the batch and the remainder as pounds (for instance, 2 bags 5 lbs). Production Wizard™ can do this. Or, determine how much the composition is altered if you round off the amount added to the batch to the nearest bag.

Can Production Wizard™ be used to batch ice cream, frozen desserts, and cultured products?
Yes. Production Wizard™ was initially designed to batch these types of products.  It can handle any situation including reworking salvage ingredients or re-standardizing a mix that is out of the acceptable composition range.

Can Production Wizard™ be used to batch processed cheese?
Yes. Production Wizard™ has features that make it a good choice for day-to-day processed cheese least-cost formulation and batching.

Can Production Wizard™ be used to batch processed meat?
Yes. Production Wizard™ has features that make it a good choice for day-to-day processed meat least-cost formulation and batching.

Can Production Wizard™ be used to batch dry blends?
Yes. It is a great solution for this product type.

Can Production Wizard™ be used to batch beverages?
Yes. It is a great solution for this product type.

Can formulas and ingredients created in TechWizard™ be imported into Production Wizard™?
Yes. With the click of a button you can import TechWizard™ formulas into Production Wizard™.

Can Production Wizard™ communicate with other software programs such Oracle®, SAP®, Wonderware®, Microsoft® NAV, etc.?
Yes. Production Wizard™ is an excellent fit for use with these types of software applications. Production Wizard™ provides day-to-day batching tools that these software packages do not offer and a data bridge can be created to communicate with any of these programs. This provides you with the best overall solution at a reduced cost.

How does Production Wizard™ provide tighter control over the batching process?
The administrative and configuration tools allow management to determine exactly what is allowable in each formula and what is not allowable. Furthermore, security features limit a particular user to that level of access that he or she requires. During daily batch creation, each formula is created using only what is allowed. Formulas can be configured to allow savage ingredients to be used as long as the finished product meets preset requirements. Formula re-standardization is one area where formulas can be thrown off track to try and meet lab results for components such as total fat and total solids. With Production Wizard™ re-standardization is a simple process for the user and the result is a formula that meets all compositional requirements.

Can Production Wizard keep track of ingredients stored in tanks and other raw storage areas? Can it keep track of the length of time the ingredients have been in those storage areas and the composition?
Yes. Production Wizard™ is designed to do all this and more.

Do I have to enter a recipe for every variation of a formula? For example, today my 12% fat white mix is using 35% cream but tomorrow it will be using 40% fat cream. Since the fat content varies the amount used will vary. Do I have to create a recipe for each situation?
No, definitely not. If needed, you can create a formula where the exact amount of each ingredient you wish to use is set. But for most formulation situations, we will show you how to enter the required composition and Production Wizard™ will decide how much of each ingredient is needed to meet your needs while minimizing cost.

A mistake was made while dispensing the ingredients in a batch and we do not want to dump the product. How can Production Wizard™ help?
The Fix-a-Mix™ feature will quickly determine what needs to be added to the formula to put it back on track.

We have a great deal of salvage ingredients that we need to use up in new product. We need to make sure that the salvage ingredients do not introduce new allergens or other components that would adversely affect the product. How can Production Wizard™ help?

Production Wizard™ allows you to use salvage ingredients to their fullest. Production Wizard™ can take into account all the contributions of a salvage ingredient (fat, solids, sugar solids, stabilizer solids, etc.) not just fat and solids like other batching programs. This saves you money and reduces the chance of a product recall.

Can Production Wizard™ be used to manage multiple plants?
Yes. With our Enterprise version you can set up a user account to simulate the exact processing conditions at multiple locations. This allows you to administer operations for multiple locations from one central location.