tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 857649d1706618482-formula-for-sort-the-given-table-and-remove-the-contents-with-zero-sort-and-exclude-zero
Sheet: Sheet1

 |  |  |  | Need to eliminate this helpher table.
 |  |  |  | Sort for Descending |  |  | Sort for Descending and elimate the Zeros
 | Order delievered | 9
 | Order Cancelled | 0
 | Under Packaging | 12
 | Items verified | 14
 | Cash not recevied | 0
 | Blocked customer | 0
 | Order creation | 0
 | Cash recevied | 0
 | Address review | 0
 | Door locked | 0
 | Vehicle not ready | 0
 | Under delivery | 1
 | COD misused | 0
 | [NAME] | 0
 | (No response) | 1 |  |  |  |  | [NAME] for Sort the given table and remove the contents with Zero
 |  |  |  |  |  |  | Hello
 |  |  |  |  |  |  | I need to sort the given table and plot the non zero contents as shown in the attached excel file.
 |  |  |  |  |  |  | I have used 2 tables with helper formula and try to eliminate the helper table.
 |  |  |  |  |  |  | Any suggestions invited.
 |  |  |  |  |  |  | thanks in advance
Spreadsheet: 696372d1600784595-duplicate-data-in-rows-grouped-with-adjacent-data-transposed-into-column-200922-bins-rows-indexed-matching-into-columns
Sheet: Sheet1

 |  |  |  |  |  | [NAME]
Product | BIN | Bins Location | [NAME] | Key |  | Product | BIN | Bins Location | [NAME] | BIN | Bins Location | [NAME] | BIN | Bins Location | [NAME] | BIN | Bins Location | [NAME] | BIN | Bins Location | [NAME] | BIN | Bins Location | [NAME]
0,5/BLK | 1B | Cape Town Warehouse | Yes |  |  | 0,5/BLK | 1B | Cape Town Warehouse | Yes | 1G | Cape Town Warehouse | No | 2B | [NAME] | Yes | 2G | [NAME] | No | 3A | [NAME] | Yes | 4A | [NAME] | Yes
0,5/BLK | 1G | Cape Town Warehouse | No |  |  | 0,5/BLU | 1B | Cape Town Warehouse | Yes | 1G | Cape Town Warehouse | No | 2B | [NAME] | Yes | 2G | [NAME] | No | 3A | [NAME] | Yes | 4A | [NAME] | Yes
0,5/BLK | 2B | [NAME] | Yes |  |  | 0,5/RED | 1B | Cape Town Warehouse | Yes | 1G | Cape Town Warehouse | No | 2B | [NAME] | Yes | 2G | [NAME] | No | 3A | [NAME] | Yes | 4A | [NAME] | Yes
0,5/BLK | 2G | [NAME] | No
0,5/BLK | 3A | [NAME] | Yes
0,5/BLK | 4A | [NAME] | Yes |  |  | Product
0,5/BLU | 1B | Cape Town Warehouse | Yes |  |  | 0,5/BLK
0,5/BLU | 1G | Cape Town Warehouse | No |  |  | 0,5/BLU
0,5/BLU | 2B | [NAME] | Yes |  |  | 0,5/RED
0,5/BLU | 2G | [NAME] | No
0,5/BLU | 3A | [NAME] | Yes
0,5/BLU | 4A | [NAME] | Yes
0,5/RED | 1B | Cape Town Warehouse | Yes
0,5/RED | 1G | Cape Town Warehouse | No
0,5/RED | 2B | [NAME] | Yes
0,5/RED | 2G | [NAME] | No
0,5/RED | 3A | [NAME] | Yes
0,5/RED | 4A | [NAME] | Yes
Spreadsheet: 23891687-d3ad-48ac-ab69-c9b42d8b6e13
Sheet: Sheet1

Unnamed: 0 | INFORMACION GENERAL DE LA SOCIEDAD | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
NOMBRE O RAZON SOCIAL: |  |  |  |  |  |  |  |  |  | De uso exclusivo del Banco
NATURALEZA JURIDICA: |  |  |  |  |  |  |  |  |  | [NAME]
DOMICILIO: |  |  |  |  |  |  |  |  |  | [NAME]
[NAME]: |  |  |  | LOCALIDAD: |  |  |  |  |  | [NAME] |  | 2013-06-30 00:00:00
TELEFONO Y FAX: |  |  |  |  | MAIL:
FECHA DE BALANCE: |  | 2013-06-30 00:00:00 |  | NUMERO DE RUT:
GIRO PRINCIPAL:
[NAME]:
CAPACIDAD INSTALADA:
PERSONAL OCUPADO: |  | En Producción |  |  |  |  | En [NAME]
ESTADO DE LA CONTABILIDAD:
Libros Certificados |  |  |  |  |  |  | Moneda de los Est Contables
[NAME] sin L Cert |  |  |  |  |  |  | Tipo de Cambio de Cierre
Contabilidad Estimada
INTEGRACION: [NAME], Síndicos, Socios, Administradores, Apoderados |  |  |  |  |  |  | CARGO | VTO
VENTAS Y RESULTADOS DE LOS ULTIMOS CINCO EJERCICIOS
Ejercicio |  | Ventas |  |  |  |  | Resultados
INTEGRA GRUPO ECONOMICO |  |  | SI |  | NO
[NAME], Controlantes o Controladas |  |  |  | [NAME] |  |  | Actividad
[NAME] |  |  |  |  | Firma del Contador
Spreadsheet: daren_farmer__5694__Shipper Meter List
Sheet: Sheet1

 | DUKE ENERGY GUADALUPE PIPELINE
METER |  | REC/DEL |  | [NAME]
8740 |  | DEL |  | HPL - Katy
00491753 |  | DEL |  | [NAME]
00491754 |  | DEL |  | TXU [NAME]
00492756 |  | REC |  | Oasis [NAME]
00492760 |  | DEL |  | Tennessee [NAME]
00492762 |  | DEL |  | [NAME]
00491765 |  | DEL |  | Tejas [NAME]
00491773 |  | DEL |  | Tejas/Amoco Katy Ship Channel HP
00492810 |  | DEL |  | [NAME]
00492812 |  | REC |  | [NAME]
17-7462-50 |  | DEL |  | EPFS - DEFS Waha
17-6749-04 |  | DEL |  | Lone Star - DEFS Waha
17-0547-01 |  | REC/DEL |  | EPNG - [NAME]
08000007 |  | REC/DEL |  | West TX To EPFS Waha Header (Map Point)
Spreadsheet: 166067d1341451138-return-result-from-different-sheets-try
Sheet: Sheet3

UnscannedReason | FoundDeviceID | DeviceID | IP | Hostname | to remove | Reason | [NAME] | Business Application | DeviceType | OperatingSystem | Location | RescanPending | CredentialsAttempted | CredentialsSuccessful | CredentialsPending | FullyScanned | DestinationsNotPopulated | AssociatedFoundDevices | Ports | LastScanDate | OutofScope | LastAttemptErrors
Generic Failure | 7752 |  | 10.250.45.86 | AAALXP04.APIS.ABC.COM |  | Manual access OK | Live |  | WindowsServer | () | KUL Production Servers | 0 | 0 | 0 | 0 | 0 |  |  | 139. 22. 445 |  |  | Unable to perform scan : Could not connect to SAMBANET\AAALXP04 (10.250.45.86). [WMI - Connect]  The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)[WMI - Connect]  The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)[WMI - Connect]  The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)[WMI - Connect]  The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)[WMI - Connect]  The RPC server is unavailable. (Exception from HRESULT: 0x80070
No Connection | 7916 |  | 23.252.140.13 | ARCHER6.APIS.ABC.COM |  | Manual access OK | Live |  | Other | () | KUL Production Servers | 0 | 0 | 0 | 0 | 0 | No open port information
No Connection | 7046 |  | 23.252.140.12 | ARCHER5.APIS.ABC.COM |  | Manual access OK | Live |  | Other | () | KUL Production Servers | 0 | 0 | 0 | 0 | 0 | No open port information
Spreadsheet: 25372d1216671799-mass-data-sort-relocation-example
Sheet: Raw Data

37MT | 1993878 | 1 | 1985249 | Armature Asm
37MT | 1993878 | 2 | 10497770 | Bolt
37MT | 1993878 | 3 | 10497770 | Bolt
37MT | 1993878 | 4 | 10499639 | Bolt
37MT | 1993878 | 5 | 10468705 | Brush Plate Asm
37MT | 1993878 | 6 | 10511260 | [NAME]
37MT | 1993878 | 7 | 10486415 | [NAME]
37MT | 1993878 | 8 | 10468709 | CE Housing Asm
37MT | 1993878 | 9 | 10468109 | Connector
37MT | 1993878 | 10 | 1985262 | Drive Asm
37MT | 1993878 | 11 | 10468931 | Frame & Field Asm
37MT | 1993878 | 12 | 1964857 | Gasket
37MT | 1993878 | 13 | 10496035 | Housing-Nose Asm
37MT | 1993878 | 14 | 10511650 | Instruction Sheet
37MT | 1993878 | 15 | 10500414 | Insulator-Terminal
37MT | 1993878 | 16 | 1985335 | Lever Housing Asm
37MT | 1993878 | 17 | 10495537 | Motor Assembly Master
37MT | 1993878 | 18 | 9412305 | Nut
37MT | 1993878 | 19 | 1875882 | Plate-Name
37MT | 1993878 | 20 | 1949619 | Plug
37MT | 1993878 | 21 | 1945356 | Plug
37MT | 1993878 | 22 | 1986928 | Ring-Retaining
37MT | 1993878 | 23 | 10499637 | Screw
37MT | 1993878 | 24 | 1968998 | Screw
37MT | 1993878 | 25 | 10490963 | Screw
37MT | 1993878 | 26 | 10468814 | [NAME]
37MT | 1993878 | 27 | 1115689 | Solenoid & GA
37MT | 1993878 | 28 | 1965947 | Spacer
37MT | 1993878 | 29 | 1985982 | Stop-Pinion
37MT | 1993878 | 30 | 1985617 | Washer
37MT | 1993878 | 31 | 1985235 | Washer
37MT | 1993879 | 1 | 1985249 | Armature Asm
37MT | 1993879 | 2 | 10499639 | Bolt
37MT | 1993879 | 3 | 10497770 | Bolt
37MT | 1993879 | 4 | 10497770 | Bolt
37MT | 1993879 | 5 | 10468705 | Brush Plate Asm
37MT | 1993879 | 6 | 10511260 | [NAME]
37MT | 1993879 | 7 | 10486415 | [NAME]
37MT | 1993879 | 8 | 10468709 | CE Housing Asm
37MT | 1993879 | 9 | 10468109 | Connector
37MT | 1993879 | 10 | 1986244 | Drive Asm
37MT | 1993879 | 11 | 10468931 | Frame & Field Asm
37MT | 1993879 | 12 | 1964857 | Gasket
37MT | 1993879 | 13 | 1987887 | Housing-Nose Asm
37MT | 1993879 | 14 | 10511650 | Instruction Sheet
37MT | 1993879 | 15 | 10500414 | Insulator-Terminal
37MT | 1993879 | 16 | 1985335 | Lever Housing Asm
37MT | 1993879 | 17 | 10495537 | Motor Assembly Master
37MT | 1993879 | 18 | 9412305 | Nut
37MT | 1993879 | 19 | 1875882 | Plate-Name
37MT | 1993879 | 20 | 1945356 | Plug
37MT | 1993879 | 21 | 1986928 | Ring-Retaining
37MT | 1993879 | 22 | 1968998 | Screw
37MT | 1993879 | 23 | 10490963 | Screw
37MT | 1993879 | 24 | 10499637 | Screw
37MT | 1993879 | 25 | 10468814 | [NAME]
37MT | 1993879 | 26 | 1115689 | Solenoid & GA
37MT | 1993879 | 27 | 1965947 | Spacer
37MT | 1993879 | 28 | 1985982 | Stop-Pinion
37MT | 1993879 | 29 | 1985617 | Washer
37MT | 1993879 | 30 | 1985235 | Washer
Spreadsheet: 99081331-e3fd-4603-a43b-ce26ec286663
Sheet: Table 1.6

Monthly Statistical Bulletin
1.6 ANZ job advertisements
Month | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013–14
Advertisements (a) (b) – number
July | 119617.208 | 164133.31 | 174370.462 | 158166.342 | 128841.308
August | 122679.719 | 168234.867 | 171920.987 | 155159.997 | 126479.195
September | 127636.601 | 171158.866 | 169378.977 | 149458.184 | 126794.589
October | 128193.427 | 173978.008 | 168565.257 | 143378.989 | 126719.385
November | 133510.147 | 177217.38 | 167718.647 | 139815.846
December | 130535.036 | 183623.866 | 165414.572 | 136588.524
January | 135072.302 | 179237.686 | 163484.893 | 136068.724
February | 150111.172 | 175447.889 | 166234.506 | 138534.058
March | 152591.467 | 177447.541 | 165500.816 | 137019.668
April | 153484.779 | 181182.407 | 164714.9 | 134520.027
May | 159582.42 | 169110.018 | 161675.752 | 131639.582
June | 162729.829 | 175531.424 | 159877.517 | 129917.573
Annual average | 139554.4291666667 | 174478.4541666667 | 166697.545625 | 141110.5453478077
Annual change (b) – per cent
July | -51.37692842619239 | 37.21546652384664 | 6.237095931349951 | -9.292927147259606 | -18.54062857444095
August | -47.8687479605375 | 37.13339773789342 | 2.191055912327613 | -9.74924021347085 | -18.48466264149257
September | -44.37785796651608 | 34.09857725684815 | -1.039904646248372 | -11.76107764542702 | -15.16383672907467
October | -41.36045201095635 | 35.71523288787654 | -3.111169660018172 | -14.94155346614517 | -11.61927847043196
November | -33.5697128100092 | 32.73701211638993 | -5.359933094598287 | -16.63667189015662
December | -30.61358063889856 | 40.67017685581365 | -9.916627068509722 | -17.42654691873216
January | -20.02287921277945 | 32.69758740026508 | -8.788772803058826 | -16.76984857555005
February | -1.547357043661342 | 16.87863512250774 | -5.251350160160663 | -16.66347659492549
March | 9.171729371386578 | 16.28929486600977 | -6.73253905502134 | -17.20906802054679
April | 16.4375201898786 | 18.04584674810001 | -9.088910602672373 | -18.33159780930565
May | 21.4261076918803 | 5.97033056648721 | -4.396112121518432 | -18.57803017981324
June | 34.06098297425374 | 7.866778376569179 | -8.918008321974307 | -18.73931029339165
Annual average | -23.05857364973484 | 25.02537913597214 | -4.459524001877132 | -15.34935633350737
(a) Average total number of newspaper and internet job advertisements per week.
(b) Monthly figures have been seasonally adjusted. |  |  |  |  |  |  |  | Update
Source: ANZ Banking Group, Job advertisements series |  |  |  |  |  |  |  | 2002-12-09 00:00:00
Spreadsheet: 159470d1338674145-create-dynamic-data-validation-list-based-upon-criteria-data-validation-example
Sheet: Hourly

I need the Data Validation List in Column A to use Name "Lookup_Hourly_Names" to only include Employees from Name "Range_Employees" whos status is "Active" and Type is "Hourly"
Name | Rate | Start Date
[NAME]
Paris Hilton
[NAME]
Spreadsheet: 848748d1699386859-query-that-returns-a-yes-if-any-match-of-number-and-yes-response-in-a-different-row-example
Sheet: Sheet1

Numerical ID | Yes/No | Desired Output
123 | No | Yes
0 | Yes | Yes
456 | Yes | Yes
123 | Yes | Yes
123 | No | Yes
789 | No | No
789 | No | No
0 | Yes | Yes
Spreadsheet: eric_saibi__9959__110801R
Sheet: Far Rockaway 04

Owner Name |  | Keyspan Energy Company
Station Name |  | Far Rockaway Power Station
Unit Name |  | Far Rockaway 04
NERC Region |  | NPCC
State |  | NY
Fuel Type |  | Natural Gas
Capacity |  | 114 MW
Start Date |  | 2001-09-03 00:00:00
End Date |  | 2001-11-19 00:00:00
Prv. Start Date |  | 2001-09-03 00:00:00
Prv. End Date |  | 2001-12-09 00:00:00
Comments |  | Turbine O/H
SIC |  | 4911
Plant ID |  | 1507598
Unit ID |  | 1004310
Outage ID |  | 7413
Spreadsheet: chris_germany__2292__2000new12
Sheet: CGAS

 |  |  |  |  |  |  |  |  | Deal 502957 less Storage |  |  |  |  |  |  | IF On |  |  |  | 523459 / 523444 |  |  | Deal 502957
 | Deal |  | Storage | Storage |  | CES | ENA |  | Actuals |  | FOM |  |  | Total |  | Deal |  | [NAME] |  | Undertakes |  |  | Citygate
 | 502957 |  | Gross | Net |  | Transport | Transport |  | From ENA |  | Adjusted | 3rd Party | Spot Deals | Purch |  | 502957 |  | [NAME] SALES |  | [NAME] |  | Gas Daily | Price
1 | 68020 |  | 28121 |  |  | 140099 |  |  |  |  | 41858 |  |  |  |  |  |  |  |  |  |  | 6.58
 | 82996 |  | 29355 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.865
 | 84480 |  | 30872 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.865
 | 67441 |  | 22191 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.865
 | 93346 |  | 38706 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.815
 | 88509 |  | 39619 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.43
 | 75157 |  | 22574 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.155
 | 83388 |  | 30403 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.91
 | 75648 |  | 50215 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.41
 | 60794 |  | 35030 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.41
 | 55330 |  | 29442 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.41
 | 92288 |  | 67227 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10.53
 | 72488 |  | 29000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.15
Spreadsheet: 157851d1337890229-how-to-create-an-equation-to-calculate-results-for-a-judging-contest-hormel-scoring
Sheet: Placings & Cuts

 |  | Cuts
Placings | Total | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
1234 | Num | 1 | 3 | 6 | 10 | 15 | 21 | 28 | 33 | 36 | 37 | 36 | 33 | 15
1243 |  | 111 | 112 | 113 | 114 | 115 | 116 | 117 | 127 | 137 | 147 | 157 | 167 | 357
1324 |  |  | 121 | 122 | 123 | 124 | 125 | 126 | 136 | 146 | 156 | 166 | 176 | 447
1342 |  |  | 211 | 131 | 132 | 133 | 134 | 135 | 145 | 155 | 165 | 175 | 257 | 456
1423 |  |  |  | 212 | 141 | 142 | 143 | 144 | 154 | 164 | 174 | 247 | 266 | 537
1432 |  |  |  | 221 | 213 | 151 | 152 | 153 | 163 | 173 | 237 | 256 | 275 | 546
 |  |  |  | 311 | 222 | 214 | 161 | 162 | 172 | 227 | 246 | 265 | 347 | 555
2134 |  |  |  |  | 231 | 223 | 215 | 171 | 217 | 236 | 255 | 274 | 356 | 627
2143 |  |  |  |  | 312 | 232 | 224 | 216 | 226 | 245 | 264 | 337 | 365 | 636
2314 |  |  |  |  | 321 | 241 | 233 | 225 | 235 | 254 | 273 | 346 | 374 | 645
2341 |  |  |  |  | 411 | 313 | 242 | 234 | 244 | 263 | 327 | 355 | 437 | 654
2413 |  |  |  |  |  | 322 | 251 | 243 | 253 | 272 | 336 | 364 | 446 | 717
2431 |  |  |  |  |  | 331 | 314 | 252 | 262 | 317 | 345 | 373 | 455 | 726
 |  |  |  |  |  | 412 | 323 | 261 | 271 | 326 | 354 | 427 | 464 | 735
3124 |  |  |  |  |  | 421 | 332 | 315 | 316 | 335 | 363 | 436 | 473 | 744
3142 |  |  |  |  |  | 511 | 341 | 324 | 325 | 344 | 372 | 445 | 527 | 753
3214 |  |  |  |  |  |  | 413 | 333 | 334 | 353 | 417 | 454 | 536
3241 |  |  |  |  |  |  | 422 | 342 | 343 | 362 | 426 | 463 | 545
3412 |  |  |  |  |  |  | 431 | 351 | 352 | 371 | 435 | 472 | 554
3421 |  |  |  |  |  |  | 512 | 414 | 361 | 416 | 444 | 517 | 563
 |  |  |  |  |  |  | 521 | 423 | 415 | 425 | 453 | 526 | 572
4123 |  |  |  |  |  |  | 611 | 432 | 424 | 434 | 462 | 535 | 617
4132 |  |  |  |  |  |  |  | 441 | 433 | 443 | 471 | 544 | 626
4213 |  |  |  |  |  |  |  | 513 | 442 | 452 | 516 | 553 | 635
4231 |  |  |  |  |  |  |  | 522 | 451 | 461 | 525 | 562 | 644
4312 |  |  |  |  |  |  |  | 531 | 514 | 515 | 534 | 571 | 653
4321 |  |  |  |  |  |  |  | 612 | 523 | 524 | 543 | 616 | 662
 |  |  |  |  |  |  |  | 621 | 532 | 533 | 552 | 625 | 671
 |  |  |  |  |  |  |  | 711 | 541 | 542 | 561 | 634 | 716
 |  |  |  |  |  |  |  |  | 613 | 551 | 615 | 643 | 725
 |  |  |  |  |  |  |  |  | 622 | 614 | 624 | 652 | 734
 |  |  |  |  |  |  |  |  | 631 | 623 | 633 | 661 | 743
 |  |  |  |  |  |  |  |  | 712 | 632 | 642 | 715 | 752
 |  |  |  |  |  |  |  |  | 721 | 641 | 651 | 724 | 761
 |  |  |  |  |  |  |  |  |  | 713 | 714 | 733
 |  |  |  |  |  |  |  |  |  | 722 | 723 | 742
 |  |  |  |  |  |  |  |  |  | 731 | 732 | 751
 |  |  |  |  |  |  |  |  |  |  | 741
Spreadsheet: 275ff860-dc36-423c-96dd-2a564e8de642
Sheet: Sheet1

Current Position | Previous Position | Forename | Surname | County | Total Points | Total Events Played | Total Ranking Points | Ranking Events | Ranking Points | Ranking Group
1 | 1 | Betty | BLAIR | Dv | 51549 | 5 | 42871 | 4 | 10717.75 | 45
2 | 2 | [NAME] | BRYANT | Ca | 38048 | 4 | 38048 | 4 | 9512 | 40
3 | 3 | Cathy | BARGH | Sx | 42373 | 5 | 35702 | 4 | 8925.5 | 50
4 | 5 | [NAME] | WALKER | Sh | 25911 | 4 | 25911 | 4 | 6477.75 | 50
5 | 11 | Caroline | HALE | Ht | 21305 | 2 | 21305 | 4 | 5326.25 | 40
6 | 4 | [NAME] | EASTWOOD | Ch | 19778 | 3 | 19778 | 4 | 4944.5
7 | 6 | [NAME] | SHEARD | Yo | 14544 | 2 | 14544 | 4 | 3636 | 45
8 | 7 | Beryl | GOODALL | Nn | 14310 | 3 | 14310 | 4 | 3577.5 | 65
9 | 8 | Jenette | MCWHIRTER | Cu | 13374 | 2 | 13374 | 4 | 3343.5 | 50
10 | 9 | [NAME] | HARRIS | Bd | 12508 | 2 | 12508 | 4 | 3127 | 55
11 | 10 | Julie | BRADBURY | Ox | 12190 | 1 | 12190 | 4 | 3047.5 | 40
12 | 12 | [NAME] | PETCH | Yo | 10022 | 2 | 10022 | 4 | 2505.5 | 60
13 | 13 | [NAME] | HUTCHINSON | Ex | 9927 | 1 | 9927 | 4 | 2481.75
14 | 14 | [NAME] | WOOD | Db | 8120 | 1 | 8120 | 4 | 2030 | 50
15 | 15 | [NAME] | WARRENER |  | 7602 | 1 | 7602 | 4 | 1900.5 | 45
16 | 16 | Christine | CROSSLEY | Sy | 7120 | 1 | 7120 | 4 | 1780 | 55
17 | 17 | [NAME] | FLETCHER | Db | 5505 | 1 | 5505 | 4 | 1376.25 | 60
18 | 18 | Roz | CLARK | Nd | 5168 | 1 | 5168 | 4 | 1292 | 50
19 | 19 | [NAME] | ATHERTON | La | 4854 | 1 | 4854 | 4 | 1213.5 | 50
20 | 20 | Vicky | BETTS | Ha | 4288 | 1 | 4288 | 4 | 1072 | 65
Spreadsheet: kam_keiser__18016__Summary of Book Requests
Sheet: Central

 | COUNTERPARTY |  | BOOK PURPOSE |  |  | TAGG |  |  |  |  |  |  |  |  | BOOK INFORMATION
 |  |  | Type Of Transactions |  |  | Book Mapping
CP ID | Short Name | Long Name | Internal | External | Both | Code | Region | P | B | Idx | [NAME] | PHY | Y | Commodity/UOM/Curr | [NAME] | MTM or ACCRUAL | Reason For Book | Date Needed
166839 | FB-CENT1 | FB-CENT1 |  |  | X | MF | CENT1 | X | X | X | X |  | X | NG/MMBUT/USD | [NAME] | MTM | new company
166844 | FB-CENT2 | FB-CENT2 |  |  | X | MF | CENT2 | X | X | X | X |  | X | NG/MMBUT/USD | [NAME] | MTM | new company
166849 | FB-CENT3 | FB-CENT3 |  |  | X | MF | CENT3 | X | X | X | X |  | X | NG/MMBUT/USD | [NAME] | MTM | new company
166852 | FB-CENT4 | FB-CENT4 |  |  | X | MF | CENT4 | X | X | X | X |  | X | NG/MMBUT/USD |  | MTM | new company
166854 | FB-CENT5 | FB-CENT5 |  |  | X | MF | CENT5 | X | X | X | X |  | X | NG/MMBUT/USD |  | MTM | new company
166857 | FB-CENT6 | FB-CENT6 |  |  | X | MF | CENT6 | X | X | X | X |  | X | NG/MMBUT/USD | [NAME] | MTM | new company
167093 | PB-CENT1 | PB-CENT1 |  |  | X | MP | CENT1 |  |  |  |  | X |  | NG/MMBUT/USD | [NAME] | MTM | new company
167094 | PB-CENT2 | PB-CENT2 |  |  | X | MP | CENT2 |  |  |  |  | X |  | NG/MMBUT/USD | [NAME] | MTM | new company
167095 | PB-CENT3 | PB-CENT3 |  |  | X | MP | CENT3 |  |  |  |  | X |  | NG/MMBUT/USD | [NAME] | MTM | new company
167096 | PB-CENT4 | PB-CENT4 |  |  | X | MP | CENT4 |  |  |  |  | X |  | NG/MMBUT/USD |  | MTM | new company
167097 | PB-CENT5 | PB-CENT5 |  |  | X | MP | CENT5 |  |  |  |  | X |  | NG/MMBUT/USD |  | MTM | new company
167098 | PB-CENT6 | PB-CENT6 |  |  | X | MP | CENT6 |  |  |  |  | X |  | NG/MMBUT/USD | [NAME] | MTM | new company
166922 | PB-HDG-CENT1 | PB-HDG-CENT1 |  |  | X | MP | CENT |  |  |  |  | X |  | NG/MMBUT/USD | [NAME] | MTM | new company
166923 | PB-HDG-CENT2 | PB-HDG-CENT2 |  |  | X | MP | CENT |  |  |  |  | X |  | NG/MMBUT/USD | [NAME] | MTM | new company
166927 | PB-HDG-CENT3 | PB-HDG-CENT3 |  |  | X | MP | CENT |  |  |  |  | X |  | NG/MMBUT/USD | [NAME] | MTM | new company
166924 | PB-HDG-CENT4 | PB-HDG-CENT4 |  |  | X | MP | CENT |  |  |  |  | X |  | NG/MMBUT/USD |  | MTM | new company
166925 | PB-HDG-CENT5 | PB-HDG-CENT5 |  |  | X | MP | CENT |  |  |  |  | X |  | NG/MMBUT/USD |  | MTM | new company
166926 | PB-HDG-CENT6 | PB-HDG-CENT6 |  |  | X | MP | CENT |  |  |  |  | X |  | NG/MMBUT/USD | [NAME] | MTM | new company
Spreadsheet: 138298d1327596532-find-the-3-most-recent-occurances-book1
Sheet: Sheet1

Apple | 12 |  |  | Pear | 8 | 7 | 3
Orange | 4
Pear | 7
Pear | 8
Orange | 14
Orange | 2
Apple | 1
Orange | 9
Bannana | 18
Orange | 7
Apple | 4
Orange | 25
Bannana | 32
Pear | 10
Pear | 8
Apple | 7
Pear | 3
Spreadsheet: 713134d1610563843-need-help-reformatting-data-possibly-expand-and-rotate-tablehelp
Sheet: Sheet1

Player | Team | Pos | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17
[NAME] | TEN | WR | 0.81 |  |  |  | 0.71 | 0.84 | 0.93 | 0.95 | 0.82 | 0.75 | 0.81 | 0.81 | 0.86 | 0.56 | 0.84 | 0.76 | 0.9
A.J. Dillon | GB | RB | 0.06 | 0.1 |  | 0.05 |  | 0.16 | 0.23 | 0.13 |  |  |  |  |  |  | 0.08 | 0.58 | 0.11
A.J. Green | CIN | WR | 0.66 | 0.62 | 0.76 | 0.71 | 0.42 | 0.79 | 0.87 | 0.85 |  | 0.83 | 0.79 | 0.82 | 0.87 | 0.88 | 0.91 | 0.74 | 0.79
Player | Team | Pos | Index | Value
 |  |  |  | 0.05
 |  |  |  | 0.16
 |  |  |  | 0.23
 |  |  |  | 0.13
 |  |  |  | 0.08
 |  |  |  | 0.58
 |  |  |  | 0.11
 |  |  |  | 0.66
 |  |  |  | 0.62
 |  |  |  | 0.76
 |  |  |  | 0.71
 |  |  |  | 0.42
 |  |  |  | 0.79
 |  |  |  | 0.87
 |  |  |  | 0.85
 |  |  |  | 0.83
 |  |  |  | 0.79
 |  |  |  | 0.82
 |  |  |  | 0.87
 |  |  |  | 0.88
 |  |  |  | 0.91
 |  |  |  | 0.74
 |  |  |  | 0.79
Spreadsheet: 674616d1587951616-list-multiple-pages-and-remove-duplicates-test123-xatomicx-
Sheet: Monday

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sunday | Monday (new) |  | Cumulative
 | [NAME]
 | Orlaith Connelly
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Lorelei Daniel
 | Darsh Bartlett
 | [NAME]
Total