< All Topics
Print

Embedded Constants

Excel lets you put numbers into a formula, but this is rarely a good idea. To quote from the FAST standard:

“…Embedding commercial information, for example an inflation rate, is never a good idea, as both clarity of model assumptions and active parameterisation are lost.

However, not all embedded inputs are created equal. Embedding a 24 (for 24 hours per day), 12 (12 months a year), 1000 (dollars in $ 000s) is permissible, even sensible.

Other standards and best practice guides take a similar approach.

Openbox therefore warns you about any formula that contains a number. You can choose to ignore the message.

Leave a Reply

Your email address will not be published. Required fields are marked *

Your Cart

No Item Found
Subtotal 0.00
Shipping 0.00
Tax 0.00
Total 0.00
0