P.S.: you added a scene file later on.
The MoInstance rotates around itself, full circle. If I get your intention correctly, this should work like a loop.
The first observation is, that it starts to slowly accelerate, and slows down to zero at Frame 75. If a loop is wanted, it should be a linear interpolation (not spline), so it doesn’t accelerates and decelerates. This change of speed leads to different distances, and a noticeable point around frame 75 and 0. Perhaps this is wanted, … I have no input from you on that.
This would then, since frame 0 is a full frame, lead to the following formula: 75/76*360 = 355.263° As frame 0 would be practically frame 76 for the observer. So, the Object orientation shouldn’t be stopped with twice the same orientation during the loop; A common habit to type in just 360º.
In this case I would go even further, as the rotation is based on a symmetrical object, and so, use this formula (which can be typed in to the P.H field directly, Cinema 4D will do the math): 75/76*180=177.632 ° or shorten even the loop to 38/39*180=175.385 ° based on the symmetrical object.
You had a negative in front of the numbers, this can be just added later.
I have done all the steps mentioned above for the file, see below
https://www.amazon.com/clouddrive/share/hLKoc9dAENIVenV1C9FgFWENHqeBzLejRjaFaByy8ag
IF you check out the Attribute Manager> Formula Effector> Effector
You will see a formula and in the F slider a number.
The formula reads as follow:
?(mod(id;f)=0;0;1)
If (?) the Modulo of the ID (clone id number) with the divider f results in zero, then the factor used for the effector’s parameters is zero, otherwise it is 1 (or 100%).
So, if f =8 then you see only every 8th Spline. With that, the distance to each Spline clone can be determined (increased). The larger F, the larger the distance.
It draws each frame a spline, but based on the formula, only a few are not scaled to invisibility.
All of that is shortly demo’d here
https://www.amazon.com/clouddrive/share/7cadEjK7frIcGqAIjs8WzHA4jMuS1moRttQEFzUbRkb
You can download the clip, for a better viewing experience
All the best