tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: tracy_geaccone__40531__ETS - NNG IC 10-19
Sheet: Enterprise Portal Solutions

E N R O N   N et Works
2 0 0 2   P L A N |  |  |  |  |  |  |  |  |  |  |  |  | Enterprise Portal Solutions
 | SAP PROFIT CENTER: |  | 10737
 | PROFIT CENTER OWNER: |  | [NAME]
 | SAP COST CENTER: |  | 140569 |  |  |  |  |  |  |  | DUE DATE: |  | 2001-09-05 00:00:00
Direct expenses |  |  |  |  |  |  | 28032.31
Indirect expenses |  |  |  |  |  |  | 3331.85
TOTAL EXPENSES |  |  |  |  |  |  | 31364.16
OTHER COMPENSATION EXPENSES |  |  |  |  |  |  | 3660.04
TOTAL EXPENSES |  |  |  |  |  |  | 35024.2
Spreadsheet: 881857d1730098845-count-if-max-book2
Sheet: Sheet2

NAME | No. of MAX
M COOPER (1) | 2
A GILCHRIST  (2) | 0
S MCCALLUM (3) | 0
O ARBLASTER  (4) | 1
G BOLDOCK (STARMAN) | 0
H SOUTTAR (6) | 1
R BREWSTER  (7) | 0
G HAMER  (8) | 2
K MOORE (9) | 0
C O'HARE  (10) | 0
J RAK-SAKYI (11) | 1
I GRBIC (13) | 0
H BURROWS (14) | 1
A AHMEDHODZIC (15) | 0
J SHACKLETON (16) | 0
A DAVIES (17) | 0
J ROBINSON (19) | 0
V DE SOUZA COSTA (21) | 4
T DAVIES (22) | 0
T CAMPBELL (23) | 0
A BEN SLIMANE  (25) | 0
I [NAME] (29) | 0
R NORRINGTON-DAVIES  (33) | 0
L MARSH  (34) | 0
A BROOKS  (35) | 0
F SERIKI  (38) | 0
R ONE (39) | 0
S PECK  (42) | 1
H BOYES  (43) | 0
O [NAME]  (44) | 0
S SACHDEV (45) | 0
Spreadsheet: 158930d1338452886-excel-2007-formula-which-returns-the-working-days-of-a-month-stopping-at-the-end-of-it-working-days
Sheet: 2012 - Working Days

 | 2011-12-31 00:00:00 | 2012-01-31 00:00:00 | 2012-02-29 00:00:00 | 2012-03-31 00:00:00 | 2012-04-30 00:00:00 | 2012-05-31 00:00:00 | 2012-06-30 00:00:00 | 2012-07-31 00:00:00 | 2012-08-31 00:00:00 | 2012-09-30 00:00:00 | 2012-10-31 00:00:00 | 2012-11-30 00:00:00
1
2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-01 00:00:00 | Holidays
3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-06 00:00:00
4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-27 00:00:00
5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-25 00:00:00
6 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-13 00:00:00
7 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-15 00:00:00
8 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-16 00:00:00
9 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-01 00:00:00
10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-15 00:00:00
11 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-10-28 00:00:00
12 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-11-17 00:00:00
13 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-25 00:00:00
14 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-26 00:00:00
15
16
17
18
19
20
21
22
23
Spreadsheet: 214898d1361182000-how-to-create-a-packing-list-from-a-distribution-list-blist
Sheet: Sheet1

S.No |  | ME No. | Territory | A guide to walking | Running in the Park | Night and Day | [NAME] | School Days | Final Warning | Culture and Society
1 | [NAME] | 102 | BL | 5 | 3 | 3 | 3 | 3 | 2 | 2
2 | [NAME] | 105 | BL | 5 | 3 | 3 | 5 | 3 | 2 | 2
3 | GCE Texas | 112 | BL | 5 | 3 | 4 | 3 | 3 | 2 | 2
1 | GCET York | 326 | PB | 4 | 2 | 2 | 2 | 4 | 2 | 3
2 | GCET Boston | 325 | PB | 4 | 2 | 2 | 2 | 2 | 2 | 2
1 | GCET Karachi | 315 | PB | 4 | 2 | 2 | 2 | 2 | 1 | 1
2 | GCET Mango | 323 | PB | 3 | 1 | 4 | 3 | 4 | 2 | 1
3 | GCET Apex | 328 | PB | 4 | 2 | 2 | 2 | 2 | 1 | 1
2 | GCET Large | 324 | PB | 4 | 3 | 3 | 3 | 3 | 2 | 2
Spreadsheet: 220636d1363206605-return-a-value-in-a-range-based-on-two-conditions-in-adjacent-ranges-workbook-example
Sheet: Sheet1

A | B | C | D
Row 2 | Monday | Shift 1 | 8
Row 3 | Monday | Shift 2 | 9
Row 4 | Monday | Shift 3 | 7
Row 5 | Tuesday | Shift 1 | 8
Row 6 | Tuesday | Shift 2 | 11
Row 7 | Tuesday | Shift 3 | 7
Spreadsheet: 802719d1666986105-can-some-one-help-with-a-multi-criteria-index-match-excel-simple-array-logic-please
Sheet: (15Dock)

Activity ID | Activity Name | At Completion Duration | Start | Finish | BL Project Start | BL Project Finish
15D-72050 | PCK4 - Agree Z Clauses for Stage 2 Contract | 0 |  | 2022-08-31 00:00:00 |  | 2021-10-05 00:00:00
15D-S0010 | Phase 1 - Base Line Safety Assessment Development Complete | 0 |  | 2023-06-22 00:00:00 |  | TBC
15D-S0030 | Phase 3 - Safety Assessment Complete | 0 |  | 2023-08-08 00:00:00 |  | TBC
15D-6160 | PCK2 - SRC Subway Clearance - Documents Complete - M4.2 | 0 |  | 2022-10-12 00:00:00 |  | 2022-10-12 00:00:00
15D-79560 | PCK3 - Cradle (Astute) - FLEET 22 Construction Complete - M3.2 | 0 |  | 2022-09-27 00:00:00 |  | 2022-06-14 00:00:00
15D-62510 | PCK5 - AltMecH (Materials) - Issue RTM | 0 |  | 2023-02-01 00:00:00 |  | 2022-10-07 00:00:00
15D-CE028-90010 | SWCS A18 Option - Planned Completion Date | 0 |  | 2023-05-22 00:00:00 |  | 2023-02-02 00:00:00
C-S3110 | Column Strengthening - MNC Complete | 0 |  | 2022-11-11 00:00:00 |  | 2022-09-27 00:00:00
FW71750 | [NAME] | 0 |  | 2022-11-04 00:00:00 |  | 2022-10-07 00:00:00
FW72550 | [NAME] | 0 |  | 2023-03-03 00:00:00 |  | TBC
15D-SUB-1130 | Demin Break Tank Delivery Complete <<15D-66220>> | 0 |  | 2023-04-04 00:00:00 |  | 2022-08-25 00:00:00
15D-SUB-1090 | Diesel Generators Delivery Complete <<15D-31690>> | 0 |  | 2022-12-02 00:00:00 |  | 2022-09-05 00:00:00
Flood Wall Programme TBC
Flood Wall Programme TBC
Fleet 22: | Activity ID | Activity Name | Activity Type | BL Project Duration | Current Duration | BL Project Start | Start | BL Project Finish | Finish | Owner | Total Float | MIP Key Progress Milestones | MIP Milestone Categories | MIP Contractual Milestone | [NAME] | WBS | WBS Name
15D-S17260 | 15D-S17260 | FLEET 22 Modifications (Excluding Flood Wall) DETERMINISTIC COMPLETION DATE | Finish Milestone | 0 | 0 |  |  |  | 2023-07-06 00:00:00 | [NAME] | 60 | KPM.L1 |  | C.P | [NAME] | Fleet 22_0722.MS.8 | Construction Milestones
15D-17520 | 15D-17520 | PCK4 - Completion of Electrics Detailed Design Review [Programme ID Ref A10390] | Finish Milestone | 0 | 0 |  |  | 2022-05-31 00:00:00 | 2022-11-09 00:00:00 |  | 105 | KPM.L1 |  | C.P | [NAME] | Fleet 22_0722.MS.1 | Contractual Fee Milestones
15D-17540 | 15D-17540 | PCK3 - Astute Cradle Refurbishment Complete [Programme ID Ref A9300 /A14170] [Ops and Maintenance Dependency] | Finish Milestone | 0 | 0 |  |  | 2022-07-01 00:00:00 | 2022-12-06 00:00:00 |  | 176 | KPM.L1 |  | C.P | [NAME] | Fleet 22_0722.MS.1 | Contractual Fee Milestones
15D-17260 | 15D-17260 | DOCK READY TO RECEIVE A CLASS VESSEL (Deterministic Plan Date) [Programme ID Ref A11010 / A13580] | Finish Milestone | 0 | 0 |  |  | 2023-02-14 00:00:00 | 28-09-23* | [NAME] | 0 | KPM.L1 |  | C.P | [NAME] | Fleet 22_0722.MS.1 | Contractual Fee Milestones
Spreadsheet: 836405d1689326903-finding-most-often-frequency-works-or-gives-ref-error-why-doesnt-this-work
Sheet: Sheet1

Account | Location | Lead
123A | Chicago | Ricky |  | 123A
234A | Miami | Shelly |  | Location
345A | New York | [NAME] |  | Lead | Ricky
456A | Los Angeles | [NAME]
567A | Seattle | [NAME]
678A | Houston | [NAME]
789A | Denver | [NAME]
890A | Seattle | [NAME]
901A | Las Vegas | Magnuson
234A | Miami | Shelly
345A | New York | [NAME]
123A | Seattle | [NAME]
789A | Miami | [NAME]
890A | Atlanta | Skippy
890A | Atlanta | Skippy
901A | Chicago | Magnuson
234A | Miami | Shelly
345A | New York | [NAME]
456A | Chicago | [NAME]
567A | Seattle | [NAME]
678A | Houston | [NAME]
789A | Denver | [NAME]
123A | Chicago | Ricky
456A | Los Angeles | [NAME]
567A | Las Vegas | Magnuson
901A | Chicago | Magnuson
Spreadsheet: 775950d1649409308-max-if-function-across-several-sheets-test
Sheet: Master

ID | Name | Last Contact Date
1 | A
2 | B
3 | C
4 | D
5 | E
6 | F
7 | G
8 | H
9 | I
10 | J
11 | K
12 | L
13 | M
14 | N
15 | O
16 | P
17 | Q
18 | R
19 | S
20 | T
21 | U
22 | V
23 | W
24 | X
25 | Y
26 | Z
Spreadsheet: 146374d1332154532-if-function-advanced-another-rank
Sheet: Sheet1

Anna | 2 | 1st best | 1st best
Luisa | 4 | 2nd best | 1st best
Luisa | 3 | 1st best | 2nd best
[NAME] | 1 | 1st best | 4th best
[NAME] | 8 | 4th best | 1st best
[NAME] | 7 | 3rd best | 2nd best
[NAME] | 5 | 2nd best | 3rd best
[NAME] | 1 | 1st best | 2nd best
[NAME] | 9 | 2nd best | 1st best
Dann | 2 | 1st best | 1st best
Hari | 2 | 1st best | 1st best
 |  | rank ascending | rank descending
Spreadsheet: 356801d1415212097-average-of-averages-with-if-book1
Sheet: Team AVG

Date | Team RPE Avg | Team HR Avg | HRR (199) | TIME (MIN) |  |  | AVG RPE's | Correlating HR's | HRR (199) |  | RPE AVG | HR's AVG | HRR
 |  |  | 0.75 |  |  |  | > 6.6 | 136.5 | 0.69 |  | 4 |  | 0.68
 |  |  | 0.68 |  |  |  | < 6.6 | 148 | 0.73 |  | 5 |  | 0.72
 |  |  | 0.77 |  |  |  |  |  |  |  | 6 (6) |  | 0.69
 |  |  | 0.58 |  |  |  |  |  |  |  | 7 (3) |  | 0.75
 |  |  | 0.74 |  |  |  |  |  |  |  | 8 ( 3) |  | 0.73
 |  |  | 0.74
 |  |  | 0.7 |  |  |  | Time in PRCT (Min.); 10/21 Two-A-Day
 |  |  | 0.68 |  |  |  | 70 - 95 | 96 - 130 | > 131
 |  |  | 0.67 |  |  |  | 2014-10-07 00:00:00 | 2014-10-06 00:00:00 | 2014-10-03 00:00:00
 |  |  | 0.77 |  |  |  | 2014-10-10 00:00:00 | 2014-10-08 00:00:00 | 2014-10-04 00:00:00
 |  |  | 0.71 |  |  |  | 2014-10-23 00:00:00 | 2014-10-14 00:00:00 | 2014-10-11 00:00:00
 |  |  | 0.63 |  |  |  | 2014-10-27 00:00:00 | 2014-10-21 00:00:00 | 2014-10-13 00:00:00
 |  |  | 0.68 |  |  |  | 2014-10-28 00:00:00 | 2014-10-24 00:00:00 | 2014-10-22 00:00:00
 |  |  | 0.72
 |  |  | 0.72
Spreadsheet: 053ef7c5-aed4-43bb-abb6-f6a8c1a9fb9c
Sheet: CIAO

CIAO
2005-2006
 | 2005-07-01 00:00:00 | 2005-08-01 00:00:00 | 2005-09-01 00:00:00 | 2005-10-01 00:00:00 | 2005-11-01 00:00:00 | 2005-12-01 00:00:00 | 2006-01-01 00:00:00 | 2006-02-01 00:00:00 | 2006-03-01 00:00:00 | 2006-04-01 00:00:00 | 2006-05-01 00:00:00 | 2006-06-01 00:00:00 | Total | 2005-2006 price | Price per search
CIAO
Sessions | 40 | 9 | 56 | 120 | 198 | 92 | 20 | 83 | 128 | 289 | 47 | 46
Searches | 96 | 15 | 136 | 284 | 886 | 271 | 17 | 142 | 264 | 763 | 92 | 89 |  | 898
Spreadsheet: 628268d1560473792-help-calendar-correction-employee-absence-schedule-current-6-13-19
Sheet: Employee Names

 | Employee Names
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month | 31
 | Employee Names |  |  |  |  |  |  |  |  |  |  |  |  |  |  | January | January
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | February | March
 | Lynda |  |  |  |  |  |  |  |  |  |  |  |  |  |  | March | May
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | April | July
 | Heather |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May | August
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | June | October
 | Emili |  |  |  |  |  |  |  |  |  |  |  |  |  |  | July | December
 | Amber |  |  |  |  |  |  |  |  |  |  |  |  |  |  | August
 | Meredith |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September
 | Julie |  |  |  |  |  |  |  |  |  |  |  |  |  |  | October
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | November
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | December
Spreadsheet: 826002d1681729524-credit-card-installment-ccard-aligw1
Sheet: Sheet1

A BANK |  |  |  |  |  | 2022 |  |  |  |  |  |  |  |  |  |  |  | 2023 |  |  |  |  |  |  |  |  |  |  |  | 2024
shopping date | product | account closing date | amount | number of installments |  | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00
2023-04-16 00:00:00 | nike | 2023-05-04 00:00:00 | 2350.53 | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In the installment distribution, it was supposed to be in April delivery.
 |  |  |  | formula  :
 |  | Installment starts missing
 |  | It needs to calculate based on the criteria in cell g8.
 |  | It needs to be revised by calculating the year.
 |  | your formula does not include the installment on the date of purchase.
 |  | There are installments between the shopping date and the account closing date. |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 261.17 |  |  |  |  |  | this installment won't be there
 |  | If we add the year criterion to the formula in cell [NAME], the problem is solved.
 |  | According to the example, installments should occur in April and December.
Spreadsheet: 478145d1472654912-attendance-sheet-how-to-best-summarise-data-time-clock
Sheet: Sheet1

Date | Time | ID | Name |  |  |  |  |  | ID | NAME
2016-08-28 00:00:00 | 12:00:00 | 13997 |  |  |  |  |  |  | 13997 | [NAME]
2016-08-28 00:00:00 | 14:00:00 | 13997 |  |  |  |  |  |  | 15000 | [NAME]
2016-08-28 00:00:00 | 20:00:00 | 15000 |  |  |  |  |  |  | 16000 | [NAME]
2016-08-28 00:00:00 | 21:00:00 | 15000
2016-08-28 00:00:00 | 11:00:00 | 16000
2016-08-28 00:00:00 | 12:00:00 | 16000
2016-08-29 00:00:00 | 08:00:00 | 13997
2016-08-29 00:00:00 | 09:00:00 | 13997
2016-08-29 00:00:00 | 19:00:00 | 15000
2016-08-29 00:00:00 | 20:00:00 | 15000 |  |  |  |  |  |  | Summary
2016-08-29 00:00:00 | 10:00:00 | 16000 |  |  |  |  |  |  | 14:19:00 | 19:20:00
2016-08-29 00:00:00 | 11:00:00 | 16000
2016-08-30 00:00:00 | 08:00:00 | 13997
2016-08-30 00:00:00 | 09:00:00 | 13997
2016-08-30 00:00:00 | 19:00:00 | 15000
2016-08-30 00:00:00 | 20:00:00 | 15000
2016-08-30 00:00:00 | 10:00:00 | 16000
2016-08-30 00:00:00 | 11:00:00 | 16000
2016-08-31 00:00:00 | 12:00:00 | 13997
2016-08-31 00:00:00 | 14:00:00 | 13997
2016-08-31 00:00:00 | 20:00:00 | 15000
2016-08-31 00:00:00 | 21:00:00 | 15000
2016-08-31 00:00:00 | 11:00:00 | 16000
2016-08-31 00:00:00 | 12:00:00 | 16000
Spreadsheet: 100486d1298851748-sumifs-alternative-for-excel-2003-sumproduct-not-working-newkvs
Sheet: Friday

Weekly [NAME] |  |  |  |  | Friday
Hour | T/C | TTL | TTL | Name | Shift Manager
0000 - 0100 | 0 | 0 | #N/A
0100 - 0200 | 0 | 0 | #N/A
0200 - 0300 | 0 | 0 | #N/A
0300 - 0400 | 0 | 0 | #N/A
0400 - 0500 | 0 | 0 | #N/A
0500 - 0600 | 0 | 0 | #N/A
0600 - 0700 | 8 | 1635 | 204.375 |  | Darren Green
0700 - 0800 | 24 | 1334 | 55.58333333333334 |  | Darren Green
0800 - 0900 | 49 | 2395 | 48.87755102040816 |  | Darren Green
0900 - 1000 | 77 | 6005 | 77.98701298701299 |  | Darren Green
1000 - 1100 | 70 | 1614 | 23.05714285714286 |  | Darren Green
1100 - 1200 | 58 | 1444 | 24.89655172413793 | [NAME] | Darren Green
1200 - 1300 | 100 | 2877 | 28.77 |  | [NAME]
1300 - 1400 | 99 | 2346 | 23.6969696969697 |  | [NAME]
1400 - 1500 | 93 | 2778 | 29.87096774193548 |  | [NAME]
1500 - 1600 | 84 | 2609 | 31.05952380952381 |  | [NAME]
1600 - 1700 | 73 | 2963 | 40.58904109589041 |  | [NAME]
1700 - 1800 | 74 | 2742 | 37.05405405405406 |  | [NAME]
1800 - 1900 | 55 | 1393 | 25.32727272727273 |  | [NAME]
1900 - 2000 | 37 | 813 | 21.97297297297297 |  | [NAME]
2000 - 2100 | 23 | 899 | 39.08695652173913 |  | [NAME]
2100 - 2200 | 12 | 230 | 19.16666666666667 |  | [NAME]
2200 - 2300 | 7 | 126 | 18 |  | [NAME]
2300 - 0000 | 0 | 0 | #N/A
Spreadsheet: 271528d1381963604-can-i-get-vlookup-to-change-which-sheet-it-is-working-from-pay-increase-v3
Sheet: Sheet1

My Performance My Pay
My current pay rate |  | 9.23 |  | My Last performance rating |  |  | Outstanding |  | my branch number |  |  | 152
pay zone |  |  |  | My minimum pay increase |  |  |  |  | my maximum pay increase
 | 1 |  | 2 |  | 3 |  | 4
Outstanding | 0.05 | 0.1 | 0.04 | 0.09 | 0.03 | 0.08 | 0.02 | 0.07
Very good | 0.04 | 0.08 | 0.03 | 0.07 | 0.02 | 0.06 | 0 | 0.02
Good | 0.03 | 0.06 | 0.02 | 0.05 | 0 | 0.02 | 0 | 0
Developing | 0 | 0.02 | 0 | 0.02 | 0 | 0 | 0 | 0
Under performing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 681181d1591377579-vlookup-and-index-match-quicker-alternatives-example
Sheet: Sheet1

ID | Country | Role | UniqueId
1 | France | C
2 | Italy | I
3 | Italy | C
4 | Italy | I
5 | Iran | C
6 | Germany | I
7 | Holland | C
8 | Holland | I
9 | Holland | C
10 | [NAME] | I
Spreadsheet: 809912d1671435595-summarise-multiple-excel-worksheets-into-one-sheet-book1
Sheet: Raw Data 2

ID | Surname | First Name | Job | Q1 | Q2 | Q3 | Q4
2931 | Wick | [NAME] | Legal | 55 | 3 | 99 | 96
1591 | [NAME] | [NAME] | HR | 85 | 20 | 55 | 77
1289 | [NAME] | [NAME] | IT | 65 | 97 | 54 | 99
2147 | Wo | [NAME] | IT | 12 | 75 | 4 | 4
Spreadsheet: 683027d1592444654-combining-3-array-formulas-to-one-collating-from-multiple-sheets-based-on-conditions4
Sheet: HO

Name | Phone | Date order Received | [NAME] | Disc £ ea | Balance | Paid | Product | Notes/ Special Reqs | Status | Collection Date | Time | Include
pete |  | 12 |  |  |  | 6f |  |  |  | 2020-06-23 00:00:00 | 14:00:00
[NAME] |  | 1 |  |  |  | 5f |  |  |  | 2020-06-21 00:00:00 | 08:00:00
[NAME] |  | 4 |  |  |  | 14f |  |  |  | 2020-06-23 00:00:00 | 07:00:00
Spreadsheet: 829319d1684139317-is-there-a-formula-to-extract-a-specific-string-from-a-cell-not-in-a-particular-position-example_codeextractv2
Sheet: Sheet1

Text | Code
The quick brown fox jumps over the lazy dog; AB12: 025-12345678.12
PO004161 -The quick brown fox jumped over the lazy, lazy dog. The quick brown fox jumped over the dog there he goes jumping; AE01: 360-12345678.02. 12345678 | 0.2916666666666667 | 12345678.02 | 12345678.02 | 12345678.02
12345678 -The quick brown fox jumps over the lazy dog | 12345678 | 12345678 | 12345678 | 12345678
The quick brown fox jumps over the lazy dog; AB12: ABC12345678.12 | 12345678.12 | 12345678.12 | 12345678.12 | 12345678.12
1234567 -The quick brown fox jumps over the lazy dog | 1234567 | 1234567 | 1234567 | 1234567
Jumping -The quick brown fox jumped over the lazy, lazy dog. The quick brown fox jumped over the dog there he goes jumping; AE01: 360-12345678.02. 12345678 | 0.2916666666666667 | 12345678.02 | 12345678.02 | 12345678.02
Jumping -The quick brown fox jumped over the lazy, lazy dog. The quick brown fox jumped over the dog there he goes jumping over the dog; AE01: 360-12345678.02. 12345678 | 0 | 12345678.02 | 12345678.02 | 12345678.02
 | 1234567
1234567 -The quick brown fox jumps over the lazy dog | 92345678 | 1234567 | 1234567 | 1234567
jumping; AE01: 360-12345678.02. 92345678 |  | 92345678 | 12345678.02 | 12345678.02
Spreadsheet: 214716d1361080435-need-help-with-populating-worksheet-with-rows-from-other-sheet-based-on-criteria-2013-pinto-schedule
Sheet: Cubs

Field | Date | Day | Start Time | Away | AC | HC | Home |  | Code | Team | Away Games | Home Games | Total Games
 |  |  |  |  |  |  |  |  | 1 | A's
 |  |  |  |  |  |  |  |  | 3 | Dodgers
 |  |  |  |  |  |  |  |  | 4 | Phillies
 |  |  |  |  |  |  |  |  | 5 | Pirates
 |  |  |  |  |  |  |  |  | 6 | Tigers
 |  |  |  |  |  |  |  |  | 7 | Yankees
Spreadsheet: 87034d1286962726-merging-concatenating-multiple-columns-sw_sjs
Sheet: Sheet1

 | Service Journeys
SW ID | L2C | T2R | A2T | RFT |  | What I want to see per row |  | How I've tried so far is creating these additional columns and using CONCATENATE in column N. | L2C | T2R | A2T | RFT
APP0001 | Y |  |  |  |  | L2C
APP0235 |  | Y |  | Y |  | T2R,RFT
APP0568 |  |  | Y |  |  | A2T
APP1678 |  | Y | Y | Y |  | T2R,A2T,RFT
[NAME]
APP1069 | Y | Y | Y | Y |  | L2C,T2R,A2T,RFT
APP0023 |  |  | Y |  |  | A2T
Spreadsheet: 664924d1582827787-need-help-with-a-homewwork-assignment-using-index-match-and-indirect-functions-kelso_excel_ch05_ps1_resourcecenter
Sheet: EventAnalysis

Event Analysis
 |  |  |  |  |  | Registration Goals
EventID | EventType | TotalRegistrants | Action | Bonus |  | EventID | RegistrationGoal
EVNT-0037 | Annual Conference | 23 |  |  |  | EVNT-0037 | 20
EVNT-0012 | [NAME] | 66 |  |  |  | EVNT-0012 | 70
EVNT-0042 | Plant Tour | 27 |  |  |  | EVNT-0042 | 25
EVNT-0022 | Plant Tour | 38 |  |  |  | EVNT-0022 | 40
EVNT-0017 | [NAME] | 21 |  |  |  | EVNT-0017 | 20
EVNT-0032 | Survey/Study | 24 |  |  |  | EVNT-0032 | 25
 |  |  |  |  |  | Goal Met
 |  |  |  |  |  |  | 20 | 25 | 30 | 35 | 40
 |  |  |  |  |  | Annual Conference | 150 | 170 | 190 | 210 | 230
 |  |  |  |  |  | [NAME] | 140 | 160 | 180 | 200 | 220
 |  |  |  |  |  | Plant Tour | 160 | 180 | 200 | 220 | 240
 |  |  |  |  |  | Survey/Study | 120 | 140 | 160 | 180 | 200
 |  |  |  |  |  | Promote Event
 |  |  |  |  |  |  | 20 | 25 | 30 | 35 | 40
 |  |  |  |  |  | Annual Conference | 100 | 120 | 140 | 160 | 180
 |  |  |  |  |  | [NAME] | 90 | 110 | 130 | 150 | 170
 |  |  |  |  |  | Plant Tour | 110 | 130 | 150 | 170 | 190
 |  |  |  |  |  | Survey/Study | 70 | 90 | 110 | 130 | 150
Spreadsheet: hunter_shively__12746__EnovateDPR0125
Sheet: 5 Day Roll

ENRON CAPITAL AND TRADE RESOURCES
 |  | DO NOT TOUCH!! | ONLY RUN BEFORE YOU LINK ANY NEW ROLLS!!
Commodity | 5 Day Rolling Total | Current Day | Current Day-1 | Current Day-2 | Current Day-3 | Current Day-4
ENA Gas Trading
Short Term Gas |  |  | 35.50985630000257 | -64.77216996000307 | 320.1888979100012 | -68.1974740399979
 |  | 13 | 12 | 11 | 10 | 7 | 6
 |  | 17 | 84 | 12 | -54 | 19 | -53
Spreadsheet: 118940d1314107609-comparing-data-values-in-a-spreadsheet-and-transferring-a-row-of-data-copy-of-exemplar
Sheet: Sheet1

3536810431979790 |  |  |  |  |  | 3594240136794421 | G350Z | V2.3 | 2010-01-29 00:00:00
3536810431979790 |  |  |  |  |  | 3594240136794421 | G350Z | V2.4 | 2010-01-30 00:00:00
3536810431979790 |  |  |  |  |  | 3594240136794421 | G350Z | V2.5 | 2010-01-31 00:00:00
3536810431979790 |  |  |  |  |  | 3594240136794421 | G350Z | V2.6 | 2010-02-01 00:00:00
3536810431979790 |  |  |  |  |  | 3594240136794421 | G350Z | V2.7 | 2010-02-02 00:00:00
3536810431979800 |  |  |  |  |  | 3594240136794421 | G350Z | V2.8 | 2010-02-03 00:00:00
3536810431979800 |  |  |  |  |  | 3594240136794421 | G350Z | V2.9 | 2010-02-04 00:00:00
3536810431979800 |  |  |  |  |  | 3594240136794421 | G350Z | [NAME] | 2010-02-05 00:00:00
Spreadsheet: 100662d1298966781-conditional-formatting-with-multiple-rows-dummy_breathtest
Sheet: Sheet1

Breath Test Register
DATE | NAME | GUARD | READING | COMMENT
2010-08-06 00:00:00 | A Person | Guard 12 | PASS
2010-08-06 00:00:00 | Someone Else | Guard 14 | FAIL
2010-08-06 00:00:00 | [NAME] | Guard 2 | PASS
2010-08-06 00:00:00 | Mr Man | Guard 7 | FAIL
2010-08-06 00:00:00 | [NAME] | Guard 9 | FAIL
2010-08-06 00:00:00 | [NAME] | Guard 18 | PASS
2010-08-06 00:00:00 | T Ruckdriver | Guard 10 | PASS
2010-08-06 00:00:00 | Mr Man | Guard 19 | FAIL
Spreadsheet: 736455d1623660865-count-unique-values-that-meet-multiple-criteria-book1
Sheet: Sheet1

 |  | S. No | StaffID | Name | Category | In/Out/Leave
 |  | 1 | Nil | P1 | R | In
 |  | 2 | v81 | P2 | V | Out
 |  | 3 | v10 | P3 | V | In
 |  | 4 | s71 | P4 | S | In
 |  | 5 | b47 | P5 | B | Leave
 |  | 6 | b62 | P6 | B | Out
 |  | 7 | v10 | P3 | V | In
 |  | 8 | s71 | P4 | S | In
 |  | 9 | b23 | P7 | B | Leave
 |  | Required
 |  | Total V |  |  | 2 | (Solved earlier)
 |  | Total B |  |  | 3 | (Solved earlier)
 |  | Total S |  |  | 1 | (Solved earlier)
 |  | Total of In |  |  | 3 | not 5
 |  | Total Out |  |  | 2
 |  | Total Leave |  |  | 2
Spreadsheet: michelle_lokay__26703__imball0112
Sheet: Amarillo

Amarillo Natural Gas |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
contract 21534
 | poi 28786 |  | poi 56993 |  | poi 500170 |  | poi 10746 |  | poi 13247 |  | poi 500520 |  | poi 500171
 | Adobe [NAME] |  | [NAME] |  | ANG-Scott/Bandy II |  | [NAME] |  | [NAME] |  | [NAME] |  | ANG O Neal&Shadid
 | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | -3406 |  |  | -25 |  | -30
2 | -1974 |  |  | -25 |  | -30
3 | -1939 | -1900 |  | -25 |  | -30
4 | -1840 | -2104 |  | -25 |  | -30
5 | -1968 | -2104 |  | -25 |  | -30
6 | -1992 | -2104 |  | -25 |  | -30
7 | -1997 | -2104 |  | -25 |  | -30
8 | -2162 | -2104 | -3 | -25 |  | -30
9 | -2166 | -2104 |  | -25 |  | -30
10 | -2130 | -2104 | -7 | -25 |  | -30
11 | -2131 | -2104 |  | -25 |  | -30
12 | -2157 | -2104 |  | -25 |  | -30
13 | -2181 | -2104 |  | -25 |  | -30
14 | -2112 | -2104 |  | -25 |  | -30
15 | -2111 | -2104 |  | -25 |  | -30
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
index
2001-11-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 102894.9
2001-12-15 00:00:00
CBS Volume
 |  |  | 43028