Help > Player Tutorials > Post Reply     

Siib's Spreadsheet Templates

Default Avatar
siib 🦈 [ Gone ]
March 27th, 2018 6:22:01pm
2,627 Posts

Okay! So I've seen a lot of people talking about wanting better management over their acocunts, training, private shows, ect. I've also had people joke about "I need a spreadsheeet" a lot, so Siib to the rescue (jk, jk).

I have three differen't spreadsheets that I use to help myself manage my 30 accounts, 30 animal groups in training, and over 750 private show spots! Got your attention yet? I sure hope so! Below I am providing thel ink to my Google Drive where I've taken the time to upload three blank templates that you guys should be able to download, edit, and use for yourselves!

A few things to note:

(Account Sheet)
I no longer keep track of my ticket dates, I simply buy them on the Sunday/Monday that I make shows and they're available again. With 30 accounts it no longer became worthwhile to me to login and get them on the exact day they were due again. The use column is for me to keep track of what breed is on that account, OR what player I'm letting use it for training. This has all but been phased out for me as I now I have a separate training sheet.

(Training Sheet)
I do not keep track of my breeding dates. I've just gotten into the habit of going through on Sundays/Mondays and checking all of my groups. If you notice on my main, I also have a "breeding reminders" group that I send a line of paints too once they're 2 weeks out from their final breeding.

(Private Show Sheet)
I mention sorting this sheet in a very specific manner. If you find that you want to sort it in that way but do not know how, please message me for help!

If you want a sheet for literally anything else HP related, message me! These are the sheets I found I needed but I'll be happy to make more templates if anyone finds they'd be helpful. I can also help you design tables for your pages (yes with fancy CSS and all) if you want that for training or whatever. Just shoot me a message on that as well.

GOOGLE DRIVE LINK: CLICK HERE

I have set it to view only, please download the sheets to use them!! I didn't want to risk anyone accidentally entering their account information publically which is why there's no ability to edit and no ability to write notes. If you're having trouble with that please message me (okay, I'll stop, I sound like a broken record).

I really hope these help anyone who wants to get a little more organized with their accounts! I certainly couldn't survive without them!




 


View Comments 1 2 Next >


Default Avatar
siib 🦈 [ Gone ]
March 27th, 2018 7:26:59pm
2,627 Posts

Bumping this. :) 




 

Player Avatar
Administrator Binny 🦄 [on leave for April ; blitz babysitting]
March 27th, 2018 7:31:37pm
2,913 Posts

Such an amazing idea! I'm sure it'll help out a lot of people! 

Thanks for doing this siib!




 

Player Avatar
Maharet : Taking a break : BV, Blitz, & Trig watching
March 27th, 2018 8:08:29pm
2,469 Posts

of course you post this a few weeks after I get mine set up XD




mw0PiPU.png 4EvEVBM.png dJ0BFny.png xzJXn6S.png

 

Default Avatar
siib 🦈 [ Gone ]
March 27th, 2018 8:10:54pm
2,627 Posts

Haha! Sorry Maha! I sent the first two sheets to Phis this morning and realized how easy it would be to just post them for everyone! 




 

Player Avatar
Eyre • hello spring
March 27th, 2018 10:55:28pm
9,803 Posts

My heavens, siib! I've always wondered how people manage multiple billions of accounts and animals. :)




ZBfIYnq.png

 

Player Avatar
lunarie ∴ the hands of the many must join as one
March 28th, 2018 12:30:30am
1,445 Posts

This is such a brilliant idea, Siib! Props to you!! ♥




S3WSn3y.png

 

Player Avatar
PHISM || Hiatus ||
March 28th, 2018 2:49:09am
1,321 Posts

SIIB IS A GODDESSSS




Nq6uAjc.png ICvs2aV.png QYn0eyJ.png

 

Default Avatar
siib 🦈 [ Gone ]
March 28th, 2018 4:43:46am
2,627 Posts

Daw, thanks guys! ☺️☺️ Hopefully they help at least a couple players! 




 

Default Avatar
siib 🦈 [ Gone ]
April 5th, 2018 3:47:31pm
2,627 Posts

Few extra tips because I'm forever adding onto these sheets for my own purpose:

  • I've added in a "requested" column onto my private show sheet.
  • My training sheets are both separated by colors now to define accounts a little easier for me (regular trianing: http://prntscr.com/j1bjhe / private shows: http://prntscr.com/j1bhw2). This is literally to help me be able to differentiate groups a little easier.
  • Reno added in a formula to count down the days on her upgrades (at least I think that's what she told me it was for) on the account sheet (because things on my accounts change so frequently I didn't add in any formulas for myself but just so you know it can be done).



 

Player Avatar
tana ;; gone
April 5th, 2018 5:28:54pm
13,574 Posts

Thank you, based shark goddess!




xz9ZAF6.pngzTmTidi.pngRSOVxrL.png1nFp63Z.png

 

Default Avatar
siib 🦈 [ Gone ]
April 7th, 2018 2:12:47pm
2,627 Posts

💕 Doin' my best. Making spreadsheets kept me busy for a couple hours. I am currently trying to think of any other possible situations on HP that might require a spreadsheet I could add to my template group. So if you have any suggestions at all, don't hesitate to let me know!




 

Player Avatar
tana ;; gone
April 7th, 2018 2:14:06pm
13,574 Posts

Maybe a list for people to keep track of who's in their private shows?




xz9ZAF6.pngzTmTidi.pngRSOVxrL.png1nFp63Z.png

 

Default Avatar
siib 🦈 [ Gone ]
April 7th, 2018 2:16:10pm
2,627 Posts

Can do!




 

Player Avatar
roooooo ♥
April 7th, 2018 2:18:46pm
1,094 Posts

To add in the days until the upgrade expires, use the code below:

 

=E3-TODAY()

 

(REPLACE "E3" with whichever cell you're referencing)

Also, make sure the cell is formatted to "general"

 




 

Default Avatar
siib 🦈 [ Gone ]
April 7th, 2018 2:19:19pm
2,627 Posts

^ There ya go guys! Thanks Reno! lol 




 

Player Avatar
roooooo ♥
April 7th, 2018 2:19:50pm
1,094 Posts

no problem!

 

Thanks for getting me started on this :)

Didn't know I needed it! haha




 

Default Avatar
siib 🦈 [ Gone ]
April 7th, 2018 2:22:35pm
2,627 Posts

I'm just glad people are getting some use out of them! I actually had 3 separate documents and merged them all together (like the one above) because I finally decided to make my life easier by just a hair.

Also for other columns I had on the account sheet: 

Horse & Dtix - I would mark when they came in and who bought them. But since I use my own more often than not it just became pointless. 

Upgrades - I used to track their dates but since I do all my own upgrading it just kinda made me shrug. I just upgrade when I see they need to be done and sell one or two less that week. Which is why I no longer track my upgrade dates.

These sheets are literally the ones I use, so everyone will need to change things here and there.




 

Default Avatar
primrose •• creepin' ♥
June 20th, 2018 12:46:50pm
2,687 Posts

OMG why did i forget about these?! I currently need them like BAD rotf




 

Default Avatar
siib 🦈 [ Gone ]
June 20th, 2018 6:07:25pm
2,627 Posts

I also am happy to create your spreadsheets custom for you for a relatively small amount. :) I use these as my base templates but can add in anything you need. 




 

Default Avatar
primrose •• creepin' ♥
June 25th, 2018 12:36:09pm
2,687 Posts

i may harass you about them soon xD




 

View Comments 1 2 Next >