PlanetCalypsoForum.com :: Entropia Universe Discussion and Resources
Page 1 of 7 1 2 3 4 5 6 7 LastLast
Results 1 to 10 of 65
  1. #1
    Old Alpha TunerS's Avatar
    Joined
    Feb 2009
    Gender | Ingame
    Male | Male
    Location
    Latvia
    Avatar
    Sniper TunerS Eagle
    Posts
    951
    Images
    187

    Post Spreadsheets for Entropia

    This hopefully will become a thread with a lot of useful google spreadsheets for hunting, trading, crafting or for whatever else it might be needed.

    But first of all I would like to ask you all what do you think about spreadsheet where you could setup your hunting gear with all attachments, enhancers and buffs included to see how ECO it really is and basically what is the end result. This is something I have been thinking about lately myself. I created a simple example spreadsheet to test ECO of weapons with enhancers (just TT and also MU included) and the results really shocked me.

    So what are your thoughts about this? Would someone actually use it? The long term idea would be to create a complete spreadsheet that would combine hunting run tracking + gear setup, trading, crafting and mining if necessary. I have finished trading spreadsheet already since I'm using it myself. Everything would be made in google spreadsheets.

    NOTE: For those who don't know (pretty much everyone because my work on spreadsheets is not that well known in this community), my spreadsheets contain a lot of automated scripts that do most of the heavy lifting so to speak. So these spreadsheets are not just copy-paste formulas or values in different cells with a hope for the best. Everything is made so it would be as easy, fast and efficient as possible (as much as it can be with spreadsheets anyway). Due do them using scripts, I understand some player concerns about their account safety, so open source code would also be available for checking once spreadsheets are finished.

    If you want to chat about this in game, you can add me to FL: Sniper TunerS Eagle




    Trading v15.0
    EDIT (14.11.2015):

    New version is available - Trading v15.0

    This is my old trading spreadsheet that I'm still using from time to time. It is not protected against human errors so bad things can happen if the wrong cell content is deleted or changed. By bad I mean that calculations will be wrong or give errors.

    Just Copy the spreadsheet to your Google Drive and you will have full access to it.

    Detailed guide how to use this spreadsheet is comming soon (sooner or later anyway...). At the moment screenshots will have to do. It is not that hard to understand anyway.






    Weapon Stats V3.8
    EDIT (16.11.2015):

    New version is available - Weapon Stats V3.8

    Just Copy the spreadsheet to your Google Drive and you will have full access to it.

    In case you get an error message saying "Server error occured. Please try saving the project again." after pressing any of the buttons in the spreadsheet, then just copy again the spreadsheet you just copied to your google drive (your copy). So far it seems this bug happens whenever multiple users are watching the same spreadsheet and someone is trying to copy it.

    First you need to do is to press "Calculate" button once to get a pop-up window with script authorization. You will have to allow scripts to run.

    After that you can just write in the blue cell (A4) what weapon you want and it will show all matching results.
    NOTE: When opening spreadsheet for the first time, the weapon drop down menu can take up to 5 seconds to load. After that, everything should work smoothly.

    After you choose the weapon, all possible attachments (A2-A6 cells) will automatically adjust to the weapon type you choose. You can also add Rings (A7), armors (A9), helmets (A8) and skill pills (A1) to the setup.

    To add enhancers to the weapon, just choose them from the drop down menus from C2 to L2 cells. To add markup for each enhancer, type it in C1 to L1 cells according to set enhancer.

    To calculate weapon economy including used enhancers, you must set "Enhancer break ratio (shots)" in B10 cell. That is the enhancer break ratio for each enhancer.

    You can also calculate everything based on your profession levels by typing them into B13 and B14 cells. For weapons missing profession levels, all calculations will be made for maxed weapon.

    After everything is selected, just press "Calculate" button and the script will calculate everything.

    To compare weapons, just press "Compare" button to add already set weapon to the list below. To clear the sheet, press "Restore sheet to default" button.



    In "Weapon finder" sheet you can search for all available weapons between set profession levels. Just select profession type and Min to Max level and press "Search" button.

    For more information on how to use this spreadsheet, PM me in this forum or find me in game - Sniper TunerS Eagle

    NOTE: Information about all items in "Item list" sheet is not 100% complete. This list is imported from entropedia therefore it is missing some data. A warning message will appear when weapon with missing information is set.

    Features:
    * Calculate weapon stats including all enhancer types, weapon attachments, rings, helmets, armors, even skill pills.
    * Calculate weapon economy including weapon and attachment markup, broken enhancer TT and TT+MU, even skill pills.
    * It is possible to calculate weapon stats for specific profession levels.
    * Weapon compare option with detailed data.
    * Amplifier maximal damage calculation for weapon. Now it is easier to find the right amplifier for selected weapon.
    * Buff statistics. Check total item buffs on the setup.
    * Damage information for amplifiers in the drop down list for easier searching.
    * Weapon finder for specific profession levels.
    * A warning message is displayed to let users know if selected item is missing any information.
    * "Clear compare list" to clear the list of all compared weapons.
    * "Restore sheet to default" function in case something goes wrong.

    Know issues:
    * Markup on scopes and sights is not included in calculations. Since there are only handful of them in the game and almost all are missing decay information, then I will not add this function.
    * Weapon range is always set at maximum. I'm missing the level based formula for this. It also does not affect the weapon economy on the paper.
    * If weapon is missing information about profession levels, all calculations will be made as if weapon is maxed.
    * Wrong ECO calculations when missing item data. A warning message is displayed to let users know if selected item is missing any information.
    Last edited by TunerS; 11-16-2015 at 18:24.
    Visiting planet Cyrene? Check my Cyrene database for useful information.
    Complete Resource Gathering guide for planet Calypso.

  2. #2
    Dominant tuxxan's Avatar
    Joined
    Jan 2009
    Gender | Ingame
    Male | Female
    Location
    Sweden
    Avatar
    Tuxxen Skeleton Storm
    Posts
    410
    Images
    54
    I'd love to try it out

    A Trading spreadsheet Id love to have since i want to test to start trade I just simply do not know how to do it, but with a spreadsheet that would help quite a bit.

  3. #3
    Old Alpha TunerS's Avatar
    Joined
    Feb 2009
    Gender | Ingame
    Male | Male
    Location
    Latvia
    Avatar
    Sniper TunerS Eagle
    Posts
    951
    Images
    187
    Quote Originally Posted by tuxxan View Post
    This quote is hidden because you are ignoring this member. Show Quote
    I'd love to try it out

    A Trading spreadsheet Id love to have since i want to test to start trade I just simply do not know how to do it, but with a spreadsheet that would help quite a bit.
    I will post mine once I make a tutorial for it. It might be a bit difficult to understand from the start otherwise.

    Anyway, just one response so far? Was hoping for more opinions
    Visiting planet Cyrene? Check my Cyrene database for useful information.
    Complete Resource Gathering guide for planet Calypso.

  4. #4

    PM sent ingame

    I believe many of the tools you are searching for have been created already via Tal Maru and Demi Nishap

    https://docs.google.com/spreadsheets...Mg/edit#gid=12

  5. #5
    Old Alpha TunerS's Avatar
    Joined
    Feb 2009
    Gender | Ingame
    Male | Male
    Location
    Latvia
    Avatar
    Sniper TunerS Eagle
    Posts
    951
    Images
    187
    Quote Originally Posted by Timp44 View Post
    This quote is hidden because you are ignoring this member. Show Quote
    I believe many of the tools you are searching for have been created already via Tal Maru and Demi Nishap

    https://docs.google.com/spreadsheets...Mg/edit#gid=12
    No offense to creators of that spreadsheet but it looks really primitive and chaotic. Atleast to my standards. This is why I use scripts in my spreadsheets, spreadsheet can be made dynamic so every time you can adjust it for your current needs.

    Also there is nothing related to weapon ECO calculation with enhancers, skill buffs etc. what I was suggesting.

    Anyway, thanks for the info.
    Visiting planet Cyrene? Check my Cyrene database for useful information.
    Complete Resource Gathering guide for planet Calypso.

  6. #6
    Prowler SoReal's Avatar
    Joined
    Oct 2005
    Gender | Ingame
    Male | Male
    Society
    Titans Of Space
    Posts
    1,814
    Images
    92
    Quote Originally Posted by TunerS View Post
    This quote is hidden because you are ignoring this member. Show Quote
    I will post mine once I make a tutorial for it. It might be a bit difficult to understand from the start otherwise.

    Anyway, just one response so far? Was hoping for more opinions
    must have missed this but yeah I would be interested to see what you have come up with

    SoReal's Quad-Wing Equus Warp Services.
    Arkadia Shop : Celeste Island 2

    TOS Normandie Pilot: PM me in game or in forum for flight/skilling details.

  7. #7
    Subscribed and very interested!

    Thanks also for your work on Cyrene.

  8. #8
    Old Alpha TunerS's Avatar
    Joined
    Feb 2009
    Gender | Ingame
    Male | Male
    Location
    Latvia
    Avatar
    Sniper TunerS Eagle
    Posts
    951
    Images
    187

    Thumbs Up

    Quote Originally Posted by Slamdance View Post
    This quote is hidden because you are ignoring this member. Show Quote
    Subscribed and very interested!

    Thanks also for your work on Cyrene.
    Thanks!

    So far I have created weapon eco calculations including amps, enhancers (also including markup) and rings. Once I finish up with L item markup and also level requirement calculations I will need some volunteers to test it for any mistakes. If you want to help, post it here or PM me in this forum or in game and we can talk about it more.

    Also it would be great if someone could post here a list of all buff pills that increase offensive stats. I would need full item name, TT value, duration in seconds, what type of attributes and how much are increased.
    Visiting planet Cyrene? Check my Cyrene database for useful information.
    Complete Resource Gathering guide for planet Calypso.

  9. #9
    Old Alpha TunerS's Avatar
    Joined
    Feb 2009
    Gender | Ingame
    Male | Male
    Location
    Latvia
    Avatar
    Sniper TunerS Eagle
    Posts
    951
    Images
    187

    Question

    Ok, it seems that all the stats for buffs are available on entropia website, only thing that is missing is TT value. Since these pills are not tradable in auction I can't look for them there. Also can't find in entropedia either. So I need your help.

    Here is the list.


    Neurostim-A - 14% Faster Reload, 25% Increased Run Speed - 15 minute duration
    Neurostim-X* - 12% Faster Reload, 1% Increased Critical Hit Chance, 12% Increased Critical Damage - 30 minute duration
    Neurostim-Z* - Combined effects of both Neurostim-X and Neurostim-Y, 30 minute duration
    Neurostim-X2* - 16% Faster Reload, 2% Increased Critical Hit Chance, 16% Increased Critical Damage - 30 minute duration
    Neurostim-Z2* - Combined effects of both Neurostim-X2 and Neurostim-Y2, 30 minute duration
    Last edited by TunerS; 10-03-2015 at 07:19.
    Visiting planet Cyrene? Check my Cyrene database for useful information.
    Complete Resource Gathering guide for planet Calypso.

  10. #10
    The TT won't take Neurostim-X and you can't auction it. Therefore, it has no TT value. (Can you tell I'm unhappy with my strongboxes?)

    All right, the info for the pill says 5 ped TT.

    You don't need B or Y?

Page 1 of 7 1 2 3 4 5 6 7 LastLast

Tags for this Thread

Posting Permissions

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

Follow Planet Calypso on Twitter  Follow Planet Calypso on Facebook