1. Welcome to Planet Cyrene Forum!

    You appear to be browsing cyreneforum.com as a guest user. Did you know that if you sign up with an account, you get access to all kinds of additional privileges, and are then able to join the discussions?

    Already a member? Login Now!

[info] Logging your hunting results using Google Sheets

Discussion in 'Tutorials' started by Rusty Venture, Feb 17, 2015.

  1. Rusty Venture
    • Cyrene Pioneer

    Rusty Venture Maze Runner
    Bitching

    Joined:
    Sep 27, 2012
    Messages:
    408
    Likes Received:
    106
    Trophy Points:
    43
    Gender:
    Male
    Occupation:
    Monria sucks, it's owners are terrible people.
    Home page:
    Society:
    Venture Industries
    [​IMG]


    Introduction:

    Sometimes when you are loosing often it is easy to forget those big loots you had earlier and feel like you are loosing more than you are. I have created a spreadsheet to aid in calculating hunting results long term. This Tutorial will show you how to input your hunting data into the spreadsheet as well as find out how much decay you used in the hunt.

    Location:

    You will need a Google or Gmail account to save your info in Google Drive, or simply download the document and edit it on your personal computer. Click here to view my spreadsheet.

    Go to File on the top left under the title of the spreadsheet (Hunting Template) and click "Make a copy..." this will copy the spreadsheet to your own Google drive account and allow you to edit it freely.


    [​IMG]


    Tutorial:
    Only input any information in the teal boxes to avoid removing any of the calculations. This spreadsheet will automatically add up all your decay and compare it to your loot to let you know your return in PED and percentage.

    Input the total amount of Decay into the B, C, and E columns. Input the total amount of ammo purchased into the D column. It will be automatically totaled in the F column. Enter your TT return into the Column G. The Weapon used and any notes, as well as the creature name may be filled in or edited if desired.

    [​IMG]

    To calculate the decay of each item, you can write the total TT in the field before the hunt, or on a piece of paper, and subtract the items new value after the hunt from the amount before the hunt. This will give you the decay of the weapon, armor, or fap. You can total the value by putting the items into a trade terminal for it to add it up automatically, just be sure not to accidentally sell anything. This same method can be used to find the total TT return of the hunt. When you do so, do not forget to include any extra ammunition looted in the TT return.

    Reward:

    This will allow you to see if you are profiting or losing from each individual hunt, as well as view the long term results of your hunt to ensure you are hunting at an acceptable return rate.​
    Last edited: Mar 14, 2015
  2. Broken al Angels
    • Cyrene Pioneer

    Broken al Angels Member
    Amused

    Joined:
    Feb 26, 2015
    Messages:
    37
    Likes Received:
    11
    Trophy Points:
    8
    Gender:
    Male
    Location:
    Canada
    Society:
    Natural Born Killers
    Hi,

    One small item not covered is the attachment decay (plate, sight, scope, amp) and the enhancer cost.
    Also, how do you deal with the ammo looted added to your base start-up ammo?
    Or do you use only Universal Ammo? so all BLP and Laser ammo are calculated as loot?

    Thanks
  3. sluggo
    • Cyrene Pioneer

    sluggo Active Member
    Drunk

    Joined:
    Apr 13, 2014
    Messages:
    526
    Likes Received:
    150
    Trophy Points:
    43
    Gender:
    Male
    Society:
    None
    Angels most the things that really count generally don't get covered in that specific venue of tutorial. Take them with a large grain of salt.

    sluggo
  4. Rusty Venture
    • Cyrene Pioneer

    Rusty Venture Maze Runner
    Bitching

    Joined:
    Sep 27, 2012
    Messages:
    408
    Likes Received:
    106
    Trophy Points:
    43
    Gender:
    Male
    Occupation:
    Monria sucks, it's owners are terrible people.
    Home page:
    Society:
    Venture Industries
    I include that in the weapon decay field and add them manually, along with enhancer cost. Basically all possible kinds of decay fall under the 4 fields I have there in my opinion.

    I usually use universal ammo to see the ammo from loot, or I otherwise just subtract it, for example:
    100 ped BLP ammo used for the hunt, I finish with 20 ped of the ammo left, I put 80 in the ammo spent field even though I likely spent more due to looting extra ammo, however that ammo is not added to the loot field as I used it so it evens out and gives a proper report of return still.
  5. Paul Jetman Masters
    • Cyrene Pioneer

    Paul Jetman Masters Well-Known Member
    Spaced

    Joined:
    Jun 12, 2014
    Messages:
    517
    Likes Received:
    381
    Trophy Points:
    63
    Gender:
    Male
    Location:
    South Yorkshire
    re: Ammo, I work my list a similar way. If I dont use universal ammo, say a buy 100ped blp, I use all my ammo including looted and if I finish it all I add ammo to loot, but if the run is ended early I subtract my ammo, but only the ammo I was using, subtract blp but laser goes in loot

    I don't actually have a field for any armor, plates, amp, fap... Just one big fat repair field. Just easier at the end and its already like 15 columns
    Rusty Venture likes this.

Share This Page