This is a formula for excel to discover the suns location in the sky: Code: FOR X=1 TO 100 Y=((100-X)/100)*X CELLS(X,1)=Y NEXT X A graph can be drawn in excel and it clearly shows the suns motion across the sky (a curve.) This is based upon the formula: 1<=x<=100 1<=y<=x (y/x)*100 In excel you may notice that the limit (i.e. 1=1,2=2,3=3 etc.) is always ONE HUNDRED at ONE HUNDRED MINUS X. This leads to the formula ((100-x)/100)*x
