{"id":12081,"date":"2017-06-01T16:50:24","date_gmt":"2017-06-01T16:50:24","guid":{"rendered":"http:\/\/tayosolagbade.com\/sdnuggets\/?p=12081"},"modified":"2017-06-01T16:53:37","modified_gmt":"2017-06-01T16:53:37","slug":"mind-map-anatomy-of-dynamic-ration-computation-table-in-tayo-solagbades-excel-vb-ration-formulator","status":"publish","type":"post","link":"http:\/\/tayosolagbade.com\/sdnuggets\/mind-map-anatomy-of-dynamic-ration-computation-table-in-tayo-solagbades-excel-vb-ration-formulator\/","title":{"rendered":"[Mind Map] Anatomy of Dynamic Ration Computation Table in Tayo Solagbade\u2019s Excel-VB Ration Formulator"},"content":{"rendered":"

This article offers a mind-map based anatomy (see image below) of the Dynamic Ration Computation Table that is at the heart of the functionality in my popular Excel-VB Driven Ration Formulator Software<\/a>.<\/em><\/p>\n

My purpose here is to offer potentially useful practical insights into the thinking behind the construction of that table, for best practice purposes.<\/p>\n

This would benefit anyone interested in better understanding how this app works, as well as those interested in learning how to build time, effort and cost-saving worksheet data entry and report generation tables.<\/p>\n

\"rfapp-analysis-xlh\"<\/a><\/p>\n

Members of my Excel Heaven Visual Basic Automation Club will get FREE copies of the step-by-step screenshot tutorial video, in which I explain how this dynamic table was built from scratch.<\/strong><\/p>\n

You can watch a step-by-step screenshot demonstration tutorial of this app in use at www.tinyurl.com\/RealRationDemo<\/a><\/p>\n

Below are explanations of the functions of the formulas in each of the key columns in the ration computation table. <\/strong><\/em><\/p>\n

In the screenshot demonstration video tutorial that will be sent to member of my Excel Heaven Visual Basic Automation club<\/a>, I explain how EACH formula is constructed, with regard to syntax etc. Click here to request a copy<\/a>.<\/p>\n

1. Price\/Unit (Kg)<\/h3>\n

=IF(D3=\"\",\"\",IF(D3=0,0,INDEX(feedIngredientsDbase,MATCH(D3,nfFeedIngredients,0),10)))<\/p><\/blockquote>\n

When you choose an \u201cIngredient Name\u201d from the drop menu in a cell in column \u201cD\u201d, the above formula retrieves the matching Price\/Unit for the item, from the \u201cSettings\u201d worksheet (which holds the Nutrients Composition for ALL the ingredients available for use along with their prices on a row by row basis)<\/p>\n

2. Pr% in ration<\/h3>\n

=IF(D3=\"\",0,IF(D3=0,0,(INDEX(feedIngredientsDbase,MATCH(D3,nfFeedIngredients,0),2)*$E3)\/100))<\/p><\/blockquote>\n

When you you choose an \u201cIngredient Name\u201d from the drop menu in a cell in column \u201cD\u201d, the above formula retrieves the matching PERCENT %PROTEIN VALUE for the Item, from the \u201cSettings\u201d worksheet<\/p>\n

3. Amount (Kg) Std \u2013 50Kg<\/h3>\n

=IF($H$26=\"\",(E3\/100)*50,(E3\/100)*$H$26)<\/p><\/blockquote>\n

This formula uses the \u201c% in Ration\u201d value in each ingredient row\/cell to derive the physical \u201cAmount(Kg)\u201d of THAT ingredient that will make up part of the \u201cTarget Feed Size (kg)\u201d i.e. total kg feed you want to mill. Same formula adjusted Works for \u201cCalcium in Ration\u201d and \u201cFibre% in Ration\u201d columns<\/p>\n

4. kcal ME\/ in ration<\/h3>\n

=IF(D3=\"\",\"\",IF(D3=0,0,(E3\/100)*INDEX(feedIngredientsDbase,MATCH(D3,nfFeedIngredients,0),5)))<\/p><\/blockquote>\n

This formula uses the \u201c% in Ration\u201d value you type in each ingredient row\/cell to derive the equivalent ENERGY contribution (kcal ME\/g) from THAT ingredient to the total amount of feed to be milled.<\/p>\n

This Ration Computation Table uses the above highlighted formulas to create a dynamic effect that enables the user focus on posting his\/her preferred \u201c% in Ration\u201d values for ANY combination of feed ingredients s\/he wishes to use in deriving a specific ration formula.<\/h3>\n

The table returns instant ration formulas, complete with prices with every change, until s\/he arrives at one that meets his\/her needs.<\/p>\n

This approach makes it easy for the user of this Ration Computation table to quickly TEST different combinations of ingredients, based on their respective prices, as well as their nutrient content (e.g. protein , energy, calcium and fibre).<\/p>\n

Without this method the user would have to REPEATEDLY type in the respective values for each of those variables anytime the \u201cIngredient Name changed on a specific row.<\/p>\n

Major time\/effort savings would be lost. And chances of avoidable user data entry errors greatly increased!<\/p>\n

Members of my Excel Heaven Visual Basic Automation Club will get FREE copies of the step-by-step screenshot tutorial video, in which I explain how this dynamic table was built from scratch.<\/h3>\n

Click here to request a copy of the video tutorial<\/a>.<\/p>\n

Visit www.excelheaven.biz<\/a> to learn more about the club.<\/p>\n","protected":false},"excerpt":{"rendered":"

This article offers a mind-map based anatomy (see image below) of the Dynamic Ration Computation Table that is at the heart of the functionality in my popular Excel-VB Driven Ration Formulator Software. My purpose here is to offer potentially useful practical insights into the thinking behind the construction of that table, for best practice purposes. […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1375,133,266,1753],"tags":[2947,2948],"class_list":["post-12081","post","type-post","status-publish","format-standard","hentry","category-excel-vb-solutions","category-farm-biz","category-my-dn-travel-news","category-the-farm-ceo","tag-anatomy-of-dynamic-ration-computation-table-in-tayo-solagbades-excel-vb-ration-formulator","tag-mind-map"],"aioseo_notices":[],"views":1000,"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/12081","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=12081"}],"version-history":[{"count":3,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/12081\/revisions"}],"predecessor-version":[{"id":12085,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/12081\/revisions\/12085"}],"wp:attachment":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/media?parent=12081"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/categories?post=12081"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/tags?post=12081"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}