I have a protocol that works fine but it includes two transpose components to allow me to get my data how I want it. This works fine for small input files but I do have cases where the input files can be very large (10,000+ rows). In these cases the protocol can take hours to run due to the amount of data being transposed.
The protocol basically calculates the difference between 5 sequential lines and repeats for the entire range of data.
ie (A1-A2)+(A2-A3)+(A3-A4)+(A4-A5)
Transposing the input file and using an ithproperty(#i) Loop is an easy enough solution but creates a bottleneck with larger files.
I'm sure there will be an alternative or just a better way to script this. Any input would be very much appreciated.
Input file
| 1 | 2 | 3 | 4 | 5 |
| 23.490 | 32.905 | 42.547 | 44.323 | 44.886 |
| 23.557 | 32.996 | 42.797 | 44.641 | 45.087 |
| 23.617 | 33.083 | 42.825 | 44.857 | 45.349 |
| 23.686 | 33.197 | 43.411 | 44.931 | 45.206 |
| 23.747 | 33.231 | 43.555 | 44.981 | 45.199 |
| 23.800 | 33.327 | 43.668 | 45.053 | 45.204 |
| 23.922 | 33.518 | 43.889 | 45.199 | 45.258 |
| 24.006 | 33.531 | 44.001 | 45.260 | 45.292 |
| 24.169 | 33.766 | 44.096 | 45.315 | 45.340 |
| 24.213 | 33.887 | 44.289 | 45.393 | 45.443 |
