Deliverable: Build a 2 variable model based on the requirements below. The model should work if the raw data changes.
Max bid amount should be around $10 only.
Along with bid send me your strategy.
In an excel with 10 columns - there are 2 calculations that have variables. One variable is multiplication factor and another one is the denominator that is used for average calculation. These two values need to be optimized so that "pass" percent is the highest. Pass/Fail are in a different column.
Average Value 5
Optimize for Average value and multiplier so that Pass values are highest.
Formula for Multiplier is shown below. 1.2 is the multiplier that needs to be optimized
Multiplier ((I7) >(1.2* J7),G7,"F")
The value 5 is the variable that needs to be optimized.
Average Value SUM(I2:I6)/5
19 freelancers are bidding on average $18 for this job
hello I am Rajesh having 15 years of experience in Excel including the optimization part. I will use solver for your work. You can ping me for the chat. Thanks.
i have deep knowledge and experience in excel optimize with macro vba excel. i have my own excel pit optimizing that will detemine what what optimum striping ratio that we need