Development Template

The Fast Excel Development Template is an Excel workbook with pre-configured worksheets and macros. It provides a rapid way to perform many of the common processes and functions in the Fast Excel Development Method.

Click here to see a live demonstration which uses the Development Template to build a Material Availability tool from scratch in less than ten minutes.

Here is an article from October 2020 which describes the new features in the Template Version 4.0.

Here is an article from May 2023 which describes the most recent features in Template Version 4.3.

Registered users can use a download link below. Register for free here. If you are registered, you can log in here.

Dynamic Named Ranges

Query Template

Stack Template

Dynamic Named Ranges are designed to stretch and contract to perfectly fit the data.  The Development Template automates this to eliminate the need to define multiple names and formulas.The Query Template brings in data from other sources and performs calculations.  It creates names and updates the sheet at the click of a button.  This is the interface to the host ERP/MRP system.The Stack Template takes multiple tables with comparable field and appends them together.  It can automatically append tables with ten thousands of rows and calculate in seconds.

Table Template

Pivot Template

ModuleList Template

The Table Template creates a table with a specified number of rows.  It is often used to Explode Tables and create a one-to-many relationship.  It can also be used to filter and replicate source tables of data.The Pivot Table Template extends native Excel pivot tables to automatic Named Ranges. It can leverage the blazing speed of pivot calculations, perform more and then present the results as a named table.The ModuleList Template enables you to run other workbooks without opening and interacting with it manually. This unlocks some powerful techniques for building modular systems with multiple workbooks that run faster and more reliably than single workbooks.

No Code Automation

No-Code Automation is a way to build macro-automated workbooks without using any VBA coding. Interact with familiar spreadsheets and formulas and then automate at the click of a button.

1 thought on “Development Template”

Leave a Reply

Scroll to Top