Properties XLS - for unit differentiation

Here talk about units and structures.
IMPORTANT!: Every unit type and structure type should be in a separate topic.
So if you have a new unit idea than open a new topic for it!
Stratego (dev)
Site Admin
Posts: 15741
Joined: Fri Apr 25, 2014 9:28 pm

Re: Properties XLS - for unit differentiation

Post by Stratego (dev) »

ok. i start putting in the japanese tanks into xls.
Stratego (dev)
Site Admin
Posts: 15741
Joined: Fri Apr 25, 2014 9:28 pm

Re: Properties XLS - for unit differentiation

Post by Stratego (dev) »

Japan tanks are in (HaGo and Ho Ni), also stats changed in game, uos 10

i have removed all images from this topic, and placed the latest into the first post.
also the latest xls.
Stratego (dev)
Site Admin
Posts: 15741
Joined: Fri Apr 25, 2014 9:28 pm

Re: Properties XLS - for unit differentiation

Post by Stratego (dev) »

ok, i start doing the howitzers into xls
Stratego (dev)
Site Admin
Posts: 15741
Joined: Fri Apr 25, 2014 9:28 pm

Re: Properties XLS - for unit differentiation

Post by Stratego (dev) »

ok, i did not do the howitzers, but the AA cannons.
here they are in first topic

changes uos 10
Prof_GamerARCHIVED
Posts: 571
Joined: Fri Feb 03, 2017 5:46 am
Location: Athens, Greece

Re: Properties XLS - for unit differentiation

Post by Prof_GamerARCHIVED »

Should i do the howitzers today?
Success is not final, failure is not fatal: it is the courage to continue that counts.
Stratego (dev)
Site Admin
Posts: 15741
Joined: Fri Apr 25, 2014 9:28 pm

Re: Properties XLS - for unit differentiation

Post by Stratego (dev) »

Would be cool! Thanks!
Stratego (dev)
Site Admin
Posts: 15741
Joined: Fri Apr 25, 2014 9:28 pm

Re: Properties XLS - for unit differentiation

Post by Stratego (dev) »

ok ,here i have a little time to do some - are you working on any of them?
Prof_GamerARCHIVED
Posts: 571
Joined: Fri Feb 03, 2017 5:46 am
Location: Athens, Greece

Re: Properties XLS - for unit differentiation

Post by Prof_GamerARCHIVED »

Daniel (the dev) wrote:ok ,here i have a little time to do some - are you working on any of them?
Im searching info about the howitzers to fill the xls
Success is not final, failure is not fatal: it is the courage to continue that counts.
Stratego (dev)
Site Admin
Posts: 15741
Joined: Fri Apr 25, 2014 9:28 pm

Re: Properties XLS - for unit differentiation

Post by Stratego (dev) »

cool!
than i am doing the field guns!
(dont forget not all in-game units listed in the current xls.)
Stratego (dev)
Site Admin
Posts: 15741
Joined: Fri Apr 25, 2014 9:28 pm

Re: Properties XLS - for unit differentiation

Post by Stratego (dev) »

(i edited the first post and started to put in the formulas decoded from XLS - for the forumers who are not familiar with XLS formulas)
Stratego (dev)
Site Admin
Posts: 15741
Joined: Fri Apr 25, 2014 9:28 pm

Re: Properties XLS - for unit differentiation

Post by Stratego (dev) »

xls and images updated.
new AT guns are in - also changed in game too, uos 10
(i just saw that AT guns already had 2 range of attack)
User avatar
samuelch
Posts: 1677
Joined: Thu May 01, 2014 7:43 am
Location: Batavia

Re: Properties XLS - for unit differentiation

Post by samuelch »

Howitzers added.
Attachments
stats_v7 (2).xlsx
(23.11 KiB) Downloaded 84 times
Stratego (dev)
Site Admin
Posts: 15741
Joined: Fri Apr 25, 2014 9:28 pm

Re: Properties XLS - for unit differentiation

Post by Stratego (dev) »

thanks,

you have not used the latest file, the columns are not fit.

i try to fix it.
Stratego (dev)
Site Admin
Posts: 15741
Joined: Fri Apr 25, 2014 9:28 pm

Re: Properties XLS - for unit differentiation

Post by Stratego (dev) »

ok, you have not looked for the new columns so we need those too, also you left a few cells empty, would you complete the blue section or shall i?
(however prof.gamer said hw will do this howitzer part today - but not yet reported any progress)

so
- we still need the wblue cells that are empty
- also the yellow ones filled up with current in-game values.

the latest version is in the FIRST post,
a) please modify that if you do the missing ones,
b) or tell me if i should go searching for the values on the net.

thanks.
Prof_GamerARCHIVED
Posts: 571
Joined: Fri Feb 03, 2017 5:46 am
Location: Athens, Greece

Re: Properties XLS - for unit differentiation

Post by Prof_GamerARCHIVED »

Eh, i was working on the howitzers... and i just finished them.
Success is not final, failure is not fatal: it is the courage to continue that counts.
Stratego (dev)
Site Admin
Posts: 15741
Joined: Fri Apr 25, 2014 9:28 pm

Re: Properties XLS - for unit differentiation

Post by Stratego (dev) »

good! send me please - so we have them completely i gues ! thanks!
User avatar
Puss_in_Boots
Posts: 3209
Joined: Fri Apr 21, 2017 1:23 am
Location: New Jersey

Re: Properties XLS - for unit differentiation

Post by Puss_in_Boots »

I shall do stats for the ship!
OLÉ
Stratego (dev)
Site Admin
Posts: 15741
Joined: Fri Apr 25, 2014 9:28 pm

Re: Properties XLS - for unit differentiation

Post by Stratego (dev) »

you mean fill up real values and current values to help defining a XLS formula?
or you would like to define the XLS formula
User avatar
Puss_in_Boots
Posts: 3209
Joined: Fri Apr 21, 2017 1:23 am
Location: New Jersey

Re: Properties XLS - for unit differentiation

Post by Puss_in_Boots »

I think I will define them.
OLÉ
Stratego (dev)
Site Admin
Posts: 15741
Joined: Fri Apr 25, 2014 9:28 pm

Re: Properties XLS - for unit differentiation

Post by Stratego (dev) »

cool, i will prepare the ships "sheet" for you and send you the empty "peach" clored columns to fill with formulae.

wait a few sec.
Prof_GamerARCHIVED
Posts: 571
Joined: Fri Feb 03, 2017 5:46 am
Location: Athens, Greece

Re: Properties XLS - for unit differentiation

Post by Prof_GamerARCHIVED »

Wow, if we keep this up we may have finished the game in a couple of months!
Success is not final, failure is not fatal: it is the courage to continue that counts.
Stratego (dev)
Site Admin
Posts: 15741
Joined: Fri Apr 25, 2014 9:28 pm

Re: Properties XLS - for unit differentiation

Post by Stratego (dev) »

Professional_Gamer wrote:Wow, if we keep this up we may have finished the game in a couple of months!
you are optimistic :)

puss in boots: i have prepared the attached xls for you.
- you can see the empty blue cells that needs research - you need to fill them up
- also you can come up new blue columns if you want any data to use in any formula
- you need to have the "peach" colored columns to fill up with formula, best if all rows have the same formula, but if you can only do that same for only ship classes that is also good (eg. one for battleships, and one for cruisers and so on)
Attachments
stats_v11.xlsx
(27.23 KiB) Downloaded 74 times
Stratego (dev)
Site Admin
Posts: 15741
Joined: Fri Apr 25, 2014 9:28 pm

Re: Properties XLS - for unit differentiation

Post by Stratego (dev) »

first topic updated with the latest XLS, with the HOWITZERS set (and now the game and XLS is in sync, uos)
Prof_GamerARCHIVED
Posts: 571
Joined: Fri Feb 03, 2017 5:46 am
Location: Athens, Greece

Re: Properties XLS - for unit differentiation

Post by Prof_GamerARCHIVED »

Did u check the xls file i sent u?
Success is not final, failure is not fatal: it is the courage to continue that counts.
Stratego (dev)
Site Admin
Posts: 15741
Joined: Fri Apr 25, 2014 9:28 pm

Re: Properties XLS - for unit differentiation

Post by Stratego (dev) »

xls updated in first post.
there the new bonus values for howitzers, they are red since the jsons have not yet been updated (some apprentices are working on some, also prof.gamer too )
Stratego (dev)
Site Admin
Posts: 15741
Joined: Fri Apr 25, 2014 9:28 pm

Re: Properties XLS - for unit differentiation

Post by Stratego (dev) »

is somebody working on the xls? (eg. on ships)
Prof_GamerARCHIVED
Posts: 571
Joined: Fri Feb 03, 2017 5:46 am
Location: Athens, Greece

Re: Properties XLS - for unit differentiation

Post by Prof_GamerARCHIVED »

Im going to finish the jsons you sent me today.
Success is not final, failure is not fatal: it is the courage to continue that counts.
Stratego (dev)
Site Admin
Posts: 15741
Joined: Fri Apr 25, 2014 9:28 pm

Re: Properties XLS - for unit differentiation

Post by Stratego (dev) »

new XL in forst post - with real properties of ships - thanks so Prof.Gamer!
Stratego (dev)
Site Admin
Posts: 15741
Joined: Fri Apr 25, 2014 9:28 pm

Re: Properties XLS - for unit differentiation

Post by Stratego (dev) »

also i have prepared the "planes section" so please fill the blue values (get the latest xls from first post)

thanks!
User avatar
samuelch
Posts: 1677
Joined: Thu May 01, 2014 7:43 am
Location: Batavia

Re: Properties XLS - for unit differentiation

Post by samuelch »

Planes
Attachments
stats_v14.xlsx
(31.11 KiB) Downloaded 68 times
Post Reply

Return to “Units & Structures (See Nations for accepted Unit nations)”