{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Data","Report"],"read":"whole","date_system":"1900"}

{"sheet":"Data","index":0,"n_rows":26,"n_cols":16,"rows_kept":26}
["Sl. No.","Student ID","Student Name","Father Name","Date of Birth","Class","Math","English","Science","History","Computer"]
[1,1001,"Ethan Carter","William Carter","2008-03-15","10th",88,92,85,90,94]
[2,1002,"Olivia Brown","Christopher Brown","2008-07-22","10th",73,78,69,72,75]
[3,1003,"Mason Hill","Jonathan Hill","2008-12-02","10th",91,86,89,88,93]
[4,1004,"Sophia Green","Benjamin Green","2008-05-10","10th",82,80,77,85,84]
[5,1005,"Liam Wright","Patrick Wright","2008-09-18","10th",67,72,70,65,68]
[6,1006,"Ava Scott","Edward Scott","2009-01-30","9th",90,88,84,86,89]
[7,1007,"Noah Adams","Daniel Adams","2009-11-12","9th",85,82,91,89,87]
[8,1008,"Emma Turner","Richard Turner","2009-03-05","9th",76,74,79,81,78]
[9,1009,"Lucas Baker","Michael Baker","2009-04-27","9th",94,91,93,92,95]
[10,1010,"Chloe Foster","Andrew Foster","2009-06-14","9th",62,68,65,70,66]
{"$rows_empty":14}
[{"$nulls":15}," "]

{"sheet":"Report","index":1,"n_rows":24,"n_cols":8,"rows_kept":24}
{"$rows_empty":8}
[null,"Student ID",":",1010,null,null,"Marks","Grade"]
[null,"Class",":",{"$f":"VLOOKUP($D$9,Data!$B$2:$K$11,MATCH(B10,Data!$B$1:$K$1,0),FALSE)","v":"9th"},null,null,"80-100","A+"]
[null,"Student Name",":",{"$f":"VLOOKUP($D$9,Data!$B$2:$K$11,MATCH(B11,Data!$B$1:$K$1,0),FALSE)","v":"Chloe Foster"},null,null,"70-79","A"]
[null,"Father Name",":",{"$f":"VLOOKUP($D$9,Data!$B$2:$K$11,MATCH(B12,Data!$B$1:$K$1,0),FALSE)","v":"Andrew Foster"},null,null,"60-69","A-"]
[null,"Date of Birth",":",{"$f":"VLOOKUP($D$9,Data!$B$2:$K$11,MATCH(B13,Data!$B$1:$K$1,0),FALSE)","v":"2009-06-14"},null,null,"50-59","B"]
[]
[{"$nulls":3},"Subject","Total Marks","Obtained Marks","Grade","Percentage"]
[{"$nulls":3},"Math",100,{"$f":"VLOOKUP($D$9,Data!$B$2:$K$11,MATCH(D16,Data!$B$1:$K$1,0),FALSE)","v":62},{"$f":"IF(F16>=80,\"A+\",IF(F16>=70,\"A\",IF(F16>=60,\"A-\",IF(F16>=50,\"B\",\"F\"))))","v":"A-"},{"$f":"F16/E16","v":{"v":0.62,"d":"62.0%"}}]
[{"$nulls":3},"English",100,{"$f":"VLOOKUP($D$9,Data!$B$2:$K$11,MATCH(D17,Data!$B$1:$K$1,0),FALSE)","v":68},{"$f":"IF(F17>=80,\"A+\",IF(F17>=70,\"A\",IF(F17>=60,\"A-\",IF(F17>=50,\"B\",\"F\"))))","v":"A-"},{"$f":"F17/E17","v":{"v":0.68,"d":"68.0%"}}]
[{"$nulls":3},"Science",100,{"$f":"VLOOKUP($D$9,Data!$B$2:$K$11,MATCH(D18,Data!$B$1:$K$1,0),FALSE)","v":65},"A-",{"v":0.65,"d":"65.0%"}]
[{"$nulls":3},"History",100,{"$f":"VLOOKUP($D$9,Data!$B$2:$K$11,MATCH(D19,Data!$B$1:$K$1,0),FALSE)","v":70},"A",{"v":0.7,"d":"70.0%"}]
[{"$nulls":3},"Computer",100,{"$f":"VLOOKUP($D$9,Data!$B$2:$K$11,MATCH(D20,Data!$B$1:$K$1,0),FALSE)","v":66},{"$f":"IF(F20>=80,\"A+\",IF(F20>=70,\"A\",IF(F20>=60,\"A-\",IF(F20>=50,\"B\",\"F\"))))","v":"A-"},{"v":0.66,"d":"66.0%"}]
[{"$nulls":3},"Total",{"$f":"SUM(E16:E20)","v":500},{"$f":"SUM(F16:F20)","v":331},{"$f":"IF(H21*100>=80,\"A+\",IF(H21*100>=70,\"A\",IF(H21*100>=60,\"A-\",IF(H21*100>=50,\"B\",\"F\"))))","v":"A-"},{"v":0.662,"d":"66.2%"}]
[]
[]
[null,"Signature of Teacher",{"$nulls":4},"Signature of Parent"]