Skip to main content
Main Content

[Spreadsheet] The Ultimate Pack Tracker 2000 - V.3 NOW AVAILABLE

[Spreadsheet] The Ultimate Pack Tracker 2000 - V.3 NOW AVAILABLE
Posted 2020-11-10 19:42:20 (edited)

I was poking around for spreadsheets this morning and just could not find one that checked my boxes completely. Thus, the Ultimate Pack Tracker 2000 was born. Spreadsheets are such a relaxing way to spend an afternoon - and by relaxing, I mean yelling very loudly about formulas and drop downs and wondering why there are too many decimal places in that spot.

The Ultimate Pack Tracker 2000 - V.3
(Updated: 27 Nov 2020)

Features:

  • See every detail of every wolf in your pack at a glance.
  • Main Database Spreadsheet where information is grouped into categories such as:
    • Identification - includes name, link, img link, ID number, sex
    • Basic - personality, disposition, est. birthdate, est. death date, lifestage, den, breeding status
    • Roles - main role, sub role, and recommended hunting position, clashing personality
    • Stats - exactly as it says on the package, your wolf stats all neatly in a row
    • Looks - Basic genetic information such as base, base genetics, mutations etc.
    • Markings - all ten marking slots accounted for!
    • Project workshop - desired wardrobe link and image, numbers of RMA/sex changer/base changer etc etc etc. needed, and total predicted project cost
    • $$$ - record purchase price, and investments (how many GC did you spent on marking applicators this time, hmm?)
    • Other - A 'last updated' column so you know when stats need to be updated, and a space to write any other notes down
  • A paste and go spreadsheet to convert raw information from your wolf's page to data that can then be put right into your main spreadsheet
  • Pack statistics - see an overview of how wolf counts by age, gender, base group, base shade, base rarities, and food usage per day
  • Wolf lookup - choose a wolf from the dropdown menu and see all their data in one handy place!
  • Breeding Tracker - to keep track of who was bred to who, when, how many puppies came of it, stud fees (if applicable) and profits from pups (if applicable); also predicts pup stat ranges based upon parent total stats
  • Pupsitting tracker - keep track of who has what proficiency and how much pups are covered
  • Hunter Position Calculator - the main spreadsheet itself has this natively built in, but this is also a handy calculator for when you'd like to check the stats of a pup you're thinking of buying
  • Age Calculator - figure out your wolf's RL birthdate, and what dates/how many rollovers until they wean, grow to adolescent, become adults, and become Old(TM).

To Use:

  • To Save:
    • Open the Ultimate Pack Tracker 2000 spreadsheet. Navigate to File -> Make a Copy, and save a copy to your Google Drive
  • Paste + Go Sheet
    • Copy your wolf's stats from their page, starting from 'Level' and ending at the bottom-most stat (ie. stats total). Go to the Paste + Go Sheet, select 'Level', and hit CTRL+V. Do not be alarmed if box colors change.
    • Copy and paste your wolf's looks, starting from 'Looks' and ending at the bottom-most value (ie. Variant). Go to the Paste + Go Sheet, select 'Looks', and hit CTRL+V. Do not be alarmed if box colors change.
    • Copy and paste your wolf's markings, starting from 'Markings' and ending at the bottom most value (ie. Marking 10). Go to the Paste + Go Sheet, select 'Markings', and hit CTRL+V. Do not be alarmed if box colors change.
    • All of these values should be successfully transferred to Row 19, and can be copied directly to the Main Spreadsheet.

Known Issues:

  • -

Upcoming Features:

  • Project Planner - Possibly a separate tab that contrasts current vs desired looks and outlines project costs
  • Dashboard - view your pack and sort them via age, gender, position, den, hunting party, etc.

Suggestions:

  • .

Discord Server

  • Join the Discord Server to get sneak previews of upcoming features, update pings, and watch as I scream about vlookup and query functions.

Special Thanks:




counterklock
#21666

Posted 2020-11-10 19:48:48 (edited)

Update Logs

V.2 Notes (11 Nov 2020):

  • ..
  • ..
  • ..



counterklock
#21666

Posted 2020-11-10 19:48:58

And one more extra reserved post


counterklock
#21666

Posted 2020-11-10 20:22:49

OH MY GOD THIS IS THE HAPPIEST DAY OF MY LIFE


bonibaru
#369

Posted 2020-11-11 13:02:56

UPDATE:

I have a smol progress update on the age calculator



counterklock
#21666

Posted 2020-11-11 13:18:04

Update again:


counterklock
#21666

Posted 2020-11-11 22:08:37

UPDATE:

VERSION 2 IS NOW AVAILABLE. See the 2nd Post for update notes


counterklock
#21666

Posted 2020-11-11 22:12:41

You are a gift to us notorious overcrowding dens! Thank you <3


Lloma
#2054

Posted 2020-11-11 22:31:38

Your link is broken!


RelevantKoala
#15056

Posted 2020-11-11 22:34:05

@RelevantKoala should be fixed now! :'D


counterklock
#21666

Search Topic