A dice roller inside google sheets (Available and in testing)

A note about “sorting dice”:

If you include that option (which can be very handy!), make sure that it is optional.

Otherwise you won’t be able to use this for any game where dice are considered separately.

For example, a game like Swords Without Master, where you roll two dice and it matters whether the first one is the low die or the high die.

3 Likes

I published some changes, one is breaking if you are testing please read on!

  1. Breaking: Changed the way Yonder saves your stats. If you have a problem where any roller shows blank, or won’t go past the Update Stats grey screen please:

Go to Extensions > Yonder > Clear saved character data then close the sidebar and open it again

You will need to update your stats again, and setup a character name. Sorry

You won’t see any meaningful difference in functionality but It will allow me to develop a Game Master Panel at some point as suggested by @Anders and @RichRogers

  1. Sorting dice for improvised rolls. When you roll an improvised roll there will be a clickable text that sorts the dice. This solves @Anders suggestion, but keeps it optional as per @Paul_T comment

image

image

Dice are still grouped by faces, tho, so from left to right are the d12s sorted and then the d100s. Let me know what you thing of this

image

  1. Added Extra Bonuses to the FitD roller, they add more dice to be rolled as shown in the following screenshot

  1. I added a small animation to the Improvised Roll button to make it more appealing[?] and clearer that you can click on it

salida

Bugfixes

  • Yonder was saving the same stats for all the documents you were using it, now it saves stats per document. This is related to the first change listed above

  • There was a bug where after you added an extra bonus you wouldn’t be able to delete it

5 Likes

Awesome!

I’m usually not fond of animations since they tend to distract me, but this one is unobtrusive enough that I don’t think that’s an issue. And I do think it makes it more clear that the R is something you can click.

2 Likes

I’m now working in support for Troika and d20 like games as well as a Game Master Template Configuration

Troika

Will support both roll under and roll versus rolls. And will inform you if something is a Fumble or a Mighty Blow in the case of versus rolls.

Skill will be supported as an Extra Bonus, like in the PbtA and FitD rollers. This is to maximize compatibility between rollers.

Getting ahead of myself both Clickable Skills and Extra Bonuses will be configurable as Templates, this means that if there’s a Template that someone prepared ahead the player will only have to fill in their values.



d20-like games (check style)

Most of the things required for d20 have already been implemented as part of one of the other rollers in one way or another. I’ll playtest using Mörk Borg. This means that when you click on an ability/stat you will get a d20+stat as a result; I call this “check style”

The roller will not calculate modifiers, since different games calculate them in different ways, so the number you configure in the roller is the modifier, not the score.

During development I’ll consider if I add support for some kind of roll under in a separate roller, which would extend support for other kind of d20 OSR games, like OSE. the troika roller will probably put me a bit ahead to implement this but I’ll have to see

Game Master Template Configuration

This is the big one. I’ll add a screen that allows someone to configure a quick template within the roller, in the fashion that @Anders and @RichRogers had suggested previously.

This will be very simple, as the roller is, you’ll get to list Clickable Skills, the ones that appear on top of the roller, and a list of Extra Bonuses. Once configured when a player opens a roller those lists will be already filled and they will only have to provide their values.


All of these changes should be implemented in the next two weeks or so


I am doing this project for fun, and because these are the games I regularly run but I really think that it’s usable for most people, so if you haven’t tried it, try it! At the very least it will be one less tab open :stuck_out_tongue:

You can get Yonder: Dice Roller for sheets, here

-A

5 Likes

Sounds great! I’m glad you’re putting in the time and effort to do this.

2 Likes

Version 1.2.1: Now with Troika & D20 Support

This version introduces new games, and the now called “Game setup screen”

Get Yonder here for free!

d20-like games

Support for d20-like games. I tested this mainly with Mörk Borg, but it should be compatible with games that use some kind of d20 + stat + modifier roll. Up to and including 5e, though more complex games would need more fiddling.

YonderMarketplace 03 d20

Troika! support

I’ve been running troika extensively with Yonder. I suggest setting up your Advanced Skill Rank as the stat, and your Skill as an extra bonus. But I’ve added support for Testing your Luck, which is reduced by one each time you roll. I really like how it’s been working for my game and I hope it works for you.

YonderMarketplace 04 Troika

More ways to setup your stats

Importing from the sheet is still supported, but now you can write your own stats, or edit them. This is particularly helpful if the stats you imported have really long names, for example. And it can help with weirder character keepers where all rollable stats are not next to each other.

YonderMarketplace 07 Stats

Game Template Setup

For the same reasons I also added a new screen to the menu item: Game Template Setup here you can write down names and default values for stats and bonuses, which makes it much easier for players to use; now when they first open yonder in the document, and haven’t setup their numbers before they will be asked if they’d like to use the template.

YonderMarketplace 08 Template

Other changes

  • Standarized rollers in the backend. This should make it easier to support new games and systems
  • PbtA games now display their rolled dice as dice instead of numbers
  • Better rolls logging to the sheet
  • Updated Marketplace listing with new screenshots

I hope you enjoy the new version of Yonder! Let me know if you’ve tried it please!

As a final note. If you’ve installed Yonder and don’t see it in your Extensions menu go to Extensions > Add-ons > Manage Add-ons > And enable Yonder in this document.

3 Likes

I’m probably doing something stupid, but I’ve just been trying out Yonder and get the following:
Capture

It looks like it’s treating a Stat with value 0 in a PbtA set up differently than the non-zero stats; multiplying the 2d6 by 100 rather than just adding the Stat.

… and I’ve just noticed it seems to be doing something odd with double 6, too

Thoughts?

3 Likes

I know exactly what’s going on, but I don’t know why it’s happening. The sidebar results, are the dice icons are showing properly?

The thing that’s happening is: see how 4+4=8 that’s a number, but the code is taking the 0 as text. So when adding numbers and text it will render as 80 I’m not sure where the other zero is coming from, but I know where the bug most likely is

(4+4) + Deep(0)

Thanks for your report! I’ll check it today

In the meantime could you send me some screenshots of the sidebar for the same rolls? Thanks!

UPDATE 1

So, what I think is happening @Alun_R is that you are getting your stats from the sheet, and that’s working as intended. But both your 0 in Deep and +1 for that particular roll of Canny are text. Meaning the value in the value for the +1 in the roller looks like this and it’s harder to recognize for the 0 but that zero is text not a number.

image

Probably those cells in the spreadsheet have these actual content '+1 so that it’s displayed as +1 and '0 for some reason

You can fix it by replacing the +1 with a single 1 in the roller text box, click and write it down. Same for the 0

However i think this might be a common problem. So I’ll also work on a patch that forces those texts extracted from the spreadsheet into numbers

UPDATE 2

I pushed the fix. What you can do is

  • go to Settings, (top right corner cog)
  • select sheet
  • grab your range and import stats from sheet
  • close Settings (top right corner cog)

Then the numbers that are imported should be numbers :+1:

3 Likes

You were right - I’d set up the keeper to allow ‘+3’ to appear by making it ‘text’. Now I’ve gone back to defining the stats as ‘number’ it’s working fine.
Thanks.

1 Like

For the record with the latest patch if you get the stats from the sheet it should strip out any text symbols and leave you with just a number :3

Glad it works for you!

Any chance this could get Warhammer Fantasy Roleplay integration? It looks amazing and I’d love to use it in my games.

I haven’t played any version of warhammer fantasy, so I’m not sure where to start. What edition would you like to have integrated? Maybe I can look into it

4E would be amazing, and would transfer pretty easily to 2E as well (and as a skill-based d100 roll under system, would be easy to port to Call of Cthulhu as well).

Your skill level is the target number, you need to roll under that number to succeed, and the number of tens under or over your skill level is your success level (i.e. skill level of 35, you roll an 18 = 2 SL; skill level 35 and you roll an 83 = -3 SL). Target numbers are modified by the GM based on difficulty from +60 (Very Easy) to -30 (Very Hard). I’ve played with quite a few people who use advantage die instead of target number modification for difficulty (less calculation).

Cthulhu is a similar system, roll under to succeed, Hard Success on =<1/2 of your skill level, Extreme Success on =<1/5 of your skill level.

1 Like

I think I’ll have some time to do a rough sketch this weekend. Could I hit you up with some screenshots? I don’t think functionality will come super soon, but I’m looking forward to new features after a couple of months

1 Like

I would absolutely love to help in any way that I can. I’m no coder, but I’ve managed to make a (barely) function dice roller in my homebrew WFRP character sheet, so hopefully that gives me some insight :skull: Thanks heaps for taking this on. No rush at all!