We have an almost complete spreadsheet with a number of formulas (Vlookups, Ratio Multipliers, Matches) and variables that need editing and verification.
The spreadsheet works with 10 input variables, with a resulting 10 output variables.
Each variable impacts on the output differently, and there are matrices in separate sheets that determine each factor, along with multiplier ratios based on these matrices.
You will have 10 test cases (input and target output) to work with and the formulas/matrices will need to be edited so that each test case is equal to the target output.
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.
Please check attachment for example.
Some explanation: Each input test case (Located in rows 15-24) is pasted in column B separately to a resulting output figure (Column P). The output is then pasted in each test case outputs in rows 28-37. Rows 54-63 will then measure the difference between rows 28-37 and 41-50 (standardised results). This is where the target results are nearest to 0 with the exception of 4 for CL.
Our aim is to adjust the ratios and format of the formulas/workings to have very minimal difference in each output case when compared to the standardised results.
We will send the remaining 2 test cases once the spreadsheet has been updated so that we can test its accuracy, since there are only 8 test cases at the moment.
36 freelancere byder i gennemsnit $152 på dette job
I have taken a look at the file. I find very interacting formula and hence will take sometime to understand and edit, thus keeping a week as duration for this project.
As I have a direct experience with a project with similar settings and scope, I am able to realize the project in a very reasonable time and in the highest quality.