Excel Consulting - Past Project Examples and
Possible Uses
Excel custom macro programs can be created for a variety of tasks that
are not always obvious. If
you have an excel spreadsheet problem, help could be closer than you think.
If it is something that we have done before, we can probably do it again, maybe
faster. ;-)) J
Some uses are listed below. MaKro Consulting has created Excel
(XL) spreadsheets and visual basic macro programs
(VBA) that automatically do the tasks listed below:
 | High speed input forms and keyboard methods to maximize
speed of data entry while minimizing input effort. Make it easier on
your worker and hopefully make them happier and more productive. |
| Repair files with the dreaded
Too many
different cell formats problem. |
| High speed estimators- create customer price estimates
for manufactured buildings, print supply requests, leasing, etc based on
specific products (1-10,000) that you are selling. |
| Aliasing program to convert various file types in
non-standard format to a standard format for use in updating online
parts database. Used to reflect current inventory from many different
suppliers. |
| Updating 100s of existing spreadsheets to reflect the
latest version (new equations, union agreement changes, product changes,
VBA code changes or additions, etc) Do it automatically instead of
manually over and over and over again. |
| Rollup 100s of data entry worksheets into a summary
report with a single click. |
| Automatic recommendations and reports based on high speed input questionnaire. |
| Calendar creation to put your calculated time sensitive
events on an easy to read Excel created calendar. Format your calendar for
import to Google Calendar for use on your Android phone. Reminder of
important events a year+ later. |
| Spreadsheets that both READ from and WRITE BACK to online
Quick Base databases. |
| Smart spreadsheets that automatically update themselves
from a Quick Base database. |
| Estimating spreadsheets that update themselves
(interest rates, etc.) from a file placed on a web site. |
| Pull down menus for your products that allow quick data retrieval and
lookup. |
| Special excel programs to do special editing, row deletion, formatting,
and searches. |
| High speed data search macro and location within an Excel database. |
| Selective data retrieval from Microsoft Access or other databases. |
| Automatic import of data from Quick Books to XL for special
reports and calculations. |
| Automatic data formatting macro to allow easy export from XL to programs
such as Quick Books |
| Custom excel program to draw and dimension technical
drawings using
database values. |
| Specialized invoices with customized input for different customers,
projects, & properties. |
| Custom data formatting for data transfer between different programs
or spreadsheets |
| Specialized payroll and analysis (with high speed input) for a phone sales force. |
| Enable/Disable protection systematically to prevent worksheet/program
damage. |
| Perform extensive, detailed engineering calculations.
I have a B.S. in Petroleum Engineering, Texas A & M. |
| Program for blending different types of hydrocarbons
from plant locations around the world and calculating the resulting
properties, or lowest cost blend.. (API Gravity, Density, Viscosity,
Aromatics, etc.) |
| Track hydrocarbon transport, departure and arrival
times, volumes and types of hydrocarbons within a network of pipelines. |
| Special excel programs to download data, format data, and create Excel databases
from information on the internet. |
| Special Program to improve speed of plant pickup and
shipping from a major greenhouse. Track inventory and locations. |
| Program to use Excel as a time clock replacement.
No need to buy the time clock or the time punch cards. |
| Data Analysis/Charting : For projects such as
changing the way that CPR is done. |
| And many more. |
