Category Archives: Excel-VB Solutions

How Studying a Great African Achiever is Leading Me to Self-Actualization

“Va vers les gens, vit avec eux. Apprend d’eux. Aime-les. Commence avec ce qu’ils connaissent. Planifie avec eux. Construit sur ce qu’ils ont. Enseigne en montrant. Apprend en pratiquant. Ne te conforme pas, mais transforme. Ne soulage pas mais libère. Et quand avec les meilleurs leaders, le travail est fait, la tâche accomplie, les gens diront nous l’avons fait nous-mêmes”. Lao Tsu, Fondateur de la philosophie Tao, 600 av J.C.

English Translation:

“Go to the people. Live with them. Learn from them. Love them. Start with what they know. Build with what they have. But with the best leaders, when the work is done, the task accomplished, the people will say ‘We have done this ourselves.” – Lao Tzu, founder of the Tao philosophy, 600 B.C

I discovered the above wise quote through reading a publication by a great African man here in Benin Republic, whose works have inspired me since I read about an award he received way back in 1987.

That was during my first undergraduate year as a student of Agricultural Extension Services in Nigeria’s University Of Ibadan.

I was 17 years old at the time. In another 2 months from today I will clock 46.

How time has flown – almost 30 years have passed – yet this man has continued to be a leading light and inspiration to many across the world, for his works.

I constantly drew inspiration from following his progress, and often visualised myself doing something similar in my chosen area of interest.

Over the past 10 years I’ve taken concrete steps closer to achieving my dream. And I resolved that I would find a way to meet and thank him for doing what he’s been doing.

Relocating to Benin Republic in 2013 made the possibility of that happening just a matter of time.

And now it has…

About 2 weeks ago I met and spoke with him for the first time ever. The next day I ran into him again and we had a short exchange.

In between those 2 meetings I had a good opportunity to observe him from a distance as he moved around and interacted with the people. It was obvious, to me, that there was deliberate purpose in his actipns and utterances.

Later that day I got handed a document published by his organization in which I read the quote reproduced above, and had my inner eyes opened to the secret of his success.

Click here to read the page on his organisation’s website, where the quote is reproduced.

Click below to view a page with the english version of the quote, along with several other quotes by the same Chinese philosopher.

This man does not know it, but he’s been mentoring me remotely as I followed his progress, over the past 2 and a half decades.

As soon as I read this quote, I instantly knew it was what I needed to adopt to achieve the new plans I’ve been working on.

Before now, I periodically sensed a need to do what it advised but resisted the impulse each time mainly because I was not sure how to proceed.

Luckily for me, this great man chose not to be miserly in sharing the sources of his own inspiration. As a result, the rest of us benefit.

How I wish there was a way I could add value to him the way he has done to me and many thousand others who continue to benefit from the enduring solutions provided by his organisation.

For now, one way I know I can thank him is by succeeding in using this quote’s wisdom to implement my own evolving plans to start a centre that help others with solutions I offer.

PS: By the way, in case you’ve not discovered it yet, from clicking the above mentioned link to his website, this man that I have spoken so highly of in this article, is Father Godfrey Nzamujo – the Founder of the world renowned Songhai Integrated Farming centre, headquarted here in Benin Republic’s Porto Novo. He makes me proud to be African!

Marriage is Not for Everyone [You Don’t Have to Get Married to Prove You’re Normal]

Yes.

 

It is my considered opinion, based on my personal observations over the past 25 years of my adult life (16 of them as a husband and father) that marriage is not for everyone.

 

You don’t have to get married to prove you’re normal. And when you’re a high performing achiever or “genius”, getting married successfully will require finding someone who often COMPLEMENTS you, making you better than you were – and who, in doing so will NEVER feel inadequate or threatened by the success that consequently accrues to YOU in the process!

 

Henry Ford and his wife; Andrew Carnegie and his wife (as mentioned in Napoleon Hill’s Think and Grow Rich) reportedly enjoyed that kind of blissful union.

 

As a result, when fame and fortune came into their lives, they kept their partnership going strong and did not lose focus on what mattered – which was the preservation of the true love, friendship and affection they began their journey with, no matter the conflicts or disagreements they had!

 

<h3>In Nigeria I consider Tunde and Wunmi Obe (TWO) to be an exemplary celebrity couple who undoubtedly will have LOTS of useful wisdom to pass on to couples – be they celebrities or everyday married people. </h3>

 

In Napoleon Hill’s Think and Grow Rich, he expounded (in a chapter dedicated to it) on the concept he called “Sex Transmutation”.

 

That phrase, despite the presence of the ever suggestive 3 letter word in it, has less to do with the act itself, and a lot more to do with the degree to which a couple can use their “sexuality” to connect “symbiotically” on a deep emotional and psychological level, that makes them flourish and excel, seemingly at virtually anything they do.

 

Check out Tunde and Wunmi’s many hit songs, videos – as well as photos of they share of their kids/family. Check out the way they “roll” in public and how they “flow” in private (even while still in public view).

 

Then go back and pay close(r) attention to the often very instructive messages in the lyrics of most of their songs, and you will begin to understand what I mean: those two (pun intended) are in sychrony with one another: the closest thing one will ever see to a perfect marital union – especially for a celebrity couple.

 

<h3>It takes two (pardon the pun…again) to make marriage work that way. </h3>

 

Everyone – man or woman, husband or wife – can and will make mistakes. What counts is not how loudly you prove you can scream when you feel genuinely aggrieved.

 

What really matters is how far you are willing to go to protect what you have, by trying your best to repair any damage that may be done by the other party, using the “connection” you share.

 

You would do the above within reason of course (however subjective that may be). You don’t, for instance, want to make yourself a willing accomplice in unrepentant visitation of abuse (physical, emotional or psychological) on your person. This is after all the 21st century.

 

<B>Not everyone is willing to adopt this kind of attitude however, and many believe they must prove they are right, and the other person wrong, before they can let things be. </b>

 

How very wrong!

 

<h3>The worst part of it all is the misguided belief majority seem to have that there is some kind of wisdom inherent in the act of putting your private affairs up for consideration in the “court of public opinion” e.g newspapers, TV, social media etc. </h3>

 

In most cases that simply ends up messing the relationship up the more.

 

The sad part is however that they forget their loved ones (parents, siblings, unclues/aunts/cousins, friends, associates, clients, business partners and more!) will also suffer major pain and embarrassment as a result of that singular move into the public space.

 

Quite often those people would have attended the couple’s engagement and wedding events, playing influential, often visible roles – with pride!

 

Most would have received the wedding videos and excitedly played it for guests to watch and admire the couple.

 

When it all falls apart, they will want to avoid being mentioned in relation to the former love birds!

 

The simple scenario I’ve painted above proves that the collateral damage that can result from going “public” with your marriage/private issues, can be far reaching, hard to quantify or contain, and often impossible to repair!

 

<h3>Case Study: There is story of a celebrity couple’s marriage collapse currently trending in the news…</h3>

 

As far as I’m concered BOTH of them are the losers. Neither is better off – especially with the court of public opinion session they have now started.

 

They may not admit it, but the pain and embarassment is there and it will continue eating at them for a long time to come. No one will ever look at them the same way again.

 

Could they – as well as their respective fans – have been better off if they had never gotten married?

 

On the benefit of hindsight…the answer seems to be an obvious YES.

 

That’s what doing what society expects of you can sometimes do to you e.g bite you in the you-know-where.

 

But nothing is impossible – so I hope they can find a way to make up, especially for the sake of the little child between them.

 

<h3>This is why I believe – and I’ve been hammering it into the heads of all my kids – that Marriage is not for everyone.</h3>

 

You don’t have to get married to prove you’re normal.

 

Alternatives exist and we have examples in history and many today to refer to.

 

If you’re keen to do, get all the help you can to choose the right partner, then be prepared to fight to keep your marriage: YES, be ready to fight!

 

Some smart thinking women with great visions and ambitions choose to stay single, but arrange to have a child or two via what today are available as “professional services”.

 

Many end up proving to be great parents, and raising well rounded and successful kids.

 

I won’t bore you by giving specific examples. I know you can think up a few, all by yourself :-)

 

Single parent Moms and Dads can be found all over the planet.

 

Some chose the life, while others were forced into it via being abandonned by a partner or through the loss (via death) of the partner.

 

But they went on/are going on to make the most of it. So, it’s not impossible.

It may not be normal, but the risks of emotional trauma, pain and suffering are greatly minimised.

 

<h3>Not everyone can endure the B.S that staying married sometimes requires both parties to swallow from another at various times.</h3>

 

Such persons must therefore get real and consider that the marriage option is simply NOT for them: No be by force O!

 

In other words my message is this:

 

<blockquote>Unless you are damn sure you can deal with things not working out with the person you’re currently crazy and raving about, DO NOT get married to him/her!</blockquote>

 

Period.

PII 012: Succeed by Solving Problems Using MS Excel Visual Basic [How I Started Spreadsheet Programming in Guinness Nigeria Using Lotus 1-2-3 Macros in 1995, Before Discovering Microsoft’s Excel Visual Basic in 1999]

Today I enjoy patronage from buyers within and outside Africa, for my customizable Excel Visual Basic software. But the journey to this point began for me 2 decades ago when I worked as a young graduate trainee brewer in Guinness!

Back then Lotus 1-2-3’s was the industry spreadsheet application standard worldwide and it had a keystroke based macro programming language. 

Guinness had the Lotus SmartSuite installed on all its computers.

By the year 2000 however, the company rolled out MS Office installations across all its sites and relevant personnel received training to begin using it.

SCROLL DOWN TO READ FULL ISSUE

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

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

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 012: Succeed by Solving Problems Using MS Excel Visual Basic [How I Started Spreadsheet Programming in Guinness Nigeria Using Lotus 1-2-3 Macros in 1995, Before Discovering Microsoft’s Excel Visual Basic in 1999]

Today I enjoy patronage from buyers within and outside Africa, for my customizable Excel Visual Basic software. But the journey to this point began for me 2 decades ago when I worked as a young graduate trainee brewer in Guinness!

Back then Lotus 1-2-3’s was the industry spreadsheet application standard worldwide and it had a keystroke based macro programming language.

Guinness had the Lotus SmartSuite installed on all its computers.

By the year 2000 however, the company rolled out MS Office installations across all its sites and relevant personnel received training to begin using it.

NB: At the end of this piece, I’ve included a Wikipedia link to read the history of how MS Excel Visual Basic came to life 23 years ago, and how it has evolved since then.

Having always been very adaptable to changing circumstances, I wasted no time in learning to use the new application.

I did that using the Reed Jacobson authored “MS Excel ’97 Visual Basic Step by Step” manual given out to attendees of an 2 day on-site Introduction to MS Excel course facilitated by a representative from a Microsoft partner organisation – Bitrax International.

There were about 15 of us, but I was the only one with any interest in or knowledge of spreadsheet automation. Indeed when the copies of the manual were being shared out, the facilitator actually called out asking:

“Which one of you is Tayo Solagbade?”

When I raised my hand, a bit surprised by the fact that I’d been singled out, he said (holding up a copy of the book):

“I’m told by the managers in the Head Office’s IT department that you are the only one likely to understand what is in this manual.”

It was a great complement, but at the same time a challenge for me to take my game to the next level.

I immediately realized I needed to quickly learn to use Excel VB to control Excel, as proficiently as I used Lotus macros to automate spreadsheet reports.

Indeed the IT department had had to help out in the rollover to MS Office, when users of 4 apps I’d developed to automate daily, weekly and monthly data recording and report generation in Lotus 1-2-3, repeatedly requested for the apps to be converted to versions that would run in MS Excel, if they were to agree to move to the new platform.

Their reason was simple: the apps had saved them hundreds of hours normally spent doing most of their work manually. Not only were they getting work done faster, there was much less occurrence of reporting errors.

Since the company’s IT department had no in-house expertise in spreadsheet automation, my apps had to be sent to the UK office where a developer with skills in use of both spreadsheet development platforms did a great job of converting my apps to versions that worked satisfactorily in MS Excel.

After I got hold of the manual by Reed Jacobson, I dug in and quickly began using the new coding language.

Before I left the company to start my own business (offering custom spreadsheet automation solutions), I built an Excel VB driven Training Records Database that was deployed across the brewery’s intranet for use by departmental heads.

This was a solution I developed as a last resort under 2 weeks in the final stage of ISO 9000 audits being conducted by officers of the Standards Organisation of Nigeria (SON).

They had requested that every department head show proof of access to “easily retrievable” training records of all members of their respective departments.

I was Training and Technical Development Manager at the time, having been promoted from Shift Brewer less than a year earlier.

Unfortunately we were still waiting for the IT department to get back to us with an app fitting the specifications we’d sent to them. At that point, it became obvious that it was up to the Training department to provide an alternative solution, if only temporarily.

Up until that time, I’d only been practising my new found skills in Excel VB coding privately.

This training database challenge made me get serious about developing an app for users again – and this time around they were to be busy senior managers across the brewery.

Long story short, I got it done – with round-the-clock (weekends included) training records data entry help from my training instructors and engineering trainees (which I facilitated by providing refreshments using my personal funds).

Only when it became apparent that the app worked, did I inform the brewery head (Andy Jones) that we had developed an alternative solution, which I then demonstrated for him to see ob his PC.

The rest as they say is history.

With Andy’s consent, I went round to show each department head how to launch the app from the brewery’s intranet, using shortcuts I placed on their respective desktops.

By the time the audiors went round again, the brewery passed with Zero Non Conformities on that front!

Just to add some perspective for you, it was in 1995 that I first began developing custom spreadsheet software using my self-taught skills.

As I’ve noted in several articles over the years, I discovered spreadsheet automation via Macro Programming while reporting, as a Graduate Trainee brewer to Richard Chambers, a young Scottish manager who worked as an expatriate Training Coordinator in Guinness Nigeria’s Ikeja brewery.

We never sat down one day for a training session on spreadsheet programming. Instead, what happened was that I took an interest in sitting and watching him develop reporting applications for use by senior management personnel in the head office and in the breweries.
After some time he noticed my persisting interest and began giving me his laptop to check the integrity of the many mega (nested) formulas he used in the apps.

In order to do what he asked successfully, I had to study and fully understand how to manually calculate all the different usage rates and Key Performance Indicator ratios used in the reports.

It was his way of giving me more of the training he knew would help me succeed in the Technical Function.

Doing those tasks excited me as I discovered that I was mastering stuff that would enable me reason at the level of, and rub minds with the top minds in the company’s technical function.

My curiousity made me begin studying Richard’s macro programming code and as I got more familiar with them and what they did, I began copying out and making my own modifications in a test workbook.

Over time my confidence and competence grew to the point that Richard noticed I could correctly write or modify code in his app, to remove bugs identified.

That assignment introduced me to Manufacturing Usage Rates as well as Variable Costs Reduction Analysis.

In 1995, I got redeployed to Guinness’ Benin Brewery. One day his counterpart there (Joe Sheehy) called him in Lagos about a problem in the app used for generating brewery month end reports for the Technical Review Meeting.

Richard told him I could help solve the problem. So Joe sent for me, and I did solve the problem. From that day onwards, the training department became my “home” – and news about me and what I could do began to spread.

Today, I’ve used those insights from my time in Guinness to develop custom apps for clients in various industries, with the most popular of them being sold to buyers within and outside Africa – such as my Excel VB Ration Formulator and my Poultry Farm Manager.

My story proves that anyone who is willing to do the hard work required, with undiluted persistence, and who has a passionate desire to solve data handling and report generation problems in any field, will succeed in doing so using MS Excel-VB programming.

If you can read and write, you can learn to code proficiently in any language – MS Excel Visual Basic for Applications being no exception.

I offer learning solutions you can adopt via my Excel VB club and workshop events, as well as my private coaching – all available online in experiential format.

Click here to request details of how to get started with me.

Below is the promised Wikipedia link you can click to read the history of how MS Excel Visual Basic came to life 23 years ago, and how it has evolved since then.

Visual Basic for Applications – Wikipedia, the free encyclopedia

Click here .

SDN Blog

New posts from last week*

Monday:

 

[Tuesday]:

[Wednesday]:

[Thursday]:

N/A

[Friday]:

Protected: Use This VBA Code Snippet to Make MS Excel Remind You to Save Your Work at Regular Intervals, to Avoid Data Loss!

[Saturday]:

How the Excel-VB Driven Poultry Farm Manager is Used (True Stories)

 

 

[Sunday]:

Protected: THE FARM CEO (Issue 45 – International Business Opportunity): Agro-processing Companies in Benin Republic Seek Buyers/Distributors in Nigeria and Other English/French Speaking Countries for their Organic Health Boosting Agro-based Food/Drink Products

 

Tayo K. Solagbade*

Self-Development/Performance Improvement Specialist

*Creator of the Mastering Adversity for Perpetual Success Achievement Coaching Program

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

 

THE FARM CEO (Issue 45 – International Business Opportunity): Agro-processing Companies in Benin Republic Seek Buyers/Distributors in Nigeria and Other English/French Speaking Countries for their Organic Health Boosting Agro-based Food/Drink Products

This week just ended, I met the marketing representatives team leader for a company here that produces nicely made and packaged Pineapple juice.

When I told him how I get buyers without going out or paying for advertisement, he invited me to meet the Head of Marketing – a lady.

By the end of that meeting she told to prepare a presentation she could present to MD. I’ve been working on that, but writing acceptable French is not as easy as speaking it.

So we contacted a translator who asked for FCFA 25k (divide by 2 to get Naira equivalent), and said he could only work over the weekend. I agreed tentatively.

We then went on attended day 3 of a trade fair today and I met for the first time some very entrepreneurial Beninese citizens who produce natural health boosting products from various agricultural raw materials, in attractive packaging.

But they just don’t know how to find buyers.

By the time I spoke with some about how I cut the time, effort and money I expend to sell my custom apps and books, which are mostly digital, for up to N80k, they were asking me what they had to do to get my web marketing support service.

I’ve told them my fee is FCFA 500.000.0 – including training of their staff.

But I added that I currently would prefer part payment in form of a bedroom apartment I can live in with my family for 1 year or more at no expense to me. (This is designed to appeal to companies that have accommodation facilities they pay little or nothig to use).

If they give me that, I will cut off FCFA 300,000.0 so they only pay me FCFA 200k. And if they pay for my monthly Blackberry subscription here, (which is FCFA 10k per month) for 1 year, I will cut off the FCFA 120k and take the rest FCFA 80k in cash.

The idea is to eliminate those 2 cash flow expenses from my budget, by getting a client to pay for them. Since I will get other clients I will not feel it and I will have peace of mind!

Entry into Nigerian market: They want distributors and consumers.

Some of these companies have health boosting agro-based products I believe will really do well in Nigeria. Not surprisingly, they are keen to connect with buyers/distributors in Nigeria.

Upon discovering that I can communicate proficiently in French, and that I also offer Web Marketing, combined with my knowledge of Nigeria and how to sell in it, they’ve shown serious interest in paying for my service.

We’re looking at a form of partnership.

It occurred to me that you, as members of my club, or persons you know, may be interested in their products.

The above described development made decide that it’s better to do a group event so I can win miultiple clients from among them.

I plan to organize a FREE web marketing talk for sales and marketing personnel of the companies.

That way I’ll just explain with my mind map to many potential clients at once.

For the first time since coming to this country I’ve identified and connected with people truly hungry for a solution I offer like Web Marketing.

The icing on the cake is that have good quality health boosting organic products that vcome well packaged, which they are eager to introduce to the Nigerian market.

My unique combination of skills, and knowledge equips me to help them achieve their goals in a cost-effective mannet.

If you’re interested in receiving photos of some of their products along with contact details etc, let me know.

How the Excel-VB Driven Poultry Farm Manager is Used (True Stories)

In this article, I share some examples of how my Farm CEO clients use my increasingly popular <a href=”http://tinyurl.com/15pfmVideos” target=”blank”> Excel-VB driven Poultry Farm Manager software</a> I sold them, with my guidance. I do this here to provide potentially useful insights for prospective buyers who may be concerned about how well it meets their unique needs.

 

In a separate post to follow this one, I will feature excerpts from an email conversation I had with a Farm CEO who is now a client, several hours before he purchased this same app from me.

 

He’d written in to ask 2 questions about data integrity protection which I replied required extending the app for a standard development fee. He’s since bought the app on the understanding that he’ll order for the extension when he’s ready via an arrangement in which I hope to get other Farm CEO users to share the fee payment, at a pocket friendly rate.

 

Having said the above, it so happens that there are ways in which the app is already being used by existing clients to get around some of its seeming limitations – which I’ll be telling him about.

 

You see, I did not build this app for use in the manner being requested by some clients (e.g across an intranet), because I felt most of those who would need it would want use it alone, or with a few trusted persons they shared a PC with.

 

<H3>As a result, here’s what my clients do, based on my thinking in developing the app:</H3>

 

1. The Farm CEO/owner or someone s/he trusts to use it right gets assigned the username and password to exclusively post data into it.

 

2. S/he is advised to use the app on a computer preferably not shared with 3rd parties.

 

3. Typically s/he prints and makes photocopies of the daily record form (that comes with the app) weekly, for issue to the supervisor or manager, who shares them out to farm operatives.

 

4. I recommend that the client try to post entries daily using data hand filled into the paper record forms. However, the logistics of getting the filled paper forms back from the farm can sometimes make it hard to do. So that makes them post what may be several days backlog or at weekends – which is still okay.

 

5. The various Key Performance Indicators (KPIs) auto-computed by the app and presented in dynamic report summary tables and trending charts, are meant primarily for exclusive use of the business owner/decision maker.

 

Once s/he completes posting of the data, s/he then sits back and carefully reviews the autogenerated reports, to establish/follow trends, with a view to identifying areas that need intervention – or opportunties to replicate pockets of success etc.

 

<H3>By way of interest, I always recommend that the CEOs get their manager/supervisor to snap clear photos of (or scan) the filled and signed Daily Records Form, and send (e.g via email or Whatsapp) to the CEO at the end of each day, making it unnecessary for him/her to come down daily, or to wait till weekend to pick them up in bulk.</H3>

 

I do not know if any do this, but they tell me interesting stories about how they use the app to identify areas not doing well and then use that to challenge and guide the farm manager/supervisor to establish the root cause and take corrective action.

 

<b>A few days ago, one CEO told me how his Farm Manager later asked him how he (the CEO) had been able to discover a cage line of birds were getting higher than the farm’s average feeding rate, but returning the lowest Hen Day Percentage in the flock!</b>

 

He said he replied by making a rhetorical statement saying “What do you think I’ve been doing with the software I post data and records I get from you!

 

The above scenario provides an example that justifies the thinking I adopted in building this app.

 

Simply put, it was built for use by a decision maker or owner with the motivation to use it with integrity.

 

It so happens that the Web Marketing System I use to attract clients or buyers is designed to repel most people lacking the above qualities. As a result I continue to have a growing number of serious minded and results focused Farm CEO purchasing this app and making diligent use of it.

 

You can join them today, and become a member of my Cost-Saving Farm Business Ideas Club, which earns you access to a lifetime 40% discount on all other products and services I offer (terms apply).

 

 

<a href=”http://tayosolagbade.com/pfmgr.html” target=”blank”> Click here to send me a message</a>

Learn to Please Your Clients Without losing Productivity or Profits

As Burt Dubin one wrote, youu are a marketer first and an expert second. It does not matter what field you specialize in – this truth always applies. I have profited greatly by acting based on this truth in my business, and I always recommend it to my clients and others I coach.

The main reason is that it keeps you focused on ensuring you stay profitable while working to meet your client’s needs.

Below is an example from a real life case study based on work I do serving Farm CEO users and prospective buyers of my Excel-VB driven Poultry Farm Manager software.

The prospect had emailed me following our phone conversation that took place when he called me, in response to detailed notes I sent to him. Note that I also made him a promotional offer of some bonus gift products if he paid before a deadline of about 36 hours from the time the offer was made:

From: xyzfarms
Date: Wed, 27 Apr 2016 19:34:08 +0100
To: Tayo K. Solagbade
Subject: Re: 10 Cost-Saving Farm Business Ideas Articles – and a Video – You May Find Useful
Hello Tayo
Thanks for the series of articles you’ve issued providing an insight into the importance of record keeping and cost savings.
I also acknowledge receipt of your offer for the purchase of the software. However, I have 3 questions before reaching a final decision on the software purchase.
Firstly, can the software be remotely view from anywhere in the world. In the event of travelling outside the country and being able to monitor activities / performance on site?
Secondly, can 2 users be on the system at the same time. That is the farm manager carrying out the input whilst I await for the output at the other end, at a different location? Or do I need to log out and log back in after he is done with the input.
Thirdly, would you be providing basic record keeping forms that farm staff will need to complete on a daily basis before the actual input is made on the system by the farm manager?
I strongly hope you can respond within a resonable time frame in order to avoid me breaching the offer time frame period.
Thanks in antipicipation of a prompt response.

Here’s the response I sent to him

Thanks for your message,

My responses to your questions begin with “>”:

1. Firstly, can the software be remotely view from anywhere in the world. In the event of travelling outside the country and being able to monitor activities / performance on site?

> No it cannot. However I can add such functionality in a manner that enables cost-effective use in that manner if you wish. For instance I can make it generate a special web page report or PDF that will be automatically emailed to you.

Several other options exist. I will tell you what they are, with pros and cons, then recommend a way forward based on the uniques needs I identify you have from asking you questions.

2. Secondly, can 2 users be on the system at the same time. That is the farm manager carrying out the input whilst I await for the output at the other end, at a different location? Or do I need to log out and log back in after he is done with the input.

> This app can be used across an intranet via 2 or more terminals. However only 1 person will be able to save changes made, and that’s the person who opens it first on the network. However all other persons will be able to view the entries and generate any reports they want from any other terminals.

Having said that, I did not build this app for use in that manner. If this kind of usage is important to you, a different architecture is likely to be needed to make it happen – like that used in the network based Hotel Records Management System I built for a Lagos based hotel that used it for 6 years.

Again adding this functionality requires a development expense. I have ideas of cost-effective ways to get it done. To make it easier for you, I offer to peak to other Farm CEOs using the app to find out if they would like to share the cost of adding that functionality with you – along with that mentioned in 1 above.

3. Thirdly, would you be providing basic record keeping forms that farm staff will need to complete on a daily basis before the actual input is made on the system by the farm manager?

> The app actually comes with an interface containing a customizable farm operations daily records form that you will print out and make photocopies of for each day of the month. The PDF userguide that I will send along with the software contains details, but it’s quite straightforward. Rest assured I will be available to support you anytime.

Important Notes

You first have to buy the app.

The good thing is that once you buy the app you become a member of my Farm Business Ideas Club and that entitles you to a lifetime discount of 40% on all my other products and services.

Adding the functionalities mentioned in 1 and 2 above will however require additional investment on your part. Development fee starts from N100k depending on nature and scope of work to be done.

Another thing I can do is to speak to other Farm CEOs using the app to find out if they would like to share the cost of adding those functionalities with you.

Hope this helps,

Tayo

Summary

This conversation is yet to be concluded. However I have shared these excerpts here to illustrate how I respond to requests that fall outside the scope of the solution I offer. It’s important to always put the client’s needs first. However it is not wise to do so at the expense of your productivity or profitability. The foregoing informed the offers I made to him above. I hope you find this of some use.

No Country Can Really Develop Unless its Citizens are Educated: But What Kind of “Education” is Needed?

“No country can really develop unless its citizens are educated.” – Nelson Mandela

I believe it’s safe to say we all agree that the above quote is accurate.

What I’m not so sure about is how well we all agree on the shape and form this so called “education” should take, to equip those exposed to it, to emerge with real world relevant competence to “develop” their respective countries.

This is why some societies push millions of people through their “educational systems”, who on completing their programs arrive larger society unprepared to deal with realities of fending for themselves, talk less of influencing change to develop society.

The above scenario is a common one, that strongly indicates that societies need to constantly review and evolve their educational systems to give learners the knowledge, skills and attitudes to function as competent members of society.

These persons would not only have the ability to flourish financially and otherwise, but also understand how to work with others to influence positive social change and progress in their society.

When that kind of educational system is in place in any society, the wisdom contained in Mandela’s above mentioned quote will become “harvestable” there.

Take a close look at countries we call developed or advanced today, and you’ll realize most strive continually to reinvent their “educational” systems to equip their learners to deal effectively with the evolving realities of larger society.

In contrast, less developed societies tend to be guilty of doing the exact opposite.

For instance there are countries where parents, education providers and policy makers mindlessly continue to place illogical preference on having youths attend universities to earn degrees, despite ample evidence that many of those instutions in their country offer mostly theoretical learning with little or no practical or real world exposure provided to the learners.

As a result, they continue to blindly operate outdated educational systems, churning out millions of “products” ill equipped to be useful to themselves or the society.

The developed societies on the other hand have various aspects of their system tailored to meet the unique needs and talents of learners, as well as the society.

As a result, learners get useful guidance to choose the best career path to follow, which sometimes would not require a tour of university academics.

For instance some learners demonstrate traits that qualify them to attend Vocational Skills Development programs or technical colleges, emerging with market ready income earning skills that make them unlikely to become a burden on those who support them after comnpleting their “education”.

The same cannot be said for persons who undergo mostly theoretical education.

PII 011: You Need to Coach Your Child to be Resourceful in Life [Watch video of 12 Year Old Building Battery Powered Toy Power Bike from Scratch]

Few weeks ago, I shared a video on my YouTube channel, of a battery-powered toy power bike built by my 12 year old son, using scrap materials he picked up from various places.

Since then I have shown the video to many people in Nigeria and here in Benin Republic, eliciting the same comments of admiration from them.

What most people who have seen the video on the web do NOT know is that I got him to record a 4 part demonstration video of himself building another such toy bike from beginning to the end.

His 14 year old brother helped to hold the Blackberry camera, while playing background music, as he worked.

I share photos and clips from the videos (with details of how to get them and also attend a FREE workshop facilitated by my son) in this article.

SCROLL DOWN TO READ FULL ISSUE

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

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

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 011: You Need to Coach Your Child to be Resourceful in Life [Watch video of 12 Year Old Building Battery Powered Toy Power  Bike from Scratch]

Few weeks ago, I shared a video on my YouTube channel, of a battery-powered toy power bike built by my 12 year old son, using scrap materials he picked up from various places.

Since then I have shown the video to many people in Nigeria and here in Benin Republic, eliciting the same comments of admiration from them.

What most people who have seen the video on the web do NOT know is that I got him to record a 4 part demonstration video of himself building another such toy bike from beginning to the end.

His 14 year old brother helped to hold the Blackberry camera, while playing background music, as he worked.

I share photos and  clips from the videos (with details of how to get them and also attend a FREE workshop facilitated by my son) in this article.

I told him to record the video of himself making the bike for 2 main reasons:

  1. I wanted him to have video proof to show that he actually made the first bike, and that he knew how to do it so well that he could make another just as functional, if asked, anytime. Not only did this young man deliver a /similarly functional mobile bike, this new one even ran better (without falling over) than the first one – he corrected the problem causing the instability.
  1. I could see a money making opportunity on several levels such as:
  • Putting nice finishing touches to the bike and selling it to kids, with a guarantee of FREE repairs for every buyer, to encourage more sales.
  • Offering FREE training facilitated by him, to other kids interested in learning how to make the bike themselves. These kids would be asked to buy at least one toy bike and the 4 part demonstration video of him making the bike, in order to attend the training.

NB: My determination to help him launch his toy product for sale grew stronger a few days later, when I saw a Made in China toy car with immovable wheels on sale for N200.0 in a shop.

Getting home, I promptly told Chika and his siblings that I would find a way to help him refine, brand and sell his battery powered bike to parents of kids like his siblings who all loved playing with it.

Believe me: we WILL do it.

By getting him to build another bike from scratch, I established the fact that he knew exactly what to do, and how to do it.

Even now, after seeing him create/build and fix stuff since he was 8, I am still I was awed that he did this successfully despite not having attended any formal learning event.

All he did was to watch a 3 minute video of an American chap, making the bike, and 48 hours later, the sister came running to me saying “Tayo, Chika has made the bike in the video!”

I’d downloaded the video for him and his siblings to watch (we do that A LOT as part of their real world relevant Personal Achievement Based Homeschooling). The American had used nice looking tools such as a hot glue gun, and a professional kit to make the bike.

As can be seen in our video, my son had only the simple tool kit I bought him last year, but he went out and got other scrap with which he improvised to build his own bike.

For instance, while a lighter was used in the video, along with a hot glue gun, my son had to use LOTS of matches in conjunction with a glue stick he got from his mother. The result was that the finished product was not as pretty as that in the video he had watched, but it worked!

So why didn’t I just buy him the stuff he saw used in the video?

First of all, we did not know where to find a hot glue gun, for instance, in Lagos. Stuff like that are not used much in our part of the world.

However the main reason was that I have always trained my kids to try hard at all times to get as much as possible done, with as little as possible. As a result, they have learned to be very adaptable/resourceful in using what they have to get what they want (like I AM).

By so doing they are building a capacity for achieving their goals with little or no money (like I do).

This philosophy has been behind their use of our trademark no-over charcoal stove pot to make cakes, chin-chin, bread, pizza, cookies and our pineapple peel based drinks.

This is why, whenever they do ask for money to try out a new idea, I rarely hesitate to give them whatever they ask.

Below I feature short clips from Chika’s 4 part demonstration video which is now available for purchase for N1, 000.0 (One thousand Naira).

chika-part3

Note that ANY payments for his products will be made directly into his bank account.

The 4 videos are available for direct delivery/download via email, as well as on CD/DVD via courier.

Regarding the FREE demonstration workshop, a minimum of 10 attendees is required for it to hold. So, once the number of buyers equals or exceeds that number, a date and venue will be agreed and communicated to everyone. Click here to request further details.

I share the work I do with my kids as a Best Practice Parenting Advocate – and NOT to brag!

What are you doing to help your child discover, develop and actualize his full genius/potentials? Be warned that schools and school teachers are NOT equipped to help your child with this most important need.

It’s Important that I make that clear. This is NOT about me. Indeed, it’s bigger than me. The future wellbeing and success of many children depends on their parents’ understanding and acceptance of the truths I share here.

You need to be a Coach-Parent to your child. Do not leave him/her to learn via Osmosis from you or any other persons. If you fail to act as a catalyst in the life of your child, especially during his/her formative years, s/he may not forgive you for it later on in life.

SDN Blog

New posts from last week*

Monday:

 

[Tuesday]:

[Wednesday]:

[Thursday]:

[Friday]:

Protected: Use This VBA Code Snippet to Make MS Excel Remind You to Save Your Work at Regular Intervals, to Avoid Data Loss!

[Saturday]:

 

 

[Sunday]:

Protected: THE FARM CEO (Issue 44): Website Introduction to Songhai Integrated Farming Centre, Maize & Soyabeans Prices/tonne, Grasscutters, Rabbits Prices [in Benin Republic]

Protected: THE FARM CEO (Issue 43): Agribusiness Data Survey in Benin (Rabbits, Grasscutters, Snail etc; buying Maize, Soyabeans in tonnes, buying a tractor), Snail Farming Online Learning Resources List/Links, Do Not Use Book Values of Ingredient Nutrient Composition for YOUR Livestock Feed Formulation

 

Tayo K. Solagbade*

Self-Development/Performance Improvement Specialist

*Creator of the Mastering Adversity for Perpetual Success Achievement Coaching Program

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