tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 157123d1337623893-help-with-gantt-chart-needs-to-have-days-of-the-week-as-headers-gannt-chart-conditional-formatting
Sheet: Sheet1

Month | Year
May | 2012
 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
Start | End | Days
2012-05-02 00:00:00 | 2012-05-10 00:00:00
2012-05-08 00:00:00 | 2012-05-23 00:00:00
2012-05-30 00:00:00 | 2012-06-22 00:00:00
Spreadsheet: 56571d1256744686-sum-if-and-grouping-dates-sum-if-example
Sheet: Sheet1

Dept | Date | Employee | Status | Phone Calls | Sales | $ Sales for Every 100 Outbound Calls
Finance | 2009-10-22 00:00:00 | Mark | ACTIVE | 9 | 0.09 | 10
Finance | 2009-10-22 00:00:00 | [NAME] | ACTIVE | 240 | 28.04 | 116.8333
Finance | 2009-10-22 00:00:00 | [NAME] | ACTIVE | 5 | 0.05 | 10
Accounting | 2009-10-22 00:00:00 | Julie | ACTIVE | 653 | 6.659 | 10.1975
Finance | 2009-10-23 00:00:00 | [NAME] | ACTIVE | 70 | 0.846 | 12.0857
Finance | 2009-10-23 00:00:00 | Mark | ACTIVE | 56 | 0.651 | 11.625
Finance | 2009-10-23 00:00:00 | [NAME] | ACTIVE | 247 | 3.518 | 14.2429
Finance | 2009-10-23 00:00:00 | [NAME] | ACTIVE | 877 | 10.055 | 11.4652
Finance | 2009-10-23 00:00:00 | [NAME] | ACTIVE | 540 | 9.508 | 17.6074
Accounting | 2009-10-23 00:00:00 | Becky | ACTIVE | 99 | 2.21 | 22.3232
Accounting | 2009-10-23 00:00:00 | Julie | ACTIVE | 914 | 10.094 | 11.0438
Finance | 2009-10-24 00:00:00 | [NAME] | ACTIVE | 78 | 0.93 | 11.9231
Finance | 2009-10-24 00:00:00 | Mark | ACTIVE | 508 | 10.009 | 19.7028
Finance | 2009-10-24 00:00:00 | [NAME] | ACTIVE | 284 | 3.989 | 14.0458
Finance | 2009-10-24 00:00:00 | [NAME] | ACTIVE | 640 | 7.718 | 12.0594
Finance | 2009-10-24 00:00:00 | [NAME] | ACTIVE | 486 | 9.197 | 18.9239
Accounting | 2009-10-24 00:00:00 | Becky | ACTIVE | 146 | 5.666 | 38.8082
Accounting | 2009-10-24 00:00:00 | Julie | ACTIVE | 818 | 10.028 | 12.2592
Finance | 2009-10-25 00:00:00 | [NAME] | ACTIVE | 127 | 1.52 | 11.9685
Desired Result
 |  |  |  | Total Phone Calls | Total Sales
Finance | 2009-10-22 00:00:00 |  |  | 254 | 28.18
Accounting | 2009-10-22 00:00:00 |  |  | 653 | 6.66
Finance | 2009-10-23 00:00:00 |  |  | 1790 | 24.58
Accounting | 2009-10-23 00:00:00 |  |  | 1013 | 12.3
Spreadsheet: michelle_lokay__26703__imball0112
Sheet: burlington

56423
Day | Measured | Scheduled | Imbal
1 | 150014 | 149436
2 | 160216 | 158454
3 | 159349 | 165965
4 | 155848 | 155735
5 | 166911 | 168136
6 | 181580 | 183336
7 | 184934 | 184986
8 | 195682 | 194987
9 | 197184 | 204987
10 | 172328 | 172131
11 | 168128 | 169997
12 | 179190 | 178987
13 | 195118 | 194973
14 | 157810 | 157053
15 | 172272 | 173740
16 | 174151 | 174108
17 | 175008 | 175353
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 |  |  |  |  |  |  | 20
2001-11-30 00:00:00 |  |  | -23010 |  |  |  | 530
2001-12-17 00:00:00
 |  |  |  |  |  |  | 5989
CBS Volume
 |  |  | -10969
Spreadsheet: 854399d1704293404-create-text-string-from-a-list-of-selections-naming-generator-permit-register-test-sheet-wip
Sheet: Sheet1

Permit | Site | Permit number | Comments |  | Permit types |  | Sites
Break ground | [NAME] | HX2101_BG_SN_0001 |  |  | break ground | BG | [NAME] | SN
 |  |  |  |  | Hot works | HW | Swanwick | SW
 |  |  |  |  | Confined space | CS | Ripley | RI
Spreadsheet: 817754d1676426542-calculating-payment-due-dates-automatically-subscription-tracker-glenn
Sheet: Interface

 | Service details |  |  | Billing period |  |  |  |  | Context
 | Subscription | Date commenced | Payment Next Due | QTY | Unit | Correct Answer | Multiple |  | 1 | The date as of me creating this is 14 Feb 23.
 | Spotify | 2021-07-21 00:00:00 |  | 4 | w |  | 21 |  | 2 | The cells that are highlighted orange are user input. (Column B, C, E, F)
 | ExpressVPN | 2021-11-09 00:00:00 |  | 5 | d |  | 93 |  | 3 | The cells that are white with orange text are automatic calculations. (Column D)
 | Hulu | 2022-01-09 00:00:00 |  | 1 | y |  | 2 |  | 4 | Column D (Payment Next Due) needs to update every time the previous due date has passed.
 | [NAME] | 2019-12-18 00:00:00 |  | 4 | d |  | 289 |  | 5 | Cell [NAME] is left blank to provide space for solution.
 | Amazon Prime | 2022-04-19 00:00:00 |  | 1 | q |  | 4 |  | 6 | Problem: How do I create the auto-calculations for column D? Thank you for your time.
 | MasterClass | 2022-01-09 00:00:00 |  | 3 | w |  | 20
 | Tidal
 | Apple Music
 | HubSpot
 | Zenefits
 | Disney+
 | Audible
 | GrandBox
 | Kindle Direct
 | Netflix
 | [NAME]
Spreadsheet: 329789d1404404459-index-lookup-for-top-10-index-lookup-1-
Sheet: Sheet1

 | Site | Year | product | VS | project id | Savings
 | California | 2013 | 78 | cargo | INT0002 | 1000
 | California | 2013 | other | cargo | INT0014 | 891 |  |  | Wisconsin Top 10
 | California | 2013 | 78 | cargo | INT0026 | 927 |  |  | project id | product | VS | savings
 | Wisconsin | 2013 | 32 | evac | INT0031 | 1868
 | Florida | 2013 | 38 | seats | INT0036 | 2016
 | Wisconsin | 2013 | 78 | cargo | INT0040 | 1868
 | Florida | 2013 | other | cargo | INT0042 | 1905
 | mexico | 2013 | 100 | cargo | INT0043 | 250
 | Wisconsin | 2014 | 78 | light | INT0001 | 500
 | Wisconsin | 2014 | 78 | cargo | INT0004 | 435
 | Florida | 2014 | 78 | cargo | INT0006 | 205
 | Florida | 2014 | 38 | cargo | INT0009 | 33
 | Wisconsin | 2014 | 38 | seats | INT0010 | 267
 | California | 2014 | 78 | cargo | INT0011 | 677
 | Wisconsin | 2014 | 38 | light | INT0013 | 1743
 | Florida | 2014 | other | light | INT0015 | 2209 |  |  | Mexico Top 10
 | California | 2014 | 33 | evac | INT0020 | 952 |  |  | project id | product | VS | savings
 | California | 2014 | 38 | cargo | INT0023 | 396
 | Wisconsin | 2014 | 77 | light | INT0025 | 1738
 | Wisconsin | 2014 | 78 | seats | INT0034 | 1553
 | mexico | 2014 | 100 | seats | INT0044 | 645
 | Florida | 2015 | 78 | light | INT0003 | 204
 | California | 2015 | 38 | cargo | INT0005 | 734
 | Wisconsin | 2015 | other | evac | INT0007 | 1045
 | Wisconsin | 2015 | cross | cargo | INT0016 | 109
 | Wisconsin | 2015 | 38 | evac | INT0019 | 255
 | Florida | 2015 | 47 | cargo | INT0021 | 1908
 | Wisconsin | 2015 | other | cargo | INT0028 | 1382
 | Florida | 2015 | 47 | cargo | INT0033 | 2189
 | California | 2015 | 38 | cargo | INT0035 | 1323 |  |  | 2014 California Top  10
 | Wisconsin | 2015 | 77 | light | INT0037 | 1088 |  |  | project id | product | VS | savings
 | California | 2015 | 78 | cargo | INT0038 | 1575
 | mexico | 2015 | 300 | evac | INT0045 | 2000
 | mexico | 2015 | 47 | seats | INT0046 | 2000
 | California | 2016 | 78 | evac | INT0008 | 2064
 | Florida | 2016 | 78 | seats | INT0012 | 345
 | California | 2016 | 37 | cargo | INT0017 | 995
 | Florida | 2016 | 47 | cargo | INT0018 | 2036
 | Wisconsin | 2016 | 53 | seats | INT0022 | 405
 | Florida | 2016 | 38 | light | INT0027 | 2240
 | Florida | 2016 | 38 | cargo | INT0030 | 1775
 | Florida | 2016 | other | light | INT0039 | 735
 | Florida | 2017 | other | seats | INT0024 | 1064
 | California | 2017 | other | cargo | INT0029 | 496
 | California | 2017 | 34 | evac | INT0032 | 503
 | California | 2017 | other | cargo | INT0041 | 2255
Spreadsheet: 35941d1233668553-cell-referencing-issues-to-other-worksheets-sample-workbook
Sheet: Sheet1

Wk 1 Sets / Reps / Intensity | 3 | 10 | @ | 65
Wk 2 Sets / Reps / Intensity | 8 | 15 | @ | 68
Wk 3 Sets / Reps / Intensity | 3 | 10 | @ | 71
Wk 4 Sets / Reps / Intensity | 7 | 13 | @ | 65
Wk 5 Sets / Reps / Intensity
Spreadsheet: 474341d1470737086-return-max-and-min-values-from-data-between-two-dates-times-sample28
Sheet: Folha1

 |  |  | 2016-08-09 15:30:00
Time From |  |  | 2016-08-09 16:05:00
2016-08-09 15:00:00 | 20 |  |  | Sum
2016-08-09 15:05:00 | 120 |  |  | [NAME]
2016-08-09 15:30:00 | 245 |  |  | Min
2016-08-09 15:37:00 | 280
2016-08-09 15:52:00 | 280
2016-08-09 16:00:00 | 376
2016-08-09 16:07:00 | 460
2016-08-09 16:30:00 | 460
Spreadsheet: 0a8791de-84e4-4eb4-bfac-22483612972b
Sheet: Heavy Equip Certificates

HEAVY EQUIPMENT OPERATIONS
Certificates
Student Name:
ID #
Prerequisite | Semester | Grade
___ DIT 103 (2) Preventive Maintenance Lab
Backhoe Operator
___ HEO 109 (2) Power Shovel Backhoe Operator
___ HEO 125 (3) Special Problems
Bulldozer Operator
___ HEO 111 (7) Bulldozer Operator
___ HEO 125 (3) Special Problems
Front-End Loader Operator
___ HEO 105 (4) Utility Tractor Loader Operator
___ HEO 125 (3) Special Problems
Motor-Grader Operator
___ HEO 106 (7) Motor Grader Operator
___ HEO 125 (3) Special Problems
Hydraulic Excavator Operator
___ HEO 100 (12) Heavy Equipment Operations I
___ HEO 115 (7) Hydraulic Excavator Operator
___ HEO 125 (3) Special Problems I
Spreadsheet: 24fa70f4-03f0-4b5d-93dd-9f5cf78ba627
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
HENDERSON COMMUNITY COLLEGE
ACADEMIC PLAN/APPLICATION FOR AGRICULTURAL TECHNICIAN CERTIFICATE
EMPL ID |  |  | Major/Program Code |  |  |  |  | Name
([NAME] shaded areas as applicable) |  |  |  |  |  |  |  |  |  |  | (2010-2011)
Academic Success Requirements |  |  |  | Semester | Credit |  |  |  |  |  | Semester | Credit
(May be required) |  |  |  | Taken | Hours |  | Electives |  |  |  | Taken | Hours
ENC 090 - Foundations of College Writing I |  |  |  |  | 3*
ENC 091 - Foundations of College Writing II |  |  |  |  | 3*
MT 055 - Pre-Algebra |  |  |  |  | 3*
MT 065  - Basic Algebra with Measurement |  |  |  |  | 3*
RDG 010 - Introduction to College Reading |  |  |  |  | 3*
RDG 020 - Improved College Reading |  |  |  |  | 3*
RDG 030 - Reading for the College Classroom |  |  |  |  | 3*
* Courses numbered 001-099 and MA 108 do not count toward the
determination of grade point average or as credit toward graduation.
Agricultural Technician II |  |  |  | Semester | Credit
Certificate Requirements |  |  |  | Taken | Hours
AG 125 - Introduction to [NAME] and Soils |  |  |  |  | 3
AG 130 - Field Applications in Agriculture |  |  |  |  | 2
AG 140 - Issues in Agriculture |  |  |  |  | 3
AG 150 - Agricultural Power |  |  |  |  | 3
AG 170 - Intro. to Equipment, Machines, and Engines |  |  |  |  | 3
AG 180 - Agricultural Internship I |  |  |  |  | 2
AG 190 - Agricultural Internship II |  |  |  |  | 2
AG 230 - Career Development in Agriculture |  |  |  |  | 3 |  | The certificate in Agricultural Technician II is
CIS 100 - Introduction to Computers |  |  |  |  | 3 |  | awarded to students who complete the specified requirements
Total Credit Hours |  |  |  |  | 24 |  | with a cumulative grade point average of 2.0 or higher.
HENDERSON COMMUNITY COLLEGE
SEMESTER-BY-SEMESTER ACADEMIC PLAN FOR AGRICULTURAL TECHNICIAN II CERTIFICATE
Semester |  |  | Year |  |  |  | Semester |  |  | Year
Course |  |  |  | Grade | Credit |  | Course |  |  |  | Grade | Credit
 |  |  |  |  | Hours |  |  |  |  |  |  | Hours
Sem. GPA |  | Cum. GPA |  | Total |  |  | Sem. GPA |  | Cum. GPA |  | Total
Semester |  |  | Year |  |  |  | Semester |  |  | Year
Course |  |  |  | Grade | Credit |  | Course |  |  |  | Grade | Credit
 |  |  |  |  | Hours |  |  |  |  |  |  | Hours
Sem. GPA |  | Cum. GPA |  | Total |  |  | Sem. GPA |  | Cum. GPA |  | Total
Semester |  |  | Year |  |  |  | Semester |  |  | Year
Course |  |  |  | Grade | Credit |  | Course |  |  |  | Grade | Credit
 |  |  |  |  | Hours |  |  |  |  |  |  | Hours
Sem. GPA |  | Cum. GPA |  | Total |  |  | Sem. GPA |  | Cum. GPA |  | Total
Semester |  |  | Year |  |  |  | Semester |  |  | Year
Course |  |  |  | Grade | Credit |  | Course |  |  |  | Grade | Credit
 |  |  |  |  | Hours |  |  |  |  |  |  | Hours
Sem. GPA |  | Cum. GPA |  | Total |  |  | Sem. GPA |  | Cum. GPA |  | Total
Spreadsheet: 132804d1323954658-sum-of-dynamic-range-above-result-cell-test_addouting2
Sheet: Sheet1

Test sheet to workout how to add new laps to a run sheet automatically (probably by [NAME] the next available lap) |  |  |  |  |  |  |  |  |  | Fcons/Lap | 3.5
 |  |  |  |  |  |  |  |  |  | FuelStart | 65
Lap/time | Sector 1 | Sector 2 | Sector 3 | Lap time | FCons(Kg) | FRem(Kg) | Laps left | Notes
1 | 4 | 2 | 5 | 22 | 3.5 | 65 | 18
2 | 2 | 3 | 4 | 19 | 7 | 58 | 16
x |  |  |  |  | XYZ | XYZ | XYZ | [NAME]
Total | [NAME] | [NAME] | Best S3 | Min Lap | FCons total | FRem total | Notes
 | 2 | 2 | 4 | 19 | 10.5 | 123
 |  |  |  |  | Kg/lap | [NAME]
Tyre set
Tyre set life | -1 |  |  |  | MFuelUsed | KCons
Spreadsheet: lynn_blair__24434__vacationsched
Sheet: Sheet1

2001-10-01 00:00:00
Vac. Hours left |  |  | DATE |  | C.D. |  |  | Carryover to 2002
[NAME] | 58
[NAME] | 40 |  |  |  | 5,8,18,19,25,26
[NAME] | 64 |  | 5,8
[NAME] | 68 |  | 1,2,3,4,5 |  | 18,19
[NAME] | 60
[NAME] | 40 |  | 19 |  | 11,12
[NAME] | 40 |  |  |  | 4,5
[NAME] | 66 |  | 17 |  | 18,19
[NAME] | 56 |  |  |  | 25,26
[NAME] | 136
[NAME] | 112 |  |  |  | 11,12
[NAME]
[NAME] | 58
[NAME] | 40 |  | 5,6,7,8,9, |  | 1,2,27,28,29,30
[NAME] | 32 |  |  |  | 8, 9, 20, 21
[NAME] | 28 |  |  |  | 8,9,27,28,29,30
[NAME] | 60 |  |  |  | 1,2
[NAME] | 32 |  | 19,20,21 |  | 1,2,15,16
[NAME] | 40 |  |  |  | 1,2
[NAME] | 58 |  | 2 |  | 15,16
[NAME] | 56
[NAME] | 136
[NAME] | 112
Dec. -01
[NAME] | 58 |  |  |  | 26,27,28,31 |  |  | 58
[NAME] | 0 |  |  |  | 20,21 |  |  | 0
[NAME] | 32 |  |  |  |  |  |  | 32
[NAME] | 28 |  |  |  |  |  |  | 28
[NAME] | 60 |  | 21,26,27,(dis day 28) |  |  |  |  | 36
[NAME] | 8 |  |  |  | 6,7,26,27,28,31 |  |  | 8
[NAME] | 40 |  | 31 |  | 13,14 |  |  | 32
[NAME] | 50 |  | 17,18,19,20,21 |  | 6,7 |  |  | 10
[NAME] | 56 |  |  |  | 13,14 |  |  | 56
[NAME] | 136 |  | 26,27,28,31 |  |  |  |  | 104
[NAME] | 112 |  |  |  | 20,21 |  |  | 112
Spreadsheet: 838004d1690588185-keep-a-group-family-rows-together-when-sorting-ef1612_group-sort
Sheet: Sheet1

[NAME] | Account Number | Account Type | Fee Structure | HELPER_1 | Helper_2 |  | Expand all the Groups, so all the data is visible, then Ungroup the data from Rows (on Data tab)
[NAME] | KramerGroup | Group | Standard Fee |  |  |  | Enter formulae in E2 and F2 and copy down to the bottom of your data
[NAME] | 6579 | IHIRA
[NAME] | 9194 | RH
Mark | 7368 | SEP
[NAME] | 1609 | CO
Jake | 2159 | IHIRA
[NAME] | 4187 | LT
Nick | 1817 | LT
[NAME] | DossGroup | Group | 0.01
[NAME] | 2786 | JT
Scott | 6214 | RH
[NAME] | 2009 | RO
[NAME] | 9230 | RH
Sara | 5866 | CO
[NAME] | CorthGroup | Group | Standard Fee
Kristy | 1259 | IN
[NAME] | 1681 | RO
[NAME] | StevensGroup | Group | Standard Fee
[NAME] | 8921 | LT
[NAME] | 1984 | RO
[NAME] | MartinGroup | Group | Standard Fee
[NAME] | 4449 | IN
Mark | 3834 | RH
[NAME] | 3767 | SEP
Cox Family | CoxGroup | Group | GrandFathered
[NAME] | 3785 | IN
[NAME] | 8426 | CO
Mixon Family | MixonGroup | Group | Standard Fee
[NAME] | 4516 | RO
[NAME] | 5400 | SEP
Samantha | 9247 | JT
Julie | 6012 | RO
Spreadsheet: chris_germany__1840__DPLcapacitybymonth
Sheet: 8-99

DAYTON CAPACITY : |  |  | AUGUST 1999
 |  |  |  |  |  | [NAME] | TOTAL
PIPE | RECEIPT | DELIVERED | DELIVERY POINT | FUEL | COMMODITY | DEL CHARGE | VARIABLE
ANR |  | 0 | Pool to Farmersville (DPL) gate | 0.0458 | 0.0147 | 0 | 0.101
PEPL |  | 1183 | Pool to DPL gate or other point (milage) | 0.0554 | 0.0498 | 0 | 0.155
TXG |  | 2493 | zn SL or zn 1 to DPL gate in zn 4 | 0.0287 | 0.0409 | 0 | 0.094
TCO |  | 0 | Leach / Lebanon FT to DPL gate | 0.0223 | 0.0246 | 0 | 0.066
TRUNK |  | 12029 | ELA or WLA to TETCO or [NAME] | 0.0227 | 0.0174 | 0 | 0.059
TETCO |  | 11560 | Receipt from Trunkline to Market | 0.039 | 0.0871 | 0 | 0.163
Trunk |  | 0 | Bourbon / Tuscola | 0.0227 | 0.0174 |  | 0.059
Pepl |  | 0 | Gas City / Tetco / Lebanon | 0.009 | 0.0075 |  | 0.24
Tetco |  | 0 | Farmersville / Lebanon | 0.0043 | 0.0871 |  | 0.163
Trunk |  | 0 | Bourbon / Tuscola | 0.0227 | 0.0174 |  | 0.059
Pepl |  | 0 | [NAME] or Tco Maumee | 0.0135 | 0.01 |  | 0.035
 |  |  | 282 Miles
Trunk |  | 0 | Bourbon / Tuscola | 0.0227 | 0.0174 |  | 0.059
Pepl |  | 0 | MichCon / Consumers / Union | 0.018 | 0.0125 |  | 0.047
 |  |  | 347 - 350 Miles
 |  |  |  | 31 | Days | July '99
 |  |  | APPROMIMATE SST AVAILABLE FOR CES USE Daily:
 |  |  |  | 120000 | Daily SST |  | Monthly SST
 |  |  |  |  | Daily DPL | 700000 | Monthly DPL
Spreadsheet: 709677d1608480920-number-of-times-a-month-day-falls-on-a-certain-day-of-week-within-a-range-of-years-day
Sheet: Sheet1

Start Date |  | End date |  | Date in question |  |  | Day of interest |  | Number of occurances
1985-01-22 00:00:00 |  | 2020-12-20 00:00:00 |  | 2020-06-05 00:00:00 |  |  | Friday
 |  |  |  | 05-Jun
Spreadsheet: 849772d1700161660-na-affecting-if-or-formula-na-affecting-if-or-formula-1
Sheet: Sheet1

Part | Is it engine related? | Details
Wheel
Brake rotor
#N/A |  | I want this to return No (but I can't edit the #N/A in column A. That data must remain)
Camshaft
Piston
Differential
Brake pad
Seat
Steering wheelo
Radio
Spreadsheet: 155571d1336967509-excel-2007-using-excel-to-determine-which-row-to-choose-weight-example-1
Sheet: Sheet1

Batch number | Start Date | End Date | Weight | Grade | Desired out come |  |  | Grade
24689001 | 2007-03-25 00:00:00 | 2009-03-24 00:00:00 |  |  |  |  |  | Premium
24689001 | 2007-03-20 00:00:00 | 2009-03-24 00:00:00 |  |  |  |  |  | Very Good
24689001 | 2007-04-16 00:00:00 | 2009-04-15 00:00:00 |  |  |  |  |  | Good
24689001 | 2009-03-25 00:00:00 | 2010-03-24 00:00:00 |  | Premium | Select this row of data |  |  | Above Average
24689001 | 2009-03-25 00:00:00 | 2013-05-07 00:00:00 |  | Reject |  |  |  | Average
99987543 | 2007-03-25 00:00:00 | 2009-03-24 00:00:00 |  | Reject | Select this row of data |  |  | Below Average
43452532 | 2007-03-25 00:00:00 | 2009-03-24 00:00:00 |  | Very Good | Select this row of data |  |  | Poor
43452532 | 2008-03-29 00:00:00 | 2009-12-12 00:00:00 |  | Good |  |  |  | Reject
43452532 | 2009-03-25 00:00:00 | 2010-03-24 00:00:00 |  | Above Average |  |  |  | Destory
53246532 | 2007-04-16 00:00:00 | 2009-04-15 00:00:00 |  | Average | Select this row of data
24689051 | 2009-03-25 00:00:00 | 2010-03-24 00:00:00 |  | Good
24689051 | 2009-03-25 00:00:00 | 2007-03-24 00:00:00 |  | Below Average
24689051 | 2009-03-25 00:00:00 | 2008-03-24 00:00:00 |  | Poor
24689051 | 2009-03-25 00:00:00 | 2010-03-24 00:00:00 |  | Destory
24689051 | 2009-03-25 00:00:00 | 2010-05-24 00:00:00 |  | Above Average
24689051 | 2009-03-25 00:00:00 | 2010-08-24 00:00:00 |  | Good
24689051 | 2009-03-25 00:00:00 | 2014-09-24 00:00:00 |  | Premium | Select this row of data
24689051 | 2009-03-25 00:00:00 | 2018-03-24 00:00:00 |  | Very Good
Spreadsheet: 731657d1620486509-v-lookup-based-on-different-sheets-using-data-validation-list-test-sheets-ans
Sheet: Mar 23

Enter 1st of Month Here -> | 2023-03-01 00:00:00 | Controller | Volunteer 1 | Volunteer 2 | Volunteer 3 | Volunteer 4 | Volunteer 5 | Volunteer 6
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
Sat
Sun
Spreadsheet: daren_farmer__5452__hpl0902
Sheet: Sheet1

HPLN0902XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  AMI_CHOSKI / ENRON
FROM:  [NAME]  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - September 02, 2000
 |  |  |  |  |  | ** Sat/Sun | ** Monday | ** Tuesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 9/2-3/2000 | 2000-09-04 00:00:00 | 2000-09-05 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs. | Eff. 0900 hrs. | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED | NOMINATED | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL
 |  |  |  |  | 0 to 30  0900hrs | 0 to 30  0900hrs | 0 to 30  0900hrs | 0 to 30  0900hrs
 |  |  |  |  | 30  to 0 2100hrs | 30  to 0 2100hrs | 30  to 0 2100hrs | 30  to 0 2100hrs
 |  | Firm Summary
Enron (S) |  | Oasis Turbine |  | ENA | 0 | 1.8 | 1.8 | 1.8
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | 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: 216951d1361933431-trouble-with-index-and-match-formula-sampledata
Sheet: TARPLANS

Service Location | Work Order Number | [NAME] of Work: | Task | Craft | Crew | Duration | Total | Total Man Hours Required
71 D-3A/4"-P-109-K | 3976573 | Replace 4" Nozzle Per IR 12-71-022 | IR 12-71-022 Manway 18"-300 [NAME] During The Dessicant Change Out On D-3A. | 0 | 0 | #N/A | #N/A | #N/A
71 D-7/1"-P-137-K | 4088194
71 E-103 | 4088205
71 E-107/6"-P-106-F | 4088189
71 H-1/ 1"-FG-253-AC | 4088191
71 P-101/ 3/4"-P-108-K | 4088195
71 P-106B/3/4"-P-212-F | 4060225
71 T-1 / 3"-P-206-F | 4088187
71 T-2/1"-P-001-FX | 4060230
71D1 | 1784813
71D12 | 1802923
71D4 | 1802887
71D5 | 1802869
71E104 | 1802882
71E105 | 1802883
71E106A | 1802927
71E106B | 1802928
71E107 | 1802930
71E109A | 1802933
71E109B | 1802934
71-E110A | WO1821241
71E110B | 1821242
71E111 | 2629993
71E112A | 1802938
71E113 | 1802925
71FL(FE)1125 | 1821300
71FL(FT)1104 | 3517846
71FT1108 | WO 3517849
71FT1110 | 5829545
71FT1121 | 3517851
71FT1151 | 5829546
71FT1152 | 3517852
71FT1153 | 5829547
71FT1154 | 5829548
71FT1155 | 5829549
71FT1156 | 5829550
71FT1158 | 5872189
71LV1404 | WO 2698708
71PT1212 | 3517853
E-109A&B/1-1/2"-P-216F | 4060231
E-113/3"-P-301-30A | 3976573
Various | 4088197
Spreadsheet: 733136d1621415670-formulas-with-multiple-range-criteria-not-returning-result-s-1
Sheet: Sheet1

Product Code | Product Name | XYZ | ABC | DEF | GHI
60000000 | ABC | 12
 | ASD
 | QWE
 | RTY
 | UIO
 | KJH
 | NHJ
 | MKO
Sr. No | Party Name | ABC | ASD | QWE | RTY | UIO | KJH | NHJ | MKO
1 | XYZ | 12 | 32 | 52 | 72 | 92 | 112 | 132 | 152
2 | ABC
3 | DEF
4 | GHI