[DF 8] On Gemstones and Carats

[Stripe]

Originally Posted by Bruno

Just made one, specifically aimed at the OP :D

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

[cmdicely]

Originally Posted by Stripe

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

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.

[Peter Knutsen]

Originally Posted by Bruno

Just made one, specifically aimed at the OP :D It uses the exact rules from DF8, even though they're questionable for semiprecious gems.

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

[Peter Knutsen]

Originally Posted by Stripe

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

Can't Libre Office open the file?

[Captain-Captain]

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

[Stripe]

Originally Posted by cmdicely

I just posted a quick conversion of Bruno's sheet in native Google Spreadsheet form, so you can use it online without Office.

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!

Originally Posted by Peter Knutsen

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

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"

[vierasmarius]

Originally Posted by Stripe

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'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).

[cmdicely]

Originally Posted by Stripe

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!

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.

[Bruno]

Originally Posted by cmdicely

Google Docs may not support importing those from Excel, but it definitely supports drop-down boxes and images.

EDIT: Did a quick conversion to a native Google Spreadsheet of the working part of Bruno's spreadsheet (there's more in Bruno's that doesn't connect to the actual calculation part, and that's not included) -- minus the images for now.

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

Originally Posted by Stripe

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

...it worked! XD

Aren't I sneaky?

Originally Posted by Peter Knutsen

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

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.

Originally Posted by Stripe

I can edit the carats field, right?

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

[Bruno]

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