tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: vkaminski__40922__CinergyPrices
Sheet: Monthly

Cinergy Prices (last day of the month)
TopRelation:Energy:Electricity:Cinergy:Pasha:E.CINERGY.INTO
CommonLow | CommonHigh | PKWeightedAvg
Date | Common Low | Common High | Weighted Average
1998-01-31 00:00:00 | 14.75 | 15.25 | 15.02999973297119
1998-02-28 00:00:00 | 14.75 | 15.25 | 15
1998-03-31 00:00:00 | 16.5 | 17.5 | 17.06999969482422
1998-04-30 00:00:00 | 21.75 | 23.75 | 22.75
1998-05-31 00:00:00 | 69.5 | 89.5 | 79.56999969482422
1998-06-30 00:00:00 | 54 | 159 | 106.5999984741211
1998-07-31 00:00:00 | 30.5 | 34 | 32.27999877929688
1998-08-31 00:00:00 | 36.5 | 42 | 39.22000122070312
1998-09-30 00:00:00 | 46.25 | 54.25 | 50.25
1998-10-31 00:00:00 | 17.75 | 20 | 18.86000061035156
1998-11-30 00:00:00 | 16.5 | 17.5 | 17.04999923706055
1998-12-31 00:00:00 | 17.5 | 18.75 | 18.13999938964844
1999-01-31 00:00:00 | 15.25 | 16.25 | 15.73999977111816
1999-02-28 00:00:00 | 16.25 | 17.25 | 16.77000045776367
1999-03-31 00:00:00 | 18 | 18.5 | 18.45999908447266
1999-04-30 00:00:00 | 25.5 | 29.5 | 26.20000076293945
1999-05-31 00:00:00 | 18.75 | 20 | 19.44000053405762
1999-06-30 00:00:00 | 23.75 | 26.5 | 25.23999977111816
1999-07-31 00:00:00 | 101.25 | 113.75 | 107.5
1999-08-31 00:00:00 | 22.25 | 26 | 24.65999984741211
1999-09-30 00:00:00 | 19.5 | 20.75 | 20.1299991607666
1999-10-31 00:00:00 | 23.5 | 24.5 | 23.97999954223633
1999-11-30 00:00:00 | 21.5 | 23.5 | 22.52000045776367
1999-12-31 00:00:00 | 14.5 | 15 | 14.78999996185303
2000-01-31 00:00:00 | 26.75 | 29 | 27.8700008392334
2000-02-29 00:00:00 | 19.75 | 20 | 19.8799991607666
2000-03-31 00:00:00 | 22.75 | 24.5 | 23.64999961853027
2000-04-30 00:00:00 | 23.5 | 24.5 | 23.98999977111816
2000-05-31 00:00:00 | 33.75 | 40.75 | 37.27999877929688
2000-06-30 00:00:00 | 18.5 | 21 | 19.80999946594238
2000-07-31 00:00:00 | 40.25 | 47.5 | 43.47000122070312
2000-08-31 00:00:00 | 59 | 66.5 | 62.72999954223633
2000-09-30 00:00:00 | 17.75 | 18.75 | 18.17000007629395
2000-10-31 00:00:00 | 34.75 | 35.75 | 35.2400016784668
2000-11-30 00:00:00 | 38 | 45.5 | 48.31000137329102
2000-12-31 00:00:00 | #N/A | #N/A | 50.5
2001-01-31 00:00:00 | #N/A | #N/A | 27.10000038146973
2001-02-28 00:00:00 | #N/A | #N/A | 41.20999908447266
Spreadsheet: 741263d1626940736-formula-to-look-into-sheet-named-here-and-extract-values-into-columns-in-sheet-named-output-extract-values-into-desired-columns-ans-2_1
Sheet: OUTPUT

 |  |  |  | Section I |  |  | Section II |  |  | Section III
S/N | Name + Unique # | Name | Sales # | Sales Code | Sales #-1 | Sales #-2 | Sales Code | Sales #-1 | Sales #-2 | Sales Code | Sales #-1 | Sales #-2 | NOTE
 |  |  |  |  |  |  |  |  |  |  |  |  | Further sections can be extended without change of formula
 |  |  |  |  |  |  |  |  |  | TNT | 1 | 1
 |  |  |  |  |  |  |  |  |  | TNT | 1 | 1
 |  |  |  |  |  |  |  |  |  | TNT | 1 | 1
 |  |  |  |  |  |  |  |  |  | TNT | 1 | 1
 |  |  |  |  |  |  |  |  |  | TNT | 1 | 1
 |  |  |  |  |  |  |  |  |  | TNT | 1 | 1
 |  |  |  |  |  |  |  |  |  | TNT | 1 | 1
Spreadsheet: 41277d1239770285-find-value-from-multiple-tables-inventory-bar-v8
Sheet: Beer

Date 1 |  |  | Date 2 |  |  | Date 3 |  |  | Date 4 |  |  | Date 5 |  |  | Date 6
35042 | [NAME] Lt | 40 | 35042 | [NAME] Lt | 81
35094 | [NAME] | 11 | 40000 | Amstel Lt | 20
35096 | 312 | 11 | 40021 | Stella | 12
40045 | Heineken | 6 | 35094 | [NAME] | 16
40021 | Stella | 5 | 40045 | Heineken | 11
40024 | Corona | 5 | 35097 | Fat Tire | 5
40000 | Amstel Lt | 2 | 40024 | Corona | 3
35099 | [NAME] | 1 | 35041 | [NAME] | 3
 |  |  | 40040 | Guinness | 1
 |  |  | 40019 | Hoegaarden | 1
 |  |  | 35098 | GI: Honkers Ale | 1
 |  |  | 35099 | [NAME] | 1
Spreadsheet: 126748d1319857166-formula-to-take-into-account-stock-levels-and-efficiency-level-test-trainsv2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | A to B | A to C | B to C
 |  |  |  |  |  |  |  |  |  |  | N Wagons full capacity | 24 | 18 | 18
 |  |  |  |  |  |  |  |  |  |  | N wagons half capacity or break down | 12 | 9 | 9
 |  |  |  |  |  |  |  |  |  |  | Wagon capacity | 5
 |  |  | Wagons |  |  | Stock (opening day)
 |  |  | Breakdown level |  | 1 |  |  |  |  |  | Stock | A | B | C
 |  |  | A to B | A to C | B to C | Stock A | Stock B | Stock C |  |  | [NAME] | 29800 | 6200 | 4000
 |  | 2011-01-01 00:00:00 | 0 | 18 | 18 | 30000 | 6210 | 3000 |  |  | Min | 28900 | 3000 | 3100
 |  | 2011-01-02 00:00:00 | 24 | 18 | 18 | 29910 | 6120 | 3180
 |  | 2011-01-03 00:00:00 | 24 | 18 | 18 | 29700 | 6150 | 3360
 |  | 2011-01-04 00:00:00 | 24 | 18 | 18 | 29490 | 6180 | 3540
 |  | 2011-01-05 00:00:00 | 0 | 18 | 18 | 29280 | 6210 | 3720
 |  | 2011-01-06 00:00:00 | 24 | 18 | 18 | 29190 | 6120 | 3900
 |  | 2011-01-07 00:00:00 | 24 | 0 | 0 | 28980 | 6150 | 4080
 |  | 2011-01-08 00:00:00 | 0 | 0 | 0 | 28860 | 6270 | 4080
 |  | 2011-01-09 00:00:00 | 0 | 0 | 0 | 28860 | 6270 | 4080
 |  | 2011-01-10 00:00:00 | 0 | 0 | 0 | 28860 | 6270 | 4080
Spreadsheet: 793162d1661344029-assign-rank-points-based-upon-highest-lowest-median-values-test-15-ans
Sheet: Sheet1

 |  | KPI's | Points
 | EMP | DAS | DAS | FORMULA
 | A | 10 | 3 |  | [NAME] in cell D4,D5,D6 to auto assign rank/points (3 or 1 or 0) based upon the value in cell C4,C5,C6 | Highest value=3, Lowest value=0, Mid value=1
 | B | 8 | 1
 | C | 6 | 0
 |  | If all 0 |  |  |  | If 2 cells same with high values but not with 0 |  |  |  | If 2 cells with same low values compared to 3rd cell value but not with 0
 |  | KPI's | Points |  |  | KPI's | Points |  |  | KPI's | Points
 | EMP | DAS | DAS |  | EMP | DAS | DAS |  | EMP | DAS | DAS
 | A | 0 | 0 |  | A | 1 | 1 |  | A | 4 | 3
 | B | 0 | 0 |  | B | 2 | 3 |  | B | 2 | 1
 | C | 0 | 0 |  | C | 2 | 3 |  | C | 2 | 1
 |  | If all 1 |  |  |  | If 2 cells same with values but with 0 |  |  |  | If 2 cells with 0
 |  | KPI's | Points |  |  | KPI's | Points |  |  | KPI's | Points
 | EMP | DAS | DAS |  | EMP | DAS | DAS |  | EMP | DAS | DAS
 | A | 1 | 3 |  | A | 0 | 0 |  | A | 1 | 3
 | B | 1 | 3 |  | B | 2 | 3 |  | B | 0 | 0
 | C | 1 | 3 |  | C | 2 | 3 |  | C | 0 | 0
Spreadsheet: 715258d1611644221-link-dropdown-in-c6-c9-to-dropdown-in-column-b2-main-dropdown-dropdown_linkcell_sample
Sheet: Names

Last Name | First Name | Name |  | Let | Name | L1 | L2 | L3 | Name1 |  | Okay | Out |  | [NAME]
Abdelnour | Habig |  |  |  | Abdelnour, [NAME] |  |  |  |  |  | Okay
Abdelrahman | Habiger |  |  |  | Abdelrahman, Habiger |  |  |  |  |  | [NAME]
Macchi | Hable |  |  |  | Macchi, Hable
Macchia | Haby |  |  |  | Macchia, [NAME]
Macchio | Hach |  |  |  | Macchio, Hach
Macchione | Hache |  |  |  | Macchione, Hache
Abdou | Hachey |  |  |  | Abdou, Hachey
Abdul | Faga |  |  |  | [NAME], [NAME]
Abdulla | Fagan |  |  |  | Abdulla, [NAME]
[NAME] | Fagen |  |  |  | [NAME], [NAME]
[NAME] | Fager |  |  |  | [NAME], Fager
[NAME] | Yampolsky |  |  |  | [NAME], [NAME]
Abed | Yan |  |  |  | Abed, [NAME]
Abee | Yanagi |  |  |  | Abee, Yanagi
[NAME] | Yanak |  |  |  | [NAME], [NAME]
Sabio | Faggart |  |  |  | Sabio, Faggart
[NAME] | Fagin |  |  |  | Sabir, Fagin
Sabiston | Yanke |  |  |  | Sabiston, Yanke
Sablan | Yankee |  |  |  | Sablan, Yankee
Sable | Yankey |  |  |  | Sable, Yankey
Abeles | [NAME] |  |  |  | Abeles, [NAME]
Abell | Fago |  |  |  | Abell, Fago
Abella | Faaborg |  |  |  | Abella, Faaborg
Spreadsheet: kay_mann__19196__Purchase Power Schedule
Sheet: Schedule of Purchase Power

Resource | Amount MW | Hour Limitation | Reliability | Term | Delivery Point | Scheduling | Minimum Delivery
SEPA | 11 | 1500 |  | None | Into Entergy | 1.  Submit annual schedule by June 20 2.  Monthly breakdown (by week) 10 days prior to beginning of month 3.  Weekly breakdown (by hour) by preceding Wednesday
Cajun | 7 | NA | Firm System Capacity (as firm as native load) | 2010-05-31 00:00:00 | Into Entergy | Week ahead by COB Thursday Hourly changes with approval | At least 25% of contract capacity
EPI-Isis | 7 | NA | Unit Contingent, Transmission Contingent | 2010-05-31 00:00:00 | Into Entergy | 16 hours in advance
EPI-Ritchie | 1 | NA | Unit Contingent, Transmission Contingent | 2010-05-31 00:00:00 | Into Entergy | 16 hours in advance
Spreadsheet: 98967d1297775730-circular-reference-and-its-solution-excelforum-help
Sheet: Sheet1 (with data)

T1 | T2 | Demand | Capacity | [NAME] (demand - capacity) | Queued vehicles
0 | 1 | 350 | 3000 | 350 | 1450350
1 | 2 | 250 | 3000 | 250 | 1450600
2 | 3 | 200 | 3000 | 200 | 1450800
3 | 4 | 300 | 3000 | 300 | 1451100
4 | 5 | 900 | 3000 | 900 | 1452000
5 | 6 | 2200 | 3000 | 2200 | 1454200
6 | 7 | 3100 | 3000 | 3100 | 1457300
7 | 8 | 3600 | 3000 | 3600 | 1460900
8 | 9 | 2800 | 3000 | 2800 | 1463700
9 | 10 | 2500 | 3000 | 2500 | 1466200
10 | 11 | 2400 | 3000 | 2400 | 1468600
11 | 12 | 2550 | 3000 | 2550 | 1471150
12 | 13 | 2650 | 3000 | 2650 | 1473800
13 | 14 | 2750 | 3000 | 2750 | 1476550
14 | 15 | 2800 | 3000 | 2800 | 1479350
15 | 16 | 3200 | 3000 | 3200 | 1482550
16 | 17 | 3500 | 3000 | 3500 | 1486050
17 | 18 | 3200 | 3000 | 3200 | 1489250
18 | 19 | 2950 | 3000 | 2950 | 1492200
19 | 20 | 2450 | 3000 | 2450 | 1494650
20 | 21 | 2000 | 3000 | 2000 | 1496650
21 | 22 | 1500 | 3000 | 1500 | 1498150
22 | 23 | 1050 | 3000 | 1050 | 1499200
23 | 24 | 800 | 3000 | 800 | 1500000
Spreadsheet: 836155d1689132862-assistance-with-countifs-for-two-values-accident-review-spreadsheet-v2
Sheet: 2024

Sunshine Accident Review
 | drop down list options |  | drop down list options |  |  |  |  |  |  | FREQUENCY OF TYPE
DATE OF ACCIDENT | ACCIDENT TYPE | ACCIDENT LOCATION/ADDRESS | ACCIDENT SUBURB | FURTHER NOTES | ACTIONS TAKEN FROM FINDINGS |  | FINDINGS | TOTAL ACCIDENT COUNT | D.A.F (MOVING) | D.A.F (ST-NARY) | THIRD PARTY AT FAULT | CONTRIB | NON ACCIDENT INCIDENT | OTHER
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Burnside
 |  |  |  |  |  |  | Cairnlea
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Charter - Long Distance
 |  |  |  |  |  |  | Charter - Metro
 |  |  |  |  |  |  | Charter - Rural
 |  |  |  |  |  |  | Charter - Souther Cross Station
 |  |  |  |  |  |  | Deanside
 |  |  |  |  |  |  | Delahey
 |  |  |  |  |  |  | Footscray
 |  |  |  |  |  |  | Fraser Rise
 |  |  |  |  |  |  | Kealba
 |  |  |  |  |  |  | Keilor
 |  |  |  |  |  |  | Keilor East
 |  |  |  |  |  |  | Kingsville
 |  |  |  |  |  |  | Maidstone
 |  |  |  |  |  |  | Maribyrnong
 |  |  |  |  |  |  | Seddon
 |  |  |  |  |  |  | St Albans
 |  |  |  |  |  |  | Sunshine
 |  |  |  |  |  |  | Sydenham
 |  |  |  |  |  |  | Taylors Hill
 |  |  |  |  |  |  | Taylors Lakes
 |  |  |  |  |  |  | West Footscray
 |  |  |  |  |  |  | Yarraville
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Albanvale
 |  |  |  |  |  |  | Deer Park
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Braybrook
Spreadsheet: mary_fischer__25627__1292
Sheet: E8.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY #  1292
COMPANY NAME    Marlin Fair Value Co.
ANALYSIS OF OTHER DEFERRED CHARGES
FOR THE 3 MONTHS ENDED 3-31-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  | 12-31-2000 Balance |  |  |  | Charged to |  | Transfer / Reclasses
[NAME] |  | DR. (CR.) |  | Cash Pd / (Rec'd) |  | Income Statement |  | Amount |  | Hyperion Acct. # |  | DR. (CR.)
 |  | BEGINNING BALANCE |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | to / from |  | ENDING BALANCE |  | COMMENTS
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Work in Progress:
 |  | 0
Total  (Hyperion Line 0343)
Asset/Expense Accts:  DR/(CR)
Other Deferred Charges:
 |  | 0
Total (Hyperion line 360)
Asset/Expense Accts:  DR/(CR)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 96843d1296120473-vlookup-help-needed-order-book
Sheet: Grassmere, Rainow

PAYMENT BREAKDOWN |  |  |  | JOB DURATION
WEEK # | WEEK ENDING | AMOUNT |  | START | # OF WEEKS | END
 |  | 10000 |  | 2011-01-18 00:00:00 | 10
 |  | 1800
 |  | 1800
 |  | 1800 |  | TOTAL JOB VALUE
 |  | 1800
 |  | 1800
 |  | 1800 |  | DATA INTEGRITY
 |  | 1800 |  | Job End
 |  | 1800 |  | Payments
 |  | 5000
Spreadsheet: chris_germany__1684__200004strg
Sheet: Activity

[NAME] worksheet
CES Storage Allotment on TCO for COH Choice 2000/2001
 | FSS-SCQ | 6295922
 | SST-MDQ-W | 113053
 | SST-MDQ-S | 56527
 |  |  | S | W
 | COH-03 PORTSMOUTH | 22-15 | 927 | 1854
 | COH-07 TOLEDO | 23-1 | 15734 | 31467
 | COH-07 [NAME] | 23-3 | 2364 | 4727
 | COH-07 [NAME] | 23-4 | 1834 | 3667
 | COH-07 COLUMBUS | 23-5 | 14701 | 29402
 | COH-07 DAYTON | 23-6 | 2502 | 5004
 | COH-07 MANSFIELD | 23-8 | 2680 | 5359
 | COH-07 OHIO MISC | 23-9 | 3261 | 6521
 | COH-05 PARMA | 23N-2 | 7673 | 15345
 | COH-05 SANDUSKY | 23N-7 | 3096 | 6192
 | COH-08 PITTSBURGH | 24-35 | 1724 | 3447
 | COH-08 NEWCASTLE | 24-39 | 34 | 68
Actual Storage MDQ Effective 4/1/2000
 | FSS-SCQ | 6050607
 | SST-MDQ-S | 54327
 | [NAME] 3/31/2000 | 170981
 | [NAME]
 |  |  |  |  | [NAME] |  |  | Actual |  | Proxy |  | ENA
 | [NAME] | Inject % |  | Balance | Monthly | Daily |  | Balance |  | Balance |  | [NAME]
 | Mar 31,2000 |  |  |  |  |  |  |  |  | 0
 | 2000-04-01 00:00:00 | 0.13 |  | 170981
 | 2000-05-01 00:00:00 | 0.18
 | 2000-06-01 00:00:00 | 0.18
 | 2000-07-01 00:00:00 | 0.18
 | 2000-08-01 00:00:00 | 0.18
 | 2000-09-01 00:00:00 | 0.13
 | 2000-10-01 00:00:00 | 0.02
 | 2000-11-01 00:00:00 | 0
 | 2000-12-01 00:00:00 | 0
Spreadsheet: 880060d1727699677-detect-employee-actual-entry-data-and-exit-date-book6-1
Sheet: Sheet1

Employee Name | Entry Date | Exit Date | Role | Team | Actual Entry Date | Actualy Exit Date
A | 2021-10-01 00:00:00 | 2021-11-30 00:00:00 | Engineer | Data Science
A | 2021-06-01 00:00:00 | 2021-09-30 00:00:00 | Engineer | Engineering 1
B | 2022-10-01 00:00:00 |  | Manager | Engineering 1
B | 2021-10-15 00:00:00 | 2022-09-30 00:00:00 | Technical Architect | Engineering 1
B | 2021-03-01 00:00:00 | 2021-10-14 00:00:00 | Engineer | Engineering 1
C | 2024-08-01 00:00:00 | 2027-07-31 00:00:00 | Trainee | Apprenticeship
D | 2022-05-23 00:00:00 | 2023-04-30 00:00:00 | Product Manager | Supply Chain
D | 2020-12-01 00:00:00 | 2022-05-22 00:00:00 | Product / Service Owner | Supply Chain
E | 2023-10-01 00:00:00 |  | Engineer | Engineering 2
E | 2020-12-01 00:00:00 | 2022-05-31 00:00:00 | Engineer | Engineering 2
Spreadsheet: 811336d1672416028-matching-values-2-dynamic-arrays-match-2-arrays
Sheet: Feuil1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | B | C | D | E
wanted value | expected result |  |  |  | title_B_title | title_C_title | title_D_title | title_E_title |  |  |  |  |  |  |  |  |  |  |  | PQYCF | XEODT | AJBAS | PKLSQ | LYAWR
A,C | PQYCF,AJBAS |  |  | PQYCF | XEODT | AJBAS | PKLSQ | LYAWR
A | PQYCF | PQYCF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | title_B_title | title_C_title | title_D_title | title_E_title
E,B,A | LYAWR,XEODT,PQYCF | PQYCF,XEODT,LYAWR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XEODT | AJBAS | PKLSQ | LYAWR
Spreadsheet: 3f7b1705-71d1-450d-9d6a-691711167f4a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | LỊCH CÔNG TÁC KHOA | Unnamed: 4 | Unnamed: 5
 |  |  | TUẦN9 (31/10 -06/11/2011)
Thứ, ngày | Giờ | Nội dung công việc | Cán bộ  chủ trì | Cán bộ cùng thực hiện/ cùng tham dự | [NAME] điểm
Thứ Hai 31/10 | 8h00 | Họp giao ban [NAME] | T.Hưng | CB - GV - NV Khoa | VPK
 | 9h30 | Họp Chi bộ 2 |  | [NAME] viên chi bộ 2 | PH1
 | 10h00 | Triển khai đăng kí, bốc thăm lịch thi đấu 3 nội dung [NAME] | T. Dũng |  | PH2
 | 10h30 | Họp chuẩn bị [NAME] bế giảng và trao bằng tốt [NAME] | Ô. T.X.Hùng | T. Nam, [NAME] | PH1
[NAME] | 8h30 | [NAME] ban tháng 11/2011 | [NAME] | T. Hưng, T. Nam | PH1
Thứ Tư 02/11 | 8h30 | Tập huấn các thư ký [NAME] về công tác quản lý đào tạo | [NAME] | [NAME] | PH1
 | 13h30 | Tập huấn Cán bộ lớp K2011 Khoa MT & CNSH | [NAME] | T. Nam, T. Dũng, [NAME] | HT1 L6
[NAME]
Thứ Sáu 04/11
Thứ Bảy 05/11
 | 13h30 | Lễ bế giảng và trao bằng tốt [NAME] MT & CNSH, CNTT | [NAME] | T. Hưng, T. Nam, thư ký [NAME] | HT1 L6
[NAME] | 8h00 | [NAME] mạc Hội thao sv toàn trường | [NAME] | T. Nam, T. Dũng | Sân trường
Ghi chú: |  |  |  | TP. HCM, ngày 29 tháng 10 năm 2011
 |  |  |  | [NAME]
Spreadsheet: 794436d1662045493-proper-formula-for-grade-department-shift-test-environment
Sheet: test environment

Employee | ?Pass/Fail | Department | Shift |  | Assembly | Pass | Fail
Employee1 | Fail | Assembly | 1
Employee2 | Fail | Assembly | 1 |  | Molding | Pass | Fail
Employee3 | Fail | Assembly | 1
Employee5 | Fail | Assembly | 1
Employee6 | Fail | Assembly | 1 |  |  |  | Pass | Fail |  |  | Pass | Fail
Employee16 | Fail | Assembly | 1 |  | Assembly | 1st | 1 | 8 | Molding | 1st | 0 | 1
Employee22 | Fail | Assembly | 1 |  |  | 2nd | 7 | 4 |  | 2nd | 1 | 1
Employee25 | Fail | Assembly | 1 |  |  | 3rd | 1 | 1 |  | 3rd | 1 | 0
Employee8 | Fail | Assembly | 2
Employee9 | Fail | Assembly | 2
Employee15 | Fail | Assembly | 2
Employee11 | Fail | Assembly | 3
Employee20 | Fail | Assembly | 3
Employee4 | Fail | Molding | 1
Employee7 | Fail | Molding | 2
Employee19 | Pass | Assembly | 1
Employee10 | Pass | Assembly | 2
Employee18 | Pass | Assembly | 2
Employee24 | Pass | Assembly | 2
Employee13 | Pass | Assembly | 3
Employee14 | Pass | Assembly | 3
Employee17 | Pass | Assembly | 3
Employee23 | Pass | Assembly | 3
Employee26 | Pass | Assembly | 3
Employee21 | Pass | Molding | 2
Employee12 | Pass | Molding | 3
Spreadsheet: 220793d1363267881-finding-values-in-a-2d-array-index-formula
Sheet: Sheet1

Cities | Sum | A1 | C6 | D2 | J4 | J12
Detroit | 423 | 230 | 86 | 5 | 33 | 69
NYC | 341 | 77 | 38 | 54 | 163 | 9
Chicago | 201 | 41 | 29 | 75 | 19 | 37
 |  | Client
 |  | 1 | 2 | 3 |  |  | Row match
Detroit | 423
NYC | 341
Chicago | 201
Spreadsheet: 272142d1382224395-finding-min-max-for-dynamic-date-range-book1
Sheet: Sheet1

Week End | 2013-08-02 00:00:00 | 2013-08-09 00:00:00 | 2013-08-16 00:00:00 | 2013-08-23 00:00:00 | 2013-08-30 00:00:00 | 2013-09-06 00:00:00 | 2013-09-13 00:00:00 | 2013-09-20 00:00:00 | 2013-09-27 00:00:00 | 2013-10-04 00:00:00 | 2013-10-11 00:00:00 | 2013-10-18 00:00:00 | 2013-10-25 00:00:00 | 2013-11-01 00:00:00 | 2013-11-08 00:00:00 | 2013-11-15 00:00:00
Period | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 4 | 4
 | MIN | MAX
Period | Start Date | End Date
1
2
3
4
Spreadsheet: 203559d1357162212-comparing-names-and-dates-in-separate-workbooks-example-for-help
Sheet: Master List

First Name: | Last Name: | [NAME]: | [NAME] | Hyatt Departure | [NAME] | Hyatt Departure 2
[NAME] | Jones | [EMAIL] | 2013-01-09 00:00:00 | 2013-01-11 00:00:00 | 2013-01-15 00:00:00 | 2013-01-16 00:00:00
[NAME] | Aguilar | [EMAIL] |  |  | 2013-01-09 00:00:00 | 2013-01-10 00:00:00
[NAME] | [NAME] | [EMAIL] |  |  | 2013-01-15 00:00:00 | 2013-01-16 00:00:00
Spreadsheet: 111141d1307605120-copying-and-separating-out-delimited-fields-copying-and-separating-out-delimited-fields
Sheet: Result

Total Records | 8
Field1 | Field2 | Field3 | Field4
PART X | DEVICE | 2009-02-26 00:00:00 | 34228
PART X | DEVICE | 2009-02-26 00:00:00 | 39598
PART X | DEVICE | 2009-02-26 00:00:00 | 62038
PART X | DEVICE | 2009-02-26 00:00:00 | 41379
PART X | DEVICE | 2009-02-26 00:00:00 | 42628
PART Y | DEVICE2 | 2011-03-10 00:00:00 | 34000
PART Y | DEVICE2 | 2011-03-10 00:00:00 | 31223
PART Z | [NAME] | 2011-03-11 00:00:00 | 34111
Spreadsheet: 686173d1594399035-vba-how-to-copy-column-range-to-another-column-using-formula-in-1-cell-book1
Sheet: Sheet1

COL_1 |  |  |  |  | COL_2
1 |  |  |  |  | 1
3 |  |  |  |  | 3
56 |  |  |  |  | 56
88 |  |  |  |  | 88
5 |  |  |  |  | 5
34 |  |  |  |  | 34
3 |  |  |  |  | 3
89 |  |  |  |  | 89
5 |  |  |  |  | 5
34 |  |  |  |  | 34
3 |  |  |  |  | 3
35 |  |  |  |  | 35
6 |  |  |  |  | 6
7 |  |  |  |  | 7
Spreadsheet: 677379d1589322840-looking-for-a-way-to-select-winners-based-on-location-example-winners-problem
Sheet: Before

name | points | location
[NAME] | 450 | Washington
[NAME] | 124 | Washington
[NAME] | 96 | Washington
[NAME] | 483 | Washington
[NAME] | 222 | Washington
[NAME] | 394 | New York
[NAME] | 182 | New York
[NAME] | 44 | New York
[NAME] | 203 | San Francisco
[NAME] | 112 | San Francisco
Adam | 456 | San Francisco
[NAME] | 342 | San Francisco
[NAME] | 231 | San Francisco
[NAME] | 505 | Kansas
Jordan | 100 | Kansas
[NAME] | 87 | Kansas
[NAME] | 42 | Kansas
[NAME] | 310 | Kansas
Spreadsheet: 693565d1599037579-countif-within-date-range-with-multiple-lookups-countif-multiple-lookups-between-date-range
Sheet: Summaries

 |  |  |  | Breaches
 |  |  |  | Date Range
 |  |  |  | To | 2020-08-31 00:00:00
 |  |  |  | From
 |  |  |  | Months | -12
 |  |  |  |  | Name | Number of breaches
 |  | Lookup
 |  | J |  | Exec | [NAME]
 |  | S |  |  | [NAME]
 |  | W |  |  | Will
 |  | D |  |  | [NAME]
 |  | T |  |  | [NAME]
 |  | K |  |  | [NAME]
 |  | N |  | Mngmt | Nick
 |  | A |  |  | Adrian
 |  | C |  |  | [NAME]
 |  | JU |  |  | Julian
 |  | A |  |  | [NAME]
 |  | N |  |  | [NAME]
 |  | H |  |  | Hans
Spreadsheet: 888356d1738848009-formula-to-list-references-vertically-sheet1
Sheet: Sheet1

References | Quantity | Value
FR23 | 1 | 1000 |  |  | Fruits | Sports | Clothes
SP1.34 | 1 | 500 |  |  | FR | SP | CL
CL.AAA | 23 | 200
D.23 | 4 | 300 |  |  | FR23 | SP1.34 | CL.AAA
SP1.35 | 1 | 400 |  |  |  | SP1.35
SP5.44 | 1 | 300 |  |  |  | SP5.44
Spreadsheet: 11c5e348-fa4f-4322-8deb-80b9693a858a
Sheet: BookFlix

Scholastic BookFlix 2014
 | Total Sessions | Books Viewed | Web Links Used
July | 216 | 722 | 49
August | 533 | 1577 | 47
September | 2348 | 6528 | 45
October | 2330 | 5229 | 36
November | 4277 | 13203 | 119
December
Notes:
Live to Public on July 15, 2014.
Web Links = each book pair has a web links section of sites put together by bookflix on the topic.
Spreadsheet: 693259d1598886665-if-statement-with-multi-criteria-statement-inside-a-data-validation-list-stock-inventory-control-sample-dharvey1978-
Sheet: Sheet 4

 | LOCATIONS
 | VENDOR
 | DIVISION | [NAME] |  | Count
 | Division 1 | Location 1
 | Division 1 | Location 2
 | Division 1 | Location 3
 | Division 1 | Location 4
 | Division 1 | Location 5
 | Division 1 | Location 6
 | Division 2 | Location 1
 | Division 2 | Location 2
 | Division 2 | Location 3
 | Division 2 | Location 4
 | Division 2 | Location 5 |  | DIVISION | No: | Location
 | Division 2 | Location 6 |  | Division 1 | 1 | Location 1
 | Division 2 | Location 7 |  | Division 1 | 2 | Location 2
 |  |  |  | Division 1 | 3 | Location 3
 |  |  |  | Division 1 | 4 | Location 4
 |  |  |  | Division 1 | 5 | Location 5
 |  |  |  | Division 1 | 6 | Location 6
 |  |  |  | Division 2 | 7 | Location 1
 |  |  |  | Division 2 | 8 | Location 2
 |  |  |  | Division 2 | 9 | Location 3
 |  |  |  | Division 2 | 10 | Location 4
 |  |  |  | Division 2 | 11 | Location 5
 |  |  |  | Division 2 | 12 | Location 6
 |  |  |  | Division 2 | 13 | Location 7
Spreadsheet: 734840d1622541808-matching-name-to-location-book5-1-ans
Sheet: System

Full Name | First Name | Middle Name | Last Name | Site | Subject | Maths | Technical drawing | accounts | IT | Art | Geography | [NAME] | [NAME]
Abdul
Ceasar
[NAME]
Moomba
[NAME]
Lilato
Mwansa
Ndanji
[NAME]
Mwamba
Kekzo
Matiya
Spreadsheet: 74314d1274860993-total-by-job-type-and-date-copy-of-earnings-1
Sheet: Summary Monthly

Monthly earnings | Total | Totl Cash | Total Invoice | Totl Advertising | [NAME] | Totl Fashion | Totl Film | Total HC in | Total HC out | Ttl Internet | Ttl Print | Totl Theatre | Total TV | Total Video | Total Tax owed
2008-07-01 00:00:00 | #N/A
2008-08-01 00:00:00
2008-09-01 00:00:00
2008-10-01 00:00:00
2008-11-01 00:00:00
2008-12-01 00:00:00
2009-01-01 00:00:00
2009-02-01 00:00:00
2009-03-01 00:00:00
2009-04-01 00:00:00
2009-05-01 00:00:00
2009-06-01 00:00:00
2009-07-01 00:00:00
2009-08-01 00:00:00
2009-09-01 00:00:00
2009-10-01 00:00:00
2009-11-01 00:00:00
2009-12-01 00:00:00
2010-01-01 00:00:00
2010-02-01 00:00:00
2010-03-01 00:00:00
2010-04-01 00:00:00
2010-05-01 00:00:00