Close Window

"Everybody knows some Excel, but stop seeing Excel as an office program that everybody MASTERS and that is used to organize numbers in columns and make a few calculations. Excel is the best reporting application on the market and it is fully programmable with its own PROGRAMMING LANGUAGE within called VBA"
- Pierre LeClerc PLI Consulting Inc

5 Reasons To Justify Hiring CB Solutions To Build A Low Cost Excel Software For You.

1. You realise you can SAVE a lot of MONEY by using the software to automate aspects of your work.

2. You know how much MONEY/TIME/EFFORT it is currently COSTING you/others to work without it.

3. You have checked the cost of an alternative software type and found it prohibitive.

4. You discovered off-the-shelf software do NOT allow enough customisation to meet your unique needs.

5. You tried to build a software by yourself but did not have the time, training or resources to finish it.

Click HERE NOW to tell me your Custom Software Development Need.

BE A MS EXCEL POWER USER™ !
"Companies have paid me up to N200,000 (i.e Two Hundred Thousand Naira – Proof Available) to build custom bullet proof Excel-VB driven software for them. Learn MS Excel and/or VBA Programming from me & start winning the respect/admiration of others by EXCELLING with spreadsheets & helping THEM do same!
" - Tayo K. Solagbade

Learn More About My Experiential(Job-Based) Coaching - Click HERE


HAVING EXCEL PROBLEMS?
MS Excel is a powerful tool. Every once in a while however, we all encounter problems in using it. Are you having any difficulties with a particular workbook or worksheet? Would you like "another pair of eyes" to look at it?(Be sure to replace sensitive data with dummy values!)

Just Click HERE to zip and upload the workbook with details of the problem to me, and I just might have the answer!

 

Close Window
You are at Tayo Solagbade's Excel Heaven mini-site: www.excelheaven.spontaneousdevelopment.com  
 
Excel 2000 Upwards Compatibility Assurance Seal
Version Dependency: Most applications built pre-2007 offered for download on this site were developed using Excel 2003, and will run on Excel 2002/XP but NOT on Excel 2000. Any post-2006 software built for clients or offered to visitors on this site WILL run on Excel 2000!

WATCH VIDEO DEMONSTRATION - CLICK HERE!

"(The Church Records & Accounts Manager has) really helped me in the preparation of my monthly Accounts..(CB Solutions' service is okay. The personnel is always on ground whenever you call him and solution to problem is (provided) without delay or alteration of data"- Adebisi Folayan Finance & Admin Manager, Anglican Church Of The Ascension, Opebi, Lagos. More...

"(The General Accounts Manager) has been a tremendous improvement in our weekly and monthly report.. my Medical Director expressed his happiness when he saw the report...Mr Tayo, I am impressed by your talent, you're thorough in your job, sincere and friendly with your client. Keep it up." - Rev. Mfon Inyang, Manager-Accounts, Med-In Specialist Hospital & pharmaceutical Company, Ogudu, Lagos. More...


"Preparation of staff salary has now been reduced from days to just two days. (The Paysl;ip Generator) has helped me a lot...I really commend the CB Solutions* for (an) excellent job. It has solved my organisation's accounting problem. More grease to your elbow." - Adeniyi S. Elegbede, Accountant Motayo Hospital, Ikeja, Lagos. More...

Business Contacts
Manager

Learn how you can get your own copy of my Personal/Business Contacts Manager - Click now

Discard bulky cardholders & STILL have access to ALL your business/personal contacts data in ONE place!

Learn more here...


Automated Cash Book

Click to view larger image(Press F11 to zoom closer)

Built - so far in 2007 - for two large hospitals(and a hotel in 2006) in Lagos. Allows user to post receipt (cash, cheque. value card etc) and payment amounts into spreadsheet tables using automated data entry forms. Automatically generates Monthly/Yearly Summaries, trial balance in ready to print formats. 100% customisable.

Learn more here...


Click HERE now to view a larger version of this report's cover
 

 

 
A Hospital Orders An Automated Excel Cash(& Expense Analysis) Book
Home | Stories | Building An Automated Cash Book
 
The Story: September 2006, I walked into the reception area of a large Lagos hospital, and requested to speak with the accountant. The receptionist called him up on the intercom and passed the handset to me. Using my elevator speech, I explained that I provide MS Excel automation services to help business users get their work done with AT LEAST 75% less effort and in AT LEAST 75% less time than they could using conventional methods, giving examples of other clients I had worked for.

After a few questions, he asked me to pass the phone to the receptionist, and told her to send me to his office in the hospital penthouse at the top floor. The meeting lasted just over 15 minutes. He was really business-like. I had hit on his VERY exposed "felt-need" nerve. He asked to see the demos of past projects I mentioned. I showed him the "Cash Inflow & Outflow Tracker" I built for business centers and the "Restaurant & Bar Manager". Those two were apparently enough to convince him.

Next thing I knew, he took me to a computer used by his assistant, and called up what turned out to be a number of manual MS Excel workbooks used to manage their Cash Books for various purposes (tracking receipts and payments for the main hospital, and also movements to/from the different bank accounts). He told me he felt - from looking at what I had already done - that I would be able to help them automate their manual Excel Cash books to make them (as his Medical Director would later say) "more friendly".

"So how much will it cost?" he asked(a question that often tells me the prospect is to be taken seriously). I told him. We negotiated and came to a compromise. Then he ended the meeting by asking me to send in my proposal with a quote. I did that a day later, and went on to other business marketing tasks with other prospects.

I did NOT hear from him for nearly two months subsequently.

Some weeks after my last meeting with the accountant, my other marketing efforts led me to win a project to build an automated records management system for a hotel, which involved working with the hotel account and the auditor to build an automated Cash Book that generated a trial balance etc.

As I approached completion of the hotel project, I called the Hospital accountant to inform him that I had since gone on to build an automated cash book for another client. (I often do this to help clients move closer to taking the decision to buy, as it gives them more verifiable PROOF to assure themselves that I can deliver a solution that meets their needs). He told me they had someone who was working on an alternative, and as such he would only call on me if the alternative did not work. I thanked him and ended the call.

Three weeks later, I got a call from him on my mobile. He said "Mr Solagbade, this is..... from .....hospital. We want you to come and build the automated cash book we discussed about. When can you come and pick up your cheque?"

I went on to build a fairly different type of cash book from that used by the hotel, to match the format used by the hospital's accounts department. But the logic was still the same, so I was quite at home with it.

Note: On 5th Feb. 2007, I won a much larger paid project with another Lagos hospital by using the above cash book for my business marketing demo to them. I was engaged within days after my first meeting/demonstration to build a custom automated Excel-based software to handle this hospital's general accounts preparation from cash office receipts to year-end Profit and Loss reports/balance sheet auto-generation.

How The Auto-Cash Book Works: Click here to read though the browser based user guide I created for users of the hospital's cash book. It provides screen shots of various parts of the program to facilitate comprehension. You can fill/submit a request to download - and test run - a demo version of the program.


Article Update: On 12th March 2007, I got a call from the accountant of another large hospital to pick up a 100% advance payment cheque to build an automated cash book(and a Payslip Generator) for his department. This made it the third time in 2007 that I would be asked to build this kind of application for a hospital here in Lagos. Each time I have used the more recent version to "sell" my services to the next prospective client.

Tayo K. Solagbade - 7th April 2007

Back to Stories Index


Google
Web www.spontaneousdevelopment.com
 
Learn How I Can Help You
Learn about Excel Solutions I developed to solved real-life problems for clients(individuals & businesses)
Buy XL Software
Download sample XL Software
Get a 100% Customisable Excel software solution developed to meet your needs
Learn  about my personal or small group Experiential(Job Based) Coaching
Contact Me
Read my FREE Articles & Tutorials
Upload your workbook automation request

Income & Expense Manager

Click now to fill/submit a request form to download a demo version of the program and a screenshot tutorial

Built to help Biz Center owners know if they are really making PROFITS - but useful for anyone keen to track income + expenses. Easy to learn & use - even by a PC novice. Allows data entry at 60 rows per day for 365 days. Automatically computes daily, weekly, monthly, annual (tabulated, charted, and printable) summaries of income, expenses etc

Request download link..


Automated Invoice Generator

Click now to fill/submit a request form to download a demo version of the program and a screenshot tutorial

Quickly and conveniently prepare professional looking Invoices & Delivery Notes for clients. Select item(s) from drop menus, watch program auto-insert prices, quantities and compute totals, VAT etc. It even writes the EXACT Amount Due in Words.

Request download link..


General Accounts Manager

Click to view larger image(Press F11 to zoom closer)

Built for a specialist hospital in Lagos. Allows user to post cash office receipt using in-house format register (cash, cheque. value card etc) and payment amounts using custom floating data entry forms. Automatically generates Weekly, Monthly/Annual Income & Expense Report - integrated with charts of EACH heading value. Dynamic report preparation interface with drop menus. View larger screenshot here...

WATCH VIDEO DEMONSTRATION - CLICK HERE!

An Excel-VB Software To Formulate Balanced Feed For Your Farm Animals

Screenshot of printable one-page ration formulation report(includes a pearsion square computation outcome) auto-generated by the software. Click to take a closer look. Screenshot of the floating data entry form interface provided in the software. The user will find this interface intuitive and convenient to use when trying out different combinations of feed ingredients in formulating rations for different farm animals. Click to take a closer look.
Many visitors to my Integrated Fish Farm site have already downloaded the Acrobat PDF E-book version of my 70 page Practical Livestock Feed Formulation Handbook. I have since gone further to build an automated ration formulation application (view entry form and pearson square computation results page). This 100% customisable software makes the process of calculating quantities of various ingredients to make a balanced ration quicker, easier and more accurate. Click here to view software screenshots...

Get this automated feed formulation software FREE by taking advantage of a huge discount to buy the Practical Feed Formulation Handbook and three (3) other very useful Self-Help Books!

How I can help you Order a Custom Excel Software/Solution Contact Me