We aim to implement updates to StrongTyping to make it increasingly easy to use. One of the ways has been using the FAST modelling standard – an attraction is that it’s structure admits a lot of scope for automated assistance in a way that is more difficult when compared with a model which uses a more arbitrary structure.

Recent enhancements allow metadata to be applied automatically as a modeler creates the elements of the model. First entries on an example inputs sheet are created. Type metadata are both created and assigned as the user enters labels and values. In addition, the values are color coded using the prescribed color coding scheme. Then a few lines of a calculation sheet are created to illustrate how types are assigned automatically and, again, color coding is applied. There is no interruption to the modelers work, for example no extra key strokes, but the metadata is being created constantly and can be used by the modeler to verify the model at any time.

The option to apply metadata retrospectively always exists and remains the only option when working with an existing workbook. By applying meta data as the model is created, several classes of error can be identified immediately leaving the modeler more time to focus on the real calculation requirements of the model rather than checking work for errors that have no need to appear.

This is part of the progression of StrongTyping and further enhancements will appear. For example, a list of values on the input sheet can appear in the task pane while the modeler is working on, say, a calculation sheet. Then the modeler will be able to select one or more values from the list in the task pane. When this is done, the corresponding labels and links can be added to the calculation sheet, metadata assigned and colors applied automatically.