No Macro Experience - Need to run a loop (I think?!) over a set of data for multiple rows

Hi,

I have a spreadsheet containing 300+ rows, each row requiring its own individual output score. Within each row there a multiple columns which have drop down values and depend on what the user inputs. This is calculated by a bit of data which I don't want to have to copy 300+ times within the spreadsheet just to give a unique output for each row. So I can do it for one row, but then the next row changes the data and I would end up with the same score for every row.

I've never made any sort of macro so I'm a complete beginner (not even sure how you put a macro into your spreadsheet!) so apologies in advance if this is something that has been answered many times.

I've attached my spreadsheet, data is at the right side.

Thank you in advance.