Toggle menu
Toggle preferences menu
Toggle personal menu
Not logged in
Your IP address will be publicly visible if you make any edits.

Archive:AMC Buyback Spreadsheet: Difference between revisions

From EVE University Wiki
No edit summary
Line 19: Line 19:
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.
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.


----
=== Filling the Spreadsheet for personal Buy Back ===
====  Prepare the spreadsheet ====
# Go to the [[#Latest Version|current version]]
# Log into your google account and go to the current version.
# Open the file menu and select "Make a Copy"
# Name it following this convention.  For Personal use: "PLAYERNAME (DATE)" e.g. Jefferson Spence (2014/03/11)
==== Work on the spreadsheet ====
: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.
:The "Icons" view in your inventory will not work for this.  You need to use the "Details" or "List" view.
:Be sure to select the Inventory tab before continuing.
==== Submit the Buy-Back ====
Follow the section [[#Submit the spreadsheet|Submit the spreadsheet]] below.
----
----


Line 56: Line 73:
# 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.
# 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 ====
# Go to the [[#Latest Version|current version]]
# Log into your google account and go to the current version.
# Open the file menu and select "Make a Copy"
# Name it following this convention.  For Personal use: "PLAYERNAME (DATE)" e.g. Jefferson Spence (2014/03/11)
==== Work on the spreadsheet ====
: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.
:The "Icons" view in your inventory will not work for this.  You need to use the "Details" or "List" view.
:Be sure to select the Inventory tab before continuing.
==== Submit the Buy-Back ====
Follow the section [[#Submit the spreadsheet|Submit the spreadsheet]] below.
----
----


Line 78: Line 78:


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 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:
# Make a copy
# Copy the contents of the Stuff you wish to contract over to the '''Paste Inventory''' tab (Make sure items are stacked).
# 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 (Click the blue button in the upper right of the spreadsheet, then click '''get shareable link'''.)
# Share the Spreadsheet (Click the blue button in the upper right of the spreadsheet, then click '''get shareable link'''.)
# There is no 6
# Create a Contract to Bruce Industries for the product
# Create a Contract to Bruce Industries for the product
# 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
# In the Description field of the contract paste the buyback link
# In the Description field of the contract paste the buyback link
#: (the field located between ""/d/*****/edit#"" Example below.)
#: (the field located between ""/d/*****/edit#"" Example below.)
Line 96: Line 94:
* Prices were updated and no longer match on contract and spreadsheet.
* Prices were updated and no longer match on contract and spreadsheet.
* Value and/or quantity does not match on contract and spreadsheet.
* Value and/or quantity does not match on contract and spreadsheet.
* Contract Station is more then 5 jumps away from the Homestation without AMC Officer approval.
* Contract Station is more then 5 jumps away from the AMC Homestation without AMC Officer approval. Exception to 5 jump rule is Dantan system
* Contract is not submitted from NPC station or one of the Ivy League structures.
* Contract is not submitted from NPC station or one of the Ivy League structures.
* Submission did not come via a Google Docs spreadsheet
* Submission did not come via a Google Docs spreadsheet