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

Task | Star Date | End Date | Day | Month | NETWORKDAYS | NETWORKDAYS.INTL | Hours
A | 2021-02-10 10:55:31 | 2021-02-12 05:02:32 |  |  |  |  |  |  | Work schedule 09:00 to 17:00
B | 2021-01-05 23:43:52 | 2021-01-07 05:03:18
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?
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: 173208d1344469319-find-lowest-score-and-match-to-person-from-list-ef154_sort-with-tie-break
Sheet: Sheet1

GOLFER | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | total |  | tie-break
[NAME] | 4 | 5 | 6 | 5 | 2 | 6 | 1 | 8 | 1 | 8 | 2 | 9 | 1 | 8 | 8 | 2 | 1 | 8 | 85 |  | 84.999
[NAME] | 5 | 5 | 9 | 4 | 3 | 7 | 2 | 7 | 2 | 7 | 3 | 8 | 2 | 7 | 7 | 5 | 2 | 7 | 92 |  | 91.999
[NAME] | 3 | 6 | 3 | 6 | 4 | 4 | 3 | 6 | 3 | 6 | 4 | 7 | 3 | 6 | 9 | 6 | 3 | 6 | 88 |  | 87.999
fred | 2 | 4 | 5 | 7 | 5 | 9 | 4 | 5 | 4 | 5 | 5 | 6 | 4 | 5 | 3 | 8 | 4 | 5 | 90 |  | 89.999
 |  |  | PLACE | 1 | 2 | 3 | 4
 |  |  | SCORE | 84.999 | 87.999 | 89.999 | 91.999
 |  |  | GOLFER | [NAME] | [NAME] | fred | [NAME]
Spreadsheet: 777559d1650470153-help-with-multiple-dates-and-values-to-count-occurrences-ohio-river-flood-crest-date-info-2-excelforum-042022-v1-
Sheet: Rankings

high  rank | date recent  rank
16 | 1 | 46.12 | ft | 03/07/2021 (P)
26 | 2 | 44.53 | ft | 2020-02-17 00:00:00
24 | 3 | 44.91 | ft | 2019-02-28 00:00:00
15 | 4 | 46.45 | ft | 2019-02-15 00:00:00
7 | 5 | 50.68 | ft | 2018-02-27 00:00:00
35 | 6 | 42.97 | ft | 2015-12-30 00:00:00
38 | 7 | 42.3 | ft | 2015-04-18 00:00:00
12 | 8 | 47.33 | ft | 2015-03-17 00:00:00
8 | 9 | 49.3 | ft | 2011-04-28 00:00:00
21 | 10 | 45.32 | ft | 2011-03-15 00:00:00
42 | 11 | 41.5 | ft | 2010-05-07 00:00:00
22 | 12 | 45.04 | ft | 2008-03-22 00:00:00
18 | 13 | 46.05 | ft | 2005-01-14 00:00:00
32 | 14 | 43.55 | ft | 2004-01-09 00:00:00
41 | 15 | 41.56 | ft | 2003-02-28 00:00:00
34 | 16 | 43.25 | ft | 2002-03-25 00:00:00
25 | 17 | 44.69 | ft | 2000-02-22 00:00:00
5 | 18 | 52.42 | ft | 1997-03-08 00:00:00
29 | 19 | 44.3 | ft | 1996-05-13 00:00:00
19 | 20 | 46.03 | ft | 1996-01-27 00:00:00
28 | 21 | 44.32 | ft | 1995-05-23 00:00:00
37 | 22 | 42.5 | ft | 1994-04-20 00:00:00
30 | 23 | 44.1 | ft | 1994-03-16 00:00:00
27 | 24 | 44.52 | ft | 1994-02-01 00:00:00
39 | 25 | 42.04 | ft | 1993-03-10 00:00:00
14 | 26 | 46.85 | ft | 1991-01-05 00:00:00
23 | 27 | 45 | ft | 1990-12-25 00:00:00
31 | 28 | 43.63 | ft | 1990-02-17 00:00:00
17 | 29 | 46.08 | ft | 1989-02-21 00:00:00
36 | 30 | 42.51 | ft | 1985-12-04 00:00:00
20 | 31 | 45.85 | ft | 1984-05-12 00:00:00
9 | 32 | 49.08 | ft | 1978-12-15 00:00:00
40 | 33 | 41.94 | ft | 1977-04-11 00:00:00
33 | 34 | 43.5 | ft | 1976-02-23 00:00:00
13 | 35 | 46.9 | ft | 1972-04-21 00:00:00
43 | 36 | 41.2 | ft | 1971-02-25 00:00:00
44 | 37 | 41.2 | ft | 1971-02-25 00:00:00
3 | 38 | 53.9 | ft | 1964-03-08 00:00:00
11 | 39 | 48.8 | ft | 1962-03-06 00:00:00
6 | 40 | 51.3 | ft | 1948-04-20 00:00:00
2 | 41 | 54.4 | ft | 1945-03-08 00:00:00
10 | 42 | 48.9 | ft | 1943-03-24 00:00:00
1 | 43 | 60.8 | ft | 1937-01-27 00:00:00
4 | 44 | 53.8 | ft | 1913-04-01 00:00:00
Spreadsheet: 726220d1617112708-return-each-occurrence-of-a-value-from-a-list-list-file-test
Sheet: Statistics

Frozen stock holding by Sku 2020
Product
APPLE
Batch | Quantity | Weeks in Storage | Storage Cost | Value | Avg Total Cost per Kg
WK1
Spreadsheet: 94420d1294244717-value-error-from-a-countifs-formula-vessel-report-on-the-hour-iii
Sheet: LEGEND

Time | 01:00:00 | 02:00:00 | 03:00:00 | 04:00:00 | 05:00:00 | 06:00:00 | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00 | 1900-01-01 00:00:00 | 25 A.M
Disc
Load
Total
 |  |  |  |  | Start
 |  |  |  |  | Stop
 |  |  |  |  |  |  |  |  |  | BERTH 15
Time | 01:00:00 | 02:00:00 | 03:00:00 | 04:00:00 | 05:00:00 | 06:00:00 | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00 | 1900-01-01 00:00:00 | 25 A.M
Disc
Load
Total
 |  |  |  |  |  |  |  |  |  | BERTH 16
Time | 01:00:00 | 02:00:00 | 03:00:00 | 04:00:00 | 05:00:00 | 06:00:00 | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00 | 1900-01-01 00:00:00
Disc
Load
Total
 |  |  |  |  |  |  |  |  |  | BERTH 17
Time | 01:00:00 | 02:00:00 | 03:00:00 | 04:00:00 | 05:00:00 | 06:00:00 | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00 | 1900-01-01 00:00:00 | 25 A.M
Disc
Load
Total
 |  |  |  |  |  |  |  |  |  | BERTH 18
Time | 01:00:00 | 02:00:00 | 03:00:00 | 04:00:00 | 05:00:00 | 06:00:00 | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00 | 1900-01-01 00:00:00 | 25 A.M
Disc
Load
Total
Spreadsheet: 684260d1593235026-calculate-increase-by-date-range-with-multiple-worksheets-excel-rehersal
Sheet: Report

Last Total | 2020-07-01 00:00:00 | 2020-07-13 00:00:00 | 2020-07-27 00:00:00 | 2020-08-10 00:00:00 | 2020-08-24 00:00:00 | 2020-09-07 00:00:00 | 2020-09-21 00:00:00 | 2020-10-05 00:00:00 | 2020-10-19 00:00:00 | 2020-11-02 00:00:00 | 2020-11-16 00:00:00 | 2020-11-30 00:00:00 | 2020-12-14 00:00:00 | 2020-12-28 00:00:00 | 2021-01-11 00:00:00 | 2021-01-25 00:00:00 | 2021-02-08 00:00:00 | 2021-02-22 00:00:00 | 2021-03-08 00:00:00 | 2021-03-22 00:00:00 | 2021-04-05 00:00:00 | 2021-04-19 00:00:00 | 2021-05-03 00:00:00 | 2021-05-17 00:00:00 | 2021-05-31 00:00:00 | 2021-06-14 00:00:00 | 2021-06-28 00:00:00
Spreadsheet: f8a1fed1-7ec0-41c3-99a0-cca4f7085b67
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Valor | 0 |  | Retenção | 0.0639
N | Tarifa ao cliente | Acréscimo | Retenção Total  (sem tarifa ao cliente) | Cliente  (plano comum) | Valor a receber  (plano comum) | Vendedor quer [NAME] | Valor do Produto  (sem acréscimo) | Parcela ao cliente | Teste  (valor a receber) | % Acréscimo
1 |  |  | 0.0639 | 0 | 0 | 0 | 0 | 0 | 0
2 | 0.0199 | 0.04019601000000006 | 0.1040960100000001 | 0 | 0 | 0 | 0 | 0 | 0
3 | 0.0199 | 0.06089591059900012 | 0.1247959105990001 | 0 | 0 | 0 | 0 | 0 | 0
4 | 0.0199 | 0.08200773921992033 | 0.1459077392199203 | 0 | 0 | 0 | 0 | 0 | 0
5 | 0.0199 | 0.1035396932303967 | 0.1674396932303967 | 0 | 0 | 0 | 0 | 0 | 0
6 | 0.0199 | 0.1255001331256818 | 0.1894001331256818 | 0 | 0 | 0 | 0 | 0 | 0
7 | 0.0199 | 0.1478975857748828 | 0.2117975857748828 | 0 | 0 | 0 | 0 | 0 | 0
8 | 0.0199 | 0.170740747731803 | 0.234640747731803 | 0 | 0 | 0 | 0 | 0 | 0
9 | 0.0199 | 0.1940384886116659 | 0.257938488611666 | 0 | 0 | 0 | 0 | 0 | 0
10 | 0.0199 | 0.2177998545350381 | 0.2816998545350382 | 0 | 0 | 0 | 0 | 0 | 0
11 | 0.0199 | 0.2420340716402856 | 0.3059340716402856 | 0 | 0 | 0 | 0 | 0 | 0
12 | 0.0199 | 0.2667505496659273 | 0.3306505496659273 | 0 | 0 | 0 | 0 | 0 | 0
13 | 0.0199 | 0.2919588856042792 | 0.3558588856042792 | 0 | 0 | 0 | 0 | 0 | 0
14 | 0.0199 | 0.3176688674278045 | 0.3815688674278045 | 0 | 0 | 0 | 0 | 0 | 0
15 | 0.0199 | 0.3438904778896177 | 0.4077904778896177 | 0 | 0 | 0 | 0 | 0 | 0
16 | 0.0199 | 0.3706338983996214 | 0.4345338983996214 | 0 | 0 | 0 | 0 | 0 | 0
17 | 0.0199 | 0.3979095129777739 | 0.4618095129777739 | 0 | 0 | 0 | 0 | 0 | 0
18 | 0.0199 | 0.4257279122860316 | 0.4896279122860316 | 0 | 0 | 0 | 0 | 0 | 0
19 | 0.0199 | 0.4540998977405237 | 0.5179998977405237 | 0 | 0 | 0 | 0 | 0 | 0
20 | 0.0199 | 0.4830364857055602 | 0.5469364857055602 | 0 | 0 | 0 | 0 | 0 | 0
21 | 0.0199 | 0.5125489117711008 | 0.5764489117711008 | 0 | 0 | 0 | 0 | 0 | 0
22 | 0.0199 | 0.5426486351153459 | 0.6065486351153458 | 0 | 0 | 0 | 0 | 0 | 0
23 | 0.0199 | 0.5733473429541414 | 0.6372473429541413 | 0 | 0 | 0 | 0 | 0 | 0
24 | 0.0199 | 0.6046569550789289 | 0.6685569550789289 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 355690d1414760833-collating-information-from-multiple-worksheets-to-one-worksheet-lv-switchgear-new
Sheet: PROTECTION & INTERLOCK

COMP.REF. | DRG REF | [NAME] | MANUFACTURER | SUPPLIER | PART NUMBER | B&S Part Number | QUANT | REMARKS
 |  | LOCKOUT RELAY 24VDC | AVK/SEG |  | MRL1-24D
 |  | REF RELAY 24VDC AUX 5A SECONDARY | AVK/SEG |  | IRI1-ER/5/L/D
 |  | G59 RELAY | AVK/SEG |  | MFR11-VDEW
 |  | G59 RELAY | AVK/SEG |  | MRU4 |  | 1
 |  | DELIVERY FROM AVK/SEG | AVK/SEG |  | PER UNIT |  | 1
 |  | G59 RELAY | IPU/COMAP |  | MAINS PRO |  | 1
 |  | G59 RELAY DOOR MOUNTING KIT | IPU/COMAP |  | MAINS PRO FRAME |  | 1
 |  | DELIVERY FROM IPU/COMAP | IPU/COMAP |  | PER SHIPMENT |  | 1
 |  | CLASS X CTS | CTT
 |  | DEEPSEA UNIT | DEEPSEA ELECTRONICS |  | DSE 8660
 |  | 24VDC 10A BATTERY CHARGER | DEEPSEA ELECTRONICS |  | DSE 9470
 |  | SOLENOID INTERLOCK 2NO/2NC | FORTRESS |  | SS1-BLBP-X002
 |  | ACB INTERLOCK | FORTRESS |  | FS LOCK
 |  | TX HOUSING 2 KEYS | FORTRESS |  | P20-
 |  | KEY | FORTRESS |  | BLK-C
 |  | ELECTRICAL INTERLOCK 2NO/2NC | FORTRESS |  | S-BLBP-A02022
 |  | BOLT INTERLOCK | FORTRESS |  | Q1-BLBP-B-LS
 |  | ELECTRICAL INTERLOCK 2NO/2NC - PANEL MOUNT | CASTELL |  | KS 20 FS 4 POLE
 |  | ELECTRICAL INTERLOCK 3NO/3NC - PANEL MOUNT | CASTELL |  | KS 30 FS 6 POLE
 |  | ELECTRICAL INTERLOCK 2NO/2NC -  ENCLOSURE | CASTELL |  | KS 20 FS 4 POLE
 |  | BOLT INTERLOCK  FS TYPE K BRASS | CASTELL |  | K-FSB-6.4-FORM "X"
 |  | BOLT INTERLOCK MULTIKEY | CASTELL |  | FS TYPE KL BRASS
 |  | PANEL DOOR LOCK | CASTELL |  | TYPE D (BRASS) FK4 KEY
 |  | ACB INTERLOCK | CASTELL |  | PDS01388
 |  | SOLENOID INTERLOCK 2NO/2NC | CASTELL |  | UPS-FSB-P-C/04-240A
 |  | SOLENOID INTERLOCK 3NO/3NC | CASTELL |  | UPS-FSB-P-C/06-240A
 |  | SURFACE MOUNT SOLENOID INTERLOCK | CASTELL |  | KSS-20
 |  | KEY EXCHANGE BOX 2 IN 1 OUT | CASTELL |  | B FS 2in 1out
 |  | KEY EXCHANGE BOX 3 IN 1 OUT | CASTELL |  | B FS 3in 1out
 |  | TRANSFORMER HOUSING LOCK | CASTELL |  | BD-FSB-F-1S-D-RE-MS-2
 |  | KEY | CASTELL |  | FK4-NI
 |  | CARRIAGE AND PACKING | CASTELL |  | (£19.50) + 2% of goods value
 |  |  |  |  |  |  | .
 |  |  |  |  |  |  | .
Spreadsheet: 108385d1305437921-if-a-cell-in-a-column-in-any-worksheet-x-copy-entire-row-budget_update
Sheet: Utilities

Utilities
 |  |  |  |  | Total Utilities Budget | Spent So Far | Total Remaining
 |  |  |  |  | 100 | 113.35 | -13.34999999999999
Date | Location | Memo | Method | Amount
2011-04-25 00:00:00 | Xfinity |  | VISA | 24
2011-04-23 00:00:00 | City |  | VISA | 25.22
2011-04-20 00:00:00 | Power Co |  | VISA | 64.13
Spreadsheet: 291835d1390417169-automatically-copy-a-row-of-data-from-one-sheet-to-another-routsheet
Sheet: 908

RO# | OWNERS NAME | TAG | ADVISOR | [NAME] OF WORK | PROMISE TIME | 10 | 12 | 2 | 4 | DISPATCH TIME
74358 | SHORE | 827 | 908 | DASH HARNESS | 1.22.14
73821 | RUIZ | 11 | 1013 | RUNNING BOARD | 1.21.14
26777 | ncd | k14209 | 1052 | abs pump | asap
75050 | MALBIA | 399 | 1052 | RECALL | WAIT
Spreadsheet: 2a37936f-ff8d-43fd-ac63-acd372c811c5
Sheet: Sheet1

Information Resource Center Product Abstract | Unnamed: 1
Abstract Item | Place the answers in the blue fields below.
Name of Product: | Publication
File Name: | "FH Gazette Summer 2007"
Category: | discrimination
Office: | Legal Aid Society of Palm Beach County
Audience: | FHIP Grantees
Contact Number: | [PHONE]
Summary of Product: | Seasonal publication to inform residents of Palm Beach County, FL of fair housing laws through local stories and articles
Date Completed:
Key Words: | discrimination, Florida, fair housing, newsletter
Spreadsheet: 27a5ac58-e75f-4b3d-87b9-546682369d86
Sheet: Sheet1

Campus | Last Name | First Name | [NAME] | Phone Number | Fax Number | Street | Street2 | City | State | Zip
Appalachian State University | [NAME] | [NAME] | [EMAIL] | [PHONE] | [PHONE] | Academy Drive |  | Boone | NC | 28608
East Carolina University | Schwan | [NAME] | [EMAIL] | [PHONE] |  | East Fifth Street |  | Greenville | NC | 27858
Elizabeth City State University | Azaglo | Priscilla |  |  |  | [NAME] |  | Elizabeth City | NC | 27909
Fayetteville State University | Jones | [NAME] | [NAME] | [PHONE] |  | 1200 Murchison Road |  | Fayetteville | NC | 28301
NC Agricultural and Technical State University | Turner | Canisha | [EMAIL] | [PHONE] | [PHONE] | 1601 East Market Street |  | Greensboro | NC | 27411
North Carolina Central University | Weathers | [NAME] | [EMAIL] | [PHONE] |  | 1801 Fayetteville Street |  | [NAME] | NC | 27707
NC State University | Parker | [NAME] | [EMAIL] | [PHONE] |  |  |  | Raleigh | NC | 27695
UNC Asheville | Whittaker | Leigh | [EMAIL] | [PHONE] |  | 1 University Heights |  | Asheville | NC | 28804
UNC-Chapel Hill | [NAME] | Christy | [EMAIL] | [PHONE] |  |  |  | Chapel Hill | NC | 27599
UNC Charlotte | Nails | [NAME] | [EMAIL] | [PHONE] |  | 9201 University City Boulevard |  | Charlotte | NC | 28223
UNC Greensboro | Bayne | Crystal | [EMAIL] | [PHONE] |  | Student Government Association | 226 Elliott University Center, 221 EUC, [NAME],                              P.O. Box 26170 | Greensboro | NC | 27402
UNC Pembroke | [NAME] | Emily | [EMAIL] | [PHONE] |  | 1 University Drive |  | Pembroke | NC | 28372
[NAME] | Steffey | Zachary | [EMAIL] | [PHONE] |  | 601 S. College Road |  | [NAME] | NC | 28403
UNC School of the Arts | Blankinship | [NAME] | [EMAIL] |  |  | 1533 South Main St. |  | Winston-Salem | NC | 27127
Western Carolina University | Hermance | [NAME] | [EMAIL] | [PHONE] |  |  |  | Cullowhee | NC | 28723
Winston-Salem State University | Bell | Bryant | [EMAIL] | [PHONE] |  | 601 [NAME], Jr. Drive |  | Winston-Salem | NC | 27110
North Carolina School of Science and Mathematics | Thakker | Parth | [EMAIL] |  |  | 1219 Broad Street |  | [NAME] | NC | 27705
Spreadsheet: 761250d1640778456-if-statement-to-include-3-conditions-and-outcomes-based-on-dates-and-blank-cells-deferred-income-subs-status
Sheet: Dec 21

Deferred Income Calculation
2021-12-31 00:00:00
ID | Organisation | First Joined | Live or Expired | Contract Value | Currency | Contract GBP Value | Contract Length (mths) | Contract Length (yrs) | Contract Start Date | Contract End Date
 | Expired Subscription | 2020-12-04 00:00:00 |  | 5000 | EUR |  | 12 |  | 2020-12-04 00:00:00 | 2021-12-03 00:00:00
 | Pending Subscription | 2021-11-01 00:00:00 |  |  |  |  | 12
 | Live Subscription | 2021-11-01 00:00:00 |  | 7000 | GBP |  | 12 |  | 2021-12-06 00:00:00 | 2022-12-05 00:00:00
Spreadsheet: 60200d1260771757-how-to-remove-formula-from-creating-duplicate-values-2010
Sheet: February

 |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
 |  | 2010-02-01 00:00:00 |  | 2010-02-02 00:00:00 |  | 2010-02-03 00:00:00 |  | 2010-02-04 00:00:00 |  | 2010-02-05 00:00:00 |  | 2010-02-06 00:00:00 |  | 2010-02-08 00:00:00 |  | 2010-02-09 00:00:00 |  | 2010-02-10 00:00:00 |  | 2010-02-11 00:00:00 |  | 2010-02-12 00:00:00 |  | 2010-02-13 00:00:00 |  | 2010-02-15 00:00:00 |  | 2010-02-16 00:00:00 |  | 2010-02-17 00:00:00 |  | 2010-02-18 00:00:00 |  | 2010-02-19 00:00:00 |  | 2010-02-20 00:00:00 |  | 2010-02-22 00:00:00 |  | 2010-02-23 00:00:00 |  | 2010-02-24 00:00:00 |  | 2010-02-25 00:00:00 |  | 2010-02-26 00:00:00 |  | 2010-02-27 00:00:00
Consultant Name | Team Leader | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved
Mpho | [NAME]
[NAME] | [NAME]
Glodean ([NAME]) | [NAME]
[NAME] | [NAME]
Lehlohonolo | [NAME]
Matshidiso | [NAME]
Rachel | [NAME]
Naledi G | [NAME]
Innocentia | [NAME]
Glyndine | [NAME]
Vacant | [NAME]
Vacant | [NAME]
Vacant | [NAME]
Total |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Consultant | Leads | Total Sales | Monthly Target | [NAME] | Total Approved | QA Monthly Score | QA Rating
Mpho |  | 0 |  | 0 | 0 |  | -
[NAME] |  | 0 |  | 0 | 0 |  | -
Glodean ([NAME]) |  | 0 |  | 0 | 0 |  | -
[NAME] |  | 0 |  | 0 | 0 |  | -
Lehlohonolo |  | 0 |  | 0 | 0 |  | -
Matshidiso |  | 0 |  | 0 | 0 |  | -
Rachel |  | 0 |  | 0 | 0 |  | -
Naledi G |  | 0 |  | 0 | 0 |  | -
Innocentia |  | 0 |  | 0 | 0 |  | -
Glyndine |  | 0 |  | 0 | 0 |  | -
Vacant |  | 0 |  | 0 | 0 |  | -
Vacant |  | 0 |  | 0 | 0 |  | -
Vacant |  | 0 |  | 0 | 0 |  | -
Total | 0 | 0 | 0 | 0 | 0 | #N/A | #N/A
 |  | 0 | 0.8499 | D
 |  | 0.85 | 0.9 | C
 |  | 0.91 | 0.9499 | B
 |  | 0.95 | 1 | A
Spreadsheet: 684056d1593109726-help-with-conditional-formating-for-inventory-control-inventory-example
Sheet: Sheet1

Item | Required Quaintity | On Hand Quantity
Spoons | 100 | 100 |  |  | So I want the cells in Column C highlight based on the corsponding cell in Column B. If the QTY on hand is less than the required QTY highlight the cell light red. If the QTY on hand is = to the corsponding cell in Column B then highlight light green.
Cups | 200 | 250
Plates | 50 | 50
Knifes | 20 | 19
[NAME] | 1000 | 999
Aprons | 3 | 3
Spreadsheet: 121039d1315790017-pivot-table-to-simple-list-pivot-table-to-list-request
Sheet: Source Data

This would be my source data that I am using for tracking testing and tsetgin information
 | Test Specification | Insignificant Column1 | Insignificant Column2 | Insignificant Column3 | Insignificant Column4 | Insignificant Column5 | Test Sample Configuration 1 | Test Sample Configuration 2 | Test Sample Configuration 3 | Test Sample Configuration 4 | Insignificant Column6 | Insignificant Column7 | Insignificant Column8 | Insignificant Column9
 | Spec 1 | Text | Text | Text | Text | Text | 1 | 1 | 1 | 1 | Text | Text | Text | Text
 | Spec 2 | Text | Text | Text | Text | Text | 1 |  | 1 | 1 | Text | Text | Text | Text
 | Spec 3 | Text | Text | Text | Text | Text |  | 1 | 1 |  | Text | Text | Text | Text
 | Spec 4 | Text | Text | Text | Text | Text | 1 |  | 1 | 1 | Text | Text | Text | Text
 | Spec 5 | Text | Text | Text | Text | Text | 1 | 1 |  | 1 | Text | Text | Text | Text
 | Spec 6 | Text | Text | Text | Text | Text |  | 1 | 1 |  | Text | Text | Text | Text
 | Spec 7 | Text | Text | Text | Text | Text | 1 |  | 1 | 1 | Text | Text | Text | Text
 | Spec 8 | Text | Text | Text | Text | Text | 1 | 1 |  | 1 | Text | Text | Text | Text
 | Spec 9 | Text | Text | Text | Text | Text |  | 1 | 1 |  | Text | Text | Text | Text
 | Spec 10 | Text | Text | Text | Text | Text | 1 |  | 1 | 1 | Text | Text | Text | Text
 | Spec 11 | Text | Text | Text | Text | Text | 1 | 1 |  |  | Text | Text | Text | Text
 | Spec 12 | Text | Text | Text | Text | Text |  | 1 | 1 | 1 | Text | Text | Text | Text
 | Spec 13 | Text | Text | Text | Text | Text | 1 |  |  | 1 | Text | Text | Text | Text
 | Spec 14 | Text | Text | Text | Text | Text |  | 1 | 1 | 1 | Text | Text | Text | Text
 | Spec 15 | Text | Text | Text | Text | Text | 1 |  | 1 | 1 | Text | Text | Text | Text
 | Spec 16 | Text | Text | Text | Text | Text | 1 | 1 | 1 | 1 | Text | Text | Text | Text
 | Spec 17 | Text | Text | Text | Text | Text | 1 | 1 | 1 | 1 | Text | Text | Text | Text
 | Spec 18 | Text | Text | Text | Text | Text | 1 | 1 | 1 |  | Text | Text | Text | Text
 | Spec 19 | Text | Text | Text | Text | Text | 1 | 1 | 1 |  | Text | Text | Text | Text
 | Spec 20 | Text | Text | Text | Text | Text | 1 | 1 |  |  | Text | Text | Text | Text
Spreadsheet: 162170d1339756994-excel-2007-formula-returning-last-value-needs-few-tweaks-example
Sheet: 1

 |  |  |  |  |  |  |  |  |  |  |  | 100000
Number | P/L                                    € |  |  |  |  |  | 0 |  |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0
1 | 2972.499999999997
1 | 3576.999999999997
2 | 2367.999999999997
2 | 3576.999999999997
3 | 4785.999999999995
4 | -4885.999999999995
5 | -4885.999999999995
6 | 4785.999999999995
7 | 4785.999999999995
8 | 4785.999999999995
9 | 4785.999999999995
10 | 4785.999999999995
11 | -4885.999999999995
12 | -4885.999999999995
13 | 4785.999999999995
14 | 4785.999999999995
15 | 4785.999999999995
16 | 4785.999999999995
17 | 4785.999999999995
18 | -4885.999999999995
19 | -4885.999999999995
20 | -4885.999999999995
21 | -4885.999999999995
22 | -4885.999999999995