tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 679435d1590418124-substraction-based-on-multiple-conditions-hourly-time-cards
Sheet: Date

Profile date | Employee number | Name | Activites | Start time | End time | Time | Hrs
2020-04-27 00:00:00 | 1702 | Sample | Clock-in | 06:34:44 | 06:34:44
2020-04-27 00:00:00 | 1702 | Sample | Indirect activity | 06:34:44 | 08:15:52
2020-04-27 00:00:00 | 1702 | Sample | Process | 08:15:52 | 10:45:48
2020-04-27 00:00:00 | 1702 | Sample | Indirect activity | 10:45:48 | 10:45:54
2020-04-27 00:00:00 | 1702 | Sample | Process | 10:45:54 | 14:22:48
2020-04-27 00:00:00 | 1702 | Sample | Indirect activity | 14:22:48 | 15:00:14
2020-04-27 00:00:00 | 1702 | Sample | Clock-out | 15:00:14 | 15:00:14
2020-04-27 00:00:00 | 1635 | Sample1 | Clock-in | 06:34:33 | 06:34:33
2020-04-27 00:00:00 | 1635 | Sample1 | Indirect activity | 06:34:33 | 07:34:05
2020-04-27 00:00:00 | 1635 | Sample1 | Process | 07:34:05 | 08:17:58
2020-04-27 00:00:00 | 1635 | Sample1 | Indirect activity | 08:17:58 | 08:29:38
2020-04-27 00:00:00 | 1635 | Sample1 | Process | 08:29:38 | 08:45:50
2020-04-27 00:00:00 | 1635 | Sample1 | Indirect activity | 08:45:50 | 09:21:56
2020-04-27 00:00:00 | 1635 | Sample1 | Process | 09:21:56 | 10:09:51
2020-04-27 00:00:00 | 1635 | Sample1 | Indirect activity | 10:09:51 | 10:10:11
2020-04-27 00:00:00 | 1635 | Sample1 | Indirect activity | 10:10:11 | 12:08:46
2020-04-27 00:00:00 | 1635 | Sample1 | Process | 12:08:46 | 14:44:44
2020-04-27 00:00:00 | 1635 | Sample1 | Indirect activity | 14:44:44 | 15:03:45
2020-04-27 00:00:00 | 1635 | Sample1 | Clock-out | 15:03:45 | 15:03:45
2020-04-27 00:00:00 | 1796 | Sample2 | Clock-in | 06:51:48 | 06:51:48
2020-04-27 00:00:00 | 1796 | Sample2 | Indirect activity | 06:51:48 | 15:03:08
2020-04-27 00:00:00 | 1796 | Sample2 | Clock-out | 15:03:08 | 15:03:08
2020-04-27 00:00:00 | 1686 | Sample3 | Clock-in | 06:58:34 | 06:58:34
2020-04-27 00:00:00 | 1686 | Sample3 | Indirect activity | 06:58:34 | 15:00:36
2020-04-27 00:00:00 | 1686 | Sample3 | Clock-out | 15:00:36 | 15:00:36
2020-04-27 00:00:00 | 1691 | Sample4 | Clock-in | 06:34:37 | 06:34:37
2020-04-27 00:00:00 | 1691 | Sample4 | Indirect activity | 06:34:37 | 07:23:39
2020-04-27 00:00:00 | 1691 | Sample4 | Process | 07:23:39 | 12:43:06
2020-04-27 00:00:00 | 1691 | Sample4 | Process | 12:43:06 | 14:58:17
2020-04-27 00:00:00 | 1691 | Sample4 | Indirect activity | 14:58:17 | 15:03:59
2020-04-27 00:00:00 | 1691 | Sample4 | Clock-out | 15:03:59 | 15:03:59
Spreadsheet: kimberly_watson__20552__imbalsumm0108
Sheet: NS Steel

 | North Star Steel
 | POI 500383 - North Start Steel IC
Day | Measured | Scheduled
1 | -2001 | -2139
2 | -79 | -2139
3 | -553 | -2453
4 | -1052 | -2453
5 | -1743 | -2453
6 | -1725 | -2453
7 | -1957 | -2139
8 | -1968 | -2139
9 | -76 | -711
10 | -800 | -2139
11 | -1249 | -2139
12 | -1989 | -2139
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  | -394244.14
2001-08-12 00:00:00
CBS Volume
 |  |  | -68282
Spreadsheet: 136631d1326749662-pull-data-if-columns-equal-a-range-copy-of-test2
Sheet: Sheet1

Item Id | Description | Qty | ITN | [NAME] | Date In | Days Old | Location | PO Number
Item 1 | Item 1 | 2 |  |  |  | 42 |  |  | 1 | 31
Item 1 | Item 1 | 2 |  |  |  | 42 |  |  | 2
Item 1 | Item 1 | 2 |  |  |  | 43 |  |  | 3
Item 1 | Item 1 | 2 |  |  |  | 43 |  |  | 4
Item 1 | Item 1 | 1 |  |  |  | 455
Item 1 | Item 1 | 3 |  |  |  | 455
Item 1 | Item 1 | 1 |  |  |  | 644
Item 1 | Item 1 | 3 |  |  |  | 680
Item 1 | Item 1 | 2 |  |  |  | 680
Item 2 | Item 2 | 1 |  |  |  | 42 |  |  | 5
Item 2 | Item 2 | 1 |  |  |  | 42 |  |  | 6
Item 2 | Item 2 | 1 |  |  |  | 43 |  |  | 7
Item 2 | Item 2 | 1 |  |  |  | 43 |  |  | 8
Item 2 | Item 2 | 3 |  |  |  | 173
Item 2 | Item 2 | 20 |  |  |  | 448
Item 2 | Item 2 | 30 |  |  |  | 448
Item 2 | Item 2 | 2 |  |  |  | 680
Item 3 | Item 3 | 1 |  |  |  | 33 |  |  | 9
Item 3 | Item 3 | 1 |  |  |  | 33 |  |  | 10
Item 3 | Item 3 | 1 |  |  |  | 35 |  |  | 11
Item 3 | Item 3 | 1 |  |  |  | 63
Item 3 | Item 3 | 1 |  |  |  | 70
Item 3 | Item 3 | 1 |  |  |  | 76
Item 3 | Item 3 | 17 |  |  |  | 288
Item 3 | Item 3 | 1 |  |  |  | 358
Item 4 | Item 4 | 1 |  |  |  | 42 |  |  | 12
Item 4 | Item 4 | 1 |  |  |  | 42 |  |  | 13
Item 4 | Item 4 | 1 |  |  |  | 42 |  |  | 14
Item 4 | Item 4 | 1 |  |  |  | 42 |  |  | 15
Item 4 | Item 4 | 1 |  |  |  | 42 |  |  | 16
Item 4 | Item 4 | 1 |  |  |  | 42 |  |  | 17
Item 4 | Item 4 | 1 |  |  |  | 42 |  |  | 18
Item 4 | Item 4 | 1 |  |  |  | 42 |  |  | 19
Item 4 | Item 4 | 1 |  |  |  | 42 |  |  | 20
Item 4 | Item 4 | 1 |  |  |  | 42 |  |  | 21
Item 4 | Item 4 | 1 |  |  |  | 42 |  |  | 22
Item 4 | Item 4 | 1 |  |  |  | 42 |  |  | 23
Item 4 | Item 4 | 1 |  |  |  | 42 |  |  | 24
Item 4 | Item 4 | 1 |  |  |  | 42 |  |  | 25
Item 4 | Item 4 | 1 |  |  |  | 42 |  |  | 26
Item 4 | Item 4 | 1 |  |  |  | 42 |  |  | 27
Item 4 | Item 4 | 1 |  |  |  | 42 |  |  | 28
Item 4 | Item 4 | 1 |  |  |  | 42 |  |  | 29
Item 4 | Item 4 | 1 |  |  |  | 43 |  |  | 30
Item 4 | Item 4 | 1 |  |  |  | 43 |  |  | 31
Item 4 | Item 4 | 1 |  |  |  | 362
Item 4 | Item 4 | 1 |  |  |  | 455
Spreadsheet: 26857d1219422498-complex-count-function-fruit
Sheet: Sheet1

Product | Quantity | Name
Apples | 43 | [NAME] |  |  |  | [NAME] | [NAME] | [NAME] | [NAME]
Carrots | 54 | [NAME] |  |  | Apples | Count of rows where Product=Apples and Name=[NAME]
Peas | 3 | [NAME] |  |  | Carrots | Count of rows where Product=Carrots and Name=[NAME]
Water | 5 | [NAME] |  |  | Peas | Count of rows where Product=Peas and Name=[NAME]
Soup | 56 | [NAME] |  |  | Water | Count of rows where Product=Water and Name=[NAME]
Apples | 56 | [NAME] |  |  | Soup | Count of rows where Product=Soup and Name=[NAME]
Peas | 4 | [NAME]
Water | 3 | [NAME] |  |  |  | I thought I could use one of the count functions and place some login in there like product = F3 and Name=G2
Apples | 5 | [NAME]
Peas | 6 | [NAME]
Apples | 7 | [NAME]
Water | 5 | [NAME]
Apples | 4 | [NAME]
Carrots | 4 | [NAME]
Water | 4 | [NAME]
Apples | 5 | [NAME]
Soup |  | [NAME]
Carrots | 6 | [NAME]
Peas | 5 | [NAME]
Apples | 34 | [NAME]
Apples | 43 | [NAME]
Water | 5 | [NAME]
Carrots | 67 | [NAME]
Water | 7 | [NAME]
Peas | 5 | [NAME]
Soup | 4 | [NAME]
Apples | 3 | [NAME]
Carrots | 45 | [NAME]
Soup | 5 | [NAME]
Spreadsheet: 840254d1692613514-how-to-to-count-all-dates-overdue-except-the-rows-with-a-obsolete-status-book1
Sheet: Sheet1

 |  |  |  |  |  | Date |  | Status |  | Not obsolete and expired |  |  | Not obsolete and not expired
 |  |  |  |  |  | 2023-02-02 00:00:00 |  | Obsolete
 |  |  |  |  |  | 2023-06-01 00:00:00 |  | Released
 |  |  |  |  |  | 2023-09-28 00:00:00 |  | Obsolete
 |  |  |  |  |  | 2023-07-13 00:00:00 |  | Obsolete
 |  |  |  |  |  | 2023-04-16 00:00:00 |  | Review
 |  |  |  |  |  | 2023-04-27 00:00:00 |  | Released
 |  |  |  |  |  | 2023-02-16 00:00:00 |  | Released
 |  |  |  |  |  | 2023-04-24 00:00:00 |  | Obsolete
 |  |  |  |  |  | 2023-05-23 00:00:00 |  | Released
 |  |  |  |  |  | 2023-03-30 00:00:00 |  | Obsolete
 |  |  |  |  |  | 2023-09-21 00:00:00 |  | Review
 |  |  |  |  |  | 2023-07-20 00:00:00 |  | Released
 |  |  |  |  |  | 2023-08-12 00:00:00 |  | Released
 |  |  |  |  |  | 2023-01-18 00:00:00 |  | Released
 |  |  |  |  |  | 2023-04-06 00:00:00 |  | Obsolete
 |  |  |  |  |  | 2023-08-01 00:00:00 |  | Obsolete
 |  |  |  |  |  | 2023-09-18 00:00:00 |  | Review
 |  |  |  |  |  | 2023-09-24 00:00:00 |  | Released
 |  |  |  |  |  | 2023-09-08 00:00:00 |  | Released
 |  |  |  |  |  | 2023-06-12 00:00:00 |  | Obsolete
 |  |  |  |  |  | 2023-09-21 00:00:00 |  | Released
 |  |  |  |  |  | 2023-06-02 00:00:00 |  | Obsolete
 |  |  |  |  |  | 2023-02-03 00:00:00 |  | Released
Spreadsheet: 737536d1624458405-formula-to-change-cell-data-depending-upon-other-cell-value-change
Sheet: Sheet1

Plan | Time | Keyword
 | 5 | 1
 | 3 | 1
 | 4 | 1
 | 55 | 1
 | 34 | 1
 | 3 | 2
 | 34 | 2
 | 2 | 2
 | 23 | 2
 | 5 | 2
 | 2 | 3
 | 4 | 3
 | 3 | 3
 | 4 | 3
 | 3 | 3
 | 66 | 3
 | 6 | 3
 | 6 | 3
 | 3 | 3
 | 43 | 4
 | 4 | 4
 | 3 | 4
 | 3 | 4
 | 4 | 4
Spreadsheet: 175662d1345602106-conditional-formatting-for-another-cells-value-when-using-data-bars-conditionalformattingproblem
Sheet: Sheet1

Name 1 | 2
Name 2 | 90
Name 3 | 23
Name 4 | 46
Name 5 | 75
Name 6 | 86
Name 7 | 12
Name 8 | 98
Name 9 | 33
Name 10 | 66
Spreadsheet: 744675d1629379448-extract-from-table-based-on-criteria-then-order-results-by-other-criteria-excel-timesheet-tables
Sheet: Messy Solution

Manually Entered Fields |  |  |  |  |  |  |  |  |  | Concatenations |  |  |  |  | Calculations |  |  |  |  |  |  |  |  | [NAME]
Ref | Name | Misc 1 | Priority | M | T | W | T | F | Area | M1 | T1 | W1 | TH1 | F1 | M2 | T2 | [NAME] | TH2 | F2 | Display Name |  |  |  |  | Monday | Tuesday | Wednesday | Thursday | Friday | Notes
1 | [NAME] |  |  |  | F | F | F |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | [NAME] |  |  |  |  |  |  |  | Backoffice |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 | [NAME] |  |  |  | F |  | F |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 | [NAME] |  |  | F | F |  | F | F | Storage |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 | [NAME] |  |  | F |  | F |  | F | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 | [NAME] |  | 1 |  | F | F | F |  | Storage
 | [NAME] |  |  |  |  |  |  |  | Backoffice |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Storage
 | [NAME] |  | 2 | F | F | F |  | F | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monday | Tuesday | Wednesday | Thursday | Friday | Notes
 | [NAME] |  | 1 | F |  | F |  | F | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
Spreadsheet: 525566d1498775408-count-number-of-occurrencies-for-account-number-s666-test-file
Sheet: TEST

account number | name | address | attended |  |  |  | account number | name | times attended
1 | [NAME] doe | 1234 drive | 1 |  |  |  | 1 | [NAME] doe | 6
1 | [NAME] doe | 1234 drive | 1 |  |  |  | 2 | mary | 5
1 | [NAME] doe | 1234 drive | 1 |  |  |  | 3 | [NAME] | 5
1 | [NAME] doe | 1234 drive | 1 |  |  |  | 4 | [NAME] | 6
1 | [NAME] doe | 1234 drive | 1
1 | [NAME] doe | 1234 drive | 1
2 | mary | 5678 drive | 1
2 | mary | 5678 drive | 1
2 | mary | 5678 drive | 1
2 | mary | 5678 drive | 0
2 | mary | 5678 drive | 1
2 | mary | 5678 drive | 1
3 | [NAME] | 9876 drive | 1
3 | [NAME] | 9876 drive | 1
3 | [NAME] | 9876 drive | 1
3 | [NAME] | 9876 drive | 0
3 | [NAME] | 9876 drive | 1
3 | [NAME] | 9876 drive | 1
4 | [NAME] | 5432 drive | 1
4 | [NAME] | 5432 drive | 1
4 | [NAME] | 5432 drive | 1
4 | [NAME] | 5432 drive | 0
4 | [NAME] | 5432 drive | 1
4 | [NAME] | 5432 drive | 1
4 | [NAME] | 5432 drive | 1
Spreadsheet: michelle_lokay__26703__imball0112
Sheet: Devon

 | Devon SFS Operating
 | POI 36289 - Bilbrey 28 Fed 1 C/P
Day | Measured | Scheduled
1 | 650 | 589
2 | 625 | 589
3 | 616 | 589
4 | 599 | 589
5 | 595 | 589
6 | 616 | 589
7 | 629 | 589
8 | 662 | 589
9 | 681 | 589
10 | 701 | 589
11 | 641 | 589
12 | 646 | 589
13 | 533 | 589
14 | 549 | 589
15 | 693 | 589
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  | 148916.73
2001-12-15 00:00:00
CBS Volume
 |  |  | 28495
Spreadsheet: darrell_schoolcraft__7445__imball0202
Sheet: Continental

 | Contintental
 | 500204 |  | 500205
Day | Measured | Scheduled | Measured | Scheduled
1 |  |  |  | 65
2 |  |  |  | 65
3 |  |  |  | 65
4 |  |  |  | 33
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
2002-01-31 00:00:00 |  |  |  |  | 27090
2002-02-04 00:00:00
CBS Volume
 |  |  | -2700
Spreadsheet: michelle_lokay__26811__RIghtFTS
Sheet: SC-Permian

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H:\1ZiminLu\1Zimin\OptionLibrary\Asian2\ResidOpt\Debug\residOpt.dll
 |  | Valuation Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | StripVol
 |  | 2000-09-08 00:00:00 |  |  |  |  |  | daily volume (mmBTU) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KJKKKKBK
 |  |  |  |  |  |  |  | 10000 |  |  |  |  |  |  | Fuel |  | Forward Price Correlation
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.05 |  | 0.95
 | mat |  | SOCAL | Permian | Volalitity | Int Rate | Days | Volume | DF | PV Volume |  | Rows | Years | Strip (Socal) | Strip (Permian) | Spread | Strip Vol (SOCAL) | Strip Vol (Permian) | Strike | Int | Correl | Correl+1% | T(days) | PV Volume | Total Intrinsic Value | Option Value | Option Value(+1%)
 |  | 2000-11-01 00:00:00 |  |  |  |  |  |  |  |  |  | 18 | 1 |  |  |  |  |  | 0.3837 |  | 0.96
 |  | 2000-12-01 00:00:00 |  |  |  |  |  |  |  |  |  | 30 | 2 |  |  |  |  |  | 0.3837 |  | 0.97
 |  | 2001-01-01 00:00:00 |  |  |  |  |  |  |  |  |  | 42 | 3 |  |  |  |  |  | 0.3837 |  | 0.98
 |  | 2001-02-01 00:00:00 |  |  |  |  |  |  |  |  |  | 54 | 4 |  |  |  |  |  | 0.3837 |  | 0.99
 |  | 2001-03-01 00:00:00 |  |  |  |  |  |  |  |  |  | 66 | 5 |  |  |  |  |  | 0.3837 |  | 1
 |  | 2001-04-01 00:00:00
 |  | 2001-05-01 00:00:00
 |  | 2001-06-01 00:00:00
 |  | 2001-07-01 00:00:00
 |  | 2001-08-01 00:00:00
 |  | 2001-09-01 00:00:00
 |  | 2001-10-01 00:00:00
 |  | 2001-11-01 00:00:00
 |  | 2001-12-01 00:00:00
 |  | 2002-01-01 00:00:00
 |  | 2002-02-01 00:00:00
 |  | 2002-03-01 00:00:00
 |  | 2002-04-01 00:00:00
 |  | 2002-05-01 00:00:00
 |  | 2002-06-01 00:00:00
 |  | 2002-07-01 00:00:00
 |  | 2002-08-01 00:00:00
 |  | 2002-09-01 00:00:00
 |  | 2002-10-01 00:00:00
 |  | 2002-11-01 00:00:00
 |  | 2002-12-01 00:00:00
 |  | 2003-01-01 00:00:00
 |  | 2003-02-01 00:00:00
 |  | 2003-03-01 00:00:00
 |  | 2003-04-01 00:00:00
 |  | 2003-05-01 00:00:00
 |  | 2003-06-01 00:00:00
 |  | 2003-07-01 00:00:00
 |  | 2003-08-01 00:00:00
 |  | 2003-09-01 00:00:00
 |  | 2003-10-01 00:00:00
 |  | 2003-11-01 00:00:00
 |  | 2003-12-01 00:00:00
 |  | 2004-01-01 00:00:00
 |  | 2004-02-01 00:00:00
 |  | 2004-03-01 00:00:00
 |  | 2004-04-01 00:00:00
 |  | 2004-05-01 00:00:00
 |  | 2004-06-01 00:00:00
 |  | 2004-07-01 00:00:00
 |  | 2004-08-01 00:00:00
 |  | 2004-09-01 00:00:00
 |  | 2004-10-01 00:00:00
 |  | 2004-11-01 00:00:00
 |  | 2004-12-01 00:00:00
 |  | 2005-01-01 00:00:00
 |  | 2005-02-01 00:00:00
 |  | 2005-03-01 00:00:00
 |  | 2005-04-01 00:00:00
 |  | 2005-05-01 00:00:00
 |  | 2005-06-01 00:00:00
 |  | 2005-07-01 00:00:00
 |  | 2005-08-01 00:00:00
 |  | 2005-09-01 00:00:00
 |  | 2005-10-01 00:00:00
 |  | 2005-11-01 00:00:00
Spreadsheet: 40589d1238972216-array-formula-help-across-multiple-tabs-book5
Sheet: Data

Client | Role | Market | Week Commencing | Cost
[NAME] | Sales | Brisbane | 2009-03-15 00:00:00 | 100
[NAME] | Sales | Brisbane | 2009-03-15 00:00:00 | 251
[NAME] | Sales | Sydney | 2009-03-15 00:00:00 | 125
[NAME] | Sales | Brisbane | 2009-03-22 00:00:00 | 1356
[NAME] | Sales | Sydney | 2009-03-22 00:00:00 | 311
[NAME] | Sales | Sydney | 2009-03-22 00:00:00 | 123
[NAME] | Sales | Brisbane | 2009-03-29 00:00:00 | 1335
[NAME] | Sales | Brisbane | 2009-03-29 00:00:00 | 123
[NAME] | Sales | Brisbane | 2009-03-29 00:00:00 | 15
[NAME] | Sales | Brisbane | 2009-03-29 00:00:00 | 1
[NAME] | Sales | Sydney | 2009-03-29 00:00:00 | 8
[NAME] | Sales | Brisbane | 2009-04-05 00:00:00 | 182
[NAME] | Sales | Sydney | 2009-04-05 00:00:00 | 121
[NAME] | Sales | Sydney | 2009-04-05 00:00:00 | 12
[NAME] | Sales | Sydney | 2009-04-05 00:00:00 | 54
[NAME] | Sales | Sydney | 2009-04-05 00:00:00 | 18412
Spreadsheet: ecf64b8b-f934-4b9c-a5e2-658e6fd76fcc
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | STATE OF MARYLAND EXPENSE ACCOUNT | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  |  | Use for reimbursement effective July 1, 2011
 |  |  |  | 55.5 ¢ per mile
Department | Coppin State University
Unit  or   Division
Agency    Code | R27 |  | Employee Social Security No.
Employee   Name
and    Address
Assigned   Office   Location     (City) |  | Baltimore |  | One Way Commute Miles
For   Period    Beginning |  |  |  | And Ending
Date
Day | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | TOTALS
Hotel |  |  |  |  |  |  |  | 0
Breakfast |  |  |  |  |  |  |  | 0
Lunch |  |  |  |  |  |  |  | 0
Dinner |  |  |  |  |  |  |  | 0
Telephone |  |  |  |  |  |  |  | 0
Fare (Indicate below) |  |  |  |  |  |  |  | 0
Taxi |  |  |  |  |  |  |  | 0
Bridge or Road Tolls |  |  |  |  |  |  |  | 0
Mileage * (See Below) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Parking |  |  |  |  |  |  |  | 0
Registration Fee |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
Totals | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Method of Travel
 |  |  |  |  |  | (Specify)
Purpose of Travel:
Date | Time |  |  |  |  |  | Total | Total | Reimb.
Day | Start | End | TERRITORY COVERED INCURRING ABOVE EXPENSES |  |  |  | [NAME] | Commute Miles | [NAME]*
Sunday |  |  |  |  |  |  |  |  | 0.0
Monday |  |  |  |  |  |  |  |  | 0.0
Tuesday |  |  |  |  |  |  |  |  | 0.0
Wednesday |  |  |  |  |  |  |  |  | 0.0
Thursday |  |  |  |  |  |  |  |  | 0.0
Friday |  |  |  |  |  |  |  |  | 0.0
Saturday |  |  |  |  |  |  |  |  | 0.0
*Compute equal to total miles less total commute miles, if applicable.
 |  |  |  |  |  | Date
Cerified just and correct and payment not received
 |  |  |  | (Signature of employee)
Approved by |  |  |  |  | Approved by
 |  | Immediate Supervisor |  |  |  |  | Authorized Signature
 |  |  |  |  | Title
COTGAD - X-5  (3/92)
Spreadsheet: john_griffith__15585__Cal '02 Barrier
Sheet: Barrier

 | Barrier Option Pricing
 | Function: BRRR
 |  |  |  |  |  |  | 3.85
 |  | EffDt |  |  |  | 2001-12-31 00:00:00
 |  | INPUTS |  |  |  |  |  |  |  |  |  | OUTPUTS
 |  |  |  |  |  |  |  |  | Call/Put | [NAME] |  | 0 | 1 | 2 | 3 | 4 | 5
 | OptionType | Fwd Price | Strike | Ann.IntRt | Ann.Vol | ExpDt | Barrier | Rebate | C=1/P=0 | In=1/Out=0 |  | Price | Delta | Gamma | Vega | Rho | Theta
 | Up-and-Out Put | 5 | 4.5 | 0.0466 | 0.39 |  | 5.5 | 0 | 0 | 0
 | Down-and-Out Put | 5 | 4.5 | 0.0466 | 0.39 |  | 0.01 | 0 | 0 | 0
 | Down-and-Out Put | 5 | 4.5 | 0.0466 | 0.39 |  | 0.3 | 0 | 0 | 0
 | Down-and-Out Put | 5 | 4.5 | 0.0466 | 0.39 |  | 0.59 | 0 | 0 | 0
 | Down-and-Out Put | 5 | 4.5 | 0.0466 | 0.39 |  | 0.88 | 0 | 0 | 0
 | Down-and-Out Put | 5 | 4.5 | 0.0466 | 0.39 |  | 1.17 | 0 | 0 | 0
 | Down-and-Out Put | 5 | 4.5 | 0.0466 | 0.39 |  | 1.46 | 0 | 0 | 0
 | Down-and-Out Put | 5 | 4.5 | 0.0466 | 0.39 |  | 1.75 | 0 | 0 | 0
 | Down-and-Out Put | 5 | 4.5 | 0.0466 | 0.39 |  | 2.04 | 0 | 0 | 0
 | Down-and-Out Put | 5 | 4.5 | 0.0466 | 0.39 |  | 2.33 | 0 | 0 | 0
 | Down-and-Out Put | 5 | 4.5 | 0.0466 | 0.39 |  | 2.62 | 0 | 0 | 0
 | Down-and-Out Put | 5 | 4.5 | 0.0466 | 0.39 |  | 2.91 | 0 | 0 | 0
 | Down-and-Out Put | 5 | 4.5 | 0.0466 | 0.39 |  | 3.2 | 0 | 0 | 0
 | Down-and-Out Put | 5 | 4.5 | 0.0466 | 0.39 |  | 3.49 | 0 | 0 | 0
 | Down-and-Out Put | 5 | 4.5 | 0.0466 | 0.39 |  | 3.78 | 0 | 0 | 0
 | Down-and-Out Put | 5 | 4.5 | 0.0466 | 0.39 |  | 4.07 | 0 | 0 | 0
 | Down-and-Out Put | 5 | 4.5 | 0.0466 | 0.39 |  | 4.36 | 0 | 0 | 0
 | Down-and-Out Put | 5 | 4.5 | 0.0466 | 0.39 |  | 4.65 | 0 | 0 | 0
Spreadsheet: 689708d1596609820-if-function-exceeding-8000-character-limit-need-help-on-shorter-formula-au-and-nz-vendor-margin-analysis-fy20-ytd-test
Sheet: Summary

 |  | January | February | March | April | May | June | July | August | September | October | November | December
 | % Split by month | 0.042 | 0.056 | 0.092 | 0.068 | 0.08 | 0.179 | 0.059 | 0.065 | 0.107 | 0.062 | 0.074 | 0.116
 | NZ to AUD rate | 0.96722611 | 0.95803974 | 0.97917924 | 0.94138886 | 0.93297554 | 0.93570144 | 0.93477683
 | Enter current month | July
Spreadsheet: 525409d1498706975-need-help-with-if-and-or-formula-book1
Sheet: Sheet1

WED | THURS | FRI | SAT | SUN | MON | TUES |  |  | IF BOTH HIGHLIGHTED CELLS = "OFF", "REQ OFF" or "VACA" THAN RESULT "YES"
12-10 | 12-10 | 12-10 | OFF | REQ OFF | 12-10 | 12-10
12-10 | 12-10 | 12-10 | VACA | REQ OFF | 12-10 | 12-10
 |  |  |  |  |  |  |  |  | 3 DIFFERENT WAYS TO SCHEDULE SOMEONE OFF
 |  |  |  |  |  |  |  |  | 1> OFF
 |  |  |  |  |  |  |  |  | 2> REQ OFF
 |  |  |  |  |  |  |  |  | 3> VACA
Spreadsheet: 777866d1650644040-find-days-of-a-month-in-a-period-from-to-month-day
Sheet:  3X7 2R

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | From month | from day
 | Year | 2022 | Month | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 10
 |  | month | 1 | NO | NO | NO | NO | NO | NO | NO | NO | NO | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |  |  |  |  | to  month | to day
 |  | month | 2 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |  |  |  |  |  |  |  | 4 | 7
 |  | month | 3 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
 |  | month | 4 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | NO | NO | NO | NO | NO | NO | NO | NO | NO | NO | NO | NO | NO | NO | NO | NO | NO | NO | NO | NO | NO | NO | NO
Spreadsheet: 698884d1602224430-trying-to-generate-a-report-based-on-time-sheet-groups-by-earn-codes-sample-results
Sheet: Sheet1

UserID | Name | Period | EarnCode | Hours
10 | [NAME] | 1/5/2018-1/18/2018 | Regular | 31.88
16 | [NAME] | 1/5/2018-1/18/2018 | Regular | 32.63
16 | [NAME] | 1/5/2018-1/18/2018 | Lunch | 5.15
20 | Goege Fly | 1/5/2018-1/18/2018 | Regular | 68.9
5 | [NAME] | 1/5/2018-1/18/2018 | Regular | 39.35
6 | [NAME] | 1/5/2018-1/18/2018 | Regular | 63.13
6 | [NAME] | 1/5/2018-1/18/2018 | Lunch | 10.33
8 | [NAME] | 1/5/2018-1/18/2018 | Regular | 67.67
10 | [NAME] | 1/19/2018-2/1/2018 | Regular | 31.92
16 | [NAME] | 1/19/2018-2/1/2018 | Regular | 62.45
16 | [NAME] | 1/19/2018-2/1/2018 | Lunch | 8.85
20 | Goege Fly | 1/19/2018-2/1/2018 | Regular | 79.32
21 | [NAME] | 1/19/2018-2/1/2018 | Regular | 7.57
6 | [NAME] | 1/19/2018-2/1/2018 | Regular | 75.18
6 | [NAME] | 1/19/2018-2/1/2018 | Lunch | 8.68
8 | [NAME] | 1/19/2018-2/1/2018 | Regular | 76.48
Spreadsheet: f808b499-dba1-46ee-a0ab-05ffb38b14d8
Sheet: AD CONTACT INFO

Area Director (AD)  Name | AD Email | AD Phone
[NAME] | [NAME] | [PHONE]
[NAME] | [NAME] | [PHONE]
[NAME] | debra.landvik@ state.mn.us | [PHONE]
[NAME] | [EMAIL] | [PHONE]
[NAME] | [NAME] | [PHONE]
[NAME] | [NAME] | [PHONE]
[NAME] | [EMAIL] | [PHONE]
[NAME] | [NAME] | [PHONE]
[NAME] | [NAME] | [PHONE]
Other Useful Information
Student Support Division | [NAME] | [PHONE]
Student Support Division FAX |  | [PHONE]
[NAME] and Neglected or Delinquent Coordinator | [EMAIL] | [PHONE]
IT Help Desk for SERVS Technical Issues | [EMAIL] | [PHONE]
SERVS Access Assistance | [EMAIL] | [PHONE]
Spreadsheet: 677385d1589327830-i-need-an-alternative-to-an-if-function-as-i-have-too-many-queries-to-be-able-o-use-the-if-stock-analysis
Sheet: Production Requirement

 | Big Machine |  |  | Small Macine
 | Job 1 | Job 2 | Job 3 | Job 1 | Job 2 | Job 3
Number of Packs Made | 3000 | 1000 | 2000 | 3000 | 4000 | 5000
Formulation Made
Cost p Kg
Amount Of Material
Redundancy Factor
Raw Materials
a
b
c
d
e
f
g
h
i
j
k
l
m
n
o
p
q
r
s
t
u
v
w
x
y
z
aa
ab
ac
ad
ae
af
ag
ah
ai
aj
ak
al
am
an
ao
ap
aq
ar
as
at
au
av
Total