ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Middle Age Renaissance Life Challenge Workbook Instructions
2
Challenge and Spreadsheet Tracker created by Kristina Brooke with the help of Claude for the formulas for this spreadsheet.
3
Sidenote: I have not written Javascript in so long, but putting together this workbook reminded me of how much I enjoy programming.
4
This is a comprehensive tracking system for The Sims 4 Renaissance Life Challenge - a 51-episode journey where your middle-aged Sim transitions from corporate life to become a well-rounded "Renaissance Sim."

Key Features:

📊 Episode Tracking: Individual sheets for all 51 episodes with auto-populated goals from the master INFO sheet
✅ Goal Management: Check off completed goals with visual feedback (bold = incomplete, italic = complete)
📈 Progress Dashboard: Real-time statistics showing completion rates by episode groups, skill categories, and overall progress
📝 Flexible Design: Add custom goals and notes to personalize your gameplay experience
🔄 Automated Setup: Built-in scripts to create and manage episode sheets efficiently

Perfect for players who want to:

- Track their challenge progress systematically
- See statistics and completion rates at a glance
- Document their Sim's transformation journey
- Stay motivated with visual progress indicators
- Customize goals while maintaining organization
5
6
Quick Start Guide
7
8
1. Initial Setup
9
💡 INFO Sheet: This is your master data sheet containing all 51 episodes with titles, duration, and goals
10
📃 Episode Template MASTER (HIDDEN): Your template for tracking each episode - DO NOT delete this!
11
🔍 Dashboard: Your progress tracking hub showing completion stats across all episodes
12
CAUTION: Do not change the formulas on any of the sheets as doing so will break the function of the entire workbook. I cannot provide support.
13
14
2. Playing Episodes
15
Before Starting an Episode:
16
✅ Go to the Dashboard to see which episode you're on
17
✅ Navigate to that Episode's sheet (e.g., "Episode 1")
18
✅ Review the goals listed - they auto-populate from the INFO sheet
19
✅ The episode info at the top shows title, duration, and current status
20
During Gameplay:
21
✅ Check off goals as you complete them in-game using the checkboxes in column B. If your goal has a "Goal Keyword" it will be auto-tallied in the INFO Sheet (columns K-O). Make sure to Read the Custom Goal section
22
✅ Add notes/screenshots in column C for memorable moments or reminders
23
✅ Completed goals will appear in italic, incomplete goals remain bold
24
After Playing:
25
✅ Go to the INFO sheet
26
✅ Update the episode's row:
27
✅ Change Status (column E) from "Not Started" to "In Progress" or "Completed"
28
✅ Add the Date Played (column F)
29
Your Dashboard will automatically update with your progress!
30
31
3. Understanding the Dashboard
32
The Dashboard shows:
33
✅ Episodes Progress: How many goals completed in each 10-episode block
34
✅ Skills Progress: Tracks specific goal types (Fitness, Gardening, Career, etc. )
35
✅ Overall Progress: Total goals completed and episodes played
36
✅ Completion Rate: Your success rate for attempted goals
37
38
4. Add More Custom Goals
39
DO NOT us the Episode Tools > Add Custom Goals Setting UNLES the section is NOT showing in your worksheet.
40
✅ Select the entire last custom goal row (click the row number)
41
✅ Right-click → Insert 1 below
42
The new row will have: The same formatting and A checkbox in column B. The conditional formatting (bold/italic) will automatically apply
43
Read the Custom Goal Wording Guide before adding custom goals.
44
5. Transformation not Perfection
45
✅ Partial Completion: It's okay to move to the next episode without completing all goals - the challenge is about transformation, not perfection!
46
✅ Dashboard Motivation: Check your Dashboard regularly to see your progress visualized
47
48
6. Troubleshooting
49
50
Formulas not updating?
51
Use Episode Tools → Refresh All Episode Formulas
52
53
Can't see goals in an episode?
54
Check that the worksheet tab is properly named (e.g., "Episode 1" not "Episode1") - there must be a space
55
Run the refresh function from Episode Tools menu
56
57
Dashboard showing errors?
58
This is normal if you haven't created all episode sheets yet
59
Numbers will update as you create more episodes
60
61
62
7. The Journey
63
Remember, this challenge is about your Sim's transformation from corporate lawyer to Renaissance Sim. Each episode builds on the last, developing skills, relationships, and new life perspectives. The workbook is your companion to track this incredible journey!
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100