it also
lgbtq-plus
"Nine Lives ROMA" - Romulus · Quirinus
Tuesday, May 12, 2020
makes 0 sense
with the predetermined numbers
lol
Enkidu summoned by the world only has a 11500 powerlevel
therefore
this system is shit
why did you convince me to spend time figuring this out
this
is how it should work
okay dan
lets make a spreadsheet
that actually calculates servant powerlevels
you cannot quantify anyone with EX is the problem with giving parameters numbers
yeah
hence why we'll do two calcs
without EX
and EX is above A+++
also i kinda
itll also take me like
2 mins to do this
I can't belive jeralt is fucking dead
you know
it just hit me
a servant with D++ all around would be better than A's with this system
Yes.
thats
now
how does one
kinda weird
use formulas
can you make
"C+" a variable in spreadsheets
thats the true question
unsure
or I could do it manually
for 300 servants
i think the + would fuck it up
but i dont know
@Spooky Phijkchu
are you around
lord of spreadsheets
hes fucking dead
you want
C+
to return a numerical value?
okay bopit
are you good with spreadsheets
if statement
if(C+, #)
if you want to do it for all of them
you would chain the if statments
which could be a pain
if(C+, #, if(B-, #, etc))
that's the best way I know how to do it
does that answer your question or were you trying to do something else?
Sheet1!D2=IF(E, 10, IF(E+, 20
and keep chaining?
yes
okay.
then close with a lot
of )s?
or
it's a pain but I think that's the only way to do it
yes
close with
a LOT
of )
nice thing is
you should only have to do it once
then you can copy it down
yes
dan can you count
how many )s i need
actually
yeah that sounds righth
tbh if you entered it