ankit bidawatka
New Member
i want to make a marksheet file on excel where following are the criterion to get pass:-
1) There are two group comprising four paper in each group.A candidate may appear in both the groups simultaneously or in one group in one examination and the remaining group at any subsequent examination and shall ordinarily be declared to have passed the Final Examination if he passes in both the groups
(2) A candidate shall ordinarily be declared to have passed the Final Examination in both the groups simultaneously, if he-
(a) secures at one sitting a minimum of 40 percent marks in each paper of each of the groups and a minimum
of 50 percent marks in the aggregate of all the papers of each of the groups; or
(b) secures at one sitting minimum of 40 percent marks in each paper of both the groups and a minimum of
50 percent marks in the aggregate of all the papers of both the groups taken together.
(3) A candidate shall be declared to have passed in a group if he secures at one sitting a minimum of 40 percent marks in each paper of the group and a minimum of 50 percent marks in the aggregate of all the papers of that group.
(4) A candidate who has passed in any one of the groups but not in both the groups of the Final Examination under the syllabus as specified by the council under items (i) and (ii) of regulation 31 or the Final Examination as per syllabus under paragraph 3 or paragraph 3A of schedule “B” to the Chartered Accountants Regulations, 1988 or paragraph 3 of Schedule ‘BB’ to the Chartered Accountants Regulations, 1964 (two groups scheme after January 1, 1985) enforced at the relevant time shall be eligible for exemption in that particular group and shall be required to appear and pass in the remaining group in order to pass the Final Examination.
(5) The Council may frame guidelines to continue to award exemption in a paper or papers to a candidate, granted earlier under the syllabus as specified under items (i) and (ii) of regulation 31 for the unexpired chance or chances of the exemption.in the corresponding paper or papers for the paper or papers in which he had secured exemption, if the corresponding paper or papers exists in the new syallubus of the Final Examination as may be specified by the Council. On appearing in the examination of the corresponding paper or papers for the paper or papers in which he had failed, he shall be declared to have passed the examination if he secures at one sitting a minimum of 40 per cent in the corresponding paper or papers for the paper or papers in which he had failed earlier and a minimum of 50 per cent marks in the aggregate of all the papers of the group including the marks of the paper or papers in which he had earlier been granted exemption by the Council.
(6) Notwithstanding anything contained in sub regulation (1) to (5) above, a candidate who has papered in all the papers comprised in a group and fails in one or more papers comprised in a group but secures a minimum of 60 percent of the marks in any paper or papers of that group shall be eligible to appear at any one or more of the immediately next three following examinations in the paper or papers in which he secured less than 60 percent marks. He shall be declared to have passed in that group if he secures at one sitting a minimum of 40 percent marks in each of such papers and a minimum of 50 percent of the total marks of all the papers of the group including the paper or papers in which he had secured a minimum of 60 percent marks in the earlier examination referred to above. He shall not be eligible for any further exemption in the remaining paper(s) of that group until he has exhausted the exemption already granted to him in that group.
1) There are two group comprising four paper in each group.A candidate may appear in both the groups simultaneously or in one group in one examination and the remaining group at any subsequent examination and shall ordinarily be declared to have passed the Final Examination if he passes in both the groups
(2) A candidate shall ordinarily be declared to have passed the Final Examination in both the groups simultaneously, if he-
(a) secures at one sitting a minimum of 40 percent marks in each paper of each of the groups and a minimum
of 50 percent marks in the aggregate of all the papers of each of the groups; or
(b) secures at one sitting minimum of 40 percent marks in each paper of both the groups and a minimum of
50 percent marks in the aggregate of all the papers of both the groups taken together.
(3) A candidate shall be declared to have passed in a group if he secures at one sitting a minimum of 40 percent marks in each paper of the group and a minimum of 50 percent marks in the aggregate of all the papers of that group.
(4) A candidate who has passed in any one of the groups but not in both the groups of the Final Examination under the syllabus as specified by the council under items (i) and (ii) of regulation 31 or the Final Examination as per syllabus under paragraph 3 or paragraph 3A of schedule “B” to the Chartered Accountants Regulations, 1988 or paragraph 3 of Schedule ‘BB’ to the Chartered Accountants Regulations, 1964 (two groups scheme after January 1, 1985) enforced at the relevant time shall be eligible for exemption in that particular group and shall be required to appear and pass in the remaining group in order to pass the Final Examination.
(5) The Council may frame guidelines to continue to award exemption in a paper or papers to a candidate, granted earlier under the syllabus as specified under items (i) and (ii) of regulation 31 for the unexpired chance or chances of the exemption.in the corresponding paper or papers for the paper or papers in which he had secured exemption, if the corresponding paper or papers exists in the new syallubus of the Final Examination as may be specified by the Council. On appearing in the examination of the corresponding paper or papers for the paper or papers in which he had failed, he shall be declared to have passed the examination if he secures at one sitting a minimum of 40 per cent in the corresponding paper or papers for the paper or papers in which he had failed earlier and a minimum of 50 per cent marks in the aggregate of all the papers of the group including the marks of the paper or papers in which he had earlier been granted exemption by the Council.
(6) Notwithstanding anything contained in sub regulation (1) to (5) above, a candidate who has papered in all the papers comprised in a group and fails in one or more papers comprised in a group but secures a minimum of 60 percent of the marks in any paper or papers of that group shall be eligible to appear at any one or more of the immediately next three following examinations in the paper or papers in which he secured less than 60 percent marks. He shall be declared to have passed in that group if he secures at one sitting a minimum of 40 percent marks in each of such papers and a minimum of 50 percent of the total marks of all the papers of the group including the paper or papers in which he had secured a minimum of 60 percent marks in the earlier examination referred to above. He shall not be eligible for any further exemption in the remaining paper(s) of that group until he has exhausted the exemption already granted to him in that group.
