I. Client - Generating Reports
Login
When the program starts, if a Client database is in use the Login window should automatically open and the Login process will run. If this does not occur, then from the main window select ‘Client’ or ‘Reports’. The Client Reports window will open and the Login window will appear. Click on CANCEL to stop the login process so that you may enter a different User Id and Password. Click on SKIP LOGIN to bypass the login process completely. If you skip the login you will not be able to download data from the Remote server but you will be able to generate reports with the current data in the local database.Note: This window may be navigated and functions executed using just the keyboard if desired. Items will have an associated Hot Key which will be revealed by holding down the ALT key and then hitting the desired letter. For example: Alt ‘u’ will place the current days date in the display window at the top center of the form.
Downloading Data
Click on RUN DOWNLOAD to run a download from the LAST DOWNLOAD date shown to the left of the button or first select a date, see below. If using a Selected Date, place a check in the box next to USE SELECTED DATE and run the download. Records will be downloaded from that date forward.Placing a check in the box next to DOWN LOAD RECORDS AT STARTUP will cause the download process to run each time the form is opened from the LAST DOWNLOAD date.
Enter or Select a Date
Start by selecting USE TODAY or entering a date. Enter Month, Day and Year and then Alt ‘s’ to select the day. You will receive a Message Box if the date entered is invalid. Most reports will require at least an Operator and a Well name. The date selected will be displayed at the top left of the form.Selecting an Operator, Well or Tank
After selecting a date you will note that the cursor is positioned in the textbox just below the word SEARCH. If not, use Alt ‘o’ or click on the text ‘Operators’ shown in red. You can find an Operator by starting to type the Operators name. The arrow will move through the Operators data grid as you type or you may also use the Up and Down arrows on the keyboard. When you have positioned the arrow next to the desired Operator either click on the arrow or use the ENTER key on the keyboard.The focus will then shift to the Wells data grid and you may repeat the search process by typing or using the Up and Down arrows to find the desired Well. Click next to the Well name or use ENTER.
The focus will then shift to the Tanks data grid and you may repeat the search process by typing or using the Up and Down arrows to find the desired Tank. Click next to the Tank name or use ENTER.
As the selection process is executed, your selections will be displayed just above the data grids.
Lists
In the left most pane just below the data grids, use the Option buttons to select the Entity (Well, Operator or Tank), the Report Type (Daily Totals, Oil Runs, Gauge Oil or Gauge Water) and then select if you want the report By (Day, Month or Year).Click on VIEW under the LIST heading and the report will be generated if any data is present.
Selected Day
By Well
This is a list of Oil, Gas and Water production for all of the Operators wells for the day selected.This Day
This is a table showing all available data for a single Well for the selected day. (Daily Totals, Oil Runs, Gauge Oil and Gauge Water)Week Ending
This is a table showing a recap of data for a single Well for the Week. Any day of the week of interest may be selected to generate the report.II. Pumper - Entering & Checking Daily Pumper Data
Gauge Oil Oil Runs Gauge Water Daily Totals Uploading Downloading set Up Data
On the main screen in the Toolbar click on the REMOTE button to open the Remote Database Connection window and click on DOWNLOAD (Alt ‘d’) to download the data from the remote server.If you are using a Dial-Up Internet Service, the process to connect to that service should start at this time if you are not already connected. You may find it easier to track your download if you connect to the service prior to running the upload.
Daily Data
To enter daily gauge and run data, at the main window click on the ‘Pumper’ icon. The Pumper Reports window will open.Note: This window may be navigated and functions executed using just the keyboard if desired. Items will have an associated Hot Key which will be revealed by holding down the ALT key and then hitting the desired letter. For example: Alt ‘u’ will place the current days date in the display window at the top center of the form.
Start by selecting USE TODAY or entering a date. Enter Month, Day and Year and then Alt ‘s’ to select the day. You will receive a Message Box if the date entered is invalid. A Pumper name will be needed next. If your Pumper name is not available in the drop down list, click on the GET button next to the list. In the Pumper Setup window enter a new name and save it.
Note: See Appendix II for sorting, searching and selecting items in a data grid.
Gauge Oil
Select an Operator, Well and Tank. Make sure you are on the GAUGE OIL tab (Ctrl ‘z’) and then enter Feet and Inches for the Oil and for Water Bottoms if needed. Click on SAVE above or use Alt ‘v’ to save the data. The Production net of Water Bottoms will be calculated and displayed to the right.Oil Runs
Use Ctrl ‘x’ to move to the Oil Runs tab. Enter a Ticket Number (duplicate Ticket Numbers are not allowed), then Feet and Inches for both the Top and Bottom Gauge. Next enter any Gravity, Temperature or BS&W data desired. Click on SAVE above or use Alt ‘v’ to save the data. The Barrels will be calculated and displayed to the left.Gauge Water
Use Ctrl ‘a’ to move to the GAUGE WATER tab and then enter Feet and Inches. Click on SAVE above or use Alt ‘v’ to save the data. The water Production will be calculated and displayed to the right.Daily Totals
Use Ctrl ‘s’ to move to the Daily Totals tab. If needed, enter data for Less CLS Stock, Tubing, Casing, Line, Diff, Temp, Choke, Hours, MCF and, Water Barrels. Click on SAVE above or use Alt ‘v’ to save the data. Calculations will be made as needed and if Hours was left blank , 24 will be entered and saved.Uploading Pumper Data
Repeat the above steps for each Operator, Well and tank desired. When finished close the Pumper Reports window, click on the REMOTE button to open the Remote Database Connection window and click on UPLOAD (Alt ‘u’) to upload the data to the remote server.If you are using a Dial-Up Internet Service, the process to connect to that service should start at this time if you are not already connected. You may find it easier to track your upload if you connect to the service prior to running the upload.
III. Office - Set Up Operators, Wells and Tanks
Operators Wells Tanks Overview Uploading To setup new operator or well names, on the main screen in the Toolbar click on the SETUP button or right click and select SETUP. The SetUp Window will open and if Operators and Wells are present it will navigate to the Wells view.
Operators
To Create or Edit Operator names click on OPERATORS. Enter a name in the text box and click on CREATE. I suggest using short names to keep things simple. Please note that if you DELETE a Operator name you will delete all associated records to that operator which will usually include all associated wells and tanks and any data for those items. To edit an Operator name, click on the left border of the data grid next to the desired Operator. The Operator name will appear in the Operator text box and may be edited as desired. Click on SAVE EDIT to update the Operator name throughout the database. Be aware that duplicate Operator names are allowed.At this point you may want to setup Login data for your Clients. Select an Operator by clicking on the left border of the data grid next to the desired Operator. Click on the button SET LOGIN. The window will expand and you will be able to enter a UserId and a Password. Select CREATE or SAVE EDIT as needed. Select FINISH/CLEAR when finished.
A UserId and Password will be given to each Client. This Login will allow the Client to download records from the remote database for the associated Operator. If a Client needs to have access to data from more than one Operator, setup a UserId and Password for that client for each Operator.
Wells
Well names are created in a similar fashion. Click on WELLS and first use the drop down menu to select an Operator, next enter a Well name, a location, enter or select a State name and then use the radio or bullet buttons to select the ‘Type’ for that Well. When finished click on CREATE. Repeat this process to set up the Wells for each Operator. If you do not find the state you want, click on STATES create a new State and State ID. The state will then be available for your selection. Be aware that duplicate Operator names are allowed such that the Location field becomes important.To edit a Well name, click on the left border of the data grid next to the desired Well. Edit as desired and click on SAVE EDIT to update the Well information throughout the database.
Tanks
Tank names are created in a similar fashion. Click on TANKS and first use the drop down menu to select a Well, next enter a Tank name, a size, the Barrels Per Inch as a decimal (ex: 1.67) and then use the radio or bullet buttons to select the ‘Type’ for that Tank. When finished click on CREATE. Repeat this process to set up the Tanks for each Well. Be aware that duplicate Tank names are allowed.To edit a Tank name, click on the left border of the data grid next to the desired Tank. Edit as desired and click on SAVE EDIT to update the Tank information throughout the database.
Overview
Overview provides a grid like view of the Operator and Well names plus related headings. The records are initially grouped by Operator then Well. To change the grouping click on UNGROUP and then follow the directions for creating a new group. Note that more than one Heading may be placed into the grouping area at the same time.Uploading SetUp Data
When finished close the Well SetUp window, click on the REMOTE button to open the Remote Database Connection window and in the OFFICE TASKS frame, click on UPLOAD (Alt ‘p’) to upload the data to the remote server.If you are using a Dial-Up Internet Service, the process to connect to that service should start at this time if you are not already connected. You may find it easier to track your upload if you connect to the service prior to running the upload.
Note: When working with an OFFICE database, the user may function as both the Office and a Pumper. The Remote Database Connection window offers the necessary options to perform the needed tasks.
IV. Installation
It is best to terminate all programs that auto-start when your system boots-up especially virus protection programs that are in constant run mode and then re-boot before the installation. Place the CD in the drive. If the installation program does not start automatically, use Windows Explorer or My Computer expand the directory for the CD. Double click on the file ‘DayPumper_Install.exe’.
This program requires that the .NET Framework 1.0 or later and MDAC 2.6 or later be present on your system. In general, the .NET Framework 1.0 and MDAC 2.6 were not distributed with either Windows 95 or Windows 98; however, they may have been installed later. If your system has either Windows 2000 or Windows XP both of these products should be present but may not have the proper version. If you are not sure, run the DayPumper install and you will be prompted to add or update these components as needed. Then run the DayPumper install again.
V. Running the Program
There are several methods to start the program.
1) Double click on the ‘Desk Top’ icon.
2) Go to Start, Programs, and find the DayPumper listing.
3) Using Windows Explorer or My Computer, go to the DayPumper folder and double click on the file named ‘DayPumper.exe’.The program will open to the main window. The four main icons at the top of the screen are from left to right:
EXIT to exit the program PUMPER entering or editing of data by the Field Pumper CLIENT / REPORTS viewing reports, tables or lists of pumper data REMOTE data transfers by the Pumper or Office SETUP set up Operator, Well & Tank names -- show an Overview VI. Database Structures
There are two types of databases associated with this program. The Remote Database is a SQL Server database residing on a remote server to which has been preset for each Company purchasing this Program. The Local database will be an Access database of which there are three versions: OFFICE, PUMPER and CLIENT. Each version has slightly different functionality.
CLIENT will be the Pumping Company’s clients that will be allowed to download data from the remote server based upon permissions granted by the OFFICE. Clients will be able to generate a variety of Reports that may be viewed on screen or printed.
OFFICE is normally used to setup Operator, Well and Tank names which are uploaded to the remote server. OFFICE may also download the daily PUMPER data.
PUMPER is used to enter daily data for Oil and Water Gauges, Gas data and any other needed information which is then uploaded to the remote server. PUMPER will initially download the setup information that was previously uploaded by OFFICE. A Pumping Company that does not use a central office will want to function as an OFFICE to permit the field pumper to create and enter data for both the OFFICE and PUMPER functions.
VII. Create and Name a New Database
To create a new local database file select FILE, CREATE NEW. An input window will open asking you to enter the new database name such as: Operator04. After entering the name select ‘OK’ and the database will be created. The database is now ready for use and the name of the new database should be listed at the top of the form.
Note: If you are currently acting as the OFFICE, you will be prompted if you want to create a Pumper or a Client database. You will select YES or NO for each option. By selecting NO to each option you will be creating an Office database.
To open a database select: FILE, OPEN. The ‘Open a Database’ window will open so that you may select the file you have just created. Select the file by double clicking on the file or selecting the file and then clicking on OPEN. At the top of the screen in the Menu bar you will see the name of the Current Database file in use.
Day Pumper will remember the last database that was in use and open to that database when you start a new session. To enable or disable this option use: FILE, PREFERENCES to open a view of the current preferences. A check in the check box in the upper left portion of the view will cause the last file used to be remembered. Please note the other options available in this view.
VIII. Back Up
To make a Back Up of your database file use FILE, BACKUP from either the dropdown or right click menu. To use the right click menu the cursor must be over the main program window.
The best location for back up files would be on a separate physical drive from where the program is stored but this is not always available. A default path is provided.
When you have reached the end of the year and you are ready to start working on the next year, return to the main window and select FILE, NEXT YEAR. This will set up a new database file using the basic Operator, Well and Tank information you have entered in the database file that is currently open. It will not change anything in the file that is currently open but create a new file with the following changes.
All Daily Totals, Oil Run, Gauge Oil and Water Gauge entries will be deleted except for the Daily Totals record for the last day of the previous year. This record is needed to get the ‘CLS Stock’ value for the first day of the next year for each Well.
Start by selecting the file that you wish to rename. Then click on FILE, NEXT YEAR, an input box will ask you to enter the new file name. I would use the same basic name as before and just change the year. Then click ‘OK’.
This file is now available for use by use.
Delete All Records Prior To
An alternative to creating a new local database or if you just want to do a Clean Up on the current database, run the DELETE command.Select TOOLS, DELETE from the Menu list at the top of the window. Enter a Month and a Year for which you want all prior records to be deleted. Click on DELETE/CLOSE or DELETE to delete the records.
For example if you are starting a new year, after you have entered all records for January 1 of the new year then run a DELETE for all records prior to month 1 of the new year.
Note: Only the OFFICE version of the database has the ability to delete records from the Remote database.
As you know crashes do occur. They occur due to problems in this program, in the Visual Basic programming language, in the Widows Operating System and in the Access Database program used along with this program. Most crashes will occur as you start to use the program and get familiar with its operations. Before you contact PE Inc. here are a few hints. The program is designed to save data often so when a crash occurs you usually loose very little data.
When a crash occurs and the program is still open, try clicking on the main exit icon of the main window to exit the program. It looks like a man walking through a door or leaving a room.
If that fails ‘Control-Alt-Delete’ should take you to the Task Manager and you can close the program from there.
If portions of the program are still not working then ‘Re-Start’ the Windows Operating System.
Now, re-enter the program and try the procedure again.
If all else fails, send an e-mail to: staff@peincvb.com. You can describe the problem you are having or leave a number and time where I can contact you if you like. I will reply as soon as I can. A preview of this program is available at www.peincvb.com
PE Inc.
12557 S. 18th Circle
Jenks, OK 74037-3658DISCLOSURE AGREEMENT
PE Inc. grants you a non-exclusive right to use the object version of the Program solely for your own use subject to this Agreement. You agree not to modify, reverse engineer, reverse assemble, decompile, or disassemble the Program in whole or part. Furthermore you agree to comply with all U.S. laws and regulations relating to export of the Program. The Program is proprietary and confidential to PE Inc. and shall not be used by any third party (with or without compensation) without the prior written consent of PE Inc. You agree not to remarket the program or divulge its contents to any third party, other than your subsidiaries or affiliates. This program is based upon PE Inc.’s industry knowledge; however, the accuracy or correctness of information within cannot and will not be guaranteed. The user agrees that he shall rely upon the information provided herein at his own risk. Further, that neither PE Inc. nor its employees shall be liable or responsible for any loss, cost, damages or expenses whatsoever incurred or sustained by the user resulting from any interpretations made herein.
Appendix I – Sort & Search
Set Up Window
Several of the data grids used in this program have sorting and searching capabilities. By clicking on the top of the grid over any column heading, the grid will be sorted alphabetically based upon the data in that column. The cursor will then be placed for you in the SEARCH text box. You can start to type the name you are searching for and the grid arrow in the left border will be repositioned as you get closer to your objective. At any point by clicking on the left border you can select the corresponding name.Client / Reports or Pumper Windows
Grids on these windows may only be searched on the first column.
See (III. Selecting an Operator) above for a description of the search method.