HomeApplicationGraphic design

How to Create a Uniform Spiral Pattern in Microsoft Excel

In this article, you'll learn to make the 'uniform spiral' pattern and image below, and the dozens of variations the file permits therefrom. Become familiar with the image to be created: === Previous Lessons Learned ===
Part 1 of 4:

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. How to Create a Uniform Spiral Pattern in Microsoft Excel Picture 1How to Create a Uniform Spiral Pattern in Microsoft Excel Picture 1
    Complete those first before attempting this one because there was a sequence to building the worksheets.
Part 2 of 4:

The Tutorial

  1. How to Create a Uniform Spiral Pattern in Microsoft Excel Picture 2How to Create a Uniform Spiral Pattern in Microsoft Excel Picture 2
    Start a new workbook by saving the old workbook under a new name. Save the workbook into a logical file folder.
  2. How to Create a Uniform Spiral Pattern in Microsoft Excel Picture 3How to Create a Uniform Spiral Pattern in Microsoft Excel Picture 3
    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. How to Create a Uniform Spiral Pattern in Microsoft Excel Picture 4How to Create a Uniform Spiral Pattern in Microsoft Excel Picture 4
    None of the Lookup tables have changed.
  4. How to Create a Uniform Spiral Pattern in Microsoft Excel Picture 5How to Create a Uniform Spiral Pattern in Microsoft Excel Picture 5
    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
Part 3 of 4:

Explanatory Charts, Diagrams, Photos

  1. (dependent upon the tutorial data above)
  1. How to Create a Uniform Spiral Pattern in Microsoft Excel Picture 6How to Create a Uniform Spiral Pattern in Microsoft Excel Picture 6
    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. How to Create a Uniform Spiral Pattern in Microsoft Excel Picture 7How to Create a Uniform Spiral Pattern in Microsoft Excel Picture 7
    Remove Axis, Grid lines and Chart Legend for both charts in Chart Layout.
    1. How to Create a Uniform Spiral Pattern in Microsoft Excel Picture 8How to Create a Uniform Spiral Pattern in Microsoft Excel Picture 8
      Spcl Design 04
Part 4 of 4:

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.
3.8 ★ | 8 Vote
rowsetrrs

You should read it

Maybe you are interested

Graphic design