{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["OHELL","Rules"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"OHELL","index":0,"n_rows":81,"n_cols":21,"rows_kept":81,"cut":false,"hidden":false,"merged":[[1,16,1,18]]}
[null,null,"Bidding","Scoring","<--1. Choose Bidding and Scoring options (see Rules sheet)"]
[null,null,"Dealer","Regular"," ",null,null,null,null,null,null,null,null,null,null,null,"<--2. Enter player names in\n        order of dealing ",null,null,null,"<--3. Enter name of first dealer"]
[null,"-","-",null,null,"-","-","-","-","-","-","-","-","-","-","-",null,{"$f":"IF(U3>0,MATCH(T2,OFFSET(E2:P2,0,0,1,U3),0),#N/A)","v":1},null,{"$f":"IF(D2=\"squared\",2,IF(D2=\"Tricks\",3,1))","v":1},{"$f":"COUNTA(E2:P2)","v":1}]
[null,{"$f":"IF(AND(NOT(ISNA($R$3)),B5<>\"\"),OFFSET($E$2,0,R4-1),\"\")","v":" "},{"$f":"IF(COUNT(E4:P4)=COUNTA($E$2:$P$2),IF(SUM(E4:P4)=B5,IF($C$2=\"Dealer\",\"Dealer\",\"OK\"),\"OK\"),\"\")","v":""},{"$f":"IF(B5>0,\"Bid\",\"\")","v":"Bid"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E4:P4)","v":0},{"$f":"+R3","v":1},null,7,"<--4. Enter number of cards to start (1-10)"]
[null,{"$f":"+T4","v":7},{"$f":"IF(AND(SUM(E5:P5)<>T4,COUNT(E5:P5)=COUNTA($E$2:$P$2)),\"Tricks\",IF(COUNT(E5:P5)=COUNTA($E$2:$P$2),\"OK\",\"\"))","v":""},{"$f":"IF(B5>0,\"Made\",\"\")","v":"Made"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E5:P5)","v":0}]
[null,{"$f":"IF(C4=\"OK\",IF(T4=Q4,\"Even\",IF(T4>Q4,\"Underbid\",\"Overbid\")),\"\")","v":""},{"$f":"IF(C4=\"OK\",+Q4-T4,\"\")","v":""},{"$f":"IF(B5>0,\"Score\",\"\")","v":"Score"},{"$f":"IF(OR(E$2=\" \",$B5=\"\",$Q5=0),\" \",IF($B5=$Q5,IF(E5=E4,0.00001+E2+10+E5^IF($T$3=2,2,1),IF($T$3=3,E5+E2,E2-ABS(E5-E4)))))","v":" "},{"$f":"IF(OR(F$2=\" \",$B5=\"\",$Q5=0),\" \",IF($B5=$Q5,IF(F5=F4,0.00001+F2+10+F5^IF($T$3=2,2,1),IF($T$3=3,F5+F2,F2-ABS(F5-F4)))))","v":" "}," "," "," "," "," "," "," "," "," "," ",{"$f":"SUM(E6:P6)","v":0}]
[null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,null,"Key to colors"]
[null,{"$f":"IF(AND(NOT(ISNA($R$3)),B9<>\"\"),OFFSET($E$2,0,R8-1),\"\")","v":" "},{"$f":"IF(COUNT(E8:P8)=COUNTA($E$2:$P$2),IF(SUM(E8:P8)=B9,IF($C$2=\"Dealer\",\"Dealer\",\"OK\"),\"OK\"),\"\")","v":""},{"$f":"IF(B9>0,\"Bid\",\"\")","v":"Bid"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E8:P8)","v":0},{"$f":"IF(R4=$U$3,1,R4+1)","v":1},"*","Dealer","Choose bidding method: Dealer or Everyone"]
[null,{"$f":"+T4-1","v":6},{"$f":"IF(AND(SUM(E9:P9)<>B9,COUNT(E9:P9)=COUNTA($E$2:$P$2)),\"Tricks\",IF(COUNT(E9:P9)=COUNTA($E$2:$P$2),\"OK\",\"\"))","v":""},{"$f":"IF(B9>0,\"Made\",\"\")","v":"Made"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E9:P9)","v":0},null,"*","Regular","Choose scoring method: Regular, Squared, or Tricks (see Rules sheet)"]
[null,{"$f":"IF(C8=\"OK\",IF(B9=Q8,\"Even\",IF(B9>Q8,\"Underbid\",\"Overbid\")),\"\")","v":""},{"$f":"IF(C8=\"OK\",+Q8-B9,\"\")","v":""},{"$f":"IF(B9>0,\"Score\",\"\")","v":"Score"},{"$f":"IF(OR(E$2=\" \",$B9=\"\",$Q9=0),\" \",IF($B9=$Q9,IF(E9=E8,0.00001+E6+10+E9^IF($T$3=2,2,1),IF($T$3=3,E9+E6,E6-ABS(E9-E8)))))","v":" "},{"$f":"IF(OR(F$2=\" \",$B9=\"\",$Q9=0),\" \",IF($B9=$Q9,IF(F9=F8,0.00001+F6+10+F9^IF($T$3=2,2,1),IF($T$3=3,F9+F6,F6-ABS(F9-F8)))))","v":" "},{"$f":"IF(OR(G$2=\" \",$B9=\"\",$Q9=0),\" \",IF($B9=$Q9,IF(G9=G8,0.00001+G6+10+G9^IF($T$3=2,2,1),IF($T$3=3,G9+G6,G6-ABS(G9-G8)))))","v":" "},{"$f":"IF(OR(H$2=\" \",$B9=\"\",$Q9=0),\" \",IF($B9=$Q9,IF(H9=H8,0.00001+H6+10+H9^IF($T$3=2,2,1),IF($T$3=3,H9+H6,H6-ABS(H9-H8)))))","v":" "},{"$f":"IF(OR(I$2=\" \",$B9=\"\",$Q9=0),\" \",IF($B9=$Q9,IF(I9=I8,0.00001+I6+10+I9^IF($T$3=2,2,1),IF($T$3=3,I9+I6,I6-ABS(I9-I8)))))","v":" "},{"$f":"IF(OR(J$2=\" \",$B9=\"\",$Q9=0),\" \",IF($B9=$Q9,IF(J9=J8,0.00001+J6+10+J9^IF($T$3=2,2,1),IF($T$3=3,J9+J6,J6-ABS(J9-J8)))))","v":" "},{"$f":"IF(OR(K$2=\" \",$B9=\"\",$Q9=0),\" \",IF($B9=$Q9,IF(K9=K8,0.00001+K6+10+K9^IF($T$3=2,2,1),IF($T$3=3,K9+K6,K6-ABS(K9-K8)))))","v":" "},{"$f":"IF(OR(L$2=\" \",$B9=\"\",$Q9=0),\" \",IF($B9=$Q9,IF(L9=L8,0.00001+L6+10+L9^IF($T$3=2,2,1),IF($T$3=3,L9+L6,L6-ABS(L9-L8)))))","v":" "},{"$f":"IF(OR(M$2=\" \",$B9=\"\",$Q9=0),\" \",IF($B9=$Q9,IF(M9=M8,0.00001+M6+10+M9^IF($T$3=2,2,1),IF($T$3=3,M9+M6,M6-ABS(M9-M8)))))","v":" "},{"$f":"IF(OR(N$2=\" \",$B9=\"\",$Q9=0),\" \",IF($B9=$Q9,IF(N9=N8,0.00001+N6+10+N9^IF($T$3=2,2,1),IF($T$3=3,N9+N6,N6-ABS(N9-N8)))))","v":" "},{"$f":"IF(OR(O$2=\" \",$B9=\"\",$Q9=0),\" \",IF($B9=$Q9,IF(O9=O8,0.00001+O6+10+O9^IF($T$3=2,2,1),IF($T$3=3,O9+O6,O6-ABS(O9-O8)))))","v":" "},{"$f":"IF(OR(P$2=\" \",$B9=\"\",$Q9=0),\" \",IF($B9=$Q9,IF(P9=P8,0.00001+P6+10+P9^IF($T$3=2,2,1),IF($T$3=3,P9+P6,P6-ABS(P9-P8)))))","v":" "},{"$f":"SUM(E10:P10)","v":0},null,"*","Roger","Enter player names"]
[null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,"*","Sid","Enter first dealer's name"]
[null,{"$f":"IF(AND(NOT(ISNA($R$3)),B13<>\"\"),OFFSET($E$2,0,R12-1),\"\")","v":" "},{"$f":"IF(COUNT(E12:P12)=COUNTA($E$2:$P$2),IF(SUM(E12:P12)=B13,IF($C$2=\"Dealer\",\"Dealer\",\"OK\"),\"OK\"),\"\")","v":""},{"$f":"IF(B13>0,\"Bid\",\"\")","v":"Bid"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E12:P12)","v":0},{"$f":"IF(R8=$U$3,1,R8+1)","v":1},null,"Art","Dealer for this hand"]
[null,{"$f":"IF(OR(B9=\"\",B9=$T$4),\"\",IF(B9>B5,B9+1,IF(B9=1,2,B9-1)))","v":5},{"$f":"IF(AND(SUM(E13:P13)<>B13,COUNT(E13:P13)=COUNTA($E$2:$P$2)),\"Tricks\",IF(COUNT(E13:P13)=COUNTA($E$2:$P$2),\"OK\",\"\"))","v":""},{"$f":"IF(B13>0,\"Made\",\"\")","v":"Made"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E13:P13)","v":0},null,"Bid","OK","Bids are OK"]
[null,{"$f":"IF(C12=\"OK\",IF(B13=Q12,\"Even\",IF(B13>Q12,\"Underbid\",\"Overbid\")),\"\")","v":""},{"$f":"IF(C12=\"OK\",+Q12-B13,\"\")","v":""},{"$f":"IF(B13>0,\"Score\",\"\")","v":"Score"},{"$f":"IF(OR(E$2=\" \",$B13=\"\",$Q13=0),\" \",IF($B13=$Q13,IF(E13=E12,0.00001+E10+10+E13^IF($T$3=2,2,1),IF($T$3=3,E13+E10,E10-ABS(E13-E12)))))","v":" "},{"$f":"IF(OR(F$2=\" \",$B13=\"\",$Q13=0),\" \",IF($B13=$Q13,IF(F13=F12,0.00001+F10+10+F13^IF($T$3=2,2,1),IF($T$3=3,F13+F10,F10-ABS(F13-F12)))))","v":" "},{"$f":"IF(OR(G$2=\" \",$B13=\"\",$Q13=0),\" \",IF($B13=$Q13,IF(G13=G12,0.00001+G10+10+G13^IF($T$3=2,2,1),IF($T$3=3,G13+G10,G10-ABS(G13-G12)))))","v":" "},{"$f":"IF(OR(H$2=\" \",$B13=\"\",$Q13=0),\" \",IF($B13=$Q13,IF(H13=H12,0.00001+H10+10+H13^IF($T$3=2,2,1),IF($T$3=3,H13+H10,H10-ABS(H13-H12)))))","v":" "},{"$f":"IF(OR(I$2=\" \",$B13=\"\",$Q13=0),\" \",IF($B13=$Q13,IF(I13=I12,0.00001+I10+10+I13^IF($T$3=2,2,1),IF($T$3=3,I13+I10,I10-ABS(I13-I12)))))","v":" "},{"$f":"IF(OR(J$2=\" \",$B13=\"\",$Q13=0),\" \",IF($B13=$Q13,IF(J13=J12,0.00001+J10+10+J13^IF($T$3=2,2,1),IF($T$3=3,J13+J10,J10-ABS(J13-J12)))))","v":" "},{"$f":"IF(OR(K$2=\" \",$B13=\"\",$Q13=0),\" \",IF($B13=$Q13,IF(K13=K12,0.00001+K10+10+K13^IF($T$3=2,2,1),IF($T$3=3,K13+K10,K10-ABS(K13-K12)))))","v":" "},{"$f":"IF(OR(L$2=\" \",$B13=\"\",$Q13=0),\" \",IF($B13=$Q13,IF(L13=L12,0.00001+L10+10+L13^IF($T$3=2,2,1),IF($T$3=3,L13+L10,L10-ABS(L13-L12)))))","v":" "},{"$f":"IF(OR(M$2=\" \",$B13=\"\",$Q13=0),\" \",IF($B13=$Q13,IF(M13=M12,0.00001+M10+10+M13^IF($T$3=2,2,1),IF($T$3=3,M13+M10,M10-ABS(M13-M12)))))","v":" "},{"$f":"IF(OR(N$2=\" \",$B13=\"\",$Q13=0),\" \",IF($B13=$Q13,IF(N13=N12,0.00001+N10+10+N13^IF($T$3=2,2,1),IF($T$3=3,N13+N10,N10-ABS(N13-N12)))))","v":" "},{"$f":"IF(OR(O$2=\" \",$B13=\"\",$Q13=0),\" \",IF($B13=$Q13,IF(O13=O12,0.00001+O10+10+O13^IF($T$3=2,2,1),IF($T$3=3,O13+O10,O10-ABS(O13-O12)))))","v":" "},{"$f":"IF(OR(P$2=\" \",$B13=\"\",$Q13=0),\" \",IF($B13=$Q13,IF(P13=P12,0.00001+P10+10+P13^IF($T$3=2,2,1),IF($T$3=3,P13+P10,P10-ABS(P13-P12)))))","v":" "},{"$f":"SUM(E14:P14)","v":0},null,"Bid","Dealer","Error: Dealer must change bid"]
[null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,"Made","OK","Tricks are OK"]
[null,{"$f":"IF(AND(NOT(ISNA($R$3)),B17<>\"\"),OFFSET($E$2,0,R16-1),\"\")","v":" "},{"$f":"IF(COUNT(E16:P16)=COUNTA($E$2:$P$2),IF(SUM(E16:P16)=B17,IF($C$2=\"Dealer\",\"Dealer\",\"OK\"),\"OK\"),\"\")","v":""},{"$f":"IF(B17>0,\"Bid\",\"\")","v":"Bid"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E16:P16)","v":0},{"$f":"IF(R12=$U$3,1,R12+1)","v":1},"Made","Tricks","Error: Total tricks must equal cards dealt"]
[null,{"$f":"IF(OR(B13=\"\",B13=$T$4),\"\",IF(B13>B9,B13+1,IF(B13=1,2,B13-1)))","v":4},{"$f":"IF(AND(SUM(E17:P17)<>B17,COUNT(E17:P17)=COUNTA($E$2:$P$2)),\"Tricks\",IF(COUNT(E17:P17)=COUNTA($E$2:$P$2),\"OK\",\"\"))","v":""},{"$f":"IF(B17>0,\"Made\",\"\")","v":"Made"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E17:P17)","v":0},null,"Bid*",null,"Enter number of tricks bid"]
[null,{"$f":"IF(C16=\"OK\",IF(B17=Q16,\"Even\",IF(B17>Q16,\"Underbid\",\"Overbid\")),\"\")","v":""},{"$f":"IF(C16=\"OK\",+Q16-B17,\"\")","v":""},{"$f":"IF(B17>0,\"Score\",\"\")","v":"Score"},{"$f":"IF(OR(E$2=\" \",$B17=\"\",$Q17=0),\" \",IF($B17=$Q17,IF(E17=E16,0.00001+E14+10+E17^IF($T$3=2,2,1),IF($T$3=3,E17+E14,E14-ABS(E17-E16)))))","v":" "},{"$f":"IF(OR(F$2=\" \",$B17=\"\",$Q17=0),\" \",IF($B17=$Q17,IF(F17=F16,0.00001+F14+10+F17^IF($T$3=2,2,1),IF($T$3=3,F17+F14,F14-ABS(F17-F16)))))","v":" "},{"$f":"IF(OR(G$2=\" \",$B17=\"\",$Q17=0),\" \",IF($B17=$Q17,IF(G17=G16,0.00001+G14+10+G17^IF($T$3=2,2,1),IF($T$3=3,G17+G14,G14-ABS(G17-G16)))))","v":" "},{"$f":"IF(OR(H$2=\" \",$B17=\"\",$Q17=0),\" \",IF($B17=$Q17,IF(H17=H16,0.00001+H14+10+H17^IF($T$3=2,2,1),IF($T$3=3,H17+H14,H14-ABS(H17-H16)))))","v":" "},{"$f":"IF(OR(I$2=\" \",$B17=\"\",$Q17=0),\" \",IF($B17=$Q17,IF(I17=I16,0.00001+I14+10+I17^IF($T$3=2,2,1),IF($T$3=3,I17+I14,I14-ABS(I17-I16)))))","v":" "},{"$f":"IF(OR(J$2=\" \",$B17=\"\",$Q17=0),\" \",IF($B17=$Q17,IF(J17=J16,0.00001+J14+10+J17^IF($T$3=2,2,1),IF($T$3=3,J17+J14,J14-ABS(J17-J16)))))","v":" "},{"$f":"IF(OR(K$2=\" \",$B17=\"\",$Q17=0),\" \",IF($B17=$Q17,IF(K17=K16,0.00001+K14+10+K17^IF($T$3=2,2,1),IF($T$3=3,K17+K14,K14-ABS(K17-K16)))))","v":" "},{"$f":"IF(OR(L$2=\" \",$B17=\"\",$Q17=0),\" \",IF($B17=$Q17,IF(L17=L16,0.00001+L14+10+L17^IF($T$3=2,2,1),IF($T$3=3,L17+L14,L14-ABS(L17-L16)))))","v":" "},{"$f":"IF(OR(M$2=\" \",$B17=\"\",$Q17=0),\" \",IF($B17=$Q17,IF(M17=M16,0.00001+M14+10+M17^IF($T$3=2,2,1),IF($T$3=3,M17+M14,M14-ABS(M17-M16)))))","v":" "},{"$f":"IF(OR(N$2=\" \",$B17=\"\",$Q17=0),\" \",IF($B17=$Q17,IF(N17=N16,0.00001+N14+10+N17^IF($T$3=2,2,1),IF($T$3=3,N17+N14,N14-ABS(N17-N16)))))","v":" "},{"$f":"IF(OR(O$2=\" \",$B17=\"\",$Q17=0),\" \",IF($B17=$Q17,IF(O17=O16,0.00001+O14+10+O17^IF($T$3=2,2,1),IF($T$3=3,O17+O14,O14-ABS(O17-O16)))))","v":" "},{"$f":"IF(OR(P$2=\" \",$B17=\"\",$Q17=0),\" \",IF($B17=$Q17,IF(P17=P16,0.00001+P14+10+P17^IF($T$3=2,2,1),IF($T$3=3,P17+P14,P14-ABS(P17-P16)))))","v":" "},{"$f":"SUM(E18:P18)","v":0},null,"Bid*","xx","Error: Bid must be between 0 and total number of cards in the hand"]
[null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,"Made*","xx","Enter number of tricks made (blue means bid made)"]
[null,{"$f":"IF(AND(NOT(ISNA($R$3)),B21<>\"\"),OFFSET($E$2,0,R20-1),\"\")","v":" "},{"$f":"IF(COUNT(E20:P20)=COUNTA($E$2:$P$2),IF(SUM(E20:P20)=B21,IF($C$2=\"Dealer\",\"Dealer\",\"OK\"),\"OK\"),\"\")","v":""},{"$f":"IF(B21>0,\"Bid\",\"\")","v":"Bid"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E20:P20)","v":0},{"$f":"IF(R16=$U$3,1,R16+1)","v":1},"Made*","xx","Enter number of tricks made (red means bid not made)"]
[null,{"$f":"IF(OR(B17=\"\",B17=$T$4),\"\",IF(B17>B13,B17+1,IF(B17=1,2,B17-1)))","v":3},{"$f":"IF(AND(SUM(E21:P21)<>B21,COUNT(E21:P21)=COUNTA($E$2:$P$2)),\"Tricks\",IF(COUNT(E21:P21)=COUNTA($E$2:$P$2),\"OK\",\"\"))","v":""},{"$f":"IF(B21>0,\"Made\",\"\")","v":"Made"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E21:P21)","v":0},null,"Score","xx","Player is trailing"]
[null,{"$f":"IF(C20=\"OK\",IF(B21=Q20,\"Even\",IF(B21>Q20,\"Underbid\",\"Overbid\")),\"\")","v":""},{"$f":"IF(C20=\"OK\",+Q20-B21,\"\")","v":""},{"$f":"IF(B21>0,\"Score\",\"\")","v":"Score"},{"$f":"IF(OR(E$2=\" \",$B21=\"\",$Q21=0),\" \",IF($B21=$Q21,IF(E21=E20,0.00001+E18+10+E21^IF($T$3=2,2,1),IF($T$3=3,E21+E18,E18-ABS(E21-E20)))))","v":" "},{"$f":"IF(OR(F$2=\" \",$B21=\"\",$Q21=0),\" \",IF($B21=$Q21,IF(F21=F20,0.00001+F18+10+F21^IF($T$3=2,2,1),IF($T$3=3,F21+F18,F18-ABS(F21-F20)))))","v":" "},{"$f":"IF(OR(G$2=\" \",$B21=\"\",$Q21=0),\" \",IF($B21=$Q21,IF(G21=G20,0.00001+G18+10+G21^IF($T$3=2,2,1),IF($T$3=3,G21+G18,G18-ABS(G21-G20)))))","v":" "},{"$f":"IF(OR(H$2=\" \",$B21=\"\",$Q21=0),\" \",IF($B21=$Q21,IF(H21=H20,0.00001+H18+10+H21^IF($T$3=2,2,1),IF($T$3=3,H21+H18,H18-ABS(H21-H20)))))","v":" "},{"$f":"IF(OR(I$2=\" \",$B21=\"\",$Q21=0),\" \",IF($B21=$Q21,IF(I21=I20,0.00001+I18+10+I21^IF($T$3=2,2,1),IF($T$3=3,I21+I18,I18-ABS(I21-I20)))))","v":" "},{"$f":"IF(OR(J$2=\" \",$B21=\"\",$Q21=0),\" \",IF($B21=$Q21,IF(J21=J20,0.00001+J18+10+J21^IF($T$3=2,2,1),IF($T$3=3,J21+J18,J18-ABS(J21-J20)))))","v":" "},{"$f":"IF(OR(K$2=\" \",$B21=\"\",$Q21=0),\" \",IF($B21=$Q21,IF(K21=K20,0.00001+K18+10+K21^IF($T$3=2,2,1),IF($T$3=3,K21+K18,K18-ABS(K21-K20)))))","v":" "},{"$f":"IF(OR(L$2=\" \",$B21=\"\",$Q21=0),\" \",IF($B21=$Q21,IF(L21=L20,0.00001+L18+10+L21^IF($T$3=2,2,1),IF($T$3=3,L21+L18,L18-ABS(L21-L20)))))","v":" "},{"$f":"IF(OR(M$2=\" \",$B21=\"\",$Q21=0),\" \",IF($B21=$Q21,IF(M21=M20,0.00001+M18+10+M21^IF($T$3=2,2,1),IF($T$3=3,M21+M18,M18-ABS(M21-M20)))))","v":" "},{"$f":"IF(OR(N$2=\" \",$B21=\"\",$Q21=0),\" \",IF($B21=$Q21,IF(N21=N20,0.00001+N18+10+N21^IF($T$3=2,2,1),IF($T$3=3,N21+N18,N18-ABS(N21-N20)))))","v":" "},{"$f":"IF(OR(O$2=\" \",$B21=\"\",$Q21=0),\" \",IF($B21=$Q21,IF(O21=O20,0.00001+O18+10+O21^IF($T$3=2,2,1),IF($T$3=3,O21+O18,O18-ABS(O21-O20)))))","v":" "},{"$f":"IF(OR(P$2=\" \",$B21=\"\",$Q21=0),\" \",IF($B21=$Q21,IF(P21=P20,0.00001+P18+10+P21^IF($T$3=2,2,1),IF($T$3=3,P21+P18,P18-ABS(P21-P20)))))","v":" "},{"$f":"SUM(E22:P22)","v":0},null,"Score","xx","Player is leading"]
[null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,"Score","xx","Player is not leading or trailing"]
[null,{"$f":"IF(AND(NOT(ISNA($R$3)),B25<>\"\"),OFFSET($E$2,0,R24-1),\"\")","v":" "},{"$f":"IF(COUNT(E24:P24)=COUNTA($E$2:$P$2),IF(SUM(E24:P24)=B25,IF($C$2=\"Dealer\",\"Dealer\",\"OK\"),\"OK\"),\"\")","v":""},{"$f":"IF(B25>0,\"Bid\",\"\")","v":"Bid"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E24:P24)","v":0},{"$f":"IF(R20=$U$3,1,R20+1)","v":1},null,"xx","Totals for hand"]
[null,{"$f":"IF(OR(B21=\"\",B21=$T$4),\"\",IF(B21>B17,B21+1,IF(B21=1,2,B21-1)))","v":2},{"$f":"IF(AND(SUM(E25:P25)<>B25,COUNT(E25:P25)=COUNTA($E$2:$P$2)),\"Tricks\",IF(COUNT(E25:P25)=COUNTA($E$2:$P$2),\"OK\",\"\"))","v":""},{"$f":"IF(B25>0,\"Made\",\"\")","v":"Made"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E25:P25)","v":0}]
[null,{"$f":"IF(C24=\"OK\",IF(B25=Q24,\"Even\",IF(B25>Q24,\"Underbid\",\"Overbid\")),\"\")","v":""},{"$f":"IF(C24=\"OK\",+Q24-B25,\"\")","v":""},{"$f":"IF(B25>0,\"Score\",\"\")","v":"Score"},{"$f":"IF(OR(E$2=\" \",$B25=\"\",$Q25=0),\" \",IF($B25=$Q25,IF(E25=E24,0.00001+E22+10+E25^IF($T$3=2,2,1),IF($T$3=3,E25+E22,E22-ABS(E25-E24)))))","v":" "},{"$f":"IF(OR(F$2=\" \",$B25=\"\",$Q25=0),\" \",IF($B25=$Q25,IF(F25=F24,0.00001+F22+10+F25^IF($T$3=2,2,1),IF($T$3=3,F25+F22,F22-ABS(F25-F24)))))","v":" "},{"$f":"IF(OR(G$2=\" \",$B25=\"\",$Q25=0),\" \",IF($B25=$Q25,IF(G25=G24,0.00001+G22+10+G25^IF($T$3=2,2,1),IF($T$3=3,G25+G22,G22-ABS(G25-G24)))))","v":" "},{"$f":"IF(OR(H$2=\" \",$B25=\"\",$Q25=0),\" \",IF($B25=$Q25,IF(H25=H24,0.00001+H22+10+H25^IF($T$3=2,2,1),IF($T$3=3,H25+H22,H22-ABS(H25-H24)))))","v":" "},{"$f":"IF(OR(I$2=\" \",$B25=\"\",$Q25=0),\" \",IF($B25=$Q25,IF(I25=I24,0.00001+I22+10+I25^IF($T$3=2,2,1),IF($T$3=3,I25+I22,I22-ABS(I25-I24)))))","v":" "},{"$f":"IF(OR(J$2=\" \",$B25=\"\",$Q25=0),\" \",IF($B25=$Q25,IF(J25=J24,0.00001+J22+10+J25^IF($T$3=2,2,1),IF($T$3=3,J25+J22,J22-ABS(J25-J24)))))","v":" "},{"$f":"IF(OR(K$2=\" \",$B25=\"\",$Q25=0),\" \",IF($B25=$Q25,IF(K25=K24,0.00001+K22+10+K25^IF($T$3=2,2,1),IF($T$3=3,K25+K22,K22-ABS(K25-K24)))))","v":" "},{"$f":"IF(OR(L$2=\" \",$B25=\"\",$Q25=0),\" \",IF($B25=$Q25,IF(L25=L24,0.00001+L22+10+L25^IF($T$3=2,2,1),IF($T$3=3,L25+L22,L22-ABS(L25-L24)))))","v":" "},{"$f":"IF(OR(M$2=\" \",$B25=\"\",$Q25=0),\" \",IF($B25=$Q25,IF(M25=M24,0.00001+M22+10+M25^IF($T$3=2,2,1),IF($T$3=3,M25+M22,M22-ABS(M25-M24)))))","v":" "},{"$f":"IF(OR(N$2=\" \",$B25=\"\",$Q25=0),\" \",IF($B25=$Q25,IF(N25=N24,0.00001+N22+10+N25^IF($T$3=2,2,1),IF($T$3=3,N25+N22,N22-ABS(N25-N24)))))","v":" "},{"$f":"IF(OR(O$2=\" \",$B25=\"\",$Q25=0),\" \",IF($B25=$Q25,IF(O25=O24,0.00001+O22+10+O25^IF($T$3=2,2,1),IF($T$3=3,O25+O22,O22-ABS(O25-O24)))))","v":" "},{"$f":"IF(OR(P$2=\" \",$B25=\"\",$Q25=0),\" \",IF($B25=$Q25,IF(P25=P24,0.00001+P22+10+P25^IF($T$3=2,2,1),IF($T$3=3,P25+P22,P22-ABS(P25-P24)))))","v":" "},{"$f":"SUM(E26:P26)","v":0},null,"*","You may enter data in these cells. All others are protected."]
[null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,{"$f":"IF(AND(NOT(ISNA($R$3)),B29<>\"\"),OFFSET($E$2,0,R28-1),\"\")","v":" "},{"$f":"IF(COUNT(E28:P28)=COUNTA($E$2:$P$2),IF(SUM(E28:P28)=B29,IF($C$2=\"Dealer\",\"Dealer\",\"OK\"),\"OK\"),\"\")","v":""},{"$f":"IF(B29>0,\"Bid\",\"\")","v":"Bid"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E28:P28)","v":0},{"$f":"IF(R24=$U$3,1,R24+1)","v":1},null,"Note: This workbook has one macro for clearing the spreadsheet. You do not have"]
[null,{"$f":"IF(OR(B25=\"\",B25=$T$4),\"\",IF(B25>B21,B25+1,IF(B25=1,2,B25-1)))","v":1},{"$f":"IF(AND(SUM(E29:P29)<>B29,COUNT(E29:P29)=COUNTA($E$2:$P$2)),\"Tricks\",IF(COUNT(E29:P29)=COUNTA($E$2:$P$2),\"OK\",\"\"))","v":""},{"$f":"IF(B29>0,\"Made\",\"\")","v":"Made"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E29:P29)","v":0},null,null,"to enable macros if you do not wish to use the Clear button. All other features"]
[null,{"$f":"IF(C28=\"OK\",IF(B29=Q28,\"Even\",IF(B29>Q28,\"Underbid\",\"Overbid\")),\"\")","v":""},{"$f":"IF(C28=\"OK\",+Q28-B29,\"\")","v":""},{"$f":"IF(B29>0,\"Score\",\"\")","v":"Score"},{"$f":"IF(OR(E$2=\" \",$B29=\"\",$Q29=0),\" \",IF($B29=$Q29,IF(E29=E28,0.00001+E26+10+E29^IF($T$3=2,2,1),IF($T$3=3,E29+E26,E26-ABS(E29-E28)))))","v":" "},{"$f":"IF(OR(F$2=\" \",$B29=\"\",$Q29=0),\" \",IF($B29=$Q29,IF(F29=F28,0.00001+F26+10+F29^IF($T$3=2,2,1),IF($T$3=3,F29+F26,F26-ABS(F29-F28)))))","v":" "},{"$f":"IF(OR(G$2=\" \",$B29=\"\",$Q29=0),\" \",IF($B29=$Q29,IF(G29=G28,0.00001+G26+10+G29^IF($T$3=2,2,1),IF($T$3=3,G29+G26,G26-ABS(G29-G28)))))","v":" "},{"$f":"IF(OR(H$2=\" \",$B29=\"\",$Q29=0),\" \",IF($B29=$Q29,IF(H29=H28,0.00001+H26+10+H29^IF($T$3=2,2,1),IF($T$3=3,H29+H26,H26-ABS(H29-H28)))))","v":" "},{"$f":"IF(OR(I$2=\" \",$B29=\"\",$Q29=0),\" \",IF($B29=$Q29,IF(I29=I28,0.00001+I26+10+I29^IF($T$3=2,2,1),IF($T$3=3,I29+I26,I26-ABS(I29-I28)))))","v":" "},{"$f":"IF(OR(J$2=\" \",$B29=\"\",$Q29=0),\" \",IF($B29=$Q29,IF(J29=J28,0.00001+J26+10+J29^IF($T$3=2,2,1),IF($T$3=3,J29+J26,J26-ABS(J29-J28)))))","v":" "},{"$f":"IF(OR(K$2=\" \",$B29=\"\",$Q29=0),\" \",IF($B29=$Q29,IF(K29=K28,0.00001+K26+10+K29^IF($T$3=2,2,1),IF($T$3=3,K29+K26,K26-ABS(K29-K28)))))","v":" "},{"$f":"IF(OR(L$2=\" \",$B29=\"\",$Q29=0),\" \",IF($B29=$Q29,IF(L29=L28,0.00001+L26+10+L29^IF($T$3=2,2,1),IF($T$3=3,L29+L26,L26-ABS(L29-L28)))))","v":" "},{"$f":"IF(OR(M$2=\" \",$B29=\"\",$Q29=0),\" \",IF($B29=$Q29,IF(M29=M28,0.00001+M26+10+M29^IF($T$3=2,2,1),IF($T$3=3,M29+M26,M26-ABS(M29-M28)))))","v":" "},{"$f":"IF(OR(N$2=\" \",$B29=\"\",$Q29=0),\" \",IF($B29=$Q29,IF(N29=N28,0.00001+N26+10+N29^IF($T$3=2,2,1),IF($T$3=3,N29+N26,N26-ABS(N29-N28)))))","v":" "},{"$f":"IF(OR(O$2=\" \",$B29=\"\",$Q29=0),\" \",IF($B29=$Q29,IF(O29=O28,0.00001+O26+10+O29^IF($T$3=2,2,1),IF($T$3=3,O29+O26,O26-ABS(O29-O28)))))","v":" "},{"$f":"IF(OR(P$2=\" \",$B29=\"\",$Q29=0),\" \",IF($B29=$Q29,IF(P29=P28,0.00001+P26+10+P29^IF($T$3=2,2,1),IF($T$3=3,P29+P26,P26-ABS(P29-P28)))))","v":" "},{"$f":"SUM(E30:P30)","v":0},null,null,"are implemented with formulas and formatting."]
[null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,{"$f":"IF(AND(NOT(ISNA($R$3)),B33<>\"\"),OFFSET($E$2,0,R32-1),\"\")","v":" "},{"$f":"IF(COUNT(E32:P32)=COUNTA($E$2:$P$2),IF(SUM(E32:P32)=B33,IF($C$2=\"Dealer\",\"Dealer\",\"OK\"),\"OK\"),\"\")","v":""},{"$f":"IF(B33>0,\"Bid\",\"\")","v":"Bid"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E32:P32)","v":0},{"$f":"IF(R28=$U$3,1,R28+1)","v":1}]
[null,{"$f":"IF(OR(B29=\"\",B29=$T$4),\"\",IF(B29>B25,B29+1,IF(B29=1,2,B29-1)))","v":2},{"$f":"IF(AND(SUM(E33:P33)<>B33,COUNT(E33:P33)=COUNTA($E$2:$P$2)),\"Tricks\",IF(COUNT(E33:P33)=COUNTA($E$2:$P$2),\"OK\",\"\"))","v":""},{"$f":"IF(B33>0,\"Made\",\"\")","v":"Made"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E33:P33)","v":0}]
[null,{"$f":"IF(C32=\"OK\",IF(B33=Q32,\"Even\",IF(B33>Q32,\"Underbid\",\"Overbid\")),\"\")","v":""},{"$f":"IF(C32=\"OK\",+Q32-B33,\"\")","v":""},{"$f":"IF(B33>0,\"Score\",\"\")","v":"Score"},{"$f":"IF(OR(E$2=\" \",$B33=\"\",$Q33=0),\" \",IF($B33=$Q33,IF(E33=E32,0.00001+E30+10+E33^IF($T$3=2,2,1),IF($T$3=3,E33+E30,E30-ABS(E33-E32)))))","v":" "},{"$f":"IF(OR(F$2=\" \",$B33=\"\",$Q33=0),\" \",IF($B33=$Q33,IF(F33=F32,0.00001+F30+10+F33^IF($T$3=2,2,1),IF($T$3=3,F33+F30,F30-ABS(F33-F32)))))","v":" "},{"$f":"IF(OR(G$2=\" \",$B33=\"\",$Q33=0),\" \",IF($B33=$Q33,IF(G33=G32,0.00001+G30+10+G33^IF($T$3=2,2,1),IF($T$3=3,G33+G30,G30-ABS(G33-G32)))))","v":" "},{"$f":"IF(OR(H$2=\" \",$B33=\"\",$Q33=0),\" \",IF($B33=$Q33,IF(H33=H32,0.00001+H30+10+H33^IF($T$3=2,2,1),IF($T$3=3,H33+H30,H30-ABS(H33-H32)))))","v":" "},{"$f":"IF(OR(I$2=\" \",$B33=\"\",$Q33=0),\" \",IF($B33=$Q33,IF(I33=I32,0.00001+I30+10+I33^IF($T$3=2,2,1),IF($T$3=3,I33+I30,I30-ABS(I33-I32)))))","v":" "},{"$f":"IF(OR(J$2=\" \",$B33=\"\",$Q33=0),\" \",IF($B33=$Q33,IF(J33=J32,0.00001+J30+10+J33^IF($T$3=2,2,1),IF($T$3=3,J33+J30,J30-ABS(J33-J32)))))","v":" "},{"$f":"IF(OR(K$2=\" \",$B33=\"\",$Q33=0),\" \",IF($B33=$Q33,IF(K33=K32,0.00001+K30+10+K33^IF($T$3=2,2,1),IF($T$3=3,K33+K30,K30-ABS(K33-K32)))))","v":" "},{"$f":"IF(OR(L$2=\" \",$B33=\"\",$Q33=0),\" \",IF($B33=$Q33,IF(L33=L32,0.00001+L30+10+L33^IF($T$3=2,2,1),IF($T$3=3,L33+L30,L30-ABS(L33-L32)))))","v":" "},{"$f":"IF(OR(M$2=\" \",$B33=\"\",$Q33=0),\" \",IF($B33=$Q33,IF(M33=M32,0.00001+M30+10+M33^IF($T$3=2,2,1),IF($T$3=3,M33+M30,M30-ABS(M33-M32)))))","v":" "},{"$f":"IF(OR(N$2=\" \",$B33=\"\",$Q33=0),\" \",IF($B33=$Q33,IF(N33=N32,0.00001+N30+10+N33^IF($T$3=2,2,1),IF($T$3=3,N33+N30,N30-ABS(N33-N32)))))","v":" "},{"$f":"IF(OR(O$2=\" \",$B33=\"\",$Q33=0),\" \",IF($B33=$Q33,IF(O33=O32,0.00001+O30+10+O33^IF($T$3=2,2,1),IF($T$3=3,O33+O30,O30-ABS(O33-O32)))))","v":" "},{"$f":"IF(OR(P$2=\" \",$B33=\"\",$Q33=0),\" \",IF($B33=$Q33,IF(P33=P32,0.00001+P30+10+P33^IF($T$3=2,2,1),IF($T$3=3,P33+P30,P30-ABS(P33-P32)))))","v":" "},{"$f":"SUM(E34:P34)","v":0}]
[null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,{"$f":"IF(AND(NOT(ISNA($R$3)),B37<>\"\"),OFFSET($E$2,0,R36-1),\"\")","v":" "},{"$f":"IF(COUNT(E36:P36)=COUNTA($E$2:$P$2),IF(SUM(E36:P36)=B37,IF($C$2=\"Dealer\",\"Dealer\",\"OK\"),\"OK\"),\"\")","v":""},{"$f":"IF(B37>0,\"Bid\",\"\")","v":"Bid"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E36:P36)","v":0},{"$f":"IF(R32=$U$3,1,R32+1)","v":1}]
[null,{"$f":"IF(OR(B33=\"\",B33=$T$4),\"\",IF(B33>B29,B33+1,IF(B33=1,2,B33-1)))","v":3},{"$f":"IF(AND(SUM(E37:P37)<>B37,COUNT(E37:P37)=COUNTA($E$2:$P$2)),\"Tricks\",IF(COUNT(E37:P37)=COUNTA($E$2:$P$2),\"OK\",\"\"))","v":""},{"$f":"IF(B37>0,\"Made\",\"\")","v":"Made"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E37:P37)","v":0}]
[null,{"$f":"IF(C36=\"OK\",IF(B37=Q36,\"Even\",IF(B37>Q36,\"Underbid\",\"Overbid\")),\"\")","v":""},{"$f":"IF(C36=\"OK\",+Q36-B37,\"\")","v":""},{"$f":"IF(B37>0,\"Score\",\"\")","v":"Score"},{"$f":"IF(OR(E$2=\" \",$B37=\"\",$Q37=0),\" \",IF($B37=$Q37,IF(E37=E36,0.00001+E34+10+E37^IF($T$3=2,2,1),IF($T$3=3,E37+E34,E34-ABS(E37-E36)))))","v":" "},{"$f":"IF(OR(F$2=\" \",$B37=\"\",$Q37=0),\" \",IF($B37=$Q37,IF(F37=F36,0.00001+F34+10+F37^IF($T$3=2,2,1),IF($T$3=3,F37+F34,F34-ABS(F37-F36)))))","v":" "},{"$f":"IF(OR(G$2=\" \",$B37=\"\",$Q37=0),\" \",IF($B37=$Q37,IF(G37=G36,0.00001+G34+10+G37^IF($T$3=2,2,1),IF($T$3=3,G37+G34,G34-ABS(G37-G36)))))","v":" "},{"$f":"IF(OR(H$2=\" \",$B37=\"\",$Q37=0),\" \",IF($B37=$Q37,IF(H37=H36,0.00001+H34+10+H37^IF($T$3=2,2,1),IF($T$3=3,H37+H34,H34-ABS(H37-H36)))))","v":" "},{"$f":"IF(OR(I$2=\" \",$B37=\"\",$Q37=0),\" \",IF($B37=$Q37,IF(I37=I36,0.00001+I34+10+I37^IF($T$3=2,2,1),IF($T$3=3,I37+I34,I34-ABS(I37-I36)))))","v":" "},{"$f":"IF(OR(J$2=\" \",$B37=\"\",$Q37=0),\" \",IF($B37=$Q37,IF(J37=J36,0.00001+J34+10+J37^IF($T$3=2,2,1),IF($T$3=3,J37+J34,J34-ABS(J37-J36)))))","v":" "},{"$f":"IF(OR(K$2=\" \",$B37=\"\",$Q37=0),\" \",IF($B37=$Q37,IF(K37=K36,0.00001+K34+10+K37^IF($T$3=2,2,1),IF($T$3=3,K37+K34,K34-ABS(K37-K36)))))","v":" "},{"$f":"IF(OR(L$2=\" \",$B37=\"\",$Q37=0),\" \",IF($B37=$Q37,IF(L37=L36,0.00001+L34+10+L37^IF($T$3=2,2,1),IF($T$3=3,L37+L34,L34-ABS(L37-L36)))))","v":" "},{"$f":"IF(OR(M$2=\" \",$B37=\"\",$Q37=0),\" \",IF($B37=$Q37,IF(M37=M36,0.00001+M34+10+M37^IF($T$3=2,2,1),IF($T$3=3,M37+M34,M34-ABS(M37-M36)))))","v":" "},{"$f":"IF(OR(N$2=\" \",$B37=\"\",$Q37=0),\" \",IF($B37=$Q37,IF(N37=N36,0.00001+N34+10+N37^IF($T$3=2,2,1),IF($T$3=3,N37+N34,N34-ABS(N37-N36)))))","v":" "},{"$f":"IF(OR(O$2=\" \",$B37=\"\",$Q37=0),\" \",IF($B37=$Q37,IF(O37=O36,0.00001+O34+10+O37^IF($T$3=2,2,1),IF($T$3=3,O37+O34,O34-ABS(O37-O36)))))","v":" "},{"$f":"IF(OR(P$2=\" \",$B37=\"\",$Q37=0),\" \",IF($B37=$Q37,IF(P37=P36,0.00001+P34+10+P37^IF($T$3=2,2,1),IF($T$3=3,P37+P34,P34-ABS(P37-P36)))))","v":" "},{"$f":"SUM(E38:P38)","v":0}]
[null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,{"$f":"IF(AND(NOT(ISNA($R$3)),B41<>\"\"),OFFSET($E$2,0,R40-1),\"\")","v":" "},{"$f":"IF(COUNT(E40:P40)=COUNTA($E$2:$P$2),IF(SUM(E40:P40)=B41,IF($C$2=\"Dealer\",\"Dealer\",\"OK\"),\"OK\"),\"\")","v":""},{"$f":"IF(B41>0,\"Bid\",\"\")","v":"Bid"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E40:P40)","v":0},{"$f":"IF(R36=$U$3,1,R36+1)","v":1}]
[null,{"$f":"IF(OR(B37=\"\",B37=$T$4),\"\",IF(B37>B33,B37+1,IF(B37=1,2,B37-1)))","v":4},{"$f":"IF(AND(SUM(E41:P41)<>B41,COUNT(E41:P41)=COUNTA($E$2:$P$2)),\"Tricks\",IF(COUNT(E41:P41)=COUNTA($E$2:$P$2),\"OK\",\"\"))","v":""},{"$f":"IF(B41>0,\"Made\",\"\")","v":"Made"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E41:P41)","v":0}]
[null,{"$f":"IF(C40=\"OK\",IF(B41=Q40,\"Even\",IF(B41>Q40,\"Underbid\",\"Overbid\")),\"\")","v":""},{"$f":"IF(C40=\"OK\",+Q40-B41,\"\")","v":""},{"$f":"IF(B41>0,\"Score\",\"\")","v":"Score"},{"$f":"IF(OR(E$2=\" \",$B41=\"\",$Q41=0),\" \",IF($B41=$Q41,IF(E41=E40,0.00001+E38+10+E41^IF($T$3=2,2,1),IF($T$3=3,E41+E38,E38-ABS(E41-E40)))))","v":" "},{"$f":"IF(OR(F$2=\" \",$B41=\"\",$Q41=0),\" \",IF($B41=$Q41,IF(F41=F40,0.00001+F38+10+F41^IF($T$3=2,2,1),IF($T$3=3,F41+F38,F38-ABS(F41-F40)))))","v":" "},{"$f":"IF(OR(G$2=\" \",$B41=\"\",$Q41=0),\" \",IF($B41=$Q41,IF(G41=G40,0.00001+G38+10+G41^IF($T$3=2,2,1),IF($T$3=3,G41+G38,G38-ABS(G41-G40)))))","v":" "},{"$f":"IF(OR(H$2=\" \",$B41=\"\",$Q41=0),\" \",IF($B41=$Q41,IF(H41=H40,0.00001+H38+10+H41^IF($T$3=2,2,1),IF($T$3=3,H41+H38,H38-ABS(H41-H40)))))","v":" "},{"$f":"IF(OR(I$2=\" \",$B41=\"\",$Q41=0),\" \",IF($B41=$Q41,IF(I41=I40,0.00001+I38+10+I41^IF($T$3=2,2,1),IF($T$3=3,I41+I38,I38-ABS(I41-I40)))))","v":" "},{"$f":"IF(OR(J$2=\" \",$B41=\"\",$Q41=0),\" \",IF($B41=$Q41,IF(J41=J40,0.00001+J38+10+J41^IF($T$3=2,2,1),IF($T$3=3,J41+J38,J38-ABS(J41-J40)))))","v":" "},{"$f":"IF(OR(K$2=\" \",$B41=\"\",$Q41=0),\" \",IF($B41=$Q41,IF(K41=K40,0.00001+K38+10+K41^IF($T$3=2,2,1),IF($T$3=3,K41+K38,K38-ABS(K41-K40)))))","v":" "},{"$f":"IF(OR(L$2=\" \",$B41=\"\",$Q41=0),\" \",IF($B41=$Q41,IF(L41=L40,0.00001+L38+10+L41^IF($T$3=2,2,1),IF($T$3=3,L41+L38,L38-ABS(L41-L40)))))","v":" "},{"$f":"IF(OR(M$2=\" \",$B41=\"\",$Q41=0),\" \",IF($B41=$Q41,IF(M41=M40,0.00001+M38+10+M41^IF($T$3=2,2,1),IF($T$3=3,M41+M38,M38-ABS(M41-M40)))))","v":" "},{"$f":"IF(OR(N$2=\" \",$B41=\"\",$Q41=0),\" \",IF($B41=$Q41,IF(N41=N40,0.00001+N38+10+N41^IF($T$3=2,2,1),IF($T$3=3,N41+N38,N38-ABS(N41-N40)))))","v":" "},{"$f":"IF(OR(O$2=\" \",$B41=\"\",$Q41=0),\" \",IF($B41=$Q41,IF(O41=O40,0.00001+O38+10+O41^IF($T$3=2,2,1),IF($T$3=3,O41+O38,O38-ABS(O41-O40)))))","v":" "},{"$f":"IF(OR(P$2=\" \",$B41=\"\",$Q41=0),\" \",IF($B41=$Q41,IF(P41=P40,0.00001+P38+10+P41^IF($T$3=2,2,1),IF($T$3=3,P41+P38,P38-ABS(P41-P40)))))","v":" "},{"$f":"SUM(E42:P42)","v":0}]
[null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,{"$f":"IF(AND(NOT(ISNA($R$3)),B45<>\"\"),OFFSET($E$2,0,R44-1),\"\")","v":" "},{"$f":"IF(COUNT(E44:P44)=COUNTA($E$2:$P$2),IF(SUM(E44:P44)=B45,IF($C$2=\"Dealer\",\"Dealer\",\"OK\"),\"OK\"),\"\")","v":""},{"$f":"IF(B45>0,\"Bid\",\"\")","v":"Bid"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E44:P44)","v":0},{"$f":"IF(R40=$U$3,1,R40+1)","v":1}]
[null,{"$f":"IF(OR(B41=\"\",B41=$T$4),\"\",IF(B41>B37,B41+1,IF(B41=1,2,B41-1)))","v":5},{"$f":"IF(AND(SUM(E45:P45)<>B45,COUNT(E45:P45)=COUNTA($E$2:$P$2)),\"Tricks\",IF(COUNT(E45:P45)=COUNTA($E$2:$P$2),\"OK\",\"\"))","v":""},{"$f":"IF(B45>0,\"Made\",\"\")","v":"Made"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E45:P45)","v":0}]
[null,{"$f":"IF(C44=\"OK\",IF(B45=Q44,\"Even\",IF(B45>Q44,\"Underbid\",\"Overbid\")),\"\")","v":""},{"$f":"IF(C44=\"OK\",+Q44-B45,\"\")","v":""},{"$f":"IF(B45>0,\"Score\",\"\")","v":"Score"},{"$f":"IF(OR(E$2=\" \",$B45=\"\",$Q45=0),\" \",IF($B45=$Q45,IF(E45=E44,0.00001+E42+10+E45^IF($T$3=2,2,1),IF($T$3=3,E45+E42,E42-ABS(E45-E44)))))","v":" "},{"$f":"IF(OR(F$2=\" \",$B45=\"\",$Q45=0),\" \",IF($B45=$Q45,IF(F45=F44,0.00001+F42+10+F45^IF($T$3=2,2,1),IF($T$3=3,F45+F42,F42-ABS(F45-F44)))))","v":" "},{"$f":"IF(OR(G$2=\" \",$B45=\"\",$Q45=0),\" \",IF($B45=$Q45,IF(G45=G44,0.00001+G42+10+G45^IF($T$3=2,2,1),IF($T$3=3,G45+G42,G42-ABS(G45-G44)))))","v":" "},{"$f":"IF(OR(H$2=\" \",$B45=\"\",$Q45=0),\" \",IF($B45=$Q45,IF(H45=H44,0.00001+H42+10+H45^IF($T$3=2,2,1),IF($T$3=3,H45+H42,H42-ABS(H45-H44)))))","v":" "},{"$f":"IF(OR(I$2=\" \",$B45=\"\",$Q45=0),\" \",IF($B45=$Q45,IF(I45=I44,0.00001+I42+10+I45^IF($T$3=2,2,1),IF($T$3=3,I45+I42,I42-ABS(I45-I44)))))","v":" "},{"$f":"IF(OR(J$2=\" \",$B45=\"\",$Q45=0),\" \",IF($B45=$Q45,IF(J45=J44,0.00001+J42+10+J45^IF($T$3=2,2,1),IF($T$3=3,J45+J42,J42-ABS(J45-J44)))))","v":" "},{"$f":"IF(OR(K$2=\" \",$B45=\"\",$Q45=0),\" \",IF($B45=$Q45,IF(K45=K44,0.00001+K42+10+K45^IF($T$3=2,2,1),IF($T$3=3,K45+K42,K42-ABS(K45-K44)))))","v":" "},{"$f":"IF(OR(L$2=\" \",$B45=\"\",$Q45=0),\" \",IF($B45=$Q45,IF(L45=L44,0.00001+L42+10+L45^IF($T$3=2,2,1),IF($T$3=3,L45+L42,L42-ABS(L45-L44)))))","v":" "},{"$f":"IF(OR(M$2=\" \",$B45=\"\",$Q45=0),\" \",IF($B45=$Q45,IF(M45=M44,0.00001+M42+10+M45^IF($T$3=2,2,1),IF($T$3=3,M45+M42,M42-ABS(M45-M44)))))","v":" "},{"$f":"IF(OR(N$2=\" \",$B45=\"\",$Q45=0),\" \",IF($B45=$Q45,IF(N45=N44,0.00001+N42+10+N45^IF($T$3=2,2,1),IF($T$3=3,N45+N42,N42-ABS(N45-N44)))))","v":" "},{"$f":"IF(OR(O$2=\" \",$B45=\"\",$Q45=0),\" \",IF($B45=$Q45,IF(O45=O44,0.00001+O42+10+O45^IF($T$3=2,2,1),IF($T$3=3,O45+O42,O42-ABS(O45-O44)))))","v":" "},{"$f":"IF(OR(P$2=\" \",$B45=\"\",$Q45=0),\" \",IF($B45=$Q45,IF(P45=P44,0.00001+P42+10+P45^IF($T$3=2,2,1),IF($T$3=3,P45+P42,P42-ABS(P45-P44)))))","v":" "},{"$f":"SUM(E46:P46)","v":0}]
[null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,{"$f":"IF(AND(NOT(ISNA($R$3)),B49<>\"\"),OFFSET($E$2,0,R48-1),\"\")","v":" "},{"$f":"IF(COUNT(E48:P48)=COUNTA($E$2:$P$2),IF(SUM(E48:P48)=B49,IF($C$2=\"Dealer\",\"Dealer\",\"OK\"),\"OK\"),\"\")","v":""},{"$f":"IF(B49>0,\"Bid\",\"\")","v":"Bid"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E48:P48)","v":0},{"$f":"IF(R44=$U$3,1,R44+1)","v":1}]
[null,{"$f":"IF(OR(B45=\"\",B45=$T$4),\"\",IF(B45>B41,B45+1,IF(B45=1,2,B45-1)))","v":6},{"$f":"IF(AND(SUM(E49:P49)<>B49,COUNT(E49:P49)=COUNTA($E$2:$P$2)),\"Tricks\",IF(COUNT(E49:P49)=COUNTA($E$2:$P$2),\"OK\",\"\"))","v":""},{"$f":"IF(B49>0,\"Made\",\"\")","v":"Made"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E49:P49)","v":0}]
[null,{"$f":"IF(C48=\"OK\",IF(B49=Q48,\"Even\",IF(B49>Q48,\"Underbid\",\"Overbid\")),\"\")","v":""},{"$f":"IF(C48=\"OK\",+Q48-B49,\"\")","v":""},{"$f":"IF(B49>0,\"Score\",\"\")","v":"Score"},{"$f":"IF(OR(E$2=\" \",$B49=\"\",$Q49=0),\" \",IF($B49=$Q49,IF(E49=E48,0.00001+E46+10+E49^IF($T$3=2,2,1),IF($T$3=3,E49+E46,E46-ABS(E49-E48)))))","v":" "},{"$f":"IF(OR(F$2=\" \",$B49=\"\",$Q49=0),\" \",IF($B49=$Q49,IF(F49=F48,0.00001+F46+10+F49^IF($T$3=2,2,1),IF($T$3=3,F49+F46,F46-ABS(F49-F48)))))","v":" "},{"$f":"IF(OR(G$2=\" \",$B49=\"\",$Q49=0),\" \",IF($B49=$Q49,IF(G49=G48,0.00001+G46+10+G49^IF($T$3=2,2,1),IF($T$3=3,G49+G46,G46-ABS(G49-G48)))))","v":" "},{"$f":"IF(OR(H$2=\" \",$B49=\"\",$Q49=0),\" \",IF($B49=$Q49,IF(H49=H48,0.00001+H46+10+H49^IF($T$3=2,2,1),IF($T$3=3,H49+H46,H46-ABS(H49-H48)))))","v":" "},{"$f":"IF(OR(I$2=\" \",$B49=\"\",$Q49=0),\" \",IF($B49=$Q49,IF(I49=I48,0.00001+I46+10+I49^IF($T$3=2,2,1),IF($T$3=3,I49+I46,I46-ABS(I49-I48)))))","v":" "},{"$f":"IF(OR(J$2=\" \",$B49=\"\",$Q49=0),\" \",IF($B49=$Q49,IF(J49=J48,0.00001+J46+10+J49^IF($T$3=2,2,1),IF($T$3=3,J49+J46,J46-ABS(J49-J48)))))","v":" "},{"$f":"IF(OR(K$2=\" \",$B49=\"\",$Q49=0),\" \",IF($B49=$Q49,IF(K49=K48,0.00001+K46+10+K49^IF($T$3=2,2,1),IF($T$3=3,K49+K46,K46-ABS(K49-K48)))))","v":" "},{"$f":"IF(OR(L$2=\" \",$B49=\"\",$Q49=0),\" \",IF($B49=$Q49,IF(L49=L48,0.00001+L46+10+L49^IF($T$3=2,2,1),IF($T$3=3,L49+L46,L46-ABS(L49-L48)))))","v":" "},{"$f":"IF(OR(M$2=\" \",$B49=\"\",$Q49=0),\" \",IF($B49=$Q49,IF(M49=M48,0.00001+M46+10+M49^IF($T$3=2,2,1),IF($T$3=3,M49+M46,M46-ABS(M49-M48)))))","v":" "},{"$f":"IF(OR(N$2=\" \",$B49=\"\",$Q49=0),\" \",IF($B49=$Q49,IF(N49=N48,0.00001+N46+10+N49^IF($T$3=2,2,1),IF($T$3=3,N49+N46,N46-ABS(N49-N48)))))","v":" "},{"$f":"IF(OR(O$2=\" \",$B49=\"\",$Q49=0),\" \",IF($B49=$Q49,IF(O49=O48,0.00001+O46+10+O49^IF($T$3=2,2,1),IF($T$3=3,O49+O46,O46-ABS(O49-O48)))))","v":" "},{"$f":"IF(OR(P$2=\" \",$B49=\"\",$Q49=0),\" \",IF($B49=$Q49,IF(P49=P48,0.00001+P46+10+P49^IF($T$3=2,2,1),IF($T$3=3,P49+P46,P46-ABS(P49-P48)))))","v":" "},{"$f":"SUM(E50:P50)","v":0}]
[null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,{"$f":"IF(AND(NOT(ISNA($R$3)),B53<>\"\"),OFFSET($E$2,0,R52-1),\"\")","v":" "},{"$f":"IF(COUNT(E52:P52)=COUNTA($E$2:$P$2),IF(SUM(E52:P52)=B53,IF($C$2=\"Dealer\",\"Dealer\",\"OK\"),\"OK\"),\"\")","v":""},{"$f":"IF(B53>0,\"Bid\",\"\")","v":"Bid"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E52:P52)","v":0},{"$f":"IF(R48=$U$3,1,R48+1)","v":1}]
[null,{"$f":"IF(OR(B49=\"\",B49=$T$4),\"\",IF(B49>B45,B49+1,IF(B49=1,2,B49-1)))","v":7},{"$f":"IF(AND(SUM(E53:P53)<>B53,COUNT(E53:P53)=COUNTA($E$2:$P$2)),\"Tricks\",IF(COUNT(E53:P53)=COUNTA($E$2:$P$2),\"OK\",\"\"))","v":""},{"$f":"IF(B53>0,\"Made\",\"\")","v":"Made"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E53:P53)","v":0}]
[null,{"$f":"IF(C52=\"OK\",IF(B53=Q52,\"Even\",IF(B53>Q52,\"Underbid\",\"Overbid\")),\"\")","v":""},{"$f":"IF(C52=\"OK\",+Q52-B53,\"\")","v":""},{"$f":"IF(B53>0,\"Score\",\"\")","v":"Score"},{"$f":"IF(OR(E$2=\" \",$B53=\"\",$Q53=0),\" \",IF($B53=$Q53,IF(E53=E52,0.00001+E50+10+E53^IF($T$3=2,2,1),IF($T$3=3,E53+E50,E50-ABS(E53-E52)))))","v":" "},{"$f":"IF(OR(F$2=\" \",$B53=\"\",$Q53=0),\" \",IF($B53=$Q53,IF(F53=F52,0.00001+F50+10+F53^IF($T$3=2,2,1),IF($T$3=3,F53+F50,F50-ABS(F53-F52)))))","v":" "},{"$f":"IF(OR(G$2=\" \",$B53=\"\",$Q53=0),\" \",IF($B53=$Q53,IF(G53=G52,0.00001+G50+10+G53^IF($T$3=2,2,1),IF($T$3=3,G53+G50,G50-ABS(G53-G52)))))","v":" "},{"$f":"IF(OR(H$2=\" \",$B53=\"\",$Q53=0),\" \",IF($B53=$Q53,IF(H53=H52,0.00001+H50+10+H53^IF($T$3=2,2,1),IF($T$3=3,H53+H50,H50-ABS(H53-H52)))))","v":" "},{"$f":"IF(OR(I$2=\" \",$B53=\"\",$Q53=0),\" \",IF($B53=$Q53,IF(I53=I52,0.00001+I50+10+I53^IF($T$3=2,2,1),IF($T$3=3,I53+I50,I50-ABS(I53-I52)))))","v":" "},{"$f":"IF(OR(J$2=\" \",$B53=\"\",$Q53=0),\" \",IF($B53=$Q53,IF(J53=J52,0.00001+J50+10+J53^IF($T$3=2,2,1),IF($T$3=3,J53+J50,J50-ABS(J53-J52)))))","v":" "},{"$f":"IF(OR(K$2=\" \",$B53=\"\",$Q53=0),\" \",IF($B53=$Q53,IF(K53=K52,0.00001+K50+10+K53^IF($T$3=2,2,1),IF($T$3=3,K53+K50,K50-ABS(K53-K52)))))","v":" "},{"$f":"IF(OR(L$2=\" \",$B53=\"\",$Q53=0),\" \",IF($B53=$Q53,IF(L53=L52,0.00001+L50+10+L53^IF($T$3=2,2,1),IF($T$3=3,L53+L50,L50-ABS(L53-L52)))))","v":" "},{"$f":"IF(OR(M$2=\" \",$B53=\"\",$Q53=0),\" \",IF($B53=$Q53,IF(M53=M52,0.00001+M50+10+M53^IF($T$3=2,2,1),IF($T$3=3,M53+M50,M50-ABS(M53-M52)))))","v":" "},{"$f":"IF(OR(N$2=\" \",$B53=\"\",$Q53=0),\" \",IF($B53=$Q53,IF(N53=N52,0.00001+N50+10+N53^IF($T$3=2,2,1),IF($T$3=3,N53+N50,N50-ABS(N53-N52)))))","v":" "},{"$f":"IF(OR(O$2=\" \",$B53=\"\",$Q53=0),\" \",IF($B53=$Q53,IF(O53=O52,0.00001+O50+10+O53^IF($T$3=2,2,1),IF($T$3=3,O53+O50,O50-ABS(O53-O52)))))","v":" "},{"$f":"IF(OR(P$2=\" \",$B53=\"\",$Q53=0),\" \",IF($B53=$Q53,IF(P53=P52,0.00001+P50+10+P53^IF($T$3=2,2,1),IF($T$3=3,P53+P50,P50-ABS(P53-P52)))))","v":" "},{"$f":"SUM(E54:P54)","v":0}]
[null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,{"$f":"IF(AND(NOT(ISNA($R$3)),B57<>\"\"),OFFSET($E$2,0,R56-1),\"\")","v":""},{"$f":"IF(COUNT(E56:P56)=COUNTA($E$2:$P$2),IF(SUM(E56:P56)=B57,IF($C$2=\"Dealer\",\"Dealer\",\"OK\"),\"OK\"),\"\")","v":""},{"$f":"IF(B57>0,\"Bid\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E56:P56)","v":0},{"$f":"IF(R52=$U$3,1,R52+1)","v":1}]
[null,{"$f":"IF(OR(B53=\"\",B53=$T$4),\"\",IF(B53>B49,B53+1,IF(B53=1,2,B53-1)))","v":""},{"$f":"IF(AND(SUM(E57:P57)<>B57,COUNT(E57:P57)=COUNTA($E$2:$P$2)),\"Tricks\",IF(COUNT(E57:P57)=COUNTA($E$2:$P$2),\"OK\",\"\"))","v":""},{"$f":"IF(B57>0,\"Made\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E57:P57)","v":0}]
[null,{"$f":"IF(C56=\"OK\",IF(B57=Q56,\"Even\",IF(B57>Q56,\"Underbid\",\"Overbid\")),\"\")","v":""},{"$f":"IF(C56=\"OK\",+Q56-B57,\"\")","v":""},{"$f":"IF(B57>0,\"Score\",\"\")","v":""},{"$f":"IF(OR(E$2=\" \",$B57=\"\",$Q57=0),\" \",IF($B57=$Q57,IF(E57=E56,0.00001+E54+10+E57^IF($T$3=2,2,1),IF($T$3=3,E57+E54,E54-ABS(E57-E56)))))","v":" "},{"$f":"IF(OR(F$2=\" \",$B57=\"\",$Q57=0),\" \",IF($B57=$Q57,IF(F57=F56,0.00001+F54+10+F57^IF($T$3=2,2,1),IF($T$3=3,F57+F54,F54-ABS(F57-F56)))))","v":" "},{"$f":"IF(OR(G$2=\" \",$B57=\"\",$Q57=0),\" \",IF($B57=$Q57,IF(G57=G56,0.00001+G54+10+G57^IF($T$3=2,2,1),IF($T$3=3,G57+G54,G54-ABS(G57-G56)))))","v":" "},{"$f":"IF(OR(H$2=\" \",$B57=\"\",$Q57=0),\" \",IF($B57=$Q57,IF(H57=H56,0.00001+H54+10+H57^IF($T$3=2,2,1),IF($T$3=3,H57+H54,H54-ABS(H57-H56)))))","v":" "},{"$f":"IF(OR(I$2=\" \",$B57=\"\",$Q57=0),\" \",IF($B57=$Q57,IF(I57=I56,0.00001+I54+10+I57^IF($T$3=2,2,1),IF($T$3=3,I57+I54,I54-ABS(I57-I56)))))","v":" "},{"$f":"IF(OR(J$2=\" \",$B57=\"\",$Q57=0),\" \",IF($B57=$Q57,IF(J57=J56,0.00001+J54+10+J57^IF($T$3=2,2,1),IF($T$3=3,J57+J54,J54-ABS(J57-J56)))))","v":" "},{"$f":"IF(OR(K$2=\" \",$B57=\"\",$Q57=0),\" \",IF($B57=$Q57,IF(K57=K56,0.00001+K54+10+K57^IF($T$3=2,2,1),IF($T$3=3,K57+K54,K54-ABS(K57-K56)))))","v":" "},{"$f":"IF(OR(L$2=\" \",$B57=\"\",$Q57=0),\" \",IF($B57=$Q57,IF(L57=L56,0.00001+L54+10+L57^IF($T$3=2,2,1),IF($T$3=3,L57+L54,L54-ABS(L57-L56)))))","v":" "},{"$f":"IF(OR(M$2=\" \",$B57=\"\",$Q57=0),\" \",IF($B57=$Q57,IF(M57=M56,0.00001+M54+10+M57^IF($T$3=2,2,1),IF($T$3=3,M57+M54,M54-ABS(M57-M56)))))","v":" "},{"$f":"IF(OR(N$2=\" \",$B57=\"\",$Q57=0),\" \",IF($B57=$Q57,IF(N57=N56,0.00001+N54+10+N57^IF($T$3=2,2,1),IF($T$3=3,N57+N54,N54-ABS(N57-N56)))))","v":" "},{"$f":"IF(OR(O$2=\" \",$B57=\"\",$Q57=0),\" \",IF($B57=$Q57,IF(O57=O56,0.00001+O54+10+O57^IF($T$3=2,2,1),IF($T$3=3,O57+O54,O54-ABS(O57-O56)))))","v":" "},{"$f":"IF(OR(P$2=\" \",$B57=\"\",$Q57=0),\" \",IF($B57=$Q57,IF(P57=P56,0.00001+P54+10+P57^IF($T$3=2,2,1),IF($T$3=3,P57+P54,P54-ABS(P57-P56)))))","v":" "},{"$f":"SUM(E58:P58)","v":0}]
[null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,{"$f":"IF(AND(NOT(ISNA($R$3)),B61<>\"\"),OFFSET($E$2,0,R60-1),\"\")","v":""},{"$f":"IF(COUNT(E60:P60)=COUNTA($E$2:$P$2),IF(SUM(E60:P60)=B61,IF($C$2=\"Dealer\",\"Dealer\",\"OK\"),\"OK\"),\"\")","v":""},{"$f":"IF(B61>0,\"Bid\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E60:P60)","v":0},{"$f":"IF(R56=$U$3,1,R56+1)","v":1}]
[null,{"$f":"IF(OR(B57=\"\",B57=$T$4),\"\",IF(B57>B53,B57+1,IF(B57=1,2,B57-1)))","v":""},{"$f":"IF(AND(SUM(E61:P61)<>B61,COUNT(E61:P61)=COUNTA($E$2:$P$2)),\"Tricks\",IF(COUNT(E61:P61)=COUNTA($E$2:$P$2),\"OK\",\"\"))","v":""},{"$f":"IF(B61>0,\"Made\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E61:P61)","v":0}]
[null,{"$f":"IF(C60=\"OK\",IF(B61=Q60,\"Even\",IF(B61>Q60,\"Underbid\",\"Overbid\")),\"\")","v":""},{"$f":"IF(C60=\"OK\",+Q60-B61,\"\")","v":""},{"$f":"IF(B61>0,\"Score\",\"\")","v":""},{"$f":"IF(OR(E$2=\" \",$B61=\"\",$Q61=0),\" \",IF($B61=$Q61,IF(E61=E60,0.00001+E58+10+E61^IF($T$3=2,2,1),IF($T$3=3,E61+E58,E58-ABS(E61-E60)))))","v":" "},{"$f":"IF(OR(F$2=\" \",$B61=\"\",$Q61=0),\" \",IF($B61=$Q61,IF(F61=F60,0.00001+F58+10+F61^IF($T$3=2,2,1),IF($T$3=3,F61+F58,F58-ABS(F61-F60)))))","v":" "},{"$f":"IF(OR(G$2=\" \",$B61=\"\",$Q61=0),\" \",IF($B61=$Q61,IF(G61=G60,0.00001+G58+10+G61^IF($T$3=2,2,1),IF($T$3=3,G61+G58,G58-ABS(G61-G60)))))","v":" "},{"$f":"IF(OR(H$2=\" \",$B61=\"\",$Q61=0),\" \",IF($B61=$Q61,IF(H61=H60,0.00001+H58+10+H61^IF($T$3=2,2,1),IF($T$3=3,H61+H58,H58-ABS(H61-H60)))))","v":" "},{"$f":"IF(OR(I$2=\" \",$B61=\"\",$Q61=0),\" \",IF($B61=$Q61,IF(I61=I60,0.00001+I58+10+I61^IF($T$3=2,2,1),IF($T$3=3,I61+I58,I58-ABS(I61-I60)))))","v":" "},{"$f":"IF(OR(J$2=\" \",$B61=\"\",$Q61=0),\" \",IF($B61=$Q61,IF(J61=J60,0.00001+J58+10+J61^IF($T$3=2,2,1),IF($T$3=3,J61+J58,J58-ABS(J61-J60)))))","v":" "},{"$f":"IF(OR(K$2=\" \",$B61=\"\",$Q61=0),\" \",IF($B61=$Q61,IF(K61=K60,0.00001+K58+10+K61^IF($T$3=2,2,1),IF($T$3=3,K61+K58,K58-ABS(K61-K60)))))","v":" "},{"$f":"IF(OR(L$2=\" \",$B61=\"\",$Q61=0),\" \",IF($B61=$Q61,IF(L61=L60,0.00001+L58+10+L61^IF($T$3=2,2,1),IF($T$3=3,L61+L58,L58-ABS(L61-L60)))))","v":" "},{"$f":"IF(OR(M$2=\" \",$B61=\"\",$Q61=0),\" \",IF($B61=$Q61,IF(M61=M60,0.00001+M58+10+M61^IF($T$3=2,2,1),IF($T$3=3,M61+M58,M58-ABS(M61-M60)))))","v":" "},{"$f":"IF(OR(N$2=\" \",$B61=\"\",$Q61=0),\" \",IF($B61=$Q61,IF(N61=N60,0.00001+N58+10+N61^IF($T$3=2,2,1),IF($T$3=3,N61+N58,N58-ABS(N61-N60)))))","v":" "},{"$f":"IF(OR(O$2=\" \",$B61=\"\",$Q61=0),\" \",IF($B61=$Q61,IF(O61=O60,0.00001+O58+10+O61^IF($T$3=2,2,1),IF($T$3=3,O61+O58,O58-ABS(O61-O60)))))","v":" "},{"$f":"IF(OR(P$2=\" \",$B61=\"\",$Q61=0),\" \",IF($B61=$Q61,IF(P61=P60,0.00001+P58+10+P61^IF($T$3=2,2,1),IF($T$3=3,P61+P58,P58-ABS(P61-P60)))))","v":" "},{"$f":"SUM(E62:P62)","v":0}]
[null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,{"$f":"IF(AND(NOT(ISNA($R$3)),B65<>\"\"),OFFSET($E$2,0,R64-1),\"\")","v":""},{"$f":"IF(COUNT(E64:P64)=COUNTA($E$2:$P$2),IF(SUM(E64:P64)=B65,IF($C$2=\"Dealer\",\"Dealer\",\"OK\"),\"OK\"),\"\")","v":""},{"$f":"IF(B65>0,\"Bid\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E64:P64)","v":0},{"$f":"IF(R60=$U$3,1,R60+1)","v":1}]
[null,{"$f":"IF(OR(B61=\"\",B61=$T$4),\"\",IF(B61>B57,B61+1,IF(B61=1,2,B61-1)))","v":""},{"$f":"IF(AND(SUM(E65:P65)<>B65,COUNT(E65:P65)=COUNTA($E$2:$P$2)),\"Tricks\",IF(COUNT(E65:P65)=COUNTA($E$2:$P$2),\"OK\",\"\"))","v":""},{"$f":"IF(B65>0,\"Made\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E65:P65)","v":0}]
[null,{"$f":"IF(C64=\"OK\",IF(B65=Q64,\"Even\",IF(B65>Q64,\"Underbid\",\"Overbid\")),\"\")","v":""},{"$f":"IF(C64=\"OK\",+Q64-B65,\"\")","v":""},{"$f":"IF(B65>0,\"Score\",\"\")","v":""},{"$f":"IF(OR(E$2=\" \",$B65=\"\",$Q65=0),\" \",IF($B65=$Q65,IF(E65=E64,0.00001+E62+10+E65^IF($T$3=2,2,1),IF($T$3=3,E65+E62,E62-ABS(E65-E64)))))","v":" "},{"$f":"IF(OR(F$2=\" \",$B65=\"\",$Q65=0),\" \",IF($B65=$Q65,IF(F65=F64,0.00001+F62+10+F65^IF($T$3=2,2,1),IF($T$3=3,F65+F62,F62-ABS(F65-F64)))))","v":" "},{"$f":"IF(OR(G$2=\" \",$B65=\"\",$Q65=0),\" \",IF($B65=$Q65,IF(G65=G64,0.00001+G62+10+G65^IF($T$3=2,2,1),IF($T$3=3,G65+G62,G62-ABS(G65-G64)))))","v":" "},{"$f":"IF(OR(H$2=\" \",$B65=\"\",$Q65=0),\" \",IF($B65=$Q65,IF(H65=H64,0.00001+H62+10+H65^IF($T$3=2,2,1),IF($T$3=3,H65+H62,H62-ABS(H65-H64)))))","v":" "},{"$f":"IF(OR(I$2=\" \",$B65=\"\",$Q65=0),\" \",IF($B65=$Q65,IF(I65=I64,0.00001+I62+10+I65^IF($T$3=2,2,1),IF($T$3=3,I65+I62,I62-ABS(I65-I64)))))","v":" "},{"$f":"IF(OR(J$2=\" \",$B65=\"\",$Q65=0),\" \",IF($B65=$Q65,IF(J65=J64,0.00001+J62+10+J65^IF($T$3=2,2,1),IF($T$3=3,J65+J62,J62-ABS(J65-J64)))))","v":" "},{"$f":"IF(OR(K$2=\" \",$B65=\"\",$Q65=0),\" \",IF($B65=$Q65,IF(K65=K64,0.00001+K62+10+K65^IF($T$3=2,2,1),IF($T$3=3,K65+K62,K62-ABS(K65-K64)))))","v":" "},{"$f":"IF(OR(L$2=\" \",$B65=\"\",$Q65=0),\" \",IF($B65=$Q65,IF(L65=L64,0.00001+L62+10+L65^IF($T$3=2,2,1),IF($T$3=3,L65+L62,L62-ABS(L65-L64)))))","v":" "},{"$f":"IF(OR(M$2=\" \",$B65=\"\",$Q65=0),\" \",IF($B65=$Q65,IF(M65=M64,0.00001+M62+10+M65^IF($T$3=2,2,1),IF($T$3=3,M65+M62,M62-ABS(M65-M64)))))","v":" "},{"$f":"IF(OR(N$2=\" \",$B65=\"\",$Q65=0),\" \",IF($B65=$Q65,IF(N65=N64,0.00001+N62+10+N65^IF($T$3=2,2,1),IF($T$3=3,N65+N62,N62-ABS(N65-N64)))))","v":" "},{"$f":"IF(OR(O$2=\" \",$B65=\"\",$Q65=0),\" \",IF($B65=$Q65,IF(O65=O64,0.00001+O62+10+O65^IF($T$3=2,2,1),IF($T$3=3,O65+O62,O62-ABS(O65-O64)))))","v":" "},{"$f":"IF(OR(P$2=\" \",$B65=\"\",$Q65=0),\" \",IF($B65=$Q65,IF(P65=P64,0.00001+P62+10+P65^IF($T$3=2,2,1),IF($T$3=3,P65+P62,P62-ABS(P65-P64)))))","v":" "},{"$f":"SUM(E66:P66)","v":0}]
[null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,{"$f":"IF(AND(NOT(ISNA($R$3)),B69<>\"\"),OFFSET($E$2,0,R68-1),\"\")","v":""},{"$f":"IF(COUNT(E68:P68)=COUNTA($E$2:$P$2),IF(SUM(E68:P68)=B69,IF($C$2=\"Dealer\",\"Dealer\",\"OK\"),\"OK\"),\"\")","v":""},{"$f":"IF(B69>0,\"Bid\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E68:P68)","v":0},{"$f":"IF(R64=$U$3,1,R64+1)","v":1}]
[null,{"$f":"IF(OR(B65=\"\",B65=$T$4),\"\",IF(B65>B61,B65+1,IF(B65=1,2,B65-1)))","v":""},{"$f":"IF(AND(SUM(E69:P69)<>B69,COUNT(E69:P69)=COUNTA($E$2:$P$2)),\"Tricks\",IF(COUNT(E69:P69)=COUNTA($E$2:$P$2),\"OK\",\"\"))","v":""},{"$f":"IF(B69>0,\"Made\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E69:P69)","v":0}]
[null,{"$f":"IF(C68=\"OK\",IF(B69=Q68,\"Even\",IF(B69>Q68,\"Underbid\",\"Overbid\")),\"\")","v":""},{"$f":"IF(C68=\"OK\",+Q68-B69,\"\")","v":""},{"$f":"IF(B69>0,\"Score\",\"\")","v":""},{"$f":"IF(OR(E$2=\" \",$B69=\"\",$Q69=0),\" \",IF($B69=$Q69,IF(E69=E68,0.00001+E66+10+E69^IF($T$3=2,2,1),IF($T$3=3,E69+E66,E66-ABS(E69-E68)))))","v":" "},{"$f":"IF(OR(F$2=\" \",$B69=\"\",$Q69=0),\" \",IF($B69=$Q69,IF(F69=F68,0.00001+F66+10+F69^IF($T$3=2,2,1),IF($T$3=3,F69+F66,F66-ABS(F69-F68)))))","v":" "},{"$f":"IF(OR(G$2=\" \",$B69=\"\",$Q69=0),\" \",IF($B69=$Q69,IF(G69=G68,0.00001+G66+10+G69^IF($T$3=2,2,1),IF($T$3=3,G69+G66,G66-ABS(G69-G68)))))","v":" "},{"$f":"IF(OR(H$2=\" \",$B69=\"\",$Q69=0),\" \",IF($B69=$Q69,IF(H69=H68,0.00001+H66+10+H69^IF($T$3=2,2,1),IF($T$3=3,H69+H66,H66-ABS(H69-H68)))))","v":" "},{"$f":"IF(OR(I$2=\" \",$B69=\"\",$Q69=0),\" \",IF($B69=$Q69,IF(I69=I68,0.00001+I66+10+I69^IF($T$3=2,2,1),IF($T$3=3,I69+I66,I66-ABS(I69-I68)))))","v":" "},{"$f":"IF(OR(J$2=\" \",$B69=\"\",$Q69=0),\" \",IF($B69=$Q69,IF(J69=J68,0.00001+J66+10+J69^IF($T$3=2,2,1),IF($T$3=3,J69+J66,J66-ABS(J69-J68)))))","v":" "},{"$f":"IF(OR(K$2=\" \",$B69=\"\",$Q69=0),\" \",IF($B69=$Q69,IF(K69=K68,0.00001+K66+10+K69^IF($T$3=2,2,1),IF($T$3=3,K69+K66,K66-ABS(K69-K68)))))","v":" "},{"$f":"IF(OR(L$2=\" \",$B69=\"\",$Q69=0),\" \",IF($B69=$Q69,IF(L69=L68,0.00001+L66+10+L69^IF($T$3=2,2,1),IF($T$3=3,L69+L66,L66-ABS(L69-L68)))))","v":" "},{"$f":"IF(OR(M$2=\" \",$B69=\"\",$Q69=0),\" \",IF($B69=$Q69,IF(M69=M68,0.00001+M66+10+M69^IF($T$3=2,2,1),IF($T$3=3,M69+M66,M66-ABS(M69-M68)))))","v":" "},{"$f":"IF(OR(N$2=\" \",$B69=\"\",$Q69=0),\" \",IF($B69=$Q69,IF(N69=N68,0.00001+N66+10+N69^IF($T$3=2,2,1),IF($T$3=3,N69+N66,N66-ABS(N69-N68)))))","v":" "},{"$f":"IF(OR(O$2=\" \",$B69=\"\",$Q69=0),\" \",IF($B69=$Q69,IF(O69=O68,0.00001+O66+10+O69^IF($T$3=2,2,1),IF($T$3=3,O69+O66,O66-ABS(O69-O68)))))","v":" "},{"$f":"IF(OR(P$2=\" \",$B69=\"\",$Q69=0),\" \",IF($B69=$Q69,IF(P69=P68,0.00001+P66+10+P69^IF($T$3=2,2,1),IF($T$3=3,P69+P66,P66-ABS(P69-P68)))))","v":" "},{"$f":"SUM(E70:P70)","v":0}]
[null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,{"$f":"IF(AND(NOT(ISNA($R$3)),B73<>\"\"),OFFSET($E$2,0,R72-1),\"\")","v":""},{"$f":"IF(COUNT(E72:P72)=COUNTA($E$2:$P$2),IF(SUM(E72:P72)=B73,IF($C$2=\"Dealer\",\"Dealer\",\"OK\"),\"OK\"),\"\")","v":""},{"$f":"IF(B73>0,\"Bid\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E72:P72)","v":0},{"$f":"IF(R68=$U$3,1,R68+1)","v":1}]
[null,{"$f":"IF(OR(B69=\"\",B69=$T$4),\"\",IF(B69>B65,B69+1,IF(B69=1,2,B69-1)))","v":""},{"$f":"IF(AND(SUM(E73:P73)<>B73,COUNT(E73:P73)=COUNTA($E$2:$P$2)),\"Tricks\",IF(COUNT(E73:P73)=COUNTA($E$2:$P$2),\"OK\",\"\"))","v":""},{"$f":"IF(B73>0,\"Made\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E73:P73)","v":0}]
[null,{"$f":"IF(C72=\"OK\",IF(B73=Q72,\"Even\",IF(B73>Q72,\"Underbid\",\"Overbid\")),\"\")","v":""},{"$f":"IF(C72=\"OK\",+Q72-B73,\"\")","v":""},{"$f":"IF(B73>0,\"Score\",\"\")","v":""},{"$f":"IF(OR(E$2=\" \",$B73=\"\",$Q73=0),\" \",IF($B73=$Q73,IF(E73=E72,0.00001+E70+10+E73^IF($T$3=2,2,1),IF($T$3=3,E73+E70,E70-ABS(E73-E72)))))","v":" "},{"$f":"IF(OR(F$2=\" \",$B73=\"\",$Q73=0),\" \",IF($B73=$Q73,IF(F73=F72,0.00001+F70+10+F73^IF($T$3=2,2,1),IF($T$3=3,F73+F70,F70-ABS(F73-F72)))))","v":" "},{"$f":"IF(OR(G$2=\" \",$B73=\"\",$Q73=0),\" \",IF($B73=$Q73,IF(G73=G72,0.00001+G70+10+G73^IF($T$3=2,2,1),IF($T$3=3,G73+G70,G70-ABS(G73-G72)))))","v":" "},{"$f":"IF(OR(H$2=\" \",$B73=\"\",$Q73=0),\" \",IF($B73=$Q73,IF(H73=H72,0.00001+H70+10+H73^IF($T$3=2,2,1),IF($T$3=3,H73+H70,H70-ABS(H73-H72)))))","v":" "},{"$f":"IF(OR(I$2=\" \",$B73=\"\",$Q73=0),\" \",IF($B73=$Q73,IF(I73=I72,0.00001+I70+10+I73^IF($T$3=2,2,1),IF($T$3=3,I73+I70,I70-ABS(I73-I72)))))","v":" "},{"$f":"IF(OR(J$2=\" \",$B73=\"\",$Q73=0),\" \",IF($B73=$Q73,IF(J73=J72,0.00001+J70+10+J73^IF($T$3=2,2,1),IF($T$3=3,J73+J70,J70-ABS(J73-J72)))))","v":" "},{"$f":"IF(OR(K$2=\" \",$B73=\"\",$Q73=0),\" \",IF($B73=$Q73,IF(K73=K72,0.00001+K70+10+K73^IF($T$3=2,2,1),IF($T$3=3,K73+K70,K70-ABS(K73-K72)))))","v":" "},{"$f":"IF(OR(L$2=\" \",$B73=\"\",$Q73=0),\" \",IF($B73=$Q73,IF(L73=L72,0.00001+L70+10+L73^IF($T$3=2,2,1),IF($T$3=3,L73+L70,L70-ABS(L73-L72)))))","v":" "},{"$f":"IF(OR(M$2=\" \",$B73=\"\",$Q73=0),\" \",IF($B73=$Q73,IF(M73=M72,0.00001+M70+10+M73^IF($T$3=2,2,1),IF($T$3=3,M73+M70,M70-ABS(M73-M72)))))","v":" "},{"$f":"IF(OR(N$2=\" \",$B73=\"\",$Q73=0),\" \",IF($B73=$Q73,IF(N73=N72,0.00001+N70+10+N73^IF($T$3=2,2,1),IF($T$3=3,N73+N70,N70-ABS(N73-N72)))))","v":" "},{"$f":"IF(OR(O$2=\" \",$B73=\"\",$Q73=0),\" \",IF($B73=$Q73,IF(O73=O72,0.00001+O70+10+O73^IF($T$3=2,2,1),IF($T$3=3,O73+O70,O70-ABS(O73-O72)))))","v":" "},{"$f":"IF(OR(P$2=\" \",$B73=\"\",$Q73=0),\" \",IF($B73=$Q73,IF(P73=P72,0.00001+P70+10+P73^IF($T$3=2,2,1),IF($T$3=3,P73+P70,P70-ABS(P73-P72)))))","v":" "},{"$f":"SUM(E74:P74)","v":0}]
[null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,{"$f":"IF(AND(NOT(ISNA($R$3)),B77<>\"\"),OFFSET($E$2,0,R76-1),\"\")","v":""},{"$f":"IF(COUNT(E76:P76)=COUNTA($E$2:$P$2),IF(SUM(E76:P76)=B77,IF($C$2=\"Dealer\",\"Dealer\",\"OK\"),\"OK\"),\"\")","v":""},{"$f":"IF(B77>0,\"Bid\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E76:P76)","v":0},{"$f":"IF(R72=$U$3,1,R72+1)","v":1}]
[null,{"$f":"IF(OR(B73=\"\",B73=$T$4),\"\",IF(B73>B69,B73+1,IF(B73=1,2,B73-1)))","v":""},{"$f":"IF(AND(SUM(E77:P77)<>B77,COUNT(E77:P77)=COUNTA($E$2:$P$2)),\"Tricks\",IF(COUNT(E77:P77)=COUNTA($E$2:$P$2),\"OK\",\"\"))","v":""},{"$f":"IF(B77>0,\"Made\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E77:P77)","v":0}]
[null,{"$f":"IF(C76=\"OK\",IF(B77=Q76,\"Even\",IF(B77>Q76,\"Underbid\",\"Overbid\")),\"\")","v":""},{"$f":"IF(C76=\"OK\",+Q76-B77,\"\")","v":""},{"$f":"IF(B77>0,\"Score\",\"\")","v":""},{"$f":"IF(OR(E$2=\" \",$B77=\"\",$Q77=0),\" \",IF($B77=$Q77,IF(E77=E76,0.00001+E74+10+E77^IF($T$3=2,2,1),IF($T$3=3,E77+E74,E74-ABS(E77-E76)))))","v":" "},{"$f":"IF(OR(F$2=\" \",$B77=\"\",$Q77=0),\" \",IF($B77=$Q77,IF(F77=F76,0.00001+F74+10+F77^IF($T$3=2,2,1),IF($T$3=3,F77+F74,F74-ABS(F77-F76)))))","v":" "},{"$f":"IF(OR(G$2=\" \",$B77=\"\",$Q77=0),\" \",IF($B77=$Q77,IF(G77=G76,0.00001+G74+10+G77^IF($T$3=2,2,1),IF($T$3=3,G77+G74,G74-ABS(G77-G76)))))","v":" "},{"$f":"IF(OR(H$2=\" \",$B77=\"\",$Q77=0),\" \",IF($B77=$Q77,IF(H77=H76,0.00001+H74+10+H77^IF($T$3=2,2,1),IF($T$3=3,H77+H74,H74-ABS(H77-H76)))))","v":" "},{"$f":"IF(OR(I$2=\" \",$B77=\"\",$Q77=0),\" \",IF($B77=$Q77,IF(I77=I76,0.00001+I74+10+I77^IF($T$3=2,2,1),IF($T$3=3,I77+I74,I74-ABS(I77-I76)))))","v":" "},{"$f":"IF(OR(J$2=\" \",$B77=\"\",$Q77=0),\" \",IF($B77=$Q77,IF(J77=J76,0.00001+J74+10+J77^IF($T$3=2,2,1),IF($T$3=3,J77+J74,J74-ABS(J77-J76)))))","v":" "},{"$f":"IF(OR(K$2=\" \",$B77=\"\",$Q77=0),\" \",IF($B77=$Q77,IF(K77=K76,0.00001+K74+10+K77^IF($T$3=2,2,1),IF($T$3=3,K77+K74,K74-ABS(K77-K76)))))","v":" "},{"$f":"IF(OR(L$2=\" \",$B77=\"\",$Q77=0),\" \",IF($B77=$Q77,IF(L77=L76,0.00001+L74+10+L77^IF($T$3=2,2,1),IF($T$3=3,L77+L74,L74-ABS(L77-L76)))))","v":" "},{"$f":"IF(OR(M$2=\" \",$B77=\"\",$Q77=0),\" \",IF($B77=$Q77,IF(M77=M76,0.00001+M74+10+M77^IF($T$3=2,2,1),IF($T$3=3,M77+M74,M74-ABS(M77-M76)))))","v":" "},{"$f":"IF(OR(N$2=\" \",$B77=\"\",$Q77=0),\" \",IF($B77=$Q77,IF(N77=N76,0.00001+N74+10+N77^IF($T$3=2,2,1),IF($T$3=3,N77+N74,N74-ABS(N77-N76)))))","v":" "},{"$f":"IF(OR(O$2=\" \",$B77=\"\",$Q77=0),\" \",IF($B77=$Q77,IF(O77=O76,0.00001+O74+10+O77^IF($T$3=2,2,1),IF($T$3=3,O77+O74,O74-ABS(O77-O76)))))","v":" "},{"$f":"IF(OR(P$2=\" \",$B77=\"\",$Q77=0),\" \",IF($B77=$Q77,IF(P77=P76,0.00001+P74+10+P77^IF($T$3=2,2,1),IF($T$3=3,P77+P74,P74-ABS(P77-P76)))))","v":" "},{"$f":"SUM(E78:P78)","v":0}]
[null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,null,null,null,"© 2020, Ruth's Waterfalls"]
[null,null," "," ","http://www.naturalhighs.net/Fun/ohhell.htm",null,null,null,null,null," "," "," "," "," "," "," "]

{"sheet":"Rules","index":1,"n_rows":65,"n_cols":2,"rows_kept":65,"cut":false,"hidden":false,"merged":[[63,1,63,4],[58,1,58,4]]}
[]
[]
[null,"The name of this card game is \"Oh Hell!\"  It is best with 4 or more players."]
[]
[null,"Every player draws for deal. The first highest card deals. Subsequently, the deal passes to the left."]
[]
[null,"On the first hand, deal seven cards to each player. On the next hand, deal six cards, then five, etc."]
[null,"On the seventh hand, deal one card to each player. Then work back up to seven cards for"]
[null,"subsequent hands. The game is 13 hands. The left column of the score sheet shows the number of"]
[null,"cards for each hand. "]
[]
[null,"Alternatively start at 8, 9 or 10 cards and work down to one and back up."]
[]
[null,"When the cards have been dealt, turn up the top card and the suit of that card is trump for the"]
[null,"hand. Players then bid and the scorekeeper records the bids."]
[]
[null,"For bidding alternative 1, set the option to \"Dealer.\" Then, starting with the player to the left of the"]
[null,"dealer, each player must in turn declare the number of tricks they intend to take. The dealer is the"]
[null,"last to bid and is responsible for making the total of all bids be not equal to the total number of"]
[null,"cards in the hand. For example, in a deal of five cards with four players, if the bids are 2, 0, and 1"]
[null,"(for a total of three), the dealer may NOT bid 2. With this variation, the dealer leads any card for the first"]
[null,"trick."]
[]
[null,"For bidding alternative 2, set the option to \"Everyone\" rather than \"Dealer.\" Then on the count of"]
[null,"three, all players simultaneously declare their bids. With this alternative, following the bidding, the"]
[null,"player to the left of the dealer leads any card. "]
[]
[null,"Players must follow suit if possible, otherwise they may slough or trump. The highest card of the"]
[null,"suit led or the highest trump wins the trick. The winner of the trick leads for the next trick. Aces are"]
[null,"high."]
[]
[null,"Following the hand, each player in turn states the number of tricks taken. The scorekeeper records"]
[null,"the number of tricks and awards points to each player as follows:"]
[]
[null,"For scoring alternative 1, set the option to \"Regular.\" Then, if the number of tricks taken is equal to"]
[null,"the player's bid, the player receives points equal to the bid plus a bonus of 10 points."]
[]
[null,"For scoring alternative 2, set the option to \"Squared.\" Then, if the number of tricks taken is equal to"]
[null,"the player's bid, the player receives points equal to the square of the bid plus a bonus of 10 points."]
[]
[null,"For both alternatives 1 and 2, if the number of tricks taken is not equal to the bid, the player's score is"]
[null,"reduced by the difference. For example, a player bidding 3 and taking 1 receives negative 2 points,"]
[null,"as does a player bidding 1 and taking 3."]
[]
[null,"For Scoring alternative 3, set the option to \"Tricks.\"  Then, if the number of tricks taken is equal to"]
[null,"the player's bid, the player receives points equal to the  bid plus a bonus of 10 points as with alternative 1."]
[null,"However if the number of tricks taken is not equal to the bid, the player's score is increased by the "]
[null,"number of tricks bid. This can have the effect of reducing the spread between those receiving the"]
[null,"10-point bonus and those going down, which may result in a closer game. This alternative  also gives "]
[null,"players who see that they cannot make their bid to try and take as many tricks as possible, thus depriving"]
[null,"other players of tricks they may have bid."]
[]
[null,"The highest score at the end of the game is the winner."]
[]
[null,"For more than 7 players, use two decks of cards. In case cards of equal rank and suit are played"]
[null,"on a trick, the first played is the highest."]
[]
[null,"Thanks to Steve Hintz for suggesting the change to include scoring alternative 3. Also see"]
[null,"https://www.pagat.com/exact/ohhell.html"]
[null,"for more than you would ever need to know about Oh Hell! variations."]
[]
[null,"Roger Hopkins, February, 2005; Revised September, 2015; Revised January, 2020"]
[null,"© 2020, Ruth's Waterfalls"]
[null,"http://www.naturalhighs.net/Fun/ohhell.htm"]
[null,"info@naturalhighs.net"]