Creating a running name list

shanam1580 

Creating a Running Name List for Nurse Scheduling

Here's how you can create a running name list in Excel to determine whose turn it is for the next listing at your clinic:

1. Create a Table:

• Open Microsoft Excel.
• Enter the following data in a table:

• List all six nurses' names in column A.
• In column B, enter the percentage of time each nurse works (100 for full-time, 75, 60, and 50 for the others).

2. Calculate Appearances:

• In column C (optional), create a heading "Appearances."
• In cell C2, enter the formula =INT(B2/25). This formula calculates how many times a nurse's name should appear in the list based on their percentage (divide by 25 to convert percentages to whole numbers).
• Copy the formula in cell C2 down to all remaining nurse rows (C3 to C7).

3. Build the Running List:

• In column D (optional), create a heading "Running List."
• In cell D2, enter the name of the first nurse in your list (e.g., Nurse 1).
• In cell D3, enter the formula =IF(ROW() <= SUM($C$2:$C2), D2, ""). This formula checks if the current row number is less than or equal to the sum of appearances for all nurses up to the current row. If true, it repeats the name from the previous row. Otherwise, it leaves the cell blank.
• Copy the formula in cell D3 down to all remaining nurse rows (D4 to D7).

4. Drag and Fill:

• Select the entire list in columns A, B, C, and D.
• Hover your mouse over the bottom right corner of the selection until it turns into a plus sign (+).
• Drag the selection downwards as many rows as needed to create the full running list. Excel will automatically fill the names and appearances based on the formulas.

5. Refine and Use:

• You can hide columns B and C (appearances) if you don't need them for reference.
• By scrolling down the "Running List" (column D), you can see which nurse's name appears next, indicating whose turn it is for the listing.

Additional Tips:

• You can format the running list (column D) to highlight the current nurse's name for easier identification.
• This method assumes a fixed schedule for each nurse. If schedules change, you'll need to update the percentages in column B and rebuild the running list.

Alternative Approach:

If you prefer a more visual representation, you can create a separate sheet with a list of nurses and use conditional formatting to highlight the current nurse based on a formula referencing the running list on the other sheet