1. Discord Support team Facebook l2central.info

Shots trade calculator

Discussion in 'Players helping players' started by xMichelle, Mar 18, 2021.

  1. xMichelle

    xMichelle User

    Joined:
    08.01.16
    Messages:
    147
    Likes Received:
    1
    Hello, I have just created an online excel sheet in which we can calculate how much we will earn adena by trading shots, any suggestions, changes and corrections are welcome :)
    (sorry for my english)

    Please edit only yellow box

    https://1drv.ms/x/s!An26QxBdYwsEhCHPksV-gacEDVYZ?e=DpkNY5

    Please leave comment if i help or give me idea for new calculator :)
     
    Last edited: Mar 18, 2021
  2. xMichelle

    xMichelle User

    Joined:
    08.01.16
    Messages:
    147
    Likes Received:
    1
    v2.0 done - improved readability
     
  3. xMichelle

    xMichelle User

    Joined:
    08.01.16
    Messages:
    147
    Likes Received:
    1
    v3.0 I added fees for a successful auction
     
  4. xMichelle

    xMichelle User

    Joined:
    08.01.16
    Messages:
    147
    Likes Received:
    1
    v4.0
    - U can count how much u can craft SS from items in inventory and make adena for selling them (without fee)
    - U can count how much adena can get for seling already have SS
     
    Last edited: Mar 18, 2021
  5. xMichelle

    xMichelle User

    Joined:
    08.01.16
    Messages:
    147
    Likes Received:
    1
    v5.0
    - Added recipe
    - Removed problem with BSSR calculation
     
  6. xMichelle

    xMichelle User

    Joined:
    08.01.16
    Messages:
    147
    Likes Received:
    1
    Something is wrong with BSSR [Percent of cost (earn%)]
    Dunno why.
    Help with mathematical formula.
    SSR % is ok its this same BSSR formula but result is not good :(