Тёмный

Spreadsheet Emblem: Combat Effectiveness 

Excelblem
Подписаться 47 тыс.
Просмотров 27 тыс.
50% 1

I invent a problem and then make a spreadsheet to solve it. Establishing methods for use in later analysis.
Support me on Patreon: / excelblem
Twitter: / excelblem
Subscribe: / @excelblem
#FireEmblem

Игры

Опубликовано:

 

25 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 74   
@kafkeinated
@kafkeinated 3 года назад
I like how Excelblem's first video is about helping people know and learn what makes a unit good... And now he is showing us how to kill your character in every funniest way possible.
@maltheopia
@maltheopia 2 года назад
Those are the same thing. Now that you know the good units, or just how many good units you need to beat the game, you can maximize your DPR (Deaths Per Run).
@brozomicki-sothe307
@brozomicki-sothe307 2 года назад
He wanted to show which units are harder to kill
@MarlowPreston
@MarlowPreston 2 года назад
Went from this innocent start to accepting hundreds in blood money on stream in just 10 months. Excellent character development.
@PERSONTHATISCLEVER
@PERSONTHATISCLEVER 3 года назад
You've lulled us in with the memes, only to hit us with the analysis. You're jokes are good but I hope you continue some of the strategic analysis like this too.
@Excelblem
@Excelblem 3 года назад
Thanks! My first "funny video" was actually intended to be a clip for my next video essay, but it got popular on its own so I just decided to run with it. I've been working on follow-ups to this video behind my more humorous daily uploads, so stay tuned.
@DefaultMushroom
@DefaultMushroom 3 года назад
I’ve been watching your memes for a few weeks without even questioning why your name has Excel in it lol
@PeevedLatias
@PeevedLatias 3 года назад
This is excellent and tickles the spreadsheet enthusiast inside of me.
@ChrisTheFields
@ChrisTheFields 3 года назад
This is an insane amount of work. I'm very interested to see how you interpret this data in the future.
@Excelblem
@Excelblem 3 года назад
Thanks, that means a lot! I've got some concepts I'd like to introduce that I think will prove pretty interesting.
@m0nkEz
@m0nkEz Год назад
Excelblem 2 years ago: a unit is good when they kill things without dying Excelblem today: a unit is bad if it doesn't die
@murderedx8018
@murderedx8018 3 года назад
I like how serious this video is and then the other video like this is just, how to maximize player casualties
@MemeMuseum23
@MemeMuseum23 3 года назад
Oh yeah, it’s big brain time
@n00b614
@n00b614 3 года назад
I've only played a few Fire Emblem games casually and am not super well-versed on their inner mechanics, and would likely be categorized as one of those isolated primitive apes that would say something like "Amelia is good" because I tend to use units simply based on whether or not I like the character. That said, though I don't quite understand everything, I can recognize and respect the sheer amount of effort that went into creating that spreadsheet, and your presentation was executed well enough to captivate my attention despite my limited understanding, so I subscribed on the spot. I'm absolutely fascinated by this project, and can't wait to see what conclusions you draw from this, and if it ever gets a public release, I'd love to go over it and learn how it works/what it all means. Keep up the good work!
@keldeo05
@keldeo05 3 года назад
I'd love to be able to see a tier list strictly using this spreadsheet for the parameters
@sed1589
@sed1589 3 года назад
3:50 he goes through every unit before deciding to drop the seth bomb
@vishuprathikanti9352
@vishuprathikanti9352 3 года назад
Sounds very promising! I'm kinda curious about Franz's combat compared to Seth's. Obviously seth starts out better but I feel like Franz scales with enemy units quite well, so I'm curious to see what that'd look like.
@tim0boy891
@tim0boy891 Год назад
Rare moment when RU-vid recommends the very first video of a RU-vid channel to me.
@naruceleste3591
@naruceleste3591 Год назад
a fascinating thing that I personally don't notice much in terms of unit analysis is also the question of: How well does the unit synergize with the REST of your army? Maybe it's the yu-gi-oh brain that actively looks for combos and ways to make things stronger or at least more consistent, but I feel like it's important to factor in units who have roles that isn't 100% going to be combat. Obviously cases like dancing units or especially early-game healers fall under this, but also how is the character's movement compared to everyone else? If they're lagging behind, godly stats that make them immune to everything and instantly one-shot everything doesn't really help much. Meanwhile a cavalier or flier with decent stats who's able to run ahead and guarantee that the village with Item You Want doesn't get destroyed is substantially more valuable despite having a very narrow immediate combat application.
@gratedshtick
@gratedshtick 3 года назад
What an incredible video, it should get more attention tbh.
@cobaltpenguin
@cobaltpenguin 3 года назад
Awesome video! As a fan of both fire emblem and stats, it's great to see a combination of the two.
@Zutip
@Zutip 3 года назад
Very interesting, please show more insights!
@marcoasturias8520
@marcoasturias8520 3 года назад
I'd love to be able to have a look at that spreadsheet!
@upsidedownman256
@upsidedownman256 3 года назад
This is fantastic. Well done, you madlad.
@pinkstarmona1695
@pinkstarmona1695 Год назад
I love how a 1% altered the whole trajectory of your channel
@SirVyre
@SirVyre 9 месяцев назад
I got recommended the Excelblem trainee arc, neat!
@mannersworld
@mannersworld 3 года назад
I came here to subscribe for the means but this, this is some quality content.
@darcyscott1750
@darcyscott1750 3 года назад
I can't help but to think you're neglecting a few aspects. Why not code up a simulator that does thousands of trials for each unit against each enemy? That way, you'd also be accounting for crit, hit/miss, ect. You'd also get experimental results that you can then perform more detailed statistical analysis on. E.g. - rather than X unit defeats Y unit in one round, you'd have X unit defeats Y unit in one round with probability x.
@Excelblem
@Excelblem 3 года назад
Excellent points. This is something I'm working on at the moment! Though, I would like to note that it may not be necessary to do simulations to find those probabilities. Given all the combat parameters, I'm working on a method to model it using probability distributions.
@youngnigar525
@youngnigar525 3 года назад
@@Excelblem u make amazing content
@GeorgisTrying
@GeorgisTrying 3 года назад
Praise the spreadsheet. Don't stop the statistics my lad
@nintonintendo1
@nintonintendo1 Год назад
The beginning, the chapter 1, the prologue of a legend.
@AlexaRobin21
@AlexaRobin21 3 года назад
Hope to see more unit analysis soon.
@Leelee-Brown
@Leelee-Brown 3 года назад
Is this your only video like this? I absolutely love this, show me more of your spreadsheets!!
@thehuffpuff10
@thehuffpuff10 Год назад
Wow this is your first ever youtube video. I've been binge watch your content and this is crazy to see your growth.
@MerlockTheGreat
@MerlockTheGreat 3 года назад
Amelia is good, she kils anyting and wouldn't die
@ericd1022
@ericd1022 9 месяцев назад
Ah yes, the one that started it all
@SumDonuts
@SumDonuts 3 года назад
Do you have this spreadsheet available at all? I was inspired by this video and have gathered all Enemy data for FE7 Lyn and Eliwood Normal Mode and am currently in the process of gathering it for Hector Normal Mode. I plan to get it for their respective Hard Modes as well. And eventually for all of the games within the series.
@Noahs_Chair
@Noahs_Chair 2 года назад
You are the most heroic mad man I ever seen
@MarceloKatayama
@MarceloKatayama 3 года назад
One question, how could we factor move and the ease at which a unit could get stronger (basically by getting to certain places with enemies quickly, or having augmented exp gain) into the average score of the unit? This project seems like a lot of hard work, so I wanted to congratulate you and ask if you have something in mind for accounting to the things I pointed out above.
@Excelblem
@Excelblem 3 года назад
Movement is tricky, since so much of its usefulness is so context-depend and is fairly independent of your unit's combat performance. As for boosted XP gain, I've already implemented a bit of a prototype solution in this video, where I estimate an expected level for the unit at the start of a chapter, giving lower level units more levels per chapter. It's not perfect, though, and I have been working on other implementations, including a xp gain calculator from the average enemy and from the boss for each chapter.
@michaelsubroto5563
@michaelsubroto5563 3 года назад
@@Excelblem I think Amelia is very good if you put much effort into her and upgrade her to General which is her best class, i used her in final game and she is practically invinsible though being liability in the first chapters since Gheb/ Binks (depending on route).
@athath2010
@athath2010 2 года назад
@@michaelsubroto5563 ANY unit (except, like, a dragonstone-less manakete) can be good if you dump everything you have into them- the real question is how much you need to dump into them to make them good. If your goal is just to get a unit with high def for the novelty factor (which probably means that you don't want TWO high def units), Gilliam is leagues ahead of Amelia- an average 10/4 Knight Amelia has less def than a base level Gilliam (7.6 vs. 9) and a much worse def growth than Gilliam (30% vs. 55%), and Gilliam has way more time to train (and has an easier time training) than Amelia does. This means that an average Gilliam needs less effort and a smaller time investment than an average Amelia needs to reach the funny klink thresholds (because let's be real here, the only reason you're fielding a General is to see those "No Damage!" pop ups), making him the superior General. That's not to say that you can't use both, but I think the novelty factor wears off faster if you have two Knights/Generals instead of one. Amelia is much better off as a Paladin, a class which is much better suited to her growths and is less impaired by (and in fact synergizes with) redundancy. In fe8, your growth rates aren't affected by your class, so the difference in def between a General Amelia and a Paladin Amelia is only 4 points- just because General!Amelia's sprite LOOKS heavily armored doesn't mean that she actually IS heavily armored.
@enigmaze7489
@enigmaze7489 Год назад
"Rather than doing some tedious math," he creates an omega spreadsheet that took several months of work. Lol. Truly a Pog Champ moment. (P.S. looking back at the origins of Excelbm for funsies now that the "FE Engage Ironman Maddening run!" is over).
@gagolas2267
@gagolas2267 Год назад
wow this was your first video? I finally see why you are named that way XD.
@RGBredgreenblue
@RGBredgreenblue Год назад
I'm not using Excel for games yet tho. Not enough time to making excel sheets dayo...
@Erikuzuma
@Erikuzuma Год назад
It's worth noting that Amelia is very likely to lv up *more* than twice per chapter for the first few chapters.
@sigmundsoldier
@sigmundsoldier 3 года назад
Nice
@reddeckwins8696
@reddeckwins8696 Год назад
goat
@ZergYinYang
@ZergYinYang 2 месяца назад
Good vid.
@lanceknightmare
@lanceknightmare 2 года назад
When it comes to Vaike in Awakening, he has a max strength of 51 as a Warrior or 52 as a Barbarian, Bassilio can also reach this strength number. These two units in the chapter they are introduced in fall into the 1 to 2 round category for defense in Lunatic. Though, are far more viable in lower difficulties. This makes the children of Vaike and Bassilio the strongest Barbarians or Warriors possible in Awakening.
@goncalocarneiro3043
@goncalocarneiro3043 3 года назад
Damn, I really wanted to see Forde.
@mtk77621
@mtk77621 Год назад
updated version for 0 strength?
@loudradialem5233
@loudradialem5233 3 года назад
Very interesting! After you finish with Sacred Stones, how difficult would it be to make spreadsheets to the other games?
@silversword404
@silversword404 Год назад
You should try to add a purple line to the graph to represent the average between the offense and defense score
@joshmcgoo
@joshmcgoo 3 года назад
correct answer is "a mount that fly"
@degreeskelvin3025
@degreeskelvin3025 Год назад
I like how this was just an elaborate way to say "Seth good, Amelia bad". But where is that spreadsheet though?
@RGBredgreenblue
@RGBredgreenblue Год назад
It's not only about spreadsheet. It's about comparing not only Current run units, but each Current situation on each chapter
@degreeskelvin3025
@degreeskelvin3025 Год назад
@@RGBredgreenblue yeah, but i wanna have that spreadsheet so i can compare the data of other characters but theres no link
@RGBredgreenblue
@RGBredgreenblue Год назад
@@degreeskelvin3025 ok
@austinhensley6553
@austinhensley6553 9 месяцев назад
A good combat unit has good enough stats, the best weapon type for the game, and 999999 movement so it will actually see combat
@lagspike7763
@lagspike7763 Год назад
Excel where's the Duessel graph I need to see it
@bleh22
@bleh22 3 года назад
I don't care about stats that much. Waifus first, power second
@quinnlee-miller9792
@quinnlee-miller9792 Год назад
Amelia in Ephraim route is easier to train imo, and more useful, given the big maps
@misterbadguy7325
@misterbadguy7325 3 года назад
Did you post this spreadsheet somewhere?
@Excelblem
@Excelblem 3 года назад
Not yet. There's still a lot I want to add to it at the moment, so it'll be a while before I release it publicly.
@maxusheracross9928
@maxusheracross9928 2 года назад
You know sometimes I forget how insanely good at FE Excelblem is. It's kinda wack ngl
@chaincat33
@chaincat33 2 года назад
Amelia is good as super trainee, at least, and decent as paladin
@TheScribeScribe
@TheScribeScribe 2 года назад
Amelia is good. She kills everything and dies a lot.
@demityrant1784
@demityrant1784 2 года назад
I can't help but assume this video came about from some poor fool uttering the words: "Amelia is good" and it made you seethe. I would too, don't worry.
@habddz
@habddz 2 года назад
20 def unit. "Enough speed to not be double". Must be a lance/axe user.
@Insulted25
@Insulted25 3 года назад
When your first video is a serious analysis and the rest of your videos are shitposts.
@generalforsythe3944
@generalforsythe3944 2 года назад
As a Fire Emblem 7 player that prefers Advance Wars, I say, where’s the Advance Wars
@thelastgogeta
@thelastgogeta 2 года назад
It'll happen before Codename S.T.E.A.M.
Далее
Efficiency vs Optimality in Fire Emblem Challenge runs
11:12
Выпускаем трек? #iribaby
00:14
Просмотров 494 тыс.
I Rebalanced Fire Emblem The Sacred Stones
28:11
Просмотров 23 тыс.
Minimalist Kaizo Emblem 1 Hour Challenge
2:12
How to beat Fire Emblem 11 in the worst way possible
22:50
Fire Emblem ROMHacks: An Overview
6:33
Просмотров 48 тыс.
How Axes Went From Zero to Hero in Fire Emblem
25:06
Просмотров 68 тыс.