# Data analysis of an excel file

I want to analyze an excel file with measurement data.

Please review the attached example Excel file before bidding.

Column A (or 1) contains the time stamp (in seconds)

Column C (or 3) contains the actual signal, which is periodic: The signal rises to a maximum within approximately 1 sec, stays in a plateau for about 1.25 sec and then decreases for about 1 sec, stays in a plateau for 1.25 sec, etc. (1 period = 5 sec).

In Column AO (or 41) the absolute difference of each cell of column C (or 3) to the previous cell is calculated (i.e. the difference in absolute numbers, without - or +).

What I want to be calculated is the time difference between the peaks of column AO (or 41) for each half period (each 2.5 sec or 25 lines):

Remember the time stamp is in column A (or 1).

I want to have a formula which can calculate the time difference of the peaks, so that I can load new data sets in column A (or 1) and B (or 2) and get the data calculated.

The milestone will only be released if the solution is provided, no advance release of milestone.

Please only bid if you understand the problem and know how to solve it. Otherwise we both waste our time.

Skills: Data Processing, Excel

( 71 reviews ) Munich, Germany

Project ID: #20673740

## Awarded to:

engineeringexp

A Data Scientist with experience in Python, R programming, R Shiny, R studio and anything related to data science and python Master in Engineering, Electrical and Electronic Engineer, who is dynamic, reliable, resourc More

€30 EUR in 7 days
(2 Reviews)
3.1

## 14 freelancers are bidding on average €132 for this job

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl More

€220 EUR in 5 days
(314 Reviews)
7.9
asin1987

Dear Employer, I have checked your Sample file. There I see there is a col A which has timestamp in Seconds and each 25 rows gives you a cycles of up and down and back. I also understand you need a formula probably in More

€250 EUR in 7 days
(170 Reviews)
7.5
polarjin2017

Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. This is what i have done in Excel/Word/PPT/Access/VBA/MACRO. Just Creating forms, query, Macro, custom f More

€155 EUR in 3 days
(86 Reviews)
6.7
dvcontact

Hi, I have examined your project description about writing Excel formula that will calculate the difference between the peak of column AO for each half period in your Excel spreadsheet. You can be confident that this p More

€150 EUR in 2 days
(50 Reviews)
6.3
seoguru17

I am good at Excel formula and VBA/Macro, I need to see the data so I can understand your requirement, I have a few question to discuss so I need you to send a message on chat.

€100 EUR in 3 days
(80 Reviews)
6.3
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. Willing to take up your project. Thank you, Regards.

€170 EUR in 3 days
(101 Reviews)
6.1
leemilun

Hi. I read your description carefully. I'm a senior developer and until now I did all projects perfectly. Checking my profile, you can see the projects I had done. I can work at any time with the great satisfaction, qu More

€120 EUR in 1 day
(9 Reviews)
5.4
susanna2018

⭐⭐⭐ Hi, Dear client. ⭐⭐⭐ I'm very interested your project. I read your description carefully. I'm very talented Excel & VBA expert with full time. If you assign to me this project, you can get a cool result. If I a More

€120 EUR in 7 days
(6 Reviews)
3.3
bluesea1990

Hello Dear I have read your description carefully. I have full experience in Excel VBA,Macro and Web scraping. I hope to discuss more via chatting. thanks

€140 EUR in 2 days
(8 Reviews)
3.4
youthfreedev9

Dear, I am very interested in your job description. (Well, What is Column B?) I have reviewed your attached excel file and description. Because I am an Excel expert with formulas, functions skills, I can complete your More

€140 EUR in 2 days
(3 Reviews)
2.6
ironstar20311

Hi ⭐I can finish in 1 day I have read your requirement very carefully so I am very interesting and confidence your project I am an experienced and skillful full time data entry expert. I have rich experiences with data More

€80 EUR in 1 day
(5 Reviews)
2.3
Rinawagdy24

Hi I have an in this field, i will finish it as soon as possible . I'd like to work with you Thanks

€30 EUR in 7 days
(0 Reviews)
0.0
anwmdaw

Hi Dear. I have seen the details of your project and I am fully prepared to accomplish it with all efficiency, accuracy and creativity. I have a lot of experience in Office software, especially Microsoft Word & Excel, More

€140 EUR in 7 days
(0 Reviews)
0.0