Terminé

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

en 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

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(13 Commentaires)
3.7

19 freelance font 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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(193 Commentaires)
7.1
ReflexiveData

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(13 Commentaires)
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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(36 Commentaires)
5.2
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(3 Commentaires)
2.6
wxin02

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(2 Commentaires)
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(3 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(3 Commentaires)
1.8
faes013

A proposal has not yet been provided

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)
0.0
AnimPriyam

i ll make it

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
ahmedtaher2020

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)
0.0
JulioSalazar

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 6 jours
(0 Commentaires)
0.0
maxxsols2

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 6 jours
(0 Commentaires)
0.0
fusionsoft4

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 6 jours
(0 Commentaires)
0.0
VkShah1990

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0