Additional materials for The Deadly Spring

[Bruno]

I have a weirdly happy relationship with tables of material properties. For interested parties, I've dug up the properties for a few more materials for the Deadly Spring "Materials Lists Pounds" tab on the Deadly Spring spreadsheet. They're probably most useful for folks to base fantasy materials on, but it's interesting anyways.

Obviously Essential Yew and Giant Spider Silk are fantasy materials - I based them on real Yew and real Spider Silk under the theory that Essential materials are "three times as good" and I arbitrarily called Giant Spider Silk "Essential Spider Silk" because whadayagonnado.

The CODE tag seems to be preserving tabs, so you should be able to just insert these into your spreadsheet.

Common name 	Density (lbs/in3)	Tensile St (psi)	Elastic Modulus (psi)	Max Strain	A	Bow Cost/lb	Arrow Cost/lb
Bone (Antler)	 0.067 	 27,267 	 2,480,145 	1.10%	 1.02 	 $45 	 $5.1 
Bone (Cattle Femur, fresh)	 0.072 	 15,664 	 2,567,168 	0.61%	 1.03 	 $13 	 $5 
Essential Yew	 0.029 	 135,000 	 3,960,000 	3.41%	 1.20 	 $1598 	 $19.1 
Ivory (Indian Elephant)	 0.061 	 15,954 	 1,812,972 	0.88%	 1.07 	 $23 	 $4.1 
Silk (Silkworm)	 0.048 	 37,710 	 1,435,874 	2.63%	 1.07 	 $615 	 $12.3 
Silk (Spider)	 0.040 	 26,107 	 4,931,283 	0.53%	 0.64 	 $1750 	 $865 
Silk (Giant Spider)	 0.079 	 130,534 	 14,793,849 	0.88%	 0.46 	 $7250 	 $1295

[DouglasCole]

Originally Posted by Bruno

I have a weirdly happy relationship with tables of material properties. For interested parties, I've dug up the properties for a few more materials for the Deadly Spring "Materials Lists Pounds" tab on the Deadly Spring spreadsheet. They're probably most useful for folks to base fantasy materials on, but it's interesting anyways.

Obviously Essential Yew and Giant Spider Silk are fantasy materials - I based them on real Yew and real Spider Silk under the theory that Essential materials are "three times as good" and I arbitrarily called Giant Spider Silk "Essential Spider Silk" because whadayagonnado.

The CODE tag seems to be preserving tabs, so you should be able to just insert these into your spreadsheet.

Common name 	Density (lbs/in3)	Tensile St (psi)	Elastic Modulus (psi)	Max Strain	A	Bow Cost/lb	Arrow Cost/lb
Bone (Antler)	 0.067 	 27,267 	 2,480,145 	1.10%	 1.02 	 $45 	 $5.1 
Bone (Cattle Femur, fresh)	 0.072 	 15,664 	 2,567,168 	0.61%	 1.03 	 $13 	 $5 
Essential Yew	 0.029 	 135,000 	 3,960,000 	3.41%	 1.20 	 $1598 	 $19.1 
Ivory (Indian Elephant)	 0.061 	 15,954 	 1,812,972 	0.88%	 1.07 	 $23 	 $4.1 
Silk (Silkworm)	 0.048 	 37,710 	 1,435,874 	2.63%	 1.07 	 $615 	 $12.3 
Silk (Spider)	 0.040 	 26,107 	 4,931,283 	0.53%	 0.64 	 $1750 	 $865 
Silk (Giant Spider)	 0.079 	 130,534 	 14,793,849 	0.88%	 0.46 	 $7250 	 $1295

Thanks, Bruno. Thats pretty cool.

[munin]

For forum readability and discussion:

Common name               Density  Tensile St  Elastic Modulus  Max Strain      A  Bow Cost/lb  Arrow Cost/lb
                        (lbs/in3)       (psi)            (psi)
Bone (Antler)               0.067      27,267        2,480,145       1.10%   1.02          $45          $5.10
Bone (Cattle Femur, fresh)  0.072      15,664        2,567,168       0.61%   1.03          $13          $5 
Essential Yew               0.029     135,000        3,960,000       3.41%   1.20       $1,598         $19.10
Ivory (Indian Elephant)     0.061      15,954        1,812,972       0.88%   1.07          $23          $4.10
Silk (Silkworm)             0.048      37,710        1,435,874       2.63%   1.07         $615         $12.30
Silk (Spider)               0.040      26,107        4,931,283       0.53%   0.64       $1,750        $865
Silk (Giant Spider)         0.079     130,534       14,793,849       0.88%   0.46       $7,250      $1,295

[Flyndaran]

Thank you Munin for cracking the nut so I can get to the meatiness of Bruno's post. :)

[Bruno]

Eheh. Sorry, the forum's just not a good format for table transport.

It started with making up numbers for "Essential wood", but seeing a picture of a sort of ridiculous-looking fantasy-bow made out of deer antlers sent me kiting off on a side quest. By the numbers, antler makes an excellent heavy (non-metalic) war arrow for high ST archers, incidentally. Assuming you can find antlers long and straight enough for arrows :D

I'm figuring the cattle femurs are a good base for making up "dragonbone" for bone/crossbow material, although the result I suspect will be so stiff it won't be good for anything except arrows and risers/stocks. Unfortunately I couldn't find a study on dried bone that had all the numbers I wanted, just on fresh. Fresh bone would be more elastic, I suspect.

Silk seemed like an interesting alternative to sinew for composite material, and it turns out it's not too hard to find stats on spidersilk, with all the materials research going on with it.

Note that while there's an arrow cost for each material, it makes no more sense to make arrows out of giant spider silk than it does out of sinew :)

[acrosome]

Originally Posted by Bruno

By the numbers, antler makes an excellent heavy (non-metalic) war arrow for high ST archers, incidentally. Assuming you can find antlers long and straight enough for arrows :D

Well, yeah. There are African tribes who made very powerful bows not from antlers but from antelope horn. Various species have very long, straight horns, and it is pretty simple to join two of them at the base using a plug. (See the Bowyer's Bible book series- I think it's in book 5.) Voila- an incredibly powerful bow. Hope you ate your Wheaties.

And, yes, backing bows with silk instead of sinew is also historical.

[eustakos]

Ok,
and how do i use it in the excel-shet ?
i can replace existing lines in the Materials Tab, but i cant find a way to expand the selection.

MKS

[Bruno]

Originally Posted by eustakos

Ok,
and how do i use it in the excel-shet ?

I'm guessing you're new to excel? Actually, that was sort of mean of me to assume everyone using the spreadsheet is an excel supernerd, I know darn well most people hate the program *facepalm*

Originally Posted by eustakos

i can replace existing lines in the Materials Tab, but i cant find a way to expand the selection.

Select a whole row by clicking on the number on the far left (so, say, clicking on the "10" on the left)
Right click on the selected row, pick "Insert".
It'll insert new blank cells for you.

[stranger38]

Speaking of wierd materials or compositions or... whatever you guys are talking about, these days i've seen on youtube a dude who made a take down bow with skis! i really don't know how to even start to treat a bow like that... recurve competition bow? since it's glass fiber...

[sir_pudding]

Originally Posted by stranger38

Speaking of wierd materials or compositions or... whatever you guys are talking about, these days i've seen on youtube a dude who made a take down bow with skis! i really don't know how to even start to treat a bow like that... recurve competition bow? since it's glass fiber...

Doesn't TDS have fiberglass already?