tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 124684d1318541935-sumif-dollars-from-certain-date-range-sumifsdaterange
Sheet: Sheet1

Date | Dollars |  | First Date | End Date
2011-09-18 00:00:00 | 57 |  | 2011-09-08 00:00:00 | 2011-09-14 00:00:00
2011-09-08 00:00:00 | 63
2011-09-09 00:00:00 | 36
2011-09-14 00:00:00 | 55
2011-09-19 00:00:00 | 91 |  | Row Labels | Sum of Dollars
2011-09-21 00:00:00 | 20 |  | 2011-09-08 00:00:00 | 237
2011-09-08 00:00:00 | 49 |  | 2011-09-09 00:00:00 | 132
2011-09-19 00:00:00 | 92 |  | 2011-09-10 00:00:00 | 68
2011-09-28 00:00:00 | 8 |  | 2011-09-11 00:00:00 | 54
2011-09-25 00:00:00 | 59 |  | 2011-09-12 00:00:00 | 153
2011-09-24 00:00:00 | 53 |  | 2011-09-13 00:00:00 | 144
2011-09-20 00:00:00 | 4 |  | 2011-09-14 00:00:00 | 56
2011-09-27 00:00:00 | 1 |  | Grand Total | 844
2011-09-21 00:00:00 | 51
2011-09-19 00:00:00 | 44
2011-09-16 00:00:00 | 76
2011-09-17 00:00:00 | 9
2011-09-04 00:00:00 | 32
2011-09-22 00:00:00 | 12
2011-09-03 00:00:00 | 75
2011-09-02 00:00:00 | 52
2011-09-24 00:00:00 | 40
2011-09-06 00:00:00 | 9
2011-09-10 00:00:00 | 68
2011-09-08 00:00:00 | 49
2011-09-01 00:00:00 | 46
2011-09-20 00:00:00 | 3
2011-09-08 00:00:00 | 76
2011-09-21 00:00:00 | 45
2011-09-12 00:00:00 | 57
2011-09-04 00:00:00 | 22
2011-09-26 00:00:00 | 80
2011-09-01 00:00:00 | 98
2011-09-15 00:00:00 | 32
2011-09-27 00:00:00 | 8
2011-09-13 00:00:00 | 89
2011-09-25 00:00:00 | 43
2011-09-25 00:00:00 | 14
2011-09-02 00:00:00 | 7
2011-09-16 00:00:00 | 81
2011-09-18 00:00:00 | 42
2011-09-23 00:00:00 | 65
2011-09-05 00:00:00 | 68
2011-09-27 00:00:00 | 13
2011-09-22 00:00:00 | 23
2011-09-15 00:00:00 | 95
2011-09-24 00:00:00 | 78
2011-09-01 00:00:00 | 2
2011-09-07 00:00:00 | 65
2011-09-30 00:00:00 | 37
2011-09-26 00:00:00 | 70
2011-09-26 00:00:00 | 76
2011-09-09 00:00:00 | 40
2011-09-25 00:00:00 | 69
2011-09-23 00:00:00 | 29
2011-09-02 00:00:00 | 23
2011-09-23 00:00:00 | 76
2011-09-16 00:00:00 | 86
2011-09-14 00:00:00 | 1
2011-09-07 00:00:00 | 18
2011-09-06 00:00:00 | 77
2011-09-11 00:00:00 | 54
2011-09-01 00:00:00 | 92
2011-09-28 00:00:00 | 61
2011-09-12 00:00:00 | 96
2011-09-02 00:00:00 | 44
2011-09-05 00:00:00 | 53
2011-09-28 00:00:00 | 10
2011-09-05 00:00:00 | 46
2011-09-25 00:00:00 | 87
2011-09-27 00:00:00 | 56
2011-09-16 00:00:00 | 34
2011-09-01 00:00:00 | 89
2011-09-16 00:00:00 | 28
2011-09-17 00:00:00 | 14
2011-09-19 00:00:00 | 68
2011-09-25 00:00:00 | 35
2011-09-25 00:00:00 | 74
2011-09-20 00:00:00 | 35
2011-09-04 00:00:00 | 92
2011-09-06 00:00:00 | 31
2011-09-23 00:00:00 | 9
2011-09-18 00:00:00 | 96
2011-09-09 00:00:00 | 56
2011-09-21 00:00:00 | 48
2011-09-15 00:00:00 | 80
2011-09-04 00:00:00 | 1
2011-09-17 00:00:00 | 75
2011-09-27 00:00:00 | 34
2011-09-01 00:00:00 | 74
2011-09-04 00:00:00 | 68
2011-09-13 00:00:00 | 55
2011-09-27 00:00:00 | 78
2011-09-18 00:00:00 | 76
2011-09-27 00:00:00 | 24
2011-09-24 00:00:00 | 40
2011-09-29 00:00:00 | 44
2011-09-20 00:00:00 | 56
2011-09-28 00:00:00 | 25
2011-09-07 00:00:00 | 48
Spreadsheet: 740077d1626176397-sheet-named-range-lookup-indirect-function-syntax-multiple-page-lookup
Sheet: input

 |  | 1 | Cells D14 and D15 are Company (D2) and [NAME] (D3) input codes
 |  | 2 | Cells D17 and D18/E18 are the formulas I currently use for the single database sheet - BUT this formula only works for the Customer List sheet
 |  | 3 | Cell D20 is a potential VLOOKUP formula, if I could find a means to search for the column number by the input of D3
 |  | 4 | CellsD24 is the full formula based on the green formulas
 |  | 5 | Cell D25 is the full formula minus the offset part
 |  | 6 | Cell D26 is a shorted version of the full formula using helper cells at D30 and E30
 |  | 7 | Row Section from the full formula
 |  | 8 | D30 and E30 when combined with a colon (  : )  create a reference to a sheet and line number based on the full sheet array of data: alter [NAME] and the row ref changes, which isued by the column part of index as the array
 |  | 9 | D38 Working Index match formula but without a column SECTION so just finds the company, not the person
 |  | 10 | [NAME] - summary of the companies and codes in the data worksheets for ease of checking
 |  | Company Code | [NAME]
 |  | Person Code | SNJOH
 |  |  |  |  | [NAME] to return the name from single sheet
 |  |  |  |  | array references formula single sheet - with correct line number based on array starting on line 5
 |  |  |  | Vlookup result but with column stated - only returns the first person listed ie column 5
 |  |  |  | Put in AOJOH - the second person from [NAME] and it still says [NAME] |  |  |  |  |  |  | Company code |  | Person codes
 |  |  |  |  |  |  |  |  |  |  | Cust
 |  |  |  | Full formula incl offset
 |  |  |  | excluding offset
 |  |  |  | full formula Using helper cells at D18 and E18 |  |  |  |  |  |  | Staff
 |  |  |  | row no for index
 |  |  |  |  |  |  |  |  |  |  | Consult
 |  |  |  |  | Column helper cells for D26 with correct sht and row number
 |  |  | Other formulas |  |  |  |  |  |  |  | Subs/Supps
 |  |  |  | Full aaray for chosen sheet
 |  |  |  | Returns Sheet Name where ref found
 |  |  |  | returning just the cell reference without the choose
 |  |  |  | countif a reference exists
 |  |  |  | match if reference exists
 |  |  |  | Index without a column just matching the company code
 |  |  | INDEX(People,MATCH(1,--(COUNTIF(INDIRECT("'"&People&"'!$B$1:$B$400"),$D$3)&#62;0),0))
 |  |  | Another formula found on net to return sheet name - that does not work
Spreadsheet: 840200d1692548202-need-excel-formula-to-divide-annual-budget-on-monthly-prorated-basis-sample-data-16-aligw
Sheet: Sheet1

 |  |  |  |  |  |  |  | 2023-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | FY2023
Name | Role | Team | Start Date | End Date | Salary | Funding Type
Adam | VP | R&D | 2020-06-15 00:00:00 |  | 275000 | Budget
Pam | VP | Product | 2021-01-01 00:00:00 | 2023-06-20 00:00:00 | 250000 | Budget
Vipul | VP | Growth | 2023-03-04 00:00:00 | 2023-08-21 00:00:00 | 350000 | Budget
Spreadsheet: 80886eae-6865-433e-8b5d-d7b7c9dafc6f
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
2124 | 5993 | [NAME] | [NAME] | SVK | 75 | 00:30:39 | 00:00:56 | 00:40:30 | 00:01:25 | 00:30:55 | 1 | 01:43:27
2124 | 10473 | [NAME] | [NAME] | AUT | 74 | 00:31:19 | 00:01:02 | 00:40:31 | 00:01:30 | 00:30:46 | 2 | 01:44:05
2124 | 7767 | [NAME] | Viana | ITA | 73 | 00:30:27 | 00:01:00 | 00:47:10 | [NAME] | 00:30:32 | 3 | 01:49:37
2124 | 10436 | [NAME] | Powlison | USA | 0 | 00:34:44 | 00:01:13 | 00:44:41 | 00:01:43 | [NAME] | 4 | 01:56:07
2124 | 9956 | [NAME] | Lobo | ESP | 72 | 00:32:08 | 00:01:08 | 00:50:00 | [NAME] | 00:35:27 | 5 | 01:59:22
Spreadsheet: 806090d1669104544-reference-a-date-if-multiple-criteria-are-met-sample
Sheet: Page 1

 | DATE | CREW #1 | CREW #2 | CREW #3 | CREW #4 | CREW #5 | CREW #6 | KEYWORDS
 | 1951-01-01 00:00:00 | NAME 1 | [NAME] 2 | NAME 3 | N/A | N/A | N/A | KEYWORD1
 | 1952-01-01 00:00:00 | [NAME] 2 | N/A | N/A | N/A | N/A | N/A | KEYWORD1
 | 1953-01-01 00:00:00 | NAME 3 | N/A | N/A | N/A | N/A | N/A | KEYWORD1
 | 1954-01-01 00:00:00 | NAME 1 | [NAME] 2 | NAME 3 | N/A | N/A | N/A | KEYWORD2
 | 1955-01-01 00:00:00 | [NAME] 2 | N/A | N/A | N/A | N/A | N/A | KEYWORD2
 | 1956-01-01 00:00:00 | NAME 3 | N/A | N/A | N/A | N/A | N/A | KEYWORD2
Spreadsheet: 26ed4b13-7881-4c2d-a34d-724c8446e544
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Atlantic-Elektra | 75596256728 | [NAME] | Christmas With Yolanda Adams | 2002-04-01 | Compact Disc | Seasonal | 4.99 | Y | Available
Atlantic-Elektra | 75596269025 | [NAME] | Believe | 2002-04-01 | Compact Disc | Gospel | 13.99 | Y | Available
Atlantic-Elektra | 75596262927 | [NAME] | Experience, The | 2002-04-01 | Compact Disc | Gospel | 13.99 | Y | Available
Atlantic-Elektra | 75596243926 | [NAME] | Mountain High, Valley Low | 2002-04-01 | Compact Disc | Gospel | 13.99 | Y | Available
Atlantic-Elektra | 16998145029 | [NAME] | Live In Concert | 2002-09-01 | Compact Disc | Gospel | 13.99 | Y | Available
Atlantic-Elektra | 75596276726 | [NAME] | 2Nd Chance | 2002-07-19 | Compact Disc | Gospel | 13.99 | Y | Available
Spreadsheet: 107012d1304163280-adding-cell-reference-numbers-together-random-rotation-v5
Sheet: Home

 | [NAME] of each group
 | Number of Workers | 19
 | Number of Weeks | 5
Week 1 |  |  | Week 2 |  |  | Week 3 |  |  | Week 4 |  |  | Extra Week
Teams case 1
42 | Matchey |  | 42 | Thompson |  | 42 | Majerus |  | 42 | Walker |  | 42 | Majerus
5 | Pince |  | 5 | Bartz |  | 5 | [NAME] |  | 5 | Pince |  | 5 | [NAME]
2 | Morris |  | 2 | [NAME] |  | 2 | Matchey |  | 2 | Majerus |  | 2 | bauer
10 | Larson |  | 10 | Larson |  | 10 | [NAME] |  | 10 | bauer |  | 10 | [NAME]
46 | [NAME] |  | 46 | Morris |  | 46 | [NAME] |  | 46 | [NAME] |  | 46 | Walker
3 | [NAME] |  | 3 | [NAME] |  | 3 | Wanek |  | 3 | Wanek |  | 3 | Morris
44 | Wanek |  | 44 | [NAME] |  | 44 | [NAME] |  | 44 | [NAME] |  | 44 | [NAME]
45 | [NAME] |  | 45 | bauer |  | 45 | [NAME] |  | 45 | Thompson |  | 45 | [NAME]
43 | Thompson |  | 43 | [NAME] |  | 43 | Pince |  | 43 | [NAME] |  | 43 | Larson
12 | Majerus |  | 12 | [NAME] |  | 12 | [NAME] |  | 12 | [NAME] |  | 12 | [NAME]
7 | [NAME] |  | 7 | Wanek |  | 7 | Thompson |  | 7 | Matchey |  | 7 | Pince
1 | bauer |  | 1 | Matchey |  | 1 | VanCampen |  | 1 | VanCampen |  | 1 | [NAME]
9 | [NAME] |  | 9 | Pince |  | 9 | Larson |  | 9 | [NAME] |  | 9 | VanCampen
41 | VanCampen |  | 41 | Walker |  | 41 | bauer |  | 41 | [NAME] |  | 41 | [NAME]
14 | [NAME] |  | 14 | [NAME] |  | 14 | Walker |  | 14 | [NAME] |  | 14 | Thompson
4 | Walker |  | 4 | Majerus |  | 4 | [NAME] |  | 4 | Larson |  | 4 | [NAME]
13 | [NAME] |  | 13 | [NAME] |  | 13 | Bartz |  | 13 | Morris |  | 13 | Wanek
47 | [NAME] |  | 47 | [NAME] |  | 47 | Morris |  | 47 | Bartz |  | 47 | Matchey
48 | Bartz |  | 48 | VanCampen |  | 48 | [NAME] |  | 48 | [NAME] |  | 48 | Bartz
49 | 0 |  | 49 | 0 |  | 49 | 0 |  | 49 | 0 |  | 49 | 0
50 | 0 |  | 50 | 0 |  | 50 | 0 |  | 50 | 0 |  | 50 | 0
Spreadsheet: 69107d1269609380-hiding-specific-fields-on-pivot-table-fields-pt-example
Sheet: Pivot

 |  |  |  |  |  | Valores
 | Segment | Region | Customer | Country | Model | Unit Sold | [NAME]. Net Sales | Soma de Net Sales | Soma de Variable Costs | Soma de Marginal Profit | Soma de Fixed Costs | Soma de SG&A | Soma de Operating Profit
 | A | America | C2 | Canada | Camry | 14 | 7.416428571428571 | 103.83 | -87.65 | 16.18 | -12.62 | -4.7 | -1.14
 |  |  | [NAME] | Canada | Corolla | 9 | 5.768888888888889 | 51.92 | -54.15 | -2.23 | -6.5 | -2.69 | -11.42
 |  | Europe | C1 | Italy | Civic | 25 | 2.0768 | 51.92 | -50.48 | 1.44 | -7.27 | -2.6 | -8.43
 | B | America | C1 | Italy | Civic | 51 | 2.035882352941176 | 103.83 | -79.85 | 23.98 | -14.28 | -4.6 | 5.1
 |  |  |  | US | Civic | 25 | 4.1532 | 103.83 | -87.65 | 16.18 | -12.62 | -4.7 | -1.14
 |  |  | C4 | US | Camry | 52 | 1.996730769230769 | 103.83 | -79.85 | 23.98 | -14.28 | -4.6 | 5.1
 |  | Europe | C2 | Italy | Corolla | 30 | 1.730666666666667 | 51.92 | -54.15 | -2.23 | -6.5 | -2.69 | -11.42
 | C | Europe | C4 | US | Accord | 18 | 2.884444444444445 | 51.92 | -50.49 | 1.43 | -7.27 | -2.6 | -8.44
 | Total geral |  |  |  |  | 224 | 2.78125 | 622.9999999999999 | -544.27 | 78.73 | -81.33999999999999 | -29.18 | -31.79
Spreadsheet: 732599d1621031278-price-menu-dependent-drop-downs-with-lookup-function-based-on-multiple-selections-price-menu-xlookup
Sheet: Pricing

MAKE | MODEL | Category | Service | Labor Hours |  | LABOR RATE | 100 |  |  | MAKES |  | MODEL |  | Category |  | SERVICE
FORD | FESTIVA | BRAKES | MASTER CYLINDER REPLACEMENT | 3.5 |  |  |  |  |  | FORD |  | FESTIVA |  | BRAKES |  | MASTER CYLINDER REPLACEMENT
FORD | FESTIVA | BRAKES | R&R FRONT BRAKE PADS | 3.5 |  |  |  |  |  | TOYOTA |  | MUSTANG |  | ELECTRICAL |  | OVERHALL
FORD | MUSTANG | BRAKES | R&R FRONT BRAKE PADS -RESURFACE ROTORS | 4.5 |  |  |  |  |  | HONDA |  | RAV4 |  | ENGINE |  | R&R FRONT BRAKE PADS
FORD | MUSTANG | BRAKES | R&R FRONT BRAKE PADS -REPLACE ROTORS | 4.5 |  |  |  |  |  |  |  | CAMRY |  |  |  | R&R FRONT BRAKE PADS -REPLACE ROTORS
TOYOTA | RAV4 | ELECTRICAL | REPLACE HEADLIGHTS | 4.5 |  |  |  |  |  |  |  | SUPRA |  |  |  | R&R FRONT BRAKE PADS -RESURFACE ROTORS
TOYOTA | RAV4 | BRAKES | R&R FRONT BRAKE PADS | 3.5 |  |  |  |  |  |  |  | FIT |  |  |  | REPLACE HEADLIGHTS
TOYOTA | CAMRY | BRAKES | R&R FRONT BRAKE PADS -RESURFACE ROTORS | 4.5 |  |  |  |  |  |  |  | ACCORD |  |  |  | WATER PUMP
TOYOTA | CAMRY | BRAKES | R&R FRONT BRAKE PADS -REPLACE ROTORS | 4.5 |  |  |  |  |  |  |  | ODYSSEY
TOYOTA | SUPRA | ENGINE | OVERHALL | 0.5
TOYOTA | SUPRA | ENGINE | WATER PUMP | 0.5
HONDA | FIT | BRAKES | MASTER CYLINDER REPLACEMENT | 3.5
HONDA | FIT | BRAKES | R&R FRONT BRAKE PADS | 4.5
HONDA | ACCORD | BRAKES | R&R FRONT BRAKE PADS -RESURFACE ROTORS | 5.5
HONDA | ODYSSEY | BRAKES | R&R FRONT BRAKE PADS -REPLACE ROTORS | 5.5
Spreadsheet: 740849d1626629930-multiple-averages-test
Sheet: Sheet1

Name | Handedness | Opp's Name | Pitcher's Hand | L IP | R IP | PA vs L | PA vs R
[NAME] | R | Wily Peralta | R | 11.2 | 14.1 | 92 | 174
[NAME] | B | [NAME] | L | 17 | 72.2 | 23 | 78
[NAME] | L | [NAME] | R | 33 | 43 | 78 | 196
Spreadsheet: 219c5eb1-f031-4b10-84d3-9874c15a55d2
Sheet: Action Exception

Instructions for requesting a Discipline Action Exception
Please send emails to:  [EMAIL]; [NAME]; [EMAIL]
In the subject line please provide your Administrative Unit number and what type of an exception you are requesting. (e.g. AU##### - Special Education Discipline Grade to Age Exception)
Instructions for filling out the Template next to this instruction sheet. Please enter your exceptions on the sheet called SPEDEOY-EXCEPTIONS.
Row 2 on the spreadsheet is populated as an example.
Column A - should have the error code populated, this is the error code you are requesting an exception for, such as “SD002”
Column B - should have the letter E populated
Column C  - should be left blank
Column D - report your 5-digit AU code
Column E - if student is attending a school provide the 4-digit school code. If student is in a program leave this field blank in the exception template
Column F - report the 3-digit grade level code you are reporting for this student
Column G - report the student's sasid
Column H - should be left blank
Column I - report the student's 2-digit disability code
Column J - written explanation of why the exception is needed. Please note that incomplete or vague explanations will be returned to you for more details before an exception will be processed. See below for specific information needed for each exception type (200 character limit).
SPECIAL EDUCATION DISCIPLINE DATA COLLECTION EXCEPTIONS
EXCEPTION TYPE | ERROR CODE (S) | INFORMATION NEEDED IN "COMMENTS AND EXPLANATION"
Program | DA005 | Please provide the name of the program the student is attending.  Zero-Fill School Code in the interchange file and leave Column H blank in the exception template
Spreadsheet: 829848d1684490726-match-2-inputs-and-return-value-from-another-cell-assessment-matrix-wip
Sheet: Matrix

170 | 150 | 365
Name | Department | Catergory | Start Date | Initial Assessment | 2022
 |  |  |  |  | CAR |  | HGV |  | CAR |  | HGV |  | CAR |  | HGV |  | CAR |  | HGV |  | CAR |  | HGV |  | CAR |  | HGV
[NAME] | Hygiene | CAR |  |  | 2022-01-01 00:00:00 | 10
Anesti Tuni | Logistics | HGV
Antaio [NAME] | Logistics | HGV
Arsalan Amjad | Logistics | HGV
[NAME] | Engineering | CAR
[NAME] | Warehouse | CAR
[NAME] | Logistics | HGV
[NAME] | Logistics | HGV
[NAME] | Engineering | CAR
[NAME] | Logistics | HGV
[NAME] | Logistics | HGV
[NAME] | Warehouse | CAR
[NAME] | Warehouse | CAR
[NAME] | Logistics | CAR |  |  |  |  |  |  | 2023-05-19 00:00:00
Constantine Marcu | Logistics | HGV
Cristian Archiudean | Warehouse | CAR
[NAME] | Logistics | HGV
[NAME] | Milling | CAR
[NAME] | Milling | CAR
[NAME] | Milling | CAR
[NAME] | Logistics | HGV
[NAME] | Milling | CAR
[NAME] | Logistics | HGV
[NAME] | Logistics | HGV
[NAME] | SLT | CAR
[NAME] | Logistics | HGV
Deimantas Kubilius | Logistics | HGV
[NAME] | SLT | CAR
[NAME] | Technical | CAR
[NAME] | Central | CAR
[NAME] | Warehouse | CAR
[NAME] | Central | CAR
[NAME] | Warehouse | CAR
[NAME] | Engineering | CAR
[NAME] | Logistics | HGV
[NAME] | Weighbridge | CAR
[NAME] | Warehouse | CAR
[NAME] | Central | CAR
[NAME] | Central | CAR
[NAME] | Logistics | HGV
[NAME] | Warehouse | CAR
[NAME] | Engineering | CAR
[NAME] | Technical | CAR
[NAME] | Engineering | CAR
[NAME] | Logistics | HGV
[NAME] | Engineering | CAR
[NAME] | Logistics | CAR |  |  |  |  |  |  | 2023-05-18 00:00:00 | 71
[NAME] | Central | CAR
[NAME] | SLT | CAR
[NAME] | Milling | CAR
[NAME] (AGY) | Warehouse | CAR
[NAME] | Logistics | HGV
[NAME] | Milling | CAR
[NAME] | Logistics | HGV
[NAME] | Logistics | HGV
[NAME] (AGY) | Warehouse | CAR
Les Hole | Logistics | HGV |  |  |  |  |  |  |  |  | 2023-05-18 00:00:00 | 213
[NAME] | Milling | CAR
[NAME] | Technical | CAR
[NAME] | Logistics | HGV
[NAME] | SLT | CAR
[NAME] | Logistics | HGV |  |  |  |  |  |  |  |  | 2023-05-17 00:00:00 | 219
[NAME] | Milling | CAR
[NAME] | Milling | CAR
[NAME] | Logistics | HGV
[NAME] | Milling | CAR
[NAME] | Milling | CAR
[NAME] | Central | CAR
[NAME] | Logistics | HGV |  |  |  |  |  |  |  |  | 2023-04-27 00:00:00
Mikail Ramadan | Warehouse | CAR
[NAME] (AGY) | Warehouse | CAR
[NAME] | Milling | CAR
[NAME] | Warehouse | CAR
Osei Bonsu | Hygiene | CAR
Parvez Hussain | Logistics | HGV
[NAME] | Logistics | HGV
[NAME] | Weighbridge | CAR
[NAME] (AGY) | Warehouse | CAR
Pilar Aparicio | SLT | CAR
[NAME] | Central | CAR
[NAME] | VMU | CAR
[NAME] | Logistics | HGV |  |  |  |  |  |  | 2023-05-19 00:00:00 | 240
[NAME] | SLT | HGV
[NAME] | Hygiene | CAR
[NAME] | Weighbridge | CAR
[NAME] | Logistics | HGV
[NAME] | Logistics | HGV
[NAME] | Warehouse | CAR
[NAME] | SLT | HGV
[NAME] | Hygiene | CAR
[NAME] | Warehouse | CAR
[NAME] | Milling | CAR
[NAME] | Logistics | HGV
[NAME] | Engineering | CAR
[NAME] | Warehouse | CAR
Spreadsheet: 748475d1632159197-cell-formatting-based-on-vlookup-and-multiple-cell-values-upload-sheet
Sheet: Input

[NAME]: | Perctange complete | Risk | Formatted Cell
GOV.AM1 | 0.9
GOV.AM1.1 | 0.95
GOV.CO2 | 0.9
GOV.PR1 | 0.9
GOV.AM1 | 0.9
Spreadsheet: a031ecdb-384a-4122-8272-3d4dfc941c02
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
HORS | Test | HORS | [NAME], IgE | [NAME], 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
HORS | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
HORS | Result | HORS | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6143-2
Spreadsheet: 761183d1640706295-combine-columns-datas-for-identical-values-in-first-column-test
Sheet: test

point | type | other | value
15 | A
15 | B | x
20 | A |  |  |  |  |  | point | type and values combined
20 | C | y |  |  |  |  | 15 | AB |  |  | AB |  | AB
 |  |  |  |  |  |  | 20 | AC |  | 20 | AC | 20 | AC
30 | H |  |  |  | ---> | ---> | 30 | HD(5)E |  | 30 | HD(5)E | 30 | HD(5)E
30 | D | z | 5 |  | what i need to obtain |  | 60 | B |  | 60 | B | 60 | B
30 | E |  |  |  |  |  | 66 | C(4) |  | 66 | C(4) | 66 | C(4)
 |  |  |  |  |  |  | 72 | D |  | 72 | D | 72 | D
60 | B | x |  |  |  |  | 80 | A(-8) |  | 80 | A(-8) | 80 | A(-8)
66 | C | y | 4
72 | D | y
80 | A | x | -8
Spreadsheet: 22832d1211988676-updating-charts-in-excel-97-2008-bkgs
Sheet: Data

Firm booking' |  |  |  |  |  |  | Start | End
Date | FP booking legs | V booking legs | FP fees | VH fees | Total revenue |  | 5 | 11
2008-05-19 00:00:00 | 104 | 356 | 52 | 890 | 942
2008-05-20 00:00:00 | 65 | 391 | 32.5 | 977.5 | 1010
2008-05-21 00:00:00 | 59 | 276 | 29.5 | 690 | 719.5
2008-05-22 00:00:00 | 52 | 257 | 26 | 642.5 | 668.5
2008-05-23 00:00:00 | 81 | 268 | 40.5 | 670 | 710.5
2008-05-24 00:00:00 | 61 | 191 | 30.5 | 477.5 | 508
2008-05-25 00:00:00 | 32 | 136 | 16 | 340 | 356
2008-05-26 00:00:00 | 40 | 219 | 20 | 547.5 | 567.5
2008-05-27 00:00:00 | 66 | 358 | 33 | 895 | 928
2008-05-28 00:00:00 |  |  | 0 | 0 | 0
2008-05-29 00:00:00 |  |  | 0 | 0 | 0
2008-05-30 00:00:00 |  |  | 0 | 0 | 0
2008-05-31 00:00:00 |  |  | 0 | 0 | 0
Spreadsheet: 487703d1478202837-multi-purpose-calander-task-manager-master-worklist
Sheet: Monthly

Column1 | Column2 | Column3 | Column4
2016-04-25 00:00:00
 | M4MO | M4PU | M4AD
 | M4MO | M4PU | M4AD
 | M4MO | M4PU | M4AD
 | M4MO | M4PU | M4AD
 | M4MO | M4PU | M4AD
 | M4MO | M4PU | M4AD
 | M4MO | M4PU | M4AD
 | M4MO | M4PU | M4AD
 | M4MO | M4PU | M4AD
 | M4MO | M4PU | M4AD
Column1 | Column2 | Column3 | Column4
2016-04-25 00:00:00
 | MA4B
 | MM
 | MMO1 | MWS
 | MPU2
 | MF
 | MMO2
 | MPU2 | MW
 | MH
 | MA4B
 | MM
 | MMO1 | MWS
 | MPU2
 | MF
 | MMO2
 | MPU2 | MW
 | MH
 | MA4B
 | MM
 | MMO1 | MWS
 | MPU2
 | MF
 | MMO2
 | MPU2 | MW
 | MH
 | MA4B
 | MM
 | MMO1 | MWS
 | MPU2
 | MF
 | MMO2
 | MPU2 | MW
 | MH
 | MA4B
 | MM
 | MMO1 | MWS
 | MPU2
 | MF
 | MMO2
 | MPU2 | MW
 | MH
 | MA4B
 | MM
 | MMO1 | MWS
 | MPU2
 | MF
 | MMO2
 | MPU2 | MW
 | MH
 | MA4B
 | MM
 | MMO1 | MWS
 | MPU2
 | MF
 | MMO2
 | MPU2 | MW
 | MH
 | MA4B
 | MM
 | MMO1 | MWS
 | MPU2
 | MF
 | MMO2
 | MPU2 | MW
 | MH
 | MA4B
 | MM
 | MMO1 | MWS
 | MPU2
 | MF
 | MMO2
 | MPU2 | MW
 | MH
Spreadsheet: 90900d1290601125-how-to-insert-a-drop-down-country-list-for-ziva
Sheet: 21-11-2010

[NAME] | Name | url | Business Area | location
 |  |  | Diamonds & Jewelry | York
 |  |  | Diamonds & Jewelry | York
 | [NAME] |  | Diamonds & Jewelry | York
 | [NAME] |  | Diamonds & Jewelry
 | Rich
 | [NAME]
 | Yehuda
 | Harold
 | [NAME]
 | [NAME]
 | [NAME]
Spreadsheet: 84321d1284383224-index-match-problem-for-multiple-matches-index
Sheet: Sheet1

Date | Name | Code | Interval | Min | Comments
2010-07-08 00:00:00 | [NAME] | V | S | 1
2010-08-24 00:00:00 | [NAME] | Q | S
2010-08-31 00:00:00 | [NAME] | V | L |  | asdfasdfas
2010-09-01 00:00:00 | [NAME] | V | S | 3
2010-09-02 00:00:00 | [NAME] | F | B1 | 2 | kjasdhkjasdhkj
2010-09-06 00:00:00 | [NAME] | V | B3 | 3 | asdfsdf
2010-09-07 00:00:00 | [NAME] | FMLA | B1 | 2
2010-09-07 00:00:00 | [NAME] | V | S | 1 | asdfsd
2010-09-07 00:00:00 | [NAME] | S | B2 | 5
2010-09-08 00:00:00 | [NAME] | V | S | 3
2010-09-08 00:00:00 | [NAME] | V | S |  | asdfsdf
2010-09-09 00:00:00 | [NAME] | S | B2 | 2
2010-09-09 00:00:00 | [NAME] | S | B2 | 2 | asdfasdfas
2010-09-10 00:00:00 | [NAME] | V | S | 1
2010-09-13 00:00:00 | [NAME] | FMLA | S | 1 | asdfsdf
2010-09-14 00:00:00 | [NAME] | V | S
2010-09-18 00:00:00 | [NAME] | V | S |  | asfsdsaf
2010-09-22 00:00:00 | [NAME] | V | S | 1
2010-09-22 00:00:00 | [NAME] | V | S
2010-09-22 00:00:00 | [NAME] | F | S |  | asdfasfsdf
2010-09-23 00:00:00 | [NAME] | V | S | 1
2010-09-23 00:00:00 | [NAME] | V | B2 | 2
2010-09-25 00:00:00 | [NAME] | V | B2 | 3
2010-09-29 00:00:00 | [NAME] | V | B1 | 5
Spreadsheet: 107502d1304648212-excel-2007-nested-counting-duplicates-example
Sheet: Desired Result 1

 |  | Desired Result
Items | Parts to Make | Tools for current Step | Tools to complete up to this step
Item A | N/A | Hammer, Screwdriver
Item B | N/A | Hammer, Saw
Item C |  | Hammer | Hammer, Saw, Screwdriver
Item D |  | Hammer | Hammer, Saw, Screwdriver