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

UPDATE: Wolvden admin renamed three of four main personalities, and I've changed the spreadsheet to reflect it <3

Marking! Thank you for sharing this.

Thanks for sharing this tracker! I made some changes in my copy - I added old personality names in brackets cause new ones are a bit confusing for me right now :P
Also I didn't feel a need of "last updated" column so I changed it to "for breeding?" so I can keep track which wolves I want to breed in future :D Maybe it will be an inspiration for next change in your tracker :)


Question - should "Rec. Hunting Pos." cells update automatically when pasting stats in master info database tab and selecting "hunter" in main role? Mine show just "-" even though the wolf is a hunter

@Misskiedis It absolutely should update automatically after you've pasted stats into the master info database. Are you using the latest version of the spreadsheet? I'm really bad at announcing the minor tweaks, but I've been fiddling with the V2 public master.

I use online google sheets

I got it! I changed

=IF([cell] = "5. Hunter"

to

=IF([cell] = "Hunter",

I've been trying to use the paste and go info, but it doesn't seem to work when I paste the data into the main spreadsheet.

I've figured out the paste and go sheet, it works, but when I highlight and copy row 19 and paste at the wolves "level" cell I get a bunch of errors saying "This Reference Does Not Exist". I suspect this is because when I select the row, it shows the formula as "=C4". Maybe I'm not selecting it right, but I just can't seem to figure out how to work around it trying to select the first formula of the first cell rather than the information within the cell. I'm VERY confused.

Tech you are you shift-ctrl-v? or just ctrl-v?

I was just doing ctrl+v. Shift+ctrl+v works! Thank you

@Misskiedis thanks for catching that! Il fix it as soon as I can. I'm in mobile atm

@Tech 3.0 it sounds like you aren't pasting as instructed. When you paste into the main spreadsheet, you MUST use shift+ ctrl+v - this pastes only the values copied and not the formulas themselves

Okay so, either I'm not understanding how the pasting+go is supposed to work or I'm doing it wrong. 

When using the paste + go is it supposed to put the info into the right column, like when I'm copy pasting the stats is it supposed to sort them so that speed is in speed column, strength in strength etc? Or does it just paste the whole block and you then have to sort them out?

because no matter how I copy paste (I've tried, CTRL + Shift + V, CTRL + V, and actually right clicking and selecting paste) it only ever does this;

And I'm not sure if it's supposed to be doing that, or if it's supposed to spread out accordingly in line 19? I was hoping it would just auto fill in line 19 to the right spots but it's not