Completed

optimize data in excel

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.

Background:

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

Multiplier 1.2

Pass 540

Fail 422

NA 1081

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

Skills: Excel, Visual Basic

See more: i need excel data entry, need excel data person, read excel data pass webform javascript, excel fetch data web site need log, need programmer importtext file excel data base, large excel data, simple visual basic application sort excel data, excel data processing home, read excel data using, excel data entry mail merge form, excel data web form, excel data import, excel data capture, find excel data using, excel data access database, visual basic code extract excel data, amibroker excel data, excel data formatting macro, excel data front end, excel data mining project

About the Employer:
( 33 reviews ) Erie, United States

Project ID: #12691748

Awarded to:

pgbhughes

This is a solver problem. So i would simply build the optimisation calculation and then any constraints to prevent divide by zero, and then run using Excel solver. Very quick and easy. Do this kind of work for breakfas More

$10 USD in 1 day
(13 Reviews)
3.7

19 freelancers are bidding on average $18 for this job

schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex More

$10 USD in 0 days
(193 Reviews)
7.1
ReflexiveData

Hi, Thanks for posting this project. Please check our website: [url removed, login to view] & reviews. For excel related projects please check our portfolio. I have worked on integrating excel, word, SQL database, Power More

$30 USD in 1 day
(13 Reviews)
5.3
KavTan

Hi, I am a professional freelancer with proficiency in EXCEL, and I can complete your task effectively and efficiently in a timely manner.

$15 USD in 1 day
(36 Reviews)
5.2
$25 USD in 1 day
(3 Reviews)
2.6
wxin02

Hi I am a experienced excel VBA programmer. Please contact me if you would like to. Thanks

$15 USD in 1 day
(2 Reviews)
2.8
rajeshkumararora

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.

$10 USD in 0 days
(3 Reviews)
2.1
prabirakalata

Dear Sir, I read this job's description understand that I am perfect for this job.I have lot of experience in this job. So you hire me for the project. f you hire me, I can completed this very carefully and satisfi More

$10 USD in 1 day
(3 Reviews)
1.8
faes013

A proposal has not yet been provided

$25 USD in 1 day
(0 Reviews)
0.0
Thisara1994

hello sir, i am an university student in university of colombo and i study statistics and computer science as my core cources. so analysis and excel representation will be easier for me. i am 100% confident with this More

$13 USD in 5 days
(0 Reviews)
0.0
AnimPriyam

i ll make it

$20 USD in 2 days
(0 Reviews)
0.0
ahmedtaher2020

A proposal has not yet been provided

$15 USD in 2 days
(0 Reviews)
0.0
doresframika

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

$25 USD in 1 day
(0 Reviews)
0.0
$15 USD in 1 day
(0 Reviews)
0.0
$20 USD in 5 days
(0 Reviews)
0.0
JulioSalazar

A proposal has not yet been provided

$15 USD in 6 days
(0 Reviews)
0.0
maxxsols2

Dear Client, Thanks for providing us opportunity to place bid over the project and communicate with [url removed, login to view] mainly deal in web development, SEO, Android App, software testing and graphic design. Our vision is to b More

$23 USD in 6 days
(0 Reviews)
0.0
fusionsoft4

Dear Client, Thanks for providing us opportunity to place bid over the project and communicate with [url removed, login to view] mainly deal in web development, SEO, Android App, software testing and graphic design. Our vision is to b More

$23 USD in 6 days
(0 Reviews)
0.0
VkShah1990

A proposal has not yet been provided

$20 USD in 3 days
(0 Reviews)
0.0