Thank you for your feedback. Your method will dramatically increase
the amount of cells I need per symbol and one of my primary goals is to
keep the main page as clean as I can. By this I mean only having one
row per stock symbol and keeping the rows short enough to avoid any
sideways scrolling.

By itself this constraint would make it impossible to fit all the
necessary columns I need onto one row, but is it possible to have
another worksheet used to hold all the temporary/working data?

What I mean by this is having each dropdown choice add its mapped value
to a cell in another worksheet. The score could then be calculated by
tally the columns in that 'Working' worksheet and returning the
cumulative score to the Score cell in the Main sheet. If this is
feasible, can this all be done without switching worksheets too?

TIA