Greg, thanks for the super clear response. I've updated my spreadsheet based on your feedback.

For the life of me, I can't tell what is "shiny" about the C&J hat. If you have time, feel free to clarify.