tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 773142d1647638376-return-text-based-on-a-value-in-today-column-header-attendance-dashboard
Sheet: Attendence Dashboard

Month | Year
3 | 2022
ID No. | Employee Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DUTY |  |  | P | H
1 | [NAME] | D | P | P | P |  |  | P | P | P | P | P |  |  | P | P | P | P | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
2 | [NAME] | P | D | P | P |  |  | P | P | P | P | P |  |  | P | P | P | P | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
3 | [NAME] | D | P | D | P |  |  | H | H | H | H | H | H | H | H | H | H | H | H | H | H |  |  |  |  |  |  |  |  |  |  | D
4 | [NAME] | P | D | P | D |  |  | P | P | P | P | P |  |  | P | P | P | P | P |  |  |  |  |  |  |  |  |  |  |  | D |  |  |  | =TODAY() | =TODAY()+1
5 | [NAME] | P | P | D | P | D |  | P | P | P | P | P |  |  | P | P | P | P | P |  |  |  |  |  |  |  |  |  |  | D |  |  |  |  | If an employee is on duty "D" (in the{=Today()} column) the employee name should appear in the duty table.
6 | [NAME] | P | P | P | D |  | D | P | P | P | P | P |  |  | P | P | P | P | P |  |  |  |  |  |  |  |  |  | D
7 | [NAME] | P | P | P | P | D |  | D | P | P | P | P |  |  | P | P | P | P | P |  |  |  |  |  |  |  |  | D |  |  |  | D
8 | [NAME] | L | L | L | L |  | D | L | D | P | H | H | H | H | H | H | H | H | H | H | H |  |  |  |  |  | D |  |  |  | D
9 | [NAME] | P | P | P | P |  |  | D | P | D | P | P |  |  | P | P | P | P | P |  |  |  |  |  |  | D |  |  |  | D
10 | [NAME] | P | P | P | P |  |  | P | D | P | D | P |  |  | P | P | P | P | P |  |  |  |  |  | D |  |  |  | D
11 | [NAME] | P | P | P | P |  |  | P | P | D | P | D |  |  | P | P | P | P | P |  |  |  |  | D |  |  |  | D
12 | [NAME] | P | P | P | P |  |  | P | P | P | D | P | D |  | P | P | P | P | P |  |  |  | D |  |  |  | D
13 | [NAME] | L | L | L | L |  |  | L | L | L | L | D |  | D | P | P | P | P | P |  |  | D |  |  |  | D
14 | [NAME] | P | P | P | L |  |  | P | P | P | P | P | D |  | D | P | P | P | P |  | D |  |  |  | D
15 | [NAME] | P | P | P | L |  |  | P | P | P | P | P |  | D |  | D | P | P | P | D |  |  |  | D
16 | [NAME] | H | H | H | H | H | H | H | H | H | H | H | H | H | D | P | D | P | D |  |  |  | D
17 | [NAME] | P | P | P | P |  |  | P | P | P | P | P |  |  | P | D | P | D | P |  |  | D
18 | [NAME] | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | D | H | D |  | D
19 | [NAME] | P | P | P | P |  |  | P | P | P | P | P |  |  | P | P | P | D | P | D
 |  | D = Duty
 |  | P = Present
 |  | L = Leave
 |  | H = Holiday
 | text(p2;"0;0;0;@")
Spreadsheet: 884339d1733431648-trying-to-load-names-for-teams-in-proper-order-teams-schedule
Sheet: Team Course Schedule

Week 1
Teams |  | 2025-05-27 00:00:00 | HCP | Place |  |  |  |  | HCP | Place |  |  |  |  | HCP | Place |  |  |  |  | HCP | Place |  |  |  |  | HCP | Place
1 | 1a |  |  |  | 2 | 2a |  |  |  |  | 3 | 3a |  |  |  |  | 4 | 4a |  |  |  |  | 5 | 5a
 | 1 |  |  |  |  | 2 |  |  |  |  |  | 3 |  |  |  |  |  | 4 |  |  |  |  |  | 5
 |  | VS | HCP |  |  |  | VS |  | HCP | Place |  |  | VS |  | HCP | Place |  |  | VS |  | HCP | Place |  |  | VS |  | HCP | Place
10 | 10a |  |  |  | 9 | 9a |  |  |  |  | 8 | 8a |  |  |  |  | 7 | 7a |  |  |  |  | 6 | 6a
 | 10 |  |  |  |  | 9 |  |  |  |  |  | 8 |  |  |  |  |  | 7 |  |  |  |  |  | 6
Week 2
Teams |  |  | HCP | Place |  |  |  |  | HCP | Place |  |  |  |  | HCP | Place |  |  |  |  | HCP | Place |  |  |  |  | HCP | Place
1 | 1 |  |  |  | 2 | 2a |  |  |  |  | 4 | 4a |  |  |  |  | 5 | 5a |  |  |  |  | 6 | 6a
 | 1 |  |  |  |  | 2 |  |  |  |  |  | 4 |  |  |  |  |  | 5 |  |  |  |  |  | 6
 |  | VS | HCP |  |  |  | VS |  | HCP | Place |  |  | VS |  | HCP | Place |  |  | VS |  | HCP | Place |  |  | VS |  | HCP | Place
3 | 3a |  |  |  | 10 | 10a |  |  |  |  | 9 | 9a |  |  |  |  | 8 | 8a |  |  |  |  | 7 | 7a
 | 3 |  |  |  |  | 10 |  |  |  |  |  | 9 |  |  |  |  |  | 8 |  |  |  |  |  | 7
Spreadsheet: 063c9ece-0639-4523-bcf9-68c1f7fd1e93
Sheet: Activites codes

 | SFY 2013 FEDERAL CODE SHEET
SFY 2013 FEDERAL EDRS-SERVS-UFARS codes crosswalk
EDRS Activity codes
Activity Code | [NAME]
J | Assessment
K | Coursework Registration, Tuition or Fee
L | [NAME] (Personnel Development only)
M | Special Education Curriculum Development
N | Special Education Program Evaluation
O | IEP Planning Development, Review Due Process
S | Advisory Committee Activities
T | Conference/Workshop Expenses
V | Professional Membership/Dues Expenses
W | Family Events
X | Interagency Activities
Z | Travel, Mileage, Meals and Lodging
Team Teaching Required for Personnel type code 1
+ | Team Teaching Model - Regular Class
* | Team Teaching Model - Resource Room
# | Team Teaching Model - Separate Class
Required for Personnel type code 12 Cultural Liaison
t | Americal Indian
u | Bilingual
v | African American
w | Other
Required for Alternative Delivery of Specialized Instructional Services FSC Z and FSC z
s | Special Education Teacher
R | Regular Education Teacher
Required for Personnel Type code 62
a | Interpreter Services
b | Assistive Technology Services
c | Para/PCA Services
d | Nursing Services
e | Vision Services
f | Other IEP Specified Services
Spreadsheet: louise_kitchen__23975__Schedule C_927
Sheet: Schedule C

Schedule C
Second Quarter 2001
Item: |  | 2001-06-30 00:00:00 |  | Expected |  | Unidentified |  | 2000-10-18 00:00:00 |  | 2000-11-06 00:00:00 |  | 2001-09-28 00:00:00
Entex - Volumetric exposure |  | 0 |  |  |  |  |  | 3.2 |  | 3.2 |  | 0
APEA Prepay |  | 1.1 |  |  |  |  |  | 1.1 |  | 1.1 |  | 1.1
Entex- Swap fixed/index |  | 0 |  |  |  |  |  | 0.9 |  | 0.9 |  | 0
Canada Toll Rates |  | 2 |  |  |  |  |  | 0.5 |  |  | (B)
Napoleonville Pad Gas |  | 1.6 |  |  |  |  |  |  |  |  |  | 1.6
Long-Term Transport - El Paso |  | 0
AEP |  | 0
Credit Reserve |  | 67 |  |  |  |  |  |  |  |  |  | 67
Allowance for Doubtful Accounts ([NAME]) |  | 80 |  |  |  |  |  |  |  |  |  | 80
Gas Release |  | 0 |  |  |  |  |  |  |  |  |  | -500
Gas Reserve |  | 457
Items less than $0.5MM |  | 0.1 |  |  |  |  |  | 1.3 |  |  | (C)
Gas Books
Other |  | 89.9 |  |  |  |  |  | 90.9 |  | 90.9 |  | 89.9
Other |  | 90 |  |  |  |  |  | 90 |  | 90 |  | 90
Colorado Springs |  | 17.2 |  |  |  |  |  | 17.2 |  | 17.2 |  | 17.2
ERCOT Transmission |  | 2.9 |  |  |  |  |  | 2.9 |  | 2.9 |  | 2.9
FP&L / JEA |  | 10.3 |  |  |  |  |  | 12.1 |  | 12.1
California Political Risk |  | 47 |  |  |  |  |  | 47 |  | 47 |  | 47
OPPD |  | 5 |  |  |  |  |  | 5 |  | 5 |  | 5
VEPCO |  | 3 |  |  |  |  |  | 3 |  | 3 |  | 3
MJMUC |  | 2 |  |  |  |  |  | 2 |  | 2 |  | 2
Engage Energy |  | 0 |  |  |  |  |  | 0.7 |  | 0.7 |  | 0
Welded Tube |  | 0.6 |  |  |  |  |  | 0.6 |  | 0.6 |  | 0.6
Canfibre |  | 2.9 |  |  |  |  |  | 0 |  | 3.445 |  | 2.9
Reedy Creek |  | 1 |  |  |  |  |  |  |  |  |  | 0
ENA CAL |  | 0 |  |  |  |  |  |  |  |  |  | 0
Northwest Refund Risk |  | 0 |  |  |  |  |  |  |  |  |  | 10
[NAME] |  | 0 |  |  |  |  |  |  |  |  |  | 0
Green Mountain |  | 1.7
West Market Liquidity |  | 0 |  |  |  |  |  |  |  |  |  | 0
PG&E |  | 51.5
EPMI |  | 0.9 |  |  |  |  |  |  |  |  |  | 0.9
Metro Water District |  | 2.3 |  |  |  |  |  |  |  |  |  | 0
BPA |  | 0 |  |  |  |  |  |  |  |  |  | 22.8
Delivery risk - BPA Federal Surplus Power Clause |  | 11.4 |  |  |  |  |  |  |  |  |  | 11.4
Power Reserve |  | 123.5 |  |  |  |  |  |  |  |  |  | 123.5
Power Books
TVA |  | 0 |  |  |  |  |  | 56 |  | 56 |  | 0
Reserve for COF Rediscounting |  | 0 |  |  |  |  |  |  |  |  |  | 0
Total Schedule C
[NAME]'s Schedule
[NAME]
Metro Water District Change |  |  |  |  |  |  |  |  |  |  |  | -1.1
Green Mountain Change |  |  |  |  |  |  |  |  |  |  |  | 0.4
Canada Gas Change |  |  |  |  |  |  |  |  |  |  |  | -1
Reedy Creek Release |  |  |  |  |  |  |  |  |  |  |  | -1
Unexplained Variance
Spreadsheet: 125311d1318962017-formula-for-total-up-proba
Sheet: How it is now

Nr.[NAME]. | Region | County | Town | Street | Year since function | Length
1 | SOUTH | ALBA | Alba Iulia | Regina Maria | 1984 | 0.128
2 | SOUTH | ALBA | Alba Iulia | Revolutiei | 1985 | 0.145
3 | SOUTH | ALBA | Alba Iulia | Revolutiei | 1985 | 0.164
4 | SOUTH | ALBA | Alba Iulia | Revolutiei | 1985 | 0.164
5 | SOUTH | ALBA | Alba Iulia | Revolutiei | 1983 | 0.105
6 | SOUTH | ALBA | Alba Iulia | Revolutiei 1989 | 1983 | 0.054
7 | SOUTH | ALBA | Alba Iulia | Revolutiei 1989 | 1983 | 0.054
8 | SOUTH | ALBA | Alba Iulia | Revolutiei 1989 | 1985 | 0.245
9 | SOUTH | ALBA | Alba Iulia | Revolutiei 1989 | 1989 | 0.4
10 | SOUTH | ALBA | Alba Iulia | Simion Barnutiu | 1994 | 0.164
Spreadsheet: drew_fossum__8685__sharris1100wk4
Sheet: Annual V. Plan 

Transwestern Annual Total  Variance
 |  | Annual | Annual | Annual
 |  | Margin | Fuel & UAF | Total
Plan |  | 147.1638 | 20.982 | 168.1458
Actuals through Sept.,Oct. Wkly., & 4th Forecast |  | 149.685849857216 | 27.30115980308685 | 176.9870096603028
 |  | ------------- | ------------- | -------------
Variance from Plan |  | 2.52204985721599 | 6.319159803086855 | 8.841209660302844
 |  | ------------- | ------------- | -------------
Resolution of El Paso Measurement Dispute |  |  |  | 3
 |  |  |  | -------------
Adjusted Variance from Plan |  |  |  | 11.84120966030284
 |  |  |  | ========
Sempra Contract in December |  |  |  | 0.31
 |  |  |  | -------------
 |  |  |  | 12.15120966030284
 |  |  |  | ========
Spreadsheet: 59430d1259929914-how-to-automate-top-5-entries-in-a-worksheet-709631_befuddled_v2
Sheet: Sep09

Date | Item | Description |  |  |  | 2009-09-01 00:00:00 | Items | A | apples
 |  |  |  |  |  |  |  | B | bananas
 |  |  |  |  |  |  |  | C | carrots
 |  |  |  |  |  |  |  | D | dogs
 |  |  |  |  |  |  |  | E | elephants
 |  |  |  |  |  |  |  | F | fish
 |  |  |  |  |  |  |  | G | grapes
 |  |  |  |  |  |  |  | H | hyenas
 |  |  |  |  |  |  |  | I | iguanas
 |  |  |  |  |  |  |  | J | jesuits
Spreadsheet: 77831d1278331113-value-error-total-for-all
Sheet: Totals

 |  | Total Time Recorded for each Category
 |  | Other Building Control Activities |  |  | Non-Chargaeable activities |  |  | Chargeable Activities
 |  | A1 | 1904-01-02 00:00:00 | 0.96 | B1 |  |  | C1
 |  | A2 |  | #N/A | B2 | 12:00:00 |  | C2
 |  | A3 |  | #N/A | B3 | 12:00:00 |  | [NAME]
 |  | A4 |  | #N/A | B4 | 12:00:00 |  | C4 | 12:00:00
 |  | A5 |  | #N/A | B5 |  |  | C5
 |  | A6 | 01:00:00 | 0.04000000000000001 | B6 |  |  | C6
 |  | A7 |  | #N/A | B7 |  |  | C7
 |  | A8 |  | #N/A | B8 |  |  | C8
 |  | A9 |  | #N/A | B9 |  |  | C9
 |  | A10 |  | #N/A | B10 |  |  | C10 | 01:00:00
 |  | A11 |  | #N/A | B11 |  |  | C11
 |  | A12 |  | #N/A | B12 |  |  | C12
 |  | A13 |  | #N/A | B13 |  |  | C13
 |  | A14 |  | #N/A |  |  |  | C14
 |  | A15 |  | #N/A |  |  |  | C15
 |  | A16 |  | #N/A |  |  |  | C16
 |  | A17 |  | #N/A |  |  |  | C17
 |  | A18 |  | #N/A
 |  | A19 |  | #N/A
 |  | A20 |  | #N/A
 |  | A21 |  | #N/A
 |  | A22 |  | #N/A
 |  | A23 |  | #N/A
 |  | A24
 |  | A25
 |  | A26
 |  | A27 |  | #N/A
 |  | A28 |  | #N/A
 |  | A29 |  | #N/A
 |  | A30 |  | #N/A
 |  | Total | 1904-01-02 01:00:00 |  |  | 1904-01-02 12:00:00 |  |  | 13:00:00
 | Percentages of Total |  | 0.3378378378378378 |  | 0.4864864864864866 |  |  | 0.1756756756756757
Spreadsheet: 847791d1698665283-combine-functions-to-return-the-right-values-from-a-matrix-excelforum_1
Sheet: Calendar 1

 |  |  |  |  |  |  |  |  |  |  |  | Function not working → |  |  |  | [NAME] not working
 | MATRIX |  |  |  |  |  |  |  |  |  |  | RETURN VALUES FROM THE MATRIX
 | ↓ |  |  | ↓ |  |  | ↓ |  |  | 2023-10-04 00:00:00
 | Unit | Position | Shift | Staff | 01/10/2023 | 02/10/2023 | 03/10/2023 | 04/10/2023 | 05/10/2023 | Oct |  | Day: | 2023-10-03 00:00:00
 | 2C | Position1 | M | Employee 01 | 2C |  | 2C | 2C
 | 3P | Position1 | E | Employee 02 |  | 3P | 3P |  |  |  |  | 2C |  |  | 4C
 | 4C | Position1 | N | Employee 03 | 4C |  | 4C | 4C
 | 2C | Position1 | M | Employee 04 | 2C | 2C | 2C
 | 3P | Position1 | E | Employee 05 |  | 3P
 | 4C | Position1 | N | Employee 06 | 4C |  | 4C
 | FLO | Position1 | M | Employee 07 | FLO |  | FLO | FLO
 | 3P | Position1 | E | Employee 08 | HOL | HOL | 3P |  |  |  |  | 3P |  |  | FLO
 | 4C | Position1 | N | Employee 09 | VAC | VAC | VAC | VAC | VAC
 | 2C | Position1 | M | Employee 10 | 2C | SICK | SICK | SICK
 | FLO | Position1 | M | Employee 11 | FLO |  | FLO |  | FLO
 | 3P | Position1 | M | Employee 12 | 3P |  | 3P
 | 2C | Position1 | M | Employee 13 |  | 2C
 | 3P | Position1 | M | Employee 14 | 3P |  | 3P |  |  |  |  | VAC |  | HOL |  | Sick
 | 2C | Position1 | M | Employee 15 | 2C | 2C | 2C
 | FLO | Position1 | M | Employee 16 | FLO |  | FLO |  | FLO
 | 2C | Position1 | M | Employee 17 |  | 2C
 | 3P | Position1 | M | Employee 18 | VAC | VAC | VAC | VAC | VAC
Spreadsheet: 474080d1470625976-highlighting-cells-based-on-start-end-date-and-time-dynamic-and-reusable-sheet-time-shading
Sheet: Sheet1

[NAME] | Start date | Start Time | End date | End Time
Total net runtime | 2016-04-16 00:00:00 | 21:02:34 | 2016-04-17 00:00:00 | 02:40:21
Total net runtime | 2016-04-16 00:00:00 | 23:52:26 | 2016-04-17 00:00:00 | 01:56:26
Spreadsheet: 888286d1738777864-sumproduct-sum-not-liking-adding-whole-column-formula-query-5-feb
Sheet: Sheet1

2025-01-20T05:21:15.615Z |  |  | Monday | 1
2025-01-20T05:21:30.003Z |  |  | Tuesday | 2
 |  |  | Wednesday | 3
2025-01-21T17:30:35.234Z |  |  | Thursday | 4
2025-01-21T17:30:51.058Z |  |  | Friday | 5
2025-01-21T17:30:52.105Z |  |  | Saturday | 6
2025-01-21T17:31:01.084Z |  |  | Sunday | 7
2025-01-21T17:31:01.250Z
2025-01-21T20:30:53.287Z
2025-01-21T20:30:53.695Z
2025-01-22T06:48:44.802Z
2025-01-22T06:48:48.830Z
2025-01-22T11:49:25.654Z
2025-01-22T11:50:23.399Z
2025-01-22T11:50:23.408Z
2025-01-22T11:50:23.409Z
Spreadsheet: 373542d1422472488-search-a-dynamic-number-of-cells-in-a-column-based-on-data-in-column-a-testsheet
Sheet: SourceSheet

Oakridge Apartments (0019)
Apt Nbr |  | Name |  |  |  |  |  | Active |  | Eviction |  |  | Last Payment |  |  |  |  | Receivable Type |  |  |  | Current |  |  | Over 30 |  | Over 60 |  | Over 90 |  |  | Over 120 |  |  | Balance
 |  |  |  |  |  |  |  |  |  |  |  |  | Amt |  | Date
1284-3 |  | normal, person (1789) |  |  |  |  |  | Y |  | Y |  |  | 1145 |  | 2014-12-23 00:00:00 |  |  | Rent - |  |  |  | 808 |  |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  | 808
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Late Charge - |  |  |  | 25 |  |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Filing Fee - |  |  |  | 150 |  |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  | 150
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month To Month - |  |  |  | 50 |  |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  | 50
 |  |  | Apt: 1284-3 Total: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1033 |  |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  | 1033
1284-8 |  | not normal p (1793) |  |  |  |  |  | Y |  | N |  |  | 150 |  | 2015-01-16 00:00:00 |  |  | Unapplied Payment - |  |  |  | -5 |  |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  | -5
 |  |  | Apt: 1284-8 Total: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -5 |  |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  | -5
1302-1 |  | Kinda Normal (3350) |  |  |  |  |  | N |  | N |  |  | 127 |  | 2014-12-23 00:00:00 |  |  | Rent - |  |  |  | 299 |  |  | 197 |  | 0 |  | 0 |  |  | 0 |  |  | 496
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Damages - |  |  |  | 42.4 |  |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  | 42.4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Subsidy - Ann Arbor |  |  |  | -512 |  |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  | -512
 |  |  | Apt: 1302-1 Total: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -170.6 |  |  | 197 |  | 0 |  | 0 |  |  | 0 |  |  | 26.4
1302-2 |  | [NAME] (9649) |  |  |  |  |  | Y |  | Y |  |  | 55 |  | 2014-12-12 00:00:00 |  |  | Rent - |  |  |  | 330 |  |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  | 330
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Late Charge - |  |  |  | 25 |  |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Subsidy - WestlandHC |  |  |  | 570 |  |  | 570 |  | 0 |  | 0 |  |  | 0 |  |  | 1140
 |  |  | Apt: 1302-2 Total: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 925 |  |  | 570 |  | 0 |  | 0 |  |  | 0 |  |  | 1495
1302-4 |  | Fake Name (14728) |  |  |  |  |  | Y |  | N |  |  | 317 |  | 2015-01-05 00:00:00 |  |  | Rent - |  |  |  | -20 |  |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  | -20
 |  |  | Apt: 1302-4 Total: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -20 |  |  | 0 |  | 0 |  | 0 |  |  | 0 |  |  | -20
Report Version: 22-Dec-2011 (8.0.0) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Page 5 of 5
Spreadsheet: 733216d1621441805-match-two-cells-with-two-cells-from-range-excel-question-5-19-2021
Sheet: Sheet1

Part | Plant |  |  |  |  | Part | Plant |  | Helper
123 | ZZ45 | Function = if cell A2 & B2 match G2 & H2 or G3 & H3 or G4 & G4 etc, then return I2 (or I3 etc which ever the case is) |  |  |  | 456 | GH67
456 | GH67 |  |  |  |  | 123 | ZZ45
678 | ZZ45 |  |  |  |  | 123 | BH89
345 | BH89 |  |  |  |  | 890 | BH89
123 | BH89 |  |  |  |  | 345 | BH89
456 | ZZ45 |  |  |  |  | 678 | ZZ45
890 | BH85 |  |  |  |  | 456 | ZZ45
Spreadsheet: 212799d1360248741-conditional-formatting-for-dates-176-shooting
Sheet: WHT List

Cadet Names | .22 WHT? | Re-Test Date | L98 WHT? | Re-Test Date | L81 WHT? | Re-Test Date
 | 2012-08-09 00:00:00 |  | 2012-08-25 00:00:00 |  | 2012-08-25 00:00:00
 | 2012-10-25 00:00:00
 | 2011-09-22 00:00:00 |  | 2012-06-24 00:00:00
 | 2012-03-01 00:00:00 |  | 2012-06-24 00:00:00
 | 2012-10-16 00:00:00 |  | 2012-10-30 00:00:00 |  | 2012-09-29 00:00:00
 | 2012-10-28 00:00:00
 | 2012-03-18 00:00:00 |  | 2012-09-30 00:00:00
Spreadsheet: 150486d1334573664-look-up-and-display-elsewhere-example-sheet
Sheet: Sheet1

 | Distance | Percentage
 | 1 | 100
 | 2 | 99.5
 | 3 | 99 |  |  | Distance at 20% | HELP HERE.
 | 4 | 98.5
 | 5 | 98
 | 6 | 97.5
 | 7 | 97
 | 8 | 96.5
 | 9 | 96
 | 10 | 95.5
 | 11 | 95
 | 12 | 94.5
 | 13 | 94
 | 14 | 93.5
 | 15 | 93
 | 16 | 92.5
 | 17 | 92
 | 18 | 91.5
 | 19 | 91
 | 20 | 90.5
 | 21 | 90
 | 22 | 89.5
 | 23 | 89
 | 24 | 88.5
 | 25 | 88
 | 26 | 87.5
 | 27 | 87
 | 28 | 86.5
 | 29 | 86
 | 30 | 85.5
 | 31 | 85
 | 32 | 84.5
 | 33 | 84
 | 34 | 83.5
 | 35 | 83
 | 36 | 82.5
 | 37 | 82
 | 38 | 81.5
 | 39 | 81
 | 40 | 80.5
 | 41 | 80
 | 42 | 79.5
 | 43 | 79
 | 44 | 78.5
 | 45 | 78
 | 46 | 77.5
 | 47 | 77
 | 48 | 76.5
 | 49 | 76
 | 50 | 75.5
 | 51 | 75
 | 52 | 74.5
 | 53 | 74
 | 54 | 73.5
 | 55 | 73
 | 56 | 72.5
 | 57 | 72
 | 58 | 71.5
 | 59 | 71
 | 60 | 70.5
 | 61 | 70
 | 62 | 69.5
 | 63 | 69
 | 64 | 68.5
 | 65 | 68
 | 66 | 67.5
 | 67 | 67
 | 68 | 66.5
 | 69 | 66
 | 70 | 65.5
 | 71 | 65
 | 72 | 64.5
 | 73 | 64
 | 74 | 63.5
 | 75 | 63
 | 76 | 62.5
 | 77 | 62
 | 78 | 61.5
 | 79 | 61
 | 80 | 60.5
 | 81 | 60
 | 82 | 59.5
 | 83 | 59
 | 84 | 58.5
 | 85 | 58
 | 86 | 57.5
 | 87 | 57
 | 88 | 56.5
 | 89 | 56
 | 90 | 55.5
 | 91 | 55
 | 92 | 54.5
 | 93 | 54
 | 94 | 53.5
 | 95 | 53
 | 96 | 52.5
 | 97 | 52
 | 98 | 51.5
 | 99 | 51
 | 100 | 50.5
 | 101 | 50
 | 102 | 49.5
 | 103 | 49
 | 104 | 48.5
 | 105 | 48
 | 106 | 47.5
 | 107 | 47
 | 108 | 46.5
 | 109 | 46
 | 110 | 45.5
 | 111 | 45
 | 112 | 44.5
 | 113 | 44
 | 114 | 43.5
 | 115 | 43
 | 116 | 42.5
 | 117 | 42
 | 118 | 41.5
 | 119 | 41
 | 120 | 40.5
 | 121 | 40
 | 122 | 39.5
 | 123 | 39
 | 124 | 38.5
 | 125 | 38
 | 126 | 37.5
 | 127 | 37
 | 128 | 36.5
 | 129 | 36
 | 130 | 35.5
 | 131 | 35
 | 132 | 34.5
 | 133 | 34
 | 134 | 33.5
 | 135 | 33
 | 136 | 32.5
 | 137 | 32
 | 138 | 31.5
 | 139 | 31
 | 140 | 30.5
 | 141 | 30
 | 142 | 29.5
 | 143 | 29
 | 144 | 28.5
 | 145 | 28
 | 146 | 27.5
 | 147 | 27
 | 148 | 26.5
 | 149 | 26
 | 150 | 25.5
 | 151 | 25
 | 152 | 24.5
 | 153 | 24
 | 154 | 23.5
 | 155 | 23
 | 156 | 22.5
 | 157 | 22
 | 158 | 21.5
 | 159 | 21
 | 160 | 20.5
 | 161 | 20
 | 162 | 19.5
 | 163 | 19
 | 164 | 18.5
 | 165 | 18
 | 166 | 17.5
 | 167 | 17
 | 168 | 16.5
 | 169 | 16
 | 170 | 15.5
 | 171 | 15
 | 172 | 14.5
 | 173 | 14
 | 174 | 13.5
 | 175 | 13
 | 176 | 12.5
 | 177 | 12
 | 178 | 11.5
 | 179 | 11
 | 180 | 10.5
 | 181 | 10
 | 182 | 9.5
 | 183 | 9
 | 184 | 8.5
 | 185 | 8
 | 186 | 7.5
 | 187 | 7
 | 188 | 6.5
 | 189 | 6
 | 190 | 5.5
 | 191 | 5
 | 192 | 4.5
 | 193 | 4
 | 194 | 3.5
 | 195 | 3
 | 196 | 2.5
 | 197 | 2
 | 198 | 1.5
 | 199 | 1
 | 200 | 0.5
 | 201 | 0
 | 202 | -0.5
 | 203 | -1
 | 204 | -1.5
 | 205 | -2
 | 206 | -2.5
 | 207 | -3
 | 208 | -3.5
 | 209
 | 210
 | 211
 | 212
 | 213
 | 214
 | 215
 | 216
 | 217
 | 218
 | 219
 | 220
 | 221
Spreadsheet: 66473d1267117582-array-copy-arraycopy
Sheet: Sheet2

 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | < required
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Master Data
 | 2010-02-28 00:00:00 | 2010-03-31 00:00:00 | 2010-04-30 00:00:00 | 2010-05-31 00:00:00 | 2010-06-30 00:00:00 | 2010-07-31 00:00:00 | 2010-08-31 00:00:00 | 2010-09-30 00:00:00 | 2010-10-31 00:00:00 | 2010-11-30 00:00:00 | 2010-12-31 00:00:00 | 2011-01-31 00:00:00 | 2011-02-28 00:00:00 | 2011-03-31 00:00:00 | 2011-04-30 00:00:00 | 2011-05-31 00:00:00 | 2011-06-30 00:00:00 | 2011-07-31 00:00:00 | 2011-08-31 00:00:00 | 2011-09-30 00:00:00 | 2011-10-31 00:00:00 | 2011-11-30 00:00:00 | 2011-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
Task 1 | 2 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Task 1 | 2 | 2
Task 2 |  | 4 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Task 2 |  | 4 | 4
Task 3 |  |  |  | 5 | 5 | 5 | 5 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Task 3 |  |  |  | 5 | 5 | 5 | 5 | 5
Spreadsheet: 42577d1241110126-images-based-on-value-image_test-1-
Sheet: Sheet1

reference | image
2
4
6
3
2
4
4
3
4
3
2
4
7
4
5
6
2
3
1
3
4
5
6
7
4
3
4
3
2
4
4
3
4
3
2
4
7
4
4
3
4
3
4
3
2
4
4
3
4
3
2
4
7
4
5
6
2
3
1
4
3
4
3
2
4
4
3
4
3
2
4
7
4
5
4
3
4
3
2
4
4
3
4
3
2
4
3
4
3
2
4
4
3
4
3
2
4
7
4
5
6
2
3
1
3
4
5
6
7
3
4
5
4
3
4
3
2
4
4
3
4
3
2
4
7
4
5
6
2
3
1
3
4
3
4
3
2
4
4
3
4
3
2
4
7
4
5
6
2
3
1
3
4
5
6
7
Spreadsheet: 144250d1330850732-calendar-generator-in-excel-sample
Sheet: Sheet1

 |  |  |  |  |  | Date Range | 2012-01-29 00:00:00 | 2012-03-03 00:00:00 | Cells with [NAME] should remain in place so that they can reflect weekly and monthly performance
Date | Day | Field 1 | Field 2 | Field 3 | Field 4
2012-01-29 00:00:00 | nedjelja | 1
2012-01-30 00:00:00 | ponedjeljak |  | 2
2012-01-31 00:00:00 | utorak |  |  | 3
2012-02-01 00:00:00 | srijeda |  |  |  | 4
2012-02-02 00:00:00 | četvrtak
2012-02-03 00:00:00 | petak
2012-02-04 00:00:00 | subota
 | Week 1 | 1 | 2 | 3 | 4
2012-02-05 00:00:00 | nedjelja
2012-02-06 00:00:00 | ponedjeljak
2012-02-07 00:00:00 | utorak | 4
2012-02-08 00:00:00 | srijeda |  | 5
2012-02-09 00:00:00 | četvrtak |  |  | 6
2012-02-10 00:00:00 | petak |  |  |  | 7
2012-02-11 00:00:00 | subota
 | Week 2 | 4 | 5 | 6 | 7
2012-02-12 00:00:00 | nedjelja
2012-02-13 00:00:00 | ponedjeljak
2012-02-14 00:00:00 | utorak
2012-02-15 00:00:00 | srijeda
2012-02-16 00:00:00 | četvrtak
2012-02-17 00:00:00 | petak
2012-02-18 00:00:00 | subota
 | Week 3 | 0 | 0 | 0 | 0
2012-02-19 00:00:00 | nedjelja
2012-02-20 00:00:00 | ponedjeljak
2012-02-21 00:00:00 | utorak
2012-02-22 00:00:00 | srijeda
2012-02-23 00:00:00 | četvrtak
2012-02-24 00:00:00 | petak
2012-02-25 00:00:00 | subota
 | Week 4 | 0 | 0 | 0 | 0
Month End |  | 5 | 7 | 9 | 11
Spreadsheet: 87338d1287153049-detect-if-entries-have-duplicate-criteria-detect-duplicate-criteria-v5
Sheet: Sheet1

Item | AppGroup | OK to treat like app? |  |  | Item | AppGroup | App | [NAME] | Supported By | HIDE COLUMNS
1 | BIEM | Y | should be Y |  | 1 | BIEM | Excel | [NAME] | [NAME] | BIEMMS SupportJoe | 2
2 | Maximo | Y | should be N |  | 2 | BIEM | Word | [NAME] | [NAME] | BIEMMS SupportJoe | 2
 |  |  |  |  | 3 | Maximo | [NAME] | [NAME] | [NAME] | MaximoMS SupportJoe | 2
 |  |  |  |  | 4 | Maximo | [NAME] | [NAME] | [NAME] | MaximoMS SupportJoe | 2
 |  |  |  |  | 5 | Maximo | Alon |  | [NAME] | MaximoJane | 1