Results 1 to 15 of 15
Thread: Spreadsheet nightmare
-
2021-03-12, 12:18 PM (ISO 8601)
- Join Date
- Aug 2008
Spreadsheet nightmare
OK, this is probably not the board to post this in, but it is related (at least tangentially), and I don't know where to look for this, so here we go. I am trying to come up with ranges for percentile rolls in a chart I wrote out in LibreOffice Calc. All I want is to have the program determine the most even distribution for it, but I can't figure out how to get it to do that. Does anyone on here know the program well enough to be able to help?
-
2021-03-12, 03:16 PM (ISO 8601)
- Join Date
- Aug 2007
- Location
- Imagination Land
- Gender
Re: Spreadsheet nightmare
I'm sure someone in the Mad Science and Grumpy Technology subforum will be able to help you.
-
2021-03-13, 06:18 PM (ISO 8601)
- Join Date
- Oct 2009
Re: Spreadsheet nightmare
Anybody else see that title and think this was going to be someone either asking advice for or complaining about playing an artificer?
I am not seaweed. That's a B.
Praise I've received A quick outline on building a homebrew campaign
Avatar by Tiffanie Lirle
-
2021-03-14, 08:09 PM (ISO 8601)
- Join Date
- Apr 2010
- Location
- London, EU
- Gender
Re: Spreadsheet nightmare
In Excel I would use VB (via a macro) but I don't know if Libra supports this.
π = 4
Consider a 5' radius blast: this affects 4 squares which have a circumference of 40' — Actually it's worse than that.
Completely Dysfunctional Handbook
Warped Druid Handbook
Avatar by Caravaggio
-
2021-03-14, 08:44 PM (ISO 8601)
- Join Date
- May 2018
- Location
- Colorado
- Gender
Re: Spreadsheet nightmare
I normally like playing around with Any Dice for dice distributions, it works pretty well.
-
2021-03-14, 11:30 PM (ISO 8601)
- Join Date
- Jan 2014
Currently Recruiting WW/Mafia: Logic's Deathloop Mafia and Cazero's Graduates Of Hope's Peak - Danganronpa Mafia
Avatar by AsteriskAmp
My Homebrew
-
2021-03-15, 12:23 AM (ISO 8601)
- Join Date
- Feb 2006
- Location
- NYC
- Gender
Re: Spreadsheet nightmare
If it's a matter of formatting I could probably help, but what do you mean by "determine the most even distribution for it"?
Do you want the program to take non-percentile fractions and turn them into a percent table? A spreadsheet might not be the best tool for that, but if it's simple enough you may be able to work it out anyway with an extra step or two.
Post some sample data and the sort of thing you want to get as a result.I want you to PEACH me as hard as you can.
-
2021-03-16, 03:00 PM (ISO 8601)
- Join Date
- Mar 2016
Re: Spreadsheet nightmare
I don't get the need for a programmed calculation? Are you intending to alter the length of the table or why you need to "program" it?
I mean, i would just calculate it (with a calculator if needed) and fill in the results into the table/sheet.
1) 100 / amount of possible outcomes rounded down
2) assign the remaining rest either as:
a) "re-roll"
b) to one of the possible outcomes
c) create a tiny possibility for something special (e.g. roll twice, death or whatsoever..)Extended Signature with Links to all my build showcases in the forum
My latest build showcases:
Gaive'Ur, the last Eldritch Knight of Bane (✝)
PACMAN, the Southern Beholder Mage (accelerated spell progression + double 9s)
Optimus Urbana Hierophantus - a Mobile Suit Gundam / Mech / Transformers build
Orko, He-man & Battlecat (a Dragonfire Mount's Ubermount and its Ubermount)
Giant Dwarf, the Rock Superstar (a War Chanter build)
-
2021-03-17, 04:19 AM (ISO 8601)
- Join Date
- Jan 2007
- Location
- Switzerland
- Gender
Re: Spreadsheet nightmare
Can you give a more detailed description of what you're trying to do? I'm not entirely clear what you want distributed.
Resident Vancian Apologist
-
2021-03-19, 11:01 AM (ISO 8601)
- Join Date
- Aug 2008
Re: Spreadsheet nightmare
I am prepping to run a D&D 3.5 campaign in which all of the PCs are children of a god and a mortal, but none of the characters know it. I am going to have each of the players roll a die to determine which god is their parent, and I have 21 possibilities. This is important because they are going to be getting benefits from their divine parent as they go up in level, along the same lines as the Bloodlines from Unearthed Arcana. At the moment I just dropped one of the gods I was using (making it an even 20, flat 5% for each), but I wouldn't mind adding that one and possibly one or two more back in. So what I was trying to do was to simply input the range (1-100), and draw it out over the number of possible outcomes, and have the program divide up the range into that many possibilities
-
2021-03-19, 11:55 AM (ISO 8601)
- Join Date
- Aug 2011
- Location
- Sharangar's Revenge
- Gender
Re: Spreadsheet nightmare
Is there intended to be an even chance of having each deity for a parent? In that case, it's just a simple 100 divided by the number of gods.
21 is the product of 3 and 7, neither of which go evenly into 100, so you're going to have a slightly uneven distribution if you are only going to roll 1d100.
If you want an even distribution, you're going to want a number of gods that will divide 100 with no remainders: 2,4,5,10,20,25 and 50.
If you can get 33 gods, you can evenly divide it into 3% chances, with any results of 100 resulting in a reroll until you get a result in the range of 1-99.
You could do a similar thing with any number of gods, and reroll the 'extra' numbers.
If you have 23 gods, for example, each god gets a 4% chance, and there's a 8% chance of a reroll.
Is that what you are looking for?
Use =randbetween(1,<number of gods>), as Eldan recommends below.Last edited by Lord Torath; 2021-03-20 at 10:30 AM. Reason: I suffered a bout of stupidity, getting too hung up on the d100
Warhammer 40,000 Campaign Skirmish Game: Warpstrike
My Spelljammer stuff (including an orbit tracker), 2E AD&D spreadsheet, and Vault of the Drow maps are available in my Dropbox. Feel free to use or not use it as you see fit!
Thri-Kreen Ranger/Psionicist by me, based off of Rich's A Monster for Every Season
-
2021-03-19, 12:03 PM (ISO 8601)
- Join Date
- Aug 2008
-
2021-03-19, 02:09 PM (ISO 8601)
- Join Date
- Jan 2007
- Location
- Switzerland
- Gender
Re: Spreadsheet nightmare
Don't roll a d100? Go to random.org or the wizards dice roller and roll 1dx where X is number of gods.
Alternatily in Excel, use the command
Code:=randbetween(1,X)
Resident Vancian Apologist
-
2021-03-23, 06:17 PM (ISO 8601)
- Join Date
- Sep 2016
Re: Spreadsheet nightmare
As given, if you are using the spreadsheet to make the choices, get it to use the "right sized die"
Or write it once.
If however you want to produce a dynamic lookup table, you could use something like the following
ID Gods Start Stop 1 name 1 0 =int(A2/max(100*A$2:A$102)) A2+1 name 2 =D2+1 =int(100*A2/max(A$2:A$102))
(and then should be able to click and drag up to 100, note that this version uses all the numbers and is uneven weighting)
A2*int(100/max....) will make each bin the same size with a re-roll space at the end
It doesn't have any column dependency so it would be quite easy to Copy/Paste to do a collection of tables, and might even break even over just doing it by hand.
Instead of max, you could use counta which would (arguably) be a lot more sensible.
The advantage of max, is that you can skip ID's to have an outcome weighted more than the rest (I'd then have a column for the weighting and then a calculated column for the cumulative weighting).Last edited by jayem; 2021-03-23 at 06:20 PM.
-
2021-03-27, 10:44 AM (ISO 8601)
- Join Date
- Apr 2020
- Location
- United States
- Gender
Re: Spreadsheet nightmare
Spreadsheet nightmare..... Sounds like my job.