Quote (Godel @ Sep 20 2012 02:22am)
Not sure how you collect and store data, but I was referring to an excel function
I was going to write it to store into a databse, but not paying for microsoft access and it won't work with open office (as far as I know). Learning XML with java looks like a pain as well and don't feel like relearning vb.net and learning socketing (to look up hiscores online) to do it there (XML seems so much easier in vb) and recoding everything there as well.
So with what I have I just c/p all usernames from an excel spreadsheet and put it into a text document since doing that adds a line feed after each one making it easier to read into java then store that info into a text document with the line feed so easy to c/p back into spreadsheet. Too lazy to modify the spreadsheet
Pretty sure to use that function I would have to do something like =TRIM(B3) (with the user with the space at end in B3 of course), which adds another column onto the 11 I already use
column headings atm
Code
in/out 0exp-prev. Forum Name RS Name RS Name Starting EXP RS Name End Exp Exp Difference 0exp Botting Offense
RS Name - the first one is for what they give me, the 2nd is from copying from start exp text file (to make sure they line up), and 3rd from copying from end exp text file
can probably delete the 0 exp and botting offense at the end since I never pay attention to the 0 exp and very very very rare to actually catch someone botting.