tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 780309d1652379631-getting-an-error-code-when-trying-to-add-more-conditions-columns-to-an-if-statement-calendar-draft
Sheet: What I Want

Exam | Level | Department | Designation | Name on [NAME] | Date
COMLEX-USA | Level 1 | All | Launch | Level 1 Cycle Launch | 2022-05-10 00:00:00
COMLEX-USA | Level 1 | Test Development Editing | SECR | L1 Scorable [NAME] | 2022-05-16 00:00:00
All | All | All | Office Closure |  | 2022-05-30 00:00:00
COMLEX-USA | Level 1 | Test Development Editing | SECR | L1 Scorable ECR Ends | 2022-06-01 00:00:00
COMLEX-USA | Level 1 | Test Development Editing | PTECR | L1 Pretest ECR | 2022-06-02 00:00:00
COMLEX-USA | Level 1 | Test Development Editing | PTECR | L1 Pretest ECR | 2022-06-03 00:00:00
COMLEX-USA | Level 1 | Test Development | KV | L1 Key Validation Begins | 2022-06-03 00:00:00
COMLEX-USA | Level 1 | Test Development | KV | L1 Key Validation Ends | 2022-06-08 00:00:00
COMLEX-USA | Level 3 | Test Development Editing | IWW | [NAME] | 2022-06-10 00:00:00
COMLEX-USA | Level 3 | Test Development Editing | IWW | [NAME] | 2022-06-11 00:00:00
COMLEX-USA | Level 2 | All | Launch | Level 2 Cycle Launch | 2022-06-14 00:00:00
COMLEX-USA | Level 1 | Test Development Editing | SECR | L1 Scorable [NAME] | 2022-06-14 00:00:00
COMLEX-USA | Level 2 | Test Development Editing | SECR | L1 Scorable [NAME] | 2022-06-14 00:00:00
COMLEX-USA | Level 1 | Test Development Editing | PTECR | L1 Pretest ECR | 2022-06-17 00:00:00
Spreadsheet: 839147d1691690545-lookup-example
Sheet: Income

 | INCOME
 |  |  |  |  |  |  |  | Total Made
 | Date | Item | Income Stream | Price | Payment | Fees | Postage | Total | Notes |  |  | Fees | Pecentage | Column2
 | 20th May 2023 | Honeycomb | Craft Market | 20 | Cash |  | 0 |  | Lutterworth |  |  | Cash | 0
 | 20th May 2023 | [NAME] | Craft Market | 15 | SumUp |  | 0 |  | Lutterworth |  |  | Paypal | 0.029 | 30p
 | 20th May 2023 | [NAME] | Craft Market | 15 | Cash |  | 0 |  | Lutterworth |  |  | SumUp | 0.0169
 | 20th May 2023 | Dragonfly | Craft Market | 10 | Cash |  | 0 |  | Lutterworth |  |  | Stripe | 0.015 | 20p
 | 20th May 2023 | Honeycomb | Craft Market | 20 | Cash |  | 0 |  | Lutterworth
 | 27th May 2023 | [NAME] | Craft Market | 25 | SumUp |  | 0 |  | Hinckley
 | 27th May 2023 | Gothic Spinner & [NAME] | Craft Market | 35 | SumUp |  | 0 |  | Hinckley
 | 27th May 2023 | Rainbow Spinner & Squirly Heart | Craft Market | 35 | SumUp |  | 0 |  | Hinckley
 | 27th May 2023 | [NAME] | Craft Market | 15 | Cash |  | 0 |  | Hinckley
 | 3rd June 2023 | [NAME] | Craft Market | 25 | Cash |  | 0 |  | [NAME]
 | 8th June 2023 | Poppy Spinner | Craft Market | 25 | Paypal |  | 3.29 |  | March
 | 8th June 2023 | Dragonfly | Craft Market | 10 | Cash |  | 0 |  | March
 | 8th June 2023 | Honeycomb | Craft Market | 20 | Cash |  | 0 |  | March
 | 22nd June 2023 | Custom Dangle & Custom Heart | Craft Market | 40 | SumUp |  | 3.29 |  | Banbury
 | 22nd June 2023 | Dragonfly | Craft Market | 10 | Cash |  | 0 |  | Banbury
 | 22nd June 2023 | [NAME] | Craft Market | 10 | Cash |  | 0 |  | Banbury
 | 22nd June 2023 | Honeycomb | Craft Market | 20 | Cash |  | 0 |  | Banbury
 | 22nd June 2023 | Crystal Sqaure | Craft Market | 20 | Cash |  | 0 |  | Banbury
 | 22nd June 2023 | [NAME] | Craft Market | 25 | Cash |  | 0 |  | Banbury
 | 4th August | [NAME] | Website | 20 | Stripe |  | 3.29
Spreadsheet: 390993d1429820585-calculating-a-due-date-based-on-a-range-of-payment-terms-test-sheet
Sheet: Payment Terms

 | Site by client | Agreed Terms
 | ABC
 | A | 30
 | B | 30 EOM
 | C | 45
 | D | 60 EOM
 | ADA
 | E | 30 EOM
 | F | 42
 | G | 35
 | H | 60
 | BCR
 | I | 45 EOM
 | J | 30 EOM
 | K | 30 EOM
 | L | 30
Spreadsheet: 47865d1247036883-sorting-non-unique-rows-of-data-into-another-worksheet-example
Sheet: 130

Account | ID# | Src | Date | Memo/Payee | Debit | Credit | Code | Job No. | Job Name
01 | ID-2 | GJ | 1/2/2009 |  | 200 |  | 130
01 | ID-2 | GJ | 1/2/2009 |  | 5 |  | 130
01 | ID-2 | GJ | 1/2/2009 |  | 254352 |  | 130
Spreadsheet: 173852d1344810659-dynaimc-sum-range-sample
Sheet: Season

2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00
0.2 | 0.3 | 0.4 | 0.1 | 0.12 | 0.1 | 0.09 | 0.1 | 0.12 | 0.07 | 0.1 | 0.03 | 0.05 | 0.02 | 0.1
Spreadsheet: 82306d1282310486-retrieve-specific-data-challenging-dummy
Sheet: Dataset

City1 | City2 | City3 | City4 | City5 | [NAME] | City7 | City8 | City9 | City10 | City11 | City12 | City13 | City14 | City15 | City16 | City17 | City18 | City19 | City20 | City21 | City22 | City23 | City24 | City25 | City26 | City27 | City28 | City29 | City30 | City31 | City32 | City33 | City34 | City35 | City36 | City37 | City38 | City39 | City40 | City41 | City42 | City43 | City44 | City45 | [NAME] | City47 | City48 | City49 | City50 | City51 | City52 | City53 | City54 | City55 | City56 | City57
19930 | 19393 | 19977 | 19994 | 19393 | 0 | 0 | 0 | 19977 | 20078 | 19805 | 20416 | 20312 | 0 | 0 | 19790 | 19690 | 19805 | 20192 | 20312 | 0 | 19790 | 0 | 0 | 19386 | 19386 | 20192 | 20211 | 19393 | 19994 | 19704 | 20436 | 20211 | 0 | 0 | 20355 | 0 | 0 | 19704 | 0 | 19991 | 19930 | 20355 | 20355 | 19386 | 0 | 19805 | 19393 | 19704 | 19393 | 19790 | 20437 | 0 | 0 | 19930 | 20314 | 20386
0 | 19991 | 0 | 0 | 19930 | 0 | 0 | 0 | 20078 | 0 | 20386 | 0 | 20416 | 0 | 0 | 20437 | 0 | 19977 | 20312 | 0 | 0 | 0 | 0 | 0 | 20416 | 20192 | 20314 | 0 | 19991 | 0 | 20416 | 0 | 20386 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20192 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 19994 | 0 | 0
0 | 0 | 0 | 0 | 19977 | 0 | 0 | 0 | 20192 | 0 | 0 | 0 | 20437 | 0 | 0 | 0 | 0 | 0 | 20436 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 19994 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 19994 | 0 | 0 | 0 | 20436 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20312 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 20078 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 20386 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: mary_fischer__25606__31Z
Sheet: E5.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY #  031Z
COMPANY NAME    LINC
ANALYSIS OF GOODWILL
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 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.)
Purchase of LINC by Anjou |  | 40 |  | 3120000
Total Goodwill* |  |  |  |  |  |  |  |  | ** |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 0344 | Same signs as Hyperion
**MUST TIE TO HYPERION ACCOUNT 1418 | Reverse signs from Hyperion
Spreadsheet: 27e1dbf7-f1c1-411a-b889-7c91ea7ccb53
Sheet: 8c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120-360 | 360+ | TOTAL
Basis | - | - | 7 | 6 | 19 | 9 | 28 | 6 | 75
Cap/Floor | 6 | - | 11 | 21 | 112 | 49 | 12 | - | 211
Debt Option |  |  |  |  |  |  |  |  | -
Exotic |  |  |  |  |  |  |  |  | -
Fixed-Fixed | 14 | - | - | 4 | 8 | 5 | - | - | 31
Fixed-Float | 81 | 34 | 212 | 1516 | 2104 | 2533 | 3252 | 734 | 10466
FRA | 14 | 56 | 107 | 26 | 14 | - | - | - | 217
Inflation | 4 | - | 6 | 8 | 35 | 21 | 26 | 7 | 107
OIS | 12 | 13 | 27 | 35 | 79 | 21 | 19 | - | 206
Swaption | - | - | - | 82 | 121 | 301 | 293 | 83 | 880
TOTAL | 131 | 103 | 370 | 1698 | 2492 | 2939 | 3630 | 830 | 12193
Spreadsheet: 796962d1663653836-how-to-incorporate-an-or-into-my-sumifs-sum-ifs
Sheet: Sheet1

Security | PMT | Coupon 1 | Coupon 2
Bond 1 | 1000 | 2022-09-30 00:00:00
Bond 2 | 500 | 2022-10-31 00:00:00
Bond 3 | 4000 | 2022-09-30 00:00:00
Bond 4 | 2000 | 2022-12-31 00:00:00
Bond 5 | 900 | 2022-11-30 00:00:00
 |  |  |  |  | 2022-09-30 00:00:00 | 2022-10-31 00:00:00 | 2022-11-30 00:00:00 | 2022-12-31 00:00:00 | 2023-01-31 00:00:00 | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00
 |  |  |  | Bond 1
 |  |  |  | Bond 2
 |  |  |  | Bond 3
 |  |  |  | Bond 4
 |  |  |  | Bond 5
Spreadsheet: 737402d1624396062-formula-for-keeping-future-numbers-at-zero-before-being-asked-to-calculate-excel-help-with-formula
Sheet: Sheet1

 | Feb 2021 | Mar 2021 | Apr 2021 | May 2021 | Jun 2021 | Jul 2021 | Aug 2021 | Sep 2021 | Oct 2021 | Nov 2021 | Dec 2021
Total Paid | 0 | 360 | 899 | 438 | 1545.3 | 0 | 0 | 0 | 0 | 0 | 0
Total Dist (Current Month) | 0 | 360.92 | 899 | 438 |  |  | 0 | 0 | 0 | 0 | 0
Total Dist (Future Months) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Net Overpayment | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Principal Beginning Balance | 3904.12
Monthly Accrual | 354.92 | 354.92 | 354.92 | 354.92 | 354.92 | 0 | 0 | 0 | 0 | 0 | 0
Amount Paid (to Current) | 0 | 354.92 | 354.92 | 354.92 | 354.92
Amount Paid (to [NAME]) | 0 | 6
Principal Ending Balance | 4259.04
Interest Balance
Interest Added | 32.53 | 35.44 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
Amount Paid (to Interest) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Interest Ending Balance | 32.53
Clearing House Fees
Principal Beginning Balance | 8 | 8 | 16 | 24
Amount Paid | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Principal Ending Balance | 8 | 16 | 24
Spreadsheet: 05f80a87-1d8f-4476-bc2c-2abf5e8ef7f6
Sheet: BOLO

 |  |  | 2014 Bread Of Life Outreach Pick-Up Calendar
 | January |  |  |  |  |  |  |  | February |  |  |  |  |  |  |  | March
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  |  | 1 | 2 | 3 | 4 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1
 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8
 | 12 | 13 | 14 | 15 | 16 | 17 | 18 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15
 | 19 | 20 | 21 | 22 | 23 | 24 | 25 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22
 | 26 | 27 | 28 | 29 | 30 | 31 |  |  | 23 | 24 | 25 | 26 | 27 | 28 |  |  | 23 | 24 | 25 | 26 | 27 | 28 | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | 31
 | April |  |  |  |  |  |  |  | May |  |  |  |  |  |  |  | June
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  | 1 | 2 | 3 | 4 | 5 |  |  |  |  |  | 1 | 2 | 3 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | 8 | 9 | 10 | 11 | 12 | 13 | 14
 | 13 | 14 | 15 | 16 | 17 | 18 | 19 |  | 11 | 12 | 13 | 14 | 15 | 16 | 17 |  | 15 | 16 | 17 | 18 | 19 | 20 | 21
 | 20 | 21 | 22 | 23 | 24 | 25 | 26 |  | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  | 22 | 23 | 24 | 25 | 26 | 27 | 28
 | 27 | 28 | 29 | 30 |  |  |  |  | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  | 29 | 30
 | July |  |  |  |  |  |  |  | August |  |  |  |  |  |  |  | September
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  | 1 | 2 | 3 | 4 | 5 |  |  |  |  |  |  | 1 | 2 |  |  | 1 | 2 | 3 | 4 | 5 | 6
 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | 13 | 14 | 15 | 16 | 17 | 18 | 19 |  | 10 | 11 | 12 | 13 | 14 | 15 | 16 |  | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | 20 | 21 | 22 | 23 | 24 | 25 | 26 |  | 17 | 18 | 19 | 20 | 21 | 22 | 23 |  | 21 | 22 | 23 | 24 | 25 | 26 | 27
 | 27 | 28 | 29 | 30 | 31 |  |  |  | 24 | 25 | 26 | 27 | 28 | 29 | 30 |  | 28 | 29 | 30
 |  |  |  |  |  |  |  |  | 31
 | October |  |  |  |  |  |  |  | November |  |  |  |  |  |  |  | December
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  |  | 1 | 2 | 3 | 4 |  |  |  |  |  |  |  | 1 |  |  | 1 | 2 | 3 | 4 | 5 | 6
 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | 12 | 13 | 14 | 15 | 16 | 17 | 18 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15 |  | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | 19 | 20 | 21 | 22 | 23 | 24 | 25 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22 |  | 21 | 22 | 23 | 24 | 25 | 26 | 27
 | 26 | 27 | 28 | 29 | 30 | 31 |  |  | 23 | 24 | 25 | 26 | 27 | 28 | 29 |  | 28 | 29 | 30 | 31
 |  |  |  |  |  |  |  |  | 30
 |  | Newport BOLO in yellow, [NAME] in Purple.  [NAME] is subject to change.  Call CPFB with questions [PHONE]. Thank you.
 |  | Holidays, Food Bank is Closed |  |  |  |  |  |  |  | Pick Up for BOLO - Newport |  |  |  |  |  |  |  | Pick Up for BOLO - Juniata Cty
Spreadsheet: 278055d1384530543-icon-set-help-for-forum-icon-sets
Sheet: Sheet1

Month | Pageviews | % Change
2013-01-01 00:00:00 | 153713 | 0
2013-02-01 00:00:00 | 130876
2013-03-01 00:00:00 | 139045
2013-04-01 00:00:00 | 135798
2013-05-01 00:00:00 | 120129
2013-06-01 00:00:00 | 130619
2013-07-01 00:00:00 | 151874
2013-08-01 00:00:00 | 135428
2013-09-01 00:00:00 | 121403
2013-10-01 00:00:00 | 121250
2013-11-01 00:00:00
2013-12-01 00:00:00
Spreadsheet: michelle_lokay__26699__imball0112
Sheet: NNG

NNG
 | Measured | Scheduled | Imbalance
1635 | -422325
3531 | -124072 | -48052
60667 | -1 | -387639
60749 | 1890 | -110804
61206
61334
62960
INDEX
2001-11-30 00:00:00 |  |  | 724900
2001-12-04 00:00:00
CBS Volume
 |  |  | 125846
Spreadsheet: 826561d1682083386-filter-formula-helping-filtering-between-a-number-range-book1
Sheet: Wed2

 |  |  |  |  | 898-1 | OPERATOR |  |  |  |  |  |  |  |  |  |  |  |  | YES
 |  |  |  |  | 890-2 | OPERATOR |  |  |  |  |  |  |  |  |  |  |  |  | YES
 |  |  |  |  | 890-3 | OPERATOR |  |  |  |  |  |  |  |  |  |  |  |  | YES
 |  |  |  |  | 109-4 | OPERATOR |  |  |  |  |  |  |  |  |  |  |  |  | YES
 |  |  |  |  | 890-5 | OPERATOR |  |  |  |  |  |  |  |  |  |  |  |  | YES
 |  |  |  |  | 890-6 | OPERATOR |  |  |  |  |  |  |  |  |  |  |  |  | YES
 |  |  |  |  | 109-7 | OPERATOR |  |  |  |  |  |  |  |  |  |  |  |  | YES
 |  |  |  |  | 890-8 | OPERATOR |  |  |  |  |  |  |  |  |  |  |  |  | YES
 |  |  |  |  | 109-9 | OPERATOR |  |  |  |  |  |  |  |  |  |  |  |  | YES
 |  |  |  | 0 | 0 | 0 | 0 | 890-2 | OPERATOR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | YES
 |  |  | 0 | 0 | 0 | 0 | 0 | 890-3 | OPERATOR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | YES
 |  |  | 0 | 0 | 0 | 0 | 0 | 890-5 | OPERATOR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | YES
 |  |  | 0 | 0 | 0 | 0 | 0 | 890-6 | OPERATOR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | YES
 |  |  | 0 | 0 | 0 | 0 | 0 | 890-8 | OPERATOR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | YES
Spreadsheet: 293286d1390936416-cannot-format-cells-into-currency-1-1-2014-copy
Sheet: Projections

PROJECTIONS
 | CAG |  | CC |  | WSP |  | POOLED FUNDS |  | P-Fund | LEGACY | SG/MG* | TOTALS
Approved Grants
Paid
Scheduled | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0
Contingent | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0
Under Consideration
Board Grants | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0
Staff [NAME] | 0 |  | 0 |  |  |  | 0 |  |  | 0 | 0
Pipeline | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0
Subtotal
Budget + Refunds
Balance Available
% Available
Status Codes
Paid-- | payments on approved grants that have been paid in 2014
Scheduled-- | payments on approved grants to be paid by 12/31;  no contingencies or conditions to be met prior to release
Contingent-- | payments on approved grants to be paid by 12/31; a contingency or condition must be met prior to release of payments
Board Grants-- | payments on grants scheduled for the next upcoming Board meeting, VPP approval is final and complete
Staff [NAME] | payments on grants that have received final VPP approval, awaiting President approval
Pipeline-- | potential payments on requests being considered for funding in 2014
Spreadsheet: 669431d1585356319-applying-conditional-format-to-dates-based-on-current-year-and-6-month-intervals-brief_sample
Sheet: Sheet1

Building 1 |  |  |  | Building 2 |  |  |  | Building 3
Location: | Serial Number: | [NAME]: |  | Location: | Serial Number: | [NAME]: |  | Location: | Serial Number: | [NAME]:
Ground | 159265 | 2022-03-01 00:00:00 |  | Ground | 153489 | 2022-06-01 00:00:00 |  | Ground | 152657 | 2022-02-01 00:00:00
Ground | 152628 | 2022-02-01 00:00:00 |  | Ground | 152826 | 2022-03-01 00:00:00 |  | Ground | 153102 | 2022-04-01 00:00:00
Middle | 153976 | 2023-02-01 00:00:00 |  | Middle | 151129 | 2021-04-01 00:00:00 |  | Ground | 153101 | 2022-04-01 00:00:00
Middle | 155846 | 2024-03-01 00:00:00 |  | Middle | 153137 | 2022-08-01 00:00:00 |  | Middle | 153035 | 2022-04-01 00:00:00
Top | 153608 | 2022-03-01 00:00:00 |  | Top | 153262 | 2022-05-01 00:00:00 |  | Middle | 153940 | 2022-02-01 00:00:00
Top | 154871 | 2022-02-01 00:00:00 |  | Top | 153046 | 2022-04-01 00:00:00 |  | Middle | 153780 | 2022-09-01 00:00:00
 |  |  |  |  |  |  |  | Top | 153675 | 2022-07-01 00:00:00
Building 4 |  |  |  | Building 5 |  |  |  | Top | 155860 | 2022-07-01 00:00:00
Location: | Serial Number: | [NAME]: |  | Location: | Serial Number: | [NAME]: |  | Building 6
Ground | 153949 | 2022-03-01 00:00:00 |  | Ground | 153544 | 2022-06-01 00:00:00
Ground | 154873 | 2021-01-01 00:00:00 |  | Ground | 152930 | 2022-03-01 00:00:00 |  | Location: | Serial Number: | [NAME]:
Middle | 153455 | 2022-06-01 00:00:00 |  | Middle | 151621 | 2021-04-01 00:00:00 |  | Top | 153411 | 2022-06-01 00:00:00
Middle | 154004 | 2023-02-01 00:00:00 |  | Middle | 151946 | 2021-05-01 00:00:00 |  | Top | 150814 | 2021-02-01 00:00:00
Top | 150600 | 2021-01-01 00:00:00 |  | Top | 152708 | 2022-03-01 00:00:00 |  | Top | 154544 | 2022-04-01 00:00:00
Top | 153249 | 2022-06-01 00:00:00 |  | Top | 152680 | 2022-03-01 00:00:00 |  | Top | 153658 | 2022-07-01 00:00:00
 |  |  |  |  |  |  |  | Top | 154814 | 2023-09-01 00:00:00
Building 7 |  |  |  | Building 8 |  |  |  | Top | 153990 | 2023-02-01 00:00:00
Location: | Serial Number: | [NAME]: |  | Location: | Serial Number: | [NAME]: |  | Building 9
Ground | 152886 | 2022-03-01 00:00:00 |  | Ground | 152987 | 2022-03-01 00:00:00
Ground | 153445 | 2022-06-01 00:00:00 |  | Ground | 152855 | 2022-03-01 00:00:00 |  | Location: | Serial Number: | [NAME]:
 |  |  |  | Ground | 150902 | 2022-02-01 00:00:00 |  | Ground | 154743 | 2023-03-01 00:00:00
 |  |  |  | Ground | 154766 | 2023-05-01 00:00:00 |  | Ground | 154526 | 2022-01-01 00:00:00
 |  |  |  |  |  |  |  | Top | 152872 | 2022-03-01 00:00:00
 |  |  |  |  |  |  |  | Top | 154647 | 2022-07-01 00:00:00
Spreadsheet: 121515d1316105167-finding-the-lowest-value-based-on-multiple-text-criteria-book2
Sheet: Sheet1

2000 |  |  |  |  | Min Data
Name1 | P01
 | P02
 | P03
[NAME] | P01
 | P02
 | P03
 | P04
2001 |  |  |  |  | Min Data
Name1 | P01
 | P02
 | P03
 | P04
 | P05
[NAME] | P01
 | P02
2002 |  |  |  |  | Min Data
Name1 | P01
 | P02
Spreadsheet: daren_farmer__5016__HPLN0310
Sheet: Sheet1

HPLN0310.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 - March 10-12, 2001
 |  |  |  |  |  | **Sat. & Sun. | **Monday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 3/10-11/01 | 2001-03-12 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs. | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED | 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: 766876d1644135103-stock-closing-prices-w-o-data-types-data-from-web-imported-aligw
Sheet: TSP Funds (2)

“Classic” TSP Lifecycle Funds 8/1/2005 - 2/4/2022 | TSP L Income Fund | TSP L 2030 Fund | TSP L 2040 Fund | TSP L 2050 Fund
Last Price (2/4/2022) | 23.1671 | 42.0551 | 47.7062 | 28.5776
Change (1-Day) | 0.07% | 0.23% | 0.27% | 0.32%
YTD Return | -1.36% | -3.48% | -4.20% | -4.82%
1-Year Return | 3.26% | 6.45% | 7.27% | 7.92%
3-Year Return | 4.90% | 10.47% | 12.14% | 13.53%
5-Year Return | 4.54% | 8.97% | 10.22% | 11.28%
10-Year Return | 4.26% | 8.64% | 9.73% | 10.67%
Annual Return Since 8/1/2005 | 4.3% | 7.1% | 7.7% | 10.0%
Annualized Standard Deviation | 3.9% | 13.2% | 15.2% | 14.1%
Maximum Drawdown | -11.0% | -43.3% | -48.4% | -29.2%
[NAME] | 0.43 | 0.39 | 0.40 | 0.61
Value of $1,000 invested on 8/1/2005 | $1,995 | $3,083 | $3,400 | $2,858
Spreadsheet: 780381d1652430975-compare-4-cells-and-depending-on-what-it-say-give-the-corresponding-output-in-a-new-cell-matches_updated-lp
Sheet: Tabelle1

code 1 | code 2 | code 3 | code 4 |  | what it should say |  | desired result
match | no match | match | match |  | old match |  |  |  | I have 4 different cells with either match or no match in it.
no match | no match | no match | no match |  | no match |  |  |  | If either or both code 1 & code 2 are "match" it should say "new match"
match | no match | no match | no match |  | new match |  | new match |  | If either or both code 3 & code 4 are "match" it should say "old match" --> doesnt matter what code 1 & code 2 say
no match | no match | match | match |  | old match |  |  |  | if no match at all in neither 1-4 --> no match
match | no match | match | match |  | old match
no match | match | match | match |  | new match |  | correct that was my mistake
no match | no match | no match | no match
no match | match | match | no match |  |  | old match |  | if either code 3 or code 4 are a match, it is an old match, no matter what in code 1 or code 2 is
match | no match | no match | no match |  |  | new match
no match | match | no match | no match |  |  | new match
no match | match | no match | match |  |  | old match