Completed

Simple Excel function. Script to run multiple iterations of a sheet and record the data

I have a sheet with a simple macro to randomize a sequence of returns, and display the results. There is a button to run the macro once, and only one macro in the sheet. The results I want to record are in F4:T4 Here is the sheet: [login to view URL]

I want a simple script to run this simulation repeatedly (I would select the number of times, likely 50-1000, collecting each set of results as a new row on the another tab. I'd like a header section on the new tab that is showing me some statistical analysis of these results - average obviously, but maybe a couple other simple analysis as well Median? Std Dev? (not too worried about that part, and I could add those later). Main thing is the script to run these sheet multiple times and display the results.

I think this is a very simple job, just would like someone to whip it up for me

Skills: Excel, Python, Statistics, Visual Basic

See more: iterative calculation excel, how to auto populate in excel from another worksheet, enable iterative calculation excel 2016, excel autofill formula, excel autofill cell based on another, timestamp in excel that doesn't change, excel formula timestamp when cell changes, iterative calculation excel 2016, can vba script run outside excel, simple excel vba script, excel web script sheet, script run excel macro, script create multiple accounts using excel file, excel vba automatically run script, mysql run multiple script files, verify sheet name exists excel using script, script create multiple users excel, macro script read multiple cells excel, mysql script run multiple scripts, schedule vbs script run excel macro specific time day

About the Employer:
( 19 reviews ) Dartmouth, Canada

Project ID: #19769836

Awarded to:

vlayausa

Hello, I am proficient with Excel and VBA. I would love to help with this project. Please contact me for more information.

$15 USD in 1 day
(140 Reviews)
5.8

7 freelancers are bidding on average $24 for this job

BestService222

Hi, How are you? I am very interest in your project. As I am a professional Expert with great experience and skills, I am sure that I can help you I'm ready to start to work on your project right now. If we clarif More

$25 USD in 1 day
(19 Reviews)
4.5
KimHyokJun

Hi, glad to bid on your project. I have 7+ years experience of c/C++ development and also VB. It is not difficult for me to help you. I wish your good response for me. If you choose me, I will complete it successfu More

$50 USD in 1 day
(4 Reviews)
3.4
sunshine7677

Dear Client, I am Expert in Excel Macro. I have 5+ Years of Experience in Data Entry, Web Scrapping, Web Research and MS Office. I will be there during your working hours to provide support whenever you need. Let’s More

$30 USD in 0 days
(8 Reviews)
2.9
zubi125

Hello! I would absolutely love to do this project. As I have no work to do these days, I can start immediately and finish as soon as possible. I can assure you of a 100% accuracy, as I am very patient. This would be a More

$15 USD in 1 day
(0 Reviews)
0.0
optimagp66

Good time of the day, Sir! I would like to apply for the project. My Portfolio: - Gyroscope Health -innovative app, written using react native, that tracks your health, food, sleeping habbits. (DM for URL) - Startup More

$20 USD in 1 day
(0 Reviews)
0.0
hosamhos2002

PROFESSIONAL SUMMARY ــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــ Trustworthy Accountant With over 8 years More

$10 USD in 1 day
(0 Reviews)
0.0