Calculate Time Running per Day

[Sam White]

Hi-

 

I'm looking for some help.  How do I calculate the total amount of time that my line is running per day?

 

Thanks!

Sam

[Lindsey.Wilcox]

Hi Sam-

Doing this is possible using a combination of capsules and signal from conditions. Use the following steps to perform this calculation:
1. Create a condition for when your line is running. (If you have a tag that specifies Running vs. Not running, just use Value Search). 

2. Next, create Daily Capsules using Periodic Condition.

3. Now use Signal from Condition to calculate the total duration Running per day.

This will result in a new signal that reports the total duration Running per day.

Please let me know if you have any additional questions.

[carl.abz.uk]

Trying to follow this but when I click on the screenshots It asks me to sign into Altassian and I have no account?   

BTW What's the link between Altassian and SeeQ - I see a few things like the SeeQ KB have altasian URL's? 

 

 

[Steve Sliwa]

I went back and tried to manually add some representative images for Lindsey's approach.

[Guest Jon Peterson-Test]

@carl.abz.uk Thanks for pointing the bad links out. The pngs @Lindsey.Wilcox pasted into her response were actually references to online content (as opposed to copying and up loading the png to the forum). Problem is the online content cannot be accessed from Seeq.org unless you had a Seeq login to Atlassian; I suspect to avoid cross site scripting (XSS). Images in Atlassian KB are actually links to the original image. 

I'll be posting an internal note for proper use. 

Thanks,

Jon 

[carl.abz.uk]

So back to the topic at hand  - unlike Sam / Lyndsay  I'm trying to do the same thing but would like hours running per month over a year.  Often the system can run for many days with no problem so with value search I use a max capsule duration of 40 days - the end result is SLOW!   So i invert the logic and look for the number of hours the system is NOT flowing.  I create monthly capsules and do the same trick.  And I do indeed see a new (brown) signal of non running hour per month.  

End result looks good, I set the analysis range to 1 year - the trace follows up - but when I export to Excel SeeQ just sits there with the export wheel spinning, I gave up after 10 minutes

All I want is a table with somthign like Jan. X hours Feb. Y hours Mar. X hours etc etc.

But I suspect the problem is Seeq is trying to export everything?  My signal is generally captured 1/min so over a year I have 1440 * 365 = 525,600 points so it's quitea lot of data?  I get wanrings over the interpolation insterval, but then i can't change this - and indeed asI an showing step data I'm not sure  why there is interpolation anyway?

During the import of my original signal is there a way to resample the data to say 5 min resolution rather than 1 to keep the volume manageable (if indded this is the problem)

Is there a way to only export one trace (i.e. the 12 values I want)?

[Guest Jon Peterson]

On the export, we export everything on the screen. Also, there's the option of the gridding of data:

Gridding is often useful (likely not in your case) to get many signals all on the same timestamp. The default is automatic where we choose a gridding for all tags that's roughly the sample spacing of the signal with the most data. I suspect that is what is taking so long. We always export all the data that is on the worksheet. In your case we are generating lots of samples; no doubt that's the performance issue. 

As I show above, just put the trace to export on the worksheet and then choose Ungridded Original time stamps; we know ungridded will only have one sample per month. I created the following chart from the export:

Seeq Organizer Topics are a great way to produce the chart. I created the following and set it up to execute on the current year:

The max interpolation, as you noticed, is set automatically to be ~2x a month. That because any math we do on the month capsule requires us to look to the right and left of any capsule. We give the warning, because often math on that big of time period can take a lot of time. In the future we will calculate that warning and only bring it up if it is an issue. 

[carl.abz.uk]

OK I got there in the end, turning off gridding and the export works fine.  Many thanks.  Now the follow up questions....

You say you export "everything on the screen" - by experimentation I think the fact a trace is visible or greyed  out (i.e..  not selected on the details pane) makes no difference to the export.    The only way I can find to export just the bar graph (12 points per year = quick!) without including the other data (~500k points/year = SLOW) is to delete the other traces?  

I duplicated the page for this - see below - then deleted the original signal, capsules and conditions to leave just the bar graph, but this seems a long winded way of doing it.  Is there no way in Export  on my first page to select what I want to export?

Also  it's a minor point but when moving the cursor the width of the bar chart seems to change the time the value is reported over - in the example there is only one value written on 31-Aug for the result at end of August - yet the cursor returns the resuls as "far to the right" as  4th September  but not form 5th September as by this point we are not on the width of the bar chart.

 

 

 

[Guest Jon Peterson]

Hi Carl,

Yes, you got it correct. If it is on the screen in any way we export it. 

The bar chart is a visualization of the continuous signal--we interpolate between the samples; that being said, I consider this a bug. The interpolation can be a flat line (step), or interpolated, so, there can be "values" at the timestamps between samples. I experimented with setting the signal to discrete--the cursor should only show values a the time of the sample, but it extrapolates on the width of the column, which is arbitrary. I'd argue that moving to a bar chart could imply discrete; but certainly if discrete, it should do no interpolation. I'm going to file a bug on this. 

[Atul Sharma]

Hello , 

Can anyone please explain How to import excel file data in seeq workbench?

I did not find and import excel button in toolbars!

Thanks for your support,

Regards,

[Thorsten Vogt]

Hi Atul,

as far as I know there is currently no way to import the data out of an Excel file in a Seeq native way. I would suggest contacting Seeq support regarding this topic.

However you can evaluate the following options:

- If you are able to transform the data into CSV format you can use the CSV import.

- Another possibility would be using the way that Brian described here (with using Excel instead of Access):

- If you have access to Seeq Data Labs you could use Python and Pandas to read the data from Excel and write it back to Seeq (https://datatofish.com/read_excel/).

- Using Seeq Connector SDK to implement your own connector or using Seeq Server SDK/REST API to push data to Seeq

Regards,

Thorsten