Category Archives: General

Custom Spreadsheet Applications Are NOT Only for Accounting or Financial Reporting [Hint: Case Study of Tayo Solagbade’s Excel-VB Poultry Farm Manager – an Entreprise Information System]

The video screenshot below (click here to watch it) is of an Excel-VB spreadsheet software (called Poultry Farm Manager™) that I built – in 2014 – for a large poultry layer farm in Ekiti state, Southwest Nigeria, owned by a Nigerian diplomat, who was then based in a Francophone West African nation.

vid-youtube-shot

In 2009, I built the very first version of that app, for a 12,000 layer farm in Ogun State, also in South West Nigeria – owned by an entrepreneurial client couple.

Over they years, I’ve gotten lots of attention for this singular app, confirming my gut level instinct that smallholder Farm CEOs across the world are generally neglected in terms of their data handling and report generation for timely/accurate decision making needs.

But – contrary to assumptions made by some of the farm business owners who come to me, this Poultry Farm Manager app is NOT an accounting application.

Yes, it does income and expense recording and reports weekly, monthly and annually as indicated in the video.

However its main purpose is to record daily operations data so as to auto-generate Key Performance Indicators (KPIs) for determining how well the animals are doing on a DAILY basis.

As data is punched in, the automated charts are instantly plotted for KPIs like feeding rates, Hen Day Percentage, Mortality Rate; Feed to Egg Conversion Ratio.

The trend of the charted data quickly tells you if there’s anything to worry about. And you can then take corrective action.

I call my applications of this kind “Enterprise Information Systems” (EIS).

This Poultry Farm Manager spreadsheet application originally catered for poultry layers farm operations…

But following inquiries/requests from Farm CEOs reaching out to me from within and outside Africa; I have since included an interface that handles data entry and report generation for a broiler operation.

This includes auto-generation of feeding rate, feed to flesh conversion ratio, mortality rate, growth rate etc, on a daily, weekly, monthly and annual basis.

Those are the KPIs it measures.

What custom spreadsheet software solution or “Enterprise Information Systems” (EIS) do YOU need?

I have a vision to help small holder farmers (and  other businesses) adopt intelligent and cost-effective custom software solutions to manage their farm business more profitably for the long term.

This is why I’m being deliberate in finding the RIGHT clients to work with. It’s NOT a matter of how much money you’re willing to pay, but how committed you will be to making  use of the solution developed to solve a real life problem you have, in a way that it can be used to help others.

If the above describes YOU, fill and submit the form on the page linked here (click).

PII 052: Real Life Farm Business Case Study – Excel-VB Ration Formulator Spreadsheet Software Anatomy

In this week’s issue of my Performance Improvement Ideas (PII) newsletter, I discuss – using annotated screenshot images – design considerations employed in developing my popular Excel-VB Ration Formulator spreadsheet software.

Prospective buyers, as well as users/owners of this app curious to better understand how it works, and how to make more productive use of it, will find reading this a useful experience – as would persons interested in learning how to build commercial quality apps with user friendly features.

This is a real life farm business case study designed to offer potentially useful insights other business users can learn from, in building zero cost custom apps to solve real life problems. 

SCROLL DOWN TO READ FULL ISSUE

Tayo Solagbade's Performance Improvement IDEAS(PI Squared) Newsletter

Tayo Solagbade’s
Performance Improvement
IDEAS
(PI Squared) Newsletter

Monday 6th February 2017

Logo - Tayo Solagbade's Self-Development Academy


NB: 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.
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.

************

View Tayo Solagbade's video tutorials and demonstrations on Facebook Productivity Tips, Web Marketing, and for his Custom MS Excel-VB driven software applicationsJoin the SD Nuggets community on Facebook.comConnect with Tayo on Twitter.comConnect with Tayo on Google PlusConnect with Tayo on LinkedIn.com

PII 052: Real Life Farm Business Case Study – Excel-VB Ration Formulator Spreadsheet Software Anatomy

In this week’s issue of my Performance Improvement Ideas (PII) newsletter, I discuss – using annotated screenshot images – design considerations employed in developing my popular Excel-VB Ration Formulator spreadsheet software.

Prospective buyers, as well as users/owners of this app curious to better understand how it works, and how to make more productive use of it, will find reading this a useful experience – as would persons interested in learning how to build commercial quality apps with user friendly features.

This is a real life farm business case study designed to offer potentially useful insights other business users can learn from, in building zero cost custom apps to solve real life problems. 

The information provided is designed to guide the app’s user to become familiar with making use of the app. But it also highlights the thinking that guided design of the different interfaces and features/functions.

This was done to provide the farm CEO, his/her personnel (with skills to function as in-house developers) and possibly extension specialists, information and insights to enable them develop similar apps on their own, at zero cost, to solve other data handling and report generation problems.

4a. Control of Unauthorized Access to Ration Formulation Workbooks is Crucial

The Excel-VB Ration Formulator application is not a normal Excel workbook. When opened, it remains in a small window due to initial disabling of Excel-VB code in it. A PDF user guide (and a 4 part video screenshot tutorial) explains (and demonstrates) how to get to – and past – the login screen (shown above).

xlvbapp-case-study-tip1

A ration formulation workbook typically holds sensitive information, which if tampered with could have serious consequences. The login screen (left above) prevents unauthorized users from gaining access to the contents of this workbook app. A username and password assigned to the licensed owner grants user access.

Following login, the Navigation Menu ensures the user does not stray. S/he clicks the appropriate command button to move directly to the desired interface.

The easy-to-understand interface greatly reduces the need for formal Excel training of end users – especially farm business owners who often have a lot on their hands, and could struggle to make out time to learn Excel in order to use it. The intuitive graphic user interfaces make it possible for a complete Excel novice to use the Excel-VB Ration Formulator.

To ensure success, extension specialists or farm CEOs who choose to develop their own custom apps for use in managing farm business operations will need to build in similar user friendly features to enable ease-of-use.

4b. Best Practice Worksheet Design Is Essential to a Error-Free Use

Figure 3: This nutrient composition table is in a different worksheet from the ration computation table, which has formulas that draw on values from the former. Names of new ingredients added to the nutrient composition table instantly appear in the ration computation table’s drop menus.

For every ingredient that’s chosen by the user in the computation table(below) ALL corresponding nutrient values (protein, energy, calcium etc) entered for it, in the nutrient table (above) instantly appear in the corresponding columns in the composition table – via a database function. No need to type new values in, each time a new or different ingredient is added. This app is futuristic in that it enables users easily add new ingredients or completely replace old ones and their nutrients without having to tamper with the spreadsheet etc. So s/he gets to focus on formulating the ration, rather than worrying about modifying a spreadsheet.

 

xlvbapp-case-study-tip2

Above: The user clicks an ingredient’s name in the in-cell drop menu or via the floating data entry form (see below). Clicking an ingredient’s name 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 “fixed” or “variable” label to assign to each ingredient.

4c. Computing a Ration Formula Using the Excel-VB Driven App (Steps A to D)

xlvbapp-case-study-tip3

At “A” Type target protein value into the field labeled “Tgt Pr+ (%)”. Below it, enter total kg of feed you want to make

At “B” Use the drop menus to choose the crude protein sources you want to use

If you choose more than ONE CP source, you MUSTU choose “Mixture” at “C” in the “Variable No. 2” drop menu under Pearson Square Inputs. Once the above is done, click the REFRESH button. The software will generate values into the grey boxes in the “Estimated % To Use In Ration” section (see “C” above).

At “D” You will now enter the values from “C” above into the data entry fields for EACH ingredient at “D” e.g. 55.57 for Maize. Then click the REFRESH button. The formulated ration will be updated on the form (and also on the worksheet).

Drop menus provided next to each ingredient name allow you specify if it is a Variable of Fixed ingredient. The app’s 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.

The table’s total protein should equal the target Pr+ value you want in the ration you’re 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 be within desired range for your animals).

You will check Ingredients Cost (Naira). Compare to your budget. Make adjustments if needed – possibly using cheaper alternatives. Note that the app instantly inserts user entries in on 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 “Store this formula” on the worksheet and/or printed out by clicking the “Print Preview” on the worksheet.

4d. Smart Error Handling Ensure Users Get Reliable Ration Formulas

xlvbapp-case-study-tip4

The app formats relevant formula cells in the password protected ration formulation area. They turn RED when “invalid” values appear in them. And it throws an error alert prompt notifying the user.

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%. The user must clear whatever caused that error before s/he can continue with the ration formulation.

In contrast, manual Excel workbooks created for feed formulation typically allow such severe errors go unnoticed, since no in-built error handling exists.

Bear in mind that this application has evolved over the years, based on feedback from users, to improve the “reliable and safe use”. The original version built in 2004, was not as enhances as this.

4e. Custom Excel Apps Can Use Different Ration Formulation Techniques

xlvbapp-case-study-tip5

This app is based on an improved version of the Pearson Square computation technique, which – unlike the original version – allows for feed formulation using more than one protein source/ingredients at a time. It generates a print-ready formula and diagram.

At the bottom, the user is reminded of rules guiding feed formulation via this technique

Read: If You Don’t Understand Feed Formulation, You Cannot Formulate Feed Correctly [Hint: Answers to a Farm CEO’s Whatsapp Queries About Feed Formulation]

 

4f. Farmers Must Know the Full Nutrient Profiles of their Animals

Example of Broiler Starter Ration profile a farmer will formulate a ration to meet

xlvbapp-case-study-tip6

Click here to let me know if you’d like to learn more about how to build a commercial quality Excel-VB driven spreadsheet application to improve your work, or that you can sell to clients.

Excel-VB Driven Ration Formulator

Click to view larger screenshot

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 watch a screenshot demonstration of the Excel-VB Driven Poultry Farm Manager I built for a client farm business in Ekiti state, South West Nigeria.

Click here to contact me about purchasing this product.

SDN Blog™

New posts from last week*

Monday:

[Wednesday]:

[Thursday]:

[Recommended] Why Nigerians Hate Igbo – by Chinua Achebe

[Friday]:

Two (2) Feed Formulation Compounding Problems Farm CEOs Need Extension Specialists to Help Them Solve

[Saturday]:

N/A

[Sunday]:

[Recommended] 16 Essential Terms You Must Know To Learn VBA Programming

The FARM CEO (Issue 72) : One New Skill Modern Extension Professionals Need to Succeed, The Need to Explore Cheaper Local Alternative Feed Ingredients In Formulating Least Cost Diets, Two (2) Feed Formulation Compounding Problems Farm CEOs Need Extension Specialists to Help Them Solve

Tayo K. Solagbade*

Self-Development/Performance Improvement Specialist

*Best Practice Farm Business Support Specialist & Founder of the MS Excel Heaven Visual Basic Automation Club and Competition

Mobile: +234-803-302-1263 (in Nigeria) or +229-66-122-136 (in Benin Republic)

http://www.tayosolagbade.com

Tayo K. Solagbade is a Location Independent Performance Improvement

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

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

Tayo is the author of the Self-Development (SD) Bible™ and the popular Livestock Feed Formulation Handbook. He is also the developer of its accompanying Excel-VB driven Ration Formulator™ and the Poultry Farm Manager™ software.

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

In May 2012 he was the Guest Speaker at the Centre for Entrepreneurship Development’s Annual Semester Entrepreneurial Lecture at Yaba College of Technology in Lagos.

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

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

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.

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.

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’s(NIM) Young Managers’ competition, a Certified Psychometric Test Administrator for Psytech UK, innovator of Spontaneous Coaching for Self-Development™ (SCfS-D™), and Founder of the Self-Development Academy (SDAc).

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

You can connect with him on Twitter @tksola.com and Facebook.

Visit Tayo Solagbade Dot Com, to download over over 10 performance improvement resources to boost your personal and work related productivity.

====
[IMPORTANT NOTE:====

On 4th May 2014, Tayo’s 9 year old domain (Spontaneousdevelopment dot com), which hosted his website, was taken over by Aplus.net.

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.

But updates are still ongoing to URLs bearing the old domain name in most of the over 1,000 web pages, and blog posts he’s published.

If you experience any difficulties finding a page or document, email Tayo at tksola dot com.

Click “Tayo, What Happened to SpontaneousDevelopmentDotCom ?” to read a detailed narrative about how the above event occurred :-))

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:

Succeed by Emerging from Adversity Like a Phoenix

(TayoSolagbade.com launches extra Hosting plan with FREE Web Marketing!)

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:

A Proven Strategy to Find Profitable Buyers Regardless of Your Domain Name
==================

View Tayo Solagbade's video tutorials and demonstrations on Facebook Productivity Tips, Web Marketing, and for his Custom MS Excel-VB driven software applicationsJoin the SD Nuggets community on Facebook.comConnect with Tayo on Twitter.comConnect with Tayo on Google PlusConnect with Tayo on LinkedIn.com

Home |About | Contact | SD Nuggets™ | Speaking/Web Marketing IDEAS | Web Marketing Systems | Freelance Writing | MS Excel® Heaven™ | Cost-Saving Farm Biz Ideas

[Recommended] Why Nigerians Hate Igbo – by Chinua Achebe

When I saw the thought provoking Facebook post/query (shown below) by Joe Ibekwe, I instantly recalled the words of Chinua Achebe in the last book he gifted us before passing on.

joe-igbos-hate

However, a quick check in my travel bag soon revealed, to my dismay, that I’d left my well read Copy of Achebe’s “There Was a Country” back in Cotonou.

Out of desperation, I Googled to find reviews or commentaries on the book that may have highlighted the sentiments expressed by Achebe, that I felt held the answers Joe (and others seeking insights) would appreciate.

I was not disappointed: I found EVERYTHING I needed – and even more…bless the Google team for making and keeping this search engine so powerful!

So much so, that I have NO need to add anything else.

Instead, I simply invite any persons interested in getting accurate answers to the excellent poser by Joe, to read Chinua’s words on the pages linked below:

Why Nigerians hate Igbo, by Chinua Achebe.

Let me note here that I’m Yoruba, but my LOVE for the positive attributes of the average Igbo person has NEVER been hidden.

Articles (like this one) on this blog provide verifiable proof of the fact that I admire those qualities in them and admonish other Nigerians and indeed Africans to emulate them.

Yet, even I have noticed certain shortcomings that characterize majority of them.

My respect for Chinua Achebe’s honesty and his capacity for balanced reasoning grew exponentially, when I read his words below, in which he identified certain Igbo tendencies that often make others despise them – in spite of their many positive attributes.

Here’s how Nigeria’s The Nation newspaper captured it in “Why Nigerians Hate Igbo – by Chinua Achebe”:

Achebe, however, saved some criticisms for his kinsmen. He criticised them for what he described as “hubris, overweening pride and thoughtlessness, which invite envy and hatred or even worse that can obsess the mind with material success and dispose it to all kinds of crude showiness.”

He added that “contemporary Igbo behavior(that) cab offend by its noisy exhibitionism and disregard for humility and quietness.”

Judging from my personal experiences as a conscious thinking adult over the past 30 years in paid and self-employment, I believe Achebe’s criticisms are spot on!

I honestly believe that if the average Igbo person minimizes display of any of the negative tendencies highlighted by Chinua Achebe, s/he is likely to experience little or no friction with most people from other tribes or cultures s/he encounters.

Let it be known however, that I speak primarily for MYSELF (and maybe others who think like me) and not for the generality of Nigerians, talk less Africans.

Many thanks to Joe Ibekwe for bringing this up. My half-Igbo kids are sure to benefit from the useful insights that this exercise will expose them to (Yep: I’m printing copies for them to read)!

Related Articles

1. “˜There Was a Country’: a review of Chinua Achebe’s Biafran memoir – By Ike Anya

2. Chinua Achebe reflects on Biafra, but for whom?

3. Igbo, Yoruba at war over Chinua Achebe’s criticism of Awolowo in new book

4. Succeeding Through Hard Work, Determination and Persistence: 3 Lessons from Nigeria’s Igbo Traders

Protected: The FARM CEO (Issue 71) : 11 Business Opportunities in Africa That Will Make More Millionaires in 2016, Investing in Africa’s agriculture is the next best thing, AGRICULTURE INVESTMENT IN AFRICA: TOP COUNTRIES TO FOCUS ON, African farming is the new frontier for brave investors

This content is password protected. To view it please enter your password below:

Succeed Even In Economic Recession by Developing Multiple Competencies [Hint: Become a Multipreneur]

When I decided to become – and later begin calling myself – a MULTIPRENEUR in 2004 (2 years after I became a startup), many people criticized me for “doing too many things”.

Some said I was trying to be a “Jack of All Trades” and anytime I had a setback they readily pointed out that THAT was the cause.

But I knew better, and simply ignored them – because my experiences had taught me that if I was to survive the harsh socio-economic environment I had to operate in as an entrepreneur, I needed to function as a multi-skilled entrepreneur aka Multipreneur.

The above is why it was intriguing, if not somewhat amusing for me to come across an article titled “Why entrepreneurs need multiple competencies” – on the website for a Nigerian National newspaper (Business Day).

multiple-competencies

A portion of the article’s abstract (reproduced below) really caught my attention:

“According to experts, multiple competencies save costs, enable entrepreneurs compete better than peers, attract…” Really? According to “experts” – what experts???

You mean like those who constantly lectured me in my startup years about the need to NOT do too many things, when I chose to use my “multiple competencies” to make more money with less effort, in less time and using fewer resources?

Experts? Huh…what a joke!

If truth be told, without my deliberately nurtured HABIT of developing and using my multiple competencies, I would have quit my business a long time ago, instead of outlasting adversity I’ve faced, by thriving in spite of repeated setbacks and disappointments.

My multipreneurial aptitude kept me going each time, because I always had a new or different skill, knowledge or attitude I could apply to get myself back on track each time I derailed, or to leapfrog to a new level of achievement as the need arose.

Sadly, when I was starting out, it was almost impossible to find people to respect and encourage me for displaying this trait in my society.

Most established entrepreneurs and so called experts frowned seriously at my tendency, and told me it was going to do me more harm than good.

Yet, I kept recalling how my abilities were saving me money, time and effort and so I knew they were wrong. What was more, at a point, I began to use my skills to help those who had cast aspersion on me for using them.

That was when I realized they had no clue what they were talking about when they were criticizing me. So I decided to begin writing about Multipreneuring, sharing true stories from my personal experiences of succeeding with it.

At the bottom of this article, I’ve appended links to some of those articles I’ve written on multipreneuring or what I like to call being a “Jack of Many Trades”

Today I have established a firm reputation as a reliable provider of a complementary mix of multidisciplinary solutions to clients within and outside Africa (see www.tayosolagbade.com, this blog, www.thefarmceo.net, www.excelheaven.biz and www.tksola.com – and relevant links on each site).

Hopefully, more people in this part of the world (Nigeria/Africa) will realize that developing and using multiple competencies is a sure way to boost one’s chances of succeeding in ANY field, regardless of the challenges you may have to face.

Related Articles

1. No. 128: Using Location Independent Multipreneuring to Achieve Public Speaking Success

2. If You Lack Capital, Intelligent Multipreneuring Can Help You Succeed!

3. More Real-Life Proof that Being an Intelligent Jack of Many Trades (aka Multipreneur), Can Make You Succeed More Often

4. You can SUCCEed MORE by being a Multipreneur – A True Story (Hint: New Book Coming Soon)

5.  To Achieve Uncommon Success, Avoid Specializing [Hint: New York Times Article About Steve Martin’s Amazing Success As a Multipreneur]!

6. Being a Jack of All Trades Doesn’t Mean You’re a Master of None – by Melanie Pinola on LifeHacker.com

7.  Knowing a Little of Everything Is Often Better Than Having One Expert Skill – by Adam Dachis on LifeHacker.com

Study Your Child’s Naughty Actions to Discover Her Genius [True Story: Secretly Keeping a Pet Turtle – Then Getting Caught & Flogged!]

Kids will always get into trouble. Every parent must accept this as a reality. What matters is how we help them LEARN from the mistakes they make, so they arrive adulthood as well rounded and competent individuals.

I for one got into all sorts of trouble between the ages of 10 and 16. Today, I coach my own kids (3 of them teenage boys) on a daily basis, and it’s NOT been funny dealing with their naughty sides.

I’ve however found my own past experiences from going through that phase quite useful in “parenting” them.

There’s however one very important insight I’ve since gained:

It’s that quite often, if you pay close enough attention, your child’s naughty actions may provide pointers to a natural gift, talent or ability that s/he may be able to exploit to achieve success in adult life via a formal income earning vocation.

In my case, my passion for wild life and agriculture as a child, reflects in the work I now do as an expert supporting livestock farmers, and providing agro-based solutions (like my Excel-VB Ration Formulator, Feed Formulation Handbook, Excel-VB Poultry Farm Manager, my Feed Formulation Home Study Video Series etc).

What follows below is a true story about one of my many naughty escapades as a school age child, which illustrates the point I’ve made above:

Secretly Keeping a Pet Turtle (Then Getting Caught & Flogged)!

Secretly Keeping a Pet Turtle (Then Getting Caught & Flogged)!

One day I caught a small turtle during one of our trips to catch crabs. It was about the size of my palm. I excitedly took it home, and secretly kept and fed it (I think earthworms – but not sure now) for months.

One day my brother, Femi found out about it. I pleaded with him to say nothing to our parents. He agreed.

But later on, when we had one of our few BIG quarrels as kids, he went and told my Dad that I was keeping a tortoise downstairs in the backyard, near the well.

My father was enraged, and called me to ask if it was true. I said it was. That night I got the beating of my life.

We had a Guava tree at the back of the house at Olodi-Apapa, where we lived then. Once you were to be flogged, the tree would “supply” some long slim branches. Oh, how I resented that tree!

After my punishment that night, my father asked me to get the turtle out of the old sink I’d kept it in, and take it to the car.

Then he drove right to the middle of the bridge that crossed the Lagoon (I believe it’s called Carter bridge), and asked me to drop the turtle into the water.

My heart bled as I did that, but I had no choice. It was obvious he was greatly upset that I’d brought a turtle home. But I did not know why. He never told me why. To myself I said: “Afterall, it’s not a snake!”

You may wonder why I kept the Turtle a secret in the first place.

In truth, I have no idea. We kept lots of cats (mother – and kittens she put to litter, which we gave out) and a dog in the house for years.

Maybe I anticipated my parents would say no to another pet.

But I must say I never expected such an extreme reaction from my Dad. Many years later, I asked my mother about it, and she explained that the shell of the turtle had some traditional significance he was not comfortable with.

Anyway, that experience of losing the Turtle only made me more interested in aquatic life.

2 decades later, I’ve created my own brand of Natural Self-Cleaning Aquariums™ that I build for use as learning aids (e.g. to explain concepts like the Nitrogen Cycle, Balanced Ecosystem) in schools and other places.

And between 2000 and 2004, I spent many long hours visiting all sorts of water bodies and aquarium shops, as well as fish farms, collecting, breeding, and rearing – different kinds of beautiful, but hardy, ornamental fish species e.g. Platy, Gourami etc.

In the home I intend to setup for my family in Cotonou, we’re going to have a special aquatic garden (with lighted glass aquarium displays at night) next to the home based Brew Pub we’ll be running. It’s a concept I already tested extensively at our family house in Lagos between 2002 and 2005. So I know it works.

Read: Working As A Farm Hand Enabled Me Create My Self-Cleaning Aquariums

This article is based on excerpts from my first Best Practice Parenting Book published in 2014 for sale in print and ebook format via lulu.com/spotlight/sdaproducts – click to view the book.

Kukuru Danger™ - 5 True Stories About the Adventures - and Misadventures! - of a School Age Child Trying to Find Purpose in Life

 

PII 050: You Cannot Achieve Your Goals All Alone (Hint: How to Get Others to Gladly Support You to Succeed)

2 weeks ago, in issue “PII 048” of this Performance Improvement Ideas (PII) newsletter, I explained why “You Need to Habitually Study Successful People”, if you wish “To Make Success a Habit.

In that piece I also explained why you need to analyze your failures (and they will be MANY) also in order to learn how to succeed better.

Now in this issue, I explain why you need to share from doing the above with others around you. Not just those close to you, but any persons you have cause to interact with, in the process of trying to succeed.

The reason you have to do that is this:

SCROLL DOWN TO READ FULL ISSUE

Tayo Solagbade's Performance Improvement IDEAS(PI Squared) Newsletter

Tayo Solagbade’s
Performance Improvement
IDEAS
(PI Squared) Newsletter

Monday 23rd January 2017

Logo - Tayo Solagbade's Self-Development Academy


NB: 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.
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.

************

View Tayo Solagbade's video tutorials and demonstrations on Facebook Productivity Tips, Web Marketing, and for his Custom MS Excel-VB driven software applicationsJoin the SD Nuggets community on Facebook.comConnect with Tayo on Twitter.comConnect with Tayo on Google PlusConnect with Tayo on LinkedIn.com

PII 050: You Cannot Achieve Your Goals All Alone (Hint: How to Get Others to Gladly Support You to Succeed)

2 weeks ago, in issue “PII 048” of this Performance Improvement Ideas (PII) newsletter, I explained why “You Need to Habitually Study Successful People”, if you wish “To Make Success a Habit.

In that piece I also explained why you need to analyze your failures (and they will be MANY) also in order to learn how to succeed better.

Now in this issue, I explain why you need to share from doing the above with others around you. Not just those close to you, but any persons you have cause to interact with, in the process of trying to succeed.

img-20160509-00504

The reason you have to do that is this:

It is very unlikely that you will be able to achieve your goals all alone!

In other words there are very few people who are able to achieve authentic success, without needing help from others.

As the saying goes, no man is an island.

The truth, as has been my experience and that of others who stories I’ve read, is that you will find it necessary at some point in time, as you try to achieve your goal, to pass some of the lessons you learn to others you come across, and identify to be in NEED of such information, education and/or insights.

Note that you would do this NOT because you feel superior to them, or you want to prove a point.

Instead you would do so because – apart from boosting their ability to succeed in achieving their own goals – it would be in your long term interest, to get them to understand where you are coming from.

If people do not see what you see, and gain the insights that you have about why you need to operate the way you do to achieve your success:

  1. They may not know what to do, and how to do it, when you encounter challenges and need them to support you like you may have done for them.
  2. They may not be able to adequately prepare themselves to support you if/when the need to do so arises.

In other words, if you share with them the insights you’ve gained from studying the lives of other successful people, you would be inadvertently informing and educating them about why they need to think and act the way those successful people DID (like YOU are doing) if they wish to boost their changes of achieving the successes they desire.

However, not everybody wants to, or finds it easy to get out of his/her comfort zone to do something few people have (or no one has) done before.

Some people are comfortable being where they are!

They don’t like stress or uncertainty – and they certainly do not like taking risks….all of which those of us who are entrepreneurs thrive on!

If you are an entrepreneur, or you have the mindset of one, then I’m sure you know what I mean.

We never see setbacks as bad things – but those who lack our mindset do, and that’s why quite often when they learn of things going wrong for us, they imagine the worst and wonder why we insist on forging ahead :-)

Luckily, most of us have enough wisdom backed by resilience to NOT let their negative mindsets discourage us from staying true to our cause till we succeed.

The above is why entrepreneurs generally tend to be in the minority within most populations. The larger majority love to be salaried employees, avoiding the insecurities of having to stand on their own to find ways to earn income.

People with entrepreneurial traits are rarely in the majority in society.

That’s just the way it is. That’s because it’s not easy and generally not fun – at least not in those initial stages of building from the ground up as a startup.

Those are often VERY challenging, potentially traumatizing periods in the life of most entrepreneurs. I have been through it, so I know.

For those of us who are entrepreneurial by nature, we actually get a thrill from doing it all, no matter how hard it gets or how long it takes.

But those who are NOT, when they decide to become entrepreneurs, find it to be an unpleasant experience – especially when things are not going well for them.

So it’s not everyone that will want to be an entrepreneur.

Therefore you need to understand that in functioning as one, you will periodically find yourself having to relate with others who LACK that mindset you have, but who you may have to approach for help or support to keep going!

Do you see what I’m getting at here?

These would be people who would NEVER on their own choose the path you have adopted as an entrepreneur, but they would be in your network and in a position, at some point to give you what you need to recover from setbacks or progress to the next stage of your entrepreneurial evolution.

For instance they may be those you have to ask to lend you money, load you their cars, or other resources you need, give you a reference, or recommend you to others. Sometimes you may have to live – or share office space – with them etc.

So these people you may find yourself needing to relate with and/or request help or support from may not necessarily share your entrepreneurial mindset e.g. they may think a lot of what you’re doing or trying to do is crazy – and that would make it difficult to convince them that helping you is a good idea…especially when it has to do with THEM giving YOU their money to use for that purpose!

That’s why you need to find a way to share your insights with them in a manner that enables them UNDERSTAND what makes you tick.

If you refuse to develop that ability, you’re going to have to work a LOT on your own, with little or no support from others who have the means to give it.

So for you to interface with others who do NOT do what you do, and make them feel like lending you a hand, you will have to learn to communicate what you see (your vision) and fee (your passion).

And so you need to be able to able to communicate what you see (your vision), and communicate what you feel (your passion), in a manner that attracts other people and makes them feel like buying into your vision and supporting you to achieve it.

Now the minute you learn how to do that, you’ll find that sometimes 50% of the work you need to do is taken away.

This is because they’ll likely become your most fervent advocates, sometimes going out of their way to do things for you and/or ask you how they can help.

As you make that happen in your life, you’ll find that succeeding becomes a much easier endeavor.

Next week I’m going to talk you about  the role that (deliberate) exposure to poverty can play in preparing people to achieve authentic success, not just in business, but in any area of life.

Excel-VB Driven Ration Formulator

Click to view larger screenshot

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 watch a screenshot demonstration of the Excel-VB Driven Poultry Farm Manager I built for a client farm business in Ekiti state, South West Nigeria.

Click here to contact me about purchasing this product.

SDN Blog™

New posts from last week*

Monday:

[Wednesday]:

[Thursday]:

Fear Can Be Very Costly!

[Friday]:

N/A

[Saturday]:

N/A

[Sunday]:

Protected: THE FARM CEO (Issue 71): Africa Enterprise Challenge Fund, AWARD LAUNCHES 2016 GAIA AGTECH INNOVATION CHALLENGE, 50 New Innovative Agriculture Business Ideas in 2017

2017]

Tayo K. Solagbade*

Self-Development/Performance Improvement Specialist

*Best Practice Farm Business Support Specialist & Founder of the MS Excel Heaven Visual Basic Automation Club and Competition

Mobile: +234-803-302-1263 (in Nigeria) or +229-66-122-136 (in Benin Republic)

http://www.tayosolagbade.com

Tayo K. Solagbade is a Location Independent Performance Improvement

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

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

Tayo is the author of the Self-Development (SD) Bible™ and the popular Livestock Feed Formulation Handbook. He is also the developer of its accompanying Excel-VB driven Ration Formulator™ and the Poultry Farm Manager™ software.

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

In May 2012 he was the Guest Speaker at the Centre for Entrepreneurship Development’s Annual Semester Entrepreneurial Lecture at Yaba College of Technology in Lagos.

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

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

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.

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.

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’s(NIM) Young Managers’ competition, a Certified Psychometric Test Administrator for Psytech UK, innovator of Spontaneous Coaching for Self-Development™ (SCfS-D™), and Founder of the Self-Development Academy (SDAc).

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

You can connect with him on Twitter @tksola.com and Facebook.

Visit Tayo Solagbade Dot Com, to download over over 10 performance improvement resources to boost your personal and work related productivity.

====
[IMPORTANT NOTE:====

On 4th May 2014, Tayo’s 9 year old domain (Spontaneousdevelopment dot com), which hosted his website, was taken over by Aplus.net.

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.

But updates are still ongoing to URLs bearing the old domain name in most of the over 1,000 web pages, and blog posts he’s published.

If you experience any difficulties finding a page or document, email Tayo at tksola dot com.

Click “Tayo, What Happened to SpontaneousDevelopmentDotCom ?” to read a detailed narrative about how the above event occurred :-))

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:

Succeed by Emerging from Adversity Like a Phoenix

(TayoSolagbade.com launches extra Hosting plan with FREE Web Marketing!)

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:

A Proven Strategy to Find Profitable Buyers Regardless of Your Domain Name
==================

View Tayo Solagbade's video tutorials and demonstrations on Facebook Productivity Tips, Web Marketing, and for his Custom MS Excel-VB driven software applicationsJoin the SD Nuggets community on Facebook.comConnect with Tayo on Twitter.comConnect with Tayo on Google PlusConnect with Tayo on LinkedIn.com

Home |About | Contact | SD Nuggets™ | Speaking/Web Marketing IDEAS | Web Marketing Systems | Freelance Writing | MS Excel® Heaven™ | Cost-Saving Farm Biz Ideas

Fear Can Be Very Costly!

This is a true story. Names, dates and locations have been changed.
—-

It was a quiet afternoon in March 1995.  She was visiting me as usual in the Training Centre, during break time.

Annogu looked at me and said “Tayo, I hope you’re not going to get so busy as you often do, and forget to come around on my birthday. Remember it’s on Saturday – 2 days from today?

I looked up from typing on the computer, and smiled saying “Come on, don’t worry. I promise I’ll come and see you.” She said “Well you’d better. Or I’ll never forgive you!

We both laughed. As I looked at her, I could not help thinking how far we’d come, less than three months after we first got together. She was now in her fifth month as an Industrial Trainee (IT) from a university in the east.

On hindsight, my initial misgivings about getting close to females (due to a nasty peeping tom accusation back in primary school), now seemed baseless. We clearly enjoyed each other’s company. And I looked forward to spending more time with her on Saturday.

As her birthday approached, I asked some of my more “girl savvy” colleagues for tips on what gift to buy for her. They mocked me for being so nerdy that at 25, I knew nothing about dating. I endured their jibes, and after reflecting on their suggestions, settled for a big box of chocolates, and a beautifully worded birthday card from the popular Asterix Super Stores.

At about 12 noon on saturday, I dressed up, and with the neatly wrapped gift in hand, read out the address she’d written on a slip of paper, to a taxi driver. He knew the place, and after agreeing the fare, we set off.

I was not to know I was in for a (scary) surprise.

About 20 minutes later, the taxi pulled over, and the driver said “Oga, na here O.”(I.e. “Boss, this is the place”). I paid him and got out, then looked round. For some strange reason, I felt like I’d been there before. But I shrugged it off, and taking my bearing from house 21, made my way up to number 35, written on the slip.

As I got closer, I felt a knot tightening in my chest, as the realization dawned on me.

“It can‘t be!” I told myself.

I looked again at her handwritten directions on the slip she had given me. Yes, I was on the right street, and at the right house.

But not only had I been in the house before, I had also met the owner. Only it had been at night, and for a completely different purpose. I felt like disappearing with the gift in my hand.

“How could this happen?” I asked myself. I wondered if she had known, and chosen not to mention it, but dropped the thought just as quickly.

She had told me she was staying with her uncle and aunt, having moved from her home state to take up the 6 month internship at the company. I just never thought to ask for her uncle’s name. “If I had, would I have still dated her?” I wondered. It was hard to say.

So, there I was…

Standing uncertainly outside the door. I no longer needed her to tell me her uncle’s name. I already knew it was Hama Elbon…my landlord!

I had been there 9 months earlier, to pay one year’s rent and sign a tenancy agreement for a 3 bedroom flat in his new block of four flats. This was so I could move out of the apartment I shared with my two graduate trainee colleagues.

There were 2 main reasons I was nervous about being back.

Firstly, on the night of my maiden visit, Mr. Elbon had expressed reservations about renting out to bachelors. According to him, most of them were “players”, who kept late nights and preyed on girls. Even though I was not like that, I was not sure he would jump up and down in joy, on seeing me pop up at his door to take his niece out :-)

The second reason was that Annogu had once told me her father (a high court judge in her home state at the time), would frown at her dating someone from a different tribe. So, I worried that her guardians might share a similar bias. And I was not keen to face any tribal discrimination drama – especially not one that could cause tension with my new landlord!

But then I told myself, “The worst that can happen is they’ll say they don’t want a mere trainee, who also happens to come from another tribe, dating their niece. I’m certainly not going to run away with my tail between my legs!”

So I summoned courage and knocked.

The door opened, and sure enough I found myself looking at my landlord’s wife.

I greeted her, and she replied pleasantly, adding “Oh aren’t you the new tenant at our house on Abopki highlands? How are you?” I replied half-smiling, that I was fine.

Before I could say more, she looked at the wrapped gift in my hand and smiled broadly saying “So, you’re the one Annogu is expecting. She never did tell me the person’s name. What an interesting co-incidence! Sit down while I let her know you’re here.”

“Is oga around?”, I asked casually. “No, he’s been away on a trip, but we expect him back today or tomorrow”, she replied, as she walked away.

At that point, my apprehension rapidly faded away. The uncle was away. And his wife betrayed no noticeable reservations. What a relief!

And so it was that far from being a disaster, my date with Annogu turned out great.

We spent an enjoyable day at the leisure park, having ice cream, a nice meal, and sharing lots of fun stories – including how I almost bolted back to my flat, when I found out she lived with my landlord (she had also been shocked to hear her aunt say she already knew me).

I got her back home before nightfall. The uncle was not back (“Thank God!” I thought to myself). So I said goodbye to both ladies, and left.

Fear (when not controlled) can be costly in life – and especially in marketing.

In marketing products or services, the fear of rejection, disappointment or even embarassment can hold you back. For instance, making cold calls in person or on phone can be a psychologically tasking exercise. But people who succeed in marketing, learn to dig in and do it – in spite of any doubts or fears they have.

Letting fear paralyze you can deny you the success you need. Just like I realized in deciding to knock on my landlord’s door, the worst that can happen is those you approach will say “no”.

Last time I checked, NO never killed anyone. What’s more, you’ll never know if they won’t say YES, unless you try – will you?

So, don’t let the fear of what can go wrong keep you from taking the steps to achieve your dream. Or one day you’ll look back with regret, wondering what might have been.

Twenty years from now, you will be more disappointed by the things you didn’t do than by the ones you did do. So throw off the bowlines. Sail away from the safe harbour. Catch the trade wind in your sails. Explore. Dream. Discover. – Mark Twain.

PS: This post was first published online via spontaneousdevelopment.com (now defunct) on Monday, September 17, 2012 8:00 AM

[Recommended] Marissa Mayer to Leave Yahoo Board; Yahoo to Change Name to Altaba

[Moves will come after $4.8 billion sale to Verizon]

Yahoo Chief Executive Marissa Mayer will step down from the board of directors after the core internet business is sold to Verizon, while what remains of the company will be renamed Altaba.

Yahoo Inc. said Monday it will whittle down its board after completing its deal with Verizon Communications Inc., and several longtime directors, including Chief Executive Marissa Mayer and co-founder David Filo, will step down as directors.

After the sale of its core internet business, the company will change its name to Altaba Inc. from RemainCo, Yahoo said in a regulatory filing. Altaba’s remaining assets include Yahoo’s stake in Alibaba Group Holding Ltd. and Yahoo Japan. The name is a combination of the words “alternate” and “Alibaba,” a person familiar with the matter said.

Continue reading…

http://www.wsj.com/articles/after-sale-marissa-mayer-to-leave-yahoo-board-yahoo-to-change-name-to-altaba-1484002787

Make MORE Money: Convert Your Custom Spreadsheets to Mobile Phone Apps [Hint: My New Spreadsheet to Mobile Phone App Conversion Service – See “Agricultural Field Inspection App” in test mode]

This is my first broadcast to members of my Excel Heaven Visual Basic Automation Club in 2017 – and it is a special Audio Podcast.

In it, I reveal the many insights I’ve gained from over 6 months of careful research into the potential opportunities to be harvested from venturing into development of mobile phone apps using custom spreadsheets.

My message: Regardless of your field of interest or specialization, you can LEARN to create mobile phone apps you can sell, based on custom spreadsheets you use in your work!

My interest in doing this was first aroused after a series of clients asked me if my Excel-VB Ration Formulator and the Poultry Farm Manager software had versions that could run on mobile platforms.

At that time I waved off such inquiries as being from overzealous users. But later on, after I encountered a feed formulation app built to work on Android devices, I realized that not only would it be wise to explore building my own app to work on mobile devices, but that I could create a whole new range of products, based on spreadsheet customization – and even help other professionals using proprietary spreadsheet models they’ve built.

At the end of the audio, I announce my new Spreadsheet to Mobile Phone App Conversion Service. 

Click here to request a copy of the audio podcast

NB:

0. If you’re a member of my Excel Heaven VB Automation Club, REPLY YES to the email in which you’re reading this message, and I’ll send you the audio file in your email inbox as an attachment.

1. If you’re NOT a member of my Excel Heaven VB Automation Club and you’re reading this online: Text “YES – XL Heaven Podcast 2017” with your name and email address to +234-803-302-1263

2. If you’re NOT a member of my Excel Heaven VB Automation Club, and you’re reading this in an email: simply click REPLY and type “YES – XL Heaven Podcast 2017”. Alternatively, send “YES – XL Heaven Podcast 2017” to tayo at tksola dot com

Below: Screenshot of an Example “Agricultural Field Inspection App” – in test mode

xl-mobile-app-agric-insp2

It’s a mobile app for agriculture field inspections.

How It Works:

The app comes with 2 links that allow you to to install it on (a)  your mobile device and/or (b) run it in your web browser.

1. Users will use it to collect images, notes, and GPS locations while working/inspecting locations in the field.

2. The app automatically records date, time, and GPS location when a new record is posted.

3. It also allows the user capture up to two images and type in accompanying notes for each record.

4. This nifty app will come in especially useful for field workers/researches when they need to document specific issues while in the field.

NB: Variants of this app will be created for other applications. For instance, Primary Health Care Database Facilities Inspection etc.