I am trying to find a formula to calculate an amortization schedule where the
interest is compounded semi-annually rather than monthly (that's how we do it
in the Great White North).

There are lots of amortization templates but they all seem to calculate
interest on a monthly compounding basis.

Any help would be appreciated.