How to calculate next transform location based off distance?

I think I can fix this entirely from BP. Attempting to break down the for each core macro into a more specific loop in my BP.