Category Archives: General

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

 

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>

PII 009: Churn Out a Relentless Mass of Useful Quality No-Strings-Attached Article Marketing Content – AND SELL MORE!

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 009: Churn Out a Relentless Mass of Useful Quality No-Strings-Attached Article Marketing Content – AND SELL MORE!

One’s ability to churn out a relentless mass of useful quality no-strings-attached article marketing content often makes readers overlook any biases they have, regarding the creator of that content!

It’s why I do so much of it daily, for my brand. I recommend you make it a priority for your brand as well.

To achieve Zero Cost Web Marketing, that kind of content must be put in place and constantly updated with more useful quality additions.

Those not willing to do this, because they want quicker results, typically settle for use of paid advertising online and off.

I however continue to argue based on my experience based achievement that
you get more profitable, better quality clients using low to zero cost web marketing of the kind I use – and which I advocate for adoption.

It takes lots of hard work and time to get it up and running (“critical mass”).

But once in place, the results will make the effort worthwhile – like pushing a large boulder to the top of a slope and the letting it roll down!

You need to TEST articles on your new website built by your new developer. This is needed in order to get a good idea of what the USER EXPERIENCE will be for visitors who come to your site from various sources e.g. search engine results pages, your Ezinearticles.com (EZA) by-line, or your EZA profile, an article posted on Twitter etc.

In my experience from working with clients, I’ve found that your home page needs to go beyond showing article titles to publishing a brief preview of each article also got pulled in under each title, to better communicate to readers.

One thing you need to avoid is devoting excessive space capital to your signup interface.

Instead mqke provision to link each image we use in a slideshow on the home pqge, to a specific page or offer on the site(?)

Many experts happen to have different target clients, with VARYING needs in fairly different markets.

It’s therefore important that the opt-in offer you have on your site caters for all of them.

This is why I feel it’s best to serve a mix of give away offerings – instead of just one.

Otherwise you may short-change yourself. It’s of course up to you to decide if you want to. But deciding on how to do IT will require some thinking and testing.

That’s why I feel it’s best we use the slideshow interface like I did over the years to be sure of what to put up in mine at www.tayosolagbade.com.

It is my experience based opinion, that a business website owner’s number one priority should be to ensure his/her website serves the most attractive content up in as compelling a manner as will make visitors “feel” convinced to connect with him/her by joining the mailing list or sending a message or request for more.

Keep this in mind: You can’t rush this process, if you’re to get it right!

SDN Blog

New posts from last week*

Monday:

[Tuesday]:

[Wednesday]:
[Thursday]:

[Friday]:

What If You Never Had to Leave Home or Drive Around Anymore to Make ALL the Money You Need (?)

[Saturday]:

Socio-Economic Stability Makes People Less Inclined to be Dishonest [True Story: Lady hawker in Cotonou offers to send me (via e-top up) N250 Naira worth of MTN Benin airtime, and I agreed – giving her the money, knowing that I could not recognize or locate her. Read this article to find out what happened!]

 

 

[Sunday]:

Protected: THE FARM CEO (Issue 42): Bill & Melinda Gates Foundation: Agricultural Development: Strategy Overview, Smallholder Farming in Africa: 5 Major NGOs, Five Innovative NGOs in Agriculture

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

 

Re: “Agatu Killings and Buhari’s moral weakness” [Alternative Perspectives and a Possible Way Forward]

I finally managed to read the Punch opinion piece from last week titled “Agatu killings and Buhari’s moral weakness” this evening.

It was sent to me by a “friend”…who preferred not to share it directly online…ahem…

As is my usual habit, I kept my mind OPEN like an umbrella in reading it from start till end.

To be honest, I only read it once – that was enough. I needed no second round.

The author’s points were clearly made and only a fool would argue that they were not valid ones – worth bringing up.

Long story short:

PMB was/is…

a. Refusing, for some strange reason, in the opinion of the writer, to address the issue of Fulani herdsmen killing people in Agatu

b. Doing what Nigerians call “eye-service” by sending condolence messages to other countries for terrorist related loss of lives while “massacres” continued in his own domain

c.”Reading from (GEJ’s) playbook” by being too lethargic in taking decisive action against the fulani herdsmen. She noted especially Buhari’s statement that the government would search for “root causes” and “act immediately to address the root of the problem”

She also took a swipe at Oga patapata of police – IGP Solomon Arase – in passing, with regard to his pronouncements on the reported activities of the Fulani herdsmen & that Buhari’s evasiveness encouraged the IGP’s attitude…

Here’s my take:

1. It is impossible for MOST Nigerians to accurately argue for or against any of the points raised – except for a tiny few who may REALLY be in the know.

Reason: Just like it is in PMB’s government, so it was in GEJs and those before them.

There is information that the rest of us will probably NEVER get to read or hear, about some topical issues of this kind, which will often influence what we see our leaders do and what we hear them say.

This is why I personally refuse to expend too much intellectual glucose on these kinds of issues.

Think about it:

In other climes, the kind of worldwide movement that the #BringBackOurGirls campaign initiated would have resulted in most if not all of the Chibok girls being found before GEJ left office.

Instead, what we heard/read is that at some point the USA pulled out from helping our people search for the girls because something was not right on OUR side of the equation and THEY did not like it.

How does one explain THAT??!

2. It is my considered opinion that too many well educated Nigerians fail to realize that the fact that we all dress well and speak good english to one another does NOT mean we are all equally sane.

Yes, I mean SANE as in sanity – opposite of insanity aka madness.

Many Nigerians in Nigeria, rich, not-so-rich and poor, are in different stages of insanity, influenced by the socioeconomic environment we operate in.

[NB: Let him who the cap fits wear it. For me, I categorize people based on their actions – what they do, and not what they say about themselves!]

As a result of the state of mind of majority among us, NORMAL thinking habits that people in progressive societies employ rarely appeal to us.

This is why it is said that even Jesus Christ or Islam’s Muhammad would get corrupted if they had to spend time in Nigeria, working with Nigerians.

3. I bring the above points up because I believe we need to ask ourselves why we always demand straightforward solutions from leaders, when we KNOW we are not straightforward people, and our society is far from being a straightforward one???

When I still used to pound the pavement as an entrepreneur in Nigeria, in my early startup years, I kept doing what the books said one should do to market products and services e.g. I placed ads, designed and printed flyers and made sales calls. I attended networking events and conferences. I subscribed to magazines and so on.

Yet, I got little or nothing in terms of client projects from all those efforts. And the few I got made a mockery of my skills, experience and educational qualifications!

The problem was I could not figure out why I struggled even as I saw many crooked and less competent others getting client jobs I wanted.

One day I visited a higher institution based on an advert I’d seen in a daily, to speak with the owner of an engineering training firm about an idea I had for a Joint Venture. It turned out the gentleman was also a lecturer in the engineering department.

After I introduced myself, we got talking about what he did and at a point I mentioned that I’d once been a guest speaker at the Centre for Management Development(CMD) – Shangisha in Lagos, and that the feedback in the forms filled by the centre’s directors had encouraged me to develop a one-day seminar based on the theme of the talk I’d given there.

I however noted that despite hand delivering over 50 copies to organizations in Lagos (many of which were multinationals or large indigenous ones), I’d gotten nowhere with it.

He looked at me in amusement as I spoke, then smiled as he pulled out a one page document with names, and signatures as well as a stamp on it.

Pointing to the fee per head column, he told me that the training manager in the company he did that training for had bluntly told him to give up N4k out of the N15k for EVERY one of the 15 attendees who got nominated to attend.

He then told me these words:

“My friend, you will not hear from them. They expect you to know what to do. If you know what to do, and make them an offer, they will then tell you what they want. From what I see on this booklet, this program of yours is loaded, but if you refuse to do what I’m telling you, I really doubt if you’ll make headway with it.”

That conversation happened in 2004 – 2 years after I became self-employed. 2 years after I’d spoken at CMD and the training manager had told me “If you say you’ve spoken here, they’ll invite you to speak”.

I went on to hear many variants of those words uttered by that engineering lecturer, from others I had cause to speak with (including close relatives!) as the years progressed.

But no one had ever told me I needed to “know what to do” along these fraudulent lines when I started out as an entrepreneur. What I later found out was that almost everyone around me already knew and/or also did it (relatives included!)

They just assumed and expected I would find out and eventually fall in line, having LEARNED that it was impossible to fight the system.

Well, here I am today. I succeed on an international level as a multipreneur, earning income without needing to leave my home – and while traveling between countries.

But I did not need to continue wasting my time fighting the system to get here. Instead, after YEARS of suffering doing that, I conceived a strategy that enabled me completely EVADE the system.

In other words, I found a way to do what I LOVED doing for a living, without needing to relate with people who believed in the system in a way that gave them power over me!

4. How does ALL this relate to the issue of Buhari and the points made by the author of the Punch opinion piece?

Well, it’s simple really.

Nigerians, from what I’ve seen over the past 14 years as an entrepreneur, are over 80% a duplicitous lot.

Forget schooling, status, class, income level etc. Duplicity has become a way of life for most!

So, anyone who wants to achieve meaningful progress working with Nigerians will probably have to be psychic to SEE through their double-facedness.

As a president, Local Government Chairman, head of a small parastatal, or a mere chairman of the building community awarding contracts in your small church(!) you will find yourself surrounded by conniving characters who show one face to you today, and another tomorrow. Scheming to get what they are not qualified to have!

Based on the above situation, no matter how good your intentions are, you may find that pleasing Nigerians will be hard – because even those crying that they are being victimized today (as well as the ones working with/for you) will often gladly let themselves be used against you – if it benefits THEM!

Example: What does it take to get 80% of Nigerians to go out and bear false witness about something that did not happen?

We’ve seen it happen again and again – accusations and counter accusations with those in charge of deciding who is telling the truth even eventually getting fingered for also joining in!!!!

5. It is possible that the above is why Buhari said he wanted to search for the “root cause”….maybe the man is seeing a lot of the duplicity on all sides as I have seen in my own small corner of Nigeria(?)

Maybe that’s what makes him so reluctant to act I.e he’s struggling to make sense of the mixed signals he’s getting(?)

Or maybe the man is just confused….or biased – as some would have us believe (NB: I do NOT agree with this school of thought).

Possible Way Forward

Hopefully it will be obvious I’m making no case in support of Buhari or his IGP here.

In fact, I’m making no case in support of, or against anyone here.

Instead, I’m simply saying the major problem of Nigeria is that it is a society of over 80% dishonest SOULS who never want to let truth prevail and always put self-interest first!

In such an environment, even an angel will struggle to get anything right as a leader.

This was why GEJ struggled to lead Nigeria, as did others before him.

My argument against GEJ was however that he was too weak, and showed no strength of character.

In Buhari’s case I have yet to see enough to justify drawing any far reaching conclusions about him.

After he’s spent 24 months in office I’m convinced I will have enough material to use as a basis for doing an accurate, fair and impartial evaluation of his leadership of Nigeria.

For now, I will continue to work and pray in every way I can for his success, because PMB’s success will benefit all Nigerians, regardless of tribal or party affiliations, including me, you and all our loved ones.

 

 

Download 37 Archived Editions of The Farm CEO Newspaper (8thJune2015 -15thFeb2016)

Like I said earlier this year, all my Farm CEO clients (i.e farm business owners who make purchases from me – from a certain lower limit upwards) will get instant lifetime subscription to The Farm CEO Newspaper.

The screenshot below shows ALL 37 issues published in PDF format since I launched it mid 2015, about 8 months ago.

tfc-01to37-15thFeb2016-shot

As I continued publishing it, I discovered that new clients who joined my network often added new perspective to ideas I had about editorial content to publish next.

Indeed, at a point, some clients made requests for certain kinds of information, that I had to search for on their behalf, which convinced me to adopt this strategy of giving non-expiring subscriptions to all clients.

Since it came into effect, I’ve gotten more responses to the content published – for obvious reasons.

Since my goal is to use this newspaper to HELP Farm CEOs grow their businesses, it only makes sense to continue with a strategy that’s eliciting useful feed back from them.

Now, if you’re a client and are NOT aware of it, let me inform you that as a member of my Cost-Saving Farm Business Ideas Club, you are entitled to contact me to help you research a subject or topic related to your business.

Just call me to let me know what you have in mind. It’s even possible I’ve already compiled such material for a previous client and will simply need to send them across to you.

For those interested in getting access to the archived PDF versions of The Farm CEO, click here to send me a request.

Why I Voted for Buhari (Despite Voting Against Him in 3 Previous Elections), and Why I Believe He Has What it Takes to Reform Nigeria Now That He’s President

My attitude towards any personality – be s/he celebrity or public office holder – is that s/he could be my brother/sister/father or mother or even a good friend.

So, regarding the many unsavoury campaigns launched against Buhari during the countdown to the elections, I always asked myself:

How would I have felt – as Buhari’s son – when all those false claims were being made about his lack of results or original certificates to back up his claims of schooling?

And after he got into office, would I not want my “father” to be given a fair and impartial opportunity to SHOW what he can do…especially when his success would BENEFIT even his critics???

For each of us, it never feels as bad as when it’s happening to a loved one!

Those same considerations guided ALL I did and said even while GEJ was in office.

I carefully studied him over time. Especially what he said with his own mouth and what he DID – or said he did.

Most times I came away not very happy.

But it was his scandalous exchange with the CNN lady (Amanpour) in that January interview that finally did it for me. I arrived at my own assessment of him – and boldly stated it. For me, he simply could not meet the mark. He lacked the depth to do so – and, I believe it was not his fault. He simply got promoted beyond his level of competence without knowing it. Period.

As a result of the above observations, the last thing I expected GEJ to do was run for office again. But he apparently saw himself differently.

Still I did not “hate on him” for that. He had every right to contest again!

However I decided I would do my bit to ensure someone I considered better got in ahead of him.

So I chose Buhari…

What most people do NOT know is that I did NOT vote for Buhari on ALL his previous outings…!

If I recall correctly, I voted twice for Okotie (despite being a non-church-goer O!). Then I voted for Ribadu.

But after I saw how they ended up, and noticed how Buhari remained as constant as ever in his resolve, I realized he had a rare strength of character that had obviously made him immune to what I considered the chronically corrupting influences of Nigerian society.

It is my considered opinion that MANY who do not appreciate Buhari have NOT really experienced Nigeria the way I have as adults with family responsibilities outside paid employment.

Have you EVER had to function as an ADULT with dependants in THIS Nigerian society, outside of salaried employment for up to 5 years at stretch?

If YES, then – unless you had connections with crooked people making things happen for you – it is VERY likely you will have SEEN the naked evil that people do to others in such circumstances in Nigeria. They do it with impunity – even to relatives.

In my case, I’ve been functioning as an adult with wife and kids outside paid employment and NO CONNECTIONS now for 14 years

During that time, I have been to Nigeria’s hell on earth and back, more times than I care to count!

When you lack money in Nigeria as a self-employed person and are not lucky to hold salaried employment of any kind to guarantee some income to SUPPORT those that you are responsible for as spouse and parent, you will KNOW that there are multiple levels of suffering, humiliation and downright evil doing in Nigeria.

For Buhari to have been kicked out of public office when he was, and still remain without blemish till today, such that nothing could be found to use against him during the elections spoke VOLUMES to me.

I have been on the streets in Nigeria. I have SEEN/FELT suffering caused by corruption in this society as an entrepreneur trying to earn income the honest way.

And I can tell you that ANYONE who has tasted power in this society (like Buhari did), and can still RESIST corruption like Buhari has done – and is DOING – has what it takes to CHANGE this nation for the better.

Character and integrity are qualities that make it possible for any person to achieve ANY goals s/he sets his/her mind on – Buhari WEARS them like a cloth!

And that is why I am convinced Buhari is our best bet for reforming Nigeria.

We must not forget that we have MBA and PhD holders engaged in all sorts of fraudulent dealings in and out of the public as well as private sectors daily.

These are brilliant minds that have soiled their hands and compromised themselves, so that it’s now impossible for them to demand for others to do what is needed to change Nigeria.

Does it occur to us that Buhari has no PhD and yet no one has been able to pin any corrupt dealings on him?

Whether Buhari has intelligence or IQ or a wall covered with degrees and awards for leadership excellence, or not, is immaterial – because we have too many examples of people who boasted all those and still failed to deliver, and even stole out money!

I argue that even Obama, with all his distinguished accomplishments after running 2 terms in the USA would be made to look like the biggest FOOL on the planet, if by some strange miracle, he was allowed to contest for office in Nigeria and won the elections to lead us for 4 short years.

We all know what would have happened to Obama if when the republicans were trying so hard to discredit him in office, the country had been NIGERIA, with full blooded Nigerians in it, and NOT the HIGHLY discerning Americans that son of a Kenyan immigrant has had to preside over!

It would have been a mess and Obama would have been buried under it!

This is why I believe a man like Buhari who has successfully defied Nigeria’s corruption machine is the best bet we have.

But we don’t ALL have to agree on this. Each person has a right to his/her own opinions.

I AM a citizen of Nigeria and because I wanted Nigeria to succeed, I acknowledged the Good I saw done by GEJ while he was in office (my posts are still there on his Facebook page, and on my own wall). Same thing I did when OBJ was in power.

It is the same thing I do now. I refuse to sit back with a wait and see attitude. Instead I will hope and pray, and do what I can in my own little way (like I did all the time the other presidents were in office) to make Nigeria succeed with Buhari’s leadership.

By so doing, I believe I would be setting a good example for my kids to follow.

I hope others will do the same.

Related Article:

A People’s Ability to Disagree Without Being Disagreeable is Crucial for Societal Advancement [Hint: Why Too Many of Today’s Nigerians Are Often Too Angry to be Reasoned With!]

Conversations About Productivity Boosting Excel Visual Basic Automation [True Stories: Enquiries from a business user in India and Nigeria]

[UPDATE: 24th June 2024 – Download PDF Version with offer of download links to the original automated MS Excel Workbook and screenshot video demonstration sent to Pravin. Click HERE to download the PDF now – NO SIGNUP NEEDED]

Conversations---Pravin

Since announcing my FREE workshop Introduction to Excel-VB Automation on Monday, which is to hold tomorrow (Sat 19th Mar 2016) for members of my Excel-VB club, I’ve had some MS Excel business users contact me.

In this article I share screenshots and excerpts s from 2 such exchanges – one with a business user based in India, and another with a Nigerian Farm CEO – with background in corporate management – who is a member of my Cost-Saving Farm Business Ideas Club.

A. At about 12:53 p.m on Tuesday 15th March 2016, I got the message below from an Indian gentleman, requesting my help with getting Excel-VB code he was writing to run – trouble free – for a task he was trying to automate.

Here’s the message:

“Sir right now i got vba code for i have been searching from a gengleman…..but can we set two macro in a single excel sheet… The following code solved my Single problem.

Sub Copy_Paste_Data()

Sheets(“Sheet1”).Range(“A3:N1000”).Copy Destination:=Sheets(“Sheet2”).Range(“A” & Rows.Count).End(xlUp).Offset(1, 0)

End Sub

I shall use the above code when I have to export all all kind of data from A3 to N1000.

But If I don’t want to export the data having no value in column I.

If Column I has no value so that row will not be exported to Sheet2… What I mean to say that if I need all data to export then I shall use the above code and When I need to export data having value in column I then I shall use that code for i am requesting you to make.

So this way my grave problem will be solved……….please send me it to my maild id (removed for privacy)

At about 12:53 p.m on Tuesday 15th March 2016, I got the message below from the gentleman requesting my help with getting Excel-VB code he was writing to run - trouble free - for a task he was trying to automate.

I replied that I would do what he asked on the condition that he agree to let me use him/his “project” as a case study for step-by-step video tutorial I would share with my Excel-VB club members – who pay to learn from me.

He responded by sending a request to join my Excel-VB Club, and posting this follow up message:

It’s your kindness. Thanks for helping me……..Sir I shall eagerly be waiting for your mail with video sir………Thanks a lot again sir..
….

Sir, I got formula as I needed. but as we run that, it export the data
even with value (formula also exported and that looks #REF! ). so only
this problem remains now…….so please help this way now i am just
providing you this code that i recently got from a gentleman….

Sub Copy_Paste_Filter()

With Sheets(“Sheet1”)
.Range(“I3:I1000″).AutoFilter Field:=1, Criteria1:=”<>0”
.Range(“A3:N1000”).Copy Destination:=Sheets(“Sheet2”).Range(“A” & Rows.Count).End(xlUp).Offset(1, 0)
.Range(“I3:I1000”).AutoFilter
End With

End Sub

He responded by sending a request to join my Excel-VB Club, and posting this follow up message:

The above message came in a 4:29a.m – I’d only just gone to bed 1.5 hours before then, after finishing work on a client project.

So, when I saw it in the morning, I wrote back saying(in part):

“… I am just waking up…My priority this morning is to get a client’s boolk manuscript proof reading finished and returned to him…Only after that will I then be able to spend time creating the video tutorial I offered for use as a case study…If you cannot wait for that, I recommend you ask the “gentleman” that is giving you these codes to help you debug it to get it running properly. Alternatively Google to one of many open discussion forums and post your question there.

My Excel Heaven brand does NOT operate in that manner…When I’m done, I will create the promised video and send to you and my club members. “

He replied saying he would wait.

Looking back, I’m glad I was frank with him, because as I type these words, I still have to do a visit to the talk venue his p.m and also review material I’m to use tomorrow!

So, chances are good that I’ll have to create the promised video over the weekend.

One thing is certain though…

This exercise is going to be perfect for use in explaining how range objects can be manipulated using MS Excel-VB coding.

Even more important, this particular case study will serve as an introduction to EFFICIENT coding that executes faster compared to he clumsy code sentences generated by the Macro Recorder (which my club members are starting with)!

B. It’s now confirmed that I’ll be having more than ONE run of my 4 hour FREE talk event tomorrow. Reason: Some members of my Excel-VB club will not be able to make it down to join the main group from 2p.m.

Apart from those wanting to come at a different time (I told them I’d be HAPPY to meet ANY who chose to do so), at least ONE, based outside Lagos will not be able to come down at all.

For him and others like him, the nature of my Excel-VB club makes it possible to STILL learn ALL they need to know. See details below, based on a response I made to a member of my Cost-Saving Farm Business Ideas club, living in Ibadan, who asked about Video tutorials:

See details below, based on a response I made to a member of my Cost-Saving Farm Business Ideas club, living in Ibadan, who asked about Video tutorials:

It so happens that my Excel-VB club is designed to enable business users/busy persons who become members learn from me remotely, with the option of attending the FREE Monthly Workshop (Saturday’s being the maiden one).

Since they signed up, the current members have been receiving downloadable video tutorials taking them though what they need to know.

One member who is based in Port Harcourt, chose to purchase the Home Study video tutorials I’m creating on DVD. After the workshop on Saturday, I will add new videos based on that event’s outcome and send to him via Fedex.

I recommend you also join the club, so you can get the DVD via the 2-in-1 offer I make to new members i.e. pay the membership fee to join the club, in response to an offer I make to you via email, and I will send you the DVD containing the home study step-by-step videos, while you continue, like other members, receiving the online tutorials and tips I send out weekly.

Here are some useful links to give you a better idea of what is on offer:

1. LEARN MS EXCEL-VB AUTOMATION FROM ME…IN THE COMFORT OF YOUR HOME!

http://excelheaven.tayosolagbade.com/?page_id=66

2. Learn more about what you get on the DVD below:

Title: Get My Home Study Excel-VB Programming Video Tutorial DVD

http://excelheaven.tayosolagbade.com/?p=336

3. This page provides a detailed background (including a 9 part slide show presentation) about my Excel-VB Club and Competition:

Title: Welcome to my MS Excel Heaven Visual Basic Automation Club [Introductory Videos You Need to Watch]

http://excelheaven.tayosolagbade.com/?p=318

RELATED RESOURCE

1 Hour Talk(No. 5): Proven Strategies for Using MS Excel to Boost Employee and Company Productivity (or go to http://tinyurl.com/xlvb1hourtalk)

Click here to contact me if you have any questions or require clarification.

 

1. Click the link below to download a 9-page MS PowerPoint Slideshow which explains in FULL details what you will be learning – and doing.

http://tayosolagbade.com/uploads/xlhcluboffer.ppsx

The Need to Conquer Our Fears to Live in Harmony With Nature’s Gifts [True Story With Photos: The Scared Stray Kitten I Rescued 5 Years Ago Is Now A Mother of Two Lovely Kittens!]

In certain societies, people live in harmony with snakes, and even worship them. In others the mere sight of a baby snake will have everyone taking to their heels. It’s a simple question of familiarity.

A child that’s never seen (or been near) a dog before, could get scared, and even burst into tears when one comes to her, playfully wagging its tail. Give that same child a few days or weeks, and he’ll soon be the best of friends with the same animal!

Let me share an example in form of a personal true story.

I once took home a stray kitten. It had been chased into the rain by some market women who wanted to kill it (based on superstition that it was a witch – a story for another day).

Not only did it have blood coming from its nose, but it’s heavy breathing suggested it also had a respiratory infection. I knew leaving it was likely to mean certain death for it.

Plus, from my earliest years till well into my teens, I and my siblings had lived with cats and dogs in our parents’ home. It just felt natural taking this one home with me.

However, there was a problem.

I knew my two youngest children (girls – 3 and 6 years old), and their mother, were scared of animals. The boys having spent time with me picking up all kinds of insects, trapping birds and rodents, were already weaned of their fear of many things.

So, when I got home, I connived with the boys to make the cat at home :-) They fed the kitten with warm milk and medication given it by Dr. Folorunsho, my Vet Doctor friend who’d cleaned it up and treated for injuries.

Then I pleaded with their mother to let us nurse the kitten back to full health, after which I would let it go. She agreed, but warned “Just keep it away from me!”

After a month, she was back to full health and bounding around the house. Well, it’s been 2 years now since Lily (that’s the name the kids gave it) joined our family.

She’s a big girl now. And guess what? Our girls now carry it around fearlessly, just like their brothers do. And although she still won’t stroke it, their mother brings home pieces of fish and chicken from the frozen foods store, which she cooks for the dreaded cat!

All the perceptions she’d carried around about cats had been subject to tests during the many months she’d had to be around one on a continuous basis. This helped her verify that most of the things that she;d been told were unfounded.

It’s been over 3 years now. She has been with the kids, and the cat, ALONE each time I’ve had to travel away to Cotonou. Very rarely has the issue of the cat come up for discussion at anytime.

She's a BIG girl now, our cat. When I rescued her in September 2011 as a badly injured kitten, with a severe respiratory infection, she fit neatly into the palm of my hands! The kids LOVE her silly. We once visited my parents and took the cat with us. Something scared the cat as we got down and she scampered into an uncompleted building. Thinking she would come out later, we went in to my parent's. By the time we came out, she was still nowhere to be found, so we left - the kids were all downcast. It was like someone had died!
She’s a BIG girl now, our cat. When I rescued her in September 2011 as a badly injured kitten, with a severe respiratory infection, she fit neatly into the palm of my hands! The kids LOVE her silly. We once visited my parents and took the cat with us. Something scared the cat as we got down and she scampered into an uncompleted building. Thinking she would come out later, we went in to my parent’s. By the time we came out, she was still nowhere to be found, so we left – the kids were all downcast. It was like someone had died!
Thankfully, one week later, when I visited my parents again, a securyty guard informed me of a cat meowing as if lost in the compound he was guarding. He was scared of cats, and was visibly rel;ieved ewhen I called out the cats name and she ran out to meet me. She was dirty and obviouslyt bvery huinrgy. My mother quickly made a her a bowl of milk. I left for home earlier than planned . We had a celebration at home that night!

Another reason she may have accepted the cat, was that its meowing soon scared away mice and rats that often came from the undeveloped plot next door!

However one looks at it, the point to be made is that once she got familiar with the animal, she lost her initial fear of it, and now lets it sit next to her!

Today, we have NOT one, but three cats – because Lily is now a mother!

See photos below of Lily the little ones – born on 22nd December 2016 i.e. about 3 months ago.

lily-sdn-2 lily-sdn-3 lily-sdn-1

We had a few scares during the first few weeks of their lives, when they picked up some eye infection, but our good Vet doctor friend prescribed a mix of drugs that soon cleared all that up.

Related Articles:

1. Teacher Says Tom and Jerry Cartoons Make Kids Act Retarded …AMAZING!

2. Schools Can Kill Your Child’s Creativity – IF You Don’t Apply These Tips

Attend Tayo Solagbade’s FREE 4 Hour Practical Introduction to MS Excel-VB Automation Workshop [Get Home Study DVD Video: How to build an automated Cash Book with Bank Reconciliation table, Debtors/Creditors Schedule etc]

NB: At the bottom of this post is the transcript of a message I sent (with download link to my NEW VIDEO titled “How to build an automated Cash Book”) today to members of my Excel-VB Club in continuation of their home study coaching.

 Join 3 accountants and a university professor in my NEW MS Excel-Visual Basic Automation Club, to attend this FREE workshop, and also start downloading my step-by-step tutorials on automating your daily tasks in MS Excel using Visual Basic Macros.

Highlight: Get a Step-by-Step video tutorial on best practice worksheet design and Excel Visual Basic coding using a real life spreadsheet software I built in 2007 for a popular Lagos based hospital with over 120 staff.
1. Each club  member wishing to attend, gets FREE access to my forthcoming FREE 4 Hour Practical Introduction to MS ExcelVB Automation Workshop.
Attend Tayo Solagbade's FREE 4 Hour Practical Introduction to MS Excel-VB Automation Workshop [Get Home Study DVD Video: How to build an automated Cash Book with Bank Reconciliation table, Debtors/Creditors Schedule etc]
2. ALL attendees will get a DVD containing my Home Study Step-by-Step Video Tutorials.
3. Non-club-members wishing to attend simply need to join the club by paying the membership fee.
Details, with links to relevant additional information provided below:

Date: Saturday 19th March 2016

Attendees: Tayo Solagbade’s Excel-VB Club Members ONLY. [Not yet a member, click here to let request signup and other details]

Venue: TBD

Admission Fee: FREE – for ALL Members [NB: Every tuition or training centre that joins the club automatically secures FREE access for ALL its students/learners, to the workshop, AND also to my step- by-step tutorials]

AS A MEMBER, YOU CAN ALSO INVITE ME TO CONDUCT MY FREE EXCEL-VB WORKSHOP AT YOUR TUITION CENTRE!

Signup and invite me to conduct the workshop on YOUR tuition centre’s premises, on a date convenient for YOU and YOUR students.

First 5 tuition centres to signup pay N10k (instead of $65 USD or N13k) to join. All club members get to attend my FREE 4 Hour Introduction to Excel-VB workshop.

1. To learn more about how to join the club or compete, OR to be a SPONSOR, click the link below to download the 9 page slideshow that offers FULL details:

http://www.tayosolagbade.com/uploads/xlhcluboffer.ppsx

2. Introductory Videos Club Members Need to Watch

Welcome to my MS Excel Heaven Visual Basic Automation Club [Introductory Videos You Need to Watch] | SD Nuggets™

Transcript of Email message sent to club members today…

Hi,
Click the link below to download PART 1 of the new video tutorial:

http://tayosolagbade.com/—link disabled—.zip

TITLE: How to build an automated Cash Book with Bank Reconciliation table, Debtors/Creditors Schedule etc.

It is a Step-by-Step video tutorial on best practice worksheet design and VB coding using real life spreadsheet software I built in 2007 for a popular Lagos based hospital with over 120 staff.

INSTRUCTIONS

Download the zipped folder linked ABOVE to your desktop and unzip the contents.

2 files will emerge. Double click on the web page file to launch a browser window in which the SWF video file will playback/

Note that if you see THE browser prompt shown in the linked PNG image below, all you need do is simply click “Activate Adobe Flash” (or the equivalent linked text displayed in your browser), and follow the instructions to get the video to display and play.

http://tayosolagbade.com/sdnuggets/wp-content/uploads/2015/10/fbsc-video-tip.png

Let me know if you need help.

In your service.

Tayo

A Smarter and Cheaper Strategy for Earning Foreign Exchange [Hint: It’s NOT Related to Crude Oil or Agricultural Exports…But It’s Cheaper And More Sustainable]

It’s become more apparent that we as a people in Nigeria still refuse to GET IT, when it comes to identify SMARTER strategies for earning TANGIBLE foreign exchange on a sustainable basis to boost our economy.

Since I became a child capable of intelligent thought, growing up in Nigeria, most times the subject of foreign exchange earnings has been discussed, it has always been MAINLY regard to sales of Crude Oil, and Agricultural Exports.

Fast forward many decades later, and I’m approaching my 46th birthday, yet nothing has changed.

Both the leadership and followers in Nigeria still cannot see that there are MANY more reliable alternative ways today, to earn substantial amounts of foreign exchange, on a long term sustainable basis, at much less cost, using much fewer resources, and in much less time!

This is the Information Age we’re in for heaven’s sake. A time in which PC and Internet technology drives virtually every area of our lives – even including the exploration of our crude oil (which now commands pitiful selling prices in the market) as well as our agribusiness endeavors.

I recently got a browser error message displayed in my attempt to make online renewal payment for a client’s website hosting using my Debit card, linked to my Paypal account.

The message shown advised that my card been “denied by the card issuer”: I had no clue what that meant.

By the time I called the bank’s support arm, they checked and announced that the funds paid in by my client were insufficient. In reality however my hosting provider platform was working with Nigeria’s N200 to $ 1 USD official exchange rate showing that I have well over the required amount.

Long story short, by the time I voiced the above fact, the bank customer service operator told me that N300 to $ 1 USD rate was set for online card transactions, due to the continued fall of the Nigerian Naira, was responsible!

Yet, NO notification was sent out to card users to that effect.

So users discovered that fact only at the point of payment! By implication of the above, my client, who’d I only recently hit with a price increase, to adjust for an earlier value drop, now has to absorb yet another hike to make the payment possible.

My point however is that this is all happening because Nigeria’s major means of earning sustainable amounts of foreign exchange is via crude oil and agricultural sales, for the most part. With the former providing the bulk of the earnings, effectively making us a mono-economy for decades, we were NOT ready for the drastic change in fortunes when it happened.

Now that the oil market is no longer so lucrative, our leaders and people are turning to Agriculture – which is not bad. However, in doing so they are adopting the same mental attitude employed in handling our generation of Forex earnings from crude oil sales.

By this I mean, for instance, that they are working to setup large plantations, agricultural estates, farm settlements and the like.

To be fair to them, such models are proven to be viable and in some areas are already working. The problem I see, which many of those involved seem not to, however, is the fact that this adopted approach takes A LOT of time, money, effort and resources.

This is why despite the lucrative prospects of venturing into agribusiness, so many who want to, have not been able to. And since government itself is no longer exactly swimming in a pool of free-to-spend cash, they are unable to give out as much financial assistance as they would like to.

Add to that the massive hole smashed into Nigeria’s coffers, by the political looters, most still being chased for possible recovery, and it becomes obvious that this capital and resource intensive strategy used for so long is simply not worth making our main focus.

We need to put in place something that can work faster, with much less (if possible zero cost) requirements, while at the same time impacting a larger number of our people.

Such a solution exists and has been in existence for decades.

But it is ALIEN to our society, for the most part. We are simply not used to functioning in such dimensions.

That is why it is understandable that up till this moment, despite ALL the pain, suffering, and lack visited on majority of us, we and our leaders still choose to ignore it or pretend it’s not there.

Yet if we were to adopt it, massive benefits can accrue to us a nation, within a much shorter period, and on a much more sustainable basis compared to what we currently have in place!

This solution requires deliberate use of the Creative Mind, the brain, the thinking faculties – in as many varied ways as possible, to earn income.

To some extent one could argue that we have elements of that happening already in Nigeria. That would be with regard to our entertainment industry. I won’t waste time explaining much.

One example should suffice.

What do David O, Tuface, Olamide, Sunny Ade, Wiz Kid, Seun and Femi Kuti, Lagbaja and so many other musicians getting international recognition do to make money?

Simple. They think up songs and strategies to deliver those songs to their target markets in a way that gets them invited to perform, and also earns them royalties from records sales.

But let’s get real here. Most Nigerian artistes don’t really know what it feels like to live on royalty earnings. The system we have here simply does not protect their interests that well in the respect.

As a result, they depend heavily on LIVE shows for their living. However Lagbaja, the Anikulapo-Kuti Brothers, Asha and other Nigerian acts who have established themselves by traveling and recording internationally, can boast of such royalty benefits being significant. Fela Anikulapo Kuti did that so well, that his albums continue to generate earnings for his offspring toda, MANY years after he’s passed on.

Most people in Nigeria don’t get it but THAT is another way foreign exchange earnings enter Nigeria.

Having said that however, even the music or entertainment creation model does not offer as much rewards to a large population like ours, compared to the solution I have in mind.

Among other things, getting started in music can often require having access to scarce funds. And this has caused some great talents to NOT take off in that industry.

The solution I advocate for adoption has much fewer barriers to adoption – even age is almost no limitation!

The fact that Nigerians in general have not adopted this solution I have in mind, does not imply we are dumb, blind or stupid.

No. It’s more of a problem of one-sided thinking caused by years of exposure to an environment in which VERY little critical thinking is done.

That is why we all think the same way about subject like these. We keep saying oil prices affect our dollar earnings. We forget some countries don’t even have Crude Oil to sell, yet they earn BILLIONS in US dollars annually!

A good example is India.

The Indians are leaders worldwide in software development and sales, and it earns them huge volumes of foreign exchange annually.

Unlike us, they did not sit around waiting for oil wells to be dug and oil to be drilled from them for sale to other countries at the huge expense we all know it takes to do it.

Instead, several decades ago they invested quality time and money to bring in top programmers to teach coding to Indian youths from primary school level on a formal basis.

It was a deliberate strategy that they diligently pursued until they began to turn our armies of young programmers, with the marketing skills to take whatever solutions they created and use the web to reach their target buyers.

Today, we know that many organizations in Nigeria use Indian software, which they often purchase RENEWABLE user licenses for – at premium rates in US dollars, all of which goes right into the Indian economy.

Yet I know of no single digital solution conceived and developed by Nigerians in Nigeria, that is purchased for use by Indians in India – whether as individuals or organizations.

It is also instructive to note that this happens with comparatively less effort and money being expended by the Indians – when compared to the costs we incur to get our crude oil to buyers!

In other words, the Indians (and other nations like them) are making low to zero cost use of the creative intellect of their nationals, across various age groups, to create foreign exchange earning solutions needed on a regular basis by people across the world.

[Hint: Note that I say the above as one who has made sales of my customizable Excel-VB Ration Formulator software to buyers in places like Canada, Philippines, England, Tanzania, Uganda and other countries but NOT ONE sale to anyone – so far – in India. Yet, over 90% of the enquiries posted under one of the most viewed videos for this aforementioned app were made by Indians who repeatedly request in their posts that I send them the app FREE…for some strange reason!]

If we in Nigeria are really serious about getting ourselves out of the mess we are in, with regard to having adequate foreign exchange earnings, we WILL have to look beyond the traditional capital intensive methods we’ve gotten so used to.

We will have to do something similar to what the Indians, Americans and many other developed countries are doing.

We will have to invest MORE time in using the creative intellect of our people, which comes at low to zero cost, to create solutions we can sell to a potentially unlimited global paying audience of eager buyers, just like the Americans and Indians have been doing to us for years.

Once we begin doing that, our own army of creatives will generate solutions that will attract buyers from abroad to pay in foreign currency.

Over time, that will add up like it does for India, giving us enough reserves to NOT have our currency fall so badly in value that prohibitive exchange rates stifle our ability to make online payments for what we want.