Background: I just completed a seven month long project for Walt Disney World corporation. As a supply chain manager, my objective was to develop a network optimization model via excel while maintain a high level of automation. This required some of the longest nested if functions, array functions, VB script, and macros. It was completed successfully via excel 2010 and now I want to change the supply chain industry. My goal is to turn this file into a program. I am highly motivated and created a website with the software details: [url removed, login to view]
Breakthrough: currently optimization software will force users to recreate their company's entire network, flows, and activities via SQL. My model automates all of those tasks. Finally, users have time to analyze the optimized output as opposed to troubleshooting.
knowledge regarding manufacturing, logistics, and supply chain is highly preferable for easier understanding but not required,
I have a 25 MB excel workbook containing multiple sheets. One sheet is used as a data entry sheet for supplier data while other sheets or tabs provide the following: savings summary, warehouse site location optimization for schedule and routing, and detailed output for facility optimization. The data entry sheet contains ADVANCED macros to clear out and copy entered data.
I would like to have this workbook packaged as standalone software. I will also need a small keygen app to create serial keys for this software.
By this I mean that the software will perform the same function, but without the need to have excel installed. This would be a standard windows software package, and include stadnard features, such as allowing the user to specify the installation directory, an option to remove software at a later date, the option for the user to type in their serial key.
I will send the user the serial key when they purchase this software. I will use the keygen to create the serail key and then send this to the user.
The user should be able to move between worksheets in the same way as they could normally. They should also be able to print any of the worksheets as well as save the data which they can re-open at a later date.
Preference will be given to those who can provide a demo. For example, create a small spreadsheet, and then create an app to show the same functionality of the spreadsheet.
One of the main macros creates scenarios or what if analysis to determine which of the 50,000 U.S zip codes is the most optimal location for a company to open up a site. The work is done but converting this into an application while maintaining 100% of the functionality is Required