Some time ago, I had come across some interesting data about Scotch Whiskey. I soon, decided to parse it and display it in an android app. The app can be downloaded for free at the Android Market https://market.android.com/details?id=Scotch.App

This Scotch data can be downloaded here below.

http://www.bio.umontreal.ca/casgrain/en/labo/scotch.html

This file being parsed : scotch.xls

To get this Excel Data into my android java application: Using Microsoft Excel, I simply saved it as a *.csv, opened it using notepad, and copy and pasted it into a string variable (String scotchData).

For each row of different Scotch, parse the appropriate columns for their values.

I also added a tasty photograph taken by Kyle May.

[java]

//for each item in the array

//add logic to match the Excel file’s columns

//I populate a different output string for each category

String sColor = “Color : “;

for ( int i = 2; i < 16; i++)

{

if (indValues[i].equals(“1”))

{

switch(i)

{

case 2:

sColor += “wyne”;

break;

case 3:

sColor += “yellow”;

break;

case 4:

sColor += “v.pale”;

break;

case 5:

sColor += “pale”;

break;

case 6:

sColor += “p.gold”;

break;

case 7:

sColor += “gold”;

break;

case 8:

sColor += “o.gold”;

break;

case 9:

sColor += “f.gold”;

break;

case 10:

sColor += “bronze”;

break;

case 11:

sColor += “p.amber”;

break;

case 12:

sColor += “amber”;

break;

case 13:

sColor += “f.amber”;

break;

case 14:

sColor += “red”;

break;

case 15:

sColor += “sherry”;

break;

}

}

}

String sNose = “Nose : “;

for ( int i = 16; i < 28; i++)

{

if (indValues[i].equals(“1″))

{

switch(i)

{

case 16:

sNose += ” AROMA “;

break;

case 17:

sNose += ” PEAT “;

break;

case 18:

sNose += ” SWEET “;

break;

case 19:

sNose += ” LIGHT “;

break;

case 20:

sNose += ” FRESH “;

break;

case 21:

sNose += ” DRY “;

break;

case 22:

sNose += ” FRUIT “;

break;

case 23:

sNose += ” GRASS “;

break;

case 24:

sNose += ” SEA “;

break;

case 25:

sNose += ” SHERRY “;

break;

case 26:

sNose += ” SPICY “;

break;

case 27:

sNose += ” RICH “;

break;

}

}

}

String sBody = “Body :”;

for ( int i = 28; i < 36; i++)

{

if (indValues[i].equals(“1″))

{

switch(i)

{

case 28:

sBody += ” soft “;

break;

case 29:

sBody += ” med “;

break;

case 30:

sBody += ” full “;

break;

case 31:

sBody += ” round “;

break;

case 32:

sBody += ” smooth “;

break;

case 33:

sBody += ” light “;

break;

case 34:

sBody += ” firm “;

break;

case 35:

sBody += ” oily “;

break;

}

}

}

String sPal= “Palate :”;

for ( int i = 36; i < 51; i++)

{

if (indValues[i].equals(“1″))

{

switch(i)

{

case 36:

sPal += ” full “;

break;

case 37:

sPal += ” dry “;

break;

case 38:

sPal += ” sherry “;

break;

case 39:

sPal += ” big “;

break;

case 40:

sPal += ” light “;

break;

case 41:

sPal += ” smooth “;

break;

case 42:

sPal += ” clean “;

break;

case 43:

sPal += ” fruit “;

break;

case 44:

sPal += ” grass “;

break;

case 45:

sPal += ” smoke “;

break;

case 46:

sPal += ” sweet “;

break;

case 47:

sPal += ” spice “;

break;

case 48:

sPal += ” oil “;

break;

case 49:

sPal += ” salt “;

break;

case 50:

sPal += ” arome “;

break;

}

}

}

String sFin = “Finish :”;

for ( int i = 51; i < 70; i++)

{

if (indValues[i].equals(“1″))

{

switch(i)

{

case 51:

sFin += ” full “;

break;

case 52:

sFin += ” dry “;

break;

case 53:

sFin += ” warm “;

break;

case 54:

sFin += ” big “;

break;

case 55:

sFin += ” light “;

break;

case 56:

sFin += ” smooth “;

break;

case 57:

sFin += ” clean “;

break;

case 58:

sFin += ” fruit “;

break;

case 59:

sFin += ” grass “;

break;

case 60:

sFin += ” smoke “;

break;

case 61:

sFin += ” sweet “;

break;

case 62:

sFin += ” spice “;

break;

case 63:

sFin += ” oil “;

break;

case 64:

sFin += ” salt “;

break;

case 65:

sFin += ” arome “;

break;

case 66:

sFin += ” ling “;

break;

case 67:

sFin += ” long “;

break;

case 68:

sFin += ” very “;

break;

case 69:

sFin += ” quick “;

break;

}

}

}

String sScore = “Score : ” + indValues[72];

String sPer = “% : ” + indValues[73];

String sReg = “Region : ” + indValues[74];

String sDist= “District : ” + indValues[75];

//I clump all my output strings together here

alertDialog.setMessage( sColor+”

”+sNose+”

”+sBody+”

”+sPal+”

”+

sFin+”

”+sScore+”

”+sPer+”%

”+sReg+”

”+sDist );

//close button

alertDialog.setButton(“Close”, new DialogInterface.OnClickListener() {

public void onClick(DialogInterface dialog, int which) {

} });

alertDialog.show();

}

}

});

}

//event for initial Image click

private OnClickListener iniPicClickListener = new OnClickListener()

{

public void onClick(View v)

{

//hide greeting hide image and show scotchList

greetTxt.setVisibility(8);

iniPic.setVisibility(8);

titleList.setVisibility(1);

}

};

}

[/java]

main.xml

[xml]



android:orientation=”vertical”

android:layout_width=”fill_parent”

android:layout_height=”fill_parent”>

android:id=”@+id/greetingText”

android:layout_width=”fill_parent”

android:layout_height=”wrap_content”

android:text=”Welcome To Scotch App”

android:gravity=”center”

/>

android:layout_height=”wrap_content”

android:layout_width=”wrap_content”

android:src=”@drawable/kylemayscotchphoto”

android:layout_gravity=”center”

android:background=”#FFF”

>

android:id=”@+id/listTitle”

android:layout_width=”fill_parent”>

[/xml]

Full Code:

[java]

package Scotch.App;

import java.util.ArrayList;

import java.util.Hashtable;

import android.app.Activity;

import android.app.AlertDialog;

import android.content.DialogInterface;

import android.content.Intent;

import android.net.Uri;

import android.os.Bundle;

import android.view.View;

import android.view.View.OnClickListener;

import android.widget.AdapterView;

import android.widget.ArrayAdapter;

import android.widget.ImageButton;

import android.widget.ListView;

import android.widget.TextView;

import android.widget.Toast;

import android.widget.AdapterView.OnItemClickListener;

public class Drink extends Activity

{

//Raw Scotch Data

public static String scotchData = “Aberfeldy,Aberfeldy,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0,1,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,1,0,0,1,1,0,0,0,0,0,1,0,0,0,1,0,0,0,0,0,0,0,-9,2,69,40,HIGH,MIDLAND,0,1,0,0,0,0,0,0,0

”

+ ” Aberlour,Aberlour,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,1,0,0,0,0,0,0,0,0,1,1,1,1,1,1,0,0,0,1,0,1,0,0,0,0,1,0,0,1,1,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,1,0,0,0,12,4,83,43,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Ardberg,Ardberg,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,0,0,0,1,0,0,1,0,0,0,0,1,1,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,10,4,85,40,ISLAY,SOUTH,1,0,0,0,0,0,0,0,0

”

+ ” Ardmore,Ardmore,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1,0,1,0,0,0,0,1,0,0,0,0,0,0,0,0,1,0,0,0,0,1,0,1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,18,2,66,46,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Auchentoshan,Auchentosh,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,1,0,0,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,10,5,85,40,LOW,WEST,0,0,0,0,0,0,1,0,0

”

+ ” Aultmore,Aultmore,0,0,1,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,1,0,0,1,0,0,0,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,12,3,75,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Balblair,Balblair,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,1,0,0,1,1,0,0,0,0,1,0,0,0,0,0,1,0,0,0,0,0,0,0,1,0,0,0,10,3,76,40,HIGH,NORTH,0,0,0,0,0,1,0,0,0

”

+ ” Balmenach,Balmenach,0,0,0,0,1,0,0,0,0,0,0,0,0,0,1,1,1,0,0,0,1,1,0,0,0,0,1,1,0,0,1,1,0,0,0,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,-9,3,69,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Balvenie,Balvenie,0,0,0,0,0,0,0,0,0,0,1,0,0,0,1,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,1,0,0,0,-9,4,85,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Banff,Banff,0,0,0,0,0,0,0,1,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,1,1,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1,0,0,0,0,0,0,0,-9,2,66,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Ben Nevis,Ben Nevis,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,-9,1,55,40,HIGH,WEST,0,0,0,0,1,0,0,0,0

”

+ ” Benriach,Benriach,0,0,0,0,0,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,1,0,0,0,1,0,0,0,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,1,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,-9,3,69,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Benrinnes,Benrinnes,0,0,0,0,0,0,0,0,0,0,1,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,1,0,1,1,0,1,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,-9,3,78,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Benromach,Benromach,0,0,0,0,0,0,0,0,0,0,1,0,0,0,1,1,0,0,0,1,0,1,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,1,1,0,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,1,0,1,0,0,0,0,0,0,0,0,0,-9,3,75,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Bladnoch,Bladnoch,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,8,4,85,40,LOW ,BORDERS,0,0,0,0,0,0,1,0,0

”

+ ” Blair Athol,Blair Atho,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,1,0,0,1,0,0,0,1,0,0,0,1,0,0,1,0,0,0,0,0,1,1,0,0,1,0,0,0,0,0,1,0,0,0,0,0,1,0,0,0,0,0,0,0,8,3,75,40,HIGH,MIDLAND,0,1,0,0,0,0,0,0,0

”

+ ” Bowmore,Bowmore,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,1,0,0,0,1,0,1,1,0,0,0,0,1,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1,10,4,81,40,ISLAY,LOCH,1,0,0,0,0,0,0,0,0

”

+ ” Brackla,Brackla,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,1,0,1,0,0,1,0,0,0,1,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,-9,3,77,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Bruichladdich,Bruichladd,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,0,0,1,0,0,0,0,1,0,0,1,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10,3,76,40,ISLAY,LOCH,1,0,0,0,0,0,0,0,0

”

+ ” Bunnahabhain,Bunnahabha,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,1,0,0,0,0,1,0,0,0,1,1,0,0,0,0,0,0,0,1,1,0,0,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,12,3,77,40,ISLAY,NORTH,1,0,0,0,0,0,0,0,0

”

+ ” Caol Ila,Caol Ila,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1,0,1,0,0,0,0,0,0,0,0,1,1,1,0,0,0,0,0,0,0,0,0,1,0,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,12,4,77,40,ISLAY,NORTH,1,0,0,0,0,0,0,0,0

”

+ ” Caperdonich,Caperdonic,0,0,0,0,0,0,0,1,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,1,0,0,0,0,0,0,0,0,0,1,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,1,0,0,0,-9,3,73,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Cardhu,Cardhu,0,0,0,1,0,0,0,0,0,0,0,0,0,0,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,1,0,0,0,0,0,1,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,1,0,0,1,0,0,0,12,3,72,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Clynelish,Clynelish,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,1,0,0,0,0,1,1,0,0,0,0,0,0,0,1,0,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,1,0,0,0,12,4,81,40,HIGH,NORTH,0,0,0,0,0,1,0,0,0

”

+ ” Coleburn,Coleburn,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,0,0,0,0,0,0,0,0,0,1,0,1,0,1,0,0,0,0,0,1,0,1,1,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,-9,2,67,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Convalmore,Convalmore,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,1,0,0,0,1,0,0,0,0,1,0,1,0,0,0,1,0,0,0,0,0,0,0,1,0,1,0,0,0,0,0,0,0,-9,2,68,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Cragganmore,Cragganmor,0,0,0,0,0,1,0,0,0,0,0,0,0,0,1,0,1,0,0,0,0,1,0,0,0,1,0,1,0,0,1,1,1,0,0,0,0,0,0,0,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,12,4,90,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Craigellachie,Craigellac,0,0,0,0,0,0,0,1,0,0,0,0,0,0,1,1,1,0,0,1,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-9,3,72,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Dailuaine,Dailuaine,0,0,0,0,0,1,0,0,0,0,0,0,0,0,1,0,1,0,0,1,0,0,0,1,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,1,0,1,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,-9,3,74,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Dallas Dhu,Dallas Dhu,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,1,1,0,0,0,0,1,0,0,0,1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,1,0,0,0,1,0,0,1,0,0,0,0,0,0,0,1,0,0,-9,4,85,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Dalmore,Dalmore,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1,0,0,0,1,0,0,1,0,0,1,1,1,0,0,0,0,0,1,1,0,1,0,1,0,1,0,1,0,1,0,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,1,0,0,12,4,79,40,HIGH,NORTH,0,0,0,0,0,1,0,0,0

”

+ ” Dalwhinnie,Dalwhinnie,0,0,0,0,0,1,0,0,0,0,0,0,0,0,1,1,0,0,0,1,0,0,1,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,1,0,1,1,1,1,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,15,3,76,43,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Deanston,Deanston,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,1,0,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,1,0,0,1,0,0,0,0,0,1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-9,2,69,40,HIGH,MIDLAND,0,1,0,0,0,0,0,0,0

”

+ “Dufftown,Dufftown,0,0,0,0,0,0,0,1,0,0,0,0,0,0,1,1,1,0,0,1,0,0,0,0,0,1,0,1,0,1,0,1,1,1,0,1,0,0,0,0,0,0,0,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,1,0,0,0,10,3,71,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Edradour,Edradour,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,1,1,0,0,0,1,0,0,1,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,1,0,0,0,1,1,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10,4,81,40,HIGH,MIDLAND,0,1,0,0,0,0,0,0,0

”

+ “Fettercairn,Fettercair,0,0,0,1,0,0,0,0,0,0,0,0,0,0,1,0,1,1,0,0,1,0,0,0,0,0,0,0,0,0,1,1,0,0,0,1,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,1,0,1,0,0,0,0,0,0,0,0,0,0,1,0,0,0,8,3,71,40,HIGH,EAST,0,0,0,1,0,0,0,0,0

”

+ ” Glen Albyn,Glen Alby,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1,0,1,0,1,0,0,0,1,0,0,0,1,0,1,0,1,0,0,0,0,0,0,1,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,-9,2,67,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Glenallachie,Glenallach,0,0,1,0,0,0,0,0,0,0,0,0,0,0,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,0,0,0,0,0,1,0,0,12,3,76,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Glenburgie,Glenburgie,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,0,0,0,0,0,0,0,0,1,1,0,1,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,-9,2,68,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Glencadam,Glencadam,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,0,0,0,0,1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,1,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-9,2,68,40,HIGH,EAST,0,0,0,1,0,0,0,0,0

”

+ ” Glen Deveron,Glen Dever,0,0,0,0,0,1,0,0,0,0,0,0,0,0,1,0,1,0,1,0,0,0,0,1,0,0,0,1,0,0,1,1,0,0,1,0,0,0,0,0,1,0,0,0,1,0,0,0,0,0,1,1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,12,3,75,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Glendronach,Glendronac,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,1,0,0,1,0,0,0,1,0,0,0,1,1,0,1,0,0,1,0,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,1,1,1,0,0,0,0,0,0,0,0,0,0,12,3,75,43,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Glendullan,Glendullan,0,0,0,0,0,0,0,0,0,0,1,0,0,0,1,0,1,0,0,0,1,0,0,1,0,0,0,1,1,0,1,0,1,0,0,1,0,1,0,0,0,1,0,0,1,0,0,0,1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,12,3,75,43,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Glen Elgin,Glen Elgin,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,0,0,0,0,1,0,0,0,0,0,1,1,0,0,0,1,0,0,0,0,0,0,0,0,1,1,0,0,1,0,0,0,0,0,0,0,0,1,0,1,0,0,1,0,0,0,0,0,0,0,0,0,12,3,75,43,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Glenesk,Glenesk,0,0,0,0,0,1,0,0,0,0,0,0,0,0,1,0,1,0,0,1,0,0,0,0,0,0,1,1,0,0,1,1,0,0,0,1,0,0,0,1,0,0,0,0,1,0,0,0,0,0,1,0,0,0,0,1,0,0,0,1,0,0,0,0,0,0,0,0,12,3,66,40,HIGH,EAST,0,0,0,1,0,0,0,0,0

”

+ ” Glenfarclas,Glenfarcla,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,1,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,1,0,0,10,4,86,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Glenfiddich,Glenfiddic,1,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,1,1,0,1,0,0,0,0,0,0,0,0,0,1,1,1,0,0,1,0,0,0,0,0,1,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,-9,3,75,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Glen Garioch,Glen Gario,0,0,0,0,0,0,0,1,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1,0,0,0,0,0,0,0,0,1,0,1,1,0,0,0,0,0,1,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,1,10,4,77,43,HIGH,EAST,0,0,0,1,0,0,0,0,0

”

+ ” Glenglassaugh,Glenglassa,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,1,0,0,0,0,0,0,0,0,1,1,1,0,0,0,0,0,0,0,0,0,1,0,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-9,3,76,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Glengoyne,Glengoyne,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,0,0,1,0,1,0,0,1,0,0,0,1,0,1,1,1,0,0,0,0,0,0,0,0,1,0,0,0,1,0,0,0,0,0,1,0,0,0,0,1,0,0,0,1,0,0,0,0,0,0,0,0,10,3,74,40,HIGH,WEST,0,0,0,0,1,0,0,0,0

”

+ ” Glen Grant,Glen Grant,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,1,0,0,1,0,0,0,0,0,0,0,1,0,0,0,1,0,0,0,1,0,0,1,0,0,1,0,0,1,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,10,4,76,43,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Glen Keith,Glen Keith,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,1,0,1,0,1,0,0,0,0,0,1,1,0,0,0,0,0,0,1,1,0,0,0,0,0,0,1,1,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,-9,2,64,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Glenkinchie,Glenkinchi,0,0,0,0,0,1,0,0,0,0,0,0,0,0,1,1,1,0,0,0,0,1,0,0,0,0,0,1,0,0,0,1,0,1,1,0,0,0,0,1,1,0,1,0,1,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,10,4,76,43,LOW,EAST,0,0,0,0,0,0,1,0,0

”

+ ” Glenlivet,Glenlivet,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,0,0,0,1,0,0,1,1,1,0,0,1,0,0,0,0,0,1,0,0,1,1,0,0,1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,12,5,85,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Glenlochy,Glenlochy,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,0,1,0,1,0,0,0,0,0,0,0,1,0,0,0,1,1,1,0,1,0,0,1,0,0,0,0,1,0,0,1,0,0,0,0,0,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,1,-9,2,70,40,HIGH,WEST,0,0,0,0,1,0,0,0,0

”

+ ” Glenlossie,Glenlossie,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,1,0,1,1,1,0,0,1,0,0,0,1,0,1,1,1,0,0,0,1,0,0,0,0,1,1,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,1,0,1,0,0,-9,3,76,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Glen Mhor,Glen Mhor,0,0,0,0,0,1,0,0,0,0,0,0,0,0,1,0,1,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1,0,0,0,1,0,0,0,0,0,1,0,1,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,1,0,0,0,0,8,2,64,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Glenmorangie,Glenmorang,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,1,0,1,0,0,1,1,0,1,0,0,1,0,0,0,1,0,1,0,0,0,0,0,0,0,0,1,0,1,1,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,10,4,80,40,HIGH,NORTH,0,0,0,0,0,1,0,0,0

”

+ ” Glen Moray,Glen Moray,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,1,0,0,0,1,0,0,0,0,1,1,1,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,12,3,75,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Glen Ordie,Glen Ordie,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,1,0,0,0,0,0,1,0,1,1,0,1,0,0,0,1,1,0,0,0,0,1,0,0,0,1,0,0,0,0,0,1,0,0,0,1,0,0,0,0,0,1,0,0,0,0,0,0,0,12,3,75,40,HIGH,NORTH,0,0,0,0,0,1,0,0,0

”

+ ” Glenrothes,Glenrothes,0,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,1,0,0,0,0,1,0,1,1,0,1,0,0,0,1,1,0,0,0,1,0,1,0,0,1,0,0,0,0,0,1,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,8,4,80,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Glen Scotia,Glen Scoti,0,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,1,0,0,0,1,0,0,0,0,1,0,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,8,4,85,40,LOW,CAMPBEL,0,0,0,0,0,0,0,1,0

”

+ ” Glen Spey,Glen Spey,0,0,0,0,0,1,0,0,0,0,0,0,0,0,1,0,0,1,0,0,0,0,0,0,0,0,0,1,0,0,0,1,0,0,0,0,0,0,0,0,0,1,1,1,0,0,0,0,1,0,1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,8,3,73,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Glentauchers,Glentauche,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,1,1,0,1,0,1,0,0,0,0,0,1,1,0,0,0,1,0,1,1,0,0,0,0,0,1,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,17,2,71,46,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Glenturret,Glenturret,1,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,1,0,0,0,0,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,1,0,0,10,4,77,57.1,HIGH,MIDLAND,0,1,0,0,0,0,0,0,0

”

+ ” Glenugie,Glenugie,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,0,0,0,0,1,0,1,1,0,0,1,1,0,0,1,0,0,1,0,0,1,1,0,0,0,0,0,0,1,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-9,2,70,54.8,HIGH,EAST,0,0,0,1,0,0,0,0,0

”

+ ” Glenury Royal,Glenury Ro,0,0,0,0,0,0,0,0,1,0,0,0,0,0,1,1,0,0,0,1,0,0,0,0,0,0,0,1,0,0,0,1,1,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,1,0,1,1,0,0,0,0,0,0,1,0,12,3,76,40,HIGH,EAST,0,0,0,1,0,0,0,0,0

”

+ ” Highland Park,Highland P,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1,1,0,0,0,1,0,0,1,0,0,0,1,0,0,1,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,12,5,90,40,HIGH,ORKNEY,0,0,0,0,0,0,0,0,1

”

+ ” Imperial,Imperial,0,0,0,0,0,0,0,1,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,1,0,0,1,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,1,1,1,0,0,0,0,0,0,0,0,1,0,0,0,1,0,0,0,0,0,0,0,0,0,-9,3,76,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Inchgower,Inchgower,0,0,0,0,0,1,0,0,0,0,0,0,0,0,1,1,1,0,0,1,0,0,1,0,0,1,0,1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,1,0,0,12,3,75,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Inchmurrin,Inchmurrin,0,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,1,0,1,0,0,0,0,0,0,0,1,0,1,0,1,0,1,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,12,2,65,40,HIGH,WEST,0,0,0,0,1,0,0,0,0

”

+ ” Inverleven,Inverleven,0,0,0,0,0,1,0,0,0,0,0,0,0,0,1,1,0,0,0,1,1,1,0,0,0,0,0,0,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,17,2,67,46,LOW,WEST,0,0,0,0,0,0,1,0,0

”

+ ” Jura,Jura,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,1,1,1,0,1,0,0,0,1,0,0,1,0,0,0,0,1,0,0,0,1,0,0,0,0,0,0,0,0,1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,1,0,0,1,0,0,0,0,0,10,3,71,40,HIGH,JURA,0,0,0,0,0,0,0,0,1

”

+ ” Kinclaith,Kinclaith,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,1,0,0,0,0,1,0,0,0,0,0,0,1,0,0,1,0,0,0,1,0,0,0,0,0,0,0,0,1,0,1,0,0,0,0,0,0,0,0,0,0,0,-9,2,69,40,LOW,WEST,0,0,0,0,0,0,1,0,0

”

+ ” Knockando,Knockando,0,0,0,0,1,0,0,0,0,0,0,0,0,0,1,1,0,0,0,1,0,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,1,0,1,1,0,1,1,0,1,0,0,0,0,0,1,1,1,0,1,1,1,0,0,0,0,0,0,0,0,-9,3,76,43,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Knockdhu,Knockdhu,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,1,1,0,0,1,1,0,0,0,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,1,0,0,1,0,0,0,0,0,1,0,0,0,0,0,0,0,1,0,0,0,0,1,0,1,0,0,-9,3,73,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Ladyburn,Ladyburn,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,1,0,0,0,0,0,1,0,0,0,0,1,0,0,0,1,0,0,1,0,0,0,0,0,1,0,0,0,1,0,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,20,2,57,46,LOW,WEST,0,0,0,0,0,0,1,0,0

”

+ ” Lagavulin,Lagavulin,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,1,0,0,0,1,0,0,1,1,0,0,0,0,1,1,0,0,0,1,0,1,0,0,0,0,0,0,0,1,0,0,0,1,0,0,1,0,1,0,0,0,0,0,1,0,0,0,1,0,0,0,0,0,12,5,89,43,ISLAY,SOUTH,1,0,0,0,0,0,0,0,0

”

+ ” Laphroaig,Laphroaig,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,0,0,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10,4,86,43,ISLAY,SOUTH,1,0,0,0,0,0,0,0,0

”

+ ” Linkwood,Linkwood,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,1,0,1,0,1,0,1,0,0,0,0,0,1,0,0,1,0,0,0,0,1,1,0,0,0,0,0,1,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,12,4,83,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Littlemill,Littlemill,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,1,1,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,1,0,0,0,1,0,1,0,0,0,0,0,0,0,0,0,0,0,8,4,83,43,LOW,NORTHWEST,0,0,0,0,0,0,1,0,0

”

+ ” Lochnagar,Lochnagar,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,1,1,0,1,0,0,0,0,0,0,0,1,0,0,1,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,12,4,80,43,HIGH,EAST,0,0,0,1,0,0,0,0,0

”

+ ” Lochside,Lochside,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,1,0,0,1,0,1,1,1,0,0,1,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,-9,3,71,40,HIGH,EAST,0,0,0,1,0,0,0,0,0

”

+ ” Longmorn,Longmorn,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,1,0,0,0,0,1,0,1,0,0,0,0,0,0,0,1,1,1,0,1,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,12,4,85,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Macallan,Macallan,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,1,0,0,0,1,0,0,1,0,1,0,0,1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,1,0,0,0,0,0,0,0,10,5,87,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Millburn,Millburn,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,0,0,0,0,0,0,0,0,1,0,1,0,0,1,0,1,0,0,0,0,0,1,0,0,0,0,0,0,1,1,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,-9,3,76,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Miltonduff,Miltonduff,0,0,0,0,1,0,0,0,0,0,0,0,0,0,1,1,0,0,0,1,0,1,0,0,0,0,0,1,0,0,1,0,1,0,0,0,0,0,0,0,1,0,0,0,1,0,0,0,1,0,1,0,0,0,0,0,0,0,0,1,0,0,0,1,0,0,0,0,12,3,76,43,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Mortlach,Mortlach,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,1,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,1,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,12,4,81,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” North Port,North Port,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,0,0,0,1,0,0,0,1,0,0,0,1,0,0,0,1,0,0,1,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-9,2,64,40,HIGH,EAST,0,0,0,1,0,0,0,0,0

”

+ ” Oban,Oban,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1,1,0,1,0,0,0,1,0,0,0,0,1,1,0,1,0,1,0,0,1,0,0,0,1,0,1,0,1,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,12,4,76,43,HIGH,WEST,0,0,0,1,0,0,0,0,0

”

+ ” Port Ellen,Port Ellen,0,0,0,0,0,0,0,0,0,0,1,0,0,0,1,1,1,0,0,0,0,1,1,0,1,0,0,1,0,0,1,0,0,0,0,1,0,0,0,0,0,0,0,0,1,1,0,0,1,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,0,1,0,0,-9,4,79,40,ISLAY,SOUTH,0,0,0,0,1,0,0,0,0

”

+ ” Pulteney,Pulteney,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,0,0,1,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,1,0,0,0,0,1,1,0,1,0,0,0,1,0,0,0,0,0,0,0,0,0,0,1,0,0,1,0,0,8,3,77,40,HIGH,NORTH,0,0,0,0,0,1,0,0,0

”

+ ” Rosebank,Rosebank,0,0,0,0,0,0,0,0,0,0,1,0,0,0,1,0,0,0,0,1,0,1,0,1,0,0,0,0,0,0,1,1,0,0,0,1,0,0,0,0,0,1,1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,8,4,76,40,LOW,CENTRAL,0,0,0,0,0,0,1,0,0

”

+ ” Saint Magdalene,Saint Magd,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,1,0,0,0,1,0,0,0,1,0,0,0,1,0,0,1,1,0,0,0,0,0,0,0,0,0,0,1,1,1,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,18,2,67,40,LOW,CENTRAL,0,0,0,0,0,0,1,0,0

”

+ ” Scapa,Scapa,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,0,1,1,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,1,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,8,3,76,40,HIGH,ORKNEY,0,0,0,0,0,0,0,0,1

”

+ ” Singleton,Singleton,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,1,0,0,1,0,0,0,0,0,1,0,0,0,0,1,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,-9,4,79,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Speyburn,Speyburn,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,1,1,0,0,1,0,0,0,0,0,0,1,0,0,0,0,1,0,0,0,0,0,1,0,0,1,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1,0,0,0,0,0,0,0,1,-9,3,71,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Springbank,Springbank,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,1,0,1,0,0,0,1,0,0,1,0,1,0,1,1,1,0,0,0,0,0,0,1,0,0,0,0,0,1,0,0,1,0,0,0,1,0,0,0,0,0,0,1,1,0,0,1,0,0,0,1,0,15,5,88,46,LOW,CAMPBEL,0,0,0,0,0,0,0,1,0

”

+ ” Springbank-Longrow,Longrow,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,1,1,0,0,0,0,1,0,0,0,0,0,1,0,1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,1,0,1,0,0,0,14,5,90,46,LOW,CAMPBEL,0,0,0,0,0,0,0,1,0

”

+ ” Strathisla,Strathisla,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,1,0,0,0,1,0,1,0,1,0,0,0,0,1,0,0,1,1,0,0,0,0,0,1,0,1,0,0,0,0,0,1,0,1,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,8,3,79,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Talisker,Talisker,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,1,1,0,0,0,0,0,1,0,0,1,0,0,1,0,0,0,0,1,0,0,0,1,0,0,0,0,0,1,1,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,0,0,0,0,1,0,0,10,4,90,45.8,HIGH,SKYE,0,0,0,0,0,0,0,0,1

”

+ ” Tamdhu,Tamdhu,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,1,1,1,0,0,0,0,0,1,0,0,0,1,0,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10,3,75,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Tamnavulin,Tamnavulin,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,10,3,76,43,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Teaninich,Teaninich,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1,1,0,0,0,1,0,0,0,0,0,0,1,1,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,1,1,1,0,0,0,0,1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,-9,3,71,40,HIGH,NORTH,0,0,0,0,0,1,0,0,0

”

+ ” Tobermory,Tobermory,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,1,1,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,1,0,0,0,0,0,1,0,1,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,1,0,0,0,1,0,0,0,0,-9,2,67,40,HIGH,MULL,0,0,0,0,0,0,0,0,1

”

+ ” Tomatin,Tomatin,0,0,0,0,0,0,0,1,0,0,0,0,0,0,1,1,1,0,1,1,0,0,0,0,0,0,1,1,0,0,1,0,0,0,0,1,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,10,3,75,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Tomintoul,Tomintoul,0,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,1,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,12,3,76,40,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Tormore,Tormore,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,0,0,0,1,1,0,0,0,0,0,0,1,1,0,1,0,0,0,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,1,0,10,3,76,43,HIGH,SPEY,0,0,1,0,0,0,0,0,0

”

+ ” Tullibardine,Tullibardi,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,1,0,0,1,0,1,0,1,0,0,0,0,0,1,1,1,0,1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,1,0,0,0,0,10,3,76,40,HIGH,MIDLAND,0,1,0,0,0,0,0,0,0

”;

//Globalize controls

ImageButton iniPic;

TextView greetTxt;

ListView titleList;

//global srraylist for title string or “name” title of each list element

public ArrayList<String> sTitle = new ArrayList<String>();

//hash table Key: index Value: data row

public Hashtable<Integer,String> dataHash = new Hashtable();

/** Called when the activity is first created. */

@Override

public void onCreate(Bundle savedInstanceState)

{

super.onCreate(savedInstanceState);

setContentView(R.layout.main);

//Greetings TextView

greetTxt = (TextView) findViewById(R.id.greetingText);

//initial Picture by Kyle May Button

iniPic = (ImageButton) findViewById(R.id.iniPic);

//Image onClickListener set

iniPic.setOnClickListener(iniPicClickListener);

//break up the string by to line breaks (“

”)

String [] row = scotchData.split(“\

”);

//for each row element

for ( int i =0; i < row.length; i++)

{

//break up line into array by commas

String [] element = row[i].split(“,”);

//add first element of each row to sTitle arrayList

sTitle.add(element[0].trim());

//increment the key and add the row as

dataHash.put(i, row[i]);

}

//shamelessly promote yourself

sTitle.add(“www.mantascode.com”);

//get TitleList

titleList = (ListView) findViewById(R.id.listTitle);

//set titleList to invisible/gone

titleList.setVisibility(8);

//populate titleList with sTitle ArrayList

titleList.setAdapter(new ArrayAdapter<String>(this,

android.R.layout.simple_list_item_1, sTitle));

//onItemClickListener for titleList

titleList.setOnItemClickListener(new OnItemClickListener()

{

public void onItemClick(AdapterView<?> parent, View view,int position, long id)

{

//if the item that was clicked was my hardcoded promo

if( position == 109)

{

Toast.makeText(getApplicationContext(),

“Documentation for Scotch App” ,Toast.LENGTH_LONG).show();

Intent i = new Intent(Intent.ACTION_VIEW);

i.setData(Uri.parse(“http://www.mantascode.com”));

startActivity(i);

}

else//if position is in hashtable parse the Value of the HashTable

{

//Alert dialog window

AlertDialog alertDialog = new AlertDialog.Builder(Drink.this).create();

//set title to name of Scotch

alertDialog.setTitle(sTitle.get(position));

//split up the Hash set into an array

String [] indValues = dataHash.get(position).split(“,”);

//for each item in the array

//add logic to match the Excel file’s columns

//I populate a different output string for each category

String sColor = “Color : “;

for ( int i = 2; i < 16; i++)

{

if (indValues[i].equals(“1”))

{

switch(i)

{

case 2:

sColor += “wyne”;

break;

case 3:

sColor += “yellow”;

break;

case 4:

sColor += “v.pale”;

break;

case 5:

sColor += “pale”;

break;

case 6:

sColor += “p.gold”;

break;

case 7:

sColor += “gold”;

break;

case 8:

sColor += “o.gold”;

break;

case 9:

sColor += “f.gold”;

break;

case 10:

sColor += “bronze”;

break;

case 11:

sColor += “p.amber”;

break;

case 12:

sColor += “amber”;

break;

case 13:

sColor += “f.amber”;

break;

case 14:

sColor += “red”;

break;

case 15:

sColor += “sherry”;

break;

}

}

}

String sNose = “Nose : “;

for ( int i = 16; i < 28; i++)

{

if (indValues[i].equals(“1″))

{

switch(i)

{

case 16:

sNose += ” AROMA “;

break;

case 17:

sNose += ” PEAT “;

break;

case 18:

sNose += ” SWEET “;

break;

case 19:

sNose += ” LIGHT “;

break;

case 20:

sNose += ” FRESH “;

break;

case 21:

sNose += ” DRY “;

break;

case 22:

sNose += ” FRUIT “;

break;

case 23:

sNose += ” GRASS “;

break;

case 24:

sNose += ” SEA “;

break;

case 25:

sNose += ” SHERRY “;

break;

case 26:

sNose += ” SPICY “;

break;

case 27:

sNose += ” RICH “;

break;

}

}

}

String sBody = “Body :”;

for ( int i = 28; i < 36; i++)

{

if (indValues[i].equals(“1″))

{

switch(i)

{

case 28:

sBody += ” soft “;

break;

case 29:

sBody += ” med “;

break;

case 30:

sBody += ” full “;

break;

case 31:

sBody += ” round “;

break;

case 32:

sBody += ” smooth “;

break;

case 33:

sBody += ” light “;

break;

case 34:

sBody += ” firm “;

break;

case 35:

sBody += ” oily “;

break;

}

}

}

String sPal= “Palate :”;

for ( int i = 36; i < 51; i++)

{

if (indValues[i].equals(“1″))

{

switch(i)

{

case 36:

sPal += ” full “;

break;

case 37:

sPal += ” dry “;

break;

case 38:

sPal += ” sherry “;

break;

case 39:

sPal += ” big “;

break;

case 40:

sPal += ” light “;

break;

case 41:

sPal += ” smooth “;

break;

case 42:

sPal += ” clean “;

break;

case 43:

sPal += ” fruit “;

break;

case 44:

sPal += ” grass “;

break;

case 45:

sPal += ” smoke “;

break;

case 46:

sPal += ” sweet “;

break;

case 47:

sPal += ” spice “;

break;

case 48:

sPal += ” oil “;

break;

case 49:

sPal += ” salt “;

break;

case 50:

sPal += ” arome “;

break;

}

}

}

String sFin = “Finish :”;

for ( int i = 51; i < 70; i++)

{

if (indValues[i].equals(“1″))

{

switch(i)

{

case 51:

sFin += ” full “;

break;

case 52:

sFin += ” dry “;

break;

case 53:

sFin += ” warm “;

break;

case 54:

sFin += ” big “;

break;

case 55:

sFin += ” light “;

break;

case 56:

sFin += ” smooth “;

break;

case 57:

sFin += ” clean “;

break;

case 58:

sFin += ” fruit “;

break;

case 59:

sFin += ” grass “;

break;

case 60:

sFin += ” smoke “;

break;

case 61:

sFin += ” sweet “;

break;

case 62:

sFin += ” spice “;

break;

case 63:

sFin += ” oil “;

break;

case 64:

sFin += ” salt “;

break;

case 65:

sFin += ” arome “;

break;

case 66:

sFin += ” ling “;

break;

case 67:

sFin += ” long “;

break;

case 68:

sFin += ” very “;

break;

case 69:

sFin += ” quick “;

break;

}

}

}

String sScore = “Score : ” + indValues[72];

String sPer = “% : ” + indValues[73];

String sReg = “Region : ” + indValues[74];

String sDist= “District : ” + indValues[75];

//I clump all my output strings together here

alertDialog.setMessage( sColor+”

”+sNose+”

”+sBody+”

”+sPal+”

”+sFin+”

”+sScore+”

”

+sPer+”%

”+sReg+”

”+sDist );

//close button

alertDialog.setButton(“Close”, new DialogInterface.OnClickListener() {

public void onClick(DialogInterface dialog, int which) {

} });

alertDialog.show();

}

}

});

}

//event for initial Image click

private OnClickListener iniPicClickListener = new OnClickListener()

{

public void onClick(View v)

{

//hide greeting hide image and show scotchList

greetTxt.setVisibility(8);

iniPic.setVisibility(8);

titleList.setVisibility(1);

}

};

}

[/java]