{"id":25616,"date":"2023-09-20T18:10:39","date_gmt":"2023-09-20T18:10:39","guid":{"rendered":"https:\/\/jurn.link\/jurnsearch\/?p=25616"},"modified":"2023-12-03T18:31:01","modified_gmt":"2023-12-03T18:31:01","slug":"microsofts-ai-voices-and-project-gutenberg","status":"publish","type":"post","link":"https:\/\/jurn.link\/jurnsearch\/index.php\/2023\/09\/20\/microsofts-ai-voices-and-project-gutenberg\/","title":{"rendered":"Microsoft&#8217;s AI voices and Project Gutenberg"},"content":{"rendered":"<p>Microsoft has used its advanced AI text-to-speech voices to <a href=\"https:\/\/web.archive.org\/web\/20230926141414\/https:\/\/archive.org\/details\/@project_gutenberg_and_microsoft?tab=uploads\">produce free audiobooks of all 4,840 Project Gutenberg books<\/a>.<\/p>\n<p>There\u2019s now a handy single-page Browse list, but it\u2019s A-Z by title rather than by author. So I made a quick Excel .XLS ordered A-Z by author, with the clickable hyperlink retained on each title. The links are to .MP3 files, and of course to get them your Excel needs to be allowed online.<\/p>\n<p>.XLS for Excel (as PDF): <em>(sadly lost on the blog move) <\/em><\/p>\n<hr>\n<p><strong>Tutorial:<\/strong><\/p>\n<p>There are times when Excel fails to automatically paste into two columns. So here\u2019s how to sort a list such as this \u2018by every nth line\u2019, using the handy Kutools plug-in for Excel. No \u2018wrestling with formulas\u2019 is needed here\u2026<\/p>\n<p>1. Highlight and Crtl + C copy the list from the source. The data must be clean, meaning strictly line 1 then the matching line 2, consistently all the way down.<\/p>\n<p>2. Paste the list to the first Excel column.<\/p>\n<p>3. Top tabs bar | Kutools tab | Range | Transform Range.<\/p>\n<p>4. The \u201cData to be transformed\u201d box is automatically filled in for you. You just need to type in the \u201cFixed Value\u201d. Here we want \u201c2\u201d. Then check the output demo looks correct. Press OK.<\/p>\n<p>5. You\u2019re taken to the next box. Don\u2019t type anything. Instead you just click on the first cell of your target column. I chose \u201cC\u201d. The \u201coutput range\u201d box will then be auto-filled with a bit of Excel\u2019s magic gibberish. Press OK.<\/p>\n<p>6. Processing will then start. Let it run, for a big list. It can happily process over 9,000 lines.<\/p>\n<p>7. All done. The list has been separated into two columns. By extracting every line, then the following line, and so on down the column list.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft has used its advanced AI text-to-speech voices to produce free audiobooks of all 4,840 Project Gutenberg books. There\u2019s now &hellip;<\/p>\n<p><a href=\"https:\/\/jurn.link\/jurnsearch\/index.php\/2023\/09\/20\/microsofts-ai-voices-and-project-gutenberg\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-25616","post","type-post","status-publish","format-standard","hentry","category-jurn-tips-and-tricks"],"_links":{"self":[{"href":"https:\/\/jurn.link\/jurnsearch\/index.php\/wp-json\/wp\/v2\/posts\/25616","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jurn.link\/jurnsearch\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jurn.link\/jurnsearch\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jurn.link\/jurnsearch\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jurn.link\/jurnsearch\/index.php\/wp-json\/wp\/v2\/comments?post=25616"}],"version-history":[{"count":1,"href":"https:\/\/jurn.link\/jurnsearch\/index.php\/wp-json\/wp\/v2\/posts\/25616\/revisions"}],"predecessor-version":[{"id":25617,"href":"https:\/\/jurn.link\/jurnsearch\/index.php\/wp-json\/wp\/v2\/posts\/25616\/revisions\/25617"}],"wp:attachment":[{"href":"https:\/\/jurn.link\/jurnsearch\/index.php\/wp-json\/wp\/v2\/media?parent=25616"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jurn.link\/jurnsearch\/index.php\/wp-json\/wp\/v2\/categories?post=25616"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jurn.link\/jurnsearch\/index.php\/wp-json\/wp\/v2\/tags?post=25616"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}