We’re currently using a spreadsheet to display IT infrastructure and software licensing data.
For this project we are looking for Excel VBA experts that also have good knowledge about databases, especially MySQL. Any software licensing knowledge is a plus.
In order to create this spreadsheet there are several manual steps to be performed:
1. Extract all the relevant data from a MySQL database
2. Add formatting for each object type
3. Create formulas for counting the objects
4. Create a summary to simplify the overview.
Excel should communicate with MySQL through an ODBC connection.
Other than performing the above steps automatically, the spreadsheet should be able to record changes (i.e., change in a server name) and update the MySQL database accordingly.
The spreadsheet will be composed of multiple building blocks that link and assemble based on the underlying data but also based on user specifications.
Additional custom forms will have to be created to upload data into MySQL also.
The spreadsheet will have 2 roles:
1. Presentation – 2 sheets :
a. The “Deployment” sheet – Contains all the infrastructure information and the software hosted on all servers.
b. The “Deployment summary” sheet – Contains all selected products and options and their number of CPUs and named users. This will be updated dynamically based on changes made in the “Deployment” sheet.
2. Backend – sheets and forms:
The “Deployment” sheet - The spreadsheet should track all changes done manually on the deployment sheet and update the data accordingly (i.e., moving one instance from one server to another or completely deleting it).
We can either provide a dump of the MySQL database or a VirtualBox image with a MySQL server. You will also be provided with a template of the spreadsheet with data from the DB filled in.
Once a bid will be accepted, more information will be provided. We will need to discuss in detail how you will automate the actions.
Although the formatting should stay the same, we are open to suggestions so your input and feedback will be appreciated.