Man-3k Locked 17.01
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Man-3k Locked 17.01 as PDF for free.
More details
- Words: 5,832
- Pages: 101
Program MIRATH in EXCEL By
Engr Malik Bashir Ahmad Bagvi, Islamabad 0300 5032 566 Email: [email protected] 09.01.2008 Sheet1= Input andSheet2= Output Example Masi'la manasikha and Calculations Sheet3 = The Muslim Family Enter DATA in RED CELLS See OUTPUT in CELLS GREEN ---->> You may un-lock any sheet by using password: bagvi. Better do not do so, because any change may corrupt the program To solve a given problem on division of mirath: Step 1Enter name of deceased person (DP) and his year of death (YOD) DP= YOD= ZAID Step 2Enter : Tarka = 100 debt= 0 Net= Tarka-Debt+Loan= 100 Willmax= Net/3 Divisible= 100.00 RS Step 3Enter number of persons of each heir (NO) of the DP:(See sheet 3 for heirs) Sno Code 1
Heir 1 Husband
No 0
Share1 0.00 0.00
0
0.00
Each= 2
2 Wife Each=
3
3 son
0 Each=
4
45 DTR
0 Each=
5
6 SS
0 Each=
6
78 SD
0 Each=
7
9 SSS
0
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Each= 8
1011 SSD
0 Each=
9
12 F
0 Each=
10
13 M
0 Each=
11
14 FF
0 Each=
12
15 FM
0 Each=
13
16 MM
1 Each=
14
1718 RB
1 Each=
15
0
1920 RS Each=
16
0
2122 PB Each=
17
2324 PS
0 Each=
18
2526 MT
0 Each=
19
27 MR (@)
(@) Smallest of code 27-144/Table 2 20
0 Each=
151 DS
0 Each=
21
152 DD
0 Each=
22
173 MF
0 Each=
23
215 RBD
0 Each=
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 16.67 16.67 83.33 83.33 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
24
0
216 RSS Each=
25
0
217 RSD Each=
26
0
218 PBD Each=
27
0
219 PSS Each=
28
0
220 PSD Each=
29
0
221 MBS Each=
30
0
222 MBD Each=
31
0
223 MSS Each=
32
224 MSD
0 Each=
33
247 FRS
0 Each=
34
248 FPS
0 Each=
35
249 FMB
0 Each=
36
250 FMS
0 Each=
37
251 MRB
0 Each=
38
252 MRS
0 Each=
39
253 MPB
0 Each=
40
254 MPS
0
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Err:508 Err:508 0.00
Each= 41
255 MMB
0 Each=
42
256 MMS
0 Each=
Total= Bait ul mall= Err:508 RS
Thanks
0.00 0.00 0.00 0.00 0.00
100 Residue from Husband (W
5032 566
EEN CELLS
rupt the program
ar of death (YOD) 2008 loan=
0 will= 0 RS
See sheet 3 for heirs)
Share2 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/
1 1 1 RS 1 RS 1 1 1 1 1 1 1 1 1
0 UNIT= RS
0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/ 50/ 50/ 250/ 250/ 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/
1 1 1 1 1 1 1 1 1 1 1 3 3 3 3 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 Err:508 Err:508 0/ 1
0/ 0/ 0/ 0/ 0/
1 1 1 1 1 RS
sidue from Husband (Wife)
0
0
0.00
0
Masi'la Manasikha Example
Zaid died in Hijri year 1380 and left property worth RS 100,000 . He was survived by his wife (Hinda), 2 sons (Aqil and Baseer), daughter (Bano) and Aqil's wife (Najma). Before the division of tarka of Zaid, Aqil and Hinda also in year 1410 and 1415 respectively. Zaid owned a piece of land measuring 100 kanals The family tree is as under: 1 Zaid (1380) | ------- ------- ----------------- ----------------- -------------- ---------- ---| | 2 Aqil (1410)
Baseer
| Najma shares obtained from sheet 1 by solving 3 problems in succession: Name Relation Share got from : 1. Zaid (1380) Prop=100 Aqil son 35.00 2. Aqil (1410) prop=35.00 hinda mother 12.50 mother 5.83 3. Hinda (1415) prop=12.50+5.83= 18.33 basirson 35.00 real brother 13.6 son najma dtr 17.50 real sister 6.8 dtr
banox
0.00 wife
8.75
==== ============ ============================== ========================= ====== Calculations start FRACTIONAL SHARES OUT OF UNITY (1 )
CHILD=
SHEET1!D40+SHEET1!D42+SHEET1!D44+SHEET1!D46+SHEET1!D48+SHEET1!D50
IKHWA= SHEET1!D62+SHEET1!D64+SHEET1!D66+SHEET1!D68+SHEET1!D70
H= H= TH=
IF(AND(SHEET1!D36>0,J37=0),1/2,0) IF(AND(SHEET1!D36>0,J37>0),1/4,0) MAX(J41,J42)
W= W= TW=
IF(AND(SHEET1!D38>0,J37=0),1/4,0) IF(AND(SHEET1!D38>0,J37>0),1/8,0) MAX(J45,J46)
D= D= TD=
IF(AND(SHEET1!D42=1,SHEET1!D40=0),1/2,0) IF(AND(SHEET1!D42>1,SHEET1!D40=0),2/3,0) MAX(J49,J50)
SD= SD= SD= TSD=
IF(AND(SHEET1!D46>1,SHEET1!D40=0,SHEET1!D42=0,SHEET1!D44=0),2/3,0) IF(AND(SHEET1!D46=1,SHEET1!D40=0,SHEET1!D42=0,SHEET1!D44=0),1/2,0) IF(AND(SHEET1!D46>0,SHEET1!D42=1,SHEET1!D40=0,SHEET1!D44=0),1/6,0) MAX(J53,J54,J55)
SSD= SSD= SSD= TSSD=
IF(AND(SHEET1!D50>1,SHEET1!D40=0,SHEET1!D42=0,SHEET1!D44=0,SHEET1!D46=0,SHEET1!D48=0),2/3,0) IF(AND(SHEET1!D50=1,SHEET1!D40=0,SHEET1!D42=0,SHEET1!D44=0,SHEET1!D46=0,SHEET1!D48=0),1/2,0) IF(AND(SHEET1!D50>0,SHEET1!D40=0,(SHEET1!D42+SHEET1!D46=1),SHEET1!D44=0,SHEET1!D48=0),1/6,0) MAX(J58,J59,J60)
F= M= M= M= M= M= M=
IF(AND(SHEET1!D52>0,J37>0),1/6,0) IF(AND(SHEET1!D54=1,J37>0),1/6,0) IF(AND(SHEET1!D54=1,F38>1),1/6,0) IF(AND(SHEET1!D54=1,SHEET1!D36=1,SHEET1!D52=1),1/6,0) IF(AND(SHEET1!D54=1,SHEET1!D38>0,SHEET1!D52=1,J65=0,J66=0,J67=0),1/4,0) IF(AND(SHEET1!D54=1,J65=0,J66=0,J67=0,J68=0),1/3,0) MAX(J65,J66,J67,J68,J69)
FF=
IF(AND(SHEET1!D56=1,SHEET1!D52=0,J37>0),1/6,0)
FM= MM= FM= MM= FM= MM= RS1= RS2= RS= PS=
IF(AND(SHEET1!D52=0,SHEET1!D54=0,SHEET1!D58>0,SHEET1!D60>0),1/12,0) IF(AND(SHEET1!D54=0,SHEET1!D58=1,SHEET1!D60=1),1/12,0) IF(AND(SHEET1!D58=1,SHEET1!D60=0,SHEET1!D52=0,SHEET1!D54=0),1/6,0) IF(AND(SHEET1!D60=1,SHEET1!D58=0, SHEET1!D54=0),1/6,0) MAX(J76,J78) MAX(J77,J79) IF(AND(J37=0,SHEET1!D52=0,SHEET1!D56=0,SHEET1!D62=0,SHEET1!D64=1),1/2,0) IF(AND(J37=0,SHEET1!D52=0,SHEET1!D56=0,SHEET1!D62=0,SHEET1!D64>1),2/3,0) MAX(J82+J83) IF(AND(J37=0,SHEET1!D52=0,SHEET1!D56=0,SHEET1!D62=0,SHEET1!D64=0,SHEET1!D66=0,SHEET1!D68=1)
PS= PS= TPS= MT= MT=
IF(AND(J37=0,SHEET1!D52=0,SHEET1!D56=0,SHEET1!D62=0,SHEET1!D64=0,SHEET1!D66=0,SHEET1!D68>1) IF(AND(SHEET1!D64=1,J37=0,SHEET1!D52=0,SHEET1!D56=0,SHEET1!D62=0,SHEET1!D66=0,SHEET1!D68>0) MAX(J85,J86,J87) IF(AND(J37=0,SHEET1!D52=0,SHEET1!D56=0,SHEET1!D70=1),1/6,0) IF(AND(J37=0,SHEET1!D52=0,SHEET1!D56=0,SHEET1!D70>1),1/3,0)
MT=
MAX(J89,J90)
===================== CHECK for ZF = ==================== H= W= D= SD= SSD= F= M= FF=
J43 J47 J51 J56 J61 J64 J70 J73
FM= MM= RS= PS= MT=
J80 J81 J84 J88 J91
TZF= RES=
J43+J47+J51+J56+J61+J64+J70+J73+J80+J81+J84+J88+J91 1-F112
B - START OF RESIDUARIES S+D N= S= D= RES=
2*SHEET1!D40+SHEET1!D42 IF(AND(SHEET1!D40>0,F113>0),2*SHEET1!D40*F113/F116,0) IF(AND(SHEET1!D40>0),SHEET1!D42*F113/F116,0) F113-F117-F118
SS+SD N= SS= SD= RES=
2*SHEET1!D44+SHEET1!D46 IF(AND(SHEET1!D44>0,F119>0),2*SHEET1!D44*F119/F123,0) IF(AND(SHEET1!D44>0,F119>0),SHEET1!D46*F119/F123,0) F119-F124-F125
SSS+SSD N= SSS=
IF(AND(SHEET1!D46>0,J56=0),(SHEET1!D46+2*SHEET1!D48+SHEET1!D50),2*SHEET1!D48+ IF(AND(SHEET1!D48>0,F126>0),2*SHEET1!D48*F126/F129,0)
SSD= SD= RES=
IF(AND(SHEET1!D48>0,F126>0),SHEET1!D50*F126/F129,0) IF(AND(SHEET1!D48>0,F126>0),(SHEET1!D46*F126/F129),0) F126-F130-F131-H132
F= RES=
IF(AND(SHEET1!D52=1,F133>0),F133,0) F133-F134
FF= RES=
IF(AND(SHEET1!D56=1,F135>0),F135,0) F135-F138
RB+RS N= RB= RS= RES=
2*SHEET1!D62+SHEET1!D64 IF(AND(SHEET1!D62>0, F139>0),2*SHEET1!D62*F139/SHEET1!D242,0) IF(AND(SHEET1!D62>0,F139>0),SHEET1!D64*F139/SHEET1!D242,0) F139-SHEET1!D243-SHEET1!D244
RS= TRS= RES= PB+PS N= PB= PS= RES= PS= TPS= RES= MT= MR= RES=
IF(AND(SHEET1!D64>0,SHEET1!D245>0,SHEET1!D62=0),SHEET1!D245,0) H149+H153 H150-H153 2*SHEET1!D66+SHEET1!D68 IF(AND(SHEET1!D66>0,F150>0),2*SHEET1!D66*F150/F152,0) IF(AND(SHEET1!D66>0,F150>0),SHEET1!D68*F150/F152,0) F150-F153-F154 IF(AND(SHEET1!D68>0,SHEET1!D66=0,F155>0,SHEET1!D64=0),F155,0) F154+F156 F155-F156 IF(AND(SHEET1!D72>0,F158>0),F158,0) F158-F160
END OF RESIDUARIES
C.
PROBLEM OF RETURN
RES=
F161
TZF= TZFS=
F112 J43+J47
TZFN=
F169-SHEET1!D460
RES ZFS=
1.0-SHEET1!D460
ADJUSTED SHARES FOR RADD
D=
IF(AND(F167>0,SHEET1!D42>0),J51/SHEET1!D461*SHEET1!D462,0)
SD=
IF(AND(F167>0,SHEET1!D46>0),J56/SHEET1!D461*SHEET1!D462,0)
SSD=
IF(AND(F167>0,SHEET1!D50>0),J61/SHEET1!D461*SHEET1!D462,0)
M=
IF(AND(F167>0,SHEET1!D54>0),J70/SHEET1!D461*SHEET1!D462,0)
FM=
IF(AND(F167>0,SHEET1!D58>0),J80/SHEET1!D461*SHEET1!D462,0) test
0.167
MM=
IF(AND(F167>0,SHEET1!D60>0),J81/SHEET1!D461*SHEET1!D462,0)
RS=
IF(AND(F167>0,SHEET1!D64>0),J84/SHEET1!D461*SHEET1!D462,0)
PS=
IF(AND(F167>0,SHEET1!D68>0),J88/SHEET1!D461*SHEET1!D462,0)
MT=
IF(AND(F167>0,SHEET1!D70>0),J91/SHEET1!D461*SHEET1!D462,0)
END OF RETURN D- PROBLEM OF
EXCESS
H= W= S= D= SS= SD= SSS= SSD= F=
IF(AND(F169>1,SHEET1!D36>0),J43/F169,0) IF(AND(F169>1,SHEET1!D38>0),J47/F169,0)
M=
IF(AND(F169>1, SHEET1!D54>0), J70/F169,0)
FF= FM= MM= RS=
IF(AND(F169>1,SHEET1!D56>0),J73/F169,0) IF(AND(F169>1,SHEET1!D58>0),J80/F169,0) IF(AND(F169>1,SHEET1!D60>0),J81/F169,0) IF(AND(F169>1,SHEET1!D64>0),J84/F169,0)
IF(AND(F169>1,SHEET1!D42>0),J51/F169,0) IF(AND(F169>1,SHEET1!D46>0),J56/F169,0) IF(AND(F169>1,SHEET1!D50>0),J61/F169,0) IF(AND(F169>1,SHEET1!D52>0), J64/F169,0)
(MAS'ILA AL-AUL)
PS= MT=
IF(AND(F169>1,SHEET1!D68>0),J88/F169,0) IF(AND(F169>1,SHEET1!D70>0),J91/F169,0)
END OF AUL SUM TOTAL OF SHARES Code
Heir
Share A ZF J43 J47
A ZF
1 2
H W
3
S
45
D
J51
0.00
6 78
SS SD
J56
0.00
SSS SSD
J61
0
9 1011
0 0
ZF 12 13
F M
J64 J70
0.00 0.00
14 15 16
FF FM MM
J73 J80 J81
0 0 0.17
1718 1920
RB RS
J84
0
2122 2324
PB PS
J88
0.00
2526 27
MT MR
J91
0.00
ZF A
ZF A
J59
END OF SUM TOTAL OF SHARES
1. FINAL SHARES
Code
Heir
1 2 3 45 6 78 9 ### 12 13 14 15 16 ### ### ### ### ### 27
H W S D SS SD SSS SSD F M FF FM MM RB RS PB PS MT MR *
ZF+RES
ZF+RES
J43
0
J47
0.00
F117
0.00
J51+F118
0.00
F124
0.00
J56+H132
0.00
F130
0.00
J61+F131
0.00
J64+F134
0.000
J70
0.000
J73+F138
0.00
J80
0.00
J81
0.17
H263=
0.83
H264=
0.00
F153
0.00
J88+F157
0.00
J91
0.00
F160
0.00
SUM1=
ZF+RES ZF+RES J286+J287+J288+J289+J290+J291+J292+J293+J294+J295
SUM2=
J296+J297+J298+J299+J300+J301+J302+J303+J304
SUM=
SUM1+SUM2= RES ZF+RES=
G306+G307 0.00
Distant Kindred Class 1 N=
SHEET1!D74*2+SHEET1!D76
DS
C151=
IF(AND(SHEET1!D74>0),C311*(2*SHEET1!D74/K341)
DD
C152=
IF(AND(SHEET1!D76>0),C311*(1*SHEET1!D76/K341)
RES=
C311-K342-K343
Distant Kindred Class 2 N= MF
Sheet1!D56 IF(AND(SHEET1!D56=1),K344,0)
RESDK2=
Distant Kindred Class 3 PROP=
0.00
NRB=
RBD
B323
NRS=
RSS+RSD
C323+D323
NR=
2*NRB+NRS
2*F356+F357
NPB=
PBD
E323
NPS=
PSS+PSD
F323+G323
NP=
2*NPB+NPS
F359*2+F360
NMT=
MBS+MBD+MSS+MSD=
DK3: ZF START SHARE OF RSS+RSD: SRS2=
IF(AND((RSS+RSD)>1,NRB=0),PROP*2/3,0)
CELL
IF(AND(C323+D323)>1,B323=0,G350*2/3,0)
RSS2=
IF(AND(RSS>0),SRS2*(2*C323/(2*C323+D323)),0)
CELL
IF(AND(C323>0),F367*(2*C323/(2*C323+D323)),0)
RSD2=
IF(AND(RSD>0),SRS2*(1*D323/(2*C323+D323)),0)
CELL
IF(AND(D323>0),F367*(1*D323/(2*C323+D323)),0)
RSS1=
IF(AND((RSS+RSD)=1,NRB=0),PROP*1/2,0)
CELL
IF(AND(C323+D323=1,B323=0),G350*1/2,0)
RSS1=
IF(AND(RSD=0),RS1,0)
CELL
IF(AND(D323=0),F372,0)
RSD1=
IF(AND(RSS=0),RS1,0)
CELL
IF(AND(C323=0),F372,0)
RSS BASIC MAX(RSS2,RSS1) CELL
MAX(F368,F374)
RSD BASIC RSD2+RSD1) CELL
MAX(F370,F376)
RESIDUE FROM RSS+RSD: RES RSS+RSD RESDK2-(BASIC RSS+BASIC RSD) CELL
G350-F378-F380
ZF-DK3 SHARE OF PSS+PSD PS2=
IF(AND((PSS+PSD)>1,PBD=0,RBD=0,RSS=0,RSD=0),PROP*2/3,0)
CELL
IF(AND((F323+G323)>1,E323=0,B323=0,C323=0,D323=0),G350*2/3,0)
PS1=
IF(AND((PSS+PSD)=1,PBD=0,RBD=0,RSS=0,RSD=0),PROP*1/2,0)
CELL
IF(AND((F323+G323)=1,E323=0,B323=0,C323=0,D323=0),G350*1/2,0)
PS0=
IF(AND(PSS+PSD>0,PBD=0,RBD=0,(RSS+RSD)=1,PROP*1/6,0)
CELL
IF(AND(F323+G323)>0,E323=0,B323=0,(C323+D323)=1),G350*1/6,0)
SPSS2= IF(AND(PSS>0),PS2*(2*PSS/(2*PSS+PSD),0) CELL
IF(AND(F323>0),G390*(2*F323/(2*F323+G323)),0)
SPSD2= IF(AND(PSD>0),PS2*(1*PSD/(2*PSS+PSD)),0) CELL
IF(AND(G323>0),G390*(1*G323/(2*F323+G323)),0)
SPSS1= IF(AND(PSS>0),PS1*(2*PSS/(2*PSS+PSD)),0) CELL
IF(AND(F323>0),G392*(2*F323/(2*F323+G323)),0)
SPSD1= IF(AND(PSD>0),PS1*(1*PSD/(2*PSS+PSD)),0) CELL
IF(AND(G323>0),G392*(1*G323/(2*F323+G323)),0)
SPSS0= IF(AND(PSS>0),PS0*(2*PSS/(2*PSS+PSD)),0) CELL
IF(AND(F323>0),G394*(2*F323/(2*F323+G323)),0)
SPSD0= IF(AND(PSD>0),PS0*(1*PSD/(2*PSS+PSD)),0) CELL
IF(AND(G323>0),G394*(1*G323/(2*F323+G323)),0)
SPSSMAX= MAX(SPSS2,SPSS1,SPSS0) CELL
MAX(G395,G399,G404)
SPSDMAX= MAX(SPSD2,SPSD1,SPSD0) CELL
MAX(G397,G401,G406)
Residue from PSS+PSD= MT2=
IF(AND(MT>1),1/3*BOK3,0)
CELL
IF(AND(F362>1),1/3*G350,0)
MT1=
IF(AND(NSHEET1!DT=1),1/6*BODK3,0)
CELL
IF(AND(F362=1),1/6*G350,0)
MT=
MAX(SSHEET1!DT2,SSHEET1!DT1)
F383-(G408+G410)
CELL
RES MT--DK3= CELL
BASIC MT
MAX(G413,G415) RESIDUE FROM MT
G411-G417
RESIDUE FROM MT--DK3 IN CELL I381
DK3-RESIDUARIES START RB=
IF(AND(NRB>0),RES6*(2*NRB/NR),0)
CELL
IF(AND(F356>0),G419*(2*F356/F358),0)
RS=
IF(AND(NRB>0,NRS>0),RES6*(1*NRS/NR),0)
CELL
IF(AND(F356>0,F357>0),G419*(1*F357/F358),0)
RES7=RES6-RB-RS CELL G419-G424-G426 RBD=
IF(AND(RBD>0),RB,0
CELL
IF(AND(B323>0),G424,0)
RSS+RSD
CELL NRS1 2*RSS+RSD CELL 2*C323+D323
RS= G426
RSS=
IF(AND(RSS>0,NRB>0),RS*(2*RSS/NRS),0)
CELL
IF(AND(C323>0,F356>0),F435*(2*C323/F437),0)
RSD=
IF(AND(RSD>0,NRB>0),(RSS+RSD)-RSS)
CELL
IF(AND(D323>0,F356>0),F435-F439,0)
RES5 RES7
CELL
G428
share of PBD+PSS+PSD
SHARE OF PBD SPBD=
IF(AND(PBD>0),SPAT*2*PBD/NP,0)
CELL
IF(AND(E323>0),F444*2*E323/F361,0)
SHARE OF PSS+PSD SPSS+PSDIF(AND(PBD>0),SPAT*1*PS/NP,0)
CELL
IF(AND(E323>0),F444*1*F360/F361,0)
SHARE OF PSS PSS= CELL
IF(AND(PBD>0),PS*2*PSS/(2*PSS+PSD),0) IF(AND(E323>0),F458*2*F323/(2*F323+G323),0)
SHARE OF PSD PSD= IF(AND(PBD>0),PS*1*PSD/(2*PSS+PSD),0) CELL IF(AND(E323>0),F458*1*G323/(2*F323+G323),0) RES6= RES7
CELL
F444-F463-F467
RESIDUE FROM PBD+PSS+PSD
RADD DK3 BEGINS TDK3= CELL
SUM TOTAL BASIC DK3 AS ZF RSS+RSD+PSS+PSD+MT F378+F380+G408+G410+G417
RSS= CELL
IF(AND(RES6>0),RSS*BOK3/TDK3,0) IF(AND(B470>0,B476>0),C350*B378/B476,0)
RSD= CELL
IF(AND(RES6>0),RSD*BOK3/TDK3,0) IF(AND(F470>0),G350*F380/F476,0)
PSS= CELL
IF(AND(RES6>0),PSS*BOK3/TDK3,0) IF(AND(F470>0),G350*G408/F476,0)
PSD= CELL
IF(AND(RES6>0),PSD*BOK3/(BOK3-TDK3),0) IF(AND(F470>0),G350*G410/F476,0)
MT= CELL
IF(AND(RES6>0),SSHEET1!DT*BOK3/(BOK3-TDK3),0) IF(AND(F470>0),G350*G417/F476,0)
END OF RETURN DK3 FINAL SHARES DK 1, 2, 3 DS= DD=
K342 K343
MF=
I312
RBD= RSS= RSD=
G431 MAX(MAX(F439,F479),F377) MAX(MAX(F441,F482),F380)
PBD= PSS= PSD=
F454 MAX(MAX(F463,F485),G403) MAX(MAX(F467,F488),G409)
MT= MAX(F491,G417) TDK123= F472+F473+F475+F477+F478+F479+F481+F482+F483+F485 CELL RESIDUE RES FROM C1-27-TDK123 DK123= CELL C311-F512
DK4 BEGIN F= NO FATHER SIDE= CELL
FRS+FPS+FMB+FMS 0.00
M= NO MOTHER SIDE= CELL
MRB+MRS+MPB+MPS+MMB+MMS 0.00
SHARE OF FRS (B307) FRS1= CELL FRS2= CELL FRS=
IF(AND(F489>0,FRS>0,SHEET1!D=0),F489,0) IF(AND(F514>0,B332>0,F520=0),F514,0) IF(AND(F489>0,FRS>0,SHEET1!D>0),2/3*F489,0) IF(AND(F514>0,B332>0,F520>0),2/3*F514,0) MAX(F523,F524)
SHARE OF FPS (C307) FPS1= CELL
IF(AND(F489>0,FPS>0,FRS=0,SHEET1!D=0),F489,0) IF(AND(F514>0,C332>0,B332=0,F520=0),F514,0)
0.00
FPS2= CELL
IF(AND(F489>0,FPS>0,FRS=0,SHEET1!D>0),2/3*F489,0) IF(AND(F514>0,C332>0,B332=0,F520>0),2/3*F514,0)
FPS=
MAX(F530,F533)
SHARE OF FMB+FMS (D307+E307) N FMBS= FMB+FMS= D332+E332 FMBS1= IF(AND(FMB>0,FRS=0,FPS=0,FMS=0),F489,0) CELL IF(AND(F539>0,B332=0,C332=0,B520=0),F514,0) FMBS2= IF(AND(FMBS>0,FRS=0,FPS=0,F513>0),2/3*F489,0) CELL IF(AND(F538>0,B332=0,C332=0,F520>0),2/3*F514,0) FMBS= CELL
FMBS1+FMBS2 F540+F543
SHARE OF FMB S FMB= IF(AND(FMB>0),SFMBS*2*FMB/(2*FMB+FMS,0) IF(AND(D332>0),F546*2*D332/(2*D332+E332),0) CELL
SHARE OF FMS SFMS= CELL
IF(AND(FMS>0),SFMBS*1*FMS/(2*FMB+FMS,0) IF(AND(E332>0),F546*1*E332/(2*D332+E332),0)
SUMF=
F526+F535+F546+F551+F557
===================================== SHARE OF MRB+MRS NM= CELL
2*MRB+MRS 2*F332+G332
NF= CELL
FRS+FPS+FMB+FMS B332+C332+D332+E332
MRB1= CELL MRB2= CELL MRB= CELL
IF(AND(F489>0,NM>0,NF=0),F489*(2*MRB/(2*MRB+MRS)),0) IF(AND(F514>0,F564>0,F567=0),F514*(2*F332/(2*F332+G332)),0) IF(AND(F489>0,NM>0,NF>0),1/3*F489*(2*MRB/(2*MRB+MRS)),0) IF(AND(F514>0,F564>0,F567>0),1/3*F514*(2*F332/(2*F332+G332)),0) MRB1+MRB2 F570+F572
MRS1= CELL
IF(AND(F489>0,NM>0,NF=0),F489*(1*MRS/(2*MRB+MRS)),0) IF(AND(F514>0,F564>0,F567=0),F514*(1*G332/(2*F332+G332)),0)
MRS2= CELL MRS= CELL
IF(F489>0,NSHEET1!D>0,NF>0),1/3*F489*(1*MRS/(2*MRB+MRS),0) IF(AND(F514>0,F564>0,F567>0),1/3*F514*(1*G332/(2*F332+G332)),0) MRS1+MRS2 F577+F579
SHARE MPB+MPS TEST NM1= CELL
2*MPB+MPS 2*H332+I332
MPB1= CELL MPB2=
IF(AND(F489>0,NM=0,NM1>0,NF=0),F489*(2*MPB/(2*MPB+MPS)),0) IF(AND(F514>0,F564=0,F585>0,F567=0),F514*(2*H332/(2*H332+I332)),0) IF(AND(F489>0,NM=0,NM1>0,NF>0),1/3*F489*(2*MPB/(2*MPB+MPS)),0)
CELL MPB= MPS1= CELL
IF(AND(F514>0,F564=0,F585>0,F567>0),1/3*F514*(2*H332/(2*H332+I332)),0) F588+F590 CELL IF(AND(F489>0,NM=0,NM1>0,NF=0),F489*(1*MPS/(2*MPB+MPS)),0) IF(AND(F514>0,F564=0,F585>0,F567=0),F514*(1*I332/(2*H332+I332)),0)
MPS2= IF(AND(F489>0,NM=0,NM1>0,NF>0),1/3*F489*(1*MPS/(2*MPB+MPS)),0) CELL IF(AND(F514>0,F564=0,F585>0,F567>0),1/3*F514*(I332/(2*H332+I332)),0) MPS= CELL
MPS1+MPS2 G593+G596
SHARE OF MMB+MMS NSHEET1!D2= 2*MMB+MMS CELL 2*B336+C336 MMB1= CELL
IF(AND(F489>0,NM=0,NM1=0,NM2>0,NF=0),F489*(2*MMB/(2*MMB+MMS)),0) IF(AND(F514>0,F564=0,F585=0,G607>0,F567=0),F514*(2*B336/(2*B336+C336)),0)
MM2= CELL MMB= CELL
IF(AND(F489>0,NM=0,NM1=0,NM2>0,NF>0),1/3*F489*(2*MMB/(2*MM+MMS)),0) IF(AND(F514>0,F564=0,F585=0,G607>0,F567>0),1/3*F514*(2*B336/(2*B336+C336)),0) MB1+MB2 G610+G613
MMS1= CELL
IF(AND(F489>0,NM=0,NM1=0,NM2>0,NF=0),F489*(1*MMS/(2*MMB+MMS)),0) IF(AND(F514>0,F564=0,F585=0,G607>0,F567=0),F514*(1*C336/(2*B336+C336)),0)
MMS2= IF(AND(F489>0,NM=0,NM1=0,NM2>0,NF>0),1/3*F489*(1*MMS/(2*MMB+MMS)),0) CELL IF(AND(F514>0,F564=0,F585=0,G607>0,F567>0),1/3*F514*(1*C336/(2*B336+C336)),0) MMS= MMS1+MMS2 CELL G593+G596 SMM=F549+F556+F566+F574+F590+F598
THE END DK4
RESDK4
F514-(F559+F624)
Final Shares Code Heir 1
No 0
Share 0
Each=
2
Wife
0
Each=
3
son
0
Each=
45
DTR
0
Each=
6
SS
0
SD
0
SSS
0
SSD
0
F
0
M
0
Each=
14
FF
0
Each=
15
FM Each=
0.00
0.00
Each=
13
0.00
0.00
Each=
12
0.00
0.00
Each=
###
0.00
0.00
Each=
9
0.00
0.00
Each=
78
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0
0.00
0.00 0.00 0.00 0.00 0.00
16
MM
1
Each=
###
RB
1
Each=
###
RS
0
Each=
###
PB
0
Each=
###
PS
0
Each=
###
MT
0
Each=
27
MR
0
Each=
151
DS
0
Each=
152
DD Each=
0
16.67 16.67 83.33 83.33 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
------------------------------------------------------Total= Bait ul SHEET1!Dall=
Warning Do not enter data in this sheet
(Vested heritage)
erty worth RS 100,000 . ns (Aqil and Baseer), daughter (Bano)
nd Hinda also in year 1410 and 1415
measuring 100 kanals
d (1380)
----- -------------- ---------- ---| | Bano
3 Hinda (1415)
3 problems in succession:
Hinda (1415) p=12.50+5.83= Total 12.22 ### 6.11 ###
check
8.75 ###
============= =======
UNITY (1 )
46+SHEET1!D48+SHEET1!D50
0
68+SHEET1!D70
1
=0,SHEET1!D44=0),2/3,0) =0,SHEET1!D44=0),1/2,0) =0,SHEET1!D44=0),1/6,0)
0 0 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
=0,SHEET1!D44=0,SHEET1!D46=0,SHEET1!D48=0),2/3,0) 0.00 =0,SHEET1!D44=0,SHEET1!D46=0,SHEET1!D48=0),1/2,0) 0.00 2+SHEET1!D46=1),SHEET1!D44=0,SHEET1!D48=0),1/6,0) 0.00 0.00
=1,J65=0,J66=0,J67=0),1/4,0)
>0,SHEET1!D60>0),1/12,0)
0.000 0.000 0.000 0.000 0.000 0.000 0.000
0.00
0.00 0.00 =0,SHEET1!D54=0),1/6,0) 0.00 0.17 0.00 0.17 T1!D62=0,SHEET1!D64=1),1/2,0) ] 0.00 T1!D62=0,SHEET1!D64>1),2/3,0) 0.00 0.00 T1!D62=0,SHEET1!D64=0,SHEET1!D66=0,SHEET1!D68=1),1/2,0) 0.00
T1!D62=0,SHEET1!D64=0,SHEET1!D66=0,SHEET1!D68>1),2/3,0) 0.00 T1!D56=0,SHEET1!D62=0,SHEET1!D66=0,SHEET1!D68>0),1/6,0) 0.00 0.00 T1!D70=1),1/6,0) 0.00 T1!D70>1),1/3,0) 0.00
END OF ZF 0.00 ZF = ==================== H W D SD SSD F M FF
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
FM MM RS PS MT
0.00 0.17 0.00 0.00 0.00
0.167 0.83
RESIDUARIES 0 0.00 0.00 0.83
0 0.00 0.00 0.83
6+2*SHEET1!D48+SHEET1!D50),2*SHEET1!D48+SHEET1!D50) 0.00 0.00
9/SHEET1!D242,0) HEET1!D242,0)
2=0),SHEET1!D245,0)
ET1!D64=0),F155,0)
(Mas'la Tashbeeb)
0.00 0.00 TSD=0.00 0.83 0.00 0.83
0.00 0.83
2.00 0.83 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.167 0.00 0.167
###
HEET1!D462,0)
0.00
HEET1!D462,0)
0.00
HEET1!D462,0)
0.00
HEET1!D462,0)
0.00
HEET1!D462,0)
0.00
HEET1!D462,0)
0.00
HEET1!D462,0)
0.00
HEET1!D462,0)
0.00
HEET1!D462,0)
0.00
ND OF RETURN
AS'ILA AL-AUL) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00
B RES
B RES
C= C D= D E RADDRADDAULAUL AUL+RADD F211 0.00 F211 F212 0.00 F212
F117
0.00
F118
0.00 F180
F124 H132 F130 F131
F138
0.00 S 0.00 F180+F214
0.00 D
0.00 0.00 F183 0.00 F216
0.00 0.00 F183+F216
0.00 SS 0.00 SD
0.00 0.00 F186
0 F218
0.00 0.00 F186+F218
0.00 SSS 0.00 SSD
F189
F219 0 F221
0.00 F219 0.00 F189+F221
0.00 F 0.00 M
F192 F196
F223 0 F224 0 F225
0.00 F223 0.00 F192+F224 0.00 F196+F225
0.00 FF 0.00 FM 0.00 MM
RES F134
E AUL+RADD 0.00 H 0.00 W
0 F214
RADD 0.00
0.00
H148 H154
0.83 0.00 H205=
0 F226
0.00 0.00 H205+L264=
0.00 RB 0.00 RS
F153 F157
0.00 0.00 H208=
0 F227
0.00 0.00 H208+L267=
0.00 PB 0.00 PS
F160
0.00
H211=
RES B
RES B
0 H233= 0.00 H211= 0.00
RADDRADDAULAUL C= C D= D
D OF SUM TOTAL OF SHARES
PROP= ### RS
AUL+RADD E
0.00 MT 0.00 MR AUL+RADD E
RADD+AUL
RADD+AUL FINALFINALAMT AMT HEIR CLASSCLASS
L236
0.00 IF(AND(F286>0),.F286,D286), 0.00 H286*K277 0.00 H
L237
0.00 IF(AND(F287>0).F287,D287) 0.00 H287*K277 0.00 W
L239
0.00 IF(AND(F288>0).F288,D288) 0.00 H288*K277 0.00 S
L241
0.00 IF(AND(F289>0).F289,D289) 0.00 H289*K277 0.00 D
L244
0.00 IF(AND(F290>0).F290,D290) 0.00 H290*K277 0.00 SS
L245
0.00 IF(AND(F291>0).F291,D291) 0.00 H291*K277 0.00 SD
L247
0.00 IF(AND(F292>0).F292,D292) 0.00 H292*K277 0.00 SSS
L248
0.00 IF(AND(F293>0).F293,D293) 0.00 H293*K277 0.00 SSD
L251
0.00 IF(AND(F294>0).F294,D294) 0.00 H294*K277 0.00 F
L252
0.00 IF(AND(F295>0).F295,D295) 0.00 H295*K277 0.00 M
L254
0.00 IF(AND(F296>0).F296,D296) 0.00 H296*K277 0.00 FF
L255
0.00 IF(AND(F297>0).F297,D297) 0.00 H297*K277 0.00 FM
L256
0.00 IF(AND(F298>0).F298,D298) 0.17 H298*K277 16.67 MM
L258
0.00 IF(AND(F299>0).F299,D299) 0.83 H299*K277 83.33 RB
L259
0.00 IF(AND(F300>0).F300,D300) 0.00 H300*K277 0.00 RS
L261
0.00 IF(AND(F301>0).F301,D301) 0.00 H301*K277 0.00 PB
L262
0.00 IF(AND(F302>0).F302,D302) 0.00 H302*K277 0.00 PS
L264
0.00 IF(AND(F303>0).F303,D303) 0.00 H303*K277 0.00 MT
L265
0.00 IF(AND(F304>0).F304,D304) 0.00 H304*K277 0.00 MR
RADD+AUL J292
Heir
RADD+AUL FINALAMTAMT CLASS CLASS 0.00 ### ### RS
ET1!D74*2+SHEET1!D76
0
ND(SHEET1!D74>0),C311*(2*SHEET1!D74/K341),0)
0.00
ND(SHEET1!D76>0),C311*(1*SHEET1!D76/K341),0)
0.00
1-K342-K343
0.00
0
ND(SHEET1!D56=1),K344,0)
0
K344-G349
0.00
0 males 0 females 0 eq females
0 males 0 females 0 eq females 0.00
0.00
0.00 RSS OUT OF 2/3 SHARE
0.00
3
0.00
###
0.00
###
0.00
###
0.00
BASIC RSS
0.00
BASIC RSD
+RSD: 0.00
PROP*2/3,0)
3=0),G350*2/3,0)
0
PROP*1/2,0)
3=0),G350*1/2,0)
0
=1),G350*1/6,0)
0
3-(G408+G410)
0
0
0.00
0.00
0.00
0.00
0.00 PSS BASIC
0.00 PSD BASIC
#REF!
### #REF! 0.00
0.00
ASIC MT
0.00
###
###
###
RESIDUE FROM RB+RS ###
###
0.00
0
0.00
0.00
RESIDUE FROM RBD+RSS+RSD
0.00
0.00
0.00
0.00
0.00
0.00
D+PSS+PSD
EGINS 0.00
0.00 RSS
0.00 RSD
0.00 PSS
0.00 PSD
0.00 MT
RN DK3 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
+FPS+FMB+FMS
+MRS+MPB+MPS+MMB+MMS
0.00 0.00 0.00
0.00
0.00 0.00
S (D307+E307)
?? 0 Err:502 0.00
0.00
0.00
(D307) 0.00
0.00 0.00
===========
0
0
2+G332)),0)
0.00
F332+G332)),0)
0.00
32+G332)),0)
0 0
0.00
0.00
MRB+MRS),0) *F332+G332)),0)
MPB+MPS)),0) 2/(2*H332+I332)),0) B/(2*MPB+MPS)),0)
0.00 0.00
0
0.00
F514*(2*H332/(2*H332+I332)),0) ### ### *MPS/(2*MPB+MPS)),0) 4*(1*I332/(2*H332+I332)),0) ###
9*(1*MPS/(2*MPB+MPS)),0) F514*(I332/(2*H332+I332)),0) ###
0.00
0
MMB/(2*MMB+MMS)),0) 4*(2*B336/(2*B336+C336)),0)
###
*(2*MMB/(2*MM+MMS)),0) F514*(2*B336/(2*B336+C336)),0)
### ###
MMS/(2*MMB+MMS)),0) 4*(1*C336/(2*B336+C336)),0)
###
*(1*MMS/(2*MMB+MMS)),0) F514*(1*C336/(2*B336+C336)),0)
###
0.00 Err:508
Err:508
Code
Heir No Share 173 MF 0 ### ### RS Each= 215 RBD 0 ### ### RS Each= 216 RSS 0 ### ### RS Each= 217 RSD 0 ### ### RS Each= 218 PBD 0 ### ### RS Each= 219 PSS 0 ### ### RS Each= 220 PSD 0 ### ### RS Each= 221 MBS 0 ### ### RS Each= 222 MBD 0 ### ### RS Each= 223 MSS 0 ### ### RS Each= 224 MSD 0 ### ### RS Each= 247 FRS 0 ### ### RS Each=
248 FPS 0 ### Each=
### RS
249 FMB 0 ###
### RS 250 FMS 0 ### ### RS Each= 251 MRB 0 ### ### RS Each= 252 MRS 0 ### ### RS Each= 253 MPB 0 ### ### RS Each= 254 MPS 0 ### ### RS Each= 255 MMB 0 ### ### RS Each= 256 MMS 0 ### ### RS Each= Each=
------------------------### RS
t ul SHEET1!Dall= F628= ### RS
Thanks
s sheet
The Muslim Family Code list of prospective heirs Alive at the time of death of the deceased TABLE 1: Code 1 to 26 Code Number Name of Heirs 1 Husband 2 Wife(one/more)
Abbreviation H W
3
Son (one/more)
S
4 5
Daughters(two/more) Daughter (single)
D D
6 7 8
Sons son (one/more) Sons daughters(two/more) Sons daughter (single)
SS SD SD
9 10 11
Sons sons son (one/more) Sons sons daughters (two/more) Sons sons daughter (single)
SSS SSD SSD
12 13
Father Mother
F M
14
Fathers father
FF
15 16
Fathers mother Mothers mother
FM MM
17 18
Real brothers (two/more) Real brother (single)
RB RB
19 20
Real sisters (two/more) Real sister (single)
RS RS
21 22
Paternal brothers(two/more) Paternal brother (single)
23 24
Paternal sisters (two/more) Paternal sister (single)
25 26
Maternal brother/sister (two/more) Maternal brother/sister (single)
(*) PB PB PS PS (**)
(*) Paternal brother/sister is the person, who is from the same father as the dying person, but from a different mother. (**) Maternal brother/sister is the person, who is from the same mother as the dying person, but from a different father. ---------------------------------------------
TABLE 2: (Tree) Code 27 to 149 This table comprises Male residuaries Mail Residuary --------------------------MR MR Rule:
Only the smallest code from among code 27 to 144 will inherit.
Similarly, smallest from among code 12, 14, 145-149 will inherit
A male residuary is a male who is related to the DP (Deceased Person) thro Thus, Real brother's son is a male residuary Real brother's daughter is not a male residuary Mother's father is not a male residuary Father's brother's son is a male residuary Father's sister's son is not a male residuary Father's maternal brother is not a male residuary (because, though male himself, is related to the DP through mother/female) >>> All those MALES who are not listed in table 1 or table 2, fall in the category of Distant Kindred. >>> All those FE-MALES who are not listed in Table 1 fall in the category of Distant Kindred. >>> Only those persons can inherit, who have a blood relation with DP. (Husband/ wife is the only exception. They do inherit, though have no blood Further explanation Code 33= Code 12 (DP's father's real brother Code 34= Code 12 (DP's father's Paternal brother Code 35= Son of Code 33 Code 36= Son of Code 34 Example Zaid was survived by his father (code 12)'s FF's (code 145)'s FFF's (code 148)'s paternal brother (code 104)'s SS (Code 108)'s son (code 110)/Abdullah. Thus as per this Ttree, Code of Abdullah = 110 Adam (peace be upon him) !
<< Real brother ! Paternal brother >> 123---------------------149-----------------------! ! 125 103 -----------------148---------------------104 ! ! ! ! 127 105 85---------------147---------------- 86 106 ! ! ! ! ! ! 129 107 87 69------------146-------------70 88 108 ! ! ! ! ! ! ! ! 131 109 89 71 55---------145----------56 72 90 110 ! ! ! ! ! ! ! ! ! ! 133 111 91 73 57 43-------14-------44 58 74 92 112 ! ! ! ! ! ! ! ! ! ! ! ! 135 113 93 75 59 45 33----12----34 46 60 76 94 114 ! ! ! ! ! ! ! ! ! ! ! ! ! ! 137 115 95 77 61 47 35 RB-DP-PB 36 48 62 78 96 116 ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! 139 117 97 79 63 49 37 27 28 38 50 64 80 98 118 ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! 141 119 99 81 65 51 39 29 30 40 52 66 82 100 120 ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! 143 121 101 83 67 53 41 31 32 42 54 68 84 102 122 DP= Dying Person whose left over property is to be divided RB= Real Brother of DP PB= Paternal Brother of DP ------------------------------------------------------------
Table 3: Code 150: Code 151 to 300 Distant Kindred (Zawil Arham) Code 150 has been allotted to them as a Class. This Class comprises Cod 151 to 300 as listed below.
Distant Kindred (Zawil Arham)
124 ! 126 ! 128 ! 130 ! 132 ! 134 ! 136 ! 138 ! 140 ! 142 ! 144
Family Distant Kindred Class A Group 1 151 Daughter Son (To be read as Dying Person's Daughter's Son) 152 Daughter Daughter
Group 2 153 Son Daughter Son
(Dying Person's Son's Daughter's Son)
154 Son Daughter Daughter Group 3 155 Daughter Son Son 156 Daughter Son Daughter 157 Daughter Daughter Son 158 Daughter Daughter Daughter
Group 4 159 Son Son Daughter Son 160 Son Son Daughter Daughter Group 5 161 Son Daughter Son Son 162 Son Daughter Son Daughter 163 Son Daughter Daughter Son
DS DD
164 Son Daughter Daughter Daughter 165 Daughter Son Son Son 166 Daughter Son Son Daughter 167 Daughter Son Daughter Son 168 Daughter Son Daughter Daughter 169 Daughter Daughter Son Son 170 Daughter Daughter Son Daughter 171 Daughter Daughter Daughter Son 172 Daughter Daughter Daughter Daughter
Family Distant Kindred Class B Group 6 173 Mother Father
(Dying Person's mother's Father)
Group 7A 174 Father Mother Father Group 7B 175 Mother Father Father 176 Mother 1. Father Mother 177 Mother 2. Mother Father Group 8A
MF
178 Father 1. Father Mother Father 179 Father 2. Mother Father Father 180 Father Mother Father Mother 181 Father Mother Mother Father Group 8B 182 Mother Father Father Father 183 Mother Father Father Mother 184 Mother Father Mother Father 185 Mother Father Mother Mother 186 Mother Mother Father Father 187 Mother Mother Father Mother 188 Mother Mother Mother Father Group 9A 189 Father Father Father Mother Father 190 Father Father Mother Mother Father 191 Father Father Mother Father Father 192 Father Father Mother Father Mother 193 Father Mother Father Father Father 194 Father Mother Father Father Mother 195 Father Mother Father Mother Father 196 Father Mother Father Mother Mother
197 Father Mother Mother Father Father 198 Father Mother Mother Father Mother 199 Father Mother Mother Mother Father Group 9B 200 Mother Father Father Father Father 201 Mother Father Father Father Mother 202 Mother Father Father Mother Father 203 Mother Father Father Mother Mother 204 Mother Father Mother Father Father 205 Mother Father Mother Father Mother 206 Mother Father Mother Mother Father 207 Mother Father Mother Mother Mother 208 Mother Mother Father Father Father 209 Mother Mother Father Father Mother 210 Mother Mother Father Mother Father 211 Mother Mother Father Mother Mother 212 Mother Mother Mother Father Father 213 Mother Mother Mother Father Mother 214 Mother Mother Mother Mother Father ------------------------------------------
Family Distant Kindred Class C
Group 10 215 Real Brother Daughter
RBD
Group 11 216 Real Sister Son 217 Real Sister Daughter
RSS RSD
Group 12 218 Paternal Brother Daughter
PBD
Group 13 219 Paternal Sister Son 220 Paternal Sister Daughter
PSS PSD
Group 14 221 Maternal Brother Son 222 Maternal Brother Daughter 223 Maternal Sister Son 224 Maternal Sister Daughter Group 15 225 Real Brother Son Daughter Group 16 226 Paternal Brother Son Daughter Group 17 227 Real Brother Daughter Son
MBS MBD MSS MSD
228 Real Brother Daughter Daughter Group 18 229 Real Sister Son Son 230 Real Sister Son Daughter 231 Real Sister Daughter Son 232 Real Sister Daughter Daughter Group 19 233 Paternal Brother Daughter Son 234 Paternal Brother Daughter Daughter Group 20 235 Paternal Sister Son Son 236 Paternal Sister Son Daughter 237 Paternal Sister Daughter Son 238 Paternal Sister Daughter Daughter Group 21 239 Maternal Brother Son Son 240 Maternal Brother Son Daughter 241 Maternal Brother Daughter Son 242 Maternal Brother Daughter Daughter 243 Maternal Sister Son Son 244 Maternal Sister Son Daughter 245 Maternal Sister Daughter Son 246 Maternal Sister Daughter Daughter -----------------------------------------------------
Family Distant Kindred Class D Group 22 247 Father Real Sister
FRS
Group 23 248 Father Paternal Sister
FPS
Group 24 249 Father Maternal Brother 250 Father Maternal Sister
FMB FMS
Group 25 251 Mother Real Brother 252 Mother Real Sister
MRB MRS
Group 26 253 Mother Paternal Brother 254 Mother Paternal Sister
MPB MPS
Group 27 255 Mother Maternal Brother 256 Mother Maternal Sister Group 28 257 Father Real Brother Daughter Group 29 258 Father Paternal Brother Daughter Group 30 259 Father Real Sister Son 260 Father Real Sister Daughter
MMB MMS
Group 31 261 Father Paternal Sister Son 262 Father Paternal Sister Daughter Group 32 263 Father Maternal Brother Son 264 Father Maternal Brother Daughter 265 Father Maternal Sister Son 266 Father Maternal Sister Daughter Group 33 267 Mother Real Brother Son 268 Mother Real Brother Daughter 269 Mother Real Sister Son 270 Mother Real Sister Daughter Group 34 271 Mother Paternal Brother Son 272 Mother Paternal Brother Daughter 273 Mother Paternal Sister Son 274 Mother Paternal Sister Daughter Group 35 275 Mother Maternal Brother Son 276 Mother Maternal Brother Daughter 277 Mother Maternal Sister Son 278 Mother Maternal Sister Daughter Group 36 279 Father father Real sister 280 Father mother Real brother 281 Father mother Real sister
Group 37 282 Father father paternal sister 283 Father mother paternal brother 284 Father mother paternal sister
Group 38 285 286 287 288
Father father maternal brother Father father maternal sister Father mother maternal brother Father mother maternal sister
Group 39 289 mother mother real brother 290 mother mother real sister
Group 40 291 mother father real brother 292 mother father real sister Group 41 293 mother mother paternal brother 294 mother mother paternal sister Group 42 295 mother father paternal brother 296 mother father paternal sister Group 43 297 mother mother maternal brother 298 mother mother maternal sister Group 44 299 mother father maternal brother 300 mother father maternal sister -------------------------------------------Note: For the time being the program SUNNILAW.FOR coves only code 1 to 278. ---------------------------------------------NOTE: 1. ALL THESE RELATIONS ARE WITH RESPECT TO THE DYING PERSON.
2. ONLY BLOOD RELATIONS INHERIT.
----------------------------------------------------------
ceased
MT MT
om the same
from the same erent father.
to 149 residuaries
144 will inherit.
Deceased Person) through males only.
herit, though have no blood relation with each other)
brother >> ------------ 124 ! ---------104 126 ! ! ----- 86 106 128 ! ! ! --70 88 108 130 ! ! ! ! 6 72 90 110 132 ! ! ! ! ! 8 74 92 112 134 ! ! ! ! ! 0 76 94 114 136 ! ! ! ! ! 2 78 96 116 138 ! ! ! ! ! 4 80 98 118 140 ! ! ! ! ! 6 82 100 120 142 ! ! ! ! ! 8 84 102 122 144
a Class. isted below.
E DYING PERSON.
The Islamic law of Inheritance in brief Zawil Furud Table 4 Children =S, D, SS, SD, SSS, SSD Definitions Ikhwa =2 or more persons (irrespective of sex) from among (real, paternal and maternal) brothers and sisters, all put together. Example: 1 RB + 1 PS constitute ikhwa √=Alive x = Not Alive 2 > = 2 OR more in number
SNO
Heir 1
1H
Share (Alternate) 3
2
1/2 1/4
12/24 6/24
2W
3D
1/4
6/24
1/8
3/24
2/3
16/24
1/2
12/24
4
4 SD
2/3
16/24
1/2
12/24
1/6 2/3
4/24 16/24]
5 SSD 1/2 1/6
12/24 4/24
6F
1/6
4/24
7M
1/6
4/24
1/4
6/24
1/3
8/24
1/6
4/24
1/6
4/24
8 FF 9 FM 10 MM
Sno
Heir 1
Share 23
4
11 RS
2/3
16/24
1/2 2/3
12/24
12 PS
16/24
13 MT
1/2
12/24
1/6
4/24
1/3
8/24
1/6
4/24
$ To be subdivided equally among all MTL irrespective of sex D1= Daughter 1 SD1= Son's daughter 1 RS1= Real Sister 1
Asabat (=Residuaries)
Table 5
(Those who get the Residue left from Zawil Furud) S.No Heir
14 S
15 SS
16 SSS
→
D
SD
SSD
*1
*1
*1 *2
*1
[C145 = Code 145] A double share to the male. If male is not alive, the female stands exclud ed
*2
*3
SD (C7/C 8) shall also share with SSS(C 9), if it did not get as Zawil Furud Least of C14 (FF) and C145 to C149 gets the Residu e
*4 *5
*6
She will get a share here only if she did not, in Table 3 Furthe r: [RS>]x Least among C27 to C144 shall get the residu e from Table 3
*7
*8
In case none among Sno 14 to 23 gets the residu e, the same shall be divide d among ZFN in the ratio of their basic shares The Residu e goes over to the Distan t Kindr ed (C150)
of Inheritance in brief (Those getting fractional shares)
ve of sex) from among rnal) brothers and sisters, all put together. constitute ikhwa
Condition 5 A. Zawil Furud Sababi (ZFS) [CH]x [CH]√ [CH]x [CH]√ B. Zawil Furud Nasabi (ZFN) [2>] . [S]x [1 ] . [S]x
[2>] . [S. D. SS]x [1] .
[
"
]x
[D1 >]√ . [S. SS]x [2>] . [S. D. SS. SD. SSS]x [1 ] . [
"
]x
[D1 or SD1]√ . [S. SS. SSS]x [CH]√ [CH]√ or [Ikhwa]√ or [H+F]√ [W+F]√ . [1/6]x [1/6]x . [1/4]x [CH]√ . [F]x [F (Hanafi and Maliki)]x . [M]x [M]x
Condition 5
[2>] . [CH. F. FF. RB]x [1 ] . [
"
]x
[2>] . [CH. F. FF. RB. RS. PB]x
[1 ] .
[
"
]x
[RS1]√ . [CH. F. FF. RB. PB]x
[2>] . [CH. F. FF]x .............. $
[1 ] . [
"
]x
MTL irrespective of sex 1 RS1= Real Sister 1
duaries)
Zawil Furud) 17 F
18 FF
19 RB
20
21 PB
22
C145 to C149
RS
RS *3
PS
PS *4
*1
*4 *1
*5
23
24
25
26 baitul mal
C27
R
DK
to A C144 D D C 150 *6
*7
*8
4 Typical problems Problem 1 DP= Zaid
YOD=
2005
Solution
ADA= Assumed Divisible Amount
1
2
Heir 2W M F 4 S (=8 D) 2 D (=2D) 3 MT (2 male + b1 female) 4 RB Explanation COL 2 COL 3:
PROP=
Share * 1/8 * 1/6
3
ADA
1/6 Residue . x x
. x x * (8x6=)48
4 Share each 6 6/48/2 8 8/48 8 8/48 26 2x26/48/10 26/48/10 x x
For abbreviations see tablev 1/Sheet 3
ADA = 8 X 6 = 48 Share of 2 W= Share of 2 M= Share of 2 F= Sum total of zawil furuz= Residue= ADA-22=
Ignore number occuring twice 48/8= 48/6= 48/6= 6+8+8= 40-22=
COL4
2 W= 4S+2D= Share 1 D= Share 1 S =
1 W= 10 D 26/48/10 2x26/48/10
6/48/2 Son gets double the share od a DTR
COL 5
Quantum
1 W=
6/48/2X400=
6/48
Problem 2
see sheet 4 table 1 6 8 8 22 26 This goes to son
25
Problem of Excess
if sum total of shares of zawil furuz exceeds ADA, then replace ADA by the sum total DP= Hinda
YOD=
1999
Solution 1
PROP=
ADA= Assumed Divisible Amount 2
3
4
Heir Heir M F 6D
Share * 1/4 * 1/6
ADA
1/6 * 2/3
Share each 18 18/90 12 12/90 12 12/90 48 48/90/6
* (72=) 90
Explanation COL 2 COL 3:
For abbreviations see Sheet 3
ADA = 4 x 6 x 3 = 72 Ignore number occuring twice Share of H= 72/4= Sum total of zawil furuz= 18 + 12 + 12 + 48= Sum total having exceeded ADA, ADA replaced by sum total
Problem 3
Problem of Return
see sheet 4 table 1 18 90
Case 1
When H (W) not alive
that is when there is some residue from zawilm furuz (table 1), but none in table 2 to get it. It will go back to zawil mfuruz, except to H (W) DP= Aqil
YOD=
1985
PROP=
Solution 1
2
Heir M I MT 1 RS
Share * 1/6
3
4 Share each 2 2/10 2 2/10 6 6/10
ADA 1/6
* 1/2 * (12) 10
Explanation COL 2
For abbreviations see Table Sheet 3
ADA = 6 x 2 = 12
Problem 4
Problem of Return
Case 2
When H (W) is alive
that is when there is some residue from zawilm furuz (table 1), but none in table 2 to get it. It will go back to zawil mfuruz, except to H (W) DP= Aqil
YOD=
1985
PROP=
Solution 1
2
3
4
Heir W M I MT
Share * 1/4 * 1/3 * 1/6
ADA
Share each 18 18/72/2 24 24/36 12 12/36
* (72) 36
Explanation COL 2
COL 3
For abbreviations see table 1/sheet 3
ADA =4 x 3 x 6 = 72 out of it W= 72X 1/4= 18 Quantum= 18/72 x 144= Balance = 144-36= 108 It will be divided among other zawil furuz as in problem 3 abov thus ADA for M and MT = 6x3= 18 being problem of Return, replace ADA (72) by sum total of M and MT= Share of M = 24/36 x 108= 72 Share of MT= 12/36 x 108= 36
Exercise Solve these 4 typical problems using program (by entering data in sheet 1)
There are good 268 million problems related to zawil furuz and asabat (table 2 and 3 put together. Now you should be able to attempt any such problems. For problems related to distant kindred (zawil arham), may use the program mirath (sheet 1).
Another program : ENTITLED SUNNI21.EXE (folder 5/ software package MATH.IN.ISLAM), covering nearest 278 heirs may Bagvi 11.01.2008
400 Kanals of land
5 Quantum 25.00 66.66 66.66 43.33 21.66 x x 400.00
see sheet 4 table 1
see sheet 4 table 2
Kanals
1800 grams of gold
5
Quantum 360.00 240.00 240.00 160.00 1800.00
see sheet 4 table 1
H (W) not alive RS 100
5 Quantum 20.00 20.00 60.00 100.00
H (W) is alive
RS 144
5
Quantum 18+18=36 Both W 72.00 36.00 144.00
18/72 x 144= RS 36 furuz as in problem 3 above.
24+12=
36
(sheet 1).
nearest 278 heirs may also be used.
Engr Malik Bashir Ahmad Bagvi, Islamabad 0300 5032 566 Email: [email protected] 09.01.2008 Sheet1= Input andSheet2= Output Example Masi'la manasikha and Calculations Sheet3 = The Muslim Family Enter DATA in RED CELLS See OUTPUT in CELLS GREEN ---->> You may un-lock any sheet by using password: bagvi. Better do not do so, because any change may corrupt the program To solve a given problem on division of mirath: Step 1Enter name of deceased person (DP) and his year of death (YOD) DP= YOD= ZAID Step 2Enter : Tarka = 100 debt= 0 Net= Tarka-Debt+Loan= 100 Willmax= Net/3 Divisible= 100.00 RS Step 3Enter number of persons of each heir (NO) of the DP:(See sheet 3 for heirs) Sno Code 1
Heir 1 Husband
No 0
Share1 0.00 0.00
0
0.00
Each= 2
2 Wife Each=
3
3 son
0 Each=
4
45 DTR
0 Each=
5
6 SS
0 Each=
6
78 SD
0 Each=
7
9 SSS
0
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Each= 8
1011 SSD
0 Each=
9
12 F
0 Each=
10
13 M
0 Each=
11
14 FF
0 Each=
12
15 FM
0 Each=
13
16 MM
1 Each=
14
1718 RB
1 Each=
15
0
1920 RS Each=
16
0
2122 PB Each=
17
2324 PS
0 Each=
18
2526 MT
0 Each=
19
27 MR (@)
(@) Smallest of code 27-144/Table 2 20
0 Each=
151 DS
0 Each=
21
152 DD
0 Each=
22
173 MF
0 Each=
23
215 RBD
0 Each=
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 16.67 16.67 83.33 83.33 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
24
0
216 RSS Each=
25
0
217 RSD Each=
26
0
218 PBD Each=
27
0
219 PSS Each=
28
0
220 PSD Each=
29
0
221 MBS Each=
30
0
222 MBD Each=
31
0
223 MSS Each=
32
224 MSD
0 Each=
33
247 FRS
0 Each=
34
248 FPS
0 Each=
35
249 FMB
0 Each=
36
250 FMS
0 Each=
37
251 MRB
0 Each=
38
252 MRS
0 Each=
39
253 MPB
0 Each=
40
254 MPS
0
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Err:508 Err:508 0.00
Each= 41
255 MMB
0 Each=
42
256 MMS
0 Each=
Total= Bait ul mall= Err:508 RS
Thanks
0.00 0.00 0.00 0.00 0.00
100 Residue from Husband (W
5032 566
EEN CELLS
rupt the program
ar of death (YOD) 2008 loan=
0 will= 0 RS
See sheet 3 for heirs)
Share2 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/
1 1 1 RS 1 RS 1 1 1 1 1 1 1 1 1
0 UNIT= RS
0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/ 50/ 50/ 250/ 250/ 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/ 0/
1 1 1 1 1 1 1 1 1 1 1 3 3 3 3 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 0/ 1 Err:508 Err:508 0/ 1
0/ 0/ 0/ 0/ 0/
1 1 1 1 1 RS
sidue from Husband (Wife)
0
0
0.00
0
Masi'la Manasikha Example
Zaid died in Hijri year 1380 and left property worth RS 100,000 . He was survived by his wife (Hinda), 2 sons (Aqil and Baseer), daughter (Bano) and Aqil's wife (Najma). Before the division of tarka of Zaid, Aqil and Hinda also in year 1410 and 1415 respectively. Zaid owned a piece of land measuring 100 kanals The family tree is as under: 1 Zaid (1380) | ------- ------- ----------------- ----------------- -------------- ---------- ---| | 2 Aqil (1410)
Baseer
| Najma shares obtained from sheet 1 by solving 3 problems in succession: Name Relation Share got from : 1. Zaid (1380) Prop=100 Aqil son 35.00 2. Aqil (1410) prop=35.00 hinda mother 12.50 mother 5.83 3. Hinda (1415) prop=12.50+5.83= 18.33 basirson 35.00 real brother 13.6 son najma dtr 17.50 real sister 6.8 dtr
banox
0.00 wife
8.75
==== ============ ============================== ========================= ====== Calculations start FRACTIONAL SHARES OUT OF UNITY (1 )
CHILD=
SHEET1!D40+SHEET1!D42+SHEET1!D44+SHEET1!D46+SHEET1!D48+SHEET1!D50
IKHWA= SHEET1!D62+SHEET1!D64+SHEET1!D66+SHEET1!D68+SHEET1!D70
H= H= TH=
IF(AND(SHEET1!D36>0,J37=0),1/2,0) IF(AND(SHEET1!D36>0,J37>0),1/4,0) MAX(J41,J42)
W= W= TW=
IF(AND(SHEET1!D38>0,J37=0),1/4,0) IF(AND(SHEET1!D38>0,J37>0),1/8,0) MAX(J45,J46)
D= D= TD=
IF(AND(SHEET1!D42=1,SHEET1!D40=0),1/2,0) IF(AND(SHEET1!D42>1,SHEET1!D40=0),2/3,0) MAX(J49,J50)
SD= SD= SD= TSD=
IF(AND(SHEET1!D46>1,SHEET1!D40=0,SHEET1!D42=0,SHEET1!D44=0),2/3,0) IF(AND(SHEET1!D46=1,SHEET1!D40=0,SHEET1!D42=0,SHEET1!D44=0),1/2,0) IF(AND(SHEET1!D46>0,SHEET1!D42=1,SHEET1!D40=0,SHEET1!D44=0),1/6,0) MAX(J53,J54,J55)
SSD= SSD= SSD= TSSD=
IF(AND(SHEET1!D50>1,SHEET1!D40=0,SHEET1!D42=0,SHEET1!D44=0,SHEET1!D46=0,SHEET1!D48=0),2/3,0) IF(AND(SHEET1!D50=1,SHEET1!D40=0,SHEET1!D42=0,SHEET1!D44=0,SHEET1!D46=0,SHEET1!D48=0),1/2,0) IF(AND(SHEET1!D50>0,SHEET1!D40=0,(SHEET1!D42+SHEET1!D46=1),SHEET1!D44=0,SHEET1!D48=0),1/6,0) MAX(J58,J59,J60)
F= M= M= M= M= M= M=
IF(AND(SHEET1!D52>0,J37>0),1/6,0) IF(AND(SHEET1!D54=1,J37>0),1/6,0) IF(AND(SHEET1!D54=1,F38>1),1/6,0) IF(AND(SHEET1!D54=1,SHEET1!D36=1,SHEET1!D52=1),1/6,0) IF(AND(SHEET1!D54=1,SHEET1!D38>0,SHEET1!D52=1,J65=0,J66=0,J67=0),1/4,0) IF(AND(SHEET1!D54=1,J65=0,J66=0,J67=0,J68=0),1/3,0) MAX(J65,J66,J67,J68,J69)
FF=
IF(AND(SHEET1!D56=1,SHEET1!D52=0,J37>0),1/6,0)
FM= MM= FM= MM= FM= MM= RS1= RS2= RS= PS=
IF(AND(SHEET1!D52=0,SHEET1!D54=0,SHEET1!D58>0,SHEET1!D60>0),1/12,0) IF(AND(SHEET1!D54=0,SHEET1!D58=1,SHEET1!D60=1),1/12,0) IF(AND(SHEET1!D58=1,SHEET1!D60=0,SHEET1!D52=0,SHEET1!D54=0),1/6,0) IF(AND(SHEET1!D60=1,SHEET1!D58=0, SHEET1!D54=0),1/6,0) MAX(J76,J78) MAX(J77,J79) IF(AND(J37=0,SHEET1!D52=0,SHEET1!D56=0,SHEET1!D62=0,SHEET1!D64=1),1/2,0) IF(AND(J37=0,SHEET1!D52=0,SHEET1!D56=0,SHEET1!D62=0,SHEET1!D64>1),2/3,0) MAX(J82+J83) IF(AND(J37=0,SHEET1!D52=0,SHEET1!D56=0,SHEET1!D62=0,SHEET1!D64=0,SHEET1!D66=0,SHEET1!D68=1)
PS= PS= TPS= MT= MT=
IF(AND(J37=0,SHEET1!D52=0,SHEET1!D56=0,SHEET1!D62=0,SHEET1!D64=0,SHEET1!D66=0,SHEET1!D68>1) IF(AND(SHEET1!D64=1,J37=0,SHEET1!D52=0,SHEET1!D56=0,SHEET1!D62=0,SHEET1!D66=0,SHEET1!D68>0) MAX(J85,J86,J87) IF(AND(J37=0,SHEET1!D52=0,SHEET1!D56=0,SHEET1!D70=1),1/6,0) IF(AND(J37=0,SHEET1!D52=0,SHEET1!D56=0,SHEET1!D70>1),1/3,0)
MT=
MAX(J89,J90)
===================== CHECK for ZF = ==================== H= W= D= SD= SSD= F= M= FF=
J43 J47 J51 J56 J61 J64 J70 J73
FM= MM= RS= PS= MT=
J80 J81 J84 J88 J91
TZF= RES=
J43+J47+J51+J56+J61+J64+J70+J73+J80+J81+J84+J88+J91 1-F112
B - START OF RESIDUARIES S+D N= S= D= RES=
2*SHEET1!D40+SHEET1!D42 IF(AND(SHEET1!D40>0,F113>0),2*SHEET1!D40*F113/F116,0) IF(AND(SHEET1!D40>0),SHEET1!D42*F113/F116,0) F113-F117-F118
SS+SD N= SS= SD= RES=
2*SHEET1!D44+SHEET1!D46 IF(AND(SHEET1!D44>0,F119>0),2*SHEET1!D44*F119/F123,0) IF(AND(SHEET1!D44>0,F119>0),SHEET1!D46*F119/F123,0) F119-F124-F125
SSS+SSD N= SSS=
IF(AND(SHEET1!D46>0,J56=0),(SHEET1!D46+2*SHEET1!D48+SHEET1!D50),2*SHEET1!D48+ IF(AND(SHEET1!D48>0,F126>0),2*SHEET1!D48*F126/F129,0)
SSD= SD= RES=
IF(AND(SHEET1!D48>0,F126>0),SHEET1!D50*F126/F129,0) IF(AND(SHEET1!D48>0,F126>0),(SHEET1!D46*F126/F129),0) F126-F130-F131-H132
F= RES=
IF(AND(SHEET1!D52=1,F133>0),F133,0) F133-F134
FF= RES=
IF(AND(SHEET1!D56=1,F135>0),F135,0) F135-F138
RB+RS N= RB= RS= RES=
2*SHEET1!D62+SHEET1!D64 IF(AND(SHEET1!D62>0, F139>0),2*SHEET1!D62*F139/SHEET1!D242,0) IF(AND(SHEET1!D62>0,F139>0),SHEET1!D64*F139/SHEET1!D242,0) F139-SHEET1!D243-SHEET1!D244
RS= TRS= RES= PB+PS N= PB= PS= RES= PS= TPS= RES= MT= MR= RES=
IF(AND(SHEET1!D64>0,SHEET1!D245>0,SHEET1!D62=0),SHEET1!D245,0) H149+H153 H150-H153 2*SHEET1!D66+SHEET1!D68 IF(AND(SHEET1!D66>0,F150>0),2*SHEET1!D66*F150/F152,0) IF(AND(SHEET1!D66>0,F150>0),SHEET1!D68*F150/F152,0) F150-F153-F154 IF(AND(SHEET1!D68>0,SHEET1!D66=0,F155>0,SHEET1!D64=0),F155,0) F154+F156 F155-F156 IF(AND(SHEET1!D72>0,F158>0),F158,0) F158-F160
END OF RESIDUARIES
C.
PROBLEM OF RETURN
RES=
F161
TZF= TZFS=
F112 J43+J47
TZFN=
F169-SHEET1!D460
RES ZFS=
1.0-SHEET1!D460
ADJUSTED SHARES FOR RADD
D=
IF(AND(F167>0,SHEET1!D42>0),J51/SHEET1!D461*SHEET1!D462,0)
SD=
IF(AND(F167>0,SHEET1!D46>0),J56/SHEET1!D461*SHEET1!D462,0)
SSD=
IF(AND(F167>0,SHEET1!D50>0),J61/SHEET1!D461*SHEET1!D462,0)
M=
IF(AND(F167>0,SHEET1!D54>0),J70/SHEET1!D461*SHEET1!D462,0)
FM=
IF(AND(F167>0,SHEET1!D58>0),J80/SHEET1!D461*SHEET1!D462,0) test
0.167
MM=
IF(AND(F167>0,SHEET1!D60>0),J81/SHEET1!D461*SHEET1!D462,0)
RS=
IF(AND(F167>0,SHEET1!D64>0),J84/SHEET1!D461*SHEET1!D462,0)
PS=
IF(AND(F167>0,SHEET1!D68>0),J88/SHEET1!D461*SHEET1!D462,0)
MT=
IF(AND(F167>0,SHEET1!D70>0),J91/SHEET1!D461*SHEET1!D462,0)
END OF RETURN D- PROBLEM OF
EXCESS
H= W= S= D= SS= SD= SSS= SSD= F=
IF(AND(F169>1,SHEET1!D36>0),J43/F169,0) IF(AND(F169>1,SHEET1!D38>0),J47/F169,0)
M=
IF(AND(F169>1, SHEET1!D54>0), J70/F169,0)
FF= FM= MM= RS=
IF(AND(F169>1,SHEET1!D56>0),J73/F169,0) IF(AND(F169>1,SHEET1!D58>0),J80/F169,0) IF(AND(F169>1,SHEET1!D60>0),J81/F169,0) IF(AND(F169>1,SHEET1!D64>0),J84/F169,0)
IF(AND(F169>1,SHEET1!D42>0),J51/F169,0) IF(AND(F169>1,SHEET1!D46>0),J56/F169,0) IF(AND(F169>1,SHEET1!D50>0),J61/F169,0) IF(AND(F169>1,SHEET1!D52>0), J64/F169,0)
(MAS'ILA AL-AUL)
PS= MT=
IF(AND(F169>1,SHEET1!D68>0),J88/F169,0) IF(AND(F169>1,SHEET1!D70>0),J91/F169,0)
END OF AUL SUM TOTAL OF SHARES Code
Heir
Share A ZF J43 J47
A ZF
1 2
H W
3
S
45
D
J51
0.00
6 78
SS SD
J56
0.00
SSS SSD
J61
0
9 1011
0 0
ZF 12 13
F M
J64 J70
0.00 0.00
14 15 16
FF FM MM
J73 J80 J81
0 0 0.17
1718 1920
RB RS
J84
0
2122 2324
PB PS
J88
0.00
2526 27
MT MR
J91
0.00
ZF A
ZF A
J59
END OF SUM TOTAL OF SHARES
1. FINAL SHARES
Code
Heir
1 2 3 45 6 78 9 ### 12 13 14 15 16 ### ### ### ### ### 27
H W S D SS SD SSS SSD F M FF FM MM RB RS PB PS MT MR *
ZF+RES
ZF+RES
J43
0
J47
0.00
F117
0.00
J51+F118
0.00
F124
0.00
J56+H132
0.00
F130
0.00
J61+F131
0.00
J64+F134
0.000
J70
0.000
J73+F138
0.00
J80
0.00
J81
0.17
H263=
0.83
H264=
0.00
F153
0.00
J88+F157
0.00
J91
0.00
F160
0.00
SUM1=
ZF+RES ZF+RES J286+J287+J288+J289+J290+J291+J292+J293+J294+J295
SUM2=
J296+J297+J298+J299+J300+J301+J302+J303+J304
SUM=
SUM1+SUM2= RES ZF+RES=
G306+G307 0.00
Distant Kindred Class 1 N=
SHEET1!D74*2+SHEET1!D76
DS
C151=
IF(AND(SHEET1!D74>0),C311*(2*SHEET1!D74/K341)
DD
C152=
IF(AND(SHEET1!D76>0),C311*(1*SHEET1!D76/K341)
RES=
C311-K342-K343
Distant Kindred Class 2 N= MF
Sheet1!D56 IF(AND(SHEET1!D56=1),K344,0)
RESDK2=
Distant Kindred Class 3 PROP=
0.00
NRB=
RBD
B323
NRS=
RSS+RSD
C323+D323
NR=
2*NRB+NRS
2*F356+F357
NPB=
PBD
E323
NPS=
PSS+PSD
F323+G323
NP=
2*NPB+NPS
F359*2+F360
NMT=
MBS+MBD+MSS+MSD=
DK3: ZF START SHARE OF RSS+RSD: SRS2=
IF(AND((RSS+RSD)>1,NRB=0),PROP*2/3,0)
CELL
IF(AND(C323+D323)>1,B323=0,G350*2/3,0)
RSS2=
IF(AND(RSS>0),SRS2*(2*C323/(2*C323+D323)),0)
CELL
IF(AND(C323>0),F367*(2*C323/(2*C323+D323)),0)
RSD2=
IF(AND(RSD>0),SRS2*(1*D323/(2*C323+D323)),0)
CELL
IF(AND(D323>0),F367*(1*D323/(2*C323+D323)),0)
RSS1=
IF(AND((RSS+RSD)=1,NRB=0),PROP*1/2,0)
CELL
IF(AND(C323+D323=1,B323=0),G350*1/2,0)
RSS1=
IF(AND(RSD=0),RS1,0)
CELL
IF(AND(D323=0),F372,0)
RSD1=
IF(AND(RSS=0),RS1,0)
CELL
IF(AND(C323=0),F372,0)
RSS BASIC MAX(RSS2,RSS1) CELL
MAX(F368,F374)
RSD BASIC RSD2+RSD1) CELL
MAX(F370,F376)
RESIDUE FROM RSS+RSD: RES RSS+RSD RESDK2-(BASIC RSS+BASIC RSD) CELL
G350-F378-F380
ZF-DK3 SHARE OF PSS+PSD PS2=
IF(AND((PSS+PSD)>1,PBD=0,RBD=0,RSS=0,RSD=0),PROP*2/3,0)
CELL
IF(AND((F323+G323)>1,E323=0,B323=0,C323=0,D323=0),G350*2/3,0)
PS1=
IF(AND((PSS+PSD)=1,PBD=0,RBD=0,RSS=0,RSD=0),PROP*1/2,0)
CELL
IF(AND((F323+G323)=1,E323=0,B323=0,C323=0,D323=0),G350*1/2,0)
PS0=
IF(AND(PSS+PSD>0,PBD=0,RBD=0,(RSS+RSD)=1,PROP*1/6,0)
CELL
IF(AND(F323+G323)>0,E323=0,B323=0,(C323+D323)=1),G350*1/6,0)
SPSS2= IF(AND(PSS>0),PS2*(2*PSS/(2*PSS+PSD),0) CELL
IF(AND(F323>0),G390*(2*F323/(2*F323+G323)),0)
SPSD2= IF(AND(PSD>0),PS2*(1*PSD/(2*PSS+PSD)),0) CELL
IF(AND(G323>0),G390*(1*G323/(2*F323+G323)),0)
SPSS1= IF(AND(PSS>0),PS1*(2*PSS/(2*PSS+PSD)),0) CELL
IF(AND(F323>0),G392*(2*F323/(2*F323+G323)),0)
SPSD1= IF(AND(PSD>0),PS1*(1*PSD/(2*PSS+PSD)),0) CELL
IF(AND(G323>0),G392*(1*G323/(2*F323+G323)),0)
SPSS0= IF(AND(PSS>0),PS0*(2*PSS/(2*PSS+PSD)),0) CELL
IF(AND(F323>0),G394*(2*F323/(2*F323+G323)),0)
SPSD0= IF(AND(PSD>0),PS0*(1*PSD/(2*PSS+PSD)),0) CELL
IF(AND(G323>0),G394*(1*G323/(2*F323+G323)),0)
SPSSMAX= MAX(SPSS2,SPSS1,SPSS0) CELL
MAX(G395,G399,G404)
SPSDMAX= MAX(SPSD2,SPSD1,SPSD0) CELL
MAX(G397,G401,G406)
Residue from PSS+PSD= MT2=
IF(AND(MT>1),1/3*BOK3,0)
CELL
IF(AND(F362>1),1/3*G350,0)
MT1=
IF(AND(NSHEET1!DT=1),1/6*BODK3,0)
CELL
IF(AND(F362=1),1/6*G350,0)
MT=
MAX(SSHEET1!DT2,SSHEET1!DT1)
F383-(G408+G410)
CELL
RES MT--DK3= CELL
BASIC MT
MAX(G413,G415) RESIDUE FROM MT
G411-G417
RESIDUE FROM MT--DK3 IN CELL I381
DK3-RESIDUARIES START RB=
IF(AND(NRB>0),RES6*(2*NRB/NR),0)
CELL
IF(AND(F356>0),G419*(2*F356/F358),0)
RS=
IF(AND(NRB>0,NRS>0),RES6*(1*NRS/NR),0)
CELL
IF(AND(F356>0,F357>0),G419*(1*F357/F358),0)
RES7=RES6-RB-RS CELL G419-G424-G426 RBD=
IF(AND(RBD>0),RB,0
CELL
IF(AND(B323>0),G424,0)
RSS+RSD
CELL NRS1 2*RSS+RSD CELL 2*C323+D323
RS= G426
RSS=
IF(AND(RSS>0,NRB>0),RS*(2*RSS/NRS),0)
CELL
IF(AND(C323>0,F356>0),F435*(2*C323/F437),0)
RSD=
IF(AND(RSD>0,NRB>0),(RSS+RSD)-RSS)
CELL
IF(AND(D323>0,F356>0),F435-F439,0)
RES5 RES7
CELL
G428
share of PBD+PSS+PSD
SHARE OF PBD SPBD=
IF(AND(PBD>0),SPAT*2*PBD/NP,0)
CELL
IF(AND(E323>0),F444*2*E323/F361,0)
SHARE OF PSS+PSD SPSS+PSDIF(AND(PBD>0),SPAT*1*PS/NP,0)
CELL
IF(AND(E323>0),F444*1*F360/F361,0)
SHARE OF PSS PSS= CELL
IF(AND(PBD>0),PS*2*PSS/(2*PSS+PSD),0) IF(AND(E323>0),F458*2*F323/(2*F323+G323),0)
SHARE OF PSD PSD= IF(AND(PBD>0),PS*1*PSD/(2*PSS+PSD),0) CELL IF(AND(E323>0),F458*1*G323/(2*F323+G323),0) RES6= RES7
CELL
F444-F463-F467
RESIDUE FROM PBD+PSS+PSD
RADD DK3 BEGINS TDK3= CELL
SUM TOTAL BASIC DK3 AS ZF RSS+RSD+PSS+PSD+MT F378+F380+G408+G410+G417
RSS= CELL
IF(AND(RES6>0),RSS*BOK3/TDK3,0) IF(AND(B470>0,B476>0),C350*B378/B476,0)
RSD= CELL
IF(AND(RES6>0),RSD*BOK3/TDK3,0) IF(AND(F470>0),G350*F380/F476,0)
PSS= CELL
IF(AND(RES6>0),PSS*BOK3/TDK3,0) IF(AND(F470>0),G350*G408/F476,0)
PSD= CELL
IF(AND(RES6>0),PSD*BOK3/(BOK3-TDK3),0) IF(AND(F470>0),G350*G410/F476,0)
MT= CELL
IF(AND(RES6>0),SSHEET1!DT*BOK3/(BOK3-TDK3),0) IF(AND(F470>0),G350*G417/F476,0)
END OF RETURN DK3 FINAL SHARES DK 1, 2, 3 DS= DD=
K342 K343
MF=
I312
RBD= RSS= RSD=
G431 MAX(MAX(F439,F479),F377) MAX(MAX(F441,F482),F380)
PBD= PSS= PSD=
F454 MAX(MAX(F463,F485),G403) MAX(MAX(F467,F488),G409)
MT= MAX(F491,G417) TDK123= F472+F473+F475+F477+F478+F479+F481+F482+F483+F485 CELL RESIDUE RES FROM C1-27-TDK123 DK123= CELL C311-F512
DK4 BEGIN F= NO FATHER SIDE= CELL
FRS+FPS+FMB+FMS 0.00
M= NO MOTHER SIDE= CELL
MRB+MRS+MPB+MPS+MMB+MMS 0.00
SHARE OF FRS (B307) FRS1= CELL FRS2= CELL FRS=
IF(AND(F489>0,FRS>0,SHEET1!D=0),F489,0) IF(AND(F514>0,B332>0,F520=0),F514,0) IF(AND(F489>0,FRS>0,SHEET1!D>0),2/3*F489,0) IF(AND(F514>0,B332>0,F520>0),2/3*F514,0) MAX(F523,F524)
SHARE OF FPS (C307) FPS1= CELL
IF(AND(F489>0,FPS>0,FRS=0,SHEET1!D=0),F489,0) IF(AND(F514>0,C332>0,B332=0,F520=0),F514,0)
0.00
FPS2= CELL
IF(AND(F489>0,FPS>0,FRS=0,SHEET1!D>0),2/3*F489,0) IF(AND(F514>0,C332>0,B332=0,F520>0),2/3*F514,0)
FPS=
MAX(F530,F533)
SHARE OF FMB+FMS (D307+E307) N FMBS= FMB+FMS= D332+E332 FMBS1= IF(AND(FMB>0,FRS=0,FPS=0,FMS=0),F489,0) CELL IF(AND(F539>0,B332=0,C332=0,B520=0),F514,0) FMBS2= IF(AND(FMBS>0,FRS=0,FPS=0,F513>0),2/3*F489,0) CELL IF(AND(F538>0,B332=0,C332=0,F520>0),2/3*F514,0) FMBS= CELL
FMBS1+FMBS2 F540+F543
SHARE OF FMB S FMB= IF(AND(FMB>0),SFMBS*2*FMB/(2*FMB+FMS,0) IF(AND(D332>0),F546*2*D332/(2*D332+E332),0) CELL
SHARE OF FMS SFMS= CELL
IF(AND(FMS>0),SFMBS*1*FMS/(2*FMB+FMS,0) IF(AND(E332>0),F546*1*E332/(2*D332+E332),0)
SUMF=
F526+F535+F546+F551+F557
===================================== SHARE OF MRB+MRS NM= CELL
2*MRB+MRS 2*F332+G332
NF= CELL
FRS+FPS+FMB+FMS B332+C332+D332+E332
MRB1= CELL MRB2= CELL MRB= CELL
IF(AND(F489>0,NM>0,NF=0),F489*(2*MRB/(2*MRB+MRS)),0) IF(AND(F514>0,F564>0,F567=0),F514*(2*F332/(2*F332+G332)),0) IF(AND(F489>0,NM>0,NF>0),1/3*F489*(2*MRB/(2*MRB+MRS)),0) IF(AND(F514>0,F564>0,F567>0),1/3*F514*(2*F332/(2*F332+G332)),0) MRB1+MRB2 F570+F572
MRS1= CELL
IF(AND(F489>0,NM>0,NF=0),F489*(1*MRS/(2*MRB+MRS)),0) IF(AND(F514>0,F564>0,F567=0),F514*(1*G332/(2*F332+G332)),0)
MRS2= CELL MRS= CELL
IF(F489>0,NSHEET1!D>0,NF>0),1/3*F489*(1*MRS/(2*MRB+MRS),0) IF(AND(F514>0,F564>0,F567>0),1/3*F514*(1*G332/(2*F332+G332)),0) MRS1+MRS2 F577+F579
SHARE MPB+MPS TEST NM1= CELL
2*MPB+MPS 2*H332+I332
MPB1= CELL MPB2=
IF(AND(F489>0,NM=0,NM1>0,NF=0),F489*(2*MPB/(2*MPB+MPS)),0) IF(AND(F514>0,F564=0,F585>0,F567=0),F514*(2*H332/(2*H332+I332)),0) IF(AND(F489>0,NM=0,NM1>0,NF>0),1/3*F489*(2*MPB/(2*MPB+MPS)),0)
CELL MPB= MPS1= CELL
IF(AND(F514>0,F564=0,F585>0,F567>0),1/3*F514*(2*H332/(2*H332+I332)),0) F588+F590 CELL IF(AND(F489>0,NM=0,NM1>0,NF=0),F489*(1*MPS/(2*MPB+MPS)),0) IF(AND(F514>0,F564=0,F585>0,F567=0),F514*(1*I332/(2*H332+I332)),0)
MPS2= IF(AND(F489>0,NM=0,NM1>0,NF>0),1/3*F489*(1*MPS/(2*MPB+MPS)),0) CELL IF(AND(F514>0,F564=0,F585>0,F567>0),1/3*F514*(I332/(2*H332+I332)),0) MPS= CELL
MPS1+MPS2 G593+G596
SHARE OF MMB+MMS NSHEET1!D2= 2*MMB+MMS CELL 2*B336+C336 MMB1= CELL
IF(AND(F489>0,NM=0,NM1=0,NM2>0,NF=0),F489*(2*MMB/(2*MMB+MMS)),0) IF(AND(F514>0,F564=0,F585=0,G607>0,F567=0),F514*(2*B336/(2*B336+C336)),0)
MM2= CELL MMB= CELL
IF(AND(F489>0,NM=0,NM1=0,NM2>0,NF>0),1/3*F489*(2*MMB/(2*MM+MMS)),0) IF(AND(F514>0,F564=0,F585=0,G607>0,F567>0),1/3*F514*(2*B336/(2*B336+C336)),0) MB1+MB2 G610+G613
MMS1= CELL
IF(AND(F489>0,NM=0,NM1=0,NM2>0,NF=0),F489*(1*MMS/(2*MMB+MMS)),0) IF(AND(F514>0,F564=0,F585=0,G607>0,F567=0),F514*(1*C336/(2*B336+C336)),0)
MMS2= IF(AND(F489>0,NM=0,NM1=0,NM2>0,NF>0),1/3*F489*(1*MMS/(2*MMB+MMS)),0) CELL IF(AND(F514>0,F564=0,F585=0,G607>0,F567>0),1/3*F514*(1*C336/(2*B336+C336)),0) MMS= MMS1+MMS2 CELL G593+G596 SMM=F549+F556+F566+F574+F590+F598
THE END DK4
RESDK4
F514-(F559+F624)
Final Shares Code Heir 1
No 0
Share 0
Each=
2
Wife
0
Each=
3
son
0
Each=
45
DTR
0
Each=
6
SS
0
SD
0
SSS
0
SSD
0
F
0
M
0
Each=
14
FF
0
Each=
15
FM Each=
0.00
0.00
Each=
13
0.00
0.00
Each=
12
0.00
0.00
Each=
###
0.00
0.00
Each=
9
0.00
0.00
Each=
78
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0
0.00
0.00 0.00 0.00 0.00 0.00
16
MM
1
Each=
###
RB
1
Each=
###
RS
0
Each=
###
PB
0
Each=
###
PS
0
Each=
###
MT
0
Each=
27
MR
0
Each=
151
DS
0
Each=
152
DD Each=
0
16.67 16.67 83.33 83.33 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
------------------------------------------------------Total= Bait ul SHEET1!Dall=
Warning Do not enter data in this sheet
(Vested heritage)
erty worth RS 100,000 . ns (Aqil and Baseer), daughter (Bano)
nd Hinda also in year 1410 and 1415
measuring 100 kanals
d (1380)
----- -------------- ---------- ---| | Bano
3 Hinda (1415)
3 problems in succession:
Hinda (1415) p=12.50+5.83= Total 12.22 ### 6.11 ###
check
8.75 ###
============= =======
UNITY (1 )
46+SHEET1!D48+SHEET1!D50
0
68+SHEET1!D70
1
=0,SHEET1!D44=0),2/3,0) =0,SHEET1!D44=0),1/2,0) =0,SHEET1!D44=0),1/6,0)
0 0 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
=0,SHEET1!D44=0,SHEET1!D46=0,SHEET1!D48=0),2/3,0) 0.00 =0,SHEET1!D44=0,SHEET1!D46=0,SHEET1!D48=0),1/2,0) 0.00 2+SHEET1!D46=1),SHEET1!D44=0,SHEET1!D48=0),1/6,0) 0.00 0.00
=1,J65=0,J66=0,J67=0),1/4,0)
>0,SHEET1!D60>0),1/12,0)
0.000 0.000 0.000 0.000 0.000 0.000 0.000
0.00
0.00 0.00 =0,SHEET1!D54=0),1/6,0) 0.00 0.17 0.00 0.17 T1!D62=0,SHEET1!D64=1),1/2,0) ] 0.00 T1!D62=0,SHEET1!D64>1),2/3,0) 0.00 0.00 T1!D62=0,SHEET1!D64=0,SHEET1!D66=0,SHEET1!D68=1),1/2,0) 0.00
T1!D62=0,SHEET1!D64=0,SHEET1!D66=0,SHEET1!D68>1),2/3,0) 0.00 T1!D56=0,SHEET1!D62=0,SHEET1!D66=0,SHEET1!D68>0),1/6,0) 0.00 0.00 T1!D70=1),1/6,0) 0.00 T1!D70>1),1/3,0) 0.00
END OF ZF 0.00 ZF = ==================== H W D SD SSD F M FF
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
FM MM RS PS MT
0.00 0.17 0.00 0.00 0.00
0.167 0.83
RESIDUARIES 0 0.00 0.00 0.83
0 0.00 0.00 0.83
6+2*SHEET1!D48+SHEET1!D50),2*SHEET1!D48+SHEET1!D50) 0.00 0.00
9/SHEET1!D242,0) HEET1!D242,0)
2=0),SHEET1!D245,0)
ET1!D64=0),F155,0)
(Mas'la Tashbeeb)
0.00 0.00 TSD=0.00 0.83 0.00 0.83
0.00 0.83
2.00 0.83 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.167 0.00 0.167
###
HEET1!D462,0)
0.00
HEET1!D462,0)
0.00
HEET1!D462,0)
0.00
HEET1!D462,0)
0.00
HEET1!D462,0)
0.00
HEET1!D462,0)
0.00
HEET1!D462,0)
0.00
HEET1!D462,0)
0.00
HEET1!D462,0)
0.00
ND OF RETURN
AS'ILA AL-AUL) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00
B RES
B RES
C= C D= D E RADDRADDAULAUL AUL+RADD F211 0.00 F211 F212 0.00 F212
F117
0.00
F118
0.00 F180
F124 H132 F130 F131
F138
0.00 S 0.00 F180+F214
0.00 D
0.00 0.00 F183 0.00 F216
0.00 0.00 F183+F216
0.00 SS 0.00 SD
0.00 0.00 F186
0 F218
0.00 0.00 F186+F218
0.00 SSS 0.00 SSD
F189
F219 0 F221
0.00 F219 0.00 F189+F221
0.00 F 0.00 M
F192 F196
F223 0 F224 0 F225
0.00 F223 0.00 F192+F224 0.00 F196+F225
0.00 FF 0.00 FM 0.00 MM
RES F134
E AUL+RADD 0.00 H 0.00 W
0 F214
RADD 0.00
0.00
H148 H154
0.83 0.00 H205=
0 F226
0.00 0.00 H205+L264=
0.00 RB 0.00 RS
F153 F157
0.00 0.00 H208=
0 F227
0.00 0.00 H208+L267=
0.00 PB 0.00 PS
F160
0.00
H211=
RES B
RES B
0 H233= 0.00 H211= 0.00
RADDRADDAULAUL C= C D= D
D OF SUM TOTAL OF SHARES
PROP= ### RS
AUL+RADD E
0.00 MT 0.00 MR AUL+RADD E
RADD+AUL
RADD+AUL FINALFINALAMT AMT HEIR CLASSCLASS
L236
0.00 IF(AND(F286>0),.F286,D286), 0.00 H286*K277 0.00 H
L237
0.00 IF(AND(F287>0).F287,D287) 0.00 H287*K277 0.00 W
L239
0.00 IF(AND(F288>0).F288,D288) 0.00 H288*K277 0.00 S
L241
0.00 IF(AND(F289>0).F289,D289) 0.00 H289*K277 0.00 D
L244
0.00 IF(AND(F290>0).F290,D290) 0.00 H290*K277 0.00 SS
L245
0.00 IF(AND(F291>0).F291,D291) 0.00 H291*K277 0.00 SD
L247
0.00 IF(AND(F292>0).F292,D292) 0.00 H292*K277 0.00 SSS
L248
0.00 IF(AND(F293>0).F293,D293) 0.00 H293*K277 0.00 SSD
L251
0.00 IF(AND(F294>0).F294,D294) 0.00 H294*K277 0.00 F
L252
0.00 IF(AND(F295>0).F295,D295) 0.00 H295*K277 0.00 M
L254
0.00 IF(AND(F296>0).F296,D296) 0.00 H296*K277 0.00 FF
L255
0.00 IF(AND(F297>0).F297,D297) 0.00 H297*K277 0.00 FM
L256
0.00 IF(AND(F298>0).F298,D298) 0.17 H298*K277 16.67 MM
L258
0.00 IF(AND(F299>0).F299,D299) 0.83 H299*K277 83.33 RB
L259
0.00 IF(AND(F300>0).F300,D300) 0.00 H300*K277 0.00 RS
L261
0.00 IF(AND(F301>0).F301,D301) 0.00 H301*K277 0.00 PB
L262
0.00 IF(AND(F302>0).F302,D302) 0.00 H302*K277 0.00 PS
L264
0.00 IF(AND(F303>0).F303,D303) 0.00 H303*K277 0.00 MT
L265
0.00 IF(AND(F304>0).F304,D304) 0.00 H304*K277 0.00 MR
RADD+AUL J292
Heir
RADD+AUL FINALAMTAMT CLASS CLASS 0.00 ### ### RS
ET1!D74*2+SHEET1!D76
0
ND(SHEET1!D74>0),C311*(2*SHEET1!D74/K341),0)
0.00
ND(SHEET1!D76>0),C311*(1*SHEET1!D76/K341),0)
0.00
1-K342-K343
0.00
0
ND(SHEET1!D56=1),K344,0)
0
K344-G349
0.00
0 males 0 females 0 eq females
0 males 0 females 0 eq females 0.00
0.00
0.00 RSS OUT OF 2/3 SHARE
0.00
3
0.00
###
0.00
###
0.00
###
0.00
BASIC RSS
0.00
BASIC RSD
+RSD: 0.00
PROP*2/3,0)
3=0),G350*2/3,0)
0
PROP*1/2,0)
3=0),G350*1/2,0)
0
=1),G350*1/6,0)
0
3-(G408+G410)
0
0
0.00
0.00
0.00
0.00
0.00 PSS BASIC
0.00 PSD BASIC
#REF!
### #REF! 0.00
0.00
ASIC MT
0.00
###
###
###
RESIDUE FROM RB+RS ###
###
0.00
0
0.00
0.00
RESIDUE FROM RBD+RSS+RSD
0.00
0.00
0.00
0.00
0.00
0.00
D+PSS+PSD
EGINS 0.00
0.00 RSS
0.00 RSD
0.00 PSS
0.00 PSD
0.00 MT
RN DK3 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
+FPS+FMB+FMS
+MRS+MPB+MPS+MMB+MMS
0.00 0.00 0.00
0.00
0.00 0.00
S (D307+E307)
?? 0 Err:502 0.00
0.00
0.00
(D307) 0.00
0.00 0.00
===========
0
0
2+G332)),0)
0.00
F332+G332)),0)
0.00
32+G332)),0)
0 0
0.00
0.00
MRB+MRS),0) *F332+G332)),0)
MPB+MPS)),0) 2/(2*H332+I332)),0) B/(2*MPB+MPS)),0)
0.00 0.00
0
0.00
F514*(2*H332/(2*H332+I332)),0) ### ### *MPS/(2*MPB+MPS)),0) 4*(1*I332/(2*H332+I332)),0) ###
9*(1*MPS/(2*MPB+MPS)),0) F514*(I332/(2*H332+I332)),0) ###
0.00
0
MMB/(2*MMB+MMS)),0) 4*(2*B336/(2*B336+C336)),0)
###
*(2*MMB/(2*MM+MMS)),0) F514*(2*B336/(2*B336+C336)),0)
### ###
MMS/(2*MMB+MMS)),0) 4*(1*C336/(2*B336+C336)),0)
###
*(1*MMS/(2*MMB+MMS)),0) F514*(1*C336/(2*B336+C336)),0)
###
0.00 Err:508
Err:508
Code
Heir No Share 173 MF 0 ### ### RS Each= 215 RBD 0 ### ### RS Each= 216 RSS 0 ### ### RS Each= 217 RSD 0 ### ### RS Each= 218 PBD 0 ### ### RS Each= 219 PSS 0 ### ### RS Each= 220 PSD 0 ### ### RS Each= 221 MBS 0 ### ### RS Each= 222 MBD 0 ### ### RS Each= 223 MSS 0 ### ### RS Each= 224 MSD 0 ### ### RS Each= 247 FRS 0 ### ### RS Each=
248 FPS 0 ### Each=
### RS
249 FMB 0 ###
### RS 250 FMS 0 ### ### RS Each= 251 MRB 0 ### ### RS Each= 252 MRS 0 ### ### RS Each= 253 MPB 0 ### ### RS Each= 254 MPS 0 ### ### RS Each= 255 MMB 0 ### ### RS Each= 256 MMS 0 ### ### RS Each= Each=
------------------------### RS
t ul SHEET1!Dall= F628= ### RS
Thanks
s sheet
The Muslim Family Code list of prospective heirs Alive at the time of death of the deceased TABLE 1: Code 1 to 26 Code Number Name of Heirs 1 Husband 2 Wife(one/more)
Abbreviation H W
3
Son (one/more)
S
4 5
Daughters(two/more) Daughter (single)
D D
6 7 8
Sons son (one/more) Sons daughters(two/more) Sons daughter (single)
SS SD SD
9 10 11
Sons sons son (one/more) Sons sons daughters (two/more) Sons sons daughter (single)
SSS SSD SSD
12 13
Father Mother
F M
14
Fathers father
FF
15 16
Fathers mother Mothers mother
FM MM
17 18
Real brothers (two/more) Real brother (single)
RB RB
19 20
Real sisters (two/more) Real sister (single)
RS RS
21 22
Paternal brothers(two/more) Paternal brother (single)
23 24
Paternal sisters (two/more) Paternal sister (single)
25 26
Maternal brother/sister (two/more) Maternal brother/sister (single)
(*) PB PB PS PS (**)
(*) Paternal brother/sister is the person, who is from the same father as the dying person, but from a different mother. (**) Maternal brother/sister is the person, who is from the same mother as the dying person, but from a different father. ---------------------------------------------
TABLE 2: (Tree) Code 27 to 149 This table comprises Male residuaries Mail Residuary --------------------------MR MR Rule:
Only the smallest code from among code 27 to 144 will inherit.
Similarly, smallest from among code 12, 14, 145-149 will inherit
A male residuary is a male who is related to the DP (Deceased Person) thro Thus, Real brother's son is a male residuary Real brother's daughter is not a male residuary Mother's father is not a male residuary Father's brother's son is a male residuary Father's sister's son is not a male residuary Father's maternal brother is not a male residuary (because, though male himself, is related to the DP through mother/female) >>> All those MALES who are not listed in table 1 or table 2, fall in the category of Distant Kindred. >>> All those FE-MALES who are not listed in Table 1 fall in the category of Distant Kindred. >>> Only those persons can inherit, who have a blood relation with DP. (Husband/ wife is the only exception. They do inherit, though have no blood Further explanation Code 33= Code 12 (DP's father's real brother Code 34= Code 12 (DP's father's Paternal brother Code 35= Son of Code 33 Code 36= Son of Code 34 Example Zaid was survived by his father (code 12)'s FF's (code 145)'s FFF's (code 148)'s paternal brother (code 104)'s SS (Code 108)'s son (code 110)/Abdullah. Thus as per this Ttree, Code of Abdullah = 110 Adam (peace be upon him) !
<< Real brother ! Paternal brother >> 123---------------------149-----------------------! ! 125 103 -----------------148---------------------104 ! ! ! ! 127 105 85---------------147---------------- 86 106 ! ! ! ! ! ! 129 107 87 69------------146-------------70 88 108 ! ! ! ! ! ! ! ! 131 109 89 71 55---------145----------56 72 90 110 ! ! ! ! ! ! ! ! ! ! 133 111 91 73 57 43-------14-------44 58 74 92 112 ! ! ! ! ! ! ! ! ! ! ! ! 135 113 93 75 59 45 33----12----34 46 60 76 94 114 ! ! ! ! ! ! ! ! ! ! ! ! ! ! 137 115 95 77 61 47 35 RB-DP-PB 36 48 62 78 96 116 ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! 139 117 97 79 63 49 37 27 28 38 50 64 80 98 118 ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! 141 119 99 81 65 51 39 29 30 40 52 66 82 100 120 ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! 143 121 101 83 67 53 41 31 32 42 54 68 84 102 122 DP= Dying Person whose left over property is to be divided RB= Real Brother of DP PB= Paternal Brother of DP ------------------------------------------------------------
Table 3: Code 150: Code 151 to 300 Distant Kindred (Zawil Arham) Code 150 has been allotted to them as a Class. This Class comprises Cod 151 to 300 as listed below.
Distant Kindred (Zawil Arham)
124 ! 126 ! 128 ! 130 ! 132 ! 134 ! 136 ! 138 ! 140 ! 142 ! 144
Family Distant Kindred Class A Group 1 151 Daughter Son (To be read as Dying Person's Daughter's Son) 152 Daughter Daughter
Group 2 153 Son Daughter Son
(Dying Person's Son's Daughter's Son)
154 Son Daughter Daughter Group 3 155 Daughter Son Son 156 Daughter Son Daughter 157 Daughter Daughter Son 158 Daughter Daughter Daughter
Group 4 159 Son Son Daughter Son 160 Son Son Daughter Daughter Group 5 161 Son Daughter Son Son 162 Son Daughter Son Daughter 163 Son Daughter Daughter Son
DS DD
164 Son Daughter Daughter Daughter 165 Daughter Son Son Son 166 Daughter Son Son Daughter 167 Daughter Son Daughter Son 168 Daughter Son Daughter Daughter 169 Daughter Daughter Son Son 170 Daughter Daughter Son Daughter 171 Daughter Daughter Daughter Son 172 Daughter Daughter Daughter Daughter
Family Distant Kindred Class B Group 6 173 Mother Father
(Dying Person's mother's Father)
Group 7A 174 Father Mother Father Group 7B 175 Mother Father Father 176 Mother 1. Father Mother 177 Mother 2. Mother Father Group 8A
MF
178 Father 1. Father Mother Father 179 Father 2. Mother Father Father 180 Father Mother Father Mother 181 Father Mother Mother Father Group 8B 182 Mother Father Father Father 183 Mother Father Father Mother 184 Mother Father Mother Father 185 Mother Father Mother Mother 186 Mother Mother Father Father 187 Mother Mother Father Mother 188 Mother Mother Mother Father Group 9A 189 Father Father Father Mother Father 190 Father Father Mother Mother Father 191 Father Father Mother Father Father 192 Father Father Mother Father Mother 193 Father Mother Father Father Father 194 Father Mother Father Father Mother 195 Father Mother Father Mother Father 196 Father Mother Father Mother Mother
197 Father Mother Mother Father Father 198 Father Mother Mother Father Mother 199 Father Mother Mother Mother Father Group 9B 200 Mother Father Father Father Father 201 Mother Father Father Father Mother 202 Mother Father Father Mother Father 203 Mother Father Father Mother Mother 204 Mother Father Mother Father Father 205 Mother Father Mother Father Mother 206 Mother Father Mother Mother Father 207 Mother Father Mother Mother Mother 208 Mother Mother Father Father Father 209 Mother Mother Father Father Mother 210 Mother Mother Father Mother Father 211 Mother Mother Father Mother Mother 212 Mother Mother Mother Father Father 213 Mother Mother Mother Father Mother 214 Mother Mother Mother Mother Father ------------------------------------------
Family Distant Kindred Class C
Group 10 215 Real Brother Daughter
RBD
Group 11 216 Real Sister Son 217 Real Sister Daughter
RSS RSD
Group 12 218 Paternal Brother Daughter
PBD
Group 13 219 Paternal Sister Son 220 Paternal Sister Daughter
PSS PSD
Group 14 221 Maternal Brother Son 222 Maternal Brother Daughter 223 Maternal Sister Son 224 Maternal Sister Daughter Group 15 225 Real Brother Son Daughter Group 16 226 Paternal Brother Son Daughter Group 17 227 Real Brother Daughter Son
MBS MBD MSS MSD
228 Real Brother Daughter Daughter Group 18 229 Real Sister Son Son 230 Real Sister Son Daughter 231 Real Sister Daughter Son 232 Real Sister Daughter Daughter Group 19 233 Paternal Brother Daughter Son 234 Paternal Brother Daughter Daughter Group 20 235 Paternal Sister Son Son 236 Paternal Sister Son Daughter 237 Paternal Sister Daughter Son 238 Paternal Sister Daughter Daughter Group 21 239 Maternal Brother Son Son 240 Maternal Brother Son Daughter 241 Maternal Brother Daughter Son 242 Maternal Brother Daughter Daughter 243 Maternal Sister Son Son 244 Maternal Sister Son Daughter 245 Maternal Sister Daughter Son 246 Maternal Sister Daughter Daughter -----------------------------------------------------
Family Distant Kindred Class D Group 22 247 Father Real Sister
FRS
Group 23 248 Father Paternal Sister
FPS
Group 24 249 Father Maternal Brother 250 Father Maternal Sister
FMB FMS
Group 25 251 Mother Real Brother 252 Mother Real Sister
MRB MRS
Group 26 253 Mother Paternal Brother 254 Mother Paternal Sister
MPB MPS
Group 27 255 Mother Maternal Brother 256 Mother Maternal Sister Group 28 257 Father Real Brother Daughter Group 29 258 Father Paternal Brother Daughter Group 30 259 Father Real Sister Son 260 Father Real Sister Daughter
MMB MMS
Group 31 261 Father Paternal Sister Son 262 Father Paternal Sister Daughter Group 32 263 Father Maternal Brother Son 264 Father Maternal Brother Daughter 265 Father Maternal Sister Son 266 Father Maternal Sister Daughter Group 33 267 Mother Real Brother Son 268 Mother Real Brother Daughter 269 Mother Real Sister Son 270 Mother Real Sister Daughter Group 34 271 Mother Paternal Brother Son 272 Mother Paternal Brother Daughter 273 Mother Paternal Sister Son 274 Mother Paternal Sister Daughter Group 35 275 Mother Maternal Brother Son 276 Mother Maternal Brother Daughter 277 Mother Maternal Sister Son 278 Mother Maternal Sister Daughter Group 36 279 Father father Real sister 280 Father mother Real brother 281 Father mother Real sister
Group 37 282 Father father paternal sister 283 Father mother paternal brother 284 Father mother paternal sister
Group 38 285 286 287 288
Father father maternal brother Father father maternal sister Father mother maternal brother Father mother maternal sister
Group 39 289 mother mother real brother 290 mother mother real sister
Group 40 291 mother father real brother 292 mother father real sister Group 41 293 mother mother paternal brother 294 mother mother paternal sister Group 42 295 mother father paternal brother 296 mother father paternal sister Group 43 297 mother mother maternal brother 298 mother mother maternal sister Group 44 299 mother father maternal brother 300 mother father maternal sister -------------------------------------------Note: For the time being the program SUNNILAW.FOR coves only code 1 to 278. ---------------------------------------------NOTE: 1. ALL THESE RELATIONS ARE WITH RESPECT TO THE DYING PERSON.
2. ONLY BLOOD RELATIONS INHERIT.
----------------------------------------------------------
ceased
MT MT
om the same
from the same erent father.
to 149 residuaries
144 will inherit.
Deceased Person) through males only.
herit, though have no blood relation with each other)
brother >> ------------ 124 ! ---------104 126 ! ! ----- 86 106 128 ! ! ! --70 88 108 130 ! ! ! ! 6 72 90 110 132 ! ! ! ! ! 8 74 92 112 134 ! ! ! ! ! 0 76 94 114 136 ! ! ! ! ! 2 78 96 116 138 ! ! ! ! ! 4 80 98 118 140 ! ! ! ! ! 6 82 100 120 142 ! ! ! ! ! 8 84 102 122 144
a Class. isted below.
E DYING PERSON.
The Islamic law of Inheritance in brief Zawil Furud Table 4 Children =S, D, SS, SD, SSS, SSD Definitions Ikhwa =2 or more persons (irrespective of sex) from among (real, paternal and maternal) brothers and sisters, all put together. Example: 1 RB + 1 PS constitute ikhwa √=Alive x = Not Alive 2 > = 2 OR more in number
SNO
Heir 1
1H
Share (Alternate) 3
2
1/2 1/4
12/24 6/24
2W
3D
1/4
6/24
1/8
3/24
2/3
16/24
1/2
12/24
4
4 SD
2/3
16/24
1/2
12/24
1/6 2/3
4/24 16/24]
5 SSD 1/2 1/6
12/24 4/24
6F
1/6
4/24
7M
1/6
4/24
1/4
6/24
1/3
8/24
1/6
4/24
1/6
4/24
8 FF 9 FM 10 MM
Sno
Heir 1
Share 23
4
11 RS
2/3
16/24
1/2 2/3
12/24
12 PS
16/24
13 MT
1/2
12/24
1/6
4/24
1/3
8/24
1/6
4/24
$ To be subdivided equally among all MTL irrespective of sex D1= Daughter 1 SD1= Son's daughter 1 RS1= Real Sister 1
Asabat (=Residuaries)
Table 5
(Those who get the Residue left from Zawil Furud) S.No Heir
14 S
15 SS
16 SSS
→
D
SD
SSD
*1
*1
*1 *2
*1
[C145 = Code 145] A double share to the male. If male is not alive, the female stands exclud ed
*2
*3
SD (C7/C 8) shall also share with SSS(C 9), if it did not get as Zawil Furud Least of C14 (FF) and C145 to C149 gets the Residu e
*4 *5
*6
She will get a share here only if she did not, in Table 3 Furthe r: [RS>]x Least among C27 to C144 shall get the residu e from Table 3
*7
*8
In case none among Sno 14 to 23 gets the residu e, the same shall be divide d among ZFN in the ratio of their basic shares The Residu e goes over to the Distan t Kindr ed (C150)
of Inheritance in brief (Those getting fractional shares)
ve of sex) from among rnal) brothers and sisters, all put together. constitute ikhwa
Condition 5 A. Zawil Furud Sababi (ZFS) [CH]x [CH]√ [CH]x [CH]√ B. Zawil Furud Nasabi (ZFN) [2>] . [S]x [1 ] . [S]x
[2>] . [S. D. SS]x [1] .
[
"
]x
[D1 >]√ . [S. SS]x [2>] . [S. D. SS. SD. SSS]x [1 ] . [
"
]x
[D1 or SD1]√ . [S. SS. SSS]x [CH]√ [CH]√ or [Ikhwa]√ or [H+F]√ [W+F]√ . [1/6]x [1/6]x . [1/4]x [CH]√ . [F]x [F (Hanafi and Maliki)]x . [M]x [M]x
Condition 5
[2>] . [CH. F. FF. RB]x [1 ] . [
"
]x
[2>] . [CH. F. FF. RB. RS. PB]x
[1 ] .
[
"
]x
[RS1]√ . [CH. F. FF. RB. PB]x
[2>] . [CH. F. FF]x .............. $
[1 ] . [
"
]x
MTL irrespective of sex 1 RS1= Real Sister 1
duaries)
Zawil Furud) 17 F
18 FF
19 RB
20
21 PB
22
C145 to C149
RS
RS *3
PS
PS *4
*1
*4 *1
*5
23
24
25
26 baitul mal
C27
R
DK
to A C144 D D C 150 *6
*7
*8
4 Typical problems Problem 1 DP= Zaid
YOD=
2005
Solution
ADA= Assumed Divisible Amount
1
2
Heir 2W M F 4 S (=8 D) 2 D (=2D) 3 MT (2 male + b1 female) 4 RB Explanation COL 2 COL 3:
PROP=
Share * 1/8 * 1/6
3
ADA
1/6 Residue . x x
. x x * (8x6=)48
4 Share each 6 6/48/2 8 8/48 8 8/48 26 2x26/48/10 26/48/10 x x
For abbreviations see tablev 1/Sheet 3
ADA = 8 X 6 = 48 Share of 2 W= Share of 2 M= Share of 2 F= Sum total of zawil furuz= Residue= ADA-22=
Ignore number occuring twice 48/8= 48/6= 48/6= 6+8+8= 40-22=
COL4
2 W= 4S+2D= Share 1 D= Share 1 S =
1 W= 10 D 26/48/10 2x26/48/10
6/48/2 Son gets double the share od a DTR
COL 5
Quantum
1 W=
6/48/2X400=
6/48
Problem 2
see sheet 4 table 1 6 8 8 22 26 This goes to son
25
Problem of Excess
if sum total of shares of zawil furuz exceeds ADA, then replace ADA by the sum total DP= Hinda
YOD=
1999
Solution 1
PROP=
ADA= Assumed Divisible Amount 2
3
4
Heir Heir M F 6D
Share * 1/4 * 1/6
ADA
1/6 * 2/3
Share each 18 18/90 12 12/90 12 12/90 48 48/90/6
* (72=) 90
Explanation COL 2 COL 3:
For abbreviations see Sheet 3
ADA = 4 x 6 x 3 = 72 Ignore number occuring twice Share of H= 72/4= Sum total of zawil furuz= 18 + 12 + 12 + 48= Sum total having exceeded ADA, ADA replaced by sum total
Problem 3
Problem of Return
see sheet 4 table 1 18 90
Case 1
When H (W) not alive
that is when there is some residue from zawilm furuz (table 1), but none in table 2 to get it. It will go back to zawil mfuruz, except to H (W) DP= Aqil
YOD=
1985
PROP=
Solution 1
2
Heir M I MT 1 RS
Share * 1/6
3
4 Share each 2 2/10 2 2/10 6 6/10
ADA 1/6
* 1/2 * (12) 10
Explanation COL 2
For abbreviations see Table Sheet 3
ADA = 6 x 2 = 12
Problem 4
Problem of Return
Case 2
When H (W) is alive
that is when there is some residue from zawilm furuz (table 1), but none in table 2 to get it. It will go back to zawil mfuruz, except to H (W) DP= Aqil
YOD=
1985
PROP=
Solution 1
2
3
4
Heir W M I MT
Share * 1/4 * 1/3 * 1/6
ADA
Share each 18 18/72/2 24 24/36 12 12/36
* (72) 36
Explanation COL 2
COL 3
For abbreviations see table 1/sheet 3
ADA =4 x 3 x 6 = 72 out of it W= 72X 1/4= 18 Quantum= 18/72 x 144= Balance = 144-36= 108 It will be divided among other zawil furuz as in problem 3 abov thus ADA for M and MT = 6x3= 18 being problem of Return, replace ADA (72) by sum total of M and MT= Share of M = 24/36 x 108= 72 Share of MT= 12/36 x 108= 36
Exercise Solve these 4 typical problems using program (by entering data in sheet 1)
There are good 268 million problems related to zawil furuz and asabat (table 2 and 3 put together. Now you should be able to attempt any such problems. For problems related to distant kindred (zawil arham), may use the program mirath (sheet 1).
Another program : ENTITLED SUNNI21.EXE (folder 5/ software package MATH.IN.ISLAM), covering nearest 278 heirs may Bagvi 11.01.2008
400 Kanals of land
5 Quantum 25.00 66.66 66.66 43.33 21.66 x x 400.00
see sheet 4 table 1
see sheet 4 table 2
Kanals
1800 grams of gold
5
Quantum 360.00 240.00 240.00 160.00 1800.00
see sheet 4 table 1
H (W) not alive RS 100
5 Quantum 20.00 20.00 60.00 100.00
H (W) is alive
RS 144
5
Quantum 18+18=36 Both W 72.00 36.00 144.00
18/72 x 144= RS 36 furuz as in problem 3 above.
24+12=
36
(sheet 1).
nearest 278 heirs may also be used.
Related Documents
1701
December 2019 5
Locked
August 2019 18
00-1701
May 2020 4
The Locked Room
May 2020 1
82255bir Form 1701.pdf
December 2019 12