Shadowrun
Shadowrun Play => Character creation and critique => Topic started by: hannibalisfun on <07-19-13/0343:32>
-
On a whim, I started building a character builder in excel for 5th edition Shadowrun this week since I hate working with paper and pencil. It is definitely not done but I think you can more or less go through the character creation process for anything except a technomancer and maybe riggers/hackers. Just a heads up, the layout on everything except maybe the augmentation and inventory tabs is horrible and I don't have a sheet that really compiles everything except maybe the Karma tab.
Any way, I figure I would post the current version of the project in case someone want to run with it or just use it. Let me know if you have any suggestion or found one of the many mistakes. I am sure I made. The file is available here.
Update(8/14/13)
version 0.8.6 of the Character Builder. here (https://www.dropbox.com/s/s9md4z7hw08k74b/Character%20Builder%20V0.8.6.xlsx).
Update(4/13/14)
I just figured I should note that idiedtrying has taken over this project and converted it over to openoffice. So, the link above is no the most up to date file. Just go to last page in this thread and it should be somewhere around there.
-
Will give it a look, thanks!
-
;D
Thank you so much!!!
Please check the magic on a Mystic Adept magic priority C.
I think it is off by one.
-
I think I fixed the issue with the magic ratings on the mystic adept and Magician. Here is a link to the updated file https://www.dropbox.com/s/py1xitbzcykvh6b/Character%20Builder%20V0.6.1.xlsx (https://www.dropbox.com/s/py1xitbzcykvh6b/Character%20Builder%20V0.6.1.xlsx).
-
Will definitely be checking this out! My group will need a good char builder, what with the guy behind Chummer not planning to update to 5e.
Thanks!
-
If anyone has a character sheet in excel that I could steal. I would appreciate it then I can try to create an output for the character creator.
-
Heads up - Negative qualities are taking away karma instead of granting it. :)
-
I don't use Excel, I use Apple Numbers - but without getting into a war over which is better (Numbers) ... I opened it to see if it worked. It seems to be fine with only minor formatting oddities. So, simply wanted to say "good work" that's a lot of typing and such. Keep us updated with revisions!
-
I thought I had fixed the negative qualities issue but I must of missed it. It should be fixed tonight.
So, I looked into it and the most up to date files should have the problem fixed.
-
On priority b for magic the values are reversed. It gives me 6 magic and a skill at 4 with a mystic adept. It Gives a magic of 4 with no skill for adept.
-
There is a new version up. It should now work for technomancer and I added a section for knowledge skills and contacts. Also, I appreciate the issues people are pointing out.
-
On the spell list, unless I am missing it, I don't see any of the Increase (Mental) spells listed. You only have the Increase (Physical) spells. Being that mages will most likely want to pick up Increase Willpower, Logic, or Charisma, would be cool to have it added.
-
On the stats page there is no way to increase your magic. For example if you are priority D and start with 2 Mag you could only increase it to 6 with special points by getting rid of B11s code, which will make the cost come out wrong.
-
Also, I appreciate the issues people are pointing out.
We doubly appreciate the work you are doing. There is a void in the character creation help department, and every bit to fill it is a good thing. :D
-
New version is up. I fixed markelphoenix and Chrona issues. Hopefully sometime this week, I can get a character sheet up and running.
-
Looks good.
Thank you.
Are you going to make Race on the Stats workbook be a menu selection?
-
RE: Version 0.7.7 -
On the Qualities Database, the Allergies are listed like this:
Allergy - Uncommon 2 0
Allergy - Common 7 0
Allergy - Mild 3 0
Allergy - Moderate 8 0
Allergy - Severe 13 0
Allergy - Extreme 18 0
Should look like this since the Uncommon/Common combines with the Mild/Moderate/Severe/Extreme ratings....
Allergy - Uncommon/Mild 5 0
Allergy - Uncommon/Moderate 10 0
Allergy - Uncommon/Severe 15 0
Allergy - Uncommon/Extreme 20 0
Allergy - Common/Mild 10 0
Allergy - Common/Moderate 15 0
Allergy - Common/Severe 20 0
Allergy - Common/Extreme 25 0
-
Are you going to make Race on the Stats workbook be a menu selection?
It should already be there but I had similar issue with one of my friends. I am going to try creating the list a different way to see if it is compatible with more versions of excel. Just for reference. what version of excel are you using and are there any other drop down lists that don't work?
TCArknight, I just listed the way I did because I was being lazy. I assumed someone would just pick an availability and a severity but I guess I should go in and create the combinations.
Hopefully, I should be able to have both those tweaks done sometime before i go to bed.
-
skills tab: While Lockpicking and Locksmith are both listed, there really should only be Locksmith.
Knowledge Skills tab: missing column for Specialization costs like you have for skills..
Modification to the Karma tab - Add a spot for Resources trade
-
So, just a general update on progress. Still working on getting the excel sheet to generate a character sheet between work and preping for my own game. I have not had much time to devote to the issue.
skills tab: While Lockpicking and Locksmith are both listed, there really should only be Locksmith.
Knowledge Skills tab: missing column for Specialization costs like you have for skills..
Modification to the Karma tab - Add a spot for Resources trade
I will try to fix the first two before I go to bed tonight but the last comment. Maybe I missed something in the character creation chapter of the rule book but beside the 2,000 per a point of starting karma. I don't know what that would be and I think i already included that.
-
Just thought I'd let you know that after choosing priorities the amount of attribute points and special points is off. I chose attributes 3 which should've given 14 attribute points but instead it showed 22/7 instead of just 14 points.
-
Just as a bit of help, I made a front end character sheet in excel. It's hyper crude in terms of what I've done it, but I figured any shortcut you can use will help you (at least that's always been my experience). Feel free to crib it wholesale if it helps the project. https://docs.google.com/file/d/0B6s2WZ2XUShmMmFJVFBXdzg3ZFU/edit?usp=sharing
-
Just thought I'd let you know that after choosing priorities the amount of attribute points and special points is off. I chose attributes 3 which should've given 14 attribute points but instead it showed 22/7 instead of just 14 points.
Looks like that is because all of the attributes and edge starts at 0 values instead of 1. The initial cost should be showing a - value. Buying it up to a 1 value, will then show the correct values.
-
Thanks! That worked!
-
So, I have been slowly plucking away at this sheet and now I have a basic character sheet that should show attribute, skills, limits, etc. I still need to build a second page for inventory and augmentations. It should take Augmentation into account for attributes but not adept powers and no cyber limb averaging.
-
So, I have been slowly plucking away at this sheet and now I have a basic character sheet that should show attribute, skills, limits, etc. I still need to build a second page for inventory and augmentations. It should take Augmentation into account for attributes but not adept powers and no cyber limb averaging.
VERY exciting news. My players have been looking for something like this.
-
It says there is no file to download.
-
Damn, I must of messed up the link. I will take a look when get home from work this afternoon.
Update: The link is now fixed.
-
Any chance you can make the character sheet wider? The way it is now it looks squished together making it barely
readable.
-
I will look into it. When I made the character sheet. I was trying to fit it on to one page but i maybe set up one sheet to print and one to view on your computer screen.
-
Thanks, hannibalisfun! This will come in handy)
-
Using build 0.8.6, if I set Magic priority to A, and set "Are you an Adept" to 'Yes', it breaks power points and base magic rating to #N/A
-
Using build 0.8.6, if I set Magic priority to A, and set "Are you an Adept" to 'Yes', it breaks power points and base magic rating to #N/A
That's cause you cant take Priority A in magic for an adept your either a Mystic adept, a Magician or a Technomancer. Try magic priority B for an adept and move whatever your B was to A.
-
great program you made only thing i noticed off was the exotic ranged weapon skill didn't show the points you put in correctly
-
Thanks so much for building this, it's the best tool of its kind I've been able to find.
Hope it's not too presumptuous, but I spent some time making a lot of bugfixes, adding some features like different campaign levels, checks on a lot of different limits, and polishing the interface. Here's my version, hope it's an improvement.
-
Neo-Anarchist, One thing I've noticed even with Hannibalisfun's version is that for augmentations that have capacity neither
sheet fills in the correct capacity as they both show 0 for items like cybereyes which does have capacity. Also, any chance
either of you (hannibalisfun or neo-anarchist) could make the qualities section wider or on another page so we can either
add subsections for qualities that have the such as codeslinger (hack on the fly), ect.? Thanks to you both though!
-
Good call, I hadn't realized that was missing. Thanks for the tip, I've uploaded a new version on my original post, see if that does the trick.
Any other bugs or feature ideas?
EDIT: Just added a comments field for qualities too, which will let you specify whatever appropriate detail (for example what the character is addicted to, or what matrix action they're good at, etc.). I also took out the karma display for qualities on the charsheet, since that's not really relevant there, so there's a bit more room for detail text.
-
I just made an adept with magic priority B. The character sheet listed his magic of 6 in the "Resonance" box. Just thought you should know.
-
ISSUES:
- Active Skill selection from Adapt don't show in the Karma tab (and likewise in the character sheet).
- Distinctive Style quality gives 9 karma instead of 5.
- Non-defaulting skills (such as Arcana, Compiling ot Pilot Aerospace should have a default value
Thank to both of you!
-
Thanks sahadir and rythymhack for the bug reports. I think I fixed all those issues, although I wasn't clear on your last point sahadir.
I figured you meant that skills you can't default on shouldn't have a "Total Dice" rating on the character sheet unless you actually know the skill, which is a good point, so I changed that.
If there's anything else, hit me up while I'm still motivated :p
-
Neo-Anarchist, I appreciate that someone is running with my excel sheet. I like what you are doing to the sheet. My personal shadowrun game died with a whimper. So, most of my motivation to work on this had fallen to the wayside until I can get into another shadowrun game. Although, I am still working on adding a section to auto calculate weapon stuff; die pools, damage, ap, etc.
-
if you find the time to add weapon stuff, that sounds awesome! i have no plans to do anything major like that, just polish the UI and work out the kinks (so I can use it for my own campaign :)
After checking out this sheet (http://forums.shadowruntabletop.com/index.php?topic=11925.0), I've been wanting to try some of the fancy scripting ideas in use there, so that may be next for my part.
Let me know if there's anything I should especially not mess with to avoid conflicting with your work.
-
Looks great but one question why is the character sheet split like on the right side? Also the knowledge skills values don't appear to work. Where is the karma total?
-
The most about of time I spend, and others spend making characters is choosing what your going to take, and some tweaking at the end. The math is about 2% of the time it takes to make a character. Sometimes I'll use a calculator for alphaware or used ware, to double check.
-
It's a shame you lost motivation hannibalisfun as your character sheet is one of the best ones so far. I don't know if
you or neo-anarachist was planning on making it as detailed as the upgraded character generator found below but
i'm greatful for both neo-anarchist and your work on it.
http://forums.dumpshock.com/index.php?showtopic=23735
PS: Not sure if linking to other forums is frowned upon here but if it is I apologize.
-
I'm making a few updates to this sheet; mainly to add a Text Block output suitable for posting on forums. I'll post a link here once it's ready.
-
Just uploaded version 0.8.10. A bunch of interface improvements (you can filter augmentations and gear based on category now).
Also, in order to support open standards and compatibility, I ported the spreadsheet to ODS format. It should work in Excel, Open Office, and any other compatible spreadsheet software.
-
Where is the link?
-
Previous page, it's an attachment
-
None of the dropdowns seem to be working (Excel 2007) in the 0.8.10 release.
When opening, it also complains of unreadable content (downloaded zip file is 100kb and the ods file is 114kb)
The error log from the recovery is below:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<logFileName>error059240_01.xml</logFileName>
<summary>Errors were detected in file 'C:\Users\REDACTED\Dropbox\ShadowRun\CharGens\Character Builder V0.8.10-neoanarchist_fork.ods'</summary>
<additionalInfo>
<info>Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.</info>
</additionalInfo>
</recoveryLog>
-
There's an error in the Gear Calculation for "Chargen Allowed?" The formula does not always refer to "$U$5" but sequences with each row.
-
None of the dropdowns seem to be working (Excel 2007) in the 0.8.10 release.
When opening, it also complains of unreadable content (downloaded zip file is 100kb and the ods file is 114kb)
The error log from the recovery is below:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<logFileName>error059240_01.xml</logFileName>
<summary>Errors were detected in file 'C:\Users\REDACTED\Dropbox\ShadowRun\CharGens\Character Builder V0.8.10-neoanarchist_fork.ods'</summary>
<additionalInfo>
<info>Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.</info>
</additionalInfo>
</recoveryLog>
I am getting the same error using Office 2010 professional.
My excel skills are too weak for the repair.
-
Sorry for the delay, I've updated version 0.8.11 with a lot more bugfixes and small polishes here and there.
I noticed the same problems in Excel - unfortunately Excel doesn't seem to handle the version of the sheet that I'm working with now. I guess I suggest using OpenOffice or LibreOffice (which are better software anyway, being open source). For those who are stuck in the megacorp software game, I'll include here the older version (0.8.9) which still works with Excel.
-
Hi,
I guess I could slum it with OpenOffice (socialist software)...
I can find 0.8.10 but not 0.8.11, Can you give us a link/attachment?
Cheers
-
I have just the image for that!
(http://www.dailyfailcenter.com/sites/default/files/fail/aWZ1A8d_460s_v1.jpg)
-
I have just the image for that!
(http://www.dailyfailcenter.com/sites/default/files/fail/aWZ1A8d_460s_v1.jpg)
You know, that's just going to encourage some people around here!
Seriously, thank you to hannibalisfun for doing the original version, and Neo-Anarchist for continuing this. I've just started a SR5 game, and needed an electronic option for my character sheet. Bad things always seem to happen to my paper ones.
-
Anyone got a link to the latest version?
-
I had been just updating my original post, replacing it with the newer version, so as not to crap up the messageboard. But given that there are compatibility issues which might cause people to want an old version, and that my post is buried somewhere in the middle of the thread, I'll just start adding a new attachment with each update.
p.s. death to microsoft and all western aggressors :)
-
Yeah having issues with no dropdown menus in OpenOffice.
-
Where do I add initiate levels and also choose Mentor spirits? I couldn't find them on karma or adept page.
-
Thanks!
-
The V0.8.11-neoanarchist_fork works very well for me.
I like that it blanks out active skills which you cannot default, however you seem to have lost the -1 for defaulting (see pg. 130) when you can. A "-1" can be added the first sum.
e.g. for Character Sheet S22, =IF(U22=0,IF(VLOOKUP(A22,$'Skills Database'.$C$6:$G$86,4,0)="Yes",W22+Y22-1,""),U22+W22+Y22)
One minor issue, in LibreOffice, function "ifna" isn't supported so on the priorities page, you need to strip it.
e.g. for Priorities B6, =ifna(LOOKUP(B6,E3:E7,J3:J7),"")
-
hey guys, I dont know if this is still relevant, but i fixed some bugs and did some improvements that use ooo basic. So u should use open office. For example there is now a weapons table on the character sheet, listing all ranged weapons with the according stats bought on the inventory sheet. Tell me what u think.
-
@idiedtrying - Thanks for the update. However, I have noticed a few problems.
1) The Ranged Weapons table on the character sheet tab doesn't seem to auto generate like you suggested in your comment.
2) On the Melee/Projectile Weapons table on the character sheet tab, the Type column doesn't seem to be pulling the correct info for the Weapon column. For example when you select Melee Weapons - Blades in the Type column your options in the Weapon column are; Forearm snap-blades, Katana, Knife, Pole arm, Survival Knife, Sword, Club (not a blade), and Extendable baton (also not a blade). And, it's missing the Combat Axe and the Combat Knife. It looks like it's omitting the first two entries from the Blades table and grabbing the first two entries from the Clubs table. It's not incorrect for just the Blades type.
3) The Attribute-Only Tests table on the Character Sheet tab seems to have some multiply operations that should be addition operations.
Thanks to everyone that has contributed to this project. Some pretty good spreadsheet skilz.
-
thank you for your bugreport Dilz669. I should have fixed the points 2 and 3. The thing with point 1 is, i am pretty sure that it works, but you have to actually use the macro "init" to make it work. The macro should automatically start when u open the file, but the standard preference in open office is to block unknown macros. So you should set the macrosecuritylevel on middle and let the macro "init" automatically run when the document is activated (but that should still be the case).
I also fixed the defaulting bug.
Attached the new version.
-
btw could someone explain to me the new gear- and lifestylecosts for trolls and dwarfs, which came with the errata, so i can implement them into the sheet?
and as always if u find a bug just write a bugreport.
-
There is no longer an increased cost to gear for Dwarves and Trolls. Instead, Dwarves have a 50% increase to their Lifestyle cost, and Trolls have a 100% increase to their Lifestyle cost.
-
ok thanks for the explanation. :) here is the new version.
-
i have a lot of freetime at hand right now. Has someone a wish on what to add next?
-
Found a couple more bugs and have a few suggestions for additions.
Bugs First;
1) On the Inventory tab, Taser Dart Ammo has incorrect availability.
2) On the Inventory tab, Smartgun system, internal(weapon cost) has incorrect pricing. If you put the price in the Rating column the final price in the Cost column is (Rating x 2). It should be just the Rating (like clothing), which should be the same as the weapon cost that it's installed in (not weapon cost x 2).
3) On the Character Sheet tab, the Contacts section isn't pulling from the correct rows on the Contacts tab. The Contacts tab fillable fields start on row 2. On the Character Sheet tab the top row of the Contacts section starts pulling from row 4 of the Contacts tab.
4) On the Character Sheet tab, the first additional box on the Stun Damage track doesn't un-gray. The X goes away but the box stays dark gray.
Suggestions;
1) On the Augmentations tab, for Commlink Headware, have it pull the cost based on the rating and add it to the base cost. At the moment you have to purchase the actual commlink in the inventory section (and note it as internal) to account for the cost. The price for the internal commlink only pays for the extra components needed to make the commlink internal.
2) On the Character Sheet tab, expand the Notes field of the Contacts section to be at least as wide as the same field on the Contacts tab.
3) On the Character Sheet tab, if possible, make breakouts for some of the other major gear like vehicles, drones, cyberdecks, etc.
4) On the Character Sheet tab, auto fill the matrix initiative based off the cyberdeck setup and make seperate spots for cold-sim and hot-sim. I know the cyberdeck attributes are quickly changeable during play so maybe instead of putting in an actual number for the Data Processing part you could just put the formula in (for example; DP+(pull INTuition) + 3D6 for Cold-Sim mode).
5) Pretty minor one, the Revision History tab hasn't been kept up. Maybe just ditch that whole page and just put a Version Number on the Character Sheet tab.
That's all I've got for now. Great work. I hope this is the kind of stuff you were looking for.
EDIT: Woot! 69th reply!
-
thank u very much. that was the kind of stuff i was looking for. Thats the new version in which those bugs listed above should be fixed. I just did point 2 from the suggestion part; the others will take more time and consideration on how to implement those. If u have something more specific in mind, pm me.
-
When I download v9 or one before, I can only get that "read only". Any idea why? Or how I can get one that works in Excel? The one on the very first page works for me so I'm not sure why these don't.
-
Save it to a different location. It's probably saved to a protected subdirectory.
-
Hey, sorry to complain about something given freely.
I download V0.9 Clear and I get no options, no drop downs, no carry over of data. I would guess my Excel version is breaking the links?
I am on a Win7Ultimate and using Office Pro Plus 2010. When I try Libra Office it just dies on me. I save the spreadsheet to another locations, test again with no luck.
Or am I just not understanding what this spreadsheet should do?
Thanks again!
-
The sheet has been converted from Excel to Open Office Calc, in order to make it accessible to people who do not have Excel. Open Office is free for personal use and even though there is an option in Excel to open Open Office documents, things like Macros which are required for this sheet will not work.
tl,dr: You need Open Office for this to work. http://www.openoffice.org/ (http://www.openoffice.org/)
-
Or Libre Office, if you don't trust Apache :)
-
Thank you, Charasanya. You were correct. I was not able to make it work until I download Open Office (even though I had Office and Excel already). But, it works now!
On a side note, it appears that the skills Assessing, Astral Combat, and Arcana are pulling the wrong stats. It looks like they are are pulling from the Magic Stat currently.
One more question... is there a place that prints up the magic spells? I see where to select them, but I didn't see them on the Character Sheet. I'm guessing this is likely something that is still being worked on?
-
you'r right. still working on a spelltable and a vehicletable right now. but the bugs u have mentioned should be fixed now. here is the new version.
-
In this version I finally added a vehicle/drone table. I realized it with dropdowns. Tell me: What do you guys like better dropdowns or autofill per macro like in the rangeweapontable?
The advantage of autofill is, that its auto. But it has a downside too. You, the user, can't easily change the position and size of the table. On my side its far less work to implent those with dropdowns.
The best solution would be too autofill and autoadjust the sizes and positions of all the tables, but that's so much work, that i alone can't realize it. Tell me what u think.
-
I enjoy your changes (for one I can actually use it, since I have don't have MS Office) Here are a few of my thoughts:
Biotechnology skill is officially part of the biotech skill group, so when you get around to it if you can update that.
I have some house rules and we use the high life rules in the GM section; I have made the changes I needed to use it, but it would be nice if you could make some of the common house rules like initiation and altered priority sets, that would be really cool.
I tend to prefer dropdown because it shows you all the options, but the fill in the blank is nicer for when you want a value that isn't supported.
-
I tried it out yesterday, mapping out two characters I have been building and was very surprised that everything worked out pretty brilliantly.
Its no Chummer (*sigh*) but so far the best character editor for Shadowrun 5 that I have seen.
It would be nice however, if it was somehow possible for the mods to rename this thread to [SR5] Open Office: Calc Character Builder or if you would start a new one with the next major release, idiedtrying.
-
I noticed that on the character sheet view adept powers seem to be missing. Perhaps they could be added there somehow?
-
I think this is my new favorite tool, so thank you.
A couple of things I noticed when building my prime runner troll...
Troll armor (+1) is not included
Qualities with levels are not being adjusted
Bone Lacing adjustments are not included for Body
Unarmed Combat is not a melee option for character sheet
Ranged weapons are not dropped down enabled on character sheet similar to melee - would be a great enhancement.
Nuyen value is errored on character sheet
Thanks for all the effort.
-
Hey, thank you for your input. As far as I can tell, you are not allowing my marcos to run and therfore you get an error withe the nuyen value. Also the rangedweapontable automatically fills in the weapons bought in the inventory tab, if u use the macros. I explained how to use them in a previous post. As I understand it, bone lacing does only boost your Body value, when making a resist a damage test. I checked the values and it should be fine the way it is. I already added the Troll armor, but will release the new version, when i have more. I will add unarmed combat to the meeletable on the charactersheet and add quality scaling in the near future. I am still working on a spell/adeptpower table. Btw, if there are people under you with spreadsheet skills, who are willing to contribute to this project, let me know.
-
Are there any actual excel versions of this still? Open office version isn't playing well and I can't install open office on this laptop (work laptop)
-
no, not any I know off. I don't even have excel; i am sorry.
-
Just booted this puppy up and I'm impressed. This clearly took quite a bit of work, thanks!
-
Yeah this is my current favorite builder. Makes things sooooooo much easier.
-
thank you :) I like to hear that.
-
I really enjoy this spreadsheet and I appreciate all of the updates that you've done. Here are a few small things that I've noticed (and remember).
Augmentation database (D in database isn't capitalized)
D44 and D45 are transposed. As a result Dermal Plating doesn't show it's proper essence cost.
Gear Database
G238 - G240 should be "1" so the Skillsoft prices scale with rating.
Orthoskin's bonus to armor doesn't show on the character sheet.
Troll's racial armor doesn't show on the character sheet.
-
I just wanted to say. I am glad someone ran with my character builder and I like what you have been doing to the sheet idiedtrying.
-
This is awesome thanks for the hard work guys!
-
I took the first step. There is a web site called ZamZar. I used them to convert the ods file into an excel file. The result has some functionality, but it is still *broken*. If someone feels brave enough, it might make a better starting point that a full conversion from ods.
I had to zip the file because the xlsx size was 275K, and we have a 256K max. Here is the file:
-
So i just fixed a few minor bugs. Here is the new version. Sadly i'm kinda busy right now, so major updates gonna take a while. Btw thank u for all the good feedback.
Thats still an open office version.
-
Keep up the good work, still my favorite character builder :)
-
I'll have to load open office to see this I guess...
-
New version is up. I fixed markelphoenix and Chrona issues. Hopefully sometime this week, I can get a character sheet up and running.
I can't tell if anyone mentioned but the bladed weapons section is completely screwy, on the character sheet summary. You can't select anything there...
Also I'm having issues selecting a lifestyle. It just tells me to select one, even when I do- I get the feeling that's just a placeholder, though.
-
hey its sound like ur talking about my sheet here. its just works with open office. And u have to allow my macros. I alrdy explained how in one of my posts. Check also, if u got the newest version.
-
I think he means because the melee weapons section on the character sheet you have to use the right pull-down menu first, then the left one. It's opposite from everywhere else.
-
Hello im new here and to Shadowrun so im probably being blind here but in either one of the 2 versions i cannot find where the Autosofts for my drones
-
I think he means because the melee weapons section on the character sheet you have to use the right pull-down menu first, then the left one. It's opposite from everywhere else.
Why on earth is it inverted?
-
@Idiedtrying
There's some stuff I'd like that's not on here (the variable lifestyle modifiers for instance from 4th ed) but I'm not exactly excel savy am I right in thinking I just go to the relevant database and insert the name/value in there then change all the formulas to look a bit further e.g. A1-A9 instead of A1-A8? Another thing I can't figure out is the lifestyles. I go to inventory select category lifestyle and and in item it has some weird formula "Squatter(rat=l.style adjustment (1=norm))" and causes the nearby box to go from choose a lifestyle to roll 2d6 and insert the eyecount in the box which I assume is just mistyped but why are we rolling dice for lifestyle? On another note (yes I am a bit lifestyle focused right now) the lifestyle options don't seem to change any values at all. Would you mind explaining how this is meant to work what is the die count for please?
-
@senko
when u select a lifestyle the rating accounts for the lifestyle options u chose somwhere else. eg.: u chose a high lifestyle and want it to be extra secure. then u have to adejust the rating of this chosen lifgestyle to 1.2.
(rat=l.style adjustment (1=norm) means that u should select a rating of 1.0 for ur lifestyle, when u chose no additional options for it. The dice i want u to roll are for the extra starting money u get according to ur highest lifestyle.
-
Hmnmmm missed that entirely, goes off to look for die roll lifestyles . . . returning briefly to say thank you and i'll adjust that then.
Oh and I've noticed that the wealth calculation keeps returning a #value! result in the inventory calc which mucks everything else up for some reason.
EDIT
Ah that' for the selling of a permanently bought lifestyle if your renting month to month it doesn't apply from what I can see.
-
Hmm your better at this than me then I changed priorities to allow ne to select c, d and e twice (for atreet scum) now whenever I try to close libre office I get an error message about referring to $arg$61 or somethin and need to use task manager to shut it down. Although I'm hoping to force it to put lifestyles and lifestyle options in the fist few purchases as a linked drip down.
-
This is a great thing you're doing!
Cyber weapons such as the retractable spurs aren't available in the melee section of the character sheet. And in the spirit of automation, it would be nice to be able to link ammo with a certain weapon. The stats for the weapons are in the database.
Again, great job!!
-
Yep every time I close with Libre office I get . . .
BASIC runtime error.
Property or method not found: $(ARG1).
and need to use task manager to shut it down. Also it would be useful if the calculated values factored in a street/normal/prime karma along with resources (i.e. it automatically converted the Karma available to the correct value) instead of just a base 25.
-
OK guys, this sounds fantastic, but....the original dropbox link is down. Can anyone provide a new one?
-
Are you talking about the original post on the first page? If so their project was taken over by the one I'm talking about and the link for that is on page7/8 in idiedtrying's post and that was working as of a few days ago.
-
right, ok, found that, thanks.
-
Regarding Character Builder V0.9.3 idiedtrying.zip, I appreciate the work you've done and how responsive you've been to feedback. Here is some additional feedback.
Qualities: I can't seem to add rating 2 for High Pain Tolerance. In addition, it would be nice if adding High Pain Tolerance would adjust the -1, -2, etc modifiers in the damage boxes. for the appropriate rating level. It would be nice if non-Awakened characters were prohibited from taking Spirit Bane so they don't do so accidentally. There are way too many boxes for Qualities. By picking the cheapest qualities, I can only get to 6 each for positive and negative. There are 9 rows for qualities.
Post CharGen usage: The spreadsheet seems a bit difficult to use after CharGen. I don't see a spot on the "Character Sheet" sheet which lists Karma, Street Cred, Notoriety, Public Awareness, etc. Most importantly, it would be nice if a Karma spot was added, along with a spot to track total karma gained on the "Karma" sheet. This way the "Karma" can be used to continue to track the Karma gained and used. If the sheet is going to continue to be used, perhaps some of the negative quality spaces can be used for tracking karma. The positive spaces can stay in case people buy extras.
Adding the karma gained the "Karma" sheet would also require adding a way to differentiate between CharGen and Post-CharGen qualities for the gaining of positive ones, and a way to pay back the negative ones. This gets especially tricky with adding ratings. If this spirals out of control, then perhaps instead of editing the "Karma" sheet, it would be better to add a few new sheets for tracking Post-CharGen stats.
Stylistically, I don't like all the gray background. I like to print out sheets so the gray areas between the large boxes seem a little pointless. The yellow regions come up pretty light so that's less of an issue.
-
Hi there! New to the forum.
Where can I find this file Character Builder V0.9.3?
I cannot seems to find the correct link.
Thanks.
-
It's on page 7. It seems that only registered users can see the link.
-
Ok where is this link for the updated builder? I looked on page 7 and I see no link.
-
http://forums.shadowruntabletop.com/index.php?action=dlattach;topic=11723.0;attach=2878
Hope this will work. If not, go to page seven and look for a post by 'idietrying'. The builder is attached to the post.
-
Or try Chummer for 5th Edition...
http://forums.shadowruntabletop.com/index.php?topic=17200.0
-
So i just fixed a few minor bugs. Here is the new version. Sadly i'm kinda busy right now, so major updates gonna take a while. Btw thank u for all the good feedback.
Thats still an open office version.
Hey, Idietrying, I understand you don't keep the project up anymore, but could you share again the last version of it?