Editing Talk:Quality/Exact formula and numbers?/reply (4)

Alright, I wrote a Python script to do the math, and the result is the attached table.

One problem is that my numbers don't seem to exactly match the ones already on the wiki, and a randomly generated sample of 10,000 also seems to be slightly different... although I can't say if I'm doing that wrong, or this wrong.

Opinions on the colors, content, and accuracy? If you want to see the script, I'll find a way to share it.

{| {{STDT| sortable center}} style = 'width: auto'
|-
! data-sort-type='number' | Skill level
! Awful
! Shoddy
! Poor
! Normal
! Good
! Superior
! Excellent
! Masterwork
! Legendary
! Avg. Value
|-
!1 Incompetent
| style='background:#8F7' | 65.96% || style='background:#CF8' | 23.18% || style='background:#FC7' | 8.87% || style='background:#F86' | 1.79% || style='background:#D66' | 0.19% || style='background:#D66' | 0.01% || style='background:#D66' | - || style='background:#D66' | - || style='background:#D66' | - || x0.49
|-
!2 Basic Awareness
| style='background:#8F7' | 55.46% || style='background:#CF8' | 27.68% || style='background:#FC7' | 13.12% || style='background:#F86' | 3.28% || style='background:#D66' | 0.43% || style='background:#D66' | 0.03% || style='background:#D66' | - || style='background:#D66' | - || style='background:#D66' | - || x0.53
|-
!3 Basic Familiarity
| style='background:#8F7' | 44.57% || style='background:#CF8' | 30.80% || style='background:#CF8' | 18.06% || style='background:#FC7' | 5.58% || style='background:#D66' | 0.91% || style='background:#D66' | 0.08% || style='background:#D66' | - || style='background:#D66' | - || style='background:#D66' | - || x0.58
|-
!4 Amateur
| style='background:#8F7' | 34.04% || style='background:#CF8' | 31.92% || style='background:#CF8' | 23.18% || style='background:#FC7' | 8.87% || style='background:#F86' | 1.79% || style='background:#D66' | 0.19% || style='background:#D66' | 0.01% || style='background:#D66' | - || style='background:#D66' | - || x0.63
|-
!5 Strong Amateur
| style='background:#CF8' | 24.66% || style='background:#8F7' | 30.80% || style='background:#CF8' | 27.68% || style='background:#FC7' | 13.12% || style='background:#F86' | 3.28% || style='background:#D66' | 0.43% || style='background:#D66' | 0.03% || style='background:#D66' | - || style='background:#D66' | - || x0.68
|-
!6 Practitioner
| style='background:#CF8' | 16.88% || style='background:#CF8' | 27.69% || style='background:#8F7' | 30.80% || style='background:#CF8' | 18.06% || style='background:#FC7' | 5.58% || style='background:#D66' | 0.91% || style='background:#D66' | 0.08% || style='background:#D66' | - || style='background:#D66' | - || x0.74
|-
!7 Skilled Practitioner
| style='background:#FC7' | 10.87% || style='background:#CF8' | 23.18% || style='background:#8F7' | 31.92% || style='background:#CF8' | 23.18% || style='background:#FC7' | 8.87% || style='background:#F86' | 1.79% || style='background:#D66' | 0.19% || style='background:#D66' | 0.01% || style='background:#D66' | - || x0.81
|-
!8 Professional
| style='background:#FC7' | 6.59% || style='background:#CF8' | 18.07% || style='background:#8F7' | 30.80% || style='background:#CF8' | 27.68% || style='background:#FC7' | 13.12% || style='background:#F86' | 3.28% || style='background:#D66' | 0.43% || style='background:#D66' | 0.03% || style='background:#D66' | - || x0.87
|-
!9 Skilled Professional
| style='background:#F86' | 3.75% || style='background:#FC7' | 13.13% || style='background:#CF8' | 27.69% || style='background:#8F7' | 30.80% || style='background:#CF8' | 18.06% || style='background:#FC7' | 5.58% || style='background:#D66' | 0.91% || style='background:#D66' | 0.08% || style='background:#D66' | - || x0.94
|-
!10 Expert
| style='background:#F86' | 1.99% || style='background:#FC7' | 8.87% || style='background:#CF8' | 23.18% || style='background:#8F7' | 31.92% || style='background:#CF8' | 23.18% || style='background:#FC7' | 8.87% || style='background:#F86' | 1.79% || style='background:#D66' | 0.19% || style='background:#D66' | 0.01% || x1.02
|-
!11 Strong Expert
| style='background:#F86' | 1.19% || style='background:#FC7' | 6.32% || style='background:#CF8' | 19.36% || style='background:#8F7' | 31.28% || style='background:#CF8' | 26.66% || style='background:#FC7' | 11.98% || style='background:#F86' | 2.84% || style='background:#D66' | 0.35% || style='background:#D66' | 0.02% || x1.08
|-
!12 Very Strong Expert
| style='background:#D66' | 0.68% || style='background:#F86' | 4.32% || style='background:#CF8' | 15.53% || style='background:#8F7' | 29.46% || style='background:#8F7' | 29.46% || style='background:#CF8' | 15.53% || style='background:#F86' | 4.32% || style='background:#D66' | 0.63% || style='background:#D66' | 0.05% || x1.14
|-
!13 Master
| style='background:#D66' | 0.38% || style='background:#F86' | 2.84% || style='background:#FC7' | 11.98% || style='background:#CF8' | 26.66% || style='background:#8F7' | 31.28% || style='background:#CF8' | 19.36% || style='background:#FC7' | 6.32% || style='background:#F86' | 1.09% || style='background:#D66' | 0.10% || x1.21
|-
!14 Strong Master
| style='background:#D66' | 0.20% || style='background:#F86' | 1.79% || style='background:#FC7' | 8.87% || style='background:#CF8' | 23.18% || style='background:#8F7' | 31.92% || style='background:#CF8' | 23.18% || style='background:#FC7' | 8.87% || style='background:#F86' | 1.79% || style='background:#D66' | 0.20% || x1.29
|-
!15 Planet-Class Master
| style='background:#D66' | 0.12% || style='background:#F86' | 1.20% || style='background:#FC7' | 6.78% || style='background:#CF8' | 20.13% || style='background:#8F7' | 31.51% || style='background:#CF8' | 26.00% || style='background:#FC7' | 11.32% || style='background:#F86' | 2.60% || style='background:#D66' | 0.33% || x1.36
|-
!16 System-Class Master
| style='background:#D66' | 0.07% || style='background:#D66' | 0.79% || style='background:#FC7' | 5.05% || style='background:#CF8' | 17.05% || style='background:#8F7' | 30.32% || style='background:#CF8' | 28.44% || style='background:#FC7' | 14.07% || style='background:#F86' | 3.67% || style='background:#D66' | 0.54% || x1.43
|-
!17 Revered Master
| style='background:#D66' | 0.04% || style='background:#D66' | 0.50% || style='background:#F86' | 3.67% || style='background:#FC7' | 14.07% || style='background:#CF8' | 28.44% || style='background:#8F7' | 30.32% || style='background:#CF8' | 17.05% || style='background:#FC7' | 5.05% || style='background:#D66' | 0.86% || x1.51
|-
!18 Visionary
| style='background:#D66' | 0.02% || style='background:#D66' | 0.31% || style='background:#F86' | 2.60% || style='background:#FC7' | 11.32% || style='background:#CF8' | 26.00% || style='background:#8F7' | 31.51% || style='background:#CF8' | 20.13% || style='background:#FC7' | 6.78% || style='background:#F86' | 1.32% || x1.61
|-
!19 Legendary
| style='background:#D66' | 0.01% || style='background:#D66' | 0.19% || style='background:#F86' | 1.79% || style='background:#FC7' | 8.87% || style='background:#CF8' | 23.18% || style='background:#8F7' | 31.92% || style='background:#CF8' | 23.18% || style='background:#FC7' | 8.87% || style='background:#F86' | 1.99% || x1.71
|-
!20 Godlike
| style='background:#D66' | - || style='background:#D66' | 0.11% || style='background:#F86' | 1.20% || style='background:#FC7' | 6.78% || style='background:#CF8' | 20.13% || style='background:#8F7' | 31.51% || style='background:#CF8' | 26.00% || style='background:#FC7' | 11.32% || style='background:#F86' | 2.93% || x1.83
|}

'''EDIT:''' I realized my PDF function was centered around the number I gave it, not beginning at it. I updated the table with figures that seem to almost exactly agree with WA, and I think that this is right.

Future work to be done is checking if, and when, it's optimal to recraft until a given quality is achieved in order to get more buck per material.

Anyway, these figures are depressing: It's almost impossible to make a profit with buy->craft->sell on higher difficulties, unless you've got max crafting skill, high social skill, craft high value/material items, '''and''' use materials bought at low or very low price... crazy.
Latest revision		Your text
Line 85:		Line 85:

	Anyway, these figures are depressing: It's almost impossible to make a profit with buy->craft->sell on higher difficulties, unless you've got max crafting skill, high social skill, craft high value/material items, '''and''' use materials bought at low or very low price... crazy.		Anyway, these figures are depressing: It's almost impossible to make a profit with buy->craft->sell on higher difficulties, unless you've got max crafting skill, high social skill, craft high value/material items, '''and''' use materials bought at low or very low price... crazy.
−
−	~~```EDIT2```: Apparently, it's optimal to recraft until the most probable quality, and it gets a minor benefit of x0.02-x0.08. I pushed the table to the wiki page.~~