SHDb in Google Sheets
Created by cromofantasy, 2 mo 22 d ago.
Buenos días, he intentado a modo de hobby crear el calculador de stats en Google Sheets, ya que es algo que me divierte mucho hacer.
Una cosa que he notado es que la fórmula que aparece en los stats para calcular la clase del super (( INT^1.3 + (STR*2 )^0.5 + (SPE*2)^0.5 + DUR^1.6 + (POW + SPS)^2 + COM^1.8 ) ^ TIER) no da el resultado que dice en la web, por ejemplo, Superman da un resultado mucho más alto. ¿Esta es la verdadera fórmula?
PD: Lo hago como hobby por amor a la web, no intento robar datos, ni nada por el estilo, amo las estadistícas y excel, por ende intenté ver si podía imitarlo.
Saludos.
Translation by ChatGPT:
Good morning, I've been trying, as a hobby, to create a stats calculator in Google Sheets, as it's something I really enjoy doing. One thing I've noticed is that the formula appearing in the stats to calculate the superhero class (( INT^1.3 + (STR2 )^0.5 + (SPE2)^0.5 + DUR^1.6 + (POW + SPS)^2 + COM^1.8 ) ^ TIER) doesn't yield the result stated on the website; for instance, Superman's result is much higher. Is this the real formula?
P.S.: I'm doing this as a hobby out of love for the web; I'm not trying to steal data or anything like that. I love statistics and Excel, so I tried to see if I could replicate it.
Greetings.
Low (grey) = .3
Medium (blue) = .6
Max (Purple) = 1
The updated calculation should be:
(( INT^1.3 + (STR2 )^0.5 + (SPE2)^0.5 + DUR^1.6 + (POW + (SPS*LVL) )^2 + COM^1.8 ) ^ TIER)
The part in bold is updated.
Hope this helps.