tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 81807d1281968754-data-validation-list-with-condition-data_validation
Sheet: Sheet1

 | AS | Standard Chartered
 | AS | Tata
 | AS | TNT
 | EU | Toyota
 | AS | UBS
 | AS | Unilever
 | EU | UPS
 | AS | Wipro
 | AS | World Bank
 | DE | A.T. Kearney
 | DE | ABB
 | EU | Accenture
 | DE | adidas Group
 | DE | [NAME]
 | DE | Allianz
 | DE | Arthur D. Little
 | DE | Audi
 | DE | Auswärtiges Amt
 | DE | AXA
 | AF | Bain & Company
 | AF | BASF
 | AF | Bayer
 | AF | BayernLB
 | DE | BCG
 | DE | [NAME]
 | AS | Bertelsmann
 | DE | [NAME]
 | AS | BKW
 | DE | BMW
 | DE | Boehringer Ingelheim
 | DE | Booz & Co.
Spreadsheet: 49601d1248962031-vlookup-need-all-values-fitout-liste-detay
Sheet: spec

SPECLER
25045-18-3PS-00003R Rev 0.pdf
25045-18-3PS-03530 Rev 0.pdf
25045-18-3PS-04851R Rev 0.pdf
25045-18-3PS-05700R Rev 0.pdf
25045-18-3PS-06100 Rev 0.pdf
25045-18-3PS-06402R Rev 0.pdf
25045-18-3PS-06425 Rev 0.pdf
25045-18-3PS-07480R Rev 0.pdf
25045-18-3PS-08000 Rev 7.pdf
25045-18-3PS-08414 Rev 0.pdf
25045-18-3PS-08450R Rev 0.pdf
25045-18-3PS-08588R Rev 0.pdf
25045-18-3PS-08712 Rev 7.pdf
25045-18-3PS-08816R Rev 0.pdf
25045-18-3PS-08940R Rev 0.pdf
25045-18-3PS-08950 Rev 0.pdf
25045-18-3PS-09000R Rev 0.pdf
25045-18-3PS-09505 Rev 0.pdf
25045-18-3PS-09510R Rev 0.pdf
25045-18-3PS-09547R Rev 0.pdf
25045-18-3PS-09570 Rev 0.pdf
25045-18-3PS-09571R Rev 0.pdf
25045-18-3PS-09649 Rev 0.pdf
25045-18-3PS-09672 Rev 0.pdf
25045-18-3PS-09681R Rev 0.pdf
25045-18-3PS-09770 Rev 0.pdf
25045-18-3PS-10190 Rev 0.pdf
25045-18-3PS-10260R Rev 0.pdf
25045-18-3PS-10288 Rev 0.pdf
25045-18-3PS-10452 Rev 0.pdf
25045-18-3PS-10519 Rev 0.pdf
25045-18-3PS-10800R Rev 0.pdf
25045-18-3PS-11105 Rev 0.pdf
25045-18-3PS-11135 Rev 0.pdf
25045-18-3PS-11160R Rev 0.pdf
25045-18-3PS-11216 Rev 0.pdf
25045-18-3PS-11400 Rev 0.pdf
25045-18-3PS-11401 Rev 0.pdf
25045-18-3PS-11421 Rev 0.pdf
25045-18-3PS-11830 Rev 0.pdf
25045-18-3PS-11831 Rev 0.pdf
25045-18-3PS-12494R Rev 0.pdf
25045-18-3PS-12500R Rev 0.pdf.pdf
25045-18-3PS-12641 Rev 0.pdf
25045-18-3PS-13095 Rev 0.pdf
25045-18-3PS-16511R Rev 0.pdf
25045-18-3PS-16512R Rev 0.pdf
25045-18-3PS-16525R Rev 0.pdf
25045-18-3PS-16531R Rev 0.pdf
25045-18-3PS-16999 Rev 15.pdf
Spreadsheet: 725010d1616499871-daily-sales-spreadsheet-month-target-2021-22
Sheet: 2021 QTR3

Monthly Target | 2021-10-01 00:00:00 |  |  |  |  |  |  | Monthly Target | 2021-11-01 00:00:00 |  |  |  |  |  | 2021-12-01 00:00:00
31150 |  |  |  |  |  |  |  | 31150
Day | DATE | Daily Target | Daily Sales | Month To Date | Updated Target |  |  | Day | DATE | Daily Target | Daily Sales | Month To Date | Updated Target |  | DATE | Daily Target | Daily Sales | Month To Date | Updated Target
 |  |  | 2491 |  |  |  |  |  |  |  | 2491 |  |  |  |  |  | 2491
 |  |  | 2553 |  |  |  |  |  |  |  | 2553 |  |  |  |  |  | 2553
 |  | Target |  |  |  |  |  |  |  | Target |  |  |  |  |  | Target
TOTAL |  |  |  |  |  |  |  | TOTAL
Spreadsheet: 859659d1707979026-trying-to-pull-data-from-two-sheets-with-formulas-vlookup-array-formula-test-excel-5-aligw
Sheet: DATA ENTRY 

MANUAL ENTRY |  | SALES HISTORY TAB - MANUAL ENTRY |  |  |  |  |  | RPS DATA TAB - MANUAL ENTRY?
Custom SIM List | [NAME] | Pulled Sales History SIM List | SIM Description | [NAME] Months | Sales - 24 Months | Market Cost | Margin | Sell | [NAME] | Contract Start Date | Contract Stop Date | Cost-Side Claim | Authorization Name | Market Cost (Includes WTT) | Replacement Cost (NET cost) | Loaded Margin
[PHONE] | J |  | T&B H104-3/8X10EGC HANGER-ROD | 480 | 388.53 | 308.15 | 0.206882351427174 |  | SASCO-PSO~ | 45152 | 45535 |  |  |  |  | s
[PHONE] | g |  | T&B A1200S10PGC 1-5/8X1-5/8-SLOT-CH | 40 | 350.37 | 167.81 | 0.521049176584753 |  | SASCO-PSO~ | 45152 | 45535 |  |  |  |  | s
[PHONE] | g |  | T&B 54105 6AWG-BLUE-1H-COP-LUG | 107 | 346.58 | 227.86 | 0.342547175255352 |  | PRICE GUIDANCE | 0 | 0 |  |  |  |  | s
[PHONE] | g |  | T&B 842-TB 1/2-BUSHED-NIPPLE | 5 | 12.42 | 7.8 | 0.371980676328502 |  | PRICE GUIDANCE | 0 | 0 |  |  |  |  | s
[PHONE] | g |  | T&B ST125-471 1-1/4-STAR-TECK-FTG | 4 | 233.86 | 173.56 | 0.257846574873856 |  | 45035330-SASCO-ABB_ | 45168 | 45474 |  |  |  |  | s
[PHONE] | g |  | T&B 5266 1-1/2-L/T-SEALING-RING | 18 | 142.29 | 104.23 | 0.267481903155527 |  | PRICE GUIDANCE | 0 | 0 |  |  |  |  | s
[PHONE] | g |  | T&B ST075-468 3/4-MC-CBL-CONN | 5 | 147 | 109.09 | 0.257891156462585 |  | 45035330-SASCO-ABB_ | 45168 | 45474 |  |  |  |  | s
[PHONE] | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
[PHONE] | dsds |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
Spreadsheet: 08f0ed63-3583-4c18-bcd7-086b620b4be6
Sheet: State Code

 | State Name | State Abb | State Code (IPEDS)
2 | Alaska | AK | 2
1 | Alabama | AL | 1
4 | Arkansas | AR | 5
3 | Arizona | AZ | 4
5 | California | CA | 6
6 | Colorado | CO | 8
7 | Connecticut | CT | 9
51 | District of Columbia | DC | 11
8 | Delaware | DE | 10
9 | Florida | FL | 12
10 | Georgia | GA | 13
11 | Hawaii | HI | 15
15 | Iowa | IA | 19
12 | Idaho | ID | 16
13 | Illinois | IL | 17
14 | Indiana | IN | 18
16 | Kansas | KS | 20
17 | Kentucky | KY | 21
18 | Louisiana | LA | 22
21 | Massachusetts | MA | 25
20 | Maryland | MD | 24
19 | Maine | ME | 23
22 | Michigan | MI | 26
23 | Minnesota | MN | 27
25 | Missouri | MO | 29
24 | Mississippi | MS | 28
26 | Montana | MT | 30
33 | North Carolina | NC | 37
34 | North Dakota | ND | 38
27 | Nebraska | NE | 31
29 | New Hampshire | NH | 33
30 | New Jersey | NJ | 34
31 | New Mexico | NM | 35
28 | Nevada | NV | 32
32 | New York | NY | 36
35 | Ohio | OH | 39
36 | Oklahoma | OK | 40
37 | Oregon | OR | 41
38 | Pennsylvania | PA | 42
39 | Rhode Island | RI | 44
40 | South Carolina | SC | 45
41 | South Dakota | SD | 46
42 | Tennessee | TN | 47
43 | Texas | TX | 48
44 | Utah | UT | 49
46 | Virginia | VA | 51
45 | Vermont | VT | 50
47 | Washington | WA | 53
49 | Wisconsin | WI | 55
48 | West Virginia | WV | 54
50 | Wyoming | WY | 56
Spreadsheet: 86924d1286879184-averages-from-annual-observations-copy-of-example
Sheet: Example

country | year | Exports%GDP |  |  |  |  |  | Average Exports
Afghanistan | 1984 |  |  |  |  | Afghanistan | 1984-88 | #N/A
Afghanistan | 1985 |  |  |  |  | Afghanistan | 1989-93 | #N/A
Afghanistan | 1986 |  |  |  |  | Afghanistan | 1994-98 | #N/A
Afghanistan | 1987 |  |  |  |  | Afghanistan | 1999-03 | 21.99
Afghanistan | 1988 |  |  |  |  | Afghanistan | 2004-07 | 11.945
Afghanistan | 1989 |  |  |  |  | Angola | 1984-88
Afghanistan | 1990 |  |  |  |  | Angola | 1989-93
Afghanistan | 1991 |  |  |  |  | Angola | 1994-98
Afghanistan | 1992 |  |  |  |  | Angola | 1999-03
Afghanistan | 1993 |  |  |  |  | Angola | 2004-07
Afghanistan | 1994
Afghanistan | 1995
Afghanistan | 1996
Afghanistan | 1997
Afghanistan | 1998
Afghanistan | 1999
Afghanistan | 2000 |  |  |  |  | Average of Exports%GDP
Afghanistan | 2001 |  |  |  |  | country | year | Total
Afghanistan | 2002 | 32.87 |  |  |  | Afghanistan | 1984-1988
Afghanistan | 2003 | 11.11 |  |  |  |  | 1989-1993
Afghanistan | 2004 | 11.46 |  |  |  |  | 1994-1998
Afghanistan | 2005 | 12.43 |  |  |  |  | 1999-2003 | 21.99
Afghanistan | 2006 |  |  |  |  |  | 2004-2008 | 11.945
Afghanistan | 2007 |  |  |  |  | Afghanistan Total |  | 16.9675
Angola | 1984 | 35.72 |  |  |  | Algeria | 1984-1988 | 34.5075
Algeria | 1985 | 38.55 |  |  |  |  | 1989-1993 | 55.444
Algeria | 1986 | 32.59 |  |  |  |  | 1994-1998 | 73.44500000000001
Algeria | 1987 | 33.02 |  |  |  |  | 1999-2003 | 75.816
Algeria | 1988 | 33.87 |  |  |  |  | 2004-2008 | 74.785
Algeria | 1989 | 38.91 |  |  |  | Algeria Total |  | 63.05681818181817
Algeria | 1990 | 30.26 |  |  |  | Angola | 1984-1988 | 35.72
Algeria | 1991 | 68.79 |  |  |  | Angola Total |  | 35.72
Algeria | 1992 | 53.9 |  |  |  | Grand Total |  | 55.21629629629629
Algeria | 1993 | 85.36
Algeria | 1994
Algeria | 1995 | 82.41
Algeria | 1996 | 68.2
Algeria | 1997 | 56.87
Algeria | 1998 | 86.3
Algeria | 1999 | 89.62
Algeria | 2000 | 76.63
Algeria | 2001 | 73.53
Algeria | 2002 | 69.62
Algeria | 2003 | 69.68
Algeria | 2004 | 79.28
Algeria | 2005 | 73.77
Algeria | 2006 | 71.35
Algeria | 2007 | 74.74
Spreadsheet: 870707d1717168809-highlight-values-with-specific-criteria-cf-and-wildcards2-eba
Sheet: Sheet1

 |  |  |  |  |  | Requirements
 |  | Product Group | Product Group Level 1 | Material Group |  | 1) | Highlight all 3x2xx
 |  | LCR | LCR - LARGE CR | CRN32-2 A-G-A-E-HQUE 3x266/460 60 HZ |  | 2) | Highlight all 3x2xx/4xx
 |  | LCR | LCR - LARGE CR | CRN64-2-2 A-J-E-E-HUUE@E 3x200 50Hz TO
 |  | [NAME] | MEDCR - Medium CR | CR64-2-2 A-J-A-V-HQQV 3x200 50Hz TRM
 |  | [NAME] | MEDCR - Medium CR | CRN45-2 A-G-A-E-HQQE 3x380V 50H SE3BT4 S
 |  | [NAME] | MEDCR - Medium CR | CR32-3-2 P-F-A-E-HQQE 3x400/690 60 HZ
 |  | VLACR | VLACR - Large CR | CR15-9 A-F-A-E-HQQE 3x380V 50HZ IE465
 |  | VLACR | VLACR - Large CR | CR64-2-2 A-F-A-V-HQQV 3x400/690 50 HZ
 |  | VLACR | VLACR - Large CR | CR64-2-2 A-F-A-V-HQQV 3x400/690 50 HZ
 |  | VLACR | VLACR - Large CR | CR64-2-2 A-F-A-V-HQQV 3x400/690 50 HZ
 |  | VLACR | VLACR - Large CR | CR64-2-2 A-F-A-V-HQQV 3x400/690 50 HZ
 |  | VLACR | VLACR - Large CR | CRN45-2 A-F-A-E-HUUE 3x380V 50HZ IE4
 |  | [NAME] | [NAME] | CRN45-1 X-J-E-E-HUUE@D 3x245 60Hz TO
 |  | [NAME] | [NAME] | CRI15-9 A-P-A-E-HQQE 3x200/346 50 HZ
 |  | [NAME] | [NAME] | CRI15-9 A-P-A-E-HQQE 3x200/346 50 HZ
 |  | [NAME] | [NAME] | CRI15-9 A-P-A-E-HQQE 3x200/346 50 HZ
 |  | LCREE | LCREE - LARGE CRE | CRI15-9 A-P-A-E-HQQE 3x200/346 50 HZ
 |  | LACRE | LACRE - Large CRE | CRI32-4-2 X-F-A-E-HQQE 3x400D 50 HZ
 |  | LACRE | LACRE - Large CRE | CRI32-4-2 X-F-A-E-HQQE 3x400D 50 HZ
 |  | MECRE | MECRE - Medium CRE | CRI32-4-2 X-F-A-E-HQQE 3x400D 50 HZ
 |  | MECRE | MECRE - Medium CRE | CRI32-4-2 X-F-A-E-HQQE 3x400D 50 HZ
 |  | MECRE | MECRE - Medium CRE | CRI32-4 X-F-A-E-HQQE 3x400D 50 HZ
 |  | [NAME] | [NAME] | CRI32-4 X-F-A-E-HQQE 3x400D 50 HZ
 |  | [NAME] | [NAME] | CRI32-4 X-F-A-E-HQQE 3x400D 50 HZ
 |  | SCREE | SCREE - SMALL CRE | CRI32-4 X-F-A-E-HQQE 3x400D 50 HZ
 |  | SCREE | SCREE - SMALL CRE | [NAME] A-F-A-E-HQQE 3x400/690 50 HZ
 |  | SCREE | SCREE - SMALL CRE | [NAME] A-F-A-E-HQQE 3x400/690 50 HZ
 |  | SCREE | SCREE - SMALL CRE | [NAME] A-F-A-E-HQQE 3x400/690 50 HZ
 |  | SCREE | SCREE - SMALL CRE | CRI64-2-2 A-F-A-E-HQQE 3x400/690 50 HZ
 |  | [NAME] | SCRE - SMCRE | CR45-2 X-F-A-E-HQQE 3x380V 50HZ EX IE4
 |  | SMCR | SMCR - SMALL CR | CRN15-5 H-GA-A-V-HQQV 213/215TC 60 HZ
 |  | SMCR | SMCR - SMALL CR | CRN15-5 H-GA-A-V-HQQV 213/215TC 60 HZ
 |  | SMCR | SMCR - SMALL CR | CRN15-5 H-GA-A-V-HQQV 213/215TC 60 HZ
 |  | SMCR | SMCR - SMALL CR | CR32-2 A-G-A-E-HQQE 3x230/460 60 HZ
 |  | SMCR1 | SMCR1 - SMALL CR | CR32-2 A-G-A-E-HQQE 3x230/460 60 HZ
 |  | SMCR1 | SMCR1 - SMALL CR | CR32-2 A-G-A-E-HQQE 3x230/460 60 HZ
 |  | SMCR1 | SMCR1 - SMALL CR | CR32-2 A-G-A-E-HQQE 3x230/420 60 HZ
 |  | SMCR1 | SMCR1 - SMALL CR | CR20-7 A-A-A-E-HQQE 3x380V 50HZ IE4
Spreadsheet: 745305d1629844440-formula-for-financial-planning-financial-planning-monthly-w-d
Sheet: Sheet2

 | Scenario 1 | Scenarion 2 | Scenarion 3
Current value | 369000 | 369000 | 369000
Retirement Age | 67 | 67 | 67
Interest rate | 0.05 | 0.07 | 0.09
Inflation | 0.03 | 0.03 | 0.03
Number of years
Monthly withdrawal | 597.0835346041454 | 1194.171184881512 | 1791.262135922265 | <-- using Solver
Future value
Inflation adjusted
PMT
FV
Spreadsheet: 884308d1733401937-support-required-for-wallfall-formula-simplification-new-file
Sheet: working one

 | Value |  |  | 0.2 | 0.3 | 0.4 | 0.5 | 0.6 | 0.7 | 0.8 | 0.9 | 1 | 1 | 1
 | Month | Plan | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | JAN | FEB | MAR | YTD
 | APR | 1
 | MAY | 2
 | JUN | 1
 | JUL | 1
 | AUG | 2
 | SEP | 1
 | OCT | 1
 | NOV | 1
 | DEC | 1
 | JAN | 1
 | FEB | 1
 | MAR | 1
 | TOTAL
Spreadsheet: 218731d1362563845-count-issue-count-test
Sheet: Matrix

Week Commencing: |  |  | 2013-03-04 00:00:00 |  |  |  |  |  | Week Commencing: |  |  | 2013-03-11 00:00:00
Today: |  |  | 2013-03-06 00:00:00
 |  | Mon | Tue | Wed | Thur | Fri |  |  |  |  | Mon | Tue | Wed | Thur | Fri
 |  | 2013-03-04 00:00:00 | 2013-03-05 00:00:00 | 2013-03-06 00:00:00 | 2013-03-07 00:00:00 | 2013-03-08 00:00:00 |  |  |  |  | 2013-03-11 00:00:00 | 2013-03-12 00:00:00 | 2013-03-13 00:00:00 | 2013-03-14 00:00:00 | 2013-03-15 00:00:00
1 - RV53B | Maximum Staff Requirement | 0 | 0 | 2 | 0 | 0 |  |  | 1 - RV53B | Maximum Staff Requirement | 2 | 2 | 0 | 1 | 0
2 - RV74 | Maximum Staff Requirement | 0 | 0 | 2 | 1 | 1 |  |  | 2 - RV74 | Maximum Staff Requirement | 2 | 0 | 0 | 0 | 0
3 - RV53 | Maximum Staff Requirement | 0 | 0 | 3 | 1 | 1 |  |  | 3 - RV53 | Maximum Staff Requirement | 3 | 3 | 3 | 0 | 0
4 - RDKP72 | Maximum Staff Requirement | 0 | 0 | 2 | 2 | 1 |  |  | 4 - RDKP72 | Maximum Staff Requirement | 2 | 2 | 2 | 2 | 1
5 - KIEFEL | Maximum Staff Requirement | 0 | 0 | 0 | 0 | 0 |  |  | 5 - KIEFEL | Maximum Staff Requirement | 0 | 0 | 1 | 1 | 1
6 - RDKP72 | Maximum Staff Requirement | 0 | 0 | 1 | 3 | 2 |  |  | 6 - RDKP72 | Maximum Staff Requirement | 2 | 2 | 2 | 2 | 1
7 - RDKP54 | Maximum Staff Requirement | 0 | 0 | 2 | 1 | 1 |  |  | 7 - RDKP54 | Maximum Staff Requirement | 0 | 2 | 2 | 2 | 2
 |  | Tool | Order Reference | Start Date | End Date | No. Staff
Spreadsheet: 91102d1290781424-a-formula-to-multiple-search-the-value-and-total-up-total-weights-array-formulas
Sheet: Sheet1

 | weight= SF / profile
 | Type no | profile |  |  | Total Weight
 | 10 | 2000 |  | Block A
 | 20 | 3000 |  | Block B
 | 30 | 4000
 | Block A
 | type no | SF
 | 10 | 2500
 | 20 | 1000
 | 10 | 540
 | 30 | 2100
 | [NAME]
 | Type no | SF
 | 20 | 233
 | 20 | 250
 | 10 | 1100
Spreadsheet: 818298d1676720730-need-to-sum-in-a-different-sheet-using-titles-in-current-sheet-to-choose-other-sheets-test2-2-1-
Sheet: Production

 |  |  |  |  |  | Expected results with the word: "Production"
 |  | APR | MAY | JUN |  | APR | MAY | JUN
 | 2022FY Production Claims |  |  |  | <---------- | 2 | 0 | 1
 | Production Sheets 2019FY
 | KPI (N.º Claims/10.000 PS)
 |  | APR | MAY | JUN | <---------- | APR | MAY | JUN
 | 2023FY Production Claims |  |  |  |  | 2 | 2 | 1
 | Production Sheets 2019FY
 | KPI (N.º Claims/10.000 PS)
 | Complaints | 5
 | Production Sheets NOT TFM | 109447
 | KPI fy2021
 | Number of complaints per FY | FY2019 | FY2020 | FY2021
 | Gapping defect | 1
 | Marking failure | 1
 | Slider enamelling | 1
 | Wrong length | 1 | 1
 | Wrong reference/color/finish | 1 | 1
 | Manual work |  | 1 | 1
 | Slider mix | 3 | 1
 | Oxidation/MF Chain | 4
 | Wrong slider | 3 | 1 | 1
 | Dyeing | 1 |  | 5
 | Defects / Lack of terminals/open parts | 5 | 5 | 4
 | By Location | FY2019 | FY2020 | FY2021
 | Chain / Item | 7 | 2 | 5
 | Slider | 4 | 3 | 1
 | Tape | 3
 | Open parts | 3 | 1 | 1
 | Top stop | 2 | 4 | 3
 | Bottom stop | 2
 | By Section
 | CF Assembly TFM | 4 | 2 | 3
 | CF Assembly Apparel | 6 | 4 | 3
 | MF Assembly | 5 | 3 | 1
 | Dyeing TFM | 1 |  | 3
 | [NAME] | 1 | 1 | 2
 | Oxidation/MF Chain | 3
 | Enamelling | 1
 | By [NAME]
 | Wrong component / color | 2 |  | 1
 | Wrong quantity |  | 1
 | Wrong item | 2
 | Stains/Spots - Dirtiness | 1 | 2 | 1
 | Missing component | 3 | 2 | 2
 | Unleveling |  |  | 3
 | Different color/tone | 4 | 2 | 2
 | Slider Mix | 3 | 1
 | Wrong Slider | 3
 | Deficient Operation | 1 | 1 | 1
 | Wrong length | 1 | 1 | 1
 | Marking failure | 1
 |  | 2019 | 2020 | 2021
 |  | 3 CF FR-13 chain | 5 CIFOR | 5 CIFC
 |  | 3 Y | 5 CIFC | 5 CF roll
 |  | 3 CFO | 3 CHC | 5 MF
 |  | 2 CHC | 5 CIFC | 3 CF
 |  | 5 CIFC | 5 CIFC | 5 MF
 |  | 3 Y | 5 VS
 |  | 5 RC | 5 CIFOR
 |  | 3 CF | 5 CIFOR
 |  | 5 CIFC
 |  | 2 CHC
 |  | 5 MFC
 |  | 5 MFC
 |  | 5 MFC
Spreadsheet: 855058d1704781852-need-help-with-formulas-to-return-name-from-roster-on-calendar-resource-tracker-aligw
Sheet: Jul

 |  |  |  |  |  | CALENDAR MONTH | JULY
 |  |  |  |  |  | CALENDAR YEAR
 |  |  |  |  |  | 1ST DAY OF WEEK | MONDAY
daily notes
daily notes
daily notes
daily notes
daily notes
 |  |  | Notes
daily notes
Spreadsheet: 133239d1324303073-using-index-and-match-to-find-several-values-jc-multiplelargestmatches-data1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MI
First Name | Last Name | Student # |  | Clicker # |  | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 |  |  | Ready% |  | Visial Score | Auditory Score | Kinesthetic Score |  | Linguistic | [NAME] | Visual-Spatial | Kinesthetic | Music-Rhythmic | Naturalist | Interpersonal | Intrapersonal |  | Strongest MI |  | Other MIs with strongest score
First 1 | Last 1 | 21 | 1 | 1 |  | 1 | 2 | 1 | 1 | 2 | 3 | 1 | 2 | 1 | 1 | 2 | 3 | 1 | 1 | 2 | 2 | 1 | 2 | 3 | 2 | 1 | 1 | 3 | 3 | 2 | 2 | 1 | 2 | 1 | 2 | 3 | 1 | 2 | 2 | 2 | 2 | 3 | D | A | B | D | A | A | B | A | A | B | A | A | B | A | A | B | A | B | A | B | A | B | B | B | A | A | A | B | A | A | A | A | A | B | A | A | B | B | A | A | B | A | B | A | B |  | 1.666666666666667 | 0.4444444444444444 |  | 4 | 8 | 4 |  | 3 | 4 | 4 | 3 | 5 | 2 | 1 | 2
First 2 | Last 2 | 22 |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | B | D | A | D | A | A | A | A | B | B |  | A | A | A | A | A | B | A | A | A | A | B |  | A | A | B | A | B | A | B | B | A | B | B | A | A | B | A | B | B | A | A | B | B |  |  |  |  | 0 | 0 | 0 |  | 2 | 2 | 4 | 3 | 3 | 2 | 5 | 2
First 3 | Last 3 | 23 | 1 | 3 |  | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 1 | 2 | 1 | 1 | 2 | 2 | 2 | 1 | 1 | 2 | 2 | 1 | 2 | 2 | 3 | 3 | 3 | 2 | 1 | 2 | 2 | 1 | 3 | 2 | 2 | 3 | 2 | 1 | 2 | 3 | A | C | A | B | A | B | A | A | B | A | B |  | A | A | B | A | A | A | B | A | A | A | B | A | B | A | A | A | B | A | A | B | A | A | A | A | A | A | A | A | B | B | A | A | A |  | 1.476190476190476 | 0.5079365079365079 |  | 3 | 7 | 6 |  | 4 | 3 | 3 | 2 | 4 | 5 | 4 | 3
First 4 | Last 4 | 24 | 1 | 4 |  | 2 | 2 | 2 | 3 | 2 | 1 | 3 | 2 | 3 | 1 | 1 | 2 | 2 | 1 | 2 | 1 | 2 | 3 | 2 | 1 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 3 | A | A | A | A | A | A | A | A | B | B | A | A | A | A | A | B | B | A | A | B | A | A | B | A | A | A | A | A | A | B | B | B | B | A | A | A | B | A | A | B | B | A | A | B | A |  | 1.952380952380952 | 0.3492063492063492 |  | 0 | 1 | 15 |  | 3 | 3 | 5 | 3 | 4 | 2 | 4 | 2
Spreadsheet: 684450d1593372081-pair-up-values-in-one-range-area-with-values-in-other-range-area-book1-revised
Sheet: Sheet1

Group One | A | B | C | D | E |  |  | A | B | C | D | E
 | 5 | 3 | 7 | 6 | 4 |  |  | A III |  | C III | D III | E III
 |  |  |  |  |  |  |  | A IV |  | C IV | D IV | E IV
 |  |  |  |  |  |  |  |  |  | C V | D V
Group Two | I | II | III | IV | V
 | 2 | 4 | 7 | 6 | 5
Rules
1. If value of a cell in group-1 is more than 5 (--> 6 and 7), it's paired up with value of cell in group-2 which is more than 4 (--> 5, 6 and 7)
2. If value of a cell in group-1 is more than 3 (--> 4 and 5), it's paired up with value of cell in group-2 which is more than 5 (-->  6 and 7)
3. Those pairs will be put in yellow area
Spreadsheet: 144769d1331132089-lock-all-cells-before-current-date-dates-are-in-column-book1
Sheet: Sheet1

Date | Processor | process | Allocated | Submitted/Approved | Queries Raised | [NAME] | Query Responses Acted / RFMI response | Denied / Rejected Cases Acted | Total Processed | Processing Balance | [NAME]
2012-03-01 00:00:00 | [NAME] | ER Creation
2012-03-02 00:00:00 | Mat | ER Creation | 3 | 2 | 1 |  | 1 |  | 4
2012-03-03 00:00:00 | [NAME] | Extensity | 52 | 47 | 0 | 3 | 0 | 2 | 52 | 0 | 0
2012-03-04 00:00:00 | Christ | Extensity
2012-03-05 00:00:00 | McMilen | Extensity | 56 | 54 | 0 | 2 | 0 | 0 | 56 | 0 | 0
2012-03-06 00:00:00 | KP | Extensity Review
2012-03-07 00:00:00 | [NAME] | PCard | 2 | 2 | 0 |  | 1 |  | 2 | 0 | 0
2012-03-08 00:00:00 | Mepta | Pcard | 2 | 2 |  |  |  |  | 2
2012-03-09 00:00:00 | Optimos | VIP | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2012-03-10 00:00:00 | Billgate | VIP | 32 | 27 | 5 |  | 4 | 1 | 32 | 0 | 5
2012-03-11 00:00:00 | King | VIP
2012-03-12 00:00:00 | Sophi | VIP
2012-03-13 00:00:00 | [NAME] | VIP Rev
2012-03-14 00:00:00 | Phillis | VIP Rev
Spreadsheet: 13ae5cac-54b7-47a7-b5e1-cff0b41668fa
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
LYWB | Test | LYWB | Lyme Disease Antibody, Immunoblot, Serum | Lyme Disease Ab, Immunoblot, S | Immunoblot | Serum Gel Tube: SGT |  |  | 0.25 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.2 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	Heat-inactivated specimen | IgG: negative IgM: negative | Monday through Friday; 9 a.m. Saturday, Sunday; varies | Same day/1 day | 3 days | 2 | 86617 |  |  |  |  | Rochester
LYWB | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
LYWB | Result | 5744 | IgG Immunoblot | IgG Immunoblot | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6320-6 | Borrelia [NAME].[NAME]:ACnc:Pt:Ser:Ord:IB
LYWB | Result | 2992 | IgG Band(s) | IgG Band(s) | Alphanumeric |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | 13502-0 | Borrelia [NAME].IgG band pattern:Imp:Pt:Ser:Nom:IB
LYWB | Result | 23931 | IgM Immunoblot | IgM Immunoblot | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6321-4 | Borrelia [NAME].IgM:ACnc:Pt:Ser:Ord:IB
LYWB | Result | 23932 | IgM Band(s) | IgM Band(s) | Alphanumeric |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | 13503-8 | Borrelia [NAME].IgM band pattern:Imp:Pt:Ser:Nom:IB
LYWB | Result | 6241 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12781-1 | Borrelia [NAME] band pattern:Imp:Pt:Ser:Nom:IB