1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

A geeky tool for measuring eco

Discussion in 'General Economy Discussion' started by San, Apr 26, 2015.

  1. OZtwo

    OZtwo Active Member

    Messages:
    308
    Likes Received:
    52
    Trophy Points:
    28
    Yes Excel works..I have been using a tool like yours now for over 4 years. My tool is to give a snap shot of daily value of MU and doesn't give as much detail as yours.

    Edit: Oh I'm sorry you are talking about your data.

    For this to work with Excel your script will need to add tabs between columns (or HTML formatting using columns) this will make it much easier to copy/paste in excel with it having little to no issues pasting.
     
    Last edited: May 16, 2015
  2. San

    San Well-Known Member

    Messages:
    1,115
    Likes Received:
    271
    Trophy Points:
    83
    It does exactly that if you choose 'spreadsheet' as format option.
     
  3. Michael

    Michael Member

    Messages:
    43
    Likes Received:
    12
    Trophy Points:
    8
    Yes it doe's . I should have put that in my previous post. :redface: I keep multiple runs per sheet and would never paste in A1 so for me it is is faster to just use plain text since the math is already done. That way I don't have to change the cell ref's. That's just my preference.
     
  4. San

    San Well-Known Member

    Messages:
    1,115
    Likes Received:
    271
    Trophy Points:
    83
    It was made exactly for that upon another player's request, to group multiple runs into accounts for different mobs, activities or whatever. The cell you paste into becomes the top left corner of the imported table. This can be anywhere you want on your sheet, even if there is already data in it. Ideally below, of course. The math is done automatically and the result shown at once, but this way you have the ability to further manipulate it, e.g. add a row manually for a repair that wasn't recorded, or delete something which got in the way, e.g. a trade which couldn't wait but doesn't belong there, and the partial sums are automatically adjusted. Otherwise a spreadsheet program would be pointless.

    Edit: It was reported that spreadsheet import does not work as intended, i.e. the cell addresses in the formulas were not interpreted as relative but absolute instead. This means, the sums and percentage do not work if the data is pasted anywhere other than in the top left corner of a fresh sheet. Strange thing is, it appeared to work for me at the time, but now I also can't reproduce the behaviour. Obviously I need to read up a little on spreadsheet formulas to find out how to do this properly. Update to follow.
     
    Last edited: May 20, 2015
  5. San

    San Well-Known Member

    Messages:
    1,115
    Likes Received:
    271
    Trophy Points:
    83
    Been experimenting a little more with spreadsheet import, but have found no clean way of doing this without breaking something else it was intended to do.

    The way it seems to work is this: Temporarily create a fresh sheet, paste the data in the top left corner there, then take this table into the clipboard again by marking the range from top-left to bottom-right, and paste it into your actual sheet where you need it. This part then gets transposed correctly.

    If I put in extra functions to determine current cell address and calculate the range to sum up this way, it breaks the ability to add or remove rows. The automatic address conversion is not intelligent enough to dive into hand-made logic and adapt the parameters there.

    Does this suffice? It is actually just a few clicks more and takes only seconds. But would have been cool if it had "just worked". If an Excel expert comes up with a better way, I'd be happy to implement it.
     
    • Informative Informative x 1
  6. San

    San Well-Known Member

    Messages:
    1,115
    Likes Received:
    271
    Trophy Points:
    83
    OP-edited-:bump:
     
  7. DxBlueIce

    DxBlueIce Adviser Arkadia Adviser

    Messages:
    542
    Likes Received:
    27
    Trophy Points:
    28
    Awesome and simple tool - thank you very much!
     
    • Friendly Friendly x 1
  8. San

    San Well-Known Member

    Messages:
    1,115
    Likes Received:
    271
    Trophy Points:
    83
  9. Antrace

    Antrace Member

    Messages:
    62
    Likes Received:
    10
    Trophy Points:
    8
    I'll try it asap

    thanks :)
     
  10. KingMike

    KingMike Member

    Messages:
    91
    Likes Received:
    14
    Trophy Points:
    8
    I know its really old project but was working till MA changed something today on My Items page.
     
    • Informative Informative x 1
  11. KingMike

    KingMike Member

    Messages:
    91
    Likes Received:
    14
    Trophy Points:
    8
    Currently i edited some regex is the code as a work around

    from
    HTML:
        var re = /^\d+\s+(.*?)\s+(\d+)\s+(\d+\.\d+)\s+PED/gm;
    
    to
    HTML:
      var re = /^(.*?)\s+(\d+)\s+(\d+\.\d+)\s+/gm;
    
    hope OP will come up with better option :)
     
    • Useful Useful x 1
  12. San

    San Well-Known Member

    Messages:
    1,115
    Likes Received:
    271
    Trophy Points:
    83
    No, that's precisely the solution. Thank you! And sorry for taking some time to fix it, edited now at the location:

    https://sandals-eu.neocities.org/inv.html

    Will probably delete the pastebin, or are there folks who prefer it?
     
  13. San

    San Well-Known Member

    Messages:
    1,115
    Likes Received:
    271
    Trophy Points:
    83
    Update: Edited it to ignore items listed on auction because it messes up the result when they get sold during the time between the snapshots.
     
  14. Ajvar

    Ajvar New Member

    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    I messed around with your script and came up with a version that suits my need better. Anyone who wishes can take a look at it.
    Just rename index.txt to index.html and open web page.
    It can also save the data in a nice JSON format if it's ran from a server for which you need the save.txt script. In this case rename both files to .php.
     

    Attached Files: