Recent content by Drivium

some *kind

Yea, I tried a delay. I think I need to reference some time of form function, but not sure how to do that. If you go to that link and select an object in the first drop down, you see the subsequent dropdowns change. I have to trigger THAT somehow...

Does my question make sense? I'm happy to clarify. TIA!

I created a script to BEGIN to do what I need. This script interacts with the initial form. I can fill out the form and submit, but it errors. Upon further inspection, after a selection is made in the first dropdown field, the form is supposed to refresh with updated dropdown options. With my...

Getting same results as my attempt. 3month oil_vol and standard oil_vol match values.

Thanks for the reply. I changed up the WHERE ?, but not understanding which date reference I should change or what to change it to. Not totally sure I applied your last suggestion correctly either. Now Oil volume and average oil volume are identical. SELECT; SELECT A.Well_Name, A.Test_Date...

Also, I really need this to SHOW the following columns Well_Name, Test_Date, Oil_Vol, Water_Vol, Gas_Vol, Water_Cut, 3Mon_Avg_Oil_Vol, 3Mon_Date, 3Mon_Avg_Water_Vol, 3Mon_Avg_Gas_Vol, 3Mon_Avg_Water_Cut,Delta_Oil_Vol, Delta_Water_Vol, Delta_Gas_Vol, Delta_Water_Cut. For the 3 month avg date...

Ok...got it to work...sort of. But I'm getting the same problem as before where the data is not unique to each well. But instead, showing the same data for each well (depending on date) SELECT A.Well_Name, A.Test_Date, A.Oil_Vol, A.Water_Vol, A.Gas_Vol, A.Water_Cut...

No luck. I've tried putting commas after each (Select statement, but it's not working. I either get a syntax error or punctuation error...

Something like.... (not working) Got error saying "The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect" SELECT Well_Name, Test_Date, DateAdd("m",-3,[Test_Date]) AS SinceDate, (SELECT AVG(Oil_Vol) FROM 3Mon_Average_2...

That worked. Now trying to apply it to the rest of my criteria and getting an error about an extra ) SELECT Well_Name, Test_Date, DateAdd("m",-3,[Test_Date]) AS SinceDate, (SELECT AVG(Oil_Vol),AVG(Water_Vol), AVG(Gas_Vol),AVG(Water_Cut) FROM 3Mon_Average_2 B WHERE B.Oil_Vol = A.Oil_Vol AND...

I must have applied the technique wrong... every well has the same average for the same time period. When the date moves up a day, the average changes (but is the same) for all wells still. SELECT Well_Name, Test_Date, DateAdd("m",-3,[Test_Date]) AS SinceDate, (SELECT AVG(Oil_Vol) FROM...

Regarding well testing: Posted 5 months worth of data in the attached spreadsheet. Basically I have 6 columns of data: Well Name Test_Date Oil_Vol Water_Vol Gas_Vol Water_Cut I need to calculate a rolling 3 month average per well on oil,water,gas, and water cut. Easy to do in Excel, but not...

I think for this instance, I am in need of a specific formula for my spreadsheet. Ive been reading non stop on this since my original post, but can't seem to translate any formula to work with my spreadsheet. In this version, I've cleaned up a lot of the data improved the function in general...

Which index? =index(theFormula,1,1) or =index(theFormula,count(theFormula),1)