{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["pivot2","pivot1","data"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"pivot2","index":0,"n_rows":78,"n_cols":10,"rows_kept":78,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Year","(Tous)"]
[]
["Average of Marks",null,"Subject"]
["Country","Name","French","Geography","Maths","Science","Trignometry"]
["China","Lee",86,63.333333333333336,72.33333333333333,73,84]
["India","Ajay",67.66666666666667,78.33333333333333,91.33333333333333,63.666666666666664,67.33333333333333]
[null,"Mark",64,66,75,56.333333333333336,73.33333333333333]
["Spain","Able",85,85.33333333333333,76,73.33333333333333,81]
[null,"Bud",67,74.33333333333333,88,73,74]
[null,"Jack",72.66666666666667,65,55.333333333333336,67.66666666666667,78.66666666666667]
[null,"Jonah",66.66666666666667,74.66666666666667,81.33333333333333,57,66.66666666666667]
["Tiawan","Sarah",88.33333333333333,75,84.33333333333333,75.33333333333333,74.33333333333333]
[null,"Steffi",75.66666666666667,79.33333333333333,66.66666666666667,66,66.66666666666667]
{"$rows_empty":64}
[{"$nulls":9},{"$error":"#REF!"}]

{"sheet":"pivot1","index":1,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Country","(Tous)"]
[]
["Sum of Marks",null,"Subject"]
["Name","Year","French","Geography","Maths","Science","Trignometry"]
["Able","First Year",87,97,71,64,76]
[null,"Second Year",91,84,61,85,98]
[null,"Third Year",77,75,96,71,69]
["Ajay","First Year",61,98,96,53,80]
[null,"Second Year",58,50,100,71,58]
[null,"Third Year",84,87,78,67,64]
["Bud","First Year",56,83,91,56,78]
[null,"Second Year",52,83,93,85,67]
[null,"Third Year",93,57,80,78,77]
["Jack","First Year",95,58,50,51,83]
[null,"Second Year",72,51,54,89,55]
[null,"Third Year",51,86,62,63,98]
["Jonah","First Year",68,77,85,62,62]
[null,"Second Year",82,79,72,52,70]
[null,"Third Year",50,68,87,57,68]
["Lee","First Year",82,62,83,76,71]
[null,"Second Year",90,72,79,76,97]
[null,"Third Year",86,56,55,67,84]
["Mark","First Year",56,65,62,61,66]
[null,"Second Year",73,69,96,58,57]
[null,"Third Year",63,64,67,50,97]
["Sarah","First Year",96,56,65,66,63]
[null,"Second Year",98,77,91,66,72]
[null,"Third Year",71,92,97,94,88]
["Steffi","First Year",71,68,59,67,88]
[null,"Second Year",78,84,73,63,59]
[null,"Third Year",78,86,68,68,53]

{"sheet":"data","index":2,"n_rows":136,"n_cols":5,"rows_kept":136,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Country","Name","Year","Subject","Marks"]
["Spain","Jack","First Year","Maths",50]
["Spain","Jack","First Year","Science",51]
["Spain","Jack","First Year","Geography",58]
["Spain","Jack","First Year","Trignometry",83]
["Spain","Jack","First Year","French",95]
["India","Mark","First Year","Maths",62]
["India","Mark","First Year","Science",61]
["India","Mark","First Year","Geography",65]
["India","Mark","First Year","Trignometry",66]
["India","Mark","First Year","French",56]
["Tiawan","Sarah","First Year","Maths",65]
["Tiawan","Sarah","First Year","Science",66]
["Tiawan","Sarah","First Year","Geography",56]
["Tiawan","Sarah","First Year","Trignometry",63]
["Tiawan","Sarah","First Year","French",96]
["India","Ajay","First Year","Maths",96]
["India","Ajay","First Year","Science",53]
["India","Ajay","First Year","Geography",98]
["India","Ajay","First Year","Trignometry",80]
["India","Ajay","First Year","French",61]
["Spain","Jonah","First Year","Maths",85]
["Spain","Jonah","First Year","Science",62]
["Spain","Jonah","First Year","Geography",77]
["Spain","Jonah","First Year","Trignometry",62]
["Spain","Jonah","First Year","French",68]
["Spain","Able","First Year","Maths",71]
["Spain","Able","First Year","Science",64]
["Spain","Able","First Year","Geography",97]
["Spain","Able","First Year","Trignometry",76]
["Spain","Able","First Year","French",87]
["Spain","Bud","First Year","Maths",91]
["Spain","Bud","First Year","Science",56]
["Spain","Bud","First Year","Geography",83]
["Spain","Bud","First Year","Trignometry",78]
["Spain","Bud","First Year","French",56]
["Tiawan","Steffi","First Year","Maths",59]
["Tiawan","Steffi","First Year","Science",67]
["Tiawan","Steffi","First Year","Geography",68]
["Tiawan","Steffi","First Year","Trignometry",88]
["Tiawan","Steffi","First Year","French",71]
["China","Lee","First Year","Maths",83]
["China","Lee","First Year","Science",76]
["China","Lee","First Year","Geography",62]
["China","Lee","First Year","Trignometry",71]
["China","Lee","First Year","French",82]
["Spain","Jack","Second Year","Maths",54]
["Spain","Jack","Second Year","Science",89]
["Spain","Jack","Second Year","Geography",51]
["Spain","Jack","Second Year","Trignometry",55]
["Spain","Jack","Second Year","French",72]
["India","Mark","Second Year","Maths",96]
["India","Mark","Second Year","Science",58]
["India","Mark","Second Year","Geography",69]
["India","Mark","Second Year","Trignometry",57]
["India","Mark","Second Year","French",73]
["Tiawan","Sarah","Second Year","Maths",91]
["Tiawan","Sarah","Second Year","Science",66]
["Tiawan","Sarah","Second Year","Geography",77]
["Tiawan","Sarah","Second Year","Trignometry",72]
["Tiawan","Sarah","Second Year","French",98]
["India","Ajay","Second Year","Maths",100]
["India","Ajay","Second Year","Science",71]
["India","Ajay","Second Year","Geography",50]
["India","Ajay","Second Year","Trignometry",58]
["India","Ajay","Second Year","French",58]
["Spain","Jonah","Second Year","Maths",72]
["Spain","Jonah","Second Year","Science",52]
["Spain","Jonah","Second Year","Geography",79]
["Spain","Jonah","Second Year","Trignometry",70]
["Spain","Jonah","Second Year","French",82]
["Spain","Able","Second Year","Maths",61]
["Spain","Able","Second Year","Science",85]
["Spain","Able","Second Year","Geography",84]
["Spain","Able","Second Year","Trignometry",98]
["Spain","Able","Second Year","French",91]
["Spain","Bud","Second Year","Maths",93]
["Spain","Bud","Second Year","Science",85]
["Spain","Bud","Second Year","Geography",83]
["Spain","Bud","Second Year","Trignometry",67]
["Spain","Bud","Second Year","French",52]
["Tiawan","Steffi","Second Year","Maths",73]
["Tiawan","Steffi","Second Year","Science",63]
["Tiawan","Steffi","Second Year","Geography",84]
["Tiawan","Steffi","Second Year","Trignometry",59]
["Tiawan","Steffi","Second Year","French",78]
["China","Lee","Second Year","Maths",79]
["China","Lee","Second Year","Science",76]
["China","Lee","Second Year","Geography",72]
["China","Lee","Second Year","Trignometry",97]
["China","Lee","Second Year","French",90]
["Spain","Jack","Third Year","Maths",62]
["Spain","Jack","Third Year","Science",63]
["Spain","Jack","Third Year","Geography",86]
["Spain","Jack","Third Year","Trignometry",98]
["Spain","Jack","Third Year","French",51]
["India","Mark","Third Year","Maths",67]
["India","Mark","Third Year","Science",50]
["India","Mark","Third Year","Geography",64]
["India","Mark","Third Year","Trignometry",97]
["India","Mark","Third Year","French",63]
["Tiawan","Sarah","Third Year","Maths",97]
["Tiawan","Sarah","Third Year","Science",94]
["Tiawan","Sarah","Third Year","Geography",92]
["Tiawan","Sarah","Third Year","Trignometry",88]
["Tiawan","Sarah","Third Year","French",71]
["India","Ajay","Third Year","Maths",78]
["India","Ajay","Third Year","Science",67]
["India","Ajay","Third Year","Geography",87]
["India","Ajay","Third Year","Trignometry",64]
["India","Ajay","Third Year","French",84]
["Spain","Jonah","Third Year","Maths",87]
["Spain","Jonah","Third Year","Science",57]
["Spain","Jonah","Third Year","Geography",68]
["Spain","Jonah","Third Year","Trignometry",68]
["Spain","Jonah","Third Year","French",50]
["Spain","Able","Third Year","Maths",96]
["Spain","Able","Third Year","Science",71]
["Spain","Able","Third Year","Geography",75]
["Spain","Able","Third Year","Trignometry",69]
["Spain","Able","Third Year","French",77]
["Spain","Bud","Third Year","Maths",80]
["Spain","Bud","Third Year","Science",78]
["Spain","Bud","Third Year","Geography",57]
["Spain","Bud","Third Year","Trignometry",77]
["Spain","Bud","Third Year","French",93]
["Tiawan","Steffi","Third Year","Maths",68]
["Tiawan","Steffi","Third Year","Science",68]
["Tiawan","Steffi","Third Year","Geography",86]
["Tiawan","Steffi","Third Year","Trignometry",53]
["Tiawan","Steffi","Third Year","French",78]
["China","Lee","Third Year","Maths",55]
["China","Lee","Third Year","Science",67]
["China","Lee","Third Year","Geography",56]
["China","Lee","Third Year","Trignometry",84]
["China","Lee","Third Year","French",86]