r2c | Recognition to Cognition Networks | Computer Vision library

I'm in the process of accelerating some data analysis code with GPU and am currently doing some profiling and comparisons between the numpy.fft library and cuFFT (using the skcuda.fft wrapper).

I'm certain I'm just missing something obvious about the FFT implementation in cuFFT, but I'm struggling to find what it is in the cuFFT documentation.

To setup the problem I create 500 ms of data sampled at 100 MS/s with a few spectral components. Then, I declare the GPU arrays, the cufft plan (R2C) and run the fft with a subset of the data. Finally, I have a comparison with numpy.fft.rfft:

I have done many loops before, but for some reason, this one doesn't work. I want to find all the Excel files in a folder that begin with "vip" and run another macro. That second macro does many things and saves the file in another folder (hence why when the loop ends, I kill all the remaining files).

The issue is when I run the loop, the first files is found, the second macro is run, but when it loops, it can't find the second file. I did a version with a counter but that didn't really work. The counter could find the three files I needed to run the macro on, but the same issue happened when starting the loop for the second macro, it would find the first file, and the second would not be found. I even tried a version that opened all Excel files in a loop, using a IF statement to find which ones to run the macro on and which to simply close, but I ran into the exact same issue as the other two versions.

So basically, it finds the first file, does what it has to, loops and then gives me the Error 1004 message, where the folder might have been moved, renamed or deleted. I'm stumped.

Thanks for your help!

Here is my code (sorry for the French statements, but you should understand what the code does anyway!):

I have the count working fine as below:

I have hundreds of columns (fixed) and a varying number of rows depending on the data pull. I have a code which inputs a totals formula in last row plus one. This works well. But I have so many columns I need to sum. Say every column in Range H:EA needs a sum total.

I need a more efficient formula than below, but I am unsure where to turn:

I'm new to vba. I am trying to execute a Macro which will work in different sheets. (Each sheet has a data table).

Select a specific column in Dynamic table (which exists in all seven sheets) and calculate in one cell after the last cell in the table (of the specific column) the sum of the cells in the column.

I searched in the site a lot, But I do not exactly understand. I would appreciate any help

Please note: I have only started coding with Python since very recently and am not very acquainted with phrasing, so I do not have any idea on whether this question is a duplicate or not.

I was trying to make my programme run quicker. Here is a portion of it:

The dictionary consists of row-column-keys. Some rows have only one column (r1c1) while others have more (r5c1,r5c2,r5c3...). I would like to count the keys (and so the columns) of every row.