tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 32864d1229029770-name-error-copy-of-parrs-calculator
Sheet: Matrix

Parrs Calculator : Matrix
Tenure | over 12 months
Status | open (deliquent)
Credit Class | Reliability | Single Payment Amount / Date | Two Payments Amounts & Dates | Three Payments Amounts & Dates
B | H | PTP Past Due + Current / 10 bus days after bill due date | 1st pymt past due ptp on due/ 10 bus days | 2nd
B | M | PTP Past Due + Current / | 1st pymt ptp / 10 bus days
B | L
B | R
Spreadsheet: 882491d1730887827-matching-values-across-tables-drsgon-grid-spill-365-aligw
Sheet: Sheet1

Machine A | Machine B | Machine C | SKU | Plant |  |  | SKU | Machine A | Machine A | Machine A | Machine B | Machine B | Machine B | Machine C | Machine C | Machine C
 |  |  | 1 | New York |  |  |  | New York | Wisconsin | Idaho | New York | Wisconsin | Idaho | New York | Wisconsin | Idaho
 |  |  | 1 | Wisconsin |  |  | 1 | X |  |  |  |  |  |  | X
 |  |  | 1 | Idaho |  |  | 2 |  |  |  |  | X | X |  | X
 |  |  | 2 | New York |  |  | 3 | X | X | X |  |  |  |  | X
 |  |  | 2 | Wisconsin
 |  |  | 2 | Idaho
 |  |  | 3 | New York
 |  |  | 3 | Wisconsin
 |  |  | 3 | Idaho
Spreadsheet: 267085d1379944178-slightly-complex-delivery-sheet-for-bakery-bread
Sheet: Bread_subs

[NAME] |  | Today's date |  |  | Production: WED |  | Production: FRI |  | Hubs | Wed | Fri
 |  | Week ending |  |  | WS |  | WS |  | Wharf
 |  |  |  |  | SS |  | SS |  | Green
 |  |  |  |  | RY |  | RY |  | Lilac
 |  |  |  |  | SP |  | SP |  | Fabric
 |  |  |  |  | Total |  | Total |  | Wood
 |  |  |  |  |  |  |  |  | H&C
 |  |  |  |  |  |  |  |  | Opposite
 |  |  |  |  |  |  |  |  | Tabitha
 |  |  |  |  |  |  |  |  | GreenAct
 |  |  |  |  |  |  |  |  | TOTAL
Name | [NAME] | Address | Phone | Drop-off | Sub period | Week Start | Week End | No. | Bread | Days | Paid | Invoice # | Helper 1 | Helper 2 | Notes | Paying SUBS
[NAME] |  |  |  | E | 12 weeks | 2013-08-19 00:00:00 |  | 1 | SS | Fri | Yes |  |  |  |  | 0
Ipsum |  |  |  | E | 4 weeks | 2013-09-02 00:00:00 |  | 1 | SP | Fri | Yes |  |  |  |  | 1
[NAME] |  |  |  | C | 12 weeks | 2013-08-12 00:00:00 |  | 1 | SP | Wed | Yes |  |  |  |  | 0
[NAME] |  |  |  | G | 4 weeks | 2013-09-09 00:00:00 |  | 1 | SS | Wed | Yes |  |  |  |  | 1
[NAME] |  |  |  | G | 4 weeks | 2013-09-09 00:00:00 |  | 1 | SS | Fri | Yes |  |  |  |  | 1
[NAME] |  |  |  | A | 12 weeks | 2013-08-12 00:00:00 |  | 1 | SP | Wed | Yes |  |  |  |  | 0
[NAME] |  |  |  | E | 12 weeks | 2013-09-02 00:00:00 |  | 1 | SP | Wed | Yes |  |  |  |  | 0
[NAME] |  |  |  | F | 12 weeks | 2013-08-12 00:00:00 |  | 1 | SP | Wed | Yes |  |  |  |  | 0
[NAME] |  |  |  | B | 12 weeks | 2013-08-05 00:00:00 |  | 1 | SP | Fri | Yes |  |  |  |  | 0
[NAME] |  |  |  | I | 12 weeks | 2013-08-12 00:00:00 |  | 1 | SS | Wed | Yes |  |  |  |  | 0
Molly |  |  |  | E | 52 weeks | 2013-09-09 00:00:00 |  | 1 | WS | Wed | Yes |  |  |  |  | 0
[NAME] |  |  |  | C | 4 weeks | 2013-09-16 00:00:00 |  | 1 | SP | Wed | Yes |  |  |  |  | 1
[NAME] |  |  |  | E | 4 weeks | 2013-08-12 00:00:00 |  | 1 | SS | Wed | Yes |  |  |  |  | 1
Emmanuel |  |  |  | D | 52 weeks | 2013-08-05 00:00:00 |  | 1 | SS | Wed | Yes |  |  |  |  | 0
A |  |  |  | D | 52 weeks | 2013-08-05 00:00:00 |  | 1 | SP | Wed | Yes |  |  |  |  | 0
B |  |  |  | D | 52 weeks | 2013-08-05 00:00:00 |  | 1 | SS | Wed | Yes |  |  |  |  | 0
C |  |  |  | D | 52 weeks | 2013-08-05 00:00:00 |  | 1 | SP | Wed | Yes |  |  |  |  | 0
D |  |  |  | C | Standing Order | 2013-08-12 00:00:00 |  | 1 | WS | Wed | Yes |  |  |  |  | 1
E |  |  |  | E | 12 weeks | 2013-08-26 00:00:00 |  | 1 | SS | Fri | Yes |  |  |  |  | 0
F |  |  |  | E | 12 weeks | 2013-08-19 00:00:00 |  | 1 | WS | Wed | Yes |  |  |  |  | 0
G |  |  |  | H | 24 weeks | 2013-09-02 00:00:00 |  | 1 | RY | Fri | Yes |  |  |  |  | 0
H |  |  |  | A | 4 weeks | 2013-08-12 00:00:00 |  | 1 | SS | Wed | Yes |  |  |  |  | 1
P |  |  |  | F | 4 weeks | 2013-09-09 00:00:00 |  | 1 | SS | Fri | Yes |  |  |  |  | 1
Q |  |  |  | G | 12 weeks | 2013-09-02 00:00:00 |  | 1 | SS | Fri | Yes |  |  |  |  | 0
W |  |  |  | E | 8 weeks | 2013-09-09 00:00:00 |  | 1 | WS | Wed | Yes |  |  |  |  | 1
R |  |  |  | H | 8 weeks | 2013-08-12 00:00:00 |  | 1 | SP | Fri | Yes |  |  |  |  | 1
Spreadsheet: 84036d1284042957-excel-2007-rounding-off-to-a-specific-day-afrondeopdag-1-
Sheet: Blad1

2010-07-27 00:00:00
2010-07-27 00:00:00
2010-08-06 00:00:00
2010-08-27 00:00:00
2010-06-11 00:00:00
2010-07-27 00:00:00
2010-06-18 00:00:00
2010-08-04 00:00:00
2010-08-13 00:00:00
2010-09-03 00:00:00
Spreadsheet: benjamin_rogers__970__NYCA 2002 ICAP Load Forecast
Sheet: Sheet1

NYCA 2002 ICAP Peak Forecast
 | TO | TO [NAME]. | TO | TO
Transmission District | 2001 Peak | 2001 Peak | 2002 Peak | Growth Factor
[NAME] | 1049 | 985 | 990
Con Edison | 12207 | 12225 | 12225
LIPA | 4844 | 4605 | 4667
NYPA | 660 | 660 | 660
NYSEG | 2511 | 2516 | 2498
NMPC | 6283 | 6370 | 6370
Orange and Rockland | 1340 | 1355 | 1380
RGE | 1544 | 1512 | 1560
 | NYCA Weighted Average Growth Rate:
 | NYCA Weather Normalized 2001 Summer Peak: |  | 30780 | MW
NYCA 2002 Summer Peak Forecast including Rockland Electric |  |  |  | MW
 | less: Rockland Electric Peak Contribution |  | 435
NYCA 2002 Summer Peak Forecast Net |  |  |  | MW
 |  |  |  | 2002-01-30 00:00:00
Spreadsheet: 816099d1675365585-formula-to-calculate-new-worth-based-on-todays-date-sample6
Sheet: Sheet1

 |  |  |  | Today's Date
Assets |  |  | Current Net Worth
Asset 1 |  |  | Asset 2 |  |  | Asset 3
Month | Amount |  | Month | Amount |  | Month | Amount
Jan | 5000 |  | Jan | 250 |  | Jan | 2000
Feb | 5250 |  | Feb | 330 |  | Feb | 2100
Mar | 5500 |  | Mar | 450 |  | Mar | 1900
Apr | 6000 |  | Apr | 510 |  | Apr | 1600
May | 6500 |  | May | 550 |  | May | 1400
Jun |  |  | Jun |  |  | Jun
Jul |  |  | Jul |  |  | Jul
Aug |  |  | Aug |  |  | Aug
Sep |  |  | Sep |  |  | Sep
Oct |  |  | Oct |  |  | Oct
Nov |  |  | Nov |  |  | Nov
Dec |  |  | Dec |  |  | Dec
Spreadsheet: 120442d1315308078-problem-with-hours-worked-between-function-working-hours
Sheet: Sheet1

 |  |  |  |  |  | Start date | Start time | End date | End time | Eg given | Calculated
 |  |  |  |  |  | 2011-05-08 00:00:00 | 09:20:00 | 2011-05-08 00:00:00 | 09:40:00 | 00:20:00
 |  |  |  |  |  | 2011-03-08 00:00:00 | 11:47:00 | 2011-03-08 00:00:00 | 12:58:00 | 01:11:00
 |  |  |  |  |  | 2011-08-07 00:00:00 | 10:14:00 | 2011-08-07 00:00:00 | 15:25:00 | 05:11:00
 |  |  |  |  |  | Here are some examples that are incorrect:
 |  |  |  |  |  | 24/08/2011 | 15:00:00 | 25/08/2011 | 10:30:00 | 13:42:00
 |  |  |  |  |  | 20/07/2011 | 15:00:00 | 21/07/2011 | 08:48:00 | 12:00:00
Spreadsheet: 707885d1607525196-how-to-assign-a-country-to-a-specific-area-dashboard
Sheet: SPAIN

Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  lowest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  highest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Antenna cable | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | [NAME] | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Charger | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Recheargable battery | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Full swim kit | AB | MedEL | Cochlear | OM | Custom label
Spreadsheet: 2e5aeae7-3b6a-450d-9224-8b29267c2489
Sheet: Quarterly- Unit Sales Levels 

Quarterly Question: By roughly what percent are your firm's unit sales levels above/below “normal,” if at all?
 | Average percent above/below normal
 | Small firms (1-99 employees) | Mid size firms (100-499 employees) | Large firms (500+ employees)
2012-09-14 00:00:00 | -0.096 | -0.096 | -0.049
2012-12-14 00:00:00 | -0.103 | -0.111 | -0.021
2013-03-15 00:00:00 | -0.122 | -0.068 | -0.033
2013-06-14 00:00:00 | -0.073 | -0.015 | -0.022
2013-09-13 00:00:00 | -0.074 | -0.066 | -0.025
2013-12-09 00:00:00 | -0.086 | -0.022 | -0.038
Spreadsheet: 267458d1380082850-capturing-and-saving-updated-data-from-fields-driven-by-selections-from-drop-down-menu-20130924-1230-mockup-mr-excel
Sheet: Summary-from Database

 |  |  |  |  |  |  |  |  | Employee summary
 | Sheet used to display employee summary based on data in "Data-from database"
 | Name
 | Zeddmore, Winston
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Skills |  |  | Current
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Skill 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Skill 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Skill 3
 | Overall message
 | Strengths
 | Skills that have improved
 | Development objectives
Spreadsheet: 27802d1221481769-time-into-critera-book7
Sheet: Sheet2

0 | 1 | 1 | 1
1 | 0 | 0 | 1 |  |  |  |  |  |  |  | YYYY-09-15
1 | 1 | 1 | 1
0 | 0 | 1 | 0
1 | 1 | 0 | 0
Alt.1 | 3 | 1 | 3 | 7
Alt.2 | 2 | 1 | 2 | 5
Alt.3 | 7
Spreadsheet: 137290d1327040776-how-to-consolidate-large-quantity-of-arrows-into-one-cell-copy-of-consolidation
Sheet: Sheet1

INPUT |  |  | OUTPUT
CODIGO | CANTIDAD |  | CODIGO | CANTIDAD |  | Row Labels | Sum of CANTIDAD
E1200 | 1 |  | E1200 |  |  | E1200 | 5
E2500 | 1 |  | E2500 |  |  | E2500 | 3
E1200 | 1 |  | WAP54G |  |  | WAP610N | 1
E2500 | 1 |  | WUSB54GC |  |  | WUSB54GC | 16
WAP610N | 1 |  |  |  |  | Grand Total | 25
WUSB54GC | 15
E1200 | 2
WUSB54GC | 1
E1200 | 1
E2500 | 1
Spreadsheet: 600743d1543936194-index-match-with-repeating-column-headers-sample-file
Sheet: Sheet1

Task | Activity No (Index 1) | Activity Name | Estimated Completion Date | Actual Complete Date | Comment | Activity No (Index 2) | Activity Name | Estimated Completion Date | Actual Complete | Comment
Task 1 | 1 | Backup old computer | 2017-09-30 00:00:00 | 2018-10-01 00:00:00 | Delayed due to lack of resources | 2 | Install new software | 2015-10-15 00:00:00 | 2015-10-15 00:00:00 | Completed on time
Task 2 | 1 | Submit purchase order for approval | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | Submitted on time | 2 | Order desks | 2017-01-02 00:00:00 | 2017-01-09 00:00:00 | Delayed due to being out of office
Task 3 | 1 | Test work station | 2017-04-04 00:00:00 | 2017-03-01 00:00:00 | Able to complete early due to other projects being on hold | 2 | Write test station report | 2017-04-11 00:00:00 | 2017-03-15 00:00:00 | Able to write report early due to other projects being on hold
 | B | C | D
 | Task | Task 1
 | Row Labels | Estimated Completion Date | Actual Complete Date | Comment
 | Backup old computer |  |  | Delayed due to lack of resources
 | Install new software
Grey cells represent data dump
Purple dotted is what I'm trying to complete
see formulas in these boxes
need to complete yellow boxes
Spreadsheet: daren_farmer__5849__accrued0500
Sheet: Sheet2

Sum of Quantity |  | Sum of Quantity |  | Sum of Quantity |  | Sum of Quantity |  | Sum of Quantity
Period | Total | Period | Total | Period | Total | Period | Total | Period | Total
01-MAY-2000 | -39780 | 01-MAY-2000 | -20454 | 01-MAY-2000 | -78770 | 01-MAY-2000 | -79659 | 01-MAY-2000 | -90176
02-MAY-2000 | -59817 | 02-MAY-2000 | -60808 | 02-MAY-2000 | -56595 | 02-MAY-2000 | -56535 | 02-MAY-2000 | -54382
Grand Total | -99597 | 03-MAY-2000 | -5218 | 03-MAY-2000 | -3242 | 03-MAY-2000 | -3182 | 03-MAY-2000 | -14822
 |  | Grand Total | -86480 | 04-MAY-2000 | 14191 | 04-MAY-2000 | 18947 | 04-MAY-2000 | 5461
 |  |  |  | Grand Total | -124416 | 05-MAY-2000 | -42697 | 05-MAY-2000 | -59838
 |  |  |  |  |  | 06-MAY-2000 | -34026 | 06-MAY-2000 | -31950
 |  |  |  |  |  | 07-MAY-2000 | -110720 | 07-MAY-2000 | -94435
 |  |  |  |  |  | Grand Total | -307872 | 08-MAY-2000 | -52630
 |  |  |  |  |  |  |  | Grand Total | -392772
Spreadsheet: 796283d1663198335-excel-series-and-sequence-formula-needed-hd
Sheet: Sheet1

#[NAME] | SUM | 1st value
5 | 50 | 2
2 | 70 | 10
3 | 50 | 2
10 | 200 | 2
5 | 100 | 2
12 | 300 | 2
4 | 500 | 2
8 | 700 | 2
Spreadsheet: 176344d1345820683-ranking-compiled-data-from-different-worksheets-compilation-of-keywords
Sheet: Groupon - Phrase

Keyword | Competition | Global Monthly Searches | Local Monthly Searches (Canada)
"websites like groupon" | 0.61 | 3600 | 210
"living social" | 0.14 | 1500000 | 60500
"daily deals" | 0.4 | 301000 | 27100
"deal of the day" | 0.46 | 201000 | 22200
"livingsocial" | 0.24 | 450000 | 22200
"best deals" | 0.84 | 450000 | 18100
"group on" | 0.1 | 301000 | 14800
"daily deal" | 0.26 | 301000 | 14800
"groupon clone" | 0.58 | 18100 | 480
"one day deals" | 0.52 | 18100 | 170
"groupon sites" | 0.43 | 1300 | 140
"groupon type sites" | 0.47 | 590 | 58
Spreadsheet: 706856d1606925504-lookup-across-multiple-columns-across-multiple-sheets-test-o365-version-completed
Sheet: Results

 |  |  |  |  |  |  |  |  |  |  | Apple
 |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Orange
 |  | 9865 | [NAME] | Yes | Yellow |  |  |  |  |  | Pear
 |  | 667 | [NAME] | Yes | Purple
 |  | 745 | [NAME] | Yes | Red
 |  | 329 | [NAME] | Yes | Yellow
 |  | 487 | [NAME] | Yes | Purple
Spreadsheet: chris_germany__1764__090100winterload
Sheet: Number Custs Jun 2000

CustType | Program | Effective Month | # Customers |  |  |  |  | Effective Month
Commercial | AGL | 2000-06-01 00:00:00 | 5304 |  |  | CustType | Program | 2000-06-01 00:00:00
Commercial | BGE | 2000-06-01 00:00:00 | 106 |  |  | Commercial | AGL | 5304
Commercial | CGV | 2000-06-01 00:00:00 | 322 |  |  |  | BGE | 106
Commercial | CMD | 2000-06-01 00:00:00 | 321 |  |  |  | CGV | 322
Commercial | COH | 2000-06-01 00:00:00 | 7923 |  |  |  | CMD | 321
Commercial | CPA | 2000-06-01 00:00:00 | 2717 |  |  |  | COH | 7923
Commercial | MIC | 2000-06-01 00:00:00 | 765 |  |  |  | CPA | 2717
Commercial | NIP | 2000-06-01 00:00:00 | 130 |  |  |  | MIC | 765
Commercial | WGL-MD | 2000-06-01 00:00:00 | 84 |  |  |  | NIP | 130
Residential | AGL | 2000-06-01 00:00:00 | 77087 |  |  |  | WGL-MD | 84
Residential | BGE | 2000-06-01 00:00:00 | 3725 |  |  | Commercial Total
Residential | CGV | 2000-06-01 00:00:00 | 3424 |  |  | Residential | AGL | 77087
Residential | CMD | 2000-06-01 00:00:00 | 373 |  |  |  | BGE | 3725
Residential | COH | 2000-06-01 00:00:00 | 113746 |  |  |  | CGV | 3424
Residential | CPA | 2000-06-01 00:00:00 | 37255 |  |  |  | CMD | 373
Residential | MIC | 2000-06-01 00:00:00 | 15115 |  |  |  | COH | 113746
Residential | NIP | 2000-06-01 00:00:00 | 518 |  |  |  | CPA | 37255
Residential | NJG | 2000-06-01 00:00:00 | 10415 |  |  |  | MIC | 15115
Residential | WGL-MD | 2000-06-01 00:00:00 | 1095 |  |  |  | NIP | 518
Residential | WGL-VA | 2000-06-01 00:00:00 | 5040 |  |  |  | NJG | 10415
Residential | PECO | 2000-06-02 00:00:00 | 19477 |  |  |  | PECO | 19477
 |  |  |  |  |  |  | WGL-MD | 1095
 |  |  |  |  |  |  | WGL-VA | 5040
 |  |  |  |  |  | Residential Total
 |  |  |  |  |  | Grand Total
Spreadsheet: 60507d1261044570-sumproduct-formula-not-gathering-correct-data-variance-tracking-test-11b-
Sheet: Employee Search

Employee Variances
Employee: | Employee #14
Track Back: | 180
Month Tracking:
Total NET:
Total ABS:
# of Variances:
Date | [NAME] |  |  |  |  |  |  |  | Days | Back Track | Month Track | [NAME] Sum
 |  |  |  |  |  |  |  |  |  | 30 | 2009-03-01 00:00:00 | Sunday
 |  |  |  |  |  |  |  |  |  | 60 | 2009-04-01 00:00:00 | Monday
 |  |  |  |  |  |  |  |  |  | 90 | 2009-05-01 00:00:00 | Tuesday
 |  |  |  |  |  |  |  |  |  | 180 | 2009-06-01 00:00:00 | Wednesday
 |  |  |  |  |  |  |  |  |  | 365 | 2009-07-01 00:00:00 | Thursday
 |  |  |  |  |  |  |  |  |  | 730 | 2009-08-01 00:00:00 | Friday
 |  |  |  |  |  |  |  |  |  | 1095 | 2009-09-01 00:00:00 | Saturday
 |  |  |  |  |  |  |  |  |  |  | 2009-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2009-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2009-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2010-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2010-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2010-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2010-04-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2010-05-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2010-06-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2010-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2010-08-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2010-09-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2010-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2010-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2010-12-01 00:00:00
Spreadsheet: 707399d1607247606-flight-time-calculating-number-of-minutes-required-by-a-date-to-remain-current-updated-flight-time-currency-log-2
Sheet: Summary

 |  |  |  |  |  |  |  |  |  |  |  |  |  | RPAS Team Flight Currency
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Pilot | Last 90 days | Needed To Gain Currency | Last 80 days | MINUTES NEEDED WITHIN NEXT 10 DAYS | MINUTES WITHIN PRECEEDING 88 DAYS | MINUTES NEEDED WITHIN NEXT 2 DAYS | Notes
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | KEY
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Orange Text | Almost Current: 90-119 minutes time
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Green Text | Current: 120 mins +
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Red Text | NOT CURRENT
 |  |  |  |  |  |  |  |  |  |  |  |  |  | New Pilot 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | New Pilot 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | New Pilot 3
Spreadsheet: 58256d1258545138-looking-up-data-what-i-would-like-to-do-in-g-lookup-etaf
Sheet: Sheet1

 | brain |  | brain | 22 | brain | 22
 | bob |  | [NAME] | 21 | bob | 15
 | [NAME] |  | bob | 15 | [NAME] | 54
 |  |  | [NAME] | 18
 |  |  | jason | 54
 |  |  | [NAME] | 54
 |  |  | I would really like Colum D to check Colum B, for excat matches it will display Data from D & E in F & G
 | brain |  | brain | 22 | brain | 22
 | bob |  | [NAME] | 21 | bob | 15
 | [NAME] |  | bob | 15 | [NAME] | 54
 |  |  | [NAME] | 18 | #N/A | #N/A
 |  |  | jason | 54 | #N/A | #N/A
 |  |  | [NAME] | 54 | #N/A | #N/A
Spreadsheet: 142400d1329824033-if-problem-forum-test
Sheet: Sheet1

1
2 |  | 1
3 |  | 1
4 |  | 1
5 |  | 1
6 |  | 1
7 |  | 1
7 |  | 2
7 |  | 3
8 |  | 1
9 |  | 1
10 |  | 1
10 |  | 2
11 |  | 1
11 |  | 2
12 |  | 1
13 |  | 1
13 |  | 2
13 |  | 3
13 |  | 4
14 |  | 1
Spreadsheet: 83195d1283236723-excel-2007-vlookup-need-multiple-results-test-problem
Sheet: Sheet1

 | Column A | Column B | Column C | Column D
 | Employee No. | Salary
 | 10 | 5000 | ? | ?
 | 20 | 2000 | ? | ?
 | 30 | 4000 | ? | ?
 | 40 | 3000 | ? | ?
 | 50 | 1500 | ? | ?
 | 60 | 2000 | ? | ?
 | 70 | 7000 | ? | ?
 | 80 | 1000 | ? | ?
 | 90 | 3900 | ? | ?
 | 100 | 2000 | ? | ?
 | Now , I have to arrange the salary in descending order in column C and I want in column D the corresponding employee no.
 | I have tried as below.
 | Salary | Employee No. | [NAME] in  descending order | Corresponding Emp. No
 | 5000 | 10 | 7000 | 70
 | 2000 | 20 | 5000 | 10
 | 4000 | 30 | 4000 | 30
 | 3000 | 40 | 3900 | 90
 | 1500 | 50 | 3000 | 40
 | 2000 | 60 | 2000 | 20
 | 7000 | 70 | 2000 | 20 |  | I want in these coloured cells the value of 60 and 100 respectively.
 | 1000 | 80 | 2000 | 20
 | 3900 | 90 | 1500 | 50 |  | Please help me with suitable formula in column D
 | 2000 | 100 | 1000 | 80
Spreadsheet: 31505d1227352127-automatic-popluation-of-a-table-taking-specific-info-from-other-sheets-example
Sheet: Limit Breaches

Breaches
Date | Site | Limit Breach | Result | Limit
2008-02-01 00:00:00 | Site 2 | Cu | 6 | 5
2008-02-02 00:00:00 | Site 1 | Cu | 6 | 5
2008-02-03 00:00:00 | Site 1 | Zn | 12 | 10
2008-02-03 00:00:00 | Site 1 | Fe | 15 | 10
The above has been entered manually but I need it to automatically enter details of any limit breach from the other two tabs
along with the other info above regarding site, date etc...
Spreadsheet: 185087d1349471463-creating-a-product-suggestion-recommendation-form-example-excel
Sheet: Sheet2

 |  | Industry | Alloy Type | Value DRIVERS | Method | GOOD | BETTER | BEST | Product Type
 |  | MVI | Ferrous | Extended tool life | CUTTING/MACHINING | 540 | 55 | 3800 | Semi-Synthetic
 |  | MVI | Ferrous | Superior foam control | CUTTING/MACHINING | 60 | 40 | 70 | Semi-Synthetic
 |  | MVI | Ferrous | Improved part finish | CUTTING/MACHINING | 90 | 55 | 70 | Semi-Synthetic
 |  | MVI | Ferrous | Rust protection | CUTTING/MACHINING | 30 | 20 | 40 | Semi-Synthetic
 |  | MVI | Ferrous | Longer sump life | CUTTING/MACHINING | 50 | 60 | 3800 | Semi-Synthetic
 |  | MVI | Ferrous | Cl Free-Heavy Duty | CUTTING/MACHINING | 66 | 40 | 70 | Semi-Synthetic
 |  | MVI | Ferrous | Extended tool life | GRINDING | 66 | 44 | 60 | Semi-Synthetic
 |  | MVI | Ferrous | Rust protection | GRINDING | 30 | 60 | 20 | Emulsifiable fluid
 |  | MVI | Ferrous | Longer sump life | GRINDING | 20 | 40 | 10 | Emulsifiable fluid
 |  | MVI | Ferrous | Cl Free- Heavy Duty | GRINDING | 10 | 44 | 610 | Emulsifiable fluid
 |  | MVI | Ferrous | Extended tool life | FORMING | 610 | 60 | 20 | Emulsifiable fluid
 |  | MVI | Ferrous | Superior foam control | FORMING | 20 | 40 | 610 | Emulsifiable fluid
 |  | MVI | Ferrous | Improved part finish | FORMING | 610 | 44 | 30 | Emulsifiable fluid
 |  | MVI | Ferrous | Rust protection | FORMING | 30 | 44 | 610 | Emulsifiable fluid
 |  | MVI | Ferrous | Longer sump life | FORMING | 40 | 60 | 20 | Emulsifiable fluid
 |  | MVI | Ferrous | Cl Free- Heavy Duty | FORMING | 60 | 290 | 610 | Emulsifiable fluid
 |  | MVI | Ferrous | Cl Free- Heavy Duty | GRINDING | 400 | 610 | 627 | Sythetic
 |  | MVI | Ferrous | Extended tool life | FORM TAPPING | 500 | 400 | 800 | Sythetic
 |  | MVI | Ferrous | Superior foam control | FORM TAPPING | 40 | 50 | 60 | Sythetic
 |  | MVI | Ferrous | Improved part finish | FORM TAPPING | 3150 | 3200 | 320 | Sythetic
 |  | MVI | Ferrous | Rust protection | FORM TAPPING | 30 | 40 | 50 | Sythetic
 |  | MVI | Ferrous | Longer sump life | FORM TAPPING | 30 | 40 | 50 | Sythetic
 |  | MVI | Ferrous | Cl Free- Heavy Duty | FORM TAPPING | 420 | 400 | 610 | Sythetic
 |  | MVI | Ferrous | Extended tool life | MILLING | 95 | 100 | 495 | Sythetic
 |  | MVI | Ferrous | Extended tool life | MILLING | 99 | 901 | 3900 | Straight Oil
 |  | MVI | Ferrous | Cl Free- Heavy Duty | MILLING | 99 | 3900 | 901 | Straight Oil
 |  | MVI | Ferrous | Extended tool life | DRILLING | 99 | 901 | 3900 | Straight Oil
 |  | MVI | Ferrous | Cl Free- Heavy Duty | DRILLING | 99 | 3900 | 901 | Straight Oil
 |  | MVI | Ferrous | Extended tool life | TURNING | 99 | 901 | 3900 | Straight Oil
 |  | MVI | Ferrous | Cl Free- Heavy Duty | TURNING | 99 | 3900 | 901 | Straight Oil
 |  | MVI | Aluminum | Extended tool life | CUTTING/MACHINING | 99 | 901 | 3900 | Straight Oil
 |  | MVI | Aluminum | Cl Free- Heavy Duty | CUTTING/MACHINING | 99 | 3900 | 901 | Straight Oil
Spreadsheet: 179823d1347384066-using-if-statement-only-4-cells
Sheet: Sheet1

1 | + | 1
2 | - | 1
4 | * | 2
8 | / | 2
4 | ^ | 2
SQRT | of | 16