PDA

View Full Version : Some google sheets that might be of interest



Livet er herlig
30 Jan 2015, 11:19 AM
I have made a few different google sheets for travian over the years. This first one is a collection of different calculators I have made when either bored or in need of something. I will suggest making copies of these sheets to your own drive before using them.

First sheet:

https://goo.gl/FJDwi2 (it is view only, you will need to take a copy to your own drive to use it)

Description of the tabs:
NPC Calc - this is basically just a tool to NPC into troops. It is NOT needed much really. I usually use the one that is already included in the game, but this is can be useful if you have a heavy crop negative. If you have 2M res in your hammer and want 500k Wheat left, just put in 1.5M in the field for res.
Else it can show how much res you will need for queing.

XP/Scrolls - calculates if the changed hero XP is possible with scrolls. As you know, you might get a different XP if the srolls is taken one and one, instead of all together. The math here is not hard, but a nice calc if you can't be bothered to do it manually.

Trade route - this tab helps calculate how much res to send in each traderoute. You can add how long each celebration takes for you, then it tells you how much to send to have enough res stored for next celebration. By entering the time the mercs takes to the target village, it show you how many trips with return you can take in 24 hours. It also shows if you get more trips out of doing single routes or multiple deliveries for each route. Remember to set the number of trips you want yo take in a day to get the correct res of each type.

Travel time - Well, just a simple travel time calculator. Nothing special and there are lots of them out there.

Attack - This is used to time chiefing attacks from several villages. Put in the travel time for the different villages and and landing time for the one you sent first. This is also something you can do in getterplans, but this is a bit quicker and easier.

Second sheet:

http://goo.gl/vzstMQ

This will help calculate travel time to all arts and show where they are on a map. It is all explained in the info tab in the sheet. This sheet has not been tested much, since I just made it. It will be sensitive to change in the source code for the arts in the TC. If some server is close to the arts now, give it a try :)

Please check them out and give me comment

Trouble
07 Feb 2015, 02:58 AM
Trade route one will be usefull if it works, Used to have something similar but I deleted it

Livet er herlig
07 Feb 2015, 10:42 AM
It does work :) I have been using it for years now. But it does calculate to have the res the moment the celebration is over, so if you are slow with starting a new one, you will get some res stored there over time. But you can just ship everything as soon as you start a celebration to reset the storage.

Hawkery
12 Feb 2015, 09:49 PM
You are a god(dess)! This looks great and kudos for the effort.

A few things I've noticed... Hammer calc - when I type in 30 seconds difference and 60 seconds difference, the change in hammer size changes by about 2k with any size lvl fields, except 25 crop consumption is one thing over 60 seconds but implying considerably more troops than 2k at 30 seconds - too tired to do the math manually and work it out but it might just be me being slow. Would there also be a way to work out hammer sizes in a spreadsheet when double scouting oases?

The travel time calculator looks great, but how easy would it be to adjust it to work around a 2x server? Gettertools hasn't fully registered the 2x of uk19 so it makes gettertools redundant for offense planning which is a real pain, though it's a one off and 2x servers aren't that common so if it's a huge job then it might not be worth it for the long run.

Livet er herlig
13 Feb 2015, 12:25 AM
ehm, I must admit that I made the hammer calc while drunk today. I thought I got it all figured out… But guess not. Will fix it tomorrow. Igm me any problem and I will fix it. :)

Edit: if the difference in crop between scoutings is small, there will be little difference in hammer size if you change the time between when you scout. say you have a difference of 100 crop over a difference of 30 sec or 60 sec, it will make hammer size close to crop prod… Please send me a message so I can sort the other stuff out

MLGJ
20 Aug 2015, 11:40 PM
nice work fella

Livet er herlig
08 Oct 2015, 12:06 PM
Thanks :)
I really hope somebody has tried out the art organizer by now. It does still work (I made an acc on some server right before arts to check).

Nobody has been silly enough to put hammerinfo into the public version at least, guess that's good. ;)

I see that one of the sheets (the calculator one) has been messed with a bit. Here is a fresh copy: https://goo.gl/FJDwi2

Should really make a copy to your own, so made it so that this one can only be comented in.

Livet er herlig
04 Mar 2016, 03:14 PM
Hello. I made something new that might be of interest....

This is a defense form and a handling sheet for it. It has been made so you can copy paste the attacks from you RP directly into the form.

Here is the link: https://goo.gl/SiA97c

It has some scripts in it that will probably ask to be allowed to run.
The look of the form, can be changed, I did not use a lot of time on layout, but don't delete any of the questions.

You will need to paste the SQL file for the server you are playing into the tab called SQL parser. To find the file, look here: tsX.travian.co.uk/map.sql (where X is the number of your server).

I have not really tried it much... It might be slow if you handle a lot of attacks at once, but not sure.
If someone tries it out, please inform me of any troubles or mistakes in the coding.

Cheers
Hubba

Hawkery
22 Mar 2016, 01:23 AM
I couldn't quite get the script to work.. not sure about the whole access to my drive offline stuff either so didn't feel entirely comfortable with it, but that's due to not understanding what it means by offline access.

Are you attempting to create a spreadsheet that can provide an text / visual overview of all the villages under attack? Usually a google form set up properly (and most importantly, filled in properly) gives a decent overview... when people fill them in at least.

Livet er herlig
22 Mar 2016, 09:43 AM
I couldn't quite get the script to work.. not sure about the whole access to my drive offline stuff either so didn't feel entirely comfortable with it, but that's due to not understanding what it means by offline access.

The scripts are under the script editor, you can look them over there. Not sure what kind of access google.docs asks for when running scripts, but if you look at the scripts, you can see that it only access/modify the current active sheet.


Are you attempting to create a spreadsheet that can provide an text / visual overview of all the villages under attack? Usually a google form set up properly (and most importantly, filled in properly) gives a decent overview... when people fill them in at least.

Your last statement there is key, the point of the sheet is to make it A LOT faster and easier to add incoming attacks. Here you can add up to 100 attacks from different villages by just copy pasting from the RP. That way, people might bother to do it :P

Livet er herlig
25 Mar 2016, 07:36 PM
It has come to my attention that the link for the defense form sheet: https://goo.gl/SiA97c did not add a form when copied.
That was because it was set to view only, and for some reason, you did not get a form with it when you made a copy.

It is now changed to "everyone can edit" so if you take a copy now the form will work as well.
Sorry about that.