Some Spreadsheets I made to track Royals data.

Discussion in 'Guides' started by PkewPkew, Jan 7, 2020.

  1. PkewPkew
    Offline

    PkewPkew Donator

    Joined:
    Jun 4, 2018
    Messages:
    216
    Likes Received:
    197
    Gender:
    Male
    Location:
    East Coast US
    Country Flag:
    IGN:
    Snikt
    Level:
    200
    Guild:
    Rogue
    I made these spreadsheets to track a few things in Royals. One for leech sales, one for Apples from APQ and one for tracking gear and upgrade costs. I hope someone else finds them useful so I decided to share here. Any suggestions would be appreciated as I am an amateur at best.

    Some of the formulas will work strangely until data is entered into the first few rows (specifically the AVG of last 4 runs in APQ sheet). Any suggestions to make the formulas work better would be appreciated. Also, to reduce file size the "Total" formula in the APQ sheet is only applied to the first 26 rows. When you go past this just extend the formula beyond that point.





     
    Last edited: Jan 7, 2020
    Noee and 2hSword like this.
  2. Wonderstruck
    Offline

    Wonderstruck Donator

    Joined:
    Apr 10, 2020
    Messages:
    1,512
    Likes Received:
    631
    Very nice. Bump.
     

Share This Page