{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Dynamic Chart 2"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":1,"defined_names":8,"comments":0,"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":"Dynamic Chart 2","index":0,"n_rows":13,"n_cols":23,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Month","Achieved","Target",null,null,"Start Start Month","Select End Month",null,null,null,null,null,null,null,null,null,null,"Month","Achieved","Target"]
["2012-01-01",39,32,null,null,"2012-02-01","2012-05-01",null,{"$f":"\"Jan to \"&TEXT(G2,\"mmm\")","v":"Jan to May"},null,null,null,null,null,null,null,null,{"$f":"IF(AND(MONTH($F$2)<=MONTH(EDATE($F$2,ROW(A1)-1)),MONTH($G$2)>=MONTH(EDATE($F$2,ROW(A1)-1))),TEXT(EDATE($F$2,ROW(A1)-1),\"mmm\"),\"\")","v":"Feb"},{"$f":"IF(R2=\"\",\"\",VLOOKUP(DATE(YEAR(TODAY()),MONTH(1&$R2),1),$A$2:$B$13,2,0))","v":28},{"$f":"IF(R2=\"\",\"\",VLOOKUP(DATE(YEAR(TODAY()),MONTH(1&$R2),1),$A$2:$C$13,3,0))","v":40}]
["2012-02-01",28,40,null,null,null,null,null,null,null,null,null,"ColA",{"$f":"OFFSET($S$2,0,0,COUNTIF($S$2:$S$13,\"<>\"&\"\"),1)","v":29},null,null,null,{"$f":"IF(AND(MONTH($F$2)<=MONTH(EDATE($F$2,ROW(A2)-1)),MONTH($G$2)>=MONTH(EDATE($F$2,ROW(A2)-1))),TEXT(EDATE($F$2,ROW(A2)-1),\"mmm\"),\"\")","v":"Mar"},{"$f":"IF(R3=\"\",\"\",VLOOKUP(DATE(YEAR(TODAY()),MONTH(1&$R3),1),$A$2:$B$13,2,0))","v":29},{"$f":"IF(R3=\"\",\"\",VLOOKUP(DATE(YEAR(TODAY()),MONTH(1&$R3),1),$A$2:$C$13,3,0))","v":37},{"$f":"COUNTIF(T2:T13,\"<>\"&\"-\")","v":4},{"$f":"COUNTIF(S2:S13,\"<>\"&\"-\")","v":4},{"$f":"COUNTIF(R2:R13,\"<>\"&\"-\")","v":4}]
["2012-03-01",29,37,null,null,null,null,null,null,null,null,null,"ColB",{"$f":"OFFSET($T$1,0,0,COUNTIF($T$2:$T$13,\"<>\"&\"\"),1)","v":34},null,null,null,"Apr",37,34,{"$f":"COUNTIF(R2:R14,\"<>\"&\"*\")","v":1}]
["2012-04-01",37,34,null,null,null,null,null,null,null,null,null,"ColC",null,null,null,null,"May",34,46]
["2012-05-01",34,46,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(MONTH($F$2)<=MONTH(EDATE($F$2,ROW(A5)-1)),MONTH($G$2)>=MONTH(EDATE($F$2,ROW(A5)-1))),TEXT(EDATE($F$2,ROW(A5)-1),\"mmm\"),\"-\")","v":"-"},{"$f":"IF(R6=\"-\",\"-\",VLOOKUP(DATE(YEAR(TODAY()),MONTH(1&$R6),1),$A$2:$B$13,2,0))","v":"-"},{"$f":"IF(R6=\"-\",\"-\",VLOOKUP(DATE(YEAR(TODAY()),MONTH(1&$R6),1),$A$2:$C$13,3,0))","v":"-"},{"$f":"COUNTIF('Dynamic Chart 2'!$S$2:$S$13,\"<>\" & \"\" )","v":12}]
["2012-06-01",27,34,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(MONTH($F$2)<=MONTH(EDATE($F$2,ROW(A6)-1)),MONTH($G$2)>=MONTH(EDATE($F$2,ROW(A6)-1))),TEXT(EDATE($F$2,ROW(A6)-1),\"mmm\"),\"-\")","v":"-"},{"$f":"IF(R7=\"-\",\"-\",VLOOKUP(DATE(YEAR(TODAY()),MONTH(1&$R7),1),$A$2:$B$13,2,0))","v":"-"},{"$f":"IF(R7=\"-\",\"-\",VLOOKUP(DATE(YEAR(TODAY()),MONTH(1&$R7),1),$A$2:$C$13,3,0))","v":"-"}]
["2012-07-01",35,47,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","-","-"]
["2012-08-01",35,36,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","-","-"]
["2012-09-01",25,44,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","-","-"]
["2012-10-01",30,43,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","-","-"]
["2012-11-01",39,49,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","-","-"]
["2012-12-01",25,40,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","-","-"]