Another Method

Another Method of Angle Calculation on the Square of Nine In the book we provide a formula for calculating angles on the Square on Nine that is attributed to Carl Futia. If converted to a paper version of the Square of Nine Futia's formula would place the squares of the odd numbers (1,3,5,…) on the 315 degree angle and the squares of the even numbers (2,4,6,…) on the 135 degree angle, and 0 in the center of the table instead of the numeral 1. This is the formula that we use for our personal work because it is both effective and easy to use. The Gann Wheel, which is the best known Square of Nine, has the numeral 1 in the center of the table, the squares of the odd numbers on the 315 degree angle, and the even number squares "floating" towards the 135 degree angle as they increase in magnitude. Having read our book you also know that Gann used a Square of Nine table consisting of exactly 81 numbers (9 rows * 9 columns) with the numeral 1 in the lower left corner. Unfortunately, Gann never left any writings explaining how he used this particular version. We use Carl Futia's formula exclusively and only very seldom even refer to the Gann Wheel, or the paper version of the Square of Nine. However, for the sake of completeness we provide here a set of Excel calculations that will convert any number as it would appear on the Gann Wheel  to an angle. 1. Find the ring on the Wheel Wheel containing NUMBER. Ring# = Round(((SQRT(NUMBER) - 0.22) / 2), 0) 2. Convert NUMBER to a 315 degree angle. 315 degree angle = (Ring# * 2 +1)^2 3. Find the Zero Angle on Ring# Zero Angle = ((Ring# * 2 + 1)^2) - (7 * Ring#) 4. Convert to the Angle of of NUMBER Angle = Sum ((NUMBER - Zero Angle) / (Ring#/45)) Using 390 as an example of NUMBER you can check your formulae entries: 1. Ring# = (((SQRT(390) (((SQRT( 390) - 0.22) / 2),0) = 10 2. 315 degree angle = (10 * 2 + 1) ^2 = 441 3. Zero Angle = ((10 * 2 + 1) ^2) - (7 * 10) = 371 4. Angle = Sum((390-371) / (10/45) = 85.50 degress