How to Create Floral and Other Images with Trig and Neutral Operations

Step-by-Step Guide

1. 1

   Step 1: Open a new Excel workbook and create 3 worksheets: C.Data

   Save the workbook into a logical file folder.
   
   If you tap on the green font "Ticklezzz" below, there will appear an animation of the curve to be created; hit the browser's Back button to return from YouTube here.
   
   It was done with random number generation at the tips and pi approximation to 15 digits for a constant recalc, and recorded in QuickTime Player.
   
   Ticklezzz , Recommended Settings:
   Set General to R1C1 Off and Show the 10 Most Recent Documents; Edit
   - set all the Top options to checked except Automatically Convert Date System.
   
   Display number of decimal places = blank (for integers preferred), Preserve display of dates and set 30 for 21st century cutoff; View
   - show Formula Bar and Status Bar, hover for comments and all of Objects, Show gridlines and all boxes below that auto or checked; Chart
   - show chart names and data markers on hover.
   
   Leave rest unchecked for now; Calculation Automatic and calculate before save, Iteration limited, 100 (200 for the animation tho), max change .000 000 000 000 01 w/o spaces if you do goal-seeking a lot (like for the animation) and save external link values and use 1904 system; Error checking
   - check all; Save
   - save preview picture with new files and Save Autorecover after 5 minutes; Ribbon
   -- all checked except Hide group titles and Developer., Do Format Cells Font Size 9 or 10 if you're comfortable with that and Format Number Number Decimal Places
   4., A1:
   Enter 1, and Format Cell Number Number Custom "Degrees="00.00 w/ commas and Insert Name Define name Degrees for cell $A$1 and do Insert Comment and edit in "A1:
   Original Value is
   1.
   
   Set to whatever pleases your aesthetic
   -- chaos is possible herewith tho! Low values work better.
   
   Notice that inputting a 2 gets rid of all those wonderful little Errors in the data!? Error which should probably rather be kept, as will be explained."; B1:
   Enter the column heading Neutrality Formulas; C1:
   Enter in the Defined Variable Name Converter; D1:
   Enter w/o quotes the formula "=(PI()^2)/((PI()^2)-(205))" and Insert Name Create in Left Row name Converter for cell $D$1 and Insert New Comment and edit in "D1:
   The original value is formula (to be entered in the formula bar as copied from here) of: =(PI()/180)^-0.1414  ….
   
   You could try 16 or 2 or-.01 or =PI()/2.5.
   
   Now=(PI()^2)/((PI()^2)-(205))"; E1:
   Enter the Defined Variable Name CFactor.
   
   F1:
   Enter 95 and Insert Name Create Left Row Name CFactor for cell $F$1 and do insert New Comment and edit in "F1:
   The original value is
   -5.
   
   Try entering 0 or 1 or 6 or =-PI() or =-EXP(1) (a fave) ..
   
   Which is the transcendental number e in XL ..
   
   Or 18 or any formula, preceded by an "="
   
   and logically valid to Excel.
   
   Input of .00001 may result in something like a simple circle, if var(iable) Degrees doesn't equal 1 maybe? Currently=
   95."
   
   A2: a; B2: b; C2: sin a; D2: cos a; E2:
   Factor sin a; F2: cos b., In cell A3, enter w/o quotes the formula "=Degrees" and Insert Name Define name Top for cell $A$3 and do Insert New Comment and edit in "A3:
   This cell has the Insert
   -Define(d) Name of "Top"
   
   as used by cells below it in their formulas.
   
   Its own reference is to the "Degrees" variable."; Edit Go To cell range A4:
   A363 and with A4 the active cell enter w/o quotes the formula "=A3-((2*Top)/360)" and Edit Fill Down and select cell A4 and Insert New Comment and edit in "A4:
   The effect of this formula,  "=A3-((2*Top)/360)"  is to decrement a series automatically through +Top to
   -Top (cell A3=Top), eg.
   
   When Top=1, the result in cell A363 at the bottom will be
   -1, the series having decremented thru 0 (in cell A183).
   
   If instead Degrees=360, then Top=360= cell A3's new value in the formula.
   
   A3=360.
   
   So 360-((2*360)/360)= (360-(720/360)) = 360-(2) =
   358.
   
   Cell A362 near the bottom =
   -358 and cell A183 still =
   0.
   
   The decrementing is uniform.
   
   If Degrees=Top= (-1), then the formula increments up to A363=+1 uniformly."., But the cell-formula below is different!"; B4:
   Into cell B4 enter w/o quotes the formula "=-A4/(1-(1/A4))" and do Insert New Comment and edit in "B4:
   This cell's formula, "=-A4/(1-(1/A4))" is also a Neutral Operation
   -- that of a-b = a/b.
   
   So the effect is that there are rotating formulas thru various Neutralities." B5:
   Enter in w/o quotes the formula "=A5/(A5+1)" and insert New Comment and edit in "B5:
   This cell's formula, "=A5/(A5+1)" is another Neutrality., of a-b = a*b." B6:
   Enter into the cell w/o quotes the formula, "=A6/(1-(1/A6))" and Insert New Comment and edit in "B6:
   This cell's formula, "=A6/(1-(1/A6))" is another different Neutrality of a-b = a/b.
   
   Edit Go To cell range B7:
   B363 and Edit Fill Down, which will repeat the 4-sequence formulation above to the bottom., The ±Top and Decrement in cell-column A, e.g.
   
   In A3, is divided by twice the Neutrality-result in B3, so that's "A3/(2*B3)".
   
   That result is multiplied by both CFactor, say =
   -5, and Converter, say =
   1.7725501863 or =(PI()/180)^-0.1414.
   
   Then the SIN() function is applied to that result.
   
   The SIN() function returns a value from 0 to 1, having to do with a point on a curve, say a circle or an ellipse or a flower's edge.
The above result is multiplied by a COS(ine) function performing the same way.
   
   So it's multiplying together 2 parts of the same angle.
   
   If sine is y/r and cos is x/r than it's achieved XY/r^2, right? 
Then, by adding to the above total product the LAST formula term, "+COS((ROW()-3)*PI()/180)"
   
   it's setting the result in a path around a circle (or cycle).
   
   For cell C3 in Row 3, the ROW() function returns the row the formula is in, row 3, and subtracts 3 from it; 3-3=0, so I'll get the COS of 0 which is
   1.
   
   The "*PI()/180" part of the formula is Excel's way of converting sine formulas from angles to pi-radians and vice versa.
 Performed over 360 or 361 rows, the full circle is completed by the last term, as modified in form by the previous XY/r^2 relation ... that's it in a nutshell.
   
   Why's it called "sin(a)"? To fool intruders? No, that's just how the sheet formulas evolved, so it helps keep track of the Form-Evolution-Path."
, The formula,
"=(SIN(CFactor*A3/(2*B3)*Converter)*SIN(A3*CFactor*Converter))+SIN((ROW()-3)*PI()/180)"
   
   
is different in 2 respects: 1) the 2nd term, "SIN(A3*CFactor*Converter)"
   
   for sine = distance Y over radius r, i.e. y/r, is fully squared, so I get Y^2/r^2, instead of XY/r^2 as explained in cell C3; 2) the last term "SIN((ROW()-3)*PI()/180)"
   
   works with and against the final COS() function in cell C3 to complete the points around the circle, since elements of set {X=COS(), Y=SIN()} give the coordinates of circle points on the circumference (unless and until otherwise modified, as done here by the other terms), relative to a constant radius r.
   
   But the whole point is to modify the constancy of radius r to get the fun design! To understand this better, see the explanation of the formula in cell C3's comment please, or ask."
   
   These next two steps may be skipped therefore, but they're easy.
   
   Into E1, enter "Sin(C3)" and Edit Fill Down to E3:
   E363.
   
   Do Insert New Comment and edit in "E3:
   The new formula, =SIN(1/CFactor*C3*(1/Converter)), is an attempt to see a Side View
   -- see Chart at bottom in blue and white.
   
   This formula, "=CFactor*C3" merely re-applies whatever's the value or formula-value-variable in CFactor in cell F1 to the formula in C3 … from the outside, as it were.
   
   Whereas earlier, Cfactor gets used internally in cell C3's formula.
   
   The column title, "Factor sin a" tells the story of what I'm doing.
   
   Currently the formula is set to =SIN(C3)" instead.
, Charting cell range E3:
   F363 I leave as an exercise to do.
   
   Perhaps Cos and Sin should be switched.
, Edit Go To cell range C3:
   D363 and use either Chart Wizard to create a new chart page or use the Ribbon and select Charts, All, scroll down to Scatter, Smoothed Line Scatter and OK and Cut or Copy the chart to the Chrys Chart worksheet's A1 cell.
   
   Hover over the lowest right corner until the double headed arrow appears and pull the chart open into a large square, Click on the Plot Background and choose Radial Fill dark Green right and Black left radial from Center, Double click on the series plot line and change the Line weight to 1 and color white.
   
   In Chart Layout, get rid of the axes and chart label, etc. unless you want to leave formulation notes and that is done via Chart Title Text Box options for MS Excel 2011 for the Mac.
   
   You are Done! The above jpg shows how it should have turned out
 , For more art charts and graphs, you might also want to click on Category:
   Algebra, 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: Chrys Chart and Saves.

3. 3

   Step 3: Set Preferences: Open Preferences in the Excel menu.

4. 4

   Step 4: Select the entire worksheet by selecting between the 1 of row 1 and the A of column A in the upper and left most corner of the C.Data worksheet.

5. 5

   Step 5: Enter the Defined Name Variables and headers of row 1.

6. 6

   Step 6: Enter the column headings.

7. 7

   Step 7: Enter the formulas.

8. 8

   Step 8: Into cell B3 enter w/o quotes the formula "=IF(ISERR(A3/(A3-1))

9. 9

   Step 9: A3/(A3-1))" and do Insert New Comment and edit in "B3: The formula in this cell

10. 10

    Step 10: "=A3/(A3-1)" is a Neutral Operation in that when Y= X/(X-1)

11. 11

    Step 11: then X + Y = X * Y

12. 12

    Step 12: as does this cell =A3/(A3-1)

13. 13

    Step 13: similarly.

14. 14

    Step 14:  Edit Go To cell range C3:C363 and with C3 the active cell

15. 15

    Step 15: enter the formula w/o quotes "=(SIN(CFactor*A3/(2*B3)*Converter)*COS(A3*CFactor*Converter))+COS((ROW()-3)*PI()/180)" and Edit Fill Down and Errors are on purpose and Do Insert New Comment and edit in "C3: This formula

16. 16

    Step 16: 
=(SIN(CFactor*A3/(2*B3)*Converter)*COS(A3*CFactor*Converter)) +COS((ROW()-3)*PI()/180)
looks a lot more wicked than it really is.

17. 17

    Step 17:  Edit Go To cell range D3:D363 and with D3 the active cell

18. 18

    Step 18: enter the formula w/o quotes "=(SIN(CFactor*A3/(2*B3)*Converter)*SIN(A3*CFactor*Converter))+SIN((ROW()-3)*PI()/180)" and Edit Fill Down and the errors are on purpose and do Insert New Comment and edit in "D3: This formula works pretty much like the one in D3

19. 19

    Step 19: except that it's using 3 SIN() functions together instead of SIN*COS+COS of cell C3.

20. 20

    Step 20: That is all that's needed to produce the chart shown above

21. 21

    Step 21: There are two more columns

22. 22

    Step 22: however

23. 23

    Step 23: for adventurous types.

24. 24

    Step 24: Edit Go To cell range F3:F3633 and with F3 the active cell

25. 25

    Step 25: enter w/o quotes the formula "=COS(D3)" and Edit Fill Down.

26. 26

    Step 26: 
Create the Chart.

27. 27

    Step 27: Make use of helper articles when proceeding through this tutorial: See the Related LifeGuide Hubs below and the article How to Do the Sub Steps of Neutral Operations for a list of articles related to Excel

28. 28

    Step 28: Geometric and/or Trigonometric Art

29. 29

    Step 29: Charting/Diagramming and Algebraic Formulation relating to Neutral Operations.

Detailed Guide

About the Author