tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 39194d1237391399-sorting-with-dates-example
Sheet: Sheet1

 | [NAME]
 |  |  |  | Dates |  |  |  |  |  |  |  |  |  |  |  | Hours
 |  |  |  | 2009-01-17 00:00:00 |  |  | A |  |  |  | 0.75 |  |  | 0 | 0.75
 |  |  |  | 2009-02-13 00:00:00 |  |  | A |  |  |  | 0.75 |  |  | 0 | 0.75
 |  |  |  | 2009-02-20 00:00:00 |  |  | B |  |  |  | 1.25 |  |  | 0 | 1.25
 |  |  |  | 2009-01-06 00:00:00 |  |  | B |  |  |  | 16 |  |  | 8 | 24
 |  |  |  | 2009-01-07 00:00:00 |  |  | C |  |  |  | 16 |  |  | 8 | 24
 |  |  |  | 2009-01-10 00:00:00 |  |  | C |  |  |  | 16 |  |  | 8 | 24
 |  |  |  | 2009-01-13 00:00:00 |  |  | C |  |  |  | 16 |  |  | 8 | 24
 |  |  |  | 2009-01-16 00:00:00 |  |  | C |  |  |  | 16 |  |  | 8 | 24
 |  |  |  | 2009-01-19 00:00:00 |  |  | C |  |  |  | 16 |  |  | 8 | 24
 |  |  |  | 2009-01-22 00:00:00 |  |  | C |  |  |  | 16 |  |  | 8 | 24
 |  |  |  | 2009-01-25 00:00:00 |  |  | C |  |  |  | 16 |  |  | 8 | 24
 |  |  |  | 2009-01-28 00:00:00 |  |  | C |  |  |  | 16 |  |  | 8 | 24
 |  |  |  | 2009-01-31 00:00:00 |  |  | C |  |  |  | 16 |  |  | 8 | 24
 |  |  |  | 2009-02-03 00:00:00 |  |  | C |  |  |  | 16 |  |  | 8 | 24
 |  |  |  | 2009-02-06 00:00:00 |  |  | C |  |  |  | 16 |  |  | 8 | 24
 |  |  |  | 2009-02-09 00:00:00 |  |  | C |  |  |  | 16 |  |  | 8 | 24
 |  |  |  | 2009-02-12 00:00:00 |  |  | C |  |  |  | 16 |  |  | 8 | 24
 |  |  |  | 2009-02-15 00:00:00 |  |  | C |  |  |  | 16 |  |  | 8 | 24
 |  |  |  | 2009-02-18 00:00:00 |  |  | C |  |  |  | 16 |  |  | 8 | 24
 |  |  |  | 2009-02-21 00:00:00 |  |  | C |  |  |  | 16 |  |  | 8 | 24
 |  |  |  | 2009-02-24 00:00:00 |  |  | C |  |  |  | 16 |  |  | 8 | 24
 |  |  |  | 2009-02-27 00:00:00 |  |  | C |  |  |  | 16 |  |  | 8 | 24
 |  |  |  | 2009-03-02 00:00:00 |  |  | C |  |  |  | 16 |  |  | 8 | 24
 |  |  |  | 2009-03-05 00:00:00 |  |  | C |  |  |  | 16 |  |  | 8 | 24
 |  |  |  | 2009-03-08 00:00:00 |  |  | C |  |  |  | 16 |  |  | 8 | 24
 |  |  |  | 2009-03-11 00:00:00 |  |  | C |  |  |  | 16 |  |  | 8 | 24
Spreadsheet: b2a11c1b-288a-4b9c-8755-d2c76f87c39e
Sheet: Sheet1

Locus name | 6038 | Unnamed: 2
Included in this  reconstruction | 363 | 0.06021
Total Number of Proteins | 387
Total Number of Model reactions | 374
Gene Association Mode Reactions | 318 | 0.85
[NAME] | 56 | 0.1497
Total number of [NAME] | 371
Number of Extracellular metabolites | 13
Number of intracellular Biomass Metabolites | 63
Number of Assigned citations | 396
Spreadsheet: 841233d1693438724-unique-count-filter-count-lookup-test-solution-
Sheet: 3

 |  |  |  |  | First Name | Last Name | Dept Code |  |  | First Name | Count 11
 |  |  |  |  | GLORIA | Last Name | TN-PR-PSH |  |  | GLORIA
 |  |  |  |  | PHILLIP | Last Name | TN-PR-WAR |  |  | PHILLIP
 |  |  |  |  | KEIRJAUN | Last Name | TN-PR-IDS |  |  | KEIRJAUN
 |  |  |  |  | CLAUDE | Last Name | TN-PR-IDS |  |  | CLAUDE
 |  |  |  |  | BRUNO | Last Name | TN-PR-ASS |  |  | BRUNO
 |  |  |  |  | EVELYN | Last Name | TN-PR-PSH |  |  | EVELYN
 |  |  |  |  | LASHAYA | Last Name | TN-PR-IDS |  |  | LASHAYA
 |  |  |  |  | DEVON | Last Name | TN-PR-VMI |  |  | DEVON
 |  |  |  |  | [NAME] | Last Name | TN-PR-IDS |  |  | [NAME]
 |  |  |  |  | CAMERON | Last Name | TN-PR-IDS |  |  | CAMERON
 |  |  |  |  | NATHANIEL | Last Name | TN-PR-VMI |  |  | NATHANIEL
 |  |  |  |  | LASHAYA | Last Name | TN-PR-IDS
 |  |  |  |  | CLAUDE | Last Name | TN-PR-IDS
 |  |  |  |  | GLORIA | Last Name | TN-PR-PSH
Spreadsheet: 166299d1341523891-using-mod-row-to-display-in-every-nth-cell-with-some-cells-skipped-example2
Sheet: Daily

Item #
1
Total mg's
Friday
Saturday
Sunday
Monday
Tuesday
Wednesday
Thursday
Item #
Total mg's
Friday
Saturday
Sunday
Monday
Tuesday
Wednesday
Thursday
Spreadsheet: 785743d1656672515-data-validation-based-on-multiple-criteria-dv_swiftus
Sheet: Sheet1

Product | [NAME] |  |  | Apple | [NAME] | Pear |  | Products | [NAME] |  | Apple_DV | Banana_DV | Pear_DV |  |  |  | Apple | Codes
Apple | AP1 |  |  | AP1 | BA1 | PE1 |  | [NAME] | BA1 |  |  |  |  |  |  |  | [NAME]
[NAME] | BA1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pear
Apple | AP2
Apple | AP3
[NAME] | BA2
Pear | PE1
Spreadsheet: b5a5a6ab-4a0e-4513-9a43-d7d873436bef
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
42702794 | 2014-08-13 05:54:01 | ALLIES | 0 | 3 | 7 | 694159 | dugoutdoug | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
42750193 | 2014-08-16 19:04:02 | ALLIES | 1 | 6 | 4 | 1448307 | K-ami-case | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
42750525 | 2014-08-16 19:45:43 | ALLIES | 1 | 7 | 3 | 206845 | [NAME] | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
42758196 | 2014-08-17 08:03:47 | ALLIES | 1 | 6 | 3 | 943675 | [NAME] | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
42758411 | 2014-08-17 08:22:44 | AXIS | 1 | 6 | 1 | 943675 | [NAME] | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
42758563 | 2014-08-17 08:44:51 | AXIS | 1 | 6 | 5 | 1620997 | player1620997 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
42771301 | 2014-08-18 04:08:49 | ALLIES | 1 | 4 | 2 | 1607905 | kdubbs56 | 6161 | western | 1944-06-10 | 1944-06-10 | Mont Mouchet | Mont Mouchet
42771593 | 2014-08-18 04:30:35 | ALLIES | 1 | 6 | 3 | 1607905 | kdubbs56 | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
42787264 | 2014-08-19 07:01:34 | AXIS | 1 | 6 | 4 | 1622265 | player1622265 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
42787409 | 2014-08-19 07:12:03 | ALLIES | 1 | 6 | 0 | 1622265 | player1622265 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
42801351 | 2014-08-20 07:46:31 | ALLIES | 1 | 6 | 4 | 1537209 | bynumbill | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
42801616 | 2014-08-20 08:13:45 | AXIS | 1 | 6 | 3 | 1537209 | bynumbill | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
Spreadsheet: 36384d1234272728-pulling-data-based-on-date-copy-of-test2
Sheet: Data

 |  | Date | Type | Value
 |  | 2009-02-12 00:00:00 | Cat | 2
 |  | 2009-02-01 00:00:00 | [NAME] | 1
 |  | 2009-01-15 00:00:00 | Dog | 2
 |  | 2009-01-14 00:00:00 | Dog | 5
 |  | 2009-01-11 00:00:00 | [NAME] | 8
 |  | 2009-01-05 00:00:00 | Dog | 9
 |  | 2009-01-03 00:00:00 | Cat | 3
 |  | 2009-01-01 00:00:00 | Dog | 2
Spreadsheet: 878677d1725917265-user-must-choose-from-a-dropdown-when-they-choose-certain-information-in-another-cell-fy25-cmpa-financial-tracker-test
Sheet: CMPA

Status | CMPA Number | Submitter | Date | USER 1 | USER 2 | Department | Fund | Source Code | Function | Purpose | Project | Activity | Account Code | Purchased For [NAME] | Commodity Code | Vendor | Amount | Form Type | PS ID | OER | Description | GL Reconciliation Comments | PS Reconciliation Comments | Purchase Order # | Invoice # | Voucher # | PS Reference # | Payment Date | PS Reconcile Status | Supporting Docs | Supporting Docs2
 | CMP-25-0001 |  |  | CPADM |  |  |  |  |  |  |  |  |  | CPADM
 | CMP-25-0002 |  |  | CPADM |  |  |  |  |  |  |  |  |  | DGORG
 | CMP-25-0003 |  |  | CPADM |  |  |  |  |  |  |  |  |  | DGTAL
 | CMP-25-0004 |  |  | MKTNG
 | CMP-25-0005 |  |  | COMED
 | CMP-25-0006 |  |  | CPADM |  |  |  |  |  |  |  |  |  | COMED
 | CMP-25-0007
 | CMP-25-0008
 | CMP-25-0009
 | CMP-25-0010
 | CMP-25-0011
 | CMP-25-0012
 | CMP-25-0013
 | CMP-25-0014
 | CMP-25-0015
 | CMP-25-0016
 | CMP-25-0017
 | CMP-25-0018
 | CMP-25-0019
 | CMP-25-0020
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
Spreadsheet: 865177d1712230112-need-to-change-the-sheet-name-in-a-transpose-formula-for-the-entire-table-excel-help-32-aligw
Sheet: transpose

M/Y | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00
Toys |  | 191 | 152 | 38 | 7 | 164
Bread | 47 | 49 | 123 | 14 | 190 | 43
Milk | 64 | 94 | 164 | 191 | 104 | 21
 |  | I need to change the transpose formula for the entire table, using the sheet "original 2" instead of "original 1"
Spreadsheet: 861682d1709559897-convert-inconsistent-hh-mm-ss-formatting-to-use-00-00-00-showtime
Sheet: Planilha1

1h:0m
3h:54m
2h:50m
9h:57m
3h:50m
3h:4m
1h:50m
28m:9s
27m:48s
4h:0m
0s
N/A
10m:9s
51m:16s
1h:45m
Spreadsheet: 190117d1351530905-how-can-i-automatically-get-information-from-one-worksheet-to-another-by-using-idenitifier-assignment-3
Sheet: Sheet2

[NAME]
Computer Equipment | Cost
Dell XPS one 27 touch-screen monitor | 1300
keyboard | 30.75
[NAME] | 40.99
Total
Dads laptop
HP Envy 14 Spectre | 828
[NAME]
Dell Inspiron 17.3" | 720.75
University Guys laptop
Samsung series 9  15" | 750
High school kid
Dell Inspiron 14z Ultrabook | 699.99
[NAME] kid
Gateway NV57H19H | 629.9
Total | 3628.64
Subtotal (Computer Equipment + Cost of laptops)
Networking Equipment
Western Digital My Net 900 | 170
Net gear Rangemax Dual band  Wireless Modem and Router | 129.2
Total
Entertainment Equipment
Dell -AY40 Multimedia Speaker [NAME] | 70
Beats Solo HD Headphones | 200
Sub total
Miscellaneous material (for both options)
McAfee Security Center, I year subscription | 80
Logitech touch mouse (for laptops) | 60
2013 Norton 360 (1 year protection) (Windows 8/7/Vista/XP) | 80
Sub total | 220
Overall total | 5789.35
Spreadsheet: 6e86f28a-1e67-43b4-8723-7fbe9c9f1bb6
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
WDKM | Test | WDKM | Wilson Disease Known Mutation, ATP7B DNA Sequencing | Wilson Disease Known Mutation | Polymerase chain reaction (PCR)/DNA sequencing are utilized to test for the presence of a specific mutation previously identified in an affected family member. (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | VACUTAINER: VAC |  |  | 3 | mL | This test can only be performed if a mutation has previously been identified in a family member of this individual.   [NAME] must arrive within 96 hours of collection.   [NAME] blood Container/Tube: Preferred: Lavender top (EDTA) or yellow top (ACD) Acceptable: Any anticoagulant [NAME]: 3 mL Collection Instructions: 1. Invert several times to mix blood. 2. Send specimen in original tube. Specimen Stability Information: Ambient (preferred)/Refrigerated Forms:		 1. Molecular Genetics-Congenital Inherited Diseases Patient Information Sheet (Supply T521) in Special Instructions 2. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions.	 3. If not ordering electronically, submit a Molecular Genetics Request Form (Supply T245) with the specimen. | Blood: 1 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Friday; 10 a.m. | 10 days | 16 days | 1 | 81403 |  |  |  |  | Rochester
WDKM | [NAME] | VARIES | Varies |  |  |  | See instructions
WDKM | Result | 22696 | [NAME] | [NAME] | Alphanumeric
WDKM | Result | 22697 | [NAME] | [NAME] | Alphanumeric
WDKM | Result | 22698 | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
WDKM | Result | 22699 | Order Date | Order Date | Alphanumeric
WDKM | Result | 22700 | Reason For Referral | Reason For Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1 | Reason for referral:Find:Pt:^Patient:Nar:
WDKM | Result | 22701 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49549-9
WDKM | Result | 22702 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
WDKM | Result | 22703 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69047-9 | Service comment 01:Imp:Pt:[NAME]:Nom:
WDKM | Result | 22704 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
WDKM | Result | 22705 | Reviewed By: | Reviewed By: | Alphanumeric
WDKM | Result | 22706 | Release Date | Release Date | Alphanumeric
Spreadsheet: 856316d1705593849-sum-a-range-restricted-by-date-values-example-workbook
Sheet: Sheet1

Employee RC # | [NAME] | Bridge Beginning Date | Current Bridge Beginning Date | Current Bridge Ending Date | Bridge Ending Date
112233 | [NAME] | 2019-12-01 00:00:00 | 2022-12-01 00:00:00 | 2023-11-30 00:00:00 | 2024-11-30 00:00:00
113355 | Daffy Duck | 2018-12-01 00:00:00 | 2021-07-01 00:00:00 | 2024-06-30 00:00:00 | 2024-06-30 00:00:00
223344 | Porky Pig | 2021-05-01 00:00:00 | 2023-05-01 00:00:00 | 2025-04-30 00:00:00 | 2025-04-30 00:00:00
224466 | Elmer Fudd | 2020-12-01 00:00:00 | 2022-12-01 00:00:00 | 2023-11-30 00:00:00 | 2024-11-30 00:00:00
Spreadsheet: 462810d1464196492-multiple-criteria-vlookup-with-index-and-match-of-idxmatch
Sheet: Sheet1

 |  |  |  |  | ID |  | Postal | Lookup |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Postal | ID | Bag |  |  | aggregate
 |  |  |  |  | 1572 |  | 760175 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 670236 | 1711 | 16 |  |  |  |  | ,=IFERROR(LOOKUP(2,1/(Y$2:Y$555=H2)/(Z$2:Z$555=F2),AA$2:AA$555),"")
 |  |  |  |  | 1680 |  | 760175 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 640458 | 1913 | 18 |  |  |  |  | ,=IFERROR(AGGREGATE(15,6,AA$2:AA$555/(Y$2:Y$555=H2)/(Z$2:Z$555=F2),1),"")
 |  |  |  |  | 1562 |  | 750469 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 640518 | 1750 | 16
 |  |  |  |  | xxx |  | 750422 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 649848 | 1801 | 15
 |  |  |  |  | 1908 |  | 791440 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 640977 | 1813 | 20
 |  |  |  |  | yyy |  | 568402 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 641989 | 1977 | 16
 |  |  |  |  | 1843 |  | 550529 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 120118 | 1587 | 6
 |  |  |  |  | 1812 |  | 530101 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 228192 | 1875 | 11
 |  |  |  |  | 1950 |  | 530952 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 180008 | 1751 | 32
 |  |  |  |  | zz |  | 543180 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 289850 | 1854 | 23
 |  |  |  |  | 1775 |  | 824617 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 760175 | 1572 | 14
 |  |  |  |  | 1737 |  | 510637 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 750469 | 1562 | 22
 |  |  |  |  | 1717 |  | 524498 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 760125 | 1680 | 14
 |  |  |  |  | 1919 |  | 522524 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 791440 | 1908 | 27
 |  |  |  |  | 1876 |  | 521160 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 824617 | 1775 | 13
 |  |  |  |  | 1874 |  | 460412 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 330022 | 1558 | 24
 |  |  |  |  | new |  | 460412 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 310470 | 1871 | 20
 |  |  |  |  | what if |  | 460412 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 530101 | 1812 | 23
Spreadsheet: 600094d1543461222-enter-data-based-on-2-different-cells-2-columns-different-sheets-grading-excel-form
Sheet: T3 Directing

First name | Surname | ID number | Institution | Department | Email address | Attendance: Attendance | Assignment: Professionalism | Assignment: [NAME]: 5 Concepts | Assignment: [NAME]: Casting Breakdown &amp; [NAME] | Assignment: [NAME]: Director Vision Statement | Assignment:  [NAME]: 15 Step [NAME] | Course total
[NAME] ([NAME]) | [NAME] |  |  |  | [EMAIL] | 10 | 18 | 9 | 18 | 19 | 20 | 93.75
Qiran ([NAME]) | [NAME] |  |  |  | [EMAIL] | 7.27 | 16 | 8 | 15 | 8 | 12 | 65.97
Muxin | [NAME] |  |  |  | [EMAIL] | 6.82 | 15 | 7 | 16 | 16 | 0 | 66.02
[NAME] ([NAME]) | [NAME] |  |  |  | [EMAIL] | 6.82 | 18 | 9 | 16 | 16 | 18 | 83.52
Yiming ([NAME]) | [NAME] |  |  |  | [EMAIL] | 5 | 9 | 0 | 16 | 0 | 0 | 27.5
[NAME] ([NAME]) | Fang |  |  |  | [EMAIL] | 8.64 | 17 | 7 | 16 | 15 | 18 | 80.8
Qianyun (Fay) | Fang |  |  |  | [EMAIL] | 10 | 19 | 9 | 18 | 18 | 20 | 93.75
Yichao | Fu |  |  |  | [EMAIL] | 9.09 | 18 | 8 | 17 | 17 | 10 | 81.99
Junjie (Riol) | He |  |  |  | [EMAIL] | 9.09 | 18 | 8 | 15 | 18 | 17 | 86.36
Jiaqing (Agnes) | Kang |  |  |  | [EMAIL] | 10 | 19 | 8 | 17 | 17 | 20 | 90.63
Yuetong (Isabel) | [NAME] |  |  |  | [EMAIL] | 9.09 | 18 | 9 | 15 | 18 | 18 | 88.24
[NAME]) | [NAME] |  |  |  | [NAME] | 7.27 | 18 | 6 | 12 | 12 | 11 | 68.47
[NAME] (Klader) | [NAME] |  |  |  | [EMAIL] | 9.09 | 18 | 10 | 17 | 18 | 18 | 90.74
Ruimin (Vic) | [NAME] |  |  |  | [EMAIL] | 7.73 | 15 | 8 | 16 | 15 | 0 | 67.16
[NAME]) | [NAME] |  |  |  | [EMAIL] | 7.73 | 16 | 0 | 15 | 14 | 17 | 67.16
[NAME]Seven ） | Qi |  |  |  | [EMAIL] | 8.64 | 10 | 8 | 14 | 0 | 0 | 42.05
Junqi (Voang) | [NAME] |  |  |  | [EMAIL] | 8.64 | 16 | 9 | 14 | 0 | 16 | 60.8
[NAME]） | Xiao |  |  |  | [EMAIL] | 7.73 | 9 | 8 | 14 | 0 | 0 | 39.66
[NAME] (Leo) | [NAME] |  |  |  | [EMAIL] | 6.36 | 11 | 8 | 17 | 15 | 0 | 61.08
Chenyi (Freddie) | Zhang |  |  |  | [EMAIL] | 9.09 | 15 | 8 | 17 | 0 | 0 | 50.74
Linfeng (Wayne) | Zhang |  |  |  | [EMAIL] | 10 | 19 | 8 | 17 | 18 | 19 | 91.25
[NAME] (Vlad) | [NAME] |  |  |  | [EMAIL] | 10 | 19 | 8 | 16 | 18 | 18 | 90
Xinwei (Will) | [NAME] |  |  |  | [EMAIL] | 10 | 19 | 8 | 15 | 17 | 20 | 89.38
Hui ([NAME]) | Zhu |  |  |  | [EMAIL] | 5.91 | 17 | 7 | 16 | 16 | 16 | 77.39
Spreadsheet: darrell_schoolcraft__7299__imball0112
Sheet: Duke

Duke Energy Field Services
Contract  24268
2001-11-30 00:00:00 |  | 1497337.92
 |  |  |  |  |  |  |  | Duke Energy Trading and Marketing, L.L.C.
2001-12-10 00:00:00 |  |  |  |  |  |  |  | OBA Balances as of 11/30/01
50895
60874 | 1205
78169 |  |  |  |  |  |  |  | Contract# | Amount | Description/Points
500235 |  |  |  |  |  |  |  | 24361 |  | Pyote points - fuel is still being delivered causing amount to grow each month
500248 |  |  |  |  |  |  |  | 24693 | 275313.72 | [NAME] plant - hasn't had activity since 12/2000
500251 |  |  |  |  |  |  |  | 21665 | 73449.16 | no activity since 11/98
500254 |  |  |  |  |  |  |  | 22664 | 23612.35 | Grand Valley plant - last activity 4/96
500255
500262
500267
Duke Energy Trading and Marketing
Contract  24693
2001-11-30 00:00:00 |  | 275313.72
2001-12-10 00:00:00
9164
9167
Duke Energy Trading and Marketing |  |  |  | CBS Volume | 24268 | 24693 | 24361
Contract  24361 |  |  |  |  | 363548 | 117857 | 173271
2001-11-30 00:00:00 |  | 811403.49
2001-12-08 00:00:00
500241
500391 | 1815
500392 | 349
Duke Energy Trading and Marketing
21665 | oba | 73445.08 | POI 9109 Mobil Waha Plant |  |  |  | 21665 | 36401
22664 | oba | 23612.35 | POI 59918 Grand Valley Plant |  |  |  | 22664 | 18932
Spreadsheet: 549306d1511577882-copy-cell-content-depending-on-another-cell-value-example
Sheet: Sheet1

Date | Place | Amount | Code | Prima | Burning | Eventide | Winter | Afterglow | Sunset | Red | Marble
2017-01-01 00:00:00 | Wyoming | 876 | Prima | 876
2017-01-02 00:00:00 | Montana | 234 | Eventide |  |  | 234
2017-01-03 00:00:00 | New York | 456 | Red |  |  |  |  |  |  | 456
2017-01-04 00:00:00 | California | 974 | Marble
2017-01-05 00:00:00 | New Jersey | 356 | Afterglow
2017-01-06 00:00:00 | Ohio | 864 | Afterglow
2017-01-07 00:00:00 | Arizona | 245 | Red
2017-01-08 00:00:00 | Hawaii | 645 | Winter
2017-01-09 00:00:00 | Michigan | 456 | Winter
2017-01-10 00:00:00 | Florida | 862 | Eventide
2017-01-11 00:00:00 | South Carolina | 563 | Burning
2017-01-12 00:00:00 | Idaho | 450 | Prima
2017-01-13 00:00:00 | Iowa | 832 | Prima
2017-01-14 00:00:00 | Kansas | 468 | Sunset
2017-01-15 00:00:00 | Missouri | 184 | Marble
2017-01-16 00:00:00 | Maine | 238 | Red
2017-01-17 00:00:00 | Massachusettes | 234 | Prima
2017-01-18 00:00:00 | Vermont | 123 | Prima
2017-01-19 00:00:00 | North Dakota | 867 | Marble
2017-01-20 00:00:00 | Virginia | 483 | Sunset
2017-01-21 00:00:00 | Kentucky | 289 | Afterglow
Spreadsheet: 765680d1643484559-spill-range-formula-problem-spill-range-problem
Sheet: Sheet1

 | ID: | A |  |  |  |  |  |  |  | From: | 2020-01-01 00:00:00 | To: | 2022-01-01 00:00:00
 | RAW HISTORIC DATA (A) |  |  |  |  | CHANGES OVE TIME - TABLE SOLUTION (B) |  |  |  | CHANGES OVE TIME - SPILLED RANGE ©
 | DATE | ID | ROW # | NOTE |  | DATE | ROW MATCH | NOTE |  | DATE | CALCULATE | ROW MATCH | NOTE | DESIRED SOLUTION |  | ID VALIDATION
 | 2019-09-06 00:00:00 | A | 1 | [NAME] |  | 1901-01-01 00:00:00
 | 2021-07-05 00:00:00 | A | 2 | ipsum |  | 2021-02-01 00:00:00 |  |  |  | 2020-02-01 00:00:00 | True |  |  | #N/A |  | B
 | 2021-08-09 00:00:00 | A | 3 | dolor |  | 2021-03-01 00:00:00 |  |  |  | 2020-03-01 00:00:00 | True |  |  | #N/A |  | C
 | 2022-08-04 00:00:00 | A | 4 | sit |  | 2021-04-01 00:00:00 |  |  |  | 2020-04-01 00:00:00 | True |  |  | #N/A |  | D
 | 2019-05-05 00:00:00 | B | 5 | amet |  | 2021-05-01 00:00:00 |  |  |  | 2020-05-01 00:00:00 | True |  |  | #N/A
 | 2020-01-01 00:00:00 | B | 6 | consectetur |  | 2021-06-01 00:00:00 |  |  |  | 2020-06-01 00:00:00 | True |  |  | #N/A
 | 2022-01-18 00:00:00 | B | 7 | adipiscing |  | 2021-07-01 00:00:00 |  |  |  | 2020-07-01 00:00:00 | True |  |  | #N/A
 | 2022-08-04 00:00:00 | B | 8 | elit |  | 2021-08-01 00:00:00 |  |  |  | 2020-08-01 00:00:00 | True |  |  | #N/A
 | 2021-11-11 00:00:00 | C | 9 | sed |  | 2021-09-01 00:00:00 |  |  |  | 2020-09-01 00:00:00 | True |  |  | #N/A
 | 1900-01-01 00:00:00 | D | 10 | do |  | 2021-10-01 00:00:00 |  |  |  | 2020-10-01 00:00:00 | True |  |  | #N/A
 | 2021-01-02 00:00:00 | D | 11 | eiusmod |  | 2021-11-01 00:00:00 |  |  |  | 2020-11-01 00:00:00 | True |  |  | #N/A
 | 2021-12-12 00:00:00 | D | 12 | tempor |  | 2021-12-01 00:00:00 |  |  |  | 2020-12-01 00:00:00 | True |  |  | #N/A
 | 2022-02-08 00:00:00 | D | 13 | incididunt |  | 2022-01-01 00:00:00 |  |  |  | 2021-01-01 00:00:00 | True |  |  | #N/A
 |  |  |  |  |  | 2022-02-01 00:00:00 |  |  |  | 2021-02-01 00:00:00 | True |  |  | #N/A
 |  |  |  |  |  | 2022-03-01 00:00:00 |  |  |  | 2021-03-01 00:00:00 | True |  |  | #N/A
 |  |  |  |  |  | 2022-04-01 00:00:00 |  |  |  | 2021-04-01 00:00:00 | True |  |  | #N/A
 |  |  |  |  |  | 2022-05-01 00:00:00 |  |  |  | 2021-05-01 00:00:00 | True |  |  | #N/A
 |  |  |  |  |  | 2022-06-01 00:00:00 |  |  |  | 2021-06-01 00:00:00 | True |  |  | #N/A
 |  |  |  |  |  | 2022-07-01 00:00:00 |  |  |  | 2021-07-01 00:00:00 | True |  |  | #N/A
 |  |  |  |  |  | 2022-08-01 00:00:00 |  |  |  | 2021-08-01 00:00:00 | True |  |  | #N/A
 |  |  |  |  |  | 2022-09-01 00:00:00 |  |  |  | 2021-09-01 00:00:00 | True |  |  | #N/A
 |  |  |  |  |  | 2022-10-01 00:00:00 |  |  |  | 2021-10-01 00:00:00 | True |  |  | #N/A
 |  |  |  |  |  | 2022-11-01 00:00:00 |  |  |  | 2021-11-01 00:00:00 | True |  |  | #N/A
 |  |  |  |  |  | 2022-12-01 00:00:00 |  |  |  | 2021-12-01 00:00:00 | True |  |  | #N/A
 |  |  |  |  |  |  |  |  |  | 2022-01-01 00:00:00 | True |  |  | #N/A
Spreadsheet: 887189d1737404612-pulling-information-formulas-receiving-book-1-
Sheet: Front Sheet

Totals
Product | UPC | Weight
 | 90071A
 | 90071J
 | 80071
 | 80071M
 | 20071
 | 1422SS
 | 1422SA
Spreadsheet: 799832d1665337598-if-match-and-max-example
Sheet: Sheet1

VENDOR PO NUMBER | ESTIMATED DELIVERY DATE | LATEST DATE
[PHONE] | TBC | TBC
7100416441 | TBC | TBC
[PHONE] | 2023-02-20 00:00:00 | 2023-02-20 00:00:00
7100382043 | 2023-02-20 00:00:00 | 2023-02-20 00:00:00
7100414294 | 2023-04-14 00:00:00 | 2023-04-14 00:00:00
7100451458 | TBC | 2023-05-15 00:00:00
7100451458 | TBC | 2023-05-15 00:00:00
[PHONE] | 2023-03-19 00:00:00 | 2023-05-15 00:00:00
7100451458 | TBC | 2023-05-15 00:00:00
7100451458 | 2023-04-10 00:00:00 | 2023-05-15 00:00:00
7100451458 | TBC | 2023-05-15 00:00:00
7100451458 | TBC | 2023-05-15 00:00:00
7100451458 | TBC | 2023-05-15 00:00:00
7100451458 | 2023-05-15 00:00:00 | 2023-05-15 00:00:00
7100451458 | TBC | 2023-05-15 00:00:00
7100451458 | TBC | 2023-05-15 00:00:00