#Trialpears' Sheets!

1 messages · Page 1 of 1 (latest)

static warren
#

Hello! I aim to create high quality sheets on a wide variety of topics. This thread is for news about and discussion to improve any of these sheets. I'm always open to feedback, questions or suggestions but I will only do things I feel like doing in my spare time. I'm steadily improving and my standards are getting higher. That means some older sheets might not quite be up to par with the newer ones.

background-254-0.png
#

List of Sheets in reverse chronological order:

#

Trialpears' BJP Sheet
https://docs.google.com/spreadsheets/d/1ft3UxxBTiYBiBRmmLCuSpCznTFJQGRMLvf30r_qHo2w/edit?gid=0#gid=0
Instead of the traditional HP math which doesn't account for crits, talents, attack speed and personal time preference I use a reference boss with an optimal amount of pickles to determine how many you should use for the others. In my experience this gives much better results. I use Dr Defecause as my reference since you can respawn him with fewer pickles by leaving and reentering. Start high and work your way down to a good amount.

Google Docs
Trialpears' BJP Sheet
#

Trialpears' Land Rank Optimizer Sheet
https://docs.google.com/spreadsheets/d/1_Z0-mJKRMxjFb0CSmg9MlfxDgdtwNyeVDd-7Bb1wXzs/edit?gid=0#gid=0
The goal of this sheet is to easily maximize the land rank allocation with the least effort possible. Only the values in the input section needs to be changed for full Land Rank recommendations to be generated. The Goal Ratios can be changed if you disagree with my recommendations and the sheet will do its best to adapt.

Google Docs
Trialpears' Land Rank Optimizer Sheet
#

.

#

.

#

.

#

.

#

.

#

.

#

.

#

.

#

.

#

.

#

.

#

.

#

.

#

.

#

.

#

.

#

.

#

.

#

.

#

.

#

.

#

.

#

.

#

.

versed fox
#

trialpears sheet guide list Grumblo_xplode

ive been waiting for ages for this to happen

edgy echo
#

I was just thinking, with the new forge cap multiple in the hole, it's pretty impractical to do 2 minute claims.. I was thinking, maybe you should add in another column or 2 for KPH for 1 hour and possibly 2 hr.

#

@static warren

#

like 12.7m forge cap so far.. It'll go up another 3x to 38m for me.

image.png
#

well I guess your calculator covers it kinda.. I have the old sheet lol

dry ingot
#

ilysm trialpears

static warren
edgy echo
# static warren Sorry for not replying to this weeks ago. Was contemplating how best to deal wit...

Depending on how bad some people's speed may be/ how bad their kph is, might need 2 hr candies in some limited cases. If they care about emptying forge of course.

Like there's my copper > marble with 1 hours.

I decided to finally make more gold bars for my crystal shrine that's been sitting at 195 for forever lol, and was wondering why my forge wasn't emptying. I totally forgot to check how much kph I needed to do that.

image.png
static warren
#

I suppose you are right, think I will do a drop down for which candy you want to use then. People can get the forge buffs quite early if they want to, especially if they take a prolonged break after reaching the hole

versed fox
#

Could you please put these Sheets in a folder, then share the folder under view only? It would allow for a one-click solution to finding the specific sheet you need

gloomy lake
#

od

mossy nexus
#

owl

static warren
#

I'm gonna try to make one sheet update a day again, haven't really done much recently. Today the stamp sheet received some bug fixes and got the prices right for the stamps changed a few updates ago

static warren
#

I think this is what you wanted? Haven't used this feature before

versed fox
#

Woohoo. Thanks mate!

sage canopy
#

bump for good sheets Grumblo_Pray

civic forum
# static warren **Trialpears' Land Rank Optimizer Sheet** https://docs.google.com/spreadsheets/d...

Would anyone be willing to provide more detailed instructions on using this sheet? I am confused on how to use

edit: I think I made this more complicated as I thought I was supposed to update all of columns A:G. For anyone else slow on the uptake....

  1. Made a copy of the sheet so you can edit it:
  2. Update Cells D3:D7 with your information
  3. The remaining magenta cells should update on their own.
  4. For me, I found easiest to use the table in B10:F22 to decide where to put my land rank points
tiny river
#

Why would the sheet not use all the points? I have 3510 points, but it only tells me to use 3339.

image.png
hollow bear
#

Mine also seems weird, using more points than I have? Unless I'm misunderstanding something?

27A02F42-4B61-4D87-A7A7-3AC028EA7164.png
tiny river
#

It's broken. Trialpears doesn't intend to fix it.

hollow bear
violet condor
#

got stuck at 190 crop

potent delta
#

farm

grand crypt
#

@static warren do you happen to have a sheet with the exp requirements per level of villagers in the hole?

static warren
tiny river
#

@static warren If you are still updating stamp sheet, Gigafrog companion is missing.

sleek ocean
#

Trial has quit

fleet bobcat
#

Rip

plain hornet
tiny river
plain hornet
tiny river
#

And I'm just saying I haven't messaged him in 2 months.