I have used the services of John Greiner to create a custom Excel Add-In. Previously to the Add-In, we were manually making changes to every spreadsheet, which could take from 30 minutes to two hours. It also left a large margin open for errors, which could cost several thousand for just one typo, and lost time / resources.
John created the Add-In, which, with the click of a button and one second later, processed the entire spreadsheet. I was impressed with the turnaround for the Add-In, less than half a day. He was patient to work with me to ensure it was working 100% correctly. We have enlisted John as the top resource for any future spreadsheet macros and Add-Ins and I would highly recommend him for your needs.
In the few days we started using this feature we have processed several spreadsheets and have saved approximately six hours of manual edits in the first week alone.
John created several macros for me saving hours of time each week combining crucial fields from reports. He is professional, quick to respond, and skilled in this field. I plan to continue working with John as my needs develop in reporting for our company.
John wrote a complex Excel Macro that enabled me to automatically populate a crucial field in a large data base, saving me an enormous amount of time. John is highly skilled, quick to respond and has a friendly, helpful manner. I will definitely use John again for future projects.
Equinox Energy, LLC
Las Vegas, Nevada
As a financial analyst I am responsible for collecting large amounts of information and organizing it in Excel. I was looking for a more efficient way to do this and John provided the answer. I have no background in programming and was not even aware of the options available to me. John opened many doors for me and even taught me a bit about programming, and it has paid off tremendously. I am now able to spend less time on remedial tasks and focus more time on important ones. I highly recommend John for anyone looking to explore ways to increase productivity for computer based functions. John worked with me around my busy schedule and was responsive. I look forward to working with him again in the future.
Associate Analyst – Equity Research
Avondale Partners LLC
I knew what I wanted in the project, but I had no idea of how to implement it. The project was complicated, and there were setbacks, but at each stage John came up with a recommended course of action. He was not tied to one program or strategy but was most interested in making sure my needs were met – and doing so efficiently. He ended up coding the project in a combination of Macro Express, VBA, and Excel. I really appreciate John’s responsiveness to my phone calls and emails. It is refreshing to get answers back to questions the same day. He was very professional and I look forward to working with him again.
Gregory A. Johnston, CFA, CFP, QPFC, AIF
President, Johnston Investment Counsel
I was in need of a few macros to help run some tasks within our accounting system, Timberline, that has no provision for scheduling tasks and could not be done within Microsoft Task Scheduler. After trying to do so with Macro Express, I found that I was no programmer and the task at hand was a difficult one. After finding John through a referral, I contacted him online and we talked about the task at hand over the phone. I showed him what I needed via a WebEx session, he quoted me a price and performed the task professionally and expeditiously. After a few tweaks, the macro ran perfectly until we changed parameters. I contacted John and he stepped me through the revisions without question. I have never met him but would recommend him to do your next macro!
Marshall A. Tuck, PE
Vice President, Samet Corporation
If you're in need of quick results — this is your guy. And the best part about it is that the code works right the first time! He even sent me a follow up script that he thought might work better.
Your high level of service?
Your willingness to go beyond what is required?
Your ability and willingness to explain and show the customer when they don't know?
Your ability to understand the customer’s needs?
Your quality of product?
You get 10+ out of 10 on all of them... plus another 10 for just being a good person.
Randy Rowles, Web Designer
Medicine Hat, Alberta, Canada
As a clinical cytogenetic director in the fast moving field of genetics, we are constantly working to customize our computer networks to ensure accuracy, efficiency and reliability. In the past few years we have moved into the world of high through-put bioinformatics and have needed to reach outside our own homegrown workforce to enable us to utilize more sophisticated tools. One consultant we have been working with this past year stands heads above others, and that is John Greiner. His job assignment was to generate a MACRO that would interface with the Agilent genomic microarray system and our own analytical tools. In simple terms, following scanning of the microarray chip and computational analysis, the MACRO is to process the microarray data into discrete patient data files ready for analysis and interpretation. John worked jointly with us (a team of co-directors and supervisors) and Agilent to produce an amazing tool that went beyond our expectations.
I would expect many people in the bay area to have the expertise to design and generate a MACRO for our purpose. But John has additional abilities that make him unique in the field of computer consultants, the ability to hear MANY people’s version of their expectations for a project, sort through these QUICKLY, and provide a testable product in a VERY timely manner that is easy to dissect and fine tune until you reach your final version. He communicated with all parties clearly by generating a list of tasks and a reliable timetable, which became a benchmark for all of his work.
In demanding situations, John is able to guide the users to find the critical area that needs to be further reviewed. He does NOT assume he knows what the other party is talking about, he verifies by working with us in a very timely and efficient way. He seems to diffuse the tension in an otherwise stressful situation. He also educates us in the process.
Case in point, we chose to upgrade the MACRO recently, and in doing so, John taught us about critical features in the Agilent system that we were unaware existed. This surprised us, since we have been working with this system for more than 3 years and John less than a few months! John did this, as he always does, via live web interfacing, and calmly guiding us through features of the MACRO design. In a clinical setting, when a MACRO is part of a process that results in patient diagnosis, there is a lengthy and thorough validation process that must be satisfied prior to using the MACRO on patient samples. These validation processes all went very smoothly, speaking to the workmanship of the MACRO, and John’s ability to design, implement, and update MACROs in intense clinical settings.
His computer expertise together with his exceptional teaching skills and focused yet calm approach is a perfect combination, and one I think we all should strive for in our careers.
Lauren S. Jenkins, PhD
Co-director of Clinical Cytogenetics in the Regional Clinical Cytogenetics Laboratory for Northern California, Kaiser Permanente (The Permanente Medical Group)
I have been a CPA for approximately 25 years. With the constant deadlines and additional forms mandated by the Internal Revenue Service, I had to find a way to become more productive. I had heard about macros and what they could do, but I did not have the programming expertise to implement them. I needed to find a way to create electronic tax data organizers and then macro the information into the tax software without additional data entry. I honestly did not think this could be done and done accurately.
But, John proved me wrong. I have been using this process now for two years, I can't begin to tell you the time it has saved me on some of the tax returns I do. It's like having another tax preparer without the additional cost. It really is a beautiful thing to watch the data automatically go into the tax return software without having to keypunch it again!!!!!!!!!!!!!
In conclusion, the thing that really amazes me about John is his ability to envision what you want done and then make it become a reality! This is truly a unique talent that you don't find every day.
Christopher F Chestnut
Certified Public Accountant
Digital Tax Assistant
Digital Tax Organizer
I had been spending about one hour every Sunday sending out confirmation emails to all my clients for the coming week. After John wrote me a macro to semi automate the process, it now takes me about 5 minutes. Modifying my website appointment calendar used to be a cumbersome process. One keystroke combination now starts me at the place I need to be to make updates. John was great to work with; patient, quick, and pleasant. Best hundred bucks I spent in a long time!