{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Impact","Productivity","Leadership","Teaching","Community Service"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":3,"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":"Impact","index":0,"n_rows":49,"n_cols":13,"rows_kept":49,"cut":false,"hidden":false,"merged":[[3,1,3,5],[4,1,4,5],[6,0,6,1]]}
[]
["Distinguished University Professorship (DUP) Award - Application Form",null,null,null,null,null,null,null,null,null,null,"Points"]
[null,null,null,null,null,null,null,"A. Research Quality and Impact",null,null,null,{"$f":"(F23+F38+F46+F49)","v":32.666666666666671},"min. 400 points"]
["Name:",null,null,null,null,null,null,"B. Research Productivity ",null,null,null,{"$f":"(Productivity!F18+Productivity!F33+Productivity!F48+Productivity!F63)","v":37.75}]
["Department:",null,null,null,null,null,null,"C. Research Leadership ",null,null,null,{"$f":"MIN(Leadership!F18+Leadership!F33+Leadership!F41+Leadership!F69,0.5*L4)","v":18.875}]
[null,null,null,null,null,null,null,"D. Teaching Excellence",null,null,null,{"$f":"Teaching!F32","v":96.25},"min. 100 points"]
["Note: To add any row Just make double click on any cell in the row",null,null,null,null,null,null,"E. University and Community Service ",null,null,null,{"$f":"'Community Service'!F59","v":28},"min. 50 points"]
[null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(L3:L5)","v":89.291666666666671}]
["A. Research Quality and Impact"]
["Publications in ISI/Scopus-indexed journals (only Q1 and Q2)"]
["JN","Paper Title with Journal Name","Quartile (Q)","No. Au","1st/Corr","Points"]
[1,"XXX",1,3,"y",{"$f":"IF(D12=1,IFERROR((IF(C12=1,10,8))/D12,0),IFERROR((IF(C12=1,10,8))/D12,0)+IF(E12=\"Y\",0.25,0))","v":3.5833333333333335},"SAMPLE"]
[2,"XXX",2,2,"N",{"$f":"IF(D13=1,IFERROR((IF(C13=1,10,8))/D13,0),IFERROR((IF(C13=1,10,8))/D13,0)+IF(E13=\"Y\",0.25,0))","v":4},"SAMPLE"]
[3,null,null,null,null,0]
[4,null,null,null,null,0]
[5,null,null,null,null,0]
[6,null,null,null,null,0]
[7,null,null,null,null,0]
[8,null,null,null,null,0]
[9,null,null,null,null,0]
[10,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,"Total",{"$f":"SUM(F12:F22)","v":7.5833333333333339}]
[]
["Publications in flagship conferences (only A* and A)"]
["CN","Paper Title with Conference Name",null,"No. Au","1st","Points"]
[1,"XXX",null,3,"Y",{"$f":"IF(D27=1,IFERROR(3/D27,0),IFERROR(3/D27,0)+IF(E27=\"Y\",0.25,0))","v":1.25},"SAMPLE"]
[2,"XXX",null,2,"N",{"$f":"IF(D28=1,IFERROR(3/D28,0),IFERROR(3/D28,0)+IF(E28=\"Y\",0.25,0))","v":1.5},"SAMPLE"]
[3,null,null,null,null,0]
[4,null,null,null,null,0]
[5,null,null,null,null,0]
[6,null,null,null,null,0]
[7,null,null,null,null,0]
[8,null,null,null,null,0]
[9,null,null,null,null,0]
[10,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,"Total",{"$f":"SUM(F27:F37)","v":2.75}]
[]
["Citations ","[Scopus: All work over the last 8 years but only counting citations in the last 4 years]"]
["Year","Citations (excluding self-citation) ",null,null,null,"Points"]
[2020,25,null,null,null,{"$f":"B42*0.5","v":12.5}]
[2019,17,null,null,null,{"$f":"B43*0.5","v":8.5}]
[2018,6,null,null,null,3]
[2017,2,null,null,null,1]
[null,null,null,null,"Total",{"$f":"MIN(SUM(F42:F45),F23+F38)","v":10.333333333333334}]
[]
["h5-index",null,null,null,"Points","Points"]
["Number of articles cited at least h times over the last 5 years (from Scopus)",null,null,null,12,{"$f":"E49","v":12}]

{"sheet":"Productivity","index":1,"n_rows":63,"n_cols":7,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
[]
["Distinguished University Professorship (DUP) Award - Application Form"]
[]
["B. Research Productivity "]
["Research-Oriented Books or Volumes",null,"A: Authored, E: Edited, C: Book chapter"]
["BN","Book or Chapter Title with publisher","Auth, Ed, Ch.","No. Au","1st","Points"]
[1,"XXX","A",1,"Y",{"$f":"IF(D7=1,IFERROR(IF(C7=\"A\",15,IF(C7=\"E\",10,5))/D7,0),IFERROR(IF(C7=\"A\",15,IF(C7=\"E\",10,5))/D7,0)+IF(AND(C7=\"A\",E7=\"Y\"),1,0))","v":15},"SAMPLE"]
[2,"XXX","E",2,"N",{"$f":"IF(D8=1,IFERROR(IF(C8=\"A\",15,IF(C8=\"E\",10,5))/D8,0),IFERROR(IF(C8=\"A\",15,IF(C8=\"E\",10,5))/D8,0)+IF(AND(C8=\"A\",E8=\"Y\"),1,0))","v":5},"SAMPLE"]
[3,"XXX","C",1,null,5,"SAMPLE"]
[4,null,null,null,null,0]
[5,null,null,null,null,0]
[6,null,null,null,null,0]
[7,null,null,null,null,0]
[8,null,null,null,null,0]
[9,null,null,null,null,0]
[10,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,"Total",{"$f":"SUM(F7:F17)","v":25}]
[]
["Other Publications in ISI/Scopus-indexed journals (NOT Q1/Q2)"]
["JN","Paper Title with Journal Name",null,"No. Au","1st/Corr","Points"]
[1,"XXX",null,1,"y",{"$f":"IF(D22=1,IFERROR(5/D22,0),IFERROR(5/D22,0)+IF(E22=\"Y\",0.25,0))","v":5},"SAMPLE"]
[2,"XXX",null,2,"N",{"$f":"IF(D23=1,IFERROR(5/D23,0),IFERROR(5/D23,0)+IF(E23=\"Y\",0.25,0))","v":2.5},"SAMPLE"]
[3,null,null,null,null,0]
[4,null,null,null,null,0]
[5,null,null,null,null,0]
[6,null,null,null,null,0]
[7,null,null,null,null,0]
[8,null,null,null,null,0]
[9,null,null,null,null,0]
[10,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,"Total",{"$f":"SUM(F22:F32)","v":7.5}]
[]
["Other Publications in conferences (NOT Flagship)"]
["CN","Paper Title with Conference Name",null,"No. Au","1st","Points"]
[1,"XXX",null,3,"Y",{"$f":"IFERROR(1/D37,0)+IF(E37=\"Y\",0.25,0)","v":0.58333333333333326},"SAMPLE"]
[2,"XXX",null,2,"N",{"$f":"IFERROR(1/D38,0)+IF(E38=\"Y\",0.25,0)","v":0.5},"SAMPLE"]
[3,null,null,null,null,0]
[4,null,null,null,null,0]
[5,null,null,null,null,0]
[6,null,null,null,null,0]
[7,null,null,null,null,0]
[8,null,null,null,null,0]
[9,null,null,null,null,0]
[10,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,"Total",{"$f":"SUM(F37:F47)","v":1.0833333333333333}]
[]
["Patents"]
["PN","Patent Title and Number",null,null,"No. Inv","Points"]
[1,"XXX",null,null,3,{"$f":"IFERROR(5/E52,0)","v":1.6666666666666667},"SAMPLE"]
[2,"XXX",null,null,2,{"$f":"IFERROR(5/E53,0)","v":2.5},"SAMPLE"]
[3,null,null,null,null,0]
[4,null,null,null,null,0]
[5,null,null,null,null,0]
[6,null,null,null,null,0]
[7,null,null,null,null,0]
[8,null,null,null,null,0]
[9,null,null,null,null,0]
[10,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,"Total",{"$f":"SUM(F52:F62)","v":4.166666666666667}]

{"sheet":"Leadership","index":2,"n_rows":69,"n_cols":7,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
[]
["Distinguished University Professorship (DUP) Award - Application Form"]
[]
["C. Research Leadership "]
["External Funded Research Projects (completed)",null,null,null,"P: Principle Investigator C: Co-Investigator"]
["SN","Project Title",null,null,"Role","Points"]
[1,"XXX",null,null,"P",{"$f":"IF(E7=\"P\",6,IF(E7=\"C\",5,0))","v":6},"SAMPLE"]
[{"$f":"A7+1","v":2},"XXX",null,null,"C",{"$f":"IF(E8=\"P\",6,IF(E8=\"C\",5,0))","v":5},"SAMPLE"]
[{"$f":"A8+1","v":3},null,null,null,null,{"$f":"IF(E9=\"P\",6,IF(E9=\"C\",5,0))","v":0}]
[{"$f":"A9+1","v":4},null,null,null,null,0]
[{"$f":"A10+1","v":5},null,null,null,null,0]
[6,null,null,null,null,0]
[7,null,null,null,null,0]
[8,null,null,null,null,0]
[9,null,null,null,null,0]
[10,null,null,null,null,0]
[11,null,null,null,null,0]
[null,null,null,null,null,{"$f":"SUM(F7:F17)","v":11}]
[]
["Internal Funded Research Projects (completed)",null,null,null,"P: Principle Investigator C: Co-Investigator"]
["SN","Project Title",null,null,"Role","Points"]
[1,"XXX",null,null,"P",{"$f":"IF(E22=\"P\",4,IF(E22=\"C\",3,0))","v":4},"SAMPLE"]
[{"$f":"A22+1","v":2},"XXX",null,null,"C",{"$f":"IF(E23=\"P\",4,IF(E23=\"C\",3,0))","v":3},"SAMPLE"]
[{"$f":"A23+1","v":3},null,null,null,null,{"$f":"IF(E24=\"P\",4,IF(E24=\"C\",3,0))","v":0}]
[{"$f":"A24+1","v":4},null,null,null,null,0]
[{"$f":"A25+1","v":5},null,null,null,null,0]
[6,null,null,null,null,0]
[7,null,null,null,null,0]
[8,null,null,null,null,0]
[9,null,null,null,null,0]
[10,null,null,null,null,0]
[11,null,null,null,null,0]
[null,null,null,null,"Total",{"$f":"SUM(F22:F32)","v":7}]
[]
["Completed MS Thesis and PhD Dissertations",null,null,null,"P: PhD , M: MS Thesis , C: Committee Member"]
["SN","Thesis Title ",null,null,"PhD/MS","Points"]
[1,"XXX",null,null,"P",{"$f":"IF(E37=\"P\",4,IF(E37=\"M\",2,IF(E37=\"C\",1,0)))","v":4},"SAMPLE"]
[{"$f":"A37+1","v":2},"XXX",null,null,"M",{"$f":"IF(E38=\"P\",4,IF(E38=\"M\",2,IF(E38=\"C\",1,0)))","v":2},"SAMPLE"]
[{"$f":"A38+1","v":3},"XXX",null,null,"C",1,"SAMPLE"]
[{"$f":"A39+1","v":4},null,null,null,null,{"$f":"IF(E40=\"P\",4,IF(E40=\"M\",2,IF(E40=\"C\",1,0)))","v":0}]
[null,null,null,null,"Total",{"$f":"SUM(F37:F40)","v":7}]
[]
["Overall Leadership and Recognition in Research "]
["SN","Activity",null,null,null,"Points"]
["4.a","Membership in editorial board of international journals",null,null,2]
[null,"Member in .. ",null,null,null,{"$f":"IF(ISTEXT(B46),1*$E$45,0)","v":2},"SAMPLE"]
[null,null,null,null,null,{"$f":"IF(ISTEXT(B47),1*$E$45,0)","v":0}]
[null,null,null,null,null,0]
["4.b","Keynote speech invited or delivered",null,null,5]
[null,"Keynote in .. ",null,null,null,{"$f":"IF(ISTEXT(B50),1*$E$49,0)","v":5},"SAMPLE"]
[null,null,null,null,null,{"$f":"IF(ISTEXT(B51),1*$E$49,0)","v":0}]
[null,null,null,null,null,0]
["4.c","Membership in technical or scientific committee of international symposia or conferences",null,null,2]
[null,"Member in ..",null,null,null,{"$f":"IF(ISTEXT(B54),1*$E$53,0)","v":2},"SAMPLE"]
[null,null,null,null,null,{"$f":"IF(ISTEXT(B55),1*$E$53,0)","v":0}]
[null,null,null,null,null,0]
["4.d","Organizing international conference, symposium or workshop",null,null,5]
[null,"Organizing ..",null,null,null,{"$f":"IF(ISTEXT(B58),1*$E$57,0)","v":5},"SAMPLE"]
[null,null,null,null,null,{"$f":"IF(ISTEXT(B59),1*$E$57,0)","v":0}]
[null,null,null,null,null,0]
["4.d","Organizing nationa/local conference, symposium and workshop ",null,null,2]
[null,"Organizing ..",null,null,null,{"$f":"IF(ISTEXT(B62),1*$E$61,0)","v":2},"SAMPLE"]
[null,null,null,null,null,{"$f":"IF(ISTEXT(B63),1*$E$61,0)","v":0}]
[null,null,null,null,null,0]
["4.e","Development of a research laboratory at KFUPM",null,null,5]
[null,"Developing .. ",null,null,null,{"$f":"IF(ISTEXT(B66),1*$E$65,0)","v":5},"SAMPLE"]
[null,null,null,null,null,{"$f":"IF(ISTEXT(B67),1*$E$65,0)","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,"Total",{"$f":"SUM(F45:F68)","v":21}]

{"sheet":"Teaching","index":3,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
["Distinguished University Professorship (DUP) Award - Application Form"]
[]
["Teaching Excellence "]
["SN","Activity",null,null,null,"Points"]
[1,"Supervision of an undergraduate senior project (regardless of the number ‎of students in the team performing the project)‎",null,null,0.25]
[null,"Total number of projects ",null,null,10,{"$f":"E6*E7","v":2.5},"SAMPLE"]
["OR","list a project in each row here .. ",null,null,null,{"$f":"IF(ISTEXT(B8),1*$E$6,0)","v":0.25}]
[null,null,null,null,null,{"$f":"IF(ISTEXT(B9),1*$E$6,0)","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[2,"Supervision of coop student/project",null,null,0.5]
[null,"Total number of supervised students ",null,null,10,{"$f":"E13*E14","v":5},"SAMPLE"]
["OR","list a student/project in each row here ..",null,null,null,{"$f":"IF(ISTEXT(B15),1*$E$13,0)","v":0.5}]
[null,null,null,null,null,{"$f":"IF(ISTEXT(B16),1*$E$13,0)","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[3,"Development of instructional laboratory (for teaching courses)‎",null,null,3]
[null,"lab ..",null,null,null,{"$f":"IF(ISTEXT(B21),1*$E$20,0)","v":3},"SAMPLE"]
[null,null,null,null,null,{"$f":"IF(ISTEXT(B22),1*$E$20,0)","v":0}]
[null,null,null,null,null,0]
[4,"Developing and teaching a new undergraduate or graduate course",null,null,5]
[null,"course .. ",null,null,null,{"$f":"IF(ISTEXT(B25),1*$E$24,0)","v":5},"SAMPLE"]
[null,null,null,null,null,{"$f":"IF(ISTEXT(B26),1*$E$24,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(ISTEXT(B27),1*$E$24,0)","v":0}]
[5,"Points for Student Evaluation "]
[null,"Average rank in department for past 3 years",null,null,13,null,"SAMPLE"]
[null,"current number of faculty in department ",null,null,60,null,"SAMPLE"]
[null,null,null,null,null,{"$f":"100*(1-(E29-1)/E30)","v":80}]
[null,null,null,null,"Total",{"$f":"SUM(F6:F31)","v":96.25}]

{"sheet":"Community Service","index":4,"n_rows":59,"n_cols":7,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[]
["Distinguished University Professorship (DUP) Award - Application Form"]
[]
["University and Community Service"]
["SN","Activity",null,null,null,"Points"]
[1,"Chair in Promotion Committee",null,null,5]
[null,"Comm..",null,null,null,{"$f":"IF(ISTEXT(B7),1*$E$6,0)","v":5},"SAMPLE"]
[null,null,null,null,null,{"$f":"IF(ISTEXT(B8),1*$E$6,0)","v":0}]
[null,null,null,null,null,0]
[2,"Member in Promotion Committee",null,null,1]
[null,"Comm..",null,null,null,{"$f":"IF(ISTEXT(B11),1*$E$10,0)","v":1},"SAMPLE"]
[null,null,null,null,null,{"$f":"IF(ISTEXT(B12),1*$E$10,0)","v":0}]
[null,null,null,null,null,0]
[3,"Chair in Committee meets 10 times, keeps minutes and has a final report‎",null,null,5]
[null,"Comm..",null,null,null,{"$f":"IF(ISTEXT(B15),1*$E$14,0)","v":5},"SAMPLE"]
[null,null,null,null,null,{"$f":"IF(ISTEXT(B16),1*$E$14,0)","v":0}]
[null,null,null,null,null,0]
[4,"Member in Committee meets 10 times, keeps minutes and has a final report‎",null,null,1]
[null,"Comm..",null,null,null,{"$f":"IF(ISTEXT(B19),1*$E$18,0)","v":1},"SAMPLE"]
[null,null,null,null,null,{"$f":"IF(ISTEXT(B20),1*$E$18,0)","v":0}]
[null,null,null,null,null,0]
[5,"Chair in Committee meets 5 times but < 10 times, keeps minutes and has a ‎final report",null,null,3]
[null,"Comm..",null,null,null,{"$f":"IF(ISTEXT(B23),1*$E$22,0)","v":3},"SAMPLE"]
[null,null,null,null,null,{"$f":"IF(ISTEXT(B24),1*$E$22,0)","v":0}]
[null,null,null,null,null,0]
[6,"Member in Committee meets 5 times but < 10 times, keeps minutes and has a ‎final report",null,null,0.5]
[null,"Comm..",null,null,null,{"$f":"IF(ISTEXT(B27),1*$E$26,0)","v":0.5},"SAMPLE"]
[null,null,null,null,null,{"$f":"IF(ISTEXT(B28),1*$E$26,0)","v":0}]
[null,null,null,null,null,0]
[7,"Chair in Committee meets < 5 times, keeps minutes and has a final report",null,null,2]
[null,"Comm..",null,null,null,{"$f":"IF(ISTEXT(B31),1*$E$30,0)","v":2},"SAMPLE"]
[null,null,null,null,null,{"$f":"IF(ISTEXT(B32),1*$E$30,0)","v":0}]
[null,null,null,null,null,0]
[8,"Member in Committee meets < 5 times, keeps minutes and has a final report",null,null,0.5]
[null,"Comm..",null,null,null,{"$f":"IF(ISTEXT(B35),1*$E$34,0)","v":0.5},"SAMPLE"]
[null,null,null,null,null,{"$f":"IF(ISTEXT(B36),1*$E$34,0)","v":0}]
[null,null,null,null,null,0]
[9,"Coordinating a short course",null,null,5]
[null,"coordinator .. ",null,null,null,{"$f":"IF(ISTEXT(B39),1*$E$38,0)","v":5},"SAMPLE"]
[null,null,null,null,null,{"$f":"IF(ISTEXT(B40),1*$E$38,0)","v":0}]
[null,null,null,null,null,0]
[10,"Teaching a short course ",null,null,1]
[null,"teaching .. ",null,null,null,{"$f":"IF(ISTEXT(B43),1*$E$42,0)","v":1},"SAMPLE"]
[null,null,null,null,null,{"$f":"IF(ISTEXT(B44),1*$E$42,0)","v":0}]
[null,null,null,null,null,0]
[11,"Offering a KFUPM seminar or talk",null,null,1]
[null,"seminar/talk ..",null,null,null,{"$f":"IF(ISTEXT(B47),1*$E$46,0)","v":1},"SAMPLE"]
[null,null,null,null,null,{"$f":"IF(ISTEXT(B48),1*$E$46,0)","v":0}]
[null,null,null,null,null,0]
[12,"Offering a seminar or talk outside KFUPM",null,null,1]
[null,"seminar/talk ..",null,null,null,{"$f":"IF(ISTEXT(B51),1*$E$50,0)","v":1},"SAMPLE"]
[null,null,null,null,null,{"$f":"IF(ISTEXT(B52),1*$E$50,0)","v":0}]
[null,null,null,null,null,0]
[13,"Offering a seminar or talk outside the Kingdom",null,null,2]
[null,"seminar/talk .. ",null,null,null,{"$f":"IF(ISTEXT(B55),1*$E$54,0)","v":2},"SAMPLE"]
[null,null,null,null,null,{"$f":"IF(ISTEXT(B56),1*$E$54,0)","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,{"$f":"IF(ISTEXT(B58),1*$E$54,0)","v":0}]
[null,null,null,null,"Total",{"$f":"SUM(F6:F58)","v":28}]