tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 707346d1607193160-indirect-using-two-workbooks-sample
Sheet: Overview

 | Asia Funds
 |  | Region | First State Japan | First State China | [NAME] |  |  |  | Sector | First State Japan | First State China | [NAME]
 | 1 | North America |  |  |  |  |  | 1 | Basic Materials
 | 2 | United Kingdom |  |  |  |  |  | 2 | Consumer Cyclical
 | 3 | Europe Developed |  |  |  |  |  | 3 | Financial Services
 | 4 | Europe Emerging |  |  |  |  |  | 4 | Real Estate
 | 5 | Africa/Middle East |  |  |  |  |  | 5 | Communication Services
 | 6 | Japan |  |  |  |  |  | 6 | Energy
 | 7 | Australasia |  |  |  |  |  | 7 | Industrials
 | 8 | Asia Developed |  |  |  |  |  | 8 | Technology
 | 9 | Asia Emerging |  |  |  |  |  | 9 | Consumer Defensive
 | 10 | Latin America |  |  |  |  |  | 10 | Healthcare
 |  | Total |  |  |  |  |  | 11 | Utilities
 |  |  |  |  |  |  |  | 12 | Total
 |  | Country | First State Japan | First State China | [NAME] |  |  |  | Size | First State Japan | First State China | [NAME]
 | 1 |  |  |  |  |  |  | 1 | Giant
 | 2 |  |  |  |  |  |  | 2 | Large
 | 3 |  |  |  |  |  |  | 3 | Mid
 | 4 |  |  |  |  |  |  | 4 | Small
 | 5 |  |  |  |  |  |  | 5 | Micro
 | 6 |  |  |  |  |  |  | 6 | Total
 | 7 | Total
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
Spreadsheet: 85013d1285084635-active-workbook-issue-test_b
Sheet: Region 2

Fro |  | Account:  001 | .R02A01.671000.000 | 0
unting |  | Number | Acct/Sub Description | Source | Category | Journal Name | Description | Cust Document# | Vendor/Customer | Invoice # | PR End Date | Balance/Amount
1342 | 4 | 111111 | R&M Room - FF&E Misc | Payable | Purchase | Purchase Invoice | Ecommerce Invoice | AEL59360280001 | A | 12344 | 2010-08-09 00:00:00 | 6.7
6 | 1 | 222222 | R&M Bldg - Ecolab Protocol | Spreads | Other | Reverses "GNA KA | Vendor 1 |  |  |  |  | -1770.57
1342 | 4 | 111111 | R&M Room - FF&E Misc | Payable | Purchase | Purchase Invoice | Ecommerce Invoice | AEL59360280001 | B | 12344 | 2010-08-09 00:00:00 | 12.26
6 | 1 | 222222 | R&M Bldg - Ecolab Protocol | Spreads | Other | Reverses "GNA KA | Vendor 1 |  |  |  |  | -230.92
6 | 1 | 222222 | R&M D&W - Door Locks/Key Cards | Spreads | Other | 20782AH Other US | ABC vendor |  |  |  |  | 34.77
1342 | 4 | 111111 | R&M Room - FF&E Misc | Payable | Purchase | Purchase Invoice | Ecommerce Invoice | AEL59360280001 | ZONES | 12344 | 2010-08-09 00:00:00 | 78.69
6 | 1 | 222222 | R&M D&W - Door Locks/Key Cards | Spreads | Other | 20784AH Other US | ABC vendor |  |  |  |  | 104.26
1370 | 4 | 111111 | R&M Room - FF&E Misc | Payable | Purchase | Purchase Invoice | Created by TaxLink | AEL59385300001 | FR | 12344 | 2010-08-24 00:00:00 | 3.59
1370 | 4 | 111111 | R&M Room - FF&E Misc | Payable | Purchase | Purchase Invoice | Ecommerce Invoice | AEL59385300001 | xya | 12344 | 2010-08-24 00:00:00 | 41.06
1370 | 4 | 111111 | R&M Room - FF&E Misc | Payable | Purchase | Purchase Invoice | Ecommerce Invoice | AEL59385300001 | B | 12344 | 2010-08-24 00:00:00 | 300.52
6 | 1 | 222222 | R&M D&W - Door Locks/Key Cards | Spreads | Other | 20783AH Other US | ABC vendor |  |  |  |  | 37.2
1370 | 4 | 111111 | R&M Room - FF&E Misc | Payable | Purchase | Purchase Invoice | Ecommerce Invoice | AEL59385300001 | New | 12344 | 2010-08-24 00:00:00 | 26.3
6 | 1 | 222222 | [NAME] | Spreads | Other | 20800AH Other US | EFG stuff |  |  |  |  | 13
6 | 1 | 222222 | [NAME] | Spreads | Other | 20800AH Other US | EFG stuff |  |  |  |  | 118.9
Spreadsheet: 867374d1714201731-copying-data-to-another-sheet-consolidation-aligw
Sheet: Sheet1

Title | Count
TTT333391100020 | 0 |  | TTT333391100020 | 0 |  |  | 0
TTT333391100020 | 0 |  | TTT333305201161 | 1 |  | TTT333305201161 | 1
TTT333391100020 | 0 |  | TTT333356301413 | 5 |  | TTT333356201678 | 3
TTT333305201161 | 0 |  | TTT333356401666 | 0 |  | TTT333356301413 | 5
TTT333305201161 | 0 |  | TTT320509101666 | 0 |  | TTT333356401666 | 0
TTT333305201161 | 1 |  | TTT333356201678 | 3 |  | TTT333391100020 | 0
TTT333305201161 | 0
TTT333305201161 | 0
TTT333305201161 | 0
TTT333305201161 | 0
TTT333305201161 | 0
TTT333305201161 | 0
TTT333305201161 | 0
TTT333356301413 | 0
0 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 1
TTT333356301413 | 1
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 1
TTT333356301413 | 1
TTT333356301413 | 1
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT320509101666 | 0
TTT333356401666 | 0
TTT320509101666 | 0
TTT333356401666 | 0
TTT320509101666 | 0
TTT333356201678 | 1
TTT333356201678 | 1
TTT333356201678 | 1
TTT333356201678 | 0
TTT333356201678 | 0
TTT333356201678 | 0
TTT333356201678 | 0
TTT333356201678 | 0
TTT333356201678 | 0
TTT333356201678 | 0
TTT333356201678 | 0
TTT333356201678 | 0
TTT333356201678 | 0
Spreadsheet: 140785d1328889619-vlookup-function-incorrect-__invoice2
Sheet: Print Price

5" x 4" Print | 0.1
5" x 4.5" Print | 0.11
5" x 5" Print | 0.12
5" x 5.5" Print | 0.13
6" x 4" Print | 0.07
6" x 4.5" Print | 0.08
6" x 5" Print | 0.1
6" x 5.5" Print | 0.1
6" x 6" Print | 0.12
6" x 6.5" Print | 0.12
7" x 5" Print | 0.13
8" x 6" Print | 0.11
8" x 8" Print | 0.25
9" x 6" Print | 0.3
10" x 7" Print | 0.45
10" x 8" Print | 0.48
10" x 8.5" Print | 0.5
10" x 9" Print | 0.52
10" x 9.5" Print | 0.54
10" x 10" Print | 0.58
12" x 8" Print | 0.55
12" x 10" Print | 0.65
14" x 10" Print | 0.7
15" x 10" Print | 0.9
20" x 10" Print | 1
30" x 10" Print | 1.5
Spreadsheet: 139524d1328283602-return-value-2-criteria-many-duplicates-question-updated
Sheet: Sheet1

 |  | LOCATION 1 | LOCATION 2 | LOCATION 3 | LOCATION 4 | LOCATION 5 | LOCATION 6 | LOCATION 7 | LOCATION 8 | LOCATION 9 | LOCATION 10 |  |  | PRODUCT 1 | LOCATION 1 | 8
 | PRODUCT 1 |  |  |  |  |  |  |  |  |  |  |  |  | PRODUCT 1 | LOCATION 2 | 9
 | PRODUCT 2 |  |  |  |  |  |  |  |  |  |  |  |  | PRODUCT 1 | LOCATION 3 | 6
 | PRODUCT 3 |  |  |  |  |  |  |  |  |  |  |  |  | PRODUCT 1 | LOCATION 4 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PRODUCT 1 | LOCATION 5 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PRODUCT 1 | LOCATION 6 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PRODUCT 1 | LOCATION 7 | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PRODUCT 1 | LOCATION 8 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PRODUCT 1 | LOCATION 9 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PRODUCT 1 | LOCATION 10 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PRODUCT 2 | LOCATION 1 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PRODUCT 2 | LOCATION 2 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PRODUCT 2 | LOCATION 3 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PRODUCT 2 | LOCATION 4 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PRODUCT 2 | LOCATION 5 | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PRODUCT 2 | LOCATION 6 | 56
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PRODUCT 2 | LOCATION 7 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PRODUCT 2 | LOCATION 8 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PRODUCT 2 | LOCATION 9 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PRODUCT 2 | LOCATION 10 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PRODUCT 3 | LOCATION 1 | 85
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PRODUCT 3 | LOCATION 2 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PRODUCT 3 | LOCATION 3 | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PRODUCT 3 | LOCATION 4 | 65
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PRODUCT 3 | LOCATION 5 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PRODUCT 3 | LOCATION 6 | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PRODUCT 3 | LOCATION 7 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PRODUCT 3 | LOCATION 8 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PRODUCT 3 | LOCATION 9 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PRODUCT 3 | LOCATION 10 | 5
Spreadsheet: errol_mclaughlin_jr__10058__Budget Temp
Sheet: CC 103820 - G&A Assumption

 |  |  |  | Enron Net Works
 |  |  |  | 2002 Plan
SAP PROFIT CENTER: |  |  | 11105
PROFIT CENTER OWNER: |  |  | [NAME]
SAP COST CENTER/PROJECT: |  |  | 103820
 |  |  |  |  | AVERAGE
 |  |  |  |  | MONTHLY |  | TOTAL
 |  |  |  |  | AMOUNT |  | 2002 |  | ASSUMPTIONS
52001500 | Club Dues |  |  |  | 0
52002000 | Tuition Reimbursement |  |  |  | 0
52002500 | Other Employee Expenses |  |  |  | 0
52003000 | Overtime/Working Meals |  |  |  | 0
52003500 | Client Meals & entertainment |  |  |  | 0
52004000 | Employee Memberships & Dues |  |  |  | 0
52004500 | Travel & Lodging |  |  |  | 0
 | Subtotal Employee Expenses
52503500 | Communication Expenses |  |  |  | 0
 | Subtotal Communication Expense
52502000 | EIS Controllable |  |  |  | 0
 | Infrastructure
52507400 | Outside Services - IT |  |  |  | 0
 | Subtotal Outside Services - IT
52507000 | Outside Services - Legal |  |  |  | 0
52507100 | Outside Services - Audit |  |  |  | 0
52507200 | Outside Services - Contract for OH Allocation |  |  |  | 0
52507300 | Outside Services - Tax |  |  |  | 0
52507500 | Outside Services - Other |  |  |  | 0
52507600 | Outside Services - Engineering |  |  |  | 0
52507700 | Outside Services - Accounting |  |  |  | 0
52508000 | Outside Services - Professional |  |  |  | 0
 | Subtotal Outside Services
52508100 | Postage & Freight Expense |  |  |  | 0
52508500 | Subscriptions & Periodicals |  |  |  | 0
53500000 | Materials and Supplies - Stock |  |  |  | 0
53500500 | Materials and Supplies - Non Stock |  |  |  | 0
53600000 | Office Supplies |  |  |  | 0
 | Subtotal Office Supplies
52500500 | Advertising Expenses |  |  |  | 0
52504100 | Charitable Contributions |  |  |  | 0
53800000 | Equipment Rental - Personal |  |  |  | 0
53801000 | Rent - Office, Warehouse, & Tower - Real |  |  |  | 0
 | Subtotal Rent (3rd Party)
52504500 | Technology - Computer Exp |  |  |  | 0
54000000 | Transportation |  |  |  | 0
52502500 | EPSC Allocation |  |  |  | 0 |  |  |  | $700 a month an employee
 | A&A Allocation |  |  |  | 0
52505500 | Fees & Permits |  |  |  | 0
54005000 | General Business & Admin Expenses |  |  |  | 0
52504200 | Political Contributions |  |  |  | 0
52506500 | Insurance |  |  |  | 0
52506000 | Fines & Penalties |  |  |  | 0
52503000 | Allocations - Other |  |  |  | 0
52504000 | Company Membership & Dues |  |  |  | 0
 | Subtotal Other
57200000 | Depreciation |  |  |  | 0
57000000 | Amortization |  |  |  | 0
 | Subtotal Noncash Expenses
59099900 | Taxes Other than Income |  |  |  | 0
 | TOTAL DIRECT EXPENSES
Allocated Expenses:
 | ENA E-Source |  |  |  | 0
 | ENA HR |  |  |  | 0
 | ENA Internal Support |  |  |  | 0
 | ENA Legal |  |  |  | 0
 | ENA PR |  |  |  | 0
 | ENA Tax |  |  |  | 0
 | ENA Transaction Support |  |  |  | 0
 | Energy Ops |  |  |  | 0
 | ENW Accounting |  |  |  | 0
 | ENW Corporate |  |  |  | 0
 | ENW Graphics Productions |  |  |  | 0
 | ENW HR |  |  |  | 0
 | GTT Allocation |  |  |  | 0
 | IT e-Commerce |  |  |  | 0
 | IT Infrastructure - Passthrough |  |  |  | 0
 | Other Allocations |  |  |  | 0
 | TOTAL ALLOCATED EXPENSES
Spreadsheet: 2b9fee0f-a5b5-44bb-bf27-5434f8ed2361
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
District Name: |  |  | School:
 | 1 = Completed required components
 | with or without accomidations. |  |  | Career
Student | 2 = Completed alternate components | Student |  | Interest | [NAME] | Course
Unique | according to IEP | Portfolio |  | Assessment | Inventory | Plan | Parent
Identifier | See instructions tab--lower left | Complete |  | Completed | Cluster of Interest | Completed | Approval
(10 digit #) | (1 or 2) | (Y) | (N) | (Y or N) | (Code 01 - 16) | (Y or N) | (Y or N)
Spreadsheet: 55182d1255353070-how-to-automatically-alter-formula-when-filters-are-applied-malchemist-2
Sheet: 31546

Date of Order | Date of Order | Year Of Order | Month Of Order | Item No. | Description | Quantity | [NAME] value £ | Order Number | Contract
20080805 | 2008-08-05 | 2008 | 8 | 274295 | Combihammer [NAME] | 1 | 477.75 | 128309 | 31546
20080805 | 2008-08-05 | 2008 | 8 | 375991 | Orbital jig saw WSJ 850-ET 110V | 1 | 174.61 | 128309 | 31546
20080708 | 2008-07-08 | 2008 | 7 | 388214 | Laser range meter PD 40 | 1 | 165 | 127409 | 31546
Spreadsheet: 833642d1687167223-creating-randomized-lists-based-on-multiple-criteria-mappe2
Sheet: Ark1

Person | Sex | Retning | Grade | Group 1 | Group 2 | Group 3 | Group 4 | Group 5 | Group 6 | Group 7
32003 | F | Spanish | 5 | Yes | Yes | Yes | Yes | No | Yes | Yes
40572 | M | Math | 3 | Yes | Yes | Yes | Yes | No | Yes | Yes
31472 | F | P/E | 3 | No | No | Yes | No | No | Yes | No
21023 | F | Spanish | 6 | No | No | Yes | No | No | Yes | No
32259 | F | Math | 4 | Yes | Yes | Yes | Yes | Yes | Yes | Yes
31869 | F | P/E | 3 | Yes | Yes | Yes | Yes | Yes | Yes | Yes
22369 | M | Spanish | 2 | Yes | Yes | Yes | Yes | Yes | Yes | Yes
20248 | F | Math | 3 | Yes | Yes | Yes | Yes | Yes | Yes | Yes
22368 | F | Spanish | 1 | Yes | Yes | Yes | Yes | Yes | Yes | Yes
19687 | F | Math | 3 | Yes | Yes | Yes | Yes | Yes | Yes | Yes
22358 | M | P/E | 4 | Yes | Yes | Yes | Yes | Yes | Yes | Yes
Spreadsheet: 96539d1295921629-cross-reference-between-documents-vlookup-sample
Sheet: Sheet1

Random Names | [NAME] needed from other sheet:
(Must Match other file) | Product | Model | Lease Expiration
Adams |  |  |  |  | =VLOOKUP(A3, YOUR OTHER FILE ARRAY,Column needed,FALSE)
[NAME] |  |  |  |  |  | to get the array, during the creation of this formula,
[NAME] |  |  |  |  |  | simply jump to the other file and select the data you need.
Tanner
[NAME] |  |  |  |  |  | ALL the data you need should be in that array - so you select a rather large area
Jones
 |  |  |  |  |  | Use this formula in B, C, and D - changing the "column needed" to match what you need
 |  |  |  |  |  | out of the array
 |  |  |  |  |  | for example, the other file might be
 |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 |  |  |  |  |  | name | address | city | state | zip | Product | size | Model | lease start | lease expir.
 |  |  |  |  |  | [NAME] | 111 | [NAME] | WI | 12345 | Bag | M | 34A | 2010-01-01 00:00:00 | 2012-02-01 00:00:00
 |  |  |  |  |  | adams | 222 | Seattle | WA | 23456 | Bag | M | 35A | 2009-12-10 00:00:00 | 2013-02-24 00:00:00
 |  |  |  |  |  | abercrombe | 333 | NY | NY | 34567 | Rope | L | 36X2 | 2008-05-01 00:00:00 | 2010-04-01 00:00:00
 |  |  |  |  |  | [NAME] | 444 | SanDiego | CA | 45678 | Tent | XL | 132B | 2007-09-21 00:00:00 | 2011-09-20 00:00:00
 |  |  |  |  |  | and you would select ALL of it. |  |  |  |  |  |  |  | array selection area
 |  |  |  |  |  | So the first "vlookup" would return with column 6, the second one (model) needs column 8
Spreadsheet: 231393d1367034311-need-help-with-data-summary-based-on-a-daily-basis-salesman-performance_solution
Sheet: Calculation

 | Salesman 1 | Salesman 1 | Salesman 1 | Salesman 1 | Salesman 1 | Salesman 1 | Salesman 1 | Salesman 2 | Salesman 2 | Salesman 2 | Salesman 2 | Salesman 2 | Salesman 2 | Salesman 2
Date | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 20 | 30 | 40 | 50 | 60 | 70 | 80
2013-04-26 00:00:00
2013-04-27 00:00:00
2013-04-28 00:00:00
Spreadsheet: 549430d1511712429-combine-cells-based-on-partial-string-rsmc-test
Sheet: PPOSEnew (2)

 |  |  |  |  |  |  |  | Code1 | Code2 |  | DESIRED RESULT 1 |  | DESIRED RESULT 2
 |  |  |  |  |  |  |  | BRITAIN (BR) SS0029 | RSMC |  | RSMC BRITAIN |  | BRITAIN RSMC
 |  |  |  |  |  |  |  | BIG MAC | MAC |  | MAC |  | MAC
 |  |  |  |  |  |  |  | FRENCH FRY | FRY |  | FRY |  | FRY
 |  |  |  |  |  |  |  | CHICKEN NUGGETS | NUGGETS |  | NUGGETS |  | NUGGETS
 |  |  |  |  |  |  |  | HOT COFFEE | COFFEE |  | COFFEE |  | COFFEE
 |  |  |  |  |  |  |  | CHOCOLATE MUFFIN | MUFFIN |  | MUFFIN |  | MUFFIN
 |  |  |  |  |  |  |  | QUARTER POUNDER | POUNDER |  | POUNDER |  | POUNDER
 |  |  |  |  |  |  |  | CANADA (CA) SS00012 | RSMC |  | RSMC CANADA |  | CANADA RSMC
 |  |  |  |  |  |  |  | GARDEN SALAD | SALAD |  | SALAD |  | SALAD
 |  |  |  |  |  |  |  | GARDEN SALAD (AUS) SS89754 | RSMC |  | RSMC GARDEN SALAD |  | GARDEN SALAD RSMC
 |  |  |  |  |  |  |  | LARGE COKE (CH) SS11123 | RSMC |  | RSMC LARGE COKE |  | LARGE COKE RSMC
 |  |  |  |  |  |  |  | LARGE GINGER ALE | ALE |  | ALE |  | ALE
 |  |  |  |  |  |  |  | CHOCOLATE SUNDAE (USA) SS 98743 | RSMC |  | RSMC CHOCOLATE SUNDAE |  | CHOCOLATE SUNDAE RSMC
 |  |  |  |  |  |  |  | *** IF COL J HAS THE TEXT RSMC
Spreadsheet: 51579d1251224026-variable-commission-rates-copy-of-commission-structure
Sheet: Sheet1

Commission Structure - No Salary or Benefits
 | Min | [NAME] | [NAME]
Tier 1 Commissions | 0 | 80000 | 0.15
Tier 2 Commissions | 80001 | 150000 | 0.2
Tier 3 Commissions | 150001 | 400000 | 0.22
Tier 4 Commissions | 400001 | 750000 | 0.25
Tier 5 Commissions | 750001 | 100000000 | 0.3
Sales Person 1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Revenue Generated | 50000 | 62500 | 78125 | 97656.25 | 122070.3125 | 152587.890625 | 190734.86328125 | 238418.5791015625 | 298023.2238769531 | 372529.0298461914 | 465661.2873077393 | 582076.6091346741
Tier 1 Commissions | 7500 | 4500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Tier 2 Commissions | 0 | 6499.8 | 7500
Tier 3 Commissions | 0 | 0 | 8937.28
Tier 4 Commissions | 0 | 0 | 0
Tier 5 Commissions | 0 | 0 | 0
Spreadsheet: 271943d1382114103-array-formula-for-multiple-criteria-work-code-array
Sheet: Sheet1

Division | Rank | Work Code |  |  |  |  |  | DIVISION | RANK
West | Supervisor | Floor |  |  |  |  |  | WEST | SUPERVISOR |  | I would like the forumla to show the work code
West | Employee | Upstairs |  |  |  |  |  |  |  |  | only once and I would like to scroll down and get
South | Supervisor | Floor |  |  |  |  |  | Floor |  |  | all of the work codes.  The criteria are the divison and rank
South | Employee | Upstairs |  |  |  |  |  | Upstairs
West | Supervisor | Outside |  |  |  |  |  | Outside
West | Employee | Upstairs
South | Supervisor | Outside
South | Employee | OUtside
West | Supervisor | Upstairs
West | Employee | Floor
South | Supervisor | Upstairs
South | Employee | Floor
West | Supervisor | Upstairs
West | Employee | Outside
Spreadsheet: 202105d1356329666-solving-formula-based-on-data-on-separate-sheet-test1
Sheet: DATA

SQ.MM | TCL | LO | A | K | METER
10 | 2 | 1 | 30 | 19 | 3X25
20 | 4 | 2
30 | 6 | 3
40 | 8 | 4
.
50 | 10 | 5 | 100 | 65 | 3X40
60 | 20 | 6
70 | 30 | 7
80 | 40 | 8
90 | 50 | 9
Spreadsheet: 874803d1721315331-data-validation-and-output-values-book2
Sheet: Sheet1

Ingredients |  | Dish |  |  |  |  |  |  |  | Select Your Ingrediants |  | Dish Options
Tomatoes |  | Bolonese
Potatoes |  | [NAME] |  |  |  |  |  |  |  | Ingredient 1
Carrot |  | Chili con carne |  |  |  |  |  |  |  | Tomatoes
Pasta |  | Soup
[NAME] |  |  |  |  |  |  |  |  |  | Ingredient 2
Chicken |  |  |  |  |  |  |  |  |  | Beef
Beef
 |  |  |  |  |  |  |  |  |  | Ingredient 3
 |  |  |  |  |  |  |  |  |  | [NAME]
Bolonese | [NAME] | Chili con carne | Soup
Beef | Tomatoes | [NAME] | Tomatoes
Tomatoes | Chicken | Tomatoes | Potatoes
Pasta |  | Beef | Carrot
 |  |  | Chicken
Ing. 1 | Ing. 2 | Ing. 3 | Ing. 4 | Dish | Ing. 1 check | Ing. 2 check | Ing. 3 check | Ing. 4 check | Total check
Beef | Tomatoes | Pasta | N/A | Bolonese
Tomatoes | Chicken | N/A | N/A | [NAME]
[NAME] | Tomatoes | Beef | N/A | Chili con carne
Tomatoes | Potatoes | Carrot | Chicken | Soup
Spreadsheet: 877829d1724768204-add-remove-substring-from-a-string-sample-file_082724
Sheet: Sheet1

Before |  |  |  |  |  |  |  | After
COSTCENTER ID | COSTCENTER DESCRIPTION | PARENT NODE | Column1 | Column2 | READ | WRITE |  | COSTCENTER ID | COSTCENTER DESCRIPTION | PARENT NODE | Column1 | Column2 | READ | WRITE
100100 | Department 1 | ACCTG |  |  | ACTJB14 | ACTJB14 |  | 100100 | Department 1 | ACCTG |  |  | ACTJB14;CHUESMA | ACTJB14;CHUESMA
100105 | Department 2 | ACCTG |  |  | [NAME] | [NAME] |  | 100105 | Department 2 | ACCTG |  |  | [NAME] | [NAME]
100200 | Department 3 | ACTUARY |  |  | [NAME] | [NAME] |  | 100200 | Department 3 | ACTUARY |  |  | [NAME] | [NAME]
100210 | Department 4 | ACTUARY |  |  | [NAME] | [NAME] |  | 100210 | Department 4 | ACTUARY |  |  | [NAME] | [NAME]
100270 | Department 5 | MEDICAL |  |  | RKNEE;ATRXF21 | RKNEE;ATRXF21 |  | 100270 | Department 5 | MEDICAL |  |  | RKNEE;ATRXF21 | RKNEE;ATRXF21
100300 | Department 6 | IT_OTH |  |  | CHUESMA;JFITTZ;KSTARBA | CHUESMA;JFITTZ;KSTARBA |  | 100300 | Department 6 | IT_OTH |  |  | CHUESMA;JFITTZ;KSTARBA | CHUESMA;JFITTZ;KSTARBA
100345 | Department 7 | EIS |  |  | CHUESMA;JFITTZ;KSTARBA | CHUESMA;JFITTZ;KSTARBA |  | 100345 | Department 7 | EIS |  |  | CHUESMA;JFITTZ;KSTARBA | CHUESMA;JFITTZ;KSTARBA
100350 | Department 8 | DIG_TRANSF |  |  | RTULENF | RTULENF |  | 100350 | Department 8 | DIG_TRANSF |  |  | RTULENF | RTULENF
100410 | Department 9 | ESD |  |  | CHUESMA;JFITTZ;KSTARBA | CHUESMA;JFITTZ;KSTARBA |  | 100410 | Department 9 | ESD |  |  | CHUESMA;JFITTZ;KSTARBA | CHUESMA;JFITTZ;KSTARBA
100420 | Department 10 | ESD |  |  | CHUESMA;JFITTZ;KSTARBA | CHUESMA;JFITTZ;KSTARBA |  | 100420 | Department 10 | ESD |  |  | CHUESMA;JFITTZ;KSTARBA | CHUESMA;JFITTZ;KSTARBA
100425 | Department 11 | EB_IM |  |  | CHUESMA;KWIENER;KSTARBA;JFITTZ | CHUESMA;KWIENER;KSTARBA;JFITTZ |  | 100425 | Department 11 | EB_IM |  |  | CHUESMA;KSTARBA;JFITTZ | CHUESMA;KSTARBA;JFITTZ
100500 | Department 12 | DA_COE |  |  | RELOMAA;FMEMMO | RELOMAA;FMEMMO |  | 100500 | Department 12 | DA_COE |  |  | RELOMAA | RELOMAA
Changes
COSTCENTER ID | READ | WRITE
100100 | CHUESMA | ADD
100425 | KWIENER | REMOVE
100500 | FMEMMO | REMOVE
Based on the action in column C, add or remove the string from the "After" table
Spreadsheet: 215604d1361425437-move-group-of-rows-from-a-specific-column-based-on-matching-criteria-to-a-new-sheet-workbook2
Sheet: Info

Header | Header | Header | Header | Header | Header |  | Header | Header | Header | Header | Header | Header | Header | Header | Header
Mark | One | [NAME] | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | Two | [NAME] | 2 | 2 | 2 |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
[NAME] | Three | [NAME] | 3 | 3 | 3 |  | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
Nick | Four | [NAME] | 4 | 4 | 4 |  | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
[NAME] | Five | [NAME] | 5 | 5 | 5 |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
Fred | One | [NAME] | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | Two | [NAME] | 2 | 2 | 2 |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
[NAME] | Three | [NAME] | 3 | 3 | 3 |  | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
[NAME] | Four | [NAME] | 4 | 4 | 4 |  | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
[NAME] | Five | [NAME] | 5 | 5 | 5 |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
Spreadsheet: 75902d1276518567-consolidate-multiple-sheets-testing2
Sheet: Europe

 | Country | State | Company | SP | Pilot | Probability | Value | Month | J | K | L | M | N | O | P | Q | Comments
 | Hungary |  |  |  |  | 0.9 | 10
 | Sweden
 | France
 | Germany
 | England
 |  |  |  |  | Total |  | 10
Spreadsheet: 735791d1623176459-sumif-function-skipping-1-column-book1
Sheet: Detailed

 |  | IN | OUT
Date | Name | Product 1 |  | Product 2 |  | Product 3 |  | Product 4 |  | Product 5
2021-01-01 00:00:00 | [NAME] | 10 | 4 | 3 |  |  | 7 | 9 | 8 | 6 | 5
 | [NAME] | 3 | 2 |  | 100 | 6 | 5 |  |  | 4 | 3
 | Lewis | 10 |  |  |  |  |  |  | 4 | 10
 | [NAME] |  | 10 | 50 | 49 | 20 |  | 3 |  |  | 10