Character Helper, really rough |
Character Helper, really rough |
Sep 8 2005, 10:04 PM
Post
#1
|
|
Why oh why didn't I take the blue pill. Group: Dumpshocked Posts: 6,545 Joined: 26-February 02 From: Gloomy Boise Idaho Member No.: 2,006 |
Ok, in the spirit of trying to understand the game better, I tried to make a character helper(like my rigger tool) Its in excel so you need it to use it. Feel free to mod it, change it, do whatever to it. Just don't tell me it sucks or you could do better. I know it sucks, and if you can do a better job then do it.
This is not a character generator, it is a helper. It keeps track of your bp and such. You still have to know what the stuff means. Oh yeah, because I don't know how to tell excel to add 25 pts instead of 10 for the last attribute point it breaks if you get a 6. Your going to have to add the 15 points manually. I'll keep working on it, but if anyone improves it, please post it here so I can see what you did. Currently there is a sample mage I am working on, name is Sundown. Shadow Character Helper (beta) in Excel |
|
|
Sep 8 2005, 10:25 PM
Post
#2
|
|
Running Target Group: Members Posts: 1,251 Joined: 11-September 04 From: GA Member No.: 6,651 |
In cell G20 put this formula:
=IF(C20=6,15+SUM(C20)*10-(10),SUM(C20)*10-(10)) then you can 'fill' the formula to the other stats to populate those fields. Lastly, have your total add G11:G18 and have another total for the other attributes. (Since they aren't capped at 200BP) Thanks for making the helper sheet, Chummer! :-) |
|
|
Sep 8 2005, 10:45 PM
Post
#3
|
|
Why oh why didn't I take the blue pill. Group: Dumpshocked Posts: 6,545 Joined: 26-February 02 From: Gloomy Boise Idaho Member No.: 2,006 |
Wow, you can do that? Awesome.
|
|
|
Sep 8 2005, 10:49 PM
Post
#4
|
|
Running Target Group: Members Posts: 1,498 Joined: 4-August 05 From: ADL Member No.: 7,534 |
|
|
|
Sep 8 2005, 11:11 PM
Post
#5
|
|
Moving Target Group: Members Posts: 119 Joined: 17-August 05 Member No.: 7,566 |
You seem to be helpful, Serbitar. But why do you post your character generator in every thread. :D
Just kidding. |
|
|
Sep 8 2005, 11:20 PM
Post
#6
|
|
Running Target Group: Members Posts: 1,498 Joined: 4-August 05 From: ADL Member No.: 7,534 |
Damn, Ive been caught.
|
|
|
Sep 8 2005, 11:23 PM
Post
#7
|
|
Moving Target Group: Members Posts: 119 Joined: 17-August 05 Member No.: 7,566 |
Is it part of your plan for world domination. :eek:
|
|
|
Sep 8 2005, 11:29 PM
Post
#8
|
|
Running Target Group: Members Posts: 1,498 Joined: 4-August 05 From: ADL Member No.: 7,534 |
SR4 first, and then the rest of the world.
Muahahahah, bow down mortal ! *turns into a Golden Dragon and flies away* |
|
|
Sep 8 2005, 11:45 PM
Post
#9
|
|
Why oh why didn't I take the blue pill. Group: Dumpshocked Posts: 6,545 Joined: 26-February 02 From: Gloomy Boise Idaho Member No.: 2,006 |
Okay, Autarkis did a fantastic job on a much better char gen then my piece of crap. Unfortunately he had no where to host it. So I am going to host it for him :)
Enjoy his awesome work. SR$ char gen |
|
|
Sep 8 2005, 11:56 PM
Post
#10
|
|
Dragon Group: Members Posts: 4,718 Joined: 14-September 02 Member No.: 3,263 |
Technomancer is free! :cyber:
EDIT: Other than that and that i can't figure out how to make skill groups, cool. |
|
|
Sep 9 2005, 12:03 AM
Post
#11
|
|
Moving Target Group: Members Posts: 119 Joined: 17-August 05 Member No.: 7,566 |
Look under Edges (I know...I should have used "Positive Qualities") for the Technomancer BP (same for Adept, Mage, and Mystic Adapt.)
And the Skill Groups are listed alphabetically in the drop down, then followed by Skills (I couldn't figure a really good way to toggle, thats why there is the column that add SK or GS. So the first Skill Group is Athletics, but if you scroll down more, you will see Gymnastics lower in the list. :nuyen: |
|
|
Sep 9 2005, 12:08 AM
Post
#12
|
|
Dragon Group: Members Posts: 4,718 Joined: 14-September 02 Member No.: 3,263 |
I looked there first because i didn't notice it at the top at first. It's free down there too. Adept and Mage aren't there, but then again i like them being at the top in a separate dropdown because they are mutually exclusive from each other.
Ok, found the SG. I think it would be cool if they were marked SG at the front so they were sorted out. P.S. Yes you are a baaad boy using SR3 Edge & Flaw terminology. :P |
|
|
Sep 9 2005, 12:15 AM
Post
#13
|
|
Moving Target Group: Members Posts: 119 Joined: 17-August 05 Member No.: 7,566 |
I know. Well...I sent this to my gaming team, so once I hear there feedback from what is broken, I will make fixes (including the Technomancer BPs).
And its habit...like Deckers...DECKERS! |
|
|
Sep 9 2005, 01:10 AM
Post
#14
|
|
Runner Group: Members Posts: 2,598 Joined: 15-March 03 From: Hong Kong Member No.: 4,253 |
For max stats, the way I did it was make a table by race of max stat, and then vlookup the race to get the max stat for a particular attribute.
Then the formula for stat BP costs is IF(non modified stat<1,"Stat too low",IF(non modified stat>max stat,"Stat Too High",IF(non modified stat<>max stat,(non modified stat-1)*10,(non modified stat-2)*10+25))) Also, it's worth tracking the skills actually in the groups, and zeroing out the costs of those skills, so you don't end up paying points for a skill that you also have in a skill group. It's also a useful addition to track the linked stat of every skill, and calculate the pools for each skill. |
|
|
Sep 9 2005, 08:30 AM
Post
#15
|
|
Target Group: Members Posts: 52 Joined: 16-August 05 From: Stuttgart, Germany Member No.: 7,559 |
That Chargen is very nice work indeed, I just realized (pretty quick) that I had to adapt some pieces of the cyberware section though.
Recommendations: Make Capacity a seperate collum as you need it for "vanilla" Cyberware in Limbs, too. Example: Commlink, Essence .2 or Capacity 2 Move the Cybereye / ear Section over to the Limbs as you can work better with Capacity then, too. I am trying to implement this at the moment, I am not sure if my Excel uberness is sufficient though, specially as I should be learning :-/ @ Crusher Bob: I really should find the time to finish the Smuggler v.2 and Gunslinger Adept v.2, too :-( Too much work, too little time ... *volunteers for Sleep Regulator* |
|
|
Sep 9 2005, 09:00 AM
Post
#16
|
|||||
Dragon Group: Members Posts: 4,718 Joined: 14-September 02 Member No.: 3,263 |
Maybe that should be visually flagged instead? It is illegal to have a skill group + a skill from the group at different levels. Some sort of visual clue seems a good idea. It would help incase you forgot you had the group for the skill. Even if you actually allow the skill and the skill group to be both there as a shorthand notation, that is calculating the BP wrong, when you are representing a skill group that was broken up post-chargen. EDIT: Or do you mean zero out the cost of the points of the skill at and below that of the group? Not sure that is nessasary since it is already illegal for chargen, and total accuracy in BP doesn't mean nearly as much post-chargen.
Very much agreed. That'll take a bit of layout work though on top of the backend calculations, and he's kinda wide on the page already. Maybe making up the room by splitting the C column and shortening the Active Skill name. The longest name Exotic Ranged Weapon has lots of room to spare. Even if in the future, Shadow, if you allow overriding the Skill name text enter the weapon name you could instead change that choice to the abbreviated Exotic Ranged (weapon) where the user would replace 'weapon' with the specific name. That should keep it short enough to fit in a similar space. P.S. Given the height vs. width of the page there should be more than enough room to add a few extra Skill slots. There are lots of active skills, and you might see a lot used for high BP chargens (for say NPCs or a PC you are trying to mesh with an existing powerful team). |
||||
|
|||||
Sep 13 2005, 01:30 PM
Post
#17
|
|
Target Group: Members Posts: 49 Joined: 26-February 02 Member No.: 1,144 |
Maybe you can make an extra sheet for bioware, makes it easier to calculate, which essence-cost is halved.
otherwise its a good helper |
|
|
Sep 13 2005, 01:32 PM
Post
#18
|
|||
Dragon Group: Members Posts: 4,718 Joined: 14-September 02 Member No.: 3,263 |
I thought the halving depended on which you had more of? |
||
|
|||
Sep 13 2005, 03:11 PM
Post
#19
|
|
Target Group: Members Posts: 49 Joined: 26-February 02 Member No.: 1,144 |
Yes, this is how it works:
I copied the Cyberwaresheet renamed it Bioware deleted Bioware!B23 to Bioware!F23 edit Race,Attributes, and Skills!J14 to =If(Cyberware!D24>Bioware!D24;6-Cyberware!D24-(Bioware!D24/2);6-Bioware!D24-(Cyberware!D24/2)) that will calculate your Essence correct (and you have more space for your ware ;-)) but i couldnt edit the dropdown menus to only show Bioware on the Bioware Tab (@Autarkis: how did you make those menus? They dont seem to be Combo Boxes, no Format Control possible) |
|
|
Sep 13 2005, 03:16 PM
Post
#20
|
|
Moving Target Group: Members Posts: 119 Joined: 17-August 05 Member No.: 7,566 |
It is under Data=> Validation. Then under Settings, set Allow: to List and in the Data section type in "=Data_List".
Now, Data_List is defined by highlighting a column of information you want to put in there and once this section is highlighted right above A1 and to the left of the function box is a blank box (should read R1C1 if you are clicked on A1). Once you highlight this section, type the name of the data list (and use "_" for spaces) and there ya go. |
|
|
Sep 13 2005, 03:21 PM
Post
#21
|
|
Dragon Group: Members Posts: 4,718 Joined: 14-September 02 Member No.: 3,263 |
BTW i'm trying to figure out how to view "Sheet1" where all the list data is stored. It is somehow hidden (or the data cached?) so i can't get at that sheet, and i don't remember how to unhide hidden sheets (hidden workbooks no problem).
|
|
|
Sep 13 2005, 03:40 PM
Post
#22
|
|
Target Group: Members Posts: 49 Joined: 26-February 02 Member No.: 1,144 |
Format->Sheet->Unhide
that Validate trick worked btw, thx |
|
|
Sep 14 2005, 04:30 PM
Post
#23
|
|||
Moving Target Group: Members Posts: 934 Joined: 26-August 05 From: Earth - Europe - AGS - Norddeutscher Bund - Hannover Member No.: 7,624 |
Indeed, he did. But can anyone tell me, what kind of a language 'Germanic" is? :eek: |
||
|
|||
Sep 14 2005, 04:45 PM
Post
#24
|
|
Dragon Group: Members Posts: 4,718 Joined: 14-September 02 Member No.: 3,263 |
I believe that is a group that includes languages like Norwegian, Danish, German of course, i think Dutch. Basically all the languages that evolved primarily from Germanic, except for English (making some sense since English has a large percentage of words from other sources).
I believe language groups started being used as Language Skills to reduce the dilution of Lang Skill points over the enormous number of languages. P.S. Not sure if Yiddish is in there or not, since a strong exterior influence too. |
|
|
Sep 14 2005, 10:13 PM
Post
#25
|
|||
Target Group: Members Posts: 34 Joined: 10-September 05 Member No.: 7,725 |
Except that is completely unrealistic, yet still doesn't have any real impact on gameplay. Plus it's highly exploitable. I can see the language munchkins now... GM: What's your native language again? Munch: Indo-European GM: Huh? Munch: You know, Persian, German, Italian, Albanian. It's a language group. We are using language groups, right? |
||
|
|||
Lo-Fi Version | Time is now: 23rd April 2024 - 12:48 PM |
Topps, Inc has sole ownership of the names, logo, artwork, marks, photographs, sounds, audio, video and/or any proprietary material used in connection with the game Shadowrun. Topps, Inc has granted permission to the Dumpshock Forums to use such names, logos, artwork, marks and/or any proprietary materials for promotional and informational purposes on its website but does not endorse, and is not affiliated with the Dumpshock Forums in any official capacity whatsoever.