Difference between revisions of "Archive:AMC Buyback Spreadsheet"

From EVE University Wiki
Jump to: navigation, search
m (Marn Vermuldir moved page AMC Buyback Spreadsheet to Archive:AMC Buyback Spreadsheet without leaving a redirect: Moving back to archive after Buyback page was updated.)
 
(79 intermediate revisions by 16 users not shown)
Line 1: Line 1:
−
[[image:AMCtest.png|center|400px]]
+
{{historical}}
 +
[[File:AMCtest.png|center|400px]]
 
{{tocright}}
 
{{tocright}}
−
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 a personal ore and/or mineral "Buy-Back" within the [[Amarr_Mining_Campus#AMC Buy-Back|AMC Buy-Back Service]] and from an FC while [[Mining Op|running a mining op]].  
+
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 ==
 +
 
 +
This service lets you sell your ore, gas and ice directly to the campus from the AMC home system (Averon) and EVE Unversity's new infrastructure in Stacmon. The Buyback service offers a higher pay out than a new player would otherwise get without significant skills and standings, benefiting from both the higher value of the refined materials along with the prices in <font color="white">'''Jita'''</font>, where we sell them - not to mention the logistics of moving it.
 +
 
 +
The fee for this service is 4% of the refined value of the ore, ice and gas submitted, which is automatically deducted from the corresponding Jita-buy prices by the spreadsheet, so you don’t need to work it out.
  
 
The AMC Buyback has a recommended minimum of 25,000,000 ISK and a maximum of 5,000,000,000 ISK per personal Buyback contract.
 
The AMC Buyback has a recommended minimum of 25,000,000 ISK and a maximum of 5,000,000,000 ISK per personal Buyback contract.
  
−
==Latest Version==
+
Buybacks will generally be accepted within 24-48 hours. However availability of staff or other issues may delay acceptance to be slightly longer than this.
−
===ORE===
+
 
−
=====Current Version 2016-06-AMC-ORE=====
+
 
−
Updated June 2016<br>
+
<font color="red">'''IMPORTANT:''' The campus will only accept buyback contracts issued from "'''Averon - The Ore Question'''", "'''Stacmon - Furirams Furnace'''", "'''Slays - Dairek's Chateau'''" or "'''Junsoraert - Happy Bottom Riding Club'''". If you have ore outside of our home system or HQ but still within the [https://evemaps.dotlan.net/map/Everyshore/Elalan '''Elalan Constellation'''] you can use our ore hauling service to transport it to Averon - The Ore Question. Fore more information please see [https://forum.eveuniversity.org/viewtopic.php?f=233&t=120094 this thread].</font>
−
The latest version is available at:<br>
+
 
 +
== Latest Version ==
 +
 
 +
'''New Unified Buyback Sheet'''
 +
===== Current Version April 2022 (v6) =====
 +
[https://drive.google.com/open?id=1uG86UeJF8I2c2-gxZ_RhTXkzs9z-67bLnLpJpE5FcHA Buyback Spreadsheet]
 +
 
 +
== Instructions ==
  
−
[https://docs.google.com/spreadsheets/d/1MF5t-PSJkqJfCWEdM2KNo5mUddOYq1OfKT-2dmFVg_Y/edit?usp=sharing AMC Buyback Mosaic ORE]
+
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.
  
−
===ICE===
+
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.
−
=====Current Version 2014-12-AMC-ICE=====
 
−
Updated December 2014<br>
 
−
The latest version is available at:<br>
 
−
[https://docs.google.com/spreadsheets/d/1-TZbnTZ0ynHwkdNN0Vah_-6x2tptUrGVQzR_YKpfGjo/edit?usp=sharing AMC Buyback Crius ICE]
 
  
−
===GAS===
+
----
−
=====Current Version 2015-03-AMC-GAS=====
 
−
Updated March 2015<br>
 
−
The latest version is available at:<br>
 
−
[https://docs.google.com/spreadsheets/d/11BjubaQT6VfnhwLP4dcPBckE02Lt0gVg_ZrkcOdAdzA/edit?usp=sharing AMC Buyback Tiamat GAS]
 
  
−
===NOTES===
+
=== Filling the spreadsheet for personal Buyback ===
−
As with all Google Doc Spreadsheets, you can either copy it to your own personal Google Doc area or download it as a Microsoft Excel (XLS) file or in an OpenOffice.org spreadsheet file.<br />
 
−
'''We will not accept any submissions that have not come via a Google Docs spreadsheet.'''<br />
 
  
−
==Instructions==
+
==== Prepare the spreadsheet ====
−
[[File:AMC_Buyback_1.jpg|300px|thumb|right|Make a copy of the spreadsheet]]
+
# Go to the [[#Latest Version|current version]]. (Note: This link will only take you to the "Latest Version" section on the page.)
−
[[File:AMC_Buyback_2.jpg|300px|thumb|right|Name depending on Buyback usage]]
+
# Log into your Google account.
−
[[File:AMC_Buyback_Step4.PNG|300px|thumb|right|Fill amount of ore and/or mineral to column C]]
+
# Open the file menu and select "Make a Copy".
−
[[File:AMC_Buyback_Step5-UpdatePrices.png|300px|thumb|right|Select "Update Prices"]]
+
# Name it following this convention. For Personal use: "Your Name (DATE)" - e.g. Jefferson Spence (2014/11/18)
−
[[File:AMC_Buyback_Step5-Authroize.PNG|300px|thumb|right|Authroize the Buyback script to update the prices]]
 
−
[[File:AMC_Buyback_Step5-Final.png|300px|thumb|right|Check prices after clicking "Update Prices"]]
 
−
[[File:AMC_Buyback_Contract_CreateContract.png|300px|thumb|right|Create Buyback contract]]
 
−
[[File:AMC_Buyback_ContractCreateContract.png|300px|thumb|right|Select contract type and owner]]
 
−
[[File:AMC_Buyback_ContractSelectItems.png|300px|thumb|right|Select all items to add to the contract]]
 
−
[[File:AMC_Buyback_ContractSelectOptions.png|300px|thumb|right|Add Buyback value and spreadsheet key]]
 
−
[[File:AMC_Buyback_ContractReviewContract.png|300px|thumb|right|Review the contract]]
 
  
−
You'll find a brief instruction how to maintain this spreadsheet during a mining op and how you can put in a personal Buyback to the Buyback service of AMC.
+
==== Work on the spreadsheet ====
 +
# Make sure the ore/ice/gas that you'd like to submit is stacked.
 +
# On the '''Paste Inventory''' tab, select cell A4, and copy and paste these from your in-game inventory.<br />The "Icons" view in your inventory will not work for this. You need to use the "Details" or "List" view. ("Icon" is the only view that works if you have a NON-US settings in your local. Since "Details" and "List" only seem to work for them who has US as local)
  
−
It's recommended to have the skill [[Skills:Trade#Contracting|Contracting]] skilled up to Level 1 to process more than one contract at the same time.
+
<font color="red">'''IMPORTANT:''' Make sure to have default column settings and number of columns (7).</font>
  
 +
==== Submit the Buyback ====
 +
:Follow the section [[#Submit the spreadsheet|Submit the spreadsheet]] below.
 
----
 
----
  
 
=== Using the spreadsheet in a shared can mining operation ===
 
=== Using the spreadsheet in a shared can mining operation ===
  
−
While running a mining op the participation of the fleet members needs to be updated in the sheet to provide an overview to the fleet members.
+
While running a mining op the participation of the fleet members needs to be tracked in the sheet.
  
−
==== Before the operation ====
+
==== Before the operation ====
−
# Go to the [[#Latest Version|current version]]
+
# Go to the [[#Latest Version|current version]]. (Note: This link will only take you to the "Latest Version" section on the page.)
−
# Log into your google account
+
# Log into your Google account.
−
# Open the file menu and select "Make a Copy" (see image to right)
+
# 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 (27/03/2014)
+
# 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 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.
  
 
==== During the operation ====
 
==== During the operation ====
−
# Keep up with filling in the participation sheet with start and stop times for each participant.
+
# Keep up with filling in the participation sheet with the start and stop times for each participant.
−
# You must use a station within 5 jump of home and when possible try to use a station of home corporation.
 
 
# Per AMC policy everyone involved in the op should be 1.00 shared weight no matter their role unless they voluntarily agree to less.
 
# Per AMC policy everyone involved in the op should be 1.00 shared weight no matter their role unless they voluntarily agree to less.
  
 
==== After the operation ====
 
==== After the operation ====
−
# At the end of the operation have all ore contracted to the fleet command (or whoever will be submitting the buyback contract)
+
# At the end of the operation have all ore contracted to the Fleet Commander (or whoever will be submitting the buyback contract).
−
# On the Inventory or Paste Inventory tab you need to add the amount of ore you mined during the shared Can.  
+
# Make sure all the ore/ice/gas mined during the Shared Can is stacked.
−
#:On the Inventory tab add amounts of ore to to the column "Amt Mined" (column C).
+
# On the '''Paste Inventory''' tab, select cell A4, and copy and paste these from the in-game inventory.<br />The "Icons" view in your inventory will not work for this. You need to use the "Details" or "List" view.
−
#:On the Paste Inventory tab you need to stack your ores and copy and paste to cell A4.
+
# Add any additional raw ISK to the '''ExtraISK''' tab if you had sold any salvage or modules from rats, received a cash donation, or had to pay an external freighter such as Red Frog Freight.
−
#:The "Icons" view in your inventory will not work for this. You need to use the "Details" or "List" view.
+
# Double check that all the participation information is correct and make sure to thank all those who participated in the op.
−
# Add ISK values ExtraISK tab if you had sold any salvage or modules from rats, received a cash donation, or had to pay an external freighter such as Red Frog Freight.
 
−
# Double check that all the participation information is correct and be sure to thank all those who participated in the op.
 
−
 
 
−
==== Submit the Buy-Back ====
 
−
Follow the section [[#Submit the spreadsheet|Submit the spreadsheet]] below.
 
−
 
 
−
==== After Buy-Back is completed ====
 
−
# As soon as the Buy-Back is completed and paid out you need to pay the participated fleet members.
 
−
# Open your spreadsheet again and go to the participation tab.
 
−
# Start to pay out the value mentioned in "Payout (ISK)" column to the fleet members and mark the paid members in the "Paid" column.
 
−
# It is recommended to send out a EVE Mail to the fleet members as soon as you've done all after work including the payout.
 
−
 
 
−
----
 
−
 
 
−
=== Filling the Spreadsheet for personal Buy Back ===
 
  
−
==== Prepare the spreadsheet ====
+
==== Submit the Buyback ====
−
# Go to the [[#Latest Version|current version]]
+
:Follow the section [[#Submit the spreadsheet|Submit the spreadsheet]] below.
−
# Log into your google account and go to the current version.
 
−
# Open the file menu and select "Make a Copy" (see image to right)
 
−
# Name it following this convention.  For Personal use: "PLAYERNAME (DATE)" e.g. Jefferson Spence (27/03/2014)
 
  
−
==== Work on the spreadsheet ====  
+
==== After the Buyback is completed ====
−
*You can ether use the Inventory or Paste Inventory tabs.
+
# As soon as the Buyback is completed and paid out, you need to pay the fleet members.
−
:On the Inventory tab you need to add the ore and mineral numbers to "Amt Mined" (column C) you'd like to add to the Buy-Back.
+
# Open your spreadsheet again and go to the '''Participation''' tab.
−
:On the Paste Inventory tab you need to stack your ores and copy and paste to cell A4 what you'd like to add to the Buy-Back.
+
# Start to transfer the values in the "Payout (ISK)" column to the fleet members, and mark them accordingly in the "Paid?" column.
−
:The "Icons" view in your inventory will not work for this.  You need to use the "Details" or "List" view.
+
# It is recommended to send out an EVE Mail to the fleet members as soon as you've done all the after work, including the payout.
−
:Be sure to select the Inventory tab before continuing.
 
  
−
==== Submit the Buy-Back ====
 
−
Follow the section [[#Submit the spreadsheet|Submit the spreadsheet]] below.
 
 
----
 
----
  
 
=== Submit the spreadsheet ===
 
=== Submit the spreadsheet ===
  
−
Before you can submit the Buy-Back finally you need to add the current prices for the Buy-Back to the spread sheet. This is done with the following steps:
+
Before you submit the Buyback you'll need to fix the current market prices into the spreadsheet, so that they won't be updated anymore. This is done in the second step below:
−
# In the menu bar of the spread sheet you see an menu item called "Buyback" - Select it and then click "Update Prices".
+
# Change to the '''Inventory''' tab.
−
# If there is a popup asking "Authorization Required" please select "OK" and go back to the menu item "Buyback" and "Update Prices"
+
# Select "Finalize Buyback" in the Buyback Menu. (Because this step uses a script, Google docs security settings may ask you to authorize the script to run. Click the “Advanced” link on the pop up to enable the option to run the script, if this occurs).
−
# When the spreadsheet shows the message "Finished script" go back to the menu item "Buyback" and select "Prepare BuyBack"
+
#: [[File:AMC_Buyback_123.jpg|200px|thumb|none|Finalize Buyback]]
−
# To confirm the preparation was done correctly please check "Calculated ISK/unit" in column E row 4 to 11.
+
# Ensure the Buyback script has finalized prices. On the Inventory tab, the cells in Column F will contain a formula “=Market!Fx” if the Finalize Buyback script has not successfully run (as seen in the formula bar at the top when selecting a cell in column F) - run the script again. If the script has successfully completed, the formula bar will show a numeric value rather than a formula.
−
#:If there is no value please wait 5 to 10 minutes and try to "Update Prices" & "Prepare BuyBack" again.
+
#: [[File:AMC Buyback 42.jpg|1000px|thumb|none|Ensure the Buyback script has finalized prices]]
−
#:Please do not proceed until this values are not 0
+
# Share the spreadsheet (i.e. click the '''Share''' button in the upper right corner of the spreadsheet, then click "Change to anyone with the link", make sure the google doc isn't set to "restricted". Then click done).
−
# 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"
+
# Create a contract to <font color="white">'''Ivy League Buyback'''</font> with the applicable ore, ice and gas.
−
# You really expect there to be a six?
+
# There is no 6.
−
# When all above is done you need to issue the 'Private' 'Item Exchange' contract to '''Bruce Industries''' at a station that is applicable for Buy-Back service.
+
# Set the contract amount in the field "you will receive" to the amount shown in cell G1 of the '''Inventory''' sheet.
−
#:Always make sure that all ore is stacked before setting up the contract.
+
# Paste the spreadsheet key in the '''Description''' field of the contract:
−
#:If you need to issue the contract outside of the 5 jump range please contact an AMC officer before you issue the contract for approval.
+
#: (The field located between ""/d/*****/edit#"". See the image below.)
−
#:Preferred stations are stations from home corporation.
+
#: [[File:AMC_Buyback_6.jpg|500px|thumb|none|Finding the spreadsheet key]]
−
#:Set the Expiration time to the longest value (4 weeks).
+
# Set the contract for 4 weeks expiration, then click finalize the contract.
−
# Within the contract creation you need to select the ore and/or mineral you added to the spreadsheet before and add it to the contract.
+
# Wait to get paid.
−
# When you go on to the next windows you need to add the total value from the field G1 in the spreadsheet to the "I will receive" box.
 
−
# The description box on the same windows within the contract creation needs to be filled with the spreadsheet key (the part of the URL between .../d/ and /edit see image for finding the key)
 
−
#:[[File:AMC_Buyback_6.jpg|500px|thumb|none|Finding the spreadsheet key]]
 
−
# Afterwards you only need to submit the contract ingame. The ISK will be added to your wallet soon after.
 
  
−
==Reasons for your contract to be declined==
+
== Reasons for your contract to be declined ==
  
−
* Prices were updated and no longer match on contract and spreadsheet.
+
* The prices were updated and no longer match between the contract and the spreadsheet.
−
* Value and/or quantity does not match on contract and spreadsheet.
+
* The value and/or quantities do not match between the contract and the spreadsheet.
−
* Contract Station is more then 5 jumps away from the Homestation without AMC Officer approval.
+
* The contract was submitted in the AMC home system from a station or structure other than <font color="white">'''Averon - The Ore Question'''</font> or <font color="white">'''Junsoraert - Happy Bottom Riding Club'''</font>.
−
* Contract is submitted from a Citadel, Refinery or Engineering Complex not approved for buyback use.
+
* The contract was submitted outside of Averon or Stacmon/Slays without the approval of a Supply Officer.
−
* Submission did not come via a Google Docs spreadsheet
+
* The contract was not submitted from an NPC station or one of the <font color="white">'''Ivy League'''</font> structures.
 +
* The submission did not come via a Google Docs spreadsheet.
 +
* The buyback contains minerals (Spreadsheet does not support minerals).
 +
* The buyback contains Triglavian Ore (Spreadsheet currently does not support triglavian ores).
  
−
==AMC Buyback Best Practices==
+
== AMC Buyback Best Practices ==
−
The best practices keep the Buyback volunteers happy and keep your payback waiting time to a minimum:
+
The following best practices keep the Buyback volunteers happy and keep your payback waiting time to a minimum:
  
−
* The AMC Buy-Back has a recommended minimum of 25.000.000 ISK and a maximum of 5.000.000.000 ISK per personal Buy-Back contract.
+
* The AMC Buyback has a recommended minimum of 25,000,000 ISK and a maximum of 5,000,000,000 ISK per personal Buyback contract.
−
* Make sure that when you submit your buyback form that the key from your spreadsheet is included in the contract description
+
* When you submit your buyback contract, make sure that the key from your spreadsheet is included in the contract description.
 
* Only one personal contract per person, per system, per day.
 
* Only one personal contract per person, per system, per day.
−
* If refining yourself, do not add the extra unrefined ore to the contract, minerals only please
+
* Do not create a contract for ore/ice/gas inside a container.
−
* Do not create a contract for ore/minerals inside of a container
+
* If possible, please compress the ore and ice in advance to make it easier for our hauling operations.
 
{{Mining Links}}
 
{{Mining Links}}
  
 
[[Category:AMC]]
 
[[Category:AMC]]
 
[[Category:Applications]]
 
[[Category:Applications]]

Latest revision as of 20:31, 7 June 2022

E-UNI Emblem.png This page's intent is to provide information on the the history of EVE University. The information on this page is no longer current.
AMCtest.png

The AMC Buyback Spreadsheet is based on the EVE IVY Mining Op worksheet created by Scrapyard Bob.

It is used to request an ore/ice/gas "Buyback" within the AMC Buyback Service and from an FC while running a mining op.

Service Infomation

This service lets you sell your ore, gas and ice directly to the campus from the AMC home system (Averon) and EVE Unversity's new infrastructure in Stacmon. The Buyback service offers a higher pay out than a new player would otherwise get without significant skills and standings, benefiting from both the higher value of the refined materials along with the prices in Jita, where we sell them - not to mention the logistics of moving it.

The fee for this service is 4% of the refined value of the ore, ice and gas submitted, which is automatically deducted from the corresponding Jita-buy prices by the spreadsheet, so you don’t need to work it out.

The AMC Buyback has a recommended minimum of 25,000,000 ISK and a maximum of 5,000,000,000 ISK per personal Buyback contract.

Buybacks will generally be accepted within 24-48 hours. However availability of staff or other issues may delay acceptance to be slightly longer than this.


IMPORTANT: The campus will only accept buyback contracts issued from "Averon - The Ore Question", "Stacmon - Furirams Furnace", "Slays - Dairek's Chateau" or "Junsoraert - Happy Bottom Riding Club". If you have ore outside of our home system or HQ but still within the Elalan Constellation you can use our ore hauling service to transport it to Averon - The Ore Question. Fore more information please see this thread.

Latest Version

New Unified Buyback Sheet

Current Version April 2022 (v6)

Buyback Spreadsheet

Instructions

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 Contracting skill trained up to at least Level 1 to be able to have more than one outstanding contract submitted at a given time.

Filling the spreadsheet for personal Buyback

Prepare the spreadsheet

  1. Go to the current version. (Note: This link will only take you to the "Latest Version" section on the page.)
  2. Log into your Google account.
  3. Open the file menu and select "Make a Copy".
  4. Name it following this convention. For Personal use: "Your Name (DATE)" - e.g. Jefferson Spence (2014/11/18)

Work on the spreadsheet

  1. Make sure the ore/ice/gas that you'd like to submit is stacked.
  2. On the Paste Inventory tab, select cell A4, and copy and paste these from your in-game inventory.
    The "Icons" view in your inventory will not work for this. You need to use the "Details" or "List" view. ("Icon" is the only view that works if you have a NON-US settings in your local. Since "Details" and "List" only seem to work for them who has US as local)

IMPORTANT: Make sure to have default column settings and number of columns (7).

Submit the Buyback

Follow the section Submit the spreadsheet below.

Using the spreadsheet in a shared can mining operation

While running a mining op the participation of the fleet members needs to be tracked in the sheet.

Before the operation

  1. Go to the current version. (Note: This link will only take you to the "Latest Version" section on the page.)
  2. Log into your Google account.
  3. Open the file menu and select "Make a Copy".
  4. Name it following this convention. For Shared Can use: "SHARED CAN - FC-Name (DATE)" - e.g. SHARED CAN - Jefferson Spence (2014/11/18)
  5. 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".
  6. Make sure haulers know what station you want the ore delivered to, and who to contract the ore to after the op.

During the operation

  1. Keep up with filling in the participation sheet with the start and stop times for each participant.
  2. Per AMC policy everyone involved in the op should be 1.00 shared weight no matter their role unless they voluntarily agree to less.

After the operation

  1. At the end of the operation have all ore contracted to the Fleet Commander (or whoever will be submitting the buyback contract).
  2. Make sure all the ore/ice/gas mined during the Shared Can is stacked.
  3. On the Paste Inventory tab, select cell A4, and copy and paste these from the in-game inventory.
    The "Icons" view in your inventory will not work for this. You need to use the "Details" or "List" view.
  4. Add any additional raw ISK to the ExtraISK tab if you had sold any salvage or modules from rats, received a cash donation, or had to pay an external freighter such as Red Frog Freight.
  5. Double check that all the participation information is correct and make sure to thank all those who participated in the op.

Submit the Buyback

Follow the section Submit the spreadsheet below.

After the Buyback is completed

  1. As soon as the Buyback is completed and paid out, you need to pay the fleet members.
  2. Open your spreadsheet again and go to the Participation tab.
  3. Start to transfer the values in the "Payout (ISK)" column to the fleet members, and mark them accordingly in the "Paid?" column.
  4. It is recommended to send out an EVE Mail to the fleet members as soon as you've done all the after work, including the payout.

Submit the spreadsheet

Before you submit the Buyback you'll need to fix the current market prices into the spreadsheet, so that they won't be updated anymore. This is done in the second step below:

  1. Change to the Inventory tab.
  2. Select "Finalize Buyback" in the Buyback Menu. (Because this step uses a script, Google docs security settings may ask you to authorize the script to run. Click the “Advanced” link on the pop up to enable the option to run the script, if this occurs).
    Finalize Buyback
  3. Ensure the Buyback script has finalized prices. On the Inventory tab, the cells in Column F will contain a formula “=Market!Fx” if the Finalize Buyback script has not successfully run (as seen in the formula bar at the top when selecting a cell in column F) - run the script again. If the script has successfully completed, the formula bar will show a numeric value rather than a formula.
    Ensure the Buyback script has finalized prices
  4. Share the spreadsheet (i.e. click the Share button in the upper right corner of the spreadsheet, then click "Change to anyone with the link", make sure the google doc isn't set to "restricted". Then click done).
  5. Create a contract to Ivy League Buyback with the applicable ore, ice and gas.
  6. There is no 6.
  7. Set the contract amount in the field "you will receive" to the amount shown in cell G1 of the Inventory sheet.
  8. Paste the spreadsheet key in the Description field of the contract:
    (The field located between ""/d/*****/edit#"". See the image below.)
    Finding the spreadsheet key
  9. Set the contract for 4 weeks expiration, then click finalize the contract.
  10. Wait to get paid.

Reasons for your contract to be declined

  • 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 contract was submitted in the AMC home system from a station or structure other than Averon - The Ore Question or Junsoraert - Happy Bottom Riding Club.
  • The contract was submitted outside of Averon or Stacmon/Slays without the approval of a Supply Officer.
  • The contract was not submitted from an NPC station or one of the Ivy League structures.
  • The submission did not come via a Google Docs spreadsheet.
  • The buyback contains minerals (Spreadsheet does not support minerals).
  • The buyback contains Triglavian Ore (Spreadsheet currently does not support triglavian ores).

AMC Buyback Best Practices

The following best practices keep the Buyback volunteers happy and keep your payback waiting time to a minimum:

  • The AMC Buyback has a recommended minimum of 25,000,000 ISK and a maximum of 5,000,000,000 ISK per personal Buyback contract.
  • When you submit your buyback contract, make sure that the key from your spreadsheet is included in the contract description.
  • Only one personal contract per person, per system, per day.
  • Do not create a contract for ore/ice/gas inside a container.
  • If possible, please compress the ore and ice in advance to make it easier for our hauling operations.
v · t · e
Mining
Resource harvesting
Ship comparison
Concepts
Retrieved from "https://wiki.eveuniversity.org/index.php?title=Archive:AMC_Buyback_Spreadsheet&oldid=187806"