Lo Shu Grid Calculator in Excel
The Lo Shu Grid is a popular numerology tool derived from ancient Chinese traditions. It helps analyze a person’s strengths, weaknesses, and personality based on the digits of their date of birth. Each number from 1 to 9 is assigned a specific position in a 3×3 grid.
💡 What is the Lo Shu Grid?
The Lo Shu Grid is a 3×3 square used in numerology, based on ancient Chinese traditions. Each number from 1 to 9 has a fixed place in the grid. Total of each column or row is 15. Here are the Lo Shu Grid values
| 4 | 9 | 2 |
| 3 | 5 | 7 |
| 8 | 1 | 6 |
To fill the grid, you take your date of birth, remove any zeroes, and then place each remaining digit into the grid according to its number. For example, if your DOB is 04-06-1991, the digits would be: 4, 6, 1, 9, 9, 1 — and each one goes to its respective spot.
🌟 What’s Special About This Excel Calculator?
This Lo Shu Grid calculator in Excel calculates three powerful numbers that make your grid more insightful:
| 🔢 Number | 💬 Meaning |
|---|---|
| Mulank | Your birth number (single digit of your birth day) |
| Bhagyank | Destiny number (sum of all digits in your DOB) |
| Kua Number | Feng Shui number based on birth year and gender (using a simple Gregorian calendar method) |
These numbers are also placed into the Lo Shu Grid, giving a complete numerology snapshot. Some studies also add name number, angle number etc.
🧮 How the Lo Shu Grid Calculator Works
Just enter two things:
-
- Your Date of Birth in cell B2 (e.g., 01/04/1992)
- Your Gender as
MorFin cell B3
Then click the button. Excel will do everything else:
-
- Breaks down your DOB into digits (removes zeroes)
- Fills those digits in the correct spots on the grid
- Calculates Mulank, Bhagyank, and Kua Number
- Adds them to the grid
- Highlights the missing numbers from 1–9
🔐 Your Privacy Is 100% Safe
Everything runs offline in Excel — no internet, no uploading, and no data sharing. Your personal information stays with you.
✅ Final Result
- Lo Shu Grid: Shown in cells F3:H5
- Mulank: Cell B4
- Bhagyank: Cell B5
- Kua Number: Cell B6
- Missing Numbers: Cell B7 (e.g., “3, 6, 7”)
Disclaimer
I am not a professional numerologist. This Excel calculator performs only numerical calculations based on Lo Shu Grid and Feng Shui principles, using a simplified Gregorian calendar method for Kua Number. The Lo Shu Grid is a profound and expansive study, and this calculator covers only a tiny fraction of its depth. For detailed interpretations, explanations, or personalized readings, please consult a professional numerologist. This calculator is for personal exploration only and does not provide advice.
Download Excel Lo Shu Grid calculator in excel for free
: