This program pulls data from a database and inserts values into an excel spreadsheet for our CSR's. Currently it calculates a column for three month sales, and at issue is the need for it to calculate a column for one month sales , while accounting for the fact that products which begin with a 17 prefix are the same as items with a 14 prefix. The code is a bit of a mess, so cleaning it up to use functions and classes would also be a plus.
## Deliverables
Source attached