Posts from Information for moderators.

Exactly. And now the condition HP > 35 is taken into account, and everything is displayed correctly, as well as for the case when the number of summoned demons turned out to be greater than the maximum possible value. I didn't apply these conditions specifically for the summary table.
New version:

1. Why is there such a complex formula for calculating the number of demons based on pits? Why check HP? The maximum number of demons based on pits is OK(PRODUCT(pits;50)/35;1)), why is this formula not sufficient?
2. VLOOKUP limits the use to 6000; enter 6001 pits, and you will already get N/A. (with HP from 1 to 35)
3. Redundant "if" construction in calculating the number of demons. The structure looks something like this (I will describe it in the form of pseudocode for clarity):
IF (A>0 AND B>0)
{
IF (A>0)
{Return Formula1}
ELSE
{Return 0}
IF (B>0)
{Return Formula1}
ELSE
{Return 0}
}
ELSE
{Return 0}

4. In the large table (which shows the number of demons for the number of sacrifices from 1 to 600), there is no check for HP > 35... which is essentially an error.

PS: I couldn't figure out the last formula (for calculating the required number of sacrifices); it seems to be deliberately obfuscated :p, but it shows the style mentioned in point 3. It seems that you tested individual pieces of "if" statements and then inserted them inside others.

It would be better to create a table with values of 3000, 6000, 9000, 12500, and approximately how many monsters there could be.

In my opinion, that would be more useful.

You just missed the topic a little bit.

Nah, it's more like a subtle hint.

To be honest, I didn't quite understand the purpose of this thread either. It seems like many similar threads have emerged. Streams and online broadcasts are essentially the same thing, and these topics could be merged.

To be honest, I didn't understand the purpose of this thread either. It seems like many clone threads have emerged. Streams and online broadcasts are essentially the same thing and can be combined into a single thread.

I agree...

An interesting guide on strategy in Heroes III, in English. 65 pages.

This is definitely not a strategy guide – it's a decent description showcasing the main points; FizMig is much more comprehensive.

-"The algorithm for unit movement on the battlefield." - everything is explained))

There are clear algorithms.
......
If there are several units within reach that can be reached in the minimum number of turns, then many factors come into play, and I don't want to explain them in detail, such as the balance of power between the armies, the range of other units, the ratio of surrender/AI, the influence of already surrendered units, spells also have an influence, and spells originally affect two-cell units, such as the wall of fire, and the ballista has a very original effect on harpies, and so on.

:rolleyes:

Basically, I'm playing XL, 1vs7 against AI on 200% difficulty. I need a map template with a gold mine and strong/very strong monsters, without passages guarded by multiple groups of monsters, and without one-way teleporters. Usually, the monster value is 4, but is it possible to make it higher? Thanks in advance.

Vaflya, thank you, we'll give it a try.
*done. Great! --Speed! (c)=SSem

When playing, if the host has the Russian version, the player with the English version experiences font issues: hero names and city names are unreadable. Below is a file that resolves this issue, allowing the English version to display Russian fonts correctly.

The HD mod includes an optional package for recognizing Russian characters.

An interesting guide on strategy in Heroes III, in English. 65 pages.

Indeed interesting, it's a pity it's in English. But there are some inconsistencies with the official game mechanics – for example, the probability of spells appearing in the guild. Perhaps there's just a different calculation principle, but it could also be something else. Without a proper translation, it's difficult to understand right away.
It's interesting, which one is more accurate?

/Example:
Blue:
1. balance
Red:
2. 8mm6a
Blue:
3. 2SM4d(3)
Red:
4. Jebus cross
Blue:
5. skirmish
Red:
6. Diamond
This means we are playing on Mini-Nostalgia.

Favorites, to Battle! - 6 - The Battle of Favorites! - 6

Favorites, to Battle! - 6

It is time for another confrontation. We are set to fight for our favorite castle, prove its strength, and delight the viewers with interesting games and unconventional combinations. In this tournament, each player immediately chooses a race that they will play throughout the entire tournament.
The first such tournament took place in 2008.
No single castle and no single player has won twice. Necropolis, Conflux, Fortress, Castle, and Rampart have already been the best. How will it be now?

I. General questions.
1. Throughout the tournament, each participant plays as their chosen favorite race. If two identical races meet in a match, heroes are selected either by mutual agreement or randomly.
2. Game version SoD 3.2 (4.0), WT by mutual consent.
3. Rules are standard.
Any changes to the game rules are permitted by mutual agreement of the players, except for changing the Favorite Castle and the Fair Play rule.
4.Color in the bracket tables is for the first generation. Then colors change after each SUBJECTIVE restart.
5. The template selection is made by crossing out from a list of 7 templates: 2SM4d(3), Balance, Jebus cross, Mini-Nostalgia, 8mm6a, Diamond, and skirmish (at 200% difficulty). Blue starts crossing out the template.
By mutual agreement, playing on any other template is permitted. This matter must be discussed in advance with the tournament judges.

II. Organizational questions.
1. The tournament is official and regular.
2. Tournament goals:
- to play as a favorite castle and try to prove its strength,
- to gain valuable experience and improve one's level of play.
3. The tournament is conducted according to the Rules for organization, conduct, and participation in tournaments .
4. Players on the Blacklist are not allowed to participate in the tournament.
5. Hosts and judges: Gomunguls (ICQ: 499978341), Scorpiona (ICQ: 469326983) and Pit for LM (ICQ: 471401475).
Disputed issues between players are resolved by the hosts; disputed issues between players and hosts are resolved by AK.
Hosts have the right, if necessary, to make any changes to the regulations and rules during the tournament.
6. For each played match, participants must submit a report and confirmation in this thread.
7. Information on the progress of the tournament will be updated as needed and located at the beginning of this thread.
8. All tournament games go into the seasonal rating. The list of tournament reports will also be located at the beginning of this thread.
9. The tournament winner and players who take 2nd and 3rd place will be awarded Medals under their avatar.

III. Dates.
Registration - September 15 - October 9, 2013.
Draw - October 12, 2013.
The draw will be conducted taking into account the declared castle and the participant's level of play based on results from other tournaments.
Tournament start - October 12, 2013.

IV. Regulations.
Regulations will be determined after registration ends depending on the number of participants.
We plan, as usual, a group stage and playoffs.
Time limit for one game - 2 weeks.
Estimated duration of the tournament - 6 months.


Winners of previous "Favorites, to Battle!" tournaments:

"Favorites, to Battle! - 1" (2008) - Dudge (Necropolis) - Tournament History
"Favorites, to Battle! - 2" (2009) - Pit for LM (Conflux) - Tournament History
"Favorites, to Battle! - 3" (2010) - Сатир (Fortress) - Tournament History
"Favorites, to Battle! - 4" (2011) - Maretti (Castle) - Tournament History
"Favorites, to Battle! - 5" (2012-13) - GoD (Rampart) - Tournament History

Good luck to all!

So, the first thing we need to do is determine the tournament roster. Registration. Registration period: September 15 - October 9, 2013. Before registering for the tournament, each player must familiarize themselves with the information in the first post of the thread and consider whether everything suits them (rules, templates, deadlines, draw method, etc.) so as not to create problems for either opponents or organizers later. The application must include: - HW nickname - applications are accepted only from registered forum users, - Castle that you will play with throughout the tournament, - ICQ number - required, - Skype - desirable, - preferred time to play. A necessary (but not sufficient) requirement for participants: at least 5 official games on HW with players known on the forum. The list of players registered for the tournament will be located at the beginning of this thread. Due to the abundance of clones, each application will be considered individually. The organizers have the right to refuse participation to any player without publicly explaining the reasons. If you do not find yourself on the list, be sure to contact the organizers. Players known on other resources and with gaming experience, but new to HW, must inform the tournament organizers about themselves (the name of the resource and their nickname on it).

Dear friends! I invite you to take part in a traditional tournament: To take part in the tournament, please provide the following information: - nickname - favorite castle - ICQ number - Skype - preferable time for games 1. During the whole tournament, each participant plays for their chosen favorite town. If two similar towns meet, then players can come to a mutual agreement about starting heroes. If they cannot, heroes are set to random. 2. Rules for online games. 3. The color in the drawing tables is only for the first generation. After each no reason restart (only 111+111+111 or 111+112 or 113) colors must be swapped. 4. It is allowed to agree mutually on any rules changes except the change of favorite castle and Fair Play rule. 5. The game version is SoD 3.2 (4.0) + HDmod or under the mutual agreement terms - WT...

Templates.

The template for the game will be chosen by elimination procedure from the list of 5 templates: 8мм6а, 2SM4d(3), Jebus cross, Balance, Mini-Nostalgia. Blue player starts the procedure. Drawings and tournament system: Registration - September 15 - October 9, 2013. Tournament start - October 12, 2013. One game is played in 2 weeks. The tournament is official. The winner will be awarded with a medal under his avatar: The winners of previous "The Battle of Favourites!" tournaments: "The Battle of Favourites! - 1" (2008) - Dudge (Necropolis) - Tournament history "The Battle of Favourites! - 2" (2009) - Pit for LM (Conflux) - Tournament history "The Battle of Favourites! - 3" (2010) - Сатир (Fortress) - Tournament history "The Battle of Favourites! - 4" (2011) - Maretti (Castle) - Tournament history "The Battle of Favourites! - 5" (2012-13) - GoD (Rampart) - Tournament history Welcome to HeroesWorld!