![\"I](\"http:\/\/www.allyngibson.com\/graphics\/iching.jpg\")
A defining aspect of TMitHC<\/i> is the I Ching<\/i>, the Chinese book of divination. Wikipedia can explain it better (and at more length) than I<\/a>; basically, the I Ching<\/i> is an ancient Chinese system of divination that doesn’t so much tell the future as it explains the present and the forces that exist in the present that will shape the future.<\/p>\nVirtually all<\/i> of the novel’s major characters use the I Ching<\/i> at some point. Indeed, their major decisions are driven<\/i> by it. Business deals are made because of it. Sexual encounters and cross country road trips happen on its advice. An entire novel about another<\/i> alternate history is written according to it.<\/p>\n
I, just being twenty, had no idea what the I Ching<\/i> was. Indeed, I’d never even heard<\/i> of it before reading The Man in the High Castle<\/i>. But, as with all things, I was curious, and I eventually bought a copy. (For the record, it was on Election Day, November 1995, at the Barnes & Noble in Charlottesville, Virginia. I also bought a copy of White Wolf’s first volume of their omnibus reprinting of Fritz Lieber’s Fafhrd & the Gray Mouser stories there that day. The truly random things one remembers.)<\/p>\n
I can’t say that I used the I Ching<\/i> with any great regularity, or even with any purpose as Dick’s characters had. It was just something to experiment with. I learned the three-coin casting method, and at times I’d consult it, more often than not as a joke. I did attempt to plot a story with it, as Dick had done, but I found I ended up with nonsense. It was an interesting experiment, though, and as I was investigating alternate philosophies<\/a> in my developing atheism, I kept my copy of the I Ching<\/i> around. Indeed, I even bought a second copy for the office.<\/p>\n A few years later, I picked up another book of Chinese divination, the Ling Ch’i Ching<\/i> (or Ling Qi Jing<\/a><\/i>), the Spiritual Chess Classic. It’s similar but different; where the I Ching<\/i> uses coins or yarrow stalks for its casting, the Ling Ch’i Ching<\/i> uses twelve wooden Chinese chess pieces, inscribed with special markings. I went to a hardware store one day, bought twelve flat and round pieces of wood, inscribed them properly, and, again, experimented with the Ling Ch’i Ching<\/i>.<\/p>\n Interestingly, I probably use the I Ching<\/i> now more than I ever did in my experimental days. I have an I Ching<\/i> app for my phone, and I sometimes use it for fun. (At Farpoint, for instance, it suggested a dinner of ribs or buffalo wings. Not what I had. \ud83d\ude09 ) If I get blocked at the office, where I often have to write like there’s no tomorrow, I’ll pull out my copy of I Ching<\/i> there, open it up at random, and pull a visual image from the book to use as a springboard. And, if I want to do a full casting, rather than throw coins, I’ve gone high-tech.<\/p>\n I wrote an Excel spreadsheet.<\/p>\n The three-coin casting method for the I Ching<\/i> is, honestly, the worst you can use. The percentages come up wrong. Again, Wikipedia can explain better than I<\/a>, but basically, with the three-coin method, some results become far more likely than they should be with the traditional yarrow stalk method. My spreadsheet simulates a four-coin method, which produces results mathematically identical to the yarrow stalk method.<\/p>\n Is it cheating? There’s nothing physical to it, after all. I don’t think it’s cheating. I wrote the formulas myself to make it work. I wrote the underlying macro code. The working methods are mine, it’s as personal as coins carried in a pocket or a cherished bag of yarrow stalks. (For what it’s worth, I don’t even know what a yarrow stalk is<\/i>.)<\/p>\n Recently, I decided to do a similar spreadsheet for the Ling Qi Jing<\/i>, and I finished the coding today.<\/p>\n In concept, it’s actually much simpler. There’s only the one casting method — you have twelve wooden coins, and you flip them.<\/p>\n The Ling Qi Jing<\/i> had three “rows” — Heaven, Man, and Earth. Each row will have anywhere from zero to five “heads” showing. This produces 125 (5 cubed) different trigraphs.<\/p>\n My first thought was to figure each row separately, something along the lines of: This would produce, for each row, an integer from 0 and 4.<\/p>\n But I decided this wasn’t right. Oh, it was accurate, but it didn’t accurately model the way the Ling Qi Jing<\/i> would actually be cast, with all twelve coins flipped at random.<\/p>\n So I came up with a more complicated, but more accurate, procedure…<\/p>\n The commenting in the procedure explains it. A random coin out of the twelve is flipped, set aside, and then a coin from what remains is flipped. Thus there’s no order<\/i> to the way the coins are flipped. We aren’t artifically generating the Heaven line, then moving on to the next.<\/p>\n All things considered, writing the Ling Qi Jing<\/i> spreadsheet was far simpler than I expected. Even that routine, which looks more than a little complicated, worked correctly the second<\/i> time. \ud83d\ude09<\/p>\n Just because I wrote a spreadsheet for the Ling Qi Jing<\/i> doesn’t mean I’m suddenly going to start experimenting with it again. But if I do, the tool is there, like with the I Ching<\/i> spreadsheet I wrote two years ago.<\/p>\n Neither the I Ching<\/i> spreadsheet nor the Ling Qi Jing<\/i> spreadsheets work on their own. All they do is generate the hexagrams or trigraphs. A companion book is necessary to explain what the results mean<\/i>.<\/p>\n If anyone wants to try this for the I Ching<\/i> or the less-well-know Ling Qi Jing<\/i>, perhaps as an aid to their own investigations of Chinese divination, I’ve uploaded a ZIP file to my website<\/a> with both Excel spreadsheets.<\/p>\n Type your question or query into cell A1, press Alt-F8 to bring up the macros window, and run the appropriate macro. The spreadsheet does its work, and it will show you your results. Consult your book, and find your answers.<\/p>\n","protected":false},"excerpt":{"rendered":" Years ago, in college, I used to do what I called “binge reads.” One semester, I’d pick an author, and I’d read as much of that author’s work as I possibly could. One semester, it might be Orson Scott Card. Another semester, Larry Niven. I was young, just twenty or so, and I had theContinue reading “On Chinese Divination Methods”<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[52],"tags":[550,693,347],"class_list":["post-5693","post","type-post","status-publish","format-standard","hentry","category-life","tag-excel","tag-i-ching","tag-macros","entry"],"_links":{"self":[{"href":"http:\/\/www.allyngibson.com\/index.php?rest_route=\/wp\/v2\/posts\/5693","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.allyngibson.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.allyngibson.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.allyngibson.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.allyngibson.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5693"}],"version-history":[{"count":0,"href":"http:\/\/www.allyngibson.com\/index.php?rest_route=\/wp\/v2\/posts\/5693\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.allyngibson.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5693"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.allyngibson.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5693"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.allyngibson.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5693"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nRow = Int(Rnd * 2) + Int(Rnd * 2) + Int(Rnd * 2) + Int(Rnd * 2)<\/code><\/p>\n' Define some variables.
\nDim iLoop As Integer
\nDim iLen As Integer
\nDim iPos As Integer
\nDim sOne As String
\n'
\n' Each coin will be flipped randomly. First, we choose which coin it is --
\n' Heaven [A], Man [B], or Earth [C]. Then we flip it, and add its total
\n' (1 is up, 0 is down) to its row. Then, we remove that coin from the
\n' possible coins to be flipped. It's a little complicated, but it better
\n' models the way the coins are flipped in the Ling Qi Jing.
\n sOne = \"ABCABCABCABC\"
\n For iLoop = 1 To 12
\n iLen = Len(sOne)
\n iPos = Int(Rnd(iLen) + 1)
\n If Mid(sOne, iPos, 1) = \"A\" Then Cells(3, 1) = Cells(3, 1) + Int(2 * Rnd)
\n If Mid(sOne, iPos, 1) = \"B\" Then Cells(4, 1) = Cells(4, 1) + Int(2 * Rnd)
\n If Mid(sOne, iPos, 1) = \"C\" Then Cells(5, 1) = Cells(5, 1) + Int(2 * Rnd)
\n If iPos = 1 Then sOne = Right(sOne, (iLen - 1))
\n If iPos = iLen Then sOne = Left(sOne, (iLen - 1))
\n If iPos < iLen And iPos > 1 Then sOne = Left(sOne, (iLen - 1)) + Right(sOne, (iLen - 1))
\n Next iLoop<\/code><\/p>\n