[Spreadsheet] The Ultimate Pack Tracker 2000 - V.3 NOW AVAILABLE
Posted 2020-11-19 10:28:12
Can I request a dumbed down version of this? Tracking only Name Mainly an advanced generator of stat prediction, that can save the info quickly rather than having two different docs up? |
Warband #11759 |
Posted 2020-11-20 13:48:17
@Warbrand you can actually modify the existing spreadsheet quite easily by hiding the columns you don't need. Simply highlight the columns, right click, and select 'hide' |
counterklock #21666 |
Posted 2020-11-20 16:51:12
You have the stat calculator is what I mean. I'm ocd about tabs so it would not work for me. XD |
Warband #11759 |
Posted 2020-11-30 18:10:39
hi, i'm not sure if i'm missing something, but how do i actually open the ultimate pack tracker spreadsheet so i can copy it to google drive? the big giant link that says "The Ultimate Pack Tracker 2000 - V.3" doesn't seem to actually link to the pack tracker spreadsheet, just the release date and instructions. please help i feel so stupid :( |
Liza ✨ #30803 |
Posted 2020-11-30 19:34:48
I'm six years late to replying to @Warband i am so sorry: I could indeed make a stat calculator separate, but rn I'm focusing on this spreadsheet as a whole first. Sorry! You could always just... delete the other tabs and keep the breeding tab? |
counterklock #21666 |
Posted 2020-11-30 19:37:27
OHHH the tabs! thanks so much!! i knew i was missing something haha |
Liza ✨ #30803 |
Posted 2020-12-02 10:06:51 (edited)
I'm getting a "Something Broke" result in the "Rec. Hunting Pos." column with this wolf's stats- its not an issue for me as they're not actually a hunter (I was just curious what the calculator would set them as so picked hunter for funsies) but I couldn't see a report of it elsewhere on here. Currently her stats are 249 - 50, 48, 52, 49, 50, and if i type them out manually it comes up with the same error. This is literally the only issue ive run into with this, its such a detailed spreadsheet I love it!! The copy-paste page is such a good feature, I'd never have time to go through all of that data manually Edit: I just noticed the death age is calculated at 7yrs, its confirmed 7yrs 6 months now! |
Embers #3501 |
Posted 2020-12-02 12:45:16
@Embers i'm heckin scREAMIN. okay this is gonna be a lengthy explanation but basically how the formula calculates which position is best is by determining a Finishing/Chasing/Stalking stat. what's happening with your wolf there is, basically, all three role stats ended up being more or less equal, meaning all three positions are equally as viable. I haven't quite written up an if/then statement to account for this yet, because I couldn't find a wolf to test it out on, so it spits out 'something broke'. |
counterklock #21666 |
Posted 2020-12-03 10:20:19 (edited)
Oh geeze that does sound tricky to set up naturally, glad I could help find a test case! XD Thanks for explaining =D |
Embers #3501 |
Posted 2020-12-03 14:53:45
This is so great, thank you! I've been using it and added a column in Other called "Status" with values of Alive, Deceased, Sold, and Chased and it's been working really well :) I can keep track of how many wolves I chase now! |
Shyy #1839 |