A have had a few requests for a test automation spreadsheet to use to help with assigning the business value and test complexity and calculating priority. This particular spreadsheet is very simple, but if there is any actual interest, I may provide a more complex and feature-full template.
Enjoy, but please use at your own risk .