You're welcome.

There are various other allocation formulas in the workbook at https://app.box.com/shared/7xm2kt408n