Jedi Schematics and Resource usage
 

I dug this up from the galaxies forums:

Jedi FAQ

From what I have seen so far in my own saber crafting, these values are correct.

Any chance of getting them added to the tool? Or telling me how to do it myself?

SECTION 3: LIGHTSABER RESOURCES

Training Lightsaber:

COMPONENT________________RESOURCES____________1HAN D
Emitter Shroud___________Mineral_________________10
Primary Crystal__________Refined Crystal Pack_____1
Activator Mechanism______Metal___________________10
Handgrip_________________Chemical________________1 2
Focusing Crystals________Refined Crystal Pack_____1
Power Field Insulator____Gas_____________________10
Cycling Field Energizers_Metal___________________10

First Generational Lightsaber:

COMPONENT________________RESOURCES____________1HAN D___2HAND_DBL-BLD
Emitter Shroud___________Mineral_________________15______2 0______25
Primary Crystal__________Refined Crystal Pack_____1_______1_______1
Activator Mechanism______Metal___________________14______19_ _____24
Handgrip_________________Chemical________________1 7______28______40
Focusing Crystals________Refined Crystal Pack_____1_______1_______1
Power Field Insulator____Gas_____________________20______30___ ___40
Cycling Field Energizers_Metal___________________14______20_____ _40

Second Generational Lightsaber:

COMPONENT________________RESOURCES____________1HAN D___2HAND_DBL-BLD
Emitter Shroud___________Metal___________________25______2 5______30
Primary Crystal__________Refined Crystal Pack_____1_______1_______1
Activator Mechanism______Non-Ferrous Metal_______18______18______42
Handgrip_________________Inert Petrochemical_____20______20______20
Focusing Crystals________Refined Crystal Pack_____1_______1_______1
Power Field Insulator____Known Inert Gas_________22______22______42
Cycling Field Energizers_Non-Ferrous Metal_______20______20______42

Third Generational Lightsaber:

COMPONENT________________RESOURCES____________1HAN D___2HAND_DBL-BLD
Emitter Shroud___________Ferrous Metal___________35______35______35
Primary Crystal__________Refined Crystal Pack_____1_______1_______1
Activator Mechanism______Titanium Aluminum_______20______20______28
Handgrip_________________Polymer_________________2 5______25______44
Focusing Crystals________Refined Crystal Pack_____1_______1_______1
Power Field Insulator____Culsion Inert Gas_______25______25______45
Cycling Field Energizers_Polysteel Copper________25______25______45

Fourth Generational Lightsaber:

COMPONENT________________RESOURCES____________1HAN D___2HAND_DBL-BLD
Emitter Shroud___________Duralloy Steel__________40______40______40
Primary Crystal__________Refined Crystal Pack_____1_______1_______1
Activator Mechanism______Titanium Aluminum_______22______22______30
Handgrip_________________Polymer_________________2 8______28______46
Focusing Crystals________Refined Crystal Pack_____1_______1_______1
Power Field Insulator____Culsion Inert Gas_______28______28______58
Cycling Field Energizers_Polysteel Copper________28______28______58

Lightsaber Experimentation:

Experimental Damage:
Attack Speed = CD 50%, OQ 50%
Maximum Damage = CD 33%, OQ 66%
Minimum Damage = CD 33%, OQ 66%
Wound Chance = SR 50%, UT 50%
Experimental Efficiency:
Attack Action Cost = OQ 100%
Attack Health Cost = OQ 100%
Attack Mind Cost = OQ 100%
Force Power Cost = CD 33%, OQ 66%

Lightsaber Crafting Toolkit:

Resources:
COMPONENT___________RESOURCES__TOTAL
Assembly Enclosure__Metal_________10
Thermal Shielding___Mineral________6
Control Unit________Chemical_______8
Experimental Effectiveness:
Quality = CD 100%

A Refined Crystal Pack:

Resources:
COMPONENT_______________________RESOURCES__TOTAL
Module Housing Assembly_________Steel_________10
Ultrasonic Vibration Generator__Gemstone______20
Conductive Circuit Assembly_____Copper_________6
No Experimental Properties

When I was swimming through the code I found this

Worksheets("WTH Summary").Range("G7:Q61").ClearComments
For i = 7 To 61

This may be why you guys are being limited to 61 listings. Then again maybe its just a coincidence. You can find it under modules under WTHTGenerationFunctions. Change it and see if it helps. You could search for that on that page, or just go to the bottom (Its about 13 lines from the bottom).

g'luck

I tried it. Nothing. I uped it to 90 and saved it. Closed it, re-loaded and re-downloaded new resources. No dice. But maybe there is more.

I'll add the jedi schematics tonight and push em out later. Thank you for the info. Do you know if these are general for ALL jedi, or are there any crafting specific things to whatever jedi subtypes there are?

As for the resources download and WTHT and summary I'm taking a look at the whole resource retrieval, parsing, and publishing system. This will take some time since it is clear there's a lot that needs to fixed in this area and frankly my VB sucks and is unfortunetly improving. Did I mention I could write this whole thing in perl easier?

You have done an amazing job. Any help in the absence of the Fooman / Jenner is much appreciated. If I knew anything about it I would help ya. I did a search of all of the 61's in the WTH Summary. There are 3. I changed them all to 81 and nothing. Does this need to be re-compiled or anything after changing code?

The schematics are the same to all Jedi types since they are share the same skill boxes and trees now. No additional schematics are granted to Dark/Light Jedi Knights and higher ranks, they only get increased abilities. The Schematics are granted as follows:

Jedi Initiate: Lightsaber crafting tool, Enhanced Crystal pack, Training Saber

The rest of the schematics are obtained as a Padawan

Novice Lightsaber: First Generation One-handed Saber, First Generation Two-handed Saber, First Generation Double-Bladed Saber

One-Handed Saber 2: Second Generation One-Handed Saber

Two-Handed Saber 2: Second Generation Two-Handed Saber

Double-bladed Saber 2: Second Generation Double-bladed Saber

One-Handed Saber 4: Third Generation One-Handed Saber

Two-Handed Saber 4: Third Generation Two-Handed Saber

Double-bladed Saber 4: Third Generation Double-bladed Saber

Master Light Saber: Fourth Generation One-handed Saber, Fourth Generation Two-handed Saber, Fourth Generation Double-Bladed Saber

Hope this helps, and thanks for helping to keep this great tool update!

Dracul Sturm

Intrepid

Yes, that will help. I'm still digging into the WTH stuff. I'll have a new version with these schematics and a determination if I can fix the VBA associated with DLing resources from SWGC and parsing into the WTHT and WTHSummary sheets.

Ok, taking a break from the parsing issue, I'm looking at the WTHSummary. In reading the code, I believe I understand what it's doing. In looking at my 'default' spreadsheet it appears to work as expected. However, I would appriciate it if one or two of you who are having issues with the WTHSummary sheet would contact me so I can get a copy of your tool and troubleshoot it against something that isn't working.

To this end, let me explain what I think I understand and perhaps this may solve what may look like a problem but is not for some.

The GenerateWTHSummary function looks at the WthT sheet.
The first thing it looks for is what value you have in column E (X, 1, or 2) and based on that it decides if each resource listed on the WthT sheet should be pushed to the Summary sheet using the following formula:

Once the tool has generated this list, it then sorts the list and runs through it one more time (inefficient, but that's a different story) and trims out the duplicates. It then takes the information from SWGCparsed and fills in the rows with the information about the resources from the list of resources.

For single professions, you probably never encounter any problems with this sheet. For professions that have many unique resource requirements (weaponsmith being on the biggest ones in this regard) combined with one ore more professions that also have a fair amount of special requirements, you could run into a possible hard limit that some people are mentioning.

For multiprofessions you may want to cull that list somewhat using Column E since for some of your resources, specifically the unique/special ones, you may want to use a 1 instead of an X since you generally only want to harvest something better than what you have. For the generics I can see using an X. Not sure if this will help or not, but it is a general usage suggestion that can only help in the long run when you're trying to determine which of your precious lots to use on what.

Now, all of that being said, I don't have a solution yet, just validating that I understand the problem. Oh, and one other thing, it's not that you're only seeing 61 out of 61+ resources, you're actually only seeing 55 out of 55+ resources the tool thinks you should be harvesting

Thanks to some help from Backstop I believe I've resolved the issue with the WTH Summary sheet and trying to summarize more than 55 resources. The question I present to you now is how many do you think is reasonable? I was thinking about adding in 20 more for a total of 75 potential summarized resources. The alternative would be to go what I would concider extreme and have enough room for 100 possibles on resources you should harvest.

As I mentioned before, regardless of which way this gets fixed, I recommend that as a user you look at the What to harvest Today sheet and spend some time prioritizing the resources there to make the WTH Summary more meaningful to you, by not doing this, you're likely to get suggestions to harvest stuff that may not really matter to you at all.

I'm glad my blundering through the tool helped.
I take it you are referring to the options column when you mention prioritizing. I will play with that some now to see what it does. How about 80. That should hold most of us (even those not prioritizing :) )

I tried changing all the x's to 1's and it cut the WTH Summary in half. The only problem with that is that after I generated the summary the 1's reverted back to x's dow to line 107. Is ths normal???? :confused:

Disregard this...the copy must not have worked...second time through it worked.

I've pushed out a new update. See the first message in this thread for change information. Since there was a visual change to the Schematics sheet I would appriciate some feedback on if the new location of the notes box is good, bad, or doesn't matter.

I tried 1.66.5 and got a filename error on the resource download. Bria galaxy. also got it on your default ahasi galaxy.

I could not replicate this problem. I was able to download the current listing for both Bria and Ahazi

Oops I think. I think it was just a misleading error message. I hadn't changed the location of the download file, and since I don't have a folder named C:/temp I got the error message.

There is a problem with some of the Shipwright schematics. The Missle Packs to be precise. They are listed in the tool as using OQ and CD when they actually use OQ and PE, I think the percents are still 50-50. I will check next time I log in. If they are not 50-50, I will post another reply. This is true for ALL the missle packs all Mark levels. The resources used are correct.
I changed the stats in the Sata All sheet on my copy, Just thought you would like to know for any next update.

Is this in all areas of experimentation? Assuming so, I'm not sure if that was bad data entry or a change in crafting for shipwright. Either way I'll make the adjustments once I get confirmation on what needs to be changed.

Just thought id mention that the tool seems to be running a lot quicker on my slow machine, so whatever you did, nice one!

Keep up the good work.

YES
The only stats shown in game are now OQ PE for all stats for all missle packs.

Cool, thank you. I'll post an update this evening since there are some other changes/fixes that have been made to the tool.

The resource requirements and tier info for the IFF Confuser and EM Emitter are reversed.
Actual Requirements:

IFF Confuser Launcher - Tier III - Steel 1875 Radioactive 625
IFF Confuser Pack - Steel 1000 Metal 250

EM Emitter Launcher - Tier IV - Steel 3750 Radioactive 1250
EM Emitter Pack - Steel 2000 Metal 500

Nice work Sloe!

Fooman Lives. :)

From you sir, that is indeed a complement. :) I have to wonder though why you stopped your own development on 7.0? It looked to be coming along well and you had already solved some of the isses I'm running into now with trying to adjust the tool to work with JtL.

I've pushed out the current update, see the first post for change details

I just downloaded v1.66.6, but why are ALL of my resources showing up blue? Its as if the tool thinks they are all specifically named required resources.

Oh, and maybe its just me but i get the impression its faster still, grats!

EDIT: hmmm, strange. I made some personal changes to the tool (mostly formatting changes actually, to make it look nicer and easier to use). It seems to have sped the tool up no end, but also broken some things (like the blue coloring).

I think ill try and look into the code a bit. I have no experience with VB, so wish me luck...

Did you just backup your resources from the old tool and import them into the new one? None of the changes I made should have caused this. You may be able to clear it up by reconfiguring the tool. No need to select new professions, but since the configure tool button also adjusts your 'required' list it should/might clean up your resources sheet.

On the topic of tool speed
 

There have been a few folks that have mentioned that the tool seems to be working faster than it did in the past. I've thought about this for some time and can only deduce that this is because many of the errors that the tool calculation and parsing routines were encountering have been and are being reduced in number. This makes some amount of sense in that it's not searching for things that are no there (thanks to a typo) and and general behaving better in a way that seems faster.

So, I thank you for the praises regarding the speed improvements but honestly I've done nothing more than apply an editors eye towards the tool and implemented suggestions and changes in those areas that were provided by others.

One of the biggest speed issues, that I think you all will agree with, is the presenting of the schematic sheet when a schematic is chosen or any changes to experimentation or resources used are made on that sheet. Since this is a core functionality issue my new goal (even though I swore up and down that I wouldn't do this) is to try and re-write those routines and reduce the number of calculations the tool is having to do when the sheet changes.

All this because I can't insert an eighth resource into a schematic. Let this be a lesson to those of you who would pull on the loose thread.

Choosing Profession Problem
 

First let me say Great Job to all involved!!!!!! :)

Now for my problem. Just loaded up 1.66.6, imported resources, chose professions. When I choose professions it says no professions/schematics chosen. The professions are listed in the right side of the box. I removed all the professions and put back and still says no profession/schematic chosen. And as in a previous post all of my resources are blue. But I assume that is because no profession is active. Anyone else experience this?

Sloejack if you'll remember my post in the Jenners tool thread its because of the Split column in the Datall table...if there are 2 experimentation choices like first one is 50%OQ 50%cond and the second is 50%OQ 50%PE then you need to make the value in the split column 50;50;0;0 if all 4 are used 25;25;25;25 etc...This will balance the Quality looked for...like on Avian meat for Docs it was at 100;0;0;0 and because of that only OQ and PE were considered for avian meat...but Decay Resistance is very important...by changing the Split column to 50;0;50;0 (the second attribute was OQ only the third attribute was the OQ/DR) My tracker comes up with better choices for avian meat for all my Enhance packs.

I suspect there may be an issue with the resources you inserted into the tool but can't really provide any guidance since I'm not aware of a repeatable scenario that would generate a "no schem/prof" error. For troubleshooting, I would clean out the resources sheet so that you have no resources in the tool and then configure and see if you're still getting the error. If you are, then I'll need you to send me your copy of the tool and I'll see if I can figure out how it broke. If on the other hand, removing your resources does allow you to configure the tool without error, then the issue is definetly in the data you inserted.

I have a problem with the schematics page at the moment.

I've been using Fooman/Jenner/Sloejack's tool for a long time now (beta tested version for Fooman and Jenner) but it's possible I'm missing something simple.

I've got weaponsmith, artisan, medic, doctor and jedi schematics enabled on the tool. I have all my resources entered OK (or appear to be).

I select a ship blueprint to make and in the different type of steel available to be used it only lists 5 types of steel. I have a total of 20 different steels with the "use as generic flag set", all these steels should be considered as I'm using "use all resources" and haven't set any of them to be filtered via column C anyhow.

Is this a bug or am I missing something somewhere?

I suspect it's providing you the top 5 based on the schematic and your experimentation options.

Other resources, such as inert petrochemicals, list more than just the top 5.

Ok, let me rephrase since I may not have been clear the first time. Based on the schematic, and the experimentation options you have set, the ranks you are able to select are based on the tool determining that those resources fit that schematic requirement. If you'd really like to melt your brain and see exactly how this is being done, you'll want to look at the Macros in the workbook for configuring the tool and for filling in the schematic sheet. For your steel, this is apparently the top 5, for the other resources, it depends on how many of them met the requirements. You can see which ones meet for the current schematic if you unhide column AK on the Resources sheet and look for the entries with a 1 in their cell on that column. By selecting the cells in that column, you'll also see the formula used to determine if a resource fits or not.

I'll take a peek at column AK but I'm avoiding looking behind the big curtain (aka macros workbook). I'm a software engineer but I'm not a VB/Excel expert....

hi,

fist of all thank you Sloejack for updating Jenners Work

I know you might not have the capabilities to shoot out a 1.7 but still
i have to say that i dont have time to read all the pages in case my issue has alrdy been addressed.

im using jenners since 1.63 and never had any bigger problems. since 2 weeks now my 1.66 doesnt seem to update the CSV even if its says that it was downloaded. i checked this on my second computer as well as with version 1.63 and 1.64. so i tried to run 1.66.6 and the download works BUT if i try to restore my backuped resource list its giving me weired infos on the stats in the WTHT column. i get like -356% or +682% or the for eg the carbonite steel lane is giving me a "#####" instead of showing me the maximum experimental value.

How i do it:
- download 1.66.6
- configure tool(im a WS so am using the default), switching to may GAL and directory
- restore my backuped (from 1.66)
it doesnt matter then if i make a "update tool" or not, i alrdy get the weired amounts % ..
i also tried different ways like , deleting my old zib.dll, or first download the new CSV and such..


Any suggestions? im really down right now, this tool used to be my favorite prog about SWG..


regards,

-Eky
+12XP/+25ASS WS
Gorath

i found a workaround finally...

- downloaded 1.66.6
- restored backup list
- updated tool
- downloaded CSV
- removed WS from the list under "configure"
- updated tool-
- added WS to the list

et voila, all resource showing in correct percentages again :cool:

Downloaded New File Same Problem
 

OK. I deleted the 1.66.6 that I had. Downloaded a new one. Opened it and the weaponsmith schematics were there, I then went to Control Panel then Configure tool. Added Doctor click OK...... No professions/Schem chosen. Go to schematics and there are none. Am I the only one having this problem?
I am using Excel 2002 SP3.

Heh, that makes two of us, but I'll play one on TV :)