/// <summary>
/// Obrigatório ser chamado antes de qualquer heuristica
/// </summary>
/// <param name="n"></param>
/// <param name="nAf"></param>
/// <param name="nTa"></param>
/// <param name="m"></param>
/// <param name="r"></param>
/// <param name="volMin"></param>
/// <param name="volMax"></param>
/// <param name="alfaRegArea"></param>
/// <param name="areaTotal"></param>
/// <param name="alfa"></param>
/// <param name="beta"></param>
/// <param name="gama"></param>
public static void LoadData(int n = 91, int nAf = 72, int nTa = 0, int m = 72, int r = 6, int h = 19)
{
HeuristicsBase.n = n;
HeuristicsBase.nAf = nAf;
HeuristicsBase.nTa = nTa;
HeuristicsBase.m = m;
HeuristicsBase.h = h;
HeuristicsBase.r = r;
talhoes = new Talhao[n];
mVPL = new double[n, m];
mColheita = new double[n, m];
mBaldeio = new double[n, m];
mTransporte = new double[n, m];
mSilvicultura = new double[n, m];
mImplantacao = new double[n, m];
mAnteriores = new double[n, m];
mCustosMedios = new double[n, m];
mReceita = new double[n, m];
mCorte = new bool[n, m, h];
mVolume = new double[n, m, h];
mAdj = new bool[n, n];
mDistancia = new double[n, n];
mRegArea = new double[n, m, r];
}
public static void LoadXLSX(string filename)
{
Excel.Application app = new Excel.Application();
app.EnableSound = false;
Excel.Workbook workbook = app.Workbooks.Open(filename,
Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing);
Excel.Worksheet worksheet = (Excel.Worksheet)workbook.Sheets["Dados"];
int n = Convert.ToInt32(((Excel.Range)(worksheet.Cells[2, 1])).Value2);
int m = nAf = Convert.ToInt32(((Excel.Range)(worksheet.Cells[4, 1])).Value2);
int r = Convert.ToInt32(((Excel.Range)(worksheet.Cells[6, 1])).Value2);
int h = Convert.ToInt32(((Excel.Range)(worksheet.Cells[8, 1])).Value2);
int nTa = 0;
LoadData(n, nAf, nTa, m, r, h);
worksheet = (Excel.Worksheet)workbook.Sheets["Prescrições"];
Excel.Range range = worksheet.get_Range(CellFormat(2, 1), CellFormat(n * m + 2, 17));
object[,] values = (object[, ])range.Value2;
for (int i = 0; i < n; i++)
{
for (int j = 0; j < m; j++)
{
mReceita[i, j] = Convert.ToDouble(values[i * m + j + 1, 9]);
mVPL[i, j] = Convert.ToDouble(values[i * m + j + 1, 10]);
mColheita[i, j] = Convert.ToDouble(values[i * m + j + 1, 11]);
mBaldeio[i, j] = Convert.ToDouble(values[i * m + j + 1, 12]);
mTransporte[i, j] = Convert.ToDouble(values[i * m + j + 1, 13]);
mSilvicultura[i, j] = Convert.ToDouble(values[i * m + j + 1, 14]);
mImplantacao[i, j] = Convert.ToDouble(values[i * m + j + 1, 15]);
mAnteriores[i, j] = Convert.ToDouble(values[i * m + j + 1, 16]);
mCustosMedios[i, j] = Convert.ToDouble(values[i * m + j + 1, 17]);
}
}
for (int i = 0; i < n; i++)
{
talhoes[i] = new Talhao();
talhoes[i].area = Convert.ToDouble(values[i * m + 1, 2]);
talhoes[i].id = Convert.ToInt32(values[i * m + 1, 1]);
talhoes[i].idade = Convert.ToInt32(values[i * m + 1, 3]);
talhoes[i].regime = (string)values[i * m + 12, 4];
}
worksheet = (Excel.Worksheet)workbook.Sheets["mCorte"];
range = worksheet.get_Range(CellFormat(2, 1), CellFormat(n * m + 2, h));
values = (object[, ])range.Value2;
for (int i = 0; i < n; i++)
{
for (int j = 0; j < m; j++)
{
for (int k = 0; k < h; k++)
{
mCorte[i, j, k] = Convert.ToInt32(Convert.ToDouble(values[i * m + j + 1, k + 1])) == 1;
}
}
}
worksheet = (Excel.Worksheet)workbook.Sheets["mRegArea"];
range = worksheet.get_Range(CellFormat(2, 1), CellFormat(n * m + 2, r));
values = (object[, ])range.Value2;
for (int i = 0; i < n; i++)
{
for (int j = 0; j < m; j++)
{
for (int k = 0; k < r; k++)
{
mRegArea[i, j, k] = Convert.ToDouble(values[i * m + j + 1, k + 1]);
}
}
}
worksheet = (Excel.Worksheet)workbook.Sheets["mVolume"];
range = worksheet.get_Range(CellFormat(2, 3), CellFormat(n * m + 2, h + 2));
values = (object[, ])range.Value2;
for (int i = 0; i < n; i++)
{
for (int j = 0; j < m; j++)
{
for (int k = 0; k < h; k++)
{
mVolume[i, j, k] = Convert.ToDouble(values[i * m + j + 1, k + 1]);
}
}
}
volumeMedio = 0;
//Soma do volume das prescrições de um talhão
double somaTalhao = 0;
//Soma os resultados de cada ano
for (int k = 0; k < h; k++)
{
//Soma as médias das prescrições dos talhões em um ano
for (int i = 0; i < n; i++)
{
somaTalhao = 0;
//Soma as prescrições de um talhão
for (int j = 0; j < m; j++)
{
if (mVolume[i, j, k] != 0)
{
somaTalhao += mVolume[i, j, k];
}
}
volumeMedio += somaTalhao / m;
}
}
volumeMedio /= h;
worksheet = (Excel.Worksheet)workbook.Sheets["mAdj"];
range = worksheet.get_Range(CellFormat(2, 3), CellFormat(n + 2, n + 2));
values = (object[, ])range.Value2;
for (int i = 0; i < n; i++)
{
for (int j = 0; j < n; j++)
{
if (Convert.ToInt32(Convert.ToDouble(values[i + 1, j + 1])) == 1)
{
talhoes[i].vizinhos.Add(j);
}
mAdj[i, j] = Convert.ToInt32(Convert.ToDouble(values[i + 1, j + 1])) == 1;
}
}
worksheet = (Excel.Worksheet)workbook.Sheets["mDistancia"];
range = worksheet.get_Range(CellFormat(2, 1), CellFormat(n * n + 2, 3));
values = (object[, ])range.Value2;
int n2 = n * n;
for (int i = 0; i < n2; i++)
{
mDistancia[Convert.ToInt32(values[i + 1, 1]) - 1, Convert.ToInt32(values[i + 1, 2]) - 1] = Convert.ToDouble(values[i + 1, 3]);
}
worksheet = (Excel.Worksheet)workbook.Sheets["Dados"];
double volMin = Convert.ToDouble(((Excel.Range)(worksheet.Cells[10, 1])).Value2);
double volMax = Convert.ToDouble(((Excel.Range)(worksheet.Cells[12, 1])).Value2);
double alfaRegArea = Convert.ToDouble(((Excel.Range)(worksheet.Cells[14, 1])).Value2);
double alfaRegVol = Convert.ToDouble(((Excel.Range)(worksheet.Cells[16, 1])).Value2);
double betaRegVol = Convert.ToDouble(((Excel.Range)(worksheet.Cells[18, 1])).Value2);
double alfa = Convert.ToDouble(((Excel.Range)(worksheet.Cells[20, 1])).Value2);
double beta = Convert.ToDouble(((Excel.Range)(worksheet.Cells[22, 1])).Value2);
double gama = Convert.ToDouble(((Excel.Range)(worksheet.Cells[24, 1])).Value2);
double areaTotal = talhoes.Aggregate(0.0, (acc, p) => acc + p.area);
LoadParams(volMin, volMax, alfaRegArea, areaTotal, alfaRegVol, betaRegVol, volumeMedio, alfa, beta, gama);
workbook.Close(0);
app.Quit();
}