At 6/7/03 04:00 PM, Newgrundling wrote:
I'm putting this all in an excel spreadsheet. I have a column of simply numbers (never changes) to indicate rank number. The next column is their account name. The column after that is the URL to their profile, and I will hide this when copy-pasting the list. The column after that is their Voting Power. All I do is click their profile link, get the VP, plug it in, and repeat some 150 times. After that, I highlight rows 2-4 and sort by the VP, and excel changes the rest. The ranks, of course, did not move, so I just hide row 3 and I'm good to copy-paste it.
Hm. My excel spreadsheet for the top 50 protectors is a bit more complicated, but the thing is, I manually reorder the list when people pass each other in protects. Which certainly isn't such a big deal with only 50 people on my list vs. 150 or so on yours, but I'd love to automate it. I don't think I can like you do, though, because I don't just overwrite the old one, I copy and paste the cells below each update, leading to a really long spreadsheet (I like being able to refer back to how it looked weeks and months ago). Can you order only a certain number of rows of several columns without screwing up the rest of the spreadsheet?
Yeah, I accidentally typed it with a "C" the first time on accident, copied that down, then saw it @ the top and fixed it, but not the rest. Thanks for catching that.
Sure thing. I figured that was the reason, since I couldn't think of what CP could mean that resembled Voting Power. #;-}>
BVP = Base Voting Power
TVP = Total Voting Power
BPM = Blam/Protection Point Markup
One thing, maybe you should make that BPP for Blam/Protect Percentage? Just so it's clear that the amount is a percentage increase in voting power, and not a flat increase (since all your examples don't make it clear we're talking %ages here).