From 16b5ddedb1c89c0bdad56eab384f8e6cecaf2107 Mon Sep 17 00:00:00 2001
From: Sergey Chebotar <s.chebotar@gmail.com>
Date: Tue, 23 May 2023 07:07:16 +0300
Subject: Rename Magic to Guess

---
 RhSolutions.AddIn/AddIn/RhSolutionsAddIn.cs        |   4 +-
 RhSolutions.AddIn/Controllers/RibbonController.cs  |   2 +-
 RhSolutions.AddIn/Services/GuessReader.cs          | 190 +++++++++++++++++++++
 RhSolutions.AddIn/Services/MagicReader.cs          | 190 ---------------------
 RhSolutions.AddIn/Services/ReaderFactory.cs        |   2 +-
 RhSolutions.AddIn/Tools/GuessTool.cs               |  23 +++
 RhSolutions.AddIn/Tools/MagicTool.cs               |  23 ---
 RhSolutions.AddIn/Tools/ToolFactory.cs             |   2 +-
 RhSolutions.Tests/CanDoGuess.cs                    |  42 +++++
 RhSolutions.Tests/CanDoMagic.cs                    |  44 -----
 .../TestWorkbooks/TargetSpecificationGuess.xlsx    | Bin 0 -> 11597 bytes
 .../TestWorkbooks/TargetSpecificationMagic.xlsx    | Bin 11597 -> 0 bytes
 .../TestWorkbooks/TestSpecificationGuess.xlsx      | Bin 0 -> 11669 bytes
 .../TestWorkbooks/TestSpecificationMagic.xlsx      | Bin 11669 -> 0 bytes
 14 files changed, 260 insertions(+), 262 deletions(-)
 create mode 100644 RhSolutions.AddIn/Services/GuessReader.cs
 delete mode 100644 RhSolutions.AddIn/Services/MagicReader.cs
 create mode 100644 RhSolutions.AddIn/Tools/GuessTool.cs
 delete mode 100644 RhSolutions.AddIn/Tools/MagicTool.cs
 create mode 100644 RhSolutions.Tests/CanDoGuess.cs
 delete mode 100644 RhSolutions.Tests/CanDoMagic.cs
 create mode 100644 RhSolutions.Tests/TestWorkbooks/TargetSpecificationGuess.xlsx
 delete mode 100644 RhSolutions.Tests/TestWorkbooks/TargetSpecificationMagic.xlsx
 create mode 100644 RhSolutions.Tests/TestWorkbooks/TestSpecificationGuess.xlsx
 delete mode 100644 RhSolutions.Tests/TestWorkbooks/TestSpecificationMagic.xlsx

diff --git a/RhSolutions.AddIn/AddIn/RhSolutionsAddIn.cs b/RhSolutions.AddIn/AddIn/RhSolutionsAddIn.cs
index 0e3ef77..8f5fd71 100644
--- a/RhSolutions.AddIn/AddIn/RhSolutionsAddIn.cs
+++ b/RhSolutions.AddIn/AddIn/RhSolutionsAddIn.cs
@@ -36,8 +36,8 @@ public sealed class RhSolutionsAddIn : IExcelAddIn
         Services.AddSingleton<ReaderFactory>();
         Services.AddTransient<ExcelReader>()
             .AddTransient<IReader, ExcelReader>(s => s.GetService<ExcelReader>());
-        Services.AddTransient<MagicReader>()
-            .AddTransient<IReader, MagicReader>(s => s.GetService<MagicReader>());
+        Services.AddTransient<GuessReader>()
+            .AddTransient<IReader, GuessReader>(s => s.GetService<GuessReader>());
 
         Services.AddSingleton<ToolFactory>();
 
diff --git a/RhSolutions.AddIn/Controllers/RibbonController.cs b/RhSolutions.AddIn/Controllers/RibbonController.cs
index bc72081..c57a374 100644
--- a/RhSolutions.AddIn/Controllers/RibbonController.cs
+++ b/RhSolutions.AddIn/Controllers/RibbonController.cs
@@ -27,7 +27,7 @@ public class RibbonController : ExcelRibbon
                 <button id='export' getEnabled='GetExportEnabled' label='Экспорт в новый файл' size='normal' imageMso='PivotExportToExcel' onAction='OnToolPressed'/> 
                 <button id='convert' getEnabled='GetConvertEnabled' label='Актуализировать' size='normal' imageMso='FileUpdate' onAction='OnToolPressed'/> 
                 <button id='merge' label='Объединить' size='normal' imageMso='Copy' onAction='OnToolPressed'/> 
-                <button id='magicexport' label='Распознать и экспортировать' size='normal' imageMso='ExportExcel' onAction='OnToolPressed'/>
+                <button id='Guessexport' label='Распознать и экспортировать' size='normal' imageMso='ExportExcel' onAction='OnToolPressed'/>
                 <button id='dxfexport' getEnabled='GetDxfEnabled' label='Экспортировать в DXF' size='normal' imageMso='ExportExcel' onAction='OnToolPressed'/>
             </group>
             <group id='rausettings' getLabel='GetVersionLabel'>
diff --git a/RhSolutions.AddIn/Services/GuessReader.cs b/RhSolutions.AddIn/Services/GuessReader.cs
new file mode 100644
index 0000000..9cb4bde
--- /dev/null
+++ b/RhSolutions.AddIn/Services/GuessReader.cs
@@ -0,0 +1,190 @@
+using System.IO;
+
+namespace RhSolutions.Services;
+
+public class GuessReader : IReader
+{
+    private readonly Application _application;
+    private ProgressBar _progressBar;
+
+    public GuessReader(Application application)
+    {
+        _application = application;
+    }
+
+    public Dictionary<Product, double> ReadProducts(Range range)
+    {
+        _progressBar = new("Ищу колонки со значениями", range.Columns.Count);
+        int? productColumnIndex = null;
+        List<(int, double)> amountColumnIndeces = new();
+
+        for (int column = 1; column < range.Columns.Count + 1; column++)
+        {
+            _progressBar.Update();
+            if (productColumnIndex == null && IsProductColumn(range.Columns[column]))
+            {
+                productColumnIndex = column;
+            }
+            else if (IsAmountColumn(range.Columns[column], out double average))
+            {
+                amountColumnIndeces.Add((column, average));
+            }
+        }
+
+        if (productColumnIndex == null || amountColumnIndeces.Count == 0)
+        {
+            throw new ArgumentException("Колонка с артикулом или количеством не определена");
+        }
+
+        else if (amountColumnIndeces.Count == 1)
+        {
+            return GetDictionaryFromColumns(range.Columns[productColumnIndex],
+                range.Columns[amountColumnIndeces.First().Item1]);
+        }
+
+        else
+        {
+            int amountColumnIndex = amountColumnIndeces
+                .Where(i => i.Item2 < 30000 && i.Item2 > 0)
+                .OrderByDescending(i => i.Item2).First().Item1;
+            return GetDictionaryFromColumns(range.Columns[productColumnIndex],
+                range.Columns[amountColumnIndex]);
+        }
+    }
+
+    private bool IsProductColumn(Range column)
+    {
+        int successCounter = 0;
+        for (int row = 1; row < column.Rows.Count + 1; row++)
+        {
+            if (ProductSku.TryParse(column.Cells[row, 1].Value2.ToString(), out IEnumerable<ProductSku> skus))
+            {
+                successCounter++;
+            }
+
+            if (successCounter > 2)
+            {
+                return true;
+            }
+        }
+
+        return successCounter > 0;
+    }
+
+    private bool IsAmountColumn(Range column, out double average)
+    {
+        object[,] cells = column.Value2;
+        int successCounter = 0;
+        average = 0.0;
+
+        for (int row = 1; row < column.Rows.Count + 1; row++)
+        {
+            object currentCell = cells[row, 1];
+            if (currentCell == null)
+            {
+                continue;
+            }
+            double value = 0.0;
+
+            if (currentCell.GetType() == typeof(double))
+            {
+                value = (double)currentCell;
+            }
+            else if (currentCell.GetType() == typeof(string))
+            {
+                double.TryParse((string)currentCell, out value);
+            }
+
+            if (value != 0.0)
+            {
+                successCounter++;
+                average += value;
+            }
+        }
+        if (successCounter > 0)
+        {
+            average /= successCounter;
+        }
+
+        return successCounter > 0;
+    }
+
+    private Dictionary<Product, double> GetDictionaryFromColumns(Range productColumn, Range amountColumn)
+    {
+        Dictionary<Product, double> result = new();
+
+        for (int row = 1; row < productColumn.Rows.Count + 1; row++)
+        {
+            object[,] cells = amountColumn.Value2;
+            object currentCell = cells[row, 1];
+            double amountValue = 0.0;
+            if (ProductSku.TryParse(productColumn.Cells[row, 1].Value2.ToString(), out IEnumerable<ProductSku> skus) &&
+                currentCell != null)
+            {
+                Product p = new(skus.First())
+                {
+                    Name = "Распознанный артикул"
+                };
+
+                if (currentCell.GetType() == typeof(double))
+                {
+                    amountValue = (double)currentCell;
+                }
+                else if (currentCell.GetType() == typeof(string))
+                {
+                    double.TryParse((string)currentCell, out amountValue);
+                }
+
+                if (result.ContainsKey(p))
+                {
+                    result[p] += amountValue;
+                }
+                else
+                {
+                    result.Add(p, amountValue);
+                }
+            }
+        }
+        return result;
+    }
+
+    public List<(string, Dictionary<Product, double>)> ReadProducts(IEnumerable<Worksheet> worksheets)
+    {
+        List<(string, Dictionary<Product, double>)> result = new();
+        foreach (Worksheet worksheet in worksheets)
+        {
+            string wbName = Path.GetFileNameWithoutExtension(
+                worksheet.Parent.Name);
+            Range range = worksheet.UsedRange;
+            var productsDict = ReadProducts(range);
+            result.Add((wbName, productsDict));
+        }
+        return result;
+    }
+
+    public List<(string, Dictionary<Product, double>)> ReadProducts(string[] files)
+    {
+        _progressBar = new("Открываю исходные файлы...", files.Length);
+        List<Worksheet> worksheets = new();
+
+        _application.ScreenUpdating = false;
+        foreach (string file in files)
+        {
+            Workbook wb = _application.Workbooks.Open(file);
+            worksheets.Add(wb.ActiveSheet);
+            _progressBar.Update();
+        }
+        _application.ScreenUpdating = true;
+        var result = ReadProducts(worksheets);
+        foreach (var ws in worksheets)
+        {
+            ws.Parent.Close();
+        }
+        return result;
+    }
+
+    public void Dispose()
+    {
+        _progressBar?.Dispose();
+    }
+}
\ No newline at end of file
diff --git a/RhSolutions.AddIn/Services/MagicReader.cs b/RhSolutions.AddIn/Services/MagicReader.cs
deleted file mode 100644
index d0021cb..0000000
--- a/RhSolutions.AddIn/Services/MagicReader.cs
+++ /dev/null
@@ -1,190 +0,0 @@
-using System.IO;
-
-namespace RhSolutions.Services;
-
-public class MagicReader : IReader
-{
-    private readonly Application _application;
-    private ProgressBar _progressBar;
-
-    public MagicReader(Application application)
-    {
-        _application = application;
-    }
-
-    public Dictionary<Product, double> ReadProducts(Range range)
-    {
-        _progressBar = new("Ищу колонки со значениями", range.Columns.Count);
-        int? productColumnIndex = null;
-        List<(int, double)> amountColumnIndeces = new();
-
-        for (int column = 1; column < range.Columns.Count + 1; column++)
-        {
-            _progressBar.Update();
-            if (productColumnIndex == null && IsProductColumn(range.Columns[column]))
-            {
-                productColumnIndex = column;
-            }
-            else if (IsAmountColumn(range.Columns[column], out double average))
-            {
-                amountColumnIndeces.Add((column, average));
-            }
-        }
-
-        if (productColumnIndex == null || amountColumnIndeces.Count == 0)
-        {
-            throw new ArgumentException("Колонка с артикулом или количеством не определена");
-        }
-
-        else if (amountColumnIndeces.Count == 1)
-        {
-            return GetDictionaryFromColumns(range.Columns[productColumnIndex],
-                range.Columns[amountColumnIndeces.First().Item1]);
-        }
-
-        else
-        {
-            int amountColumnIndex = amountColumnIndeces
-                .Where(i => i.Item2 < 30000 && i.Item2 > 0)
-                .OrderByDescending(i => i.Item2).First().Item1;
-            return GetDictionaryFromColumns(range.Columns[productColumnIndex],
-                range.Columns[amountColumnIndex]);
-        }
-    }
-
-    private bool IsProductColumn(Range column)
-    {
-        int successCounter = 0;
-        for (int row = 1; row < column.Rows.Count + 1; row++)
-        {
-            if (ProductSku.TryParse(column.Cells[row, 1].Value2.ToString(), out IEnumerable<ProductSku> skus))
-            {
-                successCounter++;
-            }
-
-            if (successCounter > 2)
-            {
-                return true;
-            }
-        }
-
-        return successCounter > 0;
-    }
-
-    private bool IsAmountColumn(Range column, out double average)
-    {
-        object[,] cells = column.Value2;
-        int successCounter = 0;
-        average = 0.0;
-
-        for (int row = 1; row < column.Rows.Count + 1; row++)
-        {
-            object currentCell = cells[row, 1];
-            if (currentCell == null)
-            {
-                continue;
-            }
-            double value = 0.0;
-
-            if (currentCell.GetType() == typeof(double))
-            {
-                value = (double)currentCell;
-            }
-            else if (currentCell.GetType() == typeof(string))
-            {
-                double.TryParse((string)currentCell, out value);
-            }
-
-            if (value != 0.0)
-            {
-                successCounter++;
-                average += value;
-            }
-        }
-        if (successCounter > 0)
-        {
-            average /= successCounter;
-        }
-
-        return successCounter > 0;
-    }
-
-    private Dictionary<Product, double> GetDictionaryFromColumns(Range productColumn, Range amountColumn)
-    {
-        Dictionary<Product, double> result = new();
-
-        for (int row = 1; row < productColumn.Rows.Count + 1; row++)
-        {
-            object[,] cells = amountColumn.Value2;
-            object currentCell = cells[row, 1];
-            double amountValue = 0.0;
-            if (ProductSku.TryParse(productColumn.Cells[row, 1].Value2.ToString(), out IEnumerable<ProductSku> skus) &&
-                currentCell != null)
-            {
-                Product p = new(skus.First())
-                {
-                    Name = "Распознанный артикул"
-                };
-
-                if (currentCell.GetType() == typeof(double))
-                {
-                    amountValue = (double)currentCell;
-                }
-                else if (currentCell.GetType() == typeof(string))
-                {
-                    double.TryParse((string)currentCell, out amountValue);
-                }
-
-                if (result.ContainsKey(p))
-                {
-                    result[p] += amountValue;
-                }
-                else
-                {
-                    result.Add(p, amountValue);
-                }
-            }
-        }
-        return result;
-    }
-
-    public List<(string, Dictionary<Product, double>)> ReadProducts(IEnumerable<Worksheet> worksheets)
-    {
-        List<(string, Dictionary<Product, double>)> result = new();
-        foreach (Worksheet worksheet in worksheets)
-        {
-            string wbName = Path.GetFileNameWithoutExtension(
-                worksheet.Parent.Name);
-            Range range = worksheet.UsedRange;
-            var productsDict = ReadProducts(range);
-            result.Add((wbName, productsDict));
-        }
-        return result;
-    }
-
-    public List<(string, Dictionary<Product, double>)> ReadProducts(string[] files)
-    {
-        _progressBar = new("Открываю исходные файлы...", files.Length);
-        List<Worksheet> worksheets = new();
-
-        _application.ScreenUpdating = false;
-        foreach (string file in files)
-        {
-            Workbook wb = _application.Workbooks.Open(file);
-            worksheets.Add(wb.ActiveSheet);
-            _progressBar.Update();
-        }
-        _application.ScreenUpdating = true;
-        var result = ReadProducts(worksheets);
-        foreach (var ws in worksheets)
-        {
-            ws.Parent.Close();
-        }
-        return result;
-    }
-
-    public void Dispose()
-    {
-        _progressBar?.Dispose();
-    }
-}
\ No newline at end of file
diff --git a/RhSolutions.AddIn/Services/ReaderFactory.cs b/RhSolutions.AddIn/Services/ReaderFactory.cs
index d2a4b63..eea326d 100644
--- a/RhSolutions.AddIn/Services/ReaderFactory.cs
+++ b/RhSolutions.AddIn/Services/ReaderFactory.cs
@@ -13,7 +13,7 @@ public class ReaderFactory
     {
         return readerName switch
         {
-            "Magic" => (IReader)_serviceProvider.GetService(typeof(MagicReader)),
+            "Guess" => (IReader)_serviceProvider.GetService(typeof(GuessReader)),
             "Excel" => (IReader)_serviceProvider.GetService(typeof(ExcelReader)),
             _ => (IReader)_serviceProvider.GetService(typeof(ExcelReader))
         };
diff --git a/RhSolutions.AddIn/Tools/GuessTool.cs b/RhSolutions.AddIn/Tools/GuessTool.cs
new file mode 100644
index 0000000..00003c5
--- /dev/null
+++ b/RhSolutions.AddIn/Tools/GuessTool.cs
@@ -0,0 +1,23 @@
+#if !NET472
+using System.Runtime.Versioning;
+#endif
+
+namespace RhSolutions.Tools;
+
+internal class GuessTool : Tool
+{
+    public GuessTool(IServiceProvider provider) : base(provider)
+    {
+    }
+
+    public override void Execute()
+    {
+        Application app = RhSolutionsAddIn.Excel.Application;
+        Worksheet worksheet = app.ActiveWorkbook.ActiveSheet;
+        _reader = _readerFactory.GetReader("Guess");
+        var products = _reader.ReadProducts(new[] { worksheet });
+        _writer = _writerFactory.GetWriter("Excel");
+        _writer.WriteProducts(products);
+    }
+}
+
diff --git a/RhSolutions.AddIn/Tools/MagicTool.cs b/RhSolutions.AddIn/Tools/MagicTool.cs
deleted file mode 100644
index 551194f..0000000
--- a/RhSolutions.AddIn/Tools/MagicTool.cs
+++ /dev/null
@@ -1,23 +0,0 @@
-#if !NET472
-using System.Runtime.Versioning;
-#endif
-
-namespace RhSolutions.Tools;
-
-internal class MagicTool : Tool
-{
-    public MagicTool(IServiceProvider provider) : base(provider)
-    {
-    }
-
-    public override void Execute()
-    {
-        Application app = RhSolutionsAddIn.Excel.Application;
-        Worksheet worksheet = app.ActiveWorkbook.ActiveSheet;
-        _reader = _readerFactory.GetReader("Magic");
-        var products = _reader.ReadProducts(new[] { worksheet });
-        _writer = _writerFactory.GetWriter("Excel");
-        _writer.WriteProducts(products);
-    }
-}
-
diff --git a/RhSolutions.AddIn/Tools/ToolFactory.cs b/RhSolutions.AddIn/Tools/ToolFactory.cs
index 7b529c7..2169b03 100644
--- a/RhSolutions.AddIn/Tools/ToolFactory.cs
+++ b/RhSolutions.AddIn/Tools/ToolFactory.cs
@@ -10,7 +10,7 @@ internal class ToolFactory
             "convert" => new ConvertTool(RhSolutionsAddIn.ServiceProvider),
             "merge" => new MergeTool(RhSolutionsAddIn.ServiceProvider),
             "dxfexport" => new DxfTool(RhSolutionsAddIn.ServiceProvider),
-            "magicexport" => new MagicTool(RhSolutionsAddIn.ServiceProvider),            
+            "Guessexport" => new GuessTool(RhSolutionsAddIn.ServiceProvider),            
             _ => throw new Exception("Неизвестный инструмент"),
         };
         return tool;
diff --git a/RhSolutions.Tests/CanDoGuess.cs b/RhSolutions.Tests/CanDoGuess.cs
new file mode 100644
index 0000000..c801af7
--- /dev/null
+++ b/RhSolutions.Tests/CanDoGuess.cs
@@ -0,0 +1,42 @@
+using Microsoft.Extensions.DependencyInjection;
+using RhSolutions.AddIn;
+using System.IO;
+
+namespace RhSolutions.Tests;
+
+[ExcelTestSettings(OutOfProcess = true)]
+public class CanDoGuess : IDisposable
+{
+    private RhSolutionsAddIn _addIn;
+    private IReader _reader;
+
+    public CanDoGuess()
+    {
+        _addIn = new();
+        _addIn.AutoOpen();
+        _reader = new GuessReader(Util.Application);
+    }
+
+    [ExcelFact(Workbook = @"..\..\..\TestWorkbooks\TestSpecificationGuess.xlsx")]
+    public void CanWrite()
+    {
+        Worksheet sourceSheet = Util.Workbook.Worksheets[1];
+        RhSolutionsAddIn.Configuration.SetPriceListPath(Path.GetFullPath(@"..\..\..\TestWorkbooks\TargetSpecificationGuess.xlsx"));
+        var products = _reader.ReadProducts(new[] { sourceSheet });
+        var _writer = new ExcelWriter(Util.Application, RhSolutionsAddIn.Configuration);
+        _writer.WriteProducts(products);
+        Worksheet targetSheet = Util.Application.ActiveWindow.ActiveSheet;
+        var targetProducts = _reader.ReadProducts(new[] { targetSheet });
+
+        Assert.Equal("TestSpecificationGuess", products.First().Item1);
+        Assert.Equal("TargetSpecificationGuess", targetProducts.First().Item1);
+        Assert.Equal(products.First().Item2.Count(), targetProducts.First().Item2.Count());
+        Assert.Equal(products.First().Item2.Values.Sum(), targetProducts.First().Item2.Values.Sum());
+    }
+
+    public void Dispose()
+    {
+        _addIn.AutoClose();
+        Util.Application.ActiveWindow.Close(SaveChanges: false);
+    }
+}
diff --git a/RhSolutions.Tests/CanDoMagic.cs b/RhSolutions.Tests/CanDoMagic.cs
deleted file mode 100644
index d3a0bf9..0000000
--- a/RhSolutions.Tests/CanDoMagic.cs
+++ /dev/null
@@ -1,44 +0,0 @@
-using Microsoft.Extensions.DependencyInjection;
-using RhSolutions.AddIn;
-using System.IO;
-
-namespace RhSolutions.Tests;
-
-[ExcelTestSettings(OutOfProcess = true)]
-public class CanDoMagic : IDisposable
-{
-    private RhSolutionsAddIn _addIn;
-    //private ReaderFactory _readerFactory;
-    private IReader _reader;
-
-    public CanDoMagic()
-    {
-        _addIn = new();
-        _addIn.AutoOpen();
-        //_readerFactory = RhSolutionsAddIn.ServiceProvider.GetRequiredService<ReaderFactory>();
-        _reader = new MagicReader(Util.Application);
-    }
-
-    [ExcelFact(Workbook = @"..\..\..\TestWorkbooks\TestSpecificationMagic.xlsx")]
-    public void CanWrite()
-    {
-        Worksheet sourceSheet = Util.Workbook.Worksheets[1];
-        RhSolutionsAddIn.Configuration.SetPriceListPath(Path.GetFullPath(@"..\..\..\TestWorkbooks\TargetSpecificationMagic.xlsx"));
-        var products = _reader.ReadProducts(new[] { sourceSheet });
-        var _writer = new ExcelWriter(Util.Application, RhSolutionsAddIn.Configuration);
-        _writer.WriteProducts(products);
-        Worksheet targetSheet = Util.Application.ActiveWindow.ActiveSheet;
-        var targetProducts = _reader.ReadProducts(new[] { targetSheet });
-
-        Assert.Equal("TestSpecificationMagic", products.First().Item1);
-        Assert.Equal("TargetSpecificationMagic", targetProducts.First().Item1);
-        Assert.Equal(products.First().Item2.Count(), targetProducts.First().Item2.Count());
-        Assert.Equal(products.First().Item2.Values.Sum(), targetProducts.First().Item2.Values.Sum());
-    }
-
-    public void Dispose()
-    {
-        _addIn.AutoClose();
-        Util.Application.ActiveWindow.Close(SaveChanges: false);
-    }
-}
diff --git a/RhSolutions.Tests/TestWorkbooks/TargetSpecificationGuess.xlsx b/RhSolutions.Tests/TestWorkbooks/TargetSpecificationGuess.xlsx
new file mode 100644
index 0000000..e7bae5f
Binary files /dev/null and b/RhSolutions.Tests/TestWorkbooks/TargetSpecificationGuess.xlsx differ
diff --git a/RhSolutions.Tests/TestWorkbooks/TargetSpecificationMagic.xlsx b/RhSolutions.Tests/TestWorkbooks/TargetSpecificationMagic.xlsx
deleted file mode 100644
index e7bae5f..0000000
Binary files a/RhSolutions.Tests/TestWorkbooks/TargetSpecificationMagic.xlsx and /dev/null differ
diff --git a/RhSolutions.Tests/TestWorkbooks/TestSpecificationGuess.xlsx b/RhSolutions.Tests/TestWorkbooks/TestSpecificationGuess.xlsx
new file mode 100644
index 0000000..d268c3e
Binary files /dev/null and b/RhSolutions.Tests/TestWorkbooks/TestSpecificationGuess.xlsx differ
diff --git a/RhSolutions.Tests/TestWorkbooks/TestSpecificationMagic.xlsx b/RhSolutions.Tests/TestWorkbooks/TestSpecificationMagic.xlsx
deleted file mode 100644
index d268c3e..0000000
Binary files a/RhSolutions.Tests/TestWorkbooks/TestSpecificationMagic.xlsx and /dev/null differ
-- 
cgit v1.2.3