Automatic Lo Shu Grid Generator

[Parik11]

Hi All,

Can you please help me to create an automated Loshu grid in XL using Date of birth ? .

Looking forward to your help.

Thanks
PP

 

[Eric W]

Welcome to the MrExcel forum!

Try:

Book1
	A	B	C	D	E	F	G	H	I	J
1	Name			Kundli
2	DOB	7/7/1981		Y
3	Day	7
4	Month	7
5	Year	1981
6	Basic	7
7	Destiny	6
8
9
10			1
11		6	77
12			8
13
14
15		3	1	9			4	9	2
16		6	7	5			3	5	7
17		2	8	4			8	1	6
18
Sheet3

Cell Formulas
Range	Formula
B3	B3	=DAY(B2)
B4	B4	=MONTH(B2)
B5	B5	=YEAR(B2)
B6	B6	=IFERROR(1/(1/MOD(B3,9)),9)
B7	B7	=IFERROR(1/(1/MOD(B3+B4+B5,9)),9)
B10:D12	B10	=LET(c,$B$3&$B$4&RIGHT($B$5,2)&$B$7&IF($D$2<>"Y",$B$6,""),REPT(B15,LEN(c)-LEN(SUBSTITUTE(c,B15,""))))

The position of the planets is determined by the grid in B15:D17. All the online references I saw had the order as shown in G15:I17. Just choose the one you want.