ISpatialTables

Defines the public contract for the SpatialTables class. Exposes a check for existing spatial ListObjects and a method to create new spatial table sets on the "spatial_tables__" worksheet at linelist build time.

Methods

Add #

Create spatial ListObjects for the current cross-table

Signature:

Public Sub Add(ByVal formObject As IFormulas): End Sub

Creates a set of ListObjects on the "spatial_tables__" worksheet for the current cross-table row variable. For geo-type tables, four admin-level tables (adm1 through adm4) are created with formula, population, and attack rate columns. For hf-type tables, a single health-facility table is created. Skips creation when the tables already exist.

Parameters:

  • formObject: IFormulas. The formula object whose parsed expression is written into each spatial table formula column.

Exists #

Whether spatial ListObjects already exist for a variable

Signature:

Public Property Get Exists(ByVal varName As String) As Boolean: End Property

Returns True when the spatial worksheet already contains the full set of admin-level ListObjects (four for geo-type, one for hf-type) for the specified variable name. Used to avoid creating duplicate tables during the build loop.

Parameters:

  • varName: String. Fully qualified spatial variable name (e.g. "cases_sp1").

Returns: Boolean. True when the spatial ListObjects already exist.