tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 791443d1660339013-simplify-excel-formula-more-than-64-levels-of-nested-monthly-cost-quotation-variations-on-a-theme-tms
Sheet: TMS Sample

Extract |  |  |  | Converted | Extended
 | Complete |  |  | 1X a week |  |  |  | 1X a week |  |  | 2X a week |  |  | 3X a week |  |  | 4X a week |  |  | 5X a week |  |  | 6X a week
 |  | 4000 |  |  |  |  |  | Standard | Deep | Complete | Standard | Deep | Complete | Standard | Deep | Complete | Standard | Deep | Complete | Standard | Deep | Complete | Standard | Deep | Complete
 |  |  |  | 1X a week |  |  | 2000
 |  |  |  | 2X a week |  |  | 2500
 |  |  |  | 3X a week |  |  | 3000
 |  |  |  | 4X a week |  |  | 3500
 |  |  |  | 5X a week |  |  | 4000
 |  |  |  |  |  |  | 4500
=VALUE(IFERROR(INDEX(I$9:W$46,MATCH($C$8,$H$9:$H$46,0),MATCH($E$7,$I$7:$W$7,0)+MATCH($B$7,$I$8:$K$8,0)-1),"not found")) |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  | 5500
 |  |  |  |  |  |  | 6000
 |  |  |  |  |  |  | 6500
 |  |  |  |  |  |  | 7000
 |  |  |  |  |  |  | 7500
 |  |  |  |  |  |  | 8000
 |  |  |  |  |  |  | 8500
 |  |  |  |  |  |  | 9000
 |  |  |  |  |  |  | 9500
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | 10500
 |  |  |  |  |  |  | 11000
 |  |  |  |  |  |  | 11500
 |  |  |  |  |  |  | 12000
 |  |  |  |  |  |  | 12500
 |  |  |  |  |  |  | 13000
 |  |  |  |  |  |  | 13500
 |  |  |  |  |  |  | 14000
 |  |  |  |  |  |  | 14500
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 15500
 |  |  |  |  |  |  | 15500
 |  |  |  |  |  |  | 16000
 |  |  |  |  |  |  | 16500
 |  |  |  |  |  |  | 17000
 |  |  |  |  |  |  | 17500
 |  |  |  |  |  |  | 18000
 |  |  |  |  |  |  | 18500
 |  |  |  |  |  |  | 19000
 |  |  |  |  |  |  | 19500
 |  |  |  |  |  |  | 20000
Spreadsheet: e4b23989-2bce-4e90-92f4-399bffab38be
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | FOR ACCOUNTING USE ONLY UA3 Document No. | Unnamed: 10 | Unnamed: 11
REQUEST FOR CERTIFICATE TRANSFER OF FUNDS
To initiate a certificate transfer of funds between objects of expenditure or function, the following form must be filled out, printed, signed by the department head and VP/Provost, and submitted to the Director of Budget (Erwin 218).
From: |  |  |  |  |  |  |  | Date: | 2011-12-21 00:00:00
 |  | (Department)
Please Transfer |  | $ | 0
 | From Account # |  |  |  |  |  |  | To Account #
Personal Service - Regular |  |  |  |  |  |  | Personal Service - Regular
$ |  | PSR - Non-Inst |  | (0000) |  |  | $ |  | PSR - Non-Inst |  | (0000)
$ |  | PSR - Instructional |  | (0400) |  |  | $ |  | PSR - Instructional |  | (0400)
$ |  | PSR - OT/Hol-Comp |  | (1948) |  |  | $ |  | PSR - OT/Hol-Comp |  | (1948)
Temporary Service - Regular |  |  |  |  |  |  | Temporary Service - Regular
$ |  | TS - Non-Inst |  | (2000) |  |  | $ |  | TS - Non-Inst |  | (2000)
$ |  | TS - OT/Hol-Comp |  | (2098) |  |  | $ |  | TS - OT/Hol-Comp |  | (2098)
$ |  | TS - Instructional |  | (2400) |  |  | $ |  | TS - Instructional |  | (2400)
$ |  | TS - Students |  | (2600) |  |  | $ |  | TS - Students |  | (2600)
Other Than Personal Service |  |  |  |  |  |  | Other Than Personal Service
$ |  | Supplies & Exp |  | (3000) |  |  | $ |  | Supplies & Exp |  | (3000)
$ |  | Facilities Recharge |  | (3799) |  |  | $ |  | Facilities Recharge |  | (3799)
$ |  | Travel |  | (4000) |  |  | $ |  | Travel |  | (4000)
$ |  | Contractual Services |  | (5000) |  |  | $ |  | Contractual Services |  | (5000)
$ |  | Equipment |  | (7300) |  |  | $ |  | Equipment |  | (7300)
Recharges |  |  |  |  |  |  | Recharges
$ |  | Stores |  | (9200) |  |  | $ |  | Stores |  | (9200)
$ |  | Phone |  | (9300) |  |  | $ |  | Phone |  | (9300)
$ |  | Postage |  | (9400) |  |  | $ |  | Postage |  | (9400)
$ |  | Duplicating |  | (9500) |  |  | $ |  | Duplicating |  | (9500)
$ |  | Auto |  | (9600) |  |  | $ |  | Auto |  | (9600)
$ | 0 |  |  |  |  |  | $ | 0
JUSTIFICATION FOR TRANSFER OF FUNDS
DEPARTMENTAL APPROVAL
 | Signature: |  |  |  |  |  | Date:
DIVISIONAL APPROVAL (VP/Provost)
 | Signature: |  |  |  |  |  | Date:
Director of Budget
 | Signature: |  |  |  |  |  | Date:
RECOMMENDED - VP ADMINISTRATION
 | Signature: |  |  |  |  |  | Date:
ACCOUNTING DEPARTMENT
Certificate Number: |  |  |  | Effective Date of Certificate: |  |  |  | Input By: |  | Date:
Spreadsheet: 876852d1723565769-pivot-table-second-column-sum-and-values-not-matching-work-progress-dated-12-aug-2024-bvj-
Sheet: Delivery

MarkNo. | DO Qty | [NAME]. | Drawing wt, MT | ReceivedDate | Assembly Name |  | COLUMN C |  |  | Column D
QLGF-C2001 | 1 |  |  | 2024-06-14 00:00:00 |  | ok
QLGF-C2002 | 1 |  |  | 2024-06-14 00:00:00
QLGF-C2002 | 1 |  |  | 2024-06-14 00:00:00
QLGF-C2003 | 1 |  |  | 2024-06-14 00:00:00
QLGF-BM2003 | 1 |  |  | 2024-06-15 00:00:00
QLGF-BM2004 | 1 |  |  | 2024-06-15 00:00:00
QLGF-HB2005 | 1 |  |  | 2024-06-17 00:00:00
QLGF-HB2009 | 1 |  |  | 2024-06-17 00:00:00
QL-1-VB2001 | 1 |  |  | 2024-06-17 00:00:00
QL-1-VB2002 | 1 |  |  | 2024-06-17 00:00:00
QL-1-BM2002 | 1 |  |  | 2024-06-17 00:00:00
QL-1-BM2003 | 1 |  |  | 2024-06-17 00:00:00
QL-1-BM2004 | 1 |  |  | 2024-06-17 00:00:00
QT1-CL1002 | 1 |  |  | 2024-06-17 00:00:00 | Not in Sheet1
QT1-CL1007 | 1 |  |  | 2024-06-17 00:00:00 | Not in Sheet1
 |  |  |  |  |  |  | my work/test area
Spreadsheet: 271388d1381925759-product-list-months-of-year-vlookup-assistance-test
Sheet: Sales

Part Code | Description | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | Total 11-12
JBC441HD | MKII CONCEALED DOOR STOP - HEAVY DUTY | 1950 | 1900 | 2160 | 1570 | 2670 | 2068 | 1570 | 2706 | 2650 | 1105 | 1610 | 1220 | 23179
JBC442 | DOOR RESTRAINT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 20
JBC233 | ERICA | 20 | 0 | 10 | 10 | 230 | 90 | 40 | 20 | 0 | 0 | 150 | 0 | 570
Spreadsheet: 132249d1323641464-excel-2007-eliminating-weekend-in-bar-chart-plan_schedule
Sheet: Gantt Chart

# | Task Name | Resource | Status | Start Date | Duration (days)
1 | Task 1 |  |  | 2011-12-12 00:00:00 | 5
2 | Task 2 |  |  | 2011-12-19 00:00:00 | 5
3 | Task 3 |  |  | 2011-12-26 00:00:00 | 15
4 | Test Task 4 |  |  | 2012-01-02 00:00:00 | 12
5 | Testing Task 5 |  |  |  | 10
Total
 |  | 40889
 |  | 41255
 |  | 40896
Spreadsheet: 100349d1298712205-solver-issue-oil-blend-v3
Sheet: Sheet1

 |  |  | Fuel 1 | Fuel 2 | Fuel 3 | Fuel 4 | Fuel 5 | Fuel 6 | Fuel 7 | Fuel 8 | Fuel 9 | Fuel 10 | Fuel 11 | Fuel 12
 |  |  | 1% Sulfur | 3% Sulfur | 3% Sulfur | Heating | 1% Vacuum | 2% Vacuum | 0.5% Vacuum | Straight Run | Straight Run | [NAME] | Diesel
 |  |  | Fuel Oil | Fuel Oil | Fuel Oil | Oil | Gas Oil | Gas Oil | Gas Oil | (Low Sulfur) | (High Sulfur) | [NAME] | Fuel 11 | Slurry
 | Density |  | 0.996 | 0.996 | 0.996 | 0.855 | 0.904 | 0.904 | 0.904 | 0.928 | 0.953 | 0.797 | 0.85 | 1.1114
 | Linear visc. |  | 1.819 | 1.819 | 1.189 | 0.243 | 1.17 | 1.17 | 1.17 | 1.678 | 1.678 | -0.782 | -0.054 | 1.716
 | Sulfur |  | 1 | 3 | 0.7 | 0.2 | 1 | 2 | 0.5 | 0.3 | 2.75 | 0.125 | 0.2 | 2.37
 | Linear flash |  | 204.8 | 204.8 | 204.8 | 260.4 | 52.5 | 52.5 | 52.5 | 18.5 | 18.5 | 308.8 | 161.7 | 437
 | Price |  | 16.08 | 13.25 | 17.3 | 24.1 | 20.83 | 20.1 | 21.46 | 21 | 20 | 25.52 | 24.3 | 11.5
 | Portion Used |  | 0.4176984134126069 | 0.0759523802381855 | 0.5063492063492065 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1.150940317207471e-15
 |  |  | Blended Fuel Qualities |  | [NAME] | Min Spec
 | Density |  |  |  | 0.996 | 0.9
 | Linear visc. |  |  |  | 1.5 | 1
 | Sulfur |  |  |  | 1 | 0.3
 | Linear flash |  |  |  | 280 | 200
 | Cost
Spreadsheet: jonathan_mckay__16909__Lindsay Park
Sheet: Deal Sheet

Enron Direct Deal Sheet |  |  |  |  |  |  |  |  |  |  |  |  | 1 | January
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | February
Counterparty Name: | Lindsay Park Sports Centre |  |  |  | Deal Date: | 2001-07-19 00:00:00 |  |  |  |  |  |  | 3 | March
Originator: | Greg Frers |  |  |  | Deal ID #: | VB5889 |  |  |  |  |  |  | 4 | April
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | May
Deal Start Date: | 2001-08-01 00:00:00 |  |  |  | Unit of Measure: | GJ |  |  |  |  |  |  | 6 | June
Deal End Date: | 2002-07-31 00:00:00 |  |  |  | Volume (Monthly/Daily): | Monthly |  |  |  |  |  |  | 7 | July
Term Duration (months): |  |  |  |  |  |  |  |  |  |  |  |  | 8 | August
 |  |  |  |  | Price: |  |  |  |  |  |  |  | 9 | September
Fuel Rate %: | 0.01561 |  |  |  | Buy/Sell: |  |  |  |  |  |  |  | 10 | October
 |  |  |  |  |  |  |  |  |  |  |  |  | 11 | November
 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | December
 | Month | Rate 11 Volume | Rate 13 Volume | Combined Volume | Fuel | Total
 | January | 0 | 6869
 | February | 0 | 5642
 | March | 0 | 5136
 | April | 0 | 3905
 | May | 0 | 2416
 | June | 0 | 1840
 | July | 0 | 1444
 | August | 0 | 1399
 | September | 0 | 1898
 | October | 0 | 3372
 | November | 0 | 3969
 | December | 0 | 4791
 | TOTAL:
Spreadsheet: 62108d1263010640-overtime-overtime-1-
Sheet: Sheet1

Shift | Start Time | End Time | Start Day | End Day | Rate |  | Est. tax
2 | 18:00:00 | 04:30:00 | 2010-01-04 00:00:00 | 2010-01-07 00:00:00 | 15.06 |  | 0.24
Day | Date | Start Time | End Time | Hours worked | Sraight Time |  | Over Time |  | Shift Prem |  | Short WW |  | Holiday |  | Vacation |  | Pay per Day
Sun | 2010-01-03 00:00:00 | 18:00:00
Mon | 2010-01-04 00:00:00 | 18:00:00 | 03:54:00 | 9.4 | 9.4 | 141.564 |  |  | 9.4 | 7.078200000000002
Tue | 2010-01-05 00:00:00 | 18:00:00 | 04:42:00 | 10.2 | 10.2 | 153.612 |  |  | 10 | 7.680600000000001
Wed | 2010-01-06 00:00:00 | 18:00:00 | 05:24:00 | 10.9 | 10.9 | 164.154 |  |  | 10 | 8.2077
Thu | 2010-01-07 00:00:00 | 18:00:00 | 05:30:00 | 11 | 11 | 165.66 |  |  | 10 | 8.283000000000001
Fri | 2010-01-08 00:00:00 | 18:00:00
Sat | 2010-01-09 00:00:00 | 18:00:00
 |  |  | Totals:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gross Pay:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ~Taxes:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ~Net Pay:
Spreadsheet: 757778d1638455383-filter-formula-over-multiple-sheets-permit-register-gk
Sheet: Job Register 2022

ABC Job Number | Address | Job Description | Client | Job Received | Quote Sent | Date of Confirmation  to Proceed | Permit Number | BUILDING PERMIT | OCCUPANCY PERMIT | Inspection Status | Job Notes | BP INVOICE | [NAME]
ABC-22001 | Address 1 | Description 1 | Client 1 | 2022-01-01 00:00:00 | 2022-01-01 00:00:00 | 2022-01-01 00:00:00 | 001/001/2201 | BP |  |  | Note 9
ABC-22002 | Address 2 | Description 2 | Client 2 | 2022-01-02 00:00:00 | 2022-01-02 00:00:00 | 2022-01-02 00:00:00 | 001/001/2202 | APPROVE |  |  | Note 10
ABC-22003 | Address 3 | Description 3 | Client 3 | 2022-01-03 00:00:00 | 2022-01-03 00:00:00 | 2022-01-03 00:00:00 | 001/001/2203 | BP | OP |  | Note 11
ABC-22004 | Address 4 | Description 4 | Client 4 | 2022-01-04 00:00:00 | QUOTE |  |  |  |  |  | Note 12
ABC-22005 | Address 5 | Description 5 | Client 5 | 2022-01-05 00:00:00 | QUOTE |  |  |  |  |  | Note 13
Spreadsheet: 838139d1690776263-sumfs-formula-not-giving-correct-results-sumifs-using-wildard-card-to-sum-data-based-on-first-6-characters-in-col-a
Sheet: Imported Data

Name | Details | Value
85714 | 31/07/2023 | 44604.2
BQT - ACE BANK 851447 | 31/07/2023 | 19186.69
WETYLNG 00017869 | 31/07/2023 | 43065.75
V FOR | 31/07/2023 | 697.63
CRTY ERTY JUL23 | 31/07/2023 | 15258.2
WT. Creditors | 31/07/2023 | 12822.46
85186 | 31/07/2023 | 9180.72
WETYLNG 000178179 | 31/07/2023 | 29914.33
WETYLNG 000181796 | 31/07/2023 | 70977.84
BL NTR | 31/07/2023 | 160
WT.Creditors | 31/07/2023 | 655.03
WB.Creditors | 31/07/2023 | 45686.91
Spreadsheet: 193fd485-529d-43d9-9413-383170f22492
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  |  |  |  |  |  | extension.psu.edu/fruit-production
 |  |  |  |  |  |  | Apple Target Fruit Calculator
 |  |  |  |  |  |  | by [NAME]
 |  |  |  | Directions:
 |  |  |  | 1) | enter values in red text only
 |  |  |  | 2) | enter the values for your desired yield in bu/acre and desired % field cullage
 |  |  |  | 3) | designate the row spacing for the block being studied and indicate the desired return on investment
 |  |  |  | 4) | in column D '% target fruit' indicate your desired size distribution
 |  |  |  | 5) | in column I 'FOB price' indicate the price you expect your apples to sell for in the specified sizes
 |  |  |  | 6) | in the column 'Pack Charge', enter the amount charged for packing/handling specified fruit sizes
 |  |  |  | 6) | view economic analysis provided in the light yellow box
 |  |  |  | 7) | the 'graph' tab graphs the size distribution you specified
 |  | Disclaimer: The accuracy and predictions of fruit production calculators are based on certain cost measures and practices, all results may not be applicable to all opeartions.
Spreadsheet: 57033a2d-85f6-41a7-a924-0f58f6099ca6
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
MTBS | Test | MTBS | Microsporidia [NAME] | Microsporidia [NAME] | Trichrome-Blue Stain (Ryan Modification) | Stool Container: Stool |  |  | 10 | g | Forms: If not ordering electronically, submit a Microbiology Request Form (Supply T244) with the specimen.  Patient should avoid use of anti-diarrheal medication (ie, loperamide or Pepto-Bismol).   The presence of barium will interfere with this test.   Submit only 1 of the following specimens:   Preferred:	 Specimen Type: Preserved stool	 Container/Tube: Preferred: ECOFIX preservative (Supply T219) Acceptable: Container with 10% formalin [NAME]: 5 g Collection Instructions: See Stool Collection Information Sheet in Special Instructions. Specimen Stability Information: Ambient (preferred)/Refrigerated/Frozen Additional Information: Formed stool specimens seldomly yield microsporidial organisms.   Specimen Type: Unpreserved stool Container/Tube: Stool container (Supply T288) [NAME]: 5 g Collection Instructions: See Stool Collection Information Sheet in Special Instructions. Specimen Stability Information: Refrigerated <3 days (preferred)/Frozen Additional Information: Formed stool specimens seldomly yield microsporidial organisms.   Acceptable: [NAME] aspirate Container/Tube: Sterile container [NAME]: 0.5 mL Specimen Stability Information: Refrigerated <3 days (preferred)/Frozen | Stool: 1 g/Duodental aspirate: 0 | Hemolysis	NA Thawing	Warm OK-note to lab; Cold OK Lipemia	NA Icterus	NA Other	NA | Negative If positive, reported as microsporidia | Monday through Friday; 12 p.m. | 2 days | 4 days |  | Profile |  |  |  |  | Rochester
MTBS | [NAME] | VARIES | Varies |  |  |  | See instructions
MTBS | Order Question | Q00M0042 | [NAME] |  | Plain Text
MTBS | Result | MTBS | Microsporidia [NAME] | Microsporidia [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
MTBS | Billing Component | MTBS |  | Concentration |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 87015
MTBS | Billing Component | MTBS |  | Special Stain |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 87207
Spreadsheet: 8257d018-2c2b-4f5b-8014-543447a2d0b9
Sheet: Sheet1

Global X MLP ETF | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  |  |  | Fund Holdings Data as of 5/22/2013
% of Net Assets | Name | Identifier | Market Price($) | Shares Held | Market Value($)
5.73 | [NAME] PARTNERS | 118230101 | 69.12 | 51560 | 3563827.2
5.67 | MARKWEST ENERGY-PART UTS | 570759100 | 69.4 | 50834 | 3527879.6
5.35 | ENTERPRISE PRODUCTS PRTNR | 293792107 | 63.09 | 52771 | 3329322.39
5.3 | ENBRIDGE ENERGY PARTNERS | 29250R106 | 31.02 | 106292 | 3297177.84
5.29 | MAGELLAN MIDSTREAM | 559080106 | 54.37 | 60513 | 3290091.81
5.28 | ENERGY TRANSFER PARTNERSP | 29273R109 | 52.19 | 62932 | 3284421.08
5.26 | PLAINS ALL AMERN PIP | 726503105 | 59.2 | 55284 | 3272812.8
5.19 | [NAME] PARTNERS LP | 96950F104 | 52.1 | 61963 | 3228272.3
5.04 | KINDER MORGAN ENERGY PRTN | 494550106 | 88.93 | 35235 | 3133448.55
4.77 | ONEOK PARTNERS LP | 68268N103 | 53.5 | 55458 | 2967003
4.73 | EL PASO PIPELINE PART LP | 283702108 | 43.52 | 67657 | 2944432.64
4.16 | ACCESS MIDSTREAM PARTNERS | 00434L109 | 44.93 | 57559 | 2586125.87
3.79 | SUNOCO LOGISTICS PRTS | 86764L108 | 63.62 | 37076 | 2358775.12
3.77 | TARGA RESOURCES PARTNERS | 87611X105 | 49.63 | 47295 | 2347250.85
3.17 | NUSTAR ENERGY LP | 67058H102 | 49.44 | 39940 | 1974633.6
3.12 | REGENCY ENERGY PARTNERS | 75885Y107 | 26.99 | 71899 | 1940554.01
3.09 | [NAME]. PART. | 96627104 | 31.21 | 61662 | 1924471.02
2.87 | WESTERN GAS PARTNERS L.P. | 958254104 | 61.74 | 28947 | 1787187.78
2.81 | GENESIS ENERGY L.P. | 371927104 | 54.31 | 32183 | 1747858.73
2.68 | PVR PARTNERS LP | 693665101 | 26.83 | 62097 | 1666062.51
2.56 | AMERIGAS PARTNERS-LP | 30975106 | 47.71 | 33401 | 1593561.71
2.38 | INERGY LP | 456615103 | 24.72 | 59754 | 1477118.88
2.28 | SUBURBAN PROPANE PARTNERS | 864482104 | 48.42 | 29267 | 1417108.14
1.93 | ATLAS PIPELINE PARTNERS | 49392103 | 39.59 | 30333 | 1200883.47
1.69 | CHENIERE ENERGY PARTNERS | 16411Q101 | 29.5 | 35673 | 1052353.5
1.48 | EV ENERGY PARTNERS L.P. | 26926V107 | 42.43 | 21753 | 922979.79
1.41 | [NAME] | 87233Q108 | 45.5 | 19284 | 877422
1.35 | ALLIANCE RESOURCE PTNRLP | 01877R108 | 76.47 | 10999 | 841093.53
1.35 | NATURAL RESOURCE PART. LP | 63900P103 | 23.26 | 35973 | 836731.98
1.3 | SPECTRA ENERGY PARTNERS | 84756N109 | 36.7 | 22003 | 807510.1
0.67 | NORTHERN TIER ENERGY LP | 665826103 | 25.2 | 16406 | 413431.2
-0.01 | CASH | CASH | 1 | -4252.14 | -4252.14
Spreadsheet: 860714d1708705403-populate-from-another-sheet-with-duplicates-book1-version-1-
Sheet: Sheet3

Customer # | Customer Name | Product name | [NAME] (lbs) | [NAME] (kgs) |  |  | Search
 | Jordan | Poly Bags | 550 | 249.4761001896019 |  |  | 3001
2714 | Jordan | Poly Bags | 550 | 249.4761001896019 |  |  | 2920
2714 | Jordan | Poly Bags | 550 | 249.4761001896019 |  |  | 2918
2920 | Jordan | Small Carton | 150 | 68.03893641534596 |  |  | 2714
3001 | Hollis | Carton | 150 | 68.03893641534596
2918 | [NAME] | Large Carton | 5000 | 2267.964547178199
Spreadsheet: kate_symes__18226__EES March Dailies
Sheet: 3-11

POSITIVE [NAME] = LONG POSITION
NEGATIVE VARIANCE = SHORT POSITION
NP15 | 2001-03-11 00:00:00 |  |  |  |  |  | SP15 |  |  |  |  |  |  | ZP26
Fixed Peak Long | 0 | Fixed Off Peak Long | 158.36 |  |  |  | Fixed Peak Long | 0 |  | Fixed Off Peak Long | 99.62 |  |  | Fixed Peak Long | 0 |  | Fixed Off Peak Long | 99.62
Fixed Peak Short Pos | 0 | Fixed Off Peak Short | 168.36 |  |  |  | Fixed Peak Short | 0 |  | Fixed Off Peak Short | 109.62 |  |  | Fixed Peak Short | 0 |  | Fixed Off Peak Short | 109.62
Index Peak |  | Index [NAME] |  |  |  |  | Index Peak |  |  | Index [NAME] |  |  |  | Index Peak |  |  | Index [NAME]
HE | Fixed | Other | DJ Index | Load | var |  | HE | Fixed | Other | DJ Index | Load | var |  | HE | Fixed | Other | DJ Index | Load | var
1 | 4.93 | 0 | 0 | -4.93 |  |  | 1 | -21.43 | 0 | 0 | 35.43 |  |  | 1 | 1.98 | 0 | 0 | -1.98
2 | 4.02 | 0 | 0 | -4.02 |  |  | 2 | -20.05 | 0 | 0 | 38.05 |  |  | 2 | 1.94 | 0 | 0 | -1.94
3 | 3.44 | 0 | 0 | -3.44 |  |  | 3 | -19.53 | 0 | 0 | 38.53 |  |  | 3 | 1.92 | 0 | 0 | -1.92
4 | 3.29 | 0 | 0 | -3.29 |  |  | 4 | -19.92 | 0 | 0 | 38.92 |  |  | 4 | 1.91 | 0 | 0 | -1.91
5 | 3.33 | 0 | 0 | -3.33 |  |  | 5 | -19.92 | 0 | 0 | 36.92 |  |  | 5 | 1.91 | 0 | 0 | -1.91
6 | 3.73 | 0 | 0 | -3.73 |  |  | 6 | -42.44 | 0 | 0 | 33.44 |  |  | 6 | 1.93 | 0 | 0 | -1.93
7 | 4.95 | 0 | 0 | -4.95 |  |  | 7 | -33.51 | 0 | 0 | 28.51 |  |  | 7 | 1.98 | 0 | 0 | -1.98
8 | 7.03 | 0 | 0 | -7.03 |  |  | 8 | -35.82 | 0 | 0 | 25.82 |  |  | 8 | 2.07 | 0 | 0 | -2.07
9 | 9.04 | 0 | 0 | -9.04 |  |  | 9 | -37.67 | 0 | 0 | 23.67 |  |  | 9 | 2.16 | 0 | 0 | -2.16
10 | 10.22 | 0 | 0 | -10.22 |  |  | 10 | -39.07 | 0 | 0 | 22.07 |  |  | 10 | 2.2 | 0 | 0 | -2.2
11 | 10.8 | 0 | 0 | -10.8 |  |  | 11 | -39.65 | 0 | 0 | 19.65 |  |  | 11 | 2.23 | 0 | 0 | -2.23
12 | 10.8 | 0 | 0 | -10.8 |  |  | 12 | -39.58 | 0 | 0 | 18.58 |  |  | 12 | 2.23 | 0 | 0 | -2.23
13 | 10.74 | 0 | 0 | -10.74 |  |  | 13 | -39.65 | 0 | 0 | 18.65 |  |  | 13 | 2.22 | 0 | 0 | -2.22
14 | 10.59 | 0 | 0 | -10.59 |  |  | 14 | -39.71 | 0 | 0 | 18.71 |  |  | 14 | 2.22 | 0 | 0 | -2.22
15 | 10.21 | 0 | 0 | -10.21 |  |  | 15 | -39.33000000000008 | 0 | 0 | 19.33 |  |  | 15 | 2.2 | 0 | 0 | -2.2
16 | 10.46 | 0 | 0 | -10.46 |  |  | 16 | -39.36 | 0 | 0 | 19.36 |  |  | 16 | 2.21 | 0 | 0 | -2.21
17 | 11.12 | 0 | 0 | -11.12 |  |  | 17 | -39.92 | 0 | 0 | 19.92 |  |  | 17 | 2.24 | 0 | 0 | -2.24
18 | 12.56 | 0 | 0 | -12.56 |  |  | 18 | -41.37 | 0 | 0 | 16.37 |  |  | 18 | 2.3 | 0 | 0 | -2.3
19 | 14.39 | 0 | 0 | -14.39 |  |  | 19 | -43.48 | 0 | 0 | 13.48 |  |  | 19 | 2.38 | 0 | 0 | -2.38
20 | 14.05 | 0 | 0 | -14.05 |  |  | 20 | -42.82 | 0 | 0 | 15.82 |  |  | 20 | 2.36 | 0 | 0 | -2.36
21 | 12.96 | 0 | 0 | -12.96 |  |  | 21 | -41.7 | 0 | 0 | 18.7 |  |  | 21 | 2.31 | 0 | 0 | -2.31
22 | 11.04 | 0 | 0 | -11.04 |  |  | 22 | -39.54 | 0 | 0 | 22.54 |  |  | 22 | 2.24 | 0 | 0 | -2.24
23 | 8.7 | 0 | 0 | -8.7 |  |  | 23 | -46.90999999999995 | 0 | 0 | 25.91 |  |  | 23 | 2.13 | 0 | 0 | -2.13
24 | 6.32 | 0 | 0 | -6.32 |  |  | 24 | -45.03999999999993 | 0 | 0 | 31.04 |  |  | 24 | 2.04 | 0 | 0 | -2.04
Spreadsheet: andy_zipper__746__Broker & Exchange Detail 10-29-01 EM
Sheet: EXCHANGE DEAL SUMMARY

EnronOnline Exchange Detail for 10/29/2001
Completed Transactions:
TODAY
Date | 2001-10-29 00:00:00
Count
Exchange Party | Counterparty Name | Commodity | Total
True Quote LLC | PG&E Energy Trading - Power, L.P. | US East Power | 2
True Quote LLC Total |  |  | 2
Grand Total |  |  | 2
LTD
Date | (All)
Count
Exchange Party | Counterparty Name | Commodity | Total
True Quote LLC | PG&E Energy Trading - Power, L.P. | US East Power | 82
 |  | US West Power | 25
 | Tucson Electric Power Company | US West Power | 2
 | Cinergy Marketing & Trading, LLC | Natural Gas | 2
 | Conectiv Energy Supply, Inc. | US East Power | 11
 |  | Natural Gas | 1
 | Tractebel Energy Marketing, Inc. | US East Power | 1
 |  | Natural Gas | 15
 | CMS Marketing, Services and Trading Company | US East Power | 1
 |  | Natural Gas | 3
 | Calpine Energy Services, L.P. | US East Power | 4
 |  | US West Power | 2
 |  | Natural Gas | 9
 | CLECO Marketing and Trading, LLC | Natural Gas | 1
 | PG&E Energy Trading-Gas Corporation | Natural Gas | 128
 | Axia Energy, LP | Natural Gas | 3
 | Entergy-Koch Trading, LP | Natural Gas | 10
 | Conoco Inc. | Natural Gas | 13
 | Richardson Energy Marketing, Ltd. | Natural Gas | 1
True Quote LLC Total |  |  | 314
Grand Total |  |  | 314