5 Proven Smart Spreadsheet Automation Benefits to Any Business [Hint: Comparing a Manual Excel based Feed Formulation Spreadsheet with an Excel-VB Driven Ration Formulator Spreadsheet Application]

Various farm support experts already offer different Excel based feed formulation tools for farmers.

Some itemize steps users can follow, to manually create formulas in MS Excel worksheets, to build simple feed formulation tables. When the user gets it right, this works okay.

But such solutions can sometimes be like asking users to work in a minefield

When a controlled environment is lacking, the target audience can make all sorts of mistakes. The damage from feeding animals wrong ration formulas can be devastating, and sometimes irreversible!

Apart from errors, manual Excel feed formulations workbooks can be cumbersome, time consuming, and tiring to use. Farmers with pressing farm concerns rarely find them endearing!

That’s why I believe the ease of use, time saving – and accuracy/reliability – of manual Excel- solutions, will be greatly enhanced if they are modeled after the Excel-VB Ration Formulator™.

One Example: A Windows-Based User-Friendly Feed Formulation Workbook (WUFFDA) for Rabbits is available online.

It uses a range of ingredients and nutrient profiles, including amino acids, and trace minerals.

However, it needs manual updating of different large data tables periodically. Users have to copy and paste across tables, highlight/drag ranges of cells, scroll through large sheets etc

When using MS Excel, that is an invitation to user generated errors of all kinds!8,9,13
The WUFFDA is a great feed formulation resource. However, intelligent Excel-VB automation, with intuitive graphic user interfaces, will make it more user-friendly (by simplifying and/or taking over routine and repetitive tasks), while also making it more reliable and accurate.

Typical benefits of using the above approach include (See examples in the case study featured in Issue 052 of my Performance Improvement Ideas (PII) newsletter published 2 days ago – click here):

i. Reduction of User Created Errors: Error handlers can be built-in to prevent users from accidentally ending up with faulty rations for an example).

ii. Time and Effort Saving User Friendliness: in-cell drop down menus, as well as automated floating data entry forms, with drop menus speed up data entry by reduce typing.

iii. Feed Formulation Speed and Accuracy: Excel’s powerful calculation engine, combined
with useful database functions, and Excel-VB automation, will enable fast generation of multiple ration formulas, with minimal effort. Since the process is automated, repeat accuracy is assured.

iv. Adaptability: Best practice worksheet design, and customizable interfaces/code make it easy for a competent person (e.g Excel-VB trained extension specialist) to modify the app to
suit changing requirements, whenever the need arises: with no developer fees incurred!

v. Extension to Other Farm Business Aspects: Learning achieved can be easily applied to17
other farm business aspects e.g tracking poultry layers’ Key Pe4rformance Indicators(KPIs)
using an Excel-VB Poultry Farm Manager™ (See 16 Step-by-Step Screenshot User Guide Video Tutorials for it here – click).

NB: This article is based on excerpts from this 2013 international agribusiness paper.

[IMPORTANT: This blog’s contents are being updated following the transfer to www.tayosolagbade.com from my former domain – Spontaneousdevelopment.com. As a result, some parts of it may not work properly for now. Quick Tip: If a link contains “spontaneousdevelopment.com”, simply change it to “tayosolagbade.com” – and it should work. This applies to article links as well as image links. Work continues to update the links(in over 500 articles). Tayo K. Solagbade.]
Practical Livestock Feed Formulation Handbook Available as a PDF ebook, and also as a spiral bound print manual (from me). Click here for details. You can also get it as an PDF ebook via my online store. $82.5 USD to buy it from my online store (PDF download) N8,000.00 [Eight Thousand Naira] for persons who wish to send payment direct to my bank account. Payment of N50,000.00 gets you the physical handbook and software on CD with videos etc, PLUS practical one-on-one, in person training with me at a feed mill in Lagos, Nigeria. Click here to contact me about purchasing this product. Your Gifts for Subscribing When you signup, you’ll receive: Once you submit the form below, you will be taken directly to the downloads page, just as an auto-response message will be delivered to your inbox, with links to the promised gifts. I look forward to meeting and/or working with you! Tayo K. Solagbade* Performance Improvement Specialist & Multipreneur Best Practice Farm Business Support Specialist & Founder of the MS Excel Heaven Visual Basic Automation Club & Competition(www.excelheaven.biz) Excel-VB Driven Ration Formulator 1. Click here to learn more about this app – watch demo videos etc 2. Click here to watch a 4 part video in which I demonstrate how to use this app to formulate rations using real life data sent to me by an Algerian PhD student. Click here to contact me about purchasing this product. EXCEL-VB DRIVEN* POULTRY LAYER FARM MANAGER SOFTWARE Click here to download a detailed PDF user guide and watch 15 screen shot user guide tutorials of the Monthly Poultry Farm Manager that I now offer Farm CEOs. Click here to contact me about purchasing this product.
Name:
Email:


Powered by Optin Form Adder