function tl_GetMinCost(cellValue, rowNum, columnNum) {
  Logger.log("TEST");
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getActiveSheet();
  var range = sheet.getRange(rowNum, columnNum);
  var address = range.getA1Notation();

  var array = [];

  var buyable = sheet.getRange(rowNum, columnNum + 5).getValue();
  var findable = sheet.getRange(rowNum, columnNum + 6).getValue();

  var crafting = tl_GetMinCraftingCost(rowNum, columnNum);

  if(findable > 0) array.push(findable);
  if(buyable > 0) array.push(buyable);
  if(crafting > 0) array.push(crafting);


  // No values were above 0, so the effort is null
  if(array.length < 1) return null;

  var min = Math.min.apply(null, array);

  return min;
}

function tl_GetMinCost(cellValue, rowNum, columnNum) {
  Logger.log("TEST");
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getActiveSheet();
  var range = sheet.getRange(rowNum, columnNum);
  var address = range.getA1Notation();

  var array = [];

  var buyable = sheet.getRange(rowNum, columnNum + 5).getValue();
  var findable = sheet.getRange(rowNum, columnNum + 6).getValue();

  var crafting = tl_GetMinCraftingCost(rowNum, columnNum);

  if(findable > 0) array.push(findable);
  if(buyable > 0) array.push(buyable);
  if(crafting > 0) array.push(crafting);


  // No values were above 0, so the effort is null
  if(array.length < 1) return null;

  var min = Math.min.apply(null, array);

  return min;
}

function tl_GetMaxCost(cellValue, rowNum, columnNum) {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getActiveSheet();
  var range = sheet.getRange(rowNum, columnNum);
  var address = range.getA1Notation();

  var array = [];

  var buyable = sheet.getRange(rowNum, columnNum + 5).getValue();
  var findable = sheet.getRange(rowNum, columnNum + 6).getValue();

  var crafting = tl_GetMaxCraftingCost(rowNum, columnNum);

  if(findable > 0) array.push(findable);
  if(buyable > 0) array.push(buyable);
  if(crafting > 0) array.push(crafting);


  // No values were above 0, so the effort is null
  if(array.length < 1) return null;

  var min = Math.max.apply(null, array);

  return min;
}

function tl_GetMinCraftingCost(rowNum, columnNum)
{
    Logger.log("TEST");
    var ss = SpreadsheetApp.getActiveSpreadsheet();
    var sheet = ss.getActiveSheet();
    var range = sheet.getRange(rowNum, columnNum);

  var crafting = 0;
  var operationCost = sheet.getRange(rowNum, columnNum + 2).getValue();
  var craftingRange = sheet.getRange(rowNum, columnNum + 1);//TODO foreach item in components crafting += item.GetMin(itemValue, itemRowNum, itemColumnNum)

  if(!craftingRange.isBlank())
  {
     var craftingAddress = craftingRange.getValue();

    //split into array
    var valuesArray = craftingAddress.split(',');

    for(var i = 0; i < valuesArray.length; i++)
    {
      var itemKey = valuesArray[i];
      var itemColumn = 1; //Column B
      var itemRow = tl_GetRowOfItem(itemKey);

      crafting += tl_GetMinCraftingCost(itemRow, itemColumn);
    }
  }
  else
  {
   return 0;
  }

  if(crafting > 0)
  {
    crafting += operationCost;
  }

   return crafting;
}

function test()
{
  return 5;
}

function tl_GetRowOfItem(itemKey)
{
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var data = sheet.getDataRange().getValues();
  for(var i = 0; i<data.length;i++)
  {
    if(data[i][1] == itemKey){ //[1] because column B
      //Logger.log((i+1))
      return i+1;
    }
  }

  return 0;
}