Excel macro - smart spreadsheet

In Progress

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: Data Processing, Excel, MySQL, Visual Basic

See more: smart spreadsheet, database vba, user specifications template, spreadsheet experts, smart input, need experts in excel, experts in excel, experts excel, excel vba experts, excel vba db, excel macro how to, excel it experts, excel formulas for experts, custom formulas in excel, custom building products, building it infrastructure, all experts excel, smart it, image deployment software, excel vba or, excel 2013 vba, excel spreadsheet experts, vba excel macro, vba e, spreadsheet input

About the Employer:
( 0 reviews ) Bucuresti, Sector 2, Romania

Project ID: #4502215

8 freelancers are bidding on average €254 for this job


Excel Expert. Please check your PM for details. Thanks

€222 EUR in 3 days
(82 Reviews)

VBA expert for over a decade

€222 EUR in 7 days
(31 Reviews)

We are expert in enterprise solution. We provide enterprise solution to simplify office work. We have experience to develop micros,add-in and integration of office. We are expert in this field and we promise to provid More

€263 EUR in 3 days
(2 Reviews)

hi I do this work

€222 EUR in 3 days
(0 Reviews)

I can do this job.

€333 EUR in 5 days
(0 Reviews)

I can do that.

€333 EUR in 3 days
(0 Reviews)

Hi there, Let me know the details. Requirement of your project. Ready to start right away... Please check PM for more details. Thank you.

€211 EUR in 3 days
(0 Reviews)

Have prior experience in Excel VBA. Please check your inbox.

€222 EUR in 5 days
(0 Reviews)