Slitherine

Is there anywhere (apart from the game itself) where the different units to choose from in the various army lists are are listed? If yes, where?

Otherwise, I've made a simple list in Excel that can be filtered and in which it's thus possible to compare army lists, with the minimum and potential number of units for different number of force points. You can also check in which army lists certain units are included. It's all based on ArmyList.txt and the kind input from RBS (see below).

rbodleyscott wrote: ↑Sun Jun 28, 2020 4:10 pm

kronenblatt wrote: ↑Sun Jun 28, 2020 6:26 am In ArmyList.xlsx, the army list's units are specified with a MIN and a MAX, setting out "total (fixed + selection) quantity for 2000 point army".

1. How is that then adjusted and rounded for any other point of army, say 1200 point army: simply proportionally (multiplying each number with e.g. 1200/2000)?

This.

2. And how then rounded to integer values; always down, always up, or to nearest integer?

To nearest integer.

(With any floors (of say 1)?)

Floor of 1, with floor of 2 for core types in ally contingents.

Code: Select all

				StartWorkString(1);
				PrintWorkStringLiteral("MIN_", 1);
				PrintWorkStringInt(num, 1);
				min = FromFileGetValue(file, army, GetWorkString(1));
				min = ((min * points) + 1000) / 2000; // scale based on 2000 point army

				StartWorkString(1);
				PrintWorkStringLiteral("MAX_", 1);
				PrintWorkStringInt(num, 1);
				max = FromFileGetValue(file, army, GetWorkString(1));
				
				unadjustedMax = max; // v1.5.10 WatG addition	
				
				if (max > 0)
				{
					max = ((max * points) + 1000) / 2000 ; // scale based on 2000 point army

					// v1.5.10 WatG addition - to allow more than one unit of core types if their overall numbers in the allied list are not huge
					if (ally == 1)
						{
							if (max < 2)
								{
									max = (((unadjustedMax * points * 190) / 100) + 1000) / 2000;
									if (max > 2)
										{
											max = 2;
										}
								}
						}
					// End v1.5.10 WatG addition							
					
					if (max < min)
					{
						max = min;
					}
					if (max < 1)
					{
						max = 1;
					}
				}

Good job. Does it work fully with allies? I see you have them but the core list changes as well depending on the allies.

kronenblatt wrote: ↑Mon Jun 29, 2020 4:02 pm Is there anywhere (apart from the game itself) where the different units to choose from in the various army lists are are listed? If yes, where?

Otherwise, I've made a simple list in Excel that can be filtered and in which it's thus possible to compare army lists, with the minimum and potential number of units for different number of force points. You can also check in which army lists certain units are included. It's all based on ArmyList.xlsx and the kind input from RBS (see below).

rbodleyscott wrote: ↑Sun Jun 28, 2020 4:10 pm

kronenblatt wrote: ↑Sun Jun 28, 2020 6:26 am In ArmyList.xlsx, the army list's units are specified with a MIN and a MAX, setting out "total (fixed + selection) quantity for 2000 point army".

1. How is that then adjusted and rounded for any other point of army, say 1200 point army: simply proportionally (multiplying each number with e.g. 1200/2000)?

This.

2. And how then rounded to integer values; always down, always up, or to nearest integer?

To nearest integer.

(With any floors (of say 1)?)

Floor of 1, with floor of 2 for core types in ally contingents.

Code: Select all

				StartWorkString(1);
				PrintWorkStringLiteral("MIN_", 1);
				PrintWorkStringInt(num, 1);
				min = FromFileGetValue(file, army, GetWorkString(1));
				min = ((min * points) + 1000) / 2000; // scale based on 2000 point army

				StartWorkString(1);
				PrintWorkStringLiteral("MAX_", 1);
				PrintWorkStringInt(num, 1);
				max = FromFileGetValue(file, army, GetWorkString(1));
				
				unadjustedMax = max; // v1.5.10 WatG addition	
				
				if (max > 0)
				{
					max = ((max * points) + 1000) / 2000 ; // scale based on 2000 point army

					// v1.5.10 WatG addition - to allow more than one unit of core types if their overall numbers in the allied list are not huge
					if (ally == 1)
						{
							if (max < 2)
								{
									max = (((unadjustedMax * points * 190) / 100) + 1000) / 2000;
									if (max > 2)
										{
											max = 2;
										}
								}
						}
					// End v1.5.10 WatG addition							
					
					if (max < min)
					{
						max = min;
					}
					if (max < 1)
					{
						max = 1;
					}
				}

What is ArmyList.xlsx? Do you mean ArmyList.txt? That is where all the army list information for the game is held. It can be found in Field of Glory II/Core.

Here is an old post from Richard that explains how to read it:

viewtopic.php?f=492&t=79848

Paul59 wrote: ↑Mon Jun 29, 2020 8:02 pm

kronenblatt wrote: ↑Mon Jun 29, 2020 4:02 pm Is there anywhere (apart from the game itself) where the different units to choose from in the various army lists are are listed? If yes, where?

Otherwise, I've made a simple list in Excel that can be filtered and in which it's thus possible to compare army lists, with the minimum and potential number of units for different number of force points. You can also check in which army lists certain units are included. It's all based on ArmyList.xlsx and the kind input from RBS (see below).

rbodleyscott wrote: ↑Sun Jun 28, 2020 4:10 pm

This.



To nearest integer.



Floor of 1, with floor of 2 for core types in ally contingents.

Code: Select all

				StartWorkString(1);
				PrintWorkStringLiteral("MIN_", 1);
				PrintWorkStringInt(num, 1);
				min = FromFileGetValue(file, army, GetWorkString(1));
				min = ((min * points) + 1000) / 2000; // scale based on 2000 point army

				StartWorkString(1);
				PrintWorkStringLiteral("MAX_", 1);
				PrintWorkStringInt(num, 1);
				max = FromFileGetValue(file, army, GetWorkString(1));
				
				unadjustedMax = max; // v1.5.10 WatG addition	
				
				if (max > 0)
				{
					max = ((max * points) + 1000) / 2000 ; // scale based on 2000 point army

					// v1.5.10 WatG addition - to allow more than one unit of core types if their overall numbers in the allied list are not huge
					if (ally == 1)
						{
							if (max < 2)
								{
									max = (((unadjustedMax * points * 190) / 100) + 1000) / 2000;
									if (max > 2)
										{
											max = 2;
										}
								}
						}
					// End v1.5.10 WatG addition							
					
					if (max < min)
					{
						max = min;
					}
					if (max < 1)
					{
						max = 1;
					}
				}

What is ArmyList.xlsx? Do you mean ArmyList.txt? That is where all the army list information for the game is held. It can be found in Field of Glory II/Core.

Here is an old post from Richard that explains how to read it:

viewtopic.php?f=492&t=79848

Yep, that's right: ArmyList.txt. Apologies for confusion. Anyway: I've compiled the information therein into a hopefully more accessible excel spreadsheet that can be filtered.

SLancaster wrote: ↑Mon Jun 29, 2020 7:49 pm Good job. Does it work fully with allies? I see you have them but the core list changes as well depending on the allies.

Not fully, at least not yet. But possibly, if I could understand inter alia the following better:
1 Are only the core units of an ally available?
2 How and where is it distinguished which units are core and which aren't?

Because RBS spoke about core types in allies too.

kronenblatt wrote: ↑Mon Jun 29, 2020 8:12 pm

SLancaster wrote: ↑Mon Jun 29, 2020 7:49 pm Good job. Does it work fully with allies? I see you have them but the core list changes as well depending on the allies.

Not fully, at least not yet. But possibly, if I could understand inter alia the following better:
1 Are only the core units of an ally available?
2 How and where is it distinguished which units are core and which aren't?

Because RBS spoke about core types in allies too.

It uses the usual scaling with allies getting 25% of the total points and main army getting 75% of the total points.

Then there is an adjustment to boost the more common types in the ally contingent to be allowed at least 2 units. This also scales, but as an example, in a 1200 point army, if the max of a unit in the allied army list was 6, the ally would (without the adjustment) only be allowed 1 unit, but with the adjustment they will be allowed 2. If the max in the allied list was 5 or less, they would only be allowed 1, even with the adjustment.

rbodleyscott wrote: ↑Tue Jun 30, 2020 6:44 am

kronenblatt wrote: ↑Mon Jun 29, 2020 8:12 pm

SLancaster wrote: ↑Mon Jun 29, 2020 7:49 pm Good job. Does it work fully with allies? I see you have them but the core list changes as well depending on the allies.

Not fully, at least not yet. But possibly, if I could understand inter alia the following better:
1 Are only the core units of an ally available?
2 How and where is it distinguished which units are core and which aren't?

Because RBS spoke about core types in allies too.

It uses the usual scaling with allies getting 25% of the total points and main army getting 75% of the total points.

Then there is an adjustment to boost the more common types in the ally contingent to be allowed at least 2 units. This also scales, but as an example, in a 1200 point army, if the max of a unit in the allied army list was 6, the ally would (without the adjustment) only be allowed 1 unit, but with the adjustment they will be allowed 2. If the max in the allied list was 5 or less, they would only be allowed 1, even with the adjustment.

Thanks Richard. So all units in the ally army list are available to choose from (i.e., always at least 1 from each unit)? But those that are "common" (core?), i.e., with higher number in the ally army list; may be available in higher number too (potentially 2)?

Also, with certain allies you lose out on a few units. Perhaps you get three lancers ordinarily but if with a certain ally you only get two including the ally list. I think this is true..

kronenblatt wrote: ↑Tue Jun 30, 2020 7:26 am

rbodleyscott wrote: ↑Tue Jun 30, 2020 6:44 am

kronenblatt wrote: ↑Mon Jun 29, 2020 8:12 pm

Not fully, at least not yet. But possibly, if I could understand inter alia the following better:
1 Are only the core units of an ally available?
2 How and where is it distinguished which units are core and which aren't?

Because RBS spoke about core types in allies too.

It uses the usual scaling with allies getting 25% of the total points and main army getting 75% of the total points.

Then there is an adjustment to boost the more common types in the ally contingent to be allowed at least 2 units. This also scales, but as an example, in a 1200 point army, if the max of a unit in the allied army list was 6, the ally would (without the adjustment) only be allowed 1 unit, but with the adjustment they will be allowed 2. If the max in the allied list was 5 or less, they would only be allowed 1, even with the adjustment.

Thanks Richard. So all units in the ally army list are available to choose from (i.e., always at least 1 from each unit)? But those that are "common" (core?), i.e., with higher number in the ally army list; may be available in higher number too (potentially 2)?

Pretty much, although if the numbers in the allied list are high enough, there may be many more than 2.

Also if the unit has

NOT_ALLY_n

in the army list, it is excluded from ally contingents.

However, currently the only units this applies to are Praetorian Guard.

SLancaster wrote: ↑Tue Jun 30, 2020 7:38 am Also, with certain allies you lose out on a few units. Perhaps you get three lancers ordinarily but if with a certain ally you only get two including the ally list. I think this is true..

That applies to all armies with allies. It is because the main list is scaled to 75% of the total points.

Here's the latest version of the Excel file in question, also showing which allies an army list can have, but not taking ally units into consideration:

DOWNLOAD

The OPT column shows how many units in addition to the MINimum that are available. Have compared to some army lists in-game for different force points and they seem to be correctly calculated. (Although I found a discrepancy in one of the Achaemenid army lists, for a unit of which there was plentiful: should have been 18 but showed 14, or the other way around.)

Please let me know what you think. Thanks.

This updated spreadsheet now also calculates the number of units, if having an ally (it's in tab 'Army' whereas all army lists are in tab 'Armies'). It now seems to make correct calculations:

DOWNLOAD

So in tab 'Army', select an army in the dropdown list of cell B2, then (if you want to) an ally army in the dropdown list of cell B3 (empty cell B3 if you want no ally), and finally enter number of force points available to the army as a whole in cell K1 (K1:N1). The list of units available should then be presented in columns I to N of tab 'Army'.

Again, please let me all know what you think. Enjoy and thanks.