Blog

 

The Lord of the Rings is an epic trilogy of adventure, camaraderie, and fantasy. The worldwide phenomenon is arguably one of the greatest movie series to ever be made.

The Elder Scrolls IV: Oblivion is the fourth game of the Elder Scrolls series, and upon its release in 2006 revolutionized how gamers play. People still ten years later actively play and discover the hundreds of hours of adventure, exploration, and quest lines the great game has to offer.

There are a few obvious similarities between the two: there’s the fantasy element, dragons, orcs, wizards, but there are several more subtle attributes relating these two epic journeys.

 

If you’ve never seen the Lord of the Rings and or played Oblivion this contains spoilers.

The Grand Finale:

In the Lord of the Rings, a hobbit named Frodo Baggins lives a simple, peaceful life in the shire until one day his estranged uncle Bilbo bequeaths to him a mysterious ring before disappearing. As it turns out, the ring was forged by the Dark Lord Sauron and is the most powerful ring ever forged, it acts as a tether to a world of doom and destruction. Frodo volunteers for an unexpected journey to destroy the ring with the help of a fellowship, a group of brave men who set out on a quest to Mount Doom where he can throw the ring back into the fires of which it was created and save Middle Earth from the horrific destruction threatening to be inflicted by Sauron.

As his long journey finally comes to an end and the dark walls of Mount Doom threaten to collapse around him, Frodo did what he had traveled many miles to do. Tapping into his last reserve of strength he hurled The Ring into the fiery depths of Mount Doom and barely escaped with his life. Outside, he and his friend Sam flung themselves onto a ledge as lava gushed out around them.

Many miles away a different battle was happening; Aragorn, Legolas, Gimli, and Gandalf were fighting for their lives and the lives of all men. They fought the orcs relentlessly, almost to the death. As friends and foes alike fell around them a shriek pierced the air. The instant the ring sank into the lava of Mount Doom the change was obvious, Sauron’s eye, which once ominously loomed over them all shattered, and the army of orcs fled as the ground cracked beneath their feet. Aragorn was crowned king and restored peace to the realm of men.

On the continent of Tamriel in another world of men and mer, a different hero was emerging.

The hero of Kvatch, who started as nothing but a lowly no one has overcome unimaginable challenges for this final, epic battle in the Imperial City. The heart of the free world of men. The choices: defeat Mehrunes Dagon or watch Cyrodiil and all of Tamriel fall into the gates of Oblivion. But the hero cannot do it alone, he needs Martin Septim. Martin, the last, secret, air of the Septim Dynasty. Only he can wear the amulet of kings.

The battle is not easy, many die, including Martin; who sacrifices himself for the good of Tamriel. As this final battle happens and Martin defeats Mehrunes Dagon the gates of oblivion seal shut forever and as they close, the hellions that once poured out of scatter and flee. Their ties to this world severed.

Here are a few more subtle connections between the two tales –

  • The gates of oblivion are the inverse of Sauron’s eye.

  • The hero prefers to be secret: Aragon AKA Night Rider only assumed the throne of Gondor when all else had failed. And Martin lived a quiet, secret life before taking the ancestral form of a Dragon to defeat Mehrunes Dagon and save Tamriel from destruction.
  • The Lord of the Rings Trilogy takes place in Middle Earth, the realm of men. Oblivion takes place in Cyrodiil, the center of Tamriel and the province of men.
  • When Sauron’s Eye falls the army of Orcs flee as the ground shatters and crumbles beneath them. When Mehrunes Dagon is defeated and the gates of Oblivion explode the army of Daedra flee and ultimately vanish from Tamerial.
  • The events of the Lord of the Rings take place in the Third Age of Middle Earth and as Aragorn is crowned king so begins the Fourth Age, the age of men. The Oblivion Crisis is the closing event of the third era and upon the defeat of Mehrunes Dagon and the assassination of the last of the Septim Dynasty the fourth era begins.
  • In the Lord of the Rings, Sauron created the ring in the First Age when he tried to take over the world using the One Ring to control all the others,

“Three Rings for the Elven-kings under the sky,

Seven for the Dwarf-lords in their halls of stone,

Nine for Mortal Men doomed to die,

One for the Dark Lord on his dark throne

In the Land of Mordor where the Shadows lie.

One Ring to rule them all, One Ring to find them,

One Ring to bring them all and in the darkness bind them

In the Land of Mordor where the Shadows lie.”

 

He was defeated and fled to strengthen his armies and grow his power. Ages past and eventually the One Ring was forgotten with the tales of time. During the Third Age Sauron attempts his final plan for world domination which fails when Frodo destroys the ring.

Mehrunes Dagon first attempts to conquer Tamriel in the First Era in the province of Morrowind but he was defeated and reemerged in the third era with the aid of the Mythic Dawn cult who carried out his commands of assassinating all the living Septims, except for Martin, whose identity had been kept secret which leads to his final demise.

The deeper you read into the lore of the two series you the more connections you discover.

While the events of the Oblivion Crisis are carrying out a larger prophecy that began in the very first Elder Scrolls game, Arena, which released in 1994 it’s clear that the Bethesda Game designers were fans of the Lord of the Rings and reflected their admirations into their own designs. This provided an excellent sense of familiarity to their fan base and celebrated the carrying on of a successful recipe for excellent fantasy entertainment.

 

Analysis

I take overwhelming data and find the small but vital takeaways.

One of my projects involves acquiring thousands of products from a variety of sources and shipping them to a vendor overseas. Over the last year and a half over 30,000 items have been shipped, many of which we borrowed from libraries that expected them to be returned eventually. After our first, small return shipment was almost double the cost we had anticipated my boss asked me to figure out exactly which products we have to return and to investigate every possible option of replacement so that we only return the essential items to mitigate the cost.

To start, I pulled a full export of all physical products we shipped out of the Inventory Locator. Once the items were all in an Excel spreadsheet I identified which set of products we needed to return, established a chart of all other possible avenues to replace them, reached out to fifteen Supply Planners to confirm which products we had duplicates of in the warehouse to order, and finally formed the list of items that could be replaced in no other way. Of the 30,000 items, I was able to relocate all but a third of the products.

Once my analysis of the products was complete I consolidated all of my research into a single page to provide my boss with a quick reference point for where products were coming from.

Organization  

I strive to make everything straight forward and logical.

When I first started working for Houghton Mifflin Harcourt we had a library. Or rather, we had several libraries. They were set apart by subject and reasonably organized by copyright year/market. While there was no digital home for all the inventory it was fairly easy to go to the library and find the book you needed.

A year ago we moved offices and with the move lost all our storage space for the libraries. Also since our move, I’ve taken ownership of an entire division of products from a recent business acquisition. My inventory of books totals 1,219. When they arrived disorganized and in unmarked boxes, it felt as though I’d simply drown in books. The sender clearly had not spent even a minute cataloging what they were sending, I found that I had received over 80 copies of one single book and entire programs I had requested did not arrive at all. I needed to organize, catalog, and store all these books. But where will they all fit? How could I possibly track all these titles, my manager asked me.

I created a 3 Phase plan to take inventory of what we had, eliminate all the duplicates for donation or trash, and organize all the products in a system where anyone on the team would be able to find the book they desired. Here’s how I did it:

Phase 1- Unboxing and piling

Once all the boxes were emptied I had stacks and stacks of books piling up in all the vacant cubicles. I did an initial sweep and pulled out as many duplicates as I could and divided the books into a series of categories.

  • Program Known (clearly labeled on the product)
  • Program Unknown
  • No barcode

Phase 2 – Cataloging and analysis

The quickest, most efficient way to take inventory of everything and weed out the duplicates was to scan the barcode of all the products into an excel sheet using a BCST-20 Scanner and then using vLookups identify which ISBN’s were repeated. As I can scanned I stacked the products in groups of 20 so I could easily move and locate specific products when I was ready to shelve them. For the items without a barcode, I manually entered the item number so those products could be included in the final list.

Once everything was scanned and the duplicates pulled out I used the list of ISBN’s to pull in other useful product information such as program, copyright, and title from the archive and mapped out where in our office each program would be housed in phase 3.

Phase 3 – Shelving

I moved the stacks to the bookshelves and alphabetized them within their program group before shelving the products so that they could easily be located later on. I also created a master excel list with every ISBN I scanned, the program, title, and location of the product so that anyone on the team could look up if we had a book and easily locate it.

Overall I pulled out an additional 331 copies of repeated titles and organized the remaining 888 books over the course of 2 business days and cataloged the entire inventory so that going forward anyone can find what they need in a matter of seconds.

Process Documenting 

One on one training is great for getting someone started, but if you’re like me then you prefer to stumble your way through a few examples. I ensure that everyone has access to any instructions they might need.

Over the course of my time with HMH, I’ve taken the task of documenting all our process as well as establishing a folder to easily store and locate materials.

Some of the things I’ve documented are a Cheat Sheet, Tool Navigation PowerPoint, and User Guide for a tool that I built.  In addition to those pieces, I’ve also written a walkthrough script for training new team members how to conduct our QA.

As the team expanded I realized we need a consistent outline to introduce each person with. I wrote the script to encompass the background of the project, the layout and structure of the tools and reports, the expectations for QA and when assignments are due, and to go over a set of specific examples of common errors. The script is also posted in case team members would like to reference back to it

Tags: 

User Guide for inventory locator

Once I completed the Inventory Locator, tested all its features for bugs, and prepped the tool for its official launch the need for a user guide became apparent. While the tool itself is designed to be operated with minimal user interaction, I knew a written explanation of the behind-the-scenes functions would help the team understand just what each button click entailed.

The breakdown

The twelve-page guide begins with how to download the tool. Because multiple team members could potentially be working in it at the same time the database is housed on a server and each user is asked to enter their name upon opening so changes are not overridden or corrupted.

Once the tool is open a small window appears asking you where you’d like to go, you have the option of going to the Control Panel, Product Lookup Page, or the tracker to update your progress.

After the tool is installed and the needed forum is open I describe the criteria behind each of the buttons. As a user, all that needs to be done is click the button, but behind the scenes, a specific set of criteria queries are conducted to complete the function for that source.

The buttons are in chronological, left-to-right, color coded order.  But one line consists of several queries I built to do all the work.

Line three – Corporate Archives

  1. Yellow Button – Pulls products without a method of acquisition and do not fall into a Material Group of Online, Digital, or Mobile App. When clicked the tool will export results to excel list so that an order can be submitted.
  2. Blue Button – creates an email addressed to the specific archive contact with the standard message request already typed as well as the required ordering number. All the user needs to do is attach the export list from the related yellow button.
  3. Green Button – works with the Material ID table in the center of the page. When you receive a response to one of the Physical locations paste the confirmed the material ID’s into this table and clicked the associated button. Once the button is clicked access first updates the product list for the specific confirmed ID’s, checks the box for located via Corporate Archive, and sets the method of acquisition to Physical, which prevents this product from being requested in later steps.

Inventory Acquisition Completed

Once the inventory process is complete and all available products have been located the tool can generate a shipment invoice and product Product Lists for each individual program when needed.

Final result

With the completed tool, published user guide, and recorded a demo of functionality anyone on the team has access to the instructions and resources they need to either learn a new project or refresh their memory on old process.

After the launch of the tool, we realized there was another way to use this resource: similar to a customer look up anyone company-wide has the option to locate the products they need from our vast, ever growing inventory. If there’s a copy to locate, we know where it is. Whether it’s stored in an office on a shelf, sealed away in a warehouse, or waiting online we have the information and have made it available for anyone to use.

Using a Phase II Tool

The main project I’ve worked on for the last three years is called Product Genealogy Phase II. In this project, we’re going through every page of every product by the program and verifying the image records. The work is done in an access tool and once a product is complete it must pass our internal Quality Assurance (QA) checks. We check that the image found on the page matches the record in the tool.

I started on this project as the first QA person and over the years the QA team has expanded to seven people, all of whom I’ve trained. When I started this project there was little to no documentation of the process, I was given a verbal introduction and simply asked questions as new issues arose. Over time as I QA’d more and more and brought people onto the team the need for written instruction and formal training became apparent. A project of this scale requires lots of time and much of it is hard to explain before it’s happened because there’s always a new issue we didn’t predict.

The bulk of our project work is completed in Microsoft Access databases. Most people, myself included, start the project with little to no knowledge of how to operate in the databases or find the desired information. Over time I have learned how to navigate in databases, create custom queries, import & export data with Excel, and build tables and relationships.

As part of my self-initiated project to document as many of the Phase II complexities as possible, I made a PowerPoint highlighting basic tips and tricks for using the tools in QA.

Main Page:

The main Genealogy Phase II Forum displays all the base records in the tool. The page is divided into sections which I then highlighted the critical information found in each with a brief description.

Secondary Page:

The second forum shows all the records derived from the bases. Again I highlighted the critical boxes, called out the most common error found from this page, and specifically pointed out that there are three different places the folio (page number) may be located.

Access Tips & Tricks:

In addition to displaying the layout and location of our information, the PowerPoint includes tricks for using access such as:

  • Right-clicking in any field gives you the option to set a customizable filter. You can do a contains or equals to search to find related records or view only the records for one set of pages at a time. 
  • If you apply too many or loose track of which fields are filtered, the orange Filtered button in the bottom right corner of the screen can be clicked and it will remove them all, restoring the page to its default view. Beside this button, you can see how many records fit the criteria and navigate through them using the arrows.
  • From inside a cell using CTRL + F will active a pop-up window to jump to a record.
  • Unlike other Microsoft programs, access automatically saves changes to the data once you’ve clicked out of the cell, and there is no undo feature. Through the nature of our QA, there should be no changes made to the tool as we are only viewing the information. If by accident something is changed or altered simply redownload a copy of the tool from SharePoint.

training documentation

The main project I’ve worked on for the last three years is called Product Genealogy Phase II. In this project, we’re going through every page of every product by the program and verifying the image records. The work is done in an access tool and once a product is complete it must pass our internal Quality Assurance (QA) checks. We check that the image found on the page matches the record in the tool.

I started on this project as the first QA person and over the years the QA team has expanded to seven people, all of whom I’ve trained. When I started this project there was little to no documentation of the process, I was given a verbal introduction and simply asked questions as new issues arose. Over time as I QA’d more and more and brought people onto the team the need for written instruction and formal training became apparent. A project of this scale requires lots of time and much of it is hard to explain before it’s happened because there’s always a new issue we didn’t predict.

How I improved the project:

To combat this sense of unknown, in addition to the lengthy, fully detailed process instructions for each component of the project I also wrote a cheat sheet to aid new team members with the process, key points, and general guidelines. The two-page document is easy to read, small enough to either print out and keep beside your computer or simply leave up on the second screen for reference as you work. In the cheat sheet, there are four main sections each with several bulleted points beneath for elaboration.

I broke down the different types of image records that could be found and listed the required components of each (example, something taken in-house should not have a third party credit or the latter).

I listed the four primary things the QA team should be checking for:

  1. The records in the tool are accurate representations of what’s found on the page.
  2. The records are assigned to the proper folio, and before a folio is marked as incorrect all three folio fields are checked.
  3. There is exactly one record for every image, no more, no less.
  4. Consistency. If a seemingly simple graphic has a record for one page, it should have a record for all pages it’s found on.

I explained each of the columns in our QA report and when they are applicable to fill in as well as broke down the process of checking the products. We examine every 3-5 pages unless there are a high number of errors. If the passing percentage falls below 60% halt QA and return the product for rework. The QA report I designed automatically calculates the passing percentage based on the number of passes vs. fails in the report.

I included four practical tips for viewing information in the access tools as most people are not immediately familiar with the sometimes complex functions and formats. As access is typically the steepest learning curve for new team members I created a PowerPoint further describing how to navigate in the tools.

  1. The Genealogy Phase II tab shows information from all the base records. The top box lists all the product details and the Spec AutoID
  2. When you’re QA’ing the Spec Details box will show the description, the page number, and the spec type. If the AssesUsed box is not checked the image should not be on the page, sometimes you’ll see duplicate specs but only one of them will have the AssestUsed box checked – that’s ok.
  3. The Asset Details box here you’ll see the Source File number, Rights Type and credit.
  4. At the bottom of the page, you’ll see four tabs, the Base Spec Verification tab will show the status of the spec. Descriptions of the different status’s are written out in the box to the right.

And finally, in the cheat sheet, I collected links to each of our internal SharePoint sites that are either used for tracking purposes, housing digital products, the location of the new tools, and the training site where all the lengthy process instructions are available. I listed the links and explained what can be found at each of them so new members can easily find further instruction, new assignments, and fresh copies of the tool as needed.