Search results for query: *

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...

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 have a spreadsheet with 4 columns representing quarters (Q1-Q4). For each quarter there are mixed dates and text in the cells. For cells with "Pending*" and dates that fall within that quarter, I need to count the occurences. This number represents the number of failures for that well, for...

I have a situation where I may have more than 1 job for a well. Therefore the well shows up twice in my data, which is ok. But in some cases the cell is a text string with a date at the end such as "Pending as of 7/8/2011". I need a vlookup formula to evaluate the date portion, figure out if...

I googled high and low but could find anything to apply to this task. I have two tables - one table with a pull date field (date job started) and another date with an end date field (date job ended), and am trying to assign the correct end date to the correct pull date. The correct end date is...

Need to formulate a query that gives me a rolling 12 month average of well failures. This has been done in a spreadsheet through numerous calculations (attached), but I need to recreate this same concept in a query. Basically I need to recreate the data on the main graph tab. Thank you...