tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 136101d1326404960-nested-if-function-if-x-and-if-y-then-z-itl-booking
Sheet: Database

DESK | WORKSTATION 1 | ENVIRONMENT 1 | WORKSTATION 2 | ENVIRONMENT 2 | NAME | PAY NUMBER | PROJECT | TEL | DATE FROM | DATE TO | AUTHORISED | NOTES | FORM 3010(A) | STATUS | OLD BOOKING
1 |  |  |  |  |  |  |  |  | 2012-01-01 00:00:00 | 2012-01-13 00:00:00 |  |  |  | Booked | N
1 |  |  |  |  |  |  |  |  | 2012-01-14 00:00:00 | 2012-01-18 00:00:00 |  |  |  | Free Today (Future Booked) | N
2 |  |  |  |  |  |  |  |  | 2012-01-09 00:00:00 | 2012-01-20 00:00:00 |  |  |  | Booked | N
2 |  |  |  |  |  |  |  |  | 2012-01-22 00:00:00 | 2012-01-27 00:00:00 |  |  |  | Free Today (Future Booked) | N
3 |  |  |  |  |  |  |  |  | 2011-12-12 00:00:00 | 2011-12-27 00:00:00 |  |  |  | Free | Y
3 |  |  |  |  |  |  |  |  | 2012-01-12 00:00:00 | 2012-01-24 00:00:00 |  |  |  | Booked | N
4 |  |  |  |  |  |  |  |  | 2011-11-09 00:00:00 | 2011-12-20 00:00:00 |  |  |  | Free | Y
4 |  |  |  |  |  |  |  |  | 2012-01-12 00:00:00 | 2012-01-24 00:00:00 |  |  |  | Booked | N
4 |  |  |  |  |  |  |  |  | 2012-01-25 00:00:00 | 2012-01-31 00:00:00 |  |  |  | Free Today (Future Booked) | N
5 |  |  |  |  |  |  |  |  | 2011-12-26 00:00:00 | 2012-01-07 00:00:00 |  |  |  | Free | Y
5 |  |  |  |  |  |  |  |  | 2012-01-10 00:00:00 | 2012-01-11 00:00:00 |  |  |  | Free | Y
5 |  |  |  |  |  |  |  |  | 2012-01-12 00:00:00 | 2012-01-24 00:00:00 |  |  |  | Booked | N
6 |  |  |  |  |  |  |  |  | 2011-12-26 00:00:00 | 2012-01-07 00:00:00 |  |  |  | Free | Y
6 |  |  |  |  |  |  |  |  | 2012-01-12 00:00:00 | 2012-01-24 00:00:00 |  |  |  | Booked | N
27 |  |  |  |  |  |  |  |  | 2011-12-26 00:00:00 | 2012-01-07 00:00:00 |  |  |  | Free | Y
27 |  |  |  |  |  |  |  |  | 2012-01-21 00:00:00 | 2012-01-23 00:00:00 |  |  |  | Free Today (Future Booked) | N
33 |  |  |  |  |  |  |  |  | 2012-01-12 00:00:00 | 2012-01-24 00:00:00 |  |  |  | Booked | N
35 |  |  |  |  |  |  |  |  | 2012-01-10 00:00:00 | 2012-01-19 00:00:00 |  |  |  | Booked | N
36 |  |  |  |  |  |  |  |  | 2012-02-01 00:00:00 | 2012-02-17 00:00:00 |  |  |  | Free Today (Future Booked) | N
38 |  |  |  |  |  |  |  |  | 2012-01-15 00:00:00 | 2012-01-17 00:00:00 |  |  |  | Free Today (Future Booked) | N
39 |  |  |  |  |  |  |  |  | 2012-01-07 00:00:00 | 2012-01-14 00:00:00 |  |  |  | Booked | N
40 |  |  |  |  |  |  |  |  | 2012-01-10 00:00:00 | 2012-01-11 00:00:00 |  |  |  | Free | Y
Spreadsheet: 846583d1697730253-generate-a-number-of-names-from-a-list-without-repetition-book1
Sheet: Sheet1

Names
Q
W
E
R
T
Y
U
I
O
P
A
S
D
F
G
H
J
K
L
Spreadsheet: 3714dec6-decc-4900-a0ba-df22357af999
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
SNAIL | Test | SNAIL | Snail, IgE | Snail, 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
SNAIL | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
SNAIL | Result | SNAIL | Snail, IgE | Snail, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 11200-3
Spreadsheet: 865322d1712348509-l-j-chart-l-j-chart-
Sheet: ALB

 | Year: 2023
 | Day | Month | Control Number | Level 3 | Level 2 | Level 1 | Comment
 |  |  | 1 | 45.1 | 4.4 | 8.7 |  |  |  |  |  |  |  |  |  |  | Level 3 ALB Control
 |  |  | 2 | 48.9 | 5.1 | 8.2 |  |  |  |  |  |  |  |  |  |  | Lot #
 |  |  | 3 | 44 | 4.8 | 8.8 |  |  |  |  |  |  |  |  |  |  | +3 SD
 |  |  | 4 | 45.5 | 5.7 | 7.9 |  |  |  |  |  |  |  |  |  |  | +2 SD
 |  |  | 5 | 45.7 | 5 | 8.5 |  |  |  |  |  |  |  |  |  |  | +1 SD
 |  |  | 6 | 45.2 | 6 | 9 |  |  |  |  |  |  |  |  |  |  | Mean
 |  |  | 7 | 45.9 | 5.7 | 8.7 |  |  |  |  |  |  |  |  |  |  | -1 SD
 |  |  | 8 | 49.1 | 5.1 | 7.8 |  |  |  |  |  |  |  |  |  |  | -2 SD
 |  |  | 9 | 42.7 | 5.3 | 7.7 |  |  |  |  |  |  |  |  |  |  | -3 SD
 |  |  | 10 | 47.9 | 5.2 | 8.3
 |  |  | 11 | 44.7 | 5.4 | 7.7
 |  |  | 12 | 41.3 | 5.3 | 9.2
 |  |  | 13 | 46.7 | 5.1 | 7.5
 |  |  | 14 | 45.9 | 5.1 | 9.3 |  |  |  |  |  |  |  |  |  |  | Level 2 ALB Control
 |  |  | 15 | 46 | 5.1 | 7.5 |  |  |  |  |  |  |  |  |  |  | Lot #
 |  |  | 16 | 46.6 | 5.1 | 8.7 |  |  |  |  |  |  |  |  |  |  | +3 SD
 |  |  | 17 | 47.9 | 5.1 | 8.1 |  |  |  |  |  |  |  |  |  |  | +2 SD
 |  |  | 18 | 49.2 | 6 | 7.9 |  |  |  |  |  |  |  |  |  |  | +1 SD
 |  |  | 19 | 49.2 | 5.1 | 8.6 |  |  |  |  |  |  |  |  |  |  | Mean
 |  |  | 20 | 47 | 5.1 | 9.5 |  |  |  |  |  |  |  |  |  |  | -1 SD
 |  |  | 21 | 44.6 | 5.1 | 9.3 |  |  |  |  |  |  |  |  |  |  | -2 SD
 |  |  | 22 | 46.5 | 5.1 | 8.4 |  |  |  |  |  |  |  |  |  |  | -3SD
 |  |  | 23 | 45.4 | 4.8 | 7.3
 |  |  | 24 | 47.7 | 4.3 | 15.3
 |  |  | 25 | 47.4 | 5.1 | 7.9
 |  |  | 26 | 45 | 5.4 | 8.6
 |  |  | 27 | 46.4 | 5.5 | 8
 |  |  | 28 | 43.9 | 5.6 | 9.1
 |  |  | 29 | 44.1 | 5.8 | 8 |  |  |  |  |  |  |  |  |  |  | Level 1 ALB Control
 |  |  | 30 | 44.5 | 5.1 | 6.2 |  |  |  |  |  |  |  |  |  |  | Lot #
 |  |  | 31 | 41.1 | 4.9 | 5.9 |  |  |  |  |  |  |  |  |  |  | +3 SD
 |  |  | 32 | 43.1 | 4.7 | 6.6 |  |  |  |  |  |  |  |  |  |  | +2 SD
 |  |  | 33 | 43.4 | 4.6 | 5.8 |  |  |  |  |  |  |  |  |  |  | +1 SD
 |  |  | 34 | 46 | 5.4 | 7.4 |  |  |  |  |  |  |  |  |  |  | Mean
 |  |  | 35 | 40.4 | 5.3 | 7.8 |  |  |  |  |  |  |  |  |  |  | -1 SD
 |  |  | 36 | 47.8 | 5.1 | 6.1 |  |  |  |  |  |  |  |  |  |  | -2 SD
 |  |  | 37 |  |  |  |  |  |  |  |  |  |  |  |  |  | -3 SD
 |  |  | 38
 |  |  | 39
 |  |  | 40
 |  |  | 41
 |  |  | 42
 |  |  | 43
 |  |  | 44
 |  |  | 45
 |  |  | MEAN
 |  |  | 2 SD
 |  |  | 1 SD
 |  |  | %CV
Spreadsheet: 120854d1315585055-problem-using-conditional-formatting-to-flag-cells-by-color-and-count-them-example2
Sheet: Dr. MaMoo

PT. # | LAST NAME | FIRST NAME | REQUIRED | IN DATE | COM DATE | NOTES
15947 | Adkins | [NAME] | D/C Dict | 2011-04-27 00:00:00 |  | To Dr. [NAME] 1st | Total # of Yellow
50336 | Enew | Shelly | HP Dict | 2011-09-06 00:00:00 |  | Sent to Dr. [NAME] | Total # of Orange
17632 | Dear | [NAME] | D/C Dict | 2011-08-13 00:00:00 |  | Narula Sig | Total # of Red
75984 | Webb | [NAME] | PN | 2011-08-31 00:00:00 |  | DO  Sig
48591 | Hensley | [NAME] | ATT | 2011-07-29 00:00:00
15487 | Gardner | Michelle | PN | 2011-05-14 00:00:00
19854 | Grant | [NAME] | PN | 2011-09-07 00:00:00
13647 | McVey | [NAME] | HP Dict | 2011-09-07 00:00:00
 |  |  |  |  |  | *The dates are not colored accordingly :(
 |  |  |  |  |  | I noticed that when I type a date into E cells then its changing the color of the cell
 |  |  |  |  |  | directly above the one I'm typing the date into.
 |  |  |  |  |  | If I input a COM DATE into Cell F6 then it changes the color of cell E5
 |  |  |  |  |  | and continues as dates are placed in, it changes the cell in column E above it
Spreadsheet: ac4cda61-1630-4cc9-9b92-eff91ecd2ab2
Sheet: Sheet1

Date | Sport | Opponent | Time_Results
11/12/2010 | Men's Basketball | Oakland | W, 95-71
11/18/2010 | Men's Basketball | vs. [NAME] (San Juan, Puerto Rico) | W, 84-70
11/19/2010 | Men's Basketball | [NAME] (San Juan, Puerto Rico) | W, 74-71
11/21/2010 | Men's Basketball | Minnesota (San Juan, Puerto Rico) | L, 70-74
11/27/2010 | Men's Basketball | vs. VMI (Charleston, W.Va.) | W, 82-66
12/01/2010 | Men's Basketball | American | W, 71-50
12/04/2010 | Men's Basketball | at Miami | L, 76-79
12/07/2010 | Men's Basketball | [NAME] | W, 82-49
12/12/2010 | Men's Basketball | at Duquesne | W, 64-61
12/18/2010 | Men's Basketball | Cleveland State | W, 74-63
12/29/2010 | Men's Basketball | St. John's | L, 71-81
01/01/2011 | Men's Basketball | at Marquette | L, 74-79
01/04/2011 | Men's Basketball | at DePaul | W, 67-65
01/08/2011 | Men's Basketball | at Georgetown | W, 65-59
01/13/2011 | Men's Basketball | Providence | W, 93-63
01/16/2011 | Men's Basketball | Purdue | W, 68-64
01/19/2011 | Men's Basketball | vs. [NAME] (Charleston, W.Va.) | L, 71-75
01/23/2011 | Men's Basketball | USF | W, 56-46
01/26/2011 | Men's Basketball | at Louisville | L, 54-55
01/29/2011 | Men's Basketball | at Cincinnati | W, 66-55
02/02/2011 | Men's Basketball | [NAME] | W, 56-44
02/05/2011 | Men's Basketball | at Villanova | L, 66-50
02/07/2011 | Men's Basketball | Pitt | L, 66-71
02/12/2011 | Men's Basketball | [NAME] | W, 82-71
02/14/2011 | Men's Basketball | at Syracuse | L, 52-63
02/19/2011 | Men's Basketball | Notre Dame | W, 72-58
02/24/2011 | Men's Basketball | at Pitt | L, 58-71
02/27/2011 | Men's Basketball | at Rutgers | W, 65-54
03/02/2011 | Men's Basketball | Connecticut | W, 65-56
03/05/2011 | Men's Basketball | Louisville | W, 72-70
03/08/2011 | Men's Basketball | vs. Marquette (Big East) | L, 61-67
03/17/2011 | Men's Basketball | vs. [NAME] (NCAA) | W, 84-76
03/19/2011 | Men's Basketball | vs. Kentucky (NCAA) | L, 63-71
Spreadsheet: tom_donohoe__39946__CENTRALJ
Sheet: Central

 | Today's Date | 2001-05-02 00:00:00 |  |  |  |  |  | Central Desk's Positions
Region Code | Gas Daily Index Location | WACOG | Total Volume Traded (MMbtu /day) | Low Trade | High Trade | Low Mkt | High Mkt | Financial Gas Daily | Physical | Net (Financial + Physical) | Trade Check | Mkt. Check
 | TEXAS:  WEST WAHA
C | Northern, mids 1-6
 | EAST TEXAS-NORTH LA. AREA
C | MRT mainline
C | MRT west leg
C | NGPL (TexOk West)
C | NGPL (TexOk East) | 4.484 | 60000 | 4.445 | 4.53 | 4.445 | 4.53
 | EAST TEXAS/HOUSTON/KATY
C | [NAME] | 4.41 | 20000 | 4.35 | 4.45 | 4.35 | 4.45
 | TEXAS -- NORTH PANHANDLE
C | NGPL (Permian)
C | Northern (Mid 10)
 | SOUTH TEXAS -- CORPUS CHRISTI
C | NGPL (STX) | 4.403 | 45000 | 4.395 | 4.415 | 4.395 | 4.415
C | Trunkline South | 4.36 | 25000 | 4.33 | 4.4 | 4.33 | 4.4
 | LA -- ONSHORE SOUTH
C | ANR | 4.464 | 570000 | 4.42 | 4.57 | 4.42 | 4.57
C | NGPL (La. pool) | 4.498 | 257000 | 4.46 | 4.54 | 4.46 | 4.54
C | [NAME] | 4.354 | 147000 | 4.33 | 4.41 | 4.33 | 4.41
C | [NAME] | 4.335 | 25000 | 4.31 | 4.37 | 4.31 | 4.37
 | OKLAHOMA
C | ANR- OK | 4.422 | 159063 | 4.38 | 4.5 | 4.38 | 4.5
C | NGPL (Midcontinent) | 4.438 | 294918 | 4.38 | 4.495 | 4.38 | 4.495
C | NorAm (North/South) | 4.48 | 150000 | 4.4 | 4.52 | 4.4 | 4.52
C | NorAm (West)
C | Northern (Mid11)
C | ONG | 4.398 | 75000 | 4.375 | 4.42 | 4.375 | 4.42
C | PEPL | 4.434 | 182784 | 4.39 | 4.5 | 4.39 | 4.5
C | [NAME]
 | CANADIAN GAS
C | Iroquois
C | Niagra (NGF, [NAME])
C | Dawn, [NAME].
 | OTHERS\CITYGATES
 | NGPL
C | Iowa/Illinois
C | MWA/Amarillo receipt
C | Gulf Coast receipt
C | Northern, Mid 13
C | Northern (Ventura) | 4.488 | 150000 | 4.435 | 4.545 | 4.435 | 4.545
C | Northern (Demarc) | 4.489 | 250572 | 4.43 | 4.54 | 4.43 | 4.54
 | Chicago City Gate
C | LDCs, large e-users | 4.652 | 857000 | 4.6137 | 4.725 | 4.614 | 4.725
C | small end-users
 | Michigan Citygates
C | Cons. Power (large) | 4.725 | 190000 | 4.685 | 4.775 | 4.685 | 4.775
C | Cons. Power (small)
C | MichCon (large) | 4.745 | 370000 | 4.695 | 4.8 | 4.695 | 4.8
C | MichCon (small)
 | ML7
Spreadsheet: 15fd63b8-d5bc-4004-ab60-60337fe522bc
Sheet: Sheet1

Unnamed: 0 | State of New Hampshire - Primary Election | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
2012-09-11 00:00:00 | Governor - Democratic
Merrimack County | [NAME], d | [NAME], d | [NAME], d | Ovide Lamontagne, r | [NAME], r | [NAME], r | [NAME]
Allenstown | 83 | 131 | 30 | 6
Andover | 127 | 98 | 19
[NAME] | 112 | 100 | 17
Bow | 389 | 371 | 18 | 4 |  |  | 3
Bradford | 76 | 88 | 15 | 1
Canterbury | 210 | 154 | 17 | 1 | 1 |  | 1
Chichester | 85 | 108 | 12 | 1
Concord Ward 1 | 192 | 178 | 22 | 5 | 2
Concord Ward 2 | 136 | 143 | 11 |  |  |  | 2
Concord Ward 3 | 167 | 170 | 14 | 2 | 1 |  | 2
Concord Ward 4 | 199 | 223 | 13 | 2
Concord Ward 5 | 281 | 416 | 13 | 3
Concord Ward 6 | 145 | 147 | 20 | 2
Concord Ward 7 | 281 | 353 | 30 | 2 |  |  | 1
Concord Ward 8 | 187 | 132 | 27
Concord Ward 9 | 169 | 182 | 22 | 1
Concord Ward 10 | 265 | 265 | 24
Danbury | 43 | 28 | 58
Dunbarton | 91 | 115 | 11 | 3 |  |  | 1
[NAME] | 126 | 117 | 20 | 2 |  |  | 1
[NAME] | 75 | 68 | 22 | 1
[NAME] | 49 | 54 | 4 |  |  |  | 1
[NAME] | 91 | 69 | 14 | 1
Henniker | 205 | 194 | 26 | 4
Hill | 34 | 21 | 9 | 1
[NAME] | 165 | 420 | 48 | 2 | 1 |  | 4
[NAME] | 433 | 421 | 26 |  |  |  | 2
Loudon | 149 | 124 | 31 | 9 |  |  | 1
New London | 220 | 289 | 28 | 1 |  |  | 1
Newbury | 66 | 111 | 18 |  |  |  | 1
Northfield | 126 | 108 | 28 | 1 | 1 |  | 1
Pembroke | 214 | 231 | 35 | 11
Pittsfield | 77 | 75 | 20 | 1
Salisbury | 55 | 41 | 11 | 3
Sutton | 73 | 115 | 12 |  |  |  | 2
Warner | 175 | 151 | 14 | 2
[NAME] | 101 | 70 | 7 |  |  |  | 1
Wilmot | 72 | 83 | 15
TOTALS | 5744 | 6164 | 781 | 72 | 6 |  | 25
Spreadsheet: 870053d1716559629-sumifs-criteria-not-working-new-west-london-events-v3
Sheet: AVERAGE

 | WEEKKLY TOTAL
 |  | 2024-05-01 00:00:00
 | SITE | Total number of employers
 | [NAME]
 | Ealing
 | Fulham
 | Harlesden
 | [NAME]
 | [NAME]
 | Hounslow
 | Kingston
 | Queens Park
 | [NAME]
 | [NAME]
 | Uxbridge
 | Wandsworth
 | Wembley
 | OTHERS
 | District Office
 | [NAME]
 | TOTAL
 | MONTH: WEEK COMMENCING AVERAGE
Spreadsheet: 201738d1356099852-how-can-i-match-an-certain-criteria-to-a-product-example
Sheet: GAME (2)

 |  | (Original Payout)-(New Bet) | Different | (New Payout)-(Original Bet)
 |  |  | 0.03
 |  |  | 0.02
 |  |  | 0.01
 |  |  | 0
 |  |  | -0.01
 |  | 66.6599999999207 | -0.02 | 66.68000000015863
 |  |  | -0.03
 |  | Original Bet |  | New Bet | Bet Amount
 |  | 100 |  | 83.34 | 100
 |  | Original Payout |  | New Payout | Payout
 |  | 150 |  | 166.68 | 200
 |  | which function can I use to include all the criteria in color from worksheet "GAME" and import them to worksheet "GAME (2)"?
 |  | I had try SUMIFS and VLOOKUP, however none of them is working.
 |  | for example, in C13 I tried =(SUMIFS(A:A,B:B,D13) and this function did not turn out very good
Spreadsheet: 599297d1542959893-problem-with-defined-names-as-text-example
Sheet: FactuurVliegen

 | Factuur
 | Factuurnummer:
 | Factuurdatum:
 | Vervaldatum:
 | Kleur |  | Omschrijving |  |  |  |  | Aantal |  |  | Bedrag
 |  |  | [NAME]
 |  |  |  | 1000 |  | 500
Totaal te betalen
 |  | Factuurnummer | Factuurdatum | Vervaldatum | [NAME] klant |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | BTW-nummer | C2R14 | C4R14 | C9R14 | C2R16 | C4R16 | C9R16 | C2R17 | C4R17 | C9R17 | C2R18 | C4R18 | C9R18 | C2R19 | C4R19 | C9R19 | C2R20 | C4R20 | C9R20 | C2R21 | C4R21 | C9R21 | C2R22 | C4R22 | C9R22 | C2R23 | C4R23 | C9R23 | C2R24 | C4R24 | C9R24 | C2R25 | C4R25 | C9R25 | C2R26 | C4R26 | C9R26 | C2R27 | [NAME] | C9R27 | C2R28 | C4R28 | C9R28 | C2R29 | C4R29 | C9R29 | C2R30 | C4R30 | C9R30 | C2R31 | C4R31 | C9R31 | C2R32 | C4R32 | C9R32 | C2R33 | C4R33 | C9R33 | C2R34 | C4R34 | C9R34 | C2R35 | C4R35 | C9R35 | C2R36 | C4R36 | C9R36 | C2R37 | C4R37 | C9R37 | C2R38 | C4R38 | C9R38 | C1R39 | C8R39 | C1R40 | [NAME] | C1R41 | C8R41 | C1R42 | C8R42
Spreadsheet: 93839d1293623269-charts-data-from-different-sheets-example
Sheet: October

2010-10-06 00:00:00 | 3.86
2010-10-07 00:00:00 | 3.96
2010-10-08 00:00:00 | 4.14
2010-10-09 00:00:00 | 4.22
2010-10-10 00:00:00 | 4.3
2010-10-11 00:00:00 | 4.46
2010-10-12 00:00:00 | 4.55
2010-10-13 00:00:00 | 4.68
2010-10-14 00:00:00 | 4.82
2010-10-15 00:00:00 | 4.9
2010-10-16 00:00:00 | 5.03
2010-10-17 00:00:00 | 5.11
2010-10-18 00:00:00 | 5.2
2010-10-19 00:00:00 | 5.3
2010-10-20 00:00:00 | 5.4
2010-10-21 00:00:00 | 5.48
2010-10-22 00:00:00 | 5.56
2010-10-23 00:00:00 | 5.66
2010-10-24 00:00:00 | 5.79
2010-10-25 00:00:00 | 5.88
2010-10-26 00:00:00 | 5.95
2010-10-27 00:00:00 | 6.08
2010-10-28 00:00:00 | 6.21
2010-10-29 00:00:00 | 6.33
2010-10-30 00:00:00 | 6.49
2010-10-31 00:00:00 | 6.64
Average
Spreadsheet: 864796d1711938526-calculate-elapsed-time-in-days-hours-and-minutes-excluding-weekends-and-holidays-time-calculator-aligw
Sheet: Time

DATE | TIME | DATE | TIME | Output | Weekend Start | Holiday Start | Comment |  | Net Working days | Working hours |  |  |  |  |  |  | DEFAULTS | Values
2024-01-19 00:00:00 | 10:19:00 | 2024-02-02 00:00:00 | 13:14:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | Start Time | 08:00:00
2024-01-25 00:00:00 | 09:30:00 | 2024-02-05 00:00:00 | 09:50:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | End Time | 17:00:00
2024-01-24 00:00:00 | 11:00:00 | 2024-02-07 00:00:00 | 10:00:00
2024-01-29 00:00:00 | 15:15:00 | 2024-02-12 00:00:00 | 09:28:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 12:00:00
2024-01-29 00:00:00 | 09:00:00 | 2024-02-13 00:00:00 | 09:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | Lunch End | 13:00:00
2024-02-01 00:00:00 | 13:30:00 | 2024-02-16 00:00:00 | 14:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2024-02-12 00:00:00 | 13:30:00 | 2024-02-21 00:00:00 | 16:45:00
2024-02-11 00:00:00 | 10:00:00 | 2024-02-22 00:00:00 | 16:45:00
2024-02-10 00:00:00 | 09:30:00 | 2024-02-10 00:00:00 | 15:00:00
2024-02-11 00:00:00 | 10:30:00 | 2024-02-11 00:00:00 | 16:00:00
2024-01-15 00:00:00 | 10:00:00 | 2024-01-29 00:00:00 | 10:01:00
2024-01-15 00:00:00 | 10:00:00 | 2024-01-29 00:00:00 | 10:01:00
2024-01-18 00:00:00 | 02:45:00 | 2024-01-29 00:00:00 | 15:00:00
2024-01-19 00:00:00 | 10:19:00 | 2024-02-02 00:00:00 | 13:14:00
2024-01-31 00:00:00 | 23:00:00 | 2024-02-02 00:00:00 | 13:40:00
2024-01-26 00:00:00 | 10:00:00 | 2024-01-27 00:00:00 | 13:19:00
2024-01-27 00:00:00 | 07:00:00 | 2024-01-27 00:00:00 | 13:19:00
2024-01-28 00:00:00 | 17:40:00 | 2024-01-29 00:00:00 | 09:12:00
2024-01-27 00:00:00 | 13:00:00 | 2024-01-29 00:00:00 | 09:12:00
2024-01-27 00:00:00 | 18:00:00 | 2024-01-29 00:00:00 | 09:12:00
2024-01-28 00:00:00 | 10:36:00 | 2024-01-29 00:00:00 | 09:12:00
2024-01-23 00:00:00 | 15:00:00 | 2024-01-30 00:00:00 | 08:15:00
2024-02-01 00:00:00 | 11:30:00 | 2024-02-01 00:00:00 | 13:24:00
Spreadsheet: 820eaed8-0df6-4554-b612-b8759895aad5
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
DABAR | Test | DABAR | Drug of Abuse, Barbiturate Screen with GC-MS Confirmation, [NAME] | Drug of Abuse, Barbiturate, U | DABAR/505335: Enzyme-Multiplied Immunoassay Technique (EMIT) MSBR/500367: Gas Chromatography-Mass Spectrometry (GC-MS) | [NAME]: Urine |  |  | 10 | mL | Container/Tube: Plastic, 10-mL urine tube (Supply T068) [NAME]: 10 mL Collection Instructions: 1. Collect a random urine specimen. 2. No preservative. | 5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK  Lipemia	NA Icterus	NA Other	NA | Negative Positives are reported with a quantitative GC-MS result. EMIT cutoff concentration: 200 ng/mL | Screening performed Monday through Friday, Sunday Gas Chromatography-Mass Spectrometry (GC-MS) confirmation performed twice a week | 3 days | 6 days | 1 | 80101 |  |  |  |  | New England
DABAR | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 14 days
DABAR | Result | 11301 | Barbiturates | Barbiturates | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 9426-8
DABAR | [NAME] | MSBR | Drug of Abuse, [NAME], [NAME] | Drug of Abuse, Barbiturate Conf, U | Gas Chromatography-Mass Spectrometry (GC-MS) | [NAME]: Urine |  |  | 10 | mL | Container/Tube: Plastic, 10-mL urine tube (Supply T068) [NAME]: 10 mL Collection Instructions: 1. Collect a random urine specimen. 2. No preservative. | 5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK  Lipemia	NA Icterus	NA Other	NA | Positives are reported with a quantitative GC-MS result. [NAME] concentrations Amobarbital: <100 ng/mL Butalbital: <100 ng/mL Pentobarbital: <100 ng/mL Phenobarbital: <100 ng/mL Secobarbital: <100 ng/mL | Varies; 3 times per week | 3 days | 5 days | 1 | 82205 |  |  | No | Yes
MSBR | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 14 days
MSBR | Result | 2837 | GC/MS Confirmation - Barbiturate | GC/MS Confirmation - Barbiturate | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20411-5
MSBR | Result | 501226 | Amobarbital | Amobarbital | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 16239-6
MSBR | Result | 501227 | Butalbital | Butalbital | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 16237-0
MSBR | Result | 501228 | Pentobarbital | Pentobarbital | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 16240-4
MSBR | Result | 501229 | Phenobarbital | Phenobarbital | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 16241-2
MSBR | Result | 501230 | Secobarbital | Secobarbital | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 16238-8
MSBR | Result | 501225 | Comment | Comment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48767-8
Spreadsheet: 0341d122-bd20-45af-90df-e103fc292e0a
Sheet: Sheet1

Category | July | Aug. | Sept. | Oct. | Nov. | Dec. | Jan. | Feb. | March | April | May | June | YTD
Vols. Add
"checklist | 107 | 91 | 99 | 122 | 152 | 128 | 106 | 117 | 93 | 125 | 84 | 148 | 1372
"binding | 296 | 325 | 426 | 421 | 169 | 468 | 217 | 298 | 458 | 507 | 524 | 259 | 4368
"firm ord. | 253 | 339 | 324 | 265 | 163 | 239 | 231 | 168 | 522 | 385 | 229 | 190 | 3308
"approval | 264 | 220 | 237 | 273 | 234 | 254 | 260 | 231 | 262 | 750 | 683 | 323 | 3991
"s.o. | 13 | 13 | 14 | 32 | 8 | 25 | 22 | 12 | 19 | 33 | 13 | 15 | 219
"gifts | 259 | 342 | 181 | 26 | 30 | 317 | 228 | 48 | 76 | 44 | 108 | 206 | 1865
"total | 1192 | 1330 | 1281 | 1139 | 756 | 1431 | 1064 | 874 | 1430 | 1844 | 1641 | 1141 | 15123
III Activity
Bib.new | 19 | 37 | 86 | 22 | 13 | 46 | 96 | 10 | 7 | 5 | 39 | 7 | 387
"update | 2609 | 1998 | 1657 | 1952 | 2352 | 1970 | 2557 | 2242 | 1473 | 1151 | 1376 | 1436 | 22773
"delete | 712 | 910 | 498 | 922 | 330 | 1140 | 977 | 876 | 303 | 110 | 22 | 162 | 23160
Item new | 893 | 899 | 972 | 789 | 947 | 727 | 1054 | 1127 | 896 | 525 | 688 | 813 | 10330
"update | 2772 | 1513 | 1192 | 1904 | 2587 | 2231 | 2879 | 1528 | 814 | 939 | 1348 | 402 | 20109
"delete | 1349 | 1351 | 747 | 1396 | 498 | 1773 | 1685 | 1375 | 399 | 152 | 50 | 75 | 10850
Order new | 470 | 320 | 28 | 161 | 237 | 264 | 236 | 566 | 317 | 329 | 938 | 517 | 4383
"update | 877 | 574 | 525 | 230 | 130 | 150 | 155 | 89 | 238 | 234 | 99 | 577 | 3878
"delete | 762 | 461 | 516 | 324 | 0 | 0 | 0 | 33 | 32 | 0 | 2 | 277 | 2407
Checkin | 3082 | 2757 | 2817 | 3194 | 2858 | 2519 |  |  |  |  |  |  | 17227
Mfilm add | 67 | 45 | 42 | 51 | 35 | 53 | 37 | 58 | 67 | 99 | 38 | 19 | 611
Mfiche add | 1569 | 1379 | 1494 | 1314 | 1393 | 1272 | 1341 | 1264 | 1402 | 1463 | 1313 | 0 | 15204
Vol.withdr. | 353 | 44 | 175 | 352 | 2 | 1339 | 1003 | 1005 | 217 | 90 | 3 | 1 | 4584
Cat. LC | 550 | 529 | 759 | 447 | 376 | 304 | 478 | 455 | 699 | 942 | 873 | 621 | 7033
Cat. Edit | 542 | 463 | 448 | 456 | 430 | 363 | 557 | 655 | 523 | 539 | 481 | 503 | 5960
Cat. Orig. | 87 | 65 | 76 | 87 | 95 | 82 | 119 | 92 | 164 | 250 | 149 | 111 | 1377
Vol. Proc. | 1235 | 874 | 1425 | 1200 | 1018 | 373 | 1483 | 1663 | 1634 | 1963 | 2133 | 1264 | 16265