Закрыт

Excel Data Manipulation - repost

I receive a file on a daily basis (2 examples attached) with a number of columns - those of importance to this project include tag (unique identifier on my side), count (number of time specific tag has failed in a a period of time) and TimeDown (date the incident has occurred)

Daily, I would like to add the file contents I receive to a data source tab and refresh another page that will display the following:

1. All tags that contain certain, predefined characters with the number of failures (not all info in the file is relevant for me)

- predefined info includes pnp* | ala* | bp* | mhg* | san* | metropolitan*

2. The daily count of failures

- so 1 & 2 above would be perhaps combined into a table where each row is a tag and each column is a day of the week, either with count or zero. Note that only tags that have failed during the last 24 hours will be listed in the data source so if they failed yesterday but not today then today needs to be represented as a zero. If they did not fail until the 10th of the month then the first 9 columns must be zero and the count added to day 10. It is also noted that the same tag may be reflected multiple time in the same 24 hour set of data - only 1 instance should appear on the summary tab.

3. A representation of tags that are increasing during the days that pass in the month - I am not sure but this may require a graphical representation of sorts? These can be represented per set of defined characters above (i.e. all tags starting pnp* in one graph etc)

Квалификация: Excel

Показать больше representation graph, importance of graph in data representation, graph this data, graph the data, graph representation of data, graph representation in c, graph of data, graph info, graph data examples, data on a graph, data in a graph, data importance, ala, number manipulation, failed receive data, repost tag, excel unique, project data source, excel count, excel column row

О работодателе:
( 0 отзыв(-а, -ов) ) Sri Lanka

ID проекта: #5445589

14 фрилансеров(-а) в среднем готовы выполнить эту работу за R1002

gokulanand

Hey, I can get this task done in the next 12 to 24 hours with zero errors. Let me know if you are interested Thhanks

R1031 ZAR за 1 день
(94 отзывов(-а))
5.9
Jamesdmartin

Much of what you're doing is possible with a pivot table. We'd have a source tab where you. An paste in new data as it comes in, click on the refresh button, and you'd see all of the new data reflected. I didn't se Больше

R1000 ZAR за 3 дней(-я)
(4 отзывов(-а))
3.5
K9JT

Hi I believe I am fully capable of completing your project. I am very reliable and always give 110%. You are guaranteed to get more than what you pay for. Please give me the opportunity to gain more experience o Больше

R1000 ZAR за 2 дней(-я)
(8 отзывов(-а))
3.0
Itwymt

Hello. I have experience in work in Excel (implementing formulas and macros programming). I could do this work for you in 3 days.

R1088 ZAR за 3 дней(-я)
(0 отзывов(-а))
0.0
mramol999

Hi, I have 5 years experience of macro an VBA, got strong expertise on it. I have worked with many projects like Excel-VBA, Access-VBA, SQL server and SAS. We do not only deliver macro work but also provide addit Больше

R1111 ZAR за 3 дней(-я)
(0 отзывов(-а))
0.0
chaitanyapula

I have been working as an MIS (Management Information Systems) Officer for a Multi-National Company for the last 3 years and hold a total of 8 years solid experience on EXCEL. If you are talking about excel 2010, then Больше

R1055 ZAR за 2 дней(-я)
(0 отзывов(-а))
0.0
CreaT1ve123

A proposal has not yet been provided

R1088 ZAR за 3 дней(-я)
(0 отзывов(-а))
0.0
menaveenn

A proposal has not yet been provided

R1088 ZAR за 1 день
(0 отзывов(-а))
0.0
nasirknows

A proposal has not yet been provided

R1088 ZAR за 2 дней(-я)
(0 отзывов(-а))
0.0
Hanah1

I am not so sure about your explaination. But I will definitely understand when I receive the work. I have strong background in excel with more than 5 years of experience and excellent grade in statistics and excel (wh Больше

R555 ZAR за 3 дней(-я)
(0 отзывов(-а))
0.0
Nisar69

Hi, I can complete all type of Macro, VBA, Tables and Graph related projects effectively. Moreover, I can prepare Excel Forms and Database/Database conversion from and to Excel. As far as your current project is concer Больше

R555 ZAR за 4 дней(-я)
(0 отзывов(-а))
0.0
Advv

Hey mate, it sounds as though you need one tab as an "Import" sheet (which you can easily copy and paste each day's spreadsheet into), another tab to do the calculations of the daily failure count and lastly a tab for Больше

R1555 ZAR за 3 дней(-я)
(0 отзывов(-а))
0.0
nishadcds

Used to be a part of data analytics team within a big4 consulting firm. Have over 10 years of experience and 5 years of data analysis experience with VBA.

R722 ZAR за 3 дней(-я)
(0 отзывов(-а))
0.0
claudi793

A proposal has not yet been provided

R1088 ZAR за 3 дней(-я)
(0 отзывов(-а))
0.0