tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 542d9e5e-284e-4f13-9463-fad62f69c54c
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
44046640 | 2014-11-16 11:53:27 | ALLIES | 0 | 1 | 6 | 470347 | hilarion lefuneste | 12497 | pacific | 1942-09-12 | 1942-09-14 | Bloody Ridge | [NAME]
44046838 | 2014-11-16 12:22:10 | AXIS | 0 | 4 | 6 | 470347 | hilarion lefuneste | 12497 | pacific | 1942-09-12 | 1942-09-14 | Bloody Ridge | [NAME]
44096750 | 2014-11-19 22:12:09 | ALLIES | 1 | 6 | 2 | 1239105 | Ker-Gamell | 12504 | mediterranean | 1943-11-05 | 1943-11-13 | [NAME] | [NAME]
44097500 | 2014-11-19 22:47:22 | AXIS | 1 | 6 | 2 | 1239105 | Ker-Gamell | 12504 | mediterranean | 1943-11-05 | 1943-11-13 | [NAME] | [NAME]
44123055 | 2014-11-21 21:58:07 | ALLIES | 0 | 3 | 5 | 222901 | [NAME] | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
44123343 | 2014-11-21 22:29:40 | AXIS | 0 | 4 | 5 | 222901 | [NAME] | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
44124899 | 2014-11-22 00:17:15 | ALLIES | 1 | 5 | 0 | 1240562 | Big Taz | 12500 | pacific | 1943-01-13 | 1943-01-13 | Clearing Matanikau River | Nettoyage du secteur Matanikau
44125129 | 2014-11-22 00:37:55 | AXIS | 0 | 3 | 5 | 1240562 | Big Taz | 12500 | pacific | 1943-01-13 | 1943-01-13 | Clearing Matanikau River | Nettoyage du secteur Matanikau
Spreadsheet: 69514d1270040272-looking-up-positive-data-and-returning-information-stock
Sheet: Sheet1

 |  |  |  |  |  | SMITH | GARDNER | BRAIN | DUBOIS | CODEL | BRAND | SPOONS | JONES
 | PRODUCT
 | Apples 12.5Kg x 13 Country of Origin  Chile
 | [NAME] 12 x 250g Country of Origin UK |  |  |  |  | 23 |  |  |  |  | 64 |  |  | 1
 | Blackberries 8 x 200g Country of Origin UK
 | Blueberries 16 x 150g Country of Origin  Poland |  |  |  |  |  |  | 45 |  |  |  |  |  | 2
 | Broccoli (Bulk) Country of Origin UK
 | [NAME] 9kg - 22 x 30
 | Carrots 12 x 1kg Country of Origin UK |  |  |  |  |  |  |  |  |  |  | 12 |  | 3
 | Cauliflower  (Bulk) Country of Origin Germany
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 | [NAME] 12 x 250g Country of Origin UK |  |  |  |  | 87
 | Blueberries 16 x 150g Country of Origin  Poland |  |  |  |  | 45
 | Carrots 12 x 1kg Country of Origin UK |  |  |  |  | 12
Spreadsheet: daren_farmer__5577__Beaumont_Oct2000
Sheet: Mtr 98-1428

 | Meter # | October 2000 - Meter 1428
 |  |  | Amoco |  | Tejas |  | Conoco |  | Beaumont |  | [NAME]
 |  |  | 012-03149-02-012 |  | 012-27106-02-001 |  | 012-19785-02-006 |  | 012-41500-02-015 |  | 012-41500-02-015
 | Track ID |  |  |  |  |  |  |  | 417714 |  | 249110 |  | 418196
 | Deal # |  |  |  |  |  |  |  |  |  |  |  | Beaumont | Beaumont |  | Beaumont
 |  | Flow | Noms | Alloc | Noms | Alloc | Noms | Alloc | Noms | Alloc | Noms | Alloc | Swing | Buyback |  | Brokered
 | 1 | 18028 | 0 |  |  |  | 0 |  | 18000
 | 2 | 18037 | 0 |  |  |  | 0 |  | 18000
 | 3 | 18030 | 0 |  |  |  | 0 |  | 18000
 | 4 | 18027 | 0 |  |  |  | 0 |  | 18000
 | 5 | 18031 | 0 |  |  |  | 0 |  | 18000
 | 6 | 18029 | 0 |  |  |  | 0 |  | 18000
 | 7 | 18029 | 0 |  |  |  | 0 |  | 18000
 | 8 | 18053 | 0 |  |  |  | 0 |  | 18000
 | 9 | 18053 | 0 |  |  |  | 0 |  | 18000
 | 10 | 18056 | 0 |  |  |  | 0 |  | 18000
 | 11 | 18054 | 0 |  |  |  | 0 |  | 18000
 | 12 | 18055 | 0 |  |  |  | 0 |  | 18000
 | 13 | 18056 | 0 |  |  |  | 0 |  | 18000
 | 14 | 18056 | 0 |  |  |  | 0 |  | 18000
 | 15 | 18051 | 0 |  |  |  | 0 |  | 18000
 | 16 | 18055 | 0 |  |  |  | 0 |  | 18000
 | 17 | 18054 | 0 |  |  |  | 0 |  | 18000
 | 18 | 18055 | 0 |  |  |  | 0 |  | 18000
 | 19 | 18056 | 0 |  |  |  | 0 |  | 18000
 | 20 | 18056 | 0 |  |  |  | 0 |  | 18000
 | 21 | 29885 | 0 |  |  |  | 0 |  | 18000
 | 22 | 12036 | 0 |  |  |  | 0 |  | 18000
 | 23 | 17146 | 0 |  |  |  | 0 |  | 18000
 | 24 | 17050 | 0 |  |  |  | 0 |  | 18000
 | 25 | 17636 | 0 |  |  |  | 0 |  | 18000
 | 26 | 18059 | 0 |  |  |  | 0 |  | 18000
 | 27 | 18055 | 0 |  |  |  | 0 |  | 18000
 | 28 | 18804 | 0 |  |  |  | 0 |  | 18000
 | 29 | 18056 | 0 |  |  |  | 0 |  | 18000
 | 30 | 18047 | 0 |  |  |  | 0 |  | 18000
 | 31 | 18060 | 0 |  |  |  | 0 |  | 18000
 |  | Total Noms
 |  | Total Alloc
Spreadsheet: 799207d1664983947-automatic-generated-list-based-on-condition-gta
Sheet: Vehicle Cargo

Name | Range | Acq | Collection Acq | Collection Plate |  | Collections |  |  |  |  |  |  | Duplicates to sell
Z-Type | Top |  |  | B1GM0N3Y |  | Name | Collector/Plate | Bonus/Range | [NAME] | Collection Ready |  |  | Name | Range
ETR1 | Top | 1
811 | Top | 1 |  |  |  | Uninsurable | [NAME] | 35000
[NAME] | Top | 1 | 1 | SL33K |  | [NAME] | M4K3B4NK | Top
Reaper | Top | 1 |  |  |  | T20 | D3V1L | Top
Mamba | Top |  |  |  |  | [NAME] | SL33K | Top
FMJ | Top | 1
Stirling GT | Top | 1 |  |  |  | End Of Empires | The Sultan of Amir | 20000
[NAME] | Top |  |  | M4K3B4NK |  | Roosevelt Valor | OLDT1M3R | Top
Tyrus | Top | 1 |  |  |  | Z-Type | B1GM0N3Y | Top
T20 | Top |  |  | D3V1L
Roosevelt Valor | Top | 1 |  | OLDT1M3R
Sum missing
Coquette Classic | Mid | 1
Verlierer | Mid
Zentorno | Mid
[NAME] | Mid | 1
Sultan RS | Mid | 1
Cheetah | Mid | 1
[NAME] | Mid
Omnis | Mid | 1
Entity XF | Mid | 1
Coquette BlackFin | Mid | 1
Sum missing
Turismo R | Standard | 1
Tampa | Standard | 1
[NAME] | Standard
Nightshade | Standard
Massacro | Standard | 1
Jester | Standard | 1
Feltzer | Standard
Bestia GTS | Standard | 1
Alpha | Standard
Banshee 900R | Standard
Sum missing
Spreadsheet: 849556d1699983983-excel-average-for-worker-by-month-tester
Sheet: Holidays

2023-01-01 00:00:00
2023-01-16 00:00:00
2023-04-20 00:00:00
2023-05-29 00:00:00 |  |  |  |  |  | [NAME] |  |  | Agency |  | Yes
2023-06-19 00:00:00 |  |  |  |  |  | [NAME] |  |  | Agency / CDWA |  | No
2023-07-04 00:00:00 |  |  |  |  |  | [NAME] |  |  | Agency (Unstaffed)
2023-09-04 00:00:00 |  |  |  |  |  | [NAME] |  |  | CDWA
2023-11-10 00:00:00 |  |  |  |  |  | Marsh |  |  | CDWA (Unstaffed)
2023-11-11 00:00:00 |  |  |  |  |  | Ridolfi |  |  | Residential
2023-11-23 00:00:00 |  |  |  |  |  | Rule
2023-11-24 00:00:00 |  |  |  |  |  | Smith
2023-12-25 00:00:00 |  |  |  |  |  | [NAME]
Spreadsheet: 86455d1286425082-how-to-paste-only-numeric-data-of-a-copied-column-sample
Sheet: Sheet1

 |  | 01:36:30:00 | 01:47:11:00 |  |  |  |  |  | 01:36:30:00 | 01:47:11:00
 |  | [NAME] | 02:01:44:00 | 01:04:00:00 | 33 |  |  |  | 02:01:44:00 | 01:04:00:00
 |  | 02:01:44:00 | 01:04:00:00 |  |  |  |  |  | 02:01:44:00 | 01:04:00:00
 |  | Budjet | [NAME] | 02:12:39:00 | 02:17:21:00 | 6 |  |  | 02:12:39:00 | 02:17:21:00
 |  | 02:17:39:00 | 02:20:21:00 |  |  |  |  |  | 02:17:39:00 | 02:20:21:00
 |  | story | co-actors |  | 02:17:39:00 | 02:20:21:00 |  |  | 02:17:39:00 | 02:20:21:00
 |  |  | 01:02:00:00 | 01:03:52:00 | 24 | On [NAME] |  |  | 01:02:00:00 | 01:03:52:00
 |  |  | 01:03:53:00 | 01:07:24:00 | NULL | Event |  |  | 01:03:53:00 | 01:07:24:00
 |  |  | lollypop choreographer and a item number in pakistani films | Pakistani Actor | 01:14:15:00 | 01:14:10:00 |  |  | [NAME] | 01:14:10:00
 |  |  | Director and [NAME] | 01:16:39:00 | 01:20:37:00 | 1 |  |  | 01:16:39:00 | 01:20:37:00
 |  |  | ΓÇªabout [NAME]..Director..about the audience..and other projects | Actress | 01:20:40:00 | 01:31;03:00 |  |  | 01:20:40:00 | 01:31;03:00
 |  |  |  |  | DO NOT WANT
Spreadsheet: 97174d1296409240-fetching-price-in-the-lpo-fetching-price-in-the-lpo
Sheet: Purchase Ordere

 | Product | Packing | Quantity | Price per | Price total
 | [NAME] | C | 3 | 28 | 84
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 | TOTAL |  |  |  | 84
Spreadsheet: 93741d1293497603-commission-calculation-using-sumifs-commissionlookup
Sheet: New Hire 1

CONTRACT COMMISSIONS
New Hire 1 |  | NH1
2011
Class | Month |  | Client Billed | Invoice Date |  | Invoice # | [NAME] |  | Total GP / Hour | [NAME] % | # [NAME] | GP Earned
af | jan |  |  |  |  |  |  |  | 45 | 0.2 | 40
it | feb |  |  |  |  |  |  |  | 80 | 0.5 | 80
fs | [NAME] |  |  |  |  |  |  |  | 62 | 0.5 | 40
af | apr |  |  |  |  |  |  |  | 45 | 0.75 | 40
it | apr |  |  |  |  |  |  |  | 45 | 0.75 | 40
 |  |  | GP | Commission |  | GP | Commission |  | GP | Commission | YTD GP Earned By Class |  |  | YTD Commission Earned By Class
Month | Monthly Commission Rate |  | IT |  |  | AF |  |  | FS |  | IT | AF | FS | IT | AF | FS | YTD GP | YTD Commission
Dec | 0.3
Nov | 0.3
Oct | 0.3
Sep | 0.3
Aug | 0.3
Jul | 0.3
Jun | 0.3
May | 0.3
Apr | 0.3
Mar | 0.3
Feb | 0.3
Jan | 0.3
Total
 |  |  |  |  |  |  | Total GP - Check #
 |  |  |  |  |  |  | Tot YTD Comm - Check #
 | [NAME] |  | Commission |  |  | Salary | Commission
 | 0 |  | 35 |  |  | 105000
 | 200000 |  | 40 |  |  | 200100
 | 300000 |  | 45 |  |  | 380000
 | 400000
Spreadsheet: phillip_m_love__30645__finliq07
Sheet: Summary

Jul 99 liquidations
July - FINANCIAL | Central | East | West | 12 Texas | 16 & 78 Texas | Storage | Transport | Canada | Brooklyn Union | TOTAL
PG BOOK | -796991.68 | -287579.83 | -877820 |  | 0 | -2089050 | 0 | 220000 | 668270.46 |  | 2644958.79 | 0
P& BOOK | -2955 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PE BOOK | 0 | 0 | 0 | -1416080 | 0 | 0 | 0 | 0 | 0
PX BOOK | 0 | 0 | -4350 | 0 | 0 | 0 | 0 | 0 | 0
P! BOOK | 104160 | 3286 | -28892 | 0 | 0 | 0 | 0 | 0 | 0
NB BOOK | 0 | 0 | 0 | -12086.22 | 0 | 49100 | 0 | 0 | 0
Ontario Book | 87511 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
E# NEW BOOK | -11849 | -432019.5 | -142434.88 | 0 | -158769.5 | 0 | 0 | 0 | 0
OMICRON | -54185 | 291691.46 | 13983.5 | -62067 | 0 | 0 | 0 | 0 | 0
GN BOOK | -60722.33 | 191820.29 | 7468.98 | 0 | -90463.78 | 0 | 0 | 0 | 0
GG BOOK | 30209.33 | 3596805.3 | -87942.97 | 0 | 1643 | 333616.76 | 0 | -34100.11 | -1245411.2
GG BOOK TX | -5580 | 0 | 3100 | 0 | -76160.78 | 265098.5 | 0 | 0 | 0
QN BOOK | 0 | 0 | 16585 | 0 | 0 | 0 | 0 | 0 | 0
GA BOOK | 0 | -361026.66 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FX TRADE | -15532 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other | 220449.78 | 7186 | 269135.63 | -1169929 | 0 | 42982 | 0 | -41475 | 0
GX BOOK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
GR BOOK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
GB BOOK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
GV BOOK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NGL BOOK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
RESID BOOK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CRUDE BOOK   (PC) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Gas Daily New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NB INDEX BOOK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
IGI INDEX BOOK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
IGI INDEX BOOK TEXAS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
GAI BOOK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
GBI BOOK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
GVI BOOK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PEI  INDEX BOOK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] BOOK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
QKI INDEX BOOK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EF BOOK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
HO BOOK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EA BOOK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
E? BOOK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
OTHER | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CITRUS AMORT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4T | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 879771d1727331953-capture-data-from-multiple-sheets-sample-data-new-
Sheet: 192-UVW

 |  |  | GAP
 |  |  | BU2424 | BU2525
 |  |  | 104 NNN | 104 NNN
PN | Buyer | Type | Total | Total
192S | [NAME] | JJ | 20 | 30
192S | Pou | JJ | 20 | 10
192S | [NAME] | MM | 50 | 10
Spreadsheet: 67502d1268127301-how-to-separate-data-from-1-column-to-3-column-1-20column-20to-203-20column-1-
Sheet: Sheet1

06660 |  |  |  |  | 06660
SUREUP 42300 NASIR |  |  |  | SUREUP | 42300 | NASIR
28500 |  |  |  |  | 28500
SUREUP 01000 AZIMAN |  |  |  | SUREUP | 1000 | AZIMAN
BATU PAHAT |  |  |  |  | BATU PAHAT
26070 |  |  |  |  | 26060
Sureup 15150 [NAME] |  |  |  | SUREUP | 15150 | [NAME]
43650 |  |  |  |  | 43650
SUREUP 02500 WAN |  |  |  | SUREUP | 2500 | WAN
SUREUP 81000 SAMSUDIN |  |  |  | SUREUP | 81000 | SAMSUDIN
SUREUP 48000 WANN |  |  |  | SUREUP | 48000 | WANN
68100 |  |  |  |  | 68100
Sureup 76100 din |  |  |  | SUREUP | 76100 | DIN
IPOH |  |  |  |  | IPOH
BWORTH |  |  |  |  | BWORTH
Spreadsheet: 67645d1268225059-vlookup-for-range-vlookup
Sheet: Sheet1

Raw Data | Current Vlookup | [NAME] result | Category list
208501 | #N/A | 0 | 891578 | 1
209388 | #N/A | 0 | 895247 | 2
209489 | #N/A | 0 | 900934 | 3
891578 | 1 | 1 | 904652 | 4
904601 | 23 | 23 | 905026 | 5
891578 | 1 | 1 | 930596 | 6
904600 | 22 | 22 | 930755 | 7
904605 | 27 | 27 | 930797 | 8
204880 | #N/A | 0 | 931140 | 9
205447 | #N/A | 0 | 909546 | 10
208501 | #N/A | 0 | 891579 | 11
208502 | #N/A | 0 | 931169 | 12
208503 | #N/A | 0 | 904637 | 13
208504 | #N/A | 0 | 904638 | 14
891578 | 1 | 1 | 904639 | 15
207628 | #N/A | 0 | 904640 | 16
207629 | #N/A | 0 | 931662 | 17
208994 | #N/A | 0 | 904596 | 18
209523 | #N/A | 0 | 904597 | 19
891578 | 1 | 1 | 904598 | 20
904597 | 19 | 19 | 904599 | 21
904637 | 13 | 13 | 904600 | 22
904638 | 14 | 14 | 904601 | 23
 |  |  | 904602 | 24
 |  |  | 904603 | 25
 |  |  | 904604 | 26
 |  |  | 904605 | 27
 |  |  | 904606 | 28
 |  |  | 904607 | 29
 |  |  | 904608 | 30
 |  |  | 904609 | 31
 |  |  | 904610 | 32
 |  |  | 904611 | 33
 |  |  | 905401 | 34
 |  |  | 909502 | 35
 |  |  | 909503 | 36
 |  |  | 931701 | 37
 |  |  | 931885 | 38
 |  |  | 931940 | 39
 |  |  | 932186 | 40
 |  |  | 932182 | 41
 |  |  | 932240 | 42
 |  |  | 200000-299999 | 0
Spreadsheet: 866460d1713369063-looking-for-a-way-to-filter-a-text-variable-kansas-scheduler-v4-6-
Sheet: Kitting Schedule

[NAME] from date below↓ | ↓Minimum # of Kits↓ | DO NOT EDIT IN THIS REPORT
2024-04-04 00:00:00 | 25
Client | Job # | # of Stores | # of Pieces | Ship Date | Notes
 | 246061 | 120 | 120 | 2024-04-10 00:00:00 | 0
HALL 246063 [10] | 246063 | 50 | 50 | 2024-04-10 00:00:00 | 0
P&S 246437 [10] | 246437 | ? | 5650 | 2024-04-10 00:00:00 | 0
Spreadsheet: 710337d1608851861-help-pulling-data-from-a-range-attendance-template
Sheet: November

Employee Absence Schedule
November | Dates of Absence
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
Employee Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 |  | CI | T | NCNS | Total Points
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Obed Attamah
[NAME]
[NAME]
Keath Grimes
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 798133d1664319063-lookup-based-on-multiple-values-example-18-
Sheet: Sheet1

Date | Name | Job Role | Location | Code
2022-10-15 00:00:00 | [NAME] | [NAME] | B&Q - Banbury
2022-10-15 00:00:00 | Mark | [NAME] | B&Q - Banbury
2022-10-15 00:00:00 | [NAME] | [NAME] | B&Q - Banbury
2022-10-15 00:00:00 | [NAME] | [NAME] | B&Q - Banbury
2022-10-15 00:00:00 | [NAME] | Manager | B&Q - Banbury
2022-10-15 00:00:00 | [NAME] | [NAME] | B&Q - Ayr
2022-10-22 00:00:00 | [NAME] | [NAME] | B&Q - Ayr
2022-10-22 00:00:00 | [NAME] | [NAME] | B&Q - Ayr
2022-10-22 00:00:00 | [NAME] | Deputy Manager | B&Q - Ayr
2022-10-22 00:00:00 | [NAME] | Manager | B&Q - Ayr
2022-10-22 00:00:00 | [NAME] | [NAME] | B&Q - Ayr
Spreadsheet: 135462d1326079202-need-help-with-what-should-be-a-simple-if-mrhoward
Sheet: Sheet3

1125750 | AC | G | False | CASE | 1-400UN CONTAINER SAND HINGED SMARTLO | 1 | 99
1127695 | AC | G | False | CASE | 6-12 SHAKER S&P 2Z GLS SS TOPS | 1 | 99
1128290 | AC | G | False | CASE | 1-1000 LID DOME HOT BRN CF 14OZ | 1 | 99
1128300 | AC | G | False | CASE | 1-2400UN LID CUP PORT | 1 | 99
1128310 | AC | G | False | CASE | 1-1000UN PAPER WAX 14X24 | 1 | 99
1128516 | AC | G | False | CASE | 1-36 MUG CHINA BIL-RED 15OZ | 1 | 99
1128709 | AC | G | False | CASE | 1-24 BOWL CHINA RED #8304 | 1 | 99
1128717 | AC | G | False | CASE | 12-1000ML SANITIZER LEVER MED | 1 | 99
1128723 | AC | G | False | CASE | 4-3.78L CLEANER GLASS | 1 | 99
1128753 | AC | G | False | CASE | 1-1000UN BAG SAND HOT | 1 | 99
Spreadsheet: 0274215f-7864-4b61-8c3d-01769d633394
Sheet: Sheet1

Contract Number | [NAME] | Project Name | Term Start Date | Exp. Date | Project Amount / Annual Amount | Date Executed
13-PW-06 | HDR Engineering, Inc. | Lincoln Avenue Phase II - Paseo del Volcan to Chayote Road | 2012-10-24 00:00:00 | 2013-10-23 00:00:00 | 463837.25 | 2012-10-24 00:00:00
13-PW-13 | Altor Construction Inc. | Pedestrian Safety Improvements on City Streets | 2012-10-22 00:00:00 | 2013-01-05 00:00:00 | 222654 | 2012-10-01 00:00:00
13-PD-22 | SAFER New Mexico Now | Standard Field Sobriety Testing (SFST)  and Selective Traffic Enforcement Program (STEP) Training | 2012-11-05 00:00:00 | 2013-09-30 00:00:00 | 299219.31 | 2012-11-05 00:00:00
13-PW-27 | Geographic Technologies Group, Inc. (GTG) | GIS Strategic Plan Implementation – Stage 1 | 2012-11-29 00:00:00 | 2013-11-28 00:00:00 | 157980.98 | 2012-11-29 00:00:00
13-HR-30 | Public Sector Personnel Consultants, Inc. (PSPC) | Classification and Compensation Study | 2012-12-21 00:00:00 | 2013-04-01 00:00:00 | 26500 | 2012-12-21 00:00:00
13-PW-31 | Altor Construction Inc. | Lisbon Avenue Sidewalks - Phase 2A | 2013-01-14 00:00:00 | 2013-02-13 00:00:00 | 58853 | 2012-12-31 00:00:00
Spreadsheet: 863563d1711002757-call-center-login-logout-report-agenttimecard-1-
Sheet: After

Seq | Team Name (ID) | Agent Name (ID) | Agent Session | [NAME] | Logout Date | Duration
1
Spreadsheet: 717984d1612938394-determine-duration-hrs-between-previous-occurrence-rounds-log-aligw
Sheet: Log

Blasted Rounds Log
Date | Heading | Blast Number ID | Blast # for week | TIME | Interval between last heading round hrs
2021-01-03 00:00:00 | Travel [NAME] | 224 | 6 | 15:00:00
2021-01-04 00:00:00 | [NAME] | 229 | 1 | 22:00:00
2021-01-04 00:00:00 | Travel [NAME] | 225 | 2 | 22:00:00
2021-01-05 00:00:00 | Travel [NAME] | 226 | 3 | 22:00:00
2021-01-06 00:00:00 | [NAME] | 230 | 4 | 05:30:00
2021-01-06 00:00:00 | Travel [NAME] | 227 | 5 | 14:30:00
2021-01-07 00:00:00 | [NAME] | 231 | 6 | 05:30:00
2021-01-07 00:00:00 | Travel [NAME] | 228 | 7 | 22:00:00
2021-01-08 00:00:00 | [NAME] | 232 | 8 | 05:30:00
2021-01-08 00:00:00 | Travel [NAME] | 229 | 9 | 22:00:00
2021-01-09 00:00:00 | [NAME] | 233 | 10 | 17:30:00
2021-01-10 00:00:00 | Travel [NAME] | 230 | 11 | 22:00:00
2021-01-11 00:00:00 | [NAME] | 234 | 1 | 22:00:00
2021-01-12 00:00:00 | Travel [NAME] | 231 | 2 | 05:30:00
2021-01-12 00:00:00 | [NAME] | 235 | 3 | 22:00:00
2021-01-13 00:00:00 | Travel [NAME] | 232 | 4 | 05:30:00
2021-01-13 00:00:00 | [NAME] | 236 | 5 | 22:00:00
2021-01-14 00:00:00 | Travel [NAME] | 233 | 6 | 14:30:00
2021-01-14 00:00:00 | [NAME] | 237 | 7 | 22:00:00
2021-01-15 00:00:00 | Travel [NAME] | 234 | 8 | 14:30:00
2021-01-15 00:00:00 | [NAME] | 238 | 9 | 22:00:00
2021-01-18 00:00:00 | Travel [NAME] | 235 | 1 | 22:00:00
2021-01-19 00:00:00 | [NAME] | 239 | 2 | 02:30:00
2021-01-19 00:00:00 | Travel [NAME] | 236 | 3 | 22:00:00
2021-01-20 00:00:00 | [NAME] | 240 | 4 | 05:30:00
2021-01-21 00:00:00 | Travel [NAME] | 237 | 5 | 02:30:00
2021-01-21 00:00:00 | [NAME] | 241 | 6 | 05:30:00
2021-01-22 00:00:00 | Travel [NAME] | 238 | 7 | 02:30:00
2021-01-22 00:00:00 | [NAME] | 242 | 8 | 22:00:00
2021-01-23 00:00:00 | Travel [NAME] | 239 | 9 | 05:30:00
2021-01-25 00:00:00 | [NAME] | 243 | 1 | 02:30:00
2021-01-25 00:00:00 | Travel [NAME] | 240 | 2 | 19:00:00
2021-01-26 00:00:00 | [NAME] | 244 | 3 | 14:30:00
2021-01-26 00:00:00 | Travel [NAME] | 241 | 4 | 22:00:00
2021-01-27 00:00:00 | [NAME] | 245 | 5 | 22:00:00
2021-01-28 00:00:00 | Travel [NAME] | 242 | 6 | 14:30:00
2021-01-28 00:00:00 | [NAME] | 246 | 7 | 22:00:00
2021-01-29 00:00:00 | Travel [NAME] | 243 | 8 | 14:30:00
2021-02-01 00:00:00 | [NAME] | 247 | 1 | 02:30:00
2021-02-01 00:00:00 | Travel [NAME] | 244 | 2 | 14:30:00
2021-02-02 00:00:00 | [NAME] | 248 | 3 | 05:30:00
2021-02-02 00:00:00 | Travel [NAME] | 245 | 4 | 14:30:00
2021-02-03 00:00:00 | [NAME] | 249 | 5 | 05:30:00
2021-02-03 00:00:00 | Travel [NAME] | 246 | 6 | 14:30:00
2021-02-04 00:00:00 | [NAME] | 250 | 7 | 14:30:00
2021-02-04 00:00:00 | Travel [NAME] | 247 | 8 | 22:00:00
2021-02-05 00:00:00 | [NAME] | 251 | 9 | 14:30:00
2021-02-06 00:00:00 | Travel [NAME] | 248 | 10 | 16:00:00
2021-02-07 00:00:00 | [NAME] | 252 | 11 | 14:30:00
2021-02-08 00:00:00 | Travel [NAME] | 249 | 1 | 14:30:00
2021-02-09 00:00:00 | [NAME] | 253 | 2 | 05:30:00
Spreadsheet: 550136d1512124262-weekly-tables-score1
Sheet: WEEK2

 |  | SCORE |  |  |  |  | CARL |  |  | PTS |  | CAOLAN |  |  | PTS |  | SHANE |  |  | PTS |  | JENNY |  |  | PTS |  | SHAUN |  |  | PTS |  |  | WEEK 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TABLE | WK PTS | TOTAL PTS
 | CHELSEA |  | V |  | NEWCASTLE |  |  | V |  |  |  |  | V |  |  |  |  | V |  |  |  |  | V |  |  |  |  | V |  |  |  |  | DAVE
 | BRIGHTON |  | V |  | LIVERPOOL |  |  | V |  |  |  |  | V |  |  |  |  | V |  |  |  |  | V |  |  |  |  | V |  |  |  |  | STEVE
 | EVERTON |  | V |  | HUDDERSFIELD |  |  | V |  |  |  |  | V |  |  |  |  | V |  |  |  |  | V |  |  |  |  | V |  |  |  |  | HARRY
 | LEICESTER |  | V |  | BURNLEY |  |  | V |  |  |  |  | V |  |  |  |  | V |  |  |  |  | V |  |  |  |  | V |  |  |  |  | [NAME]
 | STOKE |  | V |  | SWANSEA |  |  | V |  |  |  |  | V |  |  |  |  | V |  |  |  |  | V |  |  |  |  | V |  |  |  |  | SIMON
 | WATFORD |  | V |  | TOTTENHAM |  |  | V |  |  |  |  | V |  |  |  |  | V |  |  |  |  | V |  |  |  |  | V
 | WEST BROM |  | V |  | PALACE |  |  | V |  |  |  |  | V |  |  |  |  | V |  |  |  |  | V |  |  |  |  | V
 | ARSENAL |  | V |  | MAN UTD |  |  | V |  |  |  |  | V |  |  |  |  | V |  |  |  |  | V |  |  |  |  | V
 | BOUREMOUTH |  | V |  | SOUTHAMPTON |  |  | V |  |  |  |  | V |  |  |  |  | V |  |  |  |  | V |  |  |  |  | V
 | MAN CITY |  | V |  | WEST HAM |  |  | V |  |  |  |  | V |  |  |  |  | V |  |  |  |  | V |  |  |  |  | V
 |  |  |  |  |  |  | TOTAL |  |  |  |  | TOTAL |  |  |  |  | TOTAL |  |  |  |  | TOTAL |  |  |  |  | TOTAL
Spreadsheet: 828234d1683308664-return-value-based-on-date-time-format-shift-test-book
Sheet: Sheet1

1st shift End | 15:00:00
Load Time | Shift | Desired Result
2023-05-02 17:42:47 |  | 2
2023-05-02 17:23:50 |  | 2
2023-05-02 17:18:46 |  | 2
2023-05-02 17:13:24 |  | 2
2023-05-02 17:09:34 |  | 2
2023-05-02 17:05:53 |  | 2
2023-05-02 17:02:52 |  | 2
2023-05-02 16:57:41 |  | 2
2023-05-02 16:52:37 |  | 2
2023-05-02 16:49:40 |  | 2
2023-05-02 16:42:09 |  | 2
2023-05-02 16:37:47 |  | 2
2023-05-02 16:34:28 |  | 2
2023-05-02 16:29:34 |  | 2
2023-05-02 14:56:26 |  | 1
2023-05-02 14:14:15 |  | 1
2023-05-02 13:56:37 |  | 1
2023-05-02 13:47:57 |  | 1
2023-05-02 13:43:52 |  | 1
2023-05-02 13:37:51 |  | 1
2023-05-02 13:34:44 |  | 1
2023-05-02 13:28:52 |  | 1
2023-05-02 13:25:53 |  | 1
2023-05-02 13:23:16 |  | 1
2023-05-02 13:16:59 |  | 1
2023-05-02 13:13:54 |  | 1
2023-05-02 13:09:29 |  | 1
2023-05-02 13:05:44 |  | 1
2023-05-02 13:00:28 |  | 1
2023-05-02 12:58:46 |  | 1
2023-05-02 12:55:23 |  | 1
2023-05-02 12:53:33 |  | 1
2023-05-02 12:44:43 |  | 1
2023-05-02 12:40:39 |  | 1
2023-05-02 11:57:30 |  | 1
2023-05-02 11:53:27 |  | 1
2023-05-02 11:47:27 |  | 1
2023-05-02 11:43:27 |  | 1
2023-05-02 11:39:38 |  | 1
2023-05-02 11:37:33 |  | 1
2023-05-02 11:27:47 |  | 1
2023-05-02 11:23:30 |  | 1
2023-05-02 11:05:08 |  | 1
2023-05-02 11:02:54 |  | 1
2023-05-02 10:56:43 |  | 1
2023-05-02 10:54:09 |  | 1
2023-05-02 10:50:22 |  | 1
2023-05-02 10:48:40 |  | 1
2023-05-02 10:39:06 |  | 1
2023-05-02 10:34:37 |  | 1
2023-05-02 10:28:19 |  | 1
2023-05-02 10:26:00 |  | 1
2023-05-02 10:19:33 |  | 1
2023-05-02 10:12:52 |  | 1
2023-05-02 09:56:25 |  | 1
2023-05-02 09:50:17 |  | 1