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.
Looking to make some money?
- Set your budget and the time frame
- Outline your proposal
- Get paid for your work
Bids on this Project
I have over 9 years of development and support experience in Java, UNIX and SQL. I have recently been working on Android development on my own and very keen to take up projects in this arena.
Experts in Android, Angular JS, Excel Programming, .NET, web technologies, Androidand iOS mobility solutions
Riyadh, Saudi Arabia
Chanhassen, United States
We do Web design and Development..
Ypsilanti, United States
Hi, I am an experienced programmer and web designer with two degrees. I want to know more about your project so that can help you achieve your goal.. I live in Michigan, where I have spent the last 20 years.
Cape Town, South Africa
We are experts in Copy Typing, Data Entry, Data Processing, Excel, Web Search and have a great experience in this field.
Full name: Rosette Khalil Vision: To increase the shareholder value and maximize profit by improving the operational efficiencies and maximum utilization for the available resources. education: Master degrees in economic
I am experienced person to do the work with accuracy and in time.effective & efficient, I will provide you reliable and precise work at low price. EXPERIENCE in MNC's in data entry , accounting !
I am having 10+ years of experience in customizing softwares, website design, banner design, web applications etc feel free to contact us on skype shubhampareta