tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: louise_kitchen__24136__North America Plan 01-08 adj
Sheet: West Power Origination

 | West Power Origination
 | 2002 Plan
 |  |  |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | 2002 |  | % of |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | Plan |  | Total Exp |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  |  |  |  | Compensation | 0 | 64
 | Special Pays |  |  |  |  | 0
 | Analysts & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  |  |  | Total
ENAOUTSV | Outside Services |  |  |  |  | 60000
ENASUPP | Supplies Expense |  |  |  |  | 38016
ENAMKTEX | Marketing |  |  |  |  |  |  |  |  | [NAME] | 33600 | 0
ENACONTR | Charitable Contributions |  |  |  |  |  |  |  |  | [NAME] | 52800 | 0
ENARENT | Rent |  |  |  |  |  |  |  |  | Staff | 54000 | 0
ENATECH | Technology |  |  |  |  |  |  |  |  | Specialist | 63000 | 0
ENATRANS | Transportation |  |  |  |  |  |  |  |  | Sr. Specialist | 78000 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  |  |  |  | Analyst | 66000 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  |  |  |  | Associate | 97200 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  |  |  | Manager | 120000 | 5
 |  |  |  |  |  |  |  |  |  | Director | 156000 | 4
 | Headcount |  |  |  |  |  |  |  |  | Sr. Director | 180000 | 0
 |  |  |  |  |  |  |  |  |  | VP | 216000 | 2
 | Analyst & Associate Headcount |  |  |  |  |  |  |  |  | MD | 240000 | 1
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 677322
 |  |  |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 773267d1647762232-create-a-12-week-roster-rolling-roster-staff-rotation-based-on-week-selection
Sheet: Fixed

Week #
1 | SAT | SUN | MON | TUE | WED | THU | FRI | Staff |  | Staff Lookup Table
1 | 0600-1800 | 0600-1800 | 1800-0600 |  |  |  |  |  |  | 1 | Name 12
2 | 0600-1800 | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600 |  |  |  |  | 2 | Name 11
3 |  |  |  | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600 |  |  | 3 | Name 10
4 |  |  |  |  |  | 0600-1800 | 0600-1800 |  |  | 4 | Name 9
5 | 1800-0600 | 1800-0600 |  |  |  |  |  |  |  | 5 | Name 8
6 |  |  |  |  |  |  |  |  |  | 6 | Name 7
7 |  |  |  |  |  |  |  |  |  | 7 | Name 6
8 |  |  |  |  |  |  |  |  |  | 8 | Name 5
9 |  |  |  |  |  |  |  |  |  | 9 | Name 4
10 |  |  |  |  |  |  |  |  |  | 10 | Name 3
11 |  |  |  |  |  |  |  |  |  | 11 | Name 2
12 |  |  |  |  |  |  |  |  |  | 0 | Name 1
Spreadsheet: mary_fischer__25605__926
Sheet: E-6.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 0926
COMPANY NAME Artemis Associates
ANALYSIS OF PROPERTY, PLANT AND EQUIPMENT
FOR THE PERIOD ENDING 6-30-2001
PREPARED BY: [NAME]
EXTENSION: 52580 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-6
 |  | 12-31-2000 Balance |  |  |  |  |  | CHARGED TO I/S
 |  | DR/(CR.) |  |  |  | SALES AND OTHER |  |  |  |  |  |  |  | DETAIL OF |  | ENDING
[NAME] |  | BEGINNING |  | ADDITIONS |  | RETIREMENTS |  | DEPR |  | DEPL |  | OTHER |  | OTHER CHANGES |  | BALANCE
 |  | BALANCE |  | DR/(CR) |  | DR/(CR) |  | 1415 |  | 1416 |  | (List Below-A) |  | (List Below-B) |  | DR/(CR)
Natural Gas Transmission
Electric Generation & Distribution
Construction In Process
O & G Properties
Other |  | 264295 |  | 397025 |  |  |  |  |  |  |  |  |  | -5089
Gross PP & E
Accumulated DD & A |  |  |  |  |  |  |  | -3038
Net PP & E |  |  | * |  | ** |  | ** |  |  |  |  |  |  |  |  |  | *
 |  |  |  |  | ** Pertains to amounts related to normal |  |  |  |  |  |  | (A) |  | (B) | * | [NAME] TO
 |  |  |  |  | operations.  Unusual amounts should be shown |  |  |  |  |  |  |  |  |  |  | HYPERION LINE
 |  |  |  |  | under "Other Changes" with appropriate explanations. |  |  |  |  |  |  |  |  |  |  | NET_TOT_PPE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Asset/Exp  DR/(CR)
 |  |  |  |  |  |  | DETAIL OF OTHER CHANGES     (B)
 |  |  |  |  |  |  |  |  |  |  |  | PP & E |  | ACCUM |  | NET
CHARGED TO OTHER I/S ACCTS     (A) |  |  |  |  |  |  | KEY: |  |  |  |  | DR/(CR) |  | DR/(CR) |  | DR/(CR)
[NAME] |  | HYP ACCT CHGD |  | DR/(CR) |  |  | (PROVIDE DETAIL OF INDIVIDUAL ITEMS
 |  |  |  |  |  |  | IN EXCESS OF $200,000.)
W/O misc PPE variance |  | 1325 |  | -5089 |  |  | (1) Reclassification between property
 |  |  |  |  |  |  | accounts (should net to -0-)
 |  |  |  |  |  |  | (2) Intercompany transfer
 |  |  |  |  |  |  | (list companies):
 |  | TOTAL
 |  |  |  |  |  |  | (3) Acquisition (disposition)
 |  |  |  |  |  |  | of business
 |  |  |  |  |  |  | (4) Foreign currency
 |  |  |  |  |  |  | translation adjustment
 |  |  |  |  |  |  | (5) Lease impairments -
 |  |  |  |  |  |  | Oil & Gas
 |  |  |  |  |  |  | (6) Other (detail):
 |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-6
Spreadsheet: 125731d1319202332-group-ungroup-problems-group-ungroup
Sheet: Sheet2

 | Perspektiv | KSF kode | KPI kode
A
 | A | A4 | A4.2
 | A | A4 | A4.2.1
 | A | A4 | A4.2
 | A | A4 | A4.3
 | A | A4 | A4.4
 | A | A4 | A4.5
 | A | A4 | A4.7
 | A | A4 | A4.8
 | A | A4 | A4.9
 | A | A4 | A4.10
 | A | A4 | A4.11
 | A | A4 | A4.11.1
 | A | A4 | A4.11.11
 | A | A4 | A4.11.12
 | A | A4 | A4.11.13
 | A | A4 | A4.11.14
 | A | A4 | A4.11.15
 | A | A4 | A4.11.2
 | A | A4 | A4.11.21
 | A | A4 | A4.11.22
 | A | A4 | A4.11.23
 | A | A4 | A4.11.24
 | A | A4 | [NAME]
 | A | A5 | A5.1
 | A | A5 | A5.2
 | A | A5 | A5.3
 | A | A5 | A5.4
 | A | A5 | A5.5
 | A | A5 | A5.6
 | A | A5 | [NAME]
 | A | A6 | A6.1
 | A | A6 | [NAME]
 | A | A6 | [NAME]
 | A | A6 | A6.4
 | A | A6 | A6.5
 | A | A7 | A7.2
 | A | A7 | A7.3
 | A | A7 | A7.4
 | A | A7 | A7.5
 | A | A7 | A7.6
 | A | A7 | A7.7
 | A | A2 | A2.2
 | A | A2 | A2.2.1
 | A | A2 | A2.2.11
 | A | A2 | A2.2.12
 | A | A2 | A2.2.13
 | A | A2 | A2.2.14
 | A | A9 | A9.1
 | A | A9 | A9.2
 | A | A9 | A9.3
 | A | A9 | [NAME]
 | A | A9 | A9.5
 | A | A9 | A9.6
 | A | A9 | A9.7
 | A | A10 | A10.1
 | A | A10 | A10.2
B
 | B | B2 | B2.1
 | B | B2 | B2.1.1
 | B | B2 | B2.1.2
 | B | B2 | B2.1.3
 | B | B2 | B2.1.4
 | B | B2 | B2.1.5
 | B | B2 | B2.1.6
 | B | B2 | B2.1.7
 | B | B2 | B2.2
 | B | B2 | B2.3
 | B | B2 | B2.4
 | B | B2 | [NAME]
 | B | B2 | B2.5.1
 | B | B2 | B2.5.2
 | B | B2 | B2.5.3
 | B | B2 | B2.5.4
 | B | B2 | B2.5.5
 | B | B2 | B2.6
 | B | B2 | B2.7
 | B | B2 | B2.7.1
 | B | B2 | B2.7.2
 | B | B4 | [NAME]
 | B | B4 | B4.2
 | B | B4 | B4.3
 | B | B4 | B4.4
 | B | B4 | [NAME]
 | B | B4 | B4.6
 | B | B3 | B3.3
 | B | B3 | B3.3.1
 | B | B3 | B3.3.11
 | B | B3 | B3.3.12
 | B | B3 | B3.3.2
 | B | B3 | B3.3.3
 | B | B3 | B3.3.31
 | B | B3 | B3.3.32
 | B | B9 | B9.1
 | B | B9 | B9.2
 | B | B9 | B9.3
 | B | B9 | B9.4
 | B | B10 | B10.1
 | B | B10 | B10.2
 | B | B1 | B1.1
 | B | B5 | B5.2
 | B | B5 | B5.3
 | B | B5 | B5.4
C
 | C | C1 | C1.5
 | C | C1 | C1.6
 | C | C1 | C1.6.1
 | C | C1 | C1.6.11
 | C | C1 | C1.6.2
 | C | C1 | C1.6.21
 | C | C1 | C1.6.3
 | C | C1 | C1.6.31
 | C | C2 | C2.1
 | C | C2 | C2.1.1
 | C | C2 | C2.1.2
 | C | C2 | C2.1.3
 | C | C2 | C2.1.4
 | C | C4 | [NAME]
 | C | C4 | C4.1.1.
 | C | C4 | C4.1.11
 | C | C4 | C4.1.2
 | C | C4 | C4.1.21
 | C | C4 | C4.1.3
 | C | C4 | C4.1.31
 | C | C4 | C4.1.32
 | C | C4 | C4.1.33
 | C | C4 | C4.1.34
 | C | C4 | C4.1.35
 | C | C4 | C4.1.4
 | C | C4 | C4.1.41
 | C | C4 | C4.1.42
 | C | C4 | C4.1.43
 | C | C4 | C4.1.44
 | C | C4 | C4.1.45
 | C | C4 | C4.2
 | C | C4 | C4.2.1
 | C | C4 | [NAME]
 | C | C4 | C4.2.3
 | C | C4 | [NAME]
 | C | C4 | C4.3.1
 | C | C4 | C4.3.11
 | C | C4 | C4.3.12
 | C | C4 | C4.3.13
 | C | C4 | C4.3.14
 | C | C4 | D4.3.2
 | C | C4 | D4.3.21
 | C | C4 | D4.3.22
 | C | C4 | D4.3.23
 | C | C4 | D4.3.3
 | C | C4 | D4.3.31
 | C | C4 | D4.3.32
 | C | C4 | D4.3.4
 | C | C4 | D4.3.5
D
 | D | D7 | D7.2
Spreadsheet: 0184a0f3-0590-4571-bf12-bcfe4ffdd6bc
Sheet: 7

 | Nov 16 | Nov 23 | Nov 30 | Dec 7 | Dec 14
Total Interest Rates* | N/A*** | N/A | N/A | N/A | N/A
Cleared** | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Credit | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Equities | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Commodities | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | N/A | N/A | N/A | N/A | N/A
Weekly total, estimated swap dollar volumes by asset class and cleared status (value of all trades in millions of USD), all products, tenors, and participant types.
Estimates of weekly event volumes are derived from data published in the 2012 ISDA Operations Benchmarking Survey, which defines an "event" as a new trade, confirmable amendment, partial or full termination, increase, decrease, or novation.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***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: john_griffith__15941__11_15_01ON
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | NG Z1 | 255 | 27.5 | 30 | 74.7 | 81.5 | 12.52 | 2001-11-15 10:10:00
 | NG F2 | 275 | 56 | 57 | 76.7 | 78.1 | 13.38 | 2001-11-15 10:10:00
 | NG G2 | 280 | 72 | 75 | 72.5 | 75.5 | 13.03 | 2001-11-15 10:10:00
 | NG H2 | 285 | 75 | 78 | 63.4 | 65.9 | 11.58 | 2001-11-15 10:10:00
 | NG J2 | 280 | 70 | 73 | 53.5 | 55.8 | 9.62 | 2001-11-15 10:10:00
 | NG K2 | 285 | 73 | 76 | 49.4 | 51.5 | 9.04 | 2001-11-15 10:10:00
 | NG M2 | 290 | 80 | 84 | 48.8 | 51.2 | 9.12 | 2001-11-15 10:10:00
 | NG N2 | 295 | 86 | 90 | 48.4 | 50.6 | 9.18 | 2001-11-15 10:10:00
 | NG Q2 | 300 | 94 | 98 | 48.9 | 51 | 9.42 | 2001-11-15 10:10:00
 | NG U2 | 300 | 9 | 103 | 4.4 | 50.8 | 5.21 | 2001-11-15 10:10:00
 | NG V2 | 305 | 105 | 110 | 48.7 | 51.1 | 9.57 | 2001-11-15 10:10:00
 | NG X2 | 325 | 117 | 121 | 48.7 | 50.4 | 10.12 | 2001-11-15 10:10:00
 | [NAME] | 345 | 127 | 134 | 48.2 | 50.9 | 10.75 | 2001-11-15 10:10:00
 | NG H3 |  |  |  |  |  |  | 2001-11-12 14:47:00
 | NG M3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG U3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG Z3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG H4 |  |  |  |  |  |  | 2001-09-17 07:55:00
Spreadsheet: 681f7a83-bad1-4d25-9ff2-506289cd211e
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
2748 | 15598 | Germaine | Roullet | ITA | 72 | 00:30:23 | 00:00:00 | 00:47:48 | 00:00:00 | 00:34:35 | 1 | 01:52:47
2748 | 15487 | Yuliya | Barabash | RUS | 71 | 00:28:59 | 00:00:00 | 00:50:36 | 00:00:00 | 00:36:05 | 2 | 01:55:42
2748 | 6522 | Radka | [NAME] | CZE | 73 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DNS | 00:00:00
Spreadsheet: louise_kitchen__24187__Apr 25-01 Hotlist Update
Sheet: Hotlist - Completed

E N R O N   N O R T H   A M E R I C A - H O T  L I S T |  |  |  |  |  |  |  |  |  |  |  | 1Q 2001 DEALS COMPLETED
 |  |  |  |  |  |  |  |  |  |  |  | Results based on activity through March 29, 2001
 |  | Canada Origination & Finance |  |  |  |  |  | Summary
 |  |  | Deals | Value |  |  |  | Total Natural Gas Orig
 |  | Natural Gas (LeDain) | Chippawa | 800 |  |  |  | Total Alberta Power Orig
 |  |  | Calpine | 500 |  |  |  | Total Executive
 |  |  | PGT Shell | 3000
 |  |  | Canagro | 442
 |  |  | [NAME]. Natural Gas Origination | 1432
 |  |  | [NAME] | 327
 |  |  | IMC | 318
 |  | Alberta Power (Davies) | Epcor PPA | 720
 |  |  | Alberta Power PPA | 25000
 |  |  | Misc. West Power Origination | 240
 |  | Fiance (Kitagawa) |  | Put MPR here
 |  |  | CNRL | 805
 |  |  | Blue Range | 307
 |  | Ontario Power (Devries)
 |  | Executive (Milnthorp) | CNRL | 805
 |  |  | Blue Range | 307
 |  | Budget |  |  |  | Unrealized Budget
 |  | 45625
Spreadsheet: 81601d1281714748-lookup-value-each-revenue-item-revenue
Sheet: Sheet3

Revenue A |  |  |  |  |  | Revenue Type | TOTAL
 | Outbound | 46726.67 |  |  |  | Revenue A
 |  |  |  |  |  | Revenue B
 |  |  |  |  |  | Revenue C
 | Totals: | 46726.67 |  |  |  | Revenue D
Revenue B |  |  |  |  |  | Revenue E
 | White Goods | 2770.71 |  |  |  | Revenue F
 |  |  |  |  |  | Revenue G
 | Totals: | 2770.71 |  |  |  | Revenue H
 |  |  |  |  |  | Revenue I
 | Total Disposal Charges |  |  |  |  | Revenue K
Revenue C
 | Fuel | 4694.96
 | Residential | 49383.6
 | Surcharge | 19702.27
 | Front | 1967.4
 | End | 2744.57
 | Repair | 190.97
 | Rental | 150
 | Equipment | 774
 | Management | 1980
 | Service | 19917.9
 | Totals: | 216328.7
Revenue D
 | Surcharge | 143.05
 | Totals: | 143.05
Revenue E
 | Surcharge | 597.08
 | Totals: | 597.08
Revenue F
 | Surcharge | 30.16
 | Surcharge | 5467.84
 | Totals: | 5498
Revenue G
 | Surcharge | 355.65
 | Totals: | 355.65
Revenue H
 | Front | 42
 | Totals: | 42
Revenue I
 | Surcharge | 167.23
 | Surcharge | 24245.45
 | Totals: | 24412.68
Revenue K
 | Front End Waste | 379.5
 | Totals: | 24412.68
Spreadsheet: 0666d2b2-9773-4133-adc3-58cc529817c9
Sheet: Sheet1

Unnamed: 0 | BELKNAP COUNTY OFFICES - Republican | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
2008-09-09 00:00:00 | Sheriff |  | Attorney |  |  |  | Treasurer
 | Wiggin, r | Others |  | Carroll, d | Others | Others | Muzzey, r | Others
Alton | 366 |  |  | 1 | 11 |  | 340
Barnstead | 186 | 4 |  | 1 | 3 |  | 175 | 1
Belmont | 219 | 5 |  | 12 | 5 |  | 207 | 1
Center Harbor | 85 |  |  | 2 | 2 |  | 82
Gilford | 456 | 13 |  | 19 | 13 |  | 424 | 1
Gilmanton | 181 | 2 |  | 5 | 7 |  | 173
[NAME] | 200 | 3 |  | 13 | 2 |  | 191
[NAME] | 137 |  |  | 13 | 5 |  | 121 | 1
[NAME] 3 | 178 | 3 |  | 17 | 2 |  | 161
[NAME] | 116 | 1 |  | 6 | 2 |  | 117
[NAME] | 94 | 1 |  | 2 | 1 |  | 92
[NAME] 6 | 175 | 2 |  | 10 | 2 |  | 168
Meredith | 384 | 1 |  | 4 | 14 |  | 343
New Hampton | 138 |  |  | 3 | 4 |  | 135
Sanbornton | 169 | 2 |  | 6 | 0 |  | 162
[NAME] | 172 | 2 |  | 5 | 4 |  | 169 | 1
TOTALS | 3256 | 39 |  | 119 | 77 |  | 3060 | 5
 | BELKNAP COUNTY OFFICES - Republican
2008-09-09 00:00:00 | Reg. of Deeds |  |  |  | Reg. Of Probate
 | Luther, r | Morrison, d | Others |  | Brickner, r | Chong, d | Others
Alton | 370 |  |  |  | 364
Barnstead | 179 |  | 2 |  | 194 |  | 2
Belmont | 212 |  |  |  | 201 |  | 2
Center Harbor | 84 |  |  |  | 86
Gilford | 453 |  | 1 |  | 430
Gilmanton | 185 |  |  |  | 183
[NAME] | 202 | 1 |  |  | 188
[NAME] | 139 | 1 |  |  | 128 |  | 1
[NAME] 3 | 170 |  |  |  | 165
[NAME] | 126 |  |  |  | 116
[NAME] | 100 |  |  |  | 93
[NAME] 6 | 174 |  |  |  | 161
Meredith | 358 |  |  |  | 359
New Hampton | 136 |  |  |  | 134
Sanbornton | 170 | 1 |  |  | 161 | 3
[NAME] | 175 |  | 1 |  | 176 | 1 | 1
TOTALS | 3233 | 3 | 4 |  | 3139 | 4 | 6
 | COUNTY COMMISSIONERS
 | District 1 |  |  |  | District 2 |  |  | Dist. 3
 | Tardif, r | [NAME], r | Philpot, d | Others | Shannon, d | Others | [NAME] (w-in_
Alton |  |  |  |  |  |  |  | NO ELECTION
Barnstead |  |  |  |  | 0 | 6 | 0
Belmont |  |  |  |  | 0 | 9 | 94
Center Harbor
Gilford
Gilmanton |  |  |  |  | 0 | 5 | 57
[NAME] | 74 | 147 |  | 1
[NAME] | 72 | 80 | 1
[NAME] 3 | 67 | 129
[NAME] | 64 | 81
[NAME] | 45 | 66
[NAME] 6 | 102 | 112 | 2
Meredith
New Hampton
Sanbornton |  |  |  |  | 0 | 0 | 8
[NAME] |  |  |  |  | 1 | 16 | 0
TOTALS | 424 | 615 | 3 | 1 | 1 | 36 | 159
Spreadsheet: 228256d1366055179-return-value-per-record-where-1-row-per-record-based-on-criteria-for-multiple-columns-question
Sheet: Sheet1

Input
Student | Score | Date | Error | Note
1 | 95 | 2013-04-29 00:00:00 | 5 | Use this one because it has the lowest error given the same dates and scores
1 | 95 | 2013-04-29 00:00:00 | 6
1 | 60 | 2013-04-28 00:00:00 | 5
2 | 97 | 2013-04-29 00:00:00 | 6 | Use this one because it is the highest score for this student
2 | 52 | 2013-04-28 00:00:00 | 5
3 | 50 | 2013-04-29 00:00:00 | 6 | Use this one because there are no other scores for this student
4 | 75 | 2013-04-29 00:00:00 | 5 | Use this one because it is the most recent score of the three for this student
4 | 75 | 2013-04-28 00:00:00 | 6
4 | 73 | 2013-04-28 00:00:00 | 5
Output
Student | Score | Note
1 | 95 | Use this one because it has the lowest error given the same dates and scores
2 | 97 | Use this one because it is the highest score for this student
3 | 50 | Use this one because there are no other scores for this student
4 | 75 | Use this one because it is the most recent score of the three for this student
Spreadsheet: phillip_m_love__30535__Quiz questions
Sheet: Sheet1

 | 1 | What is the importance of Officializing Books?
 |  | 3 Reasons
 | 2 | Draw a Basis Swap - Sell Chicago Chigate @ NX1 + .21 |  |  |  |  |  |  |  | [NAME]
 | 3 | Why don't we book physical Gas Daily deals in TAGG?
 | 4 | Why do we hedge deals in Sitara?
 |  | When you hedge a deal what price is associated with your physical calc?
 | 5 | What is the difference between intra-month curves and gas daily curves
 |  | ex. If HPL/SHIP & GDP-HPL/SHIP
 | 6 | How do you book and box a physical spread deal
 |  | ex. [NAME]/ELA Gas for [NAME]. |  |  |  |  |  |  |  | Anne
 | 7 | What's a fixed-for-float deal?
 |  | What risks types are involved?
x | 8 | What causes a liquidation to be booked to the wrong company?
 | 9 | ENA writes a put option - if this is exercised, is enron buying or selling physical gas?
 | 10 | What does a call give you the right to do?  A Put? |  |  |  |  |  |  |  | Kam
 | 11 | What did Sept-01 Nymex close at yesterday?  What did the August contract settle at?
 | 12 | A buyer of a call option has what limitation on its risk?  Selling a call?
 | 13 | If you buy a call, are you long or short? |  |  |  |  |  |  |  | O'neal
x | 14 | What is exposure?
 | 15 | Describe the difference between accrued & MTM on your physical P&L.
 |  | What makes up the mid price for Aug Socal?
 | 16 | Draw and define a contango curve. |  |  |  |  |  |  |  | Errol
 | 17 | On August 15th, if you receive a deal ticket for a fixed price physical deal for 9/1,
 |  | how would you book this deal without using the Trade Blotter?
 | 18 | Equation:  Customer Price+/-? = Desk Price
 | 19 | What % of futures contracts in energy go to physical delivery?
 | 20 | What is an EFP? |  |  |  |  |  |  |  | [NAME]
 |  | What are the risk components of an EFP?
 |  | Why would a trader do an EFP?
 | 21 | If the market expects the AGA to come out at 100 and it comes out at 110,
 |  | what will happen to the nymex and why?
x | 22 | What effects does changing the customer price have after flash? |  |  |  |  |  |  | start over
 | 23 | How do you book a physical Gas Daily call in Sitara?
x | 24 | If an AP is written off, what impact does the desk have?
x | 25 | Name 2 items that cause PMA's?
 | 26 | How is intrinsic value calculated?
 |  | What is the intrinsic value of an out-of-the-money option?
 | 27 | What is the cross to an option?
 |  | Why would a trader do a cross?
 |  | How do you figure out the cross?
 | 28 | What is a Pen to last day spread trade?
 |  | Why would a trader do this trade and when do they usually get done?
 | 29 | Draw out a synthetic storage deal:
 |  | ex.  INJ. OCT. 01 1BCF
 |  | W/D Jan 02 1BCF
 |  | W/B Pay.03 per/MMBTU
 | 30 | When does a typical option expire?
Spreadsheet: 814903d1674655087-formulae-starts-when-negative-value-found-and-stops-when-key-is-changed-book1-53-
Sheet: Sheet1

HD | Output Required | Key | Exp
 | 0 | 421 | 28
 | 0 | 422 | 67
 | 1 | 422 | -63
 | 2 | 422 | 60
 | 3 | 422 | 55
 | 4 | 422 | 50
 | 5 | 422 | 45
 | 6 | 422 | -41
 | 1 | 423 | -80
 | 2 | 423 | -70
 | 3 | 423 | -60
 | 4 | 423 | 50
 | 0 | 424 | 60
 | 0 | 424 | 50
 | 1 | 424 | -6
Spreadsheet: 799658d1665178870-index-and-match-product-with-highest-value-s666-pq-worst-case
Sheet: Sheet1

Product | Igredient | Value
A | 1 | 70 |  |  |  |  | Product | A | B | C | D | E
B | 2 | 60 |  |  |  |  | Worst-case Igredient | 1 | 2 | 3 | 1 | 4
B | 3 | 50
B | 4 | 47
C | 3 | 50
D | 1 | 70
E | 4 | 47
E | 5 | 45
Product | A | B | C | D | E
Worst-case Ingredient |  | 2 |  |  | 4
Spreadsheet: 733885d1621869853-salary-distribution-and-3-percent-increment-every-year-on-hire-date-salary_increment_calculation
Sheet: Salary Comparison

 |  |  |  | open position
 | open | Department | Employee ID | Employee Name | Position | Notes | Salary |  | Hire Date | Employment period | Term Date |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00
 |  | Account | 100 | A1 | Account Supervisor |  | 90000 |  | 2011-01-01 00:00:00
 |  | Account | 101 | A2 | Account Executive |  | 60000 |  | 2011-01-01 00:00:00
 |  | Account | 102 | A3 | Assitant Account Executive |  | 30000 |  | 2011-06-21 00:00:00
 |  | Account | 103 | A4 | Intern |  | 20000 |  | 2011-09-13 00:00:00
 |  | Account
 |  | Public Relations | 104 | B1 | PR Associate |  | 45000 |  | 2011-02-01 00:00:00
 |  | Public Relations | 105 | B2 | Senior PR Associate |  | 30000 |  | 2011-07-12 00:00:00
 |  | Public Relations
 |  | Creative | 106 | C1 | Copywriter |  | 30000 |  | 2011-01-25 00:00:00
 |  | Creative | 107 | C2 | Copywriter |  | 30000 |  | 2011-05-17 00:00:00
 |  | Creative
 |  | Analytics | 108 | D1 | Digital Analyst |  | 80000 |  | 2011-07-26 00:00:00
 |  | Analytics
 |  | Media | 109 | E1 | Estimator |  | 55000 |  | 2011-01-11 00:00:00
 |  | Media | 110 | E2 | Assistant Media Planner |  | 80000 |  | 2011-10-18 00:00:00
 |  | Media
 |  | Digital | 111 | F1 | Digital Traffic |  | 35000 |  | 2011-03-08 00:00:00
 |  | Digital | 112 | F2 | Business Analyst |  | 20000 |  | 2011-08-16 00:00:00
 |  | Digital
 |  | Media Buying
 |  |  |  | Total Salary
Spreadsheet: 1b09c658-948a-4184-a432-a3c62bd9d0a4
Sheet: 12d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Cross-Currency Basis | 0 | 102554 | 0 | 22612
Cross-Currency Fixed-Fixed | 0 | 3960 | 0 | 4100
Cross-Currency Fixed-Float | 0 | 10492 | 0 | 5036
TOTAL | 0 | 117006 | 0 | 31748
Spreadsheet: 150086d1334274213-consolidate-text-ef78_example-1-
Sheet: 2

Program | Category | Task | Notes
[NAME] | Post Inspection | PSO Report | Quarterly
Ian | Database | PI Insp Reports
Ian | FSA | Pre-Mist Updates
Spreadsheet: 725135d1616555452-help-with-an-if-statement-sample
Sheet: Sheet1

Ticker | Date | Day of year | Day of WK |  | E1 | E2 | SL Close | SL Low | PT1 | PT2 | PT3 | PAx Broke E2 before hitting P1 | Hit PT1 after E1 | Hit E1, but not E2 | Hit E1 and E2 | Broke SL Close | Broke SL Low | Fails to hit PT1 w/in 10 bars | Fails to hit PT2 w/in 10 bars | Fails to hit PT3 w/in 10 bars | Hit PT1 in 10bars, before hitting E1/E2
CFRX | 2021-03-11 00:00:00 |  |  |  | 5 | 5 | 5 | 5 | 1 | 1
Spreadsheet: 857421d1706449804-how-to-take-the-net-present-value-of-column-of-numbers-npv
Sheet: Sheet1

 |  | Age
 |  | 68 | -2979.65
 | 1 | 69 | -3426.597499999999
 | 2 | 70 | -3940.587124999999
 | 3 | 71 | -4531.675193749998
 | 4 | 72 | -5211.426472812498
 | 5 | 73 | -5993.140443734373
 | 6 | 74 | -6892.111510294528
 | 7 | 75 | -7925.928236838707
 | 8 | 76 | -8074.851499999999
 | 9 | 77 | -8074.851499999999
 | 10 | 78 | -8074.851499999999
 | 11 | 79 | -8074.851499999999
 | 12 | 80 | -8074.851499999999
 | 13 | 81 | -8074.851499999999
 | 14 | 82 | -8074.851499999999
 | 15 | 83 | -8074.851499999999
 | 16 | 84 | -8074.851499999999
 | 17 | 85 | -8074.851499999999
 | 18 | 86 | -8074.851499999999
 | 19 | 87 | 264753.6258698964
 | 20 | 88 | 277991.3071633913
 | 21 | 89 | 291890.8725215608
 | 22 | 90 | 306485.4161476389
 | 23 | 91 | 321809.6869550208
 | 24 | 92 | 337900.1713027718
 | 25 | 93 | 354795.1798679105