Spreadsheet: 209746d1359201275-bowling-spreadsheet-rounddown-in-formula-question-700-club-pot-games_etaf-4
Sheet: DataEntry

Date
Shift |  |  |  |  |  |  |  |  |  |  |  | Calculations DO NOT alter
 |  |  |  |  | Scratch Scores |  |  | Handicap Scores |  |  |  | Scratch Unique Rank |  |  | Handicap Unique Rank |  |  |  | Scratch Rank |  |  | Handicap Rank |  |  |  |  |  |  |  | Scratch Player |  |  | Handicap Player
Name | Average | Handicap (90% of 225) | Scratch Pot Entry | HandicapPot Entry | Game 1 | Game 2 | Game 3 | Game 1 | Game 2 | Game 3 |  | Game 1 | Game 2 | Game 3 | Game 1 | Game 2 | Game 3 |  | Game 1 | Game 2 | Game 3 | Game 1 | Game 2 | Game 3 |  |  |  |  | Game 1 | Game 2 | Game 3 | Game 1 | Game 2 | Game 3
Name1 | 204 |  | x | x | 214 | 232 | 202
[NAME] | 189 |  | x |  | 189 | 151 | 209
Name3 | 210 |  |  | x | 258 | 179 | 199
Name4 | 221 |  | x |  | 190 | 171 | 246
Name5 | 221 |  | x | x | 190 | 171 | 246
Name6 | 205 |  |  |  | 215 | 233 | 202
Name7 | 188 |  |  |  | 188 | 177 | 243
Name8 | 211 |  |  |  | 259 | 180 | 249
Name9 | 220 |  | x | x | 189 | 169 | 240 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name3
Name10 | 222 |  | x |  | 191 | 172 | 246 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name1
Name11 | 204 |  |  | x | 214 | 175 | 237 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name4
Name12 | 189 |  | x |  | 189 | 178 | 243 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name5
Name13 | 210 |  | x | x | 258 | 167 | 234 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Name14 | 221 |  |  |  | 190 | 170 | 240
Name15 | 221 |  |  |  | 190 | 173 | 231
[NAME] | 205 |  |  |  | 215 | 176 | 237
Name17 | 188 |  |  |  | 188 | 165 | 228
Name18 | 211 |  |  |  | 259 | 168 | 234
Name19 | 220 |  | x | x | 189 | 171 | 225
[NAME] | 222 |  | x |  | 191 | 174 | 231
Name21 | 204 |  |  | x | 214 | 163 | 222
Name22 | 189 |  | x |  | 189 | 166 | 228
Name23 | 210 |  | x | x | 258 | 169 | 219
Name24 | 221 |  |  |  | 190 | 172 | 225
Name25 | 221 |  |  |  | 190 | 161 | 216
Name26 | 205 |  |  |  | 215 | 164 | 222
Name27 | 188 |  |  |  | 188 | 167 | 213
Name28 | 211 |  |  |  | 259 | 170 | 219
Name29 | 220 |  |  |  | 189 | 159 | 210
Name30 | 222 |  |  |  | 191 | 162 | 216
Name31 | 204 |  |  |  | 214 | 165 | 207
Name32 | 189 |  |  |  | 189 | 168 | 213
Name33 | 210 |  | x | x | 258 | 157 | 204
[NAME] | 221 |  | x |  | 190 | 160 | 210
Name35 | 221 |  |  | x | 190 | 163 | 201
Name36 | 205 |  | x |  | 215 | 166 | 207
Name37 | 188 |  | x | x | 188 | 155 | 198
Name38 | 211 |  |  |  | 259 | 158 | 204
[NAME] | 220 |  |  |  | 189 | 161 | 195
Name40 | 222 |  |  |  | 191 | 164 | 201
Name41 | 204 |  |  |  | 214 | 153 | 192
Name42 | 189 |  |  |  | 189 | 156 | 198
Name43 | 210 |  |  |  | 258 | 159 | 189
Name44 | 221 |  |  |  | 190 | 162 | 195
Name45 | 221 |  | x | x | 190 | 151 | 186
Name46 | 205 |  | x |  | 215 | 154 | 192
[NAME] | 188 |  |  | x | 188 | 157 | 183
Name48 | 211 |  | x |  | 259 | 160 | 189
Name49 | 220 |  | x | x | 189 | 149 | 180
Name50 | 222 |  | x | x | 191 | 152 | 186
Name51 | 204 |  | x |  | 214 | 155 | 177
[NAME] | 189 |  |  | x | 189 | 158 | 183
Name53 | 210 |  | x |  | 258 | 147 | 174
Name54 | 221 |  | x | x | 190 | 150 | 180
Name55 | 221 |  |  |  | 190 | 153 | 171
Name56 | 205 |  |  |  | 215 | 156 | 177