Fill in a Spreadsheet with Data -- 2
€150-750 EUR
Pagado a la entrega
Hello,
We are looking for someone who can make excel macro's.
We are an IT firm and we extract data from our clusters. (Disk usage, mem usage, ...).
The data is exported into .csv files.
Every month we import this data into the same excel file and the use that data to expand our graphs.
=The data we extract contains numbers & dates + hours. The dates & hours are in the wrong format so we need to apply a formula to that data to get it in CET and the hours in hh:mm:ss AM/PM.
The problem with this is that it takes a lot of time.
What we currently do:
-Import the data from the .csv files into the excel file.
-For time/timezone we need to apply formula to convert to CET & hh:mm:ss AM/PM
-To some numbers we apply formula to get an average/%
-Adjust our graphs by reselecting the series entries (adding the new data to the graph)
Right now we add about 15 csv files worth of data every month. It takes about 4 hours to get this done. In the future we will be looking at about 40-50 csv files which will make this entire process very timeconsuming & unclear.
What we need:
-We need a way to be able to expand the graphs without manually having to input & select all the data.
-Basically we want to expand our graph every month with as less effort as possible.
i've included the exported data & the final file containing the graphs.
Included:
-3x Extracted csv files (Already inserted into document)
-Excel file containing imported data & graphs.
Please add a reply to these questions in your bid:
-Describe your solution(briefly)
-When you have created the solution, how long would it take us to expand the graphs?
(with 15 csv files, 4hours of work to ?? hours of work) approximately.
Regards
Seba
Nº del proyecto: #14177642
Sobre el proyecto
12 freelancers están ofertando un promedio de €355 por este trabajo
Hello Sir, My name is Jay and I am #1 Excel VBA programming expert on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-st Más
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Más
I have gone through the project details, and understand what you are trying to achieve. We have completed a number of similar a projects to yours. And we are experienced critical data research. ## A little about us Más
Hello, I graduated from Boston University USA, which is among top 50 Universities of the world. I have a lot of experience in data processing. I am very punctual and always deliver on time. My personal qualitie Más
I have the expertise in Excel VBA and can do this task, as per requirements, quickly and accurately. Ready to start work immediately.
I can help with many different forms of data entry, and have proven skills with Microsoft Excel . * My competitive advantages to your project are my accuracy in numbers and consistency in formatting. * I have pre Más
Dear sir, Hope you are well & thanks for reviewing my cover letter. I understand your job description & able to complete your project. Please, Hire me to start your project Thanks & Regards, Riaz Ahmed
