ASKA
Not enough ratings
Aska Job & Schedule Planner
By Kitsu Kat
Plan your village like a pro! This guide introduces a powerful Google Sheets tool to help you assign jobs, track perks and proficiency, and generate efficient day/night schedules for your settlers in Aska. Perfect for players who want 24/7 village coverage, staggered shifts, and quick decision-making without flipping through in-game menus. Includes job/perk matching, shift planner, auto filters, and more!
   
Award
Favorite
Favorited
Unfavorite
Aska Job & Schedule Planner (Google Sheets)
Master your village with custom job rankings, shift schedules, and perk planning.


📘 What Is This?
The Aska Job & Schedule Planner is a free Google Sheets tool that helps you:
  • Assign jobs based on perks and skill proficiency
  • Track who’s already working
  • Create custom rotating shift schedules with sleep/leisure/work cycles
  • Avoid downtime and optimize large settlements
⚙️ Features
  • Job Ranking: See the best jobs for any settler
  • Settler Ranking by Job: Flip the view to see who fits a job best
  • Job Assignment Tracker: Automatically removes placed settlers from lists
  • Schedule Generator: Generate 1–3 staggered shift pairs
  • Mid-Work Breaks Option: Split leisure time before, during, and after work
  • Live Filters & Color Coding: Helps you stay focused and organized
✋ Who Is This For?
This tool is perfect if you:
  • Love efficiency and optimization
  • Want to run a 24/7 settlement with zero gaps
  • Prefer managing settlers from a second screen
  • Get overwhelmed with in-game job tracking
✅ How To Use It
Step 1: Make a Copy
👉 ASKA Job & Schedule Planner Sheet[docs.google.com]
→ Click File > Make a Copy

Step 2: Fill Out Settler Info
Go to the Settler Input tab:
  • Add settler names
  • Select their perks
  • Set proficiency levels (1–3)

Step 3: Check Job Matches
Open the Job Ranking tab to pick a settler and see best-matching jobs.
Or, use Settler Ranking by Job to pick a job and see who fits it best.

Step 4: Assign & Track Jobs
Use the Job Assignments tab to assign jobs and auto-filter filled roles.

Step 5: Build a Schedule
  • Visit the Schedule Generator tab:
  • Set Sleep, Work, and Leisure hours
  • Toggle Mid-Work Breaks to add a third leisure slot during work
  • Go to Aska Tools > Generate Shifts
    Note: If it your first time running it needs to authorize running the script. After that click it again and the script should run.
  • Supports up to 3 shift pairs (Day/Night) with auto-staggering
🎨 Tab Color Key
Color
Sheet
🔵 Indigo
Info & Instructions
🟦 Bright Blue
Schedule Generator
🟨 Yellow
Settler Input
🟧 Orange
Jobs Database
🟪 Purple
Job Assignments
🟩 Lime Green
Job Ranking
🟥 Red
Settler Ranking by Job
🔗 Credits
Created by Kitsu Kat
Explore more tools and content:
https://beacons.ai/kitsukat
🗒️ Changelog
Date
Change
2025-05-31
1.0.1 Fixed script issues with clearing out settler names on Settler Input. Please redownload.
2025-05-24
1.0.0 Initial version uploaded

🗂️ Current Version: v1.0.1
Last updated: 2025-05-31
7 Comments
FireShark 11 hours ago 
In my case either im loged in or not it doesnt show me
SinKlare 5 Jun @ 12:10am 
I'm not sure if it's just me, but the button (Aska Tools) only appears if I'm logged onto a google account. Both on the original view-only and my copy of it.
I'm not sure if fiddling with my copy borked it but "Settler Ranking by Job" does not work beyond 50 rows (tried using the Aska Tools and/or basic add/drag rows) and in the original version, it starts with Kjell rather than Jensen. I don't use sheet/excel too often for work but I know how easily it borks up.
But! Having this is super helpful to any degree towards organizing villagers and I'm super thankful *something* exists. Much easier than on my own trying to keep them organized/happy. I don't know how to build one but a warehouse planner would be great addition. Hopefully Aska team adds/works on something more user friendly in management.
Blackthorne 3 Jun @ 3:54am 
I dont find this button too
FireShark 1 Jun @ 1:27am 
Ok either im stupid or i dont know where it is xd because i dont see that Aska Tools
Kitsu Kat  [author] 31 May @ 10:43am 
Sorry I forgot to change the wording on the button for the scripts, It's called Aska Tools next to the Help button at the top. You also need to run the script the first time and give it authorization before it can run. After you've approved it can do it's thing.
FloorTank 27 May @ 10:49am 
Very nice but in 1.0 the clear settler input isnt working saying that the script is not found
FireShark 25 May @ 6:12pm 
Cool tool but i cannot see the button to generate schedules