#5818 -Export to Excel file

3 files changed, 183 insertions, 10 deletions

diff --git a/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/Models/ColorParametrsExcelModel.cs b/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/Models/ColorParametrsExcelModel.cs
new file mode 100644
index 000000000..b762c1042
--- /dev/null
+++ b/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/Models/ColorParametrsExcelModel.cs
@@ -0,0 +1,59 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace Tango.MachineStudio.ThreadExtensions.Models
+{
+    public class ColorParametrsExcelModel
+    {
+        public String Thread_name { get; set; }
+        public String MachineNumber { get; set; }
+        public double White_point_L { get; set; }
+        public double White_point_a { get; set; }
+        public double White_point_B { get; set; }
+        public double Factor_100__C { get; set; }
+        public double Factor_100__Cyan_L { get; set; }
+        public double Factor_100__Cyan_A { get; set; }
+        public double Factor_100__Cyan_B { get; set; }
+        public double Factor_100__M { get; set; }
+        public double Factor_100__Magenta_L { get; set; }
+        public double Factor_100__Magenta_A { get; set; }
+        public double Factor_100__Magenta_B { get; set; }
+
+        public double Factor_100__Y { get; set; }
+        public double Factor_100__Yellow_L { get; set; }
+        public double Factor_100__Yellow_A { get; set; }
+        public double Factor_100__Yellow_B { get; set; }
+        public double Factor_100_K { get; set; }
+        public double Factor_100__Key_L { get; set; }
+        public double Factor_100__Key_A { get; set; }
+        public double Factor_100__Key_B { get; set; }
+        public double Factor_200_C { get; set; }
+        public double Factor_200__Cyan_L { get; set; }
+        public double Factor_200__Cyan_A { get; set; }
+        public double Factor_200__Cyan_B { get; set; }
+
+        public double Factor_200__Magenta { get; set; }
+        public double Factor_200__Magenta_L { get; set; }
+        public double Factor_200__Magenta_A { get; set; }
+        public double Factor_200__Magenta_B { get; set; }
+
+        public double Factor_200__Yellow { get; set; }
+        public double Factor_200__Yellow_L { get; set; }
+        public double Factor_200__Yellow_A { get; set; }
+        public double Factor_200__Yellow_B { get; set; }
+
+        public double Factor_200__Key { get; set; }
+        public double Factor_200__Key_L { get; set; }
+        public double Factor_200__Key_A { get; set; }
+        public double Factor_200__Key_B { get; set; }
+        
+        public int Min_Ink_Uptake_Zone1 { get; set; }
+        public int Min_Ink_Uptake_Zone2 { get; set; }
+        public int Max_Ink_Uptake_Zone1 { get; set; }
+        public int Max_ink_uptake__Zone2 { get; set; }
+        
+    }
+}
diff --git a/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/Models/TestResultsExcelModel.cs b/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/Models/TestResultsExcelModel.cs
new file mode 100644
index 000000000..fbd142362
--- /dev/null
+++ b/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/Models/TestResultsExcelModel.cs
@@ -0,0 +1,123 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace Tango.MachineStudio.ThreadExtensions.Models
+{
+    public class TestResultsExcelModel
+    {
+        public String Thread_name_test_results { get; set; }
+        public String Machine_number { get; set; }
+        public String Test_results_name__tab { get; set; }
+
+        public int Dryer_temp { get; set; }
+        public int Dryer_flow { get; set; }
+        public int Tunnel_temp { get; set; }
+        public int Tunnel_flow { get; set; }
+
+        public String Tension_in_head { get; set; }
+        public String Tension_after_dryer { get; set; }
+        public String Tension_in_winder { get; set; }
+        public String BTSR { get; set; }
+        public String Puller_tension { get; set; }
+        public String Winder_tension { get; set; }
+        
+        public double Rubbing_K_100___DE { get; set; }
+        public double Rubbing_K_100___GS { get; set; }
+        public double Rubbing_K_200___DE { get; set; }
+        public double Rubbing_K_200___GS { get; set; }
+        public double Rubbing_C_100___DE { get; set; }
+        public double Rubbing_C_100___GS { get; set; }
+        public double Rubbing_C_200___DE { get; set; }
+        public double Rubbing_C_200___GS { get; set; }
+        public double Rubbing_Y_100___DE { get; set; }
+        public double Rubbing_Y_100___GS { get; set; }
+        public double Rubbing_Y_200___DE { get; set; }
+        public double Rubbing_Y_200___GS { get; set; }
+        public double Rubbing_M_100___DE { get; set; }
+        public double Rubbing_M_100___GS { get; set; }
+        public double Rubbing_M_200___DE { get; set; }
+        public double Rubbing_M_200___GS { get; set; }
+
+        public String Color_REF { get; set; }
+        public double Load__N_REF { get; set; }
+        public double STDEV_REF { get; set; }
+        public double REF_Strain { get; set; }
+        public double STDEV_Strain_REF { get; set; }
+
+        public String Color_100_C { get; set; }
+        public int C_color_100_C { get; set; }
+        public double Load_N_100_C { get; set; }
+        public double STDEV_100_C { get; set; }
+        public double Change_100_C { get; set; }
+        public double Strain_100_C { get; set; }
+        public double STDEV_100_C_2 { get; set; }
+        public double Change_100_C_2 { get; set; }
+
+        public String Color_100_K { get; set; }
+        public int C_color_100_K { get; set; }
+        public double Load__N_100_K { get; set; }
+        public double STDEV_100_K { get; set; }
+        public double Change__100_K { get; set; }
+        public double Strain_100_K { get; set; }
+        public double STDEV_100_K_2 { get; set; }
+        public double Change_100_K_2 { get; set; }
+
+        public String Color_200_C { get; set; }
+        public int C_color_200_C { get; set; }
+        public double Load__N_200_C { get; set; }
+        public double STDEV_200_C { get; set; }
+        public double Change_200_C { get; set; }
+        public double Strain_200_C { get; set; }
+        public double STDEV_200_C_2 { get; set; }
+        public double Change_200_C_2 { get; set; }
+
+        public String Color_200_K { get; set; }
+        public int C_color_200_K { get; set; }
+        public double Load__N_200_K { get; set; }
+        public double STDEV_200_K { get; set; }
+        public double Change_200_K { get; set; }
+        public double Strain_200_K { get; set; }
+        public double STDEV_200_K_2 { get; set; }
+        public double Change_200_K_2 { get; set; }
+        
+        public String Uniformity_Zone_1 { get; set; }
+        public String Uniformity_Zone_2 { get; set; }
+        
+        public double COF_REF { get; set; }
+        public double CV_REF { get; set; }
+        public double COF_Black { get; set; }
+        public double CV_Black { get; set; }
+        //for twine inly
+        public double lub_amount { get; set; }
+        
+        public String Comments { get; set; }
+        public String Conclusion { get; set; }
+
+        public TestResultsExcelModel()
+        {
+            Comments = Conclusion = "";
+            Color_100_C = "Cyan";
+            C_color_100_C = 100;
+            Load__N_100_K = STDEV_100_K = Change__100_K = Strain_100_K = STDEV_100_K_2 = Change_100_K_2 = 0.0;
+
+            Color_200_C = "Cyan";
+            C_color_200_C = 200;
+            Load__N_200_C = STDEV_200_C = Change_200_C = Strain_200_C = STDEV_200_C_2 = Change_200_C_2 = 0.0;
+
+            Color_100_K = "Black";
+            C_color_100_K = 100;
+            Load__N_100_K = STDEV_100_K = Change__100_K = Strain_100_K = STDEV_100_K_2 = Change_100_K_2 = 0.0;
+
+            Color_200_K = "Black";
+            C_color_200_K = 200;
+            Load__N_200_K = STDEV_200_K = Change_200_K = Strain_200_K = STDEV_200_K_2 = Change_200_K_2 = 0.0;
+
+            Color_REF = "REF";
+            Load__N_REF = STDEV_REF = REF_Strain = STDEV_Strain_REF = 0;
+        }
+
+    }
+}
diff --git a/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/Models/ThreadCharacteristicsExelModel.cs b/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/Models/ThreadCharacteristicsExelModel.cs
index dc205b7f5..1f894d70b 100644
--- a/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/Models/ThreadCharacteristicsExelModel.cs
+++ b/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/Models/ThreadCharacteristicsExelModel.cs
@@ -6,7 +6,7 @@ using System.Threading.Tasks;
 
 namespace Tango.MachineStudio.ThreadExtensions.Models
 {
-    public class ThreadCharacteristicsExelModel
+    public class ThreadCharacteristicsExcelModel
     {
         public String ThreadName { get; set; }
         public String Manufacturer { get; set; }
@@ -33,14 +33,5 @@ namespace Tango.MachineStudio.ThreadExtensions.Models
         public String FiberCount  { get; set; }
         public int Twist { get; set; }
         public String TwistDirection { get; set; }
-
-        //public Color R_Color { get; set; }
-        //public String R_Name { get; set; }
-        //public String R_Media { get; set; }
-        //public double R_Cyan { get; set; }
-        //public double R_Magenta { get; set; }
-        //public double R_Yellow { get; set; }
-        //public double R_Black { get; set; }
-        //public int R_Region { get; set; }
     }
 }