tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 009decd9-b43e-4416-b868-a83ad039ee62
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | Central | IBC | NEPA | Highmark | Totals
 | ADAMS | 185 |  |  |  | 185
 | ALLEGHENY |  |  |  | 5022 | 5022
 | ARMSTRONG |  |  |  | 461 | 461
 | BEAVER |  |  |  | 865 | 865
 | BEDFORD |  |  |  | 331 | 331
 | BERKS | 1077 |  |  |  | 1077
 | BLAIR |  |  |  | 677 | 677
 | BRADFORD |  |  | 183 |  | 183
 | BUCKS |  | 1827 |  |  | 1827
 | BUTLER |  |  |  | 859 | 859
 | CAMBRIA |  |  |  | 1255 | 1255
 | CAMERON |  |  |  | 46 | 46
 | CARBON |  |  | 229 |  | 229
 | CENTRE | 365 |  |  | 139 | 504
 | CHESTER |  | 935 |  |  | 935
 | CLARION |  |  |  | 231 | 231
 | CLEARFIELD |  |  |  | 797 | 797
 | CLINTON |  |  | 140 |  | 140
 | COLUMBIA | 210 |  |  |  | 210
 | CRAWFORD |  |  |  | 521 | 521
 | CUMBERLAND | 393 |  |  |  | 393
 | DAUPHIN | 578 |  |  |  | 578
 | DELAWARE |  | 1984 |  |  | 1984
 | ELK |  |  |  | 327 | 327
 | ERIE |  |  |  | 2044 | 2044
 | FAYETTE |  |  |  | 998 | 998
 | FOREST |  |  |  | 30 | 30
 | FRANKLIN | 363 |  |  |  | 363
 | FULTON | 49 |  |  |  | 49
 | GREENE |  |  |  | 295 | 295
 | HUNTINGDON |  |  |  | 268 | 268
 | INDIANA |  |  |  | 585 | 585
 | JEFFERSON |  |  |  | 323 | 323
 | JUNIATA | 82 |  |  |  | 82
 | [NAME] |  |  | 560 |  | 560
 | LANCASTER | 835 |  |  |  | 835
 | [NAME] |  |  |  | 559 | 559
 | LEBANON | 220 |  |  |  | 220
 | LEHIGH | 818 |  |  |  | 818
 | LUZERNE |  |  | 922 |  | 922
 | LYCOMING |  |  | 217 |  | 217
 | MCKEAN |  |  |  | 242 | 242
 | MERCER |  |  |  | 614 | 614
 | MIFFLIN | 233 |  |  |  | 233
 | MONROE |  |  | 450 |  | 450
 | MONTGOMERY |  | 2230 |  |  | 2230
 | MONTOUR | 25 |  |  |  | 25
 | NORTHAMPTON | 549 |  |  |  | 549
 | NORTHUMBERLAND | 294 |  |  |  | 294
 | PERRY | 139 |  |  |  | 139
 | PHILADELPHIA |  | 8957 |  |  | 8957
 | PIKE |  |  | 143 |  | 143
 | POTTER |  |  |  | 164 | 164
 | SCHUYLKILL | 370 |  |  |  | 370
 | SNYDER | 94 |  |  |  | 94
 | [NAME] |  |  |  | 655 | 655
 | SULLIVAN |  |  | 25 |  | 25
 | SUSQUEHANNA |  |  | 222 |  | 222
 | TIOGA |  |  | 157 |  | 157
 | UNION | 68 |  |  |  | 68
 | VENANGO |  |  |  | 354 | 354
 | WARREN |  |  |  | 239 | 239
 | WASHINGTON |  |  |  | 994 | 994
 | WAYNE |  |  | 150 |  | 150
 | WESTMORELAND |  |  |  | 2169 | 2169
 | WYOMING |  |  | 81 |  | 81
 | YORK | 704 |  |  |  | 704
 | Totals | 7651 | 15933 | 3479 | 22064 | 49127
Spreadsheet: 1b09c658-948a-4184-a432-a3c62bd9d0a4
Sheet: 2

 | February 28 | March 7 | March 14 | March 21 | March 28
Total Interest Rate* | 688557647.21 | 697784147.6999999 | 700078388.08 | 671031451.1
SDs and MSPs** | 565392828.11 | 572243837.4 | 583197570.6 | 556141562.7 | 564848860.53
Other | 123164819.1 | 125540310.3 | 116880817.48 | 114889888.4 | 116560168.65
Total Cross-Currency | 32530129.8315 | 32712345 | 32654281.0583 | 32401738
SDs and MSPs | 29017778.617 | 29165882 | 29472694.672 | 29042953 | 28697052.432
Other | 3512351.2145 | 3546463 | 3181586.3863 | 3358785 | 3373151.2479
Total Credit | 17042259.9503 | 17351102 | 17247456.0975 | 16860385
SDs and MSPs | 13245567.226 | 13425965 | 13317728.301 | 12957592 | 12329270.583
Other | 3796692.7243 | 3925137 | 3929727.7965 | 3902793 | 3789475.5089
Total FX**** | 62900000 | 62900000 | 62900000 | 62900000 | 62900000
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
Total Equity**** | 8840000 | 8840000 | 8840000 | 8840000 | 8840000
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
Total Other Commodity**** | 3400000 | 3400000 | 3400000 | 3400000 | 3400000
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
TOTAL | 813270036.9918001 | 822987594.6999999 | 825120125.2358 | 795433574.1
Weekly snapshot, gross notional amount outstanding by asset class and participant type (millions of USD), all products, origins, currencies, tenors, and participant types, cleared and uncleared. For cleared swaps, the notional value for each of the two resulting swaps is attributed only to the counterparty facing the clearing organization (i.e., the clearing organization’s participation is not displayed). For uncleared swaps, the notional value of the swap is attributed to both swap counterparties. Because this table shows the aggregated notional values of swaps by participant, the totals on this table are twice those displayed on the "Gross Notional Outstanding by Cleared Status" table.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type descriptions.
***N/A indicates that data are not currently available.
****These numbers are estimates.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 132255d1323649035-formula-help-needed-leagues-2012
Sheet: Grand League

Shows |  |  |  | [NAME] | RWAS Smallholders | [NAME] | Stafford | Three Counties | Norfolk | GYS | Gatcombe BE | New Forest | Bakewell | Gillingham & Shaftsbury | Ashbourne | Berkeley | Monmouth | Frome | Newbury | Points
Driver |  | [NAME]
Derek | [NAME] | Bonnie & Clyde | S
Carole | Davenport | Wait & See | S
[NAME] | Eldridge | Mix & Match | S
[NAME] | [NAME] | Bobbie & Dazzler | S
Christine | Legate-Baggs | His & Hers | S
[NAME] | Litchfield | G & T | S
[NAME] | Marson | Gower Boys | S
[NAME] | Morris | Chalk & Cheese | S
[NAME] | Morris | Posh & Becks | S
[NAME] | Scott | Beauty & The Beast | S
Philippa | Scott | Wallace & Gromit | S
[NAME] | [NAME] | Jekyle & Hyde | S
Derek | [NAME] | Judge & Jury | L
[NAME] | Bean | Dun & Dusted | L
[NAME] | Eldridge | Just & Do It | L
[NAME] | [NAME] |  | L
[NAME] | Kinsella | Samson & Delilah | L
Christine | Legate-Baggs |  | L
[NAME] | Litchfield | Thunder & Lightning | L
[NAME] | Marson | [NAME] | L
Shelbie | McCullock | Pixie & Dixie | L
[NAME] | Morris | Suited & Booted | L
[NAME] | Mountain | Song & Dance | L
[NAME] | Scott | [NAME] | L
Philippa | Scott |  | L
[NAME] | Scott | Smokey & The Bandit | L
Trevor | Fairburn | Bangers & Mash
Trevor | Fairburn
[NAME] | Scott |  | S
[NAME] | Sycamore |  | S
[NAME] | Sycamore |  | S
[NAME] | [NAME] |  | S
Spreadsheet: 107372d1304549780-if-error-min-max
Sheet: Sheet1

size | [NAME] wide | [NAME] high |  | size | min wide | min high
820/890 | 44 | 72 |  | 820/890 | 16 | 26.5
830/840 | 72 | 60 |  | 830/840 | 26.5 | 14
3000A | 44 | 40 |  | 3000A | 32 | 16
870 | 72 | 60 |  | 870 | 26.5 | 14
850/860 | 118 | 60 |  | 860 | 58 | 14
880 | 118 | 60 |  | 880 | 58 | 17
3000A | 48 | 40 |  | 3000A | 21 | 16
3000F | 72 | 84 |  | 3000F | 18 | 21
3002F | 144 | 84 |  | 3002F | 36 | 21
3003F | 216 | 84 |  | 3003F | 54 | 21
3004F | 288 | 84 |  | 3004F | 72 | 21
3005F | 360 | 84 |  | 3005F | 90 | 21
3000fg | 72 | 84 |  | 3000fg | 16 | 16
3002fg | 144 | 84 |  | 3002fg | 32 | 16
[NAME] | 216 | 84 |  | [NAME] | 48 | 16
3004fg | 288 | 84 |  | 3004fg | 64 | 16
3005fg | 360 | 84 |  | 3005fg | 80 | 16
Spreadsheet: 45341d1244100720-nesting-vlookup-in-if-vice-versa-and-pivot-table-686167_jbritt609
Sheet: Jan Cat1

Model | Amount-Cat1 |  |  |  |  |  |  | 500 | -174.29
500 | -174.29 |  |  |  |  |  |  | 750 | -2262.167420000004
750 | -2262.167420000004 |  |  |  |  |  |  | 900 | 0
AB | -661.97716 |  |  |  |  |  |  | AB | -661.97716
AD | -53.8898 |  |  |  |  |  |  | AD | -53.8898
AL | -1523.33 |  |  |  |  |  |  | AG | 0
BX | -4056.255 |  |  |  |  |  |  | AL | -1523.33
BZ | -3228.96 |  |  |  |  |  |  | AN | 0
CA | -1841.355 |  |  |  |  |  |  | BX | -4056.255
CB | -402.3125 |  |  |  |  |  |  | BZ | -3228.96
GL | -2868.781915198807 |  |  |  |  |  |  | CA | -1841.355
GM | -221.0269653693443 |  |  |  |  |  |  | CB | -402.3125
MF | -755.3130685052638 |  |  |  |  |  |  | DE | 0
MR | -9278.193647035247 |  |  |  |  |  |  | DF | 0
OA | -328.2282893398016 |  |  |  |  |  |  | DS | 0
OB | -123.2664119982595 |  |  |  |  |  |  | DV | 0
OR | -154.8486199890987 |  |  |  |  |  |  | DX | 0
ZP | -271.5391654515289 |  |  |  |  |  |  | FA | 0
Grand Total | -28205.73496288735 |  |  |  |  |  |  | GL | -2868.781915198807
 |  |  |  |  |  |  |  | GM | -221.0269653693443
 |  |  |  |  |  |  |  | MF | -755.3130685052638
 |  |  |  |  |  |  |  | MR | -9278.193647035247
 |  |  |  |  |  |  |  | OA | -328.2282893398016
 |  |  |  |  |  |  |  | OB | -123.2664119982595
 |  |  |  |  |  |  |  | OR | -154.8486199890987
 |  |  |  |  |  |  |  | RA | 0
 |  |  |  |  |  |  |  | RF | 0
 |  |  |  |  |  |  |  | TM | 0
 |  |  |  |  |  |  |  | ZP | -271.5391654515289
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | Grand Total | -28205.73496288735
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
Spreadsheet: 838929d1691522064-missing-comma-missing-comma
Sheet: Blad1

PUT THE TEXT TOGETHER | "MISSING COMMA" |  |  | DATA 1 | DATA 2 | DATA 3
Flower, Intern, [NAME], Bridge |  |  |  | Flower | Intern | Bird, Bridge
Mountain, Cloud, Car, Sand |  |  |  | Mountain |  | Cloud, Car, Sand
Aeroplane Intern Dance |  |  |  | Aeroplane | Intern | Dance
Table, Fish |  |  |  | Table |  | Fish
Music Intern Mountaineer |  |  |  | Music | Intern | Mountaineer
River, Wind |  |  |  | River |  | Wind
Elephant,  Sea, Bunch |  |  |  | Elephant |  | Sea, Bunch
Star, Intern, House, Night, Island |  |  |  | Star | Intern | House, Night, Island
Spreadsheet: 7376ae17-ecea-43b5-a627-5cda9d15687f
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
CRYPS | Test | CRYPS | Cryptosporidium Antigen, Feces | Cryptosporidium Ag, F | Enzyme-Linked Immunosorbent Assay (ELISA) | Stool Container: Stool |  |  | 5 | g | Forms: If not ordering electronically, submit a Microbiology Request Form (Supply T244) with the specimen.  Submit only 1 of the following specimens:  Preserved Stool Container/Tube: Preferred: Stool container with 10% buffered formalin preservative (Supply T466) Acceptable: SAF or MF [NAME]: 5 g Specimen Stability Information: Ambient (preferred)/Refrigerated   Unpreserved Stool Container/Tube: Stool container (Supply T288) [NAME]: 5 g Collection Instructions: See Stool Collection Information Sheet in Special Instructions. Specimen Stability Information: Frozen | 1 g | Hemolysis	NA Thawing	Warm reject; Cold OK-note to lab Lipemia	NA Icterus	NA Other	Grossly bloody (containing no visible stool); very mucoid stool | Negative | Monday through Saturday; 1 p.m. | Same day/1 day | 3 days | 1 | 87328 |  |  |  |  | Rochester
CRYPS | [NAME] | FECAL | Fecal |  |  |  | See instructions
CRYPS | Result | 24086 | Cryptosporidium Ag, F | Cryptosporidium Ag, F | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6371-9
Spreadsheet: 123915d1317925089-finding-if-value-is-within-a-range-help-file
Sheet: Sheet1

 |  |  |  |  |  |  |  | Range2 |  | Range4 |  | Range6 |  | Range8
 |  |  |  |  |  |  | Range1 |  | Range3 |  | Range5 |  | Range7
 |  |  |  |  |  | FIX | 34 | 546 | 1058 | 1794
 |  |  |  |  |  | ADJ | 194 | 354 | 802 | 1314 | 1538
 |  |  |  |  | Range 1
 |  |  |  |  | Are there any shelves in this range?
 |  |  |  |  | Range 2
 |  |  |  |  | Are there any shelves in this range?
 |  |  |  |  | Range 3
 |  |  |  |  | Are there any shelves in this range?
 |  |  |  |  | Range 4
 |  |  |  |  | Are there any shelves in this range?
 |  |  |  |  | Range 5
 |  |  |  |  | Are there any shelves in this range?
 |  |  |  |  | Range 6
 |  |  |  |  | Are there any shelves in this range?
 |  |  |  |  | Range 7
 |  |  |  |  | Are there any shelves in this range?
 |  |  |  |  | Range 8
 |  |  |  |  | Are there any shelves in this range?
Spreadsheet: a2d624fc-dba0-4f61-ba8e-d92eccf256fd
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
6034 | 39874 | [NAME] | [NAME] | ITA | 80 | 00:00:00 | 00:00:00 | 00:13:13 | 00:01:07 | [NAME] | 1 | 00:23:21
6034 | 29858 | Eszter | Pap | HUN | 79 | 00:00:00 | 00:00:00 | 00:13:50 | 00:01:08 | 00:09:02 | 2 | 00:23:59
6034 | 39833 | Mira | [NAME] | SVK | 76 | 00:00:00 | 00:00:00 | 00:13:49 | 00:01:16 | 00:10:15 | 3 | 00:25:19
6034 | 41762 | Viktoria | Zavgorodnia | UKR | 77 | 00:00:00 | 00:00:00 | 00:14:38 | 00:01:08 | 00:09:48 | 4 | 00:25:33
6034 | 69374 | Ivana | Kuriackova | SVK | 82 | 00:00:00 | 00:00:00 | 00:14:24 | 00:01:18 | 00:10:28 | 5 | 00:26:08
6034 | 39834 | [NAME] | [NAME] | SVK | 81 | 00:00:00 | 00:00:00 | 00:13:54 | 00:01:29 | 00:11:01 | 6 | 00:26:22
6034 | 29347 | Priscila | Rocha | BRA | 78 | 00:00:00 | 00:00:00 | [NAME] | 00:01:27 | 00:10:22 | 7 | [NAME]
Spreadsheet: 82317d1282315453-locking-cells-based-on-other-cell-value-sample-student-data
Sheet: Sheet1

 |  |  |  |  |  | Data validation lists
Student name | Student ID | New/transfer/graduated | Current course selection | Previous course selection |  | Student type | Course options
[NAME] | 1QF45 |  |  |  |  | New | 3RFT
[NAME] | 1QF78 |  |  |  |  | Transfer | 4DER
[NAME] | 3DG45 |  |  |  |  | Graduated | 3GET
Spreadsheet: 699881d1602806796-need-help-with-adding-two-more-columns-assessment-tracker
Sheet: 1

Teacher: |  |  |  | Student:
Course Name:
Course Code:
 |  |  |  |  |  |  |  |  |  |  | Categories Evaluated |  |  |  |  | unn
Assessment Name | Date Submitted | P/O/C | Overall Expectations | Mark | Out Of | % Grade | Level | Weight |  | Assessment Name | K | T | C | A
Summatives | Date Submitted | P/O/C | Overall Expectations | Mark | Out Of | % Grade | Level | Weight |  | Summatives | K | T | C | A
 |  |  |  |  |  |  |  |  |  | Total:
Total Products |  |  |  | 0.7 |  | Raw Mean Grade:
Total Observations |  |  |  |  |  | Weighted Mean Grade:
Total Conversations
 |  |  |  | 0.3 |  | Raw Mean Grade: |  |  |  | Overall Expectation Tracker
Level 0 |  |  |  |  |  | Weighted Mean Grade: |  |  |  | A1/1.1 |  |  | D1/4.1
Level 1 |  |  |  |  |  |  |  |  |  | A2/1.2 |  |  | D2/4.2
Level 2 |  |  |  |  |  | Final Grade: |  |  |  | A3/1.3 |  |  | D3/4.3
Level 3 |  |  |  |  |  |  |  |  |  | A4/1.4 |  |  | [NAME]
Level 4 |  |  |  |  | Grade on Report Card: |  |  |  |  | A5/1.5 |  |  | D5/4.5
 |  |  |  |  |  |  |  |  |  | A6/1.6 |  |  | D6/4.6
 |  |  |  |  |  |  |  |  |  | B1/2.1 |  |  | E1/5.1
 |  |  |  |  |  |  |  |  |  | [NAME] |  |  | E2/5.2
 |  |  |  |  |  |  |  |  |  | B3/2.3 |  |  | E3/5.3
 |  |  |  |  |  |  |  |  |  | [NAME] |  |  | E4/5.4
 |  |  |  |  |  |  |  |  |  | B5/2.5 |  |  | E5/5.5
 |  |  |  |  |  |  |  |  |  | B6/2.6 |  |  | E6/5.6
 |  |  |  |  |  |  |  |  |  | C1/3.1 |  |  | F1/6.1
 |  |  |  |  |  |  |  |  |  | C2/3.2 |  |  | F2/6.2
 |  |  |  |  |  |  |  |  |  | C3/3.3 |  |  | F3/6.3
 |  |  |  |  |  |  |  |  |  | C4/3.4 |  |  | F4/6.4
 |  |  |  |  |  |  |  |  |  | C5/3.5 |  |  | F5/6.5
 |  |  |  |  |  |  |  |  |  | C6/3.6 |  |  | F6/6.6
Spreadsheet: 020b1087-5be6-489a-aa1f-70297ca3c691
Sheet: Purchase of Equipment

[NAME]
Item # | Item | Year | Purchase Price
 | 2500 Set | 1 | 49.5
 |  | 2 | 50.49
 |  | 3 | 51.5
 |  | 4 | 52.53
 |  | 5 | 53.58
 | 14 ft [NAME] | 1 | 2.13
 |  | 2 | 2.18
 |  | 3 | 2.22
 |  | 4 | 2.26
 |  | 5 | 2.31
 | 25 ft Line Cord | 1 | 3.82
 |  | 2 | 3.89
 |  | 3 | 3.97
 |  | 4 | 4.05
 |  | 5 | 4.13
 | 48 Port Cat 6 Panel | 1 | 247.25
 |  | 2 | 252.19
 |  | 3 | 257.24
 |  | 4 | 262.38
 |  | 5 | 267.63
 | Cat 6 [NAME] | 1 | 2.3
 | 3 ft | 2 | 2.34
 |  | 3 | 2.39
 |  | 4 | 2.44
 |  | 5 | 2.49
Spreadsheet: 54038d1254031631-excel-2007-vlookup-and-match-700977_gmunson
Sheet: Bionic

7 | Bionic
 | Date | Inv | Price
 | 2009-08-03 00:00:00 | 774 | 48.42
 | 2009-07-15 00:00:00 | 35 | 13.99
 | 2009-09-13 00:00:00 | 164 | 69.86
 | 2009-08-19 00:00:00 | 714 | 5
 | 2009-09-15 00:00:00 | 105 | 26.84
 | 2009-08-27 00:00:00 | 50 | 21.45
 | 2009-06-25 00:00:00 | 593 | 52.66
Spreadsheet: 837791d1690441852-remove-blank-in-front-and-back-of-text-number-remove-blank-front-and-back-of-number-or-text-aligw
Sheet: Sheet1

 | Trim | Substitute |  |  |  |  | still have blank front and back of this number
395,000.00 |  |  |  |  |  |  | 395,000.00 | 395,000.00
444,999.00 |  |  |  |  |  |  | 444,999.00 | 444,999.00
90,000.00 |  |  |  |  |  |  | 90,000.00 | 90,000.00
Spreadsheet: 0cae444b-43c3-49b5-9b21-43262bbcbc63
Sheet: Sheet1

FUTURE IMPACT | MOR | SL | SC | CWC | CS | HV | SM | OMZ | AP | MnA | BP | HT
DISPOSAL
Clinker | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0
Sewage |  | 0 | 0 | 0 |  |  |  |  |  |  | 0
Dredge spoil |  | 0 | 0 | 0 |  |  |  |  |  |  | 0
Pharmaceuticals |  | 0 |  |  |  |  |  |  |  |  | 0 | 0
Low-level radioactive waste |  | 0 | 0 |  |  |  |  |  | 0
Radionucleids |  | ? |  |  |  |  |  |  | ?
Chemical cont.: CFCs | ? | ? | ? | ? | ? |  | ? | ? | ? |  | 0 | ?
Chemical cont.: PAHs |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
Large structures (wrecks) |  | 1 | 1 | ? | ? |  | ? | ? | 1 | 1 |  | ?
Munitions |  | 1 | 1 |  |  |  |  |  | ? | ? |  | ?
CO2 |  | 1 |  |  | 2 |  |  |  | 2 | 2 |  | 1
Total impact disposal | 0 | 7 | 6 | 4 | 2 | 1 | 0 | 0 | 5 | 5 | 0 | 1
Mean impact disposal | 0 | 0.5833333333333334 | 0.5 | 0.3333333333333333 | 0.1666666666666667 | 0.08333333333333333 | 0 | 0 | 0.4166666666666667 | 0.4166666666666667 | 0 | 0.08333333333333333
EXPLOITATION
Trawling | 2 | 4 | 3 | 5 | 2 |  | 5 | 2 | 1 |  | 1
Long-lining | 2 | 4 | 4 | 3 | 2 |  | 3 | 2 | 1 |  | 1
Ghost fishing | 1 | 3 | 3 | 3 | 2 |  | 3 | 2 | 2 | 2 |  | ?
Mining | 1 | 1 |  |  |  | 5 | 2 | 1 |  | 3 | 2
Oil and gas |  | 1 | 1 | 1 | 1 |  |  | 1 | 1
Underwater cables | 1 | 1 | 1 | 1 | 1 |  |  | 1 | 1 | 1 |  | 1
Pipelines |  | 4 |  | 2 | 3 |  |  | 3 |  |  | 1
Science | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 0 | 0 | 1 | 1
Acoustics | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | 3 | ?
Total impact exploitation | 7 | 17 | 11 | 14 | 10 | 6 | 15 | 11 | 4 | 5 | 9 | 1
Mean impact exploitation | 0.7777777777777778 | 1.888888888888889 | 1.222222222222222 | 1.555555555555556 | 1.111111111111111 | 0.6666666666666666 | 1.666666666666667 | 1.222222222222222 | 0.4444444444444444 | 0.5555555555555556 | 1 | 0.1111111111111111
ACIDIFICATION & CLIMATE
Ocean acidification | 1 | 2 | 2 | 3 | 1 |  | 1 | 1 | 1 | 1 | 2 | 1
Warming temperature | 1 | 1 | 1 | 2 | 2 |  | 2 | 1 | 1 | 1 | 1
Hypoxia | 0 | 3 | 1 | 1 | 0 |  | 2 | 4 | 0 | 0 | 2
Nutrient loading | 1 | 5 | 5 | 2 | 1 | 0 | 2 | 1 | 2 | 2 | 1 | 1
Stratification | 5 | 5 | 5 | 5 | 2 | 2 | 4 | 5 | 5 | 5 | 5 | 2
Deep circulation shutdown | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
Regional circulation change | ? | 4 | 4 | 4 | 2 | 1 | 4 | 4 | 2 | 2 | 2 | 1
Total impact climate | 13 | 25 | 22 | 22 | 11 | 8 | 20 | 1 | 16 | 16 | 18 | 10
Mean impact climate | 1.857142857142857 | 3.571428571428572 | 3.142857142857143 | 3.142857142857143 | 1.571428571428571 | 1.142857142857143 | 2.857142857142857 | 0.1428571428571428 | 2.285714285714286 | 2.285714285714286 | 2.571428571428572 | 1.428571428571429
GRAND TOTAL | 20 | 49 | 39 | 40 | 23 | 15 | 35 | 12 | 25 | 26 | 27 | 12
GRAND MEAN | 0.8783068783068783 | 2.014550264550265 | 1.621693121693122 | 1.677248677248677 | 0.9497354497354498 | 0.6309523809523809 | 1.507936507936508 | 0.4550264550264551 | 1.048941798941799 | 1.085978835978836 | 1.19047619047619 | 0.541005291005291
Spreadsheet: michelle_lokay__26699__imball0112
Sheet: Citizens-Griffith

 | Citizens-Griffith
 | POI 78069 - Citizens Griffith
Day | Measured | Scheduled
1 | -73
2 | -57
3 | -52667 | -50314
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
2001-11-30 00:00:00 |  |  | 51396
2001-12-03 00:00:00
CBS Volume
 |  |  | 28886
Spreadsheet: 96956d1296180137-search-table-display-column-header-for-n-occurences-reverselookuptimes2
Sheet: Sheet1

F | 11 | << Change these Two Values to see new Results |  |  |  |  |  |  | RESULT
 | a | b | c | d | e | f | g | h | c
A | 45 | 24 | 11 | 44 | 22 | 33 | 46 | 19
B | 31 | 12 | 8 | 30 | 36 | 43 | 8 | 21 | c | << First column head that matches - NEW METHOD
C | 7 | 47 | 35 | 40 | 16 | 50 | 22 | 6 | e | << Second Column head that matches - NEWER METHOD
D | 49 | 17 | 32 | 44 | 23 | 22 | 5 | 22
E | 40 | 44 | 1 | 18 | 12 | 27 | 48 | 24 | 7 | 4 | 2
F | 43 | 29 | 11 | 28 | 11 | 35 | 8 | 41 |  | 4 | 2
G | 36 | 49 | 43 | 45 | 30 | 28 | 11 | 35 |  | 4 | 6
H | 50 | 41 | 40 | 38 | 37 | 18 | 39 | 40
I | 17 | 19 | 39 | 22 | 42 | 32 | 23 | 38 | The Yellow Cells in the table are conditional formatting so I could keep track
J | 5 | 47 | 33 | 44 | 38 | 50 | 5 | 5 | You might just want to use conditonal formatting and not formulas
K | 15 | 9 | 14 | 13 | 21 | 43 | 35 | 25
L | 25 | 10 | 27 | 34 | 39 | 14 | 19 | 45
M | 42 | 28 | 41 | 44 | 1 | 20 | 8 | 22
N | 2 | 38 | 4 | 42 | 5 | 44 | 19 | 28
O | 33 | 21 | 22 | 17 | 12 | 47 | 34 | 39
P | 10 | 50 | 36 | 28 | 21 | 41 | 18 | 25
Q | 41 | 32 | 23 | 12 | 16 | 36 | 33 | 29
R | 32 | 1 | 19 | 29 | 11 | 3 | 8 | 2
S | 27 | 43 | 14 | 49 | 3 | 45 | 37 | 39
T | 40 | 2 | 13 | 13 | 24 | 46 | 15 | 40
U | 33 | 42 | 49 | 43 | 33 | 38 | 32 | 13
V | 30 | 14 | 32 | 13 | 16 | 5 | 49 | 49
W | 40 | 33 | 48 | 16 | 3 | 28 | 48 | 36
X | 12 | 25 | 35 | 16 | 25 | 1 | 10 | 12
Y | 22 | 45 | 29 | 1 | 49 | 29 | 3 | 16
Z | 25 | 29 | 43 | 6 | 7 | 3 | 21 | 7
AA | 36 | 34 | 27 | 44 | 35 | 24 | 7 | 48
BB | 39 | 10 | 9 | 25 | 11 | 22 | 6 | 28
CC | 41 | 2 | 39 | 35 | 1 | 41 | 18 | 47
DD | 6 | 24 | 18 | 40 | 2 | 33 | 42 | 35
Spreadsheet: gstorey__12090__eol upgrades
Sheet: Sheet1

EOL ENHANCEMENTS
Bridge Problems
- bridging | have problems bridging Canadian eol products and fixed price physical, also have very slow response time to for bridging requests. [NAME] group to be responsible for bridging requests. EOL just sends data feed
- setting risk books | need to be able to pick physical and financial books separately for term physical deals. Not based on stack [NAME]
- update books | be able to set risk books in product properties rather than product manager
Global Properties | be able to change certain product properties across all products in a stack or all highlighted products
Failed deal message | include whether they were trying to buy or sell
Product Management
- custom ordering | custom arrange products in "my products" tab
- multiple tabs | create multiple "my product" tabs
- volume control up top | create volume reset buttons up top with the price controls
- gross up volume to reset | create a button that will gross up the bid or offer volume to the reset volume
Hedging
- formula pricing | autohedge to more than one product
- one sided hedging | hedge on the offer or bid side
Web Site
- view historical cash prices | be able to pull up time series of historical EOL cash prices - must be able to download
- update volume on limit orders
- cancel limit orders
- hold limit orders
- place current market next to order screed
- key in updated price in limit front screen
Spreadsheet: 330e1a29-e1cb-4481-a2af-b7305c0c7738
Sheet: Query1

 |  |  |  |  |  |  | Query Date 01-04-11
 |  |  |  |  |  |  | Watch for consolidated districts
dat_yer | dst_num | dst_tye | gen_lgr_num | fun_num | end_bal_amt
09-10 | 264 | 1 | 2.14 | 1 | -96481
09-10 | 316 | 1 | 2.14 | 1 | -383762.27
09-10 | 317 | 1 | 2.14 | 1 | 0
09-10 | 466 | 1 | 2.14 | 1 | 0
09-10 | 514 | 1 | 2.14 | 1 | 0
09-10 | 706 | 1 | 2.14 | 1 | 0
09-10 | 712 | 1 | 2.14 | 1 | 0
09-10 | 717 | 1 | 2.14 | 1 | 0.01
09-10 | 885 | 1 | 2.14 | 1 | -216405.98
09-10 | 2154 | 1 | 2.14 | 1 | -23006.66
09-10 | 2711 | 1 | 2.14 | 1 | -310546.88
Spreadsheet: 767692d1644582740-how-to-convert-combined-data-from-one-cell-without-commas-into-rows-and-columns-example-convert-to-columns-and-rows-ans
Sheet: Sheet1

[NAME] 3 Pear 4 Straberries 4 Bottle 6 Milk 2 Sugar 5 Kiwi 2 Eggs 3