For automatic: → paste:
| A | B | C | D | E | F | G | |---|---|---|---|---|---|---| | | Episodes (Pace) | Runtime (hrs) | Status | Date Started | Date Completed | Notes | Step 2: Input the One Pace Arc List Here is the core data to copy into your sheet (based on the standard One Pace release order up to recent arcs). Fill columns A, B, and C. one pace google sheets
function onEdit(e) var range = e.range; var sheet = range.getSheet(); var col = range.getColumn(); var row = range.getRow(); if (col === 4 && row > 1) // Column D is Status sheet.getRange(row, 8).setValue(new Date()); // Column H gets today's date For automatic: → paste: | A | B
| Arc | Episodes (Pace) | Runtime (hrs) | Status | Date Started | Date Completed | Notes | |---|---|---|---|---|---|---| | Dressrosa | 48 | 21 | Completed | 2025-02-10 | 2025-03-01 | Skip original eps 630-700; much better pacing | Install Google Sheets on your phone. Pin the sheet to your home screen. After watching a batch of One Pace episodes, open the sheet, tap the arc’s Status dropdown, and change it. It takes 5 seconds and saves you from rewatching the same arc months later. Conclusion: One Pace fixes the anime; Google Sheets fixes your memory. With this setup, you’ll never ask “What arc was I on?” again. Enjoy your filler-free journey to Laugh Tale. Pin the sheet to your home screen
Why This Paper is Helpful One Pace is a fantastic resource for fans who want to experience One Piece closer to the manga’s pacing. However, because it’s a fan project distributed across torrents, Telegram, and various archives, it’s easy to lose track of which arcs you’ve watched, which episodes you’ve downloaded, or where you left off. Google Sheets solves this by offering a free, cloud-based, accessible-from-anywhere progress tracker. Part 1: Setting Up Your One Pace Tracker in Google Sheets Step 1: Create the Basic Structure Open Google Sheets and create a new spreadsheet. Name it One Pace Tracker - [Your Name] .
=SUMIF(D2:D28, "Completed", C2:C28) This shows total hours watched. Change "Completed" to "Watching" to see remaining runtime. In column H (add a header Last Activity ), use this script (requires Apps Script – simple version):