tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: daren_farmer__5647__buydef
Sheet: Sheet1

BUYBACK & DEFICIENCY DEALS
 |  |  |  | Buyback | Type
Counterparty | Undertake | Sale | Swing | K # | of deal | Term | [NAME] | VM
AirProducts, Inc. | 414092 | 414025 | 414090 | 96023739 | Deficiency | 10/00-9/01 | 1418
BASF Corporation | 133000 | 120266 | 122310 | 96022419 | Buyback | 11/1/99-10/31/01 | 1437
Bayer Corporation | 455603 | 455565 |  | 96022013 | Buyback | November | 1550/8056 | Fred
Bayer Corporation | 504469 | 504383 |  | 96022013 | Buyback | December | 1550/8056 | Fred
Bayer Corporation | 547375 | 547365 |  | 96022013 | Buyback | January | 1550/8056 | Fred
[NAME] | 139070 | 139066 | 139068 | 96018826 | Buyback | 1/1/00-12/31/00 | 8216 | Fred
[NAME] | 544392 |  | 544388 | 96018826 | Buyback | 1/1/01-12/31/01 | 8216 | Fred
[NAME] |  | 544403 |  | 96018826 | Buyback | January | 8216 | Fred
Enron Methanol Co | 139058 | 139055 | 139057 | 96018827 | Buyback | 1/1/00-12/31/00 | 8291 | Fred
Enron Methanol Co | 544402 |  | 544395 | 96018827 | Buyback | 1/1/01-12/31/01 | 8291 | Fred
Equistar Chemicals LP | 246625 |  | 244614 | 96000240 | Buyback | 1/99-1/01 | 1384 | [NAME]
Equistar Chemicals LP | 246633 |  | 244612 | 96000240 | Buyback | 1/99-1/01 | 1553 | [NAME]
Equistar Chemicals LP | 246408 |  | 244610 | 96000240 | Buyback | 1/99-1/01 | 1373 | [NAME]
Equistar Chemicals LP | 246629 |  | 644603 | 96000240 | Buyback | 1/99-1/01 | 1552 | [NAME]
Equistar Chemicals LP | 259397 |  |  | 96000240 | Buyback | 1/99-1/01 | 1062 | [NAME]
Equistar Chemicals LP | 246408 |  | 244610 | 96000240 | Buyback | 6/00-1/01 | 1062 | [NAME]
Global Octanes Texas LP | 373580 | 276461 | 373590 | 96019673 | Deficiency | 9/00-8/01 | 1528 | Thu
Lyondell-Citgo | 147729 | 147092 |  | 96008792 | Buyback | 2/1/00-12/31/00 | 1063
Lyondell-Citgo | 542915 | 542893 |  | 96008792 | Buyback | 1/1/01-12/31/01 | 1063
Marathon-Ashland | 513826 | 454436 |  | 96019644 | Buyback | 12/00-11/01 | 1431
Petrofina Gas Pipeline | 455545 | 455500 |  | 96019331 | Buyback | 11/00-3/01 | 1484
Petrofina Gas Pipeline | 473226 | 455500 |  | 96019331 | Buyback | 12/00-3/01 | 1484
Rohm & Haas | 506606 | 506590 |  | 96019546 | Buyback | December | 1506 | Thu
Rohm & Haas | 547419 | 547409 |  | 96019546 | Buyback | January | 1506 | Thu
[NAME] |  | 168176 |  |  | Buyback | 3/1/00-1/31/02 | 1600
[NAME] | 541123 |  |  |  | Buyback | 12/25/00-12/30/00 | 1600
Temple-Inland Forest Products | N/A | 93218 | N/A | 96001360 |  | 7/99 - 1/01 | 1020
Union Carbide | 63576 | 15765 | 34825 | 96019676 | Deficiency | 2/1/99-12/31/01 | 1308 | [NAME]….ENA
Union Carbide | 63573 |  | 34832 | 96019676 | Deficiency | 1/1/00-12/31/01 | 1332 | Fred….ENA
Union Carbide |  | 498238 |  | 96019676 | Deficiency | December | 1332 | Fred….ENA
Union Carbide |  | 547192 |  | 96019676 | Deficiency | January | 1332 | Fred….ENA
Valero Marketing & Supply | 478227 | 454447 |  | 96023591 | Buyback | 11/00-4/01 | 1394
Valero Marketing & Supply | 478229 | 454452 |  | 96023591 | Buyback | 11/00-4/01 | 1233
Valero Marketing & Supply | 478230 | 454455 |  | 96023591 | Buyback | 11/00-4/01 | 8018
 |  |  |  |  |  |  |  |  | ENA
 |  |  |  |  |  |  |  |  | ENA
Spreadsheet: 593006d1538852427-how-to-link-two-excel-sheets-together-data
Sheet: SUMMARY

S/N | SCHOOL | STAFF POPULATION
 |  | MALE | FEMALE | TOTAL
1 | AJANGBADI SENIOR HIGH SCHOOL, AJANGBADI
2 | IWORO-AJIDO SENIOR MODEL COLLEGE, EBUTE-OLOFIN
3 | ARAROMI-ILOGBO SENIOR SECONDARY SCHOOL, ARAROMI ILOGBO
4 | Awodi-Ora Junior Secondary School, Ajegunle
5 | KANKON SENIOR SECONDARY SCHOOL, KANKON
6 | Alternative High School For Girls, Agboju
7 | KANKON SENIOR SECONDARY SCHOOL, KANKON
8 | IKOGA SENIOR HIGH SCHOOL, IKOGA-ZEBBE
9 | Dr. [NAME], [NAME]
10 | Newland Junior Secondary School, Tolu
11 | Ojoku Junior High School, Tolu
12 | Ojora Memorial Junior Secondary School, Tolu
13 | Olodi Apapa Junior Secondary School, Tolu
14 | OJO SENIOR HIGH SCHOOL, AGRIC OJO
15 | COMMUNITY SENIOR SECONDARY SCHOOL, AGRIC OJO
16 | OJOKU SENIOR HIGH SCHOOL, TOLU
17 | AJANGBADI SENIOR HIGH SCHOOL, AJANGBADI
18 | Imoye Junior High School, Mile 2
19 | Reservation Junior Secondary School, Tolu
Spreadsheet: 0fb1f812-35ff-4717-834f-1ab998c2b978
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2013-10-04 09:31:11.230000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
4.625 | 102.119 | 101.994 | 101.869 | 101.494
4.5 | 101.78 | 101.655 | 101.53 | 101.155 |  | Note: | Refer To Price [NAME]
4.375 | 100.918 | 100.793 | 100.668 | 100.293 |  |  | For all Price Adjs
4.25 | 100.408 | 100.283 | 100.158 | 99.533
4.125 | 99.666 | 99.541 | 99.416 | 98.791
4 | 98.747 | 98.622 | 98.497 | 97.872
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 102.125 | 102 | 101.875 | 101.5
3.75 | 102.114 | 101.989 | 101.864 | 101.489
3.625 | 101.754 | 101.629 | 101.504 | 101.129
3.5 | 101.217 | 101.092 | 100.967 | 100.592
3.375 | 100.515 | 100.39 | 100.265 | 99.64
3.25 | 99.771 | 99.646 | 99.521 | 98.896
3.125 | 98.95 | 98.825 | 98.7 | 98.075 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2013-10-18 09:31:11.230000
30 DAY | 2013-11-02 09:31:11.230000
45 DAY | 2013-11-17 09:31:11.230000
60 DAY | 2013-12-02 09:31:11.230000
90 DAY | 2014-01-01 09:31:11.230000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 270835d1381701166-cell-if-no-value-is-inputed-i-would-like-a-blank-cell-to-appear-instead-of-0-blank-cells
Sheet: Sheet1

 |  |  |  |  |  |  |  | Information
 |  |  | Account Name |  | Copied Cells |  |  | In cells D4 to D17 the company accounts are inputted here. In cells F4 to F17 there is a formula which copies the data across from cells D4 to D17. The problem with this formula is that when no data is inputted in cells D4 to D17 a "0" value appears. Therefore I need a formula which makes cells F4 to F17 appear blank if no data is in D4 to D17. Any thoughts would be much appreciated.
 |  |  | abc Ltd
 |  |  | def Ltd
 |  |  | ghi Ltd
 |  |  | jkl Ltd
Spreadsheet: 827949d1683134245-quicker-countifs-or-alternate-method-book4
Sheet: Sheet1

Vehicle Name | Date | [NAME] | [NAME] | [NAME] | Issue: Date [NAME]
94601 | 2022-06-23 00:00:00 | 5555 | hr | Primary
97145 | 2023-04-10 00:00:00 | 1254 | hr | Primary
97145 | 2023-03-16 00:00:00 | 1235 | hr | Primary
97145 | 2023-02-22 00:00:00 | 1728 | hr | Primary
97627 | 2022-11-10 00:00:00 | 5555 | hr | Primary
97627 | 2022-06-13 00:00:00 | 5555 | hr | Primary
97627 | 2022-05-24 00:00:00 | 5555 | hr | Primary
97627 | 2022-05-23 00:00:00 | 21002 | hr | Primary
97627 | 2022-05-19 00:00:00 | 5555 | hr | Primary
97627 | 2022-05-03 00:00:00 | 5555 | hr | Primary
Spreadsheet: 781810d1653560271-identify-highest-numeric-value-of-duplicate-names-formula
Sheet: Sheet1

name | score | formula column
Spot | 5 | False
Dino | 4 | False
Dino | 9 | True
Fido | 6 | True
Spot | 2 | False
Spot | 7 | True
Fido | 2 | False
Spreadsheet: 75891d1276508683-excel-2007-searching-through-worksheets-staff_template_v2
Sheet: Summary

 |  | This Year |  |  | February Lates |  | Holidays
 |  | Sick Days | Lates | Mins Late | Lates | Minutes Late | Used | Left
 | [NAME] Bloggs1 |  |  |  |  |  |  |  |  |  |  |  |  |  | January Lates
 | [NAME] Bloggs2 |  |  |  |  |  |  |  |  |  |  |  |  |  | February Lates
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | March Lates
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | April Lates
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May Lates
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | June Lates
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | July Lates
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | August Lates
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September lates
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | October Lates
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | November Lates
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | December Lates
 | Totals
Spreadsheet: chris_germany__2020__NE Transport-Supply Notional Bid-Offer
Sheet: Bid-Offer Summary

Company Name |  | El Paso Merchant Energy |  |  |  | Fax To: | [PHONE]
Contact |  | [NAME] |  |  |  | Attention: | [NAME] | (Contact No. [PHONE])
Contact Number |  | [PHONE] |  |  |  |  | or [NAME] | (Contact No. [PHONE])
Date |  | 2002-04-17 00:00:00 |  |  |  | [NAME] To: | [EMAIL]
 |  |  |  |  |  |  | [EMAIL]
 | PLEASE RESPOND BY WEDNESDAY, APRIL 17, 2002  AT 3:00 PM CT
NOTIONAL BIDS / OFFERS
ENA is completing an initital review of the value of the following assets.  This market evaluation will be used to develop an overall
asset disposition plan that will be approved by the Creditor Committee.  All pricing is notional and non-binding.  Your assistance
in providing this information is appreciated.
DEAL #1 | Pipeline Capacity
Location | Volume (Dth/d) |  | Physical Basis Offer |  | Location | Volume (Dth/d) |  | Physical Basis Bid
[NAME] |  | May 02-Mar 07 |  |  | [NAME] | 35466 | May 02-Mar 07
 |  | May 02-Mar 07 |  |  | [NAME] | 35000 | May 02-Mar 07
DEAL # 2 | Delivered Supply
Location | Volume (Dth/d) |  | Physical Basis Bid
[NAME] | 7500 | May 02-Mar 07
OTHER DEAL STRUCTURES THAT HAVE VALUE TO THE BIDDER
El Paso would enter into a capacity release at the following daily demand numbers
[NAME] = $0.075 daily demand (inclusive of all surcharges)
Tennessee NET 284 transport = $0.05 daily demand
NOTES
1)  Tennessee contract is a NET 284 service agreement.
2)  Tennessee Zone 6 Primary Delivery Points are Mendon & Various Boston Gas City Gates
Spreadsheet: 217941d1362259661-make-a-unique-list-from-data-table-unique-list_from_data_table
Sheet: Sheet1

 |  |  |  | ID |  |  | ID
 |  |  |  | 158 | <----ID comes from Data Validation |  | 153
 | DATA TABLE |  |  | SUM TABLE |  |  | 158
 | ID | Name |  | Name |  |  | 160
 | 158 | n1 |  |  | [NAME] will place from here to bottom |  | 161
 | 158 | n2 |  |  |  |  | 178
 | 160 | n1 |  |  |  |  | 188
 | 153 | n2 |  |  |  |  | 190
 | 158 | n3
 | 161 | n2
 | 178 | n5
 | 158 | n4
 | 158 | n3
 | 160 | n6
 | 158 | n1
 | 158 | n4
 | 160 | n3
 | 178 | n2
 | 160 | n3
 | 188 | n2
 | 190 | n1
 | 158 | n4
 | 153 | n3
 | 160 | n3
 |  |  |  | Names
 |  |  |  | will come only I2 cell refferenced names
 |  |  |  | example: if I2 = 158
 |  |  |  | in SUM TABLE "n1" "n2" "n3" "n4"  will be listed
 |  |  |  | as a unique list ( one time to be placed)
 |  |  |  | NOT n5 and n6
 |  |  |  | From H5 to H24  a FORMULA needed
 |  |  |  | to replace the Names from Data Table to SUM table
Spreadsheet: 772225d1647093701-get-the-most-occurrences-from-an-area-and-sort-from-largest-to-smallest-forum3-12
Sheet: Sheet1

1 | 2 | 3 | 4
5 | 6 | 7 | 8
9 | 0 | 1 | 2
1 | 2 | 3 | 4
7 | 8 | 9 | 0
 |  |  |  | 2 | 1 | 9 | 8 | 7 | 4 | 3 | 0 | 6 | 5
Spreadsheet: darrell_schoolcraft__7761__imbalsumm0106
Sheet: Duke

Duke Energy Field Services
Contract  24268
2001-05-31 00:00:00 |  | 724391.09
2001-06-04 00:00:00
60874 | 460
500235
500248
500251
500254
500255
500262
500267
Duke Energy Trading and Marketing
Contract  24693
2001-05-31 00:00:00 |  | 275313.72
2001-06-04 00:00:00
9164
9167
Duke Energy Trading and Marketing
Contract  24361
2001-05-31 00:00:00 |  | 662150.47
2001-06-04 00:00:00
500241
500391 | 772
500392 | 307
Duke Energy Trading and Marketing
21665 | oba | 73449.16 | POI 9109 Mobil Waha Plant
22664 | oba | 23612.35 | POI 59918 Grand Valley Plant
20248 | trans | -15794
25873 |  | -259
26758 |  | -596
26372 |  | 2997.09
26700 |  | 4077.9
26422 |  | 8155.8
26661 |  | 146862.35
27291 |  | -17965
27123 |  | -6425.19
Spreadsheet: 85153d1285205433-array-formula-or-pivot-table-pivot-table-help-test-file-1-
Sheet: Sheet5

Raw data
Retrieved from an external database
Cons Unit | Partner Unit | Item | Amt |  |  | Data
10 | 15 | 11800000 | -272.27 |  | Cons Unit | Sum of Partner Unit | Sum of Amt
10 | 15 | 47300000 | 261513401.17 |  | 10 | 105 | 313686572.4899999
10 | 17 | 11800000 | 48957613.76 |  | 44 | 67 | -9384802.05
10 | 17 | 47300000 | 766213.74 |  | 200 | 140 | -7313698576.75
10 | 20 | 11800000 | 2449716.09 |  | Grand Total | 312 | -7009396806.31
10 | 21 | 11800000 | -100
44 | 22 | 11800000 | -527073.75
44 | 22 | 47300000 | -9419418.92
44 | 23 | 11800000 | 561690.62
200 | 25 | 11800000 | 1081239.75
200 | 25 | 47300000 | -8938860.19
200 | 30 | 11800000 | -257101814
200 | 30 | 11800010 | 105023650.44
200 | 30 | 47300000 | -7153762792.75
Result wanted
If subtotal by Cons Unit/Partner Unit is a negative number, show total only:
Cons Unit | Partner Unit | Amt
10 | 21 | -100
44 | 22 | -9946492.67
200 | 25 | -7857620.439999999
200 | 30 | -7305840956.31
Spreadsheet: benjamin_rogers__1187__CTG-Suffield Deal List
Sheet: Deals

 | Deal / Prospect | Structuring / Execution Activities | Hardware | Origination | Group | GTD Assigned | Associate | Analysts | Other
10 | Motown (MCN) | Base Model & PPA Restructuring |  | [NAME] | QF | [NAME] | [NAME] | [NAME]
20 | Wilhelm (Kaiser) | Base Model & PPA Restructuring | Aluminum |  | Other | [NAME] | [NAME]
30 | East Coast Power |  |  | [NAME] | QF |  | [NAME] | [NAME]
31 | Tosco / Linden6 |  |  | [NAME] | QF | [NAME] | [NAME] |  | [NAME] (CTG Midstream)
40 | [NAME] (Brooklyn) / Battleship | Base Model & PPA Restructuring |  | [NAME] | QF | [NAME]   Jeff Hoover | [NAME]
50 | Lakewood | Base Model & PPA Restructuring |  | [NAME] | QF | [NAME] | [NAME] | [NAME] | [NAME])
60 | ENA - West L.B. | Buying FIAT Turbines |  | [NAME] | IPP | [NAME] | [NAME] |  | [NAME]
70 | Peoples |  |  | [NAME] | IPP | [NAME] | [NAME] | [NAME] | [NAME]
71 | Wilton (Lincoln Center) | ENA to take back advisor role | 7FA |  | IPP |  | [NAME]
72 | Calumet | Peoples Site | ABB,LM's |  | IPP |  |  | [NAME] | [NAME]
73 | Torrence |  |  |  | IPP
80 | [NAME] |  | GAS | [NAME] | IPP | [NAME] |  | [NAME] | [NAME][NAME]
90 | [NAME] | PPA Restructuring w/ [NAME] |  | [NAME] | QF | [NAME] | [NAME] | [NAME]
 | 2000 Peakers | Gleason / Done except for TVA Inter-connectCinergy / Water Supply needed |  | [NAME] | GEN
 | LM 6000 Turbines | Standard Base Model Development |  | [NAME] | GEN | [NAME] | [NAME] | [NAME] | [NAME]
 | WH 501 D5A Turbine |  | WH | [NAME] | IPP
 | Development / Structuring Fees | GE LM6000 & GE 7FA's | LM's | [NAME] | GEN |  |  |  | [NAME],[NAME], [NAME]
 | Synthetic Combined Cycle | Selling L.T. 16 hr power |  | [NAME] | IPP |  | [NAME] | [NAME]
 | Selling Turbines/Sites | Monetizing ENA Positions |  | [NAME] | IPP
 | Restructure to Accelerate Income for IPP's |  |  | [NAME] | IPP
 | Power Curves (+18 months) | Developing model for long-term merchane valuation |  |  | Other |  | [NAME] |  | [NAME] (Und) [NAME] (Strt.)
 | Endeck - Corinth |  |  | [NAME] | QF
 | IPP/QF Coverage |  |  | [NAME] | QF | [NAME] | [NAME]
 | PPA Auctions |  |  | [NAME] | QF |  | [NAME]
 | GE 7 Series Turbines |  |  | [NAME] | IPP
 | [NAME] | Labor Role Issues |  | [NAME] | IPP | [NAME]
 | STAT Oil / Viking | Power Authority |  | [NAME] | QF | [NAME] | [NAME] | [NAME]
 | [NAME] |  |  | Industrials |  | [NAME] | [NAME] | Chad Landry & [NAME]
 | Tomen |  |  | [NAME] | QF
 | El Paso / Dynegy | Dynegy Asets |  | [NAME]
 | West Coast Power Deals | CTG Functions for Portland / S.F. |  | [NAME] | VAR | [NAME]
 | Hardware Lists | Tracking Turbine Inventory |  | [NAME] | GEN |  |  | [NAME]
 | UAE-Lowell | Brownfield with existing generator |  | [NAME] | IPP |  |  | [NAME]
 | USEC | Developing 1000 MW's (GE 7FA's) for industrial customer |  | [NAME] | IPP |  |  | [NAME]
 | Teco | Price [NAME]. Product which guarantees the debt in the project |  | [NAME] | IPP |  |  | [NAME]
 | Peco | Sale of MW's from ENA's [NAME] |  | Ozzie Pagan | East Orig. |  |  | [NAME]
 | Boston Electric/NSTAR | 2000 MW Bid
 | PANDA
 | NYPA | Gas (Holtsville) |  |  |  | [NAME]
Spreadsheet: 803520d1667504279-count-duplicate-and-missing-names-in-other-sheets-main
Sheet: Sheet3

CRAIG
JASON
DALE
ROSS
CAMERON
LOUIS
DEAN
CONOR
SHANE
ELLIOT
PATRICK
MAX
SHAUN
HENRY
SIMON
TIMOTHY
MITCHELL
BILLY
PHILIP
JOEL
JOSH
MARCUS
DYLAN
CARL
ELLIOTT
BRANDON
MARTIN
TOBY
STUART
GARETH
Spreadsheet: 832574d1686445104-find-last-instance-of-a-text-string-findlast
Sheet: Sheet1

Alpha | red blue green
Bravo | gold amber yellow
[NAME] | orange blue black
Delta | black white orange |  | SEARCH
Echo | yellow white black |  | black
Foxtrot | red white blue
Golf | purple black red |  | EXPECTED RESULT
Hotel | orange white red |  | India
India | yellow black yellow
[NAME] | white blue amber
Spreadsheet: 327747d1403676278-creating-an-attendance-tracker-help-employee-attendance-tracker1
Sheet: Employee Leave Tracker

 | Employee Name | Start Date | End Date | Type of Leave | Value | Comment | Created | Reviewed
 | Employee 1 | 2014-01-03 00:00:00 | 2014-01-03 00:00:00 | CO | 1 | LM
 | Employee 1 | 2014-02-02 00:00:00 | 2014-02-02 00:00:00 | WDO | -0.5
 | Employee 1 | 2014-02-10 00:00:00 | 2014-02-10 00:00:00 | ELH | -0.75 | EARLY HIT 4:30AM
 | Employee 1 | 2014-05-05 00:00:00 | 2014-05-05 00:00:00 | WDO | 1
 | Employee 1 | 2014-10-10 00:00:00 | 2014-10-10 00:00:00 | RTLE | 1
 | Employee 1 | 2014-11-14 00:00:00 | 2014-11-14 00:00:00 | RTLE | 0.5
 | Employee 1 | 2014-12-21 00:00:00 | 2014-12-22 00:00:00 | CO | 1
 | Employee 1 | 2014-12-23 00:00:00 | 2014-12-23 00:00:00 | AL | 0.25
 | Employee 1 | 2014-12-24 00:00:00 | 2014-12-24 00:00:00 | NCNS | 2.25
 | Employee 2 | 2014-01-03 00:00:00 | 2014-01-03 00:00:00 | CO | 1
 | Employee 2 | 2014-02-02 00:00:00 | 2014-02-02 00:00:00 | WDO | -0.5
 | Employee 2 | 2014-02-10 00:00:00 | 2014-02-10 00:00:00 | AL | 0.5
 | Employee 2 | 2014-02-10 00:00:00 | 2014-02-10 00:00:00 | ELH | -0.25
 | Employee 2 | 2014-10-10 00:00:00 | 2014-10-10 00:00:00 | RTLE | 1
 | Employee 2 | 2014-11-14 00:00:00 | 2014-11-14 00:00:00 | RTLE | 0.5
 | Employee 2 | 2014-12-21 00:00:00 | 2014-12-22 00:00:00 | CO | 0
 | Employee 2 | 2014-12-24 00:00:00 | 2014-12-24 00:00:00 | NCNS | 2.25
 | Employee 2 | 2014-12-25 00:00:00 | 2014-12-25 00:00:00 | WW | YES
Spreadsheet: 197405d1354331901-if-a-cell-equals-x-then-format-that-many-cells-for-input-ppjn348-bracket-help
Sheet: Round 1

 | Total Points
SOUTH | PPG this RD
WEST
EAST
MIDWEST
Spreadsheet: 830918d1685257871-most-frequent-value-based-on-criteria-edit-most-frequent-value-based-on-criteria
Sheet: Sheet1

Client Number | Client Name | [NAME] | Amount | Sales Month
 | Client 1 | [NAME] | 12 | May |  | If [NAME] is empty, then exclude from calculation.
 | Client 2 | [NAME] | 45 | May |  | Also, if [NAME] is empty or includes the text "Unknown", then exclude from calculation.
 | Client 3 | [NAME] | 27 | May
 | Client 4 | [NAME] | 87 | May |  |  | [NAME] | Which Sales Person appears most frequently overall?
 | Client 5 | [NAME] | 19 | May
 | Client 6 | [NAME] | 52 | June |  |  | [NAME] | Which Sales Person appears most frequently in May?
 | Client 7 | [NAME] | 24 | June
 | Client 8 | [NAME] | 67 | June
 | Client 9 | [NAME] | 42 | June
 | Client 10 | [NAME] | 52 | June
 | Client 11 | [NAME] | 57 | June
 | Client 12 | [NAME] | 93 | May
 | Client 13 |  | 12
 | Client 14 |  | 42
 | Client 15 |  | 36
 | Client 16 |  | 91
 | Client 17 |  | 33
 | Client 18 |  | 18
 | Client 19 |  | 36
 | Client 20 |  | 43
 |  | Unknown PTT
 |  | RES Unknown
 |  | PLF Unknown
 |  | Unknown GRF
Spreadsheet: eric_saibi__9813__9-24-01
Sheet: Summary

Flow Date |  | Available Off Peak Capacity |  |  |  |  |  |  | Available On Peak Capacity |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Available Off Peak Capacity
2001-09-24 00:00:00
Counterparty |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
[NAME] |  |  |  |  | 30 | 30 | 30 | 35 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 85 | 85
Enron Call |  |  |  |  |  |  |  | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100
Mirant Call |  |  |  |  |  |  |  |  | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50
EPMI-ST-ERCOT |  |  |  |  |  |  |  | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20.5
ERCOT-IMBALANCE |  |  |  |  | -30 | -30 | -30 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -85 | -85 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Total
[NAME]: |  | Deal Details
20.5
Deal_id |  | CP | Volume | Price | Start Hour |  | End Hour
 |  | Mirant Call | -50 |  | 8 |  | 24
784524.1 |  | [NAME] | 30 | 20.5 | 4 |  | 6
784524.1 |  | [NAME] | 35 | 20.5 | 7 |  | 7
784524.1 |  | [NAME] | 50 | 20.5 | 8 |  | 22
784524.1 |  | [NAME] | 85 | 20.5 | 23 |  | 24
785698.1 |  | ERCOT-IMBALANCE | -30 | 0 | 4 |  | 6
785698.1 |  | ERCOT-IMBALANCE | -85 | 0 | 23 |  | 24
785699.1 |  | ERCOT-IMBALANCE | 15 | 0 | 7 |  | 7
785255.1 |  | EPMI-ST-ERCOT | -50 | 20.5 | 7 |  | 22
758660.15 |  | Enron Call | -100 |  | 7 |  | 22
Spreadsheet: darrell_schoolcraft__7316__imball0202
Sheet: NGPL

 | 52862 |  | 6828
 | Measured | Scheduled | Measured | Scheduled | Imbalance
1 | 38753 | 38839 |  | -1752
2 | 40637 | 40684
3 | 40652 | 40676
4 |  |  |  |  |  |  |  | Winkler/Eddy OBA |  |  |  |  |  |  | Gray  OBA
5
6 |  |  |  |  |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount |  | Month | Measured | Scheduled | Imbalance | Index | Amount
7
8 |  |  |  |  |  |  |  | 2001-05-01 00:00:00 | 1103057 | 1120793 |  | 4.01 |  |  | 2001-05-01 00:00:00 | -202726 | -185000 |  | 4.01 |  |  | 2001-05-01 00:00:00 | 4.01
9 |  |  |  |  |  |  |  | 2001-06-01 00:00:00 |  | 1681871 |  | 3.51 |  |  | 2001-06-01 00:00:00 | -153623 | -88473 |  | 3.51 |  |  | 2001-06-01 00:00:00 | 3.51
10 |  |  |  |  |  |  |  | 2001-07-01 00:00:00 |  | 1270571 |  | 2.94 |  |  | 2001-08-01 00:00:00 | -34269 | -27046 |  | 2.85 |  |  | 2001-07-01 00:00:00 | 2.94
11 |  |  |  |  |  |  |  | 2001-08-01 00:00:00 |  | 1418897 |  | 2.85 |  |  | 2001-09-01 00:00:00 | -1191628 | -1210937 |  | 1.96 |  |  | 2001-08-01 00:00:00 | 2.85
12 |  |  |  |  |  |  |  | 2001-09-01 00:00:00 | 1109912 | 1111335 |  | 1.96 |  |  |  |  |  |  |  |  |  | 2001-09-01 00:00:00 | 1.96
13
14 |  |  |  |  |  |  |  | 5/01 - 9/01  balance |  |  |  |  |  |  | 5/01 - 9/01  balance
15
16 |  |  |  |  |  |  |  | Volume balance @ 4/30/01 |  |  | 19880 |  |  |  | Volume balance @ 4/30/01 |  |  | 37185
17
18
19
20
21
22
23
24
25
26
27
28
29
30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10000 | 2
31 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -10000 | 1.5
2002-01-31 00:00:00 |  |  |  |  | 135609
2002-02-04 00:00:00
CBS Dollars
 |  |  | 338741
Spreadsheet: andy_zipper__285__Book1
Sheet: Sheet1

Cash | 192000
Equity | 4950
 | 1510
 | 19320
 | 5496
 | 20770
 | 60905
 | 5372
 | 6458
 | 5626
 | 6503
 | 6138
 | 36596
 | 38902
 | 32357
 | 142120
 | 2198
 | 84563
 | 82642
 | 69230
 | 3793
 | 5772
 | 9750
 | 122320
 | 44385
 | 21835
 | 5152
 | 38.7
 | 5153.8
 | 5299
 | 7860
 | 247613
 | 5611.92
 | 130000
 | 82000
 | 20000
 | 100000
Total Equity
Fixed Income | 1424760.58
Total Investments
Cash
Equity
Fixed Income