Item stats and locations

jinpachi
Staff Sergeant

Posts: 10

Item stats and locations Oct 2, 2015 17:32:16 GMT saltin, kanue, and 26 more like this

Quote

Post by jinpachi on Oct 2, 2015 17:32:16 GMT

Hi guys, Ive been playing this game for a little while now and have been really enjoying it. For a few weeks I’ve been using this forum to get the information that I need to progress on the game so firstly I would like to thank everyone for all the helpful guides and information thats been very useful to me.

I know that this topic has already got its own 2/3 threads already but I thought that I should start a new and definitive version of this (and so the link for all the info will be at the top instead of a few pages in). Firstly, I want to give credit to Pug and Andrei (and anyone else thats helped them) for posting all the information that I used. I hope you guys aren't annoyed that I've reused the information, I'm not trying to take any credit for this. I felt the need to make this because atm im always trying to upgrade my items and so keep having to switch between different threads to find the costs and where they are. Plus I want to give a little back to this great forum.

Here it is:

docs.google.com/spreadsheets/d/1I7WX-3GJEuio4B1Iq3mJDjfLPv73A74I-Bul_LhAqrM/edit?usp=sharing

Items and locations - European War 4.xlsx (79.7 KB)

Note: I added a column for the price of the items with a good general (5* business giving a reduction of 20%).

Also, if any of the senior forum members want to have control to edit or to reuse it themselves I’ll be more than happy and please let me know if there are any mistakes in there!

Last Edit: Jan 23, 2021 14:10:23 GMT by Nobunaga Oda

saltin
Administrator

Posts: 3,407

Item stats and locations Oct 3, 2015 3:01:50 GMT via mobile Napoleon Bonaparte, Józef Poniatowski, and 3 more like this

Quote

Post by saltin on Oct 3, 2015 3:01:50 GMT

jinpachi what a great post,the table looks good and best of all it is accessible to cell phone users without the need for additional app download.Google FTW.

And btw warm welcome to our Easytech fan community

Last Edit: Oct 3, 2015 3:05:33 GMT by saltin

kanue Global Moderator Posts: 1,796	Item stats and locations Oct 3, 2015 5:23:01 GMT Józef Poniatowski, 𝘛𝘳𝘰𝘵𝘴𝘬𝘺, and 1 more like this Quote Select Post Deselect Post Link to Post Member Give Gift Back to Top Post by kanue on Oct 3, 2015 5:23:01 GMT One word. "This is GREAT" wait, that's 3.
	Houses are highly illiquid assets with huge idiosyncratic risk, funded by a short position in bonds.

NetherFreek Global Moderator World Conqueror 4 If you're born before 1990, you're older than the oldest dog alive. Posts: 6,905	Item stats and locations Oct 3, 2015 13:34:25 GMT 𝘛𝘳𝘰𝘵𝘴𝘬𝘺 likes this Quote Select Post Deselect Post Link to Post Member Give Gift Back to Top Post by NetherFreek on Oct 3, 2015 13:34:25 GMT Epic that was one word

jinpachi Staff Sergeant Posts: 10	Item stats and locations Oct 3, 2015 19:28:02 GMT Quote Select Post Deselect Post Link to Post Member Give Gift Back to Top Post by jinpachi on Oct 3, 2015 19:28:02 GMT Thanks guys and thanks for the warm welcome I've also got one in the works for none RL money generals that are actually worth getting (in my opinion)

NetherFreek Global Moderator World Conqueror 4 If you're born before 1990, you're older than the oldest dog alive. Posts: 6,905	Item stats and locations Oct 3, 2015 19:33:05 GMT Quote Select Post Deselect Post Link to Post Member Give Gift Back to Top Post by NetherFreek on Oct 3, 2015 19:33:05 GMT that won't be neccesary because kanue also made a list of it. you can see that list in this thread: european-war-4.boards.net/thread/195/summary-general-data But thanks for the offer anyway!

lassalle Major Posts: 228	Item stats and locations Oct 4, 2015 6:27:55 GMT via mobile Quote Select Post Deselect Post Link to Post Member Give Gift Back to Top Post by lassalle on Oct 4, 2015 6:27:55 GMT Yep I am liking this. How did you do that jinpachi? Did you take an xlsx file and then imported into google?

jinpachi
Staff Sergeant

Posts: 10

Item stats and locations Oct 7, 2015 22:40:56 GMT andrei likes this

Quote

Post by jinpachi on Oct 7, 2015 22:40:56 GMT

Yep I am liking this.

How did you do that jinpachi?

Did you take an xlsx file and then imported into google?

Cheers lassalle. I took the info from the item prices that Pug posted saved them into notepad then imported into excel. That put them into boxes for each name, type, improvement, price etc. After that I did a similar thing with the data that Andrei provided on which items were in each location. Then I copied and pasted each price and improvement etc to each item in my locations sheet (made it easier by sorting by item so only had to copy each price etc once).

Then finally I imported the file to my google doc account (btw starting on excel is much much easier - google docs aren't that user friendly) and clicked through the 'share' options until I found the url to post.

I feel sharing spreadsheets like this is pretty good especially when there is a 'filter' applied for quick sorting.

nooblord Captain Posts: 54	Item stats and locations Oct 8, 2015 19:11:41 GMT Quote Select Post Deselect Post Link to Post Member Give Gift Back to Top Post by nooblord on Oct 8, 2015 19:11:41 GMT Very helpful- really helped me plan out what items I want for my generals

lassalle
Major

Posts: 228

Item stats and locations Oct 10, 2015 0:52:42 GMT via mobile

Quote

Post by lassalle on Oct 10, 2015 0:52:42 GMT

Oct 8, 2015 19:11:41 GMT nooblord said:

Very helpful- really helped me plan out what items I want for my generals

My thoughts too, I bookmarked the link to google doc and just look at it when I got enough medals to buy.

Last Edit: Oct 10, 2015 0:53:30 GMT by lassalle

Mountbatten Global Moderator Dieppe was staged Posts: 7,562	Item stats and locations Nov 10, 2015 11:50:34 GMT via mobile Quote Select Post Deselect Post Link to Post Member Give Gift Back to Top Post by Mountbatten on Nov 10, 2015 11:50:34 GMT Here we go
	-Best Admiral 3ver

kanue Global Moderator Posts: 1,796	Item stats and locations Nov 10, 2015 14:08:27 GMT bottlesofbeer likes this Quote Select Post Deselect Post Link to Post Member Give Gift Back to Top Post by kanue on Nov 10, 2015 14:08:27 GMT Since this thread is very useful, I will make it sticky. If you want to know where you can buy the item you want, you can open it in google doc and sort is by item name.
	Houses are highly illiquid assets with huge idiosyncratic risk, funded by a short position in bonds.

bottlesofbeer
Major

Posts: 210

Item stats and locations Nov 16, 2015 21:56:06 GMT via mobile

Quote

Post by bottlesofbeer on Nov 16, 2015 21:56:06 GMT

I check this a lot,sticky is perfect.

To add a couple thoughts:

-Some items are worth NOT waiting for,get them in the HQ right away if you have the medals instead of waiting for the right campaign.

-There is a trick to refreshing the store without having to wait: change the phone date.

FJMeyer Guest	Item stats and locations Dec 19, 2015 13:04:25 GMT Quote Select Post Deselect Post Link to Post Back to Top Post by FJMeyer on Dec 19, 2015 13:04:25 GMT Hi Guys, if I have Murat as my cavalry general, could I give him 2 cavalry pistols (+6 Attack)? Do they stack? Or do I need to get him a cavalry pistol and something else? Thanks in advance.

Mountbatten
Global Moderator

Dieppe was staged

Posts: 7,562

Item stats and locations Dec 19, 2015 14:53:01 GMT via mobile

Quote

Post by Mountbatten on Dec 19, 2015 14:53:01 GMT

Dec 19, 2015 13:04:25 GMT FJMeyer said:

Hi Guys, if I have Murat as my cavalry general, could I give him 2 cavalry pistols (+6 Attack)? Do they stack? Or do I need to get him a cavalry pistol and something else? Thanks in advance.

Some people like to use 2 pistols (yes they stack) but I prefer a Cavalry Pistol with a Saddle for +2 movement as Murat isn't fast enough for my tastes.

Last Edit: Dec 19, 2015 14:53:13 GMT by Mountbatten

-Best Admiral 3ver