This is an academic research project I am doing. I need to get specific data from several excel worksheets and perform some calculations that although they run correctly are too cumbersome to complete. After these calculations are performed I need to collect the estimated data and post them to a new 'results' worksheet which i will be using for further estimations.
The major problem I am facing is that the matrix calculations on the worksheet are not only too time consuming to perform -through the code I have written- but also impossible to calculate unless I predefine the estimation sequence of each calculation. For making the calculations work I have written macros that estimate the calculations sequentially and this is the only way they can be performed.
I need to have the full worksheet calculated in a reasonable amount of time and create the macro commands that will collect data, estimate the calculations and post the results.
If this is something you may be interested to quote pls ask me to send you the files. For purposes of quoting me the price and time to be taken for this I will be sending you a 'workflow' document outlining the sequence of calculations and the excel spreadsheet(s) where the data will be received from as well as a model spreadsheet which includes all the macros and vba code I am using for the calculations.
Thx a lot and looking forward to your reply.