tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: daren_farmer__5101__buydef
Sheet: Sheet1

BUYBACK & DEFICIENCY DEALS
 |  |  |  | Buyback | Type
Counterparty | Undertake | Sale | Swing | K # | of deal | Term | [NAME] | VM
AirProducts, Inc. | 414092 | 414025 | 414090 | 96023739 | Deficiency | 10/00-9/01 | 1418
BASF Corporation | 133000 | 120266 | 122310 | 96022419 | Buyback | 11/1/99-10/31/01 | 1437
Bayer Corporation |  | 572910 |  | 96022013 | Buyback | 2/01-3/01 | 1550/8056 | Fred
Bayer Corporation | 643826 |  | 634510 | 96022013 | Buyback | March | 1550/8056 | Fred
Beaumont Methanol Limited Partnership | 696599 | 696585 | 696594 | 96000279 | Buyback | April | 1428
Chevron Phillips Chemical | 413472 | 413447 | 413462 |  | Buyback | 10/00-9/01 | 1024
[NAME] | 544392 |  | 544388 | 96018826 | Buyback | 1/1/01-12/31/01 | 8216 | Fred
Enron Methanol Co | 544402 |  | 544395 | 96018827 | Buyback | 1/1/01-12/31/01 | 8291 | Fred
Equistar Chemicals LP | 586534 |  | 586537 | 96000240 | Buyback | 2/01-5/01 | 1552, 1373, 1553, 1334, 1399, 1062, 1384 | [NAME]
Formosa Hydrocarbons | 487064 | 446661 |  |  | Buyback | 11/00-10/01 | 1000, 1383
Global Octanes Texas LP | 373580 | 276461 | 373590 | 96019673 | Deficiency | 9/00-8/01 | 1528 | Thu
Lyondell-Citgo | 542915 | 542893 |  | 96008792 | Buyback | 1/1/01-12/31/01 | 1063
Marathon-Ashland | 513826 | 454436 |  | 96019644 | Buyback | 12/00-11/01 | 1431
Mobil Oil Corp. | 586400 | 538950 | 413351 | 96055715 | Buyback | 11/00-9/02 | 1040
Petrofina Gas Pipeline | 455545 | 455500 |  | 96019331 | Buyback | 11/00-3/01 | 1484
Petrofina Gas Pipeline | 473226 | 455500 |  | 96019331 | Buyback | 12/00-3/01 | 1484
Petrofina Gas Pipeline | 695692 |  | 695702 | 96019331 | Buyback | 4/01-10/01 | 1484
Rohm & Haas | 639741 | 639698 |  | 96019546 | Buyback | March | 1506 | Thu
Rohm & Haas | 703325 | 703318 |  | 96019546 | Buyback | April | 1506 | Thu
[NAME] |  | 168176 |  |  | Buyback | 3/1/00-1/31/02 | 1600
Union Carbide | 63576 | 15765 | 34825 | 96019676 | Deficiency | 2/1/99-12/31/01 | 1308 | [NAME]….ENA
Union Carbide | 63573 |  | 34832 | 96019676 | Deficiency | 1/1/00-12/31/01 | 1332 | Fred….ENA
Union Carbide |  | 643667 |  | 96019676 | Deficiency | March | 1332 | Fred….ENA
Union Carbide |  | 699730 |  | 96019676 | Deficiency | April | 1332 | Fred….ENA
Valero Marketing & Supply | 478227 | 454447 |  | 96023591 | Buyback | 11/00-4/01 | 1394
Valero Marketing & Supply | 478229 | 454452 |  | 96023591 | Buyback | 11/00-4/01 | 1233
Valero Marketing & Supply | 478230 | 454455 |  | 96023591 | Buyback | 11/00-4/01 | 8018
Westvaco | 692943 | 642526 |  |  | Buyback | March | 1020
Westvaco | 692934 | 692912 |  |  | Buyback | April | 1020
 |  |  |  |  |  |  |  |  | ENA
 |  |  |  |  |  |  |  |  | ENA
Spreadsheet: 790047d1659521416-extract-alert-id-from-multiple-strings-and-rest-show-as-blank-reportids
Sheet: Sheet2

[NAME] | Alert ID | [NAME] | Desired Result
APTC | Log4Shell_Detecting_Log4j_RCE |  |  | NoID
InitialAccess_ReplicationThroughRemovableMedia_Win_FirstUsbInsert |  |  | NoID
InitialAccess_DriveByCompromise_AVLogs_NotCleanedInfection |  |  | NoID
InitialAccess_T1190_Webshell Script Process Child of Common Web Processes |  |  | T1190
InitialAccess_T1190_Unified Messaging Service Spawning a Process |  |  | T1190
InitialAccess_T1190_Suspicious_Shells_Spawn_by_SQLServer |  |  | T1190
Execution_T1059.001_Change PowerShell Policies to Unsecure Level |  |  | T1059.001
Execution_T1059.001_SuspiciousPowerShell_Download Execute Pattern |  |  | T1059.001
Execution_T1059.001_PowerShell Remote Session Creation |  |  | T1059.001
Execution_T1059.003_Powershell Execute [NAME] |  |  | T1059.003
InitialAccess_T1078_Admin User [NAME] |  |  | T1078
InitialAccess_T566.001_Suspicious Explorer Child Process |  |  | T566.001
Command and Control_T1090.003_Tor Activity to the Internet |  |  | T1090.003
ATPC | FireEye HX Alerts
Alerts for Malware Removel Failed
Excessive DNS Failures
High number of abnormal web requests by http method
Detection of Cross-Site-Scripting based on Web URL
Detection of SQL related attack type in IDS
Detection of Command & Control
Short-lived Account Detected
Detection of Hack Tools(Mimikatz, Psexec, Processhacker)
Detects an IDS Attack hits based on Host
Detection of Domain Directory Service Object Change
Spreadsheet: 78361d1278704901-count-entries-in-column-that-are-whole-numbers-additional-criteria-countingwholenos
Sheet: Sheet1

A | 7.8 |  | For | Whol #s
B | 10 |  | A | 3
C | 4.8 |  | B | 4
A | 8 |  | C | 4
B | 5.1
C | 9
A | 0.6
B | 3
C | 5
A | 6
B | 3
C | 9
A | 6.4
B | 4
C | 4.4
A | 3
B | 8.8
C | 9
A | 8.2
B | 3.2
Spreadsheet: daren_farmer__5703__HPLN0131
Sheet: Sheet1

HPLN0131.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - January 31, 2001
 |  |  |  |  |  | **Wednesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2001-01-31 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 43583d1242231176-nested-if-statement-example-spreadsheet
Sheet: Sheet1

 | formula in here | 0 | No | Car | 0 | No | 1 | No | No | 1 | 1 | 1 | 1
 | formula in here | 1 | House | No | 0 | No | 1 | No | 1 | 1 | 1 | 1 | 0
 | formula in here | 0 | No | 1 | Car | 0 | 1 | No | No | 0 | 1 | 0 | 1
 | formula in here | 1 | No | Ship | 0 | No | 1 | No | 0 | 1 | 1 | 1 | 0
 | I want B to show the word that is in each row, so for example I want B4 to say [NAME] and [NAME] to say House etc. The range is actually much bigger than I have show but this is just an example. There is also a chance that there wont be a word so in this case just to return a blank cell
Spreadsheet: 45428d1244145531-importing-values-from-sheets-to-create-unique-list-flagsend
Sheet: Asia & The Pacific

Asia & The Pacific
22 | Country | Sent? | Date Sent | Date Received | Location | Contact | Notes
0 | Australia
0 | Cambodia
23 | China | Yes | June 1, 2009 |  | Georgia | [NAME] (478)-278-4089
0 | Fiji
0 | Hong Kong (1)
0 | Hong Kong (2)
24 | India | Yes | June 1, 2009 |  | Georgia | [NAME] (478)-278-4089
25 | Indonesia | Yes | June 1, 2009 |  | Georgia | [NAME] (478)-278-4090
26 | Japan | Yes | June 1, 2009 |  | Georgia | [NAME] (478)-278-4091
27 | Korea | Yes | June 1, 2009 |  | Georgia | [NAME] (478)-278-4092
28 | Malaysia | Yes |  |  | Florida
0 | Myanmar | No
29 | New Zealand | Yes |  |  | Florida
30 | Pakistan (1) | Yes |  |  | Florida
31 | Pakistan (2) | Yes | June 1, 2009 |  | Georgia | [NAME] (478)-278-4089
32 | Philippines | Yes | June 1, 2009 |  | Georgia | [NAME] (478)-278-4090
33 | Singapore | Yes | June 1, 2009 |  | Georgia | [NAME] (478)-278-4091
34 | [NAME] | Yes | June 1, 2009 |  | Georgia | [NAME] (478)-278-4092
35 | Thailand | Yes |  |  | Florida
36 | Vietnam | Yes |  |  | Florida
 | Total Countries: | 20
Spreadsheet: 808263d1670373674-insert-graph-for-the-data-series-of-wanted-years-and-months-bookm-fakhteh-
Sheet: 574230

Column1 | Year | Month | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Data
4133 | 1394 | 6 | 21 | 52.6 |  |  |  |  |  |  | 1368
4133 | 1394 | 7 | 22 | 52.68 |  |  |  |  |  |  | 1368
4133 | 1394 | 8 | 15 | 52.33 |  |  |  |  |  |  | 1368
4133 | 1394 | 9 | 16 | 52.3 |  |  |  |  |  |  | 1368
4133 | 1394 | 10 | 22 | 52.34 |  |  |  |  |  |  | 1368
4133 | 1394 | 11 | 9 | 52.23 |  |  |  |  |  |  | 1368
4133 | 1394 | 12 | 18 | 52.37 |  |  |  |  |  |  | 1368
4133 | 1395 | 1 | 20 | 52.41 |  |  |  |  |  |  | 1368
4133 | 1395 | 2 | 6 | 52.09 |  |  |  |  |  |  | 1368
4133 | 1395 | 3 | 20 | 52.08 |  |  |  |  |  |  | 1368
4133 | 1395 | 4 | 22 | 53.68 |  |  |  |  |  |  | 1368
4133 | 1395 | 5 | 7 | 53.73 |  |  |  |  |  |  | 1368
4133 | 1395 | 6 | 8 | 53.8 |  |  |  |  |  |  | 1368
4133 | 1395 | 7 | 1 | 53.78 |  |  |  |  |  |  | 1368
4133 | 1395 | 8 | 22 | 53.95 |  |  |  |  |  |  | 1368
4133 | 1395 | 9 | 9 | 54.1 |  |  |  |  |  |  | 1368
4133 | 1395 | 10 | 11 | 54.05 |  |  |  |  |  |  | 1368
4133 | 1395 | 11 | 16 | 54.08 |  |  |  |  |  |  | 1368
4133 | 1395 | 12 | 4 | 54 |  |  |  |  |  |  | 1368
4133 | 1396 | 1 | 20 | 53.93 |  |  |  |  |  |  | 1368
4133 | 1396 | 2 | 19 | 54.16 |  |  |  |  |  |  | 1368
4133 | 1396 | 3 | 10 | 54.41 |  |  |  |  |  |  | 1368
4133 | 1396 | 4 | 18 | 54.53 |  |  |  |  |  |  | 1368
4133 | 1396 | 5 | 25 | 54.73 |  |  |  |  |  |  | 1368
4133 | 1396 | 6 | 19 | 53.44 |  |  |  |  |  |  | 1368
4133 | 1396 | 7 | 17 | 53.59 |  |  |  |  |  |  | 1368
4133 | 1396 | 8 | 3 | 55.43 |  |  |  |  |  |  | 1368
4133 | 1396 | 9 | 8 | 55.32 |  |  |  |  |  |  | 1368
4133 | 1396 | 10 | 11 | 55.39 |  |  |  |  |  |  | 1368
4133 | 1396 | 11 | 19 | 55.18 |  |  |  |  |  |  | 1368
4133 | 1396 | 12 | 14 | 55.08 |  |  |  |  |  |  | 1368
4133 | 1397 | 1 | 17 | 55.25 |  |  |  |  |  |  | 1368
4133 | 1397 | 2 | 20 | 55.37 |  |  |  |  |  |  | 1368
4133 | 1397 | 3 | 30 | 55.76 |  |  |  |  |  |  | 1368
4133 | 1397 | 4 | 20 | 55.86 |  |  |  |  |  |  | 1368
4133 | 1397 | 5 | 25 | 56.3 |  |  |  |  |  |  | 1368
4133 | 1397 | 6 | 27 | 56.5 |  |  |  |  |  |  | 1368
4133 | 1397 | 7 | 19 | 56.55 |  |  |  |  |  |  | 1368
4133 | 1397 | 8 | 27 | 55.9 |  |  |  |  |  |  | 1368
4133 | 1397 | 9 | 15 | 55.65 |  |  |  |  |  |  | 1368
4133 | 1397 | 10 | 15 | 55.59 |  |  |  |  |  |  | 1368
4133 | 1397 | 11 | 15 | 55.35 |  |  |  |  |  |  | 1368
4133 | 1397 | 12 | 15 | 55.32 |  |  |  |  |  |  | 1368
Spreadsheet: 013099c0-71bb-4a5e-b72d-2436d999e953
Sheet: Figure 6

Figure 6: State Scorecard
 | Findings | Connecticut |  | Use the following options only
Federal Funding | Charters have access to federal funds according to state statutes (Yes = black, No = white)* | Y |  | Y
 | Percentage of federal revenue equals percentage of total enrollment for charter schools (<, >, or =) | > |  | P
State Funding | Charters have access to state funds according to state statutes (Yes = black, No = white) | Y |  | N
 | Percentage of state revenue equals percentage of total enrollment for charter schools (<, >, or =) | >
Local Funding | Charters have access to local funds according to state statutes (Yes = black, No = white) | P2
 | Percentage of local revenue equals percentage of total enrollment for charter schools (<, >, or =) | <
Facilities Funding | Charters have access to facilities funds according to state statutes (Yes = black, No = white) | Y1
 | Percentage of facilities revenue equals percentage of total enrollment for charter schools (<, >, or =) | N/A
Data Availability | State provides detailed, public data on federal, state, local and other revenues for district schools (Yes = black, Partial = grey, No = white) | Y
 | State provides detailed, public data on federal, state, local and other revenues for charter schools (Yes = black, Partial = grey, No = white) | Y
Funding Formula | Charters are treated as LEAs for funding purposes (Yes = black, Partial = grey, No = white) | Y
 | State funds student (black) or the LEA (grey) | S |  | S | L |  | Use these options for the query to the left only (B18)
 | State funding formula is fair and equitable (Yes = black, No = white | N
* For this finding, No could indicate that the statue is silent or that it denies access.
1 For the fiscal years ending June 30, 2006, and June 30, 2007, the Commissioner of Education shall establish, within available bond authorizations, a grant program to assist state charter schools in financing (1) school building projects, as defined in section 10-282, (2) general improvements to school buildings, as defined in subsection (a) of section 10-265h, and (3) repayment of debt incurred prior to July 1, 2005, for school building projects. The governing authorities of such state charter schools may apply for such grants to the Department of Education at such time and in such manner as the commissioner prescribes. The commissioner shall give preference to applications that provide for matching funds from nonstate sources.
2 Charter schools authorized by a school district are eligible for local funds, but charter schools authorized by the state are not.  Currently, there are no charter schools in Connecticut authorized by school districts.
Spreadsheet: darrell_schoolcraft__7322__imball0202
Sheet: SidR

 | [NAME]
 | POI 1190 - Keystone Plant Outlet
Day | Measured | Scheduled
1 | 46181 | 46125
2 | 45310 | 45501
3 | 45365 | 45393
4 | 45289 | 45501
5 | 29956 | 32422
6 | 44104 | 43943
7 | 28135 | 28260
8 | 40218 | 40777
9 | 54635 | 54792
10 | 55177 | 54792
11 | 54989 | 54792
12 | 26436 | 25267
13 | 43593 | 42531
14 | 46670 | 45534
15 | 36529 | 35569
16 | 38425 | 40811
17 | 39068 | 40811
18 | 38120 | 40811
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  | 1526.04
2002-02-18 00:00:00
CBS Volume
 |  |  | 549
Spreadsheet: 87a2ce05-b5be-4452-96be-adbbc36c4d70
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
Please click on required table number:
Diabetes Prevalence |  | Definition
10.1.1 | Diabetes Prevalence Rate (Unadjusted): 2006/07 | Click here for data definition
10.1.2 | Age-specific Prevalence of Diabetes: 2006/07 | Click here for data definition
Diabetes Disease Management |  | Definition
10.2.1 | Diabetes Management - % of patients With Last HbA1c Reading of 7.5 or Less: 2006/07 | Click here for data definition
10.2.2 | Diabetes Management - % of patients With a Record of Retinal Screening in the Last 15 Months: 2006/07 | Click here for data definition
10.2.3 | Prescribing of Oral Anti-Diabetics: 2006/07 | Click here for data definition
Spreadsheet: 39887d1238145570-pulling-information-from-master-sheet-onto-subsheets-automatically-677527_catty
Sheet: Warm

Warm
Category | Contact ID | Name | Phone
Spreadsheet: 22780d1211942378-drop-down-list-rich-information-experience-tables
Sheet: Sheet3

The table to be populated. The column headed as "function" is the column upon which the drop down should be provided
SO.xxx1_SV | field name | Function | Item | Error | Parameter_1 | Parameter_2 | Parameter_3
1 | WIPNO |  |  | ✓
2 | CUSTORD |  |  | ✓
3 | CREATED |  |  |  | TODAY
4 | REGNO |  | 0 | ✓ | [NAME] | MK.vehic_MAGIC | REGNO
The Code list
Code/ Function | Description | [NAME] | Example_1 | Example_2 | Example_3
W000 | Populate directly from Legacy Data | Data provided by Legacy system write this directly to the field, no transformation.
W001 | Use Standard Functions | Perform edit on legacy data, using Standard  functions fed by parameters | MK.targt_Title field is to to be set from the first 18 characters of the [NAME] field | Set todays' date | Set field to Hex(00)
W002 | Populate directly from Parameter_1 | Data provided in Parameter_1 | Set Field value to be "00"
W010 | Simple look-up and populate | Look-up the field in Parameter_3 via Parameter_1 and _2 shown in Item_0
W010 | Simple look-up and populate - with Parameter_1 = BLANK | If Parameter_1 is blank,  then go directly to the file in Parameter_2 and the field in Parameter_3
W010 | Simple look-up and populate - with multiple key path | Fields separated by a "+", indicate a multiple key path. | Look-up and populate with more than one Key Field
W011 | Simple look-up and populate + second condition | Perform a look-up and populate (W010), item 1, if the field is not found, then perform a second look-up (W010) item 2. | SO.headr: Requirement set ACCOUNT from SL.accts, if there is no account, then set as the default account from the Wpars file.
W012 | Simple look-up / populate + join to text data | Lookup field contents and concatenate this result to the results from another field
TEST | Test the value of a field or a previous result
W013 | Lookup field contents, conditionally populate second field | Object: Populate a field based upon the value in another field, if the value is X then lookup another field and write that value into this field, if the value is Y, then lookup a different field and populate that value
Spreadsheet: mary_fischer__25622__87P
Sheet: E5.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 087P
COMPANY NAME  EFS Water Treatment Services
ANALYSIS OF GOODWILL
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY:[NAME]
EXTENSION:[PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  | E-5
 |  |  |  | 12-31-2000 Balance
 |  |  |  | BEGINNING |  |  |  |  |  |  |  |  |  | 12-31-2001
[NAME] OR ENTITY |  | AMORTIZATION |  | BALANCE |  |  |  |  |  | OTHER |  |  |  | BALANCE
 |  | PERIOD (Yrs.) |  | DR. (CR.) |  | ADDITIONS |  | AMORTIZATION** |  | AMOUNT |  | (DESCRIBE) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Goodwill* |  |  |  |  |  |  |  |  | ** |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 0344 | Same signs as Hyperion
**MUST TIE TO HYPERION ACCOUNT 1418 | Reverse signs from Hyperion
Spreadsheet: stacey_white__39027__East Schedule C ERCOT MGMT (5-10-01)
Sheet: Schedule C - ERCOT MGMT

SCHEDULE C
DOCUMENTATION FORM |  |  | As of:
 |  |  | 2001-10-01 00:00:00
ITEM |  |  | DATA
Transaction or Book Name |  |  | ERCOT MGMT
Amount
Entry Date |  | 2001-05-01 00:00:00
Reason for Using Schedule C (e.g., income adjustment) |  |  | BP Energy/Green Mtn Deal # 606548 - Energy Reserve
 |  |  | (623,144 MW x $1.50)
 |  |  | BP Energy/Green Mtn Deal #597045/#597080/#597123/#597168
 |  |  | - Ancillary Reserve (623,144 MW x $1.00)
 |  |  | BP Energy/Green Mtn Deal - QSE Reserve (623,144 MW x $0.25)
Removal Date |  |  | 2002-12-31 00:00:00
(If amortization is required, attach the appropriate
amortization schedule)
Methodology for Removal (e.g., amortization or one time removal) |  |  | ?
Individual Using Schedule
Trader |  |  | Business Analysis & Reporting
Energy Operations/Structuring |  |  | [NAME]
Spreadsheet: 104599d1302135906-sort-max-and-min-based-off-another-column-book1
Sheet: Sheet1

 | Males |  |  | Females
 | [NAME] |  |  | [NAME]
 |  |  |  | ??? | ???
 | Most Pushups |  |  | Most Pushups
 |  |  |  | ??? | ???
 | Most Situps |  |  | Most Situps
 |  |  |  | ??? | ???
Spreadsheet: 814682d1674552318-calculating-pay-dates-payroll-dates
Sheet: Sheet1

 |  |  |  |  |  |  | Federal Holidays
 |  |  |  |  |  |  | 2023-01-02 00:00:00 | New Year’s Day
 |  |  |  |  |  |  | 2023-01-16 00:00:00 | Birthday of [NAME], Jr.
 |  |  |  |  |  |  | 2023-02-20 00:00:00 | Washington’s Birthday
 |  |  |  |  |  |  | 2023-05-29 00:00:00 | Memorial Day
 |  |  |  |  |  |  | 2023-06-19 00:00:00 | Juneteenth National Independence Day
 |  |  |  |  |  |  | 2023-07-04 00:00:00 | Independence Day
 |  |  |  |  |  |  | 2023-09-04 00:00:00 | Labor Day
 |  |  |  |  |  |  | 2023-11-09 00:00:00 | Columbus Day
 |  |  |  |  |  |  | 2023-11-10 00:00:00 | Veterans Day
 |  |  |  |  |  |  | 2023-11-23 00:00:00 | Thanksgiving Day
 |  |  |  |  |  |  | 2023-12-25 00:00:00 | Christmas Day
 | Pay Period 1 | Pay Period 2 | Pay Period 3 | Pay Period 4 | Pay Period 5 | Pay Period 6 | Pay Period 7 | Pay Period 8 | Pay Period 9 | Pay Period 10 | Pay Period 11 | Pay Period 12 | Pay Period 13 | Pay Period 14 | Pay Period 15 | Pay Period 16 | Pay Period 17 | Pay Period 18 | Pay Period 19 | Pay Period 20 | Pay Period 21 | Pay Period 22 | Pay Period 23 | Pay Period 24
 | 2023-01-01 00:00:00
 | 2023-01-15 00:00:00
10 Days after EOM
Legal Pay Date |  |  | 2023-02-24 00:00:00 |  | 2023-03-24 00:00:00 |  |  |  |  | 2023-06-09 00:00:00 | 2023-06-23 00:00:00 |  |  |  |  | 2023-09-08 00:00:00 |  |  |  |  | 2023-11-24 00:00:00 | 2023-12-08 00:00:00 | 2023-12-22 00:00:00
Accelerated Pay Date Reason |  |  | Payday is on Saturday |  | Payday is on Saturday | Payday is on Saturday |  |  |  | Payday is on Saturday | Payday is on Sunday |  |  |  |  | Payday is on Sunday |  |  |  |  | Payday is on Saturday | Payday is on Sunday | Payday is on Federal Holiday
Spreadsheet: 21969d1210256127-merging-data-test2
Sheet: Sheet1

Property Index Number | Address | Class | Neighborhood | Assessed Value | City | State | Zip Code | Year of Purchase | Purchase Price | Bldg Assess | Old Asses | Bldg. Sq. Ft | Assessment Ratio | First Name | Last Name
15011100090000 | 1415   Park Ave | 205 | 15 | 88642 | River Forest | IL | 60305 | 00/00/0000 | 0 | 52036 | 63981 | 2172 | 40.81123388581952
15-[PHONE] | 65  [NAME] | 205 | 15 | 95101 | River Forest | IL | 60306 | 2003-05-22 00:00:00 | 825000 | 54747 | 71264 | 2267 | 41.95015438906043
15011110160000 | 1211   Park Ave | 205 | 15 | 90321 | River Forest | IL | 60305 | 2004-07-01 00:00:00 | 725500 | 54796 | 66741 | 2035 | 44.38378378378378
15012080070000 | 1423   Monroe Ave | 205 | 15 | 96313 | River Forest | IL | 60305 | 2001-05-01 00:00:00 | 518000 | 49042 | 61074 | 2052 | 46.93615984405458
15012100050000 | 1427   [NAME] Pl | 205 | 15 | 86275 | River Forest | IL | 60305 | 00/00/0000 | 0 | 48029 | 62467 | 2150 | 40.12790697674419
15012100150000 | 1428   [NAME] | 205 | 15 | 63861 | River Forest | IL | 60305 | 2000-04-01 00:00:00 | 447000 | 48928 | 60960 | 2164 | 29.51062846580407
15012100180000 | 1414   [NAME] | 205 | 15 | 71586 | River Forest | IL | 60305 | 2002-06-01 00:00:00 | 570000 | 50742 | 62774 | 2091 | 34.23529411764706
15012120240000 | 1302   Jackson Ave | 205 | 15 | 70313 | River Forest | IL | 60305 | 2004-03-01 00:00:00 | 528500 | 47758 | 60662 | 1843 | 38.15138361367336
15-[PHONE] | 33 S Washington St | 205 | 15 | 74666 | River Forest | IL | 60305 | 2005-02-08 00:00:00 | 600000 | 52346 | 62888 | 1841 | 40.55730581205867
15014000100000 | 1140   Jackson Ave | 205 | 15 | 81366 | River Forest | IL | 60305 | 00/00/0000 | 0 | 47984 | 62192 | 1983 | 41.03177004538578
15014010160000 | 1118   [NAME] | 205 | 15 | 82476 | River Forest | IL | 60305 | 00/00/0000 | 0 | 48600 | 64241 | 2162 | 38.14801110083256
15014010180000 | 1106   [NAME] | 205 | 15 | 80352 | River Forest | IL | 60305 | 1996-07-31 00:00:00 | 325000 | 47859 | 63500 | 2080 | 38.63076923076923
Spreadsheet: darrell_schoolcraft__7382__FERC docket RM01-9_Dec2001final
Sheet: Item 2 - PQ2TRANSW120101

Seq # | PHC | Pipeline DUNS # | Pipeline Name | Filing Date | First Day of Reporting Period | Name of Contact Person | Phone Number of Contact Person | Original/Revised Filing Indicator
Seq # | PDC | Pipeline DUNS # | Contract or Transaction ID # | Offer # | Releasing Shipper Name | Releasing Shipper DUNS # | Acquiring Shipper Name | Acquiring Shipper DUNS # | Contract Quantity | Releasing Shipper's Contract Rate | Acquiring Shipper's Contract Rate | Term Begin Date | Term End Date | Award Date
1 | PHC | 7933047 | Transwestern Pipeline Company | 2002-02-01 00:00:00 | 2001-12-01 00:00:00 | [NAME] | (713) 853-6160 | O
2 | PDC | 7933047 | 8255 | 3155 | Southern California Gas Company | 6908826 | Enron Energy Services, Inc. | 4328568 | 2174 |  |  | 2001-12-01 00:00:00 | 2001-12-31 00:00:00 | 2001-11-21 00:00:00
3 | PDC | 7933047 | 8255 | 3156 | Southern California Gas Company | 6908826 | Enron Energy Services, Inc. | 4328568 | 7 |  |  | 2001-12-01 00:00:00 | 2001-12-31 00:00:00 | 2001-11-21 00:00:00
4 | PDC | 7933047 | 8255 | 3157 | Southern California Gas Company | 6908826 | BP Energy Company | 625275755 | 11 |  |  | 2001-12-01 00:00:00 | 2001-12-31 00:00:00 | 2001-11-21 00:00:00
5 | PDC | 7933047 | 8255 | 3158 | Southern California Gas Company | 6908826 | Exelon Energy Ohio, Inc. | 79333451 | 150 |  |  | 2001-12-01 00:00:00 | 2001-12-31 00:00:00 | 2001-11-21 00:00:00
6 | PDC | 7933047 | 8255 | 3159 | Southern California Gas Company | 6908826 | ACN Power, Inc. | 59091384 | 780 |  |  | 2001-12-01 00:00:00 | 2001-12-31 00:00:00 | 2001-11-21 00:00:00
7 | PDC | 7933047 | 8255 | 3160 | Southern California Gas Company | 6908826 | TXU Energy Trading California | 848757274 | 1037 |  |  | 2001-12-01 00:00:00 | 2001-12-31 00:00:00 | 2001-11-21 00:00:00
8 | PDC | 7933047 | 8255 | 3161 | Southern California Gas Company | 6908826 | Sempra Energy Solutions, LLC | 968254276 | 179 |  |  | 2001-12-01 00:00:00 | 2001-12-31 00:00:00 | 2001-11-21 00:00:00