I would like to solve in analytical way the following problem:

- I have a circle with diameter D1=70mm
- I have another circle with diameter D2=Xmm which is my unknown of this problem
- The center to center distance between the circles is 250mm
- The length of the "belt" (depicted in blue line color) is always fixed to 800mm
The circle identified by diameter D1 represents the driving pulley. The circle identified by diameter D2 represents the driven pulley. The blu line is always tangent to both circles (pulleys) and represents the belt.
Now, when I change the diameter D1, I will obtain another value of diameter D2 and today I have to determine the solution with the help of a parametric CAD drawing.
Is there a way to solve it analytically (for example using an Excell sheet).
Thank you in advance!
Deatil of the winding angle on the driven circle:
Edit: the winding angle is the same in both circles: detail of the system
\begin{align} |T_tT_2|=|O_1C| &= \sqrt{d^2-(r_2-r_1)^2} \tag{1}\label{1} ,\\ \phi&=\arcsin\Big(\frac{r_2-r_1}d\Big) \tag{2}\label{2} . \end{align}
Constraint:
\begin{align} (\tfrac\pi2-\phi)\cdot r_1 +\sqrt{d^2-(r_2-r_1)^2} +(\tfrac\pi2+\phi)\cdot r_2 &=\tfrac12\,L \tag{3}\label{3} , \end{align}
\begin{align} \text{or }\qquad \left( 2\,(r_2-r_1)\arcsin\left(\frac{r_2-r_1}d\right) - (L-\pi\,(r_2+r_1) -2\,\sqrt{d^2-(r_2-r_1)^2}) \right)^2 &=0 \tag{4}\label{4} . \end{align}
Unfortunately, in general, given $r_1,d$ and $L$ there is no analytic solution for $r_2$ in \eqref{4}, so we need to use numeric methods.
For example, in Excel, you can type the formula \eqref{4} and use built-in non-linear solver to minimize it.
For example, for $r_1=35,\ d=250,\ L=800$ we get $r_2=59.71462$.
As the first approximation to $r_2$ you can try
\begin{align} r_{2\,(0)} &= r_1+\pi\,d-\frac{\pi^3\,d^2}{d\,(\pi^2-2)+L-2\pi\,r_1} . \end{align}
For the above example, $r_{2\,(0)}\approx 59.69$, which is pretty close.
For the numeric approximation you can use, for example, Halley's method as a root-finding algorithm:
\begin{align} r_{2(n+1)} &= r_{2(n)} - \frac{2\,f(r_{2(n)},r_1,d,L)\,f'(r_{2(n)},r_1,d)} {2\,f'(r_{2(n)},r_1,d)^2-f(r_{2(n)},r_1,d,L)\,f''(r_{2(n)},r_1,d)} , \end{align}
where
\begin{align} f(r_{2},r_1,d,L) &= 2\,(r_2-r_1)\,\arcsin\Big(\frac{r_2-r_1}d\Big) -L+\pi\,(r_2+r_1)+2\,\sqrt{d^2-(r_2-r_1)^2} ,\\ f'(r_{2},r_1,d) &= 2\,\arcsin\Big(\frac{r_2-r_1}d\Big)+\pi ,\\ f''(r_{2},r_1,d) &= \frac 2{\sqrt{d^2-(r_2-r_1)^2}} . \end{align}
$$ \begin{array}{cc} \hline n & r_{2(n)} \\ \hline 0 & 35.0000000000 \\ 1 & 59.6915126334 \\ 2 & 59.7146200516 \\ 3 & 59.7146200510 \\ \hline \end{array} $$
This is a minimal
pythonexample: