Malfunction Randomizer

General chat about fembots, technosexual culture or any other ASFR related topics that do not fit into the other categories below.
Post Reply
User avatar
GalianaChance
Posts: 58
Joined: Fri Jan 21, 2011 1:39 am
Technosexuality: Built and Transformation
Identification: Android
Gender: Female
Location: Houston, TX
Contact:

Malfunction Randomizer

Post by GalianaChance » Thu Feb 03, 2011 2:58 pm

As I indicated this awesome thread (in which you guys were awesome),
http://www.fembotcentral.com/viewtopic.php?t=8867
... when I am role playing malfunction sequences, I have found myself being insecure about giving enough variety, and also getting a little overwhelmed by all the possibilities. The results was: I felt a little uncreative and repetitive :oops:

My first attempt to write out possibilities of malfunctions helped somewhat, in that I was able to scan a list and use a few, but then I found myself bogged down in real-time by having to mentally keep track of "which of these have I already used?" So I stopped looking at the list, which put me back at square one.

During the thread above, I thought of the idea of building a little randomizer for malfunction ideas. I wanted it to be as simple to build and use as possible, so that not only could I use it, but anybody else in the community who wanted to use it for role plays or stories could grab it and do whatever they wanted with it.

I used Excel, and saved the spreadsheet as an old format (Excel 97-2003 format) so hopefully as many people can use it as possible.

There is no "web interface" to it, it's just a straight download of an excel file.

The file can be downloaded here:
http://psophotos.net/galianachance/tech ... erator.xls

The concept is simple: each idea has a random number, a Category and an Example. Some examples are concepts (slow speed / raise speed), and some are specific phrases ("System crash is imminent").

The random number is generated by this Excel function: RandBetween(1,100)

The number re-generates every time the spreadsheet is recalculated. This recalculation event is triggered when the list is sorted (Why? I dunno, but it's handy, so I'm not questioning it...).

I put an Excel filter on the column headers, so all you have to do to re-scramble the list is to re-sort the column titled "RE-SORT ME" (click on the little arrow by the words "RE-SORT ME" and choose "Sort Smallest to Largest"). Voila!

The font is Terminal to amuse myself.

Over to the right are phrases which are helpful upon rebooting or restarting some component, which I found I wanted handy all the time instead of being buried at some random place on the list.

I had two malfunction role plays yesterday: one before I did the generator and one after. The one before felt like I was searching / breaking flow, and repetitive, and I felt like I had concentrate hard to come up with things to do.

The malfunction role play I did with the generator felt ten times easier, significantly smoother in terms of rhythm and pacing, and infinitely more varied and creative. I could just keep scrolling down the list and pick the next relevant thing without being concerned about having to think of something new or keeping track of what I'd done already. I found myself skipping things because they didn't fit the context, but that worked great.

So, I'm pleased. Yay!

Please feel to offer suggestions for improvement, or additional items for my list - I'm sure I'll add stuff all the time. I'll try to remember to keep the publicly linked one up to date with my latest phrases.

You may use any or all of the file in any way you wish, whether to help you build better malfunction sequences in your fiction, to do better role plays, or heck, I'd kinda like it if you just got turned on by it as a little work of art :)

I'd love to know what you think!!
Galiana Chance: Professional phone sex operator with a theater & technical background, trying to improve my role play skills for technosexual callers.
Relevant blog posts: http://galianachance.net/blog/category/technosexual/

xerxes31415
Moderator
Posts: 305
Joined: Sat Jun 16, 2007 12:50 pm
Technosexuality: Built
Identification: Android
Gender: Male
Location: Los Angeles, CA
x 2
Contact:

Post by xerxes31415 » Thu Feb 03, 2011 5:48 pm

First of all, I'm always impressed to see a well made spreadsheet! I'm quite impressed.

Second, as a possible suggestion: Why not break up the spreadsheet into two parts. One being the randomizer and the other being the list of actions? You could easily do this by making a three column list off screen of what you have currently with a non-changing "tracking" number. Then still use the randbetween function, but go from Min(tracking numbers) to max (tracking numbers). The trick then is to change column B and C of your current spreadsheet to use the lookup function to auto-update the list, instead of having to resort the "re-sort me" column.

Hope that helps!

User avatar
GalianaChance
Posts: 58
Joined: Fri Jan 21, 2011 1:39 am
Technosexuality: Built and Transformation
Identification: Android
Gender: Female
Location: Houston, TX
Contact:

Post by GalianaChance » Thu Feb 03, 2011 6:09 pm

xerxes31415,
I started in a direction similar to that, actually, but realized it would take a button or a macro of some type to fire off the "randomize" reshuffling, and having a macro or code triggers a lot of legit safety concerns. I know I'd be 100 times less likely to download something with programming in it from a stranger.

And then there's the versions-of-Excel issue: programming written in the old stuff ports up (usually), but backwards compatibility isn't good, even for simple stuff.

But I confess, the real reason I did it this way: my f%$&ing button wasn't working right. Ah yes, the mother of all invention: crap not working properly.

Then I accidentally stumbled on the happy re-sort re-calculate, and realized that it was simpler, and a little more shareable, with no versioning concerns.

Genius isn't always designing something beautiful, sometimes it's just recognizing it when it happens, right? (please yes, it'll make me feel better about not getting the button working...)

But back to legit discussion: one functional issue with randomly pulling from a set list of non-changing tracking numbers: when you run a random(100) one hundred times, some numbers occur multiple times, and some other numbers are left out altogether - it's not a basically even distribution unless you run it thousands of times, but I want all the options ordered for every re-shuffle.

SO, either I need to make the "reshuffle" function aware of what has been used, or be okay with having #14 five times and #30 none.

... unless, of course, I'm not understanding you, in which case, please let me know!
Galiana Chance: Professional phone sex operator with a theater & technical background, trying to improve my role play skills for technosexual callers.
Relevant blog posts: http://galianachance.net/blog/category/technosexual/

xerxes31415
Moderator
Posts: 305
Joined: Sat Jun 16, 2007 12:50 pm
Technosexuality: Built
Identification: Android
Gender: Male
Location: Los Angeles, CA
x 2
Contact:

Post by xerxes31415 » Thu Feb 03, 2011 7:05 pm

Yes, necessity is the mother of invention. (which I guess means that crappy coding and security holes from Microsoft would be its step-dad, but meh)

I prefer to stay away from macro's and such as well, especially because you start running into issues where a file could self-destruct on you with one poorly written line. ...Yes, that actually has happened to me.

As to your functional issue: Yes, exactly what you describe would be a problem. I will see if I can figure out a way in excel to not have any repeating values. Although, one way to potentially "fix" that problem is to expand the response list. This way, if you're making a table of 50 from a larger list of say 500, you will almost never have any repitition.

Also another drawback of this method is that if you happen to hit any keys or do anything with the spreadsheet, the list will auto-re-sort, which means if you were planning on following this like a script, you'll lose your place and potentially your train of thought.

KingJeremy

Post by KingJeremy » Fri Feb 04, 2011 7:15 am

Having called and tested this new feature (I'm an early adopter of technology of this variety :D ) I was very pleased at just how positively it affected my experience. So many varieties of malfunctions and we got to use quite a few of them and every single one made sense in the moment and all of them integrated seamlessly into the flow of the conversation. This is an excellent resource to have available.

User avatar
GalianaChance
Posts: 58
Joined: Fri Jan 21, 2011 1:39 am
Technosexuality: Built and Transformation
Identification: Android
Gender: Female
Location: Houston, TX
Contact:

Post by GalianaChance » Fri Feb 04, 2011 7:31 am

Thank you RM & KJ!!
Galiana Chance: Professional phone sex operator with a theater & technical background, trying to improve my role play skills for technosexual callers.
Relevant blog posts: http://galianachance.net/blog/category/technosexual/

King Snarf
Posts: 909
Joined: Sat Mar 27, 2004 9:02 pm
Technosexuality: Built and Transformation
Identification: Human
Gender: Male
Location: Drexel Hill, PA
x 5
Contact:

Re: Malfunction Randomizer

Post by King Snarf » Sat Apr 30, 2011 3:51 pm

I don't know if this is still an issue, but it seems to me you could always roll 2 ten-sided dice, with the first one representing 10-00, and the second one representing 0-9.

User avatar
GalianaChance
Posts: 58
Joined: Fri Jan 21, 2011 1:39 am
Technosexuality: Built and Transformation
Identification: Android
Gender: Female
Location: Houston, TX
Contact:

Re: Malfunction Randomizer

Post by GalianaChance » Sat Apr 30, 2011 8:09 pm

King Snarf wrote:I don't know if this is still an issue, but it seems to me you could always roll 2 ten-sided dice, with the first one representing 10-00, and the second one representing 0-9.
Hi, Snarf - thank you for the recommendation! It's a good idea to rapidly generate one random *number* at a time, but that doesn't help me rapidly generate random *ideas* and act on them. If I had to roll a number, then look up which malfunction it represented, then carry out that malfunction in real time, I'd be much too distracted by the lookup process to have continuity in real time.

The advantage to having a big long list sorted in a random order is that I can scan through and pick the ideas which work for the scenario of the moment, without becoming repetitious, and without having to confuse myself by looking anything else up.

But yes, when you're doing tabletop RPG, or if you're in a situation where the mechanics are not distracting, that's the perfectly elegant solution indeed.
Galiana Chance: Professional phone sex operator with a theater & technical background, trying to improve my role play skills for technosexual callers.
Relevant blog posts: http://galianachance.net/blog/category/technosexual/

King Snarf
Posts: 909
Joined: Sat Mar 27, 2004 9:02 pm
Technosexuality: Built and Transformation
Identification: Human
Gender: Male
Location: Drexel Hill, PA
x 5
Contact:

Re: Malfunction Randomizer

Post by King Snarf » Sat Apr 30, 2011 8:21 pm

Yeah, I didn't really think that one through all the way. :oops: In my defense, I had just listened to your robot voice sample, which was really awesome.

User avatar
GalianaChance
Posts: 58
Joined: Fri Jan 21, 2011 1:39 am
Technosexuality: Built and Transformation
Identification: Android
Gender: Female
Location: Houston, TX
Contact:

Re: Malfunction Randomizer

Post by GalianaChance » Sat Apr 30, 2011 8:25 pm

King Snarf wrote:Yeah, I didn't really think that one through all the way. :oops: In my defense, I had just listened to your robot voice sample, which was really awesome.
Being confused by listening to my voice will always and forever be an acceptable excuse! :thumbsup:
Galiana Chance: Professional phone sex operator with a theater & technical background, trying to improve my role play skills for technosexual callers.
Relevant blog posts: http://galianachance.net/blog/category/technosexual/

King Snarf
Posts: 909
Joined: Sat Mar 27, 2004 9:02 pm
Technosexuality: Built and Transformation
Identification: Human
Gender: Male
Location: Drexel Hill, PA
x 5
Contact:

Re: Malfunction Randomizer

Post by King Snarf » Sat Apr 30, 2011 8:28 pm

GalianaChance wrote:
King Snarf wrote:Yeah, I didn't really think that one through all the way. :oops: In my defense, I had just listened to your robot voice sample, which was really awesome.
Being confused by listening to my voice will always and forever be an acceptable excuse! :thumbsup:
Good to know. :wink:

Post Reply
Users browsing this forum: No registered users and 4 guests