{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Data","Charts","Pivot Data","Pivot Table","ControlData"],"not_rendered":{"charts":3,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":1},"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":"Data","index":0,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,1,30,3],[30,4,30,6],[0,1,0,6],[28,1,28,2],[28,3,28,4],[28,5,28,6],[29,1,29,2],[29,3,29,4],[29,5,29,6]]}
[null,"Year-Semester"]
["Subject","1-1","1-2","2-1","2-2","3-1","3-2"]
["Programming 1"]
["Fundamentals of Computing"]
["Japanese 3"]
["Cybercrime"]
["IS"]
["CAM"]
["Programming 2"]
["Japanese 4"]
["Web Technologies"]
["REP",null,null,null,null,null,null,null,"Aiming for Mark:"]
["CI 1",null,null,null,null,null,null,null,0.7]
["Politics and Cinema"]
["Virtual Worlds",null,null,null,null,null,null,null,"3rd Year Average Needed:"]
["APP",null,null,null,null,null,null,null,{"$f":"IFERROR(($I$13-(SUMPRODUCT(B29:E29,B30:E30)))/F30, \"Data needed to calculate\")","v":1.05}]
["Database Systems"]
["SLAD",null,null,null,null,null,null,null,"Current Marks Gained:"]
["Evolution of Complex Systems",null,null,null,null,null,null,null,{"$f":"AVERAGE(IFERROR(AVERAGE(C9:C27),0), IFERROR(AVERAGE(B9:B27),0))*B30 + AVERAGE(IFERROR(AVERAGE(D9:D27),0), IFERROR(AVERAGE(E9:E27),0))*D30 + AVERAGE(IFERROR(AVERAGE(F9:F27),0), IFERROR(AVERAGE(G9:G27),0))*F30","v":0}]
["Games Computing"]
["Advanced Databases"]
["Third Year Double Project (Sem1)"]
["Computational Intelligence 2"]
["It Architectures"]
["Electronic Commerce"]
["Third Year Double Project (Sem2)"]
["Future Marks"]
["Average",{"$f":"IFERROR(AVERAGE(INDIRECT(\"B3\"):B27), \"Data Needed\")","v":"Data Needed"},{"$f":"IFERROR(AVERAGE(INDIRECT(\"C3\"):C27), \"Data Needed\")","v":"Data Needed"},{"$f":"IFERROR(AVERAGE(INDIRECT(\"D3\"):D27), \"Data Needed\")","v":"Data Needed"},{"$f":"IFERROR(AVERAGE(INDIRECT(\"E3\"):E27), \"Data Needed\")","v":"Data Needed"},{"$f":"IFERROR(AVERAGE(INDIRECT(\"F3\"):F27), \"Data Needed\")","v":"Data Needed"},{"$f":"IFERROR(AVERAGE(INDIRECT(\"G3\"):G27), \"Data Needed\")","v":"Data Needed"}]
["Year Average",{"$f":"IFERROR(AVERAGE(B28:C28), \"Data Needed\")","v":"Data Needed"},null,{"$f":"IFERROR(AVERAGE(D28:E28), \"Data Needed\")","v":"Data Needed"},null,{"$f":"IFERROR(AVERAGE(F28:G28), \"Data Needed\")","v":"Data Needed"}]
["Weighting",0,null,0.33333333333333298,null,0.66666666666666663]
["Final Mark & Grade",{"$f":"SUMPRODUCT(B29:G29,B30:G30)","v":0},null,null,{"$f":"IF(B31>=0.7,\"1st\",IF(B31>=0.6,\"2:1\",IF(B31>=0.5,\"2:2\",IF(B31>=0.4,\"3rd\",\"Fail\"))))","v":"Fail"}]

{"sheet":"Charts","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Pivot Data","index":2,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Subject","Semester","Marks"]
["Programming 1","1-1",0.9]
["Fundamentals of Computing","1-1",0.85]
["Japanese 3","1-1",0.79]
["Cybercrime","1-2",0.9]
["IS","1-2",0.85]
["CAM","1-2",0.8]
["Programming 2","1-2",0.78]
["Japanese 4","1-2",0.73]
["Web Technologies","2-1",0.89]
["REP","2-1",0.83]
["CI 1","2-1",0.73]
["Politics and Cinema","2-1",0.6]
["Virtual Worlds","2-2",0.93]
["APP","2-2",0.85]
["Database Systems","2-2",0.87]
["SLAD","2-2",0.63]
["Evolution of Complex Systems","3-1",0.84]
["Games Computing","3-1",0.76]

{"sheet":"Pivot Table","index":3,"n_rows":25,"n_cols":2,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Row Labels","Average of Marks"]
["1-1",0.84666666666666668]
["Fundamentals of Computing",0.85]
["Japanese 3",0.79]
["Programming 1",0.9]
["1-2",0.81200000000000006]
["CAM",0.8]
["Cybercrime",0.9]
["IS",0.85]
["Japanese 4",0.73]
["Programming 2",0.78]
["2-1",0.76250000000000007]
["CI 1",0.73]
["Politics and Cinema",0.6]
["REP",0.83]
["Web Technologies",0.89]
["2-2",0.82]
["APP",0.85]
["Virtual Worlds",0.93]
["Database Systems",0.87]
["SLAD",0.63]
["3-1",0.8]
["Evolution of Complex Systems",0.84]
["Games Computing",0.76]
["Grand Total",0.80722222222222217]

{"sheet":"ControlData","index":4,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["Semester sequence"]
["1-1"]
["1-2"]
["2-1"]
["2-2"]
["3-1"]
["3-2"]