I have made a Google Spreadsheet for the 2+2 LoL Community.

You can check it out here: 2+2 League of Legends Roster

It parses data from lolking.net, so it will have semi-current stats for us to compare epeens.

I have made it editable by anyone with the link so please don't troll it too hard, and be careful to always sort the whole sheet, not just a column or range, if you want to do so.

To add yourself to the roster:

Please enter your 2+2 name, summoner name and server in the appropriate columns. In order for your stats to be parsed into the spreadsheet from lolking.net you will need to find the URL for your lolking profile. To do this, simply search lolking for your summoner name, go to your profile from the results and then copy the URL into the "L" column.

The import formula is entered into the "F" column of the spreadsheet, and after you enter your URL into the "L" column, you may need to select the cell in the "F" column and press Ctrl+Shift+E to populate the rest of the cells beside it.

For example, to add myself I did the following:

• Entered "baumer" under 2+2 Name
• Entered "Raymears" under Summoner Name
• Entered "NA" under Server
• Entered "http://www.lolking.net/summoner/na/20327085" under lolking.net URL
• Select/Click on cell F4.
• Press Ctrl+Shift+E

Because of some limitations of Google Spreadsheet, the maximum number of people is 50. If it gets full I'll figure something out at that time.

This is sick. Gives me an error when I try to ctrl+shift+e, though.

"You are trying to edit a protected cell or object. Please contact the spreadsheet owner to remove protection if you need to edit"

Should be fixed now.

this is awesome!

How'd I know Raffy would be the first to use some pro's profile page. Great job dude!

i will take credit for both of those entries

Great job.

Now I finally know who Raymears is on 2p2.

why is everyone's number so much longer than mine

Nice work!

If we're not level 30 yet, it's broken right? My Crt Shift E is giving an error.


It also says the following at the top:

genetics

I'm still just level 22, trying to grind to my 0-3 placement ASAP

Since the spreadsheet only pulls stats for ranked solo 5v5, anyone without level 30 or any ranked games will break the spreadsheet.

Just grind to 30, problem solved.

As far as the warning for maximum importhtml functions, there are 50 in the spreadsheet already, and the max is 50. Just ignore or dismiss the message.

Looks like the spreadsheet is having some issues. Probably caused by trolls. I've prevented editing for a bit so I can work this out.

Edit: It looks like including the "http://" in the URL could be causing an issue. Even if you only copy/paste the "www" portion, spreadsheets sometimes adds the "http://". If it does this, try editing the cell and deleting that portion to see if it helps.

Also, if you are under level 30 just type your level under the league column. If you hit level 30 copy and paste one of the other cells into yours and it will autopopulate if you have your URL in place.

It looks like the spreadsheet is completely broken. Not sure what happened.

I will continue the monitor the situation, please go about your business.

Looking good to me.

Fixt.



Anyway, I'm sure he'll get it sorted out. Thanks for doing all this for the forum community. Obv no rush on the fix.

I'm not really sure why it works sometimes, and other times it doesn't pull the value from lolking.net.

That website might have some thing that prevents people from parsing data excessively.

For now, I have disabled editing. If you want to be added to the roster PM me or msg me in game.

baumer here, Raymears on League (aka Trundle).

As far as work I did, I tried for like 5 minutes to figure this out but it was out of my league, so I threw my question up on the Google Docs forums and someone solved it in like 2 hours. I guess I'll link his blog just in case anyone is interested, seeing as I didn't give him anything other than a "Thanks!"

iGoogleDrive - Mine is a little bit down the page. Looks like this guy is busy.

Maybe I should ask him about the fix haha...

if only the spreadsheet were Made in America

add me plox

http://www.lolking.net/summoner/na/21073835

add me too please

http://www.lolking.net/summoner/na/25076798

I think I'm on to something, looks like it's working aorn. I know there are more degens that play this game lets get a few more names. Either post in here or PM me.

Any chance on sticky for this? It's really no use at the bottom of the barrel.

add me plz

http://www.lolking.net/summoner/na/31567743

seems to work for like 2 seconds when you first load it, then crashs