Result

Help Studio
, , ,
1

I need help in making a result (ATKT and RANK column). If individual subject has below 40 marks is counted in ATKT and count each student’s number of ATKT and write them in ATKT column. I attached files below. Thanks!!

MarkSheet.xlsx (11.7 KB)

GRADE_CRITERIA.xlsx (9.9 KB)

2

Hi

Hope the below steps would help you resolve this

  1. Use a excel application scope and pass the file path of the excel MarkSheet and get the output with a READ RANGE activity inside the scope with a variable named dt

  2. Now use a FOR EACH ROW activity and pass the variable dt as input

  3. Inside the loop use a assign activity like this

int_avg = (Convert.ToInt32(CurrentRow(“ENGLISH”).ToString) + Convert.ToInt32(CurrentRow(“URDU”).ToString) + Convert.ToInt32(CurrentRow(“PHYSICS”).ToString) + Convert.ToInt32(CurrentRow(“CHEMISTRY”).ToString) + Convert.ToInt32(CurrentRow(“BIOLOGY”).ToString) + Convert.ToInt32(CurrentRow(“MATH”).ToString))/6

Where int_avg is a variable of type int32

  1. Now use a IF activity like this

int_avg > 40

If true it goes to Then block or goes to else block

In else block use a ASSIGN ACTIVITY like this

CurrentRow(“ATKT”) = “comment you want”

Cheers @vivek.ramani

3

Thanks for replying me…

  How to calculate number of ATKT of each student? And also RANK?

@Palaniyappan

4

We could speedup with the solution suggestion when you will share with us some input sample data along with the corresponding expected output sample. Please provide the sample input in a way that the relevant requirements are covered (e.g. multiple students). Thanks

5

I need help in making a result (ATKT and RANK column). If individual subject has below 40 marks is counted in ATKT and count each student’s number of ATKT and write them in ATKT column. I attached files below. Thanks!!

MarkSheet.xlsx (11.7 KB)
GRADE_CRITERIA.xlsx (9.9 KB)

6

kindly note the excels are same as shared above and do not contain test data. Maybe you can replace the ones containing the test sample data. Thanks

8

I need help in making a result (ATKT and RANK column). If individual subject has below 40 marks is counted in ATKT and count each student’s number of ATKT and write them in ATKT column. I attached files below. Thanks!!

outputFile is manually created file. i need this type of output.

outputFile.xlsx (10.6 KB)
inputFile.xlsx (10.3 KB)

Thanks!! @ppr

1 Like
9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.