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

Taidot: Excel, Python, Tilastotiede, Visual Basic

Näytä lisää: 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

Tietoa työnantajasta:
( 17 arvostelua ) Dartmouth, Canada

Projektin tunnus: #19769836

Myönnetty käyttäjälle:


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

$15 USD 1 päivässä
(139 Arvostelua)

8 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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 Lisää

$25 USD 1 päivässä
(12 arvostelua)

Hi, I am interested in your offer: Excel VBA code. Let me know more details about this work. I will start working immediately :) Br

$25 USD 1 päivässä
(23 arvostelua)

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 Lisää

$30 USD 0 päivässä
(7 arvostelua)

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 Lisää

$50 USD 1 päivässä
(2 arvostelua)

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 Lisää

$15 USD 1 päivässä
(0 arvostelua)

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 Lisää

$20 USD 1 päivässä
(0 arvostelua)

PROFESSIONAL SUMMARY ــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــ Trustworthy Accountant With over 8 years Lisää

$10 USD 1 päivässä
(0 arvostelua)