tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 64218d1265114119-changing-cell-value-based-on-cell-to-the-left-book2
Sheet: A-L (2)

 | Menu Link | Client Link | Surname | Forename | Week On | Status
 | M-Z | GOTO | BOB | BOB | 0
 | A-L | GOTO | BOB | BOB | 0
 | Information | GOTO | BOB | BOB | 0
 |  | GOTO | SMITH | BOB | 0
 |  | GOTO | SMITH | BOB | 0
 |  | GOTO | SMITH | BOB | 0
 |  | GOTO | SMITH | BOB | 0
 |  | GOTO | SMITH | BOB | 0
 |  | GOTO | SMITH | BOB | 26
 |  | GOTO | SMITH | BOB | 0
 |  | GOTO | SMITH | BOB | 0
 |  | GOTO | SMITH | BOB | 0
 |  | GOTO | SMITH | BOB | 13
 |  | GOTO | SMITH | BOB | 13
 |  | GOTO | SMITH | BOB | 0
 |  | GOTO | SMITH | BOB | 0
 |  | GOTO | SMITH | BOB | 0
 |  | GOTO | SMITH | BOB | 0
 |  | GOTO | SMITH | BOB | 26
 |  | GOTO | SMITH | BOB | 0
 |  | GOTO | SMITH | BOB | 0
 |  | GOTO | SMITH | BOB | 0
 |  | GOTO | SMITH | BOB | 0
 |  | GOTO | SMITH | BOB | 0
 |  | GOTO | SMITH | BOB | 0
 |  | GOTO | SMITH | BOB | 0
 |  | GOTO | SMITH | BOB | 0
 |  | GOTO | SMITH | BOB | 0
 |  | GOTO | SMITH | BOB | 0
 |  | GOTO | SMITH | BOB | 0
 |  | GOTO | SMITH | BOB | 0
 |  | GOTO | SMITH | BOB | 0
 |  | GOTO | SMITH | BOB | 0
 |  | GOTO | SMITH | BOB | 0
 |  | GOTO | SMITH | BOB | 0
 |  | GOTO | SMITH | BOB | 0
 |  | GOTO | SMITH | BOB | 0
 |  | GOTO | SMITH | BOB | 0
 |  |  | SMITH | BOB | 0
Spreadsheet: 786477d1657207308-payroll-formulas-needed-for-hours-pto-and-per-diem-payroll-data-report
Sheet: Payroll Data Report

First Name | Last Name | Regular Time (Decimal) | Overtime (Decimal) | Double Time (Decimal) | PTO Hrs | [NAME] | Total (Decimal) | Per Diem Days
Adam | Osborne |  | 0 | 0 |  |  | 80
[NAME] | [NAME] |  | 20 | 49.07 |  |  | 109.07
[NAME] | Rojas-Zaragoza |  | 17 | 1 |  |  | 66
Amberley | McKenzie |  | 0 | 0 |  |  | 30
[NAME] | [NAME] |  | 6.5 | 0 |  |  | 85.75
Antony | Guillen-Hernandez |  | 17 | 1 |  |  | 98
[NAME] | Turner |  | 0 | 0 |  |  | 80
Cameron | [NAME] |  | 21.5 | 0.5 |  |  | 102
Cathy | Jury |  | 0 | 0 |  |  | 80
[NAME] | Hinrichsen |  | 0 | 0 |  |  | 72
[NAME] | Yanez |  | 25.75 | 0 |  |  | 105.25
[NAME] | Walker |  | 0 | 0 |  |  | 72
[NAME] | Young |  | 23.25 | 4 |  |  | 107.25
George | Millward |  | 17 | 0 |  |  | 97
[NAME] | Unruh |  | 9.25 | 0 |  |  | 83
J [NAME] | [NAME] |  | 19.5 | 1 |  |  | 76.5
[NAME] | Aulgur |  | 9.25 | 0 |  |  | 82.5
Jaime | Rodriguez-Herrera |  | 22 | 1.02 |  |  | 87.02
[NAME] | Hoover |  | 16.85 | 4 |  |  | 89.1
Jared | Hitomi |  | 0.75 | 0 |  |  | 55.5
[NAME] | Tuck |  | 0 | 0 |  |  | 80
[NAME] | [NAME] |  | 14 | 0.25 |  |  | 94.25
[NAME] | Martinez |  | 18.5 | 0.5 |  |  | 91
Jorge | Rodriguez |  | 7.5 | 0 |  |  | 79.5
[NAME] | O'Kennedy |  | 0 | 0 |  |  | 80
Julian | Cuevas |  | 18.75 | 3 |  |  | 93.75
Justice | Hitomi |  | 23.75 | 0.5 |  |  | 104.25
[NAME] | Jauch |  | 12.03 | 0.3 |  |  | 68.77
Manuel | Guerrero |  | 19.5 | 1 |  |  | 84
Mark | Eveland |  | 8 | 0 |  |  | 88
Mark | Schilling |  | 0 | 0 |  |  | 80
[NAME] | Novo |  | 10 | 0 |  |  | 90
[NAME] | O'Connell |  | 21.22 | 0.68 |  |  | 101.9
[NAME] | Hitomi |  | 0 | 0 |  |  | 90
Payton | Beall |  | 12.38 | 0 |  |  | 90.47
Phat | Nguyen |  | 12.07 | 0.3 |  |  | 68.82
Ricardo | Greene II |  | 5.5 | 0 |  |  | 51.77
[NAME] | Baxter |  | 0 | 0 |  |  | 80
[NAME] | Rudnick |  | 0 | 0 |  |  | 80
Saran | Khamkhong |  | 12.6 | 0 |  |  | 76.6
Sergio | [NAME] |  | 33.5 | 4 |  |  | 117.5
[NAME] | Pyka |  | 0 | 0 |  |  | 80
[NAME] | Torres |  | 0 | 0 |  |  | 80
[NAME] | Gregorich |  | 0 | 0 |  |  | 80
Trent | Hallett |  | 6 | 0 |  |  | 61
Trevor | Cronin |  | 18.25 | 0.25 |  |  | 96.75
Trevor | Whitehead |  | 12 | 0 |  |  | 91.75
[NAME] | Blake |  | 21.03 | 4 |  |  | 97.03
Zach | Keefover |  | 21.25 | 0.5 |  |  | 101.75
Zachary | Turner |  | 11.67 | 0 |  |  | 90.67
Spreadsheet: 804987d1668459634-moving-a-row-into-another-sheet-automated-please-help-test-book
Sheet: Active

User Name: | NA | CA | SA
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 873803d1720374084-cant-make-the-formula-system-suitability-and-area-ration-calculation-sheet-for-fudrocortisone-acetate-usp-excel-for
Sheet: Sheet1

Respective Solvent ( |  |  |  |  |  |  |  |  | [NAME] |  |  | )
Average peak area of |  |  |  |  |  |  | in diluent |  |  | = | 10523
 |  |  | Area Ratio of |  |  |  |  |  |  |  | Results
Solution Name |  |  | Calculation |  |  |  |  | Area Ratio |  |  | Solution Name | Average | SD |  | % RSD
[NAME] 01 |  |  | = | 635686 | - |  |  | =
 |  |  |  | 236572 |  |  |  |  |  |  | [NAME]
[NAME] 02 |  |  | = | 639863 | - |  |  | =
 |  |  |  | 241450
[NAME] 03 |  |  | = | 624296 | - |  |  | =
 |  |  |  | 236539 |  |  |  |  |  |  | Bracketing Standard Solution 01
[NAME] 04 |  |  | = | 624296 | - |  |  | =
 |  |  |  | 238607
[NAME] 05 |  |  | = | 630036 | - |  |  | =
 |  |  |  | 238196
Bracketing Standard Solution 01 |  |  | = | -257242 |  |  |  | =
 |  |  |  | 82919
Spreadsheet: 41286d1239787327-by-selecting-filter-condition-in-one-sheet-filtering-on-multiple-sheets-automatically-sample-filter-data
Sheet: Sheet1

Name | [NAME] a | [NAME] b | [NAME] c
Sethu | xxx | xxx | xxx
Kannan | xxx | xxx | xxx
[NAME] | xxx | xxx | xxx
Suresh | xxx | xxx | xxx
[NAME] | xxx | xxx | xxx
Sethu | xxx | xxx | xxx
[NAME] | xxx | xxx | xxx
Sethu | xxx | xxx | xxx
Kannan | xxx | xxx | xxx
[NAME] | xxx | xxx | xxx
Spreadsheet: 873889d1720475903-loookup-and-copy-based-on-matching-book2
Sheet: Sheet1

IP | Server name | info | other info | etc | etc
192.168.1.1 |  | … | … | … | …
192.168.1.5 |  | … | … | … | …
192.168.1.6 |  | … | … | … | …
192.168.1.10 |  | … | … | … | …
192.168.1.11 |  | … | … | … | …
(goes on for 10 thousand rows
Spreadsheet: 2fad3d3b-4663-42dd-aa76-0ce8b26f9b04
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43563146 | 2014-10-13 13:07:41 | ALLIES | 1 | 7 | 6 | 55639 | Gigimat | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
43590289 | 2014-10-15 11:28:54 | ALLIES | 0 | 4 | 10 | 1656389 | *Ne0 Angr | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
43603724 | 2014-10-16 11:37:46 | ALLIES | 0 | 3 | 6 | 1616413 | célestin poux | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
43617720 | 2014-10-17 13:06:32 | ALLIES | 0 | 0 | 6 | 1362585 | NEMAUS | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
43617795 | 2014-10-17 13:19:20 | AXIS | 0 | 5 | 6 | 1362585 | NEMAUS | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
Spreadsheet: 852692d1702645144-choose-with-array-function-sample-3-
Sheet: Sheet1

Points |  | 1 | 2 | 3 | 4 |  |  | Points |  | 11 | 12 | 1 | 2
1 |  |  |  |  |  |  |  | 2
3 | 12 |  |  |  |  | 5 |  | 7 | 10 |  |  |  |  | 3
5 | 11 |  |  |  |  | 6 |  | 11 | 9 |  |  |  |  | 4
12
 |  | 10 | 9 | 8 | 7 |  |  |  |  | 8 | 7 | 6 | 5
 |  | Box number dynamic every time will change the orders
Spreadsheet: 14f5241e-cfdb-4e4b-ba41-f33d2042c79c
Sheet: Sheet1

Description | AUN | County | District | Library | Municipalities | 2000 pop. | 2010 pop. | % change
PA0231 | 916490483 | NORTHUMBERLAND | POTTSVILLE | MOUNT CARMEL PUBLIC LIBRARY | Mount Carmel Borough | 6390 | 5893 | -0.07777777777777778
PA0231 | 916490483 | NORTHUMBERLAND | POTTSVILLE | MOUNT CARMEL PUBLIC LIBRARY | Mount Carmel Township | 2701 | 3139 | 0.1621621621621622
PA0231 | 916490483 | NORTHUMBERLAND | POTTSVILLE | MOUNT CARMEL PUBLIC LIBRARY | [NAME] | 2985 | 2924 | -0.02043551088777219
PA0231 | 916490483 | NORTHUMBERLAND | POTTSVILLE | MOUNT CARMEL PUBLIC LIBRARY | [NAME] | 735 | 611 | -0.1687074829931973
PA0231 | 916490483 | NORTHUMBERLAND | POTTSVILLE | MOUNT CARMEL PUBLIC LIBRARY | [NAME] | 21 | 10 | -0.5238095238095238
PA0231 Total |  |  |  |  |  | 12832 | 12577 | -0.01987219451371571
PA0233 | 916490605 | NORTHUMBERLAND | POTTSVILLE | RALPHO TOWNSHIP PUBLIC LIBRARY | Ralpho Township | 3764 | 4321 | 0.14798087141339
PA0233 Total |  |  |  |  |  | 3764 | 4321 | 0.14798087141339
PA0234 | 916490722 | NORTHUMBERLAND | POTTSVILLE | SHAMOKIN & COAL TWP PUB LIB | Shamokin City | 8009 | 7374 | -0.07928580347109501
PA0234 | 916490722 | NORTHUMBERLAND | POTTSVILLE | SHAMOKIN & COAL TWP PUB LIB | Coal Township | 10628 | 10383 | -0.02305231464057208
PA0234 | 916490722 | NORTHUMBERLAND | POTTSVILLE | SHAMOKIN & COAL TWP PUB LIB | Shamokin Township | 2159 | 2407 | 0.1148679944418712
PA0234 | 916490722 | NORTHUMBERLAND | POTTSVILLE | SHAMOKIN & COAL TWP PUB LIB | East Cameron Township | 686 | 748 | 0.09037900874635568
PA0234 Total |  |  |  |  |  | 21482 | 20912 | -0.0265338422865655
Subtotal of Northumerland County |  |  |  |  |  | 38078 | 37810 | -0.007038184778612322
Unclaimed Municipalities and Populations
 |  | Northumberland |  |  | HERNDON BORO | 383 | 324 | -0.1540469973890339
 |  | Northumberland |  |  | [NAME] | 761 | 794 | 0.04336399474375821
 |  | Northumberland |  |  | LOWER MAHANOY TWP | 1586 | 1709 | 0.07755359394703656
 |  | Northumberland |  |  | UPPER MAHANOY TWP | 599 | 796 | 0.328881469115192
 |  | Northumberland |  |  | WEST CAMERON TWP | 517 | 541 | 0.04642166344294004
 |  | Northumberland |  |  | ZERBE TWP | 2021 | 1872 | -0.07372587827808016
Unclaimed Municipalities Total |  |  |  |  |  | 5867 | 6036 | 0.02880518152377706
Spreadsheet: 131648d1323198876-excel-2007-find-formula-to-get-end-result-based-off-of-goal-and-current-percentage-60-goal-example
Sheet: Sheet1

 | Apples | Oranges | Pears | Lemons | Bananas
Apples |  | 1 | 1 | 3 | 2
Oranges | 2 |  | 2 | 3 | 1
Pears | 4 | 4 |  | 1 | 1
Lemons | 3 | 1 | 1 |  | 3
Bananas | 1 | 3 | 1 | 2
Spreadsheet: 695594d1600292953-how-to-create-one-formula-providing-a-result-based-on-specific-criteria-example-etaf
Sheet: Sheet1

PRB Forecast | Var | Sep 1QFC | Result
409 | -234 | 477
1242 | 1222 | 3725
167 |  | 500
 |  |  |  |  | If a "Var" (column B) is present then the sum of "Var" & "Sep 1QFC" (column B & C) is the "Result" (column D) • If a "Var" (column B) is not present then the sum of "PRB Forecast" & "Sep 1QFC" (column A & C) is the "Result" (column D) • If there are zero values then result shows a "-" in the cell
Spreadsheet: 95462d1295035639-multiply-cell-values-between-2-dates-example
Sheet: Sheet1

2010-03-31 00:00:00 | 7.244526202101631 |  | Range:
2010-04-30 00:00:00 | 1.083479487945049 |  | From | 2010-06-30 00:00:00
2010-05-31 00:00:00 | -7.717835874309642 |  | To | 2010-11-30 00:00:00
2010-06-30 00:00:00 | -3.576505278181763
2010-07-31 00:00:00 | 5.943958446834641 |  | Result | 0.08875231789325877
2010-08-31 00:00:00 | -3.373869973133059
2010-09-30 00:00:00 | 7.757264549051324
2010-10-31 00:00:00 | 2.888136882088288
2010-11-30 00:00:00 | -0.5136306566366988
2010-12-31 00:00:00 | 5.730416889946466
Spreadsheet: 169215d1342728029-arranging-information-into-tables-new-problem-1
Sheet: Summary

Summary
 | A | B | C | D
1
Spreadsheet: 845441d1696958058-pivot-with-multiple-tabs-as-range-forecasts-and-orders-10102023
Sheet: GUA

Product Name | Item Code | Total Sales | Average Sales per Day | GV On Floor Inv | GV On Floor DOI | DOI in 2 Weeks | DOI in 3 Weeks | DOI in 4 Weeks | GV In Orders | GV On Floor After Order | GV New DOI | GV New Order in [NAME] | In Cases | GV Ending DOI |  | Order Date | PO | Description | Item Code | Qty
GUAYAKI LMN EL 12/15.5Z CN | 10914 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ** Peach Juice not active
GUAYAKI ENLIGH 12/15.5Z CN | 10909 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ** Sourcing Cranberry
GUAYAKI TROPIC 12/15.5Z CN | 10912
GUAYAKI SP GRP 12/12Z CN | 10918
GUAYAKI ORNG E 12/15.5Z CN | 10913
GUAYAKI SP CLA 12/12Z CN | 10917
GUAYAKI REVEL 12/15.5Z CN | 10910
GUAYAKI TRAD T 12/16Z BTL | 10921
GUAYAKI RSPB T 12/16Z BTL | 10920
GUAYAKI MNT TE 12/16Z BTL | 10919
GUAYAKI PCH RE 12/15.5Z CN | 10915
GUAYAKI BLUEPH 12/15.5Z CN | 10911
GUAYAKI SP CRA 12/12Z CN | 10916
Product Name | Item Code | Total Sales | Average Sales per Day | GV On Floor Inv | GV On Floor DOI | DOI in 2 Weeks | DOI in 3 Weeks | DOI in 4 Weeks | GV In Orders | GV On Floor After Order | GV New DOI | GV New Order in [NAME] | In Cases | GV Ending DOI
GUAYAKI LMN EL 12/15.5Z CN | 10914
GUAYAKI ENLIGH 12/15.5Z CN | 10909
GUAYAKI TROPIC 12/15.5Z CN | 10912
GUAYAKI SP GRP 12/12Z CN | 10918
GUAYAKI ORNG E 12/15.5Z CN | 10913
GUAYAKI SP CLA 12/12Z CN | 10917
GUAYAKI REVEL 12/15.5Z CN | 10910
GUAYAKI TRAD T 12/16Z BTL | 10921
GUAYAKI RSPB T 12/16Z BTL | 10920
GUAYAKI MNT TE 12/16Z BTL | 10919
GUAYAKI PCH RE 12/15.5Z CN | 10915
GUAYAKI BLUEPH 12/15.5Z CN | 10911
GUAYAKI SP CRA 12/12Z CN | 10916
Spreadsheet: 40236d1238542693-sort-pivot-table-formula-what-example1
Sheet: Example

Number | Name | ContractDate | City | ST | Zip | Fee | Svc | COReg | Points | AM | AV | Q1 | Q2 | Q3 | Q4
100 | ABC | 2001-01-01 00:00:00 | Denver | CO | 10000 | 1 | I | METRO | 0.5 | BOB | 1 | 4 | 7 | 10 | 1
100 | ABC | 2001-01-01 00:00:00 | Denver | CO | 10000 | 1 | C | METRO | 4 | BOB | 1 | 4 | 7 | 10 | 1
200 | XYZ | 2002-01-01 00:00:00 | Castle Rock | CO | 20000 | 2 | I | SOUTH | 1 | MIKE | 2 | 6 | 9 | 12 | 3
200 | XYZ | 2002-01-01 00:00:00 | Castle Rock | CO | 20000 | 2 | C | SOUTH | 4 | MIKE | 2 | 6 | 9 | 12 | 3
300 | JohnDoe | 2003-01-01 00:00:00 | Last Chance | CO | 30000 | 3 | I | EAST | 4 | RICH | 3 | 5 | 8 | 11 | 2
300 | JohnDoe | 2003-01-01 00:00:00 | Last Chance | CO | 30000 | 3 | C | EAST | 4 | RICH | 3 | 5 | 8 | 11 | 2
400 | JanDoe | 2004-01-01 00:00:00 | Rifle | CO | 40000 | 4 | I | MNTN | 4 | MIKE | 4 | 4 | 7 | 10 | 1
400 | JanDoe | 2004-01-01 00:00:00 | Rifle | CO | 40000 | 4 | C | MNTN | 4 | MIKE | 4 | 4 | 7 | 10 | 1
500 | 123 Co | 2005-01-01 00:00:00 | Sante Fe | CO | 50000 | 5 | I |  | 4 | MIKE | 5 | 5 | 8 | 11 | 2
500 | 123 Co | 2005-01-01 00:00:00 | Sante Fe | CO | 50000 | 5 | C |  | 1 | MIKE | 5 | 5 | 8 | 11 | 2
600 | Up&Down | 2006-01-01 00:00:00 | Casper | CO | 60000 | 6 | I |  | 1 | MIKE | 6 | 6 | 9 | 12 | 3
600 | Up&Down | 2006-01-01 00:00:00 | Casper | CO | 60000 | 6 | C |  | 1 | MIKE | 6 | 6 | 9 | 12 | 3
700 | Back&Forth | 2007-01-01 00:00:00 | Vincennes | IN | 70000 | 7 | I |  | 0.5 | RICH | 7 | 0 | 0 | 0 | 0
800 | ZYX | 2008-01-01 00:00:00 | Lakewood | CO | 80000 | 8 | I | WEST | 0.5 | BOB | 8 | 0 | 0 | 0 | 0
800 | ZYX | 2008-01-01 00:00:00 | Lakewood | CO | 80000 | 8 | C | WEST | 0.5 | BOB | 8 | 0 | 0 | 0 | 0
900 | On | 2009-01-01 00:00:00 | Engelwood | CO | 90000 | 9 | C | METRO | 0.5 | MIKE | 9 | 0 | 0 | 0 | 0
1000 | Off | 2010-01-01 00:00:00 | Sterling | CO | 10001 | 10 | I | METRO | 0.5 | MIKE | 10 | 0 | 0 | 0 | 0
1000 | Off | 2010-01-01 00:00:00 | Sterling | CO | 10001 | 10 | C | NE | 4 | RICH | 10 | 5 | 8 | 11 | 2
1100 | In | 2011-01-01 00:00:00 | Random | CO | 10002 | 11 | I | SE | 4 | MIKE | 11 | 6 | 9 | 12 | 3
1100 | In | 2011-01-01 00:00:00 | Random | CO | 10002 | 11 | C | SE | 0.5 | MIKE | 11 | 0 | 0 | 0 | 0
1200 | Out | 2012-01-01 00:00:00 | Wichita | KS | 11000 | 12 | I |  | 0.5 | RICH | 12 | 0 | 0 | 0 | 0
Spreadsheet: 859606d1707932585-combining-unique-value-search-within-a-countif-search-forum-example-3
Sheet: Sheet1

Part Number | Person dealing | 1st Sent Date | 1st Due Date | 2nd person dealing | Final Letters Sent Date | Response Date (+15 working day) | Responses Closing Date | Open / Closed |  | Total open cases (some cases appear on more than one row) | Open cases with no initials in column B | Open cases with initials in column B but no initials in column E | Open cases awaiting with a date in column C less than 20 days prior to today | Open cases with a date more than 20 days after column G date, with no initials in column E | Open cases with an initial in column E | Open cases at appeal
2961-1-70 | TC | 2024-02-13 00:00:00 |  | NG | 2023-11-30 00:00:00 |  | 2023-12-21 00:00:00 | Open
1824-1-14 | AM | 2023-10-30 00:00:00 |  | NC | 2023-11-29 00:00:00 |  | 2023-12-20 00:00:00 | Open |  | Correct | Should be 1. | Should be 2. | Should be 2. | Should be 2. | Should be 6. | Correct
1824-1-14 | AM | 2023-10-31 00:00:00 |  | NC | 2023-11-29 00:00:00 |  | 2023-12-20 00:00:00 | Open
2562-1-100 | NG | 2024-02-13 00:00:00 |  | NG | 2023-11-29 00:00:00 |  | 2023-12-20 00:00:00 | Open |  |  | Equations for columns L to P counts all rows, rather than unique part numbers.
2562-1-100 | NG | 2024-02-13 00:00:00 |  | NG | 2023-11-29 00:00:00 |  | 2023-12-20 00:00:00 | Open |  |  | Some part numbers have 2 or more lines but should only be counted once e.g., rows 3 & 4 should count as 1.
2888-0-31 |  | 2023-10-31 00:00:00 |  | TP | 2023-11-29 00:00:00 |  | 2023-12-20 00:00:00 | Open
2888-0-31 |  | 2023-10-31 00:00:00 |  | TP | 2023-11-29 00:00:00 |  | 2023-12-20 00:00:00 | Open
1326-0-15 |  |  |  |  | 2023-11-28 00:00:00 |  |  | Closed
1326-0-15 |  |  |  |  | 2023-11-28 00:00:00 |  |  | Closed
1326-0-15 |  |  |  |  | 2023-11-28 00:00:00 |  |  | Closed
1797-1-57 | IH |  |  |  | 2023-11-28 00:00:00 |  | 2023-12-19 00:00:00 | Open
1797-1-57 | IH |  |  |  | 2023-11-28 00:00:00 |  | 2023-12-19 00:00:00 | Open
1838-1-60 |  |  |  |  | 2023-11-28 00:00:00 |  |  | Closed
1838-1-60 |  |  |  |  | 2023-11-28 00:00:00 |  |  | Closed
2956-1-18 | IH |  |  | IH | 2023-11-28 00:00:00 |  | 2023-12-19 00:00:00 | Open
2956-1-18 | IH |  |  | IH | 2023-11-28 00:00:00 |  | 2023-12-19 00:00:00 | Open
2956-1-19 | IH |  |  | IH | 2023-11-28 00:00:00 |  | 2023-12-19 00:00:00 | Open
2959-0-176 |  |  |  |  | 2023-11-28 00:00:00 |  | 2023-12-19 00:00:00 | Closed
0505-0-4 | IH |  |  |  | 2023-11-27 00:00:00 |  | 2023-12-18 00:00:00 | Open
1122-2-1 |  |  |  |  |  |  |  | Appeal
1122-2-1 |  |  |  |  |  |  |  | Appeal
Spreadsheet: 78858d1279148266-lookup-or-match-index-archery_sailepaty
Sheet: Sheet1

 |  |  | Rounds
Bow | Category |  | York | [NAME] | Bristol | There are a further 56 rounds
Recurve | ladies | GMB | 1080 | 1165
 |  | MB | 977 | 1091
 |  | [NAME] | 786 | 952
 |  | 1st Class | 511 | 723 | 911
 |  | 2nd Class | 308 | 508 | 725 |  | Bow | Category | Round | Score | Classification |  | F-Row | L-Row | Col | Match
 |  | 3rd Class | 142 | 280 | 473
 |  | Unclassified |  |  |  |  | Recurve | ladies | [NAME] | 750 | #N/A |  | #N/A | #N/A | 5 | #N/A
 |  |  |  |  |  |  | Recurve | gents | [NAME] | 900 | #N/A |  | #N/A | #N/A | 5 | #N/A
Recurve | gents | GMB | 1146 |  |  |  | Recurve | gents | [NAME] | 883 | #N/A |  | #N/A | #N/A | 5 | #N/A
 |  | MB | 1065 |  |  |  | Recurve | gents | [NAME] | 476 | #N/A |  | #N/A | #N/A | 5 | #N/A
 |  | [NAME] | 913
 |  | 1st Class | 698 | 884
 |  | 2nd Class | 511 | 723 | 911
 |  | 3rd Class | 283 | 477 | 695
 |  | Unclassified
Recurve | U18 | JMB | 1015 | 1118
 |  | JBowman | 839 | 992
 |  | 1st Class | 511 | 723 | 911
 |  | 2nd Class | 283 | 477 | 695
 |  | 3rd Class | 89 | 192 | 353
 |  | Unclassified
 | There are a further 37 categories below this where bow and category vary
Archery classifications explained.
Every time you shoot one of the 59 rounds (which vary in the numbers of arrows, distance, and target size) in addition to a handicap score you earn a classification. They Range from Grand Master Bowman (GMB) to unclassified. You need to achieve or exceed a particular score to get the respective classification.  Some rounds are less demanding and the higher classification cannot be earned by shooting them.  There are 40 Categories of archer depending on age, gender and bow type with varying ‘thresholds’ for the awards.
In the table for example looking at the recurve gents ‘Hereford Round’ |  |  |  |  |  |  | Score | Clasification
 |  |  |  |  |  |  | 900 | 1st class
 |  |  |  |  |  |  | 883 | 2nd class
 |  |  |  |  |  |  | 476 | Unclassified
Spreadsheet: 105058d1302538638-excel-2007-formula-that-translate-dates-to-a-calendar-employee-shift-calendar-question
Sheet: Employee Shifts

Emp# | Name | Date | Shift | Date | Shift | Date | Shift | Date | Shift | Date | Shift | Date | Shift | Date | Shift | Date | Shift
10543 | Smith | 2011-05-11 00:00:00 | AS1 | 2011-05-12 00:00:00 | AS1 | 2011-05-11 00:00:00 | AR1 | 2011-05-12 00:00:00 | AR1 | 2011-05-13 00:00:00 | AR1 | 2011-05-14 00:00:00 | AR1
10544 | [NAME] | 2011-05-11 00:00:00 | AR1 | 2011-05-12 00:00:00 | AR1 | 2011-05-13 00:00:00 | AR1 | 2011-05-14 00:00:00 | AR1
10545 | Jones | 2011-05-21 00:00:00 | AS1 | 2011-05-12 00:00:00 | AR1 | 2011-05-13 00:00:00 | AR1 | 2011-05-14 00:00:00 | AR1 | 2011-05-15 00:00:00 | AR1 | 2011-05-16 00:00:00 | AR1 | 2011-05-19 00:00:00 | AR1 | 2011-05-20 00:00:00 | AR1
***  It is possible for an employee to work multiple shifts a day ***  The AS1 shift would take priority over the AR1 shift in the calendar
Spreadsheet: 149158d1333725929-counting-zip-codes-zip-codes
Sheet: Sheet1

ZIp | #sold |  |  | zips | #installed |  |  |  | Zip | #sold | #installed | [NAME]
7012 | 1 |  |  | 7012 | 1 |  |  |  | 7012 | 1 | 1
7013 | 1 |  |  | 7026 | 1 |  |  |  | 7013 | 1 | 0
7016 | 1 |  |  | 7031 | 1 |  |  |  | 7016 | 1 | 0
7020 | 2 |  |  | 7033 | 2 |  |  |  | 7020 | 2 | 0
7022 | 1 |  |  | 7036 | 2 |  |  |  | 7022 | 1 | 0
7023 | 1 |  |  |  |  |  |  |  | 7023 | 1 | 0
7024 | 2 |  |  |  |  |  |  |  | 7024 | 2 | 0
7026 | 2 |  |  |  |  |  |  |  | 7026 | 2 | 1
7030 | 1 |  |  |  |  |  |  |  | 7030 | 1 | 0
7032 | 1 |  |  |  |  |  |  |  | 7032 | 1 | 0
7033 | 2 |  |  |  |  |  |  |  | 7033 | 2 | 2
7036 | 9 |  |  |  |  |  |  |  | 7036 | 9 | 2
Spreadsheet: 883411d1732032101-trying-to-customize-the-excel-template-attendance-record-employee-attendance-record-jul-to-jun-1-
Sheet: Holidays

 | Company holidays
 |  |  |  |  |  |  |  | **=DATE(YEAR(TODAY(00+IF(MONTH(TODAY())>6,0,-1)+1,M,D)
 | Company holidays | Description
 |  | Independence Day
 |  | Thanksgiving
 |  | Thanksgiving
 |  | Christmas
 |  | Christmas
 |  | New Year's Day
 |  | MLK
 |  | President's Day
 |  | Memorial Day
 |  | Juneteenth
Spreadsheet: 463105d1464294644-pulling-matching-data-from-different-sheets-vlookup-test-volume-report
Sheet: SUMMARY

Customer Name | Item | 01/15 | 02/15 | 03/15 | 04/15
AAA SERVICES
BBB COMPANY
CCC CORP.
DEEZ LLC
EARLY CO
FALCOG LTD
FITZ INC
LINEAR CO
MIGGY LTD
OPUS INC
QUARTZ LLC
RYTZO CO
SALS LTD
TIGZ INC
ZENITH CO
TOTAL
Spreadsheet: 17472e09-8832-4dad-a720-6c7ef92c1d1e
Sheet: # Serials Purchased

[NAME] vs. [NAME]
Serials Purchased
 | FY 2007 | FY 2008 | FY 2009 | FY 2010 | FY 2011 | % Change
Peer Average
Peer Median
University of Rhode Island | 20079 | 31443 | 38795 | 24392 | 27048
[NAME] University | 45551 | 66766 | 69418 | 52277 | 75949
Montana State University - Bozeman | 60794 | U/A | U/A | 15089 | U/A | U/A
North Dakota State University - Main Campus | 16300 | U/A | 36546 | U/A | U/A | U/A
University of Maine | 7004 | 58300 | 68162 | 17480 | 18045
University of New Hampshire - Main Campus | U/A | 59398 | 54507 | 37413 | 35277 | U/A
University of Vermont and State Ag. Coll. | 18892 | U/A | 35665 | 50866 | 55449
University of Wyoming | 37599 | 15756 | 68221 | 72617 | 75488
Source: ACRLMetrics
Revised: May 30, 2012, ajr
Spreadsheet: 5698d1ba-7392-4749-a4da-5833bc9f7783
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42246011 | 2014-07-10 21:28:48 | ALLIES | 0 | 2 | 5 | 716436 | Droopy007 | 12499 | western | 1944-06-13 | 1944-06-13 | Carentan | Carentan
42246314 | 2014-07-10 22:03:17 | AXIS | 0 | 4 | 5 | 716436 | Droopy007 | 12499 | western | 1944-06-13 | 1944-06-13 | Carentan | Carentan
42259588 | 2014-07-11 21:54:01 | ALLIES | 1 | 5 | 1 | 1422784 | flarchi | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
42274047 | 2014-07-12 21:39:23 | AXIS | 1 | 6 | 3 | 1603899 | Unrealik263 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
42274259 | 2014-07-12 21:55:00 | ALLIES | 1 | 6 | 2 | 1603899 | Unrealik263 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
Spreadsheet: 197182d1354234171-return-the-sum-of-the-two-highes-values-or-the-single-value-score-board-1-scorecopy-copy
Sheet: Sheet2

Color | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Position | Total
Yellow | 3 | 3 |  |  |  |  |  |  |  |  | tied for 4th | 6
Blue | 3 | 3 | 1 |  |  |  |  |  |  |  | tied for 4th | 6
Green | 3 | 4 | 3 |  |  |  |  |  |  |  | 3rd | 7
White | 3 | 5 | 3 |  |  |  |  |  |  |  | 2nd | 8
Black | 3 | 6 | 3 | 4 |  |  |  |  |  |  | 1st | 10
skin | 0 | 1 |  |  |  |  |  |  |  |  | 6th | 1
[NAME] | 5 |  |  |  |  |  |  |  |  |  |  | 5