Tips 'N Tricks 198: Humminbird HELIX - How Simple to Get Started
How to Acquire an N Helix with Spheroids Image
- Become familiar with the basic image to be created:
It helps placing the cursor at cell A14 and doing Freeze Panes.
MODIFIED:Create some Defined Name Variables.
- Into cell A1, type AjRows.
- Into cell B1, type GM (for Golden Mean).
- Into cell C1, type Factor1.
- Into D1, type KEY.
- Into cell E1, type Number.
MODIFIED:Select cells A1:E2 and Insert Names Create in Top Row. Into cell A2, input 2880 (as the number of adjusted rows in the data-set). In cell B2, input the formula "=-(1-sqrt(5))/2" (without quote marks). This is the Golden Mean or Ratio or Proportion, known since Euclid's time, such that a:b as b:(a+b), and is quadratic and has many special properties -- it's used because it maintains in proportion the square of a number to the number such that for the Pythagorean Theorem, a given Pythagorean triplet will grow in constant proportion to itself, and since the sine and cosine functions are Pythagorean functions, it applies to them as well. In cell C2, input .125 or "=1/8". Into cell D2, input w/o quotes "=IF(Spheroids<=24, Spheroids*VLOOKUP(Spheroids,LOOKER2,2)*2,Spheroids". Into cell E3, type 1.
MODIFIED:Create some more Defined Name Variables.
- Into cell A3, type Tip.
- Into cell B3, type Base.
- Into cell C3, type Spheroids.
- Into cell D3, type ShrinkExpand.
- Into cell E3, type PiDivisor.
- Into cell F3, type Thickness.
- Into cell G3, type ShrinkExpand2
- Into cell H3, type Variable.
MODIFIED:Select cells A3:H4 and Insert Names Create in Top Row.
MODIFIED:Input the formulas and values to row 4.
- Into cell A4, input "=Base*12/(VARIABLE*1)*PI()" -- the empty parentheses for pi are correct. Do Insert Name Define name as Tip for cell A4.
- Into B4, input 1712, which is 2^4 * 107 (where 2^4 means 2 raised to the power of 4).
- Into cell C4, type 120 for now -- the lookup table that is going to be prepared is set to take any number of spheroids up to 150.
- Into cell D4, type 2 for now. Setting up another plot column set of data with ShrinkExpand set to a different value will insert or surround one circle of spheroids with another one.
- Into cell E4, input 180. Differentiating this variable creates special effects.
- Into cell F4, type 2.
- Into cell G4, type 2.
- Into cell H4, type 1.
MODIFIED:Select cells A2:G2 and Format Cells Border thick line Top Bottom Sides Center and format number with 4 decimal places. Do the same for cell range A4:G4 please.
MODIFIED:Put the entire sheet in font Lucida Fax size 9 by selecting the very top left cell between A and 1 for column and row and thus select the entire worksheet. Generally, viewing 4 decimal places will inform one of the differences in the sine and cosine function results.
MODIFIED:Create the Column Headings.
- Into cell A5, type Base t.
- Into cell B5, type c.
- Into cell C5, type Cos (for cosine).
- Into cell D5, type Sin (for sine).
- Into cell E5, type Main X.
- Into cell F5, type Main Y.
- Into cell G5, type Second X.
- Into cell H5, type Second Y.
MODIFIED:Input the t and c Formulas.
- MODIFIED Into cell B6, input the formula, "=(Base*24/Spheroids)". Into cell B7, type "=B6". Do Edit Go To cell range B7:B2886 and do Edit Fill Down.
- Into cell A6, input "=If(odd(Spheroids)=Spheroids,0,Tip)". This formula states that if the number of spheroids input is odd, result=0, else result=Tip (where Tip was defined above as 12*PI()*B4 or 1712, for a total of 64,540.8795). In the case of the result becoming 0, the column will decrement to twice Tip, negatively from 0. The number of spheroids charted will be odd, eg. 31.
MODIFIED:Do Edit Go To cell range A7:A2886 and input "=(A6+(-Tip*2)/(AjRows))" into cell A7, then do Edit Fill Down. The value in cell A2886 should be decremented to -64,540.8795 if spheroids is even (eg. at 32), else it will equal 2*-64,540.8795. Please see Note 6 in the Tips section regarding differentiating cells A7 and A6 because their formulas are different.
MODIFIED:Input the (Adjusted) Cosine and Sine formulas.
- Do Edit Go To cell range C6:C2886 and input into cell C6 the formula, "=Thickness*Spheroids/KEY*(COS((ROW()-6)*Number*PI()/PiDivisor*Factor1))" (without the quotation marks, as always). Do Edit Fill Down. By taking the cosine of the cell 6 rows up from cell C6, we are taking the cosine of 0 to begin with, then in subsequent rows, take the cosine up to 360 and in cycles then to 2880+6. 2880/360=8. So there are 8 cycles. Number is a variable for getting partial circle effects like animation motion likenesses when a fraction because the next piece, *PI()/PiDivisor. converts from pi radians to degrees and vice versa. Recall that PiDivisor is set to 180 degrees. Multiplying by Factor1 is taking back the 8 by 1/8th.
- Do Edit Go To cell range D6:D2886 and input into cell D6 the following formula: "=Thickness*Spheroids/KEY*(SIN((ROW()-6) *Number*PI()/PiDivisor*Factor1))". Do Edit Fill Down.
MODIFIED:Input the Main X and Main Y Formulas. Do Edit Go To cell range E6:E2886 and input into cell E6 the following formula: "=((SIN(A6/(B6*2))*GM*COS(A6)*GM)+U6)/ShrinkExpand". Do Edit Fill Down.
- Do Edit Go To cell range F6:F2886 and input the formula "=((SIN(A6/(B6*2))*GM*SIN(A6)*GM)+W6)/ShrinkExpand". Do Edit Fill Down. You may notice the z-dimension has been omitted.
NEW/MODIFIED:Input the Second X and Second Y Formulas. Do Edit Go To cell range G6:G2886 and input into cell G6 the following formula: "=((SIN(A6/(B6*2))*GM*COS(A6)*GM*(COS(A6/(B6*2)))*GM)+C6)/ShrinkExpand2". Do Edit Fill Down.
- Do Edit Go To cell range H6:H2886 and input into cell H6 the formula "=((SIN(A6/(B6*2))*GM*SIN(A6)*GM*(COS(A6/(B6*2)))*GM)+D6)/ShrinkExpand2". Do Edit Fill Down.
MODIFIED:Input the LOOKER table. While the sheet will now produce the chart wanted, for small numbers of spheroids like 1 or 2 or 3, they cannot appear in a ring properly. A solution for that contingency has been worked out.
- Do Edit Go To cell range I6:I155 and input 1 into cell I6 and then do Edit Fill Series Columns Linear, Step Value 1 and blank stop value; press OK. That should input the series from 1 to 150 in that cell range.
- Do Edit Go To cell range J6:J155 and input into cell J6 .125 and then do Edit Fill Down. That will input the constant value of .125 in that cell range.
- Do Edit Go To cell range K6:K155 and input "=I6*$K/$I" and do Edit Fill Down and then input the value .125 in cell K35.
- Do Edit Go To cell range I6:K155 and Insert Name Define Name Looker. Format Cells Border Red bold Outline. Input Looker in cell J5, font bold red.
- Go to Factor1 cell C2. Input the formula, "=VLOOKUP(ABS(Spheroids),Looker,IF(Spheroids<=24,3,2))". If that next to last number is changed from 3 to 2 in the VLookup Formula just given, it will always return .125, otherwise it will adjust for the number of spheroids input the value of Factor1 (so that will no longer be an available variable). Change the font of cell C2 to dark blue italic or something red or something that helps one remember not to change it.
MODIFIED/NEW:Input the (original) LOOKER2 vlookup table.
- Select cell L5 and enter LOOKER2 into it.
- Edit Go To cell range L6:29 and input 1 into L6 and do Edit Fill Series Column Linear Step Value 1, OK.
- Enter the following numbers down from cell M6 to M29: 24, 16, 8, 4, =PI(), =PI(), =PI(), 2 from M13 to M21 and enter 1 from M22 to M29.
NEW:Enter the HELIX DATA table constants and formulas.
- Enter HELIX DATA into cell N1.
- Enter X Stretch into cell T1. Font red.
- Enter Y Stretch into cell W1. Font red.
- Enter 5 into cell T2 and format fill yellow font red and do Insert Name Define name X_Stretch to cell $T.
- Enter 5 into cell W2 and format fill yellow font red and do Insert Name Define name Y_Stretch to cell $W.
- Enter ±6π or +/- 6 pi into cell Q4.
- Enter the column headings into row 5: N5: a; O5: c; P5: n; Q5: t; R5: (i); S5: z; T5: X1; U5: 90 degrees X2; V5: X3; W5: Y.
- a, c, n: Enter .3 to cell N6, 3 into cell O6 and 1 into cell P6. Select N6:P6 and Format Fill yellow for input. Enter "=N6" into cell N7 and copy it and paste it to cell range N7:P2886.
- t: Select cell Q6 and enter "-6*PI())". Go to cell Q2889 and enter 6, font red, size 14, fill yellow. Go to cell Q2888 and enter "=PI()". Go to cell Q2887 and enter "=Q2889*Q2888" w/o quotes and do Insert Name Define Name Destiny to cell $Q87. Edit Go To cell range Q7:Q2886 and enter into cell Q7 w/o quotes the formula "=Destiny*2/2880+Q6" and Edit Fill Down.
- (i): Leave column R blank for now. More will be said in Tips.
- z: Edit Go To cell range S6:S2886 and enter w/o quotes into S6 the formula "=Q6/(2*PI()*O6)".
- X1: Edit Go To cell range T6:T2886 and enter w/o quotes into T6 the formula "=X_Stretch*(N6*COS(Q6+(2*PI()*R6)/P6)+S6)".
- 90 degrees X2: Edit Go To cell range U6:U2886 and enter w/o quotes into U6 the formula "=(T6-0.3-S6)". This is the column currently accessed by the chart.
- X3: Edit Go To cell range V6:V2886 and enter w/o quotes into V6 the formula "=-1*(T6+0.3+S6)". This is changed in The Tips section below when creating a Double Helix is accomplished.
- Y: Edit Go To cell range W6:W2886 and enter w/o quotes into W6 the formula "=Y_Stretch*(N6*SIN(Q6+(2*PI()*R6)/P6)+S6)".
- Edit Go To cell range N1:W2889 and Format Fill very light blue and Border Deep Purple bold Outline.
It is also a good idea to do Insert Comment a copy of all the formulas so far into the cells so there are always the original formulas should they ever be overwritten.Do that now for cell C2 until you see the red corner flag and remember to do it for all the other formulas later please. The Abs() Absolute function allows one to input a negative number of spheroids; the effect will be to flip the graph 180 degrees horizontally (from left to right or right to left), as one can tell with an odd number of spheroids.
Explanatory Charts, Diagrams, Photos
- (dependent upon the tutorial data above)
Create the Chart.Have a blank worksheet ready to copy a new chart into and expand and format it at will.
- Do Edit Go To cell range E6:F2886. Press the Charts button, All, or Chart Wizard. Select chart type Scatter Smoothed Line Scatter. Command c copy it and access the new worksheet and command v paste it into the new worksheet. Your chart should look like the example above except for detailing and the arc above has yet to be added. Adjust the chart size by dragging the bottom right corner until you get a square plot area. Get rid of the Vertical and Horizontal Axes, Legend and Gridlines via the Chart Layout tab. Clicking on the plot area will give access to the gradient style; the setting for that are Plot Area Fill Gradient Radial Centered Far Left White, 30% Ultramarine Blue, 55% Deep Navy Blue, no Line, Shadow, Glow or 3-D Format. Double-clicking on the chart plot line itself will give access to changing that under Format Selection of Chart Layout: set Series 1 Line to Ultramarine Blue, smoothed line, weight 1 pt. Glow is medium dark muddy red wine 1 pt 0 transparency 0 pt soft edges. Shadow for the line is checked, Perspective, 248 degrees, dark navy blue 33% size, 0 pt blur, 72 pt distance and 11% transparent. Chart Area Fill Gradient is Radial Centered left 41% White and fully right 100% Hot Pink Fuschia.
- Click in the Plot Area and do menuitem Chart Add Data and in response to the query go to Data worksheet and select cell range G6:H2886. Sometimes this does not come out right and has to be edited in the formula bar of the Chart worksheet. Click on the newly plotted series and edit in the formula bar until it reads as follows: "=SERIES(,Data!$G:$G86,Data!$H:$H86,2)". With it selected and Chart Layout active, do Format Selection for Series 2, Line Dark Brown with a hint of red, smoothed line, 0% transparency, line weight 1 point, No Shadow or Glow, etc.
Shrink the chart on the original Data worksheet and put it at the bottom of the data.
On the Chart worksheet, select menuitem Chart Add Data and then select back on the Data sheet cells G6:H2886 and hit OK.Somehow it comes out wrong sometimes and one must click on the new chart series in the Chart worksheet and type in G's for E's in the plot series in the formula bar -- then it's OK.
There should now be two series:1) =SERIES(,Data!$E:$E86,Data!$F:$F86,1) and 2) =SERIES(,Data!$G:$G86,Data!$H:$H86,2). They should be separate with the first series inside the second series. Select a good color for the second series and line thickness should probably be set to 1 for each.
Make use of helper articles when proceeding through this tutorial:
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
- X1 and Y: Columns T&W: X_Stretch = 1; Y_Stretch = 5
X1 and Y [(i) = blank); n=1]
- X2 and Y: Columns U&W: X_Stretch = 1; Y_Stretch = 5
X2 and Y [(i)=blank; n=1]
- X3 and Y: Columns V&W: X_Stretch = 1; Y_Stretch = 5
X3 and Y [(i)=blank; n=1]
- Nearly Vertical X2 and Y: Columns U&W: X_Stretch = 2; Y_Stretch = 5
Nearly Vertical Helix
- Still Nearly Vertical Helix X2 and Y with N=2 -- no change due to N=2 (no doubling of Helix). X_Stretch = 2; Y_Stretch = 5
X2 and Y N=2, X_S=2, Y_S=5
- (i) set to vary from 1 up to 2 in a series. Still no helix doubling (as had seen before??). Curious. X-Stretch = 1, Y-Stretch = 5. First, showing X2 and Y:
X2 and Y; (i) series from 1 to 2
- Main Chart under same conditions:
X2 and Y (i) in series; Main Chart
- Change of formula for column V to "=U6*-1". Charting U&W and V&W columns or X2,Y and X3,Y with N=2, (i) in series for 1 to 2, X_Stretch = 1 and Y_Stretch = 5:
X2, Y and X3, Y Double Helix.
- Main Chart, charting Helix from E&F only still:
E&F helix only still
- '* Second X in column G changed from "=((SIN(A6/(B6*2))*GM*COS(A6)*GM*(COS(A6/(B6*2)))*GM)+C6)/ShrinkExpand2" to "=((SIN(A6/(B6*2))*GM*COS(A6)*GM*(COS(A6/(B6*2)))*GM)+V6)/ShrinkExpand2" ... and Second Y in column H changed from "=((SIN(A6/(B6*2))*GM*SIN(A6)*GM*(COS(A6/(B6*2)))*GM)+D6)/ShrinkExpand2" to "=((SIN(A6/(B6*2))*GM*SIN(A6)*GM*(COS(A6/(B6*2)))*GM)+W6)/ShrinkExpand2" and here is the resulting chart, squeezed to get better sphere roundness:
Voila - Double Spheroid Vertical Helix
- Forgot to take out the z-dimension! Second X now reads "=((SIN(A6/(B6*2))*GM*COS(A6)*GM)+V6)/ShrinkExpand2" and Second Y now reads "=((SIN(A6/(B6*2))*GM*SIN(A6)*GM)+W6)/ShrinkExpand2", to produce this chart:
Voila! Now it\'s done
- It is still a good idea to do Insert New Comment a copy of all the Original formulas and Defined Name Values into the cells so there are always the original formulas should they ever be overwritten. It's a lot easier having them right there in a comment than trying to find them here in the instructions. Changing the worksheets is half the fun!! More than half!! Just be scientific about it and keep notes as you go.
Final Data Check 1
Final Tables Check 2
- If you are getting an error, it's probably because of a missing parenthesis, so count that the lefts = the rights and look to see that you have them placed exactly as given. If you are getting an undefined name error, it means that "GM" is not properly associated with cell B2 -- go back and Define Name that variable again, without quotation marks. Otherwise, it's ShrinkExpand for cell D4. If either of those cells or any previous cell contains an error value, go back and fix it according to the above instructions.
- 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.
- 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.
Sources and Citations
- The Garthwaite Curve shown was first created by Chris Garthwaite in May of 1994 and is based upon the Spherical Helix found on page 264 aling with the n-Helix of "CRC Standard Curves and Surfaces" by David von Seggern, CRC, ANN ARBOR, 1993.
Video: Nintendo Switch - Fortnite promotion - Double Helix Bundle - 1,000 V-Bucks
How to Add Another Language to Your Computer Keyboard
Sugar Smart Energy Bars
How to Organize Your Fabric Stash
2013 Short Layered Hairstyles, Razor Haircuts
Happy Saint Patrick’s Day Meet 6 Designers FromIreland
Watch the Trailer for Reese Witherspoons New Movie Home Again
The Surprising Fashion Item That Sorority Girls Are Obsessed With
Chloë Grace Moretz Might Have Been Invited to Join Taylor Swift’s Squad, Might Have Said NoThanks
Gluten-Free Frozen Waffles
Why Do Women With Atrial Fibrillation Die More Often Than Men
How to Make Wedding Gift Bags
Date: 11.12.2018, 03:50 / Views: 51194