 SR4Chargen Excel collaborative effort, Now you can all work together when I disappear. |
  |
 Jul 15 2008, 03:48 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  |
Just to be clear, this is the same sheet from this thread: SR4Chargen excell sheet updated for augmentation, but with there being two more source books since then, the title was getting out of date.
Several of you have tried to contact me with new versions, or bug fixes, of the character file. I know I haven't been the most responsive. So I've done what I should have done all along: Set up a website service where anyone can upload versions of the file, and download any of the versions posted so far. It's a fairly new service, at Drop.io. I'm still waiting to see how it evolves, but even now it should work for our needs. So, from now on, if you have the itch to improve on this sheet (or any of the versions of it laying around out there) just go ahead and then upload it to the site. You can find the most recent version I worked on (draft (IMG:style_emoticons/default/cool.gif) and a sheet that Kairo began updates on, there already. If someone wants to upload any of the other sheets that have been done since, go ahead (I know Sombranox and HalloranElder have made sheets) I just didn't have copies at the time. Here's the link to the site: Drop.io/SR4Chargen You can leave notes, comment on each file, etc. The site is big into privacy, so you don't ever have to give them any information even to upload. Hope this works out better than hoping I respond via personal message or e-mail; my time to post here tends to be unpredictable these days. Enjoy! |
 |
 
|
|
Jul 16 2008, 06:23 AM
Post
#2
|
|
|
Target Group: Members Posts: 38 Joined: 12-May 06 From: Melbourne, Australia Member No.: 8,551 |
One problem: It's asking for a password to login with.
Oops? Enjoy Random |
|
|
|
|
Jul 16 2008, 02:37 PM
Post
#3
|
|
|
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 |
QUOTE (HalloranElder @ Jul 16 2008, 01:23 AM)  One problem: It's asking for a password to login with. Oops? Enjoy Random Ah. Fixed now. New site, new service, still learning (IMG:style_emoticons/default/wink.gif) |
|
|
|
|
Jul 16 2008, 04:29 PM
Post
#4
|
|
|
Neophyte Runner Group: Members Posts: 2,159 Joined: 12-April 07 From: Ork Underground Member No.: 11,440 |
Nice attempt but many issues from the spreadsheet are not yet resolved.
Genetic Optimization does not work. Cyber Wear Suites do not add to attributes. etc. Here is a link to my prior points in this spreadsheet. Spreadsheet Issues WMS |
|
|
|
|
Jul 18 2008, 08:55 PM
Post
#5
|
|
|
Dumorimasoddaa Group: Members Posts: 2,687 Joined: 30-March 08 Member No.: 15,830 |
Posted this on the page as well.
Just an idea but we could combine this with http://forums.dumpshock.com/index.php?showtopic=22277 we would have perhaps the best PC management tool for SR4. Then the only other thing to move on to would be working out karma costs after making the PC as have finished the BP phase. A long term goal but should be achievable. I'll put the combining idea to Chrysalis and then try to think how we can link the workbooks together but keep them apart file wise. |
|
|
|
|
Jul 24 2008, 04:09 AM
Post
#6
|
|
|
Target Group: Members Posts: 2 Joined: 24-July 08 Member No.: 16,161 |
There is a problem with the Essence calculation for Bioware with the Type O System quality in the SR4 Chargen (withAugmentation) spreadsheet. Instead of halving the cost, it increases it by 1.5. I don't have Excel 2007, so I don't know if this is just a problem with the .xls version, or if it's in both.
|
|
|
|
|
Aug 9 2008, 04:24 PM
Post
#7
|
|
|
Moving Target Group: Members Posts: 236 Joined: 17-October 07 Member No.: 13,735 |
I know next to nothing about writing Excel. But, I was curious if anyone has started to update this sheet for Unwired and RC
|
|
|
|
|
Aug 9 2008, 11:01 PM
Post
#8
|
|
|
Neophyte Runner Group: Members Posts: 2,159 Joined: 12-April 07 From: Ork Underground Member No.: 11,440 |
QUOTE (raverbane @ Aug 9 2008, 10:24 AM) I know next to nothing about writing Excel. But, I was curious if anyone has started to update this sheet for Unwired and RC Answer is Yes and the follow up question is NO. I took the more basic spreadsheet before Augmentation and modified it for my own needs/uses. Right now I am rethinking the way certain build points are calculated. Ie Metagenics, Martial Arts, and Metavarients etc. WMS |
|
|
|
|
Sep 4 2008, 01:18 PM
Post
#9
|
|
|
Target Group: Members Posts: 89 Joined: 9-August 06 From: The Sixth World Member No.: 9,060 |
I have a huge update coming soon for the Excel Character Generator that Autarkis and Feshy started. Nearly all of the following worksheets are 100% complete. The formula for a couple sections on the Gear is not as good as I would like, the drones are currently not upgradeable, and not all of the armor (specifically environmental hazard suits) are input. Aside from that, this is working fairly well. All SR4 book materials are used except for Unwired, which I'll work on after I get the final kinks wrinkled out.
Main Sheet - Race, Attributes, Skills, Qualities, Build Point Tracker Race Variant - Metavariants, Drakes, Changelings, Metagenics, Infected Magic - Spells, Adept Powers, Spirits, Foci, Traditions, Paths, Mentor Spirits, Initiate Grades (Street Magic material included) Technomancer - Resonance, Common Complex Forms, Hacking Complex Forms, Registered Sprites, Submersion Cyberware Bioware - All cyberware / bioware from SR4 and Augmentation Cyberparts - Limb replacements and packages Martial Arts - Artforms, Maneuvers Firearms - All firearms from SR4 and Arsenal, Upgrades, Accessories, Ammo Armor - All armor from SR4 and Arsenal, Ballistic/Impact Grades, Upgrades, Additive Armors Gear - Melee Weapons, Projectile Weapons, Explosives, ID, Communications, Electronics, Softs, Simsense, Cred Accounts, Vision Devices, Audio Devices, Sensors, Security, B&E, Survival Gear, Chemicals, Biotech, Patches, DocWagon Contracts, Disguises, and Manatech Vehicles - All vehicles from SR4 and Arsenal, Mods, Weapons Drones - All drones from SR4 and Arsenal Lifestyles - Advanced Lifestyles from Runner's Companion Background - Large cell for typing in history / notes. |
|
|
|
|
Sep 4 2008, 10:28 PM
Post
#10
|
|
|
Dumorimasoddaa Group: Members Posts: 2,687 Joined: 30-March 08 Member No.: 15,830 |
Wow now all that's needed is a karma gen sheet. But That will be a bigger pain than the current BP sheet.
|
|
|
|
|
Sep 5 2008, 08:54 AM
Post
#11
|
|
|
Awakened Asset Group: Members Posts: 4,464 Joined: 9-April 05 From: AGS, North German League Member No.: 7,309 |
QUOTE (Dumori @ Sep 5 2008, 12:28 AM) Wow now all that's needed is a karma gen sheet. But That will be a bigger pain than the current BP sheet. It is not more painful per se. I have seriously uglified my version of the BP-sheet while implementing* karma calculation, but it works easily. Trick on attribute cost: Check if user input satisfies racial minimum requirements, if they are met substract their karmic value from usual cost figure. The expanded attribute cap is covered by that, too. That is for an attribute: (Rating Column B) =WENN(B4="";"";(B4*(B4+1)/2-1)*3) That is for a skill: (Skill Name column A, Rating Column B) =WENN(A28="";"";WENN(ISTFEHLER(FINDEN("Group";A28));(B28*(B28+1)/2+1)*2;(B28*(B28+1)/2+1)*5)) |
|
|
|
|
Sep 5 2008, 01:39 PM
Post
#12
|
|
|
Dumorimasoddaa Group: Members Posts: 2,687 Joined: 30-March 08 Member No.: 15,830 |
Fun the pain is working out what that would be. And in my case the easiest and smallest way to do said task I code now and then and I go mad with the optimising. It also helps that my German is a bit rusty as I haven't used it in 4 years.
|
|
|
|
|
Sep 5 2008, 03:25 PM
Post
#13
|
|
|
Awakened Asset Group: Members Posts: 4,464 Joined: 9-April 05 From: AGS, North German League Member No.: 7,309 |
Deeply sorry. The code looked ok to me.
=IF(B4="";"";(B4*(B4+1)/2-1)*3) =IF(A28="";"";IF(IFERROR(FIND("Group";A28));(B28*(B28+1)/2+1)*2;(B28*(B28+1)/2+1)*5)) |
|
|
|
|
Sep 5 2008, 04:01 PM
Post
#14
|
|
|
Dumorimasoddaa Group: Members Posts: 2,687 Joined: 30-March 08 Member No.: 15,830 |
ah ISTFEHLER was the problem I know the other words. That's much easier to understand. Thank you.
|
|
|
|
|
Sep 9 2008, 08:21 PM
Post
#15
|
|
|
Running Target Group: Members Posts: 1,210 Joined: 5-September 05 From: Texas Member No.: 7,685 |
How are they coming and what is the ETA?
Thanks! QUOTE (Kairo @ Sep 4 2008, 07:18 AM) I have a huge update coming soon for the Excel Character Generator that Autarkis and Feshy started. Nearly all of the following worksheets are 100% complete. The formula for a couple sections on the Gear is not as good as I would like, the drones are currently not upgradeable, and not all of the armor (specifically environmental hazard suits) are input. Aside from that, this is working fairly well. All SR4 book materials are used except for Unwired, which I'll work on after I get the final kinks wrinkled out. Main Sheet - Race, Attributes, Skills, Qualities, Build Point Tracker Race Variant - Metavariants, Drakes, Changelings, Metagenics, Infected Magic - Spells, Adept Powers, Spirits, Foci, Traditions, Paths, Mentor Spirits, Initiate Grades (Street Magic material included) Technomancer - Resonance, Common Complex Forms, Hacking Complex Forms, Registered Sprites, Submersion Cyberware Bioware - All cyberware / bioware from SR4 and Augmentation Cyberparts - Limb replacements and packages Martial Arts - Artforms, Maneuvers Firearms - All firearms from SR4 and Arsenal, Upgrades, Accessories, Ammo Armor - All armor from SR4 and Arsenal, Ballistic/Impact Grades, Upgrades, Additive Armors Gear - Melee Weapons, Projectile Weapons, Explosives, ID, Communications, Electronics, Softs, Simsense, Cred Accounts, Vision Devices, Audio Devices, Sensors, Security, B&E, Survival Gear, Chemicals, Biotech, Patches, DocWagon Contracts, Disguises, and Manatech Vehicles - All vehicles from SR4 and Arsenal, Mods, Weapons Drones - All drones from SR4 and Arsenal Lifestyles - Advanced Lifestyles from Runner's Companion Background - Large cell for typing in history / notes. |
|
|
|
|
Sep 9 2008, 08:53 PM
Post
#16
|
|
|
Dumorimasoddaa Group: Members Posts: 2,687 Joined: 30-March 08 Member No.: 15,830 |
Well I normally prefer adding some gear by hand so I hope that's still viable.
|
|
|
|
|
Sep 10 2008, 07:47 PM
Post
#17
|
|
|
Target Group: Members Posts: 89 Joined: 9-August 06 From: The Sixth World Member No.: 9,060 |
In the interests of letting you all play with it, I'll go ahead and release it since I don't have time in the immediate future to polish it up. While I don't have it in a finalized format, the generator is operating pretty close to 100% and most players will notice no problems. So please, don't be too harsh in criticism, because it's not a final release. (IMG:style_emoticons/default/wink.gif)
The Gear has some sketchy code, but if all else fails, there is a general section at the end of the Gear tab which can take manual input. The manual input will still be calculated in the costs on the Main Sheet. Later tonight, I'll upload the xls file to the dropsite mentioned in Feshy's first post of this thread. So feel free to check there in a few hours. The file name will be SR4Chargen Base Beta7c.xls |
|
|
|
|
Sep 11 2008, 07:34 AM
Post
#18
|
|
|
Awakened Asset Group: Members Posts: 4,464 Joined: 9-April 05 From: AGS, North German League Member No.: 7,309 |
Tried "http://drop.io/SR4Chargen Base Beta7c" and now it wants a password.
|
|
|
|
|
Sep 11 2008, 01:03 PM
Post
#19
|
|
|
Target Group: Members Posts: 89 Joined: 9-August 06 From: The Sixth World Member No.: 9,060 |
That's weird. I'll email Feshy and see what's up with that. In the mean time, I'll also talk with FlashbackJon and see if I can get the file hosted on his site.
|
|
|
|
|
Sep 11 2008, 01:51 PM
Post
#20
|
|
|
Dumorimasoddaa Group: Members Posts: 2,687 Joined: 30-March 08 Member No.: 15,830 |
works for me at http://drop.io/sr4chargen or direct form http://drop.io/download/48c921f2/b2f656258...nbasebeta7c.xls
|
|
|
|
|
Sep 11 2008, 01:59 PM
Post
#21
|
|
|
Moving Target Group: Members Posts: 697 Joined: 18-August 07 Member No.: 12,735 |
oddly enough... ummm taking level 6 of in debt... doesn't give any money... even though it should
|
|
|
|
|
Sep 11 2008, 02:35 PM
Post
#22
|
|
|
Target Group: Members Posts: 89 Joined: 9-August 06 From: The Sixth World Member No.: 9,060 |
QUOTE (cryptoknight @ Sep 11 2008, 07:59 AM) oddly enough... ummm taking level 6 of in debt... doesn't give any money... even though it should You're right. I'll fix it ASAP and post it on the drop. |
|
|
|
|
Sep 11 2008, 03:23 PM
Post
#23
|
|
|
Awakened Asset Group: Members Posts: 4,464 Joined: 9-April 05 From: AGS, North German League Member No.: 7,309 |
QUOTE (Dumori @ Sep 11 2008, 03:51 PM) works for me at http://drop.io/sr4chargen or direct form http://drop.io/download/48c921f2/b2f656258...nbasebeta7c.xls The later timed out, but the first link indeed does the trick. |
|
|
|
|
Sep 11 2008, 04:32 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 |
QUOTE (Ryu @ Sep 11 2008, 02:34 AM) Tried "http://drop.io/SR4Chargen Base Beta7c" and now it wants a password. You are missing the slash after SR4Chargen, so it assumes you're trying to log in to a different (and non-existent) dropio page. Using the correct URL takes you to the main SR4Chargen page, and the link there works just fine. |
|
|
|
|
Sep 11 2008, 09:08 PM
Post
#25
|
|
|
Awakened Asset Group: Members Posts: 4,464 Joined: 9-April 05 From: AGS, North German League Member No.: 7,309 |
And I even wondered about the length of the filename. Doh!
|
|
|
|
|
|
Lo-Fi Version | Time is now: 27th August 2025 - 12:43 AM |
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.