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"); }