I have an Excel spreadsheet I would like to convert to a standalone Java program. I need to be able to input a list of server details (Input tab) via an Excel worksheet and then validate the data (Application Info Validation tab). After the data is validated it needs to be 'mapped' to virtual servers on a target host (LANDING ZONE DESIGN tab). And, finally, I want to be able to 'cut and paste' the output (APR Input Form (ZONE) tab). I also need to be able to completely update the 'README', 'Network', 'site locations', 'Input', 'Target Hardware' and 'm-values' tab.
How the spreadsheet works:
- a list of servers get added to Input tab ***this is the input***
- column T in 'Application Info Validation' tab is then updated using a drop down menu to select the appropriate server
- in LANDING ZONE DESIGN tab, columns A, B, C, AK, AN and AV are then adjusted to match Input tab info
- finally, information is cut and pasted (copied) from the APR Input Form (ZONE) tab - ***this is the output***
A nice to have: able to add more than 8 virtual machines per target (in LANDING ZONE DESIGN and APR Input tabs.
Prerequisite: will require a non-disclosure agreement and all source code to be handed over at conclusion of project.