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

WEST | TRADE DATE | Counterparty | Buy/Sell from EPMI View | Buy/Sell from EES View | Trader | Location | Type (PFI) | Term | Peak, Off-peak, Super Peak, [NAME] or Flat | Volume | Price | Broker,EOL, Internal or Notes | EPMI TRADER Providing Sleeve | EPMI Deal # | EES DEAL Tracker # | EES Traders
1 | 2001-02-15 00:00:00 | MERRILL | SELL | SLEEVE | BB | SP15 | P | 2001-03-01 00:00:00 | OFF-PEAK | -25 | -162.5 | APB | JR |  | 7968 | JW = [NAME]
2 |  | EES | BUY | SELL | NB | SP15 | P | 2001-03-01 00:00:00 | OFF-PEAK | 25 | 162.45 |  |  |  |  | NB= [NAME]
3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SS=Suneet Sharma
4 |  | IDAHO | SELL | SLEEVE | DC | SP | P | 2001-04-01 00:00:00 | OFF-PEAK | -25 | -120 | APB | JR |  | 7969
5 |  | EES | BUY | SELL | NB | SP | P | 2001-04-01 00:00:00 | OFF-PEAK | 25 | 119.95
6
7 |  | EES | BUY | SELL | NB | SP | P | Q4-01 | OFF-PEAK | 25 | 95 | APB | BB |  | 7971
8
9 |  | TRANSALTA | SELL | SLEEVE | BJ | NP | P | Q4-01 | OFF-PEAK | -25 | 145 | TFS | JR |  | 7972
10 |  | EES | BUY | SELL | NB | NP | P | Q4-01 | OFF-PEAK | 25 | 144.95
11
12 |  | EES | BUY | SELL | JW | SP | P | Q3 2001 | PEAK | 25 | 320 | INTERNAL | BB |  | 7970
13
14 |  | EES | BUY | SELL | JW | SP | P | Q3 2001 | OFF-PEAK | 25 | 145 | INTERNAL | BB |  | 7973
15
16 |  | EES | BUY | SELL | JW | SP | P | Q4 2001 | PEAK | 25 | 165 | INTERNAL | BB |  | 7974
17
18 |  | EES | BUY | SELL | JW | SP | P | 2001-06-01 00:00:00 | OFF-PEAK | 25 | 135 | INTERNAL | BB |  | 7975
19
20 |  | EES | BUY | SELL | JW | PV | P | CAL 06 | PEAK | 25 | 47 | PREBON | MM |  | 7976
21
22 |  | EES | BUY | SELL | JW | PV | P | CAL 06 | PEAK | 25 | 47.55 | TFS | MM |  | 7977
23
24 |  | EES | BUY | SELL | JW | MC | P | Q3 2001 | OFF-PEAK | 50 | 286 | AMEREX | MS |  | 7978
25
26 |  | EES | SELL | BUY | JW | COB | P | Q3 2001 | OFF-PEAK | -50 | -300 | AMEREX | MS |  | 7979
27
28 |  | ELPASO | SELL | SLEEVE | MS | MC | P | Q3 2001 | OFF-PEAK | -25 | -286 | AMEREX | MS |  | 7980
29 |  | EES | BUY | SELL | JW | MC | P | Q3 2001 | OFF-PEAK | 25 | 286
30
31 |  | ELPASO | BUY | SLEEVE | MS | COB | P | Q3 2001 | OFF-PEAK | 25 | 300 | AMEREX | MS |  | 7981
32 |  | EES | SELL | BUY | JW | COB | P | Q3 2001 | OFF-PEAK | -25 | -300.05
33
34 |  | ELPASO | SELL | SLEEVE | MS | MC | P | Q4 2001 | OFF-PEAK | -75 | -280 | AMEREX | MS |  | 7982
35 |  | EES | BUY | SELL | JW | MC | P | Q4 2001 | OFF-PEAK | 75 | 280
36
37 |  | ELPASO | BUY | SLEEVE | MS | COB | P | Q4 2001 | OFF-PEAK | 75 | 277.5 | AMEREX | MS |  | 7983
38 |  | EES | SELL | BUY | JW | COB | P | Q4 2001 | OFF-PEAK | -75 | -277.55
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
Spreadsheet: debra_perlingiere__8431__PanCanadian Energy Services
Sheet: AMASTPSA 

MASTER FIRM PURCHASE/SALE AGREEMENT INFORMATION SHEET
ENA Entity: | Enovate, LLC | ATTORNEY: | [NAME]
DATE: | 2001-10-18 00:00:00 | ENA CONTACT: | [NAME]
COUNTERPARTY: | PanCanadian Energy Services Inc. | CONTACT: | [NAME]
ADDRESS: | 1200 Smith Street | TITLE: | Director
 | Suite 900 | PHONE: | [PHONE]
 | Houston, TX 77002 | FAX: | [PHONE]
INCORPORATION STATE: |  | S&P RATING:
STRUCTURE | COUNTERPARTY | Enovate, LLC
COLLATERAL
THRESHOLD  in $ | $4MM | $4MM
COMMITTED VOLUMES
THRESHOLD in $[NAME] | N/A | N/A
COLLATERAL REQUIRED FOR:
ALL TRADES
OTHER | N/A | N/A
COLLATERAL TYPE
Letter of Credit | OK | OK
COLLATERAL  MULTIPLE | 250000 | 250000
GUARANTOR (RATING) | N/A | Enron Corp. (BBB+)/ Peoples Energy Corp. (A)
LIMIT in $[NAME] |  | $4MM
Incorporation State: |  | OR/IL
MATERIAL ADVERSE CHANGE TRIGGERS  APPLY TO:
-Counterparty | X
-Guarantor |  | X
Debt Ratings Change |  | X
-Below = |  | BBB-/Baa3 | S&P/Moody's
Financial Covenants | X
-Funded Debt/Net Worth
-Minimum EBITDA, for trailing 12 months
-Minimum Cash & Cash equivalents
-Current Ratio
Non-Specific
-Unilateral
Ownership Change
-Less than 51% owned by:
Non-Standard Definitions
-Funded Debt
-Net Worth | $175MM
-Cash Flow
EVENTS OF DEFAULT
3rd party debt
-Counterparty | $10MM
-Guarantor ($[NAME]) |  | $100MM/$100MM
FIN'L STATEMENTS
-Standard | X | X | Upon request
CREDIT DECISION: | APPROVED:  X | DECLINED:
OUTSTANDING PHYSICAL TRADES: |  | YES: | NO:
ALL TRADES TO ROLL UP UNDER NEW MASTER: |  | YES: | NO:
OTHER COMMENTS
$4MM guarantee constitutes $2MM each from Enron and Peoples on behalf of Enovate LLC
CREDIT REVIEW  PREPARED BY: |  | [NAME] | X5-3596
Spreadsheet: b5f1031c-9483-42d7-8462-8a830f2c2a4e
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
WNVP | Test | WNVP | West Nile Virus (WNV), Molecular Detection, PCR, Plasma | West Nile Virus PCR, P | Real-Time Polymerase Chain Reaction (PCR)/RNA [NAME] (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) |  |  |  | 0.8 |  | Container/Tube: Lavender top (EDTA) [NAME]: 0.8 mL Forms: If not ordering electronically, submit a Microbiology Request Form (Supply T244) with the specimen. | 0.3 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	Plasma gel tube | Not applicable Positive results will be reported as WNV nucleic acid detected. | Monday through Saturday; Continuously 7 a.m.-8 p.m. (June through November) Mond | Monday through Thursday: 2 days Friday, Saturday: 3 days | 5 days | 1 | 87798 |  |  |  |  | Rochester
WNVP | [NAME] | PLEDTA | [NAME] |  |  |  | Refrigerated | 7 days
WNVP | Result | [NAME] | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2
WNVP | Result | 56072 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34892-0
WNVP | Result | 56073 | Special Information | Special Information | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48767-8
WNVP | Result | 56074 | Report Status | Report Status | Alphanumeric
Spreadsheet: 684828d1593558607-evaluated-result-is-incorrect-due-to-circular-reference-example-problem
Sheet: Experimental sheet

 | Example 1 | X | 0
 |  | Y's | Number of Y's | Alocation of X | Number of Y's after Allocation | Z |  | Y*Z's
 |  | Y1 | 6 |  |  | Z1 | 0.5 | Y1*Z1
 |  | Y2 | 3 |  |  | [NAME] | 0.5 | Y2*Z2
 |  | Y3 | 1 |  |  | Z3 | 0.5 | Y3*Z3
 |  | Y4 | 0 | 0 |  | Z4 | 0.5 | Y4*Z4
 | Example 2 | X | 0
 |  | Y's | Number of Y's | Alocation of X | Number of Y's after Allocation | Z |  | Y*Z's
 |  | Y1 | 6 |  |  | Z1 | 0.5 | Y1*Z1
 |  | Y2 | 3 |  |  | [NAME] | 0.4 | Y2*Z2
 |  | Y3 | 1 |  |  | Z3 | 0.3 | Y3*Z3
 |  | Y4 | 0 | 0 |  | Z4 | 0.2 | Y4*Z4
Spreadsheet: 100315d1298676831-what-formula-s-would-you-use-excelproblem_book1
Sheet: book 1

 | Original |  |  | Updated
Title | Start Date | End Date | Title | Start Date | End Date
3000 Miles to Graceland | 2008-05-01 00:00:00 | 2008-10-31 00:00:00 | Across the Pacific | 2007-02-01 00:00:00 | 2008-02-28 00:00:00
The Accidental Tourist | 2009-01-01 00:00:00 | 2009-10-31 00:00:00 | [NAME]: When Nature Calls | 2010-02-01 00:00:00 | 2010-03-31 00:00:00
[NAME]: When Nature Calls | 2010-02-01 00:00:00 | 2010-03-31 00:00:00 | Accidental Tourist, The | 2009-01-01 00:00:00 | 2009-09-30 00:00:00
Across the Pacific | 2007-02-01 00:00:00 | 2008-01-31 00:00:00 | 3000 Miles to Graceland | 2008-06-01 00:00:00 | 2008-10-31 00:00:00
Spreadsheet: 216021d1361560584-price-variance-and-dollar-variance-for-multiple-stores-on-certain-products-store-price-check
Sheet: Sheet1

2013-02-21 00:00:00
Store Price Variances |  |  |  |  |  | Store | Price
Item # | Item Description | Store 1 | Store 2 | Store 3 | Store 4 | Analysis | [NAME]
001038 | Bread | 2.96 | 3.51 | 2.96 | 3.51
001060 | Water | 0.59 | 0.89 | 0.59 | 0.59
001089 | Milk | 4.19 | 0 | 0 | 4.19
001091 | Soda | 0.99 | 0.89 | 1.89 | 0.99
001103 | Tenderloin | 3.49 | 3.49 | 3.99 | 4.5
001127 | Chicken | 2.89 | 2.89 |  | 2.89
001141 | Fruits | 3.5 | 3.5 | 3.5 | 3.5
001149 | Veggies | 2.8 | 2.8 | 2.21 | 2.8
Spreadsheet: 93132d1292632063-report-on-data-copy-of-example-1
Sheet: Sheet3

Month | Manager | No Response | Approved | Terminated
1/2010 | Rogers, [NAME] | 1 | 0 | 0
1/2010 | Simmons, [NAME] | 1 | 1 | 0
2/2010 | Cooper, [NAME] | 1 | 0 | 1
2/2010 | Rocker, [NAME] | 0 | 0 | 1
Spreadsheet: 4eb2a32f-b053-484b-915b-1abe39d89f55
Sheet: Sheet1

Fixed Network Telecommunication | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
Jan. 2012
Operator | No. of Ope- rators | [NAME] |  |  |  | Long-distance Network |  | International Network |  |  |  | ISDN Subscribers | No. of ADSL Lines | No. of Public Telephone Set
 |  | Operating  Revenue  (1000 NT$) | No. of Subscribers | Outgoing Minutes | No.of Fixed Lines | Operating Revenue  (1000 NT$) | Outgoing Minutes | Operating Revenue  (1000 NT$) | Outgoing Minutes | Outgoing Calls | Incoming Minutes
Total | 4 | 6118832 | 12632172 | 1142753081 | 19118031 | 623716 | 344907370 | 2169000 | 431972872 | 98082606 | 383773760 | 123617 | 4315414 | 82121
Spreadsheet: c68967d7-2f25-4607-8ead-26c9b2095f12
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2013-09-24 09:31:43.120000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
4.625 | 102.101 | 101.976 | 101.851 | 101.476
4.5 | 101.261 | 101.136 | 101.011 | 100.636 |  | Note: | Refer To Price [NAME]
4.375 | 100.385 | 100.26 | 100.135 | 99.76 |  |  | For all Price Adjs
4.25 | 99.796 | 99.671 | 99.546 | 98.921
4.125 | 99.054 | 98.929 | 98.804 | 98.179
4 | 98.135 | 98.01 | 97.885 | 97.26
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 102.125 | 102 | 101.875 | 101.5
3.75 | 101.811 | 101.686 | 101.561 | 101.186
3.625 | 101.42 | 101.295 | 101.17 | 100.795
3.5 | 100.915 | 100.79 | 100.665 | 100.29
3.375 | 100.212 | 100.087 | 99.962 | 99.337
3.25 | 99.469 | 99.344 | 99.219 | 98.594
3.125 | 98.554 | 98.429 | 98.304 | 97.679 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2013-10-08 09:31:43.120000
30 DAY | 2013-10-23 09:31:43.120000
45 DAY | 2013-11-07 09:31:43.120000
60 DAY | 2013-11-22 09:31:43.120000
90 DAY | 2013-12-22 09:31:43.120000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 708347d1607739246-clustered-if-else-combination-sample-bvj-
Sheet: Sheet1

randomized (F9) |  | Results
 |  |  | =AND($A23>30,$B23>30)*7 | =AND($A23=MEDIAN(26,$A23,30),$B23=MEDIAN(26,$B23,30))*5 | =AND($A23<20,$B23<20)*1 | =AND(OR($A23>30,$B23>30),OR($A23=MEDIAN(26,$A23,30),$B23=MEDIAN(26,$B23,30)))*6
Spreadsheet: 816959d1675922358-add-calculate-field-in-pivot-year
Sheet: Sheet7

Accounting Year | Accounting Month | Name | VOL
2022 | 2022 - 01 | AAA | 100
2022 | 2022 - 01 | BBB | 300
2023 | 2023 - 01 | AAA | 299
2023 | 2023 - 01 | BBB | 200
 |  |  |  |  |  |  | Accounting Month | (All)
 |  |  |  |  |  |  | Sum of VOL | Accounting Year
 |  |  |  |  |  |  | Name | 2022 | 2023 | Growth | %Growth
 |  |  |  |  |  |  | AAA | 100 | 299
 |  |  |  |  |  |  | BBB | 300 | 200
 |  |  |  |  |  |  | Grand Total | 400 | 499
Spreadsheet: 735276d1622808142-complex-if-sum-test1
Sheet: Sheet1

Top | Bottom | side | side B | Amend needed?
Yes | Yes | Yes | No
No | Yes | No | Yes
No | No | No | No
Yes | No | No | no
Spreadsheet: 673157d1587221504-turn-large-horizontal-list-into-vertical-list-list-test
Sheet: Sheet1

1 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
2 |  | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22
3 |  | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
Spreadsheet: 3a725fa6-1c2f-4948-9dcf-94240f9ab4f6
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Public reporting burden for this collection of information is estimated to average 1 hour.  This includes the time for collecting, reviewing, and reporting the data.  The information is being collected to obtain the supportive documentation which must be submitted to HUD for approval, and is necessary to ensure that viable projects are developed and maintained.  The Department will use this information to determine if properties meet HUD requirements with respect to development, operation and/or asset management, as well as ensuring the continued marketability of the properties. This agency may not collect this information, and you are not required to complete this form, unless it displays a currently valid OMB control number.   Warning: Any person who knowingly presents a false, fictitious, or fraudulent statement or claim in a matter within the jurisdiction of the U.S. Department of Housing and Urban Development is subject to criminal penalties, civil liability, and administrative sanctions.
 | Project Name | Enter Name
 | FHA Project No. | 000-00000
 | Address | Enter Address
 | Instructions: Only light blue cells can be edited. Enter the staffing positions and salary projections for the subject as of the date when stabilized occupancy is realized. This tab is to be completed for both New Construction and for [NAME] and 241a loans.  For Substantial Rehabilitation and 241a loans also fill out the second tab (Current Staffing Schedule) with the subject's current staffing and salary information.
 | Indicate the year in which stabilized occupancy will be reached. |  |  | enter year
 | Job Title |  | # of Employees | Combined Hours Per Week | Combined Annual Salaries
 | Administrative
 | e.g. Administrator
 | e.g. Business Office
 | e.g. Receptionist
 | e.g. Marketing Manager
 | e.g. Marketing Assistant
 | Administrative - Payroll Taxes & Benefits
 | Total - Administrative |  |  |  | 0
 | Building & Grounds
 | e.g. [NAME]
 | e.g. Housekeeping Manager
 | e.g. Housekeepers
 | Building & Grounds - Payroll Taxes and Benefits
 | Total - Building & Grounds |  |  |  | 0
 | Activities & Other
 | e.g. Activities Director
 | e.g. Activities Assistant
 | e.g. Transportation
 | Activities & Other - Payroll Taxes and Benefits
 | Total - Activities & Other |  |  |  | 0
 | Personal Care
 | e.g. Registered Nurses
 | e.g. LPN’s
 | e.g. CNAs
 | Personal Care - Payroll Taxes and Benefits
 | Total - Personal Care |  |  |  | 0
 | Dietary
 | e.g. Chef/Manager
 | e.g. Cooks
 | e.g. Assistants
 | Dietary - Payroll Taxes and Benefits
 | Total - Dietary |  |  |  | 0
 | Totals
 | Combined Number of Hours |  |  |  | 0
 | Full Time Equivalents Total (total # of hours divided by 40) |  |  |  | 0
 | Total Number of Employees (full time and part time) |  |  |  | 0
 | Total Annual Salaries Paid |  |  |  | 0
 | Total Annual Taxes & Benefits |  |  |  | 0
 | Total Annual Salaries with Benefits |  |  |  | 0
Spreadsheet: 98219d1297215436-conditional-list-conditional-list
Sheet: Sheet1

MR # | Admit Date | Last | First
1001 | 2011-01-01 00:00:00 | Jones | [NAME]
1002 | 2011-01-02 00:00:00 | Marcus | [NAME]
1003 | 2011-01-15 00:00:00 | [NAME] | Mark
1004 | 2011-01-22 00:00:00 | Wainwright | [NAME]
1001 | 2011-02-01 00:00:00 | Jones | [NAME]
1005 | 2011-02-05 00:00:00 | Anglo | Leonard
Spreadsheet: cff238f0-61cb-4577-aef7-ca9b1190357e
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
TPSF | Test | TPSF | Protein, Total, Spinal Fluid | Protein, Total, CSF | Measure by Reflectance Spectrophotometry | Plastic vial: PlV |  |  | 1 | mL | Container/Tube: Sterile vial [NAME]: 1 mL Collection Instructions: Centrifuge specimen to remove any cellular material. | 0.25 mL | Hemolysis	NA Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | > or =12 months: 0-35 mg/dL Reference values have not been established for patients that are <12 months of age. | Monday through Sunday; Continuously | Same day/1 day | 2 days | 1 | 84157 |  |  |  |  | Rochester
TPSF | [NAME] | CSF | CSF |  |  |  | Refrigerated | 72 hours
TPSF | Result | TPSF | Protein, Total, CSF | Protein, Total, CSF | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 2880-3
Spreadsheet: darron_c_giron__7992__midland_cogen
Sheet: Jul00

ENRON CAPITAL & TRADE RESOURCES
NETBACK AND FIRM CALCULATIONS
2000-07-01 00:00:00
IFGMR (TRKL/TX) |  |  | 4.29 |  |  | No. of Days: | 31
IFGMR (TRKL/LA) |  |  | 4.29
IFGMR (PEPL/TX/OK) |  |  | 4.2
IFGMR (ANR/LA) |  |  | 4.28
IFGMR (HENRY HUB) |  |  | 4.36
NX3 |  |  | 4.5383
Sitara 10227
MIDLAND COGENERATION VENTURES
CONTRACT #16-60548-302 (Ultramar)
FIXED CONTRACT: | YEAR | PRICE | YEAR | PRICE
 | 1992 | 2.52 | 2001
 | 1993 | 2.4 | 2002
 | 1994 | 2.51 | 2003
 | 1995 | 2.61 | 2004
 | 1996 | 2.53 | 2005
 | 1997 | 2.65 | 2006
 | 1998 |  | 2007 | 6.37
 | 1999
 | 2000
TERM: Through year 2004 ([NAME])  with annual renewal thereafter.
MaxDQ: 8500 MMBtu/DAY
MinDQ: 60% OF MaxDQ F7,000 MMBtu/DAY | DQ for December, January, and February, 80% of MaxDQ for all other months.
Sitara 10226
MIDLAND COGENERATION VENTURES
CONTRACT #016-60548-305 (Union Pacific)
PEPL VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.5 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR(PEPL-TX/OK)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TRIGGER* |  | 2.5
DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
DESIGNATED QUANTITY -PEPL |  | 5000 | MMBTU/D
ANR VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.5 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR (ANR/LA)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TRIGGER* |  | 2.5
DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
[NAME] -ANR |  | 4000 | MMBTU/D
TRKL/ LA-TRKL/TX AVG  VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.5 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS AVG IFGMR (TRKL/LA)/IFGMR(TRKL/TX)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TRIGGER* (TX) |  | 2.5 |  | BASIS DIFFERENTIAL
TRIGGER* (LA) |  | 2.5 |  | IFGMR (HENRY HUB)
DIFFERENTIAL (TX) |  |  |  | LESS AVG IFGMR (TRKL/LA)
DIFFERENTIAL (LA) |  |  |  | BASIS DIFFERENTIAL
DESIGNATED TRKL TOTAL |  | 6000 | MMBTU/D | BASIS DIFFERENTIAL
 |  |  |  | IFGMR (HENRY HUB)
*Customer prefers rounding to nearest penny. |  |  |  | LESS AVG IFGMR(TRKL/TX)
 |  |  |  | BASIS DIFFERENTIAL
Spreadsheet: 773779d1648044963-compare-2-lists-to-identify-matches-existing-values-test1v2
Sheet: Sheet1

ID | Sheet2 Column H = ABC | Expected | Sheet2 Column H = ABC AND Sheet2 Column J = XYZ | Expected
[PHONE] |  | Yes
[PHONE] | Yes | Yes
[PHONE]
[PHONE]
[PHONE]
[PHONE] | Yes | Yes | Yes | Yes
[PHONE] | Yes | Yes | Yes | Yes
[PHONE]
[PHONE]
[PHONE] | Yes | Yes | Yes | Yes
[PHONE] | Yes | Yes
[PHONE] | Yes | Yes
[PHONE]
Spreadsheet: 881842d1730073423-count-if-max-book1
Sheet: Sheet2

M COOPER (1)
A GILCHRIST  (2)
S MCCALLUM (3)
O ARBLASTER  (4)
G BOLDOCK (STARMAN)
H SOUTTAR (6)
R BREWSTER  (7)
G HAMER  (8)
K MOORE (9)
C O'HARE  (10)
J RAK-SAKYI (11)
I GRBIC (13)
H BURROWS (14)
A AHMEDHODZIC (15)
J SHACKLETON (16)
A DAVIES (17)
J ROBINSON (19)
V DE SOUZA COSTA (21)
T DAVIES (22)
T CAMPBELL (23)
A BEN SLIMANE  (25)
I [NAME] (29)
R NORRINGTON-DAVIES  (33)
L MARSH  (34)
A BROOKS  (35)
F SERIKI  (38)
R ONE (39)
S PECK  (42)
H BOYES  (43)
O [NAME]  (44)
S SACHDEV (45)
Spreadsheet: 190381d1351627678-leave-a-cell-with-a-formula-blank-until-another-is-filled-in-petty-cash
Sheet: Nov 12

Starting balance |  |  |  |  | 100
Date | Product | Ref | Debit | Credit | Balance | Note
2012-10-01 00:00:00 | [NAME] | 1 | 7
2012-10-02 00:00:00 | Cash | 1232435455 |  | 50
Spreadsheet: 776347d1649691173-display-start-time-and-end-time-overlapping-overlapping
Sheet: Feuil3

Start reference time | End reference time |  |  |  |  | Start reference time | End reference time
09:00:00 | 11:00:00 |  |  |  |  | 21:00:00 | 02:00:00
Schedule |  |  | What I need |  |  | Schedule |  |  | What I need
Start time | End time |  | Start overlap time | End overlap time |  | Start time | End time |  | Start overlap time | End overlap time
07:00:00 | 08:00:00 |  | no overlap | no overlap |  | 19:00:00 | 20:00:00 |  | no overlap | no overlap
07:00:00 | 09:00:00 |  | no overlap | no overlap |  | 19:00:00 | 21:00:00 |  | no overlap | no overlap
07:00:00 | 10:00:00 |  | 09:00:00 | 10:00:00 |  | 19:00:00 | 22:00:00 |  | 21:00:00 | 22:00:00
07:00:00 | 11:00:00 |  | 09:00:00 | 11:00:00 |  | 19:00:00 | 00:00:00 |  | 21:00:00 | 00:00:00
07:00:00 | 13:00:00 |  | 09:00:00 | 11:00:00 |  | 19:00:00 | 01:00:00 |  | 21:00:00 | 01:00:00
09:00:00 | 13:00:00 |  | 09:00:00 | 11:00:00 |  | 19:00:00 | 02:00:00 |  | 21:00:00 | 02:00:00
10:00:00 | 13:00:00 |  | 10:00:00 | 11:00:00 |  | 19:00:00 | 04:00:00 |  | 21:00:00 | 02:00:00
11:00:00 | 13:00:00 |  | no overlap | no overlap |  | 21:00:00 | 04:00:00 |  | 21:00:00 | 02:00:00
12:00:00 | 13:00:00 |  | no overlap | no overlap |  | 22:00:00 | 04:00:00 |  | 22:00:00 | 02:00:00
 |  |  |  |  |  | 01:00:00 | 04:00:00 |  | 01:00:00 | 02:00:00
 |  |  |  |  |  | 02:00:00 | 04:00:00 |  | no overlap | no overlap
 |  |  |  |  |  | 03:00:00 | 04:00:00 |  | no overlap | no overlap