A couple of days ago I ran into a data processing problem, namely – Zennoposter – working with Excel tables obtained from an Excel table. The essence of the problem:
1. We take the data from the cell
2. We process
3. Check the cell on the right – if empty – go down to the line below, if there is data – go to it
4. And so on the cycle …
The complexity of the task was in processing the transition to a cell in an adjacent column.
After a few comments in the Zennoposter forum, one night and several experiments, the solution was found simple and elegant:
1. We receive a line and we transfer it to the list
2. We work with each line separately – they took, processed, deleted, and again the cycle.
due to which both the processing speed and the simplicity of the design as a whole have increased.