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 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.

Skills: Excel, Excel Macros, Statistical Analysis

About the Client:
( 23 reviews ) Dartmouth, Canada

Project ID: #34320534

Awarded to:

yousrymohamed11

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 More

$30 USD in 2 days
(2 Reviews)
0.5

31 freelancers are bidding on average $135 for this job

(513 Reviews)
7.9
(224 Reviews)
6.9
(377 Reviews)
6.8
liveexperts123

sfdgnsearghnfarehsfgarghfsagrwfegrhtsj,fhdhsejdkgfhljgdhterwaehrjdgkfhjhrtegahsjdfkhhrtergthsrjtfktryterhrjth

$400 USD in 7 days
(18 Reviews)
6.4
(117 Reviews)
6.5
AccountantArman

"""""""""""""""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 More

$88 USD in 1 day
(187 Reviews)
6.6
(113 Reviews)
6.2
PERPETUAL0

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 More

$156 USD in 3 days
(145 Reviews)
5.8
merinsinha

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 More

$140 USD in 1 day
(142 Reviews)
5.7
raoarslan56

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 More

$50 USD in 1 day
(32 Reviews)
5.3
(9 Reviews)
4.4
Maherun75

"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 More

$50 USD in 1 day
(14 Reviews)
3.9
anenkovakateryna

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 More

$100 USD in 2 days
(4 Reviews)
3.6
Crayon1365

[login to view URL] [login to view URL] [login to view URL] More

$250 USD in 7 days
(5 Reviews)
3.2
sikandarasif

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. More

$30 USD in 2 days
(3 Reviews)
2.6
salehinfaijus360

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. More

$50 USD in 1 day
(6 Reviews)
2.8
(1 Review)
2.8
torrikress2

✅✅✅ 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 More

$150 USD in 3 days
(6 Reviews)
2.9
(1 Review)
2.4
freelancer96500

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, More

$129 USD in 4 days
(2 Reviews)
2.4