I've just noticed that my favourite piece of gear is missing from the gear section. I can't survive without my survival belt (Gatecrashing, p.159 )!

Chase-san wrote:

Trying out 0.95 it is incredibly laggy. It locks up libre office for like 10-20 seconds every time I change anything, before it will let me do anything again. EDIT: After some research, I have determined the cause is all the conditional formatting. The actual calculation is fast. Is there any chance you can make a version with minimal conditional formatting?

LibreOffice 3.5.7.2 on Win7 with version .95 is fast What version of LibreOffice and what OS platform are you using?

Um I don't know if this helps (probably too late) but here's a list of the changes I've made on most versions of the sheet. These arent' requests just trying to give you some idea of how I use your work. I put a favor used/refresh table on the third colum of the skills In game calendar date. Because tracking favor refresh is important I make a place to record the current date, in game time, on the character sheet. We use a day-of-year calendar ie; AF10:71. This also helps keep backups organized when we archive a character sheet at a backup point. I put an AI/bot form on the third column of the skills sheet and usually make a 4th page for more AI's, bots and shells cause everyone seems to have several. I add extra columns for current armor values cause that changes alot depending on what my characters are wearing and I'd rather just have that available on the sheet without having to select it on the gear page. (I think you might have this one covered already) I add a place to deduct expenses on the gear sheet I kicked the Rep names in the character sheet all the way to the left and set the two spare columns up to auto paste the rep from secondary identities off the Ego sheet I reactivate the custom morphs and backgrounds cause i use those in my campaign. (I've never figured out how to make morphs exclusive to backgrounds and vice versa) I've tried adding a fillable column to the weapons sheet that would allow a write-in for specializations that would automatically add a "skill rate (+10)" but that just screws stuff up and makes everything else not work. Because I always forget to add a bonus to skill tests for implants that a character has, I write all the potential modifications in the next column to the right on the skills sheet. For instance: Perception; Enhanced Vison +20, Persuasion; Tailored Pheremones +10 That way I know when the sheet is adding and when it's not and where the bonus is coming from. Usually when the sheet doesn't add a gear bonus to the skill because the bonus is situational I'll just add it in manually, then on the character sheet when a skill rank has been changed by a situational gear bonus I bold the number and change the text color to red. Also I've come up with my own custom traits but have had a hard time figuring out how to add them to the ego and morph sheets. I tried to add them at the end of the traits list but that didn't work so I generally just use the addiction slots and set the DUR modification to zero. It would be nice to be able to write in some traits at the end of the lists and have them be calculated in the totals and noted on the character sheet. (so I guess that one is a request :) I guess this one is another request. Hardening. I'd love to have a way to track Hardening due to successful stress checks. That's one of the things I use addiction trait slots for on the ego sheet but I havn't figured out how to make it effect moxy maximum. It would also be nice to be able to burn Rep somewhere on either the ego page or the setup page Final request: On the character sheet; could you set it up to trigger lights, sirens and an electric shock every time I absentmindedly type in a cell that contains an equation. I can't tell you how many times I've ruined my sheet by entering rep or moxie changes directly into the character sheet :D Thanks for all your work. Also, Most of my freinds, (who should know, because one is a chemist, and one is some type of webprogrammer, and one does something in finance), are pretty damned impressed with your Excel-Fu. This is not trivial work you have done. I've learned massive amounts of excel just trying to fix the stuff I break. Thanks :D

sent it to your hotmail. I kinda feel like you gave me a cool picture and I scribbled a mustache and glasses on it and gave it back :D

I think I broke the ammo configuration part of the sheet. I select the weapon and the ammo in the fields above but then when I try to link the ammo to the weapon in the ammo selection box it says ERROR:520. All of my players have reported the same problem. Is this a known bug? Also, in the area where I think are supposed to be a list of the equipment (under the implants box) there's no list of equipment, just a single "\". Another bug? Or did I enter an "\" somewhere on accident?

I am using the sheet in LibreOffice. I opened the file in Excel 2010 and it doesn't show anything. I then proceeded to check a copy that I have of the original sheet (unused) in excel 2010 and it appears to work. So somehow something triggers an error when not using Excel.

First is there a new version of the sheet? I am using v.95 in Win 7. My version of .95 is having problems of listing only synth morphs but no other morphs. I am using the latest version of OpenOffice also. What's going on?

agroschim wrote:

By the way, sometimes it's working painfully slow. Is it just my Libre Office or a general problem with big spread sheets?

Comparing performance between Libre, Open, 2007, 2010, it seems to indeed perform worse on Libre and Open, especially Open.

Hey, are the professions suppose to be locked in on the v.95 sheet? if so than I will not touch it, but if I can, how can I get to the val_profession_feild?

Just stopping in to say this has been a [b]huge[/b] help for a couple of online EP games I've played in, although the custom background editor is a touch temperamental* at the moment. *Trying to select any of the new factions results in getting the modifiers, skill selections, and description for one of the three core factions - usually Barsoomian (BG2), Hypercorp (BG3), or Argonaut (BG1). I've tried this with a completely freshly-downloaded copy of the sheet with only custom backgrounds on it too, same thing happens. Drop me a PM if you need help adding data, I have plenty of free time on my hands. Figure I might as well return the favour for how much time this has saved me and no doubt others in my groups. (As a sidenote, I'm guessing the other custom gear/etc. sections are unfinished? Being able to add more/custom weapons and have them actually display in the weapon sections/support mods/etc. would be really handy, I don't want to try just cramming stuff in at random and hoping it doesn't make the sheet break.) [b]EDIT:[/b] Okay, I figured out why custom factions [i]mostly[/i] break! It appears to be the alphabetical sorting. Names are correct, but it doesn't select the correct skill set or background description, like it's not figuring out the offset properly for/from the Values sheet.

is there a version out later than 0.95 i cant find the new backgrounds on my copy at all.

I'm using your character sheet rather extensivly for our campaign. Awesome piece of work! Now, would it be possible to add checkboxes (or something else) to the sheet to assign equipment / morphs to a character without financial costs? I currently have to add enough credits after assigning stuff just to display the "correct" amount of money on the sheet. The same would be nice for reputation gain and loss. In my campaign, the PCs often get rewarded with small increases in reputation, they don't have to spend rez points on it.

What you could do, temporarily, is unhide the Data and Values sheets (in OpenOffice, this should be under Format -> Sheet -> Show...) and tweak the CP costs there. You can also set an item's cost to 'Morph' on the gear sheet and it'll not cost anything. Take in mind you have to be careful doing this because you could easily break stuff by messing around on those pages!

I have made a couple changes to the sheet that some people may find useful. Mostly these changes benefit the most for people who bring there laptops to their RP session, but it can still be useful to those who don't. On the printable page of the workbook I have added a addictions monitor. This monitor displays the most recent "game day" in the RP, the most recent day that your character got his/her/its fix and depending on the addiction level, will tell you how long you have left of your current stash. It will tell you if you are all god with regards to the characters fix, of if your character is going through withdraw. Currently this monitor only works for drug addictions as without knowing every possible addiction out there to date and made it the easiest for me to test while programming if you will. I will continue to work on this and add more addictions for it to monitor. How does the workbook know current game dates and when your most recent fix was you may ask. Well I have also created a Mission Log in the workbook. It has 240 entry blocks for you to write down what happened most recently, if you gained or lost money, rez point gain/loss, I also made it so if you over spend on rez points, you go negative by how much rez you wend over by, and rep gain and loss. This one is interesting because it allows you to directly allocate to which group, if mandated by the GM, where those rep points go, however, when you specify which group it goes to, it gives all the rep to the group. This can be avoided by not specifying which group the rep goes to. The last thing that I believe everyone could benefit from, especially the GMs, is a combat page where damage to the morph, current state of the morph i.e. light damage, heavy damage, unconscious, death, etc. will be displayed, current status of armor, and possibly a changeable battle log if possible. Like I said, still under development. I am currently a computer science major in college so I will admit I somewhat know what I am doing, and I still have a lot of room to grow. If kindalas would like, I may send him what I have done so far and I would love to see what he thinks.

When selecting the Regular Ruster, the Morph trait Planned Obsolescence doesn't appear in the printed sheet. Or am I doing something wrong?

kindalas wrote:

Currently when you purchase a morph with a trait the sheet is set up to just make those traits cost zero points. So the trait won't show up unless you "purchase" it.

Awesome. Thank you so much :-D

Hey! haven't heard anything about the transhuman update for your awesome spreadsheet generator (which taught me the game!). Just wanting to be 'that guy' and ask about any updates? It really is an awesome tool, if I new how to make something like that, I would do it myself. But sadly I haven't a clue where to start. Anyways, thanks for making it and excitedly waiting for an updated version!