public static void InitRobot()
{
robotApp = new RobotApplication();
nodeServer = robotApp.Project.Structure.Nodes;
barServer = robotApp.Project.Structure.Bars;
caseServer = robotApp.Project.Structure.Cases;
labelServer = robotApp.Project.Structure.Labels;
PrefrencesServer = robotApp.Project.Preferences;
barForceServer = robotApp.Project.Structure.Results.Bars.Forces;
}
public static double[,] Run_analysis()
{
robApp.Project.CalcEngine.Calculate();
results = robApp.Project.Structure.Results.Bars.Forces;
double[,] a = new double[6, Genome.towerBar_cnt];
// for (int k = 0; k < 4; k++) //para 5 casos de carga
// {
for (int i = 0; i < Genome.towerBar_cnt; i++)
{
IRobotBar current_bar = (IRobotBar)robApp.Project.Structure.Bars.Get(i + 1);
a[0, i] = i + 1;
a[1, i] = current_bar.Length;
a[2, i] = Max(results.Value(i + 1, 1, 0).FX * -1.0, results.Value(i + 1, 1, 0.5).FX * -1.0, results.Value(i + 1, 1, 1).FX * -1.0) / 1000; //converter N para Kn *-1 porque comp = + no robot
// a[3, i] = Max(results.Value(i + 1, 1, 0).MY, results.Value(i + 1, 1, 0.5).MY, results.Value(i + 1, 1, 1).MY) / 1000; //N/m -> kN/m
// a[4, i] = Max(results.Value(i + 1, 1, 0).MZ, results.Value(i + 1, 1, 0.5).MZ, results.Value(i + 1, 1, 1).MZ) / 1000;
//a[5, i] = 1; //remover(era para o V)
// para comparar multiplos load cases
for (int k = 2; k < 5; k++)
{
double temp = Max(results.Value(i + 1, k, 0).FX * -1.0, results.Value(i + 1, k, 0.5).FX * -1.0, results.Value(i + 1, k, 1).FX * -1.0) / 1000;
if (a[2, i] < 0 && temp < 0) // se a verificação e de buckling
{
a[2, i] = Math.Min(a[2, i], temp);
}
else if (a[2, i] < 0 && temp > 0)
{
if (temp * 0.4 > Math.Abs(a[2, i]))
{
a[2, i] = temp;
} // so se força de traçao for muito maior é que substitui força de comp
}
else if (a[2, i] > 0 && temp < 0)
{
if (Math.Abs(temp) > 0.4 * a[2, i])
{
a[2, i] = temp;
} // so se a F tração for muito grande é que nao é subst por comp
}
else if (a[2, i] > 0 && temp > 0)
{
a[2, i] = Math.Max(temp, a[2, i]);
}
}
}
return(a); //[rbt_bar_num,Lenght,Fx,My,Mz]
}
public void CopyData()
{
button1.Text = "Loading...";
//this.WindowState = FormWindowState.Minimized;
//-------------------------------------
//Load Cases
IRobotCaseCollection robotCaseCollection = robapp.Project.Structure.Cases.GetAll();
int loadCase = 0;
int FindCase(string casename)
{
int number = 1;
IRobotCase robotCase = robapp.Project.Structure.Cases.Get(1);
for (int i = 0; i < robotCaseCollection.Count; i++)
{
robotCase = robapp.Project.Structure.Cases.Get(i);
if (robotCase != null)
{
if (robotCase.Name == casename)
{
number = i;
break;
}
}
}
loadCase = number;
return(number);
}
//-------------------------------------
//Get Number of Bars Selected
RobotSelection barSel = robapp.Project.Structure.Selections.Get(IRobotObjectType.I_OT_BAR);
//Get All Load Cases
RobotSelection casSel = robapp.Project.Structure.Selections.Get(IRobotObjectType.I_OT_CASE);
//Get Bar and Node Data
IRobotBarServer robotBarServer = robapp.Project.Structure.Bars;
IRobotNodeServer inds = robapp.Project.Structure.Nodes;
//Get a List of the bars and Setup bar information Struct
int[] barSelArray = new int[barSel.Count];
BeamDataStruct[] beamData = new BeamDataStruct[barSelArray.Length];
for (int i = 1; i < barSel.Count + 1; i++)
{
//Setup bar no. array
barSelArray[i - 1] = barSel.Get(i);
//Get node information from bar data
IRobotBar bar = (IRobotBar)robotBarServer.Get(barSelArray[i - 1]);
int startNodeNo = bar.StartNode;
int endNodeNo = bar.EndNode;
IRobotNode startNode = (IRobotNode)inds.Get(startNodeNo);
IRobotNode endNode = (IRobotNode)inds.Get(endNodeNo);
//If a Beam, Skip
if (startNode.Z == endNode.Z)
{
continue;
}
//Which is highest node
IRobotNode node = (startNode.Z > endNode.Z) ? startNode : endNode;
//Populate beam data from node and bar data.
beamData[i - 1].barNo = barSelArray[i - 1];
IRobotBarSectionData sectData = bar.GetLabel(IRobotLabelType.I_LT_BAR_SECTION).Data;
double depth = sectData.GetValue(IRobotBarSectionDataValue.I_BSDV_BF);
double breath = sectData.GetValue(IRobotBarSectionDataValue.I_BSDV_D);
if (depth < breath)
{
double holder = breath;
breath = depth;
depth = holder;
}
depth = depth * 1000;
breath = breath * 1000;
beamData[i - 1].section = $"C1 {depth} x {breath}";
beamData[i - 1].x = node.X;
beamData[i - 1].y = node.Y;
beamData[i - 1].z = node.Z;
beamData[i - 1].height = bar.Length;
IRobotMaterialData concrete = bar.GetLabel(IRobotLabelType.I_LT_MATERIAL).Data;
Double concreteS = concrete.RE / 1000000;
beamData[i - 1].concreteStrength = concreteS.ToString();
}
textBox2.AppendText("\r\nSorting\r\n");
beamData = beamData.OrderBy(x => x.z).ToArray();
beamData = beamData.OrderBy(x => x.y).ToArray();
beamData = beamData.OrderBy(x => x.x).ToArray();
int group = 1;
int posInGroup = 0;
for (int i = 0; i < beamData.Length; i++)
{
posInGroup = 0;
for (int j = 0; j < beamData.Length; j++)
{
if (beamData[i].x - beamData[j].x < 0.0001 && beamData[i].y - beamData[j].y < 0.0001 && beamData[i].barNo != beamData[j].barNo)
{
if (beamData[j].group != 0)
{
beamData[i].group = beamData[j].group;
for (int k = 0; k < beamData.Length; k++)
{
if (beamData[i].group == beamData[k].group && beamData[i].barNo != beamData[k].barNo)
{
posInGroup++;
}
}
beamData[i].posInGroup = posInGroup;
}
else
{
beamData[i].group = group;
group++;
}
break;
}
}
}
void CalculateResults()
{
textBox2.AppendText($"\r\nStarting calculation: {DateTime.Now.ToString("h:mm:ss tt")}");
RobotExtremeParams robotExtremeParams = robapp.CmpntFactory.Create(IRobotComponentType.I_CT_EXTREME_PARAMS);
robapp.Project.Structure.Selections.Get(IRobotObjectType.I_OT_CASE).FromText(FindCase(listBox1.SelectedItem.ToString()).ToString());
robotExtremeParams.Selection.Set(IRobotObjectType.I_OT_CASE, casSel);
IRobotBarForceServer robotBarResultServer = robapp.Project.Structure.Results.Bars.Forces;
int total = beamData.Length;
bool firstLoop = true;
string columnsSelected = "";
for (int i = 0; i < beamData.Length; i++)
{
DateTime startTime = DateTime.Now;
textBox2.AppendText($"\r\nStart Calculation {i + 1} / {total} before bar selection: {DateTime.Now.ToString("h:mm:ss tt")}");
robapp.Project.Structure.Selections.Get(IRobotObjectType.I_OT_BAR).FromText(beamData[i].barNo.ToString());
robotExtremeParams.Selection.Set(IRobotObjectType.I_OT_BAR, barSel);
//MZ
robotExtremeParams.ValueType = IRobotExtremeValueType.I_EVT_FORCE_BAR_MZ;
if (Math.Abs(robapp.Project.Structure.Results.Extremes.MaxValue(robotExtremeParams).Value) > Math.Abs(robapp.Project.Structure.Results.Extremes.MinValue(robotExtremeParams).Value))
{
beamData[i].mZForceServer = robotBarResultServer.ValueEx(beamData[i].barNo, loadCase, robapp.Project.Structure.Results.Extremes.MaxValue(robotExtremeParams).CaseCmpnt, 1);
beamData[i].mZForceServerbtm = robotBarResultServer.ValueEx(beamData[i].barNo, loadCase, robapp.Project.Structure.Results.Extremes.MaxValue(robotExtremeParams).CaseCmpnt, 0);
}
else
{
beamData[i].mZForceServer = robotBarResultServer.ValueEx(beamData[i].barNo, loadCase, robapp.Project.Structure.Results.Extremes.MinValue(robotExtremeParams).CaseCmpnt, 1);
beamData[i].mZForceServerbtm = robotBarResultServer.ValueEx(beamData[i].barNo, loadCase, robapp.Project.Structure.Results.Extremes.MinValue(robotExtremeParams).CaseCmpnt, 0);
}
beamData[i].mzValue = Math.Abs(beamData[i].mZForceServer.MZ) > Math.Abs(beamData[i].mZForceServerbtm.MZ) ? beamData[i].mZForceServer.FX : beamData[i].mZForceServerbtm.FX;
//MY
robotExtremeParams.ValueType = IRobotExtremeValueType.I_EVT_FORCE_BAR_MY;
if (Math.Abs(robapp.Project.Structure.Results.Extremes.MaxValue(robotExtremeParams).Value) > Math.Abs(robapp.Project.Structure.Results.Extremes.MinValue(robotExtremeParams).Value))
{
beamData[i].mYForceServer = robotBarResultServer.ValueEx(beamData[i].barNo, loadCase, robapp.Project.Structure.Results.Extremes.MaxValue(robotExtremeParams).CaseCmpnt, 1);
beamData[i].mYForceServerbtm = robotBarResultServer.ValueEx(beamData[i].barNo, loadCase, robapp.Project.Structure.Results.Extremes.MaxValue(robotExtremeParams).CaseCmpnt, 0);
}
else
{
beamData[i].mYForceServer = robotBarResultServer.ValueEx(beamData[i].barNo, loadCase, robapp.Project.Structure.Results.Extremes.MinValue(robotExtremeParams).CaseCmpnt, 1);
beamData[i].mYForceServerbtm = robotBarResultServer.ValueEx(beamData[i].barNo, loadCase, robapp.Project.Structure.Results.Extremes.MinValue(robotExtremeParams).CaseCmpnt, 0);
}
beamData[i].myValue = Math.Abs(beamData[i].mYForceServer.MY) > Math.Abs(beamData[i].mYForceServerbtm.MY) ? beamData[i].mYForceServer.FX : beamData[i].mYForceServerbtm.FX;
//FX
robotExtremeParams.ValueType = IRobotExtremeValueType.I_EVT_FORCE_BAR_FX;
if (Math.Abs(robapp.Project.Structure.Results.Extremes.MaxValue(robotExtremeParams).Value) > Math.Abs(robapp.Project.Structure.Results.Extremes.MinValue(robotExtremeParams).Value))
{
beamData[i].fXForceServer = robotBarResultServer.ValueEx(beamData[i].barNo, loadCase, robapp.Project.Structure.Results.Extremes.MaxValue(robotExtremeParams).CaseCmpnt, 1);
beamData[i].fXForceServerbtm = robotBarResultServer.ValueEx(beamData[i].barNo, loadCase, robapp.Project.Structure.Results.Extremes.MaxValue(robotExtremeParams).CaseCmpnt, 0);
}
else
{
beamData[i].fXForceServer = robotBarResultServer.ValueEx(beamData[i].barNo, loadCase, robapp.Project.Structure.Results.Extremes.MinValue(robotExtremeParams).CaseCmpnt, 1);
beamData[i].fXForceServerbtm = robotBarResultServer.ValueEx(beamData[i].barNo, loadCase, robapp.Project.Structure.Results.Extremes.MinValue(robotExtremeParams).CaseCmpnt, 0);
}
beamData[i].fxValue = Math.Abs(beamData[i].fXForceServer.FX) > Math.Abs(beamData[i].fXForceServerbtm.FX) ? beamData[i].fXForceServer.FX : beamData[i].fXForceServerbtm.FX;
double totalTime = (DateTime.Now - startTime).TotalSeconds;
textBox2.AppendText($"\r\nEnd Calculation {i + 1} / {total} {DateTime.Now.ToString("h:mm:ss tt")} \r\nTime taken: {totalTime}");
if (firstLoop)
{
textBox2.AppendText($"\r\nEstimated finish time: {DateTime.Now.AddSeconds(total * totalTime).ToString("h:mm:ss tt")}");
firstLoop = false;
}
columnsSelected += $"{beamData[i].barNo.ToString()} ";
}
textBox2.AppendText($"\r\ncolumns selected {columnsSelected}");
robapp.Project.Structure.Selections.Get(IRobotObjectType.I_OT_BAR).FromText(columnsSelected);
}
int maxCol = 1;
void WriteResults()
{
int column = 1;
int currentGroup = 0;
for (int i = 0; i < beamData.Length; i++)
{
if (beamData[i].group == currentGroup)
{
column = beamData[i].posInGroup;
if (column >= maxCol)
{
maxCol = column;
}
}
else
{
currentGroup++;
column = 0;
}
int row = currentGroup + 2;
int columnPos = beamData[i].posInGroup + 1;
WriteCell(row, 0, columnPos.ToString());
WriteCell(row, 1 + 22 * column, beamData[i].section.ToString());
WriteCell(row, 2 + 22 * column, beamData[i].barNo.ToString());
WriteCell(row, 3 + 22 * column, beamData[i].concreteStrength.ToString());
WriteCell(row, 4 + 22 * column, beamData[i].group.ToString());
WriteCell(row, 5 + 22 * column, beamData[i].posInGroup.ToString());
WriteCell(row, 6 + 22 * column, beamData[i].height.ToString());
WriteCell(row, 7 + 22 * column, (beamData[i].fxValue / 1000).ToString());
WriteCell(row, 8 + 22 * column, (beamData[i].fXForceServer.MY / 1000).ToString());
WriteCell(row, 9 + 22 * column, (beamData[i].fXForceServer.MZ / 1000).ToString());
WriteCell(row, 10 + 22 * column, (beamData[i].fXForceServerbtm.MY / 1000).ToString());
WriteCell(row, 11 + 22 * column, (beamData[i].fXForceServerbtm.MZ / 1000).ToString());
WriteCell(row, 12 + 22 * column, (beamData[i].mzValue / 1000).ToString());
WriteCell(row, 13 + 22 * column, (beamData[i].mZForceServer.MY / 1000).ToString());
WriteCell(row, 14 + 22 * column, (beamData[i].mZForceServer.MZ / 1000).ToString());
WriteCell(row, 15 + 22 * column, (beamData[i].mZForceServerbtm.MY / 1000).ToString());
WriteCell(row, 16 + 22 * column, (beamData[i].mZForceServerbtm.MZ / 1000).ToString());
WriteCell(row, 17 + 22 * column, (beamData[i].myValue / 1000).ToString());
WriteCell(row, 18 + 22 * column, (beamData[i].mYForceServer.MY / 1000).ToString());
WriteCell(row, 19 + 22 * column, (beamData[i].mYForceServer.MZ / 1000).ToString());
WriteCell(row, 20 + 22 * column, (beamData[i].mYForceServerbtm.MY / 1000).ToString());
WriteCell(row, 21 + 22 * column, (beamData[i].mYForceServerbtm.MZ / 1000).ToString());
}
WriteCell(0, 0, currentGroup.ToString());
}
void PopulateHeaders()
{
for (int i = 0; i <= maxCol; i++)
{
//Headers
WriteCell(1, 1 + 22 * i, "Cross Section");
WriteCell(1, 2 + 22 * i, "Bar No.");
WriteCell(1, 3 + 22 * i, "Concrete Strength");
WriteCell(1, 4 + 22 * i, "Group");
WriteCell(1, 5 + 22 * i, "Pos In Group");
WriteCell(1, 6 + 22 * i, "Length");
//FZ Max
WriteCell(1, 7 + 22 * i, "Fx (Max) [kN]");
WriteCell(1, 8 + 22 * i, "My (Top) [kNm]");
WriteCell(1, 9 + 22 * i, "Mz (Top) [kNm]");
WriteCell(1, 10 + 22 * i, "My (Btm) [kNm]");
WriteCell(1, 11 + 22 * i, "Mz (Btm) [kNm]");
//MX Max
WriteCell(1, 12 + 22 * i, "Fx (Max) [kN]");
WriteCell(1, 13 + 22 * i, "My (Top) [kNm]");
WriteCell(1, 14 + 22 * i, "Mz (Top) [kNm]");
WriteCell(1, 15 + 22 * i, "My (Btm) [kNm]");
WriteCell(1, 16 + 22 * i, "Mz (Btm) [kNm]");
//MY Max
WriteCell(1, 17 + 22 * i, "Fx (Max) [kN])");
WriteCell(1, 18 + 22 * i, "My (Top) [kNm]");
WriteCell(1, 19 + 22 * i, "Mz (Top) [kNm]");
WriteCell(1, 20 + 22 * i, "My (Btm) [kNm]");
WriteCell(1, 21 + 22 * i, "Mz (Btm) [kNm]");
//Headers
WriteCell(0, 9 + 22 * i, "Fx (Max)");
WriteCell(0, 14 + 22 * i, "Mz (Max)");
WriteCell(0, 19 + 22 * i, "My (Max)");
}
}
WriteData();
CalculateResults();
WriteResults();
PopulateHeaders();
SaveExcel();
CloseExcel();
button1.Text = "Start";
textBox2.AppendText("\r\nDone, view your documents for the file named 'Results for bars ~date~', you may close this window or select more columns and press 'Start'.");
robapp = null;
this.WindowState = FormWindowState.Normal;
}
