Samples & Products
Screenshots don’t do them justice!
The best spreadsheets are ones that are part of an ecosystem, working together to auto-magically enhance each other for the better. This dynamic relationship is best experienced in action, either live or through video. Check out the video below to see a system in motion!
Learn About My Products
Camp Activity Schedules
- Easily see double-booking errors
- Use information from master schedule to automatically create group and activity schedules
- Drop-down menus help ensure you schedule the correct activities for a given age group
- Counting features allow you to easily understand how many times each group has a given activity
- Ability to change information for each session as needed
- Color-coded activities help to visually organize the schedule
Camp Elective Schedules
- Assign activities based on campers’ ranking
- Counting features let you know how many campers have gotten their first choice, so you can ensure camper happiness
- Schedule the right staff for the right activity. The system gives you list of staff who can be assigned a given activity so, for example, you don’t accidentally assign a staff to be at the waterfront if they are not a lifeguard.
- Schedule the right number of staff. Counting features let you know how many staff you need based on camper elective assignments. You’ll know when you have scheduled enough staff to meet demand.
- Information presented how you want it. Give the right information to the right people in the right format! You’ll get a list of who should be where for a variety of different audiences.
KPIs (Key Performance Indicators)
Understand your program(s) better than you ever have before! You send me your data. I’ll chug through the numbers and send you a nifty PDF of the metrics you care about most.
Operations and Logistics Support
Information is only as good as the people who have the same information! These lists will magically put the right information to the right list so you can easily print and support your team in doing their job, Get everybody on the same page so your team can work together and not against each other!
Some examples include:
- Lunch Lists that tell counselors which person needs which lunch and tell the kitchen which allergies to be aware of. These are easily separated by group so you can print and hand out.
- Dismissal lists that tell group leaders who is taking the bus or staying for after-school/after-camp. These lists simultaneously create attendance sheets so everyone is operating on the same information. Teamwork makes the dreamwork!
Attendance
A network of attendance sheets work together to instantly inform administration of who is absent. Can be used for any number of activities! Staff use a tablet/phone/computer using a Google Sheet. The system archives every night so you have a record of the information and your staff can use the same link all season.
Dashboards
Data is good, but information is better. Let’s turn your data into information by creating some nifty charts and show off some metrics! The opportunities are endless!
Mailing Lists (especially for weddings, alumni events, and marketing campaigns)
Your organization has a rich and unique history and is a beautiful compilation of many people who have served the same way you do. And, this often means you have a folder of a hodgepodge of various mailing lists.
Take the stress off your plate and let a spreadsheet professional handle the details.
- Organized information
- Data integrity
- Avoid duplicated entries
Payroll
Reduce time and increase accuracy! No matter how your staff clock in/out or not, you most likely find yourself checking the staff schedule to make sure everyone gets paid the right amount. Add in a few absences and sick days and you’ll find that processing payroll is a labor of details. Work with me to simplify the details. Improving your payroll system is one of the best ways to reduce stress in your job.
Automatically calculate wage based on necessary factors. Reports are automatically generated to show total payroll per week, per program, and per person.
Fun Fact: A client once told me that my improvements to her payroll system saved her marriage! She was able to to spend more quality time with her partner after we cut her payroll processing down by 50%.
Financial Insights
Your good at what you do! And sometimes you could use support with the financial aspect of your job. In collaboration with my bookkeeping friends at Camp Ledger, we can help you be be informed and empowered when it comes to your finances.
Switching Databases
If you’re switching from one database to a different database, you likely need to dump all the data from one and put it in a particular format to be accepted by the new database. I’m here to help!
- Keep all the info you can keep
- Organized to fit
Cross-Department Communication
The same, but different. Your staff want information in one way, and the finance department wants the same information but in a different way, and the facilities crew needs yet a different version.
- Give everyone the info they want
- Show it the way they want to see it
- Automated!
Dynamic scheduling for camps and schools! This auto-magic scheduling infrastructure will have you giddy with excitement!