A while back, I mentioned that some of the people I worked with had mad excel skills, and some people wrote in wanting to see examples. I finally found something I could post here that doesn’t violate any NDAs or contain sensitive company information: a teammate’s personal Asscher cut diamond pricing model (right click to download and open or save). [Updated June 28, 2007: unlocked version of spreadsheet now available.]
I realize this is a bit out of left field, so here’s a little background. Someone recently joined our group who’d built an Excel-based model to price out how much an Asscher cut diamond should cost, based on several factors. He did this so that he could get the right engagement ring for his fiancée, where “right” was defined as the biggest bang for the buck (though I have to say it’s a gorgeous ring, and I’m no diamond afficionado). After putting the model to good use, he posted publicly on a diamond forum, and I got his permission to post it here as well.