EPIC BPAL Spreadsheet Thread

[clephan]

updated => csv, xls 

 

as a warning, the xls does have a macro, but you can disable it. it does three things: replaces NULL with nothing, fixes the case for the name & area, and creates links from the number in hte review id.

 

i don't remember if it has ingenue in it, but it does have hemlock + some of the up&comings + the rest of the lunacy series.

Wonderful, many many thanks for that!

[Astarte]

Aye!

Thanks Qspice, I'd completely forgotten was what in some of the recent Ltd editions I'd ordered recently.

^^!!!

[metterklume]

many thanks, quantum spice - i was naughty and printed it out at work (after fidgiting it a bit to get it down to 13 pages from 40 or so!)

 

(the things we do for our addictions....and i can only imagine what will happen after i get my first order.)

[Scylla]

Wow. I admire your efficiency and compulsiveness--I mean organization! All of you!

[ipb]

the new perfumes have been added to the two files linked above.

[spark]

If anyone uses Filemaker, I have a database that includes pretty much everything, as far as I know (altho I haven't added single notes). It includes checkboxes for the majority of the notes, so you can search on whatever notes or combos you desire. Let me know if you want it.

[Pookstrell]

Oooh, thanks quantum spice- I didn't know such a thing was available... I'm a newbie

 

Ooh Andrabell, is this a different version? I'd love a copy!

[Effluvia]

ooooh, thanks so much!!!

[tart]

As my Black Phoenix addiction has grown, I've been ordering, sending, and receiving so many lovely perfumes. I didn't want to lose track of how many I've actually tried, so I finally put together a spreadsheet of my own.

 

The fields I'm using are:

Date

Name

Size

From (order, freebie, or swap)

Status (kept, swapped, or to be swapped)

Swapped From (travels of an imp purposes)

Swapped To (ditto)

 

The spreadsheet isn't really meant as a rating guide, or one to help me choose more perfumes in the future as it doesn't include scent descriptions yet. It's more like an inventory list.

 

So from my lovely spreadsheet, I can see that:

- I've decided to keep 6 imps for sure

- I've swapped away 11

- Two more need to be swapped

- I'm waiting for 16(!) scents to arrive

- Etcetera, etcetera.

 

I used Microsoft Excel to make my spreadsheet so if anyone is interested in seeing one for similar purposes, just let me know.

[tart]

Well . Just as I've posted this, the Excel sheet sorted incorrectly and everything is out of order.

 

ETA: I'm going to make a Microsoft Access version that should resist destruction.

Edited August 11, 2004 by tart

[spark]

Dude. Use FileMaker. I've got my little database and it allows me to search on all the different notes, so (for example) I can screen out the loathesome vetiver...

[Morrighana]

I use the oxymoron that is MSWorks for mine.

 

My categories are:

 

Name

Category

Sizes owned

Like/Dislike

Buy More?

Comments

Status (swap list, to be tested, permanent collection, etc)

Reviewed?

and Travel (To or from whom)

 

I my spreadsheet.

[SpinalDesign]

I have cheap little note books I got for 10 cents.. I keep all the different places I buy from and love in there own books .. bpal now has one . It's listed down the same way so it doesn't get confusing I even have a swap fairy book with all the information of who I am swapping with . This way I have everything on hand if I’m going someone where . The best smell I love are in my little back addiction book hehe.

[Scylla]

I was trying SOOOO hard to avoid getting obsessive about making a database....

 

But now you guys drove me to it!

 

Thanks, Morrighana. I used your field suggestions. And in MSWorks also.

[Daerk]

OpenOffice v1.1.2.

 

Free. Fast. Opensource. Allows you to save in .PDF format. Full compatibility with M$ Office formats, Corel formats, etc.

 

Ok now that i've finished pimping OpenOffice... I too have created a spreadsheet. Quite a few, actually. I'll upload them to my server sometime soonish and link to them here.

 

-- Daerk

[Belladonnastrap]

Open Office is my new best friend. I do most of my spreadsheet stuff working it <3

[Absinthe]

Apparently I need to keep a database, too. I just discovered that I have ANOTHER 5ml of Desire coming to me. Why couldn't I have made this mistake with Snake Oil or something?

[hadaverde]

I'm reviving this old thread in the hopes that one of you lovely people can hook me up with a current spreadsheet...?

 

 

Excel format would be splendid, if you have it, otherwise, CSV would be just as easy for me to work with.

 

Thanks in advance for any help!

[Ina Garten Davita]

I'm reviving this old thread in the hopes that one of you lovely people can hook me up with a current spreadsheet...?

 

 

Excel format would be splendid, if you have it, otherwise, CSV would be just as easy for me to work with.

 

Thanks in advance for any help!

<{POST_SNAPBACK}>

 

 

Happy Christmas.

[squishy87]

I'm reviving this old thread in the hopes that one of you lovely people can hook me up with a current spreadsheet...?

 

 

Excel format would be splendid, if you have it, otherwise, CSV would be just as easy for me to work with.

 

Thanks in advance for any help!

<{POST_SNAPBACK}>

 

Happy Christmas.

<{POST_SNAPBACK}>

 

 

I would love a spreadsheet too if you wouldn't mind!!

 

Thanks!!

[Ina Garten Davita]

 

[divajen]

Do any of you have a comprehensive list of all of the current BPAL scents? Alphabetical, organized by category, etc? I would love to add one to my computer so I can keep track of my likes, dislikes, make ordering/swapping easier and so on. Thanks!

 

Jenny

[Lina]

There is a thread on this that has a excel spreadsheet. The thread. and here is the link to the spreadsheet Click me!

[VorpalBunny]

Do I just need more coffee?

 

A lovely forumite sent me Nine Mysteries as a gift and I was saving it to try... so now I want to put comments in my spreadsheet but I can't seem to figure out where it would go under. Should I just add a new tab?

[harlequin]

*tee hee* I have the feeling this reminder comes on the heels of you seeing the spreadsheet on ebay?