How to Create a Uniform Spiral Pattern in Microsoft Excel

Previous Lessons Learned

1. Be sure that you have done the three previous spreadsheets. They are:

   1. Create Artistic Patterns in Microsoft Excel
   2. Create a Flower Pattern in Microsoft Excel
   3. Create a Tornado Screw Pattern in Microsoft Excel

2. Complete those first before attempting this one because there was a sequence to building the worksheets.

The Tutorial

1. Start a new workbook by saving the old workbook under a new name. Save the workbook into a logical file folder.

2. Set variables to various values and set formulas correctly.

   1. Set A4, On=0,Off=1, to 0.
   2. Set B2, TURNS, to 12.
   3. Set C1, S's Count, to 144.
   4. Set D5, AAA, to 0.
   5. Set E3, Divisor to 160.
   6. Set H1 to .98 and J1 to .96
   7. Set E4, YN, to Y.
   8. The formula in Factor is "=IF(E4="Y",IF(ODD(S_COUNT)=S_COUNT,-S_COUNT*0.01,S_COUNT*0.01),-0.25)"
   9. Adjuster is set to 1 and AdjRows to 1439.
   10. t is -308100.
   11. Adj is "=IF(TURNS>0,VLOOKUP(TURNS,TURNS_LOOKUP,2),VLOOKUP(TURNS, TURNS_LOOKUP_NEG,2))"
   12. Designer is "=VLOOKUP(S_COUNT,SPHEROIDS_COUNT_LOOKER,2)"
   13. Var is "=IF(S_COUNT<4,S_COUNT+30,12)"
   14. Cc is "=-0.25*PI()/C3"
   15. db is 4.5
   16. top is "=ROUND((-B4*PI())+(Adj),0)" 968,277
   17. H2 is Sync1 "=H1/GMLL"
   18. J2 is Sync2 "=J1/GMSL"

3. None of the Lookup tables have changed.

4. The column formulas are as follows:

   1. B7: "=IF(EVEN(S_COUNT)=S_COUNT,ROUND((-B4*PI())+(Adj),0),top)"
   2. B8;B1447: "=((B7+(-TOP*2)/(AdjRows)))*$B$1"
   3. C7: "=ROUND(-EXP((PI()^2)+(Cc*-(db))),0)+Designer"
   4. C8:C1447: "=C7"
   5. D7:D1447: "=IF(A7=0,D6,DEGREES((ROW()-7))*COS((ROW()-7)*Factor*PI()/(180))/Divisor)" which looks new.
   6. E7:E1447: "=IF(A7=0,E6,DEGREES((ROW()-7))*SIN((ROW()-7)*Factor*PI()/(180))/Divisor)"
   7. F7:F1447: "=IF(A7=0,F6,((PI())*((SIN(B7/(C7*2))*GMLL*COS(B7)*GMLL*(COS(B7/(C7*2)))*GMLL)+D7)))"
   8. G7:G1447: "=IF(A7=0,G6,((PI())*((SIN(B7/(C7*2))*GMLL*SIN(B7)*GMLL*(COS(B7/(C7*2)))*GMLL)+E7)))"
   9. H7:H1447: "=F7*GMLL*Sync1"
   10. I7:I1447: "=G7*GMLL*Sync1"
   11. J7:J1447: "=F7*GMSL*Sync2"
   12. K7:K1447: "=G7*GMSL*Sync2"
   13. A7:A1447: (without spaces) "=IF(OR(AND((ROW()-7)>Rrs,(ROW()-7)<=Rrs*2),AND((ROW()-7)>Rrs*4,(ROW()-7)<=Rrs*5), AND((ROW()-7)>Rrs*7,(ROW()-7)<=Rrs*8), AND((ROW()-7)>Rrs*10,(ROW()-7<=Rrs*11),AND((ROW()-7)>Rrs*13,(ROW()-7<=Rrs*14), AND((ROW()-7)>Rrs*16,(ROW()-7<=Rrs*17), AND((ROW()-7)>Rrs*19,(ROW()-7)<=Rrs*20), AND((ROW()-7)>Rrs*22,(ROW()-7<=Rrs*23), AND((ROW()-7)>Rrs*25,(ROW()-7)<=Rrs*26), AND((ROW()-7)>Rrs*28,(ROW()-7)<=Rrs*29), AND((ROW()-7)>Rrs*31,(ROW()-7)<=Rrs*32), AND((ROW()-7)>Rrs*34,(ROW()-7)<=Rrs*35), AND((ROW()-7)>Rrs*37,(ROW()-7)<=Rrs*38), AND((ROW()-7)>Rrs*40,(ROW()-7)<=Rrs*41)),0,1)+On_0_Off_1

Explanatory Charts, Diagrams, Photos

1. (dependent upon the tutorial data above)

1. Create the charts. These flow from F7:G1446, H7:I1446 and J7:K1446, the latter two being copied in or Added Series independently and corrections made until the series look like this:

   1. =SERIES(,'CosSin to Base X,Y DATA'!$H$7:$H$1446,'CosSin to Base X,Y DATA'!$I$7:$I$1446,1) in ice blue or green-blue, it's hard to tell. Line weight is .25 for all.
   2. =SERIES(,'CosSin to Base X,Y DATA'!$J$7:$J$1446,'CosSin to Base X,Y DATA'!$K$7:$K$1446,2) in red-lavender
   3. =SERIES(,'CosSin to Base X,Y DATA'!$F$7:$F$1446,'CosSin to Base X,Y DATA'!$G$7:$G$1446,3) in blue

2. Remove Axis, Grid lines and Chart Legend for both charts in Chart Layout.

   1. Spcl Design 04

Helpful Guidance

1. Make use of helper articles when proceeding through this tutorial:

   1. See the article How to Create a Spirallic Spin Particle Path or Necklace Form or Spherical Border for a list of articles related to Excel, Geometric and/or Trigonometric Art, Charting/Diagramming and Algebraic Formulation.
   2. For more art charts and graphs, you might also want to click on Category:Microsoft Excel Imagery, Category:Mathematics, Category:Spreadsheets or Category:Graphics to view many Excel worksheets and charts where Trigonometry, Geometry and Calculus have been turned into Art, or simply click on the category as appears in the upper right white portion of this page, or at the bottom left of the page.