Automated 5g Function Testing
Originally published: 29/03/2024 09:06
Publication number: ELQ-84153-1
View all versions & Certificate
certified

Automated 5g Function Testing

How to automate testing 5g functions

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 thoroughly test them. 

To automate testing, BXL uses TestTemplate.xlsm. BXL offers TestTemplate.xlsm for free here. It contains a template for creating your own test, a step by step guide, a video tutorial, and VBA to automate generating hundreds or even thousands of randomized tests to help ensure our functions are as free from errors as possible. 

Want to see
https://www.eloquens.com/tool/jNDNHywy/finance/excel-lambda-functions/financial-starter-pack

How 5g enables dynamic arrays in financial modeling? See:
https://youtu.be/x_JaNxV0TGw


How 5g can solve circularity in financial models? See:

https://youtu.be/VHf0o-coxMA


How 5g can cut model risk by a factor greater than 1,000 to 1? See:
https://youtu.be/pEzzBVG9WVE

This Best Practice includes
1 Excel Workbook containing TestTemplate.xlsm

Craig Hatmaker offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Further information

Automate testing your 5g functions.

Tested on English Excel 365 for Windows.

Not tested with other languages or on MAC


0.0 / 5 (0 votes)

please wait...