Tick % Offset

[asacre]

I've been experimenting with different methods to match the actual Offset Tick % that the software provides, but I always notice some variation. I’m wondering if this is due to a specific programmed function that causes fluctuations. I appreciate your help. I've been comparing Tick % and Tick Offset extensively to improve the accuracy of my analysis, but it's taking longer than expected.

[alrodopial]

this setting for tick% may help:

[asacre]

Is there an actual formula to represent this in excel to make the analysis accurate?