Question description:
This user has given permission to use the problem statement for this
blog.
I need a help in analysis of one seconds data for frequency reading on the national grid. I have to count number of events when frequency below certain point was recorded below certain frequency point for certain period of time
Solved by A. H. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
26/06/2018 - 10:41
Hi
Excelchat Expert
26/06/2018 - 10:41
Hello! How are you?
User
26/06/2018 - 10:41
I have a problem with some analysis.
User
26/06/2018 - 10:41
Good very well.
Excelchat Expert
26/06/2018 - 10:41
That's good to hear.
Excelchat Expert
26/06/2018 - 10:42
Let me confirm my understanding of your problem statement.
User
26/06/2018 - 10:42
I can see we have only 19 minutes so straight to the point.
Excelchat Expert
26/06/2018 - 10:43
You need to count the number of instances a frequency falls below a certain number for a certain period of time in your data right?
User
26/06/2018 - 10:43
yes but also for few different condition.
Excelchat Expert
26/06/2018 - 10:43
It's okay - if we need more time we are allowed for a maximum of 2 20-minutes extension per session for free.
Excelchat Expert
26/06/2018 - 10:43
Okay, could you share with me your file so I can have a better view of your data structure?
User
26/06/2018 - 10:44
If that last for between 0-2 seconds or 5-15 seconds
Excelchat Expert
26/06/2018 - 10:44
Then we can further expound on the other conditions.
Excelchat Expert
26/06/2018 - 10:45
Okay, I can see you paste the data in the document preview
Excelchat Expert
26/06/2018 - 10:45
How do i tell if they last for X no. of seconds?
User
26/06/2018 - 10:46
difference between recorded times
Excelchat Expert
26/06/2018 - 10:47
Where do I see the recorded times?
User
26/06/2018 - 10:47
column a
Excelchat Expert
26/06/2018 - 10:47
I can see there is a date and time stamp in column A but until the minute data only. Could you show me an example?
Excelchat Expert
26/06/2018 - 10:48
May I know what is the range of frequency you want to include in the count?
Excelchat Expert
26/06/2018 - 10:50
Hello? Are you still with me?
Excelchat Expert
26/06/2018 - 10:54
Hi, I am sorry I will not be able to include the second condition you made mention based on the duration if we can't clear up the question on how to compute for the duration...
Excelchat Expert
26/06/2018 - 10:55
What I have provided so far is the count on event based on the frequency below a specified number as indicated in cell G2 - which you could change base on what really is the requirement.
Excelchat Expert
26/06/2018 - 10:58
HI, this session will automatically end in less than 3 minutes.
Excelchat Expert
26/06/2018 - 10:58
I hope you are able to come back and confirm solution provided so far.
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.