VBA Excel solver replacement
This project was awarded to neilMT1 for $35 AUD.Get free quotes for a project like this
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
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
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online