tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 692822d1598594743-creating-a-list-with-2-criteria-and-allowing-duplicate-return-values-sample
Sheet: -DATA-

Mfg Itm ID | ID | USED | Expiration |  | Active List | Expiring | Expiring2 | Expiring3 | Expiring4 | Expiring5 | Expiring6 | Expiring7 | Expiring8 | Expiring9 | Expiring10 | Expiring11 | Expiring12 | Expiring13 | Expiring14 | Expiring15
5950020 | 2674 | True | 2020-12-01 00:00:00
0115311 | 2452 | True | 2020-12-01 00:00:00
TEM1208GL | 1399 | False | 2021-01-07 04:51:01 |  | 115311
TEM1208GR | 2048 | True | 2021-02-01 00:00:00
5950009 | 5015 | False | 2021-02-01 00:00:00 |  |  |  | 2023-03-01 00:00:00 | 2024-03-01 00:00:00 | 2028-07-01 00:00:00
0115310 | 6569 | True | 2021-04-01 00:00:00
0115320 | 8659 | True | 2021-04-01 00:00:00
5950040 | 1273 | True | 2021-04-01 00:00:00
TEM1208GL | 4589 | False | 2021-06-01 00:00:00
5950007 | 8309 | True | 2021-06-01 00:00:00
TEM1208GR | 2073 | True | 2021-06-01 00:00:00
5950009 | 6613 | True | 2021-06-01 00:00:00
5950008 | 6053 | True | 2021-08-01 00:00:00
0115310 | 142 | True | 2021-09-01 00:00:00
5950008 | 5611 | True | 2021-09-01 00:00:00
5950020 | 4966 | False | 2021-09-01 00:00:00
0117311 | 450 | True | 2021-10-01 00:00:00
5950040 | 5790 | True | 2021-10-01 00:00:00
UML1 | 4875 | True | 2021-11-01 00:00:00
5950009 | 1936 | False | 2021-11-01 00:00:00
TEM1208GR | 1371 | True | 2021-12-01 00:00:00
TEM1208GL | 4311 | False | 2022-02-01 00:00:00
UML1 | 3112 | True | 2022-03-01 00:00:00
0115320 | 2438 | True | 2022-04-01 00:00:00
UML1 | 8316 | True | 2022-04-01 00:00:00
5950007 | 4966 | False | 2022-05-01 00:00:00
0117311 | 593 | True | 2022-07-01 00:00:00
0112720 | 6212 | True | 2023-02-01 00:00:00
0117311 | 1598 | False | 2023-02-01 00:00:00
0115311 | 7638 | False | 2023-03-01 00:00:00
0117321 | 4416 | False | 2023-03-01 00:00:00
0115311 | 1563 | False | 2023-03-01 00:00:00
0117311 | 3323 | False | 2023-06-01 00:00:00
0117311 | 2329 | False | 2023-07-01 00:00:00
0115321 | 2618 | False | 2023-08-01 00:00:00
0117321 | 1211 | False | 2023-11-01 00:00:00
0115311 | 6533 | False | 2024-03-01 00:00:00
0112760 | 7903 | True | 2024-04-01 00:00:00
0112770 | 7175 | False | 2024-06-01 00:00:00
0112720 | 7749 | True | 2024-06-01 00:00:00
0112680 | 6966 | True | 2024-10-01 00:00:00
0112760 | 5661 | False | 2024-10-01 00:00:00
0112680 | 5937 | True | 2024-12-01 00:00:00
0112640 | 1038 | True | 2025-01-01 00:00:00
0112720 | 13 | True | 2025-01-01 00:00:00
0112770 | 3762 | True | 2025-02-01 00:00:00
0115321 | 2648 | True | 2025-04-01 00:00:00
0112770 | 1543 | True | 2028-06-01 00:00:00
0115311 | 2345 | False | 2028-07-01 00:00:00
Spreadsheet: 713831d1610964280-if-ifs-across-multiple-workbooks-for-direct-link-to-main-workbook-wb1
Sheet: Ark1

Date | WB2 or WB 3
2019-01-01 00:00:00
2019-01-02 00:00:00
2019-01-03 00:00:00
2019-01-04 00:00:00
2019-01-05 00:00:00
2019-01-06 00:00:00
2019-01-07 00:00:00
2019-01-08 00:00:00
2019-01-09 00:00:00
2019-01-10 00:00:00
2019-01-11 00:00:00
2019-01-12 00:00:00
2019-01-13 00:00:00
2019-01-14 00:00:00
2019-01-15 00:00:00
2019-01-16 00:00:00
2019-01-17 00:00:00
2019-01-18 00:00:00
2019-01-19 00:00:00
2019-01-20 00:00:00
2019-01-21 00:00:00
2019-01-22 00:00:00
2019-01-23 00:00:00
2019-01-24 00:00:00
2019-01-25 00:00:00
2019-01-26 00:00:00
2019-01-27 00:00:00
2019-01-28 00:00:00
2019-01-29 00:00:00
2019-01-30 00:00:00
2019-01-31 00:00:00
2019-02-01 00:00:00
2019-02-02 00:00:00
2019-02-03 00:00:00
2019-02-04 00:00:00
2019-02-05 00:00:00
2019-02-06 00:00:00
Spreadsheet: 780288d1652373691-if-calculated-value-is-not-equal-to-a-date-return-book1
Sheet: Sheet1

 | 2022-04-01 00:00:00 | 2022-05-13 00:00:00
 | 2022-04-01 00:00:00 | 2022-04-29 00:00:00
 | 2022-04-22 00:00:00 | 2022-04-29 00:00:00
 | 2022-04-29 00:00:00 | 2022-05-13 00:00:00
 | 2022-04-18 00:00:00 | 2022-05-23 00:00:00
 | 2022-04-18 00:00:00 | 2022-04-25 00:00:00
 | 2022-04-25 00:00:00 | 2022-05-20 00:00:00
 | 2022-05-20 00:00:00 | 2022-05-30 00:00:00
 | 2022-05-30 00:00:00 | 2022-06-03 00:00:00
Spreadsheet: 73af81b5-d576-4a32-ac0a-4db91eec06e5
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
HIPA | Test | HIPA | Hippuric Acid, [NAME] | Hippuric Acid, U | Ion Chromatography (IC), Colorimetry (C) | [NAME]: Urine |  |  | 2 | mL | Send 4 mL from a random urine collection. Send specimen refrigerated in a plastic urine container. | 2 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | Reporting limit determined each analysis   Creatinine:    U.S. Population (10th - 90th percentiles, median)  All participants:   	335 - 2370 mg/L, median:  1180 (n=22,245)  Males:	 	495 - 2540 mg/L, median: 1370 (n=10,610)  Females: 	273 - 2170 mg/L, median 994 (n=11,635)   Hippuric Acid (g/L)   Synonym(s): Hippurate; n-Benzoylglycine   Normal in an unexposed population up to 1.6 g Hippuric Acid/L urine.   Hippuric Acid (Creatinine corrected) (g/g Creat)   Synonym(s): Hippurate; n-Benzoylglycine   Biological Exposure Index (ACGIH) for monitoring   exposure to Toluene:   1.6 g Hippuric Acid/g Creatinine measured in an end of shift specimen.   Specific Gravity Confirmation    Physiologic range:  1.010-1.030.   Test Performed by:  NMS Labs                               3701 Welsh Road                               P.O. Box 433A                               [NAME], PA  19090-0437 | Varies, Monday through Saturday | 2 days | 4 - 8 days |  |  |  |  |  |  | NMS Labs
HIPA | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 7 days
HIPA | Result | Z1305 | Creatinine | Creatinine | Alphanumeric |  |  |  |  | mg/L |  |  |  |  |  |  |  |  |  | 2161-8 | Creatinine:MCnc:Pt:[NAME]:Qn:
HIPA | Result | Z1341 | Reporting Limit | Reporting Limit | Alphanumeric |  |  |  |  | mg/L |  |  |  |  |  |  |  |  |  | In Process
HIPA | Result | [NAME] | Hippuric Acid | Hippuric Acid | Alphanumeric |  |  |  |  | g/L |  |  |  |  |  |  |  |  |  | 6709-0 | Hippurate:MCnc:Pt:[NAME]:Qn:
HIPA | Result | Z1342 | Reporting Limit | Reporting Limit | Alphanumeric |  |  |  |  | g/L |  |  |  |  |  |  |  |  |  | In Process
HIPA | Result | Z1306 | Hippuric Acid(Creatinine corrected) | Hippuric Acid(Creatinine corrected) | Alphanumeric |  |  |  |  | g/g Cr |  |  |  |  |  |  |  |  |  | 13754-7 | Hippurate/Creatinine:MCrto:Pt:[NAME]:Qn:
HIPA | Result | [NAME] | Reporting Limit | Reporting Limit | Alphanumeric |  |  |  |  | g/g Cr |  |  |  |  |  |  |  |  |  | In Process
HIPA | Result | Z2513 | Specific Gravity Confirmation | Specific Gravity Confirmation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2965-2 | Specific gravity:Rden:Pt:[NAME]:Qn:
Spreadsheet: 768719d1645098815-amount-not-pulling-through-pivot-table-2022-01-pettycash
Sheet: JNL

 |  |  |  |  |  |  |  |  |  |  | CEVA ANIMAL HEALTH (PTY) LTD
 |  |  |  |  |  |  |  |  | REF:-
ACC NO | ACCOUNT [NAME] | DEBIT | CREDIT | SL TYPE | SL | SL DESCR | COST OBJ 1 | COST OBJ 2 | COST OBJ 3 | COST OBJ 4 | REMARKS |  |  | COPY FROM PIVOT (COLUMNS A & B)
 |  |  |  | S
 |  |  |  | S
 |  |  |  | S
 |  |  |  | S
 |  |  |  | S
 |  |  |  | S
 |  |  |  | S
 |  |  |  | S
 |  |  |  | S
 |  |  |  | S
 |  |  |  | S
 |  |  |  | S
 |  |  |  | S
 |  |  |  | S
 |  |  |  | S
 |  |  |  | S
 |  |  |  | S
 |  |  |  | S
656.445600 | [NAME] |  |  | S | ZA
656.531000 | PETTY CASH |  |  | S | ZA
 | TOTALS |  |  |  |  |  |  |  |  |  |  |  |  | Number of Lines =
 | TEST |  |  |  |  |  |  |  |  |  |  |  |  | Lines Required =
 |  |  |  |  |  |  | PROCESSED:
 |  |  |  |  |  |  | DATE:
 |  |  |  |  |  |  | JOURNAL:
Spreadsheet: 53186d1253116633-how-to-pick-up-latest-number-from-spread-sheet-september-fandi-report
Sheet: snapshot

 |  | MONTH TO UNIT GROSS |  |  |  |  |  | AVERAGE GROSS AT UNIT
 |  | TOTAL | RESERVE | AM | WARR | GAP |  | TOTAL | RESERVE | AM | WARR | GAP
 | AJ | 21976.98 | 3498.42 | 11384.56 | 5676 | 1418 |  | 1292.763529411765 | 205.7894117647059 | 669.6800000000001 | 333.8823529411765 | 83.41176470588235
 | Mori | 36937.41 | 9405.910000000002 | 12171.5 | 10256 | 5104 |  | 1539.05875 | 391.9129166666667 | 507.1458333333333 | 427.3333333333333 | 212.6666666666667
 | Fred | 22463.75 | 5192.77 | 11786.98 | 4988 | 496 |  | 1604.553571428571 | 370.9121428571429 | 841.9271428571429 | 356.2857142857143 | 35.42857142857143
 | Bev | 3973.81 | 0 | 3260.81 | 713 | 0 |  | 662.3016666666666 | 0 | 543.4683333333334 | 118.8333333333333 | 0
 | VJ | 1254.72 | 1254.72 | 0 | 0 | 0 |  | 1254.72 | 1254.72 | 0 | 0 | 0
 | [NAME] | 456 | 0 | 456 | 0 | 0 |  | 456 | 0 | 456 | 0 | 0
Spreadsheet: 0e94225e-c3af-4c87-bf16-e340c8853ff1
Sheet: Grade 6

2013 Minnesota Comprehensive Assessments-Series III (MCA-III)
Grade 6 Mathematics
Scale Score | Level | Percentile Rank
611 | D | 1
612 | D | 1
613 | D | 1
614 | D | 1
615 | D | 1
616 | D | 1
617 | D | 1
618 | D | 2
619 | D | 2
620 | D | 2
621 | D | 2
622 | D | 3
623 | D | 3
624 | D | 3
625 | D | 4
626 | D | 4
627 | D | 5
628 | D | 5
629 | D | 6
630 | D | 7
631 | D | 8
632 | D | 9
633 | D | 10
634 | D | 11
635 | D | 12
636 | D | 13
637 | D | 15
638 | D | 16
639 | D | 18
640 | P | 20
641 | P | 22
642 | P | 24
643 | P | 26
644 | P | 28
645 | P | 31
646 | P | 33
647 | P | 36
648 | P | 39
649 | P | 42
650 | M | 45
651 | M | 48
652 | M | 51
653 | M | 54
654 | M | 57
655 | M | 60
656 | M | 63
657 | M | 66
658 | M | 69
659 | M | 72
660 | M | 75
661 | M | 77
662 | E | 80
663 | E | 82
664 | E | 84
665 | E | 86
666 | E | 88
667 | E | 90
668 | E | 91
669 | E | 92
670 | E | 94
671 | E | 95
672 | E | 96
673 | E | 96
674 | E | 97
675 | E | 98
676 | E | 98
677 | E | 98
678 | E | 99
679 | E | 99
680 | E | 99
681 | E | 99
682 | E | 99
683 | E | 99
684 | E | 99
685 | E | 99
686 | E | 99
687 | E | 99
688 | E | 99
End of Worksheet
Spreadsheet: 648901d1573274719-select-vehicle-code-last-date-in-the-month-oldest-time-on-that-date-return-amount-value-sample-work
Sheet: Sheet1

 | Card num. | Date | Hour | [NAME]
 | 56035 | 2019-10-31 00:00:00 | 08:12:11 | 267000
 | 56035 | 2019-10-29 00:00:00 | 11:35:01 | 481800
 | 56035 | 2019-10-24 00:00:00 | 18:50:42 | 705000
 | 56035 | 2019-10-22 00:00:00 | 17:45:57 | 928800
 | 56035 | 2019-10-18 00:00:00 | 09:04:00 | 1140600
 | 56035 | 2019-10-15 00:00:00 | 11:57:14 | 1358400
 | 56035 | 2019-10-10 00:00:00 | 11:37:36 | 1576200
 | 78733 | 2019-10-01 00:00:00 | 07:53:15 | 682831
 | 78733 | 2019-10-02 00:00:00 | 20:02:33 | 540543
 | 78733 | 2019-10-02 00:00:00 | 07:59:39 | 618598
 | 78733 | 2019-10-08 00:00:00 | 15:06:48 | 270601
 | 78733 | 2019-10-08 00:00:00 | 09:19:05 | 412351
 | 78733 | 2019-10-09 00:00:00 | 15:09:48 | 20601
 | 78733 | 2019-10-09 00:00:00 | 12:13:23 | 146601
 | 78733 | 2019-10-16 00:00:00 | 09:03:48 | 601
 | 78733 | 2019-10-17 00:00:00 | 08:30:52 | 1219976
 | 78733 | 2019-10-19 00:00:00 | 21:40:09 | 1079441
 | 78733 | 2019-10-23 00:00:00 | 11:24:28 | 937691
 | 78733 | 2019-10-26 00:00:00 | 09:32:16 | 819026
 | 78733 | 2019-10-28 00:00:00 | 18:13:19 | 678005
 | 78733 | 2019-10-31 00:00:00 | 18:28:24 | 398121
 | 78733 | 2019-10-31 00:00:00 | 18:25:13 | 528005
Spreadsheet: 862629d1710302828-formula-to-merge-data-table-data-table
Sheet: Data Table

 | A | B | C | D | E | F | G | H
1 | A1 | B1 |  | D1 | E1
2 |  |  |  | D2 | E2
1 |  |  |  |  |  |  | G3 | H3
2 |  |  |  |  |  |  | G4 | H4
Spreadsheet: michelle_lokay__26750__imball0112
Sheet: SWGasTrans

 | SW Gas Transmission Co - contr27380
 | POI 78003 - TW/SGTC Mojave Del
Day | Measured | Scheduled
1 | -13990 | -14000
2 | -13992 | -14000
3 | -14009 | -14000
4 | -14013 | -14000
5 | -13999 | -14000
6 | -13873 | -13944
7 | -14088 | -13955
8 | -13865 | -14000
9 | -13897 | -14000
10 | -13902 | -14000
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  | -482.28
2001-12-10 00:00:00
CBS Volume
 |  |  | 12777
Spreadsheet: 136539d1326714490-formula-to-return-date-specific-criteria-help
Sheet: Monthly Art

Original Art Sales to include Artist & Gallery Commission
Total Art Sales
YEAR | 2011 |  |  |  |  |  |  |  |  |  |  |  |  | [42]
Artist ref | Artist | January | February | March | April | May | June | July | August | September | October | November | December | Total
A0001 | [NAME] | 2730 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2730
A0002 | [NAME] | 210 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 210
A0004 | [NAME] | 210 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 210
TOTAL AMOUNT PAID TO ARTISTS INCLUDING STUART |  | 3150 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3150 | total incl Stuart | 8910 | 20950 | 11397 | 10000
Stuarts totals |  | 2730 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2730 | Stuarts | 4680 | 14800 | 10397 | 10000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 420 | Oth Artists | 4230 | 6150 | 550 | 0
Gallery Commission @ 45%
YEAR | 2011 |  |  |  |  |  |  |  |  |  |  |  |  | [42]
Artist ref | Artist | January | February | March | April | May | June | July | August | September | October | November | December | Total
A0001 | [NAME] | 2730 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2730 | 3570
A0002 | [NAME] | 210 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 210 | 420
A0004 | [NAME] | 210 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 210
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | oct 2009 - dec 2009 | jan-july 2010 | Aug-Dec 2010
TOTAL PROFIT |  | 3150 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3150 | Profit incl Stuarts | 6583.5 | 17005 | 10847
Stuarts |  | 2730 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Stuarts | 4680 | 14800 | 10397
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Profit from other artists | 1903.5 | 2205 | 450 | 0 | 0 | 0
Artist Commission @ 55% (paid to artists)
YEAR | 2011 |  |  |  |  |  |  |  |  |  |  |  |  | [42]
Artist ref | Artist | January | February | March | April | May | June | July | August | September | October | November | December | Total
Artist ref | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 2940
A0001 | [NAME] | 2730 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2730 | 2940
A0002 | [NAME] | 210 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 210
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | oct 2009 - dec 2009 | jan-july 2010 | Aug-Dec 2010
TOTAL PROFIT |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | Profit incl Stuarts | 6583.5 | 17005 | 10847
Stuarts |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | Stuarts | 4680 | 14800 | 10397
Spreadsheet: 871655d1718082656-column-months-with-dates-worksheet-ans
Sheet: Sheet1 (2)

COD | NAME | FIRST_DATE | LAST_DATE | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00
1001 | A | 2024-01-01 00:00:00 | 2024-03-01 00:00:00
1001 | B | 2024-05-01 00:00:00 | 2024-08-01 00:00:00
1002 | R | 2024-04-01 00:00:00 | 2024-09-01 00:00:00
Spreadsheet: 292967d1390849093-comparing-most-recent-data-data-example
Sheet: Sheet1

 | 2 | yes |  |  | most recent | 5
 | 3 | no |  |  |  | yes | no
 | 2 | yes |  |  | 2
 | 3 | no |  |  | 3
 | 4 | yes |  |  | 4
 | 5 | no |  |  | 5
 | 2 | yes |  |  | 6
 | 3 | no |  |  | 8
 | 6 | yes |  |  | 7
 | 5 | no |  |  | 9
 | 4 | yes
 | 2 | no
 | 8 | yes
 | 6 | no
 | 2 | yes
 | 3 | no
 | 2 | yes
 | 5 | yes
 | 4 | no
 | 2 | yes
 | 3 | no
 | 6 | yes
 | 5 | no
 | 4 | yes
 | 2 | no
 | 3 | yes
 | 2 | no
 | 4 | yes
 | 2 | no
 | 3 | yes
 | 5 | no
 | 4 | yes
 | 2 | no
 | 3 | yes
 | 6 | yes
 | 2 | no
 | 3 | yes
 | 5 | no
 | 8 | yes
 | 7 | no
 | 2 | yes
 | 3 | no
 | 9 | yes
 | 3 | no
 | 4 | yes
 | 2 | no
 | 5 | yes
 | 4 | no
 | 2 | yes
 | 3 | no
 | 5 | yes
 | 7 | yes
 | 6 | no
 | 2 | yes
 | 3 | no
 | 4 | yes
 | 2 | no
 | 5 | yes
 | 4 | no
 | 5 | yes
 | 6 | no
 | 9 | yes
 | 5 | no
 | 4 | yes
 | 2 | no
 | 3 | yes
 | 2 | no
 | 3 | yes
 | 5 | yes
 | 4 | no
 | 2 | yes
 | 3 | no
 | 5 | yes
 | 4 | no
 | 2 | yes
 | 3 | no
 | 5 | yes
 | 4 | no
 | 2 | yes
 | 3 | no
Spreadsheet: 97618d1296747081-looking-for-formula-that-will-catch-special-rule-abuse-for-the-same-id-2011_02_03_reply
Sheet: Sheet1 (4)

ID | date | SLED |  | check
22 | 2010-01-27 00:00:00 | 2012-01-12 00:00:00
22 | 2010-01-27 00:00:00 | 2012-01-14 00:00:00
22 | 2010-01-27 00:00:00 | 2012-01-17 00:00:00
22 | 2010-01-27 00:00:00 | 2012-01-20 00:00:00
22 | 2010-01-27 00:00:00 | 2012-01-20 00:00:00
22 | 2010-01-27 00:00:00 | 2012-01-18 00:00:00
22 | 2010-01-27 00:00:00 | 2012-01-18 00:00:00
22 | 2010-01-27 00:00:00 | 2012-01-20 00:00:00
22 | 2010-01-27 00:00:00 | 2012-01-19 00:00:00
22 | 2010-01-28 00:00:00 | 2012-01-19 00:00:00
22 | 2010-01-28 00:00:00 | 2012-01-31 00:00:00
22 | 2010-01-28 00:00:00 | 2012-01-28 00:00:00
22 | 2010-01-28 00:00:00 | 2012-02-20 00:00:00
22 | 2010-01-28 00:00:00 | 2012-01-21 00:00:00
22 | 2010-01-29 00:00:00 | 2012-01-29 00:00:00
22 | 2010-01-29 00:00:00 | 2012-01-28 00:00:00
22 | 2010-01-29 00:00:00 | 2012-01-28 00:00:00
22 | 2010-01-29 00:00:00 | 2012-02-29 00:00:00
22 | 2010-01-29 00:00:00 | 2012-01-28 00:00:00
Spreadsheet: 241044d1370505045-filtering-by-one-column-based-on-values-in-another-table_pivot-solution
Sheet: pivot

Status | Select Me
Count of Material Description
Drawing number | Material Description | Total
1 | [NAME] type A | 1
 | Flange type A | 1
 | Gasket 1 | 1
 | PVC pipe | 1
1 Total |  | 4
3 | [NAME] type B | 1
 | Flange type C | 1
 | Gasket 1 | 1
 | PVC pipe | 1
3 Total |  | 4
Spreadsheet: 59108d1259577933-making-a-form-but-cant-remember-the-formula-example
Sheet: Full Data

ID | IRP Ref | Date of Entry | Claimant surname | Claimant first name | Claimant address Line 1 | Claimant address Line 2 | Claimant address Line 3 | Claimant address Line 4 | Clamiant address Line 5 | Claimant postcode | Claimant tel home | Claimant mobile | Claimant email | Patient surname | Patient first name | DOB | Deceased | Patient address Line 1 | Patient address [NAME] | Patient address [NAME] | Patient address [NAME] | Patient address Line 5 | Patient postcode | Patient tel home | Patient mobile | Patient email | Other contact info | Responsible PCT | Hub PCT | Reason 1 | Reason 2 | Reason 3 | Reason 4 | Reason 5 | Reason 6 | Reason 7 | Reason 8 | Case notes | IRP date | Date report received | Sent to claimant / PCT | Lay Chair | Period of claim | Append1a | Append1a date | Append1a notes | Append1b
2 | 09/422 | 2009-02-02 00:00:00
3 | 09/427 | 2009-03-20 00:00:00
5 | 09/426 | 2009-03-19 00:00:00
Spreadsheet: 191731d1352204852-defining-names-on-a-column-definename
Sheet: Sheet1

 |  |  | without defining names |  |  |  |  | defining names
 |  |  | Cost 1 | 1 | 4 | 7 |  | Cost 1 | 1 | 4 | 7
 |  |  | Cost 2 | 2 | 5 | 8 |  | Cost 2 | 2 | 5 | 8
 |  |  | Cost 3 | 3 | 6 | 9 |  | Cost 3 | 3 | 6 | 9
 |  |  | Cost 4 |  |  |  |  | Cost 4
Spreadsheet: 751472d1634132274-tons-of-info-show-affected-from-dropdown-examplefileupdated
Sheet: Calculations

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes | No
Spreadsheet: 24607d1215131852-formula-help-2007-version-stg1
Sheet: Sheet1

Name | ADC# | STG Group | Unit | Self Admission(5) | Tattos(7) | Symbolism(2) | Documents(5) | Publications(1) | Authorship(7) | Court Records(9) | Group Photos(2) | [NAME]) | Contacts(2) | C/I Information(2) | Membership(9) | Other Agencies(8) | Media(5) | Total | Comments
Smith | 123456 | DW004 | Kenterstein | X |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | Security Threat Group investigation complete
Jones | 202784 | EK046 | Wabash |  |  | X |  |  |  | X |  |  |  |  |  |  |  | 11 | Scheduled for validation
Spreadsheet: 00b1ceb6-866d-43a5-9f36-4fbf8b127fe4
Sheet: 14a

Product |  | TOTAL
Single - Name* | Corporate | 794025
 | Loans | 5903
 | Municipal | <1,000
 | Recovery
 | Sovereign | 226007
Index Tranche | Asia | <1,000
 | Europe | 183520
 | North America | 192951
Index | Asia | 31788
 | Europe | 398146
 | North America | 580839
Other | Exotic
 | Swaptions
 | Total Return Swap
TOTAL* |  | 2413181
Estimated net notional amount outstanding, December 7 weekly snapshot, by product type (millions of USD), all tenors and currencies. This table will be expanded to reflect participant type and cleared status as more complete data becomes available.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 877984d1724933636-calculating-overtime-hours-lieu-tracker
Sheet: Sheet1

Day | Date | Time In | Time Out | Total Time | [NAME] | Time Used | Week Total | Acumulated Week Total |  | Accumulated | Accumulated | Used
 |  |  |  |  |  |  |  |  |  | Hours | Days | Time
Monday | 2024-08-26 00:00:00 | 06:41:00 | 17:03:00
Tuesday | 2024-08-27 00:00:00 | 06:39:00 | 17:01:00
Wednesday | 2024-08-28 00:00:00 | 06:30:00 | 16:48:00
Thursday | 2024-08-29 00:00:00 | 06:34:00
Friday | 2024-08-30 00:00:00
Saturday | 2024-08-31 00:00:00
Sunday | 2024-09-01 00:00:00
Spreadsheet: 100034d1298511934-count-occurences-of-y-and-put-value-into-table2-flash-sample
Sheet: Sheet2

 | (SHEET 2)
 | VENICE
 | Analyst | Submitted | # Submit'd | Complied | # Compl'd | LHDR Pending | # Pending | Add On Debt | # Add-ons
 | [NAME] |  |  |  |  |  |  | 1173.02 | 1
 | Seamus |  | 3 |  |  |  |  | 0 | 0
 | [NAME] |  | 2 |  |  |  |  | 0 | 0
 | Nate |  | 1 |  |  |  |  | 0 | 0
 | [NAME] |  | 2 |  |  |  |  | 0 | 0
 | [NAME] |  | 1 |  |  |  |  | 0 | 0
 | [NAME] |  | 1 |  |  |  |  | 0 | 0
 | Total
 |  | B4:B11 are the total |  | D4:D11 are the total |  | F4:F11 are from all
 |  | amounts from c3:c20 |  | sum (from Sheet1) |  | "N's" from Sheet 1
 |  | Sheet 1 |  | ALL "Y's"
Spreadsheet: 877144d1723817807-filter-function-to-extract-selected-columns-kerahjoy-filter-by-selected-columns-365-aligw
Sheet: Sheet1

Data | County | Region | Support Coordinator | Supervisor |  | Criteria | Select Column names |  | Derised outcome |  | Support Coordinator | Supervisor
 | Walker | Region 1 | Diane Parsons | [NAME] |  |  | Support Coordinator |  |  | Region 1 | Diane Parsons | [NAME]
 | [NAME] | Region 3 | [NAME] | [NAME] |  |  | Supervisor |  |  | Region 3 | [NAME] | [NAME]
 | Fulton | Region 3 | [NAME] | [NAME] |  |  | Region |  |  | Region 3 | [NAME] | [NAME]
 | Newton | Region 3 | [NAME] | [NAME] |  |  |  |  |  | Region 3 | [NAME] | [NAME]
 | [NAME] | Region 3 | [NAME] | [NAME] |  |  |  |  |  | Region 3 | [NAME] | [NAME]
 | [NAME] | Region 3 | [NAME] | [NAME] |  |  |  |  |  | Region 3 | [NAME] | [NAME]
Spreadsheet: 800268d1665571282-use-125-if-2500-otherwise-use-40-attachment
Sheet: Tabelle1

 |  |  |  |  | Hourly rate | Working hours | Gross revenue | Net revenue (40%) | Total
 |  |  |  |  | 125 | 8 | 2200
 |  |  |  |  |  | 8 | 2500
 |  |  |  |  |  | 8 | 2600
 |  |  |  |  |  | 7 | 1900
 |  |  |  |  |  | 6 | 3000
 |  |  |  |  |  | 9 | 2200
Spreadsheet: 709366d1608268076-returning-last-value-in-a-row-excel-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10