How to calculate my MBA results?

[Skeptical]

Hi everybody at MrExcel,

We are from a university. We have SIX specializations,

Specializations------Codes

Finance ----- F,
Marketing ----M,
HR ----H,
Finance with Marketing ----FM
Finance with HR----FH
HR with Marketing------HM

We have six subjects in each combination i.e.

Combination---Subjects

F--------F1,F2,F3,F4,F5,F6
H------------H1,H2,H3,H4,H5,H6
M------M1,M2,M3,M4,M5,M6
FM----------F1,F2,F3,M1,M2,M3
HM----------H1,H2,H3,M1,M2,M3
FH------------F1,F2,F3,H1,H2,H3

Total marks 150*6 subjects=900

Result Conditions:
Awarding of Class: <tbody> [TD="colspan: 6"]

<tbody>
[TD="colspan: 4"]In each subject, student should score>=75 marks in Total for a Pass [/TD]

[TD="colspan: 3"]The marks in External should be >= 40 marks[/TD]

[TD="colspan: 3"]The marks in Internal should be >= 25 marks[/TD]

[TD="colspan: 6"]50% - 60% is Second Class[/TD]

[TD="colspan: 5"]60% - 70% is First class[/TD]

[TD="colspan: 10"]>= 70% is FCD (First Class with Distinction)[/TD]

</tbody>

[/TD]

</tbody>

I have Results column and Class column, What formula should be used there to get my results calculated?
I have tried with so many IFs but that is so inefficient, I request humbly everybody please help me on this.

I have attached a sample workbook here .

Thank you very much
Skeptical

 

[Smitty]

Take a look at the HTML Maker link in my sig. It will let you post screen shots so everyone has a better idea of what you're after. External links are fine, but you greatly limit your exposure since many members can't/won't download files from untrusted sources.

 

[Smitty]

FYI - Please don't post the same question multiple times. It just causes everyone to do extra work on your behalf. I have deleted your duplicate threads.

 

[Peter_SSs]

Smitty

This thread & all the posts in it are in the 'Moderated' queues so the OP probably posted again because this one didn't show up to him.
I've left it all as Moderated till you have seen this then you can remove it.

 

[Joe4]

FYI - Please don't post the same question multiple times. It just causes everyone to do extra work on your behalf. I have deleted your duplicate threads.

This thread & all the posts in it are in the 'Moderated' queues so the OP probably posted again because this one didn't show up to him.
I've left it all as Moderated till you have seen this then you can remove it.

I have approved all of them. I am guessing that they re-posted the question because they didn't see it because it was Moderated (though they should have been notified when submitting it that it was being Moderated and awaiting approval).

 

[Smitty]

Thanks Peter

 

[Skeptical]

Hi Smitty,

Apologies..My intention is not posting multiple times, but I didn't see it posted and I tried to post it multiple times. At first, I thought they changed the posting functionality.

About posting the screen-shot, It is too big to post as I have 58 columns. I don't know how to accommodate so many columns here. Even from the windows snipping tool we cannot see the entire screen to cut it.

And the reason for the delayed reply is I thought it was not at all posted and I am trying to post it today. Later I have seen the MrExcel post link surprisingly.

I don't see any better idea that this. Please let me know if you still need the screenshot. Thank you so much.
Skeptical

 

[Peter_SSs]

About posting the screen-shot, It is too big to post as I have 58 columns.

Could you make up a smaller dummy file with, say, 15 columns that can still demonstrate the issue you have?

Alternatively, with the HTML maker Smitty mentioned, or others in Section B of the Forum Use Guidelines, you may be able to hide a lot of the columns if they are not vital to demonstrating your issue, then the screen shot won't be as wide.

 

[Skeptical]

Hi Peter,

Here is the Screenshot. I have presented the marks for Finance and Marketing specializations. But we have columns for HR as well. In the Col BE I need the result whether Pass or Fail. Downloading the Google drive link will pretty much make you understand easily. I couldn't insert the image as well as I can't see the same after insertion. That's why I have given a link for the same(Screenshot).

https://drive.google.com/open?id=0B-uTVzgsjvZRaXZFc0FXdF94WEU

Hint: Those guys who opted for MH, will study half of the Marketing and HR subjects, obviously.

Please ask me if you need anything.
Skeptical

 

[Skeptical]

Here is the actual sample. I did some quick learning on HTML maker which makes the reader's life easier. Thanks for making me understand about how to use this. Thank all.

Excel 2012

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI
Stud-1	MF
Stud-2	MH
Stud-3	F
Stud-4	MH
Stud-5	MF
Stud-6	MF
Stud-7	MF
Stud-8	MF
Stud-9	H
Stud-10	M
Stud-11	FH
Stud-12	M
Stud-13	M

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="bgcolor: #F2F2F2"]Student[/TD]
[TD="bgcolor: #F2F2F2"]Branch[/TD]
[TD="bgcolor: #FFE699, align: center"]F1[/TD]
[TD="bgcolor: #FFE699, align: center"]F1[/TD]
[TD="bgcolor: #FFE699, align: center"]F1[/TD]
[TD="bgcolor: #FFE699, align: center"]F2[/TD]
[TD="bgcolor: #FFE699, align: center"]F2[/TD]
[TD="bgcolor: #FFE699, align: center"]F2[/TD]
[TD="bgcolor: #FFE699, align: center"]F3[/TD]
[TD="bgcolor: #FFE699, align: center"]F3[/TD]
[TD="bgcolor: #FFE699, align: center"]F3[/TD]
[TD="bgcolor: #FFE699, align: center"]F4[/TD]
[TD="bgcolor: #FFE699, align: center"]F4[/TD]
[TD="bgcolor: #FFE699, align: center"]F4[/TD]
[TD="bgcolor: #FFE699, align: center"]F5[/TD]
[TD="bgcolor: #FFE699, align: center"]F5[/TD]
[TD="bgcolor: #FFE699, align: center"]F5[/TD]
[TD="bgcolor: #FFE699, align: center"]F6[/TD]
[TD="bgcolor: #FFE699, align: center"]F6[/TD]
[TD="bgcolor: #FFE699, align: center"]F6[/TD]
[TD="bgcolor: #F8CBAD, align: center"]M1[/TD]
[TD="bgcolor: #F8CBAD, align: center"]M1[/TD]
[TD="bgcolor: #F8CBAD, align: center"]M1[/TD]
[TD="bgcolor: #F8CBAD, align: center"]M2[/TD]
[TD="bgcolor: #F8CBAD, align: center"]M2[/TD]
[TD="bgcolor: #F8CBAD, align: center"]M2[/TD]
[TD="bgcolor: #F8CBAD, align: center"]M3[/TD]
[TD="bgcolor: #F8CBAD, align: center"]M3[/TD]
[TD="bgcolor: #F8CBAD, align: center"]M3[/TD]
[TD="bgcolor: #F8CBAD, align: center"]M4[/TD]
[TD="bgcolor: #F8CBAD, align: center"]M4[/TD]
[TD="bgcolor: #F8CBAD, align: center"]M4[/TD]
[TD="bgcolor: #F8CBAD, align: center"]M5[/TD]
[TD="bgcolor: #F8CBAD, align: center"]M5[/TD]
[TD="bgcolor: #F8CBAD, align: center"]M5[/TD]

[TD="align: center"]2[/TD]
[TD="bgcolor: #F2F2F2, align: right"][/TD]
[TD="bgcolor: #F2F2F2, align: right"][/TD]
[TD="bgcolor: #FFE699, align: center"]Int[/TD]
[TD="bgcolor: #FFE699, align: center"]Ext[/TD]
[TD="bgcolor: #FFE699, align: center"]Total[/TD]
[TD="bgcolor: #FFE699, align: center"]Int[/TD]
[TD="bgcolor: #FFE699, align: center"]Ext[/TD]
[TD="bgcolor: #FFE699, align: center"]Total[/TD]
[TD="bgcolor: #FFE699, align: center"]Int[/TD]
[TD="bgcolor: #FFE699, align: center"]Ext[/TD]
[TD="bgcolor: #FFE699, align: center"]Total[/TD]
[TD="bgcolor: #FFE699, align: center"]Int[/TD]
[TD="bgcolor: #FFE699, align: center"]Ext[/TD]
[TD="bgcolor: #FFE699, align: center"]Total[/TD]
[TD="bgcolor: #FFE699, align: center"]Int[/TD]
[TD="bgcolor: #FFE699, align: center"]Ext[/TD]
[TD="bgcolor: #FFE699, align: center"]Total[/TD]
[TD="bgcolor: #FFE699, align: center"]Int[/TD]
[TD="bgcolor: #FFE699, align: center"]Ext[/TD]
[TD="bgcolor: #FFE699, align: center"]Total[/TD]
[TD="bgcolor: #F8CBAD, align: center"]Int[/TD]
[TD="bgcolor: #F8CBAD, align: center"]Ext[/TD]
[TD="bgcolor: #F8CBAD, align: center"]Total[/TD]
[TD="bgcolor: #F8CBAD, align: center"]Int[/TD]
[TD="bgcolor: #F8CBAD, align: center"]Ext[/TD]
[TD="bgcolor: #F8CBAD, align: center"]Total[/TD]
[TD="bgcolor: #F8CBAD, align: center"]Int[/TD]
[TD="bgcolor: #F8CBAD, align: center"]Ext[/TD]
[TD="bgcolor: #F8CBAD, align: center"]Total[/TD]
[TD="bgcolor: #F8CBAD, align: center"]Int[/TD]
[TD="bgcolor: #F8CBAD, align: center"]Ext[/TD]
[TD="bgcolor: #F8CBAD, align: center"]Total[/TD]
[TD="bgcolor: #F8CBAD, align: center"]Int[/TD]
[TD="bgcolor: #F8CBAD, align: center"]Ext[/TD]
[TD="bgcolor: #F8CBAD, align: center"]Total[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"]41[/TD]
[TD="align: right"]61[/TD]
[TD="align: right"]102[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]70[/TD]
[TD="align: right"]38[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"]99[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]41[/TD]
[TD="align: right"]57[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]44[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]4[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]59[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]36[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]70[/TD]
[TD="align: right"]52[/TD]
[TD="align: right"]122[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]5[/TD]

[TD="align: right"]74[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]107[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]68[/TD]
[TD="align: right"]113[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]64[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]64[/TD]
[TD="align: right"]107[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]91[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]57[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]6[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]41[/TD]
[TD="align: right"]59[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]79[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]7[/TD]

[TD="align: right"]75[/TD]
[TD="align: right"]74[/TD]
[TD="align: right"]149[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]110[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]62[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]57[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]69[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]106[/TD]
[TD="align: right"]68[/TD]
[TD="align: right"]73[/TD]
[TD="align: right"]141[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]8[/TD]

[TD="align: right"]15[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]131[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]49[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]42[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]70[/TD]
[TD="align: right"]58[/TD]
[TD="align: right"]128[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]70[/TD]
[TD="align: right"]99[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]9[/TD]

[TD="align: right"]73[/TD]
[TD="align: right"]69[/TD]
[TD="align: right"]142[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]63[/TD]
[TD="align: right"]118[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]36[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]58[/TD]
[TD="align: right"]58[/TD]
[TD="align: right"]116[/TD]
[TD="align: right"]47[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]10[/TD]

[TD="align: right"]37[/TD]
[TD="align: right"]44[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]63[/TD]
[TD="align: right"]98[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]68[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]57[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]69[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]106[/TD]
[TD="align: right"]68[/TD]
[TD="align: right"]73[/TD]
[TD="align: right"]141[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]11[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]12[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]73[/TD]
[TD="align: right"]110[/TD]
[TD="align: right"]57[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]71[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]74[/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]60[/TD]
[TD="align: right"]63[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]84[/TD]

[TD="align: center"]13[/TD]

[TD="align: right"]42[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]119[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]63[/TD]
[TD="align: right"]94[/TD]
[TD="align: right"]48[/TD]
[TD="align: right"]52[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]14[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]66[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]73[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]66[/TD]
[TD="align: right"]47[/TD]
[TD="align: right"]113[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]47[/TD]
[TD="align: right"]73[/TD]

[TD="align: center"]15[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]41[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]95[/TD]
[TD="align: right"]41[/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]87[/TD]

</tbody>

Sheet1​