tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 141240d1329164085-excel-2007-how-to-grab-information-from-other-sheets-and-place-it-in-the-main-sheet-fulllist2
Sheet: Cricket

Event (select from dropdown list) | Team Name | Level of Play | First Name | Last Name | Concatenate | Capt(*) | Sex | Date of Birth | Address | Suburb | State(abbr) | Postcode | Phone # | [NAME] | [NAME] | Golf Club | Squash Grade |  |  | Preferred Day | Time | Rego/Soc | Business Unit | Employee# | T-Shirt Size | Cheque | Cash | Direct Deb | Total |  | Notes
 |  |  | Test1 | Test1 | Test1 Test1 |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  | Test2 | Test2 | Test2 Test2 |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  | Test3 | Test3 | Test3 Test3 |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  | Test4 | Test4 | Test4 Test4 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | xl
 |  |  | Test5 | Test5 | Test5 Test5 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | Test6 | Test6 | Test6 Test6 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | [NAME] | [NAME] | [NAME] |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | Test8 | Test8 | Test8 Test8 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  | Test9 | Test9 | Test9 Test9 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  | Test10 | Test10 | Test10 Test10 |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  | Test11 | Test11 | Test11 Test11 |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | Test12 | Test12 | [NAME] |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  | Test13 | Test13 | Test13 Test13 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  | Test14 | Test14 | Test14 Test14 |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | xl
 |  |  | Test15 | Test15 | Test15 Test15 |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | Test16 | Test16 | Test16 Test16 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | Test17 | Test17 | [NAME] |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | Test18 | Test18 | Test18 Test18 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  | Test19 | Test19 | Test19 Test19 |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  | Test20 | Test20 | Test20 Test20 |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | xl
 |  |  | Test21 | Test21 | Test21 Test21 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | Test22 | Test22 | [NAME] |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | Test23 | Test23 | Test23 Test23 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | Test24 | Test24 | Test24 Test24 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  | [NAME] | [NAME] | [NAME] |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 858074d1706848689-table-cross-referencing-table-cross-referencing-dj
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | Choose number: | Output: |  | Choose Letter: | Output:
Argos | - |  |  |  |  |  |  |  |  |  |  | 8 |  |  | Currys
Boots |  |  |  |  |  |  |  |  | - | - |  |  | E |  |  | 4
Currys |  | - |  | - |  | - |  |  |  | - |  |  | G |  |  | 6
Decathlon |  |  |  | - |  |  |  | - |  |  |  |  |  |  |  | 10
Ebay | - | - | - |  |  | - |  | -
Fanta
Gatorade |  |  |  | - |  | - |  | - |  | -
Spreadsheet: 845819d1697155542-find-quantity-on-orders-looking-up-part-code-and-order-refs-on-separate-sheets-label-stock-example
Sheet: Orders

Customer | Order ref | Product part code | Description | Packs | Packs UQ | Qty Ordered | UQ
Customer 001 | 5007 | AAA0032 |  | 100 | Unit | 100 | Unit
Customer 001 | 5008 | AAA0035 |  | 500 | Unit | 500 | Unit
Customer 001 | 5008 | AAA0066 |  | 50 | Unit | 50 | Unit
Customer 002 | 5009 | AAA0001 |  | 100 | Unit | 100 | Unit
Customer 002 | 5009 | AAA0005 |  | 500 | Unit | 500 | Unit
Customer 002 | 5009 | AAA0067 |  | 50 | Unit | 50 | Unit
Spreadsheet: 167100d1341901330-filtering-one-specific-name-in-excel-2010-copy-of-morning-attendance-2-
Sheet: 31 Jan 2012

Daily Morning Staff |  |  |  |  | Tuesday
 | 07:30-14:30 |  | 2012-01-31 00:00:00
Name | Staff No. | Title | Time In | Out | Locations | Remarks
Naima Mohamed | 2166 | Client Ralation Supervisor | 07:30:00 | 14:30:00 | EFS
Sheikha [NAME] | 2120 | Reservation Officer | 07:30:00 | 14:30:00 | TOPS
Syed Sultan | 2888 | Supervisor | 07:30:00 | 14:30:00 | EFS
[NAME] | 4143 | Aircraft Team Leader | 07:00:00 | 14:30:00 | EFS
Jalil Nushadi | 1889 | Driver | 05:45:00 | 14:30:00 | EFS
[NAME] | 624 | Driver |  |  | EFS | Annual
Soud Sharar | 2097 | [NAME] Officer | 07:30:00 | 14:30:00 | [NAME]
[NAME] | 1897 | Manager | 07:30:00 | 14:30:00 | EFS
[NAME] | 1861 | Duty Officer | 07:30:00 | 14:30:00 | EFS
Spreadsheet: 680909d1591251551-combining-2-lists-in-2-separate-sheet-into-1-list-on-the-third-sheet-example
Sheet: Data 2

2020 Sales
Client# | Product # | Numer Sold
A | A1 | 10
A | A2 | 15
C | A1 | 5
C | A2 | 1
C | A3 | 5
D | A2 | 10
D | A3 | 5
Spreadsheet: 767308d1644403894-need-help-to-get-the-count-based-on-criteria-sample-1
Sheet: Sheet40

Count of Status | Column Labels
Row Labels | Duplicate | No Show | Not Interested | Not Suitable | Not Yet Scheduled | Offer Accepted | [NAME] | Rejected (1st) | Rejected (2nd) | Rejected (Final) | Rejected-Online Test | Reschedule | Scheduled | Grand Total
2020 | 2 | 4 | 9 | 2 |  | 2 | 2 | 13 | 2 |  |  |  |  | 36
2021 | 16 | 32 | 34 | 68 | 6 | 9 | 4 | 68 | 8 | 4 | 26 | 1 | 4 | 280
Jan | 3 | 2 | 2 | 7 |  |  | 1 | 11 | 1 |  |  |  |  | 27
Feb | 1 | 5 | 2 | 3 |  |  |  | 8 | 2 |  |  |  |  | 21
Mar | 1 | 2 | 4 | 11 |  | 1 |  | 9 | 1 |  | 5 |  |  | 34
Apr | 6 | 4 | 7 | 18 |  | 4 |  | 12 | 1 | 2 | 9 |  |  | 63
May |  | 3 | 1 | 1 |  | 1 |  | 1 |  | 1 | 1 |  |  | 9
Jun | 1 | 2 | 2 | 1 |  |  | 1 | 4 | 1 |  | 3 |  |  | 15
Jul | 2 | 9 | 15 | 16 | 2 | 2 | 1 | 14 | 2 |  | 6 |  |  | 69
Aug | 2 | 5 | 1 | 10 | 4 | 1 | 1 | 9 |  | 1 | 2 | 1 |  | 37
Sep |  |  |  | 1 |  |  |  |  |  |  |  |  | 4 | 5
Grand Total | 18 | 36 | 43 | 70 | 6 | 11 | 6 | 81 | 10 | 4 | 26 | 1 | 4 | 316
Spreadsheet: 129491d1321633449-get-the-nearest-address-according-to-zipcode-nearest-site
Sheet: PoPs

Zip/Postal Code | Site Id | Address | Suite / Demark | City | St/Prov | NPA-NXX |  |  | Customer ZipCoe |  | 1st_Nearest_Site | 2nd_Nearest_Site | 3rd_Nearest_Site | 4th_Nearest_Site
10011 | NYCT02 |  |  |  |  |  |  |  | 447823 |  | BOST01 | ANCT01 | SEAT01 | EWRL02
19108 | PHLX01 |  |  |  |  |  |  |  | 60089-4507 |  | CHIT01 | MIAL01 | ATLX01 | CHIX01
20171 | IADX01 |  |  |  |  |  |  |  | 30022 |  | ATLT02 | IADX01 | PHLX01 | MIAT01
30339 | ATLT02 |  |  |  |  |  |  |  | 33044 |  | MIAT01 | ATLT02 | IADX01 | TULT01
33126 | MIAT01 |  |  |  |  |  |  |  | 60173- |  | CHIT01 | MIAL01 | ATLX01 | CHIX01
74134 | TULT01 |  |  |  |  |  |  |  | 60173 |  | TULT01 | MIAT01 | ATLT02 | HOUX01
77041 | HOUX01 |  |  |  |  |  |  |  | 96880 |  | SEAF01 | HNLT01 | SFOL01 | SEAT01
90245 | LAXT01 |  |  |  |  |  |  |  | 99815 |  | BOST01 | ANCT01 | SEAT01 | EWRL02
94107 | SFOL01
96819 | HNLT01
98109 | SEAF01
98188 | SEAT01
99502 | ANCT01
02110-1010 | BOST01
07094-1908 | EWRL02
30312-1705 | ATLX01
33132-1715 | MIAL01
60176-1203 | CHIT01
60607-3621 | CHIX01
75201-4143 | [NAME]
80111-8177 | DENT01
80203-1424 | DENF01
Spreadsheet: 167536d1342020321-expanding-a-formula-to-display-content-on-more-variables-actcasinotracking-expanded-2-
Sheet: Search

ACT Casino Tracking
Shopper Dept: | All
Shopper EID: | 1211 |  | < This number will be typed in.
TM Dept: | All |  | < This will be selected from a drop down menu.
TM EID: |  |  | < This number will be typed in.
ACT: | All |  | < This will be selected from a drop down menu.
Appearance: | All |  | < This will be selected from a drop down menu.
Pass: | All |  | < This will be selected from a drop down menu.
Comments: |  |  | < This is a phrase that will be typed in, such as the word "nice" it will search for any comments with that phrase in it.
Track Back Days:
Custom Start Date:
Custom End Date:
Entries:
Shopper Dept | Shopper Last Name | Shopper EID | TM Dept | TM Last Name | TM EID | A | C | T | ACT | Appearance | Pass All | Date | Comments
Spreadsheet: 740643d1626435037-using-multiple-if-functions-with-vlookup-2023-cohort
Sheet: Cohort

Teacher |  |  | Date |  |  |  | Date |  |  |  | Date |  |  |  | Date |  |  |  | Date |  |  |  | Date |  |  |  | Date |  |  |  | Date
 |  |  | Type (L/S/R/W) | L |  |  | Type (L/S/R/W) |  |  |  | Type (L/S/R/W) |  |  |  | Type (L/S/R/W) |  |  |  | Type (L/S/R/W) |  |  |  | Type (L/S/R/W) |  |  |  | Type (L/S/R/W) |  |  |  | Type (L/S/R/W)
 |  |  | Title |  |  |  | Title |  |  |  | Title |  |  |  | Title |  |  |  | Title |  |  |  | Title |  |  |  | Title |  |  |  | Title
Name |  | TIER | Out of | 20 | % | Grade | Out of |  | % | Grade | Out of |  | % | Grade | Out of |  | % | Grade | Out of |  | % | Grade | Out of |  | % | Grade | Out of |  | % | Grade | Out of |  | % | Grade
student name | W | H |  | 9
student name | W
student name | X
student name | W
student name | X
student name | W
student name | X
student name | W
student name | W
student name | X
student name | X
student name | W
student name | W
student name | X
student name | W
student name | W
student name | X
student name | X
student name | X
student name | W
student name | W
student name | X
student name | X
student name | X
student name | X
student name | X
student name | W
student name | X
student name | X
student name | W
student name | X
Spreadsheet: 275879d1383671386-age-range-formula-counting-blank-cells-copy-of-age-range
Sheet: Sheet1

 | DOB | Age
 | 1956-08-19 00:00:00 |  |  | Range | Count |  | Count
 | 1956-08-20 00:00:00 |  |  | 17 |  | From 0 to 17 Years
 | 1956-08-21 00:00:00 |  |  | 24 |  | From 18 to 24 Years
 | 1990-07-20 00:00:00 |  |  | 29 |  | From 25 to 29 Years
 | 1970-06-06 00:00:00 |  |  | 34 |  | From 30 to 34 Years
 | 1934-05-05 00:00:00 |  |  | 39 |  | From 35 to 39 Years
 | 1980-01-06 00:00:00 |  |  | 44 |  | From 40 to 44 Years
 | 1979-10-01 00:00:00 |  |  | 49 |  | From 45 to 49 Years
 | 1956-12-01 00:00:00 |  |  | 59 |  | From 50 to 59 Years
 | 1948-03-14 00:00:00 |  |  | 64 |  | From 60 to 64 Years
 | 1946-09-13 00:00:00 |  |  | 65 |  | 65 Years and over
 | 1964-11-17 00:00:00
 | 1986-12-15 00:00:00
Spreadsheet: 15df561b-a008-4ae9-9ab9-62a7b276eca8
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6861 | 8083 | [NAME] | Little | USA | 661 | 00:00:00 | 00:00:00 | 04:54:05 | 00:05:32 | 03:16:46 | 1 | 08:16:22
6861 | 19333 | [NAME] | Poffenroth | CAN | 663 | 00:00:00 | 00:00:00 | 05:06:39 | 00:07:12 | 03:50:19 | 2 | 09:04:11
6861 | 54022 | [NAME] | Morrison | USA | 662 | 00:00:00 | 00:00:00 | 05:32:11 | 00:06:40 | 03:59:16 | 3 | 09:38:07
6861 | 54020 | [NAME] | [NAME] | USA | 659 | 00:00:00 | 00:00:00 | 05:51:25 | 00:09:41 | 04:09:52 | 4 | 10:10:58
Spreadsheet: 169ddf41-952d-484a-a44d-727ef057cb92
Sheet: Labor Force

Country | Time | Source | Method | Notes
Middle East
Bahrain | 1960 - 2010 | WDI | Levels
 | 2011 - 2013 | IDB | Population Growth
Iran | 1960 - 2010 | WDI | Levels
 | 2011 - 2013 | IDB | Population Growth
Iraq | 1960 - 2010 | WDI | Levels
 | 2011 - 2013 | IDB | Population Growth
Jordan | 1960 - 2010 | WDI | Levels
 | 2011 - 2013 | IDB | Population Growth
Kuwait | 1960 - 1991 | WDI | Levels
 | 1992 - 1995 | IDB | Population Growth
 | 1996 - 2010 | WDI | Growth
 | 2011 - 2013 | IDB | Population Growth
Oman | 1960 - 2010 | WDI | Levels
 | 2011 - 2013 | IDB | Population Growth
Qatar | 1960 - 2010 | WDI | Levels
 | 2011 - 2013 | IDB | Population Growth
Saudi Arabia | 1960 - 2010 | WDI | Levels
 | 2011 - 2013 | IDB | Population Growth
Syria | 1960 - 2010 | WDI | Levels
 | 2011 - 2013 | IDB | Population Growth
United Arab Emirates | 1960 - 2010 | WDI | Levels
 | 2011 - 2013 | IDB | Population Growth
Yemen | 1960 - 2010 | WDI | Levels
 | 2011 - 2013 | IDB | Population Growth
Africa
Algeria | 1960 - 2010 | WDI | Levels
 | 2011 - 2013 | IDB | Population Growth
Angola | 1960 - 2010 | WDI | Levels
 | 2011 - 2013 | IDB | Population Growth
[NAME] | 1960 - 2010 | WDI | Levels
 | 2011 - 2013 | IDB | Population Growth
Cameroon | 1960 - 2010 | WDI | Levels
 | 2011 - 2013 | IDB | Population Growth
Democratic Republic of Congo | 1960 - 2010 | WDI | Levels
 | 2011 - 2013 | IDB | Population Growth
Cote d'Ivoire | 1960 - 2010 | WDI | Levels
 | 2011 - 2013 | IDB | Population Growth
Egypt | 1960 - 2010 | WDI | Levels
 | 2011 - 2013 | IDB | Population Growth
Ethiopia | 1960 - 2010 | WDI | Levels
 | 2011 - 2013 | IDB | Population Growth
Ghana | 1960 - 2010 | WDI | Levels
 | 2011 - 2013 | IDB | Population Growth
Kenya | 1960 - 2010 | WDI | Levels
 | 2011 - 2013 | IDB | Population Growth
Madagascar | 1960 - 2010 | WDI | Levels
 | 2011 - 2013 | IDB | Population Growth
[NAME] | 1960 - 2010 | WDI | Levels
 | 2011 - 2013 | IDB | Population Growth
[NAME] | 1960 - 2010 | WDI | Levels
 | 2011 - 2013 | IDB | Population Growth
Morocco | 1960 - 2010 | WDI | Levels
 | 2011 - 2013 | IDB | Population Growth
Mozambique | 1960 - 2010 | WDI | Levels
 | 2011 - 2013 | IDB | Population Growth
[NAME] | 1960 - 2010 | WDI | Levels
 | 2011 - 2013 | IDB | Population Growth
Nigeria | 1960 - 2010 | WDI | Levels
 | 2011 - 2013 | IDB | Population Growth
Senegal | 1960 - 2010 | WDI | Levels
 | 2011 - 2013 | IDB | Population Growth
South Africa | 1960 - 2010 | WDI | Levels
 | 2011 - 2013 | IDB | Population Growth
Sudan | 1960 - 2010 | WDI | Levels
 | 2011 - 2013 | IDB | Population Growth
Tanzania | 1960 - 2010 | WDI | Levels
 | 2011 - 2013 | IDB | Population Growth
Tunisia | 1960 - 2010 | WDI | Levels
 | 2011 - 2013 | IDB | Population Growth
Uganda | 1960 - 2010 | WDI | Levels
 | 2011 - 2013 | IDB | Population Growth
Zambia | 1960 - 2010 | WDI | Levels
 | 2011 - 2013 | IDB | Population Growth
Zimbabwe | 1960 - 2010 | WDI | Levels
 | 2011 - 2013 | IDB | Population Growth
Spreadsheet: 14f98333-1e86-4eb9-843c-7e60778d3b93
Sheet: LFG

PETRON
LAFARGE- CHITORGARH
 |  | 2011 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012
S.NO. | ITEM DECRIPTION | 2011-01-01 00:00:00 |  | 2011-02-02 00:00:00 |  | 2011-03-06 00:00:00 |  | 2011-04-07 00:00:00 |  | 2011-05-09 00:00:00 |  | 2011-06-10 00:00:00 |  | 2011-07-12 00:00:00 |  | 2011-08-13 00:00:00 |  | 2011-09-14 00:00:00 |  | 2011-10-16 00:00:00 |  | 2011-11-17 00:00:00 |  | 2011-12-19 00:00:00
 |  | DATE | UNIT RATE (RS.) | DATE | UNIT RATE (RS.) | DATE | UNIT RATE (RS.) | DATE | UNIT RATE (RS.) | DATE | UNIT RATE (RS.) | DATE | UNIT RATE (RS.) | DATE | UNIT RATE (RS.) | DATE | UNIT RATE (RS.) | DATE | UNIT RATE (RS.) | DATE | UNIT RATE (RS.) | DATE | UNIT RATE (RS.) | DATE | UNIT RATE (RS.)
1
Spreadsheet: 116498d1311869171-countifs-results-excluding-duplicates-book2
Sheet: Sheet2

 |  | Desired result | Course_Num | Year_Per | St_Date
S-V80-A |  | 5 | S-V80-A | Year1 | 2011-01-01 00:00:00
S-V96-B |  | 3 | S-V80-A | Year1 | 2011-01-01 00:00:00
 |  |  | S-V80-A | Year1 | 2011-01-01 00:00:00
 |  |  | S-V80-A | Year1 | 2011-01-01 00:00:00
 |  |  | S-V80-A | Year1 | 2011-01-01 00:00:00
 |  |  | S-V80-A | Year1 | 2011-02-01 00:00:00
 |  |  | S-V80-A | Year1 | 2011-02-01 00:00:00
 |  |  | S-V80-A | Year1 | 2011-02-01 00:00:00
 |  |  | S-V80-A | Year1 | 2011-02-01 00:00:00
 |  |  | S-V80-A | Year1 | 2011-02-01 00:00:00
 |  |  | S-V80-A | Year1 | 2011-03-01 00:00:00
 |  |  | S-V80-A | Year1 | 2011-03-01 00:00:00
 |  |  | S-V80-A | Year1 | 2011-03-01 00:00:00
 |  |  | S-V80-A | Year1 | 2011-03-01 00:00:00
 |  |  | S-V80-A | Year1 | 2011-03-01 00:00:00
 |  |  | S-V80-A | Year1 | 2011-04-01 00:00:00
 |  |  | S-V80-A | Year1 | 2011-04-01 00:00:00
 |  |  | S-V80-A | Year1 | 2011-04-01 00:00:00
 |  |  | S-V80-A | Year1 | 2011-04-01 00:00:00
 |  |  | S-V80-A | Year1 | 2011-04-01 00:00:00
 |  |  | S-V80-A | Year1 | 2011-05-01 00:00:00
 |  |  | S-V80-A | Year1 | 2011-05-01 00:00:00
 |  |  | S-V80-A | Year1 | 2011-05-01 00:00:00
 |  |  | S-V80-A | Year1 | 2011-05-01 00:00:00
 |  |  | S-V80-A | Year1 | 2011-05-01 00:00:00
 |  |  | S-V96-B | Year1 | 2011-09-01 00:00:00
 |  |  | S-V96-B | Year1 | 2011-09-01 00:00:00
 |  |  | S-V96-B | Year1 | 2011-09-01 00:00:00
 |  |  | S-V96-B | Year1 | 2011-10-01 00:00:00
 |  |  | S-V96-B | Year1 | 2011-10-01 00:00:00
 |  |  | S-V96-B | Year1 | 2011-10-01 00:00:00
 |  |  | S-V96-B | Year1 | 2011-11-01 00:00:00
 |  |  | S-V96-B | Year1 | 2011-11-01 00:00:00
 |  |  | S-V96-B | Year1 | 2011-11-01 00:00:00
Spreadsheet: 690031d1596810868-elapsed-workday-minutes-between-2-date-timestamps-sample
Sheet: Sheet1

UniqueID | EntryTime | Response Date
17028499623 | 3/2/2020 5:59:32 PM | 3/2/2020 6:05:42 PM
55198359414 | 3/3/2020 7:11:04 AM | 3/3/2020 7:11:18 AM
64936242032 | 3/3/2020 8:39:06 AM | 3/3/2020 8:54:12 AM
80850295561 | 3/3/2020 3:32:39 PM | 3/3/2020 3:32:52 PM
866741611 | 3/16/2020 3:45:24 PM | 3/17/2020 6:11:24 AM
76570045712 | 3/22/2020 1:17:12 PM | 3/30/2020 2:07:19 PM
12391889300 | 4/19/2020 2:36:44 PM | 5/19/2020 6:54:18 AM
Spreadsheet: phillip_m_love__30713__200009_OA
Sheet: EAST-EGM-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 115390018 | 552262107
2 |  | Liquidations
3 |  | Interdesk | 94289528 | 478297973
4 |  | Option Premiums | 0 | 328693
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 209679546 | 1030888773
 | Purchases:
6 |  | 3rd Party / Inter Enron | -125159045 | -587897917
7 |  | Liquidations
8 |  | Interdesk | -85943454 | -433469456
9 |  | Option Premiums
10 |  | [NAME] | 527887 | 2631825
 | Total Purchases: |  | -210574612 | -1018735548
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 | Imbalances:
13 |  | In Kind | 28856 | 154255
14 |  | Cash Out | 738220 | 3077467
15 |  | Cash In | -671117 | -3209533
16 |  | Synthetic Storage | -359961 | 3993212
 | Total Imbalances: |  | -264002 | 4015401
 | Storage:
17 |  | Injection (Sales to Stg) | 1324662 | 6109948
18 |  | W/D (Purchase from Stg) | -792900 | -3660171
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -792900 | -3660171
 | Total Storage: |  | 531762 | 2449777
20 | Linepack: |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
22 | UA4: |  | 627306 | 2869924.95
23 | Fuel: |  | -527887 | -2631825
 | Transport Expense:
24 |  | Commodity | 0 | -2103544
25 |  | Demand | 0 | -2761982.5
 | Total Transport Expense: |  | 0 | -4865526.5
 | Transport Revenue:
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance | 0 | 6003890.313600002
31 |  | Prior Month Book Balance | 0 | -13901698
 |  | Total MTM Income | 0 | -7897807.686399998
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | -7164164
34 |  | Originations | 0 | 53300
35 |  | Broker Fees | 0 | -4496
36 |  | Asset Group Demand Charges | 0 | 20000
37 |  | [NAME] | 0 | 23732.85
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | -66750
40 |  | Miscellaneous | 0 | 1095949
 |  | TOTAL INTRA-MTH
FT-East
 |  | Current Month MTM | 0 | -102792 | 0 | 0 |  |  | 0 | 0
 |  | Financial Liquidations | 0 | 0 | 0 | 0 |  |  | 0 | 0
 |  | Originations | 0 | 0 | 0 | 0 |  |  | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Transport
 |  | Current Month MTM | 0 | -412000 | 0 | 0 |  |  | 0 | 0
 |  | Financial Liquidations | 0 | 0 | 0 | 0 |  |  | 0 | 0
 |  | Originations | 0 | 0 | 0 | 0 |  |  | 0 | 0
 |  | TOTAL FIRM TRADING
Spreadsheet: 688781d1595953154-adding-all-purchases-from-a-custom-date-range-from-a-purchase-journal-pj-sample-excel
Sheet: Sheet2

DAILY SALES  QUARTER 3, 2020
PER 7 | sales | PER 8 | sales | PER 9 | sales |  |  |  | SALES | ACTUAL  PURCHASES  $ | ACTUAL  PURCHASE % | PURCHASE %  TARGET | [NAME]
2020-07-01 00:00:00 |  | 2020-08-01 00:00:00 |  | 2020-09-01 00:00:00 |  |  | P7 | WEEK 1
2020-07-02 00:00:00 |  | 2020-08-02 00:00:00 |  | 2020-09-02 00:00:00 |  |  | P7 | WEEK 2
2020-07-03 00:00:00 |  | 2020-08-03 00:00:00 |  | 2020-09-03 00:00:00 |  |  | P7 | WEEK 3
2020-07-04 00:00:00 |  | 2020-08-04 00:00:00 |  | 2020-09-04 00:00:00 |  |  | P7 | WEEK 4
2020-07-05 00:00:00 |  | 2020-08-05 00:00:00 |  | 2020-09-05 00:00:00 |  |  | P7 | WEEK 5
2020-07-06 00:00:00 |  | 2020-08-06 00:00:00 |  | 2020-09-06 00:00:00 |  |  | P8 | WEEK 1
2020-07-07 00:00:00 |  | 2020-08-07 00:00:00 |  | 2020-09-07 00:00:00 |  |  | P8 | WEEK 2
2020-07-08 00:00:00 |  | 2020-08-08 00:00:00 |  | 2020-09-08 00:00:00 |  |  | P8 | WEEK 3
2020-07-09 00:00:00 |  | 2020-08-09 00:00:00 |  | 2020-09-09 00:00:00 |  |  | P8 | WEEK 4
2020-07-10 00:00:00 |  | 2020-08-10 00:00:00 |  | 2020-09-10 00:00:00 |  |  | P8 | WEEK 5
2020-07-11 00:00:00 |  | 2020-08-11 00:00:00 |  | 2020-09-11 00:00:00 |  |  | P8 | WEEK 6
2020-07-12 00:00:00 |  | 2020-08-12 00:00:00 |  | 2020-09-12 00:00:00 |  |  | P9 | WEEK 1
2020-07-13 00:00:00 |  | 2020-08-13 00:00:00 |  | 2020-09-13 00:00:00 |  |  | P9 | WEEK 2
2020-07-14 00:00:00 |  | 2020-08-14 00:00:00 |  | 2020-09-14 00:00:00 |  |  | P9 | WEEK 3
2020-07-15 00:00:00 |  | 2020-08-15 00:00:00 |  | 2020-09-15 00:00:00 |  |  | P9 | WEEK 4
2020-07-16 00:00:00 |  | 2020-08-16 00:00:00 |  | 2020-09-16 00:00:00 |  |  | P9 | WEEK 5
2020-07-17 00:00:00 |  | 2020-08-17 00:00:00 |  | 2020-09-17 00:00:00
2020-07-18 00:00:00 |  | 2020-08-18 00:00:00 |  | 2020-09-18 00:00:00
2020-07-19 00:00:00 |  | 2020-08-19 00:00:00 |  | 2020-09-19 00:00:00
2020-07-20 00:00:00 |  | 2020-08-20 00:00:00 |  | 2020-09-20 00:00:00
2020-07-21 00:00:00 |  | 2020-08-21 00:00:00 |  | 2020-09-21 00:00:00
2020-07-22 00:00:00 |  | 2020-08-22 00:00:00 |  | 2020-09-22 00:00:00
2020-07-23 00:00:00 |  | 2020-08-23 00:00:00 |  | 2020-09-23 00:00:00
2020-07-24 00:00:00 |  | 2020-08-24 00:00:00 |  | 2020-09-24 00:00:00
2020-07-25 00:00:00 |  | 2020-08-25 00:00:00 |  | 2020-09-25 00:00:00
2020-07-26 00:00:00 |  | 2020-08-26 00:00:00 |  | 2020-09-26 00:00:00
2020-07-27 00:00:00 |  | 2020-08-27 00:00:00 |  | 2020-09-27 00:00:00
2020-07-28 00:00:00 |  | 2020-08-28 00:00:00 |  | 2020-09-28 00:00:00
2020-07-29 00:00:00 |  | 2020-08-29 00:00:00 |  | 2020-09-29 00:00:00
2020-07-30 00:00:00 |  | 2020-08-30 00:00:00 |  | 2020-09-30 00:00:00
2020-07-31 00:00:00 |  | 2020-08-31 00:00:00
PURCHASE  TARGET | 0.55 |  | 0.55 |  | 0.55