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.
24 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
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.
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!
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.
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.
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.