How to Create a Squiggly Frame Pattern in Microsoft Excel

Part 1 of 3:

The Tutorial

  1. How to Create a Squiggly Frame Pattern in Microsoft Excel Picture 1
    Start a new workbook by saving the previous workbook from Create a Floral Glassware Pattern in Microsoft Excel under a new name. Save the workbook into a logical file folder.
  2. How to Create a Squiggly Frame Pattern in Microsoft Excel Picture 2
    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 = 25
    5. Enter Var = 12
    6. Enter Divisor = 39,708,609,295
    7. Enter top = "=ROUND((-B4*PI())+(Adj),0)"   9679383
    8. Enter YN = N
    9. Enter Power = 2
    10. All the rest are the same as they were before.
  3. How to Create a Squiggly Frame Pattern in Microsoft Excel Picture 3
    Complete all changes in the upper Columnar Formulas section.
    1. c = -24625 as the result of "=ROUND(-EXP((PI()^2)+(Cc*-(db))),0)+Designer"
    2. Enter to D7:D1447 w/ D7 active "=X7/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)"
    3. Enter to E7:E1447 w/ E7 active "=Y7/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)"
    4. The External Ring and GMLL x,y and GMSL x,y formulas are unchanged. All other formulas and lookup tables are unchanged.
    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" and 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.
Part 2 of 3:

Explanatory Charts, Diagrams, Photos

  1. (dependent upon the tutorial data above)
  1. How to Create a Squiggly Frame Pattern in Microsoft Excel Picture 4
    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 Deep Purple from the Color Wheel.
    3. Create the second chart with Plot Area background Black Fill. and paste in the GMLL and GMSL series and edit the series if they've arrived wrong until they read in the formula bar as follows:
      1. =SERIES(,DATA!$H$7:$H$1446,DATA!$I$7:$I$1446,1) Burgundy Red
      2. =SERIES(,DATA!$J$7:$J$1446,DATA!$K$7:$K$1446,2) Turquoise (Blue)Green
      3. =SERIES(,DATA!$F$7:$F$1446,DATA!$G$7:$G$1446,3) Blue Purple
  2. How to Create a Squiggly Frame Pattern in Microsoft Excel Picture 5
    Copy the live formulas and Paste Special Values then too to Saves, then Do Copy Picture and Paste Picture from the Chart with the Shift Key depressed to Saves and Save the workbook. Do so for each modification in the Tips section below.
  3. How to Create a Squiggly Frame Pattern in Microsoft Excel Picture 6 Squiggly Eye at Alpine
Part 3 of 3:

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.
4.5 ★ | 2 Vote

May be interested

  • How to Acquire Bézier Curves Using ExcelPhoto of How to Acquire Bézier Curves Using Excel
    bézier curves are used in photoshop, animation, auto manufacturing, film special effects, higher math curve analysis and for many other functions. in this article, learn to use bézier curves and the formulas they're based on to create e...
  • How to Work with Excel CubesPhoto of How to Work with Excel Cubes
    you'll learn to work simply with excel cubes following the steps below to make this image and many more like it. become familiar with the basic image to be created: === the tutorial ===
  • How to Create Artistic Patterns in Microsoft ExcelPhoto of How to Create Artistic Patterns in Microsoft Excel
    have you ever wanted to create special designs and patterns? this article will show you how you can make cool patterns using microsoft excel. it's followed by 14 more articles of artistic designs that build from this beginning. open a new...
  • How to Create a Uniform Spiral Pattern in Microsoft ExcelPhoto of 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 ===
  • How to Create a Sin and Cos Circle in ExcelPhoto of How to Create a Sin and Cos Circle in Excel
    learn how to create a a graph of a circle using the sin (sine) and cos (cosine) functions in microsoft excel in this article. additionally, you will learn to offset the circle, plot a radius and to shrink or expand the circle and radius...
  • How to Create a Curve in ExcelPhoto of How to Create a Curve in Excel
    you will learn to research and locate a curve of interest, then set up the data for graphing (charting) it in microsoft excel in the following steps. the example curve in the photo from the text was chosen at random from a standard...