tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 76478d1277036429-double-vlookup-or-index-match-or-something-else-hera-1-
Sheet: Sheet1

 |  | Helper Column ColumnsA:E must be sorted ascending on this column This column can then be hidden
breadboard | nsw | breadboard nsw |  | 2009-05-01 00:00:00 |  | 2009-04-01 00:00:00
chair | tas | chair tas |  | 2009-03-01 00:00:00 |  | 2009-07-01 00:00:00
coffee table | act | coffee table act |  | 2008-03-01 00:00:00 |  | 2009-09-01 00:00:00
glass | wa | glass wa |  | 2008-01-01 00:00:00 |  | 2009-01-01 00:00:00
hatstand | tas | hatstand tas |  | 2009-09-01 00:00:00 |  | 2009-08-01 00:00:00
highchair | sa | highchair sa |  | 2008-06-01 00:00:00 |  | 2009-12-01 00:00:00
sink | nsw | sink nsw |  | 2009-02-01 00:00:00 |  | 2009-06-01 00:00:00
sink | [NAME] | [NAME] |  | 2008-05-01 00:00:00 |  | 2009-11-01 00:00:00
table | qld | table qld |  | 2009-10-01 00:00:00 |  | 2009-05-01 00:00:00
table | review | table review |  | 2009-09-01 00:00:00 |  | 2009-02-01 00:00:00
table | sa | table sa |  | 2007-07-01 00:00:00 |  | 2010-01-01 00:00:00
table | wa | table wa |  | 2008-10-01 00:00:00 |  | 2009-03-01 00:00:00
telephone | nsw | telephone nsw |  | 2008-04-01 00:00:00 |  | 2009-10-01 00:00:00
Spreadsheet: 540817d1506980956-finding-the-eligible-minimum-value-please-help-urgent-thank-you-so-much-sample-2-
Sheet: TOOLING

 | Part Number
 | Best Choice: Chair
 | Vendor | Cost | [NAME] % | Profit $ | Sale $
 | Best Choice: Desk
 | Vendor | Cost | [NAME] % | Profit $ | Sale $
 |  |  | .
 | Best Choice: Chair & Desk
 | Vendor | Cost | [NAME] % | Profit $ | Sale $
 | Supplies Vendor | Cost: Chair | [NAME] % | Profit: Chair | Sale $: Chair | Cost: Desk | Mark-up% | Profit: Desk | Sale $: Desk | Total: Cost | Total: Profit $ | Total: Sale $
 | Vendor 1. | 1111 | 0.2 |  |  | 555 | 0.2
 | Vendor 2. | 1111 | 0.2 |  |  | 567 | 0.1
 | Vendor 3. | 1345 | 0.2 |  |  | 0 | 0
 | [NAME]. | ABC | ABC |  |  | ABC | ABC
 | Vendor
 | Vendor 1.
 | Vendor 2.
 | Vendor 3.
 | [NAME].
 | Vendor 5.
 | Vendor 6.
Spreadsheet: 720956d1614392182-method-to-estimate-missing-data-items-data-fill-example
Sheet: Sheet2

Date | Value
2019-02-12 00:00:00
 | 4994
 | 6169
 | 3600
 | 4200
 | 4800
 | 5280
 | 6995
 | 5040
 | 4813
 | 5040
 | 4560
 | 4800
 | 5280
 | 5520
 | 5640
Spreadsheet: 864799d1711948868-from-static-to-dynamic-cell-reference-via-indirect-function-raw-materials-record
Sheet: Toluene

Raw Material |  | Toluene
Date | Description | Batch Processed Quantity |  | Quantity Stored ([NAME]'s) | Quantity Issued ([NAME]'s) | Total Quantity Remaining ([NAME]'s) | Bilty or Batch (Description)
 |  | Qty | [NAME]'s
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
2023-09-30 00:00:00 |  |  |  |  |  | 701
Total
Spreadsheet: 25269d1216407499-if-condition-then-paste-value-weekmonthtimestudy
Sheet: Time Study Form

ADMINISTRATION DIVISION TIME STUDY |  |  |  |  |  |  |  |  |  |  | (revised 07/01/04) |  |  |  |  |  |  |  |  |  |  |  | Name: |  |  |  | Emil
I certify that this is a true and |  |  |  |  |  |  |  | I certify that the employee's time records have |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month: | 7
accurate report of my time and the |  |  |  |  |  |  |  | been examined and that, to the best of my knowledge |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classification: |  |  |  |  |  |  |  |  |  |  |  | Day: | 1
activities were performed as shown. |  |  |  |  |  |  |  | and belief, this time record is true and correct |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year: | 2008
 |  |  |  |  |  |  |  | and the activities were performed as shown.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Budget Unit Number:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2008-07-01 00:00:00
Employee's signature and date |  |  |  |  |  |  |  | [NAME]'s signature and date |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month and Year:
BUDGET | [NAME] | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | TOTAL | BUDGET
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
7580 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7580 | 0
7560 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7560 | 0
7598 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7598 | 0
7700 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7700 | 0
7650 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7650 | 0
7800 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  | 7 | 7800 | 1
Specific Programs: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
1874 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Total Allocable |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  | 7 | Allocable
 | Nonallocable |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nonalcble | 0
 | Total Hours | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 0 | 7 | Total Hrs | 1
Spreadsheet: 5e803b98-39fe-4760-98fe-9c63845aecd3
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
FVAP | Test | FVAP | VAP Cholesterol | VAP Cholesterol | Ultra-Sensitive Centrifugation | Serum Gel Tube: SGT |  |  | 3 | mL | Draw blood in a serum gel tube(s), plain red-top tube(s) is acceptable. Spin down and send 3 mL of serum refrigerated in a plastic vial. | 1.5 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA Other	NA | A final report will be attached in MayoAccess.     	 Test Performed By:  Atherotech                                        201 London Parkway                                        Birmingham, AL  35211 | Monday through Friday | 3 days | 4-6 days |  | Profile |  |  |  |  | Atherotech
FVAP | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
FVAP | Result | [NAME] | VAP Cholesterol | VAP Cholesterol | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FVAP | Billing Component | FVAP |  | High [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 83701
FVAP | Billing Component | FVAP |  | Triglycerides |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 84478
Spreadsheet: 679366d1590351820-help-with-filter-subtotal-and-getting-nonadjacent-cell-data-book1
Sheet: Sheet3

SYMBOL | date | OPEN | HIGH | LOW | CLOSE | volume | con | TIMESTAMP |  |  | volume | con
BBB | 2020-05-28 00:00:00 | 17923.3 | 18175 | 17565.6 | 17644.85 | 1378440 | 109080 | 2020-05-21 00:00:00 |  | total
AAA | 2020-06-25 00:00:00 | 17900 | 18163.05 | 17581.05 | 17648.15 | 176040 | 37820 | 2020-05-21 00:00:00
BBB | 2020-07-30 00:00:00 | 17920.85 | 18174 | 17620.05 | 17688.2 | 19725 | 3275 | 2020-05-21 00:00:00 |  | [NAME]
BBB | 2020-05-28 00:00:00 | 9068.9 | 9169.7 | 9046.15 | 9075.1 | 7511325 | -252825 | 2020-05-21 00:00:00
AAA | 2020-06-25 00:00:00 | 9070 | 9166.45 | 9040.3 | 9075.6 | 1996125 | 150525 | 2020-05-21 00:00:00 |  | HIGH
DDD | 2020-07-30 00:00:00 | 9074.65 | 9165 | 9045.2 | 9073.05 | 292275 | 11925 | 2020-05-21 00:00:00
BBB | 2020-05-28 00:00:00 | 13439 | 13690 | 13439 | 13545 | 1550 | 300 | 2020-05-21 00:00:00
AAA | 2020-06-25 00:00:00 | 0 | 0 | 0 | 13360 | 100 | 0 | 2020-05-21 00:00:00
DDD | 2020-05-28 00:00:00 | 1177.05 | 1198.1 | 1167.05 | 1184.25 | 1477200 | -86400 | 2020-05-21 00:00:00
Spreadsheet: 95aeb2f5-ee45-4dc6-be30-d23c5fff55fc
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
FAMPH | Test | FAMPH | Amphetamines Screen and GC-MS Confirmation, Serum - Forensic | Serum Amphetamine Analysis | Screen by Immunoassay/If positive, confirmation by Gas Chromatography-Mass Spectrometry (GC-MS) | Green-Top Tube (Sodium Heparin): GrnNaHp OR Plain, Red-Top Tube: Red OR |  |  | 5 | mL | Submit only 1 of the following specimens:   Plasma Draw blood in a green-top (sodium heparin) tube(s). ([NAME] is not acceptable.) Spin down and send 5 mL of  sodium heparin plasma refrigerated. Note:  1. Indicate plasma on request form. 	2. Label specimen appropriately (plasma).   Serum Draw blood in a plain, red-top tube(s). (Serum gel tube is not  acceptable.) Spin down and send 5 mL of serum refrigerated. Note:  1. Indicate serum on request form. 	2. Label specimen appropriately (serum). | 1.2 mL Note: Submission of the m | Specimens other than	Serum, plasma Anticoagulants other than	Plain red-top, sodium heparin, EDTA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | This specimen was screened by Immunoassay. Any positive result is confirmed by Gas Chromatography with Mass Spectrometry (GC/MS). The following threshold concentrations are used for this analysis: DRUG SCREENING CONFIRMATION THRESHOLD THRESHOLD Amphetamines 50 ng/mL Amphetamine 10 ng/mL Methamphetamine 10 ng/mL TEST PERFORMED BY MEDTOX LABORATORIES, INC. 402 W. COUNTY ROAD D ST. PAUL, MN. 55112 | Monday through Sunday | 5 days | 6 days | 1 | 80101 |  |  |  |  | Medtox Laboratories, Inc
FAMPH | [NAME] | VARIES | Varies |  |  |  | Refrigerated
FAMPH | Result | Z1146 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FAMPH | Result | Z1168 | [NAME]:Methamphet | [NAME]:Methamphet | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
FAMPH | Result | Z1169 | Amphetamine | Amphetamine | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
FAMPH | Result | [NAME] | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 879118d1726572292-primary-code-and-secondary-code-selection-cpt-groups-jt-
Sheet: primary matched secondary

Primary code & description |  | << this formula gets the column number for the relevant Secondary group
004 Description |  | << this formula gets the associated Secondary group number, for the selected dropdown choice
44568 | 44568 description
44569 | 44569 description
44570 | 44570 description
44571 | 44571 description
44572 | 44572 description
44573 | 44573 description
44574 | 44574 description
Spreadsheet: 43e9c895-da6e-4c6e-b29e-bea6bf6f111c
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
C2729 | Test | C2729 | Breast Carcinoma-Associated Antigen (CA 27.29), Serum | Breast [NAME] Ag(CA 27.29) | Chemiluminometric Immunoassay | Serum Gel Tube: SGT |  |  | 0.5 | mL | Collection Container/Tube:  Preferred: Serum gel Acceptable: Red top Submission Container/Tube: Plastic vial [NAME]: 0.5 mL Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.25 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | Males > or =18 years: < or =38.0 U/mL (use not defined) Females > or =18 years: < or =38.0 U/mL Reference values have not been established for patients that are <18 years of age. Serum markers are not specific for malignancy, and values may vary by method. | Monday through Friday, Sunday; 6 a.m.-6 p.m. | Same day/1 day | 2 days | 1 | 86300 |  |  |  |  | Rochester
C2729 | [NAME] | SERUM | Serum |  |  |  | Frozen | 90 days
C2729 | Result | C2729 | Breast [NAME] Ag(CA 27.29) | Breast [NAME] Ag(CA 27.29) | Numeric |  |  |  |  | U/mL |  |  |  |  |  |  |  |  |  | 17842-6
Spreadsheet: 164520d1340803133-excel-2007-trying-to-build-a-time-sheet-work-book-and-am-stuck-on-seperating-the-day-and-night-shift-new-project-pay-roll-and-time-sheet-beta-day-night-test
Sheet: Friday Timesheeet

 |  |  | TRI TOOL INC.
 | Customer: |  |  |  |  |  |  |  |  | CUSTOMER CONTACT: |  |  |  |  |  | JOB NO: |  |  |  |  |  | Home Page
 | Work Location: |  |  |  |  |  |  |  |  | CUST. P.O. NO. |  |  |  |  |  | DATE:
 | Employee: |  |  |  |  | TOTAL HRS: |  | WORK [NAME]/WORK ORDER NO. |  |  |  |  |  |  |  |  | CONSUMABLES: |  |  |  |  | Payroll
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QUAN: | PART NO:
 |  |  |  |  | Verify the following SAFTY ITEM CHECKLIST as required on this site. |  |  |  |  |  |  |  |  | Equipment Usage: |  |  |  |  | Tech Initial
 |  | NO | YES
 |  |  | X | 1 | If required, has the site specific training been completed?
 |  |  | X | 2 | If permits are required, do you have the proper papers?
 |  |  | X | 3 | Is Scaffolding correct and safe?
 |  |  | X | 4 | If lockout is required, has the proper procedure been followed?
 |  |  | X | 5 | Do you know the emergency signals?
 |  |  | X | 6 | Do you know the escape routes and assembley points?
 |  |  | X | 7 | Are safety glasses required?
 |  | X |  | 8 | Is a face sheild required?
 |  |  | X | 9 | Is a hard hat required?
 |  | X |  | 10 | Are flame resistant clothes required?
 |  |  | X | 11 | Is hearing protection required?
 |  |  | X | 12 | Are safety toed shoes required?
 |  | X |  | 13 | Are respirators required? |  |  |  |  |  |  |  |  | SIGNATURES:
 |  |  | X | 14 | Is fall protection equipment required?
 |  |  |  | 15 | Other: |  |  |  |  |  |  |  | CUSTOMER:
 |  |  |  |  |  |  |  |  |  |  |  |  | TRI TOOL:
Spreadsheet: 700720d1603302489-if-formula-problems-clin-tracking-base-year-10012020lkf
Sheet: Total Option 3

Base Year | CLIN # | Amount | DATE | [NAME] | OBLIGATED | INVOICED | EXPENDED
10/2018 -09/2019
TO DATE
MOD# |  |  | DATE | AMOUNT | OBLIGATED (PR'S) | INVOICED | EXPENDED
P00001
 | CLIN0003 | 150000
 | CLIN0004 | 1000000
 | CLIN0005 | 10000
 | CLIN0006 | 0
 | CLIN0007 | 10000
 | CLIN0008 | 129000
 | CLIN0009 | 0
PR's pending approval
Total Obligated including pending
Percentage used
Remaining funding
Total ODC Funded
Percentage Used
 | CLIN0003 | CLIN0004 | CLIN0005 | CLIN0006 | CLIN0007 | CLIN0008 | CLIN0009
Total Funding remianing
Spreadsheet: 117578d1312894761-tracking-employee-training-of-completion-and-showing-on-a-graph-example
Sheet: Sheet1

 |  | Data: Monthly % of General Job Run Training Completed by Department
 |  | Department | % Completed in May | % Completed in June | % Completed in July | % Completed in August
 |  | Welding | 0 | 0.73 | 0
 |  | Assembly | 0.23 | 0.26 | 0.05000000000000004
 |  | Shipping | 0.1 | 0.35 | 0.06000000000000005
 |  | Press, Shear, [NAME] | 0.21 | 0.05999999999999998 | 0
 |  | Maintenance | 0 | 0.44 | 0.5
 |  | Quality | 0.02 | 0.58 | 0.82
 |  | Laser | 0.22 | 0.09000000000000001 | 0.85
 |  | Press Brake | 0.13 | 0.1899999999999999 | 0.8
 |  | Toolroom | 0.17 | 0.19 | 0.91
 |  | Engineering | 0 | 0.29 | 0.5
 |  | Estimating | 0 | 0 | 0
 |  | Supervisor/ Manager | 0 | 0.49 | 0.67
 |  | Sales | 0 | 0.11 | 0.25
 |  | HR | 0 | 1 | 1
 |  | Scheduling | 0 | 0 | 0
 |  | Finance | 0 | 0 | 0
 |  | Data: Monthly % of Company Wide General Job Run Training and New Employee Orientation Completed
 |  | Type | % Completed in May | % Completed in June | % Completed in July | % Completed in August
 |  | Company % of General Job Run Training Completed | 0 | 0.4385196031857143 | 0.03
 |  | Company % of New Employee Orientation Completed | 0.14 | 0 | 0 |  | Tyrae [NAME] 7/29/11 and [NAME] hired 8/1/11 have not had new employee orientation
 |  | Data: Monthly % of Weld Certification Completed
 |  | Type | % Completed in May | % Completed in June | % Completed in July | % Completed in August
 |  | % of General Weld Certification Completed | 0 | 0.6898148148148148 | 0
 |  | % of Core Weld Certifcation Completed | 0 | 0 | 0 |  | [NAME] hired 7/14/11 has not been certified
Spreadsheet: 141796d1329456586-polynomial-equation-test
Sheet: DATA

 | AIRFIELD |  |  |  |  | OCG | RWY
 | ELEV |  |  |  |  | CAT C CIRC | 331
 | TEMP | 23 |  |  |  | CAT D CIRC | 880
 | QNH |  |  |  |  | 10NM MSA | 2000
 | WIND |  |  |  |  | 25NM MSA | 3000
 | PRESSURE ALTITUDE | 230
 | ACFT WEIGHT | 14300
 | RWY
 | SLOPE
 | TORA | 7300
 | TODA | 7300
 | STODA
 | TOFLUNC | 2000
 | TOFLCOR
 | TOFL <= TORA
 | TODA > TOFL + 500'
 | V2 CLIMB
Spreadsheet: 858439d1707138483-formula-required-formula-required
Sheet: Sheet1

 |  | HIGHER | LOWER |  | ANSWER
 | PROB - 1 | 5.86 | -21.86 |  |  | IF C AND D COLUMN PRICES ARE -VE THEN ANSWER SHOULD BE REQUIRED HIGHER  (CLMN C ) + LOWER (CLMN D)
 |  | LOWER | HIGHER
 | PROB - 2 | -23.19 | 5.96 |  |  | IF C AND D COLUMN PRICES ARE -VE THEN ANSWER SHOULD BE REQUIRED LOWER (CLMN C) + HIGHER (CLMN D)
 |  | HIGHER | LOWER
 | PROB - 3 | 10 | 5 |  |  | IF C AND D COLUMN PRICE ARE +VE THEN ANSWER SHOULD BE REQUIRED HIGHER  (CLMN C) -  LOWER (CLMN D)
 |  | LOWER | HIGHER
 | PROB - 4 | 5 | 10 |  |  | IF C AND D COLUMN PRICES ARE +VE THEN ANSWER SHOULD BE REQUIRED HIGER  (CLM D) -  LOWER (CLMN C)
Spreadsheet: kam_keiser__18014__Reco!J11
Sheet: Reconciliation

 | Enron North America
 | Business Analysis & Reporting - Portfolio Accounting
 | Income Statement Reconciliation - 2001 YTD
 | Book(s): |  | [NAME]
 | Profit Center |  | 27094
 | Month: |  | 2001-11-30 00:00:00
Mark to Market
 | General [NAME] |  | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 2001-10-01 00:00:00 | 2001-11-01 00:00:00 | 2001-12-01 00:00:00 | Total
 | (company/major/sub/sl) |  | (Inc)/Exp ($'s) | (Inc)/Exp ($'s) | (Inc)/Exp ($'s) | (Inc)/Exp ($'s) | (Inc)/Exp ($'s) | (Inc)/Exp ($'s) | (Inc)/Exp ($'s) | (Inc)/Exp ($'s) | (Inc)/Exp ($'s) | (Inc)/Exp ($'s) | (Inc)/Exp ($'s) | (Inc)/Exp ($'s) | (Inc)/Exp ($'s)
 | 42000000 Mark to Market |  | 0 | 0 | 0 | -259106 | -1028155 | -542261 | 782033 | -108742 | 1204665 | 1187667 | -1629302
 |  |  |  |  |  |  | 0
 | Total MTM Assets/Liability
 | End vs Beginning Bal |  | 0 | 0 | 0
 | MTM Income Per DPR |  | 0 | 0 | 0
 | MTM Variance
Liquidations
 | General [NAME]
 | (company/major/sub/sl) |  | (Inc)/Exp ($'s) | (Inc)/Exp ($'s) | (Inc)/Exp ($'s) | (Inc)/Exp ($'s) | (Inc)/Exp ($'s) | (Inc)/Exp ($'s) | (Inc)/Exp ($'s) | (Inc)/Exp ($'s) | (Inc)/Exp ($'s) | (Inc)/Exp ($'s) | (Inc)/Exp ($'s) | (Inc)/Exp ($'s) | (Inc)/Exp ($'s)
 | 51009600 Broker Fees |  |  |  |  |  |  |  |  |  |  |  | 29317
 | 45016000 Liquidations |  |  |  |  | -9198 | -449298 | -745269 | -171542 | -984040 | -1240940 | -2012927 | 2172494
 | 45015000 Third Party Accr |  |  |  |  |  | -8454 | 241436 | -222830 | -74325 | 61172 | 1324550 | -1321550
 | 45016000 Rho & Drift |  |  |  |  | 172 | 999 | 2346 | 5135 | -838 | -16369 | -10077 | 6884
 | Total Liquidations
 | End vs Beginning Bal |  | 0 | 0 | 0
 | Liquidation Income Per DPR |  | 0 | 0 | 0
 | Liquidation Variance
 | Total Variance
 | TOTAL G/L
 | TOTAL DPR
 | TOTAL [NAME]
 | TOTAL DPR MTM Income |  | 0 | 0 | 0
 | Other G/L Entries |  |  |  |  |  | 1 | -457 | 8973 | 1430 | -1586 | -3034 | 5573
 |  |  |  |  |  |  | 457 | -8973 | -1430 | 1586 | 3034 | -5573
 | Total G/L
Spreadsheet: 64922d1265735490-how-to-unprotect-check-boxes-with-sheet-already-protected-book1
Sheet: Sheet3

 | 0 | 0 | 0
 | Y1 | Y2 | Y3
1 | 3 | 9 | 5 | #N/A | #N/A | #N/A
2 | 3 | 4 | 7 | #N/A | #N/A | #N/A
3 | 4 | 5 | 9 | #N/A | #N/A | #N/A
4 | 5 | 5 | 6 | #N/A | #N/A | #N/A
Spreadsheet: daren_farmer__5891__BmarlUA4
Sheet: HIST

 | Lamar Power Estimate | Bennington BAV | [NAME]
date | Mmbtu | Mmbtu | Mmbtu
2000-05-01 00:00:00 | 0 | 46023 | 46027
2000-05-02 00:00:00 | 0 | 54712 | 53845
2000-05-03 00:00:00 | 0 | 45853 | 45000
2000-05-04 00:00:00 | 0 | 44274 | 43423 |  | Bennington BAV - Confirmed Nom
2000-05-05 00:00:00 | 0 | 39796 | 38323 |  | Lamar Power Deliveries
2000-05-06 00:00:00 | 0 | 51250 | 50252 |  | Estimated UA4 received by HPL (Physical)
2000-05-07 00:00:00 | 0 | 49277 | 50252
2000-05-08 00:00:00 | 0 | 50769 | 50252
2000-05-09 00:00:00 | 0 | 92794 | 97690
2000-05-10 00:00:00 | 0 | 106143 | 98363
2000-05-11 00:00:00 | 0 | 101160 | 101342
2000-05-12 00:00:00 | 0 | 90677 | 90000
2000-05-13 00:00:00 | 0 | 57176 | 57000
2000-05-14 00:00:00 | 0 | 60116 | 57000
2000-05-15 00:00:00 | 1220 | 56063 | 57000
2000-05-16 00:00:00 | 343 | 109310 | 109979
2000-05-17 00:00:00 | 590 | 108441 | 108434
2000-05-18 00:00:00 | 2544 | 155186 | 152325
2000-05-19 00:00:00 | 1987 | 138720 | 136979
2000-05-20 00:00:00 | 1033 | 70305 | 65979
2000-05-21 00:00:00 | 4298 | 67078 | 65979
2000-05-22 00:00:00 | 4920 | 70497 | 65979
2000-05-23 00:00:00 | 11455 | 93398 | 83979
2000-05-24 00:00:00 | 4874 | 92972 | 78979
2000-05-25 00:00:00 | 317 | 92768 | 82979
2000-05-26 00:00:00 | 2967 | 130025 | 122928
2000-05-27 00:00:00 | 6620 | 106955 | 97269
2000-05-28 00:00:00 | 14296 | 116454 | 97269
2000-05-29 00:00:00 | 2369 | 109273 | 97269
2000-05-30 00:00:00 | 4 | 96410 | 97269
Totals