HSR planning

Overview

Two Excel workbooks I use for planning in Honkai: Star Rail. The pull sheet prices out a range of pull targets, once with the doubled anniversary top-up bonus and once at regular rates, and charts the two against each other. The second workbook records the teams that five AI assistants suggested, laid out in one table so they can be compared.

The problem

The same number of pulls costs a different amount depending on which top-up packs are bought and whether their first-purchase double bonus is still available. The pull sheet answers what a given target costs in each case.

What I did

• Built a "Spend Aniv" sheet with 30 pull targets, each with the jades gained, the pack combination to buy, the total cost and a cost-per-pull formula.
• Built a matching "Spend Reg" sheet for the same 30 targets at regular rates, with no double bonus.
• Added a milestone table to both, from E0 through S1 and up to E6, with cumulative pulls, estimated cost and cost per pull for each step.
• Added a "Comparison" sheet that pulls both cost-per-pull columns together by formula and sets the milestone costs side by side.
• Charted it: eight charts across the three sheets, covering cost against pulls, cost per pull, cost per milestone, and anniversary against regular.
• Made a separate "AI HSR Comparison" workbook with the teams suggested by Gemini, ChatGPT, Grok, DeepSeek and Copilot, three teams each, with role, character and notes per slot and columns for a score out of 10 and a total out of 30.

Stack

Microsoft Excel: formulas, cross-sheet references, scatter charts and a bar chart.

Outcome / impact

• The comparison shows a pull is cheapest while the double bonuses last, and gets steadily more expensive once they run out.
• At regular rates the cost of a pull stays roughly flat across the whole range.