Access - Structure for importing data

N

Neutralizer

Board Regular
Joined
Sep 23, 2009
Messages
53
Hi All,

I'm contemplating creating a database to hold a bunch of drill and blast information for a mine. The drill pattern and the loading information is provided by a contractor in either text or csv file format (in both cases the file is comma delimited).

Each one of these files is generated by a CAD program and contains a bunch of records with each record holding the following information:
* Drill hole ID
* Drill hole coordinates (X,Y,Z).
* Drill hole geometery (angle, bearing, diameter)
* Product loading information (deck length, deck weight, charge height and deck contents).

NOTE: A drill hole ID is only unique within any individual file, drill holes in other patterns (i.e. other files) will often have the same ID. So, each drill hole would only be truly uniquely identified if both the pattern ID and then the ID of each individual hole within that pattern are considered together.

The upshot of all this is:
* Each text/csv file is representative of a unique drill and blast pattern
* Each record in each file is representative of a unique drill hole and it's associated loading configuration (a unique ID in the form of the drill hole ID is already assigned by the CAD program).
* The number of records can be different in each file (different number of holes per pattern)
* The number of fields for each record can vary, both between files and within each individual file (different blast hole loading configurations such as multiple decks of explosives).

My question is, what is the best structure to use to hold this data?

Should I import each blast into a seperate table, or should I import them all into the same table and somehow add a field that stores the pattern ID and use a combination of the two fields as the primary key?

If the latter, how do I fill out the pattern ID field?
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
Sort by date Sort by votes
What do you mean fill out?

Is there data for the pattern other than the data for the drill holes and blasts?

eg date/period of pattern, pattern type, location etc

I think you probably want at least a pattern table with the ID an autonumber field (primary key) and 2 other tables, one for blast data and one for drill data.

In those 2 tables pattern ID would be a foreign key, an autonumber can be used for the primary key.

I'm pretty sure there'll be other tables needed.

One thing that I think needs further explanation is the changing no of fields.
 
Upvote 0
Essentially what I was wondering is if each time a new pattern is imported from a CSV, should I put each pattern into a seperate table or should I split up the information from each file into 'functional' tables (i.e. one for drilling, one for blasting etc as you seem to suggest).

To explain the changing number of fields, there are some fields that are always present in each file in the same number and position, however for other aspects (mainly the explosive loading configuration) sometimes there is only one set of fields or there can well be any numbers of sets of fields to cover this aspect if they are 'deck loading' the drill holes.

I've attached two ficticious examples that show the structure of the CSV files that we recieve. Each example shows the same blast pattern, but with a different charging configuration (hence why there is more fields/columns in the second example).

The green highlighted fields are always present in the same layout though the number of records can vary from file to file (Green = drilling information).

The other sets of coloured data relate to the charging configuration for the drill holes:
* The first example contains, just two 'decks' the maroon being the explosive product data and the red the stemming data.
* The second example is a more complex loading, with an explosive deck, an air deck, another explosive deck and then a stemming deck (there can be any number of decks theorectically, though there is rarely more than 12 sets of decking information in total)

Example 1:
Excel 2007<table rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6" cellpadding="2.5px"><colgroup><col style="background-color: #E0E0F0" width="25px"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th>
</th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th><th>J</th><th>K</th><th>L</th><th>M</th><th>N</th><th>O</th><th>P</th></tr></thead><tbody><tr><td style="color: #161120;text-align: center;">1</td><td style="font-weight: bold;text-align: center;color: #00B050;;">ID</td><td style="font-weight: bold;text-align: center;color: #00B050;;">X</td><td style="font-weight: bold;text-align: center;color: #00B050;;">Y</td><td style="font-weight: bold;text-align: center;color: #00B050;;">Z</td><td style="font-weight: bold;text-align: center;color: #00B050;;">Length</td><td style="font-weight: bold;text-align: center;color: #00B050;;">Angle</td><td style="font-weight: bold;text-align: center;color: #00B050;;">Diameter</td><td style="font-weight: bold;text-align: center;color: #00B050;;">Bearing</td><td style="font-weight: bold;text-align: center;color: #953735;;">Deck length 1</td><td style="font-weight: bold;text-align: center;color: #953735;;">Deck weight 1</td><td style="font-weight: bold;text-align: center;color: #953735;;">Charge to 1</td><td style="font-weight: bold;text-align: center;color: #953735;;">Deck contents 1</td><td style="font-weight: bold;text-align: center;color: #FF0000;;">Deck length 2</td><td style="font-weight: bold;text-align: center;color: #FF0000;;">Deck weight 2</td><td style="font-weight: bold;text-align: center;color: #FF0000;;">Charge to 2</td><td style="font-weight: bold;text-align: center;color: #FF0000;;">Deck contents 2</td></tr><tr><td style="color: #161120;text-align: center;">2</td><td style="text-align: center;color: #00B050;;">A5</td><td style="text-align: center;color: #00B050;;">695509.07</td><td style="text-align: center;color: #00B050;;">7422209.84</td><td style="text-align: center;color: #00B050;;">25</td><td style="text-align: center;color: #00B050;;">30.29</td><td style="text-align: center;color: #00B050;;">20</td><td style="text-align: center;color: #00B050;;">229</td><td style="text-align: center;color: #00B050;;">147.7</td><td style="text-align: center;color: #953735;;">25.3</td><td style="text-align: center;color: #953735;;">1146.1</td><td style="text-align: center;color: #953735;;">10</td><td style="text-align: center;color: #953735;;">CoalCharge 1.1</td><td style="text-align: center;color: #FF0000;;">5</td><td style="text-align: center;color: #FF0000;;">205.9</td><td style="text-align: center;color: #FF0000;;">0</td><td style="text-align: center;color: #FF0000;;">Stemming</td></tr><tr><td style="color: #161120;text-align: center;">3</td><td style="text-align: center;color: #00B050;;">A6</td><td style="text-align: center;color: #00B050;;">695516.68</td><td style="text-align: center;color: #00B050;;">7422214.65</td><td style="text-align: center;color: #00B050;;">25</td><td style="text-align: center;color: #00B050;;">32.02</td><td style="text-align: center;color: #00B050;;">20</td><td style="text-align: center;color: #00B050;;">229</td><td style="text-align: center;color: #00B050;;">147.7</td><td style="text-align: center;color: #953735;;">27</td><td style="text-align: center;color: #953735;;">1223.1</td><td style="text-align: center;color: #953735;;">10</td><td style="text-align: center;color: #953735;;">CoalCharge 1.1</td><td style="text-align: center;color: #FF0000;;">5</td><td style="text-align: center;color: #FF0000;;">205.9</td><td style="text-align: center;color: #FF0000;;">0</td><td style="text-align: center;color: #FF0000;;">Stemming</td></tr><tr><td style="color: #161120;text-align: center;">4</td><td style="text-align: center;color: #00B050;;">A7</td><td style="text-align: center;color: #00B050;;">695524.02</td><td style="text-align: center;color: #00B050;;">7422219.88</td><td style="text-align: center;color: #00B050;;">25</td><td style="text-align: center;color: #00B050;;">33.75</td><td style="text-align: center;color: #00B050;;">20</td><td style="text-align: center;color: #00B050;;">229</td><td style="text-align: center;color: #00B050;;">147.7</td><td style="text-align: center;color: #953735;;">28.8</td><td style="text-align: center;color: #953735;;">1304.6</td><td style="text-align: center;color: #953735;;">10</td><td style="text-align: center;color: #953735;;">CoalCharge 1.1</td><td style="text-align: center;color: #FF0000;;">5</td><td style="text-align: center;color: #FF0000;;">205.9</td><td style="text-align: center;color: #FF0000;;">0</td><td style="text-align: center;color: #FF0000;;">Stemming</td></tr><tr><td style="color: #161120;text-align: center;">5</td><td style="text-align: center;color: #00B050;;">A8</td><td style="text-align: center;color: #00B050;;">695531.36</td><td style="text-align: center;color: #00B050;;">7422225.11</td><td style="text-align: center;color: #00B050;;">25</td><td style="text-align: center;color: #00B050;;">28.6</td><td style="text-align: center;color: #00B050;;">20</td><td style="text-align: center;color: #00B050;;">229</td><td style="text-align: center;color: #00B050;;">147.7</td><td style="text-align: center;color: #953735;;">23.6</td><td style="text-align: center;color: #953735;;">1069.1</td><td style="text-align: center;color: #953735;;">10</td><td style="text-align: center;color: #953735;;">CoalCharge 1.1</td><td style="text-align: center;color: #FF0000;;">5</td><td style="text-align: center;color: #FF0000;;">205.9</td><td style="text-align: center;color: #FF0000;;">0</td><td style="text-align: center;color: #FF0000;;">Stemming</td></tr><tr><td style="color: #161120;text-align: center;">6</td><td style="text-align: center;color: #00B050;;">A9</td><td style="text-align: center;color: #00B050;;">695539.24</td><td style="text-align: center;color: #00B050;;">7422229.5</td><td style="text-align: center;color: #00B050;;">25</td><td style="text-align: center;color: #00B050;;">28.6</td><td style="text-align: center;color: #00B050;;">20</td><td style="text-align: center;color: #00B050;;">229</td><td style="text-align: center;color: #00B050;;">147.7</td><td style="text-align: center;color: #953735;;">23.6</td><td style="text-align: center;color: #953735;;">1069.1</td><td style="text-align: center;color: #953735;;">10</td><td style="text-align: center;color: #953735;;">CoalCharge 1.1</td><td style="text-align: center;color: #FF0000;;">5</td><td style="text-align: center;color: #FF0000;;">205.9</td><td style="text-align: center;color: #FF0000;;">0</td><td style="text-align: center;color: #FF0000;;">Stemming</td></tr><tr><td style="color: #161120;text-align: center;">7</td><td style="text-align: center;color: #00B050;;">A10</td><td style="text-align: center;color: #00B050;;">695547.11</td><td style="text-align: center;color: #00B050;;">7422233.88</td><td style="text-align: center;color: #00B050;;">25</td><td style="text-align: center;color: #00B050;;">28.6</td><td style="text-align: center;color: #00B050;;">20</td><td style="text-align: center;color: #00B050;;">229</td><td style="text-align: center;color: #00B050;;">147.7</td><td style="text-align: center;color: #953735;;">23.6</td><td style="text-align: center;color: #953735;;">1069.1</td><td style="text-align: center;color: #953735;;">10</td><td style="text-align: center;color: #953735;;">CoalCharge 1.1</td><td style="text-align: center;color: #FF0000;;">5</td><td style="text-align: center;color: #FF0000;;">205.9</td><td style="text-align: center;color: #FF0000;;">0</td><td style="text-align: center;color: #FF0000;;">Stemming</td></tr><tr><td style="color: #161120;text-align: center;">8</td><td style="text-align: center;color: #00B050;;">B1</td><td style="text-align: center;color: #00B050;;">695482.18</td><td style="text-align: center;color: #00B050;;">7422193.44</td><td style="text-align: center;color: #00B050;;">25</td><td style="text-align: center;color: #00B050;;">17.2</td><td style="text-align: center;color: #00B050;;">0</td><td style="text-align: center;color: #00B050;;">229</td><td style="text-align: center;color: #00B050;;">147.7</td><td style="text-align: center;color: #953735;;">12.2</td><td style="text-align: center;color: #953735;;">552.6</td><td style="text-align: center;color: #953735;;">5</td><td style="text-align: center;color: #953735;;">CoalCharge 1.1</td><td style="text-align: center;color: #FF0000;;">5</td><td style="text-align: center;color: #FF0000;;">205.9</td><td style="text-align: center;color: #FF0000;;">0</td><td style="text-align: center;color: #FF0000;;">Stemming</td></tr><tr><td style="color: #161120;text-align: center;">9</td><td style="text-align: center;color: #00B050;;">B2</td><td style="text-align: center;color: #00B050;;">695489.79</td><td style="text-align: center;color: #00B050;;">7422198.25</td><td style="text-align: center;color: #00B050;;">25</td><td style="text-align: center;color: #00B050;;">19.17</td><td style="text-align: center;color: #00B050;;">0</td><td style="text-align: center;color: #00B050;;">229</td><td style="text-align: center;color: #00B050;;">147.7</td><td style="text-align: center;color: #953735;;">14.2</td><td style="text-align: center;color: #953735;;">642.2</td><td style="text-align: center;color: #953735;;">5</td><td style="text-align: center;color: #953735;;">CoalCharge 1.1</td><td style="text-align: center;color: #FF0000;;">5</td><td style="text-align: center;color: #FF0000;;">205.9</td><td style="text-align: center;color: #FF0000;;">0</td><td style="text-align: center;color: #FF0000;;">Stemming</td></tr><tr><td style="color: #161120;text-align: center;">10</td><td style="text-align: center;color: #00B050;;">B3</td><td style="text-align: center;color: #00B050;;">695497.66</td><td style="text-align: center;color: #00B050;;">7422202.63</td><td style="text-align: center;color: #00B050;;">25</td><td style="text-align: center;color: #00B050;;">21.2</td><td style="text-align: center;color: #00B050;;">0</td><td style="text-align: center;color: #00B050;;">229</td><td style="text-align: center;color: #00B050;;">147.7</td><td style="text-align: center;color: #953735;;">16.2</td><td style="text-align: center;color: #953735;;">733.9</td><td style="text-align: center;color: #953735;;">5</td><td style="text-align: center;color: #953735;;">CoalCharge 1.1</td><td style="text-align: center;color: #FF0000;;">5</td><td style="text-align: center;color: #FF0000;;">205.9</td><td style="text-align: center;color: #FF0000;;">0</td><td style="text-align: center;color: #FF0000;;">Stemming</td></tr><tr><td style="color: #161120;text-align: center;">11</td><td style="text-align: center;color: #00B050;;">B4</td><td style="text-align: center;color: #00B050;;">695505.27</td><td style="text-align: center;color: #00B050;;">7422207.44</td><td style="text-align: center;color: #00B050;;">25</td><td style="text-align: center;color: #00B050;;">23.03</td><td style="text-align: center;color: #00B050;;">0</td><td style="text-align: center;color: #00B050;;">229</td><td style="text-align: center;color: #00B050;;">147.7</td><td style="text-align: center;color: #953735;;">18</td><td style="text-align: center;color: #953735;;">816.8</td><td style="text-align: center;color: #953735;;">5</td><td style="text-align: center;color: #953735;;">CoalCharge 1.1</td><td style="text-align: center;color: #FF0000;;">5</td><td style="text-align: center;color: #FF0000;;">205.9</td><td style="text-align: center;color: #FF0000;;">0</td><td style="text-align: center;color: #FF0000;;">Stemming</td></tr><tr><td style="color: #161120;text-align: center;">12</td><td style="text-align: center;color: #00B050;;">B5</td><td style="text-align: center;color: #00B050;;">695512.88</td><td style="text-align: center;color: #00B050;;">7422212.25</td><td style="text-align: center;color: #00B050;;">25</td><td style="text-align: center;color: #00B050;;">24.6</td><td style="text-align: center;color: #00B050;;">0</td><td style="text-align: center;color: #00B050;;">229</td><td style="text-align: center;color: #00B050;;">147.7</td><td style="text-align: center;color: #953735;;">19.6</td><td style="text-align: center;color: #953735;;">887.8</td><td style="text-align: center;color: #953735;;">5</td><td style="text-align: center;color: #953735;;">CoalCharge 1.1</td><td style="text-align: center;color: #FF0000;;">5</td><td style="text-align: center;color: #FF0000;;">205.9</td><td style="text-align: center;color: #FF0000;;">0</td><td style="text-align: center;color: #FF0000;;">Stemming</td></tr><tr><td style="color: #161120;text-align: center;">13</td><td style="text-align: center;color: #00B050;;">C5</td><td style="text-align: center;color: #00B050;;">695505.33</td><td style="text-align: center;color: #00B050;;">7422215.76</td><td style="text-align: center;color: #00B050;;">24.97</td><td style="text-align: center;color: #00B050;;">23.16</td><td style="text-align: center;color: #00B050;;">0</td><td style="text-align: center;color: #00B050;;">229</td><td style="text-align: center;color: #00B050;;">147.7</td><td style="text-align: center;color: #953735;;">18.2</td><td style="text-align: center;color: #953735;;">822.9</td><td style="text-align: center;color: #953735;;">5</td><td style="text-align: center;color: #953735;;">CoalCharge 1.1</td><td style="text-align: center;color: #FF0000;;">5</td><td style="text-align: center;color: #FF0000;;">205.9</td><td style="text-align: center;color: #FF0000;;">0</td><td style="text-align: center;color: #FF0000;;">Stemming</td></tr><tr><td style="color: #161120;text-align: center;">14</td><td style="text-align: center;color: #00B050;;">C6</td><td style="text-align: center;color: #00B050;;">695512.94</td><td style="text-align: center;color: #00B050;;">7422220.57</td><td style="text-align: center;color: #00B050;;">24.97</td><td style="text-align: center;color: #00B050;;">24.97</td><td style="text-align: center;color: #00B050;;">0</td><td style="text-align: center;color: #00B050;;">229</td><td style="text-align: center;color: #00B050;;">147.7</td><td style="text-align: center;color: #953735;;">20</td><td style="text-align: center;color: #953735;;">904.9</td><td style="text-align: center;color: #953735;;">5</td><td style="text-align: center;color: #953735;;">CoalCharge 1.1</td><td style="text-align: center;color: #FF0000;;">5</td><td style="text-align: center;color: #FF0000;;">205.9</td><td style="text-align: center;color: #FF0000;;">0</td><td style="text-align: center;color: #FF0000;;">Stemming</td></tr><tr><td style="color: #161120;text-align: center;">15</td><td style="text-align: center;color: #00B050;;">C7</td><td style="text-align: center;color: #00B050;;">695520.55</td><td style="text-align: center;color: #00B050;;">7422225.38</td><td style="text-align: center;color: #00B050;;">24.98</td><td style="text-align: center;color: #00B050;;">26.82</td><td style="text-align: center;color: #00B050;;">0</td><td style="text-align: center;color: #00B050;;">229</td><td style="text-align: center;color: #00B050;;">147.7</td><td style="text-align: center;color: #953735;;">21.8</td><td style="text-align: center;color: #953735;;">988.4</td><td style="text-align: center;color: #953735;;">5</td><td style="text-align: center;color: #953735;;">CoalCharge 1.1</td><td style="text-align: center;color: #FF0000;;">5</td><td style="text-align: center;color: #FF0000;;">205.9</td><td style="text-align: center;color: #FF0000;;">0</td><td style="text-align: center;color: #FF0000;;">Stemming</td></tr><tr><td style="color: #161120;text-align: center;">16</td><td style="text-align: center;color: #00B050;;">C8</td><td style="text-align: center;color: #00B050;;">695528.16</td><td style="text-align: center;color: #00B050;;">7422230.18</td><td style="text-align: center;color: #00B050;;">24.98</td><td style="text-align: center;color: #00B050;;">26.98</td><td style="text-align: center;color: #00B050;;">0</td><td style="text-align: center;color: #00B050;;">229</td><td style="text-align: center;color: #00B050;;">147.7</td><td style="text-align: center;color: #953735;;">22</td><td style="text-align: center;color: #953735;;">995.8</td><td style="text-align: center;color: #953735;;">5</td><td style="text-align: center;color: #953735;;">CoalCharge 1.1</td><td style="text-align: center;color: #FF0000;;">5</td><td style="text-align: center;color: #FF0000;;">205.9</td><td style="text-align: center;color: #FF0000;;">0</td><td style="text-align: center;color: #FF0000;;">Stemming</td></tr><tr><td style="color: #161120;text-align: center;">17</td><td style="text-align: center;color: #00B050;;">C9</td><td style="text-align: center;color: #00B050;;">695535.77</td><td style="text-align: center;color: #00B050;;">7422234.99</td><td style="text-align: center;color: #00B050;;">24.98</td><td style="text-align: center;color: #00B050;;">26.98</td><td style="text-align: center;color: #00B050;;">0</td><td style="text-align: center;color: #00B050;;">229</td><td style="text-align: center;color: #00B050;;">147.7</td><td style="text-align: center;color: #953735;;">22</td><td style="text-align: center;color: #953735;;">995.7</td><td style="text-align: center;color: #953735;;">5</td><td style="text-align: center;color: #953735;;">CoalCharge 1.1</td><td style="text-align: center;color: #FF0000;;">5</td><td style="text-align: center;color: #FF0000;;">205.9</td><td style="text-align: center;color: #FF0000;;">0</td><td style="text-align: center;color: #FF0000;;">Stemming</td></tr><tr><td style="color: #161120;text-align: center;">18</td><td style="text-align: center;color: #00B050;;">C10</td><td style="text-align: center;color: #00B050;;">695543.37</td><td style="text-align: center;color: #00B050;;">7422239.8</td><td style="text-align: center;color: #00B050;;">24.97</td><td style="text-align: center;color: #00B050;;">26.98</td><td style="text-align: center;color: #00B050;;">0</td><td style="text-align: center;color: #00B050;;">229</td><td style="text-align: center;color: #00B050;;">147.7</td><td style="text-align: center;color: #953735;;">22</td><td style="text-align: center;color: #953735;;">995.6</td><td style="text-align: center;color: #953735;;">5</td><td style="text-align: center;color: #953735;;">CoalCharge 1.1</td><td style="text-align: center;color: #FF0000;;">5</td><td style="text-align: center;color: #FF0000;;">205.9</td><td style="text-align: center;color: #FF0000;;">0</td><td style="text-align: center;color: #FF0000;;">Stemming</td></tr></tbody></table>
Sheet2
​




Example 2:
Excel 2007<table rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6" cellpadding="2.5px"><colgroup><col style="background-color: #E0E0F0" width="25px"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th>
</th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th><th>J</th><th>K</th><th>L</th><th>M</th><th>N</th><th>O</th><th>P</th><th>Q</th><th>R</th><th>S</th><th>T</th><th>U</th><th>V</th><th>W</th><th>X</th></tr></thead><tbody><tr><td style="color: #161120;text-align: center;">1</td><td style="font-weight: bold;text-align: center;color: #00B050;;">ID</td><td style="font-weight: bold;text-align: center;color: #00B050;;">X</td><td style="font-weight: bold;text-align: center;color: #00B050;;">Y</td><td style="font-weight: bold;text-align: center;color: #00B050;;">Z</td><td style="font-weight: bold;text-align: center;color: #00B050;;">Length</td><td style="font-weight: bold;text-align: center;color: #00B050;;">Angle</td><td style="font-weight: bold;text-align: center;color: #00B050;;">Diameter</td><td style="font-weight: bold;text-align: center;color: #00B050;;">Bearing</td><td style="font-weight: bold;text-align: center;color: #953735;;">Deck length 1</td><td style="font-weight: bold;text-align: center;color: #953735;;">Deck weight 1</td><td style="font-weight: bold;text-align: center;color: #953735;;">Charge to 1</td><td style="font-weight: bold;text-align: center;color: #953735;;">Deck contents 1</td><td style="font-weight: bold;text-align: center;color: #7030A0;;">Deck length 2</td><td style="font-weight: bold;text-align: center;color: #7030A0;;">Deck weight 2</td><td style="font-weight: bold;text-align: center;color: #7030A0;;">Charge to 2</td><td style="font-weight: bold;text-align: center;color: #7030A0;;">Deck contents 2</td><td style="font-weight: bold;text-align: center;color: #0070C0;;">Deck length 3</td><td style="font-weight: bold;text-align: center;color: #0070C0;;">Deck weight 3</td><td style="font-weight: bold;text-align: center;color: #0070C0;;">Charge to 3</td><td style="font-weight: bold;text-align: center;color: #0070C0;;">Deck contents 3</td><td style="font-weight: bold;text-align: center;color: #FF0000;;">Deck length 4
</td><td style="font-weight: bold;text-align: center;color: #FF0000;;">Deck weight 4
</td><td style="font-weight: bold;text-align: center;color: #FF0000;;">Charge to 4
</td><td style="font-weight: bold;text-align: center;color: #FF0000;;">Deck contents 4
</td></tr><tr><td style="color: #161120;text-align: center;">2</td><td style="text-align: center;color: #00B050;;">A5</td><td style="text-align: center;color: #00B050;;">695509.07</td><td style="text-align: center;color: #00B050;;">7422209.84</td><td style="text-align: center;color: #00B050;;">25</td><td style="text-align: center;color: #00B050;;">30.29</td><td style="text-align: center;color: #00B050;;">20</td><td style="text-align: center;color: #00B050;;">229</td><td style="text-align: center;color: #00B050;;">147.7</td><td style="text-align: center;color: #953735;;">10.15</td><td style="text-align: center;color: #953735;;">459.65</td><td style="text-align: center;color: #953735;;">5</td><td style="text-align: center;color: #953735;;">CoalCharge 1.3</td><td style="text-align: center;color: #7030A0;;">5</td><td style="text-align: center;color: #7030A0;;">0</td><td style="text-align: center;color: #7030A0;;">5</td><td style="text-align: center;color: #7030A0;;">Air</td><td style="text-align: center;color: #0070C0;;">5.075</td><td style="text-align: center;color: #0070C0;;">229.825</td><td style="text-align: center;color: #0070C0;;">2.5</td><td style="text-align: center;color: #0070C0;;">CoalCharge 1.05</td><td style="text-align: center;color: #FF0000;;">5</td><td style="text-align: center;color: #FF0000;;">205.9</td><td style="text-align: center;color: #FF0000;;">0</td><td style="text-align: center;color: #FF0000;;">Stemming</td></tr><tr><td style="color: #161120;text-align: center;">3</td><td style="text-align: center;color: #00B050;;">A6</td><td style="text-align: center;color: #00B050;;">695516.68</td><td style="text-align: center;color: #00B050;;">7422214.65</td><td style="text-align: center;color: #00B050;;">25</td><td style="text-align: center;color: #00B050;;">32.02</td><td style="text-align: center;color: #00B050;;">20</td><td style="text-align: center;color: #00B050;;">229</td><td style="text-align: center;color: #00B050;;">147.7</td><td style="text-align: center;color: #953735;;">11</td><td style="text-align: center;color: #953735;;">498.9</td><td style="text-align: center;color: #953735;;">5</td><td style="text-align: center;color: #953735;;">CoalCharge 1.3</td><td style="text-align: center;color: #7030A0;;">5</td><td style="text-align: center;color: #7030A0;;">0</td><td style="text-align: center;color: #7030A0;;">5</td><td style="text-align: center;color: #7030A0;;">Air</td><td style="text-align: center;color: #0070C0;;">5.5</td><td style="text-align: center;color: #0070C0;;">249.45</td><td style="text-align: center;color: #0070C0;;">2.5</td><td style="text-align: center;color: #0070C0;;">CoalCharge 1.05</td><td style="text-align: center;color: #FF0000;;">5</td><td style="text-align: center;color: #FF0000;;">205.9</td><td style="text-align: center;color: #FF0000;;">0</td><td style="text-align: center;color: #FF0000;;">Stemming</td></tr><tr><td style="color: #161120;text-align: center;">4</td><td style="text-align: center;color: #00B050;;">A7</td><td style="text-align: center;color: #00B050;;">695524.02</td><td style="text-align: center;color: #00B050;;">7422219.88</td><td style="text-align: center;color: #00B050;;">25</td><td style="text-align: center;color: #00B050;;">33.75</td><td style="text-align: center;color: #00B050;;">20</td><td style="text-align: center;color: #00B050;;">229</td><td style="text-align: center;color: #00B050;;">147.7</td><td style="text-align: center;color: #953735;;">11.9</td><td style="text-align: center;color: #953735;;">538.1</td><td style="text-align: center;color: #953735;;">5</td><td style="text-align: center;color: #953735;;">CoalCharge 1.3</td><td style="text-align: center;color: #7030A0;;">5</td><td style="text-align: center;color: #7030A0;;">0</td><td style="text-align: center;color: #7030A0;;">5</td><td style="text-align: center;color: #7030A0;;">Air</td><td style="text-align: center;color: #0070C0;;">5.95</td><td style="text-align: center;color: #0070C0;;">269.05</td><td style="text-align: center;color: #0070C0;;">2.5</td><td style="text-align: center;color: #0070C0;;">CoalCharge 1.05</td><td style="text-align: center;color: #FF0000;;">5</td><td style="text-align: center;color: #FF0000;;">205.9</td><td style="text-align: center;color: #FF0000;;">0</td><td style="text-align: center;color: #FF0000;;">Stemming</td></tr><tr><td style="color: #161120;text-align: center;">5</td><td style="text-align: center;color: #00B050;;">A8</td><td style="text-align: center;color: #00B050;;">695531.36</td><td style="text-align: center;color: #00B050;;">7422225.11</td><td style="text-align: center;color: #00B050;;">25</td><td style="text-align: center;color: #00B050;;">28.6</td><td style="text-align: center;color: #00B050;;">20</td><td style="text-align: center;color: #00B050;;">229</td><td style="text-align: center;color: #00B050;;">147.7</td><td style="text-align: center;color: #953735;;">9.3</td><td style="text-align: center;color: #953735;;">421.45</td><td style="text-align: center;color: #953735;;">5</td><td style="text-align: center;color: #953735;;">CoalCharge 1.3</td><td style="text-align: center;color: #7030A0;;">5</td><td style="text-align: center;color: #7030A0;;">0</td><td style="text-align: center;color: #7030A0;;">5</td><td style="text-align: center;color: #7030A0;;">Air</td><td style="text-align: center;color: #0070C0;;">4.65</td><td style="text-align: center;color: #0070C0;;">210.725</td><td style="text-align: center;color: #0070C0;;">2.5</td><td style="text-align: center;color: #0070C0;;">CoalCharge 1.05</td><td style="text-align: center;color: #FF0000;;">5</td><td style="text-align: center;color: #FF0000;;">205.9</td><td style="text-align: center;color: #FF0000;;">0</td><td style="text-align: center;color: #FF0000;;">Stemming</td></tr><tr><td style="color: #161120;text-align: center;">6</td><td style="text-align: center;color: #00B050;;">A9</td><td style="text-align: center;color: #00B050;;">695539.24</td><td style="text-align: center;color: #00B050;;">7422229.5</td><td style="text-align: center;color: #00B050;;">25</td><td style="text-align: center;color: #00B050;;">28.6</td><td style="text-align: center;color: #00B050;;">20</td><td style="text-align: center;color: #00B050;;">229</td><td style="text-align: center;color: #00B050;;">147.7</td><td style="text-align: center;color: #953735;;">9.3</td><td style="text-align: center;color: #953735;;">421.45</td><td style="text-align: center;color: #953735;;">5</td><td style="text-align: center;color: #953735;;">CoalCharge 1.3</td><td style="text-align: center;color: #7030A0;;">5</td><td style="text-align: center;color: #7030A0;;">0</td><td style="text-align: center;color: #7030A0;;">5</td><td style="text-align: center;color: #7030A0;;">Air</td><td style="text-align: center;color: #0070C0;;">4.65</td><td style="text-align: center;color: #0070C0;;">210.725</td><td style="text-align: center;color: #0070C0;;">2.5</td><td style="text-align: center;color: #0070C0;;">CoalCharge 1.05</td><td style="text-align: center;color: #FF0000;;">5</td><td style="text-align: center;color: #FF0000;;">205.9</td><td style="text-align: center;color: #FF0000;;">0</td><td style="text-align: center;color: #FF0000;;">Stemming</td></tr><tr><td style="color: #161120;text-align: center;">7</td><td style="text-align: center;color: #00B050;;">A10</td><td style="text-align: center;color: #00B050;;">695547.11</td><td style="text-align: center;color: #00B050;;">7422233.88</td><td style="text-align: center;color: #00B050;;">25</td><td style="text-align: center;color: #00B050;;">28.6</td><td style="text-align: center;color: #00B050;;">20</td><td style="text-align: center;color: #00B050;;">229</td><td style="text-align: center;color: #00B050;;">147.7</td><td style="text-align: center;color: #953735;;">9.3</td><td style="text-align: center;color: #953735;;">421.45</td><td style="text-align: center;color: #953735;;">5</td><td style="text-align: center;color: #953735;;">CoalCharge 1.3</td><td style="text-align: center;color: #7030A0;;">5</td><td style="text-align: center;color: #7030A0;;">0</td><td style="text-align: center;color: #7030A0;;">5</td><td style="text-align: center;color: #7030A0;;">Air</td><td style="text-align: center;color: #0070C0;;">4.65</td><td style="text-align: center;color: #0070C0;;">210.725</td><td style="text-align: center;color: #0070C0;;">2.5</td><td style="text-align: center;color: #0070C0;;">CoalCharge 1.05</td><td style="text-align: center;color: #FF0000;;">5</td><td style="text-align: center;color: #FF0000;;">205.9</td><td style="text-align: center;color: #FF0000;;">0</td><td style="text-align: center;color: #FF0000;;">Stemming</td></tr><tr><td style="color: #161120;text-align: center;">8</td><td style="text-align: center;color: #00B050;;">B1</td><td style="text-align: center;color: #00B050;;">695482.18</td><td style="text-align: center;color: #00B050;;">7422193.44</td><td style="text-align: center;color: #00B050;;">25</td><td style="text-align: center;color: #00B050;;">17.2</td><td style="text-align: center;color: #00B050;;">0</td><td style="text-align: center;color: #00B050;;">229</td><td style="text-align: center;color: #00B050;;">147.7</td><td style="text-align: center;color: #953735;;">6.1</td><td style="text-align: center;color: #953735;;">276.3</td><td style="text-align: center;color: #953735;;">2.5</td><td style="text-align: center;color: #953735;;">CoalCharge 1.3</td><td style="text-align: center;;">
</td><td style="text-align: center;;">
</td><td style="text-align: center;;">
</td><td style="text-align: center;;">
</td><td style="text-align: center;color: #0070C0;;">3.05</td><td style="text-align: center;color: #0070C0;;">138.15</td><td style="text-align: center;color: #0070C0;;">1.25</td><td style="text-align: center;color: #0070C0;;">CoalCharge 1.05</td><td style="text-align: center;color: #FF0000;;">5</td><td style="text-align: center;color: #FF0000;;">205.9</td><td style="text-align: center;color: #FF0000;;">0</td><td style="text-align: center;color: #FF0000;;">Stemming</td></tr><tr><td style="color: #161120;text-align: center;">9</td><td style="text-align: center;color: #00B050;;">B2</td><td style="text-align: center;color: #00B050;;">695489.79</td><td style="text-align: center;color: #00B050;;">7422198.25</td><td style="text-align: center;color: #00B050;;">25</td><td style="text-align: center;color: #00B050;;">19.17</td><td style="text-align: center;color: #00B050;;">0</td><td style="text-align: center;color: #00B050;;">229</td><td style="text-align: center;color: #00B050;;">147.7</td><td style="text-align: center;color: #953735;;">7.1</td><td style="text-align: center;color: #953735;;">321.1</td><td style="text-align: center;color: #953735;;">2.5</td><td style="text-align: center;color: #953735;;">CoalCharge 1.3</td><td style="text-align: center;;">
</td><td style="text-align: center;;">
</td><td style="text-align: center;;">
</td><td style="text-align: center;;">
</td><td style="text-align: center;color: #0070C0;;">3.55</td><td style="text-align: center;color: #0070C0;;">160.55</td><td style="text-align: center;color: #0070C0;;">1.25</td><td style="text-align: center;color: #0070C0;;">CoalCharge 1.05</td><td style="text-align: center;color: #FF0000;;">5</td><td style="text-align: center;color: #FF0000;;">205.9</td><td style="text-align: center;color: #FF0000;;">0</td><td style="text-align: center;color: #FF0000;;">Stemming</td></tr><tr><td style="color: #161120;text-align: center;">10</td><td style="text-align: center;color: #00B050;;">B3</td><td style="text-align: center;color: #00B050;;">695497.66</td><td style="text-align: center;color: #00B050;;">7422202.63</td><td style="text-align: center;color: #00B050;;">25</td><td style="text-align: center;color: #00B050;;">21.2</td><td style="text-align: center;color: #00B050;;">0</td><td style="text-align: center;color: #00B050;;">229</td><td style="text-align: center;color: #00B050;;">147.7</td><td style="text-align: center;color: #953735;;">8.1</td><td style="text-align: center;color: #953735;;">366.95</td><td style="text-align: center;color: #953735;;">2.5</td><td style="text-align: center;color: #953735;;">CoalCharge 1.3</td><td style="text-align: center;;">
</td><td style="text-align: center;;">
</td><td style="text-align: center;;">
</td><td style="text-align: center;;">
</td><td style="text-align: center;color: #0070C0;;">4.05</td><td style="text-align: center;color: #0070C0;;">183.475</td><td style="text-align: center;color: #0070C0;;">1.25</td><td style="text-align: center;color: #0070C0;;">CoalCharge 1.05</td><td style="text-align: center;color: #FF0000;;">5</td><td style="text-align: center;color: #FF0000;;">205.9</td><td style="text-align: center;color: #FF0000;;">0</td><td style="text-align: center;color: #FF0000;;">Stemming</td></tr><tr><td style="color: #161120;text-align: center;">11</td><td style="text-align: center;color: #00B050;;">B4</td><td style="text-align: center;color: #00B050;;">695505.27</td><td style="text-align: center;color: #00B050;;">7422207.44</td><td style="text-align: center;color: #00B050;;">25</td><td style="text-align: center;color: #00B050;;">23.03</td><td style="text-align: center;color: #00B050;;">0</td><td style="text-align: center;color: #00B050;;">229</td><td style="text-align: center;color: #00B050;;">147.7</td><td style="text-align: center;color: #953735;;">9</td><td style="text-align: center;color: #953735;;">408.4</td><td style="text-align: center;color: #953735;;">2.5</td><td style="text-align: center;color: #953735;;">CoalCharge 1.3</td><td style="text-align: center;;">
</td><td style="text-align: center;;">
</td><td style="text-align: center;;">
</td><td style="text-align: center;;">
</td><td style="text-align: center;color: #0070C0;;">4.5</td><td style="text-align: center;color: #0070C0;;">204.2</td><td style="text-align: center;color: #0070C0;;">1.25</td><td style="text-align: center;color: #0070C0;;">CoalCharge 1.05</td><td style="text-align: center;color: #FF0000;;">5</td><td style="text-align: center;color: #FF0000;;">205.9</td><td style="text-align: center;color: #FF0000;;">0</td><td style="text-align: center;color: #FF0000;;">Stemming</td></tr><tr><td style="color: #161120;text-align: center;">12</td><td style="text-align: center;color: #00B050;;">B5</td><td style="text-align: center;color: #00B050;;">695512.88</td><td style="text-align: center;color: #00B050;;">7422212.25</td><td style="text-align: center;color: #00B050;;">25</td><td style="text-align: center;color: #00B050;;">24.6</td><td style="text-align: center;color: #00B050;;">0</td><td style="text-align: center;color: #00B050;;">229</td><td style="text-align: center;color: #00B050;;">147.7</td><td style="text-align: center;color: #953735;;">9.8</td><td style="text-align: center;color: #953735;;">443.9</td><td style="text-align: center;color: #953735;;">2.5</td><td style="text-align: center;color: #953735;;">CoalCharge 1.3</td><td style="text-align: center;;">
</td><td style="text-align: center;;">
</td><td style="text-align: center;;">
</td><td style="text-align: center;;">
</td><td style="text-align: center;color: #0070C0;;">4.9</td><td style="text-align: center;color: #0070C0;;">221.95</td><td style="text-align: center;color: #0070C0;;">1.25</td><td style="text-align: center;color: #0070C0;;">CoalCharge 1.05</td><td style="text-align: center;color: #FF0000;;">5</td><td style="text-align: center;color: #FF0000;;">205.9</td><td style="text-align: center;color: #FF0000;;">0</td><td style="text-align: center;color: #FF0000;;">Stemming</td></tr><tr><td style="color: #161120;text-align: center;">13</td><td style="text-align: center;color: #00B050;;">C5</td><td style="text-align: center;color: #00B050;;">695505.33</td><td style="text-align: center;color: #00B050;;">7422215.76</td><td style="text-align: center;color: #00B050;;">24.97</td><td style="text-align: center;color: #00B050;;">23.16</td><td style="text-align: center;color: #00B050;;">0</td><td style="text-align: center;color: #00B050;;">229</td><td style="text-align: center;color: #00B050;;">147.7</td><td style="text-align: center;color: #953735;;">9.1</td><td style="text-align: center;color: #953735;;">411.45</td><td style="text-align: center;color: #953735;;">2.5</td><td style="text-align: center;color: #953735;;">CoalCharge 1.3</td><td style="text-align: center;;">
</td><td style="text-align: center;;">
</td><td style="text-align: center;;">
</td><td style="text-align: center;;">
</td><td style="text-align: center;color: #0070C0;;">4.55</td><td style="text-align: center;color: #0070C0;;">205.725</td><td style="text-align: center;color: #0070C0;;">1.25</td><td style="text-align: center;color: #0070C0;;">CoalCharge 1.05</td><td style="text-align: center;color: #FF0000;;">5</td><td style="text-align: center;color: #FF0000;;">205.9</td><td style="text-align: center;color: #FF0000;;">0</td><td style="text-align: center;color: #FF0000;;">Stemming</td></tr><tr><td style="color: #161120;text-align: center;">14</td><td style="text-align: center;color: #00B050;;">C6</td><td style="text-align: center;color: #00B050;;">695512.94</td><td style="text-align: center;color: #00B050;;">7422220.57</td><td style="text-align: center;color: #00B050;;">24.97</td><td style="text-align: center;color: #00B050;;">24.97</td><td style="text-align: center;color: #00B050;;">0</td><td style="text-align: center;color: #00B050;;">229</td><td style="text-align: center;color: #00B050;;">147.7</td><td style="text-align: center;color: #953735;;">10</td><td style="text-align: center;color: #953735;;">452.45</td><td style="text-align: center;color: #953735;;">2.5</td><td style="text-align: center;color: #953735;;">CoalCharge 1.3</td><td style="text-align: center;;">
</td><td style="text-align: center;;">
</td><td style="text-align: center;;">
</td><td style="text-align: center;;">
</td><td style="text-align: center;color: #0070C0;;">5</td><td style="text-align: center;color: #0070C0;;">226.225</td><td style="text-align: center;color: #0070C0;;">1.25</td><td style="text-align: center;color: #0070C0;;">CoalCharge 1.05</td><td style="text-align: center;color: #FF0000;;">5</td><td style="text-align: center;color: #FF0000;;">205.9</td><td style="text-align: center;color: #FF0000;;">0</td><td style="text-align: center;color: #FF0000;;">Stemming</td></tr><tr><td style="color: #161120;text-align: center;">15</td><td style="text-align: center;color: #00B050;;">C7</td><td style="text-align: center;color: #00B050;;">695520.55</td><td style="text-align: center;color: #00B050;;">7422225.38</td><td style="text-align: center;color: #00B050;;">24.98</td><td style="text-align: center;color: #00B050;;">26.82</td><td style="text-align: center;color: #00B050;;">0</td><td style="text-align: center;color: #00B050;;">229</td><td style="text-align: center;color: #00B050;;">147.7</td><td style="text-align: center;color: #953735;;">10.9</td><td style="text-align: center;color: #953735;;">494.2</td><td style="text-align: center;color: #953735;;">2.5</td><td style="text-align: center;color: #953735;;">CoalCharge 1.3</td><td style="text-align: center;;">
</td><td style="text-align: center;;">
</td><td style="text-align: center;;">
</td><td style="text-align: center;;">
</td><td style="text-align: center;color: #0070C0;;">5.45</td><td style="text-align: center;color: #0070C0;;">247.1</td><td style="text-align: center;color: #0070C0;;">1.25</td><td style="text-align: center;color: #0070C0;;">CoalCharge 1.05</td><td style="text-align: center;color: #FF0000;;">5</td><td style="text-align: center;color: #FF0000;;">205.9</td><td style="text-align: center;color: #FF0000;;">0</td><td style="text-align: center;color: #FF0000;;">Stemming</td></tr><tr><td style="color: #161120;text-align: center;">16</td><td style="text-align: center;color: #00B050;;">C8</td><td style="text-align: center;color: #00B050;;">695528.16</td><td style="text-align: center;color: #00B050;;">7422230.18</td><td style="text-align: center;color: #00B050;;">24.98</td><td style="text-align: center;color: #00B050;;">26.98</td><td style="text-align: center;color: #00B050;;">0</td><td style="text-align: center;color: #00B050;;">229</td><td style="text-align: center;color: #00B050;;">147.7</td><td style="text-align: center;color: #953735;;">11</td><td style="text-align: center;color: #953735;;">497.9</td><td style="text-align: center;color: #953735;;">2.5</td><td style="text-align: center;color: #953735;;">CoalCharge 1.3</td><td style="text-align: center;;">
</td><td style="text-align: center;;">
</td><td style="text-align: center;;">
</td><td style="text-align: center;;">
</td><td style="text-align: center;color: #0070C0;;">5.5</td><td style="text-align: center;color: #0070C0;;">248.95</td><td style="text-align: center;color: #0070C0;;">1.25</td><td style="text-align: center;color: #0070C0;;">CoalCharge 1.05</td><td style="text-align: center;color: #FF0000;;">5</td><td style="text-align: center;color: #FF0000;;">205.9</td><td style="text-align: center;color: #FF0000;;">0</td><td style="text-align: center;color: #FF0000;;">Stemming</td></tr><tr><td style="color: #161120;text-align: center;">17</td><td style="text-align: center;color: #00B050;;">C9</td><td style="text-align: center;color: #00B050;;">695535.77</td><td style="text-align: center;color: #00B050;;">7422234.99</td><td style="text-align: center;color: #00B050;;">24.98</td><td style="text-align: center;color: #00B050;;">26.98</td><td style="text-align: center;color: #00B050;;">0</td><td style="text-align: center;color: #00B050;;">229</td><td style="text-align: center;color: #00B050;;">147.7</td><td style="text-align: center;color: #953735;;">11</td><td style="text-align: center;color: #953735;;">497.85</td><td style="text-align: center;color: #953735;;">2.5</td><td style="text-align: center;color: #953735;;">CoalCharge 1.3</td><td style="text-align: center;;">
</td><td style="text-align: center;;">
</td><td style="text-align: center;;">
</td><td style="text-align: center;;">
</td><td style="text-align: center;color: #0070C0;;">5.5</td><td style="text-align: center;color: #0070C0;;">248.925</td><td style="text-align: center;color: #0070C0;;">1.25</td><td style="text-align: center;color: #0070C0;;">CoalCharge 1.05</td><td style="text-align: center;color: #FF0000;;">5</td><td style="text-align: center;color: #FF0000;;">205.9</td><td style="text-align: center;color: #FF0000;;">0</td><td style="text-align: center;color: #FF0000;;">Stemming</td></tr><tr><td style="color: #161120;text-align: center;">18</td><td style="text-align: center;color: #00B050;;">C10</td><td style="text-align: center;color: #00B050;;">695543.37</td><td style="text-align: center;color: #00B050;;">7422239.8</td><td style="text-align: center;color: #00B050;;">24.97</td><td style="text-align: center;color: #00B050;;">26.98</td><td style="text-align: center;color: #00B050;;">0</td><td style="text-align: center;color: #00B050;;">229</td><td style="text-align: center;color: #00B050;;">147.7</td><td style="text-align: center;color: #953735;;">11</td><td style="text-align: center;color: #953735;;">497.8</td><td style="text-align: center;color: #953735;;">2.5</td><td style="text-align: center;color: #953735;;">CoalCharge 1.3</td><td style="text-align: center;;">
</td><td style="text-align: center;;">
</td><td style="text-align: center;;">
</td><td style="text-align: center;;">
</td><td style="text-align: center;color: #0070C0;;">5.5</td><td style="text-align: center;color: #0070C0;;">248.9</td><td style="text-align: center;color: #0070C0;;">1.25</td><td style="text-align: center;color: #0070C0;;">CoalCharge 1.05</td><td style="text-align: center;color: #FF0000;;">5</td><td style="text-align: center;color: #FF0000;;">205.9</td><td style="text-align: center;color: #FF0000;;">0</td><td style="text-align: center;color: #FF0000;;">Stemming</td></tr></tbody></table>
Sheet1​
 
Last edited:
Upvote 0
What does each row of the data you've posted represent?

A blasting configuration?

Are the fields in red the pattern?

Sorry for all the stupid questions, just trying to get some sort of understanding of the data.:)

<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2><TBODY><TR><TD style="TEXT-ALIGN: center; COLOR: #953735; FONT-WEIGHT: bold">Deck length 1</TD><TD style="TEXT-ALIGN: center; COLOR: #953735; FONT-WEIGHT: bold">Deck weight 1</TD><TD style="TEXT-ALIGN: center; COLOR: #953735; FONT-WEIGHT: bold">Charge to 1</TD><TD style="TEXT-ALIGN: center; COLOR: #953735; FONT-WEIGHT: bold">Deck contents</TD></TR></TBODY></TABLE>

Weird, don't know how that was posted, I did try to post them but it didn't seem to work.

Anyways, I was going to ask if they were some sort of 'group'.
 
Last edited:
Upvote 0
Should I import each blast into a seperate table, or should I import them all into the same table and somehow add a field that stores the pattern ID and use a combination of the two fields as the primary key?

If the latter, how do I fill out the pattern ID field?
Click to expand...

From a relational database standpoint, it sounds like you have two tables:
  • 1 Master Table with "Green" data that is common to all files. But you'll have to get the pattern ID in there.
  • 1 Child table with the repeating "Deck" information.

I might tackle this with an upload process - drop the csv into a temporary staging table. Push the common fields to the Master table and add the pattern ID as this is done. Push the deck fields to the child table and include the pattern ID and hole ID as this is done (to relate them back to the master record).

You'll end up with a composite primary key in the master table (the Pattern ID field and the Hole ID field will together be the primary key). You'll have the same two fields in the child table as a foreign key in every row that includes deck information related to this master record. In practice, often DB admins prefer to use an autonumber primary key as the primary key, and then create a unique index on the Pattern ID and Hole ID fields to guarantee they are unique.
 
Upvote 0
Yep to give you an understanding of the data:

Excel 2007<table rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6" cellpadding="2.5px"><colgroup><col style="background-color: #E0E0F0" width="25px"><col><col><col><col></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th>
</th><th>A</th><th>B</th><th>C</th><th>D</th></tr></thead><tbody><tr><td style="color: #161120;text-align: center;">1</td><td style="font-weight: bold;text-align: center;color: #953735;;">Deck length 1</td><td style="font-weight: bold;text-align: center;color: #953735;;">Deck weight 1</td><td style="font-weight: bold;text-align: center;color: #953735;;">Charge to 1</td><td style="font-weight: bold;text-align: center;color: #953735;;">Deck contents 1</td></tr><tr><td style="color: #161120;text-align: center;">2</td><td style="text-align: center;color: #953735;;">25.3</td><td style="text-align: center;color: #953735;;">1146.1</td><td style="text-align: center;color: #953735;;">10</td><td style="text-align: center;color: #953735;;">CoalCharge 1.1</td></tr></tbody></table>
Sheet1​




Deck length 1: This is representative of the length in meters of the 'deck' when loaded in the hole, irrespective of what substance the deck is comprimsed of.
Deck weight 1: This is the mass of the substance that comprises the deck in kg.
Charge to 1: This the length from the top of the hole to the top this particular deck.
Deck contents 1: This is the substance that comprises the deck. It can be a bulk explosive product (for instance CoalCharge 1.1), or air, water or stemming etc.

These fields are then repeated for all the other decks that will need to be loaded (theoretically this can be as many as they want), until the hole is stemmed off.
 
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Question
Relationships using multi-field compound keys setup & Possible Redundant Indexes setup
Replies
1
Views
564
Micron
M
D
  • Question
Importing Excel Spreadsheet into Access - decimal point precision
2
Replies
16
Views
3K
Joe4
Joe4
G
  • Question
VBA Save File Based On Filtered Change In Range
Replies
4
Views
473
GoHeels
G
T
  • Question
PowerBI - Linked sources - splicer not working - expanded rows
Replies
0
Views
222
Tashat
T
G
  • Question
Set a Unique ID for imported row of data
Replies
1
Views
411
James006
James006

Forum statistics

Threads
1,215,654
Messages
6,126,048
Members
449,282
Latest member
Glatortue

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top