{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Data","index":0,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Country","Person","Date","Date2","Time","Amount"]
[{"$f":"CHOOSE(RANDBETWEEN(1,4),\"Belgium\",\"Netherlands\",\"France\",\"Germany\")","v":"Belgium"},"I","2016-08-13","2016-08-13","21:06:13",{"$f":"RANDBETWEEN(0,1000)","v":648}]
["Netherlands","you","2016-08-14","2016-08-14","20:15:00",199]
["Netherlands","he","2016-08-15","2016-08-15","02:56:18",133]
["Netherlands","she","2016-08-16","2016-08-16","13:46:47",173,null,null,null,null,"Press Ctrl-Shift-E to duplicate the selected column"]
["Belgium","you","2016-08-18","2016-08-18","00:47:13.936",605,null,null,null,null,"Column widths are respected"]
["Germany","they","2016-08-19","2016-08-19","01:00:26.680",485]
["Belgium","I","2016-08-20","2016-08-20","05:23:42.895",278]
["Germany","you","2016-08-21","2016-08-21","23:23:13.018",850]
["Germany","he","2016-08-22","2016-08-22","00:00:05.379",899]
["Belgium","she","2016-08-23","2016-08-23","07:27:44.596",390]
["Germany","we","2016-08-24","2016-08-24","23:08:14.184",413]
["Netherlands","you","2016-08-25","2016-08-25","00:35:42.953",175]
["France","they","2016-08-26","2016-08-26","01:34:43.254",761]
["Total",null,{"$f":"MONTH(MAX(Table1[Date]))","v":8},{"$f":"MONTH(MAX(Table1[Date2]))","v":8},null,{"$f":"SUBTOTAL(109,Table1[Amount])","v":6009}]