https://docs.google.com/spreadsheets/d/1-rvzhV-xdHiqkq3DDJP0-0KIdRCvdrx-2Vas0A1dCPw/edit?usp=sharing

UPDATE: FOUND SOME PROBLEMS REGARDING DELETING QUESTS AND USING CUT AND PASTE FOR THE VALUES.

UPDATE2: Found a solution to the problem. See how-to section for details.

I've been working on this for the past week and I feel like it should be done and post-worthy now. Originally, I was just gonna post it on r/mhguildquests but since I added some features other people might find useful, I'm posting it here too. Sample: https://docs.google.com/spreadsheets/d/1nBuzS9HvLH00A-l7qu4s6uqX3wn1I-BhCRLrLij68GU/pubhtml

Features:

• Drop-down menu for all the needed inputs (except for sets you're collecting)

• Automatic filling in of all the relic skin related fields

• Automatic display of the average number of "Beshackled Weapons" and "Beshackled Armor" the quest gives per completion at Level 136

• Automatic marking of guild quests that can potentially be a part of sets you're collecting

• Automatic listing of guild quests that are parts of sets you're collecting in Sheet 2: "Set Listing"

How-to's:

Getting Started

1. Log into your Google account and make a copy of the template. (File > Make a Copy)
2. Input the details of the GQs found in your game (If the gq is part of a set you're collecting, use the armor piece input with an asterisk *)
3. Scroll to the right and enter the name of the sets you're collecting (Must be in proper capitalization e.g. Gloaming/Adamance, Arc/Storge, Kirin U, etc.)

Deleting Quests

1. Highlight all the input (All columns starting from "Left Monster" to "Weapon")
2. Press your "Backspace" key
3. Highlight all the input of all the rows after the deleted quest (All columns starting from "Left Monster" to "Weapon")
4. Press CTRL X
5. Right-click the "Left Monster" cell of the row of the quest you deleted and select Paste Special -> Paste values only
6. Move existing remarks one step up

I'll be figuring out easier solutions for this but I'm not sure if I can release it soon. So sorry

Fixing Broken Formulas

1. Copy the cell 1 row above the broken cell's.
2. Right-click the broken cell and select Paste Special -> Paste formula only
3. Repeat for other broken cells

Limitations:

• Subspecies names are not supported due to the nature of Vuze's original relic models spreadsheet. Instead it is inputted as (monster) sub. (e.g. Stygian Zinogre -> Zinogre sub)

• It cannot determine whether or not it's an impossible guild quest. (It does not however list the average relic rates if it's impossible e.g. Double Teostra) The following monsters cannot be found in double monster hunts: Chameleos, Gore Magala, Kushala Daora, Shagaru Magala, and Teostra

• It cannot automatically list quests in "Set Listing" if it gives more than one armor skin

• The automatic formulas cannot work in the opposite way (You can't enter the skins and get the corresponding monster and biases)

• It only has enough space for one character's guild quests. You'd have to make another copy if you have more than one character with guild quests.

Reminders:

• To remove the frozen columns/rows go to File > Freeze and set to "No Rows" and/or "No Columns"

• It's safe to add a row under the "Wanted" tag but not anywhere else. When there is a prompt saying that you shouldn't be editing that part, don't edit that part. (aside from adding a row under "Wanted")

Credits to Vuze, believingunbeliever, soma2035, Aule (of MH IRC), and McL

Sources:

• /u/MHVuze 's MH4U: Relic Models: https://docs.google.com/spreadsheets/d/1-oyh86FG6V4-T5zegGIZuX0b-_tyy7_TIe8Wv8jkfZE/edit?usp=sharing

• /u/believingunbeliever 's Weapon Skin Table Image: http://i.imgur.com/FEXl0TD.png

• soma2035's Expeditions, Guild Quests, and Relics FAQ: http://www.gamefaqs.com/boards/762804-monster-hunter-4-ultimate/71733152

• Special thanks to Aule (of MH IRC) for helping me with some formulas and /u/McLown for giving me information regarding treasure room relic rates

I hope you guys find it useful :) I'm open for suggestions but since school's starting soon, I might not be able to add the feature as soon as you'd like.