Excel macro - smart spreadsheet

IN PROGRESS
Bids
8
Avg Bid (EUR)
254
Project Budget (EUR)
€100 - €300

Project Description:
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.

Skills required:
Data Processing, Excel, MySQL, Visual Basic
Hire brotaru
Project posted by:
brotaru Romania
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


€ 222
in 3 days
€ 222
in 7 days
€ 263
in 3 days
Hire Nishant4me
€ 222
in 3 days
€ 333
in 5 days
€ 333
in 3 days
€ 211
in 3 days
€ 222
in 5 days