{"id":11399,"date":"2017-02-09T23:38:58","date_gmt":"2017-02-09T23:38:58","guid":{"rendered":"http:\/\/tayosolagbade.com\/sdnuggets\/?p=11399"},"modified":"2017-02-09T23:50:23","modified_gmt":"2017-02-09T23:50:23","slug":"potential-spreadsheet-automation-benefits-that-farm-businesses-need-to-succeed-betterpotential-spreadsheet-automation-benefits-that-farm-businesses-need-to-succeed-better-hint-insights-from-agribusi","status":"publish","type":"post","link":"http:\/\/tayosolagbade.com\/sdnuggets\/potential-spreadsheet-automation-benefits-that-farm-businesses-need-to-succeed-betterpotential-spreadsheet-automation-benefits-that-farm-businesses-need-to-succeed-better-hint-insights-from-agribusi\/","title":{"rendered":"Potential Spreadsheet Automation Benefits that Farm Businesses Need to Succeed Better [Hint: Insights from Agribusiness Research Survey Interview of Farm Industry Stakeholders]"},"content":{"rendered":"<blockquote><p>This article features - and discusses (with charts) - responses to questions in an agribusiness research survey questionnaire I circulated a few years ago.<\/p>\n<p>The semi-structured questionnaire was used to solicit responses from farm owners, feed makers and extension experts. Some were buyers\/users of my\u00a0<a href=\"http:\/\/tinyurl.com\/RealRationDemo\" target=\"_blank\">Excel-VB Ration Formulator\u2122<\/a>.<\/p><\/blockquote>\n<p><strong><em>CEOs of smallholder (fish, pig, and poultry) farm businesses make up 80% of respondents (30% of them own feed mills, to control feed cost\/quality), and 20% are farm support specialists.<\/em><\/strong><\/p>\n<p>22.2% of those who formulate their rations use the Excel-VB driven Ration Formulator\u2122. Others use off-the-shelf software (11.1%), manual Excel workbooks (11.1%), and calculators (11.1%).<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-11404\" src=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/02\/sdn-agribizpapee-cht3a.png\" alt=\"sdn-agribizpapee-cht3a\" width=\"580\" srcset=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/02\/sdn-agribizpapee-cht3a.png 767w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/02\/sdn-agribizpapee-cht3a-300x103.png 300w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/02\/sdn-agribizpapee-cht3a-150x52.png 150w\" sizes=\"(max-width: 767px) 100vw, 767px\" \/><\/p>\n<p><strong>Over 75% of the respondents were 41 years old and above. At least 55.6% hold a University Masters degree; one is a PhD holder, and some also hold professional qualifications.<\/strong><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-11400\" src=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/02\/sdn-agribizpapee-cht5b.png\" alt=\"sdn-agribizpapee-cht5b\" width=\"580\" srcset=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/02\/sdn-agribizpapee-cht5b.png 828w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/02\/sdn-agribizpapee-cht5b-300x89.png 300w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/02\/sdn-agribizpapee-cht5b-768x229.png 768w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/02\/sdn-agribizpapee-cht5b-150x45.png 150w\" sizes=\"(max-width: 828px) 100vw, 828px\" \/><\/p>\n<p><strong>Not surprisingly, all 55.6% say they always aim for least cost feed formulation. This suggests they are likely to adopt customizable Excel apps that quickly and accurately formulate rations.<\/strong><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-11405\" src=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/02\/sdn-agribizpapee-cht4.png\" alt=\"sdn-agribizpapee-cht4\" width=\"580\" srcset=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/02\/sdn-agribizpapee-cht4.png 819w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/02\/sdn-agribizpapee-cht4-300x94.png 300w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/02\/sdn-agribizpapee-cht4-768x240.png 768w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/02\/sdn-agribizpapee-cht4-150x47.png 150w\" sizes=\"(max-width: 819px) 100vw, 819px\" \/><\/p>\n<p>Those who own feed mills will thus confidently formulate useful rations for themselves, and other farmers who come to their mills. Multiple benefits will thus accrue to the industry.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-11406\" src=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/02\/sdn-agribizpapee-cht6.png\" alt=\"sdn-agribizpapee-cht6\" width=\"580\" srcset=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/02\/sdn-agribizpapee-cht6.png 784w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/02\/sdn-agribizpapee-cht6-300x129.png 300w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/02\/sdn-agribizpapee-cht6-768x331.png 768w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/02\/sdn-agribizpapee-cht6-150x65.png 150w\" sizes=\"(max-width: 784px) 100vw, 784px\" \/><\/p>\n<p><strong>55.6% buy commercial feed (from \"2 sources\" or \"anywhere they can find\"). 66.7% of that percentage says they their animals' performances vary noticeably with different sources of feed.<\/strong><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-11402\" src=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/02\/sdn-agribizpapee-cht2a.png\" alt=\"sdn-agribizpapee-cht2a\" width=\"580\" srcset=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/02\/sdn-agribizpapee-cht2a.png 737w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/02\/sdn-agribizpapee-cht2a-300x95.png 300w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/02\/sdn-agribizpapee-cht2a-150x48.png 150w\" sizes=\"(max-width: 737px) 100vw, 737px\" \/><\/p>\n<p>Their farm output tends to fluctuate as a result - and that naturally bothers the farmers.<\/p>\n<p><strong><a href=\"http:\/\/excelheaven.tayosolagbade.com\/?p=822\" target=\"_blank\">Hen Day Percentage (HDP) data auto-charted - in September 2013 - by a custom Excel-VB software built for a layers farm in South West Nigeria<\/a>, appears to support the above.<\/strong><\/p>\n<p>When the two farm managers were asked about a sharp downward slope of charted HDP data, over a one week period (from above 70% to between 55 and 65%), their checks revealed it coincided with their use - due to cash flow problems - of feed from a different supplier!<\/p>\n<p>Customizable Excel-VB driven tools can help such farmers consistently formulate their own feed to specification. More predictable livestock performance and reduced feeding expenses will occur, and ultimately lead to increased profits.<\/p>\n<p><a href=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/02\/sdn-agribizpapee-cht6.png\" rel=\"attachment wp-att-11406\"><img decoding=\"async\" class=\"alignnone size-full wp-image-11406\" src=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/02\/sdn-agribizpapee-cht6.png\" alt=\"sdn-agribizpapee-cht6\" width=\"580\" srcset=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/02\/sdn-agribizpapee-cht6.png 784w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/02\/sdn-agribizpapee-cht6-300x129.png 300w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/02\/sdn-agribizpapee-cht6-768x331.png 768w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/02\/sdn-agribizpapee-cht6-150x65.png 150w\" sizes=\"(max-width: 784px) 100vw, 784px\" \/><\/a><\/p>\n<p>Read:\u00a0<a href=\"http:\/\/excelheaven.tayosolagbade.com\/?p=822\" target=\"_blank\">One New Skill Modern Extension Professionals Need to Succeed<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This article features - and discusses (with charts) - responses to questions in an agribusiness research survey questionnaire I circulated a few years ago. The semi-structured questionnaire was used to solicit responses from farm owners, feed makers and extension experts. Some were buyers\/users of my\u00a0Excel-VB Ration Formulator\u2122. CEOs of smallholder (fish, pig, and poultry) farm [&hellip;]<\/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,266,1753],"tags":[2731,2732],"class_list":["post-11399","post","type-post","status-publish","format-standard","hentry","category-entrepreneurs","category-excel-vb-solutions","category-farm-biz","category-my-dn-travel-news","category-the-farm-ceo","tag-hint-insights-from-agribusiness-research-survey-interview-of-farm-industry-stakeholders","tag-potential-spreadsheet-automation-benefits-that-farm-businesses-need-to-succeed-better"],"aioseo_notices":[],"views":745,"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/11399","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=11399"}],"version-history":[{"count":3,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/11399\/revisions"}],"predecessor-version":[{"id":11409,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/11399\/revisions\/11409"}],"wp:attachment":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/media?parent=11399"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/categories?post=11399"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/tags?post=11399"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}