tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 34589d1231899050-calculate-overtime-week2discussion_kendrick
Sheet: Sheet1

Employee | Rate | Hours | Total Rate | Overtime 40-50 hrs | Overtime Rate | Overtime Over 50 Hours | Extra Overtime Rate | Total Hours | Total Pay
[NAME] | 8.75 | 40 |  | 10 |  | 50 |  | 100
Spreadsheet: 600253d1543570021-sumifs-with-max-sample
Sheet: Source

ComplexName | RoomType | BookingType | No Of Beds | Rent
Complex 1 | [NAME] | 14/09/2019 - 04/09/2020 51w | 9 | 77571
Complex 1 | Deluxe Studio | 14/09/2019 - 04/09/2020 51w | 2 | 19074
Complex 1 | Premier [NAME] | 14/09/2019 - 04/09/2020 51w | 3 | 28305
Complex 1 | Ultra Studio | 14/09/2019 - 04/09/2020 51w | 1 | 10047
Complex 2 | [NAME] | 31/08/2019 - 21/08/2020 51w | 80 | 518160
Complex 2 | [NAME] Dual Occ | 31/08/2019 - 21/08/2020 51w | 4 | 27948
Complex 2 | Ground [NAME] | 31/08/2019 - 21/08/2020 51w | 16 | 106080
Complex 2 | Ground [NAME] Dual Occ | 31/08/2019 - 21/08/2020 51w | 2 | 7650
Complex 2 | Ultra Studio | 31/08/2019 - 21/08/2020 51w | 6 | 48042
Complex 2 | [NAME] | 07/09/2019 - 03/07/2020 43w | 80 | 500200
Complex 2 | [NAME] Dual Occ | 07/09/2019 - 03/07/2020 43w | 4 | 25652
Complex 2 | Ground [NAME] | 07/09/2019 - 03/07/2020 43w | 16 | 103068
Complex 2 | Ground [NAME] Dual Occ | 07/09/2019 - 03/07/2020 43w | 2 | 6546
Complex 2 | Ultra Studio | 07/09/2019 - 03/07/2020 43w | 6 | 45024
Spreadsheet: 672499d1586892139-removing-blanks-using-new-filter-function-help-needed
Sheet: Sheet1

 | Input |  |  |  |  |  | Current Output |  |  |  |  | Desired Output
 | Names | Alpha | Bravo | [NAME] | Delta |  | Alpha | Bravo | [NAME] | Delta |  | Alpha | Bravo | [NAME] | Delta
 | [NAME] | 1 |  | 1 |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME]
 | [NAME] |  | 1 |  |  |  |  | [NAME] |  |  |  |  | Emanuel | [NAME] | [NAME]
 | Emanuel |  | 1 |  |  |  |  | Emanuel |  |  |  |  | [NAME]
 | [NAME] |  | 1 |  |  |  |  | [NAME]
 | [NAME] |  |  | 1 | 1 |  |  |  | [NAME] | [NAME]
 | [NAME] |  |  |  | 1 |  |  |  |  | [NAME]
Spreadsheet: 685154d1593764329-create-summary-page-referencing-multiple-sheets-pq-loading-schedule-example-aligw
Sheet: B

Device Name/Number | Device Type | Location | MAC Address | Serial Number | IP Address | [NAME]
B1 | CCTV | Reception | f4:f6:g4:6j:8c:9n | 12345 | 10.10.10.6 | Switch-a
B2 | CCTV | Store Room | s4:6v:8s:c6:8g:fd | 67890 | 10.10.10.7 | Switch-b
B3 | CCTV | Warehouse | ab:cd:ef:gh:ij:kl | 13579 | 10.10.10.8 | Switch-a
Spreadsheet: 850768d1701141975-drop-down-list-to-select-rows-must-also-include-all-edpivco-sample-216-aligw
Sheet: Sheet2

All | Note: This solution accommodates up to 49 teacher names.
 | To extend it, fill the formula down more rows.
Spreadsheet: 154539d1336480330-date-range-lookup-date-range
Sheet: Sheet1

location | start | end | Type |  |  | location | Date | Type | Type | Type | Type | Type
1 | 2011-02-13 00:00:00 | 2011-04-09 00:00:00 | grass |  |  | 1 | 2011-04-06 00:00:00 | weeds | grass |  |  |  | should be"weeds and Grass"
1 | 2011-04-05 00:00:00 | 2011-04-08 00:00:00 | weeds |  |  | 2 | 2011-07-11 00:00:00 | grass | pool |  |  |  | should be"grass and pool"
1 | 2011-04-07 00:00:00 | 2011-04-08 00:00:00 | pool |  |  | 2 | 2011-08-15 00:00:00 |  |  |  |  |  | should be blank
1 | 2011-07-10 00:00:00 | 2011-07-29 00:00:00 | trees |  |  | 3 | 2011-06-03 00:00:00 | grass | weeds | pool | trees | roof | should be"grass, weeds,pool,trees,roof"
1 | 2011-07-15 00:00:00 | 2011-08-01 00:00:00 | roof
2 | 2011-02-13 00:00:00 | 2011-02-25 00:00:00 | weeds
2 | 2011-04-05 00:00:00 | 2011-04-08 00:00:00 | weeds
2 | 2011-04-05 00:00:00 | 2011-04-08 00:00:00 | roof
2 | 2011-07-10 00:00:00 | 2011-07-29 00:00:00 | grass
2 | 2011-07-05 00:00:00 | 2011-08-01 00:00:00 | pool
3 | 2011-06-01 00:00:00 | 2011-06-05 00:00:00 | grass
3 | 2011-06-01 00:00:00 | 2011-06-02 00:00:00 | weeds
3 | 2011-06-01 00:00:00 | 2011-06-03 00:00:00 | pool
3 | 2011-06-01 00:00:00 | 2011-06-04 00:00:00 | trees
3 | 2011-06-01 00:00:00 | 2011-06-05 00:00:00 | roof
Spreadsheet: 54111d1254143790-find-duplicates-by-name-and-date-help
Sheet: Sheet1

FirstInitial | SurnameInitial | DateofBirth | Gender | Unique ID | Spend | Date
L | S | 1974-01-01 00:00:00 | F | L-S-01/01/1974-F | 1 | 2009-06-30 00:00:00
L | S | 1974-01-01 00:00:00 | F | L-S-01/01/1974-F | 2 | 2009-07-27 00:00:00
D | P | 1974-08-01 00:00:00 | M | D-P-01/08/1974-M | 3 | 2009-07-23 00:00:00
P | D | 1972-08-21 00:00:00 | M | P-D-21/08/1972-M | 4 | 2009-07-13 00:00:00
J | H | 1967-08-01 00:00:00 | M | J-H-01/08/1967-M | 5 | 2009-07-15 00:00:00
A | c | 1981-01-01 00:00:00 | F | A-c-01/01/1981-F | 6 | 2009-07-07 00:00:00
M | W | 1965-11-20 00:00:00 | M | M-W-20/11/1965-M | 7 | 2009-05-26 00:00:00
R | B | 1982-01-19 00:00:00 | M | R-B-19/01/1982-M | 8 | 2009-06-01 00:00:00
E | J | 1986-04-04 00:00:00 | F | E-J-04/04/1986-F | 9 | 2009-04-02 00:00:00
E | J | 1986-04-04 00:00:00 | F | E-J-04/04/1986-F | 10 | 2009-04-02 00:00:00
T | J | 1971-05-02 00:00:00 | F | T-J-02/05/1971-F | 11 | 2009-07-23 00:00:00
T | L | 1983-11-11 00:00:00 | F | T-L-11/11/1983-F | 12 | 2009-06-26 00:00:00
H | D | 1982-09-05 00:00:00 | F | H-D-05/09/1982-F | 13 | 2009-06-24 00:00:00
C | G | 1981-08-11 00:00:00 | M | C-G-11/08/1981-M | 14 | 2009-07-11 00:00:00
L | H | 1973-03-01 00:00:00 | M | L-H-01/03/1973-M | 15 | 2009-07-10 00:00:00
D | J | 1988-03-09 00:00:00 | M | D-J-09/03/1988-M | 16 | 2009-06-24 00:00:00
A | B | 1982-07-08 00:00:00 | M | A-B-08/07/1982-M | 17 | 2009-07-16 00:00:00
B | H | 1988-02-20 00:00:00 | M | B-H-20/02/1988-M | 18 | 2009-07-12 00:00:00
J | P | 1974-01-01 00:00:00 | M | J-P-01/01/1974-M | 19 | 2009-07-24 00:00:00
S | W | 1979-02-18 00:00:00 | F | S-W-18/02/1979-F | 20 | 2009-07-02 00:00:00
A | F | 1973-11-22 00:00:00 | M | A-F-22/11/1973-M | 21 | 2009-07-02 00:00:00
P | B | 1971-07-11 00:00:00 | M | P-B-11/07/1971-M | 22 | 2009-06-29 00:00:00
I | T | 1976-09-16 00:00:00 | M | I-T-16/09/1976-M | 23 | 2009-07-23 00:00:00
M | L | 1987-05-11 00:00:00 | M | M-L-11/05/1987-M | 24 | 2009-06-30 00:00:00
R | W | 1977-04-30 00:00:00 | M | R-W-30/04/1977-M | 25 | 2009-07-25 00:00:00
S | S | 1985-06-06 00:00:00 | F | S-S-06/06/1985-F | 26 | 2009-07-30 00:00:00
Spreadsheet: 698924d1602252738-trying-to-generate-a-report-based-on-time-sheet-groups-by-earn-codes-time-sample
Sheet: Sheet2

UserId | Period | Name | EarnCode | Total Hours |  |  |  | Code
16 | 1/5/2018-1/18/2018 | [NAME] | Lunch | 5.15 |  |  |  | Lunch
6 | 1/5/2018-1/18/2018 | [NAME] | Lunch | 10.33
16 | 1/19/2018-2/1/2018 | [NAME] | Lunch | 8.85
6 | 1/19/2018-2/1/2018 | [NAME] | Lunch | 8.68
Spreadsheet: 734971d1622627752-match-two-set-of-numbers-to-return-matched-numbers-that-are-in-sequence-matching
Sheet:  Matching nos

 |  | Matching Numbers |  |  | Data set 1 |  |  |  |  |  |  |  |  | Matching Numbers |  |  | Data set 2
 |  | 0 |  |  | 11 | 37 | 89 |  |  |  |  |  |  | 0 |  |  | 1 | 165 | 56
 |  | 22 |  |  | 33 | 42 | 49 |  |  |  |  |  |  | 22 |  |  | 0 | 101 | 104
 |  | 33 |  |  | 45 | 57 | 131 |  |  |  |  |  |  | 33 |  |  | 130 | 13 | 83
 |  | 57 |  |  | 67 | 91 | 71 |  |  |  |  |  |  | 57 |  |  | 14 | 41 | 94
 |  | 71 |  |  | 123 | 83 | 154 |  |  |  |  |  |  | 71 |  |  | 93 | 71 | 87
 |  | 83 |  |  | 124 | 157 | 167 |  |  |  |  |  |  | 83 |  |  | 141 | 22 | 67
 |  | 101 |  |  | 165 | 88 | 56 |  |  |  |  |  |  | 101 |  |  | 134 | 88 | 121
 |  | 133 |  |  | 88 | 130 | 99 |  |  |  |  |  |  | 133 |  |  | 88 | 54 | 99
 |  | 210 |  |  | 78 | 73 | 141 |  |  |  |  |  |  | 210 |  |  | 78 | 73 | 3
 |  | [NAME] to return result |  |  |  |  |  |  |  |  |  |  |  | [NAME] to return result
 |  | No. of Matching Numbers in sequential order |  |  |  |  | 4 |  | There are four Matching numbers in sequential order (yellow highlighted) appearing in the data set, so the formular returns "4" |  |  |  |  | No. of Matching Numbers in sequential order |  |  |  |  | 3 |  | There are two sets of Matching numbers in sequential order:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1st set: Green highlight
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2nd set: Yellow highlight
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The formular returns "3" as the number of Matching numbers in the 2nd set (which has  the higher number of Matching numbers in sequential order)
 |  | Next Lower Matching number |  |  |  |  |  |  | Can we also have a formula to return the Matching number before the first Matched Number in the sequence? |  |  |  |  | Next Lower Matching number
 |  | Next Higher Matching number |  |  |  |  |  |  | Can we also have a formula to return the Matching number after the last Matched Number in the sequence? |  |  |  |  | Next Higher Matching number
Spreadsheet: f1a3226b-8bd9-49ba-8e8a-c350910ee1bc
Sheet: Totals

 |  |  | B&W MFP | Color MFP | B/W MFD | Color MFD |  |  | B&W  MFP | Color  MFP
 |  | MFP:
 |  |  | B&W  Printer | Color  Printer | B/W Printer | Color Printer |  |  | B&W  Printer | Color  Printer
 |  | Printer:
 |  |  | Total B&W | Total  Color | Total B&W | Total  Color |  |  | Total B&W | Total  Color
 |  | Total:
 |  |  |  |  | Total This Invoice: |  |  |  | Total This Invoice:
 |  |  |  |  | HP Toner: |  |  |  | Total Invoice w/ HP Toner:
 |  |  |  |  | Invoice Total
 |  | MFP
 |  | Printer
 |  |  |  |  | MFP Total:
 |  |  |  |  | Printer Total:
 |  |  |  |  | Device Total:
Spreadsheet: 41155d1239664573-conditional-correlation-within-2-time-series-book2
Sheet: Sheet1

Date | Time | Data 1 | Data 2
2009-03-02 00:00:00 | 01:10:21 | 5 | 17 |  |  | Selected Date |  | 2009-03-05 00:00:00
2009-03-05 00:00:00 | 11:24:31 | 3 | 6 |  |  | Selected Min Time |  | 07:00:00
2009-03-01 00:00:00 | 11:43:18 | 8 | 6 |  |  | Selected [NAME] |  | 17:00:00
2009-03-01 00:00:00 | 16:16:39 | 18 | 18
2009-03-05 00:00:00 | 17:58:53 | 20 | 12 |  |  | Correlation |  | 0.461033116582131
2009-03-03 00:00:00 | 22:59:21 | 15 | 8
2009-03-02 00:00:00 | 02:23:22 | 6 | 17
2009-03-05 00:00:00 | 06:00:01 | 10 | 13
2009-03-01 00:00:00 | 16:34:47 | 4 | 11
2009-03-05 00:00:00 | 09:33:08 | 12 | 13
2009-03-05 00:00:00 | 17:45:08 | 1 | 10
2009-03-04 00:00:00 | 03:51:29 | 8 | 14
2009-03-05 00:00:00 | 09:52:26 | 8 | 12
2009-03-05 00:00:00 | 14:24:57 | 14 | 3
2009-03-04 00:00:00 | 16:41:21 | 4 | 12
2009-03-02 00:00:00 | 06:38:06 | 3 | 7
2009-03-03 00:00:00 | 02:29:54 | 10 | 1
2009-03-04 00:00:00 | 00:42:25 | 5 | 11
2009-03-01 00:00:00 | 20:54:17 | 2 | 9
2009-03-02 00:00:00 | 10:03:43 | 17 | 17
2009-03-01 00:00:00 | 16:21:31 | 3 | 10
2009-03-05 00:00:00 | 16:34:12 | 5 | 11
2009-03-05 00:00:00 | 16:49:59 | 19 | 19
2009-03-04 00:00:00 | 19:09:53 | 3 | 13
Spreadsheet: 272859d1382534679-how-to-look-up-a-value-in-a-list-and-return-multiple-corresponding-values-multiple_corresponding_values-1-
Sheet: Collation

 | 1 | 1 | 2 | 2 | 3 | 3
Client Name | order date | order cost | order date | order cost | order date | order cost
Spreadsheet: tracy_geaccone__40145__03_09_EXECSUMM
Sheet: ForecastQ13-09

Transwestern Pipeline Company
($[NAME])
First Quarter Forecast-Revised 3-09-2001
 |  | March 2001 Year To Date
 |  | Plan | Estimate | [NAME] |  | Comments
MARGIN |  | 38.14 |  |  |  | Sempra & Richardson Short Term Firm Contracts; Tenaska K
FUEL |  | 7.97
STRETCH |  | 2.55 | 0
VARIANCE FROM PLAN
TARGET ADJUSTMENT |  | -3.3 | 0
TOTAL
PREVIOUS FORECAST 3-02-2001 |  | 45.359 | 57.224 |  | A
DIFFERENCE
CONTRIBUTOR
Sempra, [NAME] |  |  |  | 1.229
Fuel |  |  |  | 0.005
Other |  |  |  | 0.014
Total
A. First Quarter Forecast to [NAME] was $10.1Million over plan.
Spreadsheet: 157812d1337879739-automatically-emailing-notifications-when-dates-in-columns-is-or-to-computer-date-_pda-sample-for-auto-email
Sheet: Sheet1

 | NAME | PROGRAM OR [NAME] | TYPE | DATE | NUMBER | STATUS (1 - 6) | HYPERLINK  .PDF | [NAME] | [NAME]other | EXPIRES | RENEWAL NOTIF. DATE | Days till  Renewal Notif.
S | AACME ANVILS |  | PIXA | 2010-10-15 00:00:00 |  | 6 |  |  |  | 2015-10-16 00:00:00 | 2012-05-09 00:00:00 | 1795 | IF L2 = or < today (on computer), then: email [EMAIL] with message that B2 needs an updated D2 because it expires on K2 AND attach hyperlinked document from H2, THEN: change L2 color to red | [EMAIL]
S | [NAME] |  | ZXC | 2010-10-15 00:00:00 |  | 6 |  |  |  | 2015-10-16 00:00:00 | 2012-05-04 00:00:00 |  |  | [EMAIL]
Spreadsheet: 781010d1652942508-formula-to-sort-lowest-value-of-doublets-returning-criteria-aligw
Sheet: Ark1

 |  | Customer | Returning | Price
 |  | 56615 |  | 68.5
 |  | 153454 |  | 456
 |  | 6351351 |  | 15
 |  | 6468 |  | 95 | This should return single in A5, because it's the lowest price of the 2 on that customer
 |  | 635418564 |  | 541
 |  | 153513 |  | 15
 |  | 6548645 |  | 2123
 |  | 51356 |  | 61
 |  | 115 |  | 15461
 |  | 54561516 |  | 5641
 |  | 541561 |  | 5000
 |  | 6468 |  | 750 | This should return single in A13, because it's 2 equal prices(750) and I only want 1 showing
 |  | 6468 |  | 750 | As long as just one is "Returning", this should work for you.
 |  | 879 |  | 81
 |  | 7545451 |  | 351
 |  | 4664 |  | 651
 |  | 8944 |  | 651
 |  | 84968964 |  | 1561
 |  | 541561 |  | 3000 | This should return single in A20, because it's the lowest price of the 2 on that customer
Spreadsheet: 91883d1291587999-data-validation-and-conditional-formatting-draft_template
Sheet: Line Up

Forwards |  | [NAME]
1 |  |  |  | [NAME]: | 59.4
2 |  |  |  | [NAME]:
3 |  |  |  | [NAME]:
4
5
6
7 |  |  |  | Forwards [NAME]:
8 |  |  |  | Defence Cap Hit:
9 |  |  |  | [NAME] Hit:
10 |  |  |  | Reserve Cap Hit:
11 |  |  |  | Active Cap Hit:
12 |  |  |  | Total Cap Hit:
Defenceman
1 | [NAME], [NAME]
2 | Del Zotto, [NAME]
3 | Pronger, [NAME]
4 | Myers, Tyler
5 | [NAME], [NAME]
6 | Whitney, Ryan
Goalies
1 | [NAME], [NAME]
2 | [NAME], [NAME]
Reserve
1
2
3
4
5
Spreadsheet: 342e3136-a1b5-4649-afdc-1eb3d08ad451
Sheet: Sheet1

Growth rates of Af293, A1163, N. fischeri and A. clavatus isolates at various temperatures | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
Temperature | N.fischeri | STDV | SEM | A.clavatus | STDV | SEM | A1163 | STDV | SEM | AF293 | STDV | SEM
25C | 0.3756758248166761 | 0.008427503177481796 | 0.004213751588740898 | 0.004213751588740898 |  |  | 0.2935028495489104 | 0.01344314158471129 | 0.006721570792355644 | 0.2885363552338998 | 0.00140290134502746 | 0.0007014506725137301
30C | 0.4560910369459166 | 0.01202264640710498 | 0.006011323203552492 | 0.1552782730439712 | 0.005071894037875925 | 0.001267973509468981 | 0.4596316734852755 | 0.002910777435774742 | 0.001680538136095636 | 0.449103714486131 | 0.009467135497279457 | 0.004733567748639728
37C | 0.4831999212386429 | 0.008793946954588806 | 0.004396973477294403 | 0.06018681813493742 | 0.003930399070086451 | 0.0009825997675216127 | 0.5443474821189274 | 0.009048443792775716 | 0.003694011709759039 | 0.545191953783866 | 0.007282160728093148 | 0.003641080364046574
42C | 0.2847175506457287 | 0.005083301788385839 | 0.002541650894192919 | 0 | 0 | 0 | 0.4678596407273797 | 0.01779848647248392 | 0.006292715239775206 | 0.4944310198594953 | 0.01364011777174024 | 0.006820058885870122
50C | 0.004213751588740898 |  |  | 0.004213751588740898 |  |  | 0.1598698197552262 | 0.008648586434301282 | 0.004324293217150641 | 0.1624452952142183 | 0.01004411335124434 | 0.005022056675622169
Abbreviations:
STDV, standard deviation
SEM = STDV()/SQRT(COUNT())
Spreadsheet: daf42248-7182-4205-b91c-90aeca99dd22
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
FLEP | Test | FLEP | [NAME] | [NAME] | Enzyme-Linked Immunosorbent Assay (ELISA) | Plain, Red-Top Tube: Red |  |  | 1 | mL | Draw blood in a plain, red-top tube(s).  (Serum gel tube is acceptable.) Separate and freeze within one hour. Send 1 mL of serum frozen in a plastic vial.   Note:  EDTA (lavender-top) plasma is an acceptable alternate. | 0.5 mL NOTE:  Minimum volume doe | Hemolysis	NA Thawing	Warm OK <2 days; Cold OK <2 days Lipemia	NA Icterus	NA Other	NA | Units: ng/mL          Age                                  Range   Adults (BMI=22)   Males                                 0.7 -  5.3   Females                             3.3 - 18.3   Contact laboratory for other BMI reference ranges.   Test Performed By:   Esoterix Endocrinology                                4301 Lost Hills Road                                Calabasas Hills, CA 91301 | Tuesday, Thursday | 2-6 days | 4 - 15 days | 1 | 83520 |  |  |  |  | Esoterix Endocrinology
FLEP | [NAME] | SERUM | Serum |  |  |  | Frozen | 200 days
FLEP | Result | Z0262 | [NAME] | [NAME] | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 21365-2
Spreadsheet: 812811d1673387067-if-formula-question1-etaf
Sheet: Sheet1

Diameter = | 48 |  | Center line radius = |  | 1.5 | Steel Per Lb. 20 ga. |  | 0.98 |  | Labor = |  |  | Seam Weld Cost = |  | 0.73 |  | Labor Time = | 60
 |  |  |  |  |  |  |  |  |  | [NAME] |  |  | Weight | Weight | Weight | Weight | Weight | Weight | Weight | Weight | Weight
3 piece pattern |  |  |  |  |  |  |  |  |  | Length | X | [NAME] | 26 Ga | 24 Ga | 22 Ga | 20 Ga | 18 Ga | 16 Ga | 14 Ga | 12 Ga | 10 Ga
 |  |  |  |  |  | I would like to change L1 to calculate if B1 is 18 or less to be .208, but if it's over 18 it is .208*2. I'm sure this is a simple question for most of you, but I'm still pretty new to Excel. Thank you in advance.
Spreadsheet: mary_fischer__25624__31X
Sheet: E12.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031X
COMPANY NAME     Harper Investment Company
ANALYSIS OF LONG-TERM DEBT
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY: |  |  |  |  |  |  |  |  |  |  |  | ** Credit Positive Liability  (Debit Negative Liability) **
EXTENSION: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-12
 |  |  |  |  |  |  |  | ORIGINAL |  | BEGINNING BALANCE |  |  |  |  |  |  |  |  |  | OTHER (NON-CASH) |  |  |  | ENDING BALANCE
PAYEE AND [NAME] |  | HYPERION |  | DUE |  | INTEREST |  | AMOUNT |  | CURRENT |  | LONG-TERM |  |  |  | ADDITIONS |  | RETIREMENTS |  | AMOUNT |  | [NAME] |  | CURRENT |  | LONG-TERM
 |  | ACCOUNT |  | DATE |  | RATE |  | AUTHORIZED |  | PORTION |  | PORTION |  | TOTAL |  | DR (CR) |  | DR (CR) |  | DR (CR) |  |  |  | PORTION |  | PORTION |  | TOTAL
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Current:
Current Maturities of Long-Term Debt * |  | 0450 |  |  |  | 0
Notes Payable - Other |  | TOT_NP_OTHER
Total Short-Term
Long-Term:
Long-Term Debt (Hyperion Accts. 0705, 0770)
Notes (list by name of payee or issue):
Total (Hyperion Accts 0705 & 0770)
Current Maturities of L/T Debt (Contra) * |  | 0775
Unamortized Premium on L/T Debt |  | 0765
Total Long-Term Debt
Total Debt  DR/(CR)
!!DO NOT INCLUDE INTERCOMPANY DEBT!!
*  HYPERION ACCOUNTS 0450 & 0775 MUST BE THE SAME AMOUNT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-12
 |  |  |  | Income Accts:  (DR)/CR Reverse signs from Hyperion
 |  |  |  |  |  |  | Income Accts: (DR)/CR  Reverse signs from Hyperion
Spreadsheet: 860600d1708628788-excel-formula-to-extra-partial-data-based-on-a-delimiter-folder-name
Sheet: Sheet1

Date | Invoice No. | Department | Auma Ref No | Sales in Charge | Client Name | [NAME]
FZE 7973 | 2024-01-12 00:00:00 | Sales | FPO-2303/2024 | Shamanth | [NAME] LLC
FZE 7975 | 2024-01-16 00:00:00 | Sales+Spares | FPO-296/2023 | [NAME] | Multiline Technical Co. WLL
FZE 7977 | 2024-01-18 00:00:00 | Spares | FPO-535/2023 | [NAME] | Jaz Trade International Fzco
FZE 7979 | 2024-01-04 00:00:00 | Sales | FPO-2242/2023 | Shamanth | Solutions FZC
FZE 7981 | 2024-01-09 00:00:00 | Sales | FPO-517/2024 | [NAME] | HYDROJET FACILITIES MANAGEMENT LLC
FZE 7984 | 2024-01-10 00:00:00 | Spares | FPO-318/2023 | [NAME] | EXCEL GRAND GENERAL TRADING WHOLESALERS
FZE 7986 | 2024-01-11 00:00:00 | Sales | FPO-327/2023 | [NAME] | Sanstar General Trading LLC
FZE 7998 | 2024-01-23 00:00:00 | Sales+Spares | FPO-220/2023 | [NAME] | Sanstar General Trading LLC
FZE 7999 | 2024-01-22 00:00:00 | Sales | FPO-3221/2023 | Kirupa | CAMTECH MANUFACTURING FZCO
FZE 8001 | 2024-01-22 00:00:00 | Spares | FPO-536/2024 | [NAME] | DUBAL
FZE 8002 | 2024-01-26 00:00:00 | Spares | FPO-394/2023 | [NAME] | S2 Operation and Maintenance Company WLL
FZE 8003 | 2024-01-26 00:00:00 | Spares | FPO-399/2023 | [NAME] | Fujairah Asia Power Company PJSC
FZE 8004 | 2024-01-26 00:00:00 | Spares | FPO-404/2023 | [NAME] | Pineapple Building Materials Trading LLC
FZE 8011 | 2024-01-26 00:00:00 | Sales | FPO-2256/2023 | Shamanth | Mechatronics Industrial Equipment L.L.C
FZE 8015 | 2024-01-26 00:00:00 | Sales | FPO-6096/2023 | N.Af-Shamanth | [NAME]
FZE 8016 | 2024-01-30 00:00:00 | Spares | FPO-552/2024 | [NAME] | Al NABOODAH MEP L.L.C.
FZE 8018 | 2024-01-30 00:00:00 | Sales | FPO-281/2024 | [NAME] | Samsung C&T Corporation
FZE 8019 | 2024-01-31 00:00:00 | Spares | FPO-406/2023 | [NAME] | Mekelins International Trading Co LLC
Spreadsheet: mark_taylor__24730__legalreview2
Sheet: nominations

Nomination
Country | Commodity | Nomination Field | Abbreviation | ID | Long Description Sentences
Germany | Power | Day Ahead | DA | 1 | Physical delivery must be nominated by 11:00 on the day prior to delivery.
Germany | Power | Week Ahead | WA | 2 | Physical delivery must be nominated by 11:00 on the Thursday of the week prior to delivery.
Germany | Power | Week End | WE | 3 | Physical delivery must be nominated by 11:00 on Friday for deliveries on Saturday, Sunday and Monday.
Germany | Power | Month Ahead | MA | 4 | Physical delivery must be nominated by 11:00 on the Thursday of the week prior to the first week of delivery.
Netherlands | Power | Day Ahead | DA | 5 | Physical delivery must be nominated by 11:00 on the day prior to delivery.
Netherlands | Power | Week Ahead | WA | 6 | Physical delivery must be nominated by 11:00 on the Thursday of the week prior to delivery.
Netherlands | Power | Week End | WE | 7 | Physical delivery must be nominated by 11:00 on Friday for deliveries on Saturday, Sunday and Monday.
Netherlands | Power | Month Ahead | MA | 8 | Physical delivery must be nominated by 11:00 on the Thursday of the week prior to the first week of delivery.
Switzerland | Power | Day Ahead | DA | 9 | Physical delivery must be nominated by 11:00 on the day prior to delivery.
Switzerland | Power | Week Ahead | WA | 10 | Physical delivery must be nominated by 11:00 on the Thursday of the week prior to delivery.
Switzerland | Power | Week End | WE | 11 | Physical delivery must be nominated by 11:00 on Friday for deliveries on Saturday, Sunday and Monday.
Switzerland | Power | Month Ahead | MA | 12 | Physical delivery must be nominated by 11:00 on the Thursday of the week prior to the first week of delivery.