The Scenario
Summer planning starts in April. The HR manager needs vacation days used, remaining vacation, and sick days for all 20 employees so she can finalize the holiday schedule and approve pending leave requests.
She sent a message asking each team lead to check MOCO and report back. After three days the response rate was about 60%.
The bad version:
- Log into MOCO, navigate to the Absence section, open each employee's record individually, note their vacation and sick day counts, enter them into the Excel workbook one row at a time.
- Realize MOCO shows remaining days based on the contract calendar, not the calendar year — decide which figure goes in the planning workbook and go back to adjust six rows.
- Sort manually by department because that's how the HR director wants it.
Twenty employees. Individually looked up. Manually transcribed. For a workbook that should take seconds to fill.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the workbook and uses its built-in MOCO integration to pull the absence report for all employees in one operation.
Pull the MOCO absence report for 2026 and write each employee's name, vacation days used, remaining vacation days, and sick days into my Leave Planning worksheet
What You Get
- One row per employee in the Leave Planning worksheet.
- Columns: employee name, vacation days used, remaining vacation days, sick days for the year.
- Data reflects MOCO's current state — approved leave requests are included.
- All 20 employees appear, not just the ones who replied to the message.
What If the Data Is Not Quite Ready
I need to include department for sorting
Pull the MOCO absence report for 2026 and write employee name, department, vacation days used, remaining vacation days, and sick days to my Leave Planning worksheet, sorted by department then employee name
I need to flag employees with fewer than 5 vacation days remaining
Pull the MOCO absence report for 2026, write it to my Leave Planning worksheet, and add a column flagging any employee with fewer than 5 remaining vacation days as Low Balance
I need to compare against contractual entitlement to spot discrepancies
Pull the MOCO absence report for 2026 for all employees. For each employee, compare vacation days used plus remaining against the contractual entitlement in my Entitlements worksheet (matched by employee name). Flag any row where the numbers do not add up.
Pull the absence data, flag risks, calculate team coverage gaps, and draft a summary in one shot
Pull the MOCO absence report for 2026. Flag employees with fewer than 5 vacation days remaining. For each month from May to August, calculate how many employees have approved leave overlapping — flag any month where more than 3 employees are out simultaneously. Write all findings to my Leave Planning worksheet.
Twenty rows. Accurate data. The holiday schedule gets approved by end of week.
Try It
Get the 7-day free trial of SheetXAI and open your leave planning workbook, then ask it to pull the MOCO absence report for the year. See also the utilization report spoke if you want to combine absence data with billable hour analysis.