tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: michael_maggi__26462__NYMEXWEEKLY
Sheet: hu

Week Ending: | 2001-10-12 00:00:00
 | Futures Settlement Prices
 | UNLEADED GASOLINE |  |  |  |  | Contract Symbol:  [NAME]
 | Contract | Monday | Tuesday | Wednesday | Thursday | Friday | Open
 | Month | 2001-10-08 00:00:00 | 2001-10-09 00:00:00 | 2001-10-10 00:00:00 | 2001-10-11 00:00:00 | 2001-10-12 00:00:00 | Interest
 | 2001-11-01 00:00:00 | 0.6147 | 0.6137 | 0.6137 | 0.6273 | 0.601 | 28062
 | 2001-12-01 00:00:00 | 0.6176 | 0.6179 | 0.6194 | 0.6351 | 0.6091 | 19638
 | 2002-01-01 00:00:00 | 0.6253 | 0.6259 | 0.628 | 0.6426 | 0.6181 | 10726
 | 2002-02-01 00:00:00 | 0.6343 | 0.6354 | 0.6375 | 0.6511 | 0.6276 | 5570
 | 2002-03-01 00:00:00 | 0.6443 | 0.6459 | 0.6485 | 0.6616 | 0.6386 | 7875
 | 2002-04-01 00:00:00 | 0.7078 | 0.7094 | 0.712 | 0.7221 | 0.7011 | 9691
 | 2002-05-01 00:00:00 | 0.7128 | 0.7144 | 0.717 | 0.7271 | 0.7061 | 7726
 | 2002-06-01 00:00:00 | 0.7103 | 0.7119 | 0.715 | 0.7246 | 0.7036 | 5190
 | Total Weekly Volume
 |  |  | 132384 |  | Total Open Interest |  | 100696
 |  |  |  | Weekly volume and open interest reflects all traded months.
 | Historical Volatility-Spot Month Futures
 |  |  |  | Unleaded Gas
 | 5 Day Hist. Vol. |  |  | 0.4357
 | 20 Day Hist. Vol. |  |  | 0.6225
 | Implied Volatility-Options |  |  | Unleaded Gas
 | At the Money Call & Put |  |  | 0.4652
Spreadsheet: 776042d1649452946-spill-filter-formula-upwards-book1
Sheet: Sheet1

 |  | CURRENT FORMAT |  |  |  |  |  |  |  | PREFERRED [NAME]
 |  | Shovel |  |  |  |  |  |  |  | Shovel
 |  | 4100C BOSS | 6020B | EX2500 | EX8000 |  |  |  |  | 4100C BOSS | 6020B | EX2500 | EX8000
 |  | F1602 |  |  | F1402
 |  | F1603 |  |  | F1403
 |  | F1604
 |  | F1605
 |  | F1606
 |  | F1607
 |  |  |  |  |  |  |  |  |  | F1601
 |  |  |  |  |  |  |  |  |  | F1602
 |  |  |  |  |  |  |  |  |  | F1603
 |  |  |  |  |  |  |  |  |  | F1604
 |  |  |  |  |  |  |  |  |  | F1605 |  |  | F1401
 |  |  |  |  |  |  |  |  |  | F1606 |  |  | F1402
 |  |  |  |  |  |  |  |  |  | F1607 | R0248 | F1302 | F1403
Spreadsheet: jeff_dasovich__14108__Appdx B 3rd Qtr 2000 Report win 95
Sheet: Check Data

Pipeline Imbalance = Total Imbalance - Customer Imbalance
Total Imbalance = Change in Inventory - Pipeline Storage Balancing
Pipeline Storage Balancing = Physical Storage - Scheduled Storage
Pipeline Imbalance = (Change in Inventory - Pipeline Storage Balancing) - Customer Imbalance
Customer Imbalance = Core (supply - determined usage) + EG + Industrial
Date | Chage in Inventory | Pipeline Storage Balancing | Customer Imbalance | Pipeline Imbalance
Spreadsheet: 25ed47dc-389e-416c-995f-ef35e8d7bfea
Sheet: EPR 1X PQY

Unaudited Supplemental Data
Reconciliations of GAAP to Non-GAAP Adjusted Measures
(In millions, except EPS)
Fourth Quarter Ended September 30, 2011
 |  |  |  |  | Continuing Operations
 | Revenue | Cost of  Revenues | Operating Expenses | Operating Income | Net Earnings (a) | Diluted EPS
GAAP measures | 539.8 | 242 | 182 | 115.7999999999999 | 59.99999999999989 | 0.2
% of revenue |  |  | 0.3371619118191923 | 0.2145238977399035
IP Usage settlements | -2 | -6.8 | 0 | 4.8 | 3 | 0.01
Impairment | 0 | 0 | -15.8 | 15.8 | 10 | 0.03
Total non-GAAP adjustments | -2 | -6.8 | -15.8 | 20.6 | 13 | 0.04
Adjusted measures | 537.8 | 235.2 | 166.2 | 136.3999999999999 | 72.99999999999989 | 0.24
% of revenue |  |  | 0.3078918117821415 | 0.2526861800666912
Year Ended September 30, 2011
 |  |  |  |  | Continuing Operations
 | Revenue | Cost of  Revenues | Operating Expenses | Operating Income | Net Earnings (a) | Diluted EPS
GAAP measures | 1957 | 818.6 | 633.5 | 504.8999999999999 | 292.2999999999998 | 0.97
% of revenue |  |  | 0.3237097598364844 | 0.2579969340827797
IP Usage settlements | -2 | -6.8 | 0 | 4.8 | 3 | 0.01
Impairment | 0 | 0 | -15.8 | 15.8 | 10 | 0.03
Investment gain | 0 | 0 | 0 | 0 | -4.3 | -0.01
Certain discrete tax items (benefits) | 0 | 0 | 0 | 0 | -22.1 | -0.07
Total non-GAAP adjustments | -2 | -6.8 | -15.8 | 20.6 | -13.4 | -0.04000000000000001
Adjusted measures | 1955 | 811.8000000000001 | 617.7 | 525.4999999999999 | 278.8999999999999 | 0.9299999999999999
% of revenue |  |  | 0.3156361778231988 | 0.2685232498722534
(a) Adjustments tax effected at 36%
Spreadsheet: richard_shapiro__32191__ees-headcount
Sheet: Sheet1

Enron Government Affairs - The Americas Cost Center 103885 - Kingerski
2001-2003 OPERATING & STRATEGIC PLAN
Headcount Summary
 |  |  |  |  |  | Estimated |  | Year End Plan
 |  |  |  |  |  | 12/31/00 |  | 2001 |  | 2002 |  | 2003
Domestic Employees
 | Full Time |  |  |  |  | 10 |  | 10 |  | 10 |  | 10
 | Part Time
 | Temporary
 | VOE / Student Learners
 | Open Positions
 |  | Total Employees
 | 3rd Party Contract
 | Total
International Employees
 | Full Time
 | Part Time
 | Temporary
 | VOE / Student Learners
 | Open Positions
 |  | Total Employees
 | 3rd Party Contract
 | Total
Total Domestic & International
 | Full Time
 | Part Time
 | Temporary
 | VOE / Student Learners
 | Open Positions
 |  | Total Employees (1)
 | 3rd Party Contract (2)
 | Total  *
Location of Total Employees (1)
 | Domestic
 |  | 1400 Smith |  |  |  | 7 |  | 8 |  | 8 |  | 8
 |  | [NAME]
 |  | Omaha
 |  | Other |  |  |  | 2 |  | 2 |  | 2 |  | 2
 | Expatriates
 | International
 | Total
Location of 3rd Party Contractors (2)
 | Domestic
 |  | 1400 Smith
 |  | [NAME]
 |  | Omaha
 |  | Other
 | Expatriates
 | International
 | Total
Total Employees by Location *
 | * Totals should tie.
Spreadsheet: 3872f249-8280-480d-8cd2-b82c50cf8e47
Sheet: Sheet1

City Officials Statements | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
For Quarter Ending 3/31/08
(As of 6/11/08)
Name | Title | Personal Benefits Reported | City Benefits Reported
Adams, Sam | City Commissioner | 170
Ames, [NAME] | At-will Staff for Comm. Adams
[NAME], [NAME] | At-will Staff for Comm. Adams
Birge, [NAME] | At-will Staff for Comm. Adams |  | 150
Blackmer, [NAME] | City Auditor
Hanson, [NAME] | Portland Planning Commission Member
Leonard, [NAME] | City Commissioner
[NAME], [NAME] | At-will Staff for Comm. Adams
Lim, [NAME] | At-will Staff for Comm. Adams | 70
Lowthian, Amanda | At-will Staff for Mayor [NAME] | 25
Marriott, [NAME] | Director of Bureau of Environmental Services
Oppenheim, [NAME] | At-will Staff for Comm. Adams
Potter, [NAME] | Mayor | 557 | Yes, Values Not Given
Saltzman, [NAME] | City Commissioner
[NAME], [NAME] | Director of Bureau of Development Services
Schneider, Kimberly | At-will Staff for Comm. Adams
[NAME], [NAME] | Director of Bureau of Police | 311.5
[NAME], [NAME] | City Commissioner
Spreadsheet: 153226d1335808828-making-a-schedule-with-auto-time-format-and-adding-total-hours-se-schedule
Sheet: mar 5

 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 | 2012-03-05 00:00:00 | 2012-03-06 00:00:00 | 2012-03-07 00:00:00 | 2012-03-08 00:00:00 | 2012-03-09 00:00:00 | 2012-03-10 00:00:00
[NAME] | off | 8:30-5:30 | 8:00-5:00 | 9:00-5:00 | 8:30-5:30 | 9:15-5:15
 |  | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 11:30-12:30 | 38
[NAME] | 8:30-5:30 | 9:30-5:30 | off | 9:30-5:30 | 8:30-5:30 | 9:15-5:15
 | 2:00-3:00 | 2:00-3:00 |  | 2:00-3:00 | 2:00-3:00 | n/l | 38
Ray | 8:00-5:00 | 8:00-5:00 | 8:00-4:00 | 7:00-4:00 | off | 9:00-5:00
 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 |  | 12:30-1:30 | 38
Mark | 8:30-5:30 | 8:00-4:00 | 8:30-5:30 | 8:30-5:30 | 8:00-4:00
 | 1:00-2:00 | 1:00-2:00 | 1:00-2:00 | 1:00-2:00 | 1:00-2:00 |  | 38
[NAME] | 9:30-5:30 | 8:00-5:00 | 8:30-5:30 | 7:00-4:00-HOMER | 9:30-5:30-counter
ctr 12-2 | 11:00-12:00 | 11:00-12:00 | 11:00-12:00 | 12:00-1:00 | 11:00-12:00 |  | 38
Kat |  |  | 8:00-5:00 |  |  | 9:15-5:15
 |  |  | 12:00-1:00 |  |  | 11:30-12:30
 |  |  | 12:00-1:00 |  |  | 12:00-1:00
 |  |  |  |  |  | total hours
Spreadsheet: 847924d1698769592-help-making-an-annual-leave-calendar-mehhchael-excel-help-aligw
Sheet: Sheet1

 |  |  |  |  |  | 2024-04-01 00:00:00
 | Name | A | A-Date | B | B-Date
 | [NAME] | A | 2024-04-08 00:00:00 | B | 2024-05-06 00:00:00
 | [NAME] | A |  | B
 | [NAME] | A |  | B
 | [NAME] | A |  | B
 | [NAME] | A |  | B
 | [NAME] | A |  | B
 | [NAME] | A |  | B
 | [NAME] | A |  | B
Spreadsheet: 700871d1603378852-how-to-pull-cells-based-on-adjacent-cells-example
Sheet: Sheet2

Employee | Day |  |  | Mon | [NAME] | Wed | Thurs | Fri
[NAME] | Mon |  |  | [NAME] | Kenny | Mark | [NAME] | [NAME]
Mark | Wed |  |  | [NAME] |  | [NAME] | [NAME]
[NAME] | Mon |  |  | [NAME] |  | [NAME] | [NAME]
[NAME] | Thurs |  |  | Tyler
[NAME] | Thurs
[NAME] | Wed
[NAME] | Mon
Kenny | [NAME]
[NAME] | Thurs
[NAME] | Wed
Tyler | Mon
[NAME] | Fri
Spreadsheet: 586a4f46-d5f0-4b52-8a54-4b098530be99
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
OPEN DIVISION CIF-SS/FORD 2014 GIRLS BASKETBALL CHAMPIONSHIPS
 | FINALS | SEMIFINALS |  | 1ST ROUND | QUARTERFINALS | SEMIFINALS | FINALS
 | FRIDAY | SAT., MAR. 1 |  | SAT., FEB. 22 | WED., FEB.26 | SAT., MAR. 1 | SATURDAY
 | [NAME] 7 | 7:00 P.M. |  | 7:00 P.M. | 7:00 p.m. | 7:00 p.m. | MAR. 7/8
 |  |  |  | [NAME] (1) - Trinity #1
 |  |  |  |  | *[NAME]
 |  |  |  | BYE
 |  | Alemany |  |  |  | [NAME]
 |  | 45 |  | *Alemany (8) - Mission #2 |  | 75-28 | PLEASE REPORT SCORES TO:
 |  |  |  |  |  |  | www.cifsshome.org
 |  |  |  |  | Sierra Canyon |  | Home Campus
 |  |  |  | Sierra Canyon (9) - Alpha #2 | 56
 | *Alemany |  |  |  |  |  | [NAME]
 | 61-47 |  |  | *Serra (5) - Del Rey #1T |  | F | 56-54
 |  |  |  |  | Serra
 |  |  |  | [NAME] (12) - Almont #1 | 71
 |  | *[NAME] |  |  |  | *Etiwanda
 |  | 37 |  | [NAME] (4) - Baseline #1 |  | 67-54
 |  |  |  |  | *Etiwanda
 |  |  |  | BYE
 |  |  |  | Friday, March 7 - 9:00 p.m. - Felix Event Ctr, APU
 |  |  |  | Poly/Long Beach (3) - Moore #1
 | CONSOLATION |  |  |  |  |  | CHAMPION
 | CHAMPION |  |  |  | *Poly/LB
 | F |  |  | BYE
 |  | *Lynwood |  |  |  | Poly/LB
 |  | 44 |  | *Chaminade (6) - Mission #1 |  | 75-57
 |  |  |  |  | Chaminade
 |  |  |  | Lynwood (11) - San Gabriel Vly #1 | 64
 | Lynwood |  |  |  |  |  | [NAME]
 | 51-44 | F |  | *Canyon Springs (7) - Inland Valley #1 |  | F | 62-49
 |  |  |  |  | [NAME]
 |  |  |  | Troy (10) - Freeway #1 | 54
 |  | Troy
 |  | 51 |  | [NAME] (2) - Alpha #1 |  | *[NAME]
 |  |  |  |  |  | 52-42
 |  |  |  |  | *[NAME]
 |  |  |  | BYE
 | *Denotes Host Team
 | 2014 GIRLS BASKETBALL OPEN DIVISION
Spreadsheet: 95468d1295037942-picking-two-columns-of-data-and-combining-forum-sample-12
Sheet: Sheet1

1 |  |  |  | 2 |  |  |  |  | 3
8 |  | SORT FROM OTHER 2 NUMBERS |  | 5 |  | SORT FROM OTHER 2 NUMBERS |  |  | 9 |  | SORT FROM OTHER 2 NUMBERS
NUM |  |  |  | NUM |  |  |  |  | NUM
018 |  |  |  | 350 |  |  |  |  | 190
028 |  |  |  | 125 |  |  |  |  | 092
181 |  |  |  | 405 |  |  |  |  | 309
083 |  |  |  | 522 |  |  |  |  | 192
218 |  |  |  | 153 |  |  |  |  | 049
804 |  |  |  | 550 |  |  |  |  | 139
813 |  |  |  | 154 |  |  |  |  | 229
282 |  |  |  | 253 |  |  |  |  | 905
805 |  |  |  | 056 |  |  |  |  | 419
814 |  |  |  | 542 |  |  |  |  | 923
382 |  |  |  | 353 |  |  |  |  | 690
581 |  |  |  | 570 |  |  |  |  | 159
428 |  |  |  | 516 |  |  |  |  | 249
870 |  |  |  | 255 |  |  |  |  | 907
618 |  |  |  | 543 |  |  |  |  | 169
528 |  |  |  | 805 |  |  |  |  | 259
438 |  |  |  | 517 |  |  |  |  | 089
808 |  |  |  | 256 |  |  |  |  | 179
187 |  |  |  | 355 |  |  |  |  | 926
268 |  |  |  | 445 |  |  |  |  | 593
484 |  |  |  | 905 |  |  |  |  | 449
089 |  |  |  | 581 |  |  |  |  | 909
188 |  |  |  | 752 |  |  |  |  | 189
728 |  |  |  | 653 |  |  |  |  | 792
638 |  |  |  | 159 |  |  |  |  | 639
485 |  |  |  | 528 |  |  |  |  | 954
189 |  |  |  | 357 |  |  |  |  | 289
378 |  |  |  | 456 |  |  |  |  | 739
684 |  |  |  | 259 |  |  |  |  | 496
855 |  |  |  | 475 |  |  |  |  | 595
289 |  |  |  | 556 |  |  |  |  | 992
865 |  |  |  | 593 |  |  |  |  | 389
389 |  |  |  | 485 |  |  |  |  | 497
848 |  |  |  | 557 |  |  |  |  | 659
578 |  |  |  | 665
866 |  |  |  | 954
 |  |  |  | 855
 |  |  |  | 567
 |  |  |  | 595
 |  |  |  | 865
 |  |  |  | 577
 |  |  |  | 659
 |  |  |  | 578
Spreadsheet: 78734d1279055531-simple-but-complex-dividing-issue-divide-by-example
Sheet: Sheet1

518.4078369140625 |  | 95.19999694824219 | 29.73999977111816
635.0269165039062 |  | 94.08000183105469 | 29.73999977111816
516.0596313476562 |  | 95.04000091552734 | 25.90999984741211
595.351318359375 |  | 95.33999633789062 | 25.90999984741211
493.9788818359375 |  | 96.0999984741211 | 23.59000015258789
481.2322998046875 |  | 96.0999984741211 | 23.59000015258789
422.2500305175781 |  | 96.94999694824219 | 24.06999969482422
455.3952941894531 |  | 96.62000274658203 | 24.06999969482422
537.0978393554688 |  | 96.52999877929688 | 28.23999977111816
671.58056640625 |  | 93.08000183105469 | 28.23999977111816
659.2321166992188 |  | 93.75 | 27.81999969482422
708.3399658203125 |  | 93.51000213623047 | 27.81999969482422
650.3446655273438 |  | 95.05999755859375 | 28.43000030517578
718.71923828125 |  | 98.97000122070312 | 28.43000030517578
655.9546508789062 |  | 95.9000015258789 | 25.75
710.6110229492188 |  | 91.88999938964844 | 25.75
572.45263671875 |  | 94.02999877929688 | 0
631.9498291015625 |  | 96.16999816894531 | 0
632.0858764648438 |  | 0 | 0
697.7568969726562 |  | 0 | 0
11963.82751464844 |  |  | 427.0999984741211
 |  |  | 3.56992775055627
 |  |  | 4.53
Spreadsheet: 121136d1315861159-match-different-sheet-values-then-highlight-rows-that-meet-criteria-example
Sheet: Variable

 | Number
 | 1153
 | 34215
 | 21
 | 315
 | 4654
 | 1324323
 | 4684651
 | 21315
 | 2131456
 | 4896
 | 654665
 | 3215561
 | 1313515
 | 1315431
 | 8987945
 | 131684
 | 4354496
Spreadsheet: 155445d1336844036-arrays-question-anotherwa2doit
Sheet: Sheet1

 | [NAME] | coef | Inga | coef | Alise | coef | today()
[NAME] | 2012-01-01 00:00:00 | 1.688710444469143 | 2012-01-06 00:00:00 | 1.371252155020653 | 2012-01-03 00:00:00 | 1.040553926723608 | 2012-02-14 00:00:00
Alise | 2012-02-15 00:00:00 | 0.9871740102151009 | 2012-02-02 00:00:00 | 0.8076068832731258 | 2012-02-04 00:00:00 | 0.6022022025140813
Inga | 2012-03-25 00:00:00 | 0.07976106303538122 | 2012-03-31 00:00:00 | 0.1160746904611686 | 2012-03-15 00:00:00 | 0.5758473982879398
 | [NAME] | Alise
 | 2012-01-01 00:00:00 | 2012-01-03 00:00:00
 | 2012-02-15 00:00:00 | 2012-02-04 00:00:00
 | 2012-03-25 00:00:00 | 2012-03-15 00:00:00
 | [NAME] | Alise | Inga
 | 2012-01-01 00:00:00 | 2012-01-03 00:00:00 | 2012-01-06 00:00:00
 | 2012-02-15 00:00:00 | 2012-02-04 00:00:00 | 2012-02-02 00:00:00
 | 2012-03-25 00:00:00 | 2012-03-15 00:00:00 | 2012-03-31 00:00:00
Spreadsheet: 142557d1329912691-comparing-values-across-sheets-and-returning-another-set-of-data-based-on-comparison-dummy-2-
Sheet: Report

Only the following names appear since they appear in Sheet2.
Athlete's Name | Event (from Sheet2, Column E)
 |  |  | They are now paired up with their own events. |  |  |  | Yellow | Javelin
 |  |  |  |  |  |  | Red | Marathon
 |  |  |  |  |  |  | Black | Shotput
 |  |  |  |  |  |  | Green | Discus
 |  |  |  |  |  |  | Orange | 100m
 |  |  | Note: NAMES SHOULD ONLY BE HERE IF AND ONLY IF THEY APPEAR IN BOTH SHEET1 AND SHEET2! THERE ARE INSTANCES THAT THE "MASTER LIST" WILL NOT BE ABLE TO INCLUDE THE NAMES IN SHEET2. Those are excluded. Basically, this is an "attendance" report for athletes.
Spreadsheet: 760203d1640060557-vlookup-for-a-formula-result-test-bracket
Sheet: Bracket

 | Round 10 | Round 9 | Round 7 | Round 6 | Round 4 | Round 2 | Round 1 | Round 3 | Round 5 | Round 8 | Round 11
 |  |  |  |  |  |  | Game 1
 |  |  |  |  |  | Game 9 |  | Game 13
 |  |  |  |  | Game 17 |  | Game 2
 |  |  |  |  | renee |  |  |  | Game 21
 |  |  |  |  | Loser of 16
 |  |  |  | Game 23 |  |  | Game 3
 |  |  |  |  |  | Game 10 |  | Game 14
 |  |  | Game 25 |  | Game 18 |  | Game 4
 |  |  |  |  |  |  |  |  |  | Game 27
 |  |  |  |  | Loser of 15
 |  |  |  |  |  |  | Game 5
 |  |  | Loser of 22
 |  |  |  |  |  | Game 11 |  | Game 15
 |  | Game 29 |  |  | Game 19 |  | Game 6
 |  |  |  |  |  |  |  |  | Game 22 |  |  | Tournament Winner
 |  |  |  |  | Loser of 14
 |  |  |  | Game 24 |  |  | Game 7
 | Game 57 |  |  |  |  | Game 12 |  | Game 16
Winner of [NAME] |  |  |  |  |  |  |  |  |  |  | Winner of Losers bracket
 |  |  | Game 26 |  | Game 20 |  | Game 8
 |  |  |  |  | Loser of 15
 | Loser of 27 |  | Loser of 21
Spreadsheet: 160713d1339170917-dynamic-charts-help-setting-up-with-named-ranges-table_chart-example
Sheet: Sheet1

 |  | Series | 2010 | 20102 | 20103 | 20104 | 20105 | 20106 | 20107 | 20108 | 20109 | 201010 | 201011 | 201012
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  | 1000 Series | 7763.5 | 8469.77 | 14815.32 | 11033.26 | 5095.31 | 15453.28 | 10837.89 | 13496.6 | 12830.25 | 10793.5 | 14062.41 | 3788.38
 |  | 2000 Series | 10092.09 | 5325.63 | 22213.71 | 21963.15 | 17151.68 | 9628.29 | 5899.38 | 14082.57 | 14850.55 | 9588.31 | 13304.52 | 3775.56
 |  | 3000 Series | 55873.29 | 62078.31 | 64356.14 | 63029.48 | 80443.55 | 83927.28 | 53788.17 | 78987.78 | 78974.75 | 71375.56 | 74311.65 | 48475.32
 |  | 4000 Series | 7913.15 | 15395.78 | 16422.78 | 9894.11 | 9978.63 | 6662.32 | 5602.92 | 17048.49 | 7927.92 | 5155.61 | 21520.2 | 3586.9
 |  | 5000 Series | 521.16 | 1108.98 | 746.38 | 1367.3 | 1764.27 | 350.64 | 841.5 | 1257.86 | 424.92 | 210.35 | 1380.11 | 191.29
 |  | 6000 Series | 4091.32 | 3364.03 | 4649.13 | 9092.19 | 3881.53 | 8939.77 | 2668.1 | 5458.63 | 8772.13 | 6326.73 | 6112.38 | 1361.8
 |  | 7000 Series | 14251.74 | 15246.56 | 18486.33 | 19455.33 | 14478 | 26037.78 | 19175.95 | 26168.59 | 29650.31 | 17966.23 | 23866.37 | 15728.87
 |  | 9000 Series | 3105.29 | 10053.25 | 6280.81 | 4243.49 | 16914.07 | 4463.59 | 3970.94 | 3268 | 11368.6 | 4175.57 | 16848.46 | 2684.15
 |  | A Series | 1198.03 | 923.14 | 2479.93 | 1869.04 | 3068.3 | 1404.73 | 2249.31 | 2343.26 | 749.7 | 1196.33 | 1258.6 | 1542.07
 |  | E Series | 1001.4 | 1371.32 | 1504.88 | 825.31 | 1492.36 | 1317.29 | 1701.54 | 584.25 | 521.25 | 1423.17 | 2117.41 | 144.64
 |  | G Series |  | 228.33 | 95.16 | 39.18 | 56.76 | 35.02 | 840.5 | 1010.06 | 395.33
 |  | J Series | 36.14 | 28.24 | 281.32 | 131.84 | 1453.73 | 119.9 |  | 85.23 | 39.02 | 144 | 45.72
 |  | W Series | 132.9 | 272.67 | 1227.66 | 329.2 | 633.82 | 245.72 | 91.76 | 334.3 | 393.56 | 915.27 | 614.87 | 118.3
 |  | N Series | 1090.55 | 2402.93 | 2600.24 | 2844.19 | 2537.91 | 2869.28 | 2588.98 | 4274.55 | 4329.64 | 5080.98 | 5025.16 | 325.28
 |  | S Series | 5458.65 | 3048.2 | 1882.55 | 3061.44 | 2758.47 | 3833.47 | 1706.46 | 12187.53 | 4916.46 | 1415.39 | 2662.92 | 484.94
 |  | U Series |  |  | 17.2 |  |  |  |  |  |  | 34.4
 |  | Miscellaneous Income | 3523.17 | 2853.21 | 6695.1 | 7851.87 | 4162.62 | 5827.62 | 3407.48 | 2316.94 | 4447.69 | 6658.86 | 6573.95 | 2276.32
Spreadsheet: 186753d1350195876-get-the-data-from-two-different-sheets-shiftsab-indirect
Sheet: Result

 |  |  | Shift | Shift A
 |  |  |  | Day |  |  |  |  |  |  |  |  | Shift A | Day |  | Shift ADay | DayNight!C4 | 15
 |  |  |  |  |  |  |  |  |  |  |  |  | Shift B | Night |  | Shift ANight | NightDay!C4 | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shift BDay | [NAME] | 13
Emp No | Emp Name | 8-9 AM | 10-11 AM | 12-2 PM | 4-5 PM | 8-9 PM | 12-1 AM | 4-5 AM |  |  |  |  |  |  |  | [NAME] | DayNight!C13 | 13
 |  | Break Fast | Brunch | Lunch | [NAME] | Dinner | Snacks | Morning Tea
Spreadsheet: 713659d1610869670-randomizer-for-employees-qualified-for-several-roles-example-updated-1-15-21-ans
Sheet: Sheet1

Employee List and Current Qualifications |  |  |  |  |  | Table 1 |  |  | Table 2 |  |  | Table 3
Employee | [NAME] | Feeder | Tester | [NAME] |  | Role | Name |  | Role | Name |  | Role | Name
ww |  | X |  |  |  | [NAME] |  |  | [NAME] |  |  | [NAME]
[NAME] | X | X |  |  |  | [NAME] |  |  | [NAME] |  |  | Tester
[NAME] |  |  | X |  |  | [NAME] |  |  | [NAME] |  |  | [NAME]
cc |  | X | X |  |  | Feeder |  |  | Feeder |  |  | Feeder
qq | X | X | X |  |  | Tester |  |  | Tester |  |  | Tester
[NAME] |  | X | X
bbb |  |  | X
KK |  | X
aaa | X
dd | X
[NAME] | X | X | X
[NAME] | X |  | X
[NAME] | X | X
[NAME]'s I've tried in H3,4,5 and K3,4,5:
=INDEX($A$3:$A$8,RANK($E3,$E$3:$E$8),1)
Works, but picks anyone regardless of qualificaton
=INDEX($A$3:$A$8,LARGE(IF($B$3:$B$8="X",ROW($B$3:$B$8)-ROW($B$3)+1),INT(RAND()*COUNTIF($B3:$B$8,"X")+1)))
Works, but allows duplicate names in multiple roles, based on qualification, within the same table or even multiple tables
Spreadsheet: 662972d1581869085-finding-clashes-in-a-table-sixth-form-options
Sheet: Options & Groups WIP

Block A
Biology
Business
English Literature
English Language
French
Geography
Latin
Mathematics
Music Technology
Physical Education (BTEC)
Physics
Politics
Block B
Biology
Business
Chemistry
Classical Civilisation
Design Technology
Economics
English Literature
German
Mathematics
Further Maths
Music
Psychology
Textiles
Block C
Art
Business
Chemistry
Economics
Film
Geography
History
Physics
Psychology
Religious Studies
Spanish
Theatre Studies
Spreadsheet: 138241d1327584432-solved-need-to-return-a-specified-cell-based-on-the-highest-value-in-a-range-copy-of-test-worksheet
Sheet: Combined Results

 | [NAME] AND INTERVIEW COMBINED RESULTS
 |  |  | Resume | Interview | Total
 |  | [NAME] Score: | 12 | 12
 |  | Percentage of Total Score: | 0.25 | 0.75
 |  | Weighting Factor:
 |  | [NAME] Score:
 |  | FINAL COMBINED CANDIDATE RATING
 |  | Candidate | Weighted Scores |  |  |  |  |  | Base Scores
 |  |  | Resume | Interview | Total |  |  |  | Resume | Interview
 |  | 1 |  |  |  |  |  |  | 12 | 3
 |  | 2 |  |  |  |  |  |  | 9 | 6
 |  | 3 |  |  |  |  |  |  | 6 | 7
 |  | 4 |  |  |  |  |  |  | 5 | 9
 |  | 5 |  |  |  |  |  |  | 3 | 12
 |  | 6 |  |  |  |  |  |  | 3 | 0
 |  | 7 |  |  |  |  |  |  | 3 | 0
 |  | 8 |  |  |  |  |  |  | 3 | 0
 |  | 9 |  |  |  |  |  |  | 3 | 0
 |  | 10 |  |  |  |  |  |  | 3 | 0
Spreadsheet: darrell_schoolcraft__7818__imbalsumm0109
Sheet: Continental

 | Contintental
 | 500204 |  | 500205
Day | Measured | Scheduled | Measured | Scheduled
1
2
3
4
5
6
7
8
9
10 | 50 |  | 133
11 | 6398 | 6000 | 4497 | 5210
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-08-31 00:00:00 |  |  |  |  | 6001.93
2001-09-11 00:00:00
CBS Volume
 |  |  | -13252
Spreadsheet: 880599d1728408511-appending-total-at-last-with-sum-from-i-to-p-with-lookup-demo
Sheet: Sheet2

 |  |  |  |  |  |  |  | Total | Col (AC+ AN) | Col (W+ Y) | Col (X+ Z) | Col (AH+ AJ) | Col (AI+ AK) | Col (AA+ AL) | Col (AB+ AM)
Sheet1 | Sheet1 | Sheet1 | Sheet1 | Sheet1 | Sheet1 | Sheet1 | Sheet1 | J+K+M+O | Sheet1 | Sheet1 | Sheet1 | Sheet1 | Sheet1 | Sheet1 | Sheet1 | Sheet1 | Sheet1
Lookup | Lookup | Lookup | Lookup | Lookup | Lookup | Lookup | Lookup | Sheet2 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Lookup | Lookup
 |  |  |  |  |  |  |  | Current Sheet |  |  |  |  |  |  |  |  |  |  | Sheet1 | <[NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month | Feb
Total
Spreadsheet: 0645cdbb-89e1-4cc4-89af-5c21414aceda
Sheet: NAm

min.pop | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | % Var
among region | 1.8 | 1.8 | 1.8 | 1.8 | 1.81 | 1.8 | 1.9 | 1.8 | 1.8 | 1.3
among population | 8.7 | 8.7 | 8.6 | 8.6 | 8.3 | 7.9 | 7.7 | 7.8 | 7.7 | 8.1
within population | 89.5 | 89.5 | 89.6 | 89.6 | 89.9 | 90.3 | 90.4 | 90.4 | 90.5 | 90.6
 | Phi
st | 0.105 | 0.105 | 0.104 | 0.104 | 0.101 | 0.097 | 0.096 | 0.096 | 0.095 | 0.094
 | 0.089 | 0.089 | 0.088 | 0.088 | 0.084 | 0.08 | 0.078 | 0.079 | 0.079 | 0.082
 | 0.018 | 0.018 | 0.018 | 0.018 | 0.018 | 0.018 | 0.019 | 0.018 | 0.018 | 0.013