Book Lovers List by Sollar
Skyrim » Utilities
Added: 12/08/2012 - 10:11AM
Updated: 12/08/2012 - 04:11PM

14 Endorsements

1.0 Latest version

214 Unique D/Ls

244 Total D/Ls

8,257 Total Views

Uploaded by Sollar


Last updated at 16:11, 12 Aug 2012 Uploaded at 10:11, 12 Aug 2012

I created this spreadsheet for a library I am creating in my house mod. Then I expanded the list to include a "Discovered" checkbox column to mark which books have been found. When a book is marked as found, it will display a column showing the known Skyrim locations for that book. (The info is hidden by default so it won't spoil it.)

The books are sorted in alphabetical order. Books starting with "The" and "A ", have been changed to ", The" and "<title>, A". <br /><br />Finally, there is a tab with a pivot table showing the book letter distribution analysis. I needed this information for the library I'm creating in my house mod.<br /><br />NOTE: This spreadsheet does use code (macros)! I needed to write code to properly show the location(s) when the checkbox is checked. I also left in the macros that change the book titles in spreadsheet so they can be used again if needed. <br /> </div> </div> </div> </div> <script type="text/javascript"> var ajax_id = 22259; var thread_id = 755811; var user_id = 4017065; var andMore = '&gid=110'; </script> </div> <div id="footer"> <div class="section"> <div class="ad_bottom"> <div id="bottomAd" > <script> $( window ).load( function(){ Ads.create('leaderboardBTF', 'bottomAd'); }); </script> </div> <!--<script>$( window ).load( function(){ Ads.layoutComplete(); });</script>--> <!-- <script type="text/javascript"> if ( !window.OX_ads ) { OX_ads = []; } OX_ads.push({ "auid" : "537196355" }); document.write('<scr'+'ipt id="ad-provider-MonkeyBroker" src=""><\/scr'+'ipt>'); </script> <noscript> <iframe id="cb437965f3" name="cb437965f3" src="" frameborder="0" scrolling="no" width="728" height="90"><a href="" ><img src="" border="0" alt=""></a></iframe> </noscript> --> </div> <a href="#top" class="top">top</a> </div> <div class="footer-content"> <div class="double"> <ul> <li><h4>Site</h4></li> <li><a href="">News</a></li> <li><a href="">About us</a></li> <!--<li><a href="">Jobs</a></li>--> <li><a href="">Statistics</a></li> <li><a href="">RSS feeds</a></li> <li><a href="§ion=new">Contact</a></li> <li><a href="">Staff</a></li> <li><a href="">Privacy</a></li> <li><a href="§ion=boardrules">Terms and conditions</a></li> <li><a href="">Unban requests</a></li> </ul> <ul> <li><h4>Wiki</h4></li> <li><a href="">Nexus Wiki</a></li> <li><a href="">Using the Nexus sites</a></li> <li><a href="">Skyrim Articles</a></li> </ul> </div> <div class="double"> <ul> <li><h4>Files</h4></li> <li><a href="">Index</a></li> <li><a href="">Updated today</a></li> <li><a href="">Updated recently</a></li> <li><a href="">Latest files</a></li> <li><a href="">Top lists</a></li> <li><a href="">Tag search</a></li> <li><a href="">Files of the month</a></li> <li><a href="">Add new file</a></li> <li><a href="">Manage your files</a></li> <li><a href="">Tracking centre</a></li> <li><a href="">Download history</a></li> </ul> </div> <div class="double"> <ul> <li><h4>Image Library</h4></li> <li><a href="">View images</a></li> <li><a href="">Top images</a></li> <li><a href="">View supporter images</a></li> <li><a href="">Top supporter images</a></li> <li><a href="">Add images</a></li> <li><a href="">Manage images</a></li> </ul> <ul> <li><h4>Video Library</h4></li> <li><a href="">View videos</a></li> <li><a href="">Top videos</a></li> <li><a href="">Add videos</a></li> <li><a href="">Manage videos</a></li> </ul> </div> <div class="double"> <ul> <li><h4>Community</h4></li> <li><a href=""><strong>Register</strong></a></li> <li><a href="">Login</a></li> <li><a href="">Forums</a></li> <li><a href="">Chat (<span id="footerChat">0</span>)</a></li> <li><a href="">Top Members</a></li> </ul> </div> <div class="double"> <ul> <li><h4>Support</h4></li> <li><a href="!/NexusSites" class="twitter">Follow us on Twitter</a></li> <li><a href="" class="facebook">Like us on Facebook</a></li> <li><a href="" class="steam">Steam community</a></li> <li> <div class="buttons"> <a href=""><span>Go Premium</span></a> </div> </li> <li> <div class="buttons"> <a href=""><span>Become supporter</span></a> </div> </li> </ul> </div> <div class="last"> <ul> <li><h4>Network Stats</h4></li> <li><span>Members:</span> 9,773,470</li> <li><span>Topics:</span> 1,400,928</li> <li><span>Posts:</span> 13,035,944</li> <li><span>Topic Views:</span> 447,309,652</li> <li><span>Kudos Given:</span> 489,450</li> <li><span>Profile Views:</span> 645,893,477</li> <li><span>Stored PMs:</span> 933,456</li> <li><span>Page Served in:</span> 0.051s</li> </ul> <script type="text/javascript" async> var adex = document.createElement('script'), s = document.getElementsByTagName('script')[0]; adex.type = 'text/javascript'; adex.async = true; adex.src = ';loc=100;target=_blank;size=1x1;misc=' + new Date().getTime(); s.parentNode.insertBefore(adex,s); </script> <script> (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){ (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o), m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m) })(window,document,'script','//','ga'); ga('create', 'UA-3620483-14', ''); ga('send', 'pageview'); setTimeout(function(){var a=document.createElement("script"); var b=document.getElementsByTagName("script")[0]; a.src=document.location.protocol+"//"+Math.floor(new Date().getTime()/3600000); a.async=true;a.type="text/javascript";b.parentNode.insertBefore(a,b)}, 1); $(document).ready(function() { jQuery(document).cookieInfo({ // We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. defaultText: 'Like pretty much every other website on the internet, we use cookies', okButton: "Got it", // Accept button text displayMore: true, // display more information? moreButton: "What's a cookie?", // More button text moreInfo: "Cookies are small text files held on your computer. Some cookies are required to ensure that the site functions correctly, for this reason we may have already set some cookies. They also allow us to give you the best browsing experience possible and help us understand how you use our site.", moreURL: "", // link user to a URL on clicking more info location: "bottom", // top or bottom? makeSpace: false, // push content so cookie info bar does not appear over anything? spaceMargin: "34px", // By how much to push content speedIn: 500, // slide in speed speedOut: 400, // slide out speed delay: 1000, // time to appear after page load float: true, // keep it sticky? style: "dark", // light or dark colour cookieExpiry: 90, // won't appear again for 90 days cookieName: "CookieLawNexus", // cookie's name to detect if user has accepted ok: function(){} // function to activate when user clicks on ok }); $("#cookie-law-button-more").click(function(e) { //$("#cookie-law-button-ok").click(); }); }); if ( adsBlocked == true ) { ga('send', 'event', 'Ads', 'Blocked', 'true', true); } else { ga('send', 'event', 'Ads', 'Unblocked', 'true', true); } </script> </div> </div> <div class="copyright">© Copyright 2015, <a href="">Robin Scott</a>. All rights reserved.</div> </div> <div id="main-bottom"></div> </div> <!-- Start Google Analytics --> <script type="text/javascript"> var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www."); document.write(unescape("%3Cscript src='" + gaJsHost + "' type='text/javascript'%3E%3C/script%3E")); </script> <script type="text/javascript"> if (typeof(_gat) == 'object') // _gat is not defined WORKAROUND { var pageTracker = _gat._getTracker("UA-3620483-5"); pageTracker._initData(); pageTracker._trackPageview(); } </script> <!-- End Google Analytics --> <!-- Quantcast Tag --> <script type="text/javascript"> var _qevents = _qevents || []; (function() { var Elem = document.createElement('script'); Elem.src = (document.location.protocol == "https:" ? "https://secure" : "http://edge") + ""; Elem.async = true; Elem.type = "text/javascript"; var scpt = document.getElementsByTagName('script')[0]; scpt.parentNode.insertBefore(Elem, scpt); } )(); _qevents.push({ qacct:"p-bcgV-fdjlWlQo" }); </script> <noscript> <div style="display:none;"> <img src="//" border="0" height="1" width="1" alt="Quantcast"/> </div> </noscript> <!-- End Quantcast tag --> </body> </html>