Just wanted to followup to say thanks for the help. I'm going to see about upgrading my office installation on the laptop.

In a nut shell, I take into account the theoretical maximums for each stat of a resource; these are all defined inside the Resource DB of the spreadsheet.

First I total the sum of all stats in the resource and compare that to the Max Sum that the stats *could* be for a perfect reosurce. I use that ratio and weight it as being 40% of the rate calculation.

Next I look at how many stats columns are in the 90%, or better, ranking (but not 95% or better) and weight that as 30% of the rate calculation.

Finally I take the stats that are 95% or better and weight those by another 30%.

Now I have set a maximum value for my resource prices to be 10CPU. Internal to the calculations there is a hardcoded 1CPU minimum (have to cover mining costs).

I take the ratio (actual vs theoretical max) for the overall stats multiplied by .4 plus the ratio of the 90% stats, times .3, plus the ratio of 95% stats, times .3.

So you end up with a rate somewhere between 1 and 10 CPU based on how high the actual stats are.

The ratio numbers and max CPU can be fully adjusted by the user, if you choose to use this function.

I use this to come up with more realistic pricing of my weapons and ship parts, though it has brought me some accusations of "undercutter" in the past :shrug: I make a nice profit using this, and if necessary can use the profit markup field on the schematic page if I want to get my pricing up into the same range as my competitors (I've seen numbers as high ad 500% there to equal thier prices).

For me this takes some of the subjectiveness out of the pricing side of the business.

As far as different pricing structures for different resource types, I never thought about it (especially concerning animal resources). I suppose something could be done, but it could make for some complex data entry requirements. If someone wants to tackle that aspect, i am more than willing to incorporate the results (provided that they can be toggled off for folks that do not want to use them).

The end result I am striving for is adaptability for different playstyles. I'll throw ideas out in the tool from time to time that I come up with and see if they stick; feel free to counter those ideas with others, or with modifications to those ideas.

Yeah, I think the system is great for mined resources, I just want to tweak it a little in a couple areas.


Here's an example of what I'm looking for.

Codoan Copper's CR has a Max Theoretical rate of 739
Desh Copper's CR has a Max Theoretical Rate of 116

Where are you defining this difference? Is it defined for every resource, or is it defined when the "resources type" is selected?

If it's defined by the selected resource type then I would merely need to redo the formula assigned to the animal resource types and radioactive resource types.

I've scrolled over and had a look at the worksheet area on the Resources tab but I can't make any sense of it.

One problem I may run into is the hard ceiling; many animal resources generally run higher than your 10cpu, or even my 15cpu caps. Quality Avian meat for example can easily e priced up to 50cpu.

Here's my favorite animal harvesting value formulas.

A Pricing Guide for Animal Resources

The radioactive formula appears to be a pretty common one as I search through forums on the subject.

PE/500 = Price

Some people (of which I am one) use a 1.5 modifier after that.

(PE/500 = Actual Power Per Resource Unit) x 1.5 = Price


I don't mind making the changes myself at all, if you could just point me in the right direction I'll be back when it's finished.


Thanks man,

d

Ok, I see in the resources db where the difference is being defined... and all the calculations are made in the worksheet area of the main resources page?

The way you have it defined is correct. DR/FL/PE/OQ are all set to one and that is the peramiters I'm looking for.

I guess the change is merely in the calculation... so is the formula you're using global (ie, can it be modified for an individual resource type)?


Thanks again.

d

Sorry, wrong sheet. The theoretical maxes for each resource stat are on NoExceptionList (hidden). I should know better than to try to post this off of the top of my head instead of looking first. The ResourceDB worksheet categorizes each resource and marks the relevant stat categories (0 - not applicable, 1 - applicable)

I'm not following your description of this.... :(



Found this one. I was not aware of an invisible range holding the server names on the Control Panel page, so extra rows were inserted when I added the new function options to that worksheet.

Get back to me on the first problem and I will post all of these fixes at the same time.

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.

I've run into a problem.

Everything was working great just yesterday and today I tried to download from SWG Craft and it won't read the file.

I've tried creating and new directory, that doesn't help.

I read here in the forums that I should try to back-up my file and start from scratch with a new download, which I did, and still nothing.

I'm downloading the file fine, when I hit download a new file is place in the assigned directory, but the SWGC Import page won't update.

I've also tried to download the file for other servers and they won't read either.

I'm on Lowca by the way.


Peace.

HI Strongbow...

First and foremost thanks for your reply.

Yes I did put the zlib.dll in the system32 directory, however I have Windows 2000 Pro so the installation folder is not C:\Windows\System32 like it says on the Control Panel tab of the tool. But just to be safe I placed the file on C:\Winnt\system32 and created a C:\Windows\System32 folder and placed it there too just in case.

As for your other questions, I did create the directory for the files and configured it on the Control Panel as instructed. I have Office 2000 though. It's also worth mentioning that I had this problem with version 1.70.01 but not with version 1.66.91.

Once again, thanks for your reply and hope to hear from you soon.

Zad MacLeod
Master Weaponsmith
Gorath

That kinda sounds like the problem I was having... Is the error: "An error ocurred while reading the data-file"???

Regards,

Zad MacLeod
Master Weaponsmith
Gorath

Experimentation percentages wrong
 

I saw this happening in an older version, but downloaded the current version and verified its happening in it as well.

I configured the tool for only Armorsmith and download the latest file. When I download the current resources for my server and go to the WTH Today tab, I see some resources listed mutltiple times with slightly different experimentation values when they shouldn't be.

For armorsmith, Wooly Hide gets listed three times. The first time is shows

Wooly at OQ42%;SR58% for these schematics:
Composite Armor Gloves, Composite Armor Helmet, Composite Armor Left Bicep, Composite Armor Left Bracer, Composite Armor Pants, Composite Armor Right Bicep, Composite Armor Right Bracer, Ithorian Defender Boots, Ithorian Defender Gloves, Ithorian Defender Helmet, Ithorian Defender Left Bicep, Ithorian Defender Left Bracer, Ithorian Defender Leggings, Ithorian Defender Right Bicep, Ithorian Defender Right Bracer

Listed again at OQ43%;SR57% for these schematics:
Composite Armor Boots, Composite Armor Chest Plate, Ithorian Defender Chest Plate

Then again at OQ50%;SR50% for these schematics:
Ithorian Guardian Boots, Ithorian Guardian Chest Plate, Ithorian Guardian Gloves, Ithorian Guardian Helmet, Ithorian Guardian Left Bicep, Ithorian Guardian Left Bracer, Ithorian Guardian Leggings, Ithorian Guardian Right Bicep, Ithorian Guardian Right Bracer, Kashyyykian Ceremonial Armor Chest Plate, Kashyyykian Ceremonial Armor Left Bracer, Kashyyykian Ceremonial Armor Leggings, Kashyyykian Ceremonial Armor Right Bracer, Ithorian Sentinel Boots, Ithorian Sentinel Chest Plate, Ithorian Sentinel Gloves, Ithorian Sentinel Helmet, Ithorian Sentinel Left Bicep, Ithorian Sentinel Left Bracer, Ithorian Sentinel Leggings, Ithorian Sentinel Right Bicep, Ithorian Sentinel Right Bracer, Padded Armor Belt, Padded Armor Boots, Padded Armor Chest Plate, Padded Armor Gloves, Padded Armor Helmet, Padded Armor Left Bicep, Padded Armor Left Bracer, Padded Armor Pants, Padded Armor Right Bicep, Padded Armor Right Bracer, Padded Armor Segment, Ubese Armor Boots, Ubese Armor Gloves, Ubese Armor Helmet, Ubese Armor Jacket, Ubese Armor Left Bracer, Ubese Armor Pants, Ubese Armor Right Bracer


The listing of 50/50 is the correct one and should be for everything. I'm not sure where the percentages come from, but on the Data All page all the pieces show 50/50.

Other resouces that are listed multiple times in a similar manner include Aluminum, Beryllius Copper, Crystalline Gemstone, Instrusive Ore, Metal, Nabooian Fiberplast, Non-Ferrous Metal, and Polymer.

Same here.

Typically this occurs because some resource in the schematic does not have all of the stats listed, so the weight is shifted more to the resources in that schematic that do have that particular stat.

In the case of Composite Armor Gloves, the Solid Petro resource does not have an SR stat, so the weight of that stat gets distributed across the other resources in the schematic. The crafting engine in SWG does the same thing.

Here's a snippet from the original Jenner Thread on this tool about this very issue:



So take your COmposite Gloves:

Aluminum 10
Beryllius Copper 10
Intrisuve Ore 25
Solid Petro 25
Fiberplast 15
Hide 10

If Solid Petro had SR, then the weighting of materials with OQ vs materials with SR would be 95/95 for OQ/SR, making a 50/50 split

Since Solid Petro does not have SR, you instead have 95/70 on the materials for OQ/SR, making a 42%/58% split

OQ: 1-(95/165) = 42.4%
SR: 1-(70/165) = 57.6%

I hope that helps. This is easy to see when only 2 resources are involved; with 5 it can get confusing very easily.

Hoi,

a guildie told me that i have to try this tool. Only problem is: he also told me that for BE-Stuff it use the data as in datapad for calculating the rating: each 33% of OQ, PE and FL.

Problem is: its already proved that the data in datapad is wrong. It seems that it's like OQ=50% PE=30% and FL=20% for all the stuff that shown at 33% each. (That means all flora food and creature food, thats used in chef- and tailor-tissues. The data for the petstims and vitality packs seems to be correct.)

Is it maybe possible to correct this?
If you need a list of the schematic names i can post them also

Ok..thank you. I must have missed that discussion. At least I'm not going crazy.

If you like, you can make the necessary adjustments on the Data All Worksheet in the tool for each affected schematic.

I do not know how many BE's use this tool, but I would like to see some kind of consensus from them before making the change in a published version of the tool.

OK, based on the reports so far, it appears that the new Import function has gone beyond the functional capabilities of Excel 2000. I simply have no way to test whether that is indeed the case, since I am running Office 2003.

To try an figure this out, I need a volunteer who is running Office 2000.....

Open the VBA editor (Tools, Macros, Visual Basic Editor), open the DataImportFunctions Module and place a breakpoint on the following line:



Also temporarily remark out (put single quote at beginning of line) the following line:


Now, go back to the Control Panel sheet and re-run a download. When the program gets to the breakpoint you will be able to "step" thru the code one line at a time by pressing the F8 key. I suspect that when you get to the line:


that you will get a run-time error. Report that error back here and we'll try to see what is happening. I suspect that one of the properties listed in that section of code is not valid in Excel 2000. You could help me out by looking that up the QueryTables object in the Excel 2000 Help system and checking the Properties for the Add method.

willl try to find out how :)

Hmm... I don't understand what changed on my end, but the schematic page seems to be working fine now. All I've done was use Excel to make a small spreadsheet. <shrug>

What had been happening was when I clicked on the Schematic tab I got a weird screen. Right now I see the usual pull down bar that lets me pick what weapon I want to make. Before I had been seeing just a long list of weapons, with no pull down bar, or anything like I'm used to seeing on that page.

I'm using the last update you made. I opened it just so I could better describe my problem, and magically its working right. Hmmph.

Hmm... I don't understand what changed on my end, but the schematic page seems to be working fine now. All I've done was use Excel to make a small spreadsheet. <shrug>

What had been happening was when I clicked on the Schematic tab I got a weird screen. Right now I see the usual pull down bar that lets me pick what weapon I want to make. Before I had been seeing just a long list of weapons, with no pull down bar, or anything like I'm used to seeing on that page.

I'm using the last update you made. I opened it just so I could better describe my problem, and magically its working right. Hmmph.

Error In Calculations...
 

ERROR MAYBE???

So I have two of the new SW Steels, and I am a weaponsmith...

Hardened Arveshium Steel Hisoabosiam
CR: 889 CD: 787 DR: 67 HR: 16 MB: 55 OQ: 673 SR: 214 UT: 218

Crystallized Bicorbantium Steel Lavor
CR: 205 CD: 934 DR: 338 HR: 982 MB: 568 OQ: 476 SR: 587 UT: 587


According to the WTHT the Lavor is better for LLCs, yet it 1) doesn't show up at all when I go to the schematics page, and 2) the schematics page thinks the Hisoabosiam is best I have.


For now I just update it by hand, since I have done the % calculations and know that Lavor is better, but I don't know exactly what the problem is nor how to fix it.


Thanks.

Something I just noticed on my end. I import the resources and go to the WTH page, and I have resources showing as being available for 13 days, even though my limit is set at 7 days. Very strange, but not a real big deal since its easy to ignore the resources that are too old.

Excel uses VBA ? Is that basically the same as regular VB ? I was considering trying to learn VB to help a little more. I have to do it for my major sooner or later anyway, and its nice have a real program to look at while I'm learning.

VBA (or Visual Basic for Applications) is basically a subset of Visual Basic, geared specifically for the MSOffice applications. For all intents and purposes it is the same as VB 6. It is not anywhere near the same as the .NET version of VB, however.

Is the Shipwright (JtL) resources that are hanging around? I have those hard-coded into the system since they have a spawn length of about 20 days.

There is a bit of an issue with the schematic rankings that I had hoped to have time to fix by this weekend, but real life interfered. It is not appropriately taking into account resources that are missing one of the stats, so it is missing weight difference caused by the Ore component. As a result, the schematic is using the 50/50 OQ/CD ratio explicitly, instead of the 65/35 CD/OQ split it should be using.

However, if you use the ranking drop down on that line of the schematic, you should see the resource you want under one of the other ranks. I made a change to the most recent version to at least get the proper resources culled into the list, but have not gotten the rest of the code to rank them appropriately.

I like all the new changes, this is really an awesome tool and everyone has done the community a great service. I just switched over to 1.70.01 today. I loaded up all my resources, settings and everything. Then I go and try to pull up a schematic and I get the following error

Run-time error '9':

Subscript out of range

It then has options for end or debug. Any ideas of what the problem is or possible solution? Thanks in advance

What schematic are you trying to pull up?

Thanks for the info about VB. My school doesn't teach any of the .net languages yet, guess I'll need to get a book to find out whats different. I'm taking C++ classes atm.

The resources that are past the 7 day limit I have set are:

Lavor Steel 14 Days
Hisoabosiam 7 days 11 hours
Quadeuteilihium Siclastic Ore 9 Days 7 Hours
OmniBegogris Aluminum 14 days 7 hours

I don't know if they are shipwright resources or not. They might have not been marked as unavailable when spawn ran out if they aren't for shipwright. I don't know how how often Starsider Server resources get updated

I get this same thing. Is there a fix for it? Im running 1.70.01...

/Thylex

I have a fix for it. I will try to upload an updated version tonight.

Ok. I sorta self fixed this one. I just did a new setup and it fixed this. But, a new problem came up after I saved and closed. Now when I try and download the updated resource table I get the following error.

Run-time error '53'

File not found: zlib.dll


I have the file in the same folder as before and I doubled checked the directory in the control panel and all seems to be fine. Sorry for my lack of knowledge in excel and thanks in advance for any input.

Zlib.dll has to be placed in your System32 directory. Check and see if it is still there.

Yeah I checked and its still there. I am going to try and do a clean install again and copy over a fresh zlib.

The "Update Stock" feature on the schematics page does not seem to be working...

When I click it it has a "1" in the schem field and no number in the manufacturing run field. I place my number I want in the manufacturing run field and it goes to an error.

Run-time Error '9':

Subscript out of range.


This is a relatively important feature in my opinion, and I don't know if this bug has been reported or not. I would think this would be up there on the NEED to be fixed before other alterations are made. It might be my setup or something but I personally can't find a way to not get it to come up in this version, so for now I will alter the numbers manually.

You stole the words right out of my mouth. Most of my problems earlier have been worked around with a simple fresh install, but this one seems to replicate itself no matter what I do. I have tried on 3 different systems with 2 different OS (pro and home) and office 2001 and 2002. I am sorry that I am not a excel person but I hope this info can help.

Version 1.71.02 is available for download. See link in first message of this thread.

The Update Stock function should be working now; it has taken everything that I have thrown at it so far.

Question
 

Hello again friends,

Could someone tell me what the numbers in the "Where I can find it" column, next to the planet's name (On the WTHT tab) mean?

Thanks in advance

Zad MacLeod
Master Weaponsmith
Gorath

The number represents how many days the resource has been in spawn on that planet. In actuality it really means how many days ago it was entered on SWGCraft for that planet.

It is meant as quick lookup to help you judge the spawn cycle vs the planetary resources.

Thanks for fixing the Auto Update Stock feature :).

No sweat. I should have posted that release 4 days ago :o

Dealing with some major crap (different word should really be there) at work, so it has been difficult to find time and motivation for my extra-curricular activities.

hmm ive got a little problem your brilliant little tool isint importing the insect meat from the chimera database to the wth section for combat medic..