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:
    297
    Likes Received:
    51
    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 Active Member

    Messages:
    966
    Likes Received:
    219
    Trophy Points:
    43
    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 Active Member

    Messages:
    966
    Likes Received:
    219
    Trophy Points:
    43
    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 Active Member

    Messages:
    966
    Likes Received:
    219
    Trophy Points:
    43
    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 Active Member

    Messages:
    966
    Likes Received:
    219
    Trophy Points:
    43
    OP-edited-:bump:
     
  7. DxBlueIce

    DxBlueIce Adviser Arkadia Adviser

    Messages:
    291
    Likes Received:
    15
    Trophy Points:
    18
    Awesome and simple tool - thank you very much!
     
    • Friendly Friendly x 1
  8. San

    San Active Member

    Messages:
    966
    Likes Received:
    219
    Trophy Points:
    43
  9. Antrace

    Antrace Member

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

    thanks :)
     

Share This Page