Results 1 to 11 of 11

Thread: Some google sheets that might be of interest

  1. #1

    Default Some google sheets that might be of interest

    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
    Last edited by Livet er herlig; 17 Oct 2015 at 05:34 PM. Reason: Changed link
    2013: uk5 - Jabberwock, 2014: uk5 - She-Hulk, 2016: uk2 - Livet er herlig

  2. #2
    Honoured Natarian MemberHonoured Natarian MemberHonoured Natarian MemberHonoured Natarian Member Trouble's Avatar
    Join Date
    May 2009
    Location
    Leeds/Norwich
    Posts
    2,387

    Default

    Trade route one will be usefull if it works, Used to have something similar but I deleted it
    No-cringe signature.

  3. #3

    Default

    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.
    2013: uk5 - Jabberwock, 2014: uk5 - She-Hulk, 2016: uk2 - Livet er herlig

  4. #4

    Default

    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.
    "Itís only when the tide goes out that you see who was swimming naked."

    #MakeTravianGreatAgain #MTGA

  5. #5

    Default

    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
    Last edited by Livet er herlig; 13 Feb 2015 at 02:00 AM.
    2013: uk5 - Jabberwock, 2014: uk5 - She-Hulk, 2016: uk2 - Livet er herlig

  6. #6
    Mr Fantastic

    Well-Known MemberWell-Known MemberWell-Known MemberWell-Known Member MLGJ's Avatar
    Join Date
    Aug 2009
    Location
    Omnipresent
    Posts
    1,709

    Default

    nice work fella
    This post was brought to you by "Mr Fantastic"

    Yayyyyy made it on to setbacks ignore list, can give it but not take it
    Let me guess, some kind of funny joke?
    This message is hidden because MLGJ is on your ignore list.

    Where is my apology from MLGJ, for his insult on the forums? - URSULA THE MINOR
    In your dreams Sunshine xx

  7. #7

    Default

    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.
    Last edited by Livet er herlig; 16 Oct 2015 at 11:19 PM. Reason: New link
    2013: uk5 - Jabberwock, 2014: uk5 - She-Hulk, 2016: uk2 - Livet er herlig

  8. #8

    Default

    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
    2013: uk5 - Jabberwock, 2014: uk5 - She-Hulk, 2016: uk2 - Livet er herlig

  9. #9

    Default

    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.
    "Itís only when the tide goes out that you see who was swimming naked."

    #MakeTravianGreatAgain #MTGA

  10. #10

    Default

    Quote Originally Posted by Hawkery View Post
    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.

    Quote Originally Posted by Hawkery View Post
    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
    2013: uk5 - Jabberwock, 2014: uk5 - She-Hulk, 2016: uk2 - Livet er herlig

  11. #11

    Default

    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.
    2013: uk5 - Jabberwock, 2014: uk5 - She-Hulk, 2016: uk2 - Livet er herlig

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •