Class record — three terms

CLASS RECORD — SY 2026–2027 (three terms)
Fill the yellow cells once. Weights follow DepEd Order No. 15, s. 2026 for Grades 2–10 and SHS; you can override them.

Region	[REGION]
Division	[DIVISION]
School name	[SCHOOL NAME]
School ID	[000000]
School year	2026–2027
Grade and section	Grade 7 — [SECTION]
Teacher	[TEACHER’S NAME]
Learning area	Science

Weights	From the table	Your override (optional)	Used
Written Work (WW)	20%		20%
Performance Tasks (PT)	50%		50%
Examinations (EX)	30%		30%
Check: weights add up to 100%			OK

Inside Examinations
Summative Test 1			30%
Summative Test 2			30%
Term Examination			40%

Learning area / subject group	WW	PT	EX
English	20%	50%	30%
Filipino	20%	50%	30%
Mathematics	20%	50%	30%
Science	20%	50%	30%
Araling Panlipunan	20%	50%	30%
GMRC / Values Education	20%	50%	30%
Makabansa (Grades 2–3)	20%	50%	30%
EPP / TLE	20%	60%	20%
MAPEH — Music and Arts	20%	60%	20%
MAPEH — PE and Health	20%	60%	20%
MAPEH (whole)	20%	60%	20%
SHS core / academic elective	20%	50%	30%
SHS Field Exposure / Arts Apprenticeship / Creative Production	15%	70%	15%
SHS Arts, Sports, Health and Wellness elective	20%	60%	20%
SHS Research elective / Design and Innovation	40%	60%	0%
SHS TechPro elective	15%	65%	20%
SHS Work Immersion	20%	80%	0%

■ How the grade is computed (DepEd Order No. 15, s. 2026, as reported — check the official text)
1. Percentage score of a component = learner’s total raw score ÷ total highest possible score × 100.
2. Weighted score = percentage score × weight of the component.
3. Initial grade = WW + PT + EX weighted scores. Examinations = Summative Test 1 (30%) + Summative Test 2 (30%) + Term Exam (40%).
4. Term grade = initial grade transmuted with the adjusted table for SY 2026–2027 (sheet Transmutation).
5. Final grade = average of the three term grades, rounded to a whole number. Passing = 75.
• Formative assessments are not counted in the grade — record only graded WW, PT and exams here.
• Grade 1 (and Kindergarten) use descriptive reporting, not this numerical record. Grade 12 in SY 2026–2027 keeps the
DO 8, s. 2015 weights (quarterly) — do not use this file for Grade 12.

Template — check against the current BIR/DepEd rules. Not tax/legal advice. © Layers (layers.md) · CC BY 4.0

LEARNERS — type names once
Last name, First name, Middle name. Boys first, then girls, alphabetical — as in the school forms.

No.	LRN	Learner’s name (Last, First, Middle)	Sex
1	100000000001	DELA CRUZ, Juan Miguel P.	M
2	100000000002	REYES, Paolo Andres S.	M
3			M
4			M
5			M
6			M
7			M
8			M
9			M
10			M
11			M
12			M
13			M
14			M
15			M
16			M
17			M
18			M
19			M
20			M
21			M
22			M
23			M
24			M
25			M
26			M
27			M
28			M
29			M
30			M
1	100000000101	BAUTISTA, Maria Clara L.	F
2	100000000102	SANTOS, Angelica Mae R.	F
3			F
4			F
5			F
6			F
7			F
8			F
9			F
10			F
11			F
12			F
13			F
14			F
15			F
16			F
17			F
18			F
19			F
20			F
21			F
22			F
23			F
24			F
25			F
26			F
27			F
28			F
29			F
30			F

Template — check against the current BIR/DepEd rules. Not tax/legal advice. © Layers (layers.md) · CC BY 4.0

ADJUSTED TRANSMUTATION TABLE — SY 2026–2027
Key Stages 2–4 and Grades 2–3. Initial grade (IG) of 70.00 = transmuted grade 75. Check against the annex of DepEd Order No. 15, s. 2026.

Initial grade from	to	Transmuted grade
0.00	4.67	60
4.68	9.34	61
9.35	14.00	62
14.01	18.67	63
18.68	23.34	64
23.35	28.00	65
28.01	32.67	66
32.68	37.33	67
37.34	42.00	68
42.01	46.66	69
46.67	51.33	70
51.34	56.00	71
56.01	60.66	72
60.67	65.33	73
65.34	69.99	74
70.00	71.17	75
71.18	72.35	76
72.36	73.53	77
73.54	74.71	78
74.72	75.89	79
75.90	77.07	80
77.08	78.25	81
78.26	79.43	82
79.44	80.61	83
80.62	81.79	84
81.80	82.97	85
82.98	84.15	86
84.16	85.33	87
85.34	86.51	88
86.52	87.69	89
87.70	88.87	90
88.88	90.05	91
90.06	91.23	92
91.24	92.41	93
92.42	93.59	94
93.60	94.77	95
94.78	95.95	96
95.96	97.13	97
97.14	98.31	98
98.32	99.49	99
99.50	100.00	100

Grade from	Descriptor	Filipino
0	Emerging	Nagsisimula
65	Developing	Napauunlad
75	Connecting	Natutungo
80	Benchmarking	Napamamalas
90	Advancing	Namumukod-tangi


Template — check against the current BIR/DepEd rules. Not tax/legal advice. © Layers (layers.md) · CC BY 4.0

FINAL GRADES — SCIENCE — Grade 7 — [SECTION]
Final grade = average of the three term grades, rounded to a whole number. Passing = 75.

No.	Learner’s name	Term 1	Term 2	Term 3	Final grade	Remarks	Descriptor
	MALE
1	DELA CRUZ, Juan Miguel P.	'Term 1'!AF8			IF(COUNT(C6:E6)<3,"",ROUND(AVERAGE(C6:E6),0))	IF(F6="","",IF(F6>=75,"Passed","Failed"))	IF(F6="","",VLOOKUP(F6,Transmutation!$A$48:$B$52,2,TRUE))
2	REYES, Paolo Andres S.	'Term 1'!AF9			IF(COUNT(C7:E7)<3,"",ROUND(AVERAGE(C7:E7),0))	IF(F7="","",IF(F7>=75,"Passed","Failed"))	IF(F7="","",VLOOKUP(F7,Transmutation!$A$48:$B$52,2,TRUE))
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
	FEMALE
1	BAUTISTA, Maria Clara L.	'Term 1'!AF39			IF(COUNT(C37:E37)<3,"",ROUND(AVERAGE(C37:E37),0))	IF(F37="","",IF(F37>=75,"Passed","Failed"))	IF(F37="","",VLOOKUP(F37,Transmutation!$A$48:$B$52,2,TRUE))
2	SANTOS, Angelica Mae R.	'Term 1'!AF40			IF(COUNT(C38:E38)<3,"",ROUND(AVERAGE(C38:E38),0))	IF(F38="","",IF(F38>=75,"Passed","Failed"))	IF(F38="","",VLOOKUP(F38,Transmutation!$A$48:$B$52,2,TRUE))
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30

Template — check against the current BIR/DepEd rules. Not tax/legal advice. © Layers (layers.md) · CC BY 4.0

TERM 1 — SCIENCE — GRADE 7 — [SECTION]
School: [SCHOOL NAME] ([000000]) Teacher: [TEACHER’S NAME] SY 2026–2027

LEARNERS			WRITTEN WORK (20%)											PERFORMANCE TASKS (50%)											EXAMINATIONS (30%)					TERM GRADE
No.	LRN	Learner’s name	1	2	3	4	5	6	7	8	Total	PS	WS	1	2	3	4	5	6	7	8	Total	PS	WS	ST 1	ST 2	Term exam	PS	WS	Initial grade	Term grade	Descriptor
		HIGHEST POSSIBLE SCORE	20	15	25	20	10				90	100	20	50	40	30						120	100	50	30	30	50	100	30
		MALE
1	100000000001	DELA CRUZ, Juan Miguel P.	18	12	20	17	9				76	IF(OR(L8="",N(L$6)=0),"",ROUND(L8/L$6*100,2))	IF(M8="","",ROUND(M8*Setup!$D$14,2))	44	33	25						102	IF(OR(W8="",N(W$6)=0),"",ROUND(W8/W$6*100,2))	IF(X8="","",ROUND(X8*Setup!$D$15,2))	24	26	41	IF(OR(COUNT(Z8:AB8)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z8)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA8)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB8)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC8="","",ROUND(AC8*Setup!$D$16,2))	IF(COUNT(D8:K8,O8:V8,Z8:AB8)=0,"",ROUND(N(N8)+N(Y8)+N(AD8),2))	IF(AE8="","",VLOOKUP(AE8,Transmutation!$A$5:$C$45,3,TRUE))	IF(AF8="","",VLOOKUP(AF8,Transmutation!$A$48:$B$52,2,TRUE))
2	100000000002	REYES, Paolo Andres S.	14	10	18	12	6				60	IF(OR(L9="",N(L$6)=0),"",ROUND(L9/L$6*100,2))	IF(M9="","",ROUND(M9*Setup!$D$14,2))	38	30	21						89	IF(OR(W9="",N(W$6)=0),"",ROUND(W9/W$6*100,2))	IF(X9="","",ROUND(X9*Setup!$D$15,2))	17	19	30	IF(OR(COUNT(Z9:AB9)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z9)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA9)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB9)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC9="","",ROUND(AC9*Setup!$D$16,2))	IF(COUNT(D9:K9,O9:V9,Z9:AB9)=0,"",ROUND(N(N9)+N(Y9)+N(AD9),2))	IF(AE9="","",VLOOKUP(AE9,Transmutation!$A$5:$C$45,3,TRUE))	IF(AF9="","",VLOOKUP(AF9,Transmutation!$A$48:$B$52,2,TRUE))
3												IF(OR(L10="",N(L$6)=0),"",ROUND(L10/L$6*100,2))	IF(M10="","",ROUND(M10*Setup!$D$14,2))										IF(OR(W10="",N(W$6)=0),"",ROUND(W10/W$6*100,2))	IF(X10="","",ROUND(X10*Setup!$D$15,2))				IF(OR(COUNT(Z10:AB10)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z10)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA10)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB10)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC10="","",ROUND(AC10*Setup!$D$16,2))
4												IF(OR(L11="",N(L$6)=0),"",ROUND(L11/L$6*100,2))	IF(M11="","",ROUND(M11*Setup!$D$14,2))										IF(OR(W11="",N(W$6)=0),"",ROUND(W11/W$6*100,2))	IF(X11="","",ROUND(X11*Setup!$D$15,2))				IF(OR(COUNT(Z11:AB11)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z11)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA11)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB11)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC11="","",ROUND(AC11*Setup!$D$16,2))
5												IF(OR(L12="",N(L$6)=0),"",ROUND(L12/L$6*100,2))	IF(M12="","",ROUND(M12*Setup!$D$14,2))										IF(OR(W12="",N(W$6)=0),"",ROUND(W12/W$6*100,2))	IF(X12="","",ROUND(X12*Setup!$D$15,2))				IF(OR(COUNT(Z12:AB12)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z12)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA12)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB12)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC12="","",ROUND(AC12*Setup!$D$16,2))
6												IF(OR(L13="",N(L$6)=0),"",ROUND(L13/L$6*100,2))	IF(M13="","",ROUND(M13*Setup!$D$14,2))										IF(OR(W13="",N(W$6)=0),"",ROUND(W13/W$6*100,2))	IF(X13="","",ROUND(X13*Setup!$D$15,2))				IF(OR(COUNT(Z13:AB13)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z13)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA13)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB13)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC13="","",ROUND(AC13*Setup!$D$16,2))
7												IF(OR(L14="",N(L$6)=0),"",ROUND(L14/L$6*100,2))	IF(M14="","",ROUND(M14*Setup!$D$14,2))										IF(OR(W14="",N(W$6)=0),"",ROUND(W14/W$6*100,2))	IF(X14="","",ROUND(X14*Setup!$D$15,2))				IF(OR(COUNT(Z14:AB14)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z14)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA14)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB14)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC14="","",ROUND(AC14*Setup!$D$16,2))
8												IF(OR(L15="",N(L$6)=0),"",ROUND(L15/L$6*100,2))	IF(M15="","",ROUND(M15*Setup!$D$14,2))										IF(OR(W15="",N(W$6)=0),"",ROUND(W15/W$6*100,2))	IF(X15="","",ROUND(X15*Setup!$D$15,2))				IF(OR(COUNT(Z15:AB15)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z15)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA15)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB15)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC15="","",ROUND(AC15*Setup!$D$16,2))
9												IF(OR(L16="",N(L$6)=0),"",ROUND(L16/L$6*100,2))	IF(M16="","",ROUND(M16*Setup!$D$14,2))										IF(OR(W16="",N(W$6)=0),"",ROUND(W16/W$6*100,2))	IF(X16="","",ROUND(X16*Setup!$D$15,2))				IF(OR(COUNT(Z16:AB16)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z16)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA16)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB16)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC16="","",ROUND(AC16*Setup!$D$16,2))
10												IF(OR(L17="",N(L$6)=0),"",ROUND(L17/L$6*100,2))	IF(M17="","",ROUND(M17*Setup!$D$14,2))										IF(OR(W17="",N(W$6)=0),"",ROUND(W17/W$6*100,2))	IF(X17="","",ROUND(X17*Setup!$D$15,2))				IF(OR(COUNT(Z17:AB17)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z17)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA17)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB17)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC17="","",ROUND(AC17*Setup!$D$16,2))
11												IF(OR(L18="",N(L$6)=0),"",ROUND(L18/L$6*100,2))	IF(M18="","",ROUND(M18*Setup!$D$14,2))										IF(OR(W18="",N(W$6)=0),"",ROUND(W18/W$6*100,2))	IF(X18="","",ROUND(X18*Setup!$D$15,2))				IF(OR(COUNT(Z18:AB18)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z18)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA18)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB18)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC18="","",ROUND(AC18*Setup!$D$16,2))
12												IF(OR(L19="",N(L$6)=0),"",ROUND(L19/L$6*100,2))	IF(M19="","",ROUND(M19*Setup!$D$14,2))										IF(OR(W19="",N(W$6)=0),"",ROUND(W19/W$6*100,2))	IF(X19="","",ROUND(X19*Setup!$D$15,2))				IF(OR(COUNT(Z19:AB19)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z19)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA19)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB19)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC19="","",ROUND(AC19*Setup!$D$16,2))
13												IF(OR(L20="",N(L$6)=0),"",ROUND(L20/L$6*100,2))	IF(M20="","",ROUND(M20*Setup!$D$14,2))										IF(OR(W20="",N(W$6)=0),"",ROUND(W20/W$6*100,2))	IF(X20="","",ROUND(X20*Setup!$D$15,2))				IF(OR(COUNT(Z20:AB20)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z20)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA20)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB20)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC20="","",ROUND(AC20*Setup!$D$16,2))
14												IF(OR(L21="",N(L$6)=0),"",ROUND(L21/L$6*100,2))	IF(M21="","",ROUND(M21*Setup!$D$14,2))										IF(OR(W21="",N(W$6)=0),"",ROUND(W21/W$6*100,2))	IF(X21="","",ROUND(X21*Setup!$D$15,2))				IF(OR(COUNT(Z21:AB21)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z21)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA21)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB21)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC21="","",ROUND(AC21*Setup!$D$16,2))
15												IF(OR(L22="",N(L$6)=0),"",ROUND(L22/L$6*100,2))	IF(M22="","",ROUND(M22*Setup!$D$14,2))										IF(OR(W22="",N(W$6)=0),"",ROUND(W22/W$6*100,2))	IF(X22="","",ROUND(X22*Setup!$D$15,2))				IF(OR(COUNT(Z22:AB22)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z22)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA22)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB22)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC22="","",ROUND(AC22*Setup!$D$16,2))
16												IF(OR(L23="",N(L$6)=0),"",ROUND(L23/L$6*100,2))	IF(M23="","",ROUND(M23*Setup!$D$14,2))										IF(OR(W23="",N(W$6)=0),"",ROUND(W23/W$6*100,2))	IF(X23="","",ROUND(X23*Setup!$D$15,2))				IF(OR(COUNT(Z23:AB23)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z23)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA23)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB23)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC23="","",ROUND(AC23*Setup!$D$16,2))
17												IF(OR(L24="",N(L$6)=0),"",ROUND(L24/L$6*100,2))	IF(M24="","",ROUND(M24*Setup!$D$14,2))										IF(OR(W24="",N(W$6)=0),"",ROUND(W24/W$6*100,2))	IF(X24="","",ROUND(X24*Setup!$D$15,2))				IF(OR(COUNT(Z24:AB24)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z24)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA24)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB24)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC24="","",ROUND(AC24*Setup!$D$16,2))
18												IF(OR(L25="",N(L$6)=0),"",ROUND(L25/L$6*100,2))	IF(M25="","",ROUND(M25*Setup!$D$14,2))										IF(OR(W25="",N(W$6)=0),"",ROUND(W25/W$6*100,2))	IF(X25="","",ROUND(X25*Setup!$D$15,2))				IF(OR(COUNT(Z25:AB25)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z25)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA25)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB25)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC25="","",ROUND(AC25*Setup!$D$16,2))
19												IF(OR(L26="",N(L$6)=0),"",ROUND(L26/L$6*100,2))	IF(M26="","",ROUND(M26*Setup!$D$14,2))										IF(OR(W26="",N(W$6)=0),"",ROUND(W26/W$6*100,2))	IF(X26="","",ROUND(X26*Setup!$D$15,2))				IF(OR(COUNT(Z26:AB26)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z26)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA26)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB26)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC26="","",ROUND(AC26*Setup!$D$16,2))
20												IF(OR(L27="",N(L$6)=0),"",ROUND(L27/L$6*100,2))	IF(M27="","",ROUND(M27*Setup!$D$14,2))										IF(OR(W27="",N(W$6)=0),"",ROUND(W27/W$6*100,2))	IF(X27="","",ROUND(X27*Setup!$D$15,2))				IF(OR(COUNT(Z27:AB27)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z27)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA27)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB27)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC27="","",ROUND(AC27*Setup!$D$16,2))
21												IF(OR(L28="",N(L$6)=0),"",ROUND(L28/L$6*100,2))	IF(M28="","",ROUND(M28*Setup!$D$14,2))										IF(OR(W28="",N(W$6)=0),"",ROUND(W28/W$6*100,2))	IF(X28="","",ROUND(X28*Setup!$D$15,2))				IF(OR(COUNT(Z28:AB28)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z28)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA28)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB28)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC28="","",ROUND(AC28*Setup!$D$16,2))
22												IF(OR(L29="",N(L$6)=0),"",ROUND(L29/L$6*100,2))	IF(M29="","",ROUND(M29*Setup!$D$14,2))										IF(OR(W29="",N(W$6)=0),"",ROUND(W29/W$6*100,2))	IF(X29="","",ROUND(X29*Setup!$D$15,2))				IF(OR(COUNT(Z29:AB29)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z29)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA29)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB29)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC29="","",ROUND(AC29*Setup!$D$16,2))
23												IF(OR(L30="",N(L$6)=0),"",ROUND(L30/L$6*100,2))	IF(M30="","",ROUND(M30*Setup!$D$14,2))										IF(OR(W30="",N(W$6)=0),"",ROUND(W30/W$6*100,2))	IF(X30="","",ROUND(X30*Setup!$D$15,2))				IF(OR(COUNT(Z30:AB30)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z30)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA30)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB30)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC30="","",ROUND(AC30*Setup!$D$16,2))
24												IF(OR(L31="",N(L$6)=0),"",ROUND(L31/L$6*100,2))	IF(M31="","",ROUND(M31*Setup!$D$14,2))										IF(OR(W31="",N(W$6)=0),"",ROUND(W31/W$6*100,2))	IF(X31="","",ROUND(X31*Setup!$D$15,2))				IF(OR(COUNT(Z31:AB31)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z31)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA31)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB31)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC31="","",ROUND(AC31*Setup!$D$16,2))
25												IF(OR(L32="",N(L$6)=0),"",ROUND(L32/L$6*100,2))	IF(M32="","",ROUND(M32*Setup!$D$14,2))										IF(OR(W32="",N(W$6)=0),"",ROUND(W32/W$6*100,2))	IF(X32="","",ROUND(X32*Setup!$D$15,2))				IF(OR(COUNT(Z32:AB32)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z32)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA32)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB32)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC32="","",ROUND(AC32*Setup!$D$16,2))
26												IF(OR(L33="",N(L$6)=0),"",ROUND(L33/L$6*100,2))	IF(M33="","",ROUND(M33*Setup!$D$14,2))										IF(OR(W33="",N(W$6)=0),"",ROUND(W33/W$6*100,2))	IF(X33="","",ROUND(X33*Setup!$D$15,2))				IF(OR(COUNT(Z33:AB33)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z33)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA33)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB33)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC33="","",ROUND(AC33*Setup!$D$16,2))
27												IF(OR(L34="",N(L$6)=0),"",ROUND(L34/L$6*100,2))	IF(M34="","",ROUND(M34*Setup!$D$14,2))										IF(OR(W34="",N(W$6)=0),"",ROUND(W34/W$6*100,2))	IF(X34="","",ROUND(X34*Setup!$D$15,2))				IF(OR(COUNT(Z34:AB34)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z34)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA34)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB34)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC34="","",ROUND(AC34*Setup!$D$16,2))
28												IF(OR(L35="",N(L$6)=0),"",ROUND(L35/L$6*100,2))	IF(M35="","",ROUND(M35*Setup!$D$14,2))										IF(OR(W35="",N(W$6)=0),"",ROUND(W35/W$6*100,2))	IF(X35="","",ROUND(X35*Setup!$D$15,2))				IF(OR(COUNT(Z35:AB35)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z35)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA35)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB35)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC35="","",ROUND(AC35*Setup!$D$16,2))
29												IF(OR(L36="",N(L$6)=0),"",ROUND(L36/L$6*100,2))	IF(M36="","",ROUND(M36*Setup!$D$14,2))										IF(OR(W36="",N(W$6)=0),"",ROUND(W36/W$6*100,2))	IF(X36="","",ROUND(X36*Setup!$D$15,2))				IF(OR(COUNT(Z36:AB36)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z36)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA36)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB36)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC36="","",ROUND(AC36*Setup!$D$16,2))
30												IF(OR(L37="",N(L$6)=0),"",ROUND(L37/L$6*100,2))	IF(M37="","",ROUND(M37*Setup!$D$14,2))										IF(OR(W37="",N(W$6)=0),"",ROUND(W37/W$6*100,2))	IF(X37="","",ROUND(X37*Setup!$D$15,2))				IF(OR(COUNT(Z37:AB37)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z37)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA37)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB37)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC37="","",ROUND(AC37*Setup!$D$16,2))
		FEMALE
1	100000000101	BAUTISTA, Maria Clara L.	19	14	23	19	10				85	IF(OR(L39="",N(L$6)=0),"",ROUND(L39/L$6*100,2))	IF(M39="","",ROUND(M39*Setup!$D$14,2))	47	38	28						113	IF(OR(W39="",N(W$6)=0),"",ROUND(W39/W$6*100,2))	IF(X39="","",ROUND(X39*Setup!$D$15,2))	27	28	46	IF(OR(COUNT(Z39:AB39)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z39)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA39)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB39)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC39="","",ROUND(AC39*Setup!$D$16,2))	IF(COUNT(D39:K39,O39:V39,Z39:AB39)=0,"",ROUND(N(N39)+N(Y39)+N(AD39),2))	IF(AE39="","",VLOOKUP(AE39,Transmutation!$A$5:$C$45,3,TRUE))	IF(AF39="","",VLOOKUP(AF39,Transmutation!$A$48:$B$52,2,TRUE))
2	100000000102	SANTOS, Angelica Mae R.	12	9	15	11	5				52	IF(OR(L40="",N(L$6)=0),"",ROUND(L40/L$6*100,2))	IF(M40="","",ROUND(M40*Setup!$D$14,2))	35	26	20						81	IF(OR(W40="",N(W$6)=0),"",ROUND(W40/W$6*100,2))	IF(X40="","",ROUND(X40*Setup!$D$15,2))	15	14	27	IF(OR(COUNT(Z40:AB40)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z40)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA40)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB40)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC40="","",ROUND(AC40*Setup!$D$16,2))	IF(COUNT(D40:K40,O40:V40,Z40:AB40)=0,"",ROUND(N(N40)+N(Y40)+N(AD40),2))	IF(AE40="","",VLOOKUP(AE40,Transmutation!$A$5:$C$45,3,TRUE))	IF(AF40="","",VLOOKUP(AF40,Transmutation!$A$48:$B$52,2,TRUE))
3												IF(OR(L41="",N(L$6)=0),"",ROUND(L41/L$6*100,2))	IF(M41="","",ROUND(M41*Setup!$D$14,2))										IF(OR(W41="",N(W$6)=0),"",ROUND(W41/W$6*100,2))	IF(X41="","",ROUND(X41*Setup!$D$15,2))				IF(OR(COUNT(Z41:AB41)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z41)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA41)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB41)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC41="","",ROUND(AC41*Setup!$D$16,2))
4												IF(OR(L42="",N(L$6)=0),"",ROUND(L42/L$6*100,2))	IF(M42="","",ROUND(M42*Setup!$D$14,2))										IF(OR(W42="",N(W$6)=0),"",ROUND(W42/W$6*100,2))	IF(X42="","",ROUND(X42*Setup!$D$15,2))				IF(OR(COUNT(Z42:AB42)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z42)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA42)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB42)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC42="","",ROUND(AC42*Setup!$D$16,2))
5												IF(OR(L43="",N(L$6)=0),"",ROUND(L43/L$6*100,2))	IF(M43="","",ROUND(M43*Setup!$D$14,2))										IF(OR(W43="",N(W$6)=0),"",ROUND(W43/W$6*100,2))	IF(X43="","",ROUND(X43*Setup!$D$15,2))				IF(OR(COUNT(Z43:AB43)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z43)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA43)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB43)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC43="","",ROUND(AC43*Setup!$D$16,2))
6												IF(OR(L44="",N(L$6)=0),"",ROUND(L44/L$6*100,2))	IF(M44="","",ROUND(M44*Setup!$D$14,2))										IF(OR(W44="",N(W$6)=0),"",ROUND(W44/W$6*100,2))	IF(X44="","",ROUND(X44*Setup!$D$15,2))				IF(OR(COUNT(Z44:AB44)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z44)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA44)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB44)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC44="","",ROUND(AC44*Setup!$D$16,2))
7												IF(OR(L45="",N(L$6)=0),"",ROUND(L45/L$6*100,2))	IF(M45="","",ROUND(M45*Setup!$D$14,2))										IF(OR(W45="",N(W$6)=0),"",ROUND(W45/W$6*100,2))	IF(X45="","",ROUND(X45*Setup!$D$15,2))				IF(OR(COUNT(Z45:AB45)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z45)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA45)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB45)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC45="","",ROUND(AC45*Setup!$D$16,2))
8												IF(OR(L46="",N(L$6)=0),"",ROUND(L46/L$6*100,2))	IF(M46="","",ROUND(M46*Setup!$D$14,2))										IF(OR(W46="",N(W$6)=0),"",ROUND(W46/W$6*100,2))	IF(X46="","",ROUND(X46*Setup!$D$15,2))				IF(OR(COUNT(Z46:AB46)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z46)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA46)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB46)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC46="","",ROUND(AC46*Setup!$D$16,2))
9												IF(OR(L47="",N(L$6)=0),"",ROUND(L47/L$6*100,2))	IF(M47="","",ROUND(M47*Setup!$D$14,2))										IF(OR(W47="",N(W$6)=0),"",ROUND(W47/W$6*100,2))	IF(X47="","",ROUND(X47*Setup!$D$15,2))				IF(OR(COUNT(Z47:AB47)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z47)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA47)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB47)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC47="","",ROUND(AC47*Setup!$D$16,2))
10												IF(OR(L48="",N(L$6)=0),"",ROUND(L48/L$6*100,2))	IF(M48="","",ROUND(M48*Setup!$D$14,2))										IF(OR(W48="",N(W$6)=0),"",ROUND(W48/W$6*100,2))	IF(X48="","",ROUND(X48*Setup!$D$15,2))				IF(OR(COUNT(Z48:AB48)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z48)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA48)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB48)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC48="","",ROUND(AC48*Setup!$D$16,2))
11												IF(OR(L49="",N(L$6)=0),"",ROUND(L49/L$6*100,2))	IF(M49="","",ROUND(M49*Setup!$D$14,2))										IF(OR(W49="",N(W$6)=0),"",ROUND(W49/W$6*100,2))	IF(X49="","",ROUND(X49*Setup!$D$15,2))				IF(OR(COUNT(Z49:AB49)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z49)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA49)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB49)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC49="","",ROUND(AC49*Setup!$D$16,2))
12												IF(OR(L50="",N(L$6)=0),"",ROUND(L50/L$6*100,2))	IF(M50="","",ROUND(M50*Setup!$D$14,2))										IF(OR(W50="",N(W$6)=0),"",ROUND(W50/W$6*100,2))	IF(X50="","",ROUND(X50*Setup!$D$15,2))				IF(OR(COUNT(Z50:AB50)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z50)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA50)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB50)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC50="","",ROUND(AC50*Setup!$D$16,2))
13												IF(OR(L51="",N(L$6)=0),"",ROUND(L51/L$6*100,2))	IF(M51="","",ROUND(M51*Setup!$D$14,2))										IF(OR(W51="",N(W$6)=0),"",ROUND(W51/W$6*100,2))	IF(X51="","",ROUND(X51*Setup!$D$15,2))				IF(OR(COUNT(Z51:AB51)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z51)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA51)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB51)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC51="","",ROUND(AC51*Setup!$D$16,2))
14												IF(OR(L52="",N(L$6)=0),"",ROUND(L52/L$6*100,2))	IF(M52="","",ROUND(M52*Setup!$D$14,2))										IF(OR(W52="",N(W$6)=0),"",ROUND(W52/W$6*100,2))	IF(X52="","",ROUND(X52*Setup!$D$15,2))				IF(OR(COUNT(Z52:AB52)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z52)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA52)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB52)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC52="","",ROUND(AC52*Setup!$D$16,2))
15												IF(OR(L53="",N(L$6)=0),"",ROUND(L53/L$6*100,2))	IF(M53="","",ROUND(M53*Setup!$D$14,2))										IF(OR(W53="",N(W$6)=0),"",ROUND(W53/W$6*100,2))	IF(X53="","",ROUND(X53*Setup!$D$15,2))				IF(OR(COUNT(Z53:AB53)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z53)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA53)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB53)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC53="","",ROUND(AC53*Setup!$D$16,2))
16												IF(OR(L54="",N(L$6)=0),"",ROUND(L54/L$6*100,2))	IF(M54="","",ROUND(M54*Setup!$D$14,2))										IF(OR(W54="",N(W$6)=0),"",ROUND(W54/W$6*100,2))	IF(X54="","",ROUND(X54*Setup!$D$15,2))				IF(OR(COUNT(Z54:AB54)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z54)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA54)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB54)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC54="","",ROUND(AC54*Setup!$D$16,2))
17												IF(OR(L55="",N(L$6)=0),"",ROUND(L55/L$6*100,2))	IF(M55="","",ROUND(M55*Setup!$D$14,2))										IF(OR(W55="",N(W$6)=0),"",ROUND(W55/W$6*100,2))	IF(X55="","",ROUND(X55*Setup!$D$15,2))				IF(OR(COUNT(Z55:AB55)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z55)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA55)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB55)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC55="","",ROUND(AC55*Setup!$D$16,2))
18												IF(OR(L56="",N(L$6)=0),"",ROUND(L56/L$6*100,2))	IF(M56="","",ROUND(M56*Setup!$D$14,2))										IF(OR(W56="",N(W$6)=0),"",ROUND(W56/W$6*100,2))	IF(X56="","",ROUND(X56*Setup!$D$15,2))				IF(OR(COUNT(Z56:AB56)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z56)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA56)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB56)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC56="","",ROUND(AC56*Setup!$D$16,2))
19												IF(OR(L57="",N(L$6)=0),"",ROUND(L57/L$6*100,2))	IF(M57="","",ROUND(M57*Setup!$D$14,2))										IF(OR(W57="",N(W$6)=0),"",ROUND(W57/W$6*100,2))	IF(X57="","",ROUND(X57*Setup!$D$15,2))				IF(OR(COUNT(Z57:AB57)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z57)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA57)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB57)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC57="","",ROUND(AC57*Setup!$D$16,2))
20												IF(OR(L58="",N(L$6)=0),"",ROUND(L58/L$6*100,2))	IF(M58="","",ROUND(M58*Setup!$D$14,2))										IF(OR(W58="",N(W$6)=0),"",ROUND(W58/W$6*100,2))	IF(X58="","",ROUND(X58*Setup!$D$15,2))				IF(OR(COUNT(Z58:AB58)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z58)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA58)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB58)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC58="","",ROUND(AC58*Setup!$D$16,2))
21												IF(OR(L59="",N(L$6)=0),"",ROUND(L59/L$6*100,2))	IF(M59="","",ROUND(M59*Setup!$D$14,2))										IF(OR(W59="",N(W$6)=0),"",ROUND(W59/W$6*100,2))	IF(X59="","",ROUND(X59*Setup!$D$15,2))				IF(OR(COUNT(Z59:AB59)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z59)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA59)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB59)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC59="","",ROUND(AC59*Setup!$D$16,2))
22												IF(OR(L60="",N(L$6)=0),"",ROUND(L60/L$6*100,2))	IF(M60="","",ROUND(M60*Setup!$D$14,2))										IF(OR(W60="",N(W$6)=0),"",ROUND(W60/W$6*100,2))	IF(X60="","",ROUND(X60*Setup!$D$15,2))				IF(OR(COUNT(Z60:AB60)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z60)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA60)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB60)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC60="","",ROUND(AC60*Setup!$D$16,2))
23												IF(OR(L61="",N(L$6)=0),"",ROUND(L61/L$6*100,2))	IF(M61="","",ROUND(M61*Setup!$D$14,2))										IF(OR(W61="",N(W$6)=0),"",ROUND(W61/W$6*100,2))	IF(X61="","",ROUND(X61*Setup!$D$15,2))				IF(OR(COUNT(Z61:AB61)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z61)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA61)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB61)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC61="","",ROUND(AC61*Setup!$D$16,2))
24												IF(OR(L62="",N(L$6)=0),"",ROUND(L62/L$6*100,2))	IF(M62="","",ROUND(M62*Setup!$D$14,2))										IF(OR(W62="",N(W$6)=0),"",ROUND(W62/W$6*100,2))	IF(X62="","",ROUND(X62*Setup!$D$15,2))				IF(OR(COUNT(Z62:AB62)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z62)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA62)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB62)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC62="","",ROUND(AC62*Setup!$D$16,2))
25												IF(OR(L63="",N(L$6)=0),"",ROUND(L63/L$6*100,2))	IF(M63="","",ROUND(M63*Setup!$D$14,2))										IF(OR(W63="",N(W$6)=0),"",ROUND(W63/W$6*100,2))	IF(X63="","",ROUND(X63*Setup!$D$15,2))				IF(OR(COUNT(Z63:AB63)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z63)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA63)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB63)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC63="","",ROUND(AC63*Setup!$D$16,2))
26												IF(OR(L64="",N(L$6)=0),"",ROUND(L64/L$6*100,2))	IF(M64="","",ROUND(M64*Setup!$D$14,2))										IF(OR(W64="",N(W$6)=0),"",ROUND(W64/W$6*100,2))	IF(X64="","",ROUND(X64*Setup!$D$15,2))				IF(OR(COUNT(Z64:AB64)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z64)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA64)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB64)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC64="","",ROUND(AC64*Setup!$D$16,2))
27												IF(OR(L65="",N(L$6)=0),"",ROUND(L65/L$6*100,2))	IF(M65="","",ROUND(M65*Setup!$D$14,2))										IF(OR(W65="",N(W$6)=0),"",ROUND(W65/W$6*100,2))	IF(X65="","",ROUND(X65*Setup!$D$15,2))				IF(OR(COUNT(Z65:AB65)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z65)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA65)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB65)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC65="","",ROUND(AC65*Setup!$D$16,2))
28												IF(OR(L66="",N(L$6)=0),"",ROUND(L66/L$6*100,2))	IF(M66="","",ROUND(M66*Setup!$D$14,2))										IF(OR(W66="",N(W$6)=0),"",ROUND(W66/W$6*100,2))	IF(X66="","",ROUND(X66*Setup!$D$15,2))				IF(OR(COUNT(Z66:AB66)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z66)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA66)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB66)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC66="","",ROUND(AC66*Setup!$D$16,2))
29												IF(OR(L67="",N(L$6)=0),"",ROUND(L67/L$6*100,2))	IF(M67="","",ROUND(M67*Setup!$D$14,2))										IF(OR(W67="",N(W$6)=0),"",ROUND(W67/W$6*100,2))	IF(X67="","",ROUND(X67*Setup!$D$15,2))				IF(OR(COUNT(Z67:AB67)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z67)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA67)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB67)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC67="","",ROUND(AC67*Setup!$D$16,2))
30												IF(OR(L68="",N(L$6)=0),"",ROUND(L68/L$6*100,2))	IF(M68="","",ROUND(M68*Setup!$D$14,2))										IF(OR(W68="",N(W$6)=0),"",ROUND(W68/W$6*100,2))	IF(X68="","",ROUND(X68*Setup!$D$15,2))				IF(OR(COUNT(Z68:AB68)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z68)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA68)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB68)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC68="","",ROUND(AC68*Setup!$D$16,2))

Template — check against the current BIR/DepEd rules. Not tax/legal advice. © Layers (layers.md) · CC BY 4.0

TERM 2 — SCIENCE — GRADE 7 — [SECTION]
School: [SCHOOL NAME] ([000000]) Teacher: [TEACHER’S NAME] SY 2026–2027

LEARNERS			WRITTEN WORK (20%)											PERFORMANCE TASKS (50%)											EXAMINATIONS (30%)					TERM GRADE
No.	LRN	Learner’s name	1	2	3	4	5	6	7	8	Total	PS	WS	1	2	3	4	5	6	7	8	Total	PS	WS	ST 1	ST 2	Term exam	PS	WS	Initial grade	Term grade	Descriptor
		HIGHEST POSSIBLE SCORE									0	100	20									0	100	50				100	30
		MALE
1	100000000001	DELA CRUZ, Juan Miguel P.										IF(OR(L8="",N(L$6)=0),"",ROUND(L8/L$6*100,2))	IF(M8="","",ROUND(M8*Setup!$D$14,2))										IF(OR(W8="",N(W$6)=0),"",ROUND(W8/W$6*100,2))	IF(X8="","",ROUND(X8*Setup!$D$15,2))				IF(OR(COUNT(Z8:AB8)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z8)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA8)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB8)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC8="","",ROUND(AC8*Setup!$D$16,2))
2	100000000002	REYES, Paolo Andres S.										IF(OR(L9="",N(L$6)=0),"",ROUND(L9/L$6*100,2))	IF(M9="","",ROUND(M9*Setup!$D$14,2))										IF(OR(W9="",N(W$6)=0),"",ROUND(W9/W$6*100,2))	IF(X9="","",ROUND(X9*Setup!$D$15,2))				IF(OR(COUNT(Z9:AB9)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z9)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA9)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB9)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC9="","",ROUND(AC9*Setup!$D$16,2))
3												IF(OR(L10="",N(L$6)=0),"",ROUND(L10/L$6*100,2))	IF(M10="","",ROUND(M10*Setup!$D$14,2))										IF(OR(W10="",N(W$6)=0),"",ROUND(W10/W$6*100,2))	IF(X10="","",ROUND(X10*Setup!$D$15,2))				IF(OR(COUNT(Z10:AB10)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z10)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA10)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB10)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC10="","",ROUND(AC10*Setup!$D$16,2))
4												IF(OR(L11="",N(L$6)=0),"",ROUND(L11/L$6*100,2))	IF(M11="","",ROUND(M11*Setup!$D$14,2))										IF(OR(W11="",N(W$6)=0),"",ROUND(W11/W$6*100,2))	IF(X11="","",ROUND(X11*Setup!$D$15,2))				IF(OR(COUNT(Z11:AB11)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z11)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA11)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB11)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC11="","",ROUND(AC11*Setup!$D$16,2))
5												IF(OR(L12="",N(L$6)=0),"",ROUND(L12/L$6*100,2))	IF(M12="","",ROUND(M12*Setup!$D$14,2))										IF(OR(W12="",N(W$6)=0),"",ROUND(W12/W$6*100,2))	IF(X12="","",ROUND(X12*Setup!$D$15,2))				IF(OR(COUNT(Z12:AB12)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z12)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA12)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB12)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC12="","",ROUND(AC12*Setup!$D$16,2))
6												IF(OR(L13="",N(L$6)=0),"",ROUND(L13/L$6*100,2))	IF(M13="","",ROUND(M13*Setup!$D$14,2))										IF(OR(W13="",N(W$6)=0),"",ROUND(W13/W$6*100,2))	IF(X13="","",ROUND(X13*Setup!$D$15,2))				IF(OR(COUNT(Z13:AB13)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z13)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA13)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB13)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC13="","",ROUND(AC13*Setup!$D$16,2))
7												IF(OR(L14="",N(L$6)=0),"",ROUND(L14/L$6*100,2))	IF(M14="","",ROUND(M14*Setup!$D$14,2))										IF(OR(W14="",N(W$6)=0),"",ROUND(W14/W$6*100,2))	IF(X14="","",ROUND(X14*Setup!$D$15,2))				IF(OR(COUNT(Z14:AB14)=0,(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))=0),"",ROUND((IF(N(Z$6)>0,N(Z14)/Z$6Setup!$D$20,0)+IF(N(AA$6)>0,N(AA14)/AA$6Setup!$D$21,0)+IF(N(AB$6)>0,N(AB14)/AB$6Setup!$D$22,0))/(IF(N(Z$6)>0,Setup!$D$20,0)+IF(N(AA$6)>0,Setup!$D$21,0)+IF(N(AB$6)>0,Setup!$D$22,0))100,2))	IF(AC14="","",ROUND(AC14*Setup!$D$16,2))
…