Where your hours go, where your money goes, and whether the two agree
Ask a VTuber fan who their oshi is and they answer instantly. Ask which talent takes the largest share of what they spend and it becomes a guess — because the two halves of that question arrive through completely different doors. The attention is a stream you happened to be free for at eleven at night. The money is a membership that renewed quietly last Tuesday, a merch order from a drop announced mid-stream, a superchat you sent because a song landed. Neither leaves a record anywhere the other can see.
This workbook keeps both records and joins them.
What the join actually tells you
The Stream Log is your attention: who you watched, roughly how long, live or in the archive. The Support Log is your money: memberships and fan clubs converted onto one monthly scale, plus merch, voice packs, tickets and superchats. The Value tab puts them on the same row per talent and works out:
- Support per hour — what an hour of a talent’s streams really costs you
- Share of your hours against share of your money, each measured against your own totals
- The balance gap between them, in percentage points — the honest single number
- A plain-English reading — in balance, watching past paying, paying past watching, or the one worth acting on: paying, not watching
That last reading is the one the file exists to find. In the worked example it lands on a membership still billing at $4.99 a month with no hours logged against it inside the 90-day window. The same example shows most of the hours going to one talent while most of the money goes to a different one — which is the sort of thing a following hides from you until the two halves are on the same page.
It is not a budget, and it is not a telling-off
Nothing here says you spend too much. Supporting people whose work you enjoy is the point of the hobby, and a high support-per-hour figure on a talent whose concerts you go to is a fact rather than a failure. You may well look at it, see how much you watch someone for free, and decide to start a membership.
Their schedule, on your clock
VTuber schedules are published in whatever zone the talent posts in — Japan Standard Time for the major Japanese agencies, which is UTC+9 all year with no daylight saving, and local time for many English-language agencies and Western indies. Enter the date and time exactly as the announcement gives them, say which zone it used, and every row converts to your own clock and counts down.
That matters more than it sounds. Karaoke streams are often left unarchived, usually over music licensing: if you weren’t there live, there is nothing to catch up on. The countdown flags Today and This week rather than just showing a date, and ticketed events carry a cost and an access state so “need a ticket” never becomes “missed it”.
Eight tabs that talk to each other
- Oshi Roster — who you follow, by agency and the generation or wave they debuted with, with your tier, days following, a countdown to each debut anniversary, and a flag for whether you’re still watching or have quietly drifted
- Stream Log — the attention half, with the milestone streams marked so you can find the debut or the 3D reveal again
- Support Log — the money half. Log a membership once, on the day it started; it’s charged only for the days it was actually running inside your window
- Value — the join, with three thresholds you set
- Events & Debuts — any announcement zone converted to yours, counting down
- Agencies & Terms — the agency list that feeds the roster dropdown and rolls your hours and spending up per agency, plus 28 fandom terms explained
- Dashboard — the whole following on one screen, pulled live
- Read Me — a map of the tabs, and what to do first
Own it, don’t rent it
A blank spreadsheet gives you columns and no method. A fan-tracking app gives you a login, a subscription and a database you don’t control. This sits between them: the structure and the arithmetic already built, in a file you download once and keep. No account, no monthly fee, and no app deciding what counts as watching.
Opens in Excel, Google Sheets and LibreOffice Calc. The Google Sheets version is a ready-made native copy — click Make a copy and it lands in your Drive with every dropdown, color and live formula working. No importing, no repairing.
Try it free first
The free My Oshi List is a single pre-filled tab — talent, agency, tier and a following flag, with the counts computed for you. It’s the roster without the join. If it earns a place on your desktop, the full tracker adds the two logs, the support-per-hour engine, the agency rollup, the events clock and the glossary.
New to the format, or explaining it to someone who is? What is a VTuber? covers how agencies and indies differ and what the vocabulary means, free to read.
A note on what this is
This is a personal tracker, not financial advice, and it is not affiliated with, sponsored by, or endorsed by any VTuber agency, talent, or platform. Agency names appear only so you can label your own follows. The example talents and the two example agencies are invented placeholders, and every price in the example is an illustrative figure to be replaced with what your own statement says. Nothing here connects to your accounts — no logins or card numbers belong in the file.
