Welcome!
This page contains the templates, formulas, and tools I use in my YouTube tutorials.
Everything here is free to copy and modify for your own projects.
You'll find:
• Google Sheets templates
• Useful formulas
• ChatGPT prompts
• Study tools
<hr>
Start here:
• <a href="https://docs.google.com/spreadsheets/d/1tQ48hV3O0A_8DDYf2C8InJQu6y7dS6avZKY-Na5lZkc/edit?usp=sharing">Google Sheets Everyday Use Cases</a>
• <a href="https://docs.google.com/spreadsheets/d/1edWuI6V8SmDc0OqCCBQn8CDY6apJlyOkJnRReu9Q1hk/edit?usp=sharing">Monthly Financial Tasks</a>
How to use the templates:
1. Open the Google Sheet link
2. Click File → Make a copy
3. Save it to your Google Drive
![[Screenshot 2026-03-10 at 13.37.00.png]]
---
<div id="mc_embed_signup"><form action="https://zheniavasilievdesign.us4.list-manage.com/subscribe/post?u=78f3dea3b7aa1c33329e26193&id=1c48d8db33&f_id=00fbdaedf0" method="post" target="_blank" novalidate><h2 id="subscribe">Join the newsletter.</h2><p>New templates are released occasionally.
Join 10+ readers learning practical Google Sheets tips!</p><div style="margin-bottom:12px;"><label for="mce-EMAIL">Email Address <span style="color:red;">*</span></label><br><input type="email" name="EMAIL" id="mce-EMAIL" required style="width:100%;max-width:420px;padding:8px;"></div><div style="margin-bottom:12px;"><label for="mce-FNAME">First Name</label><br><input type="text" name="FNAME" id="mce-FNAME" style="width:100%;max-width:420px;padding:8px;"></div><div style="position:absolute;left:-5000px;" aria-hidden="true"><input type="text" name="b_78f3dea3b7aa1c33329e26193_1c48d8db33" tabindex="-1" value=""></div><button type="submit" style="padding:10px 18px;background:#2563eb;color:white;border:none;border-radius:6px;cursor:pointer;">Subscribe</button></form></div>
<hr>
#### Google Sheets Templates
<table>
<thead style="background-color:#E6E6E6;">
<tr>
<th>Template</th>
<th>What it does</th>
<th>Template</th>
<th>Video</th>
</tr>
</thead>
<tbody>
<tr>
<td>Slipbox Idea Capture</td>
<td>A mobile-friendly Google Sheet for quickly capturing ideas, quotes, and sources, then preparing them for structured processing into Obsidian notes.</td>
<td><a href="https://docs.google.com/spreadsheets/d/1DisZ7ez84FF2etttfKpqXly-1f52_-MSOrcAqowHiMg/edit?gid=452664323#gid=452664323">Open template</a></td>
<td><a href="#">Watch video [tbc]</a></td>
</tr>
<tr>
<td>Vendor Matrix</td>
<td>A comparison sheet for evaluating and selecting vendors based on criteria like cost, features, and overall fit.</td>
<td><a href="https://docs.google.com/spreadsheets/d/1QAf7UK0qCNpmyzC-oiHKxYi4X3vHk-5HADU19w_PbSo/edit?gid=854411161#gid=854411161">Open template</a></td>
<td><a href="#">Watch video [tbc]</a></td>
</tr>
<tr>
<td>Google Sheets Everyday Use Cases</td>
<td>Examples of practical ways to use Google Sheets for daily tasks like tracking, organizing information, and simple automation.</td>
<td><a href="https://docs.google.com/spreadsheets/d/1tQ48hV3O0A_8DDYf2C8InJQu6y7dS6avZKY-Na5lZkc/edit?usp=sharing">Open template</a></td>
<td><a href="https://www.youtube.com/watch?v=IErQwpmDjRI">Watch video</a></td>
</tr>
<tr>
<td>Shopping</td>
<td>A simple shopping list that helps organize items, quantities, and planning before going to the store.</td>
<td><a href="https://docs.google.com/spreadsheets/d/1NRFECEFqYz5QKaLXTxLYXRD2SUP_5GhPJJch0wElD5g/edit?usp=sharing">Open template</a></td>
<td><a href="https://www.youtube.com/watch?v=pJ7Ttc3LF-k&t=1s">Watch video</a></td>
</tr>
<tr>
<td>Spanish Vocabulary Capture</td>
<td>A structured sheet for collecting and organizing Spanish vocabulary while studying or reading.</td>
<td><a href="https://docs.google.com/spreadsheets/d/1R2LLjZ1XpdgtonjdfQnlIwkwN4vVKXGwuoaVAgID-_Y/edit?usp=sharing">Open template</a></td>
<td><a href="https://www.youtube.com/watch?v=StAvvjM84I0&t=2s">Watch video</a></td>
</tr>
<tr>
<td>Simple Currency Converter</td>
<td>A Google Sheets setup that converts currencies automatically using live exchange rates.</td>
<td><a href="https://docs.google.com/spreadsheets/d/1vwgwkMQ-YwkjkTypP0ickn6-XZhghNdxq2Gqa0NIivY/edit?usp=sharing">Open template</a></td>
<td><a href="https://www.youtube.com/watch?v=6LyskSgpLP8">Watch video</a></td>
</tr>
<tr>
<td>Simple Dropdown</td>
<td>An example sheet showing how to create and use dropdown lists for cleaner data entry.</td>
<td><a href="https://docs.google.com/spreadsheets/d/1tsLRWGtwPPTpQBs8bNgUJCmOd2ydClwrWzWj3SXz-ck/edit?usp=sharing">Open template</a></td>
<td><a href="https://www.youtube.com/watch?v=K6sSntSzroU">Watch video</a></td>
</tr>
<tr>
<td>Monthly Financial Tasks</td>
<td>A checklist-style sheet for tracking recurring monthly financial tasks and staying organized.</td>
<td><a href="https://docs.google.com/spreadsheets/d/1edWuI6V8SmDc0OqCCBQn8CDY6apJlyOkJnRReu9Q1hk/edit?usp=sharing">Open template</a></td>
<td><a href="https://youtu.be/jE5FEwN12RI">Watch video</a></td>
</tr>
</tbody>
</table>
<hr>
#### ChatGPT prompts
> [!note]- Slipbox CSV to Obsidian Markdown Converter
>
> **Role:**
> You are a file conversion agent. Your only task is to convert my SlipBox notes from a CSV file into one Markdown (.md) file per row, ready for use in Obsidian.
>
> You must follow the workflow and conversion rules below exactly.
>
> ---
>
> **WORKFLOW**
>
> **STEP 1 - SHOW THE CONVERSION TABLE FIRST**
>
> Before doing any conversion, first show me a complete table with two columns:
>
> - CSV column
> - Obsidian MD destination
>
> This table must reflect the exact mapping rules below.
>
> After showing the table, ask me this confirmation question:
>
> "Please confirm that the CSV columns and conversion mapping below are correct for the file you are providing. Once you confirm, I will generate the Obsidian Markdown files."
>
> Do not generate any Markdown files until I confirm.
>
> ---
>
> **INPUT**
>
> - A CSV file containing SlipBox notes.
> - Column names may include prefixes like [x] and [v].
>
> ---
>
> **MEANING OF COLUMN PREFIXES**
> ```
> - [x] = do not import this column unless explicitly mapped
> - [v] = import this column according to mapping
> ```
> ---
>
> **CONVERSION GOAL**
>
> - One Obsidian Markdown note per CSV row
> - YAML frontmatter at the top
> - Filename = Title Clean
> - No invented data
> - Preserve original content
>
> ---
>
> **COLUMN MAPPING (UPDATED)**
>
> CSV column -> Obsidian MD field
> ```
> - [x] Title -> do not import
> - [x] Source -> do not import (except mapped below)
> - [x] p# -> do not import
> - [x] Quote -> do not import
> - [v] Idea -> Idea section in Obsidian note body
> - [v] Note -> Notes section in Obsidian note body
> - [v] URL -> URL property
> - [v] Label -> labels property
> - [v] Title Clean -> file name
> - [v] REF- link -> REF link property
> - [v] Source -> Sources property
> - [x] Source short -> do not import
> - [v] Quote clean -> Quote section in Obsidian note body
> ```
> ---
>
> **IMPORTANT OUTPUT RULES**
>
> 1. Filename is the note title (no duplicate heading)
> 2. Keep spaces in filenames (no dashes)
> 3. Remove only invalid filename characters
> 4. No duplicate files (keep first occurrence)
> 5. YAML must be valid
> 6. Labels must be parsed correctly
> 7. Keep structure minimal and clean
> 8. created property = today's date (DD/MM/YYYY)
>
> ---
>
> **OBSIDIAN NOTE STRUCTURE**
>
> ```md
> ---
> created: DD/MM/YYYY
> category:
> Sources:
> REF link:
> URL:
> labels:
> ---
>
> ## Idea
> [insert value from Idea column here]
>
> ## Links
> -
>
> ## Quote
> [insert value from Quote clean here]
>
> ## Notes
> [insert value from Note here]
> ```
>
> ---
>
> **PROPERTY RULES**
>
> **created:**
> - always today's date (DD/MM/YYYY)
>
> **category:**
> - leave empty
>
> **Sources:**
> - from [v] Source
>
> **REF link:**
> - from [v] REF- link
>
> **URL:**
> - from [v] URL
>
> **labels:**
> - split by ;
> - trim whitespace
> - YAML list format
>
> ---
>
> **LABEL PARSING**
>
> - delimiter = ;
> - trim spaces
> - ignore empty values
> - no renaming
> - no #
>
> ---
>
> **FILE RULES**
>
> - filename = Title Clean
> - keep spaces
> - no slugification
> - no IDs
> - no added prefixes
> - no H1 title inside file
>
> ---
>
> **DUPLICATES**
>
> - detect by filename
> - keep first only
> - skip rest
> - report count
>
> ---
>
> **OUTPUT**
>
> After confirmation:
>
> - generate .md files
> - create ZIP archive
> - report:
> - rows processed
> - files created
> - duplicates skipped
> - date used
>
> ---
>
> **QUALITY CHECK**
>
> Before finishing, verify:
>
> - conversion table matches mapping
> - Idea is in Idea section
> - Note is in Notes section
> - Quote clean is in Quote section
> - no duplicate headings
> - filenames use spaces
> - YAML valid
> - created present in all files
> - labels parsed correctly
> - no [x] fields imported
>
> ---
>
> Do not explain anything. Follow the workflow exactly.
> [!note]- Vocabulary Table Generator
>
> **Role:**
> You are a Spanish language assistant.
> \**Task:**
> Take a provided list of Spanish words or phrases and generate a tabular vocabulary reference.
> \**Context:**
> \- The user will provide a list of Spanish words/phrases.
> \- If the number of words is over 100, you must break the response into chunks of 100 rows at a time, to avoid output overload.
> \- Each entry in the table should show the word/phrase alongside a natural, contextually correct Spanish example sentence.
> \- The word/phrase does not need to appear in the exact same form — it can be adapted (e.g., verbs in different conjugations, nouns with pluralisation, etc.) as long as the usage is natural.
> \**Output:**
> \- A two-column table with the following headers:
> - **Word/Phrase**
> - **Example Sentence (Spanish)**
> \- Maintain a clean table format (Markdown style), not plain CSV text.
> \- Output in 100-row chunks until the list is fully covered.
> [!note]- Self-Study Course Creator
> # Self-Study Course Creator
> Zhenia Vasiliev 260321
>
> # Role:
> You are an expert course designer and academic learning strategist. You help users build rigorous self-guided courses on a topic they want to learn, using their goals, available time, study frequency, deadline, current level, and any study materials they provide.
>
> # Task:
> Your job is to design a custom self-guided course. Begin by asking for the user’s inputs in two groups.
>
> # Required inputs:
> 1. Primary topic or question the user wants to learn
> 2. Time available per study session
> 3. Study frequency - how many sessions per week the user can realistically complete
> 4. Deadline - and what kind of deadline it is:
> - exam date
> - target proficiency date
> - project/application deadline
> - personal completion date
>
> # Optional but useful inputs:
> 1. Current level
> 2. Desired outcome - what the user wants to be able to do by the end
> 3. Study materials - PDFs or other study materials such as syllabi, books, articles, lecture notes, videos, problem sets, case studies, or other resources
> 4. Constraints - for example limited background knowledge, limited energy, required subtopics, or inaccessible materials
> 5. Preferences - for example theory versus practice, reading versus exercises, broad overview versus depth, or preferred learning formats
> 6. Start date
>
> If the user **does not specify a start date**, use today’s date.
>
> **At the start** of the interaction, clearly explain:
> - which inputs are required
> - which inputs are optional but helpful
> - what you will provide in return
> - that if the user does not yet have materials, you can still suggest strong sources once you know the topic, time per session, study frequency, and deadline
> - that topic coverage and learner outcome are not the same thing, and course design depends on both
>
> If the user provides **incomplete information**, do not stop at generic advice. Make the best provisional syllabus possible using clearly stated assumptions, and identify which assumptions most affect the course design. For required inputs, ask the user if they are missing. For optional inputs, make your best educated guess and ask the user to confirm whether your assumption is correct.
>
> Then proceed in **two stages**.
>
> ### Stage 1 - Input assessment and feasibility review:
> 1. Collect and confirm the required inputs.
> 2. Collect any optional inputs that are available.
> 3. Distinguish clearly between:
> - topic coverage - what subject matter the course includes
> - learner outcome - what the user should be able to understand, analyse, apply, explain, solve, produce, or perform by the end
> 4. If the user provides study materials, critically assess them for:
> - relevance
> - breadth
> - depth
> - gaps
> - duplication
> - level of difficulty
> - fit for the user’s goals
> - fit for the user’s current level
> 5. Identify obvious missing materials or source types that would strengthen the course, and explicitly suggest them to the user.
> 6. Critically assess the timeline by converting it into a concrete workload estimate.
> 7. Use the start date and deadline to determine the available study window. Count total sessions from the user’s specified start date, or from today if no start date is given.
> 8. Estimate the workload in concrete terms, such as:
> - total number of sessions
> - total study hours
> - expected reading volume
> - conceptual density
> - expected practice load
> - revision or review capacity
> 9. Explain what is realistically achievable within that timeframe.
> 10. If the timeline is generous, indicate that broader or deeper coverage is possible.
> 11. If the timeline is limited, identify:
> - which core concepts can realistically be covered
> - which important concepts are out of scope due to time constraints
> - what a minimum viable version of the course would look like
> 12. If the user does not provide materials, recommend a strong starter set of sources suited to the topic, current level, desired outcome, session length, study frequency, and deadline.
> 13. Confirm the final scope of the course before building it, while also proceeding provisionally if the user has left important but non-blocking details unspecified.
>
> ### Stage 2 - Course construction:
> Once the inputs, materials, and timeline are confirmed or provisionally established:
> 14. Calculate the total number of study sessions using:
> - the start date
> - the deadline
> - the number of sessions per week
> - the time available per session
> 15. Analyse all provided materials and identify the main themes, concepts, debates, methods, skills, and learning priorities.
> 16. Create a new syllabus organised around those themes and outcomes rather than simply reproducing any one source.
> 17. Sequence the course logically from foundational ideas to more advanced, specialised, or applied work.
> 18. Build a multi-modal course structure where appropriate. The syllabus may include reading, exercises, problem sets, writing tasks, concept reviews, practice tasks, mini-projects, case analysis, revision sessions, or other suitable learning modes.
> 19. Divide the course into sessions or modules that fit the user’s available session length and weekly study frequency.
> 20. Assign content proportionately so that each session has a realistic workload.
> 21. Include checkpoint sessions or milestone reviews at appropriate intervals.
> 22. Build a coherent self-guided learning pathway, not just a reading list.
>
> ### Context:
> This prompt is for creating self-guided courses on specific topics. The goal is not merely to summarise one book or prepare for one discussion session, but to design a structured syllabus that helps the user learn a topic independently over time.
>
> The course should adapt to the user’s real constraints:
> - their topic or question
> - their current level
> - their desired outcome
> - their available time per session
> - their study frequency
> - their start date
> - their deadline
> - the quality and quantity of their materials
> - any constraints or preferences
>
> The agent should think critically rather than mechanically. It should not assume that all provided materials are equally useful, nor that every desired learning goal is achievable within the available time. It must make reasoned judgments about scope, prioritisation, omissions, workload, sequencing, and course design.
>
> The agent must distinguish between topic coverage and learner outcome. Two users studying the same topic may need very different syllabi depending on whether their goal is broad literacy, critical analysis, exam preparation, practical application, research fluency, project completion, or operational competence.
>
> If materials are provided, use them as the primary source base for constructing the syllabus. Where appropriate, infer recurring themes across the materials and synthesise them into a clearer and more teachable structure than the original sources may provide. If the material set is too large to analyse fully, prioritise the most central, relevant, or high-value items and say so explicitly.
>
> ### Output:
> Provide the response in five parts.
>
> #### Part 1 - Input summary and assumptions
> Include:
> - a concise summary of the user’s goal
> - the required inputs received
> - any optional inputs received
> - any assumptions you made
> - which assumptions most affect the course design
>
> #### Part 2 - Assessment and feasibility review
> Before presenting the syllabus, include:
> - an assessment of the proposed timeline
> - the type of deadline and how it affects the course design
> - the start date used
> - the estimated total number of sessions
> - the estimated total study hours
> - a concrete workload estimate
> - a critical review of the provided materials
> - a list of recommended missing materials or source types, if relevant
> - a clear explanation of the final scope of the course and what will and will not be covered
> - a clear statement of what is realistically achievable by the deadline
>
> #### Part 3 - Design rationale
> In 3 to 5 sentences, explain why the course was structured this way. Clarify the logic behind the sequencing, exclusions, emphasis, modality choices, and pacing.
>
> #### Part 4 - Custom course syllabus
> Create a complete syllabus using the following structure:
>
> **Course Title:** Provide a clear and specific title.
> **Course Overview:** Briefly explain the overall aim of the course, the intended level, the main themes, and the intended learner outcome.
> **Learning Goals:** List the main things the user should be able to understand, analyse, compare, apply, explain, produce, or perform by the end of the course.
> **Course Structure:** Divide the course into modules or sessions based on the calculated number of study sessions.
> For each session include: **Session number: Title**
> **Focus:** State the central concept, problem, question, skill, or theme.
> **Mode:** State the main learning mode for the session, such as reading, practice, problem solving, writing, review, case analysis, or project work.
> **Why this matters:** Explain why this session is important within the wider course.
> **Materials:** List the relevant materials or activities for that session. If user-provided materials are used, refer specifically to them.
> **Key ideas:** Summarise the major concepts, arguments, methods, or skills covered in that session.
> **Study task:** Provide a concrete task such as close reading, note-making, problem solving, comparison, concept mapping, application exercise, mini-project work, or reflection.
> **Reflection question:** Include one strong question that helps the user think critically about the material.
> **Progression note:** Briefly explain how this session connects to the previous one or prepares for the next one.
> **Checkpoint:**
> At appropriate intervals, include a checkpoint session or checkpoint subsection stating:
> - what the learner should now be able to explain, compare, analyse, apply, or produce
> - what should be reviewed before moving on
> - whether pace adjustments are advisable
>
> #### Part 5 - Final synthesis
> At the end of the syllabus, include:
> - a short explanation of how the course progresses as a whole
> - any optional advanced topics for further study
> - any topics intentionally excluded because of time constraints
> - any recommended next step after the course, based on the learner outcome
>
> ### Output requirements:
> - Use plain text only
> - No icons or decorative symbols
> - The highest heading level used must be ##
> - Keep the structure clear, professional, and readable
> - Balance the workload realistically across sessions
> - Prioritise coherence, progression, feasibility, and learner outcome over completeness
> - If source materials are weak or incomplete, say so explicitly and compensate with well-justified recommendations
> - Do not simply summarise documents - synthesise them into a teachable course structure
> - Make clear which parts of the course rely on verified provided materials and which parts rely on external recommendations or provisional assumptions
>
> ### Source Verification Policy:
> Do not fabricate details about sources, including titles, authors, arguments, page ranges, editions, or coverage. When recommending new materials, distinguish clearly between verified provided sources and external recommended sources, and never present recommended sources as if they were already supplied or verified by the user.
>
> ### Suggested opening phrase for the agent:
> To build your custom self-guided course, I need five core things: the topic or question you want to learn, your current level, how much time you can spend per study session, how often you can study, and your target deadline. It also helps if you share any study materials you want me to use, such as syllabi, books, articles, or PDFs, and tell me what outcome you want by the end, such as general understanding, exam preparation, research competence, or practical application. In return, I will assess what is realistically achievable in your timeframe, review the quality and completeness of your materials, suggest important missing sources, and design a structured syllabus tailored to your goals.
<hr>
#### Obsidian Templates
> [!note]- Slipbox Permanent Note Template
>
> **Instructions:**
> Copy and paste this into a new note in Obsidian.
> Please see the instructions in these three videos:
> 1. Video 1 [tbc]
> 2. Video 2 [tbc]
> 3. Video 3 [tbc]
>
> **Template:**
> ```md
> ---
> created:
> category:
> Sources:
> REF link:
> URL:
> labels:
> ---
>
> ### Idea
> (Write one clear idea in your own words)
>
> ### Links
> -
>
> ## Quote
>
> ### Notes
> - Why this matters:
> - What it connects to:
> ```
<hr>
#### Anki Code Snippets
> [!note]- Creating Grid of Four Images in Your Anki Card
> Check our [YouTube video explainer!](https://www.youtube.com/watch?v=nxv0RU8uISs)
>
In your Card Template (Front or Back):
> \<div class="image-grid">
> \<img src="{{Image1}}">
> \<img src="{{Image2}}">
> \<img src="{{Image3}}">
> \<img src="{{Image4}}">
> \</div>
>
> Then in the Styling section:
>
> .image-grid {
> display: grid;
> grid-template-columns: 1fr 1fr;
> gap: 10px;
> max-width: 400px;
> }
>
> .image-grid img {
> width: 100%;
> height: auto;
> }
>
> Then your note type just needs fields like:
> Image1
> Image2
> Image3
> Image4
<hr>
#### Google Sheets Formulas
**Conditional Formatting for Highighting Duplicates**
Check our [YouTube video explainer!](https://www.youtube.com/watch?v=DsNdToRJ57M)
```text
=AND($A2<>"out", LEN(TRIM($J2))>0,
COUNTIFS(
ARRAYFORMULA(TRIM(LOWER($J$2:$J$2198))),
TRIM(LOWER($J2)),
$A$2:$A$2198,"<>out")>1)
```