Color calibration tab - Apply to RML , export data to excel file.

Related Work Items: #6482

9 files changed, 345 insertions, 33 deletions

diff --git a/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.MachineDesigner/Views/ColorCalibrationView.xaml b/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.MachineDesigner/Views/ColorCalibrationView.xaml
index 0d8acbc53..e853e2075 100644
--- a/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.MachineDesigner/Views/ColorCalibrationView.xaml
+++ b/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.MachineDesigner/Views/ColorCalibrationView.xaml
@@ -39,7 +39,20 @@
                     <commonControls:MachineView Width="500" Margin="0 40 0 0" DataContext="{Binding Machine}" />
                     <StackPanel Margin="40 40">
                         <TextBlock FontSize="16">MEDIA</TextBlock>
-                        <ComboBox ItemsSource="{Binding Rmls}" SelectedItem="{Binding SelectedRML}" FontSize="16" IsEnabled="{Binding Machine,Converter={StaticResource NullObjectToBooleanConverter}}" Background="Transparent" Style="{StaticResource TransparentComboBoxStyle}" >
+
+                        <controls:SearchComboBox ItemsSource="{Binding Rmls}" SelectedItem="{Binding SelectedRML}" FontSize="16" IsEnabled="{Binding Machine,Converter={StaticResource NullObjectToBooleanConverter}}" HorizontalContentAlignment="Stretch" SearchProperty="Name" >
+
+                            <ComboBox.ItemTemplate>
+                                <DataTemplate>
+                                    <StackPanel>
+                                        <TextBlock Text="{Binding Name}" FontWeight="Bold" FontStyle="Italic" Foreground="{StaticResource MainWindow.Foreground}"></TextBlock>
+                                        <TextBlock FontSize="11" Text="{Binding Manufacturer}" Foreground="{StaticResource GrayBrush}"></TextBlock>
+                                    </StackPanel>
+                                </DataTemplate>
+                            </ComboBox.ItemTemplate>
+                        </controls:SearchComboBox>
+
+                        <!--<ComboBox ItemsSource="{Binding Rmls}" SelectedItem="{Binding SelectedRML}" FontSize="16" IsEnabled="{Binding Machine,Converter={StaticResource NullObjectToBooleanConverter}}" Background="Transparent" Style="{StaticResource TransparentComboBoxStyle}" >
 
                             <ComboBox.ItemTemplate>
                                 <DataTemplate>
@@ -49,7 +62,7 @@
                                     </StackPanel>
                                 </DataTemplate>
                             </ComboBox.ItemTemplate>
-                        </ComboBox>
+                        </ComboBox>-->
 
 
                         <TextBlock FontSize="16" Margin="0 40 0 0">LIQUID FACTORS</TextBlock>
diff --git a/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/Excel/ColorCalibrationDataExcel.cs b/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/Excel/ColorCalibrationDataExcel.cs
new file mode 100644
index 000000000..0a5caa0b7
--- /dev/null
+++ b/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/Excel/ColorCalibrationDataExcel.cs
@@ -0,0 +1,73 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace Tango.MachineStudio.ThreadExtensions.Excel
+{
+    //Property Names should be the same as define names in excel file. Each define name should be unique by worksheet.
+    public class CyanColorCalibrationDataExcel
+    {
+        public double Ink_C { get; set; }
+        public double L_C { get; set; }
+        public double A_C { get; set; }
+        public double B_C { get; set; }
+        public double X_C { get; set; }
+        public double Y_C { get; set; }
+
+        public CyanColorCalibrationDataExcel()
+        {
+            Ink_C= 0;
+            L_C = A_C = B_C = X_C = Y_C = 0;
+        }
+    }
+
+    public class MagentaColorCalibrationDataExcel
+    {
+        public double Ink_M { get; set; }
+        public double L_M { get; set; }
+        public double A_M { get; set; }
+        public double B_M { get; set; }
+        public double X_M { get; set; }
+        public double Y_M { get; set; }
+
+        public MagentaColorCalibrationDataExcel()
+        {
+            Ink_M = 0;
+            L_M = A_M = B_M = X_M = Y_M = 0;
+        }
+    }
+
+    public class YellowColorCalibrationDataExcel
+    {
+        public double Ink_Y { get; set; }
+        public double L_Y { get; set; }
+        public double A_Y { get; set; }
+        public double B_Y { get; set; }
+        public double X_Y { get; set; }
+        public double Y_Y { get; set; }
+
+        public YellowColorCalibrationDataExcel()
+        {
+            Ink_Y = 0;
+            L_Y = A_Y = B_Y = X_Y = Y_Y = 0;
+        }
+    }
+
+    public class BlackColorCalibrationDataExcel
+    {
+        public double Ink_B { get; set; }
+        public double L_B { get; set; }
+        public double A_B { get; set; }
+        public double B_B { get; set; }
+        public double X_B { get; set; }
+        public double Y_B { get; set; }
+
+        public BlackColorCalibrationDataExcel()
+        {
+            Ink_B = 0;
+            L_B = A_B = B_B = X_B = Y_B = 0;
+        }
+    }
+}
diff --git a/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/Tango.MachineStudio.ThreadExtensions.csproj b/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/Tango.MachineStudio.ThreadExtensions.csproj
index ae05ca02c..e7724a473 100644
--- a/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/Tango.MachineStudio.ThreadExtensions.csproj
+++ b/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/Tango.MachineStudio.ThreadExtensions.csproj
@@ -104,6 +104,7 @@
     <Compile Include="Converters\ColorWithPercentToBrushConverter.cs" />
     <Compile Include="Converters\ComboBoxVisibleConverter.cs" />
     <Compile Include="Converters\NumericFieldConverter.cs" />
+    <Compile Include="Excel\ColorCalibrationDataExcel.cs" />
     <Compile Include="Excel\ColorDataExcelModel.cs" />
     <Compile Include="Excel\ColorParametrsExcelModel.cs" />
     <Compile Include="Models\CalibrationPlotModel.cs" />
@@ -234,6 +235,7 @@
       <LastGenOutput>Settings.Designer.cs</LastGenOutput>
     </None>
     <EmbeddedResource Include="Templates\ExportRMLTemplate.xlsx" />
+    <EmbeddedResource Include="Templates\ColorDataFileTemplate.xlsx" />
   </ItemGroup>
   <ItemGroup>
     <Resource Include="Images\threads.png" />
diff --git a/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/Templates/ColorDataFileTemplate.xlsx b/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/Templates/ColorDataFileTemplate.xlsx
new file mode 100644
index 000000000..968ae39b7
--- /dev/null
+++ b/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/Templates/ColorDataFileTemplate.xlsx
diff --git a/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/ViewModels/CalibrationDataVM.cs b/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/ViewModels/CalibrationDataVM.cs
index b8fab210c..493d8015a 100644
--- a/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/ViewModels/CalibrationDataVM.cs
+++ b/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/ViewModels/CalibrationDataVM.cs
@@ -12,6 +12,12 @@ namespace Tango.MachineStudio.ThreadExtensions.ViewModels
 {
     public class CalibrationDataPointVM : ExtendedObject
     {
+        public double Ink { get; set; }
+        public double L { get; set; }
+        public double A { get; set; }
+        public double B { get; set; }
+
+
         private double _x;
 
         public double X
diff --git a/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/ViewModels/ColorCalibrationTabVM.cs b/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/ViewModels/ColorCalibrationTabVM.cs
index a2a119e29..b259c4ebb 100644
--- a/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/ViewModels/ColorCalibrationTabVM.cs
+++ b/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/ViewModels/ColorCalibrationTabVM.cs
@@ -154,7 +154,10 @@ namespace Tango.MachineStudio.ThreadExtensions.ViewModels
                 var index = 1;
                 foreach (var nw in items.Zip(calibrationPoints, Tuple.Create))
                 {
-                    CyanCalibrationData.CalibrationPoints.Add(new CalibrationDataPointVM() { Index = index++, X = nw.Item1.InkPercentage, Y = nw.Item2 });
+                    CyanCalibrationData.CalibrationPoints.Add(new CalibrationDataPointVM()
+                    { Index = index++, X = nw.Item1.InkPercentage, Y = nw.Item2,
+                    Ink = nw.Item1.InkPercentage, L = nw.Item1.L, A = nw.Item1.A, B = nw.Item1.B
+                    });
                 }
 
                 SynchronizedObservableCollection<RmlExtensionColorCalibrationsTestsLiquidData> data = RmlExtensionColorCalibrationsTest.RmlExtensionColorCalibrationsTestsLiquidData;
@@ -189,7 +192,13 @@ namespace Tango.MachineStudio.ThreadExtensions.ViewModels
                 var index = 1;
                 foreach (var nw in items.Zip(calibrationPoints, Tuple.Create))
                 {
-                    MagentaCalibrationData.CalibrationPoints.Add(new CalibrationDataPointVM() { Index = index++, X = nw.Item1.InkPercentage, Y = nw.Item2 });
+                    MagentaCalibrationData.CalibrationPoints.Add(new CalibrationDataPointVM()
+                    { Index = index++, X = nw.Item1.InkPercentage, Y = nw.Item2,
+                        Ink = nw.Item1.InkPercentage,
+                        L = nw.Item1.L,
+                        A = nw.Item1.A,
+                        B = nw.Item1.B
+                    });
                 }
                 
                 SynchronizedObservableCollection<RmlExtensionColorCalibrationsTestsLiquidData> data = RmlExtensionColorCalibrationsTest.RmlExtensionColorCalibrationsTestsLiquidData;
@@ -223,7 +232,13 @@ namespace Tango.MachineStudio.ThreadExtensions.ViewModels
                 var index = 1;
                 foreach (var nw in items.Zip(calibrationPoints, Tuple.Create))
                 {
-                    YellowCalibrationData.CalibrationPoints.Add(new CalibrationDataPointVM() { Index = index++, X = nw.Item1.InkPercentage, Y = nw.Item2 });
+                    YellowCalibrationData.CalibrationPoints.Add(new CalibrationDataPointVM()
+                    { Index = index++, X = nw.Item1.InkPercentage, Y = nw.Item2,
+                        Ink = nw.Item1.InkPercentage,
+                        L = nw.Item1.L,
+                        A = nw.Item1.A,
+                        B = nw.Item1.B
+                    });
                 }
                
                 SynchronizedObservableCollection<RmlExtensionColorCalibrationsTestsLiquidData> data = RmlExtensionColorCalibrationsTest.RmlExtensionColorCalibrationsTestsLiquidData;
@@ -257,7 +272,13 @@ namespace Tango.MachineStudio.ThreadExtensions.ViewModels
                 var index = 1;
                 foreach (var nw in items.Zip(calibrationPoints, Tuple.Create))
                 {
-                    BlackCalibrationData.CalibrationPoints.Add(new CalibrationDataPointVM() { Index = index++, X = nw.Item1.InkPercentage, Y = nw.Item2 });
+                    BlackCalibrationData.CalibrationPoints.Add(new CalibrationDataPointVM()
+                    { Index = index++, X = nw.Item1.InkPercentage, Y = nw.Item2,
+                        Ink = nw.Item1.InkPercentage,
+                        L = nw.Item1.L,
+                        A = nw.Item1.A,
+                        B = nw.Item1.B
+                    });
                 }
                 
                 SynchronizedObservableCollection<RmlExtensionColorCalibrationsTestsLiquidData> data = RmlExtensionColorCalibrationsTest.RmlExtensionColorCalibrationsTestsLiquidData;
@@ -377,7 +398,8 @@ namespace Tango.MachineStudio.ThreadExtensions.ViewModels
             calibrationTable.CalibrationPoints.Clear();
             var index = 1;
             points.ForEach(x => {
-                calibrationTable.CalibrationPoints.Add(new CalibrationDataPointVM() { Index = index++, X = x.Ink, Y = x.CalculatedPoint });
+                calibrationTable.CalibrationPoints.Add(new CalibrationDataPointVM() { Index = index++, X = System.Math.Round(x.Ink,2), Y = System.Math.Round(x.CalculatedPoint, 2),
+                Ink = System.Math.Round(x.Ink,2), L = System.Math.Round(x.L,2), A = System.Math.Round(x.A, 2), B = System.Math.Round(x.B,2)});
                 calibrationPoints.Add(x.CalculatedPoint);
             });
             UpdatePlots(plot, items, calibrationPoints);
@@ -408,8 +430,15 @@ namespace Tango.MachineStudio.ThreadExtensions.ViewModels
                     {
                         _notification.ShowError("Linearizion process failed. " + result.ErrorMessage);
                     });
+                    for( int i =0; i<  result.InkPercentage.Count; i++)
+                    {
+                        result.InkPercentage[i] = 0.0;
+                    }
+                }
+                for (int i = 0; i < result.InkPercentage.Count; i++)
+                {
+                    result.InkPercentage[i] = Math.Round(result.InkPercentage[i], 2);
                 }
-
                 return result.InkPercentage.ToList();
             }
             catch (Exception ex)
@@ -420,5 +449,7 @@ namespace Tango.MachineStudio.ThreadExtensions.ViewModels
         }
 
         #endregion
+
+        
     }
 }
diff --git a/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/ViewModels/ColorCalibrationViewVM.cs b/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/ViewModels/ColorCalibrationViewVM.cs
index 3f4d8a415..2144d05f5 100644
--- a/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/ViewModels/ColorCalibrationViewVM.cs
+++ b/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/ViewModels/ColorCalibrationViewVM.cs
@@ -21,6 +21,10 @@ using Tango.Logging;
 using Tango.BL.Enumerations;
 using Tango.PMR.ColorLab;
 using Tango.BL.Calibration;
+using System.IO;
+using Tango.Core.Helpers;
+using Tango.Documents;
+using Tango.MachineStudio.ThreadExtensions.Excel;
 
 
 namespace Tango.MachineStudio.ThreadExtensions.ViewModels
@@ -154,7 +158,8 @@ namespace Tango.MachineStudio.ThreadExtensions.ViewModels
         public RelayCommand CreateColorDataImportExcelTemplateCommand { get; set; }
         public RelayCommand ApplyToRMLCommand { get; set; }
         public RelayCommand ApplyToMachineCalibrationCommand { get; set; }
-        
+        public RelayCommand ExportColorCalibrationToExcelCommand { get; set; }
+
         public RelayCommand SaveCommand { get; set; }
         
         public RelayCommand AddTabCommand { get; set; }
@@ -174,7 +179,8 @@ namespace Tango.MachineStudio.ThreadExtensions.ViewModels
             ApplyToRMLCommand = new RelayCommand(ApplyToRML);
             ApplyToMachineCalibrationCommand = new RelayCommand(ApplyToMachineCalibration);
             SaveCommand = new RelayCommand(Save, () => IsFree);
-            
+            ExportColorCalibrationToExcelCommand = new RelayCommand(ExportColorCalibrationToExcel, () => IsFree);
+
             AddTabCommand = new RelayCommand(() => AddNewTab());
             RemoveTabCommand = new RelayCommand<ColorCalibrationTabVM>(RemoveTab);
             RenameTabCommand = new RelayCommand(RenameTab);
@@ -221,22 +227,44 @@ namespace Tango.MachineStudio.ThreadExtensions.ViewModels
         {
             if(SelectedTab != null && ActiveRML != null)
             {
-                var liquidTypesRmls = ActiveRML.LiquidTypesRmls;
-                var calibrationDataVM = SelectedTab.CyanCalibrationData;
-                ApplayCalibrationDataToliquidTypesRml(liquidTypesRmls, LiquidTypes.Cyan, SelectedTab.CyanCalibrationData);
-                ApplayCalibrationDataToliquidTypesRml(liquidTypesRmls, LiquidTypes.Magenta, SelectedTab.MagentaCalibrationData);
-                ApplayCalibrationDataToliquidTypesRml(liquidTypesRmls, LiquidTypes.Yellow, SelectedTab.YellowCalibrationData);
-                ApplayCalibrationDataToliquidTypesRml(liquidTypesRmls, LiquidTypes.Black, SelectedTab.BlackCalibrationData);
-                Save();
+                {
+                    try
+                    {
+                        IsFree = false;
+                        DateTime lastUpdated = DateTime.UtcNow;
+                        var rml =  new RmlBuilder(_active_context).Set(ActiveRML.Guid).WithLiquidFactors().Build();
+                        if (rml != null)
+                        {
+                            var liquidTypesRmls = rml.LiquidTypesRmls;
+                            var calibrationDataVM = SelectedTab.CyanCalibrationData;
+                            ApplayCalibrationDataToliquidTypesRml(liquidTypesRmls, LiquidTypes.Cyan, SelectedTab.CyanCalibrationData);
+                            ApplayCalibrationDataToliquidTypesRml(liquidTypesRmls, LiquidTypes.Magenta, SelectedTab.MagentaCalibrationData);
+                            ApplayCalibrationDataToliquidTypesRml(liquidTypesRmls, LiquidTypes.Yellow, SelectedTab.YellowCalibrationData);
+                            ApplayCalibrationDataToliquidTypesRml(liquidTypesRmls, LiquidTypes.Black, SelectedTab.BlackCalibrationData);
+                            _active_context.SaveChanges();
+                        }
+                    }
+                    catch (Exception ex)
+                    {
+                        LogManager.Log(ex, "Could not apply to RML color calibrations.");
+                        _notification.ShowError($"An error occurred while trying to apply to RML color calibrations.\n{ex.Message}");
+                    }
+                    finally
+                    {
+                        IsFree = true;
+                    }
+                }
             }
         }
 
         private void ApplayCalibrationDataToliquidTypesRml(SynchronizedObservableCollection<LiquidTypesRml> liquidTypesRmls, LiquidTypes type, CalibrationDataVM calibrationDataVM)
         {
-            if (calibrationDataVM.CalibrationPoints.Count == 0)
+            if (calibrationDataVM.CalibrationPoints.Count == 0 || liquidTypesRmls.Count == 0)
                 return;
 
             var liquidTypeRml = liquidTypesRmls.SingleOrDefault(x => x.LiquidType.Type == type);
+            if(liquidTypeRml == null)
+                return;
             CalibrationData calData = new CalibrationData();
             calData.LiquidType = (PMR.ColorLab.LiquidType)liquidTypeRml.LiquidType.Code;
             calData.CalibrationPoints.Clear();
@@ -250,19 +278,36 @@ namespace Tango.MachineStudio.ThreadExtensions.ViewModels
         {
             if (SelectedTab != null)
             {
-                var idsPack = Machine.IdsPacks.
+                try
+                {
+                    IsFree = false;
+                    DateTime lastUpdated = DateTime.UtcNow;
+                    var machine = new MachineBuilder(_active_context).Set(Machine.Guid).WithConfiguration().WithCats().Build();
+                    var idsPack = machine.Configuration.IdsPacks.Where(z => !z.IsEmpty).
                     Where(x => ActiveRML.LiquidTypesRmls.ToList().Exists(y => x.LiquidType != null && y.LiquidType.Guid == x.LiquidType.Guid))
                     .OrderBy(x => x.PackIndex).ToList();
 
-                ApplayCalibrationDataToToMachineRml(idsPack, LiquidTypes.Cyan, SelectedTab.CyanCalibrationData);
-                ApplayCalibrationDataToToMachineRml(idsPack, LiquidTypes.Magenta, SelectedTab.MagentaCalibrationData);
-                ApplayCalibrationDataToToMachineRml(idsPack, LiquidTypes.Yellow, SelectedTab.YellowCalibrationData);
-                ApplayCalibrationDataToToMachineRml(idsPack, LiquidTypes.Black, SelectedTab.BlackCalibrationData);
-                Save();
+                    var cats = machine.Cats.Where(x => x.RmlGuid == ActiveRML.Guid).ToList();
+
+                    ApplayCalibrationDataToToMachineRml(idsPack, LiquidTypes.Cyan, SelectedTab.CyanCalibrationData, cats);
+                    ApplayCalibrationDataToToMachineRml(idsPack, LiquidTypes.Magenta, SelectedTab.MagentaCalibrationData, cats);
+                    ApplayCalibrationDataToToMachineRml(idsPack, LiquidTypes.Yellow, SelectedTab.YellowCalibrationData, cats);
+                    ApplayCalibrationDataToToMachineRml(idsPack, LiquidTypes.Black, SelectedTab.BlackCalibrationData, cats);
+                    _active_context.SaveChanges();
+                }
+                catch (Exception ex)
+                {
+                    LogManager.Log(ex, "Could not update color calibrations.");
+                    _notification.ShowError($"An error occurred while trying to save color calibrations.\n{ex.Message}");
+                }
+                finally
+                {
+                    IsFree = true;
+                }
             }
         }
 
-        private void ApplayCalibrationDataToToMachineRml(List<IdsPack> idsPacks, LiquidTypes type, CalibrationDataVM calibrationDataVM)
+        private void ApplayCalibrationDataToToMachineRml(List<IdsPack> idsPacks, LiquidTypes type, CalibrationDataVM calibrationDataVM, List< Cat> cats)
         {
             if (calibrationDataVM.CalibrationPoints.Count == 0)
                 return;
@@ -271,19 +316,19 @@ namespace Tango.MachineStudio.ThreadExtensions.ViewModels
 
             if (idsPack != null)
             {
-                var cat = idsPack.LiquidType.Cats.FirstOrDefault(x => x.MachineGuid == Machine.Guid && x.RmlGuid == ActiveRML.Guid); ;
-
+                //cat.RmlGuid = ActiveRML.Guid;
+                // cat.MachineGuid = Machine.Guid;
+                var cat = cats.FirstOrDefault( x=> x.LiquidTypeGuid == idsPack.LiquidTypeGuid);
                 if (cat == null)
                 {
                     cat = new Cat();
                     cat.Name = "untitled";
+                    cat.RmlGuid = ActiveRML.Guid;
+                    cat.MachineGuid = Machine.Guid;
+                    cat.LiquidTypeGuid = idsPack.LiquidTypeGuid;
                     _active_context.Cats.Add(cat);
                 }
-
-                cat.RmlGuid = ActiveRML.Guid;
-                cat.MachineGuid = Machine.Guid;
-                cat.LiquidType = idsPack.LiquidType;
-
+                
                 CalibrationData calData = new CalibrationData();
                 calData.LiquidType = (PMR.ColorLab.LiquidType)idsPack.LiquidType.Code;
                 calData.CalibrationPoints.AddRange(calibrationDataVM.CalibrationPoints.Select(x => new CalibrationPoint() { X = x.X, Y = x.Y }));
@@ -525,6 +570,139 @@ namespace Tango.MachineStudio.ThreadExtensions.ViewModels
         }
 
         #endregion
+        #region Export / Import Excel
 
+        public void ExportColorCalibrationToExcel()
+        {
+            SaveFileDialog dlg = new SaveFileDialog();
+            dlg.Filter = "Excel Documents|*.xlsx";
+            if (dlg.ShowDialog().Value)
+            {
+                using (_notification.PushTaskItem("Exporting Color Calibration to file..."))
+                {
+                    Task.Factory.StartNew(() =>
+                    {
+                        try
+                        {
+                            IsFree = false;
+
+                            Stream stream = null;
+                            bool dispose = false;
+                            String file = AssemblyHelper.GetCurrentAssemblyFolder() + "\\Templates\\ColorDataFileTemplate.xlsx";
+
+                            if (File.Exists(file))
+                            {
+                                stream = File.OpenRead(file);
+                                dispose = true;
+                            }
+                            else
+                            {
+                                stream = EmbeddedResourceHelper.GetEmbeddedResourceStream("Tango.MachineStudio.ThreadExtensions.Templates.ColorDataFileTemplate.xlsx");
+                            }
+
+                            byte[] data = new byte[stream.Length];
+                            stream.Read(data, 0, data.Length);
+                            File.WriteAllBytes(dlg.FileName, data);
+
+                            if (dispose)
+                            {
+                                stream.Dispose();
+                            }
+
+                            ExcelWriter writer = new ExcelWriter(dlg.FileName);
+                            //ActiveRMLExtension = await new RmlExtensionsBuilder(_active_context)
+                            //                .Set(guid)
+                            //                .WithUser()
+                            //                .BuildAsync();
+
+                            //ActiveRML = new RmlBuilder(_active_context)
+                            //    .Set(SelectedRMLExtension.RMLGuid)
+                            //    .Build();
+
+                            List<CyanColorCalibrationDataExcel> cyanDataExelModels = new List<CyanColorCalibrationDataExcel>();
+                            
+                            foreach(var value in SelectedTab.CyanCalibrationData.CalibrationPoints)
+                            {
+                                CyanColorCalibrationDataExcel cyan_model = new CyanColorCalibrationDataExcel();
+                                cyan_model.Ink_C = value.Ink;
+                                cyan_model.L_C = value.L;
+                                cyan_model.A_C = value.A;
+                                cyan_model.B_C = value.B;
+                                cyan_model.X_C = value.X;
+                                cyan_model.Y_C = value.Y;
+
+                                cyanDataExelModels.Add(cyan_model);
+                            }
+                            
+                            writer.WriteData(cyanDataExelModels, "Cyan", 1);
+
+                            List<MagentaColorCalibrationDataExcel> magentaDataExelModels = new List<MagentaColorCalibrationDataExcel>();
+                            foreach (var value in SelectedTab.MagentaCalibrationData.CalibrationPoints)
+                            {
+                                MagentaColorCalibrationDataExcel model = new MagentaColorCalibrationDataExcel();
+                                model.Ink_M = value.Ink;
+                                model.L_M = value.L;
+                                model.A_M = value.A;
+                                model.B_M = value.B;
+                                model.X_M = value.X;
+                                model.Y_M = value.Y;
+                                magentaDataExelModels.Add(model);
+                            }
+                            writer.WriteData(magentaDataExelModels, "Magenta", 1);
+
+                            List<YellowColorCalibrationDataExcel> yellowDataExelModels = new List<YellowColorCalibrationDataExcel>();
+                            foreach (var value in SelectedTab.YellowCalibrationData.CalibrationPoints)
+                            {
+                                YellowColorCalibrationDataExcel model = new YellowColorCalibrationDataExcel();
+                                model.Ink_Y = value.Ink;
+                                model.L_Y = value.L;
+                                model.A_Y = value.A;
+                                model.B_Y = value.B;
+                                model.X_Y = value.X;
+                                model.Y_Y = value.Y;
+                                yellowDataExelModels.Add(model);
+                            }
+                            writer.WriteData(yellowDataExelModels, "Yellow", 1);
+
+                            List<BlackColorCalibrationDataExcel> blackDataExelModels = new List<BlackColorCalibrationDataExcel>();
+                            foreach (var value in SelectedTab.BlackCalibrationData.CalibrationPoints)
+                            {
+                                BlackColorCalibrationDataExcel model = new BlackColorCalibrationDataExcel();
+                                model.Ink_B = value.Ink;
+                                model.L_B = value.L;
+                                model.A_B = value.A;
+                                model.B_B = value.B;
+                                model.X_B = value.X;
+                                model.Y_B = value.Y;
+                                blackDataExelModels.Add(model);
+                            }
+                            writer.WriteData(blackDataExelModels, "Black", 1);
+                            
+                            writer.Dispose();
+
+                            InvokeUI(() =>
+                            {
+                                _notification.ShowInfo("Color Calibration exported successfully.");
+                            });
+                        }
+                        catch (Exception ex)
+                        {
+                            LogManager.Log(ex, $"Error exporting Color Calibration to {dlg.FileName}");
+
+                            InvokeUI(() =>
+                            {
+                                _notification.ShowError($"An error occurred while trying to export the Color Calibration. Make sure the selected excel file is closed and data is valid.\n{ex.FlattenMessage()}");
+                            });
+                        }
+                        finally
+                        {
+                            IsFree = true;
+                        }
+                    });
+                }
+            }
+        }
+
+        #endregion
     }
 }
diff --git a/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/Views/ColorCalibrationView.xaml b/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/Views/ColorCalibrationView.xaml
index 407ad2e9f..04a2dace2 100644
--- a/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/Views/ColorCalibrationView.xaml
+++ b/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.ThreadExtensions/Views/ColorCalibrationView.xaml
@@ -168,6 +168,12 @@
                     <TextBlock VerticalAlignment="Center" Margin="10 0 0 0" Text="Apply to Machine"></TextBlock>
                 </StackPanel>
             </Button>
+            <Button DockPanel.Dock="Right" HorizontalAlignment="Right" Width="180" Height="36" Margin="0 0 26 0" VerticalAlignment="Center" Command="{Binding ExportColorCalibrationToExcelCommand}" ToolTip="Save color calibration in Excel">
+                <StackPanel Orientation="Horizontal">
+                    <materialDesign:PackIcon Kind="ContentSaveAll" Width="24" Height="24" />
+                    <TextBlock VerticalAlignment="Center" Margin="10 0 0 0" Text="Save to excel"></TextBlock>
+                </StackPanel>
+            </Button>
         </DockPanel>
         <Grid Grid.Row="1" >
             <Grid.RowDefinitions>
diff --git a/Software/Visual_Studio/PPC/Modules/Tango.PPC.JobsV2/Tango.PPC.JobsV2.csproj b/Software/Visual_Studio/PPC/Modules/Tango.PPC.JobsV2/Tango.PPC.JobsV2.csproj
index 898dac30b..a1bf13df7 100644
--- a/Software/Visual_Studio/PPC/Modules/Tango.PPC.JobsV2/Tango.PPC.JobsV2.csproj
+++ b/Software/Visual_Studio/PPC/Modules/Tango.PPC.JobsV2/Tango.PPC.JobsV2.csproj
@@ -663,10 +663,13 @@
   <ItemGroup>
     <Resource Include="Images\ColorSelection\arrow_top_bottom.png" />
   </ItemGroup>
+  <ItemGroup>
+    <Resource Include="Images\ColorSelection\Heart_disable.png" />
+  </ItemGroup>
   <Import Project="$(MSBuildToolsPath)\Microsoft.CSharp.targets" />
   <ProjectExtensions>
     <VisualStudio>
-      <UserProperties BuildVersion_AssemblyInfoFilename="Properties\AssemblyInfo.cs" BuildVersion_UpdateAssemblyVersion="True" BuildVersion_BuildVersioningStyle="None.None.Increment.TimeStamp" BuildVersion_UseGlobalSettings="False" BuildVersion_StartDate="2000/1/1" />
+      <UserProperties BuildVersion_StartDate="2000/1/1" BuildVersion_UseGlobalSettings="False" BuildVersion_BuildVersioningStyle="None.None.Increment.TimeStamp" BuildVersion_UpdateAssemblyVersion="True" BuildVersion_AssemblyInfoFilename="Properties\AssemblyInfo.cs" />
     </VisualStudio>
   </ProjectExtensions>
 </Project>
\ No newline at end of file