VBA Excel solver replacement

This project was awarded to neilMT1 for $35 AUD.

Get free quotes for a project like this
Project Budget
Total Bids
Project Description

The existing Excel Spread sheet has an input data sheet and a calculation sheet to calculate a single total cost depending on five variables. The variables are independent of each other and can be individually optimised to minimise the cost calculation.

This has been optimised by using the solver tool but requires a VBA macro replacement to adjust the five variable cells (4 digits positive numbers) to minimise the value calculated in the cost cell.

The project requires a VBA macro to be written activated by a key stroke. No changes to the spread sheet is required. Once a Freelancer has been chosen, the Excel 2010 spread sheet will be sent for the macro to be added and stating the location of the five variable cells and the cost cell.

To be completed by 19 Nov 2012

Awarded to:
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

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