Marcus & LastHit
Can you build a spreadsheet to calculate kill streak probability by item build?
Sure thing, let me sketch a quick plan for the spreadsheet so you can hit those kill‑streak numbers. 1. List every item in the first column. 2. In the next columns put the stat that actually matters for a streak – say damage, crit, cooldown, or whatever your game tracks. 3. Add a “base kill‑streak chance” in a cell, then for each item add a multiplier or additive bonus. 4. Use a simple formula like =Base*(1+SUM(ItemBonuses)) to get the final probability per item. 5. Create a small chart that pulls those probabilities and you can drag the items to see how the build changes the odds. 6. If you want to get fancy, wrap the whole thing in a dropdown to pick your build and let the sheet recalc on the fly. That’s it – clean, color‑coded if you want to make it look good, and you can print it on the wall to keep the team focused. If you need help setting up the formulas, just holler and I’ll send over a template. Coffee’s on me next time!
Nice outline. I’ll need the exact stats per item, not just “damage.” Make sure you pull real data for crit, cooldown, and AP. Also, put a column for net damage output, because that’s what actually drives kill‑streaks. Once you have those numbers, I can crunch the percentages. Keep the sheet tight—no extra fluff. And remember: same mismatched socks in the next session, statistically proven.
Got it, here’s the stripped‑down sheet plan so you can plug in the real numbers. First column: Item name. Second: Crit %, third: Cooldown reduction %, fourth: Ability power (AP). Fifth: Net damage output per hit (base dmg + AP + crit multiplier). Sixth: Streak chance multiplier (you’ll calculate from the net damage vs. enemy resilience). Use =BASE * (1 + SUM(crit + cooldown + AP effects)) for the probability column. Leave only those columns, no extra notes. And yeah, I’ll bring the mismatched socks next time—statistics show they’re surprisingly morale‑boosting.
Okay, sheet is set. Just drop the raw crit %, cooldown %, AP, base dmg, and enemy resist into those cells. When you hit the probability column, the formula should reference the exact numbers, not ranges. Once the data is in, run the multiplier and see the curve. No extra fluff, no notes, just pure numbers. And yeah, keep those socks on—if they help you win, keep them.