What I did during my lunch hour

[mochiko42]

I decided to organize my OEC search into a sortable list based on stats and criteria important to me (e.g. spread). (pivot tables here I come..)

How do you all keep track of and compare the various stones you're considering when making a purchase?

 

[kenny]

OMG!
I thought nobody else was geeky enough to load all their candidate diamonds into a spreadsheet.

 

[mochiko42]

OMG!
I thought nobody else was geeky enough to load all their candidate diamonds into a spreadsheet.

Oh good! I'm not the only one...

But how else can you sort and filter the candidates otherwise??

 

[kenny]

OMG!
I thought nobody else was geeky enough to load all their candidate diamonds into a spreadsheet.

Oh good! I'm not the only one...

But how else can you sort and filter the candidates otherwise??

Some people here 'follow their heart' or wait for one to 'speak' to them.

Clearly you and I are worse than those who 'buy the paper'.
We buy the spreadsheet.

Boy, people surely do vary.

 

[mochiko42]

OMG!
I thought nobody else was geeky enough to load all their candidate diamonds into a spreadsheet.

Oh good! I'm not the only one...

But how else can you sort and filter the candidates otherwise??

Some people here 'follow their heart' or wait for one to 'speak' to them.

Clearly you and I are worse than those who 'buy the paper'.
We buy the spreadsheet.

Boy, people surely do vary.

Hahah definitely.

I think it's very important to "follow your heart" but I find it so difficult to judge that when doing the preliminary search on the Internet and vendor photos/videos vary so much. Spreadsheet is more for the initial screening and narrowing down of candidates.

Also you have so many options online and vendors present their info in so many ways, so I find it helpful to present the candidates in a consistent format for ease of reference.

Yes this is my OCD speaking! I have to organize the information into a tidy format.

 

[ForteKitty]

Where's the column that rates their level of attractiveness to you? Because you know old cuts can vary widely in appearance. Even AVRs aren't identical!

 

[Andelain]

I've got a spreadsheet that's kind of similar, but it's of diamonds that I already own.

 

[mochiko42]

Where's the column that rates their level of attractiveness to you? Because you know old cuts can vary widely in appearance. Even AVRs aren't identical!

Yup!! It's not shown on the screenshot but I have a column which sorts the candidates into "Consider" "Shortlist" "Archive" etc. depending on whether they are still in the running..

 

[mochiko42]

I've got a spreadsheet that's kind of similar, but it's of diamonds that I already own.

oooh boy... I have just started my collection so I have a long ways to go before I can do that!

 

[arkieb1]

I do the same thing but in handwriting, so I have spiralled bound notebooks with pages of diamond stats like this hand written of potential purchases - the old fashioned boring non techno savvy version

 

[chrono]

Spreadsheet user here too; it's just too easy to edit and keep track using it.

 

[LLJsmom]

I didn't know there was any other way. I'm just wondering how to post a live spreadsheet on PS.

 

[Andelain]

I didn't know there was any other way. I'm just wondering how to post a live spreadsheet on PS.

Here's my loose stone page. Someone could copy it and paste it into a spreadsheet if they wanted to. You'd have to quote me like you were going to reply to me, and copy all the text from there so the tabs would be there. That's how I send copies of spreadsheets when I can't send the actual attachment. You do lose your pretty formatting, fills, etc.


0.593 D VS-2 AGS Ideal Ideal VG black tray c Mar, 2014 PS AGS-104051517006 http://www.whiteflash.com/loose-diamonds/round-cut-loose-diamond-2645094.htm
0.328 E VS-2 AGS none Ideal Excellent black tray Jan, 2014 PS AGS-7414702 http://www.whiteflash.com/loose-diamonds/round-cut-loose-diamond-2178.htm
0.363 E SI-1 AGS Ideal Ideal Ideal grey tray 500 7/26/2014 LT AGS 0005173801 http://loupetroop.com/listings/loose-stones-diamond/star-star-sold-star-star-ags-ideal-0-diamond-pair
0.368 E SI-1 AGS Ideal Ideal Ideal grey tray 500 7/26/2014 LT AGS 0005173309 http://loupetroop.com/listings/loose-stones-diamond/star-star-sold-star-star-ags-ideal-0-diamond-pair
0.323 F VS-2 AGS Ideal Ideal Excellent black tray c Jan, 2014 PS AGS-104052321014 http://www.whiteflash.com/loose-diamonds/round-cut-loose-diamond-2673891.htm
0.35 F SI-2 AGS Ideal Ideal VG black tray c Mar, 2014 PS AGS-104051354025 http://www.whiteflash.com/loose-diamonds/round-cut-loose-diamond-2664810.htm
0.368 F SI-1 AGS Ideal Ideal Ideal black tray 836 Apr, 2014 ACA AGS-104065566094 http://www.whiteflash.com/loose-diamonds/round-cut-loose-diamond-2970630.htm?source=pricescope
0.405 G SI-2 AGS Ideal Ideal Ideal silver ring Apr, 2011 BGD Sig AGS-104048050057 http://www.briangavindiamonds.com/diamonds/diamond-details/0.405-g-si2-round-diamond-ags-104048050057
0.408 G SI-2 AGS Ideal Ideal Ideal grey tray 650 Apr, 2011 BGD Sig AGS-104048050049 http://www.briangavindiamonds.com/diamonds/diamond-details/0.408-g-si2-round-diamond-ags-104048050049
0.416 G SI-2 AGS Ideal Ideal Ideal grey tray 650 Apr, 2011 BGD Sig AGS-104047811034 http://www.briangavindiamonds.com/diamonds/diamond-details/0.416-g-si2-round-diamond-ags-104047811034
0.445 G SI-2 AGS Ideal Ideal Ideal grey tray 650 Apr, 2011 BGD Sig AGS-104049771044 http://www.briangavindiamonds.com/diamonds/diamond-details/0.445-g-si2-round-diamond-ags-104049771044
0.61 G SI-1 AGS Ideal Ideal Ideal grey tray ebay AGS-3177105 http://www.agslab.com/reportTypes/dqd.php?StoneID=3177105&Weight=0.61&D=1
0.614 H SI-2 AGS Ideal Ideal Ideal grey tray Mar, 2011 ACA AGS-104050642032 http://www.whiteflash.com/loose-diamonds/round-cut-loose-diamond-2618025.htm
0.394 I VS-2 AGS Ideal Ideal Good black tray Mar, 2014 PS AGS-104055218088 http://www.whiteflash.com/loose-diamonds/round-cut-loose-diamond-2728035.htm#
0.518 I SI-1 AGS Ideal Ideal Ideal grey tray Apr, 2011 BGD Sig AGS-104048050018 http://www.briangavindiamonds.com/diamonds/diamond-details/0.518-i-si1-round-diamond-ags-104048050018
0.83 I VS-2 GIA Excellent Excellent VG grey tray 2011 virtual GIA-2115317831 from ebay
0.422 J SI-2 AGS Ideal Ideal Ideal black tray c Jan, 2014 ACA AGS-104063246047 http://www.whiteflash.com/loose-diamonds/round-cut-loose-diamond-2890082.htm
0.8 N I-1 black tray 1000 Jan, 1995 recut by Brian Gavin, Sept 2010 [URL='https://www.pricescope.com/community/threads/what-do-you-think-of-this-diamond.149984/']https://www.pricescope.com/community/threads/what-do-you-think-of-this-diamond.149984/[/URL]

 

[cflutist]

I didn't know there was any other way. I'm just wondering how to post a live spreadsheet on PS.

Here's my loose stone page. Someone could copy it and paste it into a spreadsheet if they wanted to. You'd have to quote me like you were going to reply to me, and copy all the text from there so the tabs would be there. That's how I send copies of spreadsheets when I can't send the actual attachment. You do lose your pretty formatting, fills, etc.


0.593 D VS-2 AGS Ideal Ideal VG black tray c Mar, 2014 PS AGS-104051517006 http://www.whiteflash.com/loose-diamonds/round-cut-loose-diamond-2645094.htm
0.328 E VS-2 AGS none Ideal Excellent black tray Jan, 2014 PS AGS-7414702 http://www.whiteflash.com/loose-diamonds/round-cut-loose-diamond-2178.htm
0.363 E SI-1 AGS Ideal Ideal Ideal grey tray 500 7/26/2014 LT AGS 0005173801 http://loupetroop.com/listings/loose-stones-diamond/star-star-sold-star-star-ags-ideal-0-diamond-pair
0.368 E SI-1 AGS Ideal Ideal Ideal grey tray 500 7/26/2014 LT AGS 0005173309 http://loupetroop.com/listings/loose-stones-diamond/star-star-sold-star-star-ags-ideal-0-diamond-pair
0.323 F VS-2 AGS Ideal Ideal Excellent black tray c Jan, 2014 PS AGS-104052321014 http://www.whiteflash.com/loose-diamonds/round-cut-loose-diamond-2673891.htm
0.35 F SI-2 AGS Ideal Ideal VG black tray c Mar, 2014 PS AGS-104051354025 http://www.whiteflash.com/loose-diamonds/round-cut-loose-diamond-2664810.htm
0.368 F SI-1 AGS Ideal Ideal Ideal black tray 836 Apr, 2014 ACA AGS-104065566094 http://www.whiteflash.com/loose-diamonds/round-cut-loose-diamond-2970630.htm?source=pricescope
0.405 G SI-2 AGS Ideal Ideal Ideal silver ring Apr, 2011 BGD Sig AGS-104048050057 http://www.briangavindiamonds.com/diamonds/diamond-details/0.405-g-si2-round-diamond-ags-104048050057
0.408 G SI-2 AGS Ideal Ideal Ideal grey tray 650 Apr, 2011 BGD Sig AGS-104048050049 http://www.briangavindiamonds.com/diamonds/diamond-details/0.408-g-si2-round-diamond-ags-104048050049
0.416 G SI-2 AGS Ideal Ideal Ideal grey tray 650 Apr, 2011 BGD Sig AGS-104047811034 http://www.briangavindiamonds.com/diamonds/diamond-details/0.416-g-si2-round-diamond-ags-104047811034
0.445 G SI-2 AGS Ideal Ideal Ideal grey tray 650 Apr, 2011 BGD Sig AGS-104049771044 http://www.briangavindiamonds.com/diamonds/diamond-details/0.445-g-si2-round-diamond-ags-104049771044
0.61 G SI-1 AGS Ideal Ideal Ideal grey tray ebay AGS-3177105 http://www.agslab.com/reportTypes/dqd.php?StoneID=3177105&Weight=0.61&D=1
0.614 H SI-2 AGS Ideal Ideal Ideal grey tray Mar, 2011 ACA AGS-104050642032 http://www.whiteflash.com/loose-diamonds/round-cut-loose-diamond-2618025.htm
0.394 I VS-2 AGS Ideal Ideal Good black tray Mar, 2014 PS AGS-104055218088 http://www.whiteflash.com/loose-diamonds/round-cut-loose-diamond-2728035.htm#
0.518 I SI-1 AGS Ideal Ideal Ideal grey tray Apr, 2011 BGD Sig AGS-104048050018 http://www.briangavindiamonds.com/diamonds/diamond-details/0.518-i-si1-round-diamond-ags-104048050018
0.83 I VS-2 GIA Excellent Excellent VG grey tray 2011 virtual GIA-2115317831 from ebay
0.422 J SI-2 AGS Ideal Ideal Ideal black tray c Jan, 2014 ACA AGS-104063246047 http://www.whiteflash.com/loose-diamonds/round-cut-loose-diamond-2890082.htm
0.8 N I-1 black tray 1000 Jan, 1995 recut by Brian Gavin, Sept 2010 [URL='https://www.pricescope.com/community/threads/what-do-you-think-of-this-diamond.149984/']https://www.pricescope.com/community/threads/what-do-you-think-of-this-diamond.149984/[/URL]

Wow, you've got quite an extensive collection there. I use Excel spreadsheets too and have our home inventory on a MS Access database.

 

[Andelain]

Wow, you've got quite an extensive collection there. I use Excel spreadsheets too and have our home inventory on a MS Access database.

That's just the loose stuff. I didn't want to add in the mounted stones on that post.

 

[kenny]

After inputing several diamonds into a spreadsheet I was still unable to pick my favorite.

What I WAS able to do was reject the worst one for this spec or that quality.
Then I rejected the next-worst one.
Lather.
Rinse.
Repeat.

Finally I was left with one diamond.
I guess that's becuase I'm such a cynical old fart. ... or Kenny's brain is like HCA, a rejection tool.