OP: Your methodology will not find the optimum shift patterns, which depend on conditions, exertion and some other stuff not in your spreadsheet. If you ride a lot more you will find them by experience and intuition.