tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 786433d1657192520-using-filter-to-copy-relevant-data-from-one-excel-workbook-to-another-excel-help-1
Sheet: Sheet2

Name | Position | State | Entity
NAME 1 | MR | SA | 1
[NAME] 2 | MR | SA | 2
NAME 3 | Employee | WA | 2
NAME 4 | Employee | NT | 4
NAME 5 | Manager | TAS | 3
NAME 6 | Employee | WA | 4
NAME 7 | Manager | QLD | 3
[NAME] 8 | BDM | VIC | 4
NAME 9 | Employee | VIC | 5
NAME 10 | MR | SA | 4
Spreadsheet: 265802d1379410583-copying-date-from-text-l-drr-example1
Sheet: גיליון1

 | date | lab | # | site | notes | QD | SSD | WA | PSD | UCS | PL
2013.6.26,MAGAMA 219641,ZANUAH,QD(2.48),SSD(2.58),WA(3.4)-OK.pdf | 2013.6.26 | [NAME] | 219641 | ZANUAH | OK | 2.48 | 2.58 | 3.4
2013.6.26,MAGAMA 219642,ZANUAH,PSD(NC,136),UCS(26.7),PL(2.9)-OK.pdf | 2013.6.26 | [NAME] | 219642 | ZANUAH | OK |  |  |  | NC,136 | 26.7 | 2.9
2013.6.26,MAGAMA 219641,ZANUAH,QD(2.48),SSD(2.58),WA(3.4)-OK.pdf
2013.6.26,MAGAMA 219642,ZANUAH,PSD(NC,136),UCS(26.7),PL(2.9)-OK.pdf
Spreadsheet: 267932d1380296320-need-excel-2010-pivot-table-with-running-totals-that-reset-to-baseline-test2-requisitions
Sheet: DATA

DATE | REQUISITION # | MONTH | month2 | VENDOR NAME | AMOUNT
2012-09-13 00:00:00 | 58930 |  | 01-SEP | BRADLEY | 4334.15
2012-10-18 00:00:00 | 58933 |  | 02-OCT | EMERY | 100000
2012-10-18 00:00:00 | 58934 |  | 02-OCT | EMERY | 320000
2012-10-18 00:00:00 | 58935 |  | 02-OCT | NANCY | 57000
2012-10-19 00:00:00 | 58936 |  | 02-OCT | HARRISON | 100000
2012-11-05 00:00:00 | 58938 |  | 03-NOV | LINDEL | 26950
2012-11-05 00:00:00 | 59254 |  | 03-NOV | LINDEL | 4454
2012-11-14 00:00:00 | 58942 |  | 03-NOV | WINTER | 1581
2013-01-09 00:00:00 | 58951 |  | 05-JAN | GREENHOUSE | 31048.4
2013-01-30 00:00:00 | 61150 |  | 05-JAN | EMERY | 15821.58
2013-02-12 00:00:00 | 61151 |  | 06-FEB | EMERY | 8500
2013-02-12 00:00:00 | 61152 |  | 06-FEB | BRADLEY | 178128
2013-02-21 00:00:00 | 61154 |  | 06-FEB | GREENHOUSE | 1077
2013-03-01 00:00:00 | 61156 |  | 07-MAR | EMERY | 249018
2013-03-06 00:00:00 | 61158 |  | 07-MAR | HARRISON | 100000
2013-03-13 00:00:00 | 61159 |  | 07-MAR | DELTA | 6900
2013-03-27 00:00:00 | 61161 |  | 07-MAR | DELTA | 12500
2013-04-03 00:00:00 | 61163 |  | 08-APR | Parson | 13997.44
2013-04-03 00:00:00 | 61164 |  | 08-APR | Cannon | 74250
2013-05-13 00:00:00 | 61653 |  | 09-MAY | GREENHOUSE | 86541.25
2013-06-18 00:00:00 | 61654 |  | 10-JUN | EMERY | 381489
2013-05-29 00:00:00 | 61659 |  | 09-MAY | GREENHOUSE | 1515.2
2013-06-06 00:00:00 | 62236 |  | 10-JUN | BRADLEY | 3375
2013-06-13 00:00:00 | 62030 |  | 10-JUN | GREENHOUSE | 14323.86
2013-06-18 00:00:00 | 62237 |  | 10-JUN | BRADLEY | 78128
2013-06-24 00:00:00 | 62239 |  | 10-JUN | Multivista | 16303
2013-07-17 00:00:00 | 62248 |  | 11-JUL | Parson | 4381.43
2013-07-24 00:00:00 | 62250 |  | 11-JUL | GREENHOUSE | 117322.57
2013-07-29 00:00:00 | 62251 |  | 11-JUL | EMERY | 81120.51
2013-08-14 00:00:00 | 62257 |  | 12-AUG | BRADLEY | 4563.74
2013-08-20 00:00:00 | 62613 |  | 12-AUG | Keystone | 56270
2013-08-20 00:00:00 | 62614 |  | 12-AUG | EMERY | 75000
2013-08-21 00:00:00 | 62615 |  | 12-AUG | HARRISON | 100000
2013-08-30 00:00:00 | 62616 |  | 12-AUG | HARRISON | 100000
Spreadsheet: 67697d1268252638-multiple-validation-lists-forum
Sheet: Report

Type | description | Total Overall Owned Invty |  | Week 1 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13 | Week 14 | Week 15 | Week 16 | Week 17 | Week 18 | Week 19 | Week 20 | Week 21 | Week 22 | Week 23 | Week 24
[NAME] | klmno | 75
 |  | Whse3 |  | 0 | 0 | 0 | 0 | 500 | 500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 132179d1323568849-how-to-transfer-specific-product-content-from-one-row-of-a-worksheet-to-another-master-input-database-template
Sheet: All Payments

All Joker Films Payments
Title | Distributor | Date | Currency | Amount | Allocated to [NAME]
ANDFT | Eagle | 2011-12-07 00:00:00 | USD | 14950 | No
DDN | Raven | 2011-12-06 00:00:00 | USD | 245000 | No
Beware | Sparrow | 2011-12-04 00:00:00 | USD | 6550 | No
ANDFT | Cardinal | 2011-12-03 00:00:00 | CAD | 12000 | No
Spreadsheet: 883870d1732621621-if-and-formula-support-abigailrose-range-status-formula-v2-365-aligw
Sheet: Sheet1

Stocked This Year | Stocked Last Year | Status
Stocked | Stocked | LFL
Not Stocked | Not Stocked | Off Plan
Stocked | Not Stocked | Incremental
Not Stocked | Stocked | Discontinued
Item Code | Description | Stocked This Year | Stocked Last Year | Status
1234 | Test 1 | Stocked | Stocked
5678 | Test 2 | Not Stocked | Not Stocked
1648 | Test 3 | Stocked | Not Stocked
Spreadsheet: 208477d1358843417-question-highlight-a-cell-once-a-certain-condition-has-been-satisfied-medaninvoices-1-
Sheet: Sheet1

 | CUSTOMER ABC INVOICES |  |  |  | [NAME] PAYMENTS
 | DATE | INV NO. | AMOUNT (USD) |  | DATE | AMOUNT PAID (USD)
 | 04/01 | 0083 | 500 |  | 18/01 | 300
 | 08/01 | 0284 | 100 |  | 19/01 | 400
 | 09/01 | 0329 | 200 |  | 20/01 | 200
 | 14/01 | 0549 | 800 |  |  | 1000
 | 22/01 | 0829 | 300
 | TOTAL |  |  |  | TOTAL
 | What I would like to do is to have invoice number cell highlighted, once the total amount paid has covered the particular invoice amount. In this case invoice number 0083, 0284 and 0329 should be automatically highlighted, as they have been paid for in full. Thank you!!!
Spreadsheet: 890346d1741756534-formula-help-sample
Sheet: Sheet1

Class | ID | Date | Type | Renewal Count
Renewal | 412900888 | 2025-02-20 00:00:00 | Renewal
Weeks Platinum | 412900888 | 2025-02-20 00:00:00 | Renewal
Weeks Platinum | 146909340 | 2025-02-20 00:00:00 | Renewal
Weeks Platinum | 146909340 | 2025-02-20 00:00:00 | Renewal
Weeks Platinum | 146909340 | 2025-02-20 00:00:00 | Renewal
Weeks Platinum | 777202875 | 2025-02-28 00:00:00 | Renewal
Weeks Platinum | 777202143 | 2025-02-28 00:00:00 | Renewal
Weeks Platinum | DH0300228 | 2025-02-28 00:00:00 | Renewal
CONFIRMATION | 286814179 | 2025-02-28 00:00:00 | Ancillary Product
Points Extension | 2941157008 | 2025-02-28 00:00:00 | Confirmation
Spreadsheet: 193036d1352710116-time-sheet-with-formula-cell-to-work-out-the-hours-work-rota-template-november-2012
Sheet: PALACE

 |  |  |  |  |  | Palace
District 053 |  |  |  | MONDAY |  |  | TUESDAY |  |  | WEDNESDAY |  |  | THURSDAY |  |  | FRIDAY |  |  | SATURDAY |  |  | SUNDAY |  |  | TOTAL | Accrue
 |  |  |  | Start | End | Hrs | Start | End | Hrs | Start | End | Hrs | Start | End | Hrs | Start | End | Hrs | Start | End | Hrs | Start | End | Hrs | Hrs | Hrs
Palace | 37.5 | M | Ash
7.45-22.00 | 37.5 | D | [NAME]
8.45-22.00 S | 18 | 2.5 | Sapphire
[NAME] 71 | 25 | 2.5 | Runako
O/C 19.75hrs | 30 | L1 | Kamil
Confirmed By | 30 | W8 | [NAME]
 | 30 | W1 | Laszio
Anerley | 37.5 | M | [NAME]
8.45-21.30 | 37.5 | D | Sue
9.45-20.00 S | 18 | 2.5 | Charlene
[NAME] 49.5 | 30 | L1 | [NAME]
O/C 7.75hrs | 30 | W1 | [NAME]
Confirmed By
[NAME] | 37.5 | M | Tasha
8.15-21.30 | 37.5 | D | Justin
8.45-22.00 S | 15 | 2.5 | Sophia
[NAME] 63 | 30 | 2.5 | [NAME]
O/c 16.75hrs | 12 | L1 | [NAME]
Confirmed By | 30 | W1 | Jade
[NAME] | 37.5 | M | [NAME]
10.00-21.30 | 22.5 | D | Shanika
9.45-18.30 S | 16 | 2.5 | Charli
CSA HRS 48 | 30 | W4 | Helen
Confirmed By
Spreadsheet: 42984d1241606549-using-the-if-function-to-make-entering-a-word-space-then-word-correct-if-function-to-make-entering-a-word-space-then-word-correct-name-validation
Sheet: Sheet1

 | Text |  |  | Mine | Your formula | MINE
 | [NAME] chharia |  |  | Incorrect | Correct | Correct | 1
 | [NAME] karan |  |  | Incorrect | Correct | Correct
 | vaibhav  chhaw |  |  | Incorrect | Correct | Correct
 | vaibhavasd | 1 trailing spaces in the end and you both are saying true |  | Correct | Correct | Incorrect
 | v b |  |  | Correct | Correct | Correct
 |  |  |  | Incorrect | Incorrect | Incorrect
 |  |  |  | Incorrect | Incorrect | Incorrect
 |  |  |  | Incorrect | Incorrect | Incorrect
 |  |  |  | Incorrect | Incorrect | Incorrect
 |  |  |  | Incorrect | Incorrect | Incorrect
 |  |  |  | Incorrect | Incorrect | Incorrect
 |  |  |  | Incorrect | Incorrect | Incorrect
 |  |  |  | Incorrect | Incorrect | Incorrect
 |  |  |  | Incorrect | Incorrect | Incorrect
 |  |  |  | Incorrect | Incorrect | Incorrect
 |  |  |  |  | Correct
Spreadsheet: 32470d1228665895-filter-data-surveytest
Sheet: MRW

MRW
 |  | CUSTOMER SCORE CRITERIA |  |  |  | AVERAGE PERFORMANCE BY REP
 |  | 1 - 4 | Worse Than our competitor |  |  | 1 - 4.99 | Worse Than our competitor
 |  | 5 -6 | Equal to level of service |  |  | 5 -6.99 | Equal to level of service
 |  | 7 - 8 | Exceeding our competitors service |  |  | 7 - 8.99 | Exceeding our competitors service
 |  | 9 - 10 | Excellent |  |  | 9 - 10 | Excellent
 | Company | SI REP | Price | Stock Availability | Delivery Performance | Quality of Product | Packing | Handling of rejects | Staff Response & reliabilty | Website Opinion Score | Indvidual Account Manager/Rep Score | Overall Perception of SI asa Business | SI Performance Average
 | Company 1 | MRW | 5 | 9 | 10 | 10 | 8 | 10 | 9 | 8 | 8 | 9 | 8.6
 | Company 2 | MRW | 8 | 9 | 8 | 9 | 8 | 7 | 9 | 8 | 9 | 8 | 8.3
 | Company 3 | MRW | 6 | 8 | 8 | 8 | 8 | 9 | 9 | 10 | 9 | 7 | 8.2
 | Company 4 | MRW | 5 | 9 | 10 | 10 | 8 | 10 | 9 | 9 | 9 | 8 | 8.7
 | Company 5 | MRW | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8
 | Company 6 | MRW | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9
 | Company 7 | MRW | 6 | 6 | 6 | 6 | 6 | 10 | 7 | 7 | 7 | 6 | 6.7
 | Company 8 | MRW | 8 | 7 | 8 | 7 | 10 | 10 | 8 | 8 | 8 | 8 | 8.2
 | Company 9 | MRW | 8 | 7 | 8 | 8 | 8 | 10 | 9 | 9 | 9 | 8 | 8.4
 | Company 10 | MRW | 8 | 7 | 7 | 10 | 6 | 10 | 8 | 8 | 8 | 8 | 8
 | Company 11 | MRW | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6
 | Company 12 | MRW | 7 | 7 | 7 | 7 | 7 | 9 | 8 | 8 | 8 | 8 | 7.6
 | Company 13 | MRW | 6 | 6 | 10 | 8 | 10 | 7 | 8 | 8 | 8 | 8 | 7.9
 | Company 14 | MRW | 8 | 8 | 8 | 10 | 10 | 10 | 10 | 9 | 9 | 9 | 9.1
 | Company 15 | MRW | 8 | 8 | 8 | 8 | 8 | 10 | 9 | 8 | 10 | 9 | 8.6
 | Company 16 | MRW | 8 | 6 | 9 | 7 | 8 | 8 | 9 | 9 | 10 | 9 | 8.3
 | Customer Count: 16 |  | 7.125 | 7.5 | 8.125 | 8.1875 | 8 | 8.9375 | 8.4375 | 8.25 | 8.4375 | 8 | 8.1
Spreadsheet: 809776d1671303765-how-to-change-all-data-in-new-page-when-copied-from-old-one-tst-hendrikbez-
Sheet: Chart of Accounts

 | FISKALE JAAR: | Januarie | Februarie | Maart | April | [NAME] | Junie | Jullie | Agustus | September | Oktober | November | [NAME]
COTN / KVDN Boksburg
[NAME] rekeninge
2022
Nommer | Rekeningbeskrywing
 | Inkomste Rekeninge
40001 | Naskoolsentrum**
40100 | Tiendes Ds Pieterr**
40101 | Tiendes Ds Luke
40102 | Hendrik/Nellie
40103 | Mienie
40104 | Kaye
40105 | Thanks to the Lord
40106 | Anoniem
40107 | Ob pmt tiende
40108 | English service
40109 | Thanks to the Lord
40110 | Free Plate
40111
40112
40113
40114
40115
40200 | Tiendes Sondag 01
40201 | Tiendes Sondag 02
40202 | Tiendes Sondag 03
40203 | Tiendes Sondag 04
40204 | Tiendes Sondag 05
40300 | Tiendes Direkte KT 01
40301 | Tiendes Direkte KT 02
40302 | Tiendes Direkte KT 03
40303 | Tiendes Direkte KT 04
40304 | Tiendes Direkte KT 05
40400 | Offers Sondag 01
40401 | Offers Sondag 02
40402 | Offers Sondag 03
40403 | Offers Sondag 04
40404 | Offers Sondag 05
40500 | Sondag Skool 01
40501 | Sondag Skool 02
40502 | Sondag Skool 03
40503 | Sondag Skool 04
40504 | Sondag Skool 05
40600 | Sending Paasoffer
40601 | Sending Dankoffer
40602 | Sending Albaster
40700 | Jeug
40800 | [NAME]
40900 | Dames
41000 | Bejaardes
42000 | Kinderfees
43000 | Fasiliteit Gebruik
44000 | Bou fonds
45000 | Skenkings
46000 | Verf fonds
47000
48000
49000
 | UITGAWES
500000 | Distrik Tiendes
500100 | [NAME] Ds [NAME]
500101 | [NAME] Ds Pieter**
500102 | Lone (Tuinier)(Eric)
500103 | Lone (Skoonmaker)
500104 | Lone (Week 3)
500105 | Lone (Week 4)
500106 | Lone (Week 5)
500200 | [NAME]
500300 | Elektrisiteit
500301 | [NAME] (W&L) STADSRAAD)
500400 | Kruide- niersware
500500 | Skryfbe- hoeftes
500600 | Brandstof
500700 | [NAME].
500800 | [NAME].
500900 | [NAME]
501000 | Bankkoste
501100 | Sending Paasoffer
501200 | Sending Dankoffer
501300 | Sending Alabaster
501400 | Gebou Onder- houd
501500 | Jeugaksie
501600 | [NAME]
501700 | Dames
501800 | Bejaardes
501900 | Alarm
502000 | [NAME] (Parkrand Village)
502100 | Kinderfees
502200 | Sondagskoolrekening:
502300 | Extra (tuinslang)
502400 | Voorskot (Blaine)
502500 | [NAME]
502600 | Doodbad seel
502700 | Discord data
502800 | Belgeld vir polis
502900 | Brandstof
503000 | OKT eete
503100 | Vets
503200 | Print/pna/crazy plastic
503300 | Service Fees
503400 | Monhtly account fee
503500 | Cash Deposit Fee
503600 | Ekstra 01
503700 | Ekstra 02
503800 | Ekstra 03
503900 | Ekstra 04
Spreadsheet: 54932d1254981314-index-and-match-formulas-help
Sheet: Metropolitan Radio Spot Repo..

Time
05:08:00 | #N/A |  |  | Breakfast | 05:08:00
05:09:00 |  |  |  | Breakfast | 05:09:00
05:10:00 |  |  |  | Breakfast | 05:10:00
05:11:00 |  |  |  | Breakfast | 05:11:00
05:12:00 |  |  |  | Breakfast | 05:12:00
09:20:00 |  |  |  | Morning | 09:20:00
09:21:00 |  |  |  | Morning | 09:21:00
09:22:00 |  |  |  | Morning | 09:22:00
09:23:00 |  |  |  | Morning | 09:23:00
09:24:00 |  |  |  | Morning | 09:24:00
Spreadsheet: 785539d1656483516-how-to-use-countifs-with-index-mode-match-excel-help
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | I am trying to find out the most reason for each state using the data validation
 |  | State |  | Reason |  |  | Select -> | QLD |  |  |  |  |  |  |  |  |  |  |  |  |  | SA
 |  | QLD |  | New Job |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VIC
 |  | VIC |  | Underpaid |  |  | [NAME]: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ACT
 |  | SA |  | New Job |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NSW
 |  | SA |  | Other |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QLD
 |  | SA |  | New Job |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NT
 |  | QLD |  | Mental Health |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WA
 |  | SA |  | New Job |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TAS
 |  | QLD |  | New Job |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NZ
 |  | NSW |  | Mental Health
 |  | ACT |  | Not Challenged
 |  | QLD |  | New Job
 |  | SA |  | Other
 |  | NSW |  | New Job
Spreadsheet: 738028d1624772872-getting-information-from-sheet1-and-populatuing-in-sheet2-with-formatting-example
Sheet: Sheet1

Code number | Dept
54215986 | 5626
 | 5626
 | 5626
 | 5626
 | 5626
 | 5626
 | 5626
 | 5626
 | 5626
 | 5626
 | 5626
 | 5626
 | 5626
 | 5626
 | 5626
 | 5626
 | 5626
 | 5626
 | 5626
 | 5626
54245826 | 8954
 | 8954
 | 8954
 | 8954
 | 8954
 | 8954
 | 8954
 | 8954
 | 8954
 | 8954
 | 8954
 | 8954
 | 8954
 | 8954
 | 8954
 | 8954
 | 8954
 | 8954
 | 8954
 | 8954
Spreadsheet: 834413d1687803348-data-integrity-of-the-linked-cells-with-absolute-reference-in-a-sheet-of-wb-wb2-km117-
Sheet: DEST1

[NAME] | Process
 |  | Alt B1
 |  | Alt B1
 |  | Alt C1
 |  | [NAME]
 |  | Alt B1
 |  | Alt C1
 |  | Alt C1
 |  | [NAME]
 |  | Alt B1
 |  | Alt B1
 |  | Alt C1
 |  | [NAME]
 |  | Alt B1
 |  | Alt C1
 |  | Alt C1
 |  | [NAME]
 |  | Alt B1
 |  | Alt B1
 |  | [NAME]
 |  | [NAME]
 |  | Alt B2
 |  | Alt C1
 |  | Alt C1
 |  | [NAME]
 |  | Alt B1
 |  | Alt B1
 |  | [NAME]
 |  | Alt P3
 |  | [NAME]
 |  | Alt C1
 |  | Alt C1
 |  | Alt P3
Spreadsheet: 550200d1512147410-table-formatting-does-not-extend-when-new-table-rows-are-auto-created-excel-2016-after
Sheet: Data Sheet

 |  |  | Enter Data Here: |  |  |  | Do Not Touch:
 |  |  | Leave "Actual Velocity" blank for future sprints
 |  |  |  |  |  |  |  |  |  |  | 0.3 |  | -0.3
 |  |  | Date | Milestone | Actual Velocity | Planned Scope | Label | Date Marker | Projected Velocity | Completed + Projected | Faster Projected Velocity | Faster Completed + Projected | Slower Projected Velocity | Slower Completed + Projected
 |  |  | 2017-11-21 00:00:00 | Start | 0 | 1890 | 11/21  2017  Start |  |  | 0 |  | 0 |  | 0
 |  |  | 2017-12-04 00:00:00 | Sprint 1.1 | 160 | 1890 | 12/04  2017  Sprint 1.1 |  |  | 160 |  | 160 |  | 160
 |  |  | 2018-10-18 00:00:00 | Sprint 1.2 | 110 | 1890 | 10/18  2018  Sprint 1.2 |  |  | 270 |  | 270 |  | 270
 |  |  | 2017-11-01 00:00:00 | Sprint 1.3 | 20 | 1890 | 11/01  2017  Sprint 1.3 |  |  | 290 |  | 290 |  | 290
 |  |  | 2017-11-15 00:00:00 | Sprint 1.4 | 300 | 1890 | 11/15  2017  Sprint 1.4 | 5 |  | 590 |  | 590 |  | 590
 |  |  | 2017-11-29 00:00:00 | Sprint 1.5 |  | 1890 | 11/29  2017  Sprint 1.5 |  | 300 | 890 | 390 | 980 | 210 | 800
 |  |  | 2017-12-13 00:00:00 | Sprint 1.6 |  | 1890 | 12/13  2017  Sprint 1.6 |  | 300 | 1190 | 390 | 1370 | 210 | 1010
 |  |  | 2017-12-27 00:00:00 | Sprint 1.7 |  | 1890 | 12/27  2017  Sprint 1.7 |  | 300 | 1490 | 390 | 1760 | 210 | 1220
 |  |  | 2018-01-08 00:00:00 |  |  |  | 01/08  2018 |  | 300 | 1790 | 390 | 2150 | 210 | 1430
Spreadsheet: 60844d1261429958-excel-2007-vlookup-range-lookup
Sheet: Sheet1

Points found | Time
3 | 03:00:00 | 1
3 | 02:30:00 | 2
3 | 02:00:00 | 3
3 | 01:30:00 | 4
3 | 01:00:00 | 5
4 | 03:00:00 | 6
3 | 01:23:00 | 4
Spreadsheet: 118710d1313940117-excel-2008-stock-buy-sell-indicator-buystockpercents_abousetta
Sheet: Sheet1

Price Increase | abousetta
[NAME] | LOOKUP(A2,{-1000,0.01},{"buy",""})
-1
-0.9
-0.8
-0.7
-0.6
-0.5
-0.4
-0.3
-0.2
-0.1
0
0.001
0.002
0.003
0.004
0.005
0.006
0.007
0.008
0.009
0.01
0.011
0.1
0.2
0.3
0.4
0.5
0.6
0.7
0.8
0.9
1
Spreadsheet: 678879d1590095487-finding-consecutive-occurrences-of-countries-parkrun-my-parkrun-record-consecutive-different-countries-reduced
Sheet: All Completed Runs - TH C

MY parkruns - ALL COMPLETED RUNS - THE HOFF CLUB
Unique Country # | Country | Event (Venue) | Date Completed
 | United Kingdom | Coed Cefn-pwll-du parkrun | 2020-02-29 00:00:00
 | Italy | Uditore parkrun | 2020-03-07 00:00:00
 | Sweden | Örebro parkrun | 2020-03-14 00:00:00
Spreadsheet: 74000d1274581483-conditional-formating-when-formula-is-conditional-formating
Sheet: Sheet1

 |  |  |  |  | June |  |  |  |  |  |  |  | Formating colours
 |  |  |  |  |  |  |  |  |  |  |  |  |  | - value is less than 3.5
 |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | - value is beetween 3.5 and 8
 |  |  |  |  | 5 | 6 | 7 | 8 | 9 | 10 | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  | - value is greater than 8
 |  |  |  |  | 12 | 13 | 14 | 15 | 16 | 17 | 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  | - upper cell is Day shift
 |  |  |  |  | 19 | 20 | 21 | 22 | 23 | 24 | 25 |  |  | - lower cell is Night shift
 |  |  |  |  | 26 | 27 | 28 | 29 | 30
 |  |  |  |  |  |  |  |  |  |  |  | 2010-06-01 00:00:00 | 2010-06-02 00:00:00 | 2010-06-03 00:00:00 | 2010-06-04 00:00:00 | 2010-06-05 00:00:00 | 2010-06-06 00:00:00 | 2010-06-07 00:00:00 | 2010-06-08 00:00:00 | 2010-06-09 00:00:00 | 2010-06-10 00:00:00 | 2010-06-11 00:00:00 | 2010-06-12 00:00:00 | 2010-06-13 00:00:00 | 2010-06-14 00:00:00 | 2010-06-15 00:00:00 | 2010-06-16 00:00:00 | 2010-06-17 00:00:00 | 2010-06-18 00:00:00 | 2010-06-19 00:00:00 | 2010-06-20 00:00:00 | 2010-06-21 00:00:00 | 2010-06-22 00:00:00 | 2010-06-23 00:00:00 | 2010-06-24 00:00:00 | 2010-06-25 00:00:00 | 2010-06-26 00:00:00 | 2010-06-27 00:00:00 | 2010-06-28 00:00:00 | 2010-06-29 00:00:00 | 2010-06-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 5 | 3 | 25 | 8 | 5 | 65 | 32 | 12 | 35 | 14 | 3
 |  |  |  |  |  |  |  |  |  |  |  | 2 | 7 | 4 | 12 | 3 | 46 | 25 | 2 | 78 | 7 | 8
Spreadsheet: 599786d1543313840-formula-to-remove-duplicates-and-return-a-certain-cells-text-if-duplicates-found-mock-excel-1
Sheet: Sheet1

 | Results column |  |  |  |  |  |  |  |  | Desired results
e |  |  |  |  |  |  |  |  | e | N/A
ttt |  |  |  |  |  |  |  |  | ttt | ttt | (if duplicate is found cell K3 displays text in cell J3)
best |  |  |  |  |  |  |  |  | best | best
best |  |  |  |  |  |  |  |  | best | best
ww |  |  |  |  |  |  |  |  | ww | ww
eee |  |  |  |  |  |  |  |  | eee | N/A | (no duplicate found)
ttt |  |  |  |  |  |  |  |  | ttt | ttt
ttt |  |  |  |  |  |  |  |  | ttt | ttt
ww |  |  |  |  |  |  |  |  | ww | ww
www |  |  |  |  |  |  |  |  | www | www
www |  |  |  |  |  |  |  |  | www | www
ee |  |  |  |  |  |  |  |  | ee | N/A
Spreadsheet: kate_symes__18108__EOL 1-4
Sheet: EOL Deals

EOL Deals | From: 1/1/2001   To: 1/4/2001 |  |  | EnPower Deals | From: 1/1/2001   To: 1/4/2001
Desk | Total MWH | Total Deals |  | Desk | Total MWH | Total Deals
EPMI Long Term California | 60000 | 6 |  | EPMI Long Term California | 437200 | 15
EPMI Long Term Northwest | 139600 | 10 |  | EPMI Long Term Northwest | 1850895 | 50
EPMI Long Term Southwest | 379200 | 12 |  | EPMI Long Term Southwest | 1090914 | 25
EPMI Short Term California | 54600 | 78 |  | EPMI Short Term California | 39200 | 18
EPMI Short Term Northwest | 15200 | 31 |  | EPMI Short Term Northwest | 31600 | 28
EPMI Short Term Southwest | 189800 | 87 |  | EPMI Short Term Southwest | 177200 | 54
Grand Total | 838400 | 224 |  | Grand Total | 3627009 | 190
EOL Deals | From: 1/4/2001   To: 1/4/2001 |  |  | EnPower Deals | From: 1/4/2001   To: 1/4/2001
Desk | Total MWH | Total Deals |  | Desk | Total MWH | Total Deals
EPMI Long Term California | 60000 | 6 |  | EPMI Long Term California | 304000 | 10
EPMI Long Term Northwest | 59600 | 4 |  | EPMI Long Term Northwest | 573575 | 19
EPMI Long Term Southwest | 225200 | 7 |  | EPMI Long Term Southwest | 357200 | 9
EPMI Short Term California | 38800 | 25 |  | EPMI Short Term California | 34800 | 7
EPMI Short Term Northwest | 6400 | 8 |  | EPMI Short Term Northwest | 6400 | 9
EPMI Short Term Southwest | 101000 | 41 |  | EPMI Short Term Southwest | 87000 | 24
Grand Total | 491000 | 91 |  | Grand Total | 1362975 | 78
Spreadsheet: 766045d1643731311-help-needed-with-kpis-in-power-pivot-new-york-kpis-scorecard
Sheet: Trainings KPIs

Platform / Period | Q1 Total trainings | Q1 Total overdues | Q2 Total trainings | Q2 Total overdues | Q3 Total trainings | Q3 Total overdues | Q4 Total trainings | Q4 Total overdues
Platform 1 | 500 | 250 | 550 | 230 | 550 | 225 | 525 | 180
[NAME] | 500 | 225 | 550 | 210 | 550 | 200 | 525 | 100
[NAME] | 500 | 175 | 550 | 165 | 550 | 140 | 525 | 75
Platform / Period | Sum of Q1 Total trainings | Sum of Q1 Total overdues | Sum of Q2 Total trainings | Sum of Q2 Total overdues | Sum of Q3 Total trainings | Sum of Q3 Total overdues | Sum of Q4 Total trainings | Sum of Q4 Total overdues
Platform 1 | 500 | 250 | 550 | 230 | 550 | 225 | 525 | 180
[NAME] | 500 | 225 | 550 | 210 | 550 | 200 | 525 | 100
[NAME] | 500 | 175 | 550 | 165 | 550 | 140 | 525 | 75
Grand Total | 1500 | 650 | 1650 | 605 | 1650 | 565 | 1575 | 355
Spreadsheet: 791337d1660292990-simplify-excel-formula-more-than-64-levels-of-nested-big-formula-options
Sheet: TMS

Extract |  |  |  | Converted | Extended
 | Standard |  |  | 2X a week |  |  |  | 1X a week |  |  | 2X a week |  |  | 3X a week |  |  | 4X a week |  |  | 5X a week |  |  | 6X a week
 |  | 4000 |  |  |  |  |  | Standard | Deep | Complete | Standard | Deep | Complete | Standard | Deep | Complete | Standard | Deep | Complete | Standard | Deep | Complete | Standard | Deep | Complete
 |  |  |  | 1X a week |  |  | 2000
 |  |  |  | 2X a week |  |  | 2500
 |  |  |  | 3X a week |  |  | 3000
 |  |  |  | 4X a week |  |  | 3500
 |  |  |  | 5X a week |  |  | 4000
 |  |  |  |  |  |  | 4500
=VALUE(IFERROR(INDEX(I$9:W$46,MATCH($C$8,$H$9:$H$46,0),MATCH($E$7,$I$7:$W$7,0)+MATCH($B$7,$I$8:$K$8,0)-1),"not found")) |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  | 5500
 |  |  |  |  |  |  | 6000
 |  |  |  |  |  |  | 6500
 |  |  |  |  |  |  | 7000
 |  |  |  |  |  |  | 7500
 |  |  |  |  |  |  | 8000
 |  |  |  |  |  |  | 8500
 |  |  |  |  |  |  | 9000
 |  |  |  |  |  |  | 9500
 |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  | 10500
 |  |  |  |  |  |  | 11000
 |  |  |  |  |  |  | 11500
 |  |  |  |  |  |  | 12000
 |  |  |  |  |  |  | 12500
 |  |  |  |  |  |  | 13000
 |  |  |  |  |  |  | 13500
 |  |  |  |  |  |  | 14000
 |  |  |  |  |  |  | 14500
 |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  | 15500
 |  |  |  |  |  |  | 15500
 |  |  |  |  |  |  | 16000
 |  |  |  |  |  |  | 16500
 |  |  |  |  |  |  | 17000
 |  |  |  |  |  |  | 17500
 |  |  |  |  |  |  | 18000
 |  |  |  |  |  |  | 18500
 |  |  |  |  |  |  | 19000
 |  |  |  |  |  |  | 19500
 |  |  |  |  |  |  | 20000