Kindalas; In my game I use the concept that many morphs (especially corporate morphs) come with behavioral programming installed in the design of their brains. To this end I like to switch 1 or two of the Addiction morph traits to Behavioural Programming. In the past I've had to then modify the something in the values sheet so a character choosing Behavioural Programming wouldn't have a neg. Durrability modifier. I can't remember how I did that. Any ideas? I appreciate any help If I figgure it out I'll post the instructions here. [Edit] Figgured it out. It wasn't the values Sheet (note to self: never! Fuck with the values sheet) If anyone else wants to do what I did. On the Morph Sheet; Cell C47, C48 enter: Behavioral Programming >>this will change the last two addiction slots to read "Behavioral Programming"<< On the morph Sheet; Cell K47, K48 enter: =IF(AND(H47>0,J47=""),"What Behavior has been programmed in this morph: is it; Limited?Boosted, Blocked/Encouraged, Expunged/Enforced? (see p. 231 core","") >>this will cause a prompt to ask what behavior has been programmed into the morph<< On the Morph Sheet; Cell Z47 enter: =Z46+IF(H47=2,0,IF(H47=3,0,0)) ... In cell Z48 enter: =Z46+IF(H48=2,0,IF(H48=3,0,0)) >>this will ensure that Durability is not effected by behavioral programming the way it would have been if these were still used as addiction trait slots<< Clear as mud? Good. Now go out and Hack Kindalas' spreadsheet! :D

Yea I'm thinking of redoing how the values sheet stores some of that morph data. I would like to make it so morphs can have a specific number of implants of each type. Rather then the current system of it's all free.

OneTrikPony wrote:

I'd like to add an additional selection of "Custom" linked to the custom morphs from the variables sheet to the Type droppdown on the morphs page but I still havn't figured out how to get into that. I have no idea where dropdown menus are generated. For now I'm just replacing published morphs that I don't care about with my custom varieties. on the values sheet.

I think I understand your statement above and your goal (I'm reading from work so I'm a little distracted) and I think I got this to work, but there were a few columns that needed formulas filled and I didn't want to update something that might get changed in v96. What you're wanting to do is add an option to the drop down menu in the Book/Type field, so at the very end there's a "Custom" option and only your Custom morphs would then show up, correct?, and then as an additional question, would you want them to also show up under Biomorph, Synth, Uplift or Pod depending on the Type you put in? (this, by the way is the formula handling that I was having issues with when trying to come up with an elegant solution). If I'm understanding you correctly, let me know, and I can tell you the fields I edited/updated to get it to work (or so it seemed with the minimal testing I was able to do). I'm sure there's more elegant ways to do it, but seeing as my group is working on a ME/EP crossover type universe (Quarians, Geth, and probably Krogan are allies with Transhumanity, the Council races, not so much) that starts this Sunday, I needed a quick and dirty way to add in a Splicer Quarian Morph (our peace offering to the Quarians), and a Liberated Geth Morph into the spreadsheet, so I didn't go for elegant, I went for working. ;)

Okay, Since I'm not sure how many of the hidden fields you've set to show here is my step-by-step process to adding the three custom slots back in: 1> In the purchasable Morphs section, you'll see that Selkie is on row 136, and the next row is 141, so unhide rows 137 - 140. 2> Next Unhide rows 180 - 453 - this will unhide a lot of stuff, but the Custom Morph Builder is the important section. 3> Type in a name for your custom morph and then scroll back up to row 138 (this step is very important, I couldn't figure out why none of my customs were showing up, then I figured it out) set the GM's Value to Yes. 4> I then proceeded to build a single morph, this was to find out which columns still needed formulas and to make sure everything carries forward, so I gave a basic implant, bioware, cyberware, etc, one of each. (FYI, Ultraviolet sight and some of the newer bioware is not on the list, so you would have to manually update the values column to add those as default enhancements, which will require a copy, then paste Special - > Values in AD93.) 5> Okay, now time to edit the Values tab, first you'll notice that even with everything filled in, Biomorph and Uplift both have blank values, you can either manually edit those fields (typing 1 if yes, 0 if no) or use the formulas in W93 and X93 to build your own formulas. I manually entered the data as my plan was to push these "custom morphs" into standard morphs for my game. If you want to "lock them in" you'll want to Copy, Paste Special - Values A93 to AH93 6> now in cell AH93 type in a Custom field (I used my Initials to stick with the two letter standard). 7> now go to E267 and add the word Custom to the list, followed by editing the formula in E257 to read =COUNTA(E258:E267), the result should now display 10, not 9. 8> Now for the fun formula - On E112, you'll see a long formula that ends in OFFSET($AH$1,MATCH($A112,VAL_MORPH,0),0)="RW") what you need to do is, after the "RW" part, add the same language, only with your two letter code, in my example, my initials are DS, so now it will look like OFFSET($AH$1,MATCH($A112,VAL_MORPH,0),0)="RW",OFFSET($AH$1,MATCH($A112,VAL_MORPH,0),0)="DS"), This should make it so that the Flat says "FALSE" in the field you just edited if you set the Type Field on Morph to "Custom", every formula below it will read "#VALUE!" still, so now highlight E112 to E205, and assuming you are editing this in Excel you can now hit ctrl+D to fill the formula into all of the highlighted cells below it. If this works you should see all of the E values will now say FALSE, except for your custom Morphs which will show TRUE. Theoretically this would allow you to expand the number of morphs, using your custom morphs, to an ever-expanding list of Morphs, you would just have to continue to insert rows and you'd have to edit the conditional formatting on the Default and GM values on the Variables tab, but I haven't gotten that far yet. Hope this is easy to follow, and helps you out, if something doesn't make sense let me know. I have a screen capture program so if needed I could always do a youtube video or something of the changes I make.

Just a very minor note for future revisions, if it hasn't already been reported: the gear description for mental speed comes from the original rules -- it notes a +30 to initiative instead of a +3.

@ MODS: It would be cool if we could merge the two threads on this subect somehow. I posted a reply in the other thread. Probably should have put it here.

Hey dude, I just started running my own campaign and of course I killed their newly made morphs faster than they could have said Transumanism. I just wanted them to get the feeling that lost body doesn't mean dead character, since they are all newbies to EP. But when my player wanted to resleeve and erase all his gear from the charsheet, it generated back the money he had paid for it. Is that a bug or is there any way around it, so he can buy new gear and not get the money from the destroyed one? Thanx for the answer and thank you for your awesome creation. It really helps a lot

The morph is not such a problem, the problem is the gear, if he wants to delete all the gear, because it was burnt in a plasma torpedo explosion, he will get all the money back from it. But I guess that is one unfixable problem, isn't it?

I don't have the sheet in front of me, but couldn't you add a negative amount into the rewards section? Kinda hacky.

That's a quick solution. Right now I'm still aggressively fighting with my mega gun upgrade. I have it at the point where you can buy any gun or ammo or armor combination using drop downs. I just need to assemble the printable data in a useful way.

I'd be interested in seeing your sheets continue as they are but with updated lists/addons for the new morphs, backgrounds, equipment, etc. I've found your sheets to be the mainstay by which every GM who runs an EP game in my local area uses to create and maintain EP characters. I would advise against going down the life path option simply because of the rigorousness of creation your sheets currently allow.

OneTrikPony wrote:

I'd like to re-volunteer my time for data entry. Perhaps I could help with morph, background and faction descriptions? Let me know how I can help.

Well if you are volunteering. Again. Then yes I need the new Factions and Backgrounds as well as a descriptions of all of the Ego/Morph Traits because I really need to get those into the sheet too. And I will ensure that the custom Variables sheet is gone over and redesigned again for people like you who need the flexibility of excel.

MephitJames wrote:

For those of us wanting to help with data entry, what form would you like it it? Ammending the current version or a whole new Excel sheet you can copy/paste into? I volunteer to do Faction entry...

Just start a new excel File. have the first column be just the faction. the second column the page references (EP pXX) or (TH pXX) the third column being the description of the faction. Currently the Core book Factions are done. But the Backgrounds need to be redone because the current descriptions are too short. Considering this is the Scumborn background Description

Quote:

You were raised in the nomadic and chaotic lifestyle common to Scum barges.

and this is the Anarchist faction description

Quote:

You are opposed to hierarchy, favoring flat forms of social organization and directly democratic decision making. You believe power is always corrupting and everyone should have a say in the decisions that affect their lives. According to the primitive and restrictive policies of the Inner system and Jovian Junta, this makes you an irresponsible hoodlum at best and a terrorist at worst. In your opinion, that’s comedy coming from governments that keep their populations in line with economic oppression and threats of violence.

Thanks in advance

I'll start on backgrounds Today and post what I've done each time so we don't duplicate work. @ Kindalas: Can I assume the character count maximum will be the same as it is in the ego section of the .95 sheet?

Alright, well here's my Excel sheet with the Factions and Backgrounds expanded. I tried to make them the same length but feel free to nip and tuck how you wish. Factions and Backgrounds.

Hey kindalas, Anything else you need help with? I think this shows you have a willing population for data entry. Maybe page numbers and such?

A quick and dirty way to make the package generation work: An additional page for the package picks, and then a button that uses a macro to copy the choices into the rest of the sheet. I could easily make the sheet, but I'd need someone to help with the data entry.

I don't do macros on sheets I post online. I can after all format your hard drive with them. And the fundamanetal structure of backgrounds and factions is different between the lifepath systems and the current system. However I'm thinking of ways to structure the input methods to allow for both to exist on the sheet at the same time.

MephitJames wrote:

Hey kindalas, Took a bit longer than expected (I'm starting a new job) but here are the trait descriptions and page numbers from the new sourcebook. I used thelabmonkey's comma-separated values file as a basis so I also put in the trait costs/bonuses just 'cause. As with the faction/background descriptions, feel free to nip tuck to adjust length, although I tried to trim them to be about the same. Let me know if there's other stuff you could use!

Thanks this is exactly what I wanted.

Any updates to the spreadsheet? Last I have seen is version .95 and that was updated sometime last year.

I'm rebuilding the ego sheet from scratch right now. Epic fun. I have just finished the skills of the Factions and backgrounds. It was nice. Now I'm onto the hell of ego traits and rewriting them from zero to integrate PSI sleights into the traits. After that REP and Moxie and the EGO should (crossing fingers be done). [b]Quick Question:[/b] Do I keep the current non cannon multiple identities and rep chart? Or do I only have one field for it and just let everyone notepaper complexity like that? Or do I magically make a more complicated yet informative system? I'll be accepting responses until I finish the traits. William

kindalas wrote:

Currently I have a list of things to do before the next update. My to do list includes: Redesign Guns/Weapons to match the new Armor thing. Put Custom Morphs, Backgrounds and Factions Back in. Maybe Redesign how the Morphs buyable works. Change the base colours. Skillsoft fiddling to work with the new Skills Sheet Redo Muse and AI sheet. Move Muse/AI to Morph Sheet Implement Fork Status on morph sheet. Maybe fiddle with the PSI system.

YES PLEASE! Your character sheet has always been excellent, but there is no way that you could possibly keep up with every new book, outside resource, play-test, and home-brew. Giving a way for users to add in extra content is paramount. Maybe just have a sheet devoted to factions or backgrounds that can be added to or edited (I am not very familiar with the advanced options in xl, but can do basic table entry easily enough).

I'm going to make the custom things all kinds of free to let you do whatever you want. Well within the structure of the excel calculations that exist.

I finally managed to get the New Ego sheet filed away. It now holds everything ego related so now there will be no need to jump from sheet to sheet. Next on my list is an all new Morph Sheet. It will cover all of the Morph details like bonuses traits and implants. The new Gear sheet is almost done. Guns need a bit more work, as always but as I have been working on making guns better for the past year off and on it should turn out quite epic,. After that the Character sheet will need to have all of the small things added back into it. I'm thinking of a change in colours for it from the heavy red to a more printer friendly black and white. I don't want to give a timeline for when it will be done, but that is because I thought I'd be done by now.

Right now I am nearly finished the Morph/Implants sheet. Then I do the gear section of the Gear/Armor/Guns/Ammo Sheet. Then Printable sheet. Then custom options sheet. (Variables sheet) Then it'll be released. It is taking so long because I have had to redo everything. But it will be better and faster then before.