tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 154225d1336323642-geting-data-from-a-table-on-a-seperate-sheet-copy-of-invoice2
Sheet: Invoice

 |  |  |  |  |  |  |  |  |  |  |  | INVOICE
[NAME] |  |  |  |  |  |  |  |  |  |  |  | INVOICE #[100]
 |  |  |  |  |  |  |  |  |  |  | DATE:
680 Pittsburgh Rd,
Uniontown, PA 15401
Phone [PHONE]
Fax [PHONE]
TO | [Company Name]
 | [Street Address]
 | [City, ST ZIP Code]
 | Customer ID [ABC12345]
SALESPERSON |  | JOB |  | SHIPPING METHOD |  | SHIPPING TERMS |  | DELIVERY DATE |  | PAYMENT TERMS |  | DUE DATE
 |  |  |  |  |  |  |  |  |  | Due on receipt
QTY | ITEM NUMBER |  | [NAME] |  |  |  |  |  | UNIT PRICE |  | DISCOUNT | LINE TOTAL
1 | e123456789011
 |  |  |  |  |  |  |  | TOTAL DISCOUNT
 |  |  |  |  |  |  |  |  |  |  | SUBTOTAL
 |  |  |  |  |  |  |  |  |  |  | SALES TAX
 |  |  |  |  |  |  |  |  |  |  | TOTAL
Spreadsheet: 45209d1243978684-sum-up-feed-and-get-information-on-where-it-came-from-feed-question
Sheet: Ark1

 | Date | 2010-01-24 00:00:00
 | Week and year
 | Cage number | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | Feed type | polar artic | polar [NAME] | polar artic | pluss 300 | N/A | winter maxi |  | polar [NAME] | pluss 300
 | [NAME] | 200 |  | 1487 | 8397 | N/A | 9875 |  | 8745 | 5457
 | total (calculation)
 | Brand | KG | From cage
 | Polar artic
 | polar [NAME]
 | pliss 300
 | winter maxi
 |  | NOTE:  the array of where the different feeds occur will change by input (date).
Spreadsheet: 94035d1293820348-getting-the-monthly-sums-back-to-the-monthly-wss-sums-back-to-the-monthly-wss
Sheet: JANUARY

 | JANUARY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRESENCES | ABSENCES COUNTED AS PRESENCE |  |  |  |  |  | TOTAL
 | Name | Entry date | Leaving date | 2010-01-01 00:00:00 | 2010-01-02 00:00:00 | 2010-01-03 00:00:00 | 2010-01-04 00:00:00 | 2010-01-05 00:00:00 | 2010-01-06 00:00:00 | 2010-01-07 00:00:00 | 2010-01-08 00:00:00 | 2010-01-09 00:00:00 | 2010-01-10 00:00:00 | 2010-01-11 00:00:00 | 2010-01-12 00:00:00 | 2010-01-13 00:00:00 | 2010-01-14 00:00:00 | 2010-01-15 00:00:00 | 2010-01-16 00:00:00 | 2010-01-17 00:00:00 | 2010-01-18 00:00:00 | 2010-01-19 00:00:00 | 2010-01-20 00:00:00 | 2010-01-21 00:00:00 | 2010-01-22 00:00:00 | 2010-01-23 00:00:00 | 2010-01-24 00:00:00 | 2010-01-25 00:00:00 | 2010-01-26 00:00:00 | 2010-01-27 00:00:00 | 2010-01-28 00:00:00 | 2010-01-29 00:00:00 | 2010-01-30 00:00:00 | 2010-01-31 00:00:00 |  | W | V | C | H | F | R
1 | P1 | 2009-10-31 00:00:00 |  | W | W | W |  | V | V | V | V | V | V | V |  |  |  |  | W | W |  |  |  |  |  | W |  |  |  |  |  |  | W |  | 17 | 6.5 | 7 |  |  |  |  | 30.5
2 | P2 | 2009-06-16 00:00:00 | 2010-10-12 00:00:00 | W | W | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H
3 | P3 | 2008-11-24 00:00:00 |  | W | W | W |  |  |  |  |  | W | W |  |  |  |  |  | W | W |  |  |  |  |  | W |  |  |  |  |  |  | W
4 | P4 | 2009-06-05 00:00:00 |  | W | W | W |  |  |  |  |  | W | W |  |  |  |  |  | W | W |  |  |  |  |  | W |  |  |  |  |  |  | W
5 | P5 | 2007-05-12 00:00:00 | 2010-11-04 00:00:00 | W | W | W |  |  |  |  |  |  |  |  |  |  |  |  |  | W |  |  |  |  |  |  | W
6 | P6 | 2006-01-18 00:00:00 | 2010-03-03 00:00:00 | W | W | W |  |  |  |  |  |  |  |  |  |  |  |  | W | W |  |  |  |  |  | W | W
7 | P7 | 2009-03-23 00:00:00 | 2010-03-03 00:00:00 | W | W | W |  |  |  |  |  | W | W |  |  |  |  |  | W | W |  |  |  |  |  | W | W |  |  |  |  |  | W
8 | P8 | 2009-05-19 00:00:00 | 2010-04-20 00:00:00 | W | W | W |  |  |  |  |  | W | W |  |  |  |  |  | W |  |  |  |  |  |  | W
9 | P9 | 2010-03-03 00:00:00
10 | P10 | 2010-03-03 00:00:00
11 | P11 | 2010-04-22 00:00:00
12 | P12 | 2010-10-22 00:00:00
13 | P13 | 2010-11-23 00:00:00
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
 | F: [NAME], V: Vacances, C: Clinique, U: Fugue, R: Réintégration |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17 | 6.5 | 7 | 0 |  | 0 | 0 | 30.5 | 30.5
Spreadsheet: larry_campbell__21098__Jim Ward
Sheet: J. Ward

# | Category | Finding | Action Item | Responsible Person | Target Date | [NAME] | Completion Date | Comments
 | PSM
48 | GMP | No log sheet available to show bed status. | Assure that operations logs are developed to capture the air dryers bed in service/regeneration status. | [NAME] | 2001-03-31 00:00:00 | [NAME]
65 | Operating Procedures | No Dehydrator outlet moisture records on file. | Assure that dehydrators outlet moisture readings are checked routinely, and placed in MP2 or [NAME] for tracking. | [NAME] | 2001-03-31 00:00:00 | [NAME]
120 | GMP | Start/ stop instructions missing from remote control panels. | Insure that start/stop instructions are installed at all heater remote start-up panels. | [NAME] | 2001-03-31 00:00:00 | [NAME]
Spreadsheet: 50374d1249773544-excel-2007-solved-custom-sort-data-show-conditional-data-aug-7-ideal
Sheet: data

2009-08-07  09:30 | [NAME] | 290° 50' 24''
2009-08-07  09:30 | Neptune Altitude | -40° 44' 53''
2009-08-07  09:32 | Mercury Altitude | 30° 00' 49''
2009-08-07  09:33 | Sun Altitude | 50° 02' 03''
2009-08-07  09:34 | [NAME] | 190° 37' 16''
2009-08-07  09:37 | [NAME] | 120° 05' 17''
2009-08-07  09:37 | [NAME] | 100° 09' 06''
2009-08-07  09:39 | Mars Altitude | 60° 55' 54''
2009-08-07  09:40 | Saturn Altitude | 20° 08' 45''
2009-08-07  09:42 | Uranus [NAME] | 280° 07' 15''
2009-08-07  09:45 | Pluto Azimuth | 30° 26' 07''
2009-08-07  09:49 | [NAME] | 200° 17' 09''
2009-08-07  09:49 | Mars Azimuth | 240° 19' 02''
2009-08-07  09:54 | Mercury Azimuth | 110° 03' 44''
2009-08-07  10:04 | Jupiter [NAME] | 300° 12' 30''
2009-08-07  10:06 | [NAME] | 210° 19' 55''
2009-08-07  10:06 | Pluto Altitude | -60° 53' 36''
ETC | ETC | ETC
Or any other type of list
similar to this one.
Spreadsheet: 841000d1693246715-create-a-sum-in-a-cell-based-off-of-the-contents-of-another-workbooks-cells-project-tracker
Sheet: China

 | 2023 SR - CHINA |  | Desktop |  | IR-3D Cams |  | Monitors |  |  |  | Laptop |  | Dock's | Servers | iPhone |  | iPad Pro |  | Thin Client | Multiport |  | TOTALS |  | %
 |  |  | SFF | MFF | DELL | Brio | 22" | 24" | 27" | 32" | 5440 | 7440 | WD22TB4 | Dell | v13 | v14 | 11" | 12.9" | HP T460 | Adapters
 | H/W TOTALS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | H/W ORDERED
 | H/W RECEIVED
 | H/W REMAINING
 | H/W DEPLOYED
Spreadsheet: 221439d1363552669-stock-report-help-me-to-rectify-the-error-stock-report
Sheet: 1

Item Code | Item Description | UOM | Sales | Closing Stock
129 |  |  | 10
126 |  |  | 20
101 |  |  | 30
124 |  |  | 40
101 |  |  | 10
110 |  |  | 10
120 |  |  | 10
124 |  |  | 10
125 |  |  | 10
126 |  |  | 10
127
101 |  |  | 20
Spreadsheet: 147075d1332514232-recognise-and-count-specific-words-count-vehicles
Sheet: Sheet1

NO: | E/R | NAME | VEHICLE | REG NO | STK NO
1 | USED | JONES | FIESTA | LY10YPA | 98374
2 | USED | SMITH | MONDEO | LV09DHE | 32435
3 | USED | HOLDEN | FOCUS | LM09LKM | 23425
4 | USED | HUMPHREY | TRANSIT | EY61JYO | 32456
5 | USED | TAYLOR | CONNECT | AD10CMV | 24356
 |  | USED CAR
 |  | COMMERCIAL | 2
 |  | TOTAL
Spreadsheet: 162104d1339722238-having-a-row-of-information-show-if-using-a-dropdown-list-of-names-jpsprack_list-template_14jun12_01
Sheet: Teacher List

Teacher List |  | this sheet has been configured to show you only people who are "teacher"
Name | Position | Salary | Hours per week
[NAME]
Spreadsheet: eac29288-4a49-49d6-b9cb-21a35ad0e497
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
HAPT | Test | HAPT | Haptoglobin, Serum | Haptoglobin, S | Nephelometry | Serum Gel Tube: SGT |  |  | 1 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 1 mL | 0.5 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | 30-200 mg/dL | Monday through Saturday; 3 p.m. | 1 day | 2 days | 1 | 83010 |  |  |  |  | Rochester
HAPT | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
HAPT | Result | HAPT | Haptoglobin, S | Haptoglobin, S | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 46127-7 | Haptoglobin:MCnc:Pt:Ser/Plas:Qn:Nephelometry
Spreadsheet: 73091d1273749843-comparing-two-sheets-on-one-spreadsheet-and-populating-with-figures-iserror
Sheet: FullList

a | Not Available
b | Available
c | Available
d | Not Available
e | Available
f | Not Available
g | Not Available
h | Not Available
i | Not Available
j | Not Available
k | Not Available
l | Not Available
m | Available
n | Not Available
o | Not Available
p | Not Available
q | Not Available
r | Available
s | Not Available
t | Not Available
u | Not Available
v | Available
w | Available
x | Available
y | Not Available
z | Not Available
Spreadsheet: 110118d1306883826-avg-last-11-rows-of-data-avg_last_11_rows
Sheet: Sheet1

Month | Parameter1 | Parameter2
2009-11-01 00:00:00 | 0.0616 | 0.02213822894168466
2009-12-01 00:00:00 | 0.0307 | 0.01930693069306931
2010-01-01 00:00:00 | 0.0299 | 0.02065527065527065
2010-02-01 00:00:00 | 0.0359 | 0.009603072983354673
2010-03-01 00:00:00 | 0.0391 | 0.01534919416730622
2010-04-01 00:00:00 | 0.0347 | 0.0091
2010-05-01 00:00:00 | 0.032 | 0.0157
2010-06-01 00:00:00 | 0.0332 | 0.0011
2010-07-01 00:00:00 | 0.0174 | 0.0158
2010-08-01 00:00:00 | 0.006 | 0.0165
2010-09-01 00:00:00 | 0.0109 | 0.0109
2010-10-01 00:00:00 | 0.0051 | 0.0082
2010-11-01 00:00:00 | 0.0047 | 0.0035
2010-12-01 00:00:00 | 0.0076 | 0.0103
2011-01-01 00:00:00 | 0.007 | 0.0059
2011-02-01 00:00:00 | 0.0067 | 0.0111
Avg
Spreadsheet: 888541d1739057980-update-needed-to-formula-to-only-show-data-for-month-example
Sheet: YTD Results

 | Note: Rep names must be entered in exactly as they are shown in the survey report. Enter the supervisor name in the green boxes.
 | Claim Rep | Number of Promoters | Number of Detractors | Total Survey Count | Overall Score
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 |  |  |  | Team Score
 | Raymi [NAME]
 | [NAME]
 | Ricardo Herrera
 | [NAME]
 | [NAME]
 | [NAME]
 |  |  |  | Team Score
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 |  |  |  | Team Score
 | [NAME]
 | [NAME]
 | Alexis Jaimes
 | [NAME]
 | Alexis Jaimes
 |  |  |  | Team Score
 | Sup 5
 |  |  |  | Team Score
 | Sup 6
 |  |  |  | DRG Score
 |  |  |  | Updated 11.15.24
Spreadsheet: 116784d1312169796-match-index-data-replace-demo
Sheet: 4-1

 |  | 氏名 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 |  | Mr A
 |  | Mr B
 |  | Mr C
 |  | Mr D
 |  | Mr E
 |  | Mr F
 |  | Mr G
 |  | Mr H
 |  | Mr I
 |  | Mr J
G | Day
D | Night1
E | Night2
Q | Late
H | D.off
Spreadsheet: 94726d1294452980-excel-2007-search-2-columns-for-matching-surname-surname-search
Sheet: Sheet1

 | [NAME] |  | [NAME]
 | A smith |  | r Marcianno
 | A D Smith |  | H G wells
 | Mr A Smith |  | [NAME] |  | I need to highlight surnames in column D that are matched from B and D
 | [NAME] |  | G Bristol |  | First names and letters are ignored therefore [NAME] would still be highlighted
 | A Wellington |  | W W Well |  | even though it isn't in column B but the surname matches as would A G Smith.
 | AD wellington |  | B Bridgewater
 | Lord Wellington |  | J S Bach |  | I can't search using surname and first initial of other name as Mr A Smith would be [NAME] (no such person)
 | C Clay |  | A G Smith |  | So a conditional highlight of matching surnames would be sufficient.
 | Cassius Clay
 | [NAME] |  |  |  | The spelling in the surnames is usually good but the use of capitals is sometimes missing.
 | Rocky marcianno
 | r Wells |  |  |  | To put in a nutshell....search cell, column D, by looking at text from right to left until 'space'
 | G Clayton |  |  |  | then match same from column B
 |  |  |  |  | These columns can go on for several hundred names especially B
Spreadsheet: 78162d1278581208-creating-unique-lists-unique-lists-extended
Sheet: Sheet1

TUTOR NAMES & ASSIGNED NUMBERS
Tutor Name | Tutor Number | Tutor Name (No Duplicates)
G S | 1 | C R
G S | 2 | G S
G S | 3 | G S
G S | 4 | J P
G S | 5 | L G
G S | 6 | M D
G S | 7 | M K
C R | 8 | P D
C R | 9 | P H
G S | 10 | S C
G S | 11 | S T
G S | 12 | S W
G S | 13 | W A
G S
J P
J P
J P
G S
J P
J P
J P
J P
J P
J P
J P
J P
J P
J P
J P
J P
J P
J P
J P
J P
J P
L G
M K
M K
P H
P H
P H
P H
P H
P H
S C
S C
S C
S C
S C
S C
S C
S C
S C
S C
S C
S C
S C
S C
S C
S C
S C
S C
S C
S C
S C
S C
S C
S C
S C
S C
S C
S W
S W
S W
S W
S W
S T
S T
S T
S W
S W
S W
S W
S W
S W
S W
S W
S W
S W
S W
S W
S W
S W
S W
S W
W A
W A
W A
W A
W A
W A
W A
W A
W A
W A
W A
W A
W A
W A
W A
0
A B
A L
B E
B E
B E
B E
B E
B E
B E
B E
B E
B E
B E
B E
B E
B E
B E
B E
B E
B E
B E
B E
B E
B E
C I
C M
C K
C R
C R
C R
C R
C R
C R
G S
G S
G S
G S
G S
G S
G S
G S
G S
G S
G S
G S
G S
G S
G S
G S
G S
G S
J P
J P
J P
J P
J P
J P
J P
J P
J P
J P
J P
J P
J P
J P
J P
J P
J P
J P
J P
J P
J P
J P
J P
J P
J P
J P
J P
J P
J P
J P
J P
J P
J P
J P
J P
J P
J P
L G
L G
L G
L G
L G
L G
L G
L G
L G
L G
L G
L G
L G
L G
L G
L G
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M K
M D
P D
P H
P H
P H
P H
P H
P H
P H
S C
S C
S C
S C
S C
S C
S C
S C
S C
S C
S C
S C
S C
S C
S C
S C
S C
S C
S C
S C
S C
S C
S C
S C
S W
S T
S T
S T
S T
S W
S W
S W
S W
S W
S W
S W
S W
S W
S W
S W
S W
S W
S W
S W
S W
S W
S W
S W
S W
S W
S W
S W
S W
S W
S W
S W
S W
S W
S W
S W
S W
S W
S W
S W
S W
S W
S W
S W
S W
S W
S W
W A
W A
W A
W A
W A
W A
W A
W A
W A
W A
W A
0
0
0
0
0
0
J P
J P
J P
J P
J P
J P
W A
W A
W A
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Spreadsheet: darrell_schoolcraft__7825__imbalsumm0109
Sheet: Calpine

 | Calpine So. Point Power Del
 | 78113
Day | Measured | Scheduled
1 | -78239 | -85300
2 | -74222 | -85101
3 | -78756 | -71658
4 | -82484 | -65890
5 | -72415 | -62441
6 | -77980 | -71332
7 | -76345 | -81863
8 | -78285 | -81938
9 | -79383 | -81100
10 | -80612 | -80889
11 | -77113 | -79550
12 | -80716 | -81880
13 | -53012 | -47231
14 | -39548 | -46164
15 | -38282 | -40001
16 | -40863 | -40001
17 | -78929 | -77228
18 | -80798 | -79981
19 | -81778 | -81389
20 | -71744 | -69426
21 | -68034 | -68428
22 | -79946 | -78325
23 | -80642 | -83734
24
25
26
27
28
29
30
31
2001-08-31 00:00:00 |  |  | 81685.1
2001-09-23 00:00:00
CBS Volume
 |  |  | 130492
Spreadsheet: 884044d1732950020-distirbution-of-target-budget-as-per-the-existing-pattern-distribution-as-per-target-budget
Sheet: Sheet1

CURRENT DISTRIBUTION |  |  |  |  |  |  |  |  |  |  |  |  | REQUIRED DISTRIBUTION CASE1 |  |  |  |  |  |  |  |  |  | REQUIRED DISTRIBUTION CASE2
GROUP | Start | Finish | Month | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 |  | Month | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 |  | Month | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00
A | 2024-01-01 00:00:00 | 2024-05-01 00:00:00 |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  | 1 | 1 | 1 | 1
A | 2024-03-01 00:00:00 | 2024-08-01 00:00:00 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  | 1 | 1 | 1 | 1
A | 2024-02-01 00:00:00 | 2024-06-01 00:00:00 |  |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1
B | 2024-01-01 00:00:00 | 2024-05-01 00:00:00 |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1
B | 2024-03-01 00:00:00 | 2024-08-01 00:00:00 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  | 1 | 1 | 1 | 1 | 1
B | 2024-02-01 00:00:00 | 2024-06-01 00:00:00 |  |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1
B | 2024-01-01 00:00:00 | 2024-06-01 00:00:00 |  | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1
C | 2024-01-01 00:00:00 | 2024-05-01 00:00:00 |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  | 1 | 1 | 1 | 1
C | 2024-03-01 00:00:00 | 2024-08-01 00:00:00 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  | 1 | 1 | 1 | 1
C | 2024-02-01 00:00:00 | 2024-06-01 00:00:00 |  |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  | 1 | 1 | 1 | 1
C | 2024-01-01 00:00:00 | 2024-06-01 00:00:00 |  | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  | 1 | 1 | 1 | 1
C | 2024-03-01 00:00:00 | 2024-08-01 00:00:00 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1
 |  |  | Current Total |  |  |  |  |  |  |  |  |  | Target |  |  |  |  |  |  |  |  |  | Target | AVERAGE/P
A
B
C
Spreadsheet: thomas_martin__39860__Texas - Trading
Sheet: Texas - Trading AA

 | Texas - Trading
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % | 2002
 |  | YTD Actual |  | Forecast |  | of Total | Plan
ENACOMP | Compensation |  |  |  |  |  | 0 | Compensation | 0
 | Special Pays |  |  | 0 |  |  | 0
 | Analyst & Associates |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME] | ASSOCIATE | ENA NG TEXAS REGION G&A
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  | Other |  |  |  |  | [NAME], [NAME] | ASSOCIATE | ENA NG TEXAS REGION G&A
ENAEMPEX | Employee Expense |  |  |  |  |  | 20000 |  |  |  |  |  | Martin, Thomas A | VICE PRESIDENT | ENA NG TEXAS REGION G&A
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  | 14000 | Total |  |  |  |  | Schwieger, [NAME] | VICE PRESIDENT | ENA NG TEXAS REGION G&A
ENAOUTSV | Outside Services |  |  |  |  |  | 10000 |  |  |  |  |  | [NAME], [NAME] R | MANAGER | ENW-ENERGY OPS TEXAS RISK MGMT
ENASUPP | Supplies Expense |  |  |  |  |  | 8000
ENAMKTEX | Marketing |  |  |  |  |  |  | Intern | 33000
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME] | 48400 | 0
ENARENT | Rent |  |  |  |  |  |  | Staff | 49500 | 0
ENATECH | Technology |  |  |  |  |  |  | Specialist | 57750 | 0
ENATRANS | Transportation |  |  |  |  |  |  | Sr. Specialist | 71500 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  | 2400 | Analyst | 60500 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  | 0 | Associate | 89100 | 2
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager | 110000 | 0
 |  |  |  |  |  |  |  | Director | 143000 | 0
 | Headcount |  |  |  |  |  |  | Sr. Director | 165000 | 0
 |  |  |  |  |  |  |  | VP | 198000 | 0
 | A&A Headcount |  |  |  |  |  |  | MD | 220000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 254512
 |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 777076d1650123502-pull-data-from-multiple-sheets-floor-stock-sheets-template
Sheet: ICU 2003100

ICU 2003100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Service Units
Item | Price | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu
Lemon Lime- Soda | 0.25
Diet Lemon Lime- Soda | 0.25
Cola- Soda | 0.25
Diet Cola- Soda | 0.25
Coke | 0.9
Dr Pepper bottle | 1
Gatorade | 1.5
Hydrolyte Honey Water | 0.32
Hydrolyte Honey tea | 0.37
Hydrolyte Nectar Water | 0.32
Hydrolyte Nectar Tea | 0.35
Crackers, [NAME] | 0.08
[NAME] ea | 0.05
Broth, [NAME] | 0.1
[NAME] | 0.71
Cherrios | 0.39
Pudding-Vanilla | 0.27
Diet Vanilla Pudding | 0.35
[NAME] | 0.28
[NAME] | 0.28
[NAME] | 1.13
Applesauce | 0.32
Juice Orange | 0.23
Juice Cranberry | 0.23
Juice Apple | 0.23
Ice Cream-Vanilla | 0.41
Ice Cream- Diet-Vanilla | 0.43
Popsicles | 0.14
[NAME] | 0.35
Milk- Skim | 0.25
2% Milk | 0.25
Coffee, Liquid | 43.26
Coffee, [NAME]. cs. | 95.11
Coffee, Decaf Prepack Bags. cs. | 37.84
Tea Bags | 0.03
[NAME] | 1.47
Creamer, non dairy box | 0.03
Coffee Filters | 0.02
[NAME] | 0.16
Lemon Juice | 0.04
Sweetner-Splenda | 0.3
Sweetner-Equal | 0.03
Sweetner-Sweet N Low | 0.02
Sugar | 0.02
Salt/Pepper | 0.02
Plastic Ware (fork,spoon knife) | 0.03
Ensure | 0.14
Glucerna | 0.4
Jevity | 0.35
Nepro | 1.03
[NAME] | 15.6
Osmolite | 0.25
Perative | 1.39
Promote | 0.37
Pivot | 2.81
Pulmocare | 0.44
Vital | 3.05
2Cal HN | 0.4
[NAME] | 1.5
cups | 0.05
Refrigerator Thermometer (reg.)
[NAME] | 1.75
[NAME] | 0.11
[NAME] | 0.11
Monthly Coffee
Monthly Total
Spreadsheet: phillip_m_love__30161__9901_OA
Sheet: BGC_GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  Boston Gas
 |  |  | Total |  | Reclasses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance |  |  |  |  |  |  |  | 0
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL