"It all works brilliantly; we had struggled for many years to find a
solution to our problem, but Greg designed a macro that was the
solution -- it does everything we had hoped for. Thank you so much for the
great work." (Jess
Sutcliffe, Belgravia Music Inc.)
AUTOMATE EXCEL
I automate ANY TASK that you do in Microsoft Excel.
No matter how complex.
SAVE TIME
Instead of spending hours every month or week doing the same series of tasks in Excel, simply click a button, then do other tasks while your Excel work is automatically done for you.
Imagine how much more you can accomplish with all the time you'll save! And you'll be amazed at how much faster a well-written Excel VBA macro program can accomplish your tasks - hours of manual labor can often be completed in the blink of an eye.
I also automate huge tasks in Excel that you only wish you had the time to do - you dream it up and tell me what you want done, and I’ll make it happen.
REDUCE ERRORS
When people do repetitive, tedious tasks, small mistakes are inevitable. But even small mistakes can cost you a lot of time and money.
One of my clients had recently lost $180,000 due to a very tiny error in a huge, extremely complex Excel spreadsheet. The error had resulted in incorrectly manufactured product. They had a manual auditing process in place for that spreadsheet, but that audit took 5 days (!) to do and so could not be done as often as needed. And, that manual audit was prone to error even when undertaken. I automated that audit for them. The automated audit takes only about an hour to complete, instead of 5 days. They now run that audit as many times as needed until they are absolutely sure the data is correct, before handing it off to manufacturing. They have made no mistakes on it since then and not a penny has been lost.
A custom Excel program can do your most repetitive, most tedious tasks without making errors.
"[Greg] is definitely going to be in my favorite
list of [programmers]. He provides the solution super fast and with
great accuracy. I will use him again for other jobs in future."
(Jason Khoo,
SynergyWorks,
Singapore)
BUT IT'S DIFFERENT EVERY TIME!
So the tasks you'd like to have automated are slightly different every time you do them, and you're wondering how Excel can be programmed to accommodate the differences each time?
Here's what I'll do for you:
The Excel workbook I provide will have clearly marked places for the input data that can change. Each time you run the program, you make any of those changes that are needed for that particular run. That way, the program adapts to routine changes like that.
If some of that changing data is lists with varying quantities of entries, you'll have a whole column for each list, so you can make each such list as long or short as it needs to be. And if one column isn't enough, you'll get as many columns per list as you need.
Needing changeable settings like that is the norm, not the exception. I do it for almost every client. And it's different for every client -- often vastly different. Yours will be designed for your specific needs.
"The work Greg Lovern did creating macros for my business saved me considerable time and money and increased the accuracy of the data we send out. Greg is a very easy guy to work with and not only created the macros, but taught me how to update them and was very willing and helpful to tweak if needed."
(Stephanie Murray, Microsoft
Program Manager)
WORKSHEET
FUNCTIONS
Are you an Excel power user who's outgrown some of Excel's built-in worksheet functions? Ever wish they did something more, or something different? Just tell me what worksheet functions you want, what arguments you want to pass to them, and what results you want from them. I'll take it from there. I'll create an Excel add-in that you can install in Excel, and that you can distribute to others if you wish. You can even sell it to others.
What if you just want a small change to one of Excel's built-in worksheet functions, and don't want to pay to have the whole thing rewritten? No problem. I'll write a function with only the new or changed functionality, then call the built-in function from the new custom function. You pay only for the new or changed functionality.
"Greg was a tremendous help to us on this [Excel – Great Plains integration] project. Our existing systems were a complicated collection of old Excel sheets and macros. The primary vendor we were working with on Great Plains implementation was unable to produce a qualified resource that could integrate the data into Excel. However, with Greg, we explained to him what we wanted the system to do, and he jumped right in and made this a reality in less than 2 weeks."
(Eric Watson,
Incentra Solutions NW)
VBA PROGRAMMING
FUNCTIONS
So you're doing your own Excel VBA programming, but you'd like some functions written that you can call from your code, to make your work more efficient. No problem, just tell me what parameters you want to pass to the function, and what result you want the function to return. Leave the rest to me.
Those functions can be copied to your VBA project, or if you prefer, I can put the functions in a DLL that you can call from VBA.
"Greg’s insight and expertise of Excel has created solutions that have reduced and streamlined our delivery time by half. What an incredible gift, Thank you!"
(Rahel Haley, Microsoft
Program Manager)
AUTOMATE EXCEL
BETTER
If you already have a macro that provides some performance gain, but you want more from it, I can:
-
Make your macro more versatile.
-
Make your macro more error-proof.
-
Make your macro more convenient.
-
Make your macro run faster -- MANY TIMES faster. Don't be surprised if I can make your macro run over a hundred times faster.
-
Add whatever new functionality you wish.
"Excellent – works like a charm – thank you!"
(Patrick Blackburn,
Microsoft Program Manager)
WORKSHEET FORMULAS
Maybe you just want some worksheet formulas written. I do that too! Just tell me what you want the formulas to do.
"I have a new business and found myself trying to do everything myself. After spending dozens of hours trying to figure out how to make excel work for a new program I wanted to offer my clientele, I turned to Greg. Something that would have easily taken another 100 hours of my time only took him an hour to complete. Now I am ready to offer the program to my clients and get back to doing what I do best... my business!!!"
(Benjamin Gordon,
Simply Fit)
CALCULATE FASTER
Do you have huge workbooks that take hours, maybe
even days(!), to calculate? Let me optimize them for fastest possible
calculation speed. Don't be surprised if I make them calculate several
times faster. When I'm done, I'll demonstrate how much faster they
calculate, and you only pay if you like what you see. If the improvement
isn't fast enough to amaze and thrill you, you're under no obligation to
buy.
"Your work is very impressive!"
(John Smith, PE, SE,
Collons + Smith Structural Engineers)
AUTOMATE OFFICE
I can also automate your tasks in other VBA applications, such as Microsoft Outlook, Word, and PowerPoint, including those that are not sold as part of Office, such as Visio and Microsoft Project. And, I can integrate tasks that involve multiple VBA applications, such as copying data from Outlook to an Excel spreadsheet.
AUTOMATE ANYTHING
I can also automate most other Windows applications by creating a new program that manipulates them with simulated keystrokes and simulated mouse clicks and other programmatic controls. Of course, this technique doesn't provide as much control as Office VBA, but it's a lot better than tedious manual labor.
"Greg, it [Excel VBA custom tool]
works outstanding!"
(John
Trujillo, Microsoft Program
Manager)
DO ANYTHING
I can also create entirely new Windows programs, to your specifications,
that don't rely on any other applications at all, and do whatever tasks you
specify.
"This definitely makes life
easier!! Woohoo!!!"
(Elizabeth Brown,
Microsoft Program Manager)
HERE'S HOW IT WORKS
If you're near Bellevue, WA, we can meet
at a public place such as Starbucks, and I'll watch while you step through
the tasks you want automated. Then I'll repeat the steps back to you to make
sure I understand, and write it all down.
If you're not nearby, or if you just
don't have time to meet, we can do any of the following, whichever you
prefer:
-
You can just write the tasks down for
me.
-
You can send me your Excel workbook,
and we can discuss what you want automated by phone or email.
-
We can "meet" through web
conferencing at no cost to you, and you can tell the web conferencing
software to give me temporary permission to watch what you're doing in
Excel, while we discuss it on the phone. Or if you prefer, you can send
me your Excel file, and I can give you permission to watch it on my
computer, again while we discuss it on the phone, and you walk me
through the steps you want automated.
Then, I take it home and think about how
much time it will take to program, and get back to you (usually within a few
days) with a price.
If you accept, I get to work and let you
know when I'm done, usually within days or weeks. (Large projects require
either starting with a small piece of the project, or signing a contract.)
I demonstrate the completed work to you,
and if it's exactly what you want, you can buy it right then. Or, if changes
are needed to best meet your needs, I can make those changes and let you
know when I'm ready.
"Thanks, this is way better [than
solutions provided by others]...The [macro running time] went from ~4.5
mins on a dual core E6600 down to < 1 sec...Clearly you have high skills
in Excel..."
(David Lean, Microsoft
Technology Specialist)
DON'T FIX WHAT'S NOT
BROKEN
Perhaps you've already talked to some
other software consultants who quoted hundreds of thousands, maybe millions
of dollars to completely replace your routine Excel business processes with
special software. It will take them months or years to deliver, and then
you'll have to learn the new software and processes they set up for you, and
probably adapt your business to them in some ways. Later, when your business
needs change, you'll have to go back to those expensive consultants for more
punishment. And someday when you need to upgrade to a new version of that
special software, you can bet it will cost a lot more than upgrading to a
new version of Excel.
I'm pretty sure you can think of much
better ways to spend all that money and time.
Instead, simply automate the Excel
processes that are currently working for you right now. Those processes are
doing exactly what you want; they just take too much of your time, and risk
too much human error. Automating the Excel tasks you're already doing will
cost a very small fraction of what those fancy consultants will cost you.
Do you believe in keeping it simple? I
do.
"Wow, outstanding to get to a true
source about using [Excel's MS] Query. Thanks Greg! I really appreciate
it."
(Joe Rettenmaier, Microsoft
Contractor)
SPEND LESS
So you’ve been quoted a huge figure to completely revamp one of your processes.
You don’t want to spend all that money right now, but you do need to improve
your current process enough to tide you over until you can make the big change.
You’ve come to the right place. I can improve your current Excel-based process
at a fraction of the cost you were probably quoted. What’s more, you might like
the result so much that you decide you have better ways to spend the big bucks.
"Sweet! Thanks!"
(Michael J. Lyons,
Microsoft Development Lead)
NO JOB TOO SMALL
Many consultants want only big, 5-figure
and up contracts. That isn't me at all. I'm interested in even the smallest
jobs. I've invoiced for as little as 1/2 hour of work. There is no minimum.
SUBCONTRACTING
Someone has to write all that code
you promised your clients, but you're so busy flying all over the world
getting new clients that you don't have time to write it. You need a
subcontractor. Someone who can take your spec and write to it, and adapt
to your coding style if you've already started the project. Someone who
can read between the lines and make educated guesses when necessary, but
ask for clarification when needed. Someone who offers suggestions where
appropriate, but who doesn't argue with you about your syle and choices.
You don't want a Prima Donna. You need someone like me.
A major national restaurant chain, and a
major national computer manufacturer, and a local medical care company
probably have no idea that they are running my code. Your clients can be
next. Just tell me what you need done.
"This works great...helps a lot."
(Sean Siler, Microsoft
Program Manager)
PARTNER
You have a great idea for an
automation tool or program that you believe would sell, but you can't pay
the development cost up front, or just don't want to risk that much money.
Let's talk about partnering on the project. You have the great ideas, I
write the code, we share the profit.
"Awesome, thank you Greg – I think
this is what I need"
(Jim Cumming,
Microsoft Developer Product
Support Manager)
NO RISK
You have a set of manual procedures you
want automated, but you're not sure if you want to make a commitment to
paying for it until you're sure the automation tool does EXACTLY what you
want. No problem! I can demo the completed automation tool to you using web
conferencing software, at no cost to you. Alternatively, I can demo it to
you on my laptop computer, if that is more convenient for you.
You observe the completed automation tool
in action through web conferencing (or on my laptop computer if you prefer),
then decide if you want to buy it. If you decide not to buy it, you have no
further obligation.
Of course, for large projects, we'd need
to start with a small piece of it -- or if you prefer, we could instead just
sign a contract.
HOUSE CALLS
Yes, I do house calls, if you're near
Bellevue, WA. We can also meet at area coffee shops to discuss your project.
Alternatively, we can use web
conferencing software (at no cost to you) to view and discuss your project
together without being in the same location.
GET TUTORED IN EXCEL
I'm also available for Excel tutoring,
including both Excel usage and Excel VBA programming. Learning VBA
programming can make you as productive as 10 or more people.
Tutoring can be targeted to any specific
project you are working on, or broadened to gain more general knowledge.
If you're just getting started with VBA
and have no prior programming experience, I suggest working through a good
tutorial book and supplementing it with targeted tutoring sessions as
desired. A good choice is "Microsoft Excel 2007 Visual Basic for
Applications Step by Step" by Reed Jacobson, but others are fine too.
Tutoring is available at your place (if
you're not far from Bellevue), my place, public places of your choice such
as Starbucks, by telephone, or even by email.
STAFF RESOURCE
In addition to creating custom Excel and other Office VBA
tools for your organization, I'm happy to serve as a general Excel resource.
While at my recent 1-year contract at
Microsoft, programming Excel tools for a group of business managers and
their assistants, I happened to overhear a conversation at the next
desk about an unpopular, tedious task that took hours to do and had to be
done frequently. I recognized that what they were talking about could be
done quickly and easily in Excel. Using their actual data, I
did it for them in less than a minute while they watched. Later, their
manager organized a meeting for me to demonstrate the technique to about 12
managers, while one of them took notes so they could document the procedure
in a process document. That's just one example of how I saved them money in
ways that went beyond my main function there as an Excel VBA programmer.
If your organization in or near Bellevue,
Washington State could benefit from that kind of resource, whether full or part-time,
temporary or long-term, contact me and let's discuss your needs.
"Thanks for all of the Excel help
– we really
appreciate your expertise"
(Kiera Ojo, Microsoft
Program Manager)
|
Call or email for an absolutely free consultation to discuss your needs.
Greg Lovern
(425) 747-1548
email
Bellevue, WA
MY QUALIFICATIONS
-
I've been developing custom Microsoft Excel solutions since 1992, when I automated the bookkeeping system of a large restaurant on Lake Union in Seattle.
-
I was at Microsoft for over nine years as a Product Support Professional, including over three years in Excel support and over four years in Developer (programmer) support, helping thousands of Microsoft customers with difficult programming problems. While there, I was promoted to the Excel escalation team, then to escalation lead.
That means I handled the most difficult Excel programming support cases, which even the other members of the escalation team were unable to resolve. And, I had excellent, team-leading survey results from the customers I helped.
-
I've created and marketed two powerful
and highly regarded Excel add-ins:
--
http://PrecisionCalc.com
-
Over 1 year contracting
at Amazon.com, programming custom tools in Excel VBA,
2007-2008.
-
1-year contract at Microsoft programming custom tools in Excel VBA, 2006-2007.
-
I've been a Microsoft Certified Professional (MCP) in Excel since 1994 and in Excel VBA since 1995. And I've been a Microsoft Certified Solution Developer (MCSD) since 1997. You can view my Microsoft Certification Transcript here:
https://mcp.microsoft.com
Transcript ID: 720428
Access Code: 4F9W5G7S
Access Code is case sensitive |
MORE QUOTES:
"[Greg provided] the best
support I have ever had from Microsoft."
(Microsoft
customer survey response)
"I wanted to express my extreme
appreciation for the outstanding support Mr. Lovern has been providing to me
via the microsoft.public.excel.programming newsgroup. Despite what I have
considered to be a series of 'killer' questions, Mr. Lovern consistently
provides valuable, insightful answers that are targeted 'right on'. He has
amazing insights and consistently shows true understanding for my needs. It
is a delight that he often goes beyond the basic question, providing
additional tips, tricks, and suggestions. As a further bonus, his answers
are VERY well-written... My deeply felt thanks for Mr. Lovern for all his
answers. I am, indeed, a very satisfied customer."
(John Macko, Microsoft
customer, email to manager)
"Greg Lovern did an
incredible job for us...he was extremely helpful..."
(Drew Bollman, Microsoft
customer, email to manager)
"The level of service
[Greg] provided was excellent."
(Microsoft
customer Arhan at Data Physics, email to manager)
"I received excellent
customer support from Greg Lovern."
(Microsoft
customer, email to manager)
"Greg was very
helpful...I appreciate the way Greg worked with me."
(Microsoft
customer, email to manager)
"I am very happy and
satisfied with the problems/questions [Greg] supported."
(Microsoft
customer, email to manager)
"It was my pleasure to
work with Greg Lovern...He helped me resolve the issue quickly and
completely. He was not only knowledgeable but very personable. I am well
satisfied with the support I received."
(Microsoft
customer, email to manager)
"[Greg] resolved our
issue in no time."
(Microsoft
customer, email to manager)
"Greg immediately went
straight to the point and made a recommendation that seems to have resolved
the problem."
(Microsoft
customer, email to manager)
"[Greg] was very
knowledgeable, quickly identified the problem and solved it very quickly.
[Greg] was pleasant to work with and very friendly"
(Microsoft
customer survey response)
"I rated [Greg] [the
highest possible rating] because the support was great and fast..."
(Microsoft
customer survey response)
"[Greg was] much more
responsive than the other [product support professionals]."
(Microsoft
customer survey response)
"[Greg] was very helpful
and solved my problem very quickly."
(Microsoft
customer survey response)
"Thanks for the great
work. It was refreshing to see somebody really jump on a case and push
through to a resolution right then."
(Microsoft
Premier Technical Account Manager Maxwell Myrick)
"I love xlPrecision!
It's allowing me to do something on a very important project that wouldn't
have worked without the extra precision."
(Mark Ryan, math educator,
author of "Calculus for Dummies" and other math books, and
customer of Greg Lovern's software product xlPrecision)
"I will plug xlPrecision
in the third edition of my 'Financial Modeling' book. I have a chapter on
Monte Carlo which shows why you want might such a powerful plug in as
xlPrecision."
(Simon Benninga, Professor of
Finance & Dean of the Faculty of Management, Tel-Aviv University,
Israel, Visiting Professor of Finance, Wharton School,
University of Pennsylvania, Professor of Finance, University of Groningen,
Netherlands (partial appointment), author of "Financial Modeling", chosen as
the "#1 Recommended Text for College Students Interested in Financial
Engineering" by Financial Engineering News, editor-in-chief of European
Finance Review, and customer of Greg Lovern's software product
xlPrecision)
"An excellent product.
Well done."
(Chris Ross, Accurate
Software, customer of Greg Lovern's software product xlPrecision)
"I found xlPrecision of
tremendous help in solving extremely small probability of occurrence
problems in Excel."
(Jim Ramsden, BAE Systems,
customer of Greg Lovern's software product xlPrecision)
"I have been using
xlPrecision about 10 hours per day and I am in the middle of an important
analysis. I could not do the work that I have been doing without
xlPrecision."
(Thomas Mouat, customer of Greg
Lovern's software product xlPrecision)
"Thanks for a really
useful tool."
(Douglas
Preston, ReadyNet, customer of Greg Lovern's software product xlPrecision)
"xlPrecision really is
an outstanding improvement in Excel when you need that level of accuracy."
(Ben Hackett, customer of Greg
Lovern's software product xlPrecision)
"Very impressive. I am a
very happy customer."
(Kevin Hanson, North Dakota
Public Service Commission, Testing & Safety Division Metrology Laboratory,
State Metrologist/Assistant Director, customer of Greg Lovern's software
product xlPrecision)
(documentation available for all quotes)
A FEW PROJECTS
I'VE DONE
-
Get data from Outlook appointments, get other data from file folders, analyze the data as specified by the customer, and present the results in an Excel spreadsheet.
Saves hours of manual labor and takes a couple seconds to
run.
-
Automate an Excel spreadsheet used as a data entry form. Many columns have dropdown listboxes whose list of
items are updated frequently by getting the new data from the network, and users
can update the lists on command. The dropdowns are designed for very rapid
keyboard data entry; they are opened and closed by standard keyboard actions,
and autocomplete through thousands of list items simply by typing the first
characters of the desired item. Users can add or delete rows in the form as
desired.
-
Compare two massive data sets to find and call out any differences.
Each data set is stored in a completely different, and
nonstandard, way. Each data set is under constant revision
by many users. Each data set has
over 7,000 data points (and growing every month) that must be checked against
the other data set. To perform the comparison, each data set is converted to a
standard flat file with over 7,000 rows, and sorted. Then the two flat files are
compared line by line. Any differences found are summarized in a report. Saves 5
days of labor each time it is run.
-
Automate hundreds of similar Excel spreadsheets used as data entry forms. Also,
automate the very process of generating those spreadsheets, because there are
too many of them to efficiently update manually, and frequent updates are
required. Automate internationalizing those spreadsheets into English USA,
English UK, German, French, and Japanese, and allow for adding any number of
other languages in the future. Each spreadsheet has unique columns, and many
have hundreds of columns. These spreadsheets are distributed to thousands of the
client's vendors, each of which can have any number of users using them to
upload data to the client. Allow users to get the latest updates to the
spreadsheets via the web, by clicking a toolbar button. Many columns in the spreadsheets have dropdown listboxes. The contents of
any given listbox can depend on the entry on that row in any other column. The dropdowns are designed
for very rapid keyboard data entry; they are opened and closed by standard
keyboard actions, and autocomplete through any number of list items simply by
typing the first characters of the desired item. Before uploading the data to my
client, the user can validate their work by clicking a toolbar button, which
checks all entries according to thousands of logical tests, and provides
cell comments on each cell that fails validation, explaining in the
user's language what the problem is with their entry in that cell. Users can use as many rows as
desired (and get dropdowns and validation in all of them), limited only by
Excel's maximum number of rows in a sheet. Since many of the vendors do their
own data pre-processing that results in columns in different orders than the
spreadsheets, provide an import feature that accepts the columns in any order
and rearrange them as needed. Enables vendors to upload data to the client much
more quickly, with far fewer errors, and with much less
training, enabling them to sell more uploaded product. Rolled out
with great success in UK, Germany,
France, and Japan. It has been held back in the USA due to a
back-end legacy issue beyond my control, but is expected to roll out
soon.
|
(The words and phrases
below are intended ONLY to more thoroughly represent my skills than
is reasonably possible in the main text. They are NOT intended
to cause search hits that fall outside my skill set.)
Microsoft Excel
Developer
Microsoft Excel Consultant
Microsoft Excel Consulting
Microsoft VBA Developer
Microsoft VBA Consultant
Microsoft VBA Consulting
Microsoft Excel VBA Developer
Microsoft Excel VBA Consultant
Microsoft Excel VBA Consulting
Microsoft Excel Programmer
Microsoft Excel Programming
Microsoft VBA Programmer
Microsoft VBA Programming
Microsoft Excel VBA Programmer
Microsoft Excel VBA Programming
Microsoft Office Developer
Microsoft Office VBA Developer
Microsoft Office Programmer
Microsoft Office Programming
Microsoft Office VBA Programmer
Microsoft Office VBA Programming
Microsoft Outlook Developer
Microsoft Outlook VBA Developer
Microsoft Outlook Programmer
Microsoft Outlook Programming
Microsoft Outlook VBA Programmer
Microsoft Outlook VBA Programming
Microsoft Word Developer
Microsoft Word VBA Developer
Microsoft Word Programmer
Microsoft Word Programming
Microsoft Word VBA Programmer
Microsoft Word VBA Programming
Microsoft Project VBA Programming
Microsoft VB Programmer
Microsoft VB Programming
Microsoft VB Developer
Microsoft VB6 Programmer
Microsoft VB6 Programming
Microsoft VB6 Developer
Microsoft Visual Basic Programmer
Microsoft Visual Basic Programming
Microsoft Visual Basic Developer
Microsoft Visual Basic for Applications Programmer
Microsoft Visual Basic for Applications Programming
Microsoft Visual Basic for Applications Developer
Excel Tutor
Excel Tutoring
Microsoft Excel Tutor
Microsoft Excel Tutoring
MS Excel
Excel Automation
Excel Customization Custom Customizing Service
Excel Macros
Excel VBA Macros
Excel spreadsheet spreadsheets
|