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

@Shyy That's awesome! Let me know how well it works for you!

This sheet RULES! Any chance you could have automatic hunting party recommendations implemented at some point? Where it takes wolves that are best suited for each position, checks for conflicting personalities, and arranges them in potential hunting parties? o:

@Rat of Unusual Size I thought about doing this, but it would be a very complicated formula which would involve checking an individual wolf's stats against the other four hunters of the party. I won't say no, but I won't say yes, either. It would absolutely be limited to five wolves (and not, like, in the main sheet)

This sheet is so useful and I LOVE it!

I would just l like to know how to change the names of the dens?

I would also suggest adding (to the pupsitter tracker) how many pups (out of 10) that they are pupsitting at the moment, and (in the pack statistics) add something for the uses of food, so that it can somehow track pregnant females and add an extra use per female and add a use per puppy that is weaned, so that if you enter all the information correctly, it will show the exact amount of food uses (and maybe amusement item uses?).

You have to unhide the "back-end" tab (4 lines next to tabs and click "Back-End 1", there you can change den names)

When I try to paste the info from the Paste and Go sheet to the Main thing, it gives me #REF in all the cells it's suppose to fill.  How can I fix this?

Hey Ck! Here is a copy of the file I modified. I don't know if this may give you some ideas or shortcuts!

I modified the paste and go sheet a little extensively, because I found out there was a way to input the data while copying all four tables simultaneously (copying only the level table separately): Edited copy

@Luv, make sure when you go to paste the values over you choose "paste values".  You can find that option by hitting ctrl after pasting in the values. 

Thank you so much!  I will try that tomorrow!

Big Edit:

I hope it works for you!

Also, CK, I realized I broke a few features, so just finished applying some fixes to the sheet I shared above. Mainly, I added:

• a back-end 2 sheet to reference portraits for the wolf lookup
• changed the pack statistics formulas to count wolves I classified as "elderly" as adults, and as "Weaned Puppies" and "Nursing Puppies" as puppies.
• Added an "adult in heat" section to the paste + go sheet, because I realized the number of rows copied over changes depending on if the wolf is an adult, in heat, an adolescent, or a puppy
• I changed the food per day to reference the adult and adolescent fields -- for some reason, mine was showing only the adults
• I updated the wolf lookup sheet to reflect my rearrangement of the columns XD
• I added some quick links back to the master page on some of the calculators
• I renamed the masterdatabase sheet to mastersheet

haha, I don't remember anything else I've done. XD Anyways, hope you have fun looking at my crazy version.