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.
14 freelancers are bidding on average €132 for this job
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.
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.
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