Spreed sheet info, you can help! :)

Discover best blacksmiths' secrets, share yours!
Forum rules
Be gentle and polite. Any agressive or disrespectful message will be removed and could lead to a ban of its author (hey! we are blacksmith too, we have a Ban Hammer). Try to use at its best all sections, and if it seems the forum doesn’t contains a section fiting your topic, send a message to the moderation team.

Spreed sheet info, you can help! :)

Postby playhavock » Mon Feb 23, 2015 5:13 pm

I've made a simple excel document that I filled with the basic low end equipment thus far:

https://drive.google.com/file/d/0B2PqFy ... sp=sharing

Here you can comment on it and make changes:

https://docs.google.com/spreadsheets/d/ ... sp=sharing

Now, I'd hope we would put in real info and that people will not mess this up - but its the net so that might happen, I'm not sure. What I'd like to see is people to add more to this like a wiki. What does an ax with 2 bronze ore and 1 iron ore have stat wise? What does a single gem do to enhance a "rustic" (bronze ore only) weapon?
What does 1 magic do? And so on and so forth. If we all put in effort on this, it should grow to show all possible combos and so on, if not then this idea dies :D

Lets see what happens... if this already exists let me know :D
P1: Either Lobsters exist, or I am not awesome.
P2: Lobsters exist.
C: I am awesome.
Check out my minecraft built of Tuesday Quest Dude! viewtopic.php?f=27&t=67
User avatar
playhavock
 
Posts: 151
Joined: Mon Feb 23, 2015 4:55 pm

Re: Spreed sheet info, you can help! :)

Postby lucek_86 » Mon Feb 23, 2015 7:29 pm

Nice idea!
Useful, when creating weapon for adventurer.
It suits perfectly to land on wiki when finished :)
I suggest to add price to this. Nice to know how much you will earn, when trying to buy something in particular day. Information about basic prices + rule that every enchantment point adds 3 to gold value would also be very useful.
User avatar
lucek_86
 
Posts: 140
Joined: Mon Jan 05, 2015 2:57 pm

Re: Spreed sheet info, you can help! :)

Postby Aleksandra » Tue Feb 24, 2015 9:46 am

Price is simply sum of attack, defence and speed for weapon without gem.
Aleksandra
 
Posts: 45
Joined: Sun Jan 11, 2015 11:11 pm

Re: Spreed sheet info, you can help! :)

Postby lucek_86 » Tue Feb 24, 2015 11:00 am

Aleksandra wrote:Price is simply sum of attack, defence and speed for weapon without gem.

Thats right.
Someone figured out what is the factor of price change for gems?
User avatar
lucek_86
 
Posts: 140
Joined: Mon Jan 05, 2015 2:57 pm

Re: Spreed sheet info, you can help! :)

Postby lucek_86 » Thu Feb 26, 2015 12:23 pm

playhavock wrote:What does 1 magic do?

Every single enchantment added to weapon by molds and gems combined, sums up and is added to stats in one of two ways:
1. All three stats are increased by enchantment value
example: rustic sword - att: 3; def: 2; spd: 2
rustic sword + 2 ench - att: 5; def: 4; spd: 4
2. One stat is increased by three times enchantment value
example: rustic sword - att: 3; def: 2; spd: 2
rustic sword + 2 ench - att: 9; def: 2; spd: 2
2a. Every stat can be boosted. I believe that it's random, but there are more chances for enchantment placed in particular molds:
blade - att or spd
handle - spd or def
plate - att or def
For example claws with enchantment usually have boosted speed value (but not always).
Additional observation made by Aleksandra is, that if You are creating few weapons in combo, then different stats are boosted in each weapon. For example if you make 3x combo with all blades, you probably will get one claws with boosted att, second claws with boosted spd and third claws with boosted def.

playhavock wrote:What does a single gem do to enhance a "rustic" (bronze ore only) weapon?

Gems affect only price and does not change weapon stats.
If gem have enchantment on it, gathered from forge during it's creation, then it's enchantment value is added to whole weapon enchantment value and acts like described above.

playhavock wrote:Here you can comment on it and make changes:
https://docs.google.com/spreadsheets/d/ ... sp=sharing

Link you provided is for google sheet, but read only.
If You want us to make changes, please change permission to allow modifcations or at least comments (if you want to accept changes yourself, by moving it from comments to table).
User avatar
lucek_86
 
Posts: 140
Joined: Mon Jan 05, 2015 2:57 pm

Re: Spreed sheet info, you can help! :)

Postby playhavock » Tue Mar 03, 2015 3:33 am

no one has added anything V_V;
P1: Either Lobsters exist, or I am not awesome.
P2: Lobsters exist.
C: I am awesome.
Check out my minecraft built of Tuesday Quest Dude! viewtopic.php?f=27&t=67
User avatar
playhavock
 
Posts: 151
Joined: Mon Feb 23, 2015 4:55 pm

Re: Spreed sheet info, you can help! :)

Postby lucek_86 » Tue Mar 03, 2015 7:52 am

I wrote You already.
It's not editable.
Give us link with permission to edit, not only to read.
User avatar
lucek_86
 
Posts: 140
Joined: Mon Jan 05, 2015 2:57 pm

Re: Spreed sheet info, you can help! :)

Postby lucek_86 » Tue Mar 03, 2015 12:23 pm

OK, I did some research and I want to share this spreadsheet:
PF2 - prices

There are two sheets there. (change at the bottom of page if you like)
1. First is about items in shop.
2. Second is like yours but I want some more data in it - it would be nice to find overall formula for pricing weapon.

I believe it's something like:
material_factor * sum_of_stats-ench_incluided * gem factor
or
material_factor * sum_of_stats * gem factor + enchantment * 3
or even something else.
I don't know yet.

This one is enabled for everyone to comment (not giving edit, because I don't want to loose data).
I'll try to verify comments and move values to spreadsheet.
Please comment anything and if you want to add something feel free to write about it.
User avatar
lucek_86
 
Posts: 140
Joined: Mon Jan 05, 2015 2:57 pm

Re: Spreed sheet info, you can help! :)

Postby lucek_86 » Wed Mar 04, 2015 3:33 pm

I put some data in my spreadsheet and came out with a conclusion.

Overal price formula:
Base price of form 1 + Base price of form 2 + Base price of form 3 +
+ Sum of base stats + 3 * Enchantment value + 20 * Gem value

Base form prices:
  • 1 - bronze
  • 3 - iron
  • 9 - silver
  • 27 - gold
  • 81 - crystal
  • 243 - netherium

Base stats can be found in spreadsheets, but not yet all fields are filled.

Knowing that every enchantment point increases sum of stats by 3, we can simplify formula, to:
Base price of form 1 + Base price of form 2 + Base price of form 3 +
+ Sum of end stats + 20 * Gem value

Now the problem is, to know what stats will weapon have before it's made.
User avatar
lucek_86
 
Posts: 140
Joined: Mon Jan 05, 2015 2:57 pm

Re: Spreed sheet info, you can help! :)

Postby playhavock » Sat Mar 14, 2015 8:28 am

fixed mine so you can edit lol...
woops.
P1: Either Lobsters exist, or I am not awesome.
P2: Lobsters exist.
C: I am awesome.
Check out my minecraft built of Tuesday Quest Dude! viewtopic.php?f=27&t=67
User avatar
playhavock
 
Posts: 151
Joined: Mon Feb 23, 2015 4:55 pm


Return to Guide and Tips

Who is online

Users browsing this forum: No registered users and 1 guest

cron

x