I need you to develop a crossreference between a MySQL database and a propietary software I have.
First there is an Excel file that is filled everyday by several of our customers, the file is imported into the software that updates information in the DB.
The information comes from electrical billing of municipalities around the country, and is needed to calculate ROI based on the energy consumption of each municipality.
The attached file is excel format to be filled, and then exported to a MySQL DB.
Any doubt or question feel free to ask.