If you're new here, you may want to subscribe to my RSS feed. Thanks for visiting!
ARGH…CONNECTIVITY BLUES/WOES!!!
Due to seriously poor connectivity speeds (which have been that way ALL week, but got worse this weekend), I’ve been unable to upload the video tutorial for this week up till about an hour ago (I could not even get my emails open)!
I began going at it from 6p.m yesterday Sunday 2nd July 2017 and it got no better till past midnight. So I decided to try again from 6a.m – just got it done at 6.30a.m lol!!
Tayo
Part 2 – How I Built My Automated Cash Book/Bank Reconciliation Software” [One Key Ingredient You Need for Successful Spreadsheet Software Development]
This week, in part 2 of the step-by-step video tutorial…..I explain why successful development of your automated cash book (or indeed virtually any other real world relevant app) will often depend greatly on the existence, or establishment of a functional paper based records keeping system.
In the case of the automated cash book, that paper based system would, at the minimum, be an easy to use book keeping system.
It is what you will then use as a basis for designing the data entry and report generation interfaces in your custom Excel-VB app.
Apart from the fact that this approach ensures that your app’s design ends up being intuitive to use for the user/clients, another benefit that can accrue to you is that you will be able to use the paper based system to DOUBLE CHECK the accuracy of output you get from the app, and vice versa.
As a result, you end up with a system that boosts your ability to detect errors, since the summaries, and other parameters computed MUST always agree.
Therefore anytime the user notices they do NOT yield the same output, in any areas, s/he will know to quickly identify the cause and rectify it, so that a wrong report is NOT sent out leading to wrong interpretations being made and incorrect decisions being taken based on that.
This is important for you to keep in mind as you develop applications: You have a responsibility to make sure your app does NOT endanger the client and/or the business s/he runs by giving misleading output!
Next week, I will send you a step-by-step video recording of how to build the Imprest cash book interface in the app.
Related Article
Posted on 3 July 2017
Tags: EXCEL HEAVFN TUTORIAL, One Key Ingredient You Need for Successful Spreadsheet Software Development, Part 2 - How I Built My Automated Cash Book/Bank Reconciliation Software"
About the Author
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 organisations with personal development training and coaching, custom MS Excel-VB solutions, web marketing systems, freelance writing services, and best practice extension support services (for farm business owners).
Tayo is the author of the Self-Development (SD) Bible™, the popular Livestock Feed Formulation Handbook, and developer of its accompanying Excel-VB driven Ration Formulator - as well as the increasingly popular Monthly Poultry Farm Manager app.
On 1st April 2013, Tayo (who reads, writes and speaks the French language) relocated to Cotonou, in the French Speaking Benin Republic on the first lap of his slow travels 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).
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 previews of paid issues of The Farm CEO™ Newspaper (www.thefarmceo.net), in addition to his FREE Weekly Public Speaking/Web Marketing IDEAS newsletter - which he uses to promote Burt Dubin's Public Speaking Mentoring service to experts across the African continent.
Visit Tayo's Flagship Performance Improvement website to download over 10 performance improvement resources to boost your personal and work related productivity.
Join Tayo's international community of fans on his Flagship MS Excel Heaven Facebook page (click here). You can also connect with him via Twitter (@tksola).
Warning: count(): Parameter must be an array or an object that implements Countable in /home1/tayoswdg/public_html/sdnuggets/wp-includes/class-wp-comment-query.php on line 399