Excel macro - smart spreadsheet - repost


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: project excel 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, macro vba

Project ID: #4502298

10 freelancers are bidding on average $162 for this job


I'm looking to do this job for you.

$130 USD in 3 days
(46 Reviews)

Hello Sara2013nad I am an Excel VBA expert and here is my proposal for completing this project: I've estimated 14 days to complete but that can change once specific tasks are distilled from the requirements. My un More

$230 USD in 14 days
(17 Reviews)

Hello, Greetings From Evirtual Services!! We understand your value of your time and believe in excellent service with 100% satisfaction. I am Sanjeev and I represent Evirtual Services fast growing US based com More

$123 USD in 3 days
(4 Reviews)

Interested.Expert in Excel & VBA.Kindly check PM for details.Thanks,Amit

$250 USD in 7 days
(1 Review)

believe on my caliber, give me chance to prove. 100 % accuracy....i have got experience in MNCs in data entry , excel. so please give this opportunity .....

$100 USD in 2 days
(0 Reviews)

Hi, In my previous employment, I have written macros that could extract data from DB and show it on the Excel in a formatted look. Your project needs something similar. Hence, I believe that I can be of help to you More

$111 USD in 5 days
(0 Reviews)

Hi, I license my own software, so I have a sense of what you are interested in. I have written Excel/VBA solutions and compiled software which reads and writes to an SQL database, using Excel as the input or output. More

$277 USD in 3 days
(0 Reviews)

let me do this projec

$111 USD in 3 days
(1 Review)

hi i am 5+ yrs of experience contact skype shubhampareta expertise in developing excel sheets with database sync

$155 USD in 3 days
(0 Reviews)

hey iam very much interested to work on your project. please give me a chance

$133 USD in 3 days
(0 Reviews)