Get your key at console.anthropic.com ā API Keys. It stays in memory only and is cleared when you close the browser.
In your Google Sheet: Extensions ā Apps Script ā paste the script below ā Deploy ā New deployment ā Web app ā Anyone ā Deploy ā copy the URL here.
function doGet() {
var ss = SpreadsheetApp.openById('1KFLOPYWk6_XdSYBut5Qr7EnxwjL3UIiNxjLQ9uBUZpg');
var sheet = ss.getSheetByName('HS Paste');
var data = sheet.getDataRange().getValues();
var out = ContentService.createTextOutput(JSON.stringify(data));
out.setMimeType(ContentService.MimeType.JSON);
return out;
}
Standard weekly availability. Max days defaults to 5 for everyone except Nicolas Figueras (6 days). Use the time-off PDF on Setup for one-week exceptions.
Team availability & work limits
-
Max days / week
Horace will not schedule beyond this.
5
days
Nicolas Figueras - only person set to 6 days
Max hours / week
40 = full-time. Lower for part-time.
40
hrs
Min hours / week
0 = no minimum. Set to protect FT status.
0
hrs
Daily availability (Mon-Sat)
Recent changes
No changes yet.
Manage your roster, add new hires, and set cross-training. Cross-trained people are only pulled into a secondary role when their primary role slot is already covered for that day.
Add new team member
After adding, go to Availability to set their weekly schedule.
Cross-training
Cross-trained people work their primary job first. Horace only pulls them into a secondary role if their primary slot is filled and the secondary slot is still short.
Currently cross-trained
No cross-training set up yet.
Add cross-training
Full roster
-
Primary house: -
Updates the name everywhere in Horace including availability, schedule, and exports.
Primary house = their main scheduling pool. Additional houses = eligible for those shifts too. Inactive = stays in DB but Horace won't schedule them.
Shift Leader roles
FOH Shift Leader
Can this person lead FOH shifts?
BOH Shift Leader
Can this person lead BOH shifts?
Changes take effect on next Generate run. To change availability, go to the Availability tab.
Time off entries override standing availability for specific dates only. They do not change the Availability tab. Horace reads these automatically when generating the schedule for the matching week.
Add time off
Saved
View & manage time off
No time off entries yet.
-
No time off for this person.
Truck/Dish = 1 person (Nick Mayes or Luke Sanders) 5:15a-2p. 7am BOH = BOH Open. The constraint filler reads these rules directly and fills every slot in order.
Period
Time
Description
Role
Target
x
Saved
How do you want to build this week's schedule?
● Option 1 ā Let Horace generate it
Horace fills the week automatically using availability, staffing rules, and your notes. Deterministic or AI-polished.
↧ Option 2 ā Import your lineup
Upload photos of your handwritten lineup or paste from your Google Sheet. Horace reads names and times and populates the schedule.
Import lineup
Upload photos of your lineup sheets (handwritten or printed) ā Horace will read the names and times using vision AI.
Or paste the raw text from your Google Sheet's "Paste [Day] Here" columns below.
📋 Pull from Google Sheet
Reads your "Schedule and Lineups" sheet directly ā the same data you print the lineup from. Click anytime it's been updated.
Upload lineup photos
Click or drag photos or PDFs here JPEG, PNG, PDF ā one per day or all on one sheet
Or paste lineup text
Paste the Name/Shift/Role columns from your Google Sheet. Format: one entry per line ā Name, 5:15a - 2:00p, Role, Day ā or just paste the raw cells and Horace will parse it.
Generation mode
Fast, offline. Fills every slot deterministically. No API call.
Horace interpreted your notes
Review these overrides before running. They apply to this week only and do not change saved availability.
Constraint filler ready
Standby
Ready. Click Run Horace to generate this week's schedule.
Filling order:
1. Locked assignments (Ashley, Nick/Luke)
1.5. Shift Leaders (FOH AM, FOH PM, BOH AM, BOH PM)
2. BOH closes (all til 10:30p)
3. FOH closes by end-time
4. Floor windows: 5-8p, 4-5p, 2-4p
5. FOH day shifts
6. BOH day shifts
7. OLD drivers
Horace found 0 unfilled slots
The constraint filler couldn't place everyone. Ask Horace AI to suggest who should fill each gap ā it will explain its reasoning and let you accept or reject each suggestion individually.
-
Total shifts
-
Staff scheduled
-
Est. hours
-
Rule gaps
Run Horace first.
FOH
Day 5am-2pm0
Night 2pm-10pm0
BOH
Day 5am-2pm0
Night 2pm-10:30pm0
OLD / Delivery
Day 6am-2pm0
Night 5pm-8:30pm0
Name
Mon
Tue
Wed
Thu
Fri
Sat
Blue=FOH Green=BOH Amber=OLD Click any cell to edit
Week notes & one-time overrides
Note anything that happened this week ā shift changes, no-shows, one-time overrides. Horace reads these if you re-run generation.