[DF 8] On Gemstones and Carats

[Bruno]

Originally Posted by Peter Knutsen

It's very possible to create a "cheat sheet", using Excel or Calc, for a variety of standard gemstone types and sizes.

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

Can't use it in GDocs as GDocs does not support drop down boxes and images, so you'll need to download it and open it in Excel to use it;

https://docs.google.com/open?id=0B9v...19sRmJGZzk4STQ

To download go to the GDocs file menu and pick Download. :D

Usage: Click on the orange box next to Gem to pick your gem type from the dropdown list.
Click on the orange box next to Shape to pick the shape of your gem (see the pictures at the bottom of the sheet for examples of everything except Polished Sphere to see what I mean).
Enter the Diameter of your gem and pick your units from the dropdown box (supports Inches and CM)

Sheet gives you volume, weight in ounces, grams, and carats, and gives you the value according to DF8.

I'm working on an alternate to the gems table, splitting it up into precious and semi-precious and calculating the value of each differently. This version has a separate gem quality table, giving you quality ranges from Poor to Flawless (multiplies cost from 1/5x to 5x that indicated by weight).

[cmdicely]

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.

Can't use it in GDocs as GDocs does not support drop down boxes and images

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.

[Blind Mapmaker]

That's a neat spreadsheet, Bruno. Many thanks. Makes it much easier to visualize what the gems actually look like for those of us who never deal in 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 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?

[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?

[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.