SWGCraft.com Forums

SWGCraft.com Forums (http://www.swgcraft.com/forum/index.php)
-   Weaponsmith Discussion (http://www.swgcraft.com/forum/forumdisplay.php?f=17)
-   -   JnF's SWGC Tool v1.66.91 (http://www.swgcraft.com/forum/showthread.php?t=16080)

Kelloch 05-07-2005 12:57 AM

Quote:
Originally Posted by Zenedra
There, I have now completed the AS schematics for Sloejack to start converting into the tool. Haven't been able to get all the stats (complexity, size and such) to the faction armors though, if anyone else can provide him with that? It will shurley be a while before I can get my hands on those schematics. They cost a small fortune in fps. Ohh well, just wanted to give you all a heads up on the AS part.

Take care all


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

Same for the one schematic I have for Stormtrooper.

Shai-tan 05-09-2005 07:50 AM

Quote:
Originally Posted by pangelo
ok, fixed that, then got the following


An error occured while reading the data file

an area in the SWGCIMPORT is highlighted from A8 to R584


any ideas now???



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

Tharre 05-11-2005 01:51 AM

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

Lifere 05-13-2005 02:23 AM

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

Lifere 05-13-2005 02:34 AM

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?

Zefrin 05-13-2005 03:54 PM

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...

Banzai51 05-16-2005 04:28 AM

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

Sloejack 05-17-2005 04:38 PM

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?

Tharre 05-18-2005 03:31 AM

Hi Sloejack
 
Quote:
Originally Posted by Sloejack
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?



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

toka 05-20-2005 04:09 AM

Quote:
Originally Posted by Strongbow
I'm not sure I follow the question...

If you are asking if I have a database of the old extinct resources to use as source material, then the answer is no. Whenever I obtain resources that are not in the current spawn, then I have input them by hand.

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.

toka 05-20-2005 04:17 AM

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.

ckclyde 06-05-2005 05:23 AM

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?

dexeter 06-05-2005 05:49 PM

Quote:
Originally Posted by ckclyde
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.

ckclyde 06-06-2005 09:27 AM

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?

dexeter 06-07-2005 02:48 AM

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.

ckclyde 06-07-2005 02:50 AM

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

Shai-tan 06-10-2005 01:38 AM

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!

dexeter 06-10-2005 06:48 AM

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


Quote:
Originally Posted by Shai-tan
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!

Shai-tan 06-17-2005 04:23 PM

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:

Arkel 06-17-2005 09:31 PM

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).

Iapac 06-18-2005 09:14 PM

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

dexeter 06-19-2005 08:34 AM

Quote:
Originally Posted by Arkel
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).


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 :(

Jaysc Zeann 06-28-2005 08:01 AM

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?

RawlingsSc 06-29-2005 03:13 AM

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

Alanis 07-14-2005 02:04 PM

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

aeron 07-27-2005 07:48 PM

Quote:
Originally Posted by dexeter
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 :(

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.

ScyllaWS 07-27-2005 09:22 PM

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...

Vandal 07-28-2005 12:36 AM

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 :-)

dexeter 07-28-2005 08:12 PM

Quote:
Originally Posted by Vandal
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 ? :)

aeron 08-04-2005 02:29 PM

Quote:
Originally Posted by ScyllaWS
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...

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.

ScyllaWS 08-04-2005 04:47 PM

Aeron.. check your email! :)

Bantha_Racer 08-04-2005 06:40 PM

ScyllaWS
Can you forward me the update as well ?

rikofou 08-18-2005 04:30 PM

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!

Strongbow 08-19-2005 10:58 PM

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!

rikofou 08-20-2005 04:13 PM

ok =)

good luck ! :)

Tharre 08-21-2005 04:06 PM

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

rikofou 08-23-2005 10:00 AM

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)

Lelena 08-23-2005 06:14 PM

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

BraddaJon 08-23-2005 08:41 PM

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

Stohn 08-23-2005 11:48 PM

I didn't know there was a 1.70.2

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


All times are GMT +1. The time now is 08:33 PM.

Powered by: vBulletin Version 3.0.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.