How to Create a Tornado Screw Pattern in Microsoft Excel

Step-by-Step Guide

1. 1

   Step 1: This article relies on the previous accomplishment of the two articles preceding it: Create Artistic Patterns in Microsoft Excel and Create a Flower Pattern in Microsoft Excel.

   This one's followed by the 12 articles in the Related LifeGuide Hubs at the bottom of the page., Save the workbook into a logical file folder., Enter "=ROUND(1440/S_COUNT,1)" into cell A1.
   
   Format Cell Number Number Custom "Rrs"
   0.
   
   Insert Name Define name Rrs to cell $A$1.
   
   Enter the formula "=ROUND(1440/Rrs,0)" into cell A2.
   
   Enter On=0,Off=1 into cell A3.
   
   Enter 1 into cell A4.
   
   Edit Go To cell range A7:
   A1447 and with A7 active, enter the formula without quotes or spaces   "=IF(OR( AND((ROW()-7)>Rrs,(ROW()-7)<=Rrs*2),                                    AND((ROW()-7)>Rrs*4,(ROW()-7)<=Rrs*5),                                                  , Format Cell Fill Yellow Font bold and Number Number Custom "Divisor"
   0.00 with quotes., Format Cell Fill Yellow Font bold and Number Number Custom "AAA" +.00000000;"AAA"
   -.00000000 with quotes., Enter 24 into S's Count cell C1 for Spheroids (the example chart uses 25 but the pairs come out better with 24).
   
   Enter 968277 into cell D3, top.
   
   Enter .61 into cell H1 and .78 into cell J1., B8:
   B1447: "=((B7+(-TOP*2)/(AdjRows)))*$B$1" C7: "=ROUND(-EXP((PI()^2)+(Cc*-(db))),0)+Designer" C8:
   C1447:  "=C7" NEW:
   D7:
   D1447: "=IF(A7=0,D6,COS((ROW()-7)*Factor*PI()/(180))*((ROW()-7)/Divisor))" NEW:
   E7:
   E1447: "=IF(A7=0,E6,DEGREES((ROW()-7))/41500)" This uses the DEGREES() function for the first time.
   
   See Tips below and Excel Help under Home > Function References > Math and Trigonometry Functions.
   
   NEW:
   F7:
   F1447: "=IF(A7=0,F6,((PI())*((SIN(B7/(C7*2))*GMLL*COS(B7)*GMLL*(COS(B7/(C7*2)))*GMLL)+D7)))" NEW:
   G7:
   G1447: "=IF(A7=0,G6,((PI())*((SIN(B7/(C7*2))*GMLL*SIN(B7)*GMLL*(COS(B7/(C7*2)))*GMLL)+E7)))" H7:
   H1447: "=F7*GMLL*Sync1" I7:
   I1447: ""=G7*GMLL*Sync1" J7:
   J1447: "=F7*GMSL*Sync2" K7:
   K1447: "=G7*GMSL*Sync2"
   
   Here below is an image of my header rows and data to check against your own and the previous file's (*02" for short) original formulas.
   
   There should be no errors.
   
   Make sure there is a formula in cell A7. , Refer to the prior article for any basic problems with charting.
   
   Basically, chart the last 3 pairs of columns as individually paired sets of {x,y}'s for a threesome effect.,, 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.
2. 2

   Step 2: Please complete those first before attempting this article.

3. 3

   Step 3: Start a new workbook by saving the old workbook under a new name.

4. 4

   Step 4: Insert a new column at Column A.

5. 5

   Step 5: Insert Name Define Name Divisor into cell $E$3 and enter 1000.

6. 6

   Step 6: Insert Name Define Name AAA into cell $D$5 and enter .000004.

7. 7

   Step 7: Enter 12 into cell B2

8. 8

   Step 8: TURNS.

9. 9

   Step 9: Check the formulas in the columns: B7: "=IF(EVEN(S_COUNT)=S_COUNT

10. 10

    Step 10: ROUND((-B4*PI())+(Adj)

11. 11

    Step 11: TOP)" w/o quotes for this and all of this step's formulas.

12. 12

    Step 12: The various Lookup Tables have not changed since "Create a Flower Pattern in Microsoft Excel" or "Create Special Designs and Patterns 02".

13. 13

    Step 13: The charting is left to the imagination of the reader

14. 14

    Step 14: given Excel's new capabilities for shadow and glow

15. 15

    Step 15: reflection and so forth.

16. 16

    Step 16: Final image #

17. 17

    Step 17: Make use of helper articles when proceeding through this tutorial: 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

18. 18

    Step 18: Geometric and/or Trigonometric Art

19. 19

    Step 19: Charting/Diagramming and Algebraic Formulation.

Detailed Guide

About the Author