Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Readers > Sony Reader

Notices

Reply
 
Thread Tools Search this Thread
Old 01-26-2008, 11:15 PM   #1
anotherchance
Zealot
anotherchance will become famous soon enoughanotherchance will become famous soon enoughanotherchance will become famous soon enoughanotherchance will become famous soon enoughanotherchance will become famous soon enoughanotherchance will become famous soon enough
 
anotherchance's Avatar
 
Posts: 115
Karma: 666
Join Date: Sep 2006
Location: Philadelphia, PA
Device: PRS-505
Google Spreadsheet of Sony eBook Store category totals

I just spent the last half-hour putting this Google spreadsheet together as a proof of concept. It should make keeping track of the totals on the Sony site very easy, and I'd be able to update it about once a week. The chart will update automatically as new data is added.

Here's the link to the spreadsheet:
View Spreadsheet

The chart itself has its own image URL although it doesn't look like I can embed it on this forum as an IMG. It should embed in other webpages as the SRC of an <img> tag.
http://spreadsheets.google.com/pub?k...2&output=image

Last edited by anotherchance; 01-27-2008 at 09:54 AM. Reason: redundant sentence, now I have more data
anotherchance is offline   Reply With Quote
Old 01-27-2008, 03:16 AM   #2
Zevs
Book lover!!
Zevs doesn't litterZevs doesn't litter
 
Zevs's Avatar
 
Posts: 133
Karma: 182
Join Date: Jan 2007
Device: Sony Reader 505; Nowadays Stanza, Kindle, Txtr and Bluefire on iPhone
Thanks very much for this Anotherchance!

You should also talk to Vivaldirules about this I think, he is also following the number of books in different categories, see the link below

http://www.mobileread.com/forums/showthread.php?t=16810

Zevs
Zevs is offline   Reply With Quote
Old 01-27-2008, 09:11 AM   #3
anotherchance
Zealot
anotherchance will become famous soon enoughanotherchance will become famous soon enoughanotherchance will become famous soon enoughanotherchance will become famous soon enoughanotherchance will become famous soon enoughanotherchance will become famous soon enough
 
anotherchance's Avatar
 
Posts: 115
Karma: 666
Join Date: Sep 2006
Location: Philadelphia, PA
Device: PRS-505
Thanks. I've found the TXT file with the historical data in it. I'll see if I can import it to my spreadsheet today.
anotherchance is offline   Reply With Quote
Old 01-27-2008, 09:17 AM   #4
Zevs
Book lover!!
Zevs doesn't litterZevs doesn't litter
 
Zevs's Avatar
 
Posts: 133
Karma: 182
Join Date: Jan 2007
Device: Sony Reader 505; Nowadays Stanza, Kindle, Txtr and Bluefire on iPhone
Quote:
Originally Posted by anotherchance View Post
Thanks. I've found the TXT file with the historical data in it. I'll see if I can import it to my spreadsheet today.
Yes, that would be great!

Zevs
Zevs is offline   Reply With Quote
Old 01-27-2008, 09:24 AM   #5
anotherchance
Zealot
anotherchance will become famous soon enoughanotherchance will become famous soon enoughanotherchance will become famous soon enoughanotherchance will become famous soon enoughanotherchance will become famous soon enoughanotherchance will become famous soon enough
 
anotherchance's Avatar
 
Posts: 115
Karma: 666
Join Date: Sep 2006
Location: Philadelphia, PA
Device: PRS-505
Done it. Easy peasy. Republished spreadsheet is now available.

Last edited by anotherchance; 01-27-2008 at 09:43 AM. Reason: add link
anotherchance is offline   Reply With Quote
Old 01-27-2008, 11:05 AM   #6
vivaldirules
When's Doughnut Day?
vivaldirules ought to be getting tired of karma fortunes by now.vivaldirules ought to be getting tired of karma fortunes by now.vivaldirules ought to be getting tired of karma fortunes by now.vivaldirules ought to be getting tired of karma fortunes by now.vivaldirules ought to be getting tired of karma fortunes by now.vivaldirules ought to be getting tired of karma fortunes by now.vivaldirules ought to be getting tired of karma fortunes by now.vivaldirules ought to be getting tired of karma fortunes by now.vivaldirules ought to be getting tired of karma fortunes by now.vivaldirules ought to be getting tired of karma fortunes by now.vivaldirules ought to be getting tired of karma fortunes by now.
 
vivaldirules's Avatar
 
Posts: 10,049
Karma: 13675425
Join Date: Jul 2007
Location: Houston, TX, US
Device: Sony PRS-505, iPad
Well done!
vivaldirules is offline   Reply With Quote
Old 01-27-2008, 11:11 AM   #7
Zevs
Book lover!!
Zevs doesn't litterZevs doesn't litter
 
Zevs's Avatar
 
Posts: 133
Karma: 182
Join Date: Jan 2007
Device: Sony Reader 505; Nowadays Stanza, Kindle, Txtr and Bluefire on iPhone
Very good anotherchance!

Thanks for doing this! Interesting to see how much Science & Nature has grown! Must be a lot if interest there! I'm disappointed by the change in Travel books, very slow increase there. Would have expected that section to be bigger, but have noticed that there were very few additions during last year.

Zevs
Zevs is offline   Reply With Quote
Old 01-27-2008, 11:59 AM   #8
vivaldirules
When's Doughnut Day?
vivaldirules ought to be getting tired of karma fortunes by now.vivaldirules ought to be getting tired of karma fortunes by now.vivaldirules ought to be getting tired of karma fortunes by now.vivaldirules ought to be getting tired of karma fortunes by now.vivaldirules ought to be getting tired of karma fortunes by now.vivaldirules ought to be getting tired of karma fortunes by now.vivaldirules ought to be getting tired of karma fortunes by now.vivaldirules ought to be getting tired of karma fortunes by now.vivaldirules ought to be getting tired of karma fortunes by now.vivaldirules ought to be getting tired of karma fortunes by now.vivaldirules ought to be getting tired of karma fortunes by now.
 
vivaldirules's Avatar
 
Posts: 10,049
Karma: 13675425
Join Date: Jul 2007
Location: Houston, TX, US
Device: Sony PRS-505, iPad
Anyone interested in doing something like this for other vendors, particularly Amazon? I think many people will be insterested in seeing data on the growth of ebook titles for sale.
vivaldirules is offline   Reply With Quote
Old 01-29-2008, 03:29 AM   #9
HarryT
eBook Enthusiast
HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.
 
HarryT's Avatar
 
Posts: 65,640
Karma: 44618293
Join Date: Nov 2006
Location: UK
Device: Kindle Voyage, iPad Mini, iPhone 4, MS Surface Pro, N7
How are you allowing for books which are present in multiple categories? What proportion of books are in multiple categories?
HarryT is offline   Reply With Quote
Old 01-29-2008, 10:32 AM   #10
anotherchance
Zealot
anotherchance will become famous soon enoughanotherchance will become famous soon enoughanotherchance will become famous soon enoughanotherchance will become famous soon enoughanotherchance will become famous soon enoughanotherchance will become famous soon enough
 
anotherchance's Avatar
 
Posts: 115
Karma: 666
Join Date: Sep 2006
Location: Philadelphia, PA
Device: PRS-505
Quote:
Originally Posted by HarryT View Post
How are you allowing for books which are present in multiple categories? What proportion of books are in multiple categories?
I'm not, and the user who'd been collecting the data back to September hadn't been either. I don't think there's really a way we can accurately calculate how many books cross categories, but even if you call it 25% (seems unlikely), then we're still looking at a good 25,000 books.
anotherchance is offline   Reply With Quote
Old 02-02-2008, 01:08 PM   #11
anotherchance
Zealot
anotherchance will become famous soon enoughanotherchance will become famous soon enoughanotherchance will become famous soon enoughanotherchance will become famous soon enoughanotherchance will become famous soon enoughanotherchance will become famous soon enough
 
anotherchance's Avatar
 
Posts: 115
Karma: 666
Join Date: Sep 2006
Location: Philadelphia, PA
Device: PRS-505
Nearly 2000 titles have been added in the past week, about 1000 of which were science-fiction. 34,020 is the new grand total. I've updated the Google Spreadsheet this morning. I also modified the URLs in the first column to be sorted by "newly added".

It took me about 2 minutes to update this spreadsheet, as I had all 19 URLs in a Firefox Bookmark folder and opened all 19 pages in new tabs with a single click. It was then so easy to run down the tab list and gather the latest totals for the spreadsheet.

Last edited by anotherchance; 02-02-2008 at 01:19 PM.
anotherchance is offline   Reply With Quote
Old 02-02-2008, 01:21 PM   #12
Zevs
Book lover!!
Zevs doesn't litterZevs doesn't litter
 
Zevs's Avatar
 
Posts: 133
Karma: 182
Join Date: Jan 2007
Device: Sony Reader 505; Nowadays Stanza, Kindle, Txtr and Bluefire on iPhone
Thanks again Anotherchance for doing this! I guess they finally realized people do like SF! I think a number of people will be happy

Zevs
Zevs is offline   Reply With Quote
Old 02-02-2008, 01:34 PM   #13
JSWolf
Resident Curmudgeon
JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.
 
JSWolf's Avatar
 
Posts: 38,829
Karma: 19656443
Join Date: Nov 2006
Location: Roslindale, Massachusetts
Device: Kobo Aura H2O, Sony PRS-650, Sony PRS-T1, nook STR, iPad 1, iPhone 5
Quote:
Originally Posted by HarryT View Post
How are you allowing for books which are present in multiple categories? What proportion of books are in multiple categories?
It's same sort of numbering as people are using for Amazon's eBooks. Just getting the raw number and not weeding out any possible dupes.

On Amazon's website there are 9 different versions of Moby Dick for the Kindle. So if we weed out stuff like this, then we'll end up easily with less then 100,000 eBooks for the Kindle.

Yes, there are dupes in the count from Sony's site. Who really is going tog o and weed out the dupes? It's not worth anyone's time and effort to do so.
JSWolf is online now   Reply With Quote
Old 02-02-2008, 02:39 PM   #14
vivaldirules
When's Doughnut Day?
vivaldirules ought to be getting tired of karma fortunes by now.vivaldirules ought to be getting tired of karma fortunes by now.vivaldirules ought to be getting tired of karma fortunes by now.vivaldirules ought to be getting tired of karma fortunes by now.vivaldirules ought to be getting tired of karma fortunes by now.vivaldirules ought to be getting tired of karma fortunes by now.vivaldirules ought to be getting tired of karma fortunes by now.vivaldirules ought to be getting tired of karma fortunes by now.vivaldirules ought to be getting tired of karma fortunes by now.vivaldirules ought to be getting tired of karma fortunes by now.vivaldirules ought to be getting tired of karma fortunes by now.
 
vivaldirules's Avatar
 
Posts: 10,049
Karma: 13675425
Join Date: Jul 2007
Location: Houston, TX, US
Device: Sony PRS-505, iPad
Quote:
Originally Posted by JSWolf View Post
Yes, there are dupes in the count from Sony's site. Who really is going tog o and weed out the dupes? It's not worth anyone's time and effort to do so.
It's easy to at least get a feel for how many duplicate entries exist on the Sony website. Just search for a particular title or author within a given category and repeat that search in several other likely categories. For example, search for ebooks by Poe in Fiction and Literature and there are eleven ebooks shown with him as author. Do the same search under the category Horror or under Mysteries and Thrillers and there are zero listed. I have done this type of searching several times and I'm not sure if I ever found even one title listed in more than one category. So my impression is that the total number of ebooks available at the Sony site is closely approximated by the sum of the total ebooks found in each category. If someone finds something different, it would be good to know that.
vivaldirules is offline   Reply With Quote
Old 02-02-2008, 02:59 PM   #15
vivaldirules
When's Doughnut Day?
vivaldirules ought to be getting tired of karma fortunes by now.vivaldirules ought to be getting tired of karma fortunes by now.vivaldirules ought to be getting tired of karma fortunes by now.vivaldirules ought to be getting tired of karma fortunes by now.vivaldirules ought to be getting tired of karma fortunes by now.vivaldirules ought to be getting tired of karma fortunes by now.vivaldirules ought to be getting tired of karma fortunes by now.vivaldirules ought to be getting tired of karma fortunes by now.vivaldirules ought to be getting tired of karma fortunes by now.vivaldirules ought to be getting tired of karma fortunes by now.vivaldirules ought to be getting tired of karma fortunes by now.
 
vivaldirules's Avatar
 
Posts: 10,049
Karma: 13675425
Join Date: Jul 2007
Location: Houston, TX, US
Device: Sony PRS-505, iPad
Quote:
Originally Posted by vivaldirules View Post
I have done this type of searching several times and I'm not sure if I ever found even one title listed in more than one category.
Well, I just found a few duplicates. Search for Clinton under Biographies and under Politics and Government and a few of the hits appear in both categories. I've tried a dozen other searches of likely duplicates and haven't found any.
vivaldirules is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Sony eBook Store difficulty? Martin S Sony Reader 5 12-08-2009 06:36 PM
sony ebook store or amazon? ankit Sony Reader 1 10-16-2009 04:11 PM
created spreadsheet of 6 inch ebook readers ribcookie News 1 01-01-2009 01:30 PM
Sony eBook Store sakura-panda Sony Reader 4 10-30-2008 05:17 AM
Sony eBook Store - 20% off any title TadW Deals, Freebies, and Resources (No Self-Promotion) 7 08-20-2008 01:06 AM


All times are GMT -4. The time now is 09:03 PM.


MobileRead.com is a privately owned, operated and funded community.