You could do this fairly simply in Excel using some dropdowns coupled to lookup tables and a relatively straightforward formula. Indeed, the dropdowns can even be made dependent, so that invalid combos can't be selected.
For an idea of what can be done, see the attachment to my post at:
https://www.msofficeforums.com/excel...drop-down.html