tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 745680d1630103554-pulling-data-validation-dropdown-options-from-another-sheet-not-dependent-dropdown-data-validation-help-v5-082521
Sheet: Instructions

Instructions |  |  |  |  |  |  | Controls (to be added)
Step | Document | Instructions | Notes |  |  |  | Button/macro to reset/clear workbook
1 | N/A | Run an Advanced Find in D365 and Export the results | Only include columns that will have updated data ( |  |  |  | Button/macro to refresh the queries
2 | D365 Output Report | Unhide all columns (A/B/C are hidden by default) |  |  |  |  | Button/macro to copy values from "Import to D365" sheet
3 | D365 Output Report | Make a copy of the original D365 report file (this will be used to re-import the revised data) | Add prefix "Import" to the filename
4 | D365 Output Report (Copy) | Delete all rows (Keep headers) | This file will be used to re-import data into D365
5 | This [NAME] | Paste D365 Report data into designated tab | Paste Values (Validations will not copy over)
7 | This [NAME] | Refresh All Data (Queries and Connections in [NAME]) | Only column names that match the source D365 data will remain
8 | "Import" D365 Report (Copy) | Paste values from Import to D365 tab into D365 Output Report (Copy) | Only keep columns with new/revised data (remove other columns with unchanged data)
9 | "Import" D365 Report (Copy) | Import Revised data into D365
Phase | Description
1 | Identify and Remove Junk
2 | Upload/import cleaned data to D365
3 | Populate with corrected data
Spreadsheet: phillip_m_love__30089__Credit Report
Sheet: Sheet1

DEAL ORIGINATION REPORT
Deals Input on 3/29/01
PENDING CREDIT ITEMS
Counterparty | Deal Number | Deal Type | Comm | Contact/Action Needed
Cross Oil Refining & Marketing | V04032.2/3/4 V04033.3/4/5 | F | WTI | Brant Reves
Greeley Gas Company an Operating… | V03636.1 | P | NG | [NAME]
Linder Oil Company, A Partnership | Q24113.G | P | NG | Brant Reves
New Counterparty | V02450.1 | F | NWSP | [NAME]
New Counterparty | V03209.1 | P | NWSP | [NAME]
Pacific Gas & Electric Company | QA9788.2 NW8988.2 | P | NG | [NAME]
The Herald-Mail Company | V03164.1 | P | NWSP | [NAME]
Webco Graphics | V02852.1 | P | NWSP | [NAME]
REBOOK ITEMS
Counterparty | Deal Number | Deal Type | Comm | Rebook To--
AEP Energy Services, Ltd. | V02752.1 | F | NG | AEP Energy Services, Inc.
Cargill Energy Trading Canada, Inc. | V04042.1 v04089.1 | F | NG | Cargill Energy, a division of Cargill Inc.
Engage, Inc. | Q04484.1 | F | NG | Engage Energy Canada L.P.
Invasion Energy Inc. | QU5599.3 | P | NGGJ | Invasion Energy Inc. (w/ECC)
Louis Dreyfus Plastics LLC | [NAME] | F | C2GC | Louis Dreyfus Plastics Corp.
Star Gas Propane, LP | V04385.1 | F | C3GC | Star Gas Propane, LP (w/ENA)
Virginia Electric and Power Company | V03974.1 | F | NG | Virginia  Power Energy Marketing
Spreadsheet: 120752d1315497918-multiple-results-sample
Sheet: Cash Flows

Table of Contents
 |  | CASH FLOW SUMMARY
 |  | ANNUAL TOTALS: Years 1-5
 |  | New Business* | Running Total | Cash Needed | Running Total | Net Interest | Running Total | Principal Reduction | Running Total | Cost of Funds | Running Total
 | Year 1
 | Year 2
 | Year 3
 | Year 4
 | Year 5
 |  | *Includes commissions and overhead
 | MONTHLY CASH FLOW PROJECTIONS
 | Year 1 | New Business* | Cash Needed | Net Interest Earnings |  | Principal Reduction |  | Cost of Funds
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 |  | *Includes commissions and overhead
 | Year 2 | New Business* | Cash Needed | Net Interest Earnings |  | Principal Reduction |  | Cost of Funds
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | Running Total:
 |  | *Includes commissions and overhead
 | Year 3 | New Business* | Cash Needed | Net Interest Earnings |  | Principal Reduction |  | Cost of Funds
 | 25
 | 26
 | 27
 | 28
 | 29
 | 30
 | 31
 | 32
 | 33
 | 34
 | 35
 | 36
 | Running Total:
 |  | *Includes commissions and overhead
 | Year 4 | New Business* | Cash Needed | Net Interest Earnings |  | Principal Reduction |  | Cost of Funds
 | 37
 | 38
 | 39
 | 40
 | 41
 | 42
 | 43
 | 44
 | 45
 | 46
 | 47
 | 48
 | Running Total:
 |  | *Includes commissions and overhead
 | Year 5 | New Business* | Cash Needed | Net Interest Earnings |  | Principal Reduction |  | Cost of Funds
 | 49
 | 50
 | 51
 | 52
 | 53
 | 54
 | 55
 | 56
 | 57
 | 58
 | 59
 | 60
 | GRAND TOTALS:
 |  | New Business* | Cash Needed | Net Interest Earnings |  | Principal Reduction |  | Cost of Funds
Spreadsheet: 765367d1643294518-find-most-common-value-with-a-criteria-and-skipping-blanks-most-common-value-updated
Sheet: Sheet1

DATE | DAY | IN | OUT
2022-01-01 00:00:00
 |  | 08:00:00 | 17:00:00
 |  | 14:00:00 | 23:00:00
 |  | 14:00:00 | 23:00:00
 |  | 08:00:00 | 17:00:00
 |  | 10:00:00 | 19:00:00
 |  | 08:00:00 | 17:00:00
 |  | 08:00:00 | 17:00:00
 |  | 14:00:00 | 23:00:00
 |  | 10:00:00 | 17:00:00
 |  | 07:00:00 | 15:00:00
 |  | 07:00:00 | 16:00:00
 |  | 07:00:00 | 14:00:00
 |  | 14:30:00 | 22:30:00
 |  | 08:00:00 | 17:00:00
 |  | 07:00:00 | 16:00:00
 |  | 10:00:00 | 19:00:00
 |  | 14:00:00 | 23:00:00
 |  | 10:00:00 | 19:00:00
 |  | 07:00:00 | 16:00:00
 |  | 10:00:00 | 21:00:00
 |  | 07:00:00 | 16:00:00
 |  | 07:00:00 | 16:00:00
 |  | EXAMPLE 1 | EXAMPLE 2 | Help 1 | Help 2 | EXAMPLE 3
T | > | ""
Spreadsheet: 35853d1233587452-array-join-function-question-arrayjoin_test
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 |  | 23 | 24 |  | 26 | 27 | 28 | 29 | 30
31 | 32 | 33 | 34 |  |  | 37 |  |  | 40
41 | 42 | 43 | 44 | 45 | 46 | 47
 | 52 | 53 | 54 | 55 | 56 | 57 |  |  | 60
61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70
71 |  | 73 |  |  | 76 | 77 | 78 | 79 | 80
81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89
91 | 92 | 93 | 94 | 95 | 96 | 97 | 98 | 99 | 100
Spreadsheet: dutch_quigley__9224__Curve Fetch-multi day
Sheet: NG

 |  | 1996-01-01 00:00:00 | 1996-02-01 00:00:00 | 1996-03-01 00:00:00 | 1996-04-01 00:00:00 | 1996-05-01 00:00:00 | 1996-06-01 00:00:00
 | 1996-01-02 00:00:00 |  | 2.859 | 2.295
 | 1996-01-03 00:00:00 |  | 2.986 | 2.377
 | 1996-01-04 00:00:00 |  | 2.964 | 2.376
 | 1996-01-05 00:00:00 |  | 2.916 | 2.424
 | 1996-01-08 00:00:00 |  | 2.916 | 2.424
 | 1996-01-09 00:00:00 |  | 2.928 | 2.537
 | 1996-01-10 00:00:00 |  | 2.809 | 2.465
 | 1996-01-11 00:00:00 |  | 2.49 | 2.365
 | 1996-01-12 00:00:00 |  | 2.317 | 2.215
 | 1996-01-15 00:00:00 |  | 2.017 | 2.015
 | 1996-01-16 00:00:00 |  | 2.074 | 1.96
 | 1996-01-17 00:00:00 |  | 2.336 | 2.088
 | 1996-01-18 00:00:00 |  | 2.264 | 2.043
 | 1996-01-19 00:00:00 |  | 2.168 | 1.956
 | 1996-01-22 00:00:00 |  | 2.125 | 1.955
 | 1996-01-23 00:00:00 |  | 2.445 | 2.055
 | 1996-01-24 00:00:00 |  | 2.493 | 2.069
 | 1996-01-25 00:00:00 |  | 2.34 | 2.026
 | 1996-01-26 00:00:00 |  | 2.34 | 2.126
 | 1996-01-29 00:00:00 |  | 2.34 | 2.337
 | 1996-01-30 00:00:00 |  | 2.34 | 2.504
 | 1996-01-31 00:00:00 |  | 2.34 | 2.658
 | 1996-02-01 00:00:00 |  |  | 2.499 | 2.079
 | 1996-02-02 00:00:00 |  |  | 2.467 | 2.075
 | 1996-02-05 00:00:00 |  |  | 2.168 | 1.975
 | 1996-02-06 00:00:00 |  |  | 2.448 | 2.086
 | 1996-02-07 00:00:00 |  |  | 2.513 | 2.132
 | 1996-02-08 00:00:00 |  |  | 2.472 | 2.201
 | 1996-02-09 00:00:00 |  |  | 2.551 | 2.244
 | 1996-02-12 00:00:00 |  |  | 2.456 | 2.231
 | 1996-02-13 00:00:00 |  |  | 2.662 | 2.331
 | 1996-02-14 00:00:00 |  |  | 2.582 | 2.317
 | 1996-02-15 00:00:00 |  |  | 2.576 | 2.271
 | 1996-02-16 00:00:00 |  |  | 2.441 | 2.171
 | 1996-02-19 00:00:00 |  |  | 2.441 | 2.171
 | 1996-02-20 00:00:00 |  |  | 2.321 | 2.128
 | 1996-02-21 00:00:00 |  |  | 2.447 | 2.188
 | 1996-02-22 00:00:00 |  |  | 2.623 | 2.288
 | 1996-02-23 00:00:00 |  |  | 2.746 | 2.263
 | 1996-02-26 00:00:00 |  |  | 2.746 | 2.338
 | 1996-02-27 00:00:00 |  |  | 2.746 | 2.326
 | 1996-02-28 00:00:00 |  |  | 2.746 | 2.306
 | 1996-02-29 00:00:00 |  |  | 2.746 | 2.236
 | 1996-03-01 00:00:00 |  |  |  | 2.156 | 2.058
 | 1996-03-04 00:00:00 |  |  |  | 2.24 | 2.102
 | 1996-03-05 00:00:00 |  |  |  | 2.174 | 2.065
 | 1996-03-06 00:00:00 |  |  |  | 2.188 | 2.078
 | 1996-03-07 00:00:00 |  |  |  | 2.128 | 2.054
 | 1996-03-08 00:00:00 |  |  |  | 2.095 | 2.053
 | 1996-03-11 00:00:00 |  |  |  | 2.178 | 2.114
 | 1996-03-12 00:00:00 |  |  |  | 2.168 | 2.108
 | 1996-03-13 00:00:00 |  |  |  | 2.24 | 2.147
 | 1996-03-14 00:00:00 |  |  |  | 2.247 | 2.144
 | 1996-03-15 00:00:00 |  |  |  | 2.333 | 2.215
 | 1996-03-18 00:00:00 |  |  |  | 2.511 | 2.349
 | 1996-03-19 00:00:00 |  |  |  | 2.523 | 2.33
 | 1996-03-20 00:00:00 |  |  |  | 2.574 | 2.354
 | 1996-03-21 00:00:00 |  |  |  | 2.74 | 2.439
 | 1996-03-22 00:00:00 |  |  |  | 2.863 | 2.416
 | 1996-03-25 00:00:00 |  |  |  | 2.779 | 2.355
 | 1996-03-26 00:00:00 |  |  |  | 2.779 | 2.267
 | 1996-03-27 00:00:00 |  |  |  | 2.779 | 2.339
 | 1996-03-28 00:00:00 |  |  |  | 2.779 | 2.342
 | 1996-03-29 00:00:00 |  |  |  | 2.779 | 2.336
 | 1996-04-01 00:00:00 |  |  |  |  | 2.288 | 2.239
Spreadsheet: 53818d1253737284-how-to-extract-duplicate-rows-base-on-multiple-column-values-more-duplicates
Sheet: Sheet1

column name | schema | table name | data type | qualifiers | hide all duplicates | keep first duplicate |  | calculation
martin 1 | any 1 | some 3 | stuff 1 | qual 1 | 1 | 1 | Hide these rows | 1
martin 1 | any 7 | some 9 | stuff 1 | qual 1 | 1 | 0 |  | 1
[NAME] | any 2 | some 4 | stuff 1100 | qual 2 | 0 | 1 | Keep these rows | 0
[NAME] | any 8 | some 10 | stuff 2 | qual 2 | 0 | 1 |  | 0
[NAME] | any 3 | some 5 | stuff 3 | qual 3 | 0 | 1 | Hide this row | 1
[NAME] | any 4 | some 6 | stuff 4 | qual 4 | 1 | 1 | Hide these rows | 1
[NAME] | any 6 | some 8 | stuff 4 | qual 4 | 1 | 0 |  | 1
[NAME] | any 7 | some 9 | stuff 4 | qual 4 | 1 | 0 |  | 1
martin 5 | any 5 | some 7 | stuff 5 | qual 5 | 1 | 1 | Keep these rows | 0
martin 5 | any 5 | some 7 | stuff 5 | qual 5 | 1 | 0 |  | 0
martin 5 | any 6 | some 8 | stuff 5 | qual 555 | 0 | 1 |  | 0
[NAME] | any 6 | some 8 | stuff 6 | qual 6 | 1 | 1 | Hide these rows | 1
[NAME] | any 6 | some 8 | stuff 6 | qual 6 | 1 | 0 |  | 1
[NAME] | any 6 | some 8 | stuff 6 | qual 6 | 1 | 0 |  | 1
martin 7 | any 6 | some 8 | stuff 7 | qual 7 | 0 | 1 | Keep these rows | 0
martin 7 | any 6 | some 8 | stuff 777 | qual 7777 | 0 | 1 |  | 0
Spreadsheet: 126053d1319494698-display-rows-that-contains-certain-values-new-microsoft-excel-worksheet
Sheet: Sheet2

ID | probe_id
 |  |  |  | Criteria right now is if column D in Sheet1 is not blank(<>").
 |  |  |  | =IFERROR(INDEX(Sheet1!$A$2:$A$192,SMALL(IF(Sheet1!$D$2:$D$190<>"",ROW(Sheet1!$A$2:$A$190)-1),ROWS($A$1:A1))),"")
Spreadsheet: 126138d1319545314-display-rows-that-contains-certain-values-new-microsoft-excel-worksheet
Sheet: Sheet2

ID | probe_id | probe_id 2 | probe_id 3 | probe_id 4 | probe_id 5 | probe_id 6 | probe_id 7 | probe_id 8 | probe_id 9 | probe_id 10
cg00000924
cg00002028
cg00002808
cg00003287
cg00003578
cg00007420
Spreadsheet: jeffrey_a_shankman__13827__Mthly Int'l Trans Detail 2000
Sheet: Sheet1

Number of Employees |  | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00
Total International
Management |  | 1 | 1 | 1 | 1 | 1
Trading |  | 1 | 2 | 2 | 2 | 2
Marketing |  | 5 | 6 | 6 | 6 | 6
Origination |  | 3 | 3 | 3 | 3 | 3
Associate |  | 3 | 4 | 4 | 4 | 4
Analyst |  | 2 | 2 | 2 | 2 | 2
Scheduling |  | 3 | 4 | 4 | 5 | 5
Structuring
[NAME] |  | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 |  | 2000-11-01 00:00:00 |  | 2000-12-01 00:00:00
(Includes FWD, SWAPS, OPTIONS) |  |  |  | OTC | EOL | OTC | EOL | OTC | EOL
Coal sold |  | 574500 | 968750 | 1738000 | 795000 | 3515000 | 870000 | 9050000 | 45000
Coal bought |  | 492500 | 870000 | 2320000 | 200000 | 2170000 | 1500000 | 2069000 | 510000
Freight sold |  | 1165000 | 1565000 | 2924000 | 0 | 9531000 | 1135000 | 3368000 | 269000
Freight bought |  | 945000 | 886000 | 2823000 | 75000 | 8358000 | 747000 | 2226000 | 372000
TOTAL
[NAME] |  | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 |  | 2000-11-01 00:00:00 |  | 2000-12-01 00:00:00
 |  | 471099 | 439871.439 | 634314 |  | 670241 |  | 385385
Number of Transactions |  | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 |  | 2000-11-01 00:00:00 |  | 2000-12-01 00:00:00
 |  |  |  | OTC | EOL | OTC | EOL | OTC | EOL
Coal |  |  |  | 23 | 31 | 52 | 27 | 58 | 13
Freight |  |  |  | 27 | 1 | 39 | 30 | 26 | 12
TOTAL |  | 34 | 43
[NAME] (USD) |  | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 |  | 2000-11-01 00:00:00 |  | 2000-12-01 00:00:00
 |  | 3526000 | 3987000 | 4217000 |  | 3438000 |  | 8074000
Spreadsheet: 145818d1331752635-count-if-multiple-columns-examplecountif
Sheet: Sheet1

 | Open | Title | Grade | Manager | Team | Offered | Filled
 |  |  | H |  |  |  | 1
 | 1 |  | G
 |  |  | I |  |  |  | 1
 | 1 |  | F
 |  |  | I |  |  |  | 1
 | 1 |  | I
 |  | Open |  |  |  | Filled
 |  | I |  |  |  | I
 |  | H |  |  |  | H
 |  | G |  |  |  | G
 |  | F |  |  |  | F
Spreadsheet: 198853d1354910969-multiple-data-validation-in-one-cell-levels-and-numbers-forum
Sheet: Binder Sheet

 |  |  |  |  |  |  |  | False |  |  |  |  |  | False
 | Test 1 |  |  |  | Essay 1
 | T | A | C | K | T | T convert to % | [NAME] to value | A | A convert to % | [NAME] to value | C | C convert to % | [NAME] to value | K | K convert to % | [NAME] to value
 | 10 | 10 | 10 | 10 | 10 |  |  | 10 |  |  | 10 |  |  | 10
[NAME] | 10 | 9 | 8 | 7
Spreadsheet: 765770d1643582928-why-the-iferror-does-not-work-here-why-iferror-not-working
Sheet: Sheet1

 |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  |  |  |  | 77 | 555 | 222 | #N/A
 |  |  | 11 | 22 | 66 | 444 | 333
 |  |  | 23 | 33 | 77 | 555 | 222
 |  |  | 45 | 44 | 88 | 666 | 777
 |  |  | 67 | 55 | 99 | 777 | 212
Spreadsheet: 15c7b0fd-6630-48e9-afcd-ab2ac6ed1aba
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43041368 | 2014-09-06 10:20:51 | AXIS | 1 | 5 | 1 | 1611169 | Baron Von Funck | 12499 | western | 1944-06-13 | 1944-06-13 | Carentan | Carentan
43041479 | 2014-09-06 10:37:53 | ALLIES | 0 | 3 | 5 | 1611169 | Baron Von Funck | 12499 | western | 1944-06-13 | 1944-06-13 | Carentan | Carentan
43041588 | 2014-09-06 10:59:28 | AXIS | 0 | 6 | 7 | 1611169 | Baron Von Funck | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
43041744 | 2014-09-06 11:17:41 | ALLIES | 0 | 3 | 7 | 1611169 | Baron Von Funck | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
43046957 | 2014-09-06 19:38:03 | AXIS | 1 | 5 | 4 | 1301798 | muemo | 6156 | western | 1944-09-17 | 1944-09-19 | [NAME] | [NAME]
43047216 | 2014-09-06 20:05:44 | ALLIES | 0 | 4 | 6 | 1607905 | kdubbs56 | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
43047529 | 2014-09-06 20:20:43 | AXIS | 1 | 6 | 2 | 1607905 | kdubbs56 | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
43047708 | 2014-09-06 20:45:03 | ALLIES | 0 | 4 | 6 | 1400524 | Scharon | 7471 | mediterranean | 1942-06-05 | 1942-06-05 | Into the Cauldron | Le Chaudron
43047983 | 2014-09-06 21:07:42 | AXIS | 0 | 5 | 6 | 1400524 | Scharon | 7471 | mediterranean | 1942-06-05 | 1942-06-05 | Into the Cauldron | Le Chaudron
43104823 | 2014-09-10 22:29:23 | AXIS | 0 | 1 | 6 | 1633257 | player1633257 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
43105002 | 2014-09-10 22:43:45 | ALLIES | 0 | 5 | 6 | 1633257 | player1633257 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
43105255 | 2014-09-10 23:03:21 | ALLIES | 1 | 6 | 5 | 1627143 | vabelx2000 | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
43105536 | 2014-09-10 23:30:25 | ALLIES | 1 | 6 | 3 | 668571 | Jf Orion | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
43105897 | 2014-09-10 23:49:03 | AXIS | 0 | 2 | 6 | 668571 | Jf Orion | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
43116218 | 2014-09-11 20:06:45 | AXIS | 1 | 6 | 3 | 331242 | AdairC | 6155 | western | 1944-09-19 | 1944-09-19 | Arracourt | Arracourt
43116380 | 2014-09-11 20:16:25 | ALLIES | 1 | 6 | 3 | 331242 | AdairC | 6155 | western | 1944-09-19 | 1944-09-19 | Arracourt | Arracourt
Spreadsheet: 765166d1643200985-need-help-in-finding-any-formula-to-get-difference-of-in-and-out-timing-copy-of-sample-works-aligw
Sheet: System extracted

Emp Number | Employee Name | Unique Code for Manual | Attendance Date | time | Status
SP-01 | A |  | 22/01/2022 | 07:00:00 | IN
SP-01 | A |  | 22/01/2022 | 15:15:00 | OUT
SP-01 | A |  | 23/01/2022 | 07:05:00 | IN
SP-01 | A |  | 23/01/2022 | 13:00:00 | OUT
SP-01 | A |  | 25/01/2022 | 09:00:00 | IN
SP-01 | A |  | 25/01/2022 | 15:15:00 | OUT
SP-06 | B |  | 22/01/2022 | 07:22:00 | IN
SP-06 | B |  | 22/01/2022 | 15:15:00 | OUT
SP-06 | B |  | 23/01/2022 | 10:00:00 | IN
SP-06 | B |  | 23/01/2022 | 15:15:00 | OUT
SP-06 | B |  | 25/01/2022 | 08:00:00 | IN
SP-06 | B |  | 25/01/2022 | 09:15:00 | OUT
SP-07 | C |  | 22/01/2022 | 07:22:00 | IN
SP-07 | C |  | 22/01/2022 | 11:15:00 | OUT
SP-07 | C |  | 23/01/2022 | 07:22:00 | IN
SP-07 | C |  | 23/01/2022 | 15:15:00 | OUT
SP-07 | C |  | 25/01/2022 | 07:22:00 | IN
SP-07 | C |  | 25/01/2022 | 15:15:00 | OUT
SP-09 | D |  | 22/01/2022 | 07:22:00 | IN
SP-09 | D |  | 22/01/2022 | 15:15:00 | OUT
SP-09 | D |  | 23/01/2022 | 07:22:00 | IN
SP-09 | D |  | 23/01/2022 | 15:15:00 | OUT
SP-09 | D |  | 25/01/2022 | 07:22:00 | IN
SP-09 | D |  | 25/01/2022 | 15:15:00 | OUT
Spreadsheet: 850386d1700738597-each-day-how-many-time-repeated-repeated-days-aligw-felix
Sheet: Sheet1

Time | Result
2022-01-06 02:00:00
2022-01-06 10:00:00
2022-01-06 12:00:00
2022-01-06 13:00:00
2022-01-06 14:00:00
2022-01-06 15:00:00
2022-01-14 00:00:00
2022-01-14 07:00:00
2022-01-14 08:00:00
2022-01-14 16:00:00
2022-01-18 05:00:00
2022-01-18 08:00:00
2022-01-18 12:00:00
2022-01-18 22:00:00
2022-01-21 02:00:00
2022-01-21 04:00:00
2022-01-21 10:00:00
2022-01-21 15:00:00
2022-01-24 07:00:00
2022-01-24 08:00:00
2022-01-24 10:00:00
2022-01-24 16:00:00
2022-01-11 03:00:00
2022-01-11 11:00:00
2022-01-11 17:00:00
2022-01-17 08:00:00
2022-01-17 08:00:00
2022-01-17 15:00:00
2022-01-20 02:00:00
2022-01-20 12:00:00
2022-01-20 17:00:00
2022-01-25 08:00:00
2022-01-25 13:00:00
2022-01-25 17:00:00
2022-01-27 04:00:00
2022-01-27 12:00:00
2022-01-27 13:00:00
2022-01-10 15:00:00
2022-01-10 15:00:00
2022-01-12 10:00:00
2022-01-12 10:00:00
2022-01-13 09:00:00
2022-01-13 20:00:00
2022-01-19 03:00:00
2022-01-19 18:00:00
2022-01-26 12:00:00
2022-01-26 18:00:00
2022-01-28 08:00:00
2022-01-28 15:00:00
2022-01-03 15:00:00
2022-01-04 18:00:00
2022-01-07 14:00:00
2022-01-31 15:00:00
Spreadsheet: 174564d1345116064-images-batch-export-with-renaming-test
Sheet: Tabelle2

Picture 6
Picture 7
Picture 8
Picture 9
Picture 10
Picture 11
Picture 12
Picture 13
Picture 14
Picture 15
Picture 16
Picture 17
Picture 18
Picture 19
Picture 20
Picture 21
Picture 22
Picture 23
Picture 24
Picture 25
Picture 26
Picture 27
Picture 28
Picture 29
Picture 30
Picture 31
Spreadsheet: 64652d1265446470-looking-up-multiple-text-items-book1
Sheet: Sheet2

A1 | 5 | 2007 red dog
A3 | 3 | 2008 yellow dog
A1 | 2 | 2007 blue dog
A2 | 5 | 2009 red dog
A3 | 6 | 2008 red dog
A2 | 7 | 2009 yellow dog
A2 | 4 | 2007 red dog
Spreadsheet: 97d3b0d6-78d3-4c88-91b3-41647baa6b49
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
GABCC | Test | GABCC | GABA-B-Receptor Antibody by CBA, Spinal Fluid | GABA-B-R Ab CBA, CSF | Cell-binding assay (CBA) detects IgG specific for Gamma-Amino Butyric acid-type B receptor (GABA-B-R) by indirect immunofluorescence (IFA) | Plastic vial: PlV |  |  | 1 | mL | Container/Tube: Sterile vial [NAME]: 1 mL Additional Information: Include relevant clinical information, name, phone number, mailing address, and E-mail address (if applicable) of ordering physician | 0.5 | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK  Lipemia	Mild OK; Gross reject Icterus	Mild reject; Gross reject Other	NA | Negative | Wednesday, Friday; 8 a.m. | Negative: 2-4 days; Positive: 5-7 days |  | 1 | 86255 |  |  |  |  | Rochester
GABCC | [NAME] | CSF | CSF |  |  |  | Refrigerated | 28 days
GABCC | Result | 61515 | GABA-B-R Ab CBA, CSF | GABA-B-R Ab CBA, CSF | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: robin_rodrigue__33258__HS_STORAGE
Sheet: lava

TIME BUCKET/KEY: |  |  | REPORT REGION | RISK TYPE | 0 |  | 1 |  | 2 |  | 4 |  | 5 |  | 6
(Positions in Cont. [NAME].)     From: | Post ID |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total ECT |  | Total ECT
To: | Order |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (including B Eq) |  | (excluding B Eq)
STORAGE
Gas Daily | 1 |  | NGPRICE | P
Exotic Options
Basis - Notional | 3 |  | NGLTX | P | 0
Basis - Equivalent | 4 |  | NGFPL | P
Price | 5 |  | NGFPL | D
TOTAL:
Basis Roll-off
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CHANGE
Spreadsheet: 715735d1611846581-help-reducing-the-amount-of-formulas-to-show-the-sum-attendance-sample-for-excel-help
Sheet: Vacation

 | Use the down arrow on the table headings to filter what information you want to see, I usually filter out year PTO / Carry over hours For duplicate entries the column on the far left will highlight red Dates highlighted in green are future dates
 | Duplicate | Employee | Start Date | Vacation Type | PTO Vacation Type | Amount of Hrs | Notes
 |  | Jones, [NAME] | 2021-01-01 00:00:00 | PTO Carry Over | PTO Carry Over | 13.25
 |  | Jones, [NAME] | 2021-01-01 00:00:00 | NEW SHORT NOTICE | NEW SHORT NOTICE | 40
 |  | Jones, [NAME] | 2021-01-01 00:00:00 | NEW PTO | NEW PTO | 96
 |  | Jones, [NAME] | 2021-01-08 00:00:00 | Vacation - Scheduled | Vacation - Scheduled | 1 | [NAME]
 |  | Jones, [NAME] | 2021-01-12 00:00:00 | Vacation - Scheduled | Vacation - Scheduled | 0.75 | [NAME]
 |  | Jones, [NAME] | 2021-01-13 00:00:00 | Vacation - Scheduled | Vacation - Scheduled | 0.25 | [NAME]
 |  | Jones, [NAME] | 2021-01-14 00:00:00 | Tardy |  |  | 08:01:00
 |  | Jones, [NAME] | 2021-01-15 00:00:00 | Vacation - Scheduled | Vacation - Scheduled | 2 | [NAME]
 |  | Jones, [NAME] | 2021-01-06 00:00:00 | Forgot Time Punch |  |  | In
 |  | Jones, [NAME] | 2021-01-06 00:00:00 | Short Notice | Short Notice | 2 | [NAME]
Spreadsheet: 845981d1697275522-how-to-get-unique-data-from-two-column-book2
Sheet: Sheet1

Unique Data | Data Collection from Column A |  | Value
350317671237273 | 350317671237273 |  | 359885853397124
350317671211781 | 350317671211781 |  | 353828958235159
359885852133686 | 359885852133686 |  | 353598490915069
353828958128776 | 353828958128776 |  | 353598490960396
355895960535791 | 355895960535791 |  | 353598490611171
353828958230234 | 353828958230234 |  | 351465071837082
353598491067126 | 353598491067126 |  | 357567590936313
350862310060669 | 350862310060669 |  | 359885852128520
350862310060644 | 350862310060644 |  | 353598491066664
350568490088798 | 350568490088798 |  | 353598490670151
350317671214827 | 350317671214827 |  | 351465072088271
359885853397124 |  |  | 353598490978620
353828958235159 |  |  | 353828955042004
353598490915069 |  |  | 350568490762079
353598490960396 |  |  | 350568490344498
353598490611171 |  |  | 350568490095421
351465071837082
357567590936313
359885852128520
353598491066664
353598490670151
351465072088271
353598490978620
353828955042004
350568490762079
350568490344498
350568490095421