Help > Player Tutorials > Post Reply     

Siib's Spreadsheet Templates

Player Avatar
Moderator siib // santa jaws 🦈
March 27th, 2018 2:22:01pm
2,513 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 >


Player Avatar
Moderator siib // santa jaws 🦈
March 27th, 2018 3:26:59pm
2,513 Posts

Bumping this. :) 




 

Player Avatar
Administrator Ɓinny ♥
March 27th, 2018 3:31:37pm
1,788 Posts

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

Thanks for doing this siib!




 

Player Avatar
Moderator Maharet stay Hangry
March 27th, 2018 4:08:29pm
1,711 Posts

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




 

Player Avatar
Moderator siib // santa jaws 🦈
March 27th, 2018 4:10:54pm
2,513 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
red-nosed reindEYRE ❄️ graceland paints
March 27th, 2018 6:55:28pm
1,558 Posts

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




 

Player Avatar
ado ☠ klaatu barata nikto.
March 27th, 2018 8:30:30pm
1,034 Posts

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




 

Player Avatar
Moderator merry PHISmas || 🍜🍜🍜 || want an XMAS card from me? read my updates!
March 27th, 2018 10:49:09pm
922 Posts

SIIB IS A GODDESSSS






Breeder of HP's best Tennessee Walking Horses

 

Player Avatar
Moderator siib // santa jaws 🦈
March 28th, 2018 12:43:46am
2,513 Posts

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




 

Player Avatar
Moderator siib // santa jaws 🦈
April 5th, 2018 11:47:31am
2,513 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
tinselTANA ;; happy christmas month!
April 5th, 2018 1:28:54pm
8,795 Posts

Thank you, based shark goddess!




 

Player Avatar
Moderator siib // santa jaws 🦈
April 7th, 2018 10:12:47am
2,513 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
tinselTANA ;; happy christmas month!
April 7th, 2018 10:14:06am
8,795 Posts

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




 

Player Avatar
Moderator siib // santa jaws 🦈
April 7th, 2018 10:16:10am
2,513 Posts

Can do!




 

Player Avatar
renorooster ♥
April 7th, 2018 10:18:46am
1,072 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"

 




 

Player Avatar
Moderator siib // santa jaws 🦈
April 7th, 2018 10:19:19am
2,513 Posts

^ There ya go guys! Thanks Reno! lol 




 

Player Avatar
renorooster ♥
April 7th, 2018 10:19:50am
1,072 Posts

no problem!

 

Thanks for getting me started on this :)

Didn't know I needed it! haha




 

Player Avatar
Moderator siib // santa jaws 🦈
April 7th, 2018 10:22:35am
2,513 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.




 

Player Avatar
Peike ღ Mele Kalikimaka
June 20th, 2018 8:46:50am
2,084 Posts

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




Smiley face Smiley face Smiley face

 

Player Avatar
Moderator siib // santa jaws 🦈
June 20th, 2018 2:07:25pm
2,513 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. 




 

Player Avatar
Peike ღ Mele Kalikimaka
June 25th, 2018 8:36:09am
2,084 Posts

i may harass you about them soon xD




Smiley face Smiley face Smiley face

 

View Comments 1 2 Next >