tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 775731d1649279614-sumifs-formula-with-variable-column-linefcsts22plan-example
Sheet: Formula Tables

HRLY Table
[NAME] | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun
622 | CO:CO | CP:CP | CQ:[NAME] | CR:CR | CS:CS | CT:CT | CU:CU | [NAME]:[NAME] | CW:CW | CX:CX | CY:CY | CZ:CZ
623 | BZ:BZ | CA:CA | CB:CB | CC:CC | CD:CD | CE:CE | CF:CF | CG:CG | CH:CH | CI:CI | CJ:CJ | CK:CK
635 | GR:GR | GS:GS | GT:GT | GU:GU | GV:GV | GW:GW | GX:GX | GY:GY | GZ:GZ | HA:HA | HB:HB | HC:HC
636 | DE:DE | DF:DF | DG:DG | DH:DH | [NAME]:DI | DJ:DJ | DK:DK | DL:DL | DM:DM | DN:DN | DO:DO | DP:DP
637 | DY:DY | DZ:DZ | EA:EA | EB:EB | EC:EC | ED:ED | EE:EE | EF:EF | EG:EG | EH:EH | EI:EI | EJ:EJ
638 | HG:HG | HH:HH | HI:HI | HJ:HJ | HK:HK | HL:HL | HM:HM | HN:HN | HO:HO | HP:HP | HQ:HQ | HR:HR
639 | EI:EI | EJ:EJ | EK:EK | EL:EL | EM:EM | EN:EN | EO:EO | EP:EP | [NAME]:EQ | ER:ER | ES:ES | ET:ET
641 | EY:EY | EZ:EZ | FA:FA | FB:FB | FC:FC | FD:FD | FE:FE | FF:FF | FG:FG | FH:FH | FI:FI | FJ:FJ
643 | FN:FN | FO:FO | FP:FP | FQ:FQ | FR:FR | FS:FS | FT:FT | FU:FU | FV:FV | FW:FW | FX:FX | FY:FY
645 | GC:GC | [NAME]:[NAME] | GE:GE | GF:GF | GG:GG | GH:GH | GI:GI | GJ:GJ | GK:GK | GL:GL | GM:GM | GN:GN
64C | JM:JM | JN:JN | JO:JO | JP:JP | JQ:JQ | JR:JR | JS:JS | [NAME]:JT | JU:JU | JV:JV | JW:JW | JX:JX
HRLY SPLT TABLE
[NAME] | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun
080 | BZ:BZ | CA:CA | CB:CB | CC:CC | CD:CD | CE:CE | CF:CF | CG:CG | CH:CH | CI:CI | CJ:CJ | CK:CK
Spreadsheet: 841979d1694087665-change-the-second-transaction-entry-ticket-no-wise-same-ticket-id-with-followup-ticket
Sheet: Sheet1

Ticket no | Query | Output
60001 | Abcs | New Ticket
60002 | [NAME] | New Ticket
60001 | ddd | Followup
60002 | ddd | Followup
60001 | dd | Followup
60003 | kkk | New Ticket
Spreadsheet: 26319d1218468232-fields-not-filtering-properly-when-using-list-feature-attdn-temp-post
Sheet: Detail

 | Category | Description |  |  | Key/Legend (MAX 30)
 | 1 | Senior Management |  | F
 | 2 | Senior Staff |  | FL
 | 3 | Field Staff |  | FA
 | 4 | Non-Human Assets & Equipment |  | FLA
 |  |  |  | T
 |  |  |  | L
 |  |  |  | U
 |  |  |  | C
 |  |  |  | CO
 |  |  |  | S
 |  |  |  | V
 |  |  |  | B
 |  |  |  | A
 |  |  |  | Rsn
 |  |  |  | D
 |  |  |  | Rpr
Spreadsheet: 67814d1268328801-formula-to-return-value-based-on-category-available-hours
Sheet: Sheet1

Output table |  |  | Gregs weekly condition |  | Category lookup | Set hours to train
[NAME] |  | Greg | Week1 | Healthy | Conditon | Training hours per week
Week 1 |  | Greg | Week2 | Healthy | Healthy | Week 1 | 30
Greg |  | Greg | Week3 | Injured | Injured | Week 2 | 28
Set training hours | IF(VLOOKUP(A4,C:E,3,0),=F:F,H3),=F:F,H3-B6),=F:F,0) | Greg | Week4 | Quit | Quit | Week 3 | 25
Hours injured | 0 |  |  |  |  | Week 4 | 31
Actual training hours | #N/A
Week 2
Greg
Set training hours | IF(VLOOKUP(A4,C:E,3,0),=F:F,H3),=F:F,H3-B6),=F:F,0)
Hours injured | 0
Actual training hours | #N/A
Week 3
Greg
Set training hours | IF(VLOOKUP(A4,C:E,3,0),=F:F,H3),=F:F,H3-B6),=F:F,0)
Hours injured | 5
Actual training hours | #N/A
Week 4 (Quit)
Greg |  |  | (Worksheet 2) |  |  | (Worksheet 3)
Set training hours
Hours injured | 0
Actual training hours | 0
(Worksheet 1)
Below is the IF/Vlookup statement I've tried without any luck. Thi formula will go in cells B5, B10, B15, [NAME].
IF(VLOOKUP(A4,C:E,3,0),=F:F,H3),=F:F,H3-B6),=F:F,0)
If [NAME] is healthy he is available to train 30 hours per week if hes injured hes available the 30 hours per week minus the 5 hours injured (25 hours) if he has Quit then his hours to train are zero
Spreadsheet: 875247d1721831157-formula-to-return-name-of-fastest-person-for-particular-code-and-their-best-time-jake_fielder-book1-350-for-365-aligw
Sheet: Sheet1

code | name | mins |  | enter code: | 204085
204086 | LM | 6 |  | fastest person |  | this formula looks for the for the quickest time for the above code and returns the name
224668 | MS | 3.75 |  | their time | 6 | this formular returns the time from the same row as the above
204085 | LM | 6 |  | 2nd fastest | MS | this formula excludes the above name and finds the 2nd fastest person
224580 | MS | 37.5 |  | their time | 6.6 | this formula returns the fastest time of the 2nd fastest person
223830 | LM | 12
223639 | MS | 5.399999999999999
223626 | MS | 3
204085 | LM | 6.5
223032 | MS | 21
224663 | MM | 0.575
222774 | LM | 12
224627 | MS | 4
222843 | MM | 0.4166666666666667
224627 | MS | 4.5
207175 | LM | 18
204085 | MS | 6.6
224467 | MS | 27
224346 | MM | 0.1
224231 | MM | 1.25
224231 | MM | 1.25
Spreadsheet: 60698d1261211673-find-exact-or-closest-lower-date-book4
Sheet: Sheet1

 | NOT SORTED |  |  |  | EXPECTED
C | 2009-11-04 00:00:00 |  | C | 2009-04-01 00:00:00 | 3
C | 2009-11-03 00:00:00 |  | C | 2009-11-02 00:00:00 | 2
C | 2009-05-04 00:00:00 |  | C | 2009-04-05 00:00:00 | 3
D | 2009-04-27 00:00:00 |  | C | 2009-05-06 00:00:00 | 11
D | 2009-04-05 00:00:00 |  | C | 2009-10-02 00:00:00 | 6
D | 2009-10-02 00:00:00 |  | D | 2009-04-26 00:00:00 | 4
D | 2009-10-01 00:00:00 |  | D | 2009-04-28 00:00:00 | 8
D | 2009-06-04 00:00:00 |  | E | 2009-04-11 00:00:00 | 11
E | 2009-05-15 00:00:00 |  | E | 2009-04-04 00:00:00 | 12
E | 2009-05-14 00:00:00 |  | E | 2009-04-02 00:00:00 | 12
E | 2009-05-11 00:00:00
E | 2009-04-04 00:00:00
 |  |  | I am looking for a formula to return the expected row/location in range B2:B13 as shown in col. F
 |  |  | Col. B dates are and cannot be sorted
 |  |  | The idea is to find the exact or the closest lower date to those in col. E
 |  |  | as per 2 criterias (col. D+E)
 |  |  | I prefer no helper column and no macro
 |  |  | Thanks, Elm
Spreadsheet: 35970d1233705676-excel-2007-formatting-issue-when-linking-a-column-s-of-data-to-other-excel-files-discrete-measures
Sheet: T@C

Level | 25PE | 25CS | 5PE | 5CS | 75PE | 75CS | 10PE | 10CS | 15PE | 15CS
Spreadsheet: 061000a3-1c3e-4d35-af9a-09fc18393c1f
Sheet: Sheet1

 | SIX-WEEK SUMMER I - beginning 5/13/2014
1854 | WGS | 200 | 19Z1 | Intro to Wmen's Gnd Std Soc Sc | Online | WWW | 2014-05-13 00:00:00 | 2014-06-24 00:00:00 | BW | TBA | Womack, Becky
1855 | WGS | 201 | 19Z1 | [NAME] [NAME] | Online | WWW | 2014-05-13 00:00:00 | 2014-06-24 00:00:00 | BW | TBA | Houghton, [NAME]
1856 | WGS | 201 | 19Z2 | [NAME] [NAME] | Online | WWW | 2014-05-13 00:00:00 | 2014-06-24 00:00:00 | BW | TBA | King, [NAME]
1817 | ENG | 234 | 19Z1 | [NAME] to Women's Literature | Online | WWW | 2014-05-13 00:00:00 | 2014-06-24 00:00:00 | BW | TBA | Houghton, [NAME]
 | SIX-WEEK SUMMER II - beginning 6/26/2014
1851 | WGS | 200 | 19Z2 | Intro to Wmen's Gnd Std Soc Sc | Online | WWW | 2014-06-26 00:00:00 | 2014-08-07 00:00:00 | BW | TBA | Womack, Becky
1857 | WGS | 201 | 19Z3 | [NAME] [NAME] | Online | WWW | 2014-06-26 00:00:00 | 2014-08-07 00:00:00 | BW | TBA | Houghton, [NAME]
1858 | WGS | 201 | 19Z4 | [NAME] [NAME] | Online | WWW | 2014-06-26 00:00:00 | 2014-08-07 00:00:00 | BW | TBA | STAFF
Spreadsheet: shelley_corman__38749__Cashinoutmajorityminority
Sheet: Jan 2001

January 2001 Production Month
Cash In\Out After Bookout | 26 | Majority is Due Shippers
 | 15 | Minority is Due FGT
le_nm | [NAME] | inv_amt | sum_mmbtu_qty
ADAMS RESOURCES MARKETING, LTD. | CIO | -10832.3 | -1327
CHESAPEAKE UTILITIES CORPORATION | CIO | -214442.01 | -23643
DUKE ENERGY TRADING AND MARKETING,L.L.C. | CIO | -944005.6 | -104080
DYNEGY GAS TRANSPORTATION, INC. | CIO | -221766.35 | -21908
ENRON NORTH AMERICA CORP. | CIO | -85693.36 | -9448
FLORIDA GAS UTILITY | CIO | -304659.16 | -33545
FLORIDA POWER AND LIGHT COMPANY | CIO | -3413195.19 | -376317
FLORIDA POWER CORPORATION | CIO | -753608.16 | -83088
FLORIDA PUBLIC UTILITIES COMPANY | CIO | -44597.19 | -4917
INFINITE ENERGY, INC. | CIO | -2359998.58 | -260744
LAFARGE GYPSUM | CIO | -25166.53 | -3083
LAKELAND, CITY OF | CIO | -73476.07 | -8101
MIRANT AMERICAS ENERGY MARKETING, LP | CIO | -816.3 | -90
NATIONAL GYPSUM COMPANY | CIO | -17459.75 | -1925
NUI CORPORATION | CIO | -76278.7 | -8410
ORLANDO COGEN FUEL, INC | CIO | -171640.68 | -18924
ORLANDO UTILITIES COMMISSION | CIO | -32470.6 | -3580
PEOPLES GAS SYSTEM, A DIVISION OF TAMPA | CIO | -109230.01 | -12043
PRIOR INTRASTATE CORPORATION | CIO | -30955.91 | -3413
REEDY CREEK IMPROVEMENT DISTRICT | CIO | -66165.65 | -7295
RELIANT ENERGY SERVICES, INC. | CIO | -6829.71 | -753
SOUTH FLORIDA NATURAL GAS, INC. | CIO | -22321.27 | -2461
SOUTHEAST ALABAMA GAS DISTRICT | CIO | -28153.28 | -3104
ST. JOE NATURAL GAS COMPANY | CIO | -45059.76 | -4968
TALLAHASSEE, CITY OF | CIO | -234223.68 | -25824
UNOCAL ENERGY TRADING, INC. | CIO | -27.21 | -3
Total Due 26 Shippers
ALABAMA POWER COMPANY | CIO | 43611.89 | 4743
ANHEUSER BUSCH COMPANIES, INC | CIO | 12553.54 | 1366
BAPTIST MEDICAL CENTER | CIO | 9.19 | 1
BP ENERGY COMPANY | CIO | 1874.76 | 204
CINERGY MARKETING & TRADING, LLC | CIO | 83610.07 | 7528
CITRUS TRADING CORPORATION | CIO | 122392.42 | 13318
CLARKE-MOBILE COUNTIES GAS DISTRICT | CIO | 32313.77 | 3503
COASTAL MERCHANT ENERGY, L.P. | CIO | 173132.19 | 15623
CORAL ENERGY RESOURCES, L.P. | CIO | 9.19 | 1
EL PASO MERCHANT ENERGY, L.P. | CIO | 18361.62 | 1998
[NAME], L.P. | CIO | 8619.45 | 897
HIGHLAND ENERGY COMPANY OF TEXAS | CIO | 66.17 | 6
NOBLE GAS MARKETING, INC. | CIO | 3676 | 400
VAIL TRADING COMPANY | CIO | 70348.53 | 6959
VASTAR GAS MARKETING, INC. | CIO | 110.28 | 12
Total Due FGT  15 Shippers
Spreadsheet: 86392d1286382856-need-to-count-productivity-by-weekly-and-daily-basis-qc-report
Sheet: Summary

 |  |  | SUMMARY
Reported Date is : | 2010-10-06 00:00:00 |  | Monthly Period |  | 2010-10-01 00:00:00 |  | To
Reported Date is : | 2010-10-06 00:00:00 |  | Weekly Period |  | 2010-10-04 00:00:00 |  | To | 2010-10-06 00:00:00
Monthly | Total Files | Completed | Cancelled | In process
FTS ([NAME])
[NAME]
Weekly | Total Files | Completed | Cancelled | In process
FTS ([NAME])
[NAME]
Daily | Total Files | Completed | Cancelled | In process
FTS ([NAME])
[NAME]
Spreadsheet: 56415d1256623406-excel-2007-training-tracker-and-due-dates-example
Sheet: Sheet1

Employee | First responder | First Aid | SBA
[NAME] | 2009-01-01 00:00:00 | 2008-12-01 00:00:00 | 2008-11-10 00:00:00
[NAME] | 2009-09-01 00:00:00 | 2009-09-01 00:00:00
[NAME] | 2009-08-31 00:00:00 | 2008-01-11 00:00:00
Chester | 2008-01-12 00:00:00 | 2008-05-22 00:00:00
[NAME] | 2009-05-04 00:00:00 | 2009-08-07 00:00:00
 | 2009-08-31 00:00:00 | 2009-08-07 00:00:00 | 2008-08-19 00:00:00
Spreadsheet: tracy_geaccone__40235__enron corp infomation request-egas
Sheet: EBS EXP

 |  | October |  | November |  | December |  | January |  | February |  | March | Total | Comments
Salaries
Benefits
Payroll Taxes
Corporate Allocations & Other
Travel
Employee-Related Communications
Other Employee Expenses
Supplies and Computer Expenses
Rent & Utilities
Other
Subtotal
Depreciation
Amortizations
Taxes Other Than Income
Outside Services
Rent & Utilities
Advertising
Other |  | 1e-09 | 1e-09 | 1e-09 |  | 1e-09 |  | 1e-09 |  | 1e-09 |  | 1e-09
Subtotal
2001 Forecast Expense
Spreadsheet: 217671d1362148171-how-to-get-table-just-clicking-a-list-down-button-sample
Sheet: Sheet1

 | January | Date | Expense | Amount |  | Month | Mar | Date | Expense | Amount
 |  | 1 | Petrol | 50 |  |  |  | 1 | Petrol | 50
 |  | 2 | Food | 100
 |  | 3 | Travel | 60
 | Feb | Date | Expense | Amount
 |  | 1 | Petrol | 50
 |  | 2 | Food | 100
 |  | 3 | Travel | 60
 | Mar | Date | Expense | Amount
 |  | 1 | Petrol | 50
Spreadsheet: monika_causholli__28174__Fluff Correlations
Sheet: Sheet2

 |  |  |  |  |  |  |  | Annual:
 |  |  |  |  |  |  |  |  | Fluff vs NBSK | Fluff vs SBSK
 | NBSK | NBSK Changes | SBSK | SBSK Changes | Fluff | Fluff Changes |  | Correlation
1983 | 430.8333333333333 |  | 393.75 |  | 466.25
1984 | 513.3333333333334 |  | 487.5 |  | 537.5 |  |  | R Square
1985 | 426.6666666666667 |  | 377.5 |  | 463.3333333333333
1986 | 460.8333333333333 |  | 432.5 |  | 488.75
1987 | 577.5 |  | 551.25 |  | 583.75
1988 | 712.5 |  | 687.5 |  | 713.75 |  |  | Monthly:
1989 | 822.5 |  | 790.8333333333334 |  | 822.5 |  |  | Correlation | 0.7751003572353607 | 0.7619205791302884
1990 | 787.0833333333334 |  | 660.4166666666666 |  | 780.8333333333334
1991 | 568.3333333333334 |  | 490.4166666666667 |  | 666.25 |  |  | R Square
1992 | 551.25 |  | 507.9166666666667 |  | 658.75
1993 | 445.4166666666667 |  | 375.8333333333333 |  | 612.0833333333334
1994 | 566.25 |  | 524.1666666666666 |  | 573.75
1995 | 876.6666666666666 |  | 830.4166666666666 |  | 880.8333333333334
1996 | 599.5833333333334 |  | 527.9166666666666 |  | 589.1666666666666
1997 | 591.6666666666666 |  | 526.25 |  | 554.1666666666666
1998 | 543.75 |  | 492.9166666666667 |  | 528.3333333333334
1999 | 541.6666666666666 |  | 513.75 |  | 548.75
2000 | 685 |  | 664.1666666666666 |  | 726.6666666666666
2001 | 612.5 |  | 555 |  | 660
Spreadsheet: errol_mclaughlin_jr__10063__TAGG_ERMS Contacts
Sheet: Sheet1

TAGG/ERMS | Erms/Tagg On-Call Pager | [PHONE]
Management |  | Phone Number
[NAME] |  | x30573
[NAME] |  | x35906
[NAME] |  | x57252
PortCalc
[NAME] |  | x53853
[NAME] |  | x53360
Reporting - Oracle Reports & Excel
[NAME] |  | x33587
[NAME] |  | x31600
[NAME] |  | [NAME]
ERV/TRV
[NAME] |  | x53707
Sanjesh Pathak |  | x57438
GUI - Oracle Forms
[NAME] |  | x33587
[NAME] |  | x31600
GUI - PowerBuilder
[NAME] |  | x53361
[NAME] |  | x53816
MetaCalc, Translator, Settlement
[NAME] |  | x53416
[NAME] |  | x34811
Web
[NAME] | Infrastructure | x33587
[NAME] | Reporting | x31600
[NAME] | Reporting | [NAME]
[NAME] | ASP | x53361
[NAME] | ASP | x53816
Downloads - Exchange Futures & Options, Gas Daily
[NAME] |  | x53362
[NAME] |  | [NAME]
Bridge
[NAME] |  | x53361
[NAME] |  | x53362
[NAME] |  | x34811
New Books & Commodities, User Access
[NAME] |  | x53362
[NAME] |  | [NAME]
Deal Moves, Counterparty Changes
[NAME] |  | x53816
[NAME] |  | x53361
Database & System Maintenance
[NAME] | System/Prod. Coord. | x53416
[NAME] | Database | x53816
PostId Archive & Restore
[NAME] |  | x53416
[NAME] |  | [NAME]
Spreadsheet: fedd15c0-67cf-411f-965c-5ead7d03ee32
Sheet: Sheet1

2002-11-05 00:00:00 | Sheriff | Attorney | Treasurer | Register of Deeds | Register of Probate
Belknap           County                County Officers | Collis, r&d | Noether, r&d | Corbin, r | Normandin, r&d | Dearborn, r&d
Alton | 1697 | 1675 | 1583 | 1698 | 1687
Barnstead | 1279 | 1273 | 1083 | 1281 | 1280
Belmont | 1927 | 1893 | 1728 | 1941 | 1921
Center Harbor | 473 | 469 | 434 | 475 | 474
Gilford | 2902 | 2834 | 2566 | 2888 | 2868
Gilmanton | 1156 | 1148 | 1032 | 1158 | 1149
[NAME] | 1169 | 1125 | 1034 | 1153 | 1143
[NAME] | 792 | 766 | 679 | 788 | 786
[NAME] 3 | 761 | 752 | 635 | 756 | 752
[NAME] | 839 | 805 | 705 | 837 | 834
[NAME] | 650 | 628 | 550 | 655 | 650
[NAME] 6 | 821 | 785 | 719 | 817 | 810
Meredith | 2354 | 2306 | 2073 | 2325 | 2313
New Hampton | 709 | 704 | 630 | 712 | 709
Sanbornton | 1065 | 1048 | 915 | 1053 | 1046
[NAME] | 978 | 964 | 810 | 974 | 968
TOTALS | 19572 | 19175 | 17176 | 19511 | 19390
 | County Commissioners
 | District No. 1 |  | District No. 2 |  | District No. 3
 | Daigneault, r |  | Thurston, r
Alton |  |  |  |  | No Election
Barnstead |  |  | 971
Belmont |  |  | 1708
Center Harbor
Gilford
Gilmanton |  |  | 965
[NAME] | 956
[NAME] | 627
[NAME] 3 | 601
[NAME] | 663
[NAME] | 512
[NAME] 6 | 685
Meredith
New Hampton
Sanbornton |  |  | 862
[NAME] |  |  | 811
TOTALS | 4044 |  | 5317
Spreadsheet: 861187d1709136786-sort-two-columns-so-that-matching-numbers-line-up-in-rows-example-desired-sort-results
Sheet: Sheet1

Before Custom Sort |  |  | After [NAME]
Column 1 | Column 2 |  | Column 1 | Column 2
1 | 1 |  | 1 | 1
3 | 2 |  |  | 2
6 | 5 |  | 3
7 | 6 |  |  | 5
8 | 8 |  | 6 | 6
 | 0 |  | 7
 |  |  | 8 | 8
 |  |  |  | 0
Spreadsheet: 45315d1244074496-help-with-a-formula-project-analysis
Sheet: Expenses

 |  |  | Expense Sheet
 |  |  | Discription |  | Expense Type | Amount | Project
 |  |  | Paper |  | Printing | 5 | Project X |  | [NAME]
 |  |  | Ink |  | Printing | 3 | Project Y |  | [NAME]
 |  |  | Taxi |  | Travel | 10 | Project Z |  | Project ZTravel
 |  |  | Pens |  | Materials | 2 | Project Z |  | Project ZMaterials
 |  |  | Train |  | Travel | 5 | Project Y |  | Project YTravel
 |  |  | Train |  | Travel | 10 | Project X |  | Project XTravel
 |  |  | Files |  | Materials | 25 | Project Z |  | Project ZMaterials
Spreadsheet: a397852c-4295-43cd-bd27-1409195f4139
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
7168 | 7463 | [NAME] | [NAME] | VEN | 14 | 00:08:11 | 00:00:30 | 00:13:58 | 00:00:48 | 00:09:34 | 2 | 00:33:00
7168 | 39542 | Iuri | Vinuto Josino | BRA | 12 | 00:07:41 | 00:00:27 | 00:14:00 | 00:00:52 | 00:09:02 | 1 | 00:31:59
Spreadsheet: 833405d1686939609-formula-to-calculate-difference-between-a-day-number-and-the-current-date-book01
Sheet: Sheet1

 | Day of the Month Number (not a date) |  | [NAME] to calculate TRUE only if Day Number is within 0 to 2 days prior to today's/current date
 | 5
 | 7
 | 8
 | 10
 | 11
 | 15
 | 15
 | 17
 | 20
 | 21
 | 22
 | 25
 | 29
 | Should look like this
 | 10 |  | False
 | 13
 | 15
 | 16 |  | True
 | 17 |  | True
 | 19 |  | False
Spreadsheet: 730925d1620052352-highest-to-6-scores-from-8-weeks-don-kitchen-new
Sheet: Data

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank Helper
 | Names | Week One | Week Two | Week Three | Week Four | Week Five | Week Six | Week Seven | Week Eight |  | Total Scores for 8 weeks |  | Best 6 Scores from 8 weeks |  | Top 15 0verall Players Score |  |  |  | Players Score                  Highest top 6 scores from 8 weeks
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Top 8 Players
 | D Frith | 15 | 14 | 13 | 7 | 15 | 12 | 14
 | P Carter | 15 | 12 | 15 | 17 | 0 | 9 | 8 |  |  |  |  |  |  |  |  |  |  | 84
 | T Seymore | 15 | 15 | 14 | 17 | 0 | 9 | 14 |  |  |  |  |  |  |  |  |  |  | 83
 | A Terry | 14 | 15 | 9 | 17 | 9 | 9 | 16 |  |  |  |  |  |  |  |  |  |  | 80
 | J Vince | 14 | 10 | 9 | 13 | 13 | 12 | 6 |  |  |  |  |  |  |  |  |  |  | 79
 | M Frith | 14 | 8 | 7 | 10 | 0 | 10 | 11 |  |  |  |  |  |  |  |  |  |  | 77
 | [NAME] | 12 | 8 | 0 | 0 | 13 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 77
 | M Micklefield | 12 | 10 | 7 | 15 | 7 | 0 | 16 |  |  |  |  |  |  |  |  |  |  | 76
 | K Ellis | 12 | 15 | 7 | 0 | 0 | 0 | 0
 | K Lester | 12 | 11 | 15 | 15 | 17 | 13 | 16
 | C Medlin | 12 | 0 | 0 | 0 | 0 | 0 | 0
 | K De Veen | 12 | 12 | 15 | 7 | 3 | 13 | 6
 | J Thompson | 12 | 12 | 7 | 13 | 15 | 10 | 8
 | K  Thompson | 12 | 14 | 9 | 7 | 5 | 12 | 0
 | G Godhard | 12 | 7 | 14 | 12 | 0 | 0 | 0
 | L Lester | 12 | 11 | 8 | 10 | 19 | 13 | 14
 | L Harvey | 10 | 0 | 7 | 0 | 5 | 0 | 0
 | S Kinson | 10 | 15 | 15 | 5 | 0 | 13 | 14
 | C Micklefield | 10 | 15 | 15 | 15 | 9 | 13 | 6
 | D Bridges | 10 | 0 | 0 | 0 | 0 | 0 | 0
 | H De Veen | 10 | 15 | 13 | 5 | 19 | 12 | 8
 | L Bray | 10 | 7 | 8 | 7 | 7 | 9 | 0
 | W Seymore | 10 | 11 | 15 | 12 | 0 | 9 | 6
 | M Bray | 10 | 7 | 14 | 7 | 9 | 9 | 8
 | G Atkinson | 10 | 11 | 7 | 15 | 13 | 12 | 11
 | [NAME] | 10 | 8 | 8 | 11 | 17 | 0 | 11
 | D Ebdon | 8 | 15 | 15 | 15 | 3 | 10 | 11
 | J Sunderland | 8 | 11 | 15 | 0 | 3 | 10 | 6
 | A Levelle | 8 | 7 | 7 | 15 | 0 | 13 | 16
 | B Green | 7 | 11 | 13 | 11 | 0 | 12 | 11
 | C Laverty | 7 | 0 | 7 | 7 | 0 | 10 | 11
 | D Colquhoun | 7 | 8 | 7 | 0 | 19 | 0 | 0
 | M Holmes |  | 15 | 0 | 0 | 0 | 0 | 0
 | K Burnam | 0 | 7 | 0 | 0 | 0 | 0 | 0
 | [NAME] | 0 | 8 | 15 | 5 | 0 | 0 | 0
 | ? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | ? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | ? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | ? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | ? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 770419d1646058623-formula-for-summing-columns-with-same-header-by-each-row-sample
Sheet: Sheet1

Department | Life AD&D | Dental | Dental | Dental | Life AD&D | Life AD&D | Life AD&D | Short-Term Diability | Long-Term Disability | Life AD&D | Dental | Dental | Vision | Vision
200 | 60.75 | 4.5 | 69.24 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20.2 | 0 | 25.4 | 0
300 | 47.25 | 3.5 | 0 | 0 | 31.73 | 5.75 | 0 | 0 | 6 | 16.94 | 50.5 | 0 | 19.05 | 0
400 | 20.25 | 1.5 | 69.24 | 0 | 29.4 | 5 | 0 | 0 | 44.09 | 0 | 10.1 | 0 | 19.05 | 0
500 | 222.75 | 16.5 | 311.58 | 33.54 | 298.36 | 21.5 | 43.35 | 2.04 | 228.25 | 170 | 171.7 | 11.97 | 114.3 | 7.62
600 | 20.25 | 1.5 | 0 | 0 | 0 | 0 | 0 | 0 | 76.66 | 0 | 0 | 0 | 6.35 | 0
700 | 6.75 | 0.5 | 34.62 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6.35 | 0
800 | 6.75 | 0.5 | 0 | 0 | 16.3 | 2.5 | 0 | 0 | 0 | 0 | 10.1 | 0 | 0 | 0
900 | 13.5 | 1 | 34.62 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10.1 | 0 | 12.7 | 0
1000 | 27 | 2 | 34.62 | 0 | 13.04 | 2 | 0 | 0 | 21.08 | 44.16 | 20.2 | 0 | 12.7 | 0
1100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total | 479.25 | 35.5 | 588.54 | 33.54 | 411.73 | 39.25 | 43.35 | 2.04 | 376.08 | 315.21 | 333.3 | 23.94 | 241.2999999999999 | 7.62
Spreadsheet: 069a3504-56b2-42b9-ab27-495bc819aab7
Sheet: Sheet1

CIRCLE ONE: |  | CIRCLE ONE: |  |  |  | SPORT |  |  | SCHOOL |  |  |  |  | DATE
GENDER: BOYS / GIRLS |  | LEVEL: 7TH / 8TH
YOUR SCORE | OPPONENT | THEIR SCORE | YOUR WIN? | YOUR LOSS? |  | YOUR SCORE | OPPONENT | THEIR SCORE | YOUR WIN? | YOUR LOSS? |  | YOUR SCORE? | OPPONENT | THEIR SCORE | YOUR WIN? | YOUR LOSS?
SCRIMMAGES |  |  |  |  |  | ZONE GAMES |  |  |  |  |  | TOURNAMENTS
 | 1 |  |  |  |  |  | 1 |  |  |  |  |  | 1
 | 2 |  |  |  |  |  | 2 |  |  |  |  |  | 2
 | 3 |  |  |  |  |  | 3 |  |  |  |  |  | 3
 |  |  |  |  |  |  | 4 |  |  |  |  |  | 4
 |  |  |  |  |  |  | 5 |  |  |  |  |  | 5
 |  |  |  |  |  |  | 6 |  |  |  |  |  | 6
 |  |  |  |  |  |  | 7
 |  |  |  |  |  | SUB TOTAL OF WON/LOST                        ZONE GAMES
 |  |  |  |  |  | PLACED _____________ IN ZONE
 |  |  |  |  |  | (IF NECESSARY, PLAYOFF GAME FOR ZONE TIE)
TOTAL OF WON AND LOST NON ZONE GAMES |  |  |  |  |  | GRAND TOTAL OF       WON/LOST ZONE GAMES |  |  |  |  |  | PLACE IN TOURNAMENT
ZONE  WON/LOST?
COACH: |  |  |  |  |  |  | COORDINATOR:
** PLEASE USE SEPARATE SHEET FOR EACH TEAM (7A, 7B, 8A, 8B) |  |  |  |  |  |  |  |  |  |  |  |  |  | PAD:FORMS/M.S.WIN/LOSS
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Revised 10-08-10/dp
Spreadsheet: 827745d1683014719-average-timings-exercise-sample
Sheet: Cases

Category | Sale Date | Letter to Authority | Authority Response | Cash Received | Letter To External | Receive by External
[NAME] | 2023-03-15 00:00:00 | 2023-03-16 00:00:00 | 2023-03-18 00:00:00 | 2023-04-03 00:00:00 | 2023-03-30 00:00:00 | 2023-04-10 00:00:00
Lim | 2023-03-30 00:00:00 | 2023-03-31 00:00:00 | 2023-04-05 00:00:00 | 2023-04-19 00:00:00 | 2023-04-20 00:00:00 | 2023-04-28 00:00:00
Paf | 2023-04-10 00:00:00 | 2023-04-11 00:00:00 | 2023-04-24 00:00:00 | 2023-04-12 00:00:00 | 2023-04-25 00:00:00 | 2023-04-30 00:00:00
Lar | 2023-04-12 00:00:00 | 2023-04-12 00:00:00 | 2023-04-15 00:00:00 | 2023-04-18 00:00:00 | 2023-04-20 00:00:00 | 2023-05-01 00:00:00
Amm | 2023-02-02 00:00:00 | 2023-02-06 00:00:00 | 2023-02-23 00:00:00 | 2023-02-13 00:00:00 | 2023-03-03 00:00:00 | 2023-03-07 00:00:00
 |  |  |  | PLEASE NOTE THAT THIS IS A SAMPLE. THE ACTUAL FILE HAS MORE THAN 250 ENTRIES.