How to Program Excel to Show Spheroids Visiting Their Home Planet

The Tutorial

1. How to Program Excel to Show Spheroids Visiting Their Home Planet Picture 1
   How to Program Excel to Show Spheroids Visiting Their Home Planet Picture 2
   Open a new Excel workbook and create 4 worksheets named: Data, Goal Looker, Chart and Saves unless working from the workbook formerly created, How to Create a Cyclical Chart Using Spheroids. If using that workbook saved under a new name for this article, look for the word NEW or MODIFIED by the Step or Sub-Step (as otherwise all but the last few steps were directly copied and organized into sub-steps). Save the workbook under the filename that makes sense to you in your line of endeavor. The source file for this article is "Eggies.xlsx".
2. Open Preferences. 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 -- Automatically and calc before save, max change .000,000,000,000,01 w/o commas if you do goal-seeking a lot 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.
3. Create Defined Name variables:

   1. MODIFIED: In the cell range A1:N1, input the following Variable Names: A1: AjRows; B1: GM (for Golden Mean); C1: Factor1; D1: Factor2; E1: Number; F1: NewDate1; G1: GMSL (for Golden Mean Short Leg); H1: KEY; I1: KEY2_; J1: Variable; M1 Eggies4; N1: ShrinkExpand4
   2. MODIFIED: Select cell range A1:N2 and Insert Name Create (Create Names in) Top Row. Select cell range A2:N2 and do Format Cell Border Outline Left Right Top Bottom Outline Black Bold. Do Format Cell Font Color (fire engine) Red. That is because typically these variables won't be changed.
   3. MODIFIED: In the cell range A3:L3, input the following Variable Names: A3: Tip B3: Base; C3: Spheroids; D3: ShrinkExpand; E3: PiDivisor F3: NewDate2; G3: Base2; H3: Spheroids2; I3: ShrinkExpand2; K3: ShrinkExpand3; L3: Base4
   4. MODIFIED: ISelect cell range A3:L4 and Insert Name Create (Create Names in) Top Row. Select cell range A4:L4 and do Format Cell Border Outline Left Right Top Bottom Outline Black Bold. Do Format Cell Font Color (fire engine) Red. That is because typically some of these variables will change but most will not.
4. Input variable values in row 2: A2: input 2880; Insert New Comment and edit in 2880.
5. B2: input "=(-(1-SQRT(5))/2)^IF(Spheroids<24,1,1)"
6. MODIFIED: C2: input "=VLOOKUP(ABS(Spheroids),LOOKER,IF(Spheroids<=24,3,3))"
7. MODIFIED: D2: Input "=VLOOKUP(ABS(Spheroids),LOOKER,IF(Spheroids<=24,2,2))"
8. E2: Input 1. This variable, Number, is not being used at present. It's purpose is to warp or skew the output via incorporation into the formulas in cell range C6I2886. Insert a New Comment if you like.
9. F2: Input "=1954/9/2". This variable, NewDate1, is not being used at present. It's purpose is to warp or skew the output personally via incorporation into the formulas in cell range C6: I2886. It is a birth date in format yyyy/mm/dd, i.e. a double quotient. Insert a New Comment if you like.
10. G2: Input "=1-(-(1-SQRT(5))/2)^IF(Spheroids<24,1,1)"
11. MODIFIED: H2: Input "=IF(Spheroids>=31,Spheroids/30,Spheroids)" w/o the quotes. Insert New Comment and edit in "Keeps Spheroids round. Formula now is =IF(Spheroids>=31,Spheroids/30,Spheroids)". Expand the comment frame if need be.
12. MODIFIED: I2: Input "=IF(Spheroids>=30,Spheroids,Spheroids2)" w/o the quotes. Insert New Comment and edit in "Keeps Spheroids2 round. New formula is =IF(Spheroids>=30,Spheroids,Spheroids2)". Expand the comment frame if need be.
13. NEW: In J2, enter 1.
14. NEW: In M2, enter 40.
15. NEW: In N2, enter .1

Explanatory Charts, Diagrams, Photos

1. (dependent upon the tutorial data above)

1. Create the Chart.
   1. Activate Data worksheet and Edit Go To under Main X and Main Y cell range E6:F2886. Either do Chart Wizard or select Chart on the Ribbon (activated in Preferences) and select All, Scattered, Smoothed Line Scattered. If using Chart Wizard, a new Chart worksheet will be created. Otherwise, copy or cut and paste the chart into the upper left corner of the Chart worksheet you created at the beginning, and hover the mouse over the lower right corner until it becomes a double-headed arrow and then use it to pull the chart into an expansion of a large Square. Format Selection Glow yellow transparency 25% and Line Weight 1 and Bright Blue from the color table. This is the chaotic planet surface.
   2. On the Chart worksheet, do menuitem Chart Add Data. In response to the Range request, activate the Data worksheet again and Edit Go To under Second X and Second Y cell range H6:I2886. When I do it, it does not work right and it takes column E instead of column H. Click on the second standard ring series, or double-click until it appears in the formula bar and edit it until it reads as follows: =SERIES(,Data!$H$6:$H$2886,Data!$I$6:$I$2886,2). Edit the line of Series 2 to be dashed and 1 point line weight and Foresty Green to Lawn Green to Leafy Green in hue. It's a yellowish-green, not a blue-green with a very light yellow very transparent glow. This is the external planet ring.
   3. The first series, after clicking on it, should read as follows: =SERIES(,Data!$E$6:$E$2886,Data!$F$6:$F$2886,1). Any other series which Excel creates should be deleted by clicking on it and deleting it from the Formula Bar.
   4. DELETED: Edit Series 1 ( the one with the last digit = to 1 in the series formula, and the one randomized or input by you or spirallic) by double-clicking on it for line weight = .25, glow = canary yellow size 8 point 25% transparent, if you want to start off resembling mine.
   5. On the Chart worksheet, do menuitem Chart Add Data. In response to the Range request, activate the Data worksheet again and Edit Go To under RoseX and Rose Y cell range J6:K2886. When I do it, it does not work right and it takes column E or something instead of column J and K. Click on this next/center series3, or double-click until it appears in the formula bar and edit it until it reads as follows: =SERIES(,Data!$J$6:$J$2886,Data!$K$6:$K$2886,3). Edit the line of Series 3 to be 1 point line weight and very light pink to light maroon in hue. It's a very light orange very transparent glow. This is the central heart of the planet and it's a charming radial rose.
   6. On the Chart worksheet, do menuitem Chart Add Data. In response to the Range request, activate the Data worksheet again and Edit Go To under EGGIES X and EGGIES Y cell range M6:N2886. When I do it, it does not work right and it takes column E or something instead of column J and K.This time, that is the effect we want, so click on the series formula in the formula bar and edit it until it reads: =SERIES(,Data!$E$6:$E$2886,Data!$N$6:$N$2886,1). Edit the line of Series 1 (it's been reset to be series 1 visa that last digit in the series formula) to be 1 point line weight and very bright blue in hue.. These are the visiting spheroids and they're very glad to be home.
   7. To make the other picture we want EGGIES X and EGGIES Y cell range M6:N2886. When I do it, it does not work right and it takes column E or something instead of column J and K.This time, that is NOT the effect wanted, so click on the series formula in the formula bar and edit it until it reads: =SERIES(,Data!$M$6:$M$2886,Data!$N$6:$N$2886,1). Edit the line of Series 1 (it's been reset to be series 1 via that last digit in the series formula) to be 1 point line weight and very bright blue in hue.. These are the visiting spheroids and they're very glad to be home.
   8. Double-click on the Plot Area and set the Gradient to be Radial, Centered, Dark Purple on left and Prussian Blue on right. My pigments are all put away right now or it would be easier to say if it was Prussian, Cerulean, Ultramarine, Cobalt or some other blue. Sorry - get them mixed up. I have No Line set for either the Plot Area or the Chart Area, no Chart Titles, No Axes which are all controlled by Chart Layout (which appears on the Ribbon when you click on the Chart Plot Area).
   9. Copy the formulas  from A1:X34 to the Saves worksheet and then, below the formulas, paste them again, and then do Paste Special Values right over them. Then with the shift key held down, tale a picture of the chart under each of the two series definitions, Pasting Pictures with the shift key depressed into the Saves worksheet under the data.
   10. Save the workbook.
2. 
   
   
   How to Program Excel to Show Spheroids Visiting Their Home Planet Picture 3
   
   
   
   How to Program Excel to Show Spheroids Visiting Their Home Planet Picture 4

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.

1. Here are larger versions of the two charts -- first the version charting columns M and N:
   How to Program Excel to Show Spheroids Visiting Their Home Planet Picture 5 Visiting Home Planet 2a
2. Next, the version charting columns E and N:
   How to Program Excel to Show Spheroids Visiting Their Home Planet Picture 6 Visiting Home Planet 1a
3. The original version, whose numbers are now lost to poor recordkeeping:
   How to Program Excel to Show Spheroids Visiting Their Home Planet Picture 7 Visiting Home Planet 2a Original.
4. And its companion piece:
   How to Program Excel to Show Spheroids Visiting Their Home Planet Picture 8 Visiting Home Planet 1a Original
5. After a couple of changes, the following improved images were created. The changes were 1) In the Rose worksheet, the formula for the x (and y, relatively with sin) value was changed to "=I6*COS(Theta*Converter)+COS((ROW()-6)*PI()/180)"; and 2) in the Goal Looker worksheet, I used the formula "=randbetween(70,95)/100" in column B. I also changed ShrinkExpand3 to -1.8, and here are the results:
   How to Program Excel to Show Spheroids Visiting Their Home Planet Picture 9 Visiting Home Planet 2b
6. How to Program Excel to Show Spheroids Visiting Their Home Planet Picture 10 Visiting Home Planet 1b
7. Changing Rose's n from 30 to 45 and copying the original data from an historical copy I finally found in an old file the column B data for the Goal Looker worksheet (but column C long since changed), it comes as close as it's going to get to the original:
8. How to Program Excel to Show Spheroids Visiting Their Home Planet Picture 11 Visiting Home Planet 2c
9. How to Program Excel to Show Spheroids Visiting Their Home Planet Picture 12 Visiting Home Planet 1c
10. Still not as good as the original but time is limited. See what you come up with!! Have fun!!

1. ERRORS: If there are errors or error values, either the sheet in incomplete and needs further input or Lookup Tables for critical variables or perhaps there's a mistake somewhere along the line. If the instructions have been completed and there are still errors, select the cell that has the error value that is furthest left and topmost first. Look for a typo in a formula or unmatched parentheses. Possibly, a Defined Name is wrong -- they need to be input into the formulas exactly as they were defined. Do Insert Name Define to check. If there is a #DIV/0! error, the example does not, so look for a variable that somehow did not get filled in with a value perhaps. At any rate, what to do is select the cell with the error, and after checking all those typical errors, do Tools Auditing Trace Precedents and/or Trace Error. If fixing all the topmost leftmost errors does not fix the rest of your errors on the worksheet, one may need to do it the hard way, from the bottom right upwards then leftwards; that is the slow but sure way to fix all errors.
2. Also, errors in the chart data will most likely plot as zeroes. This may be acceptable or desirable even. However, if too many lines (or curves) are returning to 0, it may indicate a logical flaw in the data -- or too many tiny values and then perhaps rescaling the chart is needed by inspecting the horizontal and vertical axes and changing them to zero in on the problem. Hover over or click on a data marker on the series plot and then do a search in the proper column by value for that value, and identify its precedents.

1. Create a Slideshow of Excel Images
2. Create a Cyclical Chart Using Spheroids
3. Create a Cloudy Moon or Planet with Excel
4. Create a Dakini and Boddhisattva Aspect of the Mother Planet
5. Create the Photon Emission Image
6. Create the 3 Transformative Mother Planet Receptacle Images
7. Create the Idea of an Idea Image
8. Create a Lemniscate Spheroid Curve
9. Create an S Curve Pattern in Microsoft Excel
10. Create a Curve in Excel
11. Make Your Excel Curve Solid or Transparent

1. "CRC Standard Curves and Surfaces", David von Seggern, 1993, CRC Press Inc., Boca Raton, FL. ISBN 0-8493-0196-3, Library of Congress Card Number 92-33596, [pp. 264 7.1.4 Spherical Helix]
2. The source workbooks for this article are "EGGIES.xlsx", "EGGIES 01.xlsx" as well as some Saves files for pix.