En cours

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

Compétences : Excel, Visual Basic

Voir plus : 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

Concernant l'employeur :
( 33 commentaires ) Erie, United States

N° du projet : #12691748

Décerné à :

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 Plus

10 $ USD en 1 jour
(7 Commentaires)
2.4

21 freelance ont fait une offre moyenne de 18 $ pour ce travail

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 Plus

10 $ USD en 0 jours
(84 Commentaires)
5.6
imransgd101

hi, I will provide you best service but sorry I can't share my startegy in proposal

12 $ USD en 1 jour
(95 Commentaires)
5.8
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 Plus

30 $ USD en 1 jour
(11 Commentaires)
5.1
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 en 1 jour
(22 Commentaires)
4.1
25 $ USD en 1 jour
(3 Commentaires)
2.6
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 en 0 jours
(3 Commentaires)
2.0
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 Plus

10 $ USD en 1 jour
(3 Commentaires)
1.8
wxin02

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

15 $ USD en 1 jour
(1 Commentaire)
1.4
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 Plus

13 $ USD en 5 jours
(0 Commentaires)
0.0
AnimPriyam

i ll make it

20 $ USD en 2 jours
(0 Commentaires)
0.0
ahmedtaher2020

A proposal has not yet been provided

15 $ USD en 2 jours
(0 Commentaires)
0.0
faes013

A proposal has not yet been provided

25 $ USD en 1 jour
(0 Commentaires)
0.0
15 $ USD en 1 jour
(0 Commentaires)
0.0
25 $ USD en 1 jour
(0 Commentaires)
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 en 1 jour
(0 Commentaires)
0.0
VkShah1990

A proposal has not yet been provided

20 $ USD en 3 jours
(0 Commentaires)
0.0
TECHENGINEERING2

Hi I am industrial engineer. More than 5 years experiences with MATLAB/ANSYS/SIMULINK/R/SPSS/EXCEL/SOLIDWORKS.... I can solve all your problem in the fiel of : mathematics, electrical engineering, mechanical engin Plus

25 $ USD en 1 jour
(0 Commentaires)
0.0
BellalHossain333

"Rate and duration will be fixed on discussion" Greetings, I have gone through your job posting and become very much interested to work with you. I am an expert in these fields. I have already completed several p Plus

25 $ USD en 1 jour
(0 Commentaires)
0.0
20 $ USD en 5 jours
(0 Commentaires)
0.0
JulioSalazar

A proposal has not yet been provided

15 $ USD en 6 jours
(0 Commentaires)
0.0