I have an Excel spreadsheet used as template which I need to convert the xls formulas in it to Python. There are about 6 formulas which gets repeated throughout the Excel sheet.
The need is to create a separate Python file that can interact with Excel. The calculations (using the converted xls formulas) need to get done in the Python. The results from the calculations should only show the results of the formula in certain cell in the xls sheet and not show the formulas itself. Must be able to convert the Python file to exe file.
The user imports data on a daily basis in to the Excel Data sheet from a csv file. The Python code must incorporate and calculate the added rows of data. The Data-sheet can grow up to 30 000+ rows in a month.
The user should be able to filter on data in Excel and the Python code must calculate the filter and return only the date as per filter applied.
The formulas are SUMIFS ABS(IF…) SUBTOTAL SUM
More detail and Requirements in the attached Excel sheet.