tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: a085a18d-ee96-4ba5-9d3e-093817739506
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
FDPD | Test | FDPD | Dihydropyrimidine Dehydrogenase (DPD) Gene Mutation Analysis | DPD Gene Mutation | Polymerase Chain Reaction, Single Nucleotide Primer Extension | EDTA (lavender-top) tube: EDTA |  |  | 5 | mL | Collect 5 mL lavender-top (EDTA) whole blood. Ship ambient immediately. | 3 mL | Specimens Other Than:	Whole blood Anticoagulants Other Than:	EDTA, ACD A, ACD B, heparin Hemolysis:	NA Thawing:	Warm OK; Cold OK Lipemia:	NA Icteric:	NA | Dihydropyrimidine dehydrogenase (DPD) is the rate-limiting  enzyme in the pathway for the degradation of the pyrimidine  bases, uracil and thymine. DPD also catalyzes the  detoxification of pyrimidine-based chemotherapeutic agents  (e.g. 5-fluorouracil (5-FU) and capecitabine). Decreased  DPD activity is associated with severe myelosuppression or  even lethal toxicity, in patients treated with standard  doses of 5-FU. DPD deficiency is associated with congenital  thymine-uraciluria, an autosomal recessive condition  characterized by convulsive disorders, microcephaly, and  mental retardation. The IVS14+1G>A mutation in the  splice-donor site of intron 14 of the DPD gene (located on  chromosome 1) accounts for approximately 50% of DPD  deficiency alleles.   The IVS14+1G>A mutation is detected by polymerase chain  reaction (PCR) amplification of a portion of the DPD gene,  followed by a single nucleotide primer extension reaction  using fluorescent dideoxynucleotides, and detection of the  fluorescent reaction products using an automated, capillary  DNA sequencer. Since genetic variation and other problems  can affect the accuracy of the direct mutation testing,  these results should always be interpreted in light of  clinical and familial data.   This test is performed pursuant to a license agreement with  Orchid Biosciences Inc  Test Performed By:  Quest Diagnostics Nichols Institute                                         36608 [NAME]                                         San Juan Capistrano, CA  92690 | 2 days per week | 5-6 days | 7-14 days | 1 | 81400 |  |  |  |  | Quest Diagnostics/Nichols Institute
FDPD | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Ambient | 8 days
FDPD | Result | Z2293 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45284-7 | DPYD gene mutation analysis:Prid:Pt:Bld/Tiss:Nom:Molgen
FDPD | Result | Z2294 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FDPD | Result | Z2295 | Reviewed By: | Reviewed By: | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 857760d1706650043-how-to-remove-names-text-if-repeated-in-another-cell-schedule
Sheet: Jan-24

 |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun
 |  | 2023-01-29 00:00:00 | 2023-01-30 00:00:00 | 2023-01-31 00:00:00 | 2023-02-01 00:00:00 | 2023-02-02 00:00:00
Location 1 |  | [NAME] | [NAME] | [NAME]
Location 2 |  | [NAME] | [NAME]
Location 3 |  |  |  |  | Alicia | Alicia
Location 4 |  | [NAME] | [NAME] | [NAME] | Ally | [NAME]
Location 5
Location 6
Location 7
Location 8
Location 9
Location 10
Location 11 |  |  |  | [NAME] | [NAME] | [NAME]
Task1 |  | Gail / Lori | Sami / Glenn | Krystal / Krysta | Tracy/ [NAME] | Allison / Lori
[NAME] |  | Alicia | Ally | [NAME] | [NAME] | [NAME]
Office
WFH |  | Sami | [NAME], [NAME], [NAME] | [NAME]
Meetings
Meetings
Vacation/TOIL |  |  | [NAME] |  | Krystal | Krystal
Other |  | Krystal Appt @ 12:55 |  |  |  | [NAME] 11:00
Other
I have 7 field staff that I need to keep an eye on their schedule (names are in the 'Table' worksheet), and they show up in row 16.  As those staff members are allocated locations/tasks, their names are automatically removed from the line (16).  Perfect!
Well, it all works perfectly apart from one thing! I have one non-field staff member whose name does not need to be in line 16, but at times may show up in lines 17-22.  The problem is that because the name is so close to another it is
The reason…One of the field staff has the name "[NAME]" and the other is "Krystal"
So, if I enter "Krystal" into the any of the cells (C17:G22), "Krysta" disappears from line 16 (See C21, F20, and F21)
Is there a way changing this?
Spreadsheet: 684411d1593351351-ranking-with-zeros-and-count-error-ranking-zeros-and-rank-count-error
Sheet: Sheet1

Values | Rank |  |  | Required Result
1512
0 |  |  |  | 0
0 |  |  |  | 0
1365
1258
894
265 |  |  | TWO 12'S | No 11
0 |  |  |  | 0
83
254
855
798
1450
1257
741
0 |  |  |  | 0
0 |  |  |  | 0
265 |  |  | TWO 12'S
1157
Spreadsheet: 865459d1712552172-formula-to-spill-days-and-dates-date-sample
Sheet: Sheet1

Enter Start Date | 2024-03-12 00:00:00
Week #1
Day | Date
[NAME] | 2024-03-12 00:00:00
Wed | 2024-03-13 00:00:00
Thur | 2024-03-14 00:00:00
Fri | 2024-03-15 00:00:00
Sat | 2024-03-16 00:00:00
Sun | 2024-03-17 00:00:00 |  | `
Mon | 2024-03-18 00:00:00
Week#2
Day | Date
[NAME] | 2024-03-19 00:00:00
Wed | 2024-03-20 00:00:00
Thur | 2024-03-21 00:00:00
Fri | 2024-03-22 00:00:00
Sat | 2024-03-23 00:00:00
Sun | 2024-03-24 00:00:00
Mon | 2024-03-25 00:00:00
Spreadsheet: 2bfead87-8f72-4c17-b9f8-94433e058a1a
Sheet: PP 7.06.09-7.19.09

WAGE EMPLOYEE BIWEEKLY TIME CARD |  |  |  |  |  |  | Employee name: |  |  |  |  |  | Week starting: |  | 2009-10-26 00:00:00
 |  |  |  |  |  |  | Manager name: |  |  |  |  |  | Week ending:
 | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday
Time In |  | Total |  | Total |  | Total |  | Total |  | Total |  | Total |  | Total
Time Out
Time In |  | Total |  | Total |  | Total |  | Total |  | Total |  | Total |  | Total | Total Hours Scheduled
Time Out
Total
Employee signature |  |  |  |  | Date |  |  |  | Manager signature |  |  |  |  | Date
By signing above, we certify that the information on this form is accurate and complete.
 |  |  |  |  |  |  |  |  |  |  |  |  | Week starting: |  | 2009-11-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | Week ending:
 | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday
Time In |  | Total |  | Total |  | Total |  | Total |  | Total |  | Total |  | Total
Time Out
Time In |  | Total |  | Total |  | Total |  | Total |  | Total |  | Total |  | Total | Total Hours Scheduled
Time Out
Total
Employee signature |  |  |  |  | Date |  |  |  | Manager signature |  |  |  |  | Date
By signing above, we certify that the information on this form is accurate and complete.
· Employees are to complete their daily in and out times, print, sign and submit this form to their supervisor at the end of the pay period
· Only the total hours worked per day are transferred to the Biweekly Time Sheet
· Supervisors are to keep employee's Weekly Time Cards on file for 4 years
· Employees are to obtain approval from their supervisor before working overtime hours
· Overtime hours must be submitted on the Overtime Form with a copy of the employee's Weekly Time Card
Spreadsheet: 124550d1318455106-excel-2007-invoice-data-lookup-order-template-wip
Sheet: TimeWiseSkinCare

TimeWise Skin Care | Description | ITEM | PRICE
Cleanser 3 in 1 | Normal to Dry | Cleanser 3 in 1 Normal to Dry | 18
Cleansing Bar 3 in 1 with soap dish | Combination to Oily | Cleanser 3 in 1 Combination to Oily | 18
Age Fighting Moisturizer | Normal to Dry | Cleansing Bar 3 in 1 with soap dish Normal to Dry | 18
Solution | Combination to Oily | Cleansing Bar 3 in 1 with soap dish Combination to Oily | 18
Miracle Set | Normal to Dry | Age Fighting Moisturizer Normal to Dry | 22
Microdermabrasion | Combination to Oily | Age Fighting Moisturizer Combination to Oily | 22
[NAME] C | with SPF 15 | Age Fighting Moisturizer with SPF 15 | 22
[NAME] | Day with SPF 25 | Day Solution Sunscreen SPF 25 | 30
Age Fighting Eye Cream | Night | Night Solution | 30
Age Fighting Lip Primer | Trial Normal to Dry | Miracle Set Trial Normal to Dry | 44
Targeted Action Eye Revitalizer | Trial Combination to Oily | Miracle Set Trial Combination to Oily | 44
Targeted Action Line Reducer | Normal to Dry | Miracle Set Normal to Dry | 90
Even Complexion Mask | Combination to Oily | Miracle Set Combination to Oily | 90
Even Complexion Essence | Set | Microdermabrasion Set | 55
Hand and Décolleté Cream Sunscreen SPF 15 | Step 1 Refine | Microdermabrasion Step 1 | 30
Targeted Action Toning Lotion | Step 2 Replenish | Microdermabrasion Step 2 | 25
Visibly Fit Body Lotion | 4 week supply | [NAME] C | 55
Night Restore and Recover Complex | Normal to Dry | [NAME] | 30
 | Combination to Oily | Age Fighting Eye Cream | 26
 |  | Age Fighting Lip Primer | 22
 |  | Targeted Action Eye Revitalizer | 35
 |  | Targeted Action Line Reducer | 40
 |  | Even Complexion Mask | 30
 |  | Even Complexion Essence | 35
 |  | Hand and Décolleté Cream Sunscreen SPF 15 | 18
 |  | Targeted Action Toning Lotion | 28
 |  | Visibly Fit Body Lotion | 22
 |  | Night Restore & Recover Complex Normal to Dry | 40
 |  | Night Restore & Recover Complex Combination to Oily | 40
Spreadsheet: 753b4fa9-6c2b-4e21-a18d-94a364cefb32
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7479 | 57782 | Mark | Shrosbree | JPN | 0 | 00:10:53 | 00:00:56 | 01:03:23 | 00:01:09 | 00:40:28 | 1 | 01:56:50
7479 | 51326 | Keren | [NAME] | JPN | 0 | 00:11:06 | [NAME] | 01:04:41 | 00:01:02 | 00:43:16 | 2 | 02:00:57
7479 | 53655 | Toshinori | Tomioka | JPN | 0 | 00:10:52 | 00:00:54 | 01:06:52 | 00:01:08 | 00:41:45 | 3 | 02:01:32
7479 | 57784 | Mitsuhirp | Shibuya | JPN | 0 | 00:10:50 | 00:01:09 | 01:05:15 | 00:01:09 | 00:44:37 | 4 | 02:02:59
7479 | 57785 | Masato | Murai | JPN | 0 | 00:15:10 | 00:01:14 | 01:22:09 | 00:01:30 | 01:06:31 | 5 | 02:46:36
7479 | 57786 | [NAME] | Boardman | JPN | 0 | [NAME] | 00:00:54 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 41068442-9b3c-49fc-9f8e-9d44e680600f
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
MPLB | Test | MPLB | MPL Exon 10 Mutation Detection, Blood | MPL Exon 10 Mutation Detection, B | Mutation Detection in DNA Using Sanger Sequencing (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) |  |  |  | 4 | mL | [NAME] must arrive within 168 hours of draw.   Container/Tube: Preferred: Lavender top (EDTA) Acceptable: ACD [NAME]: 4 mL Collection Instructions: 1. Invert several times to mix blood. 2. Send specimen in original tube. Additional Information: Date of draw is required. Forms:  1. Hematopathology Patient Information Sheet (Supply T676) in Special Instructions 2. If not ordering electronically, submit a Hematopathology/Molecular Oncology Request Form (Supply T241) with the specimen. | 1 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold reject Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Monday through Friday | 5 days | 8 days | 1 | 81403 |  |  |  |  | Rochester
MPLB | [NAME] | BLOOD | Whole blood |  |  |  | Ambient | 7 days
MPLB | Result | 19997 | Final Diagnosis: | Final Diagnosis: | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34574-4
Spreadsheet: 167110d1341904818-index-match-multiple-results-in-drop-down-dynamicdropdowns_usingindex-1-
Sheet: Lists

Category 1 | Category 2 | Category 3
c1c1 | c2c1 | c3c1
c1c2 | c2c2 | c3c2
c1c3 | c2c3 | c3c4
c1c4 | c2c3 | c3c5
c1c5 | c2c4 | c3c6
c1c6 |  | c3c7
 |  | c3c8
 |  | c3c1
 |  | c3c10
 |  | c3c11
 |  | c3c11
Spreadsheet: michelle_lokay__26697__imball0111rev
Sheet: Citizens

Citizens Communications
 | Measured | Scheduled | Imbalance
56659 | -1020 | -3779
500046 | -7219 |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500086 |  |  |  |  |  |  |  |  |  |  | lunch | 7.6
500134 |  | -2136
500528
500529
500619
INDEX
2001-10-31 00:00:00 |  |  | -551791.86
2001-11-30 00:00:00
CBS Volume
 |  |  | -44959
Spreadsheet: 329511d1404325948-trouble-with-sumif-formula-on-totals-tab-example-payroll-2
Sheet: Trainer & Fee Ref. List

 | [NAME] | Ceci | Kilee | New Hire | New Hire | New Hire | New Hire | New Hire | New Hire | New Hire | New Hire | New Hire | New Hire
60 Minute | 70 | 140 | 420 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70
45 Minute | 50 | 100 | 300 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50
30 Minute | 40 | 80 | 240 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40
Class | 30 | 60 | 180 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30
Office Work | 20 | 40 | 120 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20
Expos | 15 | 30 | 90 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15
Spreadsheet: 863248d1710813728-need-help-with-employee-census-sample-census-data-stanley318-
Sheet: Sheet1

Need help with employee census. (excelforum.com)
Original Sample Data Set |  |  |  |  |  |  |  |  |  |  |  |  | How I want the data set to appear:
 |  |  |  |  |  |  |  |  |  |  |  |  | Alphabetically by employee, then dependents listed by spouse then child
SSN | Last | First | Relation | Emp order | Data order |  |  | SSN | Last | First | Relation |  | SSN | Last | First | Relation
111-11-1111 | [NAME] | [NAME] | Employee |  |  |  |  |  |  |  |  |  | 444-44-4444 | [NAME] | [NAME] | Employee
222-22-2222 | Jones | Penelope | Employee |  |  |  |  |  |  |  |  |  | 444-44-4444 | [NAME] | Nina | Spouse
222-22-2222 | Jones | [NAME] | Spouse |  |  |  |  |  |  |  |  |  | 444-44-4444 | [NAME] | [NAME] | Child
222-22-2222 | [NAME] | [NAME] | Child |  |  |  |  |  |  |  |  |  | 555-55-555 | Butler | Leo | Employee
333-333-333 | Smith | [NAME] | Employee |  |  |  |  |  |  |  |  |  | 555-55-555 | [NAME] | Gina | Child
333-333-333 | Smith | [NAME] | Spouse |  |  |  |  |  |  |  |  |  | 222-22-222 | Jones | Penelope | Employee
333-333-333 | Smith | [NAME] | Child |  |  |  |  |  |  |  |  |  | 222-22-2222 | Jones | [NAME] | Spouse
444-44-4444 | [NAME] | [NAME] | Employee |  |  |  |  |  |  |  |  |  | 222-22-2222 | [NAME] | [NAME] | Child
444-44-4444 | [NAME] | Nina | Spouse |  |  |  |  |  |  |  |  |  | 111-11-1111 | [NAME] | [NAME] | Employee
444-44-4444 | [NAME] | [NAME] | Child |  |  |  |  |  |  |  |  |  | 333-333-333 | Smith | [NAME] | Employee
555-55-555 | Butler | Leo | Employee |  |  |  |  |  |  |  |  |  | 333-333-333 | Smith | [NAME] | Spouse
555-55-555 | [NAME] | Gina | Child |  |  |  |  |  |  |  |  |  | 333-333-333 | Smith | [NAME] | Child
Was originally 222-22-222 which didn't match the spouse or child
Spreadsheet: 165534d1341258172-excel-2007-index-and-match-with-duplicates-book
Sheet: GREAT SUCCESS

martial Artist |  | Values |  | Top 6  Martial Artists |  |  | Top 6 Values
[NAME] |  | 9 |  | [NAME]
[NAME] |  | 8
[NAME] |  | 7
Chow-Yun Fat |  | 5
[NAME] |  | 5 |  | Chow-Yun Fat |  |  | 5
[NAME] |  | 10 |  | [NAME] |  |  | 4
[NAME] |  | 4
[NAME] |  | 7
Spreadsheet: 199954d1355370647-lookup-formula-to-pick-up-first-arriving-values-lookup-across-columns-picking-up-first-arriving-values
Sheet: Sheet1

LOOK UP TABLE
 | Jan | Feb | Mar | April | May | June
Cadburys | 40 | 60 | 25 | 70 | 20 | 10
Cadburys | 40 | 60 | 25 | 80 | 20 | 20
Cadburys | 40 | 60 | 25 | 90 | 20 | 30
Mars | 20 | 30 | 65 | 20 | 30 | 40
Mars | 20 | 30 | 65 | 9 | 40 | 50
Snickers | 25 | 27 | 54 | 20 | 50 | 1
Snickers | 25 | 27 | 54 | 20 | 60 | 2
 | Jan | Feb | Mar | April | May | June
Cadburys | 40 | 60 | 25 | 90 | 20 | 30
Mars | 20 | 30 | 65 | 20 | 40 | 50
Snickers | 25 | 27 | 54 | 20 | 60 | 2
 |  |  |  |  |  |  |  | Lookup formula to pick first values for the criteria, matching product name and month
 |  |  |  | press [NAME] and Enter at the same time after edit the formula
Spreadsheet: 87363d1287167413-expanding-a-legend-template
Sheet: Sheet1

 | (Staff Name)
Time | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
06:00:00 | Available | Available | Available | Available | Available | Busy | Busy
 | Available | Available | Available | Available | Available | Busy | Busy
07:00:00 | Client 1 | Available | Available | Available | Available | Busy | Busy
 | Client 1 | Client 1 | Available | Available | Available | Busy | Busy
08:00:00 | Client 1 | Client 1 | Available | Available | Available | Busy | Busy
 | Client 1 | Client 1 | Client 3 | Available | Client 3 | Busy | Busy
09:00:00 | Client 1 | Client 1 | Client 3 | Available | Client 3 | Busy | Busy
 | Client 1 | Client 1 | Client 3 | Available | Client 3 | Busy | Busy
10:00:00 | Client 1 | Client 1 | Client 3 | Available | Client 3 | Busy | Busy
 | Client 1 | Client 1 | Client 3 | Available | Client 3 | Busy | Busy
11:00:00 | Client 1 | Client 1 | Client 3 | Available | Client 3 | Busy | Busy
 | Client 1 | Client 1 | Client 3 | Available | Client 3 | Busy | Busy
12:00:00 | Client 1 | Client 1 | Client 3 | Available | Client 3 | Busy | Busy
 | Client 1 | Client 1 | Client 3 | Available | Client 3 | Busy | Busy
13:00:00 | Client 1 | Client 1 | Client 3 | Available | Client 3 | Busy | Busy
 | Client 1 | Client 1 | Client 3 | Available | Client 3 | Busy | Busy
14:00:00 | Client 2 | Client 2 | Client 3 | Available | Client 3 | Busy | Busy
 | Client 2 | Client 2 | Client 3 | Available | Client 3 | Busy | Busy
15:00:00 | Client 2 | Client 2 | Client 3 | Available | Client 3 | Busy | Busy
 | Client 2 | Client 2 | Client 3 | Available | Client 3 | Busy | Busy
16:00:00 | Client 2 | Client 2 | Available | Available | Client 2 | Busy | Busy
 | Client 2 | Client 2 | Available | Available | Client 2 | Busy | Busy
17:00:00 | Client 2 | Client 2 | Busy | Busy | Client 2 | Busy | Busy
 | Client 2 | Client 2 | Busy | Busy | Client 2 | Busy | Busy
18:00:00 | Client 2 | Client 2 | Busy | Busy | Client 2 | Busy | Busy
 | Busy | Busy | Busy | Busy | Client 2 | Busy | Busy
19:00:00 | Busy | Busy | Busy | Busy | Client 2 | Busy | Busy
 | Busy | Busy | Busy | Busy | Busy | Busy | Busy
20:00:00 | Busy | Busy | Busy | Busy | Busy | Busy | Busy
 | Busy | Busy | Busy | Busy | Busy | Busy | Busy
21:00:00 | Busy | Busy | Busy | Busy | Busy | Busy | Busy
 | Busy | Busy | Busy | Busy | Busy | Busy | Busy
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
Legend |  | Weekly Hours
Busy | Available | Book Review | Travel Time
Client 1 | Client 2 | Client 3 | Client 4 | Client 5 | Client 6 | Client 7 | Client 8
Spreadsheet: 96593d1295966922-mailto-problem-nazorg
Sheet: Formulier

 |  |  |  |  |  |  |  |  |  |  |  | 2011-01-25 00:00:00
Nazorgformulier |  |  |  |  |  |  | Nazorgmomenten
[NAME]: |  |  |  |  |  |  | 1e
Registratienummer:
Geboortedatum: |  |  |  | Leeftijd:
[NAME]:
Geslacht:
Geplaatst op: |  |  |  |  |  |  | 2e
Eerst nazorg op:
Tweede nazorg op:
Derde nazorg op:
[NAME] nazorg op:
Gastgezin: |  |  |  |  |  |  | 3e
[NAME]:
Eigenaar:
Adresgegevens:
 |  |  |  |  |  |  | 4e
[NAME]:
Telefoonnummer:
Bijzonderheden:
Spreadsheet: 62674d1263571852-extracting-information-within-a-merged-combined-cell-poc-lookup-1-
Sheet: Sheet1

System Name | Location | POC
a | 1 | Name
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | POCS Subtotal: 3
b | 2 | Name
 |  | [NAME]
 |  | [NAME]
 |  | POC Subtotal: 2
c | 3
d | 4 | Name
 |  | [NAME]
 |  | POCS Subtotal: 1
Spreadsheet: 766021d1643725731-conditional-formatting-how-to-blank-out-a-cell-if-conditions-are-met-in-other-cell-a
Sheet: a

 | Name if known (current staff) | [NAME] | Status of role | Role Type | Grade | Role Duration (Project allocation) | Contract Start Date | Contract End Date | Day Rate | Duration (working days) |  | Salary | Pension | NI | MonthlyTotal
1 |  |  | Vacancy | FTC
 |  |  | Position Filled | Please Select
 |  |  | Please Select | Please Select
 |  |  | Please Select | Please Select
 |  |  | Please Select | Please Select
 |  |  | Please Select | Please Select
 |  |  | Please Select | Please Select
 |  |  | Please Select | Please Select
 |  |  | Please Select | Please Select
 |  |  | Please Select | Please Select
 |  |  | Please Select | Please Select
 |  |  | Please Select | Please Select
 |  |  | Please Select | Please Select
 |  |  | Please Select | Please Select
 |  |  | Please Select | Please Select
 |  |  | Please Select | Please Select
 |  |  | Please Select | Please Select
 |  |  | Please Select | Please Select
 |  |  | Please Select | Please Select
 |  |  | Please Select | Please Select
 |  |  |  | Please Select
 |  |  |  | FTC
 |  |  |  | Day Contractor
 |  |  |  | FTE
 |  |  |  | Agency Temp
 |  |  |  | Consultant
Spreadsheet: 676883d1589038476-combine-vlookup-and-if-with-specific-values-and-iferror-samplevlookupwiferror
Sheet: Sheet1

 | Reference Table
 | ID# | Name |  |  | My Results |  |  |  |  | What I'm looking for:
 | 1802 | (blank)
 | 2009 | Chloe |  |  | ID# | Name | presence of name | Combined |  | ID# | Combined
 | 3412 | (blank) |  |  | 4465 |  |  |  |  | 4465 | 1
 | 3454 | Ruby |  |  | 6327 |  |  |  |  | 6327
 | 3774 | Poppy |  |  | 5099 |  |  |  |  | 5099
 | 4400 | (blank) |  |  | 5948 |  |  |  |  | 5948
 | 4465 | [NAME] |  |  | 6385 |  |  |  |  | 6385 | 1
 | 4644 | [NAME] |  |  | 9081 |  |  |  |  | 9081 | 1
 | 4750 | [NAME] |  |  | 3774 |  |  |  |  | 3774 | 1
 | 4994 | Willow |  |  | 4750 |  |  |  |  | 4750 | 1
 | 5099 | (blank) |  |  | 6895 |  |  |  |  | 6895 | 1
 | 5180 | Erin |  |  | 6234 |  |  |  |  | 6234
 | 5470 | Molly |  |  | 6854 |  |  |  |  | 6854
 | 5548 | [NAME] |  |  | 8920 |  |  |  |  | 8920
 | 5554 | Zola |  |  | 2009 |  |  |  |  | 2009 | 1
 | 5708 | Sophie |  |  | 1864 |  |  |  |  | 1864
 | 5882 | (blank) |  |  | 5548 |  |  |  |  | 5548 | 1
 | 6327 | (blank) |  |  | 5555 |  |  |  |  | 5555
 | 6385 | Charlotte |  |  | 7546 |  |  |  |  | 7546
 | 6854 | (blank) |  |  | 3590 |  |  |  |  | 3590
 | 6868 | Phoebe |  |  | 4994 |  |  |  |  | 4994 | 1
 | 6895 | [NAME] |  |  | 8131 |  |  |  |  | 8131
 | 7479 | (blank) |  |  | 2043 |  |  |  |  | 2043
 | 8131 | (blank)
 | 8177 | (blank)
 | 8787 | [NAME]
 | 9457 | [NAME]
 | 9732 | (blank)
 | 9828 | Zuri
Spreadsheet: 143112d1330205563-help-with-if-excel-function-sample_if
Sheet: Sheet2

 |  |  |  |  | FAIL | Summary
 |  |  |  | Test 1 | NA
 |  |  |  | Test 2 | NA
 |  |  |  | Test 3 | NA
 |  |  |  | Test 4 | NA
 |  |  |  | Test 5 | NA
 |  |  |  | Test 6 | OK
 |  |  |  | Test 7 | OK
 |  |  |  | Test 8 | OK
 |  |  |  | Test 9 | NOK
 |  |  |  | Test 10 | NOK
 |  |  |  | Test 11 | NOK
 |  |  |  | Test 12 | NOK
 |  |  |  | Test 13 | OK
 |  |  |  | Test 14 | OK
 |  |  |  | Test 15 | OK
 |  |  |  | Test 16 | OK
 |  |  |  | Test 17 | NOK
 |  |  |  | Test 18 | NOK
 |  |  |  | Test 19 | NOK
 |  |  |  | Test 20 | NOK
 |  |  |  | Test 21 | NOK
 |  |  |  | Test 22 | NOK
 |  |  |  | Test 23 | NOK
 |  |  |  | Test 24 | NOK
 |  |  |  | Test 25 | NOK
 |  |  |  | Test 26 | NOK
 |  |  |  | Test 27 | NOK
 |  |  |  | Test 28 | OK
 |  |  |  | Test 29 | OK
 |  |  |  | Test 30 | OK
 |  |  |  | Test 31 | OK
 |  |  |  | Test 32 | OK
 |  |  |  | Test 33 | OK
 |  |  |  | Test 34 | OK
 |  |  |  | Test 35 | OK
 |  |  |  | Test 36 | OK
 |  |  |  | Test 37 | OK
 |  |  |  | Test 38 | NOK
 |  |  |  | Test 39 | NOK
 |  |  |  | Test 40 | NOK
 |  |  |  | Test 41 | NOK
 |  |  |  | Test 42 | NOK
 |  |  |  | Test 43 | NOK
 |  |  |  | Test 44 | NOK
Spreadsheet: 98871d1297705384-linking-information-to-key-words-activetimetable
Sheet: Data Sheet

Activity | Maximum Numbers | Cost
Water Walkerz | 12 | 5
Archery | 12 | 12
Junior Archery | 12 | 5
Cross Bows | 12 | 10
Fencing | 12 | 10
[NAME] | 12 | 5
Sea Scooters | 12 | 10
Pool Canoes | 12 | 5
Skip Hop | 12 | 5
Petanque | 12 | 5
FUNdamentals | 12 | 5