AI Session Example
Below is the output of a session where a user asks an AI tool a set of 81 questions on different topics about data in Tuumik. For this a new demo account was created at demo.tuumik.com that was filled with randomly generated data showcasing a law firm with 65 lawyers tracking their work. Then an AI tool (Claude Code) was connected to this new user's account at demo.tuumik.com via an MCP connection. This gives the AI tool the ability to make queries to Tuumik and analyse the responses to answer questions.
Deployment: demo.tuumik.com
AI tool: Claude Code
AI model: Sonnet 5
Although this session was set up using Claude Code and Sonnet 5, in practice any AI tool that supports the MCP standard can be connected to Tuumik.
1. Billable hours & productivity
- How many billable hours did every team log this week compared to last week?
- Who are the top 5 users by billable hours this month?
- Which users logged fewer than 30 billable hours last week?
- What's the average daily billable hours per user across the firm this quarter?
- Show me a breakdown of billable hours by team for June.
- Are there any users who haven't logged any time in the past 3 business days?
- What's the trend in total billable hours over the last 6 months?
- Which day of the week do we log the most billable hours?
- Who worked the most on weekends this month?
- What's the median length for timesheet entries?
- Compare each user's billable hours this month to their own 6-month average — who is significantly above or below?
2. Availability & the in/out board
- Who is marked as in right now?
- What percentage of the team was marked available during core hours (9–17) last week?
- Which users are most frequently marked out during business hours?
- Show me Jessica's availability history for the past two weeks.
- At what time do people typically set themselves to "in" each morning?
- How many total available hours did the Finance team show on the board last month?
- Which days last month had the lowest overall availability?
- Who changed their status most frequently yesterday — lots of in/out toggling?
- Compare average daily availability between the Finance and the Dispute teams this month.
- Were there any days where fewer than 3 people on the Finance team were available?
3. Clients
- Which clients consumed the most billable hours this quarter?
- What percentage of our total hours went to our top 3 clients this year?
- Which clients have had no time logged against them in the past 60 days?
- How have hours for client Telior AB trended over the past 12 months?
- Which team spends the most time on client Telior AB?
- List all clients that have active projects but less than 10 hours logged this month.
- Which new clients (added in the last 90 days) are generating the most work?
- Is our client workload concentrated or diversified — what does the distribution of hours across clients look like this year?
- Who created client Swedish Timber AB, and when exactly was it added to the system?
- Which clients were created in the last 30 days, by whom, and on what dates?
- Who has created the most new clients this year?
- Show me a monthly timeline of client creation over the past years?
4. Projects
- Which projects received the most hours this month?
- Which projects have gone completely inactive (no time logged in 30+ days)?
- How many hours in total have been logged on project Vortexa since it started?
- Who has worked on project Vortexa, and how many hours has each person contributed?
- Which projects have only one person working on them?
- What's the average number of users contributing to each active project?
- Compare hours logged on project Vortexa vs project Brackmoor over the last quarter.
- Which projects saw the biggest week-over-week increase in logged hours?
- How is the workload for client Arpetel Logistics distributed across their projects?
- Which projects had time logged this week by users outside the team that usually works on them?
- Who created project Vortexa and when?
- Which projects were created in the last 30 days, by whom, and for which clients?
- Are there projects that were created but have never had any time logged — who created them and how long ago?
- How soon after a client is added do we typically create their first project — and who usually sets those up?
5. Users & teams
- Which teams exist in our organization and how many members does each have?
- Which teams does Jessica belong to?
- List all members of the Finance team and flag anyone who is also on another team.
- Which users belong to more than one team?
- When was Frank's account created, and who created it?
- Which user accounts were added in the last 90 days, by whom, and on what dates?
- Are there users who don't belong to any team?
- How has each team's headcount changed over the past year?
6. Cross-collection insights
- Which users were marked as available for long stretches but logged few billable hours (utilization gap)?
- What's each user's utilization rate (billable hours divided by available hours on the board) this month?
- Which team has the best utilization rate this quarter?
- Did anyone log billable time on days they were marked out all day?
- On days when availability was low firm-wide, did billable output drop proportionally?
- Which users' timesheet hours don't line up with their status history this week — any anomalies I should review?
- Which teams are overloaded (high hours per available person) and which have spare capacity right now?
- Give me a Monday-morning summary: who's in today, what got logged last week and any anomalies worth reviewing.
- Prepare a month-end report for client Morrison Engineering LLC: total hours, breakdown by project and by user, compared to the previous month.
7. After-hours & late-night work
- Has anyone been working late nights this month? Who does it most?
- For the people logging billable time late at night this month, does their in/out board history show them as working at those hours?
8. Planned time & scheduling
- What's scheduled for next week. Who's overbooked and who has room to take on more?
9. Work type, tags & unattributed time
- What's the type of work for client Charlton Milling AB this year?
- How many hours are sitting in red-tagged (write-off / do-not-bill) entries this month, and for which clients?
- How much logged time this month isn't attached to any client or project, and who has the most unattributed hours?
10. Data hygiene & anomalies
- Who logs their time days after the fact instead of same-day?
- Does anyone have overlapping time entries this month (double-billing?
- Whose in/out board status hasn't changed in over a week?
11. Vacation, coverage & workload balance
- Who's on vacation right now and when is each person back?
- Which weekday is our business-hours coverage thinnest — should we stagger anything?
- Is after-hours and weekend work concentrated in the same people (burnout risk)?
12. Write operations
- Log 2 hours for me yesterday on project Vortexa re settlement negotiations.
- Mark Andrew as out sick today with a note that he is expected back Monday.
- Create a new client "Test Client".
13. Self-service
- What did I work on last week?
- How many hours did I log last week in total?
1. Billable hours & productivity
How many billable hours did every team log this week compared to last week?
| Team | This week (Mon 13 Jul – Sat 18 Jul, in progress) | Last week (Mon 6 Jul – Sun 12 Jul) | Change per day |
|---|---|---|---|
| Dispute | 1,155.3 h | 1,216.2 h | +10.8% |
| Employment | 665.3 h | 726.4 h | +6.8% |
| Finance | 364.9 h | 409.8 h | +3.9% |
This week is still in progress (6 of 7 days elapsed), so the fair comparison is the per-day rate: every team is logging slightly more hours per day than last week.
12s
Who are the top 5 users by billable hours this month?
| # | User | Hours (1–18 Jul) |
|---|---|---|
| 1 | David Newton | 94.9 h |
| 2 | Anna Whitfield | 94.3 h |
| 3 | Ivy Sinclair | 88.8 h |
| 4 | Lauren Fisher | 86.4 h |
| 5 | Lucas Grant | 83.7 h |
9s
Which users logged fewer than 30 billable hours last week?
48 users logged fewer than 30 billable hours during the week of Mon 6 Jul – Sun 12 Jul:
| User | Hours |
|---|---|
| Hannah Wallace | 29.9 |
| Elizabeth Jones | 29.7 |
| Victoria Sanders | 29.3 |
| Laura Bentley | 29.2 |
| Robin Hawkins | 28.1 |
| Olivia Bennett | 27.9 |
| Lily Hudson | 27.6 |
| George Harris | 27.6 |
| Emily Bryant | 27.1 |
| Lucas Grant | 26.7 |
| Benjamin Watts | 25.8 |
| Chris Moore | 25.7 |
| Ellen Prescott | 25.3 |
| Emma Coleman | 25.1 |
| Joseph Sullivan | 24.2 |
| Megan Stewart | 24.0 |
| Nathan Curtis | 23.9 |
| Ethan Parker | 23.7 |
| Richard Jones | 23.4 |
| Ava Russell | 23.0 |
| Oliver Hampton | 22.5 |
| Jack Morrison | 22.3 |
| Spencer Howell | 22.2 |
| John Smith | 21.9 |
| Matthew Reeves | 21.0 |
| Abigail Spencer | 20.6 |
| Maria Vaughn | 20.3 |
| Brooke Norman | 19.9 |
| Thomas Lawson | 19.7 |
| Daniel Carter | 19.1 |
| Alice Harmon | 18.4 |
| Zoe Patterson | 18.0 |
| Diana Mercer | 17.3 |
| Nora Ellison | 17.3 |
| Andrew Bradley | 17.2 |
| Charlotte Hayes | 16.8 |
| Ruth Callahan | 16.3 |
| Sophia Reed | 16.0 |
| Mia Foster | 15.9 |
| Sarah Bishop | 14.9 |
| Frank Davis | 14.2 |
| Chloe Robinson | 13.9 |
| Michael Pearson | 13.9 |
| Claire Donovan | 12.7 |
| Jessica Miller | 11.5 |
| Amanda Green | 11.3 |
| Henry Mitchell | 10.2 |
| Ryan Cooper | 1.6 |
Note: Ruth Callahan and Ryan Cooper joined the firm on 7 Jul and 11 Jul respectively, so they only had part of the week available to log time.
19s
What's the average daily billable hours per user across the firm this quarter?
So far this quarter (1 Jul – 18 Jul, 18 of 92 days elapsed) the firm logged 4,000.7 billable hours across 65 users, which averages to about 3.4 hours per user per day. Since the quarter has only just started, this figure will move as more of Q3 is logged.
9s
Show me a breakdown of billable hours by team for June.
| Team | Hours (June) | Contributors |
|---|---|---|
| Dispute | 2,699.5 h | 47 |
| Employment | 1,669.4 h | 29 |
| Finance | 930.1 h | 15 |
Note: the system's timesheet history begins on 13 June, so June's figures cover 13–30 June rather than the full month.
9s
Are there any users who haven't logged any time in the past 3 business days?
Yes — 3 users logged nothing at all on any of the last 3 business days (Wed 15 – Fri 17 Jul): Isabella Ward, Peter Wilson, and Samantha Anderson.
24s
What's the trend in total billable hours over the last 6 months?
The tenant's actual timesheet history only goes back to 13 June 2026 — there is no logged time before that date, so a genuine 6-month trend isn't available yet. Within the available window:
| Month | Hours | Days with data |
|---|---|---|
| June (13–30) | 3,644.4 h | 18 |
| July (1–18, to date) | 4,000.7 h | 18 |
Comparing like-for-like (18 logged days each), volume is up about 9.8% per day from June to July.
14s
Which day of the week do we log the most billable hours?
| Weekday | Total hours (5 occurrences each, 13 Jun–18 Jul) |
|---|---|
| Thursday | 1,575.0 h |
| Friday | 1,567.7 h |
| Tuesday | 1,531.0 h |
| Monday | 1,511.3 h |
| Wednesday | 1,376.2 h |
Thursday is the busiest billing day, though Thursday, Friday and Tuesday are close together. Weekend logging is minimal by comparison (Saturday 42.8 h, Sunday 41.2 h in total).
8s
Who worked the most on weekends this month?
Robin Hawkins logged the most weekend billable time this month (1–18 Jul): 4.3 hours across 3 entries on Saturdays/Sundays. Runner-up was Anna Whitfield with 3.4 hours.
7s
What's the median length for timesheet entries?
The median timesheet entry is 61 minutes long (average 68.9 minutes, longest entry 256 minutes ≈ 4.3 hours), based on all 6,653 entries in the system's history (13 Jun – 18 Jul 2026).
9s
Compare each user's billable hours this month to their own 6-month average — who is significantly above or below?
A true 6-month average isn't available — the tenant's timesheet history only starts 13 June 2026. Comparing each user's July-to-date daily rate against their rate in that earlier period instead:
| User | June rate (h/day) | July rate (h/day) | Change |
|---|---|---|---|
| Significantly above | |||
| David Newton | 2.45 | 5.27 | +115.5% |
| Benjamin Watts | 2.30 | 4.05 | +76.1% |
| Anna Whitfield | 3.32 | 5.24 | +57.7% |
| Hannah Wallace | 2.57 | 4.06 | +58.1% |
| Lucas Grant | 2.98 | 4.65 | +55.9% |
| Significantly below | |||
| Diana Mercer | 4.77 | 3.29 | -31.1% |
| Amanda Green | 2.68 | 2.10 | -31.1% |
| Victoria Sanders | 4.88 | 3.51 | -28.2% |
| Peter Wilson | 3.88 | 2.90 | -25.2% |
| Jessica Miller | 3.51 | 2.84 | -19.0% |
14s
Back to top ↑
2. Availability & the in/out board
Who is marked as in right now?
Nobody is currently marked IN — it's Saturday. All 65 users show OUT except 3 on VACATION: Samantha Anderson (back 29 Jul), Peter Wilson (back 27 Jul) and Isabella Ward (back 22 Jul).
18s
What percentage of the team was marked available during core hours (9–17) last week?
Across the full week (Mon 6 – Sun 12 Jul, including the weekend), the firm was on a work status for 46.6% of possible core-hour (9:00–17:00) time. Restricted to weekdays only (Mon–Fri), availability during core hours was 66.1% — i.e. on the average weekday core-hour minute, about two-thirds of the 65 users were IN, in a MEETING, in COURT or REMOTE.
33s
Which users are most frequently marked out during business hours?
Ranked by number of separate OUT periods during business hours (9–17, weekdays, 13 Jun – 18 Jul):
| User | OUT periods | Total hours OUT (in window) |
|---|---|---|
| Charlotte Hayes | 21 | 44.0 h |
| Jack Morrison | 20 | 58.8 h |
| George Harris | 20 | 50.0 h |
| Megan Stewart | 20 | 54.5 h |
| Grace Murphy | 20 | 43.8 h |
14s
Show me Jessica's availability history for the past two weeks.
Jessica Miller's status history, 4–18 Jul 2026 (Europe/Tallinn time):
| Day | Status timeline | Available hours |
|---|---|---|
| Tue 7 Jul | IN 08:11–09:54, MEETING 09:54–10:45, IN 10:45–12:16, LUNCH, IN 13:13–13:45, then OUT | 4.6 h |
| Wed 8 Jul | IN 09:02–11:08, then OUT | 2.1 h |
| Thu 9 Jul | OUT all day | 0 h |
| Fri 10 Jul | REMOTE 08:52–13:23, LUNCH, REMOTE 14:17–18:05, then OUT | 8.3 h |
| Sat 11 – Mon 13 Jul | OUT the entire stretch | 0 h |
| Tue 14 Jul | REMOTE 08:34–13:29, LUNCH, REMOTE 14:11–17:00, then OUT | 7.7 h |
| Wed 15 Jul | IN 08:21–09:03, COURT 09:03–11:41, IN 11:41–12:01, LUNCH, IN 12:28–14:51, then OUT | 6.1 h |
| Thu 16 Jul | REMOTE 08:55–09:35, MEETING 09:35–12:15, REMOTE 12:15–13:20, LUNCH, REMOTE 14:00–17:41, then OUT | 8.1 h |
| Fri 17 Jul | IN 08:36–12:26, LUNCH, IN 12:53–14:46 (last recorded status) | 5.7 h |
Notable gap: she shows fully OUT from Wed 8 Jul afternoon through all of Thursday, and again from Saturday 11 Jul through Monday 13 Jul with no note attached to those periods.
59s
At what time do people typically set themselves to "in" each morning?
On average, people first move to a working status (IN, REMOTE, MEETING or COURT) around 8:46 AM, based on 1,487 user-days on record (13 Jun – 18 Jul 2026).
14s
How many total available hours did the Finance team show on the board last month?
The Finance team logged 1,190.6 available (work-status) hours on the in/out board in June, across its 15 members.
11s
Which days last month had the lowest overall availability?
The lowest-availability days in June were the weekends, as expected — Saturday 13, Sunday 14, Saturday 20, Sunday 21, Saturday 27 and Sunday 28 June all showed at or near zero work-status minutes firm-wide (14 Jun and 27 Jun were exactly zero). Availability recovers fully each Monday.
17s
Who changed their status most frequently yesterday — lots of in/out toggling?
Yesterday (Fri 17 Jul), three people tied for the most status changes, each with 8:
| User | Status changes |
|---|---|
| Gary Carroll | 8 |
| Alice Harmon | 8 |
| Michael Pearson | 8 |
| Anna Whitfield | 6 |
| Hannah Wallace | 6 |
10s
Compare average daily availability between the Finance and the Dispute teams this month.
So far in July, Finance averages about 4.7 available hours per person per day (1,270 hours across 15 members over 18 days), slightly ahead of Dispute's 4.5 hours per person per day (4,039 hours across 50 members). The two teams are close, with Finance marginally more available on a per-person basis.
10s
Were there any days where fewer than 3 people on the Finance team were available?
Yes. Looking at business hours (9–17) since the data began (13 Jun – 18 Jul), Finance's simultaneous headcount dropped below 3 on two weekdays: Wednesday 1 July (down to 1 person at times) and Thursday 16 July (down to 1 person). It also dipped to exactly 2 on Friday 10 July. Weekends trivially show 0, as nobody is scheduled then.
14s
Back to top ↑
3. Clients
Which clients consumed the most billable hours this quarter?
| Client | Hours (Q3 to date, 1–18 Jul) |
|---|---|
| Fractal Telecommunication LLC | 202.1 h |
| Valtratel AS | 202.1 h |
| Telavia Aeronautical Engineering AB | 201.4 h |
| Gilleon Services PLC | 200.9 h |
| Norton Systems AB | 193.0 h |
7s
What percentage of our total hours went to our top 3 clients this year?
The top 3 clients this year (Valtratel AS 414.1 h, Telavia Aeronautical Engineering AB 409.4 h, Gilleon Services PLC 404.6 h) total 1,228.0 hours out of the firm's 7,645.1 billable hours logged year-to-date — about 16.1%. Note: the tenant's actual timesheet history only starts 13 June 2026.
8s
Which clients have had no time logged against them in the past 60 days?
5 clients have had zero time logged against them in the past 60 days (19 May – 18 Jul): Aeon Communication Inc, Atelmar Finance LLC, Davedon Retail AB, Idena Architecture PLC, and Sapetel Studios AB.
10s
How have hours for client Telior AB trended over the past 12 months?
The closest match in the system is Telior AS (no client named "Telior AB" exists). Its actual history only goes back to 13 June 2026: June (13–30) logged 185.6 hours over 13 active days (≈14.3 h/day), and July (1–18 so far) logged 171.8 hours over 15 active days (≈11.5 h/day) — roughly a 20% drop in daily pace month over month. No data exists further back, so a full 12-month trend isn't available.
12s
Which team spends the most time on client Telior AB?
Using Telior AS (the closest match): the Dispute team spends the most time on this client — 264.0 hours, vs 168.1 hours for Employment and 83.6 hours for Finance (13 Jun – 18 Jul).
7s
List all clients that have active projects but less than 10 hours logged this month.
Every client in the system has at least one project. Of those, 5 have logged zero hours this month (1–18 Jul), putting them under the 10-hour bar: Aeon Communication Inc, Atelmar Finance LLC, Davedon Retail AB, Idena Architecture PLC, and Sapetel Studios AB. Every other client already has 16+ hours logged this month.
51s
Which new clients (added in the last 90 days) are generating the most work?
| Client | Added | Hours generated since |
|---|---|---|
| Telavia Aeronautical Engineering AB | 20 Apr 2026 | 409.4 h |
| Arpetel Logistics AS | 22 Apr 2026 | 365.4 h |
| Finelia OY | 4 Jun 2026 | 287.1 h |
| Finbank AB | 12 Jun 2026 | 217.1 h |
| Wells Acetel AB | 16 May 2026 | 208.3 h |
22 clients in total were added in the last 90 days (since 19 Apr).
36s
Is our client workload concentrated or diversified — what does the distribution of hours across clients look like this year?
Workload is broadly diversified. The top 3 clients account for only about 16% of total hours, and the top 10 (out of 40 active clients) account for roughly 50% — with no single client exceeding about 5.4% of the firm's total billable time. It's a long tail rather than a few dominant accounts.
16s
Who created client Swedish Timber AB, and when exactly was it added to the system?
Swedish Timber AB was created by Ivy Sinclair on 30 June 2026 at 22:18:09 (Europe/Tallinn time), i.e. 2026-06-30T19:18:09.742Z UTC.
17s
Which clients were created in the last 30 days, by whom, and on what dates?
12 clients were created since 18 June 2026:
| Client | Created | By |
|---|---|---|
| Sapetel Studios AB | 14 Jul 2026 | Megan Stewart |
| PMC Electronics LLC | 11 Jul 2026 | Ryan Cooper |
| Idena Architecture PLC | 8 Jul 2026 | Richard Jones |
| Indelex Systems AB | 8 Jul 2026 | Jack Morrison |
| Arktik Invest AS | 5 Jul 2026 | Emily Bryant |
| Horizon Machinery GmbH | 2 Jul 2026 | Claire Donovan |
| Swedish Timber AB | 30 Jun 2026 | Ivy Sinclair |
| Martel GmbH | 30 Jun 2026 | Sarah Bishop |
| Atelmar Finance LLC | 26 Jun 2026 | Mia Foster |
| Davedon Retail AB | 25 Jun 2026 | Chloe Robinson |
| Municipality of Greenwich | 24 Jun 2026 | Oliver Hampton |
| AMS Hotels AB | 18 Jun 2026 | Mia Foster |
8s
Who has created the most new clients this year?
Lucas Grant has created the most clients this year (2026): 3, followed by a tie of several people at 2 each (Chloe Robinson, Megan Stewart, Mia Foster, Oliver Hampton, Rachel Powell, Richard Jones, Thomas Lawson). 34 clients have been created in total in 2026.
8s
Show me a monthly timeline of client creation over the past years?
| Month | Clients created |
|---|---|
| 2025-06 | 1 |
| 2025-07 | 1 |
| 2025-09 | 1 |
| 2025-11 | 1 |
| 2025-12 | 2 |
| 2026-01 | 3 |
| 2026-02 | 4 |
| 2026-03 | 3 |
| 2026-04 | 4 |
| 2026-05 | 5 |
| 2026-06 | 9 |
| 2026-07 | 6 (so far) |
All 40 clients on record were added between June 2025 and July 2026, with a clear acceleration from Q1 2026 onward.
8s
Back to top ↑
4. Projects
Which projects received the most hours this month?
| Project | Client | Hours (1–18 Jul) |
|---|---|---|
| Dispute with Ataxa GmbH | Valtratel AS | 120.9 h |
| Loan Agreements with Sundström Bank | Fractal Telecommunication LLC | 111.7 h |
| Employment Dispute with Laura Bennett | Keitoberg LTD | 111.4 h |
| Public Procurement No 28545218 – Expansion of Trolleby Bridge 100 | Telavia Aeronautical Engineering AB | 110.4 h |
| Termination of Lease Agreement No 12-42 (Idelor AB, Almena Center) | Nautica AS | 105.6 h |
7s
Which projects have gone completely inactive (no time logged in 30+ days)?
None of the established projects have gone inactive — every project that had ever been worked on still has hours logged within the last 30 days. The only projects with zero logged time are 11 brand-new ones created on 16–18 Jul that simply haven't started yet: Lease Agreements (A320 Fleet), Termination of Distribution Agreement with Pollex GmbH 109, Termination of Lease Agreement No 12-42 (Idelor AB, Almena Center) 108, Public Procurement No 90561238 – Development of E-Government Portal, Sales Agreement No 144-1228 (Maltikal Chemical Facilities), Public Procurement No 28545218 – Expansion of Trolleby Bridge, Dispute with Environmental Protection Agency, Termination of Lease Agreement (Atelia 17), Patent Application for Heatcore Exchanger, Cooperation Agreement with Orvex Solutions LLC, and Employment Dispute with Daniel Carter.
15s
How many hours in total have been logged on project Vortexa since it started?
73.7 hours have been logged on "Settlement Negotiations with Vortexa Industries" (client: Swedish Timber AB) since it was created on 6 Jul 2026 — its entire lifetime to date.
7s
Who has worked on project Vortexa, and how many hours has each person contributed?
43 people have logged time on the Vortexa project. Top contributors:
| User | Hours |
|---|---|
| Benjamin Watts | 9.7 h |
| Isabella Ward | 4.7 h |
| John Smith | 4.3 h |
| Nathan Curtis | 3.8 h |
| Hannah Wallace | 3.7 h |
The remaining 38 contributors each logged between 0.3 and 3.4 hours.
8s
Which projects have only one person working on them?
None. Every project with logged time has at least 10 contributors — the smallest is "Employment Dispute with Laura Bennett 111" with 10 people. (Separately, 11 brand-new projects have zero contributors so far because no time has been logged on them yet.)
10s
What's the average number of users contributing to each active project?
Among the 50 projects that have logged time, the average is about 51 contributors per project. If you count all 61 projects in the system, including the 11 brand-new ones with no contributors yet, the average drops to about 42.
36s
Compare hours logged on project Vortexa vs project Brackmoor over the last quarter.
Vortexa ("Settlement Negotiations with Vortexa Industries") didn't exist yet last quarter (Q2, Apr–Jun) — it was only created on 6 Jul. Brackmoor ("Insolvency of Brackmoor Retail LLC") logged 77.5 hours in Q2. Comparing them instead in the current quarter to date (1–18 Jul), where both are active: Vortexa has 73.7 hours (43 contributors) vs Brackmoor's 67.9 hours (38 contributors) — Vortexa is slightly ahead.
20s
Which projects saw the biggest week-over-week increase in logged hours?
"Joint Venture with Halvorsen Maritime OY" (Xenimex Entertainment Inc) saw by far the biggest jump: from 6.2 hours the week of 6–12 Jul to 30.9 hours the week of 13–18 Jul (+about 400%). Other notable risers: "Termination of Lease Agreement (Lindgatan 42)" (+100% per-day rate), "Public Procurement No 28545218 – Expansion of Trolleby Bridge 107" (+85%), and "Insolvency of Trellix Trading AB" (+55%).
13s
How is the workload for client Arpetel Logistics distributed across their projects?
Arpetel Logistics AS has 2 projects, and the workload is almost perfectly split between them: "Public Procurement No 90561238 – Development of E-Government Portal 112" at 182.8 hours and "Merger with Falkenberg Logistics OY" at 182.6 hours.
9s
Which projects had time logged this week by users outside the team that usually works on them?
This is hard to answer cleanly for this firm: team membership overlaps heavily (most staff belong to two of the three teams), so nearly every project already draws contributors from all three teams as a matter of course — Dispute, Employment and Finance members all show up on the same matters regularly. There's no project this week where a team appears that hasn't historically worked on it; cross-team contribution is the norm here rather than an exception worth flagging.
38s
Who created project Vortexa and when?
Kate Sheldon created "Settlement Negotiations with Vortexa Industries" on 6 July 2026 at 05:03 (Europe/Tallinn time).
17s
Which projects were created in the last 30 days, by whom, and for which clients?
26 projects were created since 18 June 2026:
| Project | Client | Created | By |
|---|---|---|---|
| Lease Agreements (A320 Fleet) | Indelex Systems AB | 18 Jul | Gary Carroll |
| Termination of Distribution Agreement with Pollex GmbH 109 | Davedon Retail AB | 18 Jul | Peter Freeman |
| Termination of Lease Agreement No 12-42 (Idelor AB, Almena Center) 108 | Sapetel Studios AB | 18 Jul | Jessica Miller |
| Public Procurement No 90561238 – Development of E-Government Portal | Atelmar Finance LLC | 18 Jul | Julia Thornton |
| Sales Agreement No 144-1228 (Maltikal Chemical Facilities) | Idena Architecture PLC | 18 Jul | Samuel Greenwood |
| Public Procurement No 28545218 – Expansion of Trolleby Bridge | Idena Architecture PLC | 18 Jul | William Barrett |
| Dispute with Environmental Protection Agency | Horizon Machinery GmbH | 18 Jul | Ryan Cooper |
| Termination of Lease Agreement (Atelia 17) | Municipality of Greenwich | 18 Jul | Ruth Callahan |
| Patent Application for Heatcore Exchanger | Aeon Communication Inc | 18 Jul | Ryan Cooper |
| Cooperation Agreement with Orvex Solutions LLC | Arktik Invest AS | 18 Jul | David Newton |
| Employment Dispute with Daniel Carter | Morrison Engineering LLC | 17 Jul | Ryan Cooper |
| Acquisition of Trenholm Foods AB | Horizon Machinery GmbH | 16 Jul | Ryan Cooper |
| Trademark Registration (Northwind Brands) | Arktik Invest AS | 14 Jul | Ava Russell |
| Employment Dispute with Laura Bennett 111 | Martel GmbH | 14 Jul | Gary Carroll |
| Share Purchase Agreement (Indixa AB) 113 | PMC Electronics LLC | 14 Jul | Victoria Sanders |
| Software Licensing Agreement (Cloud Platform) | Municipality of Greenwich | 13 Jul | Samantha Anderson |
| Acquisition of Steinholt Properties AB | Indelex Systems AB | 11 Jul | Anna Whitfield |
| Joint Venture with Halvorsen Maritime OY | Xenimex Entertainment Inc | 9 Jul | Rachel Powell |
| Public Procurement No 28545218 – Expansion of Trolleby Bridge 110 | AMS Hotels AB | 6 Jul | Chris Moore |
| Settlement Negotiations with Vortexa Industries | Swedish Timber AB | 6 Jul | Kate Sheldon |
| Shareholders Agreement (Meridian Capital AB) | Xenimex Entertainment Inc | 3 Jul | Natalie Brooks |
| Dispute with Alden Insurance LLC | Swedish Timber AB | 1 Jul | Lucas Grant |
| Termination of Partnership with Chromitel AB | Finbank AB | 28 Jun | Chris Moore |
| Termination of Distribution Agreement with Pollex GmbH | Finbank AB | 24 Jun | William Barrett |
| Employment Dispute with Laura Bennett 104 | Finelia OY | 24 Jun | Thomas Lawson |
| Restructuring of Cavendish Group | Finelia OY | 18 Jun | Zoe Patterson |
9s
Are there projects that were created but have never had any time logged — who created them and how long ago?
Yes, 11 projects — all created within the last 1–2 days, which is why they haven't been touched yet:
| Project | Created by | When |
|---|---|---|
| Lease Agreements (A320 Fleet) | Gary Carroll | 18 Jul (today) |
| Termination of Distribution Agreement with Pollex GmbH 109 | Peter Freeman | 18 Jul (today) |
| Termination of Lease Agreement No 12-42 (Idelor AB, Almena Center) 108 | Jessica Miller | 18 Jul (today) |
| Public Procurement No 90561238 – Development of E-Government Portal | Julia Thornton | 18 Jul (today) |
| Sales Agreement No 144-1228 (Maltikal Chemical Facilities) | Samuel Greenwood | 18 Jul (today) |
| Public Procurement No 28545218 – Expansion of Trolleby Bridge | William Barrett | 18 Jul (today) |
| Dispute with Environmental Protection Agency | Ryan Cooper | 18 Jul (today) |
| Termination of Lease Agreement (Atelia 17) | Ruth Callahan | 18 Jul (today) |
| Patent Application for Heatcore Exchanger | Ryan Cooper | 18 Jul (today) |
| Cooperation Agreement with Orvex Solutions LLC | David Newton | 18 Jul (today) |
| Employment Dispute with Daniel Carter | Ryan Cooper | 1 day ago (17 Jul) |
15s
How soon after a client is added do we typically create their first project — and who usually sets those up?
Across the 39 clients with a project, the first project typically appears about 2 weeks after the client is added (roughly 15 days on average, ranging from under a day to about 6 weeks). One client — Aeon Communication Inc — waited over 10 months for its first project. Interestingly, in every single case the first project was created by someone other than whoever added the client — no client-creator ever set up their own client's first project. No one person clearly "owns" this step firm-wide, though a handful of people (e.g. Chloe Robinson, David Newton, Gary Carroll) show up more than once as the one who sets up a new client's first matter.
2m 18s
Back to top ↑
5. Users & teams
Which teams exist in our organization and how many members does each have?
| Team | Members |
|---|---|
| Dispute | 50 |
| Employment | 30 |
| Finance | 15 |
65 users total; membership overlaps since 30 of them belong to two teams.
2m 13s
Which teams does Jessica belong to?
Jessica Miller belongs only to the Dispute team.
5s
List all members of the Finance team and flag anyone who is also on another team.
Finance has 15 members; 10 of them also belong to another team:
| Member | Also on |
|---|---|
| Chris Moore | Dispute |
| Brooke Norman | Dispute |
| Sophia Reed | Employment |
| Spencer Howell | Dispute |
| Emily Bryant | Dispute |
| Grace Murphy | Dispute |
| Natalie Brooks | Employment |
| Lauren Fisher | Dispute |
| Claire Donovan | Dispute |
| Kate Sheldon | Dispute |
| Robin Hawkins | — (Finance only) |
| Abigail Spencer | — (Finance only) |
| Rachel Powell | — (Finance only) |
| Julia Thornton | — (Finance only) |
| Ellen Prescott | — (Finance only) |
4s
Which users belong to more than one team?
30 of the firm's 65 users belong to two teams (nobody is on all three): Elizabeth Jones, Chris Moore, Frank Davis, Richard Jones, Peter Freeman, Brooke Norman, Olivia Bennett, Emma Coleman, Sophia Reed, Spencer Howell, James Holloway, Ava Russell, Emily Bryant, Daniel Carter, Thomas Lawson, Joseph Sullivan, Grace Murphy, Hannah Wallace, Natalie Brooks, Andrew Bradley, Lauren Fisher, Megan Stewart, Jack Morrison, Samuel Greenwood, Claire Donovan, Nora Ellison, Ethan Parker, Kate Sheldon, Laura Bentley, and Ruth Callahan.
5s
When was Frank's account created, and who created it?
Frank Davis's account was created on 29 January 2025 by Elizabeth Jones.
4s
Which user accounts were added in the last 90 days, by whom, and on what dates?
| User | Created | By |
|---|---|---|
| Ryan Cooper | 11 Jul 2026 | John Smith |
| Ruth Callahan | 7 Jul 2026 | Lauren Fisher |
| Ivy Sinclair | 30 Jun 2026 | Abigail Spencer |
| Diana Mercer | 1 May 2026 | Brooke Norman |
| Ellen Prescott | 23 Apr 2026 | Peter Freeman |
8s
Are there users who don't belong to any team?
No — every one of the 65 users belongs to at least one team.
4s
How has each team's headcount changed over the past year?
Using account-creation dates as a proxy for growth (current membership, not a historical change log):
| Team | ~1 year ago | Today | Growth |
|---|---|---|---|
| Dispute | 21 | 50 | +29 (+138%) |
| Employment | 12 | 30 | +18 (+150%) |
| Finance | 6 | 15 | +9 (+150%) |
All three teams have roughly two-and-a-half times their headcount from a year ago, with Dispute adding the most people in absolute terms.
3s
Back to top ↑
6. Cross-collection insights
Which users were marked as available for long stretches but logged few billable hours (utilization gap)?
Comparing billable hours logged to hours available on the in/out board this month (1–19 Jul), these users show the widest utilization gap:
| User | Billed | Available | Utilization |
|---|---|---|---|
| Amanda Green | 37.8 h | 65.2 h | 58.0% |
| Henry Mitchell | 45.9 h | 78.5 h | 58.5% |
| Sophia Reed | 41.3 h | 70.5 h | 58.5% |
| Mia Foster | 45.5 h | 76.9 h | 59.1% |
| Matthew Reeves | 55.6 h | 92.7 h | 60.0% |
2m 41s
What's each user's utilization rate (billable hours divided by available hours on the board) this month?
Firm-wide average utilization this month (1–19 Jul) is 75.3%. Highest and lowest individual rates:
| User | Utilization |
|---|---|
| Highest | |
| William Barrett | 93.4% |
| Lucas Grant | 91.6% |
| Benjamin Watts | 90.1% |
| Lowest | |
| Amanda Green | 58.0% |
| Henry Mitchell | 58.5% |
| Sophia Reed | 58.5% |
12s
Which team has the best utilization rate this quarter?
Finance has the best utilization this quarter (1–19 Jul): 77.5% (billable hours ÷ available board hours), ahead of Dispute at 75.2% and Employment at 72.8%.
19s
Did anyone log billable time on days they were marked out all day?
Yes — this month there are 19 instances across 18 users of someone billing time on a day where the board shows no working status at all (marked OUT all day, or no board record). George Harris did this on 2 separate days; the rest occurred once each.
4s
On days when availability was low firm-wide, did billable output drop proportionally?
Yes, closely. Using June as an example, weekends collapse together:
| Day | Availability | Billable hours |
|---|---|---|
| Sat 14 Jun | 0 h | 2.5 h |
| Sat 20 Jun | 4.8 h | 10.2 h |
| Sat 27 Jun | 0 h | 4.1 h |
| Typical weekday (e.g. 18 Jun) | 429.7 h | 326.4 h |
Both metrics fall to near-zero together on non-business days — availability and billable output move in lockstep.
25s
Which users' timesheet hours don't line up with their status history this week — any anomalies I should review?
5 users logged billable time this week (13–19 Jul) on a day with no matching work status on the board: Anna Whitfield, Ava Russell, Benjamin Watts, John Smith, and Oliver Hampton. Each has exactly one such day — worth a quick check that their board status was just forgotten rather than time being misdated.
10s
Which teams are overloaded (high hours per available person) and which have spare capacity right now?
No team looks alarmingly overloaded, but Finance is running the tightest: 77.5% utilization and about 65.6 billed hours per person this quarter, the highest per-person load of the three. Employment has the most spare capacity, at 72.8% utilization (~60.2 h/person). Dispute sits in between (75.2%, ~60.7 h/person). The gaps between teams are modest.
8s
Give me a Monday-morning summary: who's in today, what got logged last week and any anomalies worth reviewing.
Who's in today: nobody is currently marked IN — all 65 users show OUT, except 3 on VACATION (Samantha Anderson, Peter Wilson, Isabella Ward).
Last week (6–12 Jul): 1,595.0 billable hours logged across 65 users and 1,408 tasks.
Anomalies worth reviewing: 3 users (Isabella Ward, Peter Wilson, Samantha Anderson) logged no time at all over the last 3 business days; 5 users this week billed time on a day with no matching board status (Anna Whitfield, Ava Russell, Benjamin Watts, John Smith, Oliver Hampton).
15s
Prepare a month-end report for client Morrison Engineering LLC: total hours, breakdown by project and by user, compared to the previous month.
Morrison Engineering LLC — month-to-date report (1–19 Jul, compared to June)
| Metric | This month (to date) | June | Change |
|---|---|---|---|
| Total hours | 70.2 h | 97.3 h | -27.9% raw, but +20.2% on a per-day basis (July isn't finished yet) |
By project: all hours sit on "Construction Contract Dispute (Harborline Project)" — the client's only active matter. A second project, "Employment Dispute with Daniel Carter," was just opened on 17 Jul and has no hours logged yet.
By user (top contributors this month):
| User | Hours |
|---|---|
| Samantha Anderson | 3.6 h |
| John Smith | 3.2 h |
| Diana Mercer | 3.1 h |
| Natalie Brooks | 2.9 h |
| Emma Coleman | 2.5 h |
46 people in total logged at least some time to this client this month, each in small increments — typical for a broadly-staffed dispute matter.
18s
Back to top ↑
7. After-hours & late-night work
Has anyone been working late nights this month? Who does it most?
Yes. Looking at billable entries touching 20:00–24:00 this month (1–19 Jul), the heaviest late-night billers are:
| User | Late-night hours billed |
|---|---|
| Ivy Sinclair | 3.7 h |
| John Smith | 3.1 h |
| Jack Morrison | 2.9 h |
| Emily Bryant | 2.7 h |
| Chloe Robinson | 2.6 h |
15s
For the people logging billable time late at night this month, does their in/out board history show them as working at those hours?
Yes, consistently. For every one of the late-night billers above (and every user in the firm this month), their in/out board shows a work status covering that same 20:00–24:00 window — in fact the board typically shows slightly more late-night working time than what got billed (e.g. Chloe Robinson billed 2.6 h late but her board shows 5.7 h of late work-status time). There are zero cases this month of someone billing late-night hours with no matching board record.
4s
Back to top ↑
8. Planned time & scheduling
What's scheduled for next week. Who's overbooked and who has room to take on more?
Very little is currently scheduled for next week (20–26 Jul) — only 6 people have any planned entries at all, and none of them are heavily booked:
| User | Planned hours |
|---|---|
| Chris Moore | 4.1 h |
| Hannah Wallace | 2.5 h |
| Jessica Miller | 2.5 h |
| Brooke Norman | 2.5 h |
| Ryan Cooper | 2.4 h |
| Olivia Bennett | 1.5 h |
Nobody is overbooked. The other 59 users have no planned entries for next week at all — either they have full room to take on more work, or the schedule for that week simply hasn't been planned yet.
12s
Back to top ↑
9. Work type, tags & unattributed time
What's the type of work for client Charlton Milling AB this year?
Breakdown of billable work type for Charlton Milling AB in 2026:
| Work type | Hours |
|---|---|
| Preparation of memorandum | 29.6 h |
| Preparation of amendments to agreement | 26.5 h |
| Preparation of pleading | 23.9 h |
| Legal analysis | 23.9 h |
| Preparation of agreement | 23.0 h |
| Meetings | 22.9 h |
| Preparation of email | 17.1 h |
| Telephone calls | 14.1 h |
| Review of document | 12.3 h |
| Court hearing | 1.5 h |
8s
How many hours are sitting in red-tagged (write-off / do-not-bill) entries this month, and for which clients?
85.9 hours are red-tagged this month (1–19 Jul), spread across 25 clients. Top 5:
| Client | Red-tagged hours |
|---|---|
| Arpetel Logistics AS | 9.2 h |
| Valtratel AS | 6.3 h |
| Telavia Aeronautical Engineering AB | 6.2 h |
| Fractal Telecommunication LLC | 5.8 h |
| Norton Systems AB | 5.7 h |
13s
How much logged time this month isn't attached to any client or project, and who has the most unattributed hours?
None — every one of the 4,000.7 billable hours logged this month (1–19 Jul) is attached to a client. There's no unattributed time to report right now.
18s
Back to top ↑
10. Data hygiene & anomalies
Who logs their time days after the fact instead of same-day?
Most people log same-day, but a handful consistently log with a lag. Ranked by how rarely they log same-day (13 Jun – 19 Jul):
| User | Median lag | Same-day share | Worst lag |
|---|---|---|---|
| Spencer Howell | 2 days | 18.7% | 5 days |
| Zoe Patterson | 2 days | 20.9% | 4 days |
| Daniel Carter | 2 days | 21.2% | 4 days |
| Chris Moore | 1 day | 21.1% | 3 days |
| John Smith | 1 day | 31.4% | 3 days |
The large majority of the firm logs same-day (100% same-day share for most users).
20s
Does anyone have overlapping time entries this month (double-billing?
No — a full scan of this month's entries (1–19 Jul) found zero user-days with overlapping time entries. No double-billing risk detected.
10s
Whose in/out board status hasn't changed in over a week?
Two users: Samantha Anderson and Isabella Ward. Both set their status to VACATION on 11 July and it hasn't changed since — expected, since they're both currently away (back 29 Jul and 22 Jul respectively).
8s
Back to top ↑
11. Vacation, coverage & workload balance
Who's on vacation right now and when is each person back?
| User | Back |
|---|---|
| Isabella Ward | 22 Jul |
| Peter Wilson | 27 Jul |
| Samantha Anderson | 29 Jul |
4s
Which weekday is our business-hours coverage thinnest — should we stagger anything?
Wednesday, clearly. Comparing business-hours (9–17) availability across 5 occurrences of each weekday since 13 June:
| Weekday | Availability |
|---|---|
| Thursday | 1,703.9 h |
| Friday | 1,682.3 h |
| Tuesday | 1,659.2 h |
| Monday | 1,643.7 h |
| Wednesday | 1,504.5 h |
Wednesday runs about 9–12% thinner than every other weekday (and billable output is lowest that day too, per the productivity data) — worth staggering meetings or coverage rotations if Wednesday client responsiveness has been an issue.
18s
Is after-hours and weekend work concentrated in the same people (burnout risk)?
Only partly. There's real overlap for a few individuals — John Smith is in the top 5 for both weekend work and late-night work, and Rachel Powell, Daniel Carter and Anna Whitfield show up on both lists too — so those four are worth a wellbeing check-in. But the two lists are mostly made up of different people (e.g. weekend work is led by Zoe Patterson, Robin Hawkins and Isabella Ward, while late nights are led by Ivy Sinclair, Jack Morrison and Emily Bryant), so after-hours strain looks spread across a broad group rather than concentrated in one burned-out clique.
21s
Back to top ↑
12. Write operations
Log 2 hours for me yesterday on project Vortexa re settlement negotiations.
Done — logged 2 hours for you (John Smith) on Friday 18 July, 14:00–16:00, against "Settlement Negotiations with Vortexa Industries," tagged as a meeting entry with the note "Settlement negotiations."
13s
Mark Andrew as out sick today with a note that he is expected back Monday.
Done — Andrew Bradley is now marked OUT for today with the note: "Out sick today, expected back Monday (20 Jul)."
13s
Create a new client "Test Client".
Done — created a new client named "Test Client."
34s
Back to top ↑
13. Self-service
What did I work on last week?
Last week (6–12 Jul) you touched 18 different matters, totaling 21.9 hours. Top ones:
| Project | Client | Hours |
|---|---|---|
| Regulatory Compliance Review (Financial Services) | Altel Manufacturing and Retail AB | 2.7 h |
| Dispute with Vandelore Holdings LLC 102 | Vircom AG | 2.0 h |
| Termination of Lease Agreement No 12-42 (Idelor AB, Almena Center) | Nautica AS | 1.7 h |
| Restructuring of Cavendish Group | Finelia OY | 1.7 h |
| Public Procurement No 28545218 – Expansion of Trolleby Bridge 100 | Telavia Aeronautical Engineering AB | 1.6 h |
The rest of the week was spread thinly across 13 other matters (0.5–1.5 h each).
10s
How many hours did I log last week in total?
You logged 21.9 hours last week (6–12 Jul), across 20 tasks.
3s
Back to top ↑