Data Optimisation/Data Analysis Project - Excel Solver

$150-250 AUD

In corso

Pubblicato

più di 5 anni fa

$150-250 AUD

Pagato al completamento

We have a spreadsheet that needs to be optimised and verified for the best solution, possibly using Excel Solver. Please see the attached for reference, there are 10 input variables (Rows 2-11) and 10 output variables (Rows 138-147). The input is subjected to 1 initial Vlookup (Rows 37-51) and 3 Multiplier matrices (Rows 66-75, 90-99 & 114-123). Our aim is to adjust the Multiplers (Highlighted in Yellow) and format of the formulas/workings to have very minimal difference in each output case when compared to the Comparison results (Rows 138-147 & 162-171). Target is for Rows 174-180 & 183 to be closest to 0, and Rows 181-182 closest to 4. One solution is required for all test cases (Columns C-K). Once completed, Columns L & M will be tested. Each variable impacts on the output differently, and there are matrices in separate sheets that determine each factor. You may be required to edit formulas, multipliers, structure of calculations and matrices. A high level of experience in Excel and Data Analysis is favored.

Rif. progetto: 18090950

Info sul progetto

21 proposte

Progetto a distanza

Attivo 6 anni fa

Hai voglia di guadagnare un po'?

Indirizzo Email

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze

Fatti pagare per il lavoro svolto

Delinea la tua proposta

La registrazione e le offerte sui lavori sono gratuite

Assegnato a:

@rinabuoy13

Hello, I am experienced excel expert in solver. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards

$166 AUD in 10 giorni

5,0

(124 valutazioni)

6,3

21 freelance hanno fatto un'offerta media di $200 AUD

@schoudhary1553

Hello, Hope you are doing well. I can help with you in your project Data Optimisation/Data Analysis. I can assure you the quality job. I have good experience in Data Processing, Excel, Mathematics, Statistical Analysis, Visual Basic. We have worked on several similar projects before! We have worked on 400+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,

$250 AUD in 4 giorni

4,9

(371 valutazioni)

8,0

@best4best

I am an excel expert and ready to start the project.

$200 AUD in 2 giorni

5,0

(164 valutazioni)

6,4

@c4cuteconain

I am a professional accountant with a decade of experience working in a US based NASDAQ registered company's finance department with excellent excel skills and knowledge.

$200 AUD in 10 giorni

4,9

(80 valutazioni)

5,8

@rajeshkumararora

Hello – I am having a PhD in and have 15 years’ experience in doing Excel projects that include VBA, distributions, analysis, solver, etc. Please provide details of your work. I am highly qualified for this project and would like to speak with you further about taking this project on. If you'd like to view my previous work along with excellent feedback from my employers, take a look at my Freelancer Portfolio. Thanks.

$150 AUD in 3 giorni

4,9

(59 valutazioni)

6,0

@ferozstk

Hello, After reading your project details I believe I'm suitable for this project. As I'm expert on this kind of project with more than 5 years experience. Please feel free to contact me. I am looking forward to hear from you. Best regards

$250 AUD in 4 giorni

4,8

(47 valutazioni)

5,8

@herguz2017

Greetings dear employer. Can you give me more details of your project? In the attached file it can be understood that it is an optimization problem with 10 input variables and 10 output variables, Maybe you should do some regression calculations and minimize some outputs to adjust them to the range that the problem requires, but it is necessary to know more about the project. I believe that I can help in the solution of the problem, I am an expert in data analysis and excel, I have more than 20 years of experience as a university professor, and I am currently retired and with a lot of time available. I am using this free time to do freelance jobs. Msc. Hernando Guzmán Jaimes. Maracaibo Venezuela

$150 AUD in 10 giorni

5,0

(8 valutazioni)

4,5

@vpr58e3445e03cda

We have gone through the requirements that you have mentioned and we will help you in this. Message us for further discussion. Feel Free to contact us. Thank you!

$150 AUD in 2 giorni

4,9

(2 valutazioni)

1,4

@matlabpythonwork

Hello Sir, I have experience in GRG nonlinear, simplex linear programming solver and evolutionary solvers in excel along with other ode solvers. I can complete the task in one day. waiting for your response, Narayana

$150 AUD in 1 giorno

0,0

(0 valutazioni)

0,0

@VIKKISANTANA

My dedication and attention to details is my greatest asset. I also challenge myself to finish the job earlier than the expected due date. Relevant Skills and Experience I have always been tapped by my previous employers to do tasks which are critical in terms of content and time.

$222 AUD in 10 giorni

0,0

(0 valutazioni)

0,0

@murthysundara18

Very strong and professional in excel

$222 AUD in 10 giorni

0,0

(0 valutazioni)

0,0

@jseroje

I have more than 7 years of actuarial experience involving manipulation of complicated Excel functions. With this experience I strongly believe I am very suited to this job.

$166 AUD in 10 giorni

0,0

(0 valutazioni)

0,0

@samihramzy

I'm a computer engineer and I have an excellent experience with excel formulas and data sheets, I have worked on similar projects before and I guarantee to deliver it quickly and efficiently.

$150 AUD in 1 giorno

0,0

(0 valutazioni)

0,0

@umabhatter

I am very proficient with Excel and data management. My wide knowledge of various formulas will help me to do your work efficiently and effectively. I've advanced skills in Excel to finish the job.

$150 AUD in 3 giorni

0,0

(0 valutazioni)

0,0

@jranik1

Hi I am a profession Statistician and Data Analyst working in an International Health Research Organization (icddr,b). As my job purposes I doing these. So, I am very much interested to do this. Thanks. Best Regards Jewel.

$222 AUD in 7 giorni

0,0

(0 valutazioni)

0,0

@amine9191

3 days

$166 AUD in 3 giorni

0,0

(0 valutazioni)

0,0

@MMSt

I have extensive expertise in optimization and working with Excel. I can try to solve your problem with both linear programming and some metaheurstic method.

$211 AUD in 5 giorni