Run a macro tool developed in excel - Might require Office 365
Budget: $10 – $30 USD
I have
537 models * 1759 records = 944,583 records
Assuming 1 sec per records = 15,743 minutes = 262 hours = 10 days max
If your computer is running at higher speed usually 0.5 sec per record, it might take around 4-5 days per company data set.
You will need to disable sleep mode on your computer and let it run over night to achieve this.
Preferably for those with additional laptop that can run this separately without affecting your existing work as once you run the macro, you will not be able to use excel for any other work.
For each data set, i have 5 models to run. All you need to do is to click the run button and that's all you need to do. Hence for a company data simulation completion, it will take likely 15-20 days
I am looking for 5-10 person running each company data set for this project.
537 models * 1759 records = 944,583 records
Assuming 1 sec per records = 15,743 minutes = 262 hours = 10 days max
If your computer is running at higher speed usually 0.5 sec per record, it might take around 4-5 days per company data set.
You will need to disable sleep mode on your computer and let it run over night to achieve this.
Preferably for those with additional laptop that can run this separately without affecting your existing work as once you run the macro, you will not be able to use excel for any other work.
For each data set, i have 5 models to run. All you need to do is to click the run button and that's all you need to do. Hence for a company data simulation completion, it will take likely 15-20 days
I am looking for 5-10 person running each company data set for this project.