So… i’m trying to do something similar for a different spreadsheet. I have never really messed up with scripts before. @zhavier, how complicated is it to just create a script that randomizes a list and draws one item? (basically, I just want the ‘draw 1 card’ script)
You should be able to open my script and find the draw one function in there. It uses the shuffle function built into VBA.
1 Like
@zhavier, is there currently a way in the spreadsheet to force tech cards into the discard and to be recorded without drawing? I say this as it would be very useful with Garth’s Maxband/Remembers then manually fiddling around with the output provided.
1 Like
No, but I could probably add it.
It would have to be a button, as opposed to the oathkeeper/prynn box that modifies the discard/draw function.
I am running out of space for buttons 
3 Likes
I have added a button past the bottom of the sheet, for saving tech choices. It is out of the way, because I didn’t want to disrupt the more generally useful buttons. It is next to the prynn/oathkeeper and Shrine options, but it functinos as any of the other buttons.
I have also edited the sheet to account for the forum changes, which seems to break the italics and bold command tags if they are capitalized.
2 Likes
It seems like the formatting rules for the forums recently changed, so I whipped up some simple HTML to translate the spreadsheet output into a form that the forums can handle, as well as adding spoiler tags to hidden details info. To use, just copy/paste the text (look for the “RAW Paste Data” at the bottom) into a file, name it with the file extension .html, and open it in a web browser.
Edit: New version, new features! You can now put the special terms “Future”, “On Loan”, and/or “Jailed” in your Board column and they will be formatted as separate lists from “In Play”. Also, if “In Play” is empty, it will be removed. And, if you set a building’s HP to 99, it will appear as infinity (∞).
2 Likes
nice work, though note I already changed the big B and big I to little b and little i for any new sheets.
1 Like
I made the replace for those case insensitive, so there shouldn’t be any compatibility problems from that. Thanks for the heads-up, though.
is there any program that when you write the name of the card here in the forums, it automatically writes it’s attack and hp. lol. and better yet, replaces it with the card picture. lol
Thanks for all your work @zhavier. I have enjoyed your spreadsheet for a long while.
If it was up to me though I wouldn’t have the tech choices connected to the draw button at all. Often I write my tech choices after I finish my turn, then if I have a technician die - I have to delete my tech choices, draw a card, then re enter them. I would have a button that says ‘confirm tech’ which you have to do at the start of each turn. perhaps other people disagree though.
1 Like
I took some shortcuts in coding that would make it a pain to undo at this point. Essentially, the draw 1 button is the core function and the discard/draw button piggybacks on it and so the tech choices are saved in there. I say pain, but I am also lazy, so, yea…
You are playing it more to the spirit of the rules, but in practice, forum games let you plot out most of your turn and then type in the tech choices, assuming you no draws during your turn.
Laslty given the real estate issue, I kinda ended up hiding the save tech choices button, so many users would not know it was there and or would forget to use it. So if I made it a required thing, people might make errors due to forgetfulness, especially if they are used to the way it works now.
1 Like
For sure. I sometimes do that too - it’s hard to avoid. But I also try to plan ahead but writing all my tech choices at one places and its often makes sense to plan ahead and note what you want your next tech choices to be. In any case, I don’t expect you to do any more work on the spreadsheet and it’s not a critical issue at all.
Also, it’s not just against the spirit of the rules, it’s against the letter of the rules. If you were playing in person you couldn’t do that.
1 Like
In person it would be like spending a lot of time at the start of your turn playing out your moves in your head, then finalizing your tech choices, then taking your turn. Assuming no draw mechanics happen during your turn.
4 Likes
@zhavier I’ve added a dropdown list option for selecting tech (helps me to actually type names correctly for autocard to work on the forums). It works based on which specs they selected, do you want to add this to the base spreadsheet and if so whats your preferred method of me giving you the changes?
3 Likes
Pm me a link to the spreadsheet you changed and I’ll see about incorporating the change
2 Likes
Added the dropdown. Thanks 
2 Likes
So, question. I teched a card and it turned red during the draw/discard phase. Is that meaningful? (It’s definitely not an accidental third copy)
In the tech box? It should only give an error (says invalid input on hoverover) if the card you put in are not within your selected specs. It doesn’t matter at all in the slightest really though. You can write whatever you want the boxes, the scripts that move the “cards” around don’t look at the text inside, I just added it so that I could actually spell the cards right for the forums (and so people’s autocard everywhere actually picked the right cards…)
Nah, in the discard pile