SWGCraft.com Forums

SWGCraft.com Forums (http://www.swgcraft.com/forum/index.php)
-   Weaponsmith Discussion (http://www.swgcraft.com/forum/forumdisplay.php?f=17)
-   -   Sloejack Mods to JnF's SWGC Crafting Tool v1.66 (http://www.swgcraft.com/forum/showthread.php?t=13865)

Sloejack 11-10-2004 01:20 AM

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

Hmm, that's an interesting issue that I can replicate and yet I'm not sure of the cause. This may have something to do with removing the excess professions that were not actually crafting professions ([Dark] Jedi Knight, etc.). The simple work around that I've been able to find is to unconfigure weaponsmith from the tool, you'll get the no schematics error since no professions are selected, and then to configure in the professions you want. I'm going to test a few more things and most likely push out 1.66.7 later tonight with no default profession selected. The only significant changes between 1.66.6 and .7 are some minor weaponsmith schematic updates. I have not yet had an opportunity to work with someone on updating the medic/doctor/CM schematics.

miceless 11-10-2004 01:39 AM

Quote:
Originally Posted by Sloejack
I have not yet had an opportunity to work with someone on updating the medic/doctor/CM schematics.

What do you need? I am Medic and CM, used to be a Doc.

Sloejack 11-10-2004 02:08 AM

Quote:
Originally Posted by miceless
What do you need? I am Medic and CM, used to be a Doc.

Just need someone to walk through the schematics for those professions and validate resources and experimentation. There was a message in the previous thread the suggested the tool was not accurate as far as those schematics were concerned. The easiest way to do it (For me at least) would be to take whichever version of the tool you currently use and update those schematics on the data all sheet and then email me your version of the tool and I can drop in the updates.

Sloejack 11-10-2004 02:14 AM

Ok, I've pushed out v. 1.66.7 that would seem to resolve the issue with selecting additional professions when first using the tool. There were some other minor updates but at this point I suspect that is all there will be. I've started working on a re-write but it's a fairly daunting task trying to understand the logic/formulas used in what Fooman and Jenner wrote and then trying to determine if there is any way to optimize the use of data to make the tool more efficient. On top of that I'm trying to add my own enhancements like an updated available resource report and schematic view as well as just general interface improvements.

miceless 11-10-2004 09:36 AM

Quote:
Originally Posted by Sloejack
The easiest way to do it (For me at least) would be to take whichever version of the tool you currently use and update those schematics on the data all sheet and then email me your version of the tool and I can drop in the updates.

Ill see what i can do.


Quote:
Originally Posted by Sloejack
I've started working on a re-write but it's a fairly daunting task trying to understand the logic/formulas used in what Fooman and Jenner wrote and then trying to determine if there is any way to optimize the use of data to make the tool more efficient. On top of that I'm trying to add my own enhancements like an updated available resource report and schematic view as well as just general interface improvements.

Keep up the good work Sloejack, im sure you will get there in the end!

Caelestra 11-10-2004 08:56 PM

I'm suddenly having a problem with the % difference to current in the WTH tab. I just updated to .7 and imported my previous tool's data. When I download, everything works, the new resources populate, but the % difference fields don't calculate... I hate to have to do that math by hand, I'm a WS and SW, so I'm tracking hundreds of resources already.

-Cael

Kithron 11-10-2004 09:03 PM

Aye, same problem here as Caelestra. I tried pulling out WS and putting it back in after updating, etc. etc. But its just not calculating the % difference in the WTHT tab.

Neelak 11-11-2004 12:55 AM

Quote:
Originally Posted by Kithron
Aye, same problem here as Caelestra. I tried pulling out WS and putting it back in after updating, etc. etc. But its just not calculating the % difference in the WTHT tab.


I just came here to post on this subject. I was going to say that the formulas from columns K, P and X from the WTHT sheet have been missing from all of the tools pushed by Sloejack. The formula's can be copied and pasted from any one of Jenner's tools and it seems to work.

Although when new resources are added there are sometimes blanks in these columns. I was wondering whether the formulas are supposed to be inserted by one of the macros. I have not had a look at that.

Great work Sloejack. Looking forward to seeing the next revision.

Neelak 11-11-2004 08:29 PM

WTH Summary
 
The formulas in column F of the WTH summary sheet are not quite right.

The reference to the WTHT sheet should be as follows.

'What to harvest Today'!$U$3:$V$1500

Not a major problem this one :)

Sloejack 11-12-2004 03:18 AM

Hmm, The reason for the formulas disappearing on the WthT sheet in columns K, P, and X appear to have to do with the fact that the tool doesn't have a default profession configured. In looking at the code, apparently it copies the existing formulas before rebuilding the page. since there were no professions, and therefore no schematics, it never pasted the data back in. So in future usage when you configure a profession, there's no formulas to copy and hence the missing percents.

As for the formula in Column F on the WTH Summary sheet, I'm not sure you want to make it to 1500. Not that this won't work, but you're making the search range a bit larger than it needs to be. The net impact is that if it's searching a large range than it needs to, it slows the tool down.

*edit* Never mind this drivel, I see that the other cells do a similar thing, this is just one of my efficiency beefs. Not sure why that formula got fixed at 148, but I made the adjustment in the .8 version

Now, back to the original issue. There appears to be a link between the WTHT and Data All sheets. Attempts to just try to get the formulas plugged back into the WTHT sheet have caused the profession chooser to break by throwing the no schematics selected error. I'll keep plugging away at this, but it appears to be turning into one of those loose thread on a sweater problems :(

I believe I've resolved this issue now and am pushing out a .8 version. For future reference it seems that whenever you have a "no profession/schematics chosen" error, the quick fix is to unconfigure the tool, and then push the "Update Tool" button on the Data All sheet. After that, go back and configure the tool normally and things seem to work fine again. Weird.

Kithron 11-12-2004 06:21 AM

Issues seem resolved in .8 fantastic work and kudos to you for taking the ball and running with it so well in the absence of Jenner and Fooman. Everyone in the SWG crafting community appreciates your effort.

Neelak 11-12-2004 07:08 PM

Hiya

Cell A6 on the hidden "Optional Components" sheet should read:

No Combat-Capable Service Module

not

No Combat Capable Service Module

Cheers

Neelak 11-13-2004 03:55 PM

Quote:
Originally Posted by Neelak
Hiya

Cell A6 on the hidden "Optional Components" sheet should read:

No Combat-Capable Service Module

not

No Combat Capable Service Module

Cheers


OK... you need to do a search and replace for the above on the "Data All" sheet too, because some entries have the hyphen and some don't.

Neelak 11-13-2004 04:04 PM

The following makes absolutely no difference to the end result... but....

Cell DE62 should read

Armor Padding

not

Padding Segment

:-)

Martan 11-16-2004 04:58 PM

Blessing
 
I have just downloaded this 1.66.8 and look forward to using it. Thank you so much for doing that I have been look forward to someone doing what you have done (including Jedi and Shipwright) for a while.

Thank you,

Carled Widar 11-22-2004 05:51 PM

Hiya Sloejack,

I looked into the vb stuff and found why I was only seeing 5 type of steel on my schematic page. There's a CULL value defined in there that was set to 5, changing it to 10 meant I started to see 10 candidate steel types, the trade off being time to produce the list of candidate resources I expect.

I know you're looking into reworking a few bits at the moment, like handling 8 resources rather than the current max of 7 so the master level ship schematics work properly, but I've something for you to look at/direct me towards the right bit of functionality....

At work here I don't have anything newer that the .4 version of your changes to the tool but that will do nicely of an example of the problem.

Taking the resources you provided with version .4 of the spreadsheet, with artisan, medic, doctor, weaponsmith and shipwright selected as professions (I don't know if anything different happens with just shipwright on its own) when I select the TIE Fighter Blueprint schematic it lists the following resources to be used:

Steel 7000 Trimofekic
Quadranium Steel

Low Grade Ore 4000 Iopasasis
Vintrium Extrusive Ore

Inert Petrochemical 2000 Evaesiab
Lubricating Oil

Aluminum 2000 Egaic
Link-Steel Aluminum


This all seems nice and correct. The Lubricating Oil is OQ 820 which will work out at 82% experimentation.

Now to the issue - on the WTH page, where all the exisiting best/second best resources are listed, a polymer with only 72.2% experimentation is listed as the best (but the schematic page shows, correctly, a better lubricating oil as the best inert petrochemical) and the best that can be harvested (with the data from the spreadsheet without updating it from the zip file) is "Saciaism" a 66.3% Polymer, when there is a OQ 797 Lubricating Oil called "Durehaerauris" listed on the SWG Parsed sheet.

I'd really like to be able to fix this (and see it fixed in future versions of the tool) but can't spot anything in the WTHTGenerationFunctions module - I've mainly looked in the CalculateMyResources function so far.

If you have any hints on somewhere better to look or can suggest a fix I'd be most grateful.

Regards

Sloejack 11-23-2004 03:54 PM

I suspect what you're seeing is due to how experimentation value is being calculated. This is honestly an area where I'm fairly weak in knowledge of the game and will be relying on the experimentation mechanics as described in the existing tool and other sources. That being said, it would appear that the schematic sheet is using one formula and the WthT sheet is using a different one. After looking at the code, it looks like the WthT sheet is doing a comparison of resources that have the relavent experimentation stats. I'm basing this off of the fact that where you see "Inert Petrochemical - Use Any" Durehaerauris is selected and in schematics that have specific experimentation values it's comparing resources with those stats and picking Saciaism. Following that logic, the WthT sheet is behaving properly.

So, in short. I won't be changing the WthT logic in the current tool. When I get to this section in the version I am building, I'll look at it and see if things can be made a little more consistent.

Kelloch 11-24-2004 02:23 AM

I've just started playing with this spreadsheet and wondered how I survived as a Master Armorsmith up until now. This is awesome! That's for everyone's hard work that has produced it.

I noticed something today and wondered if either the calculation for Exp. Value is off or if the Theo Max for a resource has been disproven.

On the Kettemoor server there is a Silicastic Ore with a Theo Max of 80% showing up as Exp Value of 83.05. Its on Yavin IV and called Mabecine. I don't know the formula for the Theo Max, so it could be anything. I'm posting the stats for the ore here as its been up for 16 days.

CR=566, DR=172, HR=455, MA=690, OQ=806, SR=855, UT=687

Thanks

Carled Widar 11-24-2004 10:54 AM

Quote:
Originally Posted by Sloejack
I suspect what you're seeing is due to how experimentation value is being calculated. This is honestly an area where I'm fairly weak in knowledge of the game and will be relying on the experimentation mechanics as described in the existing tool and other sources. That being said, it would appear that the schematic sheet is using one formula and the WthT sheet is using a different one. After looking at the code, it looks like the WthT sheet is doing a comparison of resources that have the relavent experimentation stats. I'm basing this off of the fact that where you see "Inert Petrochemical - Use Any" Durehaerauris is selected and in schematics that have specific experimentation values it's comparing resources with those stats and picking Saciaism. Following that logic, the WthT sheet is behaving properly.

So, in short. I won't be changing the WthT logic in the current tool. When I get to this section in the version I am building, I'll look at it and see if things can be made a little more consistent.


That's fair enough.

The problem with how it's working at the moment is that the WTHT page is not telling you what the best resource you have or what the best to harvest is.

The example I gave was one where the schematic calls for an inert petrochemical with experimentation stats of a combination of 25% HR/25% OQ/25% UT/25% SR and 25% MB/25% OQ/25% UT/25% SR.

With lubricating oil as an inert petrochemical, the only stat that matters is the OQ, so any lube with a OQ higher than 663 should beat the polymer that's being suggested.

I've a feeling that I and many other people have missed harvesting the most appropriate resources as a result of this.



One other thing I've noticed is on the schematics page. It only caters for 4 experimental resource properties, but for the ship blueprint schematics more than 4 are needed (5 in the example used here) if a mix of hitpoints/mass are selected rather than 100% one or the other.

Carled Widar 11-24-2004 08:34 PM

Quote:
Originally Posted by Carled Widar
One other thing I've noticed is on the schematics page. It only caters for 4 experimental resource properties, but for the ship blueprint schematics more than 4 are needed (5 in the example used here) if a mix of hitpoints/mass are selected rather than 100% one or the other.


Oops - I see this has already been rectified in 66.6.

Sorry

Fooman 11-26-2004 06:53 PM

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


Errr.... My playing time has gone down the drain.....thats why no more developments on V7 (well, not exactly true...I've got a personnalized version)..

So now I'm playing a much different game : Raising a child (which I'm sure you will all believe me when I say that they litterally eat up your time...)

I'll keep checking around this thread from time to time;

this is to reply to some earlier posts in the thread: I AM ABSOLUTELY POSITIVE about the ABPH 87%13% distribution! (the shifting of stats will happen on ALL items that require a characteristic on a resource that is missing that stat).

I might give shipwright a whirl, i"ll let you know about it latter on sloe

Fooman

Alycia Windsong 11-27-2004 04:53 PM

Ok... every time I try to select the professions for this I get VB code execution has halted style messages... Have we upgraded the requirement past Excel 2000 to Excel 2003 or Excel XP and I missed it? Had the same problem with 1.66 but not 1.64

It keeps breaking here.. with Code execution has been interrupted
Private Sub Worksheet_Change(ByVal Target As Range)

Alycia Windsong 11-27-2004 05:03 PM

Also... when I open it up and select to configure professions... the VBA device pops up

Highlights the following code

Public Sub OpenProfessionSelector()
ProfSel.Show
End Sub

Alycia Windsong 11-27-2004 10:06 PM

aaaah nm... apparently I'm lax at home but not at work... after upgrading to Excel 2000 SP3... all problems resolved.

aeron 11-28-2004 11:55 PM

Hrm mine bombs out at a differnet line of code when I select professions:

Quote:
For i = 1 To intNumSWGC
For j = 1 To 7
strCompMatrix(i) = strCompMatrix(i) & "]" & Worksheets("SWGCParsed").Cells(i + 8, j + 18).Value

It is also not showing any current harvesting info in the WTH pages. I'm assuming it's not pulling from the db. I have hte DB file downloading to a folder holding the excel spreadsheet on my desktop.

Any ideas what I screwed up?

aeron 11-29-2004 12:30 AM

Helps if you download hte right version updraged to most recent version and I run fine now.

:)

Sloejack 11-29-2004 08:54 AM

Quote:
Originally Posted by Fooman
So now I'm playing a much different game : Raising a child (which I'm sure you will all believe me when I say that they litterally eat up your time...)

I completely understand, mine turns 1 in six days :)

Looking at the other recent posts, it looks like everyone else who has raised issues has either self resolved, or for the consistancy (typos) has worked around them. I'm going to be in California for the next week at GenCon and while I won't be out of touch I probably won't be doing any tool work. The re-write I'm working on is coming along but I have no ETA since it's coming down to the end of the year and free time decreases as various folks go on vacation at work (including myself) so I don't expect to have anything pushed out even for folks to test until the new year. I'll keep an eye on this thread, if anyone finds something catastrophic I'll jump on it, but it seems that things are stable at the moment.

iamflop 11-30-2004 02:56 AM

Time it takes to load a schematic?
 
I was just wondering how long it takes for the schematic to load all the resources, experimenting lines, etc when you select one?

It is taking 2 minutes for the schematic data to load on my system. If it matters, its a P4, 3.2Ghz, 1 gig RAM, and I'm using Office 2003.

Are there any options/settings I can adjust to speed this up? I have tried removing all schematics and data not related to my profession from the various sheets inclusding the hidden ones, but it still takes 2 minutes for the data to load.

Dandi St'Min 12-02-2004 10:42 PM

Suggestions for miners
 
Do now know if this has been suggested and I have only begun to play with this great tool but immediately I have a few suggestions for my needs (I am so selfish)

Added features for miners:

1. Add a specific harvester(s) filter to config. IE Mineral, Chem, etc For us miners that specialize:)

2. Filter for planets (what to harvest today) in case we only mine in certain planets.

3. Would it be possible to add highest concentration? I think SWG craft has this info, if not I think there are other places that may have this.

4. Histories best column would be nice to in what to harvest now, even better would to be able to config a time frame 1 year, 3 mo etc.. Of course a spawn dates should be displayed.

I am sure that I will find some of my answers while playing with this great tool... let me know how if easy....

Torik Valcyn

snuff 12-04-2004 09:46 PM

hey sloejack, dont knwo if this came up already in this thread.
Jenner was going to change the wtht calculation so taht the "use as generic" flag counts on wtht as on the schematics.

for example:
i have a very good vendusii chrystal amorphous gemstone, but i only have 5k of it.
it is gonna be used in RIS.
but i need amorphous gemstones aswell for layers.
so this vendusii gems are sitting on my "best amorphous gem" spot whil my sencond best sucks like hell, and i didnt realize this till i found out that i dont have any gems for my layers left.
will you please change the wtht sheet so that the use as generic type thing actually matters?

thanks

mwdennis 12-05-2004 04:28 AM

I don't know if this has been answered yet, but I'll ask it anyways. I have noticed that when using the schematics page of the tool and picking a schematic such as an equipment factory, it shows the subcomponents and what resources they need, but it does not show the subcomponents for those particular subcomponents. Example: An Equipment Factory requires 3 Wall Modules, and it shows those modules in the subcomponent list and the resources necessary to make the wall modules. What it doesn't show, is 30 structural modules along with all the metal ore required to make them. Another example in the same schematic is the Manufacturing Mechanism. It lists the resources needed to make a manufacturing mechanism, but it does not show that you need to make another generator turbine to use as a subcomponent for it. Any ideas on if this is implemented and I am just missing something, or is this something that still needs to be worked on?

Strongbow 12-05-2004 02:58 PM

Quote:
Originally Posted by mwdennis
I don't know if this has been answered yet, but I'll ask it anyways. I have noticed that when using the schematics page of the tool and picking a schematic such as an equipment factory, it shows the subcomponents and what resources they need, but it does not show the subcomponents for those particular subcomponents. Example: An Equipment Factory requires 3 Wall Modules, and it shows those modules in the subcomponent list and the resources necessary to make the wall modules. What it doesn't show, is 30 structural modules along with all the metal ore required to make them. Another example in the same schematic is the Manufacturing Mechanism. It lists the resources needed to make a manufacturing mechanism, but it does not show that you need to make another generator turbine to use as a subcomponent for it. Any ideas on if this is implemented and I am just missing something, or is this something that still needs to be worked on?


THis is something you have to keep track of. The tool does not recurse through multiple levels of subcomponents (ie, sub components that make subcomponents).

At one point I beleive Jenner was looking at the possibility to do this. I do not think, however, that Excel has the processing power to do this efficiently.

Caife 12-06-2004 10:31 AM

What are the main differences between Fooman v6.0 and J&F's tool?

I currently use Fooman v6. Is there any reason for me to start using Jenner and Fooman instead if I am only WS, no other crafting professions?

snuff 12-06-2004 11:44 PM

i just had a thought about a new cool function this tool could use, lol
how about this:
to add an extinct resource to your resource tab it should be possible to just add the name, quantity, min desired, price, filter and stuff and this tool gets the detailed information right off this website.
so i dont have to cross check the quality ingame with my sheet and am pretty failsafe about the stats.

how does this sound? :)

RawlingsSc 12-07-2004 06:42 PM

Hi, I am working with the Doc profession and wondered what the status was on adding the new schematics to the tool. I noticed that it was in process the beginning of November and know how busy life gets. I really appreciate all of the work that is being done on this. I was ready to quit the game because the resource control was getting to a frustration level, leaving the game no fun to play, but this tool has made the difference for me.

A while back I tried to enter some of the doc schematics on my own and messed up my tool. If adding these isn't still happening I would be willing to help with it as long as I can get some information on how to do it correctly so I don't mess up the tool. Just let me know.

Thanks, and I will look forward to your reply.

Sloejack 12-07-2004 09:31 PM

Oddly enough I'm on the journey to master doctor with my jedi seeking toon so I'll have these soon. Requests to the community to provide that information have not been successful so I'm working toward it on my own.

aeron 12-08-2004 03:02 PM

Woot I was just going to ask about Doc Schems :)

aeron 12-08-2004 03:08 PM

Ok this is an odd one. I have the most current version of the file and have copied the ZLib in teh system32 directory.

Basicalyl when I try to download the latest file from any server it tells me I have the latest file available when I know I don't

Is there anyway to delete the file it has on hand to force a new download? Or is there a setting I'm missing to make this happen?

RawlingsSc 12-08-2004 07:17 PM

Quote:
Originally Posted by Sloejack
Oddly enough I'm on the journey to master doctor with my jedi seeking toon so I'll have these soon. Requests to the community to provide that information have not been successful so I'm working toward it on my own.

Cool, Thanks for all of your work!

RawlingsSc 12-08-2004 07:18 PM

Quote:
Originally Posted by aeron
Ok this is an odd one. I have the most current version of the file and have copied the ZLib in teh system32 directory.

Basicalyl when I try to download the latest file from any server it tells me I have the latest file available when I know I don't

Is there anyway to delete the file it has on hand to force a new download? Or is there a setting I'm missing to make this happen?

Going into the folder that I store my tool in there is a status file. Deleting that and retrying usually does the job for me.


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

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