My clan has put extensive work into spreadsheets for inhouses within our gaming community. Every 'season' of our inhouses we try to add to our spreadsheets. The next big statistic that we want to add would be the win-loss stats for every player vs every player in a matrix. Something similiar to what LoLking does with lane matchups. It would look something like this: http://www.lolking.net/charts?region=all&type=mid-matchup&range=daily&map=sr&queue=normal but we want actual stats rather then trends. We have experimented with a lot of different if/count commands (this is in google spreadsheets) but find that the only way we know how to do it would require roughly 80-100 hours of work. We are looking for a more efficient way to compound this data whether it be unique function commands or scripts. If you are at all interested, feel free to contact me and we can talk via Ts

This post was edited by hurt_knee on May 28 2015 11:00pm

bump

i dont know much about excel/spreadsheets, but would be simple to get the data you want from sql and use some kind of front end to display it the way you want.

i haven't tried using sql in a google spreadsheet before, but here's a link from a quick google search. that is, if you're up to learning sql and possibly a front end language.

http://acrl.ala.org/techconnect/?p=4001

/edit: i just tested it and it's kinda cool. if you're willing to learn / pay $$ i'd probably go with a custom web app though.

This post was edited by carteblanche on May 30 2015 06:16pm

thatd prolly be our last resort i fell like someone good with this kinda thing could fix our issue with ease which i why i plan to pay fg accordingly

i do appreciate any an all input tho

This post was edited by hurt_knee on May 31 2015 12:32am

still looking

still seeking help

still looking

still iso

I could do this but it depends on how much you're willing to pay.

nice bors