So I've got a couple of rollable tables at the moment (cits, magic loot, useless loot, coins, descriptions, ...ect.) and I've still got a bunch of ideas for other rollable tables that would be handy for me as a DM. I don't want to have to ruffle through papers all the time and have to re-print them when I make adjustments so I'm looking for an easy app where I can store all these rollable tables in. Anyone have any ideas?
In an ideal world I'd just have to click on the table to roll a value. Maybe even a way to input drop ratio for some entries?
Depending on how good you spreadsheet-fu is, Google sheets?
You can set up an random number generator in one cell, which would give you a decimal number between 0 and 1. Then for each table multiply it by the highest number on the table ( rounded up ), and do a VLOOKUP or INDEX of that value against the table, and give you the resulting entry. You can even specify ranges ( look up the highest entry which has that number or less ) that way.
It might end up rolling on all the tables every time you refresh the sheet - but I think that's livable. You could have one tab which just shows the results, and would probably display on a mobile device well enough, and other tab(s) where you build the lookup tables themselves.
Disclaimer: This signature is a badge of membership in the Forum Loudmouth Club. We are all friends. We are not attacking each other. We are engaging in spirited, friendly debate with one another. We may get snarky, but these are not attacks. Thank you for not reporting us.
Put your table in one sheet with numbers in the first column and "results" in the second.
Then on another sheet create a "dice" by using this formula: =RANDBETWEEN(1;COUNT(column with numbers)) This formula creates a whole number between 1 and the total number of cells in the column with numbers. So if that column has 30 numbers, it will generate a number between 1 and 30.
Then use VLOOKUP to look for the result in your table.
I would have added a new sheet for every table, but created one "top-sheet" where you gather all your results. Know that google sheets can get a little slow if you have too many sheets.
Disclaimer: This signature is a badge of membership in the Forum Loudmouth Club. We are all friends. We are not attacking each other. We are engaging in spirited, friendly debate with one another. We may get snarky, but these are not attacks. Thank you for not reporting us.
I was sceptical when I read your replies, but I've created a spreadsheet with both your tips in mind and I'm actually really happy with it!
Is there a way to implement a button that creates a new random number without having to refresh the entire page?
Happy to help :-) As for the refresh "issue": I usually only type a random character into an empty cell and hit enter. That recalculates the entire sheet and give you new results. If you use excel you can create a button, but I usually don't care about that.
Just discovered that you in google sheets can add a checkbox to a cell. If you do that, the sheet will recalculate every time you mark/unmark it. I've added one to the simple sheet in my first post. Works fine.
However, if what you want is to only refresh parts of the document (like keep one roll, while re-rolling another one). That is quite a hassle to make work. It's probably doable (at least in Excel), but that would be time consuming...
Made a sheet with a couple of random tables and a first sheet which collects all random rolls. The sheet refreshes every minute. Might try and add refresh button with macros. But I'm already really happy with this! Thanks for the tips! Cheers!
So I've got a couple of rollable tables at the moment (cits, magic loot, useless loot, coins, descriptions, ...ect.) and I've still got a bunch of ideas for other rollable tables that would be handy for me as a DM. I don't want to have to ruffle through papers all the time and have to re-print them when I make adjustments so I'm looking for an easy app where I can store all these rollable tables in. Anyone have any ideas?
In an ideal world I'd just have to click on the table to roll a value. Maybe even a way to input drop ratio for some entries?
Depending on how good you spreadsheet-fu is, Google sheets?
You can set up an random number generator in one cell, which would give you a decimal number between 0 and 1. Then for each table multiply it by the highest number on the table ( rounded up ), and do a VLOOKUP or INDEX of that value against the table, and give you the resulting entry. You can even specify ranges ( look up the highest entry which has that number or less ) that way.
It might end up rolling on all the tables every time you refresh the sheet - but I think that's livable. You could have one tab which just shows the results, and would probably display on a mobile device well enough, and other tab(s) where you build the lookup tables themselves.
My DM Philosophy, as summed up by other people: https://drive.google.com/file/d/1rN5w4-azTq3Kbn0Yvk9nfqQhwQ1R5by1/view
Disclaimer: This signature is a badge of membership in the Forum Loudmouth Club. We are all friends. We are not attacking each other. We are engaging in spirited, friendly debate with one another. We may get snarky, but these are not attacks. Thank you for not reporting us.
Spreadsheets/Excel was my first thought as well.
Put your table in one sheet with numbers in the first column and "results" in the second.
Then on another sheet create a "dice" by using this formula: =RANDBETWEEN(1;COUNT(column with numbers)) This formula creates a whole number between 1 and the total number of cells in the column with numbers. So if that column has 30 numbers, it will generate a number between 1 and 30.
Then use VLOOKUP to look for the result in your table.
I would have added a new sheet for every table, but created one "top-sheet" where you gather all your results. Know that google sheets can get a little slow if you have too many sheets.
Check out this very simple sheet I made: https://docs.google.com/spreadsheets/d/1ef0AwrCHHkf0ZHuyWAtvqGCYx6EXjZKQY5GtEmsV3fo/edit?usp=sharing
Ludo ergo sum!
I was sceptical when I read your replies, but I've created a spreadsheet with both your tips in mind and I'm actually really happy with it!
Is there a way to implement a button that creates a new random number without having to refresh the entire page?
Oh - it will work - I've done entire RPG random Character/NPC generators using that technique :)
As for the button: Yes, but it involves doing some scripting.
Here's a quick tutorial on creating custom buttons in Google Sheets: http://googleappscripting.com/google-spreadsheet-button/
It's merely the first one I found doing a Goggle search - there are probably others/better-for-your-purpose if you do some searching around.
My DM Philosophy, as summed up by other people: https://drive.google.com/file/d/1rN5w4-azTq3Kbn0Yvk9nfqQhwQ1R5by1/view
Disclaimer: This signature is a badge of membership in the Forum Loudmouth Club. We are all friends. We are not attacking each other. We are engaging in spirited, friendly debate with one another. We may get snarky, but these are not attacks. Thank you for not reporting us.
Happy to help :-) As for the refresh "issue": I usually only type a random character into an empty cell and hit enter. That recalculates the entire sheet and give you new results. If you use excel you can create a button, but I usually don't care about that.
Ludo ergo sum!
Just discovered that you in google sheets can add a checkbox to a cell. If you do that, the sheet will recalculate every time you mark/unmark it. I've added one to the simple sheet in my first post. Works fine.
However, if what you want is to only refresh parts of the document (like keep one roll, while re-rolling another one). That is quite a hassle to make work. It's probably doable (at least in Excel), but that would be time consuming...
Ludo ergo sum!
Thanks Vedexent & GodrickGreat
Made a sheet with a couple of random tables and a first sheet which collects all random rolls. The sheet refreshes every minute. Might try and add refresh button with macros. But I'm already really happy with this! Thanks for the tips! Cheers!
Link: DnD Random Tables
That looks really neet :-)
Ludo ergo sum!