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.