I have the Shocktrooper...called Assault Trooper Armor and its complexity 15, size 3.

Same for the one schematic I have for Stormtrooper.

I am receiving the same thing? Ever figure out how to fix this?

How to properly update the data all for new Shipwright items
 

Hello all, was wondering what exactly needs to be updated when adding new schematic and resources for such things as the Tie Fighter (heavy) which requires Petrochemical Asteroid and Iron Asteroid to make.

Thanks
Tharre

Ok. After experiminting with this 'JnFs_SWGCTool_v1_70_02_strongbow.zip' version I can tell that the calculations are not happening correctly for "What to havrvest today" tab.
Also Artisan still shows Bone Armor.

If I can help let me know. I would be more then happy to test any 'beta' builds of this.. :)

Anyone know of a newer build?

Thanks,
Lifere

ok.. the 'JnFs_SWGCTool_v1_66_sloejack.zip' version is same.
example:
Server: Chimaera.
'What to harvest' tab says for 'Non-Ferrous Metal SR100%' to harvest 'Alaso' (a copper)@84.8%. If you look at the 'With Summery' Tab you see that 'Dianogadoera' (an aluminum) is better-95.27%.

or am I just reading this incorrectly?

most of the guys who created this program no longer play. I know strongbow gave up playing recently as he was on intrepid and he did post that earlier in this thread sloejack is working to update a version now but it will take time the devs changed the resource stats in a patch 3 days ago slightly...

You guys need the Bio-Engineer schematics? Or do you have it covered?

oh bother, now there are new resource types that came with Rage? Have these new resource types been working into the resource tool for SWGC?

Hi Sloejack
 

I'm using v1.70.02 JnFs SWGCtools.xls without an issue and I just now downloaded the new data. What I haven't had any luck with is adding in the Asteroid resources needed for the schematics - well I take that back. I have everything working except WTH. My resources do not populate the table for some reason.

Tharre

Hey Strongbow,

First great work on your version. I just found it tonight. I have been using the latest Sloejack version another great effort.

On this we know that SWGCraft has these on the site. Would it be possible to have the took query the DB on the site to populate the resource table. This maybe could be a seperate page/update routine that you could fill in the names and tell it to update thereby quering the resources. These could then be copied to the Resource page.

This would be a great addition to the tool if it can work. Not sure if this can be queried from the site or not. I know the find resource page works like this.

Question for ya.

I'm an Architect and have been other crafting professions as well. When looking at the resource requirements for say a Deed for a Tat City Hall it totals up to 23,250 resources for one. However if you look at the schematic on the SWGCraft website, you will see that it requires over 49k Low Grade Ore alone. The tool only reports 10,800 ore. I calculated the components and included the required components in the BOM. It appears the discerpancy lies in the fact that some of the required components require components themselves and the resource requirements for the sub-components are not being calculated.

Is this something that could be looked at or would it be too much of a calculation issue? It would be great if it did for pricing options.

What is the most current version?
 

Can somebody help me answer this? Is it v.1.70.02? Are there multiple versions being updated by different peeps floating around?

JnF is Jenner and Fooman's tool, but Jenner was unable to continue supporting the tool. Since then there is Sloejack's Version and Strongbow's version, which is why there are two separate threads stickied on this forum now. Sloejack is working on updating his version, but he is also very busy in RL. The original Fooman is still around, but I haven't seen any plans for him updating his version of the software.

Ok, thank you, now I'm starting to understand the multiple thread thing. But now the question remains, which tool should I use? Is one more up-to-date than the others?

For the life of me I can't keep the versions straight. I think SloeJack's version worked faster, but if one of the others gets updated I'll be going with that one. Sorry I'm not more help, to see which version is newer you could look at first post dates on these threads. Both major versions have a sticky at the top of this forum.

Thanks for the info...I'll check those post dates. Thank again :)

An error occured while reading the data file

an area in the SWGCIMPORT is highlighted from A8 to R584



I am still recieveing this error. Has anyone else run into this and if so, how did they resolve? Please Help!

Hmm.. was the program working for you before? Are you using Office 2003?

Yup. I've been using v1.66.6 for like a year now, and it still works. It's just the new version that gets messed up. :confused:

The 1.70.2 version works flawlessly for me, and have done so since I came back to the game in March after a few months break. I used the 1.66.5 version before that, and that too worked without problems.

The issue with these tools currently is that they report wrong values on the "What to harvest today" page due to the changes in resource stat weights. This also makes them report the wrong "best" resource for a weapon in some cases.

Hopefully some Excel-gurus will make a version with the new calculations Soon(tm).

How do you use this thing, sorry i am a newb to weaponsmith.

They work fine for me as well, but that didn't help him with his problem, and he didn't answer the questions. The latest version uses commands only available in Excel 2003. I'm going to attempt to make armor on another toon.. I guess the tool won't work as well for it though :(

i went to the trouble of getting the data for the new weaponsmith schematics (minus loot), and also all of the existing ones pre-CU just in case. went to enter a few of the new ones in, but it won't show up in my schematics. anyone know what i might be doing wrong and how to fix this?

There is a button on the 'data all' sheet that updates the tool. Try that.

Is thier anyone that plans on keeping this great program going?

1.70.02 has never really worked for which is rather frustrating because the tools taht DO work in for me are incredibly helpful. Example: I select the adv Blaster power handler and it bombs out: run time error 9 subscript out of range

The code module it bombs on is as follows:

Loop
'Next step is to crawl through those types, and record all the resources that fit the bill in a
'handy array of resources we embedded in the swgSchematicSet Type. This is now searching vertically down the Resource page
'picking out all rows (resources) that fit the column.
'scan stops when there are 2 blank rows after a Resource
For i = 1 To j
k = RESOURCES_BEGIN_ON_ROW
l = 0
Do Until Worksheets("Resources").Cells(k, swgSchematic.SchematicSet(i).Column).Value = "" And _
Worksheets("Resources").Cells(k + 1, swgSchematic.SchematicSet(i).Column).Value = ""

If Worksheets("Resources").Cells(k, swgSchematic.SchematicSet(i).Column).Value = 1 Then
l = l + 1
swgSchematic.SchematicSet(i).PResource(l).Class = Worksheets("Resources").Cells(k, 1).Value
swgSchematic.SchematicSet(i).PResource(l).name = Worksheets("Resources").Cells(k, 2).Value

For y = 1 To 11 'Zip through 11 columns real fast.
swgSchematic.SchematicSet(i).PResource(l).Stats(y) = Worksheets("Resources").Cells(k, 3 + y).Value
Next y
End If
k = k + 1
Loop

Next i

Any help? This is one of my most basic Schems and I would REALLY prefer to use this to keep current.

I got that same error message after adding a new schematic to the tool. Somewhere along the way, I must've inadvertantly entered invalid data while doing it. I'd put in about a dozen new schematics and then received this error. Frustrated beyond words, I ended up re-downloading and unarchiving the spreadsheet, and had no problem - although, of course, all that work putting in new schems was lost.

Learned a lesson tho: put them in one at a time and test after each one. That's how I discovered what caused this error. I'd messed up an entry in the SPLIT column (column DG on the Data all page).. threw off the whole workbook.

If you added any new schems lately, you might wanna double-check your data entry/format on the Data all page.

Now, if only I could figure out why the download file doesn't parse correctly, I'd be a happy camper again...

I've been tinkering with armorsmith schems myself, and I think i found the problem. They added new resources to the schematics for new things, and enhancers too.

None of those objects exsists in either the NoExceptions, Required Components, or Optional Components Data. So I think we need to add all the new stuff in at least those 3 spots, you can add new schematics as long as everything they contain already exists. The download import still won't work though I don't think until the NoExceptions list is updated.

Trokk or Slowjack maybe could do up another no exceptions list, that includes the naming and format from the swgcraft database I believe to parse the resource download. Unless those match we are beat, and I have no idea how the new stuff is named in the swgcraft databases.

Trokk o DataImportFunctions code writing guru, if you could do up another NoExecptions list and email it to me I might be able to coble this back together, with help from the folks here for the new schematic information.

I may be way off on this though, who knows I haven't really spent very long looking at it yet :-)

Who's to say Trokk ever reads the WS forums ? :)

Nope no new Schems added I haven't hada chance to sit down and figure out how to add the new WS schems :(. If anyone has a copy with those in there I would be eternally grateful.

Aeron.. check your email! :)

ScyllaWS
Can you forward me the update as well ?

hello :)

i'am french and i don't speak english very well ! :(

but i'am have a probleme ! the tools is great !! but i'am armorsmith (a youg AS)
And the schematic in a tools is not a actual schematic , is a schematic of armorsmith in a pre CU !
I like this tools !

I try to modify the schematic in a "ALL DATA" , "Required Components", and " Optional Components" but i not programmer and I'am broken the tool ! :eek:

please help me :(

ps: si un canadien bi lingue peut m'aider se serais cool !


merci a tous

thank all !

if you have a update or a new version of this tools !!!! i'am your man!

Removing files from my site
 

Hi guys,

Kind of bittersweet to see activity on this thread still. I am pleased with the positive responses to the modifications I made to the tool and I am sorry I could not get it perfected during the few weeks I tried to support it, before I finally got fed up with SOE's mismanagement of Galaxies and threw in the towel. My accounts are permanently cancelled as of yesterday, after giving the ROTW and the Combat Upgrade a shot; the XP nerf in Publish 22 was SOE's last chance, despite the fact they apparently rolled it back after 6500 complaints within 24 hours on the Forums.

With regrets, I have to announce that I will be removing my versions of the SWGCTool from my Yahoo site tonight or tomorrow so I can recycle the storage space for other projects.

I wish all of you the best, and I hope the next person to pick up the challenge of supporting this tool has great success.

Catch Ya Later!

ok =)

good luck ! :)

Hints before you leave
 

Hello Strongbow,

Great work on the tool. But, please could you help me in some sense on the coding of the tool. I've successfully added new schematics for the Shipwright profession to allow asteroid resources and such. They appear in the schematice just fine but when I try to generate a WTH it does not take in any of my resources.

It really would be beneficial if you could give a clue on how that would work.

Also, with the new value system for resources can you explain the spot where the percentages to select best resources reside.

I've been trying to reengineer the code but there is so much. Any help would be appreciated.

Tharre

update for AS ans SW
 

hello !

if a player have a update for the JnF's swgc !(new shematic for AS)

i want this update

thank you


(sorry for my english)

Strongbow,

I've been using this tool for the last week or so and its great. Even though you are dropping support of the project, I have mirrored the download here so that others may still use/learn from this tool. This is only v1_66 however. If anyone has v1_70 please let me know so I can get it mirrored!

If you would like to update your orginal post with the new link please feel free to do so. If you decide to continue work on this project, I would be happy to provide webspace for you!

Thanks!,

- Lel

Hi all,

I missed downloading v1.70 and would very much like to get a copy of it. I'm still using the v1.66 without CU updates and would appreciate any help I can get.

If someone can please e-mail me the update (braddajon@yahoo.com), I would greatly appreciate it.

Thanks,
Gaarakkatarxyy :eek:
Naritus

I didn't know there was a 1.70.2

Wouldn't mind getting my hands on a copy as well.