{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Course Details","Theory","Practical","Report"],"not_rendered":{"charts":3,"images":2,"macros":1,"external_links":0,"defined_names":26,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,2,3]]}
[]
[null,"INSTRUCTIONS:"]
[]
[]
[null,"If macros are not enabled, enable them to allow automatic calculations. "]
[null,"Set screen resolution to a minimum of 1366x768 to ensure that all of the navigation, controls, and content fit on screen."]
[null,"Unhide other sheets by clicking link on above button (password required)."]
[null,"First enter details of a course in the sheet 'Course Details'."]
[null,"Enter students name & admission no. in sheet named 'Theory' only. Names & admission no. will be taken up in other sheets automatically."]
[null,"Enter Theory marks in 'Theory' sheet & Practical marks in 'Practical' sheet."]
[null,"For saving report in PDF format or printing, first delete the blank rows if any from the delete blank rows button in 'Report' sheet."]
[null,"To save file with name automatically derived from Course no. & Acad. Session use                      button in right corner of any sheet. "]
[null,"The file will be saved in UG RESULTS folder in C: drive. e.g. C:\\UG RESULTS\\VPB-111(2013-2014) result"]
[null,"For later editing open the file saved in UG RESULTS folder."]

{"sheet":"Course Details","index":1,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":true,"merged":[[1,2,1,7]]}
[]
[null,null,"Enter Course Details in Light Blue Cells Only"]
[]
[null,null,"Particular","Instructor1","Instructor2","Instructor3","Instructor4","Instructor5"]
[null,null,"Name of Course Instructor(s):"]
[null,null,"Course No. :",null,"2013-14","FIRST PROFESSIONAL"]
[null,null,"Course Title:",null,"2014-15","SECOND PROFESSIONAL"]
[null,null,"Credit Hours:",null,"2015-16","THIRD PROFESSIONAL"]
[null,null,"Class:",null,"2016-17","FOURTH PROFESSIONAL"]
[null,null,"Session:",null,"2017-18","FIFTH PROFESSIONAL"]
[null,null,null,null,"2019-20"]

{"sheet":"Theory","index":2,"n_rows":72,"n_cols":15,"rows_kept":72,"cut":false,"hidden":true,"merged":[[7,12,7,13],[8,12,8,13],[9,12,9,13],[10,12,10,13],[0,2,0,11],[1,2,2,11],[1,12,1,13],[3,2,6,2],[3,3,6,3],[3,4,6,4],[3,5,3,6],[3,7,3,8],[3,9,5,9],[3,11,6,11],[3,10,5,10]]}
[null,null,"Fill in light blue cells only"]
[null,null,{"$f":"\"THEORY\"&\" (\"&(Course_No.)&\")\"","v":"THEORY ()"}]
[]
[null,null,"S. No.","Name of Student","Admission No.","Mid-Sem",null,"End-Sem",null,"Grand Total","Out of ","Remarks"]
[null,null,null,null,null,"DOE",null,"DOE"]
[null,null,null,null,null,"Max.","Weightage","Max.","Weightage"]
[null,null,null,null,null,null,null,null,null,{"$f":"G7+I7","v":0}]
[null,null,{"$f":"IF(ISTEXT(D8),1,\"\")","v":1},"Student1","V-2014-03-01",null,{"$f":"IF($F$7=0,0,F8/$F$7*$G$7)","v":0},null,{"$f":"IF($H$7=0,0,H8/$H$7*$I$7)","v":0},{"$f":"IF(AND(F8=\"\",H8=\"\"),\"\",G8+I8)","v":""},{"$f":"IF(AND(F8=\"\",H8=\"\"),\"\",IF(AND(F8=0,H8=0),0,ROUND((J8/$J$7*$K$7),1)))","v":""},{"$f":"IF(AND(F8=\"\",H8=\"\"),\"\",IF(AND(F8=0,H8=0),\"FAIL/ABSENT\",IF(K8<($K$7/2),\"FAIL\",\"PASS\")))","v":""},"No. of students 80% or above",null,{"$f":"COUNTIF(K8:K72,\">=\"&K7*0.8)","v":0}]
[null,null,{"$f":"IF(ISTEXT(D9),C8+1,\"\")","v":2},"Student2","V-2014-03-02",null,{"$f":"IF($F$7=0,0,F9/$F$7*$G$7)","v":0},null,{"$f":"IF($H$7=0,0,H9/$H$7*$I$7)","v":0},{"$f":"IF(AND(F9=\"\",H9=\"\"),\"\",G9+I9)","v":""},{"$f":"IF(AND(F9=\"\",H9=\"\"),\"\",IF(AND(F9=0,H9=0),0,ROUND((J9/$J$7*$K$7),1)))","v":""},{"$f":"IF(AND(F9=\"\",H9=\"\"),\"\",IF(AND(F9=0,H9=0),\"FAIL/ABSENT\",IF(K9<($K$7/2),\"FAIL\",\"PASS\")))","v":""},"No. of students between 65% & 80%",null,{"$f":"COUNTIFS(K8:K72,\">=\"&K7*0.65,K8:K72,\"<\"&K7*0.8)","v":0}]
[null,null,{"$f":"IF(ISTEXT(D10),C9+1,\"\")","v":3},"Student3","V-2014-03-03",null,0,null,0,"","","","No. of students between 50% & 65%",null,{"$f":"COUNTIFS(K8:K72,\">=\"&K7*0.5,K8:K72,\"<\"&K7*0.65)","v":0}]
[null,null,4,"Student4","V-2014-03-04",null,0,null,0,"","","","No. of students below 50%",null,{"$f":"COUNTIF(K8:K72,\"<\"&K7*0.5)","v":0}]
[null,null,5,"Student5","V-2014-03-05",null,0,null,0,"","",""]
[null,null,6,"Student6","V-2014-03-06",null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]
[null,null,"",null,null,null,0,null,0,"","",""]

{"sheet":"Practical","index":3,"n_rows":71,"n_cols":17,"rows_kept":71,"cut":false,"hidden":true,"merged":[[6,14,6,15],[7,14,7,15],[8,14,8,15],[9,14,9,15],[70,3,70,4],[69,3,69,4],[68,3,68,4],[67,3,67,4],[66,3,66,4],[65,3,65,4],[64,3,64,4],[63,3,63,4],[62,3,62,4],[61,3,61,4],[60,3,60,4],[59,3,59,4],[58,3,58,4],[57,3,57,4],[56,3,56,4],[55,3,55,4],[54,3,54,4],[53,3,53,4],[52,3,52,4],[51,3,51,4],[50,3,50,4],[49,3,49,4],[48,3,48,4],[47,3,47,4],[46,3,46,4],[45,3,45,4],[44,3,44,4],[43,3,43,4],[42,3,42,4],[41,3,41,4],[40,3,40,4],[39,3,39,4],[38,3,38,4],[37,3,37,4],[36,3,36,4],[35,3,35,4],[34,3,34,4],[33,3,33,4],[32,3,32,4],[31,3,31,4],[30,3,30,4],[29,3,29,4],[28,3,28,4],[27,3,27,4],[26,3,26,4],[25,3,25,4],[24,3,24,4],[23,3,23,4],[22,3,22,4],[21,3,21,4],[20,3,20,4],[19,3,19,4],[18,3,18,4],[17,3,17,4],[16,3,16,4],[15,3,15,4],[14,3,14,4],[13,3,13,4],[12,3,12,4],[11,3,11,4],[10,3,10,4],[9,3,9,4],[6,3,6,4],[8,3,8,4],[7,3,7,4],[0,2,0,13],[1,2,2,13],[3,3,5,4],[3,2,5,2],[3,5,5,5],[3,13,5,13],[3,6,4,6],[3,7,4,7],[3,8,4,8],[3,9,4,9],[3,10,4,10],[3,12,4,12],[3,11,4,11]]}
[null,null,"Fill in light blue cells only"]
[null,null,{"$f":"\"PRACTICAL\"&\" (\"&(Course_No.)&\")\"","v":"PRACTICAL ()"}]
[]
[null,null,"S. No.","Name of Student",null,"Admission No.","NB","Viva","Written","Assignment","Exercise","Grand Total ","Out of","Remarks"]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"G6+H6+I6+J6+K6","v":0}]
[null,null,{"$f":"INDEX(S.No.,ROW(A1))","v":1},{"$f":"INDEX(Student_name,ROW(A1))","v":"Student1"},null,{"$f":"INDEX(Admn_no.,ROW(A1))","v":"V-2014-03-01"},null,null,null,null,null,{"$f":"IF(AND(G7=\"\",H7=\"\",I7=\"\",J7=\"\",K7=\"\"),\"\",G7+H7+I7+J7+K7)","v":""},{"$f":"IF(AND(G7=\"\",H7=\"\",I7=\"\",J7=\"\",K7=\"\"),\"\",IF(AND(G7=0,H7=0,I7=0,J7=0,K7=0),0,ROUND((L7/$L$6*$M$6),1)))","v":""},{"$f":"IF(AND(G7=\"\",H7=\"\",I7=\"\",J7=\"\",K7=\"\"),\"\",IF(AND(G7=0,H7=0,I7=0,J7=0,K7=0),\"FAIL/ABSENT\",IF(M7<($M$6/2),\"FAIL\",\"PASS\")))","v":""},"No. of students 80% or above",null,{"$f":"COUNTIF(M7:M71,\">=\"&M6*0.8)","v":0}]
[null,null,2,"Student2",null,"V-2014-03-02",null,null,null,null,null,{"$f":"IF(AND(G8=\"\",H8=\"\",I8=\"\",J8=\"\",K8=\"\"),\"\",G8+H8+I8+J8+K8)","v":""},{"$f":"IF(AND(G8=\"\",H8=\"\",I8=\"\",J8=\"\",K8=\"\"),\"\",IF(AND(G8=0,H8=0,I8=0,J8=0,K8=0),0,ROUND((L8/$L$6*$M$6),1)))","v":""},{"$f":"IF(AND(G8=\"\",H8=\"\",I8=\"\",J8=\"\",K8=\"\"),\"\",IF(AND(G8=0,H8=0,I8=0,J8=0,K8=0),\"FAIL/ABSENT\",IF(M8<($M$6/2),\"FAIL\",\"PASS\")))","v":""},"No. of students between 65% & 80%",null,{"$f":"COUNTIFS(M7:M71,\">=\"&M6*0.65,M7:M71,\"<\"&M6*0.8)","v":0}]
[null,null,3,"Student3",null,"V-2014-03-03",null,null,null,null,null,"","","","No. of students between 50% & 65%",null,{"$f":"COUNTIFS(M7:M71,\">=\"&M6*0.5,M7:M71,\"<\"&M6*0.65)","v":0}]
[null,null,4,"Student4",null,"V-2014-03-04",null,null,null,null,null,"","","","No. of students below 50%",null,{"$f":"COUNTIF(M7:M71,\"<\"&M6*0.5)","v":0}]
[null,null,5,"Student5",null,"V-2014-03-05",null,null,null,null,null,"","",""]
[null,null,6,"Student6",null,"V-2014-03-06",null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,{"$f":"INDEX(S.No.,ROW(A33))","v":""},{"$f":"INDEX(Student_name,ROW(A33))","v":0},null,{"$f":"INDEX(Admn_no.,ROW(A33))","v":0},null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,"",0,null,0,null,null,null,null,null,"","",""]
[null,null,{"$f":"INDEX(S.No.,ROW(A65))","v":""},{"$f":"INDEX(Student_name,ROW(A65))","v":0},null,{"$f":"INDEX(Admn_no.,ROW(A65))","v":0},null,null,null,null,null,"","",""]

{"sheet":"Report","index":4,"n_rows":95,"n_cols":18,"rows_kept":95,"cut":false,"hidden":true,"merged":[[0,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[89,5,89,8],[78,3,78,4],[78,7,78,8],[74,3,74,4],[74,7,74,8],[70,3,70,4],[70,7,70,8],[66,3,66,4],[66,7,66,8],[62,3,62,4],[62,7,62,8],[58,3,58,4],[58,7,58,8],[54,3,54,4],[54,7,54,8],[50,3,50,4],[50,7,50,8],[64,3,64,4],[74,10,74,11],[75,3,75,4],[75,7,75,8],[75,10,75,11],[72,3,72,4],[72,7,72,8],[72,10,72,11],[73,3,73,4],[73,7,73,8],[73,10,73,11],[78,10,78,11],[79,3,79,4],[79,7,79,8],[79,10,79,11],[76,3,76,4],[76,7,76,8],[76,10,76,11],[77,3,77,4],[77,7,77,8],[77,10,77,11],[71,10,71,11],[68,3,68,4],[68,7,68,8],[68,10,68,11],[69,3,69,4],[69,7,69,8],[69,10,69,11],[66,10,66,11],[67,3,67,4],[67,7,67,8],[67,10,67,11],[70,10,70,11],[71,3,71,4],[71,7,71,8],[64,7,64,8],[64,10,64,11],[65,3,65,4],[65,7,65,8],[65,10,65,11],[62,10,62,11],[63,3,63,4],[63,7,63,8],[63,10,63,11],[60,3,60,4],[60,7,60,8],[60,10,60,11],[61,3,61,4],[61,7,61,8],[61,10,61,11],[58,10,58,11],[59,3,59,4],[59,7,59,8],[59,10,59,11],[56,3,56,4],[56,7,56,8],[56,10,56,11],[57,3,57,4],[57,7,57,8],[57,10,57,11],[54,10,54,11],[55,3,55,4],[55,7,55,8],[55,10,55,11],[52,3,52,4],[52,7,52,8],[52,10,52,11],[53,3,53,4],[53,7,53,8],[53,10,53,11],[50,10,50,11],[51,3,51,4],[51,7,51,8],[51,10,51,11],[48,3,48,4],[48,7,48,8],[48,10,48,11],[49,3,49,4],[49,7,49,8],[49,10,49,11],[46,7,46,8],[46,10,46,11],[47,3,47,4],[47,7,47,8],[47,10,47,11],[46,3,46,4],[44,3,44,4],[44,7,44,8],[44,10,44,11],[45,3,45,4],[45,7,45,8],[45,10,45,11],[42,3,42,4],[42,7,42,8],[42,10,42,11],[43,3,43,4],[43,7,43,8],[43,10,43,11],[40,3,40,4],[40,7,40,8],[40,10,40,11],[41,3,41,4],[41,7,41,8],[41,10,41,11],[38,3,38,4],[38,7,38,8],[38,10,38,11],[39,3,39,4],[39,7,39,8],[39,10,39,11],[36,3,36,4],[36,7,36,8],[36,10,36,11],[37,3,37,4],[37,7,37,8],[37,10,37,11],[34,3,34,4],[34,7,34,8],[34,10,34,11],[35,3,35,4],[35,7,35,8],[35,10,35,11],[32,3,32,4],[32,7,32,8],[32,10,32,11],[33,3,33,4],[33,7,33,8],[33,10,33,11],[30,3,30,4],[30,7,30,8],[30,10,30,11],[31,3,31,4],[31,7,31,8],[31,10,31,11],[28,3,28,4],[28,7,28,8],[28,10,28,11],[29,3,29,4],[29,7,29,8],[29,10,29,11],[26,3,26,4],[26,7,26,8],[26,10,26,11],[27,3,27,4],[27,7,27,8],[27,10,27,11],[24,3,24,4],[24,7,24,8],[24,10,24,11],[25,3,25,4],[25,7,25,8],[25,10,25,11],[22,3,22,4],[22,7,22,8],[22,10,22,11],[23,3,23,4],[23,7,23,8],[23,10,23,11],[20,3,20,4],[20,7,20,8],[20,10,20,11],[21,3,21,4],[21,7,21,8],[21,10,21,11],[12,3,14,4],[12,5,14,5],[18,3,18,4],[18,7,18,8],[18,10,18,11],[19,3,19,4],[19,7,19,8],[19,10,19,11],[16,3,16,4],[16,7,16,8],[16,10,16,11],[17,3,17,4],[17,7,17,8],[17,10,17,11],[15,12,15,13],[16,12,16,13],[17,12,17,13],[18,12,18,13],[1,2,1,11],[2,2,2,11],[3,9,3,10],[4,3,4,5],[4,9,5,11],[5,3,5,5],[12,6,12,11],[13,6,13,8],[13,9,13,11],[14,7,14,8],[14,10,14,11],[15,3,15,4],[15,7,15,8],[15,10,15,11],[6,3,6,5],[7,3,7,5],[8,3,8,5],[10,4,10,5],[12,2,14,2],[11,2,11,4]]}
["TOP FIVE RANK HOLDERS",null,null,null,null,null,null,null,null,null,"Acad. Form-22"]
[null,null,"Result of Internal Examination (Instructor's Report)"]
[{"$f":"IFERROR(IF(AND(K8=\"\",K9=\"\"),\"\",\"1. \"&INDEX($D$16:$D$80,MATCH(1,$Q$16:$Q$80,0))),\"\")","v":""},null,"(See Academic Regulation 8.11.1)"]
[{"$f":"IFERROR(IF(AND(K8=\"\",K9=\"\"),\"\",\"2. \"&INDEX($D$16:$D$80,MATCH(2,$Q$16:$Q$80,0))),\"\")","v":""},null,"Name of Course Instructor(s):",null,null,null,null,null,"Course No. :",{"$f":"IF(Course_No.=\"\",\"\",Course_No.)","v":""}]
[{"$f":"IFERROR(IF(AND(K8=\"\",K9=\"\"),\"\",\"3. \"&INDEX($D$16:$D$80,MATCH(3,$Q$16:$Q$80,0))),\"\")","v":""},null,1,{"$f":"IF(Instructor1=\"\",\"\",Instructor1)","v":""},null,null,null,null,"Course Title:",{"$f":"IF(Course_Title=\"\",\"\",Course_Title)","v":""}]
[{"$f":"IFERROR(IF(AND(K8=\"\",K9=\"\"),\"\",\"4. \"&INDEX($D$16:$D$80,MATCH(4,$Q$16:$Q$80,0))),\"\")","v":""},null,{"$f":"IF(D6=\"\",\"\",C5+1)","v":""},{"$f":"IF(Instructor2=\"\",\"\",Instructor2)","v":""}]
[{"$f":"IFERROR(IF(AND(K8=\"\",K9=\"\"),\"\",\"5. \"&INDEX($D$16:$D$80,MATCH(5,$Q$16:$Q$80,0))),\"\")","v":""},null,{"$f":"IF(D7=\"\",\"\",C6+1)","v":""},{"$f":"IF(Instructor3=\"\",\"\",Instructor3)","v":""},null,null,null,null,"Credit Hours:",{"$f":"IF(Credit_Hours=\"\",\"\",Credit_Hours)","v":""}]
[null,null,{"$f":"IF(D8=\"\",\"\",C7+1)","v":""},{"$f":"IF(Instructor4=\"\",\"\",Instructor4)","v":""},null,null,null,null,"Max. Marks","i) Theory:",{"$f":"IF(Max._Marks__Theory=\"\",0,Max._Marks__Theory)","v":0}]
[null,null,{"$f":"IF(D9=\"\",\"\",C8+1)","v":""},{"$f":"IF(Instructor5=\"\",\"\",Instructor5)","v":""},null,null,null,null,null,"ii) Practical:",{"$f":"IF(Max._Marks__Practical=\"\",0,Max._Marks__Practical)","v":0}]
[null,null,"Class:",null,{"$f":"IF(Class=\"\",\"\",Class)","v":""}]
[null,null,"Session:",null,{"$f":"IF(Acad_year=\"\",\"\",Acad_year)","v":""}]
[null,null,"Date of Examination:",null,null,{"$f":"IF(Date_of_End_Term_Examination=\"\",\"\",Date_of_End_Term_Examination)","v":""}]
[null,null,"S. No.","Name of Student",null,"Admission No.","RESULT"]
[null,null,null,null,null,null,{"$f":"\"Theory (\"&Max._Marks__Theory&\")\"","v":"Theory ()"},null,null,{"$f":"\"Practical (\"&Max._Marks__Practical&\")\"","v":"Practical ()"}]
[null,null,null,null,null,null,"Figures","Words",null,"Figures","Words"]
[null,null,{"$f":"INDEX(S.No.,ROW(A1))","v":1},{"$f":"IF(INDEX(Student_name,ROW(A1))=\"\",\"\",INDEX(Student_name,ROW(A1)))","v":"Student1"},null,{"$f":"IF(D16=\"\",\"\",IF(INDEX(Admn_no.,ROW(A1))=\"\",\"\",INDEX(Admn_no.,ROW(A1))))","v":"V-2014-03-01"},{"$f":"IF(INDEX(Theory_marks,ROW(A1))=0,0,IF(INDEX(Theory_marks,ROW(A1))=\"\",\"\",INDEX(Theory_marks,ROW(A1))))","v":""},{"$f":"IF(G16=\"\",\"\",IF(G16=0,\"ABSENT/WITHDRAWN\",Spellindian(G16)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A1))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A1))=0,0,INDEX(Practical_marks,ROW(A1))))","v":""},{"$f":"IF(J16=\"\",\"\",IF(J16=0,\"ABSENT/WITHDRAWN\",Spellindian(J16)))","v":""},null,"No. of students 80% or above",null,{"$f":"COUNTIF(P16:P80,\">=\"&($K$8+$K$9)*0.8)","v":0},{"$f":"IF(AND(J16=\"\",G16=\"\"),\"\",IF(G16=\"\",J16,IF(J16=\"\",G16,G16+J16)))","v":""},{"$f":"IF(AND(G16=\"\",J16=\"\"),\"\",RANK(R16,$R$16:$R$80)+COUNTIF($R$16:R16,R16)-1)","v":""},{"$f":"INDEX(P16:P80,$P$15)","v":""}]
[null,null,2,"Student2",null,"V-2014-03-02",{"$f":"IF(INDEX(Theory_marks,ROW(A2))=0,0,IF(INDEX(Theory_marks,ROW(A2))=\"\",\"\",INDEX(Theory_marks,ROW(A2))))","v":""},{"$f":"IF(G17=\"\",\"\",IF(G17=0,\"ABSENT/WITHDRAWN\",Spellindian(G17)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A2))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A2))=0,0,INDEX(Practical_marks,ROW(A2))))","v":""},{"$f":"IF(J17=\"\",\"\",IF(J17=0,\"ABSENT/WITHDRAWN\",Spellindian(J17)))","v":""},null,"No. of students between 65% & 80%",null,{"$f":"COUNTIFS(P16:P80,\">=\"&(K8+K9)*0.65,P16:P80,\"<\"&(K8+K9)*0.8)","v":0},{"$f":"IF(AND(J17=\"\",G17=\"\"),\"\",IF(G17=\"\",J17,IF(J17=\"\",G17,G17+J17)))","v":""},{"$f":"IF(AND(G17=\"\",J17=\"\"),\"\",RANK(R17,$R$16:$R$80)+COUNTIF($R$16:R17,R17)-1)","v":""},{"$f":"INDEX(P17:P81,$P$15)","v":""}]
[null,null,3,"Student3",null,"V-2014-03-03",{"$f":"IF(INDEX(Theory_marks,ROW(A3))=0,0,IF(INDEX(Theory_marks,ROW(A3))=\"\",\"\",INDEX(Theory_marks,ROW(A3))))","v":""},{"$f":"IF(G18=\"\",\"\",IF(G18=0,\"ABSENT/WITHDRAWN\",Spellindian(G18)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A3))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A3))=0,0,INDEX(Practical_marks,ROW(A3))))","v":""},{"$f":"IF(J18=\"\",\"\",IF(J18=0,\"ABSENT/WITHDRAWN\",Spellindian(J18)))","v":""},null,"No. of students between 50% & 65%",null,{"$f":"COUNTIFS(P16:P80,\">=\"&(K8+K9)*0.5,P16:P80,\"<\"&(K8+K9)*0.65)","v":0},"",{"$f":"IF(AND(G18=\"\",J18=\"\"),\"\",RANK(R18,$R$16:$R$80)+COUNTIF($R$16:R18,R18)-1)","v":""},""]
[null,null,4,"Student4",null,"V-2014-03-04",{"$f":"IF(INDEX(Theory_marks,ROW(A4))=0,0,IF(INDEX(Theory_marks,ROW(A4))=\"\",\"\",INDEX(Theory_marks,ROW(A4))))","v":""},{"$f":"IF(G19=\"\",\"\",IF(G19=0,\"ABSENT/WITHDRAWN\",Spellindian(G19)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A4))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A4))=0,0,INDEX(Practical_marks,ROW(A4))))","v":""},{"$f":"IF(J19=\"\",\"\",IF(J19=0,\"ABSENT/WITHDRAWN\",Spellindian(J19)))","v":""},null,"No. of students below 50%",null,{"$f":"COUNTIF(P16:P80,\"<\"&(K8+K9)*0.5)","v":0},"",{"$f":"IF(AND(G19=\"\",J19=\"\"),\"\",RANK(R19,$R$16:$R$80)+COUNTIF($R$16:R19,R19)-1)","v":""},""]
[null,null,5,"Student5",null,"V-2014-03-05",{"$f":"IF(INDEX(Theory_marks,ROW(A5))=0,0,IF(INDEX(Theory_marks,ROW(A5))=\"\",\"\",INDEX(Theory_marks,ROW(A5))))","v":""},{"$f":"IF(G20=\"\",\"\",IF(G20=0,\"ABSENT/WITHDRAWN\",Spellindian(G20)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A5))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A5))=0,0,INDEX(Practical_marks,ROW(A5))))","v":""},{"$f":"IF(J20=\"\",\"\",IF(J20=0,\"ABSENT/WITHDRAWN\",Spellindian(J20)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G20=\"\",J20=\"\"),\"\",RANK(R20,$R$16:$R$80)+COUNTIF($R$16:R20,R20)-1)","v":""},""]
[null,null,6,"Student6",null,"V-2014-03-06",{"$f":"IF(INDEX(Theory_marks,ROW(A6))=0,0,IF(INDEX(Theory_marks,ROW(A6))=\"\",\"\",INDEX(Theory_marks,ROW(A6))))","v":""},{"$f":"IF(G21=\"\",\"\",IF(G21=0,\"ABSENT/WITHDRAWN\",Spellindian(G21)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A6))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A6))=0,0,INDEX(Practical_marks,ROW(A6))))","v":""},{"$f":"IF(J21=\"\",\"\",IF(J21=0,\"ABSENT/WITHDRAWN\",Spellindian(J21)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G21=\"\",J21=\"\"),\"\",RANK(R21,$R$16:$R$80)+COUNTIF($R$16:R21,R21)-1)","v":""},""]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A7))=0,0,IF(INDEX(Theory_marks,ROW(A7))=\"\",\"\",INDEX(Theory_marks,ROW(A7))))","v":""},{"$f":"IF(G22=\"\",\"\",IF(G22=0,\"ABSENT/WITHDRAWN\",Spellindian(G22)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A7))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A7))=0,0,INDEX(Practical_marks,ROW(A7))))","v":""},{"$f":"IF(J22=\"\",\"\",IF(J22=0,\"ABSENT/WITHDRAWN\",Spellindian(J22)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G22=\"\",J22=\"\"),\"\",RANK(R22,$R$16:$R$80)+COUNTIF($R$16:R22,R22)-1)","v":""},""]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A8))=0,0,IF(INDEX(Theory_marks,ROW(A8))=\"\",\"\",INDEX(Theory_marks,ROW(A8))))","v":""},{"$f":"IF(G23=\"\",\"\",IF(G23=0,\"ABSENT/WITHDRAWN\",Spellindian(G23)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A8))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A8))=0,0,INDEX(Practical_marks,ROW(A8))))","v":""},{"$f":"IF(J23=\"\",\"\",IF(J23=0,\"ABSENT/WITHDRAWN\",Spellindian(J23)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G23=\"\",J23=\"\"),\"\",RANK(R23,$R$16:$R$80)+COUNTIF($R$16:R23,R23)-1)","v":""},""]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A9))=0,0,IF(INDEX(Theory_marks,ROW(A9))=\"\",\"\",INDEX(Theory_marks,ROW(A9))))","v":""},{"$f":"IF(G24=\"\",\"\",IF(G24=0,\"ABSENT/WITHDRAWN\",Spellindian(G24)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A9))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A9))=0,0,INDEX(Practical_marks,ROW(A9))))","v":""},{"$f":"IF(J24=\"\",\"\",IF(J24=0,\"ABSENT/WITHDRAWN\",Spellindian(J24)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G24=\"\",J24=\"\"),\"\",RANK(R24,$R$16:$R$80)+COUNTIF($R$16:R24,R24)-1)","v":""},""]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A10))=0,0,IF(INDEX(Theory_marks,ROW(A10))=\"\",\"\",INDEX(Theory_marks,ROW(A10))))","v":""},{"$f":"IF(G25=\"\",\"\",IF(G25=0,\"ABSENT/WITHDRAWN\",Spellindian(G25)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A10))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A10))=0,0,INDEX(Practical_marks,ROW(A10))))","v":""},{"$f":"IF(J25=\"\",\"\",IF(J25=0,\"ABSENT/WITHDRAWN\",Spellindian(J25)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G25=\"\",J25=\"\"),\"\",RANK(R25,$R$16:$R$80)+COUNTIF($R$16:R25,R25)-1)","v":""},""]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A11))=0,0,IF(INDEX(Theory_marks,ROW(A11))=\"\",\"\",INDEX(Theory_marks,ROW(A11))))","v":""},{"$f":"IF(G26=\"\",\"\",IF(G26=0,\"ABSENT/WITHDRAWN\",Spellindian(G26)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A11))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A11))=0,0,INDEX(Practical_marks,ROW(A11))))","v":""},{"$f":"IF(J26=\"\",\"\",IF(J26=0,\"ABSENT/WITHDRAWN\",Spellindian(J26)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G26=\"\",J26=\"\"),\"\",RANK(R26,$R$16:$R$80)+COUNTIF($R$16:R26,R26)-1)","v":""},""]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A12))=0,0,IF(INDEX(Theory_marks,ROW(A12))=\"\",\"\",INDEX(Theory_marks,ROW(A12))))","v":""},{"$f":"IF(G27=\"\",\"\",IF(G27=0,\"ABSENT/WITHDRAWN\",Spellindian(G27)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A12))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A12))=0,0,INDEX(Practical_marks,ROW(A12))))","v":""},{"$f":"IF(J27=\"\",\"\",IF(J27=0,\"ABSENT/WITHDRAWN\",Spellindian(J27)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G27=\"\",J27=\"\"),\"\",RANK(R27,$R$16:$R$80)+COUNTIF($R$16:R27,R27)-1)","v":""},""]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A13))=0,0,IF(INDEX(Theory_marks,ROW(A13))=\"\",\"\",INDEX(Theory_marks,ROW(A13))))","v":""},{"$f":"IF(G28=\"\",\"\",IF(G28=0,\"ABSENT/WITHDRAWN\",Spellindian(G28)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A13))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A13))=0,0,INDEX(Practical_marks,ROW(A13))))","v":""},{"$f":"IF(J28=\"\",\"\",IF(J28=0,\"ABSENT/WITHDRAWN\",Spellindian(J28)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G28=\"\",J28=\"\"),\"\",RANK(R28,$R$16:$R$80)+COUNTIF($R$16:R28,R28)-1)","v":""},""]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A14))=0,0,IF(INDEX(Theory_marks,ROW(A14))=\"\",\"\",INDEX(Theory_marks,ROW(A14))))","v":""},{"$f":"IF(G29=\"\",\"\",IF(G29=0,\"ABSENT/WITHDRAWN\",Spellindian(G29)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A14))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A14))=0,0,INDEX(Practical_marks,ROW(A14))))","v":""},{"$f":"IF(J29=\"\",\"\",IF(J29=0,\"ABSENT/WITHDRAWN\",Spellindian(J29)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G29=\"\",J29=\"\"),\"\",RANK(R29,$R$16:$R$80)+COUNTIF($R$16:R29,R29)-1)","v":""},""]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A15))=0,0,IF(INDEX(Theory_marks,ROW(A15))=\"\",\"\",INDEX(Theory_marks,ROW(A15))))","v":""},{"$f":"IF(G30=\"\",\"\",IF(G30=0,\"ABSENT/WITHDRAWN\",Spellindian(G30)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A15))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A15))=0,0,INDEX(Practical_marks,ROW(A15))))","v":""},{"$f":"IF(J30=\"\",\"\",IF(J30=0,\"ABSENT/WITHDRAWN\",Spellindian(J30)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G30=\"\",J30=\"\"),\"\",RANK(R30,$R$16:$R$80)+COUNTIF($R$16:R30,R30)-1)","v":""},""]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A16))=0,0,IF(INDEX(Theory_marks,ROW(A16))=\"\",\"\",INDEX(Theory_marks,ROW(A16))))","v":""},{"$f":"IF(G31=\"\",\"\",IF(G31=0,\"ABSENT/WITHDRAWN\",Spellindian(G31)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A16))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A16))=0,0,INDEX(Practical_marks,ROW(A16))))","v":""},{"$f":"IF(J31=\"\",\"\",IF(J31=0,\"ABSENT/WITHDRAWN\",Spellindian(J31)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G31=\"\",J31=\"\"),\"\",RANK(R31,$R$16:$R$80)+COUNTIF($R$16:R31,R31)-1)","v":""},""]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A17))=0,0,IF(INDEX(Theory_marks,ROW(A17))=\"\",\"\",INDEX(Theory_marks,ROW(A17))))","v":""},{"$f":"IF(G32=\"\",\"\",IF(G32=0,\"ABSENT/WITHDRAWN\",Spellindian(G32)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A17))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A17))=0,0,INDEX(Practical_marks,ROW(A17))))","v":""},{"$f":"IF(J32=\"\",\"\",IF(J32=0,\"ABSENT/WITHDRAWN\",Spellindian(J32)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G32=\"\",J32=\"\"),\"\",RANK(R32,$R$16:$R$80)+COUNTIF($R$16:R32,R32)-1)","v":""},""]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A18))=0,0,IF(INDEX(Theory_marks,ROW(A18))=\"\",\"\",INDEX(Theory_marks,ROW(A18))))","v":""},{"$f":"IF(G33=\"\",\"\",IF(G33=0,\"ABSENT/WITHDRAWN\",Spellindian(G33)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A18))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A18))=0,0,INDEX(Practical_marks,ROW(A18))))","v":""},{"$f":"IF(J33=\"\",\"\",IF(J33=0,\"ABSENT/WITHDRAWN\",Spellindian(J33)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G33=\"\",J33=\"\"),\"\",RANK(R33,$R$16:$R$80)+COUNTIF($R$16:R33,R33)-1)","v":""},""]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A19))=0,0,IF(INDEX(Theory_marks,ROW(A19))=\"\",\"\",INDEX(Theory_marks,ROW(A19))))","v":""},{"$f":"IF(G34=\"\",\"\",IF(G34=0,\"ABSENT/WITHDRAWN\",Spellindian(G34)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A19))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A19))=0,0,INDEX(Practical_marks,ROW(A19))))","v":""},{"$f":"IF(J34=\"\",\"\",IF(J34=0,\"ABSENT/WITHDRAWN\",Spellindian(J34)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G34=\"\",J34=\"\"),\"\",RANK(R34,$R$16:$R$80)+COUNTIF($R$16:R34,R34)-1)","v":""},""]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A20))=0,0,IF(INDEX(Theory_marks,ROW(A20))=\"\",\"\",INDEX(Theory_marks,ROW(A20))))","v":""},{"$f":"IF(G35=\"\",\"\",IF(G35=0,\"ABSENT/WITHDRAWN\",Spellindian(G35)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A20))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A20))=0,0,INDEX(Practical_marks,ROW(A20))))","v":""},{"$f":"IF(J35=\"\",\"\",IF(J35=0,\"ABSENT/WITHDRAWN\",Spellindian(J35)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G35=\"\",J35=\"\"),\"\",RANK(R35,$R$16:$R$80)+COUNTIF($R$16:R35,R35)-1)","v":""},""]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A21))=0,0,IF(INDEX(Theory_marks,ROW(A21))=\"\",\"\",INDEX(Theory_marks,ROW(A21))))","v":""},{"$f":"IF(G36=\"\",\"\",IF(G36=0,\"ABSENT/WITHDRAWN\",Spellindian(G36)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A21))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A21))=0,0,INDEX(Practical_marks,ROW(A21))))","v":""},{"$f":"IF(J36=\"\",\"\",IF(J36=0,\"ABSENT/WITHDRAWN\",Spellindian(J36)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G36=\"\",J36=\"\"),\"\",RANK(R36,$R$16:$R$80)+COUNTIF($R$16:R36,R36)-1)","v":""},""]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A22))=0,0,IF(INDEX(Theory_marks,ROW(A22))=\"\",\"\",INDEX(Theory_marks,ROW(A22))))","v":""},{"$f":"IF(G37=\"\",\"\",IF(G37=0,\"ABSENT/WITHDRAWN\",Spellindian(G37)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A22))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A22))=0,0,INDEX(Practical_marks,ROW(A22))))","v":""},{"$f":"IF(J37=\"\",\"\",IF(J37=0,\"ABSENT/WITHDRAWN\",Spellindian(J37)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G37=\"\",J37=\"\"),\"\",RANK(R37,$R$16:$R$80)+COUNTIF($R$16:R37,R37)-1)","v":""},{"$f":"INDEX(P37:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A23))=0,0,IF(INDEX(Theory_marks,ROW(A23))=\"\",\"\",INDEX(Theory_marks,ROW(A23))))","v":""},{"$f":"IF(G38=\"\",\"\",IF(G38=0,\"ABSENT/WITHDRAWN\",Spellindian(G38)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A23))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A23))=0,0,INDEX(Practical_marks,ROW(A23))))","v":""},{"$f":"IF(J38=\"\",\"\",IF(J38=0,\"ABSENT/WITHDRAWN\",Spellindian(J38)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G38=\"\",J38=\"\"),\"\",RANK(R38,$R$16:$R$80)+COUNTIF($R$16:R38,R38)-1)","v":""},{"$f":"INDEX(P38:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A24))=0,0,IF(INDEX(Theory_marks,ROW(A24))=\"\",\"\",INDEX(Theory_marks,ROW(A24))))","v":""},{"$f":"IF(G39=\"\",\"\",IF(G39=0,\"ABSENT/WITHDRAWN\",Spellindian(G39)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A24))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A24))=0,0,INDEX(Practical_marks,ROW(A24))))","v":""},{"$f":"IF(J39=\"\",\"\",IF(J39=0,\"ABSENT/WITHDRAWN\",Spellindian(J39)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G39=\"\",J39=\"\"),\"\",RANK(R39,$R$16:$R$80)+COUNTIF($R$16:R39,R39)-1)","v":""},{"$f":"INDEX(P39:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A25))=0,0,IF(INDEX(Theory_marks,ROW(A25))=\"\",\"\",INDEX(Theory_marks,ROW(A25))))","v":""},{"$f":"IF(G40=\"\",\"\",IF(G40=0,\"ABSENT/WITHDRAWN\",Spellindian(G40)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A25))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A25))=0,0,INDEX(Practical_marks,ROW(A25))))","v":""},{"$f":"IF(J40=\"\",\"\",IF(J40=0,\"ABSENT/WITHDRAWN\",Spellindian(J40)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G40=\"\",J40=\"\"),\"\",RANK(R40,$R$16:$R$80)+COUNTIF($R$16:R40,R40)-1)","v":""},{"$f":"INDEX(P40:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A26))=0,0,IF(INDEX(Theory_marks,ROW(A26))=\"\",\"\",INDEX(Theory_marks,ROW(A26))))","v":""},{"$f":"IF(G41=\"\",\"\",IF(G41=0,\"ABSENT/WITHDRAWN\",Spellindian(G41)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A26))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A26))=0,0,INDEX(Practical_marks,ROW(A26))))","v":""},{"$f":"IF(J41=\"\",\"\",IF(J41=0,\"ABSENT/WITHDRAWN\",Spellindian(J41)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G41=\"\",J41=\"\"),\"\",RANK(R41,$R$16:$R$80)+COUNTIF($R$16:R41,R41)-1)","v":""},{"$f":"INDEX(P41:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A27))=0,0,IF(INDEX(Theory_marks,ROW(A27))=\"\",\"\",INDEX(Theory_marks,ROW(A27))))","v":""},{"$f":"IF(G42=\"\",\"\",IF(G42=0,\"ABSENT/WITHDRAWN\",Spellindian(G42)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A27))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A27))=0,0,INDEX(Practical_marks,ROW(A27))))","v":""},{"$f":"IF(J42=\"\",\"\",IF(J42=0,\"ABSENT/WITHDRAWN\",Spellindian(J42)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G42=\"\",J42=\"\"),\"\",RANK(R42,$R$16:$R$80)+COUNTIF($R$16:R42,R42)-1)","v":""},{"$f":"INDEX(P42:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A28))=0,0,IF(INDEX(Theory_marks,ROW(A28))=\"\",\"\",INDEX(Theory_marks,ROW(A28))))","v":""},{"$f":"IF(G43=\"\",\"\",IF(G43=0,\"ABSENT/WITHDRAWN\",Spellindian(G43)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A28))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A28))=0,0,INDEX(Practical_marks,ROW(A28))))","v":""},{"$f":"IF(J43=\"\",\"\",IF(J43=0,\"ABSENT/WITHDRAWN\",Spellindian(J43)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G43=\"\",J43=\"\"),\"\",RANK(R43,$R$16:$R$80)+COUNTIF($R$16:R43,R43)-1)","v":""},{"$f":"INDEX(P43:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A29))=0,0,IF(INDEX(Theory_marks,ROW(A29))=\"\",\"\",INDEX(Theory_marks,ROW(A29))))","v":""},{"$f":"IF(G44=\"\",\"\",IF(G44=0,\"ABSENT/WITHDRAWN\",Spellindian(G44)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A29))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A29))=0,0,INDEX(Practical_marks,ROW(A29))))","v":""},{"$f":"IF(J44=\"\",\"\",IF(J44=0,\"ABSENT/WITHDRAWN\",Spellindian(J44)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G44=\"\",J44=\"\"),\"\",RANK(R44,$R$16:$R$80)+COUNTIF($R$16:R44,R44)-1)","v":""},{"$f":"INDEX(P44:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A30))=0,0,IF(INDEX(Theory_marks,ROW(A30))=\"\",\"\",INDEX(Theory_marks,ROW(A30))))","v":""},{"$f":"IF(G45=\"\",\"\",IF(G45=0,\"ABSENT/WITHDRAWN\",Spellindian(G45)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A30))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A30))=0,0,INDEX(Practical_marks,ROW(A30))))","v":""},{"$f":"IF(J45=\"\",\"\",IF(J45=0,\"ABSENT/WITHDRAWN\",Spellindian(J45)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G45=\"\",J45=\"\"),\"\",RANK(R45,$R$16:$R$80)+COUNTIF($R$16:R45,R45)-1)","v":""},{"$f":"INDEX(P45:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A31))=0,0,IF(INDEX(Theory_marks,ROW(A31))=\"\",\"\",INDEX(Theory_marks,ROW(A31))))","v":""},{"$f":"IF(G46=\"\",\"\",IF(G46=0,\"ABSENT/WITHDRAWN\",Spellindian(G46)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A31))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A31))=0,0,INDEX(Practical_marks,ROW(A31))))","v":""},{"$f":"IF(J46=\"\",\"\",IF(J46=0,\"ABSENT/WITHDRAWN\",Spellindian(J46)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G46=\"\",J46=\"\"),\"\",RANK(R46,$R$16:$R$80)+COUNTIF($R$16:R46,R46)-1)","v":""},{"$f":"INDEX(P46:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A32))=0,0,IF(INDEX(Theory_marks,ROW(A32))=\"\",\"\",INDEX(Theory_marks,ROW(A32))))","v":""},{"$f":"IF(G47=\"\",\"\",IF(G47=0,\"ABSENT/WITHDRAWN\",Spellindian(G47)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A32))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A32))=0,0,INDEX(Practical_marks,ROW(A32))))","v":""},{"$f":"IF(J47=\"\",\"\",IF(J47=0,\"ABSENT/WITHDRAWN\",Spellindian(J47)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G47=\"\",J47=\"\"),\"\",RANK(R47,$R$16:$R$80)+COUNTIF($R$16:R47,R47)-1)","v":""},{"$f":"INDEX(P47:P100,$P$15)","v":""}]
[null,null,{"$f":"INDEX(S.No.,ROW(A33))","v":""},{"$f":"IF(INDEX(Student_name,ROW(A33))=\"\",\"\",INDEX(Student_name,ROW(A33)))","v":""},null,{"$f":"IF(D48=\"\",\"\",IF(INDEX(Admn_no.,ROW(A33))=\"\",\"\",INDEX(Admn_no.,ROW(A33))))","v":""},{"$f":"IF(INDEX(Theory_marks,ROW(A33))=0,0,IF(INDEX(Theory_marks,ROW(A33))=\"\",\"\",INDEX(Theory_marks,ROW(A33))))","v":""},{"$f":"IF(G48=\"\",\"\",IF(G48=0,\"ABSENT/WITHDRAWN\",Spellindian(G48)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A33))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A33))=0,0,INDEX(Practical_marks,ROW(A33))))","v":""},{"$f":"IF(J48=\"\",\"\",IF(J48=0,\"ABSENT/WITHDRAWN\",Spellindian(J48)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G48=\"\",J48=\"\"),\"\",RANK(R48,$R$16:$R$80)+COUNTIF($R$16:R48,R48)-1)","v":""},{"$f":"INDEX(P48:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A34))=0,0,IF(INDEX(Theory_marks,ROW(A34))=\"\",\"\",INDEX(Theory_marks,ROW(A34))))","v":""},{"$f":"IF(G49=\"\",\"\",IF(G49=0,\"ABSENT/WITHDRAWN\",Spellindian(G49)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A34))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A34))=0,0,INDEX(Practical_marks,ROW(A34))))","v":""},{"$f":"IF(J49=\"\",\"\",IF(J49=0,\"ABSENT/WITHDRAWN\",Spellindian(J49)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G49=\"\",J49=\"\"),\"\",RANK(R49,$R$16:$R$80)+COUNTIF($R$16:R49,R49)-1)","v":""},{"$f":"INDEX(P49:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A35))=0,0,IF(INDEX(Theory_marks,ROW(A35))=\"\",\"\",INDEX(Theory_marks,ROW(A35))))","v":""},{"$f":"IF(G50=\"\",\"\",IF(G50=0,\"ABSENT/WITHDRAWN\",Spellindian(G50)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A35))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A35))=0,0,INDEX(Practical_marks,ROW(A35))))","v":""},{"$f":"IF(J50=\"\",\"\",IF(J50=0,\"ABSENT/WITHDRAWN\",Spellindian(J50)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G50=\"\",J50=\"\"),\"\",RANK(R50,$R$16:$R$80)+COUNTIF($R$16:R50,R50)-1)","v":""},{"$f":"INDEX(P50:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A36))=0,0,IF(INDEX(Theory_marks,ROW(A36))=\"\",\"\",INDEX(Theory_marks,ROW(A36))))","v":""},{"$f":"IF(G51=\"\",\"\",IF(G51=0,\"ABSENT/WITHDRAWN\",Spellindian(G51)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A36))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A36))=0,0,INDEX(Practical_marks,ROW(A36))))","v":""},{"$f":"IF(J51=\"\",\"\",IF(J51=0,\"ABSENT/WITHDRAWN\",Spellindian(J51)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G51=\"\",J51=\"\"),\"\",RANK(R51,$R$16:$R$80)+COUNTIF($R$16:R51,R51)-1)","v":""},{"$f":"INDEX(P51:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A37))=0,0,IF(INDEX(Theory_marks,ROW(A37))=\"\",\"\",INDEX(Theory_marks,ROW(A37))))","v":""},{"$f":"IF(G52=\"\",\"\",IF(G52=0,\"ABSENT/WITHDRAWN\",Spellindian(G52)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A37))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A37))=0,0,INDEX(Practical_marks,ROW(A37))))","v":""},{"$f":"IF(J52=\"\",\"\",IF(J52=0,\"ABSENT/WITHDRAWN\",Spellindian(J52)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G52=\"\",J52=\"\"),\"\",RANK(R52,$R$16:$R$80)+COUNTIF($R$16:R52,R52)-1)","v":""},{"$f":"INDEX(P52:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A38))=0,0,IF(INDEX(Theory_marks,ROW(A38))=\"\",\"\",INDEX(Theory_marks,ROW(A38))))","v":""},{"$f":"IF(G53=\"\",\"\",IF(G53=0,\"ABSENT/WITHDRAWN\",Spellindian(G53)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A38))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A38))=0,0,INDEX(Practical_marks,ROW(A38))))","v":""},{"$f":"IF(J53=\"\",\"\",IF(J53=0,\"ABSENT/WITHDRAWN\",Spellindian(J53)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G53=\"\",J53=\"\"),\"\",RANK(R53,$R$16:$R$80)+COUNTIF($R$16:R53,R53)-1)","v":""},{"$f":"INDEX(P53:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A39))=0,0,IF(INDEX(Theory_marks,ROW(A39))=\"\",\"\",INDEX(Theory_marks,ROW(A39))))","v":""},{"$f":"IF(G54=\"\",\"\",IF(G54=0,\"ABSENT/WITHDRAWN\",Spellindian(G54)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A39))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A39))=0,0,INDEX(Practical_marks,ROW(A39))))","v":""},{"$f":"IF(J54=\"\",\"\",IF(J54=0,\"ABSENT/WITHDRAWN\",Spellindian(J54)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G54=\"\",J54=\"\"),\"\",RANK(R54,$R$16:$R$80)+COUNTIF($R$16:R54,R54)-1)","v":""},{"$f":"INDEX(P54:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A40))=0,0,IF(INDEX(Theory_marks,ROW(A40))=\"\",\"\",INDEX(Theory_marks,ROW(A40))))","v":""},{"$f":"IF(G55=\"\",\"\",IF(G55=0,\"ABSENT/WITHDRAWN\",Spellindian(G55)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A40))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A40))=0,0,INDEX(Practical_marks,ROW(A40))))","v":""},{"$f":"IF(J55=\"\",\"\",IF(J55=0,\"ABSENT/WITHDRAWN\",Spellindian(J55)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G55=\"\",J55=\"\"),\"\",RANK(R55,$R$16:$R$80)+COUNTIF($R$16:R55,R55)-1)","v":""},{"$f":"INDEX(P55:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A41))=0,0,IF(INDEX(Theory_marks,ROW(A41))=\"\",\"\",INDEX(Theory_marks,ROW(A41))))","v":""},{"$f":"IF(G56=\"\",\"\",IF(G56=0,\"ABSENT/WITHDRAWN\",Spellindian(G56)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A41))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A41))=0,0,INDEX(Practical_marks,ROW(A41))))","v":""},{"$f":"IF(J56=\"\",\"\",IF(J56=0,\"ABSENT/WITHDRAWN\",Spellindian(J56)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G56=\"\",J56=\"\"),\"\",RANK(R56,$R$16:$R$80)+COUNTIF($R$16:R56,R56)-1)","v":""},{"$f":"INDEX(P56:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A42))=0,0,IF(INDEX(Theory_marks,ROW(A42))=\"\",\"\",INDEX(Theory_marks,ROW(A42))))","v":""},{"$f":"IF(G57=\"\",\"\",IF(G57=0,\"ABSENT/WITHDRAWN\",Spellindian(G57)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A42))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A42))=0,0,INDEX(Practical_marks,ROW(A42))))","v":""},{"$f":"IF(J57=\"\",\"\",IF(J57=0,\"ABSENT/WITHDRAWN\",Spellindian(J57)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G57=\"\",J57=\"\"),\"\",RANK(R57,$R$16:$R$80)+COUNTIF($R$16:R57,R57)-1)","v":""},{"$f":"INDEX(P57:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A43))=0,0,IF(INDEX(Theory_marks,ROW(A43))=\"\",\"\",INDEX(Theory_marks,ROW(A43))))","v":""},{"$f":"IF(G58=\"\",\"\",IF(G58=0,\"ABSENT/WITHDRAWN\",Spellindian(G58)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A43))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A43))=0,0,INDEX(Practical_marks,ROW(A43))))","v":""},{"$f":"IF(J58=\"\",\"\",IF(J58=0,\"ABSENT/WITHDRAWN\",Spellindian(J58)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G58=\"\",J58=\"\"),\"\",RANK(R58,$R$16:$R$80)+COUNTIF($R$16:R58,R58)-1)","v":""},{"$f":"INDEX(P58:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A44))=0,0,IF(INDEX(Theory_marks,ROW(A44))=\"\",\"\",INDEX(Theory_marks,ROW(A44))))","v":""},{"$f":"IF(G59=\"\",\"\",IF(G59=0,\"ABSENT/WITHDRAWN\",Spellindian(G59)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A44))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A44))=0,0,INDEX(Practical_marks,ROW(A44))))","v":""},{"$f":"IF(J59=\"\",\"\",IF(J59=0,\"ABSENT/WITHDRAWN\",Spellindian(J59)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G59=\"\",J59=\"\"),\"\",RANK(R59,$R$16:$R$80)+COUNTIF($R$16:R59,R59)-1)","v":""},{"$f":"INDEX(P59:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A45))=0,0,IF(INDEX(Theory_marks,ROW(A45))=\"\",\"\",INDEX(Theory_marks,ROW(A45))))","v":""},{"$f":"IF(G60=\"\",\"\",IF(G60=0,\"ABSENT/WITHDRAWN\",Spellindian(G60)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A45))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A45))=0,0,INDEX(Practical_marks,ROW(A45))))","v":""},{"$f":"IF(J60=\"\",\"\",IF(J60=0,\"ABSENT/WITHDRAWN\",Spellindian(J60)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G60=\"\",J60=\"\"),\"\",RANK(R60,$R$16:$R$80)+COUNTIF($R$16:R60,R60)-1)","v":""},{"$f":"INDEX(P60:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A46))=0,0,IF(INDEX(Theory_marks,ROW(A46))=\"\",\"\",INDEX(Theory_marks,ROW(A46))))","v":""},{"$f":"IF(G61=\"\",\"\",IF(G61=0,\"ABSENT/WITHDRAWN\",Spellindian(G61)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A46))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A46))=0,0,INDEX(Practical_marks,ROW(A46))))","v":""},{"$f":"IF(J61=\"\",\"\",IF(J61=0,\"ABSENT/WITHDRAWN\",Spellindian(J61)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G61=\"\",J61=\"\"),\"\",RANK(R61,$R$16:$R$80)+COUNTIF($R$16:R61,R61)-1)","v":""},{"$f":"INDEX(P61:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A47))=0,0,IF(INDEX(Theory_marks,ROW(A47))=\"\",\"\",INDEX(Theory_marks,ROW(A47))))","v":""},{"$f":"IF(G62=\"\",\"\",IF(G62=0,\"ABSENT/WITHDRAWN\",Spellindian(G62)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A47))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A47))=0,0,INDEX(Practical_marks,ROW(A47))))","v":""},{"$f":"IF(J62=\"\",\"\",IF(J62=0,\"ABSENT/WITHDRAWN\",Spellindian(J62)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G62=\"\",J62=\"\"),\"\",RANK(R62,$R$16:$R$80)+COUNTIF($R$16:R62,R62)-1)","v":""},{"$f":"INDEX(P62:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A48))=0,0,IF(INDEX(Theory_marks,ROW(A48))=\"\",\"\",INDEX(Theory_marks,ROW(A48))))","v":""},{"$f":"IF(G63=\"\",\"\",IF(G63=0,\"ABSENT/WITHDRAWN\",Spellindian(G63)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A48))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A48))=0,0,INDEX(Practical_marks,ROW(A48))))","v":""},{"$f":"IF(J63=\"\",\"\",IF(J63=0,\"ABSENT/WITHDRAWN\",Spellindian(J63)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G63=\"\",J63=\"\"),\"\",RANK(R63,$R$16:$R$80)+COUNTIF($R$16:R63,R63)-1)","v":""},{"$f":"INDEX(P63:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A49))=0,0,IF(INDEX(Theory_marks,ROW(A49))=\"\",\"\",INDEX(Theory_marks,ROW(A49))))","v":""},{"$f":"IF(G64=\"\",\"\",IF(G64=0,\"ABSENT/WITHDRAWN\",Spellindian(G64)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A49))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A49))=0,0,INDEX(Practical_marks,ROW(A49))))","v":""},{"$f":"IF(J64=\"\",\"\",IF(J64=0,\"ABSENT/WITHDRAWN\",Spellindian(J64)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G64=\"\",J64=\"\"),\"\",RANK(R64,$R$16:$R$80)+COUNTIF($R$16:R64,R64)-1)","v":""},{"$f":"INDEX(P64:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A50))=0,0,IF(INDEX(Theory_marks,ROW(A50))=\"\",\"\",INDEX(Theory_marks,ROW(A50))))","v":""},{"$f":"IF(G65=\"\",\"\",IF(G65=0,\"ABSENT/WITHDRAWN\",Spellindian(G65)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A50))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A50))=0,0,INDEX(Practical_marks,ROW(A50))))","v":""},{"$f":"IF(J65=\"\",\"\",IF(J65=0,\"ABSENT/WITHDRAWN\",Spellindian(J65)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G65=\"\",J65=\"\"),\"\",RANK(R65,$R$16:$R$80)+COUNTIF($R$16:R65,R65)-1)","v":""},{"$f":"INDEX(P65:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A51))=0,0,IF(INDEX(Theory_marks,ROW(A51))=\"\",\"\",INDEX(Theory_marks,ROW(A51))))","v":""},{"$f":"IF(G66=\"\",\"\",IF(G66=0,\"ABSENT/WITHDRAWN\",Spellindian(G66)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A51))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A51))=0,0,INDEX(Practical_marks,ROW(A51))))","v":""},{"$f":"IF(J66=\"\",\"\",IF(J66=0,\"ABSENT/WITHDRAWN\",Spellindian(J66)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G66=\"\",J66=\"\"),\"\",RANK(R66,$R$16:$R$80)+COUNTIF($R$16:R66,R66)-1)","v":""},{"$f":"INDEX(P66:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A52))=0,0,IF(INDEX(Theory_marks,ROW(A52))=\"\",\"\",INDEX(Theory_marks,ROW(A52))))","v":""},{"$f":"IF(G67=\"\",\"\",IF(G67=0,\"ABSENT/WITHDRAWN\",Spellindian(G67)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A52))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A52))=0,0,INDEX(Practical_marks,ROW(A52))))","v":""},{"$f":"IF(J67=\"\",\"\",IF(J67=0,\"ABSENT/WITHDRAWN\",Spellindian(J67)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G67=\"\",J67=\"\"),\"\",RANK(R67,$R$16:$R$80)+COUNTIF($R$16:R67,R67)-1)","v":""},{"$f":"INDEX(P67:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A53))=0,0,IF(INDEX(Theory_marks,ROW(A53))=\"\",\"\",INDEX(Theory_marks,ROW(A53))))","v":""},{"$f":"IF(G68=\"\",\"\",IF(G68=0,\"ABSENT/WITHDRAWN\",Spellindian(G68)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A53))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A53))=0,0,INDEX(Practical_marks,ROW(A53))))","v":""},{"$f":"IF(J68=\"\",\"\",IF(J68=0,\"ABSENT/WITHDRAWN\",Spellindian(J68)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G68=\"\",J68=\"\"),\"\",RANK(R68,$R$16:$R$80)+COUNTIF($R$16:R68,R68)-1)","v":""},{"$f":"INDEX(P68:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A54))=0,0,IF(INDEX(Theory_marks,ROW(A54))=\"\",\"\",INDEX(Theory_marks,ROW(A54))))","v":""},{"$f":"IF(G69=\"\",\"\",IF(G69=0,\"ABSENT/WITHDRAWN\",Spellindian(G69)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A54))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A54))=0,0,INDEX(Practical_marks,ROW(A54))))","v":""},{"$f":"IF(J69=\"\",\"\",IF(J69=0,\"ABSENT/WITHDRAWN\",Spellindian(J69)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G69=\"\",J69=\"\"),\"\",RANK(R69,$R$16:$R$80)+COUNTIF($R$16:R69,R69)-1)","v":""},{"$f":"INDEX(P69:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A55))=0,0,IF(INDEX(Theory_marks,ROW(A55))=\"\",\"\",INDEX(Theory_marks,ROW(A55))))","v":""},{"$f":"IF(G70=\"\",\"\",IF(G70=0,\"ABSENT/WITHDRAWN\",Spellindian(G70)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A55))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A55))=0,0,INDEX(Practical_marks,ROW(A55))))","v":""},{"$f":"IF(J70=\"\",\"\",IF(J70=0,\"ABSENT/WITHDRAWN\",Spellindian(J70)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G70=\"\",J70=\"\"),\"\",RANK(R70,$R$16:$R$80)+COUNTIF($R$16:R70,R70)-1)","v":""},{"$f":"INDEX(P70:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A56))=0,0,IF(INDEX(Theory_marks,ROW(A56))=\"\",\"\",INDEX(Theory_marks,ROW(A56))))","v":""},{"$f":"IF(G71=\"\",\"\",IF(G71=0,\"ABSENT/WITHDRAWN\",Spellindian(G71)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A56))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A56))=0,0,INDEX(Practical_marks,ROW(A56))))","v":""},{"$f":"IF(J71=\"\",\"\",IF(J71=0,\"ABSENT/WITHDRAWN\",Spellindian(J71)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G71=\"\",J71=\"\"),\"\",RANK(R71,$R$16:$R$80)+COUNTIF($R$16:R71,R71)-1)","v":""},{"$f":"INDEX(P71:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A57))=0,0,IF(INDEX(Theory_marks,ROW(A57))=\"\",\"\",INDEX(Theory_marks,ROW(A57))))","v":""},{"$f":"IF(G72=\"\",\"\",IF(G72=0,\"ABSENT/WITHDRAWN\",Spellindian(G72)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A57))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A57))=0,0,INDEX(Practical_marks,ROW(A57))))","v":""},{"$f":"IF(J72=\"\",\"\",IF(J72=0,\"ABSENT/WITHDRAWN\",Spellindian(J72)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G72=\"\",J72=\"\"),\"\",RANK(R72,$R$16:$R$80)+COUNTIF($R$16:R72,R72)-1)","v":""},{"$f":"INDEX(P72:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A58))=0,0,IF(INDEX(Theory_marks,ROW(A58))=\"\",\"\",INDEX(Theory_marks,ROW(A58))))","v":""},{"$f":"IF(G73=\"\",\"\",IF(G73=0,\"ABSENT/WITHDRAWN\",Spellindian(G73)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A58))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A58))=0,0,INDEX(Practical_marks,ROW(A58))))","v":""},{"$f":"IF(J73=\"\",\"\",IF(J73=0,\"ABSENT/WITHDRAWN\",Spellindian(J73)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G73=\"\",J73=\"\"),\"\",RANK(R73,$R$16:$R$80)+COUNTIF($R$16:R73,R73)-1)","v":""},{"$f":"INDEX(P73:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A59))=0,0,IF(INDEX(Theory_marks,ROW(A59))=\"\",\"\",INDEX(Theory_marks,ROW(A59))))","v":""},{"$f":"IF(G74=\"\",\"\",IF(G74=0,\"ABSENT/WITHDRAWN\",Spellindian(G74)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A59))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A59))=0,0,INDEX(Practical_marks,ROW(A59))))","v":""},{"$f":"IF(J74=\"\",\"\",IF(J74=0,\"ABSENT/WITHDRAWN\",Spellindian(J74)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G74=\"\",J74=\"\"),\"\",RANK(R74,$R$16:$R$80)+COUNTIF($R$16:R74,R74)-1)","v":""},{"$f":"INDEX(P74:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A60))=0,0,IF(INDEX(Theory_marks,ROW(A60))=\"\",\"\",INDEX(Theory_marks,ROW(A60))))","v":""},{"$f":"IF(G75=\"\",\"\",IF(G75=0,\"ABSENT/WITHDRAWN\",Spellindian(G75)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A60))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A60))=0,0,INDEX(Practical_marks,ROW(A60))))","v":""},{"$f":"IF(J75=\"\",\"\",IF(J75=0,\"ABSENT/WITHDRAWN\",Spellindian(J75)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G75=\"\",J75=\"\"),\"\",RANK(R75,$R$16:$R$80)+COUNTIF($R$16:R75,R75)-1)","v":""},{"$f":"INDEX(P75:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A61))=0,0,IF(INDEX(Theory_marks,ROW(A61))=\"\",\"\",INDEX(Theory_marks,ROW(A61))))","v":""},{"$f":"IF(G76=\"\",\"\",IF(G76=0,\"ABSENT/WITHDRAWN\",Spellindian(G76)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A61))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A61))=0,0,INDEX(Practical_marks,ROW(A61))))","v":""},{"$f":"IF(J76=\"\",\"\",IF(J76=0,\"ABSENT/WITHDRAWN\",Spellindian(J76)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G76=\"\",J76=\"\"),\"\",RANK(R76,$R$16:$R$80)+COUNTIF($R$16:R76,R76)-1)","v":""},{"$f":"INDEX(P76:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A62))=0,0,IF(INDEX(Theory_marks,ROW(A62))=\"\",\"\",INDEX(Theory_marks,ROW(A62))))","v":""},{"$f":"IF(G77=\"\",\"\",IF(G77=0,\"ABSENT/WITHDRAWN\",Spellindian(G77)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A62))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A62))=0,0,INDEX(Practical_marks,ROW(A62))))","v":""},{"$f":"IF(J77=\"\",\"\",IF(J77=0,\"ABSENT/WITHDRAWN\",Spellindian(J77)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G77=\"\",J77=\"\"),\"\",RANK(R77,$R$16:$R$80)+COUNTIF($R$16:R77,R77)-1)","v":""},{"$f":"INDEX(P77:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A63))=0,0,IF(INDEX(Theory_marks,ROW(A63))=\"\",\"\",INDEX(Theory_marks,ROW(A63))))","v":""},{"$f":"IF(G78=\"\",\"\",IF(G78=0,\"ABSENT/WITHDRAWN\",Spellindian(G78)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A63))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A63))=0,0,INDEX(Practical_marks,ROW(A63))))","v":""},{"$f":"IF(J78=\"\",\"\",IF(J78=0,\"ABSENT/WITHDRAWN\",Spellindian(J78)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G78=\"\",J78=\"\"),\"\",RANK(R78,$R$16:$R$80)+COUNTIF($R$16:R78,R78)-1)","v":""},{"$f":"INDEX(P78:P100,$P$15)","v":""}]
[null,null,"","",null,"",{"$f":"IF(INDEX(Theory_marks,ROW(A64))=0,0,IF(INDEX(Theory_marks,ROW(A64))=\"\",\"\",INDEX(Theory_marks,ROW(A64))))","v":""},{"$f":"IF(G79=\"\",\"\",IF(G79=0,\"ABSENT/WITHDRAWN\",Spellindian(G79)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A64))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A64))=0,0,INDEX(Practical_marks,ROW(A64))))","v":""},{"$f":"IF(J79=\"\",\"\",IF(J79=0,\"ABSENT/WITHDRAWN\",Spellindian(J79)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G79=\"\",J79=\"\"),\"\",RANK(R79,$R$16:$R$80)+COUNTIF($R$16:R79,R79)-1)","v":""},{"$f":"INDEX(P79:P100,$P$15)","v":""}]
[null,null,{"$f":"INDEX(S.No.,ROW(A65))","v":""},{"$f":"IF(INDEX(Student_name,ROW(A65))=\"\",\"\",INDEX(Student_name,ROW(A65)))","v":""},null,{"$f":"IF(D80=\"\",\"\",IF(INDEX(Admn_no.,ROW(A65))=\"\",\"\",INDEX(Admn_no.,ROW(A65))))","v":""},{"$f":"IF(INDEX(Theory_marks,ROW(A65))=0,0,IF(INDEX(Theory_marks,ROW(A65))=\"\",\"\",INDEX(Theory_marks,ROW(A65))))","v":""},{"$f":"IF(G80=\"\",\"\",IF(G80=0,\"ABSENT/WITHDRAWN\",Spellindian(G80)))","v":""},null,{"$f":"IF(INDEX(Practical_marks,ROW(A65))=\"\",\"\",IF(INDEX(Practical_marks,ROW(A65))=0,0,INDEX(Practical_marks,ROW(A65))))","v":""},{"$f":"IF(J80=\"\",\"\",IF(J80=0,\"ABSENT/WITHDRAWN\",Spellindian(J80)))","v":""},null,null,null,null,"",{"$f":"IF(AND(G80=\"\",J80=\"\"),\"\",RANK(R80,$R$16:$R$80)+COUNTIF($R$16:R80,R80)-1)","v":""},{"$f":"INDEX(P80:P100,$P$15)","v":""}]
[null,null,"NOTE: Submit results within 5 days of examination."]
[null,null,1,null,"All corrections and cuttings be initialized."]
[null,null,"CERTIFICATE"]
[null,null,null,"Certified that: "]
[null,null,"i) students mentioned above except student at Sr. No. ____________ have completed attendance requirement as per "]
[null,null,"Academic Regulation No. 4.1.1 "]
[null,null,"ii) all the students mentioned above except student at Sr. No.______________ appeared in the examination as per "]
[null,null,"Academic Regulation No. 8.9.7. Absent student (s) has/ have been awarded ‘Zero’."]
[null,null,1]
[null,null,1]
[null,null,1]
[null,null,"Signature of Course Instructor (with date)",null,null,null,null,null,null,"Head of Department (with date) "]
[null,null,"a"]
[null,null,"a"]
[null,null,"a",null,null,null,null,"Dean (with date)"]