tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 134801d1325635137-help-with-if-statement-mockup1
Sheet: paste in

 | ID | Name | Class | Date | Gross Period BNAV | Beginning Net Capital Change | [NAME] BNAV
 | Jones_A | [NAME] | A_B | 2011-02-28 00:00:00 | 654 | 0 | 654
 | Jones_A | [NAME] | A_SP3 | 2011-02-28 00:00:00 | 0.01 | 0 | 0.01
 | Jones_A | [NAME] | A_SP4 | 2011-02-28 00:00:00 | 51 | 0 | 51
 | Jones_A | [NAME] | A_SP5 | 2011-02-28 00:00:00 | 64 | 0 | 64
 | Jones_A | [NAME] | A_SP6 | 2011-02-28 00:00:00 | 894984 | 0 | 894984
 | Jones_A | [NAME] | A_SP7 | 2011-02-28 00:00:00 | 61 | 0 | 61
 | Jones_A | [NAME] | A_SP8 | 2011-02-28 00:00:00 | 654 | 0 | 654
 | Smith_P | [NAME] | A_A2 | 2011-02-28 00:00:00 | 65 | 0 | 65
 | Smith_P | [NAME] | A_SP2 | 2011-02-28 00:00:00 | 654 | 0 | 654
 | Smith_P | [NAME] | A_SP3 | 2011-02-28 00:00:00 | 0.011 | 0 | 0.011
 | Smith_P | [NAME] | A_SP4 | 2011-02-28 00:00:00 | 65498 | 0 | 65498
 | Smith_P | [NAME] | A_SP5 | 2011-02-28 00:00:00 | 3213 | 0 | 3213
 | Smith_P | [NAME] | A_SP6 | 2011-02-28 00:00:00 | 654698 | 0 | 654698
 | Smith_P | [NAME] | A_SP7 | 2011-02-28 00:00:00 | 23 | 0 | 23
 | Smith_P | [NAME] | A_SP8 | 2011-02-28 00:00:00 | 6118 | 0 | 6118
 | Andrews_W | [NAME] | A_B | 2011-02-28 00:00:00 | 98471 | 0 | 98471
 | Andrews_W | [NAME] | A_SP2 | 2011-02-28 00:00:00 | 694 | 0 | 694
 | Andrews_W | [NAME] | A_SP3 | 2011-02-28 00:00:00 | 651 | 0 | 651
 | Andrews_W | [NAME] | A_SP4 | 2011-02-28 00:00:00 | 65465 | 0 | 65465
 | Andrews_W | [NAME] | A_SP5 | 2011-02-28 00:00:00 | 6694 | 0 | 6694
 | Andrews_W | [NAME] | A_SP6 | 2011-02-28 00:00:00 | 416 | 0 | 416
 | Andrews_W | [NAME] | A_SP7 | 2011-02-28 00:00:00 | 321 | 0 | 321
 | Andrews_W | [NAME] | A_SP8 | 2011-02-28 00:00:00 | 5479 | 0 | 5479
Spreadsheet: drew_fossum__8889__gallup up front pmt
Sheet: Payment

Double Layered Case - $0.0365 @ $2.42
Fuel cost of power @ 100% LF, 25% peaks hit
Gas heat rates
 | Base rate, 0-25% load factor
 |  | Gas volume |  | MMBtu/d
 |  | Heat rate | 49640 | Btu/hp-hr
 | Variable rate, 25% load factor +
 |  | Gas volume |  | MMBtu/d
 |  | Heat rate | 6070 | Btu/hp-hr
 | Total Mmbtu/d
 | Fuel cost of power @ 100% LF, 25% peaks hit
 |  | Gas volume |  | MMBtu
 |  | Value of gas
 |  | Less:
 |  | O&M | 150000
 |  | Rebate | 999332.3424602705
 |  | Value of Gas Stream
 |  | Fuel cost
 |  | kW hours
 |  | $/kWh
 | Year One Payment:
 |  | Value Creation
 |  | ECS Adder | 500000
 |  | Monetization
 |  | ECS Option | 0
 |  | Total
 | Total
Spreadsheet: darrell_schoolcraft__7364__imball0201
Sheet: EOG

 | 500249 |  | 500260 |  | 500646 |  | 500598
 | Pronghorn |  | Pitchfork Ranch |  | Tristi Draw |  | EOG/TW Eddy
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 10708 | 11500 | 8161 | 8800 |  | 7800
2 | 10744 | 11500 | 7789 | 8800 | 70 | 7800
3 | 10863 | 11500 | 7744 | 8800 | 3645 | 7800
4 | 10242 | 11500 | 8002 | 8800 | 5612 | 7800
5 | 10778 | 10500 | 8365 | 7800 | 7669 | 7800
6 | 10431 | 10500 | 8128 | 7800 | 7973 | 7800
7 | 10424 | 10500 | 8598 | 7800 | 7892 | 7800
8 | 10274 | 10500 | 7816 | 7800 | 7851 | 7800
9 | 10910 | 10500 | 8098 | 7800 | 7846 | 7800
10 | 10835 | 10414 | 8179 | 7800 | 7955 | 7800
11 | 10923 | 10500 | 8046 | 7800 | 7285 | 7800
12 | 10260 | 10500 | 8250 | 7800 | 7013 | 7800
13 | 10150 | 10500 | 8185 | 7800 | 6965 | 7800
14 | 9670 | 10500 | 7899 | 7800 | 7876 | 7800
15 | 9743 | 10500 | 8341 | 7800 | 4873 | 7800
16 | 9410 | 9350 | 8114 | 7517 | 7114 | 6967
17 | 10064 | 9700 | 7780 | 7900 | 8219 | 7400
18 | 9644 | 9700 | 7586 | 7900 | 8311 | 6400
19 | 9194 | 9000 | 8104 | 8000 | 7883 | 7000
20 | 9281 | 9000 | 8051 | 8000 | 12314 | 7000
21 | 8979 | 8927 | 7845 | 7935 | 7404 | 6943
22 | 5948 | 9000 | 7914 | 8000 | 8924 | 7000
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  |  |  |  |  |  |  | 4536.21
2002-01-22 00:00:00
CBS Volume
 |  |  | -125538
Spreadsheet: michelle_lokay__26703__imball0112
Sheet: CIG

 | Tumbleweed
 | 9198
Day | Measured | Scheduled
1
2
3
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 |  |  | 16648
2001-12-15 00:00:00
CBS Dollars
 |  |  | 383998.2
Spreadsheet: 00b984f6-3370-468f-b365-f2bc43c66b79
Sheet: Example

THIS WORKSHEET MUST BE RETURNED WITH PAYMENT AND UPDATE APPLICATION
 | COMPANY NAME: | Test Client
 | Certificate # | Z-00000-0000 |  |  |  | Issue Date |  | 2014-08-01 00:00:00
 | Worksheet to determine annual certification fee
Depending on the products produced or services provided, fees could be based on more than one level of this schedule.
If you are certified as a partner with another company and that company pays your fees,  you ARE NOT required to return this worksheet.  Retail Stores certifying departments and Restaurants do NOT need to complete this worksheet (see section D of the OTCO Fee Schedule for applicable fees).
Sales from - to (Month/Year): |  | January 2013 - December 2013
Total Organic Sales: |  | 2500000
Retail Products *
 |  | Enter Sales amount
 |  | from last fiscal year |  |  |  | Rate |  |  | FEE
$0 to $500,000 enter here ~~~> |  | 500000 |  |  | X | .5% (.005) | = |  |  |  | A
$500,001 to $2 Million |  | 1500000 |  |  | X | .25% (.0025) | = |  |  |  | B
$2,000,001 to $50 Million |  | 500000 |  |  | X | .05% (.0005) | = |  |  |  | C
$50,000,001 to $100 Million |  |  |  |  | X | .025% (.00025) | = |  |  |  | D
$100,000,001 and over |  |  |  |  | X | .0025% (.000025) | = |  |  |  | E
 | Sub Total Sales |  |  |  |  | Sub Total Fees |  |  |  |  | F
Non-retail and Co-packing Products *
 |  | Enter Sales amount
 |  | from last fiscal year |  |  |  | Rate |  |  | FEE
$0 to $2 Million enter here~~> |  |  |  |  | X | .1% (.001) | = |  |  |  | G
$2,000,001 to $50 Million |  |  |  |  | X | .05% (.0005) |  |  |  |  | H
$50,000,001 to $100 Million |  |  |  |  | X | .025% (.00025) | = |  |  |  | I
$100,000,001 and over |  |  |  |  | X | .0025% (.000025) | = |  |  |  | J
 | Sub Total Sales |  |  |  |  | Sub Total Fees |  |  |  |  | K
 | Total Sales
 |  |  |  |  | TOTAL ANNUAL FEE (Minimum Fee $1000; Maximum $40,000) |  |  | F + K = |  |  | L
* See page 3 of the fee schedule for definition.
 |  |  |  | Inspection Deposit |  |  |  | + | 200 |  | M
See Example for assistance in completing this form |  |  |  | EU assessment (add $295.00) |  |  |  | + |  |  | N
 |  |  |  | New Applicant (add $75.00) |  |  |  | + |  |  | O
 |  |  |  | Livestock fee (add $100.00) |  |  |  | + |  |  | P
 |  | TOTAL DUE |  |  |  |  |  | L + M + N + O + P = |  |  | Q
 | Make checks payable to:  Oregon Tilth, Inc.
 | 2525 SE 3rd Street - Corvallis, OR 97333 - Phone (503)378-0690 - Fax (541) 753-4924
Completed by, Signature: _______________________________________
Completed by, Print name: _______________________________________
Date: ____________________________
Spreadsheet: 848910d1699519810-a-cumulative-formula-is-needed-for-tracking-positive-and-negative-times-for-a-flexi-balanc-flexi-tracker-v2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | (hh:[NAME]) | (hh:[NAME]) | (hh:[NAME])
 | Date | IN | Out | IN | OUT | Any breaks | paid business leave | Contracted to work | total worked today | total worked today | Daily credit or debit | expected running flexi balance
Monday |  | 08:28:00 | 11:48:00 | 13:01:00 | 16:19:00 | 00:00:00 | 00:00:00 | 07:00:00
Tuesday |  | 08:37:00 | 11:53:00 | 13:00:00 | 17:39:00 | 00:00:00 | 00:00:00 | 07:00:00
Wednesday |  | 08:57:00 | 11:50:00 | 12:58:00 | 16:00:00 | 00:00:00 | 00:00:00 | 07:00:00
Thursday |  | 08:50:00 | 11:51:00 | 12:57:00 | 18:37:00 | 00:00:00 | 00:00:00 | 07:00:00
Friday |  | 08:54:00 | 11:51:00 | 12:58:00 | 16:03:00 | 00:00:00 | 00:00:00 | 07:00:00
Spreadsheet: 106709d1303919352-excel-2007-need-help-with-an-excel-project-please-help-book1
Sheet: Details

OS | CPU | Memory | Hard Drive | Graphic Card | MS Office | Theft Protection
Windows 7 Home | Intel core i5 | 4gb DDR3 | [NAME] rpm | 512mb ATI Radeon | MS Home | 1-year protection
Windows 7 Pro | Intel core i7 | 6gb [NAME] | 320 gb @5400 rpm | 1gb ATI Radeon | MS Enterprise | 2-year protection
Windows 7 Ultimate |  | 8gb DDR3 | 180gb SSD | 1gb Nvidia graphics | None | 3-year protection
 |  |  |  |  |  | None
Spreadsheet: 757303d1638184169-trying-to-get-xlookup-to-look-at-2-tables-headwalls
Sheet: Manhole Rates Schedule

 | Pipe Dia
 |  | 0 | 1
 | [NAME] | 1 | 1.25
 | 900 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 1050 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 | 1200 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
 | 1350 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
 | 1500 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
 | 1800 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6
 | 2100 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7
 | 2400 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8
 | 2700 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9
 | 3000
 | Headwall | Labour | Plant | Material | Total
 | Headwall 150 | 10
 | Headwall 225 | 20
 | Headwall 300 | 30
 | Headwall 375 | 40
 | Headwall 450 | 50
 | Headwall 525 | 60
 | Headwall 600 | 7
 | Headwall 750 | 8
 | Headwall 900
Spreadsheet: 269047d1380922891-dropdownl-list-hyperlink-generator
Sheet: Master Sheet

 | Table of Contents
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Ladonnia Hollingsworth
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 |  | Week 1 | Week 2 | Week 3 | Week 4
 | [NAME] | 7 | 10
 | Score
 |  |  |  |  | Overall Score
 |  | Week 1 | Week 2 | Week 3 | Week 4
 | [NAME] | 20
 | Score
 |  |  |  |  | Overall Score
 |  | Week 1 | Week 2 | Week 3 | Week 4
 | [NAME] | 10 | 30
 | Score
 |  |  |  |  | Overall Score
 |  | Week 1 | Week 2 | Week 3 | Week 4
 | [NAME] | 50 | 100
 | Score
 |  |  |  |  | Overall Score
 |  | Week 1 | Week 2 | Week 3 | Week 4
 | [NAME] | 14
 | Score
 |  |  |  |  | Overall Score
 |  | Week 1 | Week 2 | Week 3 | Week 4
 | [NAME] | 80
 | Score
 |  |  |  |  | Overall Score
 |  | Week 1 | Week 2 | Week 3 | Week 4
 | [NAME] | 7
 | Score
 |  |  |  |  | Overall Score
 |  | Week 1 | Week 2 | Week 3 | Week 4
 | [NAME] | 10
 | Score
 |  |  |  |  | Overall Score
 |  | Week 1 | Week 2 | Week 3 | Week 4
 | [NAME] | 30
 | Score
 |  |  |  |  | Overall Score
 |  | Week 1 | Week 2 | Week 3 | Week 4
 | Ladonnia Hollingsworth | 7
 | Score
 |  |  |  |  | Overall Score
 |  | Week 1 | Week 2 | Week 3 | Week 4
 | [NAME] | 14
 | Score
 |  |  |  |  | Overall Score
 |  | Week 1 | Week 2 | Week 3 | Week 4
 | [NAME] | 7
 | Score
 |  |  |  |  | Overall Score
 |  | Week 1 | Week 2 | Week 3 | Week 4
 | [NAME] | 20
 | Score
 |  |  |  |  | Overall Score
 |  | Week 1 | Week 2 | Week 3 | Week 4
 | [NAME] | 10
 | Score
 |  |  |  |  | Overall Score
 |  | Week 1 | Week 2 | Week 3 | Week 4
 | [NAME] | 36
 | Score
 |  |  |  |  | Overall Score
 |  | Week 1 | Week 2 | Week 3 | Week 4
 | [NAME]
 | Score
 |  |  |  |  | Overall Score
 |  | Week 1 | Week 2 | Week 3 | Week 4
 | [NAME]
 | Score
 |  |  |  |  | Overall Score
 |  | Week 1 | Week 2 | Week 3 | Week 4
 | [NAME] | 14
 | Score
 |  |  |  |  | Overall Score
 |  | Week 1 | Week 2 | Week 3 | Week 4
 | [NAME] | 14
 | Score
 |  |  |  |  | Overall Score
 |  | Week 1 | Week 2 | Week 3 | Week 4
 | [NAME] | 21
 | Score
 |  |  |  |  | Overall Score
 |  | Week 1 | Week 2 | Week 3 | Week 4
 | [NAME] | 36
 | Score
 |  |  |  |  | Overall Score
 |  | Week 1 | Week 2 | Week 3 | Week 4
 | [NAME]
 | Score
 |  |  |  |  | Overall Score
 |  | Week 1 | Week 2 | Week 3 | Week 4
 | [NAME] | 7
 | Score
 |  |  |  |  | Overall Score
 |  | Week 1 | Week 2 | Week 3 | Week 4
 | [NAME] | 21
 | Score
 |  |  |  |  | Overall Score
Spreadsheet: joe_parks__14912__TXULSP Avail Cap Elec Gen
Sheet: available capacity

 |  |  | Today's Date:
 | Lone Star Pipeline
Estimated Available Capacity on the TXU Lone Star Pipeline system
Gas Day runs from 9:00 a.m. to 9:00 a.m.
All volumes are expressed in [NAME]/d
The data below is TXU Lone Star Pipeline's best estimate of available capacity based on current operational data.  The available capacity listed
at the various [NAME])  is subject to the nomination process and the operational conditions existing at the time a nomination is confirmed.
The volumes listed below do not represent individual point capacity availability.   All transportation service will be performed subject to the terms
and conditions of your Transportation Agreement.
Please contact TXU Lone Star Pipeline's Transportation Administration Department before scheduling any imbalance makeup.  When
nominating imbalance makeup, please indicate what portion of your nomination is intended as imbalance makeup.  For more information, please
contact your TXU Lone Star Pipeline Transportation Administrator.
Please visit our web site at www.txulsp.com for nomination information and for a list of Major Interconnect Points on our system.
 | Receipt Area Capacity
 | Gas Day | Gas Day
 | 2002-03-28 00:00:00
From the Waha Area | 200000
East of Waha to | 100000
to the Maryneal Compressor
East of Maryneal Compressor | 50000
[NAME] | 100000
(Waller and Ft. Bend Counties)
Line V (30") | 50000
(Ennis to [NAME])
Lines L8A | 0
(Limestone and Freestone Cty)
Line P | 15000
([NAME] Area - for local consumption only)
[NAME] and O (East Texas) | 25000
 | * Carthage Plant OK for 25,000
Spreadsheet: 587588d1535102625-lowest-average-of-student-and-return-student-name-find-lowest-student
Sheet: Sheet1

ID | Subject | score |  | ID | Name | Age
1000 | Math | 80 |  | 1000 | [NAME] | 14
1001 | English | 45 |  | 1001 | [NAME] | 15
1002 | Math | 60 |  | 1002 | [NAME] | 16
1002 | English | 87 |  |  |  | This solution needs to be a formula that must be within one cell and needs to be dynamic(e.g changes).
1001 | English | 50
1000 | Chem | 54 |  |  |  | Q.
1001 | Math | 71 |  |  |  | Return the 2nd letter for the name of a student with the lowest average score?
1002 | Chem | 83
 |  |  |  |  |  | answer in C18, value should be o as [NAME] has the lowest average
 | Answer
Spreadsheet: errol_mclaughlin_jr__10071__Bkrqs823
Sheet: Sheet1

From: | Risk Management -Controls
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Department: | Risk Management
Subject: | Book Request #823
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date:
COUNTERPARTY |  | BOOK PURPOSE |  |  | TAGG |  |  |  |  |  |  |  |  | BOOK INFORMATION |  |  |  |  | Reporting -Subledger
 |  | Type Of Transactions |  |  | Book Mapping
Short Name | [NAME] | Internal | External | Both | Code | Region | P | B | Idx | [NAME] | PHY | Y | Commodity/UOM/Curr | [NAME] | MTM/ACCRUAL | Reason For Book | Date Needed |  | MTM | Prud | Realized
Trade-Track-1 | Trade-Track-1 | X |  |  | )F | CENTRAL | X | X | X | X |  | X | NG/MMBTU/USD | [NAME] | MTM | Trading Track | 2001-07-23 00:00:00
Trade-Track-2 | Trade-Track-2 | X |  |  | )G | CENTRAL | X | X | X | X |  | X | NG/MMBTU/USD | [NAME] | MTM | Trading Track | 2001-07-23 00:00:00
Trade-Track-3 | Trade-Track-3 | X |  |  | )H | CENTRAL | X | X | X | X |  | X | NG/MMBTU/USD | [NAME] | MTM | Trading Track | 2001-07-23 00:00:00
Trade-Track-4 | Trade-Track-4 | X |  |  | )I | WEST | X | X | X | X |  | X | NG/MMBTU/USD | [NAME] | MTM | Trading Track | 2001-07-23 00:00:00
Trade-Track-5 | Trade-Track-5 | X |  |  | )J | WEST | X | X | X | X |  | X | NG/MMBTU/USD | [NAME] | MTM | Trading Track | 2001-07-23 00:00:00
(Note 1) Please ensure access to both production and stage to enter deals, calculate books and set the official flag.
*A unique portfolio/book code will be assigned to your book unless you request a specific portfolio/book code.
BOOK CANNOT BE SET UP IF THERE IS ANY MISSING INFORMATION.
***Please provide login names for book administrators.***
IT SECURITY | Book |  |  |  |  |  |  |  |  |  |  |  | RisktRAC Check List |  | Added (Y/N) | Processors ID
Access List | Administrator*
trohaue | [NAME] |  |  |  |  |  |  |  |  |  |  |  | Created in RisktRAC |  | Y | JB
kkeiser |  |  |  |  |  |  |  |  |  |  |  |  | Hierarchy |  | Y | JB
plove |  |  |  |  |  |  |  |  |  |  |  |  | Master booklist |  | Y | JB
abike |  |  |  |  |  |  |  |  |  |  |  |  | Sent to GCP |  | Y | JB
owinfre |  |  |  |  |  |  |  |  |  |  |  |  | Sent to TAGG/ERMS |  | Y | JB
dbaumba |  |  |  |  |  |  |  |  |  |  |  |  | Active/Inactive Book List
emclaug
 |  |  |  |  |  |  |  |  |  |  |  |  | Any questions, please contact :
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | (x52465)
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | (x52526)
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | (x57197)
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | (x31462)
Spreadsheet: 700125d1602973249-vlookup-no-working-vlookup-not-working
Sheet: Sheet1

 | Pressure Altitude Correction
 | QHN |  | in HG |  | Correction
 | 949 | 951 | 2801 | 2081 | 1900 |  | qnh | 3009
 | 952 | 955 | 2811 | 2820 | 1800 |  | rwy elev | 300
 | 956 | 958 | 2821 | 2830 | 1700 |  | correction |  | should read as -200
 | 959 | 961 | 2831 | 2840 | 1600
 | 962 | 964 | 2841 | 2845 | 1500
 | 965 | 968 | 2846 | 2856 | 1400
 | 969 | 971 | 2857 | 2866 | 1300
 | 972 | 974 | 2868 | 2877 | 1200
 | 975 | 978 | 2878 | 2886 | 1100
 | 979 | 981 | 2887 | 2895 | 1000
 | 982 | 984 | 2896 | 2905 | 900
 | 985 | 988 | 2906 | 2915 | 800
 | 989 | 991 | 2916 | 2925 | 700
 | 992 | 994 | 2926 | 2935 | 600
 | 995 | 997 | 2936 | 2945 | 500
 | 998 | 1001 | 2946 | 2954 | 400
 | 1002 | 1004 | 2955 | 2964 | 300
 | 1005 | 1007 | 2965 | 2974 | 200
 | 1008 | 1011 | 2975 | 2984 | 100
 | 1012 | 1014 | 2985 | 2994 | 0
 | 1015 | 1018 | 2995 | 3004 | -100
 | 1019 | 1021 | 3005 | 3014 | -200
 | 1022 | 1025 | 3015 | 3024 | -300
 | 1026 | 1028 | 2025 | 3034 | -400
 | 1029 | 1031 | 3035 | 3044 | -500
 | 1032 | 1035 | 3045 | 3054 | -600
 | 1036 | 1038 | 3055 | 3065 | -700
 | 1039 | 1042 | 3066 | 3075 | -800
 | 1043 | 1045 | 3076 | 3085 | -900
 | 1046 | 1050 | 3086 | 3095 | -1000
Spreadsheet: 746858d1631078774-rank-by-column-q-data-first-then-by-column-l-data-then-by-column-k-data-to-break-ties-book-2
Sheet: Individual JR.

 |  |  | Test |  |  |  |  |  |  |  | Portfolio
# | Name | County | Correct Number of Test Questions (Don't [NAME]) | TEST Score | Total # of Bonus Questions Correct | Tie-Breaker (Enter -0.000X to order ties) | Test Place | Test Place Points | Total Test Points | Final Test Rank | [NAME] | [NAME] | [NAME] Points | Portfolio Placing | Portfolio Placing Points | Total Portfolio Points | Final Portfoilio Rank | SHOULD BE | SOLUTION
 | [NAME] |  | 42 |  | 5 | 0.0002 |  |  |  |  | 171 |  |  | 9
 | [NAME] |  | 30 |  | 5 | 0.0002 |  |  |  |  | 172 |  |  | 8
 | [NAME] |  |  |  | 4 | 0.0002 |  |  |  |  | 174 |  |  | 7
 | [NAME] |  |  |  | 3 | 0.0003 |  |  |  |  | 174 |  |  | 6
 | [NAME] |  | 20 |  | 5 |  |  |  |  |  | 175 |  |  | 5
 | Parker Miner |  | 41 |  | 5 |  |  |  |  |  | 176 |  |  | 4
 | [NAME] |  | 32 |  | 5 | 0.0001 |  |  |  |  | 177 |  |  | 2
 | [NAME] |  | 40.5 |  | 5 |  |  |  |  |  | 177 |  |  | 3
 | [NAME] |  | 42 |  | 5 | 0.0001 |  |  |  |  | 177 |  |  | 1
 | [NAME] |  |  |  | 4 | 0.0001 |  |  |  |  | 171 |  |  |  |  |  |  | 11
 | [NAME] |  | 0.03 |  |  |  |  |  |  |  | 171 |  |  | 10
 | [NAME] |  | 0.01 |  |  |  |  |  |  |  | 171 |  |  |  |  |  |  | 12
 | [NAME] |  | 24 |  | 5 | 0.0001 |  |  |  |  | 157
 | [NAME] |  |  |  | 4 |  |  |  |  |  | 158
 | [NAME] |  |  |  | 5 | 0.0001 |  |  |  |  | 159
 | [NAME] |  | 24 |  | 4 | 0.0002 |  |  |  |  | 160
 | [NAME] |  |  |  | 3 |  |  |  |  |  | 161
 | Dustee Buhl |  | 23.5 |  | 5 |  |  |  |  |  | 162
 | [NAME] |  | 27 |  | 4 | 0.0002 |  |  |  |  | 163
 | [NAME] |  |  |  | 3 |  |  |  |  |  | 164
 | [NAME] |  |  |  |  |  |  |  |  |  | 165
 | [NAME] |  |  |  | 3 | 0.0003 |  |  |  |  | 166
 | [NAME] |  |  |  | 3 | 0.0003 |  |  |  |  | 167
 | Ellie Thurgood |  | 26 |  | 4 |  |  |  |  |  | 168
 | [NAME] |  |  |  | 4 | 0.0001 |  |  |  |  | 169
 | Destiny Zarate |  | 28 |  | 4 |  |  |  |  |  | 170
 | [NAME] |  |  |  | 3 |  |  |  |  |  | 154
 | [NAME] |  | 32 |  | 4 | 0.0002 |  |  |  |  | 153 |  |  |  |  |  |  | 29
 | [NAME] |  |  |  | 5 |  |  |  |  |  | 152
 | [NAME] |  | 44.5 |  | 5 | 0.0001 |  |  |  |  | 150 |  |  |  |  |  |  | 31
 | [NAME] |  | 19.6 |  | 1 |  |  |  |  |  | 150 |  |  |  |  |  |  | 32
 | [NAME] |  | 27.6 |  | 1 |  |  |  |  |  | 149
 | [NAME] |  | 44.5 |  | 5 | 0.0002 |  |  |  |  | 153 |  |  |  |  |  |  | 28
 | [NAME] |  | 27.8 |  | 1 |  |  |  |  |  | 147
 | [NAME] |  | 41.3 |  | 5 |  |  |  |  |  | 146
 | [NAME] |  | 25.5 |  | 1 |  |  |  |  |  | 145
Spreadsheet: 788314d1658401583-aligning-rows-with-similar-id-from-one-worksheet-into-another-book-etaf
Sheet: pay

Reference | Paid
REC-2022-01-000216 | 800 |  | REC-2022-01-000216 |  | 1
REC-2022-01-000222 | 200
REC-2022-01-000225 | 300
REC-2022-01-000229 | 150
REC-2022-01-000305 | 400
REC-2022-01-000315 | 200
REC-2022-01-000322 | 700
REC-2022-01-000327 | 100
REC-2022-01-000331 | 50
REC-2022-01-000336 | 100
REC-2022-01-000358 | 100
REC-2022-01-000376 | 120
REC-2022-02-000950 | 100
REC-2022-02-001084 | 100
REC-2022-02-001105 | 200
REC-2022-02-001181 | 300
REC-2022-03-001412 | 100
REC-2022-03-001652 | 120
REC-2022-03-001704 | 300
REC-2022-03-001714 | 100
REC-2022-03-001881 | 220
REC-2022-04-002315 | 240
REC-2022-04-002700 | 100
REC-2022-04-002357 | 100
REC-2022-04-002360 | 220
REC-2022-04-002364 | 220
REC-2022-04-002605 | 100
REC-2022-04-002609 | 100
REC-2022-04-002628 | 100
REC-2022-04-002634 | 200
REC-2022-04-002641 | 300
REC-2022-04-002648 | 100
REC-2022-04-002683 | 100
REC-2022-04-002714 | 120
REC-2022-05-002840 | 100
REC-2022-05-002845 | 600
REC-2022-05-002849 | 200
REC-2022-05-002854 | 200
REC-2022-05-002858 | 100
REC-2022-05-002934 | 400
REC-2022-05-002950 | 500
REC-2022-05-002988 | 100
REC-2022-05-003024 | 300
REC-2022-05-003034 | 200
REC-2022-05-003072 | 1120
REC-2022-05-003076 | 300
REC-2022-05-003506 | 50
REC-2022-05-003135 | 650
REC-2022-05-003141 | 550
REC-2022-05-003270 | 450
REC-2022-05-003285 | 1100
REC-2022-05-003291 | 400
REC-2022-05-003308 | 800
REC-2022-06-003514 | 250
REC-2022-06-003518 | 1320
REC-2022-06-003523 | 700
REC-2022-06-003534 | 100
REC-2022-06-003571 | 100
REC-2022-06-003807 | 400
REC-2022-06-003817 | 1080
REC-2022-06-003830 | 300
REC-2022-06-003842 | 100
REC-2022-06-003847 | 600
REC-2022-06-003851 | 520
REC-2022-06-003857 | 820
REC-2022-06-003860 | 500
REC-2022-06-003864 | 400
REC-2022-06-003871 | 820
REC-2022-06-003875 | 2593
REC-2022-06-003977 | 920
REC-2022-06-003982 | 1720
REC-2022-06-003994 | 2600
 | 30723
Spreadsheet: sally_beck__33865__Global Hot List 1207
Sheet: Hotlist - Completed

E N R O N   G L O B A L   M A R K E T S  -  H O T  L I S T |  |  |  |  |  |  |  |  |  |  |  | 4Q00 DEALS COMPLETED
 |  | Deal |  | Value |  |  |  | Deal |  | Value
 |  |  |  |  |  |  |  | Energy West |  | 26
 |  | SUBTOTAL
 |  |  |  |  |  |  |  | SUBTOTAL
 |  | Coal Origination & Finance
 |  | Deal |  | Value |  |  |  | Global Risk Markets
 |  | Coellerici (1) |  | 1300 |  |  |  | Deal |  | Value
 |  | ENV - Germany |  | 350
 |  | SUBTOTAL |  |  |  |  |  | SUBTOTAL
 |  | Deal |  | Value |  |  |  | Deal |  | Value
 |  | SUBTOTAL |  |  |  |  |  | SUBTOTAL
 |  |  |  |  |  |  |  | TOTAL DEALS COMPLETED
Spreadsheet: 736292d1623476795-sumif-based-on-date-range-giving-error-euro-pool-2020-master-sheet
Sheet: Scores

Game | [NAME] | [NAME] | [NAME] | Krishna | Manreet | Ganesh | Balan | [NAME] | [NAME] | [NAME]
1
2
3
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
32
33
34
35
36
TOTAL
Spreadsheet: 58317d1258581925-pulling-multiple-and-varied-of-rows-from-one-sheet-into-another-commission-report-test
Sheet: Incentive Payment Summary

 | Name |  | Employee Name
 | Number |  | Number
 | Employee #: |  | Employee Number
 | Incentive Payment Summary
 |  | Total Incentive Payment | Dealer Incentive | Retail Incentive | Windsor Incentive
 |  | 1137.1229 | 27.968 | 1109.1549 | 0
 | Incentive Payment Details
 | Customer # | Customer Name | Sales | Territory | Cust Type | Currency