I think that I need to know how to determine the angle between two points on the Earth's elliptical orbit around the Sun in order to calculate the Sun's distance from Earth.
I found the main equations at this page This is a good reference but I am still lost because I don't see how to calculate $\theta$ there, nor $\psi$ (eccentric anomaly)
There is a another website at "How can I find the Distance to the Sun on any given day." That is my ultimate goal btw, to have a spreadsheet with an entire year in 4 hour increments including distance to the sun for each 4 hour period. For a novice person with no math background, this website explanation seems a little easier to understand for me. Alas, she also did not explain how to determine the radius angle between two points on the ellipse. (Unless I'm overlooking it - which could be the problem)
This is the formula I ultimately derived:
$a$ = semi-major axis is $149.6$ million km
$e$ = eccentrity of the ellipse = $0.017$
$\theta$ = Is supposed to be angle between two points on the ellipse But I used number of days since last perihelion This is where I get lost
$X$ = number of days since last perihelion
$$\text{distance} = \frac{a(1-e^2)}{1+e\cdot\cos\theta}$$
$$\text{distance} = \frac{149.6\cdot(1-0.017^2)}{1+0.017\cdot\cos\big(X\cdot\frac{365.25}{360}\big)}$$
Will someone please help me understand how to correct my formula?
