tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 730462d1619707700-modify-formula-and-conditional-formatting-booking-sheet-ans
Sheet: Availability

 | AVAILABILITY AT WINDOW PERIOD |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-07-23 00:00:00 |  | 2021-08-06 00:00:00
 | Reference Start Date |  | 2021-07-01 00:00:00 |  | 22
 | Period | Start Time | End Time | 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 | 2021-08-01 00:00:00 | 2021-08-02 00:00:00 | 2021-08-03 00:00:00 | 2021-08-04 00:00:00 | 2021-08-05 00:00:00 | 2021-08-06 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 | 2021-08-01 00:00:00 | 2021-08-02 00:00:00 | 2021-08-03 00:00:00 | 2021-08-04 00:00:00 | 2021-08-05 00:00:00 | 2021-08-06 00:00:00 |  |  | Available
 | 1 | 06:00:00 | 10:00:00
 | 2 | 11:00:00 | 15:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Not Available
 | 3 | 17:00:00 | 21:00:00
 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Double Reservation
 | No | Customer |  | Phone |  |  | Event |  |  | ID |  |  | Book Date |  |  | Book Period |  |  | Notes
 | 1 | [NAME] |  |  |  |  |  |  |  |  |  |  | 2021-07-26 00:00:00 |  |  | 1
 | 2 | [NAME] |  |  |  |  |  |  |  |  |  |  | 2021-07-26 00:00:00 |  |  | 2
 | 3 | [NAME] |  |  |  |  |  |  |  |  |  |  | 2021-07-29 00:00:00 |  |  | 1
 | 4 | Cantique |  |  |  |  |  |  |  |  |  |  | 2021-07-27 00:00:00 |  |  | 2
 | 5 | Gladys |  |  |  |  |  |  |  |  |  |  | 2021-08-09 00:00:00 |  |  | 1
 | 6 | Serlia |  |  |  |  |  |  |  |  |  |  | 2021-08-09 00:00:00 |  |  | 1
 | 7 | [NAME] |  |  |  |  |  |  |  |  |  |  | 2021-07-29 00:00:00 |  |  | 1
 | 8 | Dewi |  |  |  |  |  |  |  |  |  |  | 2021-08-08 00:00:00 |  |  | 3
Spreadsheet: 121040d1315797268-read-another-sheet-nfl-football-schedule-2011-2012
Sheet: Week 1

Team | 1 | 2 | 3 | 4 | OT | Total | W/L
New Orleans Saints | 7 | 10 | 10 | 7
Green Bay Packers | 21 | 7 | 7 | 7
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Atlanta Falcons | 3 | 0 | 3 | 6
Chicago Bears | 10 | 6 | 14 | 0
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Cincinnati Bengals | 10 | 3 | 0 | 14
[NAME] | 0 | 14 | 3 | 0
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Buffalo Bills | 14 | 6 | 14 | 7
Kansas City Chiefs | 0 | 7 | 0 | 0
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Philadelphia Eagles | 14 | 3 | 7 | 7
St. Louis Rams | 7 | 3 | 3 | 0
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Detroit Lions | 6 | 14 | 7 | 0
Tampa Bay Buccaneers | 10 | 3 | 0 | 7
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Tennessee Titans | 0 | 0 | 7 | 7
[NAME] | 7 | 3 | 3 | 3
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Pittsburgh Steelers | 0 | 7 | 0 | 0
Baltimore Ravens | 14 | 7 | 11 | 3
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Indianapolis Colts | 0 | 0 | 0 | 7
Houston Texans | 17 | 17 | 0 | 0
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
New York Giants | 7 | 7 | 0 | 0
Washington Redskins | 0 | 14 | 7 | 7
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
[NAME] | 0 | 0 | 7 | 10
San Francisco 49ers | 0 | 16 | 0 | 17
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Minnesota Vikings | 7 | 10 | 0 | 0
San Diego Chargers | 7 | 0 | 7 | 10
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Carolina Panthers | 7 | 7 | 7 | 0
Arizona Cardinals | 7 | 0 | 7 | 14
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Dallas Cowboys | 7 | 3 | 7 | 7
New York Jets | 0 | 7 | 3 | 6
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
New England Patriots
[NAME]
Team | 1 | 2 | 3 | 4 | OT | Total | W/L
Oakland Raiders
Denver Broncos
Spreadsheet: 3874c125-cb36-4ce6-aeac-cbdb5654d277
Sheet: Table 1.2

Monthly Statistical Bulletin
1.2 Unemployment
Month | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013–14
Number unemployed (a) – '000
July | 652.2862837 | 618.7075169 | 605.8224145 | 625.7479334 | 692.6155035
August | 656.4349881 | 585.339719 | 621.3762626 | 612.3826069 | 703.740322
September | 651.6425126 | 593.4409474 | 623.0494736 | 662.9320518 | 694.2222228
October | 643.7446449 | 617.0086145 | 610.8617822 | 646.0369361 | 702.279504
November | 638.7421271 | 601.0090389 | 621.6460752 | 631.5513152 | 705.8350297
December | 633.6218045 | 572.4913912 | 613.9250887 | 651.7059163 | 714.455804
January | 609.3749826 | 593.9216442 | 604.715574 | 657.4024993 | 729.7898591
February | 611.5020701 | 586.0590959 | 618.8442249 | 655.3221753 | 741.4609937
March | 623.3440446 | 577.2533282 | 614.8307304 | 677.7586109 | 713.7891335
April | 633.4337338 | 581.880874 | 594.274051 | 678.8382646 | 713.4158141
May | 599.4835 | 585.4149234 | 617.6686225 | 673.1666684
June | 598.2678803 | 583.5777919 | 621.6108329 | 698.0785467
Annual average | 628.1305094416666 | 590.6837662416666 | 613.8477528583334 | 656.180680075
Unemployment rate (a) (b) – per cent
July | 5.695507 | 5.3153186 | 5.1240121 | 5.2243774 | 5.6936433
August | 5.7389023 | 5.0279106 | 5.2477853 | 5.1173997 | 5.7831128
September | 5.6875126 | 5.0832039 | 5.2512698 | 5.5082278 | 5.7076472
October | 5.6121402 | 5.2618831 | 5.1488417 | 5.3714822 | 5.7674688
November | 5.5588718 | 5.1077669 | 5.23247 | 5.2526021 | 5.7875666
December | 5.5014856 | 4.8754556 | 5.1804615 | 5.4050545 | 5.8653892
January | 5.2828852 | 5.057176 | 5.0866917 | 5.4352654 | 5.9734717
February | 5.3028716 | 4.9821566 | 5.205163 | 5.4065362 | 6.0388438
March | 5.3929702 | 4.8909738 | 5.1435241 | 5.594728 | 5.8161953
April | 5.4715425 | 4.9440803 | 4.986788 | 5.5869365 | 5.8066083
May | 5.1938741 | 4.9780177 | 5.1558317 | 5.5462054
June | 5.158131 | 4.9475822 | 5.1979625 | 5.732905
Annual average | 5.466391175000001 | 5.039293775000001 | 5.163400116666667 | 5.431810016666667
(a) Monthly figures are seasonally adjusted.
(b) Number unemployed as a proportion of the labour force. |  |  |  |  |  |  |  | Update
Source: ABS, Labour force, Cat. no. 6202.0 |  |  |  |  |  |  |  | 2014-06-12 00:00:00
Spreadsheet: 819667d1677624273-countif-mm-yy-with-conditions-workload-wip-test-02282023
Sheet: Application Tracker

 |  |  | Application Status |  |  |  | Current Step |  |  |  |  |  |  | Target Move Date |  |  |  | Program Manager
 |  |  | Green |  |  |  | Phase 2 |  |  |  |  |  |  | 2023-03-31 00:00:00 |  |  |  | Test, Test1
 |  |  | Yellow |  |  |  | Build / Execute |  |  |  |  |  |  | 2023-11-30 00:00:00 |  |  |  | Test, Test1
 |  |  | Yellow |  |  |  | Build / Execute |  |  |  |  |  |  | 2023-11-30 00:00:00 |  |  |  | Test, Test1
 |  |  | Green |  |  |  | Build / Execute |  |  |  |  |  |  | 2023-05-05 00:00:00 |  |  |  | Test, Test1
 |  |  | Green |  |  |  | Build / Execute |  |  |  |  |  |  | 2023-06-30 00:00:00 |  |  |  | Test, Test1
 |  |  | Green |  |  |  | Build / Execute |  |  |  |  |  |  | 2023-04-13 00:00:00 |  |  |  | Test, Test1
 |  |  | Green |  |  |  | Build / Execute |  |  |  |  |  |  | 2023-04-10 00:00:00 |  |  |  | Test, Test1
 |  |  | Green |  |  |  | Phase 2 |  |  |  |  |  |  | 2023-04-11 00:00:00 |  |  |  | Test, Test1
 |  |  | Green |  |  |  | Phase 2 |  |  |  |  |  |  | 2023-09-23 00:00:00 |  |  |  | Test, Test1
 |  |  | Green |  |  |  | Phase 2 |  |  |  |  |  |  | 2023-10-30 00:00:00 |  |  |  | Test, Test1
 |  |  | Green |  |  |  | Phase 2 |  |  |  |  |  |  | 2023-09-30 00:00:00 |  |  |  | Test, Test1
 |  |  | Green |  |  |  | Build / Execute |  |  |  |  |  |  | 2023-03-31 00:00:00 |  |  |  | Test, Test1
 |  |  | Green |  |  |  | Build / Execute |  |  |  |  |  |  | 2023-05-19 00:00:00 |  |  |  | Test, Test1
 |  |  | Green |  |  |  | Build / Execute |  |  |  |  |  |  | 2023-03-10 00:00:00 |  |  |  | Test, Test1
 |  |  | Green |  |  |  | Build / Execute |  |  |  |  |  |  | 2023-03-10 00:00:00 |  |  |  | Test, Test1
 |  |  | Green |  |  |  | Build / Execute |  |  |  |  |  |  | 2024-03-30 00:00:00 |  |  |  | Test, Test1
 |  |  | Green |  |  |  | Build / Execute |  |  |  |  |  |  | 2023-03-31 00:00:00 |  |  |  | Test, Test1
 |  |  | Green |  |  |  | Build / Execute |  |  |  |  |  |  | 2023-06-12 00:00:00 |  |  |  | Test, Test1
 |  |  | Green |  |  |  | Phase 2 |  |  |  |  |  |  |  |  |  |  | Test, Test1
 |  |  | Green |  |  |  | Build / Execute |  |  |  |  |  |  | 2023-11-30 00:00:00 |  |  |  | Test, Test1
 |  |  | Green |  |  |  | Build / Execute |  |  |  |  |  |  | 2023-10-04 00:00:00 |  |  |  | Test, Test1
 |  |  | Green |  |  |  | Phase 2 |  |  |  |  |  |  | 2023-04-19 00:00:00 |  |  |  | Test, Test1
 |  |  | Green |  |  |  | Build / Execute |  |  |  |  |  |  | 2023-03-31 00:00:00 |  |  |  | Test, Test1
 |  |  | Green |  |  |  | Build / Execute |  |  |  |  |  |  | 2023-12-22 00:00:00 |  |  |  | Test, Test1
Spreadsheet: 468b3414-0349-410c-b5b9-46d7649ecd44
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
8MOP | Test | 8MOP | 8-Methoxypsoralen (8-MOP), Serum | 8-Methoxypsoralen (8-MOP), S | High-Performance Liquid Chromatography (HPLC) | Plain, Red-Top Tube: Red |  |  | 3 | mL | Collection Container/Tube: Red top Submission Container/Tube: Amber vial (Supply T192) [NAME]: 3 mL Collection Instructions:  1. Draw blood 2 to 3 hours after patient has ingested 8-MOP.  2. Spin down within 2 hours of draw. 3. Send specimen in amber vial to protect from light. | 1.1 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Serum gel tube | 50-125 ng/mL | Tuesday; 11:00 a.m. | 2 days | 9 days | 1 | 80299 |  |  |  |  | Rochester
8MOP | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
8MOP | Result | 80296 | 8-Methoxypsoralen (8-MOP), S | 8-Methoxypsoralen (8-MOP), S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 13625-9 | Methoxsalen:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 879039d1726479882-help-with-formula-for-numerical-cataloging-sort-smallest-to-largest-not-working-number-format
Sheet: Sheet1

 | 176
 | 182
 | 192
 | 206
 | 207
 | 216
 | 222
 | 222
 | 225
 | 226
 | 229
 | 231
 | 234
 | 235
 | 238
 | 239
 | 241
 | 241
 | 244
 | 245
 | 246
 | 249
 | 1517
 | 1751
 | 1918
 | 1999
 | 2068
 | 2069
 | 2097
 | 2101
 | 2116
 | 2117
 | 2119
 | 2125
 | 2129
 | 2141
 | 2163
 | 2177
 | 2178
 | 2187
 | 2199
 | 2201
 | 2202
 | 2205
 | 2211
 | 2211
 | 2212
 | 2216
 | 2217
 | 2218
 | 2221
 | 2222
 | 2225
 | 2228
 | 2238
 | 2243
 | 2252
 | 2253
 | 2258
 | 2264
 | 2265
 | 2266
 | 2267
 | 2268
 | 2273
 | 2293
 | 2305
 | 2309
 | 2312
 | 2316
 | 2317
 | 2318
 | 2319
 | 2322
 | 2324
 | 2326
 | 2328
 | 2335
 | 2336
 | 2338
 | 2341
 | 2346
 | 2348
 | 2349
 | 2351
 | 2355
 | 2357
 | 2358
 | 2359
 | 2366
 | 2367
 | 2372
 | 2374
 | 2378
 | 2379
 | 2382
 | 2385
 | 2388
 | 2391
 | 2392
 | 2394
 | 2397
 | 2399
 | 2401
 | 2403
 | 2406
 | 2407
 | 2408
 | 2411
 | 2411
 | 2412
 | 2412
 | 2413
 | 2415
 | 2418
 | 2419
 | 2423
 | 2424
 | 2426
 | 2429
 | 2432
 | 2433
 | 2434
 | 2435
 | 2436
 | 2437
 | 2438
 | 2439
 | 2441
 | 2442
 | 2443
 | 2444
 | 2445
 | 2446
 | 2448
 | 2449
 | 2451
 | 2453
 | 2454
 | 2456
 | 2458
 | 2459
 | 2462
 | 2463
 | 2464
 | 2465
 | 2466
 | 2468
 | 2469
 | 2471
 | 2472
 | 2473
 | 2475
 | 2476
 | 2477
 | 2478
 | 2479
 | 2480
 | 2481
 | 2482
 | 2484
 | 2485
 | 2486
 | 2487
 | 2488
 | 2489
 | 2491
 | 2492
 | 2493
 | 2494
 | 2495
 | 2496
 | 2497
 | 2498
 | 2499
 | 15126
 | 19106
 | 19187
 | 19199
 | 19201
 | 20123
 | 20128
 | 20172
 | 20225
 | 20237
 | 21105
 | 21109
 | 21111
 | 21114
 | 21119
 | 21133
 | 21134
 | 21157
 | 21163
 | 21164
 | 21174
 | 21184
 | 21203
 | 21207
 | 21223
 | 21242
 | 21248
 | 21252
 | 22103
 | 22104
 | 22113
 | 22114
 | 22115
 | 22118
 | 22126
 | 22131
 | 22132
 | 22133
 | 22144
 | 22145
 | 22148
 | 22152
 | 22158
 | 22159
 | 22163
 | 22167
 | 22171
 | 22172
 | 22177
 | 22183
 | 22191
 | 22196
 | 22197
 | 22201
 | 22205
 | 22209
 | 22211
 | 22212
 | 23103
 | 23104
 | 23109
 | 23113
 | 23117
 | 23119
 | 23126
 | 23127
 | 23134
 | 23136
 | 23139
 | 23143
 | 23144
 | 23145
 | 23146
 | 23147
 | 23148
 | 23151
 | 23153
 | 23154
 | 23155
 | 23156
 | 23157
 | 23158
 | 23159
 | 23161
 | 23162
 | 23163
 | 23164
 | 23165
 | 23168
 | 23171
 | 23172
 | 23173
 | 23175
 | 23176
 | 23177
 | 23182
 | 23183
 | 23185
 | 24101
 | 24102
 | 24103
 | 24104
 | 24105
 | 24106
 | 24107
 | 24108
 | 24109
 | 24111
 | 24112
 | 24113
 | 24114
 | 24115
 | 24116
 | 24117
 | 24118
 | 24119
 | 24121
 | 24122
 | 24123
 | 24124
 | 24125
Spreadsheet: 880990d1728896130-need-help-to-make-fifo-calculation-more-efficient-fifo-calculation
Sheet: Sheet1

 | PURCHASE ORDERS |  |  |  |  |  |  |  |  |  |  |  |  |  | Purchase order number
 | EAN | Stock purchased | Purchase order number | Cost of goods |  |  |  |  |  | Date | EAN | # sold | [NAME] |  | 1 | 2
 | 999 | 20 | 1 | 4 |  |  |  |  |  | 2024-10-01 00:00:00 | 999 | 10
 | 990 | 20 | 1 | 4 |  |  |  |  |  | 2024-10-02 00:00:00 | 999 | 4
 | 998 | 20 | 1 | 30 |  |  |  |  |  | 2024-10-03 00:00:00 | 990 | 25
 | 999 | 30 | 2 | 6 |  |  |  |  |  | 2024-10-04 00:00:00 | 998 | 25
 | 990 | 30 | 2 | 6 |  |  |  |  |  | 2024-10-05 00:00:00 | 998 | 6
 | 998 | 30 | 2 | 35 |  |  |  |  |  | 2024-10-06 00:00:00 | 990 | 3
 |  |  |  |  |  |  |  |  |  | 2024-10-07 00:00:00 | 999 | 5
 |  |  |  |  |  |  |  |  |  | 2024-10-08 00:00:00 | 998 | 2
 |  |  |  |  |  |  |  |  |  | 2024-10-09 00:00:00 | 998 | 10
 |  |  |  |  |  |  |  |  |  | 2024-10-10 00:00:00 | 990 | 3
 |  |  |  |  |  |  |  |  |  | 2024-10-11 00:00:00 | 999 | 7
Spreadsheet: daren_farmer__5407__hpl0809
Sheet: Sheet1

HPLN0809XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  AMI_CHOSKI / ENRON
FROM:  [NAME]  (TU ELECTRIC)
 |  |  |  |  |  | ** Wednesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-08-09 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL
 |  |  |  |  | 0 to 40  0900hrs | 0 to 40  0900hrs
 |  |  |  |  | 40  to 0 2100hrs | 40  to 0 2100hrs
 |  | Firm Summary
Enron (S) |  | LS HPL [NAME] |  | ENA | 0 | 14
Enron (S) |  | Reklaw |  | ENA | 20 | 20
Enron (S) |  | Oasis Turbine |  | ENA | 2.4 | 0
Enron (S) |  | Oasis Sealy |  | ENA | 30 | 65
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
Empire (Enron) |  | [NAME]. |  | Empire | 8 | 8
Empire (Enron) |  | Oasis Turbine |  | Empire | 10 | 10
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 809817d1671337650-cant-extract-date-from-a-string-copy-of-sample-data
Sheet: Sheet1

ORDER NUMBER | SKU | order_date
[PHONE]-5211537/SKU | 2X-3C0F-KNJE | Sun, 18 Jul, 2021, 10:38 pm IST
[PHONE]-7850720/SKU | DN-0WDX-VYOT | Tue, 19 Oct, 2021, 6:05 pm IST
[PHONE]-4289117/SKU | DN-0WDX-VYOT | Sun, 28 Nov, 2021, 10:20 pm IST
[PHONE]-9557154/SKU | AH-J3AO-R7DN | Wed, 28 Jul, 2021, 4:06 am IST
[PHONE]-1215552/SKU | KL-7WAA-Z82I | Tue, 28 Sept, 2021, 2:50 pm IST
[PHONE]-6725123/SKU | HH-FOWV-5YWO | Thu, 17 Jun, 2021, 9:12 pm IST
Spreadsheet: 03321f37-dd07-4938-ae2c-bd07928a9978
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | FORM BA9 | Unnamed: 9 | Unnamed: 10
 |  |  |  |  |  |  |  | Rev 10/26/00
 |  | Instructions:
 |  | - Complete Sections A, B, & D only if requesting a non-endowed gift account.
 |  | - Complete Sections A, C, & D only if requesting a new endowment
 |  | account and its corresponding expenditure account.
 |  | - Please attach any documentation (I.e. pledge, card, letter,  endowment
 |  | agreement, etc.) that identifies the intent of the donors gifts being used
 |  | to establish this account.
A | REQUEST FOR A NEW GIFT ACCOUNT
 | Business Unit # ____________ |  |  | Business Unit Name ____________________________
 | Account Title  _______________________________________________________________
 | Short Account Title  __________________________________________________________
 | Responsible Person ___________________ |  |  |  | [NAME] ______________________________
 |  |  |  |  | Phone ______________________________
 |  |  |  |  | [NAME] _______________________________
B | NEW GIFT ACCOUNT
 | Restricted
 | The purpose of this account is to receive and expend gifts being contributed to the College for the
 | following restricted purpose(s): _____________________________________________________
 | ______________________________________________________________________________
 | Unrestricted (Discretionary)
 | Bus Unit | Fund | Department | Program | Class | Project/ Grant |  | Distribution %
 |  | 11 |  |  |  | GFT
C | NEW ENDOWMENT AND EXPENDITURE ACCOUNTS |  |  |  | Please Note:  Requests for endowment accounts
 |  |  |  |  | must be accompanied by an endowment agreement
 |  |  |  |  | or draft (signed agreement must be sent when completed);
 |  |  |  |  | donor documentation; copy of check/security (if available)
 | ENDOWMENT ACCOUNT
 | Purpose _______________________________________________________________________
 | ______________________________________________________________________________
 | ENDOWMENT TYPE |  | Circle One: |  | True |  | Term |  | Quasi
 | Bus Unit | Fund | Department | Program | Class | Project/ Grant |  | Distribution %
 |  | 31 |  |  |  | END
* |  | 11 |  |  |  | GFT
 | * | The purpose of this restricted gift fund is to expend income from the endowment account for
 |  | the same purposes as stated above per the terms of the written endowment agreement.
D | Amount on deposit being used to establish this account: $______________________________
Amount shown has been deposited in Gift Clearing Account: # 16020
Date __________________ |  |  | President's/Director's Signature _____________________________________
SUBMIT WITH ALL REQUIRED DOCUMENTATION TO:
 |  |  |  |  | KCTCS Office of Institutional Advancement
 |  |  |  |  | PO Box 14092
 |  |  |  |  | Lexington, KY  40512
Spreadsheet: kate_symes__19023__Palo
Sheet: DJ Palo Verde Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-04-04 00:00:00 |  | 235.76 | 37168 | 96.07 | 12040
 | 2001-04-03 00:00:00 |  | 232.48 | 34768 | 101.7 | 8424 | 124.35 | 2275 | 80.72 | 166
 | 2001-04-02 00:00:00 |  | 234.1 | 20032 | 134.92 | 8456 | 151.72 | 5836 | 152.21 | 1055
 | 2001-04-01 00:00:00 |  | 150 | 800 | 130 | 0 | 169.97 | 4993 | 179.55 | 3133 |  | 136.89 | 20112
 | 2001-03-31 00:00:00 |  | 155.24 | 26800 | 79.32 | 5000 | 203.27 | 4434 | 161.69 | 2164
 | 2001-03-30 00:00:00 |  | 155.24 | 26800 | 78.68 | 5600 | 166.55 | 6883 | 125.76 | 3604
 | 2001-03-29 00:00:00 |  | 149.29 | 27472 | 74.97 | 7680 | 151.01 | 3119 | 106.73 | 2737
 | 2001-03-28 00:00:00 |  | 117.91 | 28384 | 64.05 | 8795 | 135.59 | 5365 | 79.21 | 2138
 | 2001-03-27 00:00:00 |  | 107.14 | 26352 | 54.09 | 6800 | 138.05 | 5768 | 73.14 | 3889
 | 2001-03-26 00:00:00 |  | 280.53 | 20768 | 160.99 | 5520 | 115.17 | 3547 | 66.57 | 2059
 | 2001-03-25 00:00:00 |  | 200 | 0 | 135 | 200 | 80.99 | 1643 | 75.59 | 545 |  | 162.46 | 16560
 | 2001-03-24 00:00:00 |  | 233.04 | 14608 | 130.51 | 4880 | 130 | 6097 | 179.92 | 3350
 | 2001-03-23 00:00:00 |  | 233.24 | 14448 | 130.51 | 4880 | 324.97 | 6129 | 242.2 | 3200
 | 2001-03-22 00:00:00 |  | 281.29 | 18448 | 160.38 | 5360 | 385.71 | 8040 | 282.16 | 2915
 | 2001-03-21 00:00:00 |  | 460.02 | 24848 | 198.73 | 8120 | 350.98 | 4786 | 253.67 | 1853
 | 2001-03-20 00:00:00 |  | 377.03 | 18384 | 176.12 | 5120 | 390.83 | 2452 | 357.57 | 1668
 | 2001-03-19 00:00:00 |  | 297.33 | 24848 | 176.6 | 9000 | 258.33 | 3388 | 199.67 | 2448
 | 2001-03-18 00:00:00 |  | 220 | 0 | 185 | 0 | 170.47 | 4949 | 156.95 | 2582 |  | 178.66 | 28200
 | 2001-03-17 00:00:00 |  | 195.41 | 17152 | 121.88 | 8832 | 191.77 | 10872 | 180.55 | 1883
 | 2001-03-16 00:00:00 |  | 195.98 | 16352 | 121.88 | 8832 | 219.02 | 5921 | 173.76 | 3142
 | 2001-03-15 00:00:00 |  | 180.19 | 17472 | 98.04 | 5160 | 188.69 | 6005 | 136.45 | 3320
 | 2001-03-14 00:00:00 |  | 162.56 | 17184 | 81.84 | 6960 | 194.59 | 4065 | 117.41 | 1400
 | 2001-03-13 00:00:00 |  | 157.46 | 17840 | 69.39 | 7288 | 171.29 | 4137 | 134.75 | 1330
 | 2001-03-12 00:00:00 |  | 166.55 | 12544 | 91.58 | 6920 | 186.95 | 2928 | 114.77 | 1215
 | 2001-03-11 00:00:00 |  | 163 | 3200 | 90 | 1600 | 104.25 | 1435 | 110.05 | 945 |  | 93.34 | 17760
 | 2001-03-10 00:00:00 |  | 148.73 | 18400 | 66.56 | 5864 | 109.79 | 3007 | 124.99 | 2735
 | 2001-03-09 00:00:00 |  | 148.73 | 18400 | 66.56 | 5864 | 175.73 | 6415 | 122.41 | 1756
 | 2001-03-08 00:00:00 |  | 185.11 | 22848 | 92.66 | 8640 | 191.53 | 4219 | 145.14 | 1004
 | 2001-03-07 00:00:00 |  | 300.27 | 25616 | 169.6 | 6824 | 225.26 | 4337 | 151.01 | 1201
 | 2001-03-06 00:00:00 |  | 309.17 | 20320 | 175.44 | 6728 | 215.32 | 7762 | 192.69 | 3047
 | 2001-03-05 00:00:00 |  | 276.65 | 9792 | 162.76 | 4656 | 215.88 | 4042 | 160.99 | 832
Spreadsheet: 725280d1616603691-excel-newbie-nested-if-functions-in-a-gantt-chart-stack-model-gantt-chart-help
Sheet: Example

 |  |  |  | 2020-01-06 00:00:00
 |  |  |  | 1
 |  |  |  | 2020-01-01 00:00:00 |  |  |  | 2020-02-01 00:00:00 |  |  |  | 2020-03-01 00:00:00 |  |  |  |  | 2020-04-01 00:00:00
Target at Budget | Current Target | Longstop to hit plan
2020-01-10 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00
2020-02-20 00:00:00 | 2020-02-20 00:00:00 | 2020-04-01 00:00:00
2020-05-01 00:00:00 | 2020-02-01 00:00:00 | 2020-05-01 00:00:00
Target at Budget | Current Target | Longstop to hit plan
2020-01-10 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00
 | 2020-02-20 00:00:00 | 2020-04-01 00:00:00
 |  |  |  |  |  | Hi Everyone,
 |  |  |  |  |  | I am trying to create [NAME] to track projects.
 |  |  |  |  |  | I have made my first attempt using the following methodology:
 |  |  |  |  |  | Step 1: Use Excel Formula to generate a value within the cell based on if the dates match those in Columns A-C "Budget/Target,Longstop" (See Row 6)
 |  |  |  |  |  | Step 2: Use Conditional Formatting to allocate a colour to the cell (See Row 6)
 |  |  |  |  |  | I would appreciate assistance with the following issues:
 |  |  |  |  |  | Issue 1: When the Target/Budget/Longstop dates are the same, I would like the cell to return a value showing "budget + target" if the budget and target dates were the same, "budget + longstop" if the budget and longstop dates were the same, and so on (See Row 7 and 8)
 |  |  |  |  |  | Issue 2: When there is no date in one of the columns A-C or there is a #N/A, I would like the formula to still work to pull in the data from the other columns (See Rows 12-14). In Row 13 I have attempted to create a formula but it hasn't worked and I am totally lost.
 |  |  |  |  |  | Please could someone help me create the appropriate formulas?
 |  |  |  |  |  | Thank you in advance.