{"id":11744,"date":"2017-04-03T22:22:25","date_gmt":"2017-04-03T22:22:25","guid":{"rendered":"http:\/\/tayosolagbade.com\/sdnuggets\/?p=11744"},"modified":"2017-04-03T22:22:25","modified_gmt":"2017-04-03T22:22:25","slug":"pii-060-4-annotated-pictorial-guides-you-need-for-using-tayo-solagbades-popular-livestock-ration-formulator","status":"publish","type":"post","link":"http:\/\/tayosolagbade.com\/sdnuggets\/pii-060-4-annotated-pictorial-guides-you-need-for-using-tayo-solagbades-popular-livestock-ration-formulator\/","title":{"rendered":"PII 060: 4 Annotated Pictorial Guides You Need for Using Tayo Solagbade's Popular Livestock Ration Formulator"},"content":{"rendered":"

Every now and then Farm CEOs who just purchased my Farm Business Best Practice Management apps call or send emails to ask for help with getting up and running using them.<\/p>\n

That's why I provide step-by-step explanations about how to use my popular Excel-VB Poultry Farm Manager, using four annotated pictorial guides that give quick tips about how to use the software.<\/p>\n

In this week's issue of my Performance Improvement IDEAS newsletter, I explain the steps involved in using the Ration Formulator, using each of the pictorial guides.<\/em><\/p>\n

SCROLL DOWN TO READ FULL ARTICLE<\/strong><\/p>\n\n\n\n\n
\n

\"Tayo<\/a><\/h1>\n

Tayo Solagbade's<\/a>
\nPerformance Improvement <\/span>IDEAS
\n(PI Squared) Newsletter<\/strong><\/span><\/h1>\n

Monday 3rd April March\u00a02017<\/em><\/p>\n

\"Logo<\/a><\/p>\n


\nNB: <\/strong>This PI Squared newsletter will be published weekly, on Mondays, in place of the Speaking\/Web Marketing IDEAS newsletter, starting from today - 15th February 2016.<\/strong><\/em> I'm reinventing my Monday newsletter content and theme, to accommodate my vision of serving the growing audience of serious minded individuals and organizations reaching out to me, with information, education. news and research findings designed to help them do what they do better.<\/p>\n

************<\/p>\n

\"View<\/span><\/a>\"Join<\/a>\"Connect<\/a>\"Connect<\/a><\/span>\"Connect<\/a><\/p>\n

PII 060: 4 Annotated Pictorial Guides You Need for Using Tayo Solagbade's Popular Livestock Ration Formulator<\/h1>\n

Every now and then Farm CEOs who just purchased my Farm Business Best Practice Management apps call or send emails to ask for help with getting up and running using them.<\/p>\n

That's why I provide step-by-step explanations about how to use my popular Excel-VB Poultry Farm Manager, using four annotated pictorial guides that give quick tips about how to use the software.<\/p>\n

In this week's issue of my Performance Improvement IDEAS newsletter, I explain the steps involved in using the Ration Formulator, using each of the pictorial guides.<\/em><\/p>\n

Click here to download the guides in a zipped folders<\/a>.<\/span><\/p>\n

I created and began sending them to buyers as extra \"quick start\" learning tools, when I noticed more Farm CEOs who bought the app had difficulty making out time from their busy schedules to read the detailed PDF guide I send each buyer.<\/p>\n

Download and study these 4 guide images.<\/p>\n

Print them out if you prefer.<\/p>\n

Either way, they will help you quickly learn to use the app.<\/p>\n

If you need any help making sense or use of the information provided, let me know.<\/p>\n

Note that you will have cause - in using the software to - \"try\" using variable values for feed ingredients, until the Pr+ value, Energy level and other important parameters for your feed turn out the way you want them.<\/strong><\/p>\n

Recall that you need a SOUND understanding of feed formulation principles (such as those described in the feed formulation handbook) to make effective use of this software.<\/p>\n

The common saying - Garbage-In Garbage Out - in relation to computers applies firmly here!<\/p>\n

Guide 1 - Nutrient Composition Table<\/h3>\n

Click UPDATE SETTINGS on the Ration Formulator\u2019s Menu to access this table<\/p>\n

\"guide-1-nutrient-composition-table\"<\/a><\/p>\n

The nutrient composition tablie is in a different worksheet from the ration computation table, which has formulas. New ingredients added to the nutrient contribution table instantly appear in the computation table\u2019s drop menus.<\/p>\n

For every ingredient that is chosen by the user in the computation table. All corresponding nutrient values (Protein, energy, calcium etc) entered for it in the nutrient table instantly appear in the corresponding columns in the computation table \u2013 via a database function.<\/p>\n

No need to type new values in, each time a new of different ingrendient is added. This app is futuristic in that it enables users easily add new ingredients or completely replace old ones and their nutrient without having to temper with the spreadsheet etc. So s\/he gets to focus on formulating the ration, rather than worrying about modifying a spreadsheet.<\/p>\n

The user clicks an ingredients name in the in-cell drop menu or via the floating data entry form. Clicking an ingredient\u2019s nae will post it in the cell and the database functions in the table will instantly cause its computed nutrient values to appear along the same row (drawing from the nutrient composition table where they would have been posted initially: A drop menu is also used to choose \u201cfixed\u201d or \u201cvariable\u201d label to assign to each ingredient.<\/p>\n

Guide 2 \u2013 Computing a Ration Formula Using the Excel-VB Driven App (Steps A to D)<\/h3>\n

\"guide-2-computing-a-ration-formula-using-the-excel-vb-driven-app\"<\/a><\/p>\n

At \"A<\/strong>\": Type target protein value you want in the final feed into \"Tgt Pr+(%).<\/em><\/p>\n

Below it, enter total kg of feed you want <\/em>to make.<\/em><\/p>\n

At \"B\"<\/strong>: Use the drop menus to choose <\/em>the crude protein sources you want to use. If you choose more than ONE CP <\/em>source, you MUST choose \"Mixture\" at <\/em>\"C\"<\/em><\/strong> in\"Variable No. 2<\/strong>\" under Pearson <\/strong><\/em>Square Inputs<\/em><\/strong><\/p>\n

Once the above is done, click the <\/em><\/strong>REFRESH button.<\/em><\/strong> The software will <\/em>\u00a0generate values for in the \"Estimated % <\/strong><\/em>\u00a0To Use In Ration\" section (below <\/em><\/strong>section \"C\")<\/em><\/strong>.<\/em><\/p>\n

At \"D<\/strong>\": You will now enter the <\/em>generated values into the data entry <\/em>fields for EACH ingredient at \"D<\/strong>\". Then <\/em>finish by clicking REFRESH to generate <\/em>the ration formula.<\/em><\/p>\n

Drop menus provided next to each ingredient name allows you specify if it is a Variable or Fixed ingredient. The app\u2019s computation takes this into consideration. If you forget to make up the totals to 100% the app will throw an error alert and force you to find and correct the mistake BEFORE you can progress.<\/p>\n

The table\u2019s total protein<\/strong> should equal the target Pr+ value you want in the ration you\u2019re formulating. If not, check the total % in ration (should be approx 100%) in the table. Sometimes minor changes to the variable ingredients will be needed to get the target protein right. The kcal ME\/g Calcium, Fibre (should ne within the desired range for your animals).<\/p>\n

You will check Ingredients Cost (Naira)<\/strong>. Compare to your budget. Make adjustments if needed \u2013 possibly using cheaper alternatives. Note that the app instantly inserts user entries in the data form, into the correct location on the spreadsheet. The user need not interact with the spreadsheet at all. And when the right formula is obtained, it can be stored (by clicking the \u201cStore this formula<\/strong>\u201d button on the worksheet and\/or printed out by clicking the \u201cPrint Preview<\/strong>\u201d button on the worksheet.<\/p>\n

Guide 3 \u2013 Error Handling to Ensure You Get Reliable Ration Formulas<\/h3>\n

The app formats relevant formula cells in the password protected ration formulation area. They turn red when \u201cinvalid\u201d.<\/p>\n

\"guide-3-error-handling-to-ensure-you-get-reliable-ration-formulas\"<\/a><\/p>\n

If the error is not corrected, the user will not be allowed to move beyond that stage. In the instance below, the TOTAL% in ration is less than 100%<\/strong>. The user must clear whatever caused that error before s\/he can continue with the ration formulation.<\/p>\n

In contrast, manual Excel workbooks created for feed formulation typically allow such severe errors go unnoticed, since no in-build error handling exists.<\/p>\n

Bear in mind that this application has evolved over the years, based on feedback from users, to improve the \u201creliable and safe use\u201d. The original version built in 2004 was not as enhanced as this.<\/p>\n

Guide 4 \u2013 This app generates THIS print-ready Pearson Square formula and diagram page<\/h3>\n

The app is based on an improved version of the Pearson Square technique. It generates a print-ready formula and diagram. At the bottom of the print page, the user is reminded using a set of bullet points of rules guiding feed formulation based on this ration formulation technique.<\/p>\n

\"guide-4-the-app-generates-this-print-ready-pearson-square-formula-and-diagram-page\"<\/p>\n

Excel-VB Driven Ration Formulator<\/span><\/h2>\n

\"Click<\/a><\/p>\n

1. <\/strong><\/span>Click here<\/a> to learn more about this app - watch demo videos etc<\/span><\/p>\n

2.<\/strong> Click here<\/a> 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.<\/p>\n

Click here<\/a> to contact me about purchasing this product.<\/span><\/span><\/span><\/h3>\n

EXCEL-VB DRIVEN <\/span><\/strong>POULTRY LAYER FARM MANAGER SOFTWARE<\/span><\/h1>\n

Click here<\/a> 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.<\/strong><\/p>\n

\"Click<\/a><\/h3>\n

Click here<\/a> to contact me about purchasing this product.<\/span><\/h3>\n

SDN Blog\u2122<\/strong><\/h3>\n

New posts from last week*<\/span><\/p>\n

Monday<\/span>:<\/strong><\/span><\/p>\n

\n

PII 059: Read This And Understand Why Your Internet Access Is Sometimes Slow<\/a><\/h2>\n
<\/div>\n

[Tuesday]<\/span>:<\/strong><\/h2>\n<\/div>\n
\n

Empower Your Daughter to be Her Own Boss With Minimal Resources Via Vocation She Can Build on to Excel [Case Study: Cosmetic Makeup and Gele Tying]<\/a><\/h2>\n

<\/h2>\n<\/div>\n

[Wednesday<\/span>]:<\/strong><\/span><\/p>\n

\n

N\/A<\/h2>\n<\/div>\n

[Thursday<\/span>]:<\/strong><\/span><\/p>\n

N\/A<\/h2>\n

[Friday<\/span>]:<\/strong><\/p>\n

[RECOMMENDED] My Lord, Tell Me Where To Keep Your Bribe? \u2013 By Niyi Osundare (Renowned Nigerian poet)<\/a><\/h2>\n

[Saturday<\/span>]:<\/strong><\/h2>\n

N\/A<\/h2>\n

[Sunday<\/span>]:<\/strong><\/span><\/p>\n

[RECOMMENDED] Understanding Relative and Absolute Cell References in MS Excel<\/a><\/h2>\n
<\/div>\n
\n

The FARM CEO (Issue 77): GFIA \u2013 Global Forum for Innovations in Agriculture, 5th Commercial Farm Africa<\/a><\/h2>\n<\/div>\n

<\/h2>\n<\/td>\n<\/tr>\n

\n

\"\"<\/a><\/p>\n

Tayo K. Solagbade*<\/span><\/span><\/p>\n

Self-Development\/Performance Improvement Specialist<\/strong><\/p>\n

*Best Practice Farm Business Support Specialist & Founder of the MS Excel Heaven Visual Basic Automation Club and Competition<\/em><\/span><\/p>\n

Mobile:<\/strong> +234-803-302-1263 (in Nigeria<\/strong>) or +229-66-122-136 (in Benin Republic<\/strong>)<\/p>\n

http:\/<\/a><\/span>\/www.tayosolagbade.com<\/a><\/p>\n

Tayo K. Solagbade<\/a> is a Location Independent Performance Improvement<\/b><\/p>\n

Specialist and Multipreneur (i.e. a highly versatile\/multi-skilled entrepreneur), with a bias for delivering Best Practice solutions to Farm Businesses and others.<\/p>\n

Since 2002, he has earned multiple streams of income providing individuals and organizations with personal development training and coaching, custom MS Excel-VB solutions<\/a>, web marketing<\/a> systems\/web hosting<\/a>, freelance writing services, and best practice extension support services (for farm business owners<\/a>).<\/p>\n

Tayo is the author of the Self-Development (SD) Bible\u2122<\/a> and the popular Livestock Feed Formulation<\/a> Handbook. He is also the developer of its accompanying Excel-VB driven Ration Formulator\u2122<\/a> and the Poultry Farm <\/a>Manager\u2122 software.<\/p>\n

He has delivered talks\/papers to audiences in <\/a>various groups and organizations, including the Centre for Management Development, University of Lagos, Christ Baptist Church, Volunteer Corps, Tantalisers Fast Foods and others.<\/p>\n

In May 2012 he was the Guest Speaker at the Centre for Entrepreneurship Development\u2019s Annual Semester Entrepreneurial Lecture at Yaba College of Technology in Lagos.<\/p>\n

On 1st April 2013, Tayo (who reads, write and speaks the French language) relocated to Cotonou, Benin Republic<\/a> to begin slowly traveling across the West African region.<\/p>\n

His key purpose is to deliver talks, seminars <\/strong>and workshops on his key areas of focus and interest to interested audiences (Email tayo at tksola dot com for details).<\/p>\n

In a previous life, before leaving to become self-employed, Tayo served for seven years (October 1994 to December 2001) as a high performing manager in Guinness Nigeria. He rose from Shift Brewer to Training & Technical Development Manager, and later acted in senior roles as Production Manager and Technical Manager.<\/p>\n

In addition to constantly challenging the status quo and influencing positive work changes, he built a reputation for using self-taught spreadsheet programming skills (starting with Lotus 1-2-3, and later moving to Excel Visual Basic) - in his spare time - to develop Automated Spreadsheet Applications to computerize manual report generation processes in the departments he worked. Over four(4) of his applications were adopted for brewery level reporting.<\/strong><\/a><\/p>\n

Tayo holds a B.Sc degree in Agricultural Extension Services from the University of Ibadan, Nigeria, having graduated top of his class - with Second Class Upper Division honors - in 1992. He is an Associate Member of the UK Institute & Guild of Brewing, a 1997 National Finalist of the Nigerian Institute of Management\u2019s(NIM) Young Managers\u2019 competition, a Certified Psychometric Test Administrator for Psytech UK, innovator of Spontaneous Coaching for Self-Development\u2122 (SCfS-D\u2122), and Founder of the Self-Development Academy (SDAc)<\/a>.<\/p>\n

When he's not amazing clients with his superhuman skills (wink), Tayo works as the creative force behind his Daily Self-Development Nuggets blog<\/a> - on which he also publishes The Farm CEO Weekly Newspaper (sent via email to paid subscribers) and his Weekly Performance Improvement IDEAS<\/a> newsletter.<\/p>\n

You can connect with him on Twitter @tksola.com<\/a> and Facebook<\/a>.<\/p>\n

Visit Tayo Solagbade Dot Com<\/a>, to download over over 10 performance improvement resources to boost your personal and work related productivity.<\/p>\n

====
\n[IMPORTANT NOTE:====<\/h3>\n

On 4th May 2014, Tayo's 9 year old domain (Spontaneousdevelopment dot com), which hosted his website, was taken over by Aplus.net.<\/em><\/p>\n

Within a few days however, Tayo used his advanced self-taught web development skills to build a SUPERIOR \"reincarnation\" of it the website http:\/\/www.tayosolagbade.com<\/a>.<\/p>\n

But updates are still ongoing to URLs bearing the old domain name in most of the over 1,000 web pages, and blog posts <\/strong><\/em>he's published.<\/p>\n

If you experience any difficulties finding a page or document, email Tayo at tksola dot com.<\/p>\n

Click \"Tayo, What Happened to SpontaneousDevelopmentDotCom<\/a> ?\" to read a detailed narrative about how the above event occurred :-))<\/p>\n

Here's an article Tayo wrote, to inspire others to defy adversity, and bounce back to even greater reckoning at what they do EVERY time:<\/h4>\n
\n

Succeed by Emerging from Adversity Like a Phoenix<\/a><\/p>\n

(TayoSolagbade.com launches extra Hosting plan with FREE Web Marketing!)<\/p>\n<\/div>\n

And he wrote the one below, to explain why losing a domain name, no matter how old, NO LONGER determines your online success or otherwise:<\/h4>\n

A Proven Strategy to Find Profitable Buyers Regardless of Your Domain Name<\/a>
\n==================<\/p>\n

\"View<\/span><\/a>\"Join<\/a>\"Connect<\/a>\"Connect<\/a><\/span><\/span>\"Connect<\/a><\/p>\n

Home<\/a> |About<\/a> | Contact<\/a> | SD Nuggets\u2122<\/a> | Speaking\/Web Marketing IDEAS<\/a> | Web Marketing Systems<\/a> | Freelance Writing<\/a> | MS Excel\u00ae Heaven\u2122<\/a> | Cost-Saving Farm Biz Ideas<\/a><\/span><\/p>\n

\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

Every now and then Farm CEOs who just purchased my Farm Business Best Practice Management apps call or send emails to ask for help with getting up and running using them. That's why I provide step-by-step explanations about how to use my popular Excel-VB Poultry Farm Manager, using four annotated pictorial guides that give quick […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,1375,133,1,266,1753],"tags":[2839,2838],"class_list":["post-11744","post","type-post","status-publish","format-standard","hentry","category-entrepreneurs","category-excel-vb-solutions","category-farm-biz","category-general-2","category-my-dn-travel-news","category-the-farm-ceo","tag-4-annotated-pictorial-guides-you-need-for-using-tayo-solagbades-popular-livestock-ration-formulator","tag-pii-060"],"aioseo_notices":[],"views":1027,"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/11744","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/comments?post=11744"}],"version-history":[{"count":3,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/11744\/revisions"}],"predecessor-version":[{"id":11753,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/11744\/revisions\/11753"}],"wp:attachment":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/media?parent=11744"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/categories?post=11744"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/tags?post=11744"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}