{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Weekly Picks","dev_notes","Schedule"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"Weekly Picks","index":0,"n_rows":110,"n_cols":41,"rows_kept":110,"cut":false,"hidden":false,"merged":[[9,17,9,18],[1,17,1,18],[4,23,9,23],[1,19,3,23]]}
["Week Lookup Column Offset",2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17]
[null,"GAME 1","GAME 2","GAME 3","GAME 4","GAME 5","GAME 6","GAME 7","GAME 8","GAME 9","GAME 10","GAME 11","GAME 12","GAME 13","GAME 14","GAME 15","GAME 16","SCORE",null,"Week 1"]
["VISITOR",{"$f":"IF(VLOOKUP($T$2&\" Visitors\",SCHEDULE_TABLE,B$1,FALSE)=0,\"\",VLOOKUP($T$2&\" Visitors\",SCHEDULE_TABLE,B$1,FALSE))","v":"GB"},"NO","CIN","BUF","WAS","TEN","NE","OAK","JAX","CLE","MIN","SF","CAR","IND","NYG","SD",null,"pts",null,null,null,null,null,"<----- Select the week and make your picks."]
[null,"at","at","at","at","at","at","at","at","at","at","at","at","at","at","at","at",null,null,null,null,null,null,null,"         Send them in to your pool administrator to copy"]
["HOME",{"$f":"IF(VLOOKUP($T$2&\" Homes\",SCHEDULE_TABLE,B$1,FALSE)=0,\"\",VLOOKUP($T$2&\" Homes\",SCHEDULE_TABLE,B$1,FALSE))","v":"SEA"},"ATL","BAL","CHI","HOU","KC","MIA","NYJ","PHI","PIT","STL","DAL","TB","DEN","DET","ARI",null,"pts",null,null,null,null,"TOTAL POINTS FOR YEAR","         and paste into the Master sheet."]
["WINNER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R3+R5=0,\"\",R3+R5)","v":""},"pts"]
[null,{"$f":"B3","v":"GB"},"NO","CIN","BUF","WAS","TEN","NE","OAK","JAX","CLE","MIN","SF","CAR","IND","NYG","SD"]
[null,{"$f":"B5","v":"SEA"},"ATL","BAL","CHI","HOU","KC","MIA","NYJ","PHI","PIT","STL","DAL","TB","DEN","DET","ARI"]
[]
["NAME","PICKS","PICKS","PICKS","PICKS","PICKS","PICKS","PICKS","PICKS","PICKS","PICKS","PICKS","PICKS","PICKS","PICKS","PICKS","PICKS","TIE-BREAK",null,"PICK PTS","PTS RANK","ABS DIFF","TIE-BREAK"]
["<Enter Participant 1>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",{"$f":"IF(SUM(Z11:AO11)=0,0,SUM(Z11:AO11))","v":0},{"$f":"IF(ISERROR(RANK(T11,$T$11:$T$85)),\"\",RANK(T11,$T$11:$T$85))","v":1},{"$f":"IF(ISBLANK(R11),\"\",IF(U11=1,ABS(R11-R$6),\"\"))","v":""},{"$f":"IF(ISERROR(RANK(V11,$V$11:$V$85,1)),\"\",RANK(V11,$V$11:$V$85,1))","v":""},{"$f":"IF(T11=\"\",0,T11)","v":0},null,{"$f":"IF(ISBLANK(B$6),\"\",IF(B11=B$6,1,0))","v":""},{"$f":"IF(ISBLANK(C$6),\"\",IF(C11=C$6,1,0))","v":""},{"$f":"IF(ISBLANK(D$6),\"\",IF(D11=D$6,1,0))","v":""},{"$f":"IF(ISBLANK(E$6),\"\",IF(E11=E$6,1,0))","v":""},{"$f":"IF(ISBLANK(F$6),\"\",IF(F11=F$6,1,0))","v":""},{"$f":"IF(ISBLANK(G$6),\"\",IF(G11=G$6,1,0))","v":""},{"$f":"IF(ISBLANK(H$6),\"\",IF(H11=H$6,1,0))","v":""},{"$f":"IF(ISBLANK(I$6),\"\",IF(I11=I$6,1,0))","v":""},{"$f":"IF(ISBLANK(J$6),\"\",IF(J11=J$6,1,0))","v":""},{"$f":"IF(ISBLANK(K$6),\"\",IF(K11=K$6,1,0))","v":""},{"$f":"IF(ISBLANK(L$6),\"\",IF(L11=L$6,1,0))","v":""},{"$f":"IF(ISBLANK(M$6),\"\",IF(M11=M$6,1,0))","v":""},{"$f":"IF(ISBLANK(N$6),\"\",IF(N11=N$6,1,0))","v":""},{"$f":"IF(ISBLANK(O$6),\"\",IF(O11=O$6,1,0))","v":""},{"$f":"IF(ISBLANK(P$6),\"\",IF(P11=P$6,1,0))","v":""},{"$f":"IF(ISBLANK(Q$6),\"\",IF(Q11=Q$6,1,0))","v":""}]
["<Enter Participant 2>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 3>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 4>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 5>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 6>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 7>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 8>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 9>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 10>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 11>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 12>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 13>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 14>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 15>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 16>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 17>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 18>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 19>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 20>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 21>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 22>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 23>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 24>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 25>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 26>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 27>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 28>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 29>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 30>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 31>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 32>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 33>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",{"$f":"IF(SUM(Z43:AO43)=0,0,SUM(Z43:AO43))","v":0},{"$f":"IF(ISERROR(RANK(T43,$T$11:$T$85)),\"\",RANK(T43,$T$11:$T$85))","v":1},{"$f":"IF(ISBLANK(R43),\"\",IF(U43=1,ABS(R43-R$6),\"\"))","v":""},{"$f":"IF(ISERROR(RANK(V43,$V$11:$V$85,1)),\"\",RANK(V43,$V$11:$V$85,1))","v":""},{"$f":"IF(T43=\"\",0,T43)","v":0},null,{"$f":"IF(ISBLANK(B$6),\"\",IF(B43=B$6,1,0))","v":""},{"$f":"IF(ISBLANK(C$6),\"\",IF(C43=C$6,1,0))","v":""},{"$f":"IF(ISBLANK(D$6),\"\",IF(D43=D$6,1,0))","v":""},{"$f":"IF(ISBLANK(E$6),\"\",IF(E43=E$6,1,0))","v":""},{"$f":"IF(ISBLANK(F$6),\"\",IF(F43=F$6,1,0))","v":""},{"$f":"IF(ISBLANK(G$6),\"\",IF(G43=G$6,1,0))","v":""},{"$f":"IF(ISBLANK(H$6),\"\",IF(H43=H$6,1,0))","v":""},{"$f":"IF(ISBLANK(I$6),\"\",IF(I43=I$6,1,0))","v":""},{"$f":"IF(ISBLANK(J$6),\"\",IF(J43=J$6,1,0))","v":""},{"$f":"IF(ISBLANK(K$6),\"\",IF(K43=K$6,1,0))","v":""},{"$f":"IF(ISBLANK(L$6),\"\",IF(L43=L$6,1,0))","v":""},{"$f":"IF(ISBLANK(M$6),\"\",IF(M43=M$6,1,0))","v":""},{"$f":"IF(ISBLANK(N$6),\"\",IF(N43=N$6,1,0))","v":""},{"$f":"IF(ISBLANK(O$6),\"\",IF(O43=O$6,1,0))","v":""},{"$f":"IF(ISBLANK(P$6),\"\",IF(P43=P$6,1,0))","v":""},{"$f":"IF(ISBLANK(Q$6),\"\",IF(Q43=Q$6,1,0))","v":""}]
["<Enter Participant 34>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 35>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 36>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 37>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 38>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 39>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 40>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 41>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 42>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 43>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 44>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 45>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 46>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 47>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 48>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 49>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 50>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 51>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 52>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 53>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 54>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 55>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 56>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 57>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 58>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 59>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 60>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 61>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 62>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 63>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 64>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 65>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",{"$f":"IF(SUM(Z75:AO75)=0,0,SUM(Z75:AO75))","v":0},{"$f":"IF(ISERROR(RANK(T75,$T$11:$T$85)),\"\",RANK(T75,$T$11:$T$85))","v":1},{"$f":"IF(ISBLANK(R75),\"\",IF(U75=1,ABS(R75-R$6),\"\"))","v":""},{"$f":"IF(ISERROR(RANK(V75,$V$11:$V$85,1)),\"\",RANK(V75,$V$11:$V$85,1))","v":""},{"$f":"IF(T75=\"\",0,T75)","v":0},null,{"$f":"IF(ISBLANK(B$6),\"\",IF(B75=B$6,1,0))","v":""},{"$f":"IF(ISBLANK(C$6),\"\",IF(C75=C$6,1,0))","v":""},{"$f":"IF(ISBLANK(D$6),\"\",IF(D75=D$6,1,0))","v":""},{"$f":"IF(ISBLANK(E$6),\"\",IF(E75=E$6,1,0))","v":""},{"$f":"IF(ISBLANK(F$6),\"\",IF(F75=F$6,1,0))","v":""},{"$f":"IF(ISBLANK(G$6),\"\",IF(G75=G$6,1,0))","v":""},{"$f":"IF(ISBLANK(H$6),\"\",IF(H75=H$6,1,0))","v":""},{"$f":"IF(ISBLANK(I$6),\"\",IF(I75=I$6,1,0))","v":""},{"$f":"IF(ISBLANK(J$6),\"\",IF(J75=J$6,1,0))","v":""},{"$f":"IF(ISBLANK(K$6),\"\",IF(K75=K$6,1,0))","v":""},{"$f":"IF(ISBLANK(L$6),\"\",IF(L75=L$6,1,0))","v":""},{"$f":"IF(ISBLANK(M$6),\"\",IF(M75=M$6,1,0))","v":""},{"$f":"IF(ISBLANK(N$6),\"\",IF(N75=N$6,1,0))","v":""},{"$f":"IF(ISBLANK(O$6),\"\",IF(O75=O$6,1,0))","v":""},{"$f":"IF(ISBLANK(P$6),\"\",IF(P75=P$6,1,0))","v":""},{"$f":"IF(ISBLANK(Q$6),\"\",IF(Q75=Q$6,1,0))","v":""}]
["<Enter Participant 66>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 67>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 68>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 69>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 70>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 71>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 72>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 73>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 74>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 75>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 76>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,{"$f":"IF(ISBLANK(B$6),\"\",IF(B86=B$6,1,0))","v":""},{"$f":"IF(ISBLANK(C$6),\"\",IF(C86=C$6,1,0))","v":""},{"$f":"IF(ISBLANK(D$6),\"\",IF(D86=D$6,1,0))","v":""},{"$f":"IF(ISBLANK(E$6),\"\",IF(E86=E$6,1,0))","v":""},{"$f":"IF(ISBLANK(F$6),\"\",IF(F86=F$6,1,0))","v":""},{"$f":"IF(ISBLANK(G$6),\"\",IF(G86=G$6,1,0))","v":""},{"$f":"IF(ISBLANK(H$6),\"\",IF(H86=H$6,1,0))","v":""},{"$f":"IF(ISBLANK(I$6),\"\",IF(I86=I$6,1,0))","v":""},{"$f":"IF(ISBLANK(J$6),\"\",IF(J86=J$6,1,0))","v":""},{"$f":"IF(ISBLANK(K$6),\"\",IF(K86=K$6,1,0))","v":""},{"$f":"IF(ISBLANK(L$6),\"\",IF(L86=L$6,1,0))","v":""},{"$f":"IF(ISBLANK(M$6),\"\",IF(M86=M$6,1,0))","v":""},{"$f":"IF(ISBLANK(N$6),\"\",IF(N86=N$6,1,0))","v":""},{"$f":"IF(ISBLANK(O$6),\"\",IF(O86=O$6,1,0))","v":""},{"$f":"IF(ISBLANK(P$6),\"\",IF(P86=P$6,1,0))","v":""},{"$f":"IF(ISBLANK(Q$6),\"\",IF(Q86=Q$6,1,0))","v":""}]
["<Enter Participant 77>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 78>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 79>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 80>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 81>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 82>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 83>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 84>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 85>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 86>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 87>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 88>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 89>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 90>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 91>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 92>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 93>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 94>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 95>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 96>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 97>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,{"$f":"IF(ISERROR(RANK(T107,$T$11:$T$85)),\"\",RANK(T107,$T$11:$T$85))","v":1},{"$f":"IF(ISBLANK(R107),\"\",IF(U107=1,ABS(R107-R$6),\"\"))","v":""},{"$f":"IF(ISERROR(RANK(V107,$V$11:$V$85,1)),\"\",RANK(V107,$V$11:$V$85,1))","v":""},0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 98>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 99>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]
["<Enter Participant 100>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pts",0,1,"","",0,null,"","","","","","","","","","","","","","","",""]

{"sheet":"dev_notes","index":1,"n_rows":73,"n_cols":5,"rows_kept":73,"cut":false,"hidden":true,"merged":[]}
[]
[null,"2014-2015 Enhancements"]
[]
[null,"make it so I can easily copy-paste whole lists/tables of picks"]
[null,"allow me to delete whole ranges of picks"]
[null,"conditional color formatting of the teams would be cool"]
[null,"make a participant picks sheet where they pick the week, and the games are filled out and they can pick their picks and send them in."]
[]
[null,"Backlog"]
[]
[null,"add in support for confidence points"]
[null,"add in support for picking against the spread"]
[]
[null,"Way Backlog"]
[]
[null,"figure out what historic spreads look like from a distribution standpoint, then have confidence points based on picks with or for the spread"]
[]
[null,"Reference Lists"]
[]
[null,null,"TEAM_LIST","Font","Background"]
[null,null,"ARI","white","148, 34, 60"]
[null,null,"ATL","red","black"]
[null,null,"BAL","230, 200, 88","36, 22, 100"]
[null,null,"BUF","204, 14, 44","4, 50, 140"]
[null,null,"CAR","212, 214, 212","4, 138, 212"]
[null,null,"CHI","255, 102, 0","5, 36, 71"]
[null,null,"CIN","black","244, 78, 36"]
[null,null,"CLE","252, 82, 20","60, 34, 12"]
[null,null,"DAL","15% grey","50% dark blue"]
[null,null,"DEN","252, 78, 4","20, 55, 98"]
[null,null,"DET","188, 198, 204","4, 106, 172"]
[null,null,"GB","244, 202, 5","36, 71, 41"]
[null,null,"HOU","white","4, 26, 52"]
[null,null,"IND","white","4, 58, 108"]
[null,null,"JAX","212, 186, 84","4, 126, 132"]
[null,null,"KC","244, 198, 4","192, 0, 0"]
[null,null,"MIA","white","25, 136, 144"]
[null,null,"MIN","244, 190, 4","60, 2, 95"]
[null,null,"NE","220, 222, 220","12, 34, 68"]
[null,null,"NO","196, 174, 116","black"]
[null,null,"NYG","white","28, 46, 108"]
[null,null,"NYJ","white","28, 50, 36"]
[null,null,"OAK","196, 202, 204","black"]
[null,null,"PHI","196, 198, 196","4, 58, 68"]
[null,null,"PIT","black","252, 182, 28"]
[null,null,"SD","252, 182, 28","4, 110, 204"]
[null,null,"SEA","100, 238, 62","4, 22, 44"]
[null,null,"SF","204, 174, 116","164, 30, 52"]
[null,null,"STL","204, 178, 116","12, 38, 76"]
[null,null,"TB","212, 10, 10","100, 89, 73"]
[null,null,"TEN","148, 177, 220","12, 38, 76"]
[null,null,"WAS","246, 199, 0","132, 0, 49"]
[]
[]
[]
[null,null,"WEEK_LIST"]
[null,null,"Week 1"]
[null,null,"Week 2"]
[null,null,"Week 3"]
[null,null,"Week 4"]
[null,null,"Week 5"]
[null,null,"Week 6"]
[null,null,"Week 7"]
[null,null,"Week 8"]
[null,null,"Week 9"]
[null,null,"Week 10"]
[null,null,"Week 11"]
[null,null,"Week 12"]
[null,null,"Week 13"]
[null,null,"Week 14"]
[null,null,"Week 15"]
[null,null,"Week 16"]
[null,null,"Week 17"]

{"sheet":"Schedule","index":2,"n_rows":68,"n_cols":18,"rows_kept":68,"cut":false,"hidden":true,"merged":[]}
[]
["Week 1",{"$f":"A2&\" Visitors\"","v":"Week 1 Visitors"},"GB","NO","CIN","BUF","WAS","TEN","NE","OAK","JAX","CLE","MIN","SF","CAR","IND","NYG","SD"]
[null,null,"at","at","at","at","at","at","at","at","at","at","at","at","at","at","at","at"]
[null,{"$f":"A2&\" Homes\"","v":"Week 1 Homes"},"SEA","ATL","BAL","CHI","HOU","KC","MIA","NYJ","PHI","PIT","STL","DAL","TB","DEN","DET","ARI"]
[]
["Week 2",{"$f":"A6&\" Visitors\"","v":"Week 2 Visitors"},"PIT","MIA","DET","ATL","NO","NE","ARI","DAL","JAX","SEA","STL","KC","NYJ","HOU","CHI","PHI"]
[null,null,"at","at","at","at","at","at","at","at","at","at","at","at","at","at","at","at"]
[null,{"$f":"A6&\" Homes\"","v":"Week 2 Homes"},"BAL","BUF","CAR","CIN","CLE","MIN","NYG","TEN","WAS","SD","TB","DEN","GB","OAK","SF","IND"]
[]
["Week 3",{"$f":"A10&\" Visitors\"","v":"Week 3 Visitors"},"TB","SD","TEN","BAL","GB","IND","OAK","MIN","HOU","WAS","DAL","SF","KC","DEN","PIT","CHI"]
[null,null,"at","at","at","at","at","at","at","at","at","at","at","at","at","at","at","at"]
[null,{"$f":"A10&\" Homes\"","v":"Week 3 Homes"},"ATL","BUF","CIN","CLE","DET","JAX","NE","NO","NYG","PHI","STL","ARI","MIA","SEA","CAR","NYJ"]
[]
["Week 4",{"$f":"A14&\" Visitors\"","v":"Week 4 Visitors"},"NYG","CAR","GB","BUF","TEN","ATL","DET","MIA","TB","JAX","PHI","NO","NE"]
[null,null,"at","at","at","at","at","at","at","at","at","at","at","at","at"]
[null,{"$f":"A14&\" Homes\"","v":"Week 4 Homes"},"WAS","BAL","CHI","HOU","IND","MIN","NYJ","OAK","PIT","SD","SF","DAL","KC"]
[]
["Week 5",{"$f":"A18&\" Visitors\"","v":"Week 5 Visitors"},"MIN","CHI","HOU","BUF","BAL","PIT","TB","ATL","STL","CLE","ARI","NYJ","KC","CIN","SEA"]
[null,null,"at","at","at","at","at","at","at","at","at","at","at","at","at","at","at"]
[null,{"$f":"A18&\" Homes\"","v":"Week 5 Homes"},"GB","CAR","DAL","DET","IND","JAX","NO","NYG","PHI","TEN","DEN","SD","SF","NE","WAS"]
[]
["Week 6",{"$f":"A22&\" Visitors\"","v":"Week 6 Visitors"},"IND","CHI","NE","CAR","PIT","GB","DET","DEN","BAL","JAX","SD","WAS","DAL","NYG","SF"]
[null,null,"at","at","at","at","at","at","at","at","at","at","at","at","at","at","at"]
[null,{"$f":"A22&\" Homes\"","v":"Week 6 Homes"},"HOU","ATL","BUF","CIN","CLE","MIA","MIN","NYJ","TB","TEN","OAK","ARI","SEA","PHI","STL"]
[]
["Week 7",{"$f":"A26&\" Visitors\"","v":"Week 7 Visitors"},"NYJ","ATL","MIN","MIA","NO","CAR","CIN","CLE","SEA","TEN","KC","NYG","ARI","SF","HOU"]
[null,null,"at","at","at","at","at","at","at","at","at","at","at","at","at","at","at"]
[null,{"$f":"A26&\" Homes\"","v":"Week 7 Homes"},"NE","BAL","BUF","CHI","DET","GB","IND","JAX","STL","WAS","SD","DAL","OAK","DEN","PIT"]
[]
["Week 8",{"$f":"A30&\" Visitors\"","v":"Week 8 Visitors"},"SD","DET","SEA","BAL","MIA","STL","CHI","BUF","MIN","HOU","PHI","OAK","IND","GB","WAS"]
[null,null,"at","at","at","at","at","at","at","at","at","at","at","at","at","at","at"]
[null,{"$f":"A30&\" Homes\"","v":"Week 8 Homes"},"DEN","ATL","CAR","CIN","JAX","KC","NE","NYJ","TB","TEN","ARI","CLE","PIT","NO","DAL"]
[]
["Week 9",{"$f":"A34&\" Visitors\"","v":"Week 9 Visitors"},"NO","JAX","TB","ARI","PHI","NYJ","SD","WAS","STL","DEN","OAK","BAL","IND"]
[null,null,"at","at","at","at","at","at","at","at","at","at","at","at","at"]
[null,{"$f":"A34&\" Homes\"","v":"Week 9 Homes"},"CAR","CIN","CLE","DAL","HOU","KC","MIA","MIN","SF","NE","SEA","PIT","NYG"]
[]
["Week 10",{"$f":"A38&\" Visitors\"","v":"Week 10 Visitors"},"CLE","TEN","KC","MIA","DAL","SF","PIT","ATL","DEN","STL","NYG","CHI","CAR"]
[null,null,"at","at","at","at","at","at","at","at","at","at","at","at","at"]
[null,{"$f":"A38&\" Homes\"","v":"Week 10 Homes"},"CIN","BAL","BUF","DET","JAX","NO","NYJ","TB","OAK","ARI","SEA","GB","PHI"]
[]
["Week 11",{"$f":"A42&\" Visitors\"","v":"Week 11 Visitors"},"BUF","ATL","MIN","HOU","PHI","SEA","CIN","SF","DEN","TB","OAK","DET","NE","PIT"]
[null,null,"at","at","at","at","at","at","at","at","at","at","at","at","at","at"]
[null,{"$f":"A42&\" Homes\"","v":"Week 11 Homes"},"MIA","CAR","CHI","CLE","GB","KC","NO","NYG","STL","WAS","SD","ARI","IND","TEN"]
[]
["Week 12",{"$f":"A46&\" Visitors\"","v":"Week 12 Visitors"},"KC","CLE","NYJ","TB","CIN","JAX","GB","DET","TEN","STL","ARI","MIA","WAS","DAL","BAL"]
[null,null,"at","at","at","at","at","at","at","at","at","at","at","at","at","at","at"]
[null,{"$f":"A46&\" Homes\"","v":"Week 12 Homes"},"OAK","ATL","BUF","CHI","HOU","IND","MIN","NE","PHI","SD","SEA","DEN","SF","NYG","NO"]
[]
["Week 13",{"$f":"A50&\" Visitors\"","v":"Week 13 Visitors"},"CHI","PHI","SEA","SD","CLE","TEN","WAS","NYG","CAR","NO","OAK","CIN","ARI","NE","DEN","MIA"]
[null,null,"at","at","at","at","at","at","at","at","at","at","at","at","at","at","at","at"]
[null,{"$f":"A50&\" Homes\"","v":"Week 13 Homes"},"DET","DAL","SF","BAL","BUF","HOU","IND","JAX","MIN","PIT","STL","TB","ATL","GB","KC","NYJ"]
[]
["Week 14",{"$f":"A54&\" Visitors\"","v":"Week 14 Visitors"},"DAL","PIT","IND","TB","HOU","BAL","NYJ","CAR","NYG","STL","KC","BUF","SF","SEA","NE","ATL"]
[null,null,"at","at","at","at","at","at","at","at","at","at","at","at","at","at","at","at"]
[null,{"$f":"A54&\" Homes\"","v":"Week 14 Homes"},"CHI","CIN","CLE","DET","JAX","MIA","MIN","NO","TEN","WAS","ARI","DEN","OAK","PHI","SD","GB"]
[]
["Week 15",{"$f":"A58&\" Visitors\"","v":"Week 15 Visitors"},"ARI","PIT","JAX","GB","TB","CIN","MIN","HOU","OAK","MIA","WAS","DEN","NYJ","SF","DAL","NO"]
[null,null,"at","at","at","at","at","at","at","at","at","at","at","at","at","at","at","at"]
[null,{"$f":"A58&\" Homes\"","v":"Week 15 Homes"},"STL","ATL","BAL","BUF","CAR","CLE","DET","IND","KC","NE","NYG","SD","TEN","SEA","PHI","CHI"]
[]
["Week 16",{"$f":"A62&\" Visitors\"","v":"Week 16 Visitors"},"TEN","SD","PHI","CLE","DET","BAL","MIN","ATL","NE","KC","GB","NYG","IND","BUF","SEA","DEN"]
[null,null,"at","at","at","at","at","at","at","at","at","at","at","at","at","at","at","at"]
[null,{"$f":"A62&\" Homes\"","v":"Week 16 Homes"},"JAX","SF","WAS","CAR","CHI","HOU","MIA","NO","NYJ","PIT","TB","STL","DAL","OAK","ARI","CIN"]
[]
["Week 17",{"$f":"A66&\" Visitors\"","v":"Week 17 Visitors"},"CAR","CLE","DET","JAX","SD","NYJ","CHI","BUF","PHI","CIN","NO","IND","DAL","OAK","ARI","STL"]
[null,null,"at","at","at","at","at","at","at","at","at","at","at","at","at","at","at","at"]
[null,{"$f":"A66&\" Homes\"","v":"Week 17 Homes"},"ATL","BAL","GB","HOU","KC","MIA","MIN","NE","NYG","PIT","TB","TEN","WAS","DEN","SF","SEA"]