Posts tagged excel
I discovered the graph of OneEye around early Nov-2004 after my close friend (Fred Rouda) asked me a freak question about the number 9. He asked, “Do you know anything about the number 9?” knowing I love things like this. I answered, “no, except it’s an upside down six.” He then said, “There’s something weird about it. Did you know, when you multiply 9 with ANY number, the resulting digits ALWAYS add up to 9?” I answered with a simple…“wow”. So I tested it!
Let’s see… 9×4=36, which =9 (when you add 3+6). Again 9×42=378… now 3+7+8=18…and 1+8=9!!! See? Trust me I did an excel calculation and found it does this till infinity (not that I could!). All multiples of 9 always add up to 9 when the resulting digits are reduced to their single-digit-sum. This concept is also known as the “Rule of Nines” and also “Modulo 9“.
How did the graph appear?
Well, being the insatiably inquisitive me… I hopped on my computer and thought I’d see what happens with all the basic numbers in our times tables, as this ‘9 theory’ really boggled my mind a little and invigorated it as well. I looked at all the numbers in our times-tables and noticed that after I added all the digits for each number, a repetitive pattern appeared. I found that the resulting numbers keep repeating itself infinitely, after every 9th column/row.
Here is the repeating 9×9 block of numbers in our times tables (after reducing each number to a single digit):
I later found that this is also know as the “Vedic Square” in Indian Mathematics. Now this is where I thought, I’d graph this section to see what comes up? Scatter graph… nothing. Line Graph… nothing. Bar graphs, Pie graphs, all showed nothing but straight lines and circles. Then…. I tried the WireFrameContouring graph and… voila! Out popped this eye! My jaw dropped and I ended up staring at it for a good hour or two, wondering what the *#*% it was?
It was soon after this little discovery that a lot of weird things started to happen to me. I started experiencing an increased level of awareness and knowledge. Eventually I realized this was my own spiritual journey and it was the weirdest 😯 year following after this but I won’t go into it now (it’s in the next post: What Followed After My Discovery). Remember that it all started with one question about one number… the number 9!
How To Bring Out “OneEye” From Our Times Tables
To do this yourself, all you need is a Microsoft Office Excel program (or more advanced contour graphing tools). Here is a step-by-step instruction on how you can do this too:
- Start a new page from your program and save it first under whatever name you want.
- Write down the numbers from the times-table starting from 1x’s to 9x’s into each cell. It should look something like this so far:
Times Table 1 2 3 4 5 6 7 8 9 x.1 1 2 3 4 5 6 7 8 9 x.2 2 4 6 8 10 12 14 16 18 x.3 3 6 9 12 15 18 21 24 27 x.4 4 8 12 16 20 24 28 32 36 x.5 5 10 15 20 25 30 35 40 45 x.6 6 12 18 24 30 36 42 48 54 x.7 7 14 21 28 35 42 49 56 63 x.8 8 16 24 32 40 48 56 64 72 x.9 9 18 27 36 45 54 63 72 81
(Note that I don’t go beyond the 9x’s table because the numbers after x9 repeat infinitely, so for example, all 10x’s results in the same sequence as the 1x’s and 11x’s = 2x’s etc, so you get it repeating over and over once you reduce each number to its “single-digit-root/sum”. Therefore, we will only use the 9×9 square – this will become evident to you further on).
- Now reduce each number above to single digit numbers by adding each. That is; if we look at 42, it adds to 6 as a single-digit-sum. Take 48 as well as an example and we get 12 in this case, so we further reduce 12, to 3 in the end. Now do this for each cell and you should get the Vedic Square as shown previously.
- Once you have this, you should surround the square with all 9’s like this (as it naturally should be);
- This is now your area to graph. Highlight this block (on your excel page) by holding your mouse over the first number (top left) and click-hold all the way through to the last number in the block (bottom right).
- Now go to the graphing tool bar in the “Insert” menu where you should see the “charts” charting tools bar (for MS Office 2007), otherwise it should be visible on the top bar in older versions.
- Go to the “Surface” graphing area and select the “Wireframe Contour” graph (NOT the 3D one!) … and click on it.
- To get the graph to show up quickly, just click “next” to anything asked and that should lead you to the final resulting graph. You can remove the info around the axis’ later.
- Congratulations! 😀 You should now see a graph of an eye (“OneEye”) exactly like this:
If you want an excel sheet showing how this is done just send me a request via my contact form, or email to: info(at)eyephi.com. Enjoy!