Sunday, March 17, 2013

Percentage Correction evaluator III

Hi Gents,

here's the new Excel sheet for calculation bot prices. I've also added a few other things I believe will be helpful.

The first tab, "settings" is where the users start out. After they have copied the "CardsMTGO3.txt" file to the root directory, they are ready to hit the "Process Prices" button. This sets the file up for everything else. After doing that, the users can select different percentages from the drop down menu's until he is satisfied.

The users can then proceed to the "prices" tab. From here (direction on tab as well), they can enter card information and results based on the choices in the "settings" sheet. This is all recalculated if any changes are made to the settings sheet, so when they go back, the new prices will be reflected. The users can copy and paste the price data directly from the "CardsMTGO3" tab that was generated after clicking the "Process Prices" button.

 The final addition, because I became weary of continually editing my PersonalPercentages.txt file (the ; were enough to drive me mad), I created the "PersonalPercentages" tab. The users can now choose from the drop-downs on the left and the rest is calculated for them, again based on what they entered into the "settings" tab. Then all they have to do is copy the cells to the right (clearly marked by green cell at top) and paste them into their "PersonalPercentages.txt" file.

Hope you guys like/enjoy. 
Cheers, 
James 

PS: Carlos, I did try to get it so that the user could select from left to right the Set and then Rarity so as to provide a "filtered" list of possible card choices ...Unfortunately Excel limits array sizes and it is too small to do this...It broke after 1439 items :(


12 comments:

  1. Published on the behalf of James

    ReplyDelete
  2. what if we make the Cardsmtgo3 window not being "deleted" and recreated(just having the columns deleted or "overwritten") when clicking on "process prices" keeping the other tabs in with the formulas already made? (does this make sense?)

    But its a good job so far, now its up to Albert to fix the Cardsmtgo3 on V4 ;) (like having just the sell prices on pricelist and we adjust how much % of the sell price we wish to buy for, for example, or having the profit margins more stable and not a uncommon at buy 0.2 sell 0.3 and a common at buy 0.015 sell 0.150)

    I wouldnt do as good job as Jimmi with the macros but the sharing of ideas surely helped :)

    ReplyDelete
    Replies
    1. Thanks for the kind words, Carlos. While macros are pretty easy to do, they can get messy...quickly.

      I've been contemplating building this in JAVA or C so as to provide a usable version for folks that don't use Excel (or have the newest version). :) The only think keeping me from doing so at the moment is waiting until the new MTGOLibrary Bot is released so as to prevent having to re-code to much (I already code as my primary job, so this is just a continuation of work (albeit on something I enjoy) when I get home).

      The great thing about doing this in a programming language such as one mentioned above is the ability to utilize several different types of data structures and algorithms that will not only improve the speed, but provide several different options for sorting, searching and otherwise manipulating. It would also run on almost any platform. Not to mention, I could have it write out the file directly rather than copying and pasting :)

      I can prevent the sheet from being deleted and remade, only having it overwrite the old data. This is easy. However, the way it is now, it should not change any formulas, only update the card names, set names, etc.

      If you'd like me to send you a version that doesn't delete the data and only reloads the CardsMTGO3.txt file AND leaves this tab there, let me know and I'll get it out to you in the next day or 2.

      Cheers,
      Jimmi

      Delete
  3. This comment has been removed by the author.

    ReplyDelete
  4. I'll be sending another file to Albert, as I need to turn off the protection from some sheets prior to running the "process prices" script and then turn it back on. Without doing this, it throws an error.

    My apologies to anybody who has run into this. If you wish to unlock yourself in the meantime, the password has been left blank.

    On another note, anybody that feels they could improve upon, or would like to edit this, please feel free. I'm providing this file under the Creative Commons "Attribution - Share Alike" (CC BY-SA) license.

    What does this mean for you?

    It means that you may remix, tweak, and build upon this work even for commercial purposes, as long as you credit myself and license the new creations under the identical terms.

    Cheers,
    Jimmi

    ReplyDelete
  5. if u need help making it a standalone application contact "klixxer" in MTGO (owner of swebot chain). he's pretty good with things like that.

    ReplyDelete
    Replies
    1. Well thank you for the credit :)
      It could be a possibility to add this to the current MTGO Tool I've been developing.

      Regards,
      Sebastian

      Delete
    2. Thanks for the reference Carlos!

      Hi Sebastion,
      Do you have a link for the MTGO Tool? I'd love to take a look at it! If you're open to the idea of a collaborative work, let me know. I typically work in JAVA, ColdFusion & SQL but also have experience in PERL and C. I am also not opposed to learning a new language, so long as it's not ASM :) Never was a language I enjoyed.

      If you'd like to see some of my work, I'm on github at https://github.com/b1nary0mega or you can view my work(s) at http://www.jamesandkrystina.info/james/coding.cfm

      Cheers,
      Jimmi
      mtgo: b1nary0mega

      Delete
  6. The program is written in C#.
    Add me on skype and we can have a chat :)
    Skype: Klizzer

    Regards,
    Sebastian

    ReplyDelete
    Replies
    1. Hi Sebastian! I've installed SKYPE on my work machine (no mic or camera, but I can txt). I will install it on my machine when I get home (mic and camera there).

      I've not worked in C#, but I here it's very similar to JAVA.

      I see you're in Sweden. Is there a particular time and/or day that works best for you? I'm located in New York, USA (GMT -5). I'm pretty flexible but this weekend friday to sunday is booked (birthday weekend).

      Cheers,
      Jimmi

      Delete
    2. I'm currently located in South Africa actually. The time zone here is GMT +2. I'm online from 08.00-22.00 every day pretty much. 08.00-17.00 at work then the other hours if I'm home.

      Yes C# and Java are very similar :)

      Cheers,
      Sebastian

      Delete