tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 469882d1468233368-make-line-chart-where-y-axis-value-affected-by-multiple-variables-zeszyt1
Sheet: Arkusz1

 | 0 | 3 | 90 | change this 2 cells
 | 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
 | 32
 | 33
 | 34
 | 35
 | 36
 | 37
 | 38
 | 39
 | 40
 | 41
 | 42
 | 43
 | 44
 | 45
 | 46
 | 47
 | 48
 | 49
 | 50
 | 51
 | 52
 | 53
 | 54
 | 55
 | 56
 | 57
 | 58
 | 59
 | 60
 | 61
 | 62
 | 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
 | 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
 | 379
 | 380
 | 381
Spreadsheet: 856090d1705477898-b1-fix-minus-b3-plug-remainng-letter-pull-letter
Sheet: Sheet1

AEI | DLN |  | Excel 2019 | Excel 365
E | ALIENED
G | ALIGNED
U | ALIUNDE
V | ANDVILE
N | ANNELID
V | ANVILED
G | DEALIGN
G | DEALING
E | DELAINE
S | DENIALS
H | HIELAND
X | INDEXAL
H | INHALED
C | INLACED
K | KNAIDEL
H | LEADING
N | LINDANE
P | PLAINED
S | SNAILED
U | UNIDEAL
Spreadsheet: 743965d1628843978-highlight-date-range-on-calendar-399
Sheet: Issue

 |  |  |  |  |  | 3099 - HIRE ISSUE LOG
Date | Customer | Site | Issue | Who attended | Engine hrs | Comments | Summary | Worksheet rec'd | Comments | Warranty
2020-02-21 00:00:00
2020-02-23 00:00:00
2020-03-13 00:00:00
2020-03-15 00:00:00
2020-03-25 00:00:00
2020-03-29 00:00:00
2020-03-30 00:00:00
2020-06-17 00:00:00
2020-07-17 00:00:00
2021-07-16 00:00:00 |  |  |  |  |  |  |  | Y
2020-07-19 00:00:00
2021-07-29 00:00:00 |  |  |  |  |  | GB |  | Y
2020-08-03 00:00:00 |  |  |  |  |  |  |  | Y/INV
2020-08-04 00:00:00
2020-09-21 00:00:00 |  |  |  |  |  |  |  | Y
2020-09-30 00:00:00
2020-10-03 00:00:00
2020-10-05 00:00:00
2020-10-13 00:00:00
2020-11-11 00:00:00
2020-11-17 00:00:00
2020-12-31 00:00:00 |  |  |  |  |  |  |  | Y
2021-03-29 00:00:00
2021-03-30 00:00:00 |  |  |  |  |  |  |  | Y
2021-04-26 00:00:00 |  |  |  |  |  |  |  | Y
2021-04-28 00:00:00 |  |  |  |  |  |  |  | Y
2021-06-01 00:00:00 |  |  |  |  |  |  |  | Y
2021-06-01 00:00:00
2021-06-02 00:00:00 |  |  |  |  |  |  |  | Y
2021-06-03 00:00:00
2021-06-02 00:00:00 |  |  |  |  |  |  |  | Y
2021-06-22 00:00:00
2021-06-30 00:00:00
2021-07-05 00:00:00 |  |  |  |  |  |  |  | Y
2021-07-06 00:00:00 |  |  |  |  |  |  |  | Y
2021-07-06 00:00:00 |  |  |  |  |  |  |  | Y
2021-08-06 00:00:00 |  |  |  |  |  | CAT |  | Y
2021-08-10 00:00:00 |  |  |  |  |  | Off-hired
Spreadsheet: 162448d1339888661-excel-2007-how-can-i-join-two-formulas-mjc-registro-interactivo
Sheet: ESTSR

[NAME]
HOJA DE NOTAS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-01 00:00:00
ESCUELA : |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-09-01 00:00:00
GRUPO: |  | 2ndo R |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-10-01 00:00:00
MAESTRO: |  | [NAME] |  |  |  |  |  | Firma del padre o encargado |  |  |  |  |  |  | _____________________________________ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-11-01 00:00:00
CLASE DE: |  | Ingles |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-01 00:00:00
HORA: |  |  |  |  |  |  |  | Entregado en la libreta en la fecha: |  |  |  |  |  |  |  | ________________________________ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-01-01 00:00:00
AÑO: |  | 2012-2013 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-02-01 00:00:00
Número del estudiante |  |  | 1 |  | [NAME]: | 2012-08-01 00:00:00 |  |  | Nombre del Estudiante: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-03-01 00:00:00
Puntos Total de Trabajo |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-04-01 00:00:00
[NAME] obtenida |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-05-01 00:00:00
Puntos Total de Exam o Proyectos
[NAME] obtenida
Spreadsheet: 701103d1603533786-vlookup-return-values-in-different-row-example
Sheet: List1

a
 | b
 |  | c
 |  |  | d
 |  |  |  | e
f
 | g
 |  | h
 |  |  | i
 |  |  |  | j
Spreadsheet: 862354d1710111565-data-validation-from-multiple-sheets-w-in-workbook-review_template-redesigned-example-2
Sheet: Main

 | As of: | 2023-09-30 00:00:00 | Manpower | Auth | Req | On Hand | Vacancies | % Vacancies |  |  | Project A
 | Program/Project: |  |  | 5 | 5 | 4
 | Sponsor/Customer: | Multiple |  | 3 | 3 | 0
 | Directorate: |  |  | 0 | 0 | 0
 | Program Mgr: |  |  | 0 | 0 | 0
 | PE: |  |  | 10 | 10 | 10
 | Overall Status: | On track | Total
 | Description:
 | Milestones, Deliverables, Risks, and Accomplishments
 | Project | Objectives | MS # | Milestones | Planned Completion | Actual Completion | [NAME] | [NAME] | Due | Delivered | Risk | Type | Corrective Action Plan (CAP) | Significant Accomplishments
 | Project A | Something |  | Proj A Task 1 |  |  |  | Proj A Del 1 |  |  |  | Financial | Resolve FAR regulation issue
 | Project B | Something |  | Proj B Task 2 |  |  |  | Proj B Del 5 |  |  |  | Schedule | Fix HVAC- Bring SPARTAN up and continue certification process
 | Project B | Something |  | Proj B Task 6 |  |  |  | Proj B Del 6 |  |  |  | Performance
 | Project C | Something |  | Proj C Task 3 |  |  |  | Proj C Del 3 |  |  |  | Technical
 | Project C | Something |  | Proj C Task 5 |  |  |  | Proj C Del 4 |  |  |  | Multiple
Spreadsheet: 475021d1471018988-conditional-formatting-using-formula-formating-random-selection
Sheet: Master Month with Rt 50

 |  |  |  |  |  |  | Using the mySAMPLE Function to Select a Monthly Random Sample
1. Enter holidays in range D15:AH15.
2. Locate each of the sampled ID# in range U9:U12 from Range D18:AH111
3. Enter the corresponding Trip# in V9:V14 and the corresponding Date in W9:W14.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Paste (1,2,3) Copy ID,Trip & Date here after initial selection
Enter Minimum Sample Size |  |  |  |  |  |  | 6 |  | # Days This Month (calc) |  |  |  |  |  |  |  |  | Sample (calc) |  | ID# | Trip # | Date
Enter Calendar Year |  |  |  |  |  |  | 2016 |  | Total Monthly Trips Operated (calc) |  |  |  |  |  |  |  |  |  |  | 583
Enter Month as # (1, 2, …, 12) |  |  |  |  |  |  | 8 | NOTE: re-enter month here to update trips |  |  |  |  |  |  |  |  |  |  |  | 1154
Enter Total Daily Trips on Schedule |  |  |  |  |  |  | 92 |  |  |  |  |  |  |  |  |  |  |  |  | 1212
Enter 1 for Holidays in Row 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 995
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1134
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1095
 |  |  | Dates
Holidays
Weekdays (calc)
 |  | Trip #
 |  | 1
Spreadsheet: 762150d1641412029-calculate-percentage-of-the-sum-of-highest-3-marks-out-of-300-and-350-when-subject-changes-problem-on-percentage-calculation
Sheet: Sheet1

ENG |  |  | [NAME] |  |  | SCI |  |  | HIST |  |  | GEO |  |  | BEST 3 | %
THEORY | PRAC. | TOT | THEORY | PRAC. | TOT | THEORY | PRAC. | TOT | THEORY | PRAC. | TOT | THEORY | PRAC. | TOT
50 | 15 |  | 60 | 20 |  | 45 | 15 |  | 55 | 20 |  | 45 | 25
Here is a distribution of marks obtained by a student. In Cell P2 a sum of his top 3 marks is calculated. Total marks is 300. But if the sum of best 3 marks included the subject Geography (GEO), the total marks become 350. I want to put a  formula in Cell Q2 that will calculate the % of marks obtained out of total marks 300 but 350 when Geography (GEO) is included in the Best 3 sum.
Spreadsheet: 13798a7d-9ca2-4d28-987f-ea09105df8ec
Sheet: VALLA

VALLA MENOS VENCIDA
SUB 19
CLUB | PARTIDOS |  |  |  |  |  |  | TOTAL | PARTIDOS | PONDERADO
 | 1 | 2 | 3 | 4 | 5 | 6 | 7
SUB 14
CLUB | PARTIDOS |  |  |  |  |  |  | TOTAL | PARTIDOS | PONDERADO
 | 1 | 2 | 3 | 4 | 5 | 6 | 7
Spreadsheet: 41887d1240424333-conditional-formatting-multiple-rows-independently-sample-excel-file
Sheet: Sheet1

A | 60.301507537688 | 33.420365535248 | 36.36363636364 | 137.142857142856 | 182.535211267608 | 56.206088992976 | 232.525951557096 | 97.959183673472
B | 119.4183096227682 | 107.032167717379 | 114.3733649916465 | 108.3753967054515 | 98.73875868175317 | 51.47991883796534 | 117.1766337414373 | 90.0685618058572
C | 98.97764685496657 | 39.32655082381083 | 43.37082795500385 | 101.8567639257363 | 192.5594949004438 | 46.1277557942321 | 148.3355208209114 | 158.7614356087386
D | 27.13567839195383 | 103.3942558746517 | 86.63101604275707 | 23.7362637362741 | 131.8309859154855 | 109.6018735362752 | 186.8512110726451 | 178.4256559766497
Spreadsheet: 382c2322-ee71-4cb1-bf9b-8218501ab1de
Sheet: Sheet1

GO Term | Description | CRANE p-value | [NAME] | Subtype | CRANE Genes | Verhaak Genes
GO:0006355 | regulation of transcription, DNA-dependent | 0.00604975080495623 | 0.000692 | Classical | IKBKAP, MAP2K1, TGFB3, TBP, GTF2B, STAT3, CTNNB1, EP300, NCOA3, YWHAQ, BCL6, POU3F2, CRK, MYBBP1A | [NAME], NR2F6, [NAME], [NAME], ZNF671, [NAME], ZNF211, ZNF264, JUND, ZNF227, SHOX2, KEAP1, ARNTL, ZNF45, ZNF446, ERCC2, EYA2, ZNF419, [NAME], [NAME], [NAME], ZNF20, HMG20B, [NAME], TLE2, RFXANK, CC2D1A, SOX9, NR2E1, ZNF606, [NAME], TGIF2, TEAD3, IRF3, ZNF304, ZFHX4, ZNF134,
GO:0007010 | cytoskeleton organization | 0.00070952153703402 | 0.000595 | Proneural | ACTG1, ARHGEF2, GSN, PRKCI, BCL6, PAK1, CRK, CTNNB1 | STMN1, WASF1, [NAME], CDKN1B, KIF21B, EPB41, MAP2, MAPT, SPTBN2, TMSL8, MTSS1, FHOD3, DBN1, PFN2, [NAME],
GO:0042127 | regulation of cell proliferation | 0.00527689964061531 | 0.003177202 | Mesenchymal | IGF1R, [NAME], ARHGEF2, CASP3, TGFBR1, TGFB3, BCL6, POU3F2, CTNNB1 | LAMB1, STAT6, S100A11, [NAME], RHOG, [NAME], [NAME], TIMP1, POLD4, NRP1, EMP3, [NAME], IGFBP6, PTPRC, TNFRSF11A, SHC1, ANXA1, GRN,
GO:0043228 | non-membrane-bounded organelle | 0.000671761623301584 | 0.001036578 | Proneural | IKBKAP, [NAME], MAP2K1, DDX5, STAT3, PXN, CTNNB1, ACTG1, [NAME], [NAME], CASP3, EP300, SYN1, GSN, BCL6, RPL4, PES1, MYBBP1A, DNM1, HSPA9 | STMN1, CASK, TAF5, NR0B1, [NAME], RAD21, CBX1, NOL4, DNM3, FHOD3, CHD7, PFN2, [NAME], [NAME], TOP2B, WASF1, SATB1, [NAME], KIF21B, DCX, MYO10, EPB41, MAP2, ACTR1A, HDAC2, MAPT, SPTBN2, HMGB3, MTSS1, LOC81691, DBN1,
GO:0043232 | intracellular non-membrane-bounded organelle | 0.000671761623301584 | 0.001036578 | Proneural | IKBKAP, [NAME], MAP2K1, DDX5, STAT3, PXN, CTNNB1, ACTG1, [NAME], [NAME], CASP3, EP300, SYN1, GSN, BCL6, RPL4, PES1, MYBBP1A, DNM1, HSPA9 | STMN1, CASK, TAF5, NR0B1, [NAME], RAD21, CBX1, NOL4, DNM3, FHOD3, CHD7, PFN2, [NAME], [NAME], TOP2B, WASF1, SATB1, [NAME], KIF21B, DCX, MYO10, EPB41, MAP2, ACTR1A, HDAC2, MAPT, SPTBN2, HMGB3, MTSS1, LOC81691, DBN1,
GO:0045449 | regulation of transcription | 0.00481533494049 | 0.001174373 | Classical | IKBKAP, MAP2K1, TGFBR1, TGFB3, TBP, DDX5, GTF2B, STAT3, CTNNB1, MAPK1, EP300, NCOA3, YWHAQ, POU3F2, BCL6, IKBKB, CRK, MYBBP1A | [NAME], [NAME], NR2F6, [NAME], [NAME], ZNF671, [NAME], ZNF211, ZNF264, JUND, ZNF227, SHOX2, KEAP1, ARNTL, ZNF45, ZNF446, ERCC2, EYA2, ZNF419, [NAME], [NAME], [NAME], ZNF20, HMG20B, [NAME], TLE2, RFXANK, CC2D1A, SOX9, NR2E1, ZNF606, [NAME], TGIF2, TEAD3, IRF3, ZNF304, ZFHX4, ZNF134,
Spreadsheet: 112489d1308606843-index-match-across-multiple-sheets-using-multiple-criteria-index-match-across-multiple-sheets-using-multiple-criteria-1-list
Sheet: Master

 |  | Select a Sheet ► | Campaign1
 |  | Enter an Year ► | 2011
 |  | Enter a Department Name ► | Dept1
 |  |  |  |  |  |  |  | Sheet Names
Row # | Week | Task | Responsible | Compaign |  |  |  | Campaign1
 |  |  |  |  |  |  |  | Campaign2
 |  |  |  |  |  |  |  | Campaign3
 |  |  |  |  |  |  |  | Campaign4
 |  |  |  |  |  |  |  | Campaign5
 |  |  |  |  |  |  |  | Campaign6
 |  |  |  |  |  |  |  | Campaign7
 |  |  |  |  |  |  |  | Campaign8
 |  |  |  |  |  |  |  | Campaign9
 |  |  |  |  |  |  |  | Campaign10
Spreadsheet: 870249d1716798144-sumproduct-formula-not-giving-any-results-excel-help-with-formulas-2-
Sheet: Results

Week Commencing | Contract | Contract % | Days Worked | Days Lost | Daily Average m3 | Reasons for Days Lost | Reasons for Days Lost | Contract Profit | Profit per Machine | Daily Average Profit | Contract Notes
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
Week Number |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
Spreadsheet: 715086d1611560765-trades-needed-in-sheet-2-test99
Sheet: Sheet1

Date | Price | Signal | Stop Loss Price | Fix sale point | Buy/sell | SL Price | Price
2010-11-10 00:00:00 | 6.55
2010-11-11 00:00:00 | 6.54 | Buy
2010-11-15 00:00:00 | 6.59
2010-11-16 00:00:00 | 6.34
2010-11-22 00:00:00 | 6.54
2010-11-23 00:00:00 | 6.67 | Sell
2010-11-24 00:00:00 | 6.47
2010-11-25 00:00:00 | 6.67
2010-11-26 00:00:00 | 6.4 | Buy
2010-11-29 00:00:00 | 6.61
2010-11-30 00:00:00 | 6.01
2010-12-01 00:00:00 | 6.67 | Sell
2010-12-02 00:00:00 | 6.55
2010-12-06 00:00:00 | 6.61
2010-12-07 00:00:00 | 6.53 | Buy
2010-12-08 00:00:00 | 6.86
2010-12-09 00:00:00 | 6.67
2010-12-10 00:00:00 | 6.59 | Sell
2010-12-13 00:00:00 | 6.54
2010-12-14 00:00:00 | 6.54
Spreadsheet: 711313d1609606524-help-with-index-find-formula-to-identify-if-employees-shift-matches-their-last-shift-same-shift
Sheet: Sheet1

Name | Shift | Same Shift As Last Time
[NAME] | AM
[NAME] | PM
[NAME] | AM
[NAME] | PM | NO
[NAME] | AM | NO
[NAME] | PM | NO
[NAME] | AM | NO
[NAME] | PM | NO
[NAME] | AM | NO
[NAME] | PM | YES
[NAME] | AM | YES
[NAME] | PM
[NAME] | AM
[NAME] | PM
[NAME] | AM
Spreadsheet: 36b4807f-b2cc-4aa6-81ed-15b4bd915fb7
Sheet: 2001-02

Table F
Student Numbers by [NAME] and Method of Study
2001-02
 | Full Time |  |  | Part Time |  |  | Total
 | Male | Female | Total | Male | Female | Total | Male | Female | Total
Undergraduate | 5125 | 5833 |  | 131 | 77 |  | 5256 | 5910
%
Graduate | 2047 | 2113 | 4160 | 1065 | 926 | 1991 | 3112 | 3039
%
Total
Spreadsheet: 821830d1678922047-change-how-spreadsheet-information-is-presented-sample-problem
Sheet: Sheet1

Date | 2022-03-03 00:00:00 |  |  |  | Date | Time | School | Class | Student | Score
Time | 13:30:00 |  |  |  | 2022-03-03 00:00:00 | 13:30:00 | Pavan | 6c | 5 | 82
School | Pavan |  |  |  | 2022-03-02 00:00:00 | 13:30:00 | Pavan | 6a | 9 | 91
Class | 6c |  |  |  | 2022-03-03 00:00:00 | 13:30:00 | Noble | 7e | 6 | 84
Student | 5 |  |  |  | 2022-03-04 00:00:00 | 13:30:00 | [NAME] | 6b | 5 | 86
Score | 82 |  |  |  | 2022-03-02 00:00:00 | 13:30:00 | Noble | 6d | 2 | 87
Date | 2022-03-02 00:00:00
Time | 13:30:00
School | Pavan
Class | 6a
Student | 9
Score | 91
Date | 2022-03-03 00:00:00
Time | 13:30:00
School | Noble
Class | 7e
Student | 6
Score | 84
Date | 2022-03-04 00:00:00
Time | 13:30:00
School | [NAME]
Class | 6b
Student | 5
Score | 86
Date | 2022-03-02 00:00:00
Time | 13:30:00
School | Noble
Class | 6d
Student | 2
Score | 87
Spreadsheet: 183858d1349073959-super-tricky-lookup-problem-attempt-1-
Sheet: Sheet1

Ad Name | My attempt | Desired Output | My Try | 2nd try
xxxxBSE_01_4TH_CA_AND_HS_WIN_FishFoodies_0yyy |  | BSE_01_4TH_CA_AND_HS_WIN_FishFoodies_0
fdsgdfsgBSE_01_ADF_CA_AND_v2.2_WIN_FishFoodies_0dfgd |  | BSE_01_ADF_CA_AND_v2.2_WIN_FishFoodies_0
BSE_01_GOO_CA_AND_v2.2_WIN_FishFoodies_0333332 |  | BSE_01_GOO_CA_AND_v2.2_WIN_FishFoodies_0
Raw data | Lookup Table
BSE_01_4TH_CA_AND_HS_WIN_FishFoodies_0
BSE_01_ADF_CA_AND_v2.2_WIN_FishFoodies_0
BSE_01_GOO_CA_AND_v2.2_WIN_FishFoodies_0
Spreadsheet: 862161d1709912367-reverse-tax-calculation-net-to-gross-v2ab
Sheet: gross calculation

 | Tax
 | Annual
INPUTS:
Net income (goal) | 100000
Deductions
Gross income
Deductions
Taxable income
Tax rate
Tax
Personal deductions:
Refundable quebec abatement
Net income (proof of concept)
Present-day Federal basic personal deduction: | 15000
Federal base rate | 0.15
Quebec abatement (% of federal tax) | 0.165
Spreadsheet: 77832d1278331562-copying-rows-and-cells-of-qualified-information-tomartin-1-
Sheet: original data sheet

 | Product description | Material | quantity | Color | condition
1 | Large | new | 20
1 | medium | new | 10
0 | small | used | 10
0 | round | used | 10
1 | flat | new | 15
0 | square | new | 10
 |  | [NAME]: this is simular to the original document I am copying from. I only need partial information from rows that have a # 1 in th A columns. All other rows can be ignored if they don't have the # 1 in the A column.
Spreadsheet: 850577d1700934087-employee-total-workin-hours-summary-total-working-hours-summary
Sheet: Sheet2

TABLE 1 |  |  |  |  |  |  | TABLE 2
Name | ID | Date | Regular hours | OT hours | Total hours |  | Name | ID | 2023-11-13 00:00:00
[NAME] | 10247 | Week 1: Nov 13 - Nov 19 |  |  |  |  | [NAME] | 10247
 |  | 2023-11-13 00:00:00 | 2.48 | 0 | 2.48 |  | [NAME] | 10301
 |  | 2023-11-16 00:00:00 | 3.97 | 0 | 3.97
 |  | 2023-11-17 00:00:00 | 4.2 | 0 | 4.2
[NAME] | 10301 | Week 1: Nov 13 - Nov 19
 |  | 2023-11-14 00:00:00 | 7.6 | 0 | 7.6
 |  | 2023-11-15 00:00:00 | 7.97 | 0 | 7.97
 |  | 2023-11-16 00:00:00 | 7.93 | 0 | 7.93
 |  | 2023-11-17 00:00:00 | 8.43 | 0 | 8.43
 |  | 2023-11-18 00:00:00 | 6.25 | 0 | 6.25
Spreadsheet: sally_beck__33824__global standards daily reporting
Sheet: B 03

Quantitative Standards
Daily Exception Reports
Reports Supporting Quantitative Standards B
Report B 03:
Purpose: | To capture when commercial did not sign off on daily P&L, positions, etc.
Date | Book | Commodity | Reason trader did not sign off | Key contact
2000-10-25 00:00:00 | Gas - Henry Hub | Gas | Book was finalized at 11:30 pm and trader was gone. | [NAME]
2000-10-25 00:00:00 | DPR | All | One of 3 people required to sign off DPR has not yet done so - Viewer was down. | [NAME]
Spreadsheet: 867118d1713997220-changing-template-data-employee-absence-report-copy-
Sheet: June

 | Employee Absence Report
 | June
 | Absence type key | V | Vacation (10) |  |  | P | Paid (2) |  |  | S | Unpaid (1) |  |  | U | Unauthorized |  |  | O | Other
 |  | Dates of absence
 | 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 |  | Total days
 | [NAME]. M  (PMO)
 | [NAME]. P  (PMO) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V | V | V | V |  |  | V
 | [NAME]. R  (GL)
 | [NAME]. M  (GL)
 | Teddy. M  (GL)
 | Krushna. J  (DLO)
 | [NAME]. W  (PFO)
 | Jaxon. B  (PMO)
 | Daman. S (PMO)
 | Alvin. C  (GL)
 | Baldomero. N  (GL)
 | Junner. B  (GL)
 | Heather. C  (PFO)
 | Jordan. B  (LO)
 | Santos. C  (GL)
 | Sunny. I  (GL)
 | Oliver. M  (PR)
 | [NAME]. C  (TL)
 | Justin. H  (YFO)
 | [NAME]. M  (YFO)
 | [NAME]. T  (YFO)
 | [NAME]. B  (SHC)
 | [NAME]. H  (IM)
 | [NAME]. A  (IM)
 | [NAME]. M  (IM)
 | Maryanne. B  (IMA)
 | Art. P  (MF)
 | Fabrice. M  (MF)
 | [NAME]. T (IE)
 | [NAME]. P  (IE)
 | Justin. N  (IEA)
 | Paige. B  (WMR)
 | Maryann. R  (PSC)
Spreadsheet: darrell_schoolcraft__7334__imball0203
Sheet: burlington

56423
Day | Measured | Scheduled | Imbal
1 | 125289 | 125129
2 | 151397 | 150614
3 | 140641 | 140609
4 | 140746 | 140609
5 | 138812 | 138455
6 | 140914 | 140423
7 | 147299 | 147989
8 | 142094 | 142003
9 | 171123 | 172003
10 | 168833 | 172003
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 |  |  |  |  |  |  | 20
2002-02-28 00:00:00 |  |  | -13944.79 |  |  |  | 530
2002-03-10 00:00:00
 |  |  |  |  |  |  | 5989
CBS Volume
 |  |  | -7030
Spreadsheet: 701687d1603889612-duplicate-values-formula-duplicate-1-2
Sheet: Sheet1

 | MAC ADD | Netwok | aaa
 | Mac 1 | A
 | Mac 1 | B
 | Mac 2 | C
 | Mac 2 | D
 | Mac 3 | F
 | Mac 4 | A
 | Mac 4 | A
 |  |  | Count of MAC ADD | aaa
 |  |  |  | Mac 1A | Mac 1B | [NAME] | Mac 2D | Mac 3F | [NAME] | Grand Total
 |  |  | Total | 1 | 1 | 1 | 1 | 1 | 2 | 7
Spreadsheet: bf6bfdf3-baf7-4c80-b282-1e7baa8b486e
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
FSFLE | Test | FSFLE | Safflower (Carthamus tinctorius) IgE | Safflower IgE | Radioimmunoassay (RIA) | Plain, Red-Top Tube: Red |  |  | 0.5 | mL | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | <[NAME]/L   Test Performed by: Viracor-IBT Laboratories                              1001 NW Technology Dr.                              Lee's Summit, MO 64086 | Monday through Friday | 2 - 3 days | 4 - 7 days | 1 | 86003 |  |  |  |  | Viracor-IBT Laboratories
FSFLE | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FSFLE | Result | Z3100 | Safflower IgE | Safflower IgE | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FSFLE | Result | Z3101 | Class | Class | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process