Hartowijaya Pty Ltd

Gas Management Tool Set Project (Permit to Mine Module)

Outline:

An Excel spreadsheet based tools to provide common Coal Mine Methane field calculations for Gas Drainage Engineers to standardize Permit to Mine calculations and process.

Key features of Project:

Gas In Place calculation based on specified polygon regions and geostatistical techniques (Kriging)

Key Benefits of Project:

Repeatability and basis for calculations

Exporting Drilling plans from AutoCAD to Excel

Outline:

To speed up budgeting for Underground Inseam Drilling (CBM), a macro/form was used to export flightplan (AutoCAD) information to an Excel worksheet. Borehole information was then used to prepare a drilling program budget.

Key features of Solution:

Export of data from AutoCAD to Excel worksheet

Key Benefits of Solution:

Significant reduction of time to prepare AFE/Budgets

Introduced an easy means of comparing multiple drilling program

Write a DXF file VB Example

The following Visual Basic subroutine constructs a DXF file representing a polygon.

Point in area Excel Example

http://www.andypope.info/fun/pointinarea.htm

Reading a DXF file VB Example

References:

http://www.codeproject.com/KB/cs/dxfreader.aspx

http://www.autodesk.com/techpubs/autocad/acad2000/dxf/lwpolyline_dxf_06.htm

LWPOLYLINE

The following group codes apply to lwpolyline entities. In addition to the group codes described here, see "Common Group Codes for Entities." For information about abbreviations and formatting used in this table, see "Formatting Conventions in This Reference."