Advansis advised on the drivers that should be analysed behind price erosion and advised on how they can be computed from data. We created an Excel and SQL based solution to store, track, analyze and report erosion data.