Match True up template in excel

[Jack Cosgrove]

Does anyone happen to have an excel spreadsheet template that would calculate match true up on a bi-weekly payroll basis, instead of an annual basis?  Match is .50 for every dollar match up to 8% and payroll is bi-weekly.

[Doghouse]

It relies on the payroll to limit deferrals correctly, but this one is based on 50% of the first 6%...

Match.xlsx