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

10 Endorsements

1.0 Latest version

214 Unique D/Ls

244 Total D/Ls

7,591 Total Views

Uploaded by Sollar

Description

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'; // $('#fcontentarea').loadPage('http://www.nexusmods.com/skyrim/ajax/moddescription/?pUp=1&id=22259&gid=110'); </script> </div> <div id="footer"> <div class="section"> <div class="ad_bottom"> <script type="text/javascript"> if ( !window.OX_ads ) { OX_ads = []; } OX_ads.push({ "auid" : "537196355" }); document.write('<scr'+'ipt src="http://ox-d.zam.com/w/1.0/jstag"><\/scr'+'ipt>'); </script> <noscript> <iframe id="cb437965f3" name="cb437965f3" src="http://ox-d.zam.com/w/1.0/afr?auid=537196355&cb=511758226" frameborder="0" scrolling="no" width="728" height="90"><a href="http://ox-d.zam.com/w/1.0/rc?cs=cb437965f3&cb=511758226" ><img src="http://ox-d.zam.com/w/1.0/ai?auid=537196355&cs=cb437965f3&cb=511758226" 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="http://www.nexusmods.com/skyrim/news/archive/">News</a></li> <li><a href="http://www.nexusmods.com/skyrim/about/about/">About us</a></li> <li><a href="http://www.nexusmods.com/skyrim/about/webstats/">Statistics</a></li> <li><a href="http://www.nexusmods.com/skyrim/rss/">RSS feeds</a></li> <li><a href="http://forums.nexusmods.com/index.php?app=nexus&module=support§ion=new">Contact</a></li> <li><a href="http://www.nexusmods.com/skyrim/users/top/">Staff</a></li> <li><a href="http://www.nexusmods.com/skyrim/about/netdeveloper/">Jobs</a></li> <li><a href="http://www.nexusmods.com/skyrim/about/privacy/">Privacy</a></li> <li><a href="http://www.nexusmods.com/skyrim/about/unban/">Unban requests</a></li> </ul> <ul> <li><h4>Wiki</h4></li> <li><a href="http://wiki.tesnexus.com/">Nexus Wiki</a></li> <li><a href="http://wiki.tesnexus.com/index.php/Category:Using_the_Nexus_sites">Using the Nexus sites</a></li> <li><a href="http://wiki.tesnexus.com/index.php/Category:Skyrim">Skyrim Articles</a></li> </ul> </div> <div class="double"> <ul> <li><h4>Files</h4></li> <li><a href="http://www.nexusmods.com/skyrim/mods/categories/">Index</a></li> <li><a href="http://www.nexusmods.com/skyrim/mods/newtoday/">Updated today</a></li> <li><a href="http://www.nexusmods.com/skyrim/mods/newrecently/">Updated recently</a></li> <li><a href="http://www.nexusmods.com/skyrim/mods/latestmods/">Latest files</a></li> <li><a href="http://www.nexusmods.com/skyrim/mods/top/">Top lists</a></li> <li><a href="http://www.nexusmods.com/skyrim/mods/tags/">Tag search</a></li> <li><a href="http://www.nexusmods.com/skyrim/mods/modsofthemonth/">Files of the month</a></li> <li><a href="http://www.nexusmods.com/skyrim/mods/new/">Add new file</a></li> <li><a href="http://www.nexusmods.com/skyrim/mods/manage/">Manage your files</a></li> <li><a href="http://www.nexusmods.com/skyrim/mods/track/">Tracking centre</a></li> <li><a href="http://www.nexusmods.com/skyrim/mods/history/">Download history</a></li> </ul> </div> <div class="double"> <ul> <li><h4>Image Library</h4></li> <li><a href="http://www.nexusmods.com/skyrim/images/view/">View images</a></li> <li><a href="http://www.nexusmods.com/skyrim/images/top">Top images</a></li> <li><a href="http://www.nexusmods.com/skyrim/supporterimages/View/">View supporter images</a></li> <li><a href="http://www.nexusmods.com/skyrim/supporterimages/Top/">Top supporter images</a></li> <li><a href="http://www.nexusmods.com/skyrim/images/add/">Add images</a></li> <li><a href="http://www.nexusmods.com/skyrim/images/manage/">Manage images</a></li> </ul> <ul> <li><h4>Video Library</h4></li> <li><a href="http://www.nexusmods.com/skyrim/videos/view/">View videos</a></li> <li><a href="http://www.nexusmods.com/skyrim/videos/top">Top videos</a></li> <li><a href="http://www.nexusmods.com/skyrim/videos/add/">Add videos</a></li> <li><a href="http://www.nexusmods.com/skyrim/videos/manage/">Manage videos</a></li> </ul> </div> <div class="double"> <ul> <li><h4>Community</h4></li> <li><a href="http://www.nexusmods.com/skyrim/users/register/"><strong>Register</strong></a></li> <li><a href="http://www.nexusmods.com/skyrim/users/login/">Login</a></li> <li><a href="http://forums.nexusmods.com">Forums</a></li> <li><a href="http://forums.nexusmods.com/index.php?app=ipchat">Chat (<span id="footerChat">0</span>)</a></li> <li><a href="http://www.nexusmods.com/skyrim/users/top/">Top Members</a></li> </ul> </div> <div class="double"> <ul> <li><h4>Support</h4></li> <li><a href="http://www.twitter.com/#!/NexusSites" class="twitter">Follow us on Twitter</a></li> <li><a href="http://www.facebook.com/pages/Nexus-sites/71629282833?ref=mf" class="facebook">Like us on Facebook</a></li> <li><a href="http://www.steamcommunity.com/groups/nexussites" class="steam">Steam community</a></li> <li> <div class="buttons"> <a href="http://www.nexusmods.com/skyrim/users/premium/"><span>Go Premium</span></a> </div> </li> </ul> </div> <div class="last"> <ul> <li><h4>Network Stats</h4></li> <li><span>Members:</span> 8,334,773</li> <li><span>Topics:</span> 1,222,492</li> <li><span>Posts:</span> 11,355,060</li> <li><span>Topic Views:</span> 353,083,269</li> <li><span>Kudos Given:</span> 409,774</li> <li><span>Profile Views:</span> 283,101,379</li> <li><span>Stored PMs:</span> 852,495</li> <li><span>Page Served in:</span> 0.073s</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 = 'http://adserver.adtechus.com/addyn/3.0/5353.1/2413182/0/16/ADTECH;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','//www.google-analytics.com/analytics.js','ga'); ga('create', 'UA-3620483-14', 'nexusmods.com'); ga('send', 'pageview'); </script> </div> </div> <div class="copyright">© Copyright 2014, <a href="http://www.blacktreegaming.com">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 + "google-analytics.com/ga.js' 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") + ".quantserve.com/quant.js"; 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="//pixel.quantserve.com/pixel/p-bcgV-fdjlWlQo.gif" border="0" height="1" width="1" alt="Quantcast"/> </div> </noscript> <!-- End Quantcast tag --> </body> </html>