Mercury Injection Capillary Injection Program (MICP) measurement report for one well and another well has the different data format from time to time and from one company and another company. And this measurement data is needed to be standardized so it can be read to another program. By doing this manually, it can cost a lot of time and effort. So I tried to develop a desktop application based on python that can be read all MICP report format universally and then standardized the data format so it could be read and the process by another program. This software not only can read one excel document with multiple sheets, it also can read multiple excel workbook with the same format at the same time. So it can be more efficient and effortless for the user to do data formatting.
Skills: Python, Numpy, Pandas, Microsoft Excel, PyQt5