Hello.
Iv been playing Master of Magic for a long time, and iv been nerding around whit the game information, playing whit it in Excel, allmost tought about makeing a for fun Excel variant in vba :P
I did post a Excel sheet displaying some unit statistics, Level and race just for interest (but it was apparently gone today?).
In anycase im a vba programmer and i like to have some fun whit interesting systems, and til this day i havent found a better system for combat fun
Tought i do like how warhammer(&40k) Plays out too, whit a Maximum ammount of rounds and the one whit most score wins ect and how units shot\act ect.
Master of Magic combat is interesting for me on the basic Level where all units basicly starts whit 30% chance to hit, and then 30% chance to Block that hit whit any Shields avable per unit then that unit starts loseing Health then repeat Next units Shield and Health til all damage has been dealt.
The Magic system is also well made whit the resistance where one roll determines the Whole thing, but it kinda fails flat late game where the damage or the Magic penetration doesnt quite cut it to make most of the Magics worthwhile, and some just ignore the flaws like Call of crack dat Magic reist that has a flat chance of destroying unit on ground.
I have been working my Math on the problem itself and as far as i can tell, the Magic resistances Works, its just that resistance itself isnt balanced for Level, InFact it shouldnt be increased based on Level.
I mean a recruit halfling has 7 resistance, wich means all Magic attacks that doesnt have a penetration to it, only has about 30% to actualy succeed.. and that itself is fine, it Works in normal combat whit 30%, and startoutspells in the game has decent damage for that 30%, or and one can invest in a single target spell for penetration (and thats costy, whiout increaseing the spell damage.. wich makes it borderline, but its good for just penetrating that single hero resistance to damage it).
But if you look at halfling elite, they got 100% Magic resist.. now its immune to all but those spells you invest extra penetration in, and most splash spells.
(on recruit Level, the 30% chance whit some of the splash spells, theyr barely cost effective exept for beeing like a regular attack that doesnt let any of Your units get hurt.. and again thats fine.).
I have tried to make work arounds for this problem in Excel by running segmented tests on different resistances, and maybe allowing sorta like a Shield blocking system, but that doesnt represent Magic very well, some tests Works better, but on avarge the best one iv tested after 10000 combat cycles whit 50 in Magic skill, is that units or at least regular units shouldnt gain resist on Level up and eventualy become more or less immune. (not heroes seeing you kinda want too invest in penetration there to damage said hero).
That will also Balance out spellcasters like wizards whit Fireball, it will actualy become usefull, more than a regular attack because it attacks all the units in the stack, and one can actualy nerf doombolt too.
This was the main reson i uploaded the Excel sheet to show People just the basics of the game, the stat makeup of basic troops, and hopefully my NeXT upload of same sheet where i make combat between 2 units possible, including spellcasting possible from skill and a few choises of Magic, and my long time goal just for the lols, is makeing a Excel sheet work as overview map whit movement included, so one can try to make hit and run tactics and make troll regeneration some time to shine.
Ill add this questionmark to is it allowed to post Excel sheets? seeing my last one disappeard, or is it against form rules to display game content or simular, i will make you note that my Works are just for fun and Learning, and i would never take Money for my Works or and formulas.
Iam basicly doing all the work, and you get the more fun Things to play whit.
Iv been playing Master of Magic for a long time, and iv been nerding around whit the game information, playing whit it in Excel, allmost tought about makeing a for fun Excel variant in vba :P
I did post a Excel sheet displaying some unit statistics, Level and race just for interest (but it was apparently gone today?).
In anycase im a vba programmer and i like to have some fun whit interesting systems, and til this day i havent found a better system for combat fun
Tought i do like how warhammer(&40k) Plays out too, whit a Maximum ammount of rounds and the one whit most score wins ect and how units shot\act ect.
Master of Magic combat is interesting for me on the basic Level where all units basicly starts whit 30% chance to hit, and then 30% chance to Block that hit whit any Shields avable per unit then that unit starts loseing Health then repeat Next units Shield and Health til all damage has been dealt.
The Magic system is also well made whit the resistance where one roll determines the Whole thing, but it kinda fails flat late game where the damage or the Magic penetration doesnt quite cut it to make most of the Magics worthwhile, and some just ignore the flaws like Call of crack dat Magic reist that has a flat chance of destroying unit on ground.
I have been working my Math on the problem itself and as far as i can tell, the Magic resistances Works, its just that resistance itself isnt balanced for Level, InFact it shouldnt be increased based on Level.
I mean a recruit halfling has 7 resistance, wich means all Magic attacks that doesnt have a penetration to it, only has about 30% to actualy succeed.. and that itself is fine, it Works in normal combat whit 30%, and startoutspells in the game has decent damage for that 30%, or and one can invest in a single target spell for penetration (and thats costy, whiout increaseing the spell damage.. wich makes it borderline, but its good for just penetrating that single hero resistance to damage it).
But if you look at halfling elite, they got 100% Magic resist.. now its immune to all but those spells you invest extra penetration in, and most splash spells.
(on recruit Level, the 30% chance whit some of the splash spells, theyr barely cost effective exept for beeing like a regular attack that doesnt let any of Your units get hurt.. and again thats fine.).
I have tried to make work arounds for this problem in Excel by running segmented tests on different resistances, and maybe allowing sorta like a Shield blocking system, but that doesnt represent Magic very well, some tests Works better, but on avarge the best one iv tested after 10000 combat cycles whit 50 in Magic skill, is that units or at least regular units shouldnt gain resist on Level up and eventualy become more or less immune. (not heroes seeing you kinda want too invest in penetration there to damage said hero).
That will also Balance out spellcasters like wizards whit Fireball, it will actualy become usefull, more than a regular attack because it attacks all the units in the stack, and one can actualy nerf doombolt too.
This was the main reson i uploaded the Excel sheet to show People just the basics of the game, the stat makeup of basic troops, and hopefully my NeXT upload of same sheet where i make combat between 2 units possible, including spellcasting possible from skill and a few choises of Magic, and my long time goal just for the lols, is makeing a Excel sheet work as overview map whit movement included, so one can try to make hit and run tactics and make troll regeneration some time to shine.
Ill add this questionmark to is it allowed to post Excel sheets? seeing my last one disappeard, or is it against form rules to display game content or simular, i will make you note that my Works are just for fun and Learning, and i would never take Money for my Works or and formulas.
Iam basicly doing all the work, and you get the more fun Things to play whit.
