Gear builder, And other time saving files Options

[Chrysalis]

Hi,

I will see what I can do next week. I would prefer on adding them all at the same time.

-Chrysalis

[Chrysalis]

Well, I finished updating to a new version. That version can be found not only at the top of the thread, but also here as well:

See below

I basically added Magical Gear from Street Magic.

Edit: Some minor changes done.

[Chrysalis]

This is a version I was working on yesterday.

http://www.2shared.com/file/3451959/fab7f8..._160608-02.html

I am not sure if it is better or not. The big difference is that of firearms marked down as they are. One issue I do have is that it seems to be too much information and a bit cluttered.

What do you think?

To be honest I feel like I am talking to myself.

-Chrysalis

[RobertB]

You are not talking to yourself. I, for one, plan to put your builder to good use. Unfortunately, the gear tables in Magic in the Shadows do not include the magical gear from the base book. Thanks again.

[Chrysalis]

Which gear is the excel sheet missing? The only one I found was spell formulae.

Lodges have already been added and they can be found under facilities, shops, and kits. Same as with magical kits.

-Chrysalis

[Dumori]

Something that might be worth adding is nanowear and the none essence effecting stuff in augmentation that your missing I think theres some. As these aren't in most char gen equipment sections.

[Chrysalis]

Added a few things I missed such as spell Formulae and page references for magic. Added gear related nanoware and medtech from Augmentation.

Have I reached that magical glass ceiling? Is there anything more to add?


-Chrysalis

[Dumori]

Thanks Chrysalis I will have Feedback from my runners after today as I'm running 1on1s with them there all new to the game to get them used to stuff your gear tables will help loads. BTW lets hope unwired is kind to you youve done loads allready. Your work is amazing. A grate time saver for my prime runners (all its be used for yet).

Edit
your miss form what i can see the genetic transfusions and nanowear both of witch are expendable and drug like except in certain situations.

I would add my self but I suck at excel and I'm unsure on you how you've linked all your sheets and cells together

P.s are Drugs awakened and other wise on the sheet? I cant remember finding them. Also there is error on the sheet using moneys although a correct word replacing it with nuyen, cash or money available sound better to me and works better (at least in my understanding of UK English) . But you've mentioned that you are/worked as an editor/proofreader and thus I am unsure about this "mistake". Please forgive any offense I may have caused I know what its like when people point things out that are fine to you due to a misunderstanding or ignorance on their part.

This post has been edited by Dumori: Jun 18 2008, 07:48 AM

[Chrysalis]

Moneys or Monies are pecuniary sums. To see definition of pecuniary:
http://dictionary.reference.com/browse/pecuniary

Basically it is a way of differentiation that there are several sums of money involved.

Drugs can be found under Biotech, Chemtech, and Genetech.

[Dumori]

Ah I still dislike the word Moneys even understand it its context its just clunky but that isn't the point of this.

Cool looks like the gear builder is done much help today by the way saved munching though all 4 book while making a Technomancer.
I cant think of any thing it needs other than the custom weapons and vehicles pages being more streamlined or explained I don't really get how they save time. My player are even less excel literrate than me so help is needed.

[Chrysalis]

The problem is that weapons contain mods when bought and can be further accessorized.

That's the general weapon accessory list given. Really for weapon mods or accessories to be of *any* assistance it would demand that they were developed better. I would really have to come up with a magical excel sheet that would give:
1. Weapon and mods
2. Drop down list of what mods you can use.
3. What accessories you can then use.

This is a process that can be done with an eyeball but would demand many, many hours of work to develop.
I am not saying it is impossible, I am asking if there is actually a need for it.

-Chrysalis

[Dumori]

I would say yes as the cost modifiers can get a bit hecktic some times. actually how would one deal with mulitpul weapon cost X n mods I assume they'd add up (weap cost x6 and a weap cost x 2 would equal a weap cost times 8)but I'm unsure. Btw if you need help compiling data for the new project Im happy to help. Ah the joys of unemployment and time between education.

[Chrysalis]

I would need to have the weapon mod tables copied into excel. Very easy all one needs to do is copy each value into a different cell. Once done I can take that information and perform a bit of magic on.

I do have to say that some prices do not make sense. I will show you once it is done. There are several ways in which the data can be used in forming a weapon builder excel sheet.

-Chrysalis

[RobertB]

Maybe I'm missing them, but I don't see any of the items listed under Foci, Magical Supplies, or Fetishes on page 340 of the main rules. Specifically:

Foci Availability Cost
Spellcasting Focus (Force x 4)R Force x 15,000¥
Counterspelling Focus (Force x 4)R Force x 5,000¥
Sustaining Focus (Force x 4)R Force x 10,000¥
Summoning Focus (Force x 4)R Force x 15,000¥
Banishing Focus (Force x 4)R Force x 5,000¥
Binding Focus (Force x 4)R Force x 10,000¥
Weapon Focus (Force x 5)R Force x 10,000¥
Power Focus (Force x 5)R Force x 25,000¥
Magical Supplies
Spirit Binding Materials (Force x 2) Force x 500¥
Magical Lodge Materials (Force x 2) Force x 500¥
Biofi ber (Force x 3) Force x 100¥ per sq. meter
Fetishes
Combat 8R 200¥
Detection 2 50¥
Healing 2 500¥
Illusion 2 100¥
Manipulation 6R 300¥


Am I crazy? (IMG:style_emoticons/default/smile.gif)

[Dumori]

I have found a few errors C38 on Accounting & Totals is =SUM(C20:C34) not =SUM(C17:C34) as it should be. You are missing kits for other skills as in all kits cost 500 shops 5000 and facilitys 100000 this mean that build like the weapon specialist can not be built in the gear builder. Also life style cost are lacking any list I dont know if this an over sight or not. Ill get back to you on any other problems I find

Edit
I looks like the weapons an munitions are not showing up in the accounting page. Not sure why.
Edit to found you why looks like the total was set for =SUM(L8:L157) not =SUM(J8:J157) .

This post has been edited by Dumori: Jun 18 2008, 11:57 PM

[Chrysalis]

Hi RobertB and Dumori.

Thanks for the feedback. I think you will like the next version.
http://www.2shared.com/file/3464157/63620e..._190608-03.html

Missing Magical Items from SR4's page 340 have been added to the list.
Any item mentioned as being calculated by tool size now is under Kits, Shops, and Facilities. I have also added a few extra lines with the generic prices for Kits, Shops, and Facilities.

Weapon mods have been added.

I've added all of the lifestyle information, including team lifestyles and a starting cash calculator.
For ease of finding SINs, Licenses, and Credsticks it is now its own spreadsheet.

Noted mistakes in calculations have been fixed.

[Dumori]

Cool already testing it. Looks like you've made the most useful spreadsheet on dumpshock. One flaw starting money is taken off the budget not added on/ignored. The last thing certain weapon stats have been changed in etarte as in my 5th printing core book my (f) stats are all +5 not +2 I think that is the last thing.

[Chrysalis]

New version out. Updated Drugs with Duration and Effect and Toxins with Vector, Speed, Penetration, Power, and Effect.

-Chrysalis

[Chrysalis]

So what's next?

-Chrysalis

[Cadmus]

So what's next?

-Chrysalis

ooo weapon mods? I love you! any one working on a desent sheet for building vehicles and drones? granted the weapon mod section you have no idea how many trees you have saved from being turned into note pads (IMG:style_emoticons/default/smile.gif)

[Dumori]

There is already vehicle one ill try to find the URL i got it from for you.
http://skitzinc.wikispaces.com/Files this is the one i use
there is also http://forums.dumpshock.com/index.php?showtopic=21180

[Chrysalis]

I have an updated version with the few missing items from Arsenal, but before I release it I need for their to be commentary on the existing one.

[RobertB]

Well, you asked. (IMG:style_emoticons/default/smile.gif) How about a sheet that gathers all the items you selected, groups them into categories that match the tabs of the workbook, and formats them for easy printing? The printed sheet would include the relevant ratings and prices that are defined in the workbook.

[Dumori]

That would be cool but IDK how it could be done. unless you looks for entered amounts.

[Chrysalis]

A quick look at excel tells me that the easiest way to do this is actually by copying the header row and the item row.

Otherwise I would have to use VBA or macros. Not easy to do.


-Chrysalis