tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 857195d1706223678-transfer-or-copy-data-to-next-sheet-excel-problem-transfer-data-to-sheet_rev3
Sheet: Level 2

[NAME] TOOL P/N | PROJECT | [NAME] TOOL TYPE | LOWER DIE-1 | LOWER DIE-2 | PM DATE | MONTH | WORKWEEK | STATUS | REPLACED PARTS | REMARKS
KIA - JA GROMMET RR [NAME] | KIA - JA | GROMMET [NAME] | 217768 | 119925 | 2024-01-04 00:00:00 |  |  | Done | Spring
[NAME] | [NAME] | GROMMET [NAME] | 22520 | 4153 | 2024-01-04 00:00:00 |  |  | Done
25.0770-3140.2 | MMC SUV/MPV | CONNECTOR MOLD | [NAME] | [NAME] | 2024-01-04 00:00:00 |  |  | Done | Core-1
10.0774-7421.1/7410.1 Coreline 3 | MANDO/RENAULT | CORE SENSOR | [NAME] | [NAME] | 2024-01-04 00:00:00 |  |  | Done
10.0774-7421.1/7410.1 Coreline 1 | MANDO/RENAULT | CORE SENSOR | [NAME] | [NAME] | 2024-01-04 00:00:00 |  |  | Done | [NAME]
10.0774-7421.1/7410.1 Coreline 2 | MANDO/RENAULT | CORE SENSOR | [NAME] | [NAME] | 2024-01-04 00:00:00 |  |  | Done
10.0774-4803.2 (INT 21-007) | RENAULT 52 | CONNECTOR MOLD | 279347 | [NAME] | 2024-01-04 00:00:00 |  |  | Done
10.0774-2332.1(8016) | RENAULT 52 | GROMMET [NAME] | [NAME] | [NAME] | 2024-01-04 00:00:00 |  |  | Done
10.0711-6512.4 | RENAULT 52 (RA GEN3) | SENSOR HEAD MOLD | [NAME] | 193641 | 2024-01-04 00:00:00 |  |  | Done | [NAME]
06.4130-1003.2 L15 | MANDO NX4_NT1_US4 | CONNECTOR MOLD | [NAME] | [NAME] | 2024-01-05 00:00:00 |  |  | Done
06.4130-1003.2 L14 | MANDO NX4 | CONNECTOR MOLD | 2502278 | 2502278 | 2024-01-05 00:00:00 |  |  | Done
06.4108-3045.2 | HONDA 3RB | SENSOR HEAD MOLD | 18475 | 18042 | 2024-01-05 00:00:00 |  |  | Done
06.4108-3016.2 | NISSAN B13B | SENSOR HEAD MOLD | 22945 | [NAME] | 2024-01-05 00:00:00 |  |  | Done
06.4108-3014.2 L15 (TH20-002A) | MANDO NX4_US4 | ADAPTOR MOLD | [NAME] | [NAME] | 2024-01-05 00:00:00 |  |  | Done
06.4108-3014.2 L14 | MANDO NX4 | ADAPTOR MOLD | 445229 | 502508 | 2024-01-05 00:00:00 |  |  | Done
Spreadsheet: 217743d1362166453-need-help-on-index-match-function-attendance
Sheet: Att

2013-02-04 00:00:00
 | Code | Name | DOJ
 | 1 | A | 2013-02-01 00:00:00
 |  | B
 |  | C
 |  | D
 |  | E
 |  | F
 |  | G
 |  | H
 |  | I
 |  | J
 |  | K
 |  | L
 |  | M
 |  | N
 |  | O
 |  | P
 |  | Q
 |  | R
 |  | S
 |  | T
 |  | U
 |  | V
 |  | W
 |  | Q
 |  | Y
 |  | Z
Spreadsheet: 837885d1690479345-sum-up-number-of-hours-in-the-format-hh-mm-ss-format-sum_up_hours
Sheet: Sheet3

Total No Of Hours
[NAME] |  | 23:24:34
47:12:38 |  | 1 day, 23:12:38
23:57:40 |  | 23:57:40
14:34:55 |  | 14:34:55
10:56:55 |  | 10:56:55
12:06:38 |  | 12:06:38
22:39:16 |  | 22:39:16
13:12:57 |  | 13:12:57
16:38:32 |  | 16:38:32
14:22:59 |  | 14:22:59
18:55:56 |  | 18:55:56
27:34:01 |  | 1 day, 3:34:01
[NAME] |  | 18:04:43
Spreadsheet: 827813d1683039703-expenses-and-taxes-spreadsheet-double-check-formulas-test_expense-and-taxes
Sheet: Sheet1

2023 - Q1 | PAYMENT & EXPENSES |  | BUSINESS NAME
 | (SEE SALES REPORTS 2023) |  |  |  |  |  |  |  |  |  | (IF APPLICABLE)
DATE | PAYMENTS RECEIVED |  |  |  | PAYMENT DESCRIPTION |  | DATE | EXPENSES |  | EXPENSE DESCRIPTION | CASH RECEIPT NUMBER
 | 1000 |  |  |  | INCOME SOURCE 1 |  | 2023-04-03 00:00:00 | 1000 |  | [NAME] | SEE RECEIPT
 | 1000 |  |  |  | INCOME SOURCE 2 |  | 2023-04-03 00:00:00 | 0 |  | [NAME] | SEE RECEIPT
 | 1000 |  |  |  | INCOME SOURCE 3 |  | 2023-04-05 00:00:00 | 0 |  | [NAME] | SEE RECEIPT
 | TOTAL |  |  |  |  |  |  | TOTAL EXPENSES
 |  |  | TOTAL PROFIT AFTER EXPENSES |  | ESTIMATED TAXES OWED (30%)
 |  |  | TOTAL PROFIT AFTER TAXES
Spreadsheet: 859072d1707513831-pull-data-from-otherworksheet-by-searching-text-in-the-column-which-is-changed-daily-book1
Sheet: Company2

 | Company 1 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | Total
 | Income
 | Rental Income | 30000 | 30000 |  |  |  |  |  |  |  |  |  |  | 60000
 | Total Income | 30000 | 30000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 60000
 | Gross Profit | 30000 | 30000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 60000
 | Expenses
 | Bank Charges & Fees | 20 | 20 |  |  |  |  |  |  |  |  |  |  | 40
 | Interest Expense | 8816.22 | 8616.26 |  |  |  |  |  |  |  |  |  |  | 17432.48
 | Management Fee | 3500.99 | 3500.99 |  |  |  |  |  |  |  |  |  |  | 7001.98
 | Engineering | 177.2 |  |  |  |  |  |  |  |  |  |  |  | 177.2
 | Total Expenses | 12514.41 | 12137.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 24651.66
 | Net Operating Income | 17485.59 | 17862.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 35348.34
 | Net Income | 17485.59 | 17862.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 35348.34
Spreadsheet: 785026d1656084557-overlap-of-date-and-time-test2
Sheet: Details

Day | [NAME] | Start Time | Leave Time |  |  |  | [NAME] | Total Time
Day 1 | Snowwhite111 | 2022-06-08 08:57:50 | 2022-06-08 10:39:10 |  |  |  | Snowwhite111
Day 1 | Snowwhite111 | 2022-06-08 08:02:13 | 2022-06-08 08:51:09 |  |  |  | Sleepyabc
Day 1 | Snowwhite111 | 2022-06-08 08:52:00 | 2022-06-08 08:57:56 |  |  |  | Docnyc
Day 2 | Snowwhite111 | 2022-06-09 08:57:50 | 2022-06-09 10:39:10 |  |  |  | Grumpy367
Day 1 | Grumpy367 | 2022-06-08 08:51:06 | 2022-06-08 10:39:41
Day 1 | Grumpy367 | 2022-06-08 08:02:45 | 2022-06-08 08:51:11
Day 2 | Grumpy367 | 2022-06-09 08:02:45 | 2022-06-09 09:51:11
Day 1 | Docnyc | 2022-06-08 08:02:04 | 2022-06-08 10:39:56
Day 1 | Docnyc | 2022-06-08 08:05:10 | 2022-06-08 10:04:56
Day 1 | Docnyc | 2022-06-08 10:04:41 | 2022-06-08 10:39:18
Day 2 | Docnyc | 2022-06-09 08:04:41 | 2022-06-09 10:39:18
Day 1 | Sleepyabc
Day 2 | Sleepyabc
Spreadsheet: 47914d1247085729-summing-text-test-timesheet-v2
Sheet: Week 1

 |  |  |  |  | Employee:
 |  | TIME SHEET |  |  | Week Of:
 | DATE | [NAME] | ONSITE HOURS |  | ALL HOURS |  |  |  | TOTAL
 |  | (Show/City) | IN | OUT | IN | OUT | PTO
MON. |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 0
TUES. |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 0
WED. |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 0
THURS. |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 0
FRI. |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 0
SAT. |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 0
SUN. |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 0
 |  |  |  |  |  | PTO |  | Total Hours | 0
 |  | Reviewed By Supervisor
 |  |  |  |  |  |  |  |  | OT
 |  | Submitted For Payroll Processing |  |  |  |  |  |  | 0
Spreadsheet: 100022d1298508765-count-occurences-of-y-and-put-value-into-table2-flash-sample
Sheet: Sheet1

Analyst: | Client Name | Amount: | Compl'd (Y or N)
Seamus | [NAME] | 37815 | Y
[NAME] | [NAME] | 30358 | Y
[NAME] | [NAME] | 11503.72 | Y
Seamus | [NAME] | 12085.39 | Y
[NAME] | [NAME] | 24220.72 | N
Nathan | [NAME] | 25727.48 | Y
Seamus | [NAME] | 13890.32 | Y
[NAME] | August Alden | 22323.43 | Y
[NAME] | [NAME] | 5234.32 | Y
[NAME] | [NAME] | 10398.99 | Y
[NAME] | [NAME] | 32509.02 | N
 | TOTAL
 | Individual Totals | Number of deals | Total Debt
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Nathan
 | Seamus
 | Totals
 | COMPLIED | Number of complied deals | Total compl'd debt
 | [NAME]
 | [NAME]
 | Dennis
 | [NAME]
 | [NAME]
 | Nathan
 | Seamus
Spreadsheet: 757671d1638388404-insert-a-blank-line-in-a-column-of-numbers-transaction-formatting
Sheet: Sheet1

Before |  | After
TXN00001174 |  | TXN00001174
TXN00001174 |  | TXN00001174
TXN00001184
TXN00001184 |  | TXN00001184
TXN00001184 |  | TXN00001184
TXN00001184 |  | TXN00001184
TXN00001338 |  | TXN00001184
TXN00001338
TXN00001338 |  | TXN00001338
TXN00001367 |  | TXN00001338
TXN00001367 |  | TXN00001338
TXN00001367
TXN00001367 |  | TXN00001367
TXN00001367 |  | TXN00001367
TXN00001367 |  | TXN00001367
TXN00001423 |  | TXN00001367
TXN00001423 |  | TXN00001367
 |  | TXN00001367
 |  | TXN00001423
 |  | TXN00001423
Spreadsheet: 586327d1534322735-report-and-email-automation-button-report-aging-aug-2018
Sheet: Report

POSM Monitoring Data
Today
Item Code | Description | Dept | PIC | UoM | Received Date | Recent Transactions Date | Balance (Qty) | Indicator | STATUS
 |  |  |  |  |  |  |  |  | GOOD | BAD | QUARANTINE
 |  |  |  | Indicator = current date - received date (days)
 |  |  |  | 1 | < 90 days
 |  |  |  | 92 | >= 90 days dan < 180 days
 |  |  |  | 185 | >= 180 days dan < 365 days
 |  |  |  | 400 | >= 365 days
Spreadsheet: 820821d1678297813-extract-numbers-between-symbols-calculate-and-join-numbers-extract-numbers-between-symbols-1-
Sheet: Sheet1

 |  | Actual Output till date
 |  | Plant1 | 100
 |  | Plant2 | 300
 |  | Plant3
 |  | Plant4 | 200
 |  | Total:
 | (Total)Plant1+Plant2/Plant3/Plant4
Target | (2600)1000+500/700/400
Balance to against target (B9-Col.D data of each plant)
No. of balance working days | 249
Average required per month | (200.8)90.4+20.1/70.3/20.1
We have 4 plants at various locations.  Preparing a report of Target Vs. Actual , balance and average required per month
Need a formula for the yellow highlighted cells.  The challenge is to extract the numbers between the symbols and multiply with No. of months balance, etc.
Spreadsheet: 858680d1707286126-how-to-do-partial-match-between-two-columns-that-contains-names-to-check-in-excel-forum
Sheet: Sheet1

 |  |  | Eligible Plans
From SAP | From HR | Company | Hours | I have to match column A to Coumn B and pull the partial matching name
Lim, [NAME] | Backwood Jap | Sop | 3 | For eg; how to show [NAME], [NAME] (Jap) here
Ram, Yukku | [NAME] | Sop | 4
Pin, [NAME] | [NAME] | Sop | 6
[NAME], [NAME] (Jap) | [NAME] lim tan | Sop | 6
Spreadsheet: 99563d1298175508-count-by-month-count_by_month-1-
Sheet: Sheet1

Activity1
Planned | Actual
2010-12-05 00:00:00
2010-12-06 00:00:00
2010-12-14 00:00:00
2011-01-01 00:00:00
2011-01-05 00:00:00
2011-01-06 00:00:00
2011-01-10 00:00:00
2011-02-01 00:00:00
2011-02-03 00:00:00
2011-02-04 00:00:00
2011-02-10 00:00:00
2011-02-15 00:00:00
Spreadsheet: 1acbc5b5-eba7-43ce-aba6-394b78c6d600
Sheet: BUSAD

 | PROGRAM LEVEL | # | SLOs | # | ASSESSMENT METHOD DEFINED | # | ASSESSED COURSE | # | DISCUSSION/ IMPROVEMENT | #
 | A.A. Degree Business Administration | 1 | X | 1
 | A.S. Degree Business Administration | 1 | X | 1
 | Business Management Certificate | 1 | X | 1
 | Retail Management Certificate | 1
 | TOTAL
 | PERCENTAGE
 | COURSE
4 | BUSAD 039 | 1 | X | 1
4 | BUSAD 053 | 1
2 | BUSAD 100 | 1 | X | 1 | X | 1 | 1 | 1
4 | BUSAD 103 | 1 | X | 1
4 | BUSAD 105 | 1 | X | 1
4 | BUSAD 145 | 1 | X | 1
4 | BUSAD 155 | 1 | X | 1
4 | BUSAD 198 | 1 | X | 1
4 | BUSAD 200 | 1
5 | BUSAD 210 | 1
4 | BUSAD 230 | 1 | X | 1 | X | 1 | X | 1 | X | 1
 | TOTAL
 | PERCENTAGE
Spreadsheet: 141308d1329213288-search-common-values-with-different-physical-locations-example2
Sheet: Sheet2

 |  |  | Date | [NAME] | PO Number | Description | OGS Job Number | Qty | AN Number | Eng | Comments | Location | OGS Part Number | GRN Number
 |  |  | 2011-10-12 00:00:00 | routeco | 114081 | picoview | s14965 | 1 | 1143366 | amcg | no blue | A1 |  | 30957
 |  |  | 2011-10-12 00:00:00 | gas arc | 114119 | changeover | p16347 | 1 | 72397 | ms | no blue | floor |  | 30956
 |  |  | 2011-10-12 00:00:00 | edmundsons | 114256 | enclosures | n15023 | 5 | 150088374 | dw |  | C2 |  | 30955
 |  |  | 2011-10-12 00:00:00 | edmundsons | 114256 | mcb | n15023 | 5 | 150088311 | rg |  | C4 |  | 30954
 |  |  | 2011-10-12 00:00:00 | edmundsons | 14217 | din rail | n14700 | 5 | 150088266 | cm |  | floor |  | 30953
 |  |  | 2011-10-12 00:00:00 | vulcan | 114258 | various nuts | cons | 1300 | 174512 | ad | p/ship | issued |  | 30952
 |  |  | 2011-10-12 00:00:00 | routeco | 114081 | vents | s14965 | 8 | 1871 | amcg |  | D4 |  | 30951
 |  |  | 2011-10-12 00:00:00 | [NAME] | 114227 | labels | a16324 | 1 | 39442 | jd |  | issued  [NAME] |  | 30950
 |  |  | 2011-10-12 00:00:00 | powersolve | 114181 | power supplys and modules | n14700 | 18 | 14498 | cm |  | b2 |  | 30949
 |  |  | 2011-10-12 00:00:00 | vulcan | 114210 | cutting wheel | cons | 2 | 174244 | ad |  | issued |  | 30948
 |  |  | 2011-10-11 00:00:00 | CABLE SYSTEMS | 114174 | HAWKE GLAND KIT | N16229 | 4 | 104550/01 | [NAME] | BACK-ORDER | C2 |  | 30947
Spreadsheet: 120676d1315446251-excel-2007-sumifs-with-vlookup-criteria-example1
Sheet: Sheet1

Test1 | <- Enter PGM ID
Table 1 |  |  |  |  |  |  | Table 2
PGM | ACCT | ENTRY |  |  |  |  | ACCTLOOKUP | OK
Test1 | A | 10 |  |  |  |  | A | 0
Test1 | B | 20 |  |  |  |  | B | 1
Test1 | A | 30 |  |  |  |  | C | 1
Test 2 | C | 40 |  |  |  |  | D | 1
Test 2 | B | 50 |  |  |  |  | E | 0
Test 2 | E | 60
 |  | I would like my formula to return the sum of all ENTRYs where PGM=PGMID and ACCT corresponds to a value of 1 in table 2
 |  | In this example, the result should be 20
 |  | Basic idea of what I am trying to do:   =SUMIFS(C6:C11,A6:A11,A1,B6:B11,VLOOKUP(B6:B11,H6:I10,2)=1)
Spreadsheet: 2c647c94-69a9-4303-8681-0e6b7e24e53b
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
SFLB | Test | SFLB | Influenza Virus B Antibodies, IgG and IgM (Separate Determinations), Serum | Influenza Virus B Ab, IgG, IgM, S | Immunofluorescence | Serum Gel Tube: SGT |  |  | 0.25 | mL | Preferred: Red top Acceptable: Serum gel [NAME]: 0.25 mL Additional Information:  1. Incidence of influenza virus infections is seasonal in the United States and usually occurs only from November to March. 2. Indicate influenza virus B. | 0.15 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | IgG: <1:10 IgM: <1:10 | Monday through Friday; 9 a.m. | 1 day | 3 days | 2 | 86710 |  |  |  |  | Rochester
SFLB | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
SFLB | Result | 5733 | Influenza Virus B Ab, IgG | Influenza Virus B Ab, IgG | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9535-6 | Influenza virus B Ab.[NAME]:Titr:Pt:Ser:Qn:
SFLB | Result | 5734 | Influenza Virus B Ab, IgM | Influenza Virus B Ab, IgM | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9536-4 | Influenza virus B Ab.IgM:Titr:Pt:Ser:Qn:
Spreadsheet: 376924d1423749800-find-value-that-doesnt-match-and-bring-back-column-heading-find-value-that-doesnt-match-and-index-column-heading-150212-ndm-vxx
Sheet: Year 2

PersID | PosCode | Org1 | Org2 | Org3 | Non-Matching Value from Year 1 | Location of non-matching value from Year 1 | Header
1001 | 21 | 8 | A1 | SS1
1002 | 21 | 9 | A2 | AQ1
1003 | 22 | 11 | B3 | D34
1004 | 23 | 12 | B2 | DW4
1005 | 23 | 22 | C1 | SS2
Spreadsheet: 674107d1587662723-help-with-formula-can-i-combine-sums-and-count-formulas-book2-example
Sheet: Company Scorecard

 |  |  |  |  | Week | Month | Quarter | Year
 | Week Starting: | 2020-04-22 00:00:00 |  |  |  |  |  |  |  |  | MRR
 |  |  |  |  |  |  |  |  |  |  | Count |  |  |  |  |  |  |  | 2020-01-01 00:00:00
 | [NAME] | MRR
 | Lost MRR
 | No Current Project
 | Lost Funding
 | Competition Won
 | Competitive Loss
 | Pricing
 | Product Feature/Fit
 | Duplicate
 | Missing Integrations
 | Not a Fit
 | Timing
 | Not Qualified
 | Stalled
 | [NAME]
Spreadsheet: 230073d1366677157-conditionally-format-from-the-highest-to-lowest-with-tie-break-highest_percentage
Sheet: Plan1

 |  |  | Incorrect |  |  |  |  |  | Correct exemple
Código de barras | IND | Descrição | Fornecedor A | Fornecedor B | Fornecedor C | Fornecedor D | Fornecedor E |  | Fornecedor A | Fornecedor B | Fornecedor C | Fornecedor D | Fornecedor E
7896253902580 | Abbott | Betaserc 24 mg, 60 Comprimidos, ABBOTT_x0000_ | 0.08 | 0.08 | NT | NT | NT |  | 0.08 | 0.08 | NT | NT | NT
7896255762540 | Abbott | Bufedil 150 mg, 40 comprimidos, Abbott_x0000_ | 0.105 | NT | 0.07 | 0.07 | 0.05 |  | 0.105 | NT | 0.07 | 0.07 | 0.05
7896255762731 | Abbott | Bufedil 300 mg, 20 comprimidos, Abbott_x0000_ | 0.105 | NT | 0.07 | NT | NT |  | 0.105 | NT | 0.07 | NT | NT
7896255713160 | Abbott | Dilacoron 80 mg, 30 Comprimidos Revestidos, ABBOTT_x0000_ | 0 | 0.08 | 0.07 | 0.07 | 0.02 |  | 0 | 0.08 | 0.07 | 0.07 | 0.02
7896253902092 | Abbott | Duspatalin 200 mg, 30 Cápsulas, ABBOTT_x0000_ | 0.08 | 0.08 | 0.07 | 0.07 | 0.02 |  | 0.08 | 0.08 | 0.07 | 0.07 | 0.02
7891158024979 | Abbott | Hytrin 5 mg, 30 comprimidos, Abbott_x0000_ | 0.09 | NT | NT | 0.07 | 0.09 |  | 0.09 | NT | NT | 0.07 | 0.09
Spreadsheet: 828881d1683780953-filter-formula-but-only-return-certain-columns-sample24-etaf
Sheet: Sheet1

 | LOAD # | SHIPPER | DRIVER | [NAME] | PAY | SHIFT
 | 1 | [NAME] | [NAME] | 400 | 1500 | SHIFT 1
 | 2 | X91 | PHIL | 500 | 1900 | SHIFT 2
 | 3 | X002 | TOM | 490 | 2200 | SHIFT 5
 | 4 | 3XL | [NAME] | 412 | 1500 | SHIFT 4
 | 5 | 3XL | [NAME] | 902 | 3400 | SHIFT 1
 | 6 | X91 | CHUCK | 910 | 3250 | SHIFT 3
 | SEARCH | 4
 | LOAD # | SHIPPER | [NAME] | PAY
 |  | 3XL | 412 | 1500
Spreadsheet: 736103d1623350654-sumif-with-multiple-conditions-wildcard-in-name-excel-help-4
Sheet: Sheet1

[NAME] | Money | Stage | Name | Product | Yes or No |  | Name
US Fruit_United States | 20 | 0. Stage Opp Zero | US United States | PS5 | Yes |  | United States Country Total
US Game_New York City NY | 30 | 2. Stage Prepare | New York NY City | PS5 | Yes |  | New York Country Total
MY_Malaysia-MY_country | 40 | 3. Stage Game | Malaysia Mlysia | MP5 | Yes |  | Malaysia Country Total
Thailand_BKOK_BK | 50 | 4. Stage Post | Bangkok Thailand | Apple | Yes |  | Thailand Country Total
US Fruit_United States | 60 | 5. Stage Pre | US United States | Samsung | Yes
US Game_New York City NY | 70 | 0. Stage Opp Zero | New York NY City | MP5 | Yes
MY_Malaysia-MY_country | 80 | 7. Stage Done | Malaysia Mlysia | Apple | No |  | Total the Money (Column B) if:
Thailand_BKOK_BK | 90 | 8. Stage Close | Bangkok Thailand | Samsung | Yes |  | 1. Stage (Column C) is between 1-7 only, [NAME] and 8
US Fruit_United States | 100 | 3. Stage Game | US United States | MP5 | Yes
US Game_New York City NY | 110 | 4. Stage Post | New York NY City | Apple | No
MY_Malaysia-MY_country | 120 | 5. Stage Pre | Malaysia Mlysia | Samsung | Yes
Thailand_BKOK_BK | 130 | 8. Stage Close | Bangkok Thailand | MP5 | Yes
US Fruit_United States | 140 | 8. Stage Close | US United States | Apple | No
US Game_New York City NY | 150 | 8. Stage Close | New York NY City | Samsung | Yes
Spreadsheet: 794904d1662393241-paye-tax-tax-calculations-tms
Sheet: Sheet1

12630 |  |  |  |  |  |  |  |  |  |  |  | $A$1
Name | Amount | [NAME] | Notes
Income | 1828.1 |  |  |  |  |  |  |  |  |  |  | =$B$3
Pension | 91.41 |  | Pension is 5% of Income |  |  |  |  |  |  |  |  | =$B$3*5%
Taxable | 765.16 |  |  |  |  |  |  |  |  |  |  | =$B$3-$B$3*5%-$A$1/13
Tax | 153.03 |  | Tax is 20% of the taxable pay |  |  |  |  |  |  |  |  | =($B$3-$B$3*5%-$A$1/13)*20%
N.I | 114.11 |  | N.I is 0% of Income up to £968, and then 13.25% from £968 £1,828.10 (Income) - £968 (0%) = £860.10.  13.25% of £860.10 = £113.96. |  |  |  |  |  |  |  |  | =($B$3-967)*13.25%
Pay | 1469.55
 |  |  |  |  |  |  |  |  |  |  |  | National Insurance contributions
[NAME]
 |  |  |  |  |  |  |  |  |  |  |  | The rates of National Insurance contributions (NICs) for both employees and employers are increased by 1.25 percentage points for 2022/23.  For employees, the rate of NICs is set at 13.25% on all earnings between the primary threshold and the upper earnings limit, and at 3.25% on earnings above the upper earnings limit.  For employers, the rate of NICs is set at 15.05% on earnings above the secondary threshold.
 |  |  |  |  |  |  |  |  |  |  |  | The primary threshold is set initially at £190 per week, rising to £242 per week from 6 July 2022. The secondary threshold is set at £175 per week for the whole of the 2022/23 tax year.  The upper earnings limit is set at £967 per week for 2022/23, so that it remains aligned with the income tax higher rate threshold.
Spreadsheet: 58081d1258394462-delete-row-if-specific-cell-contains-no-data-example1
Sheet: Sheet1

Unit Roster Report
Owner Name | Account # | Unit Address
2009 Texas | 1 | 7777 [NAME]
2009 Texas | 2 | Sesame Street
[NAME], [NAME] | 3 | 1802 Park Place
Jon, Brice
[NAME], [NAME] | 4 | 1839 Montgomery Road
[NAME], [NAME]
[NAME], [NAME] | 5 | 1708 Fluvial Drive
[NAME], [NAME]
Spreadsheet: 686390d1594574759-vlookup-with-3-number-type-based-on-criteria-test_adjustment
Sheet: Sheet1

ANALYSIS OF CALCULATION |  |  |  |  |  |  |  |  |  | uraian | description | grade
Data Transaksi Penjualan | Objek Penilaian | P-1 |  | P-2
[NAME] data/informasi
[NAME] (Rp) |  | 0 |  | 0
Analisis Perbandingan dan Penyesuaian |  |  |  |  |  |  |  |  |  | description |  | Rating/Grade |  | TABLE OF INDEX
Item | Objek | P-1 | Adj. | P-2 | Adj. |  | IMPORTANT. DON'T REMOVE |  |  | Vehicle Condition | Very good | 1 |  | indeks
 |  |  |  |  |  |  | P-1 | P-2 |  |  | Good | 2 |  | [NAME] |  | 0.01
XX | XX |  | 0 |  | 0 |  |  |  |  |  | Enough | 3 |  | [NAME] |  | 0
XX | XX | XX | 0 | XX | 0 |  |  |  |  |  | Bad | 4 |  | [NAME] |  | NEGATIVE NUMBER | POSITIVE NUMBER
Vehicle Condition | Very good | Good | 0.17 | Very good | -0.17 |  |  |  |  | Body Condition | Very good | 1 |  | Vehicle Condition | Very good | -0.17 | 0.17
 |  |  |  |  |  |  |  |  |  |  | Good | 2 |  | Vehicle Condition | Good | -0.15 | 0.15
 |  |  |  |  |  |  |  |  |  |  | Enough | 3 |  | Vehicle Condition | Enough | -0.11 | 0.11
 | note : |  |  |  |  |  |  |  |  |  | Bad | 4 |  | Vehicle Condition | Bad | -0.05 | 0.05
 | comparing objek "Very Good vs P-1 "Good" the answer is correct (postive number) cause Very good is rating in 1 and Good in rating number 2 |  |  |  | comparing Very good vs Very good, should be answer is 0 (zero) cause they in the same rating/grade
 |  |  |  |  |  |  | as controller , if contains data input error |  |  |  |  |  |  |  |  | number of index, is random but always couple "positive & negative number"
Spreadsheet: 123425d1317656682-enter-value-in-cell-return-multiple-rows-of-data-focusgroup
Sheet: Sheet1

Focus Group | Group Score
A | 3.22 |  |  | Type Focus Group Letter here
P | 8.11
K | 4.59 |  |  | returns a list of scores one in each row
V | 10
B | 0.78
C | 9.33
D | 4.55
E | 2.77
A | 4.82
B | 1.11
F | 6.67
G | 9
F | 8
F | 6.41
G | 8.55
D | 9.34
E | 7.63
I | 0.91
H | 2.22
J | 5.81
J | 5.22
J | 3.74
O | 4
M | 6.99
N | 4.28
L | 7.77
A | 8
C | 4.1
C | 5.1
C | 3.91
R | 4.85
N | 6.55
O | 9.95
P | 3.45
P | 7.75
Q | 3.86
Q | 7.75
M | 4.45
N | 3.65
J | 9.13
K | 7.85
H | 2.25
J | 5.55
Y | 0.77
F | 10
G | 9.5
B | 1.22
N | 6.5
E | 7.3
T | 4.8
Q | 1.81
A | 6.94
S | 7.33
D | 2.67
T | 5.99
B | 1.05
U | 7.69
J | 9.67
L | 8.5
G | 6.1
H | 9.4
K | 0.5
Y | 7.33
Z | 2.3
D | 8.64
R | 8.2
T | 10
N | 9.64
I | 4.88
L | 3.75
S | 2.05
A | 6.44
G | 7.39
V | 6.8
B | 0.4
H | 5.81
Y | 6.44
J | 2.94
M | 7.33
S | 1.1
W | 0.5
R | 9.5
F | 7.66
G | 7.3
H | 8.5
B | 8.6
R | 2.4
W | 6.1
S | 0.9
F | 7.1
H | 5.66
X | 6.3
W | 4.8
G | 9.1
S | 6.2
Q | 7.3
L | 0.7
Z | 6.44
K | 0.8