Support the GITP forums on Patreon
Help support GITP's forums (and ongoing server maintenance) via Patreon
Results 1 to 16 of 16
  1. - Top - End - #1
    Barbarian in the Playground
     
    SwashbucklerGuy

    Join Date
    Aug 2008

    Default 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?

  2. - Top - End - #2
    Titan in the Playground
     
    ElfRangerGuy

    Join Date
    Aug 2007
    Location
    Imagination Land
    Gender
    Male

    Default Re: Spreadsheet nightmare

    I'm sure someone in the Mad Science and Grumpy Technology subforum will be able to help you.
    "Nothing you can't spell will ever work." - Will Rogers

    Watch me draw and swear at video games.

  3. - Top - End - #3
    Titan in the Playground
     
    Kelb_Panthera's Avatar

    Join Date
    Oct 2009

    Default 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
    Spoiler
    Show
    Quote Originally Posted by ThiagoMartell View Post
    Kelb, recently it looks like you're the Avatar of Reason in these forums, man.
    Quote Originally Posted by LTwerewolf View Post
    [...] bringing Kelb in on your side in a rules fight is like bringing Mike Tyson in on your side to fight a toddler. You can, but it's such massive overkill.
    A quick outline on building a homebrew campaign

    Avatar by Tiffanie Lirle

  4. - Top - End - #4
    Titan in the Playground
     
    nedz's Avatar

    Join Date
    Apr 2010
    Location
    London, EU
    Gender
    Male

    Default 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

  5. - Top - End - #5
    Ogre in the Playground
     
    OrcBarbarianGuy

    Join Date
    May 2018
    Location
    Colorado
    Gender
    Male

    Default Re: Spreadsheet nightmare

    I normally like playing around with Any Dice for dice distributions, it works pretty well.

  6. - Top - End - #6
    Titan in the Playground
     
    AvatarVecna's Avatar

    Join Date
    Jan 2014

    Default Re: Spreadsheet nightmare

    Quote Originally Posted by Kelb_Panthera View Post
    Anybody else see that title and think this was going to be someone either asking advice for or complaining about playing an artificer?
    *raises hand*


    Currently Recruiting WW/Mafia: Percy Jackson Mafia

    Avatar by AsteriskAmp

  7. - Top - End - #7
    Titan in the Playground
     
    Nifft's Avatar

    Join Date
    Feb 2006
    Location
    NYC
    Gender
    Male

    Default Re: Spreadsheet nightmare

    Quote Originally Posted by Aleolus View Post
    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?
    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.

  8. - Top - End - #8
    Ogre in the Playground
     
    MonkGuy

    Join Date
    Mar 2016

    Default Re: Spreadsheet nightmare

    Quote Originally Posted by Aleolus View Post
    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?
    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..)
    Orochimaru, the ultimate villain
    El Mariachi dual double-hand-crossbow action
    Papa Smurf a Redcap Lion of Talisid (ubercharger/gish)
    Hellfire Escalation Glaivelock a Killer Kobold build
    Hammerdin of Moradin a guide to epic hammer throwing
    Almighty Claw of Malar monk/warlock gish (with minor DBZ-SSJ fluff)
    TO: BoBaFeat Body outside Body & Void Disciple 4 to break the game.

  9. - Top - End - #9
    Colossus in the Playground
     
    Eldan's Avatar

    Join Date
    Jan 2007
    Location
    Switzerland
    Gender
    Male

    Default 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.
    "In dark times, should the stars also go out?"

  10. - Top - End - #10
    Barbarian in the Playground
     
    SwashbucklerGuy

    Join Date
    Aug 2008

    Default 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

  11. - Top - End - #11
    Troll in the Playground
     
    Lord Torath's Avatar

    Join Date
    Aug 2011
    Location
    Sharangar's Revenge
    Gender
    Male

    Default 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

  12. - Top - End - #12
    Barbarian in the Playground
     
    SwashbucklerGuy

    Join Date
    Aug 2008

    Default Re: Spreadsheet nightmare

    Basically, though I did consider weighting it in favor of certain gods. I have decided against that though, as it is difficult to decide which gods would be more/less likely to sire offspring

  13. - Top - End - #13
    Dwarf in the Playground
    Join Date
    Jun 2020

    Default Re: Spreadsheet nightmare

    Using a spreadsheet seems like overkill for this purpose. If your goal is simply to have an equal chance of each deity, you can just google "random number generator", type in the number of gods, and hit "generate". If it's important to you to roll physical dice, just assign 1-4 to the first god, 5-8 to the second, 9-12 to the third, and so on, then roll d100. You'll have a few extra numbers at the end that don't go with a god, so just reroll if you get one of those.

  14. - Top - End - #14
    Colossus in the Playground
     
    Eldan's Avatar

    Join Date
    Jan 2007
    Location
    Switzerland
    Gender
    Male

    Default 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)
    where X=number of gods.
    "In dark times, should the stars also go out?"

  15. - Top - End - #15
    Barbarian in the Playground
     
    PaladinGuy

    Join Date
    Sep 2016

    Default Re: Spreadsheet nightmare

    Quote Originally Posted by Aleolus View Post
    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
    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.

  16. - Top - End - #16
    Dwarf in the Playground
     
    Kobold

    Join Date
    Apr 2020
    Location
    United States
    Gender
    Male

    Default Re: Spreadsheet nightmare

    Spreadsheet nightmare..... Sounds like my job.
    "Sure, Philosophers can say 'But how do we know the sun will rise tomorrow?' to which the correct response is 'Shut up nerd! Stop playing 3D chess against your own brain and find something real to worry about'."

    -ContraPoints

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •