tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 673398d1587365649-help-with-nested-if-formula-on-a-date-range-example_1
Sheet: Sheet1

 |  |  |  |  |  |  | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00
 |  |  |  |  |  |  | 2020-01-31 00:00:00 | 2020-02-29 00:00:00 | 2020-03-31 00:00:00 | 2020-04-30 00:00:00 | 2020-05-31 00:00:00 | 2020-06-30 00:00:00 | 2020-07-31 00:00:00 | 2020-08-31 00:00:00 | 2020-09-30 00:00:00 | 2020-10-31 00:00:00 | 2020-11-30 00:00:00 | 2020-12-31 00:00:00 | 2021-01-31 00:00:00 | 2021-02-28 00:00:00 | 2021-03-31 00:00:00 | 2021-04-30 00:00:00 | 2021-05-31 00:00:00 | 2021-06-30 00:00:00 | 2021-07-31 00:00:00 | 2021-08-31 00:00:00 | 2021-09-30 00:00:00 | 2021-10-31 00:00:00 | 2021-11-30 00:00:00 | 2021-12-31 00:00:00 | 2022-01-31 00:00:00 | 2022-02-28 00:00:00 | 2022-03-31 00:00:00 | 2022-04-30 00:00:00 | 2022-05-31 00:00:00 | 2022-06-30 00:00:00 | 2022-07-31 00:00:00 | 2022-08-31 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 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00
 | Event Intervals | 30 | months
 | Next Maintenance Event | cycle #2 | cycle #3
Car 1 | 2022-12-01 00:00:00 |  |  |  |  |  | =if date of maintenance falls within this period, "1" else "0"
Car 2 | 2023-01-15 00:00:00
Car 3 | 2021-07-23 00:00:00
Spreadsheet: b20aca74-95d2-4fca-b5fa-757bf6f67307
Sheet: Sheet1

2013 NEREC  Regional Speech Entries:  May 23, 2013  2:00 -5:00 p.m.  Lifelong Learning Center, Norfolk | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 | Entries due to [EMAIL] by May 9
Note:  Each county may enter three (3) presenters in PSA and speech categories for each age division.
First Name | Last Name | County | Title of Speech/PSA | PSA or Speech | Division | Address | Town | Zip Code | [NAME] | Phone | Time Requests | Payment
Spreadsheet: sally_beck__33712__Metrics 0623
Sheet: Coal

E N R O N   N O R T H   A M E R I C A - H O T  L I S T  M E T R I C S |  |  |  |  |  |  |  |  |  |  |  |  | Team: | Coal Origination & Finance
Results based on Activity through June 23, 2000 |  |  |  |  |  |  |  |  |  |  |  |  | Week | 12
 |  | Weekly Summary - 2Q00 through 1Q01
 |  | # of Transactions
 |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13
 |  | 2000-04-07 00:00:00 | 2000-04-14 00:00:00 | 2000-04-21 00:00:00 | 2000-04-28 00:00:00 | 2000-05-05 00:00:00 | 2000-05-12 00:00:00 | 2000-05-19 00:00:00 | 2000-05-26 00:00:00 | 2000-06-02 00:00:00 | 2000-06-09 00:00:00 | 2000-06-16 00:00:00 | 2000-06-23 00:00:00 | 2000-06-30 00:00:00
Postings Rollforward:
Beginning |  | 0
+ Entrances |  | 4 | 10 | 1 | 3 | 3 | 0 | 1 | 0 | 0 | 2 | 6 | 0
- Exits |  | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 5 | 0
- Executions |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Ending
Postings Rollforward:
Beginning
+ Entrances
- Exits
+/- [NAME]
- Executions
Ending
Average Deal Size
 |  |  |  |  |  |  |  | Forward Quarters
 | Actual |  |  | Current Quarter |  | Per |  |  |  |  |  |  |  | Total Year
 | 1Q00 |  |  | 2Q00 |  | Hot List |  | 3Q00 |  |  | 4Q00 |  |  | 2000 |  |  | 1Q01
 | # | $ |  | # | $ |  |  | # | $ |  | # | $ |  | # | $ |  | # | $
Executions | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  |  |  |  | 0 | 0
DPR/MPR |  | -1.1 |  |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0
Postings | 0 | 0 |  | 5 | 4 |  |  | 10 | 45 |  | 5 | 25 |  |  |  |  | 2 | 10
Identified Margin
Budget |  | 12.7
$ Coverage
$ millions
Spreadsheet: 884711d1733951970-tabs-that-feed-on-specific-tab-tracking-correios_2
Sheet: Q1

Q1
Qual a loja que esta enviando?
UIP | 198 | 0.08104789193614409
UCK | 84 | 0.03438395415472779
UIG | 387 | 0.1584117887842816
U7A | 285 | 0.1166598444535407
U7M | 50 | 0.02046663937781416
UJM | 259 | 0.1060171919770774
URZ | 1 | 0.0004093327875562833
UBZ | 3 | 0.00122799836266885
UBX | 416 | 0.1702824396234138
UGF | 127 | 0.05198526401964797
URJ | 28 | 0.01146131805157593
URK | 462 | 0.1891117478510029
U7C | 143 | 0.05853458862054851
Total | 2443
Significar | 7.05
[NAME]. | 3.97
Variação | 15.72
Spreadsheet: 829398d1684185390-need-to-return-a-value-if-all-instances-are-a-but-if-there-is-one-b-in-the-data-return-b-stockstatustest
Sheet: Raw Data

Root | Item | Description | Value ($) | SO# | Stock Status
 | 000001A | Project 1 | 100 | 100123 | InStock |  | Item | Root: 000001
 | 000001B | Project 1 | 150 | 100124 | SoldOut |  | 000001A | Sub-SKU: 000001A, 000001B, 000001C
 | 000001C | Project 1 | 125 | 100125 | SoldOut
 | 000002A | Project 2 | 117 | 100126 | PreOrder
 | 000002B | Project 2 | 132 | 100127 | SoldOut
 | 000003A | Project 3 | 165 | 100128 | InStock
 | 000003B | Project 3 | 984 | 100129 | PreOrder
 | 000004A | Project 4 | 153 | 100130 | SoldOut
 | 000004B | Project 4 | 665 | 100140 | SoldOut
 | 000004C | Project 4 | 135 | 100150 | SoldOut
Spreadsheet: 38258d1236359436-pull-info-from-1-worksheet-into-another-not-a-one-to-one-relationship-index-match-info
Sheet: MasterSPRList

SPR ID | Category | OverallProj
7497 | Rpt | SHOES
7499 | Maint | MAINT
7777 | Adm | ADM
9999 | PTO | PTO
11373 | CCM | COACH
12487 | Discoverer | GENERAL
13545 | CCM | COACH
13604 | RFP | BH
14901 | Supt-ESG | BH
14905 | Supt-ESG | BH
14906 | Supt-ESG | BH
14909 | Supt-ESG | BH
14913 | Supt-ESG | BH
16402 | Smart | SURVEY
16883 | Rpt-BH | BH
16915 | Training | GENERAL
Spreadsheet: james_steffes__12823__SDGE Contract Request
Sheet: Sheet1

CustomerName
Acterna Inc
Airport
Alaris Medical Systems, Inc.
Alessio Investment Company, a California Limited Partnership
AMCC
Apricorn, Inc.
APTA Group, Inc.
[NAME]
[NAME]
Bartell Hotels
Belmont Laundry
Boneys Market
[NAME]
Burlington Coat Factory Warehouse Corporation
Carltas Company
Carltas Company
Chicago Pizza & Brewery, Inc.
Chugai Pharma U.S.A., Inc.
Crocket & Company, Inc.
Deutsch ECD
Dimension One Spas, Inc.
Discovery Child Center
Distinctive Plastics Inc.
Drew Motor Ford
[NAME]
Encad
Endevco
Exec One Assoc LP
Falmat
Gen-Probe Incorporated
[NAME]
Graphite Design International, Inc.
[NAME]
[NAME]
Harbor Packaging, Inc.
[NAME]
Henrys Market
[NAME]
Hyatt Corporation
Immune Response Corporation, The (Inc).
Intuit, Inc.
[NAME] In the Box
Kaiser Foundation Hospitals
Ketema
[NAME]
LA Fitness
La Jolla Country Club, Inc.
La Jolla Pharmaceutical
Lees Aquarium
Leiserv Premier Lane
Ligand Pharmacy
Los Mares
[NAME]
Mailing Concepts
Major Market Inc.
[NAME]
[NAME] Auto
McGraw Broadcast Co.
Midwest TV
Mission Valley Resort, L.P.
[NAME]
North County Ford, Inc.
North County Powder Coating
Nypro Inc
O.L.S. San Diego LLC
Oglebay Norton Industrial Sands, Inc.
Olympic Resort
Pacific Bell
Physicians Medical Building
PIC I
Plastics Engineering and Development, Inc.
Polese Company, Inc.
Poway Chevrolet
Poway Honda
Puja Restaurant
Quality Buick
Quality Chevrolet
Quality Craft, Inc.
Quality Suites
[NAME]
Radyne Comstream, Inc.
Rancho Bernardo Partners Ltd.
[NAME]
Romona
[NAME]
Safeway Inc.
San Diego CC
San Diego Harbor Island
[NAME], LLC
South Coast Newspaper, Inc.
Spectrum Floral Services
Starwood Hotels & Resorts Worldwide, Inc.
Stein Mart, Inc.
Sysco
[NAME]
The Limited
Tipton Enterprises
Toppan Electronics
Toro Ag
Toys R Us
TRICON
Triple Tree
Via-Sat
[NAME]
White Sands of La Jolla
Spreadsheet: 89887d1289622252-help-building-a-simulation-based-on-probability-one11-monte-carlo-simulation-of-game
Sheet: Parameters

Average games played per day | 3 | Minimum games per day | 0 | Maximum games per day | 6
Probability | Probability Breakpoint | Result | [NAME]
0.05 | 0 | Loss | 70
0.35 |  | Fast Win | 16
0.6 |  | Win | 100
 |  | Win | 100
 | First win bonus |  | 150
Spreadsheet: 208419d1358820747-autopopulate-data-depending-on-the-selection-from-the-dropdown-list-monthly-data
Sheet: Sheet1

Properties | January | February | March | April | May | June | July | August | September | October | November | December | YTD
Property 1 | 1234 | 3434 | 2323 | 9898 | 1234 | 3434 | 2323 | 9898 | 1234 | 3434 | 2323 | 9898
Property 2 | 123 | 454 | 4343 | 545 | 123 | 454 | 4343 | 545 | 123 | 454 | 4343 | 545
Property 3 | 454 | 656 | 5454 | 5454 | 454 | 656 | 5454 | 5454 | 454 | 656 | 5454 | 5454
Property 4 | 676 | 655 | 65 | 5454 | 676 | 655 | 65 | 5454 | 676 | 655 | 65 | 5454
Property 5 | 878 | 7676 | 232 | 545 | 878 | 7676 | 232 | 545 | 878 | 7676 | 232 | 545
Property 6 | 7676 | 76 | 32 | 32443 | 7676 | 76 | 32 | 32443 | 7676 | 76 | 32 | 32443
Property 7 | 4545 | 878 | 232 | 43 | 4545 | 878 | 232 | 43 | 4545 | 878 | 232 | 43
Property 8 | 545 | 657 | 232 | 34 | 545 | 657 | 232 | 34 | 545 | 657 | 232 | 34
Property 9 | 3434 | 898 | 325 | 54343 | 3434 | 898 | 325 | 54343 | 3434 | 898 | 325 | 54343
Property 10 | 5656 | 23 | 232 | 434 | 5656 | 23 | 232 | 434 | 5656 | 23 | 232 | 434
Property 11 | 676 | 4343 | 657 | 343 | 676 | 4343 | 657 | 343 | 676 | 4343 | 657 | 343
Property 12 | 767 | 2323 | 8787 | 4334 | 767 | 2323 | 8787 | 4334 | 767 | 2323 | 8787 | 4334
Spreadsheet: chris_stokley__3964__ContactList
Sheet: Sheet1

Power Contact List
Name | KPMG Number (713-319x) | Mobile
[NAME] | x2459 | [PHONE]
[NAME] | x2082 | [PHONE]
[NAME] | x2073 | [PHONE]
[NAME] | x2826 | [PHONE]
[NAME] | x2839
[NAME] | x2009
[NAME] | x2913 | [PHONE]
[NAME] | [NAME] | [PHONE]
[NAME] |  | [PHONE]
[NAME]
37th Conference Room | 39067
Spreadsheet: 1cb030b1-c745-48e0-ad3b-ff1b88108498
Sheet: Sheet1

Field Experience | ECH- 6 | 4-8 | 8-12 | All Level | Total
Fall 2012 | 194 (66%) | 5 (2%) | 68 (23%) | 25 (9%) | 292
Spring 2013 | 145 (63%) | 12 (5%) | 58 (25%) | 17 (7%) | 232
Fall 2013 | 161 (65%) | 16 (7%) | 57 (23%) | 12 (5%) | 246
Total | 500 (65%) | 33 (4%) | 183 (24%) | 54 (7%) | 770
Student Teaching | ECH- 6 | 4-8 | 8-12 | All Level | Total
Fall 2012 | 34 (55%) | 5 (8%) | 12 (19%) | 11 (18%) | 62
Spring 2013 | 56 (57%) | 7 (7%) | 27 (28%) | 8 (8%) | 98
Fall 2013 | 30 (51%) | 2 (3%) | 23 (39%) | 4 (7%) | 59
Total | 120 (55%) | 14 (6%) | 62 (28%) | 23 (11%) | 219
Student Teaching | ECH- 6 | 4-8 | 8-12 | All Level | Total
Spring 2014 (before grades) | 62 (51%) | 11 (10%) | 38 (31%) | 10 (8%) | 121
Spreadsheet: 681606d1591658195-how-to-extract-cells-between-start-and-end-dates-sample-1-
Sheet: Sheet1

Deliv.Dt | Time | Del.T | Item | Order | Desp.Dt. | Order Date | Quantity | Out.Qty. | Cust.  Adr
2020-03-23 00:00:00 | 0 | 0 | [NAME] | 7000295998 | 2020-03-12 00:00:00 | 2020-03-23 00:00:00 | 200 | 200 | 092C34  04
2020-03-23 00:00:00 | 0 | 0 | 7598T0050 | 7000296000 | 2020-03-12 00:00:00 | 2020-03-23 00:00:00 | 200 | 200 | 092C34  04
2020-03-23 00:00:00 | 0 | 0 | 7599P0010 | 7000295994 | 2020-03-12 00:00:00 | 2020-03-23 00:00:00 | 200 | 200 | 092C34  04
2020-04-20 00:00:00 | 0 | 0 | 7991T0050 | 7000296992 | 2020-04-17 00:00:00 | 2020-04-09 00:00:00 | 70 | 70 | 092C34  01
2020-04-20 00:00:00 | 0 | 0 | 7996T0050 | 7000297031 | 2020-04-17 00:00:00 | 2020-04-09 00:00:00 | 70 | 70 | 092C34  01
2020-03-31 00:00:00 | 0 | 0 | 7997TA050 | 7000297032 | 2020-04-19 00:00:00 | 2020-04-01 00:00:00 | 70 | 70 | 092C34  01
2020-03-31 00:00:00 | 0 | 0 | 7997TB050 | 7000297033 | 2020-04-19 00:00:00 | 2020-04-01 00:00:00 | 70 | 70 | 092C34  01
2020-04-21 00:00:00 | 0 | 0 | 8043S0010 | 7000287321 | 2020-04-20 00:00:00 | 2020-04-09 00:00:00 | 7 | 7 | 092C34  01
2020-04-21 00:00:00 | 0.0006944444444444445 | 0 | 8043S0010 | X | 2020-04-20 00:00:00 | 2020-04-09 00:00:00 | 40 | 40 | 092C34  01
2020-05-04 00:00:00 | 0.0006944444444444445 | 0 | 8043S0010 | X | 2020-05-01 00:00:00 | 2020-04-09 00:00:00 | 60 | 60 | 092C34  01
2020-04-17 00:00:00 | 0 | 0 | 8046S0010 | 7000287320 | 2020-04-16 00:00:00 | 2020-04-09 00:00:00 | 12 | 12 | 092C34  01
Spreadsheet: sara_shackleton__36452__ISDA Master Swap Agreement Sheet
Sheet: Collateral Threshold

Marubeni Corporation |  | S&P/Moody's |  |  | Enron Corp.
 |  | (higher of)
5000000 |  | Baa1 |  |  | 10000000
4000000 |  | Baa2 |  |  | 10000000
3000000 |  | Baa3 |  |  | 10000000
1500000 |  | Ba1 |  |  | 7000000
1000000 |  | Ba2 |  |  | 5000000
0 |  | Ba3 or lower |  |  | 0
Spreadsheet: eric_saibi__9708__010402R
Sheet: Mojave 02

Owner Name |  | Southern California Edison Company
Station Name |  | Mojave Power Station
Unit Name |  | Mojave 02
NERC Region |  | WSCC
State |  | CA
Fuel Type |  | Coal
Capacity |  | 818 MW
Start Date |  | 2001-12-29 00:00:00
End Date |  | 2002-01-05 00:00:00
Prv. Start Date |  | 2001-12-29 00:00:00
Prv. End Date |  | 2002-01-04 00:00:00
Comments |  | [NAME] leak
SIC |  | 4911
Plant ID |  | 1015381
Unit ID |  | 1006330
Outage ID |  | 19326
Spreadsheet: 219187d1362679444-automatically-updating-multiple-sheets-to-a-master-sheet-master-test
Sheet: 4.

Test |  |  |  |  |  |  | Target |  | Actual |  |  |  |  | 2011 |  |  |  |  |  |  |  |  |  |  |  | 2012 |  |  |  |  |  |  |  |  |  |  |  | 2013 |  |  |  |  |  |  |  |  |  |  |  | 2014
Activity | Core | Stream | Task | Milestone | Accountable | External | Start | End | Actual | Actual End Date | Status | Funding | Notes/Location | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
4 | Main Title
4.1 | Title
4.1
4.2 | Title
4.2
4.2
4.2
4.2
4.1
4.2
4.2
4.2
4.2
4.2
4.2
4.2
4.2
4.3 | Title
4.3
4.3
4.3
4.3
4.3
4.4 | Title
4.4
4.4
4.5 | Title
4.5
4.5
4.5
4.5
4.6 | Title
4.6
4.6
4.6
4.6
4.7 | Title
4.7
4.7
4.8 | Title
4.8
4.8
4.8
4.8
4.8
4.8
4.8
4.8
Spreadsheet: lynn_blair__24414__NNGWKednotes
Sheet: July 28 & 29, 2001

NNG WEEKEND NOTES
For cc Mail distribution:  [NAME], [NAME], [NAME], S. January, [NAME], [NAME], [NAME], TMS OnCall
SATURDAY |  |  | 2001-07-28 00:00:00
Mail distribution send to the above listing on Sunday evening.
H:\DATA\Process Guidelines\[NNGWKednotes Template.xls]Dec 25 & 26
 | PROCESS |  |  |  | COMMENTS:
 | Gas Day: | SAT |  |  | [NAME]
 | 7:00 A.M. Non-grid: |  |  |  | Process completed late 10:02am, due to
 |  |  |  |  | system problems.
 | Gas Day: | FRI |  |  | [NAME]
 | 8:00 AM Final Storage |  |  |  | Mid American fuel not taken on storage nom.  [NAME] scheduled 2 contracts.
 |  |  |  |  | Connections between servers - problem noted when UCU & USES' noms
 |  |  |  |  | failed to show up at HUB.  Final Process Delayed until resolved.  Completed 11:00 a.m.
 | Gas Day: | SAT |  |  | [NAME]
 | 10:00 A.M. Intraday 1: |  |  |  | Extended nominations deadline to 10:30, due to technical problems
 |  |  |  |  | with the system on the Non Grid AM cycle.
 | Gas Day: | SAT |  |  | No problems with process. Storage was allocated.
 | 5:00 P.M. Intraday 2: |  |  |  | [NAME]
 | Gas Day: | SUN |  |  | [NAME]
 | 11:30 A.M. Timely
 |  |  |  |  | No Problems with Process.
 | Gas Day: | SUN |  |  | [NAME]
 | 6:00 P.M. Evening |  |  |  | No Problems with Process
 | Other Comments:
 | On Call Reps. |  |  |  | [NAME] |  | 6:30 - 3:30
 |  |  |  |  | [NAME] |  | 6:30 - 3:30
 |  |  |  |  | [NAME] |  | 1:00 - 10:00
 |  |  |  |  | [NAME] |  | 1:00 - 10:00
SUNDAY
 | PROCESS |  |  |  | COMMENTS:
 | Gas Day: | SUN |  |  | [NAME]
 | 7:00 A.M. Non-grid: |  |  |  | No Problems
 | Gas Day: | SAT |  |  | [NAME]
 | 8:00 AM Final Storage
 |  |  |  |  | No Problems with Process.  Storage was allocated.  Process completed
 |  |  |  |  | 9:35 a.m.
 | Gas Day: | SUN |  |  | [NAME]
 | 10:00 A.M. Intraday 1: |  |  |  | No Problems with Process.
 | Gas Day: | SUN |  |  | No problems with process.
 | 5:00 P.M. Intraday 2: |  |  |  | [NAME]
 | Gas Day: | MON |  |  | No problems with process.
 | 11:30 A.M. Timely |  |  |  | [NAME]
 | Gas Day: | MON |  |  | C Greaney
 | 6:00 P.M. Evening |  |  |  | No Problems with Process
 | Other Comments:
 | On Call Reps: |  |  |  | [NAME] |  | 6:30 - 3:30
 |  |  |  |  | [NAME] |  | 6:30 - 3:30
 |  |  |  |  | [NAME] |  | 1:00 - 10:00
 |  |  |  |  | [NAME] |  | 1:00 - 10:00
Spreadsheet: phillip_m_love__30143__9911_OA
Sheet: EAST-EGM-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 100793061 | 290821152
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 34376354 | 87323206
4 |  | Option Premiums | 0 | -481
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 135169415 | 378143877
 | Purchases:
6 |  | 3rd Party / Inter Enron | -103607089 | -308993742.9766267
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -30814363 | -78054921
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 152027 | 362607
 | Total Purchases: |  | -134269425 | -386686056.9766267
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 | Imbalances:
13 |  | In Kind | -3098 | -75353
14 |  | Cash Out | 830902 | 2045437
15 |  | Cash In | -844605 | -2079004
16 |  | Synthetic Storage | 501387 | 5752
 | Total Imbalances: |  | 484586 | -103168
 | Storage:
17 |  | Injection (Sales to Stg) | 0 | 0
18 |  | W/D (Purchase from Stg) | 243284 | 744449
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | 243284 | 744449
 | Total Storage: |  | 243284 | 744449
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | -1567860 | -4684753.508366235
 |  |  | 0 | 0
23 | Fuel: |  | -152027 | -362607
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -402213
25 |  | Demand | 0 | -490388
 | Total Transport Expense: |  | 0 | -892601
 | Transport Revenue:
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | -82527
 | Total Transport Revenue: |  | 0 | -82527
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense | 0 | 42944
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 42944
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance | 0 | 15355188.2963
31 |  | Prior Month Book Balance | 0 | -6851832
 |  | Total MTM Income | 0 | 8503356.296300001
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 5094995
34 |  | Originations | 0 | 14426
35 |  | Broker Fees | 0 | -15665
36 |  | Asset Group Demand Charges | 0 | -36809
37 |  | [NAME] | 0 | 23732.85
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | -20325
 |  | TOTAL INTRA-MTH
FT-East
 |  | Current Month MTM | 0 | 580000 | 0 | 0 |  |  | 0 | 0
 |  | Financial Liquidations | 0 | 0 | 0 | 0 |  |  | 0 | 0
 |  | Originations | 0 | 0 | 0 | 0 |  |  | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: tracy_geaccone__40271__AEL 06 01
Sheet: Income State. - YTD

Azurix Europe Ltd
Statement of Income
YTD June 2001
(US GAAP & USD thousands)
Average exchange rate used |  |  | 1.4397 |  | 1.439 |  |  |  | 1.429
 |  |  | YTD
 |  |  | Actuals |  | Forecast |  | [NAME] |  | Budget |  | [NAME]
Revenues:
 | WWSL Potable Water |  | 56250 |  | 55381 |  |  |  | 55168
 | WWSL Sewage |  | 120618 |  | 120843 |  |  |  | 118580
 | WWSL Unregulated |  | 8890 |  | 8775 |  |  |  | 7611
 | Swiss Combi |  | 7282 |  | 6806 |  |  |  | 7708
 | Wessex Water Enterprises |  | 5341 |  | 5620 |  |  |  | 5267
Net operating revenues
Operating and maintenance expenses:
 | Personnel |  | 11333 |  | 11243 |  |  |  | 10140
 | Power |  | 6701 |  | 6772 |  |  |  | 6921
 | Chemicals and materials |  | 1940 |  | 2297 |  |  |  | 2932
 | Equipment costs |  | 2003 |  | 1904 |  |  |  | 1729
 | Abstraction/Discharge fees |  | 3620 |  | 3548 |  |  |  | 3354
 | Transportation |  | 3310 |  | 3065 |  |  |  | 3225
 | Rent and rates |  | 7342 |  | 7299 |  |  |  | 7065
 | Other operations costs |  | 7140 |  | 6814 |  |  |  | 6302
 | WWSL Unregulated |  | 3685 |  | 3197 |  |  |  | 3208
 | Swiss Combi |  | 8399 |  | 8088 |  |  |  | 8215
 | Wessex Water Enterprises |  | 5645 |  | 5852 |  |  |  | 4819
Total O&M expense
General and administrative expense
 | Billing and customer services |  | 8441 |  | 8475 |  |  |  | 8977
 | Other overhead departments |  | 6543 |  | 6556 |  |  |  | 6046
 | Azurix Corp share options |  | 768 |  | 768 |  |  |  | 0
Total G&A expense
EBITDA
Depreciation and amort. expense |  |  | 39719 |  | 39035 |  |  |  | 38309
Goodwill amortization expense |  |  | 9568 |  | 9695 |  |  |  | 9574
Total D&A expense
Equity in (gain)/loss of unconsolidated affiliates
Interest income - affiliates (list separately) |  |  | -5022 |  | -5002 |  |  |  | -4830
Interest income - 3rd party |  |  | -3134 |  | -3344 |  |  |  | -4401
Interest expense, gross - affiliates (list separately) |  |  | 3282 |  | 3268 |  |  |  | 3172
Interest expense, gross - 3rd parties |  |  | 34301 |  | 35551 |  |  |  | 38841
Amort. & W/O, deferred financing costs |  |  | 676 |  | 707 |  |  |  | 857
(Capitalized interest) |  |  | -2208 |  | -2409 |  |  |  | -3572
Dividend Income
(Gain)/loss on disposition of assets
Currency transaction (gain)/loss
Total other (income)/expense
Income tax expense, current |  |  | 4952 |  | 4377 |  |  |  | 1001
Income tax expense, deferred |  |  | 11215 |  | 11725 |  |  |  | 15003
Total income tax expense
Minority Interest
Net Income
Spreadsheet: 166101d1341471684-i-want-to-be-able-to-apply-the-filters-to-my-count-examplefile
Sheet: CRM

Status | Group | Area | Industry | Contact | Telefonnr | Note | [NAME] | Follow up | Customer no |  |  | <-- I would like this filtering bar here (copied from customer sheet), so that I can get the results on statuses (and other criterias) for just my selected customers. It doesn't need to have this look, but this functionality
Statuses
Go
Hold
Done
Some other criteria
C1 | x
C2 | x
[NAME] | x
Spreadsheet: 704951d1605815172-summing-ytd-and-last-12-months-sample
Sheet: Sheet1

2020-10-31 00:00:00 |  |  |  |  |  | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2018 | 2018 | 2018
 |  |  |  |  |  | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 12 | 11 | 10
CY Month | PY Month | CY TTM | PY TTM | CY YTD | PY YTD | 10-2020 | 9-2020 | 8-2020 | 7-2020 | 6-2020 | 5-2020 | 4-2020 | 3-2020 | 2-2020 | 1-2020 | 12-2019 | 11-2019 | 10-2019 | 9-2019 | 8-2019 | 7-2019 | 6-2019 | 5-2019 | 4-2019 | 3-2019 | 2-2019 | 1-2019 | 12-2018 | 11-2018 | 10-2018
 |  |  |  |  |  | 3131 | 3030 | 3131 | 3131 | 3030 | 3131 | 3030 | 3131 | 2929 | 3131 | 3131 | 3030 | 3131 | 3030 | 3131 | 3131 | 3030 | 3131 | 3030 | 3131 | 2828 | 3131 | 3131 | 3030 | 3131