How to Create Lines of Sinewave Spheres in Excel

The Tutorial

1. Open a new Excel workbook and create three worksheets (except Chart if you're using Chart Wizard): Data, Chart and Saves.

2. Set Your Preferences: Open Preferences in the Excel menu and follow the directions below for each tab/icon.

   1. In General, set R1C1 to Off and select Show the 10 Most Recent Documents .
   2. In Edit, set all the first options to checked except Automatically Convert Date System . Set Display number of decimal places to blank (as integers are preferred). Preserve the display of dates and set 30 for 21st century cutoff.
   3. In View, click on show Formula Bar and Status Bar and hover for comments of all Objects . Check Show gridlines and set all boxes below that to auto or checked.
   4. In Chart, allow show chart names and set data markers on hover and leave the rest unchecked for now.
   5. In Calculation, Make sure Automatically and calculate before save are checked. Set max change to .000,000,000,000,01 without commas as goal-seeking is done a lot. Check save external link values and use 1904 system
   6. In Error checking, check all the options.
   7. In Save, select Save preview picture with new files and Save Autorecover after 5 minutes
   8. In Ribbon, keep all of them checked except Hide group titles and Developer .

3. It helps placing the cursor at cell A16 and doing Freeze Panes. Edit Go To cell range A1:R17288 and Format Cells Number Number Decimal Places 4, Font Size 9 or 10, Fill (from the color wheel) a nice purple fuchsia and make the Border Dark Blue bold Outline.

4. Enter the upper Defined Name Variables Section (here's a picture of it and the column headers and data section for you to check your figures against later):

   1. A1: Enter Sinewave Spheres in Linear Shapes
   2. I1: Enter AYE
   3. I2: Enter BEE
   4. I3: Enter CEE
   5. J1: Enter 40
   6. J2: Enter .50
   7. J3: Enter ,50
   8. Select cell range I1:J3 and Insert Names Create Names in Left Column, OK. Select cell range J1:J3 and Format Fill canary yellow (for input).
   9. K1: Enter Stretch_y1
   10. K2: Enter ""=(8.5*(SHRINKER*10))*0.75" w/o quotes.
   11. K3: Enter SHRINKER
   12. L3: Enter "=0.025*36/12" w/o quotes
   13. L1: Enter Stretch_x1
   14. L2: Enter "=(8.5*(SHRINKER*10))*0.8" w/o quotes.
   15. M1: Enter ROWS
   16. M2: Enter MAGIC
   17. M3: Enter SPHERES and Format Fill yellow since these could be CUT SPHERES.
   18. Select cell range M1:N3 and Insert Name Create Names in Left Column, OK.
   19. Select cell N3, enter 12, and Format Fill sky blue as this is the Key Input Cell.
   20. N1: Enter "==17285-5" w/o quotes
   21. N2: Enter "=N1/SPHERES" or "=ROWS/SPHERES"
   22. Command+Select cell range K1:L3, M1:N2 and Format Fill white because these cells are only partially available to (recommended for) changing.

5. Enter Column Headings to rows 4 and 5.

   1. Select cell range A1:H3 and Format Fill white. Make the font in A1 purple.
   2. A5: Line x1
   3. B5: Line y1
   4. C5: Line x2
   5. D5: Line y2
   6. E5: Slope1
   7. F5: Slope2
   8. G5: Indicator
   9. H5: Randy (for RandBetween)
   10. I5: t: 0 to nπ
   11. j5: z1_
   12. K5: Adj_x1
   13. L5: Adj_y1
   14. M4 and N4: Charting
   15. M5: x: No z
   16. N5: y: With z
   17. O5: Adj_x2
   18. P5: Adj_y2
   19. Q4 and R4: Charting
   20. Q5: x2: No z
   21. R5: y2: With z

6. Enter the columnar formulas.

   1. Line x1: Edit Go To cell range A6:A17285 and enter into A6 -10 and into A17285 10 and do Edit Fill Series Column Linear Accept Proposed Step Value or hit Trend, OK.
   2. Line y1: Edit Go To cell range B6:B17285 and enter into B6 w/o quotes the formula, "=E6*A6+0" and Edit Fill Down. This is y=mx+b, where b=0. Select range A6:B17285 and Format Fill yellow with Red bold Outline per cell.
   3. Line x2: Edit Go To cell range C6:C17285 and enter into C6 -30 and into A17285 30 and do Edit Fill Series Column Linear Accept Proposed Step Value or hit Trend, OK.
   4. Line y2: Edit Go To cell range D6:D17285 and enter into D6 w/o quotes the formula, "=F6*C6+0" and Edit Fill Down. This is y=mx+b, where b=0. Select range C6:C17285 and Format Fill yellow.
   5. Slope1: E6: Enter 3. Edit Go To cell range E7:E17285and enter w/o quotes into E7 the formula "=E6" and Edit Fill Down. Select cell E6 and Format Fill yellow and Border blue bold Outline, font red.
   6. Slope2: Edit Go To cell range F6:F17285 and enter into F6 w/o quotes the formula "=-1/E6" and Edit Fill Down. This negative inverse slope becomes the basis for the perpendicular. Select range E6:F17285 and Format Fill sky blue.
   7. Indicator: Select G1 and enter 1. Select G2 and enter 0. Select G3:G17285 and enter to G3 w/o quotes the formula "=IF((ROW()-7)/MAGIC=INT((ROW()-7)/MAGIC),1, IF((ROW()-7)=0,1,0))" and Edit Fill Down and Format Cells Number Number 0.0000;; to hide all the zeros.
   8. Randy: Edit Go To cell range H6:H17285 and enter to H6 w/o quotes the formula "=RANDBETWEEN(0,10)/100" and Edit Fill Down. This is not being used right now, eats up lots of processing time with so many rows, so treat judiciously and set calculation to manual first, which is Command+=.
   9. t: 0 to nπ: Select cell I6 and enter 0.. Edit Go To cell range E7:E17285 and enter to E7 w/o quotes the formula "=IF(G7=1,2*PI(),2*PI()/(MAGIC*1)+I6)".
   10. z1_: Edit Go To cell range J6:J17285 and enter to cell J6 w/o quotes the formula "=CEE*COS(AYE*I6)" and Edit Fill Down.
   11. Adj_x1: Edit Go To cell range K6:K17285 and enter to cell K6 w/o quotes the formula "=IF(G6=1,A6,K5)" and Edit Fill Down. Insert Name Define Name Adj_x1 to cell range $K$6:$K$17285.
   12. Adj_y1: Edit Go To cell range L6:L17285 and enter to cell L6 w/o quotes the formula "=IF(G6=1,B6,L5)" and Edit Fill Down. Insert Name Define Name Adj_y1 to cell range $L$6:$L$17285.
   13. x: No z: Edit Go To cell range M6:M17285 and enter to cell M6 w/o quotes the formula "=(Stretch_x1*(((BEE^2-CEE^2*COS(AYE*I6)*COS(AYE*I6))^0.5*COS(I6)))+Adj_x1)" and Edit Fill Down.
   14. y: With z: Edit Go To cell range N6:N17285 and enter to cell N6 w/o quotes the formula "=(Stretch_y1*(((BEE^2-CEE^2*COS(AYE*I6)*COS(AYE*I6))^0.5*SIN(I6))+z1_)+Adj_y1)" and Edit Fill Down.
   15. Select cell M17286 and enter "=M6" and select cell M17287 and enter the Randy formula "=SHRINKER^2*(Stretch_x1*(((BEE^2-CEE^2*COS(AYE*I17287)*COS(AYE*I17287))^0.5*COS(I17287)))+Adj_x1)*Randy" or +Randy. Use judiciously. This is a planned error value.
   16. Copy M17286:M17287 and Paste to N17286. This is also a planned error value.
   17. Adj_x2: Edit Go To cell range O6:O17285 and enter to cell O6 w/o quotes the formula "=IF(G6=1,C6,O5)" and Edit Fill Down. Insert Name Define Name Adj_x2 to cell range $O$6:$O$17285.
   18. Adj_y2: Edit Go To cell range P6:P17285 and enter to cell L6 w/o quotes the formula "=IF(G6=1,D6,P5)" and Edit Fill Down. Insert Name Define Name Adj_y2 to cell range $P$6:$P$17285.
   19. x2: No z: Edit Go To cell range Q6:Q17285 and enter to cell Q6 w/o quotes the formula "=(Stretch_x1*(((BEE^2-CEE^2*COS(AYE*I6)*COS(AYE*I6))^0.5*COS(I6)))+Adj_x2)" and Edit Fill Down.
   20. y2: With z: Edit Go To cell range R6:R17285 and enter to cell R6 w/o quotes the formula "=(Stretch_y1*(((BEE^2-CEE^2*COS(AYE*I6)*COS(AYE*I6))^0.5*SIN(I6))+z1_)+Adj_y2)" and Edit Fill Down.
   21. Edit Go To cell range M6:R17288 and format Fill sky blue.
   22. Select cell H5 and Format Fill light sea green font red centered font horizontal and border blue bold outline. Copy H5 to L17287 and then Paste Special Format to cells G6, G7, I6, M17286 and Na7286 to make those cells very distinct.
   23. Select cell range O1:R3 and Format Fill white.

Explanatory Charts, Diagrams, Photos

1. (dependent upon the tutorial data above)

1. The charting is in your capable hands -- see prior articles referenced at top for help. Just be wary that when you ADD SERIES for columns Q and R, you want to end up with two series charted:

   1. =SERIES(,'DATA 01'!$Q$8:$Q$17285,'DATA 01'!$R$8:$R$17285,1)
   2. =SERIES(,'DATA 01'!$M$8:$M$17286,'DATA 01'!$N$8:$N$17286,2)

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.