Author Topic: FixBoy 2000 - A virtual crafting helper tool  (Read 8218 times)

zipoo

  • Hero Member
  • *****
  • Posts: 1181
    • View Profile
Re: FixBoy 2000 - A virtual crafting helper tool
« Reply #15 on: November 11, 2015, 21:11 »
which program i need to have to open it?

Balthasar

  • Developer
  • Sr. Member
  • *****
  • Posts: 291
  • .:
    • View Profile
Re: FixBoy 2000 - A virtual crafting helper tool
« Reply #16 on: November 11, 2015, 21:54 »
Microsoft Excel is needed here. Without it won't work. You can open the file itself via open office too but you won't have access to the form, just to the tables i guess. If you have Excel it shouldn't matter which version you have btw.

sh0z

  • Guest
Re: FixBoy 2000 - A virtual crafting helper tool
« Reply #17 on: November 11, 2015, 21:56 »
very nice tool baltha!

zipoo

  • Hero Member
  • *****
  • Posts: 1181
    • View Profile
Re: FixBoy 2000 - A virtual crafting helper tool
« Reply #18 on: November 11, 2015, 21:56 »
too bad i dont ahve excel ;/

Balthasar

  • Developer
  • Sr. Member
  • *****
  • Posts: 291
  • .:
    • View Profile
Re: FixBoy 2000 - A virtual crafting helper tool
« Reply #19 on: November 11, 2015, 22:12 »
Thx @shoz.

@all

Please keep in mind guys, that i typed in all the values manually in some tables. I tested the calculation mechanism itself, it should be ok but i can't assure that there may not be some typing or c/p error at some certain cell for a certain value like weight, exp or whatever. So please doublecheck your result sometimes or have a closer look if something seems suspicious value-wise :). Of course you are able to correct it yourself then by accessing the tables directly but it would be nice to have a quick feedback here also.

@zipoo

If you happen to be a student of some sort (highschool or university or some other eductional institution) you most probably will be able to get the office package for free.


Vodka

  • Sr. Member
  • ****
  • Posts: 437
    • View Profile
Re: FixBoy 2000 - A virtual crafting helper tool
« Reply #20 on: November 12, 2015, 10:05 »
Wrong calculating item weight for nades.
Perhaps with all 10x stuff

Balthasar

  • Developer
  • Sr. Member
  • *****
  • Posts: 291
  • .:
    • View Profile
Re: FixBoy 2000 - A virtual crafting helper tool
« Reply #21 on: November 12, 2015, 18:03 »
Wrong calculating item weight for nades.
Perhaps with all 10x stuff

Yep, it shows the wrong amount of batches. The weight shown in the info panel is the weight for 10 batches, which you craft at once, when you craft nades.

The value within the table was still "1" instead of "10". So calculation itself is ok. You can type in the value 10 into the sheet by yourself (Sheet "TableWeapons", Row "BB", last three entries) or download the whole file again, its updated.

SPECIAL

  • Guest
Re: FixBoy 2000 - A virtual crafting helper tool
« Reply #22 on: November 12, 2015, 23:04 »
Nice work as always! Thank you very much!

P.S. U can open it without downloading programs, just write in google "xls online reader" and use some random link.

Darling Madyson

  • Hero Member
  • *****
  • Posts: 541
  • top youtuber in the world
    • View Profile
Re: FixBoy 2000 - A virtual crafting helper tool
« Reply #23 on: November 13, 2015, 19:25 »
really nice
SRY MAX thats why you stop play

BEST PVP VIDEO!

SPECIAL

  • Guest
Re: FixBoy 2000 - A virtual crafting helper tool
« Reply #24 on: November 28, 2015, 08:42 »
What do u think about function of calculation how many items with bonuses can i get?
For example:
I choose to craft 1000 avengers, program says me amount of regular, upgraded, enchanced, improved and so on according with the formula.
It'll be interesting to look at theoretical and practical parts of crafting.
I think it's very easy to realize.

Balthasar

  • Developer
  • Sr. Member
  • *****
  • Posts: 291
  • .:
    • View Profile
Re: FixBoy 2000 - A virtual crafting helper tool
« Reply #25 on: November 29, 2015, 00:03 »
What do u think about function of calculation how many items with bonuses can i get?
For example:
I choose to craft 1000 avengers, program says me amount of regular, upgraded, enchanced, improved and so on according with the formula.
It'll be interesting to look at theoretical and practical parts of crafting.
I think it's very easy to realize.

Sure. Shouldn't be that hard. Just would need the right formula(s). Do you have them at hand by now or do i need to take the (approximated) statistic values from HERE?

hejmr

  • Hero Member
  • *****
  • Posts: 2500
  • Love and harmony
    • View Profile
Re: FixBoy 2000 - A virtual crafting helper tool
« Reply #26 on: November 29, 2015, 18:01 »
Nice work brotha.

http://www.youtube.com/watch?v=5_Ur9CAWsaM
Being a FOnline veteran means sinking in sentiment every time you look at the clock and it's 22:38.

SPECIAL

  • Guest
Re: FixBoy 2000 - A virtual crafting helper tool
« Reply #27 on: November 29, 2015, 19:31 »
Sure. Shouldn't be that hard. Just would need the right formula(s). Do you have them at hand by now or do i need to take the (approximated) statistic values from HERE?
I asked some devs, but noone said me real info about chance boosting in non-protected towns. I think u should get formula from wiki yet and add other info later when we know it.

Vodka

  • Sr. Member
  • ****
  • Posts: 437
    • View Profile
Re: FixBoy 2000 - A virtual crafting helper tool
« Reply #28 on: December 05, 2015, 09:50 »
When i'm clicking on T4 pic i get error "path not found"

Balthasar

  • Developer
  • Sr. Member
  • *****
  • Posts: 291
  • .:
    • View Profile
Re: FixBoy 2000 - A virtual crafting helper tool
« Reply #29 on: December 05, 2015, 10:40 »
When i'm clicking on T4 pic i get error "path not found"

The folder "Pics" has to be within the same folder where your FixBoy.xlsm file is. Within the Pics folder there has to be the "T4" folder. The structure is like:

folder containing the files:



folder "Pics":