tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 839673d1692151240-excel-formula-to-exclude-columns-and-rows-with-zero-amounts-zero-amounts
Sheet: Sheet1

Kindly asking for excel formula to produce a report leaving out rows with zero amounts or empty as shown in the desired solution
CGT computation |  |  |  |  |  |  | Desired solution
Details | Rate | Reference | US$ | US$ |  |  | Details | Rate | Reference | US$ | US$
Gross Capital Amount |  | Section 8 (1)(a) |  | 700000 |  |  | Gross Capital Amount |  | Section 8 (1)(a) |  | 700000
Less: Recoupment |  | section 8 of the Taxes Act |  | -1350 |  |  | Less: Recoupment |  | section 8 of the Taxes Act |  | -1350
Capital Amount |  |  |  | 698650 |  |  | Capital Amount |  |  |  | 698650
Less:  Allowable deductions |  |  | 0 |  |  |  | Less:  Allowable deductions
Land | Cost | Section 11(2)(a) | 0 |  |  |  | Boundary wall | Cost | Section 11(2)(b) | 9000
Boundary wall | Cost | Section 11(2)(b) | 9000 |  |  |  | Capital Allowance | 0.025 | section 15(2)(c) of Taxes Act | -1350
Warehouse building | Cost | Section 11(2)(b) | 0 |  |  |  | Inflation Allowance | 0.025 | Section 39A 9(b) of the Finance Act | 1575
farm | Cost | Section 11(2)(b) | 0 |  |  |  | Total deductable |  |  |  | -9225
Capital Allowance | 0 | section 15(2)(c) of Taxes Act | 0 |  |  |  | Gain/loss before relief |  |  |  | 689425
Capital Allowance | 0.025 | section 15(2)(c) of Taxes Act | -1350 |  |  |  | Less: Assessed loss b/f |  | Section 11(3) |  | -5000
Capital Allowance | 0.025 | section 15(2)(c) of Taxes Act | 0 |  |  |  |  |  |  |  | 684425
Capital Allowance | 0 | section 15(2)(c) of Taxes Act | 0 |  |  |  | Capital Gain Tax | 0.2 |  |  | 136885
Inflation Allowance | 0.025 | Section 39A 9(b) of the Finance Act | 0
Inflation Allowance | 0.025 | Section 39A 9(b) of the Finance Act | 1575
Inflation Allowance | 0.025 | Section 39A 9(b) of the Finance Act | 0
Inflation Allowance | 0.025 | Section 39A 9(b) of the Finance Act | 0
Brokerage fees
Bad Debts |  | Section 11(2)(e)
Total deductable |  |  |  | -9225
Gain/loss before relief |  |  |  | 689425
Less: Rollover relief |  | Section 22
Less: Assessed loss b/f |  | Section 11(3) |  | -5000
 |  |  |  | 684425
Capital Gain Tax | 0.2 |  |  | 136885
Spreadsheet: 90bce6b0-89db-4281-b8dc-bbaabc4b18fe
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
BENW | Test | BENW | White Bean, IgE | White Bean, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
BENW | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
BENW | Result | BENW | White Bean, IgE | White Bean, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6279-4 | Bean white Ab.IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 872968d1719417222-use-vba-to-transfer-automatically-data-from-excel-file-1-to-excel-file-2-consolidation-2
Sheet: MANPOWER PLAN

FILE INDEX ORDER | PROJECT | OU | Colonne1 | IGG | Job Holder | HR4u # Position | Position | Validated in WPB 24 ? | Location | Métier | Mob Trigger | Months to / post trigger START DATE | =>Mob if NA | Planned Start Date | End Trigger | Months to / post trigger  END DATE | =>End if NA | Planned End Date | Reporting to #HR4U | Reporting to position | Staffing category | [NAME] | Position Count | Head Count | Full Time Eqvt | Comment | Change since last version
AGUP 001 | AGUP2 | OT/CL/OU/GPI-AGUP | CL | [NAME] | TEST x | 60087077 | Project Director |  | France | P-Projets | NA |  | 2021-07-01 00:00:00 | 2021-07-01 00:00:00 | NA |  | 2023-09-03 00:00:00 | 2023-09-03 00:00:00 |  | Director | [NAME] | TSO | 1 | 1 | 1 |  | No
Spreadsheet: 15a2aab2-a464-4d4f-a886-c4240380f46a
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42767492 | 2014-08-17 22:43:16 | AXIS | 0 | 5 | 6 | 1495910 | player1495910 | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
42767857 | 2014-08-17 23:01:26 | ALLIES | 1 | 6 | 3 | 1495910 | player1495910 | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
42777363 | 2014-08-18 16:50:04 | ALLIES | 1 | 6 | 1 | 206845 | [NAME] | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
42777520 | 2014-08-18 17:10:11 | AXIS | 0 | 5 | 6 | 206845 | [NAME] | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
42800383 | 2014-08-20 05:43:12 | AXIS | 1 | 5 | 3 | 1537209 | bynumbill | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
42814207 | 2014-08-21 05:53:35 | ALLIES | 0 | 2 | 6 | 1623012 | player1623012 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
42814299 | 2014-08-21 06:06:00 | AXIS | 0 | 5 | 6 | 1623012 | player1623012 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
42827728 | 2014-08-22 06:15:19 | ALLIES | 1 | 7 | 4 | 1503014 | Agent Avacado | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
42827983 | 2014-08-22 06:41:38 | AXIS | 0 | 5 | 7 | 1503014 | Agent Avacado | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
42840564 | 2014-08-23 04:43:16 | AXIS | 0 | 4 | 7 | 1503014 | Agent Avacado | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
42840861 | 2014-08-23 05:01:40 | ALLIES | 1 | 7 | 2 | 1503014 | Agent Avacado | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
42870866 | 2014-08-25 05:12:49 | AXIS | 1 | 7 | 2 | 1503014 | Agent Avacado | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
42871027 | 2014-08-25 05:37:18 | ALLIES | 0 | 3 | 7 | 1503014 | Agent Avacado | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
42889697 | 2014-08-26 15:19:45 | AXIS | 0 | 5 | 6 | 1624680 | [NAME] | 7664 | pacific | 1944-07-25 | 1944-07-25 | Japanese Counterattack | Contre-attaque japonaise
Spreadsheet: darrell_schoolcraft__7306__imball0201
Sheet: transcol

 | TransColorado
 | 500632
Day | Measured | Scheduled
1 | 106165 | 117417
2 | 117972 | 117437
3 | 124002 | 124207
4 | 100788 | 100788
5 | 104942 | 104207
6 | 104211 | 104207
7 | 84424 | 83518
8 | 77456 | 77234
9 | 89763 | 89032
10 | 93179 | 92822
11 | 100949 | 100822
12 | 93077 | 92822
13 | 93000 | 92822
14 | 92998 | 92822
15 | 93044 | 92822
16 | 85485 | 85001
17 | 94982 | 93956
18 | 83049 | 82542
19 | 84312 | 82822
20 | 85027 | 82822
21
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  | 12821
2002-01-20 00:00:00
CBS Volume
 |  |  | -49782
Spreadsheet: 875547d1722147676-calculating-per-diem-meals-on-multiple-variables-sallyd028-per-diems-example-aligw
Sheet: Per Diems

 | Example
 | Departure Date | Start Time |  | Return Date | End Time
 | 2024-07-30 00:00:00 | 07:01:00 |  | 2024-08-03 00:00:00 | 17:00:00 |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Breakfast | Lunch | Dinner
 |  |  |  |  |  |  |  |  |  | 2024-07-30 00:00:00 | 0 | 1 | 1
 | Number of Nights |  |  |  |  |  |  |  |  | 2024-07-31 00:00:00 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  | 2024-08-01 00:00:00 | 1 | 1 | 1
 | Meals entitlement - calculated from trip dates |  |  | Breakfast | Lunch | Dinner |  |  |  | 2024-08-02 00:00:00 | 1 | 1 | 1
 |  |  |  |  | 5 | 4 |  |  |  | 2024-08-03 00:00:00 | 1 | 1 | 0
 | Departure |  |  |  | Return
 | Meal | Before |  |  | Meal | After
 | Breakfast | 07:00:00 |  |  | Breakfast | 08:00:00
 | Lunch | 11:00:00 |  |  | Lunch | 14:00:00
 | Dinner | 17:00:00 |  |  | Dinner | 19:00:00
 | Question 1
 | How do I calculate the number of meals based on multiple variables:
 | 1 | Departure date and start time
 | 2 | Return date and end time
 | 3 | Departure before time for breakfast, lunch and dinner
 | 4 | Return after time for breakfast, lunch and dinner
 | Answer should populate the following:
 | 4 | in cell E14 Breakfast
 | 5 | in cell F14 Lunch
 | 4 | in cell E14 Dinner
 | Question 2
 | I want the time displayed as 24 hour time. But when you enter you must put the colon in. Is there any way to alter the way the time is entered to display as 24 hour time without having to put a colon in?
 | For example if I have formatted the cell to display 24 hour time:
 | But when I enter the time as "0700" without a colon
 | It will display like this 0:00
Spreadsheet: 174575d1345116736-transpose-of-3-rows-0a1-fotismetafora-dedomenon-1-
Sheet: Φύλλο1

Α/Α | Names | Monday | Tusday | Wednesday | Thursday | Friday | Saturday | Sunday |  | Α/Α | Order
1 | A | 1 | 2 | 3 | 4 | 5 | 6 | 7 |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21
1 | A | 8 | 9 | 10 | 11 | 12 | 13 | 14
1 | A | 15 | 16 | 17 | 18 | 19 | 20 | 21
2 | G | 1 | 2 | 3 | 4 | 5 | 6 | 7
2 | G | 8 | 9 | 10 | 11 | 12 | 13 | 14
2 | G | 15 | 16 | 17 | 18 | 19 | 20 | 21
3 | L | 1 | 2 | 3 | 4 | 5 | 6 | 7
3 | L | 8 | 9 | 10 | 11 | 12 | 13 | 14
3 | L | 15 | 16 | 17 | 18 | 19 | 20 | 21
 |  |  |  |  |  |  |  |  |  |  |  |  |  | We want like this
 |  | Table is like this.
Spreadsheet: 6ff5eae6-e4df-4557-9901-e8334194788d
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
GRAS3 | Test | GRAS3 | Grass Panel # 3 | Grass Panel # 3 | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top	 Acceptable: Serum gel				 Specimen Volume: 0.5 mL	 Additional Information: See Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
GRAS3 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
GRAS3 | Result | GRAS3 | Grass Panel # 3 | Grass Panel # 3 | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 50654-3 | (Anthoxanthum odoratum+Lolium perenne+Phleum pratense+Secale cereale+Holcus lanatus) Ab.IgE:ACnc:Pt:Ser:Qn:Multidisk
Spreadsheet: 810395d1671732670-alphanumeric-sorting-on-table-s666-pq-alphanumeric-sorting-on-table
Sheet: Prenotazioni

 |  |  | Cod | Cliente | Dal | Al |  | Cod | Cliente | Dal | Al
 |  |  | 1A | [NAME] | 2023-07-15 00:00:00 | 2023-08-15 00:00:00 |  | 1A | [NAME] | 2023-07-15 00:00:00 | 2023-08-15 00:00:00 |  | 1A
 |  |  | 1A | Caputo | 2023-07-15 00:00:00 | 2023-08-15 00:00:00 |  | 1A | Caputo | 2023-07-15 00:00:00 | 2023-08-15 00:00:00 |  | 1A
 |  |  | 2A | Veronica |  |  |  | 2A | Veronica |  |  |  | 2A
 |  |  | 3A | YYY | 2023-06-04 00:00:00 | 2023-06-12 00:00:00 |  | 3A | AABBB | 2023-06-07 00:00:00 | 2023-06-10 00:00:00 |  | 3A
 |  |  | 3A | AABBB | 2023-06-07 00:00:00 | 2023-06-10 00:00:00 |  | 3A | [NAME] | 2023-07-01 00:00:00 | 2023-08-31 00:00:00 |  | 3A
 |  |  | 3A | [NAME] | 2023-07-01 00:00:00 | 2023-08-31 00:00:00 |  | 3A | YYY | 2023-06-04 00:00:00 | 2023-06-12 00:00:00 |  | 3A
 |  |  | 4A | AAAAA | 2023-06-01 00:00:00 | 2023-09-30 00:00:00 |  | 4A | AAAAA | 2023-06-01 00:00:00 | 2023-09-30 00:00:00 |  | 4A
 |  |  | 4A | CCCC | 2023-08-10 00:00:00 | 2023-08-20 00:00:00 |  | 4A | CCCC | 2023-08-10 00:00:00 | 2023-08-20 00:00:00 |  | 4A
 |  |  | 4B | [NAME] | 2023-06-01 00:00:00 | 2023-09-30 00:00:00 |  | 5A | Leone | 2023-06-01 00:00:00 | 2023-09-30 00:00:00 |  | 5A
 |  |  | 5A | Leone | 2023-06-01 00:00:00 | 2023-09-30 00:00:00 |  | 6A | Paola | 2023-06-01 00:00:00 | 2023-09-30 00:00:00 |  | 6A
 |  |  | 6A | Paola | 2023-06-01 00:00:00 | 2023-09-30 00:00:00 |  | 14A | Seminara | 2023-06-01 00:00:00 | 2023-09-30 00:00:00 |  | 14A
 |  |  | 9D | [NAME] |  |  |  | 24A | AAA | 2023-06-01 00:00:00 | 2023-06-05 00:00:00 |  | 24A
 |  |  | 9E | BBBB | 2023-07-05 00:00:00 | 2023-07-12 00:00:00 |  | 4B | [NAME] | 2023-06-01 00:00:00 | 2023-09-30 00:00:00 |  | 4B
 |  |  | 12F | [NAME] |  |  |  | 9D | [NAME] |  |  |  | 9D
 |  |  | 14A | Seminara | 2023-06-01 00:00:00 | 2023-09-30 00:00:00 |  | 9E | BBBB | 2023-07-05 00:00:00 | 2023-07-12 00:00:00 |  | 9E
 |  |  | 15G | [NAME] |  |  |  | 12F | [NAME] |  |  |  | 12F
 |  |  | 16G | Martucci | 2023-06-01 00:00:00 | 2023-09-30 00:00:00 |  | 15G | [NAME] |  |  |  | 15G
 |  |  | 23I | [NAME] |  |  |  | 16G | Martucci | 2023-06-01 00:00:00 | 2023-09-30 00:00:00 |  | 16G
 |  |  | 24A | AAA | 2023-06-01 00:00:00 | 2023-06-05 00:00:00 |  | 23I | [NAME] |  |  |  | 23I
Spreadsheet: 131828d1323348353-allocate-points-according-to-rank-tie-problem-rank
Sheet: Blad1

Players | Scores | Points |  |  |  |  |  | Allocation of points |  |  |  | Ties
a | 540 |  |  |  |  |  |  | 1st | 50
z | 555 |  |  |  |  |  |  | 2nd | 45 |  |  | example: | 4th | 550 | 40
e | 530 |  |  |  |  |  |  | 3th | 42 |  |  |  | 5th | 550 | 40
r | 536 |  |  |  |  |  |  | 4th | 40 |  |  |  | 6th | 545 | 36
t | 547 |  |  |  |  |  |  | 5th | 38
y | 548 |  |  |  |  |  |  | 6th | 36 |  |  |  | point 38 is not allocated because of tie!
u | 526 |  |  |  |  |  |  | 7th | 34
i | 539 |  |  |  |  |  |  | 8th | 33
o | 538 |  |  |  |  |  |  | 9th | 32
p | 542 |  |  |  |  |  |  | 10th | 31
q | 551 |  |  |  |  |  |  | 11th | 30
s | 560 |  |  |  |  |  |  | … | 29
d | 541 |  |  |  |  |  |  |  | 28
f | 534 |  |  |  |  |  |  |  | 27
g | 536 |  |  |  |  |  |  |  | 26
h | 540 |  |  |  |  |  |  |  | 25
j | 546 |  |  |  |  |  |  |  | 24
k | 532 |  |  |  |  |  |  |  | 23
l | 538 |  |  |  |  |  |  |  | 22
m | 531 |  |  |  |  |  |  |  | 21
w | 537 |  |  |  |  |  |  |  | 20
x | 547 |  |  |  |  |  |  |  | 19
c | 541 |  |  |  |  |  |  |  | 18
v | 542 |  |  |  |  |  |  |  | 17
b | 544 |  |  |  |  |  |  |  | 16
n | 545 |  |  |  |  |  |  |  | 15
[NAME] | 546 |  |  |  |  |  |  |  | 14
ze | 528 |  |  |  |  |  |  |  | 13
er | 547 |  |  |  |  |  |  |  | 12
rt | 543 |  |  |  |  |  |  |  | 11
ty | 534 |  |  |  |  |  |  |  | 10
yu | 532 |  |  |  |  |  |  |  | 9
ui | 561 |  |  |  |  |  |  |  | 8
io | 556 |  |  |  |  |  |  |  | 7
op | 549 |  |  |  |  |  |  |  | 6
qs | 547 |  |  |  |  |  |  |  | 5
sd | 542 |  |  |  |  |  |  |  | 4
df | 541 |  |  |  |  |  |  | … | 3
fg | 526 |  |  |  |  |  |  | 39th | 2
gh | 529 |  |  |  |  |  |  | >39th | 1
hj | 514
jk | 532
kl | 540
Spreadsheet: 94906d1294673723-auto-updating-workbooks-yarn-testing-summary
Sheet: Unifi

 | 70-34 SD Text |  |  |  |  |  |  | 70-36 SD Mixed Merges Back Bar |  |  |  |  |  |  | 72-34 Samples |  |  |  |  |  |  | 155-84 Augusta
 | [NAME]. Denier | Elongation | Tenacity | Interlace Nodes/M | Oil Extraction | [NAME] |  | [NAME]. Denier | Elongation | Tenacity | Interlace Nodes/M | Oil Extraction | [NAME] |  | [NAME]. Denier | Elongation | Tenacity | Interlace Nodes/M | Oil Extraction | [NAME] |  | [NAME]. Denier | Elongation | Tenacity | Interlace Nodes/M | Oil Extraction | [NAME]
 | 81.9 | 18.4225 | 5.1075 | 87.27250000000001 |  |  |  | 74.49999999999999 | 18.3238 | 4.5992 | 85.84 |  |  |  | 74.3 | 15.651 | 4.678999999999999 | 87.725
 | 81.3 | 18.759 | 5.125999999999999 | 86.145 |  |  |  |  |  |  |  |  |  |  | 74.45 | 14.436 | 4.224666666666667 | 84.72166666666668
 | 81.3 | 17.766 | 4.946 | 87.28999999999999
 | 81.65 | 18.305 | 5.056 | 88.01499999999999
 | 81.375 | 18.329 | 5.086 | 87.8025
 | 80.6 | 18.134 | 4.973000000000001 | 86.315
 | 81.85 | 17.505 | 4.993 | 87.92500000000001
 | 80.825 | 17.9835 | 5.106 | 85.45
 | 81.96666666666667 | 17.15966666666667 | 4.625333333333334 | 85.04
 | 81.88333333333334 | 16.882 | 4.608 | 86.36000000000001
 | 82.675 | 17.1545 | 4.734 | 87.31500000000001
Average | 81.575 | 17.85456060606061 | 4.941893939393939 | 86.81181818181818 | #N/A | #N/A |  | 74.49999999999999 | 18.3238 | 4.5992 | 85.84 | #N/A | #N/A |  | 74.375 | 15.0435 | 4.451833333333333 | 86.22333333333333 | #N/A | #N/A |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Spreadsheet: benjamin_rogers__1044__Peaker Valuation 060500
Sheet: Changes

CHANGES
 | CHANGES | DATE | COMMENTS
May 29 2000 Valuation
1 | Update Treasury | 2000-06-02 00:00:00 | Update from Bloomberg on 6/2/00
2 | Update Spread | 2000-06-02 00:00:00 | Update from Bloomberg on 6/2/00
4 | Update Real Revenue from Desk | 2000-06-01 00:00:00 | Received from [NAME] on 06/2/00
5 | Update Libor forward curve | 2000-06-02 00:00:00 | Downloaded from internet on 6/2/00
May 29 2000 Valuation
1 | Update Treasury | 2000-05-26 00:00:00 | Update from Bloomberg on 5/26/00
2 | Update Spread | 2000-05-26 00:00:00 | Update from Bloomberg on 5/26/00
4 | Update Real Revenue from Desk | 2000-05-25 00:00:00 | Received from [NAME] on 05/25/00
5 | Update Libor forward curve | 2000-05-26 00:00:00 | Downloaded from internet on 5/26/00
May 22 2000 Valuation
1 | Update Treasury | 2000-05-19 00:00:00 | Update from Bloomberg on 5/19/00
2 | Update Spread | 2000-05-19 00:00:00 | Update from Bloomberg on 5/19/00
4 | Update Real Revenue from Desk | 2000-05-18 00:00:00 | Received from [NAME] on 05/18/00
5 | Update Libor forward curve | 2000-05-19 00:00:00 | Downloaded from internet on 5/19/00
May 15 2000 Valuation
1 | Update Treasury | 2000-05-12 00:00:00 | Update from Bloomberg on 5/12/00
2 | Update Spread | 2000-05-12 00:00:00 | Update from Bloomberg on 5/12/00
4 | Update Real Revenue from Desk | 2000-05-11 00:00:00 | Received from [NAME] on 05/11/00
5 | Update Libor forward curve | 2000-05-12 00:00:00 | Downloaded from internet on 5/12/00
May 8 2000 Valuation
1 | Update Treasury | 2000-05-08 00:00:00 | Update from Bloomberg on 5/08/00
2 | Update Spread | 2000-05-08 00:00:00 | Update from Bloomberg on 5/08/00
3 | Update 1999, 2000 O&M | 2000-03-31 00:00:00 | Received from Theresa Wiesmann on 4/25/00
4 | Update Real Revenue from Desk | 2000-05-04 00:00:00 | Received from [NAME] on 05/04/00
5 | Update Libor forward curve | 2000-04-28 00:00:00 | Downloaded from internet on 4/28/00
6 | Update Capex | 2000-05-05 00:00:00 | Model from [NAME] dated 5/05/2000
April 21 2000 Valuation
1 | Update Treasury | 2000-04-24 00:00:00
2 | Update Real Revenue from Desk | 2000-04-20 00:00:00 | Received from [NAME] on 4/24/00
3 | Update Libor forward curve | 2000-04-24 00:00:00 | Downloaded from internet on 4/24/00
April 14 2000 Valuation
1 | Update Treasury | 2000-04-14 00:00:00
2 | Update 1999, 2000 O&M | 2000-02-29 00:00:00 | Received from Theresa Wiesmann on 4/14/00
3 | Update Real Revenue from Desk | 2000-04-13 00:00:00 | Received from [NAME] on 4/14/00
 |  |  | Note:
 |  |  | [NAME] changed the MWs for Summer, Winter, and Shoulder months.
 |  |  | b. The availability for shoulder months has changed from 95% to 75%
 |  |  | c. As per [NAME], [NAME] will start operating on 6/2000 instead of 7/2000, at 350MW gross
4 | Update Libor forward curve | 2000-04-14 00:00:00 | Downloaded from internet on 4/14/00
5 | Update Capex | 2000-04-07 00:00:00 | Model from [NAME] dated 4/11/2000
Spreadsheet: scott_neal__38019__MgmtSum-Q2_2001_0511
Sheet: GM-WklyChnge

ENRON NORTH AMERICA
1st QUARTER 2001 DETAIL OF GROSS MARGIN
DAILY CHANGE
 |  |  |  |  |  |  | Actual | Deals | Forecast | Total
Business Team |  | DPR(1) | MPR | Accruals | Other | FTA | Margin | Identified | Margin | Margin
ERCOT (Smith/Sukaly) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Southeast (Herndon/Pagan) |  | 0 |  |  |  |  |  | 0 | 0
Midwest (Sturm/Baughman) |  | 0 | 0 | 0 | 0 | 0 |  | 0
Northeast (Davis/Ader) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Management Book (Presto) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
New Albany (Presto) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Development (Jacoby) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Structuring (Aucoin) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Fundamentals (Will) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total East Power
Originations (Calger) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
QF (Calger) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Development ([NAME]) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Trading (Belden) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Middle Market/Services (Foster/Wolfe) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Fundamentals ([NAME]) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Total West Power
West (Allen/Tycholiz) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Midwest (Shively/Luce) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
East (Neal/Vickers) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Texas (Martin) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Financial (Arnold) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Derivatives (Lagrasta) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
NG Structuring (McMicheal) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
NG Fundamentals (Gaskill) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Management |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Total Natural Gas
Natural Gas (McKay/LeDain) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Finance (Kitagawa) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Alberta Power (Zufferli/Davies) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Ontario Power (Devries) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Retail (Pope) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Executive (Milnthorp) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Total Canada
Upstream Executive (Mrha) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Compression Services ([NAME]) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Offshore (Byargeon) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Storage (Bieniawski) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
[NAME] (Grass) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
[NAME] (Mrha) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Bridgeline (Mrha) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
HPL (Redmond) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
LT Fundamentals/Transport ([NAME]) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Mexico (Yzaguirre) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Generation Investments (Duran) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Principal Investing ([NAME]) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Energy Capital Svcs (Thompson/Josey) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Corporate Development (Detmering) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Restructuring (Redmond) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Cross Commodity (Lavorato) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Office of the Chairman (Delainey/Lavorato) |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Overview |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Total Commercial
(1) Excludes Cap. Charge & Operating Costs