tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 856697d1705918479-conditional-formatting-not-applying-to-cells-with-formula-receipted_for_forum
Sheet: MONTH

 |  | RETURNS |  |  |  |  |  |  | PROCESSED |  |  |  |  |  |  | FAST TRACKS |  |  |  |  |  | REJECTS
 | MONTH | TRAYS IN | SUPPS IN | TOTAL IN | INSTRUMENT TOTAL IN |  |  | MONTH | TRAYS OUT | SUPPS OUT | TOTAL OUT | INSTRUMENT TOTAL OUT |  |  | MONTH | FAST TRACKS | PERCENTAGE |  |  | MONTH | DIRTY | DIRTY % | BYPASSED | BYPASSED % | RUSTY | RUSTY % | TOTAL | TOTAL % |  |  | MONTH | TURNAROUND TIME
 | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME] | 1464 |  |  |  | [NAME] | 369 |  | 366 |  | 64 |  |  |  |  |  | [NAME] | 1 day, 22:38:00
 | APRIL |  |  |  |  |  |  | APRIL |  |  |  |  |  |  | APRIL | 611 |  |  |  | APRIL | 277 |  | 270 |  | 47 |  |  |  |  |  | APRIL | 1 day, 18:34:00
 | MAY |  |  |  |  |  |  | MAY |  |  |  |  |  |  | MAY | 1016 |  |  |  | MAY | 383 |  | 178 |  | 40 |  |  |  |  |  | MAY | 1 day, 21:35:00
 | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME] | 964 |  |  |  | [NAME] | 387 |  | 161 |  | 66 |  |  |  |  |  | [NAME] | 1 day, 20:32:00
 | JULY |  |  |  |  |  |  | JULY |  |  |  |  |  |  | JULY | 943 |  |  |  | JULY | 403 |  | 167 |  | 91 |  |  |  |  |  | JULY | 1 day, 23:49:00
 | AUGUST |  |  |  |  |  |  | AUGUST |  |  |  |  |  |  | AUGUST | 710 |  |  |  | AUGUST | 343 |  | 117 |  | 60 |  |  |  |  |  | AUGUST | 1 day, 23:44:00
 | SEPTEMBER |  |  |  |  |  |  | SEPTEMBER |  |  |  |  |  |  | SEPTEMBER | 772 |  |  |  | SEPTEMBER | 426 |  | 128 |  | 101 |  |  |  |  |  | SEPTEMBER | 1 day, 23:40:00
 | OCTOBER |  |  |  |  |  |  | OCTOBER |  |  |  |  |  |  | OCTOBER |  |  |  |  | OCTOBER |  |  |  |  |  |  |  |  |  |  | OCTOBER
 | NOVEMBER |  |  |  |  |  |  | NOVEMBER |  |  |  |  |  |  | NOVEMBER |  |  |  |  | NOVEMBER |  |  |  |  |  |  |  |  |  |  | NOVEMBER
 | DECEMBER |  |  |  |  |  |  | DECEMBER |  |  |  |  |  |  | DECEMBER |  |  |  |  | DECEMBER |  |  |  |  |  |  |  |  |  |  | DECEMBER
 | JANUARY |  |  |  |  |  |  | JANUARY |  |  |  |  |  |  | JANUARY |  |  |  |  | JANUARY
 | FEBRUARY |  |  |  |  |  |  | FEBRUARY |  |  |  |  |  |  | FEBRUARY |  |  |  |  | FEBRUARY
 | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  | [NAME]
 | APRIL |  |  |  |  |  |  | APRIL |  |  |  |  |  |  | APRIL | 551 |  |  |  | APRIL | 322 |  | 116 |  | 60
 | MAY |  |  |  |  |  |  | MAY |  |  |  |  |  |  | MAY |  |  |  |  | MAY
 | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  | [NAME]
 | AVERAGE |  |  |  |  |  |  | AVERAGE |  |  |  |  |  |  | AVERAGE |  |  |  |  | AVERAGE |  |  |  |  |  |  |  |  |  |  | AVERAGE
Spreadsheet: darrell_schoolcraft__7334__imball0203
Sheet: SWGasTrans

 | SW Gas Transmission Co - contr27380
 | POI 78003 - TW/SGTC Mojave Del
Day | Measured | Scheduled
1 | -14215 | -14000
2 | -14170 | -14000
3 | -14559 | -14000
4 | -13643 | -14000
5 | -29174 | -29194
6 | -29132 | -28461
7 | -13949 | -14000
8 | -14162 | -14000
9 | -14099 | -14000
10 | -14081 | -14000
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-02-28 00:00:00 |  |  | -15719.76
2002-03-10 00:00:00
CBS Volume
 |  |  | 5419
Spreadsheet: 37018d1234958103-putting-a-formula-into-a-cell-if-it-falls-between-a-date-range-bakerd
Sheet: Sheet1

 |  |  |  |  |  | Month
Resource | % | start | end |  | Resource | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00
A | 10 | 2009-01-01 00:00:00 | 2009-03-01 00:00:00 |  | A | 0.1 | 0.1 | 0.1 | 0.05 | 0.05 | 0.05 | 0.05 | 0 | 0
A | 5 | 2009-04-01 00:00:00 | 2009-07-01 00:00:00 |  | B | 0 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0 | 0 | 0
B | 20 | 2009-02-01 00:00:00 | 2009-06-01 00:00:00
Spreadsheet: 487079d1477907239-sorting-and-colour-reading-age-cells-test-data
Sheet: Sheet1

CES Assessment Services | 919 6232 Manor Lodge School
CES Assessment Services | 1965
CES Assessment Services | 919 6232 Manor Lodge School
CES Assessment Services | 9
Upn | NGRT Digital RA Differenc Year 2
 | 0/5
 | 0/2
 | 0/2
 | -1/0
 | 1/1
 | 0/3
 | 0/2
 | 0/1
 | 1/6
 | 0/1
 | 0/5
 | -1/5
 | 1/2
 | -1/7
 | 0/8
 | 1/7
 | 0/11
 | 2/7
 | 2/1
 | 0/4
 | 1/9
 | -1/7
 | -1/7
 | 1/0
 | 1/1
 | 0/11
 | 0/5
 | 0/10
 | 0/5
 | -1/9
 | 3/5
 | 0/9
 | -1/6
 | 0/11
 | 0/2
 | 0/6
 | 0/8
 | 3/11
 | 1/1
 | 1/0
 | 0/4
 | 0/6
 | 2/1
 | 3/3
 | 0/7
 | 0/4
 | 2/9
 | 0/6
 | 0/9
 | 1/11
 | -1/7
 | 0/7
 | 0/9
 | 0/4
 | 0/9
 | 2/4
 | 1/1
 | 1/11
 | 0/3
 | 3/8
Spreadsheet: 164520d1340803133-excel-2007-trying-to-build-a-time-sheet-work-book-and-am-stuck-on-seperating-the-day-and-night-shift-new-project-pay-roll-and-time-sheet-beta-day-night-test
Sheet: Saturday Night Timesheeet

 |  |  | TRI TOOL INC.
 | Customer: |  |  |  |  |  |  |  |  | CUSTOMER CONTACT: |  |  |  |  |  | JOB NO: |  |  |  |  |  | Home Page
 | Work Location: |  |  |  |  |  |  |  |  | CUST. P.O. NO. |  |  |  |  |  | DATE:
 | Employee: |  |  |  |  | TOTAL HRS: |  | WORK [NAME]/WORK ORDER NO. |  |  |  |  |  |  |  |  | CONSUMABLES: |  |  |  |  | Payroll
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QUAN: | PART NO:
 |  |  |  |  | Verify the following SAFTY ITEM CHECKLIST as required on this site. |  |  |  |  |  |  |  |  | Equipment Usage: |  |  |  |  | Tech Initial
 |  | NO | YES
 |  |  |  | 1 | If required, has the site specific training been completed?
 |  |  |  | 2 | If permits are required, do you have the proper papers?
 |  |  |  | 3 | Is Scaffolding correct and safe?
 |  |  |  | 4 | If lockout is required, has the proper procedure been followed?
 |  |  |  | 5 | Do you know the emergency signals?
 |  |  |  | 6 | Do you know the escape routes and assembley points?
 |  |  |  | 7 | Are safety glasses required?
 |  |  |  | 8 | Is a face sheild required?
 |  |  |  | 9 | Is a hard hat required?
 |  |  |  | 10 | Are flame resistant clothes required?
 |  |  |  | 11 | Is hearing protection required?
 |  |  |  | 12 | Are safety toed shoes required?
 |  |  |  | 13 | Are respirators required? |  |  |  |  |  |  |  |  | SIGNATURES:
 |  |  |  | 14 | Is fall protection equipment required?
 |  |  |  | 15 | Other: |  |  |  |  |  |  |  | CUSTOMER:
 |  |  |  |  |  |  |  |  |  |  |  |  | TRI TOOL:
Spreadsheet: 794422d1662041620-how-to-update-a-list-tab-based-on-an-evolving-data-tab-test-v4
Sheet: List

Centre | Faculty | AO | Title | [NAME] | Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 | Column 7 | Column 8 | Column 9 | Column 10 | Column 11 | Column 12 | Column 13 | Column 14 | Column 15 | Column 16
Spreadsheet: 605648d1547199709-copy-a-conditional-formatted-cell-with-cell-color-help-4
Sheet: dt

 |  |  |  |  |  |  |  |  |  |  |  | 2018-07-15 00:00:00
Member Details |  |  | Payment Details |  |  |  |  |  |  |  |  |  |  |  |  | Member Details
Member No | Name | ID No | 2018-01-01 00:00:00 | 2018-02-01 00:00:00 | 2018-03-01 00:00:00 | 2018-04-01 00:00:00 | 2018-05-01 00:00:00 | 2018-06-01 00:00:00 | 2018-07-01 00:00:00 | 2018-08-01 00:00:00 | 2018-09-01 00:00:00 | 2018-10-01 00:00:00 | 2018-11-01 00:00:00 | 2018-12-01 00:00:00 | Last payment | Adress | Contact No | [NAME]
1 | kasun | 953201631v | 2500 | 2500 | 2500 | 2500 | 2500 |  |  |  |  |  |  |  |  | 123 | x789 | asd
2 | prasad | 659820167v | 6000 |  |  | 6000 |  |  |  |  |  |  |  |  |  | 456 | x654 | sdf
3 | wimalarathna | 654876544v | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 |  |  |  |  |  |  |  | 789 | x123 | xcb
4 | supun | 214976444v | 2500 | 6000 |  |  | 2500 |  |  |  |  |  |  |  |  | 741 | x741 | rt
5 | nayomi | 321578731v | 6000 |  |  | 2500 |  |  |  |  |  |  |  |  |  | 852 | x852 | qw4
6 | rajiw | 654788731v | 2500 | 2500 | 2500 |  |  |  |  |  |  |  |  |  |  | 123456 | 123456789 | asd132
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =NOT(ISNUMBER(HLOOKUP(DATE(YEAR($M$1);MONTH($M$1)-1;1);$A$4:$L$9;ROW()-3)))
Spreadsheet: 712390d1610192104-rolling-12-week-total-or-average-formula-test-1-sumproduct
Sheet: Sheet1

cust | date | cases | lines | week | Packed on time? |  |  | Last 12 weeks |  | cust | Orders | cases | lines | last 12 weeks total orders | pass | fail | On Time %
123 | 2020-12-09 00:00:00 | 100 | 10 | 50 | Pass |  |  | 45 |  | 123
abc | 2020-12-15 00:00:00 | 10 | 1 | 51 | Fail |  |  | 46 |  | abc
def | 2020-12-24 00:00:00 | 2000 | 100 | 51 | Fail |  |  | 47 |  | def
123 | 2021-01-01 00:00:00 | 10 | 10 | 52 | Pass |  |  | 48
abc | 2021-01-08 00:00:00 | 150 | 15 | 1 | Pass |  |  | 49
def | 2021-01-15 00:00:00 | 250 | 10 | 2 | Fail |  |  | 50
def | 2021-01-21 00:00:00 | 100 | 10 | 3 | Fail |  |  | 51
 |  |  |  |  |  |  |  | 52
 |  |  |  |  |  |  |  | 53
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  | 3
Spreadsheet: 772317d1647196782-add-numbers-beside-a-column-filled-with-numbers-based-on-a-list-of-criteria-excel-example
Sheet: Excel example

 | List 1 |  |  | List 2 | List 3
 | 1911 |  |  | 1440 | 1439 |  | The light blue coloured cells (column C) are the ones that I would like to quickly fill with numbers that match between columns 2 and 3 (according to the examples in C2 - C11).
 | 9060 |  |  | 1450 | 1441 |  | List 1 (column B) contains numbers in a random order from List 2 (column E). Basically, I would like to match numbers in List 1 with the numbers from List 3, based on the vertical pair in lists 2 and 3.
 | 1440 |  |  | 1700 | 1701
 | 1777 |  |  | 1710 | 1701
 | 1777 |  |  | 1762 | 1762
 | 1810 |  |  | 1777 | 199999
 | 1440 |  |  | 1800 | 1849
 | 1440 |  |  | 1810 | 1819
 | 1440 |  |  | 1910 | 1920
 | 9080 |  |  | 1911 | 1921
 | 9320 |  |  | 1912 | 1922
 | 1912 |  |  | 1925 | 1911
 | 9355 |  |  | 1930 | 1910
 | 1942 |  |  | 1935 | 1912
 | 9355 |  |  | 1940 | 1913
 | 1940 |  |  | 1941 | 1930
 | 9070 |  |  | 1942 | 1914
 | 1710 |  |  | 1990 | 199999
 | 9020 |  |  | 2000 | 2000
 | 1710 |  |  | 2170 | 2141
 | 9020 |  |  | 2171 | 2143
 | 1710 |  |  | 2250 | 2251
 | 9020 |  |  | 2860 | 2860
 | 1941 |  |  | 2870 | 2871
 | 9330 |  |  | 2880 | 2871
 | 9330 |  |  | 2888 | 2961
 | 1440 |  |  | 2920 | 2921
 | 1440 |  |  | 2950 | 2961
 | 2920 |  |  | 2951 | 2979
 | 2950 |  |  | 5200 | 3030
 | 5200 |  |  | 7700 | 3181
 | 1925 |  |  | 7800 | 3178
 | 7940 |  |  | 7810 | 3178
 | 1930 |  |  | 7850 | 3184
 | 7940 |  |  | 7905 | 3176
 | 1930 |  |  | 7910 | 3180
 | 9340 |  |  | 7911 | 3180
 | 9340 |  |  | 7915 | 3179
 | 1930 |  |  | 7920 | 3183
 | 1930 |  |  | 7925 | 3172
 | 2870 |  |  | 7930 | 3171
 | 7911 |  |  | 7940 | 3175
 | 7930 |  |  | 7945 | 3170
 | 1930 |  |  | 7960 | 3170
 | 2950 |  |  | 7965 | 3070
 | 2920 |  |  | 9020 | 5050
 | 1930 |  |  | 9030 | 5110
 | 1930 |  |  | 9060 | 5120
 | 1930 |  |  | 9070 | 5140
 | 1777 |  |  | 9080 | 5130
 | 1710 |  |  | 9240 | 5101
 | 1930 |  |  | 9300 | 5520
 | 1710 |  |  | 9310 | 5500
 | 1930 |  |  | 9320 | 5530
 | 1930 |  |  | 9330 | 5600
 | 7700 |  |  | 9340 | 5550
 | 1710 |  |  | 9350 | 5580
 | 1935 |  |  | 9355 | 5540
 | 1935 |  |  | 9360 | 5510
 | 1935 |  |  | 9500 | 5690
 | 7940 |  |  | 9540 | 5601
 | 1777
 | 1777
 | 1777
Spreadsheet: 914be084-fb81-4c62-a144-f6e24a7ad3fd
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
259088 | 30438 | [NAME] | Steyn | RSA | 11 | 00:36:26 | 00:00:00 | [NAME] | 00:00:00 | [NAME] | 1 | 02:09:33
259088 | 51795 | Liezl | [NAME] | RSA | 14 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 02:14:01
Spreadsheet: 106116d1303329421-drop-down-list-options-prototype-5
Sheet: Sheet2

...
Chapter_Master
Captain
Chapter Master |  |  | Captain [NAME]
Column1 | Column2 |  | Column1 | Column2
Power armour | 0 |  | Power armour | 0
[NAME] armour | 15 |  | [NAME] armour | 20
Terminator armour | 40 |  | Terminator armour | 35
Chapter_Master power/artificer armour Weapons 1 |  |  | Captain power/artificer armour Weapons 1
Column1 | Column2 |  | Column1 | Column2
Bolt pistol | 0 |  | Power blade | 15
Boltgun | 0 |  | Lightning claw | 15
Storm bolter | 3 |  | Plasma pistol | 15
Combi-flamer | 10 |  | Power fist | 25
Chapter_Master power/artificer armour Weapons 2 |  |  | Captain power/artificer armour Weapons 2
Column1 | Column2 |  | Column1 | Column2
Combi-melta | 10 |  | Bolt pistol | 0
Combi-plasma | 10 |  | Boltgun | 0
Storm shield | 15 |  | Storm bolter | 3
Power blade | 15 |  | Combi-flamer | 10
Chapter_Master_Terminator Weapons 1 |  |  | Captain_Terminator Weapons 1
Column1 | Column2 |  | Column1 | Column2
Storm bolter | 0 |  | Combi-plasma | 0
Combi-flamer | 5 |  | Lightning claw | 10
Combi-melta | 5 |  | Thunder hammer | 20
Chapter_Master_Terminator Weapons 2 |  |  | Captain_Terminator Weapons 2
Column1 | Column2 |  | Column1 | Column2
Power blade | 0 |  | Storm shield | 0
Lightning claw | 5 |  | Thunder hammer | 15
Power fist | 10 |  | Chainfist | 15
Spreadsheet: 00c44e93-e2fd-4a89-84f9-a325683ae3fb
Sheet: Q3 DAVID

[NAME]
n | 12 |  | year | net worth at the end of the year |  | Intrinsic
P | 750000 |  | 0
X | 0 |  | 1
F |  |  | 2
rate | 0.04 |  | 3
(1 + rate)^n |  |  | 4
 |  |  | 5
 |  |  | 6
 |  |  | 7
 |  |  | 8
 |  |  | 9
 |  |  | 10
 |  |  | 11
 |  |  | 12
Spreadsheet: 140140d1328633218-sumif-and-vlookups-combined-may-be-the-answer-813347-sum-example
Sheet: Sheet5

 | Code | Value |  | Totals
 | a | 1 |  | a
 | b | 2 |  | b
 | c | 3 |  | c
 | d | 4 |  | d
 | a | 5
 | b | 6
 | c | 7
 | a | 8
 | b | 9
Spreadsheet: 29563d1224619639-vlookup-formula-only-returns-ref-or-n-a-test-inventory-tool
Sheet: pal

Qty | Piece of Equipment | Serial Number | Location | Cost | date of Purchase
1 | Starlux Pulsed Light Demo Systems | 15-1109 | [NAME] | 375000 | Purchased from [NAME] in November 2007 for 375k
1 | Starlux Pulsed Light Demo Systems | 15-1338 | Northtown
1 | Starlux Pulsed Light Demo Systems | 15-1344 | Queen Street West
1 | Starlux Pulsed Light Demo Systems | 15-0347 | Vegas
1 | Starlux Pulsed Light Demo Systems | 15-1494 | No Location listed
1 | Starlux Pulsed Light Demo Systems | 15-0558 | Woodfield
6 | Total Starlux Units
1 | Yellow H P | 065233 | No Location listed
1 | Yellow H P | 060727 | No Location listed
1 | Yellow H P | 056884-25 | No Location listed
3 | Total Yellow Hand Pieces
1 | RS H P | 066534 | No Location listed
1 | RS H P | 061132-6 | No Location listed
1 | RS H P | 070216-7 | No Location listed
1 | RS H P | 062572-8 | No Location listed
1 | RS H P | 070626-3 | No Location listed
5 | Total RS Hand Pieces
1 | Green H P | 078287 | No Location listed
1 | Green H P | 061312-7 | No Location listed
1 | Green H P | 054366-12 | No Location listed
1 | Green H P | 063523-4 | No Location listed
1 | Green H P | 069407-20 | No Location listed
1 | Green H P | 069945 | No Location listed
1 | Green H P | 067910 | No Location listed
7 | Total Green Hand Pieces
1 | Violet H P | 059014 | No Location listed
1 | Total Violet Hand Pieces
1 | 1064 H P | 056865-2 | No Location listed
1 | Total 1064 Hand Pieces
1 | External Chiller Assembly | 066493-4 | No Location listed
Spreadsheet: 01e118d2-4d57-43b6-b1bf-5ad2f5dedb28
Sheet: Welding Tech Certificates 2

WELDING TECHNOLOGY
Certificates
Students Name:
ID #
Production Line Welder | Semester | Grade
___ WLD 130 (2) Gas Tungsten Arc Welding (GTAW)
___ WLD 131 (3) Gas Tungsten Arc Welding (GTAW) Fillet Lab
___ WLD 140 (2) Gas Metal Arc Welding (GMAW)
___ WLD 141 (3) Gas Metal Arc Welding (GMAW) Fillet Lab
___ WLD 100 (2) Oxy-Fuel Systems
AND ___ WLD 101 (2) Oxy-Fuel Systems Lab
OR ___ WLD 110 (2) Cutting Procedures
AND ___ WLD 111 (3) Cutting Procedures Lab
___ WLD 120 (2) Shielded Metal Arc Welding (SMAW)
___ WLD 121 (3) Shielded Metal Arc Welding (SMAW) Fillet Lab
[NAME]
___ WLD 100 (2) Oxy-Fuel Systems
AND ___ WLD 101 (2) Oxy-Fuel Systems Lab
OR ___ WLD 110 (2) Cutting Procedures
AND ___ WLD 111 (3) Cutting Procedures Lab
___ WLD 120 (2) Shielded Metal Arc Welding (SMAW)
___ WLD 121 (3) Shielded Metal Arc Welding (SMAW) Fillet Lab
___ WLD 123 (3) Shielded Metal Arc Welding (SMAW) Groove with Backing Lab
OR ___ WLD 225 Shielded Metal Arc Welding (SMAW) Open Groove Lab
___ WLD 130 (2) Gas Tungsten Arc Welding (GTAW)
___ WLD 131 (3) Gas Tungsten Arc Welding (GTAW) Fillet Lab
OR ___ WLD 133 (3) Gas Tungsten Arc Welding (GTAW) Groove Lab
___ WLD 140 (2) Gas Metal Arc Welding (GMAW)
___ WLD 141 (3) Gas Metal Arc Welding (GMAW) Fillet Lab
OR ___ WLD 143 (3) Gas Metal Arc Welding (GMAW) Fillet Groove Lab
___ WLD 170 (2) Blueprint Reading for Welding
___ WLD 171 (3) Blueprint Reading for Welding Lab
Southeast Kentucky Community & Technical College | Updated Spring 2013
Spreadsheet: 06be73a5-1960-4812-b87e-a0eba44c1505
Sheet: Sheet1

Date | Sport | Opponent | Time_Results
10/12/2012 | Men's Swimming | West Virginia State Games (Huntington, W.Va.) | 1st place
10/13/2012 | Men's Swimming | West Virginia State Games (Huntington, W.Va.) | 1st place
10/19/2012 | Men's Swimming | Penn State | L, 174-69
10/27/2012 | Men's Swimming | at Villanova | W, 174-113
11/02/2012 | Men's Swimming | at Cincinnati | W, 177-114
11/16/2012 | Men's Swimming | Pitt Invitational (Pittsburgh, Pa.) | 2nd place
11/17/2012 | Men's Swimming | Pitt Invitational (Pittsburgh, Pa.) | 2nd place
11/18/2012 | Men's Swimming | Pitt Invitational (Pittsburgh, Pa.) | 2nd place
11/29/2012 | Men's Swimming | U.S. Winter Nationals (Austin, Texas) | Results
11/30/2012 | Men's Swimming | U.S. Winter Nationals (Austin, Texas) | Results
11/30/2012 | Men's Swimming | Miami Diving Invitational (Miami, Ohio) | Results
12/01/2012 | Men's Swimming | Miami Diving Invitational (Miami, Ohio) | Results
12/01/2012 | Men's Swimming | U.S. Winter Nationals (Austin, Texas) | 33rd place
01/03/2013 | Men's Swimming | Orange Bowl Classic (Key Largo, Fla.) | 2nd place
01/12/2013 | Men's Swimming | at Pitt | L, 217-63
01/18/2013 | Men's Swimming | TCU | L, 160-131
02/09/2013 | Men's Swimming | [NAME] (Diving) | Results
02/27/2013 | Men's Swimming | Big 12 Championships (Austin, Texas) | 1st place
02/28/2013 | Men's Swimming | Big 12 Championships (Austin, Texas) | 2nd place
03/01/2013 | Men's Swimming | Big 12 Championships (Austin, Texas) | 2nd place
03/02/2013 | Men's Swimming | Big 12 Championships (Austin, Texas) | 3rd place
03/15/2013 | Men's Swimming | NCAA Zone Diving (Blacksburg, Va.) | Results
03/16/2013 | Men's Swimming | NCAA Zone Diving (Blacksburg, Va.) | Results
Spreadsheet: 98791d1297645403-vehicle-vin-calculation-vin-numbers
Sheet: data

VIN |  | 1st | 2nd | Combined
11111111111111111 |  | 1 | 1 | 1
1M8GDM9AXKP042788 |  | 1 | 1 | 1
1M8GDM9A1KP042788 |  | 1 | 0 | 0
ABCDEFGH723456789 |  | 1 | 1 | 1
Spreadsheet: 188314d1350820430-shirt-sizing-and-numbering-player-number-jacc
Sheet: Sheet1

 | PLAYER | YOUTH JERSEYS |  |  |  | ADULT JERSEYS |  |  |  |  |  |  |  | YOUTH  PANTS |  |  |  | ADULT PANTS |  |  |  |  |  |  | SOCKS |  |  |  | BELT | HATS
NAME | NUMBER | Y-SMALL | Y-MEDIUM | Y-LARGE | Y-XL | SMALL | MEDIUM | LARGE | XL | 2XL | 3XL | 4XL | 5XL | Y-SMALL | Y-MEDIUM | Y-LARGE | Y-XL | SMALL | MEDIUM | LARGE | XL | 2XL | 3XL | 4XL | SMALL | MEDIUM | LARGE | XL | OSFA | XS/SMALL | SMALL/MED | LRG/XL | 2XL
player 1 | 94 | 1 |  |  | 1 |  |  | 1 |  |  | 1 | 1 | 1
player 2 | 93 | 1 | 1 |  |  | 1 | 1 |  | 1 |  |  |  | 1
player 3 | 89 | 1 |  |  | 1 | 1 | 1 |  |  | 1 | 1 | 1
player 4 | 89 | 1 |  |  |  |  | 1 | 1 | 1 |  |  | 1 | 1
player 5 | 94 | 1 | 1 |  |  |  |  |  |  | 1 | 1 | 1
player 6 | 86 | 1 | 1 |  | 1 |  |  | 1 | 1
player 7 | 87 | 1 |  | 1 | 1 |  | 1 | 1 |  | 1 |  | 1 | 1
player 8 | 87 |  | 1 | 1 |  |  |  |  | 1 | 1 | 1 |  | 1
player 9 | 86 | 1 |  |  | 1 |  |  | 1 |  |  | 1 | 1 | 1
player 10 | 90 |  | 1 | 1 | 1 | 1 | 1 |  | 1
player 11 | 90 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  | 1 | 1
player 12 | 86 |  |  |  | 1 | 1 |  |  |  |  | 1 | 1 | 1
player 13 | 86 | 1 |  |  | 1 | 1 |  | 1 |  |  | 1
player 14 | 90 | 1 | 1 |  |  | 1 |  |  | 1 |  |  | 1
player 15 | 85 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 | 1 | 1 |  | 1
player 16 | 94 |  | 1 | 1 | 1 |  | 1 |  | 1 | 1 | 1
player 17 | 90 | 1 | 1 | 1 |  |  | 1 |  |  | 1 | 1 | 1 | 1
player 18 | 86 |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1
player 19 | 87 |  | 1 | 1 | 1 |  | 1 | 1 |  |  |  | 1
player 20 | 91 |  |  |  |  | 1 |  |  | 1 |  | 1 |  | 1
player 21 | 93 | 1 |  |  |  | 1 |  |  |  |  | 1 |  | 1
player 22 | 89 |  |  | 1 | 1 |  |  |  | 1 | 1 |  | 1 | 1
player 23 | 89 |  |  | 1 | 1 |  |  | 1 |  |  | 1 | 1
player 24 | 86 |  | 1 | 1 |  |  | 1 |  |  |  | 1 | 1 | 1
player 25 | 89 | 1 |  |  | 1 | 1 | 1 |  |  | 1 | 1 |  | 1
player 26 | 88 | 1 | 1 |  |  |  | 1
player 27 | 91 | 1 | 1 | 1 |  |  |  | 1 | 1 |  |  | 1 | 1
player 28 | 92 |  | 1 | 1 | 1 | 1 |  | 1 | 1 |  |  |  | 1
player 29 | 85 | 1 | 1 |  | 1 | 1 | 1 | 1 |  |  | 1 |  | 1
 |  | Y-SMALL | Y-MEDIUM | Y-LARGE | Y-XL | SMALL | MEDIUM | LARGE | XL | 2XL | 3XL | 4XL | 5XL
 | 85 | 2 | 2 | 1 | 1 | 2 | 2 | 2 | 1 | 1 | 2 |  | 2
 | 86 | 3 | 2 | 1 | 4 | 2 | 1 | 4 | 2 | 1 | 5 | 4 | 4
 | 87 | 1 | 2 | 3 | 2 |  | 2 | 2 | 1 | 2 | 1 | 2 | 2
 | 88 | 1 | 1 |  |  |  | 1
 | 89 | 3 |  | 2 | 4 | 2 | 3 | 2 | 2 | 3 | 3 | 4 | 3
 | 90 | 2 | 3 | 2 | 2 | 3 | 3 | 1 | 3 | 2 | 1 | 3 | 2
 | 91 | 1 | 1 | 1 |  | 1 |  | 1 | 2 |  | 1 | 1 | 2
 | 92 |  | 1 | 1 | 1 | 1 |  | 1 | 1 |  |  |  | 1
 | 93 | 2 | 1 |  |  | 2 | 1 |  | 1 |  | 1 |  | 2
 | 94 | 2 | 2 | 1 | 2 |  | 1 | 1 | 1 | 2 | 3 | 2 | 1
Spreadsheet: 112863d1308841516-excel-2007-auto-populate-rows-based-on-preceeding-2-variables-example
Sheet: Sheet2

 | Task | Start Date
 | Task 1 | 1
 | Task 2 | 2
 | Task 3 | 3
 | Task 4 | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  | 11
 |  | 12
 |  | 13
 |  | 14
 |  | 15
 |  | 16
 |  | 17
 |  | 18
 |  | 19
 |  | 20
 |  | 21
 |  | 22
 |  | 23
 |  | 24
 |  | 25
 |  | 26
 |  | 27
 |  | 28
 |  | 29
 |  | 30
 |  | 31
Spreadsheet: 54973d1255013833-automated-ref-number-generation-indexnumberupdate2
Sheet: Sheet1

 | Index number
 | 0
Yes | 1
Yes | 2
Yes | 3
no
Yes | 4
Yes | 5
Yes | 6
Yes | 7
yes | 8
yes | 9
Spreadsheet: 796573d1663354373-sample-data-for-date-and-time-based-on-specific-person-sample-file-etaf
Sheet: Sheet2

Time | Date | Salesperson |  |  |  |  |  | Nick | [NAME] | [NAME] | [NAME] | [NAME]
00:38:00.010000 | 2020-08-10 00:00:00 | [NAME] |  |  |  | 2020-08-10 00:00:00
00:20:00.010000 | 2020-08-10 00:00:00 | [NAME] |  |  |  | 2020-08-11 00:00:00
00:18:00 | 2020-08-12 00:00:00 | Nick |  |  |  | 2020-08-12 00:00:00
00:09:59.962000 | 2020-08-12 00:00:00 | [NAME] |  |  |  | 2020-08-13 00:00:00
00:33:59.990000 | 2020-08-13 00:00:00 | [NAME] |  |  |  | 2020-08-14 00:00:00
00:22:59.981000 | 2020-08-14 00:00:00 | [NAME] |  |  |  | 2020-08-15 00:00:00
00:49:00.019000 | 2020-08-16 00:00:00 | [NAME] |  |  |  | 2020-08-16 00:00:00
00:56:00.010000 | 2020-08-17 00:00:00 | Nick |  |  |  | 2020-08-17 00:00:00
 |  |  |  |  |  | 2020-08-18 00:00:00
 |  |  |  |  |  | For instance on 8/10/20 mike ahs 0:38 and 0:20 hours. I need that to total to 0.58 hour and search the rest of my sales people for time on that day and then total there time  My end result will scroll a month's worth of time and check everyday for time from all my sales people then list them row A through what ever and shows the days across in each column. If I can get the formula to search properly I think I can get the summary sheet figured out.  in my example to get the value in A15 I got this far =SUMIFS($A$3:$A$10, $B$3:$B$10,G3, $C$3:$C$10, $C$3) but I can not figure out how to get it to check the next name listed for the same date and then move to 8/11