Jump to content


Photo

how can i keep track of what bpal i've tried?


  • Please log in to reply
598 replies to this topic

#576 sunlitgarden

sunlitgarden

    1/32 too few

  • Members
  • 2,544 posts
  • Ox
  • Scorpio
  • United States

Posted 25 November 2012 - 08:24 AM

Sunlitgarden, thanks for keeping the spreadsheet updated and good work! Quick question - I seem to be able to edit the spreadsheet. Should that be happening, or am I just editing my own version of it? As a test, I added "abc" to the note description of Yuletide 2005 in the last line of the spreadsheet (line #2976). Can you see that?

If anyone can edit the spreadsheet, that's a problem, right? I don't want to be able to accidentally mess things up!

Also, I'm confused by the sorting method; eg. there are LE Yules both at the very bottom and very top of the spreadsheet, and Hellfire is on line 5 among unreleased scents and Lunacies instead of with the rest of the GC Sin & Salvation category...could it be organised in a more intuitive way?


I designed it originally so that other people could update it also, because I tend to get busy and forget about some projects that I have (such as this, it's been a few months since I've updated it, as you can see.) Unfortunately, it looks like the sorting got messed up somehow and now it's all jumbled up. The original Hackess spreadsheet was in roughly chronological order, but not all the scents have dates, so it can't really be re-sorted that way.... I'm thinking of just editing my copy and uploading a whole new one since it doesn't look like there have been any significant edits since I last worked on it.

#577 coltostallion

coltostallion

    evil enabler

  • Members
  • 284 posts
  • SotD:The Black Rider
  • Dragon
  • Gemini
  • Japan

Posted 28 November 2012 - 09:35 AM


Sunlitgarden, thanks for keeping the spreadsheet updated and good work! Quick question - I seem to be able to edit the spreadsheet. Should that be happening, or am I just editing my own version of it? As a test, I added "abc" to the note description of Yuletide 2005 in the last line of the spreadsheet (line #2976). Can you see that?

If anyone can edit the spreadsheet, that's a problem, right? I don't want to be able to accidentally mess things up!

Also, I'm confused by the sorting method; eg. there are LE Yules both at the very bottom and very top of the spreadsheet, and Hellfire is on line 5 among unreleased scents and Lunacies instead of with the rest of the GC Sin & Salvation category...could it be organised in a more intuitive way?


I designed it originally so that other people could update it also, because I tend to get busy and forget about some projects that I have (such as this, it's been a few months since I've updated it, as you can see.) Unfortunately, it looks like the sorting got messed up somehow and now it's all jumbled up. The original Hackess spreadsheet was in roughly chronological order, but not all the scents have dates, so it can't really be re-sorted that way.... I'm thinking of just editing my copy and uploading a whole new one since it doesn't look like there have been any significant edits since I last worked on it.


Please do! I've been trying to keep my spreadsheet up to date but I'm about sixish months behind.

#578 Fuhrankie

Fuhrankie

    obsessive precious hoarder

  • Members
  • 2,064 posts
  • Tiger
  • Aquarius
  • Australia

Posted 28 November 2012 - 11:58 AM


I keep track of mine in an Access database that I designed myself. I can search fragrance descriptions as well as personal notes on a scent. Very handy, especially as I've added filters for owned/unowned. Looking for a scent with patchouli? Easy. If anyone is interested in seeing it, they're welcome to ask, but I haven't added many scents yet. Just ones so far that I'm interested in.
One of the best things I've ever done in Access. XD



I'd be very interested in seeing this - it sounds really handy :D

Here's a link to my working version: https://sites.google...redirects=0&d=1

It's still very much in alpha, but it's going to be filled with fabulous fragrances when I finally get around to it!

Sorry for not getting back to you sooner.

#579 sunlitgarden

sunlitgarden

    1/32 too few

  • Members
  • 2,544 posts
  • Ox
  • Scorpio
  • United States

Posted 03 December 2012 - 06:02 PM

I've been working on updating the spreadsheet, I have through the Weenies added. I'll hopefully finish getting it up to date tonight and then upload a new version.

#580 sunlitgarden

sunlitgarden

    1/32 too few

  • Members
  • 2,544 posts
  • Ox
  • Scorpio
  • United States

Posted 04 December 2012 - 04:10 AM

Hopefully this will work in Excel (I saved it using OpenOffice, but in xls format, so it should hopefully work.) Everything up through Anniversaries should be in here now, although I didn't add the exact dates for many of the Lunacies and such, because honestly, I really didn't feel like looking them all up. The more recent scents should all be in chronological order, but scents from before 2007 or so may not be. (Since I started using this spreadsheet a couple years ago, the new scents have just been added onto the end.) I'm gonna scrap the Google Doc for now because it just is too slow for a document of this size, it lags when I try to scroll through it.

http://home.comcast....Spreadsheet.xls

Edited by sunlitgarden, 04 December 2012 - 04:11 AM.


#581 coltostallion

coltostallion

    evil enabler

  • Members
  • 284 posts
  • SotD:The Black Rider
  • Dragon
  • Gemini
  • Japan

Posted 04 December 2012 - 01:31 PM

Hopefully this will work in Excel (I saved it using OpenOffice, but in xls format, so it should hopefully work.) Everything up through Anniversaries should be in here now, although I didn't add the exact dates for many of the Lunacies and such, because honestly, I really didn't feel like looking them all up. The more recent scents should all be in chronological order, but scents from before 2007 or so may not be. (Since I started using this spreadsheet a couple years ago, the new scents have just been added onto the end.) I'm gonna scrap the Google Doc for now because it just is too slow for a document of this size, it lags when I try to scroll through it.

http://home.comcast....Spreadsheet.xls


Thank you!

#582 sunlitgarden

sunlitgarden

    1/32 too few

  • Members
  • 2,544 posts
  • Ox
  • Scorpio
  • United States

Posted 05 December 2012 - 05:23 AM

I realized I forgot to put the new RPG scents in there! :eek: I'll do that in the next day or two, whenever I get to it.

#583 RavenintheWind

RavenintheWind

    casual sniffer

  • Members
  • 8 posts
  • Mood:ready for vacaiion
  • SotD:Autumn Lace
  • Horse
  • Taurus
  • United States

Posted 03 January 2013 - 07:00 PM

Thank you for the spreadsheet to track my collection. I need to get a handle on all the treasures...

#584 murflegirl

murflegirl

    casual sniffer

  • Members
  • 7 posts
  • Tiger
  • Scorpio
  • United States

Posted 19 March 2013 - 01:09 AM

Seconded. The collection tracking function in this forum is by far one of the best things I've ever experienced on the internets.

#585 ClareN

ClareN

    Dr. Girlfriend

  • Members
  • 1,092 posts
  • Rat
  • Pisces
  • Australia

Posted 19 April 2013 - 04:38 AM

Anyone have a more recent version? Looking for Pickman Gallery and this year's Lupercalias :)

#586 izile

izile

    1/32 too few

  • Members
  • 3,292 posts
  • Mood:haungry
  • SotD:Lilac Wood
  • Ram
  • Virgo
  • United States

Posted 04 September 2013 - 07:54 PM

I have the Lupers - but that's about it - and I can't be sure I have all or there aren't gaps. I'm not good at this.

https://docs.google....bGc&usp=sharing

that's what I've got - but you'd have to strip out the color coding and tally codes in the first column. And that has nothing SINCE the Lupers - oy - was hoping someone else had been going and could help fill in the gaps.

EDIT:

OK, I gave myself a project - and I think it's *mostly* updated, basically went off the "new" page, so if it's there, it's on the google doc - I got a dead link for the last pickman stuff with Lilith's creations, so those aren't there (yet)

Edited by izile, 04 September 2013 - 09:05 PM.


#587 TwilightEyes

TwilightEyes

    must be 5mL to ride

  • Members
  • 5,254 posts
  • SotD:Snake Oil
  • Dog
  • Virgo
  • United States

Posted 05 September 2013 - 05:09 AM

If you guys are missing scents you should be able to get all of the scent notes (and usually accompanying photos) from scentbase.com.

#588 izile

izile

    1/32 too few

  • Members
  • 3,292 posts
  • Mood:haungry
  • SotD:Lilac Wood
  • Ram
  • Virgo
  • United States

Posted 05 September 2013 - 02:17 PM

If you guys are missing scents you should be able to get all of the scent notes (and usually accompanying photos) from scentbase.com.


Yeah, but a lot of times, how would you even *know* what you were missing, if it was missing? Yes, if I remembered "oh, I'm missing "___" I could go find the notes, hell, even in the BPAL reviews section - but I'm not even aware of what my gaps might be (aside from TAL/BPTP - maybe if I get a quiet bit today, I'll look at catching up on BPTP, at least)

BUT, I think my list is now complete - as far as I'm aware -

#589 TwilightEyes

TwilightEyes

    must be 5mL to ride

  • Members
  • 5,254 posts
  • SotD:Snake Oil
  • Dog
  • Virgo
  • United States

Posted 06 September 2013 - 01:52 AM


If you guys are missing scents you should be able to get all of the scent notes (and usually accompanying photos) from scentbase.com.


Yeah, but a lot of times, how would you even *know* what you were missing, if it was missing? Yes, if I remembered "oh, I'm missing "___" I could go find the notes, hell, even in the BPAL reviews section - but I'm not even aware of what my gaps might be (aside from TAL/BPTP - maybe if I get a quiet bit today, I'll look at catching up on BPTP, at least)

BUT, I think my list is now complete - as far as I'm aware -

You'd do a search for pickman gallery, Yule, halloweenies, whatever.

#590 reynardine

reynardine

    sexy swapper

  • Members
  • 586 posts
  • SotD:Snakes in the Pumpkin Patch
  • Horse
  • Aquarius
  • United States

Posted 23 November 2013 - 02:49 AM

Izile Thank you so much for your update! I still use a spreadsheet since I'm used to that, so your work is very appreciated!

btw, I'm updating the old spreadsheet from Hackness/Sunlitgarden's one. I pasted Izile's updates and got it updated through the 2013 Yule Update. I still need to go through the BPTP updates and TALs and make sure those are current. Will post it once that's done.

Edited by reynardine, 23 November 2013 - 04:33 AM.


#591 izile

izile

    1/32 too few

  • Members
  • 3,292 posts
  • Mood:haungry
  • SotD:Lilac Wood
  • Ram
  • Virgo
  • United States

Posted 25 November 2013 - 10:05 PM

Izile Thank you so much for your update! I still use a spreadsheet since I'm used to that, so your work is very appreciated!

btw, I'm updating the old spreadsheet from Hackness/Sunlitgarden's one. I pasted Izile's updates and got it updated through the 2013 Yule Update. I still need to go through the BPTP updates and TALs and make sure those are current. Will post it once that's done.


no problem! but oh! I haven't had a chance to update futher, do you have a link to the one you've been working on with the Yule update?

#592 mermaidsdream

mermaidsdream

    1/32 too few

  • Members
  • 2,724 posts
  • SotD:Spanked Revisited
  • Ox
  • Aries
  • United States

Posted 25 November 2013 - 10:50 PM

I'm still itching for a BPAL iPhone/iPad/Android app ;) That said, I wouldn't even know where to begin coding one.

#593 reynardine

reynardine

    sexy swapper

  • Members
  • 586 posts
  • SotD:Snakes in the Pumpkin Patch
  • Horse
  • Aquarius
  • United States

Posted 10 December 2013 - 06:57 PM

izile, sorry it took so long to reply! I uploaded what I have so far on google.docs over here. The BPAL is up to date through the We Love Fine scents (and includes the Yule updates), but I'm still catching up with the Trading Posts' updates, so those aren't current yet. I don't have all the discontinued dates yet either--it takes a while to go through the old announcements!

#594 izile

izile

    1/32 too few

  • Members
  • 3,292 posts
  • Mood:haungry
  • SotD:Lilac Wood
  • Ram
  • Virgo
  • United States

Posted 17 December 2013 - 03:25 PM

izile, sorry it took so long to reply! I uploaded what I have so far on google.docs over here. The BPAL is up to date through the We Love Fine scents (and includes the Yule updates), but I'm still catching up with the Trading Posts' updates, so those aren't current yet. I don't have all the discontinued dates yet either--it takes a while to go through the old announcements!


oh thanks so much!

-k, I updated the BPTP tab on my google doc all the way up through yules (even got the dorian HG and the bliss smooch - think that's all new in the GC area) - can let me know if I missed anything, but think that's up to date now, too.

Edited by izile, 17 December 2013 - 05:01 PM.


#595 vanilla323

vanilla323

    1/32 too few

  • Members
  • 3,911 posts
  • Mood:Let Them Eat Cake!
  • SotD:Dragon's Milk
  • Ox
  • Cancer
  • United States

Posted 17 December 2013 - 10:36 PM

I keep my bottle list up to date on here and I also have a notebook to keep track of things I've tried/sold/swapped too.

#596 izile

izile

    1/32 too few

  • Members
  • 3,292 posts
  • Mood:haungry
  • SotD:Lilac Wood
  • Ram
  • Virgo
  • United States

Posted 27 January 2014 - 09:14 PM

Just added lupers and clive barker - haven't don'e BPTP lupers yet. - *whew* trying to keep a head on this.

#597 Wren12

Wren12

    obsessive precious hoarder

  • Members
  • 1,138 posts
  • Mood:Bemused
  • SotD:VILF + Madagascan Vanilla (try it!)
  • Rooster
  • Scorpio
  • United States

Posted 03 March 2014 - 06:10 AM

I have the Lupers - but that's about it - and I can't be sure I have all or there aren't gaps. I'm not good at this.

https://docs.google....bGc&usp=sharing

that's what I've got - but you'd have to strip out the color coding and tally codes in the first column. And that has nothing SINCE the Lupers - oy - was hoping someone else had been going and could help fill in the gaps.

EDIT:

OK, I gave myself a project - and I think it's *mostly* updated, basically went off the "new" page, so if it's there, it's on the google doc - I got a dead link for the last pickman stuff with Lilith's creations, so those aren't there (yet)


Izile, this is simply amazing!! Thank you so much for sharing it with us all!!

<3 :wub2:

#598 izile

izile

    1/32 too few

  • Members
  • 3,292 posts
  • Mood:haungry
  • SotD:Lilac Wood
  • Ram
  • Virgo
  • United States

Posted 25 March 2014 - 01:16 PM

nervous energy this morning - finished updating the Lupers BPTP update, and added the new Alice and Emerald City (and Lunacy) - think it's up to date.

(as ever, ignore the color coding, and column A, that's all personal notation)

Izile's BPAL Spreadsheet

#599 meaganola

meaganola

    must be 5mL to ride

  • Members
  • 5,707 posts
  • Pig
  • Aquarius
  • United States

Posted 12 April 2014 - 06:25 PM

nervous energy this morning - finished updating the Lupers BPTP update, and added the new Alice and Emerald City (and Lunacy) - think it's up to date.

(as ever, ignore the color coding, and column A, that's all personal notation)

Izile's BPAL Spreadsheet


Ooh, *fantastic*. I finally got my new (well, okay, at this point, a few months old) laptop set up with Open Office last night (aargh, security settings!) and was getting ready to go through the insanely arduous process of updating the spreadsheet I had on my old laptop with far too many months of missing updates. This saves me a ton of work. Thank you!


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users