tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 779617d1651908726-auto-assignment-randomized-with-little-or-no-duplicates-activity-timeline-participant-planning-and-checklists
Sheet: Mentor Checklist

Mentor Name | Cycle | Region | Helper Lookup
[NAME] | C1 | NA
[NAME] | C1 | NA
[NAME] | C1 | NA
[NAME] | C1 | NA
[NAME] | C1 | NA
[NAME] | C1 | NA
[NAME] | C1 | NA
[NAME] | C1 | NA
[NAME] | C1 | NA
[NAME] | C1 | NA
[NAME] | C1 | APAC
[NAME] | C1 | APAC
[NAME] | C1 | APAC
[NAME] | C1 | APAC
[NAME] | C1 | APAC
[NAME] | C2 | NA
[NAME] | C2 | NA
[NAME] | C2 | NA
[NAME] | C2 | NA
[NAME] | C2 | NA
[NAME] | C2 | NA
[NAME] | C2 | NA
[NAME] | C2 | NA
[NAME] | C2 | APAC
[NAME] | C2 | APAC
[NAME] | C2 | APAC
Jailesh Prasad | C2 | APAC
Spreadsheet: 714504d1611247663-help-computing-a-running-total-between-2-sheets-book6
Sheet: Sheet2

Starting Liquid |  | 200000
Mon 01/25 |  | Tue 01/26 |  | Wed 01/27 |  | Thu 01/28 |  | Fri 01/29 |  | Sat 01/30 |  | Sun 01/31
A | B | A | B | A | B | A | B | C | D | C | D | C | D
4
8 | 4
 | 8 | 12
 |  | 2 | 3 | 14
 |  |  |  |  | 13 | 13
 |  |  |  |  |  |  | 14 | 14 | 4
 |  |  |  |  |  |  |  |  | 9 | 13 | 13 | 13 | 13
18210 | 14056 | 24566 | 5223 | 24373 | 12768 | 12768 | 17267 | 17267 | 18780 | 20000 | 20000 | 20000 | 20000
32266 |  | 29789 |  | 37141 |  | 30035 |  | 36047 |  | 40000 |  | 40000
Mon 01/25 |  | Tue 01/26 |  | Wed 01/27 |  | Thu 01/28 |  | Fri 01/29 |  | Sat 01/30 |  | Sun 01/31
A | B | A | B | A | B | A | B | C | D | C | D | C | D
14 | 14 | 14 | 14 | 14 | 4
 |  |  |  |  | 10 | 14 | 14 | 14 | 14 | 14 | 11
 |  |  |  |  |  |  |  |  |  |  | 2 | 11
 |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 13
25969 | 25969 | 25969 | 25969 | 25969 | 22804 | 21539 | 21539 | 21539 | 21539 | 21539 | 20805 | 25187 | 25364
51938 |  | 51938 |  | 48774 |  | 43077 |  | 43077 |  | 42343 |  | 50551
Rows 9-19 represent production line 1
Rows 21-29 represent production line 2
Row 19 is the total amount of liquid used for that day - example, 32,266 used on production line 1 on Monday
Row 29 is the same, but for production line 2
Row 7 represents the running total of where we will be at the end of each day - based off of the usages in rows 19+29
Cell C5 will be manually entered on Monday morning
My goal is to have a running count that incorporates incoming loads of liquid, based off of the schedule on the next sheet
Spreadsheet: 879548d1727123521-dynamic-page-breaks-loader-paperwork-template-copy
Sheet: CALC

[NAME] | TO # | Location | QTY | XX | Extended Material Description | Material Description | SO*Line | [NAME] | Ship-to Name | Delivery | SqSt
Spreadsheet: 140536d1328797551-vlookup-help-summary
Sheet: Suggested Format

Aircraft Program | List Rate | Discount | Net Price
Astra/Astra SP, 135 Recurrent | 14000 | 0.1
[NAME] G1000, 61.55 Initial SIC | 9550 | 0.15
The aircraft listed above would be selectabel from the list of aircraft on tab 1 (13Month Program)
Aircraft Program | List Rate | Discount | Net Price
 |  | 0.1
 |  | 0.1
Spreadsheet: 783583d1654936510-tiered-pricing-waterrates
Sheet: Sheet1

1-10 m3 : 10 x 1,500 = 15,000 |  | Volume boundaries | Rates | Marginal Rates | Usage | Cost
11-15 : 5 x 1.850 = 9.250 |  | 0 | 1500 | 1500 | 100
16-20 : 5 x 2,400 = 12,000 |  | 10 | 1850
> 20 : 80 x 3,000 = 240,000 |  | 15 | 2400
 |  | 20 | 3000
See ….
http://www.mcgimpsey.com/excel/variablerate.html
Spreadsheet: 455136d1460124681-count-down-a-total-when-subtracting-sum-with-decrease
Sheet: Sheet1

name | date | amount | after formula/amount
[NAME] | 2016-01-01 00:00:00 | 100 | 100
george | 2016-02-01 00:00:00 | 200 | 200
[NAME] | 2016-02-09 00:00:00 | 25 | 75
[NAME] | 2016-03-11 00:00:00 | 50 | 25
george | 2016-04-20 00:00:00 | 10 | 190
etc…
Spreadsheet: 29b9faa7-aa1f-483c-a0f3-a34e4092d38d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 11. FINANCE COMMITMENTS, For Plant and Equipment: Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Commercial Finance - Transport equipment ; |  |  | Original | A2413510X | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Commercial Finance - Other plant and equipment ; |  |  | Original | A2413511A | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Commercial Finance - Total ; |  |  | Original | A2413512C | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Lease Finance - Total ; |  |  | Original | A2413513F | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | DERIVED | Month | 1
TOTAL ; |  |  | Original | A2413514J | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 753587d1635536737-average-score-with-2-criteria-test-file
Sheet: MATRIX

Employee | Setup | Call | [NAME]
Employee 1
Employee 2
Employee 3
Employee 4
Employee 5
Spreadsheet: 860515d1708596346-converting-to-date-extract-no-datevalue
Sheet: Date

EFFECTIVE DATE | Datevalue | Text | [NAME] |  | Data-->Text to Colums-->Next-->Next-->Date-->MDY-->Finish
2018-01-30 00:00:00
2016-12-16 00:00:00
2022-10-27 00:00:00
2022-04-06 00:00:00
2019-10-03 00:00:00
2021-09-01 00:00:00
Spreadsheet: 90841d1290551676-cash-flow-circular-reference-nightmare-cashflow-trial
Sheet: Sheet1

Cashflow
 |  | Interest Rate |  | 0.625 |  |  | [NAME] |  | Sep
 |  | Starting Balance |  | 1000 |  |  | Loan Amount |  | 1500
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Bank Balance
 | I want to try and work out what the lowest interest rate is in order for the bank balance to remain positive after it pays the loan
 | I have just used trial and error until the line is above zero
 | Is there anyway in which the interest rate is calculated in order to prevent negative bank balance
 | Without causing a circular reference
 | i.e. If I change any of the other cells that have a border it will calculate the interest rate needed to make the bank balance as close to negative as possible without going negative after the loan is paid off
 | Beyond me! I cant work it out. Thanks for looking at this, it is much appreciated.
 | Please bear in mind that the spreadsheet I am doing this on contains many more rows which adds to the complication!!!!!
 | Thanks!!!!!!!!
Spreadsheet: 734437d1622155636-add-in-a-column-down-dynamic-formulas-book2
Sheet: EEM Schedule 2021

 | Days |  |  |  |  |  | Names
Name 1 |  |  |  |  |  |  | Name 1
Project 1 | 5 |  |  |  |  |  | Name 2
Project 2 | 4 |  |  |  |  |  | Name 3
Project 3 | 8
Project 4 | 5
Project 5 | 4
Name 2
Project 2 | 7
Project 3 | 3
Project 4 | 1
Project 5 | 1
Project 6 | 7
Project 7 | 7
Project 8 | 10
Project 9 | 6
Project 10 | 10
Project 11 | 1
Name 3
Project 12 | 10
Project 13 | 3
Project 14 | 8
Project 15 | 2
Project 16 | 7
Spreadsheet: 0861efc5-0b91-4eb5-99e5-06a9aa0f9ea9
Sheet: Budget Spreadsheet

Program; Term 20XX: Director
Program Dates: Month XX, 20XX to Month XX, 20XX
ORG: 101???
 |  |  | Number of faculty to be supported by participants |  |  | USD to 1 Foreign Currency
Classes: |  |  | 1 |  |  | 1.45
 |  |  |  |  |  |  |  |  |  | People per room | 2
 |  |  | Number of Anticipated Participants |  |  | Activities & Excursions | Cost in Foreign Currency | Cost Per Person in USD |  | Accommodations | Dates | US Currency per room | Cost Per Person | Foreign Currency per room | Cost Per Person
 |  |  | 10 |  |  |  |  | 0
Budget Item | Foreign Currency | USD
[NAME] |  |  |  | The [NAME]. stipend amount is $2000.00
Faculty Benefits |  | 0
[NAME] |  | 700 |  | To & from BNA
Airfare (per person) |  | 0
Airport Transfers | 0 | 0
Housing (per person) |  |  |  |  |  |  |  |  |  |  |  | Total |  | Total
Meals (per person)
Activities & Excursions (per person) |  |  |  |  |  |  |  |  |  | Participant Meals | # of meals included in program | Amount permited per meal |  |  | Cost Per Person
On-site transportation |  |  |  |  |  |  |  |  |  | Breakfast |  | 8
Tips |  |  |  |  |  |  |  |  |  | Lunch |  | 9
Phone Charges |  |  |  |  |  |  |  |  |  | Dinner |  | 19
Contingencies |  | 0 |  |  |  |  |  |  |  | Total
Director Airfare
Director Insurance |  | 36.5 |  |  |  |  |  |  |  | [NAME] | # of students | Amount alloted per student |  |  | Stipend
Director Housing |  |  |  |  |  |  |  |  |  | [NAME] |  | 0
Director Daily Meals
Director Activities |  |  |  |  |  | Total |  |  |  | Faculty Meals | # of meals included in program | Amount permited per meal |  |  | Cost Per Person
Director [NAME] |  | 0 |  |  |  | Phone Usage Charges |  |  |  | Breakfast |  | 8
Director to/from US Airport |  | 0 |  |  |  | Phone ($35 If phone is not returned) |  |  |  | Lunch |  | 9
Director's total cost |  |  |  |  |  | SimCard ($25 If SimCard is not returned) |  |  |  | Dinner |  | 19
 |  |  |  |  |  | Minutes (Mandatory Credit) |  | 40 |  | Total
Total Individual Expenses |  |  |  |  |  | Additional Credit: when account drops below $20, $30 credit will automatically be billed to the program account.
 |  |  |  |  |  | Total
 |  |  |  |  |  | Note:  Students are required to buy insurance for themselves as part of their applications on Horizon's through CISI.  The insurance is $36.50 per person.  There is a link in the Horizon's post acceptance application that explains to students how to complete this portion of the application.
Advertised Program Price |  | $?????
Spreadsheet: 154432d1336423099-more-than-one-countif-jrios_sample_05may12_01
Sheet: Jan-3

DSI North Operations Log
Opener |  |  |  |  |  |  |  | Day of the Week |  | Wednesday
Closer |  |  |  |  |  |  |  | Date
Routes |  | Driver |  | Assistant |  | Stops / Pieces | Door | Carpet | Phone | Area
Zip Codes
98001 | 98001 | 98002 | 98002 | 98002 | 98002 | 98002 | 98003
 |  |  |  |  |  |  |  |  | 98001 |  |  |  | 98001
 |  |  |  |  | 98003
 |  |  |  |  |  |  |  |  | 98001
Spreadsheet: 199987d1355383233-pivot-count-values-greater-than-zero-pivot
Sheet: Pivot

Balance | (All)
Row Labels | Sum of Sales | Sum of Balance | Count of Balance
ABC | 8811 | 37 | 5
BCD | 3772 | 115 | 5
CDE | 3245 | 149 | 7
Grand Total | 15828 | 301 | 17
Spreadsheet: 51866d1251464657-vba-function-doesnt-work-properly-bill2
Sheet: DataSheet

MOVEMENT AREA | TAKA
BOGRA | 3600
BOGRA | 3600
BOGRA | 3600
COX'S BAZAR | 9200
COX'S BAZAR | 9200
BOGRA | 9200
BOGRA | 4200
KONABARI | 4200
RANGPUR | 4200
KONABARI | 4200
KONABARI | 4200
KONABARI | 4200
KONABARI | 4200
KONABARI | 4600
KONABARI | 4600
DINAJPUR | 4600
DINAJPUR | 4600
DINAJPUR | 4800
KONABARI | 4800
KONABARI | 4800
KONABARI | 4800
KONABARI | 4800
CHITTAGONG | 4800
CHITTAGONG | 4800
PABNA | 5200
TANGAIL | 5200
KUSHTIA | 1300
KUSHTIA | 1300
KUSHTIA | 1600
M. BAZAR | 7200
PABNA | 3600
TANGAIL | 4600
Spreadsheet: 0fd1b7c5-ae38-4857-92f7-cdd07e8a3d0d
Sheet: Charts

September In Motion Results |  |  |  |  |  |  |  |  | October In Motion Results
 | Class: |  |  |  |  |  |  |  |  | Class:
This month we are |  |  |  |  |  | min/day |  |  | This month we are |  |  |  |  |  |  | min/day
November In Motion Results |  |  |  |  |  |  |  |  | December Motion Results
 |  | Class: |  |  |  |  |  |  |  | Class:
This month we are |  |  |  |  |  | min/day |  |  | This month we are |  |  |  |  |  | min/day
January In Motion Results |  |  |  |  |  |  |  |  | February In Motion Results
 | Class: |  |  |  |  |  |  |  |  | Class:
This month we are |  |  |  |  |  | min/day |  |  | This month we are |  |  |  |  |  | min/day
March In Motion Results |  |  |  |  |  |  |  |  | April In Motion Results
 | Class: |  |  |  |  |  |  |  |  | Class:
This month we are |  |  |  |  |  | min/day |  |  | This month we are |  |  |  |  |  | min/day
May In Motion Results |  |  |  |  |  |  |  |  | June In Motion Results
 | Class: |  |  |  |  |  |  |  |  | Class:
This month we are |  |  |  |  |  | min/day |  |  | This month we are |  |  |  |  |  | min/day
Month by Month Average |  |  |  |  |  |  |  |  |  | Month by Month Changes (min/day)
 | Class:
 |  |  |  |  |  |  |  |  |  | September
 |  |  |  |  |  |  |  |  |  | October
 |  |  |  |  |  |  |  |  |  | November
 |  |  |  |  |  |  |  |  |  | December
 |  |  |  |  |  |  |  |  |  | January
 |  |  |  |  |  |  |  |  |  | February
 |  |  |  |  |  |  |  |  |  | March
 |  |  |  |  |  |  |  |  |  | April
 |  |  |  |  |  |  |  |  |  | May
 |  |  |  |  |  |  |  |  |  | June
Spreadsheet: 011bad6e-cbac-46d9-8d3a-9eea9ca76b6f
Sheet: Sheet1

CITY NATIONAL CORP | Unnamed: 1 | Unnamed: 2
8-K
01/28/2013
Not Applicable
Check the appropriate box below if the Form
8-K filing is intended to simultaneously
satisfy the filing obligation of the registrant
under any of the following provisions ( see
General Instruction A.2. below):
 | [ ] | Written communications pursuant to Rule
 |  | 425 under the Securities Act (17 CFR 230.425)
 | [ ] | Soliciting material pursuant to Rule 14a-12
 |  | under the Exchange Act (17 CFR 240.14a-12)
 | [ ] | Pre-commencement communications pursuant
 |  | to Rule 14d-2(b) under the Exchange Act
 |  | (17 CFR 240.14d-2(b))
 | [ ] | Pre-commencement communications pursuant
 |  | to Rule 13e-4(c) under the Exchange Act
 |  | (17 CFR 240.13e-4(c))
____________________________
Created by Morningstar Document Research.
http://documentresearch.morningstar.com/
Spreadsheet: 675364d1588258895-deleting-multiple-rows-based-on-one-rows-criteria-test-formatting
Sheet: Sheet1

Acct No | Order Date | Last | First | Code
111 | 2020-01-23 00:00:00 | AAA | ZZZ | GGGG
111 | 2020-01-23 00:00:00 | AAA | ZZZ | 01111
111 | 2020-01-23 00:00:00 | AAA | ZZZ | 01111
222 | 2020-01-06 00:00:00 | BBB | YYY | GGGG
222 | 2020-01-06 00:00:00 | BBB | YYY | 00999
222 | 2020-01-06 00:00:00 | BBB | YYY | 00999
333 | 2020-01-31 00:00:00 | CCC | [NAME] | GGGG
333 | 2020-01-31 00:00:00 | CCC | [NAME] | 01112
333 | 2020-01-31 00:00:00 | CCC | [NAME] | 01112
444 | 2020-01-17 00:00:00 | DDD | WWW | GGGG
444 | 2020-01-17 00:00:00 | DDD | WWW | 09998
444 | 2020-01-17 00:00:00 | DDD | WWW | 09998
555 | 2020-01-09 00:00:00 | EEE | VVV | 09997
555 | 2020-01-09 00:00:00 | EEE | VVV | 09997
666 | 2020-01-24 00:00:00 | FFF | VVV | GGGG
666 | 2020-01-24 00:00:00 | FFF | UUU | GGGG
666 | 2020-01-24 00:00:00 | FFF | UUU | 01113
666 | 2020-01-24 00:00:00 | FFF | UUU | 01113
777 | 2020-01-28 00:00:00 | GGG | TTT | 01114
777 | 2020-01-28 00:00:00 | GGG | TTT | 01114
888 | 2020-01-13 00:00:00 | HHH | SSS | 01115
888 | 2020-01-13 00:00:00 | HHH | SSS | 01115
999 | 2020-01-02 00:00:00 | III | RRR | GGGG
999 | 2020-01-02 00:00:00 | III | RRR | 09996
999 | 2020-01-02 00:00:00 | III | RRR | 09996
Spreadsheet: 148423d1333396619-creating-a-report-to-show-vehicle-tax-due-tax-disc-log-trial
Sheet: BU06 LYK

 |  |  |  |  | BU06 LYK
Registration number : | BU06 LYK |  | Date Taxed | Duration | Tax Expiry  Date | Cost (£)
Manufacturer : | IVECO |  | 2008-09-29 00:00:00 | 12 Months | 2009-10-01 00:00:00 | 180
Specification : | Van (2 Axle) |  | 2009-09-30 00:00:00 | 12 Months | 2010-10-01 00:00:00 | 185
Type : | DAILY 35 VAN |  | 2010-09-01 00:00:00 | 12 Months | 2011-10-01 00:00:00 | 200
1st Registered : | 25.07.06 |  | 2011-09-01 00:00:00 | 12 Months | 2012-10-01 00:00:00 | 210
Engine : | 2300 cc
[NAME] : | 3,500kg
Back To Index
Spreadsheet: 451746d1458322196-help-with-excel-finding-key-words-and-adding-up-values-in-that-row-copy-of-new-scrap
Sheet: PT Graph

Press | Sum of Total Ran | Sum of Total Scrap
1000 | 800 | 50
110 | 255 | 9
225 | 300 | 22
230 | 700 | 36
270 | 400 | 36
400 | 550 | 15
500 | 100 | 5
Grand Total | 3105 | 173
Spreadsheet: 177911d1346514044-find-a-better-solution-to-a-scoring-formula-problemsheet
Sheet: Sheet1

 | TEAMS |  |  |  |  | 1st DOUBLES |  |  |  |  |  |  | 2nd DOUBLES |  |  |  |  |  | 1st Sgls |  |  | 2nd [NAME] |  |  | 3rd Sgls |  |  | 4th Sgls
42 | 85 | 41 | 41 |  | 95 | 121 |  | 41 | 58 |  |  | 25 | 26 | 45 | 25 | 50 | 30 |  | 100 | 60 | 85 | 18 | 45 | 60 | 41 | 95 |  | 11 | 100
81 | 57 | 85 | 59 |  | 46 | 80 |  | 83 | 57 |  |  | 9 | 11 | 81 | 41 | 40 | 26 |  | 60 | 95 | 81 | 30 | 30 | 41 | 33 | 57 |  | 24 | 60
45 | 60 | 22 | 137 |  | 32 | 40 |  | 134 | 79 |  |  | 40 | 26 | 100 | 43 | 40 | 41 |  | 81 | 28 | 140 | 41 | 41 | 98 | 117 | 59 |  | 41 | 50
60 | 30 | 41 | 43 |  | 60 | 84 |  | 23 | 42 |  |  | 40 | 70 | 26 | 35 | 100 | 83 |  | 80 | 60 | 100 | 36 | 30 | 6 | 21 | 76 |  | 45 | 60
30 | 14 |  |  |  | 55 | 40 |  | 32 |  |  |  | 140 | 5 | 35 | 30 | 30 | 70 |  | 55 | 57 | 41 | 41 | 100 | 46 | 41 | 71 |  | 9 | 70
 |  |  |  |  |  | 3DF |  | 1DF |  |  |  | 41 | 59 | 44 | 87 | 62 |  |  | 93 | 46 | 38 | 37 | 36 | 78 | 58 | 57 |  | 13 | 40
 |  |  |  |  |  |  |  |  |  |  |  |  | 44 |  |  |  |  |  | [NAME] | 115 | [NAME] | 41 | 59 | 26 | 21 | 60 |  | 36
 |  |  |  |  |  |  |  |  |  |  |  |  | 38 |  |  |  |  |  |  | 40 | 16 |  | 33 | 68 | 67 | 18 |  | 45
 |  |  |  |  |  |  |  |  |  |  |  |  | 1DF |  |  |  |  |  |  | 2DF | 3DF |  | 87 | 34 |  |  |  | 61
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | 24 |  |  |  | 54
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2DF | 1DF
 |  |  |  |  |  | 3rd DOUBLES |  |  |  |  |  |  | 4th DOUBLES
 |  |  |  |  | [NAME] |  |  | Dale |  |  |  | [NAME] |  |  | [NAME]
 |  |  |  |  | 40 | 63 |  | 30 | 6 |  |  | 95 | 55 |  | 41 | 57
 |  |  |  |  | 81 | 61 |  | 45 | 11 |  |  | 87 | 41 |  | 11 | 57
 |  |  |  |  | 125 | 7 |  | 40 | 24 |  |  | 57 | 45 |  | 134 | 33
 |  |  |  |  | 77 | 125 |  | 55 | 60 |  |  | 60 | 23 |  | 45 | 41
 |  |  |  |  | 54 | 63 |  | 14 | 60 |  |  | 51 | 81 |  | 12 | 30
 |  |  |  |  | 9 | 42 |  | 15 | 39 |  |  | 8 | 138
 |  |  |  |  | XX |  |  | 8 |  |  |  | 3DF | 3DF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <<< This is the formula line
NAME |  |  |  |  | SCORE |  | DARTS |  | AVG |  | NAME |  |  |  | SCORE |  | DARTS |  | AVG |  | NAME |  |  |  | SCORE |  | DARTS |  | AVG
Spreadsheet: 34469d1231774599-move-autofilter-button-to-another-cell-excel_problem_template
Sheet: Blad1

 |  |  | SEARCH
 |  |  | Car
 |  |  | Color
 |  |  | Cost
 |  |  | Spec
 |  |  | RC
 |  |  | Location
 | Car | Color | Cost | Spec | RC | Location
 | Volvo | Red | 5 | 4wd | 123 | Sweden
 | Volvo | Blue | 6 | Diesel | 124 | Sweden
 | Volvo | Green | 7 | 4wd | 123 | Denmark
 | Saab | Red | 10 | Diesel | 125 | Norway
 | Saab | Blue | 8 | Diesel | 125 | Denmark
 | Saab | Green | 6 | 4wd | 126 | Sweden
Spreadsheet: 878091d1725050877-combine-data-in-column-based-on-criteria-in-another-column-combine-data-in-column-based-on-criteria-in-another-column
Sheet: Sheet1

Speaker | Initial Sentence |  | Speaker | Joined Sentence
Speaker 1 | Goats can be many colours. |  | Speaker 1 | Goats can be many colours. Elephants are grey. Squirrels can be red or grey.
Speaker 1 | Elephants are grey.
Speaker 1 | Squirrels can be red or grey.
Speaker 2 | Snow leopards are white. |  | Speaker 2 | Snow leopards are white.
Speaker 1 | Tigers have stripes. |  | Speaker 1 | Tigers have stripes.
Speaker 2 | Leopards have spots. |  | Speaker 2 | Leopards have spots. And so do hyenas.
Speaker 2 | And so do hyenas.
Speaker 1 | Dolphins are grey. |  | Speaker 1 | Dolphins are grey.
Speaker 3 | Fire ants are red. |  | Speaker 3 | Fire ants are red. Goldfish are gold.
Speaker 3 | Goldfish are gold.
Speaker 1 | Robins have a red breast. |  | Speaker 1 | Robins have a red breast.
Speaker 2 | Gorillas are black. |  | Speaker 2 | Gorillas are black.
Spreadsheet: 697626d1601453042-chart-colored-cells-on-a-separate-tab-to-display-conflicts-tester
Sheet: Simplified Results

abalo |  |  | brio |  |  | brio
Portuguese | shock |  | Italian | vivacity |  |  | μπρίο
 |  |  | Latin | stock |  | Italian | vivacity
 |  |  | Portuguese | pride |  | Latin | stock
 |  |  | Romanian | successfully |  | Portuguese | pride
 |  |  | Spanish | verve |  | Romanian | successfully
 |  |  |  |  |  | Spanish | verve
Spreadsheet: 59980d1260497926-how-can-i-fix-value-dreamz
Sheet: Invoice

 |  | Island [NAME]
 |  | 1001 Anchor Cove
 |  | [NAME], Jamaica, B.W.I.
 |  |  |  |  |  |  | Date | 2009-12-10 00:00:00
 |  |  |  |  |  |  | Invoice No
Name:
Address:
City: |  |  |  | Postal Code:
Country:
Item # | Description |  |  |  |  | Quantity | Unit Price | Extended Price
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | Total Sales | 0
Payment Method |  |  |  |  |  |  | Sales Tax | 0
 | Check |  |  |  |  |  | Shipping | 15
 | VISA
 | MasterCard |  |  |  |  |  | TOTAL | 15
 | Discover
 | American Express
Card # |  |  |  | Expiration
 |  | Thank you for your order!
Spreadsheet: 130615d1322491367-formula-too-long-too-many-sheet-names-dummy-ot-more-than-1-code-v3
Sheet: P2-Jan 11 to Jan 24

 |  | Pay Period 2 January 11, 2012 to January 24, 2012
 |  | OT Straight Time | OT  Other | OT  Acting Captain | OT  Acting P/C | Stat Holiday | Acting Captain | Acting  P/C | STAT Acting Captain | STAT Acting P/C | Fire Calls | Meetings | TAPP C | Replace WSIB | Replace Bereavement | Replace Sick | Replace Manpower | Replace Parental Leave | Replace Long Term Disability | Replace Education | Replace Suspension | [NAME] | Time Owing (P/C Only) | OT Tech - Auto Extrication | OT Tech - HAZMAT | OT Tech - Rope | OT Tech - MSA | OT Tech - Other, Not Listed | OT A/C Tech - Auto Extrication | OT A/C Tech - HAZMAT | OT A/C Tech - Rope | OT A/C Tech - MSA | OT A/C Tech - Other, Not Listed
 |  | ST | OTH | OTAC | OTAPC | STAT | AC | APC | ACST | APCST | FC | MT | TAP | WSIB | B | S | M | PL | LTD | ED | SUSP | LTS | TO | AT | HT | RT | MSAT | OTT | ACAT | ACHT | ACRT | ACMSAT | ACOTT
EMP# | Employee 1 | [NAME] too long (formula from post)
EMP# | Employee 2
EMP# | Employee 3
EMP# | Employee 4
EMP# | Employee 5
EMP# | Employee 6
EMP# | Employee 7
EMP# | Employee 8
EMP# | Employee 9
Totals
Spreadsheet: 780656d1652658199-show-top-n-from-excel-data-table-using-slicers-slicers-sample-book
Sheet: Dashboard

 |  |  |  |  |  |  | Want to show Top N?
 | Total |  |  |  |  |  | For example, assuming all slicers are selected, it would look like this:
 |  |  |  |  |  |  | Oregon | 5303.49
 |  |  |  |  |  |  | Oregon | 2139.14
 |  |  |  |  |  |  | California | 1262.2
 |  |  |  |  |  |  | Arizona | 909.77
 |  |  |  |  |  |  | Arizona | 787.99
 |  |  |  |  |  |  | Arizona | 639.61
 |  |  |  |  |  |  | Colorado | 562.93
 |  |  |  |  |  |  | California | -228.91
 |  |  |  |  |  |  | Oregon | -565.8
 |  |  |  |  |  |  | California | -808.65