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

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:

• @Cryptid-Horro #5944 for their Wolf Tracker spreadsheet, which offered an invaluable jumping-off point for me to start with my own sheet
• @ranuncudahlia #1639 and @Venti #1171 for their pupsitting sheets, which helped me figure out how to set my own up
• @Gem #3187 for their Hunting Party Spreadsheet, from which I stole borrowed and tweaked the hunting position formula to suit my own needs
• @IceOrthus #15164 for their data collection and crunching, from which I would never have been able to create my breeding tracker pup stat predictor!
  
  

Update Logs

V.2 Notes (11 Nov 2020):

• ..
• ..
• ..
  

And one more extra reserved post

OH MY GOD THIS IS THE HAPPIEST DAY OF MY LIFE

UPDATE:

I have a smol progress update on the age calculator

Update again:

UPDATE:

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

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

Your link is broken!

@RelevantKoala should be fixed now! :'D