Google Spreadsheet to tryout gang loadouts

[dabbk]

After assembling a list kind of randomly according to miniatures I had at hand, I started thinking a bit more about proper lists. I ended up being bored to do the math by hand each time, and started using the neat google spreadsheet that had been created for Shadow War Armageddon for list building some time ago.

Find the link to a v1.0 here: https://docs.google.com/spreadsheets/d/1Gn6kJHGARF1ANRowxD2VxGki3aCCK6L3j6pv2KfQIgg/edit?usp=sharing

Note: so far, this is only to compute gang value. It shouldn't be too hard to add proper roster stuff. I don't need it for now, and I also am waiting on yaktools to do this properly. Until then, copy to your own google drive, edit and enjoy!

 

[Malo]

What do you mean "do it properly"?

 

[dabbk]

Well, provide all the tools to properly handle gangs, gangers and campaigns. My file is just a helper to do the math when calculating the total gang value. It even works just for starting gangs, as experience added value is not handled at all.

I haven't checked the latest status of yaktools for N17 (are they up yet?), but I think in the end they will do much more than just basic accounting like my file

 

[dabbk]

Also: duh. just realised that the tools were up, congrats! I just imported a gang, and the interface + roster generation look awesome!

Couple of things:
- I hate naming my stuff. People will hate me, but I'm pretty sure it could be done to implement this: https://www.warhammer-community.com/2018/01/28/naming-necromunda-gang/ Yes, I could do it on my own and input it to the system, but how cool would it be to have name generators in the system, for lazy people like me?
- I have a simple number on each of my gangers' miniature (for each gang, it goes from 1 to n, in the order of completion of painting, where n is the number of gangers I have currently painted/operationnal for play). It would help to get it on the roster andr card. Should I put it in the name of the ganger, or...?

 

[Malo]

I hate naming my stuff. People will hate me, but I'm pretty sure it could be done to implement this:

Funnily enough when I saw that post I did some research on name generation. I was hoping someone had an API I could hook into but most of the stuff I found was just sites with their own name generators for users but nothing I could use in my site. There was some stuff on GitHub but it will need some research to see if it's viable for me.

I have a simple number on each of my gangers' miniature (for each gang, it goes from 1 to n, in the order of completion of painting, where n is the number of gangers I have currently painted/operationnal for play). It would help to get it on the roster andr card. Should I put it in the name of the ganger, or...?

That is supported. In the ganger editor, press the Functions button then the change Name/Label button and add your label.

 

[Vonvilkee]

Not sure about programming or if this is useful but...

www.behindthename.com

 

[dabbk]

Thanks @Malo for the label thing, that's precisely what I need!

As for name generation... I'd say it should not be that hard: create two tables (seems that the WC ones are adjective + name?), offer a drop down list if user wants to not randomly generate a name, but get some help coming up with new names.

It does not have to be fully integrated into the tools for now: could be a good quick project for a webdev (I might even be able to hack something together even if I'm a completely different type of programmer).
Of course, it could be that whenever you create a new member, the 'name' field is randomly filled with something, depending on gang type (house), member type, gang name, other members' names, ... this can be made as sophisticated as one wishes

Sooo, about the code snipplet, it would take as inputs:
* gang type (house)
* member type (leader, champion, etc)
* optionnally: member equipment (eg if carries CC weapons only, or long range/heavy weapons...)
* pointer to table of already used names to avoid redundant ones
* pointers to tables like the ones in the WC article. It could be possible to have an infinite number of sets
* some seed to init the random selection of items (or do we

Its output would simply be the generated name. If not happy with a name, click generate again.


Yet another approach would be the string processing exercises that you do to generate "medicament name generator" where you mix syllabes in a way that result in a plausible drug name... takes more work, but that's just to say name generation is an infinite topic

 

[DrCraniax]

Hey @dabbk - the spreadsheet looks great! Maybe someone can point out to me though - for Escher it looks like they're all 5 credits more expensive than the original N17 rulebook. Is this correct - if so where should I be looking for any updates/changes to the rules in the hardcopies? Any help appreciated, have only just started on this journey!

 

[dabbk]

Hi! Hmm, I may have made mistakes. I took the values from my gangwar book, but did this whole thing kind of in a hurry.

If you can point out to precise mistakes, I'll be happy to update the original file. But the beauty of it all is that anyone can easily modify the file, and update whatever they want For example, I am not sure I'll add the orlocks from GW there, but if anyone wants to do it, it should be easy.

 

[DrCraniax]

Hi! Hmm, I may have made mistakes. I took the values from my gangwar book, but did this whole thing kind of in a hurry.

If you can point out to precise mistakes, I'll be happy to update the original file. But the beauty of it all is that anyone can easily modify the file, and update whatever they want For example, I am not sure I'll add the orlocks from GW there, but if anyone wants to do it, it should be easy.

Oh yeah you're right - it's different in Gang War than it is in the original rulebook. Oh man this is going to get confusing as more GW supplements come out... hoping they'll somehow release PDFs of the most recent rules all compiled into one place rather than having to flip from rulebook to rulebook figuring out what's what!

 

[DrCraniax]

Hey dabbk, are you considering keeping the spreadsheet updated with GW2, GSC, Cultists and additional weapons?

 

[Malo]

As for name generation... I'd say it should not be that hard: create two tables (seems that the WC ones are adjective + name?), offer a drop down list if user wants to not randomly generate a name, but get some help coming up with new names.

Missed your post before sorry. It's not really about the development, that's the easy part. It's about having a source of name parts to pick from. So either an existing name generator site that has an API to hook into, or a resource of name parts (preferably themed) that I could obtain and enter into my own database to select from.

 

[dabbk]

Hey dabbk, are you considering keeping the spreadsheet updated with GW2, GSC, Cultists and additional weapons?

I'm not sure: would it make sense? It is not too hard to do, but if it is of no use... also I ordered marchs wd but dont own gw2.