tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: mike_swerzbin__28066__EMR Prices
Sheet: Sheet1

 |  | Peak |  | Off-Peak
Region | Delivery Date | Low | High | Low | High
Red numbers indicate flat, 24-hour products.
NW/N. Rockies | 2002-01-08 00:00:00 | 17 | 18 | 14.5 | 15.25
Mid-Columbia | 2002-01-08 00:00:00 | 17 | 18 | 14.5 | 15.25
COB | 2002-01-08 00:00:00 | 19 | 19.75 | 14.25 | 16
N. California | 2002-01-08 00:00:00 | 20.5 | 22 | 15.5 | 17.25
Midway/Sylmar | 2002-01-08 00:00:00 | NA | NA | NA | NA
S. California | 2002-01-08 00:00:00 | 20.5 | 22.5 | 15 | 17
Mead | 2002-01-08 00:00:00 | 19.5 | 21.5 | 14.5 | 15.75
Palo Verde | 2002-01-08 00:00:00 | 18.75 | 22 | 14 | 16.25
Inland SW | 2002-01-08 00:00:00 | 18.75 | 22 | 14 | 16.25
4-Corners | 2002-01-08 00:00:00 | 17.5 | 20.75 | 13.5 | 15
Central Rockies | 2002-01-08 00:00:00 | 17.75 | 18.5 | 14.5 | 16
Spreadsheet: 791330d1660286441-help-with-sumproduct-countif-countifs-index-match-what-to-choose-2022-08-12-oeldere-charliechaz-count-help-with-expected-results
Sheet: PT

Som van U_Docversion | Kolomlabels
Rijlabels | SOP-02659 | SOP-04077 | WRK-00479 | WRK-00577 | WRK-01610 | WRK-01777 | WRK-02123 | WRK-03109 | WRK-03575 | WRK-04933 | Eindtotaal
2015 | 3 | 4 |  |  | 1 |  |  |  |  |  | 8
2016 | 2 | 6 |  |  | 2 |  |  |  |  |  | 10
2017 | 3 | 7 | 1 | 2 | 1 | 1 | 1 | 4 | 2 |  | 22
2018 | 2 | 1 |  |  | 1 |  |  | 1 | 1 |  | 6
2019 | 2 | 1 | 1 |  |  |  |  |  | 2 |  | 6
2020 |  | 4 | 2 | 3 | 1 | 2 | 2 | 4 | 2 |  | 20
2021 |  |  |  |  |  |  |  | 1 |  | 1 | 2
2022 |  | 1 |  |  |  |  | 1 | 1 |  |  | 3
 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 10
Eindtotaal | 14 | 25 | 5 | 6 | 7 | 4 | 5 | 12 | 8 | 1 | 87
Aantal van U_Docversion | Kolomlabels
Rijlabels | SOP-02659 | SOP-04077 | WRK-00479 | WRK-00577 | WRK-01610 | WRK-01777 | WRK-02123 | WRK-03109 | WRK-03575 | WRK-04933 | Eindtotaal
2015 | 15 | 24 |  |  | 6 |  |  |  |  |  | 45
2016 | 14 | 49 |  |  | 27 |  |  |  |  |  | 90
2017 | 21 | 97 | 12 | 13 | 11 | 6 | 6 | 41 | 22 |  | 229
2018 | 15 | 11 |  |  | 3 |  |  | 11 | 12 |  | 52
2019 | 17 | 10 | 10 |  |  |  |  |  | 23 |  | 60
2020 |  | 44 | 25 | 18 | 8 | 14 | 6 | 42 | 20 |  | 177
2021 |  |  |  |  |  |  |  | 20 |  | 12 | 32
2022 |  | 35 |  |  |  |  | 11 | 5 |  |  | 51
 | 12 | 1 | 10 | 13 | 5 | 6 | 4 | 11 | 11 |  | 73
Eindtotaal | 94 | 271 | 57 | 44 | 60 | 26 | 27 | 130 | 88 | 12 | 809
Som van Veld1 | Kolomlabels
Rijlabels | SOP-02659 | SOP-04077 | WRK-00479 | WRK-00577 | WRK-01610 | WRK-01777 | WRK-02123 | WRK-03109 | WRK-03575 | WRK-04933 | Endtotal
2015 | 47.25 | 159.6 | 0 | 0 | 14.4 | 0 | 0 | 0 | 0 | 0
2016 | 45.73333333333333 | 1039.616666666667 | 0 | 0 | 558.9 | 0 | 0 | 0 | 0 | 0
2017 | 101.15 | 4095.016666666667 | 52.8 | 37.7 | 94.78333333333333 | 4.2 | 3.6 | 752.35 | 185.5333333333333 | 0
2018 | 50.75 | 48.4 | 0 | 0 | 6.9 | 0 | 0 | 62.51666666666667 | 93.6 | 0
2019 | 65.16666666666667 | 43.33333333333334 | 40 | 0 | 0 | 0 | 0 | 0 | 405.5666666666667 | 0
2020 | 0 | 522.1333333333333 | 265.8333333333333 | 75.6 | 50.13333333333333 | 40.13333333333333 | 4.2 | 933.1 | 360 | 0
2021 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 266.6666666666667 | 0 | 134.4
2022 | 0 | 449.1666666666667 | 0 | 0 | 0 | 0 | 18.15 | 15.41666666666667 | 0 | 0
 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 729139d1618927498-find-top-highest-largest-values-on-the-basis-of-criteria-sample-file-for-excel-forum
Sheet: Sheet1

Index | OI
15000 | 4406 |  | Current Index | 16372 |  |  | The index value must be above current index value
15100 | 7898 |  |  |  |  |  | Result Required
15200 | 6261 |  |  |  |  |  | Top 6 highest / largest values
15300 | 6551 |  |  |  |  |  | Index | OI
15400 | 24440 |  |  |  |  | 1 | 16400 | 38938
15500 | 11998 |  |  |  |  | 2 | 16500 | 10278
15600 | 12996 |  |  |  |  | 3 | 16700 | 11136
15700 | 16077 |  |  |  |  | 4 | 16900 | 34594
15800 | 9335 |  |  |  |  | 5 | 17400 | 21691
15900 | 40931 |  |  |  |  | 6 | 17900 | 27275
16000 | 10218
16100 | 16302
16200 | 16527
16300 | 10058
16400 | 38938
16500 | 10278
16600 | 8441
16700 | 11136
16800 | 6269
16900 | 34594
17000 | 2748
17100 | 5860
17200 | 3319
17300 | 2577
17400 | 21691
17500 | 3185
17600 | 1541
17700 | 1466
17800 | 1486
17900 | 27275
Spreadsheet: 131089d1322735117-or-nested-in-countifs-workbook1
Sheet: Sheet2

 | Located in D, F, or G | Located in F, G, or K | Located in G or J
Spreadsheet: joe_parks__14986__BridgeDPR0520
Sheet: Bridgeline DPR2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BRIDGELINE GAS MARKETING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAILY POSITION REPORT
 |  | Position |  |  | Maturity / Gap Risk |  |  | Value-at-Risk |  |  |  | P&L ($000)
Business Unit - Commodity Group |  | Net Open | Limit |  | Sensitivity | Limit |  | 1-Day |  | Limit |  | Today | 5 Day Rolling | MTD | QTD | YTD |  | Yesterday's MTD | Yesterday's QTD | Yesterday's YTD
BRIDGELINE GAS MARKETING
GAS TRADING |  |  | 15 Bcf |  |  |  |  |  |  | 2000
1 Month |  |  |  |  |  | 9 Bcf 1 Month
2-12 Months |  |  |  |  |  | 25 Bcf 2-12 Months
13-18 Months |  |  |  |  |  | 5 Bcf 13-18 Months
TOTAL TRADING
Notes to File
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MTD | QTD | YTD
 |  |  |  |  |  |  |  |  |  |  |  |  | ENRON NORTH AMERICA | 2155.232515900004 | 4158.232515900004 | 9449.232515900003
 |  |  |  |  |  |  |  |  |  |  |  |  | GAS TRADING | 2155.232515900004 | 4158.232515900004 | 9449.232515900003
 | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | -2243.48
 |  |  |  |  |  |  |  |  |  | 998027.0603850778
Spreadsheet: 91087d1290772277-returning-information-from-separate-workbook-based-on-cell-text-par-test
Sheet: T-0

60 SECOND PAR REPORT FOR WORK WEEK |  |  |  |  |  |  |  |  |  | 47 |  |  |  |  |  |  |  |  | #N/A
WO # | TASK # | UNIT # | USI # | EQUIP # | WORK ORDER DESC | STATUS | TARGET START | DELAY | SCR # | NOTES
crew 1
 | OF |  | COMP = |  | COMPLIANCE
100003 | 2 | 2 | 411 | P2 | TEST INFORMATION 2 DELAY 1 | DELAYED | 2010-11-15 00:00:00 | CON | 15512 | Test notes
100005 | 2 | 3 | 411 | P4 | TEST INFORMATION 4 DELAY 2 | DELAYED | 2010-11-15 00:00:00 | ENG | 15513 | Test notes
100014 | 11 | 4 | 411 | P13 | TEST INFORMATION 13 DELAY 3 | DELAYED | 2010-11-15 00:00:00 | KB | 15514 | Test notes
100025 | 1 | 2 | 411 | P1 | TEST INFORMATION 1 DELAY 4 | DELAYED | 2010-11-16 00:00:00 | SB | 15515 | Test notes
100030 | 4 | 3 | 411 | P6 | TEST INFORMATION 6 DELAY 5 | DELAYED | 2010-11-16 00:00:00 | ENG | 15516 | Test notes
100037 | 11 | 4 | 411 | P13 | TEST INFORMATION 13 DELAY 7 | DELAYED | 2010-11-16 00:00:00 | KB | 15517 | Test notes
100040 | 1 | 2 | 411 | P1 | TEST INFORMATION 1 DELAY 8 | DELAYED | 2010-11-17 00:00:00 | TE | 15518 | Test notes
100045 | 4 | 3 | 411 | P6 | TEST INFORMATION 6 DELAY 9 | DELAYED | 2010-11-17 00:00:00 | CON | 15519 | Test notes
100052 | 11 | 4 | 411 | P13 | TEST INFORMATION 13 DELAY 10 | DELAYED | 2010-11-17 00:00:00 | KB | 155120 | Test notes
crew2
 | OF |  | COMP = |  | COMPLIANCE
100003 | 2 | 2 | 411 | P2 | TEST INFORMATION 2 DELAY 1 | DELAYED | 2010-11-15 00:00:00 | CON | 20001 | Test notes
100099 | 2 | 3 | 411 | P4 | TEST INFORMATION 4 DELAY 2 | DELAYED | 2010-11-15 00:00:00 | SB | 20002 | Test notes
100094 | 11 | 4 | 411 | P13 | TEST INFORMATION 13 DELAY 3 | DELAYED | 2010-11-15 00:00:00 | KB | 20004 | Test notes
100035 | 1 | 2 | 411 | P1 | TEST INFORMATION 1 DELAY 4 | DELAYED | 2010-11-16 00:00:00 | SB | 30005 | Test notes
100085 | 4 | 3 | 411 | P6 | TEST INFORMATION 6 DELAY 5 | DELAYED | 2010-11-16 00:00:00 | WGC | 30006 | Test notes
100091 | 11 | 4 | 411 | P13 | TEST INFORMATION 13 DELAY 7 | DELAYED | 2010-11-16 00:00:00 | WKR | 30007 | Test notes
100055 | 1 | 2 | 411 | P1 | TEST INFORMATION 1 DELAY 8 | DELAYED | 2010-11-17 00:00:00 | SB | 30008 | Test notes
100066 | 4 | 3 | 411 | P6 | TEST INFORMATION 6 DELAY 9 | DELAYED | 2010-11-17 00:00:00 | WKR | 300015 | Test notes
crew3
 | OF |  | COMP = |  | COMPLIANCE
crew4
 | OF |  | COMP = |  | COMPLIANCE
Spreadsheet: f631d7d0-3f1e-49f5-9a9b-339548129e97
Sheet: Sheet1

 | First Name | Last Name | City | Country | club
1 | Annabel | Bouton | PUYGAILLARD DE QUERCY | France
2 | Leah | Carroll | [NAME] | United States
3 | MARINE | CIAMOS | [NAME] | France
4 | [NAME] | [NAME] | Odense | Denmark
5 | Mathilde | [NAME] | [NAME] | France
6 | Bibben | [NAME] | Karlstad | Sweden
7 | Ane | Ramnefjell | Sykkylven | Norway
 | 7 | 7 | 7 | 7
Spreadsheet: 30601d1226197097-moving-data-sample-spreadsheet
Sheet: Sheet1

numbers |  |  | 1's colume | 2's colume | 3'scolume | 4's colume
1st  # 342 |  |  |  | 1 | 1 | 1
2nd#   132 |  |  | 1 | 1 | 1
3rd#   214 |  |  | 1 | 1 |  | 1
"
"
"
 |  | Go all the way to ten columes
Spreadsheet: 838964d1691566947-copying-a-number-to-a-different-column-and-specific-number-of-rows-copynumber
Sheet: desired result

7330 | 7330
7330 | 7330
7330 | 24558
7330 | 470812
7330 | 653373
7330 | 82640
7330
7330 | 7330
7330 | 7330
7330 | 7330
25226 | 25226
25226 | 25226
25226 | 581500
25226
25226 | 25226
25226 | 25226
25226 | 25226
82664 | 82664
82664 | 82664
82664 | 82480
82664
82664 | 82664
82664 | 82664
82664 | 82664
6060 | 6060
6060 | 6060
6060 | 1921
6060 | 19462
6060 | 481899
6060 | 57601
6060 | 653442
6060 | 82495
6060 | 82593
6060 | 494147
6060 | 668527
6060
6060 | 6060
6060 | 6060
6060 | 6060
Spreadsheet: 7f4f71ab-4fec-4148-9937-9f21486049fa
Sheet: 18

Product* | February 21 | February 28 | March 7 | March 14 | March 21
Total**
Non-Deliverable Forwards | N/A | N/A | N/A | N/A | N/A
Options | N/A | N/A | N/A | N/A | N/A
Forwards | N/A | N/A | N/A | N/A | N/A
Swaps | N/A | N/A | N/A | N/A | N/A
OTHER | N/A | N/A | N/A | N/A | N/A
TOTAL
Gross notional amount outstanding, March 21 weekly snapshot, by product type, all participant types, tenors and currencies.
*See Data Dictionary for product descriptions and Explanatory Notes for data sources.
**These numbers are estimates.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 789715d1659320936-let-and-unique-function-for-older-excel-version-daf-summary-data-aligw
Sheet: Sheet1

U | A |  | U | C
1-1 | X |  |  | 3 |  | Count
1-1 | X |  | 1-2 | 2
1-1 | X |  | 1-3 | 1
1-2 | X |  | 2-1 | 1
1-2 | X |  | 2-2 | 0
1-3 | X |  | 2-3 | 0
2-1 | X
2-2
2-3
Spreadsheet: 181585d1348079515-totaling-a-colum-if-another-colum-is-of-set-value-pretend
Sheet: Sheet1

2012-06-07 00:00:00 | 61831 |  | 90 | 30.65 | 19.35 | 11 | 1 | 1 | 1
2012-07-02 00:00:00 | 61831 |  | 0 | 0 | 0 | 11 | 1 | 1 | 1
2012-07-17 00:00:00 | 61831 |  | 145 | 64.45 | 40.55 | 11 | 1 | 1 | 1
2012-07-17 00:00:00 | 75306 |  | 0 | 0 | 0 | 11 | 1 | 1 | 1
2012-08-23 00:00:00 | 75182 |  | 0 | 0 | 0 | 11 | 1 | 1 | 1
2012-03-15 00:00:00 | 33911 |  | 180 | 65.27 | 74.73 | 11 | 1 | 1 | 1
2012-04-11 00:00:00 | 33911 |  | 0 | 0 | 0 | 11 | 2 | 1 | 1
2012-05-11 00:00:00 | 73934 |  | 225 | 123.8 | 71.2 | 11 | 2 | 1 | 1
2012-07-06 00:00:00 | 73934 |  | 0 | 0 | 0 | 11 | 2 | 1 | 1
2012-08-17 00:00:00 | 73934 |  | 145 | 88.46 | 26.54 | 11 | 2 | 1 | 1
2012-01-09 00:00:00 | 72582 |  | 180 | 131.35 | 48.65 | 11 | 2 | 1 | 1
2012-01-09 00:00:00 | 72582 |  | 0 | 0 | 0 | 11 | 2 | 1 | 1
2012-05-31 00:00:00 | 43326 |  | 0 | 0 | 0 | 11 | 5 | 1 | 1
2012-02-13 00:00:00 | 18019 |  | 90 | 32.75 | 27.25 | 11 | 3 | 1 | 1
2012-07-02 00:00:00 | 45984 |  | 145 | 82.73 | 41.59 | 11 | 3 | 1 | 1
2012-04-10 00:00:00 | 6851 |  | 90 | 55.95 | 20.06 | 11 | 3 | 1 | 1
2012-04-26 00:00:00 | 6851 |  | 0 | 0 | 0 | 11 | 3 | 1 | 1
2012-02-10 00:00:00 | 61166 |  | 90 | 55 | 0 | 11 | 3 | 1 | 1
2012-04-04 00:00:00 | 73715 |  | 225 | 98.4 | 76.6 | 11 | 4 | 1 | 1
2012-04-27 00:00:00 | 73715 |  | 0 | 0 | 0 | 11 | 4 | 1 | 1
2012-04-25 00:00:00 | 32196 |  | 145 | 64.45 | 40.55 | 11 | 4 | 1 | 1
2012-06-08 00:00:00 | 32196 |  | 145 | 64.45 | 40.55 | 11 | 4 | 1 | 1
2012-07-10 00:00:00 | 32196 |  | 0 | 0 | 0 | 11 | 4 | 1 | 1
2012-07-11 00:00:00 | 32196 |  | 0 | 0 | 0 | 11 | 4 | 1 | 1
2012-03-21 00:00:00 | 2733 |  | 0 | 0 | 0 | 11 | 4 | 1 | 1
2012-01-30 00:00:00 | 73035 |  | 115 | 0 | 0 | 11 | 5 | 1 | 1
2012-03-21 00:00:00 | 73035 |  | 0 | 0 | 0 | 11 | 5 | 1 | 1
2012-04-02 00:00:00 | 73035 |  | 0 | 0 | 0 | 11 | 5 | 1 | 1
2012-04-10 00:00:00 | 73035 |  | 0 | 0 | 0 | 11 | 5 | 1 | 1
2012-02-17 00:00:00 | 67541 |  | 90 | 55.95 | 20.06 | 11 | 5 | 1 | 1
2012-03-13 00:00:00 | 67541 |  | 0 | 0 | 0 | 11 | 6 | 1 | 1
2012-06-11 00:00:00 | 74447 |  | 285 | 225.95 | 59.05 | 11 | 6 | 1 | 1
2012-04-18 00:00:00 | 30854 |  | 225 | 80 | 115 | 11 | 6 | 1 | 1
2012-01-18 00:00:00 | 72519 |  | 260 | 128.89 | 98.89 | 11 | 6 | 1 | 1
2012-02-22 00:00:00 | 72519 |  | 0 | 0 | 0 | 11 | 18 | 1 | 1
2012-05-02 00:00:00 | 74138 |  | 180 | 0 | 64.15 | 11 | 18 | 1 | 1
2012-05-25 00:00:00 | 74138 |  | 0 | 0 | 0 | 11 | 18 | 1 | 1
2012-02-01 00:00:00 | 61869 |  | 0 | 0 | 0 | 11 | 18 | 1 | 1
2012-07-11 00:00:00 | 75165 |  | 350 | 159.91 | 150.11 | 11 | 18 | 1 | 1
2012-01-10 00:00:00 | 66086 |  | 145 | 85.38 | 14.62 | 11 | 18 | 1 | 1
2012-02-16 00:00:00 | 66086 |  | 90 | 31.53 | 13.47 | 11 | 23 | 1 | 1
2012-06-07 00:00:00 | 66086 |  | 0 | 0 | 0 | 11 | 23 | 1 | 1
2012-03-06 00:00:00 | 49443 |  | 90 | 55.95 | 20.06 | 11 | 23 | 1 | 1
2012-04-10 00:00:00 | 49443 |  | 0 | 0 | 0 | 11 | 23 | 1 | 1
2012-04-03 00:00:00 | 18136 |  | 90 | 55.95 | 20.06 | 11 | 23 | 1 | 1
2012-05-29 00:00:00 | 18136 |  | 145 | 82.73 | 41.59 | 11 | 24 | 1 | 1
2012-07-31 00:00:00 | 18136 |  | 0 | 0 | 0 | 11 | 24 | 1 | 1
Spreadsheet: 135972d1326344562-excel-2007-rank-if-formula-market-rank
Sheet: Sheet1

Name | Commission Sold | Market | Overall Rank | Market Rank
Agent 1 | 993514.709999999 | 2 | 1 | 1
Agent 2 | 990387.819999999 | 1 | 2 | 1
Agent 3 | 733533.989999999 | 5 | 3 | 1
Agent 4 | 717247.719999999 | 3 | 4 | 1
Agent 5 | 662742.259999999 | 6 | 5 | 1
Agent 6 | 660431.459999999 | 5 | 6 | 2
Agent 7 | 619894.87 | 3 | 7 | 2
Agent 8 | 604983.019999999 | 1 | 8 | 2
Agent 9 | 590508.1 | 3 | 9 | 3
Agent 10 | 567975.209999999 | 6 | 10 | 2
Agent 11 | 562927.729999999 | 5 | 11 | 3
Agent 12 | 561665.36 | 5 | 12 | 4
Agent 13 | 557863.429999999 | 4 | 13 | 1
Agent 14 | 555942.289999999 | 5 | 14 | 5
Agent 15 | 551981.819999999 | 2 | 15 | 2
Spreadsheet: lynn_blair__24470__NNGWKednotes_2001
Sheet: July 21 & 22, 2001

NNG WEEKEND NOTES
For cc Mail distribution:  [NAME], [NAME], [NAME], S. January, [NAME], [NAME], [NAME], TMS OnCall
SATURDAY |  |  | 2001-07-21 00:00:00
Mail distribution send to the above listing on Sunday evening.
H:\DATA\Process Guidelines\[NNGWKednotes Template.xls]Dec 25 & 26
 | PROCESS |  |  |  | COMMENTS:
 | Gas Day: | SAT |  |  | Image problem appears to have caused the difficulty and
 | 7:00 A.M. Non-grid: |  |  |  | ORB received during the Allocation process.  [NAME] repaired
 |  |  |  |  | after shutting down the image and re-retrieving.  Original rollback
 |  |  |  |  | did not save properly (still allocated  POI#1709 after point was
 |  |  |  |  | updated during the second allocation process.  Discussed w/
 |  |  |  |  | Wayne, rolled back again, and proceeded as usual.  Confirmations
 |  |  |  |  | cycle had to be checked due to extended time to complete.  Image
 |  |  |  |  | to be recovered.  No further difficulties-cycle complete at 10:50 a.m.//sf
 | Gas Day: | FRI |  |  | Storage was allocated ID2.
 | 8:00 AM Final Storage |  |  |  | No difficulties with this process.
 | Gas Day: | SAT |  |  | No difficulties with this process.
 | 10:00 A.M. Intraday 1:
 | Gas Day: | SAT |  |  | No difficulties with this process.
 | 5:00 P.M. Intraday 2:
 | Gas Day: | SUN |  |  | No difficulties with this process.
 | 11:30 A.M. Timely
 | Gas Day: | SUN |  |  | No difficulties with this process.
 | 6:00 P.M. Evening
 | Other Comments: |  |  |  | "Team EDI" continued to be unavailable for viewing.  [NAME] had
 |  |  |  |  | notified [NAME] of this problem Friday evening.
 | On Call Reps. |  |  |  | [NAME] |  | 6:30 - 3:30
 |  |  |  |  | [NAME] |  | 6:30 - 3:30
 |  |  |  |  | [NAME] |  | 1:00 - 10:00
 |  |  |  |  | [NAME] |  | 1:00 - 10:00
SUNDAY
 | PROCESS |  |  |  | COMMENTS:
 | Gas Day: | SUN |  |  | No difficulties with this process.
 | 7:00 A.M. Non-grid:
 | Gas Day: | SAT |  |  | No difficulties with this process.
 | 8:00 AM Final Storage
 | Gas Day: | SUN |  |  | No difficulties with this process.
 | 10:00 A.M. Intraday 1:
 | Gas Day: | SUN |  |  | No difficulties with this process.
 | 5:00 P.M. Intraday 2:
 | Gas Day: | MON |  |  | No difficulties with this process.
 | 11:30 A.M. Timely |  |  |  | Northern Border had unscheduled compressor outage  on four station.
 | Gas Day: | MON |  |  | No difficulties with this process.
 | 6:00 P.M. Evening
 | Other Comments: |  |  |  | US Energy had EDI " late nomination" message on our web. Site for gas day July 22. [NAME] determine the problem was on US Energy side at the Hub. Called [NAME]  to remove the messages from the EDI Hub.
 | On Call Reps: |  |  |  | [NAME] |  | 6:30 - 3:30
 |  |  |  |  | [NAME] |  | 6:30 - 3:30
 |  |  |  |  | [NAME] |  | 1:00 - 10:00
 |  |  |  |  | [NAME] |  | 1:00 - 10:00
Spreadsheet: darrell_schoolcraft__7805__imbalsumm0108
Sheet: SoCal

 | 10487 |  | 56697
Day | Measured | Scheduled | Measured | Scheduled
1 | -783122 | -801047 | -40000 | -40000
2 | -765413 | -746994 | -39998 | -40000
3 | -751586 | -748805 | -39999 | -40000
4 | -739284 | -742991 | -101
5 | -714787 | -734668
6 | -734353 | -750409 | -9877 | -10000
7 | -729199 | -722209 | -25859 | -25000
8 | -719904 | -715180 | -27002 | -25000
9 | -725690 | -722897 | -51038 | -50000
10 | -740803 | -742788 | -51972 | -50000
11 | -752259 | -753379 | -124
12 | -743592 | -743981 | -51599 | -50000
13 | -722904 | -722201 | -20107 | -20000
14 | -711618 | -701605
15 | -679140 | -681609
16 | -674938 | -699370 | -25872 | -25000
17 | -694068 | -664964 | -25122 | -25000
18 | -715015 | -718391 | -185
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  |  |  | 145102
2001-08-18 00:00:00
CBS Dollars
 |  |  | 448413.9
Spreadsheet: 539864d1506412103-sum-using-multipul-vookup-mz-sales-budget-plan-2018-working
Sheet: 62200

AM Bahawalpur | Plan FY | Actual YTD | [NAME] | 4Q OL | [NAME] | [NAME]
[PHONE] STAFF MEETINGS,ENTT | 9000 | 0
[PHONE] OTH-REPAIRS/MAINT | 3000 | 0
[PHONE] PRINTING/STATIONERY | 0 | 3720
[PHONE] BOOKS PERIODICALS | 2000 | 0
[PHONE] OFF FURN/EQP M&R | 7000 | 0
[PHONE] COMPUTER MAINT | 4000 | 1750
[PHONE] REPRODUCTION CHG | 2000 | 0
[PHONE] POSTAGE CHG | 9000 | 3805
[PHONE] TELEPHONES CHG | 34000 | 50784
[PHONE] INTERNET USAG CHG | 12000 | 10000
[PHONE] RECOV FOR PVT.TEL | 0 | -1500
[PHONE] LOCAL-BUSS TRAVEL | 67000 | 133138
[PHONE] REGIS & TAXES | 5000 | 8320
[PHONE] POL & SERVICES | 144000 | 122983.68
[PHONE] REP  PARTS & ACCESS | 12000 | 35500
[PHONE] PRIVATR MILEAGE | -24000 | -67691
[PHONE] OTH-VEH-TRAV EXP | 0 | 0
[PHONE] OTHERS-GR/PR EXP. | 4000 | 2810
[PHONE] BUS. MEETING & ENT. | 17000 | 1820
[PHONE] TAXES STAMPS & LICS | 0 | 4640
Spreadsheet: b3736972-f1d5-4af6-a6e8-f3befb94a7c2
Sheet: PF Income Statement YTD

The NASDAQ OMX Group, Inc.
Pro Forma Condensed Consolidated Statements of Income
(in millions, except per share amounts)
(unaudited)
 |  | Year Ended
 |  | December 31, |  | December 31,
 |  | 2008 |  | 2007
Revenues
Market Services |  | 3380 |  | 2686.8
Cost of revenues:
Liquidity rebates |  | -1752.3 |  | -1055.8
Brokerage, clearance and exchange fees |  | -447.8 |  | -576.2
Total cost of revenues
Total Market Services revenues less liquidity rebates,
brokerage, clearance and exchange fees
Issuer Services revenues |  | 341.2 |  | 344.5
Market Technology revenues |  | 126.2 |  | 119
Other revenues |  | 5.2 |  | 2.4
Total revenues less liquidity rebates, brokerage,
clearance and exchange fees
Expenses
Compensation and benefits |  | 468.1 |  | 446.6
Marketing and advertising |  | 20.5 |  | 31.1
Depreciation and amortization |  | 116.6 |  | 120
Professional and contract services |  | 89.1 |  | 94
Computer operations and data communications |  | 69.1 |  | 76.1
Occupancy |  | 72.6 |  | 69.4
Regulatory |  | 28.9 |  | 28.9
Merger expenses |  | 25.4 |  | 0
General, administrative and other |  | 76.1
Total operating expenses
Operating income
Other income (expense), net
Interest income |  | 29.8 |  | 39.2
Interest expense |  | -119 |  | -161.2
Dividend and investment income |  | 10.1 |  | 3
Income (loss) from unconsolidated investees, net |  | 1 |  | -0.9
Gain (loss) on foreign currency contracts |  | -57.9 |  | 51.8
Asset impairment charges |  | -42.2 |  | 0
Capital gains from shares in equity investments |  | 0 |  | 15.2
Total other income (expense), net
Minority interests |  | -0.8 |  | -0.9
Income before income taxes
Income tax provision |  | 192.1 |  | 151.7
Net income
Basic and diluted earnings per share:
Basic |  | 1.58 |  | 1.9
Diluted |  | 1.48 |  | 1.62
Weighted-average common shares
outstanding for earnings per share:
Basic |  | 200 |  | 176.6
Diluted |  | 214.1 |  | 213.1
Spreadsheet: 140579d1328810469-dropdown-menus-with-filtering-0139
Sheet: Lists

Location Area | 3rd floor Admin area | Bar | Clasp offices | Dining
_3rd_floor_Admin_area | Accounts office | Bar cellar | Office 12 | Mezzanine
Bar | Admin toilets | Bar store 19 | Office 13a | [NAME]
Clasp_offices | BD office | Bar wine store | Office 13b | [NAME]
Dining | IT office | [NAME]'s bar (Back of house) | Office 14a | Cedar Restaurant
 | Johns office | [NAME]'s bar (FOH) | Office 14b | Dining room 3/4
 | [NAME] office | Games Room | Office corridor | Dining room 5
 | [NAME]'s office | Bar entrance foyer |  | DR 5 corridor
 | PA's office
 | Personnel office
 | Trainers office
 | [NAME] office
 | Server room
Location Area | Location
_3rd_floor_Admin_area | IT office
Bar | [NAME]'s bar (Back of house)
Clasp_offices | Office 14a
Dining | Dining room 3/4
_3rd_floor_Admin_area | Personnel office