Since you have already done the tedious 'enter individual values in a spiral' step, I considered using this block as a helper block.Ģa) First I want this block to start at 0 in the center, so I enter 1 into a convenient cell, select this cell -> copy -> select B8:T26 -> Paste Special -> subtract. It would be a bit tedious to set up the first time, but once it is set up (and protected from accidental editing), it should do the task just fine.Ģ) Build an addition matrix. My first thought with the exact question you asked (how to build the spiral sequence), I thought of two approaches:ġ) In J17, enter =K17+1. Depending on exactly what you need from us, you may need to help us understand Gann analysis before we can help you program it into the spreadsheet.

I expect that experts in financial analysis have heard of Gann, but not all of us who are experts in spreadsheet programming are simultaneously experts in financial analysis. A quick internet search finds that Gann analysis is a type of financial/stock analysis originating with a gentleman named Gann before World War 1. I find it unwise to assume that we are experts in anything other than spreadsheet programming.