I Deliver Consistent Excel Results
If you need a custom worksheet, Excel VBA programming or an advanced Excel database, David Jenkins will meet your needs and exceed your expectations.
David Jenkins has a Master’s degree in Computer Science from Brunel University in England and a Bachelor’s degree in Mathematics from Manchester University.
He programs and consults as an independent developer and has had clients in Europe and across the USA. His clients have included large retail stores, publishing houses, hospitals, research laboratories, and many smaller companies such as a refrigerated warehouse, a flourishing chiropractic practice and a vocational training company. He was written many accounting applications including billing, payroll, budgeting, asset management and more.
Q: What makes you an Excel expert?
A: I have been developing complex Excel projects and programming for over 15 years.
Q: I know how to do Excel, what makes you so special?
A: When you have a large project, you must understand the structure of your data. Otherwise you risk getting wrong answers or never completing your project.
Q: Excel seems so easy, why can’t I just learn as I go along?
A: You can and if you keep your projects inside your ability level, you’ll be fine. But many people eventually realize they have gone past that ability level. Sometimes when it is too late.
Q: What kinds of problems can I encounter on my own?
A: If, when you fix one thing, something else goes wrong, and that keeps happening, it’s a sign that you haven’t understood the structure of your data.
A: If you find you are working 16 hours a day on your project, it’s a sign that you need to regroup and at least discuss your task with an expert.
Q: I can develop my project in a small way and then grow it. Why do I need you?
A: The short answer is that Excel is a kind of addiction. People with talent find they just do more and more and they can forget what their real task is.
A: The longer answer is that when you can write macros and, behind the macros, programs in Microsoft Office’s Visual Basic for Applications (VBA), you can do very complex and fast calculations but you need to be able to program not just write formulas.
A: The serious answer is that spreadsheets that grow tend to generate errors. We are all vulnerable. Getting the right answers is only half the work: not getting the wrong answers requires a different way of thinking. Accidents happen.
Q: Can you give me an example?
A: A large retail chain. Data from their entire world operation existed in Oracle. The manager of my project needed to know certain information about each store in a certain state. I imported an Oracle database into Excel. There were 250,000 rows detailing every store in the world. Even worse, 90% of these rows contained zero information (literally “0”). My program collected the relevant 25,000 rows and then prepped them to produce the meaningful answers that the executives of.
A: I can give you many. Think about limits. Do you really want to send a bill for $0.
A: Catastrophic error: Two famous Harvard economists, Carmen Reinhart and Kenneth Rogoff , wrote an influential paper showing that economic growth declined when a countries debt level got too high. Unfortunately, one of their errors was that they had not selected the entire row when performing a certain calculation. They had selected only the first few columns. It happens.
Q: OK But all the same, what can you do that I can’t do?
A: I can test your program and will almost certainly find errors that you haven’t thought about.
A: I can present your work in ways that make you look good. A: I can automate processes so that the task can be delegated.
A: I can connect Excel to the rest of your information world and have it automatically collect data from other software (e.g. your financial accounts, Oracle databases, many more).
Q: But I’m the only one who understands what I’m doing.
A: Think about it. That’s almost always a burden. You want to be able to share your work. You want to automate the processes you have created.
Q: Can’t I get someone in Asia to do this for $5 an hour?
A: It only works on a large scale. Big companies use software factories abroad for cheap labor but they have teams of people here who supervise and who give detailed directions.