Craig Hatmaker

Craig Hatmaker

Salem, Virginia, United States
6K followers 500+ connections

Join to follow

About

Introduction
Model errors can cost millions and crush careers. 5g modeling methodology…

Articles by Craig

See all articles

Activity

Join now to see all activity

Experience

  • Beyond Excel Graphic

    Beyond Excel

    Salem, VA, USA

  • -

    United States

  • -

    Christiansburg, VA

  • -

  • -

    Salisbury, MD

  • -

    HQ

  • -

    Roanoke, Virginia Area

  • -

    Roanoke, Virginia Area

  • -

    Newport News, Va

Education

Licenses & Certifications

Volunteer Experience

Publications

  • Reducing Errors in Excel Models with Component-Based Software Engineering

    EuSpRIG Proceedings 2023, ISBN: 978-1-905404-57-5

    Model errors are pervasive and can be catastrophic. We can reduce model errors and time to market by applying Component-Based Software Engineering (CBSE) concepts to Excel models. CBSE assembles solutions from pre-built, pre-tested components rather than written from formulas. This is made possible by the introduction of LAMBDA. LAMBDA is an Excel function that creates functions from Excel's formulas. CBSE-compliant LAMBDA functions can be reused in any project just like any Excel function…

    Model errors are pervasive and can be catastrophic. We can reduce model errors and time to market by applying Component-Based Software Engineering (CBSE) concepts to Excel models. CBSE assembles solutions from pre-built, pre-tested components rather than written from formulas. This is made possible by the introduction of LAMBDA. LAMBDA is an Excel function that creates functions from Excel's formulas. CBSE-compliant LAMBDA functions can be reused in any project just like any Excel function. They also look exactly like Excel's native functions such as SUM(). This makes it possible for even junior modelers to leverage CBSE-compliant LAMBDAs to develop models quicker with fewer errors.

    See publication

  • Ribbon Recipes: Beginners Guide to Creating Excel Menus

    Amazon Kindle

    Ribbon Recipes is a ‘cookbook’ approach to creating custom ribbons.

    Application development is like cooking. Imagine we are chefs and we are creating a new dish. No one has ever done it before. We have to start from scratch. We have some idea of ingredients needed and amounts. We mix them and guess at oven temperatures and cooking times. When finished we look back and realize what could have been done better. We record and adjust ingredients, measures, temperatures, and cooking times…

    Ribbon Recipes is a ‘cookbook’ approach to creating custom ribbons.

    Application development is like cooking. Imagine we are chefs and we are creating a new dish. No one has ever done it before. We have to start from scratch. We have some idea of ingredients needed and amounts. We mix them and guess at oven temperatures and cooking times. When finished we look back and realize what could have been done better. We record and adjust ingredients, measures, temperatures, and cooking times. We document what we did and when. Eventually we get our recipe just right. With it we can recreate our dish perfectly, and others can too. Ribbon development is like that.

    For ribbon development our ingredients are XML code snippets, VBA callbacks, images and even Excel tables. Our recipes include those ingredients and worksteps to assemble them. Our ‘kitchen equipment’ are XML editors, VBA’s interactive development environment, and even MS Paint. This course adds to what we already have to provide everthing we need to ‘cook up’ professional grade Excel interfaces.
    This course starts by teaching the basics. I then introduce you to my ‘kitchen’ with its ‘pantry’ full of ‘ingredients’. We then put our knowledge and tools to work in labs. Our first lab creates a simple ribbon from scratch. Each subsequent lab builds on prior labs with our last lab leveraging library modules built using the same techniques revealed in the first lab. Lastly, I will introduce you to professional practices that leverage other team member’s successes and make sure others can build on ours.

    This book connects you to other team members who created tools that dramatically boost performance. They improve speed, functionality and reliability. We can build on their success by leveraging their tools in our work. These tools cost tens of thousands of dollars to develop and you get them for the cost of a book. If you are an emerging VBA developer leveraging these resources will jump start your career.

    See publication

  • Proposed Spreadsheet Trasnparency Definition and Measures

    Proceedings of the EuSpRIG 2017 Conference "Spreadsheet RiskManagement", Imperial College, London, pp49-61 ISBN: 978-1-905404-54-4

    Auditors demand financial models be transparent yet no consensus exists on what that means precisely. Without a clear modeling transparency definition we cannot know when our models are "transparent". The financial modeling community debates which methods are more or less transparent as though transparency is a quantifiable entity yet no measures exist. Without a transparency measure modelers cannot objectively evaluate methods and know which improves model transparency.
    This paper proposes…

    Auditors demand financial models be transparent yet no consensus exists on what that means precisely. Without a clear modeling transparency definition we cannot know when our models are "transparent". The financial modeling community debates which methods are more or less transparent as though transparency is a quantifiable entity yet no measures exist. Without a transparency measure modelers cannot objectively evaluate methods and know which improves model transparency.
    This paper proposes a definition for spreadsheet modeling transparency that is specific enough to create measures and automation tools for auditors to determine if a model meets transparency requirements. The definition also provides modelers the ability to objectively compare spreadsheet modeling methods to select which best meets their goals.

    See publication

Honors & Awards

  • Best Rated Eloquens Author - 2024

    Eloquens

    This is a celebration of authors who have received the best rating for the Best Practices, commending the exceptional level of quality of their know-how and the appreciation shown by users.

  • Microsoft MVP

    Microsoft Corporation

  • Presenter at EuSpRIG Annual Conference, 2017 Imperial College UK

    EuSpRIG

    "Proposed Definition and Measures for Model Transparency in Excel" - Paper Published 2017

Languages

  • English

    Native or bilingual proficiency

  • Japanese

    Limited working proficiency

Recommendations received

3 people have recommended Craig

Join now to view

More activity by Craig

View Craig’s full profile

  • See who you know in common
  • Get introduced
  • Contact Craig directly
Join to view full profile

Other similar profiles

Explore more posts

Explore top content on LinkedIn

Find curated posts and insights for relevant topics all in one place.

View top content

Add new skills with these courses

See all courses