Automated 5g Function Testing

Description
Dynamic arrays are a revolutionary way to model with Excel. 5g functions take the hard work out of modeling with dynamic arrays. Before releasing 5g functions to clients or the public, we must make sure they are error free.

To make functions as error free as possible, 5g requires testing functions thoroughly. There are many ways to test functions. The method BXL uses most is randomizing the function’s inputs and comparing the function’s outputs to traditional formula results. If results differ the test fails, in which case either the 5g function, the traditional formula, or both may be wrong. We make corrections and repeat the tests. When hundreds of this type of tests pass, we consider the formula error free.

To automate testing, BXL uses BXL Tests.xlam. BXL offers BXL Tests.xlam for free here. It provides everything we need to generate thousands of randomized tests, a step by step users guide, and a video tutorial. 


To learn more about 5g see: 
https://www.eloquens.com/tool/jNDNHywy/finance/excel-lambda-functions/financial-starter-pack

To learn how 5g enables dynamic arrays in financial modeling see:
https://youtu.be/x_JaNxV0TGw

To learn how 5g can solve circularity in financial models see:
https://youtu.be/VHf0o-coxMA

To learn how 5g can cut model risk by a factor greater than 1,000 to 1 see:
https://youtu.be/pEzzBVG9WVE