A geeky tool for measuring eco

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.

 

It does exactly that if you choose 'spreadsheet' as format option.

 

Yes it doe's . I should have put that in my previous post. 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.

 

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.

 

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.

 

OP-edited-

 

Awesome and simple tool - thank you very much!

 

There is now a "proper" hosted address for the file:

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

 

I'll try it asap

thanks

 

I know its really old project but was working till MA changed something today on My Items page.

 

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

 

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?

 

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.

 

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.