tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 875012d1721554265-need-help-to-make-pending-list-data-akir4-help-2-1-aligw
Sheet: Sheet1

 | Data |  |  |  |  |  |  |  |  |  | instead of inputing manually by copy and paste I want to make the data to automatically appear here when the order still have some pending item, and disappear when it is done delivering.
 | Date | Order No | Customer | Item A | Item B | Item C | Item D | Deliver | Pending
 | 2024-07-01 00:00:00 | 33-1000 | A | 4 | 8 | 9 | 8 | Done |  |  | To do List
 | 2024-07-01 00:00:00 | 33-1001 | B | 5 | 7 | 5 | 2 | 10 | 9 |  | Date | Order No | Customer | Pending / need to be deliver
 | 2024-07-02 00:00:00 | 33-1002 | C | 6 | 5 | 3 | 3 | 10 | 7 |  | 2024-07-01 00:00:00 | 33-1001 | B | 9
 | 2024-07-02 00:00:00 | 33-1003 | D | 7 | 3 | 7 | 7 | Done |  |  | 2024-07-02 00:00:00 | 33-1002 | C | 7
 | 2024-07-03 00:00:00 | 33-1004 | E | 9 | 8 | 8 | 8 | Done |  |  | 2024-07-04 00:00:00 | 33-1006 | G | 14
 | 2024-07-03 00:00:00 | 33-1005 | F | 1 | 9 | 2 | 6 | Done |  |  | 2024-07-05 00:00:00 | 33-1008 | I | 12
 | 2024-07-04 00:00:00 | 33-1006 | G | 5 | 7 | 7 | 2 | 7 | 14 |  | 2024-07-06 00:00:00 | 33-1010 | K | 20
 | 2024-07-04 00:00:00 | 33-1007 | H | 7 | 15 | 3 | 5 | Done |  |  | 2024-07-06 00:00:00 | 33-1011 | L | 20
 | 2024-07-05 00:00:00 | 33-1008 | I | 9 | 1 | 5 | 7 | 10 | 12 |  | 2024-07-07 00:00:00 | 33-1013 | N | 10
 | 2024-07-05 00:00:00 | 33-1009 | J | 3 | 10 | 7 | 2 | Done |  |  | 2024-07-09 00:00:00 | 33-1016 | Q | 10
 | 2024-07-06 00:00:00 | 33-1010 | K | 8 | 7 | 3 | 8 | 6 | 20 |  | 2024-07-10 00:00:00 | 33-1018 | S | 12
 | 2024-07-06 00:00:00 | 33-1011 | L | 4 | 4 | 21 | 3 | 12 | 20 |  | 2024-07-10 00:00:00 | 33-1019 | T | 6
 | 2024-07-07 00:00:00 | 33-1012 | M | 4 | 6 | 7 | 5 | Done
 | 2024-07-07 00:00:00 | 33-1013 | N | 3 | 8 | 9 | 7 | 17 | 10 |  |  | 33-1001 | B | 9
 | 2024-07-08 00:00:00 | 33-1014 | O | 5 | 7 | 5 | 5 | Done |  |  | 2024-07-02 00:00:00 | 33-1002 | C | 7
 | 2024-07-08 00:00:00 | 33-1015 | P | 7 | 8 | 1 | 3 | Done |  |  | 2024-07-04 00:00:00 | 33-1006 | G | 14
 | 2024-07-09 00:00:00 | 33-1016 | Q | 5 | 7 | 5 | 8 | 15 | 10 |  | 2024-07-05 00:00:00 | 33-1008 | I | 12
 | 2024-07-09 00:00:00 | 33-1017 | R | 3 | 5 | 9 | 7 | Done |  |  | 2024-07-06 00:00:00 | 33-1010 | K | 20
 | 2024-07-10 00:00:00 | 33-1018 | S | 7 | 7 | 2 | 1 | 5 | 12 |  | 2024-07-06 00:00:00 | 33-1011 | L | 20
 | 2024-07-10 00:00:00 | 33-1019 | T | 4 | 6 | 2 | 1 | 7 | 6 |  | 2024-07-07 00:00:00 | 33-1013 | N | 10
 |  |  |  |  |  |  |  |  |  |  | 2024-07-09 00:00:00 | 33-1016 | Q | 10
 |  | https://www.instagram.com/reel/C8cUoXvCZNh/?utm_source=ig_web_copy_link&igsh=MzRlODBiNWFlZA== |  |  |  |  |  |  |  |  | 2024-07-10 00:00:00 | 33-1018 | S | 12
 |  |  |  |  |  |  |  |  |  |  | 2024-07-10 00:00:00 | 33-1019 | T | 6
Spreadsheet: 859558d1707911339-formula-issue-20240214-test-example
Sheet: 1

 |  | ACTIVITY | NAMES | NUMBER OF PARTICIPANTS
 |  | Performance | Not known
 |  | Performance | [NAME], [NAME], [NAME], [NAME], [NAME], Nina Ellis, Irene Grange, [NAME], [NAME], [NAME], [NAME], [NAME], [NAME], Freddie Peters
 |  | Recording | [NAME], [NAME], [NAME], [NAME], [NAME], Nina Ellis
 |  | Performance & Broadcast | [NAME], [NAME], [NAME], [NAME], [NAME], Nina Ellis, Irene Grange, [NAME], [NAME], [NAME], [NAME], [NAME], [NAME], Freddie Peters
 |  | Recording | Not known
 |  | Performance | [NAME], [NAME], [NAME], [NAME], [NAME], Nina Ellis, Irene Grange, [NAME], [NAME], [NAME], [NAME], [NAME], [NAME], Freddie Peters
 |  | Performance | Not applicable
 |  | [NAME] | Broadcast recording
 |  | Performance | Not known
 |  | Performance | [NAME], [NAME], [NAME], [NAME], [NAME], Nina Ellis
 |  | Performance | [NAME], [NAME], [NAME], [NAME], [NAME], Nina Ellis
Spreadsheet: 876014d1722652206-list-members-of-each-team-by-team-number-learning-the-ropes-book3
Sheet: Soluton

Player Number | First Name | Last Name | Assigned Team # |  | Team Number
 |  |  |  |  |  | TEAM MEMBERS
1 | Afera | Quick | 4 |  | 1
2 | Al | Knol | 6 |  |  | [NAME]
3 | Barb | Tamp | 9 |  | 2
4 | Barb | Pine | 1 |  |  | Nate Late
5 | [NAME] | [NAME] | 10 |  | 3
6 | [NAME] | Stout | 2 |  |  | Mac  Long
7 | [NAME] | Smith | 3 |  | 4
8 | [NAME] | Dime | 5 |  |  | [NAME]
9 | [NAME] | Radcliff | 6 |  | 5
10 | George | Plum | 8 |  |  | [NAME]
11 | [NAME] | [NAME] | 10 |  | 6
12 | [NAME] | Slow | 1 |  |  | [NAME]
13 | [NAME] | [NAME] | 7 |  | 7
14 | Mac | Long | 3 |  |  | [NAME]
15 | Nate | Late | 2 |  | 8
16 | Ned | Brow | 5 |  |  | Shelly Early
17 | Ray | Erskine | 9 |  | 9
18 | Shelly | Early | 8 |  |  | [NAME]
19 | [NAME] | Ready | 4 |  | 10
20 | Sue | Baxter | 7 |  |  | [NAME]
Spreadsheet: 856572d1705772564-complex-hours-sum-involving-semi-monthly-payperiod-and-monday-to-sunday-calendar-weeks-punches
Sheet: Names

[NAME] | Doe, [NAME] |  |  |  |  |  | Start |  |  |  |  |  |  |  |  |  |  |  | True
[NAME] | Doe, [NAME] |  |  |  |  |  | 2024-01-16 00:00:00 |  | Doe, [NAME] |  | 23.02 |  |  | 0 |  | 0
[NAME] | Doe, [NAME] |  |  |  |  |  | End |  | Doe, [NAME] |  | 40.83 |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  | 0
 |  |  |  |  |  |  | Min Wage |  |  |  | 0 |  |  | 0 |  | 0
 |  |  |  |  |  |  | 14.35 |  |  |  | 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
 |  |  |  |  |  |  |  |  |  |  | 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
Spreadsheet: 02e9c190-ba67-4eac-ad69-5b2bb300c6f2
Sheet: Sheet1

State of New Hampshire - General Election | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | State Senate District 7
2012-11-06 00:00:00 | [NAME], r | [NAME], d | [NAME]
Andover | 484 | 750 | 4
Belmont | 1540 | 1834 | 2
[NAME] | 645 | 966 | 2
Canterbury | 458 | 918 | 7
[NAME] | 443 | 752 | 6
[NAME] | 303 | 598 | 5
[NAME] | 426 | 831 | 8
Gilford | 1823 | 2386 | 3
[NAME] | 619 | 714
[NAME] | 447 | 605
[NAME] 3 | 479 | 805
[NAME] | 474 | 640
[NAME] | 387 | 601
[NAME] 6 | 695 | 892
Northfield | 830 | 1232 | 2
Salisbury | 314 | 415
[NAME] | 401 | 634
Totals | 10768 | 15573 | 39
 | State Senate District 8
 | [NAME], r | [NAME], d | [NAME]
Acworth | 282 | 237
Antrim | 674 | 674
Bennington | 384 | 336 | 1
Bradford | 529 | 380
Croydon | 295 | 117 | 1
Deering | 517 | 420
Francestown | 522 | 460 | 2
Goshen | 300 | 107 | 1
Grantham | 951 | 911
Hillsborough | 1348 | 1193 | 2
Langdon | 214 | 155
Lempster | 436 | 136
Marlow | 222 | 180 | 1
New London | 1863 | 980 | 4
Newbury | 866 | 414
Newport | 1871 | 776 | 1
Springfield | 445 | 260
Stoddard | 407 | 308
Sunapee | 1378 | 545 | 2
Sutton | 639 | 482
Unity | 505 | 212 | 2
Weare | 2613 | 1638 | 3
Windsor | 60 | 39
Washington | 388 | 178
Totals | 17709 | 11138 | 20
Spreadsheet: 739396d1625672174-configurable-match-from-two-sheets-of-data-configurable-sheet-ans
Sheet: Analysis

 |  | Configurable value
 |  | 4.35889894354067
Comparison | x | y | z | Sum
1
2
3
4
5
Spreadsheet: 736009d1623318959-format-condition-with-horizon-number-highlight-with-smallest-price-comparison_help
Sheet: Price Selection

 | Items | [NAME] : |  | Supplier 1 | Supplier 2 | Supplier 3 | Supplier 4
 | Description | Unit | QTY | Price1 | Price2 | Price4 | Price5
 | A | Pcs | 100000 | 0.041 | 0.057 | 1.8 | 0.065 |  | 0.041 | 0.057 | 1.8 | 0.065
 | B | Pcs | 5000 | 25.5 | 26.8 | 27.3 | 21.95 |  | 25.5 | 26.8 | 27.3 | 21.95
 | C | Pcs | 10000 | 1.8 | 1.85 | 1.98 | 2.77 |  | 1.8 | 1.85 | 1.98 | 2.77
 | D | Pcs | 10000 | 0 | 0.19 | 0.15 | 0.175 |  | 0 | 0.19 | 0.15 | 0.175
 | E | Pcs | 7000 | 0.88 | 0.9 | 0.9 | 0.63 |  | 0.88 | 0.9 | 0.9 | 0.63
 | F | Pcs | 5000 | 3.9 | 4.5 | 4.3 | 0 |  | 3.9 | 4.5 | 4.3 | 0
 | G | Pcs | 5000 | 2.3 | 2.4 | 2.4 | 1.97 |  | 2.3 | 2.4 | 2.4 | 1.97
 | Remark
 | 1. I would like to higher the lower price of each item from supplier 1 to 4. 2. some supplier do not supply that item so we put in 0, and I don't want to compare with zero value.
Spreadsheet: 687260d1595067990-return-last-value-from-multiple-columns-book1
Sheet: Sheet1

Name | Rating | Name | Value
[NAME] | 2 | [NAME] | 4 |  | Last rating of [NAME]
[NAME] | 4 | [NAME] | 5
Zak | 6 | Will | 2
[NAME] | 3 | [NAME] | 3
Will | 4 | Zak | 4
[NAME] | 1 | [NAME] | 5
[NAME] | 3 | Zak | 6
Spreadsheet: 155664d1337003671-vlookup-and-concatenate-all-matches-example
Sheet: Sheet1

Name | Number | Example results (vlookup the name and concatenate all matches)
[NAME] | 12 | [NAME], 13, 11, 141, 4543, 5467, 547 5, 6, 7,
[NAME] | 13 | [NAME], 13, 11, 141, 4543, 5467, 547 5, 6, 7,
[NAME] | 11 | [NAME], 13, 11, 141, 4543, 5467, 547 5, 6, 7,
[NAME] | 123 | [NAME], 234, 234, 2, 56, 989, 89, 98
[NAME] | 141 | [NAME], 13, 11, 141, 4543, 5467, 547 5, 6, 7,
[NAME] | 4543 | [NAME], 13, 11, 141, 4543, 5467, 547 5, 6, 7,
[NAME] | 5467 | [NAME], 13, 11, 141, 4543, 5467, 547 5, 6, 7,
[NAME] | 547 | [NAME], 13, 11, 141, 4543, 5467, 547 5, 6, 7,
[NAME] | 234 | [NAME], 234, 234, 2, 56, 989, 89, 98
[NAME] | 234 | [NAME], 234, 234, 2, 56, 989, 89, 98
[NAME] | 2 | [NAME], 234, 234, 2, 56, 989, 89, 98
[NAME] | 56 | [NAME], 234, 234, 2, 56, 989, 89, 98
[NAME] | 5 | [NAME], 13, 11, 141, 4543, 5467, 547 5, 6, 7,
[NAME] | 6 | [NAME], 13, 11, 141, 4543, 5467, 547 5, 6, 7,
[NAME] | 7 | [NAME], 13, 11, 141, 4543, 5467, 547 5, 6, 7,
[NAME] | 989 | [NAME], 234, 234, 2, 56, 989, 89, 98
[NAME] | 89 | [NAME], 234, 234, 2, 56, 989, 89, 98
[NAME] | 98 | [NAME], 234, 234, 2, 56, 989, 89, 98
Spreadsheet: 1fca1413-ec8c-4d44-ad13-3c008151a6ad
Sheet: Sheet1

Permit No.: | Unnamed: 1 | WQ0033804 | Unnamed: 3 | Facility Name: | Unnamed: 5 | Deerborne Cottages | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | County: | Buncombe | Unnamed: 13 | Month: | Unnamed: 15 | Unnamed: 16 | Year: | Unnamed: 18
PPI: |  | 001 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050 | 00310 | 31616 | 00610 | 00625 | 00620 | 00600 | 00400 | 00665 | 00530 | 00076
Day | ORC Arrival Time | ORC Time On Site | Flow | BOD5 | Fecal Coliform | Ammonia | Total [NAME] | Nitrate | Total Nitrogen | pH | Total Phosphorus | Total Suspended Solids | Turbidity
 | 24-hr | hrs | GPD | mg/L | #/100 mL | mg/L | mg/L | mg/L | mg/L | su | mg/L | mg/L | NTU
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
31
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Estimate | Grab | Grab | Grab | Grab | Grab | Grab | Grab | Grab | Grab | Recorder
Monthly Limit: |  |  | 5360 | 10 | 14 | 4 |  |  |  |  |  | 5
Daily Limit: |  |  |  | 15 | 25 | 6 |  |  |  | 6-9 |  | 10 | 10
Sample Frequency: |  |  | Monthly | 4 x Year | 4 x Year | 4 x Year | 4 x Year | 4 x Year | 4 x Year | Weekly | 4 x Year | 4 x Year | [NAME]
 |  | Average
 |  | Geomean
 |  | MAX/MIN
Spreadsheet: b0592d74-9006-4399-bc06-c1b573cd7377
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
NIS | Test | NIS | Nickel, Serum | Nickel, S | Inductively Coupled Plasma-Mass Spectrometry (ICP-MS) | Royal blue-top Monoject trace element blood collection tube: RylBlue |  |  | 2 | mL | Collection Container/Tube: Plain, royal blue-top [NAME] plastic trace element blood collection tube, catalog #368380 (Supply T184) Submission Container/Tube: 7-mL Mayo metal-free, screw-capped, polypropylene vial (Supply T173) [NAME]: 2 mL Collection Instructions: 1. Allow the specimen to clot for 30 minutes; then centrifuge the specimen to separate serum from the cellular fraction. 2. Remove the stopper. Carefully pour specimen into a 7-mL Mayo metal-free, screw-capped, polypropylene vial, avoiding transfer of the cellular components of blood. Do not insert a pipet into the serum to accomplish transfer, and do not ream the specimen with a wooden stick to assist with serum transfer. 3. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. Additional Information: High concentrations of gadolinium and iodine are known to interfere with most metals tests. If either gadolinium- or iodine-containing contrast media has been administered, a specimen should not be collected for 96 hours. | 0.5 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; Gross reject Other	NA | <2.0 ng/mL | Thursday; 5 p.m. | 1 day | 7 days | 1 | 83885 |  |  |  |  | Rochester
NIS | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
NIS | Result | 8622 | Nickel, S | Nickel, S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 5702-6 | Nickel:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 109868d1306690307-rearranging-data-for-further-analysis-1176-data-john
Sheet: Sheet1

Date | Duty | DOT Rout No | Trip | Contract | Bus | Driver | Sched Time | Book On Time | Schedule Distance |  | Non-Rev | Revenue | Passes | Tickets | Transfer | Total Psngrs
Date | 501 | 01.303.05 | 0 | 1425 ZNT1175 | 7517 | 7567 | 14:25 | 13:26 | 36.8 | Operated | R91.31 | R294.00 | 12 | 35 | 0 | 47
Date | 501 | 04.303.12 | 0 | 1130 ZNT1175 | 7517 | 7567 | 11:30 | 11:09 | 36.8 | Operated | R57.53 | R21.00 | 8 | 3 | 0 | 11
Date | 501 | 06.303.18 | 0 | 0620 NS1175 | 7517 | 7567 | 06:20 | 5:56 | 42.6 | Operated | R119.73 | R113.00 | 17 | 13 | 1 | 31
Date | 501 | 08.302.12 | 0 | 0350 NS1175 | 7517 | 7567 | 03:50 | 3:25 | 67.8 | Operated | R332.75 | R237.50 | 40 | 21 | 0 | 61
 | 501
 | 501
 | 501
 | 501
 | 501
 | 501
 | 501
 | 501
 | 501
 | 501
 | 501
Spreadsheet: 867757d1714555139-preventing-the-entry-of-the-number-1-in-any-dynamic-data-group-or-variable-range-data100
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Group_1 | Group_2
 | 1 |  | 1 |  |  |  |  |  | A | 1
 |  |  |  |  |  |  |  |  | B | 2
 |  |  |  |  |  |  |  |  | C
 |  |  |  |  |  |  |  |  |  | I want the non-repeated number 1 to be entered in each variable and dynamic group
 |  |  |  |  |  |  |  |  |  | If the data of each group is changed (added or decreased), the value of the data will also change according to the columns
 |  |  |  |  | Data =Sheet1!$A$19:$N$19
 | B | C | 0 | 0 | 0 | 0 |  | 2 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 695763d1600377925-max-book2
Sheet: Leaderboard

Score | User Name | Time Taken
18 | [NAME] | 00:01:39
0 | [NAME] | 00:01:39
2 | Ian s | 00:01:39
18 | Dom | 00:01:39
1 | [NAME] | 00:01:39
18 | [NAME] | 00:01:39
Spreadsheet: 6400ccf5-3885-4763-ad4a-6dd1af405127
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
FCAR | Test | FCAR | Carbamazepine, Free and Total, Serum | Carbamazepine, Free and Total, S | CARFR: Membrane Separation/Immunoassay CART: Immunoassay | Plain, Red-Top Tube: Red |  |  | 3 | mL | Container/Tube: Red top [NAME]: 3 mL | 2 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	Serum gel tube | TOTAL Therapeutic concentration: 4.0-12.0 mcg/mL Toxic concentration: > or =15.0 mcg/mL   FREE Therapeutic concentration: 1.0-3.0 mcg/mL Toxic concentration: > or =4.0 mcg/mL | Monday through Sunday; 2 p.m. | Same day/1 day | 3 days |  | Profile |  |  |  |  | Rochester
FCAR | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
FCAR | Component | CARFR | Carbamazepine, Free, Serum | Carbamazepine, Free, S | Membrane Separation/Immunoassay | Plain, Red-Top Tube: Red |  |  | 3 | mL |  | 1 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	Serum gel tube | Therapeutic concentration: 1.0-3.0 mcg/mL Toxic concentration: > or =4.0 mcg/mL | Monday through Sunday; Varies | Same day/1day | 3 days | 1 | 80157 |  |  | Yes | No
CARFR | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
CARFR | Result | 15885 | Carbamazepine, Free, S | Carbamazepine, Free, S | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 3433-0 | Carbamazepine.free:MCnc:Pt:Ser/Plas:Qn:
FCAR | Component | CART | Carbamazepine, Total, Serum | Carbamazepine, Tot, S | Immunoassay | Plain, Red-Top Tube: Red OR |  |  | 0.5 | mL | Only orderable as part of a profile. For further information see FCAR / Carbamazepine, Free and Total, Serum. | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	Serum gel tube | Therapeutic concentration: 4.0-12.0 mcg/mL Toxic concentration: > or =15.0 mcg/mL | Monday through Sunday; Varies | Same day/1 day | 3 days | 1 | 80156 |  |  | Yes | Yes
CART | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
CART | Result | 8654 | Carbamazepine, Total, S | Carbamazepine, Total, S | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 3432-2 | Carbamazepine:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 119157d1314226054-how-do-i-plot-both-month-and-date-from-pivot-table-data-2seriescolumnchart
Sheet: Sheet1

Row Labels | Sum of precip (in)
<1/1/1900
(blank)
1900
Jan | 0.92
Feb | 0
Mar | 0.9200000000000002
Apr | 1.96
May | 1.71
Jun | 0
Jul | 0.34
Aug | 0
Sep | 0.23
Oct | 0.36
Nov | 6.1
Dec | 0
1901
Jan | 3.48
Feb | 4.58
Mar | 0.43
Apr | 0.5599999999999999
May | 1.23
Jun | 0.05
Jul | 0
Aug | 0.27
Sep | 0.07
Oct | 1.09
Nov | 0.28
Dec | 0.04
Spreadsheet: 557122d1516442331-how-to-move-data-in-columns-below-another-set-of-columns-book1-5-
Sheet: New Request 2 var B

[NAME] | Col 1 | Col 2 | Col 3 | Col 4 | Col 5 | Col 6 | Col 7 | Col 8 | Col 9 |  |  |  | [NAME] | Col 1 | Col 2 | Col 3
AAA | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
BBB | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
CCC | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
Spreadsheet: 874114d1720680475-if-formula-not-making-data-blank-when-it-is-acrossley1-test-data-14-aligw
Sheet: Sheet2

 | pear |  |  |  | 2024-07-01 00:00:00 | 2024-07-02 00:00:00 | 2024-07-03 00:00:00 | 2024-07-04 00:00:00 | 2024-07-05 00:00:00 | 2024-07-06 00:00:00 | 2024-07-07 00:00:00
 |  |  |  |  |  | 5 | 5 |  | 3 | 4 | 4
Spreadsheet: 704270d1605470706-can-the-sum-range-of-sumif-be-stopped-and-only-pick-certain-rows-to-sum-help-with-excel-sumif-with-index-match
Sheet: Sheet1

Unique "Text" | Variable | Line Item | TOTALS |  | Details
S | S |  | 20 |  | < need formual that sums down from ROW 5 to ROW 20 but will stop at ROW 8. Then only sum the Rows WITHOUT the letter "v" in Column B
blank |  | Line Items 1 | 10
blank |  | Line Items 2 | 10
blank | v | Line Items 3 | 0
blank | v | Line Items 4 | 10
S | S |  | 50 |  | < need formual that sums down from ROW 10 to ROW 20 but will stop at ROW 15. Then only sum the Rows WITHOUT the letter "v" in Column B
blank |  | Line Items 5 | 20
blank | v | Line Items 6 | 20
blank |  | Line Items 7 | 0
blank |  | Line Items 8 | 20
blank |  | Line Items 9 | 10
blank |  | Line Items 10 | 0
S | S |  | 30 |  | < need formual that sums down from ROW 17 to ROW 20 but will stop at ROW 19. Then only sum the Rows WITHOUT the letter "v" in Column B
blank | v | Line Items 11 | 0
blank | v | Line Items 12 | 30
blank |  | Line Items 13 | 30
S | S
Spreadsheet: 255d1d53-7ccd-4a35-bf07-699b18e73cc7
Sheet: 11b

Product1 | EUR3 | USD | GBP | [NAME] | AUD | CAD | OTHER | TOTAL
Cross-Currency Basis | 60 | 99 | 21 | 148 | 45 | 54 | 47 | 474
Cross-Currency Fixed-Fixed | 4 | 3 | 2 | 1 | 0 | 3 | 2 | 15
Cross-Currency Fixed-Float | 3 | 31 | 0 | 4 | 2 | 2 | 143 | 185
TOTAL | 67 | 133 | 23 | 153 | 47 | 59 | 192 | 674
Spreadsheet: 76389d1276887544-pivot-table-display-dummy_wb1
Sheet: Sheet4

Week | (All)
[NAME] | Data | Total
CASTELLINI COMPANY | Sum of Short | 16
 | Sum of Dmgd
 | Sum of Quality Issue
 | Sum of Mis-ship | 2
 | Sum of Others
 | Sum of Var | -18
CHURCH BROTHERS LLC | Sum of Short | 3
 | Sum of Dmgd
 | Sum of Quality Issue
 | Sum of Mis-ship
 | Sum of Others
 | Sum of Var | -3
CLUB CHEF INC | Sum of Short | 10
 | Sum of Dmgd
 | Sum of Quality Issue
 | Sum of Mis-ship
 | Sum of Others
 | Sum of Var | -10
CONAGRA CULINARY SHEL | Sum of Short | 5
 | Sum of Dmgd
 | Sum of Quality Issue
 | Sum of Mis-ship
 | Sum of Others
 | Sum of Var | -5
FRESH START BAKERIES- | Sum of Short
 | Sum of Dmgd | 1
 | Sum of Quality Issue
 | Sum of Mis-ship
 | Sum of Others
 | Sum of Var | -1
GRANT COUNTY FOODS | Sum of Short
 | Sum of Dmgd
 | Sum of Quality Issue | 20
 | Sum of Mis-ship
 | Sum of Others
 | Sum of Var | -20
KRAFT/AURORA-DRY | Sum of Short | 61
 | Sum of Dmgd
 | Sum of Quality Issue
 | Sum of Mis-ship
 | Sum of Others
 | Sum of Var | -61
MCCAIN FOOD/ORE-IDA | Sum of Short | 1
 | Sum of Dmgd
 | Sum of Quality Issue
 | Sum of Mis-ship
 | Sum of Others
 | Sum of Var | -1
NEW FRENCH BAKERY | Sum of Short | 60
 | Sum of Dmgd
 | Sum of Quality Issue
 | Sum of Mis-ship
 | Sum of Others
 | Sum of Var | -60
RAM PRODUCE DISTRIBUT | Sum of Short
 | Sum of Dmgd
 | Sum of Quality Issue
 | Sum of Mis-ship | 10
 | Sum of Others
 | Sum of Var | -10
SELECT PRODUCT GROUP | Sum of Short
 | Sum of Dmgd | 1
 | Sum of Quality Issue
 | Sum of Mis-ship
 | Sum of Others
 | Sum of Var | -1
TYSON FOODS INC. | Sum of Short | 402
 | Sum of Dmgd
 | Sum of Quality Issue
 | Sum of Mis-ship
 | Sum of Others
 | Sum of Var | -402
US FOODSERVICE-3K STR | Sum of Short | 7
 | Sum of Dmgd
 | Sum of Quality Issue
 | Sum of Mis-ship
 | Sum of Others
 | Sum of Var | -7
WOLVERINE PACKING CO | Sum of Short | 12
 | Sum of Dmgd
 | Sum of Quality Issue
 | Sum of Mis-ship
 | Sum of Others
 | Sum of Var | -12
Total Sum of Short |  | 577
Total Sum of Dmgd |  | 2
Total Sum of Quality Issue |  | 20
Total Sum of Mis-ship |  | 12
Total Sum of Others
Total Sum of Var |  | -611
Spreadsheet: 547340d1510503270-filling-across-a-range-of-sheets-test
Sheet: Redro

BOAT NAME
OWNER NAME
MOORING TYPE
ADDRESS
HOME TEL
MOBILE TEL
[NAME]
BOAT TYPE
LENGTH
HULL COLOUR
UPPER DECK
TENDER?
DURATION
FEE
NEXT INVOICE DUE DATE | 2014-07-23 00:00:00
INVOICE DUE DATE | INVOICE REMINDER DATE | INVOICE SENT DATE | DATE PAID | NOTES
2014-07-23 00:00:00
Spreadsheet: 0b405207-99c7-4a3a-bc47-07e0b78c73c5
Sheet: 17

Product* | October 11 | October 18 | October 25 | November 1 | November 8
Total***
Agricultural | N/A | N/A | N/A | N/A | N/A
Index | N/A | N/A | N/A | N/A | N/A
Energy | N/A | N/A | N/A | N/A | N/A
Metals | N/A | N/A | N/A | N/A | N/A
OTHER** | N/A | N/A | N/A | N/A | N/A
TOTAL
Gross notional amount outstanding, November 8 weekly snapshot, by product type, all participant types, tenors and currencies.
*See Data Dictionary for product descriptions and Explanatory Notes for data sources.
**OTHER variable includes the following products: Multi-Commodity, Environmental, and Freight.
***These numbers are estimates.
****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].