

Pivot Table output - I would like to combine both tabs programmatically, be able to filter by application. Each letter drive could potentially have a unique size. Each server will have multiple letter drives (A - Z). Tab 2: This tab shows a list of servers, the letter drives on each server, and the size of the respective letter drives. There are servers with multiple applications assigned, as well as applications on multiple servers Tab 1: This tab shows a list of servers and the applications assigned to each server.

See detailed job requirements, compensation, duration, employer history, & apply today. Must be fluent English and be able to demonstrate experience working on similar projects.I would like to create a pivot table based on the data in the attached excel spreadsheet. Browse 9,198 open jobs and land a remote Microsoft Excel job today. Linn Legros is in need of freelancing agents who can be able to do Excel Analysis.

Upon agreement/understanding of scope, a fixed fee will be agreed for each milestone, assuming milestones are table/database creation, live system to be tested and sign off once all bugs are fixed.Įxperiened coders/developers only please. It will require full dedication and must be completed by end of March. This is an urgent project and one I believe may be complicated even for experienced coders. Possibly these tables I can build myself/obtain from someone else to save time. Part of this project involves setting up approx 10-14 data tables within MySQL based on an existing Excel database which uses various formulas and index functions. In some cases following this analysis, some of this data needs to be copied to a CSV format file, to be uploaded/sent to a URL available to be downloaded/accessed by another programme. I need this data to be uploaded/sent live every X seconds to a MySQL database where the data is analysed in real time. I have an Access database that updates with live data 24/7.
