tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 818813d1677067092-a-sum-product-with-multiple-criteria-urgent-problem-test
Sheet: Exercise 3

COST |  |  | Currency |  |  | Exchange |  |  |  | TOTAL COST
Part | Cost |  | Part | Currency |  | From | To | Rate |  | Part | Description | Volume | Total Cost USD
0102025 | 1.07 |  | 0121022 | EUR |  | EUR | EUR | 1 |  | 48274 | S4080 11-13MM 7/16-1/2" | 23
0103541 | 32.54 |  | 0168972 | EUR |  | EUR | GBP | 0.84 |  | 0102016 | 404 3"BB 5/16-3/8" 2T | 335
0108038 | 49.24 |  | 0169374 | EUR |  | EUR | USD | 1.16 |  | 0102025 | 404 4-1/2"BB 3/8-1/2" 4T | 670
0108065 | 352.47 |  | 0120096 | EUR |  | GBP | EUR | 1.19 |  | 0103541 | 407 8"RB 1-1-1/8" 20T | 285
0108127 | 99.63 |  | 0109643 | EUR |  | GBP | GBP | 1 |  | 0108038 | 418   3"BB SBL 5/16-3/8" | 285
0108225 | 125.05 |  | 0109064 | EUR |  | GBP | USD | 1.38 |  | 0108065 | 418 4-1/2"BB  3/8-1/2 4T | 35
0108308 | 177.16 |  | 0121095 | EUR |  | USD | EUR | 0.86 |  | 0108127 | 418   6"BB SN BL 5/8-3/4" | 168
0108371 | 207.11 |  | 0121255 | EUR |  | USD | GBP | 0.73 |  | 0108225 | 418   8"BB SN BL 5/8-3/4" | 11
0108390 | 394.99 |  | 0108390 | EUR |  | USD | USD | 1 |  | 0108308 | 421 8"BB 3/4-7/8" 15T | 47
0109037 | 334.33 |  | 0130655 | EUR |  |  |  |  |  | 0108371 | 420   10"BB SN BL 3/4-7/8 | 23
0109064 | 436.81 |  | 0109607 | EUR |  |  |  |  |  | 0108390 | 421 10"BB 3/4-7/8" 15T | 23
0109091 | 59.19 |  | 0108065 | GBP |  |  |  |  |  | 0109037 | 419 3"BB 5/16-3/8" 2T | 35
0109126 | 108.5 |  | 0109420 | GBP |  |  |  |  |  | 0109064 | 419 4-1/2"BB 3/8-1/2" 4T | 11
0109153 | 69.14 |  | 0297020 | GBP |  |  |  |  |  | 0109091 | 419 3"BB 5/16-3/8" 2T | 11
0109224 | 271.83 |  | 0109037 | GBP |  |  |  |  |  | 0109126 | 419 6"BB 5/8-3/4" 8T | 47
0109251 | 285.53 |  | 0109322 | GBP |  |  |  |  |  | 0109153 | 419 6"RB 5/8-3/4" 8T | 35
0109322 | 318.88 |  | 0109527 | GBP |  |  |  |  |  | 0109224 | 419 8"BB 5/8-3/4" 8T | 11
0109420 | 349.49 |  | 0297011 | GBP |  |  |  |  |  | 0109251 | 419 8"RB 5/8-3/4" 8T | 0
0109527 | 293.36 |  | 0109251 | GBP |  |  |  |  |  | 0109322 | 419 10"BB 5/8-3/4" 8T | 70
0109607 | 373.93 |  | 0109224 | GBP |  |  |  |  |  | 0109420 | 419 12"BB 3/4" 8T | 0
0109643 | 613.08 |  | 0108371 | GBP |  |  |  |  |  | 0109527 | 419 14"BB 5/8-3/4" 8T | 11
0120096 | 758.56 |  | 0108308 | GBP |  |  |  |  |  | 0109607 | 419 16"BB 3/4-7/8" 15T | 23
0121022 | 979.72 |  | 0108225 | GBP |  |  |  |  |  | 0109643 | 419 18"BB 1" 15T | 0
0121095 | 397.58 |  | 0109126 | USD |  |  |  |  |  | 0120096 | 430   10"BB SN BL 1-1.1/8 | 0
0121255 | 397.24 |  | 0108127 | USD |  |  |  |  |  | 0121022 | 431 8"BB 1-1-1/8" 20T | 35
0130655 | 391.68 |  | 0109153 | USD |  |  |  |  |  | 0121095 | 431 10"BB 1-1-1/8" 20T | 23
0168972 | 863.06 |  | 0109091 | USD |  |  |  |  |  | 0121255 | 431 14"BB 1-1/8" 20T | 59
0169374 | 833.95 |  | 0108038 | USD |  |  |  |  |  | 0130655 | [NAME]" 9T | 47
0297011 | 289.76 |  | 0103541 | USD |  |  |  |  |  | 0168972 | 417 6"BB 3/4-7/8" 12T | 35
0297020 | 342.71 |  | 0102025 | USD |  |  |  |  |  | 0169374 | 420   6" BB SN BL 3/4-7/8 | 298
Spreadsheet: 695465d1600230000-index-with-match-test-1-
Sheet: Sheet1

Name | 1 | 2 | 3 | 4 | 5 |  | Test1 | Test2 | Test3 | Test4 | Test5 | Test6 | [NAME] | Test8 | Test9
[NAME] |  |  |  |  |  |  | 85 | 72 | 25 | 42 | 0 | 92 | 13 | 55 | 56
bill |  |  |  |  |  |  | 44 | 56 | 78 | 36 | 52 | 97 | 64 | 84 | 80
[NAME] |  |  |  |  |  |  |  | 0 | 46 | 72 | 85 | 63 | 67 | 88 | 99
[NAME]
[NAME]
justin
 | I need john's first 5 test scores from sheet 2 - excluding zeroes.
Spreadsheet: 537702d1505230627-how-to-split-rows-by-date-and-time-example-problem
Sheet: Sheet1

Start Date | Start Time | End Date | End Time
2016-10-07 00:00:00 | 17:45:00 | 2016-10-08 00:00:00 | 11:20:00
2016-10-08 00:00:00 | 13:05:00 | 2016-10-09 00:00:00 | 11:10:00
2016-10-09 00:00:00 | 11:10:00 | 2016-10-10 00:00:00 | 11:15:00
2016-10-10 00:00:00 | 11:45:00 | 2016-10-10 00:00:00 | 14:45:00
2016-10-10 00:00:00 | 15:35:00 | 2016-10-10 00:00:00 | 17:30:00
2016-10-10 00:00:00 | 18:10:00 | 2016-10-11 00:00:00 | 08:15:00
2016-10-11 00:00:00 | 08:15:00 | 2016-10-11 00:00:00 | 09:40:00
2016-10-11 00:00:00 | 10:35:00 | 2016-10-11 00:00:00 | 12:50:00
2016-10-11 00:00:00 | 13:50:00 | 2016-10-11 00:00:00 | 14:45:00
2016-12-15 00:00:00 | 19:50:00 | 2016-12-15 00:00:00 | 19:50:00
2016-12-15 00:00:00 | 21:05:00 | 2016-12-16 00:00:00 | 11:15:00
2016-12-16 00:00:00 | 14:05:00 | 2016-12-17 00:00:00 | 09:50:00
2016-12-17 00:00:00 | 11:05:00 | 2016-12-17 00:00:00 | 11:35:00
2016-12-17 00:00:00 | 16:25:00 | 2016-12-18 00:00:00 | 10:10:00
2016-12-18 00:00:00 | 12:15:00 | 2016-12-20 00:00:00 | 11:30:00
Spreadsheet: 158815d1338401279-compare-a-range-of-cells-to-a-specific-cell-if-match-compare-another-cell-on-same-row-12-13-budget
Sheet: Student Worker Limits

Student Workers | Total Hours | Total Days | Notes
Spreadsheet: 866127d1713077988-give-a-distinct-sequence-number-for-every-data-type-in-col-a-and-col-b-ref-book
Sheet: Sheet1

DATE | TYPE | NUMBER WHAT I SHOULD Get in G6 |  |  | DATE | 2024-04-05 00:00:00
2024-04-01 00:00:00 | PAYMENT | 1 |  |  | TYPE | LIABILITY
2024-04-01 00:00:00 | PAYMENT | 1
2024-04-01 00:00:00 | PAYMENT | 1
2024-04-01 00:00:00 | PAYMENT | 1
2024-04-01 00:00:00 | PAYMENT | 1 |  |  | BILL SL NO
2024-04-01 00:00:00 | PAYMENT | 1
2024-04-01 00:00:00 | PAYMENT | 1 |  |  | Number That I should get is | 5
2024-04-01 00:00:00 | PAYMENT | 1 |  |  | But What I have got | 2
2024-04-01 00:00:00 | LIABILITY | 2
2024-04-01 00:00:00 | PAYMENT | 1
2024-04-01 00:00:00 | PAYMENT | 1
2024-04-01 00:00:00 | PAYMENT | 1
2024-04-01 00:00:00 | OTHER | 3
2024-04-01 00:00:00 | PAYMENT | 1
2024-04-01 00:00:00 | PAYMENT | 1
2024-04-01 00:00:00 | LIABILITY | 2
2024-04-01 00:00:00 | PAYMENT | 1
2024-04-01 00:00:00 | OTHER | 3
2024-04-01 00:00:00 | PAYMENT | 1
2024-04-01 00:00:00 | PAYMENT | 1
2024-04-05 00:00:00 | PAYMENT | 4
2024-04-05 00:00:00 | PAYMENT | 4
2024-04-05 00:00:00 | PAYMENT | 4
2024-04-05 00:00:00 | PAYMENT | 4
2024-04-05 00:00:00 | PAYMENT | 4
2024-04-05 00:00:00 | PAYMENT | 4
2024-04-05 00:00:00 | LIABILITY | 5
2024-04-05 00:00:00 | PAYMENT | 4
2024-04-05 00:00:00 | PAYMENT | 4
2024-04-05 00:00:00 | LIABILITY | 5
2024-04-05 00:00:00 | PAYMENT | 4
2024-04-05 00:00:00 | PAYMENT | 4
2024-04-05 00:00:00 | OTHER | 6
2024-04-05 00:00:00 | OTHER | 6
2024-04-05 00:00:00 | OTHER | 6
2024-04-08 00:00:00 | PAYMENT | 7
2024-04-08 00:00:00 | PAYMENT | 7
2024-04-08 00:00:00 | PAYMENT | 7
2024-04-08 00:00:00 | OTHER | 8
2024-04-08 00:00:00 | LIABILITY | 9
2024-04-08 00:00:00 | PAYMENT | 7
2024-04-08 00:00:00 | PAYMENT | 7
2024-04-08 00:00:00 | OTHER | 8
2024-04-08 00:00:00 | PAYMENT | 7
2024-04-08 00:00:00 | PAYMENT | 7
2024-04-08 00:00:00 | LIABILITY | 9
2024-04-08 00:00:00 | LIABILITY | 9
2024-04-08 00:00:00 | PAYMENT | 7
2024-04-08 00:00:00 | PAYMENT | 7
2024-04-08 00:00:00 | PAYMENT | 7
2024-04-08 00:00:00 | OTHER | 8
2024-04-08 00:00:00 | LIABILITY | 9
2024-04-08 00:00:00 | LIABILITY | 9
2024-04-08 00:00:00 | PAYMENT | 7
2024-04-08 00:00:00 | LIABILITY | 9
2024-04-08 00:00:00 | PAYMENT | 7
2024-04-08 00:00:00 | OTHER | 8
2024-04-08 00:00:00 | PAYMENT | 7
2024-04-08 00:00:00 | LIABILITY | 9
Spreadsheet: 328348d1403876654-formula-to-add-up-totals-from-lots-of-worksheets-testings
Sheet: sheet9

 |  |  | Item | Date of PAT Test | [NAME] |  | [NAME] key
 |  |  | 1 | TBA | 2014-06-20 00:00:00 |  | Test Due
 |  |  | 1 |  | 2013-02-27 00:00:00 |  | Test in 30 days
 |  |  | 1 | 2010-02-17 00:00:00 | 2011-02-17 00:00:00
 |  |  | 1 |  | 2013-02-17 00:00:00
 |  |  | 1 |  | 2013-08-17 00:00:00
 |  |  | 1 |  | 2013-08-17 00:00:00
 |  |  | 1 |  | 2013-08-17 00:00:00
 |  |  | 1 | 2010-02-17 00:00:00 | 2011-02-17 00:00:00
 |  |  | 1 | TBA
 |  |  | 1 | TBA
 |  |  | 1 |  | 2013-08-17 00:00:00
 |  |  | 1 |  | 2013-08-17 00:00:00
 |  |  | In need of first test:
 |  |  | Overdue for PAT test:
 |  |  | Total
Spreadsheet: 160306d1339037523-macro-or-index-match-danquality
Sheet: Behavior Data

Behavior | Score | Verbage
Company | 5 | A
Company | 5 | B
Company | 5 | C
Company | 5 | D
Company | 4 | E
Company | 4 | F
Company | 4 | G
Company | 4 | H
Company | 4 | I
Company | 4 | J
Company | 4 | K
Company | 4 | L
Company | 4 | I
Company | 3 | J
Company | 3 | K
Company | 3 | L
Company | 3 | I
Company | 3 | J
Company | 2 | K
Company | 2 | L
Company | 2 | I
Company | 2 | J
Company | 2 | K
Company | 2 | L
Company | 2 | I
Company | 2 | J
Company | 2 | K
Company | 2 | L
Company | 1 | asdasd asd asd asd asd
Company | 1 | asdasd dsad rth try tyj
Company | 1 | ewfw [NAME] er et
Company | 1 | [NAME] yjh
Company | 1 | [NAME] tuk
Results | 5 | J
Results | 5 | K
Results | 5 | L
Results | 5 | I
Results | 5 | J
Results | 4 | K
Results | 4 | L
Results | 4 | I
Results | 4 | J
Results | 4 | K
Results | 4 | L
Results | 4 | I
Results | 4 | J
Results | 4 | K
Results | 3 | L
Results | 3 | I
Results | 3 | J
Results | 3 | K
Results | 3 | L
Results | 3 | I
Results | 3 | J
Results | 3 | K
Results | 3 | L
Results | 3 | I
Results | 3 | J
Results | 2 | K
Results | 2 | L
Results | 2 | I
Results | 2 | J
Results | 2 | K
Results | 2 | L
Results | 2 | I
Results | 2 | J
Results | 2 | K
Results | 2 | L
Results | 1 | I
Results | 1 | J
Results | 1 | K
Results | 1 | L
Results | 1 | I
Thought | 5 | J
Thought | 5 | K
Thought | 5 | L
Thought | 5 | I
Thought | 5 | J
Thought | 4 | K
Thought | 4 | L
Thought | 4 | I
Thought | 4 | J
Thought | 4 | K
Thought | 4 | L
Thought | 4 | I
Thought | 4 | J
Thought | 4 | K
Thought | 4 | L
Thought | 3 | I
Thought | 3 | J
Thought | 3 | K
Thought | 3 | L
Thought | 3 | I
Thought | 2 | J
Thought | 2 | K
Thought | 2 | L
Thought | 2 | I
Thought | 2 | J
Thought | 2 | K
Thought | 2 | L
Thought | 2 | I
Thought | 2 | J
Thought | 2 | K
Thought | 1 | L
Thought | 1 | I
Thought | 1 | J
Thought | 1 | K
Thought | 1 | L
People | 5 | I
People | 5 | J
People | 5 | K
People | 5 | L
People | 5 | I
People | 4 | J
People | 4 | K
People | 4 | L
People | 4 | I
People | 4 | J
People | 4 | K
People | 4 | L
People | 4 | I
People | 4 | J
People | 4 | K
People | 4 | L
People | 3 | I
People | 3 | J
People | 3 | K
People | 3 | L
People | 3 | I
People | 3 | J
People | 2 | K
People | 2 | L
People | 2 | I
People | 2 | J
People | 2 | K
People | 2 | L
People | 2 | I
People | 2 | J
People | 2 | K
People | 2 | L
People | 2 | I
People | 1 | J
People | 1 | K
People | 1 | L
People | 1 | I
People | 1 | J
Spreadsheet: 788887d1658775164-sum-only-values-in-row-with-dates-fy23-funding-actions-e
Sheet: Sheet1

FY23 BASOPS MIPR LOG
MIPR TYPE | WBS | MIPR # | PO # | GT&C # | CONTRACT # | CONTRACT START | CONTRACT END | [NAME] | FY23 ESTIMATE | FUNDS REQUEST (FR) # | DATE  FR RCVD | DATE  FUNDS SENT | DATE  DD448-2 RCVD | BASIC $ | FUNDS REQUEST (FR) # | DATE  FR RCVD | DATE  FUNDS SENT | DATE  DD448-2 RCVD | AMD 0001 $ | FUNDS REQUEST (FR) # | DATE  FR RCVD | DATE  FUNDS SENT | DATE  DD448-2 RCVD | AMD 0002 $ | FUNDS REQUEST (FR) # | DATE  FR RCVD | DATE  FUNDS SENT | DATE  DD448-2 RCVD | AMD 0003 $ | FUNDS REQUEST (FR) # | DATE  FR RCVD | DATE  FUNDS SENT | DATE  DD448-2 RCVD | AMD 0004 $ | FUNDS REQUEST (FR) # | DATE  FR RCVD | DATE  FUNDS SENT | DATE  DD448-2 RCVD | AMD 0005 $ | STATUS | TOTAL COMMITMENT | TOTAL OBLIGATED | TOTAL BILLED | ULO | % BILLED | COMMENTS
REIMB | S.00xxxxx.131 | 123456 | 455123645 |  |  |  |  | UTILITIES | 14500000 | 654321 | 2022-07-20 00:00:00 | 2022-07-21 00:00:00 | 2022-07-23 00:00:00 | 10000 | 124578 | 2022-07-21 00:00:00 | 2022-07-22 00:00:00 | 2022-07-24 00:00:00 | 15000 | 784512 | 2022-07-23 00:00:00 |  |  | 45000
Spreadsheet: 91657d1291317397-comparing-difference-between-two-columns-compare-1
Sheet: Sheet1

Column A | Column B |  | 2 | Result should be
A | B |  |  | G
B | C |  |  | G
C | D |  |  | R
D | E |  |  | W
E | F |  |  | Z
F | F |  |  | X
G | F | 1 |  | R
A | F
B | R |  | 3
C | W |  | 4
D | Z |  | 5
E | X |  | 6
F | R |  | 7
G | A | 2
Spreadsheet: 792424d1660897782-amalgamating-and-deleting-rows-example-of-completed-sheet
Sheet: Example

Passenger Assist List |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-04-13 00:00:00
 |  |  |  |  |  |  |  | [NAME] |  |  |  | Departure
Job | Assigned To | Name | VIP | W/C | BR W/C | Mob Imp | [NAME] | Time | Head Code | From | [NAME] | Time | Head Code | Destination | [NAME] | Additional Comments
1 | SC | Mr [NAME] | Y |  |  |  |  | 0851 | 1S39 | Crewe | B2
2 | SC | Mr [NAME] |  |  |  | Y |  |  |  |  |  | 1117 | 9M52 | Wolves | E16
3 | MP | Mr Khokhar | Y |  |  |  |  | 1138 | 1S48 | [NAME]
4 | LG | [NAME] |  |  |  | Y |  | 1151 | 9S54 | Warrington | B29 | 1159 | 2N24 | Blackpool
5 | SC | Mr Aspdan |  |  |  | Y |  |  |  |  |  | 1158 | 1M10 | [NAME] | A35/36
6 | MP | Mr [NAME] |  |  |  | Y |  | 1238 | 1S52 | [NAME] | B38
7 | LG | [NAME] |  | Y |  |  | Y | 1247 | 1B18 | Burnley MR |  | 1353 | 9S60 | Edinburgh
8 | SC | [NAME] |  |  | Y | Y |  | 1259 | 2N12 | St Annes |  | 1358 | 1M12 | [NAME] | D11
9 | MP | [NAME] |  | Y |  |  | Y | 1351 | 9S60 | Birmingham | J1/2/5 | 1420 | 2N97 | Blackpool
10 | JE | [NAME] |  |  |  | Y |  | 1356 | 1M12 | [NAME] | C46 | 1409 | 2F02 | Ormskirk
11 | IP | Miss [NAME] |  |  |  | Y |  | 1438 | 1S63 | [NAME]
12 | SC | Mr [NAME] |  |  |  | Y |  | 1538 | 1S69 | [NAME] | H02
13 | IP | [NAME] | Y |  |  |  |  | 1547 | 1B24 | Accrington |  | 1617 | 9M84 | [NAME] |  | Uses Walker
14 | LG | [NAME] |  |  |  | Y |  | 1638 | 1S72 | [NAME] | B35 | 1650 | 2J60 | Chorley
15 | MP | Mr [NAME] |  | Y |  |  | Y | 1651 | 9S77 | [NAME] | A01/06
16 | LG | Miss [NAME] |  |  |  | Y |  |  |  |  |  | 1905 | 1M17 | [NAME] | [NAME]
17 | JE | Mr [NAME] | Y |  |  |  |  |  |  |  |  | 1917 | 9M60 | Crewe | E2
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
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Spreadsheet: 550049d1512069380-conditional-formatting-help-please-copy-of-excel-help-sheet-paullyb-
Sheet: MAIN SHEET

 |  |  |  | STRENGTH | COMMUNICATION | FLEXIBILITY |  |  |  | STRENGTH | COMMUNICATION | FLEXIBILITY |  |  |  | STRENGTH | COMMUNICATION | FLEXIBILITY
POSITION |  | OCT |  |  |  |  |  | DEC |  |  |  |  |  | FEB
MANAGER |  | [NAME] | BOBS |  |  |  |  | [NAME] | BOBS |  |  |  |  | [NAME] | BOBS
SERVER |  | NANCY | JEEBS |  |  |  |  | NANCY | JEEBS |  |  |  |  | NANCY | JEEBS
BUSBOY |  | PAUL | [NAME] |  |  |  |  | PAUL | [NAME] |  |  |  |  | PAUL | [NAME]
DISHWASHER |  | [NAME] | CARFE |  |  |  |  | [NAME] | CARFE |  |  |  |  | [NAME] | CARFE
 |  |  | THIS PAGE IS THE MAIN PAGE
 |  |  | EACH PERSON HAS 4 QUALIFICATIONS THEY NEED TO KEEP
 |  |  |  | STRENGTH
 |  |  |  | [NAME]
 |  |  |  | FLEXIBILITY
 |  |  | EACH COLUMN COINCIDES WITH A PERSONS NAME AND THERE IS A BLOCK I WOULD WANT THAT BLOCK TO POPULATE WHEN THE OTHER PAGES IN THE WORKBOOK ARE FILLED OUT.
 |  |  | SO EACH MANAGER I HAVE IN CHARGE OF FILLING OUT EACH TAB NEVER HAS TO TOUCH THE MAIN PAGE.
 |  |  | FOR EXAMPLE IF YOU WERE THE STRENGTHS MANAGER YOU WOUL CLICK THAT TAB AND CHECK OFF WHICH PORTIONS OF STRENGHT QUALIFICATIONS HAVE BEEN COMPLETED.
 |  |  |  | IF THAT PERSON HAS THEM ALL DONE THEN THE BLOCK UNDER STRENGTHS ON THE "Main Page" would be GREEN
 |  |  |  | IF THAT PERSON HAS HALF DONE THEN THE BLOCK UNDER STRENGTHS ON THE "Main Page" would be YELLOW
 |  |  |  | AND IF ZERO ARE COMPLETED THEN IT WOULD BE RED
 |  |  | ON THE STRENGTH SHEET I MOCKED UP [NAME] BOBS HAS COMPLETED FROM OCT THRU FEB. OCTOBER HE IS FULL GREEN / DEC HALF COMPLETE MAKING HIM YELLOW / FEB ONLY ONE DONE MAKING HIM RED.
Spreadsheet: sally_beck__35756__MgmtSum-Q1-0222
Sheet: Upside Downside

Upside / Downside Analysis
 |  |  | Estimate |  | Plan |  | [NAME]
Actual Margin
Deals Identified
Forecast Items:
 | Trading Margin Required Meet Expectations
 | Drift (IR & F/X)
 | Sycamore Forecast (Equity Trading)
 | Insurance Group
 | ECOGAS Credits
 | Credit Release (Treasury)
 | ComEd (Genco)
Less Expenses:
 | Commercial & Group Expenses
 | Interest & Interest Related Charges
Identified Earnings
Potential Upsides:
 | Upstream Transactions
 | Generation Investments Transactions
 | East Midstream Transactions
 | West Midstream Transactions
 | Principal Investing (Byers Locate?)
 | Pulp & Paper Forecast
 | Assets (No support)
Potential Downsides:
Portfolio Valuation Issues:
Earnings Before Tax
Spreadsheet: michelle_lokay__26829__Indicies
Sheet: Indicies

Dates | IGABQ00 - Mid* | IGABW00 - Mid*
 | Permian | SJ | SoCal |  |  | Perm-CA |  |  | SJ-CA
1998-10-01 00:00:00 | 1.865 | 1.705 | 2.33 |  | 1998-10-01 00:00:00 |  |  | 1998-10-01 00:00:00
1998-11-02 00:00:00 | 1.98 | 1.93 | 2.55 |  | 1998-11-01 00:00:00 |  |  | 1998-11-01 00:00:00
1998-12-01 00:00:00 | 1.975 | 1.96 | 2.15 |  | 1998-12-01 00:00:00 |  |  | 1998-12-01 00:00:00
1999-01-04 00:00:00 | 1.78 | 1.735 | 2.23 |  | 1999-01-01 00:00:00 |  |  | 1999-01-01 00:00:00
1999-02-01 00:00:00 | 1.675 | 1.635 | 1.88 |  | 1999-02-01 00:00:00 |  |  | 1999-02-01 00:00:00
1999-03-01 00:00:00 | 1.53 | 1.495 | 1.73 |  | 2000-03-01 00:00:00 |  |  | 2000-03-01 00:00:00
1999-04-01 00:00:00 | 1.64 | 1.6 | 1.96 |  | 1999-04-01 00:00:00 |  |  | 1999-04-01 00:00:00
1999-05-03 00:00:00 | 2.13 | 2.01 | 2.28 |  | 1999-05-01 00:00:00 |  |  | 1999-05-01 00:00:00
1999-06-01 00:00:00 | 2.075 | 1.945 | 2.29 |  | 1999-06-01 00:00:00 |  |  | 1999-06-01 00:00:00
1999-07-01 00:00:00 | 2.17 | 2.065 | 2.51 |  | 1999-07-01 00:00:00 |  |  | 1999-07-01 00:00:00
1999-08-02 00:00:00 | 2.47 | 2.255 | 2.63 |  | 1999-08-01 00:00:00 |  |  | 1999-08-01 00:00:00
1999-09-01 00:00:00 | 2.825 | 2.63 | 3.05 |  | 1999-09-01 00:00:00 |  |  | 1999-09-01 00:00:00
1999-10-01 00:00:00 | 2.39 | 2.35 | 2.78 |  | 1999-10-01 00:00:00 |  |  | 1999-10-01 00:00:00
1999-11-01 00:00:00 | 2.83 | 2.825 | 3.02 |  | 1999-11-01 00:00:00 |  |  | 1999-11-01 00:00:00
1999-12-01 00:00:00 | 2.065 | 2.06 | 2.47 |  | 1999-12-01 00:00:00 |  |  | 1999-12-01 00:00:00
2000-01-03 00:00:00 | 2.195 | 2.2 | 2.42 |  | 2000-01-01 00:00:00 |  |  | 2000-01-01 00:00:00
2000-02-01 00:00:00 | 2.415 | 2.37 | 2.83 |  | 2000-02-01 00:00:00 |  |  | 2000-02-01 00:00:00
2000-03-01 00:00:00 | 2.43 | 2.4 | 2.81 |  | 2000-03-01 00:00:00 |  |  | 2000-03-01 00:00:00
2000-04-03 00:00:00 | 2.78 | 2.735 | 3.06 |  | 2000-04-01 00:00:00 |  |  | 2000-04-01 00:00:00
2000-05-01 00:00:00 | 2.9 | 2.79 | 3.26 |  | 2000-05-01 00:00:00 |  |  | 2000-05-01 00:00:00
2000-06-01 00:00:00 | 4.025 | 3.835 | 4.91 |  | 2000-06-01 00:00:00 |  |  | 2000-06-01 00:00:00
2000-07-05 00:00:00 | 4.335 | 4.11 | 4.92 |  | 2000-07-01 00:00:00 |  |  | 2000-07-01 00:00:00
2000-08-01 00:00:00 | 3.755 | 3.485 | 4.81 |  | 2000-08-01 00:00:00 |  |  | 2000-08-01 00:00:00
2000-09-01 00:00:00 | 4.495 | 3.475 | 6.4 |  | 2000-09-01 00:00:00 |  |  | 2000-09-01 00:00:00
Spreadsheet: 705647d1606238982-formula-help-list-data-validation-autopopulates-fieldlist
Sheet: Comms

Type of Request: | Replacement
Site Name: |  |  |  |  |  |  |  |  |  |  | VLookUp - Protocol Database Load | VLookup for Cell A6 |  | Protocal | [NAME]
Remote ID: |  |  |  |  |  |  |  |  |  |  | AAT 60780 | Eagle |  | Eagle | AAT 60780
Protocol: | Eagle |  |  |  |  |  |  |  |  |  | RTD 60780 | FisheROC |  | Eagle | RTD 60780
Protocol [NAME]: |  | [NAME] is a the list based on what is selected in B4 |  |  |  |  |  |  |  |  | EVC 61046 | GasMicro |  | Eagle | EVC 61046
 |  |  |  |  |  |  |  |  |  |  | EPR 60885 | Mercury |  | Eagle | EPR 60885
*Poll Schedule: | 2min |  |  |  |  |  |  |  |  |  | Ultra 60780 | modbus |  | Eagle | Ultra 60780
Control Site: | No |  |  |  |  |  |  |  |  |  | Eseries 60981 | XModbus |  | Eagle | Eseries 60981
Tabular Display: | Custom |  |  |  |  |  |  |  |  |  | Orifice 60063 |  |  | Eagle | Orifice 60063
IP Address:Port Primary |  |  |  |  |  |  |  |  |  |  | TOC 60571 |  |  | Eagle | TOC 60571
IP Address:Port Secondary |  |  |  |  |  |  |  |  |  |  | Turbine 60254 |  |  | Eagle | Turbine 60254
Comm Type Primary: | CDMA |  |  |  |  |  |  |  |  |  | 107 Ultra&Turbine |  |  | FisheROC | 107 Ultra&Turbine
Comm Type Secondary: |  |  |  |  |  |  |  |  |  |  | 107 Orifice |  |  | FisheROC | 107 Orifice
Communication Group: | N/A |  |  |  |  |  |  |  |  |  | EPR |  |  | GasMicro | EPR
 |  |  |  |  |  |  |  |  |  |  | EVC |  |  | GasMicro | EVC
 |  |  |  |  |  |  |  |  |  |  | EC 350 |  |  | Mercury | EC 350
 |  |  |  |  |  |  |  |  |  |  | ERX 350 |  |  | Mercury | ERX 350
 |  |  |  |  |  |  |  |  |  |  | EC AT |  |  | Mercury | EC AT
 |  |  |  |  |  |  |  |  |  |  | ERX |  |  | Mercury | ERX
 |  |  |  |  |  |  |  |  |  |  | Mini AT |  |  | Mercury | Mini AT
 |  |  |  |  |  |  |  |  |  |  | TOC |  |  | Mercury | TOC
 |  |  |  |  |  |  |  |  |  |  | Analyzers |  |  | modbus | Analyzers
 |  |  |  |  |  |  |  |  |  |  | 334 |  |  | Xmodbus | 334
 |  |  |  |  |  |  |  |  |  |  | =(IF(B4="Eagle",VLOOKUP(B5,O3:P23,2,FALSE)),IF(B4="FisheROC",VLOOKUP(B5,O3:P23,2,FALSE))*IF(B4="GasMicro",VLOOKUP(B5,O3:P23,2,FALSE))*IF(B4="Mercury",VLOOKUP(B5,O3:P23,2,FALSE))*IF(B4="modbus",VLOOKUP(B5,O3:P23,2,FALSE))*IF(B4="XModbus",VLOOKUP(B5,O3:P23,2,FALSE)))
Spreadsheet: 0054b196-06f0-4cd9-907b-9a7e613cdb19
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
10/14/2011 | Men's Swimming & Diving | WEST VIRGINIA STATE GAMES | 12:00 AM | 1st place
10/15/2011 | Men's Swimming & Diving | WEST VIRGINIA STATE GAMES | 12:00 AM | 1st place
10/22/2011 | Men's Swimming & Diving | at Penn State | 12:00 AM | L, 143-98
11/12/2011 | Men's Swimming & Diving | CINCINNATI | 12:00 AM | W, 178-107
11/12/2011 | Men's Swimming & Diving | VILLANOVA | 12:00 AM | W, 190-100
11/18/2011 | Men's Swimming & Diving | at Pitt Invitational | 12:00 AM | 2nd place
11/19/2011 | Men's Swimming & Diving | at Pitt Invitational | 12:00 AM | 2nd place
11/20/2011 | Men's Swimming & Diving | at Pitt Invitational | 12:00 AM | 2nd place
12/01/2011 | Men's Swimming & Diving | Miami Diving Invitational (Miami, Ohio) | 12:00 AM | Results
12/01/2011 | Men's Swimming & Diving | U.S. Winter Nationals (Atlanta, Ga.) | 12:00 AM | Results
12/02/2011 | Men's Swimming & Diving | U.S. Winter Nationals (Atlanta, Ga.) | 12:00 AM | Results
12/02/2011 | Men's Swimming & Diving | Miami Diving Invitational (Miami, Ohio) | 12:00 AM | Results
12/03/2011 | Men's Swimming & Diving | Miami Diving Invitational (Miami, Ohio) | 12:00 AM | Results
12/03/2011 | Men's Swimming & Diving | U.S. Winter Nationals (Atlanta, Ga.) | 12:00 AM | Results
01/02/2012 | Men's Swimming & Diving | [NAME] Relays ([NAME], Fla.) | 12:00 AM | Results
01/07/2012 | Men's Swimming & Diving | PITT | 12:00 AM | L, 124.5-175.5
01/21/2012 | Men's Swimming & Diving | at Maryland | 12:00 AM | L, 180-120
02/10/2012 | Men's Swimming & Diving | BIG EAST Diving Championships (Pittsburgh, Pa.) | 12:00 AM | 3rd place
02/11/2012 | Men's Swimming & Diving | BIG EAST Diving Championships (Pittsburgh, Pa.) | 12:00 AM | 3rd place
02/15/2012 | Men's Swimming & Diving | BIG EAST Swimming Championships (Pittsburgh, Pa.) | 12:00 AM | 3rd place
02/16/2012 | Men's Swimming & Diving | BIG EAST Swimming Championships (Pittsburgh, Pa.) | 12:00 AM | 4th place
02/17/2012 | Men's Swimming & Diving | BIG EAST Swimming Championships (Pittsburgh, Pa.) | 12:00 AM | 4th place
02/18/2012 | Men's Swimming & Diving | BIG EAST Swimming Championships (Pittsburgh, Pa.) | 12:00 AM | 4th place
03/09/2012 | Men's Swimming & Diving | NCAA Zone Diving (Buffalo, N.Y.) | 12:00 AM | Results
03/10/2012 | Men's Swimming & Diving | NCAA Zone Diving (Buffalo, N.Y.) | 12:00 AM | Results
03/29/2012 | Men's Swimming & Diving | U.S. Grand Prix (Indianapolis, Ind.) | 12:00 AM | TBD
03/30/2012 | Men's Swimming & Diving | U.S. Grand Prix (Indianapolis, Ind.) | 12:00 AM | TBD
03/31/2012 | Men's Swimming & Diving | U.S. Grand Prix (Indianapolis, Ind.) | 12:00 AM | TBD