public void CreateGraphInput(Constants.SimulationType simulationType)
{
ExcelManipulation excelGraph = new ExcelManipulation();
excelGraph.CreateExcelFile();
int grrow = 1;
int grcol = 1;
excelGraph.createHeaders(grrow, grcol, "Run No", "A", "B", 2, true, 10, "n");
excelGraph.createHeaders(grrow, ++grcol, "Simulation Type", "A", "B", 2, true, 10, "n");
excelGraph.createHeaders(grrow, ++grcol, "Total Budget", "A", "B", 2, true, 10, "n");
excelGraph.createHeaders(grrow, ++grcol, "Average Budget", "A", "B", 2, true, 10, "n");
excelGraph.createHeaders(grrow, ++grcol, "Average Reputation", "A", "B", 2, true, 10, "n");
excelGraph.createHeaders(grrow, ++grcol, "Min Reputation", "A", "B", 2, true, 10, "n");
excelGraph.createHeaders(grrow, ++grcol, "Max Reputation", "A", "B", 2, true, 10, "n");
excelGraph.createHeaders(grrow, ++grcol, "Growth Factor ws5", "A", "B", 2, true, 10, "n");
excelGraph.createHeaders(grrow, ++grcol, "Growth Factor ws10", "A", "B", 2, true, 10, "n");
excelGraph.createHeaders(grrow, ++grcol, "Growth Factor ws15", "A", "B", 2, true, 10, "n");
excelGraph.createHeaders(grrow, ++grcol, "Comp prob ws5", "A", "B", 2, true, 10, "n");
excelGraph.createHeaders(grrow, ++grcol, "Comp prob ws10", "A", "B", 2, true, 10, "n");
excelGraph.createHeaders(grrow, ++grcol, "Comp prob ws15", "A", "B", 2, true, 10, "n");
excelGraph.createHeaders(grrow, ++grcol, "Coop prob ws6", "A", "B", 2, true, 10, "n");
excelGraph.createHeaders(grrow, ++grcol, "Coop prob ws11", "A", "B", 2, true, 10, "n");
excelGraph.createHeaders(grrow, ++grcol, "Coop prob ws16", "A", "B", 2, true, 10, "n");
excelGraph.createHeaders(grrow, ++grcol, "Reward Chance ws5", "A", "B", 2, true, 10, "n");
excelGraph.createHeaders(grrow, ++grcol, "Reward Chance ws10", "A", "B", 2, true, 10, "n");
excelGraph.createHeaders(grrow, ++grcol, "Reward Chance ws15", "A", "B", 2, true, 10, "n");
for (int i = 0; i < avgBudget.Count; i++)
{
grrow++;
grcol = 1;
excelGraph.InsertData(grrow, grcol, i.ToString(), "", "", "");
excelGraph.InsertData(grrow, ++grcol, simulationType.ToString(), "", "", "");
excelGraph.InsertData(grrow, ++grcol, totalBudget[i].ToString(), "", "", "");
excelGraph.InsertData(grrow, ++grcol, avgBudget[i].ToString(), "", "", "");
excelGraph.InsertData(grrow, ++grcol, avgReputation[i].ToString(), "", "", "");
excelGraph.InsertData(grrow, ++grcol, minReputation[i].ToString(), "", "", "");
excelGraph.InsertData(grrow, ++grcol, maxReputation[i].ToString(), "", "", "");
excelGraph.InsertData(grrow, ++grcol, growthFactor5[i].ToString(), "", "", "");
excelGraph.InsertData(grrow, ++grcol, growthFactor10[i].ToString(), "", "", "");
excelGraph.InsertData(grrow, ++grcol, growthFactor15[i].ToString(), "", "", "");
excelGraph.InsertData(grrow, ++grcol, compProb5[i].ToString(), "", "", "");
excelGraph.InsertData(grrow, ++grcol, compProb10[i].ToString(), "", "", "");
excelGraph.InsertData(grrow, ++grcol, compProb15[i].ToString(), "", "", "");
excelGraph.InsertData(grrow, ++grcol, coopProb6[i].ToString(), "", "", "");
excelGraph.InsertData(grrow, ++grcol, coopProb11[i].ToString(), "", "", "");
excelGraph.InsertData(grrow, ++grcol, coopProb16[i].ToString(), "", "", "");
excelGraph.InsertData(grrow, ++grcol, rewardChance5[i].ToString(), "", "", "");
excelGraph.InsertData(grrow, ++grcol, rewardChance10[i].ToString(), "", "", "");
excelGraph.InsertData(grrow, ++grcol, rewardChance15[i].ToString(), "", "", "");
}
long ticks = DateTime.Now.Ticks;
excelGraph.SaveDocument("coopetitionGraph_" + simulationType + "_" + ticks + ".xls");
}
public void CreateGraphInput(Constants.SimulationType simulationType)
{
ExcelManipulation excelGraph = new ExcelManipulation();
excelGraph.CreateExcelFile();
int grrow = 1;
int grcol = 1;
excelGraph.createHeaders(grrow, grcol, "Run No", "A", "B", 2, true, 10, "n");
excelGraph.createHeaders(grrow, ++grcol, "Simulation Type", "A", "B", 2, true, 10, "n");
excelGraph.createHeaders(grrow, ++grcol, "Total Budget", "A", "B", 2, true, 10, "n");
excelGraph.createHeaders(grrow, ++grcol, "Average Budget", "A", "B", 2, true, 10, "n");
excelGraph.createHeaders(grrow, ++grcol, "Average Reputation", "A", "B", 2, true, 10, "n");
excelGraph.createHeaders(grrow, ++grcol, "Min Reputation", "A", "B", 2, true, 10, "n");
excelGraph.createHeaders(grrow, ++grcol, "Max Reputation", "A", "B", 2, true, 10, "n");
excelGraph.createHeaders(grrow, ++grcol, "Growth Factor ws5", "A", "B", 2, true, 10, "n");
excelGraph.createHeaders(grrow, ++grcol, "Growth Factor ws10", "A", "B", 2, true, 10, "n");
excelGraph.createHeaders(grrow, ++grcol, "Growth Factor ws15", "A", "B", 2, true, 10, "n");
excelGraph.createHeaders(grrow, ++grcol, "Comp prob ws5", "A", "B", 2, true, 10, "n");
excelGraph.createHeaders(grrow, ++grcol, "Comp prob ws10", "A", "B", 2, true, 10, "n");
excelGraph.createHeaders(grrow, ++grcol, "Comp prob ws15", "A", "B", 2, true, 10, "n");
excelGraph.createHeaders(grrow, ++grcol, "Coop prob ws6", "A", "B", 2, true, 10, "n");
excelGraph.createHeaders(grrow, ++grcol, "Coop prob ws11", "A", "B", 2, true, 10, "n");
excelGraph.createHeaders(grrow, ++grcol, "Coop prob ws16", "A", "B", 2, true, 10, "n");
excelGraph.createHeaders(grrow, ++grcol, "Reward Chance ws5", "A", "B", 2, true, 10, "n");
excelGraph.createHeaders(grrow, ++grcol, "Reward Chance ws10", "A", "B", 2, true, 10, "n");
excelGraph.createHeaders(grrow, ++grcol, "Reward Chance ws15", "A", "B", 2, true, 10, "n");
for (int i = 0; i < avgBudget.Count; i++)
{
grrow++;
grcol = 1;
excelGraph.InsertData(grrow, grcol, i.ToString(), "", "", "");
excelGraph.InsertData(grrow, ++grcol, simulationType.ToString(), "", "", "");
excelGraph.InsertData(grrow, ++grcol, totalBudget[i].ToString(), "", "", "");
excelGraph.InsertData(grrow, ++grcol, avgBudget[i].ToString(), "", "", "");
excelGraph.InsertData(grrow, ++grcol, avgReputation[i].ToString(), "", "", "");
excelGraph.InsertData(grrow, ++grcol, minReputation[i].ToString(), "", "", "");
excelGraph.InsertData(grrow, ++grcol, maxReputation[i].ToString(), "", "", "");
excelGraph.InsertData(grrow, ++grcol, growthFactor5[i].ToString(), "", "", "");
excelGraph.InsertData(grrow, ++grcol, growthFactor10[i].ToString(), "", "", "");
excelGraph.InsertData(grrow, ++grcol, growthFactor15[i].ToString(), "", "", "");
excelGraph.InsertData(grrow, ++grcol, compProb5[i].ToString(), "", "", "");
excelGraph.InsertData(grrow, ++grcol, compProb10[i].ToString(), "", "", "");
excelGraph.InsertData(grrow, ++grcol, compProb15[i].ToString(), "", "", "");
excelGraph.InsertData(grrow, ++grcol, coopProb6[i].ToString(), "", "", "");
excelGraph.InsertData(grrow, ++grcol, coopProb11[i].ToString(), "", "", "");
excelGraph.InsertData(grrow, ++grcol, coopProb16[i].ToString(), "", "", "");
excelGraph.InsertData(grrow, ++grcol, rewardChance5[i].ToString(), "", "", "");
excelGraph.InsertData(grrow, ++grcol, rewardChance10[i].ToString(), "", "", "");
excelGraph.InsertData(grrow, ++grcol, rewardChance15[i].ToString(), "", "", "");
}
long ticks = DateTime.Now.Ticks;
excelGraph.SaveDocument("coopetitionGraph_" + simulationType + "_" + ticks + ".xls");
}
