Challenge #386: Shed Light on a Bank’s Risky Business

[hannah_malek]

Thanks for picking up these discrepancies!! I will have these records updated shortly :)

[gawa]

Some record have thresholds overlapped each other, but was it also a part of challenge??

Anyway, result matches

Spoiler

[JereJussila]

Spoiler

Fun challenge !

[TDouheret]

Spoiler

My solution:

[Pheline]

C386

[alacoume]

A solution:

[jacobcarman]

Spoiler

Decided to recreate lows and highs due to data issue.

[rachel_lynch]

Great use for the dynamic replace tool in a batch macro! There is one record that I believe may need to be double checked in the source data - the parameters are duplicated (i.e. amber is >= .03 and green is <=0.03 - it can't be both, one should drop the "="). 

Spoiler

 

[TonyAndriani]

This was a fun one. Went the macro route and worked with the Threshold columns to make it a little more interesting. Giving us the parsed limits pretty much turned this into a beginner-level exercise and didn't seem particularly realistic.

Spoiler

The overlapping thresholds was a nice touch. In the real world, when someone asks us to do an analysis the requestor usually doesn't give us a complete set of requirements (often they don't completely understand the requirements themselves). We have to inspect sample outputs and ask a lot of questions. With these weekly challenges, we can't ask questions but we can look at the output. In this case, we see that we have to evaluate the green threshold first, then amber, then red. (I evaluated red just in case there was a situation where a number fell outside the range of all three thresholds so I could flag it as an out of range error.)

[Sunny_Anand]

My solution