How to Create an Equilateral Springs Pattern in Microsoft Excel

Previous Lessons Learned

How to Create an Equilateral Springs Pattern in Microsoft Excel Picture 1

1. How to Create an Equilateral Springs Pattern in Microsoft Excel Picture 2
   This article relies on the previous accomplishment of the eight articles preceding it:

   1. How to Create Artistic Patterns in Microsoft Excel
   2. How to Create a Flower Pattern in Microsoft Excel
   3. How to Create a Tornado Screw Pattern in Microsoft Excel
   4. How to Create a Uniform Spiral Pattern in Microsoft Excel
   5. How to Create an Insectoid Pattern in Microsoft Excel
   6. How to Create a Skewed Spheroids Pattern in Microsoft Excel
   7. How to Create a Floral Glassware Pattern in Microsoft Excel
   8. How to Create a Squiggly Frame Pattern in Microsoft Excel.
   9. Please complete those first before attempting this one.

The Tutorial

1. How to Create an Equilateral Springs Pattern in Microsoft Excel Picture 3
   Start a new workbook by saving the previous workbook from How to Create a Squiggly Frame Pattern in Microsoft Excel under a new name. Save the workbook into a logical file folder.
2. How to Create an Equilateral Springs Pattern in Microsoft Excel Picture 4
   Enter the new Equilateral Triangle Data Table.

   1. Enter into cell AB4 the note, 1440 points/3 legs = 480 pts/Leg. Font bold red.
   2. Enter Equilateral to cells AB5 and AC5.
   3. Enter Triangle x to AB6 and Triangle y to AC6. Format Cells cell range AB5:AC6 Alignment horizontal center and Font Bold Underline Single.
   4. Edit Go To cell range AB7:AB486 and enter -1.8138 into cell AB7 and .001 into cell AB486, Edit Fill Series Columns Linear Proposed Step Value should be 0.0037866388308978 or so. OK.
   5. Enter .001 into cell AB487. Edit Go To cell range AB488:AB966 and enter 0.0037866388308978 into cell AB488 and 1.8138 into cell AB966, Edit Fill Series Columns Linear Proposed Step Value should be 0.0037866388308978 or so. OK.
   6. Edit Go To cell range AB967:AB1447 and enter 1.8138 into cell AB967 and -1.8138 into cell AB1446, Edit Fill Series Columns Linear Proposed Step Value should be -0.00757327766179561 or so. OK. Copy cell AB1446 to cell AB1447.
   7. Edit Go To cell range AC7:AC486 and enter -1.5708 into cell AC7 and 1.5708 into cell AC486, Edit Fill Series Columns Linear Proposed Step Value should be 0.00655865084502816 or so. OK.
   8. Enter 1.5708 into cell AC487. Edit Go To cell range AC488:AC966 and enter 1.56423767594987 into cell AC488 and -1.57079742797353 into cell AC966, Edit Fill Series Columns Linear Proposed Step Value should be -0.00655865084502816 or so. OK.
   9. Edit Go To cell range AC967:AC1447 and enter -1.5707963267949 into cell AC967 and Edit Fill Down.
   10. Edit Go To cell range U1446:AA1446 and copy it and paste it to U1447.
3. How to Create an Equilateral Springs Pattern in Microsoft Excel Picture 5
   Complete all changes in the upper Defined Variables section.

   1. Enter On=0,Off=1 cell A4 = 1
   2. Enter Adjuster = 1
   3. Enter TURNS = 9
   4. Enter S's Count = 2
   5. Enter Var = 12
   6. Enter Divisor = 360
   7. Enter top = "=ROUND((-B4*PI())+(Adj),0)" 968061
   8. NEW: Enter 28.6470945405378 into cell D4 and Format Cell Number Number Custom "(FFF)" 0.000000 with parentheses and quotes. Go to cell AA7 and enter "=D4" and Insert Name Define name FFF to cell $AA$7.
   9. Enter YN = Y
   10. Enter Power = 1
   11. Enter AAA = 20
   12. db = 4.5
   13. All the rest are the same as they were before.
4. How to Create an Equilateral Springs Pattern in Microsoft Excel Picture 6
   Complete all changes in the upper Columnar Formulas section.

   1. NEW: Enter to B7 the formula "=IF(EVEN(S_COUNT)=S_COUNT,ROUND((-B4*PI())+(Adj),0),0.0000000000001)"
   2. c = -312555 as the result of "=ROUND(-EXP((PI()^2)+(Cc*-(db))),0)+Designer"
   3. NEW: Enter to D7:D1447 w/ D7 active "=X7/IF(Divisor=0,S_COUNT,Divisor)+(IF(COS((ROW()-7)*PI()/180*Factor)<0, ABS(COS((ROW()-7)*PI()/180*Factor))^Power*-1,COS((ROW()-7)*PI()/180*Factor)^Power)*IF(AAA=1,0,1))+IF(AAA=0,0,AB7)"
   4. NEW: Enter to E7:E1447 w/ E7 active "=Y7/IF(Divisor=0,S_COUNT,Divisor)+(IF(SIN((ROW()-7)*PI()/180*Factor)<0, ABS(SIN((ROW()-7)*PI()/180*Factor))^Power*-1,SIN((ROW()-7)*PI()/180*Factor)^Power)*IF(AAA=1,0,1))+IF(AAA=0,0,AC7)"
   5. Check that F7:F1447 with F7 active contains "=IF(A7=0,F6,((PI())*((SIN(B7/(C7*2))*GMLL*COS(B7)*GMLL*(COS(B7/(C7*2)))*GMLL)+D7)))"'
   6. Check that G7:G1447 with G7 active contains "=IF(A7=0,G6,((PI())*((SIN(B7/(C7*2))*GMLL*SIN(B7)*GMLL*(COS(B7/(C7*2)))*GMLL)+E7)))"
   7. Check that Sync1 refers to H2 and Sync2 refers to J2. Check the H2 formula, "=H1/GMLL" abd check the J2 formula, "=J1/GMSL".
   8. Check the H7 formula, "=F7*GMLL*Sync1" and the I7 formula, "=G7*GMLL*Sync1".
   9. Check the J7 formula, "=F7*GMSL*Sync2" and the K7 formula, "=G7*GMSL*Sync2".
   10. Check that the lookup tables are unchanged, except as done above.

Explanatory Charts, Diagrams, Photos

1. (dependent upon the tutorial data above)

1. How to Create an Equilateral Springs Pattern in Microsoft Excel Picture 7
   Create the Chart.

   1. Edit Go To cell range F7:G1446 on the Data worksheet and using Chart Wizard or the Ribbon, select Charts All/Other, Scatter, Smoothed Line Scatter. Copy the Chart to the Chart worksheet and expand it with the double-headed arrow via the bottom right corner.
   2. Select Chart Layout and get rid of the axes and grid lines and legend; select Data Series 1 and make Line Weight 1 color Navy Blue (default) or as you please, perhaps from the Color Wheel.
   3. Select the Chart Area and Format Selection under Chart Layout Current Selection Fill red.
      How to Create an Equilateral Springs Pattern in Microsoft Excel Picture 8

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.