Category Archives: Career Development

Create a Splashscreen for Your Custom Spreadsheet Application [Part 2 of 2] – Step by Step Video Demonstration

There are 2 videos to watch below, in this non-password-protected post for members of my Excel Heaven Visual Basic Automation Club:

Video 1: What a Splash Screen looks like – real life demonstration using Tayo Solagbade’s Poultry Farm Manager Excel-VB Spreadsheet app

splashscreen1

Click here to watch the video

Video 2: Step-by-Step demonstration of how to build a Splash Screen for your Workbook application

Explanatory Overview

As your skills in Excel-VB programming improve, your confidence will grow, and you will begin to identify enhancements you can add to your workbook applications that go beyond conventional worksheet and coding needs.

A good example is the use of workbook splash screens.

They are typically used to offer some quick information (name of app etc) and sometimes brief entertainment or distraction to users – when an application is being launched.

Excel-VB coding can be used to create a splash screen – from simple to fairly sophisticated levels in terms of behavior and aesthetics.

The first video I share in this tutorial shows the custom designed splash screen I built into my Excel-VB Poultry Farm Manager to give it a fairly professional appearance/feel.

It took the use of enhanced graphic design with Photoshop, coupled with creative placement of various images using Active-X controls to achieve the visual design effect that the user of the PFM is presented with.

 

The step-by-step tutorial video I offer below it uses a more basic approach to the creation of a splash screen.

Below: Writing the code to define the time duration the Splash Screen will appear for, and then close

splashscreen3

Below: The simple splash screen that results

splashscreen2

Click here to watch the video

In a future tutorial I will show how to create something with a more refined Graphic User Interface (GUI).

For now, what matters is that you learn and understand how to write the needed bits of code to make your simply splash screen work as expected.

I explain in full detail just how to make that happen in this straight forward, easy to understand 8 minute tutorial.

RELATED ARTICLE

What You Need to Create a Splashscreen for Your Custom Spreadsheet Application [Part 1 of 2]

[FREE] POWERFUL TRUTHS ABOUT REAL BLACK HISTORY, NOT TAUGHT IN SCHOOLS, BUT WHICH YOU (AND YOUR KIDS) NEED TO KNOW

Why do black people – and their nations – often lag behind others? I have argued for years that the reason is NOT genetic. Instead it is the mental attitude of majority of us.

No one can under develop us. We have the power to develop and advance ourselves. I am doing that for myself and my family. No one can stop me. I do NOT need the government to do it for me.

If more of us would adopt a similar mindset, we would transform our individual lives, and the fortunes of our respective families and societies.

My accomplishments over the past 2 decades prove that my sentiments are accurate. But the 2 books and a movie that I feature in this report offer incontrovertible proof that we, as a people have what it takes to excel on this planet.

I recommend you read this report and follow the URLs provided to learn more, so you (and your kids) can be empowered!

2books-1movie

A Common Misconception About Spreadsheet Programming You Need to Know [Hint: What is Excel-VBA?]

[NB: The 2nd and concluding part of my tutorial titled “What You Need to Create a Splashscreen for Your Custom Spreadsheet Application” will go out next week]

======
Today, I feature the article titled “What is Excel-VBA”, (which I wrote back in 2007) to inform and educate my desired target audience and other relevant stakeholders, about the difference between Excel-VB programming that I did, and Visual Basic – that most of them were more familiar with, and often tried to equate to what I did.
This need to put forward a clarifying piece like this comes from my recent discussion with a Farm CEO, who works a 9 to 5 job as a Network Administrator.

He caused me major amusement when he asked me to email him a “patch” to download to resolve a problem he had with one of my Excel-VB software that he’d purchased.

 I said “What patch?” – and he replied that he meant a “piece of software designed to fix or improve” my Excel-VB software that he had purchased.
At that point I was forced to bluntly inform hims that Excel-VB programming vocabulary does NOT include such terms used in the Windows Operating System world – which was where he’d gotten the word “patch” i.e. as per the downloads that happen on Windows PCs to plug bugs or vulnerabilities in the Operating System.

The fact that he chose to use that term (meaning he assumed that kind of resource existed!), in addition to calling me a “Visual Basic (VB) Programmer” proved conclusively to me that he had NO CLUE what Excel-Visual Basic for Applications (VBA) was about and just how VERY different it was from anything he knew.

 This is one tendency I’ve noticed in many people who feel they are IT expert or savvy in this part of the world. They readily assume they know what you do, and will often claim they can do it better than you.
I do not doubt that anyone with the right training and time can do what I do. I state that fact clearly in my 10 item code of ethics.
What I do however know is that most of those I have met lack the needed MENTAL discipline to commit the needed time and effort to acquire the needed training to be able to do what I do.
 
And that is what gives me the edge to stay more than one step ahead of them.
For those who learn from me, or who use the apps I build, the article below provides useful insights to help you educate and inform any such persons you may come across.
===========

What is Excel-VB?

What Is Excel-VB?

Microsoft Excel is a powerful tool for recording, re-organising, analysing and presenting information. By Excel VB, I refer to Excel VBA – where VBA means Visual Basic for Applications(VBA). VBA refers to the highly extensive and flexible macro programming language developed by Microsoft for use in their MS office applications – Word, Power Point, etc.

VBA is therefore different from the Standalone Visual Basic program used(by conventional programmers) for developing “standalone” or “executable” (.exe) software applications – though it borrows many of the latter’s features.

Think of Excel VBA as being the standalone Visual Basic software built into Excel for the benefit of Excel users/developers who are not traditional-minded programmers, but who are keen to exert more control over the application to enhance user productivity.

So, Excel VB offers any interested persons the necessary tools to make the application deliver more functionality. The final product is still an Excel document, but with extra functionalities added using VBA..

Continue reading…

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

[True Story] Defying Adversity As a Nobody, to Create a Lucrative Niche Market for my Custom Automated Spreadsheet Software in Nigeria

It all still feels like yesterday – when in 2002 I quit a high paying job as a manager in a corporate multinational, in which I was an established high-flyer, to start offering my custom Excel-VB software development (and Freelance Writing) solutions to paying clients.

Not a few friends, relatives and co-workers thought I’d lost it. Indeed, some co-workers called me “mad” for doing so – as I noted in a past article (click to read) based on feedback reaching me years later.

Today, my achievements speak for themselves (Read my article titled No. 119: How to Achieve Success in Any Field (True Story):

true-story-succeed-in-any-field

I have found a reliable way to get paid what I want, the way I want, for what I do, and I am recognized internationally for it.

So what do I do exactly?

Well, I do several things, as a Location Independent Performance Improvement Specialist and Multipreneur.

However, with regard to Excel-VB software development, I USED to work on client premises, face to face or in person, building a wide range of custom automated spreadsheet applications using Excel-VB programming.

Then in 2012, I moved to providing the same service 100% remotely using the web – and over time used the pattern of client requests I was getting, to settle on key applications I could offer for sale.

As time went on, I discovered it was better to build apps and offer them for sale, instead of looking to get hired by clients to build spreadsheet software.

That decision made me focus my efforts on identifying the best markets/buyer groups to sell to, and I eventually narrowed down to farm business owners as the most serious minded of them all.

Since I did that, I have had NO cause to regret it, as Farm CEOs (from within and outside Africa) continue to respond to the sales offers of my farm business support products. Examples include the Excel-VB Ration Formulator, its accompanying Feed Formulation Handbook, my Excel-VB Poultry Farm Manager and other information products on sale at www.lulu.com/sdaproducts!

But it’s been a long – and difficult – journey, especially to succeeding in selling my Excel-VB software, starting-up from a Nigerian market legendary for software piracy and abuse of intellectual property: a VERY hostile environment indeed!

I have LOTS of true stories to share on the challenges – seen and unseen – that I’ve had to overcome to survive, and ultimately begin to flourish like I do today. It took lots of unconventional thinking and creativity based on painful experiences and deep reflection to find a solution suited to my situation!

For instance, I’ve had employees of clients inform me that their bosses hired “expert” others to try hacking my spreadsheet software. Yep: my own client so badly wanted to avoid paying me call-out fees for maintenance/update of my software, that he invited supposed “experts” from elsewhere to try making the changes he wanted!

And THAT is just one of many examples I tell you.

I have seen – and heard – all sorts. It takes being a Ninja of sorts to function as a provider of creative intellectual solutions in the Nigerian market – especially when it has to do with SOFTWARE!

Apart from worrying about your work being stolen, a more serious challenge is getting paid ENOUGH to make it profitable to practice your software development service as a business.

Now, in my case, as I’ve explained elsewhere, when I started out NO ONE was doing anything remotely resembling offering custom commercial spreadsheet software for sale to individuals or organizations.

I literally created the market for myself as an Excel-Visual Basic for Applications Developer in Nigeria.

What made it easy was the fact that I had enjoyed great success developing business solutions that worked in a world class environment, while working in a large corporate multinational.

The experiences I had while I was there, convinced me that such solutions would be needed by others. It took me time to find them, but I eventually did, and after some years, I narrowed to the most profitable niche to serve.

Several articles I’ve written in the past (see bottom  of this article) feature true stories I’ve narrated, about how my self-taught ability to use spreadsheet programming to solve real life data recording, analysis and report generation for decision making problems in the different departments I worked.

The time, effort and money saving benefits delivered by the custom apps I built, in my spare time as a trainee brewer rapidly earned me a reputation as a problem solver – catching senior management attention at the corporate level.

That eventually led to rapid career advancement opportunities coming my way, so that in less than 6 years I’d earned promotions, and acting assignments at senior management positions well ahead of my peers.

But the workload, and the dreams I had of using my skills to serve a wider and more varied audience made me sure I needed to free myself from the restrictions of a 9 to 5 job.

So, I did my best to prepare for and eventually launch my entry into the world of self-employment.

Today, 15 long years later, my established name/brand recognition and accomplishments speak for me.

I enjoy positive attention from stakeholders in the various markets I serve, for the solutions I provide – especially my custom Excel-VB software development service, as well as my Custom Web Marketing Systems (WMS) Development service.

In case you wonder about the latter (i.e. WMS), it is what empowers me to market the former, in a manner that gets total strangers to send me payment for the growing library of performance improving products and services I offer via TayoSolagbade.com.

In other words, I find and win over buyers for what I sell, by using my unique WMS at low to zero cost. It took me YEARS to develop this system and make it work for me.

That’s why I offer to help clients develop their own unique/custom WMS to sell their own products/services at less cost, in less time and using less effort like I continue to do!

I settled on the WMS strategy after about 8 to 10 years of working face to face and on-site with clients, especially within the Nigerian market, and seeing that I was making less financially and emotionally rewarding progress than I believed was possible.

Indeed I found myself serving clients with my heart and soul, working round the clock like I did on my corporate job, to deliver solutions that worked and saved them money, time and effort – only to end up getting used and dumped, or manipulated one way or another.

There were exceptions i.e clients that treated me with consideration and respect. But they were few and far between.

Most times I found myself unable to reconcile my invested time and effort with the monetary compensation I got from majority of clients I served.

All of this happened despite the fact that I diligently served in line with the 10 item code of ethics I’d found online.

That code of ethics (click to read about it here) made it imperative that I ensure the client’s satisfaction at all times.

But after reflecting on my situation back then – especially after extricating myself from the “grip” of a particularly abusive client, in 2011, I realized that Pierre Le Clerc, who had conceived the original code of ethics I’d adapted for my use, had had a different experience from mine!

It struck me that the elderly Excel-VB Developer based in Canada, who I’d “borrowed” the code of ethics from, had conceived it for a market in which he was assured of a relationship of mutual respect and consideration from majority of his clients.

People tend to behave themselves MORE over there, compared to what happens in Nigeria.

Reflecting on my experiences over more than 8 years (doing business as “CB Solutions”), it was apparent that I could not boast of being in such a market, in Nigeria.

So, I resolved to CREATE for myself, a system that would protect my interests as a provider keen to do what Le Clerc did, without suffering the kind of abuse and exploitation I’d been exposed to in the past.

That decision led me to refine my marketing and solutions development techniques to what I use today, and on which my Web Marketing System is based.

This has enabled me, for over 4 years now, to work 100% remotely via the web, to repeatedly and SUCCESSFULLY deliver my growing library of solutions to a global paying audience.

In other words, I have evolved to a system that makes it possible for me to PLEASE my clients, in a manner that earns me great rewards, of the kind I cherish financially as well as emotionally.

Central to my continuing success has been the diligent use of the 10 item code of ethics I adapted from Pierre Le Clerc’s website – and which I described in yesterday’s post (click to read).

Related Articles

1. Creating Demand for Custom Automated Spreadsheet Software Solutions in Nigeria/Africa (True Story by Tayo K. Solagbade)

2. 1 Hour Talk(No. 5): Proven Strategies for Using MS Excel to Boost Employee and Company Productivity

3. How I Built a Bank Transactions Monitor (BTM) ™Excel-VB Driven App as a Gift for a Client in 2006 [Another Example of Real Life Problem Solving with Excel-VB]

4. Achieve Business Success Using Spreadsheet Data Analysis & Reporting Automation

5. What is Excel-VB?

6. Difference between Visual Basic 6.0 and VBA

7. Get Novice Proof Custom Automated Spreadsheet Software [Hint: From Tayo K. Solagbade – a Multidisciplinary Provider Guided by a Code of Ethics That Protects YOU!]

Get Novice Proof Custom Automated Spreadsheet Software [Hint: From Tayo K. Solagbade – a Multidisciplinary Provider Guided by a Code of Ethics That Protects YOU!]

Today, I enjoy the privilege/benefit of being able to win buyers for my custom Excel-VB driven software from within and outside Africa.

Working 100% online to get found using a unique Web Marketing System I developed for myself, I continue to convince total strangers to send me payment for my custom automated workbook applications.

It’s however been a long – and difficult – journey getting where I am now – especially starting-up a software solutions development business, as a complete NOBODY, in a Nigerian market notorious for reckless software piracy and abuse of intellectual property: a VERY hostile environment indeed.

Yet I did it. Though it took lots of hard work and endurance.

What I did and why I did it, is explained in the special report I will publish on my SD (Self-Development) Multidisciplinary Nuggets blog tomorrow – 3rd March 2017.

Go to www.tinyurl.com/tksxlvbNigeriaStory from 6p.m or 3/3/2017 (That URL will NOT be active until then).

I outline 10 elements of my code of ethics below – noting that anyone, including YOU, can successfully adapt them for use in paid or self-employment/business.

In my case, this code has guided for YEARS me in relating successfully with ALL clients I provide my multidisciplinary range of solutions.

Purpose: I aspire to provide flawless service that will make my clients feel good about investing in me, and even brag to others about what I’ve done for them.

To do the above, I ALWAYS strive to be as flexible – and response – as humanly possible to the needs and circumstances of EACH client – in line with the following code of ethics:

Article 1: The well informed – and profitable – client is always right.

Article 2: If the client is not well informed, I haven’t done my job.

Article 3: The services/products I provide answer to the needs of the client.

Article 4: I don’t do “miracles” and I know when to say “NO”.

Article 5: I haven’t been hired to prove that I am smart, but to be useful.

Article 6: My services/products enable the client master the use of computer and/or Internet technology to run his/her business operations, and not the other way round (i.e. my solutions do NOT overwhelm or intimidate my clients!)

Article 7: If the client feels stupid or thinks I am “God” there is something very wrong going on.

Article 8: What I do, the client could do, if s/he had the time and training.

Article 9: My services/products are public and I have no secrets.

Article 10: When I leave, the client who is interested is empowered.

*Adapted from Code of Ethics developed by Pierre Le Clerc, Excel-VB Developer

tks-xlvb-code-ethics-flyer

Email: tayo at tksola.com

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

Twitter: @tksola

Facebook: www.tayosolagbade.com/fbk

Excel-VB Club: Facebook.com/groups/736287616508718/

Tayo Solagbade | Best Practice Farm Business Support Specialist; Founder of the Excel Heaven Visual Basic Automation Club and Competition; Creator of the 9 Component Customisable Web Marketing System (WMS)

Related Articles

1. [TRUE STORY] He was NOT smiling when we met, face to face, for the first time, today – because of My Excel-VB Poultry Farm Mgr!

2. PII 055: To Succeed Even When Things Go Wrong, You Need Mastery of Your Craft – Part 1 of 2 | Based on a True Story

3. Tayo Solagbade’s Excel-VB Poultry Farm Manager – Video Interview With Lagos Farm CEO After Problem Resolution [PII 055: To Succeed Even When Things Go Wrong, You Need Mastery of Your Craft – Part 2 of 2 | Based on a True Story]

 

PII 055: To Succeed Even When Things Go Wrong, You Need Mastery of Your Craft – Part 1 of 2 | Based on a True Story

Nothing beats being a master of your craft. You need to invest endless time, effort, money and any other necessary resources, to become as proficient as possible at it, so that ANYTIME those you serve demand for your problem solving attention, you will not be found wanting.

It is with regard to my Excel VB Solutions Development that I have narrated the true story featured below, in this week’s issue of my Performance Improvement Ideas newsletter.

Yesterday, Sunday 26th February 2017, between 10:45 a.m. and 3p.m, I spent time with a Lagos based Poultry Farm CEO named Thomas Obuseh. It was the first time we were meeting face to face, in the flesh, since he first made contact with me on phone back in August 2016.

SCROLL DOWN TO READ FULL ISSUE

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

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

Monday 27th February 2017

Logo - Tayo Solagbade's Self-Development Academy


NB: This PI Squared newsletter will be published weekly, on Mondays, in place of the Speaking/Web Marketing IDEAS newsletter, starting from today – 15th February 2016.
I’m reinventing my Monday newsletter content and theme, to accommodate my vision of serving the growing audience of serious minded individuals and organizations reaching out to me, with information, education. news and research findings designed to help them do what they do better.

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

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

PII 055: To Succeed Even When Things Go Wrong, You Need Mastery of Your Craft – Part 1 of 2 | Based on a True Story

Nothing beats being a master of your craft. You need to invest endless time, effort, money and any other necessary resources, to become as proficient as possible at it, so that ANYTIME those you serve demand for your problem solving attention, you will not be found wanting.

It is with regard to my Excel VB Solutions Development that I have narrated the true story featured below, in this week’s issue of my Performance Improvement Ideas newsletter.

Yesterday, Sunday 26th February 2017, between 10:45 a.m. and 3p.m, I spent time with a Lagos based Poultry Farm CEO named Thomas Obuseh. It was the first time we were meeting face to face, in the flesh, since he first made contact with me on phone back in August 2016.

tom-pre-solution-thb

I’d made him an offer then which he’d not taken up. Then he’d returned last Tuesday, on 20th February 2017 – calling in at about 8a.m in the morning. About 24 hours later, he’d made payment to take up a new offer I made to him.

In my usual manner, I proceeded to use details he supplied to me about himself and his farm business, to personalize the PFM and accompanying products, which I emailed to him.

I could however never have predicted what happened over the next four days.

The drama began with Tom writing in to say he’d been unable to launch the spreadsheet app, because each time he tried to do so, it returned a “Compile error”.

Past experience with other users who’d initially struggled, made me ask if he was using a computer running a Mac OS. He sent me – in response to my request – screenshots of his PC’s specs as well as that of the error message returned by the app. I noted he was using a 64 bit HP ProBook – so the Mac issue was ruled out.

Long story short, my mind went to the possibility of a 32-bit vs 64-bit conflict. But I had problems accepting that possibility because not only had I successfully run the app on 64 bit computers myself, but I had also seen others do the same – including the manager of a neighborhood café I use.

So, I had a dilemma. In the past, I’d had to follow tips provided on the Microsoft website to adviSe a client in 2014, to step down his Excel version from 64 bit to 32 bit via custom install from the disk.

He’d reported getting a different error message – shown below – from that seen by Thompson:

“Microsoft Forms… Could not load an object because it is not available on this machine”

The problem I had in Tom’s case was however that all he got was a “Compile error” message, so I could not make much of it. I needed more information, and I knew the best/quickest way would likely be to interact directly with the computer on which this was happening.

At a point, Tom wrote an email saying he believed my app did not work – and he challenged me to prove that it did by getting it to work on HIS own laptop!

I replied that I had told him there were other clients who used the app. I told him my suspicion was that his was a unique/peculiar problem that was NOT general to others.

After some heated debates on phone and email, I decided to invite him to meet with me, so I could address the problem he was having. Luckily, this was made easy by the fact that he lived in Lagos, and I was also in town.

By the time we met at Omole Estate Phase 2, I promptly removed the password protection from the Visual Basic Editor. Then I ran the Workbook Open procedure again, with the password removed.

This resulted in more descriptive information being added to the error message that appeared.

Compile error:

The code in this project must be updated for use on 64-bit systems.

Please review and update Declare statements and then mark them with the PtrSafe attribute.

Once I saw that, I immediately knew what the problem was, and what I needed to do. It was the modules in which I’d used Windows API calls that contained the  lines of code throwing the error.

I promptly made modifications to the code modules in a way that enabled the app launch fully to the login screen – and beyond. When this happened, Tom’s face lit up. It was the first time since he purchased the app, that he was seeing it working like I’d demonstrated it in the video he’d watched, in deciding to buy it.

While I worked, I deliberately engaged him in conversation and learned from Tom that he worked as a Network Administrator on a 9 to 5 job, and that his laptop was always plugged into the corporate network where daily automatic updates happened to the laptop’s Windows and Office installations.

On hearing that, I told him that updates downloaded to a computer on a corporate network would be designed to minimize chances of unauthorized application being run without restrictions on it.

An Excel-VB app like mine, meant for private use by the owner, when run on that kind of laptop would likely encounter restrictions I may not have provided for.

Note here, that Excel-VB code has been used to create harmful virus applications that cause major damage in the past.

When I made this point, Tom nodded in agreement, and went on to add that he estimated there was a 1 in 50 chance that I would encounter a user with his kind of situation – to which I exclaimed saying; “Now, you see what I meant when I said yours was a peculiar situation!”

We went on to spend over 2 hours looking through the various data entry and reporting interfaces in the app, as I gave him practical tips on how to use it.

At the same time, I also shared real life examples of how to make use of the app to monitor and manage farm operations to ensure timely decision making for optimal performance.

We ended by agreeing to work via email, as I proceed to make the remaining needed changes in the code module declarations by adding the PtrSafe attribute highlighted in the error message.

For now, he’s able to commence posting of farm data from paper records prepared by his farm hands.

By the time we parted, we’d shared a lot of banter, and he even arranged for me to converse, in French, with his wife, who works as a French Language Instructor with a Lagos based institution.

Before he drove off, I got him to take a photo with me and also recorded a testimonial video of him sharing his feelings and observations about what had been done, and the experience he’d had using the app, in the few hours he’d begin using it.

me-tom-post-solution

At the risk of stating the obvious, it was my confidence in my Excel-VB coding ability that made me invite Tom to come down with his laptop, so I could fix the problem once and for all.

Indeed, I actually made upfront payment to his bank account to cover to/fro fueling of his car for that purpose. That was how determined I was to solve the problem – and prove that my app worked!

I have been selling my Excel-VB Poultry Farm Manager (PFM) since 2009. I began selling my Excel-VB Ration Formulator software in 2004.

Over the years, I’ve had Farm C.E.Os. from within and outside Africa, by from me – but majority of my buyers continue to come from within Africa, and especially Nigeria, my home country.

The point to note however is that I CULTIVATE and ENJOY healthy relationships with my buyers long AFTER they buy from me.

Some buyers initially need my help to identify why they had issues, but I have NEVER needed to change my code to get it to work!

This experience with Tom, is one that has enabled me demonstrate in a new way, that I deliver on my promises and practice what I preach.

THAT is what I do: I SOLVE problems for those who connect with me, using the solutions I develop. And if a buyer encounters difficulties in trying to make use of my solutions, I ALWAYS adopt a POSITIVE MENTAL ATTITUDE to SOLVE whatever challenge s/he may be faced with.

The above is what I successfully DID today, with the Lagos based Farm CEO shown with me in this above shown photo taken just before we parted AFTER our meeting.

If you make mastering your craft a deeply ingrained habit, like I do, you WILL also be able to succeed in spite of setbacks or problems you encounter in your practice of it!

PS: Tomorrow, in the 2nd and concluding part of this article, I will feature the video testimonial by Tom.

tom-vid

sdn-pre-flyer

Excel-VB Driven Ration Formulator

Click to view larger screenshot

1. Click here to learn more about this app – watch demo videos etc

2. Click here to watch a 4 part video in which I demonstrate how to use this app to formulate rations using real life data sent to me by an Algerian PhD student.

Click here to contact me about purchasing this product.

EXCEL-VB DRIVEN POULTRY LAYER FARM MANAGER SOFTWARE

Click here to download a detailed PDF user guide and watch 15 screen shot user guide tutorials of the Monthly Poultry Farm Manager that I now offer Farm CEOs.

Click here to watch a screenshot demonstration of the Excel-VB Driven Poultry Farm Manager I built for a client farm business in Ekiti state, South West Nigeria.

Click here to contact me about purchasing this product.

SDN Blog™

New posts from last week*

Monday:

[Wednesday]:

[Thursday]:

Download the “PRACTICAL LIVESTOCK FEED FORMULATION HANDBOOK” – BY TAYO SOLAGBADE, Best Practice Farm Business Support Specialist

N/A

[Saturday]:

The FARM CEO (Issue 75): Top 11 Articles on Best Practice Farm Business Management for Profit – by Tayo K. Solagbade, Best Practice Farm Business Support Specialist & Founder of the Farm Business Support Centre

[Sunday]:

[TRUE STORY] He was NOT smiling when we met, face to face, for the first time, today – because of My Excel-VB Poultry Farm Mgr!

Tayo K. Solagbade*

Self-Development/Performance Improvement Specialist

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

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

http://www.tayosolagbade.com

Tayo K. Solagbade is a Location Independent Performance Improvement

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

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

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

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

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

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

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

In a previous life, before leaving to become self-employed, Tayo served for seven years (October 1994 to December 2001) as a high performing manager in Guinness Nigeria. He rose from Shift Brewer to Training & Technical Development Manager, and later acted in senior roles as Production Manager and Technical Manager.

In addition to constantly challenging the status quo and influencing positive work changes, he built a reputation for using self-taught spreadsheet programming skills (starting with Lotus 1-2-3, and later moving to Excel Visual Basic) – in his spare time – to develop Automated Spreadsheet Applications to computerize manual report generation processes in the departments he worked. Over four(4) of his applications were adopted for brewery level reporting.

Tayo holds a B.Sc degree in Agricultural Extension Services from the University of Ibadan, Nigeria, having graduated top of his class – with Second Class Upper Division honors – in 1992. He is an Associate Member of the UK Institute & Guild of Brewing, a 1997 National Finalist of the Nigerian Institute of Management’s(NIM) Young Managers’ competition, a Certified Psychometric Test Administrator for Psytech UK, innovator of Spontaneous Coaching for Self-Development™ (SCfS-D™), and Founder of the Self-Development Academy (SDAc).

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

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

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

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

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

Within a few days however, Tayo used his advanced self-taught web development skills to build a SUPERIOR “reincarnation” of it the website http://www.tayosolagbade.com.

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

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

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

Here’s an article Tayo wrote, to inspire others to defy adversity, and bounce back to even greater reckoning at what they do EVERY time:

Succeed by Emerging from Adversity Like a Phoenix

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

And he wrote the one below, to explain why losing a domain name, no matter how old, NO LONGER determines your online success or otherwise:

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

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

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

PII 054: Boost Your Success Achievement Using These 4 Services

This week’s issue of my Performance Improvement Ideas (PII) newsletter is a special broadcast edition that announces four (4) key Performance Improvement Solutions I offer via www.tayosolagbade.com, www.thefarmceo.net, and www.excelheaven.biz.

My achievements and reputation speak for me. I keep promises I make to EVERY client. If you want reliable expert support to Boost Your Success Achievement, consider taking up these solutions I offer!

SCROLL DOWN TO READ FULL ISSUE

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

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

Monday 20th February 2017

Logo - Tayo Solagbade's Self-Development Academy


NB: This PI Squared newsletter will be published weekly, on Mondays, in place of the Speaking/Web Marketing IDEAS newsletter, starting from today – 15th February 2016.
I’m reinventing my Monday newsletter content and theme, to accommodate my vision of serving the growing audience of serious minded individuals and organizations reaching out to me, with information, education. news and research findings designed to help them do what they do better.

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

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

PII 054: Boost Your Success Achievement Using These 4 Services

This week’s issue of my Performance Improvement Ideas (PII) newsletter is a special broadcast edition that announces four (4) key Performance Improvement Solutions I offer via www.tayosolagbade.com, www.thefarmceo.net, and www.excelheaven.biz.

My achievements and reputation speak for me. I keep promises I make to EVERY client. If you want reliable expert support to Boost Your Success Achievement, consider taking up these solutions I offer!

1. PUBLISH YOUR BOOK AT ZERO COST

As an expert in your field, you would greatly boost your market place credibility by writing & publishing one or more book(s) sharing your knowledge and insights about your area of expertise. There is an internationally proven way to do this AT ZERO COST. I discovered how in 2005. Today, my books can be purchased in hard copy at www.lulu.com/sdaproducts .

(NB: I also offer a book writing service. Call 234-803-302-1263 or +229-66-122-136. Visit http://tayosolagbade.com/pod-letter.html)

“Infact, there is the greater likelihood of the success of export drive involving our cultural products and talents than one involving our outstandingly shoddy manufactures and primary produce nobody wants. The only problem is : our writers and artistes have to think like business (people). They have to learn to study the international marketplace and woo it with skill & subtlety” – Sina Odugbemi (SOURCE: Article titled “Why Writers Are Poor (part 2)”. Subtitle: “A critical look at the economic status of writers in the contemporary society” – published in Newswatch magazine, January 2, 1989 page 38

2. ORDER A WEB MARKETING SYSTEM

I help clients develop and implement custom web marketing systems to make their websites get found by potential clients without their having to spend ANY money. Click the link below to view a PDF flyer (wms_talk_offer.pdf) I use to introduce and explain key benefits a Web Marketing System can deliver to its owner – IF well conceived and implemented.

http://tayosolagbade.com/uploads/wms_talk_offer.pdf

“Unless the person running your marketing is patient, it will be difficult to practice commitment. View marketing as an investment, be consistent, and make prospects confident. Patience is a guerrila virtue.” – Jay Conrad Levinson in “The 15 Secrets of Guerrilla Marketing”

3. BUILT-IN EXCEL SOLUTIONS DEVELOPMENT

Self-Development Academy’s Excel Heaven™ is the FIRST provider of Preprogrammed and Custom Spreadsheet based solutions in Nigeria. We offer Workbook Auditing/Optimisation and VBA Automation; Custom Spreadsheet Software Development; Sales; Job-Based Spreadsheet Coaching; and Consulting/Advisory Services on effective application of spreadsheets for business use.Call 234-803-302-1263. See video demos at http://www.youtube.com/user/TKSolagbadeSDAc

Visit our Excel Heaven mini-site at : http://www.excelheaven.tayosolagbade.com or http://www.excelheaven,biz

4. COST-SAVING FARM BUSINESS (BEST PRACTICE) SUPPORT SERVICES

SDAc’s Cost-Saving Farm Business Ideas mini site offers custom best practice farm management systems (and software) development at affordable rates to farm business owners in Nigeria/Africa. This is a new, unconventional, but practical approach to provision of Modern Extension Services for farm businesses in this part of the world.

I work with crop and/or livestock farmers to develop and implement intelligent decision making systems that help their farm businesses become more efficient and profitable, through low cost adaptation of technology, while building on indigenous knowledge systems.

Visit the mini-site at : http://www.iff.tayosolagbade.com

Also subscribe to Weekly Newspaper – The Farm CEO™ at www.thefarmceo.net

Excel-VB Driven Ration Formulator

Click to view larger screenshot

1. Click here to learn more about this app – watch demo videos etc

2. Click here to watch a 4 part video in which I demonstrate how to use this app to formulate rations using real life data sent to me by an Algerian PhD student.

Click here to contact me about purchasing this product.

EXCEL-VB DRIVEN POULTRY LAYER FARM MANAGER SOFTWARE

Click here to download a detailed PDF user guide and watch 15 screen shot user guide tutorials of the Monthly Poultry Farm Manager that I now offer Farm CEOs.

Click here to watch a screenshot demonstration of the Excel-VB Driven Poultry Farm Manager I built for a client farm business in Ekiti state, South West Nigeria.

Click here to contact me about purchasing this product.

SDN Blog™

New posts from last week*

Monday:

[Wednesday]:

[Thursday]:

Your Mental Attitude Can Help You Develop Street Wisdom Needed to Safely and Profitably Navigate Shark Infested Waters of Business

[Friday]:

N/A

[Saturday]:

N/A

[Sunday]:

Protected: The FARM CEO (Issue 74) : SMART SKILLS FOR SMALLHOLDER FARMERS, ORGANIC AFRICAN FARM, Buhle Farmers’ Academy

What You Need to Create a Splashscreen for Your Custom Spreadsheet Application [Part 1 of 2]

Tayo K. Solagbade*

Self-Development/Performance Improvement Specialist

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

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

http://www.tayosolagbade.com

Tayo K. Solagbade is a Location Independent Performance Improvement

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

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

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

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

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

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

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

In a previous life, before leaving to become self-employed, Tayo served for seven years (October 1994 to December 2001) as a high performing manager in Guinness Nigeria. He rose from Shift Brewer to Training & Technical Development Manager, and later acted in senior roles as Production Manager and Technical Manager.

In addition to constantly challenging the status quo and influencing positive work changes, he built a reputation for using self-taught spreadsheet programming skills (starting with Lotus 1-2-3, and later moving to Excel Visual Basic) – in his spare time – to develop Automated Spreadsheet Applications to computerize manual report generation processes in the departments he worked. Over four(4) of his applications were adopted for brewery level reporting.

Tayo holds a B.Sc degree in Agricultural Extension Services from the University of Ibadan, Nigeria, having graduated top of his class – with Second Class Upper Division honors – in 1992. He is an Associate Member of the UK Institute & Guild of Brewing, a 1997 National Finalist of the Nigerian Institute of Management’s(NIM) Young Managers’ competition, a Certified Psychometric Test Administrator for Psytech UK, innovator of Spontaneous Coaching for Self-Development™ (SCfS-D™), and Founder of the Self-Development Academy (SDAc).

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

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

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

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

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

Within a few days however, Tayo used his advanced self-taught web development skills to build a SUPERIOR “reincarnation” of it the website http://www.tayosolagbade.com.

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

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

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

Here’s an article Tayo wrote, to inspire others to defy adversity, and bounce back to even greater reckoning at what they do EVERY time:

Succeed by Emerging from Adversity Like a Phoenix

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

And he wrote the one below, to explain why losing a domain name, no matter how old, NO LONGER determines your online success or otherwise:

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

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

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

2016 Excel-Visual Basic Automation Club Home Study Tutorial Archives DVD [COMING SOON]

It feels just like yesterday, that I hosted the Maiden Edition of my FREE Monthly Workshop for members of my MS Excel Heaven Visual Basic Automation Club on Sat 19th March 2016 in Lagos-Nigeria.

Since then I have diligently churned out weekly Videos, Workbooks and Articles on various aspects of basic Excel-VB programming with a focus on work related experiences of members.

To celebrate the first year anniversary of the launch of this Excel-VB Automation learning event, I’m compiling ALL the content for the various tutorials, into a special branded DVD (screenshots below)

1. Autorun display image for the DVD menu

2016-tutorial-archive-dvd

2. Branded label for the autorun DVD itself

cdlabel

It will be made available to members as they renew their individual club memberships for another year.

This DVD is useful because I know it can be difficult to keep track of stuff that one downloads and studies over time, via the web. This archives DVD enables you access all that useful information on ONE location, for study at your convenience, without needing to incur expenses accessing the web etc.

Click here to request details of how you can get YOUR copy.

Read PII 006: Succeed by Becoming an Expert at Solving Real World Problems [Hint: Highlights from Maiden Edition of Tayo Solagbade’s FREE Monthly Workshop for his MS Excel Heaven Visual Basic Automation Club Members Held on Sat 19th March 2016 in Lagos-Nigeria]

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

This week I refer members of my Excel Heaven Visual Basic Automation Club to an excellent article (by By Jorge A. Gomez) that discusses key VBA programming terms that one needs to understand, in order to succeed in developing useful VBA applications.

Like I continue to emphasize to my club members, I believe in exposing those learning from me (via the home study tutorials I send them) to the work of as many other competent experts as I can find, so they get the benefit of insights from a wide variety of perspectives.

This, in my experience will boost their abilities to develop flexibility in their creativity, when developing their own unique solutions for clients.

My success in developing a unique range of custom Excel-VB software that I sell for passive income, to buyers within and outside Africa derives from my own exposure to similar influences.

Excel VBA Tutorial For Beginners: 16 Essential Terms You Must Know To Learn VBA Programming

So you’ve created your first (or your first few) Excel macro(s), perhaps by following these 7 easy steps to create a macro. By now, your colleagues are already looking at you like you’re a wizard.That is a great sign that you’re on a good way to learning macros and Visual Basic for Applications (VBA).

However…

Being able to create a basic macro in Excel is only the beginning in the process to become a really efficient and productive user of macros and VBA. If you really want to unleash the power of these tools, you must learn VBA due to the fact that, among others, recording a macro sometimes simply doesn’t “cut it”.

https://powerspreadsheets.com/excel-vba-tutorial-essential-terms/

One New Skill Modern Extension Professionals Need to Succeed

Findings from a 2013 questionnaire survey I conducted of Farm CEOs in Nigeria, for an international agribusiness paper I was engaged to write revealed 55.6% bought commercial feed (from “2 sources” or “anywhere they can find”).

66.7% of that percentage said their animals’ performances varied noticeably with different sources of feed.

Their farm output tended to fluctuate as a result – and that naturally bothered the CEOs.

Hen Day Percentage (HDP) data auto-charted – in September 2013 – using my Excel- VB Poultry Farm Manager software on a layers farm in South West Nigeria suggested the trend noticed from the survey was accurate.

layers-kpi-charts-1-1024x640

When the two farm managers were asked about a sharp downward slope of charted HDP data, over a one week period (from above 70% to between 55 and 65%), their checks revealed it coincided with their use – due to cash flow problems – of feed from a different supplier!

Customizable Excel-VB driven tools can help such farmers consistently formulate their own feed to specification.

More predictable livestock performance and reduced feeding expenses will occur, and ultimately lead to increased profits. See study’s full survey results in the PDF paper – click here to learn how you can get a FREE copy.

Excel-savvy extension workers can be selected to attend practical Excel-VB training – with deliberate focus on real-life farm solutions development.

It’s not likely that farm CEOs will be able to find the time to learn MS Excel Automation – even though it’s obvious that they readily embrace the flexible, and affordable Excel based solutions that can be had.

This is why I have continued to argue through my writing on Best Practice Farm Business Management, that Extension Professionals will be best placed to deliver the customizable low cost data handling and report generation solutions to farm businesses using MS Excel VBA.

In the agribusiness paper on this subject, I made the following suggestions about what extension workers need to do, to develop this valuable competence, so they can become better able to help Farm CEOs:

1. Each must have sound understanding of feed formulation science

2. Classes and useful text for self-study should be provided for those lacking – and their competence verified.

3. Next, they either learn Excel-VB programming – or engage someone who does. If the latter, we recommend they still learn some Excel-VB, so they can modify the software in future.

4. Step-by-step instructions (with annotated screenshots) should be provided for farmer-users.

5. Tools: PCs, preferably laptops, since battery power makes work possible in absence of continuous power. In Nigeria, where power supply is unreliable, this is important. A farmer may not initially be keen to put on his/her generator, just to see new feed formulation software!

6. Solutions developed must be adapted to suit MS Excel versions on farmers’ PCs. One client refused to replace his Excel 2003 with 2010 version because it looked so different. My Ration Formulator™ is built to be compatible with old and new/future MS Excel versions.

7. Encourage Farmers to Develop Indigenous Knowledge Systems: Years of supporting farm CEOs has revealed one fact: Smallholder farmers are keen to collaborate with “developers” of low cost “easy-to-use” software that can help them.

A phone conversation I had with a Canada based Farm Project Manager – Ronald V. – on 14th November 2013 is instructive with regard to the last point mentioned above.

vba-extension-solution

He’d bought my Ration Formulator via Paypal (sent to my brother-in-law in the UK) some weeks earlier. Findings from a USA university’s study had led him to adopt peas usage in rations fed to pigs that made replacement of Soya bean possible, with no apparent negative impact on performance.

His nutritionist had advised using Soya beans in a feed formulation application built for pigs. But the need to reduce variable costs drove him to test the university’s model. He replaced the data for Soya beans he’d posted in my app, with that for peas. Months after, he was still getting good results!

He ended the call by suggesting my Excel-VB app featured be modified to cater for pigs as well (with regard to their elaborate amino acids balancing needs).

That “suggestion” from him, is a good example of how farm business solutions can evolve based on user feedback for a while, before their features can be considered adequate for most possible scenarios.

My interactions with another farm CEO, this time in Africa, provides another useful illustration:

In Nigeria, an Ibadan, Oyo State – Nigeria based catfish farm owner I spoke with on phone, in the course of gathering information for my paper, explained that he regularly explores use of alternative ingredients.

After careful laboratory analyses, he hads found a way to use noodles waste, and cassava flour (known locally as “Gari”) up to 40% in formulated rations, to reduce the farm’s feeding costs.

According to him, the performance of his fish had not suffered.

Summary: Extension specialists can develop cost-effective customizable Excel-VB solutions to help farmers tackle pressing challenges they face

Discoveries that occur in the process – like those mentioned in the anecdotes narrated above – when shared, can convince other farmers to also adopt the superior Excel solutions.

That’s one of the ways my featured Excel-VB driven Ration Formulator™, and its Excel-VB Poultry Farm Manager™ sibling have been successfully introduced and sold, to Farm CEOs within and outside Africa, over the years.

It is my considered opinion that other extension professionals can do what I’m doing – and the farm business industries we serve, will be better off in the long run!

Related Article: Story: After Resolving Layers Feeding Problems, Selling Increased Eggs Output Became a Headache!