data reducing  using Excel

It may be necessary to reduce the amount of data, but keep errors low, before importing into the application.

One solution is using Excel function, for example, indirect,   INDIRECT("A"&ROW(C1)*100) ,=INDIRECT("B"&ROW(C1)*100) reduces the file by 100

Another solution is to use an algorithm line simplification. 

For Excel data there are implementations of the Ramer- Douglas- Peuker algorithm  in Visual Basic for Application (VBA)  [2], [3]. 

First, format as table, The code requires:.

1. A named range called "epsilon", 

2. An excel table on "Sheet1" named "Table1"

3. An excel table on "Sheet2" named "Table2"

https://pursuingideas.wordpress.com/2016/09/15/ramer-douglas-peucker-rdp-algorithm-in-excel-microsoft-visual-basic-vba/ One thought on “Ramer-Douglas-Peucker (RDP) Algorithm in Excel – Microsoft Visual Basic (VBA)”

https://github.com/niko86/RamerDouglasPeucker-ExcelVBA

For Ramer- Douglas- Peuker  implementation in VBA

1. https://github.com/niko86/RamerDouglasPeucker-ExcelVBA 

2. https://pursuingideas.wordpress.com/2016/09/15/ramer-douglas-peucker-rdp-algorithm-in-excel-microsoft-visual-basic-vba/

https://www.excelforum.com/excel-general/572411-reducing-data-in-a-worksheet.html