tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 491415d1480460628-populate-automatic-rota-by-date-rota-dummy
Sheet: Shift Code

Shift | Start Time | 1st Break | Lunch | 2nd Break | End Time |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
E1 | 08:00:00 | 10:00:00 | 12:00:00 | 14:00:00 | 16:00:00 |  | 8:00-16:00 | 8:00-16:00 | 8:00-16:00 | 8:00-16:00 | 8:00-16:00 | 8:00-16:00 |  | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5
E3 | 08:00:00 | 10:20:00 | 12:20:00 | 14:20:00 | 16:00:00 |  | 8:00-16:00 | 8:00-16:00 | 8:00-16:00 | 8:00-16:00 | 8:00-16:00 | 8:00-16:00 |  | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5
E3-Mon | 08:00:00 | 10:20:00 | 12:20:00 | 14:20:00 | 16:00:00 |  | 8:00-16:00 | 8:00-16:00 | 8:00-16:00 | 8:00-16:00 | 8:00-16:00 | 8:00-16:00 |  | RDO | 7.5 | 7.5 | 7.5 | 7.5 | 7.5
E3-Tue | 08:00:00 | 10:20:00 | 12:20:00 | 14:20:00 | 16:00:00 |  | 8:00-16:00 | 8:00-16:00 | 8:00-16:00 | 8:00-16:00 | 8:00-16:00 | 8:00-16:00 |  | 7.5 | RDO | 7.5 | 7.5 | 7.5 | 7.5
E3-Wed | 08:00:00 | 10:20:00 | 12:20:00 | 14:20:00 | 16:00:00 |  | 8:00-16:00 | 8:00-16:00 | 8:00-16:00 | 8:00-16:00 | 8:00-16:00 | 8:00-16:00 |  | 7.5 | 7.5 | RDO | 7.5 | 7.5 | 7.5
E3-Thu | 08:00:00 | 10:20:00 | 12:20:00 | 14:20:00 | 16:00:00 |  | 8:00-16:00 | 8:00-16:00 | 8:00-16:00 | 8:00-16:00 | 8:00-16:00 | 8:00-16:00 |  | 7.5 | 7.5 | 7.5 | RDO | 7.5 | 7.5
E3-Fri | 08:00:00 | 10:20:00 | 12:20:00 | 14:20:00 | 16:00:00 |  | 8:00-16:00 | 8:00-16:00 | 8:00-16:00 | 8:00-16:00 | 8:00-16:00 | 8:00-16:00 |  | 7.5 | 7.5 | 7.5 | 7.5 | RDO | 7.5
M1 | 10:00:00 | 12:00:00 | 14:00:00 | 16:00:00 | 18:00:00 |  | 10:00-18:00 | 10:00-18:00 | 10:00-18:00 | 10:00-18:00 | 10:00-18:00 | 10:00-18:00 |  | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5
M2 | 10:00:00 | 12:10:00 | 14:20:00 | 16:10:00 | 18:00:00 |  | 10:00-18:00 | 10:00-18:00 | 10:00-18:00 | 10:00-18:00 | 10:00-18:00 | 10:00-18:00 |  | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5
M3 | 10:00:00 | 12:20:00 | 14:40:00 | 16:20:00 | 18:00:00 |  | 10:00-18:00 | 10:00-18:00 | 10:00-18:00 | 10:00-18:00 | 10:00-18:00 | 10:00-18:00 |  | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5
M4 | 10:00:00 | 12:30:00 | 15:00:00 | 16:30:00 | 18:00:00 |  | 10:00-18:00 | 10:00-18:00 | 10:00-18:00 | 10:00-18:00 | 10:00-18:00 | 10:00-18:00 |  | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5
PT12 | 10:00:00 | ~ | ~ | ~ | 14:00:00 |  | 10:00-14:00 | 10:00-14:00 | Off | 10:00-14:00 | 10:00-14:00 | 10:00-14:00 |  | 4 | 4 | Off | 4 | 4 | 4
PT15 | 10:00:00 | ~ | 12:00:00 | ~ | 16:00:00 |  | 10:00-16:00 | Off | 10:00-16:00 | Off | 10:00-16:00 |  |  | 6 | Off | 6 | Off | 6 | 6
PT22 | 12:00:00 | ~ | ~ | ~ | 15:30:00 |  | 12:00-15:30 | 12:00-15:30 | 12:00-15:30 | 12:00-15:30 | 12:00-15:30 | 12:00-15:30 |  | 3.75 | 3.75 | 3.75 | 3.75 | 3.75 | 3.75
PT99 | 14:00:00 | ~ | ~ | ~ | 17:00:00 |  | 14:00-17:00 | 14:00-17:00 | 14:00-17:00 | 14:00-17:00 | 14:00-17:00 | 14:00-17:00 |  | 3 | 3 | 3 | 3 | 3 | 3
Spreadsheet: 837306d1690019342-filter-with-excluding-array-filter
Sheet: Feuil1

 |  |  |  |  |  |  |  | initial array |  | exclude array |  | initial with exclude |  | expected result
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 46
 | 46 |  | 48 |  |  |  |  | 46 |  | 48 |  |  |  | 47
 | 47 |  | 49 |  |  |  |  | 47 |  | 49 |  |  |  | 50
 | 48 |  |  |  |  |  |  | 48 |  |  |  |  |  | 51
 | 49 |  |  |  |  |  |  | 49 |  |  |  |  |  | 52
 | 50 |  |  |  |  |  |  | 50 |  |  |  |  |  | 53
 | 51 |  |  |  |  |  |  | 51 |  |  |  |  |  | 54
 | 52 |  |  |  |  |  |  | 52 |  |  |  |  |  | 55
 | 53 |  |  |  |  |  |  | 53 |  |  |  |  |  | 56
 | 54 |  |  |  |  |  |  | 54 |  |  |  |  |  | 57
 | 55 |  |  |  |  |  |  | 55 |  |  |  |  |  | 58
 | 56 |  |  |  |  |  |  | 56 |  |  |  |  |  | 59
 | 57 |  |  |  |  |  |  | 57 |  |  |  |  |  | 60
 | 58 |  |  |  |  |  |  | 58
 | 59 |  |  |  |  |  |  | 59
 | 60 |  |  |  |  |  |  | 60
Spreadsheet: 79cc519d-477e-4d75-985c-6bf95817d379
Sheet: SEPTEMBER

SEATTLE UNIVERSITY
NON-EXEMPT EMPLOYEE TIME REPORT
NAME: |  |  |  |  | DEPT: |  |  | (Use 4 letter-code as shown on paystub under DEPT)
Datatel ID Number or SSN:
PE: |  | 2015-09-01 00:00:00 | TO | 2015-09-30 00:00:00 |  | MO. NO.: |  | 9
Holiday Pay |  |  |  | HP | 7.5
Sick Pay |  |  |  | SP
Vacation Pay |  |  |  | VP
[NAME] |  |  |  | BR |  | (up to 5 days of paid leave)
Jury Duty Leave |  |  |  | JL
[NAME] |  |  |  | DP
 |  |  |  |  |  |  |  |  | Employee Signature |  |  |  | Date
Regular Pay |  |  |  | RP
SUB-TOTAL |  |  |  |  | 165 |  |  |  | Supervisor Signature |  |  |  | Date
Overtime (1.0 rate) |  |  |  |  |  | (If total hours worked (Sunday-Saturday) is between 37.50 and 40)
Overtime (1.5 rate) |  |  |  |  |  | (If total hours worked (Sunday-Saturday) is above 40)
TOTAL
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
 |  |  |  |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5
 |  |  |  |  | 1 |  | 2 |  | 3 |  | 4 |  | 5
 |  | HP | 7.5 |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5
 | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12
 |  |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5
 | 13 |  | 14 |  | 15 |  | 16 | Time sheets due | 17 |  | 18 |  | 19
 |  |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5
 | 20 |  | 21 |  | 22 |  | 23 |  | 24 |  | 25 |  | 26
 |  |  | 7.5 |  | 7.5 |  | 7.5
 | 27 |  | 28 |  | 29 | Pay day | 30
REMEMBER: Adjustment from Prior Month!! INCLUDE PRIOR MONTH ADJ HOURS IN THE ABOVE CALCULATION!
Spreadsheet: ea1228ba-ed1d-4d7e-9db1-f10a9abaeb9b
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7365 | 40957 | Iain | Dawson | GBR | 7 | [NAME] | 00:01:10 | [NAME] | 00:00:00 | 00:24:09 | 1 | 01:04:38
7365 | 47908 | [NAME] | Filipovic | SRB | 8 | 00:13:19 | 00:01:45 | 00:29:01 | 00:00:00 | 00:21:33 | 2 | 01:05:39
7365 | 72205 | Oren | Blitzblau B1 | ISR | 3 | 00:14:05 | 00:02:11 | 00:32:41 | 00:00:00 | [NAME] | 3 | 01:14:02
7365 | 56297 | [NAME] | Bocchi | ITA | 6 | 00:13:44 | 00:01:27 | [NAME] | 00:00:00 | 00:25:27 | 4 | 01:14:47
7365 | 17485 | Alberto | Ceriani B1 | ITA | 5 | 00:15:04 | 00:01:46 | 00:32:23 | 00:00:00 | 00:26:51 | 5 | [NAME]
7365 | 56085 | Evangelos | Barlas | GRE | 4 | 00:23:22 | 00:02:20 | 00:32:25 | 00:00:00 | 00:27:25 | 6 | 01:25:37
Spreadsheet: 0543e28b-e6a3-435d-80c0-c69d2a1d9e95
Sheet: EQ Zone and AOI Deductible

Owners Forms
USAA Group
Pennsylvania
Current, Indicated, and Proposed Earthquake Zone and Earthquake AOI / Deductible Relativities
Zone | Current | Indicated | Proposed | Change
3 | 1 | 1 | 1
4 | 0.4792 | 0.6587 | 0.5271
5 | 0.1917 | 0.4921 | 0.2109
 | Current | Indicated | Proposed | Change
Amount of Insurance | 0.1 | 0.1 | 0.1 | 0.1
10000 | 0.0616 | 0.063 | 0.063
15000 | 0.0924 | 0.0945 | 0.0945
20000 | 0.1232 | 0.126 | 0.126
30000 | 0.1848 | 0.189 | 0.189
40000 | 0.2464 | 0.252 | 0.252
50000 | 0.308 | 0.315 | 0.315
75000 | 0.462 | 0.4725 | 0.4725
100000 | 0.6281 | 0.63 | 0.63
150000 | 0.8291 | 0.848 | 0.848
200000 | 1 | 1 | 1
300000 | 1.4619 | 1.289 | 1.289
400000 | 1.8763 | 1.6088 | 1.6088
500000 | 2.3516 | 1.9498 | 1.9498
750000 | 3.6217 | 2.8269 | 2.8269
1000000 | 4.5987 | 3.6365 | 3.6365
1500000 | 7.1635 | 5.1102 | 5.1102
2000000 | 10.0634 | 6.8136 | 6.8136
each add'l $10,000, add: | 0.058 |  | 0.0341
Spreadsheet: 797363d1663844171-need-to-return-the-worker-site-based-on-a-table-with-his-working-hours-example-hd-1-
Sheet: Sheet with formula

Worker number | [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 |  |  | DE.1052
30 |  |  | DE.1052
31 |  |  | DE.1053
32 |  |  | DE.1054
33 |  |  | DE.1053
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52 |  |  | Check
53
54
55
56
57
58
59
60
61
62 |  |  | DE.1052
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158 |  |  | Check
Spreadsheet: 79926d1280179143-pulling-multiple-and-varied-of-rows-from-one-sheet-into-another-incentive-payment-report4
Sheet: Incentive Payment Summary

 | Incentive Payment Report
 | Territory Manager [NAME]: |  | [NAME]
 | TM #s | 221 | 343 | 980 | 582
 | Employee #: |  | 28830
 | Incentive Payment Summary
 |  | Total Incentive Payment | Dealer Incentive | Retail Incentive | W Incentive
 |  | 34.67 | 34.67 | 0 | 0
 |  |  | Comments
 | 0
 | Incentive Payment Details
 | Customer # | Customer Name | Sales | Territory | Cust Type | Currency
 | 100550 | EFG | 3467 | 32 | L | CD
Spreadsheet: 725250d1616598794-if-list-extract-text-before-first-comma-else-copy-value-excel-forum-question-if-list-extract-else-copy
Sheet: Sheet1

List/Single Values | New Column
Apples, Bannanas, Lemons | Apples
Rasberries | Rasberries
Cucumbers | Cucumbers
Orange, Pear, Key Lime | Orange
List/Single Values | New Column | New Column | New Column
Apples, Bannanas, Lemons | Apples | Apples | Lemons
Rasberries | Rasberries | Rasberries | Rasberries
Cucumbers | Cucumbers | Cucumbers | Cucumbers
Orange, Pear, Key Lime | Orange | Pear | Key Lime
Spreadsheet: 682262d1591982948-sum-based-on-order-number-2020-06-12-oeldere-stax67-pt-682211d1591966063-sum-based-on-order-number-in
Sheet: Sheet3

Invoice Number | Expr1 | WON | [NAME]
4420 | 100000 | 203363 | 2020-05-20 00:00:00 |  |  |  | Rijlabels | Som van Expr1
4421 | 1710 | 203398 | 2020-05-21 00:00:00 |  |  |  | 203240 | 6132
4422 | 2592.900146484375 | 203392 | 2020-05-21 00:00:00 |  |  |  | 203323 | 55898.64013671875
4423 | 1845 | 203371 | 2020-05-21 00:00:00 |  |  |  | 203358 | 7320
4424 | 55898.64013671875 | 203323 | 2020-06-03 00:00:00 |  |  |  | 203361 | 5850
4425 | 5850 | 203361 | 2020-05-27 00:00:00 |  |  |  | 203363 | 100000
4426 | 7320 | 203358 | 2020-05-27 00:00:00 |  |  |  | 203371 | 1845
4427 | 6132 | 203240 |  |  |  |  | 203392 | 2592.900146484375
 |  |  |  |  |  |  | 203398 | 1710
 |  |  |  |  |  |  | Eindtotaal | 181348.5402832031
 | TOTAL
Spreadsheet: 822988d1679633070-listing-the-winner-s-of-a-golf-skin-in-separate-cell-money-hole-formula
Sheet: Sheet2

Player | CC |  | TL |  | CR |  | SH |  |  | WINNERS OF CC
A | 5 |  |  |  | 5 |  | 5 |  |  | B | C | D | F
B
C
D
E
F
G
As you can see above, the winners for Round 1 (column B) were players B, C, D, and F because they all have a score less than a "4". I would love a formula that automatically places them under WINNERS over on the right.
Spreadsheet: 55182d1255353070-how-to-automatically-alter-formula-when-filters-are-applied-malchemist-2
Sheet: 31946

Date of Order | Date of Order | Year Of Order | Month Of Order | Item No. | Description | Quantity | [NAME] value £ | Order Number | Contract
20080225 | 2008-02-25 | 2008 | 2 | 202416 | Laser range meter PD 4 | 1 | 110 | 118949 | 31946
20080919 | 2008-09-19 | 2008 | 9 | 228195 | Battery pack B 36 2.4 NiCd | 2 | 318.6 | 118949 | 31946
20081128 | 2008-11-28 | 2008 | 11 | 272444 | Battery charger C 4/36-ACS Li TPS 230V | 1 | 101.58 | 131384 | 31946
20090121 | 2009-01-21 | 2009 | 1 | 272444 | Battery charger C 4/36-ACS Li TPS 230V | 1 | 76.6299999999999 | 132438 | 31946
20080425 | 2008-04-25 | 2008 | 4 | 272627 | Cordl. ham. dr. driver SFH 181-A 3.0 | 1 | 270.44 | 118949 | 31946
20090121 | 2009-01-21 | 2009 | 1 | 272828 | Cordl. impact screwdriver SID 144-A | 1 | 93.28 | 132438 | 31946
20090121 | 2009-01-21 | 2009 | 1 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 52.1499999999999 | 132438 | 31946
20090121 | 2009-01-21 | 2009 | 1 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 52.1499999999999 | 132438 | 31946
20080918 | 2008-09-18 | 2008 | 9 | 370101 | Battery pack SFB 185 | 2 | 179.72 | 118949 | 31946
20090427 | 2009-04-27 | 2009 | 4 | 378450 | Battery charger C 7/36-ACS 230V | 1 | 98.59 | 134794 | 31946
Spreadsheet: 193843d1352972701-selecting-a-group-of-4-numbers-from-within-a-string-of-8-by-matching-to-a-data-base-book1
Sheet: Sheet1

Item number | item | new item number |  | [NAME]
OR067342 | AGAVE DESMETTIANA VARIEGATA | 6734 |  | 06734
006375 | CAESALPINIA GILLIESII | 637 |  | 00637
GA09732PT | FERN-ATHYRIUM REGAL RED | 973 |  | 00973
003455 | JASMINUM FLORIDUM | 345 |  | 00345
CA072941 | YUCCA FIL GOLDEN SWORD | 7294 |  | 07294
Spreadsheet: 722065d1615027497-vlookup-formula-to-return-pivot-count-amount-test-2
Sheet: Master

Status | Site Name | T&A Devices
 | Bakery_Aeroton | 35
 | Bakery_Bloemfontein | 24
 | Bakery_Britos | 28
 | Bakery_Brits | 9
 | Bakery_Duens | 28
 | Bakery_Enterprise | 17
 | Bakery_Krugersdorp | 11
 | Bakery_Ladysmith | 15
 | Bakery_Mokopane | 8
 | Bakery_Nigeria_Ibadan
 | Bakery_Nigeria_Ikotan
 | Bakery_Nigeria_Oregun
 | Bakery_Olifantsfontein | 18
 | Bakery_Polokwane | 12
 | Bakery_Shakaskraal | 57
 | Bakery_Worcester | 38
 | BCX KWV Building
 | [NAME]
 | [NAME]
 | Beverages_Bloemfontein | 22
 | Beverages_Ceres | 55
 | Beverages_Ceres Water
 | Beverages_Wadeville | 58
 | [NAME] UK_Peterborough
 | Bokomo UK_Stream Foods
 | [NAME] UK_Wellingborough
 | Bread Depot_Botshabelo
Completed | Bread Depot_Durban
 | [NAME]
Completed | Bread Depot_Eshowe
 | Bread Depot_Jan Kempdorp
 | Bread Depot_Kuruman
Completed | Bread Depot_Lephalale
 | Bread Depot_Mkuze
 | Bread Depot_Mthatha
 | Bread Depot_Newcastle
 | Bread Depot_Pietermaritzburg
 | Bread Depot_Qwa [NAME] | 3
 | Bread Depot_Richards Bay
Completed | Bread Depot_Rosslyn
Completed | Bread Depot_Rustenburg
Completed | Bread Depot_Sibasa | 0
Completed | Bread Depot_Tubatse | 7
 | Bread Depot_Vryheid
 | Bread Depot_Welkom
Completed | Bread Depot_Witbank
 | Cereals_Clayville
 | Cereals_Wadeville
 | Cereals_Weetbix Atlantis | 14
 | DC_Atlantis | 8
 | DC_Bethlehem | 2
 | DC_Bloemfontein
 | DC_Ceres
 | [NAME]
 | DC_Durban | 10
 | DC_East London
 | DC_George
 | DC_Isando
 | DC_Kimberley
 | DC_Kokstad
 | DC_Port [NAME]
 | DC_Springbok
 | DC_Super Group_Cape Town
 | DC_Super Group_Jhb
 | DC_Super Group_PE
 | DC_Upington
 | DC_Vryheid
 | DC_Wadeville | 9
 | DC_White River
 | Dried Fruit_Upington
 | Dried Fruit_Worcester
 | Intake Depot_Kakamas
 | Intake Depot_Keimoes
 | Intake Depot_Vredendal
 | Mill_Aliwal North
 | Mill_Bethlehem
 | Mill_Durban
 | Mill_Estcourt
 | Mill_Klerksdorp
 | Mill_Krugersdorp
 | Mill_Malmesbury
 | Mill_Port [NAME] | 1
 | NDC
 | Pasta_Irene
 | Pasta_Malmesbury
 | Fishpaste_Saldanha
 | Savoury Foods
 | Shared Services_Rosebank
 | Shared Services_Glacier
 | Shared Services_Paarl
 | Shared Services_PFLS Malmesbury
 | Starfoods_Pietermaritzburg
 | Sugarbird_Malmesbury
 | Wellington
 | Wellington's_Atlantis | 9
Spreadsheet: 769985d1645764700-sums-of-dynamic-unique-values-with-multiple-criteria-sample-tests
Sheet: combo box

Year |  |  |  |  |  | Negative bugs | Positive bugs |  | Negative bugs | Positive bugs
Type |  |  |  |  |  | Citrobacter freundii | Group B Strep |  | Citrobacter freundii |  | Group B Strep
 |  |  |  |  |  | E. coli | MRSA |  | E. coli |  | MRSA
 |  |  |  |  |  | Enterobacter cloacae complex | MSSA |  | Enterobacter cloacae complex |  | MSSA
 |  |  |  |  |  | Klebsiella aerogenes | Staphylococcus aureus |  | Klebsiella aerogenes |  | Staphylococcus aureus
 |  |  |  |  |  | Klebsiella pneumoniae |  |  | Klebsiella pneumoniae |  | 0
 |  |  |  |  |  | Morganella morganii |  |  | Morganella morganii |  | 0
 |  |  |  |  |  | Proteus mirabilis |  |  | Proteus mirabilis |  | 0
Spreadsheet: 867853d1714640018-formula-to-zero-tables-within-kpi-spreadsheet-new-hs-kpi-updated-max-percentage-100
Sheet: H&S DS Comb

 |  |  |  |  | Friday to Thursday
 | Safety | Points avaliable | Month score | Total | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Monthly Target | Annual Target | % | Clancy Target | % Against Target
 | Major injury | -50 |  |  |  |  |  |  |  | 0 | 0
 | Lost time injury | -25 |  |  |  |  |  |  |  | 0 | 0
 | Non-lost time injury | 0 |  |  |  |  |  |  |  | 0 | 0
 | Service Strike (HV) | -20 |  |  |  |  |  |  |  | 0 | 0
 | Service Strike (LV) | -15 |  |  |  |  |  |  |  | Less than 3 | Less than 36 |  | <6
 | Service Strike (Gas) | -10 |  |  |  |  |  |  |  |  |  |  | <33
 | Service Strike (Other) | -5 |  |  |  |  |  |  |  |  |  |  | <33
 | Manager [NAME] | 0.1 |  |  |  |  |  |  |  | 10
 | Safety observations | 0.01 |  |  |  |  |  |  |  | 50
 | H&S advisor visits | 0.2 |  |  |  |  |  |  |  | 12
 | Manager/Supervisor Safety Visits | 0.01 |  |  |  |  |  |  |  | 32
 | [NAME] | 0.01 |  |  |  |  |  |  |  | 100
 | ABC Tours | 0.01 |  |  |  |  |  |  |  | 4
 | HAVS |  |  |  | 0 | 0 | 0 | 0 | 0
 | Total
Spreadsheet: 191980d1352271026-how-to-count-the-text-and-at-the-same-time-disregard-counting-those-that-repeats-help
Sheet: Sheet1

Member ID | Month
SP00002 | May |  | I want to count the number of memberID in may, diregarding those that repeat.
SP00051 | Feb
SP00052 | August
SP00053 | September
SP00054 | October
SP00055 | November
SP00056 | December
sp00058 | May
sp00058 | May
SP00057 | August
SP00060 | Feb
SP00061 | September
sp00062 | May
SP00062 | May
SP00064 | September
Spreadsheet: 142968d1330105633-excel-2007-formula-to-calculate-number-of-instances-across-12-sheets-broken-down-by-department-copy-of-observation-card
Sheet: Summary

Summary Page
This page compiles summary data based on information from the montly observation card sheets. |  |  |  |  |  |  |  |  |  |  |  |  | January
 |  |  |  |  |  |  |  |  |  |  |  |  | February
By Department: | Status |  |  |  | Potential Risk Severity |  |  |  |  |  |  |  | March
 | Safe | At-Risk | N/A |  | Serious | Minor | Minimal | Ergonomic |  |  |  |  | April
ANSIMAG |  |  |  |  |  |  |  |  |  |  |  |  | May
Calibration Lab |  |  |  |  |  |  |  |  |  |  |  |  | June
Gear & Shaft |  |  |  |  |  |  |  |  |  |  |  |  | July
Gearbox |  |  |  |  |  |  |  |  |  |  |  |  | August
HMP Unit Build and Test |  |  |  |  |  |  |  |  |  |  |  |  | September
Impeller-Inducer |  |  |  |  |  |  |  |  |  |  |  |  | October
LMV-LMC Unit Build and Test |  |  |  |  |  |  |  |  |  |  |  |  | November
[NAME] Dock |  |  |  |  |  |  |  |  |  |  |  |  | December
Maintenance Mechanical Areas
[NAME]
Overhaul & Repair
Paint & Ship
Pinnacle Unit Build and Test
R&D
Small Lot
SRPWH
Stockroom-Receiving
Sunflo
Wet End
By Month: | Status |  |  |  | Potential Risk Severity
 | Safe | At-Risk | N/A |  | Serious | Minor | Minimal | Ergonomic
January
February
March
April
May
June
July
August
September
October
November
December
Spreadsheet: 774462d1648488600-grouping-items-under-one-heading-example-tactrix-
Sheet: Pivot Table

Project Description | Action Items | Deadline | Urgency | Status
Project 2 | Task 1 | 15-Mar | HIGH | Complete
 | Task 2 | 28-Mar | HIGH | Complete
 | Task 3 | 3-Apr | LOW | In Progress
 | Task 4 | 3-Apr | HIGH | Complete
Project 1 | Task 1 | 7-Apr | LOW | In Progress
 | Task 2 | 9-Apr | MILD | To Do
 | Task 3 | 15-Apr | LOW | In Progress
Project 3 | Task 1 | 25-Mar | MILD | Complete
 | Task 2 | 17-May | LOW | To Do
 | Task 3 | 20-Jun | LOW | To Do
Grand Total
Spreadsheet: 864799d1711948868-from-static-to-dynamic-cell-reference-via-indirect-function-raw-materials-record
Sheet: Provichem2202

Raw Material |  | Provichem2202
Date | Description | Batch Processed Quantity |  | Quantity Stored ([NAME]'s) | Quantity Issued ([NAME]'s) | Total Quantity Remaining ([NAME]'s) | Bilty or Batch (Description)
 |  | Qty | [NAME]'s
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
2023-09-30 00:00:00 |  |  |  |  |  | 270
2023-11-21 00:00:00 |  |  |  |  | 18
2023-11-22 00:00:00 |  |  |  |  | 27
2023-11-23 00:00:00 |  |  |  |  | 27
2023-11-23 00:00:00 |  |  |  |  | 27
2023-11-24 00:00:00 |  |  |  |  | 27
2023-11-24 00:00:00 |  |  |  |  | 27
2023-11-24 00:00:00 |  |  |  |  | 18
2023-11-25 00:00:00 |  |  |  |  | 27
2023-11-25 00:00:00 |  |  |  |  | 27
2024-01-08 00:00:00 |  |  |  |  | 27
2024-01-09 00:00:00 |  |  |  |  | 18
Total
Spreadsheet: 877431d1724261168-return-same-value-in-one-sheet-to-another-sheet-but-also-not-return-a-value-if-none-exists-return-value-etaf
Sheet: M Sheet

ID # | Category | Group | Description | Internal External | Thing | Stuff | Other
 |  |  | Part #1
 |  |  | Entry #2
 |  |  | Document #3
 |  |  | ARGH
Spreadsheet: 868451d1715182843-make-makearray-work-to-spill-multiple-criteria-spill-multiple-criteria
Sheet: Sheet1

single occurence
 |  |  |  |  | drag down | spill
1 | [NAME] |  |  | 3
2 | [NAME] |  |  | 1 |  | [NAME]
3 | Glove |  |  | 2 |  | [NAME]
4 | Helmet
multiple occurence
 |  |  |  |  |  | spill in one cell
1 | [NAME]
2 | [NAME] |  |  | 1 |  | [NAME]
3 | Glove |  |  | 2 |  | [NAME]
4 | Helmet
3 | Jacket
multiple occurence
 |  |  |  |  | drag down |  |  | spill in multiple cells
 | [NAME] |  |  |  |  | Jacket
2 | [NAME] |  |  | 1 |  | Hat
3 | Glove |  |  | 2 |  | Boot
4 | Helmet
3 | Jacket |  |  |  |  | #N/A
2 | Boot |  |  |  | #N/A | #N/A |  | How would such MAKEARRAY formula look like that spills correctly?
1 | Hat |  |  |  | #N/A | #N/A
Spreadsheet: 66411d1267063620-looking-up-values-excel-forum-lookup-values-
Sheet: Sheet2

 | Name | B | W10 | W20 | W30
 | 0
61 | [NAME] | 1a
67 | [NAME] | 2c
61 | [NAME] | 1a
67 | [NAME] | 2c
55 | [NAME] | 1b
61 | [NAME] | 1a
79 | [NAME] | 2a
61 | [NAME] | 1a
67 | [NAME] | 2c
61 | [NAME] | 1a
67 | [NAME] | 2c
#N/A | [NAME]
67 | [NAME] | 2c
79 | [NAME] | 2a
61 | [NAME] | 1a
#N/A | [NAME]
#N/A | [NAME]
67 | [NAME] | 2c
55 | [NAME] | 1b
67 | Megan Mason | 2c
#N/A | [NAME]
73 | [NAME] | 2b
49 | [NAME] | 1c
61 | [NAME] | 1a
61 | [NAME] | 1a
67 | [NAME] | 2c
55 | [NAME] | 1b
#N/A | [NAME]
#N/A | [NAME]
#N/A | zzz zzz
#N/A | zzz zzz
#N/A | zzz zzz
#N/A | zzz zzz
#N/A | zzz zzz
Spreadsheet: 73185d1273832280-basic-search-function-help-needed-please-findall-hiliteandlist-
Sheet: Customer_Information

txt1stName
alistair
[NAME]
mark
luke
mathew
tom | [NAME]
alistair
[NAME]
mark
luke
mathew
tom
alistair
[NAME]
mark
luke
mathew
tom | wilson
alistair
[NAME]
mark
luke
mathew
tom
alistair
[NAME]
mark
luke
mathew
tom | MacKay
alistair
[NAME]
mark
luke
mathew
tom
Spreadsheet: f2661372-1fd8-40f6-a20b-e092e4412f4b
Sheet: Risk Assessment

Subrecipient Name: |  |  |  |  |  | Date:
Prime Sponsor: |  |  |  |  |  | Grant and Contracts Officer:
Subaward #: |  |  |  |  |  | Risk Level Assigned:
Instructions to GCO:  Assign an assessment rating (0, 1 or 2) for each Criteria listed below.
Criteria |  | Lower Risk | Higher Risk |  | Weight | Assessment 0 = low 1 = med 2 = high | Weighted Score
Foreign or Domestic |  | Domestic | Foreign |  | 4
Maturity of Subrecipient's Organization |  | Mature | Start-up |  | 4
Organization Type |  | University or non-profit | Industry |  | 4
Award type |  | Grant | Contract or Subcontract |  | 4
Amount of Subgrant/Subcontract |  | Total cost is <$499,999 | Total cost is >$500K |  | 3
Percentage of Prime Award Subcontracted |  | Total cost is <48.9% | Tot cost is >49% |  | 2
Accounting Systems Established |  | Yes | No |  | 2
Procurement Systems |  | approved | Not approved / ad hoc |  | 2
Negotiated Indirect Cost Rate Agreement |  | Yes | No |  | 2
Audit Report |  | A-133 | No Audit Report |  | 2
Prior experience working with Uniersity? |  | Previous positive experience | New Subrecipient, or previous negative experience |  | 2
ITAR/EAR Type of work |  | No | Yes |  | 2
Compliance (humans, animals, stem cells) |  | No | Yes |  | 2
Location of Work |  | At subrecipient's facility | International |  | 2
Sponsor Type |  | Private or Foundation or Other University | Government Owned & Contractor Operated |  | 3
Relationship of subrecipient to PI and potential for conflict of interest |  | No existing or former relationship to PI | PI's relative |  | 1
SOW & Deliverables |  | Report only | Tangible products; pivotal to success of project |  | 4
"Advantaged" status claimed? |  | Not small business, HUB zone, etc. | Yes |  | 1
Special Considerations: up to an additional 8 points; e.g. high $
Low = 0-40 |  | Bumped to Next Level? Yes____ or  No____  (check one)
Medium = 41-75 |  |  |  |  |  | Total Risk Score:
High = 76-99
Nuclear = 100
NOTE: If Cost Share for sub, then higher risk rate.