tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 475444d1471312412-extract-data-date-parse
Sheet: Sheet1

Data key:-
1. Data arrives and is loaded in columns B & C
2. The program numbers are already known and are already entered in the column headings  range E5:L6 |  |  |  | Desired output
3. Data in blue to be programatically extracted | Data in this format |  |  | Program 1 |  | Program 12 |  | Program 2 |  | Program 14
 |  |  |  | Start | End | Start | End | Start | End | Start | End
 | Program 1 | Aug 15-17 |  | 2016-08-15 00:00:00 | 2016-08-17 00:00:00
 |  | Sep 5-7 |  | 2016-09-05 00:00:00 | 2016-09-07 00:00:00
 |  | Oct 10-12 |  | 2016-10-10 00:00:00 | 2016-10-12 00:00:00
 | Program 12 | Aug 29-31 |  |  |  | 2016-08-29 00:00:00 | 2016-08-31 00:00:00
 |  | Oct 24-26 |  |  |  | 2016-10-24 00:00:00 | 2016-08-26 00:00:00
 | Program 2 | Aug 8,22 |  |  |  |  |  | 2016-08-08 00:00:00
 |  | Sep 5,19 |  |  |  |  |  | 2016-08-22 00:00:00
 |  | [NAME] |  |  |  |  |  | 2016-09-05 00:00:00
 |  |  |  |  |  |  |  | 2016-09-19 00:00:00
 | Program 14 | Aug |  |  |  |  |  | 2016-10-03 00:00:00
 |  | 2,4,10,23,25 |  |  |  |  |  | 2016-10-17 00:00:00 |  | 2016-08-02 00:00:00
 |  | Sep |  |  |  |  |  | 2016-10-31 00:00:00 |  | 2016-10-04 00:00:00
 |  | 6,8,13,15,20, 22,27,29 |  |  |  |  |  |  |  | 2016-08-10 00:00:00
 |  | [NAME] |  |  |  |  |  |  |  | 2016-08-23 00:00:00
 |  | 5,7,11,13,18, |  |  |  |  |  |  |  | 2016-08-25 00:00:00
 |  | 20,25,27 |  |  |  |  |  |  |  | 2016-09-06 00:00:00
 |  |  |  |  |  |  |  |  |  | 2016-09-08 00:00:00
 |  |  |  |  |  |  |  |  |  | 2016-09-13 00:00:00
 |  |  |  |  |  |  |  |  |  | 2016-09-15 00:00:00
 |  |  |  |  |  |  |  |  |  | 2016-09-20 00:00:00
 |  |  |  |  |  |  |  |  |  | 2016-09-22 00:00:00
 |  |  |  |  |  |  |  |  |  | 2016-09-27 00:00:00
 |  |  |  |  |  |  |  |  |  | 2016-09-29 00:00:00
 |  |  |  |  |  |  |  |  |  | 2016-10-05 00:00:00
 |  |  |  |  |  |  |  |  |  | 2016-10-07 00:00:00
 |  |  |  |  |  |  |  |  |  | 2016-10-11 00:00:00
 |  |  |  |  |  |  |  |  |  | 2016-10-13 00:00:00
 |  |  |  |  |  |  |  |  |  | 2016-10-18 00:00:00
 |  |  |  |  |  |  |  |  |  | 2016-10-18 00:00:00
 |  |  |  |  |  |  |  |  |  | 2016-10-20 00:00:00
 |  |  |  |  |  |  |  |  |  | 2016-10-25 00:00:00
 |  |  |  |  |  |  |  |  |  | 2016-10-27 00:00:00
Spreadsheet: 781486d1653375460-transpose-or-transfer-from-horizontal-data-to-vertical-daf-tocol-aligw
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RESULT
 | INPUT DATA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date | Amount
Name | Date | Amount | Date | Amount | Date | Amount | Date | Amount | Date | Amount | Date | Amount | Date | Amount | Date | Amount |  |  |  | 2000 | FORMULA HERE
Name 1 | 2019-05-07 00:00:00 | 2000 |  |  | 2019-10-23 00:00:00 | 3000 | 2019-04-05 00:00:00 | 2000 | 2019-05-08 00:00:00 | 6000 |  |  | 2019-07-08 00:00:00 | 9500 | 2019-07-30 00:00:00 | 10000 |  |  | 2019-05-07 00:00:00 | 2000
Name 2 | 2019-07-07 00:00:00 | 2500 |  |  |  |  |  |  | 2019-06-22 00:00:00 | 2500 | 2019-11-21 00:00:00 | 2500 | 2019-08-15 00:00:00 | 9500 |  |  |  |  | 2019-05-08 00:00:00 | 6000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019-06-22 00:00:00 | 2500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019-07-07 00:00:00 | 2500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019-07-08 00:00:00 | 9500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019-07-30 00:00:00 | 10000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019-08-15 00:00:00 | 9500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019-10-23 00:00:00 | 3000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019-11-21 00:00:00 | 2500
 |  | *ALL DATA IN BLUE COLOR CELLS (INPUT DATA) WILL  AUTOMATICALLY TRANSFER TO RESULT COLUMN
 |  | * MUST BE GROUP BY DATE & AMOUNT
Spreadsheet: 223355d1364180131-referring-to-different-matrices-dependant-on-value-entry-multimatrix-ref
Sheet: Product B

 | 3m | 5m | 8m | 10m | 12.5m | 16m | 20m | 22m | 25m
2T | Model 1 | Model 1M | Model 1L | Model 1XL | Model 1XXL | Model 1G | Model 1GG | Model 1GG2 | Model 1GG3
5T | Model 2 | Model 2M | Model 2L | Model 2XL | Model 2XXL | Model 2G | Model 2GG | Model 2GG2 | Model 2GG3
7T | Model 3 | Model 3M | Model 3L | Model 3XL | Model 3XXL | Model 3G | Model 3GG | Model 3GG2 | Model 3GG3
10T | Model 4 | Model 4M | Model 4L | Model 4XL | Model 4XXL | Model 4G | [NAME] | Model 4GG2 | Model 4GG3
12T | Model 5 | Model 5M | Model 5L | Model 5XL | Model 5XXL | Model 5G | Model 5GG | Model 5GG2 | Model 5GG3
15T | Model 6 | Model 6M | Model 6L | Model 6XL | Model 6XXL | Model 6G | Model 6GG | Model 6GG2 | Model 6GG3
30T | Model 7 | Model 7M | Model 7L | Model 7XL | Model 7XXL | Model 7G | Model 7GG | Model 7GG2 | Model 7GG3
Spreadsheet: 173744d1344707849-conditional-format-based-on-a-defined-range-engineering-release
Sheet: Release

 |  |  | Engineering Release
 | ER Number |  |  | Project Name |  |  | Date
Cost Code | QTY | TA Part# | Detail# | Description/Material | Primary Vendor | Unit Cost | Required Date | Job # | Area | [NAME] (Formula) | Header
 |  |  |  |  |  |  |  |  |  |  |  |  | Primary Vendor
 |  |  |  |  | fgh |  |  |  |  |  |  |  | TACNC
 |  |  |  |  | TAHORN |  |  |  |  |  |  |  | TAFAB
 |  |  |  |  | TACNC |  |  |  |  |  |  |  | TAHORN
 |  |  |  |  | TAPRE |  |  |  |  |  |  |  | TAKIT
 |  |  |  |  | fgbsfjhb |  |  |  |  |  |  |  | TAMACH
 |  |  |  |  | dffsg |  |  |  |  |  |  |  | TAPRE
 |  |  |  |  | TAPRE
 |  |  |  |  | eg
 |  |  |  |  | does it?
 |  |  |  |  | This works all the time
 |  |  |  |  | yes
 |  |  |  |  | why
Spreadsheet: 009eb9ee-c461-44bf-803f-8791b1adfb0c
Sheet: Sheet1

Table 1--U.S. cotton supply and use estimates | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  |  |  |  |  | 2012/13
Item | 2011/12 |  | May |  | June |  | July
 | Million acres
Upland:
Planted | 14.428 |  | 12.885 |  | 12.885 |  | 12.4
Harvested | 9.156 |  | 10.234 |  | 10.234 |  | 10.167
 | Pounds
Yield/harvested acre | 772 |  | 764 |  | 764 | 764 | 773
 | Million 480-lb. [NAME]
Beginning stocks | 2.572 |  | 3.198 |  | 2.968 |  | 3.063
Production | 14.722 |  | 16.28 |  | 16.28 |  | 16.365
Total supply   1/ | 17.309 |  | 19.483 |  | 19.253 |  | 19.433
[NAME] use | 3.278 |  | 3.47 |  | 3.47 |  | 3.375
Exports | 10.975 |  | 11.3 |  | 11.1 |  | 11.4
Total use | 14.253 |  | 14.77 |  | 14.57 |  | 14.775
Ending stocks  2/ | 3.063 |  | 4.708 |  | 4.678 |  | 4.653
 | Percent
Stocks-to-use ratio | 21.5 |  | 31.9 |  | 32.1 |  | 31.5
 | 1,000 acres
Extra-long staple:
Planted | 307.4 |  | 270 | 270 | 270 |  | 235
Harvested | 304.9 |  | 266 | 266 | 266 |  | 233
 | Pounds
Yield/harvested acre | 1340 |  | 1300 |  | 1300 |  | 1308
 | 1,000 480-lb. [NAME]
Beginning stocks | 28 |  | 202 |  | 232 |  | 237
Production | 851 |  | 720 |  | 720 |  | 635
Total supply   1/ | 884 |  | 922 |  | 952 |  | 872
[NAME] use | 22 |  | 30 |  | 30 |  | 25
Exports | 625 |  | 700 |  | 700 |  | 700
Total use | 647 |  | 730 |  | 730 |  | 725
Ending stocks  2/ | 237 |  | 192 |  | 222 |  | 147
 | Percent
Stocks-to-use ratio | 36.6 | 30.2 | 26.3 |  | 30.4 |  | 20.3
1/ Includes imports.  2/ Includes unaccounted.
Last update:  07/12/12.
Sources: USDA, World Agricultural Outlook Board; and USDC,
U.S. Census Bureau.
Spreadsheet: 118687d1313892558-find-the-exact-p-n-in-a-multi-p-n-range-of-cells-messy3
Sheet: Sheet1

P/N | SHELF | QTY |  | CODE | SHELF | TOTAL  QTY
AA | 1 | 1 |  | a | 2 | 46
AA | 2 | 2
AB | 3 | 3
AB | 2 | 4
BB | 1 | 5
BB | 2 | 6
CC | 1 | 7
A, CA, D | 2 | 8
A, CA, DA | 2 | 9
EE | 2 | 10
EE | 3 | 11
FF | 4 | 12
GG, A, BB | 2 | 13
GG | 6 | 14
HH | 7 | 15
JJ, KK, A | 2 | 16
GG | 6 | 17
MM | 8 | 18
GG, NN, BB | 9 | 19
Spreadsheet: 124222d1318257879-excel-2007-common-finder-exa-1-
Sheet: Sheet1

Common A | Common B |  | Ideal |  | Answer
12 | 24 |  | 9 |  | 3
79 | 85 |  | 63
 |  |  |  |  |  |  | 22 | 63
 |  |  |  |  |  | 37
Spreadsheet: 852851d1702827955-need-help-with-filtering-drop-down-lists-from-vstack-data-on-a-separate-tab-digital-operator-production-log-v2-aligw
Sheet: Master Schedule Updates

↓Select Client Name↓ | ↓Select Job #↓ |  | Master [NAME] |  |  | These helper columns can be hidden!!!
DELE | 3234 | =
SupplyLogic | 243222 | = |  |  |  |  | 243145 | 243222 | 243333 | 243545 | 243676
 |  | =
 |  | =
 |  | =
 |  | =
 |  | =
HH Global | 123321 | = |  |  |  |  | 123444 | 123555
 |  | =
 |  | =
 |  | =
 |  | =
 |  | =
 |  | =
Spreadsheet: vkaminski__40935__s100068
Sheet: DirectVoiceServices

 | Enron Information Services
 | For the Accounting Month of February, 2001
 | for Information Only - DO NOT PAY
 | Company: 0011 Enron Corp.   Cost Center: 100068 CORP-RAC-Risk Mgt Co
 | Dept | Dept Name | Account Code | Original Acctg Month | Heading | Name | Room | Amount | Description
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | Reasoner, [NAME] | n/a | 13.75 | 1-800-97-ENRON Domestic
Not in Group | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | Stephan, Nick | n/a | 0.04 | 1-800-97-ENRON Domestic
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | Hagelmann, Bjorn | n/a | 4.19 | 1-800-97-ENRON Domestic
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | LeBroc, Christian | n/a | 2.16 | 1-800-97-ENRON Domestic
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | [NAME], [NAME] | n/a | 0.53 | 1-800-97-ENRON Domestic
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | Dalal, Sunil | n/a | 1.11 | 1-800-97-ENRON Domestic
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | Yuan, [NAME] | n/a | 0.16 | 1-800-97-ENRON Domestic
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | Paraschos, Nick | n/a | 9.4 | 1-800-97-ENRON Domestic
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | *Fax-Risk Control | n/a | 2.04 | 1-800-97-ENRON Domestic
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | *Fax-Risk EB2822A | n/a | 2.7 | 1-800-97-ENRON Domestic
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | Schultz, [NAME] | n/a | 1.88 | 1-800-97-ENRON Domestic
Moved to CC 100052 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | Suttle, [NAME] | n/a | 17.66 | 1-800-97-ENRON Domestic
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | Hennessy, Rita | n/a | 3.04 | 1-800-97-ENRON Domestic
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | Adams, [NAME] | n/a | 1.86 | 1-800-97-ENRON Domestic
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | [NAME],Minal | n/a | 0.55 | 1-800-97-ENRON Domestic
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | Davenport, [NAME] | n/a | 4.08 | 1-800-97-ENRON Domestic
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | Economou, [NAME] | n/a | 7.32 | 1-800-97-ENRON Domestic
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | Gorny, [NAME] | n/a | 0.68 | 1-800-97-ENRON Domestic
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | *Modem-Murphy | n/a | 0.01 | 1-800-97-ENRON Domestic
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | Phillips, Rebecca | n/a | 0.04 | 1-800-97-ENRON Domestic
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | Port, [NAME] | n/a | 1.87 | 1-800-97-ENRON Domestic
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | Reasoner, [NAME] | n/a | 1.97 | 1-800-97-ENRON Domestic
Not in Group | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | PIPER, GREG |  | 30.25 | Credit Card Calls
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200101 | ProcFee |  |  | -0.14 | Processing Fee
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | ProcFee |  |  | 0.61 | Processing Fee
 | 100068 Total
 | Grand Total
Spreadsheet: 59008d1259334122-sumproduct-not-all-employees-are-working-708854_debs1
Sheet: Summary

Cost Centre | A
 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00
Salary Costs | 0 | 4090.75 | 4090.75 | 6875 | 6875 | 10137.41666666667 | 10137.41666666667 | 10137.41666666667 | 13774.91666666667 | 16405.91666666666 | 16405.91666666666 | 16405.91666666666 | 16405.91666666666 | 16405.91666666666 | 16405.91666666666
Spreadsheet: 820777d1678287247-formula-that-looks-for-a-color-name-example-workbook
Sheet: Sheet1

Object 1 |  |  |  | 13900
Object 2 |  |  |  | 36000
Object 3 |  |  |  | 80200
Object 4 |  |  |  | 56200
Object 5 |  |  |  | 48700
Object 6 |  |  |  | 68600
Object 7 |  |  |  | 4200
Object 8 |  |  |  | 33700
Object 9 |  |  |  | 95800
Object 10 |  |  |  | 41000
 |  |  |  |  |  |  |  |  |  | Group 1 | 0
 |  |  |  |  |  |  |  |  |  | Group 2 | 0.05
 |  |  |  |  |  |  |  |  |  | Group 3 | 0.25
 |  |  |  | Price | Price with add |  |  |  |  | Group 4 | 0.1
Group 1
Object 1 |  |  |  | 13900
Object 2 |  |  |  | 36000
Object 3 |  |  |  | 80200
Object 4 |  |  |  | 56200
Object 5 |  |  |  | 48700
Object 6 |  |  |  | 68600
Object 7 |  |  |  | 4200
Object 8 |  |  |  | 33700
Group 2
Object 10 |  |  |  | 41000
Object 2 |  |  |  | 36000
Object 3 |  |  |  | 80200
Object 4 |  |  |  | 56200
Object 4 |  |  |  | 56200
Object 4 |  |  |  | 56200
Object 4 |  |  |  | 56200
Object 4 |  |  |  | 56200
Object 4 |  |  |  | 56200
Object 4 |  |  |  | 56200
Object 4 |  |  |  | 56200
Object 1 |  |  |  | 13900
Object 1 |  |  |  | 13900
Object 9 |  |  |  | 95800
Object 6 |  |  |  | 68600
Group 3
Object 3 |  |  |  | 80200
Object 3 |  |  |  | 80200
Object 3 |  |  |  | 80200
Object 4 |  |  |  | 56200
Group 4
Object 5 |  |  |  | 48700
Object 6 |  |  |  | 68600
Object 7 |  |  |  | 4200
Object 8 |  |  |  | 33700
Object 9 |  |  |  | 95800
Object 10 |  |  |  | 41000
Spreadsheet: michelle_lokay__26561__imbalsumm0012
Sheet: transcol

 | TransColorado
 | 500632
Day | Measured | Scheduled
1 | 23550 | 23150
2 | 23965 | 23150
3 | 23996 | 23150
4 | 23484 | 23150
5 | 23000 | 23150
6 | 23146 | 23150
7 | 20037 | 23150
8 | 23762 | 23150
9 | 23829 | 23150
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2000-11-30 00:00:00 |  |  | 95639.73
2000-12-09 00:00:00
Spreadsheet: 541888d1507612235-finding-top-3-highest-values-without-ties-excelforum-eg-kolega940
Sheet: Sheet1

Student | Score |  |  |  |  | Present |  | Sixthsense | benishiryo |  |  | with Column G as 1 |  |  | Not repeating student B and with col G as 1
A | 60 |  |  |  |  | 1
B | 55 |  |  |  |  | 1
C | 55 |  |  |  |  | 1
D | 40 |  |  |  |  | 0
E | 21 |  |  |  |  | 1
Spreadsheet: 99ebfea1-3b1a-481e-8c30-9168da58d9b5
Sheet: Sheet1

Release: U.S. Import and Export Price Indexes | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=188
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-08-22 7:17 PM CDT
 | Real-Time | Period
Name: | Start | End
U.S. Import and Export Price Indexes | 2010-03-16 00:00:00 | Current
Link:
http://www.bls.gov/mxp/ | 2010-03-16 00:00:00 | Current
Source:
U.S. Department of Labor: Bureau of Labor Statistics | 2010-03-16 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2010-03-16 00:00:00
2010-04-13 00:00:00
2010-05-13 00:00:00
2010-06-15 00:00:00
2010-07-14 00:00:00
2010-08-12 00:00:00
2010-09-15 00:00:00
2010-10-13 00:00:00
2010-11-10 00:00:00
2010-12-10 00:00:00
2011-01-12 00:00:00
2011-02-15 00:00:00
2011-03-15 00:00:00
2011-04-12 00:00:00
2011-05-10 00:00:00
2011-06-10 00:00:00
2011-07-13 00:00:00
2011-08-16 00:00:00
2011-09-13 00:00:00
2011-10-14 00:00:00
2011-11-10 00:00:00
2011-12-14 00:00:00
2012-01-13 00:00:00
2012-02-14 00:00:00
2012-03-14 00:00:00
2012-04-11 00:00:00
2012-05-10 00:00:00
2012-06-12 00:00:00
2012-07-12 00:00:00
2012-08-10 00:00:00
2012-09-12 00:00:00
2012-10-11 00:00:00
2012-11-09 00:00:00
2012-12-12 00:00:00
2013-01-11 00:00:00
2013-02-13 00:00:00
2013-03-13 00:00:00
2013-04-11 00:00:00
2013-05-14 00:00:00
2013-06-13 00:00:00
2013-07-11 00:00:00
2013-08-13 00:00:00
2013-09-12 00:00:00
2013-10-23 00:00:00
2013-11-15 00:00:00
2013-12-12 00:00:00
2014-01-14 00:00:00
2014-02-14 00:00:00
2014-03-13 00:00:00
2014-04-10 00:00:00
2014-05-13 00:00:00
2014-06-12 00:00:00
2014-07-15 00:00:00
2014-08-14 00:00:00
Spreadsheet: mary_fischer__25625__1290
Sheet: E21.XLS 

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 1290
LEASE EXPENSE & FUTURE LEASE COMMITMENTS
FOR THE 6 MONTHS ENDED 6-30-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: 150530d1334590291-date-tracking-please-help-case-tracking
Sheet: Sheet1

Case | Date Rec. | Inv. | Ass. | Priority 1 | Response Due | Response Met | REMOVAL | IPA | Diligent Search | State Custody | Expedited | Custodial | Non-Custodial | 72 Hr. [NAME]. | Initial CFTM | Probable Cause | Merits | Non-Custodial Plan | Services Provided | 30 days | 60 days | 90 days | 120 days | Transfer Meeting | Closure
 | 2011-03-04 00:00:00 |  |  | Priority 3 | 2011-03-07 00:00:00
 | 2011-03-05 00:00:00 |  |  | Priority 3 | 2011-03-08 00:00:00
Spreadsheet: 35598d1233183472-conditional-counting-in-excel-2003-invalid_call_example
Sheet: Sheet2

Count of Valid Call | [NAME]
Company | N | Y | Grand Total
ABC1 | 16 | 17 | 33
[NAME] | 13 | 12 | 25
ABC3 | 10 | 10 | 20
[NAME] | 10 | 10 | 20
Grand Total | 49 | 49 | 98
Spreadsheet: 767252d1644365493-help-me-calculate-the-plus-factor-for-a-schedule-sample-schedule
Sheet: Sample

 |  |  |  |  | Total LOE (Hours) | Gross Business Days |  |  |  |  |  |  |  |  |  |  |  |  |  | Plus Factor | Total Business Days
 |  |  |  |  |  |  | Dependencies
 |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Kelsey |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Kelsey
 |  |  |  | [NAME] | 20 |  | N/A | 0 | 0 | 0 | 0 | 0 |  | N/A
 |  |  |  | [NAME] | 100 | 15 | 3 | N/A | 0 | 0 | 0 | 0 |  |  | N/A
 |  |  |  | [NAME] | 110 |  | 3 | 15 | N/A | 0 | 0 | 0 |  |  |  | N/A
 |  |  |  | [NAME] | 100 |  | 0 | 0 | 5 | N/A | 0 | 0 |  |  |  |  | N/A
 |  |  |  | [NAME] | 50 |  | 0 | 0 | 0 | 0 | N/A | 3 |  |  |  |  |  | N/A
 |  |  |  | Kelsey | 40 |  | 3 | 0 | 0 | 0 | 0 | N/A |  |  |  |  |  |  | N/A
 |  |  |  | [NAME] | 2
 |  |  |  | [NAME] | 2
 |  |  |  | [NAME] | 2
 |  |  |  | [NAME] | 2
 |  |  |  | [NAME] | 2
 |  |  |  | Kelsey | 2
Spreadsheet: 75675d1276207945-world-cup-draw-world-cup-draw
Sheet: Sheet1

name 1 | south africa
name 2 | mexico
name 3 | uruguay
name 4 | france
name 5 | argentina
name 6 | nigeria
name 7 | korea republic
name 8 | greece
name 9 | england
name 10 | usa
name 11 | algeria
name 12 | slovenia
name 13 | germany
name 14 | austrailia
name 15 | serbia
name 16 | ghana
name 17 | holland
name 18 | denmark
name 19 | japan
name 20 | cameroon
name 21 | italy
name 22 | paraguay
name 23 | new zealand
name 24 | slovakia
name 25 | brazil
name 26 | korea dpr
name 27 | ivory coast
name 28 | portugal
name 29 | spain
name 30 | switherland
name 31 | honduras
name 32 | chile
Spreadsheet: 483370d1475615175-count-sites-forecasted-per-week-book2
Sheet: Front Page

Milestone | # [NAME] This week | # Sites Actual This week | # [NAME] Next Week | # [NAME] week after next | # [NAME] after next
[NAME]
ZZ020
[NAME]
XX020
XX035
[NAME]
Milestone | # [NAME] This week | # Sites Actual This week | # [NAME] Next Week | # [NAME] week after next | # [NAME] after next
[NAME] |  |  | 2 | 0 | 0
Spreadsheet: 129771d1321881672-calculating-time-copy-of-timecard_1
Sheet: Sheet1

 | In | [NAME] | Lunch End | Out | Regular | Over Time | Daily Total
Monday | 07:25:00 | 12:00:00 | 13:00:00 | 15:00:00 | 6.583333333333334 | 0 | 06:35:00
Tuesday |  |  |  |  |  |  | 1900-01-01 00:00:00
Wednesday |  |  |  |  |  |  | 1900-01-01 00:00:00
Thursday |  |  |  |  |  |  | 1900-01-01 00:00:00
Friday |  |  |  |  |  |  | 1900-01-01 00:00:00
Saturday |  |  |  |  |  |  | 1900-01-01 00:00:00
Sunday |  |  |  |  |  |  | 1900-01-01 00:00:00
Weekly Total |  |  |  |  |  |  | 06:35:00
 | Week Beginning 11-21-2011
Spreadsheet: 37540d1235581319-conditional-formatting-comparing-data-in-pivot-table-pivot_table
Sheet: DATA

PRODUCT FAMILY | PRODUCT | STOCK | SALES
FRUIT | APPLE | 100 | 150
FRUIT | BANANA | 200 | 10
FRUIT | ORANGE | 50 | 7
MISC | MILK | 10 | 28
MISC | VODKA | 500 | 50
VEGETABLE | CARROT | 30 | 2
VEGETABLE | ONION | 30 | 15
VEGETABLE | PATATO | 30 | 20
Spreadsheet: 751406d1634087351-find-average-of-multiple-sums-omitting-blank-cells-example
Sheet: Sheet1

Project | Dec Impact | [NAME] | Jan Impact | Jan Effort
a | 2 | 5 | 2 | 5
b | 3 | 4 | 3 | 4
c | 1 | 2 | 1 | 2
d | 5 | 2 | 5 | 2
e | 4 | 3 | 4 | 3
f | 2 | 2 | 2 | 2
g | 3 | 1 | 3 | 1
h
i
j
 | Dec Average | ? | Jan Average | ?