Excel VBA macro calling Solver for simple optimization

  • Status Completed
  • Budget €8 - €30 EUR
  • Total Bids 16

Project Description

Write a macro that calls the Solver for an optimization.

Solver params:

- maximise one cell

- by changing 20 cells

- constraints

sum of the 20 cells =1

one max value for each modified cell

one min value for each midified cell

The example spreadsheet will be provided

This is a very small project for anyone used to Excel VBA and Excel Solver

Completed by:
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • รับการชำระเงินสำหรับงานของคุณ

จ้าง freelancer ที่เสนอราคาในโปรเจคนี้

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online