WERS Search:

– 2nd sheet depends on data from the first sheet
– 2nd Sheet uses conditional formatting

Deflection Calculator:

– Heavy use of Excel name manager
– Heavy use of a weird way to get the pictures to change via the dropdown
Not sure how it actually works, but I followed this website to implement it:
https://www.extendoffice.com/documents/excel/4025-excel-dynamic-image-in-cell.html
– Toggle for hiding/showing strength chart (Conditional Formatting)