How to Acquire Sinewave Spheres via Excel

The Tutorial

1. Open a new Excel workbook and create 3 worksheets (except Chart if you are 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 is 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 A14 and doing Freeze Panes. Edit Go To cell range A1:E5765 and Format Cells Number Number Decimal Places 4, Font Size 9 or 10, Fill (from the color wheel) a nice fuchsia and make the Border Dark Blue bold Outline.
4. Enter the Defined Variable Names and some initial values:

   1. In A1, enter a;
   2. In A2, enter b;
   3. In A3, enter c_;
   4. Select cell range A1:B3 and Insert Names Create in Left Column; select cell range B1:B3 and Format Fill yellow (for input);
   5. In B1, enter 18; f(or the complete sphere, the value = 100)
   6. In B2, enter .8; f(or the complete sphere, the value = .5)
   7. In B3, enter .6; f(or the complete sphere, the value = .5)
   8. In cell D1, enter Change;
   9. In cell E1, Enter Stretch_y;
   10. Select cell range D1:E2 and Insert Names Create in Top Row;
   11. Select cell range D1:D2 and Format Cell Fill White or None.
   12. Input "=Stretch_y" w/o quotes into cell D2;
   13. Input 6 into cell E2 and Format Cells Fill yellow.
5. Input Column Headers:

   1. A5: t: 0 to 2π
   2. B5: z
   3. C4 Charting ... D4: Charting
   4. C5: x: No z
   5. D5: y: With z
   6. E5: Adj_y
   7. Edit Go To cell range B6:B5765 and Insert Name Define name z to range $B$6:$B$5765;
   8. Edit Go To cell range E6:E5765 and Insert Name Define name Adj_y to range $E$6:$E$5765.
6. Enter series or formulas in columns:

   1. Edit Go To Cell range A6:A1445 and input 0 into A6 and "=2*PI()" into A1445 and do Edit Fill Series Trend OK. Copy this data section three more times until cell A5765 has 2pi in it.
   2. z: Edit Go To cell range B6:B5765 and enter into B6 w/o quotes the formula, "=c_*COS(a*A6)" and Edit Fill Down.
   3. x: No z: Edit Go To cell range C6:C5765 and enter into C6 w/o quotes the formula, "=(((b^2-c_^2*COS(a*A6)*COS(a*A6))^0.5*COS(A6)))" and Edit Fill Down.
   4. y: With z: Edit Go To cell range D6:D5765 and enter into D6 w/o quotes the formula, "=(Stretch_y*(((b^2-c_^2*COS(a*A6)*COS(a*A6))^0.5*SIN(A6))+z)+Adj_y)" and Edit Fill Down.
   5. Adj_y: Edit Go To Cell range E6:E1445 and input 2.9473;
   6. Select cell E1446 and input w/o quotes the formula "=Change+E1445". Edit Go To cell range E1447:E2885  and input into E1447 "=E1446" and Edit Fill Down.
   7. Select cell E2886 and input w/o quotes the formula "=Change+E2885". Edit Go To cell range E2887:E4325  and input into E2887 "=E2886" and Edit Fill Down.
   8. Select cell E4326 and input w/o quotes the formula "=Change+E4325". Edit Go To cell range E4327:E5765  and input into E4327 "=E4326" and Edit Fill Down. Fix the bottom border line.

Explanatory Charts, Diagrams, Photos

1. (dependent upon the tutorial data above)

1. Create the Chart:

   1. Select C4:D5 and make the font Italic. Select C6:D1445 and Format Fill Color Light Blue. This is the area of the bottommost single sphere of 4 spheres or cut spheres. Right now, with a,b and c_ set to 18, .8 and .6 respectively, we're doing cut sphere(s). Select cell range C6:D1445 and do Charts on the Ribbon (or Chart Wizard), All/Other, Scattered - Smoothed Line Scatter. Copy or Cut and Paste the chart which landed atop the data or to the side and paste in the Chart worksheet, where it should be pulled open to an approximate square at the lower left by hovering the cursor until it changes to the double-headed arrow and then grabbing the chart frame and pulling down and right. Select Chart Layout and get rid of Axes, Grid lines, and the Legend. Click in the Chart Area outside the Plot Area near the outer border and choose no line and no Fill. Do the same for the Plot Area. To do all the 4 spheres, select the cell range C6:D5765. In that case, the chart area will need to be a tall squeezed rectangle until the spheres appear round. You can Copy Picture atop the data to get an image like the one at the top of this article and use Grabber application if Copy Picture refuses to pick up the underlying data's image. Copy and Paste both data and a picture of your charts to the Saves worksheet.
   2. Try setting a,b and c_ to 100, .5 and .5 respectively and make sure the line weight is set to 1.

2. That's it, you're finished!

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.