tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 75393d1275984275-dynamic-charts-ppsdata
Sheet: Sheet1

DATEA | TIMEA | LAC | BSC_NAME | PPS | [NAME]) | SUM(A.NTDMPCH_3)
2010-05-31 00:00:00 | 20:00:00 | 330 | BSC_0-QLK101_eBSC01 | 71.26361111111112 | 256549 | 0
2010-06-01 00:00:00 | 20:00:00 | 330 | BSC_0-QLK101_eBSC01 | 72.56333333333333 | 261228 | 0
2010-06-02 00:00:00 | 20:00:00 | 330 | BSC_0-QLK101_eBSC01 | 68.30083333333333 | 245883 | 0
2010-06-03 00:00:00 | 20:00:00 | 330 | BSC_0-QLK101_eBSC01 | 69.01027777777777 | 248437 | 0
2010-06-04 00:00:00 | 20:00:00 | 330 | BSC_0-QLK101_eBSC01 | 69.29222222222222 | 249452 | 0
2010-06-05 00:00:00 | 20:00:00 | 330 | BSC_0-QLK101_eBSC01 | 69.105 | 248778 | 0
2010-06-06 00:00:00 | 20:00:00 | 330 | BSC_0-QLK101_eBSC01 | 67.16416666666667 | 241791 | 0
2010-05-31 00:00:00 | 20:00:00 | 370 | BSC_0-QLK101_eBSC01 | 17.83166666666667 | 64194 | 0
2010-06-01 00:00:00 | 20:00:00 | 370 | BSC_0-QLK101_eBSC01 | 18.02 | 64872 | 0
2010-06-02 00:00:00 | 20:00:00 | 370 | BSC_0-QLK101_eBSC01 | 15.60388888888889 | 56174 | 0
2010-06-03 00:00:00 | 20:00:00 | 370 | BSC_0-QLK101_eBSC01 | 17.68083333333333 | 63651 | 0
2010-06-04 00:00:00 | 20:00:00 | 370 | BSC_0-QLK101_eBSC01 | 17.80027777777778 | 64081 | 0
2010-06-05 00:00:00 | 20:00:00 | 370 | BSC_0-QLK101_eBSC01 | 17.60972222222222 | 63395 | 0
2010-06-06 00:00:00 | 20:00:00 | 370 | BSC_0-QLK101_eBSC01 | 17.50194444444444 | 63007 | 0
Spreadsheet: 94140d1294014526-compare-partial-data-in-two-columns-then-copy-number-value-into-cell-when-match-found-sample-of-cust-match
Sheet: Visits

Customer Name | Birthday | Site | Visit Nbr | Cust Nbr
[NAME], [NAME]  A | 1946-06-21 00:00:00 | STA | 181770 | {=IFERROR(INDEX(Headers!$A$1:$A$19075,MATCH(LEFT(A2,SEARCH(",",A2,1)-2),Headers!LEFT(B2,SEARCH(",",B2,1)-2)&Headers!$C$1:$C$19075,0),1),"NOT")} | [NAME], [NAME]
[NAME], [NAME]  A | 1946-06-21 00:00:00 | STA | 182123 |  | [NAME], [NAME]
[NAME], [NAME]  A | 1946-06-21 00:00:00 | STA | 182767 |  | [NAME], [NAME]
ARTHUR, [NAME] | 1946-08-30 00:00:00 | CLW | 338000 |  | ARTHUR, [NAME]
ARTHUR, [NAME] | 1946-08-30 00:00:00 | CLW | 338254 |  | ARTHUR, [NAME]
ARTHUR, [NAME] | 1946-08-30 00:00:00 | CLW | 348435 |  | ARTHUR, [NAME]
ARTHUR, [NAME] | 1946-08-30 00:00:00 | CLW | 364712 |  | ARTHUR, [NAME]
ARTHUR, [NAME] | 1946-08-30 00:00:00 | CLW | 367870 |  | ARTHUR, [NAME]
ARTHUR, [NAME] | 1946-08-30 00:00:00 | CLW | 383657 |  | ARTHUR, [NAME]
ASHLOCK, [NAME] | 1952-09-30 00:00:00 | CLW | 326608 |  | ASHLOCK, [NAME]
ASHLOCK, [NAME] | 1952-09-30 00:00:00 | CLW | 330155 |  | ASHLOCK, [NAME]
ASHLOCK, [NAME] | 1952-09-30 00:00:00 | CLW | 330740 |  | ASHLOCK, [NAME]
ASHLOCK, [NAME] | 1952-09-30 00:00:00 | CLW | 334558 |  | ASHLOCK, [NAME]
ASHLOCK, [NAME] | 1952-09-30 00:00:00 | CLW | 336619 |  | ASHLOCK, [NAME]
ASHLOCK, [NAME] | 1952-09-30 00:00:00 | CLW | 336271 |  | ASHLOCK, [NAME]
ASHLOCK, [NAME] | 1952-09-30 00:00:00 | CLW | 349239 |  | ASHLOCK, [NAME]
ASHLOCK, [NAME] | 1952-09-30 00:00:00 | CLW | 359600 |  | ASHLOCK, [NAME]
ASHLOCK, [NAME] | 1952-09-30 00:00:00 | CLW | 360094 |  | ASHLOCK, [NAME]
ASHLOCK, [NAME] | 1952-09-30 00:00:00 | CLW | 360248 |  | ASHLOCK, [NAME]
ASHLOCK, [NAME] | 1952-09-30 00:00:00 | CLW | 374742 |  | ASHLOCK, [NAME]
ASHLOCK, [NAME] | 1952-09-30 00:00:00 | CLW | 385634 |  | ASHLOCK, [NAME]
ASHLOCK, DOROTHY JO | 1930-08-05 00:00:00 | COL | 110977 |  | ASHLOCK, DOROTHY JO
ASHLOCK, DOROTHY JO | 1930-08-05 00:00:00 | COL | 125408 |  | ASHLOCK, DOROTHY JO
ASHLOCK, DOROTHY JO | 1930-08-05 00:00:00 | COL | 127663 |  | ASHLOCK, DOROTHY JO
ASHLOCK, DOROTHY JO | 1930-08-05 00:00:00 | COL | 128901 |  | ASHLOCK, DOROTHY JO
ASHLOCK, DOROTHY JO | 1930-08-05 00:00:00 | COL | 128200 |  | ASHLOCK, DOROTHY JO
ASHLOCK, DOROTHY JO | 1930-08-05 00:00:00 | COL | 130971 |  | ASHLOCK, DOROTHY JO
ASHLOCK, DOROTHY JO | 1930-08-05 00:00:00 | COL | 134130 |  | ASHLOCK, DOROTHY JO
ASHLOCK, DOROTHY JO | 1930-08-05 00:00:00 | COL | 137133 |  | ASHLOCK, DOROTHY JO
ATKINSON, JACKIE SU | 1956-08-09 00:00:00 | HHA | 379732 |  | ATKINSON, JACKIE SU
ATKISON  JR, JERRY | 1956-02-28 00:00:00 | COL | 117438 |  | ATKISON JR, JERRY
ATKISON  JR, JERRY | 1956-02-28 00:00:00 | COL | 122830 |  | ATKISON JR, JERRY
ATKISON  JR, JERRY | 1956-02-28 00:00:00 | COL | 130391 |  | ATKISON JR, JERRY
ATKISON  JR, JERRY | 1956-02-28 00:00:00 | STA | 106236 |  | ATKISON JR, JERRY
Spreadsheet: 772221d1647090237-fuel-cost-matching-vehicle-to-driver-to-miles-driven-per-day-fuel-cost
Sheet: Vehicles

 | Fuel PPG | 4.25
 | Total Cost
 |  |  |  |  |  |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday
 | Vehicle | MPG |  | Driver | Miles / Week | Fuel Cost | [NAME] | Vehicle | [NAME] | Vehicle | [NAME] | Vehicle | [NAME] | Vehicle | [NAME] | Vehicle | [NAME] | Vehicle | [NAME] | Vehicle
 | CRV | 32 |  | [NAME] |  |  | 42 | [NAME] | 42 | [NAME] | 42 | [NAME] | 42 | F150
 | HRV | 34 |  | Adchara |  |  | 84 | CRV | 84 | CRV | 84 | CRV | 84 | CRV | 84 | CRV
 | F150 | 16 |  | Jessica |  |  | 70 | HRV | 70 | HRV | 70 | HRV | 70 | HRV
 | [NAME] | 25
Spreadsheet: 25709d1217247147-conditional-formatting-percentageinfected-heatmap
Sheet: Sheet1

 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | A
 | B
 | C
 | D
 | E
 | F
 | G
 | H
 |  |  |  |  |  |  | Heat Map Showing Percentage Of Cells Infected By One Or More Parasite
 |  |  |  |  | Low |  | Average |  | High
Spreadsheet: 145875d1331790808-transfer-data-from-one-sheet-to-another-when-specific-value-entered-in-first-sheet-example_2012_file
Sheet: Mar

Reporter | Date Rec. | Date Comp. | Witness | Description | Pages Rec | Pages Rtn | Job Type | Rate | Total | Tithe Amount | Tithed | Invoice # | Invoice Date | Date Paid | Monthly Tithe | Tithed MTD | Left to Tithe | Total | Amount Received | Total By Reporter | Amount Due | Amount Received
[NAME] | 2012-03-01 00:00:00 | 2012-03-06 00:00:00 |  |  | 109 | 114 | Regular | 0.85 |  |  |  | 007-15 | 2012-03-06 00:00:00 | X |  |  |  |  |  | Jeanne
Jeanne | 2012-03-01 00:00:00 | 2012-03-06 00:00:00 |  |  | 36 | 48 | Regular | 1.2 |  |  |  | 001-14 | 2012-03-06 00:00:00 | X |  |  |  |  |  | [NAME]
Jeanne | 2012-03-06 00:00:00 |  |  |  | 43 | 52 | Regular | 1.2 |  |  |  | 001-15 |  |  |  |  |  |  |  | Karisa
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 2709685e-3e3d-40a3-8360-17b67fa698d2
Sheet: Sheet1

RFP NO: 9-11  REPLACE SOC ANNEX ROOF                                                                                                                                                                                                                                                                                                                         OPENED:  5/23/11                                             AWARDED:  6/1/11                                                                                                                                                 SHADED AREA INDICATES AWARD | Allied Roofing Inc.   P.O. Box 15238        Tampa, Fl 33684       Ph: [PHONE]     [NAME].  com | [NAME]                General Contrctor Inc.          1614 S 50th St.       Tampa, Fl 33619        Ph: [PHONE]      [NAME]           [EMAIL]
[NAME] | 1 | 2
Removal of Existing roof / gutters & debris disposal | 18850 | NO BID
Installation of new roof / gutters | 53870
SUBTOTAL | 72720
Add Options
SRI 92 Energy Cap surfacing | 6500
Elastomeric waterproofing on roof side of perimeter stucco covered parapets | 4800
Twenty Year Johns Manville Labor & Materials, no dollar limit extended roof warranty | 1500
ACCEPTED TOTAL | 85520
Indemnity Payment | 50
Spreadsheet: 697606d1601439815-solved-help-analyzing-data-in-a-table-shared-expense-who-owes-whom-splitting-costs-tactics
Sheet: method 1

 |  |  | Sum of NET | Credit
 |  |  | Debit\Credit | Adam | [NAME] | [NAME] | Ellen | Emily | Emma | [NAME] | [NAME]
 |  |  | Adam | 0 | -1380 | 3260 | 2000 | -185 | 1470 | -1205 | 0
 |  |  | [NAME] | 1380 | 0 | 0 | 0 | -650 | 0 | 0 | 0
 |  |  | [NAME] | -3260 | 0 | 0 | -850 | 400 | 0 | 0 | -2350
 |  |  | Ellen | -2000 | 0 | 850 | 0 | -1000 | 3400 | 0 | -220
 |  |  | Emily | 185 | 650 | -400 | 1000 | 0 | 0 | 0 | 360
 |  |  | Emma | -1470 | 0 | 0 | -3400 | 0 | 0 | 0 | 0
 |  |  | [NAME] | 1205 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | [NAME] | 0 | 0 | 2350 | 220 | -360 | 0 | 0 | 0
 |  |  |  | + | -
 |  |  | Index | Debit | Credit | DR-Cr | CR-DR | NET
[NAME] | 2
[NAME]
Adam
[NAME]
Ellen
[NAME]
Emma
Emily
Spreadsheet: 525254d1498641503-match-and-index-test1
Sheet: Sheet 1

[NAME] |  |  | [NAME]'s Solution |  |  |  | Actual References | Actual Examples of Data
AR1 |  | 1 | 1 |  |  |  | AR1 | AR1- KJLKJLKJHKLJHKLJHJKL
AR2 |  | 2 | 2 |  |  |  | AR6 | AR6 - KJJKKJHKLHKLHKLHK
[NAME] |  | #N/A | 3 |  |  |  | AR7 | [NAME]
AR4 |  | 4 | 4 |  |  |  | AR42
AR5 |  | 5 | 5 |  |  |  | AR43
AR6 |  | 6 | 6 |  |  |  | AR44
AR7 |  | 7 | 7 |  |  |  | AR45
AR8 |  | 8 | 8 |  |  |  | AR46
AR9 |  | 9 | 9 |  |  |  | AR10
AR10-DBGA5 |  | #N/A | 10 |  |  |  | AR5
AR11 |  | 11 | 11 |  |  |  | AR27
AR12 |  | 12 | 12 |  |  |  | AR35
AR13 |  | 13 | 13 |  |  |  | AR36
AR14 |  | 14 | 14 |  |  |  | AR37
AR15 |  | 15 | 15 |  |  |  | AR38
AR16 |  | 16 | 16 |  |  |  | AR39
AR17 |  | 17 | 17 |  |  |  | AR40
AR18 |  | 18 | 18 |  |  |  | AR41
AR19 |  | 19 | 19 |  |  |  | [NAME]
AR20 |  | 20 | 20 |  |  |  | AR24
AR21 |  | 21 | 21 |  |  |  | AR51a | AR51b [NAME]
AR22 |  |  |  |  |  |  | AR51b
AR23 |  |  |  |  |  |  | AR52a
AR24 |  |  |  |  |  |  | AR11
AR25 |  |  |  |  |  |  | AR12
AR26 |  |  |  |  |  |  | AR13
AR27 |  |  |  |  |  |  | AR14
AR28 |  |  |  |  |  |  | AR15
AR29 |  |  |  |  |  |  | AR16
[NAME] |  |  |  |  |  |  | AR17
AR31 |  |  |  |  |  |  | AR18
AR32 |  |  |  |  |  |  | AR31
AR33 |  |  |  |  |  |  | AR32
AR34 |  |  |  |  |  |  | AR33
AR35 |  |  |  |  |  |  | AR49
AR36 |  |  |  |  |  |  | AR54
AR37 |  |  |  |  |  |  | AR9
AR38 |  |  |  |  |  |  | AR25
AR39 |  |  |  |  |  |  | AR19
AR40 |  |  |  |  |  |  | AR20A
AR41 |  |  |  |  |  |  | AR20B
AR42 |  |  |  |  |  |  | AR22
AR43 |  |  |  |  |  |  | AR23
AR44 |  |  |  |  |  |  | AR59
AR45 |  |  |  |  |  |  | AR57
AR46 |  |  |  |  |  |  | AR47
AR47 |  |  |  |  |  |  | AR47a
AR48 |  |  |  |  |  |  | AR47b
AR49 |  |  |  |  |  |  | AR48
 |  |  |  |  |  |  | AR50
 |  |  |  |  |  |  | AR50b
Spreadsheet: 105622d1302908093-ranking-closest-to-100-book2
Sheet: Sheet1

100 | Base
 |  |  |  | Positive | Negative | Positive | Negative
86.19 | 13.81 | 14 | N | 14 |  | 9
88.36 | 11.64 | 13 | N | 13 |  | 8
90.41 | 9.590000000000003 | 11 | N | 11 |  | 6
85.94 | 14.06 | 15 | N | 15 |  | 10
97.26 | 2.739999999999995 | 4 | N | 4 |  | 3
100.75 | 0.75 | 3 | Y |  | 3 |  | 11
89.91 | 10.09 | 12 | N | 12 |  | 7
97.06 | 2.939999999999998 | 5 | N | 5 |  | 4
99.45 | 0.5499999999999972 | 2 | N | 2 |  | 2
104.07 | 4.069999999999993 | 7 | Y |  | 7 |  | 13
106.59 | 6.590000000000003 | 10 | Y |  | 10 |  | 15
99.89 | 0.1099999999999994 | 1 | N | 1 |  | 1
95.45 | 4.549999999999997 | 8 | N | 8 |  | 5
105.2 | 5.200000000000003 | 9 | Y |  | 9 |  | 14
103.89 | 3.890000000000001 | 6 | Y |  | 6 |  | 12
Spreadsheet: 121172d1315901094-date-domain-and-averaging-selected-cells-average-returns-forum
Sheet: Sheet1

Date | Price of Porsche | Average return in 30 days
1990-02-15 00:00:00 | 50000
1990-02-23 00:00:00 | 45000
1990-02-27 00:00:00 | 46000
22-mrt-90 | 33000
1990-04-06 00:00:00 | 56000
1990-04-20 00:00:00 | 45000
1990-04-27 00:00:00 | 60000
1990-05-04 00:00:00 | 62000
1990-05-06 00:00:00 | 57000
1990-05-18 00:00:00 | 45000
1990-05-18 00:00:00 | 67000
1990-05-23 00:00:00 | 70000
1990-05-24 00:00:00 | 56000
1990-06-03 00:00:00 | 67000
1990-06-21 00:00:00 | 90000
1990-06-25 00:00:00 | 74000
1990-06-29 00:00:00 | 45000
1990-06-29 00:00:00 | 60000
1990-07-19 00:00:00 | 34000
1990-07-19 00:00:00 | 56000
1990-07-19 00:00:00 | 67000
1990-07-19 00:00:00 | 80000
1990-07-20 00:00:00 | 68000
Spreadsheet: 678815d1590072794-worksheet-formula-to-count-repeating-sequence-pattern-in-cells-of-column-list-counting-patterns-in-a-column-2
Sheet: Count Pattern

 | Pattern: |  | Data: |  | Result: | [NAME] Used:
 | A |  | B
 | C |  | D
 | F |  | H
 | B |  | G |  | =COUNTIFS(D3:D53,B3,OFFSET(D3:D53,1,0),B4,OFFSET(D3:D53,2,0),B5,OFFSET(D3:D53,3,0),B6,OFFSET(D3:D53,4,0),B7,OFFSET(D3:D53,5,0),B8,OFFSET(D3:D53,6,0),B9)
 | D |  | A
 | H |  | C
 | G |  | F
 |  |  | B |  | =SUMPRODUCT((D3:D53=B3)*(OFFSET(D3:D53,1,0)=B4)*(OFFSET(D3:D53,2,0)=B5)*(OFFSET(D3:D53,3,0)=B6)*(OFFSET(D3:D53,4,0)=B7)*(OFFSET(D3:D53,5,0)=B8)*(OFFSET(D3:D53,6,0)=B9))
 |  |  | A
 |  |  | C
 |  |  | F |  | =COUNT(1/(MMULT(TRANSPOSE(ROW(B3:B10)^0),IFERROR(--(INDEX($D$3:$D$99,N(IF(1,COLUMN(A1:ZZ1)+ROW(A1:INDEX(A:A,COUNT(B3:B10)))-1)))=B3:B10),0))=COUNT(B3:B10))) | =COUNT(1/(MMULT(TRANSPOSE(ROW(B3:B10)^0),IFERROR(--(INDEX($D$3:$D$99,N(IF(1,COLUMN(A1:ZZ1)+ROW(A1:INDEX(A:A,COUNT(B3:B10)))-1)))=B3:B10),0))=COUNT(B3:B10)))
 |  |  | B
 |  |  | D
 |  |  | H
 |  |  | G
 |  |  | A
 |  |  | C
 |  |  | F
 |  |  | A |  | =SUMPRODUCT((SUBTOTAL(107,OFFSET($D$3,LARGE((ROW($D$3:$D$26)-ROW($D$3))*($D$3:$D$26=$B$3),ROW(A$1:INDEX($A:$A,COUNTIF($D$3:$D$26,$B$3)))
 |  |  | B
 |  |  | A
 |  |  | C
 |  |  | B
 |  |  | D
 |  |  | H
 |  |  | G
 |  |  | A
 |  |  | C
 |  |  | F
 |  |  | B
 |  |  | D
 |  |  | H
 |  |  | G
 |  |  | A
 |  |  | C
 |  |  | F
 |  |  | B
 |  |  | D
 |  |  | H
 |  |  | G
 |  |  | A
 |  |  | C
 |  |  | C
 |  |  | F
 |  |  | B
 |  |  | A
 |  |  | C
 |  |  | F
 |  |  | B
 |  |  | D
 |  |  | H
 |  |  | G
 |  |  | A
 |  |  | B
 |  |  | D
 |  |  | H
 |  |  | G
Spreadsheet: 672866d1587047692-fvschedule-function-determine-of-periods-to-calculate-example
Sheet: S&P 500 Returns

 | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1
Step-Up | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019
Daily | 0 | 0.2485801273180182 | 0.1297462111021434 | 0.08426099678763381 | 0.1655295801526718 | 0.2960124527587487 | 0.1310404899478458 | 0.03493127398125216 | 0.1114416274450325 | 0.2015919029135754 | 0.09617707893073404 | 0.292466641402557
Monthly | 0 | 0.2345419319125379 | 0.1278271007084568 | 0.08426099678763381 | 0.1455709287531808 | 0.2960124527587487 | 0.1139063818736611 | 0.02355141094759327 | 0.09535015704961979 | 0.1941996489237683 | 0.08990466073959923 | 0.2887807407702895
Annual | 0 | 0.2345419319125379 | 0.1278271007084568 | 0 | 0.1340569338422393 | 0.2960124527587487 | 0.1139063818736611 | 0 | 0.09535015704961979 | 0.1941996489237683 | 0 | 0.2887807407702895
Spreadsheet: 3730a9c3-8ffc-4cc6-9a2d-8cdf66991113
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 |  |  |  |  |  |  | ENGINEERING & TECHNICAL (INCORPORATED)
 |  |  |  |  |  |  | BRANCH: SYDNEY
 |  |  |  |  |  |  | PAYROLL queries: Ph 1300 853 100
 |  |  |  |  |  |  | [NAME] approved timesheets to: [EMAIL]
 |  |  |  |  |  | or | FAX: 1800 652 808 before 12pm Tuesday
Incorporated Contractor Time Sheet
Week ending day & date |  |  |  |  | Client Name
Company Name
[NAME] |  |  |  |  | Client Address
Contractor Position
Client Cost Centre |  |  |  |  | Supervisor's Name
[NAME] |  |  |  |  | Supervisor's Title
Contractor's Signature |  |  |  |  | [NAME]'s Signature
By signing this, you are verifying the hours worked, and agree to send an accompanying tax invoice. |  |  |  |  | By signing this, you are verifying the hours worked, that you are satisfied with the work completed and that you accept the Chandler Macleod Terms of Business. If you have not been provided with the Chandler Macleod Terms of Business, please contact your Consultant.
Day | Date | Time Start use AM/PM or use 24hr clock | Time Finish use AM/PM or use 24hr clock | Less Lunch | Hours Worked |  |  |  |  |  |  | Allowances
 |  |  |  |  | Ordinary | Shift | T 1/2 | T 2 | T 2 1/2 | Public Holiday | Total Hours or Days | Meal | Travel | Other:
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
 |  |  | Total Hours or Days
Send original receipts and client approval to Chandler Macleod Payroll, 200 Greenhill Road, EASTWOOD SA 5063
August 2010
Spreadsheet: 122104d1316616592-planner-room-booking-example
Sheet: Sheet1

 |  | 2011-10-01 00:00:00
 | 00:00:00
 | 00:30:00
 | 01:00:00
 | 01:30:00
 | 02:00:00
 | 02:30:00
 | 03:00:00
 | 03:30:00
 | 04:00:00
 | 04:30:00
 | 05:00:00
 | 05:30:00
 | 06:00:00
 | 06:30:00
 | 07:00:00
 | 07:30:00
 | 08:00:00
 | 08:30:00
 | 09:00:00
 | 09:30:00
 | 10:00:00
 | 10:30:00
 | 11:00:00
 | 11:30:00
 | 12:00:00
 | 12:30:00
 | 13:00:00
 | 13:30:00
 | 14:00:00
 | 14:30:00
 | 15:00:00
 | 15:30:00
 | 16:00:00
 | 16:30:00
 | 17:00:00
 | 17:30:00
 | 18:00:00
 | 18:30:00
 | 19:00:00
 | 19:30:00
 | 20:00:00
 | 20:30:00
 | 21:00:00
 | 21:30:00
 | 22:00:00
 | 22:30:00
 | 23:00:00
 | 23:30:00
Spreadsheet: 311e50f7-8735-4dbb-ace4-bdb4e3adeb13
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
CROMU | Test | CROMU | Chromium for Occupational Monitoring, [NAME] | Chromium, Occupational Monitor, U | CROM: Dynamic Reaction Cell-Inductively Coupled Plasma-Mass Spectometry (DRC-ICP-MS) CDCR: Enzymatic Colorimetric Assay | [NAME]: Urine |  |  | 10 | mL | Collection Container/Tube: Clean, plastic urine collection container Submission Container/Tube: Plastic, 6-mL tube (Supply T465) or a clean, plastic aliquot container with no metal cap or glued insert [NAME]: 6 mL Collection Instructions: 1. Collect a random urine specimen. 2. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. Additional Information: High concentrations of gadolinium and iodine are known to interfere with most metals tests. If either gadolinium- or iodine-containing contrast media has been administered, a specimen should not be collected for 96 hours. | 2 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | Chromium/creatinine ratio: <10.0 mcg/[NAME] | Tuesday, Friday; Afternoon and Evening | 1 days | 4 days |  | Profile |  |  |  |  | Rochester
CROMU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
CROMU | Component | CROM | Chromium, Random, [NAME] | Chromium, Random, U | "Only orderable as part of profile. For further information see #89547 "Chromium for Occupational Monitoring, Urine". |  |  |  |  |  | "Only orderable as part of profile. For further information see #89547 "Chromium for Occupational Monitoring, Urine". | 4 mL |  | "Only orderable as part of profile. For further information see #89547 "Chromium for Occupational Monitoring, Urine". | Tuesday, Friday; Afternoon and Evening | 2 days | 7 days | 1 | 82495 |  |  | Yes | No
CROM | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
CROM | Result | 26570 | Chromium, Random, U | Chromium, Random, U | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | 5623-4 | Chromium:MCnc:Pt:[NAME]:Qn:
CROM | Result | 29512 | Chromium/Creatinine Ratio | Chromium/Creatinine Ratio | Numeric |  |  |  |  | mcg/g Cr |  |  |  |  |  |  |  |  |  | 13464-3 | Chromium/Creatinine:MRto:Pt:[NAME]:Qn:
CROMU | Component | CDCR | [NAME] | [NAME] | Only orderable as part of a profile. For further information see CTU / Creatinine, [NAME]. |  |  |  | 5 | mL | Only orderable as part of a profile. For further information see CTU / Creatinine, [NAME]. |  |  |  |  |  |  |  |  |  |  | Yes | No
CDCR | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 30 days
CDCR | Result | CDCR | [NAME] | [NAME] | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 35674-1 | Creatinine:MCnc:XXX:[NAME]:Qn:
Spreadsheet: 684976d1593639653-trying-to-fill-in-empty-blank-cells-excel-forum
Sheet: Sheet1

Gender | Ethnicity | Birthdate | Age | Year Joined MM | Age Group
Female | Non-Hispanic White or Euro-American | 1979-03-25 00:00:00 |  | 2017 | 40-49
Female | Non-Hispanic White or Euro-American | 1987-08-09 00:00:00 |  | 2017 | 30-39
Male | Non-Hispanic White or Euro-American | 1990-09-01 00:00:00 |  | 2017 | 20-29
Female | Non-Hispanic White or Euro-American | 1989-10-22 00:00:00 |  | 2017 | 30-39
Male | Non-Hispanic White or Euro-American | 1983-11-08 00:00:00 |  | 2018 | 30-39
Male | Other | 1995-12-25 00:00:00 |  | 2017 | 20-29
Female | Southeast Asian or Indian-American | 1993-11-23 00:00:00 |  |  | 20-29
 | Not Given |  |  |  | Not Given
Female | Not Given |  |  |  | Not Given
 | Not Given |  |  |  | Not Given
 | Not Given |  |  |  | Not Given
 | Not Given |  |  |  | Not Given
 | Not Given |  |  |  | Not Given
 | Not Given |  |  |  | Not Given
 | Not Given |  |  |  | Not Given
 | Not Given |  |  |  | Not Given
 | Not Given |  |  |  | Not Given
 | Not Given |  |  |  | Not Given
 | Not Given |  |  |  | Not Given
 | Not Given |  |  |  | Not Given
Male | Not Given |  |  |  | Not Given
Male | Not Given |  |  |  | Not Given
 | Not Given |  |  |  | Not Given
 | Not Given |  |  |  | Not Given
 | Not Given |  |  |  | Not Given
 | Not Given |  |  |  | Not Given
Male | Not Given | 1976-11-12 00:00:00 |  | 2008 | 40-49
Male | Not Given | 1988-08-25 00:00:00 |  | 2016 | 30-39
Male | Not Given | 1991-01-14 00:00:00 |  | 2016 | 20-29
Female | Not Given | 1964-05-15 00:00:00 |  | 2016 | 50-59
Spreadsheet: 675583d1588357504-unique-drop-down-lists-2020-05-01-oeldere-deekster-675557d1588353303-unique-drop-down-lists-help-file
Sheet: Sheet2

Account Number | Vendor | Help |  | nw
600881 | Vendor 1 |  |  | di
600881 | Vendor 2 |  |  |  | Select Account Number (Drop Down Below) | Vendor |  | Unique List of Vendors (Used for [NAME] down in F5) | Unique List Account Numbers
603675 | Vendor 3 |  |  |  | 614635 |  |  | Vendor 1 | 600881
603675 | Vendor 4 |  |  |  |  |  |  | Vendor 2 | 603675
603675 | Vendor 5 |  |  |  |  |  |  | Vendor 3 | 614635
614635 | Vendor 3 |  |  |  |  |  |  | Vendor 4 | 617679
614635 | Vendor 6 |  |  |  |  |  |  | Vendor 5 | 618626
614635 | Vendor 7 |  |  |  |  |  |  | Vendor 6 | 648459
614635 | Vendor 5 |  |  |  |  |  |  | Vendor 7 | 656705
614635 | Vendor 8 |  |  |  |  |  |  | Vendor 8 | 666080
614635 | Vendor 9 |  |  |  | NOTES: |  |  | Vendor 9 | 667079
617679 | Vendor 3 |  |  |  | G14 has the formula to list all vendors |  |  | Vendor 10 | 667261
617679 | Vendor 5 |  |  |  | F5 has a drop down of unique account numbers |  |  | Vendor 11 | 667446
617679 | Vendor 8 |  |  |  | G5 has a drop down with same formula as G14 |  |  | Vendor 12 | 674205
618626 | Vendor 1 |  |  |  |  |  |  | Vendor 13 | 674491
618626 | Vendor 2 |  |  |  |  |  |  | Vendor 14 | 678355
648459 | Vendor 10 |  |  |  |  |  |  | Vendor 15 | 678485
648459 | Vendor 11 |  |  |  |  |  |  | Vendor 16 | 678927
648459 | Vendor 5 |  |  |  |  |  |  | Vendor 17 | 679125
648459 | Vendor 8 |  |  |  |  |  |  | Vendor 18 | 679133
656705 | Vendor 5 |  |  |  |  |  |  | Vendor 19 | 679428
656705 | Vendor 8 |  |  |  |  |  |  | Vendor 20 | 679483
666080 | Vendor 2 |  |  |  |  |  |  |  | 680589
667079 | Vendor 1 |  |  |  |  |  |  |  | 680907
667079 | Vendor 2 |  |  |  |  |  |  |  | 680908
667261 | Vendor 1 |  |  |  |  |  |  |  | 680964
667261 | Vendor 2 |  |  |  |  |  |  |  | 682366
667446 | Vendor 12
667446 | Vendor 1
667446 | Vendor 2
674205 | Vendor 13
674205 | Vendor 3
674491 | Vendor 14
674491 | Vendor 3
674491 | Vendor 5
674491 | Vendor 2
678355 | Vendor 8
678485 | Vendor 15
678485 | Vendor 2
678927 | Vendor 16
679125 | Vendor 17
679133 | Vendor 5
679133 | Vendor 8
679133 | Vendor 18
679428 | Vendor 8
679483 | Vendor 19
679483 | Vendor 8
680907 | Vendor 5
680907 | Vendor 8
680908 | Vendor 10
680908 | Vendor 5
680908 | Vendor 8
680964 | Vendor 4
680964 | Vendor 20
680964 | Vendor 5
682366 | Vendor 14