Save RML Extensions parameters in excel file.

2 files changed, 20 insertions, 17 deletions

diff --git a/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/ViewModels/MainViewVM.cs b/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/ViewModels/MainViewVM.cs
index 6b95cf190..4802e0af1 100644
--- a/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/ViewModels/MainViewVM.cs
+++ b/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/ViewModels/MainViewVM.cs
@@ -1295,7 +1295,7 @@ namespace Tango.MachineStudio.ThreadExtensions.ViewModels
                                 {
                                     ColorParametrsExcelModel colorParametrsExcelModel = new ColorParametrsExcelModel();
                                     colorParametrsExcelModel.Thread_name = ActiveRML.Name;
-                                    colorParametrsExcelModel.MachineNumber = machine.SerialNumber;
+                                    colorParametrsExcelModel.MachineNumber = machine.SerialNumber.ToString();
                                     colorParametrsExcelModel.White_point_L = ActiveRML.WhitePointL;
                                     colorParametrsExcelModel.White_point_a = ActiveRML.WhitePointA;
                                     colorParametrsExcelModel.White_point_B = ActiveRML.WhitePointB;
@@ -1305,10 +1305,10 @@ namespace Tango.MachineStudio.ThreadExtensions.ViewModels
 
                                     TestResultsViewVM.LoadTestResultsExcel(testResultsExcelModelList, machine.Guid, machine.SerialNumber);
                                 }
-
                             }
-                            writer.WriteData(colorParametrsExcelList, "Color parameters",2);
-                            writer.WriteData(testResultsExcelModelList, "Machine tests results", 2);
+                            
+                            writer.WriteData(colorParametrsExcelList, "Color parameters");
+                            writer.WriteData(testResultsExcelModelList.OrderBy(x => x.Machine_number), "Machine tests results");
                             
                             writer.Dispose();
 
diff --git a/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/ViewModels/TestResultsViewVM.cs b/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/ViewModels/TestResultsViewVM.cs
index f7823a77c..c1fb4497f 100644
--- a/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/ViewModels/TestResultsViewVM.cs
+++ b/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/ViewModels/TestResultsViewVM.cs
@@ -441,20 +441,20 @@ namespace Tango.MachineStudio.ThreadExtensions.ViewModels
                         testResultsExcelModel.Puller_tension = testresult.PullerTensionMin == null ? "" : testresult.PullerTensionMin.ToString();
                         testResultsExcelModel.Winder_tension = testresult.ExitTensionMin == null ? "" : testresult.ExitTensionMin.ToString();
 
-                        foreach( var tensileResult in testresult.TensileResults)
+                        foreach (var tensileResult in testresult.TensileResults)
                         {
-                            if(tensileResult.TestResultColor == TestResultColors.CYAN)
+                            if (tensileResult.TestResultColor == TestResultColors.CYAN)
                             {
-                                if(tensileResult.ColorPercent == 100)
+                                if (tensileResult.ColorPercent == 100)
                                 {
                                     testResultsExcelModel.Load_N_100_C = tensileResult.MaxLoad == null ? 0 : (double)tensileResult.MaxLoad;
                                     testResultsExcelModel.STDEV_100_C = tensileResult.StdevMaxLoad == null ? 0 : (double)tensileResult.StdevMaxLoad;
-                                    testResultsExcelModel.Change_100_C  = tensileResult.PercentChangeLoad == null ? 0 : (double)tensileResult.PercentChangeLoad;
+                                    testResultsExcelModel.Change_100_C = tensileResult.PercentChangeLoad == null ? 0 : (double)tensileResult.PercentChangeLoad;
                                     testResultsExcelModel.Strain_100_C = tensileResult.StrainMaxLoad == null ? 0 : (double)tensileResult.StrainMaxLoad;
                                     testResultsExcelModel.STDEV_100_C_2 = tensileResult.StdevStrainMaxLoad == null ? 0 : (double)tensileResult.StdevStrainMaxLoad;
                                     testResultsExcelModel.Change_100_C_2 = tensileResult.PercentChangeStrain == null ? 0 : (double)tensileResult.PercentChangeStrain;
                                 }
-                                else if(tensileResult.ColorPercent == 200)
+                                else if (tensileResult.ColorPercent == 200)
                                 {
                                     testResultsExcelModel.Load__N_200_C = tensileResult.MaxLoad == null ? 0 : (double)tensileResult.MaxLoad;
                                     testResultsExcelModel.STDEV_200_C = tensileResult.StdevMaxLoad == null ? 0 : (double)tensileResult.StdevMaxLoad;
@@ -464,7 +464,7 @@ namespace Tango.MachineStudio.ThreadExtensions.ViewModels
                                     testResultsExcelModel.Change_200_C_2 = tensileResult.PercentChangeStrain == null ? 0 : (double)tensileResult.PercentChangeStrain;
                                 }
                             }
-                            else if(tensileResult.TestResultColor == TestResultColors.BLACK)
+                            else if (tensileResult.TestResultColor == TestResultColors.BLACK)
                             {
                                 if (tensileResult.ColorPercent == 100)
                                 {
@@ -484,18 +484,18 @@ namespace Tango.MachineStudio.ThreadExtensions.ViewModels
                                     testResultsExcelModel.STDEV_200_K_2 = tensileResult.StdevStrainMaxLoad == null ? 0 : (double)tensileResult.StdevStrainMaxLoad;
                                     testResultsExcelModel.Change_200_K_2 = tensileResult.PercentChangeStrain == null ? 0 : (double)tensileResult.PercentChangeStrain;
                                 }
-                               
+
                             }
                             else if (tensileResult.IsWhiteColor)
                             {
                                 testResultsExcelModel.Load__N_REF = tensileResult.MaxLoad == null ? 0 : (double)tensileResult.MaxLoad;
                                 testResultsExcelModel.STDEV_REF = tensileResult.StdevMaxLoad == null ? 0 : (double)tensileResult.StdevMaxLoad;
-                                testResultsExcelModel.REF_Strain = tensileResult.StdevStrainMaxLoad == null ? 0 : (double)tensileResult.StdevStrainMaxLoad;
-                                testResultsExcelModel.STDEV_Strain_REF = tensileResult.PercentChangeStrain == null ? 0 : (double)tensileResult.PercentChangeStrain;
+                                testResultsExcelModel.STDEV_Strain_REF = tensileResult.StdevStrainMaxLoad == null ? 0 : (double)tensileResult.StdevStrainMaxLoad;
+                                testResultsExcelModel.REF_Strain = tensileResult.StrainMaxLoad == null ? 0 : (double)tensileResult.StrainMaxLoad;
                             }
 
                         }
-            
+
                         foreach (var rubbingresult in testresult.RubbingResults)
                         {
                             if (rubbingresult.TestResultColor == TestResultColors.CYAN)
@@ -527,9 +527,12 @@ namespace Tango.MachineStudio.ThreadExtensions.ViewModels
                                 testResultsExcelModel.Rubbing_K_200___GS = rubbingresult.Gs200 == null ? 0.0 : (double)rubbingresult.Gs200;
                             }
                         }
-
-                        testResultsExcelModel.Uniformity_Zone_1 = testresult.SeverityZone1Min == null ? "" : testresult.SeverityZone1Min.ToString() + "-" + testresult.SeverityZone1Max == null ? "" : testresult.SeverityZone1Max.ToString();
-                        testResultsExcelModel.Uniformity_Zone_2 = testresult.SeverityZone2Min == null ? "" : testresult.SeverityZone2Min.ToString() + "-" + testresult.SeverityZone2Max == null ? "" : testresult.SeverityZone2Max.ToString();
+                        string minZone = testresult.SeverityZone1Min == null ? "" : ((double)testresult.SeverityZone1Min).ToString();
+                        string maxZone = testresult.SeverityZone1Max == null ? "" : ((double)testresult.SeverityZone1Max).ToString();
+                        testResultsExcelModel.Uniformity_Zone_1 = $"{minZone} - {maxZone}";
+                        minZone = testresult.SeverityZone2Min == null ? "" : ((double)testresult.SeverityZone2Min).ToString();
+                        maxZone = testresult.SeverityZone2Max == null ? "" : ((double)testresult.SeverityZone2Max).ToString();
+                        testResultsExcelModel.Uniformity_Zone_2 = $"{minZone} - {maxZone}";
 
                         testResultsExcelModel.COF_REF = testresult.RefCof == null ? 0.0 : (double)testresult.RefCof;
                         testResultsExcelModel.CV_REF = 0.0;