Re: [DF 8] On Gemstones and Carats
 

If you offer this in an attempt to quench my deep, dark hatred for you...

...it worked! XD

Now, I only have to get MS Office. I saved it in my GURPS folder for one day when I finally get it.

Thanks!!! :D

Re: [DF 8] On Gemstones and Carats
 

I added this in an edit to my earlier post, but I'll risk the redundancy for the greater visibility of a new post: I just posted a quick conversion of Bruno's sheet in native Google Spreadsheet form, so you can use it online without Office.

Re: [DF 8] On Gemstones and Carats
 

What is the DF8 rule for semiprecious gems? I've forgotten. Cost linear with mass?

Re: [DF 8] On Gemstones and Carats
 

Can't Libre Office open the file?

Re: [DF 8] On Gemstones and Carats
 

Of course DF gems are likely measured in ounces. if not pounds...

Re: [DF 8] On Gemstones and Carats
 

Thanks!

Quick question in case I don't figure it out right away, how does one edit the fields? I tried clicking, double-clicking and right-clicking...

I can edit the carats field, right?

Either way, the spreadsheet looks great!

DF8: "The value of a gem in $ is (C2 + 4 x C) x V, where C is the weight of the gem in carats and V is the Value modifier for the gemstone."

Low-Tech: "Gemstones have a nominal price given by: Price = ($1 x C2 + $4 x C) x V"

Re: [DF 8] On Gemstones and Carats
 

I'm using Firefox 3.6, which apparently isn't fully compatible with Google Docs. Upgrading to Chrome should make it work (though in my case my OS is too old to allow that). You can also try Open Office, which seems to open the .xls file, though some options may not be compatible (there are some #VALUE fields on the third sheet).

Re: [DF 8] On Gemstones and Carats
 

Its set to view-only (so anyone using it doesn't edit the original) so you need to make a copy of the spreadsheet in Docs to work with. Once you do that, the shaded areas are where you should edit (blue are drop downs, the diameter is a direct entry.)

The other cells are formula driven (including carats, which is one of the weight measures), which is the same way Bruno's works -- the intended use is entering the diameter and the weight is calculated from that, the shape, and the kind of gem.

There's no actual protection on fields, except the data validation on the shaded fields, but changing other things will break formulas, so you should only do that if you are reworking the form.

Re: [DF 8] On Gemstones and Carats
 

Awesome! If you can't tell, I'm not really familiar with Google Spreadsheet :D

Aren't I sneaky?

DF8 doesn't have a separate pricing system for semiprecious, and doesn't actually make a distinction. Which makes about as much sense as anything else in a fantasy world and it's not like the precious gem numbers are particularly historical (most valuable is diamons), but it still annoys me.

The one I did, and cmdicely's conversion it looks like, both calculate carats from gem type (which references real world gem specific gravity) and volume (based on diameter at widest point and some generic sizes/shapes).

You can type over the formula in the carats field in your copy and just either don't save it, or "Undo" before saving to get the formula back. Or save a second copy for typing the carats number in by hand, which is probably safer now that I think about it.

As DF8 doesn't give a mouses fart about whether the gems are cut, shaped, opaque, sparkly, flawed, or up a dragons nose at the time, there is no cost adjustment for the various cuts/shapes included other than to account for volume differences.

I'm making a slightly fussier spreadsheet that

A) lists semi-precious (based on modern definitions of semi-precious) separately from precious and uses a different value calculation (C^1.02 * V which seems "good enough")

and B) introduces an (optional) roll for quality, which will abstractly cover the whole range of funny/perfect colour, stylish/tacky cut, valuable amber inclusion vs terrible inclusion in another type, flaws, etc etc.

Everything is coming with DF8 compatible table rolls, with the goal of being a drop in replacement. I've had to add a couple more semi-precious stones to make those table rolls work out :P

Once I'm happy with it, I'll figure out how the drop-downs work in GDocs and put it up :D

Re: [DF 8] On Gemstones and Carats
 

BTW: cmdicely, your version of the spreadsheet has unfortunately hashed up the inches/cm - you're using the conversion between linear inches and linear cm, but the actual units involved are CUBIC inches vs CUBIC cm. Your value on the units sheet for inches needs to be 2.54^3 or 16.387064