tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 692634d1598470513-formula-to-evaluate-two-criteria-and-pull-data-if-both-met-scheduling-dummy-file
Sheet: Employee Roster

ID # | First Name | Last Name | Phone | [NAME] | [NAME] | Schedule Notes | Birthday | Favorite Treat |  | Rank | Repeats | Rank + 1 |  | Rank | First Name
1 | Crystal | Smith |  |  |  |  |  |  |  |  |  |  |  | 1
2 | Apiya | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 2
3 | Braden | Trent |  |  |  |  |  |  |  |  |  |  |  | 3
4 | Chinh | Parish |  |  |  |  |  |  |  |  |  |  |  | 4
5 | Deb | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 5
6 | HK2 |  |  |  |  |  |  |  |  |  |  |  |  | 6
7 | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 7
8 | Maria | Hupf |  |  |  |  |  |  |  |  |  |  |  | 8
9 | [NAME] | White |  |  |  |  |  |  |  |  |  |  |  | 9
10 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 10
11 | Penelope | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 11
12 | [NAME] | Curtis |  |  |  |  |  |  |  |  |  |  |  | 12
13 | [NAME] | Saunders |  |  |  |  |  |  |  |  |  |  |  | 13
14 | [NAME] | Curry |  |  |  |  |  |  |  |  |  |  |  | 14
15 | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 15
16 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 16
17 | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 17
18 | [NAME] | Wall |  |  |  |  |  |  |  |  |  |  |  | 18
19 | Timothy |  |  |  |  |  |  |  |  |  |  |  |  | 19
20 | Lauren | Free |  |  |  |  |  |  |  |  |  |  |  | 20
21 | [NAME] | Bichler |  |  |  |  |  |  |  |  |  |  |  | 21
22 | Babs | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 22
23 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 23
24 | [NAME] | Smith |  |  |  |  |  |  |  |  |  |  |  | 24
25 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 25
26 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 26
27 | Deb | Buell |  |  |  |  |  |  |  |  |  |  |  | 27
28 | [NAME] | Pena |  |  |  |  |  |  |  |  |  |  |  | 28
29 | [NAME] | Curtis |  |  |  |  |  |  |  |  |  |  |  | 29
30 | Jessica | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 30
 |  | MAXIMUM OF 30 EMPLOYEES ends at row 91
 | Notes: | 15 year old servers must be indicated by an (*) after their name. Example: Barrett* AM   [NAME]* PM
 |  | MAXIMUM OF 30 EMPLOYEES ends at row 91
Spreadsheet: andy_zipper__187__DYNEGY-ICE VOL May18
Sheet: ICE-ENA

Enron North America
Activity on ICE
UOM | Deals | Volume
MMBtus
bbl
 |  |  |  |  |  |  | START | END
Enron North America Corp.
Commodity Type:  All
Instruments:  All
Trade Dates:  May-18-01 thru May-18-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
May-18-01 | 209419618 |  | Bought | NG Fin BS, LD1 for IF | CNG-SP | Nov01-Mar02 | Nov-01-01 | Mar-31-02 |  |  |  | Aquila Risk Management Corp. | 0.465 | USD / MMBtu | 15000 | Daily | 2265000 | MMBtus | Mckay, B
May-18-01 | 123636004 |  | Bought | NG [NAME], FP | [NAME] (NY) | Next Day Gas | May-19-01 | May-21-01 |  |  |  | Aquila Energy Marketing Corp | 4.47 | USD / MMBtu | 10000 | Daily | 30000 | MMBtus | Pimenov, V
May-18-01 | 464045490 |  | Sold | NG [NAME], ID, GDD | TET M3 | Next Day Gas | May-19-01 | May-21-01 |  |  |  | Mirant Americas Energy Marketing, LP | 0 | USD / MMBtu | 10000 | Daily | 30000 | MMBtus | Pimenov, V
May-18-01 | 210728057 |  | Sold | NG Fin, FP for LD1 | [NAME] | Cal 03 | Jan-01-03 | Dec-31-03 |  |  |  | AEP Energy Services, Inc. | 4.18 | USD / MMBtu | 5000 | Daily | 1825000 | MMBtus | [NAME], J
May-18-01 | 104117654 |  | Sold | NG Fin BS, LD1 for IF | ANR-SW | [NAME] | Jun-01-01 | Oct-31-01 |  |  |  | Reliant Energy Services, Inc. | -0.115 | USD / MMBtu | 10000 | Daily | 1530000 | MMBtus | [NAME], G
May-18-01 | 170453224 |  | Sold | Heating Oil Crack | HO/WTI 1st line swap | Q4 01 | Oct-01-01 | Dec-31-01 |  |  |  | J. Aron & Company | 6.2 | USD / bbl | 25000 | Monthly | 75000 | bbl | Gagliardi, L
May-18-01 | 120744183 |  | Sold | NG Fin BS, LD1 for IF | Panhandle | [NAME] | Jun-01-01 | Oct-31-01 |  |  |  | BP Amoco Corporation | -0.115 | USD / MMBtu | 5000 | Daily | 765000 | MMBtus | [NAME], G
May-18-01  Deals
Spreadsheet: 859586d1707920757-formula-on-color-coding-color-coding
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | RED | ORANGE | YELLOW | GREEN | BLUE | INDIGO | VIOLET
 |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 1 | 0 | 1 | 0 | 1
65
66
67
68 |  |  |  |  |  |  |  |  |  |  |  | RED |  | ORANGE
69 |  |  |  |  |  |  |  |  |  |  |  | YELLOW |  | GREEN
70 |  |  |  |  |  |  |  |  |  |  |  | BLUE |  | INDIGO
71 |  |  |  |  |  |  |  |  |  |  |  | VIOLET
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
Spreadsheet: mary_hain__25860__final_lr
Sheet: Sheet1

 | FY2002 | FY2003 | FY2004 | FY2005 | FY2006 | 5-yr Avg
PA-may
PA-dec
Slice | 2000 | 2000 | 2000 | 2000 | 2000
IOU
DSI-may
DSI-dec | 46 | 46 | 46 | 46 | 46
DSI-tac | 450 | 450 | 450 | 450 | 450
[NAME]
dec add'n
DSI-tac
w/o IOU
w/ IOU |  |  |  |  |  |  |  |  | ip
 |  |  |  |  |  |  |  |  | pf | 19.26
Augm to-Aug 1 | 820.8333333333334 | 845.8333333333334 | 770.8333333333334 | 866.3333333333334 | 662.8333333333334
Augm to-date
remaining
w/o IOU
w/ IOU
$ in base rate | 322.218 | 336.766 | 289.159 | 323.744 | 306.07
[NAME]
already purchased | 242.9 | 242.9 | 242.9 | 242.9 | 242.9
[NAME]
Mkt Price | 90 | 80 | 70 | 60 | 50
mkt MW in base
remaining on mkt
w/o IOU
w/ IOU
Spreadsheet: 108678d1305694383-trying-to-get-a-weighted-monthly-figure-for-staff-attrition-fte-calculations-mod
Sheet: Movements

 |  |  |  |  |  |  | Month End
Month | Name | Date Effective | End Date | FTE | FTE Impact | Weighted FTE in one calc | Adjusted Effective date | Adjusted End Date | Days Worked | Day Weighting | Weighted FTE
2011-03-01 00:00:00 | Name 1 | 2011-03-14 00:00:00 | 2011-09-09 00:00:00 | 1 | -1
2011-03-01 00:00:00 | Name 2 | 2011-03-28 00:00:00 | 2011-04-29 00:00:00 | 1 | -1
2011-03-01 00:00:00 | Name 3 | 2011-03-04 00:00:00 | 2012-03-15 00:00:00 | 1 | -1
2011-03-01 00:00:00 | Name 4 | 2011-02-07 00:00:00 | 2011-03-11 00:00:00 | 1 | -1
2011-03-01 00:00:00 | Name 5 | 2011-03-05 00:00:00 | n/a | 0.5 | -0.5
2011-03-01 00:00:00 | Name 6 | 2011-03-02 00:00:00 | n/a | 1 | -1
2011-03-01 00:00:00 | Name 7 | 2011-03-05 00:00:00 | 2011-03-07 00:00:00 | 1 | -1
2011-03-01 00:00:00 | Name 8 | 2011-03-29 00:00:00 | n/a | 1 | -1
2011-03-01 00:00:00 | Name 9 | 2011-03-02 00:00:00 | n/a | 1 | -0.4
2011-03-01 00:00:00 | Name 10 | 2011-03-28 00:00:00 | n/a | 1 | -1
2011-03-01 00:00:00 | Name 11 | 2011-03-21 00:00:00 | 2012-09-21 00:00:00 | 1 | -1
2011-03-01 00:00:00 | Name 12 | 2011-03-21 00:00:00 | n/a | 1 | -1
2011-03-01 00:00:00 | Name 13 | 2011-03-28 00:00:00 | n/a | 0.4 | -0.4
2011-03-22 00:00:00 | Name 14 | 2011-03-28 00:00:00 | n/a | 1 | -1
2011-03-22 00:00:00 | Name 15 | 2011-03-30 00:00:00 | n/a | 1 | -1
Issues:
Columns A-F are entered by our WFM team and must remain as they are as they are used for other purposes
Column in yellow is an attempt to display the weighted FTE (full time equivalent staff) that we lost throughout the month
i.e. if an agent leaves at the end of the month, it has much less weighting than an agent who leaves at the beginning of the month because we are down 1 person for a shorter period of just 1 day
Calculation in yellow works fine if the 'Effective' date is within the month listed in colunm A, and if the 'End' date is an actual date that is not in the same month as column A
I am running into problems trying to:
- get a calculation that converts the 'effective' date to the first day of month if it is in a previous month
- get a calculation that converts the 'end' date to the last day of month if it is in same month but a subsequent year (e.g. I6)
- check for errors in calculation caused by 'n/a' and replace these with last day of month
I HAVE PROVIDED A FORMULA FOR THE MONTH END DATE AT CELL (I1)
Spreadsheet: 141181d1329143426-extracting-unique-values-from-a-column-without-zeros-or-n-a-reworkinventory-withdrawal-stripped
Sheet: Totals

 | Rework Totals by Department
 | DEPARTMENT
 | Column1 | HAND | SAW | CNC | ENG | FAB | BNDL | SPECIAL | TOTALS
TYPE OF ERROR | Machining/Drilling | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Cutting Error | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Damaged in [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Engineering | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Defective Material | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Too Short for Production | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | TOTALS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Rework Totals by Part #
 | 050001  CLR
 | 050001  MIL
 | 050013ESWHT
 | 050001  UC
 | #N/A
 | #N/A
 | #N/A
Spreadsheet: 472629d1469689043-vlookup-based-on-a-criteria-account-client-wise
Sheet: MoMo

NO. | IMEI | STATUS | CLIENT | PRICE | CLIENT PAID BY | CLIENT PAID ME | PAID DATE | REMARKS
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
 | TOTAL
 | TOTAL IMEIS DONE
 | BALANCE PAYABLE AS AT
Spreadsheet: 708750d1608007779-combine-data-feom-2-rows-in-2-comlumns-into-one-row-and-column-d-and-p
Sheet: Mar

name | bol date | am/pm | d/p |  |  | total
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7
kate | 2020-03-02 00:00:00 | am | d
kitty | 2020-03-06 00:00:00 | pm | d
mary | 2020-03-15 00:00:00 | am | p |  |  | 29
 |  |  |  |  | Total
Spreadsheet: andy_zipper__767__10_24_01ON
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | NG X1 | 265 | 19 | 20 | 121.4 | 127.8 | 20.76 | 2001-10-24 10:55:00
 | NG Z1 | 285 | 51.5 | 53 | 74.6 | 76.8 | 13.56 | 2001-10-24 10:55:00
 | NG F2 | 305 | 73 | 76 | 73 | 76 | 14.29 | 2001-10-24 10:55:00
 | NG G2 | 305 | 83 | 87 | 67.5 | 70.8 | 13.26 | 2001-10-24 10:55:00
 | NG H2 | 300 | 84 | 88 | 61.4 | 64.3 | 11.85 | 2001-10-24 10:55:00
 | NG J2 | 295 | 73 | 76 | 49.1 | 51.1 | 9.29 | 2001-10-24 10:55:00
 | NG K2 | 295 | 74 | 78 | 45.6 | 48 | 8.68 | 2001-10-24 10:55:00
 | NG M2 | 300 | 80 | 83.5 | 44.8 | 46.7 | 8.63 | 2001-10-24 10:55:00
 | NG N2 | 305 | 87 | 92 | 45.2 | 47.8 | 8.92 | 2001-10-24 10:55:00
 | NG Q2 | 310 | 94 | 97 | 45.5 | 47 | 9.01 | 2001-10-24 10:55:00
 | NG U2 | 310 | 99 | 105 | 45.6 | 48.4 | 9.16 | 2001-10-24 10:55:00
 | NG V2 | 310 | 103 | 108 | 45.5 | 47.8 | 9.09 | 2001-10-24 10:55:00
 | [NAME] |  |  |  |  |  | 10.12 | 2001-10-18 10:52:00
 | NG H3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG M3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG U3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG Z3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG H4 |  |  |  |  |  |  | 2001-09-17 07:55:00
Spreadsheet: mary_fischer__25634__31Q
Sheet: E31.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY 31Q
RECONCILIATION OF STOCKHOLDERS' EQUITY AND INVESTMENT IN SUBS
FOR THE 6 MONTHS ENDED 6-30-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-31
 |  |  |  | 12-31-00 Balance |  |  |  | EQUITY IN |  | DIVIDENDS DECLARED |  |  |  | OTHER ACTIVITY
 |  |  |  | DR  (CR) |  | RECLASS 00 NI |  | EARNINGS |  |  |  |  |  |  |  |  |  | DR  (CR)
 |  | Hyp line |  | BEG BALANCE |  | TO BEG RE |  | /LOSSES |  | COMMON |  | PREFERRED |  | DR (CR) |  | (Describe) |  | END BALANCE
Shareholders Equity by Parent |  | Reverse signs from Hyperion
Common Stock |  | 0901 |  | -1100
Paid in Capital |  | 0910
Contribution Received from Parent |  | 0915 |  | -39325234
RE - Beg Bal |  | 0920 |  | -14050819 |  | 453 |  |  |  |  |  |  |  |  |  | C&E Entries
RE - Net Income |  | 0930 |  | 453
RE - Net Income (Fair Value Adjustment) |  | 0931
Dividends Decl - Preferred Stock |  | 0935
Dividends Decl - Common Stock |  | 0941
Invest in Subs Plug Account |  | 0942
Total Shareholders' Equity |  | TOT_SHARE_EQU
Net Income |  | NET_INCOME
PARENT'S CO #
Investment in Consol Sub (on Parent Books) |  |  |  | Same signs as Hyperion
Investment in CS |  | 0215
Investment in PIC (contrib by parent) |  | 0216
Investment in Equity earnings of sub |  | 0217
Total Investment in Consol Sub
Equity in Consol Sub |  | 1505
Difference between SE (on sub) and Invest (on parent)
Reasons for Differences
A schedule will need to be prepared for each subsidiary.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-31
Spreadsheet: a984cf02-7510-4d84-b18e-4f9086984606
Sheet: QTD Recon Q2FY12

ELECTRONIC ARTS INC. AND SUBSIDIARIES
Reconciliation of GAAP to Non-GAAP Unaudited Condensed Consolidated Statements of Operations
(in millions, except per share data)
 | Three Months Ended September 30, 2011
 | GAAP Results |  | Acquisition-related expenses |  | Amortization of Debt Discount |  | Change in Deferred Net Revenue (Packaged Goods and Digital Content) |  | Restructuring charges |  | Stock-Based Compensation |  | Income Tax Adjustments |  | Non-GAAP Results
Net revenue | 715 |  | 0 |  | 0 |  | 319 |  | 0 |  | 0 |  | 0 |  | 1034
Cost of goods sold | 432 |  | -8 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 424
Gross profit | 283 |  | 8 |  | 0 |  | 319 |  | 0 |  | 0 |  | 0 |  | 610
Operating expenses:
Marketing and sales | 222 |  | 0 |  | 0 |  | 0 |  | 0 |  | -6 |  | 0 |  | 216
General and administrative | 88 |  | 0 |  | 0 |  | 0 |  | 0 |  | -9 |  | 0 |  | 79
Research and development | 318 |  | 0 |  | 0 |  | 0 |  | 0 |  | -28 |  | 0 |  | 290
Acquisition-related contingent consideration | 17 |  | -17 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Amortization of intangibles | 13 |  | -13 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Restructuring charges | -1 |  | 0 |  | 0 |  | 0 |  | 1 |  | 0 |  | 0 |  | 0
Total operating expenses | 657 |  | -30 |  | 0 |  | 0 |  | 1 |  | -43 |  | 0 |  | 585
Operating income (loss) | -374 |  | 38 |  | 0 |  | 319 |  | -1 |  | 43 |  | 0 |  | 25
Interest and other income, net | -6 |  | 0 |  | 4 |  | 0 |  | 0 |  | 0 |  | 0 |  | -2
Income (loss) before provision for (benefit from) income taxes | -380 |  | 38 |  | 4 |  | 319 |  | -1 |  | 43 |  | 0 |  | 23
Provision for (benefit from) income taxes | -40 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 46 |  | 6
Net income (loss) | -340 |  | 38 |  | 4 |  | 319 |  | -1 |  | 43 |  | -46 |  | 17
Loss per share |  |  |  |  |  |  |  |  |  |  | Earnings per share
Basic and Diluted | -1.03 |  |  |  |  |  |  |  |  |  | Basic |  |  |  | 0.05
 |  |  |  |  |  |  |  |  |  |  | Diluted |  |  |  | 0.05
Number of shares used in computation |  |  |  |  |  |  |  |  |  |  | Number of shares used in computation
Basic and diluted | 331 |  |  |  |  |  |  |  |  |  | Basic |  |  |  | 331
 |  |  |  |  |  |  |  |  |  |  | Diluted |  |  |  | 337
Spreadsheet: 683967d1593083027-use-of-formula-e-g-countifs-to-count-without-counting-repeated-data-sample
Sheet: Sheet2

CUSTOMER | Contract Type | Status |  | Question:[NAME] to count Number of customers with contract C signed without counting repeat cases
CUST A | Contract A | Signed |  | Expected answer: 3
CUST A | Contract B | Recd
CUST A | Contract B | Signed
CUST A | Contract C | Late
CUST B | Contract A | Recd
CUST B | Contract C | Signed
CUST B | Contract C | Signed
CUST B | Contract A | Recd
CUST B | Contract B | Recd
CUST B | Contract B | Late
CUST C | Contract C | Signed
CUST C | Contract B | Late
CUST C | Contract A | Recd
CUST C | Contract A | Late
CUST C | Contract B | Late
CUST D | Contract C | Signed
CUST D | Contract A | Recd
CUST D | Contract B | Recd
CUST D | Contract A | Late
CUST D | Contract C | Signed
Spreadsheet: 139979d1328566619-if-function-nested-sample
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | FEE | USER
 | Price per calculator |  |  |  |  |  |  |  | 25000 | 1-10
 | No of users | 5 |  |  |  |  |  | additional | 1000 | 11-20
 | Total Price | [NAME] in here |  |  |  |  |  | additional | 750 | 21-40
 |  |  |  |  |  |  |  | additional | 500 | 40+
 | [NAME]:
 | [NAME]))))))
Spreadsheet: 747800d1631706097-pulling-percentage-values-between-sheets-and-identifying-name-fields-client-wise-division
Sheet: Clients

 | CLIENT 1
 | 1 |  | 0.5 |  | 1 |  | 1 |  | 1 |  | 0.5 |  | 1
 | RIMA |  | NAFIZ |  | MANAV |  | MAY |  | [NAME] |  | DIVYESH |  | RITA
 | 0.75 |  | 0.75 |  | 0.75 |  | 0.5 |  | 0.5 |  | 0.5 |  | 0.3
 | SHADIL |  | [NAME] |  | SABARI |  | TAHIR |  | [NAME] |  | GEOFF |  | SAVIO
 | 0.5 |  | 0.3 |  | 0.3
 | EMMA |  | [NAME] |  | ENRICO
 | CLIENT 2
 | 0.25 |  | 1 |  | 0.5 |  | 0.75 |  | 0.75 |  | 0.75 |  | 0.5
 | [NAME] |  | TINA |  | WAJD |  | ROMAIL |  | PRASHANT |  | SHAHRYAR |  | MAYSA
 | 0.25 |  | 0.25 |  | 1 |  | 0.3 |  | 0.15 |  | 0.25 |  | 0.2
 | ALI DARWICH |  | UDAY |  | SIMRAN |  | SHAHZEB |  | HUSAM |  | GEOFF |  | SABARI
 | CLIENT 2
 | 0.25 |  | 1 |  | 1 |  | 1 |  | 1
 | ADITI |  | ZAMAN |  | APRIL |  | PRIYAL |  | RAJIT
 | 1 |  | 0.2 |  | 0.2 |  | 0.1
 | SHAMIR |  | PRIYAA |  | SHAHRYAR |  | SABARI
Spreadsheet: 850950d1701254449-extracting-data-onto-new-sheet-test1-8-
Sheet: Group 2

Code | Name | Capacity | Total No. | [NAME].
AA | AA's | 10 | 5
AB | AB's | 11 | 3
BA | BA's | 13 | 4
BB | BB'S | 14 | 2
 |  | Totals
 | AA's | 10 | 5 | 50
AB | AB's | 11 | 3 | 33
BA | BA's | 13 | 4 | 52
BB | BB'S | 14 | 2 | 28
 |  | Totals | 14 | 163
Spreadsheet: 34064d1231179013-excel-2007-forcing-a-state-change-dvdjworkbook
Sheet: oddsSods

[NAME] on the |  | [NAME] |  | 27.5 | Colour(s) /
Telephone on the | 1 | [NAME] | P1 | 27.5 | Laser [NAME] | 1 x AA | Subject to artwork | 01
 | 2 | Hoa Lac | P2 | 27.5 |  | 1 x AA with insertion | Same artwork both sides | 02
 | 3 | [NAME] | P3 | 27.5 |  | 1 x AAA | Subject to artwork / same artwork both sides | 03
 | 4 |  | P4 | 27.5 |  | 1 x AAA with insertion |  | 04
 | 5 |  | P3L | 27.5 |  | 2 x AA |  | 05
 | 6 |  | P4L | 35 |  | 2 x AA with insertion |  | 06
 | 7 |  | M1 | 35 |  | 2 x AAA |  | 07
 | 8 |  | M2 | 35 |  | 2 x AAA with insertion |  | 08
 | 9 |  | M3 | 35 |  | 3 x AA |  | 09
 | 10 |  | M4 | 35 |  | 3 x AA with insertion |  | 10
 |  |  | M5 | 35 |  | 3 x AAA |  | 11
 |  |  | M6 | 35 |  | 3 x AAA with insertion |  | 13
 |  |  | M7 | 35 |  | 4 x AA |  | 14
 |  |  | M8 | 55 |  | 4 X AA with insertion |  | 24
 |  |  | [NAME] | 35 |  | 4 x AAA |  | 29
 |  |  | PG1 | 35 |  | 4 x AAA with insertion |  | 37
 |  |  | PG2 | 35 |  | 1 x AA + 1 x AAA |  | 44
 |  |  | L1 | 35 |  | 1 x AA + 1 x AAA with insertion |  | 48
 |  |  | L2 | 35 |  |  |  | 49
 |  |  | U1 | 35 |  |  |  | 77
 |  |  | U2 | 35 |  |  |  | 99
 |  |  | U3 | 35
 |  |  | U4 | 30
 |  |  | S1 | 30
 |  |  | S2 | 75
 |  |  | E1
Spreadsheet: 791918d1660659383-optomize-raw-material-pallet-beta_modded-hydr-
Sheet: OpenSolver_result

 |  | T | W | L
 |  | 16 | 75 | 845 | 16
 |  | 16 | 75 | 945 | 36
 |  | 16 | 75 | 1000 | 36
 |  | 16 | 75 | 1140 | 12
 |  | 16 | 75 | 1200 | 35
 |  | 16 | 75 | 2400 | 4
 |  | Stock L | 4800
 |  |  |  |  |  |  |  |  |  |  | waste | Bars | Tot waste
 |  |  |  |  | 2400 | 1200 | 1140 | 1000 | 945 | 845 | pr bar | used | from bars
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  | Total
 |  |  |  | Demand | 4 | 35 | 12 | 36 | 36 | 16
 |  |  | Excess production
 |  |  | Total excess = Tot waste + Excess production
Spreadsheet: tracy_geaccone__40255__C0366-111727
Sheet: Dept_100153

ENRON PROPERTY & SERVICES CORP
1400 Smith Street
Houston, Texas   77251 - 1188
MONTHLY INVOICE DETAIL
HOUSTON RECORD CTR - Dept. 100153
May, 2001
0366  EOC - Executive
Date | Ticket Number | Work Order | Service Name | Service Description | # [NAME] | Unit Cost | UOM | Service | Ticket
 |  |  |  |  |  |  |  | Total | Total
 |  |  | R/C 111727
2001-05-21 00:00:00 | 067667-8 |  | 05/01 Box Storage | RECORD STORAGE | 1 | 219.03 | /MNTH | 219.03
 |  |  |  |  |  |  | Ticket Total |  | 219.03
 |  |  |  |  |  |  | Total for R/C: 111727 |  | 219.03
 |  |  |  |  |  |  | Total for Dept_100153 |  | 219.03
Spreadsheet: andy_zipper__798__Broker & Exchange Detail 10-26-01 EM
Sheet: EXCHANGE DEAL SUMMARY

EnronOnline Exchange Detail for 10/26/2001
Completed Transactions:
TODAY
Date | 2001-10-26 00:00:00
Count
Exchange Party | Counterparty Name | Commodity | Total
True Quote LLC | PG&E Energy Trading-Gas Corporation | Natural Gas | 1
 | Conoco Inc. | Natural Gas | 2
True Quote LLC Total |  |  | 3
Grand Total |  |  | 3
LTD
Date | (All)
Count
Exchange Party | Counterparty Name | Commodity | Total
True Quote LLC | PG&E Energy Trading - Power, L.P. | US East Power | 80
 |  | US West Power | 25
 | Tucson Electric Power Company | US West Power | 2
 | Cinergy Marketing & Trading, LLC | Natural Gas | 2
 | Conectiv Energy Supply, Inc. | US East Power | 11
 |  | Natural Gas | 1
 | Tractebel Energy Marketing, Inc. | US East Power | 1
 |  | Natural Gas | 15
 | CMS Marketing, Services and Trading Company | US East Power | 1
 |  | Natural Gas | 3
 | Calpine Energy Services, L.P. | US East Power | 4
 |  | US West Power | 2
 |  | Natural Gas | 9
 | CLECO Marketing and Trading, LLC | Natural Gas | 1
 | PG&E Energy Trading-Gas Corporation | Natural Gas | 128
 | Axia Energy, LP | Natural Gas | 3
 | Entergy-Koch Trading, LP | Natural Gas | 10
 | Conoco Inc. | Natural Gas | 13
 | Richardson Energy Marketing, Ltd. | Natural Gas | 1
True Quote LLC Total |  |  | 312
Grand Total |  |  | 312