{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Map Chart in Excel","Practice Sheet"],"not_rendered":{"charts":2,"images":1},"read":"whole","date_system":"1900"}

{"sheet":"Map Chart in Excel","index":0,"n_rows":20,"n_cols":7,"rows_kept":20,"merged":[[1,6,1,8]]}
[]
["Target",{"v":0.8,"d":"80%"},{"v":0.9,"d":"90%"},null,null,"Select KPI","Sales%"]
[]
["Country","Sales%","Quality%"]
["India",{"v":0.82,"d":"82%"},{"v":0.95,"d":"95%"}]
["China",{"v":0.6,"d":"60%"},{"v":0.65,"d":"65%"}]
["Canada",{"v":0.86,"d":"86%"},{"v":0.86,"d":"86%"}]
["Brazil",{"v":0.88,"d":"88%"},{"v":0.82,"d":"82%"}]
["Australia",{"v":0.76,"d":"76%"},{"v":0.95,"d":"95%"}]
["USA",{"v":0.86,"d":"86%"},{"v":0.96,"d":"96%"}]
[]
[]
[]
["Country","X","Y","Met","Not Met"]
["India",7.1,5.5,{"$f":"IF($G$2=$B$4,IF(B5>=$B$2,B5,NA()),IF(C5>=$C$2,C5,NA()))","v":{"v":0.82,"d":"82%"}},{"$f":"IF($G$2=$B$4,IF(B5>=$B$2,NA(),B5),IF(C5>=$C$2,NA(),C5))","v":{"$error":"#N/A"}}]
["China",7.6,7,{"$f":"IF($G$2=$B$4,IF(B6>=$B$2,B6,NA()),IF(C6>=$C$2,C6,NA()))","v":{"$error":"#N/A"}},{"$f":"IF($G$2=$B$4,IF(B6>=$B$2,NA(),B6),IF(C6>=$C$2,NA(),C6))","v":{"v":0.6,"d":"60%"}}]
["Canada",1.5,8.5,{"v":0.86,"d":"86%"},{"$error":"#N/A"}]
["Brazil",2.5,2.5,{"v":0.88,"d":"88%"},{"$error":"#N/A"}]
["Australia",9,2.5,{"$error":"#N/A"},{"v":0.76,"d":"76%"}]
["USA",1.3,7,{"v":0.86,"d":"86%"},{"$error":"#N/A"}]

{"sheet":"Practice Sheet","index":1,"n_rows":20,"n_cols":7,"rows_kept":20,"merged":[[1,6,1,8]]}
[]
["Target",{"v":0.8,"d":"80%"},{"v":0.9,"d":"90%"},null,null,"Select KPI","Quality%"]
[]
["Country","Sales%","Quality%"]
["India",{"v":0.82,"d":"82%"},{"v":0.95,"d":"95%"}]
["China",{"v":0.98,"d":"98%"},{"v":0.65,"d":"65%"}]
["Canada",{"v":0.86,"d":"86%"},{"v":0.86,"d":"86%"}]
["Brazil",{"v":0.88,"d":"88%"},{"v":1,"d":"100%"}]
["Australia",{"v":0.76,"d":"76%"},{"v":0.95,"d":"95%"}]
["USA",{"v":0.86,"d":"86%"},{"v":0.96,"d":"96%"}]
[]
[]
[]
["Country","X","Y","Met","Not Met"]
["India",7.1,5.5,{"$f":"IF($G$2=$B$4, IF(B5>=$B$2,B5, NA()), IF($G$2=$C$4,  IF(C5>=$C$2,C5, NA())))","v":{"v":0.95,"d":"95%"}},{"$f":"IF($G$2=$B$4, IF(B5>=$B$2,NA(), B5), IF($G$2=$C$4,  IF(C5>=$C$2,NA(), C5)))","v":{"$error":"#N/A"}}]
["China",7.6,7,{"$f":"IF($G$2=$B$4, IF(B6>=$B$2,B6, NA()), IF($G$2=$C$4,  IF(C6>=$C$2,C6, NA())))","v":{"$error":"#N/A"}},{"$f":"IF($G$2=$B$4, IF(B6>=$B$2,NA(), B6), IF($G$2=$C$4,  IF(C6>=$C$2,NA(), C6)))","v":{"v":0.65,"d":"65%"}}]
["Canada",1.5,8.5,{"$error":"#N/A"},{"v":0.86,"d":"86%"}]
["Brazil",2.5,2.5,{"v":1,"d":"100%"},{"$error":"#N/A"}]
["Australia",8.6,2.5,{"v":0.95,"d":"95%"},{"$error":"#N/A"}]
["USA",1.3,6.8,{"v":0.96,"d":"96%"},{"$error":"#N/A"}]