Access - Structure for importing data

[Neutralizer]

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?

 

[Norie]

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.

 

[Neutralizer]

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​

 

[Norie]

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

 

[xenou]

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?

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.

 

[Neutralizer]

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.

 

[Neutralizer]

Excellent information xenou, thanks for that.