Elaborate very large Excel files
I am Microsoft partner and software developer since over 20 years, with extensive experience in office automation (look at my portfolio). I have already developed software for large data processing (check out my portfolio), the attached image is relative to a project for annual hourly consumption forecasting. Of course, the files cannot be managed with Microsoft Excel, but I don't understand how can contain 30 million rows, since Excel from version 2007 onwards supports up to 1,048,576 rows and 16,384 columns (https://support.office.com/en-nz/article/Excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3). In any case, the amount of data is high, so I think it is necessary to process them as data source and transport them in a database, otherwise you are likely to get little reliable statistical calculations. You did not specify in what format must be returned the statistical data obtained. If you are interested in my proposal feel free to contact me on chat.
