tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 730815d1619965928-help-with-building-a-revenue-cost-spreadheet-fdg-test-file
Sheet: Main Sheet

 |  |  |  |  |  |  | July | August | September | October | November | December | January | February | March | April | May | June | July | August | September | October | Nov | Dec
Role | [NAME] | End Date | Daily Rate | Contractor first Payment Date | Contractor first Payment Fortnight |  | When Candidates are Working
Apps/Integration Tester (Scripting skills) | 2021-09-01 00:00:00 | 2022-09-30 00:00:00 | 100 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 0.5 | 1 | 1 | 1 | 1 | 1 | 1
Apps/Integration Tester (Scripting skills) | 2021-09-01 00:00:00 | 2022-09-30 00:00:00 | 100 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 0.5 | 1 | 1 | 1 | 1 | 1 | 1
AWS Integration Dev | 2021-07-01 00:00:00 | 2022-03-31 00:00:00 | 100 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5
AWS Integration Dev |  |  | 100 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5
AWS Integration Dev |  |  | 100 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5
AWS Integration Dev |  |  | 100 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5
Business Analyst |  |  | 100 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Business Analyst |  |  | 100 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5
Business Analyst |  |  | 100 |  |  |  | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5
Business Analyst |  |  | 100 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 0.5
Change Manager |  |  | 100 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 0.5 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] |  |  | 100 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
DevOps Engineer |  |  | 100 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5
Integration Dev |  |  | 100 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Integration Dev |  |  | 100 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5
Licensing Analysis |  |  | 100 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5 | 1 | 1 | 1
Scrum Lead |  |  | 100 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5
Security Engineer |  |  | 100 |  |  |  | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4
Solution Architect |  |  | 100 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5
[NAME] (Win/Lin) |  |  | 100 |  |  |  |  |  | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.5 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6
Test Analyst (Scritpting skills) |  |  | 100 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Test Analyst (Scritpting skills) |  |  | 100 |  |  |  |  | 0.6 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Test Analyst (Scritpting skills) |  |  | 100 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5
Transition Support (Change Mngt) |  |  | 100 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 0.5 | 1 | 1 | 1 | 1 | 1 | 1
Transition Support (Change Mngt) |  |  | 100 |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 0.5 | 1 | 1 | 1 | 1 | 1 | 1
Transition Support (Change Mngt) |  |  | 100 |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 0.5 | 1 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 112515d1308635736-countif-for-two-criteria-calculation
Sheet: Stats

 | Stats (desired result)
Item | Current Formula | Desired Result | Is formula ok?
Number of cells contain "may be RM" in remark column | 3 | 3 | ok
Number of cells contain "may be RM" in remark column G and PCT in column H (both criteria) | 0 | 2 | not matched
number of blank cell, exclude Sav product | #N/A | 2 | not matched
number of blank cell | 6 | 6 | ok
Spreadsheet: mark_taylor__25054__105657 - O&M 063001
Sheet: Headcount - 105656

 | ENRON NORTH AMERICA
 | ENA - Legal Litigation (105656)
 | HEADCOUNT AS OF 06-30-01
Employee | Co | Team | Job Title | Headcount
SANDERS,RICHARD B | 413 | ENA - Legal | Vice President | 1
 |  |  | Total | 1
BROWNFELD, [NAME] | 413 | ENA - Legal | [NAME] | 1
 |  |  | Total | 1
BLAINE, MICHELLE | 413 | ENA - Legal | SR Counsel | 1
EDISON, ANDREW | 413 | ENA - Legal | SR Counsel | 1
 |  |  | Total
[NAME],[NAME] | 413 | ENA - Legal | Other Non-commercial | 1
MERAZ,CLAUDIA | 413 | ENA - Legal | Other Non-commercial | 1
SWEET, TWANDA | 413 | ENA - Legal | Other Non-commercial | 1
[NAME], STEPHANIE | 413 | ENA - Legal | Other Non-commercial | 1
 |  |  | Total
 |  |  | Total for 105656
Spreadsheet: 475652d1471390649-auto-copy-cells-to-another-sheet-test-barcode-timer-xlsx
Sheet: MOE

Moe | CLIENT START |  |  | CLIENT STOP
Moe | 66598 | 2016-08-15 00:00:00 | 16:03:00
Moe
Moe
Moe
Moe
Moe
Moe
Moe
Moe
Moe
Moe
Moe
Moe
Moe
Moe
Moe
Moe
Moe
Moe
Moe
Moe
Moe
Moe
Moe
Spreadsheet: 526137d1499158255-extract-numbers-for-given-creteria-excluding-duplicates-extract-numbers-for-given-creteria-excluding-duplicates
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Input |  | Desired output by formula
 |  |  |  |  |  |  | 168 | CAB |  | CAB |  | 168
 |  |  |  |  |  |  | 764 | BBB |  |  |  | 503
 |  |  |  |  |  |  | 686 | CCC |  |  |  | 708
 |  |  |  |  |  |  | 804 | BAC |  |  |  | 360
 |  |  |  |  |  |  | 510 | ACB |  |  |  | 625
 |  |  |  |  |  |  | 174 | ACB |  |  |  | 870
 |  |  |  |  |  |  | 217 | BCA |  |  |  | 888
 |  |  |  |  |  |  | 139 | CBA |  |  |  | 622
 |  |  |  |  |  |  | 624 | ABC |  |  |  | 326
 |  |  |  |  |  |  | 627 | CBA
 |  |  |  |  |  |  | 418 | CCC
 |  |  |  |  |  |  | 122 | AAA
 |  |  |  |  |  |  | 503 | CAB
 |  |  |  |  |  |  | 736 | AAA
 |  |  |  |  |  |  | 767 | CCC
 |  |  |  |  |  |  | 367 | ABC
 |  |  |  |  |  |  | 777 | BCA
 |  |  |  |  |  |  | 708 | CAB
 |  |  |  |  |  |  | 819 | BCA
 |  |  |  |  |  |  | 828 | BBB
 |  |  |  |  |  |  | 114 | ABC
 |  |  |  |  |  |  | 803 | BBB
 |  |  |  |  |  |  | 766 | AAA
 |  |  |  |  |  |  | 655 | BCA
 |  |  |  |  |  |  | 536 | ACB
 |  |  |  |  |  |  | 436 | AAA
 |  |  |  |  |  |  | 811 | ABC
 |  |  |  |  |  |  | 950 | CBA
 |  |  |  |  |  |  | 360 | CAB
 |  |  |  |  |  |  | 708 | CAB
 |  |  |  |  |  |  | 912 | BBB
 |  |  |  |  |  |  | 434 | CCC
 |  |  |  |  |  |  | 494 | AAA
 |  |  |  |  |  |  | 269 | ABC
 |  |  |  |  |  |  | 434 | CBA
 |  |  |  |  |  |  | 956 | AAA
 |  |  |  |  |  |  | 283 | BBB
 |  |  |  |  |  |  | 473 | BBB
 |  |  |  |  |  |  | 827 | CCC
 |  |  |  |  |  |  | 181 | AAA
 |  |  |  |  |  |  | 983 | ACB
 |  |  |  |  |  |  | 313 | CBA
 |  |  |  |  |  |  | 470 | BAC
 |  |  |  |  |  |  | 386 | CBA
 |  |  |  |  |  |  | 989 | AAA
 |  |  |  |  |  |  | 780 | CCC
 |  |  |  |  |  |  | 625 | CAB
 |  |  |  |  |  |  | 779 | BBB
 |  |  |  |  |  |  | 680 | AAA
 |  |  |  |  |  |  | 870 | CAB
 |  |  |  |  |  |  | 311 | BAC
 |  |  |  |  |  |  | 551 | BCA
 |  |  |  |  |  |  | 638 | BBB
 |  |  |  |  |  |  | 215 | BCA
 |  |  |  |  |  |  | 879 | BBB
 |  |  |  |  |  |  | 888 | CAB
 |  |  |  |  |  |  | 948 | ACB
 |  |  |  |  |  |  | 271 | BBB
 |  |  |  |  |  |  | 477 | CCC
 |  |  |  |  |  |  | 110 | AAA
 |  |  |  |  |  |  | 468 | CBA
 |  |  |  |  |  |  | 638 | AAA
 |  |  |  |  |  |  | 312 | CCC
 |  |  |  |  |  |  | 799 | CCC
 |  |  |  |  |  |  | 300 | BAC
 |  |  |  |  |  |  | 217 | BBB
 |  |  |  |  |  |  | 808 | ACB
 |  |  |  |  |  |  | 708 | CAB
 |  |  |  |  |  |  | 814 | BBB
 |  |  |  |  |  |  | 622 | CAB
 |  |  |  |  |  |  | 855 | BAC
 |  |  |  |  |  |  | 666 | BCA
 |  |  |  |  |  |  | 258 | BAC
 |  |  |  |  |  |  | 888 | CAB
 |  |  |  |  |  |  | 974 | BAC
 |  |  |  |  |  |  | 708 | CAB
 |  |  |  |  |  |  | 326 | CAB
 |  |  |  |  |  |  | 691 | CBA
 |  |  |  |  |  |  | 845 | CCC
 |  |  |  |  |  |  | 588 | CBA
 |  |  |  |  |  |  | 493 | CCC
 |  |  |  |  |  |  | 136 | BBB
 |  |  |  |  |  |  | 632 | ACB
 |  |  |  |  |  |  | 437 | AAA
 |  |  |  |  |  |  | 163 | AAA
 |  |  |  |  |  |  | 279 | BAC
 |  |  |  |  |  |  | 719 | AAA
 |  |  |  |  |  |  | 162 | CCC
Spreadsheet: 93437d1293021029-formula-needed-to-fetch-data-from-different-worksheets-and-include-adjacent-cells-copy-of-core-staff-leave-2010
Sheet: CX

CX
HOLIDAYS TAKEN
2010
Friday | 1900-09-24 00:00:00 | CX
Tuesday | 1900-10-12 00:00:00 | CX | SICKNESS TAKEN AS HOLIDAY
Wednesday | 1900-10-13 00:00:00 | CX | SICKNESS TAKEN AS HOLIDAY
Thursday | 1900-10-14 00:00:00 | CX | SICKNESS TAKEN AS HOLIDAY
Friday | 1900-10-15 00:00:00 | CX | SICKNESS TAKEN AS HOLIDAY
Tuesday | 1900-11-09 00:00:00 | CX
Wednesday | 1900-11-10 00:00:00 | CX
Thursday | 1900-11-11 00:00:00 | CX
Friday | 1900-11-12 00:00:00 | CX
Monday | 1900-11-15 00:00:00 | CX
Tuesday | 1900-11-16 00:00:00 | CX
Wednesday | 1900-11-17 00:00:00 | CX
Thursday | 1900-11-18 00:00:00 | CX
Friday | 1900-11-19 00:00:00 | CX
Monday | 1900-11-22 00:00:00 | CX
Tuesday | 1900-11-23 00:00:00 | CX
STATUTORY |  | 8
SEE E-MAIL 02/12/2010 |  | 4
Spreadsheet: 838085d1690703479-change-sheet-refernce-incrementally-in-adjacent-cells-2023-league-standings-sample-hd
Sheet: T17

Team # | Team Name | Permanent Bowler | Reserves | Lineup | Average | Handicap |  |  |  | Game 1 Scratch | Game 1 Handicap | Game 2 Scratch | Game 2 Handicap | Game 3 Scratch | Game 3 Handicap | Scratch Series | Handicap Series | Indiv Points
17 | Angry Balls | Player51 |  |  |  |  |  |  | Week 1
 |  | Player52 |  |  |  |  |  |  | Week 2
 |  | Player53 |  |  |  |  |  |  | Week 3
 |  |  |  |  |  |  |  |  | Week 4
 |  |  |  |  |  |  |  |  | Week 5
 |  |  |  |  |  |  |  |  | Week 6
 |  |  |  |  |  |  |  |  | Week 7
 |  |  |  |  |  |  |  |  | Week 8
 |  |  |  |  |  |  |  |  | Week 9
 | [NAME] |  |  |  |  |  |  |  | Week 10
 |  | Player51 | 0 |  |  |  |  |  | Week 11
 |  | Player52 | 114 |  |  |  |  |  | Week 12
 |  | Player53 | 99 |  |  |  |  |  | Week 13
 |  | Player54 | 141 |  |  |  |  |  | Week 14
 |  |  |  |  |  |  |  |  | Week 15
 |  |  |  |  |  |  |  |  | Week 16
 |  | Vacant |  |  |  |  |  |  | Week 17
 |  |  |  |  |  |  |  |  | Week 18
 |  |  |  |  |  |  |  |  | Week 19
 | Reserves Lookup |  | Average |  |  |  |  |  | Week 20
 |  |  |  |  |  |  |  |  | Week 21
 |  |  |  |  |  |  |  |  | Week 22
 |  |  |  |  |  |  |  |  | Week 23
 |  |  |  |  |  |  |  |  | Week 24
 |  |  |  |  |  |  |  |  | Week 25
 |  |  |  |  |  |  |  |  | Week 26
 |  |  |  |  |  |  |  |  | Week 27
 |  |  |  |  |  |  |  |  | Week 28
 |  |  |  |  |  |  |  |  | Week 29
 |  |  |  |  |  |  |  |  | Week 30
 |  |  |  |  |  |  |  |  | Week 31
 |  |  |  |  |  |  |  |  | Week 32
 |  |  |  |  |  |  |  |  | Week 33
 |  |  |  |  |  |  |  |  | Week 34
 |  |  |  |  |  |  |  |  | Week 35
 |  |  |  |  |  |  |  |  | Week 36
 | VLOOKUP(B11,C11:C18,1,FALSE) |  |  |  |  |  |  |  | Week 37
 |  |  |  |  |  |  |  |  | Week 38
 |  |  |  |  |  |  |  |  | Week 39
 |  |  |  |  |  |  |  |  | Week 40
 |  |  |  |  |  |  |  |  | Week 41
 |  |  |  |  |  |  |  |  | Week 42
 |  |  |  |  |  |  |  |  | Week 43
 |  |  |  |  |  |  |  |  | Week 44
 |  |  |  |  |  |  |  |  | Week 45
Spreadsheet: 0db1224c-4a5d-4c4a-8255-4cccf13bacd4
Sheet: Sheet1

BLS & PALS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | UPDATE COURSE
 | DATE:
AGENDA
8:00 am - 8:15 am |  |  | Introduction/Overview
8:15 am - 10:00 am |  |  | BLS Skills Stations Rotation
 |  |  | & Written Examination
 |  | Instructors |  |  | Station Rotations - 25 Min. Each
 |  | (Office Use Only)
 |  |  |  |  | Adult
 |  |  |  |  | Child
 |  |  |  |  | Infant
 |  |  |  |  | AED
10:00 am - 10:15 am |  |  | BREAK
10:15 am - 11:45 am |  |  | Overview of PALS Science & Pediatric Assessment
 |  |  | Resuscitation Team Concepts
 |  |  | Core Case Review (Watch and Learn Video Presentation)
 |  |  | Coping with Death
11:45 am  - 12:45 pm |  |  | LUNCH ON YOUR OWN
12:45 pm - 4:45 pm |  |  | Teaching Stations/Megacode
 |  |  | Teaching Stations     12:45 pm - 2:45 pm
 |  |  | Megacode Testing    2:45 pm - 4:15 pm
 |  |  | Written Examination   4:15 pm - 4:45 pm
Instructors |  |  | Station |  |  | 12:45 | 1:15 | 1:45 | 2:15
(Office Use Only) |  |  |  |  |  | - | - | - | -
 |  |  |  |  |  | 1:15 | 1:45 | 2:15 | 2:45
 |  |  | Vascular Access
 |  |  | Shock Core Cases (5-8)
 |  |  | Trauma
 |  |  | Medication Calculations
 |  |  | Rhythm Disturbances      Cardiac Core Cases (9-12)
 |  |  | Respiratory Emergencies
 |  |  | Respiratory Core Cases (1-4)
BATHROOM BREAK - STUDENTS & INSTRUCTORS
All Instructors |  |  | Megacodes |  |  | [NAME]
 |  |  |  |  |  | (2:55 pm - 4:15 pm)
Course Coordinator |  |  | Written Evaluation |  |  | 4:15 pm - 4:45 pm
 | NOTE: It is the practice of the Department of Life Support Education at WFUBMC, that textbooks or other materials are not utilized during testing of course participants.
Spreadsheet: 23089d1212506718-19xx-and-20xx-problem-dateproblem
Sheet: Sheet1

Date
11-19-99
7-27-06
8-28-06
7-26-06
3-13-07
7-11-05
11-10-06
5-27-05
12-4-06
10-28-05
7-31-06
2-24-05
8-17-06
7-7-06
10-31-05
5-5-06
3-22-06
9-29-06
7-1-05
10-25-06
4-20-07
8-12-03
5-24-04
12-10-04
8-7-06
10-21-04
3-31-06
2-27-06
8-18-06
4-20-06
5-20-02
6-30-05
4-29-03
12-29-05
8-30-06
6-9-05
4-26-06
8-31-05
3-1-07
12-22-05
12-22-06
5-29-97
6-26-98
11-18-04
4-25-07
10-17-06
11-4-05
6-5-06
2-5-07
8-27-07
8-4-06
1-24-05
12-8-06
6-13-07
3-8-05
2-12-99
5-16-07
4-26-07
4-21-06
1-25-07
3-30-06
1-10-06
3-1-04
5-25-07
9-29-06
5-21-01
1-25-07
12-29-06
2-25-05
5-10-05
2-28-05
11-18-05
4-3-02
2-28-06
2-28-07
2-12-07
6-23-06
8-13-99
2-10-95
3-27-06
7-24-03
5-24-04
6-17-03
6-19-07
3-15-04
7-22-05
11-9-07
10-4-07
9-20-06
3-8-02
4-26-07
10-26-07
1-9-07
11-18-05
7-27-07
1-26-07
8-2-06
3-8-07
3-5-90
3-9-07
6-5-07
1-19-07
5-5-06
6-21-04
3-2-07
8-31-06
8-15-06
1-31-07
10-29-07
3-26-07
5-15-06
8-2-01
12-21-06
12-21-05
3-10-05
7-25-05
9-15-06
11-29-06
5-18-01
2-9-07
6-27-07
7-26-04
10-10-01
3-20-06
12-22-06
9-22-06
1-11-07
7-31-06
8-18-09
1-25-05
12-28-05
9-25-06
3-21-06
12-29-05
2-23-07
6-29-06
5-28-04
5-31-06
9-29-06
1-31-07
5-25-05
11-21-06
5-25-05
3-9-07
2-1-07
6-17-05
11-4-05
12-17-04
12-29-05
8-31-06
3-9-06
5-18-07
9-21-06
3-3-06
8-31-07
10-30-03
12-21-06
11-14-05
9-22-06
12-22-05
4-15-05
8-29-03
11-14-05
1-5-07
10-19-05
6-13-03
2-22-07
6-24-02
7-21-06
9-20-06
10-30-03
2-23-05
11-9-04
11-27-06
6-29-07
5-25-07
5-18-04
5-16-07
12-27-05
4-16-07
4-3-06
3-8-06
7-5-07
9-7-99
1-15-03
2-19-03
3-28-06
1-2-03
2-8-02
8-7-06
12-14-04
4-24-06
3-25-05
11-14-06
8-17-07
8-24-02
11-5-04
3-5-04
6-15-04
7-6-06
1-16-07
3-10-06
3-26-07
2-10-06
3-10-06
3-5-04
1-10-07
1-17-07
5-21-05
12-29-06
9-26-05
3-27-06
4-6-98
3-22-07
3-8-06
9-16-05
7-9-03
1-12-07
4-13-04
10-31-05
12-29-05
10-28-92
1-22-07
6-2-05
11-11-04
1-30-06
6-26-06
10-17-03
4-27-04
4-21-06
10-17-07
3-31-05
2-7-06
8-4-06
10-3-05
1-18-07
10-25-06
11-25-06
4-21-06
3-24-05
9-13-04
3-4-05
3-20-07
7-12-06
10-11-06
4-28-06
10-17-07
4-12-06
12-29-05
6-20-06
3-20-07
9-27-05
12-27-06
5-30-03
1-31-04
3-3-06
8-31-05
7-167-07
6-13-03
7-14-06
10-2-03
10-13-05
1-9-06
5-26-05
1-15-07
7-26-07
10-27-06
10-5-05
8-29-06
11-16-04
9-10-04
8-22-06
9-28-06
10-28-05
11-22-06
3-9-06
4-29-06
3-8-07
4-17-07
2-20-07
1-30-06
7-29-06
6-26-06
12-14-06
9-5-06
8-10-07
1-10-05
8-22-05
6-28-05
11-18-05
10-27-06
2-14-06
9-28-07
11-17-05
Spreadsheet: 216304d1361711688-find-add-and-return-values-from-multiple-worksheets-time-spent-on-course
Sheet: Sheet2

Name | Course A | Time spent | Course B | Time spent | Course C | Time spent | Course D | Time spent
Adam | English | 1 | Maths | 3 | Science | 4 | History | 2
Eve | Maths | 2 | Geography | 1 | Science | 2
[NAME] | Maths | 3 | Geography | 1 | History | 2
Spreadsheet: 9b1fe2cb-0d27-4520-a272-ae512ce33133
Sheet: Sheet1

Girls BGC 2014 | Unnamed: 1 | [NAME] | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
1/25 - 5 sites Coed |  |  |  |  | 2014 Girls Bracket
1/27 - 3 sites Boys
1/28 - 3 sites Girls |  | Bye
1/30 - 2 sites Boys
1/31 - 2 sites Girls |  |  | Game 8  1/28/14
2/1 - 1 site 4 games |  | Twin Cedars | @Murray 7:30
 |  | Game 1 1/25/14
 |  | @Faith Baptist 6:00
 |  | [NAME]
 |  |  |  | Game 14  1/31/14
 |  | Lamoni |  | @ Seymour 7:30
 |  | Game 2   1/25/14
 | Game 6  1/28/14 | @Lamoni 7:30
 |  | Diagonal
 |  |  | Game 9  1/28/14
 |  | Moravia | @Murray 6:00
 |  | Game 3  1/25/14
 |  | @ACA 7:30
 |  | Orient-Macksburg
 |  |  |  |  | Game 17  2/1/14
 |  | Grandview Park |  |  | @ Seymour 6:00 | 2014 Champion
 |  | Bye
 |  |  | Game 10  1/28/14
 |  | Iowa Christian | @ACA 6:00
 |  | Game 4  1/25/14
 |  | @Humeston 6:00
 |  | [NAME]
 |  |  |  | Game 15  1/31/14
 |  | Ankeny Christian |  | @ Seymour 6:00
 | Game 7 1/28/14
 |  | Bye
 |  |  | Game 11  1/28/14
 |  | Melcher-Dallas | @ACA 7:30
 |  | Game 5  1/25/14
 |  | @Melcher-Dallas 7:30
 |  |  |  |  | Loser of G#14
 |  | Moulton-Udell |  |  | Game 16  2/1/14
 |  |  |  |  | @ Seymour 2:30
 |  |  | [NAME] |  | Loser of G#15
 |  |  | Game 12  1/31/14
 |  |  | Loser of G#9
 |  |  | Loser of G#10
 |  |  | Game 13  1/31/14
 |  |  | Loser of G#11
Spreadsheet: 829463d1684238493-tricky-lookup-with-ifs-book1
Sheet: MASTERDATA

ID1 | ID2 | Comments
11233
11234
11235
11236
11237
11238
11239
11240
11241
11242
Spreadsheet: 68975d1269511707-rounding-to-a-value-from-a-list-price_conversion_2
Sheet: Sheet2

2.7
3.6
4.6
5.5
6.3
6.9
7.9
8.9
11.9
13.9
14.9
15.9
17.9
19.9
22.9
24.9
26.9
31.9
35.9
40.9
44.9
49.9
53.9
59.9
62.9
67.9
71.9
76.9
79.9
85.9
89.9
99.9
109.9
112.9
119.9
121.9
129.9
130.9
135.9
139.9
143.9
149.9
149.9
159.9
169.9
179.9
189.9
199.9
209.9
219.9
229.9
239.9
245.9
249.9
259.9
269.9
Spreadsheet: diana_scholtes__8545__Financial Power Terminated
Sheet: AS of 12-14

Financial Power Transactions Terminated
 | Counterparty Name | Trades Terminated | Early Termination Date
 | AES Eastern Energy LP | 775220, 814567, 821656, 821666, 842776, [NAME], 857752 | 2001-12-11 00:00:00
 | AIG [NAME], LLC | Deal # 616996.01 | 2001-12-06 00:00:00
 | Allegheny Energy Supply Company, LLC | All trades | 2001-12-03 00:00:00
 | American Electric Power Service Corporation | All trades | 2001-12-03 00:00:00
 | Aquila Risk Management Corporation | All trades | 2001-11-29 00:00:00
 | BP Corporation North America Inc. | All trades | 5:00 p.m. 12/3/2001
 | Calpine Energy Services L.P. | All trades | 2001-12-10 00:00:00
 | Cargill, Incorporated | Deal # 813178.01 | 2001-12-03 00:00:00
 | Consolidated Edison Energy, Inc. | All trades | 2001-12-05 00:00:00
 | Coral Energy Holding, L.P. | All trades | 2001-12-05 00:00:00
 | Duke Energy Trading and Marketing, L.L.C. | All trades | 2001-12-04 00:00:00
 | El Paso Merchant Energy, L.P. | All trades | 2001-12-03 00:00:00
 | Engage Energy America LLC | All trades | 2001-12-03 00:00:00
 | Engage Energy Canada, L.P. | 633424.01, 633418.01 | 2001-12-03 00:00:00
 | Entergy-Koch Trading, LP | All trades | 2001-12-03 00:00:00
 | Exelon Generation Company, LLC | All trades | 4:00 p.m. 12/5/2001
 | Maclaren Energy Inc. | All trades | 2001-11-30 00:00:00
 | Mirant Americas Energy Marketing, LP | All trades | 2001-11-28 00:00:00
 | New Power Company, The | All trades | 2001-12-03 00:00:00
 | NRG Power Marketing, Inc. | All trades | 2001-12-03 00:00:00
 | PPL EnergyPlus, LLC | All trades | 2001-12-04 00:00:00
 | Tractebel Energy Marketing, Inc. | All trades | 2001-12-03 00:00:00
 | Williams Energy Marketing & Trading Company | All trades | 2001-12-03 00:00:00
Spreadsheet: 824961d1680979835-array-formula-keep-using-the-1st-row-as-reference-question
Sheet: Sheet3

 |  |  |  |  |  |  | Start Date |  |  |  | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00
 |  |  |  |  |  |  | End Date |  |  |  | 2021-09-30 00:00:00 | 2021-10-31 00:00:00 | 2021-11-30 00:00:00 | 2021-12-31 00:00:00
Asset Category | Asset Number | Dep Start Date | Dep End Date | Per day |  | Computer | Asset Category | Dep Start Date | Dep End Date | Per day
Furniture and Fixetures | FT-AT-0001 | 2021-01-31 00:00:00 | 2026-01-30 00:00:00 | 147.5898138006572
Furniture and Fixetures | OE-BKK728 | 2021-01-31 00:00:00 | 2026-01-30 00:00:00 | 147.5898138006572 |  |  | Computer | 2021-01-31 00:00:00 | 2026-01-30 00:00:00 | 150 |  |  |  |  | <---- Why does the formula stop?
Computer | AAA | 2022-01-31 00:00:00 | 2026-01-30 00:00:00 | 150
Computer | AAA | 2021-01-31 00:00:00 | 2026-01-30 00:00:00 | 150
Spreadsheet: 767249d1644362307-find-if-values-across-2-columns-exist-in-another-column-power-query-inner-merge-myar-
Sheet: Sheet1

EDC Subject | EDC Date |  | Lab Subject | Specimen Collection Date | SMART Specimen Status |  | Output example
114-602 | 2021-06-25 00:00:00 |  | 103-601 | 2019-03-01 00:00:00 | Packaged - Referral Site |  | 103-602 | 2019-03-01 00:00:00 | Packaged - Referral Site |  | Lab Subject | Specimen Collection Date | SMART Specimen Status
138-602 | 2018-07-17 00:00:00 |  | 103-602 | 2019-03-01 00:00:00 | Packaged - Referral Site |  |  |  |  |  | 114-602 | 2021-06-25 00:00:00 | Packaged - Referral Site
138-603 | 2018-07-17 00:00:00 |  | 103-603 | 2019-03-01 00:00:00 | Available |  |  |  |  |  | 103-602 | 2019-03-01 00:00:00 | Packaged - Referral Site
138-614 | 2018-08-03 00:00:00 |  | 103-604 | 2019-03-01 00:00:00 | Available
138-618 | 2018-08-07 00:00:00 |  | 103-605 | 2019-03-01 00:00:00 | Packaged - Referral Site
138-619 | 2018-08-07 00:00:00 |  | 103-606 | 2019-04-22 00:00:00 | Packaged - Referral Site
138-623 | 2018-08-13 00:00:00 |  | 103-607 | 2019-04-22 00:00:00 | Available
138-624 | 2018-08-13 00:00:00 |  | 103-608 | 2019-04-22 00:00:00 | Available
138-627 | 2018-08-15 00:00:00 |  | 103-609 | 2019-04-22 00:00:00 | Packaged - Referral Site
138-630 | 2018-08-15 00:00:00 |  | 103-610 | 2019-04-22 00:00:00 | Packaged - Referral Site
103-602 | 2019-03-01 00:00:00 |  | 103-611 | 2019-05-03 00:00:00 | Packaged - Referral Site
 |  |  | 114-602 | 2021-06-25 00:00:00 | Packaged - Referral Site |  | <<Date changed after the merge table was produced.
 |  |  | To get the Merge1 table
 |  |  | 1. From the Data tab select Get Data then Combine Queries and then [NAME]
 |  |  | 2. In the merge dialog box select LabTable in the drop down at the top and EDCTable from the second drop down
 |  |  | 3. Under the first drop down highlight the columns for Lab Subject and Specimen Collection Date
 |  |  | 4. Under the second drop down select the columns for EDC Subject and EDC Date
 |  |  | 5. From the bottom drop down select [NAME] (Only matching rows)
 |  |  | 6. Select OK
 |  |  | 7. Select Close and Load to
 |  |  | 8. Select a location for the [NAME] table
 |  |  | Let us know if you have any questions.
 |  |  | The resulting code:
 |  |  | let
 |  |  | Source = Table.NestedJoin(LabTable, {"Lab Subject", "Specimen Collection Date"}, EDCTable, {"EDC Subject", "EDC Date"}, "EDCTable", JoinKind.[NAME]),
 |  |  | #"Removed Columns" = Table.RemoveColumns(Source,{"EDCTable"})
 |  |  | in
 |  |  | #"Removed Columns"
Spreadsheet: darrell_schoolcraft__7792__imbalsumm0107
Sheet: NS Steel

 | North Star Steel
 | POI 500383 - North Start Steel IC
Day | Measured | Scheduled
1 |  | -2198
2 | -2087 | -3232
3 | -2 | -2673
4 | -2087 | -2139
5 | -2087 | -1056
6 | -2087 | -1501
7 | -2 | -2139
8 |  | -2139
9 | -2087 | -2139
10 | -2087 | -1187
11 | -2087 | -2139
12 | -2087 | -2139
13 | -2087 | -3500
14 | -2 | -2139
15 | -2087 | -2139
16 | -1977 | -2139
17 | -1958 | -2671
18 | -1775 | -2139
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-06-30 00:00:00 |  |  | -354102.16
2001-07-18 00:00:00
Spreadsheet: 886483d1736502632-help-needed-with-date-calculations-warranty-records
Sheet: Sheet1

 | PURCHASE  ITEM  WARRANTY  STATUS  [NAME]
 | [NAME]UNDER WARRANTY | PLACE OF PURCHASE | ORIGINAL COST | MODEL # | SERIAL NUMBER | DATE OF PURCHASE | CURRENT DATE | WARRANTY DURATION IN YEARS | WARRANTY TIME ELAPSED | WARRANTY TIME REMAINING
 | A.O. Smith Water Heater | Lowes | 2021.36 | HP10 | 174710XYZ8311668 | 2017-11-21 00:00:00 |  | 10
 |  |  |  |  |  |  | 2027-11-21 00:00:00 | 10
 |  |  |  |  |  |  | 2027-11-20 00:00:00 | 10