Help - Search - Members - Calendar
Full Version: Ware Chart
Dumpshock Forums > Discussion > Community Projects
DrowVampyre
I just finished making an Excel sheet of all the cyber and bioware in the Shadowrun 4 book, complete with autocalculations for modified cost based on grade and running totals of nuyen and Essence (with autocalculation for bio or cyberware being higher). It's not real pretty, but it should be useful to some. However, I have nowhere to host it, so if there's anyone that would be willing to host it for me, or anyone that would be willing to test it and give me feedback, I'd really appreciate it. smile.gif
DrowVampyre
Straw Man has graciously offered to host the chart at this address. Thanks Straw. smile.gif

If anyone has any comments, suggestions, or black IC, I'd love to hear them (well, maybe not the IC).
Zolhex
well I just looked at it real quick and while the essance totals changed as i went up in grade the money totals did not change. Also cyber eyes and ears you can get some mods for free if you buy the whole eyes and ears but your sheet still added the essance cost to the total used.
DrowVampyre
...Oops. Yeah, I forgot to change the values in one of the formulas. I went ahead and fixed that, so it should total the nuyen now. I'll see what I can do about making capacity an option, but I'm not an Excel wiz, so I'm not sure how good it'll come out. But I'll give it a shot, anyway! smile.gif
DrowVampyre
Ok, I added an option for Capacity instead of Essence on the items that use it. I'll work on getting it to actually track Capacity, hopefully by location, but that'll probably take a while...
BnF95
Nice DrowVampyre, very nice. I think I was able to "pretty" it up a bit. Sort of, if you'd like, I can send you a copy.
DrowVampyre
Wow...you should check out BnF95's modifications - these make it much, much nicer. THe link is the same as before. And he says it's still a work in progress! You're a technomancer, aren't you, BnF95? wink.gif
BnF95
Hahaha, nah, but waiting for bread & pastries to finish proofing gives a lot of time sitting on my hands. So I doodle with excel.
Zolhex
WOW that does look real good BnF95 way to go. Oh and Drowvampire I was just pointing out some things for ya as you have more skill in excel than me. Not to hard to do seeing as my skill in excel is 0 hehe.
DrowVampyre
Hehe, I'm glad you did point them out, and I'm glad BnF95 knew how to implement them. It's much nicer now that he got a hold of it, and should prove quite useful - I know it has for me already.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Dumpshock Forums © 2001-2012