Jump to content
  • To Search the Seeq Knowledgebase:

    button_seeq-knowledgebase.png.ec0acc75c6f5b14c9e2e09a6e4fc8d12.png.4643472239090d47c54cbcd358bd485f.png

Search the Community

Showing results for tags 'excel'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Community Technical Forums
    • Tips & Tricks
    • General Seeq Discussions
    • Seeq Data Lab
    • Seeq Developer Club
    • Seeq Admin Forum
    • Feature Requests

Categories

  • Seeq FAQs
  • Online Manual
    • General Information

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Company


Title


Level of Seeq User

Found 5 results

  1. A small team of us (with help from Seeq team members) built a short script to extract signal names from our legacy excel workbooks so that we could push them to Seeq workbench. Perhaps, like us, you are involved in migrating workbooks for monitoring/ reporting over to Seeq and could do with a boost to get started so you can get to real work of setting up the Seeq workbench. The attached script will extract the signal names (assuming you can craft your own regex search filter) from each excel worksheet and then push them to workbench with labeling for organization. Hopefully its a help to some 🙂 signal_transfer_excel2seeq_rev1.ipynb
  2. I've got an excel monitoring tool that our operators will use daily. I'd like to be able to build a functionality within the excel tool for pulling data directly from SEEQ into the excel tool. Ideally, I could build some VBA query that works in the background to pull the data from SEEQ using the API, and our operators just click a button to run the VBA code that will query the SEEQ API. Is there a way to do this? To pull data directly from SEEQ without leaving the EXCEL environment?
  3. Another common question through the support portal this morning that is of general interest To help with this example I am going to create a quick polynomial prediction using Data from Area C in the example set. Our target is going to be to try to predict compressor power as a function of all of the input weather signals If you wanted to re-create this prediction model in excel or another tool you need the coefficients from block #1 in the screenshot above and the y-intercept from block #2 in the screenshot. Inside of the workbench tool you will see rounded values for each of the coefficients and intercepts but the full values are available when you copy them to the clipboard by clicking the little button highlighted in red. To fill out the example in excel the formula will look like the following $temperature^2 * -0.000230 + $temperature * 0.0607 + $WB^2 * 0.000646 + $WB * -0.101 + 6.5946 A final point to mention here is that for multi-variable regressions with many input signals it is important to take a minute and evaluate the p-values listed in the coefficient table. If the p-values for any coefficient are above 0.05 it is best practices to rethink if that signal needs to be included in the model at all or if you may need to perform data data cleansing or re-alignment to create a better performing model. Good blog post on P-values - https://medium.com/analytics-vidhya/understanding-the-p-value-in-regression-1fc2cd2568af Great reference post on how to optimize regression models using time shifting -
  4. What is the best way to create a formula that will give me the equivalent of the Excel if function. The specific example I have is if a control valve is closed (.OP <= 0) then I want the formula to give me zero flow, other wise I want it to just give me the flow reading. So something like this in Excel IF(OP<=0,0,FLOW) Thanks for your help.
  5. The question Suppose I have an irregularly spaced discrete signal, and several continuous signals. Is there a simple way to export the data such that I only get data from the times when the discrete signal has data? I.e. suppose my discrete data was taken at 1min, 3.1min, 8min and 19.5min. Can I get an exported sheet that has the value of all the interpolated results only at 1, 3.1, 8 and 19.5 minutes? What I have tried Automatic Gridding: Fails to export any discrete data Custom Gridding: Fails to export any discrete data Original Timestamps: Exports all data, but the discrete and interpolated signals are misaligned
×
×
  • Create New...