you made this nice and easy indeed to earn steem rewards. I have a number of spreadsheets set up using named ranges, but most often I would use Table format and use a column name in a formula over a named range. I know you can set up dynamic named ranges, but with tables, if you reference them in a formula and update the table with more data, the formula updates too. with static named ranges this does not happen.
RE: Step by Step - Named Ranges in Excel