Knapsack - Optimize Save within Defined Payback Parameter

This project is similar to knapsack ([url removed, login to view]). I have a list of 20 - 80 projects. For each project, I calculate the implementation cost, the annual Savings the project will produce when implemented, and the Simple Payback (Cost / Save) for each project.

The objective is to include or exclude projects. The algorithm must maximize the Sum of the $ Saved for all projects included while monitoring as a constraint a Payback value that does not exceed a user defined value i.e. 2.0, 2.5, 3.0 ... Projects with a Save of $0.00 would be eliminated. Payback will always be >0.

Because this is an intermediate step in our process the results are contained in Excel. The results of the routine must be created or moved to excel in the form of a TRUE or FALSE value for each project (where TRUE = include project in result and FALSE exclude project)

Compétences : Excel, Mathématiques, Analyses statistiques, Statistiques, Visual Basic

en voir plus : intermediate excel, en save, 2 sum algorithm, sun identity manager find user form result, save google apps user accounts mysql, save facebook api user quize results information, asp save form result excel, google analytics user defined url parameter, save irc channel user list mysql, external user account creation sharepoint projects, save image table sql server 2005 using parameter, save text file user machine

Concernant l'employeur :
( 1 commentaire ) Chino Hills, United States

Nº du projet : #8518052

Décerné à:


Hello. I got a better solution for total payback <= 2: NOT selected projects: 18, 19, 23, 27, 32, 34, 36, 37, 41, 44, 52 Total saved = 105409.4 Total cost=210480.7 As I wrote in the previous post (I believ Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 2 jours
(5 Commentaires)

13 freelance font une offre moyenne de $171 pour ce travail


Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 250 projects. Please look at the feedback left by my employers to know more about my work. Wai Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(73 Commentaires)

Hello Sir Im excel VBA macro and formula Expert :) i can do anything in excel Sir via VBA macro :) please give me a chance for doing your job and im able to start doing your job right now :) Thank You SIncerel Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(127 Commentaires)

Hi, I have strong background in Research, Reporting, Statistics, quantitative and qualitative analysis and experience in SPSS. Let me help you. Daily writes scientific papers, and I'm used to technical language. I am r Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(30 Commentaires)

Hi, This is Santhosh from India. I am a Business Management Graduate with Computer Science engineering background who is passionate about Data, Mathematics and Technology. I have worked in few data analytics pro Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(19 Commentaires)

Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 40 projects, almost 35+ are complex VB/VBA projects, hence i can definitely deliv Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(33 Commentaires)

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(29 Commentaires)

I have worked on many problems in integer programming and optimization.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(2 Commentaires)

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(5 Commentaires)

Hello, I am expert in Excel, Visual Basic,... I have a lot of experiences in many fields. I can help you well. Please contact me. Best regards.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(16 Commentaires)

Hi, I am a Mechatronics and Control Engineer, you can check my work on my blog [login to view URL] , I am expert in Programming languages and have designed many such projects. I have also posted m Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(6 Commentaires)

Hello There, Greetings for the day & hope you are doing fantastic. I have gone through your project requirment and very much confident in getting it done. Please have a look at our works: *[login to view URL] Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 20 jours
(2 Commentaires)

Hello, in interesting into your project which match with my experiences. I placed bid for your consideration. I'm excel coder, with 3year+ experienced in excel coder & formulas I am very confident that i will deliv Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(2 Commentaires)

thank you for your posting. your task is very happy for me. bz i have solved Container Loading Problem, CLP is similar your task(KP) if you hire me, i will complete project ASAP. best regards.

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

Aucune proposition n'a encore été fournie.

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

I am an engineer in operational research and decision support I have a good command of knapsack problems, ordonnacement and planning. with regard to your project I can model the problem of rigorous way and give a solu Plus

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

Hello Sir I'm really glad to read this offer,in fact, i already do a semilar project in my study,I'm an enginieer in statistics and i can do it perfectly :) Best regards

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(1 Évaluation)