Excel Sheets
Ten Thousand Year Calendar
* Solar Version [FREE]
* Solar and Lunar Version
BaZi Demonstration [FREE]
BaZi Plotter Calculator
BaZi and Divination Calculator
Ba Zi
Qi Men Dun Jia (Chai Bu)
Da Liu Ren
Plum Blossom (Lunar-based)
A note from the author:
This page is dedicated to serious practitioners of Chinese Metaphysics who utilize Microsoft Excel (PC version). The Excel sheets on this page are created with a passion for Chinese Metaphysics to share this knowledge with a wider audience.
**Disclaimer:** This software, along with all accompanying files, data, and materials, is distributed "as is" without any warranties, whether express or implied. If you plan to use this software for critical purposes, you must conduct thorough testing before relying on it and accept any associated risks. If you encounter any errors, please contact the author through the Contact page. The author shall not be responsible for any losses resulting from the use of this software, including but not limited to any special, incidental, or consequential damages.
Technical Info
The spreadsheets were created using Microsoft Excel 365 for PC and designed for a viewing resolution 1920x1080 without using Macros or VBA. The decimal marker should use a dot instead of commas, following the United States regional format.
DATA INPUT
Only modify the green cells or use the dropdown menus.
After downloading the Excel file (.xlsx), right-click on the file, select Properties and select the Unblock option.
If missing fonts are requested, please try installing these fonts.
Ten Thousand Year Calendar
Solar Calendar
1901-2200
FREE for Everyone!
Ten Thousand Year Solar Calendar [FREE]
This Excel spreadsheet presents the Chinese Solar Calendar in Gregorian format, organized by days from Monday to Saturday. It includes an automatic finder for specific stems or branches and is available in Chinese and English. The time selection is based on UTC+0.
Each sheet is ready for printing. Print to PDF example can be downloaded here.
Latest version: 1,0.
Ten Thousand Year Calendar
Solar and Lunar Calendars
1901-2200
Ten Thousand Year Solar and Lunar Calendar.
This Excel spreadsheet presents the Chinese Solar and Lunar Calendars in Gregorian format, organized by days from Monday to Saturday. It includes an automatic finder for specific stems or branches and is available in Chinese and English. The time selection is based on UTC+0.
The Lunar Calendar can be hidden, and each sheet is ready for printing and can be easily copied and pasted.
A technical note: since most of the cells are unlocked for copy and paste purposes, please keep a duplicate copy of the original Excel sheet.
Latest version: v1,0 (Jan 2025)
Note:
1. Users will receive free updates and upgrades within one year of their purchased version.
2. To ensure compatibility, please try and evaluate the free version first. All sales are final and non-refundable.
BaZi - Four Pillar Calculator
1901-2200
BaZi / Four Pillar Chart Plotter
This is a BaZi chart Excel calculator with the following features.
- 1901-2200.
- Automatic solar time conversion.
- Solar terms and moon phases are solar converted to the local time.
- Plots both solar- and lunar-based charts.
- Chinese and English language.
- The user interface is set up to accommodate consultancy work.
This Excel spreadsheet has been developed and used for several years, with ongoing improvements leading to its first public release in 2025. The BaZi chart graph was extensively used in our BaZi e-books, private lessons, and other publications.
Latest version: v1,5 (Feb 2025)
Note:
1. Users will receive free updates and upgrades within one year of their purchased version.
2. To ensure compatibility, please evaluate free calendars on this webpage. All sales are final and non-refundable.
3. We do not provide information on star analysis to the public. They are a part of the Happy Yellow Rock BaZi lesson/teaching. The typical stars are included (travel, nobleman/guide, peach blossom/romance, scholar, study, guard, and void stars).
BaZi and Divination Calculator
1901-2200
The Complete Happy Yellow Rock's BaZi and Divination Calculator
八字 Bā Zì (The Four Pillars of Destiny)
奇門遁甲 Qí Mén Dùn Jiǎ (拆補 Chāi Bǔ method)
大六壬 Dà Liù Rén
梅花易數 Méi Huā Yì Shù (The Plum Blossom Divination, Lunar based)
This Excel calculator features the following.
- 1901-2200.
- Automatic solar time conversion.
- Solar terms and moon phases are solar converted to the local time.
- Plots of both solar- and lunar-based Ba Zi charts.
- Chinese and English language on some parts only.
Note: The Da Liu Ren calculator does not include English, as most practitioners who delve into Da Liu Ren are considered advanced-level practitioners.
- The user interface is set up to accommodate consultancy work.
- Two data input sections. One part is for the BaZi calculator, and another input section is for the divination calculators.
This is the primary consultancy tool of Happy Yellow Rock. The Excel spreadsheet has been developed and used for several years. Its development reached maturity for public release in 2025. The BaZi chart graph was extensively utilized in our BaZi e-books, private lessons, and other publications.
Latest version: V1,7 (Mar 2025)
The intro/tutorial video is not yet available. Please stay tuned!
Note:
1. Users will receive free updates and upgrades within one year of their purchased version.
2. To ensure compatibility, please evaluate the free calendars available on this webpage. All sales are final and non-refundable.
3. We do not provide public information on BaZi star analysis because it is part of the Happy Yellow Rock BaZi lesson/teaching. Please contact us for private/group lessons. The typical stars included are travel, nobleman/guide, peach blossom/romance, scholar, study, guard, and void stars.
4. The Qi Men host-guest relationship is based on several book references.
5. The Da Liu Ren celestial God calculation follows traditional methods similar to those used in BaZi.
6. Each calculator's principles are based on multiple book references from various authors aligned with Happy Yellow Rock’s methods/school.
