Members | Sign In
Modiphius > Mutant: Year Zero (Free League Publishing)
avatar

Zone Sector Generator

posted Jan 22, 2015 16:46:54 by roastinjones
Hi all,
i thought i'd put together a zone sector generator in excel just to quickly crank out the sectors, after all there's 400 in a zone and that's a lot of dice rolling for any mans wrist to handle :)

Its an xlsx file using vlookups and simple formulas - it follows the maths of the tables in the book exactly but there's no nasty macros in the background so your anti virus scanners should be fine.

I'm not great with Excel so it's a bit rough, but hopefully it will help you when filling out your Zone.

This is a direct link to the zip file - there's no password nor is there any protection on the excel file.

http://www.prwduk.com/M0/M0SectorGen.zip

Thanks to Chris and Tomas for letting me share this.
page   1 2 next last
20 replies
avatar
TomasFriaLigan said Jan 22, 2015 20:28:18
Very cool! :)
avatar
StéphaneIdczak said Jan 26, 2015 08:15:17
Wow, it's a very cool stuff.
Thank you for sharing !
avatar
StéphaneIdczak said Jan 26, 2015 13:12:58
I am a total newbie with Excelle, but I would be interested to translate this fabulous generator into french.
How can I do please?
avatar
roastinjones said Jan 26, 2015 14:27:51
Hi Stephan - there are 2 hidden sheets in the spreadsheet, one of them contains the contents of all the tables referenced from the book. If you translated those entries without moving anything around, it will continue to work fine and the generated entries will come up as you want them to. Sorry but I can't help you - i've no French beyond bonjour :)
avatar
StéphaneIdczak said Jan 26, 2015 16:22:31
Thank you for the answer.
When i am in Excell, waht is the path to open the 2 hidden sheets please?
I am realy a big noob with Excell...
I have already translated 90% of the game in french, so I will only to copy/past my translation in your file.
I just have to find how and where...
[Last edited Jun 05, 2015 08:50:27]
avatar
roastinjones said Jan 27, 2015 09:44:42
If you right click the mouse over the one tab that you can see, you'll see an option to Unhide - left click on that and you'll see the 2 hidden tabs appear. If that doesn't work for you, PM me your email address and I'll send you a copy with the tabs unhidden for you.
avatar
StéphaneIdczak said Jan 27, 2015 10:53:19
Oh yeah ! It works ! Thanks a lot !!!
avatar
roastinjones said Jan 29, 2015 15:27:00
Hi folks - thanks go to an eagle eyed member on the Fia Ligan forum, who spotted a bug on my sector generator (nothing huge, just a couple of blind spots on the random scrap generator). I've updated the spreadsheet and posted it on the same address as my first post. Cheers
avatar
TomasFriaLigan said Feb 05, 2015 13:54:57
Great work! :)
avatar
ChaoticGM said Feb 23, 2015 10:56:12
Super tool, thank you!
avatar
roastinjones said Feb 23, 2015 12:56:46
Thanks guys :)
avatar
Jakub Koprowski said May 19, 2015 11:23:11
Hi. I have created a web version of the generator. It looks good even for mobile:)
avatar
StéphaneIdczak said May 19, 2015 11:33:55
Cool stuff ! Thank you for the web version !
avatar
g5c said Jun 28, 2015 19:09:02
Great tool, thanks!
avatar
DerekHand said Jun 29, 2015 03:32:06
Love the Web version.

FYI, Environment and Settlement are misspelled, and not sure what the "Re-Roll" artifact is.
Login below to reply: