 Yet another Excel Based Character Genrator |
  |
 Aug 12 2013, 01:35 PM
Post
#26
|
|
|
Target  Group: Members Posts: 62 Joined: 27-April 10 Member No.: 18,510  |
Char Sheet, Magic Rating should reference D42 not C42?
ie.: =WENN('Character Creation'!F42="";'Character Creation'!D42;'Character Creation'!F42) instead of =WENN('Character Creation'!C42="-";"";'Character Creation'!C42) |
 |
 
|
|
Aug 12 2013, 01:43 PM
Post
#27
|
|
|
Moving Target Group: Members Posts: 109 Joined: 28-March 13 Member No.: 85,198 |
QUOTE (Korwin @ Aug 12 2013, 03:35 PM)  Char Sheet, Magic Rating should reference D42 not C42? ie.: =WENN('Character Creation'!F42="";'Character Creation'!D42;'Character Creation'!F42) instead of =WENN('Character Creation'!C42="-";"";'Character Creation'!C42) Please give me a specific location (which sheet, which cell) for the formula and whether you're referring to the cell content or data validation as I can't even locate the section you're talking about. |
|
|
|
|
Aug 12 2013, 01:46 PM
Post
#28
|
|
|
Target Group: Members Posts: 62 Joined: 27-April 10 Member No.: 18,510 |
C33 on 'CharacterSheet'
|
|
|
|
|
Aug 12 2013, 02:08 PM
Post
#29
|
|
|
Moving Target Group: Members Posts: 109 Joined: 28-March 13 Member No.: 85,198 |
QUOTE (Korwin @ Aug 12 2013, 03:46 PM) C33 on 'CharacterSheet' There is no sheet titled 'CharacterSheet' in my work, C33 on the 'Character Creation - USE THIS!' sheet is a drop-down box, its data validation formula is not the one you're referring to. What file are you looking at to begin with? |
|
|
|
|
Aug 12 2013, 02:45 PM
Post
#30
|
|
|
Moving Target Group: Members Posts: 356 Joined: 3-April 10 Member No.: 18,409 |
I chose ECDBA for my priorities, Human for metatype, and Adept for subtype, and my Karma went to -10. Is it supposed to do that? It looked like because of my natural minimum 2 to Edge, it was deducting Karma for it (35 points worth?)
|
|
|
|
|
Aug 12 2013, 02:51 PM
Post
#31
|
|
|
Moving Target Group: Members Posts: 109 Joined: 28-March 13 Member No.: 85,198 |
QUOTE (Eratosthenes @ Aug 12 2013, 04:45 PM) I chose ECDBA for my priorities, Human for metatype, and Adept for subtype, and my Karma went to -10. Is it supposed to do that? It looked like because of my natural minimum 2 to Edge, it was deducting Karma for it (35 points worth?) Check the white, Karma column next to edge. I've unintentionally left number 2 typed into that cell in the latest release. |
|
|
|
|
Aug 12 2013, 02:53 PM
Post
#32
|
|
|
Moving Target Group: Members Posts: 356 Joined: 3-April 10 Member No.: 18,409 |
QUOTE (Flaser @ Aug 12 2013, 10:51 AM) Check the white, Karma column next to edge. I've unintentionally left number 2 typed into that cell in the latest release. I was just about to edit my post: you are correct. Thanks! |
|
|
|
|
Aug 13 2013, 03:22 PM
Post
#33
|
|
|
Target Group: Members Posts: 17 Joined: 28-June 09 From: Kinston, NC/Lynchburg, VA Member No.: 17,331 |
Excellent work so far. Kudos!
I assume that the skill section is on the to-do list as my download didn't have one. |
|
|
|
|
Aug 20 2013, 10:48 AM
Post
#34
|
|
|
Target Group: Members Posts: 50 Joined: 31-July 13 From: Manchester Member No.: 134,960 |
QUOTE (Darklordofbunnies @ Aug 13 2013, 04:22 PM) Excellent work so far. Kudos! I assume that the skill section is on the to-do list as my download didn't have one. I second this! You still working on it? (IMG:style_emoticons/default/smile.gif) I only ask cos none of your links are working for me (IMG:style_emoticons/default/frown.gif) |
|
|
|
|
Aug 20 2013, 11:59 AM
Post
#35
|
|
|
Neophyte Runner Group: Members Posts: 2,236 Joined: 27-July 10 Member No.: 18,860 |
Great sheet. I am just too stupid to figure out how the qualities work. I can select them. They give me costs but they are not substracted from the karma...
(Works now fine. I guess I had some accident in excel after reloading the version it worked...) (Could you edit the first post and but the most advanced versions there?) |
|
|
|
|
Aug 29 2013, 06:21 AM
Post
#36
|
|
|
Moving Target Group: Dumpshocked Posts: 681 Joined: 23-March 10 From: Japan Member No.: 18,343 |
So far this is looking really good. I only have 1 suggestion so far... Can you make the Augmentations section a bit larger? There are a lot of low cost, low essence items that can be squeezed in for Resources-A characters.
|
|
|
|
|
Sep 10 2013, 12:56 PM
Post
#37
|
|
|
Moving Target Group: Members Posts: 109 Joined: 28-March 13 Member No.: 85,198 |
Due Real Life™ issues, I was away for a while, but I finally had some time to continue development.
Here is version v0.10, with Skill support: https://docs.google.com/file/d/0B7KaFhodT908S2t6ZUFNMGpKZDA |
|
|
|
|
Sep 11 2013, 03:05 PM
Post
#38
|
|
|
Moving Target Group: Members Posts: 109 Joined: 28-March 13 Member No.: 85,198 |
Here's a new version, at user request I've expanded the Augmentation list to 25 items... something that turned out to require a lot more changes than I initially assumed. I *tried* making it, just "drag & dropable" but unfortunately the spreadsheet is smeared over too many sheets to facilitate this. (At least, I've made almost every range used in the calculation, named & dynamically expanding).
Version 0.11: https://docs.google.com/file/d/0B7KaFhodT908N0FwS19IT01Bclk |
|
|
|
|
Jan 1 2014, 10:27 PM
Post
#39
|
|
|
Moving Target Group: Members Posts: 313 Joined: 26-February 02 From: UCAS Member No.: 1,015 |
Disregard, updating LibreOffice resolved.
|
|
|
|
|
|
Lo-Fi Version | Time is now: 25th November 2024 - 03:40 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.