Search found 184 matches

by panino76
Thu May 07, 2009 3:52 pm
Forum: Third Party Utilities
Topic: JnF's SWGCTool v2.0.2 - Official Thread
Replies: 381
Views: 262790

Re: JnF's SWGCTool v2.0.2 - Official Thread (UPDATED)

Sac wrote:I'm getting this one when I hit Import:

Image
Check the first and the second page of this thread, it's a know Excel bug.
by panino76
Wed May 06, 2009 11:15 pm
Forum: Third Party Utilities
Topic: JnF's SWGCTool v2.0.2 - Official Thread
Replies: 381
Views: 262790

Re: JnF's SWGCTool v2.0.2 - Official Thread (UPDATED)

On a totally different note, we had a number of resources and or stat requirements that changed on foods/drinks. The following schematics now require: Durindfire: 20 Funghi, 20 Flower Fruit, 1 Container, 1 Alcohol, , Garrmorl: 30 Wild Rice, 30 Flower Fruit, 1 Container, 2 Alcohol, 1 Medium Additive...
by panino76
Wed May 06, 2009 9:05 pm
Forum: Third Party Utilities
Topic: JnF's SWGCTool v2.0.2 - Official Thread
Replies: 381
Views: 262790

Re: JnF's SWGCTool v2.0.2 - Official Thread (UPDATED)

I got 'those numbers' from this formula as I stated above... =IF(Resource_stat+(Resource_cap*.04)>Resource_cap, Resource_cap, Resource_stat+(Resource_cap*.04)) Your tests for Advanced Repair Unit Case disprove his example...notice he rounded down where you had to round up to make the formula work. ...
by panino76
Wed May 06, 2009 6:25 pm
Forum: Third Party Utilities
Topic: JnF's SWGCTool v2.0.2 - Official Thread
Replies: 381
Views: 262790

Re: JnF's SWGCTool v2.0.2 - Official Thread (UPDATED)

I don't think it works that way; as Onyx said, the bonus is not applied on each individual stat of each resource but, using her(his?) words "The 4% (+40) does not get added until the final experimental average is determined." If it wouldn't work that way, how can you explain (since exp are rounded ...
by panino76
Wed May 06, 2009 3:48 pm
Forum: Third Party Utilities
Topic: JnF's SWGCTool v2.0.2 - Official Thread
Replies: 381
Views: 262790

Re: JnF's SWGCTool v2.0.2 - Official Thread (UPDATED)

Putting your resource stats in my formula comes out like so... 0% of Resource cap 856.80 1% of Resource cap 866.80 2% of Resource cap 876.80 3% of Resource cap 885.81 4% of Resource cap 893.81 Since experimentation rounds down, your tests appear to confirm that it is not a flat +40, but is 4% of ca...
by panino76
Wed May 06, 2009 3:03 pm
Forum: Third Party Utilities
Topic: JnF's SWGCTool v2.0.2 - Official Thread
Replies: 381
Views: 262790

Re: JnF's SWGCTool v2.0.2 - Official Thread (UPDATED)

Ok, let me show you some results I got so far: Schematic tested: Advanced Repair Unit Case (Droid Engineer) Resources required: 15 units of Neutronium Steel and 10 units of Rori Fiberplast Experimental path: OQ 33% - UT 67% Resources gates: 1000 for OQ on both resources, 1000 UT for fiberplast, 718 ...
by panino76
Wed May 06, 2009 1:56 pm
Forum: Third Party Utilities
Topic: JnF's SWGCTool v2.0.2 - Official Thread
Replies: 381
Views: 262790

Re: *NEW* JnF's SWGCTool v2.0 - Official Thread

2) The 4% (+40) does not get added until the final experimental average is determined. So, when I am doing the math, I don't apply the bonus until I've run the numbers. Once I have my final experimental average, then I add on the +40 and round it down to 100%. If you are determining between two res...
by panino76
Wed May 06, 2009 1:02 pm
Forum: Third Party Utilities
Topic: JnF's SWGCTool v2.0.2 - Official Thread
Replies: 381
Views: 262790

Re: JnF's SWGCTool v2.0.2 - Official Thread (UPDATED)

I am getting an import failure currently with the new version 2.0.2 when trying to import from 2.0.1. Error (11) - Division by zero Module: DataImportFunctions.importExternalData() Traceback: DataImportFunctions.importExternalData() CommandFunctions.startImport() Not sure what is going on there. co...
by panino76
Wed May 06, 2009 9:04 am
Forum: Third Party Utilities
Topic: JnF's SWGCTool v2.0.2 - Official Thread
Replies: 381
Views: 262790

Re: JnF's SWGCTool v2.0.2 - Official Thread (UPDATED)

Valtier wrote:File download is working, but the download resources feature doesn't appear to be updating anything.
Are you a new user of you were using version 2.x before this update? If so, have you imported all data from your old file?
by panino76
Tue May 05, 2009 11:23 pm
Forum: Third Party Utilities
Topic: JnF's SWGCTool v2.0.2 - Official Thread
Replies: 381
Views: 262790

Re: JnF's SWGCTool v2.0.2 - Official Thread (UPDATED)

Thank you for the work you do on this spreadsheet. Unfortunately, after downloading the file, I receive this message... The file you are trying to open 'v2.0.2 JnF's SWGCTool.xls', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a tru...
by panino76
Tue May 05, 2009 10:48 pm
Forum: Third Party Utilities
Topic: JnF's SWGCTool v2.0.2 - Official Thread
Replies: 381
Views: 262790

Re: JnF's SWGCTool v2.0.2 - Official Thread (UPDATED)

Version 2.0.2 is out folks, enjoy it :)
by panino76
Tue May 05, 2009 10:37 am
Forum: Third Party Utilities
Topic: JnF's SWGCTool v2.0.2 - Official Thread
Replies: 381
Views: 262790

Re: *NEW* JnF's SWGCTool v2.0 - Official Thread

Onyx, where you were when I needed you? :D

Interesting readings on those threads, I'll work hard in the next days to try to fix as much as I can. Thank you very much!
by panino76
Tue May 05, 2009 1:19 am
Forum: Third Party Utilities
Topic: JnF's SWGCTool v2.0.2 - Official Thread
Replies: 381
Views: 262790

Re: *NEW* JnF's SWGCTool v2.0 - Official Thread

I still hadn't gotten around to importing my massive resource database into the new version of the tool yet but after a comment someone made on the official forums about the tissue calc I ran a couple tests. It's not calculating correctly. Basically what is happening is that it is applying the 4% q...
by panino76
Mon May 04, 2009 4:13 pm
Forum: Third Party Utilities
Topic: Site Changed to SWGCRAFT.ORG Resources won't download
Replies: 4
Views: 7641

Re: Site Changed to SWGCRAFT.ORG Resources won't download

Sorry it was JNF 2.0 version. I found the places that need to be changed. In the VBA it is this for the Status.txt load. Public Function DownloadTimeStamp() Dim hFileLocation As String hFileLocation = Worksheets("GetFromSWGCraft").Cells(4, 6).Value & "\status.txt" 'panino76 - Old location 'Download...
by panino76
Mon May 04, 2009 11:33 am
Forum: Third Party Utilities
Topic: JnF's SWGCTool v2.0.2 - Official Thread
Replies: 381
Views: 262790

Re: *NEW* JnF's SWGCTool v2.0 - Official Thread

Hi i have the same problem like furian, when clicking "Download Current Ressources" there is an error message like this one: Anyways the error is : Error (62)-Input past end of file Module: Traceback: CommandFunctions.cmd_startDownload() Ok i solved it by myself. I opened the Macro Editor and searc...