tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 768888d1645190004-a-formula-to-rank-in-descendant-order-if-it-is-greater-than-another-cell-value-rank-if-greater-than-another-cell-value-1-
Sheet: Sheet1

 |  | 2
[NAME] | 4
[NAME] | 4
[NAME] | 2
[NAME] | 2
[NAME] | 5
Sandy | 1
[NAME] | 0
[NAME] | 3
[NAME] | 5
Spreadsheet: 109636d1306434965-sum-vlookups-cakeshoppe-2
Sheet: Dashboard

[NAME]
As of: | 2011-05-26 00:00:00
WTD Starting | 2011-05-23 00:00:00
MTD Starting | 2011-05-01 00:00:00
YTD Starting | 2011-03-01 00:00:00
 |  | WTD |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MTD |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YTD
 |  | [NAME] |  |  | Scheduled Orders |  |  | Response % |  |  | New Customers |  |  | Conversion % |  |  | [NAME] |  |  | Scheduled Intakes |  |  | Response % |  |  | New Patients |  |  | Conversion % |  |  | [NAME] |  |  | Scheduled Intakes |  |  | Response % |  |  | New Patients |  |  | Conversion %
Shoppe |  | Goal | Actual | % to Goal | Goal | Actual | % to Goal | Goal | Actual | % to Goal | Goal | Actual | % to Goal | Goal | Actual | % to Goal | Goal | Actual | % to Goal | Goal | Actual | % to Goal | Goal | Actual | % to Goal | Goal | Actual | % to Goal | Goal | Actual | % to Goal | Goal | Actual | % to Goal | Goal | Actual | % to Goal | Goal | Actual | % to Goal | Goal | Actual | % to Goal | Goal | Actual | % to Goal
Pleasanton |  |  | 30
Walnut Creek
Spreadsheet: 474469d1470763140-looking-for-easy-data-entry-to-output-monthly-calendar-view-zblack2
Sheet: Bookings

Days |  | Cumulative |  | Row | Car_hired | Date | Day_car | Calendar Text
 |  | 0 |  |  |  |  |  |  |  | Group |  | Group | Initative detail | Start Date | End Date
 |  |  |  |  |  |  |  |  |  | Group 1 Activity |  | Group 1 Activity | test1 | 2016-07-10 00:00:00 | 2016-07-25 00:00:00
 |  |  |  |  |  |  |  |  |  | Group 2 Activity |  | Group 2 Activity |  | 2016-07-10 00:00:00 | 2016-07-25 00:00:00
 |  |  |  |  |  |  |  |  |  | Group 3 Activity |  | Group 3 Activity | sample | 2016-07-10 00:00:00 | 2016-07-25 00:00:00
 |  |  |  |  |  |  |  |  |  | Group 4 Activity |  | Group 4 Activity |  | 2016-07-10 00:00:00 | 2016-07-25 00:00:00
 |  |  |  |  |  |  |  |  |  | Group 5 Activity |  | Group 5 Activity |  | 2016-07-10 00:00:00 | 2016-07-25 00:00:00
 |  |  |  |  |  |  |  |  |  | Group 6 Activity |  | Group 2 Activity |  | 2016-08-01 00:00:00 | 2016-08-15 00:00:00
 |  |  |  |  |  |  |  |  |  | Group 7 Activity |  | Group 4 Activity |  | 2016-08-01 00:00:00 | 2016-08-15 00:00:00
 |  |  |  |  |  |  |  |  |  | Group 8 Activity |  | Group 2 Activity |  | 2016-08-01 00:00:00 | 2016-08-15 00:00:00
 |  |  |  |  |  |  |  |  |  | Group 9 Activity |  | Group 4 Activity |  | 2016-08-01 00:00:00 | 2016-08-15 00:00:00
 |  |  |  |  |  |  |  |  |  | Group 10 Activity |  | Group 2 Activity |  | 2016-08-01 00:00:00 | 2016-08-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | Group 7 Activity | test detail | 2016-07-16 00:00:00 | 2016-08-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | Group 10 Activity | test10 | 2016-08-21 00:00:00 | 2017-01-07 00:00:00
Spreadsheet: sally_beck__35039__0417
Sheet: YTD Mgmt Summary

E N R O N   N O R T H   A M E R I C A |  |  |  |  |  |  |  |  |  |  |  | YTD 2000 EARNINGS ESTIMATE
 |  | Margin |  |  |  | Expenses |  |  |  | EBIT
Business Team |  | Actual | Plan | [NAME] |  | Forecast | Plan* | [NAME] |  | Forecast | Plan | [NAME]
Gas Trading
Power Trading
Financial Drift
Financial Trading
Canada
Coal
GRM -  Weather
Emissions
GRM - New Products
Total Trading & Risk Mgt. |  |  |  |  | 129970 |  |  |  |  | -8675 | 129850
East Midstream
West Midstream
Industrial Downstream
Midstream IPP
Mexico
Total Origination |  |  |  |  | 0 |  |  |  |  | 62310 | 39821
Generation Investments
Gas Assets
Gas Assets - Trading
Total Assets |  |  |  |  |  |  |  |  |  | -9167 | -20328
Principal Investing
Energy Investments
CTG Assets
Total Investing |  |  |  |  |  |  |  |  |  | -49969 | 24814
Commercial Transactions Group
Office of the Chairman
Overview
Total Commercial |  |  |  |  |  |  |  |  |  | -21321 | 199411
Group Total
Group Allocated to Teams
Other Interest Related Charges
Capital Charge Offset
ENA EBIT |  |  |  |  |  |  |  |  |  | -45083 | 187598
Interest Expense/(Income)
[NAME] |  |  |  |  |  |  |  |  |  | -53683 | 178998
* Includes Capital Charge & Operating, Direct, and Allocated Expenses
Actual margin changes from: | 1999-12-31 00:00:00
DPR Change:
MPR Change:
Other Margin Changes:
Total Change
Spreadsheet: 840728d1692941961-formula-to-create-list-based-on-filter-test
Sheet: Participant Costing

Client | [NAME]
 | Programs | Times |  | Hours | Apportion | Transport | [NAME]
Program
Total
 |  |  | Group Activities - Standard - Weekday Daytime
 |  |  | Centre Capital Cost
 |  |  | Transport
 |  |  | Transport kms
 |  |  | [NAME]
 |  |  | Weekly Cost of Programs
Spreadsheet: 771695d1646799464-max-quartile-ifs-multiple-criteria-ef-help
Sheet: Sheet1

 |  |  | Select Roles to Include: |  |  | Include Employee? | Employee | Role | Sales |  | [NAME]
 |  |  | SM1 | Yes |  | Yes | Team Member 1 | SM1 | 500 |  | 75th Quartile
 |  |  | SM2 | Yes |  | Yes | Team Member 2 | SM2 | 200 |  | 50th Quartile |  |  | 200
 |  |  | SM3 | Yes |  | Yes | Team Member 3 | SM1 | 300 |  | 25th Quartile |  |  | 300
 |  |  | SM4 | Yes |  | Yes | Team Member 4 | SM5 | 400 |  | Min Value |  |  | 400
 |  |  | SM5 | Yes |  | Yes | Team Member 5 | SM3 | 200 |  |  |  |  | 200
 |  |  | NSM | Yes |  | Yes | Team Member 6 | SM5 | 100 |  |  |  |  | 100
 |  | >>blank |  | No |  | Yes | Team Member 7 | SM4 | 432 |  |  |  |  | 432
 |  |  |  |  |  | Yes | Team Member 8 | SM2 | 24 |  |  |  |  | 24
 |  |  |  |  |  | Yes | Team Member 9 | SM1 | 553 |  |  |  |  | 553
 |  |  |  |  |  | Yes | Team Member 10 | SM4 | 9329 |  |  |  |  | 9329
 |  |  |  |  |  | Yes | Team Member 11 | SM2 | 43 |  |  |  |  | 43
 |  |  |  |  |  | Yes | Team Member 12 | SM4 | 234 |  |  |  |  | 234
 |  |  |  |  |  | Yes | Team Member 13 | SM3 | 2343 |  |  |  |  | 2343
 |  |  |  |  |  | Yes | Team Member 14 | SM5 | 2 |  |  |  |  | 2
 |  |  |  |  |  | Yes | Team Member 15 | NSM | 2434 |  |  |  |  | 2434
 |  |  |  |  |  | Yes | Team Member 16 |  | 434 |  |  |  |  | False
 |  |  |  |  |  | Yes | Team Member 17 | SM2 | 525 |  |  |  |  | 525
 |  |  |  |  |  | Yes | Team Member 18 | SM3 | 62 |  |  |  |  | 62
 |  |  |  |  |  | Yes | Team Member 19 |  | 562 |  |  |  |  | False
 |  |  |  |  |  | Yes | Team Member 20 | NSM | 2 |  |  |  |  | 2
 |  |  |  |  |  | Yes | Team Member 21 | NSM | 546 |  |  |  |  | 546
 |  |  |  |  |  | Yes | Team Member 22 | SM1 | 456 |  |  |  |  | 456
 |  |  |  |  |  | Yes | Team Member 23 | SM5 | 2452 |  |  |  |  | 2452
 |  |  |  |  |  | Yes | Team Member 24 |  | 2456 |  |  |  |  | False
 |  |  |  |  |  | Yes | Team Member 25 | SM3 | 7575 |  |  |  |  | 7575
 |  |  |  |  |  | Yes | Team Member 26 | SM2 | 756 |  |  |  |  | 756
 |  |  |  |  |  | Yes | Team Member 27 | SM5 | 6452 |  |  |  |  | 6452
 |  |  |  |  |  | Yes | Team Member 28 | SM1 | 65 |  |  |  |  | 65
 |  |  |  |  |  | Yes | Team Member 29 | SM1 | 654 |  |  |  |  | 654
 |  |  |  |  |  | Yes | Team Member 30 | SM4 | 4562 |  |  |  |  | 4562
 |  |  |  |  |  | Yes | Team Member 31 | SM2 | 7766 |  |  |  |  | 7766
 |  |  |  |  |  | Yes | Team Member 32 | NSM | 7567 |  |  |  |  | 7567
 |  |  |  |  |  | Yes | Team Member 33 |  | 3 |  |  |  |  | False
 |  |  |  |  |  | Yes | Team Member 34 |  | 35 |  |  |  |  | False
 |  |  |  |  |  | Yes | Team Member 35 | SM3 | 567 |  |  |  |  | 567
 |  |  |  |  |  | Yes | Team Member 36 | SM2 | 3563 |  |  |  |  | 3563
 |  |  |  |  |  | Yes | Team Member 37 | SM1 | 34 |  |  |  |  | 34
 |  |  |  |  |  | Yes | Team Member 38 | SM4 | 545 |  |  |  |  | 545
 |  |  |  |  |  | Yes | Team Member 39 |  | 5453 |  |  |  |  | False
 |  |  |  |  |  | Yes | Team Member 40 | NSM | 34 |  |  |  |  | 34
 |  |  |  |  |  | x
Spreadsheet: 758148d1638698993-finding-date-that-corresponds-to-highest-value-in-range-in-table-covid-19-help
Sheet: SA Stats

 |  |  | FIRST WAVE |  |  |  |  |  |  |  |  | DURATION (DAYS) |  |  |  | SECOND WAVE |  |  |  |  |  |  |  |  | DURATION (DAYS) |  |  |  | THIRD WAVE |  |  |  |  |  |  |  |  | DURATION (DAYS) |  |  |  | FOURTH WAVE |  |  |  |  |  |  |  |  |  |  |  |  | DURATION (DAYS)
 |  |  | START | TOTAL CASES | CASES/ MILLION | TOTAL DEATHS | DEATHS/ MILLION | CASE FATALITY RATE | END | PEAK NUMBER | PEAK DATE | LENGTH  OF WAVE / (TODAY) | DAYS OUT OF WAVE | START OF WAVE TO PEAK  / (TODAY) | PEAK TO END  OF WAVE / (TODAY) | START | TOTAL CASES | CASES/ MILLION | TOTAL DEATHS | DEATHS/ MILLION | CASE FATALITY RATE | END | PEAK NUMBER | PEAK DATE | LENGTH  OF WAVE | OUT OF WAVE | START OF WAVE TO PEAK  / (TODAY) | PEAK TO END  OF WAVE / (TODAY) | START | TOTAL CASES | CASES/ MILLION | TOTAL DEATHS | DEATHS/ MILLION | CASE FATALITY RATE | END | PEAK NUMBER | PEAK DATE | LENGTH  OF WAVE | OUT OF WAVE | START OF WAVE TO PEAK  / (TODAY) | PEAK TO END  OF WAVE / (TODAY) | START | TOTAL CASES | CASES/ MILLION | TOTAL DEATHS | DEATHS/ MILLION | CASE FATALITY RATE | END | PEAK NUMBER | PEAK DATE | PEAK NUMBER DEATHS | PEAK DATE DEATHS | LENGTH  OF WAVE | OUT OF WAVE | START OF WAVE TO PEAK  / (TODAY) | PEAK TO END  OF WAVE / (TODAY)
 | SOUTH AFRICA |  | 2020-06-14 00:00:00 |  |  |  |  |  | 2020-08-25 00:00:00 |  |  |  |  |  |  | 2020-12-02 00:00:00 |  |  |  |  |  | 2021-02-09 00:00:00 |  |  |  |  |  |  | 2021-05-22 00:00:00 |  |  |  |  |  | 2021-09-22 00:00:00 |  |  |  |  |  |  | 2021-12-01 00:00:00 | 43956 | 729.5625029968976 | 94 | 1.560170972829838 | 0.002138502138502139 | 2021-12-04 00:00:00 | 16366 | 2021-12-04 00:00:00 |  |  | 3 | 1 | 3 | 0
 |  | INCREASE IN CASES/MILLION
Spreadsheet: 42010d1240549936-unable-to-input-anything-in-the-table-test-file
Sheet: Sheet1

Field 1 | Field 2 | INPUT | Field 4 | Field 5 | Field 6 | Comments |  | x | 1
System A | Area 1 |  | A |  | 0 |  |  | 2 | 1
 | Area 2 |  | A |  | 0 |  |  | 2 | 1
 | Area 3 |  | A |  | 0 |  |  | 2 | 1
Spreadsheet: 541497d1507320455-list-of-names-multiple-times-outputting-of-appearances-rng
Sheet: l

 |  | [NAME] | [NAME] | [NAME]
 |  | [NAME]
 |  | [NAME] | [NAME]
Spreadsheet: 267fb417-2968-43e7-9cf6-547d81ab4dfb
Sheet: Directions

Weekly Nutrient Calculator
The purpose of this tool is to aid in calculating a weighted average for calories and saturated fat for a five day menu. Following this tab, there are six additional tabs in the Weekly Nutrient Calculator. There is a tab for each day of the week, and information entered in these tabs will pre-populate the weekly tab.
Directions:
Beginning on the Monday tab, fill in the number of planned meals for the day in the teal box at the top of the page. It is imperative that you fill in this box. If you do not, the calculations built into this tool will not function.
Column A | Fill in each entrée or food item from your planned menu for the day. This will include all entrées, sides, fruits, vegetables, desserts, milk choices and condiments that are available to students as part of a reimbursable meal.
Column B | Fill in the serving size for each entrée or food item entered. This information is for your reference only. Therefore, you may enter this information in whatever unit makes sense (cups, ounces, package, each, etc.).
Column C | Fill in the planned number of servings for each entrée or food item entered.
Column D | The weighting factor for each entrée or food item will be calculated automatically.
Column E | Fill in the calories per serving for each entrée or food item entered.
Column F | Fill in the grams of saturated fat for each entrée or food item entered.
Column G | Fill in the milligrams of sodium for each entrée or food item entered. (As Sodium Target 1 will implemented starting in SY 14-15, you may choose to leave this column blank for SY 13-14)
Column I | The weighted calories for each entrée or food item will be calculated automatically.
Column J | The weighted grams of saturated fat for each entrée or food item will be calculated automatically.
Column K | The weighted milligrams of sodium for each entrée or food item will be calculated automatically.
ü | The average daily calories, saturated fat and sodium will be calculated automatically and filled in at the bottom of the page. These values will pre-populate into the [NAME] tab.
ü | Repeat all steps for the Tuesday-Friday tabs.
ü | The Weekly tab will use the daily averages to calculate a weighted weekly average for each nutrient. The weighted weekly calorie average will appear in the darker purple box (B11), and the weighted weekly sodium average will appear in the darker blue box (D11) on this tab.
ü | The weighted weekly averages are used to calculate the percentage of calories from saturated fat, which will appear in the darker orange box (C11) on the [NAME] tab.
* This tool may be used as an aid to check that your planned menus are meeting calorie and saturated fat targets for the National School Lunch Program and School Breakfast Program. However, this is not a replacement for the simplified nutrient assessment in the USDA workbook or an approved nutrient analysis software. This tool may not be submitted as part of the menu certification process.
Spreadsheet: darrell_schoolcraft__7779__imbalsumm0106
Sheet: summary

Index is high - payback should be done on Dollar Valued payables
- payback should be done on Volumetric receivable
- payback should not be done on Dollar valued receivables
- payback should not be done on Volumetric payables
TRANSWESTERN  PIPELINE -   SUMMARY OF OBA BALANCES
Positive = due [NAME]
Negative = due operator |  |  |  |  |  |  |  |  |  |  |  |  |  | index
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SJ
Operator | Dollars | Volume | As of Date | Imbal Type | MS rep | Comments |  |  |  |  |  |  |  | AVG
NNG |  |  |  | Dollar Valued | [NAME] |  |  |  |  |  |  |  |  | NTXPH
[NAME] |  |  |  | Dollar Valued | [NAME] | Keystone - to be cashed out in 7/01
[NAME] |  |  |  | Volumetric | [NAME] | Milagro, [NAME], Valverde, [NAME]
PNM |  |  |  | Dollar Valued | [NAME] | 6,000/day planned makeup during 7/01
Red Cedar |  |  |  | Dollar Valued | [NAME]
NGPL |  |  |  | Volumetric | [NAME]
Amoco Abo |  |  |  | Dollar Valued | [NAME]
Conoco |  |  |  | Dollar Valued | [NAME] | [NAME] and Maljamar
[NAME] |  |  |  | Dollar Valued | [NAME]
El Paso |  |  |  | Volumetric | [NAME] | Blanco and Window Rock
EOG |  |  |  | Dollar Valued | [NAME]
Mewborne |  |  |  | Dollar Valued | [NAME]
CIG |  |  |  | Dollar Valued | [NAME] | being reconciled with CIG
PG&E TX/EPFS |  |  |  | Dollar Valued | [NAME]
Lonestar |  |  |  | Volumetric | [NAME]
Panhandle Eastern |  |  |  | Volumetric | [NAME] | Hansford
Amoco |  |  |  | Volumetric | [NAME]
Agave |  |  |  | Dollar Valued | [NAME]
Northwest |  |  |  | Volumetric | [NAME]
TransColorado |  |  |  | Dollar Valued | [NAME]
Oasis |  |  |  | Volumetric | [NAME]
Duke/GPM |  |  |  | Dollar Valued | [NAME] | Crawford, Pecos Diamond, [NAME], Linam Ranch, Artesia
Mojave Pipeline |  |  |  | Volumetric | [NAME]
Burlington |  |  |  | Dollar Valued | [NAME]
Receivable imbalances
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 79
Operator | Dollars | Volume | As of Date | Imbal Type | MS rep | Comments
Citizens Communications |  |  |  | Dollar Valued | [NAME]
Calpine |  |  |  | Dollar Valued | [NAME]
North Star Steel |  |  |  | Dollar Valued | [NAME]
Citizens-Griffith |  |  |  | Dollar Valued | [NAME]
SoCal |  |  |  | Volumetric | [NAME]
PG&E Topock |  |  |  | Volumetric | [NAME]
El Paso Field Services |  |  |  | Dollar Valued | [NAME]
Continental |  |  |  | Dollar Valued | [NAME]
Payable imbalances
Net imbals
Note -  This report does not represent the total population of imbalances on Transwestern.
Spreadsheet: 101118d1299258956-finding-cell-address-of-last-blank-cell-after-a-value-and-before-another-value-donkeyotes-reply
Sheet: Blad1

 |  |  | 275
0 | 0 |  |  |  | Give me a formula to find the cell address of the last blank cell.
 | 0.5 |  |  |  | So in this example it must be $A$14
 | 0.75
4 | 1
 | 1.2 |  |  |  | << This must be $A$14 instead of $A$4
 | 1.5
 | 2
 | 4
250 | 1
 | 25
 | 16
 | 20
 | 21
300 | 6
 | 12
 | 13
 | 14
400 | 14
Spreadsheet: 761015d1640603471-pq-add-row-with-if-cell-formula-how-8-
Sheet: Blad1

 |  |  |  | In PQ add a new column with this result
 |  |  | PO MES | LF ivm RPM | LF | RPM |  |  | PO MES | LF | RPM |  |  | PO MES | LF | RPM | Aangepast
 |  |  | 2 |  | 8 | 65 |  |  | 2 | 8 | 65 |  |  | 2 | 8 | 65 | 8
 |  |  | 2 |  | 8 | 65 |  |  | 2 | 8 | 65 |  |  | 2 | 8 | 65 | 8
 |  |  | 2 |  | 8 | 65 |  |  | 2 | 8 | 65 |  |  | 2 | 8 | 65 | 8
 |  |  | 3 |  | 8 | 0 |  |  | 3 | 8 | 0 |  |  | 3 | 8 | 0
 |  |  | 3 |  | 9 | 0 |  |  | 3 | 9 | 0 |  |  | 3 | 9 | 0
 |  |  | 3 |  | 9 | 65 |  |  | 3 | 9 | 65 |  |  | 3 | 9 | 65 | 9
 |  |  | 3 |  | 9 | 65 |  |  | 3 | 9 | 65 |  |  | 3 | 9 | 65 | 9
 |  |  | 3 |  | 9 | 65 |  |  | 3 | 9 | 65 |  |  | 3 | 9 | 65 | 9
 |  |  | 3 |  | 9 | 65 |  |  | 3 | 9 | 65 |  |  | 3 | 9 | 65 | 9
 |  |  | 3 |  | 9 | 65 |  |  | 3 | 9 | 65 |  |  | 3 | 9 | 65 | 9
 |  |  | 3 |  | 9 | 0 |  |  | 3 | 9 | 0 |  |  | 3 | 9 | 0
 |  |  | 3 |  | 10 | 0 |  |  | 3 | 10 | 0 |  |  | 3 | 10 | 0
 |  |  | 3 |  | 10 | 0 |  |  | 3 | 10 | 0 |  |  | 3 | 10 | 0
 |  |  | 3 |  | 10 | 0 |  |  | 3 | 10 | 0 |  |  | 3 | 10 | 0
 |  |  | 4 |  | 10 | 65 |  |  | 4 | 10 | 65 |  |  | 4 | 10 | 65 | 10
 |  |  | 4 |  | 10 | 65 |  |  | 4 | 10 | 65 |  |  | 4 | 10 | 65 | 10
 |  |  | 4 |  | 10 | 65 |  |  | 4 | 10 | 65 |  |  | 4 | 10 | 65 | 10
 |  |  | 4 |  | 10 | 65 |  |  | 4 | 10 | 65 |  |  | 4 | 10 | 65 | 10
 |  |  | 4 |  | 10 | 65 |  |  | 4 | 10 | 65 |  |  | 4 | 10 | 65 | 10
 |  |  | 4 |  | 10 | 65 |  |  | 4 | 10 | 65 |  |  | 4 | 10 | 65 | 10
Spreadsheet: 775891d1649363563-using-a-location-reference-combine-information-from-two-tabs-into-a-consolidated-list-test-worksheet
Sheet: FGE Store List

VP | VPEmail | Region | RDO | RM | DM | GM | Location Code | State Abbr | Column1 | Column2 | Column3 | Column4 | Column5 | Column6
[NAME] | [EMAIL] | Region 2 | [NAME] | [NAME] | [NAME] | 15 Manager | 000015 | VA
[NAME] | [EMAIL] | Region 3 | [NAME] | [NAME] | [NAME] | DE-0019 Manager | 000019 | DE
[NAME] | [EMAIL] | Region 3 | [NAME] | [NAME] | [NAME] | VA-20 Manager | 000020 | VA
[NAME] | [EMAIL] | Region 3 | [NAME] | [NAME] | [NAME] | DE-31 Manager | 000031 | DE
[NAME] | [EMAIL] | Region 1 | Alc | [NAME] | [NAME] | SC | 000034 | SC
[NAME] | [EMAIL] | Region 2 | [NAME] | [NAME] | [NAME] | NC-38 Manager | 000038 | NC
[NAME] | [EMAIL] | Region 2 | [NAME] | [NAME] | [NAME] | NC-49 Manager | 000049 | NC
[NAME] | [EMAIL] | Region 4 | Alc | Will | Scott | NY | 000052 | NY
[NAME] | [EMAIL] | Region 3 | [NAME] | [NAME] | [NAME] | MD-53 Manager | 000053 | MD
[NAME] | [EMAIL] | Region 1 | Alc | [NAME] | [NAME] | NC | 000057 | NC
[NAME] | [EMAIL] | Region 3 | [NAME] | [NAME] | [NAME] | MD-60 Manager | 000060 | MD
[NAME] | [EMAIL] | Region 4 | Alc | Will | Kurt | PA | 000061 | PA
[NAME] | [EMAIL] | Region 2 | [NAME] | [NAME] | [NAME] | SC-63 Manager | 000063 | SC
[NAME] | [EMAIL] | Region 2 | [NAME] | [NAME] | [NAME] | 64 Manager | 000064 | VA
[NAME] | [EMAIL] | Region 3 | [NAME] | [NAME] | [NAME] | MD-68 Manager | 000068 | MD
[NAME] | [EMAIL] | Region 2 | [NAME] | [NAME] | [NAME] | SC-72 Manager | 000072 | SC
[NAME] | [EMAIL] | Region 4 | Alc | Will | Kurt | PA | 000076 | PA
[NAME] | [EMAIL] | Region 2 | [NAME] | [NAME] | [NAME] | SC-77 Manager | 000077 | SC
[NAME] | [EMAIL] | Region 3 | [NAME] | [NAME] | [NAME] | MD-80 Manager | 000080 | MD
[NAME] | [EMAIL] | Region 3 | [NAME] | [NAME] | [NAME] | VA-88 Manager | 000088 | VA
[NAME] | [EMAIL] | Region 2 | [NAME] | [NAME] | [NAME] | NC-89 Manager | 000089 | NC
[NAME] | [EMAIL] | Region 1 | Alc | [NAME] | [NAME] | SC | 000091 | SC
[NAME] | [EMAIL] | Region 6 | Todd | Jeremy | Mistry | nc | 002021 | ND
[NAME] | [EMAIL] | Region 6 | Todd | Jeremy | Mistry | MN-2030 Manager | 002030 | MN
Spreadsheet: errol_mclaughlin_jr__10092__Trades 1214
Sheet: Mann

Trades | 2001-12-14 00:00:00
 |  |  |  |  |  | Clearing | Executing
Check | Month | Strike | C/P | Volume | Price | Broker | Broker
x | 2002-02-01 00:00:00 | 4.5 | P | -25 | 1.707 | [NAME] | Clarion
x | 2002-02-01 00:00:00 | - | Futures | -23 | 2.83 | [NAME] | Clarion
x | 2002-04-01 00:00:00 | 4.55 | P | -25 | 1.785 | [NAME] | Clarion
x | 2002-04-01 00:00:00 | - | Futures | -23 | 2.8 | [NAME] | Clarion
x | 2002-02-01 00:00:00 | 5.5 | P | -25 | 2.675 | [NAME] | Clarion
x | 2002-02-01 00:00:00 | - | Futures | -24 | 2.83 | [NAME] | Clarion
x | 2002-04-01 00:00:00 | 3.25 | C | 10 | 0.215 | [NAME] | Clarion
x | 2002-04-01 00:00:00 | - | Futures | -4 | 2.8 | [NAME] | Clarion
x | 2002-02-01 00:00:00 | 4.5 | C | 25 | 0.05 | [NAME] | Clarion
x | 2002-02-01 00:00:00 | - | Futures | -3 | 2.83 | [NAME] | Clarion
x | 2002-03-01 00:00:00 | 4.7 | C | 50 | 0.07 | [NAME] | Clarion
x | 2002-05-01 00:00:00 | 4.5 | C | 50 | 0.08 | [NAME] | Clarion
x | 2002-04-01 00:00:00 | 5 | C | 20 | 0.037 | [NAME] | Clarion
x | 2002-03-01 00:00:00 | 5.25 | C | 100 | 0.045 | [NAME] | Clarion
x | 2002-06-01 00:00:00 | 5 | C | 40 | 0.07 | [NAME] | Clarion
x | 2002-09-01 00:00:00 | 5 | C | 30 | 0.145 | [NAME] | Clarion
x | 2002-12-01 00:00:00 | 5 | C | 30 | 0.305 | [NAME] | Clarion
x | 2002-04-01 00:00:00 | 6 | C | -10 | 0.017 | [NAME] | Clarion
x | 2002-06-01 00:00:00 | 6 | C | -20 | 0.035 | [NAME] | Clarion
x | 2002-09-01 00:00:00 | 6 | C | 30 | 0.095 | [NAME] | Clarion
x | 2002-12-01 00:00:00 | 6 | C | 30 | 0.21 | [NAME] | Clarion
x | 2003-09-01 00:00:00 | 3.1 | C | -25 | 0.56 | [NAME] | Clarion
x | 2003-09-01 00:00:00 | 3.1 | P | -25 | 0.555 | [NAME] | Clarion
x | 2004-03-01 00:00:00 | 3.3 | C | 50 | 0.7 | [NAME] | Clarion
x | 2004-03-01 00:00:00 | 3.3 | P | 50 | 0.695 | [NAME] | Clarion
x | 2004-03-01 00:00:00 | 3 | P | -100 | 0.5 | [NAME] | Clarion
x | 2004-03-01 00:00:00 | - | Futures | -40 | 3.35 | [NAME] | Clarion
x | 2002-02-01 00:00:00 | 10 | C | -100 | 0.001 | [NAME] | Clarion
x | 2002-03-01 00:00:00 | 10 | C | 100 | 0.006 | [NAME] | Clarion
Spreadsheet: darron_c_giron__8013__Physical Spreadsheet
Sheet: April

Enron Midwest NSS Program I and Program II
April Physical Gas (Transactions with ENA and Transactions with PGLC)
2000-05-10 00:00:00
Transaction |  | Buy or Sell |  |  | Daily | Total Monthly | Price Per | Total Purchase | EMW
Date | Counterparty | EMW Perspective | Program | Location | Volume | Volume | MMBTU | or Sale | Sitara
2000-03-29 00:00:00 | ENA | B | II | Louisiana | 15255 |  | 2.855
2000-03-29 00:00:00 | ENA | B | II | Midcontinent | 5085 |  | 2.805
2000-03-03 00:00:00 | ENA | B | I | Louisiana | 7620 |  | 2.7925
2000-03-03 00:00:00 | ENA | B | I | Midcontinent | 2540 |  | 2.725
2000-03-03 00:00:00 | ENA | B | I | Louisiana | 12504 |  | 2.785
2000-03-03 00:00:00 | ENA | B | I | Midcontinent | 4168 |  | 2.72
2000-04-08 00:00:00 | ENA | S | II | Louisiana | 1000 |  | 2.94
 | ENA Total
2000-03-29 00:00:00 | PGLC | S | II | Louisiana | 15255 |  | 2.855 |  | 233209
2000-03-29 00:00:00 | PGLC | S | II | Midcontinent | 5085 |  | 2.805 |  | 233218
2000-03-03 00:00:00 | PGLC | S | I | Louisiana | 7620 |  | 2.7925 |  | 233096
2000-03-03 00:00:00 | PGLC | S | I | Midcontinent | 2540 |  | 2.725 |  | 233127
2000-03-03 00:00:00 | PGLC | S | I | Louisiana | 12504 |  | 2.785 |  | 233142
2000-03-03 00:00:00 | PGLC | S | I | Midcontinent | 4168 |  | 2.72 |  | 233147
2000-04-08 00:00:00 | PGLC | B | II | Louisiana | 1000 |  | 2.94 |  | 264696
2000-04-08 00:00:00 | PGLC | B | II | Louisiana | 1500 |  | 2.97 |  | 264699
2000-04-27 00:00:00 | PGLC | S | II | TXOK | 333 |  | 3.035 |  | 253409
 | PGLC Total
 | Grand Total
Non Program Buys and Sells to PGLC
2000-04-08 00:00:00 | PGLC | S | II | Louisiana | 1500 |  | 2.97 |  | 264702
2000-04-27 00:00:00 | PGLC | B | II | TXOK | 333 |  | 3.035 |  | 264704
Spreadsheet: 672346d1586836276-copy-rows-to-another-sheet-when-a-criteria-is-met-example-1-
Sheet: Defects

(Below are the expected results)
Test | Mapping | Expected Results | Results | Status | Date Tested | Scenario # | Item # | Tester | Comments | Other