oh wait, that’s genius…
by the way, i’d much appreciate it if someone edited in the values for the following vehicles
BD:
ED:
PD:
PD:
1 Like
I’m wondering how you calculated the efficiency stat, because I feel like you could potentially use some parameters like the sum, difference, product, and quotient parameters to streamline the process of calculating some of these
1 Like
it’s really just (attack + defense) / 100
1 Like
alright, because I think I might have a method that can automatically calculate all of this at the cost of not having the bracketed values due to the way the automatic calculation handles values inside a cell
1 Like
like this
here’s the little thing you can put in (adjust the cells as necessary, you can click on the calculated result and drag the blue circle down so it applies to everything else):
=DIVIDE(A1+B1,100)
1 Like
and if not having the values with event spoilers is a dealbreaker to you, then I’d recommend splitting it into a separate column so I can make it calculate two separate values for event spoilers and none
I’ve recently started using Google sheets for personal accounting, so I figured I’d help you out here
1 Like
I’ll probably get to filling in some of the missing values tomorrow, just wanted to let you know about these functions because they can save you so much time
(I apologize for making four replies in a row)
1 Like
alright thanks for lmk
1 Like
just added an exclusivity field in case people are f2p or don’t have the vehicles shown
1 Like
I’ve filled in everything except the couch car, you can go ahead and reorganize some of it
1 Like
will do later
1 Like