tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 222811d1363954631-data-label-assistance-sample-resourcing
Sheet: PM

MONTH | 2013 Actual - RFA | 2013 Actual - EHP | 2013 Actual - EHSQ | 2013 Actual - WHP | Total Days Available | Percentage Usage
December |  |  |  |  | 22
November |  |  |  |  | 21
October |  |  |  |  | 23
September |  |  |  |  | 21
August |  |  |  |  | 22
July |  |  |  |  | 23
June |  |  |  |  | 20
May |  |  |  |  | 23
April |  |  |  |  | 22
March |  |  |  |  | 21
February | 28 | 17 | 11 |  | 25
January | 36.5 | 39 | 18 | 0.5 | 55
MONTH | 2013 Forecast - RFA | 2013 Forecast - EHP | 2013 Forecast - EHSQ | 2013 Forecast - WHP | Total Days Available | Percentage Usage
December |  | 35 | 20 |  | 22
November |  | 35 | 20 |  | 21
October | 20 | 35 | 20 |  | 23
September | 20 | 35 | 20 |  | 21
August | 20 | 35 | 20 |  | 22
July | 20 | 40 | 20 |  | 23
June | 20 | 40 |  |  | 20
May | 20 | 40 |  |  | 23
April | 20 | 35 |  |  | 22
March | 10 | 37 |  |  | 21
February |  |  |  |  | 25
January |  |  |  |  | 54.81
MONTH | 2013 Combined - RFA | 2013 Combined - EHP | 2013 Combined - EHSQ | 2013 Combined - WHP | Total Days Available | Percentage Usage
December |  |  |  |  | 22
November |  |  |  |  | 21
October |  |  |  |  | 23
September |  |  |  |  | 21
August |  |  |  |  | 22
July |  |  |  |  | 23
June |  |  |  |  | 20
May |  |  |  |  | 23
April |  |  |  |  | 22
March |  |  |  |  | 21
February |  |  |  |  | 25
January |  |  |  |  | 54.81
Spreadsheet: 80020d1280256604-index-lowest-value-minus-match-value-example
Sheet: Sheet1

Item # | Monthly Usage | Current Vendor | ABC | JKL | XYZ | Lowest Cost Vendor | Potential Monthly Savings vs Current
46799 | 114 | ABC | 17 | 19 | 12
15494 | 76 | XYZ | 9 | 12 | 6
74128 | 476 | ABC | 17 | 17 | 18
76697 | 57 | JKL | 9 | 20 | 11
71247 | 32 | ABC | 7 | 20 | 18
73330 | 118 | JKL | 13 | 17 | 11
57624 | 461 | XYZ | 12 | 17 | 11
Spreadsheet: darrell_schoolcraft__7321__imball0202
Sheet: Amarillo

Amarillo Natural Gas |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
contract 21534
 | poi 28786 |  | poi 56993 |  | poi 500170 |  | poi 10746 |  | poi 13247 |  | poi 500520 |  | poi 500171
 | Adobe [NAME] |  | [NAME] |  | ANG-Scott/Bandy II |  | [NAME] |  | [NAME] |  | [NAME] |  | ANG O Neal&Shadid
 | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | -2376 | -2100 |  | -25
2 | -2273 | -2100 |  | -25
3 | -2269 | -2100 |  | -25
4 | -2236 | -2100 |  | -25
5 | -2299 | -2100 |  | -25
6 | -2010 | -2100 |  | -25
7 | -2194 | -2100 |  | -25
8 | -2162 | -2100 | -1 | -25
9 | -2326 | -2100 |  | -25
10 | -2395 | -2100 |  | -25
11 | -1176 | -2100 |  | -25
12 | -2617 | -2100 | -9 | -25
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
index
2002-01-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89767.28
2002-02-12 00:00:00
CBS Volume
 |  |  | 37041
Spreadsheet: 820497d1678129290-sumifs-function-gives-0-as-result-excel-work
Sheet: Employees

ID number | Name and surname | Gender | Building | Sector | Salary
6 | Sandra Nedić | Ženski | Zgrada 1 | HR | 440
46 | [NAME] | Ženski | [NAME] | HR | 890
47 | [NAME] | Ženski | [NAME] | HR | 456
48 | Draguna Nedić | Ženski | [NAME] | HR | 567
5 | [NAME] | Muški | Zgrada 1 | IT | 480
40 | Boban Ivanović | Muški | [NAME] | IT | 980
41 | [NAME] | Muški | [NAME] | IT | 658
42 | Božidar Ivanović | Muški | [NAME] | IT | 790
43 | [NAME] | Muški | [NAME] | IT | 865
44 | [NAME] | Muški | [NAME] | IT | 754
45 | [NAME] | Muški | [NAME] | IT | 654
7 | Danijela Stanković | Ženski | Zgrada 1 | Komercijalista | 370
49 | Milovan Nedić | Muški | [NAME] | Komercijalista | 675
50 | Predrag Nedić | Muški | [NAME] | Komercijalista | 654
4 | [NAME] | Muški | Zgrada 1 | Logistika | 600
31 | [NAME] | Ženski | [NAME] | Logistika | 456
32 | [NAME] | Muški | [NAME] | Logistika | 654
33 | Milovan Sekulović | Muški | [NAME] | Logistika | 647
34 | [NAME] | Muški | [NAME] | Logistika | 456
35 | Marina Vujović | Ženski | [NAME] | Logistika | 345
36 | Ognjen Simonović | Muški | [NAME] | Logistika | 675
37 | [NAME] | Muški | [NAME] | Logistika | 456
38 | [NAME] | Ženski | [NAME] | Logistika | 689
39 | Nataša Pelević | Ženski | [NAME] | Logistika | 890
2 | [NAME] | Ženski | Zgrada 1 | Pravna služba | 400
17 | Slađana Đapić | Ženski | Zgrada 1 | Pravna služba | 350
18 | Radmila Berkhout | Ženski | Zgrada 1 | Pravna služba | 280
19 | [NAME] | Ženski | Zgrada 1 | Pravna služba | 210
20 | [NAME] | Muški | Zgrada 1 | Pravna služba | 345
21 | Marica Nedić | Ženski | Zgrada 1 | Pravna služba | 480
22 | [NAME] | Muški | Zgrada 1 | Pravna služba | 615
23 | [NAME] | Ženski | Zgrada 1 | Pravna služba | 345
3 | [NAME] | Ženski | Zgrada 1 | Projektovanje | 350
24 | Nebojša Nedić | Muški | Zgrada 1 | Projektovanje | 456
25 | Željko Popović | Muški | Zgrada 1 | Projektovanje | 234
26 | [NAME] | Muški | Zgrada 1 | Projektovanje | 234
27 | [NAME] | Muški | Zgrada 1 | Projektovanje | 532
28 | Darijan Stanimirović | Muški | Zgrada 1 | Projektovanje | 345
29 | Vesna Babić | Ženski | Zgrada 1 | Projektovanje | 234
30 | [NAME] | Ženski | Zgrada 1 | Projektovanje | 554
1 | Marina Jovanović | Ženski | Zgrada 1 | Računovodstvo | 682
8 | [NAME] | Ženski | Zgrada 1 | Računovodstvo | 520
9 | Andrej Nedić | Muški | Zgrada 1 | Računovodstvo | 400
10 | [NAME] | Muški | Zgrada 1 | Računovodstvo | 380
11 | [NAME] | Ženski | Zgrada 1 | Računovodstvo | 470
12 | [NAME] | Muški | Zgrada 1 | Računovodstvo | 330
13 | [NAME] | Ženski | Zgrada 1 | Računovodstvo | 270
14 | Ana Bojičić | Ženski | Zgrada 1 | Računovodstvo | 560
15 | [NAME] | Muški | Zgrada 1 | Računovodstvo | 490
16 | Iva Nedić | Ženski | Zgrada 1 | Računovodstvo | 420
Spreadsheet: 670218d1585788904-subtotal-question-stock-spreadsheet-stock-price-cumulative
Sheet: Sheet1

Stock | Shares | Price | Total |  | Stock | Price/Share
MSFT | 1000 | 100 |  |  | MSFT
MSFT | 10 | 200 |  |  | APPL
APPL | 120 | 210
MSFT | 30 | 120
APPL | 30 | 200
MSFT | 23 | 95
Total
Spreadsheet: 741765d1627319571-using-letters-to-calculate-in-a-cell-mwr-log-1-
Sheet: OCT

Date | Where | Start | End | Time | V | Milage | MPG | GALS | Reason | Expense | [NAME] CODE | To - From | Milage | Address | Vehicle | MPG
 |  |  |  |  |  |  |  |  |  |  | A | Home - ARK | 18 | 7001 [NAME] | T - Truck | 13
 |  |  |  |  |  |  |  |  |  |  | B | Home - MWR | 27.7 | 3901-3913 Arkabutla Dam Rd | J - Jeep | 16
 |  |  |  |  |  |  |  |  |  |  | C | Home - Debbie | 5.4 | 9180 Bethal Rd | C - Car | 21
 |  |  |  |  |  |  |  |  |  |  | D | Home - Stephanie | 11 | 3997 [NAME]
 |  |  |  |  |  |  |  |  |  |  | E | Home - Valery | 17 | 9865 Green River Rd.
 |  |  |  |  |  |  |  |  |  |  | F | Home - HD | 3.6 | 7740 Craft - Goodman Rd
 |  |  |  |  |  |  |  |  |  |  | G | ARK - MWR | 10
 |  |  |  |  |  |  |  |  |  |  | H | ARK - Debbie | 20
 |  |  |  |  |  |  |  |  |  |  | I | ARK - Stephanie | 12
 |  |  |  |  |  |  |  |  |  |  | J | ARK - Valery | 5.3
 |  |  |  |  |  |  |  |  |  |  | K | MWR - Debbie | 31
 |  |  |  |  |  |  |  |  |  |  | M | MWR - Stephanie | 12
 |  |  |  |  |  |  |  |  |  |  | N | MWR - Valery | 11
 |  |  |  |  |  |  |  |  |  |  | O | HD - Debbie | 6.9
 |  |  |  |  |  |  |  |  |  |  | P | HD - Stephanie | 23
 |  |  |  |  |  |  |  |  |  |  | Q | HD - ARK | 26
 |  |  |  |  |  |  |  |  |  |  | R | HD - MWR | 36
 |  |  |  |  |  |  |  |  |  |  | S | Debbie - Stephanie | 13
 |  |  |  |  |  |  |  |  |  |  | T | Debbie - Valery | 22
 |  |  |  |  |  |  |  |  |  |  | U | Stephanie - Valery | 18
Spreadsheet: 464702d1465285227-adding-multiple-times-in-the-same-column-example
Sheet: Sheet1

 |  |  | W/E | Monday | Start | End | Total Hrs | Tuesday | Start | End | Total | Total Worked
 |  | Jan | 15th | 4:30-5:20 | 16:30:00 | 17:20:00 |  | 4:30-5:20 | 16:30:00 | 17:20:00
 |  |  | 22nd | 4:30-5:20 | 16:30:00 | 17:20:00 |  | 4:30-5:20 | 16:30:00 | 17:20:00
 |  |  | 29th | 4:30-5:20 | 16:30:00 | 17:20:00 |  | 4:30-5:20 | 16:30:00 | 17:20:00
 |  | Feb | 5th | 4:30-5:20 | 16:30:00 | 17:20:00 |  | 4:30-5:20 | 16:30:00 | 17:20:00
 |  |  | 12th | - | - | - | - | - | - | -
 |  |  | 19th | - | - | - | - | - | - | - |  |  |  |  |  | Wednesday | 07:24:00 |  | Wednesday
 |  |  | 26th | 4:30-5:20 | 16:30:00 | 17:20:00 |  | 4:30-5:20 | 16:30:00 | 17:20:00 |  |  |  |  |  | Thursday | 07:24:00 |  | Thursday
 |  | March | 4th | 4:30-5:20 | 16:30:00 | 17:20:00 |  | 4:30-5:20 | 16:30:00 | 17:20:00 |  |  |  |  |  |  |  |  | Wed + Thurs
 |  |  | 11th | 4:30-5:20 | 16:30:00 | 17:20:00 |  | - | - | -
 |  |  | 18th | 4:30-5:20 | 16:30:00 | 17:20:00 |  | 4:30-5:20 | 16:30:00 | 17:20:00
 |  |  | 25th | 4:30-5:20 | 16:30:00 | 17:20:00 |  | - |  | -
 |  | April | 1st | - | - | - | - | - | - | -
 |  |  | 8th | 4:30-5:20 | 16:30:00 | 17:20:00 |  | 4:30-5:20 | 16:30:00 | 17:20:00
 |  |  | 15th | 4:30-5:20 | 16:30:00 | 17:20:00 |  | - |  |  |  |  |  |  |  |  |  |  | Enter Days Used: | 2
 |  |  | 22nd | 4:30-5:20 | 16:30:00 | 17:20:00 |  | 4:30 - 5:00 | 16:30:00 | 17:00:00 |  |  |  |  |  | [NAME]
 |  |  | 29th | - | - | - | - | - | - | - |  |  |  |  |  | Time Dec
 |  | May | 6th | 4:30-5:20 | 16:30:00 | 17:20:00 |  | 4:30 - 5:00 | 16:30:00 | 17:00:00 |  |  |  |  |  | Working Day | 07:24:00
 |  |  | 13th | 4:30-5:20 | 16:30:00 | 17:20:00 |  | 4:30 - 5:00 | 16:30:00 | 17:00:00 |  |  |  |  |  | Work Dec
 |  |  | 20th | 4:30-5:20 | 16:30:00 | 17:20:00 |  | 4:30 - 5:00 | 16:30:00 | 17:00:00 |  |  | Wed | Thurs |  | Lieu Days
 |  |  | 27th | 4:30-5:20 | 16:30:00 | 17:20:00 |  | 4:30-5:20 | 16:30:00 | 17:20:00 |  |  | 1 |  |  | Days Left
 |  | June | 3rd | 4:30-5:20 | 16:30:00 | 17:20:00 |  | 4:30-5:20 | 16:30:00 | 17:30:00 |  |  | 1
 |  |  | 10th | 5:00-5:30 | 17:00:00 | 17:30:00 |  | 4:30-5:21 | 16:30:00 | 17:30:00 |  |  | 1 | 1
Spreadsheet: 793286d1661392467-sum-across-multiple-sheets-dsc-order-summary
Sheet: Tables

[NAME]
ANZAC Biscuits
[NAME]
Hamburger (10 HHD)
Crumbed Fish Burger w/Dill Mayo
[NAME]
[NAME] with Satled Caramel Sauce
[NAME]
Steamed chicken buns
Sticky Chicken Wings with spicy sweet potato wedges and Coleslaw
[NAME] with Chantilly Cream
Souvlaki with homemade flatbreads
Sticky Chicken Wings with spicy sweet potato wedges and avocado dip
[NAME]
bacon and cheese croquettes with sour cream dipping sauce
Small Meat pies
Minced [NAME]
[NAME] with fruit salsa
[NAME] Cheesecakes
Calzone
Calzone OMA Fri class
Buttermilk pancakes
Pumpkin [NAME] and [NAME]
[NAME]
[NAME] with Lemon curd
[NAME] and White Chocolate Cookies
[NAME] with Coconut pancakes
[NAME] with Macadamia and Wattleseed Tuilles
Pear and [NAME] with [NAME]
[NAME]
Spreadsheet: 40019d1238312391-excel-2007-deleting-duplicated-numbers-from-an-entire-column-deletecellsmatchinglist
Sheet: Sheet1

POSITION NUMBER | NEW POSITION NUMBER WITH DUPLICATE FROM COLUMN A
1 | 1
9 | 2
21 | 3
30 | 4
39 | 5
49 | 6
64 | 7
77 | 8
92 | 9
107 | 10
109 | 11
113 | 12
117 | 13
121 | 14
126 | 15
129 | 16
133 | 17
137 | 18
141 | 19
146 | 20
151 | 21
157 | 22
163 | 23
169 | 24
175 | 25
181 | 26
188 | 27
195 | 28
202 | 29
207 | 30
212 | 31
217 | 32
222 | 33
227 | 34
233 | 35
240 | 36
247 | 37
255 | 38
260 | 39
265 | 40
270 | 41
275 | 42
280 | 43
285 | 44
290 | 45
296 | 46
301 | 47
303 | 48
305 | 49
307 | 50
311 | 51
314 | 52
318 | 53
321 | 54
326 | 55
330 | 56
333 | 57
336 | 58
340 | 59
344 | 60
347 | 61
351 | 62
355 | 63
359 | 64
362 | 65
365 | 66
368 | 67
373 | 68
376 | 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
 | 159
 | 160
 | 161
 | 162
 | 163
 | 164
 | 165
 | 166
 | 167
 | 168
 | 169
 | 170
 | 171
 | 172
 | 173
 | 174
 | 175
 | 176
 | 177
 | 178
 | 179
 | 180
 | 181
 | 182
 | 183
 | 184
 | 185
 | 186
 | 187
 | 188
 | 189
 | 190
 | 191
 | 192
 | 193
 | 194
 | 195
 | 196
 | 197
 | 198
 | 199
 | 200
 | 201
 | 202
 | 203
 | 204
 | 205
 | 206
 | 207
 | 208
 | 209
 | 210
 | 211
 | 212
 | 213
 | 214
 | 215
 | 216
 | 217
 | 218
 | 219
 | 220
 | 221
 | 222
 | 223
 | 224
 | 225
 | 226
 | 227
 | 228
 | 229
 | 230
 | 231
 | 232
 | 233
 | 234
 | 235
 | 236
 | 237
 | 238
 | 239
 | 240
 | 241
 | 242
 | 243
 | 244
 | 245
 | 246
 | 247
 | 248
 | 249
 | 250
 | 251
 | 252
 | 253
 | 254
 | 255
 | 256
 | 257
 | 258
 | 259
 | 260
 | 261
 | 262
 | 263
 | 264
 | 265
 | 266
 | 267
 | 268
 | 269
 | 270
 | 271
 | 272
 | 273
 | 274
 | 275
 | 276
 | 277
 | 278
 | 279
 | 280
 | 281
 | 282
 | 283
 | 284
 | 285
 | 286
 | 287
 | 288
 | 289
 | 290
 | 291
 | 292
 | 293
 | 294
 | 295
 | 296
 | 297
 | 298
 | 299
 | 300
 | 301
 | 302
 | 303
 | 304
 | 305
 | 306
 | 307
 | 308
 | 309
 | 310
 | 311
 | 312
 | 313
 | 314
 | 315
 | 316
 | 317
 | 318
 | 319
 | 320
 | 321
 | 322
 | 323
 | 324
 | 325
 | 326
 | 327
 | 328
 | 329
 | 330
 | 331
 | 332
 | 333
 | 334
 | 335
 | 336
 | 337
 | 338
 | 339
 | 340
 | 341
 | 342
 | 343
 | 344
 | 345
 | 346
 | 347
 | 348
 | 349
 | 350
 | 351
 | 352
 | 353
 | 354
 | 355
 | 356
 | 357
 | 358
 | 359
 | 360
 | 361
 | 362
 | 363
 | 364
 | 365
 | 366
 | 367
 | 368
 | 369
 | 370
 | 371
 | 372
 | 373
 | 374
 | 375
 | 376
 | 377
 | 378
Spreadsheet: 889201d1739938689-conditional-formatting-help-example-file
Sheet: Sheet1

BRAND | TOTAL NET COST VARIANCE | ABSOLUTE UNIT [NAME] | ABSOLUTE $ [NAME] | UNITS SOLD | COST OF SALES | ABSOLUTE RESULT | NET RESULT |  | BRAND
A | 241.5 | 444 | 5719.240000000009 | 5782 | 75349.33000000002 | 0.07590299741218678 | 0.00320507163102844 |  | A | Less 0.50%
A | 464.67 | 529 | 11754.15000000001 | 9279 | 136191.99 | 0.08630573648274037 | 0.00341187466311345 |  | B | Less 2.00%
A | 179.2 | 221 | 10059.00000000001 | 2240 | 50888.70000000001 | 0.1976666725618851 | 0.00352141045065015 |  | C | Less 1.50%
C | 514.034015000136 | 196 | 1572.092275 | 14794 | 145880.23 | 0.01077659580739624 | 0.00352367154205978
C | 284.91 | 355 | 11294.29 | 3285 | 67036.45000000001 | 0.1684798344781086 | 0.00425007589154855
C | 1438.8 | 2357 | 40218.09999999995 | 21344 | 293441.19 | 0.137056764253171 | 0.00490319712784698
A | 1030.01 | 1003 | 14802.07000000002 | 15262 | 190155.35 | 0.07784198551342374 | 0.00541667641746604
A | 338.3 | 579 | 10380.84000000002 | 4444 | 60182.17000000001 | 0.1724902907289654 | 0.00562126623217474
A | 1322.77 | 1362 | 20311.17000000002 | 15398 | 222926.86 | 0.09111136271331331 | 0.00593365016669592
A | 899.97 | 376 | 4811.49 | 5642 | 80966.47999999998 | 0.05942570308107752 | 0.011115340570567
C | 970.49 | 393 | 6081.170000000006 | 6263 | 83617.04999999999 | 0.07272643557743316 | 0.0116063649698237
B | 1187.04 | 390 | 12132.75999999999 | 4754 | 100563.19 | 0.1206481218425946 | 0.0118039214945349
C | 788.604629 | 252 | 5243.475668999999 | 4079 | 64643.35 | 0.08111392229827195 | 0.0121993156140577
B | 948.21 | 214 | 6431.470000000004 | 3514 | 68268.05000000002 | 0.09420907730629485 | 0.0138895134693315
C | 1436.84 | 457 | 8552.060000000016 | 7203 | 95389.16000000002 | 0.08965442194899309 | 0.0150629274856808
C | 3503.67816500005 | 846 | 5277.022964999998 | 19301 | 137995.64 | 0.03824050502610081 | 0.0253897743798286
B | 2104.81 | 383 | 6049.690000000004 | 4907 | 74577.81999999999 | 0.0811191584843859 | 0.0282230024959164
A | 2166.46 | 281 | 7675.980000000001 | 5150 | 71367.81 | 0.1075552129174204 | 0.0303562628585633
A | 4697.24 | 1036 | 23609.36000000002 | 9510 | 142989.02 | 0.1651130974951784 | 0.032850354523725
C | 2798.29850999994 | 622 | 4849.394909999997 | 10240 | 73294.32 | 0.06616331129069751 | 0.0381789272347426
A | 5557.2 | 2712 | 56717.43999999992 | 5179 | 84154.62000000001 | 0.6739670382921331 | 0.0660355902028908
Spreadsheet: 789986d1659464566-populate-last-or-max-date-from-one-sheet-to-cell-column-in-another-sheet-2022-08-02-oeldere-ncat-cycle-count
Sheet: Count History

Help | Bin | Date Counted
 | A01A | 2022-01-07 00:00:00
 | A01A | 2022-03-06 00:00:00
 | A01A | 2022-05-09 00:00:00
 | A01A | 2022-07-07 00:00:00
 | A01B | 2022-01-10 00:00:00
 | A01B | 2022-04-07 00:00:00
 | A01B | 2022-07-29 00:00:00
Spreadsheet: 684464d1593377893-how-to-randomly-return-a-cell-value-based-on-a-criteria-sample-suji01-
Sheet: Updates

Code | ID
A1 | 1
A2 | 1
A3 | 1
A4 | 1
A5 | 1
A6 | 1
A7 | 1
A8 | 1
A9 | 1
W1 | 2
L1 | 2
Spreadsheet: 808189d1670339631-showing-blank-cell-when-result-is-00-00-calcolo-ore-copy
Sheet: Calcolo Ore NO SALARIO

 |  | Data | Giorno | Inizio | Fine | Straordinario | Totale
 |  | 2022-11-02 00:00:00
 |  | 2022-11-03 00:00:00
 |  | 2022-11-04 00:00:00
 |  | 2022-11-05 00:00:00
 |  | 2022-11-06 00:00:00
 |  | 2022-11-07 00:00:00
 |  | 2022-11-08 00:00:00
 |  | 2022-11-09 00:00:00
 |  | 2022-11-10 00:00:00
 |  | 2022-11-11 00:00:00
 |  | 2022-11-12 00:00:00
 |  | 2022-11-13 00:00:00
 |  | 2022-11-14 00:00:00
 |  | 2022-11-15 00:00:00
 |  | 2022-11-16 00:00:00
 |  | 2022-11-17 00:00:00
 |  | 2022-11-18 00:00:00
 |  | 2022-11-19 00:00:00
 |  | 2022-11-20 00:00:00
 |  | 2022-11-21 00:00:00
 |  | 2022-11-22 00:00:00
 |  | 2022-11-23 00:00:00
 |  | 2022-11-24 00:00:00
 |  | 2022-11-25 00:00:00
 |  | 2022-11-26 00:00:00
 |  | 2022-11-27 00:00:00
 |  | 2022-11-28 00:00:00
 |  | 2022-11-29 00:00:00
 |  | 2022-11-30 00:00:00
 |  | SubTotale Straordinario + Ore
Spreadsheet: 142899d1330080989-excel-2007-automating-a-datedif-formula-or-another-that-would-make-my-life-easier-datedif-2
Sheet: Sheet1

Machine number | Date
1 | 2011-06-10 00:00:00
1 | 2011-06-22 00:00:00
1 | 2011-06-23 00:00:00
2 | 2011-06-24 00:00:00
3 | 2011-06-25 00:00:00
3 | 2011-06-26 00:00:00
5 | 2011-06-27 00:00:00
6 | 2011-06-28 00:00:00
8 | 2011-06-29 00:00:00
9 | 2011-06-30 00:00:00
8 | 2011-07-01 00:00:00
9 | 2011-07-02 00:00:00
8 | 2011-07-03 00:00:00
2 | 2011-07-04 00:00:00
Spreadsheet: 237581d1369251929-populating-one-worksheet-with-data-from-aother-worksheet-based-on-criteria-vlookup
Sheet: Company Data

Name | Emails | Phone Number | Department | Manager
Davy Crockett | [EMAIL] | [PHONE] | IT | [NAME]
[NAME] | [EMAIL] | [PHONE] | Materials | [NAME]
[NAME] | [EMAIL] | [PHONE] | HR | [NAME]
[NAME] | [EMAIL] | [PHONE] | Production | [NAME]
[NAME] | [EMAIL] | [PHONE] | HR | [NAME]
[NAME] | [EMAIL] | [PHONE] | Production | [NAME]
Spreadsheet: 07d8cd1d-8ef4-423a-8127-9f67021e35a2
Sheet: Sheet1

Projects | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Appointments/Project Blocks | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16
Satus | ABCD | Name |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday
Notes/Calls |  |  |  | Daily Tasks
 |  |  |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday
Spreadsheet: 184802d1349377897-highlight-cells-that-are-common-among-several-columns-test_highlight_common_cells
Sheet: Sheet1

32 | 3 | 211 | 45
3 | 45 | 3 | 32
45 | 21 | 32 | 1
76 | 32 | 9 | 9
101 | 17 | 45 | 7
Spreadsheet: 3d19932b-b7a3-427e-92da-3e411afd1b1b
Sheet: HASL

Headworks Addendum for Sludge Loadings (HASL) worksheet
 | POTW Name =>
 | POTW NPDES # => |  |  |  |  |  |  |  |  |  | MAHL_sv = | (Q_potw * C_inf * 8.34) / ( %_adj ) lbs/day
 | POTW Sludge Permit # =>
 | Date => |  |  |  |  |  |  |  |  |  | Q_potw = | Average POTW flow (mgd)
 | POTW Average Flow => |  | mgd |  |  |  |  |  |  |  | C_inf = | Average influent concentration (mgd)
 | [NAME] flow to Disposal => |  | mgd |  |  |  |  |  |  |  | %_adj = | Per percentage of Sludge Limit as decimal
 | Average % Solids to Disposal => |  | % |  |  |  |  |  |  |  |  | (example: enter 117% as 1.17)
 | Sludge Site Area permitted => |  | acres |  |  |  |  |  |  |  | 8.34 = | Conversion Factor
POLLUTANT | CUMULATIVE SLUDGE LOADING LIMITS | Enter actual CUMULATIVE LOADING data from most recent [NAME] for the most heavily loaded field1 | % of Cumulative Limit | Flag if Greater than 80% |  |  | Enter actual MAXIMUM SLUDGE CONC. from most recent [NAME] or LTMP Data | % of Applicable Ceiling Conc. Limit | Flag if > 80% of Applicable Ceiling Conc. Limit | Flag if > 100% of the Limit |  | Enter Average POTW [NAME]. | Calculate MAHL_sv based on % of Monthly Average Concentration Limits to Protect Sludge Quality (insert these values into HWA)
 | lbs/acre | lbs/acre |  |  |  | mg/dry kg | mg/dry kg | % | Flag | Flag |  | mg/l | lbs/day
Arsenic | 36
Cadmium | 34
Chromium
Copper | 1338
Lead | 267
Mercury | 15
Molybdenum |  |  |  |  |  | 75
Nickel | 374 |  |  |  |  | 420
Selenium | 89 |  |  |  |  | 100
Zinc | 2498
 | IF Greater than 80% Flag POTW MUST SUBMIT LAND APP & METALS MANAGEMENT PLAN |  |  |  |  | If Greater than 80% of the concentration limit POTW MUST SUBMIT METALS MANAGEMENT PLAN |  |  |  |  | If over ceiling conc. POTW must reduce MAHL
1 The most heavily loaded field is determined for each polluntant indivisually, and is the field that contains the highest amount (lbs/acre) of that polluntant.
Spreadsheet: 115243d1310859598-excel-2007-need-help-with-summing-up-the-data-in-sheet-sales-summary
Sheet: June 5

HOUSTON | 1440
SHOES | 500
SHIRTS | 300
PANTS | 400
SOCKS | 240
DALLAS | 638
SHOES | 320
SHIRTS | 147
PANTS | 141
SOCKS | 30
AUSTIN | 1390
SHOES | 770
SHIRTS | 330
PANTS | 285
SOCKS | 14
Spreadsheet: 792718d1661097028-splitting-numbers-from-texts-split-numbers-from-texts
Sheet: Sheet1

 | Desired Result
Copied Data | + | - | HansDouwe |  | [NAME] |  | Bo_Ry
MBB CT-16 - 18 food
01/07 CHEQUE PROCESSING FEE .50- 289,723.85 |  | 0.5
01/07 INTER-BANK PAYMENT INTO A/C 906.30+ 290,630.15 | 906.3
01/07 INTER-BANK PAYMENT INTO A/C 115.76+ 290,745.91 | 115.76
02/07 CMS - CR PYMT MARS 838.44+ 291,584.35 | 838.44
02/07 TRANSFER TO A/C 166.10+ 291,750.45 | 166.1
02/07 TRANSFER TO A/C 237.05+ 292,384.45 | 237.05
02/07 TRANSFER FR A/C 300.00- 292,084.45 |  | 300