{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":116,"n_cols":13,"rows_kept":116,"cut":false,"hidden":false,"merged":[]}
[null,"TblCrit",null,null,null,"TblSel"]
[null,"Crit1","Crit2","Crit3",null,"Sel1","Start","End"]
[null,null,"Date","Date",null,"BRA","2010-09-01","2010-12-31",null,"Find number of unique clients that placed an Order during a specific Date (from TblOrder) from a specific country (from TblClient)"]
[null,{"$f":"INDEX(TblClient[Country],MATCH(Client,TblClient[Client],0))=TblSel[Sel1]","v":{"$error":"#VALUE!"}},{"$f":"\">=\"&TblSel[Start]","v":">=40422"},{"$f":"\"<\"&TblSel[End]","v":"<40543"}]
[]
[]
[null,"TblOrder",null,null,null,"TblFilt",null,null,null,null,null,"TblClient"]
[null,"OrderNo","Client","Date",null,"OrderNo","Client","Date","Unique",null,null,"Client","Country"]
[null,"H6559",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Thomas"},{"$f":"DATE(RANDBETWEEN(2010,2011),RANDBETWEEN(1,12),RANDBETWEEN(1,31))","v":"2011-06-15"},null,"W3317","White","2010-10-24",{"$f":"1/COUNTIF(TblFilt[Client],TblFilt[[#This Row],[Client]])","v":0.33333333333333331},null,null,"Brown","AUT"]
[null,"N3549",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Taylor"},{"$f":"DATE(RANDBETWEEN(2010,2011),RANDBETWEEN(1,12),RANDBETWEEN(1,31))","v":"2010-04-05"},null,"J9599","Taylor","2010-09-22",{"$f":"1/COUNTIF(TblFilt[Client],TblFilt[[#This Row],[Client]])","v":0.5},null,null,"Davis","AUT"]
[null,"P6257",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Brown"},"2010-01-29",null,"F6604","Taylor","2010-12-25",{"$f":"1/COUNTIF(TblFilt[Client],TblFilt[[#This Row],[Client]])","v":0.5},null,null,"Miller","BEL"]
[null,"M9592",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Miller"},"2010-02-12",null,"B8743","White","2010-11-28",{"$f":"1/COUNTIF(TblFilt[Client],TblFilt[[#This Row],[Client]])","v":0.33333333333333331},null,null,"Wilson","BEL"]
[null,"G6908",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Taylor"},"2011-03-29",null,"F4977","Moore","2010-12-02",{"$f":"1/COUNTIF(TblFilt[Client],TblFilt[[#This Row],[Client]])","v":0.5},null,null,"Moore","BRA"]
[null,"W8162",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Wilson"},"2010-05-31",null,"D2350","White","2010-10-17",{"$f":"1/COUNTIF(TblFilt[Client],TblFilt[[#This Row],[Client]])","v":0.33333333333333331},null,null,"Taylor","BRA"]
[null,"H3715",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Anderson"},"2011-12-05",null,"S9741","Moore","2010-12-13",{"$f":"1/COUNTIF(TblFilt[Client],TblFilt[[#This Row],[Client]])","v":0.5},null,null,"White","BRA"]
[null,"H9055",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Moore"},"2011-08-05",null,"Total",null,null,{"$f":"SUBTOTAL(109,TblFilt[Unique])","v":3},null,null,"Anderson","CAN"]
[null,"G7230",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Anderson"},"2010-06-05",null,null,null,null,null,null,null,"Thomas","CAN"]
[null,"W5498",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Jackson"},"2010-05-19",null,null,null,null,null,null,null,"Jackson","CHI"]
[null,"N5489",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Jackson"},"2010-06-24"]
[null,"M8183",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Moore"},"2010-06-12"]
[null,"S2274",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Taylor"},"2011-08-30"]
[null,"L9460",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Jackson"},"2010-02-11"]
[null,"V9615",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Davis"},"2010-06-27"]
[null,"N9676",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Jackson"},"2011-11-25"]
[null,"R6157",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Thomas"},"2011-03-16"]
[null,"B5928",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Anderson"},"2011-05-22"]
[null,"W4578",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Brown"},"2010-04-13"]
[null,"S7282",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Brown"},"2010-11-09"]
[null,"D9913",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Moore"},"2010-02-12"]
[null,"M2719",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Anderson"},"2010-10-21"]
[null,"R1741",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Davis"},"2010-07-09"]
[null,"N8236",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Jackson"},"2010-08-29"]
[null,"G6868",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Davis"},"2011-03-13"]
[null,"S5264",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Wilson"},"2010-05-09"]
[null,"P4676",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Davis"},"2010-09-24"]
[null,"W3306",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Taylor"},"2011-09-20"]
[null,"W9489",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Thomas"},"2010-09-11"]
[null,"L5918",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"White"},"2010-06-11"]
[null,"V8901",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Moore"},"2010-08-31"]
[null,"L5197",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Brown"},"2010-12-30"]
[null,"R5216",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"White"},"2011-05-31"]
[null,"T3181",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Jackson"},"2011-07-22"]
[null,"P7540",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Moore"},"2010-11-02"]
[null,"H1740",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"White"},"2011-11-26"]
[null,"W3317",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Moore"},"2010-10-15"]
[null,"D3833",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Taylor"},"2010-07-19"]
[null,"N4175",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"White"},"2010-06-03"]
[null,"J3258",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Jackson"},"2010-05-05"]
[null,"N2867",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Davis"},"2010-04-22"]
[null,"B1143",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Moore"},"2010-03-03"]
[null,"N1112",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Brown"},"2010-11-11"]
[null,"L5012",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Jackson"},"2011-09-27"]
[null,"F5293",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Brown"},"2010-06-27"]
[null,"F9015",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"White"},"2011-04-21"]
[null,"F5150",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Wilson"},"2011-04-07"]
[null,"M4621",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Brown"},"2010-05-06"]
[null,"L8656",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Davis"},"2011-09-05"]
[null,"N5403",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Anderson"},"2010-08-18"]
[null,"L2674",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Jackson"},"2011-10-20"]
[null,"L1066",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Davis"},"2010-03-12"]
[null,"F1061",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"White"},"2011-01-12"]
[null,"T7310",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Miller"},"2010-09-15"]
[null,"B9849",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Taylor"},"2010-06-14"]
[null,"T4186",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Taylor"},"2010-02-08"]
[null,"M2633",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Wilson"},"2011-08-08"]
[null,"F5093",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Taylor"},"2011-02-20"]
[null,"J9599",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"White"},"2010-03-15"]
[null,"W4242",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Wilson"},"2010-03-02"]
[null,"S9577",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Brown"},"2011-04-09"]
[null,"K2333",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Thomas"},"2010-01-29"]
[null,"W6039",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Miller"},"2010-01-18"]
[null,"M9868",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Taylor"},"2010-05-28"]
[null,"T4061",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Anderson"},"2011-07-20"]
[null,"K6563",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Brown"},{"$f":"DATE(RANDBETWEEN(2010,2011),RANDBETWEEN(1,12),RANDBETWEEN(1,31))","v":"2010-06-18"}]
[null,"P2846",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Wilson"},"2010-07-25"]
[null,"M3104",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Jackson"},"2011-08-13"]
[null,"R4693",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Miller"},"2010-11-01"]
[null,"N4888",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Thomas"},"2010-05-24"]
[null,"P1241",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Davis"},"2010-02-15"]
[null,"J3612",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Miller"},"2010-02-08"]
[null,"F2025",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Brown"},"2011-02-25"]
[null,"M9457",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Davis"},"2010-04-30"]
[null,"H7113",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Brown"},"2010-04-24"]
[null,"M4860",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Taylor"},"2010-07-11"]
[null,"P9223",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Anderson"},"2011-02-23"]
[null,"F6604",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Taylor"},"2010-12-26"]
[null,"J7128",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Miller"},"2010-06-27"]
[null,"F1390",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Miller"},"2010-02-06"]
[null,"V4833",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Wilson"},"2011-02-17"]
[null,"B8743",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Brown"},"2011-03-01"]
[null,"V8172",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Miller"},"2010-04-03"]
[null,"S3338",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Thomas"},"2010-06-03"]
[null,"V7311",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Moore"},"2010-09-04"]
[null,"L1593",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Jackson"},"2010-07-29"]
[null,"P1383",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Jackson"},"2011-04-18"]
[null,"F4977",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Miller"},"2010-01-22"]
[null,"P3301",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Anderson"},"2011-11-12"]
[null,"J6183",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Davis"},"2010-07-11"]
[null,"K1836",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Jackson"},"2010-01-27"]
[null,"J7230",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Wilson"},"2011-04-03"]
[null,"P3213",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Wilson"},"2011-11-25"]
[null,"W2008",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Wilson"},"2010-05-01"]
[null,"W6840",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Thomas"},"2011-10-10"]
[null,"B7567",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Anderson"},"2010-08-12"]
[null,"L5364",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Wilson"},"2010-11-29"]
[null,"M3282",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Wilson"},"2010-04-04"]
[null,"H4302",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Thomas"},"2010-09-03"]
[null,"D2350",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Thomas"},"2010-02-23"]
[null,"V6056",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Davis"},"2011-10-30"]
[null,"D3182",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Davis"},"2010-06-15"]
[null,"V9758",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Thomas"},"2011-03-14"]
[null,"W5140",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"White"},"2011-09-20"]
[null,"F6660",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Anderson"},"2011-10-17"]
[null,"S9741",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Thomas"},"2010-07-29"]
[null,"R1934",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Wilson"},"2011-12-13"]
[null,"L5210",{"$f":"INDEX(TblClient[Client],RANDBETWEEN(1,10))","v":"Taylor"},"2010-10-15"]