3 ms·
This hits home. We upgraded a very massive Excel-based model to the peak of our best practice. Proper split in requirements vs. implementation, a separate data
by wjnc 2y ago
This hits home. We upgraded a very massive Excel-based model to the peak of our best practice. Proper split in requirements vs. implementation, a separate data quality layer, model validation on the model, Ze Kloud, etc. Turns out accountants don’t grok model validation and I am still explaining imputation on individual data fields to auditors expecting each individual value to be user inputted somewhere. Waving IAS8 in front of your auditor doesn’t help since you are threading on their expertise and that gets messy. Excel models turn out to be multi headed dragons, but you can mail a spreadsheet with five example cases and get by.