tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 745663d1630086074-lookup-partial-string-of-one-cell-and-return-the-entire-value-sample-sheet
Sheet: Dataset2

Campaign / Campaign ID | Clicks | Cost | CPC | Users | Sessions | [NAME] | Pages / Session | Ecommerce Conversion Rate | Transactions | Revenue
***************_Search / [PHONE] | 36419 | 31854.93 | 0.8746788764106648 | 24980 | 42976 | 0.3158041697691735 | 5.350614296351452 | 0.05279690990320179 | 2269 | 593072.74
*********_Search / [PHONE] | 28477 | 24703.89 | 0.8675032482354181 | 21800 | 37865 | 0.2832166908754787 | 6.091403670936221 | 0.06296051762841674 | 2384 | 591354.2
**********nded / 61450963 | 24135 | 24095.97 | 0.9983828464885022 | 19766 | 29873 | 0.3651123087738091 | 4.279717470625648 | 0.02202657918521742 | 658 | 182823.5
************* / 364036963 | 15087 | 23681.95 | 1.569692450454033 | 13097 | 20181 | 0.4328824141519251 | 3.824488380159556 | 0.03087062088102671 | 623 | 194432.46
************* / 72127286 | 9299 | 22281.250931 | 2.396091077642757 | 7653 | 11237 | 0.3805286108391919 | 4.201744237785886 | 0.03337189641363354 | 375 | 79505.61
*************Search / [PHONE] | 5861 | 11421.11 | 1.948662344309845 | 4936 | 6119 | 0.5370158522634417 | 3.039548945906194 | 0.002614806340905377 | 16 | 3575.85
***********Search / [PHONE] | 4652 | 13856.69 | 2.978652192605331 | 3984 | 5442 | 0.3752296949650863 | 5.035832414553473 | 0.01745681734656376 | 95 | 26564.92
***************ded - Jan/Mar/May/Jul/Sept/Nov / 364037083 | 3950 | 3515.28 | 0.8899443037974684 | 3452 | 5509 | 0.4296605554547105 | 4.205300417498639 | 0.02795425667090216 | 154 | 48367.57
*****************ct / 364036723 | 3920 | 6708.8 | 1.711428571428571 | 3476 | 5418 | 0.4217423403469915 | 3.84108527131783 | 0.023624953857512 | 128 | 50069.88
************** / 364036843 | 3515 | 4659.42 | 1.325581792318634 | 3085 | 4583 | 0.4942177612917303 | 3.35457124154484 | 0.02378354789439232 | 109 | 35352.88
Spreadsheet: 75489d1276061425-nested-if-with-two-true-conditions-example
Sheet: Data

 | Site A |  |  | Site B |  |  | Site C |  |  | Site D
 | 2010 | 2009 | 2008 | 2010 | 2009 | 2008 | 2010 | 2009 | 2008 | 2010 | 2009 | 2008
 | 1000 | 2000 | 300 | 200 | 5000 | 1000 | 4000 | 1000 | 2000 | 3000 | 5000 | 6000
Spreadsheet: 469943d1468254167-grab-associated-items-from-another-table-powerpivot-book1
Sheet: Sheet1

Claim | Amount | Date |  | Claim |  |  |  | Date
1 | 40 | 2014-01-01 00:00:00 |  | 1 |  |  |  | 2014-01-01 00:00:00
1 | 40 | 2014-01-01 00:00:00 |  | 2 |  |  |  | 2014-01-02 00:00:00
1 | 22 | 2014-01-01 00:00:00 |  | 3 |  |  |  | 2014-01-03 00:00:00
2 | 30 | 2014-01-02 00:00:00
2 | 16 | 2014-01-02 00:00:00
2 | 30 | 2014-01-02 00:00:00
3 | 22 | 2014-01-03 00:00:00
3 | 22 | 2014-01-03 00:00:00
3 | 22 | 2014-01-03 00:00:00 |  |  |  |  |  | Row Labels | Count of Claim
 |  |  |  |  |  |  |  | 2014-01-01 00:00:00 | 3
 |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  | 2 | 1
 |  |  |  |  |  |  |  | 3 | 1
 |  |  |  |  |  |  |  | 2014-01-02 00:00:00 | 3
 |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  | 2 | 1
 |  |  |  |  |  |  |  | 3 | 1
 |  |  |  |  |  |  |  | 2014-01-03 00:00:00 | 3
 |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  | 2 | 1
 |  |  |  |  |  |  |  | 3 | 1
 |  |  |  |  |  |  |  | Grand Total | 3
Spreadsheet: 153342d1335878922-calculation-of-text-and-numbers-claims
Sheet: TOTALS

Policy | CLAIMS |  |  |  | TOTAL CLAIMS |  | DEDUCTIBLE/ | Claims Recorded At Nil
Year | Paid |  | Oustanding |  |  |  | EXCESS
 | No. | Amount | No. | Amount | No. | Amount | APPLICABLE
TOTALS
 | 1 | If the value is all "0" then its wants to show"Nil" value
 | 2 | If there is "Not Insured" then in total also wants to show "Not Insured" in Paid Amount column and rest all cells will be blank
 |  | =IF((SUM(MD!C5,BI!C8,Mny!C5,Theft!C5,EL!TABLE_29,PL!F5))=0,Nil,SUM(MD!C5,BI!C8,Mny!C5,Theft!C5,EL!TABLE_29,PL!
 |  | =IF((SUM(MD!C5,BI!C8,Mny!C5,Theft!C5,EL!TABLE_29,PL!F5))=0,"Nil",SUM(MD!C5,BI!C8,Mny!C5,Theft!C5,EL!TA BLE_29,PL!F5))
Spreadsheet: 1399462d-39fd-4964-955f-ce263fa36d21
Sheet: Sheet1

 | TERM 27 Figure 2: Specific CO2 emissions per tonne-km and per mode of transport in Europe, 1995-2010
 |  | Freight |  |  |  |  |  |  | Freight
 |  | CO2 emissions (g/t-km) |  |  |  |  |  |  | CO2 emissions (g/t-km)
 | Year | Inland | Maritime | Rail | Road |  |  |  | Inland | Maritime | Rail | Road
 | 1995 | 57.2212864841054 | 13.71017741028724 | 35.09595233329078 | 92.83033017663485 |  |  | 2000 | 69.9803931760156 | 13.86921891086715 | 26.49292858470882 | 86.85326929371945
 | 1996 | 57.40684099064707 | 13.82704805479938 | 33.01244067107906 | 91.96302638222953 |  |  | 2010 | 61.59841402827397 | 14.00014185380691 | 21.17180548045917 | 76.21746959615459
 | 1997 | 57.80422934938809 | 13.77073352152877 | 32.1279308599665 | 90.65483307031327
 | 1998 | 59.27802998316651 | 13.80498136502994 | 29.49612726019381 | 89.37617501091636
 | 1999 | 62.48020285976007 | 13.83383820062156 | 27.587086290788 | 87.98315416122804
 | 2000 | 69.9803931760156 | 13.86921891086715 | 26.49292858470882 | 86.85326929371945
 | 2001 | 69.25405367702945 | 13.8446873044491 | 25.20857407531208 | 85.25024457814517
 | 2002 | 68.48826331939802 | 13.86303653470662 | 24.23129366139838 | 84.37824268065599
 | 2003 | 67.76917591027208 | 13.88111986837092 | 22.95472103245233 | 83.63692780412423
 | 2004 | 66.88669434832129 | 13.89893558690182 | 23.47256205367544 | 82.70971118418859
 | 2005 | 66.15024279342222 | 13.91648219365123 | 22.9490434184236 | 81.94692732998898
 | 2006 | 65.12604234374425 | 13.93375841285742 | 21.92284047250958 | 81.03469957031172
 | 2007 | 64.15473177688092 | 13.95076318835867 | 21.74342569933756 | 79.64319252650499
 | 2008 | 63.24132193419038 | 13.96749568203712 | 21.55806278282091 | 78.37455558723929
 | 2009 | 62.38884636433144 | 13.98395527200457 | 21.36731780183085 | 77.19606386687818
 | 2010 | 61.59841402827397 | 14.00014185380691 | 21.17180548045917 | 76.21746959615459
Spreadsheet: 888544d1739065268-update-needed-to-formula-to-only-show-data-for-month-sample-sheet-holger5
Sheet: YTD Results

 | Note: Rep names must be entered in exactly as they are shown in the survey report. Enter the supervisor name in the green boxes.
 | Claim Rep | Number of Promoters | Number of Detractors | Total Survey Count | Overall Score
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 |  |  |  | Team Score
 | Raymi [NAME]
 | [NAME]
 | Ricardo Herrera
 | [NAME]
 | [NAME]
 | [NAME]
 |  |  |  | Team Score
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 |  |  |  | Team Score
 | [NAME]
 | [NAME]
 | Alexis Jaimes
 | [NAME]
 | Alexis Jaimes
 |  |  |  | Team Score
 | Sup 5
 |  |  |  | Team Score
 | Sup 6
 |  |  |  | DRG Score
 |  |  |  | Updated 11.15.24
Spreadsheet: 773085d1647611198-count-different-type-of-text-and-give-me-text-and-sum-of-numbers-how-to-count
Sheet: Grunnforsendur

 | Grunnur fyrir kostnaði í [NAME] |  |  | Hagstofa pr ár | Pr. mán mv. 9,5
 |  | 2018 | 1 | 1798410 |  |  | G_2018_1
 |  | 2018 | 2 | 1801050 |  |  | grunn
 | Grunnskólar
 |  |  | Mánaðarlaun | [NAME] uppbót | Laun | Laun og [NAME] |  |  | Dags. í dag
 |  | [NAME] |  |  |  |  |  |  |  | Breyta þarf [NAME] ef skoða á eldri skjöl
 |  |  |  |  |  |  |  |  |  | þar sem hún breytir aldri barna og þar af leiðandi útreikningum
 |  |  |  |  | Kostn pr tíma |  | [NAME] | notað í reit X ([NAME])
 |  |  |  |  |  |  |  |  |  | Dvalartími í leikskóla |  | 8 | dvalartími | notað í reit W
 | Stuðningur |  |  |  |  |  |  |  |  | [NAME] á mánuði |  | 21 | sérkennsla | notað í reit X
 |  |  |  |  |  | 4000 | studn | Notað í reit Z (Stuðningur)
 | Fristund á mánuði
 |  |  | 50547783
 |  |  | 319
 |  |  |  |  | 134318
 |  |  | Frístund |  | frístund |  |  | Notað í reit AC (samtals neðst)
[NAME]
[NAME]
 | Aldur  /  tímar | 4 | 5 | 6 | 7 | 8 | 9 | [NAME]
 | 1 | 227910 | 260046 | 292183 | 324319 | 356455 | 388592 | 2
 | 2 | 202201 | 227910 | 253619 | 279328 | 305037 | 330746 | 1.6
 | 3 | 182919 | 203807 | 224696 | 245585 | 266473 | 287362 | 1.3
 | 4 | 163637 | 179705 | 195773 | 211842 | 227910 | 243978 | 1
 | 5 | 150782 | 163637 | 176491 | 189346 | 202201 | 215055 | 0.8
 | 6 | 150782 | 163637 | 176491 | 189346 | 202201 | 215055 | 0.8
Frá sept 2021 ( 3%  hækkun frá 2020 þar sem ný er [NAME]) |  |  |  |  |  |  |  | Leikskóli | Leikskoli_sept21
 | Aldur  /  tímar | 4 | 5 | 6 | 7 | 8 | 9 | [NAME] | Notað í dálk W
 | 1 |  |  |  |  |  |  | 2
 | 2 |  |  |  |  |  |  | 1.6
 | 3 |  |  |  |  |  |  | 1.3
 | 4 |  |  |  |  |  |  | 1
 | 5 |  |  |  |  |  |  | 0.8
 | 6 |  |  |  |  |  |  | 0.8
Grunnskólar |  |  | Fæði | Samtals
Frá og með sept 2021
Grunnskólar |  |  | Fæði | Samtals | Grunnsk_sept21
1 | 100-200 | 213193 |  |  | Notað í dálk W
2 | 200-300 | 194840
3 | 300-400 | 183648
4 | 401 | 165432
5
Spreadsheet: 713936d1611014594-need-to-use-a-2nd-set-of-data-to-break-a-rank-tie-digital-wheel2
Sheet: Titans IH Marketing

In-House Marketing Desk
 |  |  |  |  |  | Owners: | 56 |  |  | Goal: |  |  |  |  |  |  |  | P1s: | 21 |  |  | Goal: |  |  |  | Guests: | 29 |  |  | Goal:
[NAME] | 8:00 | - | 4:30 |  |  | Gondiewski |  |  | o | Evans |  |  | o
Phone: | NA
Lunch: | 11 | - | 11:30
Breaks: | 10 | / | 2
[NAME] | 8:00 | - | 4:30 |  |  | [NAME] |  | b | p1 | okeefe |  |  | o | [NAME] |  |  | g
Phone: | NA
Lunch: | 12:30 | - | 1
Breaks: | 10:10 | / | 2:10
Savannah | 11:00 | - | 7:30 |  |  | berglund |  |  | o | wilson |  | b | o
Phone: | NA
Lunch: | 6:30 | - | 7
Breaks: | 4:30 | / | 8:30
Rhea | 11:00 | - | 7:30 |  |  | Wilkey |  |  | o | conn |  | b | p1 | [NAME] |  |  | g
Phone: | NA
Lunch: | 6 | - | 6:30
Breaks: | 4 | / | 8
Kimberly | 2:00 | - | 10:30 |  |  | Crochet` |  | b | o | [NAME] |  | b | g
Phone:
Lunch: |  | -
Breaks: |  | /
[NAME] | 2:00 | - | 10:30 |  |  | [NAME] |  | b | o | Schockley |  | b | o
Phone:
Lunch: |  | -
Breaks: |  | /
JJ | 2:00 | - | 10:30
Phone:
Lunch: |  | -
Breaks: |  | /
Lauren | 2:00 | - | 10:30
Phone:
Lunch: |  | -
Breaks: |  | /
Simone | 2:00 | - | 10:30
Phone:
Lunch: |  | -
Breaks: |  | /
[NAME] | 2:00 | - | 10:30
Phone:
Lunch: |  | -
Breaks: |  | /
[NAME] | 11:00 | - | 8:00
Phone:
Lunch: |  | -
Breaks: |  | /
[NAME] | 1:00 | - | 10:00
Phone:
Lunch: |  | -
Breaks: |  | /
Spreadsheet: 50386d1249805154-problem-with-concatenation-concat
Sheet: Sheet1

 |  |  |  |  |  |  |  | Store1 | [NAME] | Store3 | Store4
Items | Store1 | [NAME] | Store3 | Store4 |  | Condolidated Order | Comments
Corn |  | 30 |  | 20 |  | Corn = +30++20 | My problem here, for every blank row the delimeter + is dsplayed. In this case since B3 and [NAME] are both blank, right after the equal sign the + is shown and got double ++ before value 20.  Corn = +30++20.
Tomato | 20 |  | 20 |  |  | Tomato = 20++20+ | again double ++ and + at the end
Potato |  |  |  |  |  | Potato = +++ | multiple delimeter for item with no order
Spring Onion | 30 | 20 | 10 | 30 |  | Spring Onion = 30+20+10+30 | [NAME] is only good if no blank row.
 |  |  |  |  |  | Ideal result
 |  |  |  |  |  | Corn = 30+20 | no + after = sign and no double ++
 |  |  |  |  |  | Tomato = 20+20 | no double ++ and no + sign at the end
 |  |  |  |  |  |  | if there is no order for a particualr item do not display item code just display blank (which of course still contains the formula).
 |  |  |  |  |  | Spring Onion = 30+20+10+30
Spreadsheet: 152822d1335540171-conditional-formatting-with-percentages-example-1
Sheet: Sheet1

 |  |  |  |  |  |  |  | Actual OSD
 |  |  |  |  |  | % |  | Wk 1 | Wk2 | Wk3 | Wk4 | Wk5 | Wk 6
 |  |  |  |  |  | 68
 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  | 40 |  | 75 | 75
 |  |  |  |  |  | 76 |  | 75
 |  |  |  |  |  | 28
 |  |  |  |  |  | 59
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0 |  | 0
Spreadsheet: 688989d1596051935-using-min-max-and-countif-on-ranges-populated-by-formulas-tracer-example-minifs-with-data-and-formulas-change-from-text-to-number
Sheet: Lookups

CARTON | LOT | PACK DATE | PACK TIME
0159881 | 7201D | 2018-01-10 00:00:00
0159882 | 7201D | 2018-01-10 00:00:00
0159883 | 7201D | 2018-01-10 00:00:00
0159884 | 7201D | 2018-01-10 00:00:00
0159885 | 7201D | 2018-01-10 00:00:00
0159886 | 7201D | 2018-01-10 00:00:00
0159887 | 7201D | 2018-01-10 00:00:00
0159888 | 7201D | 2018-01-10 00:00:00
0159889 | 7201D | 2018-01-10 00:00:00
0159890 | 7201A | 2018-01-11 00:00:00
0159891 | 7201A | 2018-01-11 00:00:00
0159892 | 7201A | 2018-01-11 00:00:00
0159893 | 7201A | 2018-01-11 00:00:00
0159894 | 7201A | 2018-01-11 00:00:00
0159895 | 7201A | 2018-01-11 00:00:00
0159896 | 7201A | 2018-01-11 00:00:00
0159897 | 7201A | 2018-01-11 00:00:00
0159898 | 7201A | 2018-01-11 00:00:00
0159899 | 7201A | 2018-01-11 00:00:00
0159900 | 7201A | 2018-01-11 00:00:00
0159901 | 7201A | 2018-01-11 00:00:00
0159902 | 7201A | 2018-01-11 00:00:00
0159903 | 7201A | 2018-01-11 00:00:00
0159904 | 7190A | 2018-01-11 00:00:00
0159905 | 7190A | 2018-01-11 00:00:00
0159906 | 7190A | 2018-01-11 00:00:00
0159907 | 7190A | 2018-01-11 00:00:00
0159908 | 7190A | 2018-01-11 00:00:00
0159909 | 7190A | 2018-01-11 00:00:00
0159910 | 7190A | 2018-01-11 00:00:00
0159911 | 7190A | 2018-01-11 00:00:00
0159912 | 7190A | 2018-01-11 00:00:00
0159913 | 7190A | 2018-01-11 00:00:00
0159914 | 7190A | 2018-01-11 00:00:00
0159915 | 7190A | 2018-01-11 00:00:00
0159916 | 7190A | 2018-01-11 00:00:00
0159917 | 7190A | 2018-01-11 00:00:00
0159918 | 7190A | 2018-01-11 00:00:00
0159919 | 7190A | 2018-01-11 00:00:00
0159920 | 7190A | 2018-01-11 00:00:00
0159921 | 7190A | 2018-01-11 00:00:00
0159922 | 7190A | 2018-01-11 00:00:00
0159923 | 7190A | 2018-01-11 00:00:00
0159924 | 7190A | 2018-01-11 00:00:00
0159925 | 7190A | 2018-01-11 00:00:00
0159926 | 7190A | 2018-01-11 00:00:00
0159927 | 7190A | 2018-01-11 00:00:00
0159928 | 7190A | 2018-01-11 00:00:00
0159929 | 7190A | 2018-01-11 00:00:00
0159930 | 7190A | 2018-01-11 00:00:00
0159931 | 7190A | 2018-01-11 00:00:00
0159932 | 7190A | 2018-01-11 00:00:00
0159933 | 7200A | 2018-01-11 00:00:00
0159934 | 7200A | 2018-01-11 00:00:00
0159935 | 7200A | 2018-01-11 00:00:00
0159936 | 7200A | 2018-01-11 00:00:00
0159937 | 7200A | 2018-01-11 00:00:00
0159938 | 7200A | 2018-01-11 00:00:00
0159939 | 7200A | 2018-01-11 00:00:00
0159940 | 7200A | 2018-01-11 00:00:00
0159941 | 7200A | 2018-01-11 00:00:00
0159942 | 7200A | 2018-01-11 00:00:00
0159943 | 7200A | 2018-01-11 00:00:00
0159944 | 7200A | 2018-01-11 00:00:00
0159945 | 7200A | 2018-01-11 00:00:00
0159946 | 7200A | 2018-01-11 00:00:00
0159947 | 7200A | 2018-01-11 00:00:00
0159948 | 7200A | 2018-01-11 00:00:00
0159949 | 7200A | 2018-01-11 00:00:00
0159950 | 7200B | 2018-01-11 00:00:00
0159951 | 7200B | 2018-01-11 00:00:00
0159952 | 7200B | 2018-01-11 00:00:00
0159953 | 7200B | 2018-01-11 00:00:00
0159954 | 7200B | 2018-01-11 00:00:00
Spreadsheet: 285f857d-1c2e-4f3c-b43f-19d2d73d8e2e
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
 | Time Series Workbook
 | 5368.0 International Trade in Goods and Services, Australia
 | TABLE 15a. MERCHANDISE EXPORTS, State and Australia, FOB Value
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
New South Wales ; |  |  | Original | A1829245L | 1988-01-01 00:00:00 | 2012-10-01 00:00:00 | 298 | $ Millions | FLOW | Month | 1
Victoria ; |  |  | Original | A1829246R | 1988-01-01 00:00:00 | 2012-10-01 00:00:00 | 298 | $ Millions | FLOW | Month | 1
Queensland ; |  |  | Original | A1829247T | 1988-01-01 00:00:00 | 2012-10-01 00:00:00 | 298 | $ Millions | FLOW | Month | 1
South Australia ; |  |  | Original | A1829248V | 1988-01-01 00:00:00 | 2012-10-01 00:00:00 | 298 | $ Millions | FLOW | Month | 1
Western Australia ; |  |  | Original | A1829249W | 1988-01-01 00:00:00 | 2012-10-01 00:00:00 | 298 | $ Millions | FLOW | Month | 1
Tasmania ; |  |  | Original | A1829250F | 1988-01-01 00:00:00 | 2012-10-01 00:00:00 | 298 | $ Millions | FLOW | Month | 1
Northern Territory ; |  |  | Original | A1829251J | 1988-01-01 00:00:00 | 2012-10-01 00:00:00 | 298 | $ Millions | FLOW | Month | 1
Australian Capital Territory ; |  |  | Original | A1829252K | 1988-01-01 00:00:00 | 2012-10-01 00:00:00 | 298 | $ Millions | FLOW | Month | 1
State not available for publication ; |  |  | Original | A1829253L | 1988-01-01 00:00:00 | 2012-10-01 00:00:00 | 298 | $ Millions | FLOW | Month | 1
Re-exports ; |  |  | Original | A1829254R | 1988-01-01 00:00:00 | 2012-10-01 00:00:00 | 298 | $ Millions | FLOW | Month | 1
Total (State of origin) ; |  |  | Original | A1829255T | 1988-01-01 00:00:00 | 2012-10-01 00:00:00 | 298 | $ Millions | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 105494d1302817266-conditional-formatting-condformat
Sheet: CF

Name | Date
a | 2011-10-11 00:00:00
a | 2011-11-13 00:00:00
a | 2011-12-11 00:00:00
b | 2010-04-13 00:00:00
b | 2009-04-11 00:00:00
b | 2010-04-12 00:00:00
b | 2009-04-10 00:00:00
Spreadsheet: 328489d1403911033-matching-the-values-between-two-columns-match_values
Sheet: Sheet1

Column 1 | Column 2 | All Matching Vaules | Non-Matching Values
1112333 | 1111111 | This column's result should be all of the numbers that are in both columns | This column's result should be all of the numbers that are NOT in both columns
1121233 | 1111333
1121333 | 1112333
1122333 | 1113333
1123333 | 1122311
1133333 | 1123333
1232333 | 1133333
1233333 | 1232121
1333111 | 1232311
1333211 | 1233321
1333311 | 1233333
1333331 | 1333211
1333332 | 1333311
1333333 | 1333321
2111333 | 1333331
2112333 | 1333332
2113333 | 1333333
2122333 | 2111211
2123333 | 2111223
2212121 | 2111333
2212123 | 2112311
2212221 | 2112322
2212233 | 2112333
2212333 | 2113333
2213333 | 2121323
2222121 | 2122311
2222123 | 2122333
2222133 | 2123311
2222221 | 2123333
2222223 | 2212111
2222233 | 2212123
2222333 | 2212133
2223332 | 2212211
2223333 | 2212221
2232111 | 2212223
2232211 | 2212233
2232333 | 2212321
2233331 | 2212333
2233333 | 2213333
2323111 | 2222111
2323331 | 2222211
2323333 | 2222221
2332111 | 2222311
2332211 | 2222321
2333211 | 2223311
2333221 | 2223331
2333231 | 2223333
2333233 | 2232111
2333311 | 2232121
2333321 | 2232123
2333331 | 2233311
2333332 | 2233321
2333333 | 2233333
3111211 | 2322121
3111233 | 2322221
3111311 | 2323133
3111323 | 2323231
3111333 | 2323233
3113333 | 2323321
3212121 | 2323333
3212123 | 2332111
3212133 | 2332121
3212211 | 2332221
3212221 | 2333111
3212223 | 2333121
3212233 | 2333211
3212311 | 2333221
3212321 | 2333231
3212333 | 2333232
3213333 | 2333233
3222233 | 2333311
3223333 | 2333321
3312111 | 2333331
3312233 | 2333332
3313331 | 2333333
3313333 | 3111333
3322121 | 3112333
3322221 | 3113333
3322233 | 3211233
3323111 | 3212121
3323121 | 3212123
3323133 | 3212133
3323221 | 3212223
3323231 | 3212233
3323233 | 3212321
3323321 | 3212322
3323331 | 3212333
3323332 | 3213321
3323333 | 3213333
3332121 | 3222133
3332133 | 3222221
3332221 | 3222233
3333111 | 3223333
3333121 | 3312111
3333132 | 3312121
3333133 | 3312221
3333211 | 3312233
3333221 | 3313321
3333231 | 3313331
3333233 | 3313333
3333311 | 3322111
3333321 | 3322121
3333331 | 3322122
3333332 | 3322133
3333333 | 3322211
 | 3322233
 | 3323133
 | 3323211
 | 3323221
 | 3323231
 | 3323233
 | 3323311
 | 3323321
 | 3323331
 | 3323332
 | 3323333
 | 3332211
 | 3332221
 | 3332233
 | 3333111
 | 3333121
 | 3333211
 | 3333221
 | 3333231
 | 3333232
 | 3333233
 | 3333311
 | 3333321
 | 3333331
 | 3333332
 | 3333333
Spreadsheet: 41741e85-753d-4f27-958c-946bb73a9f09
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
HERR | Test | HERR | Herring, IgE | Herring, 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
HERR | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
HERR | Result | HERR | Herring, IgE | Herring, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6139-0 | Clupea harengus [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 376b03e6-c9a5-4014-9adf-13fe3b4d7896
Sheet: 1.5x down

Locustag | Our data (>1.5x) | [NAME] (>1.5x)
BSU00130 | 1.731379833447408 | 1.49927285266646
BSU01920 | 1.852990096376667 | 1.67547220391614
[NAME] | 14.47838192120133 | 1.95054712846954
BSU02700 | 6.77367801800245 | 3.02053966975433
BSU02780 | 32.77618831308175 | 1.8748711026117
BSU04000 | 1.849873920417509 | 1.48393638859348
BSU07380 | 2.23319639780385 | 1.52884159672216
BSU09890 | 4.999868887152217 | 1.63536754885661
BSU10770 | 3.99511822872298 | 2.6054558244965
BSU11020 | 1.79492344130204 | 1.52041923026242
BSU12180 | 35.40521408597068 | 2.0664714999139
BSU12190 | 4.225089763176434 | 1.90677158147635
[NAME] | 5.152248471358235 | 1.6831805379445
BSU14340 | 2.652806112445259 | 1.95897898015554
BSU14350 | 3.512074632537794 | 2.30306845487137
BSU14890 | 2.024308011652256 | 2.3095755000231
BSU16660 | 2.280686638082949 | 1.5828044128587
BSU16960 | 50.00674803622476 | 13.1769666622743
BSU17610 | 2.397395930591188 | 39.6982929734021
BSU18560 | 1.94182668628846 | 1.71947361181164
BSU18840 | 3.095858191778017 | 1.57492715961887
BSU20420 | 2.44624006942272 | 1.52201596087404
BSU21460 | 7.277823706424269 | 3.15885902012193
BSU21470 | 10.87236233724016 | 3.01428772381086
[NAME] | 17.51453164606136 | 1.81325854649195
[NAME] | 6.186749509988719 | 1.65795320150763
BSU21620 | 4.556357328008096 | 1.61917972355205
BSU23140 | 1.677355950156761 | 1.83945257891252
BSU23150 | 1.887472414715638 | 1.87399272890821
BSU24620 | 2.713071014284175 | 3.55252406835056
BSU25050 | 7.609066210943406 | 1.53146392636721
BSU26890 | 1.77668150471591 | 1.83089823867589
[NAME] | 2.491326200752639 | 1.94405023425805
[NAME] | 3.254267869813235 | 2.04503159573815
[NAME] | 3.554119070588614 | 1.9388988347218
BSU30750 | 4.273980619011294 | 1.4552016181842
BSU31080 | 4.906757306189609 | 2.30581218391158
BSU31890 | 2.963363086769216 | 1.78600132164098
BSU33260 | 1.867188524347453 | 1.49675204805572
BSU33270 | 1.833186077262337 | 1.5995052197187
BSU33280 | 2.843652643965906 | 1.53435419032129
BSU34010 | 2.27063097614039 | 1.50855349833556
BSU34020 | 5.236007043132149 | 1.53590170229105
BSU34430 | 2.241093619612784 | 1.67302415846885
BSU36780 | 1.948785737107662 | 1.77025615606578
BSU37460 | 6.39614970272962 | 2.0726677306361
BSU37470 | 4.325990411555096 | 1.8153213118722
[NAME] | 1.893135933680712 | 1.75023044700886
BSU38850 | 4.161186852672589 | 1.67749583421868
[NAME] | 2.991193679696061 | 1.67336944092727
BSU39610 | 7.616089953142668 | 1.80354577098576
BSU39940 | 2.447765079802967 | 2.08178645034592
BSU40590 | 2.716774462357919 | 2.00533418894259
[NAME] | 2.971315394177481 | 2.11429900416517
BSU40610 | 2.678712364373058 | 1.96163050727765
BSU40620 | 2.761239693204387 | 1.62241090260127