tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0a8791de-84e4-4eb4-bfac-22483612972b
Sheet: Respiratory Care

RESPIRATORY CARE
Associate in Applied Science
Student Name: | ACT | GPA
Student ID: | ________ | ________
Prerequisites | Semester | Grade
___ BIO 137 (4) Human Anatomy & Physiology I
___ MAT 110 (3) Applied Mathematics OR ___ MAT 150 (3) College Algebra
General Education and Support Courses
___BIO 139 (4) Human Anatomy & Physiology II
___ PSY 110 (3) General Psychology OR ___ SOC 101 Intro to Sociology
___ ENG 101 (3) Writing I
___ COM 181 (3) OR ___ COM 252 (3) Oral Communication
___ CIT 105 (3) Intro to Computers OR ___ IC3 Computer Literacy Exam
___ Heritage/Humanities (3)
[NAME] and Support courses may be taken prior to or in conjunction with RCP courses.
Fall Semester
___ RCP 110 ( 3) Cardiopulmonary Anatomy & Physiology
___ RCP 120 (4) Theory and Practice in Respiratory Care
___ RCP 130 (3) Pharmacology
___ RCP 150 (2) Clinical Practice I
Spring Semester
___ RCP 135 (4) Cardiopulmonary Evaluation
___ RCP 180 Ventilartory Support
___ RCP 175 (3) Clinical Practice II
___ RCP 204 (3) Emergency & Special Procedures
Summer Session
___ RCP 200 (3) Clinical Practice III
Fall Semester
___ RCP 190 (2) Advanced Ventilatory Support
___ RCP 210 (3) Cardiopulmonary Pathophysiology
___ RCP 212 (3) Neonatal Pediatric Respiratory Care
___ RCP 235 (3) Clinical Practice IV
___ RCP 168 (2) Special Topics in Respiratory Care
Spring Semester
___ RCP 214 (3) Advanced Diagnostic Procedures
___ RCP 228 (2) Preventive and Long Term Care
___ RCP 250 (3) Clinical Practice V
___ RCP 169 (2) Special Topics in Respiratory Care
Updated Spring 2013
Class admitted each Fall on the Pineville and [NAME].
Southeast Kentucky Community & Technical College | Updated Spring 2013
Spreadsheet: 218463d1362472831-quantity-formula-when-several-options-are-selected-test
Sheet: Sheet1

415 |  |  |  |  |  |  | 380 | RED | E | 380REDE | 5
ORANGE |  |  | OUTPUT: | 15 |  |  | 208 | BLUE | F | 208BLUEF | 10
G |  |  |  |  |  |  | 415 | ORANGE | G | 415ORANGEG | 15
Spreadsheet: 736514d1623692582-finding-last-date-with-positive-number-in-dataset-lastdate
Sheet: Sheet1

 | 2021-01-01 00:00:00 | 2021-01-02 00:00:00 | 2021-01-03 00:00:00 | 2021-01-04 00:00:00 | 2021-01-05 00:00:00 | 2021-01-06 00:00:00 | 2021-01-07 00:00:00 | 2021-01-08 00:00:00 | 2021-01-09 00:00:00 | 2021-01-10 00:00:00 | 2021-01-11 00:00:00 | 2021-01-12 00:00:00 | 2021-01-13 00:00:00 | 2021-01-14 00:00:00
Cust 1 | -3 | -4 | 6 | -2 | 9 | -16 | -18 | -2 | 9 | -1 | -6 | -11 | -8
Cust 2 | -9 | 4 | -13 | -9 | -12 | -18 | 2 | -7 | 1 | -3 | -3 | -16 | -20 | 3
Spreadsheet: 685285d1593879942-fill-blanks-from-other-tabs-holiday-chart
Sheet: July

Name | Site |  |  | 2021-07-01 00:00:00 | 2021-07-02 00:00:00 | 2021-07-03 00:00:00 | 2021-07-04 00:00:00 | 2021-07-05 00:00:00 | 2021-07-06 00:00:00 | 2021-07-07 00:00:00 | 2021-07-08 00:00:00 | 2021-07-09 00:00:00 | 2021-07-10 00:00:00 | 2021-07-11 00:00:00 | 2021-07-12 00:00:00 | 2021-07-13 00:00:00 | 2021-07-14 00:00:00 | 2021-07-15 00:00:00 | 2021-07-16 00:00:00 | 2021-07-17 00:00:00 | 2021-07-18 00:00:00 | 2021-07-19 00:00:00 | 2021-07-20 00:00:00 | 2021-07-21 00:00:00 | 2021-07-22 00:00:00 | 2021-07-23 00:00:00 | 2021-07-24 00:00:00 | 2021-07-25 00:00:00 | 2021-07-26 00:00:00 | 2021-07-27 00:00:00 | 2021-07-28 00:00:00 | 2021-07-29 00:00:00 | 2021-07-30 00:00:00 | 2021-07-31 00:00:00 | Total holidays | Total sick days | Total training days | Total days in lieu | Total weekend working
A Sample | [NAME]
B
C
D
E
F
G
H
I
Spreadsheet: chris_germany__1826__EGAN_strg_NOV2000
Sheet: Nov-Jan

[NAME] Deal
Date | Pipeline | Price | Comm | Fuel | Trans | Del Price | Volume | Del Cost |  | TV Money | Storage | Jan Price |  | Dec Cost | NYMX
Generic | N/A | 5.925 |  | 0.00603 |  |  | 0 |  |  | 0.07 | 0.22
2000-11-30 00:00:00 | CGLF | 5.9 |  | 0.00603 |  |  | 0 |  |  | 0.07 | 0.22 |  |  |  | 6.24
2000-11-30 00:00:00 | TGT | 5.89 |  | 0.004 |  |  | 13025 |  |  | 0.07 | 0.22
2000-11-30 00:00:00 | ANR | 5.91 | 0 | 0 |  |  | 35000 |  |  | 0.07 | 0.22
 |  |  |  |  |  |  | Weighted Average |  |  |  |  | Weighted Avg Dec Cost
Spreadsheet: 216053d1361567133-problem-with-vlookup-upc-sample
Sheet: Sheet1

 | UPC |  | taken
1 | [PHONE]
2 | [PHONE]
3 | [PHONE]
4 | [PHONE]
5 | [PHONE]
6 | 848087011256
7 | 848087011362
8 | 848087011379
9 | [PHONE]
10 | [PHONE]
11 | [PHONE]
12 | [PHONE]
13 | [PHONE]
14 | [PHONE]
15 | [PHONE]
 | [PHONE]
Spreadsheet: 733584d1621631249-not-sure-how-to-tackle-this-sample-2-
Sheet: Sheet1 (2)

EMPID | EE_LAST_NM | EE_FST_MID_NM | ACCT_STATUS | TRUE_EMPL_STATUS | HISTORY_EMPL_STATUS | EE_HIRE_DT | EE_TERM_DT | EE_REHIRE_DT | HIRE_DATE_1 | TERM_DATE_1 | HIRE_DATE_2 | TERM_DATE_2 | HIRE_DATE_3 | TERM_DATE_3 | HIRE_DATE_4 | TERM_DATE_4 | HIRE_DATE_5 | TERM_DATE_5
10001 | DUCK | [NAME] | ACTIVE PARTICIPANT | TERMINATED | TERMINATED | 2016-08-15 00:00:00 | 2016-10-02 00:00:00 | 2016-09-17 00:00:00
10002 | [NAME] | MICKEY | ACTIVE PARTICIPANT | TERMINATED | TERMINATED | 2019-06-04 00:00:00 | 2019-09-23 00:00:00 | 2019-08-12 00:00:00
10003 | [NAME] | MINNIE | ACTIVE PARTICIPANT | TERMINATED | TERMINATED | 2020-02-27 00:00:00 | 2021-03-19 00:00:00
Spreadsheet: 793006d1661261549-formula-for-date-conversation-in-the-specific-format-sheet-1
Sheet: Sheet1

 | Date | Customer name |  |  | Customer name | Date visited
 | 2022-08-01 00:00:00 | Dominos |  |  | Dominos | 1, 7, 11
 | 2022-08-02 00:00:00 | Kfc |  |  | Kfc | 2, 9
 | 2022-08-03 00:00:00 | [NAME] |  |  | [NAME] | 3, 10
 | 2022-08-04 00:00:00 | Burger king |  |  | Burger king | 4, 8, 12
 | 2022-08-05 00:00:00 | la pinoz |  |  | la pinoz | 5
 | 2022-08-06 00:00:00 | pizza king |  |  | pizza king | 6, 13
 | 2022-08-07 00:00:00 | Dominos
 | 2022-08-08 00:00:00 | Burger king
 | 2022-08-09 00:00:00 | Kfc
 | 2022-08-10 00:00:00 | [NAME]
 | 2022-08-11 00:00:00 | Dominos
 | 2022-08-12 00:00:00 | Burger king
 | 2022-08-13 00:00:00 | pizza king
Spreadsheet: 860381d1708503859-re-arrange-of-row-depend-on-no-of-task-rearrange-row-with-space
Sheet: Reposition

Person | Task (No. of task may change from time to time) |  |  | Person | task |  |  |  | Desire result
A | task 1;task 2;task 3;task 4;task 5 |  | 1 | A | Task 1 |  |  |  | Want to rearrange the column A & B to Column E & F. The no. of task may change, In column F expend each task depend on column B.
B | task 1;task 2;task 3;task 4;task 5;task 6;task 7 |  | 2 |  | Task 2
C | task 1;task 2;task 3;task 4;task 5;task 6;task 7;task 8; |  | 3 |  | Task 3
D | task 1;task 2;task 3;task 4; |  | 4 |  | Task 4
E | task 1;task 2;task 3;task 4;task 5;task 6; |  | 5 |  | Task 5
F | task 1;task 2;task 3;task 4;task 5;task 6;task 7; |  | 6 | B | Task 1
G | task 1;task 2;task 3;task 4; |  | 7 |  | Task 2
H | task 1;task 2;task 3;task 4;task 5;task 6; |  | 8 |  | Task 3
I | task 1;task 2;task 3;task 4;task 5;task 6;task 7; |  | 9 |  | Task 4
J | task 1;task 2;task 3;task 4; |  | 10 |  | Task 5
K | task 1;task 2;task 3;task 4;task 5;task 6; |  | 11 |  | Task 6
L | task 1;task 2;task 3;task 4;task 5;task 6;task 7;task 8; |  | 12 |  | Task 7
 |  |  | 13 | C | Task 1
 |  |  | 14 |  | Task 2
 |  |  | 15 |  | Task 3
 |  |  | 16 |  | Task 4
 |  |  | 17 |  | Task 5
 |  |  | 18 |  | Task 6
 |  |  | 19 |  | Task 7
 |  |  | 20 |  | Task 8
 |  |  | 21 | D | Task 1
 |  |  | 22 |  | Task 2
 |  |  | 23 |  | Task 3
 |  |  | 24 |  | Task 4
 |  |  | 25 | E | Task 1
 |  |  | 26 |  | Task 2
 |  |  | 27 |  | Task 3
 |  |  | 28 |  | Task 4
 |  |  | 29 |  | Task 5
 |  |  | 30 |  | Task 6
 |  |  | 31 | F | Task 1
 |  |  | 32 |  | Task 2
 |  |  | 33 |  | Task 3
 |  |  | 34 |  | Task 4
 |  |  | 35 |  | Task 5
 |  |  | 36 |  | Task 6
 |  |  | 37 |  | Task 7
 |  |  | 38 | G | Task 1
 |  |  | 39 |  | Task 2
 |  |  | 40 |  | Task 3
 |  |  | 41 |  | Task 4
 |  |  | 42 | H | Task 1
 |  |  | 43 |  | Task 2
 |  |  | 44 |  | Task 3
 |  |  | 45 |  | Task 4
 |  |  | 46 |  | Task 5
 |  |  | 47 |  | Task 6
 |  |  | 48 | I | Task 1
 |  |  | 49 |  | Task 2
 |  |  | 50 |  | Task 3
 |  |  | 51 |  | Task 4
 |  |  | 52 |  | Task 5
 |  |  | 53 |  | Task 6
 |  |  | 54 |  | Task 7
 |  |  | 55 | J | Task 1
 |  |  | 56 |  | Task 2
 |  |  | 57 |  | Task 3
 |  |  | 58 |  | Task 4
 |  |  | 59 | K | Task 1
 |  |  | 60 |  | Task 2
 |  |  | 61 |  | Task 3
 |  |  | 62 |  | Task 4
 |  |  | 63 |  | Task 5
 |  |  | 64 |  | Task 6
 |  |  | 65 | L | Task 1
 |  |  | 66 |  | Task 2
 |  |  | 67 |  | Task 3
 |  |  | 68 |  | Task 4
 |  |  | 69 |  | Task 5
 |  |  | 70 |  | Task 6
 |  |  | 71 |  | Task 7
 |  |  | 72 |  | Task 8
 |  |  | 73
 |  |  | 74
 |  |  | 75
 |  |  | 76
 |  |  | 77
 |  |  | 78
 |  |  | 79
 |  |  | 80
 |  |  | 81
 |  |  | 82
 |  |  | 83
 |  |  | 84
 |  |  | 85
 |  |  | 86
 |  |  | 87
 |  |  | 88
 |  |  | 89
 |  |  | 90
Spreadsheet: 6a04b62f-0551-4034-bf03-0da5c96feeb7
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
44518004 | 2014-12-20 03:58:31 | AXIS | 1 | 6 | 3 | 1680804 | *player1680804 | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
44518487 | 2014-12-20 04:57:33 | ALLIES | 1 | 6 | 1 | 1007284 | Temple58 | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
44518895 | 2014-12-20 05:39:37 | ALLIES | 1 | 7 | 5 | 1401936 | Wire Cane J61944 | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
44519051 | 2014-12-20 05:55:55 | AXIS | 1 | 7 | 5 | 1401936 | Wire Cane J61944 | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
44526085 | 2014-12-20 18:32:39 | ALLIES | 1 | 6 | 2 | 586355 | Warbanner1 | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
44526382 | 2014-12-20 18:41:13 | AXIS | 1 | 6 | 1 | 586355 | Warbanner1 | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
Spreadsheet: 145471d1331600761-excel-2007-adds-values-for-a-specific-time-frame-cost_phasing
Sheet: Sheet1

 | M-17 | M-16 | M-15 | M-14 | M-13 | M-12 | M-11 | M-10 | M-9 | [NAME] | M-7 | M-6 | M-5 | M-4 | M-3 | M-2 | M-1 | M-0
Savings Schedule | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 0 | 0 | 0 | 0 | 0 | 0
Schedule length
Month | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00 | 2015-01-01 00:00:00
Personnel hired | 1 | 1
Value
Val 2
Notes:
Savings schedule is a range that is multiplied by the number of personnel hired (using SUMPRODUCT()).
It is 'in reverse' as we have to look back to earlier periods.
The complexity with the OFFSET function is to ensure that the two ranges being multiplied are the same length and  do not go back before the first period.
In later periods it would be possible to use just the SUMPRODUCT with the ranges - see Val2 in col T
Using the list of savings by month gives flexibility.
Can also be used in cases such as getting cash flow from invoices issued in month with a percentage paid in 1 month, 2 months etc.
The formula could be simplified by having a helper row which determines the range length
Range length | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 18 | 18
Month | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00 | 2015-01-01 00:00:00
Value
Spreadsheet: 455018d1460064933-team-composition-maker-for-game-ferdyhar
Sheet: Skill

Character | FerdyHar | Dark | Fairdal | Dreadparadox | ForTheHorde | BEST | 2nd | 3rd | 4th | 5th |  | RANK | FerdyHar | Dark | Fairdal | Dreadparadox | ForTheHorde
[NAME] | 4 | 1 | 3 | 2 | 1 |  |  |  |  |  |  | 1
Anub'arak | 3 | 4 | 2 | 3 | 2 |  |  |  |  |  |  | 2
Artanis | 3 | 5 | 3 | 4 | 4 |  |  |  |  |  |  | 3
[NAME] | 3 | 3 | 4 | 3 | 1 |  |  |  |  |  |  | 4
Azmodan | 4 | 1 | 1 | 4 | 1 |  |  |  |  |  |  | 5
Brightwing | 5 | 1 | 3 | 2 | 1 |  |  |  |  |  |  | 6
[NAME] | 4 | 4 | 2 | 3 | 1 |  |  |  |  |  |  | 7
Cho | 2 | 3 | 3 | 4 | 3 |  |  |  |  |  |  | 8
Gall | 4 | 3 | 1 | 5 | 4 |  |  |  |  |  |  | 9
Dehaka | 1 | 5 | 1 | 3 | 1 |  |  |  |  |  |  | 10
Diablo | 4 | 5 | 2 | 5 | 3
E.T.C. | 4 | 5 | 4 | 4 | 3
Falstad | 5 | 2 | 4 | 3 | 1
Gazlowe | 2 | 3 | 3 | 3 | 2
Greymane | 3 | 4 | 2 | 5 | 4
Illidan | 4 | 4 | 4 | 5 | 3
Jaina | 4 | 5 | 3 | 4 | 4
[NAME] | 3 | 5 | 2 | 3 | 2
Kael'thas | 3 | 3 | 1 | 5 | 3
Kerrigan | 3 | 4 | 2 | 3 | 4
Kharazim | 5 | 1 | 3 | 2 | 5
Leoric | 3 | 4 | 4 | 4 | 1
[NAME] | 4 | 1 | 3 | 4 | 5
[NAME] | 5 | 3 | 2 | 4 | 3
Lt. Moralis | 5 | 3 | 3 | 2 | 5
Lunara | 3 | 5 | 4 | 1 | 1
Malfurion | 5 | 1 | 2 | 2 | 5
Muradin | 4 | 3 | 3 | 4 | 3
[NAME] | 2 | 1 | 5 | 4 | 1
Nazeebo | 2 | 1 | 4 | 3 | 1
Nova | 3 | 3 | 2 | 2 | 3
Raynor | 2 | 3 | 3 | 5 | 5
Rehgar | 4 | 3 | 4 | 3 | 5
[NAME] | 1 | 3 | 3 | 3 | 1
Sgt. Hammer | 1 | 4 | 4 | 4 | 3
Sonya | 3 | 5 | 3 | 3 | 3
Stitches | 3 | 4 | 3 | 4 | 1
Sylvanas | 3 | 4 | 4 | 4 | 3
Tassadar | 4 | 4 | 2 | 4 | 3
The Butcher | 4 | 3 | 3 | 4 | 3
The Lost Vikings | 2 | 1 | 4 | 1 | 1
Thrall | 5 | 4 | 4 | 5 | 3
Tychus | 3 | 1 | 2 | 5 | 4
[NAME] | 4 | 3 | 3 | 3 | 1
Tyrande | 3 | 4 | 3 | 2 | 4
Uther | 5 | 1 | 2 | 4 | 4
Valla | 4 | 3 | 3 | 4 | 4
[NAME] | 3 | 4 | 3 | 5 | 1
Zagara | 5 | 4 | 3 | 3 | 5
Zeratul | 4 | 4 | 4 | 3 | 1
Spreadsheet: 21536d1209137461-formating-question-placing-data-from-1-column-to-several-workbook1
Sheet: Sheet1

SHOP NAME | ADDRESS | CITY | ST | ZIP | PHONE
COOL STORE
10735 AL HWY 168
(256) 593-1311
BOAZ
AL 35957
[NAME]
605 COLUMBIA HIGHWAY
(334) 792-5131
OZARK
AR 22947
WHAT I AM TRYING TO ACHIEVE IN AN AUTOMATED FASHION IS:
COOL STORE | 10735 AL HWY 168 | BOAZ | AL | 35957 | (256) 593-1311
Spreadsheet: bafd30bd-cd4c-4e9a-b86a-766179fe55ee
Sheet: Sheet1

 | Outboarding matrix
 | Employee Name:
 | PID: | Department Name:
 | Date of Hire: | Department Number:
 | Date for Departure: | Date of Exit:
 | The following checklist is provided to assist all UNC-Chapel Hill employees with the exit process.  Employees leaving the University should be aware of their benefits and rights.  In addition, departing employees have an obligation to return all University property assigned to them and to settle any outstanding accounts.  Please contact your HR Facilitator if you have any questions during the exit process.  (Items on checklist may not apply to all employees.) You should review the package entitled "Leaving the University" before making any decisions.
 | Employee Responsibilities |  | Responsible party | Date completed
 | Check mailbox Empty activity list      ▪  Dictate and sign all clinic notes      ▪  Review labs and x-rays      ▪  Forward labs to colleague      ▪  Phone message alert Have Internal Medicine Clearance Sheet provided by [NAME] in the Housestaff office signed by either Dr. [NAME], Dr. [NAME],  Dr. [NAME], or Dr. [NAME] signed form back to [NAME]. |  | Self
 | Internal Medicine clinic Clearance Sheet |  | Click here for form
 | Housestaff Coordinator's Responsibilities |  | Responsible party
 | Update email distribution lists |  | Housestaff office | [NAME]
 | Clinic Coordinator's Responsibilities |  | Responsible party
 | Terminate access to IMC systems
 | ▪  Preclinic Conference website |  | Internal Medicine Clinic | [NAME]
 | ▪  CSW |  | Internal Medicine Clinic | [NAME]
 | ▪  UNC Home Health Portal |  | Internal Medicine Clinic | [NAME]
 | Patient panel transfers |  | Internal Medicine Clinic | [NAME]
Spreadsheet: 113050d1308980940-find-oldest-record-based-on-another-cell-being-empty-or-not-book1-1-
Sheet: Sheet1

Asset Tag | Date | Type | End of Service
555 | 2000-01-01 00:00:00 | Computer | 2009-05-05 00:00:00
666 | 2001-02-02 00:00:00 | Apple | 2009-06-06 00:00:00 |  |  | Note: Actual data is picked in I1 to L1 and shown in B9 through excel camera function
777 | 2004-03-03 00:00:00 | Tree | 2009-07-07 00:00:00
888 | 2006-05-05 00:00:00 | Car | 2009-08-08 00:00:00
999 | 2007-06-06 00:00:00 | Computer
 | The oldest computer STILL IN SERVICE is:
 | B9 should read "(999) 6/6/2007" (without quotes) or "6/6/2007 (999)" without quotes.  Ideally it would recognize that D6 does not have a date in it whereas D1, also a computer, does have a date in it.
Spreadsheet: 37c5d1d5-9254-408a-ab4b-b9d1989b3e97
Sheet: FA Requirements

Financial Assurance - Customer FTR Bidding Requirements
FA_FTRPREAWDREQ_<customer_id>_<AuctionPeriodBegin><Type>_<Version>.CSV
<[NAME]
Auction Name: <auction_name> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
Bid Path Information |  |  |  |  |  | FA Requirements
Source Location ID | Source Location Name | Source Location Type | Sink Location ID | Sink Location Name | Sink Location Type | Class Type | BidFA | SRFA
Number | String | String | Number | String | String | String | Number | Number
Footer: Auction Period: <AuctionPeriodBegin (MON YYYY)> - <AuctionPeriodEnd (MON YYYY)>, Auction Type: {"Monthly","Annual"}
Spreadsheet: 32992d1229189076-a-formula-to-read-values-from-other-sheets-pivot-table-test1
Sheet: 112001-Cash imprest

Account Name. | 112001-Cash imprest
Sum of Balances.
CENTER. | Account Name | Total
T | 112001-Cash imprest | 30000
U | 112001-Cash imprest | 0
V | 112001-Cash imprest | 75000
W | 112001-Cash imprest | 14753.85
X | 112001-Cash imprest | 80023.85
Y | 112001-Cash imprest | 5500
Z | 112001-Cash imprest | 29456.5
Grand Total |  | 234734.2
Spreadsheet: 679620d1590523353-identify-duplicates-in-2-columns-duplicates
Sheet: Sheet1

[NAME] | 100000 | [NAME] | 100000
[NAME] | 0.7 | [NAME] | 4140
[NAME] | 75903.8 | [NAME] | 50000 |  |  |  | Should not show row number because the month is not match
[NAME] | 0 | [NAME] | 13519.8
[NAME] | 4140 | [NAME] | 5759 |  |  |  | Should not show row number because the month is not match
[NAME] | 10000 | APRIL | 50000 |  |  |  |  | the result should show 8 instead of not found
[NAME] | 0.5 | APRIL | 2896 |  |  |  | Result should show 10 because the month is match
APRIL | 50000 | APRIL | 0.7
APRIL | 5759 | APRIL | 2896
APRIL | 2896 | APRIL | 5759 |  |  |  | Should not show row number because the month is not match
MAY | 62384 | MAY | 5759
MAY | 22910 | MAY | 22910
MAY | 4140 | MAY | 4140
MAY | 86099.1 | MAY | 200000
MAY | 0.5 | [NAME] | 1234 |  |  |  | Result should show 16 because the month is match
[NAME] | 1234 | [NAME] | 0
JULY | 5759
Spreadsheet: 708668d1607965121-need-conditional-formatting-to-highlight-if-greater-than-a-cell-but-not-highlight-if-less-copy-of-invoice_dec11
Sheet: Quotation

 |  |  |  |  | Quotation
 | 58 Interstate Drive NW |  |  |  | DATE OF QUOTE | Sept. 21st 2020
 | Melrose, MN 56352
 | Phone: [PHONE] |  |  |  | Customer # | 2001827
 | Quotation For:
 | Name |  |  |  | Prepared by:
 | Company Name |  |  |  | SLOC # | 1
 | Street Address
 | City, ST, Zip
 | Phone
 |  |  |  |  | T = Taxable or      Leave Blank
 | PART NUMBER | QTY | [NAME] | UNIT PRICE | TAXABLE? | AMOUNT | Current Inventory
 | 1726
 |  |  |  |  | SUBTOTAL
 | [NAME] FOR 30 DAYS FROM DATE OF QUOTE |  |  |  | TAX RATE
 |  |  |  |  | SALES TAX
 |  |  |  |  | OTHER | 0
 |  |  |  |  | TOTAL
Spreadsheet: 188828d1351002883-sorting-rows-on-different-tabs-by-date-task-20list-20-help-1-
Sheet: B

Due Date: | Client Name | Person Responsible | Task
2012-10-27 00:00:00 | B | person 1 | Task G
2012-10-28 00:00:00 | B | person 2 | Task H
2012-11-02 00:00:00 | B | person 3 | Task I
2012-11-05 00:00:00 | B | person 4 | Task J
2012-11-15 00:00:00 | B | person 5 | Task K
2012-11-20 00:00:00 | B | person 6
Spreadsheet: 872835d1719280117-automatically-add-new-data-from-one-table-to-another-names_table
Sheet: Sheet1

Name | course1 | [NAME] | course3 | course4 | course5 |  |  |  | course1 | [NAME] | course3 | course4 | course5 |  | course1 | [NAME] | course3 | course4 | course5
Name_1 | 2024-01-01 00:00:00 |  | 2023-01-01 00:00:00
Name_2 |  | 2023-01-01 00:00:00 |  | 2023-01-01 00:00:00 | 2020-01-01 00:00:00 |  |  |  | Name_3 | Name_5 | Name_4 | Name_3 | Name_3
Name_3 | 2024-01-01 00:00:00 |  |  | 2023-01-01 00:00:00 | 2020-01-02 00:00:00 |  |  |  | Name_4 | Name_6 | Name_5 | Name_4 | Name_4
Name_4 | 2024-01-01 00:00:00 |  | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2020-01-03 00:00:00 |  |  |  | Name_5 | Name_7 | Name_6 | Name_5 | Name_7
Name_5 | 2024-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 |  |  |  |  | Name_6 | Name_9 | Name_7 | Name_6 | Name_8
Name_6 | 2024-01-01 00:00:00 | 2023-01-02 00:00:00 | 2023-01-01 00:00:00 | 2023-01-02 00:00:00 |  |  |  |  | Name_7 | Name_10 | Name_8 | Name_7 | Name_9
Name_7 | 2024-01-02 00:00:00 | 2023-01-03 00:00:00 | 2023-01-01 00:00:00 | 2023-01-03 00:00:00 | 2023-01-01 00:00:00 |  |  |  | Name_8 | Name_11 | Name_9 | Name_10 | Name_10
Name_8 | 2024-01-03 00:00:00 |  | 2023-01-01 00:00:00 |  | 2023-01-01 00:00:00 |  |  |  | Name_10 | Name_12 | Name_10 | Name_11 | Name_11
Name_9 |  | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 |  | 2023-01-01 00:00:00 |  |  |  | Name_11 | Name_13 | Name_11 | Name_12 | Name_12
Name_10 | 2024-01-05 00:00:00 | 2023-01-01 00:00:00 | 2023-01-02 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 |  |  |  | Name_12 | Name_14 | Name_13 | Name_13 | Name_13
Name_11 | 2024-01-06 00:00:00 | 2023-01-01 00:00:00 | 2023-01-03 00:00:00 | 2023-01-01 00:00:00 | 2023-01-02 00:00:00 |  |  |  | Name_13 | Name_17 | Name_14 | Name_14 | Name_16
Name_12 | 2024-01-07 00:00:00 | 2023-01-01 00:00:00 |  | 2023-01-01 00:00:00 | 2023-01-03 00:00:00 |  |  |  | Name_14 | Name_18 | Name_15 | Name_15 | Name_17
Name_13 | 2024-01-08 00:00:00 | 2023-01-02 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-04 00:00:00 |  |  |  | Name_15 | Name_19 | Name_16 | Name_16 | Name_18
Name_14 | 2024-01-09 00:00:00 | 2023-01-03 00:00:00 | 2023-01-02 00:00:00 | 2023-01-02 00:00:00 |  |  |  |  | Name_17 | Name_20 | Name_17 | Name_17 | Name_19
Name_15 | 2024-01-10 00:00:00 |  | 2023-01-03 00:00:00 | 2023-01-03 00:00:00 |  |  |  |  | Name_18 | [NAME] |  | [NAME]
Name_16 |  |  | 2023-01-04 00:00:00 | 2023-01-04 00:00:00 | 2023-01-01 00:00:00 |  |  |  | Name_19
Name_17 | 2024-01-12 00:00:00 | 2023-01-01 00:00:00 | 2023-01-05 00:00:00 | 2023-01-05 00:00:00 | 2023-01-01 00:00:00 |  |  |  | Name_20
Name_18 | 2024-01-13 00:00:00 | 2023-01-01 00:00:00 |  |  | 2023-01-01 00:00:00
Name_19 | 2024-01-14 00:00:00 | 2023-01-01 00:00:00 |  |  | 2023-01-01 00:00:00
Name_20 | 2024-01-15 00:00:00 | 2023-01-02 00:00:00
[NAME] |  | 2023-01-03 00:00:00 |  | 2024-01-01 00:00:00