tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 826373d1681976416-divide-points-by-rank-divide-points-test
Sheet: Sheet1

Player # | Rating | Rank |  | Points |  | C | D | E | F | e*F | e*f/g |  |  | Rank | Value
1 | 67 | 2 |  | 100 |  | rank | n @ rank | Uplift | From | To |  |  | 3 | 1 | 30
2 | 22 | 11 |  |  |  |  |  |  | 30 |  |  |  | 1 | 2 | 15
3 | 68 | 1 |  |  |  | 2 | 2 | 1.5 | 20 | 30 | 15 |  | 11 | 2 | 15
4 | 0 | 0 |  |  |  | 4 | 2 | 1.5 | 10 | 15 | 7.5 |  | 7 | 4 | 7.5
5 | 41 | 7 |  |  |  |  |  |  |  |  |  |  | 9 | 4 | 7.5
6 | 47 | 6 |  |  |  |  |  |  |  |  |  |  | 6 | 6 | 4.166666666666667
7 | 66 | 4 |  |  |  |  |  |  |  |  |  |  | 5 | 7 | 4.166666666666667
8 | 28 | 10 |  |  |  |  |  |  |  |  |  |  | 12 | 8 | 4.166666666666667
9 | 66 | 4 |  |  |  |  |  |  |  |  |  |  | 10 | 9 | 4.166666666666667
10 | 30 | 9 |  |  |  |  |  |  |  |  |  |  | 8 | 10 | 4.166666666666667
11 | 67 | 2 |  |  |  |  |  |  |  |  |  |  | 2 | 11 | 4.166666666666667
12 | 39 | 8 |  |  |  |  |  |  |  |  |  |  | 4 | 0 | 0
Spreadsheet: 810206d1671602050-convert-horizontal-table-to-vertical-table-form-conversion
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | Result
A | Bangkok | 0.05 | Phuket | 0.06 | Nakhon Sawan | 0.07 |  |  |  |  | A | Bangkok | 0.05 |  |  | Bangkok | 0.05
B | [NAME] | 0.07 | Ayutthaya | 0.04 |  |  |  |  |  |  | A | Phuket | 0.06 |  | A | Phuket | 0.06
C | Pattaya | 0.03 | [NAME] | 0.1 | [NAME] | 0.09 | Pattani | 0.07 |  |  | A | Nakhon Sawan | 0.07 |  | A | Nakhon Sawan | 0.07
D | Rayong | 0.02 |  |  |  |  |  |  |  |  | B | [NAME] | 0.07 |  | B | [NAME] | 0.07
 |  |  |  |  |  |  |  |  |  |  | B | Ayutthaya | 0.04 |  | B | Ayutthaya | 0.04
 |  |  |  |  |  |  |  |  |  |  | C | Pattaya | 0.03 |  | C | Pattaya | 0.03
 |  |  |  |  |  |  |  |  |  |  | C | [NAME] | 0.1 |  | C | [NAME] | 0.1
 |  |  |  |  |  |  |  |  |  |  | C | [NAME] | 0.09 |  | C | [NAME] | 0.09
 |  |  |  |  |  |  |  |  |  |  | C | Pattani | 0.07 |  | C | Pattani | 0.07
 |  |  |  |  |  |  |  |  |  |  | D | Rayong | 0.02 |  | D | Rayong | 0.02
Spreadsheet: andy_zipper__546__11_19_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL Z1 | EXP |  |  | 61.2 | 72.3 | 0.9 | 2001-11-13 14:31:00
 | CL F2 | 17.5 | 250 | 258 | 68.7 | 70.9 | 0.77 | 2001-11-19 10:59:00
 | CL G2 | 17.5 | 345 | 355 | 62.5 | 64.3 | 0.7 | 2001-11-19 10:59:00
 | CL H2 | 18 | 400 | 420 | 57.8 | 60.7 | 0.67 | 2001-11-19 10:59:00
 | CL J2 | 18 | 445 | 465 | 55.9 | 58.4 | 0.65 | 2001-11-19 10:59:00
 | CL K2 | 18.5 | 485 | 505 | 52.5 | 54.7 | 0.62 | 2001-11-19 10:59:00
 | CL M2 | 18.5 | 505 | 530 | 50.2 | 52.7 | 0.6 | 2001-11-19 10:59:00
 | CL N2 | 19 | 520 | 540 | 46.6 | 48.4 | 0.57 | 2001-11-19 10:59:00
 | CL Q2 | 19 | 535 | 560 | 45 | 47.1 | 0.55 | 2001-11-19 10:59:00
 | CL U2 | 19 | 545 | 570 | 43.4 | 45.4 | 0.53 | 2001-11-19 10:59:00
 | [NAME] | 19 | 550 | 580 | 41.6 | 43.9 | 0.51 | 2001-11-19 10:59:00
 | CL X2 | 19 | 550 | 580 | 39.8 | 42 | 0.49 | 2001-11-19 10:59:00
 | [NAME] |  |  |  | 37.8 | 39.1 | 0.47 | 2001-11-19 10:15:00
 | CL M3 |  |  |  | 30.6 | 32.6 | 0.4 | 2001-11-19 10:15:00
 | CL Z3 |  |  |  | 27.1 | 29.1 | 0.35 | 2001-11-19 10:15:00
Spreadsheet: f044472d-a084-410c-a31d-9ae94c5c967e
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  | U.S. Census Bureau
 |  | Source: Construction Spending
 |  | Annual Rate for Total Construction: U.S. Total
 |  | Seasonally Adjusted Total Construction [Millions of Dollars]
 |  | Period: 2002 to 2012
 |  | Data Extracted on: October 30, 2014 (7:57 pm)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
2002 | 858654 | 862338 | 844551 | 858240 | 850935 | 846777 | 847129 | 839008 | 832134 | 839690 | 844697 | 855921
2003 | 863855 | 859225 | 851132 | 859459 | 866814 | 880865 | 891264 | 901839 | 911589 | 925732 | 925985 | 948491
2004 | 938826 | 938656 | 960946 | 967761 | 974158 | 983072 | 1006119 | 1013724 | 1012290 | 1015562 | 1023210 | 1037684
2005 | 1036187 | 1056492 | 1065262 | 1058365 | 1078586 | 1089505 | 1109691 | 1119782 | 1131739 | 1145663 | 1156977 | 1178305
2006 | 1183861 | 1199767 | 1213270 | 1183485 | 1180059 | 1172932 | 1165093 | 1158193 | 1151104 | 1139292 | 1137488 | 1153491
2007 | 1149899 | 1156008 | 1167402 | 1159124 | 1168195 | 1166892 | 1154018 | 1160593 | 1165162 | 1152511 | 1127558 | 1108958
2008 | 1106498 | 1092911 | 1095194 | 1092939 | 1091569 | 1075482 | 1067380 | 1058675 | 1056892 | 1051176 | 1031004 | 994216
2009 | 965270 | 962482 | 956133 | 931610 | 914093 | 903987 | 901735 | 891278 | 881340 | 870697 | 852896 | 832484
2010 | 818468 | 798063 | 807437 | 825626 | 817745 | 817869 | 790519 | 793090 | 800329 | 802013 | 799636 | 779919
2011 | 757900 | 754970 | 763454 | 772469 | 774148 | 797272 | 789632 | 801183 | 805565 | 806849 | 809833 | 817198
2012 | 823583 | 825774 | 834810 | 842898 | 861913 | 873069 | 864687 | 868246 | 876091 | 883853 | 879539 | 882637
Spreadsheet: 800584d1665746333-lookup-with-multiple-criteria-example5-2-
Sheet: Sheet1

Position | Player | Daily H'cap | GA Handicap | Gross | Nett | Gender |  | Daily H'cap |  | Male
1 | Carol | 26 | 23.1 | 93 | 67 | Female | A Grade (M) | -100 | 12
2 | Garry | 30 | 29.2 | 98 | 68 | Male | B Grade (M) | 12 | 18
3 | Trevor | 14 | 14.5 | 83 | 69 | Male | C Grade (M) | 18 | 100
4 | [NAME] | 5 | 3.6 | 76 | 71 | Male
5 | [NAME] | 3 | 1.7 | 74 | 71 | Male |  | Daily H'cap |  | Female
6 | [NAME] | 13 | 10.7 | 84 | 71 | Male | A Grade (F) | -100 | 20
7 | [NAME] | 18 | 18.0 | 89 | 71 | Male | B Grade (F) | 20 | 100
8 | Billy | 14 | 11.5 | 86^^ | 72^^ | Male
9 | Martina | 16 | 14.1 | 88 | 72 | Female
10 | [NAME] | 5 | 3.2 | 77 | 72 | Male
11 | [NAME] | 13 | 13.6 | 86 | 73 | Male
12 | [NAME] | 9 | 7.6 | 82 | 73 | Male
13 | [NAME] | 12 | 9.6 | 85 | 73 | Male
14 | [NAME] | 13 | 11.0 | 86 | 73 | Male
15 | [NAME] | 18 | 18.2 | 91 | 73 | Male
16 | Ian | 3 |  |  | 74 | Male
 | Ian | 4 |  |  | 75
PAR COMP
Position | Player | Daily H'cap | GA Handicap | Gross | Nett | Gender |  | Daily H'cap
1 | [NAME] | 15 | 11.8 | 58 | +3 | Male | A Grade (M) | -100 | 12
2 | [NAME] | 23 | 21.7 | 77 | +3 | Male | B Grade (M) | 12 | 18
3 | [NAME] | 15 | 14.1 | 66 | +2 | Male | C Grade (M) | 18 | 100
4 | Nathan | 6 | 4.4 | 76 | +2 | Male
5 | [NAME] | 10 | 8.0 | 61 | +2 | Male |  | Daily H'cap |  | Female
6 | [NAME] | 14 | 11.6 | 78 | +2 | Male | A Grade (F) | -100 | 20
7 | [NAME] | 9 | 6.8 | 51 | +1 | Male | B Grade (F) | 20 | 100
8 | [NAME] | 15 | 14.0 | 50 | +1 | Male
9 | Jeanne | 23 | 19.2 | 73 | +1 | Female
10 | [NAME] | 14 | 11.1 | 84 | +1 | Male
11 | [NAME] | 16 | 15.4 | 73 | +1 | Male
12 | [NAME] | 17 | 16.7 | 68 | +1 | Male
13 | [NAME] | 26 | 21.3 | 60 | 0 | Male
14 | Mark | 16 | 13.3 | 76 | 0 | Male
15 | [NAME] | 34 | 29.5 | 61 | 0 | Female
STABLEFORD COMP
Position | Player | Daily Handicap | GA Handicap | Gross | Nett |  |  | Daily H'cap
1 | [NAME] | 15 | 15.2 | 81 | 42 | Male | A Grade (M) | -100 | 12
2 | [NAME] | 23 | 22.7 | 74 | 41 | Male | B Grade (M) | 12 | 18
3 | Mark | 7 | 5.8 | 78 | 37 | Male | C Grade (M) | 18 | 100
4 | [NAME] | 22 | 18.8 | 86 | 37 | Female
5 | Martina | 18 | 15.2 | 89 | 37 | Female |  | Daily H'cap |  | Female
6 | [NAME] | 12 | 10.2 | 70 | 37 | Male | A Grade (F) | -100 | 20
7 | Ian | 20 | 20.0 | 86 | 36 | Male | B Grade (F) | 20 | 100
8 | [NAME] | 6 | 4.9 | 79 | 35 | Female
9 | [NAME] | 14 | 14.1 | 73 | 35 | Male
10 | [NAME] | 14 | 11.5 | 87 | 35 | Female
11 | [NAME] | 12 | 9.4 | 78 | 35 | Male
12 | [NAME] | 11 | 9.1 | 85 | 34 | Male
13 | [NAME] | 19 | 16.1 | 77 | 34 | Female
14 | [NAME] | 24 | 23.9 | 83 | 34 | Male
15 | [NAME] | 17 | 17.2 | 76 | 34 | Male
Spreadsheet: 701911d1603985862-create-duplicate-records-based-on-t-7-recurring-row-help-test
Sheet: Sheet1

Musician | Instrument | Location | [NAME] | Volume | Date
[NAME] | Guitar | United Kingdom | Rock | High | 10/13/2020
[NAME] | Guitar | United Kingdom | Rock | High | 10/13/2020
[NAME] | Guitar | United Kingdom | Rock | Low | 10/13/2020
[NAME] | Guitar | United Kingdom | Rock | Low | 10/13/2020
Ringo Starr | Drums | United Kingdom | Rock | Medium | 10/13/2020
Ringo Starr | Drums | United Kingdom | Rock | Mid-High | 10/13/2020
Ringo Starr | Drums | United Kingdom | Rock | Medium | 10/13/2020
Ringo Starr | Drums | United Kingdom | Rock | Mid-High | 10/13/2020
Ringo Starr | Drums | United Kingdom | Rock | Low | 2020-10-14 00:00:00
Ringo Starr | Drums | United Kingdom | Rock | High | 2020-10-14 00:00:00
Ringo Starr | Drums | United Kingdom | Rock | Low | 2020-10-14 00:00:00
Cliff [NAME] | [NAME] | United States | Metal | Low | 10/13/2020
Cliff [NAME] | [NAME] | United States | Metal | High | 10/13/2020
Iggy Pop | Vocals | United States | Rock | High | 2020-10-15 00:00:00
[NAME] | Keyboard | United Kingdom | Prog | Medium | 2020-10-16 00:00:00
[NAME] | Keyboard | United Kingdom | Prog | Medium | 2020-10-16 00:00:00
[NAME] | Saxophone | United States | Jazz | Medium | 2020-10-16 00:00:00
[NAME] | Saxophone | United States | Jazz | Low | 2020-10-16 00:00:00
[NAME] | Harmonica | United States | Blues | High | 2020-10-20 00:00:00
[NAME] | Harmonica | United States | Blues | Low | 2020-10-20 00:00:00
[NAME] | Woodblock | United States | Folk | Medium | 2020-10-28 00:00:00
Spreadsheet: 674147d1587675325-accrued-interest-w-prepayments-formula-interst
Sheet: Sheet1

Value | Completed | Excluded | % | Sums | Result
100 | 50
100 | 52
100 | 100 | x
100 | 0
100 | 40
100 | 90
EXCLD_COL = C2:C7 |  |  | Result:
Spreadsheet: 93398d1292975188-table-to-list-data-formatting-problem-table-to-list
Sheet: Sheet1

All areas in blue font are variable and could be changed with each table.
 |  | No. Of Columns | 5
 |  | No. Of Rows | 9
 |  |  |  |  |  |  |  |  |  |  | Function | Function
 | 1 | 2 | 3 | 4 | 5 |  |  | Column | Row |  | INDIRECT | INDEX
1 | Date | Cost | Percentage | Water | Add |  |  | 1 | 1
2 | 2010-12-12 00:00:00 | 15 | 0.08 | Dry | No
3 | 2010-12-13 00:00:00 | 16 | 0.09 | Wet | Yes
4 | 2010-12-14 00:00:00 | 17 | 0.1 | Medium | No
5 | 2010-12-15 00:00:00 | 18 | 0.11 | Tepid | Maybeish
6 | 2010-12-16 00:00:00 | 19 | 0.12 | Warm | Yes
7 | 2010-12-17 00:00:00 | 20 | 0.13 | Medium | Yes
8 | 2010-12-18 00:00:00 | 21 | 0.14 | Tepid | No
9 | 2010-12-19 00:00:00 | 22 | 0.15 | Dry | No
Spreadsheet: phillip_m_love__30155__9902_OA
Sheet: SE-LRC-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  LRC
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 8756483 | 15999987
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 2430728 | 4354318.579700247
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 11187211 | 20354305.57970025
 | Purchases:
6 |  | 3rd Party / Inter Enron | -3595574 | -6362818
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -8411446 | -14851847
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 0 | 0
 | Total Purchases: |  | -12007020 | -21214665
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales | 842723 | 1517548
12 |  | Purchases | -922792 | -1649530
 | Total Intra CTS Sales / Purchases |  | -80069 | -131982
 | Imbalances:
13 |  | In Kind | 0 | 0
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | 0 | 0
 | Storage:
17 |  | Injection (Sales to Stg) | 1542723 | 2816830
18 |  | W/D (Purchase from Stg) | -922792 | -1670255
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -922792 | -1670255
 | Total Storage: |  | 619931 | 1146575
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | 190556 | 337495.1715445606
 |  |  | 0 | 0
23 | Fuel: |  | 0 | 0
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | 0
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | 0
 | Transport Revenue:
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 112176.6
 | Total Transport Revenue: |  | 0 | 112176.6
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance | 0 | 0
31 |  | Prior Month Book Balance | 0 | 0
 |  | Total MTM Income | 0 | 0
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 0
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | 0
36 |  | Asset Group Demand Charges | 0 | -3000000
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 0
 |  | TOTAL
Spreadsheet: 703611d1605084901-exclude-range-from-randbetween-test
Sheet: Toys

[NAME] |  | [NAME] |  | [NAME] |  | Sophie
Toys |  | Toys |  | Toys |  | Toys
Bouncy Ball |  | Rings |  | Bouncy Ball |  | Spinner
Spinner |  | Bouncy Ball |  | Car |  | Car
Rings |  | Car |  | Action Man |  | Bouncy Ball
Action Man |  | Console |  |  |  | Teddy
 |  | Teddy |  |  |  | Tea Set
 |  | [NAME]
Spreadsheet: 813705d1673946309-index-placing-the-same-name-for-multiple-matching-values-solved-gdkp-raffle-sheet-sample
Sheet: Sheet1

Zzyxk's 50/50 GDKP Raffle |  |  |  |  |  |  |  |  |  |  |  | Top Contributors |  |  |  |  |  |  |  | All Contributors |  |  |  |  | Every Contribution
 |  |  |  |  |  | Total
Name | # of tickets | current total | roll needed to win |  |  |  |  |  |  |  |  | Rank | Name |  |  | Total  Tickets |  |  |  | Name | Total  Tickets |  |  |  | Name | Tickets
A | 5 |  | 1 | to |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | A | 10
B | 1 |  |  | to |  | GDKP Cut |  |  |  |  |  | 2 |  |  |  |  |  |  |  | B |  |  |  |  | B | 12
C | 10 |  |  | to |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  | F |  |  |  |  | F | 6
D | 12 |  |  | to |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  | Q |  |  |  |  | Q | 20
E | 7 |  |  | to |  | Winner Cut |  |  |  |  |  | 5 |  |  |  |  |  |  |  | R |  |  |  |  | R | 14
F | 3 |  |  | to |  |  |  |  |  |  |  | 6 |  |  |  |  |  |  |  | S |  |  |  |  | S | 4
G | 17 |  |  | to |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  |  | U |  |  |  |  | U | 7
H | 3 |  |  | to |  | Roll |  |  |  |  |  | 8 |  |  |  |  |  |  |  | V |  |  |  |  | V | 11
 |  |  |  | to |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  | W |  |  |  |  | W | 10
 |  |  |  | to |  | 10 |  |  |  |  |  | 10 |  |  |  |  |  |  |  | X |  |  |  |  | X | 8
 |  |  |  | to |  | Winner |  |  |  |  |  | Current Leader |  |  |  |  |  |  |  | C |  |  |  |  | C | 4
 |  |  |  | to |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E |  |  |  |  | E | 3
 |  |  |  | to |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D |  |  |  |  | D | 9
 |  |  |  | to |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G |  |  |  |  | F | 7
 |  |  |  | to |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H |  |  |  |  | G | 14
 |  |  |  | to |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QQ |  |  |  |  | H | 11
 |  |  |  | to |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | 5
 |  |  |  | to |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | 1
 |  |  |  | to |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | 10
 |  |  |  | to |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 12
 |  |  |  | to |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E | 7
 |  |  |  | to |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F | 3
 |  |  |  | to |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G | 17
 |  |  |  | to |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | 3
 |  |  |  | to |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | 5
 |  |  |  | to |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QQ | 28
 |  |  |  | to |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | 3
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
Spreadsheet: 696227d1600708971-im-getting-strange-results-on-a-right-function-timestamp
Sheet: Sheet1

Timestamp | Data |  | Excel Date/Time | Excel Hr. |  | 1
2020-09-19 20:00:00 | 0.05226000025868416
2020-09-19 21:00:00 | -0.03311999887228012
2020-09-19 22:00:00 | -0.09425000101327896
2020-09-19 23:00:00 | -0.1341300010681152
2020-09-20 00:00:00 | 0.03122000023722649
2020-09-20 01:00:00 | -0.0473800003528595
2020-09-20 02:00:00 | 0.08647000044584274
2020-09-20 03:00:00 | 0.05338000133633614
2020-09-20 04:00:00 | 0.1236800029873848
2020-09-20 05:00:00 | -0.09510999917984009
2020-09-20 06:00:00 | 0.119939997792244
2020-09-20 07:00:00 | 0.2215099930763245
2020-09-20 08:00:00 | 0.2634499967098236
2020-09-20 09:00:00 | 0.2864499986171722
2020-09-20 10:00:00 | 0.2536199986934662
2020-09-20 11:00:00 | 0.2222899943590164
2020-09-20 12:00:00 | 0.2321500033140182
2020-09-20 13:00:00 | 0.2240899950265884
2020-09-20 14:00:00 | -0.1279900074005127
2020-09-20 15:00:00 | -0.06380999833345413
2020-09-20 16:00:00 | 0.1372800022363663
2020-09-20 17:00:00 | 0.2513700127601624
2020-09-20 18:00:00 | 0.2555699944496155
2020-09-20 19:00:00 | 0.1463399976491928
2020-09-20 20:00:00 | 0.1109500005841255
2020-09-20 21:00:00 | -0.002189999911934137
2020-09-20 22:00:00 | -0.03523999825119972
2020-09-20 23:00:00 | 0.09442000091075897
2020-09-21 00:00:00 | 0.1458200067281723
2020-09-21 01:00:00 | 0.1437699943780899
2020-09-21 02:00:00 | 0.1713099926710129
2020-09-21 03:00:00 | 0.3483900129795074
2020-09-21 04:00:00 | 0.4153099954128265
2020-09-21 05:00:00 | 0.3052200078964233
2020-09-21 06:00:00 | 0.2980599999427795
2020-09-21 07:00:00 | 0.2941200137138367
2020-09-21 08:00:00 | 0.2548500001430511
2020-09-21 09:00:00 | 0.2253500074148178
2020-09-21 10:00:00 | 0.1821299940347672
2020-09-21 11:00:00 | 0.2338400036096573
Spreadsheet: 686100d1594363378-monthly-training-data-book2
Sheet: Sheet1

Title in English | Language | Team A | Trainer | Planned date 2020 | Performed date 2020 | Team B | Trainer | Planned date 2020 | Performed date 2020 | Team C | Trainer | Planned date 2020 | Performed date 2020 | Team D | Trainer | Planned date 2020 | Performed date 2020
Training-1 | EN |  | Person-A | 2020-11-20 00:00:00 |  |  |  |  |  |  | Person X | 2020-04-10 00:00:00 | 2020-06-10 00:00:00 |  | Person-A | 2020-07-20 00:00:00 | 2020-07-12 00:00:00
Training-2 | EN |  |  |  |  |  | Person X | 2020-04-10 00:00:00 | 2020-06-10 00:00:00 |  |  |  |  |  | Person-C | 2020-07-20 00:00:00 | 2020-07-12 00:00:00
Training-3 | EN |  | Person-B | 2020-07-20 00:00:00 | 2020-07-12 00:00:00 |  | Person X | 2020-04-10 00:00:00 | 2020-06-10 00:00:00 |  | Person-A | 2020-02-02 00:00:00 | 2020-03-03 00:00:00
Training-4 | EN
Training-5 | EN |  | Person X | 2020-04-10 00:00:00 | 2020-06-10 00:00:00 |  |  |  |  |  | Person-E | 2020-07-30 00:00:00 | 2020-07-30 00:00:00 |  | Person X | 2020-04-10 00:00:00 | 2020-06-10 00:00:00
 |  |  |  |  |  |  | Training for | 2020-07-01 00:00:00
 |  |  |  | Sr No. | Training Title | Team Name | Performed Date | Trainer Name
 |  |  |  | 1 | Training-1 | Team D | 2020-07-12 00:00:00 | Person-A
 |  |  |  | 2 | Training-2 | Team D | 2020-07-12 00:00:00 | Person-C
 |  |  |  | 3 | Training-3 | Team A | 2020-07-12 00:00:00 | Person-B
 |  |  |  | 4 | Training-5 | Team C | 2020-07-30 00:00:00 | Person-E
Spreadsheet: 169884d1343087366-rank-with-sub-categories-and-tie-breaks-score-sheet-example
Sheet: Sheet1

Name | Class | score | tie | Overall Rank | Rank in Class
Viv | T | 101 | 64 | 1 | 1
[NAME] | X | 89 | 36 | 2 | 1
Rachel | X | 89 | 24 | 3 | 1
[NAME] | T | 67 | 67 | 4 | 2
[NAME] | T | 65 | 23 | 5 | 3
[NAME] | T | 57 | 96 | 6 | 4
[NAME] | X | 56 | 24 | 7 | 3
[NAME] | T | 54 | 78 | 8 | 5
Smith | X | 54 | 23 | 9 | 4
[NAME] | X | 53 | 45 | 10 | 5
[NAME] | X | 52 | 34 | 11 | 6
[NAME] | T | 45 | 67 | 12 | 6
Mark | T | 43 | 74 | 13 | 7
[NAME] | X | 42 | 34 | 14 | 7
[NAME] | T | 35 | 45 | 15 | 8
[NAME] | X | 34 | 78 | 16 | 8
Homer | T | 34 | 34 | 17 | 9
[NAME] | T | 34 | 23 | 18 | 9
Fred | X | 33 | 56 | 19 | 9
[NAME] | X | 23 | 67 | 20 | 10
[NAME] | T | 23 | 34 | 21 | 11
Bloggs | X | 0 | 56 | 22 | 11
Spreadsheet: 49914d1249338508-how-to-average-dynamic-data-for-specific-categoris-from-a-different-worksheet-average-8-3-09
Sheet: Feb

Category | Days to Close | Agent Name
401K | 2 | [NAME]
401K | 5 | [NAME]
COBRA | 3 | Yolanda
COBRA | 4 | [NAME]
Paychecks | 6 | Yolanda
Paychecks | 3 | [NAME]
Paychecks | 1 | [NAME]
Spreadsheet: 68904d1269439297-check-boxes-for-line-graphs-book1
Sheet: Average Fee

 |  | COST - AVERAGE FEE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Target | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Red | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400
 |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
0 |  | Labour | 25 | 25 | 25 | 25 | 25 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
0 |  | Equipment | 50 | 50 | 50 | 50 | 50 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
0 |  | Distance | 5 | 5 | 5 | 5 | 5 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  | BACK TO COST SUMMARY
 |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Spreadsheet: fba35d11-91af-465c-b59c-b03007667167
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
OVMU | Test | OVMU | Ovomucoid, IgE | Ovomucoid, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday, 9 a.m.-8 p.m., Saturday 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
OVMU | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
OVMU | Result | OVMU | Ovomucoid, IgE | Ovomucoid, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 7557-2