tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 494215d1482253398-2017-revenue-forecast-trend-formula-2017-forecast-trend_linear
Sheet: Sheet1

 |  |  |  |  |  |  |  | Hosting | License
 |  |  |  |  |  |  | 1 | 0 | 4362
 |  |  |  |  |  |  | 2 | -4520 | 357.84
 |  |  |  |  |  |  | 3 | 11422.5 | 20356
 |  |  |  |  |  |  | 4 | 0 | 3306
 |  |  |  |  |  |  | 5 | 0 | 1554
 |  |  |  |  |  |  | 6 | 14820 | 25231.1
 |  |  |  |  |  |  | 7 | 0 | 1026
 |  |  |  |  |  |  | 8 | 5217 | 0
 |  |  |  |  |  |  | 9 | 2880.75 | 27490.5
 |  |  |  |  |  |  | 10 | -450 | 6850
 |  |  |  |  |  |  | 11 | 0 | 4569
 |  |  |  |  |  |  | 12 | 1875 | 45178.33
 |  |  |  |  |  |  | 13 | 2985 | 4095
 |  |  |  |  |  |  | 14 | 2985 | 0
 |  |  |  |  |  |  | 15 | 36005 | 56931.56
 |  |  |  |  |  |  | 16 | 6000 | 960
 |  |  |  |  |  |  | 17 | 8550 | 0
 |  |  |  |  |  |  | 18 | 12920 | 16568
 |  |  |  |  |  |  | 19 | 8940 | 15321
 |  |  |  |  |  |  | 20 | 8940 | 15321
 |  |  |  |  |  |  | 21 | 8940 | 60147
 |  |  |  |  |  |  | 22 | 9698.43 | 18471
 |  |  |  |  |  |  | 23 | 9935 | 18700
 |  |  |  |  |  |  | 24 | 13744 | 16945.69
 |  |  |  |  |  |  | 25 | 11244 | 56831
 |  |  |  |  |  |  | 26 | 10589.5 | 29461
 |  |  |  |  |  |  | 27 | 12644 | 35284
 |  |  |  |  |  |  | 28 | 12704 | 37961
 |  |  |  |  |  |  | 29 | 14444 | 66853
 |  |  |  |  |  |  | 30 | 11944 | 43617
 |  |  |  |  |  |  | 31 | 18064 | 70637
 |  |  |  |  |  |  | 32 | 16109 | 86921
 |  |  |  |  |  |  | 33 | 13609 | 88725
 |  |  |  |  |  |  | 34 | 14217 | 80619.5
 |  |  |  |  |  |  | 35 | 13929 | 81208
 |  |  |  |  |  |  | 36 | 13609 | 52802
 |  |  |  |  |  |  | 37
 |  |  |  |  |  |  | 38
 |  |  |  |  |  |  | 39
 |  |  |  |  |  |  | 40
 |  |  |  |  |  |  | 41
 |  |  |  |  |  |  | 42
 |  |  |  |  |  |  | 43
 |  |  |  |  |  |  | 44
 |  |  |  |  |  |  | 45
 |  |  |  |  |  |  | 46
 |  |  |  |  |  |  | 47
 |  |  |  |  |  |  | 48
Spreadsheet: 873662d1720174979-catch-break-inside-working-time-catch-break-inside-working-time
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TODAY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FRI
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WED | 09:00:15 | 12:00:15 | 15:00:15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | THU | 08:30:31 | 11:30:45 | 14:30:45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FRI | 09:00:15 | 12:00:15 | 15:00:15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SAT | 08:30:45 | 11:30:45 | 14:30:45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | breaks |  |  |  |  | my formula
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | job name | job time |  | START TIME | FINISH TIME |  |  |  |  | Start Time + Job Time | Break Time | Finish Time
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 01:20:39.834000 |  | 06:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 03:52:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 02:14:24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 01:01:12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 02:52:48
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | job name | job time |  | START TIME | FINISH TIME |  |  |  |  | Start Time + Job Time | Break Time | Finish Time
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 01:04:43.146000 |  | 06:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:50:56.604000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 03:34:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 02:38:24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 02:24:00
Spreadsheet: 863857d1711244107-exchanging-no-s-for-names-examplebook1golf
Sheet: Sheet2

player 1 |  | player 1 |  | player 7
player 2 |  | player7
player 3
player 4 |  | player 2 |  | player 2 |  | player 2
player 5 |  | player5 |  |  |  |  |  |  |  | these players corespond to the list in sheet 1
player 6 |  |  |  |  |  |  |  | player 8
player 7 |  | player 3
player 8 |  | [NAME] |  | player 4 |  | player 8
 |  | player 6
 |  | player 8 |  | player 8
 |  |  | 0 |  | 0
fred (player 2) |  |  | 1
bill
[NAME] |  |  | 1 |  | 1 |  | 0
[NAME] |  |  | 0
alf
[NAME] |  |  | 0
[NAME] |  |  | 1 |  | 0 |  | 1
 |  |  | 0
 |  |  | 1 |  | 1
Spreadsheet: 784455d1655740088-extract-month-number-from-month-name-different-language-book1
Sheet: HYP

 | Channel | Local moving | Intercompany | Priceplan | Product
 |  |  |  |  | Year 2021 |  | Year 2022 | Year 2022 | Year 2022 | Year 2022 | Year 2022 | Year 2022 | Year 2022 | Year 2022 | Year 2022 | Year 2022 | Year 2022 | Year 2022
 |  |  |  |  | YearTotal |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  |  |  | Actual |  | Actual | Actual
Spreadsheet: 0d96f988-0014-4337-9a7f-e2bc6b631a39
Sheet: Sheet2

Type | Employer | City | State
City | Garden City | Garden City | ID
City | City of Moscow | Moscow | ID
Federal | US Army Corps of Engineers/Walla Walla District | Walla Walla | WA
Federal | BLM Colorado State Office | Lakewood | CO
Federal | BLM Coeur d'Alene Field Office | Coeur d’Alene | ID
Federal | USEPA  Region 10 | Seattle | WA
Federal | US ARMY Corps of Engineers | Anchorage | AK
Federal | Natural Resource Conservation Service (NRCS) | Driggs | ID
Federal | NEPA Coordinator
Federal | US Forest Service | Missoula | MT
Federal | Idaho Association of Soil Conservation Districts | Sandpoint | ID
Federal | Department of Energy | Idaho Falls | ID
NGO | Nature Conservancy | Boise | ID
NGO | Tri-States Water Quality Council | Sandpoint | ID
NGO | Anchorage Waterways Council | Anchorage | AK
NGO | Oregon Center for Public Policy | Silverton | OR
NGO | Whidbey Island Conservation District | Coupeville | WA
Private | Holladay Engineering | Payette | ID
Private | Micron Technology | Boise | ID
Private | EcoTech | Portland | OR
Private | Brown & Caldwell | Boise | ID
Private | RJ [NAME] – Center for Laboratory Sciences | Pasco | WA
Private | [NAME] | Portland | OR
Private | Terra Graphics Environmental Engineering | Moscow | ID
Private | Terra Graphics Environmental Engineering | Boise | ID
Private | Morrison & Foerster Law Firm | San Francisco | CA
Private | Idaho Power | Boise | ID
Private | Halliburton | Houston | TX
Private | Golder Associates Inc. | Coeur d’Alene | ID
Private | Beckman Coulter | [NAME] | CA
Private | Keystone Science School | Keystone | CO
Private | Test American Environmental Laboratory | Beaverton | OR
Private | Chevron (locations worldwide-variety of skills) |  | WY
Private | [NAME] | Portland | OR
Private | Leading Edge Aviation | Lewiston | ID
Private | Conservation Seeding and Restoration (CSR) | Kimberly | ID
Private | US Silver –Galena Mine Environmental Specialist | Wallance | ID
Private | SECOR International | Redmond | WA
Private | Simplot | Boise | ID
Private | North Wind Inc | Idaho Falls | ID
Private | Battelle Energy Alliance | Idaho Falls | ID
Private | CM2M-WG Idaho, LLC (Idaho Cleanup Project) | Idaho Falls | ID
State Govt | Idaho Fish & Game | Lewiston | ID
State Govt | Western’s Governors Association | Denver | CO
State Govt | Colorado Division of Water Resources | Denver | CO
State Govt | Panhandle Health-District 1
State Govt | Idaho National Laboratory | Idaho Falls | ID
State Govt | Panhandle Health | Hayden | ID
State Govt | [NAME] | Lewiston | ID
State Govt | Latch Soil and Water Conservation District | Moscow | ID
State Govt | Minnesota Pollution Control Agency | [NAME] | MN
State Govt | University of Alaska
State Govt | Washington Dept of Health | Oylmpia | WA
State Govt | Missoula County | Missoula | MT
Tribal | Nez Perce Soil and Water Conservation District | Culdesac | ID
Tribal | Coeur d’Alene Tribe | Coeur d'Alene | ID
Tribal | [NAME] | Wellprint | WA
University | UI – [NAME] GIS specialist | Moscow | ID
University | UI Research office | Moscow | ID
University | University of Alaska | Anchorage | AK
Spreadsheet: 714985d1611495928-sum-valves-from-different-columns-considering-multiple-variables-example-data
Sheet: Sheet1

 |  |  |  |  |  | Home team |  | Away team
[NAME] | Date | Home Team | Away Team | Home team goals | Away team goals | Previous 2 games Goals Scored | Previous 2 games Goals Conceded | Previous 2 games Goals Scored | Previous 2 games Goals Conceded
 | 2004-08-14 00:00:00 | [NAME] | Southampton | 2 | 0
 | 2004-08-25 00:00:00 | Arsenal | [NAME] | 3 | 0
 | 2004-08-25 00:00:00 | Charlton | [NAME] | 5 | 1
 | 2004-08-25 00:00:00 | Fulham | Middlesbrough | 0 | 2
 | 2004-08-28 00:00:00 | [NAME] | Newcastle | 4 | 1
 | 2004-08-28 00:00:00 | [NAME] | Man United | 1 | 1
 | 2004-09-11 00:00:00 | [NAME] | Chelsea | 0 | 1
 | 2004-09-18 00:00:00 | [NAME] | [NAME] | 0 | 0
 | 2004-09-18 00:00:00 | West Brom | Fulham | 1 | 1
 | 2004-09-25 00:00:00 | [NAME] | Crystal Palace | 1 | 1
Spreadsheet: 0f1341ab-6dcb-4c15-8a10-e715a6798405
Sheet: Sheet1

#3  Course Retention | MSJC BASIC SKILLS LEVEL DATA
 | AY 07-08 | A08-09 | [NAME] | AY10-11 | AY-11-12 | AY12-13 | AY13-14
 | 2007
Gender | Retention Rates | Retention Rates | Retention Rates | Retention Rates | Retention Rates | Retention Rates | Retention Rates
Female |  |  |  |  |  | 0.9041 | 0.8894830659536542
Male |  |  |  |  |  | 0.8695 | 0.8604014598540146
Unknown |  |  |  |  |  | 0.9211 | 0.8636363636363636
AY Average |  |  |  |  |  | 0.8913 | 0.8779007497322385
Ethnicity | Retention Rates | Retention Rates | Retention Rates | Retention Rates | Retention Rates | Retention Rates | Retention Rates
White |  |  |  |  |  | 0.9103 | 0.8781456953642384
Hispanic |  |  |  |  |  | 0.896 | 0.8784648187633263
African American |  |  |  |  |  | 0.8274 | 0.8651315789473684
Asian |  |  |  |  |  | 0.9398 | 0.8714285714285714
Native American |  |  |  |  |  | 0.75 | 0.9
Filipino |  |  |  |  |  | 0.8539 | 0.9107142857142857
Pacific Islander |  |  |  |  |  | 0.8 | 0.7894736842105263
Multi-Race |  |  |  |  |  | 0.9029 | 0.8930817610062893
Unknown |  |  |  |  |  | 0.9103 | 0.9047619047619048
Age | Retention Rates | Retention Rates | Retention Rates | Retention Rates | Retention Rates | Retention Rates | Retention Rates
<18 |  |  |  |  |  | 0.94 | 0.9545454545454546
18 & 19 |  |  |  |  |  | 0.9303 | 0.909310761789601
20 to 24 |  |  |  |  |  | 0.8813 | 0.8502155172413793
25 to 29 |  |  |  |  |  | 0.8699 | 0.8805460750853242
30 to 34 |  |  |  |  |  | 0.8819 | 0.8444444444444444
35 to 39 |  |  |  |  |  | 0.8895 | 0.8652482269503546
40 to 49 |  |  |  |  |  | 0.875 | 0.8831168831168831
50 + |  |  |  |  |  | 0.899 | 0.89171974522293
Unknown
BASIC SKILLS = Courses under 70 level
Spreadsheet: 221047d1363356516-display-largest-value-unless-displayed-in-a-specific-cell-siedel-gauss
Sheet: Sheet1

 | Enter system of equations here |  |  |  |  | Siedel-Gauss Iterative Method
 | Co-ef x1 | Co-ef y1 | Co-ef z1 | constant 1 |  | nth Iteration | x value | y value | z value
 | 1 | 2 | 3 | a |  | 0th
 | Co-ef x2 | Co-ef y2 | Co-ef z2 | constant 2 |  | 1st
 | 4 | 5 | 6 | b |  | 2nd
 | Co-ef x3 | Co-ef y3 | Co-ef z3 | constant 3 |  | 3rd
 | -7 | 8 | 9 | c |  | 4th
 |  |  |  |  |  | 5th
 | Diagonally Dominant System |  |  |  |  | 6th
 |  |  |  |  |  | 7th
 |  | IF(C4^2=MAX(C4^2,C6^2,C8^2)AND(B4doesnotequalB11)) | . |  |  | 8th
 |  |  |  |  |  | 9th
 |  |  |  |  |  | 10th
 | Enter Starting Values Here |  |  |  |  | 11th
 | x | y | z |  |  | 12th
 | 0 | 0 | 0 |  |  | 13th
 |  |  |  |  |  | 14th
 |  |  |  |  |  | 15th
 |  |  |  |  |  | 16th
 |  |  |  |  |  | 17th
 |  |  |  |  |  | 18th
 |  |  |  |  |  | 19th
 |  |  |  |  |  | 20th
Spreadsheet: d7867f4c-9488-473f-8c6b-c2fedc953139
Sheet: Denial Rate Trend By Race

 | 2006 | 2007 | 2008 | 2009 | 2010
American Indian | 0.05 | 0.142857142857143 | 0.1 | 0.04225352112676056 | 0.01724137931034483
Asian | 0.07142857142857142 | 0.04545454545454546 | 0.16875 | 0.131578947368421 | 0.08185053380782918
Black or African American | 0.25 | 0.4516129032258064 | 0.2520325203252032 | 0.1401273885350318 | 0.04605263157894737
Hispanic | 0.1079136690647482 | 0.1441647597254005 | 0.1210564930300807 | 0.07464478687212327 | 0.0539259927797834
White | 0.125 | 0.2448979591836735 | 0.2402597402597403 | 0.1402597402597403 | 0.07853403141361257
Overall Total | 0.1023166023166023 | 0.1506352087114338 | 0.1261724659606657 | 0.07696007696007696 | 0.05410679439418131
Spreadsheet: 860393d1708508689-sum-of-5dp-data-rounded-to-2dp-equals-100-data
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Round 2DP
 |  |  |  |  |  |  | A | 44.7995
 |  |  |  |  |  |  | B | 32.60696
 |  |  |  |  |  |  | C | 6.24132
 |  |  |  |  |  |  | D | 8.54458
 |  |  |  |  |  |  | E | 0.04996
 |  |  |  |  |  |  | F | 0.01737
 |  |  |  |  |  |  | G | 0.00657
 |  |  |  |  |  |  | H | 0.01845
 |  |  |  |  |  |  | I | 6.88775
 |  |  |  |  |  |  | J | 0.82754
 |  |  |  |  |  |  | Total
Spreadsheet: 887974d1738287768-more-efficient-way-to-use-ifs-and-function-example
Sheet: Sheet1

Date | ID # | Invoice # | Name | Status
01/10/2025 | 44552 | 4478 | [NAME]
01/10/2026 | 25487 |  | [NAME]
01/10/2027 |  | 4458 | Janice
01/10/2028
Spreadsheet: 759256d1639451259-calculating-hours-hours
Sheet: Hours

 | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
 | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | Hours Worked
Employee 1 | 07:00:00 | 15:00:00 | 07:00:00 | 15:00:00 | 07:00:00 | 15:00:00 | 07:00:00 | 15:00:00 | 07:00:00 | 15:00:00
Employee 2 |  |  | 13:30:00 | 21:30:00 | 13:30:00 | 21:30:00 | 13:30:00 | 21:30:00 | 13:30:00 | 21:30:00 | 13:30:00 | 21:30:00
Spreadsheet: 91074d1290765883-formula-to-hide-div-0-with-null-tender-register-v4-0-nov-2010
Sheet: Averages

Per Estimator : |  | Estimator | Ave bid | ave winning tender | ave variance | % | ave finishing position | Strike/success rate
 |  | DW | 315000 | 300000 | -15000 | -0.05 | 2 | 0
 |  | JST |  |  | #N/A | #N/A |  | #N/A
 |  | KJL |  |  | #N/A | #N/A |  | #N/A
 |  | LH |  |  | #N/A | #N/A |  | #N/A
 |  | MAB |  |  | #N/A | #N/A |  | #N/A
 |  | MW |  |  | #N/A | #N/A |  | #N/A
 |  | SP |  |  | #N/A | #N/A |  | #N/A
 |  | Average | 315000 | 300000 | #N/A | #N/A | 2 | #N/A
Per Client : |  | Client | Ave bid | ave winning tender | ave variance | % | ave finishing position
 |  | Craegmoor | 315000 | 300000 | -15000 | -0.05 | 2
 |  | EMC |  |  | #N/A | #N/A
 |  | Oxfam |  |  | #N/A | #N/A
 |  | Priory |  |  | #N/A | #N/A
 |  | Average | 315000 | 300000 | #N/A | #N/A | 2
Spreadsheet: 5eaa1550-23e0-4f19-bc75-7cd2b687c3a1
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
4393 | 25584 | Remi | [NAME] | BEL | 327 | 01:55:48 | 00:01:13 | 03:04:06 | [NAME] | [NAME] | 1 | [NAME]
Spreadsheet: 104752d1302210481-conditional-formatting-date-ranges-audit-master-station-listing
Sheet: COMBI

IATA | ICAO | Airport | City | Country | Date of Last Audit | Auditor
ANU | TAPA | [NAME]. | [NAME] | [NAME] and [NAME]
ASI | FHAW | Ascension Aux AB | Georgetown | Ascension Is.
AWK | PWAK | Wake Island Airfield | Wake Island | USA
BAH | OBBI | Bahrain Intl. | [NAME] | Bahrain
BWI | KBWI | Baltimore/Washington Intl. | Baltimore, MD | USA
HIK | PHIK | Hickam AFB | Honolulu, HI | USA
MLB | KMLB | Melbourne International | Melbourne, FL | USA
NKW | FJDG | [NAME] | [NAME] | British Indian OC.
OKO | RJTY | Yokota AFB | Fussa | Japan
QPG | WSAP | Paya Lebar AB | Paya Lebar | Singapore
SUU | KSUU | Travis AFB | Fairfield, CA | USA
TER | LPLA | [NAME] | Lajes | Portugal
THU | BGTL | [NAME] | Pituffik | Greenland
WRI | KWRI | McGuire AFB | Wrightstown, NJ | USA
Spreadsheet: 887315d1737551591-combine-subtotal-and-sumifs-test1
Sheet: Sheet2

A | 1.7.1.1
B | 1.7.1.2
AA | 1.7.1.4
C | NEW SUPZET
(blank)
Total
 |  | Unit | Unit | Unit | Unit | Unit | Unit | Unit | Unit
ROW | PART | 45 | 00 | 35 | 40 | 55 | 58 | 75 | Total
1.7.1.1 | A | 1336.902000000005 |  |  |  |  |  |  | 1352.246000000005
1.7.1.2 | B | 5788.625999999969 | 773.4540000000045 |  |  | 1329.308999999993 | 141.2790000000001 | 1413.615999999994 | 24615.26100000009
1.7.1.1 | AA | 3574.395999999985 |  | 4069.370999999999 |  |  |  |  | 7650.406999999985
1.7.1.4 | C | 5.787 |  |  |  |  |  |  | 5.787
1.7.1.1 | C | 16542.44600000063 |  | 34653.2409999999 |  |  |  |  | 51257.61200000053
1.7.1.1 | AA | 6728.798999999935 |  |  |  |  |  |  | 6883.699999999935
NEW SUPZET | B | 39245.75499999792 | 3915.421999999951 |  | 3703.819999999937 | 14305.76400000009 | 622.1039999999995 | 16923.76800000008 | 286602.684000003
1.7.1.1 | (blank) | 22.592 |  |  |  |  |  |  | 1167.734
Spreadsheet: 863744d1711128615-count-instances-or-frequency-multiple-sheets-counting-position-appearances-in-baseball-excel-help-forum-roster-template-2024-03-22
Sheet: Game 2

Date: |  | 2024-05-01 00:00:00 |  |  | Field: |  |  | Start Time: |  | 18:00:00
Home: |  |  |  |  | 3rd | Set Up
Visitors: |  |  |  |  | 1st | Clean Up
 |  |  |  |  | Inning
 |  | Player |  |  | Coach Pitch |  |  |  |  |  | Innings on Bench | Innings in Infield | Inninings in Outfield |  |  |  | [NAME]
Order |  | First | Last | # | 1 | 2 | 3 | 4 | 5 | 6
1 | 12 | [NAME] |  |  | 1B (3) | 1B (3) | 1B (3) | LF (7) | LF (7) | LF (7) |  |  |  |  | P (1)
2 | 11 | Ty |  |  | 2B (4) | 2B (4) | 2B (4) | RF (9) | RF (9) | RF (9) |  |  |  |  | C (2)
3 | 1 | [NAME] |  |  | 3B (5) | 3B (5) | 3B (5) | LCF () | LCF () | LCF () |  |  |  |  | 1B (3)
4 | 2 | [NAME] |  |  | LF (7) | LF (7) | LF (7) | 1B (3) | 1B (3) | 1B (3) |  |  |  |  | 2B (4)
5 | 4 | [NAME] |  |  | P (1) | P (1) | P (1) | [NAME] () | [NAME] () | [NAME] () |  |  |  |  | 3B (5)
6 | 5 | Willie |  |  | X | RF (9) | RF (9) | 3B (5) | 3B (5) | 3B (5) |  |  |  |  | SS (6)
7 | 10 | [NAME] |  |  | RF (9) | X | SS (6) | SS (6) | C (2) | C (2) |  |  |  |  | LF (7)
8 | 9 | [NAME] |  |  | SS (6) | SS (6) | X | 2B (4) | 2B (4) | 2B (4) |  |  |  |  | CF (8)
9 | 6 | Babe |  |  | LCF () | LCF () | LCF () | X | SS (6) | SS (6) |  |  |  |  | RF (9)
10 | 7 | [NAME] |  |  | C (2) | C (2) | [NAME] () | P (1) | X | P (1) |  |  |  |  | SF (10)
11 | 8 | [NAME] |  |  | [NAME] () | [NAME] () | C (2) | C (2) | P (1) | X |  |  |  |  | EH ()
12 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | LCF ()
13 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ()
Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Roster pulled from list on roster tab
 | 9
 | 9
Notes:
 |  |  |  | Players on [NAME]
 |  | Only pull a players first name from the drop down
Spreadsheet: 545899d1509718666-if-or-and-and-statement-help-issue_multipleifstatements
Sheet: Reference

OU4 | Reference |  | **UNIQUE**
Analyst | Other Support |  | Sr. Partner (>10 yr partner)
Contract Attorney | Other attorney |  | Partner (<10 yr partner)
Director [NAME] | Other Support
Economist | Other Support
GLS - Consultant | Other Support
GLS - Director | Other Support
GLS - Legal Prof | Other Support
GLS - Manager | Other Support
GLS - Senior Manager | Other Support
GLS-Project Manager | Other Support
Junior Associate | Jr. Associate (1-3 yr)
Junior Paralegal | Paralegal
[NAME] | Other Support
Legal Assistant | Paralegal
Local Partner | **UNIQUE**
Mid Level Associate | Associate (4-6)
Mid Level Paralegal | Paralegal
Of Counsel | Of Counsel
Patent Agent | Other Support
Principal | **UNIQUE**
Principal Economist | **UNIQUE**
Principal TaxAdvisor | **UNIQUE**
Prof Sup Lawyer | Other attorney
Senior Analyst | Other Support
Senior Associate | Sr. Associate
Senior Counsel | Of Counsel
Senior Economist | Other Support
Senior [NAME] | Paralegal
Summer Associate | Other attorney
Tax Director | Other Support
Tax Specialist | Other Support
Trade Mark Associate | Other Associate
Trainee | Other Support
Translator | Other Support
Spreadsheet: 858953d1707421717-formula-to-get-shifts-from-a-difrent-tab-where-to-look-at-name-and-date-sheet-1
Sheet: Shifts

 |  |  |  |  | SHIFTS
 |  |  |  | Date | Scot | Eve | [NAME] | [NAME] |  | [NAME] | [NAME]
 |  |  |  | 2024-01-01 00:00:00 | HAPPY NEW YEAR
 |  |  |  |  | 0900-1700 | 0900-1700 |  |  |  | 0800-1600 | 0900-1700
 |  |  |  |  | 1200-2000 | 0900-1700 | 0800-1600 | 0800-1600 | 0800-1600 | 0800-1600 | 0900-1700
 |  |  |  |  | 0800-1600 | 0900-1700 | 0800-1600 | 1200-2000 | 0800-1600 | 0800-1600 | 0900-1700
 |  |  |  |  | 0900-1700 |  | 0800-1600 | 0800-1600 | 0800-1600 | 0800-1600 | 0900-1700
 |  |  |  |  |  |  |  | 0730-1400
 |  |  |  |  | 0900-1700 |  | 1200-2000 | 0800-1600 | 0800-1600 | 0800-1600 | 0900-1700
 |  |  |  |  | 0900-1700 | 1200-2000 | 0800-1600 | 0800-1600 | 0800-1600 | 0800-1600 | 0900-1700
 |  |  |  |  | 1200-2000 | 0900-1700 | 0800-1600 | 0800-1600 | 0800-1600 | 0800-1600 | 0900-1700
 |  |  |  |  | 0800-1600 | 0900-1700 | 0800-1600 | 1200-2000 | 0800-1600 | 0800-1600 | 0900-1700
 |  |  |  |  | 0900-1700 | 0900-1700 | 0800-1600 | 0800-1600 | 0800-1600 | 0800-1600 | 0900-1700
 |  |  |  |  |  |  | 0730-1400
 |  |  |  |  | 0900-1700 | 0800-1600 | 1200-2000 | 0800-1600 | 0800-1600 | 0800-1600 | 0900-1700
 |  |  |  |  | 0900-1700 | 1200-2000 | 0800-1600 | 0800-1600 | 0800-1600 | 0800-1600 | 0900-1700
 |  |  |  |  | 1200-2000 | 0900-1700 | 0800-1600 | 0800-1600 | 0800-1600 | 0800-1600 | 0900-1700
 |  |  |  |  | 0800-1600 | 0900-1700 | 0800-1600 | 1200-2000 | 0800-1600 | 0800-1600 | 0900-1700
 |  |  |  |  | 0900-1700 | 0900-1700 | 0800-1600 | 0800-1600 | 0800-1600 | 0800-1600 | 0900-1700
 |  |  |  |  | 0730-1400
 |  |  |  |  | 0900-1700 | 0900-1700 | 1200-2000 | 0800-1600 | 0800-1600 | 0800-1600 | 0900-1700
 |  |  |  |  | 0900-1700 | 0900-1700 | 1200-2000 | 0800-1600 | 0800-1600 | 0800-1600 | 0900-1700
 |  |  |  |  | 1200-2000 | 0900-1700 | 0800-1600 | 0800-1600 | 0800-1600 | 0800-1600 | 0900-1700
 |  |  |  |  | 0800-1600 | 0900-1700 | 0800-1600 | 1200-2000 | 0800-1600 | 0800-1600 | 0900-1700
 |  |  |  |  | 0900-1700 | 0900-1700 | 0800-1600 | 0800-1600 | 0800-1600 | 0800-1600 | 0900-1700
 |  |  |  |  |  | 0730-1400
 |  |  |  |  | 0900-1700 | 1200-2000 |  | 0800-1600 | 0800-1600 | 0800-1600 | 0900-1700
 |  |  |  |  | 0900-1700 | 1200-2000 |  | 0800-1600 | 0800-1600 | 0800-1600 | 0900-1700
 |  |  |  |  | 1200-2000 | 0900-1700 |  | 0800-1600 | 0800-1600 | 0800-1600 | 0900-1700
Spreadsheet: 119781d1314737724-transpose-a-reference-film-run-times-8-22-
Sheet: pocket

fri | 66 | [NAME] |  |  |  |  | 02:40:00 | 04:50:00 | 07:00:00
2011-07-15 00:00:00 |  | flat | 01:40:00
 |  | Trip |  |  |  |  |  |  |  | 09:15:00
 |  | flat | 01:57:00
 | 25 | Tree of Life |  |  |  |  | 03:00:00 | 06:00:00 |  | 09:00:00
 |  | flat | 02:30:00
sat | 66 | [NAME] |  |  | 12:15:00
2011-07-16 00:00:00 |  | flat | 01:59:00 | b'day
 |  | Boom |  | 09:30:00 |  |  | 02:30:00
 |  | scope | 02:03:00 | 11:30:00
 |  | [NAME] |  |  |  |  |  | 04:50:00 | 07:00:00
 |  | flat | 01:40:00
 |  | Trip |  |  |  |  |  |  |  | 09:15:00
 |  | flat | 01:57:00
 | 25 | Tree of Life |  |  | 12:00:00 |  | 03:00:00 | 06:00:00 |  | 09:00:00
 |  | flat | 02:30:00
[NAME] | 66 | [NAME] |  |  | 11:40:00 | 01:40:00 | 03:40:00
2011-07-17 00:00:00 |  | flat | 01:40:00
 |  | Trip |  |  |  |  |  | 05:40:00
 |  | flat | 01:57:00
 |  | [NAME] |  |  |  |  |  |  | 08:00:00
 |  | flat | 01:59:00
 |  | Boom |  |  |  |  |  |  |  |  | 10:15:00
 |  | scope | 02:03:00
 | 25 | Tree of Life |  |  | 12:00:00 |  | 03:00:00 | 06:00:00 |  | 09:00:00
 |  | flat | 02:30:00
mon | 66 | [NAME] |  |  |  |  | 03:20:00 |  | 07:40:00
2011-07-18 00:00:00 |  | flat | 01:40:00
 |  | Trip |  |  |  |  |  | 05:20:00 |  | 09:40:00
 |  | flat | 01:57:00
 | 25 | Tree of Life |  |  |  |  | 03:00:00 | 06:00:00 |  | 09:00:00
 |  | flat | 02:30:00
tues | 66 | [NAME] |  |  |  |  | 03:20:00 |  | 07:40:00
2011-07-19 00:00:00 |  | flat | 01:40:00
 |  | Trip |  |  |  |  |  | 05:20:00 |  | 09:40:00
 |  | flat | 01:57:00
 | 25 | Tree of Life |  |  |  |  | 03:00:00 | 06:00:00 |  | 09:00:00
 |  | flat | 02:30:00
wed | 66 | [NAME] |  |  |  |  | 03:20:00 |  | 07:40:00
2011-07-20 00:00:00 |  | flat | 01:40:00
 |  | Trip |  |  |  |  |  | 05:20:00 |  | 09:40:00
 |  | flat | 01:57:00
 | 25 | Tree of Life |  |  |  |  | 03:00:00 | 06:00:00 |  | 09:00:00
 |  | flat | 02:30:00
[NAME] | 66 | [NAME] |  |  |  |  | 02:30:00 | 04:30:00
2011-07-21 00:00:00 |  | flat | 01:40:00
 |  | wrecking crew |  |  |  |  |  | 06:30:00
 |  | rental | 03:00:00
 |  | Trip |  |  |  |  |  |  |  | 09:40:00
 |  | flat | 01:57:00
 | 25 | Tree of Life |  |  |  |  | 03:00:00 | 06:00:00 |  | 09:00:00
 |  | flat | 02:30:00