Search the Community
Showing results for tags 'excel'.
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?
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 -
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.
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