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

I have a sheet with a simple macro to calculate results, based on a number of input variables combined with a randomized series, and then display the results. I have a button to run the macro once, and only one macro in the sheet. The results I care about are then displayed in 14 cells, F4:S4

I want a simple script/macro 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 another tab. I'd like a header section on the new tab that is showing me the average for each of these columns, and also displayed in F8:S8 on the first worksheet. There may be a couple other useful analysis to see here Median? Std Dev? (not too worried about that part, and those could be added later in extra time). Main thing is the macro to run this sheet multiple times and display all the runs, plus the summed results on that second sheet, and also F8:S8 on the first worksheet.

Slight twist - most of the inputs will be the same for each of the 50-1000 runs, but there is one cell of information in the output of each run that is a primary piece of information required for calculation of the next run - this is where I get stuck. If you want me to know you have read the job description, please include the word 'carrot' in your offer.

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

A NDA will be required, as will demonstrated competence in spreadsheet models and Excel.

Once done if we work well together, I will want to expand this model with more complex variables and base conditions.

Taidot: Excel, Excel Macros, Tilastoanalyysi

Tietoa asiakkaasta:
( 23 arvostelua ) Dartmouth, Canada

Projektin tunnus: #34320534

Myönnetty käyttäjälle:


Hi, I'm Confident I can do this Job. I am an Expert in using Excel and Performing Calculations as I have finished 3 Nanodegrees from UDACITY for Data Analysis using Excel and Python, In Addition to applying Similar Pr Lisää

$30 USD 2 päivässä
(2 Arvostelua)

31 freelanceria on tarjonnut keskimäärin $135 tähän työhön

(513 arvostelua)
(224 arvostelua)
(377 arvostelua)


$400 USD 7 päivässä
(18 arvostelua)
(117 arvostelua)

"""""""""""""""EXCEL FUNCTION"""""""""""""" "Sir, I am Excel VBA Macro Advanced Level Expert. This is basic work for me. I can complete this project with added quality. About me I am a Chartered Accountant with more Lisää

$88 USD 1 päivässä
(187 arvostelua)
(113 arvostelua)

Hello Sir , Iam excel expert level with top rating done projects before I can done this within short time also i can provide previous samples for make you understanding better about me and my skills. When do you need t Lisää

$156 USD 3 päivässä
(145 arvostelua)

Senior Excel vba, macros expert. I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you a Lisää

$140 USD 1 päivässä
(142 arvostelua)

Carrot!! , I have read your job description very carefully, I will create you script as per your requirements to run multiple iteration based on the no: of iteration selected, populate the result of each iteration into Lisää

$50 USD 1 päivässä
(32 arvostelua)
(9 arvostelua)

"Dear Client, I specialize in Word or Excel VBA / Macro solutions and Web Scraping/Data Mining for your Excel workbooks. I will perform any tasks in Excel to automate your business. VBA macros, custom forms, charts, ta Lisää

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

Carrot Hi I've read the project description carefully. I'm an expert in Excel VBA. It would be a great pleasure for me to have the opportunity working with you. ✓ Looking forward to hearing more about your project via Lisää

$100 USD 2 päivässä
(4 arvostelua)

[login to view URL] [login to view URL] [login to view URL] Lisää

$250 USD 7 päivässä
(5 arvostelua)

Hi there, Your Excel Specialist is here Graduated from London; United Kingdom in Investment & Finance; Risk Management. I have done various VLOOKUPS, Macros, Data Analysis, Sorting of data, VBA, Hyperlinks and etc. Lisää

$30 USD 2 päivässä
(3 arvostelua)

Statistics I am an expert professional in Statistics and dissertations with skills including Statistics (SPSS), Statistical Analysis, Statistics, STATA/SPSS/R/Python program Mathematics, and Statistics report Writing. Lisää

$50 USD 1 päivässä
(6 arvostelua)
(1 arvostelu)

✅✅✅ Experiences in Excel Formulas and Macro✅✅✅ Hi, Dear! I have a full experiences and knowledge in Excel Formulas and Macro. I read your requirement carefully and so I can do your work perfectly. I can start Your wo Lisää

$150 USD 3 päivässä
(6 arvostelua)
(1 arvostelu)

Hi, I checked your requirement, This is awsome work for me because i have Experience in below technical work. Power Bi Desktop & Services With DAX, Power Editor, Excel VBA, Power Query, Power Pivot, Advance Excel, Lisää

$129 USD 4 päivässä
(2 arvostelua)