More actions
Tau Hopper (talk | contribs) m Cosmetic changes. |
Tau Hopper (talk | contribs) Reference to the buyback service on the AMC page updated, and minor improvements. |
||
| Line 3: | Line 3: | ||
The '''AMC Buyback Spreadsheet''' is based on the [[Scrapyard's_Mining_Op_Worksheet|EVE IVY Mining Op worksheet]] created by Scrapyard Bob. | The '''AMC Buyback Spreadsheet''' is based on the [[Scrapyard's_Mining_Op_Worksheet|EVE IVY Mining Op worksheet]] created by Scrapyard Bob. | ||
It is used to request an ore/ice/gas "Buyback" within the [[Amarr_Mining_Campus#AMC | It is used to request an ore/ice/gas "Buyback" within the [[Amarr_Mining_Campus#AMC Buyback|AMC Buyback Service]] and from an FC while [[Mining Op|running a mining op]]. | ||
==Service Infomation== | ==Service Infomation== | ||
| Line 26: | Line 26: | ||
Some brief instructions about how to prepare a personal Buyback at AMC, and how to maintain the spreadsheet during a mining op, are given below. | Some brief instructions about how to prepare a personal Buyback at AMC, and how to maintain the spreadsheet during a mining op, are given below. | ||
It's recommended to have the [[Skills:Trade#Contracting|Contracting]] skill trained up to at least Level 1 to be able to have more than one | It's recommended to have the [[Skills:Trade#Contracting|Contracting]] skill trained up to at least Level 1 to be able to have more than one outstanding contract submitted at a given time. | ||
---- | ---- | ||
| Line 36: | Line 36: | ||
# Log into your Google account. | # Log into your Google account. | ||
# Open the file menu and select "Make a Copy". | # Open the file menu and select "Make a Copy". | ||
# Name it following this convention. For Personal use: " | # Name it following this convention. For Personal use: "Your Name (DATE)" - e.g. Jefferson Spence (2014/11/18) | ||
==== Work on the spreadsheet ==== | ==== Work on the spreadsheet ==== | ||
| Line 54: | Line 54: | ||
# Log into your Google account. | # Log into your Google account. | ||
# Open the file menu and select "Make a Copy". | # Open the file menu and select "Make a Copy". | ||
# Name it following this convention. For Shared Can use: "SHARED CAN - FC-Name (DATE)" e.g. SHARED CAN - Jefferson Spence ( | # Name it following this convention. For Shared Can use: "SHARED CAN - FC-Name (DATE)" - e.g. SHARED CAN - Jefferson Spence (2014/11/18) | ||
# Go to the top right of the spreadsheet and click on the "Share" button to open sharing settings. Change it from private to "Anyone with the link can view". | # Go to the top right of the spreadsheet and click on the "Share" button to open sharing settings. Change it from private to "Anyone with the link can view". | ||
# Make sure haulers know what station you want the ore delivered to, and who to contract the ore to after the op. | # Make sure haulers know what station you want the ore delivered to, and who to contract the ore to after the op. | ||
| Line 86: | Line 86: | ||
# Change to the '''Inventory''' tab. | # Change to the '''Inventory''' tab. | ||
# Select "Finalize Buyback" in the Buyback Menu. | # Select "Finalize Buyback" in the Buyback Menu. | ||
# Share the spreadsheet (i.e. click the | # Share the spreadsheet (i.e. click the '''Share''' button in the upper right corner of the spreadsheet, then "Get shareable link"). | ||
# Create a contract to <font color="white">'''Ivy League AMC Holdings'''</font> with the applicable ore, ice and gas. | # Create a contract to <font color="white">'''Ivy League AMC Holdings'''</font> with the applicable ore, ice and gas. | ||
# Set the contract amount in the field "you will receive" to the amount shown in cell G1 of the '''Inventory''' sheet. | # Set the contract amount in the field "you will receive" to the amount shown in cell G1 of the '''Inventory''' sheet. | ||
# There is no 6. | # There is no 6. | ||
# | # Paste the spreadsheet key in the '''Description''' field of the contract: | ||
#: ( | #: (The field located between ""/d/*****/edit#"". See the image below.) | ||
#: [[File:AMC_Buyback_6.jpg|500px|thumb|none|Finding the spreadsheet key]] | #: [[File:AMC_Buyback_6.jpg|500px|thumb|none|Finding the spreadsheet key]] | ||
# Set the contract for 4 weeks expiration, then click finalize the contract. | # Set the contract for 4 weeks expiration, then click finalize the contract. | ||
| Line 100: | Line 100: | ||
* The prices were updated and no longer match between the contract and the spreadsheet. | * The prices were updated and no longer match between the contract and the spreadsheet. | ||
* The value and/or quantities do not match between the contract and the spreadsheet. | * The value and/or quantities do not match between the contract and the spreadsheet. | ||
* The contract was issued from a station more than 5 jumps away from the AMC home system without AMC Officer | * The contract was issued from a station more than 5 jumps away from the AMC home system without the approval of an AMC Officer. The only exceptions to the 5 jump rule are <font color="white">'''Dantan'''</font> and <font color="white">'''Hoona'''</font>. | ||
* The contract was not submitted from an NPC station or one of the <font color="white">'''Ivy League'''</font> structures. | * The contract was not submitted from an NPC station or one of the <font color="white">'''Ivy League'''</font> structures. | ||
* The contract was submitted in the home system from a station or structure other than <font color="white">'''Shemah - The Ore Question'''</font>. | * The contract was submitted in the home system from a station or structure other than <font color="white">'''Shemah - The Ore Question'''</font>. | ||