Below: Some screen shot from the fully functional Excel-VB driven Election Results Compiler Workbook application

Screen shot 1 (Above): The Navigation Menu/Switchboard - a Custom Graphic User Interface (GUI) I create to help users find their way around quickly

Screen shot 2 (Above): The multi-clickable map of Nigeria, that I use to auto-generate reports for ANY state I click on the map.- another example of how I use Custom Graphic User Interfaces (GUIs) to help users find their way around quickly.

The intuitive GUIs that I creatively incorporate is why I call my Excel-VB apps "Excel Novice Proof!". It's also why I use the tagline: "If you can use a mobile (or smart) phone, you can use my custom Excel-VB apps".

Screen shot 3 (Above): The in-cell drop menus and scroll buttons enable a user dynamically generate instant reports and charted summaries for ANY state of his/her choice.

Screen shot 4 (Above): Clicking the "Use Auto Form" buttons loads a floating form that allows him/her to do the same thing without "touching" the worksheet, PLUS s/he will also be able to click buttons to instantly change the chart type displayed.

Screen shot 5 (Above): This interface shows a floating form that enables a user click a drop menu to generate instant charts and table summaries of valid votes recorded for a party s/he chooses across ALL the states of the federation, including the Federal Capital Territory. And it also adds the totals right at the bottom - with color formatting.

NB: As I explain in the video demonstration, clicking the SAVE button on the top right of the forms (if the code is enabled) will cause the displayed table/chart summary to be saved as a FILE (image) to any location you specify on your computer. That way you would then be able to use the image outside of the app, in for example, a report or article you write, or even send it as an email to someone you think will find it useful.

Screen shot 6 (Above): This interface shows a floating form that enables a user click a drop menu to generate instant charts and table summaries of valid votes cast for ALL parties in a state s/he chooses. Note the buttons that allow the chart type displayed to be toggled from bar to line and vice versa.

Screen shot 7 (Above): In the video demo, I noted that INEC PDF summary of results had some errors in the totals column for about 5 states. Nothing serious though. However, for me, those errors confirmed that smarter use of data handling tools needs to be employed by INEC. Indeed, their summary PDF seems to be a scanned image of the paper version. As you will see from my video, smart worksheet design makes it possible to fit an even WIDER table than INEC's in Landscape orientation, on an A4 sized print page.

What's more, INEC's website offers no analysis, trending of any sort, such as the one displayed in the one page ready-to-print report auto-generated by this app. Zonal summaries of the election results offer certain very interesting insights into what really happened during that historic event.

Rather than leave people to speculate based on haphazard computations (mostly done by hand), smart use of nifty functions in MS Excel, combined with intelligent worksheet design and efficient VBA automation can dramatically boost one's ability to made useful discoveries from what otherwise appears to be ordinary looking data!

Screen shot 8 (Above): In all my apps, I insert smart clickable buttons that enable quick navigation and other tasks with a single or few clicks. Clicking a "Print" or "Print Preview" button in my apps instantly creates a ready-to-print version of the page or report being viewed by the user - and it leaves in in PREVIEW mode for the user to decide if s/he wishes to simply VIEW or send to printer. An example is seen above.

If you'd like to own a copy of the fully functional version, click here to let me know.

Copyright © 2015 www.tayosolagbade.com