tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 728473d1618480866-difference-between-the-start-date-of-a-task-and-the-end-date-with-wordays-workhours-ans
Sheet: Master

Task | Star Date | End Date | Day | Month | NETWORKDAYS | NETWORKDAYS.INTL | Hours | Total Working Hours |  | Task | Average
A | 2021-02-10 10:55:31 | 2021-02-12 05:02:32 |  |  |  |  |  |  | Work schedule 09:00 to 17:00 | A
B | 2021-01-05 23:43:52 | 2021-01-07 05:03:18 |  |  |  |  |  |  |  | B
C | 2021-03-11 21:31:35 | 2021-03-15 05:02:17 |  |  |  |  |  |  | Question: how to do the calculation considering the working schedule after I get tee value of the NETWORKDAYS.INTL? | C
D | 2021-02-09 15:02:21 | 2021-02-11 05:03:41
A | 2021-02-08 09:52:59 | 2021-02-17 05:05:51 |  |  |  |  |  |  | Result: I expect an average of time for the tasks A, B, C and B of 03:40:00
B | 2021-02-15 09:11:24 | 2021-02-18 05:04:06
C | 2021-02-15 09:13:09 | 2021-02-18 05:04:11
D | 2021-02-23 12:44:32 | 2021-02-25 05:03:59
A | 2021-02-24 12:29:14 | 2021-02-28 05:03:37
B | 2021-02-26 12:12:10 | 2021-03-05 05:06:21
C | 2021-03-01 12:30:23 | 2021-03-03 05:03:49
D | 2021-03-05 15:36:54 | 2021-03-09 05:04:01
A | 2021-02-25 15:02:43 | 2021-03-01 05:02:16
B | 2021-03-05 15:56:00 | 2021-03-09 05:03:58
C | 2021-03-08 09:39:54 | 2021-03-21 05:02:05
D | 2021-02-23 13:07:17 | 2021-02-25 05:03:49
A | 2021-03-03 08:26:02 | 2021-03-05 05:03:15
B | 2021-01-14 16:18:00 | 2021-01-18 05:01:39
C | 2021-02-10 09:52:14 | 2021-02-12 05:02:32
D | 2021-02-18 14:06:43 | 2021-02-22 05:02:30
A | 2021-01-13 13:01:00 | 2021-01-15 05:03:43
B | 2021-02-17 10:57:36 | 2021-02-17 11:07:27
C | 2021-02-17 12:25:03 | 2021-02-17 13:11:06
D | 2021-02-05 22:40:36 | 2021-02-09 05:03:34
A | 2021-03-05 16:28:18 | 2021-03-09 05:03:54
B | 2021-02-19 12:52:44 | 2021-02-23 05:03:31
C | 2021-01-11 15:29:45 | 2021-01-13 05:04:25
D | 2021-01-11 13:11:27 | 2021-01-25 05:04:33
A | 2021-01-13 13:01:29 | 2021-01-18 05:03:57
B | 2021-02-02 09:15:11 | 2021-02-04 05:04:55
C | 2021-02-24 18:28:01 | 2021-02-26 05:03:41
D | 2021-03-02 12:31:25 | 2021-03-04 05:03:30
A | 2021-01-06 15:37:21 | 2021-01-08 05:03:14
B | 2021-02-12 11:28:28 | 2021-02-17 05:03:22
C | 2021-01-04 10:39:28 | 2021-01-06 05:03:07
D | 2021-02-18 13:22:28 | 2021-02-26 05:02:30
A | 2021-02-19 11:44:57 | 2021-02-23 05:03:25
B | 2021-02-25 11:56:41 | 2021-03-01 05:02:19
C | 2021-01-22 13:04:39 | 2021-01-26 05:03:10
D | 2021-01-05 17:42:12 | 2021-01-07 05:03:25
A | 2021-01-08 10:49:24 | 2021-01-15 05:02:38
B | 2021-01-14 10:16:30 | 2021-01-18 05:01:43
C | 2021-02-01 17:25:53 | 2021-02-03 05:03:43
D | 2021-03-03 16:38:35 | 2021-03-05 05:03:14
C | 2021-01-08 09:14:13 | 2021-01-14 05:06:23
A | 2021-01-05 17:06:40 | 2021-01-07 05:03:26
B | 2021-03-01 10:25:19 | 2021-03-03 05:03:50
C | 2021-02-23 15:34:53 | 2021-02-26 05:03:56
D | 2021-01-14 13:37:45 | 2021-01-18 05:01:35
A | 2021-01-21 12:52:54 | 2021-01-25 05:05:05
B | 2021-01-06 15:23:40 | 2021-01-10 05:03:08
C | 2021-02-08 12:49:38 | 2021-02-10 05:05:54
D | 2021-02-19 14:53:46 | 2021-02-23 05:03:32
A | 2021-01-11 20:18:46 | 2021-01-13 05:04:28
B | 2021-01-15 14:38:27 | 2021-01-19 05:03:30
C | 2021-02-25 11:53:25 | 2021-03-05 05:02:20
Spreadsheet: mary_fischer__25399__MarAEPProductionComparison
Sheet: Sheet1

 |  | Clear Sky |  | [NAME]
A | Metered (invoiced) Energy (GWh) | 29.14 |  | 42
B | [NAME] (GWh) | 9.96 |  |  |  | Calculated by Data Group
C | Total Energy Billed (GWh)
D | Mar. Ave. Wind Speed (m/s) |  |  |  |  | Per actual date
E | "Ideal" production before losses (GWh) | 50 |  | 55 |  | Calculated by Data Group
F | Less estimated Losses | -0.1 |  | -0.1 |  | Per either GH or [NAME]
G | Less actual Availability | 0.93 |  | 0.85 |  | Based on actual reported numbers
H | Total Adjusted Ideal Production
 | Vaiance ((H-C)/C)
Spreadsheet: 695262d1600114139-how-to-find-latest-date-using-max-formula-matching-p-n-and-partial-text-find-latest-date-using-index-match-and-partial-word-aggregate
Sheet: Summary

 | EOP
 |  |  | App
Number
5775-3-00
5776-3-00
5789-3-00
5790-3-00
5707-3-00
5707-3-97
5708-3-00
5708-3-97
5789-3-97
0039-4-97
5325-5-00
5790-3-97
4801-3-00
4827-3-00
4828-3-00
4802-3-00
5325-4-00
0010-4-00
Spreadsheet: 848215d1698979193-how-to-calculate-a-pay-rate-that-is-affected-by-2-different-pay-conditions-pay-calculator_normal-pay-without-extra-days
Sheet: Data Validation Lists

SHIFT [NAME]
 | ADD-ON #1 | ADD-ON #2 | ADD-ON #3 | PAY CLASSIFICATION |  | NAME and STAFF # |  | DEPOT
NIL | Nil | Nil | Nil | Bus Operator |  | [NAME] | 875658
ADO | ADOC | High Capacity Allowance | No Build-Up Time | Duty Officer |  | [NAME] | 123456 | Brookvale
Annual Leave | Public Holiday |  | Travel Time | HDBOY |  | [NAME] | 894378 | North Sydney
[NAME] | Public Holiday+Work |  |  | Relief Yard Supervisor |  | [NAME] | 867770 | [NAME]
Day Off - No Pay | RDOC |  |  | Senior Bus Operator |  | [NAME] | 123456
Long Service Leave |  |  |  | Trainee Bus Operator |  | [NAME] | 123456 | Brookvale
Normal/Straight |  |  |  | [NAME] |  | [NAME] | 897397
RDO |  |  |  | Trainer
Sick Day
Sick Day With No Pay
Spreadsheet: 779168d1651608768-vlookup-in-multiple-columns-excelvl
Sheet: Sheet1

From Drops | email | Color1 | Color2 | Color3 | Color4 | Color5 | Color6 | Color7 | [NAME] | [NAME] | Color8 | Phone2
Job Found | [EMAIL] | Blue | Yellow | Green | Purple | Orange | White | Black | [EMAIL] | 5165551212 |  | 7185551212
 | VLOOKUP(B2:BM,Drops!$A$1:$B$2,2,FALSE) | This does not work
Spreadsheet: 36745d1234663454-link-sheets-and-populate-cell-based-on-entered-text-data1
Sheet: Data

 | Name | Won | Lost | Points | Average
 | [NAME] | 10 | 5 | 150
 | [NAME] | 6 | 9 | 95
 | [NAME] | 8 | 7 | 105
Spreadsheet: 101991d1300058721-protected-sheets-and-macros-demo
Sheet: Sheet2

 |  |  |  |  |  | LOGO HERE
Report of Name1 hours
Name |  | Lemonade |  |  |  | <---------------Change Name Here
Points Achieved |  |  | 2.5
Summary of Name1 Hours Participated in
[NAME] of auto filter here
Date | Name1 | Time In Hours
2010-07-01 00:00:00 | [NAME] | 0.5
2010-07-07 00:00:00 | Ish | 0.5
2010-07-14 00:00:00 | Flail | 0.5
2010-07-21 00:00:00 | Blah2 | 0.5
2010-08-04 00:00:00 | AndSoOn | 0.5
Spreadsheet: 0a8bce26-c259-4370-9454-3553150f3fae
Sheet: Math 2

 |  |  | 11-12 |  |  |  |  | 11-12 Total | 12-13 |  |  |  |  | 12-13 Total | 13-14 |  |  |  |  | 13-14 Total
Major | [NAME] | CrseNum | A | B | C | D | F |  | A | B | C | D | F |  | A | B | C | D | F
Mathematics Educ-Grades 6-12 / Mathematical Sciences | MATH | 113 | 4 | 1 |  |  | 2 | 7 | 1 |  |  |  |  | 1 | 3 |  |  |  |  | 3
 |  | 130 | 2 |  |  |  |  | 2 | 1 |  |  |  |  | 1
 |  | 170 | 3 | 3 |  |  |  | 6 | 2 | 2 |  |  |  | 4 | 2 | 1 |  |  |  | 3
 |  | 175 | 5 | 1 | 1 |  |  | 7 | 2 | 3 |  |  |  | 5 | 2 | 1 | 1 |  |  | 4
 |  | 185 |  |  | 1 |  |  | 1 | 1 |  |  |  |  | 1 |  | 2 | 1 |  |  | 3
 |  | 190 | 2 | 2 | 4 | 1 |  | 9 | 2 | 4 |  | 1 |  | 7 | 1 | 3 |  |  |  | 4
 |  | 231 | 6 | 3 |  |  |  | 9 | 5 | 1 |  |  |  | 6 | 2 | 2 |  |  |  | 4
 |  | 291 | 1 | 3 | 5 | 1 |  | 10 | 3 | 1 | 2 |  |  | 6 | 2 |  | 2 |  |  | 4
 |  | 292 | 3 | 4 | 2 |  |  | 9 | 4 |  | 2 |  |  | 6 | 2 | 1 | 1 | 1 |  | 5
 |  | 301 | 1 | 4 | 4 |  |  | 9 | 3 |  | 3 | 1 |  | 7 | 1 | 1 | 2 |  |  | 4
 |  | 307 | 5 | 3 | 1 |  |  | 9 | 4 | 2 |  |  |  | 6 | 2 | 2 |  |  |  | 4
 |  | 322 | 3 | 3 | 3 |  |  | 9 | 2 | 4 |  |  |  | 6 | 1 | 1 | 2 |  |  | 4
 |  | 406 | 4 | 3 | 2 |  |  | 9 | 4 | 1 | 1 |  |  | 6 | 1 | 3 |  |  |  | 4
 |  | 411 | 2 | 5 | 2 |  |  | 9 | 3 | 2 | 1 |  |  | 6 | 1 | 1 | 2 |  |  | 4
 |  | 421 | 1 | 2 | 6 |  |  | 9 | 2 | 2 | 2 |  |  | 6 |  | 1 | 3 |  |  | 4
 |  | 430 | 2 | 2 | 1 |  |  | 5 |  | 1 |  |  |  | 1
 |  | 431 | 3 | 1 |  |  |  | 4 | 5 |  |  |  |  | 5 | 3 | 1 |  |  |  | 4
 |  | 469 | 1 |  |  |  |  | 1 | 1 |  |  |  |  | 1 |  | 1 |  |  |  | 1
Mathematics Educ-Grades 6-12 / Mathematical Sciences Total |  |  | 48 | 40 | 32 | 2 | 2 | 124 | 45 | 23 | 11 | 2 |  | 81 | 23 | 21 | 14 | 1 |  | 59
Spreadsheet: 150251d1334350556-excel-2007-problem-with-sumproduct-across-muliple-sheets-sp-scross-sheets
Sheet: Summary

EE | EMPLOYEE | AAA | BBB | CCC | DDD | EEE
1 | Name 1
2 | Name 2
3 | Name 3
4 | Name 4
5 | Name 5
6 | Name 6
7 | Name 7
8 | Name 8
9 | Name 9
10 | Name 10
Spreadsheet: 211056d1359645268-help-row-into-column-another-sheet-dee2_version1
Sheet: CLASS

Sl.No | Name | Sub | FA(a) | FA(b) | FA(a+b) | SA
1 | Raja
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
2 | Raja
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
3 | [NAME]
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
4
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
5
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
6
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
7
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
8
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
9
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
10
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
11
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
12
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
13
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
14
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
15
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
16
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
17
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
18
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
19
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
20
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
21
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
22
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
23
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
24
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
25
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
26
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
27
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
28
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
29
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
30
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
31
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
32
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
33
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
34
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
35
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
36
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
37
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
38
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
39
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
40
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
41
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
42
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
43
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
44
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
45
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
Spreadsheet: 215267d1361319773-summing-vlookup-values-sample-average-vlookup
Sheet: Wednesday

Date: | 2013-02-13 00:00:00
Agent Group: | FL COE
Agent Name | ACD Calls | Avg ACD Time | Avg ACW Time | % Agent Occupancy w/ ACW | % Agent Occupancy w/o ACW | Extn In Calls | [NAME] In Time | Extn Out Calls | [NAME] Time | ACD Time | ACW Time | Agent [NAME] | Other Time | AUX Time | Avail Time | Staffed Time
Totals | 6928 | 02:35:00 | :05 | 81 | 78 | 54 | :50 | 938 | :12 | 12 days, 11:07:09 | 10:32:12 | 06:54:16 | 14:56:35 | 1 day, 16:51:50 | 3 days, 5:57:13 | 18 days, 18:19:15
agent 8062005 | 180 | 01:53:00 | :01 | 81 | 80 | 0 |  | 33 | :02 | 05:40:06 | :04:08 | :08:50 | :09:09 | :34:08 | 01:25:32 | 08:01:53
agent 8062054 | 167 | 02:04:00 | :02 | 82 | 80 | 1 | 02:01:00 | 19 | :09 | 05:43:55 | :05:14 | :08:17 | :08:53 | :39:43 | 01:23:26 | 08:09:28
agent 8062100 | 163 | 02:17:00 | :05 | 90 | 87 | 0 |  | 18 | :18 | 06:12:28 | :14:55 | :08:08 | :12:57 | :38:12 | :47:04 | 08:13:44
agent 8062109 | 153 | 02:15:00 | :00 | 85 | 84 | 0 |  | 40 | :12 | 05:43:47 | :01:31 | :07:51 | :32:02 | :35:00 | 01:03:10 | 08:03:21
agent 8062053 | 149 | 02:15:00 | :05 | 86 | 84 | 4 | 01:27:00 | 23 | :12 | 05:34:59 | :11:56 | :07:28 | :20:06 | :49:40 | :59:33 | 08:03:42
agent 8062056 | 149 | 02:16:00 | :01 | 86 | 85 | 0 |  | 22 | :09 | 05:37:22 | :03:01 | :07:17 | :25:49 | :51:01 | 01:02:09 | 08:06:39
agent 8062082 | 147 | 02:22:00 | :00 | 77 | 77 | 0 |  | 10 | :08 | 05:47:46 | :00:11 | :07:12 | :01:21 | :29:53 | 01:48:14 | 08:14:37
agent 8062020 | 142 | 02:25:00 | :00 | 88 | 88 | 0 |  | 25 | :15 | 05:43:54 | :00:00 | :07:19 | :14:21 | 01:05:34 | :51:46 | 08:02:54
agent 8062033 | 141 | 02:11:00 | :03 | 85 | 82 | 0 |  | 24 | :15 | 05:08:40 | :09:41 | :07:05 | :43:22 | :47:42 | 01:08:10 | 08:04:40
agent 8062133 | 133 | 02:43:00 | :08 | 92 | 88 | 0 |  | 24 | :09 | 06:02:06 | :18:51 | :06:32 | :28:25 | :44:09 | :35:45 | 08:15:48
agent [NAME] | 132 | 02:42:00 | :09 | 91 | 85 | 0 |  | 25 | :11 | 05:56:44 | :23:48 | :06:35 | :18:33 | :40:01 | :42:07 | 08:07:48
agent [NAME] | 128 | 02:24:00 | :04 | 81 | 79 | 0 |  | 19 | :21 | 05:08:11 | :08:43 | :06:32 | :19:34 | :55:30 | 01:19:32 | 07:58:02
agent 8062134 | 112 | 02:59:00 | :10 | 89 | 85 | 1 | :17 | 16 | :20 | 05:33:53 | :18:41 | :05:25 | :19:30 | :47:38 | :44:47 | 07:49:54
agent 8062088 | 110 | 03:02:00 | :07 | 88 | 85 | 0 |  | 18 | :19 | 05:33:10 | :12:12 | :05:33 | :36:29 | :40:28 | :54:46 | 08:02:38
agent 8062031 | 109 | 03:24:00 | :20 | 92 | 84 | 0 |  | 9 | :06 | 06:11:02 | :37:54 | :05:25 | :02:59 | :33:42 | :34:42 | 08:05:44
agent 8062114 | 109 | 02:06:00 | :05 | 78 | 74 | 1 | :15 | 16 | :27 | 03:48:34 | :12:18 | :05:27 | :05:33 | :36:54 | 01:11:42 | 06:00:28
agent 8062044 | 90 | 02:24:00 | :02 | 77 | 76 | 0 |  | 10 | :06 | 03:35:55 | :02:20 | :04:31 | :01:48 | :15:23 | 01:08:52 | 05:08:49
agent 8062036 | 76 | 02:37:00 | :00 | 49 | 49 | 1 | :08 | 7 | :46 | 03:18:52 | :00:33 | :03:29 | :02:42 | :56:25 | 03:42:20 | 08:04:21
agent 8062067 | 55 | 03:00:00 | :18 | 89 | 81 | 0 |  | 6 | :10 | 02:44:49 | :19:23 | :02:44 | :17:03 | :26:41 | :24:20 | 04:15:00
Spreadsheet: 1fe98130-b1a4-471d-85f9-88d59326acaf
Sheet: 7d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Fixed-Float | 223174057 | 90420970 | 25267605 | 47469321
FRA | 92166750 | 12838221 | 9589267 | 3234296
OIS | 54542201 | 14174929 | 7929536 | 6122401
OTHER* | 11961328 | 66114373 | 1130548 | 22421845
TOTAL
*OTHER variable includes the following products: Basis, Swaption, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, and Inflation.
Spreadsheet: 599323d1542972511-find-difference-formula-production-difference
Sheet: PRODUCTION DAY DIFFER

LOOM NO | 2018-11-01 00:00:00 | 2018-11-02 00:00:00 | 2018-11-03 00:00:00 | 2018-11-04 00:00:00 | 2018-11-05 00:00:00 | 2018-11-06 00:00:00 | 2018-11-07 00:00:00 | 2018-11-08 00:00:00 | 2018-11-09 00:00:00 | 2018-11-10 00:00:00 | 2018-11-11 00:00:00 | 2018-11-12 00:00:00 | 2018-11-13 00:00:00 | 2018-11-14 00:00:00 | 2018-11-15 00:00:00 | 2018-11-16 00:00:00 | 2018-11-17 00:00:00 | 2018-11-18 00:00:00 | 2018-11-19 00:00:00 | 2018-11-20 00:00:00 | 2018-11-21 00:00:00 | 2018-11-22 00:00:00 | 2018-11-23 00:00:00 | 2018-11-24 00:00:00 | 2018-11-25 00:00:00 | 2018-11-26 00:00:00 | 2018-11-27 00:00:00 | 2018-11-28 00:00:00 | 2018-11-29 00:00:00 | 2018-11-30 00:00:00
3
4
5
6
7
8
9
10
11
12
13
14
15
16
Spreadsheet: 6e585d14-d476-4fb0-9037-633ae55eb0a4
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | University of Arkansas at Pine Bluff | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16
 |  |  |  |  |  |  |  | Time Record: For Classified and Hourly Employees
Employee Name : |  |  |  |  |  |  |  |  | Social Security Number :
Department : |  | Printing Services
For the Month Ended :
Date | Regular Hours |  | [NAME] | Overtime |  | Hours Worked |  |  | Date | Regular Hours | [NAME] |  | Overtime |  | Hours Worked
 | Worked | Hours | Code | Start | End | Over   time | Extra Hours |  |  | Worked | Hours | Code | Start | End | Over   time | Extra Hours
1 | 0 |  |  |  |  | 00:00:00 | 00:00:00 |  | 16 |  |  |  |  |  | 00:00:00 | 00:00:00
2 | 0 |  |  |  |  | 00:00:00 | 00:00:00 |  | 17 |  |  |  |  |  | 00:00:00 | 00:00:00
3 | 0 |  |  |  |  | 00:00:00 | 00:00:00 |  | 18 |  |  |  |  |  | 00:00:00 | 00:00:00
4 | 0 |  |  |  |  | 00:00:00 | 00:00:00 |  | 19 |  |  |  |  |  | 00:00:00 | 00:00:00
5 | 0 |  |  |  |  | 00:00:00 | 00:00:00 |  | 20 |  |  |  |  |  | 00:00:00 | 00:00:00
6 | 0 |  |  |  |  | 00:00:00 | 00:00:00 |  | 21 |  |  |  |  |  | 00:00:00 | 00:00:00
7 | 0 |  |  |  |  | 00:00:00 | 00:00:00 |  | 22 |  |  |  |  |  | 00:00:00 | 00:00:00
8 | 0 |  |  |  |  | 00:00:00 | 00:00:00 |  | 23 |  |  |  |  |  | 00:00:00 | 00:00:00
9 | 0 |  |  |  |  | 00:00:00 | 00:00:00 |  | 24 |  |  |  |  |  | 00:00:00 | 00:00:00
10 | 0 |  |  |  |  | 00:00:00 | 00:00:00 |  | 25 |  |  |  |  |  | 00:00:00 | 00:00:00
11 | 0 |  |  |  |  | 00:00:00 | 00:00:00 |  | 26 |  |  |  |  |  | 00:00:00 | 00:00:00
12 | 0 |  |  |  |  | 00:00:00 | 00:00:00 |  | 27 |  |  |  |  |  | 00:00:00 | 00:00:00
13 | 0 |  |  |  |  | 00:00:00 | 00:00:00 |  | 28 |  |  |  |  |  | 00:00:00 | 00:00:00
14 | 0 |  |  |  |  | 00:00:00 | 00:00:00 |  | 29 |  |  |  |  |  | 00:00:00 | 00:00:00
15 | 0 |  |  |  |  | 00:00:00 | 00:00:00 |  | 30 |  |  |  |  |  | 00:00:00 | 00:00:00
 |  |  |  |  |  | 00:00:00 | 00:00:00 |  | 31 |  |  |  |  |  | 00:00:00 | 00:00:00
Total | 0 | 0 |  |  |  | 0 | 0 |  | Total | 0 | 0 |  |  |  | 0 | 0
 |  |  | Total Hours for the Month Ended |  |  |  |  |  |  | 0 | 0 |  |  |  | 0 | 0
SUMMARY
Vacation Hours Taken |  |  |  |  | (V) | 0 |  |  |  |  |  | My signature certifies that above recorded hours
Sick Hours Taken-Employee |  |  |  |  | (SE) | 0 |  |  |  |  |  | worked and leave taken are correct
Sick Hours Taken-Family |  |  |  |  | (SF) | 0
Holidays |  |  |  |  | (H) | 0
Other (Describe) |  |  |  |  | (O) | 0 |  |  |  |  |  | Signature (Employee)
Compensatory Time Taken |  |  |  |  | (C) | 0
Overtime [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Signature (Supervisor)
Extra Hours Worked |  |  |  |  |  |  |  |  |  |  |  | If all leave time has been exhausted
TOTAL HOURS TAKEN |  |  |  |  |  | 0 |  |  |  |  |  | leave without pay will be employed
Spreadsheet: 808087d1670276511-conditional-formatting-formula-if-statement-conditional-formatting-formula_ans
Sheet: Sheet1

 | Name | Invoice Date | 30 Days Later | Action
 | [NAME] | 2022-10-25 00:00:00
 | [NAME] | 2022-10-28 00:00:00
 | [NAME] | 2022-11-02 00:00:00
 | [NAME] | 2022-11-07 00:00:00
 | [NAME] | 2022-11-10 00:00:00
 | [NAME] | 2022-11-15 00:00:00
Spreadsheet: 788834d1658755370-age-in-y-m-d-format-from-days-or-months-agetable
Sheet: Sheet1

MOS | DAYS | WKS | YRS | YRSMOS | YRSMOSDAYS | AGECAT
 |  |  |  |  |  | C1
 |  |  |  |  |  | C1
 |  |  |  |  |  | C1
 |  |  |  |  |  | C1
Spreadsheet: 289124d1389400479-excel-2007-drop-down-box-range-help-excel-help
Sheet: Inputs

 |  |  |  |  | Section 1 |  | description |  | Section II |  | description
Sections |  | Module |  |  | Module 1 | 1-I.01 | Test 1 |  | Module 1 | 2-I.01 | Test 1-1
Section 1 |  | [NAME] |  |  |  | 1-I.02 | Test 2 |  |  | 2-I.02 | Test 1-2
Section 2 |  | Module 2 |  |  |  | 1-I.03 | Test 3 |  |  | 2-I.03 | Test 1-3
Section 3 |  | Module 3 |  |  | Module 2 | No Objectives |  |  | Module 2 | 2-I.04 | Test 1-4
Section 4 |  | Module 4 |  |  | Module 3 | 1-I.04 | Test 4 |  |  | 2-I.05 | Test 1-5
Section 5 |  | Module 5 |  |  |  | 1-I.05 | Test 5 |  |  | 2-I.06 | Test 1-6
Section 6 |  |  |  |  |  | 1-I.06 | Test 6 |  |  | 2-I.07 | Test 1-7
Section 7 |  |  |  |  | Module 4 | 1-II.07 | Test 7 |  | Module 3 | 2-II.08 | Test 1-8
Section 8 |  |  |  |  |  | 1-II.08 | Test 8 |  |  | 2-II.09 | Test 1-9
Section 9 |  |  |  |  |  |  |  |  |  | 2-II.09 | Test 1-10
Section 10 |  |  |  |  |  |  |  |  | Module 4 | No Objectives
Section 11
Section 12
Spreadsheet: 136695d1326794945-index-match-formula-index-and-match-formula
Sheet: UserSheet

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Customer 1 | Apr
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Customer 2 | May
 | Customer | Customer 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Customer 3 | Jun
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Customer 4 | Jul
 | Month | Apr |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Customer 5 | Aug
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Customer 6 | Sep
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Customer 7 | Oct
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Customer 8 | Nov
 | [NAME] | Customer Name | Units | m2 | £000s |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Customer 9 | Dec
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Customer 10 | Jan
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Feb
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar
 | Example Based on the cells [NAME] and C5
 | [NAME] | Customer Name | Units | m2 | £000s
 | 2 | Customer 2 | 3420 | 1891.101210727786 | 54.41281207933216
Spreadsheet: 194060d1353024245-filtering-data-and-then-re-filtering-that-data-help-suggestions-please-membership-database-and-log-copy
Sheet: Payment Status

Payment Status
Notes:
Quick Individual Member Payment Status Check
Member ID | Last Name | First Name | Membership Type | Membership Expires | Last Payment Date | Last Payment Type | Last Payment Length | Last Payment Amount
Status for Weekly or Monthly Billing
mil7890
Last Payment Made
Full Member Payment Status List
Member ID | Last Name | First Name | Membership Type | Membership Expires | Last Payment Date | Last Payment Type | Last Payment Length | Last Payment Amount
Spreadsheet: 887355d1737582042-override-conditional-formating-row-highlight-to-manual-highlight-mock-excel_01
Sheet: Sheet1

ORDER DATE | CUSTOMER | PRODUCT | QUANTITY | # OF PIECES | SHIP DATE | P/U TIME | DELIVERY DATE | DIS-PATCHED? | REP | NOTES
 |  | aaa |  |  |  |  |  |  | Salesman 1
 |  |  |  |  |  |  |  |  | Salesman 1
 |  | bb |  |  |  |  |  |  | Salesman 3
 |  |  |  |  |  |  |  |  | Salesman 1
 |  |  |  |  |  |  |  |  | Salesman 2
 |  |  |  |  |  |  |  |  | Salesman 3
 |  |  |  |  |  |  |  |  | Salesman 3
 |  |  |  |  |  |  |  |  | Salesman 2
 |  |  |  |  |  |  |  |  | Salesman 1
 |  | z |  |  |  |  |  |  | Salesman 1
 |  |  |  |  |  |  |  |  | Salesman 2
 |  |  |  |  |  |  |  |  | Salesman 2
 |  |  |  |  |  |  |  |  | Salesman 3
 |  |  |  |  |  |  |  |  | Salesman 1
Spreadsheet: 860982d1708998346-formula-to-match-partial-match-formula-to-match-items-with-partial-match
Sheet: Creditors

Code | Name | Period Month | Period Year | Reference | Sub-Reference | Date Processed | Outstanding | Due Date | Accounting Group | Ageing | Unmatched Items | Should Be
XM9854 |  |  |  | INV690643 |  |  | 10.55 | 2024-02-05 00:00:00 | Purchase | 22.14215011573833
XM9854 |  |  |  | INV690639 |  |  | 11.21 | 2024-02-05 00:00:00 | Purchase | 22.14215011573833
XM9854 |  |  |  | INV690649 |  |  | 26.98 | 2024-02-07 00:00:00 | Purchase | 20.14215011573833
XM9854 |  |  |  | 690670 |  |  | 173.32 | 2024-02-09 00:00:00 | Purchase | 18.14215011573833
XM9854 |  |  |  | 690668 |  |  | 11.21 | 2024-02-09 00:00:00 | Purchase | 18.14215011573833
XM9854 |  |  |  | 690703 |  |  | 11.21 | 2024-02-15 00:00:00 | Purchase | 12.14215011573833
XM9854 |  |  |  | 690698 |  |  | 83.33 | 2024-02-15 00:00:00 | Purchase | 12.14215011573833
XM9854 |  |  |  | 690699 |  |  | 74.8 | 2024-02-15 00:00:00 | Purchase | 12.14215011573833
XM9854 |  |  |  | 690746 |  |  | 15.43 | 2024-02-23 00:00:00 | Purchase | 4.142150115738332
XM9854 |  |  |  | 690749 |  |  | 15.43 | 2024-02-24 00:00:00 | Purchase | 5.14215011573833 |  | 690749
Spreadsheet: 110204d1306938416-excel-2007-can-a-cell-change-colour-based-on-a-calculation-alexa-rank
Sheet: Sheet1

Alexa Rank Stats
2011-03-30 00:00:00 | 3781207
2011-04-01 00:00:00 | 3797227
2011-04-05 00:00:00 | 3564567
2011-04-07 00:00:00 | 3567983
2011-04-11 00:00:00 | 3409058 |  |  | Total Difference:
 | 3261266
2011-05-05 00:00:00 | 3994804
2011-05-10 00:00:00 | 3447464
2011-05-16 00:00:00 | 3302578
2011-05-18 00:00:00 | 3303119
2011-05-20 00:00:00 | 2918274
2011-05-23 00:00:00 | 2927605
2011-05-24 00:00:00 | 2923816
2011-05-26 00:00:00 | 2926766
2011-06-01 00:00:00 | 2778938