tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 870379d1716907124-modifying-table-to-be-more-dynamic-book2-2-
Sheet: lepingud

Number | Name | [NAME] | Üürilepingu kood | Code | Kinnistu aadress | Kinnistu piirkond | Client | Kap.komp | 2024 | 2025 | 2026 | 2027 | 2028 | Rem.komp | 2024 | 2025 | 2026 | 2027 | 2028
5 | Name5 |  |  | SEEMNE200 |  |  | Client1 |  |  | 9000 | 9000 | 9000 | 9000 |  | 5000 | 5000 | 5000 | 5000 | 5000
6 | Name6 |  |  | PURAVIKU4 |  |  | Client2 |  | 9000 | 9000 | 9000 | 9000 | 9000 |  | 5000 | 5000 | 5000 | 5000 | 5000
Spreadsheet: 72747d1273487381-errorif-vlookup-and-sum-function-sample-result
Sheet: July

 | 63 | 67 | 71 | 84 | 93 | 97 | 105 | 111 | 115 | 121 | 126
2010-07-01 00:00:00
 | t |  | t |  |  | t |  |  |  | t
 |  |  |  |  |  |  | x
 | t |  | x
 | x
 | t |  |  |  | t |  |  |  | t
 | t |  |  |  | x |  |  | x
 |  |  |  |  | t
 |  |  |  |  | t
 |  |  |  | x |  |  |  | x
 |  |  |  | t
 |  |  | t
 |  |  |  |  |  | x
# of T's
# of X's
Monthly Total
6 Month Total
12 Month Total
Spreadsheet: 93900d1293661016-excel-2007-clearing-a-row-after-a-particular-word-selected-cat-working-file
Sheet: 250LS

250LS
LAST QUARTERLY | QUARTERLY DUE NLT | NEXT QUARTERLY START | UPDATED BY: | LAST MASO | MASO DUE NLT | NEXT MASO START | UPDATED BY: | JACKET REVIEW | IMT 68     DATE | IMT 68 REVIEW
2010-12-07 00:00:00 |  |  | JAD | 2010-12-07 00:00:00 |  |  | JAD |  | 2010-08-05 00:00:00
JACKET REVIEW
NAME |  | DATE ACCOMPLISHED |  | COMMENTS / FINDINGS
DEEMER |  | 2010-09-08 00:00:00
GENERAL ACCOUNT INFORMATION / NOTES
RETURN TO STATUS PAGE |  |  | INVENTORY STATUS PAGE
Spreadsheet: 811913d1672858562-cannot-find-max-min-average-based-on-multiple-criteria-forum-workbook
Sheet: Sheet1

 | 2 Queries |  |  | 1 Query
 | MIN |  |  | MIN
 | MAX |  |  | MAX
 | AVERAGE |  |  | AVERAGE
Sample ID | Pond | Pond | Pond | Duplicate
Sample ID2 | Pond | Pond | Pond | Duplicate
 | 1 | 1 | 1 | 1
Alkalinity (CaCO3) | 92 | 100 | 181 | 98
Aluminum | 0.3 | 0.142 | 1 | 0.171
NH4 | 0.18 | 0.24 | 0.99 | 0.25
Spreadsheet: 742074d1627503241-formulas-not-remaining-with-correct-rows-after-sort-sample
Sheet: Roll Up - YTD Avgs

Location | Total # of deployments | Total # of days able to inspect | Number of reinspects Assigned | % of Reinspects Assigned | Number of Claims Turned Back in by Associates | % of Claims Turned Back in by Associates | Remaining Capacity at Target | Total Assigned | Avg Claims Per Day |  | Avg Days to Contact | Avg Days to Inspect | Avg Days to Return
 |  |  |  |  |  |  |  |  |  |  | Percentage Contacted | Percentage Inspected | Percentage Returned
Totals
Mix
Hail
Wind
Tornado
Hurricane
Freezing
Flood
Backup
Wildfire
Earthquake
LL-Tornado
LL-EQ
LL-Wildfire
LL-Hurr
Backfill
Supps
Trainer
Trainee
Extern
Spreadsheet: 160722d1339173761-assign-ranking-to-data-based-on-position-within-range-2nd-copy-of-sample-krismi
Sheet: Sheet2

CCT | Points |  | Score? | score + 1 |  | RANK | Total | tranche by rank
0.67
0.532
0.885 |  |  |  |  |  |  |  |  |  |  |  | score + 1 |  |  | tranche by rank
0.734 |  |  |  |  |  |  |  |  |  |  |  | value | count |  | value | count
0.776 |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 1
0.603 |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  | 2
0.512 |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  | 3
0.727 |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  | 4
0.743 |  |  |  |  |  |  |  |  |  |  |  | 5 |  |  | 5
0.909 |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | 6
0.558 |  |  |  |  |  |  |  |  |  |  |  | 7 |  |  | 7
0.815 |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  | 8
0.861 |  |  |  |  |  |  |  |  |  |  |  | 9 |  |  | 9
0.706 |  |  |  |  |  |  |  |  |  |  |  | 10 |  |  | 10
0.735
0.679 |  |  |  |  |  |  |  |  |  |  |  | make sense? |  |  | make sense?
0.923
0.97
0.793
0.901
0.588
0.772
0.768
0.783
0.784
0.891
0.883
0.748
0.884
0.92
0.83
0.721
0.963
0.101
0.724
0.786
0.717
0.899
0.65
0.806
0.943
0.877
0.798
0.611
0.866
0.789
0.712
0.674
0.421
0.922
0.908
0.9
0.88
0.865
0.899
0.65
0.637
0.803
0.852
0.917
0.735
0.006
0.805
0.831
0.877
0.708
0.814
0.75
0.725
0.828
0.828
0.648
0.692
0.824
0.746
0.796
0.873
0.895
0.778
0.682
0.872
0.826
0.857
0.857
0.842
0.729
0.734
Spreadsheet: 849009d1699572925-show-projects-that-an-employee-is-assigned-elliot-current-project-schedule-2023-test
Sheet: AM

AM Name:
Client Name | Show/Project | Size | Detailer | AE | Launch Date | Designer | Graphic Elevations Due Date | New Build Items | Prestage Drawings | Shop Setup Start Date | Ship Date | Electrical Drawing Due | Rigging | Internet | Final Setup Drawing Package Due | Show Date | AM
Spreadsheet: 766587d1643955077-convert-columns-to-rows-keeping-first-column-identifier-convert_col2row-keeping_1st_col_identi_chris
Sheet: Sheet3

Name | ID | In | Out | In2 | Out3 | In4 | Out5 | In6 | Out7 | In8 | Out9 | In10 | Out11
AINSWORTH, NICOLE | 004648 | 2021-08-30 07:00:00 | 2021-08-30 15:00:00 | 2021-08-31 07:00:00 | 2021-08-31 15:00:00 | 2021-09-01 07:00:00 | 2021-09-01 15:00:00 | 2021-09-02 07:00:00 | 2021-09-02 15:00:00 | 2021-09-03 07:00:00 | 2021-09-03 15:00:00 | 2021-09-04 00:00:00 | 2021-09-04 00:00:00
ALLEN, DARELENE | 002246 | 2021-08-30 15:00:00 | 2021-08-30 23:00:00 | 2021-08-31 15:23:00 | 2021-08-31 23:00:00 | 2021-09-01 00:00:00 | 2021-09-01 00:00:00 | 2021-09-02 00:00:00 | 2021-09-02 00:00:00 | 2021-09-03 00:00:00 | 2021-09-03 00:00:00 | 2021-09-04 00:00:00 | 2021-09-04 00:00:00
BEERENS, LIAM | 002066 | 2021-08-30 00:00:00 | 2021-08-30 00:00:00 | 2021-08-31 00:00:00 | 2021-08-31 00:00:00 | 2021-09-01 15:00:00 | 2021-09-01 23:00:00 | 2021-09-02 15:00:00 | 2021-09-02 23:00:00 | 2021-09-03 00:00:00 | 2021-09-03 00:00:00 | 2021-09-04 00:00:00 | 2021-09-04 00:00:00
What I need is
Name | ID | In | Out
AINSWORTH, NICOLE | 004648 | 2021-08-30 07:00:00 | 2021-08-30 15:00:00
AINSWORTH, NICOLE | 004648 | 2021-08-31 07:00:00 | 2021-08-31 15:00:00
AINSWORTH, NICOLE | 004648 | 2021-09-01 07:00:00 | 2021-09-01 15:00:00
AINSWORTH, NICOLE | 004648 | 2021-09-02 07:00:00 | 2021-09-02 15:00:00
AINSWORTH, NICOLE | 004648 | 2021-09-03 07:00:00 | 2021-09-03 15:00:00
AINSWORTH, NICOLE | 004648 | 2021-09-04 00:00:00 | 2021-09-04 00:00:00
ALLEN, DARELENE | 002246 | 2021-08-30 15:00:00 | 2021-08-30 23:00:00
ALLEN, DARELENE | 002246 | 2021-08-31 15:23:00 | 2021-08-31 23:00:00
ALLEN, DARELENE | 002246 | 2021-09-01 00:00:00 | 2021-09-01 00:00:00
ALLEN, DARELENE | 002246 | 2021-09-02 00:00:00 | 2021-09-02 00:00:00
ALLEN, DARELENE | 002246 | 2021-09-03 00:00:00 | 2021-09-03 00:00:00
ALLEN, DARELENE | 002246 | 2021-09-04 00:00:00 | 2021-09-04 00:00:00
Spreadsheet: 765097d1643165834-sum-if-last-instance-of-the-date-sample-file
Sheet: Sheet1

OT Date | Time In | Office | Start Time | End Time | OT Minutes | OT Hours | Total OT for the Day | Reason | Month
2022-01-24 00:00:00 | 7:00 | Chicago | 16:00 | 16:40 | 40 | 0.666666666666667 |  | Chicago OT | January 2022
2022-01-24 00:00:00 | 7:00 | Dallas | 16:00 | 16:50 | 10 | 0.166666666666667 |  | Dallas OT | January 2022
2022-01-26 00:00:00 | 8:00 | IPMM | 17:00 | 18:00 | 60 | 1 |  | Adhoc | January 2022
2022-01-26 00:00:00 | 8:00 | Australia | 18:00 | 19:00 | 60 | 1 |  | Mailbox | January 2022
2022-01-28 00:00:00 | 8:00 | TBP | 19:00 | 20:00 | 60 | 1 |  | BRC | January 2022
Spreadsheet: 128779d1321275566-solved-summarize-an-adaptable-running-list-from-a-column-97-03-compatible-example-set-finished
Sheet: Sheet1

ID | new help 1 | new help 2 | new help 3 | new help 4 | new help 5
A | A | 1 | 7 | A | 7
B | B | 2 | 7 | B | 2
C | C | 3 | 7 | C | 3
A |  |  | 7 | D | 4
A |  |  | 7 | E | 2
A |  |  | 7 | F | 3
B |  |  | 7 | G | 1
C |  |  | 7
D | D | 4 | 7
E | E | 5 | 7
F | F | 6 | 7
G | G | 7 | 7
A |  |  | 7
A |  |  | 7
A |  |  | 7
D |  |  | 7
C |  |  | 7
D |  |  | 7
F |  |  | 7
E |  |  | 7
D |  |  | 7
F |  |  | 7
Spreadsheet: 832709d1686559740-need-formula-to-individual-calculate-of-ratings-1-to-5-from-16-people-polls-ratings_skill
Sheet: Rawdata

Emp | Ratings | Rating Person
[NAME] | 5 | [NAME]
[NAME] | 3 | [NAME]
Wick | 4 | [NAME]
Scott | 1 | [NAME]
[NAME] | 5 | [NAME]
[NAME] | 5 | [NAME]
Wick | 3 | [NAME]
Scott | 4 | [NAME]
[NAME] | 1 | Wick
[NAME] | 2 | Wick
Wick | 5 | Wick
Scott | 5 | Wick
[NAME] | 5 | Scott
[NAME] | 2 | Scott
Wick | 5 | Scott
Scott | 5 | Scott
Spreadsheet: 736513d1623692030-sum-of-units-over-a-time-period-starting-with-initial-units-and-a-known-growth-rate-sum-of-units-over-years
Sheet: Sheet1

First year units |  |  | Year | # at end of year n
1000 |  |  | 1
Number of years |  |  | 2
5 |  |  | 3
Growth rate per year |  |  | 4
0.15 |  |  | 5
Total number of units over five years
?
Spreadsheet: 702230d1604180492-formula-calculate-commission-according-the-criteria-formula-help
Sheet: Sheet1

 | Value | Amount | Deduct Commision
 | 1 | 5000
 |  |  |  |  |  |  |  | Value Cirteria commision deduction citeria
 |  |  |  |  |  |  |  | 0 | 0.05
 |  |  |  |  |  |  |  | 3 | 0.1
 |  |  |  |  |  |  |  | 6 | 0.12
 |  |  |  |  |  |  |  | 7 | 0.13
 |  |  |  |  |  |  |  | 8 | 0.14
 |  |  |  |  |  |  |  | 9 | 0.15
 |  |  |  |  |  |  |  | 10 | 0.16
 |  |  |  |  |  |  |  | 11 | 0.17
 |  |  |  |  |  |  |  | 12 | 0.18
 |  |  |  |  |  |  |  | 13 | 0.19
 |  |  |  |  |  |  |  | 14 | 0.2
 |  |  |  |  |  |  |  | 15 | 0.21
Spreadsheet: 851109d1701353314-count-unique-vaues-based-on-multiple-criteria-count-values-but-exclude-duplicates-hd
Sheet: Sheet1

Business Name | Zone | Manager | Status |  | Unique Counts |  | Criteria
Homer Home Improvements | A | Homer | Active |  |  |  | Homer
Homer Home Improvements | A | Homer | Active |  |  |  | Active
D'oh Playdough | B | [NAME] | Active |  |  |  | A
Santa's Little Helper Inc. | A | [NAME] | Inactive
Santa's Little Helper Inc. | A | [NAME] | Inactive
Santa's Little Helper Inc. | A | [NAME] | Inactive
Santa's Little Helper Inc. | A | [NAME] | Inactive
Straight A Tutors | B | [NAME] | Active
Straight A Tutors | B | [NAME] | Active
Straight A Tutors | B | [NAME] | Active
Duff LLC | C | Homer | Active
Poetry Club LLC | A | [NAME] | Active
Poetry Club LLC | A | [NAME] | Active
Spreadsheet: 856458d1705685302-index-match-how-can-i-avoid-partial-matches-example
Sheet: Sheet1

Company | Category | Search Term | Categories
Sunbeam Windows |  | Sun | Property
Crystal Glazing |  | [NAME] | Windows
Evergreen Supplies |  | Green | Gardens
Sun City |  | HR | People
Christmas
 | Cells A2, A5 and A6 return a match as the search terms exists within part of the text string, however I'm only wanting exact matches
Spreadsheet: 45e8cc57-ac08-4c68-9ad7-412077739ad0
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
6982 | 6522 | Radka | [NAME] | CZE | 32 | 00:39:11 | 00:00:00 | 01:14:36 | 00:00:00 | 00:20:25 | 1 | 02:14:13
6982 | 9743 | Airi | Sawada | JPN | 31 | 00:39:11 | 00:00:00 | 01:15:23 | 00:00:00 | 00:20:31 | 2 | 02:15:06
6982 | 7915 | Long | Hoi | MAC | 33 | 00:40:00 | 00:00:00 | 01:14:34 | 00:00:00 | 00:22:16 | 3 | [NAME]
Spreadsheet: 865810d1712792222-averages-from-a-table-based-on-a-day-of-the-week-and-beginning-ending-time-average-days-times-sample-02
Sheet: Sheet1

FRIDAY
START TIME | END TIME | NUMBER OF TRANSACTIONS | TOTAL SUM ALL CASHIERS | TOTAL SUM WAREHOUSE
00:00:00 | 00:59:59
01:00:00 | 01:59:59
02:00:00 | 02:59:59
03:00:00 | 03:59:59
04:00:00 | 04:59:59
05:00:00 | 05:59:59
06:00:00 | 06:59:59
07:00:00 | 07:59:59
08:00:00 | 08:59:59
09:00:00 | 09:59:59
10:00:00 | 10:59:59
11:00:00 | 11:59:59
12:00:00 | 12:59:59
13:00:00 | 13:59:59
14:00:00 | 14:59:59
15:00:00 | 15:59:59
16:00:00 | 16:59:59
17:00:00 | 17:59:59
18:00:00 | 18:59:59
19:00:00 | 19:59:59
20:00:00 | 20:59:59
21:00:00 | 21:59:59
22:00:00 | 22:59:59
23:00:00 | 23:59:59
Spreadsheet: 852434d1702477712-dates-based-on-number-and-text-from-another-sheet-test
Sheet: Sheet2

Emp | Name | [NAME] | Date
Emp 1 | Test Test | [NAME] | 2023-01-01 00:00:00
Emp 1 | Test Test | [NAME] | 2023-02-01 00:00:00
Emp 1 | Test Test | [NAME] | 2024-03-01 00:00:00
Emp 1 | Test Test | [NAME] | 2025-04-01 00:00:00
Emp 2 | Test 2 | [NAME] | 2023-01-01 00:00:00
Emp 2 | Test 2 | [NAME] | 2023-02-01 00:00:00
Emp 2 | Test 2 | [NAME] | 2024-03-01 00:00:00
Emp 3 | Test 3 | [NAME] | 2025-04-01 00:00:00
Spreadsheet: 141351d1329229890-earliest-date-in-column-earliestdate-sample
Sheet: Sheet1

ID | Date |  | ID | Earliest Date
102039 | 2012-04-01 00:00:00 |  | 102039 | 2009-06-08 00:00:00
102039 | 2011-04-05 00:00:00 |  | 32651 | 2010-01-01 00:00:00
102039 | 2010-02-01 00:00:00
102039 | 2009-06-08 00:00:00
32651 | 2012-02-01 00:00:00
32651 | 2011-09-19 00:00:00
32651 | 2010-01-01 00:00:00
Spreadsheet: 539621d1506307049-golf-formulas-help-please-golfpayouts-fixing
Sheet: Sheet1

POT | 60
NEXT WEEK
POINTS
 | 2017-09-18 00:00:00
RAY | 28
STAN | 29
WAYNE | 16
LYNN | 28
MOE | 22
CHRIS | 22
[NAME] | 28
HARRY | 23
PETE | 28
EDD | 19
[NAME] | 9
STEVE | 22
DOUG | 35
HAL BAXLEY | 26
ACTUAL
POINTS
 | 25 | 28
 | 29
 | 17 | 24
 | 28
 | 26
 | 25 | 22
 | 30
 | 26
 | 28 | 22
 | 8
# OF PLAYERS
MONEY WON
POINTS +/-
 | Do not mess with these numbers or formulas below here
Spreadsheet: 131186d1322776730-calculating-total-pay-for-multiple-employees-timesheet
Sheet: Sheet1

Date :- | 2011-12-05 00:00:00 |  | Machine :- | 1 |  | Shift :- | 9-5
Production
Clock no | Operator | Grade | In | Out | In | Out | Total Units | Rate | Pence per Unit | Total Earnings
1 | [NAME] | B | 9 | 5 |  |  | 1000 | 0.53 | 0.1596
2 | [NAME] | C | 9 | 5 |  |  |  | 0.52 | 0.1369
3 | [NAME] | A | 9 | 5 |  |  |  | 0.54 | 0.1713
4 | [NAME] | A | 9 | 5 |  |  |  | 0.54 | 0.1713
5 | [NAME] | A | 9 | 5 |  |  |  | 0.54 | 0.1713
Date :- | 2011-12-06 00:00:00 |  | Machine :- | 1 |  | Shift :- | 9-5
1 | [NAME] | B | 9 | 5 |  |  | 1000 | 0.53 | 0.1596
2 | [NAME] | C | 9 | 5 |  |  |  | 0.52 | 0.1369
3 | [NAME] | A | 9 | 5 |  |  |  | 0.54 | 0.1713
4 | [NAME] | A | 9 | 5 |  |  |  | 0.54 | 0.1713
5 | [NAME] | A | 9 | 5 |  |  |  | 0.54 | 0.1713
Date :- | 2011-12-07 00:00:00 |  | Machine :- | 1 |  | Shift :- | 9-5
1 | [NAME] | B | 9 | 5 |  |  | 1000 | 0.53 | 0.1596
2 | [NAME] | C | 9 | 5 |  |  |  | 0.52 | 0.1369
3 | [NAME] | A | 9 | 5 |  |  |  | 0.54 | 0.1713
4 | [NAME] | A | 9 | 5 |  |  |  | 0.54 | 0.1713
5 | [NAME] | A | 9 | 5 |  |  |  | 0.54 | 0.1713
Date :- | 2011-12-08 00:00:00 |  | Machine :- | 1 |  | Shift :- | 9-5
1 | [NAME] | B | 9 | 5 |  |  | 1000 | 0.53 | 0.1596
2 | [NAME] | C | 9 | 5 |  |  |  | 0.52 | 0.1369
3 | [NAME] | A | 9 | 5 |  |  |  | 0.54 | 0.1713
4 | [NAME] | A | 9 | 5 |  |  |  | 0.54 | 0.1713
5 | [NAME] | A | 9 | 5 |  |  |  | 0.54 | 0.1713
Date :- | 2011-12-09 00:00:00 |  | Machine :- | 1 |  | Shift :- | 9-5
1 | [NAME] | B | 9 | 5 |  |  | 1000 | 0.53 | 0.1596
2 | [NAME] | C | 9 | 5 |  |  |  | 0.52 | 0.1369
3 | [NAME] | A | 9 | 5 |  |  |  | 0.54 | 0.1713
4 | [NAME] | A | 9 | 5 |  |  |  | 0.54 | 0.1713
5 | [NAME] | A | 9 | 5 |  |  |  | 0.54 | 0.1713
Problem: How to get excel to automatically sum total wages payable per employee without the need to manually do this.
1 | [NAME]
2 | [NAME]
3 | [NAME]
4 | [NAME]
5 | [NAME]
Spreadsheet: 758905d1639153092-xlookup-for-two-criteria-vertical-and-horizontal-floor-list
Sheet: Client List

 | Configuration | No of Units |  | Beam & Block | Suspended
[NAME] | [NAME] | 0 |  | 106.08 | 60
[NAME] | [NAME] | 0 |  | 0 | 0
Camb | [NAME] | 1 |  | 106.08 | 460.7807647058824
Hamp | [NAME] | 1 |  | 106.08 | 60
Henl | [NAME] | 1 |  | 11779.59733333333 | 3491.673
Leddh | [NAME] | 1 |  | 106.08 | 60
Maro | [NAME] | 1 |  | 106.08 | 60
Oxfo | [NAME] | 1 |  | 106.08 | 60
Oxfoq | [NAME] | 1 |  | 106.08 | 60
Shaf | [NAME] | 1 |  | 106.08 | 60
[NAME] | 4 Block | 4 |  | 106.08 | 60
[NAME] | 6 Block | 6 |  | 106.08 | 60
Stra | [NAME] | 1 |  | 106.08 | 60
Sund | [NAME] | 1 |  | 106.08 | 60
Apart | [NAME] | 1 |  | 106.08 | 60
Spreadsheet: 141545d1329323951-wrapping-a-max-function-around-an-if-statement-example-max
Sheet: Pivot

Area Trading Manager | (All)
Network Manager | (All)
Regional Trading Director | (All)
Branch Code | Vehicle Registration Number | Driving Time | Idling Time | % Of Idle Time | Idling Cost
BGE
 | DV52ERU | 1 day, 9:55:52 | 1:57:45 | 0.05783777587633954 | 3.296999999452382
BGE Total |  | 1 day, 9:55:52 | 1:57:45 | 0.05783777587633954 | 3.296999999452382
[NAME]
 | DY03YMP | 13:57:51 | 1:42:45 | 0.1226353165909243 | 2.877000000136902
CV Total |  | 13:57:51 | 1:42:45 | 0.1226353165909243 | 2.877000000136902
RK
 | DV03XTA | 1 day, 21:58:03 | 1:06:31 | 0.02411728092630906 | 1.862466666391119
RK Total |  | 1 day, 21:58:03 | 1:06:31 | 0.02411728092630906 | 1.862466666391119
RX
 | DU52LFF | 3 days, 8:41:41 | 2:16:24 | 0.02817202006219953 | 3.819200000069106
RX Total |  | 3 days, 8:41:41 | 2:16:24 | 0.02817202006219953 | 3.819200000069106
Grand Total |  | 7 days, 6:33:27 | 7:03:25 | 0.2327623934557724 | 11.85566666604951
Spreadsheet: 842406d1694500155-buchstaben-nach-kriterien-auswerten-ressourcenplanung
Sheet: Auslastung

 |  | 2023 |  |  |  | 2024 |  |  |  | 2025
 |  | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4
Franz | Meier | F | F | G | G | G | G | B | B | B | B | B | B
Sepp | [NAME] | B | B | B | B | B | B | B | B | B | B | F | F
[NAME] | Huber | G | G | G | G | B | B | B | B | B | B | B | F
Spreadsheet: 757497d1638292778-dynamic-drop-down-list-box-dilemma-demo
Sheet: List

1941 |  | Unique & sorted
1962
1941
1918
1874
1872
1931
1941
1962
1955
1941
1962
1941
1918
1874
1872
1931
1941
1962
1955
Spreadsheet: 159341d1338584286-if-statements-in-multiple-columns-sample
Sheet: Sheet1

PTO Tracker1st Quarter
2012-01-01 00:00:00
 |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue
Last Name | Paid Time Off | 2012-01-01 00:00:00 | 2012-01-02 00:00:00 | 2012-01-03 00:00:00 | 2012-01-04 00:00:00 | 2012-01-05 00:00:00 | 2012-01-06 00:00:00 | 2012-01-07 00:00:00 | 2012-01-08 00:00:00 | 2012-01-09 00:00:00 | 2012-01-10 00:00:00 | 2012-01-11 00:00:00 | 2012-01-12 00:00:00 | 2012-01-13 00:00:00 | 2012-01-14 00:00:00 | 2012-01-15 00:00:00 | 2012-01-16 00:00:00 | 2012-01-17 00:00:00 | 2012-01-18 00:00:00 | 2012-01-19 00:00:00 | 2012-01-20 00:00:00 | 2012-01-21 00:00:00 | 2012-01-22 00:00:00 | 2012-01-23 00:00:00 | 2012-01-24 00:00:00 | 2012-01-25 00:00:00 | 2012-01-26 00:00:00 | 2012-01-27 00:00:00 | 2012-01-28 00:00:00 | 2012-01-29 00:00:00 | 2012-01-30 00:00:00 | 2012-01-31 00:00:00
Spreadsheet: 117959d1313300073-listing-ranked-items-with-multiples-of-the-same-rank-5pe-ranking-trial
Sheet: Trial Sheet

 | DATA |  |  |  |  |  |  |  | 5PE List | 100 | Todays date
 | 1st | 2nd | 5PE | 1st | 2nd | 1st | 2nd |  |  | Rank | Die# | 1st Common | 2nd Common
 |  |  | 42111-02070 | 2011-04-20 00:00:00 | 2011-06-15 00:00:00 |  |  | This is easier to understand, but would rather have them listed separately |  | 1
 |  |  | 42111-08030 | 2011-05-23 00:00:00 | 2011-07-25 00:00:00 |  |  |  |  | 2
 |  |  | 42313/4-08040/30 | 2011-05-20 00:00:00 | 2011-07-08 00:00:00 |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  | 6
 |  |  | 48232/3-08020 | 2011-04-21 00:00:00 | 2011-04-25 00:00:00 |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  | 2nd #6 Die does not show up. What do I cange to make this show up? |  | 9
 |  |  |  |  |  |  |  |  |  | 10
 |  |  | 48621-08030 | 2011-05-03 00:00:00 | 2011-07-26 00:00:00
 |  |  | 48621-0C010 | 2011-04-20 00:00:00 | 2011-07-21 00:00:00
 |  |  | 48622-08030 | 2011-02-19 00:00:00 | 2011-02-19 00:00:00
 |  |  | 48622-0C010 | 2011-04-27 00:00:00 | 2011-07-27 00:00:00
 |  |  | 48623-08030 | 2011-05-05 00:00:00 | 2011-07-26 00:00:00
 |  |  | 48623-0C020 | 2011-04-29 00:00:00 | 2011-05-03 00:00:00
 |  |  | 48624-08030 | 2011-05-04 00:00:00 | 2011-05-04 00:00:00
 |  |  | 48624-0C020 | 2011-01-26 00:00:00 | 2011-03-31 00:00:00
 |  |  | 48711/2-08010 | 2011-04-19 00:00:00 | 2011-06-18 00:00:00
Spreadsheet: 219218d1362686422-if-else-if-or-easier-recommendation-samplebook
Sheet: Sheet1

Commission Scale
0-24 | 0
25-49 | 1
50-74 | 2
75-99 | 3
100-124 | 4
125-149 | 5
150-174 | 6
175-199 | 7
200-249 | 8
>250 | 10
Spreadsheet: 355553d1414708135-how-to-combine-two-results-into-one-celll-after-index-match-combine-two-results-into-one-cell-by-index-match
Sheet: Sheet1

 |  | 1953 | 2014-10-30 00:00:00 | bill |  |  |  |  |  |  |  |  |  | 2014-10-30 00:00:00 | 06:30:00
 |  | 1954 | 2014-10-30 00:00:00 | bill |  |  |  |  |  | TECHNICIAN | bill
 |  |  |  |  |  |  |  |  |  | Part # | PLAN | ACTUAL | ISSUE
 |  |  |  |  |  |  |  |  |  |  | grinding
 |  |  |  |  |  |  |  |  |  | question: formula in cell k8 only show 1953, how to add 1954 into cell k8 with "/". It will ends like |  |  |  |  |  | 1953/1954
Spreadsheet: df5af0f4-c93a-4b23-81ae-5593938a0306
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
5251 | 6801 | [NAME] | [NAME] | HKG | 42 | [NAME] | 00:00:00 | 01:09:56 | 00:00:00 | 00:23:59 | 1 | 02:13:47
5251 | 10618 | [NAME] | Mangrobang | PHI | 41 | 00:42:49 | 00:00:00 | 01:09:58 | 00:00:00 | 00:31:16 | 2 | 02:24:04
Spreadsheet: 147077d1332515206-recognise-and-count-specific-words-count-vehicles
Sheet: Sheet1

NO: | E/R | NAME | VEHICLE | REG NO | STK NO
1 | USED | JONES | FIESTA | LY10YPA | 98374
2 | USED | SMITH | MONDEO | LV09DHE | 32435
3 | USED | HOLDEN | FOCUS | LM09LKM | 23425
4 | USED | HUMPHREY | TRANSIT | EY61JYO | 32456
5 | USED | TAYLOR | CONNECT | AD10CMV | 24356
 |  | car
 |  | COMMERCIAL | 2
 |  | Other
 |  | TOTAL
Spreadsheet: 871938d1718312674-index-match-5-criterias-or-xlookup-index-match-5-criteria
Sheet: Cost Calc. 

NT - ITEM CODE | Bag Code Reference | Box Code Reference | Brand Code | Volume Units | Volume Cases | Volume KG | Volume LBS | PLANT | Business Split | DL EAST |  | DL WEST |  | WASTE | RM CODE |  | [NAME] | Bag type | G | OZ | Units/Box | INGR # | CROP Previous | CROP Current | RM  2021 | NEW RM OLD FX  2021 | RM  2022
NEWWM001 | NICB176420 | GENX1EAS07 |  | 100000 |  |  |  | Montreal | 60% Montreal / 40% West | Montreal | 0.65 | [NAME] |  | 0.03 | MANBCMAL |  | Sliced [NAME] | ROLL | 1750 |  | 6 | 1 |  | MAR-24
NEWWM001 | NICB176420 | GENX1EAS07 |  | 100000 |  |  |  | Kansas | 60% Montreal / 40% West | Montreal | 0.65 | [NAME] |  | 0.03 | MANBCMAL |  | Sliced [NAME] | ROLL | 1750 |  | 6 | 1 |  | MAR-24
NEWWM001 | NICB176420 | GENX1EAS07 |  | 100000 |  |  |  | Abbostford | 60% Montreal / 40% West | Montreal | 0.65 | [NAME] |  | 0.03 | MANBCMAL |  | Sliced [NAME] | ROLL | 1750 |  | 6 | 1 |  | MAR-24 |  |  |  |  |  |  | Please help to solve the problem
NEWWM001 | NICB176420 | GENX1EAS07 |  | 100000 |  |  |  | Virginia | 60% Montreal / 40% West | Montreal | 0.65 | [NAME] |  | 0.03 | MANBCMAL |  | Sliced [NAME] | ROLL | 1750 |  | 6 | 1 |  | MAR-24
NEWWM001 | NICB176420 | GENX1EAS07 |  | 100000 |  |  |  | Jacona | 60% Montreal / 40% West | Montreal | 0.65 | [NAME] |  | 0.03 | MANBCMAL |  | Sliced [NAME] | ROLL | 1750 |  | 6 | 1 |  | MAR-24 |  |  |  |  |  |  | 5 Criterias  in column I
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Each Criteria has its own array  linked to RM-Fruit tab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] should match RM code in coulm P and Date in column Y
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Can be used index match or Xclookup
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Result in AB column
Spreadsheet: 47268d1246272971-how-do-i-conditionally-count-asterisk-in-a-cell-test-1-
Sheet: Sheet1

 | Date | Supervisor | Missed IR | Missed PIN
 | 2009-06-15 00:00:00 | [NAME], [NAME] | *
 | 2009-06-15 00:00:00 | [NAME], [NAME] | *
 | 2009-06-15 00:00:00 | [NAME], [NAME] |  | *
 | 2009-06-16 00:00:00 | Salud, Glenn | *
 | 2009-06-16 00:00:00 | Salud, Glenn |  | *
 | 2009-06-17 00:00:00 | Lapasaran, [NAME] | * | *
 | 2009-06-18 00:00:00 | Rubis, [NAME] | *
 | 2009-06-19 00:00:00 | Rubis, [NAME] |  | *
 |  | should be able to count all missed by Supervisor
 | SUPERVISOR | Missed IR | Missed PIN
 | [NAME], [NAME] | 2 | 1
 | Salud, Glenn | 1 | 1
 | Lapasaran, [NAME] | 1 | 1
 | Rubis, [NAME] | 1 | 1