{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Count","I1","I2","I3","I4","Validation","IS"],"not_rendered":{"charts":4,"images":1,"macros":0,"external_links":0,"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":"Count","index":0,"n_rows":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"=COUNT          ($D$1$:D$13)\"","v":"=COUNT          ($D$1$:D$13)"},{"$f":"COUNT($E$1:$E$13)","v":9},null,null,1,null,1,2,3,"A","B","C ",null,4]
[{"$f":"\"=COUNTA        ($D$1:$D$13)\"","v":"=COUNTA        ($D$1:$D$13)"},{"$f":"COUNTA($E$1:$E$13)","v":12},null,null,2]
[{"$f":"\"=COUNTBLANK($D$1:$D$13)\"","v":"=COUNTBLANK($D$1:$D$13)"},{"$f":"COUNTBLANK($E$1:$E$13)","v":1},null,null,3]
[{"$f":"\"=COUNTA($E:$E)\"","v":"=COUNTA($E:$E)"},{"$f":"COUNTA($E:$E)","v":13},null,null,"A"]
[{"$f":"\"=COUNTA($G$1:$1)\"","v":"=COUNTA($G$1:$1)"},{"$f":"COUNTA($1:$1)","v":10},null,null,"B"]
[null,null,null,null,"C"]
[null,null,null,null,7]
[null,null,null,null,8]
[null,null,null,null,9]
[]
[null,null,null,null,10]
[null,null,null,null,11]
[null,null,null,null,12]
[]
[null,null,null,null,16]

{"sheet":"I1","index":1,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Month","Total"]
["2009-01-01",14]
["2009-02-01",22]
["2009-03-01",27,null,"Label",{"$f":"COUNTA($A:$A)-1&\" Months\"","v":"12 Months"}]
["2009-04-01",26]
["2009-05-01",20]
["2009-06-01",23]
["2009-07-01",24]
["2009-08-01",26]
["2009-09-01",29]
["2009-10-01",24]
["2009-11-01",14]
["2009-12-01",18]

{"sheet":"I2","index":2,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Month","Total",null,"# To Plot",6]
["2009-01-01",14,null,null,{"$f":"MIN(E1,COUNT($A:$A))","v":6}]
["2009-02-01",22]
["2009-03-01",27,null,"Label",{"$f":"E2&\" Month\"&IF(E2>1,\"s\",\"\")","v":"6 Months"}]
["2009-04-01",26]
["2009-05-01",20]
["2009-06-01",23]
["2009-07-01",24]
["2009-08-01",26]
["2009-09-01",29]
["2009-10-01",24]
["2009-11-01",14]
["2009-12-01",18]

{"sheet":"I3","index":3,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Month","Domestic","Foreign","Total","Blank"]
["Jan",10,4,{"$f":"SUM(B2:C2)","v":14}]
["Feb",15,7,{"$f":"SUM(B3:C3)","v":22}]
["Mar",12,15,27]
["Apr",8,18,26,null,true]
["May",6,14,20,null,false]
["Jun",8,15,23,null,true]
["Jul",12,12,24]
["Aug",18,8,26]
["Sep",24,5,29]
["Oct",16,8,24]
["Nov",10,4,14]
["Dec",12,6,18]

{"sheet":"I4","index":4,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Month","Domestic","Foreign","Total"]
["Jan",10,4,{"$f":"SUM(B2:C2)","v":14}]
["Feb",15,7,{"$f":"SUM(B3:C3)","v":22},null,"Label",{"$f":"CHOOSE(F5,\"Domestic\",\"Foreign\",\"Total\")","v":"Foreign"}]
["Mar",12,15,27]
["Apr",8,18,26,null,2]
["May",6,14,20]
["Jun",8,15,23]
["Jul",12,12,24]
["Aug",18,8,26]
["Sep",24,5,29]
["Oct",16,8,24]
["Nov",10,4,14]
["Dec",12,5,17]

{"sheet":"Validation","index":5,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Aaron"]
[null,null,null,"Betty"]
[null,null,null,"Cindy"]
[null,null,null,"Doug"]

{"sheet":"IS","index":6,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["ISBLANK     (A15)",{"$f":"ISBLANK(A15)","v":false}]
["ISERR         (A15)",{"$f":"ISERR(A15)","v":false}]
["ISERROR    (A15)",{"$f":"ISERROR(A15)","v":false}]
["ISLOGICAL (A15)",{"$f":"ISLOGICAL(A15)","v":false}]
["ISNA           (A15)",{"$f":"ISNA(A15)","v":false}]
["ISNONTEXT(A15)",{"$f":"ISNONTEXT(A15)","v":true}]
["ISNUMBER (A15)",{"$f":"ISNUMBER(A15)","v":true}]
["ISREF         (A15)",{"$f":"ISREF(A15)","v":true}]
["ISTEXT       (A15)",{"$f":"ISTEXT(A15)","v":false}]
[]
[]
[]
[]
["Enter what to test below in A15"]
[12]