tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 827332d1682612760-retrive-value-left-of-keyword-in-a-string-retreve-value-left-of-keyword
Sheet: Sheet1

 |  |  |  |  |  | seems easy to spellout the formula but not easy to apply it:(
 |  | Data | Desired Result
 |  |  |  |  |  | If data contayins Keyword "YES" or "NO" then get all numbers to its left before the preceding space
 |  | GN230616P10 GN 10 YES -1 1.5 | 10 |  |  | and if there are none than blank
 |  | GN230616P11 GN 4080 NO -1 0.99 | 4080
 |  | GN230616P12 GN 12 NO -2 1.97 | 12
 |  | GN230915P11 GN 11 NO -1 1.3 | 11
 |  | GN230915P12 GN 4075 NO -1 1.73 | 4075
 |  | GN231215P10 GN 3980 YES -1 1.12 | 3980
 |  | GN231215P12 GN 12 YES -1 2.02 | 12
 |  | GN240119P10 GN 10 YES -2 1.71 | 10
 |  | [NAME] 2.82
 |  | GN240119P20 @EtW3N  YES -1 10.35
 |  | GN250117P10 @EtW3N  NO -1 3.1
 |  | GN250117P12 @EtW3Q 3980 YES -1 3.15 | 3980
 |  | GN250117P20 @EtW3Q 20 NO -1 11 | 20
 |  | IM230616P6 @EtS 4575.75 NO -1 0.3 | 4575.75
 |  | IM230616P7 @EtW3J 7 YES -1 1.2 | 7
 |  | IM230915P7 IM 7 YES -1 1.37 | 7
 |  | IM240119P5 IM 289 YES -2 0.625 | 289
 |  | IM240119P8 IM 8 NO -1 2.2 | 8
 |  | IM250117P7 @Et5DH23 1546 NO -2 2.15 | 1546
 |  | IM250117P10 @Et5DH23  NO -1 3.97
 |  | [NAME] 20 YES -2 2.135 | 20
 |  | S230616P22.5 @Et5DH 122.5 NO -4 2.2 | 122.5
 |  | [NAME]NO -2 1.75
 |  | S230915P22.5 S 22.5 NO -4 2.7875 | 22.5
 |  | WO230616P16 WO  NO -1 2
 |  | WO230915P17 WO 325.6 YES -2 1.625 | 325.6
 |  | WO230915P18 WO 18 NO -1 1.95 | 18
 |  | WO240119P15 WO 15 NO -2 2.15 | 15
 |  | WO240119P20 WO 4115 YES -1 5 | 4115
 |  | E230721P11 E  NO -1 1.08
 |  | E231020P12 E 4115 YES -1 0.72 | 4115
 |  | E240119P10 E 3800 NO -1 1.17 | 3800
 |  | E240621P10 E 10 NO -1 1.54 | 10
 |  | E250117P10 E 7.8 NO -1 2.01 | 7.8
 |  | IEP230519P50 IEP  YES -1 1.3
 |  | IEP230616P50 IEP 3875.5 NO -5 3.34 | 3875.5
 |  | IEP230616P55 IEP 55 NO -1 5.3 | 55
 |  | IEP230915P50 IEP 50.5 YES -3 2.75 | 50.5
 |  | IEP230915P55 @Et1J23 55 NO -2 6.855 | 55
 |  | IEP240119P50 @EtS23 50 NO -4 6.025 | 50
 |  | IEP240119P55 @EtSZ23  YES -2 7.95
 |  | IEP250117P50 @EtS23 50 NO -2 10.6 | 50
 |  | IEP250117P55 @Et1DJ23  YES -2 14.05
 |  | RI230519P12.5 @EtW3J23 12.5 YES -4 1.2025 | 12.5
 |  | RI230818P10 @EtW3J23 45.75 NO -1 0.9 | 45.75
 |  | RI231020P12.5 @Et2J23 12.5 NO -1 1.65 | 12.5
 |  | RI231020P15 @EtW3J23  YES -1 3.95
 |  | NLY230519P20 NLY 3305.25 YES -1 1.99 | 3305.25
 |  | NLY230519P22 NLY 22 NO -3 1.65 | 22
 |  | NLY230721P20 NLY 20 NO -1 2.66 | 20
Spreadsheet: 767184d1644329698-sort-and-trim-datas-containing-spaces-sortby-and-trim
Sheet: sort and trim

 |  |  |  |  | formula
text1 | bla1 | hello1 |  |  |  | bla1 | hello1
text3 | bla3 | hello3 |  |  | text2 | bla2 | hello2
text2 | bla2 | hello2 |  | --> | text3 | bla3 | hello3
text4 | bla4 | hello4 |  |  | text4 | bla4 | hello4
text6 | bla6 | hello6 |  |  | text5 | bla5 | hello5
text5 | bla5 | hello5 |  |  | text6 | bla6 | hello6
at the end of every text there are spaces |  |  |  |  | here there are spaces too, i need to remove them together with trim formula
Spreadsheet: 525614d1498811805-mtd-calculation-using-countif-sample-data
Sheet: Sheet1

Channe | Mmddyy | Month | Day | Year | [NAME] |  | Channel | Count
A | 2017-03-05 00:00:00 |  |  |  | 1 |  | A |  |  | Month | 3
B | 2017-03-03 00:00:00 |  |  |  | 1 |  | B |  |  | Day | 6
C | 2017-03-03 00:00:00 |  |  |  | 1 |  | C |  |  | Year | 2017
C | 2017-03-02 00:00:00 |  |  |  | 1
Spreadsheet: 167639d1342045403-a-formula-that-can-calculate-bulk-orders-example
Sheet: Orders

Customer | Item | Price | Amount
 | 1 | 7 | 500 | 3000
 | 2 | 30 | 101 | 2030
 | 3 | 7 | 501 | 3007 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 | 4 | 30 | 100 | 2000
Spreadsheet: 0f0f2963-60e7-4aa5-833c-fd27fb873218
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
DRPLA | Test | DRPLA | Dentatorubral-Pallidoluysian Atrophy (DRPLA) Gene Analysis | DRPLA Gene Analysis | Polymerase Chain Reaction (PCR) (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | EDTA (lavender-top) tube: EDTA OR Yellow-Top (ACD) Tube: ACD OR |  |  | 3 | mL | [NAME] must arrive within 96 hours of draw.   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.	 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. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | Normal alleles: 7-35 CAG repeats [NAME] alleles: 49-93 CAG repeats An interpretive report will be provided. | Tuesday; 2 p.m. | 5 days | 11 days | 1 | 81401 |  |  |  |  | Rochester
DRPLA | [NAME] | VARIES | Varies |  |  |  | Ambient
DRPLA | Result | 16889 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2
DRPLA | Result | 16890 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
DRPLA | Result | 16891 | Source | Source | Alphanumeric
DRPLA | Result | 16892 | Order Date | Order Date | Alphanumeric
DRPLA | Result | 16893 | Reason For Referral | Reason For Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1
DRPLA | Result | 16894 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49549-9
DRPLA | Result | 16895 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21756-2
DRPLA | Result | 16896 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69047-9
DRPLA | Result | 16897 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
DRPLA | Result | 16898 | Reviewed By: | Reviewed By: | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
DRPLA | Result | 16899 | Release Date | Release Date | Alphanumeric
Spreadsheet: 61945ce8-16ee-4608-92d7-e04fd1cf6a51
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Name | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  |  | Learner ID
 |  |  |  | School/College/University
Arts, Audio/Video Technology and Communications: Performing Arts
Career Pathway Plan of Study for ►Learners ►Parents ►Counselors ►Teachers/Faculty
This Career Pathway Plan of Study (based on the Performing Arts Pathway of the Arts, Audio/Video Technology and Communications [NAME]) can serve as a guide, along with other career planning materials, as learners continue on a career path. Courses listed within this plan are only recommended coursework and should be individualized to meet each learner’s educational and career goals. *This Plan of Study, used for learners at an educational institution, should be customized with course titles and appropriate high school graduation requirements as well as college entrance requirements.
EDUCATION | LEVELS | GRADE | [NAME] | Math | Science | Social Studies/ Sciences | Other Required Courses Other Electives Recommended       Electives                         Learner Activities | *Career and Technical Courses                    and/ or Degree Major Courses for                 Performing Arts Pathway | SAMPLE                                   Occupations Relating                            to This Pathway
 |  | Interest Inventory Administered and Plan of Study Initiated for all Learners
[NAME] |  | 9 |  |  |  |  |  |  | ►Actor ►Composer ►Conductor ►Costume Designer ►Dancer ►Director and Coach ►Film/Video Editor ►Lighting Designer ►Makeup Artist ►Music Instructor ►Musician ►Performer ►Performing Arts Educator ►Playwright ►Production Manager: Digital,     Video and Stage ►Scenic Designer ►Scenic Painter ►Sound Designer
 |  | 10
 |  | 11
 |  | College Placement Assessments-Academic/Career Advisement Provided
 |  | 12
 |  | Articulation/Dual Credit Transcripted-Postsecondary courses may be taken/moved to the secondary level for articulation/dual credit purposes.
POSTSECONDARY |  | Year 13
 |  | Year14
 |  | Year 15
 |  | Year 16
 |  |  |  |  |  | Project funded by the U.S. Department of Education (VO51B020001)
Spreadsheet: 94858d1294618606-find-all-instances-of-a-selected-item-and-return-all-results-advfilterondblclick
Sheet: Data

Number | Date | Company | Item |  | Number | Date | Company | Item |  | Number | Date | Company | Item
1 | 2008-12-14 00:00:00 | a | a1 |  |  |  |  | 2a |  | 6 | 2008-12-16 00:00:00 | r | 2a
2 | 2008-12-14 00:00:00 | b | a2 |  |  |  |  |  |  | 7 | 2008-12-17 00:00:00 | t | 2a
3 | 2008-12-14 00:00:00 | d | a3 |  |  |  |  |  |  | 8 | 2008-12-18 00:00:00 | a | 2a
4 | 2008-12-14 00:00:00 | c | a4 |  |  |  |  |  |  | 9 | 2008-12-19 00:00:00 | b | 2a
5 | 2008-12-15 00:00:00 | e | a5 |  |  |  |  |  |  | 10 | 2008-12-20 00:00:00 | c | 2a
6 | 2008-12-16 00:00:00 | r | 2a
7 | 2008-12-17 00:00:00 | t | 2a | <<<Double Click on any Item in Column D
8 | 2008-12-18 00:00:00 | a | 2a
9 | 2008-12-19 00:00:00 | b | 2a |  | Look at the code behind the worksheet to see
10 | 2008-12-20 00:00:00 | c | 2a |  | how easy the code is.
11 | 2008-12-21 00:00:00 | d | b2
12 | 2008-12-21 00:00:00 | e | b3
13 | 2008-12-21 00:00:00 | r | b4 |  | The criteria range is above with the
14 | 2008-12-21 00:00:00 | f | [NAME] |  | Advanced filtered data in K to N
15 | 2008-12-21 00:00:00 | t | b6
16 | 2008-12-22 00:00:00 | y | v5
17 | 2008-12-23 00:00:00 | a | v6
18 | 2008-12-24 00:00:00 | b | v7
19 | 2008-12-25 00:00:00 | c | v8
20 | 2008-12-26 00:00:00 | d | v9
21 | 2008-12-26 00:00:00 | t | v10
22 | 2008-12-26 00:00:00 | y | v11
23 | 2008-12-26 00:00:00 | u | v12
24 | 2008-12-26 00:00:00 | i | v13
25 | 2008-12-27 00:00:00 | a | v14
Spreadsheet: 171531d1343759168-automatic-percentage-formula-by-month-needed-book1-1-
Sheet: Sheet1

 | Vitro |  | Arc |  | Piramal MO
 | Count | % of Month | Count | % of Month | Count | % of Month
2012-07-01 00:00:00 | 254035 |  | 156200 |  | 432572
2012-08-01 00:00:00 | 356010 |  | 156200 |  | 241751
2012-09-01 00:00:00 | 402835 |  | 0 |  | 353499
2012-10-01 00:00:00 | 364139 |  | 184600 |  | 302233
2012-11-01 00:00:00 | 367302 |  | 0 |  | 432407
2012-12-01 00:00:00 | 336551 |  | 0 |  | 390521
2013-01-01 00:00:00 | 474188 |  | 92300 |  | 283632
2013-02-01 00:00:00 | 469268 |  | 106500 |  | 506798
2013-03-01 00:00:00 | 187708 |  | 99400 |  | 297543
2013-04-01 00:00:00 | 309038 |  | 78100 |  | 390518
2013-05-01 00:00:00 | 331651 |  | 78100 |  | 334731
Spreadsheet: 747394d1631468012-formula-help-to-help-build-a-stock-inventory-excel-help-om-edited
Sheet: Products Realised

Date | Product | Units |  | Oil | Wick | Wax | Vessel | Label | [NAME] | Candle Guard | [NAME] |  | [NAME] | OM002 | [NAME] | OM004 | OM005 | OM006 | OM007 | OM008 | OM009 | [NAME] | OM011 | OM012 | OM013 | OM014 | OM015 | OM016 | OM017 | OM018 | OM019 | OM020 | OM021 | OM022 | OM023 | OM024 | OM025 | OM026 | OM027 | OM028 | OM029 | [NAME] | OM031 | OM032 | OM033 | OM034 | OM035 | OM036 | OM037 | OM038 | OM039 | OM040 | OM041 | OM042 | OM043
2021-07-12 00:00:00 | Candle 1 | 10
2021-08-12 00:00:00 | Candle 2 | 15
2021-09-12 00:00:00 | Candle 3 | 10
Spreadsheet: 869502d1716073335-create-an-equation-from-a-set-of-data-with-two-variables-and-one-dependent-equa-ao
Sheet: Sheet1

Variavel  X | Variavel Y | Dependente Z
4.9 | 62 | 95.66
4.9 | 72 | 94.11
4.9 | 82 | 92.36
4.9 | 92 | 90.46
4.9 | 102 | 87.89
4.9 | 112 | 84.5
4.7 | 62 | 96.03
4.7 | 72 | 93.74
4.7 | 82 | 92.14
4.7 | 92 | 90.15
4.7 | 102 | 87.47
4.7 | 112 | 83.94
4.5 | 62 | 96.35
4.5 | 72 | 93.47
4.5 | 82 | 91.9
4.5 | 92 | 89.82
4.5 | 102 | 87.02
4.5 | 112 | 83.34
4.3 | 62 | 96.21
4.3 | 72 | 93.24
4.3 | 82 | 91.64
4.3 | 92 | 89.47
4.3 | 102 | 86.54
4.3 | 112 | 82.68
4.1 | 62 | 95.57
4.1 | 72 | 93.02
4.1 | 82 | 91.36
4.1 | 92 | 89.08
4.1 | 102 | 86
4.1 | 112 | 81.97
3.9 | 62 | 94.91
3.9 | 72 | 92.79
3.9 | 82 | 91.05
3.9 | 92 | 88.66
3.9 | 102 | 85.42
3.9 | 112 | 81.18
3.7 | 62 | 94.29
3.7 | 72 | 92.55
3.7 | 82 | 90.72
3.7 | 92 | 88.19
3.7 | 102 | 84.78
3.7 | 112 | 80.31
Spreadsheet: 756971d1637915193-returning-only-the-first-number-among-duplicate-numbers-and-removing-duplicates-excel-forum-26-11
Sheet: Sheet1

original data | preferred display of data
11417-146   /C12 | 11417-146   /C12
11417-14   /D27 | 11417-14   /D27
11417-07   /D22 | 11417-07   /D22
11417-04   /A20 | 11417-04   /A20
11417-01   [NAME] | 11417-01   [NAME]
11402-36   /C25 | 11402-36   /C25
11371-119   /D30 | 11371-119   /D30
11371-119   /D30
11371-119   /D30
11371-119   /D30
11371-119   /D30
11371-119   /D30
11371-119   /D30
11371-119   /D30
11371-119   /D30
11371-119   /D30
11371-119   /D30
11371-118   /D30 | 11371-118   /D30
11371-118   /D30
11371-118   /D30
11371-118   /D30
11371-118   /D30
11371-118   /D30
11371-118   /D30
11371-118   /D30
11371-118   /D30
11371-118   /D30
11371-118   /D30
11371-118   /D30
11371-118   /D30
11371-118   /D30
11371-118   /D30
11371-118   /D30
11371-118   /D30
11371-118   /D30
11371-118   /D30
11371-118   /D30
11371-118   /D30
11371-118   /D30
11371-118   /D30
11371-118   /D30
11371-118   /D30
11371-118   /D30
11371-118   /D30
11371-118   /D30
11371-118   /D30
11371-118   /D30
11371-118   /D30
11371-117   /D19 /D22 / | 11371-117   /D19 /D22 /
11371-117   /D19 /D22 /
11371-117   /D19 /D22 /
11371-117   /D19 /D22 /
11371-117   /D19 /D22 /
11371-117   /D19 /D22 /
11371-117   /D19 /D22 /
11371-117   /D19 /D22 /
11371-117   /D19 /D22 /
11371-117   /D19 /D22 /
11371-117   /D19 /D22 /
11371-117   /D19 /D22 /
11371-116   /D19 | 11371-116   /D19
11371-116   /D19
11371-116   /D19
11371-116   /D19
11371-116   /D19
11371-116   /D19
11371-116   /D19
11371-116   /D19
11371-116   /D19
11371-116   /D19
11371-116   /D19
11371-116   /D19
11371-116   /D19
11371-111   /D28 | 11371-111   /D28
11371-111   /D28
11371-111   /D28
11371-111   /D28
11371-111   /D28
11371-111   /D28
11371-111   /D28
11371-111   /D28
11371-111   /D28
11371-111   /D28
11371-111   /D28
11371-111   /D28
11371-111   /D28
11371-111   /D28
11371-111   /D28
11371-111   /D28
11371-111   /D28
11371-111   /D28
11371-111   /D28
11371-111   /D28
11371-111   /D28
11371-111   /D28
11371-111   /D28
Spreadsheet: 731657d1620486509-v-lookup-based-on-different-sheets-using-data-validation-list-test-sheets-ans
Sheet: Sep 21

Enter 1st of Month Here -> | 2021-09-01 00:00:00 | Controller | Volunteer 1 | Volunteer 2 | Volunteer 3 | Volunteer 4 | Volunteer 5 | Volunteer 6
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
Sat
Sun
Spreadsheet: 0e90d601-c30d-4883-b769-b856e45633f4
Sheet: Sheet1

PART A | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Summary of School Funding Projected Changes 2013/14 - 2014/15 (including academies unless stated otherwise)
 |  | A | B | C | D |  | E
 |  |  | Movement
 |  | 2013/14 | delegated | Centrally Managed | 2014/15 Estimate (A+B+C) |  | Further Detail
 |  | £'000 |  | £'000 | £'000
Schools Block:
-DSG |  | 831822 | 2607 | -2707 | 831722
-Pupil Premium (excluding academies) |  | 64464 | 17906 | 0 | 82370
Total |  | 896286 | 20513 | -2707 | 914092 |  | Appendix 1
Early Years Block- DSG |  | 78275 | 700 | 6000 | 84975 |  | Appendix 2
High Needs Block
-DSG |  | 124440 | 4684 | 4900 | 134024
-Pupil Premium (excluding academies) |  | 3280 | 352 | 1245 | 4877
Total |  | 127720 | 5036 | 6145 | 138901 |  | Appendix 3
Total |  | 1102281 | 26249 | 9438 | 1137968 |  |  |  | 1137968
PART B - Identified Pressures and Funding Solutions
Pressures/ Commitments
 | £'000
Loss of Early Years Transitional Protection | 1600
Net Increase in Primary & Secondary pupils (reception to year 11) | 7300
Increase in Early Years 3 & 4 pupils | 700
Falling Pupils Fund (new) | 500
Charging of eligible General Fund costs to DSG | 8000
Increase in projected High Needs places | 7584
Growth Fund Increased Requirements (initial estimate) | 600
Total | 26284
Funding Solutions
 | £'000
Carry Forward of Underspend from 2013/14 (£5m) | 1600
Increase in schools block DSG Allocation from [NAME] (total £9,600k) | 7300
Increase in Early Years DSG Allocation from Dfe | 700
Primary & Secondary toplsice (falling pupils fund) | 500
Primary & Secondary toplsice (eligible general fund costs) | 8000
Balance of 2013/14 carry forward | 3400
Balance of increase in DSG for 2014/15 | 2300
Surplus Balances | 2484
 | 26284
Spreadsheet: 177567d1346347441-reverse-sumproduct-solve-for-distributions-help-example
Sheet: example

 |  | months | distribution
 |  | (fixed) | (variable)
 | [1 Year] | 12 | 0.7392681671423892
 | [3 Years] | 36 | 0.1415563146319779
 | [5 Years] | 60 | 0.1191755182256329
 |  | -
 |  | back into all possible distributions (% combinations between 12/36/60 months) to acheieve given blended average figure
 |  | i.e. if I have the below blended-averages what are all the combinations of 12/36/60 months to achieve them
 |  | average | % 12mos | % 36mos | % 60mos
 |  | 17.84 | ?? % | ?? % | ?? % | <-- SUM = 100%
 |  | 33.31 | ?? % | ?? % | ?? %
 |  | 25.68 | ?? % | ?? % | ?? %
Spreadsheet: 800950d1666008571-sorting-of-rows-belonging-to-one-of-four-hierarchical-levels-sorting-of-four-levels
Sheet: Sorting

Assetnum level |  | parent | assetnum
1 |  |  | A66.0001
2 |  | A66.0001 | A66.0006
3 |  | A66.0006 | A66.0006ARM
4 |  | A66.0006ARM | A11.0085
3 |  | A66.0006 | A66.0006INS
4 |  | A66.0006INS | W53.0002
4 |  | A66.0006INS | Z32.0017
4 |  | A66.0006INS | Z32.0034
4 |  | A66.0006INS | Z32.0037
4 |  | A66.0006INS | Z32.0041
3 |  | A66.0006 | A66.0006VAL
4 |  | A66.0006VAL | X31.1412
4 |  | A66.0006VAL | X31.1413
4 |  | A66.0006VAL | X31.1414
4 |  | A66.0006VAL | X31.1415
4 |  | A66.0006VAL | [NAME]
4 |  | A66.0006VAL | X31.1425
4 |  | A66.0006VAL | X32.0144
4 |  | A66.0006VAL | X32.0145
4 |  | A66.0006VAL | X36.1038
4 |  | A66.0006VAL | X36.1039
4 |  | A66.0006VAL | X36.1040
4 |  | A66.0006VAL | X36.1041
4 |  | A66.0006VAL | X36.1042
4 |  | A66.0006VAL | X37.0077
4 |  | A66.0006VAL | X38.0170
4 |  | A66.0006VAL | X38.0171
4 |  | A66.0006VAL | [NAME]
4 |  | A66.0006VAL | X38.0173
4 |  | A66.0006VAL | [NAME]
4 |  | A66.0006VAL | X38.0182
4 |  | A66.0006VAL | X38.0183
4 |  | A66.0006VAL | X38.0186
4 |  | A66.0006VAL | X38.0187
4 |  | A66.0006VAL | X38.0200
4 |  | A66.0006VAL | X38.0202
4 |  | A66.0006VAL | X38.0203
3 |  | A66.0006 | W12.0008
3 |  | A66.0006 | W12.0009
2 |  | A66.0001 | A66.0007
3 |  | A66.0007 | A66.0007ARM
4 |  | A66.0007ARM | A13.0085
3 |  | A66.0007 | A66.0007INS
4 |  | A66.0007INS | W54.0002
4 |  | A66.0007INS | Z33.0017
4 |  | A66.0007INS | Z33.0034
4 |  | A66.0007INS | Z33.0037
4 |  | A66.0007INS | Z33.0041
3 |  | A66.0007 | A66.0007VAL
4 |  | A66.0007VAL | X40.1412
4 |  | A66.0007VAL | X40.1413
4 |  | A66.0007VAL | X40.1414
4 |  | A66.0007VAL | X40.1415
4 |  | A66.0007VAL | X40.1424
4 |  | A66.0007VAL | X40.1425
4 |  | A66.0007VAL | X32.0144
4 |  | A66.0007VAL | X32.0145
4 |  | A66.0007VAL | X42.1038
4 |  | A66.0007VAL | X42.1039
4 |  | A66.0007VAL | X42.1040
4 |  | A66.0007VAL | [NAME]
4 |  | A66.0007VAL | X42.1042
4 |  | A66.0007VAL | X37.0077
4 |  | A66.0007VAL | X43.0170
4 |  | A66.0007VAL | X43.0171
4 |  | A66.0007VAL | [NAME]
4 |  | A66.0007VAL | X43.0173
4 |  | A66.0007VAL | X43.0174
4 |  | A66.0007VAL | X43.0182
4 |  | A66.0007VAL | X43.0183
4 |  | A66.0007VAL | X43.0186
4 |  | A66.0007VAL | X43.0187
4 |  | A66.0007VAL | X43.0200
4 |  | A66.0007VAL | X43.0202
4 |  | A66.0007VAL | X43.0203
3 |  | A66.0007 | W14.0008
3 |  | A66.0007 | W14.0009
Spreadsheet: daren_farmer__5418__Industrials0800
Sheet: Supply 02-00

 |  |  |  | Supply (Buyback) Deals
2000-08-01 00:00:00 |  |  |  | Beg. Month
Counterparty | Point Name | Meter # | Sitara # | Volume |  | Adj. Volume | Pricing | Comments
Air Products, Incorporated | Pasadena Plant Air Products HP | 981418 | 132976 |  |  |  | [NAME]
BASF Corporation | Freeport Plant BASF HPL | 981437 | 133000 |  |  |  | [NAME].Hub+2After.[NAME] USD / MMBTU
Bayer Corporation | HPL/MILES INC-Baytown Plant | 981550 | 343621 |  |  |  | 0 to 1950 [NAME].Hub.GDP.D.A. - 0.01 USD/MM  1950 to 13000 [NAME].Hub. GD.D.L
Bayer Corporation | Cedar [NAME] HPL | 988056 | 343621
[NAME] | [NAME] | 981428 | 344830 |  |  |  | 0 to 1000 @ Hou.[NAME].GDP.D.A - 0.02 USD/MM    1000 to 2000 @ [NAME].HUB.GDP.D.A
[NAME] | Deer Park | 981505 | 140200 |  |  |  | [NAME]. GDP.D.A.
[NAME] | MT. Belvieu - Trident | 981389 | 140200
Chevron Chemical Company | Olefins Plant Chevron | 981024 | 336760 |  |  |  | [NAME] .HUB.GD.D.L
EGP Fuels Company | MTBE Plant | 988216 | 139070 |  |  |  | HOU.SHIPCHANN.GDP.D.A
Enron Methanol Company | [NAME] | 988291 | 139058 |  |  |  | HOU.SHIPCHANN.GDP.D.A
[NAME] | Various meters | 1373,1552,1553,1384,1062, | see comment |  |  |  | 0 to 10,000mm/d @ Kath HUB+2AFTER.GDP.D.A 10,000MM/D @ Katy HUB+2After.GDP.D.L | Sitara #: 246408,246633,246625,259397,246629
Formosa Hydrocarbons Co. | Port Comfort Formosa Hydrocarbon | 981000 | 92881 |  |  |  | [NAME]USD / MMBTU
Global Octanes Corpt. | [NAME] Porte Plant | 981528 | 137991 |  |  |  | [NAME] After. GDP.D.L
Lyondell - Citgo | [NAME] | 981063 | 147729 |  |  |  | 0 to 10,000mm/d @ Kath HUB+2AFTER.GDP.D.A 15,000MM/D @ Katy HUB+2After.GDP.D.L
Marathon  -  Ashland | Texas City Marathon Oil HPL | 981431 | 93371 |  |  |  | [NAME]
Petrofina Gas Pipeline | [NAME]. [NAME] | 981484 | 263422 |  |  |  | [NAME]
Rohm & Haas | Deer Part-Rohm & Haas | 981506 | 345297 |  |  |  | [NAME]. GDP.D.A
Shell Oil Co. | Channel Shell Oil Cogen. | 981581 | 359274 |  |  |  | [NAME]. GDP.D.A
Union Carbide | Chemical Plant | 981308 | 63576 |  |  |  | [NAME] After. GDP.D.L
Union Carbide | Seadrift Plant | 981332 | 63573 |  |  |  | [NAME] After. GDP.D.L
Valero Marketing & Supply | Texas City Refinery | 981233 | 148388 |  |  |  | 0 to 15,000 [NAME]. Hub + 2 After GDP.D.A.
Valero Marketing & Supply | Pasadena - Hill Petrol HPL | 981394 | 148396 |  |  |  | 0 TO 10,000 [NAME] After GDP.D.A
Valero Marketing & Supply | [NAME]. Calanese Chemical | 988018 | 148381 |  |  |  | 0 TO 35,000 [NAME] After GDP.D.A