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: 9392
Joined: Fri Apr 25, 2014 9:28 pm

Re: Properties XLS - for unit differentiation

Post by Stratego (dev) » Sun Sep 17, 2017 6:42 pm

ok. i start putting in the japanese tanks into xls.

Stratego (dev)
Site Admin
Posts: 9392
Joined: Fri Apr 25, 2014 9:28 pm

Re: Properties XLS - for unit differentiation

Post by Stratego (dev) » Sun Sep 17, 2017 8:01 pm

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: 9392
Joined: Fri Apr 25, 2014 9:28 pm

Re: Properties XLS - for unit differentiation

Post by Stratego (dev) » Mon Sep 18, 2017 7:08 pm

ok, i start doing the howitzers into xls

Stratego (dev)
Site Admin
Posts: 9392
Joined: Fri Apr 25, 2014 9:28 pm

Re: Properties XLS - for unit differentiation

Post by Stratego (dev) » Mon Sep 18, 2017 8:35 pm

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 » Tue Sep 19, 2017 4:24 am

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: 9392
Joined: Fri Apr 25, 2014 9:28 pm

Re: Properties XLS - for unit differentiation

Post by Stratego (dev) » Tue Sep 19, 2017 4:40 am

Would be cool! Thanks!

Stratego (dev)
Site Admin
Posts: 9392
Joined: Fri Apr 25, 2014 9:28 pm

Re: Properties XLS - for unit differentiation

Post by Stratego (dev) » Tue Sep 19, 2017 4:25 pm

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 » Tue Sep 19, 2017 5:26 pm

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: 9392
Joined: Fri Apr 25, 2014 9:28 pm

Re: Properties XLS - for unit differentiation

Post by Stratego (dev) » Tue Sep 19, 2017 6:06 pm

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: 9392
Joined: Fri Apr 25, 2014 9:28 pm

Re: Properties XLS - for unit differentiation

Post by Stratego (dev) » Tue Sep 19, 2017 7:41 pm

(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: 9392
Joined: Fri Apr 25, 2014 9:28 pm

Re: Properties XLS - for unit differentiation

Post by Stratego (dev) » Tue Sep 19, 2017 7:53 pm

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: 1605
Joined: Thu May 01, 2014 7:43 am
Location: Batavia

Re: Properties XLS - for unit differentiation

Post by samuelch » Wed Sep 20, 2017 4:43 pm

Howitzers added.
Attachments
stats_v7 (2).xlsx
(23.11 KiB) Downloaded 29 times
My pfp is made by Chiefchirpa.
Hugs and love FUR eFURRYone!Murr

Stratego (dev)
Site Admin
Posts: 9392
Joined: Fri Apr 25, 2014 9:28 pm

Re: Properties XLS - for unit differentiation

Post by Stratego (dev) » Wed Sep 20, 2017 5:33 pm

thanks,

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

i try to fix it.

Stratego (dev)
Site Admin
Posts: 9392
Joined: Fri Apr 25, 2014 9:28 pm

Re: Properties XLS - for unit differentiation

Post by Stratego (dev) » Wed Sep 20, 2017 5:39 pm

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 » Wed Sep 20, 2017 7:08 pm

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: 9392
Joined: Fri Apr 25, 2014 9:28 pm

Re: Properties XLS - for unit differentiation

Post by Stratego (dev) » Wed Sep 20, 2017 7:48 pm

good! send me please - so we have them completely i gues ! thanks!

User avatar
Puss_in_Boots
Posts: 2584
Joined: Fri Apr 21, 2017 1:23 am

Re: Properties XLS - for unit differentiation

Post by Puss_in_Boots » Wed Sep 20, 2017 7:50 pm

I shall do stats for the ship!
RED, WHITE and BLUE!

Stratego (dev)
Site Admin
Posts: 9392
Joined: Fri Apr 25, 2014 9:28 pm

Re: Properties XLS - for unit differentiation

Post by Stratego (dev) » Wed Sep 20, 2017 7:51 pm

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: 2584
Joined: Fri Apr 21, 2017 1:23 am

Re: Properties XLS - for unit differentiation

Post by Puss_in_Boots » Wed Sep 20, 2017 7:53 pm

I think I will define them.
RED, WHITE and BLUE!

Stratego (dev)
Site Admin
Posts: 9392
Joined: Fri Apr 25, 2014 9:28 pm

Re: Properties XLS - for unit differentiation

Post by Stratego (dev) » Wed Sep 20, 2017 8:06 pm

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 » Wed Sep 20, 2017 8:10 pm

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: 9392
Joined: Fri Apr 25, 2014 9:28 pm

Re: Properties XLS - for unit differentiation

Post by Stratego (dev) » Wed Sep 20, 2017 8:18 pm

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 24 times

Stratego (dev)
Site Admin
Posts: 9392
Joined: Fri Apr 25, 2014 9:28 pm

Re: Properties XLS - for unit differentiation

Post by Stratego (dev) » Wed Sep 20, 2017 9:29 pm

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 » Fri Sep 22, 2017 4:44 am

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: 9392
Joined: Fri Apr 25, 2014 9:28 pm

Re: Properties XLS - for unit differentiation

Post by Stratego (dev) » Sat Sep 23, 2017 3:07 pm

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: 9392
Joined: Fri Apr 25, 2014 9:28 pm

Re: Properties XLS - for unit differentiation

Post by Stratego (dev) » Wed Sep 27, 2017 5:31 am

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 » Wed Sep 27, 2017 11:39 am

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: 9392
Joined: Fri Apr 25, 2014 9:28 pm

Re: Properties XLS - for unit differentiation

Post by Stratego (dev) » Fri Sep 29, 2017 8:31 pm

new XL in forst post - with real properties of ships - thanks so Prof.Gamer!

Stratego (dev)
Site Admin
Posts: 9392
Joined: Fri Apr 25, 2014 9:28 pm

Re: Properties XLS - for unit differentiation

Post by Stratego (dev) » Fri Sep 29, 2017 8:42 pm

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: 1605
Joined: Thu May 01, 2014 7:43 am
Location: Batavia

Re: Properties XLS - for unit differentiation

Post by samuelch » Mon Nov 27, 2017 4:43 pm

Planes
Attachments
stats_v14.xlsx
(31.11 KiB) Downloaded 15 times
My pfp is made by Chiefchirpa.
Hugs and love FUR eFURRYone!Murr

Post Reply

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