Feature Tour

Define models using typed fields (TextField, DateField, PositiveIntegerField, etc.)
through a built-in user form interface.

The Addin generates required class modules, constructors, and Getter/Setter
properties automatically, allowing you to work with records as real objects
instead of raw worksheet rows.

Once a model exists (e.g. ApartmentUnit with number_beds, square_feet, rent_asking),
records can be created immediately.

All Getter/Setter procedures are fully wired by default, allowing instances to be
created, read, and updated without manual VBA plumbing.

Records can be sorted by one or more fields, including relational fields
(ForeignKey), even when the sort column lives on a different worksheet.

This allows expressive, database-style ordering while remaining entirely
Excel-native.

Basic field types enforce value correctness at the object level, reducing the need
for repeated defensive checks throughout your code.

Available field types are listed here.

ForeignKey and ManyToMany field types are supported, enabling expressive access
patterns such as property.amenities.all().

Relational fields allow models to reference one another without duplicating data,
bringing database-style relationships into worksheets.

FormulaField represents values calculated from worksheet cells. This allows your records to have

Some values do not belong to any specific model but still need persistence.
The Setting Registry stores these values on a hidden worksheet with zero VBA edits.

Settings persist with the workbook itself, unlike Windows Registry storage, which
is machine-specific and not portable.

The Addin ships with several built-in procedure runners that manage execution,
error capture, and reporting consistently.

In essence, write a test function, and the Addin will discover and execute it whenever
the "Test Workbook" Ribbon button is clicked. The benefit is you don't have to wire anything. You only write the test, validation, or reset function.

ErrorBank is the foundation for testing and validation. It provides expressive
assertions such as AssertGreaterThan and rich failure messages that include
context and values.

Multiple ErrorBanks can be merged together, which is how runners aggregate results
across procedures.

The Addin provides generic ListView, EditView, and CreateView forms for interacting
with records.

Given a model and list of fields, the Addin renders compatible input controls,
validates submitted values, and highlights violations directly in the form.

These forms are particularly useful for relational fields, where users must select
from related records.

They are intended as a starting point rather than an end state.

When building custom forms, submitted values are available immediately and can be
assigned directly to model properties.

Invalid assignments (e.g. assigning text to an IntegerField) fail loudly, while
bulk pre-validation can be requested before saving any values.

Type enforcement, validation, and persistence are handled centrally, eliminating
large classes of repetitive worksheet code.

Generic forms are built on top of FormBuilder. FormBuilder is also exposed
directly for advanced use cases.

Unlike generic forms, FormBuilder allows inputs to save into multiple models
at once, making more sophisticated workflows practical.

The refactoring tool performs coordinated renaming across VBA code, modules,
range names, and worksheet cells.

Think of it as a workbook-aware Find and Replace with context.

The Fixture Registry saves named text blobs using Base64 compression on hidden
worksheets. Text is decompressed transparently when retrieved.

Fixtures help keeps workbook size manageable and enables the programmatic test runner to execute, even when
your VBA project is locked.

Row and column visibility can be controlled programmatically as part of larger
procedures or runners.

An experimental mechanism for intervening in AI prompts.

More inspirational than prescriptive at this stage.

Displays progress feedback during execution.
Adds runtime overhead but improves perceived responsiveness.

Provides fine-grained timing beyond VBA’s built-in timers, allowing side-by-side
performance comparisons.

Converts numeric currency values into written English. Useful in valuation and reporting contexts.

ATTRIBUTION: this was obtained (and minimally adapted) from: www.ExcelDataPro.com

Some GIS features use Google API keys, which are free under generous limits.
All GIS capabilities are usable without paid services.

Geocoding transforms a street address into latitude and longitude coordinates,
which serve as the basis for other GIS operations.

Requires a Google API key.

Given two coordinate pairs, distance is calculated mathematically using the
Haversine formula.

This avoids API calls but loses precision over longer distances.

Converts coordinate lists into KML map files for Google Earth.
Pins can be styled with colors, labels, and descriptive hover text.

Extracts coordinate data from polygons defined in Google Earth.

Primarily used with point-in-polygon operations.

Determines whether coordinates fall within a defined polygon.
Useful for zoning, environmental studies, and property analysis.