{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","Secret Santa"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Instructions","index":0,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[11,1,11,2],[1,1,1,2],[2,1,2,2]]}
[]
[null,"Introduction"]
[null,"This spreadsheet (including macro) makes it possible to automatically draw the names for your gift exchange. It's also possible to exclude certain draw combinations by assigning persons to a group as everyone is assigned a person of another group.\n\nPerfect for drawing names for family Christmas presents and avoid having to buy gifts for close relatives."]
[]
[null,"Step","Instruction"]
[null,1,"Unhide column C in tab 'Secret Santa'."]
[null,2,"Change names in column A and assign group number in column B in tab 'Secret Santa'."]
[null,3,"Hide column C again in tab 'Secret Santa'."]
[null,3,"If you have to add lines select line 29, click copy and finally insert copied lines in tab 'Secret Santa'. Do not start entering name in line 29; it will not work."]
[null,4,"Click button 'Click here' in tab 'Secret Santa' to find secret santas."]
[]
[null,"Important remarks"]
[null,1,"Do not remove line below last name. It contains formula."]
[null,2,"Do not remove hidden columns C, F, G, H, I."]

{"sheet":"Secret Santa","index":1,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"COUNTIF(B9:B199,\"<>\")+9","v":30}]
[]
[]
[]
[1,"Group 1 - Person 1",1,"buys a gift for ",{"$f":"VLOOKUP(I9,A:B,2,1)","v":"Group 2 - Person 7"},{"$f":"VLOOKUP(E9,B:C,2,0)","v":2},{"$f":"IF(C9=F9,1,0)","v":0},{"$f":"RAND()","v":0.74584313454267426},{"$f":"RANK(H9,$H$9:$H$29)","v":7}]
[2,"Group 1 - Person 2",1,"buys a gift for ","Group 4 - Person 19",4,0,0.1001263299484989,19]
[3,"Group 1 - Person 3",1,"buys a gift for ","Group 4 - Person 20",4,0,9.9415743852890981E-2,20]
[4,"Group 1 - Person 4",1,"buys a gift for ","Group 3 - Person 13",3,0,0.32525570758169908,13]
[5,"Group 1 - Person 5",1,"buys a gift for ","Group 3 - Person 16",3,0,0.25788951590102926,16]
[6,"Group 1 - Person 6",1,"buys a gift for ","Group 2 - Person 10",2,0,0.51545454427983795,10]
[7,"Group 2 - Person 7",2,"buys a gift for ","Group 4 - Person 20",4,0,{"$f":"RAND()","v":2.0527345508899897E-2},21]
[8,"Group 2 - Person 8",2,"buys a gift for ","Group 3 - Person 12",3,0,{"$f":"RAND()","v":0.41874211531824046},12]
[9,"Group 2 - Person 9",2,"buys a gift for ","Group 4 - Person 18",4,{"$f":"IF(C17=F17,1,0)","v":0},0.15124930685159999,18]
[9,"Group 2 - Person 9",2,"buys a gift for ","Group 2 - Person 8",2,1,0.70341967874483768,8]
[10,"Group 2 - Person 10",2,"buys a gift for ","Group 3 - Person 11",3,0,0.45867100428032481,11]
[11,"Group 3 - Person 11",3,"buys a gift for ","Group 1 - Person 6",1,0,0.75253552688069991,6]
[12,"Group 3 - Person 12",3,"buys a gift for ","Group 1 - Person 4",1,0,0.80067142166573058,4]
[13,"Group 3 - Person 13",3,"buys a gift for ","Group 3 - Person 14",3,1,0.31891749178319828,14]
[14,"Group 3 - Person 14",3,"buys a gift for ","Group 1 - Person 3",1,0,0.80094500990589468,3]
[15,"Group 3 - Person 15",3,"buys a gift for ","Group 2 - Person 9",2,0,0.6295284248212174,9]
[16,"Group 3 - Person 16",3,"buys a gift for ","Group 3 - Person 15",3,1,0.2762129418994872,15]
[17,"Group 4 - Person 17",4,"buys a gift for ","Group 4 - Person 17",4,1,0.25363790416615473,17]
[18,"Group 4 - Person 18",4,"buys a gift for ","Group 1 - Person 1",1,0,0.88292508148278748,1]
[19,"Group 4 - Person 19",4,"buys a gift for ","Group 1 - Person 2",1,0,0.81035216475381089,2]
[20,"Group 4 - Person 20",4,"buys a gift for ","Group 1 - Person 5",1,{"$f":"IF(C29=F29,1,0)","v":0},0.75570261388020965,5]
[null,null,null,null,null,null,{"$f":"SUM(G9:G29)","v":4}]