Top 25 Straight Videos – Last 12 Months 
Rank Title Studio
1 Lesbian Masseuse #2 Girl Candy Films
2 Women Seeking Women Volume 82: Big Natural Breast Edition Girlfriends Films
3 Mother-Daughter Exchange Club Part 24 Girlfriends Films
4 Lesbian House Hunters Part 7 Girlfriends Films
5 Mommy & Me 4 Filly Films
6 Lesbian Beauties Vol. 8 – Interracial Sweetheart Video
7 Lesbian Storytime Theater Episode 1 Girlfriends Films
8 Lesbian Seductions Older/Younger Vol. 40 Girlfriends Films
9 Lesbian Hitchhiker 5 Sweetheart Video
10 Cheer Squad Sleepovers Episode 2 Girlfriends Films
11 Please Make Me Lesbian! Part 7 Girlfriends Films
12 Taboo II Standard Digital
13 Lesbian Guidance Counselor Girl Candy Films
14 Alexis Ford Darkside (Disc 1) Jules Jordan Video – Jules Jordan
15 Cuckold Stories 6 Digital Sin
16 Black Bi Cuckolding 9 Kick Ass
17 Cheer Squad Sleepovers Episode 1 Girlfriends Films
18 Mother-Son Secrets 3 Forbidden Fruits Films
19 Chyna Is Queen Of The Ring Vivid Premium
20 Budapest Episode 10 Girlfriends Films
21 Cougars, Kittens & Cock 2 Jules Jordan Video – Jules Jordan
22 Mother-Son Secrets 4 Forbidden Fruits Films
23 Lesbian Doms & Subs Vol. 1 Girl Candy Films
24 Against Her Will New Sensations
25 Mom’s Favorite Babysitter Love’s Kitty

I wonder if Bill Gates every thinks about all the positive contributions he’s made to the fapping community.
Lela Star - Number 1 for August
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.

Lisa AnnIt’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.

Amy RiedI 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>
B: =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,7777777,C2),6666666,E2),9999999,D2)
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>

 

or:

Rank Porn Star
1 Lela Star
2 Angelina Crow
3 Nina Hartley
4 Rachel Steele
5 Bree Olson
6 Aletta Ocean
7 Angelica Sin
8 Lisa Ann
9 Sasha Grey
10 Britney Amber
11 Samantha Sin
12 Faye Reagan
13 Madison Young
14 Carmella Bing
15 Taylor Wane
16 Amy Ried
17 Sara Jay
18 Naughty Alysha
19 Shay Fox
20 Julia Ann
21 Gianna Michaels
22 Mandingo
23 Annabelle Flowers
24 Jenna Haze
25 Jenna Jameson

*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.
http://hotmoviesblog.com/files/2011/09/top_porn_stars-August.pdf