Skip to content
Workflow · Finance close · Opening soon

Volunteer hours report

Export your sign-in sheet from Excel, then upload it to Mammoth. It totals each volunteer's hours by program for the latest quarter in the sheet, and values that time at 30 dollars an hour.

Early access opens shortly. Check back soon.

Someone typed

“total each volunteer's hours by program for the quarter from our sign-in sheet, and value that time at 30 dollars an hour”

The agent read it as

Total each volunteer's hours by program for the quarter from Volunteer sign-in sheet, and value that time at 30 dollars an hour, using the latest quarter in the sheet.

What the agent built

1 step, each one an ordinary Mammoth step you can open and change.

  1. File
    Volunteer sign-in sheet
    CSV export · 45 rows
  2. Step
    Total hours and value
    Step 1
  3. Result
    Volunteer Program Hours
    44 rows
  4. Schedule
    Runs when you say
    Proposed

Checked on the sample files: every step ran, 44 rows came out.

What you get back

The result of that run, the rows to look at first.

Volunteer Program HoursSample data44 rows
VolunteerProgramHoursValue ($)
Ava ChenCommunity Garden4120
Ava ChenFood Pantry4120
Ava ChenFront Desk4120
Ava ChenTutoring4120
Caleb TurnerCommunity Garden4.50135
Caleb TurnerFood Pantry4120
Caleb TurnerTutoring3.50105
Ethan BrooksCommunity Garden4120
Ethan BrooksFood Pantry4.50135
Ethan BrooksFront Desk4120
Ethan BrooksTutoring390
Hannah SinghFood Pantry4120
44 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How it works

How to use the Volunteer Program Hours workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Volunteer Program Hours: questions

How do you track volunteer hours by program from an Excel export?
Export your sign-in sheet from Excel, then upload it to Mammoth. It totals each volunteer's hours by program for the latest quarter in the sheet, and values that time at 30 dollars an hour. Rows that do not match the rules stay out of the totals until you change the rules or fix the source file.
Which export should you use?
Use the Excel file that contains the sign-in sheet rows you want to report on. Make sure it has the columns needed for volunteer, program, date, and hours.
What happens to rows that do not match?
Rows that do not fit the rules are not included in the result. You can review them, then update the source file or the rules so they match next time.
How do you change the rules?
Edit the rules in words, then run the workflow again. You can change the quarter logic, the grouping by program, or the hourly value if your report needs a different setup.

Get early access to this workflow

It will open already built and checked on the sample files. Swap in your own exports and see your result.

Early access opens shortly. Check back soon.

Workflows like this

Consolidate entities, compare budget to actual, build a trial balance, review month-on-month moves and work out commission.

All finance close templates →