tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 824479d1680615544-selecting-specific-time-values-time-after-frietvet-
Sheet: Sheet1

 |  |  |  |  |  |  |  | Start | 23:00:00
 |  |  |  |  |  |  |  | End | 02:00:00
 |  | Date | C/I | C/O | Actual | Scheduled | Night
 |  | 1 | 10:00:00 | 19:00:00
 |  | 2 | 01:45:00 | 08:00:00 |  |  | 00:15:00
 |  | 3 | 01:00:00 | 06:00:00 |  |  | 01:00:00
 |  | 4 | 00:05:00 | 08:00:00 |  |  | 01:55:00
 |  | 5
 |  | 6
 |  | 7 | 16:00:00 | 00:33:00 |  |  | 01:33:00
 |  | 8
 |  | 9
 |  | 10
 |  | 11
 |  | 12
 |  | 13
 |  | 14
 |  | 15
 |  | 16
 |  | 17
 |  | 18
 |  | 19
 |  | 20
 |  | 21
 |  | 22
 |  | 23
 |  | 24
 |  | 25
 |  | 26
 |  | 27
 |  | 28
 |  | 29
 |  | 30
 |  | 31
 |  | Total
Spreadsheet: 69824d1270497574-sum-isanumber-rbpd5015
Sheet: WEEK 1A

MUV | BET TEAM | VS TEAM | GAME 1 | [NAME] | G1 $ Win | [NAME] | G1 $ Risk | G1   Result | GAME 2 | [NAME] | G2 $ Win | [NAME] | G2 $ Risk | G2 Result | GAME 3 | [NAME] | G2 $ Win | [NAME] | G2 $ Risk | G3 Result | TOT Units
0 | BOS | NYY | -150 | 1 | 1 | 1.5 | 1.5 | W | -150 | 3.5 | 3.5 | 5.25 | 5.25 |  |  |  |  |  |  |  | 6.75
0 | NYY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | OAK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | PHI |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | PIT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | SD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | STL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | WAS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 7 |  |  |  |  |  | 1 |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: dana_davis__4508__1 Central Records Form
Sheet: ZOO74033

ENA |  |  |  |  |  |  |  | Page | of
 |  |  | RECORDS TRANSFER LIST |  |  |  |  | 1 | 1
[NAME] Number |  |  | R.C. Number |  | Company Number | Destination Date |  | Transfer Number
 | 408 |  | 0771 |  | 413
Company |  |  |  |  | Department |  |  | Section
ENRON CORP |  |  |  |  | Merchant Finance
Retention |  | [NAME] by Filing Arrangement and |  |  |  | [NAME] |  |  | Record
Schedule |  | Record Series Range, eg. 1-5, A-H, etc. |  |  |  |  |  | Container | Center Only
Item Number |  | (Title Same as Used in [NAME]) |  |  |  | From | To | Number | Location #
20403 |  | Cactus Reports |  |  |  |  |  | Z0074033
 |  | Wires |  |  |  | 01/01/96 | 12/31/96
 |  | General Ledgers |  |  |  | 01/01/96 | 12/31/96
 |  | Financial Statements |  |  |  | 01/01/96 | 12/31/96
 |  | Cactus III/Class a Series 801 and 804-1
 |  | [NAME] ([NAME]) |  |  |  | 05/01/95 | 05/31/95
 |  | ERAC/Cactus - VPP Modele |  |  |  | 06/01/95 | 06/30/95
 |  | Cactus III (Audubon) Amendments |  |  |  | 08/01/96 | 08/31/96
 |  | Cactus III LP (Series 12) |  |  |  | 12/01/93 | 12/31/93
Prepared By |  |  |  | Date | Building/Room/City
[NAME] |  |  |  |  | ENRON CORP./EB 2448a/HOUSTON
Department Head |  |  |  | Date | Computer Input By |  |  |  | Date
Hope Vargas
Checked and Received by |  |  |  | Date | Verified by |  |  |  | Date
Spreadsheet: eric_saibi__9729__011002
Sheet: Conemaugh 02

Owner Name |  | PSEG Power LLC
Station Name |  | Conemaugh Power Station
Unit Name |  | Conemaugh 02
NERC Region |  | MAAC
State |  | VA
Fuel Type |  | Nuclear
Capacity |  | 980 MW
Start Date |  | 2002-01-08 00:00:00
End Date |  | 1/10/02 am
Comments |  | Unit went down with a tube leak Tuesday night. However they got the unit back online about 7:30 this morning.
SIC |  | 4931
Plant ID |  | 1017267
Unit ID |  | 1004347
Outage ID |  | 19440
Spreadsheet: 127046d1320147724-excel-2007-how-to-populate-a-cell-via-various-selections-from-two-other-cells-transport-control-sheet-test-working-1
Sheet: Transport Bookings October 2011

Date | Driver | [NAME] | CUSTOMER | Eq | Job No: | Customer Reference | Trip Type | TRIP | Rate | [NAME] | Fuel | Adjustment | Sub Total | GST | Total | Paperwork complete
2011-10-24 00:00:00 | GLENN | VV80IH | Region |  |  |  |  | Melbourne to Adelaide
2011-10-24 00:00:00 | ANDY | YGH408 | [NAME] | BD | 24O112 |  | DIRECT | Melbourne to Sydney
2011-10-24 00:00:00 | CLARKE | VV08IR | [NAME] | BD | 24O113 |  | DIRECT | Melbourne to Sydney
2011-10-24 00:00:00 | ALAISTAIR | VV95IT | [NAME] | BD | 24O114 |  | DIRECT | Melbourne to Sydney
2011-10-24 00:00:00 |  |  | [NAME] | BD | 24O115 |  | DIRECT | Melbourne to Sydney
 |  |  | [NAME] |  |  |  |  | Melbourne to Sydney
Spreadsheet: 465423d1465640974-calculate-unique-names-and-repeted-names-test
Sheet: FERMA 1

SIRE NAME | NR SIRES
ALTAAVALON
ALTAAVALON
ALTAAVALON
ALTAAVALON
ALTAAVALON
ALTAAVALON
ALTAAVALON
ALTAAVALON
ALTAAVALON
ALTAANTRIM
ALTAANTRIM
ALTAANTRIM
ALTAANTRIM
ALTAANTRIM
ALTAANTRIM
ALTAANTRIM
ALTAANTRIM
ALTAARMANI
ALTAARMANI
ALTAARMANI
ALTAARMANI
ALTAARMANI
ALTAARMANI
ALTAARMANI
ALTAARMSTEAD
ALTAARMSTEAD
ALTAARMSTEAD
ALTAARMSTEAD
ALTAARMSTEAD
ALTAARMSTEAD
ALTAARMSTEAD
TUNIS
TUNIS
TUNIS
TUNIS
TUNIS
TUNIS
TUNIS
TWISTER
TWISTER
TWISTER
TWISTER
TWISTER
TWISTER
ALTAAGENCY
ALTAAGENCY
ALTAAGENCY
ALTAAGENCY
YANKEE
YANKEE
YANKEE
URSUS
URSUS
[NAME]
[NAME]
ULTRAFOX
VACHIM
VAN DE VEN
WATSON
WIN 395
WINCEL
Spreadsheet: 868657d1715335182-lookup-function-book2
Sheet: Plan

 |  |  | To serach | Fiscalité I
 |  |  | Result
 |  | 2024-01-04 00:00:00 |  |  | 2024-01-05 00:00:00
 |  | 08h00-09h30 |  |  | 08h00-09h30
 |  | Names | Pro | Course | Names | Pro | Course
 | Room 1
 | Room 2 |  |  |  |  |  | Fiscalité I
 | Room 3
 | Room4
 | Room 5
Spreadsheet: 703173d1604812055-subtraction-calculation-w-requirement-data-is-present-samplef
Sheet: Sheet1

FIELD1 | FIELD2 | [NAME] | CALC1 | CALC2
0 | 145574 | N | -
0 | 99603 | 99603 | 0 |  |  | If A is not present, but B AND C are, subtract B-C
0 | 70389 | 70384 | 5 |  |  | If A is not present, but B AND C are, subtract B-C
0 | 86040 | 86037 | 3 |  |  | If A is not present, but B AND C are, subtract B-C
107506615 | 2659189 | N | -
0 | 29228 | N | -
0 | 856143 | N | -
75667411 | 4134667 | N | -
0 | 952934042 | N | -
0 | 33583872 | N | -
0 | 88616 | N | -
0 | 4902 | N | -
12571494 | 245879 | 245851 | 12325643 |  |  | When A and C are both present, subtract A-C
13513917 | 14945027 | N | -
0 | 249665 | N | -
72107146 | 158725 | N | -
0 | 43497 | N | -
0 | 0 | N | -
0 | 226446114 | N | -
0 | 23517 | N | -
30214377 | 281517 | N | -
0 | 2770338 | N | -
0 | 0 | N | -
0 | 57587082 | N | -
0 | 0 | N | -
0 | 312707081 | N | -
0 | 92324032 | N | -
17553404 | 57842 | N | -
0 | 27424227 | N | -
0 | 64269814 | N | -
120419139 | 2205220 | 2205175 | 118213964 |  |  | When A and C are both present, subtract A-C
0 | 114288379 | N | -
Spreadsheet: john_griffith__16153__1_25_02GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HU G2 | 56 | 150 | 250 | 37 | 61.7 | 1.74 | 2002-01-25 11:52:00
 | [NAME] | 57 | 600 | 700 | 45.4 | 53 | 1.76 | 2002-01-25 11:52:00
 | [NAME] | 64 | 940 | 1040 | 46.1 | 51 | 1.95 | 2002-01-25 11:52:00
 | [NAME] | 65 | 1130 | 1230 | 44.4 | 48.3 | 1.89 | 2002-01-25 11:52:00
 | [NAME] | 65 | 1290 | 1390 | 43.5 | 46.9 | 1.85 | 2002-01-25 11:52:00
 | HU N2 | 64 | 1330 | 1430 | 41.3 | 44.4 | 1.72 | 2002-01-25 11:52:00
 | [NAME] | 64 | 1400 | 1500 | 39.8 | 42.7 | 1.66 | 2002-01-25 11:52:00
 | HU U2 | 63 | 1400 | 1500 | 37.4 | 40.1 | 1.53 | 2002-01-25 11:52:00
 | [NAME] | 59 | 1375 | 1525 | 36.9 | 41 | 1.44 | 2002-01-25 11:52:00
 | [NAME] |  |  |  | 35.9 | 39.8 | 1.36 | 2002-01-22 15:03:00
 | [NAME] |  |  |  | 35.4 | 40.3 | 1.4 | 2001-11-29 15:00:00
 | HU F3 |  |  |  |  |  | 1.26 | 2001-08-20 15:44:00
 | [NAME]
 | HU H3
 | [NAME] |  |  |  |  |  | 0.56 | 2001-07-19 17:15:00
 | [NAME]
Spreadsheet: 139973d1328564803-ranking-formula-used-in-conjunction-with-a-selection-box-test-example-ranks
Sheet: Analysis

 |  |  |  |  | Select org | office e
 |  |  |  |  | submit plan | Jan mon Act | Jan YTD actuals | delta plan to month act | delta plan to YTD act
 |  | Mission AA
 |  |  | Program 1
 |  |  | Program 2
 |  |  | Program 3
 |  |  | Program 4
 |  | Mission BB
 |  |  | Program 5
 |  |  | Program 6
 |  |  | Program 7
 |  |  | Program 8
 |  |  | Program 9
 |  |  | Program 10
 |  |  | Program 11
 |  |  | Program 12
 |  | Mission CC
 |  |  | Program 13
 |  |  | Program 14
 |  |  | Program 15
 |  |  | Program 16
 |  |  | Program 17
 |  |  | Program 18
 |  |  | Program 19
 |  | Mission DD
 |  |  | Program 20
 |  |  | Program 21
 |  |  | Program 22
 |  |  | Program 23
 |  | Mission EE
 |  |  | Program 24
 |  |  | Program 25
 |  |  | Program 26
 | REFERENCE |  |  |  |  |  | DELTA |  |  | YTD
 |  | Delta | YTD | DeltaKey | YTDkey |  | Mission | Ranking |  | Mission | Ranking
 | Mission AA
 | Mission BB
 | Mission CC
 | Mission DD
 | Mission EE
Spreadsheet: 124805d1318614925-time-formula-breaks-with-multiple-ins-per-day-test2
Sheet: Raw

Employee Name | Date | Status | Time
[NAME] | 2011-10-12 00:00:00 | IN | 05:01:00
[NAME] | 2011-10-12 00:00:00 | OUT | 10:58:00
[NAME] | 2011-10-12 00:00:00 | IN | 12:05:00
[NAME] | 2011-10-12 00:00:00 | OUT | 14:06:00
[NAME] | 2011-10-13 00:00:00 | IN | 06:17:00
[NAME] | 2011-10-13 00:00:00 | OUT | 11:04:00
[NAME] | 2011-10-14 00:00:00 | IN | 07:03:00
Spreadsheet: 68802d1269350157-vlookup-help-searching-for-a-code-book4-1-
Sheet: Sheet1

Code | Match |  | Code | Details | Price
M1129 | 38 |  | M1111 | irrelevant | 20
 |  |  | M1112 | irrelevant | 21
 |  |  | M1113 | irrelevant | 22
 |  |  | M1114 | irrelevant | 23
 |  |  | [NAME] | irrelevant | 24
 |  |  | M1116 | irrelevant | 25
 |  |  | M1117 | irrelevant | 26
 |  |  | M1118 | irrelevant | 27
 |  |  | M1119 | irrelevant | 28
 |  |  | M1120 | irrelevant | 29
 |  |  | M1121 | irrelevant | 30
 |  |  | M1122 | irrelevant | 31
 |  |  | M1123 | irrelevant | 32
 |  |  | M1124 | irrelevant | 33
 |  |  | M1125 | irrelevant | 34
 |  |  | M1126 | irrelevant | 35
 |  |  | M1127 | irrelevant | 36
 |  |  | M1234 | irrelevant | 37
 |  |  | M1129 | irrelevant | 38
 |  |  | M1130 | irrelevant | 39
 |  |  | M1131 | irrelevant | 40
 |  |  | [NAME] | irrelevant | 41
 |  |  | M1133 | irrelevant | 42
 |  |  | M1134 | irrelevant | 43
 |  |  | M1135 | irrelevant | 44
 |  |  | M1136 | irrelevant | 45
 |  |  | M1137 | irrelevant | 46
 |  |  | M1138 | irrelevant | 47
 |  |  | M1139 | irrelevant | 48
 |  |  | M1140 | irrelevant | 49
 |  |  | M1141 | irrelevant | 50
 |  |  | M1142 | irrelevant | 51
Spreadsheet: 688101d1595572191-countifs-in-combination-with-today-format-issue-issue-with-countifs-and-date
Sheet: Summary

Summary
Agent | Strikes | Strikes Today | Strikes last 7 days | Strike last 28 days |  |  | 23.07.2020
[NAME] |  |  |  |  |  |  |  |  | 08.07.2020
[NAME]
Summary
Spreadsheet: 124113d1318133563-copying-a-formula-and-skipping-rows-bdrsample
Sheet: Sheet1

First | [NAME]
Last | Doe
City | Anytown
State | Anystate
Zip | 12345
Phone | [PHONE]
First | [NAME]
Last | Doe
City | Everytown
State | Everystate
Zip | 98765
Phone | [PHONE]
First | [NAME]
Last | Smith
City | Sometown
State | Somestate
Zip | 56473
Phone | [PHONE]
Spreadsheet: 297048d1392267779-how-to-search-and-remove-a-series-of-entries-based-on-adjacent-values-search-and-remove2
Sheet: Sheet1

The data to process is in Columns A and B.
A "series" has the same *****-*** at the beginning of the number.  E.g.  15263-001    . There may be various hyphens/numbers/letters joined to the right.
I want to delete a series if the average of the numbers in the adjacent cell B is less than 20.
In below example,  All of Series 1(15623-001) and 3(61232-851) will remain, but all of Series 2(76219-002) will be deleted.
15263-001-1 | 24
15263-001-2 | 89
15263-001-3 | 3
15263-001-4 | 62
15263-001-5 | 40
76219-002-1 | 0
76219-002-2 | 0
76219-002-3 | 5
76219-002-4 | 4
76219-002-5 | 9
76219-002-6 | 22
76219-002-7 | 4
76219-002-8 | 18
76219-002-9 | 7
76219-002-10 | 0
76219-002-11 | 0
61232-851-1 | 150
61232-851-2 | 200
61232-851-3 | 34
61232-851-4 | 68
61232-851-5 | 51
61232-851-6 | 89
61232-851-7 | 2
61232-851-8 | 46
61232-851-9 | 5
61232-851-10 | 80
Spreadsheet: 273242d1382643769-vlookup-formula-problem-training-cost
Sheet: Course Booking Form

 |  | Course Title
 |  | Start Date
 |  | Duration
 |  | Training Provider
 |  | Location
 |  | Cost | 500
[NAME] | Area | Shift | To be replaced By
Employee 1
Employee 2 |  |  | Agency Despatch
Employee 3
Employee 9 |  |  | Agency Nights Hygiene
Employee 4
Spreadsheet: 696386d1600789252-dynamic-month-ytd-formula-exampledynamicdates
Sheet: Data

Month | Term | Product Tier | State | 2020 Values
Jan | New | AUTO | CA | -250
Jan | New | AUTO | CA | 0
Jan | New | AUTO | CA | 90
Jan | New | AUTO | CA | 344
Feb | New | AUTO | CA | -1380
Jan | New | AUTO | CA | 0
Mar | New | AUTO | CA | 436
Jan | New | AUTO | CA | 3294
Apr | Renewal | AUTO | CA | -135
Jan | Renewal | AUTO | CA | 0
Jan | Renewal | AUTO | CA | 52
Jan | Renewal | AUTO | CA | 314
Jan | Renewal | AUTO | CA | -1223
Spreadsheet: 81149d1281413951-return-event-based-on-date-exampledatesprt
Sheet: Sheet1

Event | Start Date | End Date | Location | One | Two | Three
Action 1 | 2010-10-01 00:00:00 | 2010-10-04 00:00:00 | North | South | East | West
Action 2 | 2010-10-02 00:00:00 | 2010-10-04 00:00:00 | North | South | East
Action 3 | 2010-10-05 00:00:00 | 2010-10-05 00:00:00 | South | West | East
Function | 2010-10-06 00:00:00 | 2010-10-20 00:00:00 | North | South
Clean-up | 2010-10-21 00:00:00 | 2010-10-22 00:00:00 | North | East
Transport | 2010-10-22 00:00:00 | 2010-10-22 00:00:00 | East | South
Transition | 2010-10-23 00:00:00 | 2010-10-24 00:00:00 | North | West
Storage | 2010-10-25 00:00:00 | 2010-11-01 00:00:00 | West | East | North
Enter Date | 2010-10-03 00:00:00
Event | Location
Action 1 | North | South | East | West
[NAME] | North | South | East
Spreadsheet: 29499d1224539651-need-if-input-and-color-identify-solution-isd-forecast-tax-time-2009-10-6-0821
Sheet: Figures

 |  | Includes Shipments 10-17
PMP |  |  | TOTAL
Part# | Customer Item # | Description | On-Hand Qty. |  | Manufactured | [NAME]
m1058-602 | 50634 | ODP Black Vol. Tote | 8000 | 8000
PMC | 50634 | ODP Black Vol. Tote | 0 | 0
m1058-601 | 50635 | ODP Navy Vol. Tote | 14103 | 14103
m1058-600 | 50636 | ODP [NAME]. Tote | 23942 | 23942
m1058-603 | 50641 | ODP Gray Vol. Tote | 0 | 0
PMC | 50641 | ODP Gray Vol. Tote | 1832 | 1832
m1058-500 | OM99658 | OM OPP Clear Base/Black lid | 5996 | 5996
m1059-011 | OM99659 | OM Portable Blue File Box | 3376 | 3376
m1059-012 | OM99660 | OM Portable Black File Box | 2468 | 2468
m1058-990 | 50644 | ODP Blue Lid Bankers Box 1 sided label | 1784 | 1784
m1058-991 | 50645 | ODP Red Lid Bankers Box 1 sided label | 2624 | 2624
m1058-706 | 50637 | Target Tote Clear BS/Blk Lid | 0 | 0
PMC | 50637 | Target Tote Clear BS/Blk Lid | 1632 | 1632
m1058-509 | 50696 | Office [NAME] tote | 0 | 0
m1059-304 | 50697 | Office [NAME] box | 3336 | 3336
m1059-303 | 50639 | OPP Black Thick Target | 13554 | 13554
m1059-301 | 50682 | Staples Portable Black | 2836 | 2836
m1059-302 | 50681 | Staples Portable Blue | 2640 | 2640
m1058-505 | 50680 | Staples OPP Tote Black | 72 | 72
m1058-506 | 50679 | Staples OPP Tote Blue | 56 | 56
 |  |  | 0 | 0
m1058-700 | 50698 | Colorful Tote Blue | 4116 | 4116
PMC | 50698 | Colorful Tote Blue | 3820 | 3820
m1058-701 | 50699 | Colorful Tote Green | 4265 | 4265
PMC | 50699 | Colorful Tote Green | 576 | 576
m1058-702 | 50700 | Colorful Tote Pink | 56 | 56
M1058-707 | 50716 | Holiday Green Tote | 1368 | 1368
M1058-708 | 50715 | Holiday Trans Red | 2496 | 2496
M1058-709 | OMO1614 | Lime Green | 0 | 0
m1058-703 | 50688 | Staples Colorful Tote Blue | 1432 | 1432
m1058-704 | 50689 | Staples Colorful Tote Teal | 984 | 984
m1058-705 | 50687 | Staples Colorful Tote Pink | 2480 | 2480
m1059-305 | 50649 | ODP Recycle Black | 3044 | 3044
m1060-012 | 50648 | ODP Slim Blue | 2610 | 2610
m1060-011 | 50647 | ODP Slim Clear | 636 | 636
m1060-013 | 50704 | ODP Slim Black | 678 | 678
PMC | 50620 | ODP Designer Thin | 1028 | 1028
PMC | 50656 | Transport LL | 736 | 736
PMC | 50657 | Transport Thick | 576 | 576
PMC | 50659 | ODP Organizer | 960 | 960
PMC | 50625 | Silver Black | 900 | 900
PMC | 50655 | Archive | 722 | 722
PMC | 50628 | Designer [NAME] | 540 | 540
PMC | 50649 | ODP Recycled FB | 560 | 560
PMC | 50675 | Organizer catalog [NAME] | 63 | 63
PMC | 50626 | Designer [NAME] | 180 | 180
PMC | 50683 | [NAME] | 2560 | 2560
PMC | 50684 | [NAME] | 560 | 560
PMC | 50685 | Organizer file box W/Dividers | 1040 | 1040
PMC | OM99661 | Office [NAME] | 0 | 0
PMC | 50672 | Catalog Item | 126 | 126
PMC | 50673 | Catalog Item | 168 | 168
PMC | 50675 | Catalog Item | 252 | 252
PMC | 50630 |  | 1000 | 1000
Spreadsheet: rick_buy__32925__Group_Netco_MarketRisk
Sheet: Canada A&A

 | Canada Analyst & Associate
 | 2002 Plan
 |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2002 |  | 2002 |  |  |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | Plan |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  | 0 | Compensation | 0
 | Special Pays |  |  |  |  | 0
 | Analysts & Associates | 0 |  | 0
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  | Total
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  | [NAME] | 33600 | 0
ENACONTR | Charitable Contributions |  |  |  |  |  | [NAME] | 52800 | 0
ENARENT | Rent |  |  |  |  |  | Staff | 54000 | 0
ENATECH | Technology |  |  |  |  |  | Specialist | 63000 | 0
ENATRANS | Transportation |  |  |  |  |  | Sr. Specialist | 78000 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  | Analyst | 66000
ENATAXES | Taxes Other than Income |  |  |  |  |  | Associate | 97200 | 2
ENATOTDR | Total Direct Expenses |  |  |  |  |  | Manager | 120000 | 0
 |  |  |  |  |  |  | Director | 156000 | 0
 | Headcount |  |  |  |  |  | Sr. Director | 180000 | 0
 |  |  |  |  |  |  | VP | 216000 | 0
 | Analyst & Associate Headcount |  |  |  |  |  | CEO | 240000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
ENAOUTLG | *  Analysts and Associates are billed through normal payroll for Canada. |  |  |  |  | Other Expense Calculation
ENAOUTTX
ENAINSUR |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
ENASYSDV
ENACORIT
ENACORRN
ENAOTHAL
ENADEPR
Spreadsheet: 61970d1262878314-how-to-show-all-entries-that-meet-a-certain-criteria-in-a-seperate-worksheet-example-of-table
Sheet: BK2

ID Number | Name | DOB | Manager | 09 Budget | 10 Budget | Ext Fund | Top Rate Y/N | A/B?C
2 | [NAME] | 1992-06-02 00:00:00 | MG | 100 | 200
3 | [NAME] | 1992-03-03 00:00:00 | MG | 1000 | 2000
6 | [NAME] | 1993-01-04 00:00:00 | PW | 100 | 200
 |  |  | This is the working table
Spreadsheet: 802343d1666795811-count-between-2-numbers-multiple-times-average-rows
Sheet: Sheet1

3 | 11 | 12
8 | 9 | 33 |  |  | How many rows between #3
1 | 6 | 23 |  |  | Then the average number of rows in the entirety (Count all colored cells and average them)
3 | 9 | 10 |  |  | Original sheet has over 4000 cells in one column and will not be color formatted
5 | 14 | 21
8 | 20 | 21 |  | Average
7 | 3 | 25
7 | 16 | 17
5 | 10 | 23
3 | 4 | 15
7 | 9 | 21
9 | 11 | 17
7 | 14 | 17
3 | 25 | 28
8 | 18 | 31
9 | 12 | 13
4 | 5 | 14
13 | 16 | 18
11 | 3 | 25
7 | 18 | 23
11 | 18 | 3
8 | 14 | 16
4 | 11 | 23
3 | 4 | 19
5 | 17 | 21
6 | 17 | 24
Spreadsheet: 841895d1694024142-find-max-sum-of-values-from-one-column-while-using-if-sum-of-other-values-x-sample-worksheet
Sheet: Sheet1

P Mahommes
[NAME]
J Hurts
[NAME]
J Fields
J Herbert
T Lawrence
J burrow
T Tagovailoa
K Cousins
D Watson
R Wilson
G Smith
S Howell
D Carr
B Purdy
M Stafford
A Richardson
G Minshew II
J Fgaroppolo
K Pickett
D Ridder
B Young
R Tannehill
M Jones
J Love
CJ Stroud
B Mayfield
T Heinicke
S Darnold
J Goff
D Prescott
Spreadsheet: chris_germany__2912__Plant Fuel 02 2000
Sheet: Jul 99

Date | lbs 1CT oil | lbs 1 DB oil | lbs 2 CT oil | lbs 2 DB oil | lbs Aux. Blr oil | daily oil mmbtu | daily oil gallons | Fuel Tank Level | Oil Deliv. Gallons | Trucks | lbs 1 CT gas | lbs 1 DB gas | lbs 2 CT gas | lbs 2 DB gas | lbs Aux. Blr gas | Daily gas mmbtu
2000-07-01 00:00:00
2000-07-02 00:00:00
2000-07-03 00:00:00
2000-07-04 00:00:00
2000-07-05 00:00:00
2000-07-06 00:00:00
2000-07-07 00:00:00
2000-07-08 00:00:00
2000-07-09 00:00:00
2000-07-10 00:00:00
2000-07-11 00:00:00
2000-07-12 00:00:00
2000-07-13 00:00:00
2000-07-14 00:00:00
2000-07-15 00:00:00
2000-07-16 00:00:00
2000-07-17 00:00:00
2000-07-18 00:00:00
2000-07-19 00:00:00
2000-07-20 00:00:00
2000-07-21 00:00:00
2000-07-22 00:00:00
2000-07-23 00:00:00
2000-07-24 00:00:00
2000-07-25 00:00:00
2000-07-26 00:00:00
2000-07-27 00:00:00
2000-07-28 00:00:00
2000-07-29 00:00:00
2000-07-30 00:00:00
2000-07-31 00:00:00
mmbtu
gallons
Spreadsheet: 752790d1634949089-multiple-entries-in-a-table-with-different-timestamps-how-to-determine-time-difference-cph020283-excelhelp
Sheet: Sheet1

 |  |  | Local Date and Time | Email Conversation ID | Elapsed Time
 |  |  | 2021-10-20 16:13:22 | 122134567890
 |  |  | 2021-10-20 16:14:13 | 132456789
 |  |  | 2021-10-20 16:15:58 | 3253124534354
 |  |  | 2021-10-20 16:18:48 | 6575675675
 |  |  | 2021-10-20 16:23:19 | 6575675675
 |  |  | 2021-10-20 16:26:15 | 476874685674
 |  |  | 2021-10-20 16:30:23 | 89078786756756
 |  |  | 2021-10-20 16:29:39 | 35434563546
 |  |  | 2021-10-20 16:33:53 | 567567567567
 |  |  | 2021-10-20 16:34:29 | 467867458657
 |  |  | 2021-10-20 16:41:27 | 3454564563567670
 |  |  | 2021-10-20 16:41:57 | 234564564536
 |  |  | 2021-10-20 16:43:43 | 132456789
 |  |  | 2021-10-20 16:46:48 | 846754756846758
 |  |  | 2021-10-20 16:49:00 | 46745674567456
 |  |  | 2021-10-20 16:51:34 | 2546546456
 |  |  | 2021-10-20 16:53:02 | 3253124534354
 |  |  | 2021-10-20 16:56:50 | 3567546785768
 |  |  | 2021-10-20 16:57:52 | 2452345235
 |  |  | 2021-10-20 16:59:30 | 6.57865786789789e+17
 |  |  | 2021-10-20 17:01:25 | 869587946573546
 |  |  | 2021-10-20 17:04:18 | 46745674567456
 |  |  | 2021-10-20 17:05:53 | 3422354254543
 |  |  | 2021-10-20 17:08:43 | 122134567890
 |  |  | 2021-10-20 17:10:18 | 4.56453635467546e+17
 |  |  | 2021-10-20 17:10:53 | 132412341
 |  |  | 2021-10-20 17:14:01 | 123412341241324
 |  |  | 2021-10-20 17:14:23 | 1234123441234120
 |  |  | 2021-10-20 17:15:14 | 47646574567456
 |  |  | 2021-10-20 17:17:20 | 7574567456745
 |  |  | 2021-10-20 17:21:13 | 3563536735674560
 |  |  | 2021-10-20 17:21:28 | 747467457
 |  |  | 2021-10-20 17:30:53 | 764674567
 |  |  | 2021-10-20 17:36:55 | 89746545635643
 |  |  | 2021-10-20 17:39:23 | 898789897987689
 |  |  | 2021-10-20 17:40:32 | 467456745
 |  |  | 2021-10-20 17:52:43 | 46745674567456
 |  |  | 2021-10-20 17:55:42 | 132456789
 |  |  | 2021-10-20 18:05:52 | 4674674
 |  |  | 2021-10-20 18:26:29 | 4567456745674560
 |  |  | 2021-10-20 18:30:56 | 7467457
 |  |  | 2021-10-20 18:43:26 | 356354634563456
 |  |  | 2021-10-20 18:46:43 | 122134567890
 |  |  | 2021-10-20 18:58:24 | 3.45643573547635e+17
 |  |  | 2021-10-20 18:59:18 | 223423452345
 |  |  | 2021-10-20 18:59:48 | 245243523452345
 |  |  | 2021-10-20 19:01:42 | 122134567890
 |  |  | 2021-10-20 19:26:11 | 7.87456356356345e+16
 |  |  | 2021-10-20 19:39:47 | 1234847634657
 |  |  | 2021-10-20 20:13:29 | 46745674
 |  |  | 2021-10-20 20:13:23 | 9.57878434653254e+17
 |  |  | 2021-10-20 20:19:09 | 4.67545674567456e+17
 |  |  | 2021-10-20 20:46:25 | 234523453245
 |  |  | 2021-10-20 20:48:52 | 46745674567456
 |  |  | 2021-10-20 21:06:08 | 2.34556746757686e+16
 |  |  | 2021-10-20 21:17:11 | 457654745
 |  |  | 2021-10-20 21:31:56 | 3456657756897
Spreadsheet: 69014d1269533490-excel-2007-automatically-search-and-count-example
Sheet: Sheet1

A010 |  | 12 | A010
A010 |  | 7 | A015
A010
A010
A010
A010
A010
A010
A010
A010
A010
A010
A015
A015
A015
A015
A015
A015
A015
A020
A020
A020
A020
A020
A020
A020
A025
A025
A025
A030
A030
A030
A030
A030
A034
A034