tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: darrell_schoolcraft__7585__imball0112
Sheet: EOG

 | 500249 |  | 500260 |  | 500646 |  | 500598
 | Pronghorn |  | Pitchfork Ranch |  | Tristi Draw |  | EOG/TW Eddy
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 13809 | 13500 | 8589 | 8766
2 | 13692 | 13500 | 8745 | 8766 |  |  | 914
3 | 13249 | 13500 | 8554 | 8766 |  |  | 372
4 | 13315 | 13500 | 8655 | 8766 |  |  | 32
5 | 13166 | 13500 | 8645 | 8766
6 | 12882 | 13500 | 8784 | 8266 | 4 |  | 72
7 | 12665 | 12936 | 8648 | 8226 | 40
8 | 12571 | 13000 | 8780 | 8266
9 | 12456 | 13000 | 8879 | 8266
10 | 12403 | 13000 | 9353 | 8266
11 | 12278 | 13000 | 9344 | 8266
12 | 12191 | 13000 | 8907 | 8266
13 | 12106 | 13000 | 8638 | 8266
14 | 11598 | 13000 | 8646 | 8266
15 | 11607 | 13000 | 9005 | 8266
16 | 11214 | 13000 | 8917 | 8266
17 | 11141 | 13000 | 8431 | 8266
18 | 11074 | 12000 | 9003 | 8866
19 | 11196 | 12000 | 8165 | 8866
20 | 11322 | 12000 | 8767 | 8866
21 | 11540 | 12000 | 8415 | 8866
22 | 11282 | 12000 | 8486 | 8866
23 | 11398 | 12000 | 8988 | 8866
24 | 11434 | 12000 | 8762 | 8866 |  |  | 97
25 | 11137 | 12000 | 7950 | 8866
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  |  |  |  |  |  |  | -38486.04
2001-12-25 00:00:00
CBS Volume
 |  |  | -144659
Spreadsheet: 153585d1335968743-use-data-grid-to-calculate-results-sample-spreadsheet
Sheet: Sheet1

 | 0.75 | 0.8 | 0.85 | 0.9 |  |  | Enter Recovery Rate | Lbs Per Hour
1000 | 0.5 | 0.52 | 0.54 | 0.56 |  |  | 0.75 | 1000
2000 | 0.54 | 0.56 | 0.5800000000000001 | 0.6000000000000001
3000 | 0.5800000000000001 | 0.6000000000000001 | 0.6200000000000001 | 0.6400000000000001
4000 | 0.6200000000000001 | 0.6400000000000001 | 0.6600000000000001 | 0.6800000000000002
5000 | 0.6600000000000001 | 0.6800000000000002 | 0.7000000000000002 | 0.7200000000000002 |  |  | Result
Spreadsheet: 819488d1677531869-how-to-print-different-weekday-each-print-book1-workouts-printed-w-dates
Sheet: Sheet1

2023-02-27 00:00:00 | [NAME] boxes |  |  | [NAME] boxes |  |  | [NAME] boxes |  |  | [NAME] boxes |  |  | [NAME] boxes |  |  | [NAME] boxes |  |  | [NAME] boxes
Do 10 sit ups |  |  | Do 10 sit ups |  |  | Do 10 sit ups |  |  | Do 10 sit ups |  |  | Do 10 sit ups |  |  | Do 10 sit ups |  |  | Do 10 sit ups
Do 10 press ups |  |  | Do 10 press ups |  |  | Do 10 press ups |  |  | Do 10 press ups |  |  | Do 10 press ups |  |  | Do 10 press ups |  |  | Do 10 press ups
Do 10 squats |  |  | Do 10 squats |  |  | Do 10 squats |  |  | Do 10 squats |  |  | Do 10 squats |  |  | Do 10 squats |  |  | Do 10 squats
Do 10,000 steps |  |  | Do 10,000 steps |  |  | Do 10,000 steps |  |  | Do 10,000 steps |  |  | Do 10,000 steps |  |  | Do 10,000 steps |  |  | Do 10,000 steps
Do 10 minutes row machine |  |  | Do 10 minutes row machine |  |  | Do 10 minutes row machine |  |  | Do 10 minutes row machine |  |  | Do 10 minutes row machine |  |  | Do 10 minutes row machine |  |  | Do 10 minutes row machine
Do 10 minutes exercise bike |  |  | Do 10 minutes exercise bike |  |  | Do 10 minutes exercise bike |  |  | Do 10 minutes exercise bike |  |  | Do 10 minutes exercise bike |  |  | Do 10 minutes exercise bike |  |  | Do 10 minutes exercise bike
Spreadsheet: 755228d1636728722-nesting-if-and-xlookup-functions-holidays-template
Sheet: Holidays

 | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2022-01-03 00:00:00 | 2022-01-04 00:00:00 | 2022-01-05 00:00:00 | 2022-01-06 00:00:00 | 2022-01-07 00:00:00 | 2022-01-08 00:00:00 | 2022-01-09 00:00:00
Employee 1 |  |  | BH | H | H | H | H
Employee 2 |  |  | BH | SL | SL | SL | SL
Employee 3 |  |  | BH | SI | SI | SI | SI
Employee 4 |  |  | BH | H | H | H | H
Employee 5 |  |  | BH | SL | SI | SI | H
Employee 6 |  |  | BH
BH | Bank holiday
 | Holiday
 | Study leave
 | Sick leave
 | Weekend
Spreadsheet: 99910d1298450310-calculate-holiday-accrued-at-current-month-monthly-accrual
Sheet: Monthly balance

 | Yearly Allowance | Name | Surname | Accrual as of Today | Monthly allowance/ accrual |  |  |  |  |  |  |  |  |  |  |  |  | TODAY
 |  |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  | 2011-02-23 00:00:00
 | 25 | [NAME] | Cricket | ?????? | 2.083333333333333 | 2.083333333333333 | 2.083333333333333 | 2.083333333333333 | 2.083333333333333 | 2.083333333333333 | 2.083333333333333 | 2.083333333333333 | 2.083333333333333 | 2.083333333333333 | 2.083333333333333 | 2.083333333333333
 |  |  |  |  | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 681536d1591629213-counting-instances-on-columns-excel-example
Sheet: Sheet2

Column2 | Column7 | Column10 | Column13 | Column16 | Column19 | Column22 | Column25 | Column28 | Observation | Major | Minor | #
 |  | Major
1 | Minor | Accept | Accept | Accept | Accept | Accept | Accept | Accept |  |  |  | 1
3 | Observation | Observation | Observation | Observation | Observation | Observation | Observation | Observation |  |  |  | 3
4 | Observation | Observation | Observation | Observation | Observation | Observation | Observation | Observation |  |  |  | 4
8A | Minor | Minor | Minor | Accept | Minor | Accept | Accept | Accept |  |  |  | 8A
8B | Minor | Accept | Accept | Accept | Major | Accept | Accept | Accept |  |  |  | 8B
9 | Major | Accept | Accept | Accept | Accept | Accept | Major | Accept |  |  |  | 9
10A | Minor | Minor | Minor | Accept | Accept | Accept | Accept | Accept |  |  |  | 10A
10B | Minor | Accept | Accept | Accept | Accept | Accept | Accept | Accept |  |  |  | 10B
11 | Accept | Accept | Minor | Accept | Accept | Accept | Accept | Accept |  |  |  | 11
13 | Observation | Observation | Observation | Observation | Observation | Observation | Observation | Observation |  |  |  | 13
15 | Accept | Minor | Accept | Accept | Accept | Accept | Accept | Accept |  |  |  | 15
16 | Observation | Observation | Observation | Observation | Observation | Major | Observation | Observation |  |  |  | 16
19 | Accept | Minor | Accept | Accept | Accept | Accept | Accept | Minor |  |  |  | 19
21 | Observation | Observation | Observation | Observation | Observation | Observation | Observation | Observation |  |  |  | 21
22 | Observation | Observation | Observation | Observation | Observation | Observation | Observation | Observation |  |  |  | 22
29 | Accept | Major | Major | Accept | Accept | Accept | Accept | Accept |  |  |  | 29
40 | Accept | Accept | Accept | Accept | Accept | Minor | Minor | Minor |  |  |  | 40
51 | Observation | Observation | Observation | Major | Minor | Observation | Minor | Observation |  |  |  | 51
52 |  |  |  | Minor | Observation |  | Observation |  |  |  |  | 52
53 |  |  |  | Observation |  |  |  |  |  |  |  | 53
Spreadsheet: 824469d1680612869-issue-with-v-and-x-lookups-time-range-etaf
Sheet: Sheet1

11:05:00
11:25:00
11:45:00
12:05:00
12:25:00
12:45:00
13:05:00
13:25:00
13:45:00
14:05:00
14:25:00
14:45:00
15:05:00
15:25:00
15:45:00
16:05:00
16:25:00
16:45:00
17:05:00
17:25:00
17:45:00
18:05:00
18:25:00
18:45:00
19:05:00
19:25:00
19:45:00
20:05:00
20:25:00
20:45:00
21:05:00
21:25:00
21:45:00
22:05:00
22:25:00
23:25:00
1900-01-01 00:25:00
1900-01-01 01:25:00
1900-01-01 02:25:00
1900-01-01 03:25:00
1900-01-01 04:25:00
1900-01-01 05:25:00
Spreadsheet: 102795d1300741274-max-value-required-solrequired
Sheet: Sheet1

 | Source DATABASE |  |  |  |  | REPORT ( with formula )
SalesSale | Sales Man Code | Zone | Date | $ [NAME] |  | Sales Man Code | Zone | Date | $ [NAME]
A100 | A | East | 2010-01-01 00:00:00 | 100 |  | A | West | 2010-11-25 00:00:00 | 3100
B200 | B | East | 2010-01-03 00:00:00 | 200 |  | B | West | 2010-12-07 00:00:00 | 3200
C300 | C | East | 2010-01-05 00:00:00 | 300 |  | C | West | 2010-12-20 00:00:00 | 3300
D400 | D | East | 2010-01-07 00:00:00 | 400 |  | D | West | 2011-01-02 00:00:00 | 3400
E500 | E | East | 2010-01-09 00:00:00 | 500 |  | E | West | 2011-01-04 00:00:00 | 3500
F600 | F | East | 2010-01-11 00:00:00 | 600 |  | F | West | 2011-02-23 00:00:00 | 3600
G2700 | G | South | 2010-10-10 00:00:00 | 2700 |  | G | West | 2011-02-26 00:00:00 | 3700
H2800 | H | South | 2010-10-21 00:00:00 | 2800 |  | H | West | 2011-03-01 00:00:00 | 3800
P2900 | P | South | 2010-11-01 00:00:00 | 2900 |  | P | West | 2011-03-05 00:00:00 | 3900
[NAME] | Q | South | 2010-11-13 00:00:00 | 3000 |  | Q | West | 2010-12-12 00:00:00 | 4000
A3100 | A | West | 2010-11-25 00:00:00 | 3100
B3200 | B | West | 2010-12-07 00:00:00 | 3200
G1700 | G | North | 2010-12-12 00:00:00 | 1700
Q4000 | Q | West | 2010-12-12 00:00:00 | 4000
C3300 | C | West | 2010-12-20 00:00:00 | 3300
H1800 | H | North | 2010-12-25 00:00:00 | 1800
D3400 | D | West | 2011-01-02 00:00:00 | 3400
E3500 | E | West | 2011-01-04 00:00:00 | 3500 |  | wherein new SALES MAN CODE entetred
P1900 | P | North | 2011-01-07 00:00:00 | 1900 |  | these sould be the formula so that can be pasted in next
[NAME] | Q | North | 2011-01-09 00:00:00 | 2000
A2100 | A | South | 2011-01-11 00:00:00 | 2100
B2200 | B | South | 2011-01-13 00:00:00 | 2200
C2300 | C | South | 2011-01-15 00:00:00 | 2300
D2400 | D | South | 2011-01-17 00:00:00 | 2400
E2500 | E | South | 2011-01-19 00:00:00 | 2500
F2600 | F | South | 2011-01-21 00:00:00 | 2600
G700 | G | East | 2011-02-05 00:00:00 | 700
H800 | H | East | 2011-02-08 00:00:00 | 800
P900 | P | East | 2011-02-11 00:00:00 | 900
Q1000 | Q | East | 2011-02-14 00:00:00 | 1000
A1100 | A | North | 2011-02-17 00:00:00 | 1100
B1200 | B | North | 2011-02-20 00:00:00 | 1200
C1300 | C | North | 2011-02-23 00:00:00 | 1300
F3600 | F | West | 2011-02-23 00:00:00 | 3600
D1400 | D | North | 2011-02-26 00:00:00 | 1400
G3700 | G | West | 2011-02-26 00:00:00 | 3700
E1500 | E | North | 2011-03-01 00:00:00 | 1500
H3800 | H | West | 2011-03-01 00:00:00 | 3800
F1600 | F | North | 2011-03-05 00:00:00 | 1600
P3900 | P | West | 2011-03-05 00:00:00 | 3900
Spreadsheet: 2a411c2c-392d-4657-8f60-8040d9cda452
Sheet: Sheet1

Region | Regional 2005-2006 ADA
1 | 334766.951
2 | 98372.52700000002
3 | 49805.59999999999
4 | 924114.5819999998
5 | 75497.76399999997
6 | 141847.204
7 | 151811.353
8 | 52737.47399999997
9 | 36987.56799999999
10 | 636697.7629999996
11 | 451857.8779999998
12 | 132993.1389999999
13 | 296363.0839999999
14 | 41466.74799999999
15 | 45311.729
16 | 72637.81399999998
17 | 72419.302
18 | 68980.85999999999
19 | 159427.657
20 | 337092.372
Spreadsheet: 36095d1233855822-how-to-compare-last-names-and-dates-of-birth-from-two-spreadsheets-compare-names
Sheet: Sheet1

[NAME] |  |  |  |  |  | Old Spreadsheet
lastName | firstName | midInit | dob |  |  |  | lastName | firstName | midInit | dob | This person is in the MAIN Database
Smith | [NAME] | A | 1965-02-05 00:00:00 |  |  |  | Smith | [NAME] | A | 1965-02-05 00:00:00 | yes
[NAME] | [NAME] | B | 1983-03-01 00:00:00 |  |  |  | [NAME] | [NAME] | B | 1983-03-01 00:00:00 | yes | What I have
Cooper | [NAME] | R | 1959-01-03 00:00:00 |  |  |  | Cooper | [NAME] | R | 1960-05-03 00:00:00 | yes | <----------
Daniels | [NAME] | C | 1959-01-03 00:00:00 |  |  |  | Daniels | [NAME] | C | 1959-01-03 00:00:00 | yes
[NAME] | [NAME] | Q | 1962-10-10 00:00:00 |  |  |  | Edwards | [NAME] | E | 1957-02-04 00:00:00 | no
 |  |  |  |  |  |  | Franklin | [NAME] | D | 1980-03-02 00:00:00 | no
 |  |  |  |  |  |  | [NAME] | [NAME] | Q | 1962-10-10 00:00:00 | yes
 |  |  |  |  |  |  | Smith | [NAME] | B | 1966-10-23 00:00:00 | yes
 |  |  |  |  |  |  |  |  |  |  |  | Comparing DOBs would produce an error also
 |  |  |  |  |  |  |  |  |  |  |  | because Cooper and Daniels have the same DOB.
 |  |  |  |  |  |  |  |  |  |  |  | What I need:
 |  |  |  |  |  |  | IF(ISNUMBER(MATCH(H10,A4:A12,0)),"yes","no") |  |  |  |  | Ideally, the formula would use the last name
 |  |  |  |  |  |  |  |  |  |  |  | AND date of birth to make the comparison
 | Or better yet, I'd like a way to have Excel compare the two databases and copy the missing names to the main datbase automatically.
 | Too much to hope for?
Before:
[NAME] |  |  |  |  |  |  | Old Spreadsheet
lastName | firstName | midInit | dob |  |  |  | lastName | firstName | midInit | dob
Adams | [NAME] | A | 1965-02-05 00:00:00 |  |  |  | Adams | [NAME] | A | 1965-02-05 00:00:00
[NAME] | [NAME] | B | 1983-03-01 00:00:00 |  |  |  | [NAME] | [NAME] | B | 1983-03-01 00:00:00
Cooper | [NAME] | R | 1960-05-03 00:00:00 |  |  |  | Cooper | [NAME] | R | 1960-05-03 00:00:00
Daniels | [NAME] | C | 1959-01-03 00:00:00 |  |  |  | Daniels | [NAME] | C | 1959-01-03 00:00:00
 |  |  |  |  |  |  | Edwards | [NAME] | E | 1957-02-04 00:00:00 | These names aren't in the main database
 |  |  |  |  |  |  | Franklin | [NAME] | D | 1980-03-02 00:00:00
After:
lastName | firstName | midInit | dob |  |  |  | lastName | firstName | midInit | dob
Adams | [NAME] | A | 1965-02-05 00:00:00 |  |  |  | Adams | [NAME] | A | 1965-02-05 00:00:00
[NAME] | [NAME] | B | 1983-03-01 00:00:00 |  |  |  | [NAME] | [NAME] | B | 1983-03-01 00:00:00
Cooper | [NAME] | R | 1960-05-03 00:00:00 |  |  |  | Cooper | [NAME] | R | 1960-05-03 00:00:00
Daniels | [NAME] | C | 1959-01-03 00:00:00 |  |  |  | Daniels | [NAME] | C | 1959-01-03 00:00:00
[NAME] | [NAME] | Q | 1962-10-10 00:00:00 |  |  |  | Edwards | [NAME] | E | 1957-02-04 00:00:00 | Now they are!
Edwards | [NAME] | E | 1957-02-04 00:00:00 |  |  |  | Franklin | [NAME] | D | 1980-03-02 00:00:00
Franklin | [NAME] | D | 1980-03-02 00:00:00
Spreadsheet: 220079d1363048454-finding-golf-handicaps-using-best-2-out-of-3-last-rounds-played-golf2012
Sheet: 2011Treasurer's Report

 |  | DEBITS |  |  |  | CREDITS
40 Golfers @ $20.00 |  |  |  |  |  | 800
Secretary's Pay - 40 @ $5.00 |  | 200
Fun Night |  | 150
Prize Money 10 Places |  | 450
 |  | 800 |  |  |  | 800
 |  |  |  |  |  |  |  | Prize | Prize
Place | Team | Points |  | $[NAME] |  | Bonus |  | Money | Money
1st | [NAME] | 36 | x | 1.21 | + | 60 | = | 103.56 | 103.56
2nd | [NAME] J. | 30.5 | x | 1.21 | + | 30 | = | 66.905 | 66.905
3rd | Marion W./ [NAME] | 29.5 | x | 1.21 | + | 15 | = | 50.695 | 50.695
4th | Michelle S./ Amber L. | 29 | x | 1.21 |  |  | = | 35.09 | 35.09
5th Tie | [NAME] T. | 27.5 | x | 1.21 |  |  | = | 33.275 | 33.275
5th Tie | [NAME] R./Tina D. | 27.5 | x | 1.21 |  |  | = | 33.275 | 33.275
7th | Tiffany G. / Kelly H. | 27 | x | 1.21 |  |  | = | 32.67 | 32.67
8th | [NAME] | 26.5 | x | 1.21 |  |  | = | 32.065 | 32.065
9th | [NAME] | 26 | x | 1.21 |  |  | = | 31.46 | 31.46
10th | [NAME] | 25.5 | x | 1.21 |  |  | = | 30.855 | 30.855
 | * Prize money was rounded to nearest dollar for |  |  |  |  |  |  |  | 449.85
 | the secretaries convenience.
Spreadsheet: 150328d1334434998-excel-gantt-chart-chart
Sheet: Sheet1

W2k8-sql63
[NAME] | Start Time | Duration | End Time
w2k8-sql63 | 2012-04-13 23:40:02 |  | 2012-04-14 02:26:58
w2k8-sql64b | 2012-04-14 02:30:00 |  | 2012-04-14 04:12:38
w2k8-sqk74 | 2012-04-14 03:40:12 |  | 2012-04-14 05:05:55
w2k8-sql76 | 2012-04-14 02:51:39 |  | 2012-04-14 03:56:53
w2k8-sql78 | 2012-04-15 02:46:18 |  | 2012-04-18 03:15:15
Spreadsheet: jeffrey_a_shankman__13918__Pick Sheet - Week 17
Sheet: Week 11

NFL PICKS OF THE WEEK - 2001
Name:
Phone Number where we can reach you on Sunday morning:
Last Person Standing Team Pick:
SEND TO:   E-mail - [EMAIL] |  |  |  | Phone - (707) 255-4813 |  |  | Fax - (707) 255-4832
WEEK 11  - First Game is Sunday @ 10 a.m.
Sunday, November 18
 |  | Visitor |  |  |  | Home
 |  | [NAME] |  |  |  | Buffalo Bills
 |  | Tennessee Titans |  |  |  | Cincinnati Bengals
 |  | Philadelphia Eagles |  |  |  | Dallas Cowboys
 |  | Atlanta Falcons |  |  |  | Green Bay Packers
 |  | New York Jets |  |  |  | [NAME]
 |  | Indianapolis Colts |  |  |  | New Orleans Saints
 |  | Chicago Bears |  |  |  | Tampa Bay Buccaneers
 |  | San Francisco 49er's |  |  |  | Carolina Panthers
 |  | [NAME] |  |  |  | Baltimore Ravens
 |  | San Diego Chargers |  |  |  | Oakland Raiders
 |  | [NAME] |  |  |  | Pittsburgh Steelers
 |  | Washington Redskins |  |  |  | Denver Broncos
 |  | Detroit Lions |  |  |  | Arizona Cardinals
 |  | St. Louis Rams |  |  |  | New England Patriots
Monday, November 19
 |  | New York Giants |  |  |  | Minnesota Vikings
Tiebreaker |  |  |  | Total |  |  | Total should = 120
Entries must be received by the beginning of the first game of the week (earlier is perfectly ok!)
Always start by giving the team that you think is most likely to win 15 points and go down from there.
If there are only 14 games in a week, your lowest pick will be "2" instead of "1"
Bye Week: | Kansas City Chiefs
Spreadsheet: 676692d1588937168-conditional-formatting-does-not-work-product-and-keyword-research-shortlist-template
Sheet: Suppliers

Supplier | MOQ | Cost Per Unit | Shipping estimate | Initial Investment | Net Profit/unit
A | 100 | 2 | 1
B | 500 | 1 | 1
C | 1000 | 5 | 1
Spreadsheet: 7f1fb634-b407-49b7-83b3-95f436a342b1
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FLPA2 | Test | FLPA2 | [NAME] Phospholipase A2 (PLAC) | [NAME] Phospholipase A2 | Quantitative Enzyme-Linked Immunosorbent Assay |  |  |  |  |  | Submit only 1 of the following specimens:   Serum Draw blood in a plain, red-top tube(s), serum gel tube is acceptable. Spin down and send 1 mL of serum refrigerated in a plastic vial.    [NAME] blood in a green-top (lithium or sodium heparin), lavender-top (EDTA), or pink-top ([NAME]) tube(s), plasma gel tube is acceptable. Spin down and send 1 mL of plasma refrigerated in a plastic vial. | 0.2 mL | Hemolysis:	NA Thawing:	Warm reject; Cold reject Lipemia:	NA Icterus:	NA Other:	[NAME] | 0 - 234 ng/mL   Patients with high lipoprotein-associated phospholipase A2 concentrations greater than or equal to 235 ng/mL are at increased risk for cardiovascular events including myocardial infarction and ischemic stroke. The median lipoprotein-associated phospholipase A2 value for a healthy population is 235 ng/mL.   This test is performed pursuant to a license agreement with diaDexus, Inc. | Sunday, Wednesday, Friday | 1 - 4 days | 3 - 11 days | 1 | 83698 |  |  |  |  | ARUP Laboratories
FLPA2 | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 7 days
FLPA2 | Result | Z2707 | [NAME] Phospholipase A2 | [NAME] Phospholipase A2 | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 833138d1686808773-if-statement-with-multiple-conditions-result-is-inconsistent-look-up-with-multiple-if-condition-aligw
Sheet: Data

Part No. | Closing Stock | TTL |  | AliGW
P04538 | 99061.53 | 908.62
P07694-21A | 8000 | 842.2
P20554-01 | 0 | 0
L05302 | 7200 | 730
Condition:
 | IF B2 is not zero in Data tab, [NAME] (only first 6 digit if lookup data only has 6 digit)
 | from the element tab, match and look at the highest number from B column
 | if A2 has decimal - like P07694-21A in B3 Data tab and B3 has more than zero match it to the Element Tab
 | exactly as is - result is 842.20
 | Another condition will be if we could not match A5 from the element tab column A - substitute that Look up value A5
 | from Other Source tab column B then match it with the Element Tab column A and pick the highest number in column B
 | also with the condition if B5 in Data tab is not zero
Spreadsheet: 683552d1592827418-team-fitness-tracker-template-fitness
Sheet: Sheet1

Name | Date | Event | Distance Miles |  |  | Event | Total Miles
[NAME] | 2020-06-20 00:00:00 | Run | 5.25 |  |  | Run | 37.54999999999999
[NAME] |  | Swim | 2 |  |  | Swim | 24.49999999999999
[NAME] |  | Cycle | 10 |  |  | Cycle | 32.69999999999999
[NAME] |  | Walk | 3 |  |  | Walk | 25.89999999999999
[NAME] |  | Row | 5 |  |  | Row | 28.09999999999999
[NAME] |  | Run | 5.2
[NAME] |  | Swim | 5.25
[NAME] |  | Cycle | 5.3
[NAME] |  | Walk | 5.35
[NAME] |  | Row | 5.4
[NAME] |  | Run | 5.45
[NAME] |  | Swim | 5.5
[NAME] |  | Cycle | 5.55
[NAME] |  | Walk | 5.6
[NAME] |  | Row | 5.65
[NAME] |  | Run | 5.7
[NAME] |  | Swim | 5.75
[NAME] |  | Cycle | 5.8
[NAME] |  | Walk | 5.85
[NAME] |  | Row | 5.9
[NAME] |  | Run | 5.94999999999999
[NAME] |  | Swim | 5.99999999999999
[NAME] |  | Cycle | 6.04999999999999
[NAME] |  | Walk | 6.09999999999999
[NAME] |  | Row | 6.14999999999999
[NAME] |  | Run | 10