Page 2 of 3
Re: Properties XLS - for unit differentiation
Posted: Sun Sep 17, 2017 6:42 pm
by Stratego (dev)
ok. i start putting in the japanese tanks into xls.
Re: Properties XLS - for unit differentiation
Posted: Sun Sep 17, 2017 8:01 pm
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.
Re: Properties XLS - for unit differentiation
Posted: Mon Sep 18, 2017 7:08 pm
by Stratego (dev)
ok, i start doing the howitzers into xls
Re: Properties XLS - for unit differentiation
Posted: Mon Sep 18, 2017 8:35 pm
by Stratego (dev)
ok, i did not do the howitzers, but the AA cannons.
here they are in first topic
changes uos 10
Re: Properties XLS - for unit differentiation
Posted: Tue Sep 19, 2017 4:24 am
by Prof_GamerARCHIVED
Should i do the howitzers today?
Re: Properties XLS - for unit differentiation
Posted: Tue Sep 19, 2017 4:40 am
by Stratego (dev)
Would be cool! Thanks!
Re: Properties XLS - for unit differentiation
Posted: Tue Sep 19, 2017 4:25 pm
by Stratego (dev)
ok ,here i have a little time to do some - are you working on any of them?
Re: Properties XLS - for unit differentiation
Posted: Tue Sep 19, 2017 5:26 pm
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
Re: Properties XLS - for unit differentiation
Posted: Tue Sep 19, 2017 6:06 pm
by Stratego (dev)
cool!
than i am doing the field guns!
(dont forget not all in-game units listed in the current xls.)
Re: Properties XLS - for unit differentiation
Posted: Tue Sep 19, 2017 7:41 pm
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)
Re: Properties XLS - for unit differentiation
Posted: Tue Sep 19, 2017 7:53 pm
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)
Re: Properties XLS - for unit differentiation
Posted: Wed Sep 20, 2017 4:43 pm
by samuelch
Howitzers added.
Re: Properties XLS - for unit differentiation
Posted: Wed Sep 20, 2017 5:33 pm
by Stratego (dev)
thanks,
you have not used the latest file, the columns are not fit.
i try to fix it.
Re: Properties XLS - for unit differentiation
Posted: Wed Sep 20, 2017 5:39 pm
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.
Re: Properties XLS - for unit differentiation
Posted: Wed Sep 20, 2017 7:08 pm
by Prof_GamerARCHIVED
Eh, i was working on the howitzers... and i just finished them.
Re: Properties XLS - for unit differentiation
Posted: Wed Sep 20, 2017 7:48 pm
by Stratego (dev)
good! send me please - so we have them completely i gues ! thanks!
Re: Properties XLS - for unit differentiation
Posted: Wed Sep 20, 2017 7:50 pm
by Puss_in_Boots
I shall do stats for the ship!
Re: Properties XLS - for unit differentiation
Posted: Wed Sep 20, 2017 7:51 pm
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
Re: Properties XLS - for unit differentiation
Posted: Wed Sep 20, 2017 7:53 pm
by Puss_in_Boots
I think I will define them.
Re: Properties XLS - for unit differentiation
Posted: Wed Sep 20, 2017 8:06 pm
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.
Re: Properties XLS - for unit differentiation
Posted: Wed Sep 20, 2017 8:10 pm
by Prof_GamerARCHIVED
Wow, if we keep this up we may have finished the game in a couple of months!
Re: Properties XLS - for unit differentiation
Posted: Wed Sep 20, 2017 8:18 pm
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)
Re: Properties XLS - for unit differentiation
Posted: Wed Sep 20, 2017 9:29 pm
by Stratego (dev)
first topic updated with the latest XLS, with the HOWITZERS set (and now the game and XLS is in sync, uos)
Re: Properties XLS - for unit differentiation
Posted: Fri Sep 22, 2017 4:44 am
by Prof_GamerARCHIVED
Did u check the xls file i sent u?
Re: Properties XLS - for unit differentiation
Posted: Sat Sep 23, 2017 3:07 pm
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 )
Re: Properties XLS - for unit differentiation
Posted: Wed Sep 27, 2017 5:31 am
by Stratego (dev)
is somebody working on the xls? (eg. on ships)
Re: Properties XLS - for unit differentiation
Posted: Wed Sep 27, 2017 11:39 am
by Prof_GamerARCHIVED
Im going to finish the jsons you sent me today.
Re: Properties XLS - for unit differentiation
Posted: Fri Sep 29, 2017 8:31 pm
by Stratego (dev)
new XL in forst post - with real properties of ships - thanks so Prof.Gamer!
Re: Properties XLS - for unit differentiation
Posted: Fri Sep 29, 2017 8:42 pm
by Stratego (dev)
also i have prepared the "planes section" so please fill the blue values (get the latest xls from first post)
thanks!
Re: Properties XLS - for unit differentiation
Posted: Mon Nov 27, 2017 4:43 pm
by samuelch
Planes