The financial reporting application need to be developed in which there will be 100 Excel files of different countries of 1.5 MB each and user has the interface for selecting any country say in dropdown and provide the 6 parameter values through the interface (textboxes) and these parameters get replaced in a sheet in excel file for that country. This excel file has many sheets, with excel formulas in all [url removed, login to view] the parameter values gets replaced in one sheet the corresponding calculations will get recalculated and target value will change which will then need to be read from excel programmatically and then shown to the user. Rather than directly changing the values in excel, user will change the values
through the interface.
Please provide the cost estimation, time estimate and solution approach you would be following because there will be 1000 concurrent users and each user will have the dedicated set of 100 excel files so that the calculations of one user does not affect the other user. Considering the server bandwidth, Server RAM and space constraint the solution approach should be in line with these. I am going for the normal shared hosting. The solution approach should be functional in that environment.