 SR4Chargen excell sheet updated for augmentation, Why yes, I have been gone for 18 months |
 Nov 20 2007, 11:59 PM
Post
#1
|
|||
|
Moving Target  Group: Members Posts: 715 Joined: 4-September 05 From: Metaplane GEPLK136 (The one with the lizards. You remember the lizards, don't you?) Member No.: 7,684  |
Sorry that I disappeared so abruptly 18 months ago. Anyway, I've gotten ahold of Augmentation, and since it allowed me to do some of my old character concepts justice, I've been inspired to update the old character generating excel file that I used regularly. This is the one created by Autarkis and updated by Blakkie through Street Magic. I've added pretty much everything in Augmentation at this point, but I certainly won't guarantee it's error-free! All files are hosted on Mediafire, so you'll have to view some adds to get them. Feel free to mirror these elsewhere if you like! *New Versions Available as of 12/05/2007 (draft 7)* The update notes are a bit further down the thread. For those of you who have the latest software (Excel 2007, can open .rar files), use this link: SR4Chargen (xlsx) For those of you with older versions of Excel (and who still use zip), use this link: SR4Chargen (xls) (not guaranteed to even be as error-free as the xlsx file) Previous Versions still available in the spoiler: [ Spoiler ] Lastly, just in case anyone was still interested in my dice roller after all this time, here's a link for that too: Die File Notes:
Thanks again to Autakris and Blakkie for their great work that I merely built on (or went mess'n up, more accurately.) See you all in another 18 months (just kidding, let me know if there are any glaring errors in the sheet that I've missed; I just did another bunch of updates that I haven't checked very closely yet.) |
||
 |
 
|
||
 |
Replies
(1 - 99)
|
Nov 21 2007, 12:09 AM
Post
#2
|
|
|
Bushido Cowgirl Group: Members Posts: 5,782 Joined: 8-July 05 From: On the Double K Ranch a half day's ride out of Phlogiston Flats Member No.: 7,490 |
..I'll have to download the update when I get home. :grinbig:
|
|
|
|
|
Nov 21 2007, 12:13 AM
Post
#3
|
|
|
Runner Group: Members Posts: 2,650 Joined: 21-July 07 Member No.: 12,328 |
Sweet.
|
|
|
|
|
Nov 21 2007, 04:06 AM
Post
#4
|
|
|
Running Target Group: Members Posts: 1,180 Joined: 22-January 07 From: Rochester, NY Member No.: 10,737 |
:notworthy:
|
|
|
|
|
Nov 22 2007, 09:52 AM
Post
#5
|
|
|
Running Target Group: Members Posts: 1,269 Joined: 18-September 06 Member No.: 9,421 |
Huh, when I try to download it gives me 0 kb .zip and .rar files.
Chris |
|
|
|
|
Nov 24 2007, 11:27 PM
Post
#6
|
|
|
Dragon Group: Members Posts: 4,718 Joined: 14-September 02 Member No.: 3,263 |
I approve! Well I will when I get a chance to look through it. :)
Thanks for doing this Feshy. I might even tweak it a bit further to address the parts that have been left out if I can figure out how to easily add a good interface for them. BTW I don't have access to the website where the old version (linked in my sig) is kept. But a quick email to the owner of that website would likely get the new version posted in it's place. EDIT: Crap, it looks like he's reorganized his page a bit. But I can't edit my sig because the board is busted. Here is the new link: http://pavao.org/shadowrun/generators/ You'll have to scroll down to the bottom of the page manually because he removed the # labels from the HTML. Also when you send it make sure to ask him to add your name to the description. 8) |
|
|
|
|
Nov 25 2007, 06:48 AM
Post
#7
|
|
|
Moving Target Group: Members Posts: 715 Joined: 4-September 05 From: Metaplane GEPLK136 (The one with the lizards. You remember the lizards, don't you?) Member No.: 7,684 |
I just thought I'd note that currently, the sheet adds essence cost multipliers together, rather than multiplying them. For instance, Second-Hand Alphaware would have a multiplier of 1 (.2 - .2) rather than .96 (1.2 * .8). Apparently, Augmentation has an example directly contradicting this, so I may change the way this is handled in the future. Also, I haven't actually added "second-hand alphaware" as a grade choice yet...
|
|
|
|
|
Nov 25 2007, 01:09 PM
Post
#8
|
|
|
Target Group: Members Posts: 87 Joined: 11-September 07 From: Saeder-Krupp Rhine-Ruhr Regional HQ Member No.: 13,215 |
I noticed that you can't clear the drop-down list fields other than by selecting a blank line -- backspacing doesn't work, but would be so much more convenient. Do you think you could change that?
|
|
|
|
|
Nov 25 2007, 09:47 PM
Post
#9
|
|
|
Running Target Group: Members Posts: 1,269 Joined: 18-September 06 Member No.: 9,421 |
Would someone mind PMing me these files? For some reason whenever I download from MediaFire I get a 0kb file that is completely useless. It is quite annoying and I cannot figure out why. Also, suggestions to fix this would be nice.
Thanks, Chris |
|
|
|
|
Nov 25 2007, 10:40 PM
Post
#10
|
|
|
Moving Target Group: Members Posts: 715 Joined: 4-September 05 From: Metaplane GEPLK136 (The one with the lizards. You remember the lizards, don't you?) Member No.: 7,684 |
It doesn't look like you can send files via PM, unfortunately. If you PM me an e-mail address, I'd be happy to send it to you. I'll do the same for anyone else having trouble with Mediafire as well.
|
|
|
|
|
Nov 26 2007, 06:22 PM
Post
#11
|
|
|
Target Group: Members Posts: 10 Joined: 26-February 02 Member No.: 2,053 |
Heyo Fleshy,
Quick question. Some of the genetic customizations seemed to have particularly high avail ratings on your sheet. Genetic Optimization for one sticks in my head as showing as 20 on the excel sheet but when I checked the hardcopy it was only listed as a 10. Was there an errata I missed somewhere that had adjusted avail ratings or were you using a house rule for the availability? |
|
|
|
|
Nov 26 2007, 06:56 PM
Post
#12
|
|
|
Moving Target Group: Members Posts: 715 Joined: 4-September 05 From: Metaplane GEPLK136 (The one with the lizards. You remember the lizards, don't you?) Member No.: 7,684 |
Mr. Black:
I looked at the phenotype adjustment section, and looked at what I typed, and it took me a few minutes to figure out just what happened. Apparently, when I typed them in, my fingers where one key off -- thus, 12 became 23, and 10 became 20 (because the zero was with the other hand...) Good catch! If you want to fix it yourself, you can unhide and unprotect the "ware list" sheet (no password for the protection) and change it. I'll be uploading a revised sheet with the few other errors I've found probably in the near future, too. Thanks for finding that! |
|
|
|
|
Nov 26 2007, 07:16 PM
Post
#13
|
|
|
Running Target Group: Members Posts: 1,269 Joined: 18-September 06 Member No.: 9,421 |
I managed to get a copy from bibliophile and it looks really good. Thanks.
Chris |
|
|
|
|
Nov 26 2007, 07:17 PM
Post
#14
|
|
|
Target Group: Members Posts: 10 Joined: 26-February 02 Member No.: 2,053 |
Will do Fleshy.
Just wanted to make certain I hadn't missed some offical errata on that. Thanks for the great work on the sheet. |
|
|
|
|
Nov 26 2007, 09:49 PM
Post
#15
|
|||||
|
Moving Target Group: Members Posts: 715 Joined: 4-September 05 From: Metaplane GEPLK136 (The one with the lizards. You remember the lizards, don't you?) Member No.: 7,684 |
As far as I know, there is no official errata on Augmentation yet. If there are, please send them my way and I'll incorporate them! I've updated the files to a new draft (edited the first post with the links). There's a few bug fixes (like the one pointed out by Mr. Black), but the biggest change is just that I've changed the way having more than one essence reducing effect works. According to an example in Augmentation, it should be handled via multiplication -- that is, if you have Biocompatability, and install Alphaware, the total reduction should be:
However, in most games (and there's been some hint that SR4 was supposed to do this?), they are handled by addition first. So instead you'd get:
The difference is pretty small, really, but I wanted to allow people to do it both ways. Also, I kind of hate that by the default rules, Second-Hand alpha is so great. You get -1 availability, and it costs 4% less essence, with no real drawbacks. Using the addition rules, it costs the same essence at least. |
||||
|
|
|
||||
|
Nov 26 2007, 10:22 PM
Post
#16
|
|||||
|
Immoral Elf Group: Members Posts: 15,247 Joined: 29-March 02 From: Grimy Pete's Bar & Laundromat Member No.: 2,486 |
Synner has stated that this is the correct way to do it. You add all the modifiers together before the actual equation. And no, there is not yet any Errata for Augmentation. |
||||
|
|
|
||||
|
Nov 26 2007, 10:24 PM
Post
#17
|
|||
|
Immoral Elf Group: Members Posts: 15,247 Joined: 29-March 02 From: Grimy Pete's Bar & Laundromat Member No.: 2,486 |
Second hand augmentation uses up more Essence, not less. |
||
|
|
|
||
|
Nov 26 2007, 10:48 PM
Post
#18
|
|
|
Moving Target Group: Members Posts: 715 Joined: 4-September 05 From: Metaplane GEPLK136 (The one with the lizards. You remember the lizards, don't you?) Member No.: 7,684 |
Second-Hand Standard cyberware uses up more essence. But according to Augmentation, Second-Hand is also available in Alphaware.
The example given in the book (on page 32) that specifically includes Second-Hand Alphaware multiplies the two essence costs of 1.2 and 0.8, and gets < 1. This is why I included both possibilities in the spreadsheet. Synner says they should be added, but as printed, the book says multiply. Once there is an official errata, we can probably remove the option (or at least switch which one is the house rule), but for now, I figure it's best to let people do both. |
|
|
|
|
Nov 26 2007, 11:05 PM
Post
#19
|
|
|
Immoral Elf Group: Members Posts: 15,247 Joined: 29-March 02 From: Grimy Pete's Bar & Laundromat Member No.: 2,486 |
Meh. The example on page 32 is wrong, and Nicola's Essence cost for that used Muscle Replacement (why?) should be 2. :D
|
|
|
|
|
Nov 26 2007, 11:29 PM
Post
#20
|
|||
|
Moving Target Group: Members Posts: 715 Joined: 4-September 05 From: Metaplane GEPLK136 (The one with the lizards. You remember the lizards, don't you?) Member No.: 7,684 |
For what it's worth, I agree. But then, if everyone agreed with me all the time, the world would be a very different place! (And seriously, who uses muscle replacement?) |
||
|
|
|
||
|
Nov 27 2007, 07:17 AM
Post
#21
|
|
|
Moving Target Group: Members Posts: 249 Joined: 2-November 06 From: Bozeman, MT Member No.: 9,762 |
I use muscle replacement. One of the characters I am playing here on the forms is an ex ganger from Caracas who had very limited access to both 'ware and nuyen and therefore has muscle replacement 1 as his only combat related cyber. The sprawl ganger archetype also uses muscle replacement. (I drew heavily from that when making my character.)
Also: great sheet, I'm a big fan. I'd also like (if possible) to have future releases continue to be Open Office compatible. My excel free trail ran out recently so I can only use the pull down options to edit fields in excel :( , but OO works like a champ. |
|
|
|
|
Nov 27 2007, 05:39 PM
Post
#22
|
|
|
Running Target Group: Members Posts: 1,180 Joined: 22-January 07 From: Rochester, NY Member No.: 10,737 |
Checking: Feshy, is there a maximum number of downloads from MediaFire? Because I just directed a very large number of people in it's direction.
|
|
|
|
|
Nov 27 2007, 06:10 PM
Post
#23
|
|
|
Running Target Group: Members Posts: 1,269 Joined: 18-September 06 Member No.: 9,421 |
None of their stuff when you join mentions anything of the sort, they seem to be a "more downloads the better" type site.
Chris |
|
|
|
|
Nov 27 2007, 11:14 PM
Post
#24
|
|||
|
Moving Target Group: Members Posts: 715 Joined: 4-September 05 From: Metaplane GEPLK136 (The one with the lizards. You remember the lizards, don't you?) Member No.: 7,684 |
They're add supported, which in this case is good because if they make add money on every download, the higher volume is actually good for them. So download away! I'm just glad people are finding this useful. |
||
|
|
|
||
|
Nov 29 2007, 11:07 PM
Post
#25
|
|
|
Moving Target Group: Members Posts: 249 Joined: 2-November 06 From: Bozeman, MT Member No.: 9,762 |
I'm getting a wierd error with draft 4. On the Cyberware_Bioware tab, all the values in the Cybr Ess. column are twice what they should be (according to the BBB, I don't have Aug). Note: bioware essence costs are unaffected. This occurs seemingly regardless of Grade.
An example: Datajack: 0.2, Wired III: 10 Hope this is just one error on an otherwise magnificent sheet. Edit: alpha grade only takes off 10% of the listed essence cost (the normal amount it should, not twice the amount it should) e.g. Alpha eye recording unit: 0.18 ess, 4,000 nuyen. |
|
|
|
|
Nov 30 2007, 03:13 AM
Post
#26
|
|
|
Runner Group: Members Posts: 2,650 Joined: 21-July 07 Member No.: 12,328 |
No wonder my essence costs seemed high!
A temp fix for everyone until someone works out the underlying cause. Change the formula in row E to =IF($A6="","",IF(VLOOKUP($A6,Complete_Ware_Table,2,FALSE)<>"Cyber",0,(VLOOKUP($A6,Complete_Ware_Table,3,FALSE))*(IF($C6="",1,(VLOOKUP($C6,Grade2,2,FALSE)))+Cyber_Essence_Reduction))*(IF($B6="",1,IF(ISERROR(FIND("E",VLOOKUP($A6,Complete_Ware_Table,5,FALSE))),$B6,1)))/2) thats a total bodgy fix until someone can figure out the problem. |
|
|
|
|
Nov 30 2007, 05:27 AM
Post
#27
|
|
|
Moving Target Group: Members Posts: 249 Joined: 2-November 06 From: Bozeman, MT Member No.: 9,762 |
I think your posted formula will only work for row 6. Also I don't think it will solve the problem with the alphaware costs. (and beta- and delta-). I think the formula fix should be to subtract the original value of the essence cost (the standard cost) of course if you knew that you could just calculate the essence costs based off of that....
Note: Sensitive system (and I am assuming the other essence affecting qualities from Augmentation) doubles the essence cost as it should, but on its own line in the totaling section of the spreadsheet. (I therefore suspect that the glitch isn't quality related) |
|
|
|
|
Nov 30 2007, 12:20 PM
Post
#28
|
|
|
Runner Group: Members Posts: 2,650 Joined: 21-July 07 Member No.: 12,328 |
Oh yeah, change the first row of col E to that, then use the excel 'formula drag' to copy it down the entire Col, that will fix the entire Col by incrementing the values as required.
Also, it correctly does alpha/beta/delta costs. (try it!) It's just a not very elegant way of doing it, but it does behave correctly in the cases I tested. |
|
|
|
|
Nov 30 2007, 05:16 PM
Post
#29
|
|
|
Moving Target Group: Members Posts: 715 Joined: 4-September 05 From: Metaplane GEPLK136 (The one with the lizards. You remember the lizards, don't you?) Member No.: 7,684 |
Doh! Somehow an old version of the formula got put in there; the one that doesn't properly handle the addition vs multiplication issue.
I'll have it fixed and uploaded in a few minutes. Sorry about that, I know I tested it before I sent it, so I'm not sure how I missed that. It's okay, I know what the formula should be, because I already wrote it once and had it working. Must have accidentally grabbed an older copy during one of the updates. As a bonus, I've got some experimental karma calculations on the sheet now too! |
|
|
|
|
Nov 30 2007, 05:28 PM
Post
#30
|
|
|
Moving Target Group: Members Posts: 715 Joined: 4-September 05 From: Metaplane GEPLK136 (The one with the lizards. You remember the lizards, don't you?) Member No.: 7,684 |
It should be fixed now. Sorry to all those of you who downloaded it with such a big bug. I know I checked the results of that formula at some point before zipping it up and posting it, but I must have made some change to it afterwards to revert it.
I guess my quality control process needs a bit of work. But then, with a toddler and an infant, both of whom like to "help" daddy type, that's not a surprise... New version is linked in the first post, as always. |
|
|
|
|
Nov 30 2007, 05:43 PM
Post
#31
|
|
|
Genuine Artificial Intelligence Group: Members Posts: 4,019 Joined: 12-June 03 Member No.: 4,715 |
The zip file for older versions of excel contains an .xlsx file, not an .xls file.
|
|
|
|
|
Nov 30 2007, 06:45 PM
Post
#32
|
|||
|
Moving Target Group: Members Posts: 715 Joined: 4-September 05 From: Metaplane GEPLK136 (The one with the lizards. You remember the lizards, don't you?) Member No.: 7,684 |
Some days I wonder which gods I cheesed off in my sleep. Fixed now, sorry about that. |
||
|
|
|
||
|
Dec 3 2007, 05:00 PM
Post
#33
|
|
|
Moving Target Group: Members Posts: 715 Joined: 4-September 05 From: Metaplane GEPLK136 (The one with the lizards. You remember the lizards, don't you?) Member No.: 7,684 |
What a surprise, I've found another error in the sheet that's still a holdover from draft 5. The transgenic costs are twice what they should be, unless "Multipliers are handled additively" is checked.
Also, somehow the draft that got saved was one where I was only halfway through the karma cost section, and it's blank. I've got a fixed sheet, I'll upload it again soon. Anyone else have any bugs to chime in about, so I can fix those too before I do? |
|
|
|
|
Dec 3 2007, 06:12 PM
Post
#34
|
|
|
Target Group: Members Posts: 87 Joined: 11-September 07 From: Saeder-Krupp Rhine-Ruhr Regional HQ Member No.: 13,215 |
Allowing to delete cyberwear by backspacing when you want to clear up the sheet would be nice. :)
|
|
|
|
|
Dec 3 2007, 10:56 PM
Post
#35
|
|||
|
Moving Target Group: Members Posts: 715 Joined: 4-September 05 From: Metaplane GEPLK136 (The one with the lizards. You remember the lizards, don't you?) Member No.: 7,684 |
Done! Also, fixed the error I previously mentioned, and fixed the karma cost section to work. Hopefully, I didn't accidentally revert anything else in the sheet this time! Draft 6 is linked in the first post, as usual. |
||
|
|
|
||
|
Dec 4 2007, 07:17 AM
Post
#36
|
|
|
Moving Target Group: Members Posts: 249 Joined: 2-November 06 From: Bozeman, MT Member No.: 9,762 |
Um sorry to point this out after you went and fixed stuff again, but:
I noticed that the formulas for the bonuses due to adept powers are not the same for each row. The first row is different (and seems to work properly). In the rest of the rows I just get "####" in each of the columns. This in turn causes (I think) the augmented stats display on the main page to display "###" for each of the physical stats, there is also an entry right next to the augmented stats column (I believe it is normally where you kept track of extra dice for damage resistance) that displays something like "Error: 502." Thanks for the great sheet otherwise! |
|
|
|
|
Dec 4 2007, 03:05 PM
Post
#37
|
|||
|
Moving Target Group: Members Posts: 715 Joined: 4-September 05 From: Metaplane GEPLK136 (The one with the lizards. You remember the lizards, don't you?) Member No.: 7,684 |
That's very odd, since I haven't changed any of the magic sheets that I can recall. I'll look into it though. Edit: Yep, those formulas are different, and apparently they were different in the copy I downloaded. It doesn't look like a bug, exactly -- the only difference is whether zeros are displayed as spaces, or as zeros. It's just an aesthetic thing, but I'll try to clean that up too. I haven't been able to reproduce the bug, though -- which adept power were you using? And which version of excel? |
||
|
|
|
||
|
Dec 4 2007, 03:57 PM
Post
#38
|
|
|
Technomancer Group: Retired Admins Posts: 4,638 Joined: 2-October 02 From: Champaign, IL Member No.: 3,374 |
@Narse
Excel sometimes hides information behind pound signs (#) when there's not enough room in a column to display the full information. Try increasing the width of the columns with the #'s in them and see if that clears things up. |
|
|
|
|
Dec 5 2007, 05:31 AM
Post
#39
|
|
|
Moving Target Group: Members Posts: 249 Joined: 2-November 06 From: Bozeman, MT Member No.: 9,762 |
I'm using OpenOffice 2.3. All the fields that were previously "###" resolved into "Err:502" when I expanded the column width. So that includes the bonuses' fields on the adept power sheet (it doesn't seem to vary with power, all the powers I used outside of the first row give the same result) the modified attributes column for all physical attributes on the main sheet as well as the fields for initiative, IPs and damage resistance bonuses. Note that of the adept powers, those powers that should populate those fields (improved physical attribute, improved reflexes, mystic armor [I tested all of these, and all of the powers sequentially until the ones starting with I]) do populate the appropriate fields with the proper number (improved reflexes 3 puts a 3 in reaction and a 3 in IPs), but the rest of the columns still list "Err: 502".
Hope this helps. Note: the zero's display as spaces in the first row on my sheet. |
|
|
|
|
Dec 5 2007, 04:54 PM
Post
#40
|
|||
|
Moving Target Group: Members Posts: 715 Joined: 4-September 05 From: Metaplane GEPLK136 (The one with the lizards. You remember the lizards, don't you?) Member No.: 7,684 |
Okay, this looks like a difference in the way OpenOffice handles the VLOOKUP command. In Excel, if the cell looked up is blank, it returns 0. In OO, however, it returns error 502 instead. That affects the main sheet too, as when you add some number to an error, you get the error. I'll use the same formula that is in the top row of the adept power list (the one that displays blank spaces instead of 0's) in the rest of the rows. This should fix your problem. I could also fill in all the blank cells in the adept list with 0, but I like the blank spaces better, personally. I've got another correction to make; currently Type O is being applied to cultured bioware. I'll make those two changes and upload yet another draft when I'm done. |
||
|
|
|
||
|
Dec 5 2007, 05:16 PM
Post
#41
|
|||
|
Moving Target Group: Members Posts: 433 Joined: 8-November 07 Member No.: 14,097 |
I think it was being applied to genetech too, when I tried it a few days ago. |
||
|
|
|
||
|
Dec 5 2007, 06:14 PM
Post
#42
|
|||||
|
Moving Target Group: Members Posts: 715 Joined: 4-September 05 From: Metaplane GEPLK136 (The one with the lizards. You remember the lizards, don't you?) Member No.: 7,684 |
Yes, it was. I've completely changed the formula to calculate bio essence cost. It *should* handle all situations better now. Of course, because I re-wrote it, I probably messed something up doing it, so keep an eye out for errors in the bioware essence cost. Draft 7 is now up with the new bioware cost which should handle any combination of Type O System, bioware grade, cultured / basic / genetech, and Biocompatability (bioware) appropriately. It also should fix the problem Narse was having in OO. (Narse, let me know -- I don't have OO to test it here.) Edit: Okay, so I missed one. Biocompatability (which I forgot to clear off the sheet) is being applied to gene tech. I'll see about fixing that... |
||||
|
|
|
||||
|
Dec 5 2007, 06:27 PM
Post
#43
|
|
|
Moving Target Group: Members Posts: 715 Joined: 4-September 05 From: Metaplane GEPLK136 (The one with the lizards. You remember the lizards, don't you?) Member No.: 7,684 |
Okay, Draft 8 is now up, with genetech properly excluded from the list of bioware that is affected by grades, Type O, or Biocompatability. It is still affected by "Sensitive System" -- but I feel that is appropriate. Enjoy, and keep an eye out for more bugs.
|
|
|
|
|
Dec 5 2007, 07:28 PM
Post
#44
|
|
|
Immoral Elf Group: Members Posts: 15,247 Joined: 29-March 02 From: Grimy Pete's Bar & Laundromat Member No.: 2,486 |
Sensitive System actually only affects the Essence cost of Cyberware, not Bioware or Geneware in any way.
|
|
|
|
|
Dec 5 2007, 07:33 PM
Post
#45
|
|||
|
Moving Target Group: Members Posts: 715 Joined: 4-September 05 From: Metaplane GEPLK136 (The one with the lizards. You remember the lizards, don't you?) Member No.: 7,684 |
Oh, right. Forgot. The sheet handles it correctly, even if I dont' remember correctly, at least :) |
||
|
|
|
||
|
Dec 5 2007, 07:47 PM
Post
#46
|
|||||
|
Genuine Artificial Intelligence Group: Members Posts: 4,019 Joined: 12-June 03 Member No.: 4,715 |
Your hard work is very much appreciated, even if it is slowly driving you mad. :D |
||||
|
|
|
||||
|
Dec 5 2007, 08:32 PM
Post
#47
|
|||||||
|
Moving Target Group: Members Posts: 715 Joined: 4-September 05 From: Metaplane GEPLK136 (The one with the lizards. You remember the lizards, don't you?) Member No.: 7,684 |
Fortunately, it's a short trip anyway :D |
||||||
|
|
|
||||||
|
Dec 6 2007, 02:53 PM
Post
#48
|
|
|
Target Group: Members Posts: 89 Joined: 9-August 06 From: The Sixth World Member No.: 9,060 |
Love this spreadsheet. Awesome job to all who contributed to this! I'm certainly no Excel wizard like the rest of you, but I have made a couple modifications. First, I added Submersion and Max Resonance cells to the Technomancer worksheet. The Max Resonance cell will add the Submersion cell results to the result of cell B1. The formula I used was =IF(Technomancer!B1=Main_Sheet!M11,B1+G1, "")
You can see the screenshot here: http://img.photobucket.com/albums/v401/Ang...r_Worksheet.png I also modifed the gear worksheet to include specific information for weapons, explosives, armor, and equipment. I made a small change to the formula in the cell for total gear cost. The new formula is =SUM(A2:A31)+SUM(E2:E16)+SUM(E18:E24)+SUM(E26:E31) I don't know how to add gear to drop down menus like you have with skills on the main sheet. If you can teach me, I would be willing to do it. You can see the screenshot here: http://img.photobucket.com/albums/v401/Ang...r_Worksheet.png |
|
|
|
|
Dec 6 2007, 05:25 PM
Post
#49
|
|
|
Moving Target Group: Members Posts: 715 Joined: 4-September 05 From: Metaplane GEPLK136 (The one with the lizards. You remember the lizards, don't you?) Member No.: 7,684 |
Looks *GREAT*! I'll send you a PM with some instructions. To be honest, I hadn't known a thing about Excel when I started this update project either - but it was a great way to learn!
|
|
|
|
|
Dec 6 2007, 09:14 PM
Post
#50
|
|
|
Bushido Cowgirl Group: Members Posts: 5,782 Joined: 8-July 05 From: On the Double K Ranch a half day's ride out of Phlogiston Flats Member No.: 7,490 |
...mmmmmm Explosives. :grinbig:
Looks good, finally a gear list I won't run out of lines on. One possible adjustment. Maybe take part of the weapons list & designate it for Weapon Accessories and extra ammo. This way it will be right there with the character's guns & such and not use up lines from the general gear list. Also a place to record Armour Mods such as Chem Treatment, Non Conductive etc. would be helpful. |
|
|
|
|
Dec 6 2007, 11:46 PM
Post
#51
|
|||
|
Moving Target Group: Members Posts: 715 Joined: 4-September 05 From: Metaplane GEPLK136 (The one with the lizards. You remember the lizards, don't you?) Member No.: 7,684 |
Actually, I suggested this in my first PM to Kairo, and he's working on it now. So obviously I agree it's a good idea :D Good suggestion extending it to armor, too. |
||
|
|
|
||
|
Dec 7 2007, 03:40 PM
Post
#52
|
|
|
Target Group: Members Posts: 89 Joined: 9-August 06 From: The Sixth World Member No.: 9,060 |
Yeah, I actually already had made the change and put in a modifications column for the armor. Great minds think alike. ;) I'm having a few issues with the drop downs, so I'll be sending what I have to Feshy to see if he can fix the delimited error I keep running into.
|
|
|
|
|
Dec 8 2007, 01:27 AM
Post
#53
|
|
|
Bushido Cowgirl Group: Members Posts: 5,782 Joined: 8-July 05 From: On the Double K Ranch a half day's ride out of Phlogiston Flats Member No.: 7,490 |
...looking forward to seein the update.
BTW someone at work kinda clued me in on doing drop downs. I'll have to search for my notes & get back to you. |
|
|
|
|
Dec 10 2007, 02:10 PM
Post
#54
|
|||
|
Target Group: Members Posts: 89 Joined: 9-August 06 From: The Sixth World Member No.: 9,060 |
Feshy got me all fixed up, but thanks for the offer. I'll be working hard on the update all week, so hopefully we'll get a quality product to you soon. :) |
||
|
|
|
||
|
Dec 10 2007, 08:52 PM
Post
#55
|
|||||
|
Bushido Cowgirl Group: Members Posts: 5,782 Joined: 8-July 05 From: On the Double K Ranch a half day's ride out of Phlogiston Flats Member No.: 7,490 |
...sweet. Thanks. |
||||
|
|
|
||||
|
Dec 11 2007, 05:25 PM
Post
#56
|
|
|
Running Target Group: Members Posts: 1,269 Joined: 18-September 06 Member No.: 9,421 |
I'm ashamed to admit this, but I'm not particularly familiar with excel, I mean I can do basic stuff, but I was wondering if there was a not too horribly complicated way to edit the sheet so that the races cost a few less BP and skills cost half. We use Frank's build rules in my home game, and right now if I use the sheet I just have to buy double skills and stuff, but going over the stated limits, even if I'm not going over the game limits, bothers me so I would like to convert the sheet to my games rules, but I can't for the life of me remember how I would do that. Any suggestions?
Chris PS: Quite a few people seem to be trying out Frank's changes around here so if you wanted to be really nice you could just make another check box that would change things to Frank's rules. |
|
|
|
|
Dec 12 2007, 07:25 AM
Post
#57
|
|
|
Moving Target Group: Members Posts: 458 Joined: 28-March 05 From: NA/UCAS/IN/ Member No.: 7,246 |
I used the xls program, since I'm working with OpenOffice 2.3, and for some reason the Gear tab shows a bunch of spaces where gear could be put, but no drop down menus. The Main page and the Magic page seemed to work fantastically. Thanks for the obvious hard work. Thanks and great job!
|
|
|
|
|
Dec 12 2007, 08:08 AM
Post
#58
|
|||
|
Moving Target Group: Members Posts: 249 Joined: 2-November 06 From: Bozeman, MT Member No.: 9,762 |
Its a feature, not a bug! I believe that the intent was to let people fill in their own gear, as there is just way too much in the book to type it all out. That being said, it looks like some drop-down menus are in the works. |
||
|
|
|
||
|
Dec 12 2007, 06:20 PM
Post
#59
|
|||
|
Bushido Cowgirl Group: Members Posts: 5,782 Joined: 8-July 05 From: On the Double K Ranch a half day's ride out of Phlogiston Flats Member No.: 7,490 |
...click on the Tables tab. From there you should be able to modify the BP costs on the Race Table (should be the first table at the top of the page). I know in the Wizdoc Excel spreadsheet I am able to edit table data and have done so on many occasions. |
||
|
|
|
||
|
Dec 12 2007, 07:58 PM
Post
#60
|
|
|
Target Group: Members Posts: 89 Joined: 9-August 06 From: The Sixth World Member No.: 9,060 |
Just to give you all a heads up on my progress...
I've entered all non-firearms equipment in the gear list up to page 320 in the SR4 rules. The data has been entered in list form into a worksheet that will be hidden. The main Gear worksheet has drop down menus and these are broken down in sections that are loosely based on the SR4 pdf bookmarks (Electronics, Explosives, Communications, etc.). Separate worksheets will be made that will include firearms and armor. The reason I wanted to separate those is so that you can include upgrade accessories to individual weapons and armor. |
|
|
|
|
Dec 14 2007, 10:23 PM
Post
#61
|
|
|
Target Group: Members Posts: 89 Joined: 9-August 06 From: The Sixth World Member No.: 9,060 |
Here are some screenshots to show the progress I'm making. It's still a work in progress and I've left some design notes that will be deleted, but what I have input is all working correctly.
http://img.photobucket.com/albums/v401/Ang...Gear_Update.png http://img.photobucket.com/albums/v401/Ang...ar_Update_2.png http://img.photobucket.com/albums/v401/Ang...ar_Update_3.png |
|
|
|
|
Dec 15 2007, 10:29 AM
Post
#62
|
|
|
Running Target Group: Members Posts: 1,269 Joined: 18-September 06 Member No.: 9,421 |
I am apparently an idiot, KK, I cannot find a tables tab in OpenOffice.
Chris |
|
|
|
|
Dec 15 2007, 05:02 PM
Post
#63
|
|||
|
Moving Target Group: Members Posts: 715 Joined: 4-September 05 From: Metaplane GEPLK136 (The one with the lizards. You remember the lizards, don't you?) Member No.: 7,684 |
There is no such tab, I think KK is thinking of a different sheet or something. Currently, the costs for metahuman type are actually selected by an IF statement in the cell that displays them. (The racial attributes are handled in some hidden columns on the main sheet.) This may be changed to a race table sometime in the future, which would greatly simplify things if we get a book with metahuman variants. For now though, you'll just have to change this cell. Putting Frank's house rules as an optional rule on the sheet is probably not a bad idea, if enough people are using it. |
||
|
|
|
||
|
Dec 17 2007, 11:09 PM
Post
#64
|
|
|
Bushido Cowgirl Group: Members Posts: 5,782 Joined: 8-July 05 From: On the Double K Ranch a half day's ride out of Phlogiston Flats Member No.: 7,490 |
...hmmm I thought there was one, must be getting mixed up with Wizdoc.xls
|
|
|
|
|
Dec 18 2007, 12:49 AM
Post
#65
|
|
|
Runner Group: Members Posts: 2,650 Joined: 21-July 07 Member No.: 12,328 |
I have a sheet that actually has franks rules built in.. I'll post it when I get home later, it's not very hard. It won't be a checkbox, it will be an entirely new sheet built from fleshys.
Edit: Technomancers don't work, maybe I can fix that, maybe I cannot, if someone writes out a complete list of technomantic powers that would help. |
|
|
|
|
Dec 18 2007, 01:29 AM
Post
#66
|
|
|
Runner Group: Members Posts: 2,650 Joined: 21-July 07 Member No.: 12,328 |
http://www.mediafire.com/?0d0ywe20tyw
Technomancer stuff is basically glue and sticky tape with no actual substance, just fill out the 'number of complex forms' box at the top and it will caculate the costs correctly. Please ignore or whatever the character built into the sheet, that is my test bed :) Otherwise everything else works. |
|
|
|
|
Dec 21 2007, 07:52 AM
Post
#67
|
|
|
Target Group: Members Posts: 1 Joined: 16-November 07 Member No.: 14,223 |
huh, i should have known the easiest way to get someone else to do this kind of work was to start on it myself - ive spent a couple of weeks learning enough Excel to add in Augmentation.
im having a little trouble downloading draft 8, mediafire claims it is password protected - normal? also, was the original cyberlimb page as unfinished as i seem to have found? rating multipliers in cost and such? i realize they suck so much that noone would have looked at them enough to stumble across any bugs, and much of the system can be ignored with Aug... but i would kind of like to know im not insane. |
|
|
|
|
Dec 22 2007, 01:18 AM
Post
#68
|
|||
|
Moving Target Group: Members Posts: 715 Joined: 4-September 05 From: Metaplane GEPLK136 (The one with the lizards. You remember the lizards, don't you?) Member No.: 7,684 |
Decidedly not normal. I just checked mediafire, and it doesn't seem to be password protected. It's been downloaded over a hundred times now, so at least some people must be able to :) If anyone has trouble getting the file, just send me a PM with your e-mail, and I'll mail you a copy of the sheet. It might take me a few days with the holiday madness that has struck, but I'll eventually get back to you. The cyberlimb page is working on the sheet I've got, though I remember fixing quite a few errors on it when I updated it. I don't recall which ones specifically. |
||
|
|
|
||
|
Dec 24 2007, 04:58 PM
Post
#69
|
|
|
Moving Target Group: Members Posts: 236 Joined: 17-October 07 Member No.: 13,735 |
I cant seem to find a Skimmer Discs under the Cyber limb accessories
|
|
|
|
|
Dec 28 2007, 02:58 PM
Post
#70
|
|
|
Target Group: Members Posts: 89 Joined: 9-August 06 From: The Sixth World Member No.: 9,060 |
Just to update: I'm still chugging away on gear. Hopefully I'll have a draft ready for Feshy to review sometime in the next week or two.
|
|
|
|
|
Feb 3 2008, 07:21 AM
Post
#71
|
|
|
Moving Target Group: Members Posts: 206 Joined: 19-January 08 Member No.: 15,368 |
Kind of an odd of me to be performing a bit of thread resurrection with my first post on DS (shiny new account and all), but hey, this thread and the chargen sheet in it was the reason I started reading these boards.
In short, I've been using this sheet to number crunch concepts for my own kicks and giggles and, in the process, I've been modifying it as new things have come up that I wanted to make use of. Specifically: --I converted it to allow overloading of BP costs of various things to user-input values, for house ruling --I converted over most of the Frank Trollman house rules that I found at http://forums.dumpshock.com/index.php?show...=19741&st=0 using checkboxes so the different parts can be turned on or off to preference. --Finally, I added a kind of cheesy Martial Arts worksheet for Arsenal Martial Arts styles, advantages, and maneuvers. Anywho, I'm not sure how one would go about submitting changes to the sheet to be included in the next official draft, but whoever is in charge of that (or anyone else who'd want a copy of the sheet with my modifications) can feel free to PM me and I can send it to you or post it somewhere temporarily to download. Thanks for a great little tool and hope the work on getting a gear list to add to it goes well. -sombranox P.S. I couldn't find anything on the sheet itself forbidding modifying it and redistributing it or whatnot, but if I've stepped on toes or infringed on creative works or anything like that, just let me know and I'll refrain from sending it to anyone and just keep it for my own use. |
|
|
|
|
Feb 3 2008, 07:58 PM
Post
#72
|
|
|
Moving Target Group: Members Posts: 715 Joined: 4-September 05 From: Metaplane GEPLK136 (The one with the lizards. You remember the lizards, don't you?) Member No.: 7,684 |
Kairo, are you still out there?
QUOTE P.S. I couldn't find anything on the sheet itself forbidding modifying it and redistributing it or whatnot, but if I've stepped on toes or infringed on creative works or anything like that, just let me know and I'll refrain from sending it to anyone and just keep it for my own use. I think we are at least two or three main authors removed from the original at this point. Thank Autarkis for having the foresight not to forbid any modification or distribution; it's his original work that I believe we have all been building on. As far as someone being in charge, I think that being 'in charge' of this document is like a 'herd' of butterflies. That is to say, to an outside observer, it isn't statistically impossible that you might see someone in charge at a given time, or progress in a certain direction, but it is an illusion generated by the mathematics of chaos that truly underly the system. That said, as the person who started this thread, I'll update the first post with an address to any updated sheet that people give me an address to, and I'll do the same with sheets I get via PM or at my e-mail (which will shortly be in my profile.) Lastly, I don't have Arsenal yet, so I've got no way to update or verify any information in that book yet. |
|
|
|
|
Feb 3 2008, 09:28 PM
Post
#73
|
|
|
Moving Target Group: Members Posts: 206 Joined: 19-January 08 Member No.: 15,368 |
|
|
|
|
|
Feb 5 2008, 03:00 PM
Post
#74
|
|
|
Moving Target Group: Members Posts: 259 Joined: 2-September 07 From: In the AGS, underwater Member No.: 13,049 |
I just upgraded to Office:mac 2008 and have problems with the spreadsheets not listing all items in dropdown menus. It happens with several versions of the sheet though so I think it might be a problem with Office though (woot).
Everything worked fine with 2004. |
|
|
|
|
Feb 6 2008, 05:19 PM
Post
#75
|
|
|
Target Group: Members Posts: 89 Joined: 9-August 06 From: The Sixth World Member No.: 9,060 |
Yep, I'm still working on this. I'll email what I have to Feshy and see if he can clean it up a bit to conform to the standards of the rest of the spreadsheet. The gear is still a work-in-progress and due to my real world work ramping up, I haven't had as much time to devote to it of late. I'll keep hammering away as time permits though. (IMG:style_emoticons/default/smile.gif)
|
|
|
|
|
Feb 12 2008, 06:12 PM
Post
#76
|
|
|
Moving Target Group: Members Posts: 718 Joined: 10-September 05 From: Montevideo, in the elusive shadows of Latin America Member No.: 7,727 |
Great work dudes! keep it up!
A fan Max |
|
|
|
|
Feb 18 2008, 09:59 AM
Post
#77
|
|
|
Runner Group: Members Posts: 2,650 Joined: 21-July 07 Member No.: 12,328 |
QUOTE (Sombranox @ Feb 3 2008, 04:28 PM)  Sweet sheet man. Thanks. |
|
|
|
|
Feb 21 2008, 11:34 PM
Post
#78
|
|
|
Neophyte Runner Group: Members Posts: 2,159 Joined: 12-April 07 From: Ork Underground Member No.: 11,440 |
The Spreadsheet does not implement Genetic Optimization ie Body, Str etc.
I like transgenetics also. WMS |
|
|
|
|
Feb 23 2008, 11:03 AM
Post
#79
|
|
|
Moving Target Group: Members Posts: 259 Joined: 2-September 07 From: In the AGS, underwater Member No.: 13,049 |
I went back to using Office 2004 for now because 2008 is a buggy pile of drek. My guess is that MS themselves can't decide about proper OOXML in their own products...
While entereing a recent char with skimmer discs in draft 9 I noticed there are no modular cyberlimb plugins in the sheet. I guess there's already a plan for that stuff? |
|
|
|
|
Feb 28 2008, 03:32 AM
Post
#80
|
|
|
Target Group: Members Posts: 79 Joined: 11-July 07 Member No.: 12,214 |
I just noticed this and thought I should note it.
The main post claims its Draft 7, but I just downloaded it as draft 8 from the link provided. just in case people where waiting for an update its there |
|
|
|
|
Feb 28 2008, 04:13 AM
Post
#81
|
|
|
Target Group: Members Posts: 23 Joined: 26-February 02 Member No.: 2,111 |
Hurrm,
Just found a bug- The "Type O System" positive trait from augmentation does not appear to work in the .xls spreadsheet. I see something referencing it in the essence cost formula, but I get no change in the essence costs for bioware. --Ikarius |
|
|
|
 Feb 28 2008, 09:04 PM
Post
#82
|
|
|
Prime Runner Group: Members Posts: 3,803 Joined: 3-February 08 From: Finland Member No.: 15,628 |
QUOTE (ikarius @ Feb 28 2008, 06:13 AM) Hurrm, Just found a bug- The "Type O System" positive trait from augmentation does not appear to work in the .xls spreadsheet. I see something referencing it in the essence cost formula, but I get no change in the essence costs for bioware. I don't know what going on in your preadsheet, becouse it definedly works for me at least(using draft 8, if it makes a difrence) it correcly halfs the essence cost for basic bioware. |
|
|
|
|
Feb 29 2008, 12:31 AM
Post
#83
|
|
|
Target Group: Members Posts: 23 Joined: 26-February 02 Member No.: 2,111 |
I've tracked this down a bit better. The bug is definitely there, and it manifests when you do NOT check the House Rule of "Modifiers are handled additively". I was mistaken in the "no change"; that was for a piece of cultured bioware. Basic bioware actually goes UP in essence cost when you do not check the house rule, and goes down in cost by half when you do check the rule. I tracked down the cell named Bio_Essence_Reduction, which does 2 different calculations based on the state of the house rule, and if the house rule is checked, it comes out as -0.5, if the house rule isn't checked, it comes out as 0.5; no negative. I'll see if I can decipher what the non-additive method was supposed to be and come up with a working replacement formula.
Ikarius |
|
|
|
|
Mar 7 2008, 12:44 PM
Post
#84
|
|
|
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 |
If someone can email me the file, kelvaris (at) gmail (dot) com, I would be happy to host it on my domain, add free. I have a couple of gigs of bandwidth so I think I would be okay.
|
|
|
|
|
Mar 7 2008, 10:06 PM
Post
#85
|
|
|
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 I got that site to let me download it. If you keep me posted on the revisions I will happily mirror for you. It's a lot easier to click on a link and start the download then to jump the add hoops.
sr4chargenrev8 this is the non rar version as is compatible through office 07 as far as I know. |
|
|
|
|
Apr 1 2008, 07:23 PM
Post
#86
|
|
|
Moving Target Group: Members Posts: 249 Joined: 2-November 06 From: Bozeman, MT Member No.: 9,762 |
Hey Guys, I'm here posting just to let you all know that I really appreciate the hard work you all have put into this wonderful sheet. Also: I eagerly await the new and improved revised draft. Keep up the great work!
This sheet is seriously probably the best community tool out there for all us SR4 players. If there is anything I can do to help bring this next release to fruition, let me know. I don't know excel but can probably learn. Most Gratefully, Narse Edit: Just fired up the sheet again after several months, and realized that I never mentioned that draft 8 still gives an Err:502 in the modified initiative pass field right from the get go. Edit2: Tracked this down to cell T34 on the cyber/bio ware page. It's formula is: CODE =MAX(T2:T33) Since T2 throught T33 can have blank values (and do before I add any ware that modifies IP's) I would guess that this is another Open office issue with lookups of blank cells throwing Err:502. (T34 displays Err:502 in these circumstances). I consider this bug to be of low importance, because the field on the main sheet displays the proper value as long as IP enhancing augmentations are present. Note, however that if a character is built with adept powers that enhance IP's and no IP modifing ware (but why would someone buy Wired Reflexes if they also had Improved reflexes?) then the field (main sheet: O14) displays Err:502. On a related note the cell Magic.P17 (the total IP mod due to adept powers) does not throw Err:502. I believe this is because it calls SUM(P3:P16) rather than MAX(x:y). This seems to cause bugs in very uncommon circumstances. That is when multiple instances of Improved Reflexes are taken. This of course is obviously a bad user input, and therefore is potentially not worth worrying about. However, it does seem significantly more likely that more than one piece of IP modifying 'ware may be present (what with 3 different ways of increasing IP via ware) which precludes using the same formula (i.e. SUM, specifically Cyber_Bio.T34=SUM(T2:T33) ) for the calculation of total Initiative Pass modifier due to ware. To conclude: Change the formula of cell Cyberware_Bioware.T34 so that if all the cells that are referenced are blank it assumes a value of 0 (all the other cells in that row take 0 when the above cells are blank [at least in open office]) Potentially consider using this same function for cell Magic.P17. I think you could try to do some error handling here (if excel/OO even allow that) as you only need to set the values of the cells to zero if MAX(x:y) throws Err:502. Of course, this might break excel compatibility as you mentioned that excel returns 0 from blank cells and OO returns Err:502. Note that this would still allow you to call MAX($Cyber_Bio.T34;$Magic.p17) in the main sheet as both cells would always have a value in them of at least zero. Perhaps you could use the following for Cyber_Bio.T34 (top line) and Magic.P17 (bottom line): CODE =IF(SUM(T2:T33)=0;0;MAX(T2:T33)) =IF(SUM(P3:P16)=0;0;MAX(P3:P16)) This takes advantage of the fact that SUM(x:y) returns 0 even if MAX(x:y) returns Err:502 (which is the case as far as I understand it.) Anyhow, since I don't know excel, you should really double check my work as I am only guessing that =IF(x;y;z) means "If x is true, then assign value y, otherwise[else] assign value z" from the context it seems to be used in, in the worksheets. Hope this was helpful, Narse |
|
|
|
|
Apr 2 2008, 02:34 AM
Post
#87
|
|
|
Bushido Cowgirl Group: Members Posts: 5,782 Joined: 8-July 05 From: On the Double K Ranch a half day's ride out of Phlogiston Flats Member No.: 7,490 |
...cool cool cool.
thanks. The larger gear page is sweet. I actually prefer the manual gear entry as it allows you to put in comments like "Fake License 4 [Concealed Weapon] or "Virtual Person [Mom]" without having to hack into various tables. |
|
|
|
|
Apr 2 2008, 06:09 PM
Post
#88
|
|
|
Moving Target Group: Members Posts: 697 Joined: 18-August 07 Member No.: 12,735 |
QUOTE (Kyoto Kid @ Apr 1 2008, 08:34 PM) ...cool cool cool. thanks. The larger gear page is sweet. I actually prefer the manual gear entry as it allows you to put in comments like "Fake License 4 [Concealed Weapon] or "Virtual Person [Mom]" without having to hack into various tables. I agree, but I'd like some way to pick the gear from a list as well... After a while, I get tired of looking up prices for everything. |
|
|
|
|
Apr 2 2008, 06:59 PM
Post
#89
|
|
|
Neophyte Runner Group: Members Posts: 2,159 Joined: 12-April 07 From: Ork Underground Member No.: 11,440 |
The packages cyberware suites do not give the bonuses to stats or skills. If you format the cells to have borders it makes it easier to see which column to add the stat bonuses to.
Genetic Optimization gives not bonus to any stats? You will need to add/insert these to the Advantage list on Sheet1 Genetic Optimization (Body) Genetic Optimization (Agility) Genetic Optimization (Reaction) Genetic Optimization (Strength) Genetic Optimization (Charisma) Genetic Optimization (Intuition) Genetic Optimization (Logic) Genetic Optimization (Willpower) Then add/edit the following to the cells in the M2-M9 cells to implement it. IF(AA2=-1,5,IF(AA2=-2,4,6+AA2))+IF(ISERROR(MATCH("Exceptional Attribute (Body)",O33:O46,0)),0,1)+IF(ISERROR(MATCH("Genetic Optimization (Body)",Cyberware_Bioware,0)),0,1) Insure that each cell for each stat is changed to reflect that stat ie Body for Genetic Optimization (Body) etc. Genetic Heritage/Genecrafted gives no cost savings on Genetic Optimization. Why was the karmic analysis added? I must have missed that topic discussion? Also add/insert to the Advantage list on Sheet1 Martial Art 1 5 Martial Art 2 10 Martial Art 3 15 Martial Art 4 20 WMS |
|
|
|
|
Apr 2 2008, 07:19 PM
Post
#90
|
|
|
Neophyte Runner Group: Members Posts: 2,159 Joined: 12-April 07 From: Ork Underground Member No.: 11,440 |
To implement some transgenetic features add the following to the WareList sheet
QUOTE Trans Alt Alien Look Gen 0.2 10 40,000 Trans Alt Minor Modification Gen 0 4 1,000 Trans Alt Moderate Modification Gen 0.1 6 2,000 Trans Alt Severe Modification 1 Gen 0.3 6 10,000 Trans Alt Severe Modification 2 Gen 0.4 8 10,000 Trans Alt Severe Modification 3 Gen 0.5 12 10,000 Trans Alt Metatype Change Gen 0.3 8 25,000 Trans Alt Sex Change Gen 0.3 6 20,000 Trans Alt Animal Features Gen 0.3 10 45,000 Trans Alt Chameleon Skin Gen 0.2 6 4,000 Trans Alt Dynamic Chameleon Skin Gen 0.2 8 7,000 Trans Alt Clean Metabolism Gen 0.1 4 2,500 Trans Alt Chloroplast Skin Gen 0.1 4 2,500 Trans Alt Dietware Gen 0.1 4 2,500 Trans Alt Hair Growth Gen 0 4 A 500 Trans Alt Sensitive Skin Gen 0 4 2,500 Trans Alt Silky Skin Gen 0 4 1,500 Trans Alt Skin Pigmentation Gen 0 4 1,500 Trans Alt Bio Tattoos Gen 0 4 A 1,500 Trans Alt Bone Density Augmentation (1-4) Gen 0.3 12 A 20,000 Trans Alt Cat's Eyes Gen 0.1 4 7,500 Trans Alt Chemical Gland Gen 0.3 12 30,000 Trans Alt Exhalation Spray Gen 0.1 5,000 Trans Alt Internal Release Gen 1,000 Trans Alt Spit Gen 0.1 3,000 Trans Alt Weapon Reservoir Gen 0.1 2,000 Trans Alt Digestive Expansion Gen 0.5 4 20,000 Trans Alt Echolocation Gen 0.1 8 15,000 Trans Alt Elastic Joints Gen 0.3 10 15,000 Trans Alt Enhanced Pherome Recepters (1-3) Gen 0.1 10 E 5,000 Trans Alt Extended Volume (1-3) Gen 0.1 10 E 4,000 Trans Alt Gecko Hands Gen 0.1 6 12,000 Trans Alt Gills (1-2) Gen 0.2 6 E 12,000 Trans Alt Hands and Foot Webbing Gen 0.1 6 6,000 Trans Alt Hearing Enhancement Gen 0.1 6 5,000 Trans Alt Muscle Augmentation (1-4) Gen 0.2 5 1 7,000 Trans Alt Muscle Toner (1-4) Gen 0.2 5 1 8,000 Trans Alt Nicitating Membrane Gen 0.1 4 2,000 Trans Alt Quills Gen 0.25 6 2,500 Trans Alt Skin Pocket Gen 0.1 4 5,000 Trans Alt Spidersilk Gland Gen 0.3 10 40,000 Trans Alt Tactile Sensitivity Gen 0.2 8 4,000 Trans Alt Tailored Critter Pheromones (1-3) Gen 0.2 4 1 15,000 Trans Alt Tailored Pheromones (1-3) Gen 0.2 4 1 15,000 Trans Alt Troll Eyes Gen 0.1 6 8,000 Trans Alt Vocal Range Extender Gen 0.1 8 12,000 To change over to Franks rules save spreadsheet to another name ie "halfcost" etc. Then load that spreadsheet and change the following cells Main Sheet AA18 to =IF($A18<>"",IF(ISERROR(FIND("(Group)",$A18)),D18*2+IF(D18>6,2,0),D18*5),0 Main Sheet AB18 to =IF(F18<>"",1,0) Then just dragfill the cells down to line 46. For Race Edit Main Sheet S3 for the costs of Franks Races For racial costs on my sheets I used a different method since I have put the subraces and other things into effect. WMS |
|
|
|
|
Apr 2 2008, 11:18 PM
Post
#91
|
|
|
Neophyte Runner Group: Members Posts: 2,159 Joined: 12-April 07 From: Ork Underground Member No.: 11,440 |
Formula in sheet Bioware_Cyberware cell D2 is
=IF($A2="","",(VLOOKUP($A2,Complete_Ware_Table,4,FALSE))*(IF($B2="",1,IF(ISERR(FIND("A",VLOOKUP($A2,Complete_Ware_Table,5,FALSE))),$B2,1)))-IF($C2="2nd Hand",1,IF($C2="2nd Alpha",1,0)) + IF($A3<>"",IF(ISERR(FIND("P",VLOOKUP(A3,Complete_Ware_Table,5,FALSE))),0,$D3),0)) Why is it referencing cells A3 and D3? The entire column of D has the same error? WMS |
|
|
|
|
Apr 3 2008, 12:58 AM
Post
#92
|
|
|
Neophyte Runner Group: Members Posts: 2,159 Joined: 12-April 07 From: Ork Underground Member No.: 11,440 |
I think the error in that cells formula is supposed to reference the availability code of the cell above it, the "P" flag in your sheet is for a added feature of a piece of cyberwear.
WMS |
|
|
|
|
Apr 15 2008, 11:04 AM
Post
#93
|
|
|
Target Group: Members Posts: 35 Joined: 13-March 02 Member No.: 2,345 |
I've only just started looking at SR4 and thus it may be me missing something from the rules, but as Magic is a stat shouldn't you be able to take Exceptional Apptitude (Magic). I notice this doesn't seem possible with the sheet but wasn't sure if it was me missing a rule or finding something missing form the sheet.
Kithran |
|
|
|
|
Apr 15 2008, 05:15 PM
Post
#94
|
|
|
Moving Target Group: Members Posts: 206 Joined: 19-January 08 Member No.: 15,368 |
QUOTE (Kithran @ Apr 15 2008, 07:04 AM) I've only just started looking at SR4 and thus it may be me missing something from the rules, but as Magic is a stat shouldn't you be able to take Exceptional Apptitude (Magic). I notice this doesn't seem possible with the sheet but wasn't sure if it was me missing a rule or finding something missing form the sheet. Kithran I think it says in the description of exceptional aptitude that it can only be taken for physical and mental stats, which is the normal six. And then somewhere in the magic section that the only way to raise magic limits is through initiation. Which is good, because mages are scary as hell as it is at Magic 6 starting out. Once they start initiating, they can get truly nasty. I don't have my books on this computer, but I'm semi-sure that those wordings were in there. |
|
|
|
|
Apr 16 2008, 08:47 PM
Post
#95
|
|
|
Moving Target Group: Members Posts: 497 Joined: 16-April 08 From: Alexandria, VA Member No.: 15,900 |
QUOTE (Kithran @ Apr 15 2008, 06:04 AM) I've only just started looking at SR4 and thus it may be me missing something from the rules, but as Magic is a stat shouldn't you be able to take Exceptional Apptitude (Magic). I notice this doesn't seem possible with the sheet but wasn't sure if it was me missing a rule or finding something missing form the sheet. Kithran Book says "The Exceptional Attribute quality allows a character to possess a natural Physical or Mental attribute at a level above the metatype maximum." Magic (and Resonance) are classified as Special attributes, which leaves them out. |
|
|
|
|
Apr 17 2008, 06:05 PM
Post
#96
|
|
|
Moving Target Group: Members Posts: 280 Joined: 21-November 07 From: Shadows of France Member No.: 14,312 |
With is further confirmed by the Lucky quality that allow to raise edge (a special attribute too) by 1 point.
|
|
|
|
|
Apr 25 2008, 01:31 PM
Post
#97
|
|
|
Moving Target Group: Members Posts: 493 Joined: 7-December 07 From: Kiev, USSR Member No.: 14,536 |
Wait, one of my players had the draft 9 version of the sheet, w/Arsenal and Frank's custom rules imped. I looked over the thread, but didn't find it. I missed it somewhere?
|
|
|
|
|
May 16 2008, 10:32 PM
Post
#98
|
|
|
Moving Target Group: Members Posts: 100 Joined: 13-March 08 From: Texas! Giddy Up! Member No.: 15,770 |
QUOTE (quentra @ Apr 25 2008, 08:31 AM) Wait, one of my players had the draft 9 version of the sheet, w/Arsenal and Frank's custom rules imped. I looked over the thread, but didn't find it. I missed it somewhere? Links not working, but if you look on this page someone quoted the person who has a link to draft v9. |
|
|
|
|
May 16 2008, 11:12 PM
Post
#99
|
|
|
Shooting Target Group: Members Posts: 1,745 Joined: 30-November 07 From: St. Louis Streets Member No.: 14,433 |
Soo.... what ever happened to the update that was supposed to be coming out that gave drop down lists for items, weapons, and other fun things?
|
|
|
|
|
May 22 2008, 06:35 AM
Post
#100
|
|
|
Moving Target Group: Members Posts: 199 Joined: 27-April 08 Member No.: 15,932 |
I'm getting a very odd error. My Physical Attributes are all messed up in the XLS for Loki (in sig). It says Err:502 but I use OpenOffice, so that may be a unique error to OO. Can anyone verify if my error happens elsewhere, or how to fix it?
|
|
|
|
 |
|
Lo-Fi Version | Time is now: 4th October 2025 - 02:10 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.