tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: a56800dd-cb8f-4357-987b-595ccab71246
Sheet: Sheet1

OPERATING/PROGRAMMATIC | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Legislative Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | Missouri Department of Health and Senior Services, Unit of Chronic Disease Control
 | [PHONE]
Does this Legislation Estimate New or Additional Revenues to the City? |  |  |  |  |  |  |  | No |  | x | Yes
 | If yes, please identify in  which Fund these revenues will be deposited (e.g. General, Sales Tax)
 | and provide the following revenue information:
 | Revenue Detail |  |  |  | FY2006-07 |  |  | FY2007-08
 | General Fund |  |  |  | 159084 |  |  | 0
 | Special Revenue
 | Enterprise
 |  |  | Total: | $ | 159084 |  | $ | 0
 | (Please detail type of revenue (fees, grants, tax) and change that will occur as a result of this legislation.  Provide multi-year
 | estimates if known, or if grant revenue please identify source of funds (federal or state) and duration of grant support)
Does this Legislation increase appropriations in the current budget? |  |  |  |  |  |  |  | No |  | x | Yes
 | If Yes, please complete the following budget information:
 | Expense Detail |  |  |  | FY2006-07 |  |  | FY2007-08
 | General Fund |  |  |  | 159084 |  |  | 0
 | Special Revenue
 | Enterprise/Other
 |  |  | Total: | $ | 159084 |  | $ | 0
 | Please detail the extent to which these increased appropriations will be of a permanent nature (e.g. number of
 | additional staff, facilities, long-term contracts)
 | Same as above
Does this Legislation expand the scope of current city services? |  |  |  |  |  |  |  | No |  | x | Yes
 | (Please detail estimate number of people to be served, who is delivering services currently to that population, service
 | performance expectations, and if grant supported, provisions for support if grant support ends.
 | The City will increase contracts with non municipal agencies from 28 to 41.
Is this legislation the result of a federal or state legislative mandate? |  |  |  |  |  |  | x | No |  |  | Yes
 | (If yes, please detail the purpose and source for that mandate).
Reviewed by:
 | 0ffice of Management and Budget |  |  | OMB Approval Date
Spreadsheet: 01ce1a93-6e8d-439d-9341-ce8d8723e0a4
Sheet: Sheet1

WPU Value, Fiscal Years 1976-2008 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
 | WPU | Dollar | Percent
Year | Value | Change | Change
1975-76 | 621 | 0 | -----
1976-77 | 683 | 62 | 0.0998389694041868
1977-78 | 732 | 49 | 0.07174231332357248
1978-79 | 795 | 63 | 0.0860655737704918
1979-80 | 852 | 57 | 0.07169811320754717
1980-81 | 946 | 94 | 0.1103286384976526
1981-82 | 1003 | 57 | 0.06025369978858351
1982-83 | 1103 | 100 | 0.09970089730807577
1983-84 | 1103 | 0 | 0
1984-85 | 1124 | 21 | 0.01903898458748867
1985-86 | 1180 | 56 | 0.0498220640569395
1986-87 | 1204 | 24 | 0.02033898305084746
1987-88 | 1204 | 0 | 0
1988-89 | 1204 | 0 | 0
1989-90 | 1240 | 36 | 0.02990033222591362
1990-91 | 1346 | 106 | 0.08548387096774193
1991-92 | 1408 | 62 | 0.04606240713224369
1992-93 | 1490 | 82 | 0.05823863636363636
1993-94 | 1539 | 49 | 0.03288590604026845
1994-95 | 1608 | 69 | 0.04483430799220273
1995-96 | 1672 | 64 | 0.03980099502487562
1996-97 | 1739 | 67 | 0.04007177033492823
1997-98 | 1791 | 52 | 0.02990224266820012
1998-99 | 1854 | 63 | 0.03517587939698492
1999-00 | 1901 | 47 | 0.02535059331175836
2000-01 | 2006 | 105 | 0.05523408732246186
2001-02 | 2116 | 110 | 0.05483549351944168
2002-03 | 2132 | 16 | 0.007561436672967864
2003-04 | 2150 | 18 | 0.008442776735459663
2004-05 | 2182 | 32 | 0.01488372093023256
2005-06 | 2280 | 98 | 0.04491292392300641
2006-07 | 2417 | 137 | 0.06008771929824561
2007-08 | 2514 | 97 | 0.04013239553165081
Average increase from 1977 to 2008: |  |  | 0.0450820541371127
10-year increase from 1999 to 2008: |  |  | 0.3466170266422097
10-year average increase from 1999 to 2008: |  |  | 0.03466170266422097
Spreadsheet: 79100d1279314418-formula-processing-example_hlookup
Sheet: Sheet1

[NAME] | Desc | $0 - $4999 | $5000 - $9999 | $10,000+ | Suggested Wholesale | order
 | Dampers
5CO-09100 | Lock-Top 8"x8" Damper | 96.58 | 91.75 | 87.17 | 120.73
5CO-09110 | Lock-Top 8"x13" Damper | 99 | 94.05 | 89.35 | 123.75
5CO-09115 | Lock-Top 8"x17" Damper | 124.52 | 118.29 | 112.38 | 155.65
5CO-09120 | Lock-Top 13"x13" Damper | 101.2 | 96.14 | 91.33 | 126.5
5CO-09125 | Lock-Top 13"x17" Damper | 130.2 | 123.69 | 117.51 | 162.75
5CO-09130 | Lock-Top 17"x17" Damper | 152.68 | 145.05 | 137.79 | 190.85
5CO-09501 | Lock-Top II 8"x8" Chimney Cap | 134.11 | 127.41 | 121.04 | 167.64
5CO-09503 | Lock-Top II 8"x13" Chimney Cap | 141.71 | 134.63 | 127.9 | 177.14
5CO-09505 | Lock-Top II 8"x17" Chimney Cap | 180.22 | 171.21 | 162.65 | 225.28
5CO-09507 | Lock-Top II 13"x13" [NAME] | 154.8 | 147.06 | 139.71 | 193.5
5CO-09509 | Lock-Top II 13"x17" Chimney Cap | 168.46 | 160.04 | 152.04 | 210.58
5CO-09510 | Lock-Top II 17"x17" Chimney Cap | 218.49 | 207.56 | 197.19 | 273.11
5CO-09512 | Lock-Top II 8" x 8" Cap w-5/8" Mesh | 134.04 | 127.34 | 120.97 | 167.55
5CO-09515 | Lock-Top II 8"x13" [NAME] w-5/8" Mesh | 145.46 | 138.18 | 131.27 | 181.82
5CO-09518 | Lock-Top II 8"x17" Cap w-5/8" Mesh | 183.95 | 174.75 | 166.02 | 229.94
5CO-09520 | Lock-Top II 13"x13" [NAME] w-5/8" Mesh | 158.48 | 150.56 | 143.03 | 198.1
5CO-09522 | Lock-Top II 13"x17" Cap w-5/8" Mesh | 178.22 | 169.31 | 160.85 | 222.78
5CO-12108 | [NAME]; 8"x8" | 79.16 | 75.2 | 71.44 | 98.95
5CO-12109 | [NAME]; 9"x13" | 81.8 | 77.71 | 73.82 | 102.25
5CO-12110 | [NAME]; 8"x17" | 87.96 | 83.56 | 79.38 | 109.95
5CO-12113 | [NAME] Damper;13"x13" | 88.54 | 84.12 | 79.91 | 110.68
5CO-12116 | [NAME]" | 99.05 | 94.1 | 89.39 | 123.81
5CO-12117 | [NAME] Damper;17"x17" | 121.14 | 115.08 | 109.33 | 151.42
5CO-12118 | [NAME] Damper;13"x18" | 101.16 | 96.1 | 91.3 | 126.45
5CO-12130 | [NAME] Damper;12" Round | 83.56 | 79.38 | 75.41 | 104.45
5CO-12408 | Lyemance [NAME], 8"x13" | 40.97 | 38.41 | 36.87 | 51.21
5CO-12411 | Lyemance [NAME], 13"x13" | 48.94 | 45.88 | 44.04 | 61.17
5CO-12412 | Lyemance [NAME], 13"x18" | 60.34 | 56.57 | 54.3 | 75.42
Spreadsheet: c3bb0aa4-e5a2-43d1-adc9-abd6da365fa5
Sheet: Sheet1

ID | Subtype | Semen | Semen.1 | Slatkin-Maddison
 |  | Amplification | Compartment | 10,000 permutations with and without amplified semen variants
C007 | C | [NAME] | Equilibrated | With amp P = 0.0001; without amp P = 0.0576
C009 | C | [NAME] | Equilibrated | With amp P = 0.186; without amp P =0.3312
C011 | C | No [NAME] | Equilibrated | P = 0.066
C012 | C | [NAME] | Equilibrated | With amp P = 0.0628; without amp P = 0.0988
C018 | C | No [NAME] | Compartmentalized | P < 0.0007
C019 | C | [NAME] | Equilibrated | With amp P = 0.0035; without amp P = 0.1149
C047 | C | [NAME] | Compartmentalized | With amp P < 0.0002; without amp P < 0.0007
C070 | C | [NAME] | Equilibrated | With amp P = 0.3126; without amp P = 0.4564
C083 | C | No [NAME] | Compartmentalized | P < 0.0002
C109 | C | [NAME] | Equilibrated | With amp P = 0.0004; without amp P = 1
C111 | C | No [NAME] | Equilibrated | P = 0.2178
C113 | C | [NAME] | Compartmentalized | With amp P = 0.0002; without amp P = 0.0001
700010333 | B | [NAME] | Equilibrated | With amp P < 0.0001; without amp P = 0.0245
700010501 | B | [NAME] | Equilibrated | With amp P = 0.0029; without amp P = 0.0311
701010380 | B | [NAME] | Compartmentalized | With amp P = 0.0002; without amp P = 0.0009
700011145 | B | [NAME] | Equilibrated | With amp P = 0.0263; without amp P - 0.0459
Spreadsheet: 879144d1726585885-countif-counting-blank-cells-with-formula-in-it-countif-workbook
Sheet: Sheet1

Data set | [NAME] |  | Data set | [NAME]
George |  |  | George | 1
George |  |  | George | 2
[NAME] |  |  | [NAME]
Spreadsheet: 866328d1713279761-count-of-time-within-a-time-count-of-time-within-a-time
Sheet: Sheet1

 | August
 | Employee Name | 5
 |  | Start | End | 210
 | Test | 09:00:00 | 15:00:00
 | Test 2 | 09:00:00 | 14:30:00
 | Test 3 | 10:00:00 | 14:00:00
 | Test 4 | 09:00:00 | 15:15:00
 | Test 5 | 08:45:00 | 16:45:00
 | Shift Category
 | 08:45 - 09:00
 | 09:00 - 09:15
 | 09:15 - 09:30
 | 09:30 - 09:45
 | 09:45 - 10:00
 | 10:00 - 10:15
 | 10:15 - 10:30
 | 10:30 - 10:45
 | 10:45 - 11:00
 | 11:00 - 11:15
 | 11:15 - 11:30
 | 11:30 - 11:45
 | 11:45 - 12:00
 | 12:00 - 12:15
 | 12:15 - 12:30
 | 12:30 - 12:45
 | 12:45 - 13:00
 | 13:00 - 13:15
 | 13:15 - 13:30
 | 13:30 - 13:45
 | 13:45 - 14:00
 | 14:00 - 14:15
 | 14:15 - 14:30
 | 14:30 - 14:45
 | 14:45 - 15:00
 | 15:00 - 15:15
 | 15:15 - 15:30
 | 15:30 - 15:45
 | 15:45 - 16:00
 | 16:00 - 16:15
 | 16:15 - 16:30
 | 16:30 - 16:45
 | 16:45 - 17:00
Spreadsheet: phillip_m_love__30084__aaaCredit Report
Sheet: Sheet1

DEAL ORIGINATION REPORT
Deals Input on 3/26/01
PENDING CREDIT ITEMS
Counterparty | Deal Number | Deal Type | Comm | Contact/Action Needed
Casco Inc. | QZ1467.1 | P | NG | [NAME]
[NAME] | QY6093.8/9 | F | SCRC | [NAME]
Harsco Corporation | [NAME] | F | SHRC | [NAME]
ICC Energy Corporation | QZ2031.1 | P | NG | [NAME]
Mainline Energy, L.L.C. | QZ1889.1/2 QZ0655.1 QZ2019.1 QZ20360.1 | P | NG | [NAME]
NDR Energy Group, LLC | QZ0822.1 | P | NG | [NAME]
New Counterparty | QY3918.D QY5241.9 QY6341.7/8/9 | F | SHRC/SCRC | [NAME]
Olympic Steel, Inc. | QZ0466.1/2/3/4 | P | SHRC | [NAME]
Power Gas Marketing & Transmission | QZ0783.1/2 | P | NG | [NAME]
Rumpke Consolidated Companies | QZ1633.1 | F | ONP | [NAME]
South Florida Natural Gas Co | QZ1238.1 | P | NG | [NAME]
Stahlschmidt Trading Limited | QY6526..7/8 QY6532.7/8 | F | SCRC SHRC | [NAME]
[NAME], LLC | QZ1557.1 QZ1674.1 | F | ONP | [NAME]
REBOOK ITEMS
Counterparty | Deal Number | Deal Type | Comm | Rebook To--
AIG Financial Products | QZ1236.1 | F | NG | AIG Energy Trading Inc.
Nexen Marketing U.S.A. Inc. | QZ0838.1 | F | NG | Nexen Marketing
Tenaska Energy Inc. | QZ1698.1 | F | NG | Tenaska Marketing Ventures
Unocal Energy Trading, Inc. | [NAME] | F | NG | Union Oil Company of California
W&T Offshore, LLC | QZ2119.1 | P | NG | W&T Offshore, Inc.
Spreadsheet: 796683d1663435055-convert-row-into-hmtl-table-book1
Sheet: Sheet1

SKU | STYLE NUMBER | DIAMETER | WHEEL WIDTH | FINISH
101-6631B | 1010 | 16 | 6.5 | NON CHROME
101-6631S | 1010 | 16 | 6.5 | NON CHROME
101-6741B | 1010 | 16 | 7 | NON CHROME
101-6741FB | 1010 | 16 | 7 | NON CHROME
101-6741P2D | 1010 | 16 | 7 | CHROME
101-6741S | 1010 | 16 | 7 | NON CHROME
102-8830B | 1020 | 18 | 8 | NON CHROME
Result
101-6631B | <table><td>STYLE NUMBER</td><td>1010</td></tr><tr><td>DIAMETER</td><td>16</td></tr><tr><td>WHEEL WIDTH</td><td>6.5</td></tr><tr><td>FINISH</td><td> NON CHROME</td></tr></table>
101-6631S | <table><td>STYLE NUMBER</td><td>1010</td></tr><tr><td>DIAMETER</td><td>16</td></tr><tr><td>WHEEL WIDTH</td><td>6.5</td></tr><tr><td>FINISH</td><td> NON CHROME</td></tr></table>
101-6741B | <table><td>STYLE NUMBER</td><td>1010</td></tr><tr><td>DIAMETER</td><td>16</td></tr><tr><td>WHEEL WIDTH</td><td>7</td></tr><tr><td>FINISH</td><td> NON CHROME</td></tr></table>
101-6741FB | <table><td>STYLE NUMBER</td><td>1010</td></tr><tr><td>DIAMETER</td><td>16</td></tr><tr><td>WHEEL WIDTH</td><td>7</td></tr><tr><td>FINISH</td><td> NON CHROME</td></tr></table>
101-6741P2D | <table><td>STYLE NUMBER</td><td>1010</td></tr><tr><td>DIAMETER</td><td>16</td></tr><tr><td>WHEEL WIDTH</td><td>7</td></tr><tr><td>FINISH</td><td> CHROME</td></tr></table>
101-6741S | <table><td>STYLE NUMBER</td><td>1010</td></tr><tr><td>DIAMETER</td><td>16</td></tr><tr><td>WHEEL WIDTH</td><td>7</td></tr><tr><td>FINISH</td><td> NON CHROME</td></tr></table>
102-8830B | <table><td>STYLE NUMBER</td><td>1020</td></tr><tr><td>DIAMETER</td><td>18</td></tr><tr><td>WHEEL WIDTH</td><td>8</td></tr><tr><td>FINISH</td><td> NON CHROME</td></tr></table>
Spreadsheet: 773728d1648027160-scenarios-how-can-i-list-a-number-of-results-exceeding-the-limit-of-32-cells-scenario_limits_example
Sheet: ENGINE 4

ENGINE 4
Nominal Power | 400
RPM | 4000
fuel consumption - full load | 400
fuel consumption - partial load | 200
fuel consumption - idle | 4
additive consumption - full load | 40
additive consumption - partial load | 20
additive consumption - idle | 4
emission 1 - full load | 6
emission 1 - partial load | 6
emission 1 - idle | 2.5
emission 2 - full load | 5
emission 2 - partial load | 3
emission 2 - idle | 2.2
emission 3 - full load | 10
emission 3 - partial load | 6
emission 3 - idle | 1.7
emission 4 - full load | 30
emission 4 - partial load | 30
emission 4 - idle | 2.1
emission 5 - full load | 15
emission 5 - partial load | 9
emission 5 - idle | 1.7
Spreadsheet: 770151d1645830861-sums-of-dynamic-unique-values-with-multiple-criteria-sample-tests
Sheet: combo box

Year |  |  |  |  |  | Negative bugs | Positive bugs |  | Negative bugs | Positive bugs
Type |  |  |  |  |  | Citrobacter freundii | Group B Strep |  | Citrobacter freundii |  | Group B Strep
 |  |  |  |  |  | E. coli | MRSA |  | E. coli |  | MRSA
 |  |  |  |  |  | Enterobacter cloacae complex | MSSA |  | Enterobacter cloacae complex |  | MSSA
 |  |  |  |  |  | Klebsiella aerogenes | Staphylococcus aureus |  | Klebsiella aerogenes |  | Staphylococcus aureus
 |  |  |  |  |  | Klebsiella pneumoniae |  |  | Klebsiella pneumoniae |  | 0
 |  |  |  |  |  | Morganella morganii |  |  | Morganella morganii |  | 0
 |  |  |  |  |  | Proteus mirabilis |  |  | Proteus mirabilis |  | 0
Spreadsheet: 16b4a616-1021-4c69-ae5c-e115faa07167
Sheet: 2012 reading grade 4

[NAME] |  | Total Number | [NAME]
[NAME] |  |  | Inconclusive | Exploring | Emerging | Developing | Novice | No Score
2010 | All Students | 703 | 15 | 18 | 31 | 20 | 8 | 7
2011 |  | 657 | 16 | 20 | 30 | 20 | 9 | 6
2012 | All Students | 661 | 17 | 20 | 29 | 21 | 8 | 5
 | Black/African American | 39 | 23 | 21 | 21 | 28 | 5 | 3
 | Hispanic/Latino | 238 | 20 | 23 | 31 | 17 | 5 | 4
 | White | 335 | 14 | 19 | 28 | 23 | 10 | 6
 | Two or more races | 25 | 24 | 20 | 20 | 24 | 8 | 4
 | Minority | 326 | 21 | 22 | 31 | 18 | 5 | 3
 | English Learners | 122 | 21 | 21 | 33 | 15 | 7 | 3
 | Free/Reduced Lunch | 360 | 16 | 21 | 29 | 23 | 7 | 4
 | Female | 240 | 19 | 21 | 27 | 20 | 7 | 5
 | Male | 419 | 17 | 20 | 30 | 21 | 8 | 4
Spreadsheet: 855021d1704741503-sum-of-columns-from-different-sheet-formula-copied-accross-to-more-sheets-area-140-relief-pharmacist-tracker
Sheet: Master

Relief 1 |  |  |  |  |  |  | Relief 2
Month | New Medicines Service |  | Hypertension Case Finding |  | Pharmacy First |  | Month | New Medicines Service |  | Hypertension Case Finding |  | Pharmacy First
 | Interventions | [NAME] | Stage 1 | Stage 2 ABPM |  |  |  | Interventions | [NAME] | Stage 1 | Stage 2 ABPM
January |  |  |  |  |  |  | January
February |  |  |  |  |  |  | February
March |  |  |  |  |  |  | March
April |  |  |  |  |  |  | April
May |  |  |  |  |  |  | May
June |  |  |  |  |  |  | June
July |  |  |  |  |  |  | July
August |  |  |  |  |  |  | August
September |  |  |  |  |  |  | September
October |  |  |  |  |  |  | October
November |  |  |  |  |  |  | November
December |  |  |  |  |  |  | December
Relief 3 |  |  |  |  |  |  | Relief 4
Month | New Medicines Service |  | Hypertension Case Finding |  | Pharmacy First |  | Month | New Medicines Service |  | Hypertension Case Finding |  | Pharmacy First
 | Interventions | [NAME] | Stage 1 | Stage 2 ABPM |  |  |  | Interventions | [NAME] | Stage 1 | Stage 2 ABPM
January |  |  |  |  |  |  | January
February |  |  |  |  |  |  | February
March |  |  |  |  |  |  | March
April |  |  |  |  |  |  | April
May |  |  |  |  |  |  | May
June |  |  |  |  |  |  | June
July |  |  |  |  |  |  | July
August |  |  |  |  |  |  | August
September |  |  |  |  |  |  | September
October |  |  |  |  |  |  | October
November |  |  |  |  |  |  | November
December |  |  |  |  |  |  | December
Spreadsheet: 187269d1350395849-conditional-formatting-based-on-values-from-a-pivot-conditional-formatting
Sheet: Pivot Data

SLN | Name | Type | Description | Participant | Rate | Unzee
124 | AA | Other | Eggs | GRU |  | 0.95
327 | AB | Local | Eggs | GRU |  | 1
473 | AC | Local | Eggs | GRU |  | 1
846 | AD | Other | Eggs | GRU |  | 0.95
596 | AE | Other | Eggs | GRU |  | 0.95
363 | AF | Local | Eggs | GRU |  | 1
172 | AG | Other | Eggs | GRU |  | 0.95
487 | AH | Local | Eggs | GRU |  | 1
986 | AI | Other | Eggs | GRU |  | 0.95
765 | AJ | Other | Eggs | GRU |  | 0.95
Spreadsheet: 690816d1597309613-simple-warehouse-location-management-template-my-sample-wms
Sheet: Rack A

RACK A
A1 |  |  |  | A2
Item Code | [NAME] | Quantity |  | Item Code | [NAME] | Quantity
CK1 | CK1 | 9 |  | CA1 | CA1 | 4
CK2 | CK2 | 12 |  | CA2 | CA2 | 231
CK3 | CK3 | 3 |  | CA3 | CA3 | 47
CK4 | CK4 | 54 |  | CK3 | CK3 | 52
CK5 | CK5 | 32 |  | CA5 | CA5 | 121
Spreadsheet: 49215d1248450802-match-function-across-multiple-sheets-example
Sheet: Sheet3

2007-01-31 00:00:00
2007-02-28 00:00:00
2007-03-31 00:00:00
2007-04-30 00:00:00
2007-05-31 00:00:00
2007-06-30 00:00:00
2007-07-31 00:00:00
2007-08-31 00:00:00
2007-09-30 00:00:00
2007-10-31 00:00:00
2007-11-30 00:00:00
2007-12-31 00:00:00
2008-01-31 00:00:00
2008-02-29 00:00:00
2008-03-31 00:00:00
2008-04-30 00:00:00
2008-05-31 00:00:00
2008-06-30 00:00:00
2008-07-31 00:00:00
2008-08-31 00:00:00
2008-09-30 00:00:00
2008-10-31 00:00:00
2008-11-30 00:00:00
2008-12-31 00:00:00
2009-01-31 00:00:00
2009-02-28 00:00:00
2009-03-31 00:00:00
2009-04-30 00:00:00
2009-05-31 00:00:00
2009-06-30 00:00:00
Spreadsheet: 581012d1531044400-creating-replacement-parts-list-supercede-data
Sheet: o

5214-077
Spreadsheet: 76588d1277142961-match-index-from-data-sheet-to-individual-sheet-subj-reimb-credit-calculation-question
Sheet: Study Site Data Sheet

Site:
COMS #:
CVD Study #:
Sponsor:
Protocol:
Number Screened:
Number Enrolled:
Number Failed:
Number Alternates
Number Completed:
Number Dropped:
Dropped Subjects:
 | Subject # | Day Dropped | Additional Procedures
Example | 115 | 12 | EKG, 2 vitals
1 |  | 28
2 |  | 28
3 |  | 28
4 |  | 28
5 |  | 28
6 |  | 28
7 |  | 28
8 |  | 28
9 |  | 28
10 |  | 28
11 |  | 28
12 |  | 28
13 |  | 28
14 |  | 28
15 |  | 28
16 |  | 28
17 |  | 28
18 |  | 28
19 |  | 28
20 |  | 28
Days Missed (Subject Reimbursement)
 | Subject # | Unit Days | Unit Day (by Exception)* | OPVs | Extended OPVs | Wash out < 5 Days | Wash out > 5 Days but < 10 Days | Wash out > 10 Days but < 15 Days | Continued participation through follow-up calculated as [NAME] out above | Diaries (per week)** | Telephone Contacts
Example | 110 | 2 |  | 1 |  |  |  | 1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
*Used for studies requiring extended in-house stays where stipends are >$10,000.  Discuss stipend options with the site for those studies.
**Varies depending on the type of diary/subject time commitment - minimum listed as default.
Spreadsheet: 51452d1251122715-counting-formula-retail-price-formula-issue
Sheet: Test Sheet

Item # | Product Description | Our Retail Price |  | Retailer 1 Price | Retailer 2 Price | Retailer 3 Price | Retailer 4 Price | Retailer 5 Price | Retailer 6 Price | Retailer 7 Price | Retailer 8 Price |  | Higher | Lower | Same
1 | Product a | 29.99 |  | 29.99 |  | 34.99 | 29.99 | 27.99 | 30 |  | 24.99
2 | Product b | 34.99 |  |  | 39.99 | 29.99 | 29.99 |  |  | 31.99 | 34.99
3 | Product c | 24.99 |  | 22.99 | 22.99 | 24.99 |  | 26.99 | 25.99 | 29.99
4 | Product d | 32.99 |  | 30.99 | 32.99 | 32.99 | 32.99 | 32.99 | 32.99 | 32.99 | 32.99
5 | Product e | 29.99 |  | 29.99 | 28.99 | 29.99 | 29.99 | 29.99 | 29.99 | 29.99 | 29.99
6 | Product g | 22.99 |  | 21.99 | 22.99 |  | 22.99 | 24.99 | 22.99 | 22.99 | 22.99
7 | Product h | 39.99 |  | 39.99 | 37.99 | 37.99 | 39.99 | 44.99 | 37.99 | 39.99 | 39.99
8 | Product i | 44.99 |  | 44.99 |  |  |  | 44.99 |  |  | 49.99
9 | Product j | 32.99 |  | 32.99 | 32.99 | 34.99 |  |  |  | 32.99
10 | Product k | 54.99 |  | 54.99 | 54.99 | 54.99 | 49.99 | 54.99 | 54.99 | 54.99 | 54.99
Spreadsheet: 145864d1331783460-merging-rows-with-same-values-in-first-columns-but-different-values-in-later-columns-database-mock-up-for-forum
Sheet: Sheet2

fullname | address | pcode | telephone | D2D | Computer | Data entry | Baking | Driver | Lit drops | Eday | Handyman | not specified | office | phone | sign crew | possible
[NAME], [NAME] | 22 1st st | 1A | 123 | X |  |  |  |  |  |  |  |  | X |  | X
Jones, [NAME] | 33 4th ave | 2B | 234 |  |  |  |  |  |  | X |  |  | X
Jones, [NAME] | 55 6th st | 1C | 987 |  |  |  |  |  |  |  |  |  |  |  | X
[NAME], [NAME] | 77 C road | 3D | n/a |  | X |  |  |  |  |  | X |  | X
[NAME], [NAME] | 8 2nd st | 4E | 456 |  |  |  | X
Hawkes, [NAME] | 999 23 ave | 3A | 345 | X |  |  |  |  | X |  |  |  | X
Cox, [NAME] | 123 CDE blvd | 4B | 567 |  |  |  |  |  |  |  |  | X
[NAME], [NAME] | 435 78 st | 5F | 678 |  |  | X |  |  |  | X
Ford, [NAME] | 876 34 ave | 6E | 789 | X |  | X |  | X |  |  |  |  |  |  | X
Spreadsheet: d54bec0b-9e86-459b-b0c0-d72b4fa61293
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
SABP | Test | SABP | Streptococcal Antibodies Profile | Streptococcal Antibodies Profile | Nephelometry |  |  |  | 1 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 1 mL | 0.5 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | ANTISTREP-O TITER <5 years: < or =70 IU/mL 5-17 years: < or =640 IU/mL > or =18 years: < or =530 IU/mL  ANTI-DNase B TITER <5 years: < or =250 U/mL 5-17 years < or =375 U/mL > or =18 years: < or =300 U/mL | Monday through Saturday; Continuously until 3 p.m. | Same day/1 day | 3 days |  | Profile |  |  |  |  | Rochester
SABP | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
SABP | Component | ASO | Antistrep-O Titer, Serum | Antistrep-O Titer, S | Nephelometry Only orderable as part of a profile. For further information see #86537 "Streptococcal Antibodies Profile, Serum." |  |  |  | 1 | mL | Only orderable as part of a profile. For further information see SABP/86537 Streptococcal Antibodies Profile. | 0.5 mL |  | Only orderable as part of a profile. For further information see SABP/86537 Streptococcal Antibodies Profile, Serum. |  |  |  | 1 | 86060 |  |  | Yes | No
ASO | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
ASO | Result | ASO | Antistrep-O Titer, S | Antistrep-O Titer, S | Numeric |  |  |  |  | IU/mL |  |  |  |  |  |  |  |  |  | 5370-2
SABP | Component | ADNAS | Anti-DNase B Titer, Serum | Anti-DNase B Titer, S | Nephelometry Only orderable as part of a profile. For further information see #86537 "Streptococcal Antibodies Profile, Serum." |  |  |  | 1 | mL | Only orderable as part of a profile. For further information see SABP/86537 Streptococcal Antibodies Profile. |  |  | Only orderable as part of a profile. For further information see SABP/86537 Streptococcal Antibodies Profile, Serum. |  |  |  | 1 | 86215 |  |  | Yes | No
ADNAS | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
ADNAS | Result | ADNAS | Anti-DNase B Titer, S | Anti-DNase B Titer, S | Numeric |  |  |  |  | U/mL |  |  |  |  |  |  |  |  |  | 5133-4