Introducing MabiCommerce!

• IceBlade wrote on 2012-08-31 07:23

  Quote from Xcelled194;944265:

  I'm not sure that the problem you think exists actually does. The program calculates the best item/town combination at that time. I'm level 9 in Taill, and it occasionally tells me to take heat crystals as opposed to anything else. This is because, as you note, selling large quantities of any item will decrease its price. But that's what this program is for, and it responds to the changes. The price drop would and does happen anyway, just because of people's common profit goals. Nothing can be done to avoid it.
  
  Commerce prices only fluctuate every 10 minutes real time. This gives you a window to basically haul some ass to the town, before the prices lower. You can bet others will do the same. Once again, this is a nuance of the game system, and MabiCommerce really doesn't change it, for better or worse.
  
  Profit information is as current as possible. When you select a town, profit information is immediately downloaded fresh from the server. That's what the slight delay is before items show up. When you hit Calculate, the new data is immediately uploaded to the server, and is thereby immediately available to other users. Because the webpage uses the same values, it will also be as current as possible.
  
  Also, using TAB and the numpad, I can enter an items profits in about 5 seconds. How much faster do you need to be, esp when some/most/all values are filled in for you?

  
  
  Well I've seen the price on Circle barrier spikes drop from 210 profit to 47 loss and I returned right after my delivery....
  
  

  Quote from qaccy;944554:

  And curse your Excel spreadsheet! It wasn't very useful to me 'cause I don't have Excel D: (and I'm both too cheap to buy it and too uppity to..."acquire" it elsewhere).

  
  
  Have you tried using OpenOffice, it's free and opens MS Office documents.
  
  

  Quote from Aubog007;944681:

  Here's an idea for this project. Calculate exp per route.

  
  
  This sounds like a good idea... I still don't know how the exp is based....
• Aubog007 wrote on 2012-08-31 08:30

  Quote from IceBlade;944701:

  Well I've seen the price on Circle barrier spikes drop from 210 profit to 47 loss and I returned right after my delivery....
  
  
  
  Have you tried using OpenOffice, it's free and opens MS Office documents.
  
  
  
  This sounds like a good idea... I still don't know how the exp is based....

  
  
  (Single Item Profit * Single Item Weight)^0.5 [rounded down] * Item Quantity * 30
• X wrote on 2012-09-01 02:30

  Quote from Aubog007;944486:

  Your program only works streaming wise if other people are using it right?
  
  If people dont use it, you can't get accurate data on how much it drops.
  
  And heat crystals... What. Circle barrier spikes are +30-35 in most towns and palala are +17.
  
  
  Oh wait i completely forgot.
  
  My apologies you are in Mari, i heard a lot of issues with commerce stem from there.
  
  And the apology is serious.

  
  
  It downloads the most up-to-date data from the server. If no one else is updating the data, then you're stuck having to enter it. I'd like to stress though that I designed MabiCommerce to work offline. If my server goes down, for example, the calculator still works fine. It just won't be able to do the convince thing of prefilling the profits.
  
  Also, Mari commerce, I've never known anything else, so *shrug*
  
  

  Quote from Sinned;944510:

  I don't commerce, but didn't mabidata also have something like that?

  
  
  There are lots of commerce tools floating around out there, and they all have varying degrees of sophistication. :3 I think MabiCommerce is the only one that uses ducats/second, though, because I'm the only one bored enough to time the routes.
  
  

  Quote from Yoorah;944552:

  Mabidata has an excel spreadsheet.

  
  
  Lots of people have Excel spreadsheets >_>
  
  

  Quote from Shisummy;944614:

  that's why i love my Fedora <3

  
  
  There are lots of open source office programs for both Windows and Linux. c:
  
  

  Quote from IceBlade;944701:

  Well I've seen the price on Circle barrier spikes drop from 210 profit to 47 loss and I returned right after my delivery....
  
  This sounds like a good idea... I still don't know how the exp is based....

  
  
  You have to keep in mind that as you're running Circle Barrier spikes, so are people on other channels. Because the channels share data, the price drop is the combined effect.
  
  Exp calculation will be added sometime soon.
• qaccy wrote on 2012-09-01 03:01

  Quote from IceBlade;944701:

  Have you tried using OpenOffice, it's free and opens MS Office documents.

  
  
  Opens, maybe, but to really use that spreadsheet you have to be able to interact with it...otherwise it's just a bunch of pretty boxes. :x
• Aubog007 wrote on 2012-09-01 05:39

  Quote from Xcelled194;945137:

  It downloads the most up-to-date data from the server. If no one else is updating the data, then you're stuck having to enter it. I'd like to stress though that I designed MabiCommerce to work offline. If my server goes down, for example, the calculator still works fine. It just won't be able to do the convince thing of prefilling the profits.
  
  Also, Mari commerce, I've never known anything else, so *shrug*
  
  
  
  There are lots of commerce tools floating around out there, and they all have varying degrees of sophistication. :3 I think MabiCommerce is the only one that uses ducats/second, though, because I'm the only one bored enough to time the routes.
  
  
  
  Lots of people have Excel spreadsheets >_>
  
  
  
  There are lots of open source office programs for both Windows and Linux. c:
  
  
  
  You have to keep in mind that as you're running Circle Barrier spikes, so are people on other channels. Because the channels share data, the price drop is the combined effect.
  
  Exp calculation will be added sometime soon.

  
  
  
  Well. There's two spread sheets that use time and horse v elephant.
  https://docs.google.com/spreadsheet/ccc?key=0AsIybnqIOKoJdHBScFJKQjVOdV9rWXlwOGgwVGMxYnc#gid=0
  https://docs.google.com/spreadsheet/ccc?key=0AsIybnqIOKoJdFJ3ZmNTZWpHOHFHUm0zWE9KeTlzSEE&hl=en_GB#gid=0
• X wrote on 2012-09-02 02:59

  Quote from Aubog007;945223:

  Well. There's two spread sheets that use time and horse v elephant.
  https://docs.google.com/spreadsheet/ccc?key=0AsIybnqIOKoJdHBScFJKQjVOdV9rWXlwOGgwVGMxYnc#gid=0
  https://docs.google.com/spreadsheet/ccc?key=0AsIybnqIOKoJdFJ3ZmNTZWpHOHFHUm0zWE9KeTlzSEE&hl=en_GB#gid=0

  
  
  There are lots of commerce sheets out there :o but the two you posted don't seem integrated? You have to copy data between them. (I think? They're not really that clear) x:
• Aubog007 wrote on 2012-09-02 05:40

  Quote from Xcelled194;945591:

  There are lots of commerce sheets out there :o but the two you posted don't seem integrated? You have to copy data between them. (I think? They're not really that clear) x:

  
  
  Oh, well i meant that these were the ones i used since commerce was out, i have been piecing together a general commerce guide that uses data from these templates and spreadsheets
• Justified wrote on 2012-09-02 06:53

  Quote from Xcelled194;945137:

  There are lots of commerce tools floating around out there, and they all have varying degrees of sophistication. :3 I think MabiCommerce is the only one that uses ducats/second, though, because I'm the only one bored enough to time the routes.

  
  
  I made a spreadsheet a long time ago, around the time the one on MabiData was posted. Complete with Travel Time, Ducat/Second, EXP/Second for all 4 vehicles to all 7 towns, and gradient coloring for best vs worst.
  
  Problem is that calculating and updating it is nowhere near worth the time. There's generally one item that's vastly superior to the other 3 items at the same town, and from there it's usually obvious which town would be worth the trip (after getting a vague idea of the actual time it takes to get there). Usually it's the same 3-4 items that end up being the best circuit anyways, so I never released it.
  Then again I don't think Ruairi has much action in commerce. Being tied for the least populated server with almost everybody rooted in Dunbarton leads to pretty static prices aside from Limited items.
  
  I'm all for the process though. Always fun seeing what kind of things people can create.
• Aubog007 wrote on 2012-09-02 08:25

  Quote from Justified;945640:

  I made a spreadsheet a long time ago, around the time the one on MabiData was posted. Complete with Travel Time, Ducat/Second, EXP/Second for all 4 vehicles to all 7 towns, and gradient coloring for best vs worst.
  
  Problem is that calculating and updating it is nowhere near worth the time. There's generally one item that's vastly superior to the other 3 items at the same town, and from there it's usually obvious which town would be worth the trip (after getting a vague idea of the actual time it takes to get there). Usually it's the same 3-4 items that end up being the best circuit anyways, so I never released it.
  Then again I don't think Ruairi has much action in commerce. Being tied for the least populated server with almost everybody rooted in Dunbarton leads to pretty static prices aside from Limited items.
  
  I'm all for the process though. Always fun seeing what kind of things people can create.

  
  Yes, it would also be nice if you could figure out the routes people take using the data you collect, it would be interesting to see what people do.
• X wrote on 2012-09-02 17:50

  Quote from Aubog007;945674:

  Yes, it would also be nice if you could figure out the routes people take using the data you collect, it would be interesting to see what people do.

  
  
  That is one of my long term goals. I'd like to be able to take how many times an item drops in profit (which only happens when it's sold to a town) to figure out what people are taking where, and how much. We need more people to use MabiCommerce before that can happen, though, or we won't have enough data.
• X wrote on 2012-09-03 21:20
  Attention everyone: thanks to the supreme efforts of Yai, MabiCommerce's web interface has received a fantastic facelift! Go check it out, and thank her!