See attached excel spreadsheets for reference.