tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 851724d1701880111-sorting-like-items-in-2-columns-bowl-history-1
Sheet: Sheet1

Bowl name |  | Las Vegas Bowl | Duke's Mayo Bowl | Armed Forces Bowl | Texas Bowl | Birmingham Bowl | New Mexico Bowl
Air Force |  | Air Force |  | Air Force
Akron
Alabama
Appalachian State
Arizona |  | Arizona |  |  |  |  | Arizona
Arizona State |  | Arizona State
Arkansas |  | Arkansas | Arkansas |  | Arkansas
Arkansas A&M
Arkansas State
Army |  |  |  | Army
Auburn |  |  |  |  |  | Auburn
[NAME] |  | [NAME]
Baylor |  |  |  | Baylor | Baylor
Boise State |  | Boise State |  | Boise State
Bolling AFB
[NAME]
Boston College |  |  | Boston College |  |  | Boston College
Bowling Green |  | Bowling Green
BYU |  | BYU |  | BYU |  |  | BYU
[NAME]
Bucknell
Buffalo
Cal State [NAME]
California |  | California |  | California
Camp Breckinridge
Carnegie Tech
Catawba
Catholic
Centenary
Central Michigan |  | Central Michigan |  |  |  |  | Central Michigan
Centre
Charlotte
Cincinnati |  |  | Cincinnati | Cincinnati |  | Cincinnati
Clemson |  |  | Clemson
Coast Guard
Coastal Carolina |  |  |  |  |  | Coastal Carolina
Colorado
Colorado A&M
Colorado State |  | Colorado State |  |  |  |  | Colorado State
 |  |  | Fresno State |  | Air Force
 |  | Appalachian State
 |  |  |  | Hardin-Simmons
 |  |  |  |  |  | Alabama
 |  |  |  |  |  |  | New Mexico
Spreadsheet: 30850d1226549950-automatically-add-information-to-first-blank-row-dispatch-master-copy
Sheet: Lists

Drivers | Payment | How They Heard | [NAME] | Status
Nunes | Cash | Repeat | HVAC | Complete
[NAME] | Check | Phonebook | Plumbing | Re Schedule
[NAME] | Credit Card | Radio Ad | Appliance | Part Ordered
[NAME] | [NAME] | TV Ad | Shop
[NAME] | No Charge | Newspaper Ad | Break
[NAME] |  | Referral
[NAME] |  | Trucks
[NAME]
Cookie
[NAME]
Spreadsheet: 04842fb2-3d80-485f-a246-fc907c0a9947
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Class1
GOMFID | Pvalue | OddsRatio | ExpCount | Count | Size | Term
GO:0001077 | 0.0006459342740962951 | 4.60516870064609 | 3.25906040268456 | 10 | 24 | RNA polymerase II core promoter proximal region sequence-specific DNA binding transcription factor activity involved in positive regulation of transcription
GO:0001071 | 0.0007775295833128181 | 1.91772340137894 | 22.8134228187919 | 38 | 168 | nucleic acid binding transcription factor activity
GO:0003700 | 0.0007775295833128181 | 1.91772340137894 | 22.8134228187919 | 38 | 168 | sequence-specific DNA binding transcription factor activity
GO:0003705 | 0.0009476014632967 | 4.29704075935232 | 3.39485458612975 | 10 | 25 | sequence-specific distal enhancer binding RNA polymerase II transcription factor activity
Class2
GOMFID | Pvalue | OddsRatio | ExpCount | Count | Size | Term
GO:0004364 | 8.669449771123091e-07 | 27.8637096774194 | 1.54787472035794 | 9 | 11 | glutathione transferase activity
GO:0061135 | 9.48700705644351e-05 | 4.05537459283388 | 5.34720357941834 | 15 | 38 | endopeptidase regulator activity
GO:0016765 | 0.0002673384470626 | 4.86558021266759 | 3.51789709172259 | 11 | 25 | transferase activity, transferring alkyl or [NAME] (other than methyl) groups
GO:0061134 | 0.000317346231417391 | 3.31571506253399 | 6.47293064876957 | 16 | 46 | peptidase regulator activity
GO:0016491 | 0.00066055969325721 | 1.70580716453358 | 37.8525727069351 | 57 | 269 | oxidoreductase activity
GO:0004866 | 0.0007659093355654791 | 3.50324675324675 | 5.06577181208054 | 13 | 36 | endopeptidase inhibitor activity
Clss3
GOMFID | Pvalue | OddsRatio | ExpCount | Count | Size | Term
GO:0008144 | 0.000198020737747538 | 7.1188995215311 | 1.27807606263982 | 7 | 29 | drug binding
GO:0000981 | 0.000240993235768674 | 4.51657754010695 | 2.64429530201342 | 10 | 60 | sequence-specific DNA binding RNA polymerase II transcription factor activity
Spreadsheet: 65091d1265834802-graphing-blank-cells-graph-example
Sheet: GRAPH DETAIL

Type | 2010-01-01 00:00:00 | 2010-02-28 00:00:00 | 2010-03-31 00:00:00
EST | 47 | 52.4 | 63.8
EST |  | 47 | 99.4
EST | 47 | 99.4 | 163.3
Act
Fcst | 50.8 | 56 | 56
Act / Fcst | 40.3
 | Period | Period | Period
[NAME] to KP | 3.799999999999997 | 3.600000000000001 | -7.799999999999997
Act Var to KP | -6.700000000000003
Spreadsheet: 71417d1272108529-extracting-a-specific-value-from-a-string-extracting-a-portion-of-the-string
Sheet: Sheet1

 |  | Raw String | What I need to get | The UDF result | My macro result
1 |  | ABCD_R_20090615_226C14593822_5_lds.acc | 226C14593822_5 | 226C14593822_5 | C__20090615_226C14593822_5_
2 |  | EFGH_R_20090615_226C14586214_1_acc | 226C14586214_1 | 226C14586214_1 | __20090615_226C14586214_1_
3 |  | IJKL_R_20090615_223C14593818_3_epm.acc | 223C14593818_3 | 223C14593818_3 | __20090615_223C14593818_3_
4 |  | MNOP_R_20090615_223C14593818_epm.acc6/16/09 | 223C14593818 | 223C14593818 | __20090615_223C14593818_61609
5 |  | QRST_R_20090615_428C14593712_lds.acc | 428C14593712 | 428C14593712 | __20090615_428C14593712_
6 |  | UVWX_P_20090615_428C14593620_ygl.acc | 428C14593620 | 428C14593620 | __20090615_428C14593620_
7 |  | YZ_R_20090615_226C14586651_3_lds.acc | 226C14586651_3 | 226C14586651_3 | __20090615_226C14586651_3_
8 |  | ABCD, [NAME] | 226C14586214_9 | 226C14586214_9 | C__20090615_226C14586214_9_
9 |  | HIJK, LMNOP_R_20090615_226C14593822_lds.acc | 226C14593822 | 226C14593822 | __20090615_226C14593822_
Spreadsheet: 674861d1588059698-calculate-average-out-of-a-table-book1
Sheet: Sheet1

number plate | Man. Name | Price in USD | country
8712412 | Mazda | 127818 | Japan
1927481 | Other | 84509 | Other |  |  |  | Man. Name | Average price for each country
2194281 | Kia | 106109 | Korea |  |  |  | Mazda
2153352 | VW | 121422 | Germany |  |  |  | Other
2194874 | VW | 65411 | Germany |  |  |  | Kia
1241242 | Mitsubishi | 147852 | Japan |  |  |  | VW
8373522 | Kia | 73259 | Korea |  |  |  | Mitsubishi
3256235 | Mazda | 76321 | Japan
7341553 | Mazda | 97233 | Japan
9164956 | VW | 99875 | Germany
9275789 | Mitsubishi | 98104 | Japan
8932593 | Other | 143233 | Other
8912412 | Kia | 139902 | Korea
8294618 | VW | 117424 | Germany
9847298 | Other | 131234
9184092 | Kia | 115575 | Korea
Spreadsheet: 646774d1572016834-sales-commission-formula-help-sales-commission-plan-mike-calc
Sheet: Sheet1

[NAME] | January | February | March | April | May | June | July | August | September | October | November | December | 2020 Revenue
Target
Earned | 150000 |  | 150000 |  |  |  |  |  |  | 210000
Commission
Salary
Total
Should be
Accum
0.03 |  |  |  |  |  |  |  |  |  |  |  |  | 3% of delivered revenue if under target
0.05 |  |  |  |  |  |  |  |  |  |  |  |  | 5% of delivered revenue if on target
Over
0.05
0.1
Total Over |  |  |  |  |  |  |  |  |  |  |  |  | 10% of revenue delivered that is over target (so you get 5% for hitting and then 10% for anything delivered above target)
Once hit 1.5m accumulative that month should be, 5% up to the 1.5m then 10%
So in October that is hit so commission should be
 | Target | Commission
Q1
Q2
Q3
Q4
Commission Structure
3% of delivered revenue if under target
5% of delivered revenue if on target
10% of revenue delivered that is over target (so you get 5% for hitting and then 10% for anything delivered above target)
10% of revenue delivered after $1.5m
Spreadsheet: 726168d1617092477-index-match-and-outstanding-receivable-days-debtor-age-analysis-2
Sheet: Age Analysis

I'm kindly asking for a formula for matching columns A to F  and calculating outstanding payment days
Customer Code | Customer Name | Invoice Date | Invoice | Invoice Amount | Amount Received | Outstanding Balance | Days Outstanding | Not yet Due | 1- 30 days | 31 - 60 Days | 61-90 Days | >90 Days
CT 002 | [NAME] | Opening Balance | C002 | 1750 | 1000
CT 002 | [NAME] | 2021-02-01 00:00:00 | C006 | 1200 | 1100
CT 002 | [NAME] | 2021-02-20 00:00:00 | C007 | 4000 | 0
CT 214 | THOKOZANI SIBANDA | Opening Balance | C003 | 1500 | 400
CT 214 | THOKOZANI SIBANDA | 2021-02-01 00:00:00 | C005 | 2000 | 0
CT 214 | THOKOZANI SIBANDA | 2021-02-15 00:00:00 | C008 | 500 | 0
H6: =IF($G6=0,"",IF(COUNT($C6)=0,"Previous Year",TODAY()-$C6-VLOOKUP($D6,TXs!$G:$I,3,0)))
Spreadsheet: 841168d1693405276-total-each-poker-players-best-25-weeks-over-four-sheets-sample_best-25-sort
Sheet: 3rd Qtr

 |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | [NAME]. | 1st Qtr. | 2nd Qtr. | [NAME]. | Yearly | Best 25 | Weeks
Rank | Player | 2023-07-09 00:00:00 | 2023-07-16 00:00:00 | 2023-07-23 00:00:00 | 2023-07-30 00:00:00 | 2023-08-06 00:00:00 | 2023-08-13 00:00:00 | 2023-08-20 00:00:00 | 2023-08-27 00:00:00 | 2023-09-03 00:00:00 | 2023-09-10 00:00:00 | 2023-09-17 00:00:00 | 2023-09-24 00:00:00 | Total | Total | Total | Total | Total | Total 1 | Played
1 | BillyMadison | 43 | 47 | 25 | 25 | 37 | 16 | 28 | 13 | 0 | 0 | 0
2 | win-winjd | 53 | 7 | 22 | 13 | 42 | 10 | 10 | 10 | 0 | 0 | 0
3 | moose | 48 | 4 | 7 | 41 | 16 | 13 | 47 | 38 | 0 | 0 | 0
4 | Pokerdoc13 | 10 | 31 | 19 | 1 | 25 | 31 | 1 | 0 | 0 | 0 | 0
5 | [NAME] | 34 | 37 | 16 | 0 | 10 | 37 | 13 | 4 | 0 | 0 | 0
6 | sicko | 13 | 0 | 40 | 0 | 28 | 0 | 37 | 0 | 0 | 0 | 0
7 | Billydice55 | 37 | 22 | 34 | 31 | 22 | 19 | 19 | 28 | 0 | 0 | 0
8 | FCSD36 | 0 | 0 | 28 | 7 | 19 | 1 | 0 | 22 | 0 | 0 | 0
9 | Amad | 19 | 42 | 50 | 4 | 7 | 28 | 42 | 1 | 0 | 0 | 0
10 | [NAME] | 28 | 13 | 13 | 16 | 47 | 47 | 22 | 16 | 0 | 0 | 0
11 | [NAME] | 22 | 28 | 31 | 22 | 31 | 22 | 31 | 19 | 0 | 0 | 0
12 | Rocket19 | 31 | 16 | 0 | 0 | 0 | 0 | 16 | 0 | 0 | 0 | 0
13 | Zscharps | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
14 | Wimp85 | 16 | 25 | 10 | 10 | 4 | 7 | 25 | 7 | 0 | 0 | 0
15 | [NAME] | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
16 | shorticus | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
17 | DoubleEagle | 0 | 0 | 0 | 0 | 13 | 42 | 7 | 0 | 0 | 0 | 0
18 | Bdshort14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
19 | TX_Tiger | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 33 | 0 | 0 | 0
20 | Burke | 0 | 19 | 45 | 19 | 0 | 25 | 0 | 0 | 0 | 0 | 0
21 | IaHawk | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
22 | BamaT8er | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
23 | Gator | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
24 | Rasty99 | 4 | 10 | 4 | 36
25 | JeffW | 7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
26 | RickNice | 25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
27 | Headhunter | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
28 | JoeSensitive | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
29 | LaCroix238 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
30 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
31 | eightyWon | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
32 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
33 | ThePiper | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
34 | Treebarkx | 0 | 0 | 1 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0
35 | Beakertwang | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
36 | CallStation |  |  |  |  |  | 4 |  |  |  |  |  |  |  | 0 | 0
Spreadsheet: 798174d1664352275-average-of-values-in-first-column-when-value-in-second-column-reaches-value-in-a-the-third-primaryflowtempexample
Sheet: Sheet1

FlowVol | Temp | TempSetPoint
1.15 | 22.1 | 0
1.58 | 22.43 | 0 |  | Note:
2.01 | 22.76 | 0 |  | Columns will always have a header.
2.44 | 23.09 | 0 |  | The range of values have been set up in Name Manager.
2.87 | 23.42 | 30.7
3.3 | 23.75 | 30.7
3.73 | 24.08 | 30.7 |  | Calculation:
4.16 | 24.41 | 30.7 |  | The average of column A (yellow, 6.74) from the start until the value in column B reaches the first reading above 0 in column C (green, 30.7).
4.59 | 24.74 | 30.7 |  | The returned result will be 6.74
5.02 | 25.07 | 30.7
5.45 | 25.4 | 30.7
5.88 | 25.73 | 30.7
6.31 | 26.06 | 30.7
6.74 | 26.39 | 30.7
7.17 | 26.72 | 30.7
7.6 | 27.05 | 30.7
8.03 | 27.38 | 30.7
8.46 | 27.71 | 30.7
8.89 | 28.04 | 30.7
9.32 | 28.37 | 30.7
9.75 | 28.7 | 30.7
10.18 | 29.03 | 30.7
10.61 | 29.36 | 30.7
11.04 | 29.69 | 30.7
11.47 | 30.02 | 30.7
11.9 | 30.35 | 30.7
12.33 | 30.68 | 30.7
12.76 | 31.01 | 30.7
13.19 | 31.34 | 30.7
Spreadsheet: 150251d1334350556-excel-2007-problem-with-sumproduct-across-muliple-sheets-sp-scross-sheets
Sheet: Sheet1

EE | EMPLOYEE | AAA | BBB | CCC | DDD | EEE
1 | Name 1 | 111
2 | Name 2
3 | Name 3
4 | Name 4
5 | Name 5
6 | Name 6
7 | Name 7
8 | Name 8
9 | Name 9
10 | Name 10 |  |  |  | 3.5 | 3.5
Spreadsheet: 72539d1273230497-lookup-values-in-2-different-workbooks-workbook-1
Sheet: Key Ring 18

Barcode | Code | Price | Category | Supplier
118971120001 | KR97-1 | 375 | 18 | 97
118971600002 | KR97-2 | 375 | 18 | 97
118971360003 | KR97-3 | 375 | 18 | 97
Spreadsheet: 875493d1722060431-help-with-creating-columns-from-repeating-pattern-in-single-column-book1_transpose
Sheet: Sheet2

Column1 |  |  | Custom.Index | Name | Group | Department | Manager | Location | Address
Name : xxxxx |  |  | 1 | xxxxx | xxxxx | xxxxxx | xxxxxx | xxxxx | xxxxxx
Group : xxxxx |  |  | 2 | xxxxxx | xxxxxx | xxxxxx | xxxxx | xxxxx | xxxxxx
Department : xxxxxx |  |  | 3 | xxxxxx | xxxxxx | xxxxxx | xxxxx | xxxxx | xxxxxx
Manager : xxxxxx |  |  | 4 | xxxxxx | xxxxxx | xxxxxx | xxxxxx | xxxxx | xxxxx
Location :xxxxx |  |  | 5 | xxxxxx | xxxxxx | xxxxxx | xxxxxx | xxxxx | xxxxx
Address : xxxxxx
Name : xxxxxx
Group : xxxxxx
Department : xxxxxx
Manager : xxxxx
Location :xxxxx
Address :xxxxxx
Name : xxxxxx
Group : xxxxxx
Department : xxxxxx
Manager : xxxxx
Location :xxxxx
Address :xxxxxx
Name : xxxxxx
Group : xxxxxx
Department : xxxxxx
Manager : xxxxxx
Location :xxxxx
Address : xxxxx
Name : xxxxxx
Group : xxxxxx
Department : xxxxxx
Manager : xxxxxx
Location :xxxxx
Address : xxxxx
Spreadsheet: 76885d1277368226-excel-2007-multiple-ifs-problema
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sizes
 |  | per unit | Sizes |  |  |  |  |  |  | <-- Here I will insert some prices of which I have to compute indexes in the following tables. In the first table, the index is given with respect to the first existing value at the beginning of each column (which has to take value 100). In the second table, the index is calculated with respect to the first existing value for each row. |  |  |  |  |  |  |  | per unit
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | This is what can occur. Not all the cells may contain value. Therefore the point of reference for the index (the 100 value) may change.
Counts |  | a |  |  |  |  |  |  |  |  |  |  |  |  |  | Counts |  | a
 |  | b |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | b |  |  | 11 | 12 |  |  | 18
 |  | c |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | c
 |  | d |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d |  | 50 |  |  |  | 60
 |  | e |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | e |  |  |  | 34
 |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | f
 |  | Intercount discount * |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Intercount discount *
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
Counts |  | a |  |  |  |  |  |  |  |  | <-- I have to insert formulas here |  |  |  |  | Counts |  | a
 |  | b |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | b
 |  | c |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | c
 |  | d |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d
 |  | e |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | e
 |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | f
 |  | Intersize index |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Intersize index
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
Counts |  | a |  |  |  |  |  |  |  |  | <-- and here |  |  |  |  | Counts |  | a
 |  | b |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | b
 |  | c |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | c
 |  | d |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d
 |  | e |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | e
 |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | f
Spreadsheet: 157736d1337860416-add-rows-blake
Sheet: Sheet1

ID | Hours
145 | 3
145 | 3
67 | 5
1507 | 1
1507 | 1
1507 | 1
Spreadsheet: 7042801b-3ac8-4219-abdf-b60cc43a95ee
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
AMS | Test | AMS | Amylase, Total, Serum | Amylase, Total, S | Colorimetric Rate Reaction | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Serum gel Acceptable: Red top [NAME]: 0.5 mL Additional Information: Patient's age and sex are required. | 0.25 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | 0-30 days: 0-6 U/L                                                            31-182 days: 1-17 U/L                                                        183-365 days: 6-44 U/L                                                         1-3 years: 8-79 U/L                                                            4-17 years: 21-110 U/L                                                         > or =18 years: 26-102 U/L | Monday through Sunday; Continuously | Same day/1 day | 2 days | 1 | 82150 |  |  |  |  | Rochester
AMS | [NAME] | SERUM | Serum |  |  |  | Frozen | 30 days
AMS | Result | AMS | Amylase, Total, S | Amylase, Total, S | Numeric |  |  |  |  | U/L |  |  |  |  |  |  |  |  |  | 1798-8
Spreadsheet: mary_fischer__25632__31N
Sheet: E21.XLS 

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031N
COMPANY NAME    EFS C&S
LEASE EXPENSE & FUTURE LEASE COMMITMENTS
FOR THE 3 MONTHS ENDED 3-31-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-21
+++++INCLUDE all rentals (building, equipment, etc.) regardless of whether it is charged to "rent expense".
+++++EXCLUDE rent allocations from Corporate or other subsidiaries.
Lease Description |  |  |  | Year to Date |  |  |  |  |  | FUTURE LEASE COMMITMENT ( net of sublease , if applicable) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Residual
Property Leased, Term, Lessor |  | *(C) |  | Gross |  | Less: |  | Net Rental |  | 1 Year Ended |  |  |  |  |  |  |  |  |  | 5 Years Ended |  |  |  |  |  | Total Remaining |  | Total |  | Value
*Indicate Capital (C) or Operating (O) Lease |  | or (O) |  | Rentals |  | Subrentals |  | Expense |  | 12-31-2002 |  | 12-31-2003 |  | 12-31-2004 |  | 12-31-2005 |  | 12-31-2006 |  | 12-31-2011 |  | 12-31-2016 |  | 12-31-2021 |  | after 12-31-2021 |  | Commitment |  | Guarantee
Individually list leases w/ an annual rent expense over $1 million.
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other Leases under $1million per year |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-21
Spreadsheet: hunter_shively__12724__Fundamentals_Netco
Sheet: IT Dev-EOL

 | IT Development
 | 2002 Plan
 |  | 2001-09-01 00:00:00 |  | 2001 |  | 2002 |  |  |  | Per HC | New HC | Adj Comp |  | 2002
 |  | YTD Actual |  | Forecast |  | Plan |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation
 | Special Pays | 0 |  |  |  |  |  |  | Compensation | 0
 | Analyst & Assoicate | 0
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense |  |  |  |  |  |  |  | Other
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services | 0 |  |  |  |  |  |  | Total
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions |  |  |  |  |  |  |  | [NAME] | 49200
ENARENT | Rent |  |  |  |  |  |  |  | [NAME] | 57600 | 3
ENATECH | Technology |  |  |  |  |  |  |  | Staff | 60000 | 1
ENATRANS | Transportation |  |  |  |  |  |  |  | Specialist | 78000
ENAOTHEX | Other Expenses |  |  |  |  |  |  |  | Sr. Specialist | 102000 | 62
ENATAXES | Taxes Other than Income |  |  |  |  |  |  |  | Tech | 192000 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  |  | IT Consultants | 192000 | 0
 |  |  |  |  |  |  |  |  | Manager | 144000 | 28
 | Headcount |  |  | 111 | 40 |  |  |  | Director | 168000 | 9
 |  |  |  |  |  |  |  |  | Sr. Director | 216000 | 8
 | A&A Headcount |  |  |  |  |  |  |  | VP | 222000 | 1
 |  |  |  |  |  |  |  |  | MD | 300000
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
ENAOUTLG | Outside Legal |  |  | 0 |  |  |  |  | Benefits & Taxes |  |  | 0.2
ENAOUTTX | Outside Tax
ENAINSUR | Insurance |  |  |  |  |  |  |  | Consultants | 160000 | 0
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure |  |  | 0
ENACORRN | Corporate Rent |  |  | 0
ENAOTHAL | Other Allocated Direct  Expenses |  |  | 0 |  |  |  | Other Expense Calculation
ENADEPR | Depreciation & Amortization
ENAOUTSV | Outside Services | 24143776.43 |  | 0 |  |  |  | Based on information from ENW accounting.
 | IT Development costs includes amounts for maintenance and enhancements to
 | Enpower, Sitara, Unify, TAGG, ERMS, and other trading systems along
 | with [NAME] and [NAME] licenses.
Spreadsheet: 541858d1507581944-complex-formula-using-countifs-and-sumifs-to-derive-a-value-across-tabs-quartermaster_matri_foumx
Sheet: QuarterMaster_Matrix

 | Number of Nights | 4
 | [NAME]
 | [NAME] | 250
 | [NAME]
 | Food Input - Total | 250
 | Food Inflation Rate | 0.05
 | [NAME] Day | 15
 | Tip - Total
 | Person | Food - Total | Food - Pre Total | Lodging -Total | Dinner $ | FIR | FIR $ Total | Participant | #people |  |  |  |  | Number of Guys | Price Per day per guy |  |  |  | Example Total
 |  |  |  |  |  |  |  |  |  |  |  |  | Day 1 |  |  |  |  |  |  | =[NAME]
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | Day 2
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | Day 3
 | Buddy |  |  |  |  |  |  |  |  |  |  |  | Day 4
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | Day 5
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | Day 6
 | Mark |  |  |  |  |  |  |  |  |  |  |  | Day 7
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | Day 8
 |  |  |  |  |  |  |  |  |  |  |  |  | Day 9
 |  |  |  |  |  |  |  |  |  |  |  |  | Day 10
Spreadsheet: 97770d1296853940-sumif-help-with-multiple-tabs-payroll-cards-formula-test
Sheet: Totals

 |  |  | Hourly | Therapy
 | Hrly Rate | Hrs | Wages | Wages | Salary | OnCall | Total
Noni
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Michelle
Bettina
[NAME]
Jessica
[NAME]
[NAME]
Spreadsheet: 776248d1649629494-hours-work-when-working-past-midnight-testweek
Sheet: Sheet1

Sunday | Platform |  | 0944 |  | Pays |  | 1056 |  |  |  |  |  |  |  |  |  | [NAME] |  | [NAME]
Run # | Start Time | Hidden | End Time | Hidden | Extend | Hidden | Duration | Task | HOS Today |  |  | Totals |  | [NAME] | OT |  | Non Platform | Day | Yes
64-3 | 2100 |  | 2600 |  |  |  |  | Platform | Non Platform |  |  | Non Platform |  |  |  |  | Platform |  | No
11-4 | 1317 |  | 1520 |  |  |  |  | Platform | Platform |  |  | Platform |  |  |  |  | Stand-By
161-1 | 1551 |  | 1929 |  |  |  |  | Platform | Overtime |  |  | Stand-By |  |  |  |  | OT / Scrounge
 |  |  |  |  |  |  |  |  | Call-Up |  |  | OT / Scrounge
 |  |  |  |  |  |  |  |  | Overall Hours
Call Up ? | No |  | 9:30 Booking |  | No |  | Additional HOS Minutes