Jump to content

Good I Snipr

Members
  • Posts

    1
  • Joined

  • Last visited

Reputation

0 Neutral

Profile Information

  • Gender
    Not Telling

RuneScape Information

  1. I've gotten this formula to work great in Google Docs for keeping track of my clanmate's daily xp gains. The troubles I have are: 1. I do not use Google Docs on a regular basis. All my stuff is OpenOffice Calc to be shared via DropBox. 2. Google Docs can only handle 50 at a time. atm my clan is 73 and we have no intention of getting smaller. 3. OpenOffice Calc always shows Err:50? when I try to use this formula. 4. OpenOffice Calc hangs, stops responding, eventually comes back and allows me to see the options for using the wizard to import data. However, it never does anything with the data no matter what I've selected/deselected in those options. The "OK" button never goes live for me to spit it to the spreadsheet. I love the ability to use the username from a cell. I do this in my spreadsheets so that when someone name changes, I need change only the one cell and all others that reference it are auto-updated. Is there a way to make a formula like this work in OpenOffice Calc? For specifics, I'll display 2 example rows of my spreadsheet. Row 1 is of course on top. Column A | Column B | Column C... u get the idea. username | xp from second to last time i checked | xp from last time I checked | xp difference Good I Snipr | 5043289 | 504732 | =C2-B2 <- note that I have to manually enter the data into column C. I want to replace that with a formula that grabs it from hiscore lite. I use this data to determine who's been inactive in the clan so we're not hanging onto shell accounts (ppl who've stopped playing). There are other columns that handle the dates that I've checked them and how long a person's been inactive. It's been a great system. However, with Jagex constantly screwing up the clanmate list, it's become necessary for me to grab a player's data directly from the hiscores. I can't manually grab that data for 73+ people each day. I'd go insane. If anyone can help with detailed step-by-step on what should be in Column C, I'd so greatly appreciate it. Feel free to contact me in game too, my pm's always on if I'm online.
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.