Fill in a Spreadsheet with Data
€750-1500 EUR
Πληρώθηκε κατά την παράδοση
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.
Feel free to ask me any question if something isn't clear.
Regards
Seba
Ταυτότητα Εργασίας: #14176013
Σχετικά με την εργασία
9 freelancers κάνουν προσφορές κατά μέσο όρο €796 για αυτή τη δουλειά
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 Περισσότερα
Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India
Hello Sir, Thank you for posting the project. I am an expert in these fields. I have already completed several projects like this. For evidence you can see my profile. I am a hard worker, productive and worthy of Περισσότερα
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 qualiti Περισσότερα
Hi Seba, I would love to create some macros for you that will automate the process. I have taken a look at the attached files and everything looks to be fine (the template is clean and simple) I an very attenti Περισσότερα
Dear Employer; I am Asif, professional Data Entry Operator. I have 3+ years of experience with more than 500 successful projects. I have done all type of office work. I would give you multiple amendments and charge l Περισσότερα
I am a new free lancer with an advanced knowledge and application of Excel formulas ans techniques , I can help you get your excel sheet done within 3 days with 100% satisfaction and more .
Hello Sir, I am an electrical engineering student and I have a very good experience in writing articles, official documents and data entry. I assure you that I will do your work in a professional way and I will not Περισσότερα
