{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Academic Workload","Research Supervision","Academic Coordination","Teaching Workload Weights","R & D Workload Weight","Uni & National Dev Workload ","Report","Lookup","Table2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Academic Workload","index":0,"n_rows":37,"n_cols":29,"rows_kept":37,"cut":false,"hidden":false,"merged":[[22,0,22,1],[23,0,23,1],[16,0,16,1],[22,3,22,4],[23,3,23,4],[21,3,21,4],[19,0,19,1],[21,0,21,1],[20,0,20,1],[6,2,6,4],[3,7,3,13],[4,3,4,6],[5,3,5,10],[15,0,15,1],[14,3,14,4],[15,3,15,4],[14,0,14,1],[0,0,0,28],[1,0,1,28],[2,0,2,28],[12,28,13,28],[10,0,10,28],[11,5,11,9],[11,10,11,14],[11,15,11,19],[11,20,11,24],[11,0,11,1],[11,3,11,4],[12,0,13,1],[12,2,13,2],[12,3,13,4],[9,0,9,28],[12,27,13,27],[24,0,24,1],[25,0,25,1],[28,3,28,4],[16,3,16,4],[27,3,27,4],[17,0,17,1],[24,3,24,4],[25,3,25,4],[26,3,26,4],[18,0,18,1],[26,0,26,1],[27,0,27,1],[17,3,17,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[29,15,30,15],[29,16,30,16],[28,0,28,1],[29,14,30,14],[29,5,30,5],[29,6,30,6],[29,7,30,7],[29,11,30,11],[29,12,30,12],[29,9,30,9],[29,10,30,10],[29,0,30,4],[29,27,30,27],[29,28,30,28],[29,24,30,24],[29,17,30,17],[29,19,30,19],[29,20,30,20],[29,21,30,21],[29,22,30,22],[29,26,30,26],[29,25,30,25]]}
["University of Moratuwa"]
["ACADEMIC STAFF WORK LOAD REPORTING FORM"]
[]
["Title and Name of Academic Staff Member:",null,null,null,null,null,null,"Dr. ABC Perera"]
["Designation:",null,null,"Senior Lecturer Gr II"]
["Department:",null,null,"Architecture"]
["Year:",null,2017]
[null,null,null,null,null,null,null,null,null,null,null,null,"Faculty of Architecture:"]
[]
["Academic workload"]
["Academic Instruction "]
[1,null,2,3,null,"Lecture",null,null,null,null,"Tutorial",null,null,null,null,"Labs",null,null,null,null,"Field Work/Projects/CDP/ Dissertation",null,null,null,null,"Research Supervision","Academic  cordination",22,23]
["Module Code",null,"Total Credit Value","Intake & Semester",null,4,5,6,7,"A",8,9,10,11,"B",12,13,14,15,"C",16,17,18,19,"D",20,21,"Total Student Contact Hrs (5+9+13+17+20+21)","Total Student Credits (A+B+C+D)"]
[null,null,null,null,null,"Proportional contribution (PC)","Assigned student contact hours","Number of students","Credit  Value (CW)","Student Credits (Formula 1)","Proportional contribution (PC)","Assigned student contact hours","Number of students","Credit  Value (CW)","Student Credits (Formula 1)","Proportional contribution (PC)","Assigned student contact hours","Number of students","Credit  Value (CW)","Student Credits (Formula 2)","Proportional contribution (PC)","Assigned student contact hours","Number of students","Credit  Value (CW)","Student Credits (Formula 2)","Total Cordination Hrs","Total Contact Hrs"]
["XY1022",null,2,"2009, S1",null,0.75,18,45,2,{"$f":"Lookup!E4 * VLOOKUP(H15, Lookup!A4:B29, 2)* I15 * F15","v":75},null,null,null,null,{"$f":"Lookup!E4 * VLOOKUP(M15, Lookup!A4:B29, 2)* N15 * K15","v":0},null,null,null,null,{"$f":"R15*S15 *P15","v":0},null,null,null,null,{"$f":"W15*X15*U15","v":0},null,null,{"$f":"SUM(G15,L15,Q15,V15,AA15)","v":18},{"$f":"SUM(J15,O15,T15,Y15)","v":75}]
["XY3042",null,2,"2006,L3S1",null,1,22,90,2,{"$f":"Lookup!E4 * VLOOKUP(H16,Lookup!A4:B29, 2)* I16 * F16","v":140},null,null,null,null,{"$f":"Lookup!E4 * VLOOKUP(M16, Lookup!A4:B29, 2)* N16 * K16","v":0},null,null,null,null,{"$f":"R16*S16 *P16","v":0},null,null,null,null,{"$f":"W16*X16*U16","v":0},null,null,{"$f":"SUM(G16,L16,Q16,V16,AA16)","v":22},140]
[null,null,null,null,null,null,null,null,null,{"$f":"Lookup!E4 * VLOOKUP(H17,Lookup!A4:B29, 2)* I17 * F17","v":0},null,null,null,null,{"$f":"Lookup!E4 * VLOOKUP(M17, Lookup!A4:B29, 2)* N17 * K17","v":0},null,null,null,null,0,null,null,null,null,{"$f":"W17*X17*U17","v":0},null,null,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"Lookup!E4 * VLOOKUP(H18,Lookup!A4:B29, 2)* I18 * F18","v":0},null,null,null,null,{"$f":"Lookup!E4 * VLOOKUP(M18, Lookup!A4:B29, 2)* N18 * K18","v":0},null,null,null,null,0,null,null,null,null,{"$f":"W18*X18*U18","v":0},null,null,{"$f":"SUM(G18,L18,Q18,V18,AA18)","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"Lookup!E4 * VLOOKUP(H19,Lookup!A4:B29, 2)* I19 * F19","v":0},null,null,null,null,{"$f":"Lookup!E4 * VLOOKUP(M19, Lookup!A4:B29, 2)* N19 * K19","v":0},null,null,null,null,0,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"Lookup!E4 * VLOOKUP(H20,Lookup!A4:B29, 2)* I20 * F20","v":0},null,null,null,null,{"$f":"Lookup!E4 * VLOOKUP(M20, Lookup!A4:B29, 2)* N20 * K20","v":0},null,null,null,null,0,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"Lookup!E4 * VLOOKUP(H21,Lookup!A4:B29, 2)* I21 * F21","v":0},null,null,null,null,{"$f":"Lookup!E4 * VLOOKUP(M21, Lookup!A4:B29, 2)* N21 * K21","v":0},null,null,null,null,0,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"Lookup!E4 * VLOOKUP(H22,Lookup!A4:B29, 2)* I22 * F22","v":0},null,null,null,null,{"$f":"Lookup!E4 * VLOOKUP(M22, Lookup!A4:B29, 2)* N22 * K22","v":0},null,null,null,null,0,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"Lookup!E4 * VLOOKUP(H23,Lookup!A4:B29, 2)* I23 * F23","v":0},null,null,null,null,{"$f":"Lookup!E4 * VLOOKUP(M23, Lookup!A4:B29, 2)* N23 * K23","v":0},null,null,null,null,0,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"Lookup!E4 * VLOOKUP(H24,Lookup!A4:B29, 2)* I24 * F24","v":0},null,null,null,null,{"$f":"Lookup!E4 * VLOOKUP(M24, Lookup!A4:B29, 2)* N24 * K24","v":0},null,null,null,null,0,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"Lookup!E4 * VLOOKUP(H25,Lookup!A4:B29, 2)* I25 * F25","v":0},null,null,null,null,{"$f":"Lookup!E4 * VLOOKUP(M25, Lookup!A4:B29, 2)* N25 * K25","v":0},null,null,null,null,0,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"Lookup!E4 * VLOOKUP(H26,Lookup!A4:B29, 2)* I26 * F26","v":0},null,null,null,null,{"$f":"Lookup!E4 * VLOOKUP(M26, Lookup!A4:B29, 2)* N26 * K26","v":0},null,null,null,null,0,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"Lookup!E4 * VLOOKUP(H27,Lookup!A4:B29, 2)* I27 * F27","v":0},null,null,null,null,{"$f":"Lookup!E4 * VLOOKUP(M27, Lookup!A4:B29, 2)* N27 * K27","v":0},null,null,null,null,0,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"Lookup!E4 * VLOOKUP(H28,Lookup!A4:B29, 2)* I28 * F28","v":0},null,null,null,null,{"$f":"Lookup!E4 * VLOOKUP(M28, Lookup!A4:B29, 2)* N28 * K28","v":0},null,null,null,null,0,null,null,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"Lookup!E4 * VLOOKUP(H29,Lookup!A4:B29, 2)* I29 * F29","v":0},null,null,null,null,{"$f":"Lookup!E4 * VLOOKUP(M29, Lookup!A4:B29, 2)* N29 * K29","v":0},null,null,null,null,0,null,null,null,null,0,null,null,0,0]
["Sub Totals",null,null,null,null,null,{"$f":"SUM(G15:G29)","v":40},null,null,{"$f":"SUM(J15:J29)","v":215},null,{"$f":"SUM(L15:L29)","v":0},null,null,{"$f":"SUM(O15:O29)","v":0},null,{"$f":"SUM(Q15:Q29)","v":0},null,null,{"$f":"SUM(T15:T29)","v":0},null,{"$f":"SUM(V15:V29)","v":0},null,null,{"$f":"SUM(Y15:Y29)","v":0},{"$f":"'Research Supervision'!R10","v":120},{"$f":"'Academic Coordination'!D19","v":270},{"$f":"SUM(G30,L30,Q30,V30,Z30,AA30)","v":430},215]
[]
["Note: Instructions to fill the form are available in the Dean's Office"]
[]
["……………………………………..",null,null,null,null,null,null,null,null,null,null,null,"…………………………………….."]
["Signature of the Staff member",null,null,null,null,null,null,null,null,null,null,null,"Signature of the HOD"]
["…………………………",null,null,null,null,null,null,null,null,null,null,null,"……………………….."]
["Date",null,null,null,null,null,null,null,null,null,null,null,"Date"]

{"sheet":"Research Supervision","index":1,"n_rows":16,"n_cols":18,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,18],[1,1,1,14],[1,15,1,16],[1,17,1,18],[2,1,2,14],[2,15,2,16],[2,17,2,18],[3,1,3,14],[3,15,3,16],[3,17,3,18],[4,1,4,14],[4,15,4,16],[4,17,4,18],[5,1,5,14],[5,15,5,16],[5,17,5,18],[6,1,6,14],[6,15,6,16],[6,17,6,18],[9,0,9,16],[9,17,9,18],[10,0,10,18],[7,1,7,14],[7,15,7,16],[7,17,7,18],[8,1,8,14],[8,15,8,16],[8,17,8,18]]}
["Research Supervision* "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No of Students",null,"Student Contact Hrs"]
[null,"PhD Full Time @ 90 hrs.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P3*90","v":0}]
[null,"PhD Part Time @ 45 hrs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P4*45","v":0}]
[null,"M Phil Full Time @ 90 hrs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P5*90","v":0}]
[null,"MPhil Part Time @ 45 hrs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P6*45","v":0}]
[null,"MSc/MEng Full Time @ 60 hrs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P7*60","v":0}]
[null,"Course based MSc/MEng/MBA Part Time @ 20 hrs",null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,{"$f":"P8*20","v":80}]
[null,"Research Projects which involve undergraduate students other than the Undergraduate Research Projects in the curriculum. ",null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,{"$f":"P9*20","v":40}]
["Sub Total \nResearch Supervision Student Contact Hours",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R3:S9)","v":120}]
["Research Supervision* "]
["Refer Section 2 in Academic Accountability and Workload Model  (page 4)"]
["……………………………………..",null,null,null,null,null,null,null,null,null,null,null,"…………………………………….."]
["Signature of the Staff member",null,null,null,null,null,null,null,null,null,null,null,"Signature of the HOD"]
["…………………………",null,null,null,null,null,null,null,null,null,null,null,"……………………….."]
["Date",null,null,null,null,null,null,null,null,null,null,null,"Date"]

{"sheet":"Academic Coordination","index":2,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[[17,5,32,6],[3,5,16,6],[2,5,2,6]]}
[]
[null,"Academic Coordination Hours",null,null,null,null,"Reference Table"]
[null,"No ","Type of Cordination Work","Contact Hrs",null,null,null,"Type of Coordination Work","Contact Hrs"]
[null,"1","None",{"$f":"INDEX($I$4:$I$36,MATCH(C4,$H$4:$H$36,0))","v":0},null,"Faculty Level Coordination",null,"None",0]
[null,"2","None",0,null,null,null,"--------------Faculty Level Coordination----------------",0]
[null,"3","Director Postgraduate Studies",60,null,null,null,"Director Undergraduate Studies",120]
[null,"4","None",0,null,null,null,"Director Postgraduate Studies",60]
[null,"5","Director Undergraduate Studies",120,null,null,null,"Director Quality Assurance",60]
[null,"6","None",0,null,null,null,"Director - Faculty of Architecture Research Unit",60]
[null,"7","None",0,null,null,null,"Director Industrial Training",60]
[null,"8","None",0,null,null,null,"Chairperson of Faculty Academic Committee",60]
[null,"9","None",0,null,null,null,"Chairperson -Faculty Curriculum & Evaluation",60]
[null,"10","None",0,null,null,null,"Chairperson - Media and Publicity Committee",60]
[null,"11","None",0,null,null,null,"Chairperson- Time Table Committee",60]
[null,"12","Chairperson of Faculty Academic Committee",60,null,null,null,"Chairperson- By Law Committee",60]
[null,"13","None",0,null,null,null,"Chairperson-Faculty Staff/Student Liaison Committee",60]
[null,"14","None",0,null,null,null,"Chairperson- Admission Committee",60]
[null,"15","Department Industry Consultative Board (DICB) Coordinator",30,null,"Departmental Level  Coordination",null,"----------Departmental Level  Coordination-------------",0]
[null,null,"Total Contact Hrs",{"$f":"SUM(D4:D18)","v":270},null,null,null,"Undergraduate Coordinator",30]
[null,null,null,null,null,null,null,"Level Coordinator",30]
[null,null,null,null,null,null,null,"Stream Coordinator",30]
[null,null,null,null,null,null,null,"Postgraduate Research Coordinator",30]
[null,null,null,null,null,null,null,"Dissertation Coordinator",30]
[null,null,null,null,null,null,null,"Industrial Training Coordinator",30]
[null,null,null,null,null,null,null,"Building Economics & Management Research Unit Coordinator",30]
[null,null,null,null,null,null,null,"Curriculum Evaluation & Development Unit Coordinator",30]
[null,null,null,null,null,null,null,"Quality & Accreditation Unit Coordinator",30]
[null,null,null,null,null,null,null,"Student Learning Environment Facilities Coordinator",30]
[null,null,null,null,null,null,null,"Department Student Counselor",30]
[null,null,null,null,null,null,null,"Event Coordinator ( One Event)",15]
[null,null,null,null,null,null,null,"Event Coordinator (Two or More Events)",30]
[null,null,null,null,null,null,null,"Marketing Coordinator",30]
[null,null,null,null,null,null,null,"Department Industry Consultative Board (DICB) Coordinator",30]
[null,null,null,null,null,null,null,"Senior Adviser to Interdisciplinary Activity",30]

{"sheet":"Teaching Workload Weights","index":3,"n_rows":41,"n_cols":4,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Teaching Workload Weights (Reporting of Contribution as Information)"]
[]
[null,"Description of Activity","Relevant Number ","Remarks (shared etc)"]
[1,"Teaching (theory) a new subject/course (hours)"]
[2," Teaching a subject with  revision (hours)"]
[3,"Teaching a subject with multiple offerings or parallel offerings (hours)"]
[4,"Teaching a subject that runs, mostly as seminars (hours)"]
[5,"Teaching a subject in an undergraduate program (hours)"]
[6,"Coordinating a subject - less than 50 students 50-100 students, 100-200 students, more than 200 students etc. (number)"]
[7,"Conducting tutorials/practical (lab or field), design classes, demonstrations, clinical teaching, discussions, training visits (hours)"]
[8," Preparation, marking and consultation of tutorials (hours)"]
[9,"Preparation, marking and consultation of practicals, clinicals, field work, design classes (hours)"]
[10,"Preparation of lecture material including electronic course material (hours)"]
[11,"Setting/Moderation of assignments and examinations and other assessment material (hours)"]
[12,"Translation of examination papers (number)"]
[13,"Marking answer scripts and submissions for practical /clinical /field work examinations and design reports (number)"]
[14,"Assessment of student presentations, viva exams (number)"]
[15,"Supervision of undergraduate projects (number)"]
[16,"Assessment of undergraduate projects as a supervisor or examiner (number)"]
[17," Number of offerings of the same course by the same teacher (number)"]
[18," Number of hours spent on preparation for a 1 hour theory or tutorial class ( 3 hours )"]
[19,"Time period spent on setting an exam paper for a 1 credit unit course (3 hours)"]
[20,"Number of students following a given course/ number of students examined by the teacher"]
[21,"Number of questions marked by the teacher"]
[22,"Time spent on translation of question paper of 1 credit unit ( 1 hour)"]
[23,"Number of tutorials per course unit"]
[24,"Number of students following the course with tutorials"]
[25,"Number of hours spent on preparation of practicals etc. ( 5 hour /2 hour practical class)"]
[26,"Number of practicals etc. per course"]
[27,"Time period spent on setting a practical/clinical/field work/ design examination (3 hours}"]
[28,"Number of groups in such examinations"]
[29,"Time spent on grading a practical/clinical/field work/design examination ( l/2 hour per student )"]
[30,"Number of students in such examinations as above"]
[31,"Number of such examinations as above in a course"]
[32," Time spent on supervision of group projects (1 hour/project/week)"]
[33,"Number of such group projects in a course"]
[34,"Time spent on correcting such group projects report of undergraduate student (2 hours/ student/week)"]
[35,"Number of such project reports collected"]
[36," Time spent on computation/ moderation of course results (5 hour/50 students/course)"]
[37,"Number of students in a course for which results have to be computed/moderated"]
[38,"Organizing/ conducting guest lectures/workshops"]

{"sheet":"R & D Workload Weight","index":4,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Research & Development Workload Weights (Reporting of Contribution as Information)"]
[]
[null,"Description of Activity","Relevant Number","Remarks "]
[1,"Research grants received - number of grants received, grant values, grant duration, nature of donor (national/international), number of research students/research assistants working under the project (numbers)"]
[2,"Member of research consultants team (number)"]
[3,"Research publications - refereed journals, non-refereed journals, extended abstracts, abstracts (numbers)"]
[4,"Dissemination of research output - patents, products, innovations (numbers)"]
[5,"Editor, associate editor, member of the editorial board of reputed journals and proceedings (numbers)"]
[6,"Editing of collection of essays or books (numbers)"]
[7,"Organization of research symposia, conferences, workshops etc. (number)"]
[8,"Supervision of research (M Phil, PhD) - full time - 90 hours/project, part time – 30 hours/project"]
[9,"Coordinator of research programs (hours)"]
[10,"Reviewer of research proposals and articles for publication (number)"]
[11,"Member of multidisciplinary research team "]
[12,"Member of team of Institutional Linkages "]
[13,"Member of projects of national relevance"]
[14,"Author of books or chapters in books (international/national publisher)"]
[15,"Author of monographs"]
[16,"Author of policy papers"]
[17,"Author of consultancy reports"]
[18,"Software development"]
[19,"Media projects and products"]
[20,"Translation and publication of books and scholarly work"]
[21," Peer reviewed presentations at national /international conferences"]

{"sheet":"Uni & National Dev Workload ","index":5,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["University and National Development Workload Weights (Reporting of Contribution as Information)"]
[]
[null,"Description of Activity","Relevant Numbers","Remarks "]
[1,"Development of new courses and degree programs (numbers)"]
[2,"Resource person at curriculum development workshops and training programs (numbers)"]
["c)","Contribution to infrastructural development at Department, Faculty, University"]
["d)","Active engagement in Departmental meetings, Faculty Boards, Senate/Faculty sub-committees"]
["e)","Contribution to student advisory board, disciplinary inquiry boards"]
["f)","Senior treasurer of student societies"]
["g)","Serving as the Vice Chancellor, Deputy Vice Chancellor, Directors of Institutes, Deans, Heads of Department"]
["h)","Serving as Directors of University Centers"]
["i)","Serving in any position of administrative support such as Proctor/Deputy Proctor/Chief student counselor/Student counselor/Warden/Sub warden"]
["j)","Serving as Coordinators of Faculty/University Units"]
["k)","Memberships of Boards of Study"]
["l)","Serving as Coordinators of international/national conferences/congresses"]
["m)","Serving as Advisors of national development projects"]
["n)","Serving as Country representatives of regional/international bodies"]
["o)","Serving in any Office of professional bodies /societies"]
["p)","Serving as Members of formalized links in outreach activities with private organizations"]
["q)","Contribution to staff development"]
["r)","Contribution to personal and professional development"]
["s)","Contribution to advancement of the profession"]

{"sheet":"Report","index":6,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Academic Workload Report"]
[null,"Academic Accountability & Workload"]
[null,"Faculty of Architecture"]
[]
[null,"Name :",{"$f":"'Academic Workload'!H4","v":"Dr. ABC Perera"}]
[null,"Designation :",{"$f":"'Academic Workload'!D5","v":"Senior Lecturer Gr II"}]
[null,"Department :",{"$f":"'Academic Workload'!D6","v":"Architecture"}]
[]
[null,"Total Student Contact Hrs :",{"$f":"'Academic Workload'!AB30","v":430}]
[]
[null,"Total Student Credits :",{"$f":"'Academic Workload'!AC30","v":215}]

{"sheet":"Lookup","index":7,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Class size","AF"]
[0,0.5,null,"SCb = ",50]
[15,0.6]
[25,0.7]
[35,0.8]
[40,0.9]
[45,1]
[55,1.1000000000000001]
[65,1.2]
[75,1.3]
[85,1.4]
[95,1.5]
[105,1.6]
[115,1.7]
[125,1.8]
[135,1.9]
[145,2]
[155,2.1]
[165,2.2000000000000002]
[175,2.2999999999999998]
[185,2.4]
[195,2.5]
[205,2.6]
[215,2.7]
[225,2.8]
[235,2.9]
[250,3]
[]
["usage",{"$f":"VLOOKUP(260, A4:B29,2)","v":3}]

{"sheet":"Table2","index":8,"n_rows":33,"n_cols":18,"rows_kept":33,"cut":false,"hidden":true,"merged":[[17,0,17,16],[17,17,17,18],[18,0,18,18],[19,0,19,3],[19,4,20,6],[19,7,20,9],[19,10,19,16],[19,17,20,18],[20,0,20,3],[20,10,20,16],[21,0,22,3],[21,4,22,6],[21,7,22,9],[21,10,22,16],[21,17,22,18],[16,6,16,16],[13,17,13,18],[14,17,14,18],[13,1,13,5],[14,1,14,5],[13,6,13,16],[14,6,14,16],[15,17,15,18],[16,17,16,18],[15,1,15,5],[16,1,16,5],[15,6,15,16],[9,0,9,16],[9,17,9,18],[10,0,10,18],[11,0,11,18],[12,17,12,18],[12,1,12,5],[12,6,12,16],[7,1,7,14],[7,15,7,16],[7,17,7,18],[8,1,8,14],[8,15,8,16],[8,17,8,18],[5,1,5,14],[5,15,5,16],[5,17,5,18],[6,1,6,14],[6,15,6,16],[6,17,6,18],[3,1,3,14],[3,15,3,16],[3,17,3,18],[4,1,4,14],[4,15,4,16],[4,17,4,18],[0,0,0,18],[1,1,1,14],[1,15,1,16],[1,17,1,18],[2,1,2,14],[2,15,2,16],[2,17,2,18]]}
["Research Supervision "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No of Students",null,"Student Contact Hrs"]
[null,"PhD Full Time @ 90 hrs."]
[null,"PhD Part Time @ 45 hrs"]
[null,"M Phil Full Time @ 90 hrs"]
[null,"MPhil Part Time @ 45 hrs"]
[null,"MSc/MEng Full Time @ 60 hrs"]
[null,"Course based MSc/MEng/MBA Part Time @ 20 hrs",null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,80]
[null,"Research Projects which involve undergraduate students other than the Undergraduate Research Projects in the curriculum. (10 per student/20 hrs max)  ",null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,20]
["Sub Total \nResearch Supervision Student Contact Hours",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R3:S9)","v":100}]
[]
["Academic Co-ordination "]
[null,null,null,null,null,null,"Description",null,null,null,null,null,null,null,null,null,null,"Student Contact Hrs"]
[null,"Faculty(Degree Program) Coordination"]
[null,"Level/Academic Coordination",null,null,null,null,"Personal mentor/advisor L1",null,null,null,null,null,null,null,null,null,null,30]
[null,"Academic Subject Coordination"]
[null,"Academic Event Coordination",null,null,null,null,"Techno + Dept Exhibitions ",null,null,null,null,null,null,null,null,null,null,10]
["Sub Total \nAcademic Coordination Student Contact Hours",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R14:S17)","v":40}]
[]
["TOTAL ",null,null,null,"Norm as per Designation",null,null,360,null,null,"Hrs ",null,null,null,null,null,null,{"$f":"SUM('Academic Workload'!AB30:AB31, Table2!R10:S10,Table2!R18:S18)","v":570}]
["Student Contact Hours",null,null,null,null,null,null,null,null,null,"Declared"]
["Student Credits ",null,null,null,"Norm as stipulated",null,null,375,null,null,"Credits Declared",null,null,null,null,null,null,{"$f":"SUM('Academic Workload'!AC30:AC31)","v":215}]
[]
[]
[]
[]
["……………………………………..",null,null,null,null,null,null,null,null,null,null,null,"…………………………………….."]
["Signature of the Staff member",null,null,null,null,null,null,null,null,null,null,null,"Signature of the HOD"]
[]
[]
["Date: ………………………….",null,null,null,null,null,null,null,null,null,null,null,"Date: …………………………."]
[]
["Note: Instructions to fill the form are avaialable in the Dean's Office"]