Administrator
发布于 2026-11-17 / 3 阅读
0
0

WorkBuddy at the Office 06 | Match Registrations to Check-Ins by ID

English
中文

Six people registered for a customer training session. The check-in export has eight rows. Your manager wants the actual headcount, but one person signed in twice and two registrants share the name Lin Ke.

In this exercise, use WorkBuddy to create a workbook with a headcount summary and an exceptions sheet. The sample data gives you five confirmed attendees and two check-in records to follow up on. Open the WorkBuddy desktop app, sign in with available credits, and have a folder where you can save files and an app that opens Excel workbooks. WorkBuddy spreadsheet analysis

1. Prepare the two lists

Create a folder named Training Attendance Practice. If you have the companion workbook, place it there. Its two tabs and names are in Chinese. For an English-language exercise, copy the entire block below. The adjacent commas in S07 leave the entered ID blank.

[Registrations]
Registration ID,Name
R001,Chen Chen
R002,Lin Ke
R003,Lin Ke
R004,Zhou Yue
R005,Li Ning
R006,Wang Qing

[Check-ins]
Check-in record ID,Entered ID,Name,Entry type
S01,R001,Chen Chen,Regular
S02,R002,Lin Ke,Regular
S03,R002,Lin Ke,Regular
S04,R004,Zhou Yue,Regular
S05,R005,Li Ning,Regular
S06,W001,Xu Jie,Walk-in
S07,,Lin Ke,Regular
S08,R999,Zhao Fan,Regular

2. Give WorkBuddy the matching and counting rules

Start a new task and use the workspace picker below the message box to open the practice folder. If you are using the workbook, drag it into the message box and check the attachment name. If you are using the text above, paste it in the same message as the prompt below. Create a task and attach files

Reconcile the registration and check-in lists for this training session. Match by registration ID and use names for review only. Give me a preview and leave the original data intact.

For each registered ID, count the first check-in as attended and flag later check-ins as duplicates. Preserve the check-in record IDs. Mark a registrant absent if no check-in matches their registration ID.

Count a walk-in only if the entry type is explicitly marked Walk-in (现场新增 in the Chinese sample), the entered ID is present and it occurs exactly once in this check-in list. Put blank IDs and unmatched regular check-ins in Pending review and exclude them from confirmed attendance.

Give me a summary with registered people, registered attendees, absentees, duplicate check-in rows, confirmed walk-ins, pending review rows and confirmed attendees. In the exceptions, include category, ID, name, check-in record ID and reason. Leave the check-in record ID blank for absentees.

Start by finding R002 and R003 in the preview. Both people are named Lin Ke, and the check-in sheet matches R002 by ID. S07 also says Lin Ke. Ask the person who handled check-ins to verify that row because its ID is blank.

3. Check the totals before saving

Compare the preview with the expected result. Keep headcounts and row counts separate.

  • Six people registered. Four registered attendees checked in and two were absent. The absent IDs are R003 and R006.
  • S02 is the first check-in for R002. S03 is the duplicate. There is one duplicate row.
  • There is one confirmed walk-in. S06 explicitly marks W001 as a walk-in.
  • Two records need review. S07 has a blank ID, and S08 contains R999, which does not appear in the registration list.
  • Confirmed attendance is five people. Four registered attendees plus one confirmed walk-in.

Account for all eight check-in rows. S01, S02, S04 and S05 are the four first matches. S03 is the duplicate, S06 is the walk-in, and S07 and S08 need review.

If WorkBuddy merges the two people named Lin Ke, ask it to keep R002 and R003 separate, leave S07 pending, and recalculate. If it treats pending records as walk-ins, ask it to reopen the entry types for S07 and S08 and update the preview. Once the totals and IDs match, send this in the same task.

I approve the preview. Save a new file named Customer Training Attendance Reconciliation.xlsx in the current workspace. Use the reviewed numbers and include two worksheets named Summary and Exceptions. Keep the input data intact and include the original check-in record IDs on the Exceptions sheet. Tell me where you saved the file.

4. Open the workbook and trace exceptions back to their rows

Open the workbook from WorkBuddy's results panel or find it in your practice folder. In Summary, check for five confirmed attendees. On Exceptions, look for S03, S06, S07 and S08, plus R003 and R006 with blank check-in record IDs. Keep both input lists with the output so another person can retrace each result. View WorkBuddy results

If an Excel file is unavailable in your setup, ask WorkBuddy for two copyable tables with headers. Paste them into separate worksheets and save the workbook yourself. If your real IDs look like 001, import that column as text and check that the leading zeros survive. Keep leading zeros in Excel

Terms you will use

  • Matching ID. A value that lets you tell whether records in two lists refer to the same person. This exercise uses registration IDs.
  • Deduplication. Count the first check-in for a person and keep any additional rows available for review.
  • Pending review. A record that needs more information before you can confirm the attendee.
  • Exceptions sheet. A list of items that need explaining, with the original IDs so you can find the source rows.

评论