tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 873772d1720341191-how-to-find-total-of-working-hours-from-a-single-cell-kvemperor-working-hours-shop-aligw
Sheet: july

[NAME] | 31 |  |  | ΡΕΠΟ
ΞΕΚΙΝΑΕΙ | 2024-07-01 00:00:00
ΒΗΜΑ | 1
 | ΙΟΥΛΙΟΣ |  | [NAME] ΡΑΦΑΕΛΑ | KROSHKINA MARIA | ΒΛΑΧΟΥ ΠΑΝΑΓΙΩΤΑ | ΚΑΛΛΟΥ ΓΕΩΡΓΙΑ | ΚΟΝΙΣΣΗ ΒΑΣΙΛΙΚΗ | ΟΙΚΟΝΟΜΟΥ ΒΑΡΒΑΡΑ | ΒΛΑΤΑΚΗΣ ΚΥΡΙΑΚΟΣ | ΚΟΝΙΣΣΗ ΙΟΥΛΙΑΝΗ |  |  | [NAME] ΡΑΦΑΕΛΑ | KROSHKINA MARIA | ΒΛΑΧΟΥ ΠΑΝΑΓΙΩΤΑ | ΚΑΛΛΟΥ ΓΕΩΡΓΙΑ | ΚΟΝΙΣΣΗ ΒΑΣΙΛΙΚΗ | ΟΙΚΟΝΟΜΟΥ ΒΑΡΒΑΡΑ | ΒΛΑΤΑΚΗΣ ΚΥΡΙΑΚΟΣ | ΚΟΝΙΣΣΗ ΙΟΥΛΙΑΝΗ
 |  | 11:00-22:00 |  | 09:00-17:00 | 11:00-17:00 | 16:00-22:00 | 09:00-22:00 | 17:00-22:00 | 09:00-22:00 | 15-00-21:00
 | 2024-07-02 00:00:00 | 09:30-22:00 |  | 09:00-17:00 | 11:00-17:00 | 16:00-22:00 | 09:00-22:00 | 17:00-22:00 | 09:00-13:00  &  17:00-22:00 | 16-00-21:00
 | 2024-07-03 00:00:00 | 09:30-22:00 |  | 09:00-17:00 | 11:00-17:00 | 16:00-22:00 | 09:00-22:00 | 17:00-22:00 | 09:00-13:00  &  17:00-22:00 | 16-00-21:00
 | 2024-07-04 00:00:00 | ΟΡΘΟΠΑΙΔΙΚΟΣ |  | 09:00-17:00 | 11:00-17:00 | 16:00-22:00 | 09:00-22:00 | 17:00-22:00 | 09:00-13:00  &  17:00-22:00 | 16-00-21:00
 | 2024-07-05 00:00:00 | ΔΕΝ ΗΡΘΕ |  | 09:00-17:00 | 11:00-17:00 | 16:00-22:01 | 09:00-22:00 | 17:00-22:00 | 09:00-13:00  &  17:00-22:00 | 16-00-21:00
 | 2024-07-06 00:00:00 | ΔΕΝ ΗΡΘΕ |  | 09:00-17:00 | 11:00-17:00 | ΡΕΠΟ | 09:00-22:00 | 17:00-22:00 | 09:00-22:00 | 16-00-21:00
 | 2024-07-07 00:00:00 | ΔΕΝ ΗΡΘΕ |  | ΡΕΠΟ | ΡΕΠΟ | 10:00-18:00 | 10:00-18:00 | ΡΕΠΟ | 10:00-18:00 | ΡΕΠΟ
 | 2024-07-08 00:00:00
 | 2024-07-09 00:00:00
 | 2024-07-10 00:00:00
 | 2024-07-11 00:00:00
 | 2024-07-12 00:00:00
 | 2024-07-13 00:00:00
 | 2024-07-14 00:00:00
 | 2024-07-15 00:00:00
 | 2024-07-16 00:00:00
 | 2024-07-17 00:00:00
 | 2024-07-18 00:00:00
 | 2024-07-19 00:00:00
 | 2024-07-20 00:00:00
 | 2024-07-21 00:00:00
 | 2024-07-22 00:00:00
 | 2024-07-23 00:00:00
 | 2024-07-24 00:00:00
 | 2024-07-25 00:00:00
 | 2024-07-26 00:00:00
 | 2024-07-27 00:00:00
 | 2024-07-28 00:00:00
 | 2024-07-29 00:00:00
 | 2024-07-30 00:00:00
 | 2024-07-31 00:00:00
Spreadsheet: 754804d1636512281-using-sumif-with-an-or-or-else-trades-template-
Sheet: RESULTS 2

 |  |  |  |  |  |  |  |  |  |  |  |  | `
 | 2021-NOV | WIN % | POINTS (NET) |  |  |  | 2021-DEC | WIN % | POINTS (NET) |  |  |  | 2021-DEC | WIN % | POINTS (NET)
 | MON | TUES | WED | THUR | FRI |  | MON | TUES | WED | THUR | FRI |  | MON | TUES | WED | THUR | FRI
 | 1 | 2 | 3 | 4 | 5 |  |  |  | 1 | 2 | 3 |  |  |  | 1 | 2 | 3
 | 8 | 9 | 10 | 11 | 12 |  | 6 | 7 | 8 | 9 | 10 |  | 6 | 7 | 8 | 9 | 10
 | 15 | 16 | 17 | 18 | 19 |  | 13 | 14 | 15 | 16 | 17 |  | 13 | 14 | 15 | 16 | 17
 | 22 | 23 | 24 | 25 | 26 |  | 20 | 21 | 22 | 23 | 24 |  | 20 | 21 | 22 | 23 | 24
 |  |  |  | HOLIDAY |  |  |  |  |  | HOLIDAY |  |  |  |  |  | HOLIDAY
 | 29 | 30 |  |  |  |  | 27 | 28 | 29 | 30 | 31 |  | 27 | 28 | 29 | 30 | 31
Spreadsheet: 722887d1615452956-return-our-products-in-the-bottom-20-of-range-excel-help
Sheet: SKU list

 | Product | Those which we supply | Bottom 20%
 | A
 | B | x
 | C
 | D | x
 | E | x
 | F | x
 | G
 | H
 | I
 | J | x
 | K
 | L | x
 | M
 | N | x
 | O | x
 | P
 | Products in the bottom 20% that we supply
 | O
Spreadsheet: 852123d1702218024-calculating-movement-between-stages-for-loans-helpstages-1-1-
Sheet: Sheet1

Starting point |  |  |  |  |  | Needed end result
name | stage | loan value | date |  |  | stage 1 to 2 | stage 1 to 3 | stage 2 to 2 (stays the same)
A | 1 | 55 | 2000-01-31 00:00:00 |  |  |  |  |  |  |  | I need sum of all the numbers that meet each above criteria
B | 1 | 150 | 2000-01-31 00:00:00 |  |  |  | 490 | 60 |  |  | PPP and QQQ should not be added to any sum
C | 2 | 70 | 2000-01-31 00:00:00
D | 1 | 200 | 2000-01-31 00:00:00
E | 1 | 500 | 2000-01-31 00:00:00
PPP | 2 | 150 | 2000-01-31 00:00:00
A | 2 | 50 | 2000-02-28 00:00:00
B | 3 | 140 | 2000-02-28 00:00:00
C | 2 | 60 | 2000-02-28 00:00:00
D | 2 | 190 | 2000-02-28 00:00:00
E | 3 | 350 | 2000-02-28 00:00:00
QQQ | 3 | 70 | 2000-02-28 00:00:00
Spreadsheet: 57784d1258001654-apply-names-model-example
Sheet: CAPACITIES (USER)

Projection Capacities - Data Entry in Yellow
 | Projection (User)
LODGEMENT CAPACITIES
Max Total Lodgements | 2
Max Total Lodgements (Based on Budgeted CSO Staffing)
TRIAL CAPACITIES
[NAME] | 1
[NAME] of Courtrooms Avaliable | 1
Max Trials Listed (Based on Projected Overlist and Court Capacity)
Max Trials Listed (Based on Budgeted Judicial and Court Capacity)
Max Trials Heard (Based on Court Capacity)
STAFF CAPACITIES
Number of Judges Required Per Courtroom Per Year (AFTE) | 0.01
Min Client Services Officers (AFTE) | 0.01
Min Registry Clerks (AFTE) | 0.01
[NAME] Annual Trial Lodgements Per 1.0 FTE - CSO's | 1
[NAME] Annual Non Trial Lodgements Per 1.0 FTE - CSO's | 1
[NAME] Annual Trial Lodgements Per 1.0 FTE - Registry Clerks | 1
[NAME] Annual Non Trial Lodgements Per 1.0 FTE - Registry Clerks | 1
[NAME] Annual Trial Listings Per 1.0 FTE - Registry Clerks | 1
Spreadsheet: 674458d1587852984-reset-cell-based-on-other-cell-contents-pto-test
Sheet: Sheet1

Employee | PTO Total | PTO Used | PTO Remaining | Hire date | Years worked | Annual PTO earned | Is Anniversary? |  |  | Year | PTO
Employee1 |  | 0 |  | 2019-07-19 00:00:00 |  |  |  |  |  | 1 | 24
Employee2 |  | 0 |  | 2019-09-22 00:00:00 |  |  |  |  |  | 2 | 36
Employee3 |  | 38 |  | 2017-02-14 00:00:00 |  |  |  |  |  | 3 | 48
Employee4 |  | 34 |  | 2015-07-17 00:00:00 |  |  |  |  |  | 4 | 50
Employee5 |  | 0 |  | 2019-07-12 00:00:00 |  |  |  |  |  | 5 | 52
Employee6 |  | 0 |  | 2019-10-18 00:00:00 |  |  |  |  |  | 6 | 56
Employee7 |  | 0 |  | 2019-08-08 00:00:00 |  |  |  |  |  | 7 | 64
Employee8 |  | 0 |  | 2019-10-15 00:00:00 |  |  |  |  |  | 8 | 72
Employee9 |  | 0 |  | 2020-04-03 00:00:00 |  |  |  |  |  | 9 | 80
Employee10 |  | 0 |  | 2019-04-25 00:00:00
Employee11 |  | 17 |  | 2002-08-05 00:00:00
Employee12 |  | 0 |  | 2019-04-26 00:00:00
Spreadsheet: 190263d1351599531-looking-for-same-number-but-different-prefix-and-add-cell-contents-zeszyt1
Sheet: Zeszyt1

whole no | stat | prefix | no
A7116 | 12 | A | 7116
R2076 | 5 | R | 2076
A2076 | 10 | A | 2076
R2068 | 4 | R | 2068
A2068 | 5 | A | 2068
[NAME] | 29 | R | 2056
A2056 | 5 | A | 2056
[NAME] | 11 | R | 2056
A2056 | 2 | A | 2056
Spreadsheet: 275336d1383466034-countif-help-countif-help
Sheet: Sheet1

N1 | N2 | N3 | N4 | BN | RANGE | Last draw | count
5 | 11 | 27 | 39 | 9 | 1 | 21 | COUNTIF(A2:E?,F2)
9 | 12 | 26 | 38 | 11 | 2 | 17
7 | 12 | 25 | 39 | 3 | 3 | 10
1 | 17 | 26 | 36 | 5 | 4 | 19
8 | 11 | 24 | 33 | 1 | 5 | 22
10 | 20 | 28 | 32 | 13 | 6 | 21
4 | 18 | 24 | 33 | 11 | 7 | 18
10 | 13 | 22 | 39 | 13 | 8 | 22
3 | 11 | 26 | 32 | 12 | 9 | 24
9 | 18 | 26 | 38 | 5 | 10 | 23
2 | 13 | 23 | 33 | 14 | 11 | 8
4 | 13 | 22 | 37 | 7 | 12 | 16
4 | 11 | 25 | 32 | 13 | 13 | 14
1 | 14 | 23 | 37 | 7 | 14 | 24
1 | 12 | 30 | 39 | 12 | 15 | 20
2 | 19 | 21 | 32 | 14 | 16 | 24 |  |  | Numbers 1 - 39 in A2:E24
7 | 16 | 29 | 32 | 9 | 17 | 23 |  |  | Number range in F2:F40
6 | 18 | 26 | 35 | 4 | 18 | 19 |  |  | Last draw - last time number came out in range A2:E24
10 | 15 | 27 | 34 | 10 | 19 | 17 |  |  | COUNTIF - range A2:E? - Last part has to point to the cell which has "Last draw" number
1 | 16 | 22 | 32 | 6 | 20 | 22 |  |  | So as count H2 would be something like COUNTIF(A2:E(G2),F2)
5 | 20 | 23 | 37 | 8 | 21 | 17
2 | 17 | 26 | 37 | 10 | 22 | 21
9 | 16 | 23 | 36 | 14 | 23 | 24
 |  |  |  |  | 24 | 8
 |  |  |  |  | 25 | 14
 |  |  |  |  | 26 | 23
 |  |  |  |  | 27 | 20
 |  |  |  |  | 28 | 7
 |  |  |  |  | 29 | 18
 |  |  |  |  | 30 | 16
 |  |  |  |  | 31 | 0
 |  |  |  |  | 32 | 21
 |  |  |  |  | 33 | 12
 |  |  |  |  | 34 | 20
 |  |  |  |  | 35 | 19
 |  |  |  |  | 36 | 24
 |  |  |  |  | 37 | 23
 |  |  |  |  | 38 | 11
 |  |  |  |  | 39 | 16
Spreadsheet: 84624d1284654313-graph-for-three-product-with-data-over-24-hrs-745942
Sheet: Sheet4

Sum of Data | Column Labels
Row Labels | A-0 | B-1 | C-2 | Grand Total
00:00:00 | 779.4 | 2273.57 | 712.87 | 3765.84
01:00:00 | 1079.37 | 558.51 | 725.24 | 2363.12
02:00:00 | 1001.71 | 1168.35 | 393.64 | 2563.7
03:00:00 | 31.82 | 1635.77 | 5.43 | 1673.02
04:00:00 | 27.17 | 934.85 | 5.51 | 967.53
05:00:00 | 69.21 | 782.41 | 8.08 | 859.7
06:00:00 | 35.32 | 830.28 | 5.49 | 871.09
07:00:00 | 2.13 | 906.96 | 5.31 | 914.4
08:00:00 | 2.13 | 18.44 | 2045.17 | 2065.74
09:00:00 | 2.15 | 707.09 | 583.89 | 1293.13
10:00:00 | 2.14 | 490.28 | 1264.71 | 1757.13
11:00:00 | 2.14 | 748.94 | 1448.96 | 2200.04
12:00:00 | 2.16 | 183.5 | 751.49 | 937.15
13:00:00 | 2.16 | 14.02 | 2310.77 | 2326.95
14:00:00 | 2.14 | 665.36 | 333.76 | 1001.26
15:00:00 | 2.15 | 448.78 | 3.06 | 453.99
16:00:00 | 2.14 | 1530.81 | 3.06 | 1536.01
17:00:00 | 3.63 | 1101.97 | 4.95 | 1110.55
18:00:00 | 848.37 | 925.07 | 472.6 | 2246.04
19:00:00 | 562.58 | 510.52 | 1777.29 | 2850.39
20:00:00 | 236.69 | 2099.62 | 1367.41 | 3703.72
21:00:00 | 36.61 | 1211.94 | 751.72 | 2000.27
22:00:00 | 40.87 | 3288.5 | 494.18 | 3823.55
23:00:00 | 37.7 | 2123.76 | 714.18 | 2875.64
Grand Total | 4811.889999999999 | 25159.3 | 16188.77 | 46159.96000000001
Spreadsheet: 694241d1599473960-condensing-down-like-items-in-a-material-list-2020-09-05-oeldere2-fenster-694033d1599311575-condensing-down-like-items-in-a-material-list-e
Sheet: example

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | These rows are over multiple sheets |  |  |  |  |  |  |  |  | this is combined on one sheet but would like all like items to be condensed before the final list on a separate sheet |  |  |  |  |  |  |  | FINAL LIST pulls all rows with [NAME] (but I want it with the like items combined shown in the section below starting on row 30)
 |  |  |  | data validation list | data validation list | data validation list |  |  |  | Intermediate list |  |  |  |  |  |  |  | IFERROR(INDEX(K$6:K$16,SMALL(IF($L$6:$L$16>$T$2,ROW($K$6:$K$16)-ROW($K$6)+1),ROWS($K$6:$K7))),"")
 |  |  |  |  |  |  |  |  |  | Item | Qty | Size | Color | Material Type |  |  |  | Item | Qty | Size | Color | Material Type
 |  | Top Bolt | 51 | 1-3/4" | black | Stainless Steel
 |  | [NAME] | 61 | 1" | black | Alloy Steel
 |  | Middle Bolt | 4 | 1-1/2" | red | Stainless Steel
 |  | Right Bolt | 12 | 2" | red | Zinc Plated
 |  | Left Bolt | 0 | 1" | green | Alloy Steel
 |  | Outside Bolt | 18 | 1-3/4" | black | Stainless Steel
 |  | Inside Bolt1 | 1 | 1" | green | Stainless Steel
 |  | Inside Bolt2 | 4 | 1" | red | Stainless Steel
 |  | Inside Bolt3 | 31 | 1" | green | Stainless Steel
 |  | Inside Bolt4 | 4 | 1" | green | Stainless Steel
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Item | Qty | Size | Color | Material Type
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Top Bolt | 51 | 1-3/4" | black | Stainless Steel | combined with other black
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 61 | 1" | black | Alloy Steel
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Middle Bolt | 4 | 1-1/2" | red | Stainless Steel | combined with other red
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Right Bolt | 12 | 2" | red | Zinc Plated
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Outside Bolt | 18 | 1-3/4" | black | Stainless Steel
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Inside Bolt1 | 1 | 1" | green | Stainless Steel | combined with other green
 |  | Undermount Bolt1 | 16 | 1-1/2" | red | Stainless Steel |  |  |  |  |  |  |  |  |  |  |  | Inside Bolt2 | 4 | 1" | red | Stainless Steel
 |  | Undermount Bolt2 | 8 | 1" | silver | Stainless Steel |  |  |  |  |  |  |  |  |  |  |  | Inside Bolt3 | 31 | 1" | green | Stainless Steel
 |  | Undermount Bolt3 | 4 | 1" | silver | Stainless Steel |  |  |  |  |  |  |  |  |  |  |  | Inside Bolt4 | 4 | 1" | green | Stainless Steel
 |  | Undermount Bolt4 | 16 | 1" | silver | Stainless Steel |  |  |  |  |  |  |  |  |  |  |  | Undermount Bolt1 | 16 | 1-1/2" | red | Stainless Steel
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Undermount Bolt2 | 8 | 1" | silver | Stainless Steel | combine with other blue
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Undermount Bolt3 | 4 | 1" | silver | Stainless Steel
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Undermount Bolt4 | 16 | 1" | silver | Stainless Steel
Spreadsheet: 720857d1614329095-look-up-value-in-linear-list-based-on-two-criteria-sample
Sheet: Sheet1

DATA SET 1
 | power | size | connections | temperature
Product 1 | 20W | 100x100 | 1" | 40°C
Product 2 | 30W | 200x200 | 2" | 40°C
Product 3 | 40W | 300x300 | 3" | 40°C
product 4 | 50W | 400x400 | 4" | 40°C
Product | Product 1 | <-----THIS IS A LIST OF PRODUCTS FROM THE ABOVE TABLE A4:A7
Power |  | <-----THIS INFORMATION IS CURRENTLY PICKED FROM DATA SET 1 (ABOVE) WITH VLOOKUP
Size
Conns.
Temp.
Capacity | 2 | <------CAPACITY B16 IS WHERE A FIGURE IS INPUTTED  BASED ON THIS AND THE PRODUCT SELECTED IN B11 THE RESPECIVE NEAREST LOSS IS PICKED FROM THE DATA SET 2 BELOW TABLE A21:I27
Loss
DATA SET 2
product 1 |  | product 2 |  | product 3 |  | product 4
Capacity | Loss | Capacity | Loss | Capacity | Loss | Capacity | Loss
1 | 0.5 | 2 | 1 | 1 | 2 | 3 | 4
2 | 1.5 | 4 | 3 | 3 | 4 | 6 | 8
3 | 2.5 | 6 | 5 | 5 | 6 | 9 | 12
4 | 3.5 | 8 | 7 | 7 | 8 | 12 | 16
5 | 4.5 | 10 | 9 | 9 | 10 | 15 | 20
Spreadsheet: 858289d1707021148-in-order-from-the-largest-with-a-combination-of-cells-with-the-same-last-name-copy-of-zeszyt1-robert
Sheet: Arkusz1

 | name | amount |  |  | name | amount
 | Beata | 2350 |  |  | [NAME]
 | [NAME] | 6000 |  |  | Renata
 | Agata | 1300 |  |  | [NAME] |  |  |  | Row Labels | Sum of amount
 | Renata | 9300 |  |  | Andrzej |  |  |  | Agata | 1300
 | [NAME] | 5000 |  |  | Beata |  |  |  | Andrzej | 3400
 | Andrzej | 3400 |  |  | Agata |  |  |  | Baltazar | 1000
 | Baltazar | 1000 |  |  | Baltazar |  |  |  | Beata | 2350
 | [NAME] | 2000 |  |  | Dorota |  |  |  | Dorota | 1000
 | [NAME] | 4500 |  |  |  |  |  |  | [NAME] | 10500
 | Dorota | 1000 |  |  |  |  |  |  | [NAME] | 7000
 |  |  |  |  |  |  |  |  | Renata | 9300
 |  |  |  |  |  |  |  |  | Grand Total | 35850
Spreadsheet: 268273d1380543052-a-dynamic-table-given-a-set-of-creteria-this-is-a-tricky-one-rank-top-10
Sheet: Sheet1

value | Top ten
Spreadsheet: 3e80dd57-3f84-49ac-af85-1a38cf60b55e
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
MTBVC | Test | MTBVC | Mtb Susp Confirm Single Antimicrobial | Mtb Susp Confirm Single Antimicrobi |  |  |  |  |  |  |  |  | Specimens other than	NA Anticoagulants other than	NA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA |  | Monday through Sunday; Varies | 21-30 days | 30 days | 1 | 87190 |  |  |  |  | Rochester
MTBVC | [NAME] | VARIES | Varies |  |  |  | See instructions
Spreadsheet: 274066d1382997751-creating-a-comma-seperated-list-based-on-a-search-criteria-from-a-column-example-workbook-for-excel-csv-list
Sheet: Sheet1

SKU1 WH S
SKU1 WH M
SKU1 WH L
SKU1 WH XL
SKU1 WH XXL
[NAME]
SKU1 BK M
SKU1 BK L
SKU1 BK XL
SKU1 BK XXL
[NAME]
SKU2 WH M
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME] L
[NAME]
[NAME]
SKU3 WH S
SKU3 WH M
SKU3 WH L
SKU3 WH XL
SKU3 WH XXL
[NAME] S
SKU3 BK M
[NAME] L
[NAME] XL
[NAME] XXL
SKU1 | this cell needs to contain a comma seperated list of the sku's contained in column A prefixed SKU1
SKU2 | this cell needs to contain a comma seperated list of the sku's contained in column A prefixed SKU2
SKU3 | this cell needs to contain a comma seperated list of the sku's contained in column A prefixed SKU3
Spreadsheet: 718255d1613060316-lookup-month-in-col-a-and-if-col-h-on-same-sheet-x-display-x-otherwise-blank-staff-changes-by-month-example
Sheet: StaffChanges

Month | DATE | OFFICE | EE NAME | Position | Supervisor | ADD | TRANS | TERM
Jan | 2021-01-30 00:00:00 | Ofc 1 | [NAME] | CSR | Green |  |  | X
Jan | 2021-01-30 00:00:00 | Ofc 1 | [NAME] | CSR | Smith |  | X
Jan | 2021-01-30 00:00:00 | Ofc 1 | [NAME] | CSR | [NAME] |  | X
Jan | 2021-01-30 00:00:00 | Ofc 2 | [NAME] | CSR | [NAME] |  | X
Feb | 2021-02-04 00:00:00 | Ofc 2 | [NAME] | Sales | Green |  |  | X
Feb | 2021-02-19 00:00:00 | Ofc 1 | [NAME] | Sales | [NAME] |  |  | X
Feb | 2021-02-10 00:00:00 | Ofc 1 | Tori | Sales | Jones |  |  | X
Spreadsheet: 862970d1710520917-function-to-find-value-if-index-row-overlaps-formula-to-find-new-values
Sheet: Sheet1

Index | 1 | 2 | 3 | 4 | 5 | 6 | Total
A | 0 | 100 | 100 | 300 | 500 | 0
B | 0 | 100 | 100 | 100 | 100 | 100
A | 200 | 200 | 200 | 0 | 0 | 0
C | 0 | 0 | 0 | 10 | 23 | 7
A | 300 | 100 | 500 | 1000 | 10 | 8
c | 100 | 0 | 100 | 0 | 100 | 0
B | 200 | 200 | 0 | 0 | 0 | 2
X | 0 | 10 | 100 | 1000 | 10 | 20
B | 200 | 200 | 200 | 0 | 0 | 0
A | 200 | 200 | 200 | 0 | 0 | 0
A
B
A
C
A
c
B
X
B
A
 |  |  |  |  |  |  |  | Equal 100% Each
 |  |  |  |  |  |  | A
 |  |  |  |  |  |  | B
 |  |  |  |  |  |  | C
 |  |  |  |  |  |  | X
Spreadsheet: 57691295-2c8c-4fb6-8ae4-22e160938c01
Sheet: Triassic

 |  |  |  |  | This chart provides a rough estimate of the SFR Loading Rate Group for soils that formed in residuum weathered from bedrock of Triassic Basin origin. This table should not be used to determine the SFR Loading Rate Group. Actual assignment to a SFR Loading Rate Group for each 15A NCAC 02T .0600 permit application shall be determined by the geometric mean of in-situ saturated hydraulic conductivity data collected in the most restrictive horizon for each soil mapping unit.
Triassic Basin Soils
(DO NOT USE THIS CHART TO ASSIGN SFR LOADING RATE GROUP)
 |  | Particle-size Control Section | Drainage Class / Water Table Depth / Type
~SFR Group |  |  |  | Depth to Rock | Subsoil Hue | Shrink-swell
 | Name |  |  |  |  |  | Classification
A | Granville | fine-loamy | W/>60" | >60" | 7.5YR-2.5Y | Low | Fine-loamy, siliceous, semiactive, thermic Typic Hapludults
A(B) | Exway | fine | W/>60" | 20-40" Cr | 10R-2.5YR | Moderate | Fine, mixed, semiactive, thermic Typic Rhodudults
A(B) | Mayodan | fine | W/>60" | >60" | 2.5YR-7.5YR | Moderate | Fine, mixed, semiactive, thermic Typic Hapludults
A(B) | Pinoka | fine-loamy | W/>6' | 20-40" Cr | 2.5YR-10YR | Low | Fine-loamy, mixed, subactive, thermic Typic Hapludults
A(B) | Wadesboro | fine | W/>60" | 40-60" Cr | 10R-2.5YR | Moderate | Fine, mixed, semiactive, thermic Typic Rhodudults
B | [NAME] | fine | W/3.0-6.0' P | >60" | 10R-7.5YR | Moderate | Fine, mixed, semiactive, thermic Typic Hapludults
B(C) | Claycreek | fine-silty | [NAME] P | >60" | 7.5YR-2.5Y | Low | Fine-silty, siliceous, semiactive, thermic [NAME]
B(C) | Hallison | fine-silty | W-MW/2.5-4.0' P | 40-60" Cr | 5YR-10YR | Low | Fine-silty, mixed, semiactive, thermic Typic Hapludults
B(C) | Mooshaunee | fine-silty | [NAME] P | 20-40" Cr | 5YR-10YR | Low | Fine-silty, mixed, semiactive, thermic Aquic Hapludults
C | Brickhaven | fine | [NAME] P | 40-60" Cr | 2.5YR-10YR | Moderate | Fine, mixed, semiactive, thermic [NAME]
C | Carbonton | fine | MW/1.0-2.0' P | 20-40" Cr | 5YR-10YR | Moderate | Fine, mixed, semiactive, thermic [NAME]
C | Creedmoor | fine | MW-SP/1.0-2.0' P | >60" | 7.5YR-2.5Y | High | Fine, mixed, semiactive, thermic Aquic Hapludults
C(D) | Green Level | fine | SP/1.0-2.5' P | >60" | 2.5YR-10YR | Very High | Fine, mixed, active, thermic Vertic Hapludults
C(D) | Polkton | fine | [NAME] P | 20-40" Cr | 2.5YR-10YR | Very High | Fine, mixed, active, thermic Oxyaquic Vertic Hapludalfs
C(D) | White Store | fine | MW/1.0-1.5' P | 40-60" Cr | 2.5YR-10YR | Very High | Fine, mixed, active, thermic Oxyaquic Vertic Hapludalfs
Spreadsheet: 110329d1307029701-create-a-table-pivottable
Sheet: Sheet1

A | 1 |  |  |  | Row Labels | Sum
A | 5 |  |  |  | A | 17
A | 12 |  |  |  | B | 120
B | 15 |  |  |  | C | 101
B | 100 |  |  |  | D | 51
B | 5 |  |  |  | Grand Total | 289
C | 1
C | 100
D | 51
Spreadsheet: 831563d1685717165-search-for-duplicate-return-value-in-the-cell-to-the-left-of-the-oldest-duplicate-book
Sheet: Test Review

Ticket Number | Paid Total | Date Added To Posting | Date Posted | Days To Post | Additional Notes
15648552 | 200 | 2022-12-12 00:00:00 | 2023-10-20 00:00:00
34737 | 180 |  | 2023-10-20 00:00:00
437347 | 21 |  | 2023-10-20 00:00:00
7345734 | 555 |  | 2023-10-20 00:00:00
733485789 | 84 |  | 2023-10-20 00:00:00
67957809 | 8791 |  | 2023-10-20 00:00:00
9045672456 | 311 |  | 2023-10-20 00:00:00
2136235 | 88 |  | 2023-10-20 00:00:00
Spreadsheet: 809558d1671149791-attendance-tracker-pto-tracker-ex-1-
Sheet: January

 | Employee PTO
 | Dayoff Type |  | Holiday |  |  | X | PTO |  |  | N | NOT-APPROVED
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enter month:
 |  | Dates of Absence |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | Employee Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | Total Days
 | Total absences of the day:
 | Lead absences:
 | Team member absences:
Spreadsheet: 801230d1666126700-i-want-count-of-dates-for-specific-category-new-microsoft-excel-worksheet
Sheet: Sheet1

Name | Category | Dates
[NAME] | A | 15 | 14
Rose | A | 19
[NAME] | B | 13 | 10 | 9 | 12
[NAME] | C | 11 | 18
[NAME] | D | 19
 |  |  |  |  |  |  |  | Category | Count
 |  |  |  |  |  |  |  | A | Here I want Count of Dates for All "A", like here count of dates for A is = 3 (C2+D2+C3)
 |  |  |  |  |  |  |  | B | Here I want 4
 |  |  |  |  |  |  |  | C | 2
 |  |  |  |  |  |  |  | D | 1
Spreadsheet: paul_y'barbo__28495__Fuel Consumption Est 01-04-20
Sheet: Sheet1

 |  |  |  |  |  | Assumptions Regarding "Days of Normal Operation"
 |  |  |  |  |  | 76% Dispatch |  | 76% Dispatch |  | 86% Dispatch |  | 86% Dispatch
 |  |  |  |  |  | 95% Availability |  | 90% Availability |  | 95% Availability |  | 90% Availability
Inventory @ end of day:       (net of heel)
 | April 17, 2001* |  |  |  |  |  | [NAME]'s |  | [NAME]'s |  | [NAME]'s |  | [NAME]'s
Balance of Deliveries Available:
 | 6 Standard Cargoes
Total LNG Available for Apr 18 - Dec 31:
LNG Consumption for Balance of Year:
258 | days (Apr 18 - Dec 31)
30 | Days for CT1 Outage @ 42,000 mmbtu/d
3 | Days for Full Outage @ 0 mmbtu/d |  |  |  |  | 0 |  | 0 |  | 0 |  | 0
 | Days of Normal Operation
 |  |  | Total Consumption
Standard Cargoes Diverted in Addition to March Diversion
1 | Cargo
Inventory @ end of day:       (net of heel)
 | December 31, 2001 |  |  |  |  |  | [NAME]'s |  | [NAME]'s |  | [NAME]'s |  | [NAME]'s
 | *Assumes tank heel of 210,000 [NAME]