Data Optimisation/Data Analysis Project - Excel Solver

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.

Taidot: tietojenkäsittely, Excel, Matematiikka, Tilastoanalyysi, Visual Basic

Näytä lisää: excel solver youtube, excel solver examples optimization, excel solver for dummies, how to use solver in excel 2010, excel solver example problems, how does excel solver work, how to use solver in excel 2016, excel solver add in, proposal data analysis project, import data project excel, data entry project excel vba, data analysis project soap, getting data project excel, spss data analysis project example, customer data analysis project report, spss data analysis project, project excel data macro, pull project data project excel, sms data analysis project, data presentation analysis project

Tietoa työnantajasta:
( 0 arvostelua ) Fawkner, Australia

Projektin tunnus: #18090950

Myönnetty käyttäjälle:


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 10 päivässä
(71 Arvostelua)

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


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

$250 AUD 4 päivässä
(303 arvostelua)

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

$200 AUD 2 päivässä
(148 arvostelua)

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

$150 AUD 3 päivässä
(49 arvostelua)

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

$250 AUD 4 päivässä
(37 arvostelua)

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 10 päivässä
(38 arvostelua)

Hi I am here to assist u inthis project I am an ACCA U.K member currently working in finance dept of a leading airline of the world I have more than 4 Years of accountancy and finance experience and have great skill Lisää

$250 AUD 5 päivässä
(23 arvostelua)

Hi, bro! I've read your requirement. I have rich experience with data processing using Excel formulas and macro. I have finished many projects like this. I'm confident in your project and I promise to do your pro Lisää

$150 AUD 3 päivässä
(12 arvostelua)

How are you, Dear sir/madam? It's very worthwhile chance for me to let you know my skills and proposal about this project. I am an honest developer who have rich experiences in Excel, Data Processing, VBA I have Lisää

$200 AUD 10 päivässä
(1 arvostelu)

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

$150 AUD 10 päivässä
(1 arvostelu)

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 2 päivässä
(1 arvostelu)

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 10 päivässä
(0 arvostelua)

3 days

$166 AUD 3 päivässä
(0 arvostelua)

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

$222 AUD 7 päivässä
(0 arvostelua)

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 3 päivässä
(0 arvostelua)

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 1 päivässä
(0 arvostelua)

Very strong and professional in excel

$222 AUD 10 päivässä
(0 arvostelua)
$388 AUD 10 päivässä
(0 arvostelua)

Hello, I have seen your attached file. The task is clearly understood. I am a Excel professional. I am doing Excel work for 8 years now. I am multi tasking, Detail oriented and a Self-motivated person. I assure you Lisää

$222 AUD 10 päivässä
(0 arvostelua)
$222 AUD 5 päivässä
(0 arvostelua)

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

$222 AUD 10 päivässä
(0 arvostelua)