Some of the feedback we received when we first released StrongTyping was related to the FAST modelling standard. An attraction of the FAST standard is that its 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.
Although we’ve incorporated the FAST modelling standard as an option for producing spreadsheet models, you may choose to apply your organization’s standard – which you are able to do with StrongTyping.
StrongTyping for spreadsheets applying FAST modelling video
An example of the way StrongTyping is changing can be seen in the video. You’ll will see how enhancements allow metadata to be applied automatically as a modeller 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 colour coded using the prescribed colour coding scheme. Then a few lines of a calculation sheet are created to illustrate how types are assigned automatically and, again, colour coding is applied.
So, no interruption to the modellers work, no extra key strokes, with metadata being created constantly and can be used by the modeller to verify the model at any time.
The option to apply metadata retrospectively always exists and remains the 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 modeller more time to focus on the real calculation requirements of the model rather than checking work for errors that have no need to appear.
The example illustrated in the video is part of the progression of Strong Typing and further enhancements will appear. For example, a list of values on the input sheet can appear in the task pane while the modeller is working on, say, a calculation sheet. Then the modeller 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 colours applied automatically.
So, now you know a little more about StrongTyping and the FAST modelling standard. The next step is to contact us so we can show you how you can create robust models. We look forward to hearing from you.
The StrongTyping team strongtyping@lyquidity.com
Comments