Jump to content

How to swap calculations across different assets in all production lines


Recommended Posts

We noticed today that if you duplicate a worksheet within a book, you cannot change the tags without affecting the 1st worksheet. Is there a way to separate the worksheets so we can have the same calculations but for a different base dataset? We are trying to make this report for all of our production lines.

Link to comment
Share on other sites

Thanks for reaching out. For my better understanding of your question - have you built an analysis on a single asset (in your first worksheet) and you are trying to swap all of the trends and calculations you have built to another similar asset in another worksheet?

Link to comment
Share on other sites

Thanks for confirmation. So there are two options:

1- Quick solution: If the number of assets that you want to apply the same analysis for is not that many, you can create a copy of each formula and use that in the new worksheet if you want them to be different. Or make a copy of the entire Analysis (Workbemch) and connect it to the new dataset. When you 'Duplicate' worksheets it keeps all the objects the same.

2- Long term solution: If the number of similar assets at different sites are too many, create an asset tree to enable you and your team to swap calculations by just clicking a button. You can find more information on this here:


If you decided to go with solution #2, please let us know, as you may need Seeq analytics engineer support to set up the asset tree.

Hope it helps and please let me know if you have any further questions.



Link to comment
Share on other sites

I have a question which may be added to this discussion.

If we create a Separate worksheet by duplicating a original worksheet.

If I try to Swap assets, it works very well. (As I have arranged the tags in asset format).

However, some of formula based values like Static High limit, Static Low limits do not swap, Static Out of bound capsule (based on deviation search of High and Low limit) do not swap. Is there any workaround this?





Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...