Seeqer Posted December 28, 2018 Share Posted December 28, 2018 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 More sharing options...
Sepideh R Posted December 28, 2018 Share Posted December 28, 2018 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 More sharing options...
Seeqer Posted December 28, 2018 Author Share Posted December 28, 2018 Yes, that is correct Link to comment Share on other sites More sharing options...
Sepideh R Posted December 28, 2018 Share Posted December 28, 2018 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: https://seeq12.atlassian.net/wiki/spaces/KB/pages/147292234/Searching+and+Navigating+an+Asset+Tree#SearchingandNavigatinganAssetTree-AssetSwapping 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. Thanks, SR Link to comment Share on other sites More sharing options...
SeeqKing Posted January 4, 2019 Share Posted January 4, 2019 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 More sharing options...
Administrators Lindsey.Wilcox Posted January 11, 2019 Administrators Share Posted January 11, 2019 SeeqKing- I'm curious to know a bit more about how you have these limits configured; are you using the Boundaries Tool? Any additional information or screenshots you can provide would be helpful. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now