tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kate_symes__18509__Palo
Sheet: DJ Palo Verde Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-01-25 00:00:00 |  | 231.78 | 13440 | 144.28 | 3040
 | 2001-01-24 00:00:00 |  | 222.84 | 13360 | 131.11 | 2880 | 136.45 | 2624 | 93.82 | 933
 | 2001-01-23 00:00:00 |  | 254.26 | 9200 | 143.99 | 4256 | 148.73 | 2079 | 105.08 | 1209
 | 2001-01-22 00:00:00 |  | 324.8 | 9200 | 164 | 2000 | 172.56 | 2925 | 139.79 | 2097
 | 2001-01-21 00:00:00 |  | 177.5 | 2400 | 124.55 | 2200 | 152.69 | 3900 | 141.53 | 2132 |  | 168.33 | 1800
 | 2001-01-20 00:00:00 |  | 452.36 | 4400 | 226.5 | 2000 | 232.31 | 2573 | 148.33 | 1359
 | 2001-01-19 00:00:00 |  | 452.36 | 4400 | 226.5 | 2000 | 273.28 | 6682 | 128.74 | 2093
 | 2001-01-18 00:00:00 |  | 379.51 | 8960 | 214.86 | 2800 | 279.1 | 6115 | 157.96 | 2108
 | 2001-01-17 00:00:00 |  | 220.81 | 12080 | 122 | 3800 | 232.88 | 4018 | 186.65 | 824
 | 2001-01-16 00:00:00 |  | 173.04 | 18112 | 105.14 | 4120 | 231.33 | 632 | 127.03 | 579
 | 2001-01-15 00:00:00 |  | 173.04 | 18112 | 104.82 | 3960 | 169.46 | 718 | 107.24 | 593
 | 2001-01-14 00:00:00 |  | 152.5 | 0 | 103 | 0 | 130.52 | 713 | 116.11 | 446 |  | 107.23 | 13560
 | 2001-01-13 00:00:00 |  | 152.77 | 14160 | 107.23 | 4520 | 138.98 | 1547 | 120.82 | 1165
 | 2001-01-12 00:00:00 |  | 159.03 | 18032 | 90.92 | 3800 | 160.71 | 727 | 98 | 450
 | 2001-01-11 00:00:00 |  | 160.31 | 19472 | 90.92 | 3800 | 153.64 | 1669 | 94.86 | 1106
 | 2001-01-10 00:00:00 |  | 143.16 | 18208 | 84.37 | 3352 | 129.46 | 2981 | 93.14 | 1118
 | 2001-01-09 00:00:00 |  | 132.19 | 14400 | 75.61 | 4552 | 145.14 | 850 | 87.82 | 1753
 | 2001-01-08 00:00:00 |  | 127.4 | 15728 | 68.15 | 5768 | 140.11 | 1652 | 87.68 | 460
 | 2001-01-07 00:00:00 |  | 121.67 | 2400 | 65 | 800 | 84.12 | 1047 | 58.43 | 682 |  | 69.34 | 16944
 | 2001-01-06 00:00:00 |  | 121.11 | 22672 | 71.97 | 5784 | 90.26 | 442 | 59.63 | 622
 | 2001-01-05 00:00:00 |  | 121.35 | 23072 | 72.24 | 5984 | 105.21 | 932 | 98.02 | 734
 | 2001-01-04 00:00:00 |  | 131.61 | 14064 | 79.75 | 6272 | 120.52 | 512 | 71.21 | 514
 | 2001-01-03 00:00:00 |  | 143.06 | 13168 | 85.45 | 3584 | 129.29 | 613 | 75.14 | 791
 | 2001-01-02 00:00:00 |  | 149.82 | 10992 | 93.38 | 2840 | 124.91 | 1327 | 56.75 | 526
 | 2001-01-01 00:00:00 |  | 145 | 0 | 100 | 0 | 70.68 | 2284 | 50.55 | 1025 |  | 93.52 | 7320
 | 2000-12-31 00:00:00 |  | 94.03 | 2480 | 88.53 | 680 | 55.11 | 1961 | 56.69 | 816 |  | 89.07 | 1992
 | 2000-12-30 00:00:00 |  | 121.88 | 6160 | 88.79 | 1344 | 90.2 | 1203 | 69.44 | 897
 | 2000-12-29 00:00:00 |  | 169.36 | 5600 | 86.08 | 1088 | 146.94 | 2282 | 91.56 | 880
 | 2000-12-28 00:00:00 |  | 169.36 | 5600 | 86.08 | 1088 | 138.35 | 2041 | 123.17 | 293
 | 2000-12-27 00:00:00 |  | 232 | 10048 | 123.85 | 728 | 128.78 | 2370 | 96.27 | 690
 | 2000-12-26 00:00:00 |  | 250.55 | 12960 | 173.75 | 800 | 124.75 | 1488 | 90.47 | 590
Spreadsheet: 85fd1d7b-1294-4693-a87b-642984d8ab72
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
PID | Test | PID | I.D. Label | I.D. Label |  |  |  |  |  |  |  |  | Specimens Other Than: Anticoagulants Other Than: Hemolysis: Thawing: Lipemia: |  |  |  |  |  |  |  |  |  |  | Rochester
Spreadsheet: 191068d1351888644-collum-to-controll-filter-b1-controlls-the-filter
Sheet: b1 controlls the filter

floor to show | 2
data
 | floor | name | telephone
 | 1 | bobb | 11
 | 1 | george | 12
 | 1 | [NAME] | 13
 | 2 | milo | 21
 | 2 | [NAME] | 22
 | 2 | [NAME] | 23
 | 2 | [NAME] | 24
 | 3 | mark | 31
 | 3 | sebastian | 32
 | 3 | [NAME] | 33
 | 4 | tifa | 41
 | 4 | jasmin | 42
result
 | floor | name | telephone
 | 2 | milo | 21
 | 2 | [NAME] | 22
 | 2 | [NAME] | 23
 | 2 | [NAME] | 24
Spreadsheet: b32ec724-cdff-442b-91ff-81da64f4983d
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
2759 | 15598 | Germaine | Roullet | ITA | 93 | 00:35:11 | 00:00:50 | 01:01:33 | 00:01:53 | 00:38:33 | 1 | 02:18:00
2759 | 15487 | Yuliya | Barabash | RUS | 91 | 00:33:24 | 00:00:56 | 01:06:31 | 00:01:11 | 00:39:13 | 2 | 02:21:15
2759 | 15827 | [NAME] | [NAME] | SVK | 92 | 00:39:45 | 00:00:59 | 01:12:04 | 00:02:37 | 00:43:44 | 3 | 02:39:09
Spreadsheet: 098da5cf-ec20-4086-bb78-c22aa8000807
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
EVROL | Test | EVROL | Everolimus, Blood | Everolimus, B | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) | Lavendar-top (EDTA) Tube: EDTA (<1 month old infant) |  |  | 3 | mL | Container/Tube: Lavender top (EDTA) [NAME]: 3 mL Collection Instructions: 1. Draw blood immediately before next scheduled dose. 2. Do not centrifuge. 3. Send specimen in original tube. Additional Information: Therapeutic range applies to trough specimens drawn immediately prior to a.m. dose. | 1mL | Hemolysis	Mild OK; Gross OK Thawing	Warm >72 hours reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	NA | 3-8 ng/mL | Monday through Sunday; 1 p.m. | Same day/1 day | 2 days | 1 | 80299 |  |  |  |  | Rochester
EVROL | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Refrigerated | 14 days
EVROL | Result | 35146 | Everolimus, B | Everolimus, B | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 50544-6 | Everolimus:MCnc:Pt:[NAME]:Qn:
Spreadsheet: 132562d1323813706-i-need-help-duplicating-selected-columns-from-a-master-job-sheet-to-a-new-sheet-bid-schedule-december
Sheet: DECEMBER FOLLOW-UP

 |  | Coughlin
 |  | Company
Bid Date | Source | Contact
2011-12-01 00:00:00
2011-12-01 00:00:00
2011-12-01 00:00:00
2011-12-01 00:00:00
2011-12-01 00:00:00
2011-12-02 00:00:00
2011-12-05 00:00:00
2011-12-06 00:00:00
2011-12-06 00:00:00
2011-12-06 00:00:00
2011-12-06 00:00:00
2011-12-06 00:00:00
2011-12-07 00:00:00
2011-12-07 00:00:00
2011-12-08 00:00:00
2011-12-08 00:00:00
2011-12-08 00:00:00
2011-12-08 00:00:00
2011-12-09 00:00:00
2011-12-09 00:00:00
2011-12-12 00:00:00
2011-12-12 00:00:00
2011-12-13 00:00:00
2011-12-13 00:00:00
2011-12-14 00:00:00
2011-12-14 00:00:00
2011-12-15 00:00:00
2011-12-15 00:00:00
2011-12-16 00:00:00
2011-12-16 00:00:00
2011-12-19 00:00:00
2011-12-19 00:00:00
2011-12-20 00:00:00
2011-12-20 00:00:00
2011-12-21 00:00:00
2011-12-21 00:00:00
2011-12-22 00:00:00
2011-12-22 00:00:00
2011-12-23 00:00:00
2011-12-23 00:00:00
2011-12-26 00:00:00
2011-12-26 00:00:00
2011-12-27 00:00:00
2011-12-27 00:00:00
2011-12-27 00:00:00
2011-12-27 00:00:00
2011-12-29 00:00:00
2011-12-29 00:00:00
2011-12-30 00:00:00
2011-12-30 00:00:00
Spreadsheet: b23df6fb-cab5-4ca2-8490-cdc1b44a3d0e
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
FINS | Test | FINS | Insulin, Free, Serum | Free Insulin, S | Automated Chemiluminescent Immunoenzymatic Assay System | Plain, Red-Top Tube: Red |  |  | 1 | mL | Collection Container/Tube:  Preferred: Red top Acceptable: Serum gel Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions: 1. Fasting. Non-fasting specimens are accepted for special studies. 2. Label specimens with corresponding draw time. Additional Information: If multiple specimens are drawn, send separate order for each specimen. | 0.4 mL | Hemolysis	Mild reject; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	NA | 1.4-14 micro IU/mL | Monday through Saturday; Continuously | 1 day | 3 days | 1 | 83527 |  |  |  |  | Rochester
FINS | [NAME] | SERUM | Serum |  |  |  | Frozen | 14 days
FINS | Result | FINS | Free Insulin, S | Free Insulin, S | Numeric |  |  |  |  | micro IU/mL |  |  |  |  |  |  |  |  |  | 6901-3 | Insulin.free:ACnc:Pt:Ser/Plas:Qn:
Spreadsheet: 135430d1326053592-sum-across-worksheets-mtg-cards
Sheet: Arabian Nights

Name | Rarity | # Owned | Total # Owned
[NAME] | U
Aladdin | R
Aladdin's Lamp | R
Aladdin's Ring | R
[NAME] | U
[NAME] from Cairo | R
Army of Allah | C
Bazaar of Baghdad | U
[NAME] | C
Bottle of Suleiman | R
Brass Man | U
Camel | C
City in a Bottle | R
City of Brass | U
Cuombajj Witches | C
Cyclone | U
Dancing Scimitar | R
Dandân | C
Desert | C
[NAME] | C
[NAME] | U
Diamond Valley | U
Drop of Honey | R
Ebony Horse | R
Elephant Graveyard | R
El-Hajjâj | R
Erg Raiders | C
[NAME] | R
Eye for an Eye | U
Fishliver Oil | C
Flying Carpet | U
Flying Men | C
[NAME] | C
[NAME] | C
Guardian Beast | R
[NAME] | C
[NAME] | C
Ifh-Bíff Efreet | R
Island Fish Jasconius | R
Island of Wak-Wak | R
Jandor's Ring | R
Jandor's Saddlebags | R
[NAME] | U
Jihad | R
Junún Efreet | R
[NAME] | R
[NAME] | U
King [NAME] | R
[NAME] | C
Library of [NAME] | U
Magnetic Mountain | U
Merchant Ship | U
Metamorphosis | C
Mijae Djinn | R
Moorish Cavalry | C
Mountain | C
[NAME] | C
Oasis | U
Old Man of the Sea | R
Oubliette | C
Piety | C
Pyramids | R
[NAME] | R
Ring of Ma'rûf | R
Rukh Egg | C
Sandals of Abdallah | U
Sandstorm | C
[NAME] | R
Serendib Efreet | R
Shahrazad | R
Sindbad | U
Singing Tree | R
Sorceress Queen | U
Stone-Throwing Devils | C
Unstable Mutation | C
War Elephant | C
[NAME] | C
[NAME] | R
Spreadsheet: daren_farmer__6007__EI330Areveff061500
Sheet: Sheet1

To:   [NAME]          (Enron)
From: [NAME] ([NAME])
Date:  6/19/00
Subject:  Revised Availabilities Effective 6/15/00 - 6/16/00
Effective Date | CTP NAME | Gross Vol. (MMBtu/d) | PVR % | PVR Volume | Avail. After PVR (MMBtu/d) | DBQ | Excess
2000-06-15 00:00:00 | EI 330 A | 2316 | 0.1634 |  |  | 1587
1st of month DBQ = 1587/d
Spreadsheet: 852951d1702924779-solved-validate-month-based-on-contract-dates-and-calculate-correct-number-of-weeks-on-date-issue-new
Sheet: Sheet2

Month | Month/year | Start month | Number of weeks per month
1 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00
2 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00
3 | Mrt/24 | 2024-03-01 00:00:00
4 | 2024-04-01 00:00:00 | 2024-04-01 00:00:00
5 | 2024-05-01 00:00:00 | 2024-05-01 00:00:00
6 | 2024-06-01 00:00:00 | 2024-06-01 00:00:00
7 | 2024-07-01 00:00:00 | 2024-07-01 00:00:00
8 | 2024-08-01 00:00:00 | 2024-08-01 00:00:00
9 | 2024-09-01 00:00:00 | 2024-09-01 00:00:00
10 | 2024-10-01 00:00:00 | 2024-10-01 00:00:00
11 | 2024-11-01 00:00:00 | 2024-11-01 00:00:00
12 | 2024-12-01 00:00:00 | 2024-12-01 00:00:00
Spreadsheet: 81125d1281383222-finding-matching-items-example1
Sheet: Table A

AB | 5678
AC | 6784
AD | 1235
AE | 9875
AF | 1234
AG | 22345
AH | 4567
AI | 9963
AJ | 4356
AK | 5567
AL | 22345
AM | 5982
AN | 2345
AO | 1245
AP | 13356
AQ | 56897
AR | 5536
AS | 12223
AT | 125
AU | 3345
Spreadsheet: 182455d1348494902-converting-data-to-time-format-data-conversion-sample-sheet
Sheet: sample

Date A | Time A | Date B | Time B | Date C | Time C
20110701 | 3841 | 20110701 | 3856 | 20110701 | 4343
20110701 | 3841 | 20110701 | 3856 | 20110701 | 4343
20110701 | 35446 | 20110701 | 35514 | 20110701 | 40214
20110701 | 40108 | 20110701 | 40123 | 20110701 | 40640
20110701 | 40108 | 20110701 | 40123 | 20110701 | 40640
20110701 | 54016 | 20110701 | 54039 | 0 | 0
20110701 | 54016 | 20110701 | 54039 | 0 | 0
20110701 | 80802 | 20110701 | 80855 | 20110701 | 81440
20110701 | 80802 | 20110701 | 80855 | 20110701 | 81440
20110701 | 92906 | 20110701 | 93002 | 20110701 | 93449
20110701 | 92906 | 20110701 | 93002 | 20110701 | 93449
20110701 | 111144 | 20110701 | 111226 | 20110701 | 111928
20110701 | 121825 | 20110701 | 121859 | 20110701 | 122135
20110701 | 135431 | 20110701 | 135527 | 20110701 | 135813
20110701 | 135431 | 20110701 | 135527 | 20110701 | 135813
20110701 | 142211 | 20110701 | 142317 | 20110701 | 142646
20110701 | 142211 | 20110701 | 142317 | 20110701 | 142646
Spreadsheet: jim_schwieger__14300__Bronco Playoff Schedule
Sheet: Sheet1

Bronco Maroon [NAME]
Monday 5/14 | Wednesday 5/16 | Saturday 5/19
#1 Braves-Labay
BC#2 @ 8:00pm | Winner of 1 vs. 8
#8 Marlins-Bleyl |  | Winner of Round 2
 | BC#2 @ 8:00pm
#3 A's-Hamilton
BC#2 @ 6:00pm | Winner of 3 vs. 6
#6 Dodgers-Truitt
 |  | BC#2 @ 10:00am
#5 Cardinals-Hamilton
WLY#5 @ 6:00pm | Winner of 4 vs. 5
#4 Reds-Cook
 | BC#2 @ 6:00pm | Winner of Round 2
#7 Astros-Cambell
WLY#5 @ 8:00pm | Winner of 2 vs. 7
#2 Angels-Arnold
Spreadsheet: 803819d1667725548-how-to-do-fast-replacing-of-row-number-accross-different-columns-copy-of-baza-nova-verzija-racuni-1-
Sheet: R61

Ime artikla
Spreadsheet: 50469d1249925740-excel-2007-dependant-lists-and-lookups-fnalgpicker
Sheet: GK

Name | Club | Price
M Almunia | ARS | 4.3
L Fabianski | ARS | 4.1
B Friedel | AV | 3.7
B Guzan | AV | 3.5
J Hart | BIR | 3.3
M Taylor | BIR | 3.2
J [NAME] | BLA | 3.2
P Robinson | BLA | 3.4
A Al Habsi | BOL | 3.3
J Jaaskelainen | BOL | 3.5
B [NAME] | BUR | 3.1
D Penny | BUR | 3.1
P Cech | CHE | 5
Hilario | CHE | 4.4
R Turnbull | CHE | 4.4
T Howard | EVE | 4.1
C Nash | EVE | 3.8
M Schwarzer | FUL | 3.7
P [NAME] | FUL | 3.5
M Duke | HUL | 3.2
B Myhill | HUL | 3.2
D Cavalieri | LIV | 4.5
J Reina | LIV | 5.1
S Given | MC | 3.8
S [NAME] | MC | 3.6
B [NAME] | MU | 4.6
T Kuszczak | MU | 4.3
[NAME] Sar | MU | 5
A [NAME] | POR | 3.2
D James | POR | 3.5
A Niemi | POR | 3.3
S Simonsen | STO | 3.1
T Sorensen | STO | 3.3
M Fulop | SUN | 3.2
C Gordon | SUN | 3.3
C Cudicini | TOT | 3.7
Gomes | TOT | 3.8
R Green | WH | 3.6
R [NAME] | WIG | 3.4
C Kirkland | WIG | 3.6
M Pollitt | WIG | 3.4
M Hahnemann | WOL | 3.2
W Hennessey | WOL | 3.2
Spreadsheet: 967c3b21-a76c-49de-8cac-e479c8ba111d
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
CRAB | Test | CRAB | Crab, IgE | Crab, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
CRAB | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
CRAB | Result | CRAB | Crab, IgE | Crab, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6092-1
Spreadsheet: 853346d1703217947-match-with-prefix-match
Sheet: Sheet1

Customer Code | Area |  |  |  |  | Customer
[NAME] | North |  |  |  |  | AA | North
AA2345 | North |  |  |  |  | BB | South
BB2348 | South |  |  |  |  | CC | East
CC3555 | East |  |  |  |  | FF | West
FF333344 | West
CC666612 | East
 |  | * Is there a formula for the red portion without using IF = AA then North, IF=BB then South etc?
Spreadsheet: 838880d1691493484-simplifying-speeding-up-an-indirect-formula-weekly-sales-yoy-by-customer-test
Sheet: B

 |  |  |  | 2023-01-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | JAN |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FEB |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAR |  |  |  |  |  |  |  |  |  |  |  |  |  |  | APR |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JUN |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JUL |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AUG |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SEPT |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OCT |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOV |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEC |  |  | TOTAL YEARLY
 |  |  |  | 2022-01-03 00:00:00 | 2023-01-02 00:00:00 | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference 22 Vs 23 |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference 22 Vs 23 |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference 22 Vs 23 |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference 22 Vs 23 |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference 22 Vs 23 |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference | 2022 | 2023 | Difference
B | 1146 |  | 2023-05-22 00:00:00
 |  |  | 2023-05-02 00:00:00
 |  |  | 2023-06-29 00:00:00
 |  |  | 2023-07-27 00:00:00
 |  |  | 2023-07-27 00:00:00
 |  |  | 2023-07-17 00:00:00
 |  |  | 2023-05-29 00:00:00
 |  |  | 2023-07-05 00:00:00
 |  |  | 2023-05-22 00:00:00
 |  |  | 2023-05-03 00:00:00
 |  |  | 2023-05-05 00:00:00
 |  |  | 2023-08-04 00:00:00
 |  |  | 2023-06-07 00:00:00
 |  |  | 2023-07-12 00:00:00
 |  |  | 2023-05-29 00:00:00
 | B's TOTAL
KEY
 | Sampling
 | New customer
abcd | Closed
Spreadsheet: 148486d1333445596-find-and-match-data-upon-a-certain-equation-example
Sheet: Sheet1

Certain data in column A |  |  |  |  | Ai | Aj | An
2 |  | Constant | 0.01 |  | 2 | 2 | 4
3 |  | Certain error | 0.02 |  | 2 | 3 | 5
4 |  |  |  |  | 2 | 4 | 6
5 |  |  |  |  | 3 | 2 | 5
6 |  |  |  |  | 3 | 3 | 6
Spreadsheet: 782769d1654263225-data-clean-up-20220523_coxiril-cen_neg_2019_batch-abc_pulse_centroid_nominal-mass-aminsajid-
Sheet: Coxiril_CEN_Neg_Batch A1

Raw data
Coxiril_Batch A_Bag 1
1 |  |  | 2 |  |  | 3
Mass | Intensity |  | Mass | Intensity |  | Mass | Intensity
101 | 55256 |  | 100 | 2323 |  | 100 | 2629
102 | 1484 |  | 101 | 24613 |  | 101 | 28560
103 | 4593 |  | 102 | 665 |  | 102 | 12
104 | 531 |  | 103 | 5880 |  | 103 | 10364
105 | 16464 |  | 105 | 11028 |  | 105 | 12282
107 | 325 |  | 107 | 329 |  | 108 | 5922
108 | 6530 |  | 109 | 16332 |  | 109 | 16345
109 | 8250 |  | 111 | 34303 |  | 111 | 23111
110 | 4586 |  | 112 | 26 |  | 112 | 55
111 | 23330 |  | 113 | 68298 |  | 113 | 53636
112 | 11906 |  | 114 | 12257 |  | 114 | 563
Using if formula |  |  |  |  |  |  |  |  |  |  | What I want |  |  |  |  |  |  |  |  |  | Using Index/Aggregate
1 |  |  | 2 |  |  | 3 |  |  |  |  | 1 |  |  | 2 |  |  | 3 |  |  |  | 1 |  |  | 2 |  |  | 3
 |  |  |  |  |  |  |  |  |  |  | 101 | 55256 |  | 100 | 2323 |  | 100 | 2629
 |  |  |  |  |  |  |  |  |  |  | 102 | 1484 |  | 101 | 24613 |  | 101 | 28560
 |  |  |  |  |  |  |  |  |  |  | 103 | 4593 |  | 103 | 5880 |  | 103 | 10364
 |  |  |  |  |  |  |  |  |  |  | 105 | 16464 |  | 105 | 11028 |  | 105 | 12282
 |  |  |  |  |  |  |  |  |  |  | 108 | 6530 |  | 109 | 16332 |  | 108 | 5922
 |  |  |  |  |  |  |  |  |  |  | 109 | 8250 |  | 111 | 34303 |  | 109 | 16345
 |  |  |  |  |  |  |  |  |  |  | 110 | 4586 |  | 113 | 68298 |  | 111 | 23111
 |  |  |  |  |  |  |  |  |  |  | 111 | 23330 |  | 114 | 12257 |  | 113 | 53636
 |  |  |  |  |  |  |  |  |  |  | 112 | 11906 |  |  |  |  | 114 | 563
Spreadsheet: 36174d1233941927-help-with-index-match-confirming-matches-on-a-list-excel_help
Sheet: Tab A

code | item
 | Activity ID | Phase
 | 1.2.1.1 | Analysis
 | 1.2.1.2 | Build
 | 1.2.1.2 | Test
 | 1.2.1.3 | Analysis
 | 1.2.1.4 | Design
 | 1.2.1.4 | Build
 | 1.2.1.4 | Test
 | 1.2.1.5 | Design
 | 1.2.1.5 | Build
 | 1.2.1.5 | Test
 | 1.2.2.1 | Design
 | 1.2.2.1 | Build
 | 1.2.2.1 | Test
 | 1.2.2.2 | Design
 | 1.2.2.2 | Build
 | 1.2.2.2 | Test
 | 1.2.2.3 | Design
 | 1.2.2.3 | Build
 | 1.2.2.3 | Test
 | 1.2.3.1 | Design
 | 1.2.3.1 | Build
 | 1.2.3.1 | Test
 | 1.2.3.2 | Design
 | 1.2.3.2 | Build
 | 1.2.3.2 | Test
 | 1.2.4.1 | Design
 | 1.2.4.1 | Build
 | 1.2.4.1 | Test
 | 1.2.4.2 | Analysis
 | 1.2.4.2 | Design
 | 1.2.4.2 | Build
 | 1.2.4.2 | Test
 | 1.2.4.3 | Design
 | 1.2.4.3 | Build
 | 1.2.4.3 | Test
 | 1.3.1.1 | Analysis
 | 1.3.1.2 | Design
 | 1.3.1.2 | Build
 | 1.3.1.2 | Test
Spreadsheet: 584934d1533537098-formula-for-identifying-start-date-and-finish-date-and-associated-number-of-days-workflow-status-draft
Sheet: Sheet1

Ref No. | Start Date | Finish Date
ABC 123 | 28/03/2018 at 10:12 AM | 28/03/2018 at 11:09 AM
ABC 123 | 28/03/2018 at 11:09 AM | 29/03/2018 at 9:07 AM
ABC 123 | 29/03/2018 at 9:07 AM | 29/03/2018 at 9:07 AM
ABC 123 | 29/03/2018 at 9:07 AM | 3/04/2018 at 11:42 AM
ABC 123 | 3/04/2018 at 1:31 PM | 3/04/2018 at 1:31 PM
ABC 123 | 3/04/2018 at 1:31 PM | 4/04/2018 at 2:07 PM
ABC 123 | 3/04/2018 at 11:42 AM | 3/04/2018 at 12:31 PM
ABC 123 | 3/04/2018 at 12:31 PM | 3/04/2018 at 1:31 PM
ABC 123 | 4/04/2018 at 2:07 PM | 4/04/2018 at 2:09 PM
ABC 124 | 13/03/2018 at 8:18 AM | 14/03/2018 at 3:27 PM
ABC 124 | 15/03/2018 at 4:51 PM | 19/03/2018 at 4:18 PM
ABC 124 | 15/03/2018 at 8:38 AM | 15/03/2018 at 4:51 PM
ABC 124 | 19/03/2018 at 4:18 PM | 19/03/2018 at 5:46 PM
ABC 124 | 19/03/2018 at 5:46 PM | 20/03/2018 at 11:46 AM
ABC 124 | 20/03/2018 at 11:46 AM | 21/03/2018 at 9:18 AM
ABC 124 | 21/03/2018 at 9:18 AM | 21/03/2018 at 9:41 AM
ABC 124 | 21/03/2018 at 9:41 AM | 22/03/2018 at 10:38 AM
ABC 124 | 22/03/2018 at 10:38 AM | 26/03/2018 at 1:02 PM
ABC 124 | 26/03/2018 at 1:02 PM | 26/03/2018 at 2:41 PM
ABC 125 | 11/04/2018 at 10:08 AM | 11/04/2018 at 11:39 AM
ABC 125 | 11/04/2018 at 11:39 AM | 11/04/2018 at 12:12 PM
ABC 125 | 15/03/2018 at 5:10 PM | 19/03/2018 at 12:03 PM
ABC 125 | 19/03/2018 at 12:03 PM | 21/03/2018 at 4:21 PM
ABC 125 | 2/03/2018 at 10:41 AM | 15/03/2018 at 5:10 PM
ABC 125 | 21/03/2018 at 4:21 PM | 22/03/2018 at 1:56 PM
ABC 125 | 22/03/2018 at 1:56 PM | 9/04/2018 at 8:57 AM
ABC 125 | 9/04/2018 at 11:41 AM | 11/04/2018 at 10:08 AM
ABC 125 | 9/04/2018 at 8:57 AM | 9/04/2018 at 8:57 AM
ABC 125 | 9/04/2018 at 8:57 AM | 9/04/2018 at 11:41 AM
ABC 126 | 1/05/2018 at 7:59 AM | 6/06/2018 at 12:17 PM
ABC 126 | 26/06/2018 at 12:58 PM | 28/06/2018 at 12:19 PM
ABC 126 | 26/06/2018 at 9:11 AM | 26/06/2018 at 12:58 PM
ABC 126 | 28/06/2018 at 12:19 PM | 29/06/2018 at 10:42 AM
ABC 126 | 29/06/2018 at 10:42 AM | 29/06/2018 at 11:08 AM
ABC 126 | 29/06/2018 at 11:08 AM | 29/06/2018 at 1:13 PM
ABC 126 | 6/06/2018 at 12:17 PM | 6/06/2018 at 12:18 PM
ABC 126 | 6/06/2018 at 12:18 PM | 6/06/2018 at 7:24 PM
ABC 126 | 6/06/2018 at 7:24 PM | 8/06/2018 at 6:25 PM
ABC 126 | 6/06/2018 at 7:24 PM | 26/06/2018 at 9:11 AM