Spreadsheet needed

the goal of this spreadsheet would be to balance my pretax and after tax deductions to my 401k, while also taking into account my taxable income and tax rate, mortgage insurance, property taxes, etc, so that when I file my taxes every year, the amount owed/refunded would be very close to zero. Obviously my salary is set for the year but I would have to make adjustments for bonuses, etc. I want to determine how much I should put into pretax 401k, versus Roth 401k while not jeopardizing taxable income which would cause me to have to pay at tax time. Company matches 100% of first 3%, plus 50% of next 2%, and also contributes 3% of base salary.

Anyone have a simple solution they can point me in the direction of