| A | B | C | D | E | |
| 1 | 西元 | 1969 | |||
| 2 | 己酉 | 雞 | |||
| 3 | |||||
| 4 | 相沖 | 卯 | 日時 | ||
| 5 | 三殺 | 辰 | 日時 | ||
| 6 | 三刑 | 酉 | 日 | 三六合 | |
| 7 | 貴化 | ||||
| 8 | 日辰 | 沖↓ | 生年 | ||
| 9 | 丙申 | 庚寅 | 1950 | 2010 | |
☆☆………………………………………………………………………………………………………
輸入：1969、丙申
A2=VLOOKUP(B1,Sheet3!$A:$C,2,FALSE)
B2=VLOOKUP(B1,Sheet3!$A:$C,3,FALSE)
C4=IF(RIGHT(A2,1)="子","午",IF(RIGHT(A2,1)="丑","未",IF(RIGHT(A2,1)="寅","申",IF(RIGHT(A2,1)="卯","酉",IF(RIGHT(A2,1)="辰","戌",IF(RIGHT(A2,1)="巳","亥",IF(RIGHT(A2,1)="午","子", IF(RIGHT(A2,1)="未","丑",IF(RIGHT(A2,1)="申","寅", IF(RIGHT(A2,1)="酉","卯",IF(RIGHT(A2,1)="戌","辰", IF(RIGHT(A2,1)="亥","巳"))))))))))))
C5=IF(RIGHT(A2,1)="子","未",IF(RIGHT(A2,1)="丑","辰",IF(RIGHT(A2,1)="寅","丑",IF(RIGHT(A2,1)="卯","戌",IF(RIGHT(A2,1)="辰","未",IF(RIGHT(A2,1)="巳","辰",IF(RIGHT(A2,1)="午","丑", IF(RIGHT(A2,1)="未","戌",IF(RIGHT(A2,1)="申","未", IF(RIGHT(A2,1)="酉","辰",IF(RIGHT(A2,1)="戌","丑", IF(RIGHT(A2,1)="亥","戌"))))))))))))
C6=IF(RIGHT(A2,1)="子","卯",IF(RIGHT(A2,1)="丑","戌",IF(RIGHT(A2,1)="寅","巳",IF(RIGHT(A2,1)="卯","子",IF(RIGHT(A2,1)="辰","辰",IF(RIGHT(A2,1)="巳","寅",IF(RIGHT(A2,1)="午","午", IF(RIGHT(A2,1)="未","戌",IF(RIGHT(A2,1)="申","巳", IF(RIGHT(A2,1)="酉","酉",IF(RIGHT(A2,1)="戌","丑", IF(RIGHT(A2,1)="亥","亥"))))))))))))
B9=VLOOKUP(A9,Sheet2!$A:$B,2,FALSE)
C9=VLOOKUP(B9,Sheet2!$A:$C,3,FALSE)
| A | B | C | D | E | |
| 1 | 西元 | 1990 | |||
| 2 | 庚午 | 馬 | |||
| 3 | |||||
| 4 | 相沖 | 子 | 日時 | ||
| 5 | 三殺 | 丑 | 日時 | ||
| 6 | 三刑 | 午 | 日 | 三六合 | |
| 7 | 貴化 | ||||
| 8 | 日辰 | 沖↓ | 生年 | ||
| 9 | 丁卯 | 辛酉 | 1981 | ||
………………………………………………………………
Pieter Holsteyn(I) 1600/1662
Wilde kanarie
☆日遁時
甲己起甲子, 乙庚起丙子, 丙辛起戊子, 丁壬起庚子, 戊癸起壬子。
輸入"甲子"，子時甲子、丑時乙丑、………亥時乙亥。
輸入"丙申"，子時戊子、丑時己丑、………亥時己亥。
| A | B | C | |
| 1 | 日辰 | ||
| 2 | 丙申 | ||
| 3 | 六甲時 | 沖↓ | |
| 4 | 戊子 | 時 | 壬午 |
| 5 | 己丑 | 時 | 癸未 |
| 6 | 庚寅 | 時 | 甲申 |
| 7 | 辛卯 | 時 | 乙酉 |
| 8 | 壬辰 | 時 | 丙戌 |
| 9 | 癸巳 | 時 | 丁亥 |
| 10 | 甲午 | 時 | 戊子 |
| 11 | 乙未 | 時 | 己丑 |
| 12 | 丙申 | 時 | 庚寅 |
| 13 | 丁酉 | 時 | 辛卯 |
| 14 | 戊戌 | 時 | 壬辰 |
| 15 | 己亥 | 時 | 癸巳 |
………………………………………………………………………………………………
A4=VLOOKUP(LEFT($B$3,1),Sheet4!$A$1:$M$10,2,FALSE)
A5=VLOOKUP(LEFT($B$3,1),Sheet4!$A$1:$M$10,3,FALSE)
C4=VLOOKUP(B5,Sheet2!$A:$B,2,FALSE)
C5=VLOOKUP(B6,Sheet2!$A:$B,2,FALSE)
| Sheet2 | A | B | C |
| 1 | 甲子 | 戊午 | 1924 |
| 2 | 乙丑 | 己未 | 1925 |
| 3 | 丙寅 | 庚申 | 1926 |
| 4 | 丁卯 | 辛酉 | 1927 |
| 5 | 戊辰 | 壬戌 | 1928 |
| 6 | 己巳 | 癸亥 | 1929 |
| 7 | 庚午 | 甲子 | 1930 |
| 8 | 辛未 | 乙丑 | 1931 |
| 9 | 壬申 | 丙寅 | 1932 |
| 10 | 癸酉 | 丁卯 | 1933 |
| 11 | 甲戌 | 戊辰 | 1934 |
| 12 | 乙亥 | 己巳 | 1935 |
| 13 | 丙子 | 庚午 | 1936 |
| 14 | 丁丑 | 辛未 | 1937 |
| 15 | 戊寅 | 壬申 | 1938 |
| 16 | 己卯 | 癸酉 | 1939 |
| 17 | 庚辰 | 甲戌 | 1940 |
| 18 | 辛巳 | 乙亥 | 1941 |
| 19 | 壬午 | 丙子 | 1942 |
| 20 | 癸未 | 丁丑 | 1943 |
| 21 | 甲申 | 戊寅 | 1944 |
| 22 | 乙酉 | 己卯 | 1945 |
| 23 | 丙戌 | 庚辰 | 1946 |
| 24 | 丁亥 | 辛巳 | 1947 |
| 25 | 戊子 | 壬午 | 1948 |
| 26 | 己丑 | 癸未 | 1949 |
| 27 | 庚寅 | 甲申 | 1950 |
| 28 | 辛卯 | 乙酉 | 1951 |
| 29 | 壬辰 | 丙戌 | 1952 |
| 30 | 癸巳 | 丁亥 | 1953 |
| 31 | 甲午 | 戊子 | 1954 |
| 32 | 乙未 | 己丑 | 1955 |
| 33 | 丙申 | 庚寅 | 1956 |
| 34 | 丁酉 | 辛卯 | 1957 |
| 35 | 戊戌 | 壬辰 | 1958 |
| 36 | 己亥 | 癸巳 | 1959 |
| 37 | 庚子 | 甲午 | 1960 |
| 38 | 辛丑 | 乙未 | 1961 |
| 39 | 壬寅 | 丙申 | 1962 |
| 40 | 癸卯 | 丁酉 | 1963 |
| 41 | 甲辰 | 戊戌 | 1964 |
| 42 | 乙巳 | 己亥 | 1965 |
| 43 | 丙午 | 庚子 | 1966 |
| 44 | 丁未 | 辛丑 | 1967 |
| 45 | 戊申 | 壬寅 | 1968 |
| 46 | 己酉 | 癸卯 | 1969 |
| 47 | 庚戌 | 甲辰 | 1970 |
| 48 | 辛亥 | 乙巳 | 1971 |
| 49 | 壬子 | 丙午 | 1972 |
| 50 | 癸丑 | 丁未 | 1973 |
| 51 | 甲寅 | 戊申 | 1974 |
| 52 | 乙卯 | 己酉 | 1975 |
| 53 | 丙辰 | 庚戌 | 1976 |
| 54 | 丁巳 | 辛亥 | 1977 |
| 55 | 戊午 | 壬子 | 1978 |
| 56 | 己未 | 癸丑 | 1979 |
| 57 | 庚申 | 甲寅 | 1980 |
| 58 | 辛酉 | 乙卯 | 1981 |
| 59 | 壬戌 | 丙辰 | 1982 |
| 60 | 癸亥 | 丁巳 | 1983 |
………………………………………………………………………………………………
| Sheet3 | A | B | C |
| 1 | 西元 | 干支 | 生肖 |
| 2 | 1924 | 甲子 | 鼠 |
| 3 | 1925 | 乙丑 | 牛 |
| 4 | 1926 | 丙寅 | 虎 |
| 5 | 1927 | 丁卯 | 兔 |
| 6 | 1928 | 戊辰 | 龍 |
| 7 | 1929 | 己巳 | 蛇 |
| 8 | 1930 | 庚午 | 馬 |
| 9 | 1931 | 辛未 | 羊 |
| 10 | 1932 | 壬申 | 猴 |
| 11 | 1933 | 癸酉 | 雞 |
| 12 | 1934 | 甲戌 | 狗 |
| 13 | 1935 | 乙亥 | 豬 |
| 14 | 1936 | 丙子 | 鼠 |
| 15 | 1937 | 丁丑 | 牛 |
| 16 | 1938 | 戊寅 | 虎 |
| 17 | 1939 | 己卯 | 兔 |
| 18 | 1940 | 庚辰 | 龍 |
| 19 | 1941 | 辛巳 | 蛇 |
| 20 | 1942 | 壬午 | 馬 |
| 21 | 1943 | 癸未 | 羊 |
| 22 | 1944 | 甲申 | 猴 |
| 23 | 1945 | 乙酉 | 雞 |
| 24 | 1946 | 丙戌 | 狗 |
| 25 | 1947 | 丁亥 | 豬 |
| 26 | 1948 | 戊子 | 鼠 |
| 27 | 1949 | 己丑 | 牛 |
| 28 | 1950 | 庚寅 | 虎 |
| 29 | 1951 | 辛卯 | 兔 |
| 30 | 1952 | 壬辰 | 龍 |
| 31 | 1953 | 癸巳 | 蛇 |
| 32 | 1954 | 甲午 | 馬 |
| 33 | 1955 | 乙未 | 羊 |
| 34 | 1956 | 丙申 | 猴 |
| 35 | 1957 | 丁酉 | 雞 |
| 36 | 1958 | 戊戌 | 狗 |
| 37 | 1959 | 己亥 | 豬 |
| 38 | 1960 | 庚子 | 鼠 |
| 39 | 1961 | 辛丑 | 牛 |
| 40 | 1962 | 壬寅 | 虎 |
| 41 | 1963 | 癸卯 | 兔 |
| 42 | 1964 | 甲辰 | 龍 |
| 43 | 1965 | 乙巳 | 蛇 |
| 44 | 1966 | 丙午 | 馬 |
| 45 | 1967 | 丁未 | 羊 |
| 46 | 1968 | 戊申 | 猴 |
| 47 | 1969 | 己酉 | 雞 |
| 48 | 1970 | 庚戌 | 狗 |
| 49 | 1971 | 辛亥 | 豬 |
| 50 | 1972 | 壬子 | 鼠 |
| 51 | 1973 | 癸丑 | 牛 |
| 52 | 1974 | 甲寅 | 虎 |
| 53 | 1975 | 乙卯 | 兔 |
| 54 | 1976 | 丙辰 | 龍 |
| 55 | 1977 | 丁巳 | 蛇 |
| 56 | 1978 | 戊午 | 馬 |
| 57 | 1979 | 己未 | 羊 |
| 58 | 1980 | 庚申 | 猴 |
| 59 | 1981 | 辛酉 | 雞 |
| 60 | 1982 | 壬戌 | 狗 |
| 61 | 1983 | 癸亥 | 豬 |
| 62 | 1984 | 甲子 | 鼠 |
| 63 | 1985 | 乙丑 | 牛 |
| 64 | 1986 | 丙寅 | 虎 |
| 65 | 1987 | 丁卯 | 兔 |
| 66 | 1988 | 戊辰 | 龍 |
| 67 | 1989 | 己巳 | 蛇 |
| 68 | 1990 | 庚午 | 馬 |
| 69 | 1991 | 辛未 | 羊 |
| 70 | 1992 | 壬申 | 猴 |
| 71 | 1993 | 癸酉 | 雞 |
| 72 | 1994 | 甲戌 | 狗 |
| 73 | 1995 | 乙亥 | 豬 |
| 74 | 1996 | 丙子 | 鼠 |
| 75 | 1997 | 丁丑 | 牛 |
| 76 | 1998 | 戊寅 | 虎 |
| 77 | 1999 | 己卯 | 兔 |
| 78 | 2000 | 庚辰 | 龍 |
| 79 | 2001 | 辛巳 | 蛇 |
| 80 | 2002 | 壬午 | 馬 |
| 81 | 2003 | 癸未 | 羊 |
| 82 | 2004 | 甲申 | 猴 |
| 83 | 2005 | 乙酉 | 雞 |
| 84 | 2006 | 丙戌 | 狗 |
| 85 | 2007 | 丁亥 | 豬 |
| 86 | 2008 | 戊子 | 鼠 |
| 87 | 2009 | 己丑 | 牛 |
| 88 | 2010 | 庚寅 | 虎 |
| 89 | 2011 | 辛卯 | 兔 |
| 90 | 2012 | 壬辰 | 龍 |
| 91 | 2013 | 癸巳 | 蛇 |
| 92 | 2014 | 甲午 | 馬 |
| 93 | 2015 | 乙未 | 羊 |
| 94 | 2016 | 丙申 | 猴 |
| 95 | 2017 | 丁酉 | 雞 |
| 96 | 2018 | 戊戌 | 狗 |
| 97 | 2019 | 己亥 | 豬 |
| 98 | 2020 | 庚子 | 鼠 |
| 99 | 2021 | 辛丑 | 牛 |
| 100 | 2022 | 壬寅 | 虎 |
| 101 | 2023 | 癸卯 | 兔 |
| 102 | 2024 | 甲辰 | 龍 |
| 103 | 2025 | 乙巳 | 蛇 |
| 104 | 2026 | 丙午 | 馬 |
| 105 | 2027 | 丁未 | 羊 |
| 106 | 2028 | 戊申 | 猴 |
| 107 | 2029 | 己酉 | 雞 |
| 108 | 2030 | 庚戌 | 狗 |
| 109 | 2031 | 辛亥 | 豬 |
| 110 | 2032 | 壬子 | 鼠 |
| 111 | 2033 | 癸丑 | 牛 |
| 112 | 2034 | 甲寅 | 虎 |
| 113 | 2035 | 乙卯 | 兔 |
| 114 | 2036 | 丙辰 | 龍 |
| 115 | 2037 | 丁巳 | 蛇 |
| 116 | 2038 | 戊午 | 馬 |
| 117 | 2039 | 己未 | 羊 |
| 118 | 2040 | 庚申 | 猴 |
| 119 | 2041 | 辛酉 | 雞 |
| 120 | 2042 | 壬戌 | 狗 |
| 121 | 2043 | 癸亥 | 豬 |
| Sheet4 | A | B | C | D | E | F | G | H | I | J | K | L | M |
| 1 | 甲 | 甲子 | 乙丑 | 丙寅 | 丁卯 | 戊辰 | 己巳 | 庚午 | 辛未 | 壬申 | 癸酉 | 甲戌 | 乙亥 |
| 2 | 乙 | 丙子 | 丁丑 | 戊寅 | 己卯 | 庚辰 | 辛巳 | 壬午 | 癸未 | 甲申 | 乙酉 | 丙戌 | 丁亥 |
| 3 | 丙 | 戊子 | 己丑 | 庚寅 | 辛卯 | 壬辰 | 癸巳 | 甲午 | 乙未 | 丙申 | 丁酉 | 戊戌 | 己亥 |
| 4 | 丁 | 庚子 | 辛丑 | 壬寅 | 癸卯 | 甲辰 | 乙巳 | 丙午 | 丁未 | 戊申 | 己酉 | 庚戌 | 辛亥 |
| 5 | 戊 | 壬子 | 癸丑 | 甲寅 | 乙卯 | 丙辰 | 丁巳 | 戊午 | 己未 | 庚申 | 辛酉 | 壬戌 | 癸亥 |
| 6 | 己 | 甲子 | 乙丑 | 丙寅 | 丁卯 | 戊辰 | 己巳 | 庚午 | 辛未 | 壬申 | 癸酉 | 甲戌 | 乙亥 |
| 7 | 庚 | 丙子 | 丁丑 | 戊寅 | 己卯 | 庚辰 | 辛巳 | 壬午 | 癸未 | 甲申 | 乙酉 | 丙戌 | 丁亥 |
| 8 | 辛 | 戊子 | 己丑 | 庚寅 | 辛卯 | 壬辰 | 癸巳 | 甲午 | 乙未 | 丙申 | 丁酉 | 戊戌 | 己亥 |
| 9 | 壬 | 庚子 | 辛丑 | 壬寅 | 癸卯 | 甲辰 | 乙巳 | 丙午 | 丁未 | 戊申 | 己酉 | 庚戌 | 辛亥 |
| 10 | 癸 | 壬子 | 癸丑 | 甲寅 | 乙卯 | 丙辰 | 丁巳 | 戊午 | 己未 | 庚申 | 辛酉 | 壬戌 | 癸亥 |
留言列表
