I wonder if Bill Gates every thinks about all the positive contributions he’s made to the fapping community.
Today I’m suffering from quite a bit of sleep deprivation and running some monthly reports. (so forgive me if I ramble)
I like to keep my eye on the ball and see what everyone is watching. See if there are special someones I should be aware of, trends, etc.
It’s really quite boring working in porn, unless you like data. Luckily I do like data.
I run Google Analytics reports on my sites, export the data into CSV, open in Excel and massage the information to get the feel of the Interwebs pervvy underbelly.
I’ll take the most uniquely viewed porn stars, turn them into an html table and share the info you you fine people.
Normally I do this through a series of concatenation and substitution formulas.
D1=substitute(a1,6666666,b1)| E1=substitute(D1,999999999,C1) | = concatenate(C1,D1)
It sounds kind of awkward and time consuming, but realistically it only takes a few minutes of cutting and pasting.
I could write a program to do it, but then I don’t get the ‘feel’ that I like from actually creating the reports.
I might miss out on some nuances that would be taken for granted if only presented with a list of names.
But I digress – the reason for today’s post – nested substitutions in Excel are amazing and simple.
instead of manipulating each column and then reprocessing the data, I can easily do it all at once with nested substitution.
I don’t know why I never thought of it before. But I’ve been running these reports and others like it for 10 years.
I guess because they are so easy to do anyway I never put the extra thought into how it could be better.
So here’s my new formula:
A: <tr><td>7777777</td><td><a href=”9999999″ title=”6666666″>6666666</a></td></tr>
C: (series of number 1-500)
D: URL http://www.hotmovies.com/porn-star/3487/Lela-Star.html
E: Star Name – Lela Star
And the end result:
<tr><td>1<a href="http://www.hotmovies.com/porn-star/3487/Lela-Star.html" title=" Lela Star "> Lela Star </a></td></tr>
*Edit* a few people were asking for more info. I did the top 487 last month and they want the larger list again.
So here are the Top 493 Porn Stars according to Unique Page Views for August 2011 in PDF Form to keep your browser from exploding.