/instructor-schedule
---
The **`/instructor-schedule`** skill is now saved! Here's how to use it:
### Usage
Type `/instructor-schedule` and specify:
1. **Which tab** has the course data (e.g., "Fall 2025", "Spring 2026")
2. **Which instructors** to include (any number of names)
### Examples
> `/instructor-schedule` Fall 2025 for Gail Ellison, J Marshall Pittman, Russell Smith
> `/instructor-schedule` Spring 2026 for Russell Smith and Kevin Taylor
### What it does
- Reads the transposed course data from the specified tab
- Filters to only the instructors you name
- Skips web-only courses (no physical schedule)
- Sorts by day (Mon→Sat), then time, then instructor
- Creates a new **"[Term] Schedules"** sheet with:
- Color-coded rows per instructor (up to 6 distinct colors)
- Day groupings with borders
- Separate Enrolled & Capacity columns
- Summary table with section counts and enrollment totals
It pairs with your `/transpose-courses` skill — paste raw catalog data, transpose it, then build schedules from it each semester.
---
> Please build a weekly schedule table for three full-time instructors (Gail Ellison, J Marshall Pittman, Russell Smith) based on Spring 2025 course data. This should list each day, each time, and the course with campus, room, plus enrolled and capacity.
Let me first read the Spring 2025 data to get all the course details for those three instructors.
Read Spring 2025 transposed data
Read Spring 2025 transposed data
Parameters:
```json
{
"sheetName": "Spring 2025",
"range": "A1:I53"
}
```
Result
```json
{
"success": true,
"csv": "Course,Status,Campus,Location & Schedule,Instructors,Instructional Format,Delivery Mode,Enrolled,Capacity\nARTV 1303-001 - Basic Animation,Open,Frisco Campus,Frisco IT104 | Thursday | 6:00 PM - 11:00 PM,Esperanza Jacobs,Combination,Hybrid,16,20\nARTV 1303-002 - Basic Animation,Waitlist,Frisco Campus,Frisco IT104 | Monday | 9:00 AM - 2:50 PM,Russell Smith,Combination,Hybrid,20,20\nARTV 1303-004 - Basic Animation,Open,Wylie Campus,Wylie CC222 | Wednesday | 9:00 AM - 2:50 PM,Russell Smith,Combination,Hybrid,9,20\nARTV 1341-001 - 3-D Animation I,Waitlist,Frisco Campus,Frisco IT102 | Wednesday | 9:00 AM - 2:50 PM,Gail Ellison,Combination,Hybrid,18,18\nARTV 1341-002 - 3-D Animation I,Open,Frisco Campus,Frisco IT102 | Tuesday | 6:00 PM - 11:00 PM,Esperanza Jacobs,Combination,Hybrid,7,18\nARTV 1341-003 - 3-D Animation I,Open,Wylie Campus,Wylie CC222 | Thursday | 6:00 PM - 11:00 PM,Christine Smith,Combination,Hybrid,8,20\nARTV 1345-001 - 3-D Model/Render I,Open,Frisco Campus,Frisco IT102 | Thursday | 9:00 AM - 2:50 PM,Gail Ellison,Combination,Hybrid,15,18\nARTV 1345-002 - 3-D Model/Render I,Open,Frisco Campus,Frisco IT102 | Monday | 6:00 PM - 11:00 PM,Nicole Wingfield Miller,Combination,Hybrid,11,18\nARTV 1345-003 - 3-D Model/Render I,Open,Wylie Campus,Wylie CC211 | Tuesday | 9:00 AM - 2:50 PM,Russell Smith,Combination,Hybrid,10,20\nARTV 1345-004 - 3-D Model/Render I,Open,Frisco Campus,Frisco IT102 | Friday | 6:00 PM - 11:00 PM,Steven Engel Craven,Combination,Hybrid,12,18\nARTV 1345-005 - 3-D Model/Render I,Open,Frisco Campus,Frisco IT102 | Saturday | 9:00 AM - 2:50 PM,Micheal Eudy,Combination,Hybrid,5,18\nARTV 1351-001 - Digital Video,Open,Frisco Campus,Frisco IT103 | Tuesday | 9:00 AM - 2:50 PM,Danielle Thompson,Combination,Hybrid,15,18\nARTV 1351-002 - Digital Video,Open,Frisco Campus,Frisco IT103 | Wednesday | 6:00 PM - 11:00 PM,Shadiah Jawad,Combination,Hybrid,16,18\nARTV 1351-003 - Digital Video,Open,Frisco Campus,Frisco IT103 | Friday | 6:00 PM - 11:00 PM,Michael Hennesy,Combination,Hybrid,15,18\nARTV 1351-004 - Digital Video,Open,Frisco Campus,Frisco IT103 | Saturday | 1:30 PM - 6:30 PM,Lee Shapiro,Combination,Hybrid,16,18\nARTV 1371-001 - Storybrd/Concept Dev,Open,Plano Campus,Plano K122 | Monday | 6:00 PM - 11:00 PM,John Schuh,Combination,Hybrid,15,18\nARTV 1371-002 - Storybrd/Concept Dev,Open,Frisco Campus,Frisco IT104 | Tuesday | 9:00 AM - 2:50 PM,Gordon Smith,Combination,Hybrid,18,20\nARTV 1371-003 - Storybrd/Concept Dev,Open,Frisco Campus,Frisco IT104 | Wednesday | 9:00 AM - 2:50 PM,Joe Eisma,Combination,Hybrid,16,20\nARTV 1371-004 - Storybrd/Concept Dev,Open,(empty),(empty),Lee Shapiro,Combination,Web,20,25\nARTV 1371-005 - Storybrd/Concept Dev,Open,Frisco Campus,Frisco IT104 | Tuesday | 6:00 PM - 11:00 PM,Howard Goldthwaite,Combination,Hybrid,11,20\nARTV 1371-006 - Storybrd/Concept Dev,Open,Wylie Campus,Wylie CC222 | Friday | 9:00 AM - 2:50 PM,Russell Smith,Combination,Hybrid,12,14\nARTV 2320-001 - Team Prog Prod I,Open,Frisco Campus,Frisco IT103 | Friday | 9:00 AM - 2:50 PM,Mark Kaufmann,Combination,Hybrid,16,18\nARTV 2335-001 - Portfolio Develop/Animation,Waitlist,Wylie Campus,Wylie CC222 | Friday | 9:00 AM - 2:50 PM,Russell Smith,Combination,Hybrid,6,6\nARTV 2335-002 - Portfolio Develop/Animation,Waitlist,Frisco Campus,Frisco IT112 | Friday | 9:00 AM - 2:50 PM,J Marshall Pittman,Combination,Hybrid,21,20\nARTV 2345-001 - 3-D Modeling and Rendering II,Open,Frisco Campus,Frisco IT102 | Tuesday | 9:00 AM - 2:50 PM,Gail Ellison,Combination,Hybrid,10,18\nARTV 2345-002 - 3-D Modeling and Rendering II,Open,Frisco Campus,Frisco IT102 | Monday | 9:00 AM - 2:50 PM,Gail Ellison,Combination,Hybrid,11,18\nARTV 2345-003 - 3-D Modeling and Rendering II,Open,Wylie Campus,Wylie CC222 | Tuesday | 6:00 PM - 11:00 PM,Kevin Taylor,Combination,Hybrid,7,20\nARTV 2351-001 - 3-D Animation II,Open,Frisco Campus,Frisco IT112 | Wednesday | 6:00 PM - 11:00 PM,Aaron Werntz,Combination,Hybrid,19,20\nARTV 2351-002 - 3-D Animation II,Open,Frisco Campus,Frisco IT112 | Friday | 6:00 PM - 11:00 PM,Stephen Steinbach,Combination,Hybrid,14,20\nARTV 2371-001 - Adv Skill Dev/Anim & Games,Open,Frisco Campus,Frisco IT112 | Tuesday | 9:00 AM - 2:50 PM,J Marshall Pittman,Combination,Hybrid,2,4\nFLMC 1301-001 - History of Animation Technique,Open,Frisco Campus,Frisco IT104 | Friday | 9:00 AM - 2:50 PM,Gordon Smith,Combination,Hybrid,14,20\nFLMC 1301-003 - History of Animation Technique,Open,(empty),(empty),Christine Smith,Combination,Web,20,25\nFLMC 1331-001 - Video Graph & Visual Effect I,Open,Plano Campus,Plano K122 | Thursday | 6:00 PM - 11:00 PM,Drew Daleo,Combination,Hybrid,16,18\nFLMC 1331-002 - Video Graph & Visual Effect I,Open,Frisco Campus,Frisco IT112 | Wednesday | 9:00 AM - 11:30 AM,Nicole Wingfield Miller,Combination,Hybrid,18,20\nFLMC 1331-003 - Video Graph & Visual Effect I,Open,Frisco Campus,Frisco IT112 | Tuesday | 6:00 PM - 11:00 PM,Ethan Wilder,Combination,Hybrid,19,20\nFLMC 1331-004 - Video Graph & Visual Effect I,Open,(empty),(empty),Ethan Wilder,Combination,Web,23,25\nFLMC 1331-005 - Video Graph & Visual Effect I,Open,Wylie Campus,Wylie CC211 | Wednesday | 9:00 AM - 2:50 PM,Drew Daleo,Combination,Hybrid,13,20\nFLMC 2330-002 - Audio Post Production,Open,Frisco Campus,Frisco IT103 | Tuesday | 6:00 PM - 11:00 PM,Aaron Kinnard,Combination,Hybrid,12,18\nFLMC 2330-003 - Audio Post Production,Open,Frisco Campus,Frisco IT103 | Thursday | 6:00 PM - 11:00 PM,Aaron Kinnard,Combination,Hybrid,11,18\nFLMC 2331-001 - Video Graph & Visual Effect II,Open,Frisco Campus,Frisco IT112 | Wednesday | 12:20 PM - 2:50 PM,J Marshall Pittman,Combination,Hybrid,14,20\nFLMC 2333-002 - Cinematography,Open,Frisco Campus,Frisco IT104 | Friday | 6:30 PM - 10:00 PM,Mark Kaufmann,Combination,Hybrid,13,20\nFLMC 2334-001 - Directing for Film or Video,Open,Frisco Campus,Frisco IT116 | Monday | 6:00 PM - 11:00 PM,Lee Shapiro,Combination,Hybrid,12,18\nFLMC 2334-002 - Directing for Film or Video,Open,Frisco Campus,Frisco IT116 | Tuesday | 6:00 PM - 11:00 PM,Arthur Muhammad,Combination,Hybrid,12,18\nFLMC 2336-001 - Production Develop - Producing,Open,Frisco Campus,Frisco H121 | Monday | 6:00 PM - 11:00 PM,Elizabeth Ekstrand,Combination,Hybrid,21,24\nFLMC 2380-001 - CoEd Cinema & Film/Vid Prod,Waitlist,(empty),(empty),Tonya McMillion,Combination,Blended,1,1\nGAME 1303-001 - Intro to Game Design & Develop,Open,Frisco Campus,Frisco IT112 | Tuesday | 9:00 AM - 2:50 PM,J Marshall Pittman,Combination,Hybrid,14,16\nGAME 1303-002 - Intro to Game Design & Develop,Open,Frisco Campus,Frisco IT112 | Monday | 6:00 PM - 11:00 PM,Adam Villarreal,Combination,Hybrid,17,20\nGAME 1303-003 - Intro to Game Design & Develop,Open,Wylie Campus,Wylie CC222 | Saturday | 9:00 AM - 2:30 PM,Adam Villarreal,Combination,Hybrid,13,24\nGAME 2309-001 - Video Game Art II,Open,Frisco Campus,Frisco IT102 | Friday | 9:00 AM - 2:50 PM,Gail Ellison,Combination,Hybrid,6,18\nGAME 2325-001 - 3-D Anim II-Character Set-Up,Waitlist,Frisco Campus,Frisco IT112 | Thursday | 6:00 PM - 11:00 PM,J Marshall Pittman,Combination,Hybrid,20,20\nGAME 2325-002 - 3-D Anim II-Character Set-Up,Open,Wylie Campus,Wylie CC211 | Monday | 9:00 AM - 2:50 PM,Stephen Steinbach,Combination,Hybrid,19,20\nGAME 2359-001 - Game & Simulation Group Projec,Open,Frisco Campus,Frisco IT112 | Thursday | 9:00 AM - 2:50 PM,J Marshall Pittman,Combination,Hybrid,6,20",
"rowCount": 52,
"columnCount": 9,
"hasMore": false,
"sheetName": "Spring 2025"
}
```
Now let me parse the schedule data for the three instructors and build the weekly schedule.
Good — I can see the full picture. Note that Pittman teaches two concurrent sections Tuesday morning, and Russell Smith has two Friday morning sections in the same room. Now let me build this as a clean schedule table on a new sheet.
Build instructor weekly schedule table
Build instructor weekly schedule table
Parameters:
```json
{
"code": "..."
}
```
Code:
```javascript
// Create a new sheet for the schedule
const newSheet = context.workbook.worksheets.add("Instructor Schedules");
newSheet.activate();
await context.sync();
// Build the schedule layout
// Title
const titleRange = newSheet.getRange("A1:H1");
titleRange.merge(true);
titleRange.values = [["Spring 2025 — Weekly Schedule: Gail Ellison, J Marshall Pittman, Russell Smith"]];
titleRange.format.font.bold = true;
titleRange.format.font.size = 14;
titleRange.format.font.color = "#FFFFFF";
titleRange.format.fill.color = "#2F5496";
titleRange.format.horizontalAlignment = Excel.HorizontalAlignment.center;
titleRange.format.rowHeight = 30;
// Headers row
const headers = ["Day", "Time", "Instructor", "Course", "Title", "Campus", "Room", "Enrolled / Capacity"];
const headerRange = newSheet.getRange("A3:H3");
headerRange.values = [headers];
headerRange.format.font.bold = true;
headerRange.format.font.color = "#FFFFFF";
headerRange.format.fill.color = "#4472C4";
headerRange.format.horizontalAlignment = Excel.HorizontalAlignment.center;
headerRange.format.rowHeight = 22;
// Schedule data - sorted by day then time
const data = [
// Monday
["Monday", "9:00 AM – 2:50 PM", "Gail Ellison", "ARTV 2345-002", "3-D Modeling & Rendering II", "Frisco", "IT102", "11 / 18"],
["Monday", "9:00 AM – 2:50 PM", "Russell Smith", "ARTV 1303-002", "Basic Animation", "Frisco", "IT104", "20 / 20"],
// Tuesday
["Tuesday", "9:00 AM – 2:50 PM", "Gail Ellison", "ARTV 2345-001", "3-D Modeling & Rendering II", "Frisco", "IT102", "10 / 18"],
["Tuesday", "9:00 AM – 2:50 PM", "J Marshall Pittman", "ARTV 2371-001", "Adv Skill Dev/Anim & Games", "Frisco", "IT112", "2 / 4"],
["Tuesday", "9:00 AM – 2:50 PM", "J Marshall Pittman", "GAME 1303-001", "Intro to Game Design & Develop", "Frisco", "IT112", "14 / 16"],
["Tuesday", "9:00 AM – 2:50 PM", "Russell Smith", "ARTV 1345-003", "3-D Model/Render I", "Wylie", "CC211", "10 / 20"],
// Wednesday
["Wednesday", "9:00 AM – 2:50 PM", "Gail Ellison", "ARTV 1341-001", "3-D Animation I", "Frisco", "IT102", "18 / 18"],
["Wednesday", "9:00 AM – 2:50 PM", "Russell Smith", "ARTV 1303-004", "Basic Animation", "Wylie", "CC222", "9 / 20"],
["Wednesday", "12:20 PM – 2:50 PM", "J Marshall Pittman", "FLMC 2331-001", "Video Graph & Visual Effect II", "Frisco", "IT112", "14 / 20"],
// Thursday
["Thursday", "9:00 AM – 2:50 PM", "Gail Ellison", "ARTV 1345-001", "3-D Model/Render I", "Frisco", "IT102", "15 / 18"],
["Thursday", "9:00 AM – 2:50 PM", "J Marshall Pittman", "GAME 2359-001", "Game & Simulation Group Projec", "Frisco", "IT112", "6 / 20"],
["Thursday", "6:00 PM – 11:00 PM", "J Marshall Pittman", "GAME 2325-001", "3-D Anim II-Character Set-Up", "Frisco", "IT112", "20 / 20"],
// Friday
["Friday", "9:00 AM – 2:50 PM", "Gail Ellison", "GAME 2309-001", "Video Game Art II", "Frisco", "IT102", "6 / 18"],
["Friday", "9:00 AM – 2:50 PM", "J Marshall Pittman", "ARTV 2335-002", "Portfolio Develop/Animation", "Frisco", "IT112", "21 / 20"],
["Friday", "9:00 AM – 2:50 PM", "Russell Smith", "ARTV 1371-006", "Storybrd/Concept Dev", "Wylie", "CC222", "12 / 14"],
["Friday", "9:00 AM – 2:50 PM", "Russell Smith", "ARTV 2335-001", "Portfolio Develop/Animation", "Wylie", "CC222", "6 / 6"],
];
const dataRange = newSheet.getRangeByIndexes(3, 0, data.length, 8);
dataRange.values = data;
// Color-code by instructor
const instructorColors = {
"Gail Ellison": { bg: "#D6E4F0", font: "#1F3864" },
"J Marshall Pittman": { bg: "#E2EFDA", font: "#375623" },
"Russell Smith": { bg: "#FCE4D6", font: "#833C0B" }
};
for (let r = 0; r < data.length; r++) {
const instructor = data[r][2];
const rowRange = newSheet.getRangeByIndexes(3 + r, 0, 1, 8);
if (instructorColors[instructor]) {
rowRange.format.fill.color = instructorColors[instructor].bg;
rowRange.format.font.color = instructorColors[instructor].font;
}
}
// Add day separator formatting - group rows by day with alternating subtle borders
const dayStarts = [0, 2, 6, 8, 11, 14]; // indices where new days start (adjusted for merged cells logic)
// We'll add a top border on each day-group start row (except first)
const dayChangeRows = [2, 6, 8, 11, 14]; // 0-indexed within data where day changes (Tue, Wed, Thu, Fri start adjusted)
// Actually let's just add bottom borders at day boundaries
// Monday ends at row index 1, Tuesday at 5, Wednesday at 8, Thursday at 11
const dayEndIndices = [1, 5, 8, 11]; // data indices where each day's last entry is
for (const idx of dayEndIndices) {
const borderRow = newSheet.getRangeByIndexes(3 + idx, 0, 1, 8);
borderRow.format.borders.getItem("EdgeBottom").style = Excel.BorderLineStyle.thin;
borderRow.format.borders.getItem("EdgeBottom").color = "#8DB4E2";
}
// Merge duplicate day names for cleaner look - we'll keep text but set vertical alignment
// Actually just set all data vertical alignment to middle
dataRange.format.verticalAlignment = Excel.VerticalAlignment.center;
// Auto-fit columns
newSheet.getRangeByIndexes(0, 0, data.length + 4, 8).format.autofitColumns();
// Set specific widths for better readability
newSheet.getRange("A:A").format.columnWidth = 75; // Day
newSheet.getRange("B:B").format.columnWidth = 130; // Time
newSheet.getRange("C:C").format.columnWidth = 135; // Instructor
newSheet.getRange("D:D").format.columnWidth = 115; // Course
newSheet.getRange("E:E").format.columnWidth = 210; // Title
newSheet.getRange("F:F").format.columnWidth = 55; // Campus
newSheet.getRange("G:G").format.columnWidth = 50; // Room
newSheet.getRange("H:H").format.columnWidth = 110; // Enrolled/Capacity
// Add a legend below
const legendStart = data.length + 5; // row index
newSheet.getRangeByIndexes(legendStart, 0, 1, 3).values = [["Instructor", "Courses", "Total Enrolled"]];
newSheet.getRangeByIndexes(legendStart, 0, 1, 3).format.font.bold = true;
newSheet.getRangeByIndexes(legendStart + 1, 0, 1, 3).values = [["Gail Ellison", 5, 60]];
newSheet.getRangeByIndexes(legendStart + 1, 0, 1, 3).format.fill.color = "#D6E4F0";
newSheet.getRangeByIndexes(legendStart + 1, 0, 1, 3).format.font.color = "#1F3864";
newSheet.getRangeByIndexes(legendStart + 2, 0, 1, 3).values = [["J Marshall Pittman", 6, 77]];
newSheet.getRangeByIndexes(legendStart + 2, 0, 1, 3).format.fill.color = "#E2EFDA";
newSheet.getRangeByIndexes(legendStart + 2, 0, 1, 3).format.font.color = "#375623";
newSheet.getRangeByIndexes(legendStart + 3, 0, 1, 3).values = [["Russell Smith", 5, 57]];
newSheet.getRangeByIndexes(legendStart + 3, 0, 1, 3).format.fill.color = "#FCE4D6";
newSheet.getRangeByIndexes(legendStart + 3, 0, 1, 3).format.font.color = "#833C0B";
// Freeze header rows
newSheet.freezePanes.freezeRows(3);
await context.sync();
return { success: true, rows: data.length };
```
Show more
Error
{"success":false,"error":"The number of rows or columns in the input array doesn't match the size or dimensions of the range.","code":"InvalidArgument","message":"The number of rows or columns in the input array doesn't match the size or dimensions of the range.","errorLocation":"Range.values","statement":"range.values = ...;","surroundingStatements":["...","var worksheets = workbook.worksheets;","var worksheet = worksheets.getItem(...);","var range = worksheet.getRange(...);","// Instantiate {range}","range.merge(...);","// >>>>>","range.values = ...;","// <<<<<","var format = range.format;","var font = format.font;","font.bold = ...;","font.size = ...;","font.color = ...;","..."],"fullStatements":["Please enable config.extendedErrorLogging to see full statements."]}
The merge range needs to match the values array. Let me fix that:
Used 2 tools, build instructor weekly schedule table
Build instructor weekly schedule table
Parameters:
```json
{
"code": "..."
}
```
Code:
```javascript
// Create a new sheet for the schedule
let newSheet;
try {
newSheet = context.workbook.worksheets.getItem("Instructor Schedules");
newSheet.delete();
await context.sync();
} catch(e) {}
newSheet = context.workbook.worksheets.add("Instructor Schedules");
newSheet.activate();
await context.sync();
// Title - write to single cell A1, then merge
newSheet.getRange("A1").values = [["Spring 2025 — Weekly Schedule: Gail Ellison, J Marshall Pittman, Russell Smith"]];
newSheet.getRange("A1:H1").merge(true);
newSheet.getRange("A1").format.font.bold = true;
newSheet.getRange("A1").format.font.size = 14;
newSheet.getRange("A1").format.font.color = "#FFFFFF";
newSheet.getRange("A1:H1").format.fill.color = "#2F5496";
newSheet.getRange("A1").format.horizontalAlignment = Excel.HorizontalAlignment.center;
newSheet.getRange("1:1").format.rowHeight = 30;
// Headers
const headers = ["Day", "Time", "Instructor", "Course", "Title", "Campus", "Room", "Enrolled / Capacity"];
newSheet.getRange("A3:H3").values = [headers];
newSheet.getRange("A3:H3").format.font.bold = true;
newSheet.getRange("A3:H3").format.font.color = "#FFFFFF";
newSheet.getRange("A3:H3").format.fill.color = "#4472C4";
newSheet.getRange("A3:H3").format.horizontalAlignment = Excel.HorizontalAlignment.center;
newSheet.getRange("3:3").format.rowHeight = 22;
// Schedule data
const data = [
["Monday", "9:00 AM – 2:50 PM", "Gail Ellison", "ARTV 2345-002", "3-D Modeling & Rendering II", "Frisco", "IT102", "11 / 18"],
["", "9:00 AM – 2:50 PM", "Russell Smith", "ARTV 1303-002", "Basic Animation", "Frisco", "IT104", "20 / 20"],
["Tuesday", "9:00 AM – 2:50 PM", "Gail Ellison", "ARTV 2345-001", "3-D Modeling & Rendering II", "Frisco", "IT102", "10 / 18"],
["", "9:00 AM – 2:50 PM", "J Marshall Pittman", "ARTV 2371-001", "Adv Skill Dev/Anim & Games", "Frisco", "IT112", "2 / 4"],
["", "9:00 AM – 2:50 PM", "J Marshall Pittman", "GAME 1303-001", "Intro to Game Design & Develop", "Frisco", "IT112", "14 / 16"],
["", "9:00 AM – 2:50 PM", "Russell Smith", "ARTV 1345-003", "3-D Model/Render I", "Wylie", "CC211", "10 / 20"],
["Wednesday", "9:00 AM – 2:50 PM", "Gail Ellison", "ARTV 1341-001", "3-D Animation I", "Frisco", "IT102", "18 / 18"],
["", "9:00 AM – 2:50 PM", "Russell Smith", "ARTV 1303-004", "Basic Animation", "Wylie", "CC222", "9 / 20"],
["", "12:20 PM – 2:50 PM", "J Marshall Pittman", "FLMC 2331-001", "Video Graph & Visual Effect II", "Frisco", "IT112", "14 / 20"],
["Thursday", "9:00 AM – 2:50 PM", "Gail Ellison", "ARTV 1345-001", "3-D Model/Render I", "Frisco", "IT102", "15 / 18"],
["", "9:00 AM – 2:50 PM", "J Marshall Pittman", "GAME 2359-001", "Game & Simulation Group Projec", "Frisco", "IT112", "6 / 20"],
["", "6:00 PM – 11:00 PM", "J Marshall Pittman", "GAME 2325-001", "3-D Anim II-Character Set-Up", "Frisco", "IT112", "20 / 20"],
["Friday", "9:00 AM – 2:50 PM", "Gail Ellison", "GAME 2309-001", "Video Game Art II", "Frisco", "IT102", "6 / 18"],
["", "9:00 AM – 2:50 PM", "J Marshall Pittman", "ARTV 2335-002", "Portfolio Develop/Animation", "Frisco", "IT112", "21 / 20"],
["", "9:00 AM – 2:50 PM", "Russell Smith", "ARTV 1371-006", "Storybrd/Concept Dev", "Wylie", "CC222", "12 / 14"],
["", "9:00 AM – 2:50 PM", "Russell Smith", "ARTV 2335-001", "Portfolio Develop/Animation", "Wylie", "CC222", "6 / 6"],
];
const dataRange = newSheet.getRangeByIndexes(3, 0, data.length, 8);
dataRange.values = data;
dataRange.format.verticalAlignment = Excel.VerticalAlignment.center;
// Color-code by instructor
const instructorColors = {
"Gail Ellison": { bg: "#D6E4F0", font: "#1F3864" },
"J Marshall Pittman": { bg: "#E2EFDA", font: "#375623" },
"Russell Smith": { bg: "#FCE4D6", font: "#833C0B" }
};
for (let r = 0; r < data.length; r++) {
const instructor = data[r][2];
const rowRange = newSheet.getRangeByIndexes(3 + r, 0, 1, 8);
if (instructorColors[instructor]) {
rowRange.format.fill.color = instructorColors[instructor].bg;
rowRange.format.font.color = instructorColors[instructor].font;
}
}
// Day group borders — bottom border after each day group
// Monday: rows 0-1, Tuesday: 2-5, Wednesday: 6-8, Thursday: 9-11, Friday: 12-15
const dayEndIndices = [1, 5, 8, 11]; // last row index of each day (except Friday which is last)
for (const idx of dayEndIndices) {
const borderRow = newSheet.getRangeByIndexes(3 + idx, 0, 1, 8);
borderRow.format.borders.getItem("EdgeBottom").style = Excel.BorderLineStyle.thin;
borderRow.format.borders.getItem("EdgeBottom").color = "#8DB4E2";
}
// Day label cells — bold the day names
const dayRows = [0, 2, 6, 9, 12]; // rows with day labels
for (const r of dayRows) {
newSheet.getRangeByIndexes(3 + r, 0, 1, 1).format.font.bold = true;
}
// Column widths
newSheet.getRange("A:A").format.columnWidth = 75;
newSheet.getRange("B:B").format.columnWidth = 130;
newSheet.getRange("C:C").format.columnWidth = 140;
newSheet.getRange("D:D").format.columnWidth = 115;
newSheet.getRange("E:E").format.columnWidth = 210;
newSheet.getRange("F:F").format.columnWidth = 55;
newSheet.getRange("G:G").format.columnWidth = 50;
newSheet.getRange("H:H").format.columnWidth = 110;
// Summary section
const sumStart = data.length + 5; // row 0-indexed from sheet top = 3 + 16 + 2 = row 21
const sumHeaderRange = newSheet.getRangeByIndexes(sumStart, 0, 1, 4);
sumHeaderRange.values = [["Instructor", "Sections", "Total Enrolled", "Total Capacity"]];
sumHeaderRange.format.font.bold = true;
sumHeaderRange.format.font.color = "#FFFFFF";
sumHeaderRange.format.fill.color = "#4472C4";
sumHeaderRange.format.horizontalAlignment = Excel.HorizontalAlignment.center;
// Gail: 5 sections, 60 enrolled, 90 capacity
const g = newSheet.getRangeByIndexes(sumStart + 1, 0, 1, 4);
g.values = [["Gail Ellison", 5, 60, 90]];
g.format.fill.color = "#D6E4F0";
g.format.font.color = "#1F3864";
// Pittman: 6 sections, 77 enrolled, 100 capacity
const p = newSheet.getRangeByIndexes(sumStart + 2, 0, 1, 4);
p.values = [["J Marshall Pittman", 6, 77, 100]];
p.format.fill.color = "#E2EFDA";
p.format.font.color = "#375623";
// Smith: 5 sections, 57 enrolled, 80 capacity
const s = newSheet.getRangeByIndexes(sumStart + 3, 0, 1, 4);
s.values = [["Russell Smith", 5, 57, 80]];
s.format.fill.color = "#FCE4D6";
s.format.font.color = "#833C0B";
// Freeze panes at row 3
newSheet.freezePanes.freezeRows(3);
await context.sync();
return { success: true, rows: data.length, summaryAtRow: sumStart + 1 };
```
Show more
Result
```json
{
"success": true,
"result": {
"success": true,
"rows": 16,
"summaryAtRow": 22
}
}
```
Verify schedule table top
Parameters:
```json
{
"sheetName": "Instructor Schedules",
"range": "A1:H19"
}
```
Result
```json
{
"success": true,
"address": "Instructor Schedules!A1:H19"
}
```
Verify summary section
Parameters:
```json
{
"sheetName": "Instructor Schedules",
"range": "A21:D25"
}
```
Result
```json
{
"success": true,
"address": "Instructor Schedules!A21:D25"
}
```
The schedule looks great but I can see the Enrolled/Capacity column has the same date issue — some values like "11 / 18" are rendering as "18-Nov". Let me fix that column's number format:
Fix Enrolled/Capacity date formatting, verify fixed schedule
Fix Enrolled/Capacity date formatting
Parameters:
```json
{
"code": "..."
}
```
Code:
```javascript
const sheet = context.workbook.worksheets.getItem("Instructor Schedules");
// Force the Enrolled/Capacity column to text format so "11 / 18" doesn't become a date
const ecRange = sheet.getRange("H4:H19");
ecRange.numberFormat = [["@"],["@"],["@"],["@"],["@"],["@"],["@"],["@"],["@"],["@"],["@"],["@"],["@"],["@"],["@"],["@"]];
// Re-write values as text strings
ecRange.values = [
["11 / 18"],
["20 / 20"],
["10 / 18"],
["2 / 4"],
["14 / 16"],
["10 / 20"],
["18 / 18"],
["9 / 20"],
["14 / 20"],
["15 / 18"],
["6 / 20"],
["20 / 20"],
["6 / 18"],
["21 / 20"],
["12 / 14"],
["6 / 6"]
];
ecRange.format.horizontalAlignment = Excel.HorizontalAlignment.center;
await context.sync();
return { success: true };
```
Show more
Result
```json
{
"success": true,
"result": {
"success": true
}
}
```
Verify fixed schedule
Parameters:
```json
{
"sheetName": "Instructor Schedules",
"range": "A1:H19"
}
```
Result
```json
{
"success": true,
"address": "Instructor Schedules!A1:H19"
}
```
The Instructor Schedules sheet is complete. Here's what it includes:
### Weekly Schedule (Mon–Fri)
- **16 course sections** across the three instructors, sorted by day and time
- Each row shows the **time, course, title, campus, room, and enrolled/capacity**
- Color-coded by instructor for quick scanning:
- 🔵 **Gail Ellison** (blue) — 5 sections, all at Frisco IT102, Mon–Fri mornings
- 🟢 **J Marshall Pittman** (green) — 6 sections at Frisco IT112, including one evening class (Thu 6–11 PM)
- 🟠 **Russell Smith** (orange) — 5 sections split between Frisco and Wylie campuses
### Summary Table (Instructor SchedulesA22:D25)
|Instructor|Sections|Enrolled|Capacity|
|---|---|---|---|
|Gail Ellison|5|60|90|
|J Marshall Pittman|6|77|100|
|Russell Smith|5|57|80|
A couple of things to note:
- **Pittman teaches two concurrent sections** on Tuesdays (ARTV 2371-001 + GAME 1303-001, both in IT112)
- **Russell Smith teaches two concurrent sections** on Fridays (ARTV 1371-006 + ARTV 2335-001, both in CC222)
> Enrolled and Capacity need to be separate columns.
Read data
Get Cell Ranges
Parameters:
```json
{
"sheetName": "Instructor Schedules",
"ranges": [
"A1:H25"
],
"includeStyles": false
}
```
Result
```json
{
"success": true,
"hasMore": false,
"worksheet": {
"name": "Instructor Schedules",
"dimension": "A1:H25",
"cells": {
"A1": "Spring 2025 — Weekly Schedule: Gail Ellison, J Marshall Pittman, Russell Smith",
"A3": "Day",
"A4": "Monday",
"A6": "Tuesday",
"A10": "Wednesday",
"A13": "Thursday",
"A16": "Friday",
"A22": "Instructor",
"A23": "Gail Ellison",
"A24": "J Marshall Pittman",
"A25": "Russell Smith",
"B3": "Time",
"B4": "9:00 AM – 2:50 PM",
"B5": "9:00 AM – 2:50 PM",
"B6": "9:00 AM – 2:50 PM",
"B7": "9:00 AM – 2:50 PM",
"B8": "9:00 AM – 2:50 PM",
"B9": "9:00 AM – 2:50 PM",
"B10": "9:00 AM – 2:50 PM",
"B11": "9:00 AM – 2:50 PM",
"B12": "12:20 PM – 2:50 PM",
"B13": "9:00 AM – 2:50 PM",
"B14": "9:00 AM – 2:50 PM",
"B15": "6:00 PM – 11:00 PM",
"B16": "9:00 AM – 2:50 PM",
"B17": "9:00 AM – 2:50 PM",
"B18": "9:00 AM – 2:50 PM",
"B19": "9:00 AM – 2:50 PM",
"B22": "Sections",
"B23": 5,
"B24": 6,
"B25": 5,
"C3": "Instructor",
"C4": "Gail Ellison",
"C5": "Russell Smith",
"C6": "Gail Ellison",
"C7": "J Marshall Pittman",
"C8": "J Marshall Pittman",
"C9": "Russell Smith",
"C10": "Gail Ellison",
"C11": "Russell Smith",
"C12": "J Marshall Pittman",
"C13": "Gail Ellison",
"C14": "J Marshall Pittman",
"C15": "J Marshall Pittman",
"C16": "Gail Ellison",
"C17": "J Marshall Pittman",
"C18": "Russell Smith",
"C19": "Russell Smith",
"C22": "Total Enrolled",
"C23": 60,
"C24": 77,
"C25": 57,
"D3": "Course",
"D4": "ARTV 2345-002",
"D5": "ARTV 1303-002",
"D6": "ARTV 2345-001",
"D7": "ARTV 2371-001",
"D8": "GAME 1303-001",
"D9": "ARTV 1345-003",
"D10": "ARTV 1341-001",
"D11": "ARTV 1303-004",
"D12": "FLMC 2331-001",
"D13": "ARTV 1345-001",
"D14": "GAME 2359-001",
"D15": "GAME 2325-001",
"D16": "GAME 2309-001",
"D17": "ARTV 2335-002",
"D18": "ARTV 1371-006",
"D19": "ARTV 2335-001",
"D22": "Total Capacity",
"D23": 90,
"D24": 100,
"D25": 80,
"E3": "Title",
"E4": "3-D Modeling & Rendering II",
"E5": "Basic Animation",
"E6": "3-D Modeling & Rendering II",
"E7": "Adv Skill Dev/Anim & Games",
"E8": "Intro to Game Design & Develop",
"E9": "3-D Model/Render I",
"E10": "3-D Animation I",
"E11": "Basic Animation",
"E12": "Video Graph & Visual Effect II",
"E13": "3-D Model/Render I",
"E14": "Game & Simulation Group Projec",
"E15": "3-D Anim II-Character Set-Up",
"E16": "Video Game Art II",
"E17": "Portfolio Develop/Animation",
"E18": "Storybrd/Concept Dev",
"E19": "Portfolio Develop/Animation",
"F3": "Campus",
"F4": "Frisco",
"F5": "Frisco",
"F6": "Frisco",
"F7": "Frisco",
"F8": "Frisco",
"F9": "Wylie",
"F10": "Frisco",
"F11": "Wylie",
"F12": "Frisco",
"F13": "Frisco",
"F14": "Frisco",
"F15": "Frisco",
"F16": "Frisco",
"F17": "Frisco",
"F18": "Wylie",
"F19": "Wylie",
"G3": "Room",
"G4": "IT102",
"G5": "IT104",
"G6": "IT102",
"G7": "IT112",
"G8": "IT112",
"G9": "CC211",
"G10": "IT102",
"G11": "CC222",
"G12": "IT112",
"G13": "IT102",
"G14": "IT112",
"G15": "IT112",
"G16": "IT102",
"G17": "IT112",
"G18": "CC222",
"G19": "CC222",
"H3": "Enrolled / Capacity",
"H4": "11 / 18",
"H5": "20 / 20",
"H6": "10 / 18",
"H7": "2 / 4",
"H8": "14 / 16",
"H9": "10 / 20",
"H10": "18 / 18",
"H11": "9 / 20",
"H12": "14 / 20",
"H13": "15 / 18",
"H14": "6 / 20",
"H15": "20 / 20",
"H16": "6 / 18",
"H17": "21 / 20",
"H18": "12 / 14",
"H19": "6 / 6"
}
}
}
```
I need to split column H into two columns (H: Enrolled, I: Capacity) and shift the summary table to include the extra column. Let me also update the title merge range.
Split Enrolled/Capacity into two columns, verify split columns
Split Enrolled/Capacity into two columns
Parameters:
```json
{
"code": "..."
}
```
Code:
```javascript
const sheet = context.workbook.worksheets.getItem("Instructor Schedules");
// 1. Expand title merge to include column I
const titleCell = sheet.getRange("A1");
titleCell.load("values");
await context.sync();
// Unmerge first, then re-merge wider
sheet.getRange("A1:H1").unmerge();
sheet.getRange("A1:I1").merge(true);
sheet.getRange("I1").format.fill.color = "#2F5496"; // ensure bg extends
// 2. Update header row: H3 = "Enrolled", I3 = "Capacity"
sheet.getRange("H3").values = [["Enrolled"]];
sheet.getRange("I3").values = [["Capacity"]];
sheet.getRange("I3").format.font.bold = true;
sheet.getRange("I3").format.font.color = "#FFFFFF";
sheet.getRange("I3").format.fill.color = "#4472C4";
sheet.getRange("I3").format.horizontalAlignment = Excel.HorizontalAlignment.center;
// 3. Split the enrolled/capacity data
const enrolledData = [11,20,10,2,14,10,18,9,14,15,6,20,6,21,12,6];
const capacityData = [18,20,18,4,16,20,18,20,20,18,20,20,18,20,14,6];
// Write Enrolled column (H4:H19)
sheet.getRange("H4:H19").numberFormat = enrolledData.map(() => [["0"]]).flat();
sheet.getRange("H4:H19").values = enrolledData.map(v => [v]);
sheet.getRange("H4:H19").format.horizontalAlignment = Excel.HorizontalAlignment.center;
// Write Capacity column (I4:I19)
sheet.getRange("I4:I19").numberFormat = capacityData.map(() => [["0"]]).flat();
sheet.getRange("I4:I19").values = capacityData.map(v => [v]);
sheet.getRange("I4:I19").format.horizontalAlignment = Excel.HorizontalAlignment.center;
// 4. Apply instructor color coding to the new column I
const instructorColors = {
"Gail Ellison": { bg: "#D6E4F0", font: "#1F3864" },
"J Marshall Pittman": { bg: "#E2EFDA", font: "#375623" },
"Russell Smith": { bg: "#FCE4D6", font: "#833C0B" }
};
const instructors = ["Gail Ellison","Russell Smith","Gail Ellison","J Marshall Pittman","J Marshall Pittman","Russell Smith","Gail Ellison","Russell Smith","J Marshall Pittman","Gail Ellison","J Marshall Pittman","J Marshall Pittman","Gail Ellison","J Marshall Pittman","Russell Smith","Russell Smith"];
for (let r = 0; r < 16; r++) {
const colors = instructorColors[instructors[r]];
const cell = sheet.getRangeByIndexes(3 + r, 8, 1, 1); // column I
cell.format.fill.color = colors.bg;
cell.format.font.color = colors.font;
}
// 5. Copy day-group bottom borders to column I
const dayEndRows = [4, 8, 11, 14]; // sheet rows (1-indexed) where day borders are: rows 5,9,12,15
for (const row of dayEndRows) {
sheet.getRangeByIndexes(row, 8, 1, 1).format.borders.getItem("EdgeBottom").style = Excel.BorderLineStyle.thin;
sheet.getRangeByIndexes(row, 8, 1, 1).format.borders.getItem("EdgeBottom").color = "#8DB4E2";
}
// 6. Set column widths for H and I
sheet.getRange("H:H").format.columnWidth = 60;
sheet.getRange("I:I").format.columnWidth = 60;
await context.sync();
return { success: true };
```
Show more
Result
```json
{
"success": true,
"result": {
"success": true
}
}
```
Verify split columns
Parameters:
```json
{
"sheetName": "Instructor Schedules",
"range": "A1:I19"
}
```
Result
```json
{
"success": true,
"address": "Instructor Schedules!A1:I19"
}
```
That looks clean. Now let me also update the summary table below to match with separate Enrolled/Capacity columns:
Update summary headers
Update summary headers
Parameters:
```json
{
"sheetName": "Instructor Schedules",
"range": "C22:D22",
"allow_overwrite": true,
"cells": [
[
{
"value": "Total Enrolled",
"cellStyles": {
"fontWeight": "bold",
"fontColor": "#FFFFFF",
"backgroundColor": "#4472C4",
"horizontalAlignment": "center"
}
},
{
"value": "Total Capacity",
"cellStyles": {
"fontWeight": "bold",
"fontColor": "#FFFFFF",
"backgroundColor": "#4472C4",
"horizontalAlignment": "center"
}
}
]
]
}
```
Show more
Result
```json
{
"success": true
}
```
Done! Instructor SchedulesH3 and Instructor SchedulesI3 are now separate columns across both the schedule table and the summary section — consistent with how the other course data sheets are formatted.
can you make this a skill I can use on the other tabs and with future data? I'd like to specify which instructors are included in the schedule each time.
Absolutely! I'll create a skill that takes instructor names and a source sheet as inputs, then builds the weekly schedule table automatically.
Read instructions, capture final schedule design
Read Skill
Parameters:
```json
{
"skill_name": "skill-creator"
}
```
Result
Capture final schedule design
can you make this a skill I can use on the other tabs and with future data? I'd like to specify which instructors are included in the schedule each time.
Let me first capture the exact design of your current schedule so the skill replicates it precisely.
Capture final schedule design, read data
Capture final schedule design
Parameters:
```json
{
"sheetName": "Spring 2025 Schedules",
"range": "A1:I25"
}
```
Result
```json
{
"success": true,
"address": "Spring 2025 Schedules!A1:I25"
}
```
Get Cell Ranges
Parameters:
```json
{
"sheetName": "Spring 2025 Schedules",
"ranges": [
"A1:I25"
],
"includeStyles": true
}
```
Result
```json
{
"success": true,
"hasMore": false,
"worksheet": {
"name": "Spring 2025 Schedules",
"dimension": "A1:I25",
"cells": {
"A1": "Spring 2025 — Weekly Schedule: Gail Ellison, J Marshall Pittman, Russell Smith",
"A3": "Day",
"A4": "Monday",
"A6": "Tuesday",
"A10": "Wednesday",
"A13": "Thursday",
"A16": "Friday",
"A22": "Instructor",
"A23": "Gail Ellison",
"A24": "J Marshall Pittman",
"A25": "Russell Smith",
"B3": "Time",
"B4": "9:00 AM – 2:50 PM",
"B5": "9:00 AM – 2:50 PM",
"B6": "9:00 AM – 2:50 PM",
"B7": "9:00 AM – 2:50 PM",
"B8": "9:00 AM – 2:50 PM",
"B9": "9:00 AM – 2:50 PM",
"B10": "9:00 AM – 2:50 PM",
"B11": "9:00 AM – 2:50 PM",
"B12": "12:20 PM – 2:50 PM",
"B13": "9:00 AM – 2:50 PM",
"B14": "9:00 AM – 2:50 PM",
"B15": "6:00 PM – 11:00 PM",
"B16": "9:00 AM – 2:50 PM",
"B17": "9:00 AM – 2:50 PM",
"B18": "9:00 AM – 2:50 PM",
"B19": "9:00 AM – 2:50 PM",
"B22": "Sections",
"B23": 5,
"B24": 6,
"B25": 5,
"C3": "Instructor",
"C4": "Gail Ellison",
"C5": "Russell Smith",
"C6": "Gail Ellison",
"C7": "J Marshall Pittman",
"C8": "J Marshall Pittman",
"C9": "Russell Smith",
"C10": "Gail Ellison",
"C11": "Russell Smith",
"C12": "J Marshall Pittman",
"C13": "Gail Ellison",
"C14": "J Marshall Pittman",
"C15": "J Marshall Pittman",
"C16": "Gail Ellison",
"C17": "J Marshall Pittman",
"C18": "Russell Smith",
"C19": "Russell Smith",
"C22": "Total Enrolled",
"C23": 60,
"C24": 77,
"C25": 57,
"D3": "Course",
"D4": "ARTV 2345-002",
"D5": "ARTV 1303-002",
"D6": "ARTV 2345-001",
"D7": "ARTV 2371-001",
"D8": "GAME 1303-001",
"D9": "ARTV 1345-003",
"D10": "ARTV 1341-001",
"D11": "ARTV 1303-004",
"D12": "FLMC 2331-001",
"D13": "ARTV 1345-001",
"D14": "GAME 2359-001",
"D15": "GAME 2325-001",
"D16": "GAME 2309-001",
"D17": "ARTV 2335-002",
"D18": "ARTV 1371-006",
"D19": "ARTV 2335-001",
"D22": "Total Capacity",
"D23": 90,
"D24": 100,
"D25": 80,
"E3": "Title",
"E4": "3-D Modeling & Rendering II",
"E5": "Basic Animation",
"E6": "3-D Modeling & Rendering II",
"E7": "Adv Skill Dev/Anim & Games",
"E8": "Intro to Game Design & Develop",
"E9": "3-D Model/Render I",
"E10": "3-D Animation I",
"E11": "Basic Animation",
"E12": "Video Graph & Visual Effect II",
"E13": "3-D Model/Render I",
"E14": "Game & Simulation Group Projec",
"E15": "3-D Anim II-Character Set-Up",
"E16": "Video Game Art II",
"E17": "Portfolio Develop/Animation",
"E18": "Storybrd/Concept Dev",
"E19": "Portfolio Develop/Animation",
"F3": "Campus",
"F4": "Frisco",
"F5": "Frisco",
"F6": "Frisco",
"F7": "Frisco",
"F8": "Frisco",
"F9": "Wylie",
"F10": "Frisco",
"F11": "Wylie",
"F12": "Frisco",
"F13": "Frisco",
"F14": "Frisco",
"F15": "Frisco",
"F16": "Frisco",
"F17": "Frisco",
"F18": "Wylie",
"F19": "Wylie",
"G3": "Room",
"G4": "IT102",
"G5": "IT104",
"G6": "IT102",
"G7": "IT112",
"G8": "IT112",
"G9": "CC211",
"G10": "IT102",
"G11": "CC222",
"G12": "IT112",
"G13": "IT102",
"G14": "IT112",
"G15": "IT112",
"G16": "IT102",
"G17": "IT112",
"G18": "CC222",
"G19": "CC222",
"H3": "Enrolled",
"H4": 11,
"H5": 20,
"H6": 10,
"H7": 2,
"H8": 14,
"H9": 10,
"H10": 18,
"H11": 9,
"H12": 14,
"H13": 15,
"H14": 6,
"H15": 20,
"H16": 6,
"H17": 21,
"H18": 12,
"H19": 6,
"I3": "Capacity",
"I4": 18,
"I5": 20,
"I6": 18,
"I7": 4,
"I8": 16,
"I9": 20,
"I10": 18,
"I11": 20,
"I12": 20,
"I13": 18,
"I14": 20,
"I15": 20,
"I16": 18,
"I17": 20,
"I18": 14,
"I19": 6
},
"styles": {
"A1:I1": {
"b": true,
"sz": 14,
"color": "#FFFFFF",
"family": "Aptos Narrow",
"fgColor": "#2F5496",
"alignment": "center"
},
"A2:I2,A20:I21,E22:I25": {
"sz": 11,
"color": "#000000",
"family": "Aptos Narrow",
"fgColor": "#FFFFFF"
},
"A3:I3,A22:D22": {
"b": true,
"sz": 11,
"color": "#FFFFFF",
"family": "Aptos Narrow",
"fgColor": "#4472C4",
"alignment": "center"
},
"A4,A6,A10,A13,A16": {
"b": true,
"sz": 11,
"color": "#1F3864",
"family": "Aptos Narrow",
"fgColor": "#D6E4F0"
},
"A5:G5,A9:G9,A11:G11,A18:G19,A25:D25": {
"sz": 11,
"color": "#833C0B",
"family": "Aptos Narrow",
"fgColor": "#FCE4D6"
},
"A7:G8,A12:G12,A14:G15,A17:G17,A24:D24": {
"sz": 11,
"color": "#375623",
"family": "Aptos Narrow",
"fgColor": "#E2EFDA"
},
"B4:G4,B6:G6,B10:G10,B13:G13,B16:G16,A23:D23": {
"sz": 11,
"color": "#1F3864",
"family": "Aptos Narrow",
"fgColor": "#D6E4F0"
},
"H4:I4,H6:I6,H10:I10,H13:I13,H16:I16": {
"sz": 11,
"color": "#1F3864",
"family": "Aptos Narrow",
"fgColor": "#D6E4F0",
"alignment": "center",
"numFmt": "0"
},
"H5:I5,H9:I9,H11:I11,H18:I19": {
"sz": 11,
"color": "#833C0B",
"family": "Aptos Narrow",
"fgColor": "#FCE4D6",
"alignment": "center",
"numFmt": "0"
},
"H7:I8,H12:I12,H14:I15,H17:I17": {
"sz": 11,
"color": "#375623",
"family": "Aptos Narrow",
"fgColor": "#E2EFDA",
"alignment": "center",
"numFmt": "0"
}
},
"borders": {
"A5:I5,A9:I9,A12:I12,A15:I15": {
"bottom": "thin solid #8DB4E2"
},
"A6:I6,A10:I10,A13:I13,A16:I16": {
"top": "thin solid #8DB4E2"
}
}
}
}
```
Now I have the exact design. Let me create the skill.
Read instructions
Read Skill
Parameters:
```json
{
"skill_name": "skill-creator"
}
```
Result
```json
{
"skill_name": "skill-creator",
"instructions": "Create new skills, modify and improve existing skills, and measure skill performance. Use when users want to create a skill from scratch, edit, or optimize an existing skill, run evals to test a skill, benchmark skill performance with variance analysis, or optimize a skill's description for better triggering accuracy."
}
```
Now let me verify the skill works by testing it against a different tab. Let me do a dry run on Fall 2025 with the same three instructors to confirm it produces the right output:
Test skill logic on Fall 2025 data
Test skill logic on Fall 2025 data
Parameters:
```json
{
"code": "..."
}
```
Code:
```javascript
// Test the skill logic against Fall 2025 data
const sourceSheet = context.workbook.worksheets.getItem("Fall 2025");
const usedRange = sourceSheet.getUsedRange();
usedRange.load("values");
await context.sync();
const allRows = usedRange.values;
const headers = allRows[0]; // Course, Status, Campus, Location & Schedule, Instructors, Instructional Format, Delivery Mode, Enrolled, Capacity
const data = allRows.slice(1);
const targetInstructors = ["Gail Ellison", "J Marshall Pittman", "Russell Smith"];
// Filter for target instructors & non-empty schedules
const filtered = data.filter(r => {
const instructor = String(r[4]).trim();
const schedule = String(r[3]).trim();
return targetInstructors.includes(instructor) && schedule !== "(empty)" && schedule !== "";
});
// Parse each entry
const dayOrder = { "Monday": 0, "Tuesday": 1, "Wednesday": 2, "Thursday": 3, "Friday": 4, "Saturday": 5 };
const entries = filtered.map(r => {
const fullCourse = String(r[0]).trim();
const parts = fullCourse.split(" - ");
const courseId = parts[0].trim();
const title = parts.slice(1).join(" - ").trim();
const schedParts = String(r[3]).trim().split("|").map(s => s.trim());
const location = schedParts[0] || "";
const day = schedParts[1] || "";
const time = schedParts[2] || "";
const locWords = location.split(" ");
const campus = locWords[0] || "";
const room = locWords[1] || "";
// Parse start time for sorting
const startTime = time.split("–")[0].trim();
let h = parseInt(startTime.split(":")[0]);
const m = parseInt(startTime.split(":")[1]);
const ampm = startTime.split(" ")[1];
if (ampm === "PM" && h !== 12) h += 12;
if (ampm === "AM" && h === 12) h = 0;
const sortMin = h * 60 + m;
return {
day, time, instructor: String(r[4]).trim(),
courseId, title, campus, room,
enrolled: r[7], capacity: r[8],
dayIdx: dayOrder[day] !== undefined ? dayOrder[day] : 99,
sortMin
};
});
entries.sort((a, b) => a.dayIdx - b.dayIdx || a.sortMin - b.sortMin || a.instructor.localeCompare(b.instructor));
return {
totalEntries: entries.length,
byInstructor: {
"Gail Ellison": entries.filter(e => e.instructor === "Gail Ellison").length,
"J Marshall Pittman": entries.filter(e => e.instructor === "J Marshall Pittman").length,
"Russell Smith": entries.filter(e => e.instructor === "Russell Smith").length,
},
sample: entries.slice(0, 5).map(e => `${e.day} ${e.time} | ${e.instructor} | ${e.courseId}`)
};
```
Show more
Result
```json
{
"success": true,
"result": {
"totalEntries": 10,
"byInstructor": {
"Gail Ellison": 1,
"J Marshall Pittman": 5,
"Russell Smith": 4
},
"sample": [
"Monday 9:00 AM - 1:50 PM | Russell Smith | ARTV 1303-002",
"Tuesday 9:00 AM - 1:50 PM | J Marshall Pittman | ARTV 2371-001",
"Tuesday 9:00 AM - 1:50 PM | J Marshall Pittman | GAME 1303-001",
"Tuesday 9:00 AM - 1:50 PM | Russell Smith | ARTV 1345-003",
"Tuesday 6:00 PM - 10:50 PM | Gail Ellison | ARTV 1341-001"
]
}
}
```
The parsing logic works correctly on different data. The skill is created and ready to use.
The **`/instructor-schedule`** skill is now saved! Here's how to use it:
### Usage
Type `/instructor-schedule` and specify:
1. **Which tab** has the course data (e.g., "Fall 2025", "Spring 2026")
2. **Which instructors** to include (any number of names)
### Examples
> `/instructor-schedule` Fall 2025 for Gail Ellison, J Marshall Pittman, Russell Smith
> `/instructor-schedule` Spring 2026 for Russell Smith and Kevin Taylor
### What it does
- Reads the transposed course data from the specified tab
- Filters to only the instructors you name
- Skips web-only courses (no physical schedule)
- Sorts by day (Mon→Sat), then time, then instructor
- Creates a new **"[Term] Schedules"** sheet with:
- Color-coded rows per instructor (up to 6 distinct colors)
- Day groupings with borders
- Separate Enrolled & Capacity columns
- Summary table with section counts and enrollment totals
It pairs with your `/transpose-courses` skill — paste raw catalog data, transpose it, then build schedules from it each semester.