tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 849065d1699626643-unique-count-function-test-3-2-aligw
Sheet: Sheet1

 | Fund 1 | Fund 2 |  |  |  |  | Product Name | Name | Sector | weight
No. of Holdings |  | 3 |  |  |  |  | Fund 1 | Apple | A | 0.098
 |  |  |  |  |  |  | Fund 1 | Apple | A | 0.062
Concentration of top 3 |  | 0.203 |  |  |  |  | Fund 1 | Alphabet | B | 0.081
 |  | 0.203 |  |  |  |  | Fund 1 | Alphabet | B | 0.059
 |  |  |  |  |  |  | Fund 1 | Alphabet | B | 0.033
Positions |  |  |  |  |  |  | Fund 1 | TSMC | A | 0.093
1 |  |  |  |  |  |  | Fund 1 | TSMC | A | 0.035
2 | Apple | Meta |  |  |  |  | Fund 1 | AON | C | 0.045
3 | TSMC | Microsoft |  |  |  |  | Fund 1 | Tesla | D | 0.071
 |  |  |  |  |  |  | Fund 1 | Bond | Cash | 0.028
 |  |  |  |  |  |  | Fund 2 | Meta | B | 0.041
 |  |  |  |  |  |  | Fund 2 | Meta | B | 0.025
 |  |  |  |  |  |  | Fund 2 | Microsoft | A | 0.035
 |  |  |  |  |  |  | Fund 2 | Bond | Cash | 0.079
 |  |  |  |  |  |  | Fund 2 | Bond | Cash | 0.042
 |  |  |  |  |  |  | Fund 2 | Mastercard | C | 0.05
 |  |  |  |  |  |  | Fund 2 | Mastercard | C | 0.052
Spreadsheet: 0d4d26b2-de72-4430-9513-4d2fe4e1cd2c
Sheet: Sheet1

Table 9--U.S. vegetable oil and fats prices | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Marketing | Soybean | Cottonseed | Sunflowerseed | Canola | Peanut | Corn | Lard 6 | Edible
year | oil 2 | oil 3 | oil 4 | oil 4 | oil 5 | oil 6 |  | tallow 6
 | Cents/pound
2001/02 | 16.46 | 17.98 | 23.25 | 23.45 | 32.23 | 19.14 | 13.55 | 13.87
2002/03 | 22.04 | 37.75 | 33.13 | 29.75 | 46.7 | 28.17 | 18.13 | 17.8
2003/04 | 29.97 | 31.21 | 33.42 | 33.76 | 60.84 | 28.43 | 26.13 | 22.37
2004/05 | 23.01 | 28.01 | 43.71 | 30.78 | 53.63 | 27.86 | 21.8 | 18.48
2005/06 | 23.41 | 29.47 | 40.64 | 31 | 44.48 | 25.18 | 21.74 | 18.16
2006/07 | 31.02 | 35.7 | 58.03 | 40.57 | 52.99 | 31.8 | 28.43 | 27.32
2007/08 | 52.03 | 73.56 | 91.15 | 65.64 | 94.53 | 69.4 | 40.85 | 41.68
2008/09 | 32.16 | 37.1 | 50.24 | 39.54 | 78.49 | 32.75 | 26.72 | 25.47
2009/10 | 35.95 | 40.27 | 52.8 | 42.88 | 59.62 | 39.29 | 31.99 | 32.26
2010/11 | 53.2 | 54.5 | 86.12 | 58.68 | 77.24 | 60.76 | 51.52 | 51.34
2011/12 | 51.9 | 53.22 | 83.2 | 57.19 | 100.15 | 56.09 | 48.11 | 50.33
2012/131 | 48.0-50.0 | 50.25-52.25 | 69.0-71.0 | 58.0-60.0 | 87.5-89.5 | 51.25-53.25 | 52.0.0-54.0 | 42.75-44.75
2011/12
October | 51.73 | 51.56 | 92.5 | 56.81 | 97 | 54.24 | 61.1 | 52.09
November | 51.44 | 50.5 | 91 | 56.13 | 98.75 | 53.98 | 48.86 | 45.51
December | 50.17 | 51.1 | 91 | 55.4 | 96.1 | 53.36 | 48.71 | 50.78
January | 50.99 | 52.19 | 88.75 | 55.06 | 95.81 | 54 |  | 51.1
February | 52.36 | 54.56 | 86 | 56.94 | 95 | 56.3 | 52.55 | 53.17
March | 53.43 | 55.95 | 82 | 59.1 | 96.6 | 59.31 | 54.6 | 52.24
April | 54.96 | 56.88 | 79 | 60.94 | 102.38 | 60.75 | 52.59 | 49
May | 50.69 | 52 | 80 | 55.88 | 106.13 | 58.05 | 54.82 | 55.48
June | 48.65 | 50.05 | 80.2 | 54.1 | 111 | 52.9 | 54.83 | 49.88
July | 51.96 | 53.75 | 78 | 57.44 | 110 | 54.76 | 53 | 49.13
August | 52.65 | 54.65 | 75 | 58.75 | 110 | 57.26 |  | 48.36
September | 53.81 | 55.5 | 75 | 59.75 | 104.5 | 58.21 |  | 47.19
2012/13
October | 49.31 | 51.31 | 74 | 57.5 | 103 | 54.75 | 51.6 | 42.27
November | 46.27 | 49.05 | 70.3 | 58.2 | 99.9 | 51.93 | 57 | 37.15
December | 47.16 | 50.06 | 67.5 | 57.13 | 98.56 | 50.63 |  | 40.92
January | 48.85 | 50.94 | 65.25 | 57.19 | 96.75 | 52.06 | 52.45 | 43.5
February | 49.33 | 51.56 | 65 | 59.38 | 86 | 51.71 | 45.56 | 41.93
March1 | 48.62 | 50.2 | 64.6 | 58.95 | 79.05 | 47.76 |  | 45
1 Preliminary.  2 Decatur, IL.  3 PBSY Greenwood, MS.  4 Midwest. 5 Southeast mills.  6 Chicago.
NA = Not available.
Sources: USDA, Agricultural Marketing Service,  Monthly Feedstuff Prices and Milling and Baking News.
Last update: | 2013-04-12 11:58:37.800000
Spreadsheet: tracy_geaccone__40264__Rate Case Request
Sheet: Sheet1

2000
Rate Case |  |  |  |  | Northern Natural Gas |  |  |  | [NAME] |  |  |  | FGT Pre-Expansion |  |  |  | FGT Incremental/Expansion |  |  |  | Northern Border Pipeline
 |  |  |  |  | Current |  | Previous |  | Current |  | Previous |  | Current |  | Previous |  | Current |  | Previous |  | Current (3) |  | Previous
 | Date Effective
 | Total Rate Base |  |  | $ |  | $ |  | $ |  | $ |  | $ |  | $ |  | $ |  | $ |  | $ |  | $
 | Long Term Debt |  |  | $ |  |  |  |  |  |  |  |  |  |  |  | $ |  | $ |  | $ |  | $
 | Allowed Return on Long Term Debt
 | Equity |  |  | $ |  |  |  |  |  |  |  |  |  |  |  | $ |  | $ |  | $ |  | $
 | Allowed Return on Equity
 | Average Depreciation Rate
 | Throughput Volume - Transport (Tcf)
 | Status of Rate Case
1999
Rate Case |  |  |  |  | Northern Natural Gas |  |  |  | [NAME] |  |  |  | FGT Pre-Expansion |  |  |  | FGT Incremental/Expansion |  |  |  | Northern Border Pipeline
 |  |  |  |  | Current |  | Previous |  | Current |  | Previous |  | Current |  | Previous |  | Current |  | Previous |  | Current (3) |  | Previous
 | Date Effective |  |  |  | 11/1/93 |  | 5/1/89 |  | 11/1/96 |  | 1/1/93 |  | 11/1/97 |  | 1/1/92 |  | 3/1/97 |  | 3/1/95 |  | 3/1/96 |  | 12/1/92
 | Total Rate Base |  |  | $ | 714 | $ | 555 | $ | 398 | $ | 398 | $ | 275 | $ | 253 | $ | 978 | $ | 908 | $ | 696 | $ | 716
 | Long Term Debt |  |  | $ | 339 |  | n/a |  | n/a |  | n/a |  | n/a |  | n/a | $ | 626 | $ | 581 | $ | 390 | $ | 422
 | Allowed Return on Long Term Debt |  |  |  | 0.0894 |  | n/a |  | n/a |  | n/a |  | n/a |  | n/a |  | n/a |  | 0.0914 |  | 0.0807 |  | 0.0833
 | Equity |  |  | $ | 393 |  | n/a |  | n/a |  | n/a |  | n/a |  | n/a | $ | 352 | $ | 326 | $ | 475 | $ | 305
 | Allowed Return on Equity |  |  |  | 0.125 |  | n/a |  | 0.115 |  | 0.115 |  | 15.64% (1) |  | 0.115 |  | 13.66% (1) |  | 13.89% (1) |  | 0.12 |  | 0.1275
 | Average Depreciation Rate |  |  |  | 0.0118 |  | 0.0185 |  | 0.012 |  | 0.017 |  | 0.0213 |  | 0.025 |  | variable (2) |  | variable (2) |  | 2.5% (4) |  | 0.031
 | Throughput Volume - Transport (Tcf) |  |  |  | 1661 |  | 1525 |  | 334 |  | 334 |  | 272 |  | 329 |  | 168 |  | 146 |  | n/a |  | n/a
 | Status of Rate Case |  |  |  | New Rate Case Filed |  |  |  | No Rate Case Until |  |  |  | No Rate Case Until |  |  |  | No Rate Case Until |  |  |  | Filed May 1999;
 |  |  |  |  | May 1998; Discussions |  |  |  | November 2006 |  |  |  | October 2001 |  |  |  | October 2001 |  |  |  | Approval Pending
 |  |  |  |  | On-Going
(1) Pre-tax overall Return
(2) Straight line book depreciation of 4% is adjusted by levelisation factors yielding regulatory depreciation rates of negative 0.88% in 1995, negative 0.55% in 1996 and negative 0.86% in 1997.
(3) Operates under a cost of tariff.  Amounts are averages for the 12 month period ending December 31, 1998.
(4) Depreciation was reduced to 2.0% in December 1998 and, beginning in 2000, is scheduled to increase on an annual basis until it reaches 3.2% in 2002.
Spreadsheet: ab91e035-c2f6-423e-b478-b375f3a4add5
Sheet: 16

Uke: | 16 |  |  |  |  | Navn:
 |  | Mandag |  | Tirsdag |  | Onsdag |  | Torsdag |  | Fredag |  | Lørdag |  | Søndag |  | Sum
Kvalitet | Form | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | Trent | Diff. | Feedback
Aerob | Kontinuerlig
 | Intervall
Anaerob | Lokalt
 | Generell
Maks.styrke | Sub.maks.
 | Tungt
 | Eksplosivt
Uth.styrke | Sirkel
 | Tungt
Spenst
Hurtighet
Koordinasjon
Bevegelighet
[NAME]
 | Sum
AKKUMULERT
Kvalitet | Form | Plan |  | Trent
Aerob | Kontinuerlig
 | Intervall
Anaerob | Lokalt
 | Generell
Maks.styrke | Sub.maks.
 | Tungt
 | Eksplosivt
Uth.styrke | Sirkel
 | Tungt
Spenst
Hurtighet
Koordinasjon
Bevegelighet
[NAME]
 | Sum
Spreadsheet: 270830d1381698263-return-a-date-in-2nd-spreadsheet-using-an-if-statement-sample
Sheet: Sheet2

Column A | Column B | Column C | Column D
123456789 | 2013-07-10 00:00:00 | BOOK | 2013-07-31 00:00:00 | #N/A
777555444 | 2013-07-10 00:00:00 | RED | 2013-07-28 00:00:00 | #N/A
999222333 | 2013-07-10 00:00:00 | ORANGE | N | N
888444666 | 2013-07-10 00:00:00 | BLUE | #N/A | #N/A
Spreadsheet: 2cf4859f-a1b0-426c-88df-544fa9efdd87
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
T4TF | Test | T4TF | T4 (Thyroxine), Total and Free | T4 (Thyroxine), Total and Free | FRT4/8725: Chemiluminometric Immunoassay T4/8724: Immunoenzymatic Assay | Plain, Red-Top Tube: Red |  |  | 1 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 1 mL | 0.6 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | T4 (THYROXINE), TOTAL ONLY > or =12 months: 5.0-12.5 mcg/dL Reference values have not been established for patients that are <12 months of age.  [NAME] (THYROXINE), FREE 0.8-1.8 ng/dL Elevated values are seen in patients on thyroxine therapy. | Monday through Friday, Sunday; 6 a.m.-3 p.m. | 1 day | 2 days |  | Profile |  |  |  |  | Rochester
T4TF | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
T4TF | Component | T4 | T4 (Thyroxine), Total Only, Serum | T4 (Thyroxine), Total Only, S | Immunoenzymatic Assay | Plain, Red-Top Tube: Red Serum Gel Tube: SGT |  |  | 0.6 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.6 mL | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK  Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | > or =12 months: 5.0-12.5 mcg/dL Reference values have not been established for patients that are <12 months of age. | Monday through Friday 5 a.m. - 12 a.m., Saturday 6 a.m. - 6 p.m. | Same day/1 day | 3 days | 1 | 84436 |  |  | Yes | Yes
T4 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
T4 | Result | T4 | T4 (Thyroxine), Total Only, S | T4 (Thyroxine), Total Only, S | Numeric |  |  |  |  | mcg/dL |  |  |  |  |  |  |  |  |  | 3026-2
T4TF | Component | FRT4 | T4 (Thyroxine), Free, Serum | T4 (Thyroxine), Free, S | Chemiluminometric Immunoassay | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.3 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | 0.8-1.8 ng/dL Elevated values are seen in patients on thyroxine therapy. | Monday through Friday, Sunday; 6 a.m.-3 p.m. | Same day/1 day | 2 days | 1 | 84439 |  |  | Yes | Yes
FRT4 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
FRT4 | Result | FRT4 | T4 (Thyroxine), Free, S | T4 (Thyroxine), Free, S | Numeric |  |  |  |  | ng/dL |  |  |  |  |  |  |  |  |  | 3024-7
Spreadsheet: 55039d1255109092-extract-info-from-my-list-excel_help-1-
Sheet: Sheet2

Team_Number | (All)
Count of Caption |  | Show_Team
Members_Number | Members_Names |  | Agg | Ban | LR | SS | Grand Total
1001 | [NAME]
1001 Total
1002 | Rich
1002 Total
1003 | [NAME] |  |  |  | 1 |  | 1
1003 Total |  |  |  |  | 1 |  | 1
1004 | [NAME] |  |  |  | 1 |  | 1
1004 Total |  |  |  |  | 1 |  | 1
1005 | George
1005 Total
1006 | Shannon
1006 Total
1007 | [NAME]
1007 Total
1008 | Wayne
1008 Total
1012 | [NAME] |  | 1 |  |  |  | 1
1012 Total |  |  | 1 |  |  |  | 1
1013 | Curtis 2 |  | 1 |  |  |  | 1
1013 Total |  |  | 1 |  |  |  | 1
1014 | (blank)
1014 Total
1015 | (blank)
1015 Total
1016 | Sand |  |  | 1 |  |  | 1
1016 Total |  |  |  | 1 |  |  | 1
1017 | [NAME] |  |  | 1 |  |  | 1
1017 Total |  |  |  | 1 |  |  | 1
1018 | [NAME]
1018 Total
1019 | [NAME] |  |  |  |  | 1 | 1
1019 Total |  |  |  |  |  | 1 | 1
1020 | [NAME]
1020 Total
Grand Total |  |  | 2 | 2 | 2 | 1 | 7
Spreadsheet: 100f4aba-24e9-4840-8728-89f79c8c7989
Sheet: Sheet1

2014 Troop 34 Flower Sale Order Form | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
[NAME] | Orders Due: 4/9/2014
Customer | Phone
Address | [NAME]
 | 17 | 8.5
Annuals | Full Flat $17.00 | Half Flat $8.50 | Total
[NAME] |  |  | 0
[NAME] |  |  | 0
Marigolds Mixed |  |  | 0
Petunias Pink |  |  | 0
Petunias Mixed |  |  | 0
Ageratum |  |  | 0
Dianthus |  |  | 0
[NAME] |  |  | 0
Salvia Red |  |  | 0
[NAME] |  |  | 0
[NAME] |  |  | 0
[NAME] |  |  | 0
Coleus |  |  | 0
[NAME] |  |  | 0
[NAME] |  |  | 0
[NAME] |  |  | 0
Miscellaneous | Price | Quantity | Total
Geraniums - Red | 3.75 |  | 0
Geraniums - Pink | 3.75 |  | 0
Geraniums - Salmon | 3.75
Hanging Baskets | Price | Quantity | Total
10" Fuchsia | 17 |  | 0
10" Geranium Ivy | 17 |  | 0
10" Double Impatiens | 17 |  | 0
10" Supertinia | 17 |  | 0
10" Torenia | 17 |  | 0
10" Calibroca | 17 |  | 0
12" Combo | 24 |  | 0
14" Coconest Combo | 34 |  | 0
Tubs & Urns | Price | Quantity | Total
16" Antique Scrolled Deck Planter w/Geraniums | 35 |  | 0
10" Terra Combo Tub w/Flowering Annuals/spike | 20 |  | 0
6.5" Annual Combo (Terra Pot) | 8 |  | 0
4.5" Hens & Chicks | 5 |  | 0
Veggies & Herbs | Price | Quantity | Total
Bell Pepper | 3 |  | 0
[NAME] | 3 |  | 0
[NAME] | 3 |  | 0
Big Boy Tomato | 3 |  | 0
[NAME] | 3 |  | 0
Dill | 3 |  | 0
Cilantro | 3 |  | 0
Lavender | 3 |  | 0
Thyme | 3 |  | 0
Sage | 3 |  | 0
[NAME] | 3 |  | 0
Total Amount Due | 0
Amount Paid | 0
Balance Due | 0
Delivery Date: May 2nd, 2014
Special Delivery Instructions
Spreadsheet: craig_dean__4372__ATCRateBwithOutOfflineGen
Sheet: systems

 | List of Available subsystems
Not shown sub index | Subsystem Name | # Buses | #Part Bus | Adjustment Type | Total Gen | Net Intrchng | MaxImport | MaxExport | Change
1 | ERCOT_GENS | 362 | 210 | ExportSpec | 40801.5 | 40648.5 | 0 | 6295.3
2 | NORTH2001 | 85 | 57 | ExportSpec | 11296.2 | 11263.9 | 0 | 1408.6
3 | SOUTH2001 | 226 | 132 | ExportSpec | 25643.3 | 25547.1 | 0 | 4645.6
4 | WEST2001 | 51 | 21 | ExportSpec | 3862 | 3837.6 | 144.6 | 241
Spreadsheet: 851209d1701435643-sum-columns-by-condition-example
Sheet: Sheet1

 | 202310 | 202311 | 202312 | 202401 | 202402 | 202403 | 202404 | 202405 | 202406 | 202407 | 202408 | 202409 | 202410 | 202411 | 202412 | 202501 | 202502 | 202503 | 202504 | 202505 | 202506
202311 | 1 | 2 | 3 | 4 | 5 | 6 | 2 | 4 | 1 | 4 | 1 | 4 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 240807d1370432690-combining-contents-of-multiple-cells-into-1-cell-without-losing-data-excel-forum-data-collapsing-sample
Sheet: Sheet1

 | Raw Input Data look slike this:
 | Smithsons | Consultants | Ltd. | VP | Client | Satisfaction | Department
 | Collapsing function:  What I want to do is select the cells I want merged, and have them COLLAPSE into the first cell of the group,
 | Combining function: OR   allow me to pick a desination cell for the result COMBINE
Example:
Collapse function:
 | Collapse:  Select these 3 cells to merge into the first cell, B11 |  |  | Collapse:  Select these 4 cells and merge them into cell E11
 | Smithsons | Consultants | Ltd. | VP | Client | Satisfaction | Department
 | Smithsons Consultants Ltd. |  |  | VP Client Satisfaction Department
[NAME]:  would do the same as the above, but allow me to select a destination cell before the collapse
I would like to add this functionality to all my spreadsheets in the future
Spreadsheet: 79cc519d-477e-4d75-985c-6bf95817d379
Sheet: OCTOBER

SEATTLE UNIVERSITY
NON-EXEMPT EMPLOYEE TIME REPORT
NAME: |  |  |  |  | DEPT: |  |  | (Use 4 letter-code as shown on paystub under DEPT)
Datatel ID Number or SSN:
PE: |  | 2015-10-01 00:00:00 | TO | 2015-10-31 00:00:00 |  | MO. NO.: |  | 10
Holiday Pay |  |  |  | HP
Sick Pay |  |  |  | SP
Vacation Pay |  |  |  | VP
[NAME] |  |  |  | BR |  | (up to 5 days of paid leave)
Jury Duty Leave |  |  |  | JL
[NAME] |  |  |  | DP
 |  |  |  |  |  |  |  |  | Employee Signature |  |  |  | Date
Regular Pay |  |  |  | RP | 172.5
SUB-TOTAL |  |  |  |  | 165 |  |  |  | Supervisor Signature |  |  |  | Date
Overtime (1.0 rate) |  |  |  |  |  | (If total hours worked (Sunday-Saturday) is between 37.50 and 40)
Overtime (1.5 rate) |  |  |  |  |  | (If total hours worked (Sunday-Saturday) is above 40)
TOTAL
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
 |  |  |  |  |  |  |  |  | 7.5 |  | 7.5
 |  |  |  |  |  |  |  | Mass of the Holy Spirit | 1 |  | 2 |  | 3
 |  |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5
 | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10
 |  |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5
 | 11 |  | 12 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17
 |  |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5
 | 18 | Time sheets due | 19 |  | 20 |  | 21 |  | 22 |  | 23 |  | 24
 |  |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5
 | 25 |  | 26 |  | 27 |  | 28 |  | 29 | Pay day | 30 |  | 31
REMEMBER: Adjustment from Prior Month!! INCLUDE PRIOR MONTH ADJ HOURS IN THE ABOVE CALCULATION!
Spreadsheet: 70874d1271631213-excel-2007-conditional-formatting-fifa2010
Sheet: Sheet3

Team | P | F | A | W | D | L | [NAME] | Pts | rank with gd as tie break | uniwue rank of col j
France | 3 | 0 | 0 | 0 | 2 | 1 | 0 | 2 | 3 | 4
Mexico | 3 | 0 | 0 | 0 | 2 | 1 | 0 | 2 | 3 | 3
South Africa | 3 | 3 | 0 | 2 | 1 | 0 | 3 | 7 | 1 | 1
Uruguay | 3 | 1 | 0 | 1 | 1 | 1 | 1 | 4 | 2 | 2
Spreadsheet: 800102d1665490369-merge-two-columns-and-sort-high-to-low-example-4
Sheet: Sheet1

 | Column1 | Column2 |  |  | Value
 |  | 59 |  |  | 9
 |  | 49 |  |  | 29
 |  | 29 |  |  | 29
 |  | 9 |  |  | 49
 | 90 | 29 |  |  | 50
 | 85 | 99 |  |  | 55
 | 80 | 169 |  |  | 59
 | 75 | 239 |  |  | 60
 | 70 | 309 |  |  | 65
 | 65 | 379 |  |  | 70
 | 60 |  |  |  | 75
 | 55 |  |  |  | 80
 | 50 |  |  |  | 85
 |  |  |  |  | 90
 |  |  |  |  | 99
 |  |  |  |  | 169
 |  |  |  |  | 239
 |  |  |  |  | 309
 |  |  |  |  | 379
Spreadsheet: 826573d1682087820-map-a-table-kg-to-g-map-kg-to-g
Sheet: prices (2)

id | qty | expected_result | current_result
Al-100 | 50 | 1165 |  |  |  |  |  |  |  |  |  | Al-100 | 2023-04-17 00:00:00 | 30 | g | 1165 | USD
Al-100 | 100 | 1165 |  | 1165 |  |  |  |  |  |  |  | Al-100 | 2023-04-17 00:00:00 | 1000 | g | 922 | USD
[NAME] | 250 | 1200 |  | 1200 |  |  |  |  |  |  |  | [NAME] | 2023-04-17 00:00:00 | 30 | g | 1500 | USD
[NAME] | 500 | 1100 |  | 1100 |  |  |  |  |  |  |  | [NAME] | 2023-04-17 00:00:00 | 500 | g | 1100 | USD
[NAME] | 1000 | 865 |  | 865 |  |  |  |  |  |  |  | [NAME] | 2023-04-17 00:00:00 | 1000 | g | 865 | USD
Al-102 | 50 | 1000 |  | 1000 |  |  |  |  |  |  |  | Al-102 | 2023-04-17 00:00:00 | 30 | g | 1000 | USD
Al-102 | 100 | 1000 |  | 1000 |  |  |  |  |  |  |  | Al-102 | 2023-04-17 00:00:00 | 1000 | g | 830 | USD
Al-103 | 250 | 940 |  | 940 |  |  |  |  |  |  |  | Al-103 | 2023-04-17 00:00:00 | 30 | g | 940 | USD
Al-103 | 500 | 940 |  | 940 |  |  |  |  |  |  |  | [NAME] | 2023-04-17 00:00:00 | 100 | g | 1200 | USD
Al-104 | 1000 | 46 |  | 46 |  |  |  |  |  |  |  | Al-104 | 2023-04-17 00:00:00 | 1000 | g | 46 | USD
Al-105 | 50 | 33 |  | 33 |  |  |  |  |  |  |  | Al-105 | 2023-04-17 00:00:00 | 25000 | g | 33 | USD
Al-130 | 100 | 29 |  | 29 |  |  |  |  |  |  |  | Al-130 | 2023-04-17 00:00:00 | 25000 | g | 29 | USD
Al-111 | 250 | 71 |  | 71 |  |  |  |  |  |  |  | Al-111 | 2023-04-17 00:00:00 | 1000 | g | 71 | USD
Al-112 | 500 | 39 |  | 39 |  |  |  |  |  |  |  | Al-112 | 2023-04-17 00:00:00 | 1000 | g | 39 | USD
Al-113 | 1000 | 7 |  | 7 |  |  |  |  |  |  |  | AA7075-100 | 2023-04-17 00:00:00 | 500 | g | 130 | USD
Al-113 | 50 | 8 |  | 8 |  |  |  |  |  |  |  | Al-113 | 2023-04-17 00:00:00 | 1000 | g | 7 | USD
AA7075-100 | 100 | 120 |  | 130 |  |  |  |  |  |  |  | AA7075-100 | 2023-04-17 00:00:00 | 1000 | g | 120 | USD
AA7075-101 | 250 | 106 |  | 106 |  |  |  |  |  |  |  | AA7075-101 | 2023-04-17 00:00:00 | 1000 | g | 106 | USD
AA7075-102 | 500 | ALERT |  | ALERT |  |  |  |  |  |  |  | Al-113 | 2023-04-17 00:00:00 | 500 | g | 8 | USD
AA7075-103 | 1000 | ALERT |  | ALERT
AA7075-104 | 50 | ALERT |  | ALERT
Spreadsheet: 2fab24ca-a95b-4407-b896-7177f8a17c98
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
CLOV | Test | CLOV | Clove, IgE | Clove, 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
CLOV | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
CLOV | Result | CLOV | Clove, IgE | Clove, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 7234-8 | Syzygium [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 97fcf2dc-aa5a-43c4-a02d-246c2211f32c
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
MTBVP | Test | MTBVP | Mtb PZA Confirmation, [NAME] | Mtb PZA Confirmation, pnc A Sequence |  |  |  |  |  |  | This test is for Billing Purposes Only. This is not an orderable test. |  |  |  |  |  |  | 1 | 87153 |  |  |  |  | Rochester
MTBVP | [NAME] | VARIES | Varies |  |  |  | See instructions
Spreadsheet: 05f642da-29c0-424d-90b7-9cc67c82e928
Sheet: Sheet1

Department Name: | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
Supervisor's Name:
 | STUDENT NAME               (Last Name, First Name) | Has Student |  |  |  |  |  |  | NEEDS HOUSING |  | GL ACCOUNT
 |  | Worked on |  |  | RATE |  |  |  |  |  | (**Entire GL # Required**)
STUDENT |  | Campus Before |  |  | OF | STIPEND | WORK | STUDY |  |  | Work Study - 61040-40
ID |  | YES | NO | JOB TITLE | PAY | AMT | YES | NO | YES | NO | Non-Work Study - 61040-10 | HIRE DATE | END DATE
 | (please list alphabetically) |  |  |  | 7.25 |  |  |  |  |  | XX-XX-XXXX-61040-XX
 |  |  |  |  | 7.25
 |  |  |  |  | 7.25
 |  |  |  |  | 7.25
 |  |  |  |  | 7.25
 |  |  |  |  | 7.25
 |  |  |  |  | 7.25
 |  |  |  |  | 7.25
 |  |  |  |  | 7.25
 |  |  |  |  | 7.25
 |  |  |  |  | 7.25
 |  |  |  |  | 7.25
 |  |  |  |  | 7.25
 |  |  |  |  | 7.25
 |  |  |  |  | 7.25
 |  |  |  |  | 7.25
 |  |  |  |  | 7.25
 |  |  |  |  | 7.25
 |  |  |  |  | 7.25
 |  |  |  |  | 7.25
 | If rate of pay is other than $7.25 per hour, enter explanation below (provide ID number, student employee name, and indicate rate of pay).
 | Include special certifications or skill sets required to perform advanced duties or assignments.
 | Digital Signature of Authorizing Official
 |  |  |  |  |  | Submit completed form to Office of Human Resources @
 | Date |  |  |  |  | [EMAIL]