{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Tables","Test","RR"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"comments":1,"pivot_tables":1},"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":"Tables","index":0,"n_rows":105,"n_cols":29,"rows_kept":105,"cut":false,"hidden":false,"merged":[]}
[null,"NName","State","Rept"]
[null,{"$f":"INDEX(Table1[NName],RANDBETWEEN(1,ROWS(Table1[])))","v":"Roger"},{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"NY"},{"$f":"COUNTIF(INDEX(Table2[NName],1):Table2[[#This Row],[NName]],Table2[NName])","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table3[UnSm])","v":1.9999999999999998}]
[null,"Table2",null,null,null,"Table3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PivotTable1"]
[null,"NName","State","Rept",null,"NName","1","2","3","4","5","6","7","8","UnSm",null,null,null,null,null,null,null,null,"Rept"]
[null,"Albert",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"AL"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":1},null,"Albert",{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"AL"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"AL"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"WA"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"CA"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":""},null,null,null,null,null,null,null,"NName",1,2,3,4,5,6]
[null,"Albert",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"AL"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":2},null,"Andrew",{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"CA"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"NY"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"NY"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":""},null,null,null,null,null,null,null,"Albert"]
[null,"Albert",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"WA"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":3},null,"Arthur",{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"CA"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"AL"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":0.5},null,null,null,null,null,null,null,"Andrew"]
[null,"Albert",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"CA"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":4},null,"Brian",{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"CT"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"WA"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"WA"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"CT"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"NY"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"CT"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":""},null,null,null,null,null,null,null,"Arthur"]
[null,"Andrew",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"CA"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":1},null,"Carl",{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"NY"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"WA"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":""},null,null,null,null,null,null,null,"Brian"]
[null,"Andrew",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"NY"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":2},null,"Daniel",{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"WA"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"WA"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"CA"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":""},null,null,null,null,null,null,null,"Carl"]
[null,"Andrew",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"NY"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":3},null,"Dennis",{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"NY"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"CA"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"CT"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"CT"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":""},null,null,null,null,null,null,null,"Daniel"]
[null,"Arthur",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"CA"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":1},null,"Donald",{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"NY"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"NY"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":0.33333333333333326},null,null,null,null,null,null,null,"Dennis"]
[null,"Arthur",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"AL"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":2},null,"Douglas",{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"NY"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"NY"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":0.33333333333333326},null,null,null,null,null,null,null,"Donald"]
[null,"Brian",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"CT"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":1},null,"Edward",{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"WA"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"NY"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"CT"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":""},null,null,null,null,null,null,null,"Douglas"]
[null,"Brian",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"WA"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":2},null,"George",{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"WA"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"NY"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":""},null,null,null,null,null,null,null,"Edward"]
[null,"Brian",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"WA"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":3},null,"Gregory",{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"CA"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"CT"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"WA"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":""},null,null,null,null,null,null,null,"George"]
[null,"Brian",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"CT"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":4},null,"Harold",{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"WA"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"CT"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"CA"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"WA"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":""},null,null,null,null,null,null,null,"Gregory"]
[null,"Brian",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"NY"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":5},null,"Henry",{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"CA"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"CA"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":""},null,null,null,null,null,null,null,"Harold"]
[null,"Brian",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"CT"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":6},null,"Jack",{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"CA"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"AL"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":0.5},null,null,null,null,null,null,null,"Henry"]
[null,"Carl",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"NY"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":1},null,"Jerry",{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"CA"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"CT"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":""},null,null,null,null,null,null,null,"Jack"]
[null,"Carl",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"WA"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":2},null,"Joe",{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"NY"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"CA"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":""},null,null,null,null,null,null,null,"Jerry"]
[null,"Daniel",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"WA"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":1},null,"Joshua",{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"NY"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"CA"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"CA"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"CT"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":""},null,null,null,null,null,null,null,"Joe"]
[null,"Daniel",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"WA"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":2},null,"Juan",{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"WA"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"CA"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"CT"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":""},null,null,null,null,null,null,null,"Joshua"]
[null,"Daniel",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"CA"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":3},null,"Justin",{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"AL"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"WA"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"NY"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":""},null,null,null,null,null,null,null,"Juan"]
[null,"Dennis",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"NY"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":1},null,"Keith",{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"WA"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"WA"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"AL"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"CT"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"WA"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"AL"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":""},null,null,null,null,null,null,null,"Justin"]
[null,"Dennis",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"CA"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":2},null,"Kenneth",{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"NY"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"AL"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":""},null,null,null,null,null,null,null,"Keith"]
[null,"Dennis",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"CT"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":3},null,"Patrick",{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"WA"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"AL"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"NY"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"AL"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":""},null,null,null,null,null,null,null,"Kenneth"]
[null,"Dennis",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"CT"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":4},null,"Paul",{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"AL"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"AL"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"CT"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"AL"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":""},null,null,null,null,null,null,null,"Patrick"]
[null,"Donald",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"NY"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":1},null,"Peter",{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"AL"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"CA"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"CT"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":""},null,null,null,null,null,null,null,"Paul"]
[null,"Donald",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"NY"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":2},null,"Raymond",{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"CT"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"CA"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":""},null,null,null,null,null,null,null,"Peter"]
[null,"Douglas",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"NY"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":1},null,"Roger",{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"WA"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"CT"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"AL"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"AL"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":""},null,null,null,null,null,null,null,"Raymond"]
[null,"Douglas",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"NY"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":2},null,"Ronald",{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"AL"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"NY"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"WA"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"AL"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":""},null,null,null,null,null,null,null,"Roger"]
[null,"Edward",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"WA"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":1},null,"Ryan",{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"AL"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"CT"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"WA"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":""},null,null,null,null,null,null,null,"Ronald"]
[null,"Edward",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"NY"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":2},null,"Stephen",{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"AL"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"CT"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":""},null,null,null,null,null,null,null,"Ryan"]
[null,"Edward",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"CT"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":3},null,"Steven",{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"AL"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"CT"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"CA"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":""},null,null,null,null,null,null,null,"Stephen"]
[null,"George",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"WA"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":1},null,"Terry",{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"WA"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"AL"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":""},null,null,null,null,null,null,null,"Steven"]
[null,"George",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"NY"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":2},null,"Walter",{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"NY"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":"NY"},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":0.33333333333333326},null,null,null,null,null,null,null,"Terry"]
[null,"Gregory",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"CA"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":1},null,null,{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":""},null,null,null,null,null,null,null,"Walter"]
[null,"Gregory",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"CT"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":2},null,null,{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":""}]
[null,"Gregory",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"WA"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":3},null,null,{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":""}]
[null,"Harold",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"WA"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":1},null,null,{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":""}]
[null,"Harold",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"CT"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":2},null,null,{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":""}]
[null,"Harold",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"CA"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":3},null,null,{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":""}]
[null,"Harold",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"WA"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":4},null,null,{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":""}]
[null,"Henry",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"CA"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":1},null,null,{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":""}]
[null,"Henry",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"CA"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":2},null,null,{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":""}]
[null,"Jack",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"CA"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":1},null,null,{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(INDEX(Table2[State],1/(1/SUMPRODUCT((Table2[Rept]=RIGHT(INDEX(Table3[#Headers],coln))*1)*(Table2[NName]=Table3[[#This Row],[NName]])*rown))),\"\")","v":""},{"$f":"IFERROR(1/(1/(1/COUNTIFS([NName],\"=*\",[1],[1],[2],[2],[3],[3],[4],[4],[5],[5],[6],[6],[7],[7],[8],[8])-1))+1,\"\")","v":""}]
[null,"Jack",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"AL"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":2}]
[null,"Jerry",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"CA"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":1}]
[null,"Jerry",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"CT"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":2}]
[null,"Joe",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"NY"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":1}]
[null,"Joe",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"CA"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":2}]
[null,"Joshua",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"NY"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":1}]
[null,"Joshua",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"CA"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":2}]
[null,"Joshua",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"CA"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":3}]
[null,"Joshua",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"CT"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":4}]
[null,"Juan",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"WA"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":1}]
[null,"Juan",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"CA"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":2}]
[null,"Juan",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"CT"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":3}]
[null,"Justin",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"AL"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":1}]
[null,"Justin",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"WA"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":2}]
[null,"Justin",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"NY"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":3}]
[null,"Keith",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"WA"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":1}]
[null,"Keith",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"WA"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":2}]
[null,"Keith",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"AL"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":3}]
[null,"Keith",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"CT"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":4}]
[null,"Keith",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"WA"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":5}]
[null,"Keith",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"AL"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":6}]
[null,"Kenneth",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"NY"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":1}]
[null,"Kenneth",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"AL"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":2}]
[null,"Patrick",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"WA"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":1}]
[null,"Patrick",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"AL"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":2}]
[null,"Patrick",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"NY"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":3}]
[null,"Patrick",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"AL"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":4}]
[null,"Paul",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"AL"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":1}]
[null,"Paul",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"AL"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":2}]
[null,"Paul",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"CT"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":3}]
[null,"Paul",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"AL"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":4}]
[null,"Peter",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"AL"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":1}]
[null,"Peter",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"CA"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":2}]
[null,"Peter",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"CT"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":3}]
[null,"Raymond",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"CT"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":1}]
[null,"Raymond",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"CA"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":2}]
[null,"Roger",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"WA"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":1}]
[null,"Roger",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"CT"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":2}]
[null,"Roger",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"AL"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":3}]
[null,"Roger",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"AL"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":4}]
[null,"Ronald",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"AL"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":1}]
[null,"Ronald",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"NY"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":2}]
[null,"Ronald",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"WA"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":3}]
[null,"Ronald",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"AL"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":4}]
[null,"Ryan",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"AL"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":1}]
[null,"Ryan",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"CT"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":2}]
[null,"Ryan",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"WA"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":3}]
[null,"Stephen",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"AL"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":1}]
[null,"Stephen",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"CT"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":2}]
[null,"Steven",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"AL"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":1}]
[null,"Steven",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"CT"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":2}]
[null,"Steven",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"CA"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":3}]
[null,"Terry",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"WA"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":1}]
[null,"Terry",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"AL"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":2}]
[null,"Walter",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"NY"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":1}]
[null,"Walter",{"$f":"INDEX(Table1[State],RANDBETWEEN(1,5))","v":"NY"},{"$f":"COUNTIF(INDEX([NName],1):Table2[[#This Row],[NName]],[NName])","v":2}]

{"sheet":"Test","index":1,"n_rows":39,"n_cols":3,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"NName","State"]
[null,"Daniel","AL"]
[null,"Paul","NY"]
[null,"Mark","WA"]
[null,"Donald","CA"]
[null,"George","CT"]
[null,"Kenneth"]
[null,"Steven"]
[null,"Edward"]
[null,"Brian"]
[null,"Ronald"]
[null,"Stephen"]
[null,"Andrew"]
[null,"Raymond"]
[null,"Gregory"]
[null,"Joshua"]
[null,"Jerry"]
[null,"Dennis"]
[null,"Walter"]
[null,"Patrick"]
[null,"Peter"]
[null,"Harold"]
[null,"Douglas"]
[null,"Henry"]
[null,"Carl"]
[null,"Arthur"]
[null,"Ryan"]
[null,"Roger"]
[null,"Joe"]
[null,"Juan"]
[null,"Jack"]
[null,"Albert"]
[null,"Jonathan"]
[null,"Justin"]
[null,"Terry"]
[null,"Gerald"]
[null,"Keith"]

{"sheet":"RR","index":2,"n_rows":102,"n_cols":11,"rows_kept":102,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Table4"]
[null,null,"NName","State","1","2","3","4","5","6","7"]
[null,null,"Albert","AL","AL","WA","CA","CT"]
[null,null,"Albert","WA","AL","WA","CA","CT"]
[null,null,"Albert","CA","AL","WA","CA","CT"]
[null,null,"Albert","CT","AL","WA","CA","CT"]
[null,null,"Andrew","AL","AL","NY","CA"]
[null,null,"Andrew","NY","AL","NY","CA"]
[null,null,"Andrew","CA","AL","NY","CA"]
[null,null,"Arthur","NY","NY","CA"]
[null,null,"Arthur","CA","NY","CA"]
[null,null,"Brian","WA","WA","AL","NY","CT","CA","TX"]
[null,null,"Brian","AL","WA","AL","NY","CT","CA","TX"]
[null,null,"Brian","NY","WA","AL","NY","CT","CA","TX"]
[null,null,"Brian","CT","WA","AL","NY","CT","CA","TX"]
[null,null,"Brian","CA","WA","AL","NY","CT","CA","TX"]
[null,null,"Brian","TX","WA","AL","NY","CT","CA","TX"]
[null,null,"Carl","AL","AL","CA"]
[null,null,"Carl","CA","AL","CA"]
[null,null,"Daniel","WA","WA","CA","AZ"]
[null,null,"Daniel","CA","WA","CA","AZ"]
[null,null,"Daniel","AZ","WA","CA","AZ"]
[null,null,"Dennis","OR","OR","AL","NY","NM"]
[null,null,"Dennis","AL","OR","AL","NY","NM"]
[null,null,"Dennis","NY","OR","AL","NY","NM"]
[null,null,"Dennis","NM","OR","AL","NY","NM"]
[null,null,"Donald","AL","AL","CT"]
[null,null,"Donald","CT","AL","CT"]
[null,null,"Douglas","AL","AL","CA"]
[null,null,"Douglas","CA","AL","CA"]
[null,null,"Edward","CA","CA","WA","AL"]
[null,null,"Edward","WA","CA","WA","AL"]
[null,null,"Edward","AL","CA","WA","AL"]
[null,null,"George","TX","TX","NY"]
[null,null,"George","NY","TX","NY"]
[null,null,"Gregory","CT","CT","WA","AZ"]
[null,null,"Gregory","WA","CT","WA","AZ"]
[null,null,"Gregory","AZ","CT","WA","AZ"]
[null,null,"Harold","AL","AL","CA","AZ","WA"]
[null,null,"Harold","CA","AL","CA","AZ","WA"]
[null,null,"Harold","AZ","AL","CA","AZ","WA"]
[null,null,"Harold","WA","AL","CA","AZ","WA"]
[null,null,"Henry","CA","CA","NY"]
[null,null,"Henry","NY","CA","NY"]
[null,null,"Jack","NY","NY","AZ"]
[null,null,"Jack","AZ","NY","AZ"]
[null,null,"Jerry","CT","CT","WA"]
[null,null,"Jerry","WA","CT","WA"]
[null,null,"Joe","CA","CA","CA"]
[null,null,"Joe","CA","CA","CA"]
[null,null,"Joshua","CA","CA","AZ","NM","OR"]
[null,null,"Joshua","AZ","CA","AZ","NM","OR"]
[null,null,"Joshua","NM","CA","AZ","NM","OR"]
[null,null,"Joshua","OR","CA","AZ","NM","OR"]
[null,null,"Juan","CA","CA","WA","AL"]
[null,null,"Juan","WA","CA","WA","AL"]
[null,null,"Juan","AL","CA","WA","AL"]
[null,null,"Justin","NY","NY","AL","CA"]
[null,null,"Justin","AL","NY","AL","CA"]
[null,null,"Justin","CA","NY","AL","CA"]
[null,null,"Keith","CA","CA","AL","NY","AZ","WA","NM"]
[null,null,"Keith","AL","CA","AL","NY","AZ","WA","NM"]
[null,null,"Keith","NY","CA","AL","NY","AZ","WA","NM"]
[null,null,"Keith","AZ","CA","AL","NY","AZ","WA","NM"]
[null,null,"Keith","WA","CA","AL","NY","AZ","WA","NM"]
[null,null,"Keith","NM","CA","AL","NY","AZ","WA","NM"]
[null,null,"Kenneth","NY","NY","CT"]
[null,null,"Kenneth","CT","NY","CT"]
[null,null,"Patrick","NJ","NJ","NY","CA","AZ"]
[null,null,"Patrick","NY","NJ","NY","CA","AZ"]
[null,null,"Patrick","CA","NJ","NY","CA","AZ"]
[null,null,"Patrick","AZ","NJ","NY","CA","AZ"]
[null,null,"Paul","NY","NY","CA","WA","AZ"]
[null,null,"Paul","CA","NY","CA","WA","AZ"]
[null,null,"Paul","WA","NY","CA","WA","AZ"]
[null,null,"Paul","AZ","NY","CA","WA","AZ"]
[null,null,"Peter","WA","WA","CT","CA"]
[null,null,"Peter","CT","WA","CT","CA"]
[null,null,"Peter","CA","WA","CT","CA"]
[null,null,"Raymond","NY","NY","CT"]
[null,null,"Raymond","CT","NY","CT"]
[null,null,"Roger","CT","CT","NY","NJ","WA"]
[null,null,"Roger","NY","CT","NY","NJ","WA"]
[null,null,"Roger","NJ","CT","NY","NJ","WA"]
[null,null,"Roger","WA","CT","NY","NJ","WA"]
[null,null,"Ronald","MA","MA","NY","CA","AL"]
[null,null,"Ronald","NY","MA","NY","CA","AL"]
[null,null,"Ronald","CA","MA","NY","CA","AL"]
[null,null,"Ronald","AL","MA","NY","CA","AL"]
[null,null,"Ryan","OR","OR","WA","CA"]
[null,null,"Ryan","WA","OR","WA","CA"]
[null,null,"Ryan","CA","OR","WA","CA"]
[null,null,"Stephen","AL","AL","CT"]
[null,null,"Stephen","CT","AL","CT"]
[null,null,"Steven","OR","OR","WA"]
[null,null,"Steven","WA","OR","WA"]
[null,null,"Terry","AL","AL","CA","OR","WA"]
[null,null,"Terry","CA","AL","CA","OR","WA"]
[null,null,"Terry","OR","AL","CA","OR","WA"]
[null,null,"Terry","WA","AL","CA","OR","WA"]
[null,null,"Walter","WA","WA"]