need to create or/and customize a report using excel VBA script.
You should be able to take data in an excel sheet and apply a few conditions.
you should know how to apply linear decay model in excel.
See this. These are the conditions.