collapse

* Navigation

* User Info

 
 
Welcome, Guest. Please login or register.

* Who's Online

Author Topic: How does everyone keep track of collection  (Read 4542 times)

0 Members and 1 Guest are viewing this topic.

Offline NightGliderSA

  • Trade Count: (0)
  • Mommy & Baby Pony
  • ****
  • Posts: 1624
    • View Profile
Re: How does everyone keep track of collection
« Reply #30 on: January 29, 2019, 12:20:36 AM »
I also use an excel spreadsheet, always have. I input the details of each pony as I buy them, including all flaws that I might have noticed on the seller's listing, who I bought them from, when and where and for how much. And then when Pony arrives I update it. I have a photograph of each pony, before and after spa day. The folders are arranged in alphabetical order and ordered by Generation on my laptop, and on an external hard drive.

And as I don't have that many ponies (only just over 200 G1, including baits and ponies awaiting rehairing) I also remember who I have.

Then I have a separate folder for my original wish list (from 8 years ago before I knew who was rare and who wasn't and that some ponies might cost more than my kidney) and my wish list additions as I have learnt about more ponies. It is nice to be able to tick ponies off from a list once they arrive. I like ticking things off of lists, there is something just so satisfying about that.

Offline Elva

  • Trade Count: (+3)
  • Sweet Kisses Pony
  • **
  • Posts: 159
  • Gender: Female
    • View Profile
Re: How does everyone keep track of collection
« Reply #31 on: February 04, 2019, 06:03:10 AM »
A really bad photo but here are some examples from my MLP bullet journal! :)
visitors can't see pics , please register or login
visitors can't see pics , please register or login

Sig by Strawberrysweets, thank you!

Offline TheCraftess

  • Trade Count: (0)
  • Bratz Pony
  • *
  • Posts: 7
    • View Profile
Re: How does everyone keep track of collection
« Reply #32 on: February 05, 2019, 10:16:13 PM »
I keep a excel spreadsheet with details of all the ponies and accessories and their condition, and a photo log with before and after cleaning photos. But I’m thinking of setting up a Wordpress site to combine the two when I have time.

Offline applejackbunny

  • Trade Count: (+13)
  • Lil Cupcake Sister Pony
  • ****
  • Posts: 1012
  • Gender: Female
    • View Profile
Re: How does everyone keep track of collection
« Reply #33 on: February 09, 2019, 11:33:00 AM »
Excel spreadsheet and photo catalogue.
Current wish list: G1: Baby Princess Sparkle (dark purple var.), Dazzleglow (blue heart var.), Cha Cha the Llama; G3: Baby Northern Lights and Winter Ice, Pumpkin Tart Nirvanas: Any interesting Applejacks (esp. Colombian)!, Argie Tomatoberry, Sweet Tooth [/color]

Offline Starflashbaby

  • Trade Count: (+33)
  • Dabbles Pony
  • ****
  • Posts: 1370
  • Gender: Female
  • When life throws you bricks, build a Castle!
    • View Profile
    • Instagram
Re: How does everyone keep track of collection
« Reply #34 on: February 09, 2019, 07:45:16 PM »
I made an excel sheet on my computer desktop. you can use google Sheets on your android app.
I made the first 6 cells frozen so when i scroll down i see that at all times.
under Cell 1B I have [My little pony inventory list]
3B [Total number of Ponies]
4B [Total estimated value on all items]
5B [Year 1981-2018] 2B and 6B are blank
 
I then put this in 3C =SUM(I8:I888) I888 is how many ponies I almost have. I have 835 ponies, keep the letter the same as the the first letter and then it will add how many ponies you have...
So like it could be =SUM(B7:B1000) I hope that makes sence.....
so for me I Use the letter I. so in cells I7-I888 I put a pic and a number 1 behind the pic so the 1s can add up in Cell 3C. its a process.

so cells B7-I7
B7 My Little Pony Name, C7 Series / Notes, D7 Generation, E7 Country, F7 Condition, G7 Year/Make of Pony, H7 Value and HI pic and number 1 behind the pic.

more about cell Is
if you have 5 ponies in a box put 5 behind the pic instead of 1. your counting how many ponies you have. if the pic happens to be an accessory then don't put a number there. if its a play set with a pony put how many ponies there are with the play set. or if you have play sets separated from ponies so no pony in your pic leave it blank again.

Thats the way I set up my excel file then you back it up several times give it to a family member or put it in a bank safe box. Just  Back it up. and update all files as you get a pony.
if you buy every month then wait every 3 months then back up again.

by the way 4C would have =SUM(H8:H888) in it then it would add the value of your ponys
visitors can't see pics , please register or login

Sales, WTB, Commissions Open

Offline Broken Irishwoman

  • Trade Count: (+39)
  • G3 Prototype Pony
  • *****
  • Posts: 2535
  • Gender: Female
  • Revelation 13:16-13:18
    • View Profile
Re: How does everyone keep track of collection
« Reply #35 on: February 10, 2019, 05:35:30 AM »
A really bad photo but here are some examples from my MLP bullet journal! :)
visitors can't see pics , please register or login


Wow, that is so pretty! :D
visitors can't see pics , please register or login


He knows that they're the fool...

 

SimplePortal 2.3.5 © 2008-2012, SimplePortal