tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 811873d1672846079-need-help-to-look-in-and-out-latest-entry-revised-example-1-1-
Sheet: Data

Emp. Number | Emp. Name | Designation | Department | Date | Time | Status |  | Expected Results |  |  |  |  | IN |  |  |  | OUT
123 | ABC | SUPERVISOR | [NAME] | 2022-11-24 00:00:00 | 08:05:00 | I |  | On Time IN |  |  |  |  | Start | End | Description |  | Start | End | Description
123 | ABC | SUPERVISOR | [NAME] | 2022-11-24 00:00:00 | 20:08:00 | O |  | On Time Out |  |  |  |  | 07:00:00 |  | On Time IN |  | 12:00:00 | 16:00:00 | Early Out
234 | ABCDE | SUPERVISOR | Store | 2022-11-24 00:00:00 | 08:02:44 | I |  | On Time IN |  |  |  |  | 08:31:00 | 11:59:00 | Late Arrivals |  | 16:01:00 | 22:00:00 | On Time Out
234 | ABCDE | SUPERVISOR | Store | 2022-11-24 00:00:00 | 12:06:43 | O |  | Early Out
345 | AB | SUPERVISOR | QA | 2022-11-24 00:00:00 | 08:02:09 | I |  | Double Entry
345 | AB | SUPERVISOR | QA | 2022-11-24 00:00:00 | 08:22:02 | O |  | Double Entry
345 | AB | SUPERVISOR | QA | 2022-11-24 00:00:00 | 08:23:48 | I |  | On Time IN |  |  |  |  | I= | IN
345 | AB | SUPERVISOR | QA | 2022-11-24 00:00:00 | 19:03:24 | O |  | On Time Out |  |  |  |  | O= | OUT
567 | [NAME] | HELPER | Finishing | 2022-11-24 00:00:00 | 07:45:38 | I |  | Double Entry
567 | [NAME] | HELPER | Finishing | 2022-11-24 00:00:00 | 07:53:01 | O |  | Double Entry |  |  |  |  | [NAME] first check by Employee Number that have both IN and OUT in the same date. Then show that the employee is on time or not. IF there are more than one entries of this type then the last entry should be considered like I highligted with [NAME]. If IN or OUT is missing then formula show me that this employee in this date one entry is missing
567 | [NAME] | HELPER | Finishing | 2022-11-24 00:00:00 | 07:56:32 | I |  | On Time IN
567 | [NAME] | HELPER | Finishing | 2022-11-24 00:00:00 | 19:00:47 | O |  | On Time Out
648 | ADON | SAMPLE MAKER | Sample | 2022-11-25 00:00:00 | 09:51:21 | I |  | Late Arrivals
648 | ADON | SAMPLE MAKER | Sample | 2022-11-25 00:00:00 | 17:00:32 | O |  | On Time Out
714 | KHAMI | SUPERVISOR | [NAME] | 2022-11-25 00:00:00 | 08:06:37 | I |  | On Time IN
714 | KHAMI | SUPERVISOR | [NAME] | 2022-11-25 00:00:00 | 19:57:12 | O |  | On Time Out
567 | [NAME] | HELPER | Finishing | 2022-11-25 00:00:00 | 07:56:32 | I |  | On Time IN
567 | [NAME] | HELPER | Finishing | 2022-11-25 00:00:00 | 13:00:00 | O |  | Early Out
345 | [NAME] | HELPER | Finishing | 2022-11-26 00:00:00 | 17:00:00 | O |  | On Time Out
345 | [NAME] | HELPER | Finishing | 2022-11-26 00:00:00 | 08:04:00 | I |  | On Time IN
714 | KHAMI | SUPERVISOR | [NAME] | 2022-11-26 00:00:00 | 08:06:37 | I |  | On Time IN
Spreadsheet: 790214d1659601157-weekly-report-shifting-employees-from-one-department-to-another-by-analyzing-data-base-excel-forum-logistik-help
Sheet: Cost categories

PTBText | Kostenstelle | Bezeichnung | Kategorie
Logistik GmbH | [PHONE] | Outbound
Logistik GmbH | [PHONE] | Inbound
Logistik GmbH | [PHONE] | Warehousing
Logistik GmbH | [PHONE] | packaging management | packaging management
Logistik GmbH | [PHONE] | Head of | Head of
Spreadsheet: 6395dd5e-4f0c-4cc9-9357-8e5105113557
Sheet: Sheet1

analytica 2012 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (27 Entries):
 | 2 Analysis 2.6 Photometers 2.6.3 Spectrophotometers
No. | Company | Country | City | [NAME] | Hall/Booth
1 | Nanolytik Research in Mind | Germany | [NAME] | 40221 | B2.430/11
2 | Alliance Instruments - AMS France Unity Scientific | France | Frepillon | 95740 | A1.406
3 | Biochrom Ltd. | United Kingdom | Cambridge | CB4 0FJ | A3.404
4 | BioTek Instruments GmbH | Germany | Bad Friedrichshall | 74177 | A3.330
5 | Bruins Instruments | Germany | Puchheim | 82178 | A2.301/402
6 | Deelux Labortechnik GmbH | Germany | [NAME] | 21376 | A1.512
7 | DURATEC Analysentechnik GmbH | Germany | [NAME] | 68766 | A1.111
8 | Eppendorf AG | Germany | Hamburg | 22339 | B1.301/404
9 | GE Healthcare | Germany | München | 80807 | A3.331/430
10 | Insion GmbH | Germany | Heilbronn | 74076 | A2.513
11 | Jasco Europe s.r.l. | Italy | Cremella | 23894 | A2.121/220
12 | J&M Analytik AG | Germany | [NAME] | 73457 | A2.550
13 | K-MAC | South Korea | Daejeon | 305500 | A3.560
14 | Laser 2000 GmbH | Germany | Weßling | 82234 | A2.303
15 | MACHEREY-NAGEL GmbH & Co. [NAME] | Germany | Düren | 52355 | A2.330
16 | PG Instruments Limited | United Kingdom | Wibtoft | LE17 5BH | B2.215A
17 | [NAME] | Germany | Waldbronn | 76337 | A2.217
18 | Precisa Gravimetrics AG | Switzerland | Dietikon | 8953 | B1.420
19 | Shimadzu Deutschland GmbH | Germany | Duisburg | 47269 | [NAME]
20 | SI Analytics GmbH | Germany | [NAME] | 55122 | A1.201/302
21 | tec5 AG Technology for Spectroscopy | Germany | Oberursel | 61440 | A2.512
22 | Thermo Scientific | Germany | Dreieich | 63303 | B1.101/202
23 | Tintometer GmbH | Germany | Dortmund | 44287 | B1.500
24 | Unity Scientific GmbH | Germany | [NAME] | 40549 | A1.406
25 | Uwe Binninger Analytik | Germany | Schwäbisch Gmünd | 73527 | A2.426
26 | WTW Wissenschaftlich-Technische Werkstätten GmbH | Germany | [NAME] | 82362 | A1.201/302
27 | [NAME] MicroImaging GmbH | Germany | Jena | 07745 | A2.111/210
Spreadsheet: 873080d1719504307-formulas-required-for-football-prediction-game-axdby-bsb-
Sheet: Sheet1

Prediction |  | Actual |  |  | Home Goals | Away Goals | Correct Result | Exact Score
H | A | H | A
3 | 1 | 5 | 1
2 | 0 | 2 | 1
2 | 1 | 2 | 1
3 | 1 | 2 | 0
1 | 2 | 1 | 3
1 | 0
0 | 1
1 | 1
2 | 2
0 | 0
Spreadsheet: 2fe838e3-2ea6-4744-a4b6-c0d0079ecb08
Sheet: Lodging Form

Lodging Form       School Name:
Bruneau/1 - A | Bruneau/1 - B | Clearwater/2 - A | Clearwater/2 - B
RAMP ACCESS IF NEEDED | RAMP ACCESS IF NEEDED
 |  | CHAP: | CHAP:
CHAP: | CHAP:
Lochsa/3 - A | Lochsa/3 - B | Middle Fork/4 - A | Middle Fork/4 - B
CHAP: | CHAP: | CHAP: | CHAP:
Payette/5 -  A | Payette/5 - B | Snake/6 - A | Snake/6 - B
CHAP: | CHAP: | CHAP: | CHAP:
Secesh/7 - A | Secesh/7 - B
CHAP: | CHAP:
Spreadsheet: 141363d1329233861-can-only-select-a-drop-down-option-once-0201_a
Sheet: Sheet1

Name | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 |  |  |  |  |  |  |  |  |  |  |  | Arsenal | [NAME] |  | [NAME]
[NAME] | Arsenal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] |  | roy
c | Arsenal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | 3 | mary
[NAME] | Arsenal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | roy | 4 | a
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chelseaa | mary | 5 | v
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Evertona | a | 6 | b
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fulham | c |  | n
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Liverpool | v | 8 | mary
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Manchester City | b | 9 | l
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | n | 10 | k
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Newcastle United | mary | 11 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Norwich City | l | 12 | g
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Queens Park Rangers | k | 13 | d
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stoke City | [NAME] | 14 | e
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sunderland | g | 15 | hj
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Swansea City | d | 16 | fg
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | e | 17 | bhj
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | West Bromwich Albion | hj | 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wigan Athletic | fg | 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | bhj | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
Spreadsheet: 7f4f71ab-4fec-4148-9937-9f21486049fa
Sheet: 7c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120-360 | 360+ | TOTAL
Basis | 1369858 | 1003907 | 2042531 | 2538142 | 3511012 | 1699051 | 1241409 | 81982 | 13487891
Fixed-Float | 10971435 | 8234995 | 15831601 | 29158358 | 63127215 | 42075734 | 19897082 | 1958753 | 191255173
FRA | 25383282 | 12882147 | 12616907 | 3198195 | 166170 | 0 | 0 | 0 | 54246702
OIS | 16172562 | 7087205 | 8814199 | 5068423 | 2027934 | 429311 | 228511 | 17383 | 39845526
Swaption | 3345596 | 1808745 | 3408060 | 3747783 | 4215792 | 2132630 | 953957 | 14476 | 19627039
OTHER* | 1643108 | 855680 | 1358270 | 2142965 | 4685171 | 3919486 | 2273646 | 175069 | 17053395
TOTAL | 58885841 | 31872679 | 44071568 | 45853866 | 77733294 | 50256212 | 24594605 | 2247663 | 335515726
*OTHER variable includes the following products: Cap/Floor, Debt Option, Exotic, Fixed-Fixed, and Inflation.
Spreadsheet: darrell_schoolcraft__7783__imbalsumm0107
Sheet: NS Steel

 | North Star Steel
 | POI 500383 - North Start Steel IC
Day | Measured | Scheduled
1 |  | -2198
2 | -2087 | -3232
3 | -2 | -2673
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
31
2001-06-30 00:00:00 |  |  | -346060
2001-07-03 00:00:00
Spreadsheet: 879574d1727167524-capture-data-from-multiple-sheets-sample-data
Sheet: 151-ABC

 |  |  | BU2424 | BU2525
PN | Supplier | Type | Total | Total
151A | 102 LLL | JJ | 100 | 50
151A | 102 LLL | JJ | 100 | 50
151A | 102 LLL | JJ | 50 | 50
151A | 102 LLL | JJ | 100 | 50
Spreadsheet: 669149d1585230489-move-rows-to-separate-sheets-astro_kt
Sheet: 2100 21 5610

Date | Vendor | Item | P.O.# | Amount | Acct Code
Spreadsheet: 494284d1482314482-conditional-formatting-workbook1
Sheet: 2

1 | 10/2 AI 2010 | 11/2 AI 2011 | 12/2 AI 2012 | 13/2 AI 2013 | 14/2 AI 2014 | 15/2 AI 2015 | 16/2 AI 2016 | 17/2 AI  2017 |  | Grand Total
AA |  | 789.75
AA | 28096.62009239197 | 74027.44943237305 | 426522.0784111023 | 543976.6175193787 | 199165.6997146606 | 416277.2316665649 | 129079.8898468018 | 5089.050048828125
AA |  | 434.6399993896484
AA | 6152.660598754883 | 23089.55012512207 | 104614.5401611328 | 300435.2008094788 | 56388.73936462402 | 89846.22061157227 | 81411.67015457153 | 2382.739929199219
AA | 24614.25003814697 | 206736.6080513 | 56116.92073440552 | 33180.65050506592 | 227623.6397438049 | 296473.6121749878 | 289551.9892578125 | 126.75
AA | 35877.25067138672 | 96457.84930801392 | 189787.9499053955 | 236036.6000366211 | 195833.5614013672 | 524009.4316825867 | 377514.3705406189 | 2866.439979553223
AA
AA | 84684.7699584961 | 212554.5304946899 | 122456.2997589111 | 221206.2021408081 | 32967.030418396 | 57262.10991668701 |  | 147
AA
AA |  |  |  |  |  |  | 324030.2194442749 | 18206.82986450195
AA |  |  |  |  |  |  | 82.4000015258789 | 211.8000030517578
AA | 5718.560161590576 | 56056.13833808899 | 9489.599987983704 | -3140.660034179688 | 2226.199970245361 | 344.1000080108643 | 6217.680061340332
AA |  |  |  |  |  |  |  | 10113.54987335205
AA |  |  |  |  |  |  | 2713.150024414062 | 1184.93994140625
AA |  |  |  |  | 32322.05004882812 | 50.79999923706055 | 109866.1996650696 | 4476.710083007812
AA |  |  | 205.8699989318848 |  |  | 4280.380035400391 | 66665.73034667969 | 1803.300048828125
AA |  |  |  | 75094.82997894287 | 245452.7902069092 | 221310.8396759033 | 282660.0487594604 | 1081.330017089844
TOTAL
NEW | 0
LOST | 0
RECOVERED | 0
Spreadsheet: 68679d1d-6391-4c9b-a111-ebd085c0ddbd
Sheet: 3

 | Jul 19 | Jul 26 | Aug 2 | Aug 9 | Aug 16
Total Interest Rate* | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | N/A | N/A | N/A | N/A | N/A
Cleared** | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Credit | 2114954 | 2129267 | 2141011 | 2150503 | 2160031
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | N/A | N/A | N/A | N/A | N/A
Weekly snapshot, net notional amount outstanding by asset class and cleared status (millions of USD), all products, tenors, and participant types.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 56031d1256159051-highlighting-pertinent-information-copy-of-copy-of-job-qualification-tool-test-10-2009
Sheet: SITEREQS

1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TWIC Card | OSHA Training | Passport
[NAME] | [NAME] | London
Tampa | Tampa | St. Petersburg
London | London | Tampa
Spreadsheet: 3888321d-3c60-4770-8ea4-dbc461cabb30
Sheet: Sheet1

PRACTICE NAME: | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | HIGHLIGHTED AREAS TO BE COMPLETED BY PRACTICE | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
DATE:
Employee name | Current wage | Date of last Increase | Hire Date | Avg work hours/week | Rating* | Comments** | Benefits
TECHNICIANS
RECEPTIONISTS
KENNEL WORKERS
GROOMERS
MANAGERS/ADMIN
OTHER
* Rating--use the rating from the last performance appraisal if available.  If not available, rate each employee on a 1-5 scale with 5 being the highest
** Comments--include anything that would be helpful in evaluating individuals--is the person the head of their department, do they have credentials (RVT, [NAME], etc), how is their attitude and performance, etc
Spreadsheet: 832131d1686139451-if-any-cell-in-column-b-includes-any-of-these-words-in-range-j1-j4-then-highlight-row-conditionalformatentirerow
Sheet: Sheet1

No. | Item | 2016 | 2017 | 2018 | 2019 |  |  |  | Fixed
1 | Fixed assets |  |  |  |  |  |  |  | Loans
2 | Total non-current assets |  |  |  |  |  |  |  | Sales
3 | Cash and the like |  |  |  |  |  |  |  | Long
4 | Total current assets
 |  |  |  |  |  |  |  |  | If any cell in column B includes any of these words in range J1:J4, then highlight entire row with read
No. | Item | 2016 | 2017 | 2018 | 2019
1 | Total current liabilities
2 | long term loans
3 | Total non-current liabilities
4 | total liabilities
No. | Item | 2016 | 2017 | 2018 | 2019
1 | Sales
2 | Cost of Goods Sold
3 | Inventory
4 | Loan
No. | Item | 2016 | 2017 | 2018 | 2019
1 | Fixed Assets
2 | Cash Papers
3 | Inventory
4 | Long Loan
Spreadsheet: 886175d1736202785-catagorize-columns-from-other-columns-catagorize-by-name-
Sheet: Sheet1

Week Number | Claim Date | Colleagues Name | From Base Branch | To Working Branch | Paid Out From Branch | Amount Claimed | Allowable Claim | Claim Difference | Item Details | Specific    Item | Authorised By | Traders Manager
13 | 2024-12-12 00:00:00 | [NAME] | 5700 | 674 | 674 | 2.38 | 2 |  | Travel | Fuel | Ian
13 | 2024-12-12 00:00:00 | [NAME] | 5689 | 2130 | 2130 | 15.37 | 15.37 |  | Travel | Fuel | Racheal
13 | 2024-12-12 00:00:00 | [NAME] | 1243 | 4528 | 4528 | 42.5 | 42.5 |  | Travel | Fuel | Ian
13 | 2024-12-12 00:00:00 | [NAME] | 5687 | 6376 | 6376 | 12 | 11.53 |  | Travel | Fuel | [NAME]
13 | 2024-12-12 00:00:00 | [NAME] | 2100 | 5110 | 5110 | 14.2 | 14.2 |  | Travel | Fuel | Ian
13 | 2024-12-12 00:00:00 | Mark A | 6532 | 1050 | 1050 | 1.22 | 1.22 |  | Travel | Fuel | Ian
13 | 2024-12-12 00:00:00 | [NAME] | 4170 | 1180 | 1180 | 3 | 1.21 |  | Travel | Fuel | Racheal
13 | 2024-12-12 00:00:00 | Scott | 5700 | 1275 | 1275 | 6.7 | 6.7 |  | Travel | Fuel | Ian
13 | 2024-12-12 00:00:00 | [NAME] | 1313 | 1275 | 1275 | 8.31 | 8.52 |  | Travel | Fuel | [NAME]
13 | 2024-12-12 00:00:00 | [NAME] | 674 | 3251 | 3251 | 19.32 | 19.32 |  | Travel | Fuel | Racheal
13 | 2024-12-12 00:00:00 | [NAME] | 4526 | 4765 | 4765 | 17.95 | 15.33 |  | Travel | Fuel | [NAME]
13 | 2024-12-12 00:00:00 | [NAME] | 129 | 4317 | 4317 | 4.37 | 4.37 |  | Travel | Fuel | [NAME]
Spreadsheet: 882904d1731371441-three-level-sort-not-working-attachment-sample
Sheet: Sheet1

Order | Type | Name | PRIOR | NOTES | DUP | TITLE | ROSS | TIMING | OBSOLETE | N/A | CHECK | SERIAL | BLANK | Unknown Serial | INCLUDE
171 | RTR/SWR | Sony XVS-7000 Prod. Swr. (COM port) | HIPRI | 128 & 256 |  |  | TITLE | (BREAK CHAR) |  |  |  | SERIAL | False | False | True
195 | RTR/SWR | [NAME] (COM port) | HIPRI |  |  | TITLE |  |  |  |  |  | SERIAL | False | False | True
50 | RTR/SWR | GVG Kalypso Prod. Swr. (COM port) | HIPRI |  |  | TITLE |  |  |  |  |  | SERIAL | False | False | True
56 | RTR/SWR | [NAME]. Swr. (COM port) | HIPRI |  |  | TITLE |  |  |  |  |  | SERIAL | False | False | True
68 | RTR/SWR | [NAME] (COM port) | HIPRI |  |  | TITLE |  |  |  |  |  | SERIAL | False | False | True
84 | RTR/SWR | [NAME] (COM port) | HIPRI |  |  | TITLE |  |  |  |  |  | SERIAL | False | False | True
159 | RTR/SWR | [NAME] Vision Prod. Swr. (COM port) | HIPRI |  |  | TITLE | ROSS |  |  |  |  | SERIAL | False | False | True
163 | RTR/SWR | Snell&Wilcox Kahuna Prod. Swr. (COM port) | HIPRI |  |  |  | TITLE |  |  |  |  | SERIAL | False | False | True
168 | RTR/SWR | Sony MVS-8000 Prod. Swr. (COM port) | HIPRI | 128 only |  |  | TITLE |  |  |  |  | SERIAL | False | False | True
169 | RTR/SWR | Sony MVS-8000X Prod. Swr. (COM port) | HIPRI | 128 & 256 |  |  | TITLE | (BREAK CHAR) |  |  |  | SERIAL | False | False | True
62 | RTR/SWR | GVG TenXL Router ASCII (COM port) | NOT DONE? |  |  | TITLE |  |  |  |  |  | SERIAL | False | False | True
Spreadsheet: 0bb2f277-a8b0-4a16-b3f1-33c394657b1f
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
3154 | 6246 | [NAME] | [NAME] | USA | 0 | [NAME] | 00:00:19 | 00:14:05 | 00:00:29 | 00:09:05 | 1 | 00:32:52
3154 | 5413 | Kelly | [NAME] | USA | 0 | 00:08:49 | 00:00:25 | 00:14:04 | 00:00:28 | 00:09:25 | 2 | 00:33:11
3154 | 5549 | Ayesha | Rollinson | CAN | 0 | 00:10:03 | 00:00:27 | 00:15:38 | 00:00:36 | 00:10:11 | 3 | 00:36:55
3154 | 15483 | [NAME] | Mensink | CAN | 0 | 00:10:48 | 00:00:31 | 00:15:16 | 00:00:38 | 00:11:15 | 4 | [NAME]
3154 | 7157 | [NAME] | [NAME] | MEX | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:40:15 | 5 | 00:40:15
Spreadsheet: 102406d1300351574-excel-2007-vlookup-copy-of-new
Sheet: Sheet2

0.0707 | 3
0.099 | 3.55
0.1257 | 4
0.1414 | 3
0.159 | 4.5
0.1963 | 5
0.198 | 3.55
0.2121 | 3
0.2463 | 5.6
0.2514 | 4
0.2827 | 6
0.2828 | 3
0.297 | 3.55
0.318 | 4.5
0.3535 | 3
0.3771 | 4
0.3848 | 7
0.3926 | 5
0.3959 | 7.1
0.396 | 3.55
0.4242 | 3
0.477 | 4.5
0.4926 | 5.6
0.4949 | 3
0.495 | 3.55
0.5027 | 8
0.5028 | 4
0.5654 | 6
0.5656 | 3
0.5889 | 5
0.5940000000000001 | 3.55
0.6285000000000001 | 4
0.636 | 4.5
0.6362 | 9
0.6363 | 3
0.6930000000000001 | 3.55
0.707 | 3
0.7389 | 5.6
0.7542 | 4
0.7696 | 7
0.7852 | 5
0.7854 | 10
0.7918 | 7.1
0.792 | 3.55
0.795 | 4.5
0.8481000000000001 | 6
0.8799 | 4
0.891 | 3.55
0.954 | 4.5
0.9815 | 5
0.9852 | 5.6
0.99 | 3.55
1.0054 | 8
1.0056 | 4
1.113 | 4.5
1.1308 | 6
1.131 | 12
1.1313 | 4
1.1544 | 7
1.1778 | 5
1.1877 | 7.1
1.2315 | 5.6
1.257 | 4
1.272 | 4.5
1.2724 | 9
1.3741 | 5
1.4135 | 6
1.431 | 4.5
1.4778 | 5.6
1.5081 | 8
1.5392 | 7
1.5394 | 14
1.5704 | 5
1.5708 | 10
1.5836 | 7.1
1.59 | 4.5
1.6962 | 6
1.7241 | 5.6
1.7667 | 5
1.9086 | 9
1.924 | 7
1.963 | 5
1.9704 | 5.6
1.9789 | 6
1.9795 | 7.1
2.0106 | 16
2.0108 | 8
2.2167 | 5.6
2.2616 | 6
2.262 | 12
2.3088 | 7
2.3562 | 10
2.3754 | 7.1
2.463 | 5.6
2.5135 | 8
2.5443 | 6
2.5447 | 18
2.5448 | 9
2.6936 | 7
2.7713 | 7.1
2.827 | 6
3.0162 | 8
3.0784 | 7
3.0788 | 14
3.1416 | 20
3.1416 | 10
3.1672 | 7.1
3.181 | 9
3.393 | 12
3.4632 | 7
3.5189 | 8
3.5631 | 7.1
3.8013 | 22
3.8172 | 9
3.848 | 7
3.927 | 10
3.959 | 7.1
4.0212 | 16
4.0216 | 8
4.4534 | 9
4.524 | 12
4.5243 | 8
4.6182 | 14
4.7124 | 10
4.9087 | 25
5.027 | 8
5.0894 | 18
5.0896 | 9
5.4978 | 10
5.655 | 12
5.7258 | 9
6.0318 | 16
6.1575 | 28
6.1576 | 14
6.2832 | 20
6.2832 | 10
6.362 | 9
6.786 | 12
7.0686 | 10
7.6026 | 22
7.6341 | 18
7.697000000000001 | 14
7.854 | 10
7.917 | 12
8.0424 | 16
8.0425 | 32
9.048 | 12
9.2364 | 14
9.4248 | 20
9.8174 | 25
10.053 | 16
10.1788 | 36
10.1788 | 18
10.179 | 12
10.7758 | 14
11.31 | 12
11.4039 | 22
12.0636 | 16
12.315 | 28
12.3152 | 14
12.5664 | 40
12.5664 | 20
12.7235 | 18
13.8546 | 14
14.0742 | 16
14.7261 | 25
15.2052 | 22
15.2682 | 18
15.394 | 14
15.708 | 20
16.0848 | 16
16.085 | 32
17.8129 | 18
18.0954 | 16
18.4725 | 28
18.8496 | 20
19.0065 | 22
19.6348 | 25
20.106 | 16
20.3576 | 36
20.3576 | 18
21.9912 | 20
22.8078 | 22
22.9023 | 18
24.1275 | 32
24.5435 | 25
24.63 | 28
25.1328 | 40
25.1328 | 20
25.447 | 18
26.6091 | 22
28.2744 | 20
29.4522 | 25
30.4104 | 22
30.5364 | 36
30.7875 | 28
31.416 | 20
32.17 | 32
34.2117 | 22
34.3609 | 25
36.945 | 28
37.6992 | 40
38.013 | 22
39.2696 | 25
40.21250000000001 | 32
40.7152 | 36
43.1025 | 28
44.17829999999999 | 25
48.255 | 32
49.087 | 25
49.26 | 28
50.2656 | 40
50.89400000000001 | 36
55.4175 | 28
56.2975 | 32
61.0728 | 36
61.575 | 28
62.832 | 40
64.34 | 32
71.25160000000001 | 36
72.38250000000001 | 32
75.3984 | 40
80.42500000000001 | 32
81.4304 | 36
87.9648 | 40
91.6092 | 36
100.5312 | 40
101.788 | 36
113.0976 | 40
125.664 | 40
Spreadsheet: 785593d1656507403-filter-function-with-wildcard-and-multiple-search-values-filter-formula1
Sheet: data

Date | Folio | Period | Sub Analysis | Flags | Narrative | Reference | Project | Debits | Credits | Value | Account Name | Our Reference | Our Reference 2 | Their Reference | User ID | Narrative
2022-05-29 00:00:00 | SL071994 | 2023/06 | AUTOBL |  | ESBOC001/LOUTH030//674797/ | 674797 |  | 127.25 | 0 | 127.25 |  | 674797
2022-05-29 00:00:00 | SL071994 | 2023/06 | AUTOBL |  | BORDI002/SOUTH037//674799/ | 674799 |  | 1102.36 | 0 | 1102.36 |  | 674799
2022-05-30 00:00:00 | SL071994 | 2023/06 | AUTOBL |  | GALWA038//674801/ | 674801 |  | 57.8 | 0 | 57.8 |  | 674801
2022-05-30 00:00:00 | SL071994 | 2023/06 | AUTOBL |  | GALWA038//674802/ | 674802 |  | 27.08 | 0 | 27.08 |  | 674802
2022-05-30 00:00:00 | SL071994 | 2023/06 | AUTOBL |  | LARGO002/IDRSX001/[NAME] | 674819 |  | 24.75 | 0 | 24.75 |  | 674819
2022-05-30 00:00:00 | SL071995 | 2023/06 | AUTOBL |  | SLA066/Bohan/674552X/SLA M | 674552X |  | 1418.83 | 0 | 1418.83 |  | 674552X
2022-05-29 00:00:00 | SL071997 | 2023/06 | AUTOBL |  | LOUTH030//674798/ | 674798 |  | 0 | 128.36 | -128.36 |  | 674798
2022-05-29 00:00:00 | SL071997 | 2023/06 | AUTOBL |  | SOUTH037//674800/ | 674800 |  | 0 | 1111.76 | -1111.76 |  | 674800