TOOLS OF THE TRADE --SPREADSHEET SOFTWARE

Read "Terms of Use" before using these spreadsheets. Please be fair to the author and pay your Shareware Fee HERE.

YOU use thIS SOFTWARE at your sole risk and responsibility. NO WARRANTY IS EXPRESSED OR IMPLIED.

Please report errors or offer improved versions.


DOWNLOAD INSTRUCTIONS
Left Click on button, then Click "Save As" to put the file onto YOUR hard drive. All files are XLSX format. Crossplots where applicable are at the bottom of the spreadsheets. You may need to click "Enable Editing" and maximize the spreadsheet, depending on your device and security settings.

 

QUICKLOOK LOG ANALYSIS -- HANDPICKED DATA

META/KWIK "CONV"
Metric Units Version
Conventional Oil, Gas, and Tar
Shale volume, porosity, saturation, permeability,  net pay, productivity, reserves.

META/KWIK "CONV"
English Units Version
Conventional Oil, Gas, and Tar
Shale volume, porosity, saturation, permeability,  net pay, productivity, reserves.

META/KWIK "UNCONV"
Metric Units Version
Unconventional Oil and Gas
Shale volume, TOC, porosity, saturation, permeability,  net pay, productivity, reserves.

ADVANCED  LOG ANALYSIS -- CONTINUOUS OR HANDPICKED DATA

META/LOG "ESP"
Metric or English Units
Conventional Oil or Gas
Shale volume, porosity, lithology, saturation, permeability, net pay,, productivity, reserves, 3 crossplots.

META/LOG "TAR"
Metric or English Units
Tar Assay Version
Shale volume, porosity, lithology, saturation, permeability, net pay,, productivity, reserves, 3 crossplots.

META/LOG "CORE"
Metric or English Units
Conventional  Core Analysis Data
Sums, averages with cutoffs, 3 crossplots.
Same layout as META/ESP for easy comparison to log analysis results.

WATER RESISTIVITY, SALINITY, ELECTRICAL PROPERTIES TOOLS

META/LOG "RW"
Calculate Water Resistivity (RW)
5 Methods

META/LOG "SAL"
Calculate Water Salinity (WS)
3 Methods

META/LOG "PYR"
Calculate Effect of Pyrite
1 Method.

META/LOG "FRF"
Calculate and Plot Formation Factor and Resistivity Index
4 Crossplots

META/LOG "SCAL"
Calculate Irreducible Water Saturation
from Capillary Pressure Data
4 Crossplots

 

UNCONVENTIONAL RESERVOIR TOOLS

META/LOG "TOC"
Calculate Total Organic Carbon (TOC)
5 Methods

META/LOG "CBM"
Calculate Coal Assay, Coal Bed Methane, Gas In Place

META/LOG "WT-VOL"
Convert Weight Fraction to/from
 Volume Fraction

META/LOG "LAM"
Model Laminated Shaly Sands
and Laminated Porosity

META/LOG "YIELD"
Calculate Oil Yield
in Immature Oil Shale
6 Methods

META/LOG "K2O"
Calculate Potash Assay
Crain's Method

RESERVOIR ENGINEERING TOOLS

META/LOG "MECH"
Calculate Mechanical Properties, Formation Pressure, Closure Stress

META/LOG "DST"
Calculate Pressure Buildup, and Flow Capacity from Horner and Ramey Plots

META/LOG "CASH"
Calculate Production Profile, Costs,
 and Cash Flow

META/LOG "GAS"
Calculate Adsorbed and Free Gas
in Place

META/LOG "TVD"
Calculate True Vertical Depth
7 Methods

META/LOG "PERM"
Calculate and Compare Permeability
5 Methods

GEOSCIENCE ANALYSIS TOOLS

META/LOG "DIP"
Regional Dip Removal -- Dip Subtraction

META/LOG "MODL"
Calculate Log Response to Porosity, Lithology, Fluid Type

META/LOG "SEIS"
Calculate Seismic Response to Changes in Porosity, Lithology, Flui

META/LOG "LITH"
Calculate mineral properties for 2- and 3- mineral models
   
     

EXTERNAL RESOURCES -- OTHER USEFUL TOOLS

HIGHLY RECOMMENDED
KCP -- Edit / Repair LAS File
EESi -- Depth Plot LAS Files
Statcato Stats Package
Units Conversion Applet
Core Analysis Manual

 

SLB FREEWARE
LAS File Viewer
LAS Commander
Log Data Toolbox
Interactive Well Diagram
SLB Chartbook

 

USEFUL STUFF
Log Response Wall Chart
Stratigraphy Wall Chart
Geological Symbols / Abbreviations
CWLS RW Catalog -- Maps 1997
CWLS RW Catalog -- Maps 2002
CWLS RW Catalog -- Data 2002

 

 

 

Page Views ---- Since 01 Jan 2015
Copyright 1978 - 2018 E. R. Crain, P.Eng. All Rights Reserved