tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: benjamin_rogers__906__BR New York Ticker 10_01
Sheet: ZONE A POSITIONS

Day | DATE | BID | OFFER | MID | SETTLE | CHG | H/R | POSITION | AVG PRICE | CRV SHT | DAILY SETTLE |  | D/A | R/T | DIFF
 |  |  |  |  |  |  |  |  |  |  |  | HE |  |  | DA-RT
 |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  |  | As of
 | 2001-09-02 00:00:00 |  |  |  |  |  |  |  |  |  |  | 10 |  |  |  |  | Total | Avg |  |  | 1 |  | 2 |  | 3 |  | 4 |  |  |  | 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 |  | 32 |  | 33 |  | 34 |  | 35 |  | 36 |  | 37 |  | 38 |  | 39 |  | 40 |  | Net | Average
 |  |  |  |  |  |  |  |  |  |  |  | 11 |  |  |  |  | Positions | Price |  | Date | Volume | Price | Volume | Price | Volume | Price | Volume | Price |  |  | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Volume | Price | Date
mon |  |  |  |  | 0 |  |  |  |  |  |  | 12
tues |  |  |  |  | 0 |  |  |  |  |  |  | 13
wed |  |  |  |  | 0 |  |  |  |  |  |  | 14
thurs |  |  |  |  | 0 |  |  |  |  |  |  | 15
fri |  |  |  |  | 0 |  |  |  |  |  |  | 16
 |  |  |  |  | 0 |  |  |  |  |  |  | 17
 |  |  |  |  | 0 |  |  |  |  |  |  | 18
 |  |  |  |  | 0 |  |  |  |  |  |  | 19 |  |  |  |  | 0
 |  |  |  |  | 0 |  |  |  |  |  |  | 20 |  |  |  |  | 0
 |  |  |  |  | 0 |  |  |  |  |  |  | 21
mon |  |  |  |  | 0 |  |  |  |  |  |  | 22 |  |  |  |  | 0
tues |  |  |  |  | 0 |  |  |  |  |  |  | 23 |  |  |  |  | 0
wed |  |  |  |  | 0 |  |  |  |  |  | DAILY SETTLE |  |  |  |  |  | 0
thurs |  |  |  |  | 0 |  |  |  |  |  |  |  | 28.56 |  |  |  | 0
fri |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
mon |  |  |  |  | 0 |  |  |  |  |  |  |  | SETTLE | OFF-PK | ON PEAK |  | 0
tues |  |  |  |  | 0 |  |  |  |  |  |  | SAT | 25.25 | 200 | 200
wed |  |  |  |  | 29.75 |  |  |  |  |  |  | SUN | 25.25 | 200 | 200 |  | 0
thurs |  |  |  |  | 29.75 |  |  |  |  |  |  | MON | 25.25 | 200 | 200 |  | 0
fri |  |  |  |  | 29.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 30.4 | 50 | 29.95 | -50 | 29.55
 |  |  |  |  |  |  |  |  |  |  |  | RTC CAL | Bid | OFFER |  |  |  |  |  |  | 50 | 30.4 | 50 | 29.95
TOTAL | TOTAL |  |  |  |  |  |  |  |  |  |  | 1X8 | 20 | 21 |  |  |  |  |  |  | 50 | 30.4 | 50 | 29.95
 |  |  |  |  |  |  |  |  |  |  |  | 1X16 | 31 | 33 |  |  |  |  |  | 2001-09-29 00:00:00
 |  |  |  |  |  | TOTAL | CURVE | SHIFT |  |  |  |  |  |  |  |  |  |  |  | 2001-09-30 00:00:00
Spreadsheet: 585436d1533766336-assets-booking-sheet-tracking-most-recent-booking-item-tracking-overdue
Sheet: Overdue Report

Late? | TRUE
Item | User
111111 | Person 1
111113 | Person 3
111115 | Person 2
111117 | Person 5
111119 | Person 6
111121 | Person 19
111123 | Person 2
111125 | Person 4
111127 | Person 4
111129 | Person 7
111133 | Person 9
111141 | Person 13
111145 | Person 15
111147 | Person 16
111149 | Person 17
111151 | Person 18
111153 | Person 20
111155 | Person 21
Spreadsheet: 169293d1342774153-arranging-information-into-tables-new-problem-1
Sheet: Summary

Summary
 | A | B | C | D |  | Sheet
1 |  |  |  |  |  | 1
 |  |  |  |  |  | 2
 |  |  |  |  |  | 3
 |  |  |  |  |  | 4
 |  |  |  |  |  | 5
Spreadsheet: 477556d1472370989-assistance-with-multiple-if-conditions-time-test-file-revised-
Sheet: Control - Admin (only)

Leave Legend |  | Employee Name | Designation | Payroll No. | Department | Employment Type |  | Date of Last Fortnightly Week | 2016-08-16 00:00:00
A = Annual Leave |  | EMP1 | OPS exe | 1 | OPS | Permanent
C = Carers Leave |  | EMP2 | OPS exe | 2 | OPS | Permanent
COM = Compassionate Leave |  | EMP3 | MGT MGR | 3 | MGT | Permanent
DR = Defence Reserves Leave |  | EMP4 | ADMIN EXE | 4 | ADMIN | Permanent
EA = Emergency Assistance Leave |  | EMP5 | COM EXE | 5 | COM | Permanent
[NAME] = Jury Duty |  | EMP6 | COM EXE | 6 | COM | Permanent
LSL = Long Service Leave |  | EMP7 | FIN Mgr | 8 | FIN | Permanent
LWOP = Unpaid Leave |  | [NAME] | FIN Mgr | 9 | FIN | Permanent
PH = Public Holiday |  | EMP9 | GEN ASST | 11 | GEN | Contract
PL = Parental Leave
PHT = PH Toil
S = Sick Leave
ST = Approved Study Leave
Rostered on or off
Yes
No |  |  |  |  |  |  |  |  | Reg- Hrs | Reg- Hrs | Reg- Hrs | any additional HR
 |  |  |  |  |  |  |  | Department | Mon - Fri | Mon - Sat | Sun | Overtime
On Call Allowance Claim = Yes No |  |  |  |  |  |  |  | OPS | 8 | 8 | 6 | YES
Yes |  |  |  |  |  |  |  | MGT | 8 | 0 | 0 | NIL - OT
No |  |  |  |  |  |  |  | ADMIN | 5 | 0 | 0 | NIL - OT
 |  |  |  |  |  |  |  | FIN | 7 | 0 | 0 | NIL - OT
 |  |  |  |  |  |  |  | COM | 4 | 3 | 0 | NIL - OT
 |  |  |  |  |  |  |  | GEN | 6 | 6
Spreadsheet: 742927d1628123397-formulas-to-chart-inventory-levels-example
Sheet: Sheet1

Job information |  |  |  | Graph information
Job ID | Date of arrival | Date of dispatch |  | Date | Items in Inventory on given date
1 | 2021-07-01 00:00:00 | 2021-07-10 00:00:00 |  | 2021-07-01 00:00:00 | ?
2 | 2021-07-01 00:00:00 | 2021-08-04 00:00:00 |  | 2021-07-02 00:00:00 | ?
3 | 2021-07-10 00:00:00 | 2021-07-13 00:00:00 |  | 2021-07-03 00:00:00 | ?
4 | 2021-07-05 00:00:00 | still in inventory |  | 2021-07-04 00:00:00 | ?
5 | 2021-07-31 00:00:00 | still in inventory |  | 2021-07-05 00:00:00 | ?
6 | 2021-07-23 00:00:00 | still in inventory |  | 2021-07-06 00:00:00 | ?
7 | 2021-07-16 00:00:00 | still in inventory |  | 2021-07-07 00:00:00 | ?
8 | 2021-07-16 00:00:00 | 2021-07-17 00:00:00 |  | 2021-07-08 00:00:00 | ?
9 | 2021-07-18 00:00:00 | 2021-08-03 00:00:00 |  | 2021-07-09 00:00:00 | ?
10 | 2021-07-25 00:00:00 | 2021-08-03 00:00:00 |  | 2021-07-10 00:00:00 | ?
 |  |  |  | 2021-07-11 00:00:00 | ?
 |  |  |  | 2021-07-12 00:00:00 | ?
* FYI - "still in inventory" |  |  |  | 2021-07-13 00:00:00 | ?
These cells will remain empty until the item is dispatched |  |  |  | 2021-07-14 00:00:00 | ?
 |  |  |  | 2021-07-15 00:00:00 | ?
 |  |  |  | 2021-07-16 00:00:00 | ?
 |  |  |  | 2021-07-17 00:00:00 | ?
 |  |  |  | 2021-07-18 00:00:00 | ?
 |  |  |  | 2021-07-19 00:00:00 | ?
 |  |  |  | 2021-07-20 00:00:00 | ?
 |  |  |  | 2021-07-21 00:00:00 | ?
 |  |  |  | 2021-07-22 00:00:00 | ?
 |  |  |  | 2021-07-23 00:00:00 | ?
 |  |  |  | 2021-07-24 00:00:00 | ?
 |  |  |  | 2021-07-25 00:00:00 | ?
 |  |  |  | 2021-07-26 00:00:00 | ?
 |  |  |  | 2021-07-27 00:00:00 | ?
 |  |  |  | 2021-07-28 00:00:00 | ?
 |  |  |  | 2021-07-29 00:00:00 | ?
 |  |  |  | 2021-07-30 00:00:00 | ?
Spreadsheet: 709176d1608197414-average-volume-handled-per-day-week-month-in-excel-volume-report-etaf
Sheet: Dates and Days

 | Work days per month
 | Month | Days
 | January | 23
 | February | 20
 | March | 22
 | April | 20
 | May | 19
 | June | 22
 | July | 23
 | August | 21
 | September | 22
 | October | 22
 | November | 21
 | December | 20
Spreadsheet: 59751d1260312797-excel-2007-how-to-sort-data-validation-menu-while-typing-characters-in-the-cell-for-the-menu-master_requirement_gathering_template_-final-
Sheet: Case Review

 |  | DATA Gathering Template
Program | Temporary Assistance - Family Assistance and Safety Net
Function Name | Case Management (Undercare)
Activity Name | Case Review
Activity Description / Purpose | Supervisory review for case correctness/payment accuracy/data entry.
 |  |  | Activity Predecessor | Activity [NAME] | Activity Input | Activity Output | Activity Successors
Steps | Tasks A task is any action that is being performed to complete a step | What unit does this? (SU) | Who does this? (W) | Applications used / System Interfaces / Tools Is there an automated system supporting the activity? | What happens before this? (P) | What causes the activity to happen (T) | Additional Information that is needed (I) | Is anything produced? (O) | What happens next ? (S) | V | Comments |  |  |  | Questions | Workarounds | Constraints/ Issues | Opportunities | Policy Considerations | Best Practices | Follow-Up | Comments
Review case inputs and/or verifications that drove the eligibility decision
Decision: approved to proceed or not
Create electronic authorization request
Spreadsheet: 697412d1601344995-using-index-and-match-but-omitting-some-results-report-help
Sheet: Assign

Address | Sign | PATH | DROP
123 Address | [NAME] | [NAME] | Ant
1b basemment | Ant | Ant | Ant
23 flower garden | [NAME] | [NAME] | Ant
12 can place | [NAME] | [NAME] | [NAME]
1 False st | [NAME] | [NAME] | [NAME]
19 fake St | [NAME] | [NAME] | Ant
20 fake St | Ant | - | Ant
21 fake St | [NAME] | - | -
22 fake St | [NAME] | - | [NAME]
23 fake St | - | [NAME] | -
162 Grand Ave
163 Grand Ave
164 Grand Ave
165 Grand Ave
166 Grand Ave
167 Grand Ave
168 Grand Ave
169 Grand Ave
170 Grand Ave
Spreadsheet: 736589d1623755613-sum-of-index-match-of-multiple-worksheets-example
Sheet: SheetnameABC

 |  | CUSTOMER A FORECAST
 |  | SKU | Vendor SKU | Description | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | Total
 |  | Category A
 |  | ITEM A | VendorA | Description | 100
 |  | ITEM B | VendorB | Description | 200
 |  | ITEM E | VendorE | Description | 500
 |  | Category B
 |  | ITEM C | VendorC | Description | 300
 |  | ITEM D | [NAME] | Description | 400
Spreadsheet: 39011d1237229816-excel-2007-opening-excel-2007-in-excel-2003-issue-test
Sheet: WL

Construct Group: Workload
Question | Strongly agree | Agree | Disagree | Strongly disagree | Question Grand Total
Total Responses
Total Responses
Total Responses
Total Responses
Total Responses
Grand Total of Responses |  |  |  |  | Overall Grand Total
Overall Construct Group Summary | Strongly Agree | Agree | Disagree | Strongly disagree
Spreadsheet: 1b404875-caf7-4f98-a1de-0d2f9ddf24d6
Sheet: Sheet1

[NAME] | Guilford County Resident Rate- Weekdays: | Non Resident Rate-Weekdays: | Guilford County Resident Rate-Weekends & Holidays | Non-Resident Rate-Weekends & Holidays: | Seating Capacity
Shelter 1 | 55 | 82.5 | 60 | 90 | 80
Shelter 2 | 40 | 60 | 45 | 67.5 | 80
Shelter 3 | 30 | 45 | 35 | 52.5 | 80
Shelter 4 | 40 | 60 | 45 | 67.5 | 80
Shelter 5 | 95 | 142.5 | 105 | 157.5 | 144
Shelter 6 | 65 | 97.5 | 70 | 105 | 80
School Groups-Any Shelter | 30 | 45
[NAME] | Guilford County Resident Rate- Weekdays: | Non Resident Rate-Weekdays: | Guilford County Resident Rate-Weekends & Holidays | Non-Resident Rate-Weekends & Holidays: | Seating Capacity
Shelter 1 | 35 | 52.5 | 40 | 60 | 35
Shelter 2 | 35 | 52.5 | 40 | 60 | 35
Shelter 4 | 35 | 52.5 | 40 | 60 | 35
Shelter 5 | 35 | 52.5 | 40 | 60 | 35
Shelter 6 | 35 | 52.5 | 40 | 60 | 35
Shelter 7 (Electricity) | 125 | 187.5 | 135 | 202.5 | 150
Shelter 8 | 35 | 52.5 | 40 | 60 | 35
Shelter 9 | 35 | 52.5 | 40 | 60 | 35
Shelter 10 (Electricity) | 125 | 187.5 | 135 | 202.5 | 150
Volleyball Court (2 hours) | 5 | 7.5 | 5 | 7.5
Horseshoes (4 hours) | 5 | 7.5 | 5 | 7.5
School Groups-Any Shelter | 30 | 45
Country Park | Guilford County Resident Rate- Weekdays: | Non Resident Rate-Weekdays: | Guilford County Resident Rate-Weekends & Holidays | Non-Resident Rate-Weekends & Holidays: | Seating Capacity
Shelter 1 (RR/Elec.) | 105 | 157.5 | 115 | 172.5 | 125
Shelter 3 | 35 | 52.5 | 40 | 60 | 25
Shelter 4 | 65 | 97.5 | 70 | 105 | 90
Shelter 5 | 35 | 52.5 | 40 | 60 | 25
Shelter 6 | 35 | 52.5 | 40 | 60 | 25
Shelter 7 (RR/Elec.) | 105 | 157.5 | 115 | 172.5 | 96
Shelter 8 | 35 | 52.5 | 40 | 60 | 25
Shelter 9 | 35 | 52.5 | 40 | 60 | 25
School Groups-Any Shelter | 30 | 45
Hester Park | Guilford County Resident Rate- Weekdays: | Non Resident Rate-Weekdays: | Guilford County Resident Rate-Weekends & Holidays | Non-Resident Rate-Weekends & Holidays: | Seating Capacity
Shelter 1 (Electricity) | 95 | 142.5 | 105 | 157.5 | 200
Shelter 2 (Electricity) | 40 | 60 | 45 | 67.5 | 40
Shelter 3 | 30 | 45 | 35 | 52.5 | 40
Shelter 4 (Electricity) | 65 | 97.5 | 70 | 105 | 70
Shelter 5 | 30 | 45 | 35 | 52.5 | 40
Shelter 6 (Electricity) | 40 | 60 | 45 | 67.5 | 40
Shelter 7 (Electricity) | 65 | 97.5 | 70 | 105 | 70
School Groups-Any Shelter | 30 | 45
Volleyball Court-2 hrs | 10 | 15 | 10 | 15
Horseshoes-4 hours | 5 | 7.5 | 5 | 7.5
Lake Brandt/Lake Higgins | Guilford County Resident Rate- Weekdays: | Non Resident Rate-Weekdays: | Guilford County Resident Rate-Weekends & Holidays | Non-Resident Rate-Weekends & Holidays: | Seating Capacity
Shelter | 40 | 60 | 45 | 68 | 36
School Groups | 25 | 38
Spreadsheet: 470768d1468632573-help-with-v-look-up-vlookuppackingslip
Sheet: Sheet1

Customer: | [NAME] |  |  |  |  | Date:
billing address: |  |  | Shipping Address:
Item |  | Quantity |  | Retail Price | Wholesale Rate | Price
Shipping:
Total:
Spreadsheet: 51682d1251307576-please-help-with-forecasting-test
Sheet: Sheet1

 |  |  |  |  |  | Q3 08 |  |  |  |  |  | Q4 08 |  |  |  |  |  | Q1 09 |  |  |  |  |  | Q2 09 |  |  |  |  |  | [NAME] |  |  |  |  |  | Q4 09 |  |  |  |  |  | Q1 10 |  |  |  |  |  | Q2 10 |  |  |  |  |  | Q3 10 |  |  |  |  |  | Q4 10
 | 2007-12-01 00:00:00 | 2008-01-01 00:00:00 | 2008-02-01 00:00:00 | Claims | TTL | FREQ | 2008-03-01 00:00:00 | 2008-04-01 00:00:00 | 2008-05-01 00:00:00 | Claims | TTL | FREQ | 2008-06-01 00:00:00 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | Claims | TTL | FREQ | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | Claims | TTL | FREQ | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | Claims | TTL | FREQ | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | Claims | TTL | FREQ | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-09 00:00:00 | Claims | TTL | FREQ | 2009-09-09 00:00:00 | 2009-10-09 00:00:00 | 2009-11-09 00:00:00 | Claims | TTL | FREQ | 2009-12-09 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | Claims | TTL | FREQ | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | Claims | TTL | FREQ
AAA | 9 | 15 | 10 | 34 | 3837 | 0.008861089392754757 | 8 | 16 | 10 | 34 | 4337 | 0.007839520405810468 | 10 | 12 | 8 | 30 | 4824 | 0.006218905472636816 | 9 | 17 | 12 | 38 | 4531 | 0.008386669609357758 | 7 | 6 | 10 | 23 | 3599 | 0.006390664073353709 | 12 | 8 | 11 | 31 | 4033 | 0.007686585668237045 | 12 | 18
Spreadsheet: 46197d1245086266-matching-problem-match-data
Sheet: Sheet1

Table A
Book Date | Product | Inv Number | Booking ID | Confirm #
2007-12-06 00:00:00 | HOTEL | 1337303813 | 3297055145 | REFUND
2007-12-06 00:00:00 | HOTEL | 1337303813 | 3297055145 | SALE
Table B
ID | Entry Date | Entry Time | Inventory | Inv ID | Status | Match
1765772 | 2008-05-02 00:00:00 | 0.6625 | 1337303813 | XYZ | Cancelled | REFUND
Spreadsheet: 767151d1644316282-how-to-group-existing-values-in-numerous-cells-to-one-cell-example-grouping-
Sheet: Sheet1

Id | Items |  | Id | items
10001 | Laptop |  | 10001
10001 | Keyboard
10001 | [NAME]
10001 | Stapler
10002 | [NAME]
10002 | Laptop
10002 | Keyboard
10002 | Stapler
10002 | Calendar
10002 | Diary
10003 | Diary
10003 | Stapler
10003 | Keyboard
10003 | Charger
10003 | Laptop
10003 | [NAME]
10003 | Usb cable
Spreadsheet: 769618d1645620829-combine-text-document-and-split-into-two-columns-document
Sheet: DATA FROM REPORT

THIS DATA IS COPIED FROM A TEXT DOCUMENT AND PASTED INTO EXCEL. |  | I NEED TO JOIN THE CATEGORY WITH THE TOTAL  SO IT IS IN ONE LINEBUT SEPARATE COLUMNS AS BELOW
 |  | CATEGORY | TOTAL
TOWN A                          202201  (0=>FRUIT01) (CATEGORY01) APPLES |  | (0=>FRUIT01) (CATEGORY01) APPLES | 12
 |  | (0=>FRUIT02) (CATEGORY02) PEARS | 120
12 |  | (0=>FRUIT03) (CATEGORY03) BANANAS | 3
 |  | (0=>FRUIT04) (CATEGORY04) PRUNES | 1121
(0=>FRUIT02) (CATEGORY02) PEARS |  | (0=>FRUIT05) (CATEGORY05) ORANGES | 0
 |  | (003100) PUMPKIN | 16
120 |  | (055012) ONIONS | 25
(0=>FRUIT03) (CATEGORY03) BANANAS
3
(0=>FRUIT04) (CATEGORY04) PRUNES
1121
(0=>FRUIT05) (CATEGORY05) ORANGES
0
(003100) PUMPKIN
16
(055012) ONIONS
25
TOWN B                          202201  (0=>FRUIT01) (CATEGORY01) APPLES
25
(0=>FRUIT02) (CATEGORY02) PEARS
95
(0=>FRUIT03) (CATEGORY03) BANANAS
1432
(0=>FRUIT04) (CATEGORY04) PRUNES
524
(0=>FRUIT05) (CATEGORY05) ORANGES
9
(012345) COCONUTS
99
(987654) DRAGON FRUIT
852
Spreadsheet: kimberly_watson__20554__imbalsumm0108
Sheet: by type

TRANSWESTERN  PIPELINE -   SUMMARY OF OBA BALANCES |  |  |  |  |  |  |  | index
 |  |  |  |  |  |  |  | SJ
Positive=due [NAME] |  | Negative = due operator |  |  |  |  |  | AVG
 |  |  |  |  |  |  |  | NTXPH
DOLLAR VALUED IMBALANCES
 |  | Calc vol @ | CBS | Calc vol | As of
Operator | $[NAME] | [NAME] | Volume | less CBS vol | Date | Mrktg rep | MS rep | Comments
West of Thoreau
Calpine |  |  |  |  |  |  | [NAME]
Citizens-Griffith |  |  |  |  |  | M Lokay | [NAME]
North Star Steel |  |  |  |  |  | M Lokay | [NAME] | majority of balance since 01/01
Citizens Communications |  |  |  |  |  |  | [NAME] | ($711,298) in 4/01 and ($194,897) in 3/01
Total WOT
San Juan
TransColorado |  |  |  |  |  | L Lindberg | [NAME]
Burlington |  |  |  |  |  | M Lokay | [NAME] | balance is cashed out monthly
Total SJ
East of Thoreau
NNG |  |  |  |  |  | TK Lohman | [NAME]
Conoco |  |  |  |  |  | M Lokay | [NAME] | Zia/Maljamar- majority of balance since 3/01
Amoco Abo |  |  |  |  |  | L Lindberg | [NAME] | paying back about 500-1,000 mmbtus/day
[NAME] |  |  |  |  |  | M Lokay | [NAME]
Duke/GPM |  |  |  |  |  | L Lindberg | [NAME] | Crawford, Pecos Diamond, [NAME], Linam Ranch, Artesia
CIG |  |  |  |  |  | M Lokay | [NAME]
Mewborne |  |  |  |  |  | M Lokay | [NAME]
EPFS / PG&E TX |  |  |  |  |  | TK Lohman | [NAME] | 1/01 - 7/01- was cashed out as of 12/31/00
PNM |  |  |  |  |  | L Lindberg | [NAME]
EOG |  |  |  |  |  | M Lokay | [NAME]
[NAME] |  |  |  |  |  | TK Lohman | [NAME]
Continental |  |  |  |  |  | M Lokay | [NAME]
El Paso Field Services |  |  |  |  |  | L Lindberg | [NAME]
Agave |  |  |  |  |  | K Watson | [NAME]
Total EOT
Total $ Value
TRANSWESTERN  PIPELINE -   SUMMARY OF OBA BALANCES |  |  |  |  |  |  |  | index
 |  |  |  |  |  |  |  | SJ
Positive=due [NAME] |  | Negative = due operator |  |  |  |  |  | AVG
 |  |  |  |  |  |  |  | NTXPH
VOLUMETRIC IMBALANCES
 |  | Calc$ @curr | If $valued | Calc$ less | As of
Operator | Volume | Mo prices | amount | if $valued | Date | Mrktg rep | MS rep | Comments
West of Thoreau
Mojave Pipeline |  |  |  |  |  |  | [NAME] | 129,146 mmbtus was created in 6/01
SoCal |  |  |  |  |  |  | [NAME]
El Paso - Window Rock |  |  |  |  |  |  | [NAME] | payback has been made for the past two months
PG&E Topock |  |  |  |  |  |  | [NAME]
Total WOT
San Juan
[NAME] |  |  |  |  |  | L Lindberg | [NAME] | balance created from 1/01 to present
Red Cedar |  |  |  |  |  | L Lindberg | [NAME] | last cashout was for balance as of 9/30/00
Amoco |  |  |  |  |  | L Lindberg | [NAME] | 114,758 mmbtu receivable in 4/01
El Paso - Blanco |  |  |  |  |  |  | [NAME] | payback has been made for the past two months
Northwest |  |  |  |  |  | L Lindberg | [NAME]
Total SJ
East of Thoreau
NGPL |  |  |  |  |  |  | [NAME]
Panhandle Eastern |  |  |  |  |  |  | [NAME] | Hansford
Oasis |  |  |  |  |  |  | [NAME]
Lonestar |  |  |  |  |  |  | [NAME]
Total EOT
Total Volumetric imbals
NET IMBAL AMOUNT
NET IMBAL VOLUME
Spreadsheet: 684875d1593595254-how-to-pick-up-correct-data-in-multiple-rows-and-columns-in-a-table-how-to-pick-up-correct-data-in-multiple-rows-and-columns-in-a-table
Sheet: Sheet1

 | Table 1 - Data |  |  |  |  |  |  |  |  |  |  |  |  |  | Table 2 - Selling Price Summary
 | Item | 1
 |  | Product A |  |  |  | Product B |  |  |  | Product C |  |  |  |  |  |  | Our selling price over different sales channels
 | Sales to | [NAME] |  | MT |  | MT |  | FR |  | OT |  | FS |  |  | Item | Product Name | [NAME] | FR | FS | GT | MT | OT
 | Our Cost Price |  | 15 |  |  |  | 20 |  |  |  | 38 |  |  |  | 1
 | Desired Margin |  |  | 0.11 |  |  |  | 0.15 |  | 0.2 |  | 0.18 |  |  | 2
 | Our Selling Price |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 | Sales to | GT |  | FS |  | OT |  |  |  |  |  |  |  |  | 4
 | Our Cost Price |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 | Desired Margin | 0.12 |  | 0.13 |  | 0.12 |  |  |  |  |  |  |  |  | 6
 | Our Selling Price
Spreadsheet: 75560d1276109787-make-a-letter-have-a-value-to-add-it-together-system-win-percentage
Sheet: Hedge

 | Date | Team | [A] | [B] | [C] | Record
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16 | 2010-06-06 00:00:00 | Boston | L | W | X
17 | 2010-06-06 00:00:00 | Colorado | W | X | X
18 | 2010-06-09 00:00:00 | Tampa Bay
19
20
 |  |  | Win %
Spreadsheet: 218156d1362375725-create-entries-based-on-date-excel
Sheet: Outpot

Date | Value1 | value 2 | Value
2013-03-01 00:00:00 | 10 | 15 | 20
 | 10 | 15 | 20
 | 10 | 15 | 20
 | 10 | 15 | 20
 | 10 | 15 | 20
 | 10 | 15 | 20
 | 14 | 19 | 23
Spreadsheet: 764126d1642599596-v-lookup-help-why-is-it-returning-n-a-excel2
Sheet: master

Employee Number | Hours | Amount | Rate | Sum
525794
526050
526149
524844
525838
525591
522787
525597
525990
525718
522721
525080
521207
520560
526015
525733
522724
522729
524508
524892
525404
525996
525991
525424
525843
524980
525361
525965
522576
525131
522742
526162
526013
525570
526083
522746
526007
522749
525983
524806
523228
525580
522752
525572
520515
521685
524510
525540
525359
525828
525017
524511
526203
525613
525971
136550
525633
525693
522361
522780
524988
525953
524695
523348
524428
523017
525186
525483
525179
525881
521454
524941
521066
524523
524827
525378
521612
523073
202255
524945
526152
525844
522569
521567
520772
524616
525364
521710
525915
525368
526134
524936
526065
522870
526073
525284
526070
525290
526133
526067
526069
522577
526141
525562
522902
513100
526085
524691
525793
524367
525249
525393
526185
526166
167224
524902
524871
524904
524940
525263
526019
525212
522379
525312
524374
525941
525644
525482
522651
161374
207973
505393
509189
521656
522363
522886
523182
524498
525565
525949
525171
526059
521078
525784
525314
524412
521396
523429
525610
523266
525437
522613
524972
Spreadsheet: 713739d1610903137-formula-for-next-due-date-example-credit-cards
Sheet: Matt

[NAME] | Gold | Platinum | FF Plus | Lock Bank | Preferred | Xellence | Total
Interest Rate | 0.0899 | 0.0795 | 0.0499 | 0.0679 | 0.059 | 0.0549
Due Day | 6 | 8 | 19 | 20 | 23 | 27
Limit | 2500 | 15500 | 9000 | 25000 | 10000 | 8975
Balance | 235 | 128.35 | 130.5 | 229.12 | 98.58 | 120.12
Available
Utilization
Target @ 25%
Over Target
[NAME] 30%
Overutilization
Last Payment | 2020-12-31 00:00:00 | 2021-01-02 00:00:00 | 2021-01-17 00:00:00 | 2021-01-17 00:00:00 | 2021-01-17 00:00:00 | 2021-01-17 00:00:00
Next Payment
Spreadsheet: 4ec44d6a-6137-4345-9cf0-c90b58e65dc9
Sheet: 3

 | Sep 27 | Oct 4 | Oct 11 | Oct 18 | Oct 25
Total Interest Rate* | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | N/A | N/A | N/A | N/A | N/A
Cleared** | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Credit | 2173681 | 2195060 | 2203309 | 2189917 | 2194511
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | N/A | N/A | N/A | N/A | N/A
Weekly snapshot, net notional amount outstanding by asset class and cleared status (millions of USD), all products, tenors, and participant types.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].